{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","Reference"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":101,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calculator","index":0,"n_rows":57,"n_cols":18,"rows_kept":57,"cut":false,"hidden":false,"merged":[[36,2,37,2],[36,4,37,5],[56,13,56,14],[26,13,26,14],[31,12,32,12],[56,12,57,12],[26,12,27,12],[33,4,34,5],[38,2,39,5],[43,2,44,5],[2,13,2,14],[32,13,32,14],[29,2,30,5],[31,2,32,3],[33,2,34,3],[31,4,32,5],[2,2,3,5],[1,12,2,12],[11,2,11,5],[10,2,10,5],[4,3,4,4],[8,3,8,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CEMS"]
[null,null,"CEMS vs PEMS Cost Savings Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,"NAME","ABBREVIATION","VALUE","UNITS","FORMULA","NOTES"]
[null,null,"Number of Sources: ",3,null,null,null,null,null,null,null,null,"Cooling Energy Usage","CCEU",{"$f":"CEMSCoolingEnergyUsage","v":7101.8003279607192},"kWh","(((1 / SQF) * (4800 * (CDD / 18.33) * 24)) / 1000) * SRCS","Energy required to run the HVAC system."]
[null,null,"Location: ",null,null,null,null,null,null,null,null,null,"Cost of Cooling Energy","CCCE",{"$f":"CEMSCostOfCoolingEnergy","v":648.39436994281368},"$","COE * CCEU","Cooling energy usage multiplied by the cost of electricity."]
[null,null,"Shelter Quality: ",null,null,null,null,null,null,null,null,null,"Heating Energy Usage","CHEU",{"$f":"CEMSHeatingEnergyUsage","v":1302.6826733150683},"kWh","((((1 / (SQF * 15)) * 66.54 * HDD * 24) / 1000) - (((1.006 * 1.165 * 40) / 3600) * (HDD / 365))) * SRCS","Energy required to heat shelter minus the heat generated by the CEMS itself."]
[null,null,"Energy Consumption: ",null,null,null,null,null,null,null,null,null,"Cost of Heating Energy","CCHE",{"$f":"CEMSCostOfHeatingEnergy","v":118.93492807366574},"$","COE * CHEU","Heating energy usage multiplied by the cost of electricity."]
[null,null,"Umbilical Length: ",100,null,"(ft)",null,null,null,null,null,null,"Total Energy Usage","CTEU",{"$f":"CEMSTotalEnergyUsage","v":280402.4830012758},"kWh","CCEU + CHEU + ((ECF * (12000 + 18 * UL) * 365 * 24) / 1000) * SRCS","Sum of the cooling, heating, and general CEMS energy usage."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Energy","CTCE",{"$f":"CEMSTotalCostOfEnergy","v":25600.746698016483},"$","COE * CTEU","Total energy usage multiplied by the cost of electricity."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shelter/Foundation/Utilities Cost","CSFUC",{"$f":"CEMSShelterFoundationUtilitiesEtcCost","v":14735.25},"$","0.05 * SC * SRCS","Based on a percentage (5%) of the shelter cost."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance Cost","CMC",{"$f":"CEMSMaintenanceCost","v":67500},"$","MF * 100 * 225 * SRCS","Estimated 225 hours of maintenance per year at a rate of $100 / hour."]
[null,null,null,null,null,null,null,null,null,null,null,null,"CO2 Generated","CCO2G",{"$f":"CEMSCO2Generated","v":197.78693862964391},"tons","0.000705368 * CTEU","Conversion based on energy usage (c.f. www.epa.gov)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Engineering Cost","CEC",{"$f":"CEMSEquipmentCost","v":19550.09966980165},"$","(1 / MF) * 6500 * SRCS","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* DAS Software Cost","CDASSWC",{"$f":"CEMSDASSoftwareCost","v":19000},"$","10000 + 3000 * SRCS","Quoted price ($10,000 plus $3,000 per source)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* DAS Hardware Cost","CDASHWC",{"$f":"CEMSDASHardwareCost","v":7000},"$","7000 * (1 + QUOTIENT((SRCS - 1), 5))","Quoted price (Five sources per license at $7,000 per license)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"DAS Support Cost","CDASSUPC",{"$f":"CEMSDASSupportCost","v":7200},"$","12 * 200 * SRCS","Support contract of $200 / month per source."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Spare Parts Cost","CSPC",{"$f":"CEMSSparePartsCost","v":16875},"$","0.25 * CMC","Based on a percentage (25%) of the maintenance cost."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consumables Cost","CCC",{"$f":"CEMSConsumablesCost","v":6750},"$","0.10 * CMC","Based on a percentage (10%) of the maintenance cost."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Installation and Start-Up Cost","CISUC",{"$f":"CEMSInstallationAndStartUpCost","v":11000},"$","5000 + 2000 * SRCS","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"CEMS Equipment Cost","CEQC",{"$f":"CEMSEquipmentCost","v":21700.610633479828},"$","=0.10 * (CTCE + CSFUC + CMC + CEC + CDASSWC + CDASHWC + CDASSUPC + CSPC + CCC + CISUC  + CSTC + CFAC + CFYAC)","Based on a percentage (10%) of the total capital cost."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* System Training Cost","CSTC",{"$f":"CEMSSystemTrainingCost","v":5100},"$","5100","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Factory Acceptance Cost","CFAC",{"$f":"CEMSFactoryAcceptanceCost","v":1975},"$","1975","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* First Year Audit Cost","CFYAC",{"$f":"CEMSFirstYearAuditCost","v":12765},"$","4255 * SRCS","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost (First Year)","CTCFY",{"$f":"CEMSTotalCostFirstYear","v":236751.70700129797},"$","CTCE + CSFUC + CMC + CEC + CDASSWC + CDASHWC + CDASSUPC + CSPC + CCC + CISUC + CEQC + CSTC + CFAC + CFYAC","Sum of the first year costs."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost (Annually Thereafter)","CTCA",{"$f":"CEMSTotalCostAnnual","v":160361.60733149631},"$","CTCE + CSFUC + CMC + CDASSUPC + CSPC + CCC + CEQC","Sum of the annual costs."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Denotes first year cost only."]
[]
[]
[null,null,"Results"]
[]
[null,null,"Total Savings (First Year):",null,{"$f":"CTCFY-PTCFY","v":152229.97836129798},null,null,null,null,null,null,null,"PEMS"]
[]
[null,null,"Total Savings (Annually Thereafter):",null,{"$f":"CTCA-PTCA","v":132258.37869149633},null,null,null,null,null,null,null,"NAME","ABBREVIATION","VALUE","UNITS","FORMULA","NOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cooling Energy Usage","PCEU",{"$f":"PEMSCoolingEnergyUsage","v":5606.4},"kWh","(0.40 * 1600 * 24 * 365) / 1000","Energy required to cool the PEMS server (Server running at 40% load)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Cooling Energy","PCCE",{"$f":"PEMSCostOfCoolingEnergy","v":511.86432000000002},"$","COE * PCEU","Cooling energy usage multiplied by the cost of electricity."]
[null,null,{"$f":"CTCFY+9*CTCA","v":1680006.1729847647},null,{"$f":"PTCFY+9*PTCA","v":337450.78639999998},null,null,null,null,null,null,null,"Heating Energy Usage","PHEU",{"$f":"PEMSHeatingEnergyUsage","v":0},"kWh","0","The PEMS server does not require additional heating."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost of Heating Energy","PCHE",{"$f":"PEMSCostOfHeatingEnergy","v":0},"$","COE * PHEU","Heating energy usage multiplied by the cost of electricity."]
[null,null,{"$f":"CONCATENATE(\"PEMS uses \", TEXT((PTEU/CTEU),\"#.##%\"), \" the energy usage of CEMS.\")","v":"PEMS uses 4.% the energy usage of CEMS."},null,null,null,null,null,null,null,null,null,"Total Energy Usage","PTEU",{"$f":"PEMSTotalEnergyUsage","v":11212.8},"kWh","PCEU + PHEU + (0.40 * 1600 * 24 * 365) / 1000","Sum of cooling, heating, and general PEMS server energy usage (Server running at 40% load)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Energy","PTCE",{"$f":"PEMSTotalCostOfEnergy","v":1023.72864},"$","COE * PTEU","Total energy usage multiplied by the cost of electricity."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Shelter/Foundation/Utilities Cost","PSFUC",{"$f":"PEMSShelterFoundationUtilitiesEtcCost","v":0},"$","0","No shelter is required for the PEMS."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance Cost","PMC",{"$f":"PEMSMaintenanceCost","v":3600},"$","12 * 300","Support contract of $300 / month."]
[null,null,null,null,null,null,null,null,null,null,null,null,"CO2 Generated","PCO2G",{"$f":"PEMSCO2Generated","v":7.9091503104000003},"tons","0.000705368 * PTEU","Conversion based on energy usage (c.f. www.epa.gov)."]
[null,null,"Reference Data",null,null,null,null,null,null,null,null,null,"* Engineering Cost","PEC",{"$f":"PEMSEngineeringCost","v":5338.5},"$","5338.5","Cost of PEMS model development."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* DAS Software Cost","PDASSWC",{"$f":"PEMSDASSoftwareCost","v":19000},"$","10000 + 3000 * SRCS","Quoted price ($10,000 plus $3,000 per source)."]
[null,null,"NAME","ABBREVIATION","VALUE","UNITS",null,null,null,null,null,null,"* DAS Hardware Cost","PDASHWC",{"$f":"PEMSDASHardwareCost","v":7000},"$","7000 * (1 + QUOTIENT((SRCS - 1), 5))","Quoted price (Five sources per license at $7,000 per license)."]
[null,null,"Number of Sources","SRCS",{"$f":"D5","v":3},"-",null,null,null,null,null,null,"DAS Support Cost","PDASSUPC",{"$f":"PEMSDASSupportCost","v":7200},"$","12 * 200 * SRCS","Support contract of $200 / month per source."]
[null,null,"Shelter Quality Factor","SQF",1,"-",null,null,null,null,null,null,"Spare Parts Cost","PSPC",{"$f":"PEMSSparePartsCost","v":150},"$","150","Replacement hard drive."]
[null,null,"Maintenance Factor","MF",1,"-",null,null,null,null,null,null,"Consumables Cost","PCC",{"$f":"PEMSConsumablesCost","v":24},"$","4 * 6","Four cannisters of compressed air at $6 apiece."]
[null,null,"Energy Consumption Factor","ECF",0.75,"-",null,null,null,null,null,null,"* Installation and Start-Up Cost","PISUC",{"$f":"PEMSInstallationAndStartUpCost","v":5400},"$","5400","Quoted price."]
[null,null,"Umbilical Length","UL",{"$f":"D9","v":100},"ft",null,null,null,null,null,null,"PEMS Cost","PC",{"$f":"PEMSCost","v":16105.5},"$","0.10 * (53685 * SRCS)","Based on a percentage (10%) of the total capital cost."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* System Training Cost","PSTC",{"$f":"PEMSSystemTrainingCost","v":5700},"$","5700","Quoted price."]
[null,null,"Shelter Cost","SC",98235,"$",null,null,null,null,null,null,"* Factory Acceptance Cost","PFAC",{"$f":"PEMSFactoryAcceptanceCost","v":1215},"$","1215","Quoted price."]
[null,null,null,null,null,null,null,null,null,null,null,null,"* First Year Audit Cost","PFYAC",{"$f":"PEMSFirstYearAuditCost","v":12765},"$","4255 * SRCS","Quoted price."]
[null,null,"Cooling Degree Days","CDD",376.66666670000001,"day · °C",null,null,null,null,null,null,"Total Cost (First Year)","PTCFY",{"$f":"PEMSTotalCostFirstYear","v":84521.728640000001},"$","PTCE + PSFUC + PMC + PEC + PDASSWC + PDASHWC + PDASSUPC + PSPC + PCC + PISUC + PC + PSTC + PFAC + PFYAC","Sum of the first year costs."]
[null,null,"Heating Degree Days","HDD",4080,"day · °C",null,null,null,null,null,null,"Total Cost (Annually Thereafter)","PTCA",{"$f":"PEMSTotalCostAnnual","v":28103.228640000001},"$","PTCE  + PSFUC + PMC + PDASSUPC + PSPC + PCC + PC","Sum of the annual costs."]
[null,null,"Cost of Electricity","COE",9.1300000000000006E-2,"$ / kWh",null,null,null,null,null,null,"* Denotes first year cost only."]

{"sheet":"Reference","index":1,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Location","CDD","HDD","Cost of Electricity",null,null,null,"Shelter Quality"]
[null,"Alabama",1166.666667,1206.1111109999999,0.1046,null,null,null,"N/A"]
[null,"Alaska",76.111111109999996,8231.6666669999995,0.14799999999999999,null,null,null,"Low"]
[null,"Arizona",1842.2222220000001,971.66666669999995,9.3299999999999994E-2,null,null,null,"Medium"]
[null,"Arkansas",1206.666667,1536.666667,7.8799999999999995E-2,null,null,null,"High"]
[null,"California",561.66666669999995,1379.444444,0.1239]
[null,"Colorado",282.77777780000002,3546.666667,9.4100000000000003E-2]
[null,"Connecticut",410,2794.4444440000002,0.15279999999999999]
[null,"Delaware",749.44444439999995,2096.1111110000002,0.1024,null,null,null,"Energy Consumption"]
[null,"Florida",1991.666667,293.88888889999998,9.74E-2,null,null,null,"Low"]
[null,"Georgia",1034.444444,1267.2222220000001,9.6500000000000002E-2,null,null,null,"Medium"]
[null,"Hawaii",2034.444444,21.666666670000001,0.34189999999999998,null,null,null,"High"]
[null,"Idaho",347.22222219999998,3462.7777780000001,6.83E-2]
[null,"Illinois",655,2834.4444440000002,7.9299999999999995E-2]
[null,"Indiana",638.88888889999998,2696.666667,9.2700000000000005E-2]
[null,"Iowa",589.44444439999995,3216.1111110000002,7.9699999999999993E-2]
[null,"Kansas",1013.8888889999999,2223.333333,9.5200000000000007E-2]
[null,"Kentucky",769.44444439999995,2141.1111110000002,8.7099999999999997E-2]
[null,"Louisiana",1583.8888890000001,711.11111110000002,8.9599999999999999E-2]
[null,"Maine",177.2222222,3874.4444440000002,0.12770000000000001]
[null,"Maryland",692.77777779999997,2290,0.104]
[null,"Massachusetts",342.77777780000002,2959.4444440000002,0.15140000000000001]
[null,"Michigan",422.22222219999998,3217.2222219999999,0.1084]
[null,"Minnesota",376.66666670000001,4080,9.1300000000000006E-2]
[null,"Mississippi",1272.2222220000001,1122.2222220000001,9.8100000000000007E-2]
[null,"Missouri",898.33333330000005,2262.2222219999999,7.8899999999999998E-2]
[null,"Montana",205.55555559999999,4185,9.2499999999999999E-2]
[null,"Nebraska",704.44444439999995,3072.7777780000001,8.2600000000000007E-2]
[null,"Nevada",1305.555556,1843.333333,8.7400000000000005E-2]
[null,"New Hampshire",240.55555559999999,3590,0.1394]
[null,"New Jersey",552.22222220000003,2478.333333,0.1196]
[null,"New Mexico",671.11111110000002,2337.7777780000001,9.2700000000000005E-2]
[null,"New York",446.11111110000002,2791.1111110000002,0.155]
[null,"North Carolina",840,1643.333333,8.6699999999999999E-2]
[null,"North Dakota",321.11111110000002,4614.4444439999997,7.9000000000000001E-2]
[null,"Ohio",551.66666669999995,2761.1111110000002,9.2899999999999996E-2]
[null,"Oklahoma",1268.8888890000001,1637.2222220000001,7.0300000000000001E-2]
[null,"Oregon",139.44444440000001,2807.7777780000001,8.3799999999999999E-2]
[null,"Pennsylvania",480.55555559999999,2760.5555559999998,9.1399999999999995E-2]
[null,"Rhode Island",334.44444440000001,2748.333333,0.15240000000000001]
[null,"South Carolina",1098.333333,1240,9.7900000000000001E-2]
[null,"South Dakota",575,3646.666667,8.1100000000000005E-2]
[null,"Tennessee",875,1772.7777779999999,9.74E-2]
[null,"Texas",1714.444444,803.33333330000005,8.0399999999999999E-2]
[null,"Utah",507.77777780000002,3177.2222219999999,7.8200000000000006E-2]
[null,"Vermont",213.88888890000001,3748.8888889999998,0.1391]
[null,"Virginia",696.11111110000002,2054.4444440000002,7.9699999999999993E-2]
[null,"Washington",109.44444439999999,3036.1111110000002,7.8100000000000003E-2]
[null,"West Virginia",528.88888889999998,2487.2222219999999,8.48E-2]
[null,"Wisconsin",394.44444440000001,3600,0.1076]
[null,"Wyoming",286.11111110000002,4016.1111110000002,8.3699999999999997E-2]