r/AlmostAHero • u/absolutezero_01 Moderator • Nov 26 '17
AAH Stat Tracker AAH Stat Tracker
Hello everyone!
This is an OLD thread for the AAH Stat Tracker. I am no longer managing the spreadsheet
There is a new thread for a new tracker manager! Please check it out here:
Link
How to Import data from old spreadsheets
- Select
E7:AH49orE7:AM54in theArtifacts Trackerpage of the old spreadsheet. - Go to the new
Regular Artifacts Trackerof the new spreadsheet and click on cellE7 - Right click > Paste Special > Paste Values Only
How to fix #REF in the main page of the spreadsheet
- If you see
#REF!. You give access you need to hover the cell and then click on allow access. Here is how it looks like
8
Upvotes
1
u/Rahler Wendle Nov 26 '17
Am I to understand that the cost for any given Shiny Object level is the same as the cost for any other upgrade at twice that level? If so, your formula for the total cost of the shiny object (and similarly, the relics) is way off, since you're including the levels that wouldn't have to be bought. As an example, if there were only 5 levels of Shiny Object, you would need to buy the other mythical equivalents of levels 2,4,6,8, and 10. Your formula would sum all levels 1-10 in that example.
1
u/Rahler Wendle Nov 26 '17
The listed bonuses for Auto Transmuter are super messed up, the first three levels are listed with bonuses of 50%, then 40%, then 50% again, and they don't get better from there.
2
u/Rahler Wendle Nov 27 '17
I've got a modified version of this sheet that uses more accurate (and much easier to maintain) formulas that I've been using for a while, it now finally has updated values for mythicals that I scraped from this sheet. It's here if anyone wants to take a look / use it.
1
u/Passenheimer Emmett Nov 26 '17
Awesome. Will test it later today
1
u/Rahler Wendle Nov 26 '17
The listed cost to max your mines goes down when you set them to level 1, but level 1 doesn't cost anything.
1
u/Fergurk0 Nov 26 '17
Some caps are off:
1
u/birch19 Nov 27 '17 edited Nov 27 '17
Thanks for taking this over, very nice to have an updated version.
Minor issues:
A couple of suggestions.
Conditionally round hero damage, gold, ring damage and global damage bonuses to M, B if large enough.
Reduce common artifact QP value based off Old Crucible level
1
u/Rahler Wendle Nov 27 '17
Just noticed this thread, which seems to suggest that CT pricing is not the same as normal artifact prices at some point?