2020 Game Simulation Spreadsheet
Overview
Hi everyone!
I thought of the idea of creating a spreadsheet which calculated the points of a match for you while going through strategy with my team and trying to do it in my head with some difficulty. So, I learned how to “program” in Google Sheets to make this a reality. In the spirit of gracious professionalism, I figured I would share this since I think it is pretty useful.
How To Use It
- Click here to go to the Google Sheet.
- Go to File > Make a Copy to get your own version which you can edit.
- Edit the white cells to change the inputs for the simulation. Team colored cells are calculated by the spreadsheet, and black cells do nothing.
Details and How Inputs Work
- A “cycle”, as referred to in row 2, is a concept I made up (someone has probably done something similar) in which during a certain amount of time (which is inputted by the user, in seconds), a robot will pick up 5 power cells, move from where they picked them up to where they are dropping them off, and drop them off. The robot starts with no power cells and ends with no power cells. The time that is inputted for this should be an overall average amount of seconds that a robot takes to complete this task, in the teleoperated period. This system is not used for the auto period.
- “Climb Time” is the number of seconds left in a match when a robot has to stop cycling power cells to begin the climb sequence.
- “Control Panel Time” refers to the total amount of time it takes for the robot to complete whatever combination of either rotation control, position control, both, or none (the time would be 0 if none). Example: A robot takes 10 seconds to do rotation control and 15 seconds to do position control. If the robot only did position control that game, “Control Panel Time” would be equal to 15.
- Rows with a “?” at the end are boolean (yes or no question). Use 1 for yes and 2 for no. These inputs are not a question as to whether the robot can do said action, but if they did it in that match. Example: Multiple teams on the same alliance should not have a “1” in the “Rotation Control” row because it can only be competed once.
- The percentages for the different power ports simultaneously account for how much a robot shoots in each different location, and how much the robot misses. If the percentages don’t add up to 100%, you have simulated the robot missing some shots. Example: The “Percent PCs Scored” cell is 90% for Team 2. That means that Team 2 missed 10% of their shots overall. Unfortunately, I haven’t made it so you can have a different accuracy depending on which port is being shot at because I’m new at this. Feel free to add it if you know how and reply to this topic because I would like to know. (Note: Don’t make the “% PCs Scored” greater than 100% because that’s impossible.)
- “PCs” is Power Cells
Thanks for reading my post and good luck with your robots! May the force be with us all!