{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Efficiency Calc's","Scratch Sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Efficiency Calc's","index":0,"n_rows":50,"n_cols":39,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,5,10,14],[11,5,11,14],[0,2,0,4],[12,0,12,2],[9,0,9,2],[0,7,0,8],[1,2,1,4],[1,7,1,8],[10,0,10,2],[6,0,6,2],[7,0,7,2],[2,1,4,14],[6,5,6,14],[7,5,7,14],[12,5,12,14],[13,5,13,14],[14,5,14,14],[14,0,14,2],[14,3,14,4],[49,0,49,1],[46,0,46,1],[39,0,39,1],[39,5,40,8],[48,0,48,2],[42,0,42,2],[43,0,43,1],[41,0,41,3],[45,0,45,2],[36,0,36,2],[37,0,37,1],[38,0,38,1],[13,3,13,4],[8,5,8,14],[9,5,9,14],[11,0,11,2],[8,0,8,2],[33,0,33,1],[15,0,15,1],[12,3,12,4],[34,0,34,1],[15,4,15,7],[31,0,31,2],[32,0,32,1],[13,0,13,2]]}
[null,"Applicant:",null,null,null,null,"Date:"]
[null,"Host Customer: ",null,null,null,null,"Application No.:"]
["Instructions:","This spreadsheet calculates the operating system efficiency, system efficiency and emissions eligibility of generation systems applying to the Self-Generating Incentive Program for incentives.  Applicants must provide documentation supporting all inputs including but not limited to system capacity, fuel consumption, waste heat recovery rate, baseline emissions, operating schedule, equivalent full load operating hours and thermal load.  See the 2011 SGIP Handbook for details of eligibility and documentation requirements.  All yellow cells must be completed by Applicant/Host Customer."]
[]
[]
[]
["Rated Net Generating Capacity =",null,null,null,"kW","Full load net continuous rated capacity of the packaged prime mover/generator at ISO conditions."]
["Ancillary Generating System Loads =",null,null,null,"kW","Any ancillary equipment loads necessary for the operation of the generator (e.g., fuel compressors, intercooler chillers, etc.) not accounted for in the Rated Net Generating Capacity."]
["Fuel Consumption Rate (LHV) =",null,null,null,"Btu/hr","Provided by manufacturer or calculated from rated capacity and generator efficiency or heat rate specifications.  Based on lower heating value of fuel."]
["Fuel Consumption Rate (HHV) =",null,null,null,"Btu/hr","Provided by manufacturer or calculated from rated capacity and generator efficiency or heat rate specifications.  Based on higher  heating value of fuel."]
["Waste Heat Recovery Rate =",null,null,null,"Btu/hr","Recoverable heat as specified by manufacturer of generator or waste heat recovery unit at full load conditions.  This is not total waste heat of the unit.  The value provided should be supported by Generating System specifications (if packaged unit), Waste Heat Recovery System specifications, or engineering analysis of recoverable waste heat."]
["Generator Emissions =",null,null,null,"lbs/MWh","NOx emissions specifications for the proposed generating system as configured, including emissions controls, for the Host Customer Site at rated conditions.  The value provided should be supported by factory testing, other installation source tests or engineering calculations."]
["Fuel Type =",null,null,"Non-Renewable ",null,"Non-Renewable fuels are any fossil based fuels such as natural gas.  Renewable fuels include landfill and digester gas.  Waste gas are fuels strictly defined as natural gas that is generated as a byproduct of petroleum production operations and is not eligible for delivery to the utility pipeline system."]
["Fuel Cell ?",null,null,null,null,"Is the proposed generator a fuel cell?"]
["Feed-in Tariff Qualified?",null,null,null,null,"Is the proposed generator qualified for the Feed-in Tariff?"]
[]
["Month","Std Hours Per Month (hrs)","Generator Equivalent Full Load Hours per Month (hrs)","Capacity Factor","Generator Electric Output per Month (kWh)","Facility Electrical Load (kWh)","Recovered Waste Heat per Month (Btu)","Thermal Load per Month (Btu)","Thermal Load Coincidence Factor","Useful thermal energy output (Btu)","Fuel Input (LHV Btu)","Fuel Input (HHV Btu)","Gross GHG Generated (kg CO2)","GHG Savings from Heat Recovery (kg CO2)","Net GHG Emissions (kg CO2)"]
["Jan",744,null,{"$f":"C18/B18","v":0},{"$f":"C18*($D$7-$D$8)","v":0},null,{"$f":"C18*$D$11","v":0},null,{"$f":"G18/H18","v":{"$error":"#DIV/0!"}},{"$f":"MIN(G18,H18)","v":0},{"$f":"C18*$D$9","v":0},{"$f":"C18*$D$10","v":0},{"$f":"L18*53.02/1000000","v":0},{"$f":"J18/(0.8*1000000)*53.02","v":0},{"$f":"M18-N18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Renewable ",null,false]
["Feb",672,null,0,{"$f":"C19*($D$7-$D$8)","v":0},null,0,null,{"$f":"G19/H19","v":{"$error":"#DIV/0!"}},0,0,0,{"$f":"L19*53.02/1000000","v":0},{"$f":"J19/(0.8*1000000)*53.02","v":0},{"$f":"M19-N19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renewable",null,false]
["Mar",744,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waste Gas"]
["Apr",720,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["May",744,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Jun",720,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Jul",744,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Aug",744,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Sep",720,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Oct",744,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Nov",720,null,0,0,null,0,null,{"$error":"#DIV/0!"},0,0,0,0,0,0]
["Dec",744,null,0,0,null,0,null,{"$f":"G29/H29","v":{"$error":"#DIV/0!"}},0,0,0,0,{"$f":"J29/(0.8*1000000)*53.02","v":0},0]
["Annual Total",{"$f":"SUM(B18:B29)","v":8760},{"$f":"SUM(C18:C29)","v":0},0,{"$f":"SUM(E18:E29)","v":0},{"$f":"SUM(F18:F29)","v":0},0,0,null,0,0,0,0,0,0]
[]
["Minimum Operating Efficiency Eligibility =",null,null,{"$f":"IF($D$13=\"Renewable\",\"EXEMPT\",IF(OR(AND(E33,E34),E35),\"PASS\",\"FAIL\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$13=\"Renewable\",\"Renewable Fuel Generators are Exempt from the Minimum Operating Efficiency Requirement\",\"\")","v":""}]
["P.U. Code 216.6 (a) =",null,{"$f":"$J$30/($E$30*3413+$J$30)","v":{"$error":"#DIV/0!"}},"≥ 5%",{"$f":"(C33>=0.05)","v":{"$error":"#DIV/0!"}},"Public Utilities Code 216.6(a) & 18CFR Part 292"]
["P.U. Code 216.6 (b) =",null,{"$f":"($E$30*3413+0.5*$J$30)/$K$30","v":{"$error":"#DIV/0!"}},"≥ 42.5%",{"$f":"(C34>=0.425)","v":{"$error":"#DIV/0!"}},"Public Utilities Code 216.6(b) & 18CFR Part 292"]
["Minimum Electric Efficiency =","Minimum Electric Efficiency =",{"$f":"D7*3413/D10","v":{"$error":"#DIV/0!"}},"≥ 40%",{"$f":"(C35>=0.4)","v":{"$error":"#DIV/0!"}},"Public Utilities Code 353.2 and 379.6"]
[]
["NOx Emissions Eligibility =",null,null,{"$f":"IF(OR($D$13=\"Waste Gas\",$D$13=\"Renewable\",$AM$18), \"EXEMPT\", IF(AND(E38,OR(E39,E40)),\"PASS\",\"FAIL\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR($D$13=\"Waste Gas\",$D$13=\"Renewable\"),\"Waste Gas & Renewable Fuel Generators are Exempt from the Emissions Requirements\",\"\")","v":""}]
["AB 1685 Total Efficiency =",null,{"$f":"($D$7*3413+$D$11)/$D$10","v":{"$error":"#DIV/0!"}},"≥ 60%",{"$f":"(C38>=0.6)","v":{"$error":"#DIV/0!"}},"Public Utilities Code 353.2 and 379.6"]
["NOx Emissions w/o CHP Credits =",null,{"$f":"D12","v":0},"≤ 0.07 lb/MWh",{"$f":"(C39<=0.07)","v":true},"Public Utilities Code 353.2 and 379.6"]
["NOx Emissions w/ CHP Credits =",null,{"$f":"(C39*D7/1000)/(D7/1000+J30/1000000/3.4/C30)","v":{"$error":"#DIV/0!"}},"≤ 0.07 lb/MWh",{"$f":"(C40<=0.07)","v":{"$error":"#DIV/0!"}},"Public Utilities Code 379.6 and Calif. ARB, Guidance for the Permitting of Electric Generation Technologies, Appendix D: Quantifying CHP Benefits, July 2002."]
[]
[]
["GHG Emissions Eligibility =",null,null,{"$f":"IF($D$13=\"Renewable\", \"EXEMPT\", IF(E44,\"PASS\",\"FAIL\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$13=\"Renewable\",\"Renewable Fuel Generators are Exempt from the Emissions Requirements\",\"\")","v":""}]
["GHG Emissions (kg CO2/MWh) =",null,{"$f":"O30/(E30/1000)","v":{"$error":"#DIV/0!"}},"< 379",{"$f":"(C44<379)","v":{"$error":"#DIV/0!"}},"CPUC Decision 11-09-015"]
[]
["Coincidence of Thermal Load =",null,null,{"$f":"IF($D$13=\"Renewable\",\"EXEMPT\",IF(E47,\"PASS\",\"FAIL\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$13=\"Renewable\",\"Renewable Fuel Generators are Exempt from the Coincidence of Load Requirements\",\"\")","v":""}]
["Max Thermal Load Coincidence Factor=",null,{"$f":"MAX(I18:I29)","v":{"$error":"#DIV/0!"}},"≤ 1.0",{"$f":"(C47<=1)","v":{"$error":"#DIV/0!"}},"CPUC Decision 11-09-015"]
[]
["Electrical Export Eligible =",null,null,{"$f":"IF(E50,\"PASS\",\"FAIL\")","v":{"$error":"#DIV/0!"}},{"$f":"IF($D$13=\"Renewable\",\"Renewable Fuel Generators are Exempt from the Coincidence of Load Requirements\",\"\")","v":""}]
["Electrical Export Factor=",null,{"$f":"E30/F30","v":{"$error":"#DIV/0!"}},{"$f":"IF(AM19=TRUE,\"≤1.25\",\"≤1.00\")","v":"≤1.00"},{"$f":"(C50<=IF(AM19=TRUE,1.25,1))","v":{"$error":"#DIV/0!"}},"CPUC Decision 11-09-015"]

{"sheet":"Scratch Sheet","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}