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.Originally Posted by Nytmair
Number 4 shouldn't have happened. There is no other passwordI'll test on some different computers and see what's gong on.
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.Originally Posted by TheRobZ
I downloaded the current link on my home laptop and did not get the password prompt. Odd.
Updated the tracker. Let me know if you run into any issues or have feature suggestions.
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:
![]()
Now if only the devs would be so kind as to give access to all this fun data via an API...
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?