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

    Re: 1000 Heroz Tracker

    1) I suggest freezing Row 1 on the Data sheet so when you scroll down, it stays visible so you know which columns are which.
    2) My "last day" info just shows "###" for all 3.
    3) I do think it's a good idea to protect the sheet so that nothing can be altered except the input data, but maybe make it visibly easier to know what is, and what is not protected. Colors maybe?
    4) The entire sheet has a password just to open, I guess heroz and it let me in. I don't think this is necessary. (Different than the password needed to unprotect it)
    Share this post

  2. #12

    Re: Re: 1000 Heroz Tracker

    Originally Posted by Nytmair
    1) I suggest freezing Row 1 on the Data sheet so when you scroll down, it stays visible so you know which columns are which.
    2) My "last day" info just shows "###" for all 3.
    3) I do think it's a good idea to protect the sheet so that nothing can be altered except the input data, but maybe make it visibly easier to know what is, and what is not protected. Colors maybe?
    4) The entire sheet has a password just to open, I guess heroz and it let me in. I don't think this is necessary. (Different than the password needed to unprotect it)
    Numbers one, two, and three will be resolved tonight.
    Number 4 shouldn't have happened. There is no other password I'll test on some different computers and see what's gong on.
    Share this post

  3. #13

    Re: 1000 Heroz Tracker

    Row 1: Frozen
    Adjusted the column width for ### showing on last days stats
    Colors added for the Data sheet, with blurb at the top saying only to edit rank, score, and time.

    Testing still going for the password popup... anyone else experience it?
    Haven't had too much time tonight since I had to run day 151 a bunch to get a good time
    Share this post

  4. #14

    Re: 1000 Heroz Tracker

    Originally Posted by TheRobZ
    Row 1: Frozen
    Adjusted the column width for ### showing on last days stats
    Colors added for the Data sheet, with blurb at the top saying only to edit rank, score, and time.

    Testing still going for the password popup... anyone else experience it?
    Haven't had too much time tonight since I had to run day 151 a bunch to get a good time
    It did the same thing for me RobZ...the password popup thing. I thought that it was because I didn't have a registered version of excel, but honestly I have no idea. I just assumed.
    Share this post

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

    Re: 1000 Heroz Tracker

    I downloaded the current link on my home laptop and did not get the password prompt. Odd.
    Share this post

  6. #16

    Re: 1000 Heroz Tracker

    Updated the tracker. Let me know if you run into any issues or have feature suggestions.
    Share this post

  7. #17

    Re: 1000 Heroz Tracker

    The current version has the pivot table, 1st, 2nd, 3rd, top 5, top 10, and top 20, as well as the last day for 1st, 2nd, and 3rd. The next version will have:

    Share this post

  8. #18

    Re: 1000 Heroz Tracker

    Wish I could have gotten in on your table RobZ.
    Share this post

  9. #19

    Re: 1000 Heroz Tracker

    Now if only the devs would be so kind as to give access to all this fun data via an API...
    Share this post

  10. #20

    Re: 1000 Heroz Tracker

    To be included in my next update, a 9 day rolling total of your score for the 10 day leaderboard?

    I should probably get to work on a web version with a signature generator, eh?
    Share this post