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

{"sheet":"Test Affordability","index":0,"n_rows":84,"n_cols":12,"rows_kept":84,"cut":false,"hidden":false,"merged":[[6,2,6,3],[78,2,78,3],[79,2,79,3],[80,2,80,3],[77,2,77,3],[68,2,68,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[58,2,58,3],[32,2,32,3],[18,2,18,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[25,2,25,5],[54,2,54,5],[38,2,38,3],[19,11,24,11],[76,2,76,3],[8,6,13,6],[19,6,24,6],[29,2,29,3],[29,4,29,5],[33,6,38,6],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[67,2,67,3],[52,2,52,3],[46,6,51,6],[41,2,41,3],[42,2,42,3],[39,2,39,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[2,2,2,11],[4,2,4,3],[4,4,4,5],[22,2,22,3],[23,2,23,3],[24,2,24,3],[15,2,15,3],[17,2,17,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[7,2,7,3],[14,2,14,3],[16,2,16,3],[8,8,13,8],[8,9,13,9],[8,10,13,10],[8,11,13,11],[19,8,24,8],[19,9,24,9],[19,10,24,10],[46,10,53,10],[49,2,49,3],[50,2,50,3],[51,2,51,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[46,11,53,11],[53,2,53,5],[40,2,40,5],[69,2,69,5],[82,2,82,5],[83,2,83,5],[62,8,69,8],[62,9,69,9],[62,10,69,10],[62,11,69,11],[75,8,82,8],[75,9,82,9],[75,10,82,10],[75,11,82,11],[58,4,58,5],[33,11,40,11],[62,6,67,6],[75,6,80,6],[81,2,81,3],[33,8,40,8],[33,9,40,9],[33,10,40,10],[46,8,53,8],[46,9,53,9]]}
[]
[]
[null,null,"TEST AFFORDABILITY OF DOMESTIC TARIFFS"]
[]
[null,null,"LOW INCOME:",null,3000,null,"Monthly Household Income"]
[]
[null,null,null,null,"Units of Consumption","Tariff per Unit of Consumption","TOTAL BILL",null,"Bill as % of Monthly Income","Desired Portion of Monthly Income","Ideal Monthly Bill","GAP between Actual Bill and Ideal Bill"]
[null,null,"WATER"]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$9","v":"Consumption 7KL to 15KL"},null,9,{"$f":"'[1]Test Afford of Variable Tariff'!$L$9","v":7.815563725490196},{"$f":"(E9*F9)+(E10*F10)+(E11*F11)+(E12*F12)+(E13*F13)+(E14*F14)","v":70.340073529411768},null,{"$f":"IF(E5=0,0,G9/($E$5))","v":2.344669117647059E-2},0.04,{"$f":"J9*($E$5)","v":120},{"$f":"G9-K9","v":-49.659926470588232}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$10","v":"Consumption 16KL to 30KL"},"Type 2",0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$10","v":8.5971200980392162}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$11","v":"Domestic Consumption Type 3"},"Type 3",0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$11","v":9.3786764705882355}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$12","v":"Domestic Consumption Type 4"},"Type 4",0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$12","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$13","v":"Domestic Consumption Type 5"},"Type 5",0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$13","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$14","v":"Domestic Consumption Type 6"},"Type 6",0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$14","v":7.815563725490196}]
[null,null,"SANITATION"]
[null,null,{"$f":"'[2]Test Revised Primary Baseline'!$C$7","v":"Low Income"},null,1,{"$f":"'[2]Test Revised Primary Baseline'!$K$7","v":68.884615384615387},{"$f":"E16*F16","v":68.884615384615387},null,{"$f":"IF(E5=0,0,G16/($E$5))","v":2.2961538461538464E-2},0.01,{"$f":"J16*($E$5)","v":30},{"$f":"G16-K16","v":38.884615384615387}]
[null,null,"SOLID WASTE"]
[null,null,{"$f":"'[3]Test Revised Primary Baseline'!$C$7","v":"Residential"},null,1,{"$f":"'[3]Test Revised Primary Baseline'!$K$7","v":94.703783012134195},{"$f":"E18*F18","v":94.703783012134195},null,{"$f":"IF(E5=0,0,G18/($E$5))","v":3.1567927670711399E-2},0.01,{"$f":"J18*($E$5)","v":30},{"$f":"G18-K18","v":64.703783012134195}]
[null,null,"ELECTRICITY","Type 1"]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$10","v":"Domestic Pre-Paid Type 1"},"Type 2",150,0.89,{"$f":"(E20*F20)+(E21*F21)+(E22*F22)+(E23*F23)+(E24*F24)+(E25*F25)","v":133.5},null,{"$f":"IF(E5=0,0,G20/($E$5))","v":4.4499999999999998E-2},0.05,{"$f":"J20*($E$5)","v":150},{"$f":"G20-K20","v":-16.5}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$11","v":"Domestic Pre-Paid Type 2"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$11","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$12","v":"Domestic Pre-Paid Type 3"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$12","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$13","v":"Domestic Pre-Paid Type 4"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$13","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$14","v":"Domestic Pre-Paid Type 5"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$14","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$15","v":"Domestic Pre-Paid Type 6"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$15","v":0}]
[null,null,"LOW INCOME TOTAL",null,null,null,{"$f":"G9+G16+G18+G20","v":367.42847192616136},null,{"$f":"IF(E5=0,0,G26/($E$5))","v":0.12247615730872045},{"$f":"J9+J16+J18+J20","v":0.11000000000000001},{"$f":"K9+K16+K18+K20","v":330},{"$f":"G26-K26","v":37.428471926161365}]
[]
[]
[]
[null,null,"MIDDLE INCOME",null,0,null,"Monthly Household Income"]
[]
[null,null,null,null,"Units of Consumption","Tariff per Unit of Consumption","TOTAL BILL",null,"Bill as % of Monthly Income","Desired Portion of Monthly Income","Ideal Monthly Bill","GAP between Actual Bill and Ideal Bill"]
[null,null,"WATER"]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$9","v":"Consumption 7KL to 15KL"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$9","v":7.815563725490196},{"$f":"(E34*F34)+(E35*F35)+(E36*F36)+(E37*F37)+(E38*F38)+(E39*F39)","v":0},null,{"$f":"IF(E30=0,0,(G34+G40)/(E30))","v":0},0,{"$f":"J34*(E30)","v":0},{"$f":"(G34+G40)-K34","v":0}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$10","v":"Consumption 16KL to 30KL"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$10","v":8.5971200980392162}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$11","v":"Domestic Consumption Type 3"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$11","v":9.3786764705882355}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$12","v":"Domestic Consumption Type 4"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$12","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$13","v":"Domestic Consumption Type 5"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$13","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$14","v":"Domestic Consumption Type 6"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$14","v":7.815563725490196}]
[null,null,"Fixed Fee",null,0,{"$f":"'[1]Test Afford of Fixed Tariff'!$L$11","v":304.09090909090907},{"$f":"E40*F40","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G34+G40)","v":0}]
[null,null,"SANITATION"]
[null,null,{"$f":"'[2]Test Revised Primary Baseline'!$C$8","v":"Middle Income"},null,0,{"$f":"'[2]Test Revised Primary Baseline'!$K$8","v":76.538461538461533},{"$f":"E43*F43","v":0},null,{"$f":"IF(E30=0,0,G43/(E30))","v":0},0,{"$f":"J43*(E30)","v":0},{"$f":"G43-K43","v":0}]
[null,null,"SOLID WASTE"]
[null,null,{"$f":"'[3]Test Revised Primary Baseline'!$C$7","v":"Residential"},null,0,{"$f":"'[3]Test Revised Primary Baseline'!$K$7","v":94.703783012134195},{"$f":"E45*F45","v":0},null,{"$f":"IF(E30=0,0,G45/(E30))","v":0},0,{"$f":"J45*(E30)","v":0},{"$f":"G45-K45","v":0}]
[null,null,"ELECTRICITY","Type 1"]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$17","v":"Domestic Metered Single Phase Type 1"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$17","v":0},{"$f":"(E47*F47)+(E48*F48)+(E49*F49)+(E50*F50)+(E51*F51)+(E52*F52)","v":0},null,{"$f":"IF(E30=0,0,(G47+G53)/(E30))","v":0},0,{"$f":"J47*(E30)","v":0},{"$f":"(G47+G53)-K47","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$18","v":"Domestic Metered Single Phase Type 2"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$18","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$19","v":"Domestic Metered Single Phase Type 3"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$19","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$20","v":"Domestic Metered Single Phase Type 4"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$20","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$21","v":"Domestic Metered Single Phase Type 5"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$21","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$22","v":"Domestic Metered Single Phase Type 6"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$22","v":0}]
[null,null,"Fixed Fee",null,0,{"$f":"'[4]Test Afford of Fixed Tariff'!$L$15/12","v":0},{"$f":"E53*F53","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G47+G53)","v":0}]
[null,null,"MIDDLE INCOME TOTAL",null,null,null,{"$f":"G34+G40+G43+G45+G47+G53","v":0},null,{"$f":"IF(E30=0,0,G55/(E30/12))","v":0},{"$f":"J34+J43+J45+J47","v":0},{"$f":"K34+K40+K43+K45+K47+K53","v":0},{"$f":"G55-K55","v":0}]
[]
[]
[]
[null,null,"HIGH INCOME",null,0,null,"Monthly Household Income"]
[]
[null,null,null,null,"Units of Consumption","Tariff per Unit of Consumption","TOTAL BILL",null,"Bill as % of Monthly Income","Desired Portion of Monthly Income","Ideal Monthly Bill","GAP between Actual Bill and Ideal Bill"]
[null,null,"WATER"]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$9","v":"Consumption 7KL to 15KL"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$9","v":7.815563725490196},{"$f":"(E63*F63)+(E64*F64)+(E65*F65)+(E66*F66)+(E67*F67)+(E68*F68)","v":0},null,{"$f":"IF(E59=0,0,(G63+G69)/(E59))","v":0},0,{"$f":"J63*(E59)","v":0},{"$f":"(G63+G69)-K63","v":0}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$10","v":"Consumption 16KL to 30KL"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$10","v":8.5971200980392162}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$11","v":"Domestic Consumption Type 3"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$11","v":9.3786764705882355}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$12","v":"Domestic Consumption Type 4"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$12","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$13","v":"Domestic Consumption Type 5"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$13","v":7.815563725490196}]
[null,null,{"$f":"'[1]Test Afford of Variable Tariff'!$C$14","v":"Domestic Consumption Type 6"},null,0,{"$f":"'[1]Test Afford of Variable Tariff'!$L$14","v":7.815563725490196}]
[null,null,"Fixed Fee",null,0,{"$f":"'[1]Test Afford of Fixed Tariff'!$L$11","v":304.09090909090907},{"$f":"E69*F69","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G63+G69)","v":0}]
[null,null,"SANITATION"]
[null,null,{"$f":"'[2]Test Revised Primary Baseline'!$C$9","v":"High Income"},null,0,{"$f":"'[2]Test Revised Primary Baseline'!$K$9","v":76.538461538461533},{"$f":"E72*F72","v":0},null,{"$f":"IF(E59=0,0,G72/(E59))","v":0},0,{"$f":"J72*(E59)","v":0},{"$f":"G72-K72","v":0}]
[null,null,"SOLID WASTE"]
[null,null,{"$f":"'[3]Test Revised Primary Baseline'!$C$7","v":"Residential"},null,0,{"$f":"'[3]Test Revised Primary Baseline'!$K$7","v":94.703783012134195},{"$f":"E74*F74","v":0},null,{"$f":"IF(E59=0,0,G74/(E59))","v":0},0,{"$f":"J74*(E59)","v":0},{"$f":"G74-K74","v":0}]
[null,null,"ELECTRICITY","Type 1"]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$24","v":"Domestic Metered Three Phase Type 1"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$24","v":0},{"$f":"(E76*F76)+(E77*F77)+(E78*F78)+(E79*F79)+(E80*F80)+(E81*F81)","v":0},null,{"$f":"IF(E59=0,0,(G76+G82)/(E59))","v":0},0,{"$f":"J76*(E59)","v":0},{"$f":"(G76+G82)-K76","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$25","v":"Domestic Metered Three Phase Type 2"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$25","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$26","v":"Domestic Metered Three Phase Type 3"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$26","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$27","v":"Domestic Metered Three Phase Type 4"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$27","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$28","v":"Domestic Metered Three Phase Type 5"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$28","v":0}]
[null,null,{"$f":"'[4]Test Afford of Variable Tariff'!$C$29","v":"Domestic Metered Three Phase Type 6"},"Type 2",0,{"$f":"'[4]Test Afford of Variable Tariff'!$L$29","v":0}]
[null,null,"Fixed Fee",null,0,{"$f":"'[4]Test Afford of Fixed Tariff'!$L$15/12","v":0},{"$f":"E82*F82","v":0}]
[null,null,"SUBTOTAL",null,null,null,{"$f":"SUM(G76+G82)","v":0}]
[null,null,"HIGH INCOME TOTAL",null,null,null,{"$f":"G63+G69+G72+G74+G76+G82","v":0},null,{"$f":"IF(E59=0,0,G84/(E59/12))","v":0},{"$f":"J63+J72+J74+J76","v":0},{"$f":"K63+K69+K72+K74+K76+K82","v":0},{"$f":"G84-K84","v":0}]