{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Summary Sheet for E-8","Projected Clauses 2017","Projected Clauses 2018","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":30,"defined_names":637,"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":"Summary Sheet for E-8","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["OPC 015242"]
["FPL RC-16"]
[]
["Clause Revenues by Rate Class for E-8 (Source: Clauses for E-8 Based on NOI)"]
[null,null,null,null,null,2017,2018]
["Rate Class",2017,2018,null,null,"Sales FC","Sales FC"]
["CILC-1D",{"$f":"('Projected Clauses 2017'!$L$17)*(F7/(F7+F8))","v":110216025.69267415},{"$f":"('Projected Clauses 2018'!$L$17)*(G7/(G7+G8))","v":115009352.76012599},null,null,2687420391,2686957625]
["CILC-1G",{"$f":"('Projected Clauses 2017'!$L$17)*(F8/($F$7+$F$8))","v":4167765.692677414},{"$f":"('Projected Clauses 2018'!$L$17)*(G8/($G$7+$G$8))","v":4344851.1436716821},null,null,101623502,101508535]
["CILC-1T",{"$f":"'Projected Clauses 2017'!L18","v":60677922.385759249},{"$f":"'Projected Clauses 2018'!L18","v":64417931.688298017},null,null,1508335314,1532421391]
["GS(T)-1",{"$f":"'Projected Clauses 2017'!L9","v":257107516.94213381},{"$f":"'Projected Clauses 2018'!L9","v":268699438.24941927},null,null,5968792122,6001791085]
["GSCU-1",{"$f":"'Projected Clauses 2017'!$L$21*(F11/($F$11+$F$21))","v":2862660.6520317723},{"$f":"'Projected Clauses 2018'!$L$21*(G11/($G$11+$G$21))","v":3025701.1359711592},null,null,70241818,71082174]
["GSD(T)-1",{"$f":"'Projected Clauses 2017'!L10","v":1088961735.3262069},{"$f":"'Projected Clauses 2018'!L10","v":1139148192.4710817},null,null,25825428784,25949742256]
["GSLD(T)-1",{"$f":"'Projected Clauses 2017'!L12","v":442230870.52000952},{"$f":"'Projected Clauses 2018'!L12","v":462823846.55001169},null,null,10507497706,10561627481]
["GSLD(T)-2",{"$f":"'Projected Clauses 2017'!L13","v":103114921.94674756},{"$f":"'Projected Clauses 2018'!L13","v":107448764.09143285},null,null,2515470925,2511431587]
["GSLD(T)-3",{"$f":"'Projected Clauses 2017'!L14","v":6994179.4044653075},{"$f":"'Projected Clauses 2018'!L14","v":7421866.0195363816},null,null,172992260,175782528]
["MET",{"$f":"'Projected Clauses 2017'!L19","v":3842212.8032636102},{"$f":"'Projected Clauses 2018'!L19","v":4002358.279443115},null,null,91208296,91241144]
["OL-1",{"$f":"'Projected Clauses 2017'!$L$20*(F17/($F$17+$F$20))","v":4592785.2663489496},{"$f":"'Projected Clauses 2018'!$L$20*(G17/($G$17+$G$20))","v":4777183.4540959587},null,null,97899984,97314768]
["OS-2",{"$f":"'Projected Clauses 2017'!L11","v":494478.0554778144},{"$f":"'Projected Clauses 2018'!L11","v":515905.71542106202},null,null,10793313,10819466]
["RS(T)-1",{"$f":"'Projected Clauses 2017'!L8","v":2491313329.0136585},{"$f":"'Projected Clauses 2018'!L8","v":2602418789.7453041},null,null,56993678507,57361215879]
["SL-1",{"$f":"'Projected Clauses 2017'!$L$20*(F20/($F$17+$F$20))","v":26309155.821398031},{"$f":"'Projected Clauses 2018'!$L$20*(G20/($G$17+$G$20))","v":28028448.119272713},null,null,560806958,570960264]
["SL-2",{"$f":"'Projected Clauses 2017'!$L$21*(F21/($F$11+$F$21))","v":1335220.0011029483},{"$f":"'Projected Clauses 2018'!$L$21*(G21/($G$11+$G$21))","v":1424066.9611859303},null,null,32762626,33455312]
["SST-DST",{"$f":"'Projected Clauses 2017'!L16","v":869455.95635394752},{"$f":"'Projected Clauses 2018'!L16","v":860801.61565699009},null,null,11856926,11856926]
["SST-TST",{"$f":"'Projected Clauses 2017'!L15","v":3204722.5264428789},{"$f":"'Projected Clauses 2018'!L15","v":3399965.4170814096},null,null,89667754,89667754]
[]
[null,{"$f":"SUM(B7:B23)","v":4608294958.006752},{"$f":"SUM(C7:C23)","v":4817767463.4170113},null,null,{"$f":"SUM(F7:F23)","v":107246477186},{"$f":"SUM(G7:G23)","v":107858876175}]

{"sheet":"Projected Clauses 2017","index":1,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["OPC 015243"]
["FPL RC-16"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Check Back "]
[null,null,null,null,null,null,null,null,null,null,null,null,"to E-8",null,null,"Storm Charge Calculation:"]
[null,null,null,"Allocated on Sales","Based on Projected 2017 Clause Allocations","Based on Projected 2017 Clause Allocations - less reclassed CILC/CDR Credits","Based on Projected 2017 Clause Allocations","Allocated based on March 2016 Storm Rate Allocations and 2017 Sales Forecast","Allocated Based on Total Clause Revenues","Allocated Based on Total Clause Revenues + GRT",null,null,"000s"]
[null,"2017 Forecasted Period Sales","2017 Forecasted Operating Base Revenues per MFR E-1","2017 Projected Fuel Clause Revenue","2017 Projected Capacity Clause Revenue","2017 Projected Energy Conservation Clause Revenue for E-8","2017 Projected Environmental Clause Revenue","2017 Projected Storm Clause Revenue","2017 Projected GRT Revenue","2017 Projected Franchise Revenue",null,"Total 2017 Projected Clause and Storm Revenue","Total 2017 Projected Clause and Storm Revenues  (Base & Clause",null,null,"Rate Classes for Storm Filings","Current Storm Rates (Effective March 1, 2016)","2017 Forecasted Sales","Storm Revenues based on 2016 Rates & 2017 Sales","Strom Revenues using Projected Storm Revenue Forecast"]
["RS1/RTR1",{"$f":"'[22]Forecast Summ by RC kWh'!C16","v":56993678507},{"$f":"'[22]E-8 Parity Analysis Final'!$C$24*1000","v":3652240399.2397504},{"$f":"$B8/$B$23*D$23","v":1682164365.7828786},{"$f":"'[23]2017 Capacity Calc'!T7","v":191468450},{"$f":"T29","v":40751726.301169418},{"$f":"'[24]FORMS 42-6P, 42-7P '!W16","v":121968984},{"$f":"T8","v":72416820.521804601},{"$f":"(SUM(D8:H8)/SUM($C$24:$H$24))*$I$23","v":132475858.65769863},{"$f":"(SUM(D8:I8)/SUM($C$24:$I$24))*$J$23","v":250067123.75010729},null,{"$f":"SUM(D8:J8)","v":2491313329.0136585},{"$f":"C8+L8","v":6143553728.2534084},null,null,"RS1/RTR1",1.34E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C16","v":56993678507},{"$f":"Q8*R8","v":76371529.199379995},{"$f":"$T$25*(S8/$S$24)","v":72416820.521804601}]
["GS1/GST1",{"$f":"'[22]Forecast Summ by RC kWh'!C7","v":5968792122},{"$f":"'[22]E-8 Parity Analysis Final'!$C$15*1000","v":381519718.45128447},{"$f":"B9/$B$23*$D$23","v":176168474.77498391},{"$f":"'[23]2017 Capacity Calc'!T8","v":18658538},{"$f":"T30","v":4050822.2617949229},{"$f":"'[24]FORMS 42-6P, 42-7P '!W17","v":11958979},{"$f":"T9","v":6791655.7758439258},{"$f":"(SUM(D9:H9)/SUM($D$24:$H$24))*$I$23","v":13671720.324212676},{"$f":"(SUM(D9:I9)/SUM($D$24:$I$24))*$J$23","v":25807326.805298399},null,{"$f":"SUM(D9:J9)","v":257107516.94213381},{"$f":"C9+L9","v":638627235.39341831},null,null,"GS1/GST1",1.1999999999999999E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C7","v":5968792122},{"$f":"Q9*R9","v":7162550.5463999994},{"$f":"$T$25*(S9/$S$24)","v":6791655.7758439258}]
["GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",{"$f":"'[22]Forecast Summ by RC kWh'!C9","v":25825428784},{"$f":"'[22]E-8 Parity Analysis Final'!$C$17*1000","v":1161081744.0947347},762235692.96676672,{"$f":"'[23]2017 Capacity Calc'!T9","v":74272988},16520932.049449939,{"$f":"'[24]FORMS 42-6P, 42-7P '!W18","v":47906347},20814904.999833938,57905659.337451376,109305210.97270508,null,1088961735.3262069,2250043479.4209414,null,null,"GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",8.5000000000000006E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C9","v":25825428784},21951614.466400001,20814904.999833938]
["OS2",{"$f":"'[22]Forecast Summ by RC kWh'!C15","v":10793313},{"$f":"'[22]E-8 Parity Analysis Final'!$C$23*1000","v":1027155.3834724165},318563.86520324624,{"$f":"'[23]2017 Capacity Calc'!T10","v":25966},6070.4670131497578,{"$f":"'[24]FORMS 42-6P, 42-7P '!W19","v":17904},50046.256461172154,26293.924663722402,49633.542136523887,null,494478.0554778144,1521633.4389502308,null,null,"OS2",4.8900000000000002E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C15","v":10793313},52779.300569999999,50046.256461172154]
["GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",{"$f":"'[22]Forecast Summ by RC kWh'!C10","v":10507497706},{"$f":"'[22]E-8 Parity Analysis Final'!$C$18*1000","v":389309710.69255412},310128047.13785315,{"$f":"'[23]2017 Capacity Calc'!T11","v":30042267},6692767.5156362839,{"$f":"'[24]FORMS 42-6P, 42-7P '!W20","v":19392567},8070348.5005905954,23515674.891152408,44389198.474777073,null,442230870.52000952,831540581.21256363,null,null,"GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",8.1000000000000006E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C10","v":10507497706},8511073.1418600008,8070348.5005905954]
["GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",{"$f":"'[22]Forecast Summ by RC kWh'!C11","v":2515470925},{"$f":"'[22]E-8 Parity Analysis Final'!$C$19*1000","v":79999169.596220881},74243945.364540547,{"$f":"'[23]2017 Capacity Calc'!T12","v":6284425},1457829.1808806474,{"$f":"'[24]FORMS 42-6P, 42-7P '!W21","v":4102744},1192606.7764597128,5483147.2485739924,10350224.376292655,null,103114921.94674756,183114091.54296845,null,null,"GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",5.0000000000000001E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C11","v":2515470925},1257735.4625000001,1192606.7764597128]
["GSLD3/GSLDT3/CS3/CST3",{"$f":"'[22]Forecast Summ by RC kWh'!C12","v":172992260},{"$f":"'[22]E-8 Parity Analysis Final'!$C$20*1000","v":4621044.7998609617},5105854.2447388424,{"$f":"'[23]2017 Capacity Calc'!T13","v":425012},98376.057513392865,{"$f":"'[24]FORMS 42-6P, 42-7P '!W22","v":277853},13122.743069738674,371916.25454007793,702045.10460325505,null,6994179.4044653075,11615224.204326268,null,null,"GSLD3/GSLDT3/CS3/CST3",8.0000000000000007E-5,{"$f":"'[22]Forecast Summ by RC kWh'!C12","v":172992260},13839.380800000001,13122.743069738674]
["SST1T",{"$f":"'[22]Forecast Summ by RC kWh'!C20","v":89667754},{"$f":"'[22]E-8 Parity Analysis Final'!$C$28*1000","v":4433565.7631138917},2646537.3790544057,{"$f":"'[23]2017 Capacity Calc'!T14","v":31511},7133.6986459511891,{"$f":"'[24]FORMS 42-6P, 42-7P '!W23","v":20651},6801.9626853972086,170411.47073149311,321676.0153256316,null,3204722.5264428789,7638288.2895567706,null,null,"SST1T",8.0000000000000007E-5,{"$f":"'[22]Forecast Summ by RC kWh'!C20","v":89667754},7173.4203200000002,6801.9626853972086]
["SST1D1/SST1D2/SST1D3",{"$f":"'[22]Forecast Summ by RC kWh'!C19","v":11856926},{"$f":"'[22]E-8 Parity Analysis Final'!$C$27*1000","v":822548.82356177154},349956.32721749716,{"$f":"'[23]2017 Capacity Calc'!T15","v":189998},46272.872192987197,{"$f":"'[24]FORMS 42-6P, 42-7P '!W24","v":129261},20462.159416895713,46233.415540967573,87272.181985599789,null,869455.95635394752,1692004.7799157191,null,null,"SST1D1/SST1D2/SST1D3",1.82E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C19","v":11856926},21579.605319999999,20462.159416895713]
["CILC D/CILC G",{"$f":"'[22]Forecast Summ by RC kWh'!C4+'[22]Forecast Summ by RC kWh'!C5","v":2789043893},{"$f":"('[22]E-8 Parity Analysis Final'!$C$12+'[22]E-8 Parity Analysis Final'!$C$13)*1000","v":93601980.856970176},82318432.049139053,{"$f":"'[23]2017 Capacity Calc'!T16","v":6978663},1617747.4922120145,{"$f":"'[24]FORMS 42-6P, 42-7P '!W25","v":4553052},{"$f":"T17+T18","v":1352182.0811575046},6082370.6130520366,11481344.149790939,null,114383791.38535155,207985772.24232173,null,null,"CILC G",8.1000000000000006E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C5","v":101623502},82315.036620000013,78052.558271999442]
["CILC T",{"$f":"'[22]Forecast Summ by RC kWh'!$C$6","v":1508335314},{"$f":"'[22]E-8 Parity Analysis Final'!$C$14*1000","v":36307353.897984095},44518409.468009688,{"$f":"'[23]2017 Capacity Calc'!T17","v":3560693},835161.19459582097,{"$f":"'[24]FORMS 42-6P, 42-7P '!W26","v":2332101},{"$f":"T19","v":114418.39530066609},3226555.1570749772,6090584.1707780929,null,60677922.385759249,96985276.283743352,null,null,"CILC D",5.0000000000000001E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C4","v":2687420391},1343710.1954999999,1274129.5228855051]
["MET",{"$f":"'[22]Forecast Summ by RC kWh'!C13","v":91208296},{"$f":"'[22]E-8 Parity Analysis Final'!$C$21*1000","v":4161010.871383768},2692006.3665680578,{"$f":"'[23]2017 Capacity Calc'!T18","v":258369},57365.08052589187,{"$f":"'[24]FORMS 42-6P, 42-7P '!W27","v":166661},{"$f":"T20","v":77836.772206817681},204310.08590134649,385664.49806149618,null,3842212.8032636102,8003223.6746473778,null,null,"CILC T",8.0000000000000007E-5,{"$f":"'[22]Forecast Summ by RC kWh'!$C$6","v":1508335314},120666.82512000001,114418.39530066609]
["OL1/SL1/PL1",{"$f":"'[22]Forecast Summ by RC kWh'!C14+'[22]Forecast Summ by RC kWh'!C17","v":658706942},{"$f":"('[22]E-8 Parity Analysis Final'!$C$22+'[22]E-8 Parity Analysis Final'!$C$25)*1000","v":107255997.55420877},19441688.523230128,{"$f":"'[23]2017 Capacity Calc'!T19","v":683363},232799.37445215814,{"$f":"'[24]FORMS 42-6P, 42-7P '!W28","v":524435},{"$f":"T21+T22","v":5274639.5518361377},1643214.0960003887,3101801.5422281642,null,30901941.087746978,138157938.64195573,null,null,"MET",8.9999999999999998E-4,{"$f":"'[22]Forecast Summ by RC kWh'!C13","v":91208296},82087.466400000005,77836.772206817681]
["SL2, GSCU1",{"$f":"'[22]Forecast Summ by RC kWh'!C18+'[22]Forecast Summ by RC kWh'!C8","v":103004444},{"$f":"('[22]E-8 Parity Analysis Final'!$C$26+'[22]E-8 Parity Analysis Final'!$C$16)*1000","v":5823662.0579830827},3040168.8354401775,{"$f":"'[23]2017 Capacity Calc'!T20","v":245374},57974.86723798365,{"$f":"'[24]FORMS 42-6P, 42-7P '!W29","v":160940},{"$f":"T23","v":48835.308211668154},223222.76270513778,421364.87953975296,null,{"$f":"SUM(D21:J21)","v":4197880.6531347204},10021542.711117804,null,null,"SL1/PL1",8.43E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C17","v":560806958},4727602.65594,4482795.5734634288]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OL",8.5299999999999994E-3,{"$f":"'[22]Forecast Summ by RC kWh'!C14","v":97899984},835086.8635199999,791843.97837270889]
["Total",{"$f":"SUM(B8:B21)","v":107246477186},{"$f":"SUM(C8:C21)","v":5922205062.0830841},{"$f":"B33","v":3165372143.0856242},{"$f":"B34","v":333125619.24357873},{"$f":"B36+B37","v":72432979.400157839},{"$f":"B35","v":213512478.91206494},{"$f":"B38","v":116244681.80487876},{"$f":"B40","v":245046588.23929924},{"$f":"B39","v":462560470.46362996},null,{"$f":"B41","v":4608294961.1492338},{"$f":"SUM(M8:M21)","v":10530500020.089836},null,null,"SL2, GSCU1",5.0000000000000001E-4,{"$f":"'[22]Forecast Summ by RC kWh'!$C$18+'[22]Forecast Summ by RC kWh'!$C$8","v":103004444},51502.222000000002,48835.308211668154]
[null,null,null,{"$f":"SUM(D8:D21)","v":3165372143.0856242},333125617,{"$f":"SUM(F8:F21)","v":72432978.413320556},{"$f":"SUM(G8:G21)","v":213512479},116244681.80487876,245046588.23929927,462560470.4636299,null,{"$f":"SUM(L8:L21)","v":4608294958.006752},null,null,null,null,null,{"$f":"SUM(R8:R23)","v":107246477186},{"$f":"SUM(S8:S23)","v":122592845.78864999},{"$f":"SUM(T8:T23)","v":116244681.80487876}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":116244681.80487876}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conservation Calculations (to remove CDR/CILC Credits Reclassed to Base):"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017 Projected Energy Conservation Clause Revenue","Removed CILC/CDR Credits reclassed to Base","2017 Projected Energy Conservation Clause Revenue for E-8"]
["Clause Revenue Requiremenets Provided by Jason Chin & Craig Martin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS1/RTR1",null,{"$f":"'[25]page 2& 3'!W11","v":75851455},{"$f":"$S$45*(R29/$R$44)","v":-35099728.698830582},{"$f":"R29+S29","v":40751726.301169418}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS1/GST1",null,{"$f":"'[25]page 2& 3'!W12","v":7539822},{"$f":"$S$45*(R30/$R$44)","v":-3488999.7382050771},{"$f":"R30+S30","v":4050822.2617949229}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",null,{"$f":"'[25]page 2& 3'!W13","v":30750519},-14229586.950550061,16520932.049449939]
[null,"2017 Revenue Requirements (per NOI)",null,null,null,null,null,null,null,null,null,null,null,null,null,"OS2",null,{"$f":"'[25]page 2& 3'!W14","v":11299},-5228.5329868502422,6070.4670131497578]
["Fuel",{"$f":"'[26]Summary of Clause Balances'!$B$2","v":3165372143.0856242},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",null,{"$f":"'[25]page 2& 3'!W15","v":12457292},-5764524.4843637161,6692767.5156362839]
["Capacity",{"$f":"'[26]Summary of Clause Balances'!$B$3","v":333125619.24357873},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",null,{"$f":"'[25]page 2& 3'!W16","v":2713467},-1255637.8191193526,1457829.1808806474]
["Environmental ",{"$f":"'[26]Summary of Clause Balances'!$B$6","v":213512478.91206494},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD3/GSLDT3/CS3/CST3",null,{"$f":"'[25]page 2& 3'!W17","v":183108},-84731.942486607135,98376.057513392865]
["Conservation",{"$f":"'[26]Summary of Clause Balances'!$B$4","v":134819977.98683727},null,null,null,null,null,null,null,null,null,null,null,null,null,"SST1T",null,{"$f":"'[25]page 2& 3'!W18","v":13278},-6144.3013540488109,7133.6986459511891]
["CILC Credits reclassed to Base",{"$f":"'[26]Summary of Clause Balances'!$B$5","v":-62386998.586679436},null,null,null,null,null,null,null,null,null,null,null,null,null,"SST1D1/SST1D2/SST1D3",null,{"$f":"'[25]page 2& 3'!W19","v":86128},-39855.127807012803,46272.872192987197]
["Storm",{"$f":"'[26]Summary of Clause Balances'!$B$9","v":116244681.80487876},null,null,null,null,null,null,null,null,null,null,null,null,null,"CILC D/CILC G",null,{"$f":"'[25]page 2& 3'!W20","v":3011124},-1393376.5077879855,1617747.4922120145]
["Franchise Fees",{"$f":"'[26]Summary of Clause Balances'!$B$8","v":462560470.46362996},null,null,null,null,null,null,null,null,null,null,null,null,null,"CILC T",null,{"$f":"'[25]page 2& 3'!W21","v":1554491},-719329.80540417903,835161.19459582097]
["GRT",{"$f":"'[26]Summary of Clause Balances'!$B$7","v":245046588.23929924},null,null,null,null,null,null,null,null,null,null,null,null,null,"MET",null,{"$f":"'[25]page 2& 3'!W22","v":106774},-49408.91947410813,57365.08052589187]
[null,{"$f":"SUM(B33:B40)","v":4608294961.1492338},null,null,null,null,null,null,null,null,null,null,null,null,null,"OL1/SL1/PL1",null,{"$f":"'[25]page 2& 3'!W23","v":433311},-200511.62554784186,232799.37445215814]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL2, GSCU1",null,{"$f":"'[25]page 2& 3'!W24","v":107909},-49934.13276201635,57974.86723798365]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R29:R42)","v":134819977},{"$f":"SUM(S29:S42)","v":-62386998.586679436},{"$f":"SUM(T29:T42)","v":72432978.413320556}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B37","v":-62386998.586679436}]

{"sheet":"Projected Clauses 2018","index":2,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["OPC 015244"]
["FPL RC-16"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Check Back "]
[null,null,null,null,null,null,null,null,null,null,null,null,"to E-8",null,null,"Storm Charge Calculation:"]
[null,null,null,"Allocated on Sales","Based on Projected 2017 Clause Allocations","Based on Projected 2017 Clause Allocations - less reclassed CILC/CDR Credits","Based on Projected 2017 Clause Allocations","Allocated based on March 2016 Storm Rate Allocations and 2017 Sales Forecast","Allocated Based on Total Clause Revenues","Allocated Based on Total Clause Revenues + GRT",null,null,"000s"]
[null,"2018 Forecasted Period Sales","2018 Forecasted Operating Base Revenues per MFR  E-1","2018 Projected Fuel Clause Revenue","2018 Projected Capacity Clause Revenue","2018 Projected Energy Conservation Clause Revenue for E-8","2018 Projected Environmental Clause Revenue","2018 Projected Storm Clause Revenue","2018 Projected GRT Revenue","2018 Projected Franchise Revenue",null,"Total 2017 Projected Clause and Storm Revenue","Total 2017 Projected Clause and Storm Revenues  (Base & Clause",null,null,"Rate Classes for Storm Filings","Current Storm Rates (Effective March 1, 2016)","2018 Forecasted Sales","Storm Revenues based on 2016 Rates & 2018 Sales","Strom Revenues using Projected Storm Revenue Forecast"]
["RS1/RTR1",{"$f":"'[27]Forecast Summ by RC kWh'!C16","v":57361215879},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$24*1000","v":3680682306.9210405},{"$f":"$B8/$B$23*D$23","v":1807556254.6870692},{"$f":"'[23]2018 Capacity Calc'!T7","v":178160183},{"$f":"T29","v":40308892.661848873},{"$f":"'[28]FORMS 42-6P, 42-7P '!W16","v":109596102},{"$f":"T8","v":74235913.861675113},{"$f":"(SUM(D8:H8)/SUM($C$24:$H$24))*$I$23","v":135432589.70572329},{"$f":"(SUM(D8:I8)/SUM($C$24:$I$24))*$J$23","v":257128853.82898745},null,{"$f":"SUM(D8:J8)","v":2602418789.7453041},{"$f":"C8+L8","v":6283101096.6663446},null,null,"RS1/RTR1",1.34E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C16","v":57361215879},{"$f":"Q8*R8","v":76864029.277860001},{"$f":"$T$25*(S8/$S$24)","v":74235913.861675113}]
["GS1/GST1",{"$f":"'[27]Forecast Summ by RC kWh'!C7","v":6001791085},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$15*1000","v":384085668.32176769},{"$f":"B9/$B$23*$D$23","v":189127354.58574051},{"$f":"'[23]2018 Capacity Calc'!T8","v":17345517},{"$f":"T30","v":4003100.9047802459},{"$f":"'[28]FORMS 42-6P, 42-7P '!W17","v":10735647},{"$f":"T9","v":6955895.2376726232},{"$f":"(SUM(D9:H9)/SUM($D$24:$H$24))*$I$23","v":13983399.181556573},{"$f":"(SUM(D9:I9)/SUM($D$24:$I$24))*$J$23","v":26548524.339669313},null,{"$f":"SUM(D9:J9)","v":268699438.24941927},{"$f":"C9+L9","v":652785106.57118702},null,null,"GS1/GST1",1.1999999999999999E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C7","v":6001791085},{"$f":"Q9*R9","v":7202149.3019999992},{"$f":"$T$25*(S9/$S$24)","v":6955895.2376726232}]
["GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",{"$f":"'[27]Forecast Summ by RC kWh'!C9","v":25949742256},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$17*1000","v":1166608342.2865608},817723582.10283923,{"$f":"'[23]2018 Capacity Calc'!T9","v":68997149},16314689.640319124,{"$f":"'[28]FORMS 42-6P, 42-7P '!W18","v":42975042},21303103.956500165,59282460.752618268,112552165.01880491,null,1139148192.4710817,2305756534.7576427,null,null,"GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",8.5000000000000006E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C9","v":25949742256},22057280.917600002,21303103.956500165]
["OS2",{"$f":"'[27]Forecast Summ by RC kWh'!C15","v":10819466},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$23*1000","v":1028127.0117544744},340941.05470023432,{"$f":"'[23]2018 Capacity Calc'!T10","v":24052},5978.7465560694327,{"$f":"'[28]FORMS 42-6P, 42-7P '!W19","v":16014},51098.199546212731,26848.271830336918,50973.442788208653,null,515905.71542106202,1544032.7271755363,null,null,"OS2",4.8900000000000002E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C15","v":10819466},52907.188740000005,51098.199546212731]
["GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",{"$f":"'[29]Forecast Summ by RC kWh'!C10","v":10561627481},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$18*1000","v":391311626.60109001},332816093.94799328,{"$f":"'[23]2018 Capacity Calc'!T11","v":27917512},6611408.2891220134,{"$f":"'[28]FORMS 42-6P, 42-7P '!W20","v":17401833},8262410.6617971612,24085835.977985289,45728752.673113994,null,462823846.55001169,854135473.15110171,null,null,"GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",8.1000000000000006E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C10","v":10561627481},8554918.259610001,8262410.6617971612]
["GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",{"$f":"'[29]Forecast Summ by RC kWh'!C11","v":2511431587},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$19*1000","v":79877247.028740644},79139777.700605854,{"$f":"'[23]2018 Capacity Calc'!T12","v":5800800},1430433.1858531702,{"$f":"'[28]FORMS 42-6P, 42-7P '!W21","v":3656881},1212780.6772141461,5591745.8169775484,10616345.710782135,null,107448764.09143285,187326011.12017351,null,null,"GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",5.0000000000000001E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C11","v":2511431587},1255715.7934999999,1212780.6772141461]
["GSLD3/GSLDT3/CS3/CST3",{"$f":"'[29]Forecast Summ by RC kWh'!C12","v":175782528},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$20*1000","v":4689899.1636103261},5539227.2127102641,{"$f":"'[23]2018 Capacity Calc'!T13","v":399236},98236.844195103869,{"$f":"'[28]FORMS 42-6P, 42-7P '!W22","v":252034},13581.777306857113,386241.65312497399,733308.5321991815,null,7421866.0195363816,12111765.183146708,null,null,"GSLD3/GSLDT3/CS3/CST3",8.0000000000000007E-5,{"$f":"'[27]Forecast Summ by RC kWh'!C12","v":175782528},14062.602240000002,13581.777306857113]
["SST1T",{"$f":"'[27]Forecast Summ by RC kWh'!C20","v":89667754},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$28*1000","v":4435542.8136063758},2825594.037761305,{"$f":"'[23]2018 Capacity Calc'!T14","v":29128},7010.9945834420178,{"$f":"'[28]FORMS 42-6P, 42-7P '!W23","v":18437},6928.1485497469121,176937.74851291336,335929.48767400271,null,3399965.4170814096,7835508.2306877859,null,null,"SST1T",8.0000000000000007E-5,{"$f":"'[27]Forecast Summ by RC kWh'!C20","v":89667754},7173.4203200000002,6928.1485497469121]
["SST1D1/SST1D2/SST1D3",{"$f":"'[27]Forecast Summ by RC kWh'!C19","v":11856926},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$27*1000","v":823480.36261404271},373633.30648135784,{"$f":"'[23]2018 Capacity Calc'!T15","v":175631},45472.067067801196,{"$f":"'[28]FORMS 42-6P, 42-7P '!W24","v":115376},20841.76092191803,44797.014412390738,85050.466773522043,null,860801.61565699009,1684281.9782710327,null,null,"SST1D1/SST1D2/SST1D3",1.82E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C19","v":11856926},21579.605319999999,20841.76092191803]
["CILC D/CILC G",{"$f":"'[27]Forecast Summ by RC kWh'!C4+'[27]Forecast Summ by RC kWh'!C5","v":2788466160},{"$f":"('[27]E-8 Parity Analysis (2)'!$C$12+'[27]E-8 Parity Analysis (2)'!$C$13)*1000","v":93581209.405946359},87869641.032774836,{"$f":"'[23]2018 Capacity Calc'!T16","v":6450294},1589513.6628748744,{"$f":"'[28]FORMS 42-6P, 42-7P '!W25","v":4063836},{"$f":"T17+T18","v":1376953.5278215506},6211317.3293443155,11792648.350982085,null,119354203.90379767,212935413.30974403,null,null,"CILC G",8.1000000000000006E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C5","v":101508535},82221.913350000003,79410.602518997344]
["CILC T",{"$f":"'[27]Forecast Summ by RC kWh'!$C$6","v":1532421391},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$14*1000","v":36661168.141376041},48289385.566047363,{"$f":"'[23]2018 Capacity Calc'!T17","v":3344144},833831.56527483545,{"$f":"'[28]FORMS 42-6P, 42-7P '!W26","v":2115056},{"$f":"T19","v":118402.01816204513},3352376.3916899827,6364736.1471237885,null,64417931.688298017,101079099.82967407,null,null,"CILC D",5.0000000000000001E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C4","v":2686957625},1343478.8125,1297542.9253025532]
["MET",{"$f":"'[27]Forecast Summ by RC kWh'!C13","v":91241144},{"$f":"'[27]E-8 Parity Analysis (2)'!$C$21*1000","v":4161445.8909158427},2875174.4187204759,{"$f":"'[23]2018 Capacity Calc'!T18","v":238927},56391.465227592656,{"$f":"'[28]FORMS 42-6P, 42-7P '!W27","v":148821},{"$f":"T20","v":79309.304927605888},208286.90172813187,395448.18883930874,null,4002358.279443115,8163804.1703589577,null,null,"CILC T",8.0000000000000007E-5,{"$f":"'[27]Forecast Summ by RC kWh'!$C$6","v":1532421391},122593.71128,118402.01816204513]
["OL1/SL1/PL1",{"$f":"'[27]Forecast Summ by RC kWh'!C14+'[27]Forecast Summ by RC kWh'!C17","v":668275032},{"$f":"('[27]E-8 Parity Analysis (2)'!$C$22+'[27]E-8 Parity Analysis (2)'!$C$25)*1000","v":113673252.03852355},21058561.877260193,{"$f":"'[23]2018 Capacity Calc'!T19","v":641040},232131.42611845824,{"$f":"'[28]FORMS 42-6P, 42-7P '!W28","v":475002},{"$f":"T21+T22","v":5450336.0546797588},1707239.3030746554,3241320.9122356051,null,32805631.573368672,146478883.61189222,null,null,"MET",8.9999999999999998E-4,{"$f":"'[27]Forecast Summ by RC kWh'!C13","v":91241144},82117.029599999994,79309.304927605888]
["SL2, GSCU1",{"$f":"'[27]Forecast Summ by RC kWh'!C18+'[27]Forecast Summ by RC kWh'!C8","v":104537486},{"$f":"('[27]E-8 Parity Analysis (2)'!$C$26+'[27]E-8 Parity Analysis (2)'!$C$16)*1000","v":5909606.37901113},3294166.3417169554,{"$f":"'[23]2018 Capacity Calc'!T20","v":230237},57826.619539593681,{"$f":"'[28]FORMS 42-6P, 42-7P '!W29","v":145832},{"$f":"T23","v":50481.583381209712},231570.57555939074,439653.97695993999,null,{"$f":"SUM(D21:J21)","v":4449768.097157089},10359374.476168219,null,null,"SL1/PL1",8.43E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C17","v":570960264},4813195.0255199997,4648623.4805916734]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OL",8.5299999999999994E-3,{"$f":"'[27]Forecast Summ by RC kWh'!C14","v":97314768},830094.97103999997,801712.57408808579]
["Total",{"$f":"SUM(B8:B21)","v":107858876175},{"$f":"SUM(C8:C21)","v":5967528922.366559},{"$f":"B33","v":3398829387.8724213},{"$f":"B34","v":309753849.86643761},{"$f":"B36+B37","v":71594917.356305301},{"$f":"B35","v":191715913.41084468},{"$f":"B38","v":119138036.77015612},{"$f":"B40","v":250721646.62413806},{"$f":"B39","v":476013711.07693344},null,{"$f":"B41","v":4817767462.9772367},{"$f":"SUM(M8:M21)","v":10785296385.783569},null,null,"SL2, GSCU1",5.0000000000000001E-4,{"$f":"'[27]Forecast Summ by RC kWh'!$C$18+'[27]Forecast Summ by RC kWh'!$C$8","v":104537486},52268.743000000002,50481.583381209712]
[null,null,null,{"$f":"SUM(D8:D21)","v":3398829387.8724208},309753850,{"$f":"SUM(F8:F21)","v":71594918.073361188},{"$f":"SUM(G8:G21)","v":191715913},119138036.77015615,250721646.62413809,476013711.07693344,null,{"$f":"SUM(L8:L21)","v":4817767463.4170113},null,null,null,null,null,{"$f":"SUM(R8:R23)","v":107858876175},{"$f":"SUM(S8:S23)","v":123355786.57348001},{"$f":"SUM(T8:T23)","v":119138036.77015612}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":119138036.77015612}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conservation Calculations (to remove CDR/CILC Credits Reclassed to Base:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018 Projected Energy Conservation Clause Revenue","Removed CILC/CDR Credits reclassed to Base","2018 Projected Energy Conservation Clause Revenue for E-8"]
["Clause Revenue Requiremenets Provided by Jason Chin & Craig Martin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RS1/RTR1",null,{"$f":"'[30]page 2& 3'!$W11","v":75834361},{"$f":"$S$45*(R29/$R$44)","v":-35525468.338151127},{"$f":"R29+S29","v":40308892.661848873}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GS1/GST1",null,{"$f":"'[30]page 2& 3'!$W12","v":7531157},{"$f":"$S$45*(R30/$R$44)","v":-3528056.0952197541},{"$f":"R30+S30","v":4003100.9047802459}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GSD1/GSDT1/HLFT1 (21-499 kW)/SDTR 1A/SDTR 1B",null,{"$f":"'[30]page 2& 3'!$W13","v":30693328},-14378638.359680876,16314689.640319124]
[null,"2018 Revenue Requirements (per NOI)",null,null,null,null,null,null,null,null,null,null,null,null,null,"OS2",null,{"$f":"'[30]page 2& 3'!$W14","v":11248},-5269.2534439305673,5978.7465560694327]
["Fuel",{"$f":"'[26]Summary of Clause Balances'!$C$2","v":3398829387.8724213},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD1/GSLDT1/CS1/CST1/HLFT2 (500-1,999 kW)/SDTR 2A/SDTR 2B",null,{"$f":"'[30]page 2& 3'!$W15","v":12438246},-5826837.7108779866,6611408.2891220134]
["Capacity",{"$f":"'[26]Summary of Clause Balances'!$C$3","v":309753849.86643761},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD2/GSLDT2/CS2/CST2/HLFT3(2,000+ kW)/SDTR 3A/SDTR 3B",null,{"$f":"'[30]page 2& 3'!$W16","v":2691118},-1260684.8141468298,1430433.1858531702]
["Environmental ",{"$f":"'[26]Summary of Clause Balances'!$C$6","v":191715913.41084468},null,null,null,null,null,null,null,null,null,null,null,null,null,"GSLD3/GSLDT3/CS3/CST3",null,{"$f":"'[30]page 2& 3'!$W17","v":184816},-86579.155804896131,98236.844195103869]
["Conservation",{"$f":"'[26]Summary of Clause Balances'!$C$4","v":134693723.28294411},null,null,null,null,null,null,null,null,null,null,null,null,null,"SST1T",null,{"$f":"'[30]page 2& 3'!$W18","v":13190},-6179.0054165579822,7010.9945834420178]
["CILC Credits reclassed to Base",{"$f":"'[26]Summary of Clause Balances'!$C$5","v":-63098805.926638804},null,null,null,null,null,null,null,null,null,null,null,null,null,"SST1D1/SST1D2/SST1D3",null,{"$f":"'[30]page 2& 3'!$W19","v":85548},-40075.932932198804,45472.067067801196]
["Storm",{"$f":"'[26]Summary of Clause Balances'!$C$9","v":119138036.77015612},null,null,null,null,null,null,null,null,null,null,null,null,null,"CILC D/CILC G",null,{"$f":"'[30]page 2& 3'!$W20","v":2990401},-1400887.3371251256,1589513.6628748744]
["Franchise Fees",{"$f":"'[26]Summary of Clause Balances'!$C$8","v":476013711.07693344},null,null,null,null,null,null,null,null,null,null,null,null,null,"CILC T",null,{"$f":"'[30]page 2& 3'!$W21","v":1568713},-734881.43472516455,833831.56527483545]
["GRT",{"$f":"'[26]Summary of Clause Balances'!$C$7","v":250721646.62413806},null,null,null,null,null,null,null,null,null,null,null,null,null,"MET",null,{"$f":"'[30]page 2& 3'!$W22","v":106091},-49699.534772407344,56391.465227592656]
[null,{"$f":"SUM(B33:B40)","v":4817767462.9772367},null,null,null,null,null,null,null,null,null,null,null,null,null,"OL1/SL1/PL1",null,{"$f":"'[30]page 2& 3'!$W23","v":436716},-204584.57388154176,232131.42611845824]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SL2, GSCU1",null,{"$f":"'[30]page 2& 3'!$W24","v":108791},-50964.380460406319,57826.619539593681]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(R29:R42)","v":134693724},{"$f":"SUM(S29:S42)","v":-63098805.926638804},{"$f":"SUM(T29:T42)","v":71594918.073361188}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B37","v":-63098805.926638804}]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}