{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Photovoltaic module","Calculations","from author"],"not_rendered":{"images":4,"macros":1,"defined_names":68,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Photovoltaic module","index":0,"n_rows":60,"n_cols":36,"rows_kept":60,"merged":[[0,1,0,17],[0,18,0,27],[1,4,3,15],[1,16,2,21],[2,22,2,23],[2,24,2,27],[3,16,3,18],[3,19,3,21],[3,22,3,23],[3,24,3,27],[4,2,4,3],[4,4,4,15],[4,16,4,18],[4,19,4,21],[4,22,4,23],[4,24,4,27],[6,2,6,14],[6,16,6,26],[7,2,7,14],[7,16,7,22],[7,23,7,26],[9,2,9,14],[9,16,9,26],[9,34,9,35],[10,2,10,12],[10,13,10,14],[11,2,11,12],[11,13,11,14],[12,2,12,12],[12,13,12,14],[13,2,13,12],[13,13,13,14],[14,2,14,10],[14,11,14,12],[14,13,14,14],[15,2,15,12],[15,13,15,14],[16,2,16,12],[16,13,16,14],[17,2,17,12],[17,13,17,14],[18,2,18,12],[18,13,18,14],[19,2,19,12],[19,13,19,14],[20,2,20,12],[20,13,20,14],[21,2,21,12],[21,13,21,14],[23,2,23,14],[23,16,23,26],[24,2,24,12],[24,13,24,14],[25,2,25,12],[25,13,25,14],[26,2,26,12],[26,13,26,14],[27,2,27,12],[27,13,27,14],[28,2,28,12],[28,13,28,14],[30,2,30,14],[31,2,31,4],[31,5,31,7],[31,8,31,11],[31,12,31,14],[32,2,32,4],[32,5,32,7],[32,8,32,11],[32,12,32,14],[33,2,33,4],[33,5,33,7],[33,8,33,11],[33,12,33,14],[34,2,34,4],[34,5,34,7],[34,8,34,11],[34,12,34,14],[35,2,35,4],[35,5,35,7],[35,8,35,11],[35,12,35,14],[36,2,36,6],[36,7,36,14],[37,2,39,14],[40,2,40,14],[40,16,40,26],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,12],[41,13,41,14],[41,16,41,24],[41,25,41,26],[41,29,41,30],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,12],[42,13,42,14],[42,16,42,24],[42,25,42,26],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,12],[43,13,43,14],[43,16,43,24],[43,25,43,26],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,12],[44,13,44,14],[44,16,44,24],[44,25,44,26],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,12],[45,13,45,14],[45,16,45,24],[45,25,45,26],[47,2,47,14],[47,16,47,26],[48,2,48,12],[48,13,48,14],[48,16,48,24],[48,25,48,26],[49,2,49,12],[49,13,49,14],[49,16,49,24],[49,25,49,26],[50,2,50,12],[50,13,50,14],[50,16,50,24],[50,25,50,26],[51,2,51,12],[51,13,51,14],[51,16,51,24],[51,25,51,26],[52,2,52,12],[52,13,52,14],[52,16,52,24],[52,25,52,26],[53,2,53,12],[53,13,53,14],[53,16,53,24],[53,25,53,26],[54,2,54,12],[54,13,54,14],[54,16,54,24],[54,25,54,26],[55,2,55,12],[55,13,55,14],[55,16,55,24],[55,25,55,26],[56,2,56,12],[56,13,56,14],[56,16,57,26],[57,2,57,12],[57,13,57,14]]}
[null,"version: 1.1. - FREE LITE VERSION",{"$nulls":16},"© 2014-2019 Damian Janicki"]
[{"$nulls":4},"  YourSpreadsheets™\n   2nd Floor, 52 Marcus Hill, London\n   www.YourSpreadsheets.co.uk\n   Tel: 020 7542 8734",{"$nulls":11},"TEST PROJECT",{"$nulls":15},"roof type:"]
[{"$nulls":22},"Revision",null,"B",{"$nulls":4},"Roof slope, θ [deg] =",{"$f":"IF(C8=AG3,20,0)","v":0},null,"PV panels mounted on or above pitched roof"]
[{"$nulls":16},"Job No:",null,null,22668,null,null,"Page:",null,"C/01",{"$nulls":4},"PV Type =",{"$f":"IF(C8=AG4,Calculations!O11,Calculations!O10)","v":"Fixed"},null,"PV panels mounted on flat roof - free standing (ballasted)"]
[null,null,"Section: ",null,"FIRST FLOOR SLAB - SHEAR CHECKS",{"$nulls":11},"Prepared By:",null,null,"DJ",null,null,"Date:",null,{"$f":"TODAY()","v":"2019-11-17"},{"$nulls":4},"Percent tributary area =",{"$f":"IF(PVType=\"Fixed\", 0.25,\nIF(PVType=\"Ballasted\", 1,\n\"PV TYPE INVALID\"))","v":0.25},null,"PV panels mounted on flat roof - mechanically fixed"]
[{"$nulls":29},"Angle of plane of panel to roof, ω [degrees] =",{"$f":"IF(NOT(C8=AG3),20,0)","v":20},null,{"$f":"MATCH(C8,AG3:AG5,0)+1","v":4}]
[null,null,"PHOTOVOLTAIC (PV) PANEL TYPE",{"$nulls":13},"SUMMARY",{"$nulls":12},"Nominal net pressure coefficient, (GC_rn)_nom =","not used anymore"]
[null,null,"PV panels mounted on flat roof - mechanically fixed",{"$nulls":13},{"$f":"IF(C8=AG4,\"Required ballast per PV panel [lbs] =\",\"Force per fixing per PV panel [lbs] =\")","v":"Force per fixing per PV panel [lbs] ="},{"$nulls":6},{"$f":"IF(C8=AG4,FIXED(Z53,1),FIXED(Z54,1)&\" / \"&FIXED(Z55,1))","v":"83.0 / -52.1"},{"$nulls":5},"Edge factor, E =","not used anymore"]
[{"$nulls":29},"Design in-to-roof wind pressure, p [psf] =",{"$f":"q_h*GC_rn_d","v":26.88838367239993}]
[null,null,"BUILDING AND WIND DATA",{"$nulls":13},"DIAGRAM: SECTION",{"$nulls":12},"Design wind pressure, p [psf] =",{"$f":"ABS(q_h * GC_rn)","v":26.88838367239993},"per panel:",null,null,"BASIC GEOMETRY CHECKS"]
[null,null,"Mean roof height above ground 'h' [ft] =",{"$nulls":10},{"v":60,"d":"60.0"},{"$nulls":15},"In-to-roof force on PV panel, F [lbs] =",{"$f":"p_dwn * A_t","v":71.00213813493106},{"$f":"F_d*4","v":284.00855253972423},null,null,{"$f":"Z49","v":"OK"},"h < 60ft"]
[null,null,"Parapet height 'hpt' [ft] =",{"$nulls":10},{"v":1,"d":"1.0"},{"$nulls":15},"Uplift force on PV panel, F [lbs] =",{"$f":"p * A_t","v":71.00213813493106},{"$f":"F*4","v":284.00855253972423},null,null,{"$f":"Z50","v":"NOT OK"},"h < min(L,B)"]
[null,null,"Building length 'L' [ft] =",{"$nulls":10},{"v":12,"d":"12.0"},{"$nulls":15},"Horizontal uplift force on panel, F_horiz [lbs] =",{"$f":"F *SIN(ω*PI()/180)","v":24.284161461338048},{"$f":"F_horiz*4","v":97.13664584535219},null,null,{"$f":"IF(OR(AND(MATCH(C8,AG3:AG5,0)=1,N15<=45),N15<=35),\"OK\",\"NOT OK\")","v":"OK"},{"$f":"IF(MATCH(C8,AG3:AG5,0)=1,\"θ < 45deg\",\"ω < 35deg\")","v":"ω < 35deg"}]
[null,null,"Building width 'B' [ft] =",{"$nulls":10},{"v":11,"d":"11.0"},{"$nulls":15},"Vertical uplift force on panel, F_vert [lbs] =",{"$f":"F * COS(ω*PI()/180)","v":66.72018526541646},{"$f":"F_vert*4","v":266.88074106166584},"without s/w",null,{"$f":"IF(l_p<=6+8/12,\"OK\",\"NOT OK\")","v":"OK"},"lp < 6'-8\""]
[null,null,{"$f":"IF(MATCH(C8,AG3:AG5,0)=1,\"Roof angle from horizontal 'θ'\",\"Angle of plane of panel to roof 'ω'\")","v":"Angle of plane of panel to roof 'ω'"},{"$nulls":8},"[deg] =",null,{"v":20,"d":"20.0"},{"$nulls":15},"Required ballast weight for uplift, W_blst_up [lbs] =",{"$f":"IF(PVType=\"Ballasted\", (F_vert - 0.9*P_D*A)/0.9, 0)","v":0},null,{"$f":"F_vert/0.9","v":74.13353918379606},null,{"$f":"IF(C8=AG3,\"N/A\",IF(h_1<=2,\"OK\",\"NOT OK\"))","v":"OK"},"h1 < 2'-0\""]
[null,null,"Wind velocity 'V' [mph] =",{"$nulls":10},75,{"$nulls":15},"Required ballast weight for sliding, W_blst_sld [lbs] =",{"$f":"IF(PVType=\"Ballasted\", (F_horiz/μ + F_vert - 0.9*P_D*A)/0.9, 0)","v":0},null,{"$f":"(F_horiz/μ + F_vert)/0.9","v":141.58954324306842}]
[null,null,"Topographic factor 'Kzt' =",{"$nulls":10},{"v":1,"d":"1.00"}]
[null,null,"Wind exposure category =",{"$nulls":10},"C",{"$nulls":17},"diagram data"]
[null,null,"Wind directionality factor 'Kd' =",{"$nulls":10},0.85,{"$nulls":15},"Edge panel:",null,"lp",{"$f":"IF(C8=AG3,\"\",3.25)","v":{"v":3.25,"d":"3.3"}}]
[null,null,"Velocity pressure exposure coefficient 'Kz' =",{"$nulls":10},{"$f":"IF(θ<=7,\nIF(exposureCategory=\"B\",FORECAST(h,OFFSET(Calculations!$J$7:$J$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2),OFFSET(Calculations!$I$7:$I$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2)),IF(exposureCategory=\"C\",FORECAST(h,OFFSET(Calculations!$K$7:$K$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2),OFFSET(Calculations!$I$7:$I$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2)),IF(exposureCategory=\"D\",FORECAST(h,OFFSET(Calculations!$L$7:$L$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2),OFFSET(Calculations!$I$7:$I$29,MATCH(h,Calculations!$I$7:$I$29,1)-1,0,2)),\"EXP CAT INVALID\"))),\nIF(h < 15, 2.01*(15/z_g)^(2/α), 2.01*(h/z_g)^(2/α)))","v":1.13},{"$nulls":15},"Yes",null,"h1",{"$f":"IF(C8=AG3,\"\",h_1)","v":0.5}]
[null,null,"Velocity pressure 'qh' [psf] =",{"$nulls":10},{"$f":"0.00256 * K_z * K_zt *K_d * V^2","v":{"v":13.8312,"d":"13.83"}},{"$nulls":15},"No",null,"panel angle",{"$f":"IF(C8=AG3,\"\",20)","v":{"v":20,"d":"20.0"}}]
[null,null,"Roof shape determinant 'apv' [ft] =",{"$nulls":10},{"$f":"MIN(0.5*SQRT(h*W_L), h)","v":{"v":13.416407864998739,"d":"13.4"}},{"$nulls":12},"(Not to scale)",null,null,"Calculate for:",null,"lp - sloped roof",{"$f":"IF(C8=AG3,3.25,\"\")","v":""}]
[{"$nulls":29},"Worst case panel design",null,"roof angle",{"$f":"IF(C8=AG3,20,\"\")","v":""}]
[null,null,"PV PANEL DATA",{"$nulls":13},"DIAGRAM: ROOF LAYOUT",{"$nulls":12},"North-East panel design",null,"length",{"$f":"W_L","v":{"v":12,"d":"12.0"}}]
[null,null,"Panel width 'b' [ft] =",{"$nulls":10},{"v":3.25,"d":"3.3"},{"$nulls":15},"South-East panel design",null,"depth",{"$f":"W_S","v":{"v":11,"d":"11.0"}}]
[null,null,"Panel chord lenght 'lp' [ft] =",{"$nulls":10},{"v":5,"d":"5.0"},{"$nulls":15},"South-West panel design"]
[null,null,"Panel height above roof at low edge 'h1' [ft] =",{"$nulls":10},0.5,{"$nulls":15},"North-West panel design"]
[null,null,"Self weight of solar panel 'W' [lbs] =",{"$nulls":10},{"v":65,"d":"65.0"}]
[null,null,"Coefficient of friction 'μ' =",{"$nulls":10},0.4,{"$nulls":15},"NORTH Horizontal distance measured orthogonal to the panel edges in the NORTH direction to building edge [ft] =",{"$f":"F33","v":{"v":2,"d":"2.0"}}]
[{"$nulls":29},"Horizontal distance measured orthogonal to the panel edges in the NORTH direction to adjacent panel [ft] =",{"$f":"M33","v":{"v":6,"d":"6.00"}},{"$f":"IF(isEdgePanel_N,\"\",d_pN)","v":""}]
[null,null,"PV ARRAY LOCATION (see layout)",{"$nulls":26},"Panel is an edge panel unobstructed by other panels from NORTH side? =",{"$f":"IF(I33=$AD$20,TRUE,FALSE)","v":true}]
[null,null,"Direction:",null,null,"'dedge' [ft]:",null,null,"edge panel:",{"$nulls":3},"'dadjacent' [ft]:",{"$nulls":16},"EAST Horizontal distance measured orthogonal to the panel edges in the EAST direction to building edge [ft] =",{"$f":"F34","v":{"v":2,"d":"2.0"}}]
[null,null,"North",null,null,{"v":2,"d":"2.0"},null,null,"Yes",{"$nulls":3},{"v":6,"d":"6.00"},{"$nulls":16},"Horizontal distance measured orthogonal to the panel edges in the EAST direction to adjacent panel [ft] =",{"$f":"M34","v":{"v":5,"d":"5.00"}},{"$f":"IF(isEdgePanel_E,\"\",d_pE)","v":""}]
[null,null,"East",null,null,{"v":2,"d":"2.0"},null,null,"Yes",{"$nulls":3},{"v":5,"d":"5.00"},{"$nulls":16},"Panel is an edge panel unobstructed by other panels from EAST side? =",{"$f":"IF(I34=$AD$20,TRUE,FALSE)","v":true}]
[null,null,"South",null,null,{"v":2,"d":"2.0"},null,null,"Yes",{"$nulls":3},{"v":2,"d":"2.00"},{"$nulls":16},"SOUTH Horizontal distance measured orthogonal to the panel edges in the SOUTH direction to building edge [ft] =",{"$f":"F35","v":{"v":2,"d":"2.0"}}]
[null,null,"West",null,null,{"v":2,"d":"2.0"},null,null,"Yes",{"$nulls":3},{"v":14,"d":"14.00"},{"$nulls":16},"Horizontal distance measured orthogonal to the panel edges in the SOUTH direction to adjacent panel [ft] =",{"$f":"M35","v":{"v":2,"d":"2.00"}},{"$f":"IF(isEdgePanel_S,\"\",d_pS)","v":""}]
[null,null,"Calculation type:",{"$nulls":4},"North-East panel design",{"$nulls":18},"(Not to scale. Panels and obstructions are indicative only)",null,null,"Panel is an edge panel unobstructed by other panels from SOUTH side? =",{"$f":"IF(I35=$AD$20,TRUE,FALSE)","v":true}]
[null,null,"dedge - distance to building edge in given direction.\nedge panel - panel unobstracted by other panels in given direction.\ndadjacent - distance to adjacent panel in given direction.",{"$nulls":26},"WEST Horizontal distance measured orthogonal to the panel edges in the WEST direction to building edge [ft] =",{"$f":"F36","v":{"v":2,"d":"2.0"}}]
[{"$nulls":29},"Horizontal distance measured orthogonal to the panel edges in the WEST direction to adjacent panel [ft] =",{"$f":"M36","v":{"v":14,"d":"14.00"}},{"$f":"IF(isEdgePanel_W,\"\",d_pW)","v":""}]
[{"$nulls":29},"Panel is an edge panel unobstructed by other panels from WEST side? =",{"$f":"IF(I36=$AD$20,TRUE,FALSE)","v":true}]
[null,null,"PV ARRAY ANALYSIS",{"$nulls":13},"CALCULATIONS: WIND FORCES"]
[null,null,"Corner:",null,"Zone:",null,"'hc-X' [ft]:",null,"'GCp'",null,"'γc*(GCrn)nom'",null,null,"'E' factor:",null,null,"Reduction for wind tunnel tests & load sharing =",{"$nulls":8},{"v":0,"d":"0%"},{"$nulls":3},"GCp calculations (plus and minus)",null,"yc * GCrn_nom * E"]
[null,null,"North-East",null,{"$f":"Calculations!D7","v":3},null,{"$f":"INDEX(Calculations!E29:E32,MATCH(Calculations!$G$33,Calculations!$G$29:$G$32,0))","v":{"v":1.341640786499874,"d":"1.34"}},null,{"$f":"IF($C$8=$AG$3,FIXED(AD43,1)&\"/\"&FIXED(AE43,1),\"N/A\")","v":"N/A"},null,{"$f":"IF($C$8=$AG$3,\"N/A\",OFFSET(Calculations!$G$17,0,-'Photovoltaic module'!E43))","v":{"v":1.9440383822372553,"d":"1.944"}},null,null,{"$f":"IF($C$8=$AG$3,\"N/A\",Calculations!$G$33)","v":{"v":1,"d":"1.00"}},null,null,"In-to-roof force on PV panel 'Fin-to-roof' [lbs] =",{"$nulls":8},{"$f":"(1-$Z$42)*F_d*IF(PVType=\"Fixed\", 4, IF(PVType=\"Ballasted\", 1))","v":{"v":284.00855253972423,"d":"284.0"}},{"$nulls":3},{"$f":"INDEX(IF(θ<=27,Calculations!$D$59:$F$59,Calculations!$D$66:$F$66),1,E43)","v":{"v":-2.6,"d":"-2.600"}},{"$f":"INDEX(IF(θ<=27,Calculations!$D$60:$F$60,Calculations!$D$67:$F$67),1,E43)","v":{"v":0.5,"d":"0.500"}},{"$f":"IF(NOT($C$8=$AG$3),K43*N43,\"N/A\")","v":{"v":1.9440383822372553,"d":"1.944"}}]
[null,null,"South-East",null,{"$f":"Calculations!E7","v":3},null,{"$f":"INDEX(Calculations!E36:E39,MATCH(Calculations!$G$40,Calculations!$G$36:$G$39,0))","v":{"v":1.6115654658084233,"d":"1.61"}},null,{"$f":"IF($C$8=$AG$3,FIXED(AD44,1)&\"/\"&FIXED(AE44,1),\"N/A\")","v":"N/A"},null,{"$f":"IF($C$8=$AG$3,\"N/A\",OFFSET(Calculations!$G$17,0,-'Photovoltaic module'!E44))","v":{"v":1.9440383822372553,"d":"1.944"}},null,null,{"$f":"IF($C$8=$AG$3,\"N/A\",Calculations!$G$40)","v":{"v":1,"d":"1.00"}},null,null,"Uplift force on PV panel 'Fuplift' [lbs] =",{"$nulls":8},{"$f":"-(1-$Z$42)*F*IF(PVType=\"Fixed\", 4, IF(PVType=\"Ballasted\", 1))","v":{"v":-284.00855253972423,"d":"-284.0"}},{"$nulls":3},{"$f":"INDEX(IF(θ<=27,Calculations!$D$59:$F$59,Calculations!$D$66:$F$66),1,E44)","v":{"v":-2.6,"d":"-2.600"}},{"$f":"INDEX(IF(θ<=27,Calculations!$D$60:$F$60,Calculations!$D$67:$F$67),1,E44)","v":{"v":0.5,"d":"0.500"}},{"$f":"IF(NOT($C$8=$AG$3),K44*N44,\"N/A\")","v":{"v":1.9440383822372553,"d":"1.944"}}]
[null,null,"South-West",null,{"$f":"Calculations!F7","v":3},null,{"$f":"INDEX(Calculations!E43:E46,MATCH(Calculations!$G$47,Calculations!$G$43:$G$46,0))","v":{"v":1.6115654658084233,"d":"1.61"}},null,{"$f":"IF($C$8=$AG$3,FIXED(AD45,1)&\"/\"&FIXED(AE45,1),\"N/A\")","v":"N/A"},null,{"$f":"IF($C$8=$AG$3,\"N/A\",OFFSET(Calculations!$G$17,0,-'Photovoltaic module'!E45))","v":{"v":1.9440383822372553,"d":"1.944"}},null,null,{"$f":"IF($C$8=$AG$3,\"N/A\",Calculations!$G$47)","v":{"v":1,"d":"1.00"}},null,null,"Horizontal 'uplift' force on panel 'Fhoriz' [lbs] =",{"$nulls":8},{"$f":"IF(C8=AG3,\"N/A\",(1-$Z$42)*F_horiz*IF(PVType=\"Fixed\",4,IF(PVType=\"Ballasted\",1)))","v":{"v":97.13664584535219,"d":"97.1"}},{"$nulls":3},{"$f":"INDEX(IF(θ<=27,Calculations!$D$59:$F$59,Calculations!$D$66:$F$66),1,E45)","v":{"v":-2.6,"d":"-2.600"}},{"$f":"INDEX(IF(θ<=27,Calculations!$D$60:$F$60,Calculations!$D$67:$F$67),1,E45)","v":{"v":0.5,"d":"0.500"}},{"$f":"IF(NOT($C$8=$AG$3),K45*N45,\"N/A\")","v":{"v":1.9440383822372553,"d":"1.944"}}]
[null,null,"North-West",null,{"$f":"Calculations!G7","v":3},null,{"$f":"INDEX(Calculations!E22:E25,MATCH(E,Calculations!$G$22:$G$25,0))","v":{"v":1.341640786499874,"d":"1.34"}},null,{"$f":"IF($C$8=$AG$3,FIXED(AD46,1)&\"/\"&FIXED(AE46,1),\"N/A\")","v":"N/A"},null,{"$f":"IF($C$8=$AG$3,\"N/A\",OFFSET(Calculations!$G$17,0,-'Photovoltaic module'!E46))","v":{"v":1.9440383822372553,"d":"1.944"}},null,null,{"$f":"IF($C$8=$AG$3,\"N/A\",E)","v":{"v":1,"d":"1.00"}},null,null,"Vertical uplift force on panel 'Fvert' [lbs] =",{"$nulls":8},{"$f":"IF(C8=AG3,\"N/A\",-(1-$Z$42)*F_vert*IF(PVType=\"Fixed\", 4, IF(PVType=\"Ballasted\", 1)))","v":{"v":-266.88074106166584,"d":"-266.9"}},{"$nulls":3},{"$f":"INDEX(IF(θ<=27,Calculations!$D$59:$F$59,Calculations!$D$66:$F$66),1,E46)","v":{"v":-2.6,"d":"-2.600"}},{"$f":"INDEX(IF(θ<=27,Calculations!$D$60:$F$60,Calculations!$D$67:$F$67),1,E46)","v":{"v":0.5,"d":"0.500"}},{"$f":"IF(NOT($C$8=$AG$3),K46*N46,\"N/A\")","v":{"v":1.9440383822372553,"d":"1.944"}}]
[{"$nulls":29},{"$f":"IF(H37=AD23,MIN(AD43:AD46),INDEX(AD43:AD46,MATCH(H37,AD24:AD27,0)))","v":{"v":-2.6,"d":"-2.600"}},{"$f":"MAX(AE43:AE46)","v":{"v":0.5,"d":"0.500"}},{"$f":"IF(H37=AD23,MAX(AF43:AF46),INDEX(AF43:AF46,MATCH(H37,AD24:AD27,0)))","v":{"v":1.9440383822372553,"d":"1.944"}}]
[null,null,"CALCULATIONS: WIND PRESSURES",{"$nulls":13},"RESULTS"]
[null,null,"Dead load of panel over module area 'PD' [psf] =",{"$nulls":10},{"$f":"65/A","v":{"v":24.615384615384617,"d":"24.6"}},null,null,"Building mean height less than 60ft:",{"$nulls":8},{"$f":"IF(h<=60,\"OK\",\"NOT OK\")","v":"OK"}]
[null,null,"Panel chord length factor 'γc' =",{"$nulls":10},{"$f":"IF(θ<=7, MIN(1, MAX(0.8, 0.6+0.06*3.25)), \"N/A\")","v":0.8},null,null,"Building mean height less than min L, B:",{"$nulls":8},{"$f":"IF(h<MIN(W_L,W_S),\"OK\",\"NOT OK\")","v":"NOT OK"}]
[null,null,"Parapet height factor 'γp' =",{"$nulls":10},{"$f":"IF(θ<=7, IF(h_pt<4,1,MIN(0.25*h_pt,1.3)), \"N/A\")","v":{"v":1,"d":"1.0"}},null,null,"Required ballast for uplift 'Wblst_uplift' [lbs] =",{"$nulls":8},{"$f":"IF($C$8=$AG$4,(1-$Z$42)*AG15 - 0.9*P_D*A,\"N/A\")","v":"N/A"}]
[null,null,"Effective wind area 'A' [sqft] =",{"$nulls":10},{"$f":"IF(3.25 < 3.25/3, 3.25*3.25/3*pea, 3.25*3.25*pea)","v":{"v":2.640625,"d":"2.6"}},null,null,"Required ballast for sliding 'Wblst_sliding' [lbs] =",{"$nulls":8},{"$f":"IF($C$8=$AG$4,(1-$Z$42)*AG16 - 0.9*P_D*A,\"N/A\")","v":"N/A"}]
[null,null,"Normalized wind area 'An' [sqft] =",{"$nulls":10},{"$f":"IF(θ<=7, (1000/(MAX(a_pv,15))^2) * A, \"N/A\")","v":{"v":11.736111111111112,"d":"11.7"}},null,null,"Required ballast per PV panel 'Wballast' [lbs] =",{"$nulls":8},{"$f":"IF($C$8=$AG$4,MAX(Z51,Z52),\"N/A\")","v":"N/A"}]
[null,null,"Tributary area 'At' [sqft] =",{"$nulls":10},{"$f":"3.25*3.25*pea","v":{"v":2.640625,"d":"2.6"}},null,null,"Force per fixing per PV panel 'Fcomp_fixing' [lbs] =",{"$nulls":8},{"$f":"IF(NOT($C$8=$AG$4),IF(C8=AG3,Z43,-Z46)/4+65/4,\"N/A\")","v":{"v":82.97018526541646,"d":"83.0"}}]
[null,null,{"$f":"\"Net in-to-roof pressure coefficient \"&IF($C$8=$AG$3,\"'GCp' =\",\"'GCrn' =\")","v":"Net in-to-roof pressure coefficient 'GCrn' ="},{"$nulls":10},{"$f":"IF(θ<=7, γ_p * $AF$47,\nIF(θ<=45, AE47, \"NOT CALCUABLE\"))","v":{"v":1.9440383822372553,"d":"1.94"}},null,null,"Force per fixing per PV panel 'Ftens_fixing' [lbs] =",{"$nulls":8},{"$f":"IF(NOT($C$8=$AG$4),IF(C8=AG3,Z44,Z46)/4+0.9*65/4,\"N/A\")","v":{"v":-52.09518526541646,"d":"-52.1"}}]
[null,null,{"$f":"\"Net uplift suction coefficient \"&IF($C$8=$AG$3,\"'GCp' =\",\"'GCrn' =\")","v":"Net uplift suction coefficient 'GCrn' ="},{"$nulls":10},{"$f":"IF(θ<=7, -γ_p * $AF$47,\nIF(θ<=45, AD47, \"NOT CALCUABLE\"))","v":{"v":-1.9440383822372553,"d":"-1.94"}},null,null,"Force per fixing per PV panel 'Fshear_fixing' [lbs] =",{"$nulls":8},{"$f":"IF(NOT(C8=AG5),\"N/A\",Z45/4)","v":{"v":24.284161461338048,"d":"24.3"}}]
[null,null,"Design in-to-roof wind pressure 'pin-to-roof' [psf] =",{"$nulls":10},{"$f":"p_dwn","v":{"v":26.88838367239993,"d":"26.89"}},null,null,"Designer's notes here if any."]
[null,null,"Design uplift wind suction 'puplift' [psf] =",{"$nulls":10},{"$f":"-p","v":{"v":-26.88838367239993,"d":"-26.89"}}]
[]
[null,null,"Spreadsheet provided by: www.YourSpreadsheets.co.uk",{"$nulls":23},"calculations are based on SEAOC PV2 (2012) and ASCE 7-10 (2010)"]

