{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["INIZIO","INTAGLIO","RINFORZO A COMPRESSIONE","CONNESSIONI INCLINATE","CONNESSIONI PIANE","Foglio2","Materiali","Viti","Prescrizioni","Viti2","Viti3","Viti4"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":8,"comments":3,"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":"INIZIO","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,0,6,10]]}
[]
[]
[]
[]
[]
["SOFTWARE DI CALCOLO PER VITI CONSTRUCT TC - TS"]
[]
[]
[null,"1) Rinforzo di trave con intaglio",null,null,null,null,"2) Rinforzo di trave a compressione"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3) Verifiche su connessioni inclinate",null,null,null,null,"4) Verifiche su connessioni piane"]
[]
[]
[]
[]
[]
[]
[]
[]
["Il presente foglio di calcolo non può essere distribuito e/o modificato senza il consenso scritto di RoofRox Srl."]
["Software Viti CONSTRUCT - RoofRox v1"]

{"sheet":"INTAGLIO","index":1,"n_rows":92,"n_cols":14,"rows_kept":92,"cut":false,"hidden":false,"merged":[[4,0,5,9],[53,4,53,5],[71,0,71,4],[41,5,42,6],[41,7,42,7],[48,0,48,9],[67,0,67,9],[16,0,16,9],[30,0,30,2],[30,6,30,8],[39,0,39,2],[39,6,39,8],[33,0,33,9],[40,0,40,9],[76,0,76,3],[76,6,76,9],[6,0,6,9],[41,8,42,8],[81,0,81,9],[86,0,87,9],[88,0,89,9]]}
[]
[]
[]
[]
["RINFORZO DI TRAVE CON INTAGLIO"]
[]
["DATI DI PROGETTO"]
["B =",160,"mm"]
["H =",360,"mm"]
["Hef =",180,"mm"]
["H-Hef =",{"$f":"B9-B10","v":180},"mm"]
["Lappoggio =",200,"mm"]
["Lintaglio =",0,"mm"]
["FV,Ed =",19,"kN"]
["Legno ="]
[]
["VERIFICA DELLA TENSIONE A TAGLIO - TRAVE NON RINFORZATA / SEZIONE RIDOTTA"]
["tc,90,d =",{"$f":"1.5*B14/(B10*(0.67*B8))*10^3","v":1.4769900497512438},"MPa"]
["c =",80,"mm"]
["αh=",{"$f":"B10/B9","v":0.5},"-"]
["i =",{"$f":"B13/B11","v":0},"-"]
["kn =",{"$f":"VLOOKUP(Prescrizioni!$D$197,Prescrizioni!$D$194:$E$196,2)","v":6.5},"-"]
["kv =",{"$f":"MIN(1,(B22*(1+(1.1*B21^1.5)/B9^0.5))/(B9^0.5*((B20*(1-B20))^0.5+0.8*B19/B9*(1/B20-B20^2)^0.5)))","v":0.46598256353982082},"-"]
["fv,k =",{"$f":"VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,8)","v":3.5},"MPa"]
[]
["EN 1995:2014",null,null,null,null,null,"NTC '18"]
["kmod =",0.9,"-",null,null,null,"kmod =",{"$f":"B27","v":0.9},"-"]
["gL =",{"$f":"IF(Prescrizioni!$D$197=2,Prescrizioni!$D$4,Prescrizioni!$E$4)","v":1.25},"-",null,null,null,"gL =",{"$f":"IF(Prescrizioni!$D$197=2,Prescrizioni!$D$3,Prescrizioni!$E$3)","v":1.45},"-"]
["fv,d =",{"$f":"B27/B28*B24","v":2.52},"MPa",null,null,null,"fv,d =",{"$f":"H27/H28*B24","v":2.1724137931034484},"MPa"]
["kv*fv,d =",{"$f":"B23*B29","v":1.1742760601203484},"MPa",null,null,null,"kv*fv,d =",{"$f":"B23*H29","v":1.0123069483796108},"MPa"]
[{"$f":"IF(B18>B30,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA NON SODDISFATTA"},null,null,null,null,null,{"$f":"IF(B18>H30,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA NON SODDISFATTA"}]
[{"$f":"CONCATENATE(TRUNC(B30,2),\" \",C30)","v":"1.17 MPa"},{"$f":"IF(B30>B18,\">\",\"<\")","v":"<"},{"$f":"CONCATENATE(ROUNDUP(B18,2),\" \",C18)","v":"1.48 MPa"},null,null,null,{"$f":"CONCATENATE(TRUNC(H30,2),\" \",I30)","v":"1.01 MPa"},{"$f":"IF(H30>B18,\">\",\"<\")","v":"<"},{"$f":"CONCATENATE(ROUNDUP(B18,2),\" \",C18)","v":"1.48 MPa"}]
[]
["VERIFICA DELLA TENSIONE A TAGLIO - TRAVE NON RINFORZATA / SEZIONE PIENA"]
["tc,90,d =",{"$f":"1.5*B14/(B9*B8)*10^3","v":0.49479166666666669},"MPa"]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '18"]
["fv,d =",{"$f":"B29","v":2.52},"MPa",null,null,null,"fv,d =",{"$f":"H29","v":2.1724137931034484},"MPa"]
[{"$f":"CONCATENATE(ROUNDUP(B38,2),\" \",C38)","v":"2.52 MPa"},{"$f":"IF(B38>B35,\">\",\"<\")","v":">"},{"$f":"CONCATENATE(ROUNDUP(B35,2),\" \",C35)","v":"0.5 MPa"},null,null,null,{"$f":"CONCATENATE(ROUNDUP(H38,2),\" \",I38)","v":"2.18 MPa"},{"$f":"IF(H38>B35,\">\",\"<\")","v":">"},{"$f":"CONCATENATE(ROUNDUP(B35,2),\" \",C35)","v":"0.5 MPa"}]
[{"$f":"IF(B35>B38,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(B35>H38,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
["RINFORZO SEZIONE 1 - CALCOLO TRAZIONE ORTOGONALE ALLE FIBRE - DIN 1052:2008"]
[null,null,null,null,null,"Fax,Rd= Ft,90,d =",null,{"$f":"1.3*(3*(1-B20)^2-2*(1-B20)^3)*B14","v":12.35},"kN"]
[]
[]
[]
[]
[]
[]
["RESISTENZA A TRAZIONE DEL CONNETTORE"]
["Scelta connettore:",null,null,null,null,null,null,"Ftens,k =",{"$f":"IF(Viti!$S$4=1,VLOOKUP(Viti!$T$4,Viti!$B$5:$P$24,14),VLOOKUP(Viti!$T$4,Viti!$B$25:$P$45,14))","v":24.1},"kN"]
[]
[]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,90,null,null,null,null,null,null,"alfa rad",{"$f":"RADIANS(E54)","v":1.5707963267948966},"rad"]
["fax,k,90° =",{"$f":"IF(Viti3!$S$4=1,VLOOKUP(Viti3!$T$4,Viti3!$B$5:$P$24,15),VLOOKUP(Viti3!$T$4,Viti3!$B$25:$P$45,15))","v":13.1},"MPa"]
["d =",{"$f":"IF(Viti3!$S$4=1,VLOOKUP(Viti3!$T$4,Viti3!$B$5:$P$24,8),VLOOKUP(Viti3!$T$4,Viti3!$B$25:$P$45,8))","v":8},"mm"]
["LVite =",{"$f":"IF(Viti3!$S$4=1,VLOOKUP(Viti3!$T$4,Viti3!$B$5:$P$24,10),VLOOKUP(Viti3!$T$4,Viti3!$B$25:$P$45,10))","v":280},"mm"]
["Rax,Rd = min [Fax,a,Rk*kmod/gconn; Ftens,k/gm2]"]
[]
["EN 1995:2014",null,null,null,null,null,"NTC '18"]
["kmod =",{"$f":"B27","v":0.9},"-",null,null,null,"kmod =",{"$f":"H27","v":0.9},"-"]
["gconn =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gconn =",{"$f":"Prescrizioni!$F$3","v":1.5},"-"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-"]
["Fax,90°,Rd =",{"$f":"($B$55*(B$57-B$11)*$B$56/(1.2*(COS($M$54))^2+(SIN($M$54))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B61/B62","v":7.830231243737801},"kN",null,null,null,"Fax,90°,Rd =",{"$f":"($B$55*($B$57-$B$11)*$B$56/(1.2*(COS($M$54))^2+(SIN($M$54))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H61/H62","v":6.7862004112394274},"kN"]
["Ftens,d =",{"$f":"$I$50/B63","v":19.28},"kN",null,null,null,"Ftens,d =",{"$f":"$I$50/H63","v":19.28},"kN"]
["Fax,Rd =",{"$f":"MIN(B64,B65)","v":7.830231243737801},"kN",null,null,null,"Fax,Rd =",{"$f":"MIN(H64,H65)","v":6.7862004112394274},"kN"]
[]
["NUMERO MINIMO CONNETTORI"]
["EN 1995:2014",null,null,null,null,null,"NTC '18"]
["nconn,min =",{"$f":"$H$42/B66","v":1.5772203419760902},"-",null,null,null,"nconn,min =",{"$f":"$H$42/H66","v":1.819869625357027},"-"]
[]
["Connettori impiegati:       →",null,null,null,null,null,"n0 =",2,"n90 =",1]
[null,null,null,null,null,null,"nconn,eff =",{"$f":"(H72*J72)^0.9","v":1.8660659830736148},"-"]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '18"]
["Fax,Rd,tot [kN]=",{"$f":"$H$73*B66","v":14.611728163539313},{"$f":"IF(B76>D76,\">\",IF(B76=D76,\"=\",\"<\"))","v":">"},{"$f":"$H$42","v":12.35},null,null,"Fax,Rd,tot [kN]=",{"$f":"$H$73*H66","v":12.663497741734071},{"$f":"IF(H76>J76,\">\",IF(H76=J76,\"=\",\"<\"))","v":">"},{"$f":"$H$42","v":12.35}]
[{"$f":"IF(B76>D76,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H76>J76,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
[]
[]
[]
[]
["NOTE PER L'UTILIZZO DEL FOGLIO"]
[]
["1) La presente relazione di calcolo è stata redatta in conformità alle normative vigenti alla data della stessa."]
["2) I parametri caratteristici delle viti sono in accordo a ETA 12/0373."]
["3) Il dimensionamento e la verifica degli elementi lignei devono svolgersi separatamente."]
["4) La presente relazione di calcolo non costituisce documento esecutivo e dovrà essere sempre conformata dal Vs. tecnico responsabile delle strutture o da tecnico abilitato."]
[]
["5) I calcoli qui riportati dovranno essere IN OGNI CASO controllati e approvati dal Vostro tecnico responsabile delle strutture. "]
[]
["6) La società Roofrox Srl declina ogni responsabilità per utilizzi impropri del presente software di calcolo. "]
["7) Il presente foglio non può essere modificato e/o distributo in alcun modo senza il consenso scritto di RoofRox Srl."]

{"sheet":"RINFORZO A COMPRESSIONE","index":2,"n_rows":88,"n_cols":16,"rows_kept":88,"cut":false,"hidden":false,"merged":[[45,3,46,5],[34,4,34,5],[41,0,41,4],[29,0,29,9],[77,0,77,9],[73,0,73,2],[73,6,73,8],[82,0,83,9],[84,0,85,9],[4,0,5,9],[6,0,6,9],[16,0,16,9],[26,0,26,2],[26,6,26,8]]}
[]
[]
[]
[]
["RINFORZO DI TRAVE A COMPRESSIONE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["DATI DI PROGETTO"]
["B =",200,"mm"]
["H =",520,"mm"]
["tpiastra =",20,"mm"]
["bapp =",200,"mm"]
["Fc,90,d =",120,"kN"]
[]
[]
["Legno ="]
[]
["VERIFICA DELLA TENSIONE A SCHIACCIAMENTO - TRAVE NON RINFORZATA"]
["sc,90,d =",{"$f":"B12*10^3/(B8*B20)","v":2.3076923076923075},"MPa"]
["kc,90 =",1,"-"]
["lef,1=",{"$f":"MIN(B11+2*30,B11+B11)","v":260},"mm","(secondo EC5 - 6.1.5)"]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '18"]
["kmod =",0.9,"-",null,null,null,"kmod =",{"$f":"B23","v":0.9},"-"]
["gL =",{"$f":"IF(Prescrizioni!$D$197=2,Prescrizioni!$D$4,Prescrizioni!$E$4)","v":1.25},"-",null,null,null,"gL =",{"$f":"IF(Prescrizioni!$D$197=2,Prescrizioni!$D$3,Prescrizioni!$E$3)","v":1.45},"-"]
["fc,90,d =",{"$f":"B23/B24*VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,7)","v":1.7999999999999998},"MPa",null,null,null,"fc,90,d =",{"$f":"H23/H24*VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,7)","v":1.5517241379310345},"MPa"]
["kC,90*fc,90,d =",{"$f":"B19*B25","v":1.7999999999999998},"MPa",null,null,null,"kC,90*fc,90,d =",{"$f":"B19*H25","v":1.5517241379310345},"MPa"]
[{"$f":"IF(B18>B26,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA NON SODDISFATTA"},null,null,null,null,null,{"$f":"IF(B18>H26,\"VERIFICA NON SODDISFATTA\",\"VERIFICA SODDISFATTA\")","v":"VERIFICA NON SODDISFATTA"}]
[{"$f":"CONCATENATE(TRUNC(B26,2),\" \",C26)","v":"1.8 MPa"},{"$f":"IF(B26>B18,\">\",\"<\")","v":"<"},{"$f":"CONCATENATE(ROUNDUP(B18,2),\" \",C18)","v":"2.31 MPa"},null,null,null,{"$f":"CONCATENATE(TRUNC(H26,2),\" \",I26)","v":"1.55 MPa"},{"$f":"IF(H26>B18,\">\",\"<\")","v":"<"},{"$f":"CONCATENATE(ROUNDUP(B18,2),\" \",C18)","v":"2.31 MPa"}]
[]
["VERIFICA DELLA TENSIONE A SCHIACCIAMENTO - TRAVE RINFORZATA"]
["Scelta connettore:"]
[]
[]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,90,null,null,null,null,null,null,null,null,"alfa rad",{"$f":"RADIANS(E35)","v":1.5707963267948966},"rad"]
["fax,k,90° =",{"$f":"IF(Viti4!$S$4=1,VLOOKUP(Viti4!$T$4,Viti4!$B$5:$P$24,15),VLOOKUP(Viti4!$T$4,Viti4!$B$25:$P$45,15))","v":13.1},"MPa"]
["fy,k =",950,"MPa",null,null,"- Per appoggi intermedi (vedere ETA 12/0373):"]
["d =",{"$f":"IF(Viti4!$S$4=1,VLOOKUP(Viti4!$T$4,Viti4!$B$5:$P$24,8),VLOOKUP(Viti4!$T$4,Viti4!$B$25:$P$45,8))","v":8},"mm"]
["d1 =",{"$f":"IF(Viti4!$S$4=1,VLOOKUP(Viti4!$T$4,Viti4!$B$5:$P$24,7),VLOOKUP(Viti4!$T$4,Viti4!$B$25:$P$45,7))","v":5.2},"mm"]
["LVite =",{"$f":"IF(Viti4!$S$4=1,VLOOKUP(Viti4!$T$4,Viti4!$B$5:$P$24,10),VLOOKUP(Viti4!$T$4,Viti4!$B$25:$P$45,10))","v":200},"mm"]
[]
["Connettori impiegati:       →",null,null,null,null,null,"n0 =",2,"n90 =",2]
[null,null,null,null,null,null,"neff,ax =",{"$f":"(H42*J42)","v":4},"-"]
[]
["lef,2=",{"$f":"IF(P6=1,2*B40+(H42-1)*H46,$B$40+($H$43-1)*$H$46+MIN($B$40,$H$47))","v":460},"mm"]
["a1,min=",{"$f":"IF(B38=8,40,IF(B38=10,50,60))","v":40},"mm","→",null,null,"a1,min=",60,"mm"]
["a1,CG,min=",{"$f":"B46","v":40},"mm",null,null,null,"a1,CG,min=",60,"mm"]
[]
[null,null,null,null,null,null,null,null,null,"segue"]
[]
[]
[]
[]
[]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '18",null,null,null,null,null,null,"INSTABILITA'"]
[]
[]
[]
[]
["kmod =",{"$f":"B23","v":0.9},"-",null,null,null,"kmod =",{"$f":"H23","v":0.9},"-",null,null,null,null,"ch =",{"$f":"(0.19+0.012*$B$38)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13)))*((90+$E$35)/180)","v":110.11000000000001},"MPa"]
["gconn =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gconn =",{"$f":"Prescrizioni!$F$3","v":1.5},"-",null,null,null,null,"Nk,i =",{"$f":"($O$61*210000*PI()*$B$39^4/64)^0.5/10^3","v":28.808103276965067},"kN"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-",null,null,null,null,"Npl,k =",{"$f":"PI()/4*$B$39^2*$B$37/10^3","v":20.175308021353651},"kN"]
["gm1 =",1.1000000000000001,"-",null,null,null,"gm1 =",1.1000000000000001,"-",null,null,null,null,"lk =",{"$f":"(O63/O62)^0.5","v":0.83685989255088367},"-"]
["Rax,90°,Rd =",{"$f":"($B$36*(B$38)*$B$40/(1.2*(COS($O$35))^2+(SIN($O$35))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B61/B62","v":15.660462487475602},"kN",null,null,null,"Rax,90°,Rd =",{"$f":"($B$36*(B$38)*$B$40/(1.2*(COS($O$35))^2+(SIN($O$35))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H61/H62","v":13.572400822478855},"kN",null,null,null,null,"kc =",{"$f":"IF(O64^2<=0.2,1,1/(O66+(O66^2-O64^2)^0.5))","v":0.63903610492392371},"-"]
["Npl,d =",{"$f":"PI()/4*$B$39^2*$B$37/10^3*1/B64","v":18.341189110321498},"kN",null,null,null,"Npl,d =",{"$f":"PI()/4*$B$39^2*$B$37/10^3*1/B64","v":18.341189110321498},"kN",null,null,null,null,"k =",{"$f":"0.5*(1+0.49*(O64-0.2)+O64^2)","v":1.0061979135551047}]
["kc =",{"$f":"O65","v":0.63903610492392371},"-",null,null,null,"kc =",{"$f":"O65","v":0.63903610492392371},"-"]
["Rax,Rd =",{"$f":"MIN(B65,B66*B67)","v":11.720682048732936},"kN",null,null,null,"Rax,Rd =",{"$f":"MIN(H65,H66*H67)","v":11.720682048732936},"kN"]
[]
["Rc,90,A =",{"$f":"$B$19*$B$8*$B$20*B25/10^3+$H$43*B68","v":140.48272819493172},"kN",null,null,null,"Rc,90,A =",{"$f":"$B$19*$B$8*$B$20*H25/10^3+$H$43*H68","v":127.57238336734554},"kN"]
["Rc,90,B =",{"$f":"$B$8*$B$45*B25/10^3","v":165.59999999999997},"kN",null,null,null,"Rc,90,B =",{"$f":"$B$8*$B$45*H25/10^3","v":142.75862068965515},"kN"]
[]
["Rc,90,d =",{"$f":"MIN(B70:B71)","v":140.48272819493172},"kN",null,null,null,"Rc,90,d =",{"$f":"MIN(H70:H71)","v":127.57238336734554},"kN"]
[{"$f":"IF(B73>$B$12,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H73>$B$12,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
[]
[]
[]
["NOTE PER L'UTILIZZO DEL FOGLIO"]
[]
["1) La presente relazione di calcolo è stata redatta in conformità alle normative vigenti alla data della stessa."]
["2) I parametri caratteristici delle viti sono in accordo a ETA 12/0373."]
["3) Il dimensionamento e la verifica degli elementi lignei devono svolgersi separatamente."]
["4) La presente relazione di calcolo non costituisce documento esecutivo e dovrà essere sempre conformata dal Vs. tecnico responsabile delle strutture o da tecnico abilitato."]
[]
["5) I calcoli qui riportati dovranno essere IN OGNI CASO controllati e approvati dal Vostro tecnico responsabile delle strutture. "]
[]
["6) La società Roofrox Srl declina ogni responsabilità per utilizzi impropri del presente software di calcolo. "]
["7) Il presente foglio non può essere modificato e/o distributo in alcun modo senza il consenso scritto di RoofRox Srl."]

{"sheet":"CONNESSIONI INCLINATE","index":3,"n_rows":109,"n_cols":22,"rows_kept":109,"cut":false,"hidden":false,"merged":[[4,0,5,9],[6,0,6,9],[18,0,18,9],[53,0,53,4],[84,0,84,4],[27,4,27,5],[58,0,58,9],[63,4,63,5],[29,3,29,8],[30,3,30,8],[31,3,31,8],[32,3,32,8],[98,0,98,9],[33,12,33,16],[57,0,57,2],[57,6,57,8],[90,0,90,9],[89,0,89,2],[89,6,89,8],[65,3,65,8],[66,3,66,8],[67,3,67,8],[68,3,68,8],[103,0,104,9],[105,0,106,9]]}
[]
[]
[]
[]
["VERIFICHE SULLE CONNESSIONI"]
[]
["DATI DI PROGETTO"]
["B =",160,"mm"]
["H =",360,"mm"]
["b =",120,"mm"]
["h =",200,"mm"]
["p = ",30,"%"]
["b =",{"$f":"DEGREES(ATAN(B12/100))","v":16.699244233993621},"[°]",null,null,null,null,null,null,null,null,null,null,"alfa rad",{"$f":"ATAN(B12/100)","v":0.2914567944778671},"rad"]
["Fc,90,d =",6,"kN",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tipologia inserimento viti"]
["Legno =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lunghezze efficaci filetti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",{"$f":"E28","v":45},"alfa"]
[{"$f":"IF(Q15=2,\"VERIFICA A TAGLIO A LATO DELLA TRAVE DI COLMO (viti posizionate a filo bordo superiore)\",\"VERIFICA A TAGLIO A LATO DELLA TRAVE DI COLMO (viti posizionate nel centro del piano di taglio)\")","v":"VERIFICA A TAGLIO A LATO DELLA TRAVE DI COLMO (viti posizionate nel centro del piano di taglio)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",{"$f":"B13","v":16.699244233993621},"beta"]
[]
["EN 1995:2014",null,null,null,null,null,"NTC '18",null,null,null,null,null,null,null,null,null,"h",{"$f":"B11","v":200}]
["kmod =",0.9,"-",null,null,null,"kmod =",{"$f":"B22","v":0.9},"-",null,null,null,null,null,null,null,"Ltot",{"$f":"B34","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L1",{"$f":"(R21/2)/(SIN(RADIANS(R18+R19)))","v":113.57556200179538},null,null,"L2",{"$f":"(R21/2)*(1/TAN(RADIANS(R18+R19)))/(COS(RADIANS(R18-R19)))","v":61.156071847120586}]
["Scelta connettore:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L3",{"$f":"R22-R23","v":86.424437998204624},null,null,"L4",{"$f":"R22-V23","v":138.84392815287941}]
[]
[]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,45,null,null,null,null,null,null,null,null,"alfa rad",{"$f":"RADIANS(E28)","v":0.78539816339744828},"rad"]
[]
["fax,k,90° =",{"$f":"IF(Viti!$S$4=1,VLOOKUP(Viti!$T$4,Viti!$B$5:$P$24,15),VLOOKUP(Viti!$T$4,Viti!$B$25:$P$45,15))","v":13.1},"MPa",{"$f":"IF($Q$16=1,IF(B34/2*COS(O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF(R24*2^0.5/2<=B8,\"\",\"- larghezza trave principale non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF($Q$16=1,IF(B34/2*COS(O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/COS(O13),0),\" mm\")),IF(R24*2^0.5/2<=B8,\"\",CONCATENATE(ROUND(R24+R23,0),\" mm\")))","v":""}]
["fy,k =",950,"MPa",{"$f":"IF($Q$15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF((R24+V24)*2^0.5/2<=B9,\"\",\"- altezza trave principale non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/SIN(RADIANS(45)-O13),0),\" mm\")),IF((R24+V24)*2^0.5/2<=B9,\"\",CONCATENATE(ROUND(R23+R24,0),\" mm\")))","v":""}]
["d =",{"$f":"IF(Viti!$S$4=1,VLOOKUP(Viti!$T$4,Viti!$B$5:$P$24,8),VLOOKUP(Viti!$T$4,Viti!$B$25:$P$45,8))","v":8},"mm",{"$f":"IF($Q$15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",\"- base trave non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF($Q$15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",CONCATENATE(ROUND(4/2^0.5*B8,0),\" mm\")),\"\")","v":""}]
["d1 =",{"$f":"IF(Viti!$S$4=1,VLOOKUP(Viti!$T$4,Viti!$B$5:$P$24,7),VLOOKUP(Viti!$T$4,Viti!$B$25:$P$45,7))","v":5.2},"mm",{"$f":"IF($Q$15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF($Q$15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",CONCATENATE(ROUND(2/2^0.5*B11/(COS(RADIANS(45)-O13)),0),\" mm\")),\"\")","v":""}]
["LVite =",{"$f":"IF(Viti!$S$4=1,VLOOKUP(Viti!$T$4,Viti!$B$5:$P$24,10),VLOOKUP(Viti!$T$4,Viti!$B$25:$P$45,10))","v":200},"mm",null,null,null,null,null,null,null,null,null,"Connettori impiegati:       →",null,null,null,null,null,"n0 =",1,"n90 =",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neff,ax =",{"$f":"T34^0.9*V34","v":3},"-"]
["kmod =",{"$f":"B22","v":0.9},"-",null,null,null,"kmod =",{"$f":"H22","v":0.9},"-"]
["gL =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gL =",{"$f":"Prescrizioni!$F$3","v":1.5},"-",null,null,null,null,"INSTABILITA'"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-",null,null,null,null,"ch =",{"$f":"(0.19+0.012*$B$32)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13)))*((90+90)/180)","v":110.11000000000001},"MPa"]
["gm1 =",1.1000000000000001,"-",null,null,null,"gm1 =",1.1000000000000001,"-",null,null,null,null,"Nk,i =",{"$f":"($O$38*210000*PI()*$B$33^4/64)^0.5/10^3","v":28.808103276965067},"kN"]
["Rax,90°,Rd,T =",{"$f":"IF(Q15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37,($B$30*(B$32)*($V$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37)","v":7.830231243737801},"kN",null,null,null,"Rax,90°,Rd,T =",{"$f":"IF(Q15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37,($B$30*(B$32)*($V$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37)","v":6.7862004112394274},"kN",null,null,null,null,"Npl,k =",{"$f":"PI()/4*$B$33^2*$B$31/10^3","v":20.175308021353651},"kN"]
["Rax,90°,Rd,C =",{"$f":"IF($Q$15=1,$B$40,($B$30*(B$32)*($R$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37)","v":7.830231243737801},"kN",null,null,null,"Rax,90°,Rd,C =",{"$f":"IF($Q$15=1,$H$40,($B$30*(B$32)*($R$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37)","v":6.7862004112394274},"kN",null,null,null,null,"lk =",{"$f":"(O40/O39)^0.5","v":0.83685989255088367},"-"]
["Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/B39","v":18.341189110321498},"kN",null,null,null,"Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/H39","v":18.341189110321498},"kN",null,null,null,null,"kc =",{"$f":"IF(O41^2<=0.2,1,1/(O43+(O43^2-O41^2)^0.5))","v":0.63903610492392371},"-"]
["kc =",{"$f":"O42","v":0.63903610492392371},"-",null,null,null,"kc =",{"$f":"O42","v":0.63903610492392371},"-",null,null,null,null,"k =",{"$f":"0.5*(1+0.49*(O41-0.2)+O41^2)","v":1.0061979135551047}]
["Rax,Rd,C =",{"$f":"MIN(B41,B42*B43)","v":7.830231243737801},"kN",null,null,null,"Rax,Rd,C =",{"$f":"MIN(H41,H42*H43)","v":6.7862004112394274},"kN"]
[]
["Rc,90,A =",{"$f":"2^0.5/2*(B44+MIN(B44,B40))","v":11.073619221411548},"kN",null,null,null,"VRd =",{"$f":"2^0.5/2*(H44+MIN(H44,H40))","v":9.5971366585566731},"kN"]
[]
[]
[]
[]
[]
[]
[]
["Numero coppie di connettori impiegate:       →",null,null,null,null,null,"ncoppie =",1]
[null,null,null,null,null,null,"neff =",{"$f":"H54^0.9","v":1},"-"]
[]
["Rc,90,d =",{"$f":"H54*MIN(B46:B46)","v":11.073619221411548},"kN",null,null,null,"Rc,90,d =",{"$f":"H54*MIN(H46:H46)","v":9.5971366585566731},"kN"]
[{"$f":"IF(B57>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H57>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
[{"$f":"IF(Q15=2,\"VERIFICA A TAGLIO A LATO DEL TRAVETTO DI FALDA (viti posizionate a filo bordo superiore)\",\"VERIFICA A TAGLIO A LATO DEL TRAVETTO DI FALDA (viti posizionate nel centro del piano di taglio)\")","v":"VERIFICA A TAGLIO A LATO DEL TRAVETTO DI FALDA (viti posizionate nel centro del piano di taglio)"}]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '08"]
["kmod =",{"$f":"H62","v":0.9},"-",null,null,null,"kmod =",{"$f":"H22","v":0.9},"-"]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,45]
[]
["fax,k,90° =",{"$f":"B30","v":13.1},"MPa",{"$f":"IF(Q15=1,IF(B34/2*COS(O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF(V23*SIN(O28-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*COS(O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/COS(O13),0),\" mm\")),IF(V23*SIN(O28-O13)<=B11/2,\"\",CONCATENATE(ROUND(V23+V24,0),\" mm\")))","v":""}]
["fy,k =",{"$f":"B31","v":950},"MPa",{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/SIN(RADIANS(45)-O13),0),\" mm\")),\"\")","v":""}]
["d =",{"$f":"B32","v":8},"mm",{"$f":"IF(Q15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",\"- base trave non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",CONCATENATE(ROUND(4/2^0.5*B8,0),\" mm\")),\"\")","v":""}]
["d1 =",{"$f":"B33","v":5.2},"mm",{"$f":"IF(Q15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",CONCATENATE(ROUND(2/2^0.5*B11/(COS(RADIANS(45)-O13)),0),\" mm\")),\"\")","v":""}]
["LVite =",{"$f":"B34","v":200},"mm"]
[]
["kmod =",{"$f":"B62","v":0.9},"-",null,null,null,"kmod =",{"$f":"H62","v":0.9},"-"]
["gL =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gL =",{"$f":"Prescrizioni!$F$3","v":1.5},"-",null,null,null,null,"INSTABILITA'"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-",null,null,null,null,"ch =",{"$f":"(0.19+0.012*$B$32)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13)))*((90+$E$28+$B$13)/180)","v":92.797798792250219},"MPa"]
["gm1 =",1.1000000000000001,"-",null,null,null,"gm2 =",1.1000000000000001,"-",null,null,null,null,"Nk,i =",{"$f":"($O$74*210000*PI()*$B$33^4/64)^0.5/10^3","v":26.446616726655616},"kN"]
["Rax,90°,Rd,T =",{"$f":"IF($Q$15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73,($B$30*(B$32)*($V$23)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73)","v":6.7791517519254976},"kN",null,null,null,"Rax,90°,Rd,T =",{"$f":"IF(Q15=1,($B$30*$O$82*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73,($B$30*$O$82*(B$32)*($V$23)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73)","v":4.3490706763756428},"kN",null,null,null,null,"Npl,k =",{"$f":"PI()/4*$B$33^2*$B$31/10^3","v":20.175308021353651},"kN"]
["Rax,90°,Rd,C =",{"$f":"IF($Q$15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)+$O$13))^2+(SIN(RADIANS(45)+$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73,($B$30*(B$32)*($R$23)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73)","v":7.493373183208254},"kN",null,null,null,"Rax,90°,Rd,C =",{"$f":"IF($Q$15=1,($B$30*$O$83*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)+$O$13))^2+(SIN(RADIANS(45)+$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73,($B$30*$O$83*(B$32)*($R$23)/(1.2*(COS(RADIANS(45)+$O$13))^2+(SIN(RADIANS(45)+$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73)","v":6.4942567587804874},"kN",null,null,null,null,"lk =",{"$f":"(O76/O75)^0.5","v":0.87342380889885152},"-"]
["Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/B75","v":18.341189110321498},"kN",null,null,null,"Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/H75","v":18.341189110321498},"kN",null,null,null,null,"kc =",{"$f":"IF(O77^2<=0.2,1,1/(O79+(O79^2-O77^2)^0.5))","v":0.61624430598154478},"-"]
["kc =",{"$f":"O78","v":0.61624430598154478},"-",null,null,null,"kc =",{"$f":"O78","v":0.61624430598154478},"-",null,null,null,null,"k =",{"$f":"0.5*(1+0.49*(O77-0.2)+O77^2)","v":1.0464234081559074}]
["Rax,Rd,C =",{"$f":"MIN(B77,B78*B79)","v":7.493373183208254},"kN",null,null,null,"Rax,Rd,C =",{"$f":"MIN(H77,H78*H79)","v":6.4942567587804874},"kN"]
[]
["Rc,90,A =",{"$f":"2^0.5/2*(2*MIN(B80,B76))","v":9.5871683489583663},"kN",null,null,null,"VRd =",{"$f":"2^0.5/2*(2*MIN(H80,H76))","v":6.1505147342495645},"kN",null,null,null,null,"kax,t",{"$f":"IF((E64-B13)<45,0.3+0.7*(E64-B13)/45,1)","v":0.74023397858232143},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"kax,c",{"$f":"IF((E64+B13)<45,0.3+0.7*(E64+B13)/45,1)","v":1}]
[]
["Numero coppie di connettori impiegate:       →",null,null,null,null,null,"ncoppie =",{"$f":"H54","v":1}]
[null,null,null,null,null,null,"neff =",{"$f":"H55","v":1},"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"a1,min =",{"$f":"5*B68","v":40},"mm",{"$f":"IF((2*H92+O87*H85)<=B10,\"OK\",\"NO\")","v":"OK"}]
[]
["Rc,90,d =",{"$f":"H86*MIN(B82:B82)","v":9.5871683489583663},"kN",null,null,null,"Rc,90,d =",{"$f":"H86*MIN(H82:H82)","v":6.1505147342495645},"kN"]
[{"$f":"IF(B89>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H89>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
["VERIFICA DELLE DISTANZE MINIME"]
["a1,CG,min =",{"$f":"B93","v":40},"mm",{"$f":"IF(B92<=R23*COS(RADIANS(R18+R19))+R21/2*TAN(RADIANS(R19)),\"OK\",\"NO\")","v":"OK"},null,null,"a2,CG,min =",{"$f":"4*B68","v":32},"mm",{"$f":"IF((2*H92+H93*H85)<=B10,\"OK\",\"NO\")","v":"OK"},null,null,null,null,{"$f":"R23*COS(RADIANS(R18+R19))+R21/2*TAN(RADIANS(R19))","v":83.84615384615384}]
["a2,min =",{"$f":"O87","v":40},"mm",null,null,null,"a2,red =",{"$f":"2.5*B68","v":20},"mm",{"$f":"J92","v":"OK"},null,null,null,null,{"$f":"IF(H54=1,B10/2-H93/2,10000)","v":50}]
[]
[]
[]
[]
[]
["NOTE PER L'UTILIZZO DEL FOGLIO"]
[]
["1) La presente relazione di calcolo è stata redatta in conformità alle normative vigenti alla data della stessa."]
["2) I parametri caratteristici delle viti sono in accordo a ETA 12/0373."]
["3) Il dimensionamento e la verifica degli elementi lignei devono svolgersi separatamente."]
["4) La presente relazione di calcolo non costituisce documento esecutivo e dovrà essere sempre conformata dal Vs. tecnico responsabile delle strutture o da tecnico abilitato."]
[]
["5) I calcoli qui riportati dovranno essere IN OGNI CASO controllati e approvati dal Vostro tecnico responsabile delle strutture. "]
[]
["6) La società Roofrox Srl declina ogni responsabilità per utilizzi impropri del presente software di calcolo. "]
["7) Il presente foglio non può essere modificato e/o distributo in alcun modo senza il consenso scritto di RoofRox Srl."]

{"sheet":"CONNESSIONI PIANE","index":4,"n_rows":110,"n_cols":22,"rows_kept":110,"cut":false,"hidden":false,"merged":[[106,0,107,9],[29,3,29,8],[30,3,30,8],[31,3,31,8],[32,3,32,8],[65,3,65,8],[66,3,66,8],[67,3,67,8],[68,3,68,8],[99,0,99,9],[90,0,90,9],[104,0,105,9],[33,12,33,16],[53,0,53,4],[57,0,57,2],[57,6,57,8],[84,0,84,4],[58,0,58,9],[63,4,63,5],[4,0,5,9],[6,0,6,9],[18,0,18,9],[27,4,27,5],[89,0,89,2],[89,6,89,8]]}
[]
[]
[]
[]
["VERIFICHE SULLE CONNESSIONI"]
[]
["DATI DI PROGETTO"]
["B =",200,"mm"]
["H =",440,"mm",null,null,null,null,null,null,null,null,null,null,null,null,4.26]
["b =",120,"mm",null,null,null,null,null,null,null,null,null,null,null,null,2.84]
["h =",200,"mm",null,null,null,null,null,null,null,null,null,null,null,null,1.79]
["p = ",0,"%",null,null,null,null,null,null,null,null,null,null,null,null,3.29]
["b =",{"$f":"DEGREES(ATAN(B12/100))","v":0},"[°]",null,null,null,null,null,null,null,null,null,null,"alfa rad",{"$f":"ATAN(B12/100)","v":0},5.08]
["VEd =",19,"kN",null,null,null,null,null,null,null,null,null,null,null,null,3.09,"Tipologia inserimento viti"]
["Legno =",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.99,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lunghezze efficaci filetti"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",{"$f":"E28","v":45}]
[{"$f":"IF(Q15=2,\"VERIFICA A TAGLIO A LATO DELLA TRAVE (viti posizionate a filo bordo superiore)\",\"VERIFICA A TAGLIO A LATO DELLA TRAVE (viti posizionate nel centro del piano di taglio)\")","v":"VERIFICA A TAGLIO A LATO DELLA TRAVE (viti posizionate a filo bordo superiore)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",{"$f":"B13","v":0}]
[]
["EN 1995:2014",null,null,null,null,null,"NTC '18",null,null,null,null,null,null,null,null,null,"h",{"$f":"B11","v":200}]
["kmod =",0.9,"-",null,null,null,"kmod =",{"$f":"B22","v":0.9},"-",null,null,null,null,null,null,null,"Ltot",{"$f":"B34","v":280}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L1",{"$f":"(R21/2)/(SIN(RADIANS(R18+R19)))","v":141.42135623730951},null,null,"L2",{"$f":"(R21/2)*1/TAN((RADIANS(R18+R19)))/(COS(RADIANS(R18-R19)))","v":141.42135623730951}]
["Scelta connettore:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L3",{"$f":"R22-R23","v":138.57864376269049},null,null,"L4",{"$f":"R22-V23","v":138.57864376269049}]
[]
[]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,45,null,null,null,null,null,null,null,null,"alfa rad",{"$f":"RADIANS(E28)","v":0.78539816339744828},"rad"]
[]
["fax,k,90° =",{"$f":"IF(Viti2!$S$4=1,VLOOKUP(Viti2!$T$4,Viti2!$B$5:$P$24,15),VLOOKUP(Viti2!$T$4,Viti2!$B$25:$P$45,15))","v":13.1},"MPa",{"$f":"IF($Q$16=1,IF(B34/2*COS(O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF(R24*2^0.5/2<=B8,\"\",\"- larghezza trave principale non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF($Q$16=1,IF(B34/2*COS(O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/COS(O13),0),\" mm\")),IF(R24*2^0.5/2<=B8,\"\",CONCATENATE(ROUND(R24+R23,0),\" mm\")))","v":""}]
["fy,k =",950,"MPa",{"$f":"IF($Q$15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF((R24+V24)*2^0.5/2<=B9,\"\",\"- altezza trave principale non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/SIN(RADIANS(45)-O13),0),\" mm\")),IF((R24+V24)*2^0.5/2<=B9,\"\",CONCATENATE(ROUND(R23+R24,0),\" mm\")))","v":""}]
["d =",{"$f":"IF(Viti2!$S$4=1,VLOOKUP(Viti2!$T$4,Viti2!$B$5:$P$24,8),VLOOKUP(Viti2!$T$4,Viti2!$B$25:$P$45,8))","v":8},"mm",{"$f":"IF($Q$15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",\"- base trave non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF($Q$15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",CONCATENATE(ROUND(4/2^0.5*B8,0),\" mm\")),\"\")","v":""}]
["d1 =",{"$f":"IF(Viti2!$S$4=1,VLOOKUP(Viti2!$T$4,Viti2!$B$5:$P$24,7),VLOOKUP(Viti2!$T$4,Viti2!$B$25:$P$45,7))","v":5.2},"mm",{"$f":"IF($Q$15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF($Q$15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",CONCATENATE(ROUND(2/2^0.5*B11/(COS(RADIANS(45)-O13)),0),\" mm\")),\"\")","v":""}]
["LVite =",{"$f":"IF(Viti2!$S$4=1,VLOOKUP(Viti2!$T$4,Viti2!$B$5:$P$24,10),VLOOKUP(Viti2!$T$4,Viti2!$B$25:$P$45,10))","v":280},"mm",null,null,null,null,null,null,null,null,null,"Connettori impiegati:       →",null,null,null,null,null,"n0 =",1,"n90 =",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"neff,ax =",{"$f":"T34^0.9*V34","v":3},"-"]
["kmod =",{"$f":"B22","v":0.9},"-",null,null,null,"kmod =",{"$f":"H22","v":0.9},"-"]
["gconn =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gconn =",{"$f":"Prescrizioni!$F$3","v":1.5},"-",null,null,null,null,"INSTABILITA'"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-",null,null,null,null,"ch =",{"$f":"(0.19+0.012*$B$32)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13)))*((90+$E$28+45)/180)","v":110.11000000000001},"MPa"]
["gm1 =",1.1000000000000001,"-",null,null,null,"gm1 =",1.1000000000000001,"-",null,null,null,null,"Nk,i =",{"$f":"($O$38*210000*PI()*$B$33^4/64)^0.5/10^3","v":28.808103276965067},"kN"]
["Fax,T,90°,Rd =",{"$f":"IF(Q15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37,($B$30*(B$32)*($V$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37)","v":10.851028261054292},"kN",null,null,null,"Fax,T,90°,Rd =",{"$f":"IF(Q15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37,($B$30*(B$32)*($V$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37)","v":9.4042244929137198},"kN",null,null,null,null,"Npl,k =",{"$f":"PI()/4*$B$33^2*$B$31/10^3","v":20.175308021353651},"kN"]
["Fax,C,90°,Rd =",{"$f":"IF($Q$15=1,$B$40,($B$30*(B$32)*($R$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B36/B37)","v":10.851028261054292},"kN",null,null,null,"Fax,C,90°,Rd =",{"$f":"IF($Q$15=1,$H$40,($B$30*(B$32)*($R$24)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H36/H37)","v":9.4042244929137198},"kN",null,null,null,null,"lk =",{"$f":"(O40/O39)^0.5","v":0.83685989255088367},"-"]
["Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/B39","v":18.341189110321498},"kN",null,null,null,"Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/H39","v":18.341189110321498},"kN",null,null,null,null,"kc =",{"$f":"IF(O41^2<=0.2,1,1/(O43+(O43^2-O41^2)^0.5))","v":0.63903610492392371},"-"]
["χ =",{"$f":"O42","v":0.63903610492392371},"-",null,null,null,"χ =",{"$f":"O42","v":0.63903610492392371},"-",null,null,null,null,"k =",{"$f":"0.5*(1+0.49*(O41-0.2)+O41^2)","v":1.0061979135551047}]
["Fax,Rd =",{"$f":"MIN(B41,B42*B43)","v":10.851028261054292},"kN",null,null,null,"Fax,Rd =",{"$f":"MIN(H41,H42*H43)","v":9.4042244929137198},"kN"]
[]
["VRd =",{"$f":"2^0.5/2*(B44+MIN(B44,B40))","v":15.345671332476723},"kN",null,null,null,"VRd =",{"$f":"2^0.5/2*(H44+MIN(H44,H40))","v":13.299581821479826},"kN"]
[]
[]
[]
[]
[]
[]
[]
["Numero coppie di connettori impiegate:       →",null,null,null,null,null,"ncoppie =",2]
[null,null,null,null,null,null,"neff =",{"$f":"H54^0.9","v":1.8660659830736148},"-"]
[]
["Rc,90,d =",{"$f":"H54*MIN(B46:B46)","v":30.691342664953446},"kN",null,null,null,"Rc,90,d =",{"$f":"H54*MIN(H46:H46)","v":26.599163642959653},"kN"]
[{"$f":"IF(B57>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H57>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"}]
[{"$f":"A19","v":"VERIFICA A TAGLIO A LATO DELLA TRAVE (viti posizionate a filo bordo superiore)"}]
[]
["EN 1995:2008",null,null,null,null,null,"NTC '18"]
["kmod =",{"$f":"B22","v":0.9},"-",null,null,null,"kmod =",{"$f":"B62","v":0.9},"-"]
[]
["Angolo inserimento connettore:    a [°] =",null,null,null,45]
[]
["fax,k,90° =",{"$f":"B30","v":13.1},"MPa",{"$f":"IF(Q15=1,IF(B34/2*COS(O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),IF(V23*SIN(O28-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"))","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*COS(O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/COS(O13),0),\" mm\")),IF(V23*SIN(O28-O13)<=B11/2,\"\",CONCATENATE(ROUND(V23+V24,0),\" mm\")))","v":""}]
["fy,k =",{"$f":"B31","v":950},"MPa",{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*SIN(RADIANS(45)-O13)<=B11/2,\"\",CONCATENATE(ROUND(B11/SIN(RADIANS(45)-O13),0),\" mm\")),\"\")","v":""}]
["d =",{"$f":"B32","v":8},"mm",{"$f":"IF(Q15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",\"- base trave non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B34/2*(2^0.5)/2<=B8,\"\",CONCATENATE(ROUND(4/2^0.5*B8,0),\" mm\")),\"\")","v":""}]
["d1 =",{"$f":"B33","v":5.2},"mm",{"$f":"IF(Q15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",\"- altezza travetto non adatta alla vite: L vite <=\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(Q15=1,IF(B35/2*(2^0.5)/2<=B11/2*1/(COS(RADIANS(45)-O13)),\"\",CONCATENATE(ROUND(2/2^0.5*B11/(COS(RADIANS(45)-O13)),0),\" mm\")),\"\")","v":""}]
["LVite =",{"$f":"B34","v":280},"mm"]
[]
["kmod =",{"$f":"B62","v":0.9},"-",null,null,null,"kmod =",{"$f":"H62","v":0.9},"-"]
["gL =",{"$f":"Prescrizioni!$F$4","v":1.3},"-",null,null,null,"gL =",{"$f":"Prescrizioni!$F$3","v":1.5},"-",null,null,null,null,"INSTABILITA'"]
["gm2 =",1.25,"-",null,null,null,"gm2 =",1.25,"-",null,null,null,null,"ch =",{"$f":"(0.19+0.012*$B$32)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13)))*((90+$E$28+$B$13)/180)","v":82.58250000000001},"MPa"]
["gm1 =",1.1000000000000001,"-",null,null,null,"gm2 =",1.1000000000000001,"-",null,null,null,null,"Nk,i =",{"$f":"($O$74*210000*PI()*$B$33^4/64)^0.5/10^3","v":24.94854927269748},"kN"]
["Fax,T,90°,Rd =",{"$f":"IF($Q$15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73,($B$30*(B$32)*($V$23)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73)","v":11.073619221411544},"kN",null,null,null,"Fax,T,90°,Rd =",{"$f":"IF(Q15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73,($B$30*(B$32)*($V$23)/(1.2*(COS(RADIANS(45)-$O$13))^2+(SIN(RADIANS(45)-$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*H72/H73)","v":8.7246696895969738},"kN",null,null,null,null,"Npl,k =",{"$f":"PI()/4*$B$33^2*$B$31/10^3","v":20.175308021353651},"kN"]
["Fax,C,90°,Rd =",{"$f":"IF($Q$15=1,($B$30*(B$32)*($B$34/2)/(1.2*(COS(RADIANS(45)+$O$13))^2+(SIN(RADIANS(45)+$O$13))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73,($B$30*(B$32)*($R$23)/(1.2*(COS(RADIANS(90)))^2+(SIN(RADIANS(90)))^2)/10^3)*((VLOOKUP(Materiali!$B$33,Materiali!$B$5:$O$32,13))/350)^0.8*B72/B73)","v":11.073619221411544},"kN",null,null,null,"Fax,C,90°,Rd =",{"$f":"H76","v":8.7246696895969738},"kN",null,null,null,null,"lk =",{"$f":"(O76/O75)^0.5","v":0.89926447768425977},"-"]
["Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/B75","v":18.341189110321498},"kN",null,null,null,"Npl,d =",{"$f":"PI()/4*$B$33^2*$B$31/10^3*1/H75","v":18.341189110321498},"kN",null,null,null,null,"kc =",{"$f":"IF(O77^2<=0.2,1,1/(O79+(O79^2-O77^2)^0.5))","v":0.60028276976468897},"-"]
["χ =",{"$f":"O78","v":0.60028276976468897},"-",null,null,null,"χ =",{"$f":"O78","v":0.60028276976468897},"-",null,null,null,null,"k =",{"$f":"0.5*(1+0.49*(O77-0.2)+O77^2)","v":1.0756580974450158}]
["Fax,Rd =",{"$f":"MIN(B77,B78*B79)","v":11.00989979992174},"kN",null,null,null,"Fax,Rd =",{"$f":"MIN(H77,H78*H79)","v":8.7246696895969738},"kN"]
[]
["VRd =",{"$f":"2^0.5/2*(2*MIN(B80,B76))","v":15.570349617418152},"kN",null,null,null,"VRd =",{"$f":"2^0.5/2*(2*MIN(H80,H76))","v":12.338546202253502},"kN"]
[]
[]
["Numero coppie di connettori impiegate:       →",null,null,null,null,null,"ncoppie =",{"$f":"H54","v":2}]
[null,null,null,null,null,null,"neff =",{"$f":"H55","v":1.8660659830736148},"-"]
[]
[]
["Rc,90,d =",{"$f":"H86*MIN(B82:B82)","v":29.055299765627286},"kN",null,null,null,"Rc,90,d =",{"$f":"H86*MIN(H82:H82)","v":23.024541348607396},"kN"]
[{"$f":"IF(B89>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,{"$f":"IF(H89>$B$14,\"VERIFICA SODDISFATTA\",\"VERIFICA NON SODDISFATTA\")","v":"VERIFICA SODDISFATTA"},null,null,null,null,null,null,null,"a1,min =",{"$f":"5*B68","v":40},"mm",{"$f":"IF((2*H92+P90*H85)<=B10,\"OK\",\"NO\")","v":"NO"}]
["VERIFICA DELLE DISTANZE MINIME"]
["a1,CG =",{"$f":"B93","v":40},"mm",{"$f":"IF(B92<=R23*SIN(RADIANS(B13+E28)),\"OK\",\"NO\")","v":"OK"},null,null,"a2,CG =",{"$f":"4*B68","v":32},"mm",{"$f":"IF((2*H92+H93*H85)<=B10,\"OK\",\"NO\")","v":"OK"}]
["a2,min =",{"$f":"P90","v":40},"mm",null,null,null,"a2,red =",{"$f":"2.5*B68","v":20},"mm",{"$f":"J92","v":"OK"},null,null,null,{"$f":"R23*SIN(RADIANS(B13+E28))","v":100}]
[]
[]
[]
[]
[]
[]
["NOTE PER L'UTILIZZO DEL FOGLIO"]
[]
["1) La presente relazione di calcolo è stata redatta in conformità alle normative vigenti alla data della stessa."]
["2) I parametri caratteristici delle viti sono in accordo a ETA 12/0373."]
["3) Il dimensionamento e la verifica degli elementi lignei devono svolgersi separatamente."]
["4) La presente relazione di calcolo non costituisce documento esecutivo e dovrà essere sempre conformata dal Vs. tecnico responsabile delle strutture o da tecnico abilitato."]
[]
["5) I calcoli qui riportati dovranno essere IN OGNI CASO controllati e approvati dal Vostro tecnico responsabile delle strutture. "]
[]
["6) La società Roofrox Srl declina ogni responsabilità per utilizzi impropri del presente software di calcolo. "]
["7) Il presente foglio non può essere modificato e/o distributo in alcun modo senza il consenso scritto di RoofRox Srl."]

{"sheet":"Foglio2","index":5,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"a",45]
[null,null,null,null,"b",0]
[]
[null,null,null,null,"h",200]
[null,null,null,null,"Ltot",280]
[null,null,null,null,"L1",{"$f":"(F19/2)/(SIN(RADIANS(F16+F17)))","v":141.42135623730951},null,null,"L2",{"$f":"(F19/2)*_xlfn.COT(RADIANS(F16+F17))/(COS(RADIANS(F16-F17)))","v":{"$error":"#NAME?"}}]
[null,null,null,null,"L3",{"$f":"F20-F21","v":138.57864376269049},null,null,"L4",{"$f":"F20-J21","v":{"$error":"#NAME?"}}]

{"sheet":"Materiali","index":6,"n_rows":135,"n_cols":24,"rows_kept":135,"cut":false,"hidden":true,"merged":[[81,2,81,12],[105,2,105,12]]}
[]
[null,null,"Resistenze legno lamellare di conifera omogeneo e combinato (EN 1194: 1999)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barre d'armatura"]
[null,null,null,"[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[kg/mc]","[kg/mc]"]
[null,"CONT",null,"fm,g,k","ft,0,g,k","ft,90,g,k","fc,0,g,k","fc,90,g,k","fv,g,k","E0,g,mean","E0,g,05","E90,g,mean","Gg,mean","rg,k","rm",null,null,null,null,null,null,"CONT","fi","A"]
[null,1,"GL20h",20,16,0.5,20,2.5,3.5,8400,7000,300,650,340,370,null,null,null,null,null,null,1,10,{"$f":"PI()*W5^2/4","v":78.539816339744831}]
[null,{"$f":"B5+1","v":2},"GL20c",20,15,0.5,18.5,2.5,3.5,10400,8600,300,250,355,390,null,null,null,null,null,null,2,12,{"$f":"PI()*W6^2/4","v":113.09733552923255}]
[null,{"$f":"B6+1","v":3},"GL22h",22,17.600000000000001,0.5,22,2.5,3.5,10500,8800,300,650,370,410,"uni en 14080:2013",null,null,null,null,null,3,14,{"$f":"PI()*W7^2/4","v":153.93804002589985}]
[null,4,"GL22c",22,16,0.5,20,2.5,3.5,10400,8600,300,650,355,390,"uni en 14080:2013",null,null,null,null,null,4,16,{"$f":"PI()*W8^2/4","v":201.06192982974676}]
[null,5,"GL24h",24,19.2,0.5,24,2.5,3.5,11500,9600,300,650,385,420,"uni en 14080:2013",null,null,null,null,null,2]
[null,6,"GL24c",24,17,0.5,21.5,2.5,3.5,11000,9100,300,650,365,400,"uni en 14080:2013"]
[null,7,"GL26h",26,20.8,0.5,26,2.5,3.5,12100,10100,300,650,405,445,"uni en 14080:2013",null,null,null,null,null,"CONT","numeri"]
[null,8,"GL26c",26,19,0.5,23.5,2.5,3.5,12000,10000,300,650,385,420,"uni en 14080:2013",null,null,null,null,null,1,0]
[null,9,"GL28h",28,22.3,0.5,28,2.5,3.5,{"$f":"12.6*1000","v":12600},10500,300,650,425,460,"uni en 14080:2013",null,null,null,null,null,2,1]
[null,10,"GL28c",28,19.5,0.5,24,2.5,3.5,12500,10400,300,650,390,420,"uni en 14080:2013",null,null,null,null,null,3,2]
[null,11,"GL30h",30,24,0.5,30,2.5,3.5,13600,11300,300,650,430,480,"uni en 14080:2013",null,null,null,null,null,1]
[null,12,"GL30c",30,19.5,0.5,24.5,2.5,3.5,13000,10800,300,650,390,430,"uni en 14080:2013"]
[null,13,"GL32h",32,25.6,0.5,32,2.5,3.5,14200,11800,300,650,440,490,"uni en 14080:2013"]
[null,14,"GL32c",32,19.5,0.5,24.5,2.5,3.5,13700,11200,300,650,400,440,"uni en 14080:2013"]
[null,15,"C14",14,8,0.4,16,2,1.7,{"$f":"7*1000","v":7000},{"$f":"4.7*1000","v":4700},{"$f":"0.23*1000","v":230},{"$f":"0.44*1000","v":440},290,350,"prEN 338: 2002"]
[null,16,"C16",16,10,0.5,17,2.2000000000000002,1.8,{"$f":"8*1000","v":8000},{"$f":"5.4*1000","v":5400},{"$f":"0.27*1000","v":270},{"$f":"0.5*1000","v":500},310,370,"prEN 338: 2002"]
[null,17,"C18",18,11,0.5,18,2.2000000000000002,2,{"$f":"9*1000","v":9000},{"$f":"6*1000","v":6000},{"$f":"0.3*1000","v":300},{"$f":"0.56*1000","v":560},320,380,"prEN 338: 2002"]
[null,18,"C20",20,12,0.5,19,2.2999999999999998,2.2000000000000002,{"$f":"9.5*1000","v":9500},{"$f":"6.4*1000","v":6400},{"$f":"0.32*1000","v":320},{"$f":"0.59*1000","v":590},330,390,"prEN 338: 2002"]
[null,19,"C22",22,13,0.5,20,2.4,2.4,{"$f":"10*1000","v":10000},{"$f":"6.7*1000","v":6700},{"$f":"0.33*1000","v":330},{"$f":"0.63*1000","v":630},340,410,"prEN 338: 2002"]
[null,20,"C24",24,14,0.5,21,2.5,2.5,{"$f":"11*1000","v":11000},{"$f":"7.4*1000","v":7400},{"$f":"0.37*1000","v":370},{"$f":"0.69*1000","v":690},350,420,"prEN 338: 2002"]
[null,21,"C27",27,16,0.6,22,2.6,2.8,{"$f":"11.5*1000","v":11500},{"$f":"7.7*1000","v":7700},{"$f":"0.38*1000","v":380},{"$f":"0.72*1000","v":720},370,450,"prEN 338: 2002"]
[null,22,"C30",30,18,0.6,23,2.7,3,{"$f":"12*1000","v":12000},{"$f":"8*1000","v":8000},{"$f":"0.4*1000","v":400},{"$f":"0.75*1000","v":750},380,460,"prEN 338: 2002"]
[null,23,"C35",35,21,0.6,25,2.8,3.4,{"$f":"13*1000","v":13000},{"$f":"8.7*1000","v":8700},{"$f":"0.43*1000","v":430},{"$f":"0.81*1000","v":810},400,480,"prEN 338: 2002"]
[null,24,"C40",40,24,0.6,26,2.9,3.8,{"$f":"14*1000","v":14000},{"$f":"9.4*1000","v":9400},{"$f":"0.47*1000","v":470},{"$f":"0.88*1000","v":880},420,500,"prEN 338: 2002"]
[null,25,"C45",45,27,0.6,27,3.1,3.8,{"$f":"15*1000","v":15000},{"$f":"10*1000","v":10000},{"$f":"0.5*1000","v":500},{"$f":"0.94*1000","v":940},440,520,"prEN 338: 2002"]
[null,26,"C50",50,30,0.6,29,3.2,3.8,{"$f":"16*1000","v":16000},{"$f":"10.7*1000","v":10700},{"$f":"0.53*1000","v":530},{"$f":"1*1000","v":1000},460,550,"prEN 338: 2002"]
[null,27,"D24",24,14,0.6,21,7.8,4,10000,8500,{"$f":"0.67*1000","v":670},{"$f":"0.62*1000","v":620},485,580]
[null,28,"D30",30,18,0.6,23,8,4,11000,9200,730,690,530,"-"]
[null,5,null,"[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[kg/mc]","[kg/mc]"]
[null,null,null,"fm,g,k","ft,0,g,k","ft,90,g,k","fc,0,g,k","fc,90,g,k","fv,g,k","E0,g,mean","E0,g,05","E90,g,mean","Gg,mean","rg,k","rm"]
[null,null,"Resistenze legno di confiere e di pioppo (prEN 338: 2002)"]
[]
[]
[]
[]
[null,null,null,"[N/mmq]","[N/mmq]","[N/mmq]","[N/mmq]","[kN/mc]","[-]","[-]","[-]"]
[null,"CONT",null,"fc,k","Rc,k","ft,k","Ecls",null,"h1","h2","hE",null,null,null,"CONT",null,"rete","mm2/m","Passo tondi","Area tondo"]
[null,1,"C20/25",20,25,{"$f":"0.7*(0.3*D42^(2/3))","v":1.5472932294289619},{"$f":"22*(0.083*E42+0.8)^0.3*1000","v":30200.493207846379},25,"-","-","-",null,null,null,1,"6 mm/10x10","Æ6/10x10",{"$f":"((100/10)*PI()*(0.6^2)/4)*100","v":282.74333882308139},100,{"$f":"PI()*6^2/4","v":28.274333882308138}]
[null,{"$f":"B42+1","v":2},"C25/30",25,30,1.7954747440105308,31447.161439943484,25,"-","-","-",null,null,null,2,"6 mm/15x15","Æ6/15x15",{"$f":"((100/15)*PI()*(0.6^2)/4)*100","v":188.49555921538757},150,{"$f":"T42","v":28.274333882308138}]
[null,{"$f":"B43+1","v":3},"C28/35",28,35,1.9363832426645466,32588.107818695284,25,"-","-","-",null,null,null,3,"6 mm/20x20","Æ6/20x20",{"$f":"(100/20)*PI()*(0.6^2)/4*100","v":141.37166941154069},200,{"$f":"T43","v":28.274333882308138}]
[null,4,"C30/37",30,37,2.0275277076718221,33019.434581752503,25,"-","-","-",null,null,null,4,"8 mm/10x10","Æ8/10x10",{"$f":"(100/10)*PI()*(0.8^2)/4*100","v":502.65482457436701},100,{"$f":"PI()*8^2/4","v":50.26548245743669}]
[null,5,"C32/40",32,40,2.1166673638233866,33642.777677364676,25,"-","-","-",null,null,null,5,"8 mm/15x15","Æ8/15x15",{"$f":"(100/15)*PI()*(0.8^2)/4*100","v":335.10321638291134},150,{"$f":"T45","v":50.26548245743669}]
[null,6,"C35/40",35,40,2.2469737091866655,33642.777677364676,25,"-","-","-",null,null,null,6,"8 mm/20x20","Æ8/20x20",{"$f":"(100/20)*PI()*(0.8^2)/4*100","v":251.32741228718351},200,{"$f":"T46","v":50.26548245743669}]
[null,7,"Leca CLS 1400 - LC 20/22",20,22,{"$f":"0.7*(I48*0.3*D48^(2/3))","v":1.2730003387574642},15000,15.5,{"$f":"0.4+0.6*H48*100/2200","v":0.82272727272727275},1,{"$f":"(H48*100/2200)^2","v":0.49638429752066121},null,null,null,2]
[null,8,"Leca CLS 1600 - LC 31.5/35",31.5,35,{"$f":"0.7*(I49*0.3*D49^(2/3))","v":1.837501174905334},20000,17.5,{"$f":"0.4+0.6*H49*100/2200","v":0.87727272727272732},1,{"$f":"(H49*100/2200)^2","v":0.63274793388429751}]
[null,9,"Leca CLS 1800 - LC 40.5/45",40.5,45,{"$f":"0.7*(I50*0.3*D50^(2/3))","v":2.3077414845141737},25000,19.5,{"$f":"0.4+0.6*H50*100/2200","v":0.93181818181818188},1,{"$f":"(H50*100/2200)^2","v":0.78564049586776863}]
[null,2]
[]
[]
[]
[null,null,null,"mm","mm","mm","N/mm","mm","mm","mm","mm","mm","mm","mm","mm","mm","Nmm","mm","N/mm2","kN"]
[null,"CONT",null,"fi","Ltot","Lfilettata","Kser","Lsp","toll","P","toll","di","toll","Lm","def","Lef","Myk","ds","fax,k,90","ftens,k"]
[null,1,"T-CON 8.0x155",8,158.85,100,7700,8.1999999999999993,2.1,5.6,0.56000000000000005,5.3,0.26,{"$f":"SUM($H$57:$K$57)","v":16.459999999999997},{"$f":"1.1*$L$57","v":5.83},100,22600,5.9,10.7,22.7]
[null,2,"T-CON 8.0x205",8,208.85,130,9000,8.1999999999999993,2.1,5.6,0.56000000000000005,5.3,0.26,{"$f":"SUM($H$57:$K$57)","v":16.459999999999997},{"$f":"1.1*$L$57","v":5.83},100,22600,5.9,10.7,22.7]
[null,2]
[]
[null,null,"Densità legname per il tavolato"]
[null,null,null,"[kg/mc]","[kg/mc]","[mm]"]
[null,"CONT",null,"rg,k","rm","sp"]
[null,1,"Legno di Conifera C16",550]
[null,{"$f":"B64+1","v":2},"Legno di Conifera C24",550]
[null,{"$f":"B65+1","v":3},"Legno di Latifoglia D35",550]
[null,4,"Legno di Latifoglia D30",550]
[null,5,"Legno di Latifoglia D24",550]
[null,6,"Pannello OSB",550]
[null,7,"Pannello fibrogesso A1 - sp. 10 mm",1150,null,10]
[null,8,"Pannello fibrogesso A1 - sp. 12,5 mm",1200,null,12.5]
[null,9,"Pannello fibrogesso A1 - sp. 15 mm",1200,null,15]
[null,10,"Pannello fibrogesso A1 - sp. 18 mm",1166.6666666000001,null,18]
[null,11,"Tavella in laterizio sp. 3,5 cm",null,null,35]
[null,12,"Tavella in laterizio sp. 5 cm",null,null,50]
[null,13,"Pianella in laterizio sp. 4,0 cm",1800,null,40]
[null,14,"Pianella in laterizio sp. 3,0 cm",1800,null,30]
[null,15,"Pianella in laterizio sp. 2,6 cm",1800,null,26]
[null,16,"Pianella in laterizio sp. 1,6 cm",1800,null,16]
[null,2]
[]
[null,null,"CONSTRUCT - TC"]
[null,"CONT","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90"]
[null,1,{"$f":"CONCATENATE($C$82,\" - \",D84)","v":"CONSTRUCT - TC - 8x120"},"8x120","01408120",5.9,5.2,8,10.199999999999999,120,110,1000,0,24.1,13.1]
[null,{"$f":"B84+1","v":2},{"$f":"CONCATENATE($C$82,\" - \",D85)","v":"CONSTRUCT - TC - 8x140"},"8x140","01408140",5.9,5.2,8,10.199999999999999,140,130,1000,0,24.1,13.1]
[null,{"$f":"B85+1","v":3},"CONSTRUCT - TC - 8x160","8x160","01408160",5.9,5.2,8,10.199999999999999,160,150,1000,0,24.1,13.1]
[null,4,"CONSTRUCT - TC - 8x180","8x180","01408180",5.9,5.2,8,10.199999999999999,180,170,1000,0,24.1,13.1]
[null,5,"CONSTRUCT - TC - 8x200","8x200","01408200",5.9,5.2,8,10.199999999999999,200,190,1000,0,24.1,13.1]
[null,6,"CONSTRUCT - TC - 8x220","8x220","01408220",5.9,5.2,8,10.199999999999999,220,210,1000,0,24.1,13.1]
[null,7,"CONSTRUCT - TC - 8x240","8x240","01408240",5.9,5.2,8,10.199999999999999,240,230,1000,0,24.1,13.1]
[null,8,"CONSTRUCT - TC - 8x260","8x260","01408260",5.9,5.2,8,10.199999999999999,260,250,1000,0,24.1,13.1]
[null,9,"CONSTRUCT - TC - 8x280","8x280","01408280",5.9,5.2,8,10.199999999999999,280,270,1000,0,24.1,13.1]
[null,10,"CONSTRUCT - TC - 8x300","8x300","01408300",5.9,5.2,8,10.199999999999999,300,290,1000,0,24.1,13.1]
[null,11,"CONSTRUCT - TC - 8x350","8x350","01408350",5.9,5.2,8,10.199999999999999,350,340,1000,0,24.1,13.1]
[null,12,"CONSTRUCT - TC - 8x400","8x400","01408400",5.9,5.2,8,10.199999999999999,400,390,1000,0,24.1,13.1]
[null,13,"CONSTRUCT - TC - 8x450","8x450","01408450",5.9,5.2,8,10.199999999999999,450,428,1000,0,24.1,13.1]
[null,14,"CONSTRUCT - TC - 8x500","8x500","01408500",5.9,5.2,8,10.199999999999999,500,478,1000,0,24.1,13.1]
[null,15,"CONSTRUCT - TC - 8x600","8x600","01408600",5.9,5.2,8,10.199999999999999,600,578,1000,0,24.1,13.1]
[null,16,"CONSTRUCT - TC - 10x450","10x450","01410450",7.1,6.1,10,13.4,450,426,1000,0,40,12.5]
[null,17,"CONSTRUCT - TC - 10x500","10x500","01410500",7.1,6.1,10,13.4,500,476,1000,0,40,12.5]
[null,18,"CONSTRUCT - TC - 10x600","10x600","01410600",7.1,6.1,10,13.4,600,576,1000,0,40,12.5]
[null,19,"CONSTRUCT - TC - 10x800","10x800","01410800",7.1,6.1,10,13.4,800,776,1000,0,40,12.5]
[null,20,"CONSTRUCT - TC - 10x1000","10x1000","01411000",7.1,6.1,10,13.4,1000,976,1000,0,40,12.5]
[null,13]
[]
[null,null,"CONSTRUCT - TS"]
[null,"CONT","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90"]
[null,1,{"$f":"CONCATENATE($C$106,\" - \",D108)","v":"CONSTRUCT - TS - 8x160"},"8x160","01580160",5.9,5.2,8,15,160,150,950,0,24.1,13.1]
[null,{"$f":"B108+1","v":2},{"$f":"CONCATENATE($C$106,\" - \",D109)","v":"CONSTRUCT - TS - 8x200"},"8x200","01580200",5.9,5.2,8,15,200,190,950,0,24.1,13.1]
[null,{"$f":"B109+1","v":3},"CONSTRUCT - TS - 8x240","8x240","01580240",5.9,5.2,8,15,240,230,950,0,24.1,13.1]
[null,4,"CONSTRUCT - TS - 8x280","8x280","01580280",5.9,5.2,8,15,280,270,950,0,24.1,13.1]
[null,5,"CONSTRUCT - TS - 8x300","8x300","01580300",5.9,5.2,8,15,300,290,950,0,24.1,13.1]
[null,6,"CONSTRUCT - TS - 8x350","8x350","01580350",5.9,5.2,8,15,350,340,950,0,24.1,13.1]
[null,7,"CONSTRUCT - TS - 8x400","8x400","01580400",5.9,5.2,8,15,400,390,950,0,24.1,13.1]
[null,8,"CONSTRUCT - TS - 8x450","8x450","01580450",5.9,5.2,8,15,450,428,950,0,24.1,13.1]
[null,9,"CONSTRUCT - TS - 8x500","8x500","01580500",5.9,5.2,8,15,500,478,950,0,24.1,13.1]
[null,10,"CONSTRUCT - TS - 10x160","10x160","01510160",7.1,6.1,10,18.5,160,148,950,0,40,12.5]
[null,11,"CONSTRUCT - TS - 10x200","10x200","01510200",7.1,6.1,10,18.5,200,188,950,0,40,12.5]
[null,12,"CONSTRUCT - TS - 10x240","10x240","01510240",7.1,6.1,10,18.5,240,228,950,0,40,12.5]
[null,13,"CONSTRUCT - TS - 10x300","10x300","01510300",7.1,6.1,10,18.5,300,288,950,0,40,12.5]
[null,14,"CONSTRUCT - TS - 10x350","10x350","01510350",7.1,6.1,10,18.5,350,338,950,0,40,12.5]
[null,15,"CONSTRUCT - TS - 10x400","10x400","01510400",7.1,6.1,10,18.5,400,388,950,0,40,12.5]
[null,16,"CONSTRUCT - TS - 10x450","10x450","01510450",7.1,6.1,10,18.5,450,426,950,0,40,12.5]
[null,17,"CONSTRUCT - TS - 10x500","10x500","01510500",7.1,6.1,10,18.5,500,476,950,0,40,12.5]
[null,18,"CONSTRUCT - TS - 10x600","10x600","01510600",7.1,6.1,10,18.5,600,576,950,0,40,12.5]
[null,19,"CONSTRUCT - TS - 12x400","12x400","01510400",8.1999999999999993,6.8,12,21,400,380,950,0,46.5,11.2]
[null,20,"CONSTRUCT - TS - 12x500","12x500","01510500",8.1999999999999993,6.8,12,21,500,480,950,0,46.5,11.2]
[null,21,"CONSTRUCT - TS - 12x600","12x600","01510600",8.1999999999999993,6.8,12,21,600,580,950,0,46.5,11.2]
[null,7]
[]
[]
[null,"CONT"]
[null,1,"Vite a testa cilindrica"]
[null,{"$f":"B133+1","v":2},"Vite a testa svasata"]
[null,2]

{"sheet":"Viti","index":7,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Construct TC"]
[null,null,null,null,null,null,null,null,null,"Construct TS",null,null,null,null,null,null,null,null,"INDICE 1","INDICE 2"]
[null,"CONT2","Gruppo","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90",null,null,1,5,null,null,"CONT"]
[null,{"$f":"IF($S$4=1,W5,0)","v":1},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E5)","v":"Construct TC - 8x120"},"8x120","01408120",5.9,5.2,8,10.199999999999999,120,110,1000,0,24.1,13.1,null,null,{"$f":"+INDEX(V5:V6,S4)","v":"Vite Testa Cilindrica"},{"$f":"+INDEX(Y5:Y45,T4)","v":"Construct TC - 8x200"},null,"Vite Testa Cilindrica",1,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W5,0,1))","v":"Construct TC - 8x120"},{"$f":"IF(X5=\"#N/D\",\"\",+IF(ISERROR(X5),\"\",X5))","v":"Construct TC - 8x120"}]
[null,{"$f":"IF($S$4=1,W6,0)","v":2},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E6)","v":"Construct TC - 8x140"},"8x140","01408140",5.9,5.2,8,10.199999999999999,140,130,1000,0,24.1,13.1,null,null,null,null,null,"Vite Testa Svasata",{"$f":"W5+1","v":2},{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W6,0,1))","v":"Construct TC - 8x140"},{"$f":"IF(X6=\"#N/D\",\"\",+IF(ISERROR(X6),\"\",X6))","v":"Construct TC - 8x140"}]
[null,3,"Vite Testa Cilindrica","Construct TC - 8x160","8x160","01408160",5.9,5.2,8,10.199999999999999,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,{"$f":"W6+1","v":3},{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W7,0,1))","v":"Construct TC - 8x160"},"Construct TC - 8x160"]
[null,4,"Vite Testa Cilindrica","Construct TC - 8x180","8x180","01408180",5.9,5.2,8,10.199999999999999,180,170,1000,0,24.1,13.1,null,null,null,null,null,null,4,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W8,0,1))","v":"Construct TC - 8x180"},"Construct TC - 8x180"]
[null,5,"Vite Testa Cilindrica","Construct TC - 8x200","8x200","01408200",5.9,5.2,8,10.199999999999999,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,5,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W9,0,1))","v":"Construct TC - 8x200"},"Construct TC - 8x200"]
[null,6,"Vite Testa Cilindrica","Construct TC - 8x220","8x220","01408220",5.9,5.2,8,10.199999999999999,220,210,1000,0,24.1,13.1,null,null,null,null,null,null,6,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W10,0,1))","v":"Construct TC - 8x220"},"Construct TC - 8x220"]
[null,7,"Vite Testa Cilindrica","Construct TC - 8x240","8x240","01408240",5.9,5.2,8,10.199999999999999,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,7,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W11,0,1))","v":"Construct TC - 8x240"},"Construct TC - 8x240"]
[null,8,"Vite Testa Cilindrica","Construct TC - 8x260","8x260","01408260",5.9,5.2,8,10.199999999999999,260,250,1000,0,24.1,13.1,null,null,null,null,null,null,8,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W12,0,1))","v":"Construct TC - 8x260"},"Construct TC - 8x260"]
[null,9,"Vite Testa Cilindrica","Construct TC - 8x280","8x280","01408280",5.9,5.2,8,10.199999999999999,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,9,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W13,0,1))","v":"Construct TC - 8x280"},"Construct TC - 8x280"]
[null,10,"Vite Testa Cilindrica","Construct TC - 8x300","8x300","01408300",5.9,5.2,8,10.199999999999999,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,10,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W14,0,1))","v":"Construct TC - 8x300"},"Construct TC - 8x300"]
[null,11,"Vite Testa Cilindrica","Construct TC - 8x350","8x350","01408350",5.9,5.2,8,10.199999999999999,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,11,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W15,0,1))","v":"Construct TC - 8x350"},"Construct TC - 8x350"]
[null,12,"Vite Testa Cilindrica","Construct TC - 8x400","8x400","01408400",5.9,5.2,8,10.199999999999999,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,12,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W16,0,1))","v":"Construct TC - 8x400"},"Construct TC - 8x400"]
[null,13,"Vite Testa Cilindrica","Construct TC - 8x450","8x450","01408450",5.9,5.2,8,10.199999999999999,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,13,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W17,0,1))","v":"Construct TC - 8x450"},"Construct TC - 8x450"]
[null,14,"Vite Testa Cilindrica","Construct TC - 8x500","8x500","01408500",5.9,5.2,8,10.199999999999999,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,14,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W18,0,1))","v":"Construct TC - 8x500"},"Construct TC - 8x500"]
[null,15,"Vite Testa Cilindrica","Construct TC - 8x600","8x600","01408600",5.9,5.2,8,10.199999999999999,600,578,1000,0,24.1,13.1,null,null,null,null,null,null,15,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W19,0,1))","v":"Construct TC - 8x600"},"Construct TC - 8x600"]
[null,16,"Vite Testa Cilindrica","Construct TC - 10x450","10x450","01410450",7.1,6.1,10,13.4,450,426,1000,0,40,12.5,null,null,null,null,null,null,16,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W20,0,1))","v":"Construct TC - 10x450"},"Construct TC - 10x450"]
[null,17,"Vite Testa Cilindrica","Construct TC - 10x500","10x500","01410500",7.1,6.1,10,13.4,500,476,1000,0,40,12.5,null,null,null,null,null,null,17,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W21,0,1))","v":"Construct TC - 10x500"},"Construct TC - 10x500"]
[null,18,"Vite Testa Cilindrica","Construct TC - 10x600","10x600","01410600",7.1,6.1,10,13.4,600,576,1000,0,40,12.5,null,null,null,null,null,null,18,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W22,0,1))","v":"Construct TC - 10x600"},"Construct TC - 10x600"]
[null,19,"Vite Testa Cilindrica","Construct TC - 10x800","10x800","01410800",7.1,6.1,10,13.4,800,776,1000,0,40,12.5,null,null,null,null,null,null,19,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W23,0,1))","v":"Construct TC - 10x800"},"Construct TC - 10x800"]
[null,20,"Vite Testa Cilindrica","Construct TC - 10x1000","10x1000","01411000",7.1,6.1,10,13.4,1000,976,1000,0,40,12.5,null,null,null,null,null,null,20,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W24,0,1))","v":"Construct TC - 10x1000"},"Construct TC - 10x1000"]
[null,{"$f":"IF($S$4=1,0,W5)","v":0},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E25)","v":"Construct TS - 8x160"},"8x160","01580160",5.9,5.2,8,15,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,21,{"$f":"IF(AND($S$4=2,'CONNESSIONI INCLINATE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W25,0,1))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,{"$f":"IF($S$4=1,0,W6)","v":0},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E26)","v":"Construct TS - 8x200"},"8x200","01580200",5.9,5.2,8,15,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,22,{"$f":"+nlookup($C$5:$D$45,$S$5,W26,0,1)","v":{"$error":"#N/A"}},{"$f":"+IF(ISERROR(X26),\"\",X26)","v":""}]
[null,0,"Vite Testa Svasata","Construct TS - 8x240","8x240","01580240",5.9,5.2,8,15,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,23,{"$f":"+nlookup($C$5:$D$45,$S$5,W27,0,1)","v":{"$error":"#N/A"}},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x280","8x280","01580280",5.9,5.2,8,15,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,24,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x300","8x300","01580300",5.9,5.2,8,15,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,25,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x350","8x350","01580350",5.9,5.2,8,15,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,26,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x400","8x400","01580400",5.9,5.2,8,15,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,27,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x450","8x450","01580450",5.9,5.2,8,15,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,28,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x500","8x500","01580500",5.9,5.2,8,15,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,29,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x160","10x160","01510160",7.1,6.1,10,18.5,160,148,1000,0,40,12.5,null,null,null,null,null,null,30,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x200","10x200","01510200",7.1,6.1,10,18.5,200,188,1000,0,40,12.5,null,null,null,null,null,null,31,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x240","10x240","01510240",7.1,6.1,10,18.5,240,228,1000,0,40,12.5,null,null,null,null,null,null,32,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x300","10x300","01510300",7.1,6.1,10,18.5,300,288,1000,0,40,12.5,null,null,null,null,null,null,33,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x350","10x350","01510350",7.1,6.1,10,18.5,350,338,1000,0,40,12.5,null,null,null,null,null,null,34,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x400","10x400","01510400",7.1,6.1,10,18.5,400,388,1000,0,40,12.5,null,null,null,null,null,null,35,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x450","10x450","01510450",7.1,6.1,10,18.5,450,426,1000,0,40,12.5,null,null,null,null,null,null,36,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x500","10x500","01510500",7.1,6.1,10,18.5,500,476,1000,0,40,12.5,null,null,null,null,null,null,37,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x600","10x600","01510600",7.1,6.1,10,18.5,600,576,1000,0,40,12.5,null,null,null,null,null,null,38,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x400","12x400","01510400",8.1999999999999993,6.8,12,21,400,380,1000,0,46.5,11.2,null,null,null,null,null,null,39,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x500","12x500","01510500",8.1999999999999993,6.8,12,21,500,480,1000,0,46.5,11.2,null,null,null,null,null,null,40,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x600","12x600","01510600",8.1999999999999993,6.8,12,21,600,580,1000,0,46.5,11.2,null,null,null,null,null,null,41,{"$error":"#N/A"},""]
[null,0]
[]
[]
[null,null,null,{"$f":"IF(Viti!S4=1,VLOOKUP(Viti!T4,Viti!B5:P24,15),VLOOKUP(Viti!T4,Viti!B25:P45,15))","v":13.1}]

{"sheet":"Prescrizioni","index":8,"n_rows":197,"n_cols":14,"rows_kept":197,"cut":false,"hidden":true,"merged":[]}
[null,"Normative di riferimento"]
[null,"CONT",null,"Lamellare","Massicio","Unioni"]
[null,1,"D.M. 14.01.2008",1.45,1.5,1.5]
[null,2,"UNI EN 1995-1-1:2014",1.25,1.3,1.3]
[null,1]
[]
[]
[null,"LIMITI PER SOLAI DI COPERTURA",null,null,null,null,"(riferiti per luce L in pianta)"]
[null,"limite freccia istantanea sui (soli) carichi variabili",null,null,null,null,"qk:","u2,ist < L / ",300]
[null,"limite freccia finale sui (soli) carichi variabili",null,null,null,null,"qk:","u2,fin < L / ",200]
[null,"limite freccia netta (finale) su tutti i carichi:",null,null,null,null,"gk e qk:","unet,fin < L / ",200]
[]
[]
[null,"LIMITI PER SOLAI di interpiano (consigliati)",null,null,null,null,"(riferiti per luce L in pianta)"]
[null,"limite freccia istantanea sui (soli) carichi variabili",null,null,null,null,"qk:","u2,ist < L /",400]
[null,"limite freccia finale sui (soli) carichi variabili",null,null,null,null,"qk:","u2,fin < L /",500]
[null,"limite freccia netta (finale) su tutti i carichi:",null,null,null,null,"gk e qk:","unet,fin < L /",500]
[]
[]
[]
[null,"CONT","Azione","Q","y0,j ","y1,j ","y2,j "]
[null,1,"Cat. A: Amb. ad uso residenziale",2,0.7,0.5,0.3]
[null,2,"Cat. B: Uffici",2,0.7,0.5,0.3]
[null,3,"Cat. C: Amb. suscettibili di affollamento",4,0.7,0.7,0.6]
[null,4,"Cat. D: Amb. ad uso commerciale",5,0.7,0.7,0.6]
[null,5,"Cat. E: Biblioteche, archivi, ...",6,1,0.9,0.8]
[null,6,"Neve (a quota < 1000 m)",1.2,0.5,0.2,0]
[null,7,"Neve (a quota > 1000 m)",1.2,0.7,0.5,0.2]
[null,8,"Coperture",0.5,0,0,0]
[null,1]
[]
[]
[]
[null,"Valori di \"kdef\" per i prodotti strutturali a base di legno (EN 1995-1-1/D.M.14.01.2008)"]
[]
[]
[null,"Materiale ","rif.","CONT","Classe servizio","kdef"]
[null,"LM","EN 14081-1",1,1,0.6]
[null,"LL",null,2,2,0.8]
[null,null,null,3,3,2]
[null,null,"valore attuale",1," <-- classe serv."]
[]
[]
[null,"Valori di \"kmod\" per i prodotti strutturali a base di legno (EN 1995-1-1/D.M.14.01.2008)"]
[]
[null,"Materiale ","rif.","CONT","Classe servizio","permanente","Lunga","Media","Breve","Istantaneo"]
[null,"LM","EN 14081-1",1,1,0.6,0.7,0.8,0.9,1.1000000000000001]
[null,"LL",null,2,2,0.6,0.7,0.8,0.9,1.1000000000000001]
[null,null,null,3,3,0.5,0.55000000000000004,0.65,0.7,0.9]
[null,null,"valore attuale",{"$f":"D41","v":1}," <-- classe serv."]
[]
[null,null,null,"CONT"]
[null,null,null,1,"Permanente",{"$f":"VLOOKUP($D$50,$D$47:$J$49,3)","v":0.6}]
[null,null,null,2,"Lunga",{"$f":"VLOOKUP($D$50,$D$47:$J$49,4)","v":0.7}]
[null,null,null,3,"Media",{"$f":"VLOOKUP($D$50,$D$47:$J$49,5)","v":0.8}]
[null,null,null,4,"Breve",{"$f":"VLOOKUP($D$50,$D$47:$J$49,6)","v":0.9}]
[null,null,null,5,"Istantaneo",{"$f":"VLOOKUP($D$50,$D$47:$J$49,7)","v":1.1000000000000001}]
[null,null,null,3]
[]
[]
[null,null,"ANGOLI",null,null,"AMMORSAMENTO",null,null,null,"Valore minimo passo minimo",null,null,100,"mm"]
[null,"CONT",null,null,"CONT"]
[null,1,45,null,1,0]
[null,2,90,null,2,{"$f":"F63+1","v":1}]
[null,1,null,null,{"$f":"E64+1","v":3},{"$f":"F64+1","v":2}]
[null,null,null,null,{"$f":"E65+1","v":4},3]
[null,null,null,null,5,4]
[null,null,null,null,6,5]
[null,null,null,null,7,6]
[null,null,null,null,8,7]
[null,null,null,null,9,8]
[null,null,null,null,10,9]
[null,null,null,null,11,10]
[null,null,null,null,12,{"$f":"IF(B65=2,\"-\",11)","v":11}]
[null,null,null,null,13,{"$f":"IF(B65=2,\"-\",12)","v":12}]
[null,null,null,null,14,{"$f":"IF(B65=2,\"-\",13)","v":13}]
[null,null,null,null,15,{"$f":"IF(B65=2,\"-\",14)","v":14}]
[null,null,null,null,15]
[]
[]
[null,"Valori di pendenza, angoli e moltiplicatori di falda"]
[null,null,"pendenza","angolo","angolo","moltiplicatore"]
[null,"CONT","%","°","rad","-",null,null,null,null,null,"CONT","TIPO G1"]
[null,1,0,{"$f":"DEGREES(ATAN(C84/100))","v":0},{"$f":"RADIANS(D84)","v":0},{"$f":"(1^2+(C84/100)^2)^0.5","v":1},null,null,null,null,null,1,"AUTOMATICO"]
[null,{"$f":"B84+1","v":2},{"$f":"B84","v":1},0.57293869768348593,{"$f":"RADIANS(D85)","v":9.9996666866652376E-3},1.0000499987500624,null,null,null,null,null,2,"VALORE UTENTE"]
[null,{"$f":"B85+1","v":3},2,1.1457628381751035,1.9997333973150535E-2,1.0001999800039989,null,null,null,null,null,1]
[null,4,3,1.7183580016554572,2.99910048568779E-2,1.0004498987955368]
[null,5,4,2.2906100426385296,3.9978687123290044E-2,1.0007996802557444]
[null,6,5,2.8624052261117479,4.9958395721942765E-2,1.0012492197250393]
[null,7,6,3.433630362450522,5.9928155121207881E-2,1.0017983829094554]
[null,8,7,4.0041729407093882,6.9886001634642508E-2,1.0024470060806208]
[null,9,8,4.5739212599008612,7.9829985712237317E-2,1.0031948963187562]
[null,10,9,5.1427645578842416,8.9758174189950524E-2,1.004041831797859]
[null,11,10,5.710593137499643,9.9668652491162038E-2,1.004987562112089]
[null,12,11,6.2772984895975545,0.10955952677394434,1.0060318086422517]
[null,13,12,6.8427734126309403,0.11942892601833845,1.0071742649611337]
[null,14,13,7.4069121284952297,0.12927500404814307,1.0084145972763385]
[null,15,14,7.9696103943213599,0.13909594148207133,1.0097524449091471]
[null,16,15,8.5307656099481335,0.14888994760949725,1.0111874208078342]
[null,17,16,9.0902769208223226,0.15865526218640141,1.0127191120937731]
[null,18,17,9.6480453160981572,0.16839015714752992,1.014347080638575]
[null,19,18,10.203973721731684,0.17809293823119754,1.016070863670443]
[null,20,19,10.757967088390005,0.18776194651359343,1.0178899744078433]
[null,21,20,11.309932474020215,0.19739555984988078,1.019803902718557]
[null,22,21,11.859779120947978,0.20699219421982101,1.0218121158021176]
[null,23,22,12.407418527400745,0.21655030497608929,1.0239140588936164]
[null,24,23,12.95276451337552,0.22606838799388393,1.0261091559868276]
[null,25,24,13.495733280795811,0.23554498072086333,1.0283968105745953]
[null,26,25,14.036243467926479,0.24497866312686414,1.0307764064044151]
[null,27,26,14.574216198038739,0.25436805855326594,1.0332473082471592]
[null,28,27,15.109575122340466,0.26371183446226615,1.0358088626768938]
[null,29,28,15.642246457208728,0.2730087030867106,1.0384603988597736]
[null,30,29,16.172159015782551,0.28225742198149112,1.0412012293500235]
[null,31,30,{"$f":"DEGREES(ATAN(C114/100))","v":16.699244233993621},0.2914567944778671,1.0440306508910551]
[null,32,31,{"$f":"DEGREES(ATAN(C115/100))","v":17.223436191131462},0.30060567004239541,1.0469479452198185]
[null,33,32,17.744671625056935,0.30970294454245623,1.049952379872535]
[null,34,33,18.262889942194128,0.31874756042064445,1.0530432089900206]
[null,35,34,18.778033222445544,0.32773850678055549,1.0562196741208714]
[null,36,35,19.290046219188735,0.33667481938672722,1.0594810050208545]
[null,37,36,19.798876354524932,0.34555558058171215,1.0628264204469138]
[null,38,37,20.304473709960437,0.3543799191234378,1.0662551289442879]
[null,39,38,20.80679101271123,0.36314700994617627,1.0697663296253066]
[null,40,39,21.305783617828769,0.37185607384858127,1.0733592129385203]
[null,41,40,21.801409486351812,0.3805063771123649,1.077032961426901]
[null,42,41,22.293629159694078,0.38909723105527838,1.0807867504739312]
[null,43,42,22.782405730481688,0.3976279915221293,1.0846197490364999]
[null,44,43,23.267704810056951,0.40609805831761564,1.0885311203635843]
[null,45,44,23.749494492866763,0.41450687458478597,1.0925200226998131]
[null,46,45,24.22774531795417,0.42285392613294071,1.0965856099730655]
[null,47,46,24.702430227771313,0.43113874071878222,1.1007270324653611]
[null,48,47,25.173524524530166,0.43936088728459144,1.1049434374663709]
[null,49,48,25.641005824305282,0.44751997515716985,1.1092339699089637]
[null,50,49,26.104854009099295,0.45561565321122449,1.1135977729862789]
[null,51,50,26.56505117707799,0.46364760900080609,1.1180339887498949]
[null,52,51,27.021581591177039,0.47161556786232767,1.1225417586887358]
[null,53,52,27.474431626277134,0.47951929199259624,1.1271202242884297]
[null,54,53,27.923589715138384,0.48735857950519029,1.1317685275708986]
[null,55,54,28.369046293278583,0.49513326346840414,1.1364858116140297]
[null,56,55,28.810793742973065,0.50284321092786088,1.1412712210513327]
[null,57,56,29.24882633654698,0.51048832191677584,1.1461239025515524]
[null,58,57,29.683140179123296,0.51806852845672091,1.1510430052782563]
[null,59,58,30.113733150982437,0.52558379355161022,1.1560276813294741]
[null,60,59,30.5406048496815,0.53303411017749003,1.1610770861575042]
[null,61,60,30.963756532073521,0.54041950027058416,1.16619037896906]
[null,62,61,31.383191056359031,0.54774001371590242,1.1713667231059623]
[null,63,62,31.798912824294419,0.55499572733858671,1.1766052864066183]
[null,64,63,32.210927723673755,0.56218674390002932,1.1819052415485769]
[null,65,64,32.619243071192827,0.56931319110066192,{"$f":"(1^2+(C148/100)^2)^0.5","v":1.1872657663724664}]
[null,66,{"$f":"B148","v":65},33.023867555796649,{"$f":"RADIANS(D149)","v":0.57637522059118373},1.1926860441876563]
[null,{"$f":"B149+1","v":67},66,33.424811182603804,0.58337300699385597,1.1981652640600127]
[null,68,67,33.822085217493957,0.590306746935372,1.2037026210821342]
[null,69,68,34.215702132437407,0.59717665809267761,1.209297316626478]
[null,70,69,34.605675551638562,0.60398297825299785,1.2149485585818027]
[null,71,70,34.992020198558663,0.61072596438920868,1.2206555615733703]
[null,72,71,35.374751843876084,0.61740589175157279,1.2264175471673584]
[null,73,72,35.753887254436748,0.62402305297675686,1.2322337440599491]
[null,74,73,36.12944414324086,0.63057775721493481,1.2381033882515629]
[null,75,74,36.501441120506314,0.63707032927568352,1.2440257232067189]
[null,76,75,36.86989764584402,0.64350110879328437,1.25]
[null,77,76,37.234833981574667,0.6498704494119476,1.2560254774486066]
[null,78,77,37.596271147211986,0.65617871799139493,1.2621014222319853]
[null,79,78,37.954230875132517,0.66242629383315121,1.2682271089990151]
[null,80,79,38.308735567447719,0.66861356792782101,1.2744018204632321]
[null,81,80,38.659808254090095,0.67474094222355274,1.2806248474865698]
[null,82,81,39.007472552121044,0.68080882891582761,1.2868954891520912]
[null,83,82,39.351752626264734,0.68681764975864523,1.2932130528261767]
[null,84,83,39.692673150668817,0.69276783539712217,1.299576854210631]
[null,85,84,40.030259271889697,0.69865982472146315,1.3059862173851606]
[null,86,85,40.364536573097361,0.70449406424221772,1.3124404748406686]
[null,87,86,40.695531039492018,0.71027100748668626,1.3189389675038037]
[null,88,87,41.023269024922435,0.71599111441630026,1.3254810447531868]
[null,89,88,41.347777219693668,0.72165485086476133,1.3320660644277369]
[null,90,89,41.669082619549954,0.72726268799669036,1.3386933928274989]
[null,91,90,41.987212495816657,0.73281510178650655,1.3453624047073711]
[null,92,91,42.3021943666837,0.73831257251722804,1.3520724832641184]
[null,93,92,42.614055969611186,0.74375558429885991,1.3588230201170424]
[null,94,93,42.922825234837191,0.74914462460601727,1.3656134152826707]
[null,95,94,43.228530259965922,0.75448018383440563,1.372443077143821]
[null,96,95,{"$f":"DEGREES(ATAN(C179/100))","v":43.531199285614179},0.75976275487577083,1.379311422413372]
[null,97,96,43.830860672092584,0.76499283271091023,1.3862178760930766]
[null,98,97,44.127542877097966,0.770170914020331,1.3931618714277247]
[null,99,98,44.421274434392238,0.77529749681212634,1.4001428498549711]
[null,100,99,44.712083933442905,0.78037308006663586,1.4071602609511114]
[null,101,100,45,0.78539816339744828,1.4142135623730951]
[null,1]
[]
[]
[]
[]
[null,"Valori di \"kn\" per intagli"]
[]
[]
[null,"Materiale ","rif.","CONT","kdef"]
[null,"LM","EN 14081-1",1,5]
[null,"LL",null,2,6.5]
[null,"LVL",null,3,4.5]
[null,null,"valore attuale",{"$f":"IF(Materiali!$B$33<=14,2,IF(AND(Materiali!$B$33>14,Materiali!$B$33<=28),1,3))","v":2}," <-- classe serv."]

{"sheet":"Viti2","index":9,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Construct TC"]
[null,null,null,null,null,null,null,null,null,"Construct TS",null,null,null,null,null,null,null,null,"INDICE 1","INDICE 2"]
[null,"CONT2","Gruppo","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90",null,null,2,4,null,null,"CONT"]
[null,{"$f":"IF($S$4=1,W5,0)","v":0},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E5)","v":"Construct TC - 8x120"},"8x120","01408120",5.9,5.2,8,10.199999999999999,120,110,1000,0,24.1,13.1,null,null,{"$f":"+INDEX(V5:V6,S4)","v":"Vite Testa Svasata"},{"$f":"+INDEX(Y5:Y45,T4)","v":"Construct TS - 8x280"},null,"Vite Testa Cilindrica",1,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W5,0,1))","v":"Construct TS - 8x160"},{"$f":"IF(X5=\"#N/D\",\"\",+IF(ISERROR(X5),\"\",X5))","v":"Construct TS - 8x160"}]
[null,{"$f":"IF($S$4=1,W6,0)","v":0},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E6)","v":"Construct TC - 8x140"},"8x140","01408140",5.9,5.2,8,10.199999999999999,140,130,1000,0,24.1,13.1,null,null,null,null,null,"Vite Testa Svasata",{"$f":"W5+1","v":2},{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W6,0,1))","v":"Construct TS - 8x200"},{"$f":"IF(X6=\"#N/D\",\"\",+IF(ISERROR(X6),\"\",X6))","v":"Construct TS - 8x200"}]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x160","8x160","01408160",5.9,5.2,8,10.199999999999999,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,{"$f":"W6+1","v":3},{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W7,0,1))","v":"Construct TS - 8x240"},"Construct TS - 8x240"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x180","8x180","01408180",5.9,5.2,8,10.199999999999999,180,170,1000,0,24.1,13.1,null,null,null,null,null,null,4,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W8,0,1))","v":"Construct TS - 8x280"},"Construct TS - 8x280"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x200","8x200","01408200",5.9,5.2,8,10.199999999999999,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,5,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W9,0,1))","v":"Construct TS - 8x300"},"Construct TS - 8x300"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x220","8x220","01408220",5.9,5.2,8,10.199999999999999,220,210,1000,0,24.1,13.1,null,null,null,null,null,null,6,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W10,0,1))","v":"Construct TS - 8x350"},"Construct TS - 8x350"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x240","8x240","01408240",5.9,5.2,8,10.199999999999999,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,7,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W11,0,1))","v":"Construct TS - 8x400"},"Construct TS - 8x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x260","8x260","01408260",5.9,5.2,8,10.199999999999999,260,250,1000,0,24.1,13.1,null,null,null,null,null,null,8,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W12,0,1))","v":"Construct TS - 8x450"},"Construct TS - 8x450"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x280","8x280","01408280",5.9,5.2,8,10.199999999999999,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,9,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W13,0,1))","v":"Construct TS - 8x500"},"Construct TS - 8x500"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x300","8x300","01408300",5.9,5.2,8,10.199999999999999,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,10,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W14,0,1))","v":"Construct TS - 10x160"},"Construct TS - 10x160"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x350","8x350","01408350",5.9,5.2,8,10.199999999999999,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,11,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W15,0,1))","v":"Construct TS - 10x200"},"Construct TS - 10x200"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x400","8x400","01408400",5.9,5.2,8,10.199999999999999,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,12,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W16,0,1))","v":"Construct TS - 10x240"},"Construct TS - 10x240"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x450","8x450","01408450",5.9,5.2,8,10.199999999999999,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,13,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W17,0,1))","v":"Construct TS - 10x300"},"Construct TS - 10x300"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x500","8x500","01408500",5.9,5.2,8,10.199999999999999,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,14,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W18,0,1))","v":"Construct TS - 10x350"},"Construct TS - 10x350"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x600","8x600","01408600",5.9,5.2,8,10.199999999999999,600,578,1000,0,24.1,13.1,null,null,null,null,null,null,15,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W19,0,1))","v":"Construct TS - 10x400"},"Construct TS - 10x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x450","10x450","01410450",7.1,6.1,10,13.4,450,426,1000,0,40,12.5,null,null,null,null,null,null,16,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W20,0,1))","v":"Construct TS - 10x450"},"Construct TS - 10x450"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x500","10x500","01410500",7.1,6.1,10,13.4,500,476,1000,0,40,12.5,null,null,null,null,null,null,17,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W21,0,1))","v":"Construct TS - 10x500"},"Construct TS - 10x500"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x600","10x600","01410600",7.1,6.1,10,13.4,600,576,1000,0,40,12.5,null,null,null,null,null,null,18,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W22,0,1))","v":"Construct TS - 10x600"},"Construct TS - 10x600"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x800","10x800","01410800",7.1,6.1,10,13.4,800,776,1000,0,40,12.5,null,null,null,null,null,null,19,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W23,0,1))","v":"Construct TS - 12x400"},"Construct TS - 12x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x1000","10x1000","01411000",7.1,6.1,10,13.4,1000,976,1000,0,40,12.5,null,null,null,null,null,null,20,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W24,0,1))","v":"Construct TS - 12x500"},"Construct TS - 12x500"]
[null,{"$f":"IF($S$4=1,0,W5)","v":1},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E25)","v":"Construct TS - 8x160"},"8x160","01580160",5.9,5.2,8,15,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,21,{"$f":"IF(AND($S$4=2,'CONNESSIONI PIANE'!$Q$15=1),\"#N/D\",+nlookup($C$5:$D$45,$S$5,W25,0,1))","v":"Construct TS - 12x600"},"Construct TS - 12x600"]
[null,{"$f":"IF($S$4=1,0,W6)","v":2},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E26)","v":"Construct TS - 8x200"},"8x200","01580200",5.9,5.2,8,15,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,22,{"$f":"+nlookup($C$5:$D$45,$S$5,W26,0,1)","v":{"$error":"#N/A"}},{"$f":"+IF(ISERROR(X26),\"\",X26)","v":""}]
[null,3,"Vite Testa Svasata","Construct TS - 8x240","8x240","01580240",5.9,5.2,8,15,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,23,{"$f":"+nlookup($C$5:$D$45,$S$5,W27,0,1)","v":{"$error":"#N/A"}},""]
[null,4,"Vite Testa Svasata","Construct TS - 8x280","8x280","01580280",5.9,5.2,8,15,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,24,{"$error":"#N/A"},""]
[null,5,"Vite Testa Svasata","Construct TS - 8x300","8x300","01580300",5.9,5.2,8,15,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,25,{"$error":"#N/A"},""]
[null,6,"Vite Testa Svasata","Construct TS - 8x350","8x350","01580350",5.9,5.2,8,15,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,26,{"$error":"#N/A"},""]
[null,7,"Vite Testa Svasata","Construct TS - 8x400","8x400","01580400",5.9,5.2,8,15,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,27,{"$error":"#N/A"},""]
[null,8,"Vite Testa Svasata","Construct TS - 8x450","8x450","01580450",5.9,5.2,8,15,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,28,{"$error":"#N/A"},""]
[null,9,"Vite Testa Svasata","Construct TS - 8x500","8x500","01580500",5.9,5.2,8,15,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,29,{"$error":"#N/A"},""]
[null,10,"Vite Testa Svasata","Construct TS - 10x160","10x160","01510160",7.1,6.1,10,18.5,160,148,1000,0,40,12.5,null,null,null,null,null,null,30,{"$error":"#N/A"},""]
[null,11,"Vite Testa Svasata","Construct TS - 10x200","10x200","01510200",7.1,6.1,10,18.5,200,188,1000,0,40,12.5,null,null,null,null,null,null,31,{"$error":"#N/A"},""]
[null,12,"Vite Testa Svasata","Construct TS - 10x240","10x240","01510240",7.1,6.1,10,18.5,240,228,1000,0,40,12.5,null,null,null,null,null,null,32,{"$error":"#N/A"},""]
[null,13,"Vite Testa Svasata","Construct TS - 10x300","10x300","01510300",7.1,6.1,10,18.5,300,288,1000,0,40,12.5,null,null,null,null,null,null,33,{"$error":"#N/A"},""]
[null,14,"Vite Testa Svasata","Construct TS - 10x350","10x350","01510350",7.1,6.1,10,18.5,350,338,1000,0,40,12.5,null,null,null,null,null,null,34,{"$error":"#N/A"},""]
[null,15,"Vite Testa Svasata","Construct TS - 10x400","10x400","01510400",7.1,6.1,10,18.5,400,388,1000,0,40,12.5,null,null,null,null,null,null,35,{"$error":"#N/A"},""]
[null,16,"Vite Testa Svasata","Construct TS - 10x450","10x450","01510450",7.1,6.1,10,18.5,450,426,1000,0,40,12.5,null,null,null,null,null,null,36,{"$error":"#N/A"},""]
[null,17,"Vite Testa Svasata","Construct TS - 10x500","10x500","01510500",7.1,6.1,10,18.5,500,476,1000,0,40,12.5,null,null,null,null,null,null,37,{"$error":"#N/A"},""]
[null,18,"Vite Testa Svasata","Construct TS - 10x600","10x600","01510600",7.1,6.1,10,18.5,600,576,1000,0,40,12.5,null,null,null,null,null,null,38,{"$error":"#N/A"},""]
[null,19,"Vite Testa Svasata","Construct TS - 12x400","12x400","01510400",8.1999999999999993,6.8,12,21,400,380,1000,0,46.5,11.2,null,null,null,null,null,null,39,{"$error":"#N/A"},""]
[null,20,"Vite Testa Svasata","Construct TS - 12x500","12x500","01510500",8.1999999999999993,6.8,12,21,500,480,1000,0,46.5,11.2,null,null,null,null,null,null,40,{"$error":"#N/A"},""]
[null,21,"Vite Testa Svasata","Construct TS - 12x600","12x600","01510600",8.1999999999999993,6.8,12,21,600,580,1000,0,46.5,11.2,null,null,null,null,null,null,41,{"$error":"#N/A"},""]
[null,0]
[]
[]
[null,null,null,{"$f":"IF(Viti!S4=1,VLOOKUP(Viti!T4,Viti!B5:P24,15),VLOOKUP(Viti!T4,Viti!B25:P45,15))","v":13.1}]

