172 réponses à ce sujet

[corlist]

p.s. When a ravager popped all the sacs by itself it did 30% damage, presumably this value is split among each separate sac.

[Tybo]

Sorry guys, I took the calculator off line for an hour or so while I make some revisions. It will be back up soon.

[cronshaw]

Thanks for doing this
I'll be interested to check it out

[Tybo]

Ok, done with this round of revisions. I separated the databases from the calculator, so if you download this latest update, you shouldn't need to download any more until I add further functions to it. Any bug fixes should not require you to redownload the spreadsheet.

[mackfactor]

Nice work.

I'm pretty sure that this is literally the only useful thread on this forum today.

[Bayonet Hipshot]

This is freaking brilliant ..!! Kudos to OP & Sirian

[Doc-Jek]

I get a bunch of overflow errors and "error: The requested spreadsheet key, sheet title, or cell range was not found."

[Tybo]

Doc-Jek wrote...

I get a bunch of overflow errors and "error: The requested spreadsheet key, sheet title, or cell range was not found."

Try again.  I forgot to make my database spreadsheet public, it should work now.

[Tybo]

The Sin wrote...

This is freaking brilliant ..!! Kudos to OP & Sirian Grimy_Bunyip

Fixed it for you

Modifié par tyhw, 28 novembre 2012 - 04:30 .

[Tybo]

Added all of the missing gear.

Next planned update is for a melee damage/melee to kill table. I will also add a toggle for the Atlas plates, Ravager sacs, and Scion shoulder.

Any other requests?

[Tybo]

Lord_Sirian wrote...

tyhw wrote...

Added all of the missing gear.

Next planned update is for a melee damage/melee to kill table. I will also add a toggle for the Atlas plates, Ravager sacs, and Scion shoulder.

Any other requests?

  

Is it set up to include the TGI's 10 second +20% multiplicative AR damage bonus? And the 20% multiplicative sniper bonus on other infiltrators?

Seems like a difficult thing to put in I guess..

Both multiplicative bonuses should be working correctly, they do on my spreadsheet.  I should figure out how to work in the 2.5 second cloak window, but I haven't thought of an elegant way to do so yet.

[Tybo]

Updated for a Marksman bug (accidental additive 10% headshot damage) and a Warp ammo IV bug (accidental 5% extra additive damage). Neither bug will require you to re-copy the calculator, but be warned that you should re-calculate anything you used with either

Modifié par tyhw, 28 novembre 2012 - 08:22 .

[Tybo]

Updated for Marksman + Cranial Trauma System bug ( I had them multiplying, when they should be adding). This one will require you to make a new copy of the spreadsheet.

Thanks to corlist for the help bug-finding

Modifié par tyhw, 28 novembre 2012 - 08:22 .

[Stardusk]

tyhw wrote...

Over the past few days I've been making a calculator to help me optimize my builds and weapon usage.   Using a template made by Grimy_Bunyip a long time ago, I made an interactive damage calculator.  With it, you can choose any class, combination of power evolutions, weapon, equipment, difficulty,and mods.  It will show you how much damage you will do per shot.

But that's not all.  I've included the most important weapon stat of all:  Time to kill.  With this calculator, you can see how many shots and how long it will take you, reloads included, to kill any enemy on any difficulty.  It calculates this for both headshots and bodyshots.

This is what it looks like:


If you'd like to use this yourself, simply click on the link below:

https://docs.google....vTEJ5d1E#gid=17

When you load up the doc, simply select File > Make a Copy.  This will give you a copy of your own to tinker with.  It also needs a few tiny updates.  It currently does not properly decrease the mag size of the Collector Sniper and SMG with level but assumes max level.  It also allows the user to put any combination of legit mods on a gun (e.g., can add both the Pistol Heavy Barrel and Pistol High Caliber Barrel at the same time).  However, to the best of my knowledge, it calculates everything else properly.  

Please report any bugs or errors you see, so I can make this work better.

Much thanks to tthw, who served as my beta tester.

EDIT:  As pointed out by Lord_Sirian, I should figure out a way to incorporate bursting ravager sacs/ scion shoulder/atlas plates.

EDIT 2:  Also from Lord_Sirian, this calculator assumes that TC is always active.  In practice, it can get pretty close to that, especially with slow RoF weapons.  However, this is another bug to address.

EDIT 3:  Atlases will also go down quicker than this with piercing due to the double/triple hit glitch.  However, I decided not to include this in the calculator at the moment due to the fact that you can do double with 1 headshot, or double without a headshot, or triple.  If there is enough demand, I can set these up though.

EDIT 4:  Also note that, when using the SMG Heat sink, I used the average number of shots you would gain and increased the mag size by that much.  The Heat sink doesn't work on the CSMG as well, but in this calculator it will show a gain for it.

EDIT 5: Added missing gear.  Reworked the spreadsheet so that I can update weapon stats and skill stats without the user needing to re copy the spreadsheet.  

EDIT 6:  Next planned update:  Melee damage table and toggle for the breakable enemy parts (ravager sacs, atlas plates, scion shoulder)  Feel free to suggest anything you would like to see

Lord of Engineering.

[Tybo]

Stardusk wrote...

Lord of Engineering.

Well, it was more fun then working on my thesis...

[Tybo]

Updated: If you re-download the calculator now, it will have a version number. It will also have a cell which tells you the current version number. If the current version number is higher than the one you have, you should make a new copy, as I have either found some errors and fixed them, or added new functions.

[Stardusk]

tyhw wrote...

Stardusk wrote...

Lord of Engineering.

Well, it was more fun then working on my thesis...

Undoubtedly without your mastery of mechanical engineering this great work would have been impossible.

[tthw]

 Hey Ty there is an error with the ammo selection, with a locust it says I can one shot everything with warp ammo IV

Edit: Adding a picture

Modifié par tthw, 28 novembre 2012 - 09:55 .

[Tybo]

tthw wrote...

 Hey Ty there is an error with the ammo selection, with a locust it says I can one shot everything with warp ammo IV

Yeah, I made a mistake when I tried to create the version updater.  I broke the ammo selection and the current version indicator didn't work.

But everything should now be working properly if you re-copy.  

[tthw]

tyhw wrote...

tthw wrote...

 Hey Ty there is an error with the ammo selection, with a locust it says I can one shot everything with warp ammo IV

Yeah, I made a mistake when I tried to create the version updater.  I broke the ammo selection and the current version indicator didn't work.

But everything should now be working properly if you re-copy.  

So I can't kill everything with one shot with the locust? Sad times.....