{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["S-Curve Scenario","Dropdown Box Selections"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":42,"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":"S-Curve Scenario","index":0,"n_rows":48,"n_cols":13,"rows_kept":48,"cut":false,"hidden":false,"merged":[[32,0,33,0],[35,2,35,13],[37,2,37,13],[38,2,38,13],[31,2,31,13],[36,2,36,13],[32,2,33,13],[34,2,34,13]]}
["Distributed PV Adoption Characteristics"]
[]
["Base Year",2018]
["Market Saturation %",0.2]
["Start of Fast Growth",2019]
["Takeover Time (Years)",4]
["Smoothing Parameter",35]
["Baseline MW Calibration Factor",1.2733721137536357E-2,"Set value so that cell B42 is equal to 500."]
[]
["Year",2018,2019,{"$f":"C10+1","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Market Penetration",{"$f":"(saturation/(1+smoothing^((fastgrowth+takeover/2-year)/takeover))+baseline_adoption_factor)","v":2.5729445824189439E-2},4.1651837508710571E-2,7.1003698122926728E-2,0.11273372113753637,0.15446374415214598,0.18381560476636216,0.19973799645088328,0.20717816558198082,0.21041166264966968,0.21177247286395101,0.21233739797078796,0.21257058900050535]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Distributed PV Penetration Forecast, Summer and Winter"]
[null,null,"Comments"]
["Total Potential, MW",{"$f":"18433+1000","v":19433},"Total potential, 18,433 MW, is based on Table 4.3 of the AWS Truepower report, \"Solar Site Screening and Hourly Generation Profiles,\" prepared for ERCOT.\n             Link: http://www.ercot.com/content/wcm/lists/114800/ERCOT_Solar_SiteScreenHrlyProfiles_Jan2017.pdf\nAn additional 2 GW of capacity potential was added to represent development outside of the four metropolitan areas represented in the distributed PV screening study (DFW, Houston, San Antonio, Austin)"]
[]
["On-peak Capacity Contribution, Summer",0.36,"Default of 36% is based on AWS Truepower Distributed PV hourly generation profiles."]
["On-peak Capacity Contribution, Winter",8.3000000000000004E-2,"Default of 8% is based on AWS Truepower Distributed PV hourly generation profiles."]
["Embedded Load Forecast Amount (%)",0.8,"Initial value is a best guess. "]
["Forecast Start Month, Summer",5,"Set to the month prior to the Start-Month of the Summer Peak Load Season (example: setting to \"5\" captures May DG growth)"]
["Forecast Start Month, Winter",11,"Set to the month prior to the Start-Month of the Winter Peak Load Season"]
[]
[null,2018,2019,{"$f":"C41+1","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Installed Capacity, End-Year",{"$f":"B$11*$B$33","v":500.00032070147336},{"$f":"C$11*$B$33","v":809.42015830677258},1379.8148656228352,2190.7544028657444,3001.6939401086529,3572.0886474247159,3881.5084850300145,4026.0932917546334,4088.929840271031,4115.3744651651596,4126.3526547663223,4130.8842560468202]
["Installed Capacity, Summer Forecast Start Month",{"$f":"B$11*$B$33","v":500.00032070147336},{"$f":"B42+(C42-B42)*($B$38/12)","v":628.92525303701473},{"$f":"C42+(D42-C42)*($B$38/12)","v":1047.0846196884654},1717.7063394740474,2528.6458767169561,3239.3584014903458,3701.013579760257,3941.7521544986057,4052.2751869697991,4099.9484339769178,4119.948710832311,4128.2408219665294]
["Installed Capacity, Winter Forecast Start Month",{"$f":"B$11*$B$33","v":500.00032070147336},{"$f":"B43+(C43-B43)*($B$39/12)","v":618.18150867571967},{"$f":"C43+(D43-C43)*($B$39/12)","v":1012.2380058008446},1661.8211961585821,2461.0675819467137,3180.1323577592302,3662.5423149044309,3921.6906066037432,4043.0649342638662,4095.9756633929915,4118.2820210943619,4127.5498127053443]
["On-Peak Ave. Capacity, Summer",{"$f":"B$43*$B35","v":180.00011545253039},{"$f":"C$43*$B35","v":226.41309109332531},376.95046308784754,618.37428221065704,910.31251561810416,1166.1690245365244,1332.3648887136924,1419.0307756194979,1458.8190673091276,1475.9814362316904,1483.1815358996319,1486.1666959079505]
["On-Peak Ave. Capacity, Winter",{"$f":"B$44*$B36","v":41.500026618222293},{"$f":"C$44*$B36","v":51.309065220084733},84.015754481470111,137.93115928116231,204.26860930157724,263.95098569401614,303.9910121370678,325.50032034811068,335.57438954390091,339.96598006161832,341.81740775083205,342.58663445454357]
["Incremental DG Excluded from Load Forecast, Summer",{"$f":"B45*(1-$B$37)","v":36.000023090506069},{"$f":"C45*(1-$B$37)","v":45.28261821866505},75.390092617569493,123.67485644213139,182.06250312362079,233.23380490730483,266.47297774273841,283.80615512389954,291.76381346182546,295.19628724633799,296.63630717992629,297.23333918159005]
["Incremental DG Excluded from Load Forecast, Winter",{"$f":"B46*(1-$B$37)","v":8.3000053236444575},10.261813044016945,16.803150896294017,27.586231856232455,40.853721860315439,52.790197138803215,60.798202427413543,65.100064069622121,67.114877908780173,67.993196012323651,68.363481550166398,68.517326890908706]

{"sheet":"Dropdown Box Selections","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["AnnAdd","CapContrSummer","CapContrWinter","Month"]
[0.1,0.2,0.05,1]
[0.2,0.3,0.06,2]
[0.3,0.36,7.0000000000000007E-2,3]
[0.4,0.4,8.3000000000000004E-2,4]
[0.5,0.5,0.09,5]
[0.6,null,0.1,6]
[0.7,null,0.11,7]
[0.8,null,null,8]
[0.9,null,null,9]
[1,null,null,10]
[null,null,null,11]
[null,null,null,12]