omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Jul 16, 2017 10:05:03 GMT -5
![]() All weapons are done and I believe all my calculations are correct with the knowledge that I have. The weapons are in order of highest DPM to lowest. Here is the charts, one with all the weapons and then a seperate chart for each hardpoint type. All charts assume level 12 weapons at 100% accuracy firing: Weapons by DPM  Weapons by DPM utilizing graph options.  Weapons by DP10  Weapons by DP20  Weapons by DP30  Light Weapons  Medium Weapons  Heavy Weapons     |
|
|
|
Post by Russel on Jul 16, 2017 15:27:51 GMT -5
What's that?
The axis.
I presume the damage over time, but then it's wrong for Molots\Punishers due to accelerated state not taken into account, and Taran is shooting small bursts.
And it's strange curved fluctuation on Thunder. And it's going _down_ a bit?
p.s. overall - a GREAT job!
|
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Jul 17, 2017 11:08:18 GMT -5
There is a new image for clarity. After I've finished a bit more I plan on letting you guys access the data. You are right about the punisher and molot, i'll get that fixed for sure.
I have the damage based in seconds I think that accounts for the fluctuations, I also base the damage off the firing rate and the damage per shot to calculate the DPS while firing.
The thunders looks like it is going down because I had it on smooth line chart instead of just line chart.
|
|
|
|
Post by HoneyNutCheerios on Jul 18, 2017 10:24:00 GMT -5
Too many colors, it's confusing. For readability, add more steps (specificity) on the Y-axis and use multiple line styles such as dashes, dots, double lines, etc. Graph styling options are kind of limited within excel so let me know if you need help towards the end just to touch-up the graphs.  |
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Jul 26, 2017 17:46:29 GMT -5
Too many colors, it's confusing. For readability, add more steps (specificity) on the Y-axis and use multiple line styles such as dashes, dots, double lines, etc. Graph styling options are kind of limited within excel so let me know if you need help towards the end just to touch-up the graphs. Lol. I messed around with the options on google sheets and didn't really think any of the line changes or color changes improved readability. So I decided to include charts that were separated by hardpoint type. hopefully this helps. |
|
|
|
Post by HoneyNutCheerios on Jul 27, 2017 1:30:34 GMT -5
Lol. I messed around with the options on google sheets and didn't really think any of the line changes or color changes improved readability. So I decided to include charts that were separated by hardpoint type. hopefully this helps. Much better. Easy to read. |
|
thes1darstard
Destrier
Posts: 66
Karma: 48
Pilot name: Darstard
Platform: iOS
League: Expert
Server Region: North America
|
Post by thes1darstard on Jul 27, 2017 22:43:18 GMT -5
A few details I'd like to understand - what level weapons are these? What is the distance assumption for the Thunder, Molots and Punishers - or is distance assumed to be 0 for all weapons? Firing strategy seems to be fire immediately on bot drop and to fire continuously for 1 min - is that correct? Would it be possible to factor in a pause for reloads on things like the missiles and Trebuchets? PS - great job - thank you for putting this together!!!!  |
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Jul 28, 2017 10:12:18 GMT -5
A few details I'd like to understand - what level weapons are these? What is the distance assumption for the Thunder, Molots and Punishers - or is distance assumed to be 0 for all weapons? Firing strategy seems to be fire immediately on bot drop and to fire continuously for 1 min - is that correct? Would it be possible to factor in a pause for reloads on things like the missiles and Trebuchets? PS - great job - thank you for putting this together!!!! This chart is all level 12 weapons at 100% accuracy firing for 1 minute. I'll update my post. The Treb is firing at maximum charge(1 shot every 23 seconds), I don't know enough about the Treb to really figure anything else out. Rockets should do the same amount of damage even if you pause and reload as long as you fire the maximum number of Rockets you can in the minute provided. Missle and Treb reload time is factored in? Reload time for all weapons is factored in. As far as the future of this I was going to work either on a loadout calculator or a range/accuracy calculator. |
|
|
|
Post by TheWWRNerdGuy on Aug 1, 2017 13:34:24 GMT -5
Put a key in so that we know which weapon is which.
|
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Aug 1, 2017 15:05:22 GMT -5
Put a key in so that we know which weapon is which. There is a legend on the right side that shows which weapons are which by color. What do you recommend? |
|
|
|
Post by Russel on Aug 1, 2017 17:48:19 GMT -5
Put a key in so that we know which weapon is which. There is a legend on the right side that shows which weapons are which by color. What do you recommend? You can put actually a "key" in a Excel (most probably in Numbers or Google sheets, too) - kind of a symbol on a line. One could be dotted, other with triangles, another with gaps, etc |
|
|
|
Post by Joopiter on Aug 1, 2017 17:55:45 GMT -5
This is realllllly helpful! Thank you.
And damn I figured the punisher mk2's were much better after 2.9.2 but they are brutal...
|
|
|
|
Post by Golden Sabre on Aug 1, 2017 18:59:40 GMT -5
Hats off to you omni, thank you for putting in the effort  |
|
|
|
Post by TheWWRNerdGuy on Aug 2, 2017 2:52:54 GMT -5
![]() All weapons are done. |
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Aug 2, 2017 10:11:15 GMT -5
There is a legend on the right side that shows which weapons are which by color. What do you recommend? You can put actually a "key" in a Excel (most probably in Numbers or Google sheets, too) - kind of a symbol on a line. One could be dotted, other with triangles, another with gaps, etc I tried that but it didn't really improve readability to me. I can definitely make up some graphs to show the changes so the forum can see how it looks. I added a chart to the main post. The graph options in google sheets are pretty limited for some reason. I didn't see a way to add dashed lines. Let me know what you think! |
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Aug 2, 2017 10:16:09 GMT -5
![]() All weapons are done. I can do Zenit and Norricum.... but these weapons, norricum in particular, aren't accurate by design so the numbers would be even more deceiving than other weapons that suffer due to accuracy. Ecu and Ancile are not weapons so wouldn't fit on this list. |
|
|
|
Post by Fredrick on Aug 2, 2017 13:02:50 GMT -5
Great work!
Could I make a suggestion?
Make the the last three bar charts color coordinated with their respective hardpoint (light Medium Heavy). It would make it easier for sorting and comparing hard point types i.e. light vs. light etc.
Again, superb work!
|
|
omni
Destrier
I made a War Robots Calculator! https://docs.google.com/spreadsheets/d/1cl4zAXMgBbH6U2h7sYn2g8z3wLqV
Posts: 26
Karma: 50
Pilot name: Omni
Platform: Android
Clan: Suicide Squad[$ $]
League: Expert
Server Region: North America
Favorite robot: Rhino
|
Post by omni on Aug 15, 2017 12:25:13 GMT -5
|
|
|
|
Post by krebby on Aug 24, 2017 8:38:27 GMT -5
I love what you've done!
One slight visual recommendation. I would set the vertical axis to cross the horizontal axis on the right side of the graph instead of the left. That would make it easier for the reader to see how much damage the weapon deals at the end of 60 seconds. Right now you have to track the 60-second-end point from the far right of the graph to the far left.
|
|
|
|
Post by DarkVagabond on Aug 24, 2017 10:31:57 GMT -5
I love what you've done! One slight visual recommendation. I would set the vertical axis to cross the horizontal axis on the right side of the graph instead of the left. That would make it easier for the reader to see how much damage the weapon deals at the end of 60 seconds. Right now you have to track the 60-second-end point from the far right of the graph to the far left. Either that or just put the pertinent figures on both vertical axes for ease of reference at both ends. |
|
