You can now choose the Morrella Method (Winner gets lesser of Looser's unpenalized score and winner's penalized score) and the Update15 Method (Winner gets Lowest Unpenalized Score)
This sheet limits the QP points that a team gets to their OWN QP points if a penalty caused the other team to loose -- per Morrella via a phone call, winning alliance gets the LESSER of their opponents unpenalized QP poi...
This spreadsheet takes raw match data (teams participating, scores, and penalties) and produces calculates the RP and QP for each team. The spreadsheet is initially populated with data from the Florida regional.
At the Finger Lakes regional, the ranking system wasn't working throughout Friday, a...
I have noticed at least a couple of threads lately on how to make sure your arm structure can take it. This is a spreadsheet I developed for my own use that provides a quick estimate of what options are readily available.
If somebody wants to continue expanding the data base I won't object, but...
1. Stacked and Contained Tetras for each goal
2. 10 pt. bonus for each row (yes, I figured out how to calculate ownership into rows and equal a bonus...)
3. 10 pt. bonus for all 3 bots in end zone (TOUCHDOWN!)
4. Penalty Deduct...
I created a spreadsheet template for the various entries into the 2005 Chairman's award. This way, we can draft our team responses prior to uploading them in the official awards web site.
Feel free to use this template for your team. Please note that I believe I copied all the instructions off...
I created a Excel spreadsheet template for our team this year to brainstorm and formulate the answers to the questions for the Judge's yearbook. The final submission will be done by our leader in the TIMS system, but we though that a good template would be useful in passing-around ideas before the...
This is a tool I use to get my chain adjuster travels right and to give my "gut" a chance to "see" the chain path before I commit to it in metal (I like to judge the amount of chain wrap around a sprocket visually).
It is not a perfect tool. It does not have any way to en...
Well, the other night a fellow CDer asked for some help in making a scoring setup for FLL. This is what I came up with, good for 15 matches (with potential for more, if you work with it). It assumes you know how to navigate between sheets and sort columns.
Since Alex469 posted his updated map of the number of teams in each state, I figured the next logical step was to find the distribution over the population of each state.
As the deadline for registration approaches, I'll try to remember to update this.
Here's some of the data I gathered throughout the regional season. I have data on every team that competed at every regional event throughout the 2004 season.
There's a separate master sheet that can be sorted by division, or can be used to compare all the teams in the nation.
After watching the webcasts of the VCU comp, I noticed how important the penalties are to the game, so, I've ADDED a penalty column to my spreadsheet. ALSO- I recently bought a PocketPC, so, I've made an Excel spreadsheet that is a little more compact so it fits easily on a PDA screen. Both file...
For the person looking to play with the 2003 FIRST Financials, provided in the 2003 Annual Report here:
http://www.usfirst.org/about/2003/annualreport2003.pdf
First tab is the working formulas, the 2nd tab is percentages and analysis.
Having the ability, opportunity, and inclination to do manual labor makes you a better engineer. - MrForbes [more] 
