{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FIA","CompressionService","Therms","ConstructionCosts"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":80,"comments":4,"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":"FIA","index":0,"n_rows":296,"n_cols":47,"rows_kept":296,"cut":false,"hidden":false,"merged":[[288,4,293,5],[10,1,12,2],[171,2,171,3],[76,4,76,8],[77,5,79,5],[77,8,79,8],[77,7,79,7],[77,6,79,6],[159,1,160,2],[77,1,79,1],[42,1,42,4],[16,2,16,8],[76,1,76,2],[77,2,79,2],[54,5,54,6],[77,9,77,13],[76,9,76,13],[56,8,56,9],[264,4,269,5],[276,4,281,5],[41,34,46,34],[42,32,46,33],[41,7,47,8],[4,11,4,12],[5,11,5,12],[0,16,0,28],[1,16,1,28],[8,0,9,1],[6,0,7,2],[9,4,9,7],[0,2,0,6],[1,3,1,8],[0,7,0,8],[7,4,7,7],[5,4,5,7],[8,5,8,6],[6,4,6,7],[0,11,0,12],[1,11,1,12],[2,11,2,12],[3,11,3,12]]}
[null,null,"NATURAL GAS COMPRESSION SERVICE CHARGE ANALYSIS",null,null,null,null,{"$f":"\"Version: P_\"&Q3","v":"Version: P_FIA_CNG_v1_P_12-21-2012.xlsm"},null,null,null,"CNG MODIFICATION KEY:",null,null,null,null,"In compliance with UG-120747 line extension O&M costs and FIT rider, UG-091548 line extension standard costs, and UG-111050 capital structure and margin rates (Password-protected)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Selection"]
[null,null,null,"INPUT PROJECT ATTRIBUTES",null,null,null,null,null,null,null,"New additions",null,null,null,null,"BASE MARGIN RATES -- Effective 5/14/2012"]
[null,null,null,"Attribute A","LATECOMER OR ADDITION PRIOR TO REVIEW? (Yes or No)",null,null,null,"No",null,null,"Add CNG to Formula",null,null,null,null,"FIA_CNG_v1_P_12-21-2012.xlsm",23,31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T",null,null,"Valid Rate Schedules","Yes/No","NCR",null,null,null,"Service/Structure Type","Expected Years of Revenue"]
[null,null,null,"Attribute B","DEVELOPER PLAT? (Yes or No)",null,null,null,"No",null,null,"Input from CompressService Tab",null,null,null,null,"Customer Charge",10.34,33.42,367.59,114.22,440.55,{"$f":"R4","v":10.34},"ADDITIONAL REVENUE",563.45000000000005,901.5,144.01,458.22,579.19000000000005,926.71,null,null,23,"Yes",0.17,null,null,null,"Single Family Residences",33]
[null,null,null,"Attribute C","FINAL REVIEW?",null,null,null,"No",null,null,"Not Applicable",null,null,null,null,"Therm Charge - Block 1",0.38640999999999998,0.32599,{"$f":"-0.00539+S5","v":0.3206},0.14649000000000001,{"$f":"-0.00539+U5","v":0.1411},{"$f":"R5","v":0.38640999999999998},null,{"$f":"0.00682+Z5","v":0.11262},0.10580000000000001,0.21162,0.20480000000000001,{"$f":"0.00539+AD5","v":0.15224000000000001},0.14685000000000001,null,null,31,"No",0.115,null,null,null,"Mobile Home",10]
[null,null,null,"Attribute D","FACILITY MODIFICATION FOR EXISTING GAS CUSTOMER w/ SCHEDULE 7 VOLUME ALLOWANCE? (Yes or No)\nNCR/QP option is not available.  ",null,null,null,"No",{"$f":"IF(OR(AND($I$6=\"Yes\",$I$7=\"Yes\"),AND($I$6=\"Yes\",$I$8=\"Yes\"),AND($I$7=\"Yes\",$I$8=\"Yes\")),\"Please check your entry in CELL I6, I8 & I7 and choose 'Yes' in only one of the three cells.\",\"\")","v":""},null,"Goal Seek Result",null,null,null,null,"Therm Charge - Block 2",null,null,null,0.11953999999999999,{"$f":"-0.00539+U6","v":0.11414999999999999},null,null,6.1059999999999996E-2,5.4239999999999997E-2,0.15365999999999999,0.14684,9.5050000000000009E-2,8.9660000000000004E-2,null,null,"31T",null,null,null,null,null,"Multi-Family Dwellings - (2+ Units, Individual Metered)",33]
["NATURAL GAS COMPRESSION SERVICE CHARGE ANALYSIS",null,null,"Attribute E","FACILITY MODIFICATION FOR EXISTING GAS CUSTOMER w/ NO ADDITIONAL REVENUE? (Yes or No)\nRevenue in this case means incremental revenue to PSE due to increased therm usage by the customer, NOT revenue credits due to Schedule 7 volume allowances.\nNCR/QP option is not available.  ",null,null,null,"No",{"$f":"IF(OR(AND($I$6=\"Yes\",$I$7=\"Yes\"),AND($I$6=\"Yes\",$I$8=\"Yes\"),AND($I$7=\"Yes\",$I$8=\"Yes\")),\"Please check your entry in CELL I6, I8 & I7 and choose 'Yes' in only one of the three cells.\",\"\")","v":""},null,null,null,null,null,null,"Therm Charge - Block 3",null,null,null,null,null,null,null,5.8880000000000002E-2,5.2060000000000002E-2,null,null,6.3280000000000003E-2,5.7889999999999997E-2,null,null,41,null,null,null,null,null,"Multi-Family Dwellings - (2+ Units, Master Metered)",20]
[null,null,null,"Attribute F","NEW FACILITY EXTENSION w/ NO SCHEDULE 7 VOLUME ALLOWANCE? (Yes or No)\nSchedule 7 provides volume allowance ONLY for space heating, water heating range, dryer, hot tub and fireplace uses.\nNCR/QP option is not available. ",null,null,null,"No",{"$f":"IF(OR(AND($I$6=\"Yes\",$I$7=\"Yes\"),AND($I$6=\"Yes\",$I$8=\"Yes\"),AND($I$7=\"Yes\",$I$8=\"Yes\")),\"Please check your entry in CELL I6, I8 & I7 and choose 'Yes' in only one of the three cells.\",\"\")","v":""},null,null,null,null,null,null,"Therm Charge - Block 4",null,null,null,null,null,null,null,null,null,null,null,4.3339999999999997E-2,3.7949999999999998E-2,null,null,"41T",null,null,null,null,null,"Commercial, Industrial, Mixed-Use",20]
[{"$f":"Q1","v":"In compliance with UG-120747 line extension O&M costs and FIT rider, UG-091548 line extension standard costs, and UG-111050 capital structure and margin rates (Password-protected)"},null,null,"Attribute G","EXPECTED YEARS OF REVENUE: (Years)",{"$f":"IF(OR(NOT(ISERROR(FIND(\"T\",LEFT(C19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(D19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(E19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(F19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(G19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(H19,1)))),NOT(ISERROR(FIND(\"T\",LEFT(I19,1))))),AM9,\"\")","v":""},null,10,{"$f":"IF(I11=\"Yes\",CompressionService!B2,AU12)","v":15},null,null,null,null,null,null,null,"Therm Charge - Block 5",null,null,null,null,null,null,null,null,null,null,null,3.3340000000000002E-2,2.7949999999999999E-2,null,null,53,null,null,null,null,null,"Temporary Services or Structures (Please see Project Manager and enter No. of years at the cell H9 .)",{"$f":"H9","v":10}]
[null,null,null,"Attribute H","NEW FACILITY EXTENSION OR FACILITY MODIFICATION FOR COMMUNITY AESTHETICS OR IN THE INTEREST OF PUBLIC SAFETY AND DOES NOT DIRECTLY BENEFIT PARTICULAR PSE CUSTOMERS? (Yes or No)\nPlease refer to RSI No. G-R28 and contact Rates Department.  Special IRS rulings may be applicable. ",null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AI$42","v":91},null,null,null,null,null,2.7469999999999998E-2,2.2079999999999999E-2,null,null,61]
[null,{"$f":"IF(OR(SUM(Therms!B64:H64)>0,SUM(ConstructionCosts!C41:I44)>0),\"RULE 7 REVIEW\",\"\")","v":""},null,"Attribute I","NATURAL GAS COMPRESSION FACILITIES? (Yes or No)",null,null,null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effective 11/1/2011 Schedule 101 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"85T",null,null,null,null,null,{"$f":"E9","v":"EXPECTED YEARS OF REVENUE: (Years)"},{"$f":"IF(C$23>=1,IF(NOT(ISNA(MATCH(C$19,$AM$4:$AM$9,FALSE))),OFFSET($AN$3,MATCH(C$19,$AM$4:$AM$9,FALSE),0),0))","v":10},{"$f":"IF(D$23>=1,IF(NOT(ISNA(MATCH(D$19,$AM$4:$AM$9,FALSE))),OFFSET($AN$3,MATCH(D$19,$AM$4:$AM$9,FALSE),0),0))","v":false},false,false,false,false,false,{"$f":"MIN(IF(AN12:AT12>0,AN12:AT12))","v":10}]
[null,null,null,null,null,null,null,"TARGET ROR",{"$f":"$G$167","v":7.7700000000000005E-2},null,null,null,null,null,null,null,"GAS COSTS",0.67837999999999998,0.67193000000000003,6.9999999999999999E-4,0.57726,{"$f":"$T$13","v":6.9999999999999999E-4},4.0064099999999998,{"$f":"X4","v":"ADDITIONAL REVENUE"},0.61334999999999995,{"$f":"$T$13","v":6.9999999999999999E-4},0.61817,{"$f":"$T$13","v":6.9999999999999999E-4},0.58521999999999996,{"$f":"$T$13","v":6.9999999999999999E-4},null,null,86,null,null,null,null,null,null,{"$f":"C19","v":0},{"$f":"D19","v":0},0,0,0,0,0]
[null,null,"enter customer name",null,null,"REP:","enter employee name",null,null,null,null,null,null,null,null,null,"Effective 6/22/2012 Schedule 7 Section 6: Operation and Maintenance Expense ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"86T",null,null,null,null,null,null,{"$f":"C21","v":1},{"$f":"D21","v":2},3,4,5,6,7]
[null,"SERVICE ADDRESS:","enter street address",null,null,"ORDER NO:","enter SAP order no.",null,null,null,null,null,null,null,null,null,"CUSTOMER COST",67,196,1974,754,2693,{"$f":"R15","v":67},{"$f":"X4","v":"ADDITIONAL REVENUE"},7799,{"$f":"$Y$15","v":7799},621,1974,{"$f":"$Y$15","v":7799},{"$f":"$Y$15","v":7799},null,null,87]
[null,null,"enter city, state and zip",null,null,"NAICS CODE:","enter NAICS code",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"87T"]
[null,"PROJECT DESCRIPTION:","enter project description",null,null,null,null,null,null,null,null,null,null,null,null,null,"REVCST1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T",null,null,"Gas First Response Trip Charge Calculation - 2012"]
[null,"CUSTOMER GROUP STRUCTURE TYPE:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R22)/R22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S22)/S22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T22)/T22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U22>5000,(U22-5000)*$U$6+4500*$U$5,IF(U22>500,(U22-500)*$U$5,0))+500*$U$5+$U$4+U22*U$13)/U22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V22>5000,(V22-5000)*V$6+4500*V$5,IF(V22>500,(V22-500)*V$5,0))+500*V$5+V$4+V22*V$13)/V22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W22)/W22)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y22>50000,(Y22-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y22>25000,(Y22-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y22*(Y$5+Y$13)))+Y$4)/Y22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z22>50000,(Z22-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z22>25000,(Z22-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z22*(Z$5+Z$13)))+Z$4)/Z22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA22>1000,(AA22-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA22*(AA$5+AA$13))+AA$4)/AA22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB22>1000,(AB22-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB22*(AB$5+$AB$13))+$AB$4)/AB22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC22>500000,(AC22-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC22>200000,(AC22-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC22>100000,(AC22-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC22>50000,(AC22-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC22>25000,(AC22-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC22*(AC$5+$AC$13)+AC$4)))))/AC22)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD22>500000,(AD22-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD22>200000,(AD22-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD22>100000,(AD22-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD22>50000,(AD22-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD22>25000,(AD22-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD22*(AD$5+AD$13)+AD$4)))))/AD22)","v":{"$error":"#DIV/0!"}},null,null,"(Does not include CC Assessments unless identified below)"]
[null,"CUSTOMER GROUP DESCRIPTION:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4,null,null,null,null,"CFS Technician"]
[null,"CUSTOMER GROUP ID.:",1,2,3,4,5,6,7,"TOTAL",null,null,null,null,null,null,"COST/YR.",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799,null,null,null,null,"Straight Time","Time and a Half","Double Time"]
[null,"RATE SCHEDULE:",null,null,null,null,null,null,null,null,"Input from CompressService Tab",null,null,null,null,null,"AVG. THERMS/MONTH",{"$f":"$C24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$C24/12","v":0},0,0,0,0,0,null,null,"Hourly Pay",null,32.39,48.585000000000001,64.78]
[null,"NO. OF CUSTOMER/S",1,0,0,0,0,0,0,{"$f":"SUM(C23:I23)","v":1},"Input from CompressService Tab"]
[null,"THERMS/CUST/YR.:",{"$f":"IF(OR(I11=\"Yes\",AND($I$7=\"Yes\",C$23>0)),0,IF(AND(C$23>0,$I$8=\"Yes\"),1,Therms!B$59))","v":0},{"$f":"IF(OR(J11=\"Yes\",AND($I$7=\"Yes\",D$23>0)),0,IF(AND(D$23>0,$I$8=\"Yes\"),1,Therms!C$59))","v":0},{"$f":"IF(OR(K11=\"Yes\",AND($I$7=\"Yes\",E$23>0)),0,IF(AND(E$23>0,$I$8=\"Yes\"),1,Therms!D$59))","v":0},{"$f":"IF(OR(L11=\"Yes\",AND($I$7=\"Yes\",F$23>0)),0,IF(AND(F$23>0,$I$8=\"Yes\"),1,Therms!E$59))","v":0},{"$f":"IF(OR(M11=\"Yes\",AND($I$7=\"Yes\",G$23>0)),0,IF(AND(G$23>0,$I$8=\"Yes\"),1,Therms!F$59))","v":0},{"$f":"IF(OR(N11=\"Yes\",AND($I$7=\"Yes\",H$23>0)),0,IF(AND(H$23>0,$I$8=\"Yes\"),1,Therms!G$59))","v":0},{"$f":"IF(OR(O11=\"Yes\",AND($I$7=\"Yes\",I$23>0)),0,IF(AND(I$23>0,$I$8=\"Yes\"),1,Therms!H$59))","v":0},{"$f":"SUM(C23*C24,D23*D24,E23*E24,F23*F24,G23*G24,H23*H24,I23*I24)","v":0},"Input from CompressService Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Labor Overheads"]
[null,"INSTALLATION YEAR (1=NOW):",1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Employee Benefits (33.00%)",0.33,10.688700000000001,16.033049999999999,21.377400000000002]
[null,"MAIN COST:",{"$f":"IF(OR(I11=\"Yes\",C23>0),ConstructionCosts!C31,0)","v":0},{"$f":"IF(OR(J11=\"Yes\",D23>0),ConstructionCosts!D31,0)","v":0},{"$f":"IF(OR(K11=\"Yes\",E23>0),ConstructionCosts!E31,0)","v":0},{"$f":"IF(OR(L11=\"Yes\",F23>0),ConstructionCosts!F31,0)","v":0},{"$f":"IF(OR(M11=\"Yes\",G23>0),ConstructionCosts!G31,0)","v":0},{"$f":"IF(OR(N11=\"Yes\",H23>0),ConstructionCosts!H31,0)","v":0},{"$f":"IF(OR(O11=\"Yes\",I23>0),ConstructionCosts!I31,0)","v":0},{"$f":"IF(OR(P11=\"Yes\",J23>0),ConstructionCosts!J31,0)","v":0},null,null,null,null,null,null,"REVCST2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Payroll Taxes (9.70%)",9.7000000000000003E-2,3.1418300000000001,4.712745,6.2836600000000002]
[null,"SERVICE COST/CUST:",{"$f":"IF(OR(I11=\"Yes\",C23>0),ConstructionCosts!C32,0)","v":0},{"$f":"IF(OR(J11=\"Yes\",D23>0),ConstructionCosts!D32,0)","v":0},{"$f":"IF(OR(K11=\"Yes\",E23>0),ConstructionCosts!E32,0)","v":0},{"$f":"IF(OR(L11=\"Yes\",F23>0),ConstructionCosts!F32,0)","v":0},{"$f":"IF(OR(M11=\"Yes\",G23>0),ConstructionCosts!G32,0)","v":0},{"$f":"IF(OR(N11=\"Yes\",H23>0),ConstructionCosts!H32,0)","v":0},{"$f":"IF(OR(O11=\"Yes\",I23>0),ConstructionCosts!I32,0)","v":0},{"$f":"C27*C$23+D27*D$23+E27*E$23+F27*F$23+G27*G$23+H27*H$23+I27*I$23","v":0},null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T",null,null,"  PTO/Holidays (15.30%)",0.153,4.9556699999999996,7.4335050000000003,9.9113399999999992]
[null,"MSA COST/CUST:",{"$f":"IF(OR(I11=\"Yes\",C23>0),ConstructionCosts!C33,0)","v":0},{"$f":"IF(OR(J11=\"Yes\",D23>0),ConstructionCosts!D33,0)","v":0},{"$f":"IF(OR(K11=\"Yes\",E23>0),ConstructionCosts!E33,0)","v":0},{"$f":"IF(OR(L11=\"Yes\",F23>0),ConstructionCosts!F33,0)","v":0},{"$f":"IF(OR(M11=\"Yes\",G23>0),ConstructionCosts!G33,0)","v":0},{"$f":"IF(OR(N11=\"Yes\",H23>0),ConstructionCosts!H33,0)","v":0},{"$f":"IF(OR(O11=\"Yes\",I23>0),ConstructionCosts!I33,0)","v":0},{"$f":"C28*C$23+D28*D$23+E28*E$23+F28*F$23+G28*G$23+H28*H$23+I28*I$23","v":0},null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R31)/R31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S31)/S31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T31)/T31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U31>5000,(U31-5000)*$U$6+4500*$U$5,IF(U31>500,(U31-500)*$U$5,0))+500*$U$5+$U$4+U31*U$13)/U31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V31>5000,(V31-5000)*V$6+4500*V$5,IF(V31>500,(V31-500)*V$5,0))+500*V$5+V$4+V31*V$13)/V31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W31)/W31)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y31>50000,(Y31-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y31>25000,(Y31-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y31*(Y$5+Y$13)))+Y$4)/Y31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z31>50000,(Z31-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z31>25000,(Z31-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z31*(Z$5+Z$13)))+Z$4)/Z31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA31>1000,(AA31-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA31*(AA$5+AA$13))+AA$4)/AA31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB31>1000,(AB31-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB31*(AB$5+$AB$13))+$AB$4)/AB31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC31>500000,(AC31-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC31>200000,(AC31-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC31>100000,(AC31-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC31>50000,(AC31-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC31>25000,(AC31-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC31*(AC$5+$AC$13)+AC$4)))))/AC31)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD31>500000,(AD31-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD31>200000,(AD31-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD31>100000,(AD31-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD31>50000,(AD31-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD31>25000,(AD31-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD31*(AD$5+AD$13)+AD$4)))))/AD31)","v":{"$error":"#DIV/0!"}},null,null,"  Incentive Pay (9.20%)",9.1999999999999998E-2,2.9798800000000001,4.4698200000000003,5.9597600000000002]
[null,"OTHER PLANT:",{"$f":"IF(OR(I11=\"Yes\",C23>0),ConstructionCosts!C34,0)","v":0},{"$f":"IF(OR(J11=\"Yes\",D23>0),ConstructionCosts!D34,0)","v":0},{"$f":"IF(OR(K11=\"Yes\",E23>0),ConstructionCosts!E34,0)","v":0},{"$f":"IF(OR(L11=\"Yes\",F23>0),ConstructionCosts!F34,0)","v":0},{"$f":"IF(OR(M11=\"Yes\",G23>0),ConstructionCosts!G34,0)","v":0},{"$f":"IF(OR(N11=\"Yes\",H23>0),ConstructionCosts!H34,0)","v":0},{"$f":"IF(OR(O11=\"Yes\",I23>0),ConstructionCosts!I34,0)","v":0},{"$f":"SUM(C29:I29)","v":0},"Input from CompressService Tab",null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4,null,null,"   Total Labor OH",null,21.766080000000002,32.649120000000003,43.532160000000005]
[null,"PROPANE CONVERSION COST:",{"$f":"IF(AND(C23>0,C22=53),C23*$X$10,0)","v":0},0,0,0,0,0,0,{"$f":"SUM(C30:I30)","v":0},"Not Applicable",null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799]
[null,"   TOTAL INVESTMENT:",{"$f":"C26+(C23*C27)+(C28*C23)+C29+C30","v":0},0,0,0,0,0,0,{"$f":"SUM(C31:I31)","v":0},null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$D24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$D24/12","v":0},0,0,0,0,0,null,null,"Total Labor & OH",null,54.156080000000003,81.234120000000004,108.31216000000001]
[null,"ADDITIONAL REVENUE:",0,0,0,0,0,0,0,{"$f":"SUM(C32:I32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Misc. Charges"]
[null,"   REVENUE PER THERM:",{"$f":"IF(C$23<=0,\"\",IF(OR($I$11=\"Yes\",$I$7=\"Yes\"),0,IF(NOT(ISBLANK(C$22)),OFFSET($Q$17,MATCH(\"REVCST\"&TEXT(C21,\"#\"),$Q$17:$Q$72,FALSE)+1,MATCH(C22,$R$3:$AD$3,FALSE)),\"\")))","v":0},"","","","","","",null,null,null,null,null,null,null,"REVCST3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Vehicles",null,5.09,5.09,5.09]
[null,"   ANNUAL COST/CUST:",{"$f":"IF(C$23<=0,\"\",IF(OR($I$11=\"Yes\",$I$7=\"Yes\"),0,IF(NOT(ISBLANK(C$22)),OFFSET($Q$17,MATCH(\"REVCST\"&TEXT(C21,\"#\"),$Q$17:$Q$72,FALSE)+3,MATCH(C22,$R$3:$AD$3,FALSE)),\"\")))","v":0},"","","","","","",null,null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T",null,null,"  Cell Phones/ Pagers",null,0.71268929027549721,0.71268929027549721,0.71268929027549721]
[null,"   COST OF GAS/THERM:",{"$f":"IF(C$23<=0,\"\",IF(OR($I$7=\"Yes\",$I$11=\"Yes\"),0,IF(NOT(ISBLANK(C$22)),OFFSET($Q$17,MATCH(\"REVCST\"&TEXT(C21,\"#\"),$Q$17:$Q$72,FALSE)+2,MATCH(C22,$R$3:$AD$3,FALSE)),\"\")))","v":0},"","","","","","",null,null,{"$f":"ISERROR(F41)","v":false},null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R39)/R39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S39)/S39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T39)/T39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U39>5000,(U39-5000)*$U$6+4500*$U$5,IF(U39>500,(U39-500)*$U$5,0))+500*$U$5+$U$4+U39*U$13)/U39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V39>5000,(V39-5000)*V$6+4500*V$5,IF(V39>500,(V39-500)*V$5,0))+500*V$5+V$4+V39*V$13)/V39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W39)/W39)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y39>50000,(Y39-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y39>25000,(Y39-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y39*(Y$5+Y$13)))+Y$4)/Y39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z39>50000,(Z39-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z39>25000,(Z39-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z39*(Z$5+Z$13)))+Z$4)/Z39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA39>1000,(AA39-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA39*(AA$5+AA$13))+AA$4)/AA39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB39>1000,(AB39-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB39*(AB$5+$AB$13))+$AB$4)/AB39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC39>500000,(AC39-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC39>200000,(AC39-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC39>100000,(AC39-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC39>50000,(AC39-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC39>25000,(AC39-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC39*(AC$5+$AC$13)+AC$4)))))/AC39)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD39>500000,(AD39-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD39>200000,(AD39-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD39>100000,(AD39-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD39>50000,(AD39-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD39>25000,(AD39-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD39*(AD$5+AD$13)+AD$4)))))/AD39)","v":{"$error":"#DIV/0!"}},null,null,"  Uniforms",null,0.59523809523809523,0.59523809523809523,0.59523809523809523]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4,null,null,"  Stores OH",0.09,0.30106168831168834,0.30106168831168834,0.30106168831168834]
[null,"   INCREMENTAL ANNUAL REVENUE (AT MATURITY): ",null,null,null,{"$f":"MAX(G272:AT272)","v":542191.88652482256},null,null,null,null,null,null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799,null,null,"Total Misc. Charges",null,6.6989890738252802,6.6989890738252802,6.6989890738252802]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$E24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$E24/12","v":0},0,0,0,0,0]
[null,"FIA CALCULATION RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Costs",null,60.855069073825284,87.933109073825278,115.01114907382528]
[null,"   PROJECT RATE OF RETURN",null,null,null,{"$f":"D227","v":7.7680234669242454E-2},null,{"$f":"IF(ISBLANK(ConstructionCosts!C21),\"\",\"Notes about OTHER PLANT COSTS\")","v":""}]
[null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"   PROJECT RATE OF RETURN LESS THAN REQUIRED ROR OF \"&TEXT($I$13,\"##.00%\")&\", CUSTOMER ADVANCE\",\"   TARGET RATE OF RETURN MET, NO CONTRIBUTION REQUIRED\"),\"\")","v":"   PROJECT RATE OF RETURN LESS THAN REQUIRED ROR OF 7.77%, CUSTOMER ADVANCE"},null,null,null,null,null,{"$f":"IF(ISERROR(F41),\"Please check all FIA input\",IF(ISBLANK(ConstructionCosts!C21),\"\",ConstructionCosts!C21))","v":""},null,null,null,null,null,null,null,null,"REVCST4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Propane Appliance Conversion Cost:",null,{"$f":"ROUND(AI40*1.5,0)","v":91}]
[null,{"$f":"IF(J23>0,IF(I3=\"Yes\",\"AND LATECOMERS ARE REQUIRED TO PAY APPLICABLE NEW CUSTOMER RATE IF PAYMENT IS REQUIRED FROM THE ORIGNIAL FACILITIES EXTENSION FOR AT LEAST THE REMAINDER OF THE EXISTING FACILITIES EXTENSION PERIOD \",IF(AND(I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13*0.9999),\"   OR SCHEDULE 107 NEW CUSTOMER RATE \"&IF($F$49>0,\"AND QUALIFYING PAYMENT\",\"\")&\" REQUIRED \",\"\")),\"\")","v":"   OR SCHEDULE 107 NEW CUSTOMER RATE  REQUIRED "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T",null,null,"1 1/2 hours of labor cost that would be required to convert the average propane customer's propane burning furnace to a natural gas burning furnace when gas arrives via a main extension."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R47)/R47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S47)/S47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T47)/T47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U47>5000,(U47-5000)*$U$6+4500*$U$5,IF(U47>500,(U47-500)*$U$5,0))+500*$U$5+$U$4+U47*U$13)/U47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V47>5000,(V47-5000)*V$6+4500*V$5,IF(V47>500,(V47-500)*V$5,0))+500*V$5+V$4+V47*V$13)/V47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W47)/W47)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y47>50000,(Y47-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y47>25000,(Y47-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y47*(Y$5+Y$13)))+Y$4)/Y47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z47>50000,(Z47-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z47>25000,(Z47-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z47*(Z$5+Z$13)))+Z$4)/Z47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA47>1000,(AA47-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA47*(AA$5+AA$13))+AA$4)/AA47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB47>1000,(AB47-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB47*(AB$5+$AB$13))+$AB$4)/AB47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC47>500000,(AC47-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC47>200000,(AC47-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC47>100000,(AC47-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC47>50000,(AC47-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC47>25000,(AC47-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC47*(AC$5+$AC$13)+AC$4)))))/AC47)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD47>500000,(AD47-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD47>200000,(AD47-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD47>100000,(AD47-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD47>50000,(AD47-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD47>25000,(AD47-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD47*(AD$5+AD$13)+AD$4)))))/AD47)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13*0.9999),\"OPTION NO. 1 - \"&IF($F$49>0,\"Qualifying Payment (QP) plus \",\"\")&\"New Customer Rate (NCR)\",\"\"),\"\")","v":"OPTION NO. 1 - New Customer Rate (NCR)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4]
[null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13*0.75),\"   ROR LESS THAN THRESHOLD ROR OF \"&TEXT($I$13*0.75,\"##.00%\")&\"; QUALIFICATION PAYMENT REQUIRED\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799]
[null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13),\"   SCH 107 NEW CUSTOMER RATE\",\"\"),\"\")","v":"   SCH 107 NEW CUSTOMER RATE"},null,null,null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",$F$41>=$I$13*0.8,$F$41<$I$13,I7<>\"Yes\",I6<>\"Yes\",I8<>\"Yes\"),\"$0.115\",IF(AND(I3<>\"Yes\",I7<>\"Yes\",I6<>\"Yes\",I8<>\"Yes\",$F$41<$I$13),\"$0.170\",\"\")),\"\")","v":"$0.115"},{"$f":"IF(AND(I3<>\"Yes\",F47>0),\"PER THERM\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$F24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$F24/12","v":0},0,0,0,0,0]
[]
[null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13*0.75),\"   TOTAL REQUIRED PROJECT SCH 107 QUALIFICATION PAYMENT IS\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I6<>\"Yes\",I8<>\"Yes\",$F$41<$I$13*0.75),$D$245,\"\"),\"\")","v":""}]
[null,{"$f":"IF(J23>0,IF(AND(I3<>\"Yes\",I7<>\"Yes\",I8<>\"Yes\",I6<>\"Yes\",$F$41<$I$13*0.75),\"   REQUIRED  QUALIFICATION PAYMENT PER CUSTOMER IS\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(AND($F$49>0,I3<>\"Yes\"),$F$49/(SUM($C$23:$I$23)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"REVCST5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T"]
[null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"OPTION NO. 2 - Customer Advance (CA)\",\"\"),\"\")","v":"OPTION NO. 2 - Customer Advance (CA)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R55)/R55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S55)/S55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T55)/T55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U55>5000,(U55-5000)*$U$6+4500*$U$5,IF(U55>500,(U55-500)*$U$5,0))+500*$U$5+$U$4+U55*U$13)/U55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V55>5000,(V55-5000)*V$6+4500*V$5,IF(V55>500,(V55-500)*V$5,0))+500*V$5+V$4+V55*V$13)/V55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W55)/W55)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y55>50000,(Y55-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y55>25000,(Y55-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y55*(Y$5+Y$13)))+Y$4)/Y55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z55>50000,(Z55-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z55>25000,(Z55-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z55*(Z$5+Z$13)))+Z$4)/Z55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA55>1000,(AA55-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA55*(AA$5+AA$13))+AA$4)/AA55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB55>1000,(AB55-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB55*(AB$5+$AB$13))+$AB$4)/AB55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC55>500000,(AC55-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC55>200000,(AC55-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC55>100000,(AC55-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC55>50000,(AC55-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC55>25000,(AC55-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC55*(AC$5+$AC$13)+AC$4)))))/AC55)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD55>500000,(AD55-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD55>200000,(AD55-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD55>100000,(AD55-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD55>50000,(AD55-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD55>25000,(AD55-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD55*(AD$5+AD$13)+AD$4)))))/AD55)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"   TOTAL CUSTOMER ADVANCE (INCLUDING FIT) FOR PROJECT IS\",\"\"),\"\")","v":"   TOTAL CUSTOMER ADVANCE (INCLUDING FIT) FOR PROJECT IS"},null,null,null,{"$f":"IF($D$244>0,IF($I$10=\"Yes\",$D$243,$D$244),\"\")","v":497.40532652045096},null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"TOTAL FIT COMPONENT IS\",\"\"),\"\")","v":"TOTAL FIT COMPONENT IS"},null,{"$f":"IF(AND($F$53>0,$I$10=\"Yes\"),0,IF($D$244>0,D244-D244/(1+$D$215),\"\"))","v":89.294622122312603},null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4]
[null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"   CUSTOMER ADVANCE (INCLUDING FIT) PER CUSTOMER IS\",\"\"),\"\")","v":"   CUSTOMER ADVANCE (INCLUDING FIT) PER CUSTOMER IS"},null,null,null,{"$f":"IF($D$244>0,$F$53/(SUM($C$23:$I$23)),\"\")","v":497.40532652045096},null,{"$f":"IF(J23>0,IF($F$41<$I$13*0.9999,\"FIT COMPONENT PER CUSTOMER IS\",\"\"),\"\")","v":"FIT COMPONENT PER CUSTOMER IS"},null,{"$f":"IF($D$244>0,$J$53/(SUM($C$23:$I$23)),\"\")","v":89.294622122312603},null,null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799]
[null,{"$f":"IF(AND(I3=\"Yes\"),\"   LATECOMER SCHEDULE 107 NEW CUSTOMER RATE……………………...…………...……………..…………..…...…..………………………………………...…\",\"\")","v":""},null,null,null,{"$f":"IF(I3=\"Yes\",\"IF RATE OF RETURN OF ORIGINAL EXTENSION IS AT OR ABOVE \"&TEXT($I$13*0.8,\"0.00%\")&\" $0.115/PER THERM, ELSE $0.170/PER THERM\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$G24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$G24/12","v":0},0,0,0,0,0]
[null,{"$f":"IF($I$4=\"Yes\",\"SECURITY DEPOSIT\",\"\")","v":""}]
[null,{"$f":"IF($I$4=\"Yes\",\"   THE DEVELOPER IS REQUIRED TO PAY A SECURITY DEPOSIT\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($I$4=\"Yes\",\"TOTAL BALANCE DUE FOR THE DEVELOPER\",\"\")","v":""}]
[null,{"$f":"IF($I$4=\"Yes\",\"   EQUIVALENT TO THE ECONOMIC VALUE OF A POTENTIAL\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF($I$4=\"Yes\",\"OPTION 1 w/ SECURITY DEPOSIT:\",\"\")","v":""},{"$f":"IF($I$4=\"Yes\",ROUND(F49,0)+ROUND(F59,0),\"\")","v":""},null,null,null,null,null,null,"REVCST6"]
[null,{"$f":"IF($I$4=\"Yes\",\"   TWO (2) YEAR DELAY IN THE ORIGINAL BUILD-OUT PLAN....................................................................................................\",\"\")","v":""},null,null,null,{"$f":"IF($I$4=\"Yes\",$D$251,\"\")","v":""},null,null,{"$f":"IF($I$4=\"Yes\",\"OPTION 2 w/ SECURITY DEPOSIT:\",\"\")","v":""},{"$f":"IF($I$4=\"Yes\",ROUND(F53,0)+ROUND(F59,0),\"\")","v":""},null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R63)/R63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S63)/S63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T63)/T63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U63>5000,(U63-5000)*$U$6+4500*$U$5,IF(U63>500,(U63-500)*$U$5,0))+500*$U$5+$U$4+U63*U$13)/U63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V63>5000,(V63-5000)*V$6+4500*V$5,IF(V63>500,(V63-500)*V$5,0))+500*V$5+V$4+V63*V$13)/V63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W63)/W63)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y63>50000,(Y63-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y63>25000,(Y63-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y63*(Y$5+Y$13)))+Y$4)/Y63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z63>50000,(Z63-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z63>25000,(Z63-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z63*(Z$5+Z$13)))+Z$4)/Z63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA63>1000,(AA63-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA63*(AA$5+AA$13))+AA$4)/AA63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB63>1000,(AB63-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB63*(AB$5+$AB$13))+$AB$4)/AB63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC63>500000,(AC63-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC63>200000,(AC63-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC63>100000,(AC63-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC63>50000,(AC63-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC63>25000,(AC63-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC63*(AC$5+$AC$13)+AC$4)))))/AC63)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD63>500000,(AD63-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD63>200000,(AD63-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD63>100000,(AD63-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD63>50000,(AD63-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD63>25000,(AD63-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD63*(AD$5+AD$13)+AD$4)))))/AD63)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$H24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$H24/12","v":0},0,0,0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REVCST7"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RATE",{"$f":"R$3","v":23},31,"31T",41,"41T",53,61,85,"85T",86,"86T",87,"87T"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REV/TH",{"$f":"IF($I$6=\"Yes\",(R$5+$R$13),(R$4+(R$5+$R$13)*R71)/R71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(S$5+$S$13),(S$4+(S$5+$S$13)*S71)/S71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(T$5+$T$13),(T$4+(T$5+$T$13)*T71)/T71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(U$13+$U$6),(IF(U71>5000,(U71-5000)*$U$6+4500*$U$5,IF(U71>500,(U71-500)*$U$5,0))+500*$U$5+$U$4+U71*U$13)/U71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(V$13+V$6),(IF(V71>5000,(V71-5000)*V$6+4500*V$5,IF(V71>500,(V71-500)*V$5,0))+500*V$5+V$4+V71*V$13)/V71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(W$5+W$13),(W$4+(W$5+W$13)*W71)/W71)","v":{"$error":"#DIV/0!"}},{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",(Y$13+Y$7),(IF(Y71>50000,(Y71-50000)*(Y$7+Y$13)+25000*(Y$6+Y$13)+25000*(Y$5+Y$13),IF(Y71>25000,(Y71-25000)*(Y$6+Y$13)+25000*(Y$5+Y$13),Y71*(Y$5+Y$13)))+Y$4)/Y71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(Z$13+Z$7),(IF(Z71>50000,(Z71-50000)*(Z$7+Z$13)+25000*(Z$6+Z$13)+25000*(Z$5+Z$13),IF(Z71>25000,(Z71-25000)*(Z$6+Z$13)+25000*(Z$5+Z$13),Z71*(Z$5+Z$13)))+Z$4)/Z71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AA$6+AA$13),(IF(AA71>1000,(AA71-1000)*(AA$6+AA$13)+1000*(AA$5+AA$13),AA71*(AA$5+AA$13))+AA$4)/AA71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AB$6+$AB$13),(IF(AB71>1000,(AB71-1000)*(AB$6+$AB$13)+1000*(AB$5+$AB$13),AB71*(AB$5+$AB$13))+$AB$4)/AB71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AC$10+$AC$13),IF(AC71>500000,(AC71-500000)*(AC$10+$AC$13)+300000*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC71>200000,(AC71-200000)*(AC$9+$AC$13)+100000*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC71>100000,(AC71-100000)*(AC$8+$AC$13)+50000*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC71>50000,(AC71-50000)*(AC$7+$AC$13)+25000*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,IF(AC71>25000,(AC71-25000)*(AC$6+$AC$13)+25000*(AC$5+$AC$13)+AC$4,AC71*(AC$5+$AC$13)+AC$4)))))/AC71)","v":{"$error":"#DIV/0!"}},{"$f":"IF($I$6=\"Yes\",(AD$10+AD$13),IF(AD71>500000,(AD71-500000)*(AD$10+AD$13)+300000*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD71>200000,(AD71-200000)*(AD$9+AD$13)+100000*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD71>100000,(AD71-100000)*(AD$8+AD$13)+50000*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD71>50000,(AD71-50000)*(AD$7+AD$13)+25000*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,IF(AD71>25000,(AD71-25000)*(AD$6+AD$13)+25000*(AD$5+AD$13)+AD$4,AD71*(AD$5+AD$13)+AD$4)))))/AD71)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS/TH",{"$f":"R$13","v":0.67837999999999998},0.67193000000000003,6.9999999999999999E-4,0.57726,6.9999999999999999E-4,4.0064099999999998,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"Y$13","v":0.61334999999999995},6.9999999999999999E-4,0.61817,6.9999999999999999E-4,0.58521999999999996,6.9999999999999999E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COST/YR",{"$f":"IF($I$6=\"Yes\",0,+R$15)","v":67},196,1974,754,2693,67,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"IF($I$6=\"Yes\",0,+Y$15)","v":7799},7799,621,1974,7799,7799]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVG THERMS/MONTH",{"$f":"$I24/12","v":0},0,0,0,0,0,{"$f":"X$4","v":"ADDITIONAL REVENUE"},{"$f":"$I24/12","v":0},0,0,0,0,0]
[null,"REVIEW OF CONTRIBUTIONS AND REFUND",null,null,null,null,null,null,{"$f":"\"REVIEW DATE: \"&TEXT(NOW(),\"MM/DD/YYYY\")","v":"REVIEW DATE: 07/21/2014"}]
[null,{"$f":"H1","v":"Version: P_FIA_CNG_v1_P_12-21-2012.xlsm"}]
[]
[null,"TOTAL ORIGINAL CA PAID:",{"$f":"C107","v":0}]
[]
[null,"STEP 6.B1: INPUT PAID ORIGINAL CA ATTRIBUTES",null,null,"STEP 6.B2: INPUT REVIEW YEAR AND LATECOMER ATTRIBUTES",null,null,null,null,"LATECOMER NCR REVENUES CALCULATION"]
[null,"CA\nCUSTOMER NAME","ORIGINAL\nADVANCE\nPAID\nBY CUSTOMER","REFUND DUE","REVIEW YEAR","LATECOMER\nCUSTOMER NAME","INSTALLATION YEAR OF LATECOMER","NCR\n$0.115 or $0.170","ESTIMATED ANNUAL USAGE","ORIGINAL EXTENSION REVIEW PERIOD "]
[null,null,null,"(WITHOUT\n INTEREST)","1 = Installation Year of Original Extension",null,null,null,null,1,2,3,4,5]
[null,null,null,{"$f":"\"Ratio used:  \n\"&IF(C$107>0,FIXED(((C$75-F$53)/C$75)*100,4,TRUE),\"0.0000\")&\"%\"","v":"Ratio used:  \n0.0000%"},1,null,null,null,null,"1-Month\nTo\n12-Month","13-Month\nTo\n24-Month","25-Month\nTo\n36-Month","37-Month\nTo\n48-Month","49-Month\nTo\n60-Month"]
[1,null,0,{"$f":"IF(AND(C$107>0,F$53>0),(C$75-F$53)/C$75*C81,IF(AND(AND(F$53=0,C81>0),C$75>0),\"Full Refund!\",0))","v":0},1,null,0,0,0,{"$f":"IF(OR(ISBLANK($F81),ISBLANK($G81),ISBLANK($H81),ISBLANK($I81)),\"Please enter all entries.\",MAX($H81*$I81*IF(J$79<=$E$80,IF($G81>J$79,0,IF($G81=J$79,1,MIN(J$79-$G81,1))),IF($G81>J$79,0,IF(AND($E$80>(J$79-1),$E$80<(J$79+1),$G81>J$79-1),ABS(J$79-1-MIN($E$80,MAX($G81,J$79-1))),1+($E$80-J$79)))),0))","v":"Please enter all entries."},"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[2,null,0,{"$f":"IF(AND(C$107>0,F$53>0),(C$75-F$53)/C$75*C82,IF(AND(AND(F$53=0,C82>0),C$75>0),\"Full Refund!\",0))","v":0},2,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[3,null,0,0,3,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[4,null,0,0,4,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[5,null,0,0,5,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[6,null,0,0,6,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[7,null,0,0,7,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[8,null,0,0,8,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[9,null,0,0,9,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[10,null,0,0,10,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[11,null,0,0,11,null,0,0,0,{"$f":"IF(OR(ISBLANK($F91),ISBLANK($G91),ISBLANK($H91),ISBLANK($I91)),\"Please enter all entries.\",MAX($H91*$I91*IF(J$79<=$E$80,IF($G91>J$79,0,IF($G91=J$79,1,MIN(J$79-$G91,1))),IF($G91>J$79,0,IF(AND($E$80>(J$79-1),$E$80<(J$79+1),$G91>J$79-1),ABS(J$79-1-MIN($E$80,MAX($G91,J$79-1))),1+($E$80-J$79)))),0))","v":"Please enter all entries."},"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[12,null,0,0,12,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[13,null,0,0,13,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[14,null,0,0,14,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[15,null,0,0,15,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[16,null,0,0,16,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[17,null,0,0,17,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[18,null,0,0,18,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[19,null,0,0,19,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[20,"",0,0,20,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[21,"",0,0,21,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[22,"",0,0,22,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[23,"",0,0,23,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[24,"",0,0,24,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[25,"",0,0,25,null,0,0,0,"Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries.","Please enter all entries."]
[]
[null,"Total",{"$f":"SUM(C81:C105)","v":0},{"$f":"SUM(D81:D105)","v":0},null,null,null,null,null,{"$f":"SUM(J81:J105)","v":0},{"$f":"SUM(K81:K105)","v":0},{"$f":"SUM(L81:L105)","v":0},{"$f":"SUM(M81:M105)","v":0},{"$f":"SUM(N81:N105)","v":0}]
[]
[]
[]
[]
[null,"PUGET SOUND ENERGY"]
[null,{"$f":"C1","v":"NATURAL GAS COMPRESSION SERVICE CHARGE ANALYSIS"}]
[null,{"$f":"H1","v":"Version: P_FIA_CNG_v1_P_12-21-2012.xlsm"}]
[]
[null,"MAIN BOOK LIFE",null,33]
[null,"SERVICE BOOK LIFE",null,33]
[null,"MSA BOOK  LIFE",null,33]
[null,"OTHER",null,15]
[null,"PROGRAM YEAR",null,null,null,null,1,2,3,4,5,{"$f":"K120+1","v":6},7,8,9,10,{"$f":"P120+1","v":11},12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"AC120+1","v":24},25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,"INVESTMENT"]
[null,"MAIN",null,null,null,null,{"$f":"IF($C$25=G$120,$C$26,0)+IF($D$25=G$120,$D$26,0)+IF($E$25=G$120,$E$26,0)+IF($F$25=G$120,$F$26,0)+IF($G$25=G$120,$G$26,0)+IF($H$25=G$120,$H$26,0)+IF($I$25=G$120,$I$26,0)","v":0},{"$f":"IF($C$25=H$120,$C$26,0)+IF($D$25=H$120,$D$26,0)+IF($E$25=H$120,$E$26,0)+IF($F$25=H$120,$F$26,0)+IF($G$25=H$120,$G$26,0)+IF($H$25=H$120,$H$26,0)+IF($I$25=H$120,$I$26,0)","v":0},{"$f":"IF($C$25=I$120,$C$26,0)+IF($D$25=I$120,$D$26,0)+IF($E$25=I$120,$E$26,0)+IF($F$25=I$120,$F$26,0)+IF($G$25=I$120,$G$26,0)+IF($H$25=I$120,$H$26,0)+IF($I$25=I$120,$I$26,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SERVICE",null,null,null,null,{"$f":"IF($C$25=G$120,$C$27*$C$23,0)+IF($D$25=G$120,$D$27*$D$23,0)+IF($E$25=G$120,$E$27*$E$23,0)+IF($F$25=G$120,$F$27*$F$23,0)+IF($G$25=G$120,$G$27*$G$23,0)+IF($H$25=G$120,$H$27*$H$23,0)+IF($I$25=G$120,$I$27*$I$23,0)","v":0},{"$f":"IF($C$25=H$120,$C$27*$C$23,0)+IF($D$25=H$120,$D$27*$D$23,0)+IF($E$25=H$120,$E$27*$E$23,0)+IF($F$25=H$120,$F$27*$F$23,0)+IF($G$25=H$120,$G$27*$G$23,0)+IF($H$25=H$120,$H$27*$H$23,0)+IF($I$25=H$120,$I$27*$I$23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MSA",null,null,null,null,{"$f":"IF($C$25=G$120,$C$28*$C$23,0)+IF($D$25=G$120,$D$28*$D$23,0)+IF($E$25=G$120,$E$28*$E$23,0)+IF($F$25=G$120,$F$28*$F$23,0)+IF($G$25=G$120,$G$28*$G$23,0)+IF($H$25=G$120,$H$28*$H$23,0)+IF($I$25=G$120,$I$28*$I$23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"OTHER",null,null,null,null,{"$f":"IF($C$25=G$120,$C$29,0)+IF($D$25=G$120,$D$29,0)+IF($E$25=G$120,$E$29,0)+IF($F$25=G$120,$F$29,0)+IF($G$25=G$120,$G$29,0)+IF($H$25=G$120,$H$29,0)+IF($I$25=G$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!B5)","v":2500000},{"$f":"IF($C$25=H$120,$C$29,0)+IF($D$25=H$120,$D$29,0)+IF($E$25=H$120,$E$29,0)+IF($F$25=H$120,$F$29,0)+IF($G$25=H$120,$G$29,0)+IF($H$25=H$120,$H$29,0)+IF($I$25=H$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!C5)","v":0},{"$f":"IF($C$25=I$120,$C$29,0)+IF($D$25=I$120,$D$29,0)+IF($E$25=I$120,$E$29,0)+IF($F$25=I$120,$F$29,0)+IF($G$25=I$120,$G$29,0)+IF($H$25=I$120,$H$29,0)+IF($I$25=I$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!D5)","v":0},{"$f":"IF($C$25=J$120,$C$29,0)+IF($D$25=J$120,$D$29,0)+IF($E$25=J$120,$E$29,0)+IF($F$25=J$120,$F$29,0)+IF($G$25=J$120,$G$29,0)+IF($H$25=J$120,$H$29,0)+IF($I$25=J$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!E5)","v":0},{"$f":"IF($C$25=K$120,$C$29,0)+IF($D$25=K$120,$D$29,0)+IF($E$25=K$120,$E$29,0)+IF($F$25=K$120,$F$29,0)+IF($G$25=K$120,$G$29,0)+IF($H$25=K$120,$H$29,0)+IF($I$25=K$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!F5)","v":0},{"$f":"IF($C$25=L$120,$C$29,0)+IF($D$25=L$120,$D$29,0)+IF($E$25=L$120,$E$29,0)+IF($F$25=L$120,$F$29,0)+IF($G$25=L$120,$G$29,0)+IF($H$25=L$120,$H$29,0)+IF($I$25=L$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!G5)","v":0},{"$f":"IF($C$25=M$120,$C$29,0)+IF($D$25=M$120,$D$29,0)+IF($E$25=M$120,$E$29,0)+IF($F$25=M$120,$F$29,0)+IF($G$25=M$120,$G$29,0)+IF($H$25=M$120,$H$29,0)+IF($I$25=M$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!H5)","v":0},{"$f":"IF($C$25=N$120,$C$29,0)+IF($D$25=N$120,$D$29,0)+IF($E$25=N$120,$E$29,0)+IF($F$25=N$120,$F$29,0)+IF($G$25=N$120,$G$29,0)+IF($H$25=N$120,$H$29,0)+IF($I$25=N$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!I5)","v":0},{"$f":"IF($C$25=O$120,$C$29,0)+IF($D$25=O$120,$D$29,0)+IF($E$25=O$120,$E$29,0)+IF($F$25=O$120,$F$29,0)+IF($G$25=O$120,$G$29,0)+IF($H$25=O$120,$H$29,0)+IF($I$25=O$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!J5)","v":0},{"$f":"IF($C$25=P$120,$C$29,0)+IF($D$25=P$120,$D$29,0)+IF($E$25=P$120,$E$29,0)+IF($F$25=P$120,$F$29,0)+IF($G$25=P$120,$G$29,0)+IF($H$25=P$120,$H$29,0)+IF($I$25=P$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!K5)","v":0},{"$f":"IF($C$25=Q$120,$C$29,0)+IF($D$25=Q$120,$D$29,0)+IF($E$25=Q$120,$E$29,0)+IF($F$25=Q$120,$F$29,0)+IF($G$25=Q$120,$G$29,0)+IF($H$25=Q$120,$H$29,0)+IF($I$25=Q$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!L5)","v":0},{"$f":"IF($C$25=R$120,$C$29,0)+IF($D$25=R$120,$D$29,0)+IF($E$25=R$120,$E$29,0)+IF($F$25=R$120,$F$29,0)+IF($G$25=R$120,$G$29,0)+IF($H$25=R$120,$H$29,0)+IF($I$25=R$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!M5)","v":0},{"$f":"IF($C$25=S$120,$C$29,0)+IF($D$25=S$120,$D$29,0)+IF($E$25=S$120,$E$29,0)+IF($F$25=S$120,$F$29,0)+IF($G$25=S$120,$G$29,0)+IF($H$25=S$120,$H$29,0)+IF($I$25=S$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!N5)","v":0},{"$f":"IF($C$25=T$120,$C$29,0)+IF($D$25=T$120,$D$29,0)+IF($E$25=T$120,$E$29,0)+IF($F$25=T$120,$F$29,0)+IF($G$25=T$120,$G$29,0)+IF($H$25=T$120,$H$29,0)+IF($I$25=T$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!O5)","v":0},{"$f":"IF($C$25=U$120,$C$29,0)+IF($D$25=U$120,$D$29,0)+IF($E$25=U$120,$E$29,0)+IF($F$25=U$120,$F$29,0)+IF($G$25=U$120,$G$29,0)+IF($H$25=U$120,$H$29,0)+IF($I$25=U$120,$I$29,0)+IF($I$11=\"Yes\",CompressionService!P5)","v":0},{"$f":"IF($C$25=V$120,$C$29,0)+IF($D$25=V$120,$D$29,0)+IF($E$25=V$120,$E$29,0)+IF($F$25=V$120,$F$29,0)+IF($G$25=V$120,$G$29,0)+IF($H$25=V$120,$H$29,0)+IF($I$25=V$120,$I$29,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL INVESTMENT BY YEAR",null,null,null,null,{"$f":"SUM(G122:G125)","v":2500000},0,0,0,0,0,0,{"$f":"SUM(N122:N125)","v":0},{"$f":"SUM(O122:O125)","v":0},{"$f":"SUM(P122:P125)","v":0},{"$f":"SUM(Q122:Q125)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD122:AD125)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"\"BOOK DEPRECIATION, S/L @ LIFE OF \"&FIXED(I9,0,TRUE)&\" YEARS\"","v":"BOOK DEPRECIATION, S/L @ LIFE OF 15 YEARS"},null,null,null,null,{"$f":"G147","v":166666.66666666666},{"$f":"H147","v":166666.66666666666},166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,0,0,0,0,0,0,0,0,{"$f":"AD147","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CUMULATIVE BOOK DEPRECIATION",null,null,null,null,{"$f":"SUM(G128)","v":166666.66666666666},{"$f":"SUM($G$128:H128)","v":333333.33333333331},{"$f":"SUM($G$128:I128)","v":500000},{"$f":"SUM($G$128:J128)","v":666666.66666666663},{"$f":"SUM($G$128:K128)","v":833333.33333333326},{"$f":"SUM($G$128:L128)","v":999999.99999999988},{"$f":"SUM($G$128:M128)","v":1166666.6666666665},{"$f":"SUM($G$128:N128)","v":1333333.3333333333},{"$f":"SUM($G$128:O128)","v":1500000},{"$f":"SUM($G$128:P128)","v":1666666.6666666667},{"$f":"SUM($G$128:Q128)","v":1833333.3333333335},{"$f":"SUM($G$128:R128)","v":2000000.0000000002},{"$f":"SUM($G$128:S128)","v":2166666.666666667},{"$f":"SUM($G$128:T128)","v":2333333.3333333335},{"$f":"SUM($G$128:U128)","v":2500000},{"$f":"SUM($G$128:V128)","v":2500000},{"$f":"SUM($G$128:W128)","v":2500000},{"$f":"SUM($G$128:X128)","v":2500000},{"$f":"SUM($G$128:Y128)","v":2500000},{"$f":"SUM($G$128:Z128)","v":2500000},{"$f":"SUM($G$128:AA128)","v":2500000},{"$f":"SUM($G$128:AB128)","v":2500000},{"$f":"SUM($G$128:AC128)","v":2500000},{"$f":"SUM($G$128:AD128)","v":2500000},{"$f":"SUM($G$128:AE128)","v":2500000},{"$f":"SUM($G$128:AF128)","v":2500000},{"$f":"SUM($G$128:AG128)","v":2500000},{"$f":"SUM($G$128:AH128)","v":2500000},{"$f":"SUM($G$128:AI128)","v":2500000},{"$f":"SUM($G$128:AJ128)","v":2500000},{"$f":"SUM($G$128:AK128)","v":2500000},{"$f":"SUM($G$128:AL128)","v":2500000},{"$f":"SUM($G$128:AM128)","v":2500000},{"$f":"SUM($G$128:AN128)","v":2500000},{"$f":"SUM($G$128:AO128)","v":2500000},{"$f":"SUM($G$128:AP128)","v":2500000},{"$f":"SUM($G$128:AQ128)","v":2500000},{"$f":"SUM($G$128:AR128)","v":2500000},{"$f":"SUM($G$128:AS128)","v":2500000},{"$f":"SUM($G$128:AT128)","v":2500000}]
[null,"BOOK VALUE BEGINNING OF YEAR",null,null,null,null,{"$f":"SUM(G126)-F148","v":2500000},{"$f":"SUM($G$126:H126)-G148","v":2333333.3333333335},{"$f":"SUM($G$126:I126)-H148","v":2166666.6666666665},{"$f":"SUM($G$126:J126)-I148","v":2000000},{"$f":"SUM($G$126:K126)-J148","v":1833333.3333333335},{"$f":"SUM($G$126:L126)-K148","v":1666666.6666666667},{"$f":"SUM($G$126:M126)-L148","v":1500000},{"$f":"SUM($G$126:N126)-M148","v":1333333.3333333335},{"$f":"SUM($G$126:O126)-N148","v":1166666.6666666667},{"$f":"SUM($G$126:P126)-O148","v":1000000},{"$f":"SUM($G$126:Q126)-P148","v":833333.33333333326},{"$f":"SUM($G$126:R126)-Q148","v":666666.66666666651},{"$f":"SUM($G$126:S126)-R148","v":499999.99999999977},{"$f":"SUM($G$126:T126)-S148","v":333333.33333333302},{"$f":"SUM($G$126:U126)-T148","v":166666.66666666651},{"$f":"SUM($G$126:V126)-U148","v":0},{"$f":"SUM($G$126:W126)-V148","v":0},{"$f":"SUM($G$126:X126)-W148","v":0},{"$f":"SUM($G$126:Y126)-X148","v":0},{"$f":"SUM($G$126:Z126)-Y148","v":0},{"$f":"SUM($G$126:AA126)-Z148","v":0},{"$f":"SUM($G$126:AB126)-AA148","v":0},{"$f":"SUM($G$126:AC126)-AB148","v":0},{"$f":"SUM($G$126:AD126)-AC148","v":0},{"$f":"SUM($G$126:AE126)-AD148","v":0},{"$f":"SUM($G$126:AF126)-AE148","v":0},{"$f":"SUM($G$126:AG126)-AF148","v":0},{"$f":"SUM($G$126:AH126)-AG148","v":0},{"$f":"SUM($G$126:AI126)-AH148","v":0},{"$f":"SUM($G$126:AJ126)-AI148","v":0},{"$f":"SUM($G$126:AK126)-AJ148","v":0},{"$f":"SUM($G$126:AL126)-AK148","v":0},{"$f":"SUM($G$126:AM126)-AL148","v":0},{"$f":"SUM($G$126:AN126)-AM148","v":0},{"$f":"SUM($G$126:AO126)-AN148","v":0},{"$f":"SUM($G$126:AP126)-AO148","v":0},{"$f":"SUM($G$126:AQ126)-AP148","v":0},{"$f":"SUM($G$126:AR126)-AQ148","v":0},{"$f":"SUM($G$126:AS126)-AR148","v":0},{"$f":"SUM($G$126:AT126)-AS148","v":0}]
[]
[]
[]
[null,"MULTI-YEAR BOOK DEPRECIATION TABLE"]
[null,null,null,"INVESTMENT  YR"]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,1,null,null,{"$f":"IF(G120<=$D$116,SLN(SUM(G122),0,$D$116),0)+IF(G120<=$D$117,SLN(SUM(G123),0,$D$117),0)+IF(G120<=$D$118,SLN(SUM(G124),0,$D$118),0)+IF(G120<=D119,SLN(SUM(G125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(H120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(H120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(H120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(H120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(I120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(I120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(I120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(I120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(J120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(J120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(J120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(J120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(K120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(K120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(K120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(K120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},166666.66666666666,{"$f":"IF(M120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(M120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(M120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(M120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(N120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(N120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(N120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(N120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},{"$f":"IF(O120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(O120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(O120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(O120<=$D$119,SLN(($G$125),0,$D$119),0)","v":166666.66666666666},166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,0,0,0,0,0,0,0,0,{"$f":"IF(AD120<=$D$116,SLN(($G$122),0,$D$116),0)+IF(AD120<=$D$117,SLN(SUM($G$123),0,$D$117),0)+IF(AD120<=$D$118,SLN(($G$124),0,$D$118),0)+IF(AD120<=$D$119,SLN(($G$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,2,null,null,null,{"$f":"IF(H120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(H120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(H120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(H120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},{"$f":"IF(I120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(I120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(I120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(I120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},{"$f":"IF(J120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(J120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(J120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(J120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},0,0,{"$f":"IF(M120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(M120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(M120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(M120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},{"$f":"IF(N120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(N120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(N120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(N120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},{"$f":"IF(O120<=($D$116+1),SLN(($H$122),0,$D$116),0)+IF(O120<=($D$117+1),SLN(($H$123),0,$D$117),0)+IF(O120<=($D$118+1),SLN(($H$124),0,$D$118),0)+IF(O120<=($D$119+1),SLN(($H$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,3,null,null,null,null,{"$f":"IF(I120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(I120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(I120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(I120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},{"$f":"IF(J120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(J120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(J120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(J120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},0,0,{"$f":"IF(M120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(M120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(M120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(M120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},{"$f":"IF(N120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(N120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(N120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(N120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},{"$f":"IF(O120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(O120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(O120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(O120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD120<=($D$116+2),SLN(($I$122),0,$D$116),0)+IF(AD120<=($D$117+2),SLN(($I$123),0,$D$117),0)+IF(AD120<=($D$118+2),SLN(($I$124),0,$D$118),0)+IF(AD120<=($D$119+2),SLN(($I$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,4,null,null,null,null,null,{"$f":"IF(J120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(J120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(J120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(J120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},{"$f":"IF(K120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(K120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(K120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(K120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},{"$f":"IF(L120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(L120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(L120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(L120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},{"$f":"IF(M120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(M120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(M120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(M120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},{"$f":"IF(N120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(N120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(N120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(N120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},{"$f":"IF(O120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(O120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(O120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(O120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD120<=($D$116+3),SLN(($J$122),0,$D$116),0)+IF(AD120<=($D$117+3),SLN(($J$123),0,$D$117),0)+IF(AD120<=($D$118+3),SLN(($J$124),0,$D$118),0)+IF(AD120<=($D$119+3),SLN(($J$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,5,null,null,null,null,null,null,{"$f":"IF(K120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(K120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(K120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(K120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},{"$f":"IF(L120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(L120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(L120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(L120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},{"$f":"IF(M120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(M120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(M120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(M120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},{"$f":"IF(N120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(N120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(N120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(N120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},{"$f":"IF(O120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(O120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(O120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(O120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD120<=($D$116+4),SLN(($K$122),0,$D$116),0)+IF(AD120<=($D$117+4),SLN(($K$123),0,$D$117),0)+IF(AD120<=($D$118+4),SLN(($K$124),0,$D$118),0)+IF(AD120<=($D$119+4),SLN(($K$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,6,null,null,null,null,null,null,null,{"$f":"IF(L120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(L120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(L120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(L120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},{"$f":"IF(M120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(M120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(M120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(M120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},{"$f":"IF(N120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(N120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(N120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(N120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},{"$f":"IF(O120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(O120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(O120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(O120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},{"$f":"IF(P120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(P120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(P120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(P120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},{"$f":"IF(Q120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(Q120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(Q120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(Q120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AD120<=($D$116+5),SLN(($L$122),0,$D$116),0)+IF(AD120<=($D$117+5),SLN(($L$123),0,$D$117),0)+IF(AD120<=($D$118+5),SLN(($L$124),0,$D$118),0)+IF(AD120<=($D$119+5),SLN(($L$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,7,null,null,null,null,null,null,null,null,{"$f":"IF(M$120<=($D$116+6),SLN(($M$122),0,$D$116),0)+IF(M$120<=($D$117+6),SLN(($M$123),0,$D$117),0)+IF(M$120<=($D$118+6),SLN(($M$124),0,$D$118),0)+IF(M$120<=($D$119+6),SLN(($M$125),0,$D$119),0)","v":0},{"$f":"IF(N$120<=($D$116+6),SLN(($M$122),0,$D$116),0)+IF(N$120<=($D$117+6),SLN(($M$123),0,$D$117),0)+IF(N$120<=($D$118+6),SLN(($M$124),0,$D$118),0)+IF(N$120<=($D$119+6),SLN(($M$125),0,$D$119),0)","v":0},{"$f":"IF(O$120<=($D$116+6),SLN(($M$122),0,$D$116),0)+IF(O$120<=($D$117+6),SLN(($M$123),0,$D$117),0)+IF(O$120<=($D$118+6),SLN(($M$124),0,$D$118),0)+IF(O$120<=($D$119+6),SLN(($M$125),0,$D$119),0)","v":0},{"$f":"IF(P$120<=($D$116+6),SLN(($M$122),0,$D$116),0)+IF(P$120<=($D$117+6),SLN(($M$123),0,$D$117),0)+IF(P$120<=($D$118+6),SLN(($M$124),0,$D$118),0)+IF(P$120<=($D$119+6),SLN(($M$125),0,$D$119),0)","v":0},{"$f":"IF(Q$120<=($D$116+6),SLN(($M$122),0,$D$116),0)+IF(Q$120<=($D$117+6),SLN(($M$123),0,$D$117),0)+IF(Q$120<=($D$118+6),SLN(($M$124),0,$D$118),0)+IF(Q$120<=($D$119+6),SLN(($M$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,8,null,null,null,null,null,null,null,null,null,{"$f":"IF(N$120<=($D$116+7),SLN(($N$122),0,$D$116),0)+IF(N$120<=($D$117+7),SLN(($N$123),0,$D$117),0)+IF(N$120<=($D$118+7),SLN(($N$124),0,$D$118),0)+IF(N$120<=($D$119+7),SLN(($N$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,9,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O$120<=($D$116+8),SLN(($O$122),0,$D$116),0)+IF(O$120<=($D$117+8),SLN(($O$123),0,$D$117),0)+IF(O$120<=($D$118+8),SLN(($O$124),0,$D$118),0)+IF(O$120<=($D$119+8),SLN(($O$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,10,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P120<=($D$116+5),SLN(($P$122),0,$D$116),0)+IF(P120<=($D$117+9),SLN(($P$123),0,$D$117),0)+IF(P120<=($D$118+9),SLN(($P$124),0,$D$118),0)+IF(P120<=($D$119+9),SLN(($P$125),0,$D$119),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"TOTAL BOOK DEPRECIATION FOR YEAR",null,null,null,null,{"$f":"SUM(G136:G146)","v":166666.66666666666},166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,166666.66666666666,0,0,0,0,0,0,0,0,{"$f":"SUM(AD136:AD146)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ACCUMULATIVE DEPRECIATION",null,null,null,null,{"$f":"SUM(G147)","v":166666.66666666666},{"$f":"SUM($G$147:H147)","v":333333.33333333331},{"$f":"SUM($G$147:I147)","v":500000},{"$f":"SUM($G$147:J147)","v":666666.66666666663},{"$f":"SUM($G$147:K147)","v":833333.33333333326},{"$f":"SUM($G$147:L147)","v":999999.99999999988},{"$f":"SUM($G$147:M147)","v":1166666.6666666665},{"$f":"SUM($G$147:N147)","v":1333333.3333333333},{"$f":"SUM($G$147:O147)","v":1500000},{"$f":"SUM($G$147:P147)","v":1666666.6666666667},{"$f":"SUM($G$147:Q147)","v":1833333.3333333335},{"$f":"SUM($G$147:R147)","v":2000000.0000000002},{"$f":"SUM($G$147:S147)","v":2166666.666666667},{"$f":"SUM($G$147:T147)","v":2333333.3333333335},{"$f":"SUM($G$147:U147)","v":2500000},{"$f":"SUM($G$147:V147)","v":2500000},{"$f":"SUM($G$147:W147)","v":2500000},{"$f":"SUM($G$147:X147)","v":2500000},{"$f":"SUM($G$147:Y147)","v":2500000},{"$f":"SUM($G$147:Z147)","v":2500000},{"$f":"SUM($G$147:AA147)","v":2500000},{"$f":"SUM($G$147:AB147)","v":2500000},{"$f":"SUM($G$147:AC147)","v":2500000},{"$f":"SUM($G$147:AD147)","v":2500000},{"$f":"SUM($G$147:AE147)","v":2500000},{"$f":"SUM($G$147:AF147)","v":2500000},{"$f":"SUM($G$147:AG147)","v":2500000},{"$f":"SUM($G$147:AH147)","v":2500000},{"$f":"SUM($G$147:AI147)","v":2500000},{"$f":"SUM($G$147:AJ147)","v":2500000},{"$f":"SUM($G$147:AK147)","v":2500000},{"$f":"SUM($G$147:AL147)","v":2500000},{"$f":"SUM($G$147:AM147)","v":2500000},{"$f":"SUM($G$147:AN147)","v":2500000},{"$f":"SUM($G$147:AO147)","v":2500000},{"$f":"SUM($G$147:AP147)","v":2500000},{"$f":"SUM($G$147:AQ147)","v":2500000},{"$f":"SUM($G$147:AR147)","v":2500000},{"$f":"SUM($G$147:AS147)","v":2500000},{"$f":"SUM($G$147:AT147)","v":2500000}]
[null,"ACCUMULATED INVESTMENT",null,null,null,null,{"$f":"SUM(G126)","v":2500000},{"$f":"SUM($G$126:H126)","v":2500000},{"$f":"SUM($G$126:I126)","v":2500000},{"$f":"SUM($G$126:J126)","v":2500000},{"$f":"SUM($G$126:K126)","v":2500000},{"$f":"SUM($G$126:L126)","v":2500000},{"$f":"SUM($G$126:M126)","v":2500000},{"$f":"SUM($G$126:N126)","v":2500000},{"$f":"SUM($G$126:O126)","v":2500000},{"$f":"SUM($G$126:P126)","v":2500000},{"$f":"SUM($G$126:Q126)","v":2500000},{"$f":"SUM($G$126:R126)","v":2500000},{"$f":"SUM($G$126:S126)","v":2500000},{"$f":"SUM($G$126:T126)","v":2500000},{"$f":"SUM($G$126:U126)","v":2500000},{"$f":"SUM($G$126:V126)","v":2500000},{"$f":"SUM($G$126:W126)","v":2500000},{"$f":"SUM($G$126:X126)","v":2500000},{"$f":"SUM($G$126:Y126)","v":2500000},{"$f":"SUM($G$126:Z126)","v":2500000},{"$f":"SUM($G$126:AA126)","v":2500000},{"$f":"SUM($G$126:AB126)","v":2500000},{"$f":"SUM($G$126:AC126)","v":2500000},{"$f":"SUM($G$126:AD126)","v":2500000},{"$f":"SUM($G$126:AE126)","v":2500000},{"$f":"SUM($G$126:AF126)","v":2500000},{"$f":"SUM($G$126:AG126)","v":2500000},{"$f":"SUM($G$126:AH126)","v":2500000},{"$f":"SUM($G$126:AI126)","v":2500000},{"$f":"SUM($G$126:AJ126)","v":2500000},{"$f":"SUM($G$126:AK126)","v":2500000},{"$f":"SUM($G$126:AL126)","v":2500000},{"$f":"SUM($G$126:AM126)","v":2500000},{"$f":"SUM($G$126:AN126)","v":2500000},{"$f":"SUM($G$126:AO126)","v":2500000},{"$f":"SUM($G$126:AP126)","v":2500000},{"$f":"SUM($G$126:AQ126)","v":2500000},{"$f":"SUM($G$126:AR126)","v":2500000},{"$f":"SUM($G$126:AS126)","v":2500000},{"$f":"SUM($G$126:AT126)","v":2500000}]
[null,"BOOK VALUE, END OF YEAR",null,null,null,null,{"$f":"G149-G148","v":2333333.3333333335},2166666.6666666665,2000000,1833333.3333333335,1666666.6666666667,1500000,1333333.3333333335,1166666.6666666667,1000000,833333.33333333326,666666.66666666651,499999.99999999977,333333.33333333302,166666.66666666651,0,0,0,0,0,0,0,0,0,{"$f":"AD149-AD148","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"INTEREST EXPENSE",null,null,null,null,{"$f":"((G130+G150)/2)*$C$157*$C$158","v":74017.666666666686},{"$f":"((H130+H150)/2)*$C$157*$C$158","v":68913},63808.333333333328,58703.666666666672,53599,48494.333333333343,43389.666666666672,38285,33180.333333333343,28075.666666666668,22970.999999999996,17866.333333333328,12761.666666666659,7656.9999999999936,2552.3333333333308,0,0,0,0,0,0,0,0,{"$f":"((AD130+AD150)/2)*$C$157*$C$158","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"(G150+G149)*$C$157*$C$158/2","v":74017.666666666686},{"$f":"(H150+H149-H137)*$C$157*$C$158/2","v":71465.333333333328},{"$f":"(I150+I149)*$C$157*$C$158/2","v":68913},66360.666666666686,63808.333333333343,61256,58703.666666666672,56151.333333333343,53599,51046.666666666664,48494.333333333336,45942,43389.666666666664,40837.333333333336,38285,38285,38285,38285,38285,38285,38285,38285,38285,{"$f":"(AD150+AD149)*$C$157*$C$158/2","v":38285},38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285,38285]
[null,null,null,null,null,null,null,{"$f":"(G150+H150)*C157*C158/2","v":68913}]
[]
[]
[]
[null,"DEBT RATIO:",{"$f":"ROUND(+D162+D163+D164,4)","v":0.52}]
[null," WTD LT AND ST DEBT ROR:",{"$f":"ROUND(I162+I163+I164,4)","v":5.8900000000000001E-2}]
[]
[null,"Docket Nos. UE-111048 and UG-111049 (Consolidated)"]
[null,null,null,"Ratio",null,"Cost","Return"]
[null,"Debt LT",null,0.48,null,6.1600000000000002E-2,{"$f":"ROUND(F162*D162,4)","v":2.9600000000000001E-2},{"$f":"D162/$C$157","v":0.92307692307692302},{"$f":"H162*F162","v":5.6861538461538456E-2}]
[null,"Debt ST",null,0.04,null,2.6800000000000001E-2,{"$f":"ROUND(F163*D163,4)","v":1.1000000000000001E-3},{"$f":"D163/$C$157","v":7.6923076923076927E-2},{"$f":"H163*F163","v":2.0615384615384619E-3}]
[null,"Trust Preferred",null,0,null,0,{"$f":"ROUND(F164*D164,4)","v":0},{"$f":"D164/$C$157","v":0},{"$f":"H164*F164","v":0}]
[null,"Preferred",null,0,null,0,{"$f":"ROUND(F165*D165,4)","v":0}]
[null,"Common Equity",null,0.48,null,9.8000000000000004E-2,{"$f":"ROUND(F166*D166,4)","v":4.7E-2}]
[null,null,null,{"$f":"SUM(D162:D166)","v":1},null,null,{"$f":"SUM(G162:G166)","v":7.7700000000000005E-2}]
[null,{"$f":"B112","v":"PUGET SOUND ENERGY"}]
[null,{"$f":"B113","v":"NATURAL GAS COMPRESSION SERVICE CHARGE ANALYSIS"}]
[null,{"$f":"B114","v":"Version: P_FIA_CNG_v1_P_12-21-2012.xlsm"}]
[]
[null,"TAX DEPRECIATION","From: Marcelia, Matthew R \nSent: Thursday, July 18, 2013 3:29 PM\nTo: Cass, Mei; Ross, Marjorie\nSubject: RE: Bonus Depreciation Question\n\nGas has a life of 20 years (for a while it was 15 years, then it reverted back to 20).\n\nMatt\nFrom: Marcelia, Matthew R \nSent: Thursday, July 18, 2013 3:29 PM\nTo: Cass, Mei; Ross, Marjorie\nSubject: RE: Bonus Depreciation Question\n\nGas has a life of 20 years (for a while it was 15 years, then it reverted back to 20).\n\nMatt\n",null,"YEAR:",null,1,2,3,4,5,{"$f":"K172+1","v":6},7,8,9,10,{"$f":"P172+1","v":11},12,13,14,15,16,17,18,19,20,21,{"$f":"AA172+1","v":22},{"$f":"AB172+1","v":23},{"$f":"AC172+1","v":24},25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[]
[null,"TAX DEPRECIATION RATE",null,"MAIN, MSA, OTHER",null,null,3.7499999999999999E-2,7.2190000000000004E-2,6.6769999999999996E-2,6.1769999999999999E-2,5.713E-2,5.2850000000000001E-2,4.888E-2,4.5220000000000003E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,2.231E-2]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,1,null,null,{"$f":"IF(G$172<=16,G174*SUM($G122,$G124:$G125),0)+0.5*(IF(H$172<=16,H174*SUM($G122,$G124:$G125),0))","v":183987.5},{"$f":"0.5*(IF(H$172<=16,H174*SUM($G122,$G124:$G125),0))+0.5*(IF(I$172<=16,I174*SUM($G122,$G124:$G125),0))","v":173700},160675,148625,137475,127162.5,117625,112300,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,55762.500000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D175+1","v":2},null,null,{"$f":"0.5*(IF(G$172<=17,F174*SUM($H122,$H124:$H125),0))+0.5*(IF(H$172<=17,G174*SUM($H122,$H124:$H125),0))","v":0},{"$f":"0.5*(IF(H$172<=17,G174*SUM($H122,$H124:$H125),0))+0.5*(IF(I$172<=17,H174*SUM($H122,$H124:$H125),0))","v":0},{"$f":"0.5*(IF(I$172<=17,H174*SUM($H122,$H124:$H125),0))+0.5*(IF(J$172<=17,I174*SUM($H122,$H124:$H125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,3,null,null,null,{"$f":"0.5*(IF(H$172<=18,F174*SUM($I122,$I124:$I125),0))+0.5*(IF(I$172<=18,G174*SUM($I122,$I124:$I125),0))","v":0},{"$f":"0.5*(IF(I$172<=18,G174*SUM($I122,$I124:$I125),0))+0.5*(IF(J$172<=18,H174*SUM($I122,$I124:$I125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,4,null,null,null,null,{"$f":"0.5*(IF(I$172<=19,F174*SUM($J122,$J124:$J125),0))+0.5*(IF(J$172<=19,G174*SUM($J122,$J124:$J125),0))","v":0},{"$f":"0.5*(IF(J$172<=19,G174*SUM($J122,$J124:$J125),0))+0.5*(IF(K$172<=19,H174*SUM($J122,$J124:$J125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,5,null,null,null,null,null,{"$f":"0.5*(IF(J$172<=20,F174*SUM($K122,$K124:$K125),0))+0.5*(IF(K$172<=20,G174*SUM($K122,$K124:$K125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,6,null,null,null,null,null,null,{"$f":"0.5*(IF(K$172<=21,F174*SUM($L122,$L124:$L125),0))+0.5*(IF(L$172<=21,G174*SUM($L122,$L124:$L125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,7,null,null,null,null,null,null,null,{"$f":"0.5*(IF(L$172<=22,F174*SUM($M122,$M124:$M125),0))+0.5*(IF(M$172<=22,G174*SUM($M122,$M124:$M125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D181+1","v":8},null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(M$172<=23,F174*SUM($N122,$N124:$N125),0))+0.5*(IF(N$172<=23,G174*SUM($N122,$N124:$N125),0))","v":0},{"$f":"0.5*(IF(N$172<=23,G174*SUM($N122,$N124:$N125),0))+0.5*(IF(O$172<=23,H174*SUM($N122,$N124:$N125),0))","v":0},0,0,{"$f":"0.5*(IF(Q$172<=23,J174*SUM($N122,$N124:$N125),0))+0.5*(IF(R$172<=23,K174*SUM($N122,$N124:$N125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D182+1","v":9},null,null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(N$172<=24,F174*SUM(O122,$O124:$O125),0))+0.5*(IF(O$172<=24,G174*SUM($O122,$O124:$O125),0))","v":0},{"$f":"0.5*(IF(O$172<=24,G174*SUM(P122,$O124:$O125),0))+0.5*(IF(P$172<=24,H174*SUM($O122,$O124:$O125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D183+1","v":10},null,null,null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(O$172<=25,F174*SUM($P122,$P124:$P125),0))+0.5*(IF(P$172<=25,G174*SUM($P122,$P124:$P125),0))","v":0},{"$f":"0.5*(IF(P$172<=25,G174*SUM($P122,$P124:$P125),0))+0.5*(IF(Q$172<=25,H174*SUM($P122,$P124:$P125),0))","v":0},{"$f":"0.5*(IF(Q$172<=25,H174*SUM($P122,$P124:$P125),0))+0.5*(IF(R$172<=25,I174*SUM($P122,$P124:$P125),0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G175:G184)","v":183987.5},173700,160675,148625,137475,127162.5,117625,112300,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,55762.500000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
[null,null,null,"SERVICE",null,null,{"$f":"G174","v":3.7499999999999999E-2},7.2190000000000004E-2,6.6769999999999996E-2,6.1769999999999999E-2,5.713E-2,5.2850000000000001E-2,4.888E-2,4.5220000000000003E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,4.462E-2,4.4610000000000004E-2,2.231E-2]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,1,null,null,{"$f":"IF(G$172<=16,G187*$G$123,0)+0.5*(IF(H$172<=16,H187*$G$123,0))","v":0},{"$f":"0.5*(IF(H$172<=16,H187*$G$123,0))+0.5*(IF(I$172<=16,I187*$G$123,0))","v":0},{"$f":"0.5*(IF(I$172<=16,I187*$G$123,0))+0.5*(IF(J$172<=16,J187*$G$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D188+1","v":2},null,null,{"$f":"0.5*(IF(G$172<=17,F187*$H$123,0))+0.5*(IF(H$172<=17,G187*$H$123,0))","v":0},{"$f":"0.5*(IF(H$172<=17,G187*$H$123,0))+0.5*(IF(I$172<=17,H187*$H$123,0))","v":0},{"$f":"0.5*(IF(I$172<=17,H187*$H$123,0))+0.5*(IF(J$172<=17,I187*$H$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,3,null,null,null,{"$f":"0.5*(IF(H$172<=18,F187*$I$123,0))+0.5*(IF(I$172<=18,G187*$I$123,0))","v":0},{"$f":"0.5*(IF(I$172<=18,G187*$I$123,0))+0.5*(IF(J$172<=18,H187*$I$123,0))","v":0},{"$f":"0.5*(IF(J$172<=18,H187*$I$123,0))+0.5*(IF(K$172<=18,I187*$I$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,4,null,null,null,null,{"$f":"0.5*(IF(I$172<=19,F187*$J$123,0))+0.5*(IF(J$172<=19,G187*$J$123,0))","v":0},{"$f":"0.5*(IF(J$172<=19,G187*$J$123,0))+0.5*(IF(K$172<=19,H187*$J$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,5,null,null,null,null,null,{"$f":"0.5*(IF(J$172<=20,F187*$K$123,0))+0.5*(IF(K$172<=20,G187*$K$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,6,null,null,null,null,null,null,{"$f":"0.5*(IF(K$172<=21,F187*$L$123,0))+0.5*(IF(L$172<=21,G187*$L$123,0))","v":0},{"$f":"0.5*(IF(L$172<=21,G187*$L$123,0))+0.5*(IF(M$172<=21,H187*$L$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,7,null,null,null,null,null,null,null,{"$f":"0.5*(IF(L$172<=22,F187*$M$123,0))+0.5*(IF(M$172<=22,G187*$M$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D194+1","v":8},null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(M$172<=23,F187*$N$123,0))+0.5*(IF(N$172<=23,G187*$N$123,0))","v":0},{"$f":"0.5*(IF(N$172<=23,G187*$N$123,0))+0.5*(IF(O$172<=23,H187*$N$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D195+1","v":9},null,null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(N$172<=24,F187*$O$123,0))+0.5*(IF(O$172<=24,G187*$O$123,0))","v":0},{"$f":"0.5*(IF(O$172<=24,G187*$O$123,0))+0.5*(IF(P$172<=24,H187*$O$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATION, INVESTMENT  IN YR ",null,{"$f":"D196+1","v":10},null,null,null,null,null,null,null,null,null,null,{"$f":"0.5*(IF(O$172<=25,F187*$P$123,0))+0.5*(IF(P$172<=25,G187*$P$123,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,null,null,null,{"$f":"SUM(G188:G197)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"TOTAL TAX DEPRECIATION",null,null,null,null,{"$f":"G185+G198","v":183987.5},{"$f":"H185+H198","v":173700},160675,148625,137475,127162.5,117625,112300,111537.5,111537.5,{"$f":"Q185+Q198","v":111537.5},111537.5,111537.5,111537.5,111537.5,55762.500000000007,0,0,0,0,0,0,0,{"$f":"AD185+AD198","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"DEPRECIATED PLANT VALUE",null,null,null,null,{"$f":"SUM(G126)-SUM(F202)","v":2500000},{"$f":"SUM($G$126:H126)-SUM($F$202:G202)","v":2316012.5},{"$f":"SUM($G$126:I126)-SUM($F$202:H202)","v":2142312.5},{"$f":"SUM($G$126:J126)-SUM($F$202:I202)","v":1981637.5},{"$f":"SUM($G$126:K126)-SUM($F$202:J202)","v":1833012.5},{"$f":"SUM($G$126:L126)-SUM($F$202:K202)","v":1695537.5},{"$f":"SUM($G$126:M126)-SUM($F$202:L202)","v":1568375},{"$f":"SUM($G$126:N126)-SUM($F$202:M202)","v":1450750},{"$f":"SUM($G$126:O126)-SUM($F$202:N202)","v":1338450},{"$f":"SUM($G$126:P126)-SUM($F$202:O202)","v":1226912.5},{"$f":"SUM($G$126:Q126)-SUM($F$202:P202)","v":1115375},{"$f":"SUM($G$126:R126)-SUM($F$202:Q202)","v":1003837.5},{"$f":"SUM($G$126:S126)-SUM($F$202:R202)","v":892300},{"$f":"SUM($G$126:T126)-SUM($F$202:S202)","v":780762.5},{"$f":"SUM($G$126:U126)-SUM($F$202:T202)","v":669225},{"$f":"SUM($G$126:V126)-SUM($F$202:U202)","v":557687.5},{"$f":"SUM($G$126:W126)-SUM($F$202:V202)","v":501925},{"$f":"SUM($G$126:X126)-SUM($F$202:W202)","v":501925},{"$f":"SUM($G$126:Y126)-SUM($F$202:X202)","v":501925},{"$f":"SUM($G$126:Z126)-SUM($F$202:Y202)","v":501925},{"$f":"((SUM($G$126:AA126)-SUM($F$202:Z202)))","v":501925},{"$f":"((SUM($G$126:AB126)-SUM($F$202:AA202)))","v":501925},{"$f":"((SUM($G$126:AC126)-SUM($F$202:AB202)))","v":501925},{"$f":"((SUM($G$126:AD126)-SUM($F$202:AC202)))","v":501925},{"$f":"((SUM($G$126:AE126)-SUM($F$202:AD202)))","v":501925},{"$f":"((SUM($G$126:AF126)-SUM($F$202:AE202)))","v":501925},{"$f":"((SUM($G$126:AG126)-SUM($F$202:AF202)))","v":501925},{"$f":"((SUM($G$126:AH126)-SUM($F$202:AG202)))","v":501925},{"$f":"((SUM($G$126:AI126)-SUM($F$202:AH202)))","v":501925},{"$f":"((SUM($G$126:AJ126)-SUM($F$202:AI202)))","v":501925},{"$f":"((SUM($G$126:AK126)-SUM($F$202:AJ202)))","v":501925},{"$f":"((SUM($G$126:AL126)-SUM($F$202:AK202)))","v":501925},{"$f":"((SUM($G$126:AM126)-SUM($F$202:AL202)))","v":501925},{"$f":"((SUM($G$126:AN126)-SUM($F$202:AM202)))","v":501925},{"$f":"((SUM($G$126:AO126)-SUM($F$202:AN202)))","v":501925},{"$f":"((SUM($G$126:AP126)-SUM($F$202:AO202)))","v":501925},{"$f":"((SUM($G$126:AQ126)-SUM($F$202:AP202)))","v":501925},{"$f":"((SUM($G$126:AR126)-SUM($F$202:AQ202)))","v":501925},{"$f":"((SUM($G$126:AS126)-SUM($F$202:AR202)))","v":501925},{"$f":"((SUM($G$126:AT126)-SUM($F$202:AS202)))","v":501925}]
[]
["CASH FLOW ANALYSIS",null,null,null,"YEAR:",0,1,2,3,4,5,{"$f":"K205+1","v":6},7,8,9,10,{"$f":"P205+1","v":11},12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"AC205+1","v":24},25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
["+  +","REVENUE AT AVG $/MCF OF:",null,null,null,null,{"$f":"G272","v":189767.1602836879},379534.32056737581,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,0,0,0,0,0,0,0,0,{"$f":"AD272","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-   -","COST OF GAS",null,null,null,null,{"$f":"G284/(1+$C$211)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD284/(1+$C$211)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-   -","INCREMENTAL BILLING (CNG O&M)",null,null,null,null,{"$f":"G296","v":150000},153750,157593.75,161533.59375,165571.93359375,169711.23193359372,173954.01273193356,178302.86305023188,182760.43462648767,187329.44549214985,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD296","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-   -","OTHER O&M (PROPANE CONVERSION COST)",null,null,null,null,{"$f":"IF($C$25=G$120,$C$30,0)+IF($D$25=G$120,$D$30,0)+IF($E$25=G$120,$E$30,0)+IF($F$25=G$120,$F$30,0)+IF($G$25=G$120,$G$30,0)+IF($H$25=G$120,$H$30,0)+IF($I$25=G$120,$I$30,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF($C$25=Q$120,$C$30,0)+IF($D$25=Q$120,$D$30,0)+IF($E$25=Q$120,$E$30,0)+IF($F$25=Q$120,$F$30,0)+IF($G$25=Q$120,$G$30,0)+IF($H$25=Q$120,$H$30,0)+IF($I$25=Q$120,$I$30,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-   -","PROPERTY TAXES",6.54838822593359E-3,null,null,null,{"$f":"IF(G205<=$D$116,+G130*$C$210,0)","v":16370.970564833975},{"$f":"IF(H205<=$D$116,+H130*$C$210,0)","v":15279.572527178378},14188.174489522777,13096.776451867179,12005.378414211582,10913.980376555985,9822.5823389003854,8731.184301244788,7639.7862635891888,6548.3882259335896,5456.9901882779914,4365.5921506223922,3274.1941129667935,2182.7960753111947,1091.3980376555974,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-   -","REVENUE TAXES",4.6135000000000002E-2,null,null,null,{"$f":"$C$211*(G206/(1+$C$211))","v":8368.8127628728053},{"$f":"$C$211*(H206/(1+$C$211))","v":16737.625525745611},23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,23910.893608208011,0,0,0,0,0,0,0,0,{"$f":"$C$211*(AD206/(1+$C$211))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-","INTEREST ON PSE BONDS",null,null,null,null,{"$f":"G151","v":74017.666666666686},68913,63808.333333333328,58703.666666666672,53599,48494.333333333343,43389.666666666672,38285,33180.333333333343,28075.666666666668,22970.999999999996,17866.333333333328,12761.666666666659,7656.9999999999936,2552.3333333333308,0,0,0,0,0,0,0,0,{"$f":"AD151","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-","TAX DEPRECIATION",null,null,null,null,{"$f":"IF(G205<$D$116,+G185,0)+IF(G205<=$I$9,+G198,IF(G205=$I$9+1,SUM(G198:AA198),0))","v":183987.5},173700,160675,148625,137475,127162.5,117625,112300,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,111537.5,55762.500000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["=","TAXABLE INCOME",null,null,null,null,{"$f":"IF(G205<=$D$116,+G206-SUM(G207:G213),0)","v":-242977.78971068558},{"$f":"IF(H205<=$D$116,+H206-SUM(H207:H213),0)","v":-48845.877485548204},{"$f":"IF(I205<=$D$116,+I206-SUM(I207:I213),0)","v":122015.73509375844},136321.9560480807,149629.68090865295,161998.94727313146,173489.73117911391,180661.9455651379,183162.93869320431,184789.99253186444,378315.50272833655,384511.56743265886,390707.63213698112,396903.69684130338,403099.76154562563,-55762.500000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-    ","FIT",0.35,0.21879999999999999,null,null,{"$f":"IF(G205<=$D$116,$C$215*G214,0)","v":-85042.226398739949},{"$f":"IF(H205<=$D$116,$C$215*H214,0)","v":-17096.05711994187},{"$f":"IF(I205<=$D$116,$C$215*I214,0)","v":42705.507282815452},47712.684616828243,52370.388318028534,56699.631545596007,60721.405912689865,63231.680947798261,64107.028542621505,64676.49738615255,132410.4259549178,134579.04860143061,136747.67124794339,138916.29389445618,141084.91654096896,-19516.875,0,0,0,0,0,0,0,{"$f":"IF(AD205<=$D$116,$C$215*AD214,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NET INCOME",null,null,null,null,{"$f":"IF(G205<=$D$116,+G214-G215,0)","v":-157935.56331194565},-31749.820365606334,79310.22781094299,88609.271431252448,97259.29259062442,105299.31572753546,112768.32526642404,117430.26461733964,119055.91015058281,120113.49514571189,245905.07677341875,249932.51883122826,253959.96088903773,257987.4029468472,262014.84500465667,-36245.625000000007,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["=","OPERATING INCOME",null,null,null,{"$f":"SUM(F225:AT225)","v":-2500000},{"$f":"IF(G205<=$D$116,+G206-G207-G208-G209-G210-G211-G215-G126*0,0)","v":100069.60335472107},{"$f":"IF(H205<=$D$116,+H206-H207-H208-H209-H210-H211-H215-H126*0,0)","v":210863.17963439366},{"$f":"IF(I205<=$D$116,+I206-I207-I208-I209-I210-I211-I215-I126*0,0)","v":303793.56114427635},{"$f":"IF(J205<=$D$116,+J206-J207-J208-J209-J210-J211-J215-J126*0,0)","v":295937.93809791916},288333.29259062448,280956.14906086883,273782.99193309079,268015.26461733965,263773.74348391622,259726.66181237856,380413.57677341875,379336.35216456157,378259.12755570444,377181.90294684726,376104.67833798996,19516.875,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ADJUSTED OPERATING INCOME - @MID YEAR ASSUMPTION (USED AS IRR SERIES)",null,null,null,{"$f":"F218+0.5*G218","v":-2449965.1983226393},{"$f":"G218*0.5+H218*0.5","v":155466.39149455738},{"$f":"H218*0.5+I218*0.5","v":257328.370389335},299865.74962109776,292135.61534427182,284644.72082574666,277369.57049697981,270899.12827521522,265894.50405062793,261750.20264814739,{"$f":"P218*0.5+Q218*0.5","v":320070.11929289869},379874.96446899016,378797.73986013304,377720.51525127585,376643.29064241861,197810.77666899498,9758.4375,0,0,0,0,0,0,{"$f":"AC218*0.5+AD218*0.5","v":0},{"$f":"AD218*0.5+AE218*0.5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"PW FACTORS @ TARGET ROR",null,{"$f":"$I$13","v":7.7700000000000005E-2},null,{"$f":"1/(1+$D221)^F$205","v":1},{"$f":"1/(1+$D221)^G$205","v":0.92790201354736934},0.86100214674526232,0.79892562563353642,0.74132469669995027,0.68787667876027669,0.63828215529393761,0.59226329710859937,0.54956230593727318,0.50993997024893123,0.47317432518226882,0.43905940909554492,0.40740410976667429,0.37803109377997052,0.35077581310194905,0.32548558328101418,0.30201872810709302,0.2802437859395871,0.26003877325748076,0.24129050130600421,0.22389394201169549,0.20775163961371018,0.19277316471532907,0.17887460769725252,0.16597810865477639,0.15401142122555106,0.14290750786448086,0.13260416429848831,0.12304367105733349,0.11417247012835992,0.10594086492378203,9.8302741879727207E-2,9.1215312127426187E-2,8.4638871789390543E-2,7.8536579557753117E-2,7.2874250308762267E-2,6.762016359725552E-2,6.2744885958295915E-2,5.8221106020502837E-2,5.4023481507379442E-2,5.0128497269536457E-2]
[null,{"$f":"\"PW OF CASH FLOWS @ \"&TEXT($D$221,\"#.#0%\")","v":"PW OF CASH FLOWS @ 7.77%"},null,{"$f":"SUM($F$222:$AT$222)","v":2449641.884860401},null,null,{"$f":"G221*(G219)","v":144257.57770674341},{"$f":"H221*(H219)","v":221560.27932367745},239570.43162210492,216567.34644034563,195800.46518826077,177040.04726976604,160443.61089612436,146125.59678211072,133476.89055104801,151448.96270742561,{"$f":"Q221*(Q219)","v":166787.67742994594},154323.75598934578,142790.09952357385,132117.3565244881,64384.55602337826,2947.2308820625603,0,0,0,0,0,0,0,{"$f":"AD221*(AD219)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"CUMULATIVE PW CASH FLOWS  @ \"&TEXT($D$221,\"#.#0%\")","v":"CUMULATIVE PW CASH FLOWS  @ 7.77%"},null,null,null,null,{"$f":"SUM(G222)","v":144257.57770674341},{"$f":"SUM($G$222:H222)","v":365817.85703042086},{"$f":"SUM($G$222:I222)","v":605388.28865252575},{"$f":"SUM($G$222:J222)","v":821955.63509287138},{"$f":"SUM($G$222:K222)","v":1017756.1002811322},{"$f":"SUM($G$222:L222)","v":1194796.1475508981},{"$f":"SUM($G$222:M222)","v":1355239.7584470224},{"$f":"SUM($G$222:N222)","v":1501365.355229133},{"$f":"SUM($G$222:O222)","v":1634842.2457801811},{"$f":"SUM($G$222:P222)","v":1786291.2084876068},{"$f":"SUM($G$222:Q222)","v":1953078.8859175527},{"$f":"SUM($G$222:R222)","v":2107402.6419068985},{"$f":"SUM($G$222:S222)","v":2250192.7414304721},{"$f":"SUM($G$222:T222)","v":2382310.0979549601},{"$f":"SUM($G$222:U222)","v":2446694.6539783385},{"$f":"SUM($G$222:V222)","v":2449641.884860401},{"$f":"SUM($G$222:W222)","v":2449641.884860401},{"$f":"SUM($G$222:X222)","v":2449641.884860401},{"$f":"SUM($G$222:Y222)","v":2449641.884860401},{"$f":"SUM($G$222:Z222)","v":2449641.884860401},{"$f":"SUM($G$222:AA222)","v":2449641.884860401},{"$f":"SUM($G$222:AB222)","v":2449641.884860401},{"$f":"SUM($G$222:AC222)","v":2449641.884860401},{"$f":"SUM($G$222:AD222)","v":2449641.884860401},{"$f":"SUM($G$222:AE222)","v":2449641.884860401},{"$f":"SUM($G$222:AF222)","v":2449641.884860401},{"$f":"SUM($G$222:AG222)","v":2449641.884860401},{"$f":"SUM($G$222:AH222)","v":2449641.884860401},{"$f":"SUM($G$222:AI222)","v":2449641.884860401},{"$f":"SUM($G$222:AJ222)","v":2449641.884860401},{"$f":"SUM($G$222:AK222)","v":2449641.884860401},{"$f":"SUM($G$222:AL222)","v":2449641.884860401},{"$f":"SUM($G$222:AM222)","v":2449641.884860401},{"$f":"SUM($G$222:AN222)","v":2449641.884860401},{"$f":"SUM($G$222:AO222)","v":2449641.884860401},{"$f":"SUM($G$222:AP222)","v":2449641.884860401},{"$f":"SUM($G$222:AQ222)","v":2449641.884860401},{"$f":"SUM($G$222:AR222)","v":2449641.884860401},{"$f":"SUM($G$222:AS222)","v":2449641.884860401},{"$f":"SUM($G$222:AT222)","v":2449641.884860401}]
[]
[null,{"$f":"\"PW CAP INVESTMENTS @ \"&FIXED(I13*100,2,TRUE)&\"%\"","v":"PW CAP INVESTMENTS @ 7.77%"},null,null,null,{"$f":"F221*G126*-1","v":-2500000},{"$f":"G221*H126*-1","v":0},0,0,0,0,0,{"$f":"M221*N126*-1","v":0},{"$f":"N221*O126*-1","v":0},{"$f":"O221*P126*-1","v":0}]
[]
[null,"INTERNAL RATE OF RETURN",null,{"$f":"IRR(F219:AT219,-0.1)","v":7.7680234669242454E-2}]
[null,{"$f":"\"NET PRESENT VALUE @ \"&FIXED(I13*100,2,TRUE)&\"%\"","v":"NET PRESENT VALUE @ 7.77%"},null,{"$f":"NPV(D221,F219:AT219)","v":-300.00321261768903}]
[]
[]
[null,"PW FACTORS @ IRR",null,{"$f":"$D$227","v":7.7680234669242454E-2},null,{"$f":"1/(1+$D$227)^F205","v":1},{"$f":"1/(1+$D$227)^G205","v":0.92791903185170344},0.86103372967260261,0.79896958482946279,0.74137908363391258,0.68793976152068326,0.63835239748256412,0.59233933865223476,0.54964294564985994,0.51002414999153645,0.47326111548113453,0.43914799609031152,0.40749378337173758,0.37812123695189048,0.35086589211496677,0.32557513892110423,0.30210736770265484,0.28033117615391406,0.26012463357458931,0.24137459814731199,0.22397608342644776,0.20783167049100576,0.19285096247013631,0.17895007838695806,{"$f":"1/(1+$D$227)^AD205","v":0.16605118348661257},0.15408205341872711,0.14297566983402771,0.13266984513073979,0.12310687424963151,0.11423321156800746,0.1059991710834963,9.8358648208880961E-2,9.1268861620227112E-2,8.4690113712848222E-2,7.8585568323836799E-2,7.2921044476570537E-2,6.766482499231434E-2,6.2787478897283269E-2,5.8261696630776363E-2,5.4062137131667652E-2,5.016528594705108E-2]
[null,{"$f":"\"PW OF CASH FLOWS @ \"&FIXED(D$227*100,2,TRUE)&\"%\"","v":"PW OF CASH FLOWS @ 7.77%"},null,{"$f":"SUM($G$232:$AT$232)","v":2449965.1983226417},null,null,{"$f":"G219*G231","v":144260.22348110759},221568.40650690204,239583.61347934412,216583.23480076541,195818.42136298562,177059.53031545616,160464.2104840079,146147.03843849574,133498.92461573379,151476.74168873703,166821.32941143532,154357.72414826887,142824.14844891784,132151.28418036891,64402.271094099568,2948.0958660158758,0,0,0,0,0,0,0,{"$f":"AD219*AD231","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"CUMMULATIVE PW CASH FLOWS @ \"&FIXED(D$227*100,2,TRUE)&\"%\"","v":"CUMMULATIVE PW CASH FLOWS @ 7.77%"},null,null,null,null,{"$f":"SUM(G232)","v":144260.22348110759},{"$f":"SUM($G$232:H232)","v":365828.62998800963},{"$f":"SUM($G$232:I232)","v":605412.24346735375},{"$f":"SUM($G$232:J232)","v":821995.47826811916},{"$f":"SUM($G$232:K232)","v":1017813.8996311048},{"$f":"SUM($G$232:L232)","v":1194873.4299465609},{"$f":"SUM($G$232:M232)","v":1355337.6404305687},{"$f":"SUM($G$232:N232)","v":1501484.6788690644},{"$f":"SUM($G$232:O232)","v":1634983.6034847982},{"$f":"SUM($G$232:P232)","v":1786460.3451735352},{"$f":"SUM($G$232:Q232)","v":1953281.6745849706},{"$f":"SUM($G$232:R232)","v":2107639.3987332396},{"$f":"SUM($G$232:S232)","v":2250463.5471821576},{"$f":"SUM($G$232:T232)","v":2382614.8313625264},{"$f":"SUM($G$232:U232)","v":2447017.102456626},{"$f":"SUM($G$232:V232)","v":2449965.1983226417},{"$f":"SUM($G$232:W232)","v":2449965.1983226417},{"$f":"SUM($G$232:X232)","v":2449965.1983226417},{"$f":"SUM($G$232:Y232)","v":2449965.1983226417},{"$f":"SUM($G$232:Z232)","v":2449965.1983226417},{"$f":"SUM($G$232:AA232)","v":2449965.1983226417},{"$f":"SUM($G$232:AB232)","v":2449965.1983226417},{"$f":"SUM($G$232:AC232)","v":2449965.1983226417},{"$f":"SUM($G$232:AD232)","v":2449965.1983226417},{"$f":"SUM($G$232:AE232)","v":2449965.1983226417},{"$f":"SUM($G$232:AF232)","v":2449965.1983226417},{"$f":"SUM($G$232:AG232)","v":2449965.1983226417},{"$f":"SUM($G$232:AH232)","v":2449965.1983226417},{"$f":"SUM($G$232:AI232)","v":2449965.1983226417},{"$f":"SUM($G$232:AJ232)","v":2449965.1983226417},{"$f":"SUM($G$232:AK232)","v":2449965.1983226417},{"$f":"SUM($G$232:AL232)","v":2449965.1983226417},{"$f":"SUM($G$232:AM232)","v":2449965.1983226417},{"$f":"SUM($G$232:AN232)","v":2449965.1983226417},{"$f":"SUM($G$232:AO232)","v":2449965.1983226417},{"$f":"SUM($G$232:AP232)","v":2449965.1983226417},{"$f":"SUM($G$232:AQ232)","v":2449965.1983226417},{"$f":"SUM($G$232:AR232)","v":2449965.1983226417},{"$f":"SUM($G$232:AS232)","v":2449965.1983226417},{"$f":"SUM($G$232:AT232)","v":2449965.1983226417}]
[]
[null,"REMAINING ASSET UN-AMORTIZED",null,null,null,null,{"$f":"(+$F$219*-1-G223)","v":2305707.6206158958},2084147.3412922185,1844576.9096701136,1628009.5632297681,1432209.0980415072,1255169.0507717412,1094725.4398756169,948599.84309350629,815122.9525424582,663673.98983503249,496886.31240508659,342562.55641574087,199772.45689216722,67655.100367679261,3270.5443443008699,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,{"$f":"(+$F$219*-1-AD223)","v":323.31346223829314},323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314,323.31346223829314]
[null,"PW OF REMAINING PLANT",null,null,null,null,{"$f":"G203*G221","v":2319755.0338684232},1994091.7343888618,1711548.3543650454,1469036.8186567477,1260886.5506260716,1082231.3298816946,928890.94860269956,797277.5153384991,682529.15317968198,580543.49424519041,489715.8884199434,408967.52303790388,337317.14497986768,273872.60077701049,217823.08947123672,168432.06943122443,140661.36225772725,130519.96126726102,121109.73486801617,112377.96684422025,104275.74171311148,96757.670699741546,89781.63746844347,{"$f":"AD203*AD221","v":83308.562186548632},77302.18259863471,71728.850884879561,66557.345165518753,61758.694595452114,57306.017069177055,53174.368626869298,49340.603717982078,45783.245539558389,42482.365722889852,39419.472694525233,36577.4080862255,33940.250613552475,31493.226884617678,29222.628639340888,27115.735955591426,25160.745992012085]
[]
[null,{"$f":"\"PW FACTORS AT THRESHOLD ROR (.75 times \"&FIXED(I13*100,2,TRUE)&\"%)\"","v":"PW FACTORS AT THRESHOLD ROR (.75 times 7.77%)"},null,{"$f":"0.75*$I$13","v":5.8275000000000007E-2},null,null,{"$f":"1/(1+$D$238)^G205","v":0.94493397273865487},{"$f":"1/(1+$D$238)^H205","v":0.8929002128356569},0.84373174537398776,0.79727079008196133,0.75336825502063387,0.71188325815183562,0.67268267525155145,0.63564071271791489,0.60063850390296936,0.56756372767283492,0.53631024797225191,0.50677777323687301,0.47887153456036757,0.45250198158358418,0.42758449512988989,0.40403911566453887,0.38179028670670556,0.36076661237079732,0.34090062825900386,0.32212858496988384,0.30439024352827365,0.28762868208005826,0.27179011323149305,{"$f":"1/(1+$D$238)^AD205","v":0.25682371144692351},0.24268144995102742,0.22931794661220137,0.21669031831253818,0.2047580433370704,0.19348283134069158,0.1828285004754828,0.17276086128414905,0.1632476069869826,0.15425820981028807,0.14576382302358845,0.13773718837125365,0.13015254860150113,0.12298556481207731,0.11621323834738355,0.10981383699641732,0.1037668252546997]
[null,"PW CASH FLOWS AT THRESHOLD ROR",null,{"$f":"SUM($G$239:$AT$239)","v":2800140.6506887167},null,null,{"$f":"G219*G238","v":146905.47494229511},229768.55668928998,253006.25230568802,232911.19285660755,214442.29662932825,197454.75355756524,182229.15033148497,169013.37206251765,157217.25011488231,181660.19002256653,203730.8363928145,191966.27511347851,180879.6027733112,170431.83536585624,84580.821073263622,3942.7904577676736,0,0,0,0,0,0,0,{"$f":"AD219*AD238","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"YEAR:",0,1,2,3,4,5,{"$f":"K241+1","v":6},7,8,9,10,{"$f":"P241+1","v":11},12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"AC241+1","v":24},25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,"CALCULATION OF CUSTOMER ADVANCE AND QUALIFICATION PAYMENT"]
[null,"ADVANCE",null,{"$f":"IF(F219*-1>D222,+(F219*-1)-$D$222,0)","v":323.31346223829314}]
[null,"ADVANCE INCL. FIT GROSS-UP",null,{"$f":"$D$243/(1-$C$215)","v":497.40532652045096}]
[null,"QUALIFICATION PAYMENT, SCH 107 SVC",null,{"$f":"IF($D$239<$D$232,($D$239-$D$232)*-1/(1-$C$215),0)","v":0}]
[]
[null,"CALCULATION OF SECURITY DEPOSIT"]
[null,"PW FACTORS @ ",null,{"$f":"$D221","v":7.7700000000000005E-2},null,null,{"$f":"1/(1+$D248)^(G$205+2)","v":0.79892562563353642},{"$f":"1/(1+$D248)^(H$205+2)","v":0.74132469669995027},0.68787667876027669,0.63828215529393761,0.59226329710859937,0.54956230593727318,0.50993997024893123,0.47317432518226882,0.43905940909554492,0.40740410976667429,0.37803109377997052,0.35077581310194905,0.32548558328101418,0.30201872810709302,0.2802437859395871,0.26003877325748076,0.24129050130600421,0.22389394201169549,0.20775163961371018,0.19277316471532907,0.17887460769725252,0.16597810865477639,0.15401142122555106,0.14290750786448086,0.13260416429848831,0.12304367105733349,0.11417247012835992,0.10594086492378203,9.8302741879727207E-2,9.1215312127426187E-2,8.4638871789390543E-2,7.8536579557753117E-2,7.2874250308762267E-2,6.762016359725552E-2,6.2744885958295915E-2,5.8221106020502837E-2,5.4023481507379442E-2,5.0128497269536457E-2,4.6514333552506684E-2,4.3160743762184914E-2]
[null,{"$f":"\"PW CASH FLOWS, 2-YEAR SLIP  @ \"&TEXT($D$221,\"#.#0%\")","v":"PW CASH FLOWS, 2-YEAR SLIP  @ 7.77%"},null,{"$f":"SUM($G249:$AT249)","v":2109146.9216219163},null,null,{"$f":"G248*G219","v":124206.08408977756},{"$f":"H248*H219","v":190763.87613116624},206270.65592332144,186464.95020006254,168584.62086081351,152431.86075915128,138142.29341312466,125814.45252382991,114923.88930533473,130397.88201343663,143604.5483178398,132873.08520061875,122942.58222376673,113753.32758989344,55435.240953369299,2537.5721164097972,0,0,0,0,0,0,0,{"$f":"AD248*AD219","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"PV CAP INVESTMENTS, 2 YEAR SLIP  @ \"&TEXT($D$221,\"#.#0%\")","v":"PV CAP INVESTMENTS, 2 YEAR SLIP  @ 7.77%"},null,{"$f":"SUM($G250:$AT250)+SUM($G122:$M122,$G125:$M125)","v":2500000},null,null,{"$f":"G248*(G123+G124)","v":0},{"$f":"H248*(H123+H124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD248*(AD123+AD124)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"SECURITY DEPOSIT",null,{"$f":"IF(AND($D$249<$D$250,$I$4=\"Yes\"),$D$250-$D$249,0)","v":0}]
[]
[null,"CALCULATION OF CRITICAL NUMBER"]
[null,"PV TOTAL INVESTMENT",null,{"$f":"F219*-1","v":2449965.1983226393}]
[null,"PV SERVICE+MSA INVESTMENTS",null,{"$f":"SUM(G255:AT255)","v":0},null,null,{"$f":"(G124+G123)*G221","v":0},{"$f":"(H124+H123)*H221","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(AD124+AD123)*AD221","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"PV CASH FLOWS",null,{"$f":"D222","v":2449641.884860401}]
[null,"NO. CUSTOMERS",null,{"$f":"J23","v":1}]
[null,"AVERAGE PV CASH FLOW/CUSTOMER",null,{"$f":"D256/D257","v":2449641.884860401}]
[null,"CRITICAL NO.",null,{"$f":"IF($I$4=\"Yes\",(D254-D255)/D258,0)","v":0}]
[]
[null,{"$f":"H1","v":"Version: P_FIA_CNG_v1_P_12-21-2012.xlsm"},null,null,null,null,{"$f":"G205","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"AD205","v":24},25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
[null,{"$f":"C$1","v":"NATURAL GAS COMPRESSION SERVICE CHARGE ANALYSIS"},null,"REVENUE"]
[null,{"$f":"B$9","v":0}]
[null,null,null,"CUST 1",null,null,{"$f":"IF(AND(G$205<=$I$9+$C$25-1),+$C$34*$C$23*$C$24+$C$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"REVENUE, GAS COSTS, CUSTOMER COST",null,"CUST 2","SINGLE CUSTOMER ONLY",null,{"$f":"IF(AND(G$205<=$I$9+$D$25-1,G$205>=$D$25),+$D$34*$D$23*$D$24+$D$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"BY \"&B21","v":"BY CUSTOMER GROUP ID.:"},null,"CUST 3",null,null,{"$f":"IF(AND(G$205<=$I$9+$E$25-1,G$205>=$E$25),+$E$34*$E$23*$E$24+$E$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 4",null,null,{"$f":"IF(AND(G$205<=$I$9+$F$25-1,G$205>=$F$25),+$F$34*$F$23*$F$24+$F$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 5",null,null,{"$f":"IF(AND(G$205<=$I$9+$G$25-1,G$205>=$G$25),+$G$34*$G$23*$G$24+$G$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 6",null,null,{"$f":"IF(AND(G$205<=$I$9+$H$25-1,G$205>=$H$25),+$H$34*$H$23*$H$24+$H$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"UPPER(\"CNG Fixed Charge \")","v":"CNG FIXED CHARGE "},"ROR","CUST 7",null,null,{"$f":"IF(AND(G$205<=$I$9+$I$25-1,G$205>=$I$25),+$I$34*$I$23*$I$24+$I$32,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,0,{"$f":"D227","v":7.7680234669242454E-2},{"$f":"UPPER(\"Contracted Volume Compression Charge\")","v":"CONTRACTED VOLUME COMPRESSION CHARGE"},null,null,{"$f":"IF(AND(G$205<=$I$9+$C$25-1,G$205>=$C$25,$I$11=\"Yes\"),CompressionService!B$8*$C$273+$B$271,0)","v":189767.1602836879},{"$f":"IF(AND(H$205<=$I$9+$C$25-1,H$205>=$C$25,$I$11=\"Yes\"),CompressionService!C$8*$C$273+$B$271,0)","v":379534.32056737581},{"$f":"IF(AND(I$205<=$I$9+$C$25-1,I$205>=$C$25,$I$11=\"Yes\"),CompressionService!D$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(J$205<=$I$9+$C$25-1,J$205>=$C$25,$I$11=\"Yes\"),CompressionService!E$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(K$205<=$I$9+$C$25-1,K$205>=$C$25,$I$11=\"Yes\"),CompressionService!F$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(L$205<=$I$9+$C$25-1,L$205>=$C$25,$I$11=\"Yes\"),CompressionService!G$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(M$205<=$I$9+$C$25-1,M$205>=$C$25,$I$11=\"Yes\"),CompressionService!H$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(N$205<=$I$9+$C$25-1,N$205>=$C$25,$I$11=\"Yes\"),CompressionService!I$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(O$205<=$I$9+$C$25-1,O$205>=$C$25,$I$11=\"Yes\"),CompressionService!J$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(P$205<=$I$9+$C$25-1,P$205>=$C$25,$I$11=\"Yes\"),CompressionService!K$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(Q$205<=$I$9+$C$25-1,Q$205>=$C$25,$I$11=\"Yes\"),CompressionService!L$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(R$205<=$I$9+$C$25-1,R$205>=$C$25,$I$11=\"Yes\"),CompressionService!M$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(S$205<=$I$9+$C$25-1,S$205>=$C$25,$I$11=\"Yes\"),CompressionService!N$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(T$205<=$I$9+$C$25-1,T$205>=$C$25,$I$11=\"Yes\"),CompressionService!O$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(U$205<=$I$9+$C$25-1,U$205>=$C$25,$I$11=\"Yes\"),CompressionService!P$8*$C$273+$B$271,0)","v":542191.88652482256},{"$f":"IF(AND(V$205<=$I$9+$C$25-1,V$205>=$C$25,$I$11=\"Yes\"),CompressionService!Q$8*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(W$205<=$I$9+$C$25-1,W$205>=$C$25,$I$11=\"Yes\"),CompressionService!R$8*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(X$205<=$I$9+$C$25-1,X$205>=$C$25,$I$11=\"Yes\"),CompressionService!S$8*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(Y$205<=$I$9+$C$25-1,Y$205>=$C$25,$I$11=\"Yes\"),CompressionService!T$8*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(Z$205<=$I$9+$C$25-1,Z$205>=$C$25,$I$11=\"Yes\"),CompressionService!U$8*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AA$205<=$I$9+$C$25-1,AA$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AB$205<=$I$9+$C$25-1,AB$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AC$205<=$I$9+$C$25-1,AC$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AD$205<=$I$9+$C$25-1,AD$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AE$205<=$I$9+$C$25-1,AE$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AF$205<=$I$9+$C$25-1,AF$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AG$205<=$I$9+$C$25-1,AG$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AH$205<=$I$9+$C$25-1,AH$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AI$205<=$I$9+$C$25-1,AI$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AJ$205<=$I$9+$C$25-1,AJ$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AK$205<=$I$9+$C$25-1,AK$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AL$205<=$I$9+$C$25-1,AL$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AM$205<=$I$9+$C$25-1,AM$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AN$205<=$I$9+$C$25-1,AN$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AO$205<=$I$9+$C$25-1,AO$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AP$205<=$I$9+$C$25-1,AP$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AQ$205<=$I$9+$C$25-1,AQ$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AR$205<=$I$9+$C$25-1,AR$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AS$205<=$I$9+$C$25-1,AS$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0},{"$f":"IF(AND(AT$205<=$I$9+$C$25-1,AT$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!*$C$273+$B$271,0)","v":0}]
[null,{"$f":"UPPER(\"CNG Volumetric Charge\")","v":"CNG VOLUMETRIC CHARGE"},null,"TOTAL",null,null,{"$f":"SUM(G264:G271)","v":189767.1602836879},379534.32056737581,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,542191.88652482256,{"$f":"SUM(Q264:Q271)","v":542191.88652482256},{"$f":"SUM(R264:R271)","v":542191.88652482256},{"$f":"SUM(S264:S271)","v":542191.88652482256},{"$f":"SUM(T264:T271)","v":542191.88652482256},{"$f":"SUM(U264:U271)","v":542191.88652482256},{"$f":"SUM(V264:V270)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(AD264:AD270)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,1.0387107803020492,{"$f":"ROUND(B273,5)","v":1.03871}]
[null,null,null,"GAS COST"]
[null,"Goal Seek Target",{"$f":"(C271-I13)/I13","v":-2.5438006122974606E-4}]
[null,null,null,"CUST 1",null,null,{"$f":"IF(AND(G$205<=$I$9+$C$25-1),$C$36*$C$24*$C$23,0)","v":0},{"$f":"IF(AND(H$205<=$I$9+$C$25-1),$C$36*$C$24*$C$23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 2","SINGLE CUSTOMER ONLY",null,{"$f":"IF(G$205<=$I$9+$D$25-1,+IF($D$25=G$205,$D$36*$D$24*$D$23,0),0)+IF(G$205<=$I$9+$D$25-1,F277,0)","v":0},{"$f":"IF(H$205<=$I$9+$D$25-1,+IF($D$25=H$205,$D$36*$D$24*$D$23,0),0)+IF(H$205<=$I$9+$D$25-1,G277,0)","v":0},{"$f":"IF(I$205<=$I$9+$D$25-1,+IF($D$25=I$205,$D$36*$D$24*$D$23,0),0)+IF(I$205<=$I$9+$D$25-1,H277,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 3",null,null,{"$f":"IF(G$205<=$I$9+$E$25-1,IF($E$25=G$205,$E$36*$E$24*$E$23,0),0)+IF(G$205<=$I$9+$E$25-1,F278,0)","v":0},{"$f":"IF(H$205<=$I$9+$E$25-1,IF($E$25=H$205,$E$36*$E$24*$E$23,0),0)+IF(H$205<=$I$9+$E$25-1,G278,0)","v":0},{"$f":"IF(I$205<=$I$9+$E$25-1,IF($E$25=I$205,$E$36*$E$24*$E$23,0),0)+IF(I$205<=$I$9+$E$25-1,H278,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 4",null,null,{"$f":"IF(G$205<=$I$9+$F$25-1,IF($F$25=G$205,$F$36*$F$24*$F$23,0),0)+IF(G$205<=$I$9+$F$25-1,F279,0)","v":0},{"$f":"IF(H$205<=$I$9+$F$25-1,IF($F$25=H$205,$F$36*$F$24*$F$23,0),0)+IF(H$205<=$I$9+$F$25-1,G279,0)","v":0},{"$f":"IF(I$205<=$I$9+$F$25-1,IF($F$25=I$205,$F$36*$F$24*$F$23,0),0)+IF(I$205<=$I$9+$F$25-1,H279,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 5",null,null,{"$f":"IF(G$205<=$I$9+$G$25-1,IF($G$25=G$205,$G$36*$G$24*$G$23,0),0)+IF(G$205<=$I$9+$G$25-1,F280,0)","v":0},{"$f":"IF(H$205<=$I$9+$G$25-1,IF($G$25=H$205,$G$36*$G$24*$G$23,0),0)+IF(H$205<=$I$9+$G$25-1,G280,0)","v":0},{"$f":"IF(I$205<=$I$9+$G$25-1,IF($G$25=I$205,$G$36*$G$24*$G$23,0),0)+IF(I$205<=$I$9+$G$25-1,H280,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 6",null,null,{"$f":"IF(G$205<=$I$9+$H$25-1,IF($H$25=G$205,$H$36*$H$24*$H$23,0),0)+IF(G$205<=$I$9+$H$25-1,F281,0)","v":0},{"$f":"IF(H$205<=$I$9+$H$25-1,IF($H$25=H$205,$H$36*$H$24*$H$23,0),0)+IF(H$205<=$I$9+$H$25-1,G281,0)","v":0},{"$f":"IF(I$205<=$I$9+$H$25-1,IF($H$25=I$205,$H$36*$H$24*$H$23,0),0)+IF(I$205<=$I$9+$H$25-1,H281,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 7",null,null,{"$f":"IF(G$205<=$I$9+$I$25-1,IF($I$25=G$205,$I$36*$I$24*$I$23,0),0)+IF(G$205<=$I$9+$I$25-1,F282,0)","v":0},{"$f":"IF(H$205<=$I$9+$I$25-1,IF($I$25=H$205,$I$36*$I$24*$I$23,0),0)+IF(H$205<=$I$9+$I$25-1,G282,0)","v":0},{"$f":"IF(I$205<=$I$9+$I$25-1,IF($I$25=I$205,$I$36*$I$24*$I$23,0),0)+IF(I$205<=$I$9+$I$25-1,H282,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TOTAL",null,null,{"$f":"SUM(G276:G282)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AD276:AD282)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AU262:AU282)","v":0}]
[]
[null,null,null,"CUST COST"]
[]
[null,null,null,"CUST 1",null,null,{"$f":"IF(AND(G$205<=$I$9+$C$25-1),+$C$35*$C$23,0)","v":0},{"$f":"IF(AND(H$205<=$I$9+$C$25-1),+$C$35*$C$23,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 2","SINGLE CUSTOMER ONLY",null,{"$f":"IF(G$205<=$I$9+$D$25-1,IF($D$25=G$205,+$D$35*$D$23,0),0)+IF(G$205<=$I$9+$D$25-1,F289,0)","v":0},{"$f":"IF(H$205<=$I$9+$D$25-1,IF($D$25=H$205,+$D$35*$D$23,0),0)+IF(H$205<=$I$9+$D$25-1,G289,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 3",null,null,{"$f":"IF(G$205<=$I$9+$E$25-1,IF($E$25=G$205,+$E$35*$E$23,0),0)+IF(G$205<=$I$9+$E$25-1,F290,0)","v":0},{"$f":"IF(H$205<=$I$9+$E$25-1,IF($E$25=H$205,+$E$35*$E$23,0),0)+IF(H$205<=$I$9+$E$25-1,G290,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 4",null,null,{"$f":"IF(G$205<=$I$9+$F$25-1,IF($F$25=G$205,+$F$35*$F$23,0),0)+IF(G$205<=$I$9+$F$25-1,F291,0)","v":0},{"$f":"IF(H$205<=$I$9+$F$25-1,IF($F$25=H$205,+$F$35*$F$23,0),0)+IF(H$205<=$I$9+$F$25-1,G291,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 5",null,null,{"$f":"IF(G$205<=$I$9+$G$25-1,IF($G$25=G$205,+$G$35*$G$23,0),0)+IF(G$205<=$I$9+$G$25-1,F292,0)","v":0},{"$f":"IF(H$205<=$I$9+$G$25-1,IF($G$25=H$205,+$G$35*$G$23,0),0)+IF(H$205<=$I$9+$G$25-1,G292,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 6",null,null,{"$f":"IF(G$205<=$I$9+$H$25-1,IF($H$25=G$205,+$H$35*$H$23,0),0)+IF(G$205<=$I$9+$H$25-1,F293,0)","v":0},{"$f":"IF(H$205<=$I$9+$H$25-1,IF($H$25=H$205,+$H$35*$H$23,0),0)+IF(H$205<=$I$9+$H$25-1,G293,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"CUST 7",null,null,{"$f":"IF(G$205<=$I$9+$I$25-1,IF($I$25=G$205,+$I$35*$I$23,0),0)+IF(G$205<=$I$9+$I$25-1,F294,0)","v":0},{"$f":"IF(H$205<=$I$9+$I$25-1,IF($I$25=H$205,+$I$35*$I$23,0),0)+IF(H$205<=$I$9+$I$25-1,G294,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"CompressionService!A6","v":"ANNUAL STATION O&M COST\n(As detailed in Exhibits B and D of Schdule 54 Service Agreement)"},null,null,{"$f":"IF(AND(G$205<=$I$9+$C$25-1,G$205>=$C$25,$I$11=\"Yes\"),CompressionService!B$6,0)","v":150000},{"$f":"IF(AND(H$205<=$I$9+$C$25-1,H$205>=$C$25,$I$11=\"Yes\"),CompressionService!C$6,0)","v":153750},{"$f":"IF(AND(I$205<=$I$9+$C$25-1,I$205>=$C$25,$I$11=\"Yes\"),CompressionService!D$6,0)","v":157593.75},{"$f":"IF(AND(J$205<=$I$9+$C$25-1,J$205>=$C$25,$I$11=\"Yes\"),CompressionService!E$6,0)","v":161533.59375},{"$f":"IF(AND(K$205<=$I$9+$C$25-1,K$205>=$C$25,$I$11=\"Yes\"),CompressionService!F$6,0)","v":165571.93359375},{"$f":"IF(AND(L$205<=$I$9+$C$25-1,L$205>=$C$25,$I$11=\"Yes\"),CompressionService!G$6,0)","v":169711.23193359372},{"$f":"IF(AND(M$205<=$I$9+$C$25-1,M$205>=$C$25,$I$11=\"Yes\"),CompressionService!H$6,0)","v":173954.01273193356},{"$f":"IF(AND(N$205<=$I$9+$C$25-1,N$205>=$C$25,$I$11=\"Yes\"),CompressionService!I$6,0)","v":178302.86305023188},{"$f":"IF(AND(O$205<=$I$9+$C$25-1,O$205>=$C$25,$I$11=\"Yes\"),CompressionService!J$6,0)","v":182760.43462648767},{"$f":"IF(AND(P$205<=$I$9+$C$25-1,P$205>=$C$25,$I$11=\"Yes\"),CompressionService!K$6,0)","v":187329.44549214985},{"$f":"IF(AND(Q$205<=$I$9+$C$25-1,Q$205>=$C$25,$I$11=\"Yes\"),CompressionService!L$6,0)","v":0},{"$f":"IF(AND(R$205<=$I$9+$C$25-1,R$205>=$C$25,$I$11=\"Yes\"),CompressionService!M$6,0)","v":0},{"$f":"IF(AND(S$205<=$I$9+$C$25-1,S$205>=$C$25,$I$11=\"Yes\"),CompressionService!N$6,0)","v":0},{"$f":"IF(AND(T$205<=$I$9+$C$25-1,T$205>=$C$25,$I$11=\"Yes\"),CompressionService!O$6,0)","v":0},{"$f":"IF(AND(U$205<=$I$9+$C$25-1,U$205>=$C$25,$I$11=\"Yes\"),CompressionService!P$6,0)","v":0},{"$f":"IF(AND(V$205<=$I$9+$C$25-1,V$205>=$C$25,$I$11=\"Yes\"),CompressionService!Q$6,0)","v":0},{"$f":"IF(AND(W$205<=$I$9+$C$25-1,W$205>=$C$25,$I$11=\"Yes\"),CompressionService!R$6,0)","v":0},{"$f":"IF(AND(X$205<=$I$9+$C$25-1,X$205>=$C$25,$I$11=\"Yes\"),CompressionService!S$6,0)","v":0},{"$f":"IF(AND(Y$205<=$I$9+$C$25-1,Y$205>=$C$25,$I$11=\"Yes\"),CompressionService!T$6,0)","v":0},{"$f":"IF(AND(Z$205<=$I$9+$C$25-1,Z$205>=$C$25,$I$11=\"Yes\"),CompressionService!U$6,0)","v":0},{"$f":"IF(AND(AA$205<=$I$9+$C$25-1,AA$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AB$205<=$I$9+$C$25-1,AB$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AC$205<=$I$9+$C$25-1,AC$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AD$205<=$I$9+$C$25-1,AD$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AE$205<=$I$9+$C$25-1,AE$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AF$205<=$I$9+$C$25-1,AF$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AG$205<=$I$9+$C$25-1,AG$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AH$205<=$I$9+$C$25-1,AH$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AI$205<=$I$9+$C$25-1,AI$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AJ$205<=$I$9+$C$25-1,AJ$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AK$205<=$I$9+$C$25-1,AK$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AL$205<=$I$9+$C$25-1,AL$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AM$205<=$I$9+$C$25-1,AM$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AN$205<=$I$9+$C$25-1,AN$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AO$205<=$I$9+$C$25-1,AO$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AP$205<=$I$9+$C$25-1,AP$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AQ$205<=$I$9+$C$25-1,AQ$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AR$205<=$I$9+$C$25-1,AR$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AS$205<=$I$9+$C$25-1,AS$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0},{"$f":"IF(AND(AT$205<=$I$9+$C$25-1,AT$205>=$C$25,$I$11=\"Yes\"),CompressionService!#REF!,0)","v":0}]
[null,null,null,"TOTAL",null,null,{"$f":"SUM(G288:G295)","v":150000},153750,157593.75,161533.59375,165571.93359375,169711.23193359372,173954.01273193356,178302.86305023188,182760.43462648767,187329.44549214985,{"$f":"SUM(Q288:Q295)","v":0},{"$f":"SUM(R288:R295)","v":0},{"$f":"SUM(S288:S295)","v":0},{"$f":"SUM(T288:T295)","v":0},{"$f":"SUM(U288:U295)","v":0},{"$f":"SUM(V288:V294)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(AD288:AD294)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"CompressionService","index":1,"n_rows":127,"n_cols":26,"rows_kept":127,"cut":false,"hidden":false,"merged":[[38,9,38,12],[34,9,34,11],[35,9,35,12],[36,9,36,12],[37,9,37,12],[0,1,0,15],[19,8,20,13],[27,9,32,13],[24,9,24,11],[22,0,22,5],[18,0,18,13],[19,0,20,0],[19,1,20,1],[19,4,20,5],[19,2,20,3],[19,6,20,6],[15,3,16,3],[1,0,2,0],[1,1,2,1],[14,0,14,13],[15,8,16,13],[9,3,10,3],[10,4,11,5],[15,0,16,0],[15,4,16,5],[15,6,16,6],[15,1,16,1],[15,2,16,2]]}
["Version 02","Schedule 54 CNG Pricing Model - Calculation of CNG Contracted Volume Compression Charge and Incremental O&M Charge\n\nPlease enter inputs in the cells in Bold Green Font and click \"CALCULATE\" when done.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Print Row"]
[{"$f":"+FIA!E9","v":"EXPECTED YEARS OF REVENUE: (Years)"},15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,{"$f":"IF(AND(C$4<=$B$2,OR(C$8<=0)),\"Check Rate/Usage Info.\",\"\")","v":""},"","","","","","","","","","","","","",null,null,null,null,null,null,null,null,null,"Y"]
["REVENUE YEAR",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,null,null,null,null,null,null,null,null,null,"Y"]
["COMPRESSION STATION CAPITAL COST \n(As detailed in Exhibits B and D of Schdule 54 Service Agreement)",2500000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"Y"]
["ANNUAL STATION O&M COST\n(As detailed in Exhibits B and D of Schdule 54 Service Agreement)",150000,{"$f":"+B6*1.025","v":153750},{"$f":"+C6*1.025","v":157593.75},161533.59375,165571.93359375,169711.23193359372,173954.01273193356,178302.86305023188,182760.43462648767,187329.44549214985,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"Y"]
["TOTAL NO. OF VEHICLES",{"$f":"IF(B4<=$B$2,SUMIF($C$25:$C$126,\"<=\"&B4,$B$25:$B$126),\"\")","v":7},{"$f":"IF(C4<=$B$2,SUMIF($C$25:$C$126,\"<=\"&C4,$B$25:$B$126),\"\")","v":14},20,20,20,20,20,20,20,20,{"$f":"IF(L4<=$B$2,+SUMIFS($B$25:$B$126,$C$25:$C$126,\"<=\"&L4),\"\")","v":20},{"$f":"IF(M4<=$B$2,+SUMIFS($B$25:$B$126,$C$25:$C$126,\"<=\"&M4),\"\")","v":20},{"$f":"IF(N4<=$B$2,+SUMIFS($B$25:$B$126,$C$25:$C$126,\"<=\"&N4),\"\")","v":20},{"$f":"IF(O4<=$B$2,+SUMIFS($B$25:$B$126,$C$25:$C$126,\"<=\"&O4),\"\")","v":20},{"$f":"IF(P4<=$B$2,+SUMIFS($B$25:$B$126,$C$25:$C$126,\"<=\"&P4),\"\")","v":20},null,null,null,null,null,null,null,null,null,"Y"]
["ANNUAL FLEET USAGE (THERMS)",{"$f":"IF(B4<=$B$2,SUMIF($C$25:$C$126,\"<=\"&B4,$H$25:$H$126),\"\")","v":182695.03546099286},365390.07092198572,521985.81560283678,521985.81560283678,521985.81560283678,521985.81560283678,521985.81560283678,521985.81560283678,521985.81560283678,521985.81560283678,{"$f":"IF(L4<=$B$2,SUMIFS($H$25:$H$126,$C$25:$C$126,\"<=\"&L4),\"\")","v":521985.81560283678},{"$f":"IF(M4<=$B$2,SUMIFS($H$25:$H$126,$C$25:$C$126,\"<=\"&M4),\"\")","v":521985.81560283678},{"$f":"IF(N4<=$B$2,SUMIFS($H$25:$H$126,$C$25:$C$126,\"<=\"&N4),\"\")","v":521985.81560283678},{"$f":"IF(O4<=$B$2,SUMIFS($H$25:$H$126,$C$25:$C$126,\"<=\"&O4),\"\")","v":521985.81560283678},{"$f":"IF(P4<=$B$2,SUMIFS($H$25:$H$126,$C$25:$C$126,\"<=\"&P4),\"\")","v":521985.81560283678},null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[{"$f":"FIA!H13","v":"TARGET ROR"},{"$f":"+FIA!I13","v":7.7700000000000005E-2},null,"ROR W/ CNG CHARGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["   PROJECT ROR BEFORE COMPRESSION CHARGE",-0.21222122810623345,null,null,{"$f":"+IF(AND($D$13<>0,$D$13<>FIA!$C$271),\"Please recalculate!\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[{"$f":"UPPER(+FIA!B270)","v":"CNG FIXED CHARGE "},488445.46,null,7.7699565668839066E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[{"$f":"UPPER(+FIA!B272)","v":"CNG VOLUMETRIC CHARGE"},1.03871,null,7.7680234669242454E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["CONTRACTED VOLUME COMPRESSION CHARGE - CUSTOMER PAYMENT OPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[{"$f":"\"FIXED MONTHLY PAYMENT FOR \"&B2&\" YEARS\"","v":"FIXED MONTHLY PAYMENT FOR 15 YEARS"},"PER MONTH:",{"$f":"+B12/12","v":40703.788333333338},"OR ","PER THERM \nUP TO MONTHLY CONTRACTED VOLUME:",null,{"$f":"+B13","v":1.03871},null,"CONTRACTED VOLUME COMPRESSION CHARGE IS AN ADDITION TO OTHER CNG CHARGES AND THE NATURAL GAS DISTRIBUTION / TRANSPORTATION AND APPLICABLE COMMODITY CHARGES. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["INCREMENTAL O&M CHARGE ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["UNIT PRICE PER THERM",0.2,"WITH SALES AND REVENUE TAXES",null,"PER THERM\nFOR THERMS EXCEEDING THE MONTHLY CONTRACTED VOLUME",null,{"$f":"ROUND(+B20*(1+N38)*(1+N39),5)","v":0.2291},null,"INCREMENTAL O&M CHARGE IS AN ADDITION TO OTHER CNG SERVICE CHARGES AND THE NATURAL GAS SERVICE CHARGES. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["FLEET INFORMATION\n(As detailed in Exhibit A of Schdule 54 Service Agreement)",null,null,null,null,null,"Therms/DGE:",{"$f":"+M25","v":1.38},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Vehicle Type\ne.g. Delivery Truck - Class 7","No. of Vehicles","CNG Fueling Start Year","Vehicle CNG Mileage (mi/DGE)","Estimated Miles per Year","Annual CNG Use/Vehicle (DGE)","Total Annual CNG Use (DGE)","Total Annual CNG Use (therms)",null,"Fuel Energy Content",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Delivery Truck - Class 7",7,1,4.2300000000000004,80000,{"$f":"IF(ISNUMBER(D25),E25/D25,0)","v":18912.529550827421},{"$f":"B25*F25","v":132387.70685579194},{"$f":"G25*$H$23","v":182695.03546099286},null,"Therms per DGE:",null,null,1.38,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Delivery Truck - Class 7",7,2,4.2300000000000004,80000,{"$f":"IF(ISNUMBER(D26),E26/D26,0)","v":18912.529550827421},{"$f":"B26*F26","v":132387.70685579194},{"$f":"G26*$H$23","v":182695.03546099286},null,"Source:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
["Delivery Truck - Class 7",6,3,4.2300000000000004,80000,{"$f":"IF(ISNUMBER(D27),E27/D27,0)","v":18912.529550827421},{"$f":"B27*F27","v":113475.17730496453},{"$f":"G27*$H$23","v":156595.74468085103},null,"Heat Content for Diesel motor fuel 138,700 Btu/gal (gross)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(D28),E28/D28,0)","v":0},{"$f":"B28*F28","v":0},0,null,"Page B-5 of the Transportation Energy Data Book: Edition 32, Appendix B, prepared and published by Oak Ridge National Laboratory (ORNL) under contract with the U.S. Department of Energy, Office of Energy Efficiency and Renewable Energy, Vehicle Technologies Program. http://cta.ornl.gov/data/tedb32/Edition32_Appendix_B.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,"Notes and Definitions:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,"CNG: Compressed Natural Gas ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,"DGE: Diesel Gallon Equivalent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,"Sales Tax: City of Bellevue",null,null,null,9.5000000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,"Effective State Revenue Related Taxes:",null,null,null,{"$f":"+FIA!C211","v":4.6135000000000002E-2},null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H45>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H46>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H47>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H48>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H49>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H50>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,{"$f":"G57*$H$23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(D65),E65/D65,0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,{"$f":"G89*$H$23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,{"$f":"B90*F90","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,{"$f":"IF(ISNUMBER(D97),E97/D97,0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H114>0,\"Y\",\"N\")","v":"N"}]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,{"$f":"G121*$H$23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]

{"sheet":"Therms","index":2,"n_rows":269,"n_cols":10,"rows_kept":269,"cut":false,"hidden":true,"merged":[[0,0,0,8],[6,0,6,7],[35,0,35,7],[62,0,62,7],[18,0,18,7],[27,0,27,7],[28,1,28,7],[31,0,31,7],[32,1,32,7]]}
["CONSUMPTION ESTIMATES"]
["CUSTOMER GROUP NO.",{"$f":"+FIA!C21","v":1},{"$f":"+FIA!D21","v":2},{"$f":"+FIA!E21","v":3},{"$f":"+FIA!F21","v":4},{"$f":"+FIA!G21","v":5},{"$f":"+FIA!H21","v":6},{"$f":"+FIA!I21","v":7}]
[{"$f":"+FIA!B20","v":"CUSTOMER GROUP DESCRIPTION:"},{"$f":"IF(+FIA!C20=0,\"\",+FIA!C20)","v":""},{"$f":"IF(+FIA!D20=0,\"\",+FIA!D20)","v":""},{"$f":"IF(+FIA!E20=0,\"\",+FIA!E20)","v":""},{"$f":"IF(+FIA!F20=0,\"\",+FIA!F20)","v":""},{"$f":"IF(+FIA!G20=0,\"\",+FIA!G20)","v":""},{"$f":"IF(+FIA!H20=0,\"\",+FIA!H20)","v":""},{"$f":"IF(+FIA!I20=0,\"\",+FIA!I20)","v":""}]
[{"$f":"+FIA!B19","v":"CUSTOMER GROUP STRUCTURE TYPE:"},{"$f":"+FIA!C19","v":0},{"$f":"+FIA!D19","v":0},{"$f":"+FIA!E19","v":0},{"$f":"+FIA!F19","v":0},{"$f":"+FIA!G19","v":0},{"$f":"+FIA!H19","v":0},{"$f":"+FIA!I19","v":0}]
[{"$f":"+FIA!B23","v":"NO. OF CUSTOMER/S"},{"$f":"+FIA!C23","v":1},{"$f":"+FIA!D23","v":0},{"$f":"+FIA!E23","v":0},{"$f":"+FIA!F23","v":0},{"$f":"+FIA!G23","v":0},{"$f":"+FIA!H23","v":0},{"$f":"+FIA!I23","v":0}]
["NO. OF RESIDENCIAL CUSTOMERS",{"$f":"IF(OR(FIA!C$19=FIA!$AM$5,FIA!C$19=FIA!$AM$4,FIA!C$19=FIA!$AM$6),+FIA!C23,0)","v":0},{"$f":"IF(OR(FIA!D$19=FIA!$AM$5,FIA!D$19=FIA!$AM$4,FIA!D$19=FIA!$AM$6),+FIA!D23,0)","v":0},{"$f":"IF(OR(FIA!E$19=FIA!$AM$5,FIA!E$19=FIA!$AM$4,FIA!E$19=FIA!$AM$6),+FIA!E23,0)","v":0},{"$f":"IF(OR(FIA!F$19=FIA!$AM$5,FIA!F$19=FIA!$AM$4,FIA!F$19=FIA!$AM$6),+FIA!F23,0)","v":0},{"$f":"IF(OR(FIA!G$19=FIA!$AM$5,FIA!G$19=FIA!$AM$4,FIA!G$19=FIA!$AM$6),+FIA!G23,0)","v":0},{"$f":"IF(OR(FIA!H$19=FIA!$AM$5,FIA!H$19=FIA!$AM$4,FIA!H$19=FIA!$AM$6),+FIA!H23,0)","v":0},{"$f":"IF(OR(FIA!I$19=FIA!$AM$5,FIA!I$19=FIA!$AM$4,FIA!I$19=FIA!$AM$6),+FIA!I23,0)","v":0}]
["GAS LOADS - SINGLE-FAMILY RESIDENCES"]
["INPUT AREA"]
["AVERAGE SQ FOOTAGE OF SINGLE-FAMILY DWELLING BEING REPRESENTED BY THIS COLUMN",0,0,0,0,0,0,0]
["MULTI-FAMILY UNITS METER MANIFOLD ID"]
["SQUARE FOOTAGE OF MULTIFAMILY DWELLING BEING REPRESENTED BY THIS COLUMN",0,0,0,0,0,0,0]
["GAS SPACE HEATING","No","No","No","No","No","No","No"]
["GAS HOT WATER","No","No","No","No","No","No","No"]
["WITH LAUNDRY (MULTI-FAMILY ONLY)","No","No","No","No","No","No","No"]
["GAS COOKING","No","No","No","No","No","No","No"]
["GAS DRYER","No","No","No","No","No","No","No"]
["GAS FIREPLACE","No","No","No","No","No","No","No"]
["GAS HOT TUB","No","No","No","No","No","No","No"]
[" CALCULATED THERMS/PER YEAR"]
["GAS SPACE HEATING",{"$f":"IF(AND(B12=\"Yes\",OR(FIA!C$19=FIA!$AM$5,FIA!C$19=FIA!$AM$4),B6>0),VLOOKUP(B9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(C12=\"Yes\",OR(FIA!D$19=FIA!$AM$5,FIA!D$19=FIA!$AM$4),C6>0),VLOOKUP(C9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(D12=\"Yes\",OR(FIA!E$19=FIA!$AM$5,FIA!E$19=FIA!$AM$4),D6>0),VLOOKUP(D9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(E12=\"Yes\",OR(FIA!F$19=FIA!$AM$5,FIA!F$19=FIA!$AM$4),E6>0),VLOOKUP(E9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(F12=\"Yes\",OR(FIA!G$19=FIA!$AM$5,FIA!G$19=FIA!$AM$4),F6>0),VLOOKUP(F9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(G12=\"Yes\",OR(FIA!H$19=FIA!$AM$5,FIA!H$19=FIA!$AM$4),G6>0),VLOOKUP(G9,Therms!$A$119:$C$269,3,TRUE),0)","v":0},{"$f":"IF(AND(H12=\"Yes\",OR(FIA!I$19=FIA!$AM$5,FIA!I$19=FIA!$AM$4),H6>0),VLOOKUP(H9,Therms!$A$119:$C$269,3,TRUE),0)","v":0}]
["GAS HOT WATER",{"$f":"IF(AND(B6>0,B13=\"Yes\",OR(FIA!$AM$5=FIA!C$19,FIA!C$19=FIA!$AM$4)),Therms!$B$110,0)","v":0},{"$f":"IF(OR(C6=0,C13=\"No\"),0,IF(C13=\"Yes\",IF(OR(FIA!$AM$5=FIA!D$19,FIA!D$19=FIA!$AM$4),Therms!$B$110,IF(C14=\"Yes\",$F$121,$F$122)),0))","v":0},{"$f":"IF(OR(D6=0,D13=\"No\"),0,IF(D13=\"Yes\",IF(OR(FIA!$AM$5=FIA!E$19,FIA!E$19=FIA!$AM$4),Therms!$B$110,IF(D14=\"Yes\",$F$121,$F$122)),0))","v":0},{"$f":"IF(OR(E6=0,E13=\"No\"),0,IF(E13=\"Yes\",IF(OR(FIA!$AM$5=FIA!F$19,FIA!F$19=FIA!$AM$4),Therms!$B$110,IF(E14=\"Yes\",$F$121,$F$122)),0))","v":0},{"$f":"IF(OR(F6=0,F13=\"No\"),0,IF(F13=\"Yes\",IF(OR(FIA!$AM$5=FIA!G$19,FIA!G$19=FIA!$AM$4),Therms!$B$110,IF(F14=\"Yes\",$F$121,$F$122)),0))","v":0},{"$f":"IF(OR(G6=0,G13=\"No\"),0,IF(G13=\"Yes\",IF(OR(FIA!$AM$5=FIA!H$19,FIA!H$19=FIA!$AM$4),Therms!$B$110,IF(G14=\"Yes\",$F$121,$F$122)),0))","v":0},{"$f":"IF(OR(H6=0,H13=\"No\"),0,IF(H13=\"Yes\",IF(OR(FIA!$AM$5=FIA!I$19,FIA!I$19=FIA!$AM$4),Therms!$B$110,IF(H14=\"Yes\",$F$121,$F$122)),0))","v":0}]
["GAS COOKING",{"$f":"IF(AND(B6>0,B15=\"Yes\",OR(FIA!$AM$5=FIA!C$19,FIA!C$19=FIA!$AM$4)),Therms!$B$113,0)","v":0},{"$f":"IF(OR(C6=0,C15=\"No\"),0,IF(C15=\"Yes\",Therms!$B$113,0))","v":0},{"$f":"IF(OR(D6=0,D15=\"No\"),0,IF(D15=\"Yes\",Therms!$B$113,0))","v":0},{"$f":"IF(OR(E6=0,E15=\"No\"),0,IF(E15=\"Yes\",Therms!$B$113,0))","v":0},{"$f":"IF(OR(F6=0,F15=\"No\"),0,IF(F15=\"Yes\",Therms!$B$113,0))","v":0},{"$f":"IF(OR(G6=0,G15=\"No\"),0,IF(G15=\"Yes\",Therms!$B$113,0))","v":0},{"$f":"IF(OR(H6=0,H15=\"No\"),0,IF(H15=\"Yes\",Therms!$B$113,0))","v":0}]
["GAS DRYER",{"$f":"IF(AND(B6>0,B16=\"Yes\",OR(FIA!$AM$5=FIA!C$19,FIA!C$19=FIA!$AM$4)),Therms!$B$112,0)","v":0},{"$f":"IF(OR(C6=0,C16=\"No\"),0,IF(C16=\"Yes\",Therms!$B$112,0))","v":0},{"$f":"IF(OR(D6=0,D16=\"No\"),0,IF(D16=\"Yes\",Therms!$B$112,0))","v":0},{"$f":"IF(OR(E6=0,E16=\"No\"),0,IF(E16=\"Yes\",Therms!$B$112,0))","v":0},{"$f":"IF(OR(F6=0,F16=\"No\"),0,IF(F16=\"Yes\",Therms!$B$112,0))","v":0},{"$f":"IF(OR(G6=0,G16=\"No\"),0,IF(G16=\"Yes\",Therms!$B$112,0))","v":0},{"$f":"IF(OR(H6=0,H16=\"No\"),0,IF(H16=\"Yes\",Therms!$B$112,0))","v":0}]
["GAS FIREPLACE",{"$f":"IF(AND(B6>0,B17=\"Yes\",OR(FIA!$AM$5=FIA!C$19,FIA!C$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(C6>0,C17=\"Yes\",OR(FIA!$AM$5=FIA!D$19,FIA!D$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(D6>0,D17=\"Yes\",OR(FIA!$AM$5=FIA!E$19,FIA!E$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(E6>0,E17=\"Yes\",OR(FIA!$AM$5=FIA!F$19,FIA!F$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(F6>0,F17=\"Yes\",OR(FIA!$AM$5=FIA!G$19,FIA!G$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(G6>0,G17=\"Yes\",OR(FIA!$AM$5=FIA!H$19,FIA!H$19=FIA!$AM$4)),Therms!$B$114,0)","v":0},{"$f":"IF(AND(H6>0,H17=\"Yes\",OR(FIA!$AM$5=FIA!I$19,FIA!I$19=FIA!$AM$4)),Therms!$B$114,0)","v":0}]
["GAS HOT TUB",{"$f":"IF(AND(B6>0,B18=\"Yes\",OR(FIA!$AM$5=FIA!C$19,FIA!C$19=FIA!$AM$4)),Therms!$B$111,0)","v":0},{"$f":"IF(OR(C6=0,C18=\"No\"),0,IF(C18=\"Yes\",Therms!$B$111,0))","v":0},{"$f":"IF(OR(D6=0,D18=\"No\"),0,IF(D18=\"Yes\",Therms!$B$111,0))","v":0},{"$f":"IF(OR(E6=0,E18=\"No\"),0,IF(E18=\"Yes\",Therms!$B$111,0))","v":0},{"$f":"IF(OR(F6=0,F18=\"No\"),0,IF(F18=\"Yes\",Therms!$B$111,0))","v":0},{"$f":"IF(OR(G6=0,G18=\"No\"),0,IF(G18=\"Yes\",Therms!$B$111,0))","v":0},{"$f":"IF(OR(H6=0,H18=\"No\"),0,IF(H18=\"Yes\",Therms!$B$111,0))","v":0}]
["THERMS/YR PER RESIDENTIAL UNIT",{"$f":"IF(OR(FIA!C$19=FIA!$AM$5,FIA!C$19=FIA!$AM$4),+SUM(B19:B25),0)","v":0},{"$f":"IF(OR(FIA!D$19=FIA!$AM$5,FIA!D$19=FIA!$AM$4),+SUM(C19:C25),0)","v":0},{"$f":"IF(OR(FIA!E$19=FIA!$AM$5,FIA!E$19=FIA!$AM$4),+SUM(D19:D25),0)","v":0},{"$f":"IF(OR(FIA!F$19=FIA!$AM$5,FIA!F$19=FIA!$AM$4),+SUM(E19:E25),0)","v":0},{"$f":"IF(OR(FIA!G$19=FIA!$AM$5,FIA!G$19=FIA!$AM$4),+SUM(F19:F25),0)","v":0},{"$f":"IF(OR(FIA!H$19=FIA!$AM$5,FIA!H$19=FIA!$AM$4),+SUM(G19:G25),0)","v":0},{"$f":"IF(OR(FIA!I$19=FIA!$AM$5,FIA!I$19=FIA!$AM$4),+SUM(H19:H25),0)","v":0}]
[]
["GAS LOADS - INDIVIDUAL METERED MULTI-FAMILY DWELLINGS"]
[]
["ADDITIONAL THERMS/YR PER CUSTOMER",0,0,0,0,0,0,0]
[]
["ADDED LOAD FOR FACILITY MODIFICATION FOR EXISTING GAS CUSTOMER w/ SCHEDULE 7 VOLUME ALLOWANCE"]
[null,{"$f":"IF(FIA!$I$6=\"No\",\"NOT APPLICABLE\",\"\")","v":"NOT APPLICABLE"}]
["ADDITIONAL THERMS/YR PER CUSTOMER",0,0,0,0,0,0,0]
[]
["GAS LOADS - COMMERCIAL OR INDUSTRIAL OR MASTER METERED MULTI-FAMILY DWELLINGS 5 UNITS AND UP"]
[null,"The loads will be estimated on a case-by-case basis."]
["NAICS CODE","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX"]
["EQUIPMENT (1) LOCATION","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX"]
["CONNECTED LOAD (cfh)",0,0,0,0,0,0,0]
["LOAD MULTIPLIER",0,0,0,0,0,0,0]
["EQUIPMENT (1) THERMS",{"$f":"+B40*B41","v":0},{"$f":"+C40*C41","v":0},0,0,0,0,0]
["EQUIPMENT (2) LOCATION","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX"]
["CONNECTED LOAD (cfh)",0,0,0,0,0,0,0]
["LOAD MULTIPLIER",0,0,0,0,0,0,0]
["EQUIPMENT (2) THERMS",{"$f":"+B44*B45","v":0},{"$f":"+C44*C45","v":0},0,0,0,0,0]
["EQUIPMENT (3) LOCATION","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX"]
["CONNECTED LOAD (cfh)",0,0,0,0,0,0,0]
["LOAD MULTIPLIER",0,0,0,0,0,0,0]
["EQUIPMENT (3) THERMS",{"$f":"+B48*B49","v":0},{"$f":"+C48*C49","v":0},0,0,0,0,0]
["EQUIPMENT (4) LOCATION","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX","XXXX"]
["CONNECTED LOAD (cfh)",0,0,0,0,0,0,0]
["LOAD MULTIPLIER",0,0,0,0,0,0,0]
["EQUIPMENT (4) THERMS",{"$f":"+B52*B53","v":0},{"$f":"+C52*C53","v":0},0,0,0,0,0]
["TOTAL THERMS/YR PER COMMERCIAL/INDUSTRIAL CUSTOMER",{"$f":"IF(OR(FIA!C$19=FIA!$AM$7,FIA!C$19=FIA!$AM$8,FIA!C$19=FIA!$AM$9),+B42+B46+B50+B54,0)","v":0},{"$f":"IF(OR(FIA!D$19=FIA!$AM$7,FIA!D$19=FIA!$AM$8,FIA!D$19=FIA!$AM$9),+C42+C46+C50+C54,0)","v":0},{"$f":"IF(OR(FIA!E$19=FIA!$AM$7,FIA!E$19=FIA!$AM$8,FIA!E$19=FIA!$AM$9),+D42+D46+D50+D54,0)","v":0},{"$f":"IF(OR(FIA!F$19=FIA!$AM$7,FIA!F$19=FIA!$AM$8,FIA!F$19=FIA!$AM$9),+E42+E46+E50+E54,0)","v":0},{"$f":"IF(OR(FIA!G$19=FIA!$AM$7,FIA!G$19=FIA!$AM$8,FIA!G$19=FIA!$AM$9),+F42+F46+F50+F54,0)","v":0},{"$f":"IF(OR(FIA!H$19=FIA!$AM$7,FIA!H$19=FIA!$AM$8,FIA!H$19=FIA!$AM$9),+G42+G46+G50+G54,0)","v":0},{"$f":"IF(OR(FIA!I$19=FIA!$AM$7,FIA!I$19=FIA!$AM$8,FIA!I$19=FIA!$AM$9),+H42+H46+H50+H54,0)","v":0}]
[]
[]
[]
["TOTAL THERMS PER YEAR PER CUSTOMER",{"$f":"ROUND(B34+B26+B55+B64+B30,0)","v":0},0,0,0,0,0,0]
[]
[]
[]
["RULE 7 REVIEW ONLY                                                            RULE 7 REVIEW ONLY                                                            RULE 7 REVIEW ONLY"]
["GAS LOADS",0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"+B2","v":1},2,3,4,5,6,7]
[null,null,null,{"$f":"+B3","v":""},{"$f":"+C3","v":""},"","","","",""]
[null,null,null,{"$f":"+B4&B10","v":"0"},"0","0","0","0","0","0"]
[{"$f":"+A7","v":"GAS LOADS - SINGLE-FAMILY RESIDENCES"},null,null,null,{"$f":"+A28","v":"GAS LOADS - INDIVIDUAL METERED MULTI-FAMILY DWELLINGS"},{"$f":"+FIA!AM6","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)"},{"$f":"+A6","v":"NO. OF RESIDENCIAL CUSTOMERS"},{"$f":"+A11","v":"SQUARE FOOTAGE OF MULTIFAMILY DWELLING BEING REPRESENTED BY THIS COLUMN"},"TOTAL THERMS","PER UNIT"]
[null,null,null,null,{"$f":"+$F$98&F99","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)MANIFOLD NO. 1"},"MANIFOLD NO. 1",{"$f":"+SUMIF($D$97:$J$97,E99,$B$6:$H$6)","v":0},{"$f":"+SUMIF($D$97:$J$97,E99,$B$11:$H$11)","v":0},{"$f":"+IF(AND(G99>0,H99>0),IF(G99<=4,VLOOKUP(H99,Therms!$A$119:$C$269,3,TRUE),H99*$F$119),0)","v":0},{"$f":"IF(I99>0,+I99/G99,0)","v":0}]
[null,null,null,null,{"$f":"+$F$98&F100","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)MANIFOLD NO. 2"},"MANIFOLD NO. 2",{"$f":"+SUMIF($D$97:$J$97,E100,$B$6:$H$6)","v":0},{"$f":"+SUMIF($D$97:$J$97,E100,$B$11:$H$11)","v":0},{"$f":"+IF(AND(G100>0,H100>0),IF(G100<=4,VLOOKUP(H100,Therms!$A$119:$C$269,3,TRUE),H100*$F$119),0)","v":0},{"$f":"IF(I100>0,+I100/G100,0)","v":0}]
[null,null,null,null,{"$f":"+$F$98&F101","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)MANIFOLD NO. 3"},"MANIFOLD NO. 3",{"$f":"+SUMIF($D$97:$J$97,E101,$B$6:$H$6)","v":0},{"$f":"+SUMIF($D$97:$J$97,E101,$B$11:$H$11)","v":0},{"$f":"+IF(AND(G101>0,H101>0),IF(G101<=4,VLOOKUP(H101,Therms!$A$119:$C$269,3,TRUE),H101*$F$119),0)","v":0},{"$f":"IF(I101>0,+I101/G101,0)","v":0}]
["YES/NO",null,null,null,{"$f":"+$F$98&F102","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)MANIFOLD NO. 4"},"MANIFOLD NO. 4",{"$f":"+SUMIF($D$97:$J$97,E102,$B$6:$H$6)","v":0},{"$f":"+SUMIF($D$97:$J$97,E102,$B$11:$H$11)","v":0},{"$f":"+IF(AND(G102>0,H102>0),IF(G102<=4,VLOOKUP(H102,Therms!$A$119:$C$269,3,TRUE),H102*$F$119),0)","v":0},{"$f":"IF(I102>0,+I102/G102,0)","v":0}]
["Yes",null,null,null,{"$f":"+$F$98&F103","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)MANIFOLD NO. 5"},"MANIFOLD NO. 5",{"$f":"+SUMIF($D$97:$J$97,E103,$B$6:$H$6)","v":0},{"$f":"+SUMIF($D$97:$J$97,E103,$B$11:$H$11)","v":0},{"$f":"+IF(AND(G103>0,H103>0),IF(G103<=4,VLOOKUP(H103,Therms!$A$119:$C$269,3,TRUE),H103*$F$119),0)","v":0},{"$f":"IF(I103>0,+I103/G103,0)","v":0}]
["No"]
[]
[]
[]
["LOOKUP TABLE 1 - APPLIANCE THERMS"]
["APPLIANCE","THERMS"]
["Water Heater",224]
["Hot Tub",100]
["Dryer",50]
["Range",72]
["Fireplace",77]
[]
["LOOKUP TABLE 2 - Furnace Therms"]
["At Least","Less Than","Annual"]
["sqft","sqft","therms",null,{"$f":"+F98","v":"Multi-Family Dwellings - (2+ Units, Individual Metered)"}]
[0,500,181,null,"Space Heating",0.26,"therms/sq.ft./year"]
[{"$f":"+B119+1","v":501},{"$f":"+B119+100","v":600},217,null,"Water Heating"]
[601,700,254,null,"with Laundry",182,"therms/per unit/year"]
[701,800,290,null,"without Laundry",152,"therms/per unit/year"]
[801,900,326]
[901,1000,362]
[1001,1100,399]
[1101,1200,435]
[1201,1300,471]
[1301,1400,507]
[1401,1500,544]
[1501,1600,553]
[1601,1700,563]
[1701,1800,573]
[1801,1900,583]
[1901,2000,592]
[2001,2100,602]
[2101,2200,612]
[2201,2300,622]
[2301,2400,631]
[2401,2500,641]
[2501,2600,651]
[2601,2700,661]
[2701,2800,671]
[2801,2900,680]
[2901,3000,690]
[3001,3100,700]
[3101,3200,710]
[3201,3300,719]
[3301,3400,729]
[3401,3500,739]
[3501,3600,749]
[3601,3700,758]
[{"$f":"+B151+1","v":3701},{"$f":"+B151+100","v":3800},768]
[3801,3900,778]
[3901,4000,788]
[4001,4100,798]
[4101,4200,807]
[4201,4300,817]
[4301,4400,827]
[4401,4500,837]
[4501,4600,846]
[4601,4700,856]
[4701,4800,866]
[4801,4900,876]
[4901,5000,885]
[5001,5100,{"$f":"C164+8","v":893}]
[5101,5200,{"$f":"C165+8","v":901}]
[5201,5300,909]
[5301,5400,917]
[5401,5500,925]
[5501,5600,933]
[5601,5700,941]
[5701,5800,949]
[5801,5900,957]
[5901,6000,965]
[6001,6100,973]
[6101,6200,981]
[6201,6300,989]
[6301,6400,997]
[6401,6500,1005]
[6501,6600,1013]
[6601,6700,1021]
[6701,6800,1029]
[6801,6900,1037]
[{"$f":"+B183+1","v":6901},{"$f":"+B183+100","v":7000},1045]
[7001,7100,1053]
[7101,7200,1061]
[7201,7300,1069]
[7301,7400,1077]
[7401,7500,1085]
[7501,7600,1093]
[7601,7700,1101]
[7701,7800,1109]
[7801,7900,1117]
[7901,8000,1125]
[8001,8100,1133]
[8101,8200,1141]
[8201,8300,1149]
[8301,8400,1157]
[8401,8500,1165]
[8501,8600,1173]
[8601,{"$f":"+B200+100","v":8700},{"$f":"C200+8","v":1181}]
[8701,{"$f":"+B201+100","v":8800},{"$f":"C201+8","v":1189}]
[8801,8900,1197]
[8901,9000,1205]
[9001,9100,1213]
[9101,9200,1221]
[9201,9300,1229]
[9301,9400,1237]
[9401,9500,1245]
[9501,9600,1253]
[9601,9700,1261]
[9701,9800,1269]
[9801,9900,1277]
[9901,10000,1285]
[10001,10100,1293]
[10101,10200,1301]
[10201,10300,1309]
[10301,10400,1317]
[10401,10500,1325]
[10501,10600,1333]
[10601,10700,1341]
[10701,10800,1349]
[10801,10900,1357]
[10901,11000,1365]
[11001,11100,1373]
[11101,11200,1381]
[11201,11300,1389]
[11301,11400,1397]
[11401,11500,1405]
[11501,11600,1413]
[11601,11700,1421]
[11701,11800,1429]
[11801,11900,1437]
[11901,12000,1445]
[12001,12100,1453]
[12101,12200,1461]
[12201,12300,1469]
[12301,12400,1477]
[12401,12500,1485]
[12501,12600,1493]
[12601,12700,1501]
[12701,12800,1509]
[12801,12900,1517]
[12901,13000,1525]
[13001,13100,1533]
[13101,13200,1541]
[13201,13300,1549]
[{"$f":"+B247+1","v":13301},13400,1557]
[13401,13500,1565]
[13501,13600,1573]
[13601,13700,1581]
[13701,13800,1589]
[13801,13900,1597]
[13901,14000,1605]
[14001,14100,1613]
[14101,14200,1621]
[14201,14300,1629]
[14301,14400,1637]
[14401,14500,1645]
[14501,14600,1653]
[14601,14700,1661]
[14701,14800,1669]
[14801,14900,1677]
[14901,15000,1685]
[15001,15100,1693]
[15101,{"$f":"+B265+100","v":15200},{"$f":"C265+8","v":1701}]
[15201,{"$f":"+B266+100","v":15300},{"$f":"C266+8","v":1709}]
[15301,{"$f":"+B267+100","v":15400},{"$f":"C267+8","v":1717}]
[15401,{"$f":"+B268+100","v":15500},{"$f":"C268+8","v":1725}]

{"sheet":"ConstructionCosts","index":3,"n_rows":190,"n_cols":11,"rows_kept":190,"cut":false,"hidden":true,"merged":[[0,1,0,3],[6,0,10,0],[11,0,17,0],[29,1,29,8],[18,0,19,0],[20,0,28,0],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[110,1,110,2],[111,1,111,2],[20,2,20,8],[39,1,39,8],[156,1,156,3],[112,1,112,2],[113,1,113,2],[119,1,119,2],[120,1,120,2],[114,3,114,4]]}
[null,"STANDARD AND NON-STANDARD COSTS  ESTIMATES"]
["CUSTOMER GROUP NO.",null,{"$f":"+FIA!C21","v":1},{"$f":"+FIA!D21","v":2},{"$f":"+FIA!E21","v":3},{"$f":"+FIA!F21","v":4},{"$f":"+FIA!G21","v":5},{"$f":"+FIA!H21","v":6},{"$f":"+FIA!I21","v":7}]
[{"$f":"+FIA!B20","v":"CUSTOMER GROUP DESCRIPTION:"},null,{"$f":"IF(+FIA!C20=0,\"\",+FIA!C20)","v":""},{"$f":"IF(+FIA!D20=0,\"\",+FIA!D20)","v":""},{"$f":"IF(+FIA!E20=0,\"\",+FIA!E20)","v":""},{"$f":"IF(+FIA!F20=0,\"\",+FIA!F20)","v":""},{"$f":"IF(+FIA!G20=0,\"\",+FIA!G20)","v":""},{"$f":"IF(+FIA!H20=0,\"\",+FIA!H20)","v":""},{"$f":"IF(+FIA!I20=0,\"\",+FIA!I20)","v":""}]
[{"$f":"+FIA!B19","v":"CUSTOMER GROUP STRUCTURE TYPE:"},null,{"$f":"IF(+FIA!C19=0,\"\",+FIA!C19)","v":""},{"$f":"IF(+FIA!D19=0,\"\",+FIA!D19)","v":""},{"$f":"IF(+FIA!E19=0,\"\",+FIA!E19)","v":""},{"$f":"IF(+FIA!F19=0,\"\",+FIA!F19)","v":""},{"$f":"IF(+FIA!G19=0,\"\",+FIA!G19)","v":""},{"$f":"IF(+FIA!H19=0,\"\",+FIA!H19)","v":""},{"$f":"IF(+FIA!I19=0,\"\",+FIA!I19)","v":""}]
[{"$f":"+FIA!B22","v":"RATE SCHEDULE:"},null,{"$f":"IF(+FIA!C22=0,\"\",+FIA!C22)","v":""},{"$f":"IF(+FIA!D22=0,\"\",+FIA!D22)","v":""},{"$f":"IF(+FIA!E22=0,\"\",+FIA!E22)","v":""},{"$f":"IF(+FIA!F22=0,\"\",+FIA!F22)","v":""},{"$f":"IF(+FIA!G22=0,\"\",+FIA!G22)","v":""},{"$f":"IF(+FIA!H22=0,\"\",+FIA!H22)","v":""},{"$f":"IF(+FIA!I22=0,\"\",+FIA!I22)","v":""}]
[null,"INPUT AREA"]
["GAS MAIN","GAS MAIN (1)\n(UP TO 4\" PE)","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"LENGTH OF THE MAIN (FT)",0,0,0,0,0,0,0]
[null,"GAS MAIN (2)\n(UP TO 4\" PE)","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"LENGTH OF THE MAIN (FT)",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD MAIN CONSTRUCTION COSTS",0,0,0,0,0,0,0]
["GAS SERVICE","GAS SERVICE (1)\nRESIDENTIAL: ANY SIZE PE SERVICE\nCOMMERCIAL: UP TO 4\" PE IN SIZE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"LENGTH OF THE SERVICE (FT)",0,0,0,0,0,0,0]
[null,"GAS SERVICE (2)\nRESIDENTIAL: ANY SIZE PE SERVICE\nCOMMERCIAL: UP TO 4\" PE IN SIZE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"LENGTH OF THE SERVICE (FT)",0,0,0,0,0,0,0]
[null,"GAS SERVICE (3)\nRESIDENTIAL: ANY SIZE PE SERVICE\nCOMMERCIAL: UP TO 4\" PE IN SIZE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"LENGTH OF THE SERVICE (FT)",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD SERVICE CONSTRUCTION COSTS",0,0,0,0,0,0,0]
["MSA","METER SET ASSEMBLY","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"SITE-SPECIFIC, NON-STANDARD MSA CONSTRUCTION COSTS",0,0,0,0,0,0,0]
["OTHER PLANT","NOTES ABOUT OTHER PLANT"]
[null,"RESIDENTIAL METER RELOCATION","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE","NOT APPLICABLE"]
[null,"TOTAL LENGTH OF THE RESIDENTIAL RELOCATION (FT)",0,0,0,0,0,0,0]
[null,"COMMERCIAL METER RELOCATION ESTIMATED COSTS",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD PERMITS",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD EASEMENTS",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD PAVING",0,0,0,0,0,0,0]
[null,"LOCAL GOVERNMENT RELATED ADDITIONAL COSTS",0,0,0,0,0,0,0]
[null,"SITE-SPECIFIC, NON-STANDARD OTHER CONSTRUCTION COSTS",0,0,0,0,0,0,0]
[null," CALCULATED CONSTRUCTION COSTS"]
[null,{"$f":"+FIA!B26","v":"MAIN COST:"},{"$f":"OFFSET($C$115,MATCH(C$7,$B$116:$B$118,0),0)*C$8+OFFSET($C$115,MATCH(C$9,$B$116:$B$118,0),0)*C$10+C11+C41","v":0},0,0,0,0,0,0]
[null,{"$f":"+FIA!B27","v":"SERVICE COST/CUST:"},{"$f":"OFFSET($C$121,MATCH(C$12,$B$122:$B$129,0),0)+OFFSET($C$121,MATCH(C$14,$B$122:$B$129,0),0)+OFFSET($C$121,MATCH(C$16,$B$122:$B$129,0),0)+OFFSET($D$121,MATCH(C$12,$B$122:$B$129,0),0)*C$13+OFFSET($D$121,MATCH(C$14,$B$122:$B$129,0),0)*C$15+OFFSET($D$121,MATCH(C$16,$B$122:$B$129,0),0)*C$17+C$18+C42","v":0},0,0,0,0,0,0]
[null,{"$f":"+FIA!B28","v":"MSA COST/CUST:"},{"$f":"OFFSET($C$132,MATCH(C$19,$B$133:$B$153,0),0)+C20+C43","v":0},0,0,0,0,0,0]
[null,{"$f":"+FIA!B29","v":"OTHER PLANT:"},{"$f":"MIN(OFFSET($C$158,MATCH(C$22,$B$159:$B$162,0),0)+OFFSET($C$158,MATCH(C$22,$B$159:$B$162,0),1)*MAX(C23-25,0),$C$163)+SUM(C25:C29,C24)+C44","v":0},0,0,0,0,0,0]
[null,"TOTAL CONSTRUCTION COSTS",{"$f":"+SUM(C31:C34)","v":0},0,0,0,0,0,0]
[]
[]
[]
[]
[null,"RULE 7 REVIEW ONLY                                                            RULE 7 REVIEW ONLY                                                            RULE 7 REVIEW ONLY"]
[null,"MAIN COST:",0,0,0,0,0,0,0]
[null,"SERVICE COST/CUST:",0,0,0,0,0,0,0]
[null,"MSA COST/CUST:",0,0,0,0,0,0,0]
[null,"OTHER PLANT:",0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["YES/NO"]
["Yes"]
["No"]
[]
[]
[]
[]
[]
[]
[]
[null,"LOOKUP TABLE 3 - Rule 7 Justification Estimates"]
[null,"Facility Type",null,null,null,null,"Effective 1/1/09","Effective 1/1/10"]
[]
[null,{"$f":"+B7","v":"GAS MAIN (1)\n(UP TO 4\" PE)"},null,null,null,"Facility Type","Base Cost","Cost per foot","Base Cost","Cost per foot"]
[null,null,"Cost per foot","Schedule 7 Section 5: Standard Costs \nEffecitve 9/1/06",null,1,"Gas Main (up to 4” PE in size)"]
[null,"PSE PROVIDED TRENCH FOR GAS ONLY\nEnter Applicable length Below",42.78,null,null,null,"With Company provided trench for gas only–",null,46.32,null,42.78]
[null,"CUSTOMER PROVIDED TRENCH\nEnter Applicable length Below",15.29,null,null,null,"With Customer provided trench–(*)",null,15.93,null,15.29]
[null,"NOT APPLICABLE",0,null,null,2,"Gas Service"]
[null,null,null,null,null,"a.","Residential Gas Service (any size PE service)"]
[null,{"$f":"+B12","v":"GAS SERVICE (1)\nRESIDENTIAL: ANY SIZE PE SERVICE\nCOMMERCIAL: UP TO 4\" PE IN SIZE"},null,null,null,null,"With Company provided trench for stub and service extension or from existing stub for service extension to meter location.",3242,null,3479]
[null,"Residential Gas SVC",null,null,null,null,"With Company provided trench for stub; Customer provided trench or conduit for service extension from stub to meter location.",2228,null,2341]
[null,"RES: PSE PROVIDED ALL TRENCH FOR STUB OR FROM EXISTING STUB TO METER\nEnter Applicable length Below",3479,0,null,null,"With Customer provided trench or conduit from main or from stub to meter location. (**) ",870,null,841]
[null,"RES: CUSTOMER PROVIDED TRENCH/CONDUIT FROM STUB TO METER; PSE PROVIDED TRENCH FOR STUB\nEnter Applicable length Below",2341,0,null,null,"With Customer provided trench or conduit from existing service on contiguous lot for twin services",1879,null,1887]
[null,"RES: CUSTOMER PROVIDED ALL TRENCH/CONDUIT FROM MAIN OR FROM STUB TO METER\nEnter Applicable length Below",841,0,null,"b.","Commercial Gas Service (up to 4” PE in size) The sum of the following charges, as applicable:"]
[null,"RES: ALL TWIN SVCS  \nEnter Applicable length Below",1887,0,null,null,"With Company provided trench in right-of-way to private property for stub",3491,null,3722]
[null,"COMM: PSE PROVIDED TRENCH IN RIGHT-OF-WAY TO PRIVATE PROPERTY FOR STUB\nEnter Applicable length Below",3722,0,null,null,"With Company provided trench for service extension from stub to meter location",null,46.26,null,46.45]
[null,"COMM: PSE PROVIDED TRENCH FROM STUB TO METER \nEnter Applicable length Below",0,46.45,null,null,"With Customer provided trench from either stub or main to meter location.(**)",null,23.07,null,28.81]
[null,"COMM: CUSTOMER PROVIDED TRENCH FROM STUB OR MAIN TO METER\nEnter Applicable length Below",0,28.81]
[null,"NOT APPLICABLE",0,0]
[]
[null,""]
[null,"3","Meter set assembly ",null,null,"Facility Type","Effective 1/1/09","Effective 1/1/10"]
[null,"MSA WITH MANIFOLD - EST. COSTS\nContact Gas Industrial Meter Operations and\nEnter Total MSA Costs Below",0]
[null,"CLASS 250 INSTALLED CONCURRENTLY WITH A NEW SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",127,null,null,3]
[null,"CLASS 400 INSTALLED CONCURRENTLY WITH A NEW SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",425,null,null,"Meter set assembly","Base Cost","Cost per foot","Base Cost","Cost per foot"]
[null,"1000 INSTALLED CONCURRENTLY WITH A NEW SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",1269,null,null,"a.","Diaphragm meters"]
[null,"CLASS 250 INSTALLED ON AN EXISTING SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",413,null,null,null,"LP delivery and installed concurrently with a new service and a new riser"]
[null,"CLASS 400 INSTALLED ON AN EXISTING SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",710,null,null,null,"Class 250 meter set assembly",127,null,127]
[null,"1000 INSTALLED ON AN EXISTING SERVICE AND RISER / DIAPHRAGM LP DELIVERY ",1442,null,null,null,"Class 400 meter set assembly",424,null,425]
[null,"1400 INSTALLED ON A NEW RISER / DIAPHRAGM LP DELIVERY ",6616,null,null,null,"1000 meter set assembly ",1241,null,1269]
[null,"2300 INSTALLED ON A NEW RISER / DIAPHRAGM LP DELIVERY ",7762,null,null,null,"LP delivery and installed on an existing riser or an existing manifold"]
[null,"1000 INSTALLED ON A NEW RISER / DIAPHRAGM IP DELIVERY ",6408,null,null,null,"Class 250 meter set assembly",389,null,413]
[null,"3000 INSTALLED ON A NEW RISER / ROTARY LP DELIVERY ",6072,null,null,null,"Class 400 meter set assembly",687,null,710]
[null,"5000 INSTALLED ON A NEW RISER / ROTARY LP DELIVERY ",7072,null,null,null,"1000 meter set assembly",1401,null,1442]
[null,"7000 INSTALLED ON A NEW RISER / ROTARY LP DELIVERY ",7579,null,null,null,"LP delivery and installed on a new riser"]
[null,"11000 INSTALLED ON A NEW RISER / ROTARY LP DELIVERY ",11406,null,null,null,"1400 meter set assembly",6328,null,6616]
[null,"16000 INSTALLED ON A NEW RISER / ROTARY LP DELIVERY ",15145,null,null,null,"2300 meter set assembly",8043,null,7762]
[null,"3000 INSTALLED ON A NEW RISER / ROTARY IP DELIVERY ",7482,null,null,null,"IP delivery and installed on a new riser"]
[null,"5000 INSTALLED ON A NEW RISER / ROTARY IP DELIVERY ",8482,null,null,null,"1000 meter set assembly ",7132,null,6408]
[null,"7000 INSTALLED ON A NEW RISER / ROTARY IP DELIVERY ",8990,null,null,null,"LP delivery with a manifold or IP delivery with a manifold"]
[null,"11000 INSTALLED ON A NEW RISER / ROTARY IP DELIVERY ",12816,null,null,null,"1000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,"16000 INSTALLED ON A NEW RISER / ROTARY IP DELIVERY ",17862,null,null,null,"1400 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,"NOT APPLICABLE",0,null,null,"b.","Rotary meters"]
[null,null,null,null,null,null,"LP delivery and installed on a new riser"]
[null,null,null,null,null,null,"3000 meter set assembly ",7872,null,6072]
[null,"4","Miscellaneous",null,null,null,"5000 meter set assembly ",7341,null,7072]
[null,"RESIDENTIAL METER RELOCATION (BASE COST INCLUDES FIRST 25' OR LESS)",null,null,null,null,"7000 meter set assembly",8178,null,7579]
[null,null,"Base cost","cost per foot",null,null,"11000 meter set assembly",9908,null,11406]
[null,"WITH CUSTOMER PROVIDED TRENCH",1221,31.09,null,null,"16000 meter set assembly",14976,null,15145]
[null,"WITH COMPANY PROVIDED TRENCH",1622,32.26,null,null,"IP delivery and installed on a new riser"]
[null,"CUT & RESET RISER ONLY (NO ADDITIONAL SERVICE LINE)",1221,null,null,null,"3000 meter set assembly",9754,null,7482]
[null,"NOT APPLICABLE",0,null,null,null,"5000 meter set assembly ",9222,null,8482]
[null,"maximum construction cost for residential meter relocation",3242,null,null,null,"7000 meter set assembly ",10060,null,8990]
[null,"",null,null,null,null,"11000 meter set assembly ",11790,null,12816]
[null,"",null,null,null,null,"16000 meter set assembly ",18061,null,17862]
[null,""]
[null,""]
[null,"",null,"Facility Type","Effective 11/1/09","Effective 1/1/10"]
[null,""]
[]
[null,null,null,null,"Base Cost","Cost per foot","Base Cost","Cost per foot"]
[null,null,null,null,"Meter set assembly (Continued)"]
[null,null,null,null,"LP delivery with a manifold or IP delivery with a manifold","Est. Costs",null,"Est. Costs"]
[null,null,null,null,"3000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,null,null,null,"5000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,null,null,null,"7000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,null,null,null,"11000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,null,null,null,"16000 meter set assembly","Est. Costs",null,"Est. Costs"]
[null,null,null,"c.","Turbine Meters","Est. Costs",null,"Est. Costs"]
[null,null,null,4,"Miscellaneous"]
[null,null,null,"a.","Residential meter relocation (Base cost includes first 25' or less)*"]
[null,null,null,null,"With Customer provided trench",1136,33.090000000000003,1221,31.09]
[null,null,null,null,"With Company provided trench",1488,34.21,1622,32.26]
[null,null,null,null,"Cut & reset riser only (no additional service line)",1136,null,1221]
[null,null,null,null,"*The maximum construction cost for residential meter relocation",3242,null,3242]
[null,null,null,"b.","Commercial/Industrial meter relocation","Est. Costs",null,"Est. Costs"]
[null,null,null,"c.","Excess Flow Valve Installation on an existing service","Est. Costs",null,"Est. Costs"]
[null,null,null,"d.","Guard posts installed concurrently with a new service, per service or manifold"]
[null,null,null,null,"2.5\" Posts",250,null,250]
[null,null,null,null,"4\" Posts",303,null,303]