{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Generic"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":181,"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":"Generic","index":0,"n_rows":93,"n_cols":28,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Project Size & Subscription Assumptions"]
[]
[null,"Res","Sml Com","Lrg Com"]
["Energy Charge",48.5,{"$f":"B9","v":48.5},{"$f":"C9","v":48.5},"$/MWH",null,"Discount Rate (Retail)",6.6600000000000006E-2]
["Subscription Charge",16.716457601426139,{"$f":"+B10-3","v":13.716457601426139},{"$f":"+B10-6","v":10.716457601426139},"$/MWH",null,"Income Taxes",0.37951000000000001]
[{"$f":"\"kWh / Subscription (month)\"","v":"kWh / Subscription (month)"},{"$f":"ROUND(AVERAGEIF($F$65:$AA$65,\"<>0\")*8760/12*D16,-2)","v":200}]
[null,null,null,null,null,0,{"$f":"F12+1","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
["Calendar Year",null,null,null,"Total",2015,{"$f":"F13+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[]
["Project Size (kW)",null,null,20000,null,0,0,{"$f":"$D$15","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
["Subscription Size (kW per Subscription)",null,null,1,null,0,0,{"$f":"$D$16","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Subscription Rate (%)",null,null,null,null,0,0,0.5,0.75,1,1,{"$f":"K17","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["Subscription per Participant"]
["Residential",null,null,2,null,0,0,{"$f":"$D$20","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["Small Commercial",null,null,4,null,0,0,{"$f":"$D$21","v":4},{"$f":"$D$21","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[]
["Number of Customers Subscribed"]
["Residential",null,null,null,null,{"$f":"$D$15*$C29/$D20*F$17","v":0},0,1500,2250,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000]
["Small Commercial",null,null,null,null,{"$f":"$D$15*$C30/$D21*F$17","v":0},0,750,1125,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500,1500]
["Total Customers (for billing fee)",null,null,null,null,{"$f":"SUM(F24:F25)","v":0},0,2250,3375,{"$f":"SUM(J24:J25)","v":4500},{"$f":"SUM(K24:K25)","v":4500},4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500,4500]
[]
["Energy Subscribed by Customer Class MWh"]
["Residential",null,0.3,{"$f":"+NPV(Discount_Rate,F29:AD29)*(1+Discount_Rate)^(0.5)","v":133226.2722395295},{"$f":"SUM(F29:AD29)","v":277200},{"$f":"$D$15*Block*12*F$17/1000*$C29","v":0},0,7200,10800,14400,14400,14400,14400,14400,14400,{"$f":"$D$15*Block*12*P$17/1000*$C29","v":14400},14400,14400,14400,14400,14400,14400,14400,14400,14400,{"$f":"$D$15*Block*12*Z$17/1000*$C29","v":14400},14400]
["Small Commercial",null,0.3,{"$f":"+NPV(Discount_Rate,F30:AD30)*(1+Discount_Rate)^(0.5)","v":133226.2722395295},{"$f":"SUM(F30:AD30)","v":277200},0,0,7200,10800,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400,14400]
["Large Commercial",null,{"$f":"1-C29-C30","v":0.39999999999999997},{"$f":"+NPV(Discount_Rate,F31:AD31)*(1+Discount_Rate)^(0.5)","v":177635.02965270606},{"$f":"SUM(F31:AD31)","v":369600},0,0,9600,14399.999999999998,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200,19200]
["Total",null,{"$f":"SUM(C29:C31)","v":1},{"$f":"+NPV(Discount_Rate,F32:AD32)*(1+Discount_Rate)^(0.5)","v":444087.574131765},{"$f":"SUM(F32:AD32)","v":924000},{"$f":"SUM(F29:F31)","v":0},{"$f":"SUM(G29:G31)","v":0},24000,36000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000,48000]
[]
[]
[]
["General Revenue Increase (Decrease)",null,null,null,null,"(Thousands of Dollars)"]
[]
["Subscription Charge by Customer Class $/MWh"]
["Contract Price - Residential",null,null,null,null,0,0,{"$f":"$B$9+$B$10","v":65.216457601426143},65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143,65.216457601426143]
["Contract Price - Small Commercial",null,null,null,null,0,0,{"$f":"$C$9+$C$10","v":62.216457601426143},62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143,62.216457601426143]
["Contract Price  - Large Commercial",null,null,null,null,0,0,{"$f":"$D$9+$D$10","v":59.216457601426143},59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143,59.216457601426143]
[]
["Subscription Revenue"]
["Contract Price - Residential",null,null,null,{"$f":"SUM(F44:AD44)","v":18078.002047115333},{"$f":"(F29*F39)/1000","v":0},0,469.55849473026825,704.33774209540229,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365,939.1169894605365]
["Contract Price - Small Commercial",null,null,null,{"$f":"SUM(F45:AD45)","v":17246.402047115327},0,0,447.95849473026823,671.93774209540231,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646,895.91698946053646]
["Contract Price  - Large Commercial",null,null,null,{"$f":"SUM(F46:AD46)","v":21886.402729487094},0,0,568.47799297369102,852.71698946053641,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382,1136.955985947382]
[{"$f":"\"Total \"&A43","v":"Total Subscription Revenue"},null,null,{"$f":"+NPV(Discount_Rate,F47:AD47)*(1+Discount_Rate)^(0.5)","v":27496.329455049614},{"$f":"SUM(F47:AD47)","v":57210.806823717736},{"$f":"SUM(F44:F46)","v":0},{"$f":"SUM(G44:G46)","v":0},1485.9949824342275,2228.9924736513408,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455]
[]
[]
["General Revenue Increase (Decrease)",null,null,{"$f":"+NPV(Discount_Rate,F50:AD50)*(1+Discount_Rate)^(0.5)","v":27496.329455049614},{"$f":"SUM(F50:AD50)","v":57210.806823717736},{"$f":"F47","v":0},0,1485.9949824342275,2228.9924736513408,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455,2971.989964868455]
[]
[]
["Expense Increase (Decrease)",null,null,null,null,"(Thousands of Dollars)"]
[null,null,null,null,null,{"$f":"F12","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
["Calendar Year",null,null,null,"Total",{"$f":"F13","v":2015},{"$f":"F55+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
[]
["Program Costs","Start-up","Year 1-3","On-Going"]
["Administration",10,366,112,{"$f":"SUM(F58:AD58)","v":3763.5401229642698},10,{"$f":"C58","v":366},{"$f":"$C58*H$93","v":384.98400275999995},{"$f":"$C58*I$93","v":392.29869881243991},{"$f":"$D58*J$93","v":122.20854766065339},{"$f":"$D58*K$93","v":124.53051006620579},127.02112026752991,129.56154267288051,{"$f":"$D58*N$93","v":132.15277352633811},134.9279817703912,137.62654140579903,140.379072233915,143.18665367859333,145.90720009848658,148.67943690035781,151.50434620146459,154.3829287792924,{"$f":"$D58*W$93","v":157.31620442609892},160.46252851462091,163.5113165563987,166.78154288752665,170.1171737452772]
["Marketing",38,350,110,{"$f":"SUM(F59:AD59)","v":3676.7947106431188},{"$f":"B59","v":38},{"$f":"C59","v":350},350,{"$f":"$C59*I$93","v":375.14902891899987},{"$f":"$D59*J$93","v":120.02625216671316},{"$f":"$D59*K$93","v":122.30675095788068},{"$f":"$D59*L$93","v":124.7528859770383},127.24794369657907,129.79290257051065,132.51855352449135,135.16892459498118,137.87230308688081,140.62974914861843,143.30171438244219,146.02444695570856,148.798911447867,151.62609076537646,154.5069864899186,157.59712621971696,160.59147161789156,163.80330105024942,167.07936707125438]
["Billing",900,0,0,{"$f":"SUM(F60:AD60)","v":960},60,{"$f":"$B60","v":900},{"$f":"$C60*H$26*12/1000*H$93","v":0},{"$f":"$C60*I$26*12/1000*I$93","v":0},{"$f":"$C60*J$26*12/1000*J$93","v":0},{"$f":"$C60*K$26*12/1000*K$93","v":0},{"$f":"$D60*L$26*12/1000*L$93","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"\"Total \"&A57","v":"Total Program Costs"},null,null,{"$f":"+NPV(Discount_Rate,F61:AD61)*(1+Discount_Rate)^(0.5)","v":5097.2070456141837},{"$f":"SUM(F61:AD61)","v":8400.3348336073886},{"$f":"SUM(F58:F60)","v":108},1616,734.98400275999995,767.44772773143973,242.23479982736654,246.83726102408647,251.77400624456823,256.80948636945959,261.94567609684873,267.44653529488255,272.79546600078021,278.25137532079577,283.81640282721173,289.2089144809288,294.70388385606634,300.30325764933161,306.00901954466883,311.82319091601755,318.05965473433787,324.10278817429025,330.5848439377761,337.19654081653158]
[]
["Cost of Goods Sold Increase (Decrease)"]
["Purchased Capacity (kW)",2017,null,{"$f":"D15","v":20000},{"$f":"SUM(F64:AD64)","v":400000},0,0,{"$f":"$D$64","v":20000},{"$f":"$D$64","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]
["Capacity Factor (Annual)",{"$f":"B64","v":2017},null,null,null,null,null,0.30674400000000002,0.304309,0.30188700000000002,0.299485,0.297101,0.29473700000000003,0.29239100000000001,0.29006399999999999,0.28775600000000001,0.285466,0.28314699999999998,0.28084799999999999,0.27856700000000001,0.27630500000000002,0.274061,0.27183499999999999,0.26962700000000001,0.26743800000000001,0.265266,0.26311099999999998]
["Power Purchased (MWh)",{"$f":"B64","v":2017},null,{"$f":"+NPV(Discount_Rate,F66:AD66)*(1+Discount_Rate)^(0.5)","v":500634.31998986745},{"$f":"SUM(F66:AD66)","v":996913.4040000001},{"$f":"F64*F65*8760/1000","v":0},0,53741.548800000004,53314.936800000003,52890.602400000003,52469.771999999997,52052.095200000003,51637.922400000003,51226.903200000001,50819.212799999994,50414.851199999997,50013.643199999999,49607.354399999997,49204.569600000003,48804.938399999999,48408.635999999999,48015.487200000003,47625.491999999998,47238.650399999999,46855.137600000002,46474.603199999998,46097.047199999994]
[]
["PPA Contract Price ($/MWh)",null,null,{"$f":"D$89","v":43.04},null,0,0,{"$f":"$B$9","v":48.5},{"$f":"$B$9","v":48.5},48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5,48.5]
["PPA Value",null,null,{"$f":"+NPV(Discount_Rate,F69:AD69)*(1+Discount_Rate)^(0.5)","v":24280.764519508568},{"$f":"SUM(F69:AD69)","v":48350.300093999991},{"$f":"F66*F$68/1000","v":0},0,2606.4651168000005,2585.7744348000001,2565.1942164000002,2544.783942,2524.5266172000001,2504.4392364000005,2484.5048051999997,2464.7318207999997,2445.1202831999999,2425.6616951999999,2405.9566884000001,2386.4216256,2367.0395123999997,2347.8188460000001,2328.7511292000004,2309.8363619999996,2291.0745443999999,2272.4741736000001,2254.0182552000001,2235.7067891999995]
[]
["Program Surplus (Deficit) (MWh)",null,null,{"$f":"+NPV(Discount_Rate,F71:AD71)*(1+Discount_Rate)^(0.5)","v":56546.745858102251},{"$f":"SUM(F71:AD71)","v":72913.40399999998},{"$f":"F66-F32","v":0},0,29741.548800000004,17314.936800000003,4890.6024000000034,4469.7719999999972,4052.0952000000034,3637.9224000000031,3226.9032000000007,2819.2127999999939,2414.8511999999973,2013.6431999999986,1607.3543999999965,1204.5696000000025,804.93839999999909,408.6359999999986,15.487200000003213,-374.50800000000163,-761.34960000000137,-1144.8623999999982,-1525.3968000000023,-1902.9528000000064]
["Market Value of Solar Generation",null,null,{"$f":"D73/D71*1000","v":-33.275869044611348},{"$f":"E73/E71*1000","v":-32.641390492974374},{"$f":"F$89","v":30.38},{"$f":"G$89","v":28.27},29.69,32.049999999999997,33.799999999999997,37.630000000000003,40.53,41.4,42.74,44.89,47.53,49.85,67.34,69.45,71.900000000000006,74.36,75.94,77.47,79.08,80.69,82.33,84.13]
["Program Surplus (Deficit) Value",null,null,{"$f":"+NPV(Discount_Rate,F73:AD73)*(1+Discount_Rate)^(0.5)","v":-1881.6421100731295},{"$f":"SUM(F73:AD73)","v":-2379.9948921359992},{"$f":"-F71*F$72/1000","v":0},0,-883.02658387200006,-554.94372443999998,-165.30236112000011,-168.19752035999991,-164.23141845600014,-150.6099873600001,-137.91784276800004,-126.55446259199972,-114.77787753599986,-100.38011351999994,-108.23924529599978,-83.657358720000175,-57.875070959999938,-30.386172959999893,-1.1760979680002439,29.013134760000124,60.20752636800011,92.378947055999845,125.58591854400019,160.09541906400054]
["Total Cost of Goods Sold",null,null,{"$f":"+NPV(Discount_Rate,F74:AD74)*(1+Discount_Rate)^(0.5)","v":22399.122409435433},{"$f":"SUM(F74:AD74)","v":45970.305201864001},{"$f":"F69+F73","v":0},0,1723.4385329280003,2030.83071036,2399.8918552800001,2376.58642164,2360.2951987440001,2353.8292490400004,2346.5869624319998,2338.177358208,2330.3424056640001,2325.2815816799998,2297.7174431040003,2302.7642668799999,2309.1644414399998,2317.4326730400003,2327.5750312320001,2338.8494967599995,2351.2820707679998,2364.8531206560001,2379.6041737440005,2395.802208264]
[]
["Expense Increase (Decrease)",null,null,{"$f":"+NPV(Discount_Rate,F76:AD76)*(1+Discount_Rate)^(0.5)","v":27496.329455049614},{"$f":"SUM(F76:AD76)","v":54370.640035471391},{"$f":"F74+F61","v":108},1616,{"$f":"H74+H61","v":2458.4225356880002},{"$f":"I74+I61","v":2798.27843809144},2642.1266551073668,2623.4236826640863,2612.0692049885683,2610.63873540946,2608.5326385288486,2605.6238935028823,2603.1378716647805,2603.5329570007957,2581.533845931212,2591.9731813609287,2603.8683252960664,2617.7359306893318,2633.5840507766688,2650.6726876760172,2669.3417255023378,2688.9559088302904,2710.1890176817765,2732.9987490805315]
[]
[]
["Revenue less Expense",null,null,null,null,"(Thousands of Dollars)"]
[null,null,null,"NPV","Total",{"$f":"F13","v":2015},{"$f":"F80+1","v":2016},2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036]
["General Revenue less Expense",null,null,{"$f":"+NPV(Discount_Rate,F81:AD81)*(1+Discount_Rate)^(0.5)","v":6.8800154597614183E-13},{"$f":"SUM(F81:AD81)","v":2840.1667882463685},{"$f":"F50-F76","v":-108},-1616,-972.42755325377266,-569.28596444009918,329.8633097610882,348.56628220436869,359.92075987988665,361.35122945899502,363.45732633960642,366.36607136557268,368.85209320367449,368.45700786765929,390.45611893724299,380.01678350752627,368.12163957238863,354.25403417912321,338.40591409178614,321.31727719243781,302.6482393661172,283.03405603816464,261.80094718667851,238.99121578792347]
["Tax Benefit (Expense)",null,null,{"$f":"+NPV(Discount_Rate,F82:AD82)*(1+Discount_Rate)^(0.5)","v":4.3688098169485001E-13},{"$f":"SUM(F82:AD82)","v":1077.8716978073792},{"$f":"F81*$H$10","v":-40.987079999999999},{"$f":"G81*$H$10","v":-613.28816000000006},-369.0459807353393,-216.04971636466206,125.18642468743059,132.28438975937996,136.59352758201578,137.13640509198319,137.93568991914404,139.03958774394849,139.9830578917265,139.83311905585538,148.18200169787309,144.2201695089413,139.70584343411721,134.44294851131906,128.42842845697376,121.94311986730207,114.85803332183514,107.41425460704386,99.356077466816373,90.699556303674839]
[]
[]
[]
["Tracking Solar Facility On-Peak Energy Prices ($/MWH)"]
[null,"Winter",null,41.88,{"$f":"AVERAGE(F87:AA87)","v":54.708636363636373},30.61,27.58,28.24,30.84,32.299999999999997,35.07,39.14,39.69,41.47,43.23,45.38,47.35,67.34,69.45,71.900000000000006,74.36,75.94,77.47,79.08,80.69,82.33,84.13]
[null,"Summer",null,44.2,{"$f":"AVERAGE(F88:AA88)","v":56.330000000000013},30.15,28.96,31.14,33.25,35.299999999999997,40.18,41.91,43.11,44,46.55,49.68,52.34,67.34,69.45,71.900000000000006,74.36,75.94,77.47,79.08,80.69,82.33,84.13]
[null,"Average",null,{"$f":"ROUND(AVERAGE(D87:D88),2)","v":43.04},{"$f":"AVERAGE(F89:AA89)","v":55.520454545454534},{"$f":"ROUND(AVERAGE(F87:F88),2)","v":30.38},28.27,29.69,32.049999999999997,33.799999999999997,37.630000000000003,40.53,41.4,42.74,44.89,47.53,49.85,67.34,69.45,71.900000000000006,74.36,75.94,77.47,79.08,80.69,82.33,84.13]
["Embedded Power Cost",null,null,55,{"$f":"AVERAGE(F90:AA90)","v":68.702157655489046},{"$f":"$D90*F$93","v":55.99},56.829849999999993,57.852787299999996,58.951990258699986,60.013126083356582,61.15337547894034,62.376442988519152,63.623971848289536,64.896451285255324,66.259276762245676,67.584462297490589,68.936151543440403,70.314874574309215,71.650857191221093,73.012223477854278,74.399455723933499,75.81304538268823,77.253493244959301,78.798563109858478,80.295735808945778,81.901650525124708,83.539683535627191]
[]
[null,null,null,null,"Inflation Forecast",1.7999999999999999E-2,1.4999999999999999E-2,1.7999999999999999E-2,1.9E-2,1.7999999999999999E-2,1.9E-2,0.02,0.02,0.02,2.1000000000000001E-2,0.02,0.02,0.02,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,0.02,1.9E-2,0.02,0.02,0.02]
[null,null,null,null,"Cumulative Inflation",1.018,1.0332699999999999,1.0518688599999999,1.0718543683399997,1.0911477469701196,1.1118795541625517,1.1341171452458028,1.1567994881507189,1.1799354779137332,1.2047141229499214,1.2288084054089199,1.2533845735170983,1.2784522649874404,1.3027428580222016,1.3274949723246232,1.352717376798791,1.3784190069579678,1.404608968090169,1.4327011474519724,1.4599224692535597,1.4891209186386309,1.5189033370114036,1.5492814037516316]