{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Input","FORM 1.00","FORM 1.10","FORM 1.20","FORM 2.00","FORM 2.10","FORM 2.20","FORM 2.30","FORM 2.50","FORM 3.00","Revenue","Sales for Resale"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":41,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":136,"n_cols":13,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
["Input:"]
[]
["Expense Month:","2018-08-01"]
[]
["Case No.","2017-00321"]
[]
["Property Tax Rates"]
["ARO Account:",1.5E-3,null,null,"Jurisdictional E(m) Table"]
["Structures & Improvements",1.4274E-2,null,null,null,"Juris. E(m)",null,null,null,"Juris. E(m) vs. Revenue Collected"]
[null,null,null,null,"Form 1.10","Ln 9","Ln 13","Ln 7","Ln 12",null,"Recovered","Recovery"]
[null,null,null,null,"Expense",null,null,null,"Adj. Retail","(Over)/Under","in","vs."]
["Adj. Jurisdictional E(m)",null,null,null,"Month","Retail","PSM","Total","Recovery","Recovery","Rates","Allowed","Exp Month / Billing"]
[{"$f":"\"Authorized for \"&TEXT(EDATE(ExpMonth,-2),\"mmm-yy\")","v":"Authorized for Jun-18"},null,null,null,"2018-02-01",0,{"$f":"H13-F13","v":0},0]
["Expense Month",{"$f":"VLOOKUP(EDATE(ExpMonth,-2),JurisEm,5, FALSE)","v":1413676},null,null,"2018-03-01",0,0,0]
[null,null,null,null,"2018-04-01",683831,23922,707753,683831,{"$f":"I15-F15","v":0},null,null,"Apr / June"]
[null,null,null,null,"2018-05-01",783036,{"$f":"H16-F16","v":23802},806838,783036,{"$f":"I16-F16","v":0},null,null,"May / July"]
["Effective Date for Billing:","2018-09-28",null,null,"2018-06-01",1461780,{"$f":"H17-F17","v":41954},1503734,1413676,-48104,{"$f":"SUM(IF(BillPeriod=E17,ESM))","v":731935},{"$f":"IF(SUM($K$17:K17)+(SUM(J16:J17))=SUM($F$15:F15),\"\",\"ERROR\")","v":""},"June / August"]
["Date Submitted:","2018-09-18",null,null,"2018-07-01",2237252,{"$f":"H18-F18","v":73481.819999999832},2310733.8199999998,2122573,-114679,{"$f":"SUM(IF(BillPeriod=E18,ESM))","v":897715},{"$f":"IF(SUM($K$17:K18)+(SUM(J17:J18))=SUM($F$15:F16),\"\",\"ERROR\")","v":""},"July / September"]
[null,null,null,null,"2018-08-01",2407393,79069,2486462,2280451,-126942,{"$f":"SUM(IF(BillPeriod=E19,ESM))","v":1540618},{"$f":"IF(SUM($K$17:K19)+(SUM(J18:J19))=SUM($F$15:F17),\"\",\"ERROR\")","v":""},"August / October"]
["Error Check:",null,null,null,"2018-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E20,ESM))","v":0},{"$f":"IF(SUM($K$17:K20)+(SUM(J19:J20))=SUM($F$15:F18),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
["To make sure that retail  ",{"$f":"IF(VLOOKUP(ExpMonth,SLSRSLtable,2,FALSE)=0,\"ERROR\",\"\")","v":""},null,null,"2018-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E21,ESM))","v":0},{"$f":"IF(SUM($K$17:K21)+(SUM(J20:J21))=SUM($F$15:F19),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
["and SLSRSL are entered ",{"$f":"IF(ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=ExpMonth,TotRev))),0)=0,\"ERROR\",\"\")","v":""},null,null,"2018-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E22,ESM))","v":0},{"$f":"IF(SUM($K$17:K22)+(SUM(J21:J22))=SUM($F$15:F20),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
["for the current expense month",null,null,null,"2018-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E23,ESM))","v":0},{"$f":"IF(SUM($K$17:K23)+(SUM(J22:J23))=SUM($F$15:F21),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2019-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E24,ESM))","v":0},{"$f":"IF(SUM($K$17:K24)+(SUM(J23:J24))=SUM($F$15:F22),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2019-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E25,ESM))","v":0},{"$f":"IF(SUM($K$17:K25)+(SUM(J24:J25))=SUM($F$15:F23),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2019-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E26,ESM))","v":0},{"$f":"IF(SUM($K$17:K26)+(SUM(J25:J26))=SUM($F$15:F24),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
["File:",null,null,null,"2019-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E27,ESM))","v":0},{"$f":"IF(SUM($K$17:K27)+(SUM(J26:J27))=SUM($F$15:F25),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
["Original & 2 copies",null,null,null,"2019-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E28,ESM))","v":0},{"$f":"IF(SUM($K$17:K28)+(SUM(J27:J28))=SUM($F$15:F26),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2019-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E29,ESM))","v":0},{"$f":"IF(SUM($K$17:K29)+(SUM(J28:J29))=SUM($F$15:F27),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2019-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E30,ESM))","v":0},{"$f":"IF(SUM($K$17:K30)+(SUM(J29:J30))=SUM($F$15:F28),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2019-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E31,ESM))","v":0},{"$f":"IF(SUM($K$17:K31)+(SUM(J30:J31))=SUM($F$15:F29),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2019-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E32,ESM))","v":0},{"$f":"IF(SUM($K$17:K32)+(SUM(J31:J32))=SUM($F$15:F30),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2019-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E33,ESM))","v":0},{"$f":"IF(SUM($K$17:K33)+(SUM(J32:J33))=SUM($F$15:F31),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2019-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E34,ESM))","v":0},{"$f":"IF(SUM($K$17:K34)+(SUM(J33:J34))=SUM($F$15:F32),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2019-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E35,ESM))","v":0},{"$f":"IF(SUM($K$17:K35)+(SUM(J34:J35))=SUM($F$15:F33),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2020-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E36,ESM))","v":0},{"$f":"IF(SUM($K$17:K36)+(SUM(J35:J36))=SUM($F$15:F34),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2020-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E37,ESM))","v":0},{"$f":"IF(SUM($K$17:K37)+(SUM(J36:J37))=SUM($F$15:F35),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2020-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E38,ESM))","v":0},{"$f":"IF(SUM($K$17:K38)+(SUM(J37:J38))=SUM($F$15:F36),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2020-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E39,ESM))","v":0},{"$f":"IF(SUM($K$17:K39)+(SUM(J38:J39))=SUM($F$15:F37),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2020-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E40,ESM))","v":0},{"$f":"IF(SUM($K$17:K40)+(SUM(J39:J40))=SUM($F$15:F38),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2020-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E41,ESM))","v":0},{"$f":"IF(SUM($K$17:K41)+(SUM(J40:J41))=SUM($F$15:F39),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2020-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E42,ESM))","v":0},{"$f":"IF(SUM($K$17:K42)+(SUM(J41:J42))=SUM($F$15:F40),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2020-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E43,ESM))","v":0},{"$f":"IF(SUM($K$17:K43)+(SUM(J42:J43))=SUM($F$15:F41),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2020-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E44,ESM))","v":0},{"$f":"IF(SUM($K$17:K44)+(SUM(J43:J44))=SUM($F$15:F42),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2020-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E45,ESM))","v":0},{"$f":"IF(SUM($K$17:K45)+(SUM(J44:J45))=SUM($F$15:F43),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2020-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E46,ESM))","v":0},{"$f":"IF(SUM($K$17:K46)+(SUM(J45:J46))=SUM($F$15:F44),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2020-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E47,ESM))","v":0},{"$f":"IF(SUM($K$17:K47)+(SUM(J46:J47))=SUM($F$15:F45),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2021-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E48,ESM))","v":0},{"$f":"IF(SUM($K$17:K48)+(SUM(J47:J48))=SUM($F$15:F46),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2021-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E49,ESM))","v":0},{"$f":"IF(SUM($K$17:K49)+(SUM(J48:J49))=SUM($F$15:F47),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2021-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E50,ESM))","v":0},{"$f":"IF(SUM($K$17:K50)+(SUM(J49:J50))=SUM($F$15:F48),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2021-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E51,ESM))","v":0},{"$f":"IF(SUM($K$17:K51)+(SUM(J50:J51))=SUM($F$15:F49),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2021-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E52,ESM))","v":0},{"$f":"IF(SUM($K$17:K52)+(SUM(J51:J52))=SUM($F$15:F50),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2021-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E53,ESM))","v":0},{"$f":"IF(SUM($K$17:K53)+(SUM(J52:J53))=SUM($F$15:F51),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2021-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E54,ESM))","v":0},{"$f":"IF(SUM($K$17:K54)+(SUM(J53:J54))=SUM($F$15:F52),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2021-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E55,ESM))","v":0},{"$f":"IF(SUM($K$17:K55)+(SUM(J54:J55))=SUM($F$15:F53),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2021-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E56,ESM))","v":0},{"$f":"IF(SUM($K$17:K56)+(SUM(J55:J56))=SUM($F$15:F54),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2021-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E57,ESM))","v":0},{"$f":"IF(SUM($K$17:K57)+(SUM(J56:J57))=SUM($F$15:F55),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2021-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E58,ESM))","v":0},{"$f":"IF(SUM($K$17:K58)+(SUM(J57:J58))=SUM($F$15:F56),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2021-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E59,ESM))","v":0},{"$f":"IF(SUM($K$17:K59)+(SUM(J58:J59))=SUM($F$15:F57),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2022-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E60,ESM))","v":0},{"$f":"IF(SUM($K$17:K60)+(SUM(J59:J60))=SUM($F$15:F58),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2022-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E61,ESM))","v":0},{"$f":"IF(SUM($K$17:K61)+(SUM(J60:J61))=SUM($F$15:F59),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2022-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E62,ESM))","v":0},{"$f":"IF(SUM($K$17:K62)+(SUM(J61:J62))=SUM($F$15:F60),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2022-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E63,ESM))","v":0},{"$f":"IF(SUM($K$17:K63)+(SUM(J62:J63))=SUM($F$15:F61),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2022-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E64,ESM))","v":0},{"$f":"IF(SUM($K$17:K64)+(SUM(J63:J64))=SUM($F$15:F62),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2022-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E65,ESM))","v":0},{"$f":"IF(SUM($K$17:K65)+(SUM(J64:J65))=SUM($F$15:F63),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2022-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E66,ESM))","v":0},{"$f":"IF(SUM($K$17:K66)+(SUM(J65:J66))=SUM($F$15:F64),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2022-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E67,ESM))","v":0},{"$f":"IF(SUM($K$17:K67)+(SUM(J66:J67))=SUM($F$15:F65),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2022-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E68,ESM))","v":0},{"$f":"IF(SUM($K$17:K68)+(SUM(J67:J68))=SUM($F$15:F66),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2022-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E69,ESM))","v":0},{"$f":"IF(SUM($K$17:K69)+(SUM(J68:J69))=SUM($F$15:F67),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2022-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E70,ESM))","v":0},{"$f":"IF(SUM($K$17:K70)+(SUM(J69:J70))=SUM($F$15:F68),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2022-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E71,ESM))","v":0},{"$f":"IF(SUM($K$17:K71)+(SUM(J70:J71))=SUM($F$15:F69),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2023-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E72,ESM))","v":0},{"$f":"IF(SUM($K$17:K72)+(SUM(J71:J72))=SUM($F$15:F70),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2023-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E73,ESM))","v":0},{"$f":"IF(SUM($K$17:K73)+(SUM(J72:J73))=SUM($F$15:F71),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2023-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E74,ESM))","v":0},{"$f":"IF(SUM($K$17:K74)+(SUM(J73:J74))=SUM($F$15:F72),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2023-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E75,ESM))","v":0},{"$f":"IF(SUM($K$17:K75)+(SUM(J74:J75))=SUM($F$15:F73),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2023-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E76,ESM))","v":0},{"$f":"IF(SUM($K$17:K76)+(SUM(J75:J76))=SUM($F$15:F74),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2023-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E77,ESM))","v":0},{"$f":"IF(SUM($K$17:K77)+(SUM(J76:J77))=SUM($F$15:F75),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2023-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E78,ESM))","v":0},{"$f":"IF(SUM($K$17:K78)+(SUM(J77:J78))=SUM($F$15:F76),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2023-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E79,ESM))","v":0},{"$f":"IF(SUM($K$17:K79)+(SUM(J78:J79))=SUM($F$15:F77),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2023-09-01",null,0,null,null,{"$f":"I80-F80","v":0},{"$f":"SUM(IF(BillPeriod=E80,ESM))","v":0},{"$f":"IF(SUM($K$17:K80)+(SUM(J79:J80))=SUM($F$15:F78),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2023-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E81,ESM))","v":0},{"$f":"IF(SUM($K$17:K81)+(SUM(J80:J81))=SUM($F$15:F79),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2023-11-01",null,{"$f":"H82-F82","v":0},null,null,0,{"$f":"SUM(IF(BillPeriod=E82,ESM))","v":0},{"$f":"IF(SUM($K$17:K82)+(SUM(J81:J82))=SUM($F$15:F80),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2023-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E83,ESM))","v":0},{"$f":"IF(SUM($K$17:K83)+(SUM(J82:J83))=SUM($F$15:F81),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2024-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E84,ESM))","v":0},{"$f":"IF(SUM($K$17:K84)+(SUM(J83:J84))=SUM($F$15:F82),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2024-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E85,ESM))","v":0},{"$f":"IF(SUM($K$17:K85)+(SUM(J84:J85))=SUM($F$15:F83),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2024-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E86,ESM))","v":0},{"$f":"IF(SUM($K$17:K86)+(SUM(J85:J86))=SUM($F$15:F84),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2024-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E87,ESM))","v":0},{"$f":"IF(SUM($K$17:K87)+(SUM(J86:J87))=SUM($F$15:F85),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2024-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E88,ESM))","v":0},{"$f":"IF(SUM($K$17:K88)+(SUM(J87:J88))=SUM($F$15:F86),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2024-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E89,ESM))","v":0},{"$f":"IF(SUM($K$17:K89)+(SUM(J88:J89))=SUM($F$15:F87),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2024-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E90,ESM))","v":0},{"$f":"IF(SUM($K$17:K90)+(SUM(J89:J90))=SUM($F$15:F88),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2024-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E91,ESM))","v":0},{"$f":"IF(SUM($K$17:K91)+(SUM(J90:J91))=SUM($F$15:F89),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2024-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E92,ESM))","v":0},{"$f":"IF(SUM($K$17:K92)+(SUM(J91:J92))=SUM($F$15:F90),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2024-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E93,ESM))","v":0},{"$f":"IF(SUM($K$17:K93)+(SUM(J92:J93))=SUM($F$15:F91),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2024-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E94,ESM))","v":0},{"$f":"IF(SUM($K$17:K94)+(SUM(J93:J94))=SUM($F$15:F92),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2024-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E95,ESM))","v":0},{"$f":"IF(SUM($K$17:K95)+(SUM(J94:J95))=SUM($F$15:F93),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2025-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E96,ESM))","v":0},{"$f":"IF(SUM($K$17:K96)+(SUM(J95:J96))=SUM($F$15:F94),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2025-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E97,ESM))","v":0},{"$f":"IF(SUM($K$17:K97)+(SUM(J96:J97))=SUM($F$15:F95),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2025-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E98,ESM))","v":0},{"$f":"IF(SUM($K$17:K98)+(SUM(J97:J98))=SUM($F$15:F96),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2025-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E99,ESM))","v":0},{"$f":"IF(SUM($K$17:K99)+(SUM(J98:J99))=SUM($F$15:F97),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2025-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E100,ESM))","v":0},{"$f":"IF(SUM($K$17:K100)+(SUM(J99:J100))=SUM($F$15:F98),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2025-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E101,ESM))","v":0},{"$f":"IF(SUM($K$17:K101)+(SUM(J100:J101))=SUM($F$15:F99),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2025-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E102,ESM))","v":0},{"$f":"IF(SUM($K$17:K102)+(SUM(J101:J102))=SUM($F$15:F100),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2025-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E103,ESM))","v":0},{"$f":"IF(SUM($K$17:K103)+(SUM(J102:J103))=SUM($F$15:F101),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2025-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E104,ESM))","v":0},{"$f":"IF(SUM($K$17:K104)+(SUM(J103:J104))=SUM($F$15:F102),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2025-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E105,ESM))","v":0},{"$f":"IF(SUM($K$17:K105)+(SUM(J104:J105))=SUM($F$15:F103),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2025-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E106,ESM))","v":0},{"$f":"IF(SUM($K$17:K106)+(SUM(J105:J106))=SUM($F$15:F104),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2025-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E107,ESM))","v":0},{"$f":"IF(SUM($K$17:K107)+(SUM(J106:J107))=SUM($F$15:F105),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2026-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E108,ESM))","v":0},{"$f":"IF(SUM($K$17:K108)+(SUM(J107:J108))=SUM($F$15:F106),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2026-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E109,ESM))","v":0},{"$f":"IF(SUM($K$17:K109)+(SUM(J108:J109))=SUM($F$15:F107),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2026-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E110,ESM))","v":0},{"$f":"IF(SUM($K$17:K110)+(SUM(J109:J110))=SUM($F$15:F108),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2026-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E111,ESM))","v":0},{"$f":"IF(SUM($K$17:K111)+(SUM(J110:J111))=SUM($F$15:F109),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2026-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E112,ESM))","v":0},{"$f":"IF(SUM($K$17:K112)+(SUM(J111:J112))=SUM($F$15:F110),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2026-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E113,ESM))","v":0},{"$f":"IF(SUM($K$17:K113)+(SUM(J112:J113))=SUM($F$15:F111),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2026-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E114,ESM))","v":0},{"$f":"IF(SUM($K$17:K114)+(SUM(J113:J114))=SUM($F$15:F112),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2026-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E115,ESM))","v":0},{"$f":"IF(SUM($K$17:K115)+(SUM(J114:J115))=SUM($F$15:F113),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2026-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E116,ESM))","v":0},{"$f":"IF(SUM($K$17:K116)+(SUM(J115:J116))=SUM($F$15:F114),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2026-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E117,ESM))","v":0},{"$f":"IF(SUM($K$17:K117)+(SUM(J116:J117))=SUM($F$15:F115),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2026-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E118,ESM))","v":0},{"$f":"IF(SUM($K$17:K118)+(SUM(J117:J118))=SUM($F$15:F116),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2026-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E119,ESM))","v":0},{"$f":"IF(SUM($K$17:K119)+(SUM(J118:J119))=SUM($F$15:F117),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2027-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E120,ESM))","v":0},{"$f":"IF(SUM($K$17:K120)+(SUM(J119:J120))=SUM($F$15:F118),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2027-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E121,ESM))","v":0},{"$f":"IF(SUM($K$17:K121)+(SUM(J120:J121))=SUM($F$15:F119),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2027-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E122,ESM))","v":0},{"$f":"IF(SUM($K$17:K122)+(SUM(J121:J122))=SUM($F$15:F120),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2027-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E123,ESM))","v":0},{"$f":"IF(SUM($K$17:K123)+(SUM(J122:J123))=SUM($F$15:F121),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2027-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E124,ESM))","v":0},{"$f":"IF(SUM($K$17:K124)+(SUM(J123:J124))=SUM($F$15:F122),\"\",\"ERROR\")","v":"ERROR"},"May / July"]
[null,null,null,null,"2027-06-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E125,ESM))","v":0},{"$f":"IF(SUM($K$17:K125)+(SUM(J124:J125))=SUM($F$15:F123),\"\",\"ERROR\")","v":"ERROR"},"June / August"]
[null,null,null,null,"2027-07-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E126,ESM))","v":0},{"$f":"IF(SUM($K$17:K126)+(SUM(J125:J126))=SUM($F$15:F124),\"\",\"ERROR\")","v":"ERROR"},"July / September"]
[null,null,null,null,"2027-08-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E127,ESM))","v":0},{"$f":"IF(SUM($K$17:K127)+(SUM(J126:J127))=SUM($F$15:F125),\"\",\"ERROR\")","v":"ERROR"},"August / October"]
[null,null,null,null,"2027-09-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E128,ESM))","v":0},{"$f":"IF(SUM($K$17:K128)+(SUM(J127:J128))=SUM($F$15:F126),\"\",\"ERROR\")","v":"ERROR"},"September / November"]
[null,null,null,null,"2027-10-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E129,ESM))","v":0},{"$f":"IF(SUM($K$17:K129)+(SUM(J128:J129))=SUM($F$15:F127),\"\",\"ERROR\")","v":"ERROR"},"October / December"]
[null,null,null,null,"2027-11-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E130,ESM))","v":0},{"$f":"IF(SUM($K$17:K130)+(SUM(J129:J130))=SUM($F$15:F128),\"\",\"ERROR\")","v":"ERROR"},"November / January"]
[null,null,null,null,"2027-12-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E131,ESM))","v":0},{"$f":"IF(SUM($K$17:K131)+(SUM(J130:J131))=SUM($F$15:F129),\"\",\"ERROR\")","v":"ERROR"},"December / February"]
[null,null,null,null,"2028-01-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E132,ESM))","v":0},{"$f":"IF(SUM($K$17:K132)+(SUM(J131:J132))=SUM($F$15:F130),\"\",\"ERROR\")","v":"ERROR"},"January / March"]
[null,null,null,null,"2028-02-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E133,ESM))","v":0},{"$f":"IF(SUM($K$17:K133)+(SUM(J132:J133))=SUM($F$15:F131),\"\",\"ERROR\")","v":"ERROR"},"February / April"]
[null,null,null,null,"2028-03-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E134,ESM))","v":0},{"$f":"IF(SUM($K$17:K134)+(SUM(J133:J134))=SUM($F$15:F132),\"\",\"ERROR\")","v":"ERROR"},"March / May"]
[null,null,null,null,"2028-04-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E135,ESM))","v":0},{"$f":"IF(SUM($K$17:K135)+(SUM(J134:J135))=SUM($F$15:F133),\"\",\"ERROR\")","v":"ERROR"},"Apr / June"]
[null,null,null,null,"2028-05-01",null,0,null,null,0,{"$f":"SUM(IF(BillPeriod=E136,ESM))","v":0},{"$f":"IF(SUM($K$17:K136)+(SUM(J135:J136))=SUM($F$15:F134),\"\",\"ERROR\")","v":"ERROR"},"May / July"]

