Math Meets Science Bridge Efficiency Excel Spreadsheet

	A	B	C	D	E	F	G	H	I	J	K	L
1	Place	Designer	Bridge Mass	Mass of Water Added (grams)	Mass of Bucket and Chain (grams)	Total Mass Held	Efficienty Rating (Mass Held/Bridge Mass)	Mass Bridge Must Hold to be in first	How much more Mass before they are in first	Effieciency Rating to Beat
2	Place	Designer	Bridge Mass	Mass of Water Added (grams)	Mass of Bucket and Chain (grams)	Total Mass Held	Efficienty Rating (Mass Held/Bridge Mass)	Mass Bridge Must Hold to be in first	How much more Mass before they are in first	1,121.684	Running total of water held	0
3	1	Rachel	9.5	9,500	1,156	10,656	1,121.684	9,500.000	0.000
4	2	Matt 2	12.8	10,500	1,156	11,656	910.625	13,201.558	2,701.558
5	3	Matt	12.0	8,000	1,156	9,156	763.000	12,304.211	4,304.211
6	4	Shea	20.0	13,844	1,156	15,000	750.000	21,277.684	7,433.684
7	5	Shea 2	19.5	12,000	1,156	13,156	674.667	20,716.842	8,716.842
8	6	Marek	16.0	9,500	1,156	10,656	666.000	16,790.947	7,290.947
9	7	Ethan 2	10.0	5,000	1,156	6,156	615.600	10,060.842	5,060.842
10	8	Sam	6.5	2,500	1,156	3,656	562.462	6,134.947	3,634.947
11	9	Caleb Jakob	10.3	4,000	1,156	5,156	500.583	10,397.347	6,397.347
12	10	Ethan	11.0	3,500	1,156	4,656	423.273	11,182.526	7,682.526
13	11	Anna Lauren	12.0	2,500	1,156	3,656	304.667	12,304.211	9,804.211
14	12	Josh H.	10.5	2,000	1,156	3,156	300.571	10,621.684	8,621.684
15	13	Mitchel Camden	18.0	4,000	1,156	5,156	286.444	19,034.316	15,034.316
16	14	Payton Brady	9.5	1,500	1,156	2,656	279.579	9,500.000	8,000.000
17	15	Jordan Griffen	6.3	0	1,156	1,156	183.492	5,910.611	5,910.611
18	16	Makenna Alyssa	12.0	1,000	1,156	2,156	179.667	12,304.211	11,304.211
19	17	karissa	13.1	500	1,156	1,656	126.412	13,538.063	13,038.063
20	18	Sam Tylor	12.5	2,000	1,156	3,156	252.480	12,865.053	12,865.053
21	19	Zach Zach	13.3	2,000	1,156	3,156	237.293	13,762.400	13,762.400
22	20	Chris	15.8	8,500	1,156	9,656	613.079	16,510.526	16,510.526
23			111.0		1,156	1,156	10.414	123,350.947	123,350.947
24			111.0		1,156	1,156	10.414	123,350.947	123,350.947
25			111.0		1,156	1,156	10.414	123,350.947	123,350.947
26			111.0		1,156	1,156	10.414	123,350.947	123,350.947
27			111.0		1,156	1,156	10.414	123,350.947	123,350.947
28			111.0		1,156	1,156	10.414	123,350.947	123,350.947
29			111.0		1,156	1,156	10.414	123,350.947	123,350.947
30			111.0		1,156	1,156	10.414	123,350.947	123,350.947
31
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