Ships & Modules

A few days ago, I discovered an MS Excel function that lets me grab the Xth highest (or lowest) value out of a data set. I figured that with this function, I'd be able to build a spreadsheet to brute-force analyze my way, through trial and error, to optimal omni-tank fits for a variety of shield ships. Simply try with or without DC, with 1 Invulns, or 2, 3 or zero, and with various numbers of specific hardeners.

I've spent a couple of hours on that, typing in data, getting the stacking penalties right, and so forth. With a ready-to-test product, I tried it on my current ship, and the values don't match what the in-game Fitting screen shows me. They're off by several percent, meaning it can't be rounding errors.

I'm not too good with spreadsheets, so at this point I'm tempted to give up.

Has anybody else made a spreadsheet like this, that facilitiates the comparison of several different fits on the same screen, showing the result (primarily the omni-tank) of each fit?

Don't refer me to EFT, because EFT can't do this. EFT requires me to manually swap out modules one at a time, and only shows the result for one fit at a time, meaning I have to do manual record-keeping in Notepad, and that does not faciliitate trying a lot of different permutations to, e.g., find the best 3-slot tank for a Cerberus, or the best 4-slot or 2-slot tank, and at what point the DC stops making a serious difference for my shield tank...

I don't know if Pyfa can do this. I downloaded it about a week ago, but could not at all figure out how to import my API data.

Is there a spreadsheet that already does this? Or a program that lets me manually compare a variety of different fit permutations? Or a program that does the analysis of its own, runs through all the permutations for X slots for a given hull, and outputs the optimal fit?

I don't do EHP, and I don't do in-coming damage, because I want the spreadsheet to be a tool for all kinds of omni-shield-tanking: Active, passive, buffer. All I care about are the four resists, and even more so I care about what the lowest of them is.

The values that are off by several percent are the actual resists. EM resist, kinetic resist, and so forth.

Is your spreadsheet taking skills into account? For passive hardeners, the numbers will be affected by resistance compensation skills and there are probably other skills that affect the overall resistances such as ship command skills affecting ship bonuses.

At this point I don't see another possiblity either.
Unless you didn't consider that your DC isn't affected by stacking penalties caused by your hardeners (afaik)... well, that'd be a fault in your spreadsheet, too.

that is not true you can have more than one window open at once in eft i use eft alot to compare more fits next to each other withput having to write down results and so in a notepad.

If you post the sheet in Google Drive and link to it I'll try to look at it over the next day or so. Hard to troubleshoot when you don't know exactly what you're looking at though.

Libre if you can manage it.

Got it. Wasn't that tough once I started grinding it hard. But of course I started with the formulas, which are pretty much fine. The only change I'd recommend on that would be to use the actual stacking formula like so:

=0.5^(((AG51-1)/2.22292081)^2) where AG51 is a reference cell for being the nth number in the stack (and in your sheet it's actually number 2).

The problem, as it turns out, is that you had the Cerberus' native therm and kin resists backwards. Try flipping those around; suddenly everything rounds properly. So now your Cerberus with DC, 2 EM, and 1 exp reads 79.4, 82.5, 73.8, 80.3 -- which is where it should be.