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

{"sheet":"TCC-4.1","index":0,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,7,9,7],[11,7,12,7]]}
["Month","Total Nominal","Base Nominal","Base Real","Total Real","CPI",null,null,null,null,"OPC 006642",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2006 RS-1 Bill Calculation for Usage: 1000 kWh"]
["2006-01-01",108.61,38.119999999999997,{"$f":"C2","v":38.119999999999997},{"$f":"B2","v":108.61},198.3,null,null,null,null,"FPL RC-16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description","Each","Quantity","Total"]
["2007-01-05",103.51,38.119999999999997,{"$f":"ROUND((($F3/$F$2)*$C$2),2)","v":38.909999999999997},{"$f":"ROUND((($F3/$F$2)*$B$2),2)","v":110.86},202.416,null,"Category","2006-01-01","2016-01-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"customer charge",5.17,1,{"$f":"ROUND(AA3*AB3,2)","v":5.17}]
["2008-01-07",102.49,39.369999999999997,{"$f":"ROUND((($F4/$F$2)*$C$2),2)","v":40.58},{"$f":"ROUND((($F4/$F$2)*$B$2),2)","v":115.61},211.08,null,"Nominal Base",{"$f":"C2","v":38.119999999999997},{"$f":"C13","v":54.86},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eenergy first 1,000 kWh",3.295E-2,1000,{"$f":"ROUND(AA4*AB4,2)","v":32.950000000000003}]
["2009-01-06",109.55,39.31,40.590000000000003,115.64,211.143,null,"Real Base",{"$f":"D13-D2","v":8.1500000000000057},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"storm",{"$f":"0.165/100","v":1.65E-3},1000,1.65]
["2010-02-03",95.43,42,41.65,118.68,216.68700000000001,null,"Nomontal Total",{"$f":"B2","v":108.61},{"$f":"B13","v":93.38},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fuel First 1,000 kWh",5.8409999999999997E-2,1000,58.41]
["2011-03-01",96.44,43.03,42.96,122.39,223.46700000000001,null,"Real Total",{"$f":"E13-E2","v":23.220000000000013},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conservation",{"$f":"0.142/100","v":1.4199999999999998E-3},1000,1.42]
["2012-01-03",94.62,43.26,43.57,124.15,226.66499999999999,null,null,null,"Nominal","Real",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capacity",{"$f":"0.603/100","v":6.0299999999999998E-3},1000,6.03]
["2013-01-02",94.25,49.61,44.27,126.13,230.28,null,"Base Part of Bill","2006-01-01",{"$f":"I4","v":38.119999999999997},{"$f":"I5","v":8.1500000000000057},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"environmental",{"$f":"0.026/100","v":2.5999999999999998E-4},1000,0.26]
["2014-01-02",99.95,52.47,44.97,128.12,233.916,null,null,"2016-01-01",{"$f":"J4","v":54.86},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"subtotal",null,null,{"$f":"SUM(AC3:AC9)","v":105.89000000000001}]
["2015-01-01",99.57,54.86,44.93,128,233.70699999999999,null,null,null,"Nominal","Real",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRT",null,null,{"$f":"ROUND(AC10*0.025641,2)","v":2.72}]
["2015-11-01",96.72,54.86,45.37,129.26,236,null,"Total Bill","2006-01-01",{"$f":"I6","v":108.61},{"$f":"I7","v":23.220000000000013},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(AC10:AC11)","v":108.61000000000001}]
["2016-01-01",93.38,54.86,46.27,131.83000000000001,240.7,null,null,"2016-01-01",{"$f":"J6","v":93.38}]
["2017-01-01",98.82,64.83,47.42,135.12,246.7,null,null,"2017-01-01",98.82]
["2018-01-01",104.18,67.38,48.65,138.62,253.1,null,null,"2018-01-01",104.18]
["2019-04-01",105.2,69.55,49.88,142.13,259.5,null,null,"2019-04-01",105.2]
["2020-01-01",106.11,69.55,51.33,146.24,267,null,null,"2020-01-01",106.11]
[]
[]
["Nominal Total Bill CAGR:",null,null,{"$f":"(B17/B2)^(1/14)-1","v":-1.6619882515398476E-3},null,"take out base",null,null,{"$f":"F13/F2","v":1.2138174483106403},{"$f":"(B2-B13)/B2","v":0.1402264984808029}]
["Nominal Base Bill CAGR:",null,null,{"$f":"(C17/C2)^(1/14)-1","v":4.3886209242563368E-2},null,null,null,null,{"$f":"C13/C2","v":1.439139559286464}]
["CPI CAGR:",null,null,{"$f":"(F17/F2)^(1/14)-1","v":2.1475026747473924E-2}]

{"sheet":"TCC4.2","index":1,"n_rows":14,"n_cols":20,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"OPC 006643",null,null,null,null,null,null,null,null,2006,"GS-1 Bill Calculation"]
["Month","Total Nominal","Base Nominal","Base Real","Total Real","CPI",null,"FPL RC-16",null,2016,1200,"KWH",null,null,null,null,1200,"KWH"]
["2006-01-01",{"$f":"T14","v":142.27000000000001},{"$f":"T5+T6","v":53.86},{"$f":"C3","v":53.86},{"$f":"B3","v":142.27000000000001},198.3,null,null,null,null,3,"KW"]
["2016-01-01",{"$f":"N14","v":119.31000000000002},{"$f":"N5+N6","v":69.64},{"$f":"ROUND((($F4/$F$3)*$C$3),2)","v":65.38},{"$f":"ROUND((($F4/$F$3)*$B$3),2)","v":172.69},240.7]
[null,null,null,null,null,null,null,null,null,null,"Customer Charge",7.46,null,{"$f":"L5","v":7.46},null,null,"Customer Charge",8.24,null,{"$f":"R5","v":8.24}]
[null,null,null,null,null,null,null,null,null,null,"Non-fuel Energy",5.1820000000000004,"¢/kWh",{"$f":"ROUND(K2*(L6/100),2)","v":62.18},null,null,"Non-fuel Energy",3.802,"¢/kWh",{"$f":"ROUND(Q2*(R6/100),2)","v":45.62}]
[null,null,null,null,null,null,null,null,null,null,"ECCR",0.17699999999999999,"¢/kWh",{"$f":"ROUND(K2*(L7/100),2)","v":2.12},null,null,"ECCR",0.13700000000000001,"¢/kWh",{"$f":"ROUND(Q2*(R7/100),2)","v":1.64}]
[null,null,null,null,null,null,null,{"$f":"(B3-B4)/B3","v":0.1613832853025936},null,null,"ECRC",0.251,"¢/kWh",{"$f":"ROUND(K2*(L8/100),2)","v":3.01},null,null,"ECRC",2.5000000000000001E-2,"¢/kWh",{"$f":"ROUND(Q2*(R8/100),2)","v":0.3}]
[null,null,null,null,"Nominal","Real",null,null,null,null,"CPRC",0.46600000000000003,"¢/kWh",{"$f":"ROUND(K2*(L9/100),2)","v":5.59},null,null,"CPRC",0.57299999999999995,"¢/kWh",{"$f":"ROUND(Q2*(R9/100),2)","v":6.88}]
[null,null,null,"2006-01-01",{"$f":"B3","v":142.27000000000001},{"$f":"E4-E3","v":30.419999999999987},null,null,null,null,"Fuel",2.907,"¢/kWh",{"$f":"ROUND(K2*(L10/100),2)","v":34.880000000000003},null,null,"Fuel",6.1909999999999998,"¢/kWh",{"$f":"ROUND(Q2*(R10/100),2)","v":74.290000000000006}]
[null,null,"Total Bill","2016-01-01",{"$f":"B4","v":119.31000000000002},null,null,null,null,null,"Storm Surcharge",9.0999999999999998E-2,"¢/kWh",{"$f":"ROUND(K2*(L11/100),2)","v":1.0900000000000001},null,null,"Storm Surcharge",0.14499999999999999,"¢/kWh",{"$f":"ROUND(Q2*(R11/100),2)","v":1.74}]
[null,null,null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(N4:N11)","v":116.33000000000001},null,null,"Subtotal",null,null,{"$f":"SUM(T4:T11)","v":138.71}]
[null,null,null,null,null,null,null,null,null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(N12*(L13/100),2)","v":2.98},null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(T12*(R13/100),2)","v":3.56}]
[null,null,null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(N12:N13)","v":119.31000000000002},null,null,"Total",null,null,{"$f":"SUM(T12:T13)","v":142.27000000000001}]

{"sheet":"TCC4.3","index":2,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"OPC 006644",null,null,"2006 GSD-1 Bill Calculation"]
["Month","Total Nominal","Base Nominal","Base Real","Total Real","CPI",null,2016,17520,"KWH",null,"FPL RC-16",null,null,17520,"KWH"]
["2006-01-01",{"$f":"R15","v":1790.8800000000003},{"$f":"R5+R6+R7","v":515.22},{"$f":"C3","v":515.22},{"$f":"B3","v":1790.8800000000003},198.3,null,null,50,"KW",null,null,null,null,50,"KW"]
["2016-01-01",{"$f":"L15","v":1448.7700000000002},{"$f":"L5+L6+L7","v":743.03},{"$f":"ROUND((($F4/$F$3)*$C$3),2)","v":625.38},{"$f":"ROUND((($F4/$F$3)*$B$3),2)","v":2173.8000000000002},240.7]
[null,null,null,null,null,null,null,null,"Customer Charge",19.48,null,{"$f":"J5","v":19.48},null,null,"Customer Charge",32.049999999999997,null,{"$f":"P5","v":32.049999999999997}]
[null,null,null,null,null,null,null,null,"Non-fuel Energy",1.8610000000000002,"¢/kWh",{"$f":"ROUND(I2*(J6/100),2)","v":326.05},null,null,"Non-fuel Energy",1.3480000000000001,"¢/kWh",{"$f":"ROUND(O2*(P6/100),2)","v":236.17}]
[null,null,null,null,null,null,{"$f":"C4/C3","v":1.4421606304103101},null,"Demand Charge",7.95,"$/kW",{"$f":"ROUND((J7*(I3)),2)","v":397.5},null,null,"Demand Charge",4.9400000000000004,"$/kW",{"$f":"ROUND((P7*(O3)),2)","v":247}]
[null,null,null,null,null,null,{"$f":"(B3-B4)/B3","v":0.19102899133386941},null,"ECCR",0.61,"$/kW",{"$f":"ROUND(I3*(J8),2)","v":30.5},null,null,"ECCR",0.129,"¢/kWh",{"$f":"ROUND(O2*(P8)/100,2)","v":22.6}]
[null,null,null,null,"Nominal","Real",null,null,"ECRC",0.23300000000000001,"¢/kWh",{"$f":"ROUND(I2*(J9/100),2)","v":40.82},null,null,"ECRC",2.4E-2,"¢/kWh",{"$f":"ROUND(O2*(P9/100),2)","v":4.2}]
[null,null,"Total Bill","2006-01-01",{"$f":"B3","v":1790.8800000000003},{"$f":"E4-E3","v":382.91999999999985},null,null,"CPRC",1.55,"$/kW",{"$f":"ROUND((J10*(I3)),2)","v":77.5},null,null,"CPRC",1.94,"$/kW",{"$f":"ROUND((P10*(O3)),2)","v":97}]
[null,null,null,"2016-01-01",{"$f":"B4","v":1448.7700000000002},null,null,null,"Fuel",2.907,"¢/kWh",{"$f":"ROUND(I2*(J11/100),2)","v":509.31},null,null,"Fuel",6.1909999999999998,"¢/kWh",{"$f":"ROUND(O2*(P11/100),2)","v":1084.6600000000001}]
[null,null,null,null,null,null,null,null,"Storm Surcharge",6.5000000000000002E-2,"¢/kWh",{"$f":"ROUND(I2*(J12/100),2)","v":11.39},null,null,"Storm Surcharge",0.128,"¢/kWh",{"$f":"ROUND(O2*(P12/100),2)","v":22.43}]
[null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(L5:L12)","v":1412.5500000000002},null,null,"Subtotal",null,null,{"$f":"SUM(R5:R12)","v":1746.1100000000004}]
[null,null,null,null,null,null,null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(L13*(J14/100),2)","v":36.22},null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(R13*(P14/100),2)","v":44.77}]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(L13:L14)","v":1448.7700000000002},null,null,"Total",null,null,{"$f":"SUM(R13:R14)","v":1790.8800000000003}]

{"sheet":"TCC4.4","index":3,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"OPC 006645",null,null,2006,"GSLD-1 Bill Calculation"]
["Month","Total Nominal","Base Nominal","Base Real","Total Real","CPI",null,2016,219000,"KWH",null,"FPL RC-16",null,null,219000,"KWH"]
["2006-01-01",{"$f":"R15","v":21848.760000000002},{"$f":"R5+R6+R7","v":5806.2800000000007},{"$f":"C3","v":5806.2800000000007},{"$f":"B3","v":21848.760000000002},198.3,null,null,600,"KW",null,null,null,null,600,"KW"]
["2016-01-01",{"$f":"L15","v":17454.939999999999},{"$f":"L5+L6+L7","v":8538.9500000000007},{"$f":"ROUND((($F4/$F$3)*$C$3),2)","v":7047.76},{"$f":"ROUND((($F4/$F$3)*$B$3),2)","v":26520.41},240.7]
[null,null,null,null,null,null,null,null,"Customer Charge",59.51,null,{"$f":"J5","v":59.51},null,null,"Customer Charge",37.549999999999997,null,{"$f":"P5","v":37.549999999999997}]
[null,null,null,null,null,null,null,null,"Non-fuel Energy",1.3760000000000001,"¢/kWh",{"$f":"ROUND(I2*(J6/100),2)","v":3013.44},null,null,"Non-fuel Energy",1.0669999999999999,"¢/kWh",{"$f":"ROUND(O2*(P6/100),2)","v":2336.73}]
[null,null,null,null,null,null,null,null,"Demand Charge",9.11,"$/kW",{"$f":"ROUND((J7*(I3)),2)","v":5466},null,null,"Demand Charge",5.72,"$/kW",{"$f":"ROUND((P7*(O3)),2)","v":3432}]
[null,null,null,null,null,null,{"$f":"C4/C3","v":1.4706404100387855},null,"ECCR",0.68,"$/kW",{"$f":"ROUND(I3*(J8),2)","v":408},null,null,"ECCR",0.122,"¢/kWh",{"$f":"ROUND(O2*(P8)/100,2)","v":267.18}]
[null,null,null,null,"Nominal","Real",{"$f":"(B3-B4)/B3","v":0.20110157281237026},null,"ECRC",0.23200000000000001,"¢/kWh",{"$f":"ROUND(I2*(J9/100),2)","v":508.08},null,null,"ECRC",2.4E-2,"¢/kWh",{"$f":"ROUND(O2*(P9/100),2)","v":52.56}]
[null,null,"Total Bill","2006-01-01",{"$f":"B3","v":21848.760000000002},{"$f":"E4-E3","v":4671.6499999999978},null,null,"CPRC",1.78,"$/kW",{"$f":"ROUND((J10*(I3)),2)","v":1068},null,null,"CPRC",2.27,"$/kW",{"$f":"ROUND((P10*(O3)),2)","v":1362}]
[null,null,null,"2016-01-01",{"$f":"B4","v":17454.939999999999},null,null,null,"Fuel",2.9039999999999999,"¢/kWh",{"$f":"ROUND(I2*(J11/100),2)","v":6359.76},null,null,"Fuel",6.1849999999999996,"¢/kWh",{"$f":"ROUND(O2*(P11/100),2)","v":13545.15}]
[null,null,null,null,null,null,null,null,"Storm Surcharge",6.2E-2,"¢/kWh",{"$f":"ROUND(I2*(J12/100),2)","v":135.78},null,null,"Storm Surcharge",0.123,"¢/kWh",{"$f":"ROUND(O2*(P12/100),2)","v":269.37}]
[null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(L5:L12)","v":17018.57},null,null,"Subtotal",null,null,{"$f":"SUM(R5:R12)","v":21302.54}]
[null,null,null,null,null,null,null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(L13*(J14/100),2)","v":436.37},null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(R13*(P14/100),2)","v":546.22}]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(L13:L14)","v":17454.939999999999},null,null,"Total",null,null,{"$f":"SUM(R13:R14)","v":21848.760000000002}]

{"sheet":"TCC4.5","index":4,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"OPC 006646",null,null,"2006 GSLD-2 Bill Calculation"]
["Month","Total Nominal","Base Nominal","Base Real","Total Real","CPI",null,2016,1124200,"KWH",null,"FPL RC-16",null,null,1124200,"KWH"]
["2006-01-01",{"$f":"R15","v":109006.58000000002},{"$f":"R5+R6+R7","v":28133.17},{"$f":"C3","v":28133.17},{"$f":"B3","v":109006.58000000002},198.3,null,null,2800,"KW",null,null,null,null,2800,"KW"]
["2016-01-01",{"$f":"L15","v":84438.58},{"$f":"L5+L6+L7","v":40543.83},{"$f":"ROUND((($F4/$F$3)*$C$3),2)","v":34148.53},{"$f":"ROUND((($F4/$F$3)*$B$3),2)","v":132314.09},240.7]
[null,null,null,null,null,null,null,null,"Customer Charge",210.99,null,{"$f":"J5","v":210.99},null,null,"Customer Charge",155.68,null,{"$f":"P5","v":155.68}]
[null,null,null,null,null,null,null,null,"Non-fuel Energy",1.2390000000000001,"¢/kWh",{"$f":"ROUND(I2*(J6/100),2)","v":13928.84},null,null,"Non-fuel Energy",1.0640000000000001,"¢/kWh",{"$f":"ROUND(O2*(P6/100),2)","v":11961.49}]
[null,null,null,null,null,null,{"$f":"C4/C3","v":1.4411397649109576},null,"Demand Charge",9.43,"$/kW",{"$f":"ROUND((J7*(I3)),2)","v":26404},null,null,"Demand Charge",5.72,"$/kW",{"$f":"ROUND((P7*(O3)),2)","v":16016}]
[null,null,null,null,null,null,{"$f":"(B3-B4)/B3","v":0.22538088985086965},null,"ECCR",0.7,"$/kW",{"$f":"ROUND(I3*(J8),2)","v":1960},null,null,"ECCR",0.11700000000000001,"¢/kWh",{"$f":"ROUND(O2*(P8)/100,2)","v":1315.31}]
[null,null,null,null,"Nominal","Real",null,null,"ECRC",0.20499999999999999,"¢/kWh",{"$f":"ROUND(I2*(J9/100),2)","v":2304.61},null,null,"ECRC",2.3E-2,"¢/kWh",{"$f":"ROUND(O2*(P9/100),2)","v":258.57}]
[null,null,"Total Bill","2006-01-01",{"$f":"B3","v":109006.58000000002},{"$f":"E4-E3","v":23307.50999999998},null,null,"CPRC",1.7,"$/kW",{"$f":"ROUND((J10*(I3)),2)","v":4760},null,null,"CPRC",2.19,"$/kW",{"$f":"ROUND((P10*(O3)),2)","v":6132}]
[null,null,null,"2016-01-01",{"$f":"B4","v":84438.58},null,null,null,"Fuel",2.8769999999999998,"¢/kWh",{"$f":"ROUND(I2*(J11/100),2)","v":32343.23},null,null,"Fuel",6.1440000000000001,"¢/kWh",{"$f":"ROUND(O2*(P11/100),2)","v":69070.850000000006}]
[null,null,null,null,null,null,null,null,"Storm Surcharge",3.6999999999999998E-2,"¢/kWh",{"$f":"ROUND(I2*(J12/100),2)","v":415.95},null,null,"Storm Surcharge",0.122,"¢/kWh",{"$f":"ROUND(O2*(P12/100),2)","v":1371.52}]
[null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(L5:L12)","v":82327.62},null,null,"Subtotal",null,null,{"$f":"SUM(R5:R12)","v":106281.42000000001}]
[null,null,null,null,null,null,null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(L13*(J14/100),2)","v":2110.96},null,null,"Gross Tax Receipts",2.5640999999999998,"%",{"$f":"ROUND(R13*(P14/100),2)","v":2725.16}]
[null,null,null,null,null,null,null,null,"Total",null,null,{"$f":"SUM(L13:L14)","v":84438.58},null,null,"Total",null,null,{"$f":"SUM(R13:R14)","v":109006.58000000002}]