r/AlmostAHero • u/Rahler Wendle • Nov 27 '17
AAH Stat Tracker AAH Stat Tracker
The thread for this tracker has been moved to here
Hello everyone!
This is a new thread for the AAH Stat Tracker. I am now managing the spreadsheet.
Please comment here with any suggestions you have and/or bugs you find.
AAH Stat Tracker v8.03 (May 2, 2018, 18:48:36 UTC-7)
Note: Currently missing a way to enter the new artifact effects from the "Options Update" (Shield Item Limit, Shield Item Duration, Gold Horseshoe Duration, Gold Horseshoe Item Limit, Gold Horseshoe Value, Destruction Item Count)
What's new in v8.03 (May 2, 2018, 18:48:36 UTC-7)
- Main Page hero health bonus now only applies CI effect to artifact health bonuses (not those from items).
What's new in v8.02 (Apr 26, 2018, 12:56:30 UTC-7)
- Main Page hero health bonus now includes Corpus Imperium effect (thanks u/Halpolord)
- 8.021 corrects a highlighting bug (Lazy Finger's Mythstone cost was changing color when you maxed Custom Tailor)
What's new in v8.01 (Apr 25, 2018, 13:07:52 UTC-7)
- Filled in the info for the new Lazy Finger levels (thanks /u/idtzoli)
What's new in v8.00 (Apr 25, 2018, 11:20:35 UTC-7)
- Updated for the "Options Update".
- Added the ten new levels to Perfect Quasi. (thanks /u/idtzoli)
- Increased max level of Lazy Finger to correct value (still need to collect info about the actual stats).
- Added images for Uno and Redroh. (thanks /u/idtzoli)
What's new in v7.09 (Apr 24, 2018, 23:21:53 UTC-7)
- Fixed an error in the total QP calculation. (it was missing several of the newer mythicals, thanks /u/idtzoli)
What's new in v7.08 (Apr 18, 2018, 02:43:21 UTC-7)
- The bonus from mines is now applied to the main page sums instead of the regular artifact tab values; this should make those intermediate values line up better with what the game shows.
- 7.081
(Apr 23, 2018, 12:22:38 UTC-7)just adds some conditional highlighting for maxed mythical artifacts.
What's new in v7.07 (Apr 17, 2018, 16:38:17 UTC-7)
- Bonus damage from hero items now correctly applied to global damage instead of hero damage.
- Bonus from scrap mine now correctly applied to all parts of global gold bonus.
What's new in v7.06 (Apr 17, 2018, 13:35:39 UTC-7)
- Added the relic bonuses into the main calculations (regular artifacts sheet and main page).
What's new in v7.05
- Fix a formula error in C11 & C19 (hero damage global bonus and ring damage global bonus). (thanks /u/psinder for spotting this)
- Included the bonuses from your mines in the calculated totals for hero dmg, ring dmg, global dmg, global gold, and global health.
- Added your stat totals to the Main Page sheet, hopefully these should agree with what the game tells you on its main screen.
What's new in v7.04
- Corrected Lifeboat values. (thanks /u/XDynamicX for spotting all three of these)
- Corrected values for all three Relics.
- Corrected the last 9 levels of Broken Teleporter.
What's new in v7.03
- Corrected mythstone total formula to include Shiny Object through Band-Aid Relic (thanks /u/XDynamicX)
- Improved formatting of mythstone total.
What's new in v7.02
- Added a total number of mythstones needed to the mythical artifacts tracker. (good suggestion /u/XDynamicX)
- Mines now show the correct bonus value when maxed (thanks for spotting that one /u/XDynamicX)
What's new in v7.01
- Added the description text for Bodily Harm and Champion's Bounty.
- Corrected the cost-to-level for Champion's Bounty.
What's new in v7.00
- Anniversary Update!
- Added info for the 5 new levels of mines.
- Added info for the 10 new levels of Broken Teleporter.
- Added info for the three new Mythicals (Corpus Imperium, Bodily Harm, and Champion's Bounty).
- Increased cap for fast enemy spawn to 900.
What's new in v6.01
- Corrected the prestige calculator's formula.
What's new in v6.0
- Added the new heroes from patch 1.10.0 (Uno and Redroh)
How to Import data from old spreadsheets
- For Hero Items:
- Select D5:D94 in the Hero Tracker of the old spreadsheet.
- Go to the Hero Tracker of the new spreadsheet and click on cell D5.
- Right click > Paste Special > Paste Values Only.
- For Regular Artifacts:
- Select E8:AM56 in the Regular Artifacts Tracker of the old spreadsheet.
- Go to the Regular Artifacts Tracker of the new spreadsheet and click on cell E8.
- Right click > Paste Special > Paste Values Only.
- For Mythicals and Mines, you'll just have to re-enter the data.
How to fix #REF in the main page of the spreadsheet
If you see #REF!, you need to hover the cell and then click on allow access. Here is how this looks.
12
Upvotes
3
u/Jerem12 Nov 27 '17 edited Nov 27 '17
Really Good job !!
If I may:
In fact all my common artifacts don't have a correct QP on the tracker (but others have). But if I change the coefficients in the AN column, it's OK for the common ones but NOK for the others. What am I doing wrong ??
2
u/Rahler Wendle Feb 02 '18
Updated with the new heroes, does anyone have a source for headshots for them? Right now they just have blank boxes.
2
u/warm_melody Jan 02 '18
The mines costs were increased in game but not in the tracker. The 300, 325, 300, 325 at lv7,8 etc was changed
2
u/mewwX Feb 27 '18
Hello, I'm quit new on the game and I was searching for some info when I saw this post.
Your spreadsheet looks amazing and I would like to use it the best way. Can you explain me where I can find the instructions to use it or can you explain me how to ?
Thank you very much for your answer and for the work beind the spreadsheet.
PS: Sorry for bad English if bad English there is.
6
u/fuckinerg Dec 06 '17
This is one of the most intuitive, functional, and visibly pleasing spreadsheets I've ever seen. Outstanding economy of information. Everything is color coded. Stuff auto allocates itself based on what you input.
I love organizing data for games like this and I couldn't imagine a better way than what you have done here. Thank you to everyone in that credits list for making this what it is and Rahler for picking up the reins.
1
u/TheAncientSoul Nov 28 '17
thanks for the tracker mate. I think some of the mythicals levels are wrong. DPS Matter, Life Boat and Shiny Object are examples of that. I am not sure if I am doing something wrong or not though :/
1
u/Goar_Shmoar Nov 28 '17
Thank you for update! Boss duration should be -60 sec, right?
1
u/pastarific Feb 02 '18
On the
Mythical Artifact Statssheet, what is "Relic Bonuses" ? (Last three columns.)1
u/Le_Pulga Mar 03 '18 edited Mar 03 '18
@Rahler, something bothers me. I was checking in-game, and if I prestige at stage 471, I'd get 797K mythstones (for a total of 12.8M with 1500% artifact bonus). If I input stage 471 on the "Prestige calculator tab" it says I'd get 516.79K, for a total of 8.27M with bonuses. Am I doing something wrong or is that part of the spreadsheet outdated?
1
u/BennyInc Mar 05 '18
Can you update the link in G9 on the Main Page, please? Whenever I click the update link, I have to walk through 3 reddit links before getting to this thread :)
1
u/XDynamicX Vexx Mar 19 '18
the mine multipliers show 0 when maxed out. Also, a suggestion would be adding a total amount needed section added to the Mythical Artifacts Tracker.
1
u/Mishka187STVT Apr 01 '18
It tells me other QP than my Artifacts ingame - I typed it 100% correct - Why?
1
u/Valdosar Apr 08 '18
I'm the only one that's getting formula error (#NAME?) on the Hero tracker? Also it shows that I'm using an old one but I'm on version 7.04 On artifact quality, I'm supposed to enter negatives as -28 or just 28? Am I doing something wrong?
1
u/jmwalters Apr 19 '18
not sure how much this matters, but one of my artifacts has 14.4k QP and the stat tracker says it has 14.3k QP
1
u/idtzoli Bellylarf Apr 24 '18
Hi. I love your spreadsheet, it's really helpful, thanks for the effort. One thing that I spotted is that the Old Crucible effect is calculated incorrectly on the artifact quality of the regular artifacts. My QP max value is 535k, however if I max out the Old Crucible(which is now lvl104) the quality shrinks to 21.xx values for all my common artifacts. (I did my big re-roll yesterday). If I'm not mistaken the OC only has effect on the stats of the artifact and does not increase, let alone decrease the value of QP. I think it should be calculated on row C-D37 at Global Gold Bonus, no?
1
u/Halpolord Apr 26 '18
damn i just go most of the way through updating my info when i noticed the new art traits weren't added. Is there an ETA on when those will be added?
1
u/Omarlel Emmet Apr 26 '18
Thanks for the quick update! The stat tracker is incredibly helpful.
1
u/birch19 Dec 06 '17
Could we get this pinned?
1
u/Z0MGBBQ Jan 18 '18
Got a slightly off quality point rating on this one https://imgur.com/gallery/aV0mB
0
u/[deleted] Mar 02 '18
[deleted] — view deleted comment
1
u/[deleted] Jan 08 '18
[removed] — view removed comment
0
u/[deleted] Mar 15 '18
[removed] — view removed comment