|
|
Post by KomodoPie on May 14, 2019 9:53:24 GMT -5
========================================== NEW FEATURES! (May 19, 2019)- Damage vs time plot NEW FEATURES! (May 14, 2019)- Built-in weapons (for Mercury, Ao Jun, etc.) - Choice of target bot size (which impacts weapons with bullet spread; data based on tests by KomodoPie and frunobulax ) - Corrected Avenger rate of fire ========================================== Ever wanted to compare how much damage weapons or whole builds can do at a given distance over a given period of time, without having to buy and upgrade them to find out? Well, you can, with the War Robots Weapon Damage Spreadsheet! The heart of the spreadsheet is the user-friendly Build Comparison Tool, which lets you select weapons for up to 5 builds from drop-down menus and automatically shows you two graphs: one comparing their damage vs distance (from 50 to 1100 m) for whatever time period you specify (from 1 to 30 sec), and the other comparing their damage vs time for whatever distance you specify. Weapon levels and target bot size are user-selectable. Built-in weapons for Mercury, Ao Jun, etc. are now included. The subsequent sheets contain the underlying data: tables of every current weapon's cumulative damage over time for various distances to target, based on the specs on the War Robots wiki. I don't know where those specs come from. You can download the spreadsheet from my Dropbox here (current version is 5.0i): www.dropbox.com/s/k7u3b498lzxry0j/War Robots%20Weapon%20Damage%20v5p0i.xlsx?dl=1 The damage calculation accounts for: - Damage per shot, rate of fire, clip size, and reload mechanics - Bullet spread (target size is accounted for based on tests with Gust, Thunder, Punisher, Avenger, Halo, Viper, and Molot) - Spark/Scourge/Calamity damage decline with distance - Corrosion damage over time (with a setting to choose whether to count it when the shots hit or when the target actually suffers) - Weapon level (which you can choose) This tool has been very useful to me in deciding which weapons to invest in, and in thinking about builds, and I hope you'll find it helpful too! P.S. Please let me know if you find any errors. |
|
|
|
Post by fizbanrapper on May 14, 2019 10:09:49 GMT -5
|
|
|
|
Post by KomodoPie on May 14, 2019 10:21:17 GMT -5
Ha! I did not know that! I'll change it now, thanks! |
|
|
|
Post by Dragoni2 on May 14, 2019 10:44:14 GMT -5
Nice!! I use this regularly. My rayker now shows the top DPS!
|
|
|
|
Post by KomodoPie on May 14, 2019 16:37:36 GMT -5
Just fixed an error whereby there were no dropdown menus for the weapon type in builds B, C, and D.
|
|
|
|
Post by Joopiter on May 14, 2019 17:00:03 GMT -5
Thanks for all the hard work!!! 
|
|
|
|
Post by integeritis on May 14, 2019 18:34:49 GMT -5
Awesome tool, thank you guys!
I spent hours playing with the previous one. Fun!
|
|
|
|
Post by KomodoPie on May 15, 2019 16:27:15 GMT -5
This = my usual trick of posting to get this thread back to the top of the recent list so more people see it before it's forever lost in the mists of time.
|
|
|
|
Post by Joopiter on May 16, 2019 13:24:10 GMT -5
Sorry, I gotta bump this just in case people missed it...
|
|
|
|
Post by foxypotato on May 16, 2019 15:31:34 GMT -5
Sticky. Pin it. Whatever.
|
|
|
|
Post by KomodoPie on May 16, 2019 16:37:50 GMT -5
Sticky. Pin it. Whatever. How do we make that happen? |
|
|
|
Post by foxypotato on May 16, 2019 16:45:46 GMT -5
Sticky. Pin it. Whatever. How do we make that happen? Summon Mr Poopface. |
|
|
|
Post by KomodoPie on May 16, 2019 17:15:57 GMT -5
Mr Poopface -- foxypotato recommended I summon you to make this thread sticky. I'm hoping this will do the trick, and I don't have to say something 3 times in a mirror or anything occult like that.  |
|
|
|
Post by Rollo Tomasi on May 16, 2019 18:58:32 GMT -5
Sticky. Pin it. Whatever. How do we make that happen? No joke! This deserves a very sticky pin. Come on mods....  |
|
|
|
Post by Rollo Tomasi on May 16, 2019 19:19:14 GMT -5
Mr Poopface -- foxypotato recommended I summon you to make this thread sticky. I'm hoping this will do the trick, and I don't have to say something 3 times in a mirror or anything occult like that. Indeed, Mr. Poopface , sticky it man. And if we need to get some more attention I’ll mix up a wicked combo of politics, religion and toss in a generous dollop of parenting advice for good measure. Then I’ll test the profanity auto-filter with a creative series of these....   |
|
|
|
Post by Rollo Tomasi on May 17, 2019 7:12:27 GMT -5
Seriously, how does Super Chest have a sticky pin, but not this? Very FEW can ever reach a super chest, yet ALL can benefit from this excellent from this excellent tool. KomodoPie , you should check out turning this into an App. At $1.99, I bet you’d sell millions of em. |
|
|
|
Post by Rollo Tomasi on May 17, 2019 8:40:47 GMT -5
Seriously, how does Super Chest have a sticky pin, but not this? Very FEW can ever reach a super chest, yet ALL can benefit from this excellent from this excellent tool. KomodoPie , you should check out turning this into an App. At $1.99, I bet you’d sell millions of em. Phil and Stan here to be telling you best ways for you monetizing your programming efforts. 1) Important to be give away for free first taste. 2) Create disconnect between RM and App currencies. 3) You should be making many different App currencies for to confuse player and they forget that they are spend RM. 4) Make Process Tokens for different level of bot and weapon. Give lots of Legacy Process Token for free, but charge RM for Meta Bot Process Token. 5) Make it easy to accidentally hit “Process Damage Analysis” Button, forcing extra spend of Tokens. 6) When hit Process Button, make spinnng dials and lights blinking just like in casino. 7) Please to be making Analysis bug that shows highest damage for new bot and weapons, then fix later, quiet behind scenes. See you on the battle field |
|
|
|
Post by Poopface on May 17, 2019 11:33:29 GMT -5
Mr Poopface -- foxypotato recommended I summon you to make this thread sticky. I'm hoping this will do the trick, and I don't have to say something 3 times in a mirror or anything occult like that. Indeed, Mr. Poopface , sticky it man. And if we need to get some more attention I’ll mix up a wicked combo of politics, religion and toss in a generous dollop of parenting advice for good measure. Then I’ll test the profanity auto-filter with a creative series of these.... You need to be careful when provoking the auto-correct. You never know what might happen.... |
|
|
|
Post by endyu on May 17, 2019 11:47:54 GMT -5
Which bots are considered large hit boxes vs small?
|
|
|
|
Post by KomodoPie on May 17, 2019 13:02:30 GMT -5
Which bots are considered large hit boxes vs small? If you mean what was used for the testing that the spreadsheet is based on, large = Natasha, small = Destrier. I'm not sure what was used for the stats on the wiki, but it's something pretty big but a bit smaller than a Natasha (maybe Griffin?). If you mean should each of the bots in the game be categorized, I think there's a continuum that I'm guessing corresponds to how big the bot looks. Persuers, Striders, Menders, etc are on the small end. Furies, Bulwarks, Fenrirs etc are on the big end. |
|
|
|
Post by KomodoPie on May 19, 2019 19:07:29 GMT -5
NEW FEATURES! (May 19, 2019)
- Damage vs time plot
Link in OP has been updated. Current version is 5.0i.
|
|
|
|
Post by Rollo Tomasi on Jul 16, 2019 15:45:06 GMT -5
========================================== NEW FEATURES! (May 19, 2019)- Damage vs time plot NEW FEATURES! (May 14, 2019)- Built-in weapons (for Mercury, Ao Jun, etc.) - Choice of target bot size (which impacts weapons with bullet spread; data based on tests by KomodoPie and frunobulax ) - Corrected Avenger rate of fire ========================================== Ever wanted to compare how much damage weapons or whole builds can do at a given distance over a given period of time, without having to buy and upgrade them to find out? Well, you can, with the War Robots Weapon Damage Spreadsheet! The heart of the spreadsheet is the user-friendly Build Comparison Tool, which lets you select weapons for up to 5 builds from drop-down menus and automatically shows you two graphs: one comparing their damage vs distance (from 50 to 1100 m) for whatever time period you specify (from 1 to 30 sec), and the other comparing their damage vs time for whatever distance you specify. Weapon levels and target bot size are user-selectable. Built-in weapons for Mercury, Ao Jun, etc. are now included. The subsequent sheets contain the underlying data: tables of every current weapon's cumulative damage over time for various distances to target, based on the specs on the War Robots wiki. I don't know where those specs come from. You can download the spreadsheet from my Dropbox here (current version is 5.0i): www.dropbox.com/s/k7u3b498lzxry0j/War Robots%20Weapon%20Damage%20v5p0i.xlsx?dl=1 The damage calculation accounts for: - Damage per shot, rate of fire, clip size, and reload mechanics - Bullet spread (target size is accounted for based on tests with Gust, Thunder, Punisher, Avenger, Halo, Viper, and Molot) - Spark/Scourge/Calamity damage decline with distance - Corrosion damage over time (with a setting to choose whether to count it when the shots hit or when the target actually suffers) - Weapon level (which you can choose) This tool has been very useful to me in deciding which weapons to invest in, and in thinking about builds, and I hope you'll find it helpful too! P.S. Please let me know if you find any errors. Hey KomodoPie, any plans to test the various pilot sharpshooter skills? Glory looks pretty ugly vs avenger at longer distances, but SS skill might close that gap. And again, great work in this thing, it is very useful! |
|
|
|
Post by RIP_HARAMBE on Aug 18, 2019 20:27:08 GMT -5
Curious if you are planning to revise with 5.3 changes?
|
|
bobot
Destrier
Posts: 43
Karma: 9
|
Post by bobot on Sept 28, 2019 21:48:08 GMT -5
Glory or Avenger does not seem accurate. Based on spreadsheet Glory is barely better only at very close range. When I watch the Avenger vs Glory video comparisons the Glory destroys avenger at very close range.
And I factored in when this was updated and the time the video was made
|
|
|
|
Post by drunkentoddler on Oct 24, 2019 11:25:24 GMT -5
SO this is the most awesome chart I have ever seen and I love to use it.
Is there any way to change it so that the damage graph goes to zero at the end of the weapons range.
For example. The calamity's line on the damage graph goes all the way out to 800m. I think it is because it is listed to do damage at 600m and zero damage at 800m in the damage chart. The graphing function then extrapolates out the line to the 800m instead of going straight to zero at 601m.
I tried to insert a distance of 601m in the chart, but I couldn't get the graph to change and I don't know enough about excel to change it.
Also, is there a way to account for pilot influence, such as sharpshooter, speedshooter and damage boost.
I don't mean to lessen the greatness of this document for comparing weapon builds. It is crazy good and gives more information about damage than anything on the web.
|
|
|
|
Post by Jeb on Jan 20, 2020 10:55:04 GMT -5
I was playing around with this again today, as I continue to level up my weapons setups and compare performances, when I realized that I never had played around with the time factor. I changed the time setting from 10s to 3s and realized that my Tulu/Pin setup wasn't as weak as it had looked at the 10s mark. When I looked at how much damage it dumps into the target in 3s compared to the others, and factoring in the extra range over the plasma setups, I better understood why it felt stronger than it showed up on the charts.
|
|
|
|
Post by >^\}VULTURE{/^< on Feb 15, 2020 16:36:14 GMT -5
I was playing around with this again today, as I continue to level up my weapons setups and compare performances, when I realized that I never had played around with the time factor. I changed the time setting from 10s to 3s and realized that my Tulu/Pin setup wasn't as weak as it had looked at the 10s mark. When I looked at how much damage it dumps into the target in 3s compared to the others, and factoring in the extra range over the plasma setups, I better understood why it felt stronger than it showed up on the charts. Some call this "alpha" damage, others call it "front loaded" damage. Thing is some weapons do most their damage in 1 second to 4 seconds. This is high damage up front, when some weapons can do more damage but must wait, like Scourge/Gekko/Punisher types and the like. "alpha" weapons are more like weapons that take longer to reload or charge like Kangdae/Shocktrain/Zues. Some fall in between like rocket weapons, they can be "alpha" or "beta" damage depending on how much ammo is stored. When "bursting" (unloading a full ammo rack) rockets act like "alpha weapons. When using "sustained fire" (using empty or half loaded ammo rack), they behave more like "beta" weapons. Hope that explained the damage to time ratio for you. *edit* Personally I like to mix both damage types. If I can kill a target with "alpha" damage I'm happy, but I keep a "beta" weapon on deck in case it develops into a brawl. |
|
|
|
Post by lucho71 on Mar 28, 2020 12:55:09 GMT -5
This is an awesome tool!!! Do you have the new updates for 5.8?
|
|
|
|
Post by bladehaven on Apr 11, 2020 13:13:30 GMT -5
========================================== NEW FEATURES! (May 19, 2019)- Damage vs time plot NEW FEATURES! (May 14, 2019)- Built-in weapons (for Mercury, Ao Jun, etc.) - Choice of target bot size (which impacts weapons with bullet spread; data based on tests by KomodoPie and frunobulax ) - Corrected Avenger rate of fire ========================================== Ever wanted to compare how much damage weapons or whole builds can do at a given distance over a given period of time, without having to buy and upgrade them to find out? Well, you can, with the War Robots Weapon Damage Spreadsheet! The heart of the spreadsheet is the user-friendly Build Comparison Tool, which lets you select weapons for up to 5 builds from drop-down menus and automatically shows you two graphs: one comparing their damage vs distance (from 50 to 1100 m) for whatever time period you specify (from 1 to 30 sec), and the other comparing their damage vs time for whatever distance you specify. Weapon levels and target bot size are user-selectable. Built-in weapons for Mercury, Ao Jun, etc. are now included. The subsequent sheets contain the underlying data: tables of every current weapon's cumulative damage over time for various distances to target, based on the specs on the War Robots wiki. I don't know where those specs come from. You can download the spreadsheet from my Dropbox here (current version is 5.0i): www.dropbox.com/s/k7u3b498lzxry0j/War Robots%20Weapon%20Damage%20v5p0i.xlsx?dl=1 The damage calculation accounts for: - Damage per shot, rate of fire, clip size, and reload mechanics - Bullet spread (target size is accounted for based on tests with Gust, Thunder, Punisher, Avenger, Halo, Viper, and Molot) - Spark/Scourge/Calamity damage decline with distance - Corrosion damage over time (with a setting to choose whether to count it when the shots hit or when the target actually suffers) - Weapon level (which you can choose) This tool has been very useful to me in deciding which weapons to invest in, and in thinking about builds, and I hope you'll find it helpful too! P.S. Please let me know if you find any errors. |
|
