True cost of new upgrades

Is there any mechanism for uploading an Excel file?  I have a spreadsheet set up where you enter your current hangar (bots and levels, weapons and levels, whether each bot/weapon is old economy or new) and where you want the hangar to end up (level of each bot and weapon).  It calculates an upgrade cost (silver and time) for each item.  You can indicate that you want to speed up any upgrade that takes longer than X hours and it will calculate the new upgrade times as well as how much Au you need to spend to do it.  Au spend captures latest and greatest from Pix with different rates for different upgrade times.




Green boxes are entered by user.

en.wikipedia.org/wiki/Price_discrimination

Pixonic has several levels.

1: if you want to be first, you pay to be first. through the black market.
2: if you dont like random, pay the asking price.
3: if you feel thats a stupid waste of money, you can BARGAIN with them and wait for them to lower the price
4: if you feel the bargain priceis still too high, you can buy component deals(whether thru in free in game currency or paid for in game currency) and get the lowest possible price in the near to mid term.
5: if none of that is acceptable, you can avail it when its sticker price has been permanently reduced... IE the DOC, JESSE, and even the THUNDER (used to be gold if memory serves)

I dont really see how this is a bad thing. pixonic always offers stuff up for discount. my problem with pixonic stems not from their pricing system, which in my eyes is bloody genius, but from the moronic design of their robots. I mean, seriously, your ultimate robot, the spectre, has a special ability which is "abuse game mechanics by removing auto targeting of your bot and letting it jump,in a game where there is no such thing as vertical manual targeting'

Really the new pricing system is just saying : 'if you want to have a level 12 entitlement bot and play in champion league', you need to pay us.

there is nothing stopping you from grinding this bot to level 8 and enjoying it all the way up to expert or even masters. I got into champion with level 10 NON DASH mechs.

Please let me know when this comes online, it's miles ahead in terms of automation compared to my own sheet.

I think pixonics original intent was “some spectres , followed by some other bots” In game. However due to the insane power differential, it became “worthwhile to just simply run all

For sure.   But... if you look at that graph,   The most expensive upgrade relative to the rest is lvl 8 to 9.     Look how it just skyrockets after 7 and that doesn't include inspirace 's adjustment cost which makes it even steeper.    Sneaky pix.   They know lvl 9 is where a lot of us will stop and now it costs even more.

Ok. I created a DropBox link for the Excel file: <link removed pending update later tonight>

Comments:

a) THere is an "Instructions" tab providing general information on how to manipulate the "Hangar Upgrade" tab.
b) On the Hangar tab, use the drop down menus to select bots and weapons, whether each follows the new economy or the old economy, what the current levels are including Mark 1/2, and the desired final level. Be aware that there is data verification in the green cells. You can also type stuff in instead of using the drop downs but case matters right now for matching the bot/weapon with the data tables on the other tabs.
c) Only alter the cells highlighted in green.
d) Cell I1 on the Hangar tab is where you enter a value if you wish to speed up an upgrade. I have it set at 48 hours right now. That means if an upgrade would normally take 48 hours, the spreadsheet will spend Au for each and every >48 hour upgrade instead.
e) The data tables are in the "Old Econ" and "New Econ" tabs. You can add new weapons/bots as time goes on by appending the list. Be sure to use the formats as already provided.
f) THe "Menu Names" tab contains the names of each weapon/bot. You will also have to add the new weapons/bots here as well as fill in the data tables mentioned in e) when adding something new.

Known issues:
1) Case sensitive matching of weapons/bots and old/new econ right now. I will fix this later on.
2) Shredder and Pulsar are not added yet.
3) WHen upgrading a weapon that starts off at some level other than 1, there will be an issue when MK2ing it as I don't have some of the upgrade costs/times. For example, an Orkan starts at level 5. When MK2ing it, the cost and time for MK2/L1, MK2/L2, MK2/L3, MK2/L4, and MK2/L5 will be zero since I just don't have the data.
4) Not a known issue per se, but I pulled data from the Wiki and warrobots.net. I think everything was transcribed correctly but I didn't go back and double check all the costs vs. the source data.

Please provide feedback on any errors/improvements you find/can think of. If this can be made robust enough, I'll see if the mods can create a sticky where the file will reside. I'll see about making a GoogleDoc at some point, but I don't know if all the functions will port over.

I do feel bad about not finishing the charts for Medium and Heavy Weapons.  I just lost the will to continue the more I looked at the new economy numbers.

That said, there are a few things that are slightly cheaper in the new economy.  

To level to Mk1 level 12:

• Aphids & Gekkos went from 38,150,000 to 31,700,000 Ag, and from 10 days to 8 days 8 hours;
• Punisher Ts & Molot Ts went from 48,005,000 to 31,970,000 Ag, and from 12 days 21 hours 23 minutes to 8 days 13 hours 35 minutes;
• The Ballista is cheaper, but no one cares; 
• The Doc, Rogatka, & Galahad went from 64,350,000 to 63,940,000 Ag, and from 17 days 13 hours 20 minutes to 17 days 3 hours 22 minutes; and
• The Kang Dae, Nashorn, Thunder, & Zenit now take 12 minutes less to upgrade.
  

I've liked your post, but now that I've been using the sheet for more than 1 hour, I realize is not enough. Big big kudos and possibly this needs its own stickied thread.

See below image if damage could be implemented