NC DENR Climate Change Work Group Webinar Session 1

1
NC DENR Climate Change Work Group Webinar Session
1

• Presented By
• Sushma Masemore
• Jennifer Marik
• Thursday, February 12, 2009 (1000 AM)

2
Outline

• Data Tables
• Submittal Dates
• Questions

3
Data Tables

• Owned_Vehicles.xls
• Leased_Vehicles.xls
• Personal_Vehicles.xls
• Owned_Fuel.xls
• Leased_Fuel.xls
• Owned_Miles.xls
• Leased_Miles.xls

• ElectricityAccounts.xls
• ElectricityRecords.xls
• StnCombEquip.xls
• StnFuelRecords.xls

4
Vehicles
5
Step 1 Owned Vehicles

• Information Needed
• Vehicle ID
• MFG Year
• Zip Code
• Make/Model
• Engine Size
• Fuel Type

6
Step 2 Owned Vehicles Resources

• Most owned vehicles are listed in DENRs Property
  database. Use VehicleAssets.xls file as an
  additional resource
• Vehicles with DOT key cards are listed in
  DOT_Specs-On_DENR_Owned Vehicles.xls. Use this
  file as an additional resource.
• Contact your budget officer
• Mention the DENR Petroleum Displacement Plan,
  Fuel Card Vehicle spreadsheet, or any other
  vehicle documentation they may have
• Note You must include ALL vehicles that consumed
  fuel in 2008!

7
Example Resource Tables
8
Step 2 Owned Vehicles Resources Continued

• Identify vehicle specifications, using
  www.fueleconomy.gov/feg/findacar. This site will
  help get the following data
• Make / Model
• Engine Size (L, cyl)
• Class
• Google Search by typing the VIN
• Other resources
• Ford Cars www.fleet.ford.com/maintenance/vin_tool
  s/default.asp
• GMC, Chevrolet, Dodge, Intl Thomas-Built
  buses
• http//www.decodethis.com/

9
Vehicle Specifications FuelEconomy.Gov Example
10
Vehicle Specifications Google Example
11
Step 3 Owned Vehicles

• Enter Information into Owned_Vehicles.xls!

12
Step 4 Use the same process for Off-Road or
Non-Road Vehicles Equipment
13
Step 5 Owned Vehicles Mileage Records
(Owned_Miles.xls)

• Mileage data can be located from your divisions
  accounting staff
• Note You only need the odometer reading around
  January 1, 2008 and December 31, 2008. The
  difference is the annual miles driven. (Monthly
  data are optional)

14
Step 6 Owned Vehicle Fuel Records
(Owned_Fuel.xls)

• Data For Vehicles with DOT keys that purchased
  fuel from DOT stations are already listed in your
  table.
• Note You need to add any other fuel purchased
  from commercial stations and/or on-site pumps.

15
Step 1 Leased Vehicles

• Information Needed
• Vehicle ID
• MFG Year
• Zip Code
• Make/Model
• Engine Size
• Fuel Type

16
Leased Vehicles

• Most leased vehicles from Motor Fleet are already
  listed for your division.
• Add/Delete vehicles to ensure list is accurate
  for 2008.
• Some divisions lease vehicles/equipment from
  other agencies. List these in the same manner.

17
Step 1 Leased Vehicles Resources

• Motor Fleet Management
• The same resources used for owned vehicles may be
  used to fill out the specifications.

18
Step 2 Leased Vehicles Mileage
Records(Leased_Miles.xls)

• DAQ has already processed mileage data from MFM
  database.
• Verify these records are correct and make
  adjustments as needed.
• If the vehicle is leased from other agencies, add
  the data.
• Note Monthly data are optional.

19
Step 3 Leased Vehicle Fuel Records
(Leased_Fuel.xls)

• If your division tracks fuel records for leased
  vehicles, enter the data.
• Note Monthly fuel records are optional.

20
Questions??
21
Electricity
22
Process Step 1

• Start by locating the information needed for
• ElectricityAccounts.xls and
• ElectricityRecords.xls, using ElectricityInvoices.
  xls

23
Step 1 Inventory of Accounts

• Information Needed for ElectricityAccounts.xls
• Individual Utility Account Numbers
• Vendor Number
• Vendor Name
• Service Address
• This information can be found using
  ElectricityInvoices.xls. For any missing
  information, contact your Budget Officer. He/She
  can help you acquire the actual electricity
  invoices.

24
ElectricityInvoices.xls
25
Process Step 2

• Locate the information needed for
• ElectricityAccounts.xls and
• ElectricityRecords.xls, using
• ElectricityAccounts.xls Tabs.

26
Step 2 Inventory of Accounts

• Additional Information Needed for
  ElectricityAccounts.xls
• 6. Building Asset ID
• 7. Building Name
• 8. Gross Square Feet
• This information can be found under the
  Owned_Bldgs Tab and Leased_Bldgs Tab. If there
  is no gross square feet associated with the
  Building, then leave it blank.

27
ElectricityAccounts.xls
The building addresses in these two tabs will
need to be cross-referenced with the service
addresses in order to figure out the Building
Asset ID and Building Name. Note Some of your
buildings may not be included here. Ask your
accounting or facility staff for help.
28
Process Step 3

• Using the information gathered, fill out
  ElectricityAccounts.xls and ElectricityRecords.xls
  .

29
ElectricityAccounts.xls
30
ElectricityRecords.xls

• Using data from ElectricityInvoices.xls, add up
  total Electricity Usage for each account number.
• Note Monthly data are optional.
• Duke Energy and Progress Energy data are
  optional.

31
Questions??
32
Stationary Combustion Sources
33
Step 1 Stationary Combustion Sources

• Using FuelInvoices.xls, find the following pieces
  of information
• Individual Utility Account Numbers
• Fuel Used (natural gas or fuel oil) Monthly or
  Annual Totals
• Vendor Number
• Vendor Name
• Service Address
• For any missing information, contact your Budget
  Officer. He/She can help you acquire the actual
  fuel invoices.

34
FuelInvoices.xls
35
Step 2 Stationary Combustion Sources

• Specify the combustion equipment, using
  Combustion Technology Tab, in StnCombEquip.xls
• Combustion Equipment ID
• Combustion Equipment Configuration
• Fuel Type
• Combustion Technology ID

36
Combustion Technology Tab, in StnCombEquip.xls
37
Step 3 Stationary Combustion Sources

• Use the information found to fill out
  StnCombEquip.xls and StnFuelRecords.xls.
• Note Monthly fuel data are optional.

38
StnComb Tables
39
Remaining Data Tables and Submittal Dates

• Owned_Fuel.xls
• Owned_Miles.xls
• Leased_Fuel.xls
• Leased_Miles.xls
• ElectricityAccounts.xls
• ElectricityRecords.xls
• StnCombEquip.xls
• StnFuelRecords.xls

• 3/13/09
• 3/13/09
• 3/13/09
• 3/13/09
• 2/28/09
• 3/20/09
• 2/28/09
• 3/20/09

40
Questions??