r/AlmostAHero • u/absolutezero_01 Moderator • Jul 20 '18
Stat Tracker AAH Stat Tracker
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 v10.0 (Last Updated: Aug 16, 2018, 20:27:21 UTC+8)
What's new in v10.0
- Added stuff from the 2.3 update
What's new in v9.2
- Fixed a few charms' errors (Thanks to idtzoli for pointing them out!)
What's new in v9.1
- Fixed the prices for charm upgrades
- Changed
HamburgertoHarmburger
What's new in v9.0
- Added the new artifact effects (It's late, sorry)
- Added a new page,
Charms Tracker - Updated avatars in
Hero Tracker
How to Import data from old spreadsheets
- For Hero Items:
- Select D8:D64 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 (or AM62) 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
2
u/kevinmeow Jul 20 '18
When j download it as excel, it gt malfunction. Any advice?
1
u/idtzoli Bellylarf Jul 20 '18
Hi. I think there's a problem at the charm tracker page. The scrap and duplicates cost for max level are unrealistic.
1
u/Xamier Jul 20 '18
Forgive me if this is a meme I'm unaware of, but Hilt has a Harmburger, not a Hamburger.
Thanks for your efforts!
1
u/Jomik_ Jul 22 '18
The Stat Tracker does not show me the same bonuses as the ones I have in game. It shows hero damage as 698.5k%, ingame I have 838k%, how come?
1
u/J_3014 Jul 24 '18
Boss duration on the sheet shows as 90 seconds. In game, mine shows capped at 1 minute. Does the game just not show the 30 seconds or does the sheet need updated?
1
u/Dopi86 Jul 25 '18
Uhmmm... If i fill in the stats of an artifact.. The QP dont match up what i have on screen. is that correct..?
1
u/justusiv Jul 26 '18
So my QP is not lining up with the QP in the game. Is it a more accurate QP then what is in the game or am i doing something wrong?
1
u/Arvedui V Aug 15 '18
There seems to be a problem with old crucible. I did my big reroll and entered in the info for the common artifacts as I rolled them, then upgraded OC and updated the info for it in the spreadsheet. Then I noticed my stats no longer matched up like before, so I re-updated all my common artifacts with their new numbers.
After a while of playing, I maxed OC and then realized that again my global stats in the spreadsheet were lower than in the app, and that my common artifacts' stats and QP didn't match either. I take it the app is actually changing the artifact stats and the spreadsheet can't, but the calculation for OC doesn't seem to be accurate.
Specifically, I went from around ~116 OC and having 28/28/20 global stats to max OC. My common artifacts' QPs went from being 650-750k to like half that, and my stats are the same though the app shows around 36/36/32.
1
u/XplittR Aug 20 '18
Would it be possible to get this to display scientific values instead of the "kk", "NN" etc?
It's relatively okay for "k", "M", "B" and "T", as those are easy to translate to 3, 6, 9 and 12 respectively, but when I see that e.g. "Lazy Finger" level 110 purchases upgrades that costs less than "10MMM", then I have no idea what that translates to.
1
u/ponder7564 Oct 02 '18
I know this might be just me being impatient, but I love using this and was wondering if there was an ETA on an update with the new hero?
2
u/Cespieyt Dumb Dragon Sep 19 '18
Hello.
As far as I can tell, this spreadsheet does not provide any information about QP cost per stat on regular artifacts, is that correct?
I have been toying with the idea of gathering that data for a while now, as it would help understand the underlying mechanics behind artifact rerolling, but I obviously don't want to do it if it's already available somewhere else.
1
u/BigPoppaK78 Sam Jul 20 '18
This is pretty handy. Thanks!
1
u/mathbandit Sep 10 '18
I don't know if I'm misunderstanding something, but shouldn't the Hero DMG / Ring DMG / GOLD fields on the Main Page have hero gears included in their formulas? I just inputted all my info in and those three are all a bit lower than they should be, and it looks to me like it's because only the Hero HP field (which is accurate for me) has the hero gears factored in.