Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 16, 2017 14:47:09 GMT -5
|
|
DirtyDuckofDoom
Destrier
Who needs Anciles when you've got Orkans??
Posts: 84
Karma: 55
Pilot name: DirtyDuckofDoom
Platform: Android
Clan: CENTAURS OF GOD
League: Expert
Server Region: North America
Favorite robot: Rogatka
|
Post by DirtyDuckofDoom on May 16, 2017 17:35:09 GMT -5
|
|
Deleted
Deleted Member
Posts: 0
Karma:
|
Post by Deleted on May 16, 2017 17:50:58 GMT -5
Me, Sworddbz, and others are working on one. To be released in one month or less.
|
|
|
Post by FlashAhAhh on May 16, 2017 17:56:38 GMT -5
Building one as we speak! should be done in a day or two.
|
|
Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 17, 2017 9:33:05 GMT -5
You guys are my heroes. You get, like, 500 points. Really looking forward to seeing it!
Thanks in advance for the hard work!
|
|
Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 17, 2017 9:37:57 GMT -5
Either you don't understand what a spreadsheet is or I am missing something. I am aware that the information is all available on the website (and actually, why not link to the wiki instead?) but the problem is that it is broken up and not in one easy to reference location. I believe this was just a pretty lame attempt at smart assery but don't worry - one day you'll get there. I believe in you! ;D
|
|
|
Post by Scuzzbopper on May 17, 2017 11:13:06 GMT -5
I use Google Sheets to keep track of where all the bots and weapons that I want to upgrade are at. I also have a priority number so I know what I am suppose to upgrade in what order based on how my current hanger is working. I tend to switch some of the load-outs on Griffs and Leos so nothing is set in stone.
|
|
|
Post by Fanghorn on May 17, 2017 11:24:59 GMT -5
This is what I use....I have the bots and weapons that I own, what level they are currently at and the upgrade times for the next level. Attachment Deleted
|
|
Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 17, 2017 11:43:16 GMT -5
This is what I use....I have the bots and weapons that I own, what level they are currently at and the upgrade times for the next level. Man, you guys are such beautiful nerds! Love what you've done here Fang - nice work!
|
|
DirtyDuckofDoom
Destrier
Who needs Anciles when you've got Orkans??
Posts: 84
Karma: 55
Pilot name: DirtyDuckofDoom
Platform: Android
Clan: CENTAURS OF GOD
League: Expert
Server Region: North America
Favorite robot: Rogatka
|
Post by DirtyDuckofDoom on May 17, 2017 18:20:43 GMT -5
Either you don't understand what a spreadsheet is or I am missing something. I am aware that the information is all available on the website (and actually, why not link to the wiki instead?) but the problem is that it is broken up and not in one easy to reference location. I believe this was just a pretty lame attempt at smart assery but don't worry - one day you'll get there. I believe in you! ;D Lol no smart-assery. Just failing to understand the purpose of a speardsheet.
|
|
|
Post by FlashAhAhh on May 17, 2017 19:24:53 GMT -5
Here's where I am up to. Ignore the incorrect time on the ROG upgrades.. just playing and haven't put all the data in yet. Just getting it working. All comments are appreciated, the more you tell me what would be useful, the better it will be. Don't by shy, I have thick skin. Features: - Enter target upgrade times, any upgrade that completes within that window will show as green - Automatic calculation of Cost and time to reach goal level for each indivdual component as well as cost and time to reach the next step - Displays Health, Speed, Shield, Damage per minute and damage per cycle for both the current level and goal level for that bot - displays total cost of ALL planned upgrades across your hangar as well as total time. - User only has to input Bot / weapons, current level and planned level. Everything else is automatic. Edit: The final version will allow for 20 bots in total to be added, they will all sit on the one page, the top pane that is (currently) blue doesn't move when you scroll down to other bots and I will also be adding an option to select up to 5 bots that are "Active" in your hangar and will be provided both current and target Health, Shield, Speed, DPC, DPM for your active hangar
|
|
|
Post by FlashAhAhh on May 18, 2017 0:04:10 GMT -5
Still ticking along. Happy to hear peoples thoughts The earlier you give me ideas the easier it is too add them in!
|
|
|
Post by sharpmango on May 18, 2017 7:35:36 GMT -5
Still ticking along. Happy to hear peoples thoughts The earlier you give me ideas the easier it is too add them in! Really good stuff Flash - I see you have target upgrade times - that's really good. Will the sheet be able to tell us what time any upgrade will finish? E.g. That way I might plan out 4-5 upgrades in advance knowing that I can time them for when I can log in. E.g 2pm 19/5, 9pm 20/5, 10pm 21/5 etc etc.
|
|
|
Post by FlashAhAhh on May 18, 2017 7:45:50 GMT -5
Still ticking along. Happy to hear peoples thoughts The earlier you give me ideas the easier it is too add them in! Really good stuff Flash - I see you have target upgrade times - that's really good. Will the sheet be able to tell us what time any upgrade will finish? E.g. That way I might plan out 4-5 upgrades in advance knowing that I can time them for when I can log in. E.g 2pm 19/5, 9pm 20/5, 10pm 21/5 etc etc. oooh nice idea... Will give that some though... the problem is that it will only be accurate if you start the upgrade straight away..... hmmmmm... Will ponder! Thanks
|
|
|
Post by Fanghorn on May 18, 2017 7:59:49 GMT -5
The other issue will be silver. When you run out like I do, even if you want to start an upgrade but don't have the silver yet, it will throw off the plan. Good stuff though.
|
|
|
Post by FlashAhAhh on May 18, 2017 8:03:34 GMT -5
The other issue will be silver. When you run out like I do, even if you want to start an upgrade but don't have the silver yet, it will throw off the plan. Good stuff though. That's actually the main reason I built this, to best use all my silver in the bank from the event... I know it won't last so want to plan it out really carefully. It gives you the Silver cost of - All planned upgrades for each bot, also broken down into each component - The cost of the next upgrade step for each component as well as a total for each bot - The cost of ALL planned upgrades for each bot So it actually allows you to totally plan out every upgrade you want to do and you will know total cost
|
|
Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 18, 2017 11:35:09 GMT -5
Really good stuff Flash - I see you have target upgrade times - that's really good. Will the sheet be able to tell us what time any upgrade will finish? E.g. That way I might plan out 4-5 upgrades in advance knowing that I can time them for when I can log in. E.g 2pm 19/5, 9pm 20/5, 10pm 21/5 etc etc. oooh nice idea... Will give that some though... the problem is that it will only be accurate if you start the upgrade straight away..... hmmmmm... Will ponder! Thanks I built a crude version that build in this kind of functionality and yes, when you don't immediately upgrade the next it becomes outdated. I just took those projections as estimates. I eventually included a "upgrade start" and "time remaining" (in case I failed to update my spreadsheet on the go) to have it sync up with reality. Here is a peek at what I'm currently limping along with for Upgrades as well as WP/Au planning:
|
|
|
Post by FlashAhAhh on May 22, 2017 20:05:06 GMT -5
Still ticking along. Happy to hear peoples thoughts The earlier you give me ideas the easier it is too add them in! Really good stuff Flash - I see you have target upgrade times - that's really good. Will the sheet be able to tell us what time any upgrade will finish? E.g. That way I might plan out 4-5 upgrades in advance knowing that I can time them for when I can log in. E.g 2pm 19/5, 9pm 20/5, 10pm 21/5 etc etc. Had some time to play this morning and this is actually easy peasy. You will be able to Sync it with War Robots by just entering the remaining time on your War Robots upgrade : All the maths is done.. just have to connect it all up when I get a chance!
|
|
|
Post by BastionOW on May 22, 2017 21:42:55 GMT -5
|
|
|
Post by FlashAhAhh on May 23, 2017 2:47:49 GMT -5
....? The Wiki has a spreadsheet for planning upgrades? I'm pretty sure it doesn't!
|
|
Red:Fox
Destrier
Posts: 42
Karma: 29
Pilot name: RedFoxJI
Platform: Android
Clan: [MWM] Midwest Mercenary
League: Expert
Server Region: North America
Favorite robot: Doc or Lance
|
Post by Red:Fox on May 23, 2017 11:09:47 GMT -5
?_?
Seriously, people don't understand what a spreadsheet is or read the previous posts. Yes, the wiki has lots of tables with the relevant data but that is a far cry from a good spreadsheet with some functionality built in.
|
|