Quote:
Originally Posted by Paul Copioli
O.K. here it is. this version just has the raw data entered by the students from the sheets, a summary sheet, and our "list" as of Friday night. There were a lot of moves made on Saturday morning based on individual robot performance. How teams play when it really counts is hard to capture in a Friday night list.
The summary sheet uses Excel Pivot tables and if you know how to use them are very powerful. I have set it up to show # of moon rocks scored and +/-. The number of MR scored is not points, but moon rocks. If you want points, then multiply by 2. The +/- is based on points and is The number of points scored by the robot minus the number of points in the robot's trailer (including Super Cell Points).
Here is my list of disclaimers:
1. If anyone complains about not being on the list or anything regarding their spot on the list, then I will never post something like this again.
2. If anyone disputes the number in any category, then I will never post something like this again.
3. The list is not personal. The list is purely statistics based. Some very close friends of ours are not even on the list.
4. The Auton speed is related to our auton speed. medium is basically the same as us, fast is faster than us ... you get the point.
|
We're not on your list!! What gives....wait, we were in Archimedes.....
Thanks for sharing, Paul. I know I'll be looking into your pivot table "magic".
