# Metric Conversion Worksheets - Excel

Document Sample

```					                              CERTs Application Worksheets
Introduction and Basic Information - SAMPLE

These worksheets are intended to strengthen your application by attaching important metrics to your project.
Complete all worksheets pertaining to your project. Light blue boxes indicate required inputs; yellow boxes contain
automatically calculated values. When finished, transer all necessary outputs to your application.

PROJECT INFORMATION                        Please provide information below
Project Name     Sample workbook with all sheets filled out
Contact Person    Clean Energy Resource Teams
Phone     651-789-3326
Email    dthiede@mnproject.org

Refer to the Calculation Guide for measurement descriptions
Refer to the Conversion Guide for useful conversions

WORKSHEETS IN THIS DOCUMENT:                                                         REQUIRED INPUTS & OUTPUTS:
Wind Energy                                                                    Blue boxes indicate required inputs:
Solar PV Energy                                                                 Yellow boxes are calculated values:
Solar Thermal Energy
Lighting Efficiency                                                                          Use arrows at lower left
Building Efficiency                                                                          to access all worksheets
Community-Based Education
School-Based Education
Research
CERTs Application Worksheets
Calculation Guide

Energy offset (kWh/year)
The calculators provided should provide either annual or lifetime savings. If                  kWh energy saved per lifetime
and divide lifetime energy savings by the years. In some cases, the years
might be under the second tab of the spreadsheet, “Assumptions”.                                  = kWh energy saved/year

Emissions offset (lbs CO2/year)
Same concept as with energy offset, but with CO2 emissions. If emissions are                      lbs CO2 saved per lifetime
given in carbon instead of carbon dioxide (C not CO2), see Conversions                                  Years lifetime
section below for appropriate conversion.
= lbs CO2 energy saved/year

If you know the lifetime of your project, such as expected life of the technology or how long the project will be implemented, state that
here. If the lifetime is unknown, refer to the Estimated Lifetimes section below. Note: For planning purposes, you may want to run
calculations for 2-3 different lifetime estimates. The final output results are very sensitive to this input.

Take the annual energy offset, recorded above, and multiply by estimated                  Annual Energy Offset * Lifetime in Years

Take the annual emissions offset, recorded above, and multiply by estimated           Annual CO2 Emissions Offset * Lifetime in Years
CERTs Application Worksheets
Conversion Guide

Converting Miles per hour to Meters per second
Use the following conversions:

Converting Carbon to CO2
To convert carbon dioxide (CO2) to carbon (C), multiply the lbs CO2 times
(12/44) (or .27273). (This is the ratio of the atomic weight of C over CO2.)
Or to convert carbon to carbon dioxide, multiply the lbs of C by (44/12) (or
3.66667).

Converting Pounds (lbs) to Tonnes (ton)
To convert CO2 or C lbs to tonnes, you can use one of the following
conversions (depending on your preferred conversion)

Converting kWh to CO2
If you already know the kWh used by the lighting and appliances, then you
can actually multiply the amount of kWh by the carbon intensity of our
electricity in Minnesota, which is 1.810 lbs CO2/kWh. (EPA EGrid)

Fuel Emissions Factors
Can be used to estimate CO2 offset by another system. From MPCA, except
Electricity is from EPA eGrid 2005.

Converting kWh to CO2
If you already know the kWh used by the lighting and appliances, then you
can actually multiply the amount of kWh by the carbon intensity of our
electricity in Minnesota, which is 1.810 lbs CO2/kWh. (EPA EGrid)
Putting all three Carbon conversions together
or carbon dioxide emissions and understand them in various forms.

Example:
ation Worksheets
sion Guide

1 mph = 0.44704 meters per second
1 meter per second = 2.23693629 mph

lbs CO2 * .27273 = lbs C
lbs C * 3.66667 = lbs CO2

1 metric tonne = 1,000kg = 2,205lb
1 US short ton = 907kg = 2,000lb

kWh * 1.810 lbs CO2/kWh = CO2 output

Natural Gas: 11.07 lbs CO2/therm
Fuel Oil: 22.13 lbs CO2/gallon
Electricity: 1.810 lbs CO2/kWh
Gasoline: 19.56 lbs CO2/gallon
Propane: 12.67 lbs CO2/gallon

kWh * 1.810 lbs CO2/kWh = CO2 output
___ kWh * 1.810 lbs CO2 per kWh * (12/44) C per CO2 /
tonnes conversion = C output

750 kWh * 1.810 lbs CO2/kWh = 1,357.5 lbs CO2
452.2 lbs CO2 * (12/44) = 370.23 lbs C
370.23 lbs C / 2,205 lbs per metric ton = .1679 metric tons C
CERTs Application Worksheets
Evaluating your Wind Energy Project - SAMPLE
Below is a worksheet detailing the project inputs, caculator inputs, and outputs required for evaluating you
If your project includes two different types of project types (e.g. a technical clean energy project with an educa
please complete any additional worksheets for each component. When finished, transer all necessary outputs

Project Inputs                                        Enter inputs in blue boxes
Number of Turbine(s)                         2
Capacity /Size of Turbine(s) (kW)                      2.00
Capacity Factor (%)                       28

Outputs                                               Outputs calculated automatically
Wind System Electricity Production (kWh/yr)                       9,811
CO2 Reductions per year (lbs/yr)                      17,660
Project Lifetime Emissions Offset (lbs co2)                    264,902

Calculation Notes for Wind

Explanation of Inputs
Capacity/Size of machine: the rated capacity of the wind turbine in kW
Capacity Factor: percent of full production capacity over a full year that the turbine will produce energy
Assumed Project Lifetime (years): anticipated years of operation before the turbine would be replaced

Explanation of Outputs
Energy Produced/Saved per Year: This is your annual energy offset for the worksheet.
Emissions Eliminated (CO2) per Year: This is your annual emission reduction.
Project Lifetime Carbon Offset (lbs of CO2): Lifetime reduction in CO2 from turbine based on electricity production
Worksheets
Project - SAMPLE
d outputs required for evaluating your wind project.
al clean energy project with an educational component),
nished, transer all necessary outputs to your application.
Check Conversion Guide

Notes
Size (kW) * capacity factor * 8760 (hours/year)
1.81 lbs/kWh *kWh = lbs/year
CO2/year * lifetime of project (in years)

ne will produce energy
ne would be replaced

heet.

ine
ne based on electricity production
CERTs Application Worksheets
Evaluating your Solar PV Energy Project - SAMPLE
Below is a worksheet detailing the project inputs, caculator inputs, and outputs required for evaluating your PV So
Project inputs are derived from a project final report and/or a project manager. If your project includes two differ
types (e.g. a technical clean energy project with an educational component), please complete any additional wo
component. When finished, transer all necessary outputs to your application.

Project Inputs                                      Enter inputs in blue boxes
Size of system (kW rating)                     25.43
Capacity Factor (%)                      15

Outputs                                             Outputs calculated automatically
PV System Electricity Production (kWh/yr)                      33,415
CO2 Reductions per year (lbs/yr)                     60,147
Project Lifetime Energy Offset (kWh)                     835,376
Project Lifetime Emissions Offset (lbs co2)                  1,503,676

Calculation Notes for Solar PV

Explanation of Inputs
Capacity/Size of machine: the rated capacity of the wind turbine in kW
Capacity Factor: percent of full production capacity over a full year that the turbine will produce energy
Assumed Project Lifetime (years): anticipated years of operation before the turbine would be replaced

Explanation of Outputs
Energy Produced/Saved per Year: This is your annual energy offset for the worksheet.
Emissions Eliminated (CO2) per Year: This is your annual emission reduction.
Project Lifetime Carbon Offset (lbs of CO2): Lifetime reduction in CO2 based on electricity production
Worksheets
gy Project - SAMPLE
utputs required for evaluating your PV Solar Energy project.
nager. If your project includes two different types of project

Check Conversion Guide

Notes
Size (kW) * capacity factor * 8760 (hours/year)
1.81 lbs/kWh *kWh = lbs/year
CO2/year * lifetime of project (in years)

rbine will produce energy
rbine would be replaced

ksheet.

anels
n electricity production
CERTs Application Worksheets
Evaluating your Solar Thermal Energy Project - SAMPLE
Below is a worksheet detailing the project inputs and outputs required for evaluating your solar thermal project. P
project knowledge and contractor bids; please use your best estimates. The Find-Solar.org calculator is available to
should you want additional assistance. If your project includes two different types of project types (e.g. a technica
an educational component), please complete any additional worksheets for each component. When finished, tran

Project Inputs                                        Enter inputs in blue boxes
Type of Project                      water
Current energy supply (e.g. electricity)                 Natural Gas
Energy Supply Units                       therms
Emission Factor                       11.07
Anticipated Energy Savings/year                        1,819
Assumed Project Lifetime (e.g. 15 yrs)                        30

Outputs                                               Outputs calculated automatically
CO2 Reductions per year (lbs/yr)                      20,136
Project Lifetime Emissions Offset (lbs co2)                    604,090

Calculation Notes for Solar Thermal

Explanation of Inputs
Current energy supply for heating water and/or heating hot air: electricity, natural gas, propane or fuel oil
Energy Produced/Saved per Year: This is your annual energy offset for the worksheet.
Assumed Project Lifetime (years): anticipated years of operation before the solar thermal panels (either hot air or hot wat

Explanation of Outputs
Emissions Eliminated (CO2) per Year: This is your annual emission reduction.
Project Lifetime Energy Offset: Amount of fossil fuel energy that the solar thermal would system would offset over its ant
Project Lifetime Carbon Offset (lbs of CO2): Lifetime reduction in CO2 based on the alternative fuel offset
n Worksheets
Energy Project - SAMPLE
evaluating your solar thermal project. Project inputs are based on
he Find-Solar.org calculator is available to help with project planning
ent types of project types (e.g. a technical clean energy project with
or each component. When finished, transer all necessary outputs to
ation.

Check Conversion Guide

Notes
type in water or space
select from drop-down list
automatically defined
automatically defined
in current supply units , based on contractor estimate
in years, based on lifetime of items installed

Notes
emission factor * energy savings per year
energy savings per year * lifetime of project
CO2/year * lifetime of project (in years)

ural gas, propane or fuel oil
ksheet.
lar thermal panels (either hot air or hot water) would be replaced

mal would system would offset over its anticipated lifetime; units will
n the alternative fuel offset
CERTs Application Worksheets
Evaluating your Low-Cost, No-Cost Energy Efficiency/Conserva
Below is a worksheet detailing potential low-cost, no-cost project options and their associated annual energy savi
of units your project would utilize - simply enter that number in the "quantity to be replaced" column. Project o
your project includes two different types of project types (e.g. a technical clean energy project with an educati
additional worksheets for each component. When finished, transer all necessary outputs t

NOTE: The values below are based on equipment using natural gas and will provide only rough estimates for other fuel type

Energy
Electricity Projects                                                          Units
Source

Electricity is the only fuel type for these projects        Electricity       kWh
Vending Miser                                            Electricity       kWh
18 W CFL (75 W Incandescent)                             Electricity       kWh
Replace Old Clothes Washer with Efficient Unit           Electricity       kWh
Upgrade Central AC from 13 - 16                          Electricity       kWh
Remove Second Refrigerator                               Electricity       kWh
Remove Stand Alone Second Freezer                        Electricity       kWh
Replace Dehumidifier                                     Electricity       kWh
Smart Power Strip                                        Electricity       kWh
LED Exit Sign                                            Electricity       kWh
Electricity       kWh
Electricity       kWh
Electricity       kWh
Electricity       kWh
Electricity       kWh

Energy
Space Heating Projects                                                        Units
Source

Space Heating Fuel (choose from drop-down)                 Natural Gas       therms
Upgrade Furnace from 78% - 94%                          Natural Gas       therms
Install Programmable Thermostat                         Natural Gas       therms
Window Insulation Film                                  Natural Gas       therms
Upgrade Attic insulation to R-49 from R-30              Natural Gas       therms
Caulking and Weatherstripping             Natural Gas   therms
Regular Replacement of Furnace Filters    Natural Gas   therms
Furnace Tuneup every 2 years              Natural Gas   therms
Natural Gas   therms
Natural Gas   therms
Natural Gas   therms
Natural Gas   therms
Natural Gas   therms

Energy
Water Heating Projects                                     Units
Source

Water Heating Fuel (choose from drop-down)   Electricity    kWh
Replace Showerhead 2.5 - 1.5 gpm           Electricity    kWh
Replace Aerator 2.75 - 1.5 gpm             Electricity    kWh
Wash Clothes in Cold water                 Electricity    kWh
Hot Water Pipe Insulation                  Electricity    kWh
Electricity    kWh
Electricity    kWh
Electricity    kWh
Electricity    kWh
Electricity    kWh
Application Worksheets
Cost Energy Efficiency/Conservation Project - SAMPLE
ns and their associated annual energy savings. Project inputs are based the number
uantity to be replaced" column. Project outputs will be automatically calcuated. If
nical clean energy project with an educational component), please complete any
en finished, transer all necessary outputs to your application.

Check Conversion Guide

ovide only rough estimates for other fuel types - see project-specific notes beside table

Savings               Assumed                                   Quantity     Total Savings
Emission Factor

1.81
1,250.00                 10                   1.81                 4                   5,000
39.00                   9                    1.81                 15                    585
157.00                  11                   1.81                 20                  3,140
117.00                  18                   1.81                 10                  1,170
844.00                  8                    1.81                 22                 18,568
476.00                  8                    1.81                 24                 11,424
88.00                   12                   1.81                 12                  1,056
170.00                  15                   1.81                200                 34,000
153.30                  10                   1.81                 40                  6,132
1.81                 0                       0
1.81                 0                       0
1.81                 0                       0
1.81                 0                       0
1.81                 0                       0
TOTAL:             81,075

Savings              Assumed                                   Quantity     Total Savings
Emission Factor

11.07                             therms
258.00                  18                  11.07                 14                   3,612
25.30                   18                  11.07                 50                   1,265
28.90                   1                   11.07                100                   2,890
21.00                   25                  11.07                 35                     735
72.20           15           11.07            80                  5,776
14.40           1            11.07           120                  1,728
27.40           2            11.07           100                  2,740
11.07            0                       0
11.07            0                       0
11.07            0                       0
11.07            0                       0
11.07            0                       0
TOTAL:             18,746

Savings       Assumed                      Quantity    Total Savings
Emission Factor

1.81                         kWh
600.86           7             1.81            40                24,034
252.07           5             1.81            40                10,083
392.75           1             1.81           200                78,551
38.10            10            1.81            45                 1,715
1.81            0                      0
1.81            0                      0
1.81            0                      0
1.81            0                      0
1.81            0                      0
TOTAL:           114,382
per year         kWh savings*      CO2 offset

9,050             50,000           90,500
1,059              5,265            9,530
5,683             34,540           62,517
2,118             21,060           38,119
33,608            148,544          268,865
20,677             91,392          165,420
1,911             12,672           22,936
61,540            510,000          923,100
11,099             61,320          110,989
0                  0                0
0                  0                0
0                  0                0
0                  0                0
0                  0                0
146,746            934,793        1,691,975

per year        energy savings*    CO2 offset

therms
39,985             65,016         719,727
14,004             22,770         252,064
31,992              2,890          31,992
8,136             18,375         203,411
63,940             86,640          959,105
19,129              1,728           19,129
30,332              5,480           60,664
0                  0                0
0                  0                0
0                  0                0
0                  0                0
0                  0                0
207,518            202,899        2,246,092

per year        energy savings*    CO2 offset

kWh
43,502           168,239          304,513
18,250            50,413           91,248
142,177            78,551          142,177
3,103            17,146           31,035
0                 0                0
0                 0                0
0                 0                0
0                 0                0
0                 0                0
207,032           314,350          568,973
Notes

(Office of Energy Security's Deemed Savings Database)
2-story single-family home, 840 hrs/yr per bulb installed (OES Deemed Savings Database)
Single-family home (OES Deemed Savings Database)
Single-amily home in Minneapolis (OES Deemed Savings Database)
(OES Deemed Savings Database)
(OES Deemed Savings Database)
(OES Deemed Savings Database)
(Green Institute)
Replacing 1-sided incandescent exit sign with 1-sided LED exit sign (OES Deemed Savings Database)

Notes

60,000 Btu/hr furnace for single-family home in Minneapolis (OES Deemed Savings Database)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)
Savings based on house using 722 therms natural gas for heating (Navigant Consulting, 2009)

Notes

Savings based on house using 192 therms for hot water (Navigant Consulting, 2009)
Savings based on house using 192 therms for hot water (Navigant Consulting, 2009)
Savings based on house using 192 therms for hot water (Navigant Consulting, 2009)
Savings based on house using 192 therms for hot water (Navigant Consulting, 2009)
CERTs Application Worksheets
Evaluating your Efficienct Lighting Project - SAMPLE
Below is a worksheet detailing the project inputs and outputs required for evaluating your lightling project. This i
us better understand the level of savings you expect from your lighting upgrade project. If your project includes tw
types (e.g. a technical clean energy project with an educational component), please complete any additional work
When finished, transer all necessary outputs to your application.

Project Inputs                                 Enter inputs in blue boxes
Type of Project                lighting install
Description of Existing System            175 watt metal halide
Description of Proposal System                        T8
Anticipated Project savings/year (kWh)                      3,418
Lifetime of new system (yrs)                        12

Outputs                                        Outputs calculated automatically
CO2 saved/year                     6,187

Calculation Notes for Lighting

Explanation of Inputs
Type of Project: lighting audit or labor to install lighting, lighting controls (timers, occupancy sensor, photo-sensors)
Description of Existing System: type of existing lighting, type of existing controls, etc.
Description of Proposed System: type of replacement lighting, type of controls, etc.
Anticipated Projects savings/year (therms): an estimate, likely from a contractor, of your anticipated savings from this sys
Lifetime of new system (years): anticipated years of operation

Explanation of Outputs
Emissions Eliminated (CO2) per Year: This is your annual emission reduction.
Project Lifetime Energy Offset (kWh): Lifetime energy saving given type of energy offset
tion Worksheets
t Lighting Project - SAMPLE
d for evaluating your lightling project. This is general guide post to help
g upgrade project. If your project includes two different types of project

Check Conversion Guide

Notes
lighting audit or labor to install lighting, lighting controls
type of lighting, type of controls, etc.
type of lighting, type of controls, etc.
estimate of overall project
based on lifetime of items installed

Notes
1.81 lbs/kWh *kWh = lbs/year
=CO2/year * lifetime of project (in years)

(timers, occupancy sensor, photo-sensors)
ontrols, etc.
ntrols, etc.
tractor, of your anticipated savings from this system improvement

on.
f energy offset
CERTs Application Worksheets
Evaluating your Building Energy Efficiency Projec
Below is a worksheet detailing the project inputs outputs required for evaluating your building energy efficiency i
to save energy is through energy efficiency projects. These projects can entail one or more of the following: a
replacing heating and cooling systems. This is a general guide post to help us better understand the level of savin
your project includes two different types of project types (e.g. a technical clean energy project with an education
each component. When finished, transer all necessary outputs to y

Project Inputs
Type of Project
Current energy supply (e.g. electricity)
Energy Supply Units
Emission Factor
Description of Existing System
Description of Proposed System
Size of Building (sq ft)
Anticipated Energy Savings/year
Assumed Project Lifetime (e.g. 15 yrs)

Project Outputs
CO2 saved/year

Calculation Notes for Building Efficiency

Explanation of Inputs
Type of Project: air sealing (to minimize air leakage), insulation (increasing the R-Factor), windows/doors, heating-cooling
Description of Existing System: if you are adding insulation, describe the R-factor of the current insulation; similarly for w
heating and cooling describe the current efficiency level of the system
Description of Proposed System: if you are adding insulation, describe the anticipated R-factor; similarly for windows and
cooling provide the efficiency level of the new system
Size of building (sq ft): square footage of structure to be improved
Anticipated Projects savings/year (therms): an estimate, likely from a contractor, of your anticipated savings from this sys
Lifetime of new system (years): anticipated years of operation

Explanation of Outputs
Emissions Eliminated (CO2) per Year: This is your annual emission reduction.
Project Lifetime Carbon Offset (lbs of CO2): Lifetime reduction in CO2 from turbine based on electricity production
CERTs Application Worksheets
Evaluating your Building Energy Efficiency Project - SAMPLE
he project inputs outputs required for evaluating your building energy efficiency improvement project. Many times, the most
ergy efficiency projects. These projects can entail one or more of the following: air sealing, insulation, window and door repla
ystems. This is a general guide post to help us better understand the level of savings you expect from your building energy eff
ent types of project types (e.g. a technical clean energy project with an educational component), please complete any addition
each component. When finished, transer all necessary outputs to your application.

Check Calculation Guide

Enter inputs in blue boxes
Heating/Cooling
Natural Gas
therms
11.07
Hot Water Boiler w/o reset controls
Hot Water Boiler with reset controls
10,000
288
20

Outputs calculated automatically
3,188
5,760
63,763

inimize air leakage), insulation (increasing the R-Factor), windows/doors, heating-cooling system upgrades
you are adding insulation, describe the R-factor of the current insulation; similarly for windows and doors, provide the current type of wi
current efficiency level of the system
if you are adding insulation, describe the anticipated R-factor; similarly for windows and doors, provide the R-Factor given the upgrades;
vel of the new system
otage of structure to be improved
r (therms): an estimate, likely from a contractor, of your anticipated savings from this system improvement
anticipated years of operation
Year: This is your annual emission reduction.
Wh): Lifetime production of electricity from turbine
bs of CO2): Lifetime reduction in CO2 from turbine based on electricity production
Worksheets
fficiency Project - SAMPLE
g energy efficiency improvement project. Many times, the most cost-effective way
e of the following: air sealing, insulation, window and door replacements, and
and the level of savings you expect from your building energy efficiency project. If

Check Conversion Guide

Notes
air sealing , insulation , remodeling , windows/doors , heating/cooling
select from drop-down list
automatically defined
automatically defined
include equipment if applicable
include equipment if applicable
total square-footage of project area
in current supply units , based on contractor estimate
in years, based on lifetime of items installed

Notes
emission factor * energy savings per year
energy savings per year * lifetime of project
CO2/year * lifetime of project (in years)

lation; similarly for windows and doors, provide the current type of window/door; for

larly for windows and doors, provide the R-Factor given the upgrades; for heating and

d savings from this system improvement
city production
CERTs Application Worksheet
Below is a worksheet for evaluating your community education project. If your project includes installation of low-cost/no-c
estimate the potential energy savings. If your project includes two different types of project types (e.g. a technical clean
additional worksheets for each component. When finished, indicate on your application t

Project Details
Type of Community Group

Type of Project

Goals of Project

Tools to be used to track project effectiveness

Number of Community Members Involved in Planning
Number of Community Members Contacted (goal)

Number of Community Member who will take action (goal)

Project Impacts
One-time effort or on-going project?
If so, How many times will the program be repeated or for how
long will it be ongoing?
How many community members are expected to be impacted for
the duration of the program?
If program will be continued indefinitely, how many community
members are expected to be impacted over the next five years?

Other Expected Impacts
CERTs Application Worksheets
aluating your Community-Based Educational Project - SAMPLE
ucation project. If your project includes installation of low-cost/no-cost fixtures/equipment please also fill out the low-cost/no-cost sheet
includes two different types of project types (e.g. a technical clean energy project with an educational component), please complete any
s for each component. When finished, indicate on your application that you have filled out this worksheet.

Check Calculation Guide

Enter inputs in blue boxes

Neighborhood Organization
Workshops with door to door recruitment

Household Energy Efficiency
To assist residents reduce energy use and save money
through low-cost and no cost measures

Utility release forms
15

500

250

Enter inputs in blue boxes
one time

6 months, March to September
400, we think that some will take action, that won't actually
sign release forms that we can track

we expect since we are doing this in a small geographic
area, that some ancillary benefits will include stronger
neighborhood ties, reduced crime, shared learning
heets
al Project - SAMPLE
t/no-cost fixtures/equipment please also fill out the low-cost/no-cost sheet to
clean energy project with an educational component), please complete any
ation that you have filled out this worksheet.

Check Conversion Guide

Notes
e.g. neighborhood, church, multi-family building, workplace,
e.g. door-to-door, workshops, event
e.g. household energy efficiency, lighting, low-cost/no-cost,
composting
e.g. behavior change, programmable thermostats, CFLs
installed, reduced water usage
e.g. energy competition, pre-post survey, utility data requests,
MN Energy Challenge

i.e. number of people, households, businesses

i.e. number of people, households, businesses

Notes
choose one; please explain if necessary

if energy savings impacts, please use other tabs
CERTs Application Worksheets
Evaluating your School-Based Educational Project - SA
Below is a worksheet for evaluating your education project. Education projects include an informational display on new te
your project includes two different types of project types (e.g. a technical clean energy project with an educational compone
component. When finished, indicate on your application that you have filled out t

Project Inputs
Type of project
Number of Faculty and Staff Involved

Project Inputs
Number of Students Involved in or Directly Impacted

In-Curriculum or Extra-Curricular
Other Information

Project Inputs
One-time effort or on-going project?
If so, How many times will the program be repeated or for how
long will it be ongoing?
How many students are expected to be impacted for the
duration of the program?
If program will be continued indefinitely, how many students
will be impacted over the next five years?
CERTs Application Worksheets
uating your School-Based Educational Project - SAMPLE
project. Education projects include an informational display on new technology, developing curriculum and teaching it, etc. If
pes (e.g. a technical clean energy project with an educational component), please complete any additional worksheets for each
. When finished, indicate on your application that you have filled out this worksheet.

Check Calculation Guide

Enter inputs in blue boxes
curriculum development; demonstration
2

Enter inputs in blue boxes

20 students will participate (300 impacted)
K-12
In-Curriculum

Enter inputs in blue boxes
on-going project

once a year indefinitely

300 a year (entire student body)

1,500
orksheets
onal Project - SAMPLE
onal display on new technology, developing curriculum and teaching it, etc. If
at you have filled out this worksheet.

Check Conversion Guide

Notes
curriculum development, demonstration/displays

Notes

choose one; please explain if necessary
class topic, course name, related research projects, materials

Notes
choose one; please explain if necessary
CERTs Application Worksheets
Evaluating Your Research Project - SAMPLE

Below is a worksheet for evaluating your research project, including resource assessments, monitoring, and feasibility stud
types (e.g. a technical clean energy project with an educational component), please complete any addit
When finished, indicate on your application that you have filled out this w

Study Information
Type of project

Final product of the research

To what extent does this research contribute to and build
upon an existing body of knowledge in this area, or to what
extent is this research more experimental?

How will the study's findings be shared?

Will the study's finding be shared with a greater community?
If yes, who and how?

What will this research/study measure as related to clean
energy impacts?
What actions/next steps will be/could be taken after this
research is completed?
CERTs Application Worksheets
Evaluating Your Research Project - SAMPLE

project, including resource assessments, monitoring, and feasibility studies. If your project includes two different types of project
ergy project with an educational component), please complete any additional worksheets for each component.
When finished, indicate on your application that you have filled out this worksheet.
Check Calculation Guide

Enter inputs in blue boxes
Home Energy Conservation Behavior Study focused
on No Cost measures.

Published Research, display, and fact sheet
describing "best practice" methods and factors to
motivate residents to take actions to reduce home
energy use including evaluating energy savings for
some of the behavior changes that don't currently
have deemed savings measurements.

This research would add to the growing body of
research to gain a deeper understanding of the
best community based marketing strategies and
the No Cost actions more residents are likely to
take to reduce home energy use.

This study would be published in the appropriate
behavior psychology journals, and would be
presented at the National BECC (Behavior, Energy
and Climate Change Conference in the Fall of 2010.
Yes, we plan to do 2 community forums to describe
the study and what we learned in addition to
presenting this as part of a class at the University
of MN.

We would identify actions, methods and messages
that are more likely to result in behavior change
that reduces energy use in the home including
evaluating deemed savings for some of the no cost
measures that don't currently have savings
numbers associated.
We would create user friendly list of "best
practices" list for communities to engage their
residents to take No Cost actions to reduce home
energy use
rksheets
ect - SAMPLE

and feasibility studies. If your project includes two different types of project
complete any additional worksheets for each component.
ave filled out this worksheet.
Check Conversion Guide

Notes
resource assessment, monitoring, feasibility study

feasibility report, published research, presentation/display

published in a journal or online, distributed to interested
parties, presentation at a conference
CERTs Application Worksheets
Evaluating Other Types of Projects - SAMPLE
Please make sure you only use this worksheet for projects that do not fit under other categories. Fill out this w
other project types - be they clean energy or energy efficiency. If your project includes two different types of p
energy project with an educational component), please complete any additional worksheets for each compon

Clean Energy

Project Inputs
Type of Project
Type of Fuel Offset (e.g. electricity)
Energy Supply Units
Emission Factor
Anticipated Energy Savings/year
Assumed Project Lifetime (e.g. 15 yrs)

Project Outputs
CO2 Reductions per year (lbs/yr)
Project Lifetime Emissions Offset (lbs co2)

Energy Efficiency

Project Inputs
Type of Project
Current energy supply (e.g. electricity)
Energy Supply Units
Emission Factor
Description of Existing System
Description of Proposed System
Anticipated Energy Savings/year
Assumed Project Lifetime (e.g. 15 yrs)
Project Outputs
CO2 saved/year
CERTs Application Worksheets
Evaluating Other Types of Projects - SAMPLE
s worksheet for projects that do not fit under other categories. Fill out this worksheet to help CERTs benchmark
n energy or energy efficiency. If your project includes two different types of project types (e.g. a technical clean
onal component), please complete any additional worksheets for each component. When finished, transer all

Check Calculation Guide

Enter inputs in blue boxes

Electricity
kWh
1.81

Outputs calculated automatically
0
0
0

Enter inputs in blue boxes

Natural Gas
therms
11.07
Outputs calculated automatically
0
0
0
eets
AMPLE
ries. Fill out this worksheet to help CERTs benchmark
ifferent types of project types (e.g. a technical clean
ts for each component. When finished, transer all

Check Conversion Guide

Notes
e.g. biomass or geothermal
select from drop-down list
automatically defined
automatically defined
in current supply units , based on contractor estimate
based on lifetime of items installed

Notes
emission factor * energy savings per year
energy savings per year * lifetime of project
CO2/year * lifetime of project (in years)

Notes
e.g. district heating
select from drop-down list
automatically defined
automatically defined
include equipment if applicable
include equipment if applicable
in current supply units , based on contractor estimate
based on lifetime of items installed
Notes
emission factor * energy savings per year
energy savings per year * lifetime of project
CO2/year * lifetime of project (in years)

```
DOCUMENT INFO
Shared By:
Categories:
Stats:
 views: 344 posted: 11/22/2010 language: English pages: 719
Description: Metric Conversion Worksheets document sample