{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Annual Yield"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Annual Yield","index":0,"n_rows":172,"n_cols":17,"rows_kept":172,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Uncertainties",null,null,null,null,null,"To be calculated"]
[null,"Year-to-year variability(Variance)",null,0,null,null,null,99,null,{"$f":"\"P\"&H4","v":"P99"},{"$f":"_xlfn.NORM.INV(1-H4/100,$D$16,$D$12*$D$16)","v":791000.61960480828},"MWh","Specific yield",{"$f":"K4/$D$20","v":1805.3645523562345},"MWh/MWp"]
[null,"Climate change",null,2.5000000000000001E-2,null,null,null,95,null,{"$f":"\"P\"&H5","v":"P95"},{"$f":"_xlfn.NORM.INV(1-H5/100,$D$16,$D$12*$D$16)","v":845633.6907229739},"MWh","Specific yield",{"$f":"K5/$D$20","v":1930.0580197676397},"MWh/MWp"]
[null,"PV module modelling/parameters",null,0.01,null,null,null,90,null,"P90",{"$f":"_xlfn.NORM.INV(1-H6/100,$D$16,$D$12*$D$16)","v":874758.37877865299},"MWh","Specific yield",{"$f":"K6/$D$20","v":1996.5316458444763},"MWh/MWp"]
[null,"Inverter efficiency uncertainty",null,5.0000000000000001E-3,null,null,null,75,null,"P75",{"$f":"_xlfn.NORM.INV(1-H7/100,$D$16,$D$12*$D$16)","v":923424.45552501932},"MWh","Specific yield",{"$f":"K7/$D$20","v":2107.6061604308661},"MWh/MWp"]
[null,"Soiling and mismatch uncertainties",null,0.01,null,null,null,50,null,"P50",977496,"MWh","Specific yield",{"$f":"K8/$D$20","v":2231.0180102661484},"MWh/MWp"]
[null,"Degradation uncertainty",null,0.01,null,null,null,25,null,"P25",1031567.5444749807,"MWh","Specific yield",{"$f":"K9/$D$20","v":2354.4298601014307},"MWh/MWp"]
[null,"Other",null,7.5999999999999998E-2,null,null,null,10,null,"P10",1080233.621221347,"MWh","Specific yield",{"$f":"K10/$D$20","v":2465.5043746878205},"MWh/MWp"]
[null,null,null,null,null,null,null,5,null,"P5",1109358.309277026,"MWh","Specific yield",{"$f":"K11/$D$20","v":2531.9780007646568},"MWh/MWp"]
[null,"Global variability (meteo + system)",null,{"$f":"SQRT((D4^2)+(D5^2)+(D6^2)+(D7^2)+(D8^2)+(D9^2)+(D10^2))","v":8.2012194215250703E-2},null,null,null,1,null,"P1",1163991.3803951917,"MWh","Specific yield",{"$f":"K12/$D$20","v":2656.6714681760623},"MWh/MWp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K13","v":0}]
[]
[null,"Annual Generation Y1"]
[null,"P50 ",null,977496,"MWh"]
[null,"Std Dev",null,{"$f":"D16*D12","v":80166.591796630702}]
[null,null,null,null,null,null,null,null,null,"Lower Limit",{"$f":"_xlfn.NORM.INV(1-99/100,$D$16,$D$12*$D$16)","v":791000.61960480828}]
[null,null,null,null,null,null,null,null,null,"Upper limit",{"$f":"_xlfn.NORM.INV(1-1/100,$D$16,$D$12*$D$16)","v":1163991.3803951917}]
[null,"System Size",null,438.13900000000001,"MWp",null,null,null,null,"Steps",5]
[null,"Specific Yield",null,{"$f":"D16/$D$20","v":2231.0180102661484},"MWh/MWp",null,null,null,null,"Delta",{"$f":"(K19-K18)/K20","v":74598.152158076686}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Prob"]
[null,null,null,null,null,null,null,null,1,{"$f":"K18","v":791000.61960480828},{"$f":"L25","v":9.9999999999999985E-3},{"$f":"IF(J25<>\"-\",_xlfn.NORM.DIST(J25,$D$16,$D$16*$D$12,1),\"-\")","v":9.9999999999999985E-3}]
[null,null,null,null,null,null,null,null,2,{"$f":"IF(I26<=$K$20+1,J25+$K$21,NA())","v":865598.77176288492},{"$f":"IF(I26<=$K$20+1,L26-L25)","v":7.1386051226265387E-2},8.1386051226265382E-2]
[null,null,null,null,null,null,null,null,3,{"$f":"IF(I27<=$K$20+1,J26+$K$21,NA())","v":940196.92392096156},{"$f":"IF(I27<=$K$20+1,L27-L26)","v":0.23948315881094176},0.32086921003720714]
[null,null,null,null,null,null,null,null,4,1014795.0760790382,0.35826157992558461,0.67913078996279175]
[null,null,null,null,null,null,null,null,5,1089393.2282371148,0.2394831588109424,0.91861394877373415]
[null,null,null,null,null,null,null,null,6,1163991.3803951915,7.1386051226265734E-2,0.98999999999999988]
[null,null,null,null,null,null,null,null,7,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,8,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,9,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,10,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,11,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,12,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,13,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,14,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,15,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,16,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,17,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,18,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,19,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,20,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,21,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,22,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,23,{"$error":"#N/A"},{"$f":"IF(I47<=$K$20+1,L47-L46)","v":false},{"$f":"IF(J47<>\"-\",_xlfn.NORM.DIST(J47,$D$16,$D$16*$D$12,1),\"-\")","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,24,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,25,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,26,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,27,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,28,{"$error":"#N/A"},false,{"$error":"#N/A"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K26:K52)","v":0.97999999999999987}]
[]
[]
[]
[null,null,null,{"$f":"NORMINV(0.001,$D$16,$D$17)","v":729762.60815468419},{"$f":"ROUNDDOWN(D58,-5)","v":700000},"min"]
[null,null,null,{"$f":"NORMINV(0.999,$D$16,$D$17)","v":1225229.3918453157},{"$f":"ROUNDUP(D59,-5)","v":1300000},"max",null,null,null,null,null,null,"p"]
[]
[]
[]
[]
[null,null,null,"Mean",{"$f":"D16","v":977496}]
[null,null,null,"Std Dev",{"$f":"D17","v":80166.591796630702}]
[null,null,null,{"$f":"(max-min)/99","v":6060.606060606061}]
[]
[null,null,null,null,"Probability Distribution"]
[null,null,{"$f":"E69","v":7.5457466541902502E-5},{"$f":"min","v":700000},{"$f":"_xlfn.NORM.DIST(D69,$E$64,$E$65,0)/$E$172","v":7.5457466541902502E-5}]
[null,null,{"$f":"C69+E70","v":1.7320624824907507E-4},{"$f":"D69+$D$66","v":706060.60606060608},{"$f":"_xlfn.NORM.DIST(D70,$E$64,$E$65,0)/$E$172","v":9.7748781707172557E-5},{"$f":"E70","v":9.7748781707172557E-5},"P99"]
[null,null,{"$f":"C70+E71","v":2.9910990031641787E-4},{"$f":"D70+$D$66","v":712121.21212121216},1.2590365206734282E-4]
[null,null,4.6035374445875347E-4,718181.81818181823,1.6124384414233564E-4]
[null,null,6.6568062075301354E-4,724242.42424242431,2.0532687629426012E-4]
[null,null,9.2565245473589229E-4,730303.03030303039,2.599718339828788E-4]
[null,null,1.2529363510749344E-3,736363.63636363647,3.2728389633904204E-4]
[null,null,1.6626126287227518E-3,742424.24242424255,4.0967627764781732E-4]
[null,null,2.172500683585276E-3,748484.84848484863,5.0988805486252404E-4]
[null,null,2.8034968199519119E-3,754545.4545454547,6.3099613636663596E-4]
[null,null,3.5799162645310445E-3,760606.06060606078,7.7641944457913271E-4]
[null,null,4.5298295190963483E-3,766666.66666666686,9.499132545653041E-4]
[null,null,5.6853810919957025E-3,772727.27272727294,1.1555515728993539E-3]
[null,null,7.0830765683149392E-3,778787.87878787902,1.3976954763192365E-3]
[null,null,8.7640220462383307E-3,784848.4848484851,1.6809454779233921E-3]
[null,null,1.0774098313147611E-2,790909.09090909117,2.0100762669092802E-3]
[null,null,1.3164050902076362E-2,796969.69696969725,2.3899525889287507E-3]
[null,null,1.5989476506724148E-2,803030.30303030333,2.8254256046477853E-3]
[null,null,1.9310686289453816E-2,809090.90909090941,3.3212097827296687E-3]
[null,null,2.3192427528879501E-2,815151.51515151549,3.8817412394256856E-3]
[null,null,2.7703446937744486E-2,821212.12121212156,4.5110194088649842E-3]
[null,null,3.2915881921155819E-2,827272.72727272764,5.2124349834113326E-3]
[null,null,3.8904470079644558E-2,833333.33333333372,5.9885881584887416E-3]
[null,null,4.5745572377049064E-2,839393.9393939398,6.8411022974045064E-3]
[null,null,5.3516011514141953E-2,845454.54545454588,7.7704391370928922E-3]
[null,null,6.2291734032333672E-2,851515.15151515196,8.7757225181917184E-3]
[null,null,7.2146312305913146E-2,857575.75757575803,9.8545782735794691E-3]
[null,null,8.314931058813585E-2,863636.36363636411,1.1002998282222698E-2]
[null,null,9.5364547319269369E-2,869696.96969697019,1.2215236731133517E-2]
[null,null,0.10884829360027896,875757.57575757627,1.3483746281009599E-2]
[null,null,0.12364745467167423,881818.18181818235,1.4799161071395273E-2]
[null,null,0.13979778699246284,887878.78787878843,1.61503323207886E-2]
[null,null,0.15732220768452634,893939.3939393945,1.7524420692063513E-2]
[null,null,0.17622925533033232,900000.00000000058,1.8907047645805974E-2]
[null,null,0.19651176109183746,906060.60606060666,2.0282505761505153E-2]
[null,null,0.21814578665272791,912121.21212121274,2.1634025560890453E-2]
[null,null,0.24108988048403557,918181.81818181882,2.2944093831307674E-2]
[null,null,0.2652846964310141,924242.4242424249,2.4194815946978532E-2]
[null,null,0.29065300878824091,930303.03030303097,2.5368312357226825E-2]
[null,null,0.31710014617618865,936363.63636363705,2.6447137387947767E-2]
[null,null,0.34451485308764962,942424.24242424313,2.7414706911460966E-2]
[null,null,0.37277057347620779,948484.84848484921,2.8255720388558152E-2]
[null,null,0.4017271358338767,954545.45454545529,2.8956562357668938E-2]
[null,null,0.43123280452405588,960606.06060606136,2.9505668690179183E-2]
[null,null,0.46112664838591905,966666.66666666744,2.9893843861863157E-2]
[null,null,0.49124116546879959,972727.27272727352,3.0114517082880529E-2,{"$f":"E114","v":3.0114517082880529E-2},"P50"]
[null,null,0.52140509278761893,978787.8787878796,3.0163927318819325E-2]
[null,null,0.55144632271061944,984848.48484848568,3.0041229923000474E-2]
[null,null,0.58119484336617311,990909.09090909176,2.9748520655553654E-2]
[null,null,0.61048561950101476,996969.69696969783,2.9290776134841635E-2]
[null,null,0.63916133258656094,1003030.3030303039,2.8675713085546197E-2]
[null,null,0.6670749045325608,1009090.90909091,2.791357194599986E-2]
[null,null,0.6940917378460697,1015151.5151515161,2.7016833313508876E-2]
[null,null,0.72009161604234184,1021212.1212121221,2.5999878196272152E-2]
[null,null,0.74497022102835475,1027272.7272727282,2.4878604986012919E-2]
[null,null,0.76864023840985995,1033333.3333333343,2.3670017381505159E-2]
[null,null,0.79103203654195398,1039393.9393939404,2.2391798132094035E-2]
[null,null,0.81209391996555524,1045454.5454545465,2.1061883423601289E-2]
[null,null,0.83179197199213672,1051515.1515151525,1.9698052026581495E-2]
[null,null,0.85010951402581647,1057575.7575757585,1.8317542033679794E-2]
[null,null,0.86704622024905398,1063636.3636363645,1.6936706223237456E-2]
[null,null,0.88261693516601059,1069696.9696969704,1.5570714916956628E-2]
[null,null,0.89685024794698198,1075757.5757575764,1.4233312780971449E-2]
[null,null,0.90978688143488973,1081818.1818181823,1.2936633487907735E-2]
[null,null,0.92147795507986863,1087878.7878787883,1.1691073644978926E-2]
[null,null,0.93198318010127468,1093939.3939393943,{"$f":"_xlfn.NORM.DIST(D134,$E$64,$E$65,0)/$E$172","v":1.0505225021406051E-2}]
[null,null,{"$f":"C134+E135","v":0.94136904208288019},{"$f":"D134+$D$66","v":1100000.0000000002},9.3858619816055006E-3]
[null,null,0.94970702131352158,1106060.6060606062,8.3379792306414232E-3]
[null,null,0.95707189487581013,1112121.2121212122,7.3648735622885422E-3]
[null,null,0.96354015717429375,1118181.8181818181,6.4682622984836178E-3]
[null,null,0.96918858770167582,1124242.4242424241,5.6484305273820359E-3]
[null,null,0.97409298676972234,1130303.03030303,4.9043990680464862E-3]
[null,null,0.97832709204554569,1136363.636363636,4.2341052758233643E-3]
[null,null,0.98196168134697781,1142424.242424242,3.6345893014320804E-3]
[null,null,0.98506386051312667,1148484.8484848479,3.1021791661488694E-3]
[null,null,0.98769652946042152,1154545.4545454539,2.6326689472948822E-3]
[null,null,0.98991801487431874,1160606.0606060599,2.2214854138972095E-3]
[null,null,0.99178185442090616,1166666.6666666658,1.8638395465873949E-3]
[null,null,0.99333671488080355,1172727.2727272718,1.5548604598973996E-3]
[null,null,0.99462642515035504,1178787.8787878777,1.2897102695514986E-3]
[null,null,0.99569010452351425,1184848.4848484837,1.0636793731592284E-3]
[null,null,0.99656236693562483,1190909.0909090897,8.7226241211053879E-4]
[null,null,0.99727358277432177,1196969.6969696956,7.1121583869698606E-4]
[null,null,0.99785018129327052,1203030.3030303016,5.7659851894880352E-4]
[null,null,0.99831497845392514,1209090.9090909075,4.6479716065463112E-4]
[null,null,0.99868751703090952,1215151.5151515135,3.7253857698441056E-4]
[null,null,0.99898440792483367,1221212.1212121195,2.968908939241372E-4]
[null,null,0.99921966372762072,1227272.7272727254,2.3525580278702175E-4]
[null,null,0.99940501759531775,1233333.3333333314,1.8535386769703575E-4]
[null,null,0.99955022233815205,1239393.9393939374,1.4520474283432144E-4]
[null,null,0.99966332629337473,1245454.5454545433,1.1310395522266089E-4]
[null,null,0.99975092397734999,1251515.1515151493,8.7597683975305547E-5]
[null,null,0.99981838070917006,1257575.7575757552,6.7456731820028729E-5]
[null,null,0.99987003136140595,1263636.3636363612,5.1650652235845013E-5]
[null,null,0.99990935413699666,1269696.9696969672,3.9322775590706331E-5]
[null,null,0.99993912081439018,1275757.5757575731,2.9766677393501181E-5]
[null,null,0.99996152527009485,1281818.1818181791,2.2404455704702917E-5]
[null,null,0.99997829230527702,1287878.787878785,1.6767035182178579E-5]
[null,null,0.99999076889789096,1293939.393939391,1.2476592613900757E-5]
[null,null,1.0000000000000002,1299999.999999997,9.2311021092114909E-6]
[]
[]
[null,null,null,null,{"$f":"SUM(E69:E170)","v":1.0000000000000002}]
[null,null,null,null,1.6495761491026908E-4]