{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","P50 and P90 Report","P50 and P90 Std Dev","Sheet3","Sheet3 (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Project and Portfolio Energy Production Forecasts"]
["Site"]
["LB II"]
["CGordo"]
["SW Mesa"]
["Hancock"]
["HWinds"]
["New Mex"]
["Montfort"]
["Total project"]
["Portfolio forecast"]
["Rated power"]
[103.5]
[41.3]
[74.900000000000006]
[97.7]
[145.80000000000001]
[204]
[30]
[697]
["Net energy (GWh/year)"]
[333]
[104.5]
[231.8]
[288.5]
[476.5]
[536.6]
[57.6]
[2029]
["Net capacity factor (%)"]
[36.700000000000003]
[28.9]
[35.299999999999997]
[33.700000000000003]
[37.299999999999997]
[30]
[21.9]
[33]

{"sheet":"P50 and P90 Report","index":1,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Project and Portfolio Energy Production Forecasts"]
[]
[null,"Site",null,"LB II","CGordo","SW Mesa","Hancock","HWinds","New Mex","Montfort","Total project","Portfolio forecast"]
[null,null,"Rated power (MW)",103.5,41.3,74.900000000000006,97.7,145.80000000000001,204,30,697]
[null,null,"Net energy (GWh/year)",333,104.5,231.8,288.5,476.5,536.6,57.6,2029]
[null,null,"Net capacity factor (%)",0.36700000000000005,0.28899999999999998,0.35299999999999998,0.33700000000000002,0.373,0.3,0.219,0.33]
[null,"One Year Average"]
[null,null,"P95",269.89999999999998,81.900000000000006,189,215.2,367.1,394.6,32.299999999999997,1550,1756]
[null,null,"P90",283.8,86.9,198.4,231.4,391.2,425.9,43.8,1661,1816]
[null,null,"P75",307.10000000000002,95.2,214.2,258.39999999999998,431.6,478.3,52.9,1838,1917]
[null,null,"P50",333,104.5,231.8,288.5,476.5,536.6,57.6,2029,2029]
[null,"Variation (%)"]
[null,null,"P95/P50",0.81,0.78,0.82000000000000006,0.75,0.77,0.74,0.56000000000000005]
[null,null,"P90/P50",0.85,0.83000000000000007,0.86,0.8,0.82000000000000006,0.79,0.76]
[null,null,"P75/P50",0.92,0.91,0.92,0.9,0.91,0.89,0.92]
[null,"10-Year Average"]
[null,null,"P95",300.3,93.6,208.8,238.4,402.8,428.8,41.5,1714,1828]
[null,null,"P90",307.5,96,213.9,249.5,419.1,452.6,48.9,1787,1872]
[null,null,"P75",319.60000000000002,100,222.3,268,446.3,492.4,54.6,1903,1946]
[null,null,"P50",333,104.5,231.8,288.5,476.5,536.6,57.6,2029,2029]
[null,"Ratio of 1-year to 10-year (%)"]
[null,null,"P95",0.9,0.88,0.91,0.9,0.91,0.92,0.78]
[null,null,"P90",0.92,0.91,0.93,0.93,0.93,0.94000000000000006,0.9]
[null,null,"P75",0.96,0.95000000000000007,0.96,0.96,0.97,0.97,0.97]
[null,null,"P50",1,1,1,1,1,1,1]
[null,null,"Note: P factors represent probability of exceedance: P95 = mean plus 1.64 * standard deviation."]
[null,null,"Monthly variation"]

{"sheet":"P50 and P90 Std Dev","index":2,"n_rows":49,"n_cols":12,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[null,"Project and Portfolio Energy Production Forecasts"]
[]
[null,"Site",null,"LB II","CGordo","SW Mesa","Hancock","HWinds","New Mex","Montfort","Total project","Portfolio forecast"]
[null,null,"Rated power (MW)",103.5,41.3,74.900000000000006,97.7,145.80000000000001,204,30,697]
[null,null,"Net energy (GWh/year)",333,104.5,231.8,288.5,476.5,536.6,57.6,2029]
[null,null,"Net capacity factor (%)",0.36700000000000005,0.28899999999999998,0.35299999999999998,0.33700000000000002,0.373,0.3,0.219,0.33]
[null,"One Year Average"]
[null,null,"P95",269.89999999999998,81.900000000000006,189,215.2,367.1,394.6,32.299999999999997,1550,1756]
[null,null,"P90",283.8,86.9,198.4,231.4,391.2,425.9,43.8,1661,1816]
[null,null,"P75",307.10000000000002,95.2,214.2,258.39999999999998,431.6,478.3,52.9,1838,1917]
[null,null,"P50",333,104.5,231.8,288.5,476.5,536.6,57.6,2029,2029]
[null,"Implied Standard Deviation"]
[null,null,0.05,38.362076093632623,13.73982440120597,26.020552405823711,44.563235779132675,66.510477411147576,86.329870131471182,15.381307847367756]
[null,null,0.1,38.390963986761093,13.73335297087386,26.062158478817455,44.555366740732836,66.559943659973982,86.379668970212364,10.768197215798811]
[null,null,0.25,38.399397459295052,13.788200632102091,26.093799045698599,44.626326777018654,66.568839610901534,86.435709338876549,6.9682304269763238]
[null,"Computed Production"]
[null,null,0.05,{"$f":"_xlfn.NORM.INV($C17,D$11,D13)","v":269.89999999999998},{"$f":"_xlfn.NORM.INV($C17,E$11,E13)","v":81.900000000000006},{"$f":"_xlfn.NORM.INV($C17,F$11,F13)","v":189},{"$f":"_xlfn.NORM.INV($C17,G$11,G13)","v":215.2},{"$f":"_xlfn.NORM.INV($C17,H$11,H13)","v":367.09999999999991},{"$f":"_xlfn.NORM.INV($C17,I$11,I13)","v":394.6},{"$f":"_xlfn.NORM.INV($C17,J$11,J13)","v":32.299999999999997},null,{"$f":"_xlfn.FORMULATEXT(J17)","v":"=NORM.INV($C17,J$11,J13)"}]
[null,null,0.1,{"$f":"_xlfn.NORM.INV($C18,D$11,D14)","v":283.79999999999995},{"$f":"_xlfn.NORM.INV($C18,E$11,E14)","v":86.9},{"$f":"_xlfn.NORM.INV($C18,F$11,F14)","v":198.4},{"$f":"_xlfn.NORM.INV($C18,G$11,G14)","v":231.4},{"$f":"_xlfn.NORM.INV($C18,H$11,H14)","v":391.19999999999993},{"$f":"_xlfn.NORM.INV($C18,I$11,I14)","v":425.9},{"$f":"_xlfn.NORM.INV($C18,J$11,J14)","v":43.800000000000026},null,{"$f":"_xlfn.FORMULATEXT(J18)","v":"=NORM.INV($C18,J$11,J14)"}]
[null,null,0.25,{"$f":"_xlfn.NORM.INV($C19,D$11,D15)","v":307.10000000000002},{"$f":"_xlfn.NORM.INV($C19,E$11,E15)","v":95.2},{"$f":"_xlfn.NORM.INV($C19,F$11,F15)","v":214.2},{"$f":"_xlfn.NORM.INV($C19,G$11,G15)","v":258.39999999999998},{"$f":"_xlfn.NORM.INV($C19,H$11,H15)","v":431.59999999999997},{"$f":"_xlfn.NORM.INV($C19,I$11,I15)","v":478.3},{"$f":"_xlfn.NORM.INV($C19,J$11,J15)","v":52.900000000000006},null,"=NORM.INV($C19,J$11,J15)"]
[null,null,0.5,{"$f":"_xlfn.NORM.INV($C20,D$11,1)","v":333},{"$f":"_xlfn.NORM.INV($C20,E$11,1)","v":104.5},231.8,288.5,476.5,536.6,57.6,null,"=NORM.INV($C20,J$11,1)"]
[null,"Goal Seek Difference"]
[null,null,"P95",{"$f":"D17-D8","v":0},{"$f":"E17-E8","v":0},{"$f":"F17-F8","v":0},{"$f":"G17-G8","v":0},{"$f":"H17-H8","v":0},{"$f":"I17-I8","v":0},{"$f":"J17-J8","v":0}]
[null,null,"P90",{"$f":"D18-D9","v":0},{"$f":"E18-E9","v":0},{"$f":"F18-F9","v":0},{"$f":"G18-G9","v":0},{"$f":"H18-H9","v":0},{"$f":"I18-I9","v":0},{"$f":"J18-J9","v":0}]
[null,null,"P75",{"$f":"D19-D10","v":0},{"$f":"E19-E10","v":0},{"$f":"F19-F10","v":0},{"$f":"G19-G10","v":0},{"$f":"H19-H10","v":0},{"$f":"I19-I10","v":0},{"$f":"J19-J10","v":0}]
[null,null,"P50",{"$f":"D20-D11","v":0},{"$f":"E20-E11","v":0},{"$f":"F20-F11","v":0},{"$f":"G20-G11","v":0},{"$f":"H20-H11","v":0},{"$f":"I20-I11","v":0},{"$f":"J20-J11","v":0}]
[null,"P99 Analysis"]
[null,null,0.01,{"$f":"_xlfn.NORM.INV($C27,D20,D13)","v":243.75646583578478},{"$f":"_xlfn.NORM.INV($C27,E20,E13)","v":72.536388714560019},{"$f":"_xlfn.NORM.INV($C27,F20,F13)","v":171.26714322934373},{"$f":"_xlfn.NORM.INV($C27,G20,G13)","v":184.83041118483396},{"$f":"_xlfn.NORM.INV($C27,H20,H13)","v":321.7734922731355},{"$f":"_xlfn.NORM.INV($C27,I20,I13)","v":335.76669015343015},{"$f":"_xlfn.NORM.INV($C27,J20,J13)","v":21.817727189308322},null,{"$f":"_xlfn.FORMULATEXT(J27)","v":"=NORM.INV($C27,J20,J13)"}]
[null,null,"P50",{"$f":"D20","v":333},{"$f":"E20","v":104.5},231.8,288.5,476.5,536.6,57.6,null,"=J20"]
[null,null,"P99 vs P50",{"$f":"D20-D27","v":89.24353416421522},{"$f":"E20-E27","v":31.963611285439981},{"$f":"F20-F27","v":60.532856770656281},{"$f":"G20-G27","v":103.66958881516604},{"$f":"H20-H27","v":154.7265077268645},{"$f":"I20-I27","v":200.83330984656988},{"$f":"J20-J27","v":35.78227281069168},null,"=J20-J27"]
[null,null,"P99/P50",{"$f":"D29/D28","v":0.26799860109373941},{"$f":"E29/E28","v":0.30587187832956919},0.26114260901922465,0.35933999589312315,0.32471460173528749,0.37427005189446488,0.62122001407450833,null,"=J29/J28"]
[]
[]
[]
[null,"Variation (%)"]
[null,null,"P95/P50",0.81,0.78,0.82000000000000006,0.75,0.77,0.74,0.56000000000000005]
[null,null,"P90/P50",0.85,0.83000000000000007,0.86,0.8,0.82000000000000006,0.79,0.76]
[null,null,"P75/P50",0.92,0.91,0.92,0.9,0.91,0.89,0.92]
[null,"10-Year Average"]
[null,null,"P95",300.3,93.6,208.8,238.4,402.8,428.8,41.5,1714,1828]
[null,null,"P90",307.5,96,213.9,249.5,419.1,452.6,48.9,1787,1872]
[null,null,"P75",319.60000000000002,100,222.3,268,446.3,492.4,54.6,1903,1946]
[null,null,"P50",333,104.5,231.8,288.5,476.5,536.6,57.6,2029,2029]
[null,"Ratio of 1-year to 10-year (%)"]
[null,null,"P95",0.9,0.88,0.91,0.9,0.91,0.92,0.78]
[null,null,"P90",0.92,0.91,0.93,0.93,0.93,0.94000000000000006,0.9]
[null,null,"P75",0.96,0.95000000000000007,0.96,0.96,0.97,0.97,0.97]
[null,null,"P50",1,1,1,1,1,1,1]
[null,null,"Note: P factors represent probability of exceedance: P95 = mean plus 1.64 * standard deviation."]
[null,null,"Monthly variation"]

{"sheet":"Sheet3","index":3,"n_rows":141,"n_cols":1,"rows_kept":141,"cut":false,"hidden":false,"merged":[]}
["P95"]
[269.89999999999998]
[81.900000000000006]
[189]
[215.2]
[367.1]
[394.6]
[32.299999999999997]
[1550]
[1756]
["P90"]
[283.8]
[86.9]
[198.4]
[231.4]
[391.2]
[425.9]
[43.8]
[1661]
[1816]
["P75"]
[307.10000000000002]
[95.2]
[214.2]
[258.39999999999998]
[431.6]
[478.3]
[52.9]
[1838]
[1917]
["P50"]
[333]
[104.5]
[231.8]
[288.5]
[476.5]
[536.6]
[57.6]
[2029]
[2029]
["Variation (%)"]
["P95/P50"]
[81]
[78]
[82]
[75]
[77]
[74]
[56]
["P90/P50"]
[85]
[83]
[86]
[80]
[82]
[79]
[76]
["P75/P50"]
[92]
[91]
[92]
[90]
[91]
[89]
[92]
["10-Year Average"]
["P95"]
[300.3]
[93.6]
[208.8]
[238.4]
[402.8]
[428.8]
[41.5]
[1714]
[1828]
["P90"]
[307.5]
[96]
[213.9]
[249.5]
[419.1]
[452.6]
[48.9]
[1787]
[1872]
["P75"]
[319.60000000000002]
[100]
[222.3]
[268]
[446.3]
[492.4]
[54.6]
[1903]
[1946]
["P50"]
[333]
[104.5]
[231.8]
[288.5]
[476.5]
[536.6]
[57.6]
[2029]
[2029]
["Ratio of 1-year to 10-year (%)"]
["P95"]
[90]
[88]
[91]
[90]
[91]
[92]
[78]
["P90"]
[92]
[91]
[93]
[93]
[93]
[94]
[90]
["P75"]
[96]
[95]
[96]
[96]
[97]
[97]
[97]
["P50"]
[100]
[100]
[100]
[100]
[100]
[100]
[100]
["Note: P factors represent probability of exceedance: P95 = mean plus 1.64 * standard deviation."]
["Monthly variation"]

{"sheet":"Sheet3 (2)","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}