Guide
Los Altos FLL 2003: MISSION: MARS
Scoring Spreadsheet Guide
Directions:
Make a backup copy of this spreadsheet right now.
Do not run any other spreadsheets while you run this one.
Make Sheet Tabs visible at the bottom of the screen by clicking Tools, Options, and the Sheet Tabs check box.
Click View, Zoom…, and experiment with different magnifications to arrive at a screen output that projects well.
Refer to this instruction screen often.
Frequently click save during the competition.
" Teams " is the place to enter team numbers and names.
In Teams, enter team numbers and names in the order of arrival on site, and then press enter.
" Scrimage or Competition Scoring " is the place to tally the data from each Ref Sheet when it
comes to you.
Before the tournament, print the Ref Sheet, make one copy per table pairing per round, and give them to the referees on clip
boards.
When a referee hands you a Ref Sheet, enter the data, line for line, as you see it in each box.
Be sure to type Enter after every entry (necessary for the spreadsheet to function).
When you're finished, note the score and write it in pen on the Ref Sheet. This is a hardcopy backup system.
Then go to the Scoring Poster and with a marking pen enter the score and results for the correct team in the correct
round/match.
" For Competition Scoring " There is a macro included that will seed the teams for the Payoff
round. For the Quarter Finals and Final round the scorekeeper enters the match winners manually.
After the A through D rounds scores are input and checked press Control Key and the "O" key at the same time and the
spreadsheet will automatically seed the teams moving on to the Playoffs.
After the Playoff round scores are input and checked the scorekeeper enters the winners of each match into the quarter final
table.
After the Quarter Final round scores are input and checked the scorekeeper enters the names of the quarterfinal match
winners into the finals table
If you print extra blank Ref Sheets and have them available near the Scoring Poster then the teams can record their own
results.
Page 1
Guide
" Overall " is the place to enter each teams highest score achieved during the competiton and the
results of each of the judging categories.
WHEN THE DAY IS DONE
Celebrate a job well done with your team and coaches!!!!
Page 2
els
he
ff
e
O
ne
ne
e
W
y
et
e
er
ul
pt
ot
ul
Li
Li
Drop
On
se
pl
at
y
t
Playoff Seeding
od
In
Em
Ou
od
ob
el
s
lly
Ba
m
in
in
Cr
re
Control O to select seeds
M
List Macro A to sort by position Macro B to sort by position Macro C to sort by position Macro D to sort by position
+
et
s
M
R
Co
s
ia
er
Co
es
es
ed
r in
er
in
ne
pl
ed
n,
rt
Area
e
uld
ul
ul
uld
h:
m
r
nc
Du
e
ot
ve
ow
Pa
ap
ge
Ic
od
od
Bo
nc
Co
Bo
lia
ob
Ro
Sh
ff
ig
D
M
M
u
rO
Al
R
Tr
La
p
V
3
2
am
ve
Los Altos Competition Dust Cleared Free Rover Averaging Table
Ro
Launch Canister Habitation Round A Round B Round C Round D
R
SCORE Boulders
List Performance (Rounds Only) Rank Performance (Rounds Only)
MISSION: MARS Score Sheet Max 400 39 39 27 39 43 31 49 31 27 43 43 31 27,31,49 14 8 Y 1 2 3 4 1 2 3 4 highest 2nd best 3rd best lowest Round A Round A+B Round A+B+C Best 3 RDS Position Team Points Position Team Points Position Team Points Position Team Points
Table Time Team Team Name AVG AVG AVG AVG
1 13.53 DogBots 176 y y y y 2 DogBots 176 199 250 136 3 2 1 4 250.00 199.00 176.00 136.00 DogBots 176 187.5 208 208 DogBots 176 DogBots 187.5 DogBots 208 DogBots 208.3
2 13.53 Earthlings 117 y y y 1 Earthlings 117 230 153 219 4 1 3 2 230.00 219.00 153.00 117.00 Earthlings 117 173.5 167 201 Earthlings 117 Earthlings 173.5 Earthlings 167 Earthlings 200.7
Table Time Team Robo Raiders 184 223 215 180 3 1 2 4 223.00 215.00 184.00 180.00 Robo Raiders 184 203.5 207 207 Robo Raiders 184 Robo Raiders 203.5 Robo Raiders 207 Robo Raiders 207.3
1 14.00 Robo Raiders 184 y y y y 2 1 Happy Hippos 158 245 131 137 2 1 4 3 245.00 158.00 137.00 131.00 Happy Hippos 158 201.5 178 180 Happy Hippos 158 Happy Hippos 201.5 Happy Hippos 178 Happy Hippos 180.0
2 14.00 Happy Hippos 158 y y y y 1 1 Marz Bars 188 174 215 188 3 4 1 2 215.00 188.00 188.00 174.00 Marz Bars 188 181 192 197 Marz Bars 188 Marz Bars 181 Marz Bars 192 Marz Bars 197.0
Round A
Table Time Team K-9 Bots 207 158 127 195 1 3 4 2 207.00 195.00 158.00 127.00 K-9 Bots 207 182.5 164 187 K-9 Bots 207 K-9 Bots 182.5 K-9 Bots 164 K-9 Bots 186.7
1 14.05 Marz Bars 188 y y y y 2 1 Red Rover 239 207 278 184 2 3 1 4 278.00 239.00 207.00 184.00 Red Rover 239 223 241 241 Red Rover 239 Red Rover 223 Red Rover 241 Red Rover 241.3
2 14.05 K-9 Bots 207 y y y y y 2 Solar Flares 153 145 194 170 3 4 1 2 194.00 170.00 153.00 145.00 Solar Flares 153 149 164 172 Solar Flares 153 Solar Flares 149 Solar Flares 164 Solar Flares 172.3
Table Time Team TigerBots 317 206 242 208 1 4 2 3 317.00 242.00 208.00 206.00 TigerBots 317 261.5 255 256 TigerBots 317 TigerBots 261.5 TigerBots 255 TigerBots 255.7
1 14.12 Red Rover 239 y y y y 2 3 1 Chaos Comets 115 155 102 153 3 1 4 2 155.00 153.00 115.00 102.00 Chaos Comets 115 135 124 141 Chaos Comets 115 Chaos Comets 135 Chaos Comets 124 Chaos Comets 141.0
2 14.12 Solar Flares 153 y y y 2 1 Ranking Tie Break POSITION Macro Area
Table Time Team 1 2 3 4 1 2 3 4 Round A Round B Round C Round D
1 14.17 TigerBots 317 y y y y y y 1 3 1 Team Name 10 155 153 115 102 Chaos Comets Position Team Points Position Team Points Position Team Points Position Team Points
2 Chaos Comets 115 y y y 1 1 DogBots 176 199 250 136 194 170 153 145 Solar Flares 1 Team 8 341 1 1 1
RANK AFTER ROUNDS
14.17 9 DogBots 59
Earthlings 117 230 153 219 8 207 195 158 127 K-9 Bots 2 Team 6 58 2 2 Robo Raiders 61 2
Table Time Team Robo Raiders 184 223 215 180 7 215 188 188 174 Marz Bars 3 Team 9 56 3 3 Happy Hippos 53 3
2 14.23 DogBots 199 y y y y 1 2 1 Happy Hippos 158 245 131 137 6 223 215 184 180 Robo Raiders 4 Team 5 49 4 4 Earthlings 39 4
1 14.23 Happy Hippos 245 y y y y 3 4 Marz Bars 188 174 215 188.03 5 230 219 153 117 Earthlings 5 Team 3 43 5 5 Marz Bars 0 5
Table Time Team K-9 Bots 207 158 127 195 4 245 158 137 131 Happy Hippos 6 Team 1 39 6 6 K-9 Bots 0 6
2 14.30 Robo Raiders 223 y y y y 2 2 2 Red Rover 239 207 278 184 3 250 199 176 136 DogBots 7 Team 10 32 7 7 Red Rover 0 7
1 14.30 K-9 Bots 158 y y y y 1 1 Solar Flares 153 145 194 170 2 278 239 207 184 Red Rover 8 Team 4 31 8 8 Solar Flares 0 8
Round B
Table Time Team TigerBots 317 206 242 208 1 317 242 208 206 TigerBots 9 Team 2 27 9 9 TigerBots 0 9
2 14.35 Marz Bars 174 y y y y 1 1 Chaos Comets 115 155 102 153 10 Team 7 0 10 10 Chaos Comets 0 10
1 14.35 Solar Flares 145 y y y 2 1
Table Time Team
2 14.40 Red Rover 207 y y y y 2 1 1
1 14.40 Chaos Comets 155 y y y 3 1
Table Time Team
2 TigerBots 206 y y y y 2 1
1 Earthlings 230 y y y y y 1 1
Table Time Team
1 15.05 DogBots 250 y y y y y y 1 1
2 15.05 K-9 Bots 127 y y y 1 1
Table Time Team
1 Robo Raiders 215 y y y y 2 2 1
2 Solar Flares 194 y y y y 2 1
Round C
Table Time Team
1 15.17 Marz Bars 215 y y y y y 2 1
2 15.17 Chaos Comets 102 y y 2 1
Table Time Team
1 15.24 Red Rover 278 y y y y y 2 3 1
2 15.24 Earthlings 153 y y y 1 1
Table Time Team
1 15.30 TigerBots 242 y y y y y 1 2 1
2 15.30 Happy Hippos 131 y y y 1 1
Table Time Team
2 15.34 DogBots 136 y y y 2 1
1 15.34 Solar Flares 170 y y y y 1 1
Table Time Team
2 15.36 Robo Raiders 180 y y y 1 2 1
1 15.36 Chaos Comets 153 y y y 2 2
Round D
Table Time Team
2 15.40 Marz Bars 188 y y y y 2 1
1 15.40 Earthlings 219 y y y y y 1 1
Table Time Team
2 15.50 Red Rover 184 y y y 2 2 1
1 15.50 Happy Hippos 137 y y y 2
Table Time Team
2 15.5 TigerBots 208 y y y 3 3 1
1 15.5 K-9 Bots 195 y y y y 2 3
Table Time Team
1 TigerBots 0
2 K-9 Bots 0
Table Time Team
1
Play Offs
Red Rover 0
2 Marz Bars 0
Table Time Team
1 DogBots 0
2 Robo Raiders 0
Table Time Team
1 Happy Hippos 0
2 Earthlings 0
Table Time Team
QTR Final
1 0
2 0
Table Time Team
1 0
2 0
Table Time Team
Final
1 0
2 0
Teams
REGISTRATION
Team #
1
2
3
4
5
6
7
8
9
10
Page 4
Teams
Page 5
Teams
REGISTRATION
Team Name
DogBots
Earthlings
Robo Raiders
Happy Hippos
Marz Bars
K-9 Bots
Red Rover
Solar Flares
TigerBots
Chaos Comets
Page 6
Teams
Page 7
Teams
Coach
Page 8
Los Altos Competition
MISSION: MARS Score Board
FLL State Championship Qu
onship Qualification Standings
Overall
Overall Award Summary
n
io
at
Award >>>
nt
or s e
ea c h n
25 T ear sig
w re
ce
E
P
R
e
an
k
O
es t D
SC
rm
25 R us
m
fo
400 AX
ob
er
M
25 R
25 P
Weight >>>
Team # Team Name RATING Overall
1 DogBots 0.0
2 Earthlings 0.0
3 Robo Raiders 0.0
4 Happy Hippos 0.0
5 Marz Bars 0.0
6 K-9 Bots 0.0
7 Red Rover 0.0
8 Solar Flares 0.0
9 TigerBots 0.0
10 Chaos Comets 0.0
Page 11
Overall
Notes
Enter Scores of 0 to 10 for
Robust Design, Research
Presentation, Teamwork.
Enter the Max Score from the
"Competition Scoring" sheet
cells AM:3-AQ:15.
Rather than redoing the
Overall Scoring spreadsheet
to only include Robust
Design, Research
Presentation, Teamwork, and
Performance categories, I set
their weightings to 25% and
the rest to 0. Michael Schuh
Page 12
s
ff
el
O
he
e
ne
ne
e
y
e
ot
et
er
W
ul
pt
ul
Li
Li
se
pl
ob
ut
y
at
od
n
Em
In
od
el
lly
Ba
O
s
in
in
om
O
Cr
R
re
M
et
rs
M
+
rs
ia
es
es
Co
d
n,
n
de
in
:C
pl
ed
de
ri
re
ne
rt
e
ow
ul
ul
m
nc
ul
e
ot
ve
Pa
ap
ch
ul
ge
Du
Ic
od
od
Bo
Co
Bo
lia
D
ob
Ro
un
Sh
ig
M
M
ff
p
Al
R
Tr
rO
La
am
V
3
2
ve
R
Ro
Score Launch Canister Dust Cleared Habitation Free Rover Boulders
Los Altos Competition 400 39 39 27 39 43 31 49 31 27 43 43 31 27,31,49 14 ea 8 ea
Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Count Count Count
Score Sheet Blank Blank Blank Blank Blank
Y or Blank
Blank Blank Blank Blank Blank Blank 1 to 3 1 to 4 1 to 4
Table Time Team
ls
ff
e
O
he
e
ne
ne
e
y
e
ot
et
W
er
ul
pt
ul
Li
Li
se
pl
ob
ut
y
at
od
n
Em
In
od
el
O
ly
Ba
s
in
in
om
O
Cr
R
re
M
et
rs
al
M
+
rs
es
es
Co
d
n,
n
de
in
:C
pl
ed
i
de
ri
e
re
rt
e
ow
ul
ul
n
m
nc
ul
e
ot
ve
Pa
ap
ch
ul
ge
Du
Ic
od
od
Bo
Co
Bo
lia
D
ob
Ro
un
Sh
ig
M
M
ff
p
Al
R
Tr
rO
La
am
V
3
2
ve
R
Ro
Score Launch Canister Dust Cleared Habitation Free Rover Boulders
Los Altos Scrimage 400 39 39 27 39 43 31 49 31 27 43 43 31 27,31,49 14 ea 8 ea
Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Count Count Count
Score Sheet Blank Blank Blank Blank Blank
Y or Blank
Blank Blank Blank Blank Blank Blank 1 to 3 1 to 4 1 to 4
Table Time Team
s
ff
el
O
he
e
ne
ne
e
y
e
ot
et
er
W
ul
pt
ul
Li
Li
se
pl
ob
ut
y
at
od
n
Em
In
od
el
ly
Ba
s
in
in
om
O
O
Cr
R
re
M
et
rs
al
M
+
rs
es
es
Co
d
n,
n
de
in
:C
pl
ed
i
de
ri
re
rt
ce
e
ow
ul
ul
m
n
ul
e
ot
ve
Pa
ap
ch
ul
ge
an
Du
Ic
od
od
Bo
Co
Bo
D
ob
Ro
un
Sh
ig
li
M
M
ff
p
Al
R
Tr
La
rO
am
V
3
2
ve
R
Ro
Score Launch Canister Dust Cleared Habitation Free Rover Boulders
Los Altos Scrimage 400 39 39 27 39 43 31 49 31 27 43 43 31 27,31,49 14 ea 8 ea
Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Y or Count Count Count
Score Sheet Blank Blank Blank Blank Blank
Y or Blank
Blank Blank Blank Blank Blank Blank 1 to 3 1 to 4 1 to 4
Table Time Team
Version Date Who Comments
1.1 Sep-03 Scott Evans Original version from Scott Evans at FLL National
1.2 Dan Fairfax
1.3 Dan Fairfax
1.4 11/11/2003 Dan Fairfax First version of Local Comp file given out for review.
1.5 11/11/2003 Dan Fairfax Fixed link to another file problem.
Updated the "Over all" sheet to include weights for the four
1.6 11/15/2003 Michael Schuh categories we are going to use.
Changed the name of the Computer Nerds to Red Rover and hid
1.7 11/15/2003 Michael Schuh unused columns in the "Over all" sheet.
Table Time Team Score
1 DogBots
2 Earthlings
Table Time Team
1 Robo Raiders
2 Happy Hippos
Round A
Table Time Team
1 Marz Bars
2 K-9 Bots
Table Time Team
1 Red Rover
2 Solar Flares
Table Time Team
1 TigerBots
2 Chaos Comets
Table Time Team Score
2 DogBots
1 Happy Hippos
Table Time Team
2 Robo Raiders
1 K-9 Bots
Round B
Table Time Team
2 Marz Bars
1 Solar Flares
Table Time Team
2 Red Rover
1 Chaos Comets
Table Time Team
2 TigerBots
1 Earthlings
Table Time Team Score
1 DogBots
2 K-9 Bots
Table Time Team
1 Robo Raiders
2 Solar Flares
Round C
Table Time Team
1 Marz Bars
2 Chaos Comets
Table Time Team
1 Red Rover
2 Earthlings
Table Time Team
1 TigerBots
2 Happy Hippos
Table Time Team Score
2 DogBots
1 Solar Flares
Table Time Team
2 Robo Raiders
1 Chaos Comets
Round D
Table Time Team
2 Marz Bars
1 Earthlings
Table Time Team
2 Red Rover
1 Happy Hippos
Table Time Team
2 TigerBots
1 K-9 Bots
ff
O
e
y
ot
et
er
pt
pl
ob
at
Em
om
Cr
R
d
n,
:C
in
re
ow
ot
ch
ge
D
ob
un
ig
p
R
Tr
La
am
R
Los Altos Scrimage SCORE Launch Canister
MISSION: MARS Score Sheet Max 400 39 39 27 39
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
# Table Time Team
1 0
2 0
Highest
Highest Highest
Most Times to Single
Average Total
the Table Round
Score Score
Score
1 bot #VALUE!
2 rot
3 tot
4 sot
ri pl
gg et
er e
R ed
am
Em
p
D pt
ow y
n,
43
R
ob
Co ot
m O
pl ff
31
et
Dust Cleared
el
y
Pa
rt
ia
49
V lly
Sh
ap
ed
31 M
3
M od
Habitation
od ul
ul e
es
27
2 in
M Li
od ne
ul
es
43
Al in
lia Li
nc ne
e
M
43
od
Ro ul
ve e
Ro ri
n
31
ve
Free Rover
rO Ba
ff se
Du
ne
+
O
27,31,49
n
Ic W
e he
Co el
s
14
re
s
Bo
ul
Boulders
de
8
rs
In
Bo
ul
de
rs
O
ut
List
Y