{"sheet":"FORM 1.00","index":1,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"ES FORM 1.00"]
[]
["DUKE ENERGY KENTUCKY, INC."]
["ENVIRONMENTAL SURCHARGE REPORT"]
[]
["Summary of Jurisdictional E(m), Jurisdictional R(m) and Environmental Surcharge Billing Factors"]
[]
[{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[]
[]
[]
["Residential (Total Revenue)"]
[]
["Jurisdictional E(m)",null,"ES Form 1.10, Line 15","=",{"$f":"'FORM 1.10'!H47","v":937949}]
[]
["Jurisdictional R(m)",null,"ES Form 1.10, Line 16","=",{"$f":"'FORM 1.10'!H50","v":11146170}]
[]
["Environmental Surcharge Billing Factor",null,"ES Form 1.10, Line 17","=",{"$f":"'FORM 1.10'!H53","v":8.4099999999999994E-2}]
[]
[]
["Non-Residential (Net Revenue)"]
[]
["Jurisdictional E(m)",null,"ES Form 1.10, Line 15","=",{"$f":"'FORM 1.10'!I47","v":1342502}]
[]
["Jurisdictional R(m)",null,"ES Form 1.10, Line 16",null,{"$f":"'FORM 1.10'!I51","v":10162293}]
[]
["Environmental Surcharge Billing Factor",null,"ES Form 1.10, Line 17","=",{"$f":"'FORM 1.10'!I53","v":0.1321}]
[]
[]
[]
[]
["Effective Date for Billing:",null,{"$f":"Input!B17","v":"2018-09-28"}]
[]
[]
["Submitted by:",null,"Theodore H. Czupik Jr."]
[]
[]
["Title:",null,"Rates & Regulatory Strategy Manager"]
[]
[]
["Date Submitted:",null,{"$f":"Input!B18","v":"2018-09-18"}]

{"sheet":"FORM 1.10","index":2,"n_rows":66,"n_cols":9,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"ES FORM 1.10"]
[]
[null,{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[null,{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
[null,"Calculation of Current Month Environmental Surcharge Factors"]
[]
[null,{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[]
[null,"Line",null,null,null,null,null,"Environmental"]
[null,"No.",null,"  E(m) = RORB + OE - EAS + Prior Period Adjustment + (Over)/Under Recovery",null,"Source",null,"Compliance Plans"]
[]
[null,{"$f":"MAX(B$13:B13)+1","v":1},null,"Environmental Compliance Rate Base (RB)",null,"ES Form 2.00",null,{"$f":"'FORM 2.00'!F28","v":32024247}]
[]
[null,{"$f":"MAX(B$13:B15)+1","v":2},null,"RB ÷ 12 months",null,"(1) ÷ 12",null,{"$f":"ROUND(H14/12,0)","v":2668687}]
[]
[null,{"$f":"MAX(B$13:B17)+1","v":3},null,"Pretax Rate of Return (ROR)",null,"ES Form 1.20",null,{"$f":"'FORM 1.20'!G16","v":8.4460000000000007E-2}]
[]
[null,{"$f":"MAX(B$13:B19)+1","v":4},null,"Return on the Environmental Compliance Rate Base (RORB)",null,"(2) x (3)",null,{"$f":"ROUND(H16*H18,0)","v":225397}]
[]
[null,{"$f":"MAX(B$13:B21)+1","v":5},null,"Environmental Operating Expenses (OE)",null,"ES Form 2.00","+",{"$f":"'FORM 2.00'!F38","v":2261065}]
[]
[null,{"$f":"MAX(B$13:B23)+1","v":6},null,"Less: Proceeds from Emission Allowance Sales (EAS)",null,"ES Form 2.00","-",{"$f":"'FORM 2.00'!F45","v":0}]
[]
[null,{"$f":"MAX(B$13:B25)+1","v":7},null,"  Sub-Total E(m)",null,"(4) + (5) - (6)",null,{"$f":"H20+H22-H24","v":2486462}]
[]
[null,{"$f":"MAX(B$13:B27)+1","v":8},null,"Jurisdictional Allocation Ratio for Expense Month",null,"Line 18",null,{"$f":"I58","v":0.96819999999999995}]
[]
[null,{"$f":"MAX(B$13:B29)+1","v":9},null,"Jurisdictional E(m) ",null," (7) x (8)",null,{"$f":"ROUND(H26*H28,0)","v":2407393}]
[]
[null,{"$f":"MAX(B$13:B31)+1","v":10},null,"Prior Period Adjustment (if necessary)",null,"(A)","+",0]
[]
[null,{"$f":"MAX(B$13:B33)+1","v":11},null,"Adjustment for (Over)/Under Recovery",null,"ES Form 2.00","+",{"$f":"'FORM 2.00'!F51","v":-126942}]
[]
[null,{"$f":"MAX(B$13:B35)+1","v":12},null,"  Total Adjusted Jurisdictional E(m)",null,"(9) + (10) + (11)",null,{"$f":"H30+H32+H34","v":2280451}]
[]
[null,13,null,"Jurisdictional E(m) to be Recovered in Rider PSM",null,"(7) - (9)",null,{"$f":"H26-H30","v":79069}]
[]
[null,"Calculation of Environmental Surcharge Billing Factors"]
[]
[null,null,null,null,null,null,null,"Residential","Non-Residential"]
[null,null,null,null,null,null,null,"(Total Revenue)","(Net Revenue)"]
[]
[null,{"$f":"MAX(B$13:B41)+1","v":14},null,"Revenues as a Percentage of 12 Month Average Total Revenues ",null,"ES Form 3.00",null,{"$f":"'FORM 3.00'!G36","v":0.4113},{"$f":"'FORM 3.00'!G64","v":0.5887}]
[]
[null,{"$f":"MAX(B$13:B46)+1","v":15},null,"Adjusted Jurisdictional E(m) - Allocated ",null,"(12) x (14)",null,{"$f":"ROUND(H36*H45,0)","v":937949},{"$f":"H36-H47","v":1342502}]
[]
[null,{"$f":"MAX(B$13:B48)+1","v":16},null,"R(m) "]
[null,null,null,"Residential R(m) = Average Total Revenue (Total Revenue excluding ESM Revenue)",null,"ES Form 3.00",null,{"$f":"'FORM 3.00'!G32","v":11146170}]
[null,null,null,"Non-Residential R(m) = Average Net Revenue (Total Revenue excluding ESM Revenue, Base Fuel and FAC Revenue)",null,"ES Form 3.00",null,null,{"$f":"'FORM 3.00'!H60","v":10162293}]
[]
[null,{"$f":"MAX(B$13:B52)+1","v":17},null,"Jurisdictional E(m) / R(m)",null,"(15) ÷ (16)",null,{"$f":"IF(H50=0,0,ROUND(H47/H50,4))","v":8.4099999999999994E-2},{"$f":"IF(I51=0,0,ROUND(I47/I51,4))","v":0.1321}]
[]
[]
[null,"Calculation of Jurisdictional Allocation Ratio - 12 Month Average"]
[]
[null,{"$f":"MAX(B$13:B57)+1","v":18},null,"Retail Revenue  ",null,"ES Form 3.00",null,{"$f":"'FORM 3.00'!G34","v":27102113},{"$f":"ROUND(H58/$H$62,4)","v":0.96819999999999995}]
[]
[null,{"$f":"MAX(B$13:B59)+1","v":19},null,"Sales for Resale",null,"Company Records",null,{"$f":"VLOOKUP(ExpMonth,SLSRSLtable,3,FALSE)","v":890752},{"$f":"I62-I58","v":3.180000000000005E-2}]
[]
[null,{"$f":"MAX(B$13:B61)+1","v":20},null,"Total Revenue  ",null,null,null,{"$f":"H58+H60","v":27992865},{"$f":"ROUND(H62/$H$62,4)","v":1}]
[]
[]
[]
[null,null,null,"Note:  (A) Amounts determined by the Commission during six-month and two-year reviews."]

{"sheet":"FORM 1.20","index":3,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"ES FORM 1.20"]
[]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Cost of Capital"]
[]
[]
["Line",null,null,null,"Weighted ","Gross up for","Pre-Tax "]
["No.","Capital Structure","Ratio","Cost","Cost","Tax Rate","Rate of Return"]
[null,null,null,null,"(A)","(B)","(A)x(B)"]
[]
[1,"Short-term Debt",9.7720000000000001E-2,3.083E-2,{"$f":"ROUND(C13*D13,5)","v":3.0100000000000001E-3},null,{"$f":"ROUND(E13,5)","v":3.0100000000000001E-3}]
[{"$f":"A13+1","v":2},"Long-term Debt",0.40977000000000002,4.2430000000000002E-2,{"$f":"ROUND(C14*D14,5)","v":1.7389999999999999E-2},null,{"$f":"ROUND(E14,5)","v":1.7389999999999999E-2}]
[{"$f":"A14+1","v":3},"Common Equity",0.49251,9.7250000000000003E-2,{"$f":"ROUND(C15*D15,5)","v":4.7899999999999998E-2},1.3373044000000001,{"$f":"ROUND(F15*E15,5)","v":6.4060000000000006E-2}]
[4,"  Total",{"$f":"SUM(C13:C15)","v":1},null,{"$f":"SUM(E13:E15)","v":6.83E-2},null,{"$f":"SUM(G13:G15)","v":8.4460000000000007E-2}]
[]
[]
[]
[null,"Note:  Capital structure, cost of debt and tax rate gross-up factor as approved in Case No. 2017-00321."]
[null,"          These rates are to remain constant until the Commission sets base rates in Duke Kentucky's next"]
[null,"          base rate case proceeding."]

{"sheet":"FORM 2.00","index":4,"n_rows":54,"n_cols":6,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"ES FORM 2.00"]
[]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Revenue Requirement of Environmental Compliance Costs"]
[]
[{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[]
["Line"]
["No.",null,"Determination of Environmental Compliance Rate Base (RB)","Source",null,"Amount"]
[]
[{"$f":"MAX(A13:A$13)+1","v":1},null,"Eligible Environmental Compliance Plant (Gross Plant)","ES Form 2.10",null,{"$f":"'FORM 2.10'!D51","v":0}]
[{"$f":"MAX(A$13:A14)+1","v":2},null,"Eligible Environmental Compliance CWIP Excluding AFUDC","ES Form 2.10",null,{"$f":"'FORM 2.10'!G51","v":31997129}]
[{"$f":"MAX(A$13:A15)+1","v":3},null,"Subtotal",null,null,{"$f":"F14+F15","v":31997129}]
[]
[{"$f":"MAX(A$13:A17)+1","v":4},null,"Additions:"]
[{"$f":"MAX(A$13:A18)+1","v":5},null,"Inventory - Emission Allowances","ES Form 2.30",null,{"$f":"ROUND('FORM 2.30'!G32,0)","v":27118}]
[{"$f":"MAX(A$13:A19)+1","v":6},null,"Subtotal",null,null,{"$f":"SUM(F19:F19)","v":27118}]
[]
[{"$f":"MAX(A$13:A21)+1","v":7},null,"Deductions:"]
[{"$f":"MAX(A$13:A22)+1","v":8},null,"Accumulated Depreciation on Eligible Environmental Compliance Plant","ES Form 2.10",null,{"$f":"'FORM 2.10'!E51","v":0}]
[{"$f":"MAX(A$13:A23)+1","v":9},null,"Accumulated Deferred Income Taxes on Eligible Environmental Compliance Plant","ES Form 2.10",null,{"$f":"'FORM 2.10'!I51","v":0}]
[{"$f":"MAX(A$13:A24)+1","v":10},null,"Accumulated Deferred Investment Tax Credits (ITC) on Eligible Environmental Compliance Plant","ES Form 2.10",null,{"$f":"'FORM 2.10'!H51","v":0}]
[{"$f":"MAX(A$13:A25)+1","v":11},null,"Subtotal",null,null,{"$f":"SUM(F23:F25)","v":0}]
[]
[{"$f":"MAX(A$13:A27)+1","v":12},null,"Environmental Compliance Rate Base",null,null,{"$f":"F16+F20-F26","v":32024247}]
[]
[]
[{"$f":"MAX(A$13:A30)+1","v":13},null,"Determination of Environmental Compliance Operating Expenses (OE)"]
[]
[{"$f":"MAX(A$13:A32)+1","v":14},null,"Monthly Depreciation Expense","ES Form 2.10",null,{"$f":"'FORM 2.10'!J51","v":0}]
[{"$f":"MAX(A$13:A33)+1","v":15},null,"Monthly Taxes Other Than Income Taxes","ES Form 2.10",null,{"$f":"'FORM 2.10'!K51","v":456727}]
[{"$f":"MAX(A$13:A34)+1","v":16},null,"Monthly Amortization Expense","ES Form 2.20",null,{"$f":"-'FORM 2.20'!N178","v":524301}]
[{"$f":"MAX(A$13:A35)+1","v":17},null,"Monthly Emission Allowance Expense","ES Form 2.30",null,{"$f":"ROUND('FORM 2.30'!E32,0)","v":1409}]
[{"$f":"MAX(A$13:A36)+1","v":18},null,"Monthly Enivronmental Reagent Expense","ES Form 2.50",null,{"$f":"'FORM 2.50'!I18","v":1278628}]
[{"$f":"MAX(A$13:A37)+1","v":19},null,"Total Environmental Compliance Operating Expense",null,null,{"$f":"SUM(F33:F37)","v":2261065}]
[]
[]
[{"$f":"A38+1","v":20},null,"Proceeds from Emission Allowance Sales (EAS)"]
[]
[{"$f":"A41+1","v":21},null,"SO2 Allowance Sales",null,null,0]
[{"$f":"A43+1","v":22},null,"NOx Allowances Sales",null,null,0]
[{"$f":"A44+1","v":23},null,"Total Emission Allowance Sales",null,null,{"$f":"SUM(F43:F44)","v":0}]
[]
[]
[{"$f":"A45+1","v":24},null,"(Over) / Under Recovery"]
[{"$f":"A48+1","v":25},null,"Adjusted Jurisdictional E(m) Authorized for Expense Month two Months Prior",null,null,{"$f":"Input!B14","v":1413676}]
[{"$f":"A49+1","v":26},null,"Jurisdictional E(m) Revenue Recovered in Current Expense Month",null,null,{"$f":"VLOOKUP(ExpMonth,Form3_Res,5,FALSE)+VLOOKUP(ExpMonth,Form3_Non,5,FALSE)","v":1540618}]
[{"$f":"A50+1","v":27},null,"(Over) / Under Recovery",null,null,{"$f":"F49-F50","v":-126942}]
[]
[null,null,"Note: (Over) recovery will be deducted from Jurisdictional E(m)"]
[null,null,"        Under recovery will be added to Jurisdictional E(m)"]

{"sheet":"FORM 2.10","index":5,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"ES FORM 2.10"]
[]
[null,{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[null,{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
[null,"Plant, Accumulated Depreciation, CWIP, ITC, ADIT"]
[null,"Depreciation Expense, Taxes Other Than Income Taxes"]
[]
[null,{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[]
[null,null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)","(8)","(9)"]
[null,null,null,"Gross",null,"Net","CWIP","Accumulated","Accumulated"]
[null,null,null,"Plant","Accumulated","Plant","Excluding","Deferred","Deferred",null,"Monthly"]
[null,"Project",null,"in-Service","Depreciation","in-Service","AFUDC","ITC","Tax Balance","Monthly","Property"]
[null,null,null,"as of","as of","as of","as of","as of","as of","Depreciation","Tax"]
[null,"No.","Description",{"$f":"ExpMonth","v":"2018-08-01"},"2018-08-01","2018-08-01","2018-08-01","2018-08-01","2018-08-01","Expense","Expense"]
[null,null,null,null,null,"(2)-(3)"]
[]
[null,1,"EB020290 Lined Retention Basin West",0,0,{"$f":"D20-E20","v":0},7080766,0,0,0,{"$f":"ROUND((F20+G20)*PropTax_Structures,0)","v":101071}]
[]
[null,2,"EB020745 Lined Retention Basin East",0,0,{"$f":"D22-E22","v":0},0,0,0,0,{"$f":"ROUND((F22+G22)*PropTax_Structures,0)","v":0}]
[]
[null,3,"EB020298 East Bend SW/PW Reroute",0,0,{"$f":"D24-E24","v":0},24916363,0,0,0,{"$f":"ROUND((F24+G24)*PropTax_Structures,0)","v":355656}]
[]
[null,4,null,null,null,{"$f":"D26-E26","v":0}]
[]
[null,5,null,null,null,{"$f":"D28-E28","v":0}]
[]
[null,6,null,null,null,{"$f":"D30-E30","v":0}]
[]
[null,7,null,null,null,{"$f":"D32-E32","v":0}]
[]
[null,8,null,null,null,{"$f":"D34-E34","v":0}]
[]
[null,9,null,null,null,{"$f":"D36-E36","v":0}]
[]
[null,10,null,null,null,{"$f":"D38-E38","v":0}]
[]
[null,11,null,null,null,{"$f":"D40-E40","v":0}]
[]
[null,12,null,null,null,{"$f":"D42-E42","v":0}]
[]
[null,13,null,null,null,{"$f":"D44-E44","v":0}]
[]
[null,14,null,null,null,{"$f":"D46-E46","v":0}]
[]
[null,15,null,null,null,{"$f":"D48-E48","v":0}]
[]
[]
[null,null,null,{"$f":"SUM(D20:D49)","v":0},{"$f":"SUM(E20:E49)","v":0},0,31997129,0,0,0,456727]

{"sheet":"FORM 2.20","index":6,"n_rows":178,"n_cols":14,"rows_kept":178,"cut":false,"hidden":false,"merged":[[133,1,133,2],[8,1,8,2],[10,1,10,2],[70,1,70,2],[72,1,72,2],[131,1,131,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ES FORM 2.20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 3"]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Amortization Calculation for Coal Ash ARO"]
[]
[]
[null,null,null,null,null,null,"Recovery:",null,null,null,"Recovery:",null,null,"Total"]
["Line","Period",null,"Cash Spend","COR Credit","Carrying Cost","10-Yr Amort.","Ending Balance",null,"Cash Spend","2-Month Cycle","Ending Balance",null,"Recovery"]
["No.","(1)",null,"(2)","(3)","(4)","(5)","(6)",null,"(7)","(8)","(9)",null,"(10) = (5) + (8)"]
[1,"2015 Total","Actual",3858084,-856412,20378,0,{"$f":"SUM(D12:G12)","v":3022050},null,0,0,0,{"$f":"B12","v":"2015 Total"},0]
[{"$f":"A12+1","v":2},"2016 Total","Actual",4486812,-107052,379037,0,{"$f":"SUM(D13:G13)+H12","v":7780847},null,0,0,null,{"$f":"B13","v":"2016 Total"},0]
[{"$f":"A13+1","v":3},"Jan-17","Actual",358148,0,43243,0,{"$f":"SUM(D14:G14)+H13","v":8182238},null,0,{"$f":"-J12","v":0},null,"Jan-17",0]
[{"$f":"A14+1","v":4},"Feb-17","Actual",424021,0,40351,0,8646610,null,0,{"$f":"-J13","v":0},null,"Feb-17",0]
[{"$f":"A15+1","v":5},"Mar-17","Actual",692184,-26763,44724,0,9356755,null,0,0,null,"Mar-17",0]
[6,"Apr-17","Actual",254067,0,50949,0,9661771,null,0,0,null,"Apr-17",0]
[7,"May-17","Actual",608377,0,56141,0,10326289,null,0,0,null,"May-17",0]
[8,"Jun-17","Actual",265619,-26763,53472,0,10618617,null,0,0,null,"Jun-17",0]
[9,"Jul-17","Actual",220636,0,51558,0,10890811,null,0,0,null,"Jul-17",0]
[10,"Aug-17","Actual",272053,0,47731,0,11210595,null,0,0,null,"Aug-17",0]
[11,"Sep-17","Actual",233743,-26763,44389,0,11461964,null,0,0,null,"Sep-17",0]
[12,"Oct-17","Actual",444793,0,60670,0,11967427,null,0,0,null,"Oct-17",0]
[13,"Nov-17","Actual",525770,0,68573,0,12561770,null,0,0,null,"Nov-17",0]
[14,"Dec-17","Actual",2482493,-26763,82850,0,15100350,null,0,0,null,"Dec-17",0]
[15,"Jan-18","Actual",510525,0,91185,0,15702060,null,0,0,null,"Jan-18",0]
[16,"Feb-18","Actual",89648,0,91534,0,15883242,null,0,0,null,"Feb-18",0]
[17,"Mar-18","Actual",396977,-26763,93696,0,16347152,null,0,0,null,"Mar-18",0]
[18,"Apr-18","Actual",132294,0,111722,0,16591168,null,173000,0,{"$f":"L28+J29+K29","v":173000},"Apr-18",0]
[19,"May-18","Actual",null,0,112480,0,16703648,null,100234,0,{"$f":"L29+J30+K30","v":273234},"May-18",0]
[20,"Jun-18","Actual",null,0,111870,-202486,16613032,null,150901,-173000,251135,"Jun-18",{"$f":"K31+G31","v":-375486}]
[21,"Jul-18","Actual",null,0,111255,-202486,16521801,null,196585,-100234,347486,"Jul-18",{"$f":"K32+G32","v":-302720}]
[22,"Aug-18","Actual",null,0,110637,-202486,16429952,null,321815,-150901,518400,"Aug-18",-353387]
[23,"Sep-18","Actual",null,0,110014,-202486,16337480,null,0,-196585,321815,"Sep-18",-399071]
[24,"Oct-18","Actual",null,0,109387,-202486,16244381,null,0,-321815,0,"Oct-18",-524301]
[25,"Nov-18","Actual",null,0,108756,-202486,16150651,null,0,0,0,"Nov-18",-202486]
[26,"Dec-18","Actual",null,0,108121,-202486,16056286,null,0,0,0,"Dec-18",-202486]
[27,"Jan-19","Actual",null,0,107481,-202486,15961281,null,0,0,0,"Jan-19",-202486]
[28,"Feb-19","Actual",null,0,106837,-202486,15865632,null,0,0,0,"Feb-19",-202486]
[29,"Mar-19","Actual",null,0,106188,-202486,15769334,null,0,0,0,"Mar-19",-202486]
[30,"Apr-19","Actual",null,0,105535,-202486,15672383,null,0,0,0,"Apr-19",-202486]
[31,"May-19","Actual",null,0,104878,-202486,15574775,null,0,0,0,"May-19",-202486]
[32,"Jun-19","Actual",null,0,104216,-202486,15476505,null,0,0,0,"Jun-19",-202486]
[33,"Jul-19","Actual",null,0,103550,-202486,15377569,null,0,0,0,"Jul-19",-202486]
[34,"Aug-19","Actual",null,0,102880,-202486,15277963,null,0,0,0,"Aug-19",-202486]
[35,"Sep-19","Actual",null,0,102204,-202486,15177681,null,0,0,0,"Sep-19",-202486]
[36,"Oct-19","Actual",null,0,101524,-202486,15076719,null,0,0,0,"Oct-19",-202486]
[37,"Nov-19","Actual",null,0,100840,-202486,14975073,null,0,0,0,"Nov-19",-202486]
[38,"Dec-19","Actual",null,0,100151,-202486,14872738,null,0,0,0,"Dec-19",-202486]
[39,"Jan-20","Actual",null,0,99457,-202486,14769709,null,0,0,0,"Jan-20",-202486]
[40,"Feb-20","Actual",null,0,98759,-202486,14665982,null,0,0,0,"Feb-20",-202486]
[41,"Mar-20","Actual",null,0,98055,-202486,14561551,null,0,0,0,"Mar-20",-202486]
[42,"Apr-20","Actual",null,0,97347,-202486,14456412,null,0,0,0,"Apr-20",-202486]
[43,"May-20","Actual",null,0,96635,-202486,14350561,null,0,0,0,"May-20",-202486]
[44,"Jun-20","Actual",null,0,95917,-202486,14243992,null,0,0,0,"Jun-20",-202486]
[45,"Jul-20","Actual",null,0,95194,-202486,14136700,null,0,0,0,"Jul-20",-202486]
[46,"Aug-20","Actual",null,0,94467,-202486,14028681,null,0,0,0,"Aug-20",-202486]
[47,"Sep-20","Actual",null,0,93735,-202486,13919930,null,0,0,0,"Sep-20",-202486]
[48,"Oct-20","Actual",null,0,92997,-202486,13810441,null,0,0,0,"Oct-20",-202486]
[49,"Nov-20","Actual",null,0,92255,-202486,13700210,null,0,0,0,"Nov-20",-202486]
[50,"Dec-20","Actual",null,0,91508,-202486,13589232,null,0,0,0,"Dec-20",-202486]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ES FORM 2.20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 3"]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Amortization Calculation for Coal Ash ARO"]
[]
[]
[null,null,null,null,null,null,"Recovery:",null,null,null,"Recovery:",null,null,"Total"]
["Line","Period",null,"Cash Spend","COR Credit","Carrying Cost","10-Yr Amort.","Ending Balance",null,"Cash Spend","2-Month Cycle","Ending Balance",null,"Recovery"]
["No.","(1)",null,"(2)","(3)","(4)","(5)","(6)",null,"(7)","(8)","(9)",null,"(10) = (5) + (8)"]
[{"$f":"A61+1","v":51},"Jan-21","Actual",null,0,90756,-202486,{"$f":"SUM(D74:G74)+H61","v":13477502},null,0,{"$f":"-J60","v":0},{"$f":"L61+J74+K74","v":0},"Jan-21",-202486]
[52,"Feb-21","Actual",null,0,89998,-202486,13365014,null,0,{"$f":"-J61","v":0},0,"Feb-21",-202486]
[53,"Mar-21","Actual",null,0,89235,-202486,13251763,null,0,0,0,"Mar-21",-202486]
[54,"Apr-21","Actual",null,0,88468,-202486,13137745,null,0,0,0,"Apr-21",-202486]
[55,"May-21","Actual",null,0,87695,-202486,13022954,null,0,0,0,"May-21",-202486]
[56,"Jun-21","Actual",null,0,86916,-202486,12907384,null,0,0,0,"Jun-21",-202486]
[57,"Jul-21","Actual",null,0,86133,-202486,12791031,null,0,0,0,"Jul-21",-202486]
[58,"Aug-21","Actual",null,0,85344,-202486,12673889,null,0,0,0,"Aug-21",-202486]
[59,"Sep-21","Actual",null,0,84550,-202486,12555953,null,0,0,0,"Sep-21",-202486]
[60,"Oct-21","Actual",null,0,83750,-202486,12437217,null,0,0,0,"Oct-21",-202486]
[61,"Nov-21","Actual",null,0,82945,-202486,12317676,null,0,0,0,"Nov-21",-202486]
[62,"Dec-21","Actual",null,0,82135,-202486,12197325,null,0,0,0,"Dec-21",-202486]
[63,"Jan-22","Actual",null,0,81319,-202486,12076158,null,0,0,0,"Jan-22",-202486]
[64,"Feb-22","Actual",null,0,80498,-202486,11954170,null,0,0,0,"Feb-22",-202486]
[65,"Mar-22","Actual",null,0,79671,-202486,11831355,null,0,0,0,"Mar-22",-202486]
[66,"Apr-22","Actual",null,0,78838,-202486,11707707,null,0,0,0,{"$f":"B89","v":"Apr-22"},-202486]
[67,"May-22","Actual",null,0,78000,-202486,{"$f":"SUM(D90:G90)+H89","v":11583221},null,0,0,0,"May-22",-202486]
[68,"Jun-22","Actual",null,0,77156,-202486,11457891,null,0,{"$f":"-J89","v":0},0,"Jun-22",-202486]
[{"$f":"A91+1","v":69},"Jul-22","Actual",null,0,76306,-202486,11331711,null,0,0,0,"Jul-22",-202486]
[70,"Aug-22","Actual",null,0,75451,-202486,11204676,null,0,0,0,"Aug-22",-202486]
[71,"Sep-22","Actual",null,0,74589,-202486,11076779,null,0,0,0,"Sep-22",-202486]
[72,"Oct-22","Actual",null,0,73722,-202486,10948015,null,0,0,0,"Oct-22",-202486]
[73,"Nov-22","Actual",null,0,72849,-202486,10818378,null,0,0,0,"Nov-22",-202486]
[74,"Dec-22","Actual",null,0,71971,-202486,10687863,null,0,0,0,"Dec-22",-202486]
[75,"Jan-23","Actual",null,0,71086,-202486,10556463,null,0,0,0,"Jan-23",-202486]
[76,"Feb-23","Actual",null,0,70195,-202486,10424172,null,0,0,0,"Feb-23",-202486]
[77,"Mar-23","Actual",null,0,69298,-202486,10290984,null,0,0,0,"Mar-23",-202486]
[78,"Apr-23","Actual",null,0,68395,-202486,10156893,null,0,0,0,"Apr-23",-202486]
[79,"May-23","Actual",null,0,67486,-202486,10021893,null,0,0,0,"May-23",-202486]
[80,"Jun-23","Actual",null,0,66571,-202486,9885978,null,0,0,0,"Jun-23",-202486]
[81,"Jul-23","Actual",null,0,65649,-202486,9749141,null,0,0,0,"Jul-23",-202486]
[82,"Aug-23","Actual",null,0,64722,-202486,9611377,null,0,0,0,"Aug-23",-202486]
[83,"Sep-23","Actual",null,0,63788,-202486,9472679,null,0,0,{"$f":"L105+J106+K106","v":0},"Sep-23",-202486]
[84,"Oct-23","Actual",null,0,62847,-202486,9333040,null,0,0,0,"Oct-23",-202486]
[85,"Nov-23","Actual",null,0,61901,-202486,9192455,null,0,0,0,"Nov-23",{"$f":"K108+G108","v":-202486}]
[86,"Dec-23","Actual",null,0,60948,-202486,9050917,null,0,0,0,"Dec-23",-202486]
[87,"Jan-24","Actual",null,0,59988,-202486,8908419,null,0,0,0,"Jan-24",-202486]
[88,"Feb-24","Actual",null,0,59022,-202486,8764955,null,0,0,0,"Feb-24",-202486]
[89,"Mar-24","Actual",null,0,58049,-202486,8620518,null,0,0,0,"Mar-24",-202486]
[90,"Apr-24","Actual",null,0,57070,-202486,8475102,null,0,0,0,"Apr-24",-202486]
[91,"May-24","Actual",null,0,56084,-202486,8328700,null,0,0,0,"May-24",-202486]
[92,"Jun-24","Actual",null,0,55092,-202486,8181306,null,0,0,0,"Jun-24",-202486]
[93,"Jul-24","Actual",null,0,54093,-202486,8032913,null,0,0,0,"Jul-24",-202486]
[94,"Aug-24","Actual",null,0,53087,-202486,7883514,null,0,0,0,"Aug-24",-202486]
[95,"Sep-24","Actual",null,0,52074,-202486,7733102,null,0,0,0,"Sep-24",-202486]
[96,"Oct-24","Actual",null,0,51054,-202486,7581670,null,0,0,0,"Oct-24",-202486]
[97,"Nov-24","Actual",null,0,50027,-202486,7429211,null,0,0,0,"Nov-24",-202486]
[98,"Dec-24","Actual",null,0,48994,-202486,7275719,null,0,0,0,"Dec-24",-202486]
[99,"Jan-25","Actual",null,0,47953,-202486,7121186,null,0,0,0,"Jan-25",-202486]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ES FORM 2.20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 3"]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Amortization Calculation for Coal Ash ARO"]
[]
[]
[null,null,null,null,null,null,"Recovery:",null,null,null,"Recovery:",null,null,"Total"]
["Line","Period",null,"Cash Spend","COR Credit","Carrying Cost","10-Yr Amort.","Ending Balance",null,"Cash Spend","2-Month Cycle","Ending Balance",null,"Recovery"]
["No.","(1)",null,"(2)","(3)","(4)","(5)","(6)",null,"(7)","(8)","(9)",null,"(10) = (5) + (8)"]
[{"$f":"A122+1","v":100},"Feb-25","Actual",null,0,46906,-202486,{"$f":"SUM(D135:G135)+H122","v":6965606},null,0,{"$f":"-J121","v":0},{"$f":"L122+J135+K135","v":0},"Feb-25",-202486]
[101,"Mar-25","Actual",null,0,45851,-202486,6808971,null,0,{"$f":"-J122","v":0},0,"Mar-25",-202486]
[102,"Apr-25","Actual",null,0,44789,-202486,6651274,null,0,0,0,"Apr-25",-202486]
[103,"May-25","Actual",null,0,43720,-202486,6492508,null,0,0,0,"May-25",-202486]
[104,"Jun-25","Actual",null,0,42643,-202486,6332665,null,0,0,0,"Jun-25",-202486]
[105,"Jul-25","Actual",null,0,41560,-202486,6171739,null,0,0,0,"Jul-25",-202486]
[106,"Aug-25","Actual",null,0,40469,-202486,6009722,null,0,0,0,"Aug-25",-202486]
[107,"Sep-25","Actual",null,0,39370,-202486,5846606,null,0,0,0,"Sep-25",-202486]
[108,"Oct-25","Actual",null,0,38265,-202486,5682385,null,0,0,0,"Oct-25",-202486]
[109,"Nov-25","Actual",null,0,37151,-202486,5517050,null,0,0,0,"Nov-25",-202486]
[110,"Dec-25","Actual",null,0,36030,-202486,5350594,null,0,0,0,"Dec-25",-202486]
[111,"Jan-26","Actual",null,0,34902,-202486,5183010,null,0,0,0,"Jan-26",-202486]
[112,"Feb-26","Actual",null,0,33766,-202486,5014290,null,0,0,0,"Feb-26",-202486]
[113,"Mar-26","Actual",null,0,32622,-202486,4844426,null,0,0,0,"Mar-26",-202486]
[114,"Apr-26","Actual",null,0,31470,-202486,4673410,null,0,0,0,"Apr-26",-202486]
[115,"May-26","Actual",null,0,30311,-202486,4501235,null,0,0,0,"May-26",-202486]
[116,"Jun-26","Actual",null,0,29144,-202486,4327893,null,0,0,0,"Jun-26",-202486]
[117,"Jul-26","Actual",null,0,27968,-202486,4153375,null,0,0,0,"Jul-26",-202486]
[118,"Aug-26","Actual",null,0,26785,-202486,3977674,null,0,0,0,"Aug-26",-202486]
[119,"Sep-26","Actual",null,0,25594,-202486,3800782,null,0,0,0,"Sep-26",-202486]
[120,"Oct-26","Actual",null,0,24395,-202486,3622691,null,0,0,0,"Oct-26",-202486]
[121,"Nov-26","Actual",null,0,23188,-202486,3443393,null,0,0,0,"Nov-26",-202486]
[122,"Dec-26","Actual",null,0,21972,-202486,3262879,null,0,0,0,"Dec-26",-202486]
[123,"Jan-27","Actual",null,0,20748,-202486,3081141,null,0,0,0,"Jan-27",-202486]
[124,"Feb-27","Actual",null,0,19516,-202486,2898171,null,0,0,0,"Feb-27",-202486]
[125,"Mar-27","Actual",null,0,18276,-202486,2713961,null,0,0,0,"Mar-27",-202486]
[126,"Apr-27","Actual",null,0,17027,-202486,2528502,null,0,0,0,"Apr-27",-202486]
[127,"May-27","Actual",null,0,15769,-202486,2341785,null,0,0,0,"May-27",-202486]
[128,"Jun-27","Actual",null,0,14504,-202486,2153803,null,0,0,0,"Jun-27",-202486]
[129,"Jul-27","Actual",null,0,13229,-202486,1964546,null,0,0,0,"Jul-27",-202486]
[130,"Aug-27","Actual",null,0,11946,-202486,1774006,null,0,0,0,{"$f":"B165","v":"Aug-27"},-202486]
[131,"Sep-27","Actual",null,0,10654,-202486,{"$f":"SUM(D166:G166)+H165","v":1582174},null,0,0,0,"Sep-27",-202486]
[132,"Oct-27","Actual",null,0,9354,-202486,1389042,null,0,{"$f":"-J165","v":0},0,"Oct-27",-202486]
[{"$f":"A167+1","v":133},"Nov-27","Actual",null,0,8045,-202486,1194601,null,0,0,0,"Nov-27",-202486]
[134,"Dec-27","Actual",null,0,6726,-202486,998841,null,0,0,0,"Dec-27",-202486]
[135,"Jan-28","Actual",null,0,5399,-202486,801754,null,0,0,0,"Jan-28",-202486]
[136,"Feb-28","Actual",null,0,4063,-202486,603331,null,0,0,0,"Feb-28",-202486]
[137,"Mar-28","Actual",null,0,2718,-202486,403563,null,0,0,0,"Mar-28",-202486]
[138,"Apr-28","Actual",null,0,1409,-202486,202486,null,0,0,0,"Apr-28",-202486]
[139,"May-28","Actual",null,0,0,-202486,0,null,0,0,0,"May-28",-202486]
[null,null,null,{"$f":"SUM(D12:D174)","v":16256244},{"$f":"SUM(E12:E174)","v":-1097279},{"$f":"SUM(F12:F174)","v":9139355},{"$f":"SUM(G12:G174)","v":-24298320},null,null,{"$f":"SUM(J12:J174)","v":942535},-942535,null,null,{"$f":"SUM(N12:N174)","v":-25240855}]
[]
[]
[null,"Monthly Amortization Amount",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(VLOOKUP(TEXT(EDATE(ExpMonth,2),\"mmm-yy\"),AROamortization,2,FALSE),0)","v":-524301}]

{"sheet":"FORM 2.30","index":7,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,1,10,6],[33,1,33,6],[34,1,34,6]]}
[null,null,null,null,null,null,"ES FORM 2.30"]
[]
[null,{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[null,{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
[null,"Inventory and Expense of Emission Allowances"]
[]
[null,{"$f":"\"For the Expense Month Ending \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month Ending August 2018"}]
[]
[]
[null,"Total SO2 and NOx Emission Allowances"]
[null,null,"Beginning","Allocations /",null,null,"Ending"]
[null,null,"Inventory","Purchases","Utilized","Sold","Inventory"]
[]
[null,"SO2 Allowances - Acid Rain Program (a)"]
[null,"Quantity",111128,null,207,0,{"$f":"C16+D16-E16-F16","v":110921}]
[null,"Dollars",17299.55,0,33.119999999999997,0,{"$f":"C17+D17-E17-F17","v":17266.43}]
[null,"$/Allowance",{"$f":"IF(C16=0,0,ROUND(C17/C16,6))","v":0.155672},{"$f":"IF(D16=0,0,ROUND(D17/D16,6))","v":0},{"$f":"IF(E16=0,0,ROUND(E17/E16,6))","v":0.16},{"$f":"IF(F16=0,0,ROUND(F17/F16,6))","v":0},{"$f":"IF(G16=0,0,ROUND(G17/G16,6))","v":0.155664}]
[]
[null,"NOx Allowances - Annual"]
[null,"Quantity",5708,null,227,0,{"$f":"C21+D21-E21-F21","v":5481}]
[null,"Dollars",5342.23,0,213.38,0,{"$f":"C22+D22-E22-F22","v":5128.8499999999995}]
[null,"$/Allowance",{"$f":"IF(C21=0,0,ROUND(C22/C21,6))","v":0.93591999999999997},{"$f":"IF(D21=0,0,ROUND(D22/D21,6))","v":0},{"$f":"IF(E21=0,0,ROUND(E22/E21,6))","v":0.94},{"$f":"IF(F21=0,0,ROUND(F22/F21,6))","v":0},{"$f":"IF(G21=0,0,ROUND(G22/G21,6))","v":0.935751}]
[]
[null,"NOx Allowances - Seasonal"]
[null,"Quantity",1149,null,227,0,{"$f":"C26+D26-E26-F26","v":922}]
[null,"Dollars",5884.95,0,1162.24,0,{"$f":"C27+D27-E27-F27","v":4722.71}]
[null,"$/Allowance",{"$f":"IF(C26=0,0,ROUND(C27/C26,6))","v":5.1218019999999997},{"$f":"IF(D26=0,0,ROUND(D27/D26,6))","v":0},{"$f":"IF(E26=0,0,ROUND(E27/E26,6))","v":5.12},{"$f":"IF(F26=0,0,ROUND(F27/F26,6))","v":0},{"$f":"IF(G26=0,0,ROUND(G27/G26,6))","v":5.1222450000000004}]
[]
[null,"Total Emission Allowances"]
[null,"Quantity",{"$f":"C16+C21+C26","v":117985},0,661,0,117324]
[null,"Dollars",28526.73,0,{"$f":"E17+E22+E27","v":1408.74},0,27117.989999999998]
[]
[null,"(a) Note: The SO2 Allowances exclude the CSSO2G1 Program Allowances as there is no dollar value associated with this program inventory.  Thus, there is no expense booked to the ledger as a result of the program."]

{"sheet":"FORM 2.50","index":8,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"ES FORM 2.50"]
[]
[{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
["Environmental Reagent Expenses"]
[]
[{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[]
["Line",null,null,null,"Account",null,"East Bend"]
["No.",null,"Expense Type",null,"Number",null,"Unit 2",null,"Total"]
[]
[1,null,"Ammonia",null,502020,null,50645,null,{"$f":"G14","v":50645}]
[{"$f":"A14+1","v":2},null,"Lime",null,502040,null,1154185,null,{"$f":"G15","v":1154185}]
[{"$f":"A15+1","v":3},null,"Hydrated Lime",null,502040,null,73798,null,73798]
[]
[4,null,"Total",null,null,null,{"$f":"SUM(G14:G16)","v":1278628},null,{"$f":"SUM(I14:I16)","v":1278628}]

{"sheet":"FORM 3.00","index":9,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,1,63,5],[31,1,31,5],[33,1,33,5],[35,1,35,5],[59,1,59,5],[61,1,61,5]]}
[null,null,null,null,null,null,null,"ES FORM 3.00"]
[]
[null,{"$f":"Company","v":"DUKE ENERGY KENTUCKY, INC."}]
[null,{"$f":"Title","v":"ENVIRONMENTAL SURCHARGE REPORT"}]
[]
[null,"Monthly Average Revenue Computation of R(m) for Residential and Non-Residential Customers"]
[]
[null,{"$f":"\"For the Expense Month of \"&TEXT(ExpMonth,\"mmmm yyyy\")","v":"For the Expense Month of August 2018"}]
[]
[null,null,null,null,null,null,null,null,null,null,"Residential = RVCL 0"]
[null,"Residential - Kentucky Jurisdictional Revenues"]
[null,"(1)","(2)","(3)","(4)","(5)","(6)",null,null,null,"(3)","(4)"]
[null,null,null,null,null,null,"Total"]
[null,null,null,null,null,"Environmental","Excluding",null,null,null,"Base Rate","Fuel"]
[null,null,"Total",null,null,"Surcharge","Environmental",null,null,null,"Fuel","Clause"]
[null,"Month","Revenues",null,null,"Revenues","Surcharge",null,null,null,"Component","Revenues"]
[null,null,null,null,null,null,"(2) - (5)"]
[]
[null,{"$f":"EDATE(ExpMonth,-11)","v":"2017-09-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$19,TotRev))),0)","v":10036825},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$19,ESM))),0)","v":0},{"$f":"C19-F19","v":10036825},null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B19,BaseFuel))),0)","v":2766046},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B19,RiderFAC))),0)","v":-164082}]
[null,{"$f":"EDATE(ExpMonth,-10)","v":"2017-10-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$20,TotRev))),0)","v":8738582},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$20,ESM))),0)","v":0},8738582,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B20,BaseFuel))),0)","v":2503044},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B20,RiderFAC))),0)","v":-548638}]
[null,{"$f":"EDATE(ExpMonth,-9)","v":"2017-11-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$21,TotRev))),0)","v":8584302},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$21,ESM))),0)","v":0},8584302,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B21,BaseFuel))),0)","v":2281980},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B21,RiderFAC))),0)","v":68740}]
[null,{"$f":"EDATE(ExpMonth,-8)","v":"2017-12-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$22,TotRev))),0)","v":10686318},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$22,ESM))),0)","v":0},10686318,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B22,BaseFuel))),0)","v":2938285},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B22,RiderFAC))),0)","v":-109117}]
[null,{"$f":"EDATE(ExpMonth,-7)","v":"2018-01-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$23,TotRev))),0)","v":16073289},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$23,ESM))),0)","v":0},16073289,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B23,BaseFuel))),0)","v":4323072},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B23,RiderFAC))),0)","v":457047}]
[null,{"$f":"EDATE(ExpMonth,-6)","v":"2018-02-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$24,TotRev))),0)","v":11744958},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$24,ESM))),0)","v":0},11744958,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B24,BaseFuel))),0)","v":3259164},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B24,RiderFAC))),0)","v":24178}]
[null,{"$f":"EDATE(ExpMonth,-5)","v":"2018-03-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$25,TotRev))),0)","v":9705373},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$25,ESM))),0)","v":0},9705373,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B25,BaseFuel))),0)","v":2676311},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B25,RiderFAC))),0)","v":431877}]
[null,{"$f":"EDATE(ExpMonth,-4)","v":"2018-04-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$26,TotRev))),0)","v":9192616},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$26,ESM))),0)","v":0},9192616,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B26,BaseFuel))),0)","v":2613999},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B26,RiderFAC))),0)","v":114337}]
[null,{"$f":"EDATE(ExpMonth,-3)","v":"2018-05-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$27,TotRev))),0)","v":9225511},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$27,ESM))),0)","v":0},9225511,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B27,BaseFuel))),0)","v":2263987},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B27,RiderFAC))),0)","v":1058577}]
[null,{"$f":"EDATE(ExpMonth,-2)","v":"2018-06-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$28,TotRev))),0)","v":13041663},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$28,ESM))),0)","v":298777},12742886,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B28,BaseFuel))),0)","v":3251112},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B28,RiderFAC))),0)","v":1402488}]
[null,{"$f":"EDATE(ExpMonth,-1)","v":"2018-07-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$29,TotRev))),0)","v":15332757},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$29,ESM))),0)","v":383577},14949180,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B29,BaseFuel))),0)","v":3770604},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B29,RiderFAC))),0)","v":2012795}]
[null,{"$f":"ExpMonth","v":"2018-08-01"},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$30,TotRev))),0)","v":12716657},null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=$B$30,ESM))),0)","v":642457},12074200,null,null,null,{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B30,BaseFuel))),0)","v":3363068},{"$f":"ROUND(SUM(IF(RVCLS=0,IF(BillPeriod=B30,RiderFAC))),0)","v":379161}]
[]
[null,"Average Monthly Residential Revenues, Excluding Environmental Surcharge, for 12 Months Ending Current Expense Month",null,null,null,null,{"$f":"ROUND(AVERAGE(G19:G30),0)","v":11146170}]
[]
[null,"Average Total Kentucky Revenues, Excluding Environmental Surcharge, for 12 Months Ending Current Expense Month",null,null,null,null,{"$f":"G32+G60","v":27102113}]
[]
[null,"Residential Revenues as a Percentage of Total Revenues for 12 Months Ending with the Current Expense Month",null,null,null,null,{"$f":"IF(G34=0,0,ROUND(G32/G34,4))","v":0.4113}]
[]
[]
[null,"Non-Residential - Kentucky Jurisdictional Revenues",null,null,null,null,null,null,null,null,"Non-Residential = All Other RVCLS"]
[null,"(1)","(2)","(3)","(4)","(5)","(6)","(7)"]
[null,null,null,null,null,null,"Total"]
[null,null,null,"Base Rate","Fuel","Environmental","Excluding","Total"]
[null,null,"Total","Fuel","Clause","Surcharge","Environmental","Non-Fuel"]
[null,"Month","Revenues","Component","Revenues","Revenues","Surcharge","Revenue"]
[null,null,null,null,null,null,"(2) - (5)","(6) - (3) - (4)"]
[]
[null,{"$f":"EDATE(ExpMonth,-11)","v":"2017-09-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$47,TotRev))-C19,0)","v":15903029},{"$f":"ROUND(SUM(IF(BillPeriod=$B$47,BaseFuel))-K19,0)","v":5373508},{"$f":"ROUND(SUM(IF(BillPeriod=$B$47,RiderFAC))-L19,0)","v":-316965},{"$f":"ROUND(SUM(IF(BillPeriod=$B$47,ESM))-F19,0)","v":0},{"$f":"C47-F47","v":15903029},{"$f":"G47-D47-E47","v":10846486}]
[null,{"$f":"EDATE(ExpMonth,-10)","v":"2017-10-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$48,TotRev))-C20,0)","v":14064282},{"$f":"ROUND(SUM(IF(BillPeriod=$B$48,BaseFuel))-K20,0)","v":5004912},{"$f":"ROUND(SUM(IF(BillPeriod=$B$48,RiderFAC))-L20,0)","v":-1086872},{"$f":"ROUND(SUM(IF(BillPeriod=$B$48,ESM))-F20,0)","v":0},14064282,{"$f":"G48-D48-E48","v":10146242}]
[null,{"$f":"EDATE(ExpMonth,-9)","v":"2017-11-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$49,TotRev))-C21,0)","v":14457057},{"$f":"ROUND(SUM(IF(BillPeriod=$B$49,BaseFuel))-K21,0)","v":4776618},{"$f":"ROUND(SUM(IF(BillPeriod=$B$49,RiderFAC))-L21,0)","v":92796},{"$f":"ROUND(SUM(IF(BillPeriod=$B$49,ESM))-F21,0)","v":0},14457057,9587643]
[null,{"$f":"EDATE(ExpMonth,-8)","v":"2017-12-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$50,TotRev))-C22,0)","v":14438593},{"$f":"ROUND(SUM(IF(BillPeriod=$B$50,BaseFuel))-K22,0)","v":4921948},{"$f":"ROUND(SUM(IF(BillPeriod=$B$50,RiderFAC))-L22,0)","v":-172877},{"$f":"ROUND(SUM(IF(BillPeriod=$B$50,ESM))-F22,0)","v":0},14438593,9689522]
[null,{"$f":"EDATE(ExpMonth,-7)","v":"2018-01-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$51,TotRev))-C23,0)","v":16089643},{"$f":"ROUND(SUM(IF(BillPeriod=$B$51,BaseFuel))-K23,0)","v":5218344},{"$f":"ROUND(SUM(IF(BillPeriod=$B$51,RiderFAC))-L23,0)","v":546874},{"$f":"ROUND(SUM(IF(BillPeriod=$B$51,ESM))-F23,0)","v":0},16089643,10324425]
[null,{"$f":"EDATE(ExpMonth,-6)","v":"2018-02-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$52,TotRev))-C24,0)","v":14714026},{"$f":"ROUND(SUM(IF(BillPeriod=$B$52,BaseFuel))-K24,0)","v":4857707},{"$f":"ROUND(SUM(IF(BillPeriod=$B$52,RiderFAC))-L24,0)","v":37207},{"$f":"ROUND(SUM(IF(BillPeriod=$B$52,ESM))-F24,0)","v":0},14714026,9819112]
[null,{"$f":"EDATE(ExpMonth,-5)","v":"2018-03-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$53,TotRev))-C25,0)","v":14704676},{"$f":"ROUND(SUM(IF(BillPeriod=$B$53,BaseFuel))-K25,0)","v":4684206},{"$f":"ROUND(SUM(IF(BillPeriod=$B$53,RiderFAC))-L25,0)","v":731789},{"$f":"ROUND(SUM(IF(BillPeriod=$B$53,ESM))-F25,0)","v":0},14704676,9288681]
[null,{"$f":"EDATE(ExpMonth,-4)","v":"2018-04-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$54,TotRev))-C26,0)","v":14331036},{"$f":"ROUND(SUM(IF(BillPeriod=$B$54,BaseFuel))-K26,0)","v":4767544},{"$f":"ROUND(SUM(IF(BillPeriod=$B$54,RiderFAC))-L26,0)","v":200332},{"$f":"ROUND(SUM(IF(BillPeriod=$B$54,ESM))-F26,0)","v":0},14331036,9363160]
[null,{"$f":"EDATE(ExpMonth,-3)","v":"2018-05-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$55,TotRev))-C27,0)","v":16761608},{"$f":"ROUND(SUM(IF(BillPeriod=$B$55,BaseFuel))-K27,0)","v":4821687},{"$f":"ROUND(SUM(IF(BillPeriod=$B$55,RiderFAC))-L27,0)","v":2218031},{"$f":"ROUND(SUM(IF(BillPeriod=$B$55,ESM))-F27,0)","v":0},16761608,9721890]
[null,{"$f":"EDATE(ExpMonth,-2)","v":"2018-06-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$56,TotRev))-C28,0)","v":19350865},{"$f":"ROUND(SUM(IF(BillPeriod=$B$56,BaseFuel))-K28,0)","v":5564309},{"$f":"ROUND(SUM(IF(BillPeriod=$B$56,RiderFAC))-L28,0)","v":2385574},{"$f":"ROUND(SUM(IF(BillPeriod=$B$56,ESM))-F28,0)","v":433158},18917707,10967824]
[null,{"$f":"EDATE(ExpMonth,-1)","v":"2018-07-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$57,TotRev))-C29,0)","v":20520965},{"$f":"ROUND(SUM(IF(BillPeriod=$B$57,BaseFuel))-K29,0)","v":5713914},{"$f":"ROUND(SUM(IF(BillPeriod=$B$57,RiderFAC))-L29,0)","v":3024833},{"$f":"ROUND(SUM(IF(BillPeriod=$B$57,ESM))-F29,0)","v":514138},20006827,11268080]
[null,{"$f":"ExpMonth","v":"2018-08-01"},{"$f":"ROUND(SUM(IF(BillPeriod=$B$58,TotRev))-C30,0)","v":17980988},{"$f":"ROUND(SUM(IF(BillPeriod=$B$58,BaseFuel))-K30,0)","v":5529498},{"$f":"ROUND(SUM(IF(BillPeriod=$B$58,RiderFAC))-L30,0)","v":628882},{"$f":"ROUND(SUM(IF(BillPeriod=$B$58,ESM))-F30,0)","v":898161},17082827,10924447]
[]
[null,"Average Monthly Non-Residential Revenues, Excluding Environmental Surcharge, for 12 Months Ending Current Expense Month",null,null,null,null,{"$f":"ROUND(AVERAGE(G47:G58),0)","v":15955943},{"$f":"ROUND(AVERAGE(H47:H58),0)","v":10162293}]
[]
[null,"Average Total Kentucky Revenues, Excluding Environmental Surcharge, for 12 Months Ending Current Expense Month",null,null,null,null,{"$f":"G32+G60","v":27102113}]
[]
[null,"Non-Residential Revenues as a Percentage of Total Revenues for 12 Months Ending with the Current Expense Month",null,null,null,null,{"$f":"IF(G62=0,0,ROUND(G60/G62,4))","v":0.5887}]

