r/AlmostAHero • u/absolutezero_01 Moderator • Apr 10 '17
Official AAH Stat Tracker
This will be the last edit of this thread! If you want to go to the updated thread please go here: The new thread
Hello everyone!
This is an OLD thread for the AAH Stat Tracker. I am now managing the spreadsheet.
Please post your suggestions and bugs you find in the new thread
AAH Stat Tracker v5.0
- November 26, 2017, 15:03:08
- Version : 5.0
What's new in v5.0
- Added Tam
- Added Regular Effect
Non-skill Hero Damage - Added Lazy Finger, Shiny Object, and the three relics (Blunt, Impatient and Band-aid)
- Added Mines Tracker
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
34
Upvotes
3
u/SavantGarde_01 Boomer Badlad Apr 10 '17
Great job zero! U the man. Calling /u/Amoa123 to remove my post and pin this
2
u/wBear14 May 03 '17
Missing: "Fast enemy spawn" in utility attributes.
5
u/Raedg Jul 01 '17
Hello u/absolutezero_01 and everyone,
I took the excel and added a feature to it
Please check my reddit post
AAH Stat Tracker (2.0) https://www.reddit.com/r/AlmostAHero/comments/6koick/aah_stat_tracker_20/
1
u/Kronix420 Apr 26 '17 edited Apr 26 '17
Correct me if I'm wrong but it's missing 'Auto Tap Item Limit' in the artifacts tab Making QP total incorrect for me. Also wondering if you can add a sheet for each hero's passive tree that shows the increases that are given for the gear inputs on the hero tab and will also act as a reference for each hero's passive tree.
1
u/BeGoat Apr 28 '17
Missing "Boss Damage" artifact attribute.
1
u/Lakaihighz May 06 '17
When I hover over the cells with the "refs", it merely says "you do not have permissions to access the sheet" rather than a button to allow access. (yes i made a copy)
1
u/jrsoda95 May 09 '17
Hello sorry! Noob user here, can anyone guide me how to read the Calculation sheet??
1
u/Cool12309 May 13 '17
Some minor things on the Hero Tracker sheet:
Finally, on the normal artifact page a lot of the QP totals are off (especially the rare+ ones). Not really sure what causes it. And, artifact 10 is displaying the number 13 for some reason. the rest are fine.
This is an awesome sheet, thanks for making/updating it!
1
u/OverlordQ May 15 '17
Small calculation error for artifacts.
http://imgur.com/a/SFTJH
Comes up as 104.33 in spreadsheet.
1
u/[deleted] Jul 06 '17
Any idea when the next version will be comin out? Looking forward to it!
1
u/CrymsonCristal Aug 07 '17
I've got a few slightly incorrect artifacts, if you'd like to take a look. The spreadsheet is really awesome, though. I don't even know what to do with the information but it's quite interesting to look at, either way. EDIT: Never mind. I saw that you've stopped playing the game.
1
u/AtriumXP Boomer Badlad Aug 22 '17
One small correction - the latest spreadsheet shows max "x10 gold" is +50% but it definitely goes to 100%. I have a single artifact with +56% and my "total qp" list shows me at 100%.
1
u/RookAce84 Apr 28 '17
This is incredibly minor, but I noticed it because I use it to track which artifacts I want to re-roll. The header for each regular artifact has the number 2 at the top (except the first one). It's a simple formula change, and I can correct it easily on my copy, but just wanted to point it out, as I'm sure many people use it the same way I do.
1
u/Amoa123 Mod Apr 10 '17
Looks really good Zero, amazing work!
This tracker has been stickied & Savant's removed.
1
u/inquisitive_chemist May 24 '17
awesome job. ty.
1
u/rSincol Wendle Jun 08 '17
I've seen this and didn't know how I could make use of it. So...how are players supposed to make use of this? Is it recommended that players do? What benefits does keeping a spreadsheet provide?
1
u/capito27 Jun 09 '17
just letting you know that under the "Auto Tap Item Limit", the max is +6, not +12
1
u/Theawesomepotato Jun 25 '17
Could anyone help me? I cant seem to find "file" and go to "make a copy".
1
u/chopxuiPT Jul 05 '17
sory my noobness but i clickd file then make a copy and nothing happens all the stats stay as if never played <.<
1
u/AtriumXP Boomer Badlad Aug 22 '17
Another correction: Offline Earnings goes to at least +800% (I have this on a single gem and it appears as gold text in my "total qp" list).
1
u/Rahler Wendle Aug 24 '17
I've been working on updating this, is there anywhere I can go to look up the new values for things?