{"sheet":"Viti3","index":10,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Construct TC"]
[null,null,null,null,null,null,null,null,null,"Construct TS",null,null,null,null,null,null,null,null,"INDICE 1","INDICE 2"]
[null,"CONT2","Gruppo","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90",null,null,1,9,null,null,"CONT"]
[null,{"$f":"IF($S$4=1,W5,0)","v":1},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E5)","v":"Construct TC - 8x120"},"8x120","01408120",5.9,5.2,8,10.199999999999999,120,110,1000,0,24.1,13.1,null,null,{"$f":"+INDEX(V5:V6,S4)","v":"Vite Testa Cilindrica"},{"$f":"+INDEX(Y5:Y45,T4)","v":"Construct TC - 8x280"},null,"Vite Testa Cilindrica",1,{"$f":"+nlookup($C$5:$D$45,$S$5,W5,0,1)","v":"Construct TC - 8x120"},{"$f":"IF(X5=\"#N/D\",\"\",+IF(ISERROR(X5),\"\",X5))","v":"Construct TC - 8x120"}]
[null,{"$f":"IF($S$4=1,W6,0)","v":2},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E6)","v":"Construct TC - 8x140"},"8x140","01408140",5.9,5.2,8,10.199999999999999,140,130,1000,0,24.1,13.1,null,null,null,null,null,"Vite Testa Svasata",{"$f":"W5+1","v":2},{"$f":"+nlookup($C$5:$D$45,$S$5,W6,0,1)","v":"Construct TC - 8x140"},{"$f":"IF(X6=\"#N/D\",\"\",+IF(ISERROR(X6),\"\",X6))","v":"Construct TC - 8x140"}]
[null,3,"Vite Testa Cilindrica","Construct TC - 8x160","8x160","01408160",5.9,5.2,8,10.199999999999999,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,{"$f":"W6+1","v":3},{"$f":"+nlookup($C$5:$D$45,$S$5,W7,0,1)","v":"Construct TC - 8x160"},"Construct TC - 8x160"]
[null,4,"Vite Testa Cilindrica","Construct TC - 8x180","8x180","01408180",5.9,5.2,8,10.199999999999999,180,170,1000,0,24.1,13.1,null,null,null,null,null,null,4,{"$f":"+nlookup($C$5:$D$45,$S$5,W8,0,1)","v":"Construct TC - 8x180"},"Construct TC - 8x180"]
[null,5,"Vite Testa Cilindrica","Construct TC - 8x200","8x200","01408200",5.9,5.2,8,10.199999999999999,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,5,{"$f":"+nlookup($C$5:$D$45,$S$5,W9,0,1)","v":"Construct TC - 8x200"},"Construct TC - 8x200"]
[null,6,"Vite Testa Cilindrica","Construct TC - 8x220","8x220","01408220",5.9,5.2,8,10.199999999999999,220,210,1000,0,24.1,13.1,null,null,null,null,null,null,6,{"$f":"+nlookup($C$5:$D$45,$S$5,W10,0,1)","v":"Construct TC - 8x220"},"Construct TC - 8x220"]
[null,7,"Vite Testa Cilindrica","Construct TC - 8x240","8x240","01408240",5.9,5.2,8,10.199999999999999,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,7,{"$f":"+nlookup($C$5:$D$45,$S$5,W11,0,1)","v":"Construct TC - 8x240"},"Construct TC - 8x240"]
[null,8,"Vite Testa Cilindrica","Construct TC - 8x260","8x260","01408260",5.9,5.2,8,10.199999999999999,260,250,1000,0,24.1,13.1,null,null,null,null,null,null,8,{"$f":"+nlookup($C$5:$D$45,$S$5,W12,0,1)","v":"Construct TC - 8x260"},"Construct TC - 8x260"]
[null,9,"Vite Testa Cilindrica","Construct TC - 8x280","8x280","01408280",5.9,5.2,8,10.199999999999999,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,9,{"$f":"+nlookup($C$5:$D$45,$S$5,W13,0,1)","v":"Construct TC - 8x280"},"Construct TC - 8x280"]
[null,10,"Vite Testa Cilindrica","Construct TC - 8x300","8x300","01408300",5.9,5.2,8,10.199999999999999,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,10,{"$f":"+nlookup($C$5:$D$45,$S$5,W14,0,1)","v":"Construct TC - 8x300"},"Construct TC - 8x300"]
[null,11,"Vite Testa Cilindrica","Construct TC - 8x350","8x350","01408350",5.9,5.2,8,10.199999999999999,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,11,{"$f":"+nlookup($C$5:$D$45,$S$5,W15,0,1)","v":"Construct TC - 8x350"},"Construct TC - 8x350"]
[null,12,"Vite Testa Cilindrica","Construct TC - 8x400","8x400","01408400",5.9,5.2,8,10.199999999999999,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,12,{"$f":"+nlookup($C$5:$D$45,$S$5,W16,0,1)","v":"Construct TC - 8x400"},"Construct TC - 8x400"]
[null,13,"Vite Testa Cilindrica","Construct TC - 8x450","8x450","01408450",5.9,5.2,8,10.199999999999999,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,13,{"$f":"+nlookup($C$5:$D$45,$S$5,W17,0,1)","v":"Construct TC - 8x450"},"Construct TC - 8x450"]
[null,14,"Vite Testa Cilindrica","Construct TC - 8x500","8x500","01408500",5.9,5.2,8,10.199999999999999,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,14,{"$f":"+nlookup($C$5:$D$45,$S$5,W18,0,1)","v":"Construct TC - 8x500"},"Construct TC - 8x500"]
[null,15,"Vite Testa Cilindrica","Construct TC - 8x600","8x600","01408600",5.9,5.2,8,10.199999999999999,600,578,1000,0,24.1,13.1,null,null,null,null,null,null,15,{"$f":"+nlookup($C$5:$D$45,$S$5,W19,0,1)","v":"Construct TC - 8x600"},"Construct TC - 8x600"]
[null,16,"Vite Testa Cilindrica","Construct TC - 10x450","10x450","01410450",7.1,6.1,10,13.4,450,426,1000,0,40,12.5,null,null,null,null,null,null,16,{"$f":"+nlookup($C$5:$D$45,$S$5,W20,0,1)","v":"Construct TC - 10x450"},"Construct TC - 10x450"]
[null,17,"Vite Testa Cilindrica","Construct TC - 10x500","10x500","01410500",7.1,6.1,10,13.4,500,476,1000,0,40,12.5,null,null,null,null,null,null,17,{"$f":"+nlookup($C$5:$D$45,$S$5,W21,0,1)","v":"Construct TC - 10x500"},"Construct TC - 10x500"]
[null,18,"Vite Testa Cilindrica","Construct TC - 10x600","10x600","01410600",7.1,6.1,10,13.4,600,576,1000,0,40,12.5,null,null,null,null,null,null,18,{"$f":"+nlookup($C$5:$D$45,$S$5,W22,0,1)","v":"Construct TC - 10x600"},"Construct TC - 10x600"]
[null,19,"Vite Testa Cilindrica","Construct TC - 10x800","10x800","01410800",7.1,6.1,10,13.4,800,776,1000,0,40,12.5,null,null,null,null,null,null,19,{"$f":"+nlookup($C$5:$D$45,$S$5,W23,0,1)","v":"Construct TC - 10x800"},"Construct TC - 10x800"]
[null,20,"Vite Testa Cilindrica","Construct TC - 10x1000","10x1000","01411000",7.1,6.1,10,13.4,1000,976,1000,0,40,12.5,null,null,null,null,null,null,20,{"$f":"+nlookup($C$5:$D$45,$S$5,W24,0,1)","v":"Construct TC - 10x1000"},"Construct TC - 10x1000"]
[null,{"$f":"IF($S$4=1,0,W5)","v":0},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E25)","v":"Construct TS - 8x160"},"8x160","01580160",5.9,5.2,8,15,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,21,{"$f":"+nlookup($C$5:$D$45,$S$5,W25,0,1)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,{"$f":"IF($S$4=1,0,W6)","v":0},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E26)","v":"Construct TS - 8x200"},"8x200","01580200",5.9,5.2,8,15,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,22,{"$f":"+nlookup($C$5:$D$45,$S$5,W26,0,1)","v":{"$error":"#N/A"}},{"$f":"+IF(ISERROR(X26),\"\",X26)","v":""}]
[null,0,"Vite Testa Svasata","Construct TS - 8x240","8x240","01580240",5.9,5.2,8,15,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,23,{"$f":"+nlookup($C$5:$D$45,$S$5,W27,0,1)","v":{"$error":"#N/A"}},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x280","8x280","01580280",5.9,5.2,8,15,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,24,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x300","8x300","01580300",5.9,5.2,8,15,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,25,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x350","8x350","01580350",5.9,5.2,8,15,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,26,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x400","8x400","01580400",5.9,5.2,8,15,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,27,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x450","8x450","01580450",5.9,5.2,8,15,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,28,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 8x500","8x500","01580500",5.9,5.2,8,15,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,29,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x160","10x160","01510160",7.1,6.1,10,18.5,160,148,1000,0,40,12.5,null,null,null,null,null,null,30,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x200","10x200","01510200",7.1,6.1,10,18.5,200,188,1000,0,40,12.5,null,null,null,null,null,null,31,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x240","10x240","01510240",7.1,6.1,10,18.5,240,228,1000,0,40,12.5,null,null,null,null,null,null,32,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x300","10x300","01510300",7.1,6.1,10,18.5,300,288,1000,0,40,12.5,null,null,null,null,null,null,33,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x350","10x350","01510350",7.1,6.1,10,18.5,350,338,1000,0,40,12.5,null,null,null,null,null,null,34,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x400","10x400","01510400",7.1,6.1,10,18.5,400,388,1000,0,40,12.5,null,null,null,null,null,null,35,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x450","10x450","01510450",7.1,6.1,10,18.5,450,426,1000,0,40,12.5,null,null,null,null,null,null,36,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x500","10x500","01510500",7.1,6.1,10,18.5,500,476,1000,0,40,12.5,null,null,null,null,null,null,37,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 10x600","10x600","01510600",7.1,6.1,10,18.5,600,576,1000,0,40,12.5,null,null,null,null,null,null,38,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x400","12x400","01510400",8.1999999999999993,6.8,12,21,400,380,1000,0,46.5,11.2,null,null,null,null,null,null,39,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x500","12x500","01510500",8.1999999999999993,6.8,12,21,500,480,1000,0,46.5,11.2,null,null,null,null,null,null,40,{"$error":"#N/A"},""]
[null,0,"Vite Testa Svasata","Construct TS - 12x600","12x600","01510600",8.1999999999999993,6.8,12,21,600,580,1000,0,46.5,11.2,null,null,null,null,null,null,41,{"$error":"#N/A"},""]
[null,0]
[]
[]
[null,null,null,{"$f":"IF(Viti!S4=1,VLOOKUP(Viti!T4,Viti!B5:P24,15),VLOOKUP(Viti!T4,Viti!B25:P45,15))","v":13.1}]

{"sheet":"Viti4","index":11,"n_rows":49,"n_cols":25,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Construct TC"]
[null,null,null,null,null,null,null,null,null,"Construct TS",null,null,null,null,null,null,null,null,"INDICE 1","INDICE 2"]
[null,"CONT2","Gruppo","Denominazione","dxL","codice","d gambo","d nocciolo","d filetto","d testa","L vite","Lfiletto","fuk(N/mm2)","d rondella","Rtens,k","FAX,K90",null,null,2,2,null,null,"CONT"]
[null,{"$f":"IF($S$4=1,W5,0)","v":0},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E5)","v":"Construct TC - 8x120"},"8x120","01408120",5.9,5.2,8,10.199999999999999,120,110,1000,0,24.1,13.1,null,null,{"$f":"+INDEX(V5:V6,S4)","v":"Vite Testa Svasata"},{"$f":"+INDEX(Y5:Y45,T4)","v":"Construct TS - 8x200"},null,"Vite Testa Cilindrica",1,{"$f":"+nlookup($C$5:$D$45,$S$5,W5,0,1)","v":"Construct TS - 8x160"},{"$f":"IF(X5=\"#N/D\",\"\",+IF(ISERROR(X5),\"\",X5))","v":"Construct TS - 8x160"}]
[null,{"$f":"IF($S$4=1,W6,0)","v":0},"Vite Testa Cilindrica",{"$f":"CONCATENATE($J$2,\" - \",E6)","v":"Construct TC - 8x140"},"8x140","01408140",5.9,5.2,8,10.199999999999999,140,130,1000,0,24.1,13.1,null,null,null,null,null,"Vite Testa Svasata",{"$f":"W5+1","v":2},{"$f":"+nlookup($C$5:$D$45,$S$5,W6,0,1)","v":"Construct TS - 8x200"},{"$f":"IF(X6=\"#N/D\",\"\",+IF(ISERROR(X6),\"\",X6))","v":"Construct TS - 8x200"}]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x160","8x160","01408160",5.9,5.2,8,10.199999999999999,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,{"$f":"W6+1","v":3},{"$f":"+nlookup($C$5:$D$45,$S$5,W7,0,1)","v":"Construct TS - 8x240"},"Construct TS - 8x240"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x180","8x180","01408180",5.9,5.2,8,10.199999999999999,180,170,1000,0,24.1,13.1,null,null,null,null,null,null,4,{"$f":"+nlookup($C$5:$D$45,$S$5,W8,0,1)","v":"Construct TS - 8x280"},"Construct TS - 8x280"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x200","8x200","01408200",5.9,5.2,8,10.199999999999999,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,5,{"$f":"+nlookup($C$5:$D$45,$S$5,W9,0,1)","v":"Construct TS - 8x300"},"Construct TS - 8x300"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x220","8x220","01408220",5.9,5.2,8,10.199999999999999,220,210,1000,0,24.1,13.1,null,null,null,null,null,null,6,{"$f":"+nlookup($C$5:$D$45,$S$5,W10,0,1)","v":"Construct TS - 8x350"},"Construct TS - 8x350"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x240","8x240","01408240",5.9,5.2,8,10.199999999999999,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,7,{"$f":"+nlookup($C$5:$D$45,$S$5,W11,0,1)","v":"Construct TS - 8x400"},"Construct TS - 8x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x260","8x260","01408260",5.9,5.2,8,10.199999999999999,260,250,1000,0,24.1,13.1,null,null,null,null,null,null,8,{"$f":"+nlookup($C$5:$D$45,$S$5,W12,0,1)","v":"Construct TS - 8x450"},"Construct TS - 8x450"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x280","8x280","01408280",5.9,5.2,8,10.199999999999999,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,9,{"$f":"+nlookup($C$5:$D$45,$S$5,W13,0,1)","v":"Construct TS - 8x500"},"Construct TS - 8x500"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x300","8x300","01408300",5.9,5.2,8,10.199999999999999,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,10,{"$f":"+nlookup($C$5:$D$45,$S$5,W14,0,1)","v":"Construct TS - 10x160"},"Construct TS - 10x160"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x350","8x350","01408350",5.9,5.2,8,10.199999999999999,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,11,{"$f":"+nlookup($C$5:$D$45,$S$5,W15,0,1)","v":"Construct TS - 10x200"},"Construct TS - 10x200"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x400","8x400","01408400",5.9,5.2,8,10.199999999999999,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,12,{"$f":"+nlookup($C$5:$D$45,$S$5,W16,0,1)","v":"Construct TS - 10x240"},"Construct TS - 10x240"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x450","8x450","01408450",5.9,5.2,8,10.199999999999999,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,13,{"$f":"+nlookup($C$5:$D$45,$S$5,W17,0,1)","v":"Construct TS - 10x300"},"Construct TS - 10x300"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x500","8x500","01408500",5.9,5.2,8,10.199999999999999,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,14,{"$f":"+nlookup($C$5:$D$45,$S$5,W18,0,1)","v":"Construct TS - 10x350"},"Construct TS - 10x350"]
[null,0,"Vite Testa Cilindrica","Construct TC - 8x600","8x600","01408600",5.9,5.2,8,10.199999999999999,600,578,1000,0,24.1,13.1,null,null,null,null,null,null,15,{"$f":"+nlookup($C$5:$D$45,$S$5,W19,0,1)","v":"Construct TS - 10x400"},"Construct TS - 10x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x450","10x450","01410450",7.1,6.1,10,13.4,450,426,1000,0,40,12.5,null,null,null,null,null,null,16,{"$f":"+nlookup($C$5:$D$45,$S$5,W20,0,1)","v":"Construct TS - 10x450"},"Construct TS - 10x450"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x500","10x500","01410500",7.1,6.1,10,13.4,500,476,1000,0,40,12.5,null,null,null,null,null,null,17,{"$f":"+nlookup($C$5:$D$45,$S$5,W21,0,1)","v":"Construct TS - 10x500"},"Construct TS - 10x500"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x600","10x600","01410600",7.1,6.1,10,13.4,600,576,1000,0,40,12.5,null,null,null,null,null,null,18,{"$f":"+nlookup($C$5:$D$45,$S$5,W22,0,1)","v":"Construct TS - 10x600"},"Construct TS - 10x600"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x800","10x800","01410800",7.1,6.1,10,13.4,800,776,1000,0,40,12.5,null,null,null,null,null,null,19,{"$f":"+nlookup($C$5:$D$45,$S$5,W23,0,1)","v":"Construct TS - 12x400"},"Construct TS - 12x400"]
[null,0,"Vite Testa Cilindrica","Construct TC - 10x1000","10x1000","01411000",7.1,6.1,10,13.4,1000,976,1000,0,40,12.5,null,null,null,null,null,null,20,{"$f":"+nlookup($C$5:$D$45,$S$5,W24,0,1)","v":"Construct TS - 12x500"},"Construct TS - 12x500"]
[null,{"$f":"IF($S$4=1,0,W5)","v":1},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E25)","v":"Construct TS - 8x160"},"8x160","01580160",5.9,5.2,8,15,160,150,1000,0,24.1,13.1,null,null,null,null,null,null,21,{"$f":"+nlookup($C$5:$D$45,$S$5,W25,0,1)","v":"Construct TS - 12x600"},"Construct TS - 12x600"]
[null,{"$f":"IF($S$4=1,0,W6)","v":2},"Vite Testa Svasata",{"$f":"CONCATENATE($J$3,\" - \",E26)","v":"Construct TS - 8x200"},"8x200","01580200",5.9,5.2,8,15,200,190,1000,0,24.1,13.1,null,null,null,null,null,null,22,{"$f":"+nlookup($C$5:$D$45,$S$5,W26,0,1)","v":{"$error":"#N/A"}},{"$f":"+IF(ISERROR(X26),\"\",X26)","v":""}]
[null,3,"Vite Testa Svasata","Construct TS - 8x240","8x240","01580240",5.9,5.2,8,15,240,230,1000,0,24.1,13.1,null,null,null,null,null,null,23,{"$f":"+nlookup($C$5:$D$45,$S$5,W27,0,1)","v":{"$error":"#N/A"}},""]
[null,4,"Vite Testa Svasata","Construct TS - 8x280","8x280","01580280",5.9,5.2,8,15,280,270,1000,0,24.1,13.1,null,null,null,null,null,null,24,{"$error":"#N/A"},""]
[null,5,"Vite Testa Svasata","Construct TS - 8x300","8x300","01580300",5.9,5.2,8,15,300,290,1000,0,24.1,13.1,null,null,null,null,null,null,25,{"$error":"#N/A"},""]
[null,6,"Vite Testa Svasata","Construct TS - 8x350","8x350","01580350",5.9,5.2,8,15,350,340,1000,0,24.1,13.1,null,null,null,null,null,null,26,{"$error":"#N/A"},""]
[null,7,"Vite Testa Svasata","Construct TS - 8x400","8x400","01580400",5.9,5.2,8,15,400,390,1000,0,24.1,13.1,null,null,null,null,null,null,27,{"$error":"#N/A"},""]
[null,8,"Vite Testa Svasata","Construct TS - 8x450","8x450","01580450",5.9,5.2,8,15,450,428,1000,0,24.1,13.1,null,null,null,null,null,null,28,{"$error":"#N/A"},""]
[null,9,"Vite Testa Svasata","Construct TS - 8x500","8x500","01580500",5.9,5.2,8,15,500,478,1000,0,24.1,13.1,null,null,null,null,null,null,29,{"$error":"#N/A"},""]
[null,10,"Vite Testa Svasata","Construct TS - 10x160","10x160","01510160",7.1,6.1,10,18.5,160,148,1000,0,40,12.5,null,null,null,null,null,null,30,{"$error":"#N/A"},""]
[null,11,"Vite Testa Svasata","Construct TS - 10x200","10x200","01510200",7.1,6.1,10,18.5,200,188,1000,0,40,12.5,null,null,null,null,null,null,31,{"$error":"#N/A"},""]
[null,12,"Vite Testa Svasata","Construct TS - 10x240","10x240","01510240",7.1,6.1,10,18.5,240,228,1000,0,40,12.5,null,null,null,null,null,null,32,{"$error":"#N/A"},""]
[null,13,"Vite Testa Svasata","Construct TS - 10x300","10x300","01510300",7.1,6.1,10,18.5,300,288,1000,0,40,12.5,null,null,null,null,null,null,33,{"$error":"#N/A"},""]
[null,14,"Vite Testa Svasata","Construct TS - 10x350","10x350","01510350",7.1,6.1,10,18.5,350,338,1000,0,40,12.5,null,null,null,null,null,null,34,{"$error":"#N/A"},""]
[null,15,"Vite Testa Svasata","Construct TS - 10x400","10x400","01510400",7.1,6.1,10,18.5,400,388,1000,0,40,12.5,null,null,null,null,null,null,35,{"$error":"#N/A"},""]
[null,16,"Vite Testa Svasata","Construct TS - 10x450","10x450","01510450",7.1,6.1,10,18.5,450,426,1000,0,40,12.5,null,null,null,null,null,null,36,{"$error":"#N/A"},""]
[null,17,"Vite Testa Svasata","Construct TS - 10x500","10x500","01510500",7.1,6.1,10,18.5,500,476,1000,0,40,12.5,null,null,null,null,null,null,37,{"$error":"#N/A"},""]
[null,18,"Vite Testa Svasata","Construct TS - 10x600","10x600","01510600",7.1,6.1,10,18.5,600,576,1000,0,40,12.5,null,null,null,null,null,null,38,{"$error":"#N/A"},""]
[null,19,"Vite Testa Svasata","Construct TS - 12x400","12x400","01510400",8.1999999999999993,6.8,12,21,400,380,1000,0,46.5,11.2,null,null,null,null,null,null,39,{"$error":"#N/A"},""]
[null,20,"Vite Testa Svasata","Construct TS - 12x500","12x500","01510500",8.1999999999999993,6.8,12,21,500,480,1000,0,46.5,11.2,null,null,null,null,null,null,40,{"$error":"#N/A"},""]
[null,21,"Vite Testa Svasata","Construct TS - 12x600","12x600","01510600",8.1999999999999993,6.8,12,21,600,580,1000,0,46.5,11.2,null,null,null,null,null,null,41,{"$error":"#N/A"},""]
[null,0]
[]
[]
[null,null,null,{"$f":"IF(Viti!S4=1,VLOOKUP(Viti!T4,Viti!B5:P24,15),VLOOKUP(Viti!T4,Viti!B25:P45,15))","v":13.1}]