Math Meets Science - Balsa Bridge Efficiency Calculator - Colton

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Place	Designer	Tower Mass	Height	Mass of Water Added (Grams)	Mass of Bucket and Chains (Grams)	Total Mass Held	Efficienty Rating (Mass Held/Tower Mass)	Score (Mass Held/Tower Mass*(Tower Height-25))	Mass Tower Must Hold to be in first	How much more Mass before they are in first	Score to Beat
2	Place	Designer	Tower Mass	Height	Mass of Water Added (Grams)	Mass of Bucket and Chains (Grams)	Total Mass Held	Efficienty Rating (Mass Held/Tower Mass)	Score (Mass Held/Tower Mass*(Tower Height-25))	Mass Tower Must Hold to be in first	How much more Mass before they are in first	14791.66667	running total	0
3	1	Colton	36.0	60.5	13844	1156	15000	416.667	14,791.667	13,844.000	0.000
4	2	Eli and Blaze	25.5	50.0	2000	1156	3156	123.765	3,094.118	13,931.500	11,931.500
5	3	Bradley	32.0	40.3	5000	1156	6156	192.375	2,943.338	29,780.819	24,780.819
6	4	Danie	111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
7	5	Maddie & Rachel*	27.0	51.0	11500	1156	12656	468.741	12,187.259	14,204.577	2,704.577
8	6	Nicole and Alli	19.0	40.0	6500	1156	7656	402.947	6,044.211	17,580.111	11,080.111
9	7		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
10	8		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
11	9		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
12	10		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
13	11		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
14	12		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
15	13		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
16	14		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
17	15		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
18	16		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
19	17		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
20	18		111.0	26.0		1156	1156	10.414	10.414	1,640,719.000	1,640,719.000
21	19		111.0	26.0		1156	1156	10.414	10.414
22	20		111.0	26.0		1156	1156	10.414	10.414
23	21		111.0	25.0		1156	1156	10.414	0.000
24	22		111.0	25.0		1156	1156	10.414	0.000
25	23		111.0	25.0		1156	1156	10.414	0.000
26	24		111.0	25.0		1156	1156	10.414	0.000
27	25		111.0	25.0		1156	1156	10.414	0.000
28	26		111.0	25.0		1156	1156	10.414	0.000
29	27		111.0	25.0		1156	1156	10.414	0.000
30	28		111.0	25.0		1156	1156	10.414	0.000
31	29		111.0	25.0		1156	1156	10.414	0.000
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100