{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Bending resistance (pressure)","Bending resistance (suction)","End support resistance (shear)","Dislocation (failure)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":90,"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":"Data","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,3,7,12],[17,3,17,12]]}
["Geometrical definition"]
[]
["Joint shape","clip"]
["bu",0]
["h",0]
["bf",0]
["ri",0]
["φ",0,null,"Plank with clip joint dimensions"]
["cf",0]
[]
["Material properties"]
[]
["t",0]
["fyb",320]
[]
["Plank implementation"]
[]
["Lsp",0,null,"Plank with chevron joint dimensions"]

{"sheet":"Bending resistance (pressure)","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[10,0,12,0],[13,0,15,0],[34,1,34,2],[34,4,34,5],[35,1,35,2]]}
["Bending resistance calculation (pressure)"]
[]
["Effective width of the upper flange (compressed)"]
["λp,u",{"$f":"(b_u/t)/(28.4*ε*SQRT(4))","v":{"$error":"#DIV/0!"}}]
["ρu",{"$f":"IF(λ_p.u>(0.5+SQRT(0.085-0.055*1)),(λ_p.u-0.055*(3+1))/λ_p.u^2,1)","v":{"$error":"#DIV/0!"}}]
["beff,u",{"$f":"ρ_u*b_u","v":{"$error":"#DIV/0!"}}]
["be,u",{"$f":"b_eff.u/2","v":{"$error":"#DIV/0!"}}]
[]
["Position of the neutral axis (fully effective web and effective flanges)"]
[null,"l\nmm","h\nmm","z\nmm","l × z\nmm²","l × z²\nmm³","Ipart\nmm⁴"]
["left wing",{"$f":"b_e.u","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},{"$f":"0","v":0},{"$f":"l_p*z_p","v":{"$error":"#DIV/0!"}},{"$f":"l_p*z_p^2","v":{"$error":"#DIV/0!"}},{"$f":"l_p*h_p^2/12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h","v":0},{"$f":"h/2","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"b_f","v":0},{"$f":"t","v":0},{"$f":"h","v":0},0,0,0]
["right wing",{"$f":"b_e.u","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h","v":0},{"$f":"h/2","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"c_f","v":0},{"$f":"t","v":0},{"$f":"h","v":0},0,0,0]
["Σ",{"$f":"SUM(l_p)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(l_p·z_p)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(l_p·z_p²)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I_part)","v":{"$error":"#DIV/0!"}}]
[]
["zc",{"$f":"Σl_p·z_p/Σl_p","v":{"$error":"#DIV/0!"}},null,"zt",{"$f":"h-z_c","v":{"$error":"#DIV/0!"}}]
[]
["Effective part of the web"]
["Ψ",{"$f":"-z_t/z_c","v":{"$error":"#DIV/0!"}},"σ2/σ1 = zt/zc",null,"heff",{"$f":"ρ_w*z_c","v":{"$error":"#DIV/0!"}}]
["kσ",{"$f":"7.81-6.29*Ψ+9.78*Ψ^2","v":{"$error":"#DIV/0!"}},null,null,"heff,1",{"$f":"0.4*h_eff","v":{"$error":"#DIV/0!"}}]
["λp,w",{"$f":"(h/t)/(28.4*ε*SQRT(k_σ))","v":{"$error":"#DIV/0!"}},null,null,"heff,2",{"$f":"0.6*h_eff","v":{"$error":"#DIV/0!"}}]
["ρw",{"$f":"IF(λ_p.w>0.5+SQRT(0.085-0.055*Ψ),(λ_p.w-0.055*(3+Ψ))/λ_p.w^2,1)","v":{"$error":"#DIV/0!"}},null,null,"Δ",{"$f":"z_c-h_eff","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"zΔ",{"$f":"h_eff.1+Δ/2","v":{"$error":"#DIV/0!"}}]
[]
["Position of the neutral axis (effective web and effective compressed flange)"]
["zeff,c",{"$f":"(Σl_p·z_p-Δ*z_Δ)/(Σl_p-Δ)","v":{"$error":"#DIV/0!"}},null,"zeff,t",{"$f":"h-z_eff.c","v":{"$error":"#DIV/0!"}}]
[]
["Inertia and effective bending modulus for one plank"]
["Ieff,pl",{"$f":"t*((Σl_p·z_p²-Δ*z_Δ^2)+(ΣI_part-Δ*t^2/12)-(Σl_p-Δ)*z_eff.c^2)","v":{"$error":"#DIV/0!"}},null,"Weff,pl",{"$f":"I_eff.pl/MAX(z_eff.c,z_eff.t)","v":{"$error":"#DIV/0!"}}]
[]
["General bending resistance of the profile"]
["Ieff",{"$f":"I_eff.pl/(b_u*0.001)","v":{"$error":"#DIV/0!"}},null,"Weff",{"$f":"W_eff.pl/(b_u*0.001)","v":{"$error":"#DIV/0!"}}]
["Mb,Rd,c",{"$f":"W_eff*0.8*f_yb*0.000001","v":{"$error":"#DIV/0!"}}]

{"sheet":"Bending resistance (suction)","index":2,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,1,51,2],[50,4,50,5],[4,0,6,0],[7,0,9,0],[26,0,28,0],[29,0,31,0],[50,1,50,2]]}
["Bending resistance calculation (suction)"]
[]
["Initial position of the neutral axis (both fully effective web and flanges)"]
[null,"l\nmm","z\nmm","l × z\nmm²"]
["left wing",{"$f":"b_f","v":0},{"$f":"0","v":0},{"$f":"l_p0*z_p0","v":0}]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h/2","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"b_u/2","v":0},{"$f":"h","v":0},0]
["right wing",{"$f":"c_f","v":0},0,0]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h/2","v":0},{"$error":"#DIV/0!"}]
[null,{"$f":"b_u/2","v":0},{"$f":"h","v":0},0]
["Σ",{"$f":"SUM(l_p0)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(l_p0·z_p0)","v":{"$error":"#DIV/0!"}}]
[]
["zc,0",{"$f":"Σl_p0·z_p0/Σl_p0","v":{"$error":"#DIV/0!"}},null,"zt,0",{"$f":"h-z_c.0","v":{"$error":"#DIV/0!"}}]
[]
["Effective width of the upper flange (tensed)"]
["e0",{"$f":"h-z_t.0","v":{"$error":"#DIV/0!"}}]
["beff,u",{"$f":"(53.3*10^10*e_0^2*t^4)/(h*L_sp*1000*b_u^3)","v":{"$error":"#DIV/0!"}}]
["be,u",{"$f":"b_eff.u/2","v":{"$error":"#DIV/0!"}}]
[]
["Effectives widths of the lower flanges (compressed)"]
["λp,b",{"$f":"(b_f/t)/(28.4*ε*SQRT(0.43))","v":{"$error":"#DIV/0!"}},null,"λp,c",{"$f":"(c_f/t)/(28.4*ε*SQRT(0.43))","v":{"$error":"#DIV/0!"}}]
["ρb",{"$f":"IF(λ_p.b>(0.5+SQRT(0.085-0.055*1)),(λ_p.b-0.055*(3+1))/λ_p.b^2,1)","v":{"$error":"#DIV/0!"}},null,"ρc",{"$f":"IF(λ_p.c>(0.5+SQRT(0.085-0.055*1)),(λ_p.c-0.055*(3+1))/λ_p.c^2,1)","v":{"$error":"#DIV/0!"}}]
["beff,f",{"$f":"ρ_b*b_f","v":{"$error":"#DIV/0!"}},null,"ceff,f",{"$f":"ρ_c*c_f","v":{"$error":"#DIV/0!"}}]
[]
["Position of the neutral axis (fully effective web and effective flanges)"]
[null,"l\nmm","h\nmm","z\nmm","l × z\nmm²","l × z²\nmm³","Ipart\nmm⁴"]
["left wing",{"$f":"b_eff.f","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},{"$f":"0","v":0},{"$f":"l_p*z_p","v":{"$error":"#DIV/0!"}},{"$f":"l_p*z_p^2","v":{"$error":"#DIV/0!"}},{"$f":"l_p*h_p^2/12","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h","v":0},{"$f":"h/2","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"b_e.u","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},{"$f":"h","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["right wing",{"$f":"c_eff.f","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"h/SIN(RADIANS(ϕ))","v":{"$error":"#DIV/0!"}},{"$f":"h","v":0},{"$f":"h/2","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"b_e.u","v":{"$error":"#DIV/0!"}},{"$f":"t","v":0},{"$f":"h","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Σ",{"$f":"SUM(l_p)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(l_p·z_p)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(l_p·z_p²)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I_part)","v":{"$error":"#DIV/0!"}}]
[]
["zc",{"$f":"Σl_p·z_p/Σl_p","v":{"$error":"#DIV/0!"}},null,"zt",{"$f":"h-z_c","v":{"$error":"#DIV/0!"}}]
[]
["Effective part of the web"]
["Ψ",{"$f":"-z_t/z_c","v":{"$error":"#DIV/0!"}},"σ2/σ1","heff",{"$f":"ρ_w*z_c","v":{"$error":"#DIV/0!"}}]
["kσ",{"$f":"7.81-6.29*Ψ+9.78*Ψ^2","v":{"$error":"#DIV/0!"}},null,"heff,1",{"$f":"0.4*h_eff","v":{"$error":"#DIV/0!"}}]
["λp,w",{"$f":"(h/t)/(28.4*ε*SQRT(k_σ))","v":{"$error":"#DIV/0!"}},null,"heff,2",{"$f":"0.6*h_eff","v":{"$error":"#DIV/0!"}}]
["ρw",{"$f":"IF(λ_p.w>0.5+SQRT(0.085-0.055*Ψ),(λ_p.w-0.055*(3+Ψ))/λ_p.w^2,1)","v":{"$error":"#DIV/0!"}},null,"Δ",{"$f":"z_c-h_eff","v":{"$error":"#DIV/0!"}}]
[null,null,null,"zΔ",{"$f":"h_eff.1+Δ/2","v":{"$error":"#DIV/0!"}}]
[]
["Position of the neutral axis (effective web and effective compressed flange)"]
["zeff,c",{"$f":"(Σl_p·z_p-Δ*z_Δ)/(Σl_p-Δ)","v":{"$error":"#DIV/0!"}},null,"zeff,t",{"$f":"h-z_eff.c","v":{"$error":"#DIV/0!"}}]
[]
["Inertia and effective bending modulus for one plank"]
["Ieff,pl",{"$f":"t*((Σl_p·z_p²-Δ*z_Δ^2)+(ΣI_part-Δ*t^2/12)-(Σl_p-Δ)*z_eff.c^2)","v":{"$error":"#DIV/0!"}},null,"Weff,pl",{"$f":"I_eff.pl/MAX(z_eff.c,z_eff.t)","v":{"$error":"#DIV/0!"}}]
[]
["General bending resistance of the profile"]
["Ieff",{"$f":"I_eff.pl/(b_u*0.001)","v":{"$error":"#DIV/0!"}},null,"Weff",{"$f":"W_eff.pl/(b_u*0.001)","v":{"$error":"#DIV/0!"}},"mm3/m"]
["Mb,Rd,c",{"$f":"W_eff*0.8*f_yb*0.000001","v":{"$error":"#DIV/0!"}}]

{"sheet":"End support resistance (shear)","index":3,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["End support resistance (shear)"]
[]
["Rw,Rd",{"$f":"α*t^2*SQRT(f_yb*E)*(1-0.1*SQRT(r_i/t))*(0.5+SQRT(0.02*l_a/t))*(2.4+(ϕ/90)^2)*2/b_u","v":{"$error":"#DIV/0!"}}]

{"sheet":"Dislocation (failure)","index":4,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[10,1,10,2]]}
["Dislocation of the plank"]
[]
["Limit displacement"]
[]
["δlim",{"$f":"IF(Data!B3=\"clip\",c_f,h/(2*TAN(RADIANS(ϕ))))","v":0}]
[]
["Maximum load"]
[]
["umax",{"$f":"(E*1000*t^3*δ_lim)/(12*(1-ν^2)*SQRT((b_f^3/3)^2+(b_f*((b_u*h)/3+h^2/2))^2))/1000","v":{"$error":"#DIV/0!"}}]
[]
["qRd",{"$f":"2*u_max/(b_u*0.001)","v":{"$error":"#DIV/0!"}}]
[]
["Displacement components"]
[]
["δv",{"$f":"u_max*1000*b_f^3*(12*(1-ν^2))/(3*E*1000*t^3)","v":{"$error":"#DIV/0!"}}]
[]
["δh",{"$f":"u_max*1000*b_f*(12*(1-ν^2))/(E*1000*t^3)*(b_u*h/3+h^2/2)","v":{"$error":"#DIV/0!"}}]