+- Idle Online Universe RPG (https://iourpg.com/forum)
+-- Forum: General (https://iourpg.com/forum/forumdisplay.php?fid=5)
+--- Forum: Guides (https://iourpg.com/forum/forumdisplay.php?fid=7)
+--- Thread: Fire Clan IOU Multicalc (/showthread.php?tid=2233)
RE: Gameinsky's modified IOU Multicalc - damador - 01-27-2017
https://docs.google.com/spreadsheets/d/1In5RSBuobSgcVblXbt9DiW8ZmlIqcIyr8PRFg9XIGIY/edit?usp=sharing here is share of latest version - optimizer ...
somehow after import from previous version F17 show negative values in optimizer tab
RE: Gameinsky's modified IOU Multicalc - jiecut - 01-28-2017
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.
RE: Gameinsky's modified IOU Multicalc - Alpha12 - 01-28-2017
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 ?
RE: Gameinsky's modified IOU Multicalc - porkbob - 01-29-2017
(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.
RE: Gameinsky's modified IOU Multicalc - LaberLu - 02-02-2017
In cells AO39, AY18 and AU62 on "Optimizer & General Instructions" it should be AS5 instead of V13. It gives negative numbers otherwise.
RE: Gameinsky's modified IOU Multicalc - Chencho - 02-04-2017
(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.
RE: Gameinsky's modified IOU Multicalc - k3rb3r05 - 02-05-2017
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
RE: Gameinsky's modified IOU Multicalc - jiecut - 02-06-2017
@laberlu Actual issue is that some formulas were changed in the game, changed in optimizer but not all these upgrade optimizer calcs.
RE: Gameinsky's modified IOU Multicalc - damador - 02-07-2017
optimizer & general S3 -> =Main!V3 - so it will autoupdate your dps not only on import
RE: Gameinsky's modified IOU Multicalc - LaberLu - 02-07-2017
@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."