Wannaskipandlaugh is correct- I have to manually update it. In the yellow column, you will/should see a formula of =SUM({}-{}). So, For Jolly being #12 on the list, her formula in the yellow column should read as =SUM({B12}-{C12}), the B being the SW and C reflects WK 1 WI. So for WK 2 WI, you'd change the C12 to D12 to reflect WK 2's WI. Does that make sense? Sorry, I'm not very good at explaining things!
My apologies on lacking on updating the yellow columns regularly. I was frustrated a bit because some people keep messing with the last 3 columns (orange, yellow, red) and that meant I had to continually fix whatever they changed as well as update their current progress. For my sanity, please do not adjust the columns (especially yellow!) unless you know how.
Way to go on the losses, everyone!!! If you're stalled or have gained, don't worry! Just get back on track and keep doing what you're doing- IT WILL COME OFF!!!
PS- Jolly- thank you sooooo much for starting this challenge!!!!!!
I had such a better week for me even with TOM here so I am hoping for a good WI!!!
Have a great weekend, everyone!