{"sheet":"Revenue","index":10,"n_rows":1283,"n_cols":14,"rows_kept":1283,"cut":false,"hidden":false,"merged":[]}
["Source: MW_RAC_044"]
[null,null,"Bill"]
["Class","Revcls","Period","Unbilled","Billed","Total","BaseFuel","DSM","FAC","PSM","ESM","BaseRev","TotalBilled"]
["Residential",0,"2017-05-01",784453,7508315,{"$f":"D4+E4","v":8292768},2588234,706329,-801494,-135356,0,5150602,{"$f":"SUM(G4:L4)","v":7508315},{"$f":"E4=M4","v":true}]
["Commercial",2,"2017-05-01",223617,8137894,{"$f":"D5+E5","v":8361511},3344724,295277,-1037055,-175342,0,5710290,{"$f":"SUM(G5:L5)","v":8137894},true]
["Industrial",4,"2017-05-01",162141,3929156,{"$f":"D6+E6","v":4091297},1932761,132522,-590393,-101113,0,2555379,3929156,true]
["Lighting",15,"2017-05-01",0,127100,127100,36136,260,-11195,-1886,0,103785,127100,true]
["OPA",16,"2017-05-01",63810,1560496,1624306,665147,50452,-205394,-34716,0,{"$f":"1085006+1","v":1085007},1560496,true]
["Residential",0,"2017-06-01",940089,9659183,10599272,3378933,923266,-1029257,-174137,0,6560378,9659183,true]
["Commercial",2,"2017-06-01",565911,9006447,9572358,3746715,331662,-1143025,-193511,0,{"$f":"6264608-2","v":6264606},9006447,true]
["Industrial",4,"2017-06-01",278841,4218650,4497491,2014732,139633,-601392,-103795,0,{"$f":"2769473-1","v":2769472},4218650,true]
["Lighting",15,"2017-06-01",0,119193,119193,33812,235,-10337,-1739,0,97222,119193,true]
["OPA",16,"2017-06-01",115294,1506064,1621358,602156,45082,-189778,-31869,0,{"$f":"1080472+1","v":1080473},1506064,true]
["Residential",0,"2017-07-01",1301409,12661898,13963307,4176245,1141439,-415742,-215265,0,{"$f":"7975220+1","v":7975221},12661898,true]
["Commercial",2,"2017-07-01",224801,10326875,10551676,3991980,353441,-398582,-206002,0,6586038,10326875,true]
["Industrial",4,"2017-07-01",38403,4666134,4704537,2019527,140063,-196673,-104031,0,2807248,4666134,true]
["Lighting",15,"2017-07-01",0,142099,142099,38253,253,-4277,-1970,0,109840,142099,true]
["OPA",16,"2017-07-01",30351,1922746,1953097,748931,57734,-79172,-37665,0,1232918,1922746,true]
["Residential",0,"2017-08-01",-948589,12185554,11236965,4074108,1113648,-587185,-210043,0,{"$f":"7795025+1","v":7795026},12185554,true]
["Commercial",2,"2017-08-01",56940,10011077,10068017,3897817,345569,-563132,-201306,0,6532129,10011077,true]
["Industrial",4,"2017-08-01",108915,4705420,4814335,2089197,144525,-294245,-107611,0,2873554,4705420,true]
["Lighting",15,"2017-08-01",0,132171,132171,35841,234,-5180,-1845,0,{"$f":"103120+1","v":103121},132171,true]
["OPA",16,"2017-08-01",44537,1825858,1870395,725160,55760,-104233,-37262,0,{"$f":"1186432+1","v":1186433},1825858,true]
["Residential",0,"2017-09-01",-443981,10036825,9592844,2766046,923855,-164082,-52907,0,{"$f":"6563912+1","v":6563913},10036825,true]
["Commercial",2,"2017-09-01",-385833,9450649,9064816,3075967,332194,-183449,-59281,0,{"$f":"6285217+1","v":6285218},9450649,true]
["Industrial",4,"2017-09-01",-252900,4518823,4265923,1679520,142197,-96993,-32054,0,2826153,4518823,true]
["Lighting",15,"2017-09-01",0,131617,131617,29778,284,-1765,-548,0,103868,131617,true]
["OPA",16,"2017-09-01",-114713,1801940,1687227,588243,55416,-34758,-11210,0,1204249,1801940,true]
["Residential",0,"2017-10-01",-705141,8738582,8033441,2503044,835843,-548638,-47728,0,{"$f":"5996060+1","v":5996061},8738582,true]
["Commercial",2,"2017-10-01",100478,8337514,8437992,2821070,305154,-617548,-54006,0,{"$f":"5882843+1","v":5882844},8337514,true]
["Industrial",4,"2017-10-01",202345,3986829,4189174,1597329,134004,-341465,-30508,0,{"$f":"2627468+1","v":2627469},3986829,true]
["Lighting",15,"2017-10-01",0,127281,127281,29928,300,-6562,-551,0,104166,127281,true]
["OPA",16,"2017-10-01",102272,1612658,1714930,556585,52319,-121297,-10475,0,{"$f":"1135527-1","v":1135526},1612658,true]
["Residential",0,"2017-11-01",1280257,8584302,9864559,2281980,761901,68740,-43566,0,5515247,8584302,true]
["Commercial",2,"2017-11-01",62729,8455289,8518018,2634821,284719,51495,-50435,0,5534689,8455289,true]
["Industrial",4,"2017-11-01",-77061,4226492,4149431,1570102,129885,30093,-29995,0,2526407,4226492,true]
["Lighting",15,"2017-11-01",0,135387,135387,30389,349,573,-560,0,104636,135387,true]
["OPA",16,"2017-11-01",-2477,1639889,1637412,541306,49810,10635,-10302,0,1048440,1639889,true]
["Residential",0,"2017-12-01",2183729,10686318,12870047,2938285,981309,-109117,-60937,0,{"$f":"6936777+1","v":6936778},10686318,true]
["Commercial",2,"2017-12-01",144604,8577566,8722170,2747849,297692,-96837,-56814,0,{"$f":"5685675+1","v":5685676},8577566,true]
["Industrial",4,"2017-12-01",-50660,4176862,4126202,1612481,134777,-56195,-33300,0,{"$f":"2519098+1","v":2519099},4176862,true]
["Lighting",15,"2017-12-01",0,133921,133921,30482,366,-1098,-607,0,{"$f":"104779-1","v":104778},133921,true]
["OPA",16,"2017-12-01",14000,1550244,1564244,531136,48848,-18747,-10928,0,999935,1550244,true]
["Residential",0,"2018-01-01",-2009512,16073289,14063777,4323072,1444510,457047,-89396,0,{"$f":"9938055+1","v":9938056},16073289,true]
["Commercial",2,"2018-01-01",-685804,9911332,9225528,3072865,334780,323406,-63777,0,{"$f":"6244060-2","v":6244058},9911332,true]
["Industrial",4,"2018-01-01",-344589,4281321,3936732,1534189,128466,158615,-31692,0,2491743,4281321,true]
["Lighting",15,"2018-01-01",0,114155,114155,24356,389,3447,-485,0,{"$f":"86447+1","v":86448},114155,true]
["OPA",16,"2018-01-01",-204643,1782835,1578192,586934,53911,61406,-12140,0,{"$f":"1092723+1","v":1092724},1782835,true]
["Residential",0,"2018-02-01",-604918,11744958,11140040,3259164,894041,24178,-67395,0,7634970,11744958,true]
["Commercial",2,"2018-02-01",-198544,8825962,8627418,2751166,296781,21324,-57105,0,5813796,8825962,true]
["Industrial",4,"2018-02-01",-115938,4105599,3989661,1525627,128601,11637,-31487,0,2471221,4105599,true]
["Lighting",15,"2018-02-01",0,159341,159341,36739,351,18,-731,0,122964,159341,true]
["OPA",16,"2018-02-01",-47975,1623124,1575149,544175,49820,4228,-11176,0,1036077,1623124,true]
["Residential",0,"2018-03-01",-1147167,9705373,8558206,2676311,427276,431877,-202284,0,6372193,9705373,true]
["Commercial",2,"2018-03-01",-7895,8705679,8697784,2627513,280930,413109,-194792,0,{"$f":"5578920-1","v":5578919},8705679,true]
["Industrial",4,"2018-03-01",114261,4223518,4337779,1515655,126041,234195,-112073,0,2459700,4223518,true]
["Lighting",15,"2018-03-01",0,136841,136841,29960,306,4713,-2229,0,{"$f":"104092-1","v":104091},136841,true]
["OPA",16,"2018-03-01",19951,1638638,1658589,511078,46387,79772,-37495,0,{"$f":"1038895+1","v":1038896},1638638,true]
["Residential",0,"2018-04-01",-279968,9192616,8912648,2613999,421995,114337,-193872,0,6236157,9192616,true]
["Commercial",2,"2018-04-01",230268,8531638,8761906,2683647,286880,114054,-199453,0,{"$f":"5646509+1","v":5646510},8531638,true]
["Industrial",4,"2018-04-01",174937,4072833,4247770,1527323,128368,62914,-113061,0,{"$f":"2467290-1","v":2467289},4072833,true]
["Lighting",15,"2018-04-01",0,132847,132847,29777,291,1257,-2216,0,103738,132847,true]
["OPA",16,"2018-04-01",81786,1593718,1675504,526797,47969,22107,-38735,0,{"$f":"1035581-1","v":1035580},1593718,true]
["Residential",0,"2018-05-01",750139,9225511,9975650,2263987,365310,1058577,-168009,0,5705646,9225511,true]
["Commercial",2,"2018-05-01",706147,9918317,10624464,2710151,289793,1254578,-201555,0,{"$f":"5865351-1","v":5865350},9918317,true]
["Industrial",4,"2018-05-01",371605,4897146,5268751,1572561,132640,714001,-116393,0,2594337,4897146,true]
["Lighting",15,"2018-05-01",0,144432,144432,29449,246,13627,-2192,0,{"$f":"103301+1","v":103302},144432,true]
["OPA",16,"2018-05-01",176325,1801713,1978038,509526,46753,235825,-37719,0,{"$f":"1047329-1","v":1047328},1801713,{"$f":"E68=M68","v":true}]
["Residential",0,"2018-06-01",792224,13041663,13833887,3251112,525305,1402488,-342065,298777,7906046,{"$f":"SUM(G69:L69)","v":13041663},true]
["Commercial",2,"2018-06-01",664391,11694570,{"$f":"D70+E70","v":12358961},3236512,348150,1398714,-341397,266511,6786080,11694570,true]
["Industrial",4,"2018-06-01",58512,5408731,5467243,1721810,145464,719816,-178410,112445,{"$f":"2887607-1","v":2887606},5408731,true]
["Lighting",15,"2018-06-01",0,68887,68887,9294,231,11078,-2138,3905,46517,68887,true]
["OPA",16,"2018-06-01",49096,2178677,2227773,596693,56070,255966,-62491,50297,1282142,2178677,true]
["Residential",0,"2018-07-01",-632639,15332757,14700118,3770604,609408,2012795,-396461,383577,{"$f":"8952835-1","v":8952834},15332757,true]
["Commercial",2,"2018-07-01",-476404,12461177,11984773,3353672,360558,1794869,-353782,318460,{"$f":"6987399+1","v":6987400},12461177,true]
["Industrial",4,"2018-07-01",-258197,5721662,5463465,1722593,146388,894974,-180736,135923,3002520,5721662,true]
["Lighting",15,"2018-07-01",0,172506,172506,38145,196,15846,-3448,4769,116998,172506,true]
["OPA",16,"2018-07-01",-115052,2165620,2050568,599504,55519,319144,-62788,54986,1199255,2165620,true]
["Residential",0,"2018-08-01",398920,12716657,13115577,3363068,543940,379161,-353083,642457,8141114,12716657,true]
["Commercial",2,"2018-08-01",459977,10818720,11278697,3181005,341751,365132,-335424,551990,{"$f":"6714267-1","v":6714266},10818720,true]
["Industrial",4,"2018-08-01",179492,5095383,5274875,1728979,147747,192919,-181393,239261,{"$f":"2967869+1","v":2967870},5095383,true]
["Lighting",15,"2018-08-01",0,114770,114770,28872,283,3438,-3033,8191,{"$f":"77020-1","v":77019},114770,true]
["OPA",16,"2018-08-01",91544,1952115,2043659,590642,55346,67393,-61801,98719,1201816,1952115,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E132=M132","v":true}]
["OPA",16,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G133:L133)","v":0},true]
["Residential",0,null,null,null,{"$f":"D134+E134","v":0},null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E196=M196","v":true}]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G197:L197)","v":0},true]
["OPA",16,null,null,null,{"$f":"D198+E198","v":0},null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E260=M260","v":true}]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G261:L261)","v":0},true]
["Lighting",15,null,null,null,{"$f":"D262+E262","v":0},null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E324=M324","v":true}]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G325:L325)","v":0},true]
["Industrial",4,null,null,null,{"$f":"D326+E326","v":0},null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E388=M388","v":true}]
["Residential",0,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G389:L389)","v":0},true]
["Commercial",2,null,null,null,{"$f":"D390+E390","v":0},null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E452=M452","v":true}]
["OPA",16,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G453:L453)","v":0},true]
["Residential",0,null,null,null,{"$f":"D454+E454","v":0},null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E516=M516","v":true}]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G517:L517)","v":0},true]
["OPA",16,null,null,null,{"$f":"D518+E518","v":0},null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E580=M580","v":true}]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G581:L581)","v":0},true]
["Lighting",15,null,null,null,{"$f":"D582+E582","v":0},null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E644=M644","v":true}]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G645:L645)","v":0},true]
["Industrial",4,null,null,null,{"$f":"D646+E646","v":0},null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E708=M708","v":true}]
["Residential",0,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G709:L709)","v":0},true]
["Commercial",2,null,null,null,{"$f":"D710+E710","v":0},null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E772=M772","v":true}]
["OPA",16,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G773:L773)","v":0},true]
["Residential",0,null,null,null,{"$f":"D774+E774","v":0},null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E836=M836","v":true}]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G837:L837)","v":0},true]
["OPA",16,null,null,null,{"$f":"D838+E838","v":0},null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E900=M900","v":true}]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G901:L901)","v":0},true]
["Lighting",15,null,null,null,{"$f":"D902+E902","v":0},null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E964=M964","v":true}]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G965:L965)","v":0},true]
["Industrial",4,null,null,null,{"$f":"D966+E966","v":0},null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
["Residential",0,null,null,null,0,null,null,null,null,null,null,0,true]
["Commercial",2,null,null,null,0,null,null,null,null,null,null,0,true]
["Industrial",4,null,null,null,0,null,null,null,null,null,null,0,true]
["Lighting",15,null,null,null,0,null,null,null,null,null,null,0,true]
["OPA",16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E1028=M1028","v":true}]
[null,0,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G1029:L1029)","v":0},true]
[null,2,null,null,null,{"$f":"D1030+E1030","v":0},null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,{"$f":"E1092=M1092","v":true}]
[null,16,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(G1093:L1093)","v":0},true]
[null,0,null,null,null,{"$f":"D1094+E1094","v":0},null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16,null,null,null,0,null,null,null,null,null,null,0,true]
[null,0,null,null,null,0,null,null,null,null,null,null,0,true]
[null,2,null,null,null,0,null,null,null,null,null,null,0,true]
[null,4,null,null,null,0,null,null,null,null,null,null,0,true]
[null,15,null,null,null,0,null,null,null,null,null,null,0,true]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]
[null,0]
[null,2]
[null,4]
[null,15]
[null,16]

{"sheet":"Sales for Resale","index":11,"n_rows":328,"n_cols":7,"rows_kept":328,"cut":false,"hidden":false,"merged":[]}
["Source: PSM Schedule 2"]
["Asset Energy = Non-native portion of DA Asset Energy (PJM BLI 1200, 1210, 1220) and RT Asset Energy (PJM BLI 1205, 1215, 1225, 1400, 1410, 1420)"]
[]
["Bill",null,"12 Month"]
["Period","Amount","Average",null,null,"PSM"]
["2017-05-01",1173611.46,null,null,null,1173611.46,{"$f":"F6-B6","v":0}]
["2017-06-01",593771.89,null,null,null,593771.89,{"$f":"F7-B7","v":0}]
["2017-07-01",415058.79,null,null,null,415058.79,0]
["2017-08-01",447589.45,null,null,null,447589.45,0]
["2017-09-01",1077979.1499999999,null,null,null,1077979.1499999999,0]
["2017-10-01",2400518.7799999998,null,null,null,2400518.7799999998,0]
["2017-11-01",1648921.22,null,null,null,1648921.22,0]
["2017-12-01",647230.18999999994,null,null,null,647230.18999999994,0]
["2018-01-01",1989969.08,null,null,null,1989969.08,0]
["2018-02-01",220839.74,null,null,null,220839.74,0]
["2018-03-01",58321.9,null,null,null,58321.9,0]
["2018-04-01",592.38,{"$f":"ROUND(AVERAGE(B6:B17),0)","v":889534},null,null,592.38,0]
["2018-05-01",0,{"$f":"ROUND(AVERAGE(B7:B18),0)","v":791733},null,null,0,0]
["2018-06-01",567725.6,789562,null,null,567725.6,0]
["2018-07-01",1617776.12,889789,null,null,1617776.12,0]
["2018-08-01",459147.96,890752,null,null,459147.96,0]
["2018-09-01",null,873731,null,null,null,0]
["2018-10-01",null,721052,null,null,null,0]
["2018-11-01",null,617956,null,null,null,0]
["2018-12-01",null,614297,null,null,null,0]
["2019-01-01",null,417772,null,null,null,0]
["2019-02-01",null,450594,null,null,null,0]
["2019-03-01",null,529048,null,null,null,0]
["2019-04-01",null,661162,null,null,null,0]
["2019-05-01",null,881550,null,null,null,0]
["2019-06-01",null,1038462,null,null,null,0]
["2019-07-01",null,459148,null,null,null,0]
["2019-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2019-09-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2019-10-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2019-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2019-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-01-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-02-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-03-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-04-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-05-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-06-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-07-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-09-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-10-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2020-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-01-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-02-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-03-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-04-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-05-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-06-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-07-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-09-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-10-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2021-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-01-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-02-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-03-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-04-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-05-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-06-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-07-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-09-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-10-01",null,{"$error":"#DIV/0!"},null,null,null,{"$f":"F71-B71","v":0}]
["2022-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2022-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-01-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-02-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-03-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-04-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-05-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-06-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-07-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-09-01",null,{"$f":"ROUND(AVERAGE(B71:B82),0)","v":{"$error":"#DIV/0!"}},null,null,null,0]
["2023-10-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2023-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-01-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-02-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-03-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-04-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-05-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-06-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-07-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-08-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-09-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-10-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-11-01",null,{"$error":"#DIV/0!"},null,null,null,0]
["2024-12-01",null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,{"$f":"F135-B135","v":0}]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$f":"ROUND(AVERAGE(B135:B146),0)","v":{"$error":"#DIV/0!"}},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,{"$f":"F199-B199","v":0}]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$f":"ROUND(AVERAGE(B199:B210),0)","v":{"$error":"#DIV/0!"}},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,{"$f":"F263-B263","v":0}]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$f":"ROUND(AVERAGE(B263:B274),0)","v":{"$error":"#DIV/0!"}},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]
[null,null,{"$error":"#DIV/0!"},null,null,null,{"$f":"F327-B327","v":0}]
[null,null,{"$error":"#DIV/0!"},null,null,null,0]