There are some reference errors in the totals sheet.
For Acszdf, the category 1 reference cell is wrong. There are many more e.gs.
Oh, you spotted that! Props for being thorough.
You're right, and let me explain why. I don't have the programming skills to whip up a script that would have dished out the correct references quickly. So, the references you see in the list book - both correct and incorrect - were put there by me by hand.
I actually rushed the first version of the distro list by putting in raw numbers in the Rich List instead of references. That decision actually cost me a full day during revision week, because I had to put in the references and check them.
With that done, I turned to the Totals sheets - and realized that, given my lack of programming skills fit for an .xlsx file, I would be a lot longer making sure that the references to Category 1 were accurate in terms of cell numbers.
So I punted again, on the grounds that the values would be the same no matter what. The references would be inaccurate, but the numbers themselves wouldn't be. All because I didn't have the programming skills to whip up a script that would ensure both kinds of accuracy.
Your criticism is accurate. Had the distro list been my "Independent Project" for an Excel course, I would have been down-marked for precisely that reason. And for one other: if you look in Category 1, you'll see that the values of each stake are all raw numbers. The others are references, and the Category 1 numbers should be too.
But I had to make a call given my limits, so that's why the book ended up the way it ended up.
