I guess Damage Amplifiers (e.g. a Gunnlogi with 3 complex damage mods) is calculated like this:
1.3*(1+0.3*0.87)*(1+0.3*0.57)
and not
1+(0.3+0.3*0.87+0.3*0.57)

Have a look http://www.eve-wiki.net/index.php?title=Stacking_penalty
20% mods, 2 stacked yield 1.409

Ok, thanks, I'll change that. Shouldn't of been much of an issue prior to this anyways, as I don't see a good fit utilizing more than 1 damage amp.

Edit: they should now be stacking appropriately

I actually just thought of an important question: do PG and CPU modules stack the same way as Damage Amplifiers? If they do, then stacking those modules will give you a little bit more than what is currently calculated....

That formula applies to all eve/dust maths. If the attribute is stacking penalized, use the stacking penalty. If not, use "1" instead of each stacking penalty.

If a module is providing an absolute value, as opposed to a percentage, the value is added/subtracted at the end of all calculations. There is usually no stacking penalty on modules that add/subtract absolute values.

Seriously, 1 like a quite modest compensation for everything your tool has allowed me to do.

I know I have thanked you already, but I would like to to it again,
Thanks.

Interested in writing a plugin for DFT? I've sent you an email through the spreadsheet sharing

This would make me super-happy.

Is there one of these for dropsuit and weapon module fittings someplace?


Munch

The thing is, though, I don't know what writing a plugin involves.

Is there one of these for dropsuit and weapon module fittings someplace?


Munch

I always wanted to do this

I am proud to present, the 1.7 Vehicle Fitting Accessory!

It contains all the vehicles, modules, skills, and attributes released here!

To use:

• Go to File
• Make a copy...
• Voila!

Cover sheet has all the directions you need. All you have to do is enter a number next to the module name to add that many modules to the fit. Everything is automatic, even the stacking penalties!

I had to look up a function to get it to work correctly for the CPU and PG upgrades, because they all have different values at their different levels, and the modules with the highest attributes are applied first! Grrr, but I did it Also you may notice that adding Boosters or Afterburners changes nothing to the speed attribute of the vehicle; it's because I'm not sure just exactly what gets affected, acceleration or speed? (Because a HAV going faster than an LAV seemed a bit odd).

I know that this isn't as awesome as the Dust Fitting Tool, but there is only so much that I can do.

Please, any feedback will be much appreciated. I also did my best to ensure maximum accuracy.

Update 1: I just realized that some of the formatting went bad at the very end. Not a big problem, just some extra borders is all!
Update 2: All vehicles now have correct shield regeneration attributes!
Update 3: All formatting is fixed! I also fixed a calculation error regarding max ammo count after skills
Update 4: Damage amps have been added to the stacking penalty calculator and are now factored into the final burst and sustained DPS attributes at the top! I think that's it, no more little things to fix!
Update 5: I'd like to thank daishi for pointing this out to me: CPU modules weren't being calculated into the fitting attribute. Only the first CPU mod wasn't being "seen," but every mod after that was applied with the appropriate stacking penalty. Problem is fixed now.
Final Update: I'd like to thank daishi and hydraSlav's for pointing out to me that Damage Amps stack directly one after the other, instead of applying to the base stats. The calculations now have Damage Amps applying bonuses after the previous bonus. PG and CPU modules have been updated to follow this stacking manner. Stacking those modules will now give you a little bit extra PG and CPU.

I applied 2 pg upgrades but the pg didn't change at all, neither increased or decreased.

The 'Total PG' (Q11) and 'Total CPU' (R11) needs to be renamed to 'PG" and "CPU'.
'PG' (A6) should be renamed to 'Total PG' ad 'CPU' (A7) should be renamed to 'Total CPU'.

[quote=The-Errorist]The 'Total PG' (Q11) and 'Total CPU' (R11) needs to be renamed to 'PG" and "CPU'.
'PG' (A6) should be renamed to 'Total PG' ad 'CPU' (A7) should be renamed to 'Total CPU'.

What the heck does bonus to turret rotation mean

I don't see the problem with renaming Renaming "Total PG/CPU" (Q11/R11) to "Used PG/CPU", as it is the sum of all the modules PG/CPU and the PG/CPU of turrets, which is essentially used PG/CPU. Having that say Total PG/CPU when it is not, is misleading. A7/A8 say how much Total PG/CPU you have to work with and it would be nice if you made it more specific.

Also, since the remaining PG/CPU is located under "Modified Values", the user might not be sure what that modified PG/CPU values represent. You could make the equations say "remaining PG/CPU" after the number to clearly show what that number is. To do so, surround your original equation with ampersand signs and put all that in in parentheses. Next put the words next to it and put all that in a set of parentheses. It should look something like

Everything in the spreadsheet is of concern to me because I try to find problems and I like to tweak things as well as knowing how something I'm using works. I know I'm being very nit-picky, but I'm just trying to help and give feedback.

I am proud to present, the 1.7 Vehicle Fitting Accessory!

It contains all the vehicles, modules, skills, and attributes released here!

To use:

• Go to File
• Make a copy...
• Voila!

Cover sheet has all the directions you need. All you have to do is enter a number next to the module name to add that many modules to the fit. Everything is automatic, even the stacking penalties!

I had to look up a function to get it to work correctly for the CPU and PG upgrades, because they all have different values at their different levels, and the modules with the highest attributes are applied first! Grrr, but I did it Also you may notice that adding Boosters or Afterburners changes nothing to the speed attribute of the vehicle; it's because I'm not sure just exactly what gets affected, acceleration or speed? (Because a HAV going faster than an LAV seemed a bit odd).

I know that this isn't as awesome as the Dust Fitting Tool, but there is only so much that I can do.

Please, any feedback will be much appreciated. I also did my best to ensure maximum accuracy.

Update 1: I just realized that some of the formatting went bad at the very end. Not a big problem, just some extra borders is all!
Update 2: All vehicles now have correct shield regeneration attributes!
Update 3: All formatting is fixed! I also fixed a calculation error regarding max ammo count after skills
Update 4: Damage amps have been added to the stacking penalty calculator and are now factored into the final burst and sustained DPS attributes at the top! I think that's it, no more little things to fix!
Update 5: I'd like to thank daishi for pointing this out to me: CPU modules weren't being calculated into the fitting attribute. Only the first CPU mod wasn't being "seen," but every mod after that was applied with the appropriate stacking penalty. Problem is fixed now.
Final Update: I'd like to thank daishi and hydraSlav's for pointing out to me that Damage Amps stack directly one after the other, instead of applying to the base stats. The calculations now have Damage Amps applying bonuses after the previous bonus. PG and CPU modules have been updated to follow this stacking manner. Stacking those modules will now give you a little bit extra PG and CPU.

I had a quick question, does everyone have problems with finding Flux grenades on the Dust fitting tool, and are there similar problems on the vehicle one?

I had a quick question, does everyone have problems with finding Flux grenades on the Dust fitting tool, and are there similar problems on the vehicle one?

I'm also currently working on making the vehicle version of DFT in collaboration with hyrdaSlav.

completely useless... couldn't find anything to do with vehicles at all... just found a blank spreadsheet page with nothing on it.