jagomart
digital resources
picture1_Estimate Template Excel 41156 | Project Tracking Tool


 297x       Filetype XLSX       File size 0.13 MB       Source: betterbuildingssolutioncenter.energy.gov


File: Estimate Template Excel 41156 | Project Tracking Tool
sheet 1 project tracker projects summary implementation summary green input total savings usd 000 yellow choose from list total projects 0 total implementaion cost usd 000 pink financial summary implemented ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Project Tracker












Projects Summary







Implementation Summary










Green Input









Total Savings (USD) $0.00

Yellow Choose from List


Total Projects 0




Total Implementaion Cost (USD) $0.00

Pink Financial Summary


Implemented 0




Total Electricity Savings (kWh) 0

Light Blue Implementation Summary


Funding needed $-




Total Natural Gas Savings (MMBtu) 0

Orange Calculated









Overall Payback (Years)
or 0.0 months











Sr. Project Details Status Savings
Tracking ID Project Description Plant Division Business Owner Energy System Annual Savings Estimate Project Origin Funding Status Implementation Cost Implementation Status Date Completed Electricity Savings Natural Gas Savings
(mm/yyyy) kWh MMBtu

































































































Sheet 2: Example-Projects Tracker












Projects Summary







Implementation Summary










Green Input









Total Savings (USD) $77,100.00

Yellow Choose from List


Total Projects 6




Total Implementaion Cost (USD) $56,000.00

Pink Financial Summary


Implemented 3




Total Electricity Savings (kWh) 1,773,300

Light Blue Implementation Summary


Funding needed $48,000.00




Total Natural Gas Savings (MMBtu) 0

Orange Calculated









Overall Payback (Years) 0.73 or 8.7 months











Sr. Project Details Status Savings
Tracking ID Project Description Plant Division Business Owner Energy System Annual Savings Estimate Project Origin Funding Status Implementation Cost Implementation Status Date Completed Electricity Savings Natural Gas Savings
(mm/yyyy) kWh MMBtu
TreasureHunt-01 Reduce Pressure Houston-A Production Business Type - I John Smith Compressed Air $10,000.00 Treasure Hunt Funding Unnecessary (OPEX) $1,000.00 Implemented 05/2021 230,000 0
TreasureHunt-01 Fix Leaks Houston-A Production Business Type - I Jane Doe Compressed Air $7,800.00 Treasure Hunt Funding Unnecessary (OPEX) $5,000.00 Planned
179,400

TreasureHunt-01 Increase storage size Houston-A Production Business Type - I John Smith Compressed Air $9,200.00 Treasure Hunt Funding Requested $25,000.00 On-hold
211,600

TreasureHunt-01 Change pressure setting on compressor 2 Houston-A Production Business Type - I John Smith Compressed Air $2,600.00 Treasure Hunt Funding Unnecessary (OPEX) $1,000.00 Implemented 07/2021 59,800

TreasureHunt-01 Make compressor 3 the base compressor Houston-A Production Business Type - I Jane Doe Compressed Air $12,500.00 Treasure Hunt Funding Unnecessary (OPEX) $1,000.00 Implemented 08/2021 287,500

TreasureHunt-01 Use machine 2 (newer) instead of production machine 1 to reduce compressed air usage Houston-A Production Business Type - I Mike Doall Compressed Air $35,000.00 Treasure Hunt Funding Requested $23,000.00 On-hold
805,000


The words contained in this file might help you see if this file matches what you are looking for:

...Sheet project tracker projects summary implementation green input total savings usd yellow choose from list implementaion cost pink financial implemented electricity kwh light blue funding needed natural gas mmbtu orange calculated overall payback years or months sr details status tracking id description plant division business owner energy system annual estimate origin date completed mmyyyy exampleprojects treasurehunt reduce pressure houstona production type i john smith compressed air treasure hunt unnecessary opex fix leaks jane doe planned increase storage size requested onhold change setting on compressor make the base use machine newer instead of to usage mike doall...

no reviews yet
Please Login to review.