Cookie Mining Spreadsheet 2016 (Public Template)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDFGHIJKLMNOPQRST
1
Chocolate Chip Mining CompanyTo use this spreadsheet, you will need to make a copy and add it to your Google Drive: Select "File" then "make a copy" and click "ok". Select the file folder icon next to the name of the document and select "move this item". Select "My Drive" and then place it into the folder of your choice. You can then share this file with your students and their Goggle Drive accounts.
2
3
Owner: Liz LaRosa
4
Name of Mine: Middle School Science Mining Company
5
6
Price of Cookie$7.00
7
Size of Cookie21Squares (Area)x 4 sq meters84
8
EquipmentPriceQuantityCost
9
Flattoothpick$2.002$4.00broken tools need to be repurchased
10
Round
toothpick$4.001$4.00
11
Paperclip$6.001$6.00
12
Total cost of equipment$14.00
13
14
Mining Costs ($1.00 per minute x 5 min)$5.00
15
16
Chocolate Ore Quality
17
ChocolateValueSquaresValue
18
Pure Chocolate$2.00$0.00
19
Very Little Slag$1.5010$60.00
20
Slag$1.00$0.00
21
Too much slag$0.50$0.00
22
Value of Chocolate Ore$60.00
23
24
Reclamation Costs & Environmental Clean Up
25
Beautiful Vistas $2.00 per square removed1$2.00
26
Trees Replanted $0.25 per square removed4$1.00
27
Deer Habitat $0.15 per square removed2$0.30
28
Rich Top Soil $0.20 per square removed1$0.20
29
Water $1.00 per square removed5$5.00
30
Miscellanious costs $0.05 per total area30$1.50
31
Total Cost of Reclamation$10.00
32
33
Profit$43.00
34
35
36
Spreadsheet by Liz LaRosa www.middleschoolscience.com 2000-2016
37
38
39
40
Loading...
 
 
 
EXAMPLE
Miner 1
2
3
4
5
6
7
8
9
10
11
12
13
14