{"sheet":"Calculations","index":1,"n_rows":67,"n_cols":15,"rows_kept":67,"hidden":true,"merged":[[2,8,2,11],[3,8,3,11],[4,9,4,11],[30,8,30,11]]}
[]
[null,"Zone 3 setback [ft] =",0,{"$nulls":5},{"$f":"\"NOTE: For use with \" & O7","v":"NOTE: For use with Low-rise w/ roof slope θ ≤ 7°"}]
[null,"Zone 2 from 3, and Zone 1 from 2 setbacks [ft] =",{"$f":"IF(θ<=7, 2*a_pv, MAX(MIN(0.1*MIN(W_L,W_S),0.4*h),0.04*MIN(W_L,W_S),3))","v":26.832815729997478},{"$nulls":5},"ASCE 7-10 Table 29.3-1",{"$nulls":4},"Options:"]
[null,"Zone 0 setback [ft] =",{"$f":"IF(θ<=7, 5*a_pv, FALSE)","v":67.0820393249937},{"$nulls":5},"Velocity Pressure Exposure Coefficients, K_h and K_z"]
[{"$nulls":9},"Exposure"]
[null,"Edge Zones","Dirs","N & E","E & S","S & W","W & N",null,"Height","B","C","D",null,"Menu","Option"]
[{"$nulls":3},{"$f":"IF(d_bN < setback_Z2,\n       IF(d_bE < setback_Z2, 3, 2),\n       IF(d_bE < setback_Z2, 2,\n               IF(AND(d_bN >= setback_Z0, d_bE >= setback_Z0), 0, 1)))","v":3},{"$f":"IF(d_bE < setback_Z2,\n       IF(d_bS < setback_Z2, 3, 2),\n       IF(d_bS < setback_Z2, 2,\n               IF(AND(d_bE >= setback_Z0, d_bS >= setback_Z0), 0, 1)))","v":3},{"$f":"IF(d_bS < setback_Z2,\n       IF(d_bW < setback_Z2, 3, 2),\n       IF(d_bW < setback_Z2, 2,\n               IF(AND(d_bS >= setback_Z0, d_bW >= setback_Z0), 0, 1)))","v":3},{"$f":"IF(d_bW < setback_Z2,\n       IF(d_bN < setback_Z2, 3, 2),\n       IF(d_bN < setback_Z2, 2,\n               IF(AND(d_bW >= setback_Z0, d_bN >= setback_Z0), 0, 1)))","v":3},null,0,0.57,0.85,1.03,null,"Building Types","Low-rise w/ roof slope θ ≤ 7°"]
[null,"Zone",{"$nulls":6},15,0.57,0.85,1.03,null,null,"Pitched roof"]
[{"$nulls":8},20,0.62,0.9,1.08]
[null,"For roof slope <= 7 degrees",{"$nulls":6},25,0.66,0.94,1.12,null,"PV Types","Fixed"]
[{"$nulls":8},30,0.7,0.98,1.16,null,null,"Ballasted"]
[null,"Theoretical nominal net pressure coefficients, (GC_rn)_nom",{"$nulls":6},40,0.76,1.04,1.22]
[null,null,"ω (deg)","Zone 3","Zone 2","Zone 1","Zone 0",null,50,0.81,1.09,1.27]
[null,null,"0 - 5",{"$f":"IF(A_n < 500,\n-0.6669*LOG(A_n)+2.3,\n-0.35*LOG(A_n)+1.445)","v":1.5867343026714629},{"$f":"IF(A_n < 500,\n-0.5743*LOG(A_n)+2,\n-0.3*LOG(A_n)+1.26)","v":1.3857722447506693},{"$f":"IF(A_n < 500,\n-0.4261*LOG(A_n)+1.5,\n-0.25*LOG(A_n)+1.025)","v":1.0442757330458996},{"$f":"IF(A_n < 500,\n-0.1853*LOG(A_n)+0.8,\n-0.2*LOG(A_n)+0.84)","v":0.6018171634203361},null,60,0.85,1.13,1.31]
[null,null,"15 - 35",{"$f":"IF(A_n < 500,\n-1.0004*LOG(A_n)+3.5,\n-0.3*LOG(A_n)+1.61)*γ_c","v":1.9440383822372553},{"$f":"IF(A_n < 500,\n-0.8337*LOG(A_n)+2.9,\n-0.25*LOG(A_n)+1.325)*γ_c","v":1.6066701312187122},{"$f":"IF(A_n < 500,\n-0.5372*LOG(A_n)+2,\n-0.25*LOG(A_n)+1.225)*γ_c","v":1.1403612744280822},{"$f":"IF(A_n < 500,\n-0.2223*LOG(A_n)+1.1,\n-0.25*LOG(A_n)+1.175)*γ_c","v":0.6897958140457237},null,70,0.89,1.17,1.34]
[{"$nulls":8},80,0.93,1.21,1.38]
[null,"Interpolation net pressure coefficients, (GC_rn)_nom * γ_c =",null,{"$f":"IF(ω<=5,D14,\nIF(ω>=15,D15,\n(ω-5)*(D15-D14)/(15-5)+D14\n))","v":1.9440383822372553},{"$f":"IF(ω<=5,E14,\nIF(ω>=15,E15,\n(ω-5)*(E15-E14)/(15-5)+E14\n))","v":1.6066701312187122},{"$f":"IF(ω<=5,F14,\nIF(ω>=15,F15,\n(ω-5)*(F15-F14)/(15-5)+F14\n))","v":1.1403612744280822},{"$f":"IF(ω<=5,G14,\nIF(ω>=15,G15,\n(ω-5)*(G15-G14)/(15-5)+G14\n))","v":0.6897958140457237},null,90,0.96,1.24,1.4]
[{"$nulls":8},100,0.99,1.26,1.43]
[null,"Edge factors",{"$nulls":6},120,1.04,1.31,1.48]
[{"$nulls":8},140,1.09,1.36,1.52]
[null,"1 - NORTH-WEST","Direction","d_X","h_c,X","Zone 2 or 3 & d_X > 3 a_pv?","E_X",null,160,1.13,1.39,1.55]
[null,null,"North",{"$f":"IF(isEdgePanel_N, d_bN, MIN(d_bN, d_pN))","v":2},{"$f":"IF(isEdgePanel_N,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(G7=2, G7=3), d_bN > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F22, 1.5,\nIF(D22/E22 <= 2, 1,\nIF(D22/E22 < 8, 1 + (2 - 1) * (D22/E22 - 2)/(8 - 2),\n2)))","v":1},null,180,1.17,1.43,1.58]
[null,null,"East",{"$f":"0","v":0},{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(G7=2, G7=3), W_L - d_bW > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F23, 1,\nIF(D23/E23 <= 2, 1,\nIF(D23/E23 < 8, 1 + (1.5 - 1) * (D23/E23 - 2)/(8 - 2),\n1.5)))","v":1},null,200,1.2,1.46,1.61]
[null,null,"South",{"$f":"0","v":0},{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(G7=2, G7=3), W_S - d_bN > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F24, 1,\nIF(D24/E24 <= 2, 1,\nIF(D24/E24 < 8, 1 + (1.5 - 1) * (D24/E24 - 2)/(8 - 2),\n1.5)))","v":1},null,250,1.28,1.53,1.68]
[null,null,"West",{"$f":"IF(isEdgePanel_W, d_bW, MIN(d_bW, d_pW))","v":2},{"$f":"IF(isEdgePanel_W,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(G7=2, G7=3), d_bW > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F25, 1,\nIF(D25/E25 <= 2, 1,\nIF(D25/E25 < 8, 1 + (1.5 - 1) * (D25/E25 - 2)/(8 - 2),\n1.5)))","v":1},null,300,1.35,1.59,1.73]
[null,null,"Max",{"$nulls":3},{"$f":"MAX(G22:G25)","v":1},null,350,1.41,1.64,1.78]
[{"$nulls":8},400,1.47,1.69,1.82]
[null,"2 - NORTH-EAST","Direction","d_X","h_c,X","Zone 2 or 3 & d_X > 3 a_pv?","E_X",null,450,1.52,1.73,1.86]
[null,null,"North",{"$f":"IF(isEdgePanel_N, d_bN, MIN(d_bN, d_pN))","v":2},{"$f":"IF(isEdgePanel_N,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(D7=2, D7=3), d_bN > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F29, 1.5,\nIF(D29/E29 <= 2, 1,\nIF(D29/E29 < 8, 1 + (2 - 1) * (D29/E29 - 2)/(8 - 2),\n2)))","v":1},null,500,1.56,1.77,1.89]
[null,null,"East",{"$f":"IF(isEdgePanel_E, d_bE, MIN(d_bE, d_pE))","v":2},{"$f":"IF(isEdgePanel_E,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(D7=2, D7=3), d_bE > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F30, 1,\nIF(D30/E30 <= 2, 1,\nIF(D30/E30 < 8, 1 + (1.5 - 1) * (D30/E30 - 2)/(8 - 2),\n1.5)))","v":1}]
[null,null,"South",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(D7=2, D7=3), W_S - d_bN > 3*a_pv), TRUE, FALSE)","v":false},1,null,"ASCE 7-10 Table 26.9-1"]
[null,null,"West",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(D7=2, D7=3), W_L - d_bE > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F32, 1,\nIF(D32/E32 <= 2, 1,\nIF(D32/E32 < 8, 1 + (1.5 - 1) * (D32/E32 - 2)/(8 - 2),\n1.5)))","v":1},null,"Exposure","α","z_g","z_min"]
[null,null,"Max",{"$nulls":3},{"$f":"MAX(G29:G32)","v":1},null,"B",7,1200,30]
[{"$nulls":8},"C",9.5,900,15]
[null,"3 - SOUTH-EAST","Direction","d_X","h_c,X","Zone 2 or 3 & d_X > 3 a_pv?","E_X",null,"D",11.5,700,7]
[null,null,"North",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(E7=2, E7=3), W_S - d_bS > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F36, 1.5,\nIF(D36/E36 <= 2, 1,\nIF(D36/E36 < 8, 1 + (2 - 1) * (D36/E36 - 2)/(8 - 2),\n2)))","v":1}]
[null,null,"East",{"$f":"IF(isEdgePanel_E, d_bE, MIN(d_bE, d_pE))","v":2},{"$f":"IF(isEdgePanel_E,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(E7=2, E7=3), d_bE > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F37, 1,\nIF(D37/E37 <= 2, 1,\nIF(D37/E37 < 8, 1 + (1.5 - 1) * (D37/E37 - 2)/(8 - 2),\n1.5)))","v":1}]
[null,null,"South",{"$f":"IF(isEdgePanel_S, d_bS, MIN(d_bS, d_pS))","v":2},{"$f":"IF(isEdgePanel_S,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(E7=2, E7=3), d_bS > 3*a_pv), TRUE, FALSE)","v":false},1]
[null,null,"West",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(E7=2, E7=3), W_L - d_bE > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F39, 1,\nIF(D39/E39 <= 2, 1,\nIF(D39/E39 < 8, 1 + (1.5 - 1) * (D39/E39 - 2)/(8 - 2),\n1.5)))","v":1}]
[null,null,"Max",{"$nulls":3},{"$f":"MAX(G36:G39)","v":1}]
[]
[null,"4 - SOUTH-WEST","Direction","d_X","h_c,X","Zone 2 or 3 & d_X > 3 a_pv?","E_X"]
[null,null,"North",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(F7=2, F7=3), W_S - d_bS > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F43, 1.5,\nIF(D43/E43 <= 2, 1,\nIF(D43/E43 < 8, 1 + (2 - 1) * (D43/E43 - 2)/(8 - 2),\n2)))","v":1}]
[null,null,"East",0,{"$f":"MIN(h_1,1)+3.25*SIN(ω*PI()/180)","v":1.6115654658084233},{"$f":"IF(AND(OR(F7=2, F7=3), W_L - d_bW > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F44, 1,\nIF(D44/E44 <= 2, 1,\nIF(D44/E44 < 8, 1 + (1.5 - 1) * (D44/E44 - 2)/(8 - 2),\n1.5)))","v":1}]
[null,null,"South",{"$f":"IF(isEdgePanel_S, d_bS, MIN(d_bS, d_pS))","v":2},{"$f":"IF(isEdgePanel_S,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(F7=2, F7=3), d_bS > 3*a_pv), TRUE, FALSE)","v":false},1]
[null,null,"West",{"$f":"IF(isEdgePanel_W, d_bW, MIN(d_bW, d_pW))","v":2},{"$f":"IF(isEdgePanel_W,0.1*a_pv,MIN(h_1,1)+3.25*SIN(ω*PI()/180))","v":1.341640786499874},{"$f":"IF(AND(OR(F7=2, F7=3), d_bW > 3*a_pv), TRUE, FALSE)","v":false},{"$f":"IF(F46, 1,\nIF(D46/E46 <= 2, 1,\nIF(D46/E46 < 8, 1 + (1.5 - 1) * (D46/E46 - 2)/(8 - 2),\n1.5)))","v":1}]
[null,null,"Max",{"$nulls":3},{"$f":"MAX(G43:G46)","v":1}]
[]
[]
[null,"For roof slopes greater than 7 degrees - calcs not used"]
[]
[null,"α =",{"$f":"IF(exposureCategory=\"B\", Calculations!$J$33,\nIF(exposureCategory=\"C\", Calculations!$J$34,\nIF(exposureCategory=\"D\", Calculations!$J$35, \"INVALID EXP CATEGORY\")))","v":9.5}]
[null,"z_g =",{"$f":"IF(exposureCategory=\"B\", Calculations!$K$33,\nIF(exposureCategory=\"C\", Calculations!$K$34,\nIF(exposureCategory=\"D\", Calculations!$K$35, \"INVALID EXP CATEGORY\")))","v":900}]
[]
[null,"For roof slopes greater than 7 degrees and less than or equal to 27 degrees"]
[]
[null,"GC_p"]
[null,null,"Direction","Zone 1","Zone 2","Zone 3"]
[null,null,"Uplift",{"$f":"IF(A<=10, -0.9,\nIF(A<100, -0.9 + (-0.8 - -0.9) * (A-10)/(100-10),\n-0.8))","v":-0.9},{"$f":"IF(A<=10, -1.5,\nIF(A<100, -1.5 + (-1.2 - -1.5) * (A-10)/(100-10),\n-1.2))","v":-1.5},{"$f":"IF(A<=10, -2.6,\nIF(A<100, -2.6 + (-2 - -2.6) * (A-10)/(100-10),\n-2))","v":-2.6},null,"minus is 'away from surface'"]
[null,null,"Downward pressure",{"$f":"IF(A<=10, 0.5,\nIF(A<100, 0.5 + (0.3 - 0.5) * (A-10)/(100-10),\n0.3))","v":0.5},{"$f":"IF(A<=10, 0.5,\nIF(A<100, 0.5 + (0.3 - 0.5) * (A-10)/(100-10),\n0.3))","v":0.5},{"$f":"IF(A<=10, 0.5,\nIF(A<100, 0.5 + (0.3 - 0.5) * (A-10)/(100-10),\n0.3))","v":0.5},null,"plus is 'towards surface'"]
[]
[null,"For roof slopes greater than 27 and less than or equal to 45"]
[]
[null,"GC_p"]
[null,null,"Direction","Zone 1","Zone 2","Zone 3"]
[null,null,"Uplift",{"$f":"IF(A<=10, -1,\nIF(A<100, -1 + (-0.8 - -1) * (A-10)/(100-10),\n-0.8))","v":-1},{"$f":"IF(A<=10, -1.2,\nIF(A<100, -1.2 + (-1 - -1.2) * (A-10)/(100-10),\n-1))","v":-1.2},{"$f":"IF(A<=10, -1.2,\nIF(A<100, -1.2 + (-1 - -1.2) * (A-10)/(100-10),\n-1))","v":-1.2}]
[null,null,"Downward pressure",{"$f":"IF(A<=10, 0.9,\nIF(A<100, 0.9 + (0.8 - 0.9) * (A-10)/(100-10),\n0.8))","v":0.9},{"$f":"IF(A<=10, 0.9,\nIF(A<100, 0.9 + (0.8 - 0.9) * (A-10)/(100-10),\n0.8))","v":0.9},{"$f":"IF(A<=10, 0.9,\nIF(A<100, 0.9 + (0.8 - 0.9) * (A-10)/(100-10),\n0.8))","v":0.9}]

{"sheet":"from author","index":2,"n_rows":39,"n_cols":11,"rows_kept":39,"merged":[[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[6,2,9,9],[12,2,22,9],[23,2,23,7],[24,2,27,9],[31,2,34,9],[38,2,41,9]]}
[null,"Version: 1.1. - FREE LITE VERSION",{"$nulls":8},"© 2014-2019 Damian Janicki"]
[]
[null,null,"For latest updates and news visit:",{"$nulls":3},"Contact me at:"]
[null,null,"www.YourSpreadsheets.co.uk",{"$nulls":3},"info@yourspreadsheets.co.uk"]
[]
[]
[null,null,"General information:\nNote: This spreadsheet contains macros. These must be enabled to use this spreadsheet."]
[]
[]
[]
[]
[]
[null,null,"The Author takes no liability for use of this spreadsheet and gives no guarantee that it is error free. \n\nIn no event shall the Author be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Author has been advised of the possibility of such damage.\n\nThis spreadsheet is a freeware and can be distributed freely but only in its original form.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowable.\n\nA full list of terms and conditions can be found here:"]
{"$rows_empty":10}
[null,null,"www.yourspreadsheets.co.uk/checkout.html"]
[null,null,"\nBy using this spreadsheet you understand and agree with the terms and conditions. You also acknowledge that you do not become an owner of this spreadsheet.\n\nDamian Janicki"]
[]
[]
[]
[]
[]
[]
[null,null,"This is a Free Lite Version. The full version of the spreadsheet allows to:\n- Input your company information and change logo\n- Change anlge, weight and area  of PV module."]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet is based on SEAOC PV2 and ASCE 7-10.\n\nChangelog:\n2019.11.17 - v.1.2. - added checks for maximum panel width and height above roof\n2014.02.22 - v.1.0. - official release of the spreadsheet."]