{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Wi System","from authors"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":68,"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":"Wi System","index":0,"n_rows":65,"n_cols":160,"rows_kept":65,"cut":false,"hidden":false,"merged":[[18,16,18,26],[16,16,16,26],[17,16,17,26],[11,16,11,26],[12,16,12,26],[14,16,14,26],[15,16,15,26],[10,16,10,26],[13,16,13,26],[11,34,11,39],[7,16,7,26],[8,25,8,26],[9,16,9,25],[30,2,30,26],[24,2,24,12],[24,13,24,14],[26,2,26,12],[26,13,26,14],[25,25,25,26],[26,25,26,26],[26,16,26,24],[25,16,25,24],[27,16,27,25],[21,24,21,26],[21,16,21,22],[21,2,21,12],[21,13,21,14],[25,2,25,12],[22,2,22,12],[22,13,22,14],[23,2,23,12],[23,13,23,14],[25,13,25,14],[22,25,22,26],[23,25,23,26],[24,25,24,26],[24,16,24,24],[23,16,23,24],[22,16,22,24],[15,2,15,12],[13,2,13,10],[14,2,14,10],[17,10,17,12],[16,13,16,14],[17,13,17,14],[13,11,13,14],[14,11,14,14],[16,11,16,12],[16,2,16,10],[0,18,0,27],[1,4,4,15],[1,16,3,21],[3,22,3,23],[3,24,3,27],[4,16,4,18],[4,19,4,21],[4,22,4,23],[4,24,4,27],[2,22,2,23],[2,24,2,27],[0,4,0,16],[9,2,9,10],[3,52,3,54],[3,44,3,46],[5,4,5,15],[5,16,5,18],[5,19,5,21],[5,22,5,23],[7,2,7,14],[5,24,5,27],[5,2,5,3],[8,16,8,24],[8,11,8,14],[9,11,9,14],[8,7,8,10],[8,2,8,4],[8,5,8,6],[11,2,11,14],[18,13,18,14],[62,12,62,26],[62,2,62,11],[28,2,28,14],[19,2,19,14],[27,2,27,12],[27,13,27,14],[18,10,18,12],[18,2,18,9],[20,16,20,26],[20,2,20,14],[17,2,17,9],[12,2,12,10],[12,11,12,14],[15,13,15,14]]}
[null,"Version: 1.8",null,null,{"$f":"IF(AD4=TRUE,\" \",IF(AJ2=TRUE,\"A newer version is available to download. Please visit our website.\",\" \"))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2023 YourSpreadsheets and Wembley Innovation"]
[null,null,null,null,"Wembley Innovation Ltd                                                                 Unit 5 Fourth Way, Wembley, Middlesex, HA9 0LH                           info@wembleyinnovation.co.uk                                                                                                    Tel: 0208 903 4527",null,null,null,null,null,null,null,null,null,null,null,"Wi SYSTEM                                   DESIGN SOFTWARE",null,null,null,null,null,null,null,null,null,null,null,null,"Latest revision:","https://www.wembleyinnovation.co.uk/",null,null,null,null,{"$f":"URLExists(AE2)","v":true},"(CHECKS IF SITE IS ONLINE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Job No:",null,null,null,null,null,null,"http://wembleyinnovation.co.uk/wp-content/uploads/2023/09/Wi-System-design-spreadsheet-v1.8.xlsm",null,null,null,null,null,null,null,null,null,null,null,null,"Beam - summary of loads",null,null,null,null,null,null,null,"Column - summary of loads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision",null,null,null,null,null,null,{"$f":"URLExists(AD3)","v":true},"(CHECKS IF VERSION STILL CURRENT)",null,null,null,null,null,null,null,null,null,null,null,null,null,"load magnitude",null,null,null,null,null,null,null,"magnitude",null,null,null,null,null,"Beam - bending moment (unfactored)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prepared By:",null,null,null,null,null,"Page:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"start","stop","sum","top","bottom","left reaction",null,null,"start","stop","sum","left","right","bottom (taken as left) reaction","top (taken as right) reaction",null,"x=",0,{"$f":"$N$17/100","v":0.05},{"$f":"$N$17/100+BI5","v":0.1},{"$f":"$N$17/100+BJ5","v":0.15000000000000002},0.2,0.25,0.3,0.35,0.39999999999999997,0.44999999999999996,0.49999999999999994,0.54999999999999993,0.6,0.65,0.70000000000000007,0.75000000000000011,0.80000000000000016,0.8500000000000002,0.90000000000000024,0.95000000000000029,1.0000000000000002,1.0500000000000003,1.1000000000000003,1.1500000000000004,1.2000000000000004,1.2500000000000004,1.3000000000000005,1.3500000000000005,1.4000000000000006,1.4500000000000006,1.5000000000000007,1.5500000000000007,1.6000000000000008,1.6500000000000008,1.7000000000000008,1.7500000000000009,1.8000000000000009,1.850000000000001,1.900000000000001,1.9500000000000011,2.0000000000000009,2.0500000000000007,2.1000000000000005,2.1500000000000004,2.2000000000000002,2.25,2.2999999999999998,2.3499999999999996,2.3999999999999995,2.4499999999999993,2.4999999999999991,2.5499999999999989,2.5999999999999988,2.6499999999999986,2.6999999999999984,2.7499999999999982,2.799999999999998,2.8499999999999979,2.8999999999999977,2.9499999999999975,2.9999999999999973,3.0499999999999972,3.099999999999997,3.1499999999999968,3.1999999999999966,3.2499999999999964,3.2999999999999963,{"$f":"$N$17/100+DV5","v":3.3499999999999961},3.3999999999999959,3.4499999999999957,3.4999999999999956,3.5499999999999954,3.5999999999999952,3.649999999999995,3.6999999999999948,3.7499999999999947,3.7999999999999945,3.8499999999999943,3.8999999999999941,3.949999999999994,3.9999999999999938,4.0499999999999936,4.0999999999999934,4.1499999999999932,4.1999999999999931,4.2499999999999929,4.2999999999999927,4.3499999999999925,4.3999999999999924,4.4499999999999922,4.499999999999992,4.5499999999999918,4.5999999999999917,4.6499999999999915,4.6999999999999913,4.7499999999999911,4.7999999999999909,4.8499999999999908,4.8999999999999906,4.9499999999999904,4.9999999999999902]
[null,null,"Wall Ref.: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Checked By:",null,null,null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rectangular",0,{"$f":"N17","v":5},{"$f":"AQ20+AT6+AU6","v":9.0000000000000011E-2},{"$f":"IF(L14=AD19,0,IF($L$10=$AD$14,INDEX(AQ21:AS21,1,MATCH(L14,AD17:AD19,0)),INDEX(AT21:AV21,1,MATCH(L14,AD17:AD19,0))))","v":0},{"$f":"IF(L15=AD19,0,IF($L$10=$AD$14,INDEX(AQ22:AS22,1,MATCH(L15,AD17:AD19,0)),INDEX(AT22:AV22,1,MATCH(L15,AD17:AD19,0))))","v":0},{"$f":"AS6*$N$17/2","v":0.22500000000000003},null,"rectangular",0,{"$f":"N17","v":5},{"$f":"AY20+BB6+BC6","v":0.18000000000000002},{"$f":"IF(AND(L10=AD14,L14=AD19),0,IF($L$10=$AD$14,INDEX(AY21:BA21,1,MATCH(L14,AD17:AD19,0)),INDEX(BB21:BD21,1,MATCH(L14,AD17:AD19,0))))","v":0},{"$f":"IF(AND(L10=AD14,L15=AD19),0,IF($L$10=$AD$14,INDEX(AY22:BA22,1,MATCH(L15,AD17:AD19,0)),INDEX(BB22:BD22,1,MATCH(L15,AD17:AD19,0))))","v":0},{"$f":"BA6*$N$17/2","v":0.45000000000000007},{"$f":"BD6","v":0.45000000000000007},null,"rectangular",0,{"$f":"-$AV$6*BI5+$AS$6*BI5^2/2","v":-1.1137500000000003E-2},{"$f":"-$AV$6*BJ5+$AS$6*BJ5^2/2","v":-2.2050000000000007E-2},-3.273750000000001E-2,-4.3200000000000009E-2,-5.3437500000000006E-2,-6.3450000000000006E-2,-7.3237499999999997E-2,-8.2800000000000012E-2,-9.2137500000000011E-2,-0.10125000000000001,-0.1101375,-0.1188,-0.1272375,-0.13545000000000001,-0.14343750000000002,-0.15120000000000003,-0.15873750000000006,-0.16605000000000009,-0.17313750000000008,-0.18000000000000005,-0.18663750000000007,-0.19305000000000008,-0.19923750000000004,-0.20520000000000008,-0.21093750000000011,-0.21645000000000009,-0.22173750000000012,-0.22680000000000008,-0.23163750000000011,-0.2362500000000001,-0.24063750000000012,-0.24480000000000007,-0.24873750000000011,-0.25245000000000006,-0.25593750000000015,-0.2592000000000001,-0.26223750000000012,-0.26505000000000006,-0.26763750000000008,-0.27000000000000013,-0.27213750000000003,-0.27405000000000013,-0.27573750000000002,-0.27720000000000006,-0.27843750000000006,-0.27945000000000009,-0.28023750000000014,-0.28080000000000005,-0.28113750000000004,-0.28125000000000006,-0.2811375000000001,-0.28080000000000011,-0.28023750000000003,-0.27945000000000009,-0.27843750000000012,-0.27720000000000011,-0.27573750000000014,-0.27405000000000013,-0.27213750000000014,-0.27000000000000018,-0.26763750000000019,-0.26505000000000023,-0.26223750000000029,-0.25920000000000021,-0.25593750000000026,{"$f":"-$AV$6*DV5+$AS$6*DV5^2/2","v":-0.25245000000000029},-0.24873750000000039,-0.24480000000000046,-0.24063750000000028,-0.23625000000000052,-0.2316375000000005,-0.22680000000000056,-0.22173750000000059,-0.2164500000000007,-0.21093750000000056,-0.2052000000000006,-0.19923750000000073,-0.19305000000000083,-0.1866375000000009,-0.18000000000000083,-0.17313750000000094,-0.16605000000000103,-0.15873750000000109,-0.15120000000000122,-0.14343750000000111,-0.13545000000000118,-0.12723750000000122,-0.11880000000000135,-0.11013750000000144,-0.10125000000000151,-9.2137500000001649E-2,-8.2800000000001761E-2,-7.3237500000001621E-2,-6.3450000000001672E-2,-5.3437500000001803E-2,-4.3200000000001904E-2,-3.2737500000001862E-2,-2.2050000000001901E-2,-1.1137500000002243E-2,-2.4424906541753444E-15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIXED BY VBA",null,null,null,null,null,null,null,null,null,null,null,"triangle",0,{"$f":"N17","v":5},{"$f":"AT7+AU7","v":2},{"$f":"IF(L14=AD19,IF($L$10=$AD$14,INDEX(AQ21:AS21,1,MATCH(L14,AD17:AD19,0)),INDEX(AT21:AV21,1,MATCH(L14,AD17:AD19,0))),0)","v":1},{"$f":"IF(L15=AD19,IF($L$10=$AD$14,INDEX(AQ22:AS22,1,MATCH(L15,AD17:AD19,0)),INDEX(AT22:AV22,1,MATCH(L15,AD17:AD19,0))),0)","v":1},{"$f":"AS7*$N$17/4","v":2.5},"half of loaded length (for moment diagram cacls)","triangle",0,{"$f":"N17","v":5},{"$f":"BB7+BC7","v":2},{"$f":"IF(AND(L10=AD14,L14=AD19),IF($L$10=$AD$14,INDEX(AY21:BA21,1,MATCH(L14,AD17:AD19,0)),INDEX(BB21:BD21,1,MATCH(L14,AD17:AD19,0))),0)","v":1},{"$f":"IF(AND(L10=AD14,L15=AD19),IF($L$10=$AD$14,INDEX(AY22:BA22,1,MATCH(L15,AD17:AD19,0)),INDEX(BB22:BD22,1,MATCH(L15,AD17:AD19,0))),0)","v":1},{"$f":"BA7*$N$17/4","v":2.5},{"$f":"BD7","v":2.5},"half of loaded length (for moment diagram cacls)","triangle",0,{"$f":"-$AV$7*BI5+$AS$7*BI5^3/3/$AR$7","v":-0.12498333333333334},-0.24986666666666665,-0.37455000000000005,-0.49893333333333334,-0.62291666666666667,-0.74639999999999995,-0.8692833333333333,-0.99146666666666661,-1.1128499999999999,-1.2333333333333332,-1.3528166666666666,-1.4712000000000001,-1.5883833333333333,-1.7042666666666668,-1.8187500000000001,-1.9317333333333337,-2.0431166666666671,-2.1528000000000005,-2.260683333333334,-2.3666666666666671,-2.4706500000000009,-2.5725333333333342,-2.6722166666666674,-2.7696000000000005,-2.8645833333333339,-2.9570666666666678,-3.0469500000000012,-3.1341333333333341,-3.2185166666666678,-3.3000000000000012,-3.3784833333333344,-3.4538666666666678,-3.5260500000000006,-3.5949333333333344,-3.6604166666666673,-3.7224000000000013,-3.7807833333333347,-3.8354666666666679,-3.8863500000000011,-3.9333333333333336,-3.9763166666666674,-4.015200000000001,-4.0498833333333337,-4.0802666666666667,-4.1062500000000002,-4.1277333333333335,-4.1446166666666659,-4.1567999999999996,-4.1641833333333329,-4.166666666666667,{"$f":"DE7","v":-4.1641833333333329},{"$f":"DD7","v":-4.1567999999999996},{"$f":"DC7","v":-4.1446166666666659},{"$f":"DB7","v":-4.1277333333333335},{"$f":"DA7","v":-4.1062500000000002},{"$f":"CZ7","v":-4.0802666666666667},{"$f":"CY7","v":-4.0498833333333337},{"$f":"CX7","v":-4.015200000000001},{"$f":"CW7","v":-3.9763166666666674},{"$f":"CV7","v":-3.9333333333333336},{"$f":"CU7","v":-3.8863500000000011},{"$f":"CT7","v":-3.8354666666666679},{"$f":"CS7","v":-3.7807833333333347},{"$f":"CR7","v":-3.7224000000000013},{"$f":"CQ7","v":-3.6604166666666673},{"$f":"CP7","v":-3.5949333333333344},{"$f":"CO7","v":-3.5260500000000006},{"$f":"CN7","v":-3.4538666666666678},{"$f":"CM7","v":-3.3784833333333344},{"$f":"CL7","v":-3.3000000000000012},{"$f":"CK7","v":-3.2185166666666678},{"$f":"CJ7","v":-3.1341333333333341},{"$f":"CI7","v":-3.0469500000000012},{"$f":"CH7","v":-2.9570666666666678},{"$f":"CG7","v":-2.8645833333333339},{"$f":"CF7","v":-2.7696000000000005},{"$f":"CE7","v":-2.6722166666666674},{"$f":"CD7","v":-2.5725333333333342},{"$f":"CC7","v":-2.4706500000000009},{"$f":"CB7","v":-2.3666666666666671},{"$f":"CA7","v":-2.260683333333334},{"$f":"BZ7","v":-2.1528000000000005},{"$f":"BY7","v":-2.0431166666666671},{"$f":"BX7","v":-1.9317333333333337},{"$f":"BW7","v":-1.8187500000000001},{"$f":"BV7","v":-1.7042666666666668},{"$f":"BU7","v":-1.5883833333333333},{"$f":"BT7","v":-1.4712000000000001},{"$f":"BS7","v":-1.3528166666666666},{"$f":"BR7","v":-1.2333333333333332},{"$f":"BQ7","v":-1.1128499999999999},{"$f":"BP7","v":-0.99146666666666661},{"$f":"BO7","v":-0.8692833333333333},{"$f":"BN7","v":-0.74639999999999995},{"$f":"BM7","v":-0.62291666666666667},{"$f":"BL7","v":-0.49893333333333334},{"$f":"BK7","v":-0.37455000000000005},{"$f":"BJ7","v":-0.24986666666666665},{"$f":"BI7","v":-0.12498333333333334},{"$f":"BH7","v":0}]
[null,null,"GENERAL DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMMARY OF RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,"Element type:",null,"Element width:",null,null,null,null,null,null,null,null,null,"top negative triangle",{"$f":"IF(AH17=1,0,AD52/2)","v":0},{"$f":"IF(AH17=1,0,N17-AD52/2)","v":0},{"$f":"AT8","v":0},{"$f":"IF(L14=AD19,AS28,0)","v":0},null,{"$f":"AS8*(AR8-AQ8)/4","v":0},{"$f":"$N$17/2-AQ8","v":2.5},"left negative triangle",{"$f":"IF(AH17=1,0,AD52/2)","v":0},{"$f":"IF(AH17=1,0,N17-AD52/2)","v":0},{"$f":"BB8","v":0},{"$f":"IF(AND(L10=AD14,L14=AD19),BA28,0)","v":0},null,{"$f":"BA8*(AZ8-AY8)/4","v":0},{"$f":"BD8","v":0},{"$f":"$N$17/2-AY8","v":2.5},"left negative triangle",0,{"$f":"$AV$8*BI5-IF(BI5>$AQ$8,$AS$8/(6*$AW$8)*(BI5-$AQ$8)^3,0)","v":0},{"$f":"$AV$8*BJ5-IF(BJ5>$AQ$8,$AS$8/(6*$AW$8)*(BJ5-$AQ$8)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DE8","v":0},{"$f":"DD8","v":0},{"$f":"DC8","v":0},{"$f":"DB8","v":0},{"$f":"DA8","v":0},{"$f":"CZ8","v":0},{"$f":"CY8","v":0},{"$f":"CX8","v":0},{"$f":"CW8","v":0},{"$f":"CV8","v":0},{"$f":"CU8","v":0},{"$f":"CT8","v":0},{"$f":"CS8","v":0},{"$f":"CR8","v":0},{"$f":"CQ8","v":0},{"$f":"CP8","v":0},{"$f":"CO8","v":0},{"$f":"CN8","v":0},{"$f":"CM8","v":0},{"$f":"CL8","v":0},{"$f":"CK8","v":0},{"$f":"CJ8","v":0},{"$f":"CI8","v":0},{"$f":"CH8","v":0},{"$f":"CG8","v":0},{"$f":"CF8","v":0},{"$f":"CE8","v":0},{"$f":"CD8","v":0},{"$f":"CC8","v":0},{"$f":"CB8","v":0},{"$f":"CA8","v":0},{"$f":"BZ8","v":0},{"$f":"BY8","v":0},{"$f":"BX8","v":0},{"$f":"BW8","v":0},{"$f":"BV8","v":0},{"$f":"BU8","v":0},{"$f":"BT8","v":0},{"$f":"BS8","v":0},{"$f":"BR8","v":0},{"$f":"BQ8","v":0},{"$f":"BP8","v":0},{"$f":"BO8","v":0},{"$f":"BN8","v":0},{"$f":"BM8","v":0},{"$f":"BL8","v":0},{"$f":"BK8","v":0},{"$f":"BJ8","v":0},{"$f":"BI8","v":0},{"$f":"BH8","v":0}]
[null,null,null,null,null,null,null,"Element type: ",null,null,null,"Wi Column",null,null,null,null,{"$f":"$L$9&\" utilisation ratio =\"","v":"Wi Column utilisation ratio ="},null,null,null,null,null,null,null,null,{"$f":"IF($Z$27=\"ERROR\",$Z$27,$Z$26/$Z$27)","v":0.39409722222222221},null,null,null,"Wi Beam",null,"Single",null,null,null,null,null,null,{"$f":"\"Unfactored moment: load on \"&IF(L9=AD9,\"beam\",\"column\")","v":"Unfactored moment: load on column"},{"$f":"IF($L$10=$AD$14,AI30,AL30)","v":0.5625},null,"bottom negative triangle",{"$f":"IF(AH18=1,0,AD53/2)","v":0},{"$f":"IF(AH18=1,0,N17-AD53/2)","v":0},{"$f":"AU9","v":0},null,{"$f":"IF(L15=AD19,AS29,0)","v":0},{"$f":"AS9*(AR9-AQ9)/4","v":0},{"$f":"$N$17/2-AQ9","v":2.5},"right negative triangle",{"$f":"IF(AH18=1,0,AD53/2)","v":0},{"$f":"IF(AH18=1,0,N17-AD53/2)","v":0},{"$f":"BC9","v":0},null,{"$f":"IF(AND(L10=AD14,L15=AD19),BA29,0)","v":0},{"$f":"BA9*(AZ9-AY9)/4","v":0},{"$f":"BD9","v":0},{"$f":"$N$17/2-AY9","v":2.5},"right negative triangle",0,{"$f":"$AV$9*BI5-IF(BI5>$AQ$9,$AS$9/(6*$AW$9)*(BI5-$AQ$9)^3,0)","v":0},{"$f":"$AV$9*BJ5-IF(BJ5>$AQ$9,$AS$9/(6*$AW$9)*(BJ5-$AQ$9)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DE9","v":0},{"$f":"DD9","v":0},{"$f":"DC9","v":0},{"$f":"DB9","v":0},{"$f":"DA9","v":0},{"$f":"CZ9","v":0},{"$f":"CY9","v":0},{"$f":"CX9","v":0},{"$f":"CW9","v":0},{"$f":"CV9","v":0},{"$f":"CU9","v":0},{"$f":"CT9","v":0},{"$f":"CS9","v":0},{"$f":"CR9","v":0},{"$f":"CQ9","v":0},{"$f":"CP9","v":0},{"$f":"CO9","v":0},{"$f":"CN9","v":0},{"$f":"CM9","v":0},{"$f":"CL9","v":0},{"$f":"CK9","v":0},{"$f":"CJ9","v":0},{"$f":"CI9","v":0},{"$f":"CH9","v":0},{"$f":"CG9","v":0},{"$f":"CF9","v":0},{"$f":"CE9","v":0},{"$f":"CD9","v":0},{"$f":"CC9","v":0},{"$f":"CB9","v":0},{"$f":"CA9","v":0},{"$f":"BZ9","v":0},{"$f":"BY9","v":0},{"$f":"BX9","v":0},{"$f":"BW9","v":0},{"$f":"BV9","v":0},{"$f":"BU9","v":0},{"$f":"BT9","v":0},{"$f":"BS9","v":0},{"$f":"BR9","v":0},{"$f":"BQ9","v":0},{"$f":"BP9","v":0},{"$f":"BO9","v":0},{"$f":"BN9","v":0},{"$f":"BM9","v":0},{"$f":"BL9","v":0},{"$f":"BK9","v":0},{"$f":"BJ9","v":0},{"$f":"BI9","v":0},{"$f":"BH9","v":0}]
[null,null,"Design approach:",null,null,null,null,null,null,null,null,"Standard",null,null,null,null,{"$f":"Q28","v":"...ADOPT: 140mm thk Wembley Innovation Wi Column"},null,null,null,null,null,null,null,null,null,null,null,null,"Wi Column",null,"Doubled",null,null,null,null,null,null,{"$f":"\"Unfactored moment: load on \"&IF(L9=AD9,\"upper\",\"left\")&\" panel\"","v":"Unfactored moment: load on left panel"},{"$f":"IF($L$10=$AD$14,INDEX(AI31:AK31,1,MATCH(L14,AD17:AD19,0)),INDEX(AL31:AN31,1,MATCH(L14,AD17:AD19,0)))","v":2.0833333333333335},null,"barrier PUDL",0,{"$f":"N17","v":5},{"$f":"AT10+AU10","v":0},{"$f":"AS35","v":0},{"$f":"AS36","v":0},{"$f":"AS10*$N$17/2","v":0},null,"barrier PUDL",0,{"$f":"N25","v":0},{"$f":"AY36+BB10+BC10","v":0},{"$f":"IF($L$10=$AD$14,INDEX(AY37:BA37,1,MATCH(L14,AD17:AD19,0)),INDEX(BB37:BD37,1,MATCH(L14,AD17:AD19,0)))","v":0},{"$f":"IF($L$10=$AD$14,INDEX(AY38:BA38,1,MATCH(L15,AD17:AD19,0)),INDEX(BB38:BD38,1,MATCH(L15,AD17:AD19,0)))","v":0},{"$f":"0.5*AZ10*BA10-1/3*AZ10^2*BA10/N17","v":0},{"$f":"1/3*AZ10^2*BA10/N17","v":0},null,"barrier PUDL",0,{"$f":"-$AV$10*BI5+$AS$10*BI5^2/2","v":0},{"$f":"-$AV$10*BJ5+$AS$10*BJ5^2/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-$AV$10*DG5+$AS$10*DG5^2/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C20<>\" \",\" \",IF(AND(L9=AD9,L10=AD13),\"Conservative design approach for Wi Beams is the same as Standard.\",IF(L9=AD10,IF(AND(Z26>AE22,C20=\" \"),\" \",IF(AND(C20=\" \",MATCH(Z26,AE22:AE25,-1)<$AG$13),\"NOTE: Required Wi Column is wider than wall thickness.\",\" \")),IF(AND(Z26>AE26,C20=\" \"),\" \",IF(AND(C20=\" \",MATCH(Z26,AE26:AE29,-1)<$AG$13),\"NOTE: Required Wi Beam is wider than wall thickness.\",\" \")))))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L13=AF9,1,2)","v":1},null,null,null,null,null,null,{"$f":"\"Unfactored moment: load on \"&IF(L9=AD9,\"lower\",\"right\")&\" panel\"","v":"Unfactored moment: load on right panel"},{"$f":"IF($L$10=$AD$14,INDEX(AI32:AK32,1,MATCH(L15,AD17:AD19,0)),INDEX(AL32:AN32,1,MATCH(L15,AD17:AD19,0)))","v":2.0833333333333335},null,"barrier line load",0,{"$f":"N17","v":5},{"$f":"AT11+AU11","v":0},{"$f":"AS42","v":0},{"$f":"AS43","v":0},{"$f":"AS11*$N$17/2","v":0},null,"barrier line load",{"$f":"N25","v":0},null,{"$f":"AY45+BB11+BC11","v":0},{"$f":"IF($L$10=$AD$14,INDEX(AY46:BA46,1,MATCH(L14,AD17:AD19,0)),INDEX(BB46:BD46,1,MATCH(L14,AD17:AD19,0)))","v":0},{"$f":"IF($L$10=$AD$14,INDEX(AY47:BA47,1,MATCH(L15,AD17:AD19,0)),INDEX(BB47:BD47,1,MATCH(L15,AD17:AD19,0)))","v":0},{"$f":"BA11*($N$17-AY11)/$N$17","v":0},{"$f":"BA11-BD11","v":0},null,"barrier line load",0,{"$f":"-$AV$11*BI5+$AS$11*BI5^2/2","v":0},{"$f":"-$AV$11*BJ5+$AS$11*BJ5^2/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-$AV$11*DG5+$AS$11*DG5^2/2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"ELEMENT ARRANGEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"DESIGNER'S NOTES",null,null,null,null,null,null,null,null,null,null,null,null,"Design approach:",null,100,"reverse selected:",null,"SUPERSEDED: MAX BENDING MOMENT VALUES",null,null,null,null,null,null,null,null,null,null,null,"sum:",{"$f":"AV6+AV7-AV8-AV9+AV10+AV11","v":2.7250000000000001},null,null,null,null,null,null,"sum:",{"$f":"BD6+BD7-BD8-BD9+BD10+BD11","v":2.95},{"$f":"BE6+BE7-BE8-BE9+BE10+BE11","v":2.95},null,"sum",{"$f":"SUM(BH6:BH11)","v":0},{"$f":"SUM(BI6:BI11)","v":-0.13612083333333333},-0.27191666666666664,-0.40728750000000008,-0.54213333333333336,-0.6763541666666667,-0.80984999999999996,-0.94252083333333325,-1.0742666666666667,-1.2049874999999999,-1.3345833333333332,-1.4629541666666666,-1.59,-1.7156208333333334,-1.8397166666666669,-1.9621875000000002,-2.082933333333334,-2.2018541666666671,-2.3188500000000007,-2.4338208333333342,-2.5466666666666673,-2.6572875000000011,-2.7655833333333342,-2.8714541666666675,-2.9748000000000006,-3.0755208333333339,-3.1735166666666679,-3.2686875000000013,-3.360933333333334,-3.450154166666668,-3.5362500000000012,-3.6191208333333345,-3.6986666666666679,-3.7747875000000009,-3.8473833333333345,-3.9163541666666672,-3.9816000000000011,-4.0430208333333351,-4.1005166666666684,-4.1539875000000013,-4.203333333333334,-4.2484541666666678,-4.2892500000000009,-4.3256208333333337,-4.3574666666666664,-4.3846875000000001,-4.4071833333333332,-4.4248541666666661,-4.4375999999999998,-4.4453208333333327,-4.447916666666667,{"$f":"SUM(DG6:DG11)","v":-4.4453208333333327},-4.4375999999999998,-4.4248541666666661,-4.4071833333333332,-4.3846875000000001,-4.3574666666666673,-4.3256208333333337,-4.2892500000000009,-4.2484541666666678,-4.203333333333334,-4.1539875000000013,-4.1005166666666684,-4.0430208333333351,-3.9816000000000016,-3.9163541666666677,-3.8473833333333349,-3.7747875000000009,-3.6986666666666683,-3.6191208333333345,-3.5362500000000017,-3.4501541666666684,-3.3609333333333344,-3.2686875000000017,-3.1735166666666688,-3.0755208333333344,-2.974800000000001,-2.871454166666668,-2.7655833333333351,-2.6572875000000016,-2.5466666666666677,-2.4338208333333351,-2.3188500000000016,-2.201854166666668,-2.0829333333333349,-1.9621875000000011,-1.839716666666668,-1.7156208333333345,-1.5900000000000014,-1.4629541666666679,-1.3345833333333346,-1.2049875000000014,-1.0742666666666683,-0.94252083333333492,-0.80985000000000162,-0.67635416666666848,-0.54213333333333524,-0.40728750000000191,-0.27191666666666858,-0.13612083333333558,-2.4424906541753444E-15]
[null,null,{"$f":"IF(L9=AD9,\"Wi Beam height:\",\"Wi Column width:\")","v":"Wi Column width:"},null,null,null,null,null,null,null,null,"Single",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conservative",null,140,{"$f":"IF(N16=AF12,4,IF(N16=AF13,3,IF(N16=AF14,2,IF(N16=AF15,1,1))))","v":3},null,"Column design",null,null,"MAX BENDING MOMENT",null,null,null,null,"Load heights",null,null,"Beam - triangular/rectangular",null,null,null,null,"Load widths",null,null,"Column - triangular/rectangular",null,null,null,null,"max",{"$f":"MIN(BH12:FD12)","v":-4.447916666666667}]
[null,null,{"$f":"IF(L9=AD9,\"Upper section construction type:\",\"Left side construction type:\")","v":"Left side construction type:"},null,null,null,null,null,null,null,null,"Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard",null,190,null,null,{"$f":"$AD$14","v":"Standard"},null,null,{"$f":"$AD$13","v":"Conservative"},null,null,null,null,{"$f":"$AD$14","v":"Standard"},null,null,{"$f":"$AD$13","v":"Conservative"},null,null,null,null,{"$f":"$AD$14","v":"Standard"},null,null,{"$f":"$AD$13","v":"Conservative"},null,null,null,null,"location",{"$f":"MATCH(BH13,BH12:FD12,0)","v":51}]
[null,null,{"$f":"IF(L9=AD9,\"Lower section construction type:\",\"Right side construction type:\")","v":"Right side construction type:"},null,null,null,null,null,null,null,null,"Standard",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,215,null,"w/2 >=H/2",{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},null,null,{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},null,null,{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"}]
[null,null,"Wall thickness 't'  [mm] =",null,null,null,null,null,null,null,null,null,null,140,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Side construction type:",null,null,"Mcol",null,{"$f":"0.45*N17^2*N22/8","v":0.5625},null,null,{"$f":"AI16","v":0.5625},null,null,null,"beam",{"$f":"IF(L13=AF9,AU16,2*AU16)","v":0.22500000000000001},null,null,"single beam height:",0.22500000000000001,null,null,"column",{"$f":"IF(L13=AF9,BC16,2*BC16)","v":0.45},null,null,"single column width:",0.45,null,null,null,"Column - bending moment (unfactored)"]
[null,null,{"$f":"IF(L9=AD9,\"Panel length 'L'\",\"Panel height 'H'\")","v":"Panel height 'H'"},null,null,null,null,null,null,null,null,"[m] =",null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free edge",null,null,"Mleft",{"$f":"IF(AD52/2>=N17/2,1,0)","v":1},0,{"$f":"N17^2*N22*AD52/2/8","v":3.75},{"$f":"IF(AH17=1,N17^2/4*N22*N17/6,N17^2/4*N22*N17/6-((N17-AD52)^2)*N22/16*(N17-(N17-AD52)/3))","v":2.0833333333333335},0,{"$f":"AJ17","v":3.75},{"$f":"IF(AH17=1,N17^2*N22*N17/2/8,N17^2*N22*AD52/2/8)","v":3.125},null,"top",0,{"$f":"AD52/2","v":3},{"$f":"N17/2","v":2.5},0,{"$f":"AR17","v":3},{"$f":"AS17","v":2.5},null,"left",0,{"$f":"AD52/2","v":3},{"$f":"N17/2","v":2.5},0,{"$f":"AZ17","v":3},{"$f":"AZ17","v":3},null,null,"x=",0,{"$f":"$N$17/100","v":0.05},{"$f":"$N$17/100+BI17","v":0.1},{"$f":"$N$17/100+BJ17","v":0.15000000000000002},0.2,0.25,0.3,0.35,0.39999999999999997,0.44999999999999996,0.49999999999999994,0.54999999999999993,0.6,0.65,0.70000000000000007,0.75000000000000011,0.80000000000000016,0.8500000000000002,0.90000000000000024,0.95000000000000029,1.0000000000000002,1.0500000000000003,1.1000000000000003,1.1500000000000004,1.2000000000000004,1.2500000000000004,1.3000000000000005,1.3500000000000005,1.4000000000000006,1.4500000000000006,1.5000000000000007,1.5500000000000007,1.6000000000000008,1.6500000000000008,1.7000000000000008,1.7500000000000009,1.8000000000000009,1.850000000000001,1.900000000000001,1.9500000000000011,2.0000000000000009,2.0500000000000007,2.1000000000000005,2.1500000000000004,2.2000000000000002,2.25,2.2999999999999998,2.3499999999999996,2.3999999999999995,2.4499999999999993,2.4999999999999991,2.5499999999999989,2.5999999999999988,2.6499999999999986,2.6999999999999984,2.7499999999999982,2.799999999999998,2.8499999999999979,2.8999999999999977,2.9499999999999975,2.9999999999999973,3.0499999999999972,3.099999999999997,3.1499999999999968,3.1999999999999966,3.2499999999999964,3.2999999999999963,{"$f":"$N$17/100+DV17","v":3.3499999999999961},3.3999999999999959,3.4499999999999957,3.4999999999999956,3.5499999999999954,3.5999999999999952,3.649999999999995,3.6999999999999948,3.7499999999999947,3.7999999999999945,3.8499999999999943,3.8999999999999941,3.949999999999994,3.9999999999999938,4.0499999999999936,4.0999999999999934,4.1499999999999932,4.1999999999999931,4.2499999999999929,4.2999999999999927,4.3499999999999925,4.3999999999999924,4.4499999999999922,4.499999999999992,4.5499999999999918,4.5999999999999917,4.6499999999999915,4.6999999999999913,4.7499999999999911,4.7999999999999909,4.8499999999999908,4.8999999999999906,4.9499999999999904,4.9999999999999902]
[null,null,{"$f":"IF(L9=AD9,\"Distance to top support's face\",\"Distance to left column's face\")","v":"Distance to left column's face"},null,null,null,null,null,null,null,"'w1' [m] =",null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free edge load",null,null,"Mright",{"$f":"IF(AD53/2>=N17/2,1,0)","v":1},0,{"$f":"N17^2*N22*AD53/2/8","v":3.75},{"$f":"IF(AH18=1,N17^2/4*N22*N17/6,N17^2/4*N22*N17/6-((N17-AD53)^2)*N22/16*(N17-(N17-AD53)/3))","v":2.0833333333333335},0,{"$f":"AJ18","v":3.75},{"$f":"IF(AH18=1,AN17,N17^2*N22*AD53/2/8)","v":3.125},null,"bottom",0,{"$f":"AD53/2","v":3},{"$f":"N17/2","v":2.5},0,{"$f":"AR18","v":3},{"$f":"AS18","v":2.5},null,"right",0,{"$f":"AD53/2","v":3},{"$f":"N17/2","v":2.5},0,{"$f":"AZ18","v":3},{"$f":"AZ18","v":3},null,null,"rectangular",0,{"$f":"-$BD$6*BI17+$BA$6*BI17^2/2","v":-2.2275000000000007E-2},{"$f":"-$BD$6*BJ17+$BA$6*BJ17^2/2","v":-4.4100000000000014E-2},-6.5475000000000019E-2,-8.6400000000000018E-2,-0.10687500000000001,-0.12690000000000001,-0.14647499999999999,-0.16560000000000002,-0.18427500000000002,-0.20250000000000001,-0.220275,-0.23760000000000001,-0.25447500000000001,-0.27090000000000003,-0.28687500000000005,-0.30240000000000006,-0.31747500000000012,-0.33210000000000017,-0.34627500000000017,-0.3600000000000001,-0.37327500000000013,-0.38610000000000017,-0.39847500000000008,-0.41040000000000015,-0.42187500000000022,-0.43290000000000017,-0.44347500000000023,-0.45360000000000017,-0.46327500000000021,-0.4725000000000002,-0.48127500000000023,-0.48960000000000015,-0.49747500000000022,-0.50490000000000013,-0.5118750000000003,-0.51840000000000019,-0.52447500000000025,-0.53010000000000013,-0.53527500000000017,-0.54000000000000026,-0.54427500000000006,-0.54810000000000025,-0.55147500000000005,-0.55440000000000011,-0.55687500000000012,-0.55890000000000017,-0.56047500000000028,-0.5616000000000001,-0.56227500000000008,-0.56250000000000011,-0.56227500000000019,-0.56160000000000021,-0.56047500000000006,-0.55890000000000017,-0.55687500000000023,-0.55440000000000023,-0.55147500000000027,-0.54810000000000025,-0.54427500000000029,-0.54000000000000037,-0.53527500000000039,-0.53010000000000046,-0.52447500000000058,-0.51840000000000042,-0.51187500000000052,{"$f":"-$BD$6*DV17+$BA$6*DV17^2/2","v":-0.50490000000000057},-0.49747500000000078,-0.48960000000000092,-0.48127500000000056,-0.47250000000000103,-0.46327500000000099,-0.45360000000000111,-0.44347500000000117,-0.43290000000000139,-0.42187500000000111,-0.41040000000000121,-0.39847500000000147,-0.38610000000000166,-0.3732750000000018,-0.36000000000000165,-0.34627500000000189,-0.33210000000000206,-0.31747500000000217,-0.30240000000000244,-0.28687500000000221,-0.27090000000000236,-0.25447500000000245,-0.2376000000000027,-0.22027500000000289,-0.20250000000000301,-0.1842750000000033,-0.16560000000000352,-0.14647500000000324,-0.12690000000000334,-0.10687500000000361,-8.6400000000003807E-2,-6.5475000000003725E-2,-4.4100000000003803E-2,-2.2275000000004486E-2,-4.8849813083506888E-15]
[null,null,{"$f":"IF(L9=AD9,\"Distance to bottom support's face\",\"Distance to right column's face\")","v":"Distance to right column's face"},null,null,null,null,null,null,null,"'w2' [m] =",null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard",null,null,null,null,null,null,null,null,null,null,null,null,"Applied loads",null,null,null,null,null,null,null,"Applied loads",null,null,null,null,null,null,null,"triangle",0,{"$f":"-$BD$7*BI17+$BA$7*BI17^3/3/$AZ$7","v":-0.12498333333333334},{"$f":"-$BD$7*BJ17+$BA$7*BJ17^3/3/$AZ$7","v":-0.24986666666666665},-0.37455000000000005,-0.49893333333333334,-0.62291666666666667,-0.74639999999999995,-0.8692833333333333,-0.99146666666666661,-1.1128499999999999,-1.2333333333333332,-1.3528166666666666,-1.4712000000000001,-1.5883833333333333,-1.7042666666666668,-1.8187500000000001,-1.9317333333333337,-2.0431166666666671,-2.1528000000000005,-2.260683333333334,-2.3666666666666671,-2.4706500000000009,-2.5725333333333342,-2.6722166666666674,-2.7696000000000005,-2.8645833333333339,-2.9570666666666678,-3.0469500000000012,-3.1341333333333341,-3.2185166666666678,-3.3000000000000012,-3.3784833333333344,-3.4538666666666678,-3.5260500000000006,-3.5949333333333344,-3.6604166666666673,-3.7224000000000013,-3.7807833333333347,-3.8354666666666679,-3.8863500000000011,-3.9333333333333336,-3.9763166666666674,-4.015200000000001,-4.0498833333333337,-4.0802666666666667,-4.1062500000000002,-4.1277333333333335,-4.1446166666666659,-4.1567999999999996,-4.1641833333333329,-4.166666666666667,{"$f":"DE19","v":-4.1641833333333329},{"$f":"DD19","v":-4.1567999999999996},{"$f":"DC19","v":-4.1446166666666659},{"$f":"DB19","v":-4.1277333333333335},{"$f":"DA19","v":-4.1062500000000002},{"$f":"CZ19","v":-4.0802666666666667},{"$f":"CY19","v":-4.0498833333333337},{"$f":"CX19","v":-4.015200000000001},{"$f":"CW19","v":-3.9763166666666674},{"$f":"CV19","v":-3.9333333333333336},{"$f":"CU19","v":-3.8863500000000011},{"$f":"CT19","v":-3.8354666666666679},{"$f":"CS19","v":-3.7807833333333347},{"$f":"CR19","v":-3.7224000000000013},{"$f":"CQ19","v":-3.6604166666666673},{"$f":"CP19","v":-3.5949333333333344},{"$f":"CO19","v":-3.5260500000000006},{"$f":"CN19","v":-3.4538666666666678},{"$f":"CM19","v":-3.3784833333333344},{"$f":"CL19","v":-3.3000000000000012},{"$f":"CK19","v":-3.2185166666666678},{"$f":"CJ19","v":-3.1341333333333341},{"$f":"CI19","v":-3.0469500000000012},{"$f":"CH19","v":-2.9570666666666678},{"$f":"CG19","v":-2.8645833333333339},{"$f":"CF19","v":-2.7696000000000005},{"$f":"CE19","v":-2.6722166666666674},{"$f":"CD19","v":-2.5725333333333342},{"$f":"CC19","v":-2.4706500000000009},{"$f":"CB19","v":-2.3666666666666671},{"$f":"CA19","v":-2.260683333333334},{"$f":"BZ19","v":-2.1528000000000005},{"$f":"BY19","v":-2.0431166666666671},{"$f":"BX19","v":-1.9317333333333337},{"$f":"BW19","v":-1.8187500000000001},{"$f":"BV19","v":-1.7042666666666668},{"$f":"BU19","v":-1.5883833333333333},{"$f":"BT19","v":-1.4712000000000001},{"$f":"BS19","v":-1.3528166666666666},{"$f":"BR19","v":-1.2333333333333332},{"$f":"BQ19","v":-1.1128499999999999},{"$f":"BP19","v":-0.99146666666666661},{"$f":"BO19","v":-0.8692833333333333},{"$f":"BN19","v":-0.74639999999999995},{"$f":"BM19","v":-0.62291666666666667},{"$f":"BL19","v":-0.49893333333333334},{"$f":"BK19","v":-0.37455000000000005},{"$f":"BJ19","v":-0.24986666666666665},{"$f":"BI19","v":-0.12498333333333334},{"$f":"BH19","v":0}]
[null,null,{"$f":"IF(AND(L9=AD9,L14<>AD19,L15<>AD19),\"Construction for at least one section must be 'Standard'.\",IF(AND(L9=AD9,N25>AD52+AD53+AQ16),\"Barrier height cannot be more than total wall height.\",IF(AND(L9=AD9,L15=AD18),\"Free edge load for the lower section is not supported.\",IF(AND(L9=AD9,N16=215),\" \",IF(AND(L9=AD10,N16>100,N17>7),\"Wi Column height cannot be more than 7m.\",IF(AND(L9=AD10,N16=100,N17>5),\"100mm Wi Column height cannot be more than 5m.\",IF(AND(L9=AD9,N16>100,N17>12),\"Wi Beam length cannot be more than 12m.\",IF(AND(L9=AD9,N16=100,N17>7.5),\"100mm Wi Beam length cannot be more than 7.5m\",\" \"))))))))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beam design",null,null,"MAX BENDING MOMENT",null,null,null,"beam",{"$f":"AQ16*$N$22","v":9.0000000000000011E-2},null,null,null,null,null,null,"column",{"$f":"AY16*$N$22","v":0.18000000000000002},null,null,null,null,null,null,null,"left negative triangle",0,{"$f":"$BD$8*BI17-IF(BI17>$AY$8,$BA$8/(6*$BF$8)*(BI17-$AY$8)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$BD$8*CO17-IF(CO17>$AY$8,$BA$8/(6*$BF$8)*(CO17-$AY$8)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DE20","v":0},{"$f":"DD20","v":0},{"$f":"DC20","v":0},{"$f":"DB20","v":0},{"$f":"DA20","v":0},{"$f":"CZ20","v":0},{"$f":"CY20","v":0},{"$f":"CX20","v":0},{"$f":"CW20","v":0},{"$f":"CV20","v":0},{"$f":"CU20","v":0},{"$f":"CT20","v":0},{"$f":"CS20","v":0},{"$f":"CR20","v":0},{"$f":"CQ20","v":0},{"$f":"CP20","v":0},{"$f":"CO20","v":0},{"$f":"CN20","v":0},{"$f":"CM20","v":0},{"$f":"CL20","v":0},{"$f":"CK20","v":0},{"$f":"CJ20","v":0},{"$f":"CI20","v":0},{"$f":"CH20","v":0},{"$f":"CG20","v":0},{"$f":"CF20","v":0},{"$f":"CE20","v":0},{"$f":"CD20","v":0},{"$f":"CC20","v":0},{"$f":"CB20","v":0},{"$f":"CA20","v":0},{"$f":"BZ20","v":0},{"$f":"BY20","v":0},{"$f":"BX20","v":0},{"$f":"BW20","v":0},{"$f":"BV20","v":0},{"$f":"BU20","v":0},{"$f":"BT20","v":0},{"$f":"BS20","v":0},{"$f":"BR20","v":0},{"$f":"BQ20","v":0},{"$f":"BP20","v":0},{"$f":"BO20","v":0},{"$f":"BN20","v":0},{"$f":"BM20","v":0},{"$f":"BL20","v":0},{"$f":"BK20","v":0},{"$f":"BJ20","v":0},{"$f":"BI20","v":0},{"$f":"BH20","v":0}]
[null,null,"UNFACTORED LOADING",null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATIONS",null,null,null,null,null,null,null,null,null,null,null,null,"Element types (red WiC, blue WiB):",null,"single values",null,null,{"$f":"$AD$14","v":"Standard"},null,null,{"$f":"$AD$13","v":"Conservative"},null,null,null,"top",0,{"$f":"AR17*$N$22","v":1.2000000000000002},{"$f":"AS17*$N$22","v":1},0,{"$f":"AU17*$N$22","v":1.2000000000000002},{"$f":"AS21","v":1},null,"left",0,{"$f":"AZ17*$N$22","v":1.2000000000000002},1,0,1.2000000000000002,1.2000000000000002,null,null,"right negative triangle",0,{"$f":"$BD$9*BI17-IF(BI17>$AY$9,$BA$9/(6*$BF$9)*(BI17-$AY$9)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$BD$9*CO17-IF(CO17>$AY$9,$BA$9/(6*$BF$9)*(CO17-$AY$9)^3,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"DE21","v":0},{"$f":"DD21","v":0},{"$f":"DC21","v":0},{"$f":"DB21","v":0},{"$f":"DA21","v":0},{"$f":"CZ21","v":0},{"$f":"CY21","v":0},{"$f":"CX21","v":0},{"$f":"CW21","v":0},{"$f":"CV21","v":0},{"$f":"CU21","v":0},{"$f":"CT21","v":0},{"$f":"CS21","v":0},{"$f":"CR21","v":0},{"$f":"CQ21","v":0},{"$f":"CP21","v":0},{"$f":"CO21","v":0},{"$f":"CN21","v":0},{"$f":"CM21","v":0},{"$f":"CL21","v":0},{"$f":"CK21","v":0},{"$f":"CJ21","v":0},{"$f":"CI21","v":0},{"$f":"CH21","v":0},{"$f":"CG21","v":0},{"$f":"CF21","v":0},{"$f":"CE21","v":0},{"$f":"CD21","v":0},{"$f":"CC21","v":0},{"$f":"CB21","v":0},{"$f":"CA21","v":0},{"$f":"BZ21","v":0},{"$f":"BY21","v":0},{"$f":"BX21","v":0},{"$f":"BW21","v":0},{"$f":"BV21","v":0},{"$f":"BU21","v":0},{"$f":"BT21","v":0},{"$f":"BS21","v":0},{"$f":"BR21","v":0},{"$f":"BQ21","v":0},{"$f":"BP21","v":0},{"$f":"BO21","v":0},{"$f":"BN21","v":0},{"$f":"BM21","v":0},{"$f":"BL21","v":0},{"$f":"BK21","v":0},{"$f":"BJ21","v":0},{"$f":"BI21","v":0},{"$f":"BH21","v":0}]
[null,null,"Lateral wind load 'Wk' [kN/m2] =",null,null,null,null,null,null,null,null,null,null,0.4,null,null,{"$f":"IF($L$9=$AD$9,\"Unfactored reaction left / right 'R'\",\"Unfactored reaction btm / top 'R'\")","v":"Unfactored reaction btm / top 'R'"},null,null,null,null,null,null,"[kN] =",{"$f":"IF($L$9=$AD$9,FIXED(AV12,2)&\" / \"&FIXED(AV12,2),FIXED(BD12,2)&\" / \"&FIXED(BE12,2))","v":"2.95 / 2.95"},null,null,null,null,"215mm thk Wembley Innovation Wi Column",{"$f":"$AF$11*AF22","v":30},{"$f":"FIXED(30*2/$N$28,2)","v":"30.00"},null,null,{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},null,"bottom",0,{"$f":"AR18*$N$22","v":1.2000000000000002},{"$f":"AS18*$N$22","v":1},0,{"$f":"AU18*$N$22","v":1.2000000000000002},{"$f":"AS22","v":1},null,"right",0,1.2000000000000002,1,0,1.2000000000000002,1.2000000000000002,null,null,"barrier PUDL",0,{"$f":"IF(BI17<=$AZ$10,-$BD$10*BI17+1/6*$BA$10*BI17^3/$AZ$10,-$BD$10*BI17+1/2*$AZ$10*$BA$10*(BI17-2/3*$AZ$10))","v":0},{"$f":"IF(BJ17<=$AZ$10,-$BD$10*BJ17+1/6*$BA$10*BJ17^3/$AZ$10,-$BD$10*BJ17+1/2*$AZ$10*$BA$10*(BJ17-2/3*$AZ$10))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(DV17<=$AZ$10,-$BD$10*DV17+1/6*$BA$10*DV17^3/$AZ$10,-$BD$10*DV17+1/2*$AZ$10*$BA$10*(DV17-2/3*$AZ$10))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Barrier distributed load 'Wb_UDL' [kN/m2] =",null,null,null,null,null,null,null,null,null,null,0,null,null,"Unfactored moment: wind load [kNm] =",null,null,null,null,null,null,null,null,{"$f":"IF(L9=AD9,ABS(INDEX(BH6:FD11,1,BH14)+INDEX(BH6:FD11,2,BH14)+INDEX(BH6:FD11,3,BH14)+INDEX(BH6:FD11,4,BH14)),ABS(INDEX(BH18:FD23,1,BH26)+INDEX(BH18:FD23,2,BH26)+INDEX(BH18:FD23,3,BH26)+INDEX(BH18:FD23,4,BH26)))","v":4.729166666666667},null,null,null,"190mm thk Wembley Innovation Wi Column",{"$f":"$AF$11*AF23","v":26},{"$f":"FIXED(26*2/$N$28,2)","v":"26.00"},"Mbeam",null,{"$f":"0.225*N17^2*N22/8","v":0.28125},null,null,{"$f":"AI23","v":0.28125},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"barrier line load",0,{"$f":"-$BD$11*BI17+IF(BI17>$AY$11,$BA$11*(BI17-$AY$11),0)","v":0},{"$f":"-$BD$11*BJ17+IF(BJ17>$AY$11,$BA$11*(BJ17-$AY$11),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-$BD$11*DG17+IF(DG17>$AY$11,$BA$11*(DG17-$AY$11),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Barrier line load 'Wb_line' [kN/m] =",null,null,null,null,null,null,null,null,null,null,0,null,null,"Unfactored moment: barrier distributed [kNm] =",null,null,null,null,null,null,null,null,{"$f":"IF(L9=AD9,ABS(INDEX(BH6:FD11,5,BH14)),ABS(INDEX(BH18:FD23,5,BH26)))","v":0},null,null,null,"140mm thk Wembley Innovation Wi Column",18,{"$f":"FIXED(18*2/$N$28,2)","v":"18.00"},"Mupper",{"$f":"AH17","v":1},0,0,{"$f":"AK17","v":2.0833333333333335},0,0,{"$f":"AK24","v":2.0833333333333335},null,null,"Load heights",null,null,"Beam - small triangle",null,null,null,null,"Load widths",null,null,"Column - small triangle",null,null,null,null,"sum",{"$f":"SUM(BH18:BH23)","v":0},{"$f":"SUM(BI18:BI23)","v":-0.14725833333333335},{"$f":"SUM(BJ18:BJ23)","v":-0.29396666666666665},-0.44002500000000005,-0.58533333333333337,-0.72979166666666673,-0.87329999999999997,-1.0157583333333333,-1.1570666666666667,-1.2971249999999999,-1.4358333333333331,-1.5730916666666666,-1.7088000000000001,-1.8428583333333333,-1.975166666666667,-2.1056250000000003,-2.2341333333333337,-2.3605916666666671,-2.4849000000000006,-2.6069583333333344,-2.7266666666666675,-2.8439250000000009,-2.9586333333333346,-3.0706916666666673,-3.1800000000000006,-3.2864583333333339,-3.3899666666666679,-3.4904250000000014,-3.5877333333333343,-3.6817916666666681,-3.7725000000000013,-3.8597583333333345,-3.943466666666668,-4.0235250000000011,-4.0998333333333346,-4.1722916666666681,-4.2408000000000019,-4.3052583333333345,-4.3655666666666679,-4.4216250000000015,-4.4733333333333336,-4.5205916666666672,-4.5633000000000017,-4.6013583333333337,-4.6346666666666669,-4.663125,-4.6866333333333339,-4.7050916666666662,-4.7183999999999999,-4.7264583333333334,-4.729166666666667,{"$f":"SUM(DG18:DG23)","v":-4.7264583333333334},-4.7183999999999999,-4.7050916666666662,-4.6866333333333339,-4.6631250000000009,-4.6346666666666669,-4.6013583333333337,-4.5633000000000017,-4.5205916666666681,-4.4733333333333336,-4.4216250000000015,-4.3655666666666679,-4.3052583333333354,-4.2408000000000019,-4.1722916666666681,-4.0998333333333346,-4.0235250000000011,-3.9434666666666685,-3.859758333333335,-3.7725000000000022,-3.681791666666669,-3.5877333333333352,-3.4904250000000023,-3.3899666666666692,-3.2864583333333348,-3.1800000000000015,-3.0706916666666686,-2.9586333333333359,-2.8439250000000027,-2.7266666666666688,-2.6069583333333357,-2.4849000000000023,-2.3605916666666693,-2.234133333333336,-2.1056250000000025,-1.9751666666666692,-1.8428583333333357,-1.7088000000000028,-1.5730916666666694,-1.4358333333333362,-1.2971250000000032,-1.1570666666666702,-1.0157583333333364,-0.8733000000000033,-0.72979166666667028,-0.58533333333333715,-0.44002500000000377,-0.29396666666667048,-0.14725833333333782,-4.8849813083506888E-15]
[null,null,"Barrier height 'hb' [m] =",null,null,null,null,null,null,null,null,null,null,0,null,null,"Unfactored moment: barrier line load [kNm] =",null,null,null,null,null,null,null,null,{"$f":"IF(L9=AD9,ABS(INDEX(BH6:FD11,6,BH14)),ABS(INDEX(BH18:FD23,6,BH26)))","v":0},null,null,null,"100mm thk Wembley Innovation Wi Column",12,{"$f":"FIXED(12*2/$N$28,2)","v":"12.00"},"Mlower",{"$f":"AH18","v":1},0,0,2.0833333333333335,0,0,{"$f":"AK25","v":2.0833333333333335},null,"top",null,null,{"$f":"IF(AH17=1,0,N17/2-AD52/2)","v":0},null,null,null,null,"left",null,null,{"$f":"IF(AH17=1,0,N17/2-AD52/2)","v":0},null,null,null,null,null,"max",{"$f":"MIN(BH24:FD24)","v":-4.729166666666667}]
[null,null,"Partial load factor for wind load 'γf' =",null,null,null,null,null,null,null,null,null,null,1.5,null,null,"Total applied factored moment 'MEd' [kNm] =",null,null,null,null,null,null,null,null,{"$f":"Z23*N26+Z24*N27+Z25*N27","v":7.09375},null,null,null,"215mm thk Wembley Innovation Wi Beam",{"$f":"$AF$11*AF26","v":40},{"$f":"FIXED(40*2/$N$28,2)","v":"40.00"},null,null,null,null,null,null,null,null,null,"bottom",null,null,{"$f":"IF(AH18=1,0,N17/2-AD53/2)","v":0},null,null,null,null,"right",null,null,{"$f":"IF(AH18=1,0,N17/2-AD53/2)","v":0},null,null,null,null,null,"location",{"$f":"MATCH(BH25,BH24:FD24,0)","v":51}]
[null,null,"Partial load factor for barrier load 'γf' =",null,null,null,null,null,null,null,null,null,null,1.5,null,null,"Moment of resistance 'MRd' [kNm] =",null,null,null,null,null,null,null,null,{"$f":"IF(C20<>\" \",\"ERROR\",IF(L9=AD10,IF(Z26>AE22,\"ERROR\",INDEX(AE22:AE25,MIN(AG13,MATCH(Z26,AE22:AE25,-1)))),IF(Z26>AE26,\"ERROR\",INDEX(AE26:AE29,MIN(AG13,MATCH(Z26,AE26:AE29,-1))))))","v":18},null,null,null,"190mm thk Wembley Innovation Wi Beam",{"$f":"$AF$11*AF27","v":40},{"$f":"FIXED(40*2/$N$28,2)","v":"40.00"},null,null,"Final Design",null,null,"MAX BENDING MOMENT",null,null,null,null,"Applied loads",null,null,null,null,null,null,null,"Applied loads"]
[null,null,"Partial material factor 'γM' =",null,null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"IF(AND(N16<>AF12,L9=AD10,N17>7),\"Wi Column height cannot be more than 7m.\",(IF(AND(L9=AD10,N17>5,N16=AF12),\"100mm Wi Column height cannot be more than 5m.\",IF(AND(N16<>AF12,L9=AD9,N17>12),\"Wi Beam length cannot be more than 12m.\",(IF(AND(N16=AF12,L9=AD9,N17>7.5),\"100mm Wi Beam length cannot be more than 7.5m.\",IF(L9=AD10,IF(Z26>AE22,\"Applied load is too high. Wi Column not suitable.\",\"...ADOPT: \"&IF($AF$11=1,\"\",\"2x\")&AD31),IF(Z26>AE27,\"Applied load is too high. Wi Beam not suitable.\",\"...ADOPT: \"&IF($AF$11=1,\"\",\"2x\")&AD31))))))))","v":"...ADOPT: 140mm thk Wembley Innovation Wi Column"},null,null,null,null,null,null,null,null,null,null,null,null,"140mm thk Wembley Innovation Wi Beam",{"$f":"$AF$11*AF28","v":30},{"$f":"FIXED(30*2/$N$28,2)","v":"30.00"},null,null,{"$f":"$AD$14","v":"Standard"},null,null,{"$f":"$AD$13","v":"Conservative"},null,null,null,"top",null,null,{"$f":"AS25*$N$22","v":0},null,null,null,null,"left",null,null,{"$f":"BA25*$N$22","v":0}]
[null,null,{"$f":"IF(AND($N$28<>$AD$45,$N$28<>$AD$46),\"Note: non-standard partial material factor used.\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100mm thk Wembley Innovation Wi Beam",15,{"$f":"FIXED(15*2/$N$28,2)","v":"15.00"},null,null,{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},{"$f":"$AD$17","v":"Free edge"},{"$f":"$AD$18","v":"Free edge load"},{"$f":"$AD$19","v":"Standard"},null,"bottom",null,null,{"$f":"AS26*$N$22","v":0},null,null,null,null,"right",null,null,{"$f":"BA26*$N$22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated element type:",null,null,{"$f":"IF($L$9=$AD$10,AG16,AG23)","v":"Mcol"},null,{"$f":"IF($L$9=$AD$10,AI16,AI23)","v":0.5625},null,null,0.5625]
[null,null,"DIAGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L9=AD10,C20=\" \"),INDEX(AD22:AD25,MIN(AG13,MATCH(Z26,AE22:AE25,-1))),IF(AND(L9=AD9,C20=\" \"),INDEX(AD26:AD29,MIN(AG13,MATCH(Z26,AE26:AE29,-1))),\" \"))","v":"140mm thk Wembley Innovation Wi Column"},null,null,{"$f":"IF($L$9=$AD$10,AG17,AG24)","v":"Mleft"},{"$f":"AH24","v":1},{"$f":"IF($L$9=$AD$10,AI17,AI24)","v":0},3.75,2.0833333333333335,0,3.75,3.125,null,null,"Load heights",null,null,"Beam - barrier PUDL",null,null,null,null,"Load widths",null,null,"Column - barrier PUDL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($L$9=$AD$10,AG18,AG25)","v":"Mright"},{"$f":"AH25","v":1},{"$f":"IF($L$9=$AD$10,AI18,AI25)","v":0},3.75,2.0833333333333335,0,3.75,3.125,null,"top",null,null,{"$f":"IF((AD53+AQ16/2)<N25,(N25-AD53-AQ16/2)*(AD52+AQ16/2-(N25-AD53-AQ16/2)/2)/(AD52+AQ16/2),0)","v":0},null,null,{"$f":"AS32","v":0},null,"column",{"$f":"AY16","v":0.45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diagram data:",null,null,null,null,null,null,null,null,null,null,null,"bottom",null,null,{"$f":"IF((AD53+AQ16/2)>=N25,N25*N25/2/(AD53+AQ16/2),(AD53+AQ16/2)/2)","v":0},null,null,{"$f":"AS33","v":0},null,"left",0,{"$f":"AD52/2","v":3},{"$f":"IF(AH17=1,N17/2,AD52/2)","v":2.5},0,{"$f":"AZ33","v":3},{"$f":"AZ33","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"panel height",{"$f":"IF($L$9=$AD$9,\"\",\"H = \"&FIXED(N17,2)&\"m\")","v":"H = 5.00m"},null,null,null,null,null,null,null,null,null,null,null,"Applied loads",null,null,null,null,null,null,"right",0,{"$f":"AD53/2","v":3},{"$f":"IF(AH18=1,N17/2,AD53/2)","v":2.5},0,{"$f":"AZ34","v":3},{"$f":"AZ34","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"panel left side length",{"$f":"IF($L$9=$AD$9,\"\",\"w1 = \"&FIXED(AD52,2)&\"m\")","v":"w1 = 6.00m"},null,"Diagram visibility:",null,"select","beam/col","stand/conserv","free/edge load/standard","overlap","handrail/barrier",null,"top",null,null,{"$f":"AS32*$N$23","v":0},null,null,{"$f":"AS35","v":0},null,null,"Applied loads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"panel right side length",{"$f":"IF($L$9=$AD$9,\"\",\"w2 = \"&FIXED(AD53,2)&\"m\")","v":"w2 = 6.00m"},null,"Left_Overlap",null,{"$f":"AND(AJ36,AK36,AL36,AM36,AN36)","v":false},{"$f":"$L$9=$AD$10","v":true},{"$f":"$L$10=$AD$14","v":true},{"$f":"L14=AD19","v":true},{"$f":"$AH$17=0","v":false},true,null,"bottom",null,null,{"$f":"AS33*$N$23","v":0},null,null,{"$f":"AS36","v":0},null,"column",{"$f":"AY32*$N$23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"column width",{"$f":"IF($L$9=$AD$9,\"\",IF(L13=AF9,\"0.45m\",\"2x0.45m\"))","v":"0.45m"},null,"Right_Overlap",null,false,{"$f":"$L$9=$AD$10","v":true},{"$f":"$L$10=$AD$14","v":true},{"$f":"L15=AD19","v":true},{"$f":"$AH$18=0","v":false},true,null,null,null,null,null,null,null,null,null,"left",0,{"$f":"AZ33*$N$23","v":0},0,0,{"$f":"BC33*$N$23","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beam panel length",{"$f":"IF($L$9=$AD$9,\"L = \"&FIXED(N17,2)&\"m\",\"\")","v":""},null,"Left_Conservative",null,false,true,{"$f":"$L$10=$AD$13","v":false},{"$f":"L14=AD19","v":true},true,true,null,null,"percetnage of load",null,null,"Beam - barrier line",null,null,null,"right",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beam panel upper height",{"$f":"IF($L$9=$AD$9,\"w1 = \"&FIXED(AD52,2)&\"m\",\"\")","v":""},null,"Right_Conservative",null,false,true,false,{"$f":"L15=AD19","v":true},true,true,null,"top",null,null,{"$f":"IF((AD53+AQ16/2)<N25,(AD52+AQ16+AD53-N25)/(AD52+AQ16/2),0)","v":0},null,null,{"$f":"AS39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beam panel lower height",{"$f":"IF($L$9=$AD$9,\"w2 = \"&FIXED(AD53,2)&\"m\",\"\")","v":""},null,"Left_Standard",null,true,true,{"$f":"$L$10=$AD$14","v":true},{"$f":"L14=AD19","v":true},{"$f":"$AH$17=1","v":true},true,null,"bottom",null,null,{"$f":"IF(AND(L15=AD17,N25<=AQ16/2),1,IF((AD53+AQ16/2)>=N25,N25/(AD53+AQ16/2),0))","v":0},null,null,{"$f":"AS40","v":0},null,null,"Load widths",null,null,"Column - barrier line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"beam width",{"$f":"IF($L$9=$AD$9,IF(L13=AF9,\"0.225m\",\"2x0.225m\"),\"\")","v":""},null,"Right_Standard",null,true,true,true,{"$f":"L15=AD19","v":true},{"$f":"$AH$18=1","v":true},true,null,null,"Applied loads",null,null,null,null,null,null,"column",{"$f":"AY16","v":0.45}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"equal distance","II",null,"Left_Free_Edge",null,false,true,true,{"$f":"L14=AD17","v":false},true,true,null,"top",null,null,{"$f":"AS39*$N$24","v":0},null,null,{"$f":"AS42","v":0},null,"left",0,{"$f":"AD52/2","v":3},{"$f":"IF(AH17=1,N17/2,AD52/2)","v":2.5},0,{"$f":"AZ42","v":3},{"$f":"AZ42","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right_Free_Edge",null,false,true,true,{"$f":"L15=AD17","v":false},true,true,null,"bottom",null,null,{"$f":"AS40*$N$24","v":0},null,null,{"$f":"AS43","v":0},null,"right",0,{"$f":"AD53/2","v":3},{"$f":"IF(AH18=1,N17/2,AD53/2)","v":2.5},0,{"$f":"AZ43","v":3},{"$f":"AZ43","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partial material factors:",null,null,"Left_Free_Edge_Load",null,false,true,true,{"$f":"L14=AD18","v":false},true,true,null,null,null,null,null,null,null,null,null,null,"Applied loads"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,"Right_Free_Edge_Load",null,false,true,true,{"$f":"L15=AD18","v":false},true,true,null,null,null,null,null,null,null,null,null,"column",{"$f":"AY41*$N$24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4,null,null,"Beam_Upper",null,false,{"$f":"$L$9=$AD$9","v":false},true,{"$f":"OR(L15=AD17,L15=AD18)","v":false},{"$f":"AND(L14=AD19,OR(L15=AD17,L15=AD18))","v":false},true,null,null,null,null,null,null,null,null,null,"left",0,{"$f":"AZ42*$N$24","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beam_Lower",null,false,{"$f":"$L$9=$AD$9","v":false},true,{"$f":"AND(NOT(AND(L14=AD18,L15=AD19)),OR(L14=AD17,L14=AD18))","v":false},{"$f":"AND(L15=AD19,OR(L14=AD17,L14=AD18))","v":false},true,null,null,null,null,null,null,null,null,null,"right",0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colour coding:",null,null,"Beam_Standard",null,false,false,true,{"$f":"NOT(AND(L14=AD18,L15=AD19))","v":true},{"$f":"AND(L14=AD19,L15=AD19)","v":true},true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X19:AA19",null,null,"Beam_Free_Edge_Load",null,false,false,true,{"$f":"AND(L14=AD18,L15=AD19)","v":false},true,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column_Left_Handrail_Short",null,false,{"$f":"$L$9=$AD$10","v":true},{"$f":"$L$10=$AD$14","v":true},{"$f":"$L$14=$AD$19","v":true},{"$f":"$AH$17=0","v":false},{"$f":"$N$24<>0","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances:",null,null,"Column_Left_Handrail_Long",null,{"$f":"AND(AJ51,AK51,AL51,AM51,AN51)","v":false},{"$f":"$L$9=$AD$10","v":true},true,{"$f":"OR($L$14=$AD$18,AND($L$10=$AD$13,$L$14=$AD$19),$AH$17=1)","v":true},{"$f":"OR($AH$17=0,AND($L$14<>$AD$17,$AH$17=1))","v":true},{"$f":"$N$24<>0","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L9=AD9,L14=AD17),0,N18)","v":6},null,null,"Column_Right_Handrail_Short",null,false,{"$f":"$L$9=$AD$10","v":true},{"$f":"$L$10=$AD$14","v":true},{"$f":"$L$15=$AD$19","v":true},{"$f":"$AH$18=0","v":false},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE: This diagram is indicative only. It is not to scale.",null,null,{"$f":"IF(AND(L9=AD9,L15=AD17),0,N19)","v":6},null,null,"Column_Right_Handrail_Long",null,false,{"$f":"$L$9=$AD$10","v":true},true,{"$f":"OR($L$15=$AD$18,AND($L$10=$AD$13,$L$15=$AD$19),$AH$18=1)","v":true},{"$f":"OR($AH$18=0,AND($L$15<>$AD$17,$AH$18=1))","v":true},false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column_Left_Barrier_Short",null,false,true,{"$f":"$L$10=$AD$14","v":true},{"$f":"$L$14=$AD$19","v":true},{"$f":"$AH$17=0","v":false},{"$f":"$N$23<>0","v":false}]
[null,null,"NOTES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column_Left_Barrier_Long",null,false,true,true,{"$f":"OR($L$14=$AD$18,AND($L$10=$AD$13,$L$14=$AD$19),$AH$17=1)","v":true},{"$f":"OR($AH$17=0,AND($L$14<>$AD$17,$AH$17=1))","v":true},{"$f":"$N$23<>0","v":false}]
[null,null,"1. Clear span between columns is edge-to-edge of columns (not centre-to-centre);",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column_Right_Barrier_Short",null,false,true,{"$f":"$L$10=$AD$14","v":true},{"$f":"$L$15=$AD$19","v":true},{"$f":"$AH$18=0","v":false},false]
[null,null,"2. Classic \"back of envelope\" failure of the panel is assumed to occur with 45° yield lines at corners;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Column_Right_Barrier_Long",null,false,{"$f":"$L$9=$AD$10","v":true},true,{"$f":"OR($L$15=$AD$18,AND($L$10=$AD$13,$L$15=$AD$19),$AH$18=1)","v":true},{"$f":"OR($AH$18=0,AND($L$15<>$AD$17,$AH$18=1))","v":true},false]
[null,null,"3. Wall panel infills to be designed separately according to BS EN1996-1.1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beam_Handrail",null,false,{"$f":"$L$9=$AD$9","v":false},true,true,true,{"$f":"$N$24<>0","v":false}]
[null,null,"4. Wi Columns are designed as simply supported columns, with pinned connection at head and base. Head connection is always required.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beam_Barrier",null,false,{"$f":"$L$9=$AD$9","v":false},true,true,true,false]
[]
[]
[]
[null,null,"Spreadsheet by: www.YourSpreadsheets.co.uk",null,null,null,null,null,null,null,null,null,"based on BS EN1996-1 and Lucideon's test results of Wembley Innovation Wi System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Performance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High"]

{"sheet":"from authors","index":1,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,2,62,9],[2,2,2,5],[2,6,2,9],[3,2,3,5],[3,6,3,9],[41,2,41,9],[42,2,42,9],[43,2,43,9],[45,2,45,9],[44,2,44,9],[46,2,46,9],[35,2,40,9],[0,1,0,3],[0,4,0,10],[4,12,4,13],[13,2,31,9],[7,2,9,9]]}
[null,"Version: 1.8",null,null,"© 2023 YourSpreadsheets and Wembley Innovation"]
[]
[null,null,"For latest updates and news visit:",null,null,null,"Contact us at:"]
[null,null,"http://www.wembleyinnovation.co.uk",null,null,null,"info@wembleyinnovation.co.uk"]
[]
[]
[]
[null,null,"General information:\nNote: This spreadsheet contains macros.\nTo change company logo: right click it and select 'change picture'."]
[]
[]
[]
[]
[]
[null,null,"The Authors take no liability for use of this spreadsheet and give no guarantee that it is error free. \n\nIn no event shall the Authors be responsible for any special, incidental or consequential damages whatsoever arising from the use of this spreadsheet, even if the Authors have been advised of the possibility of such damage.\n\nThis is a company licensed version of the spreadsheet. Within the workplace, the spreadsheet is not limited to any number of computers and can be transferred freely.\n\nReverse-engineering, decompiling or disassembling of this spreadsheet is not allowable. \n\nAnti-virus and anti-malware checks should be carried out by the user prior to installation of this spreadsheet.\n \nBy using this spreadsheet you understand and agree with the above terms and conditions. You also acknowledge that you do not become the owner of this spreadsheet.\n\nDamian Janicki & Wembley Innovation Ltd"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The intention of the Wi System is to provide structural support to laterally loaded masonry panels. The Wi System eliminates concrete/steel windposts and lintels giving cost-effective and aesthetic structural solutions.\n\nTo download the Lucideon Design Guide which forms the basis for using the Wi System click here:"]
[]
[]
[]
[]
[]
[null,null,"Lucideon Design Guide (PDF)"]
[]
[null,null,"For more information on Wembley Innovation and to order Wi Beams / Wi Columns:"]
[null,null,"www.wembleyinnovation.co.uk"]
[null,null,"info@wembleyinnovation.co.uk"]
[null,null,"or call +44 (0)20 8903 4527"]
[]
[]
[]
[null,null,"This spreadsheet is based on EN1996-1 and Lucideon's test results of the Wi System.\n\nChangelog:\n2023.09.12 - V.1.8 -  Notes revised\n2020.08.01 - V.1.7 -  SP option removed - Update check and notification added - Contacts updated\n2018.08.10 - v.1.6 -  Wi Column capacities revised following new testing at Lucideon labs.\n2017.07.31 - v.1.5. - SP capacities added.\n2015.01.28 - v.1.4. - added reactions to the spreadsheet.\n2014.09.10 - v.1.3. - revised allowable bending moment values for Wi Columns following amendments to EC6. Some minor changes to how moments are calculated. Revised colour coding functionality.\n2014.07.28 - v.1.2. - revised diagrams for clearer information. Added some extra functionality.\n2014.06.18 - v.1.1. - first release of the spreadsheet."]