calc co2 worksheet by 0XJKdI

VIEWS: 4 PAGES: 16

									The following MS Excel document includes the equations and calculations for the carbon
dioxide cost of a batch of cookies. The color coded boxes in the 'Student Sheet' can be filled out
by students according to their cookie recpie. Carbon dioxide emissions will be calculated for the
students depending on their imput values. The 'Example' tab contains a completed version of
the 'Student Sheet' where the values from the Case study are placed into the spreadsheet. The
final tab 'Reference Info' has the data used in every calculation, the density of each ingredient
as well as the carbon dioxide emissions for each type of freight transportation.


Source for 'Reference Info' sheet:
http://timeforchange.org/co2-emissions-shipping-goods
http://www.aqua-calc.com/page/density-table

Recipe Source:
Laurie Thurston's Kitchen
Student Calculations                    Guided Steps for the Excel Sheet
                                        1. Have the recipe ready, as well the student worksheet with food miles completed
                                        2. Start by filling out the yellow boxes with how much of each ingredient the recipe re
                                        3. Next fill out the blue squares with how many miles each food ingredient travels. Ch
                                        The rest will calculate itself for you, just repeat and compare!

Table 2a - Option A
                          Amount of      Mass of
Cookie Ingredient      Ingredient Used Ingredient (g)                                Distance Traveled (miles)
                         (cups or tsp)                      Train            Truck
Flour                                  0                0                0                  0
Sugar                                  0                0                0                  0
Brown Sugar                            0                0                0                  0
Egg                                    0                0                0                  0
Butter                                 0                0                0                  0
Vanilla Extract                        0                0                0                  0
Chocolate                              0                0                0                  0
Baking Soda                            0                0                0                  0
Baking Powder                          0                0                0                  0
Walnuts                                0                0                0                  0
Pecans                                 0                0                0                  0
Macidamia Nuts                         0                0                0                  0
Peanutbutter                           0                0                0                  0
Salt                                   0                0                0                  0
Oatmeal                                0                0                0                  0




Table 2b - Option B
                          Amount of     Mass of
Cookie Ingredient      Ingredient Used Ingredient (g)                                Distance Traveled (miles)
                         (cup or tsp)                       Train            Truck
Flour                                 0                 0                0                  0
Sugar                                 0                 0                0                  0
Brown Sugar                           0                 0                0                  0
Egg                                   0                 0                0                  0
Butter                                0                 0                0                  0
Vanilla Extract                       0                 0                0                  0
Chocolate                             0                 0                0                  0
Baking Soda                           0                 0                0                  0
Baking Powder                         0                 0                0                  0
Walnuts                               0                 0                0                  0
Pecans                                0                 0                0                  0
Macidamia Nuts                        0                 0                0                  0
Peanutbutter                          0                 0                0                  0
Salt                                  0                 0                0                  0
Oatmeal                               0                 0                0                  0
ent worksheet with food miles completed
h how much of each ingredient the recipe requires (ie: 4 cups of flour would be entered as 4)
 many miles each food ingredient travels. Chose how many miles with each mode of transportation that is most likely for each ingredient
epeat and compare!




 Distance Traveled (miles)                             CO2 Emitted
           Plane                   Cargo Ship           (g of CO2)
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -
                               0                   0            -

                                   Total CO2 (g)              0.00


                                                       CO2 Emitted
 Distance Traveled (miles)                              (g of CO2)
           Plane                   Cargo Ship
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
                               0                   0           -
Total CO2 (g)   0.00
n that is most likely for each ingredient
Case Study Calculations

Table 2a - Option A
                          Amount of        Mass of
Cookie Ingredient      Ingredient Used Ingredient (g)                        Distance Traveled (miles)
                         (cups or tsp)                   Train       Truck
Flour                                1.75          227.5         0                964
Sugar                                0.33             66         0                  0
Brown Sugar                              0             0         0                  0
Egg                                      0             0         0                  0
Butter                                 1.5         169.5         0                971
Vanilla Extract                          1          4.33         0                  0
Chocolate                                0             0         0                  0
Baking Soda                              0             0         0                  0
Baking Powder                            0             0         0                  0
Walnuts                                  0             0         0                  0
Pecans                                   0             0         0                  0
Macidamia Nuts                           0             0         0                  0
Peanutbutter                             0             0         0                  0
Salt                                     0             0         0                  0
Oatmeal                                  0             0         0                  0

                      Total mass (g)                 467


Table 2b - Option B

                          Amount of       Mass of
Cookie Ingredient      Ingredient Used Ingredient (g)                        Distance Traveled (miles)
                         (cup or tsp)                    Train       Truck
Flour                               1.75           227.5         0                 90
Sugar                               0.33              66         0                  0
Brown Sugar                             0              0         0                  0
Egg                                     0              0         0                  0
Butter                                1.5          169.5         0                 15
Vanilla Extract                         1           4.33         0                  0
Chocolate                               0              0         0                  0
Baking Soda                             0              0         0                  0
Baking Powder                           0              0         0                  0
Walnuts                                 0              0         0                  0
Pecans                                  0              0         0                  0
Macidamia Nuts                          0              0         0                  0
Peanutbutter                            0              0         0                  0
Salt                                    0              0         0                  0
Oatmeal                                 0              0         0                  0
Distance Traveled (miles)                              CO2 Emitted
          Plane                 Cargo Ship              (g of CO2)
                            0                      0             28
                            0                   4907               6
                            0                      0            -
                            0                      0            -
                            0                      0             21
                            0                   8601               1
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -

                                Total CO2 (g)                    56
                                g CO2/g cookie                 0.12




                                                       CO2 Emitted
Distance Traveled (miles)                               (g of CO2)
          Plane                 Cargo Ship
                            0                      0                3
                            0                   4261                5
                            0                      0            -
                            0                      0            -
                            0                      0                0
                            0                   2184                0
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -
                            0                      0            -

                                Total CO2 (g)                       8
0.02
Reference Information
                                                                              emission factors from

Method of Travel Rail          Truck          Air              Cargo Ship     Hill, H., "Food Miles: Background and Mark
g CO2/(ton*mile)            25            129            783             19
gCO2/(g*mile)         2.55E-05       1.29E-04       7.83E-04       1.86E-05


                                                                              food densities from:
Ingredient        Volume          Mass (g)                                    http://www.aqua-calc.com/page/density-t
Flour             1 cup                      130
Sugar             1 cup                      200
Brown Sugar       1 cup                      195
Egg               1 lg egg                     47
Butter            1 stick (1/2 cup)          113
Vanilla Extract   1 tsp                      4.33
Chocolate         1 tsp                       4.6
Baking Soda       1 tsp                       4.6
Baking Powder     1 cup                      132
Walnuts           1 cup                        28
Pecans            1 cup                      109
Macidamia Nuts    1 cup                      134
Peanutbutter      1 cup                      258
Salt              1 tsp                      5.69
Oatmeal           1 cup                        90
Raisins           1 cup                      145
on factors from

, "Food Miles: Background and Marketing ." NCAT Sustainable Agriculture, 2008. Accessed 26 Jul 2011. https://attra.ncat.org/attra-pub/v




ensities from:
www.aqua-calc.com/page/density-table
tps://attra.ncat.org/attra-pub/viewhtml.php?id=281#embedded

								
To top