Here is my Excel tracker for 1000 Heroz. Only the rank, score, and time columns are editable in the data tab. My data is in there. The tracker will give you your averages for those three things over each Age and Time (the 20 day periods in each Age) as well as the number of 1st, 2nd, 3rd place finishes, top 5, top 10, top 20, and the last day you hit 1st, 2nd, and 3rd.
You can delete my info and enter your own. Ensure you enable macros for it to work its magic. (the magic is defined as the lookup for last days for 1st, 2nd, and 3rd as well as the pivot table auto-refresh).
This is version 1.0. If you encounter any problems, let me know and I'll work on them. If you have a suggestion to be added to the stats page, I'll see about implementing it.
Only downside I see right now is I'll need to release another version for each Age as RedLynx does not have the Ages or Times for each Age set yet. **any dev want to give me that info, if it's available, so I only need to do bug fixes and feature development?**
**edit: v2.1 http://www.filedropper.com/heroz21_1 fixed pivot table access**
Another edit: Special thanks to Nytmair for initial testing and suggestions.
You know what would be cool. If the excel file automatically accesses game center to retrieve your info, but i dont think you can login to gamecenter over a desktop. Then again the scores arnt tied to gamecenter anyway, so there's that.
What would be better is if RedLynx had an online stats tracker for us...Originally Posted by pattyx7
But for now, this excel is amazing IMO.
You haven't played with the new and improved version yet, NM...Originally Posted by Nytmair![]()
True!! I'll hit it up in the morning when I can transfer all of my stats to itOriginally Posted by TheRobZ![]()
I don't have excel, so I guess I'll put something together in Google Docs.
Just use a windows live account and try excel online...
Great work, Robz!! Now if only I had some lackey to put in all my scores![]()
I can't say I've tried this method. Does it work, Rene? I would think there might be issues with the VB code and pivot tables...Originally Posted by xXDonReneXx
Haven´t tried it myself yet. Just came to my mind, since I use Office online pretty often.Originally Posted by TheRobZ