{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Summary","EU Summary","pvwatts_monthly (2)","Global IR","PV Syst","Helioscope","EU Raw Data","Raw Tracking","Raw Monthly"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"Summary","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Point of Access Capacity Factor",null,null,null,"Point of Access Irriadiation Capacity Factor","Electricity Production Capacity Factor","Performance Ratio"]
[null,"EU Data",null,null,{"$f":"'EU Summary'!E18","v":0.22899543378995435},{"$f":"'EU Summary'!D18","v":0.17123287671232876},{"$f":"F4/E4","v":0.74775672981056818}]
[null,"PVWatts",null,null,{"$f":"'pvwatts_monthly (2)'!D33","v":0.22487234698972602},{"$f":"'pvwatts_monthly (2)'!B33","v":0.16694055060844748},{"$f":"F5/E5","v":0.74237918909644618}]
[null,"PVSYST",null,null,{"$f":"'PV Syst'!E21","v":0.23279680365296804},{"$f":"'PV Syst'!H21","v":0.18940023850857632},0.81358607823033813]
[null,"Helioscope",null,null,{"$f":"Helioscope!M8","v":0.20916666666666667},{"$f":"Helioscope!O21","v":0.16366706448042062},0.78247202142033767]
[]
["Percent Difference (High/Low)",null,null,null,{"$f":"E6/E7-1","v":0.11297276646837306},{"$f":"F6/F7-1","v":0.15722878704917531},{"$f":"G6-G5","v":7.1206889133891949E-2}]
[]
[]
["Importance of PR"]
[null,"Capcity Factor from Collector",null,null,null,null,0.23]
[null,"PR Low",null,null,null,null,{"$f":"G5","v":0.74237918909644618}]
[null,"Final Capacity Factor",null,null,null,null,{"$f":"G13*G14","v":0.17074721349218264}]
[]
[null,"PR High",null,null,null,null,{"$f":"G6","v":0.81358607823033813}]
[null,"Final Capacity Factor",null,null,null,null,{"$f":"G13*G17","v":0.18712479799297776}]
[]
[null,"Percent Difference in Capacity Factor",null,null,null,null,{"$f":"G18/G15-1","v":9.5917140700775949E-2}]
[]
[null,"DSCR Effect",null,null,null,null,{"$f":"1/(1-G20)","v":1.1060933073934436}]

{"sheet":"EU Summary","index":1,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Summary of Annual"]
[]
[null,null,"Month ","Em: Average monthly electricity production from the given system [kWh]. ","Hm: Average monthly sum of global irradiation per square meter received by the modules of the given system [kWh/m²]. ","SDm: Standard deviation of the monthly electricity production due to year-to-year variation [kWh]."]
[null,null,"January",114,150,5.8,null,"Em: Average monthly electricity production from the given system [kWh]. "]
[null,null,"February",122,161,10.8,null,"Hm: Average monthly sum of global irradiation per square meter received by the modules of the given system [kWh/m²]. "]
[null,null,"March",145,192,7.35,null,"SDm: Standard deviation of the monthly electricity production due to year-to-year variation [kWh]."]
[null,null,"April",142,192,10.1]
[null,null,"May",137,186,8.19]
[null,null,"June",117,158,4.84]
[null,null,"July",127,172,5.91]
[null,null,"August",128,173,7.98]
[null,null,"September",115,156,13.6]
[null,null,"October",124,165,9.01]
[null,null,"November",114,150,7.6]
[null,null,"December",115,151,9.1999999999999993]
[null,null,null,{"$f":"SUM(D4:D15)","v":1500},{"$f":"SUM(E4:E15)","v":2006}]
[]
[null,null,"Cap Fac",{"$f":"D16/8760","v":0.17123287671232876},{"$f":"E16/8760","v":0.22899543378995435}]
[]
[null,null,"Performance Ratio",null,{"$f":"D18/E18","v":0.74775672981056818}]
[]
[]
["Monthly energy output from tracking PV system:"]
[null,null,null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December","Total"]
[null,null,"Vertical Axis"]
[null,null,"Month Em Hm SDm"]
[null,null,"Em: kWh",null,null,null,154,164,193,191,190,154,168,168,150,158,151,153,{"$f":"SUM(G27:R27)","v":1994},{"$f":"S27/8760","v":0.2276255707762557}]
[null,null,"Hm: kWh/m2",null,null,null,202,215,254,253,254,205,224,225,200,210,198,201,{"$f":"SUM(G28:R28)","v":2641},{"$f":"S28/8760","v":0.30148401826484017}]
[null,null,null,null,null,null,9.9700000000000006,18.100000000000001,8.77,10.9,17,11.6,11.2,9.48,20.399999999999999,10.5,13.2,14.7]
[]
[null,null,"Inclined Axis"]
[null,null,"Em Hm SDm"]
[null,null,"Em: kWh",null,null,null,152,166,200,199,195,154,170,174,156,161,148,148,{"$f":"SUM(G33:R33)","v":2023},{"$f":"S33/8760","v":0.23093607305936073}]
[null,null,"Hm: kWh/m2",null,null,null,198,217,264,265,260,205,227,233,209,214,194,193,{"$f":"SUM(G34:R34)","v":2679},{"$f":"S34/8760","v":0.30582191780821916}]
[null,null,null,null,null,null,9.5399999999999991,18,9.0399999999999991,11.5,17.5,11.6,11.3,9.98,21.3,10.7,12.8,13.9]
[null,null,"Two Axis"]
[null,null,"Em Hm SDm"]
[null,null,"Em: kWh",null,null,null,160,169,201,201,203,164,179,178,156,163,154,158,{"$f":"SUM(G38:R38)","v":2086},{"$f":"S38/8760","v":0.23812785388127855}]
[null,null,"Hm: kWh/m2",null,null,null,209,222,265,268,272,219,240,239,210,216,203,207,{"$f":"SUM(G39:R39)","v":2770},{"$f":"S39/8760","v":0.31621004566210048},{"$f":"T38/T39","v":0.75306859205776167}]
[null,null,null,null,null,null,10.5,18.899999999999999,9.09,11.6,18.399999999999999,12.6,12,10.1,21.3,11,13.6,15.5]

{"sheet":"pvwatts_monthly (2)","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["PVWatts: Monthly PV Performance Data"]
["Requested Location:","cancun"]
["Location:","LA BAJADA, CUBA"]
["Lat (deg N):",21.92]
["Long (deg W):",84.47]
["Elev (m):",4]
["DC System Size (kW):",1]
["Module Type:","Standard"]
["Array Type:","Fixed (open rack)"]
["Array Tilt (deg):",21.2]
["Array Azimuth (deg):",180]
["System Losses:",14]
["Invert Efficiency:",96]
["DC to AC Size Ratio:",1.1000000000000001]
["Average Cost of Electricity Purchased from Utility ($/kWh):","No utility data available"]
["Capacity Factor (%)","16.7\t"]
[]
["Month","AC System Output(kWh)","Solar Radiation (kWh/m^2/day)","Plane of Array Irradiance (W/m^2)","DC array Output (kWh)","Value ($)"]
[1,117.03855133,5.0106411,155.32987976000001,122.20262909,0]
[2,113.76528168,5.4056191399999998,151.35733031999999,118.79142761,0]
[3,138.40896606000001,5.8793840399999997,182.26091002999999,144.42102051000001,0]
[4,133.99873352,5.9828920400000003,179.48675537,139.9087677,0]
[5,130.43092346,5.6565976100000004,175.35452271,136.22998046999999,0]
[6,120.42835999,5.4509811399999997,163.5294342,125.87508391999999,0]
[7,128.3500061,5.7387280499999997,177.90057372999999,134.13471985000001,0]
[8,126.46035766999999,5.6175870899999998,174.14520264000001,132.13124084,0]
[9,121.49864196999999,5.5273723600000002,165.82116698999999,126.97677612,0]
[10,117.060112,5.1306891400000003,159.05136107999999,122.28321074999999,0]
[11,112.3840332,4.9954667099999996,149.86399840999999,117.28963469999999,0]
[12,102.57525635,4.3800201400000001,135.78062439000001,107.19773865000001,0]
["Total",1462.39922333,64.775978559999999,1969.88175963,1527.4422302099999,0]
[]
["Cap Factor",{"$f":"B31/8760","v":0.16694055060844748},null,{"$f":"D31/8760","v":0.22487234698972602}]
[]
["Performance Ratio",{"$f":"B33/D33","v":0.74237918909644618}]

{"sheet":"Global IR","index":3,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["Month","January","February","March","April","May","June","July","August","September","October","November","December","Total","Capactiy Factor"]
["2005",177,164,200,186,179,153,177,170,157,153,153,161,{"$f":"SUM(B3:M3)","v":2030},{"$f":"N3/8760","v":0.2317351598173516}]
["2006",160,160,194,202,173,160,171,162,169,161,137,128,{"$f":"SUM(B4:M4)","v":1977},{"$f":"N4/8760","v":0.22568493150684932}]
["2007",154,148,178,190,188,160,181,163,167,163,153,152,1997,0.22796803652968037]
["2008",148,161,188,199,191,150,176,191,152,151,159,149,2015,0.2300228310502283]
["2009",158,177,189,203,199,169,185,173,162,170,146,147,2078,0.23721461187214612]
["2010",135,130,198,163,190,166,165,179,171,182,158,155,1992,0.22739726027397261]
["2011",151,155,201,203,209,148,172,166,168,143,157,162,2035,0.23230593607305935]
["2012",147,157,190,181,168,158,174,188,108,171,148,164,1954,0.2230593607305936]
["2013",144,161,176,190,194,157,167,165,145,161,138,143,1941,0.22157534246575342]
["2014",139,177,209,206,180,172,173,181,153,163,156,159,2068,0.23607305936073059]
["2015",152,163,189,191,202,159,183,176,161,159,144,141,2020,0.23059360730593606]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Standard Deviation",null,{"$f":"STDEV(N3:N13)","v":43.146473573377719},{"$f":"STDEV(O3:O13)","v":4.9253965266412934E-3}]
[null,null,null,null,null,null,"% = (DSCR-1)/DSCR",null,null,null,null,"Average",null,{"$f":"AVERAGE(N2:N13)","v":2009.7272727272727},{"$f":"AVERAGE(O2:O13)","v":0.22942092154420921}]
[null,null,null,null,null,null,"DSCR x % = DSCR - 1",null,null,null,null,"Std Dev/Avearage",null,{"$f":"N15/N16","v":2.1468820251827697E-2},{"$f":"O15/O16","v":2.1468820251827704E-2}]
[null,null,null,null,null,null,"DSCR x % - DSCR =  -1"]
[null,null,null,null,null,null,"DSCR - DSCR * % = 1",null,null,null,null,"P90",null,null,{"$f":"NORMINV(0.1,O16,O17)","v":0.20190752134008377}]
[null,null,null,null,null,null,"DSCR = 1/(1-%)",null,null,null,null,"P90/P50",null,null,{"$f":"O19/O16","v":0.88007458073598743}]
[null,null,null,null,null,null,null,null,null,null,null,"% Red",null,null,{"$f":"1-O20","v":0.11992541926401257}]
[null,null,null,null,null,null,null,null,null,null,null,"DSCR - P90",null,null,{"$f":"1/(1-O21)","v":1.1362673367565297}]

{"sheet":"PV Syst","index":4,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["GlobHor ","DiffHor","T","Amb","GlobInc","GlobEff","EArray","E_Grid","PR"]
[null,"kWh/m² ","kWh/m²","°C","kWh/m²","kWh/m²","MWh","MWh"]
["Enero",127.6,55.45,21.68,165,161.69999999999999,13208,12977,0.83399999999999996]
["Febrero",137.19999999999999,55.9,23.04,164.2,160.80000000000001,12938,12710,0.82099999999999995]
["Marzo",181.1,66.23,24.87,196.3,191.9,15180,14910,0.80500000000000005]
["Abril",195.7,71.06,25.96,187.6,182.2,14525,14271,0.80600000000000005]
["Mayo",200.8,81.180000000000007,28.22,175.2,169.5,13567,13334,0.80700000000000005]
["Junio",181.5,89.59,28.28,153.9,148.6,12053,11847,0.81599999999999995]
["Julio",206,89.12,28.92,176.3,170.1,13652,13420,0.80700000000000005]
["Agosto",191.9,80.66,28.49,177.7,172.2,13684,13450,0.80300000000000005]
["Septiembre",164.1,69.180000000000007,26.9,168.2,163.80000000000001,12993,12767,0.80500000000000005]
["Octubre",141.4,70.22,26.19,161.1,157.1,12618,12399,0.81599999999999995]
["Noviembre",123.7,46.79,23.65,158.6,155.5,12446,12224,0.81699999999999995]
["Diciembre",115.4,47.07,22.55,155.19999999999999,152.1,12398,12180,0.83199999999999996]
[]
["Año",{"$f":"SUM(B3:B14)","v":1966.4},{"$f":"SUM(C3:C14)","v":822.44999999999993},308.75000000000006,2039.3,1985.4999999999998,159262,156489,{"$f":"I21","v":0.81358607823033813}]
[]
["Capacity",null,null,null,null,null,94319,94319]
["Yield (kWh/kWp)",null,null,null,null,null,{"$f":"G16/G18*1000","v":1688.5463162247268},{"$f":"H16/H18*1000","v":1659.1460893351286}]
[]
["Hours",{"$f":"B16/8760","v":0.22447488584474887},{"$f":"C16/8760","v":9.3886986301369851E-2},{"$f":"D16/8760","v":3.5245433789954345E-2},{"$f":"E16/8760","v":0.23279680365296804},{"$f":"F16/8760","v":0.22665525114155249},{"$f":"G19/8760","v":0.19275642879277702},{"$f":"H19/8760","v":0.18940023850857632},{"$f":"H21/E21","v":0.81358607823033813}]

{"sheet":"Helioscope","index":5,"n_rows":23,"n_cols":17,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,null,"kWh/m2","Raw CF","PR","CF"]
["With Tilt",null,1832.3,{"$f":"C2/8760","v":0.20916666666666667},{"$f":"M2","v":0.78200000000000003},{"$f":"D2*M2","v":0.16356833333333334},null,null,null,null,null,"PR",0.78200000000000003,null,8760,null,{"$f":"Q11*Q21","v":0.82321249166527033}]
["Raw",null,1743.7,{"$f":"C3/8760","v":0.19905251141552513},null,null,null,null,null,null,null,"kWp",2640]
[null,null,null,null,null,null,null,null,null,null,null,"kWh/kWp",1433.7]
[null,null,null,null,null,null,null,null,null,null,null,"CF",{"$f":"M4/O2","v":0.16366438356164384}]
[]
[null,null,null,null,null,null,null,null,null,null,null,1743.7,{"$f":"L7/$O$2","v":0.19905251141552513}]
[null,null,null,null,null,null,null,null,null,null,null,1832.3,{"$f":"L8/$O$2","v":0.20916666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,1790.9,0.20444063926940639]
[null,null,null,null,null,null,null,null,null,null,null,1737.2,0.19831050228310504]
[null,null,null,null,null,null,null,null,null,null,null,1702.5,0.19434931506849315,null,null,null,{"$f":"L11/L7","v":0.97637208235361583}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"kWh","kWp","kWh/kWp","CF"]
[null,null,null,null,null,null,null,null,null,null,null,4489239,{"$f":"$M$3","v":2640},{"$f":"L14/M14","v":1700.4693181818182},{"$f":"N14/$O$2","v":0.19411750207555001}]
[null,null,null,null,null,null,null,null,null,null,null,4356246,{"$f":"$M$3","v":2640},{"$f":"L15/M15","v":1650.0931818181818},{"$f":"N15/$O$2","v":0.18836680157741803}]
[null,null,null,null,null,null,null,null,null,null,null,3999443,2640,1514.9405303030303,0.17293841670125917]
[null,null,null,null,null,null,null,null,null,null,null,3907199,2640,1479.9996212121212,0.16894972844887227]
[null,null,null,null,null,null,null,null,null,null,null,3884223,2640,1471.2965909090908,0.16795623183893732]
[null,null,null,null,null,null,null,null,null,null,null,3881727,2640,1470.3511363636364,0.16784830323785804]
[null,null,null,null,null,null,null,null,null,null,null,3804050,2640,1440.9280303030303,0.164489501176145]
[null,null,null,null,null,null,null,null,null,null,null,3785030,2640,1433.7234848484848,0.16366706448042062,null,{"$f":"L21/L14","v":0.84313399219778673}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PR",null,{"$f":"O21/M8","v":0.78247202142033767},{"$f":"O23*M8","v":0.16366706448042062}]

{"sheet":"EU Raw Data","index":6,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Latitude (decimal degrees):\t21.268"]
["Longitude (decimal degrees):\t-87.482"]
["Radiation database:\tPVGIS-NSRDB"]
["Nominal power of the PV system (crystalline silicon) (kWp):\t1"]
["System losses(%):\t14"]
["Fixed slope of modules (deg.) (optimum):\t22"]
["Orientation (azimuth) of modules (optimum):\t-17"]
[]
["\t\tFixed angle\t\t\t\t\t\t\t\t"]
["Month\t\tEd\t\tEm\t\tHd\t\tHm\t\tSDm"]
["1\t\t3.69\t\t114\t\t4.85\t\t150\t\t5.80"]
["2\t\t4.34\t\t122\t\t5.74\t\t161\t\t10.8"]
["3\t\t4.67\t\t145\t\t6.20\t\t192\t\t7.35"]
["4\t\t4.75\t\t142\t\t6.38\t\t192\t\t10.1"]
["5\t\t4.44\t\t137\t\t6.00\t\t186\t\t8.19"]
["6\t\t3.90\t\t117\t\t5.27\t\t158\t\t4.84"]
["7\t\t4.09\t\t127\t\t5.56\t\t172\t\t5.91"]
["8\t\t4.11\t\t128\t\t5.59\t\t173\t\t7.98"]
["9\t\t3.84\t\t115\t\t5.20\t\t156\t\t13.6"]
["10\t\t4.00\t\t124\t\t5.34\t\t165\t\t9.01"]
["11\t\t3.79\t\t114\t\t4.99\t\t150\t\t7.60"]
["12\t\t3.70\t\t115\t\t4.86\t\t151\t\t9.20"]
["Year\t\t4.11\t\t125\t\t5.50\t\t167\t\t2.36"]
["\tAOI loss (%)\t Spectral effects (%)\t Temperature and low irradiance loss (%)\t Combined losses (%)"]
["Fixed system:\t2.9\t ?(0)\t10.4\t25.2"]
[]
["Ed: Average daily energy production from the given system (kWh)"]
["Em: Average monthly energy production from the given system (kWh)"]
["Hd: Average daily sum of global irradiation per square meter received by the modules of the given system (kWh/m2)"]
["Hm: Average monthly sum of global irradiation per square meter received by the modules of the given system (kWh/m2)"]
["SDm: Standard deviation of the monthly energy production due to year-to-year variation  (kWh)"]
[]
[]
["PVGIS (c) European Communities"," 2001-2016"]

{"sheet":"Raw Tracking","index":7,"n_rows":127,"n_cols":1,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["Monthly energy output from tracking PV system:"]
["January"]
["February"]
["March"]
["April"]
["May"]
["June"]
["July"]
["August"]
["September"]
["October"]
["November"]
["December"]
["Vertical Axis"]
["Month Em Hm SDm"]
[154]
[164]
[193]
[191]
[190]
[154]
[168]
[168]
[150]
[158]
[151]
[153]
[202]
[215]
[254]
[253]
[254]
[205]
[224]
[225]
[200]
[210]
[198]
[201]
[9.9700000000000006]
[18.100000000000001]
[8.77]
[10.9]
[17]
[11.6]
[11.2]
[9.48]
[20.399999999999999]
[10.5]
[13.2]
[14.7]
["Inclined Axis"]
["Em Hm SDm"]
[152]
[166]
[200]
[199]
[195]
[154]
[170]
[174]
[156]
[161]
[148]
[148]
[198]
[217]
[264]
[265]
[260]
[205]
[227]
[233]
[209]
[214]
[194]
[193]
[9.5399999999999991]
[18]
[9.0399999999999991]
[11.5]
[17.5]
[11.6]
[11.3]
[9.98]
[21.3]
[10.7]
[12.8]
[13.9]
["Two Axis"]
["Em Hm SDm"]
[160]
[169]
[201]
[201]
[203]
[164]
[179]
[178]
[156]
[163]
[154]
[158]
[209]
[222]
[265]
[268]
[272]
[219]
[240]
[239]
[210]
[216]
[203]
[207]
[10.5]
[18.899999999999999]
[9.09]
[11.6]
[18.399999999999999]
[12.6]
[12]
[10.1]
[21.3]
[11]
[13.6]
[15.5]

{"sheet":"Raw Monthly","index":8,"n_rows":156,"n_cols":1,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
["Month"]
["January"]
["February"]
["March"]
["April"]
["May"]
["June"]
["July"]
["August"]
["September"]
["October"]
["November"]
["December"]
[2005]
[177]
[164]
[200]
[186]
[179]
[153]
[177]
[170]
[157]
[153]
[153]
[161]
[2006]
[160]
[160]
[194]
[202]
[173]
[160]
[171]
[162]
[169]
[161]
[137]
[128]
[2007]
[154]
[148]
[178]
[190]
[188]
[160]
[181]
[163]
[167]
[163]
[153]
[152]
[2008]
[148]
[161]
[188]
[199]
[191]
[150]
[176]
[191]
[152]
[151]
[159]
[149]
[2009]
[158]
[177]
[189]
[203]
[199]
[169]
[185]
[173]
[162]
[170]
[146]
[147]
[2010]
[135]
[130]
[198]
[163]
[190]
[166]
[165]
[179]
[171]
[182]
[158]
[155]
[2011]
[151]
[155]
[201]
[203]
[209]
[148]
[172]
[166]
[168]
[143]
[157]
[162]
[2012]
[147]
[157]
[190]
[181]
[168]
[158]
[174]
[188]
[108]
[171]
[148]
[164]
[2013]
[144]
[161]
[176]
[190]
[194]
[157]
[167]
[165]
[145]
[161]
[138]
[143]
[2014]
[139]
[177]
[209]
[206]
[180]
[172]
[173]
[181]
[153]
[163]
[156]
[159]
[2015]
[152]
[163]
[189]
[191]
[202]
[159]
[183]
[176]
[161]
[159]
[144]
[141]