Hi all,
We’ve spent the last 2 days indoors here in southeastern Wisconsin, so I thought I’d share some of my work. I threw this together while the team was discussing how to play the game this weekend.
It is a teleoperated score simulator. The base assumption of the sheet in general is that cycles are starting at the buzzer between auton and teleop. It is read-only but you should be able to make a copy of it and edit it to your heart’s content.
The cells you want to modify are the average times for each task and the percentage chance of the scoring tasks happening. (Use logic for the % chances and your estimations, as some of the existing “cycle types” logic can fall apart if you aren’t realistic)
Extending the spreadsheet is pretty easy. If your team has a different idea of how to divide the timing of different tasks, you can add or modify those rows. If you have another cycle style, you can add a row down there, and the only formulas you should have to manually do are the total time and points/cycle.
The sheet shows both an average calculation of cycles and points, as well as one with the number of cycles rounded down.
The sheet also has an area that automatically sorts cycle types based on their performance from the numbers you enter.
The major issue I can currently see on the sheet is that it does not count truss/catch points earned “before the buzzer” but not before the end of a cycle. It should still be a decent estimation, though.
It helped us a lot during brainstorming and strategy discussion, and we are excited about the possibility of even using it at competition, if we can more accurately estimate task times, to see if certain cycle types might be more or less viable depending on the alliance makeup.
Feel free to ask me any questions about the sheet.
I don’t intend for this topic to be a debate about the current numbers in the sheet, so please take those as example numbers.