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

{"sheet":"Input","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[{"$f":"ROW()","v":1},"Cascade Natural Gas Corporation"]
[{"$f":"ROW()","v":2},"HISTORIC YEAR ENDING DECEMBER 31, 2016"]
[{"$f":"ROW()","v":3},"WP-1 Redacted",null,null,"Case 2= FTY"]
[{"$f":"ROW()","v":4},"Step 1"]
[{"$f":"ROW()","v":5},null,"All Totals Intact =",true,1]
[{"$f":"ROW()","v":6},null,"All Allocators Found = ",true]
[{"$f":"ROW()","v":7}]
[{"$f":"ROW()","v":8},"Account","Account"]
[{"$f":"ROW()","v":9},"Description","Code"]
[{"$f":"ROW()","v":10}]
[{"$f":"ROW()","v":11}]

{"sheet":"Specific Customer","index":1,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Company","v":"Cascade Natural Gas - Washington"},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Title","v":"HISTORIC YEAR ENDING DEC 31, 2016"}]
[null,"Step 0"]
["SUMMARY OF RESULTS",null,null,null,"Actual","Target",null,"INPUTS FOR SPECIFIC CUSTOMER"]
["Gross Revenue",null,null,null,{"$f":"M10","v":92000000},{"$f":"N63","v":{"$error":"#REF!"}},null,"Functions:",null,"Include Y/N","Rate of Return"]
[null,null,null,null,null,null,null,"Production",null,"Y",7.9059000000000004E-2,"Rate Class","2-RC"]
["Expenses",null,null,null,{"$f":"L63","v":{"$error":"#REF!"}},{"$f":"L63","v":{"$error":"#REF!"}},null,"Storage",null,"Y",7.9059000000000004E-2]
["Gross Receipts Taxes",null,null,null,{"$f":"E6*#REF!","v":{"$error":"#REF!"}},{"$f":"F6*#REF!","v":{"$error":"#REF!"}},null,"Transport",null,"Y",7.9059000000000004E-2,"Revenue- Actual ="]
["Pretax Margin",null,null,null,{"$f":"E6-E8-E9","v":{"$error":"#REF!"}},{"$f":"F6-F8-F9","v":{"$error":"#REF!"}},null,"Distribution",null,"Y",7.9059000000000004E-2,null,92000000]
["Incremental Income Taxes- Statutory",null,null,null,{"$f":"E10*#REF!","v":{"$error":"#REF!"}},{"$f":"F10*#REF!","v":{"$error":"#REF!"}},null,"OnSite",null,"Y",7.9059000000000004E-2]
["Benefit of Permanent Tax differences",null,null,null,0,0]
[null,null,null,null,{"$f":"E10-E11-E12","v":{"$error":"#REF!"}},{"$f":"F10-F11-F12","v":{"$error":"#REF!"}},null,"Demand (mcf-peak)",null,null,{"$f":"641197-(12*6000)","v":569197}]
["Rate Base",null,null,null,{"$f":"H63","v":{"$error":"#REF!"}},{"$f":"H63","v":{"$error":"#REF!"}},null,"Demand",null,null,0]
["Return on Rate Base",null,null,null,{"$f":"E13/E14","v":{"$error":"#REF!"}},{"$f":"F13/F14","v":{"$error":"#REF!"}},null,"Energy (mcf/month)",null,null,382386173]
[null,null,null,null,null,null,null,"Customer (months)",null,null,12]
["Actual Revenue / Target Revenue",null,null,null,{"$f":"E6/F6","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,"Billing","Gross Rev.","Revenue  Req.","Unit RB","Unit RB X","Return on RB","Revenue to","Unit Costs","Unit Costs X","Revenue for","Gross Rev.","Revenue  Req."]
[null,null,"ROR","Determinants","After GRT","Per Unit","for Class"," Bill. Determ.","for Customer","Earn Return","for Class"," Bill. Determ.","Ret. + Costs","After GRT","Per Unit"]
[]
[null,"Column Reference:",null,"a",null,null,"b=","c=","d=","e=","f=","g=","h=","I  ","j="]
[null,"Formula:",null,"Input",null,null,{"$f":"\"Lookup \" &$M$7","v":"Lookup 2-RC"},"a X b","c X ROR","dXFIT Gross",{"$f":"\"Lookup \" &$M$7","v":"Lookup 2-RC"},"a X f","e + g","hXGRT Gross","i / a"]
[null,null,null,null,null,null,"in Unit Cost",null,null,".","in Unit Cost"]
[]
[]
["PRODUCTION"]
[{"$f":"IF(UPPER(LEFT(T(J7),1))=\"Y\",1,0)","v":1},"Demand (mcf-peak)",null,{"$f":"K$13*A29","v":569197},{"$f":"N29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($D29=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D29*G29","v":{"$error":"#REF!"}},{"$f":"H29*K7","v":{"$error":"#REF!"}},{"$f":"I29*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D29=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D29*K29","v":{"$error":"#REF!"}},{"$f":"J29+L29","v":{"$error":"#REF!"}},{"$f":"M29*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D29>0,N29/D29,0)","v":{"$error":"#REF!"}}]
[null,"Demand",null,{"$f":"K$14*A29","v":0},{"$error":"#REF!"},0,{"$f":"IF($D30=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D30*G30","v":0},{"$f":"H30*K7","v":0},{"$f":"I30*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D30=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D30*K30","v":0},{"$f":"J30+L30","v":{"$error":"#REF!"}},{"$f":"M30*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D30>0,N30/D30,0)","v":0}]
[null,"Energy (mcf/month)",null,{"$f":"K$15*A29","v":382386173},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D31=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D31*G31","v":{"$error":"#REF!"}},{"$f":"H31*K7","v":{"$error":"#REF!"}},{"$f":"I31*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D31=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D31*K31","v":{"$error":"#REF!"}},{"$f":"J31+L31","v":{"$error":"#REF!"}},{"$f":"M31*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D31>0,N31/D31,0)","v":{"$error":"#REF!"}}]
[null,"Customer (months)",null,{"$f":"K$16*A29","v":12},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D32=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D32*G32","v":{"$error":"#REF!"}},{"$f":"H32*K7","v":{"$error":"#REF!"}},{"$f":"I32*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D32=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D32*K32","v":{"$error":"#REF!"}},{"$f":"J32+L32","v":{"$error":"#REF!"}},{"$f":"M32*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D32>0,N32/D32,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D33>0,N33/D33,\"\")","v":""}]
["STORAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D34>0,N34/D34,\"\")","v":""}]
[{"$f":"IF(UPPER(LEFT(T(J8),1))=\"Y\",1,0)","v":1},"Demand (mcf-peak)",null,{"$f":"K$13*A35","v":569197},{"$f":"N35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($D35=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D35*G35","v":{"$error":"#REF!"}},{"$f":"H35*K8","v":{"$error":"#REF!"}},{"$f":"I35*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D35=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D35*K35","v":{"$error":"#REF!"}},{"$f":"J35+L35","v":{"$error":"#REF!"}},{"$f":"M35*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D35>0,N35/D35,0)","v":{"$error":"#REF!"}}]
[null,"Demand",null,{"$f":"K$14*A35","v":0},{"$error":"#REF!"},0,{"$f":"IF($D36=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D36*G36","v":0},{"$f":"H36*K8","v":0},{"$f":"I36*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D36=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D36*K36","v":0},{"$f":"J36+L36","v":{"$error":"#REF!"}},{"$f":"M36*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D36>0,N36/D36,0)","v":0}]
[null,"Energy (mcf/month)",null,{"$f":"K$15*A35","v":382386173},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D37=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D37*G37","v":{"$error":"#REF!"}},{"$f":"H37*K8","v":{"$error":"#REF!"}},{"$f":"I37*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D37=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D37*K37","v":{"$error":"#REF!"}},{"$f":"J37+L37","v":{"$error":"#REF!"}},{"$f":"M37*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D37>0,N37/D37,0)","v":{"$error":"#REF!"}}]
[null,"Customer (months)",null,{"$f":"K$16*A35","v":12},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D38=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D38*G38","v":{"$error":"#REF!"}},{"$f":"H38*K8","v":{"$error":"#REF!"}},{"$f":"I38*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D38=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D38*K38","v":{"$error":"#REF!"}},{"$f":"J38+L38","v":{"$error":"#REF!"}},{"$f":"M38*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D38>0,N38/D38,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D39>0,N39/D39,\"\")","v":""}]
["TRANSMISSION",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D40>0,N40/D40,\"\")","v":""}]
[{"$f":"IF(UPPER(LEFT(T(J9),1))=\"Y\",1,0)","v":1},"Demand (mcf-peak)",null,{"$f":"K$13*A41","v":569197},{"$f":"N41","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($D41=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D41*G41","v":{"$error":"#REF!"}},{"$f":"H41*K9","v":{"$error":"#REF!"}},{"$f":"I41*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D41=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D41*K41","v":{"$error":"#REF!"}},{"$f":"J41+L41","v":{"$error":"#REF!"}},{"$f":"M41*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D41>0,N41/D41,0)","v":{"$error":"#REF!"}}]
[null,"Demand",null,{"$f":"K$14*A41","v":0},{"$error":"#REF!"},0,{"$f":"IF($D42=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D42*G42","v":0},{"$f":"H42*K9","v":0},{"$f":"I42*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D42=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D42*K42","v":0},{"$f":"J42+L42","v":{"$error":"#REF!"}},{"$f":"M42*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D42>0,N42/D42,0)","v":0}]
[null,"Energy (mcf/month)",null,{"$f":"K$15*A41","v":382386173},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D43=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D43*G43","v":{"$error":"#REF!"}},{"$f":"H43*K9","v":{"$error":"#REF!"}},{"$f":"I43*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D43=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D43*K43","v":{"$error":"#REF!"}},{"$f":"J43+L43","v":{"$error":"#REF!"}},{"$f":"M43*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D43>0,N43/D43,0)","v":{"$error":"#REF!"}}]
[null,"Customer (months)",null,{"$f":"K$16*A41","v":12},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D44=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D44*G44","v":{"$error":"#REF!"}},{"$f":"H44*K9","v":{"$error":"#REF!"}},{"$f":"I44*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D44=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D44*K44","v":{"$error":"#REF!"}},{"$f":"J44+L44","v":{"$error":"#REF!"}},{"$f":"M44*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D44>0,N44/D44,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D45>0,N45/D45,\"\")","v":""}]
["DISTRIBUTION",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D46>0,N46/D46,\"\")","v":""}]
[{"$f":"IF(UPPER(LEFT(T(J10),1))=\"Y\",1,0)","v":1},"Demand (mcf-peak)",null,{"$f":"K$13*A47","v":569197},{"$f":"N47","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($D47=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D47*G47","v":{"$error":"#REF!"}},{"$f":"H47*K10","v":{"$error":"#REF!"}},{"$f":"I47*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D47=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D47*K47","v":{"$error":"#REF!"}},{"$f":"J47+L47","v":{"$error":"#REF!"}},{"$f":"M47*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D47>0,N47/D47,0)","v":{"$error":"#REF!"}}]
[null,"Demand",null,{"$f":"K$14*A47","v":0},{"$error":"#REF!"},0,{"$f":"IF($D48=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D48*G48","v":0},{"$f":"H48*K10","v":0},{"$f":"I48*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D48=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D48*K48","v":0},{"$f":"J48+L48","v":{"$error":"#REF!"}},{"$f":"M48*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D48>0,N48/D48,0)","v":0}]
[null,"Energy (mcf/month)",null,{"$f":"K$15*A47","v":382386173},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D49=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D49*G49","v":{"$error":"#REF!"}},{"$f":"H49*K10","v":{"$error":"#REF!"}},{"$f":"I49*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D49=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D49*K49","v":{"$error":"#REF!"}},{"$f":"J49+L49","v":{"$error":"#REF!"}},{"$f":"M49*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D49>0,N49/D49,0)","v":{"$error":"#REF!"}}]
[null,"Customer (months)",null,{"$f":"K$16*A47","v":12},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D50=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D50*G50","v":{"$error":"#REF!"}},{"$f":"H50*K10","v":{"$error":"#REF!"}},{"$f":"I50*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D50=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D50*K50","v":{"$error":"#REF!"}},{"$f":"J50+L50","v":{"$error":"#REF!"}},{"$f":"M50*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D50>0,N50/D50,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D51>0,N51/D51,\"\")","v":""}]
["ONSITE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D52>0,N52/D52,\"\")","v":""}]
[{"$f":"IF(UPPER(LEFT(T(J11),1))=\"Y\",1,0)","v":1},"Demand (mcf-peak)",null,{"$f":"K$13*A53","v":569197},{"$f":"N53","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF($D53=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D53*G53","v":{"$error":"#REF!"}},{"$f":"H53*K11","v":{"$error":"#REF!"}},{"$f":"I53*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D53=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D53*K53","v":{"$error":"#REF!"}},{"$f":"J53+L53","v":{"$error":"#REF!"}},{"$f":"M53*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D53>0,N53/D53,0)","v":{"$error":"#REF!"}}]
[null,"Demand",null,{"$f":"K$14*A53","v":0},{"$error":"#REF!"},0,{"$f":"IF($D54=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D54*G54","v":0},{"$f":"H54*K11","v":0},{"$f":"I54*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D54=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":0},{"$f":"D54*K54","v":0},{"$f":"J54+L54","v":{"$error":"#REF!"}},{"$f":"M54*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D54>0,N54/D54,0)","v":0}]
[null,"Energy (mcf/month)",null,{"$f":"K$15*A53","v":382386173},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D55=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D55*G55","v":{"$error":"#REF!"}},{"$f":"H55*K11","v":{"$error":"#REF!"}},{"$f":"I55*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D55=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D55*K55","v":{"$error":"#REF!"}},{"$f":"J55+L55","v":{"$error":"#REF!"}},{"$f":"M55*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D55>0,N55/D55,0)","v":{"$error":"#REF!"}}]
[null,"Customer (months)",null,{"$f":"K$16*A53","v":12},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D56=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D56*G56","v":{"$error":"#REF!"}},{"$f":"H56*K11","v":{"$error":"#REF!"}},{"$f":"I56*#REF!","v":{"$error":"#REF!"}},{"$f":"IF($D56=0,0,HLOOKUP($M$7,UnitData,#REF!-#REF!))","v":{"$error":"#REF!"}},{"$f":"D56*K56","v":{"$error":"#REF!"}},{"$f":"J56+L56","v":{"$error":"#REF!"}},{"$f":"M56*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(D56>0,N56/D56,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D57>0,N57/D57,\"\")","v":""}]
["TOTAL SERVICE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D58>0,N58/D58,\"\")","v":""}]
[null,"Demand ($/kw-month)",{"$f":"IF(ABS(K13*F59-E59)<1,\"OK\",\"ERROR\")","v":{"$error":"#REF!"}},null,{"$f":"E29+E35+E41+E47+E53","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"H29+H35+H41+H47+H53","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"L29+L35+L41+L47+L53","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Demand ($/kwh)",{"$f":"IF(ABS(K14*F60-E60)<1,\"OK\",\"ERROR\")","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},0,null,0,0,{"$error":"#REF!"},null,0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Energy ($/kwh)",{"$f":"IF(ABS(K15*F61-E61)<1,\"OK\",\"ERROR\")","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Customer ($/month)",{"$f":"IF(ABS(K16*F62-E62)<1,\"OK\",\"ERROR\")","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"SUM(E59:E62)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(H59:H62)","v":{"$error":"#REF!"}},{"$f":"SUM(I59:I62)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]