Fire Clan IOU Multicalc

[damador]

https://docs.google.com/spreadsheets/d/1...sp=sharing here is share of latest version - optimizer ...

somehow after import from previous version F17 show negative values in optimizer tab

[jiecut]

There was some major monster hp, and xp changes and I didn't also rework the optimizer calcs.

Also, expeditions tabs needs to be tweaked with the balance changes.

[Alpha12]

In version 3.6, on "Advanced Cards" sheet, cell L30 : why are cells H42 to H45 not referenced ?
In "Optimizer & General Instructions" sheet, cell S3 come from import, so we now have to update it manually ?

[porkbob]

(01-28-2017, 08:49 PM)Alpha12 Wrote: In version 3.6,  on "Advanced Cards" sheet, cell L30 : why are cells H42 to H45 not referenced ?

I've never even looked at the Advanced Cards tabs, so I don't know. I also still can't edit it, but I'll let GIS know. Edit: It's fixed.

(01-28-2017, 08:49 PM)Alpha12 Wrote: In "Optimizer & General Instructions" sheet, cell S3 come from import, so we now have to update it manually ?

Yes, this is because every single time you changed anything on the sheet, it had to search all the inferno tiers for your optimal one since the party dps changed automatically. This is a big waste of time and processing in the long-term, especially with there now being over twice as many inferno tiers. Because you hardly ever need to use the Inferno Optimizer—and when you do, you need to update party members' DPS anyway—it only makes sense to just add 1 extra thing to update instead of having to wait for it to search the tiers every time you do something in the sheet.

[LaberLu]

In cells AO39, AY18 and AU62 on "Optimizer & General Instructions" it should be AS5 instead of V13. It gives negative numbers otherwise.

[Chencho]

(01-28-2017, 08:49 PM)Alpha12 Wrote: In version 3.6,  on "Advanced Cards" sheet, cell L30 : why are cells H42 to H45 not referenced ?
In "Optimizer & General Instructions" sheet, cell S3 come from import, so we now have to update it manually ?

If you still want that updated automatically I just added =Main!V3 to S3 in "Optimizer & General Instructions". Dunno if it's accurate for calculations, but the trick works.

On the other hand, I think that in "Main" cell L22 format needs to be edited so it shows at least 1 decimal digit for better calculations. If not, just ignore this comment.

EDIT: I have also noticed that the Simplifier Optimizer always shows the same upgrade despite of what preference you select from the drop down list.

Kind regards.

[k3rb3r05]

Hello,

Would it be possible to add in "Advanced cards":
a) a boss milestone  dropdown with conditonal formating rules:

Code:

Apply to range: F4,K4,F6,K6,F8,K8,P8,U8,F10,K10,P10,F12,K12,P12,F14,K14,F16,K16,F18,K18,F20,K20,P20,U20,Z20,F22,K22,P22,U22,Z22,F24,K24,P24,U24

Custom formula is: =F4<$M$1
($M$1 is where i have the boss dropdown)

b) in range L37:Z37 a formula that calculates how many card packs are needed to reach milestone goal.  So the fomula in L37 looks like: =L34/$Q$18 

[jiecut]

@laberlu Actual issue is that some formulas were changed in the game, changed in optimizer but not all these upgrade optimizer calcs.

[damador]

optimizer & general S3 -> =Main!V3 - so it will autoupdate your dps not only on import

[LaberLu]

@jiecut: The problem is, that it will keep recommending these bugged Upgrades, because negative Values have the best effect/cost ratio. That makes optimize for Gold useless.

@damador: From the first page: "v3.6 Note: Your own DPS is no longer auto-updated on the Optimizer page. This is so the sheet doesn't have to search all the inferno tiers every single change you make, to save on processing."