1. #1

    1000 Heroz Tracker

    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.
    Share this post

  2. #2

    Re: 1000 Heroz Tracker

    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.
    Share this post

  3. #3
    Nytmair's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    3,811

    Re: 1000 Heroz Tracker

    Originally Posted by pattyx7
    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...
    But for now, this excel is amazing IMO.
    Share this post

  4. #4

    Re: 1000 Heroz Tracker

    Originally Posted by Nytmair
    But for now, this excel is amazing IMO.
    You haven't played with the new and improved version yet, NM...
    Share this post

  5. #5
    Nytmair's Avatar Senior Member
    Join Date
    Mar 2014
    Posts
    3,811

    Re: 1000 Heroz Tracker

    Originally Posted by TheRobZ
    Originally Posted by Nytmair
    But for now, this excel is amazing IMO.
    You haven't played with the new and improved version yet, NM...
    True!! I'll hit it up in the morning when I can transfer all of my stats to it
    Share this post

  6. #6

    Re: 1000 Heroz Tracker

    I don't have excel, so I guess I'll put something together in Google Docs.
    Share this post

  7. #7

    Re: 1000 Heroz Tracker

    Just use a windows live account and try excel online...
    Share this post

  8. #8

    Re: 1000 Heroz Tracker

    Great work, Robz!! Now if only I had some lackey to put in all my scores
    Share this post

  9. #9

    Re: 1000 Heroz Tracker

    Originally Posted by xXDonReneXx
    Just use a windows live account and try excel online...
    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...
    Share this post

  10. #10

    Re: 1000 Heroz Tracker

    Originally Posted by TheRobZ
    Originally Posted by xXDonReneXx
    Just use a windows live account and try excel online...
    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...
    Haven´t tried it myself yet. Just came to my mind, since I use Office online pretty often.
    Share this post

Page 1 of 4 123 ... Last ►►