{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["CoverSheet","Data Entry & Emissions","MSW Summary","Biogenic Test Data","Emission Factors","Facility Info","Revision History"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":1,"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":"CoverSheet","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[12,5,12,9],[6,5,6,9],[7,5,7,9],[8,5,8,9],[9,5,9,9],[10,5,10,9],[11,5,11,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Macros must be enabled to use tool"]

{"sheet":"Data Entry & Emissions","index":1,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":true,"merged":[[22,9,22,10],[21,9,21,10],[8,9,8,10],[16,0,16,10],[13,9,13,10],[10,9,10,10],[1,2,1,8],[5,1,5,10],[19,9,19,10],[20,9,20,10],[18,9,18,10],[11,9,11,10],[12,9,12,10],[17,9,17,10],[7,0,7,10],[73,1,73,9],[25,9,25,10],[27,9,27,10],[31,1,31,9],[28,9,28,10],[26,9,26,10],[72,1,72,9]]}
["STEP 1.  Select Facility and Reporting Type",null,null,null,null,null,null,null,null,null,"Unit Reporting"]
[null,"Facility","Marion County"]
[null,"DOE / EIA ORIS Code",{"$f":"VLOOKUP(C2,Facility_Info,4)","v":50630}]
[null,"# of MWCs",{"$f":"VLOOKUP(C2,Facility_Info,5)","v":2}]
[null,"Max MWC Rated Input Cap. MMBtu/hr",{"$f":"MAX(VLOOKUP(C2,Facility_Info,9),VLOOKUP(C2,Facility_Info,15))","v":107.26}]
[]
["STEP 2:  Verify Boiler Design Data"]
["Boiler design information is critical to the Tier 2 calculation.  Please confirm that the figures below are the correct design values."]
[null,null,"Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Other Stationary Sources"]
[null,"Unit Number",1,2,3,4,5,6]
[null,"Included in Sum?","Yes",{"$f":"IF($K$1=\"Aggregated\",\"No\",IF($C$4>=2,\"Yes\",\"No\"))","v":"Yes"},{"$f":"IF($K$1=\"Aggregated\",\"No\",IF($C$4>=3,\"Yes\",\"No\"))","v":"No"},{"$f":"IF($K$1=\"Aggregated\",\"No\",IF($C$4>=4,\"Yes\",\"No\"))","v":"No"},{"$f":"IF($K$1=\"Aggregated\",\"No\",IF($C$4>=5,\"Yes\",\"No\"))","v":"No"},{"$f":"IF($K$1=\"Aggregated\",\"No\",IF($C$4>=6,\"Yes\",\"No\"))","v":"No"},"Yes"]
[null,"Max Rated Input Cap. (MMBtu/hr)",{"$f":"IF(C$11=\"Yes\",IF(VLOOKUP($C$2,Facility_Info,13)=C$10,VLOOKUP($C$2,Facility_Info,15),VLOOKUP($C$2,Facility_Info,9)),\"\")","v":107.26},107.26,"","","",""]
[null,"Design Steam (lbs/hr)",{"$f":"IF(C$11=\"Yes\",IF(VLOOKUP($C$2,Facility_Info,13)=C$10,VLOOKUP($C$2,Facility_Info,16)*1000,VLOOKUP($C$2,Facility_Info,10)*1000),\"\")","v":66700},66700,"","","",""]
[null,"B",{"$f":"IF(C$11=\"Yes\",C12/C13,\"\")","v":1.608095952023988E-3},{"$f":"IF(D$11=\"Yes\",D12/D13,\"\")","v":1.608095952023988E-3},"","","","",null,"Ratio of the boiler's maximum rated heat input capacity to its design rated steam output capacity (MMBtu/lb steam)"]
[]
["STEP 3:  Input Data"]
["Complete the boxes highlighted in green below and on the \"Biogenic Test Data\" tab.  Red boxes are calculated values and are LOCKED.  Facilities with auxiliary boilers (not fired by MSW) or other combustion sources (e.g., oil fired boilers used for space heating), use the column labeled \"Other Stationary Sources\" to calculate emissions.  Remember, any very large sources (>250 MMBtu/hr) must be tracked and reported separately.  Smaller sources may be combined into one or more groups for reporting."]
[null,"Data",{"$f":"C9","v":"Unit 1"},{"$f":"D9","v":"Unit 2"},"Unit 3","Unit 4","Unit 5","Unit 6","Other Stationary Sources","Notes"]
[null,"Total Steam (klbs)",537758.1,530298.5,null,null,null,null,null,"Annual steam production"]
[null,"Aux. Fuel 1","Nat. Gas (therms)",null,null,null,null,null,null,"Select auxiliary fuel from drop down menu"]
[null,"Aux. Fuel 1 Consumption",333634.09999999998,229026.9,null,null,null,null,null,"Annual natural gas consumption"]
[null,"Aux. Fuel 2",null,null,null,null,null,null,null,"Repeat for second aux. fuel combusted at facility"]
[null,"Aux. Fuel 2 Consumption"]
[null,"Aux. Fuel 3"]
[null,"Aux. Fuel 3 Consumption"]
[null,"MSW Throughput (tons)",90687.324999999997,89105.904999999999,null,null,null,null,null,"Annual MSW processed"]
[null,"Calc % Carbon in MSW",{"$f":"IF(C26=\"\",\"\",C35*1.1*(12/44)/C26)","v":0.25446103565137024},{"$f":"IF(D26=\"\",\"\",D35*1.1*(12/44)/D26)","v":0.25691119245456995},"","","",""]
[null,"fh",0.5,0.5,0.5,0.5,0.5,0.5,null,"Fraction of auxiliary fuel expended for boiler heating"]
[null,"MSW Steam (klbs)",{"$f":"IF(C14=\"\",\"\",C19-f_h/C14/1000*(C21*IF(C21=\"\",0,VLOOKUP($C20,Aux_FuelData,5))+C23*IF(C23=\"\",0,VLOOKUP($C22,Aux_FuelData,5))+C25*IF(C25=\"\",0,VLOOKUP($C24,Aux_FuelData,5))))","v":527384.52435670327},523177.44171639008,"","","",""]
[]
["STEP 4:  Review Emissions"]
[null,{"$f":"CONCATENATE(C2,\" GHG Emissions for 40 CFR 98 Reporting\")","v":"Marion County GHG Emissions for 40 CFR 98 Reporting"}]
[null,null,{"$f":"C18","v":"Unit 1"},"Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Other Stationary Sources","TOTAL"]
[null,"Emissions from MSW Combustion"]
[null,"Total CO2 (m.t.)",{"$f":"IF(C$11=\"No\",\"\",0.001*(C29*1000)*C14*EF_MSW_CO2)","v":76921.302133174657},76307.681027645434,"","","","",null,{"$f":"SUMIF(C$11:H$11,\"Yes\",C35:H35)","v":153228.98316082009}]
[null,"Fossil CO2 (m.t.)",{"$f":"IF(C$11=\"No\",\"\",C35*(1-f_Biogenic))","v":38652.954321920261},{"$f":"IF(D$11=\"No\",\"\",D35*(1-f_Biogenic))","v":38344.609716391824},"","","","",null,{"$f":"SUMIF(C$11:H$11,\"Yes\",C36:H36)","v":76997.564038312092}]
[null,"Biogenic CO2 (m.t.)",{"$f":"IF(C$11=\"No\",\"\",C35*f_Biogenic)","v":38268.347811254389},{"$f":"IF(D$11=\"No\",\"\",D35*f_Biogenic)","v":37963.071311253603},"","","","",null,76231.419122507999]
[null,"CH4 (m.t.)",{"$f":"IF(C$11=\"No\",\"\",0.001*(C29*1000)*C14*EF_MSW_CH4)","v":27.138717400899548},26.922224838860568,"","","","",null,54.060942239760116]
[null,"N2O (m.t.)",{"$f":"IF(C$11=\"No\",\"\",0.001*(C29*1000)*C14*EF_MSW_N2O)","v":3.5619566588680653},3.5335420101004495,"","","","",null,7.0954986689685153]
[null,"CH4 as CO2e (m.t.)",{"$f":"IF(C$11=\"No\",\"\",C38*GWP_CH4)","v":678.46793502248875},{"$f":"IF(D$11=\"No\",\"\",D38*GWP_CH4)","v":673.05562097151426},"","","","",null,1351.5235559940029]
[null,"N2O as CO2e (m.t.)",{"$f":"IF(C$11=\"No\",\"\",C39*GWP_N2O)","v":1061.4630843426835},{"$f":"IF(D$11=\"No\",\"\",D39*GWP_N2O)","v":1052.995519009934},"","","","",null,2114.4586033526175]
[]
[null,"Emissions from Aux Fuel 1:",{"$f":"C20","v":"Nat. Gas (therms)"}]
[null,{"$f":"IF(C43=\"Wood (ton)\",$B$37,$B$36)","v":"Fossil CO2 (m.t.)"},{"$f":"IF($C20=\"\",0,C21*VLOOKUP($C20,Aux_FuelData,5)*VLOOKUP($C20,Aux_FuelData,2)/1000)","v":1770.2625346},1215.2167314000001,0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C44:H44)+I44","v":2985.4792660000003}]
[null,"CH4 (m.t.)",{"$f":"IF($C20=\"\",0,C21*VLOOKUP($C20,Aux_FuelData,5)*VLOOKUP($C20,Aux_FuelData,3)/1000)","v":3.3363409999999996E-2},2.2902690000000003E-2,0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C45:H45)+I45","v":5.6266099999999999E-2}]
[null,"N2O (m.t.)",{"$f":"IF($C20=\"\",0,C21*VLOOKUP($C20,Aux_FuelData,5)*VLOOKUP($C20,Aux_FuelData,4)/1000)","v":3.336341E-3},2.2902690000000002E-3,0,0,0,0,0,5.6266100000000006E-3]
[null,"CH4 as CO2e (m.t.)",{"$f":"C45*GWP_CH4","v":0.83408524999999989},0.57256725000000008,0,0,0,0,0,1.4066524999999999]
[null,"N2O as CO2e (m.t.)",{"$f":"C46*GWP_N2O","v":0.99422961799999998},0.68250016200000008,0,0,0,0,0,1.6767297800000001]
[]
[null,"Emissions from Aux Fuel 2:",{"$f":"C22","v":0}]
[null,{"$f":"IF(C50=\"Wood (ton)\",$B$37,$B$36)","v":"Fossil CO2 (m.t.)"},{"$f":"IF($C22=\"\",0,C23*VLOOKUP($C22,Aux_FuelData,5)*VLOOKUP($C22,Aux_FuelData,2)/1000)","v":0},0,0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C51:H51)+I51","v":0}]
[null,"CH4 (m.t.)",{"$f":"IF($C22=\"\",0,C23*VLOOKUP($C22,Aux_FuelData,5)*VLOOKUP($C22,Aux_FuelData,3)/1000)","v":0},0,0,0,0,0,0,0]
[null,"N2O (m.t.)",{"$f":"IF($C22=\"\",0,C23*VLOOKUP($C22,Aux_FuelData,5)*VLOOKUP($C22,Aux_FuelData,4)/1000)","v":0},0,0,0,0,0,0,0]
[null,"CH4 as CO2e (m.t.)",{"$f":"C52*GWP_CH4","v":0},0,0,0,0,0,0,0]
[null,"N2O as CO2e (m.t.)",{"$f":"C53*GWP_N2O","v":0},0,0,0,0,0,0,0]
[]
[null,"Emissions from Aux Fuel 3:",{"$f":"C24","v":0}]
[null,{"$f":"IF(C57=\"Wood (ton)\",$B$37,$B$36)","v":"Fossil CO2 (m.t.)"},{"$f":"IF($C24=\"\",0,C25*VLOOKUP($C24,Aux_FuelData,5)*VLOOKUP($C24,Aux_FuelData,2)/1000)","v":0},0,0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C58:H58)+I58","v":0}]
[null,"CH4 (m.t.)",{"$f":"IF($C24=\"\",0,C25*VLOOKUP($C24,Aux_FuelData,5)*VLOOKUP($C24,Aux_FuelData,3)/1000)","v":0},0,0,0,0,0,0,0]
[null,"N2O (m.t.)",{"$f":"IF($C24=\"\",0,C25*VLOOKUP($C24,Aux_FuelData,5)*VLOOKUP($C24,Aux_FuelData,4)/1000)","v":0},0,0,0,0,0,0,0]
[null,"CH4 as CO2e (m.t.)",{"$f":"C59*GWP_CH4","v":0},{"$f":"D59*GWP_CH4","v":0},0,0,0,0,0,0]
[null,"N2O as CO2e (m.t.)",{"$f":"C60*GWP_N2O","v":0},{"$f":"D60*GWP_N2O","v":0},0,0,0,0,0,0]
[]
[null,"Summary (m.t.)"]
[null,"Fossil CO2",{"$f":"IF(C36=\"\",0,C36)+SUMIF($B44:$B62,$B$36,C44:C62)","v":40423.216856520259},{"$f":"IF(D36=\"\",0,D36)+SUMIF($B44:$B62,$B$36,D44:D62)","v":39559.826447791827},0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C65:H65)+I65","v":79983.043304312087}]
[null,"Biogenic CO2",{"$f":"IF(C37=\"\",0,C37)+SUMIF($B44:$B62,$B$37,C44:C62)","v":38268.347811254389},{"$f":"IF(D37=\"\",0,D37)+SUMIF($B44:$B62,$B$37,D44:D62)","v":37963.071311253603},0,0,0,0,0,76231.419122507999]
[null,"CH4",{"$f":"SUM(C38,C45,C52,C59)","v":27.172080810899548},{"$f":"SUM(D38,D45,D52,D59)","v":26.945127528860567},0,0,0,0,0,54.117208339760111]
[null,"N2O",{"$f":"SUM(C39,C46,C53,C60)","v":3.5652929998680651},{"$f":"SUM(D39,D46,D53,D60)","v":3.5358322791004495},0,0,0,0,0,7.1011252789685146]
[null,"CH4 as CO2e",{"$f":"C67*GWP_CH4","v":679.30202027248868},{"$f":"D67*GWP_CH4","v":673.62818822151416},0,0,0,0,0,1352.9302084940027]
[null,"N2O as CO2e",{"$f":"C68*GWP_N2O","v":1062.4573139606835},{"$f":"D68*GWP_N2O","v":1053.678019171934},0,0,0,0,0,{"$f":"SUMIF(C$11:H$11,\"Yes\",C70:H70)+I70","v":2116.1353331326172}]
[]
[null,"Total CO2e (m.t., excl. bio. CO2)",{"$f":"C65+C69+C70","v":42164.976190753427},41287.132655185276,0,0,0,0,0,{"$f":"IF(SUM(J65,J69,J70)<>SUMIF(C$11:H$11,\"Yes\",C72:H72)+I72,\"ERROR\",SUM(J65,J69,J70))","v":83452.108845938696}]
[]
[null,{"$f":"IF(ISERROR((J65+J66)*1.1*(12/44)/SUM(C26:H26)),\"\",IF((J65+J66)*1.1*(12/44)/SUM(C26:H26)>0.34,\"Your total (fossil & biogenic) CO2 emissions are higher than the expected range.  Please check your inputs.\",IF((J65+J66)*1.1*(12/44)/SUM(C26:H26)<0.22,\"Your total (fossil & biogenic) CO2 emissions are lower than the expected range.  Please check your inputs.\",\"\")))","v":""}]

{"sheet":"MSW Summary","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Emissions from MSW Combustion","Unit 1","Unit 2"]
["Total CO2 (MT)",{"$f":"'Data Entry & Emissions'!$C$35","v":76921.302133174657},{"$f":"'Data Entry & Emissions'!$D$35","v":76307.681027645434}]
["Biogenic CO2 (MT)",{"$f":"'Data Entry & Emissions'!$C$37","v":38268.347811254389},{"$f":"'Data Entry & Emissions'!$D$37","v":37963.071311253603}]
["Fossil CO2 (MT)",{"$f":"'Data Entry & Emissions'!$C$36","v":38652.954321920261},{"$f":"'Data Entry & Emissions'!$D$36","v":38344.609716391824}]
["CH4 as CO2e (MT)",{"$f":"'Data Entry & Emissions'!$C$40","v":678.46793502248875},{"$f":"'Data Entry & Emissions'!$D$40","v":673.05562097151426}]
["N2O as CO2e (MT)",{"$f":"'Data Entry & Emissions'!$C$41","v":1061.4630843426835},{"$f":"'Data Entry & Emissions'!$D$41","v":1052.995519009934}]
["Total Fossil CO2e (MT)",{"$f":"SUM(B6:B8)","v":40392.885341285437},{"$f":"SUM(C6:C8)","v":40070.660856373273}]
[]
["Entries into ODEQ tool"]

{"sheet":"Biogenic Test Data","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,3],[15,1,15,2]]}
[]
[null,"Quarterly CO2 Analysis Results"]
[null,"Biogenic Sample","Sample Date","Biomass CO2 Content"]
[null,null,"2021-02-02",0.51]
[null,null,"2021-04-13",0.48]
[null,null,"2021-08-19",0.51]
[null,null,"2021-10-11",0.49]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Annual Average",null,{"$f":"AVERAGE(D4:D15)","v":0.4975}]

{"sheet":"Emission Factors","index":4,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,1,1,6],[1,10,2,10],[1,7,1,8]]}
[]
[null,"Default Emission Factors & HHVs",null,null,null,null,null,"Expected Range",null,null,"Default High Heat Values (40 CFFR 98, Table C-1)"]
[null,"Fuel","CO2 Emission Factor\n(kg CO2 / MMBtu)","CH4 Emission Factor\n(kg CH4 / MMBtu)","N2O Emission Factor\n(kg N2O / MMBtu)","High Heat\nValue","Default High Heat Value Units (MMBtu / ?)","Minimum","Maximum"]
[null,"#1 Fuel Oil (kgal.)",73.25,3.0000000000000001E-3,5.9999999999999995E-4,139,"kgal.",0,1000,null,139]
[null,"#2 Fuel Oil (kgal.)",73.959999999999994,3.0000000000000001E-3,5.9999999999999995E-4,138,"kgal.",0,1000,null,138]
[null,"Kerosene (kgal.)",75.2,3.0000000000000001E-3,5.9999999999999995E-4,135,"kgal.",0,1000,null,135]
[null,"LPG (kgal.)",61.71,3.0000000000000001E-3,5.9999999999999995E-4,92,"kgal.",0,1000,null,92]
[null,"Nat. Gas (kscf)",53.06,1E-3,1E-4,1.0580000000000001,"kscf",0,500000,null,1.026]
[null,"Nat. Gas (MMBtu)",53.06,1E-3,1E-4,1,"MMBtu",0,500000,null,1]
[null,"Nat. Gas (therms)",53.06,1E-3,1E-4,0.1,"therm",0,5000000,null,0.1]
[null,"Propane (kgal.)",62.87,3.0000000000000001E-3,5.9999999999999995E-4,91,"kgal.",0,1000,null,91]
[null,"Used Oil (kgal.)",74,3.0000000000000001E-3,5.9999999999999995E-4,138,"kgal.",0,1000,null,138]
[null,"Wood (ton)",93.8,7.1999999999999998E-3,3.5999999999999999E-3,17.48,"ton",0,50000,null,17.48]
[null,"MSW",90.7,3.2000000000000001E-2,4.1999999999999997E-3,"n/a","n/a"]
[]
[]
[null,"Global Warming Potentials (GWP)"]
[null,"CH4 ",25]
[null,"N2O ",298]

{"sheet":"Facility Info","index":5,"n_rows":45,"n_cols":17,"rows_kept":45,"cut":false,"hidden":true,"merged":[[1,12,1,16],[1,7,1,10]]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]
[null,null,null,null,null,null,null,"Original Units",null,null,null,null,"Additional Unit(s)"]
["Facility","State","Ops Code","DOE ORIS ID","Total # of MWCs","MWC Type","Year of Initial Comm. Operation","Design HHV (Btu/lb)","Max. Rated Input Cap. (mmBTU/hr)","Design Steam Flow (Klbs/hr)","Design Heat Input/Design Steam Flow (mmBTU / lb)","All MWCs Same B?","Unit #","Design HHV (Btu/lb)","Max Rated Input Cap. (mmBTU/hr)","Design Steam Flow (Klbs/hr)","Design Heat Input/Design Steam Flow (mmBTU / lb)"]
["Alexandria","VA","ALX",50663,3,"MB",1988,4500,121.8,78.459999999999994,{"$f":"I4/J4/1000","v":1.5523833800662758E-3},"Yes"]
["Babylon","NY","BAB ",50649,2,"MB",1989,4450,139,86.11,{"$f":"I5/J5/1000","v":1.6142143769597029E-3},"Yes"]
["Bristol","CT","BRI ",50648,2,"MB",1988,4500,121.87,73.2,1.6648907103825137E-3,"Yes"]
["Burnaby","BC","BUR","n/a",3,"MB",null,5400,{"$f":"5400*(800/3)*2000/24/1000000","v":120},80.3,1.4943960149439602E-3,"Yes"]
["Camden","NJ","CAM",10435,3,"MB",null,5300,154.58000000000001,105.5,1.4652132701421803E-3,"Yes"]
["Delaware Valley","PA","DLV",10746,6,"MB",1992,4903,194,140.30000000000001,1.3827512473271559E-3,"Yes"]
["Durham-York","ON","DYK","n/a",2,"MB",2015,5589,{"$f":"5589*(481/2)*2000/24/1000000","v":112.01287499999999},74.186000000000007,1.5098923651362787E-3,"Yes"]
["Essex County","NJ","ESC",10643,3,"MB",1990,5300,336.55,217.15199999999999,1.5498360595343355E-3,"Yes"]
["Fairfax County","VA","FFX",50658,4,"MB",1990,5500,343.8,205.625,1.6719756838905774E-3,"Yes"]
["Harrisburg","PA","HRB",10118,3,"MB",1972,5200,115.56,68.569999999999993,1.6852851101064607E-3,"Yes"]
["Haverhill","MA","HAV ",50661,2,"MB",1989,5000,343.75,198.21899999999999,1.7341929885631548E-3,"Yes"]
["Hempstead","NY","HEM ",10642,3,"MB",1989,5200,337.13,210,1.6053809523809523E-3,"Yes"]
["Hennepin County","MN","HER",10013,2,"MB",1989,5200,262.60000000000002,171.376,1.5323032396601626E-3,"Yes"]
["Hillsborough County","FL","HIL ",50858,4,"MB",1987,4500,{"$f":"4500*400*2000/24/1000000","v":150},94.27,1.5911742866235284E-3,"No",4,5000,254,167.21899999999999,{"$f":"O17/P17/1000","v":1.5189661461915214E-3}]
["Honolulu (H-Power)","HI","HRR",10334,3,"RDF/MB",1990,5137,366,244,1.5E-3,"No",3,5400,405,283,{"$f":"O18/P18/1000","v":1.4310954063604239E-3}]
["Huntington","NY","HTG",50656,3,"MB",1991,6000,125,74.846999999999994,1.6700736168450308E-3,"Yes"]
["Huntsville","AL","HTV","n/a",2,"MB",1990,4500,129.4,89.31,1.4488859030343745E-3,"Yes"]
["Indianapolis","IN","IND ",50647,3,"MB",1988,4792,314.5,172.81800000000001,1.8198335821500073E-3,"Yes"]
["Kent County","MI","KEN ",50860,2,"MB",1990,4800,130,76.8,1.6927083333333334E-3,"Yes"]
["Lake County","FL","NRG",50629,2,"MB",1991,5000,110,64.400000000000006,1.7080745341614904E-3,"Yes"]
["Lancaster County","PA","LAN ",50859,3,"MB",1991,5000,166.6,96.72,1.7224979321753516E-3,"Yes"]
["Lee County","FL","LEE  ",52010,3,"MB",1994,5000,275,170.29900000000001,1.61480689845507E-3,"No",3,null,265,172.267,{"$f":"O25/P25/1000","v":1.5383097168929626E-3}]
["Long Beach","CA","LGB",50837,3,"MB",1988,4654,{"$f":"4654*1380*2000/24/1000000/E26","v":178.40333333333334},117.17,1.5226024864157493E-3,"Yes"]
["MacArthur","NY","MAC",51038,2,"MB",1990,4500,93.75,57.9,1.6191709844559584E-3,"Yes"]
["Marion County","OR","MAR ",50630,2,"MB",1987,4500,107.26,66.7,1.608095952023988E-3,"Yes"]
["Montgomery County","MD","MON ",50657,3,"MB",1995,5500,275,171.1,1.6072472238457044E-3,"Yes"]
["Niagara Falls","NY","NIA ",50472,2,"MB",1980,5200,452.05,299.44600000000003,1.5096211002985512E-3,"Yes"]
["Onondaga County","NY","ONO",50662,3,"MB",1995,6000,165,103.94199999999999,1.5874237555559831E-3,"Yes"]
["Pasco County","FL","PAS ",50666,3,"MB",1991,4800,140,90.367000000000004,1.5492381068310335E-3,"Yes"]
["Pinellas","FL","PIN",50884,3,"MB",null,4800,{"$f":"4800*(3000/3)*2000/24/1000000","v":400},244,1.639344262295082E-3,"Yes"]
["Pittsfield","MA","PIT ","n/a",2,"MB",1981,4500,45,34,1.3235294117647058E-3,"Yes"]
["Plymouth","PA","PLY",54625,2,"MB",1992,4500,{"$f":"4500*1216*2000/24/1000000/E35","v":228},148,1.5405405405405407E-3,"Yes"]
["Preston (SEConn)","CT","SEC",10646,2,"MB",1991,5000,129.69999999999999,75,1.7293333333333332E-3,"Yes"]
["Rochester (SEMASS)","MA","SMA",50290,3,"RDF",1988,5000,375,270.79599999999999,1.3848062748341924E-3,"Yes"]
["SE Florida (Dade)","FL","DAD",10062,4,"RDF",1985,5400,{"$f":"5400*3000*2000/24/1000000/E38","v":337.5},180,1.8749999999999999E-3,"Yes"]
["Springfield","MA","SPR ",50273,3,"MB",1988,4500,153,96.6,1.5838509316770187E-3,"Yes"]
["Stanislaus County","CA","STN",50632,2,"MB",1989,5200,173.33,100.5,1.7246766169154231E-3,"Yes"]
["Tulsa","OK","TUL",50660,3,"MB",1986,4500,140.5,88.427999999999997,1.5888632559822682E-3,"Yes"]
["Union County","NJ","UNI ",50960,3,"MB",1991,5400,216,125.223,1.724922737835701E-3,"Yes"]
["Wallingford","CT","WAL ",50664,3,"MB",1989,5000,58.3,35.741,1.6311798774516662E-3,"Yes"]
["Warren County","NJ","WER",10012,2,"MB",1988,5300,98.97,56.216999999999999,1.7604994930359144E-3,"Yes"]
["York","PA","YOR",50215,3,"MB",1989,4500,{"$f":"4500*1344*2000/24/1000000/E45","v":168},119.6,1.4046822742474919E-3,"Yes"]

{"sheet":"Revision History","index":6,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Who","Changes"]
[2,"2014-01-10","MVB","- Added Camden, H-Power unit 3, and Tulsa gasification unit (Unit 3)\n- Updated GWPs, emission factors and default HHVs to reflect Nov 2013 MRR revision\n- Updated start screen with new corporate logo\n- Revise macro to hide fuel specific CO2 data for Tier 4 facilities (facilities need to use CERMS data)\n- Fixed MSW steam equation to subtract steam input from aux. fuel #3 (previously only aux fuels 1&2 were considered)\n- Added data validation to steam and aux. fuel inputs\n- Removed instructions pertaining to 2010 reporting year\n- Added data check on total CO2 emissions relative to MSW processed"]
["2.0.1","2014-03-04","MVB","- Revised Camden steam production per boiler from 105.4 to 105.5 klb / hr (increase of <0.1%)\n- Corrected error in equation for lookup of design steam values for different \"last\" unit, impacts Lee, Hillsborough, and H-Power\n- Corrected spacing error in \"Aggregate data\" message box,  updated references to \"rated\" max heat input, removed unused macros in Module 1"]
[2.1,"2015-02-11","MVB","- Added Pinellas, Durham-York, and Burnaby. ( Canadian facilities added for information purposes.)  \n- Removed Hudson Valley.  \n- Corrected error in default C-1 factors for natural gas (factor for MMBtu & kcuft were reversed, but reflected correctly in the main table)"]
["2.1.1","2015-02-19","MVB","- Removed references in notes column on data entry sheet to specific year (2013)\n- Updated Durham-York design data to reflect latest design data from operations"]