Hey, I made a spreadsheet featuring all current runs on the site currently, featuring the rice donated during the run. The spreadsheet also functions as an automatic calculator to update the total rice amount and the number of people fed. The sheet uses calculations to update the totals every time a new run is added to the sheet. The sheet also has four different pages with different sorting options. The sheet does NOT include pending runs, nor rejected runs. This device can be used to monitor the total rice donated by all runs, or to view your own runs and the amount of rice you donated. This sheet does NOT function as a way to view your WR's or your placement in certain categories compared to others.
Here is a link to view the spreadsheet: https://docs.google.com/spreadsheets/d/1nVKzatgNveIKEkJcTKC2ONjOC7earWXd6wEAjsHWKgM/edit?usp=sharing
And mods, if you wish, I can send you a editors link so you can add runs when they are submitted/approved.
UPDATE 1: ADDED AN AUTO SORT FEATURE! Now just add the run to the bottom of the "Add New Runs" page and it will auto sort it correctly into the 4 other pages.
UPDATE 2: ADDED RUNNER TOTALS! Now you can view your own personal total rice count, the people you fed, and the progress you made until feeding your next person. This also autosorts with the "Add New Runs" page, so no additional work is needed. To qualify for this personal total rice count, you need to submit over 10 runs to the site. I would most likely add you once you do, but if I haven't, feel free to leave a reply in the forum or DM me. Remember, this personal rice count is NOT to see how many WR's you have, and your placement among other people. However you can view how many runs you have submitted, which categories you ran, and the rice donated from the run.
UPDATE 3: ALL RUNS INCLUDED! Total Rice Count is now accurate and all submitted runs are now included!
Superb! I keep a personal spreadsheet for new runs -- if you keep this up to date that would be a great tool for verifiying rice counts and other information. Yours looks a lot better than mine, too! Once our rice counts match, I'll post the link (with credit to you) in my "Running Total of Rice" post for people to check out :D
Right now it looks like we differ in count -- I have 2800 more grains. When you grab data about runs, you should go to users' speedrun profiles and click "Show Obsolete." What shows up is current records along with previous world records. If you've already done that, I'm not sure why our counts would be off, so let me know!
Yes I have done that. Does your spreadsheet count rejected runs? Because I didn't include mine or any other rejected runs. If not, the only possible thing I can think of is the pending runs that are not yet approved, which is unlikely. I can also give you a editor's link to the spreadsheet if you wish. Operating it is very simple. Just add the latest run to the bottom of the "Add New Runs" page, and it should auto sort is distribute to every other page. I can always keep my eye on it just to make sure no glitches happen.
That's a good idea, yet it would be another step for me in verification, so I'm not sure yet.
No pending or rejected runs are counted. One way to check your runs is to go to "Statistics" below the forum. It has a count of all the runs verified. Currently there are 174 verified. In my spreadsheet, I have 174 -- I was missing one of Jay's runs but found it and added it. Make sure you are at the number listed in stats with no duplicates :D I'd suggest keeping run times in your sheet so you can easily check for duplicates. Let me know once we match!
For reference, here is the number of runs per player. This might help :) Oxknifer 5 hi_im_airman 34 Jaychalke 66 HowDenKing 2 RvBAidan 5 The_Munch 13 Zachoholic 1 BigDaddyDouglas 1 oddtom 1 ro_money 14 IdahoJacket 10 GuffMcGufferson 1 WarriorTYS 12 NathanScott 8
Thank you for the help. I was missing some obsolete runs from Oxknifer's, hi_im_airman's, and RvBAidan's toatl runs. The number now matches with your total number of rice. Jaychalke on my spreadsheet has 67 runs, while you stated he only has 66. Is that the one run you missed, or did you add that already? Anyways it should be all updated now.
I still have 66 runs by him, after updating. You should delete one duplicate run from Jaychalke -- it was Math 100 grains, All Subjects. I just rejected it and deleted it from my spreadsheet. Was that the problem?
Edit: Love the updates announcements!! Edit 2: Looking at your list I don't see a duplicate so I'm not sure what's up... Do the counts for the rest of the players add up to their totals?
I found the error. One of the 1K grain runs were for hi_im_airman, however I put it down for Jaychalke. It's fixed now and the rice counts match up now.
Definitely keep updating! I will put a link in my rice count post.
Also, Warrior -- if you get a chance, it would be great to have you in the Discord server: https://discord.gg/CcqRdrw
(Anyone else reading this, having done runs or not, please join us on the Discord!)
