How do you suggest accomplishing this (in Excel)? I tried every possible way I know of to avoid having people to do it manually. As I do with every tool I deploy. I'd love to offer an unlocked, unhidden copy of the spreadsheet for you to edit and teach me another way as I've exhausted all ways I know.
Taking words at their face value - "Simply" also doesn't show much appreciation.
I'm taking this a bit personally simply because I've put in many hours in developing these tools for the betterment and enjoyment of the league for everyone else on my own time. So yes, when the complexities of these tools are overlooked and simplified, I take some of it to heart.
Let's drop it. If next season doesn't meet your standards, no one will force you to participate. Other leagues are popping up.