{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SEZIONE","Simbologia"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":218,"comments":1,"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":"SEZIONE","index":0,"n_rows":356,"n_cols":48,"rows_kept":356,"cut":false,"hidden":false,"merged":[[2,5,2,10],[2,1,2,3]]}
[null,null,"cm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SEZIONE!$J$5","v":30}]
[null,"Coordinate dei nodi",null,null,null,"Assi baricentrici",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-#REF!*50","v":{"$error":"#REF!"}},{"$f":"SEZIONE!$J$5","v":30}]
[null,null,"x","y",null,"A =",{"$f":"SUM((Y-OFFSET(Y,1,0))*(X+OFFSET(X,1,0)))/2","v":198},{"$f":"$C$1 & \"²\"","v":"cm²"},"L =",{"$f":"MAX(X)-MIN(X)","v":25},{"$f":"$C$1","v":"cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-#REF!*50","v":{"$error":"#REF!"}},{"$f":"SEZIONE!$J$5+#REF!*100","v":{"$error":"#REF!"}}]
[null,1,0,0,null,"P =",{"$f":"SUM(SQRT((OFFSET(X,1,0)-X)^2+(OFFSET(Y,1,0)-Y)^2))","v":156},{"$f":"C1","v":"cm"},"H =",{"$f":"MAX(Y)-MIN(Y)","v":30},{"$f":"$C$1","v":"cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*50","v":{"$error":"#REF!"}},{"$f":"SEZIONE!$J$5+#REF!*100","v":{"$error":"#REF!"}}]
[null,{"$f":"1+B5","v":2},-12.5,0,null,"xc =",{"$f":"SUM((Y-OFFSET(Y,1,0))/8*((X+OFFSET(X,1,0))^2+(OFFSET(X,1,0)-X)^2/3))/$G$4","v":0},{"$f":"C1","v":"cm"},"Wxsup =",{"$f":"G8/ABS(MAX(Y)-$G$7)","v":1983.6},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!*50","v":{"$error":"#REF!"}},{"$f":"SEZIONE!$J$5","v":30}]
[null,3,-12.5,3,null,"yc =",{"$f":"SUM((OFFSET(X,1,0)-X)/8*((Y+OFFSET(Y,1,0))^2+(OFFSET(Y,1,0)-Y)^2/3))/$G$4","v":15},{"$f":"C1","v":"cm"},"Wxinf =",{"$f":"G8/ABS(MIN(Y)-$G$7)","v":1983.6},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SEZIONE!$J$5","v":30}]
[null,4,-1,3,null,"Ix =",{"$f":"SUM((OFFSET(X,1,0)-X)*(Y+OFFSET(Y,1,0))/12*(OFFSET(Y,1,0)^2+Y^2))-G4*G7^2","v":29754},{"$f":"$C$1&\"^4\"","v":"cm^4"},"Wydx =",{"$f":"G9/ABS(MIN(X)-G6)","v":626.28},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DX =",{"$f":"MAX(X)-MIN(X)","v":25},null,null,null,null,null,null,null,null,null,"DX =",{"$f":"MAX(X)-MIN(X)","v":25}]
[null,5,-1,27,null,"Iy =",{"$f":"-SUM((OFFSET(Y,1,0)-Y)*(X+OFFSET(X,1,0))/12*(OFFSET(X,1,0)^2+X^2))-G4*G6^2","v":7828.5},{"$f":"$C$1&\"^4\"","v":"cm^4"},"Wysx =",{"$f":"G9/ABS(MAX(X)-G6)","v":626.28},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DY=",{"$f":"MAX(Y)-MIN(Y)","v":30},null,null,null,null,null,null,"Imax =",{"$f":"+(G8+G9)/2-SQRT((G8-G9)^2/4+G10^2)","v":7828.5},{"$f":"$C$1&\"^4\"","v":"cm^4"},"DY=",{"$f":"MAX(Y)-MIN(Y)","v":30}]
[null,6,-12.5,27,null,"Ixy =",{"$f":"SUM(((OFFSET(Y,1,0)-Y)^2*(OFFSET(X,1,0)+X)*(OFFSET(X,1,0)^2+X^2)/8+(OFFSET(Y,1,0)-Y)*(OFFSET(X,1,0)*Y-X*OFFSET(Y,1,0))*(OFFSET(X,1,0)^2+OFFSET(X,1,0)*X+X^2)/3+(OFFSET(X,1,0)*Y-X*OFFSET(Y,1,0))^2*(OFFSET(X,1,0)+X)/4)*IF(OFFSET(X,1,0)=X,0,1/(OFFSET(X,1,0)-X)))-G4*G6*G7","v":0},{"$f":"$C$1&\"^4\"","v":"cm^4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plot of diagonal",null,null,"For Chart labels",null,null,null,null,"Imin =",{"$f":"+(G8+G9)/2+SQRT((G8-G9)^2/4+G10^2)","v":29754},{"$f":"$C$1&\"^4\"","v":"cm^4"},"controllo scala",null,null,"per le etichette"]
[null,7,-12.5,30,null,"Direzioni principali",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"to control XY scale",null,null,null,null,null,null,null,"Plottaggio Assi principali"]
[null,8,12.5,30,null,"qp =",{"$f":"IF(G10=0,0,IF(G8-G9=0,45,DEGREES(1/2*ATAN(-2*G10/(G8-G9)))))","v":0}," deg","Wxpsup =",{"$f":"ABS(G13/MAX(SQRT((X-$G$6)^2+(Y-$G$7)^2)*SIN(ATAN2(X-$G$6,Y-$G$7)-RADIANS($G$12))))","v":1983.5999999999995},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","y",null,"x","y",null,null,null,"x","y",null,"x","y",null,"x","y"]
[null,9,12.5,27,null,"Ixp =",{"$f":"G8*COS(RADIANS(G12))^2+G9*SIN(RADIANS(G12))^2-G10*SIN(2*RADIANS(G12))","v":29754},{"$f":"$C$1&\"^4\"","v":"cm^4"},"Wxpinf =",{"$f":"ABS(G13/MIN(SQRT((X-$G$6)^2+(Y-$G$7)^2)*SIN(ATAN2(X-$G$6,Y-$G$7)-RADIANS($G$12))))","v":1983.5999999999995},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH8>=AH9,MIN(X),(MAX(X)+MIN(X)-AH9)/2)","v":-15},{"$f":"IF(AH8>=AH9,(MAX(Y)+MIN(Y)-AH8)/2,MIN(Y))","v":0},null,{"$f":"AG14","v":15},0,null,null,null,{"$f":"MIN(X)","v":-12.5},{"$f":"(AO13-$G$6)*TAN(RADIANS($G$12))+$G$7","v":15},null,{"$f":"IF(AS8>=AS9,MIN(X),(MAX(X)+MIN(X)-AS9)/2)","v":-15},{"$f":"IF(AS8>=AS9,(MAX(Y)+MIN(Y)-AS8)/2,MIN(Y))","v":0},null,{"$f":"AR14","v":15},0]
[null,10,1,27,1,"Iyp =",{"$f":"G8+G9-G13","v":7828.5},{"$f":"$C$1&\"^4\"","v":"cm^4"},"Wypdx =",{"$f":"ABS($G$14/MIN(SQRT((X-$G$6)^2+(Y-$G$7)^2)*COS(ATAN2(X-$G$6,Y-$G$7)-RADIANS($G$12))))","v":626.28000000000009},{"$f":"$C$1&\"³\"","v":"cm³"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH8>=AH9,MAX(X),(MAX(X)+MIN(X)+AH9)/2)","v":15},{"$f":"IF(AH8>=AH9,(MAX(Y)+MIN(Y)+AH8)/2,MAX(Y))","v":30},null,0,{"$f":"AH14","v":30},null,null,null,{"$f":"MAX(X)","v":12.5},{"$f":"(AO14-$G$6)*TAN(RADIANS($G$12))+$G$7","v":15},null,{"$f":"IF(AS8>=AS9,MAX(X),(MAX(X)+MIN(X)+AS9)/2)","v":15},{"$f":"IF(AS8>=AS9,(MAX(Y)+MIN(Y)+AS8)/2,MAX(Y))","v":30},null,0,{"$f":"AS14","v":30}]
[null,11,1,3,null,"Ip =",{"$f":"+G13+G14","v":37582.5},{"$f":"$C$1&\"^4\"","v":"cm^4"},"Wypsx =",{"$f":"ABS($G$14/MAX(SQRT((X-$G$6)^2+(Y-$G$7)^2)*COS(ATAN2(X-$G$6,Y-$G$7)-RADIANS($G$12))))","v":626.27999999999986},{"$f":"$C$1&\"³\"","v":"cm³"}]
[null,12,12.5,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AP16-$G$7)*TAN(RADIANS(-$G$12))+$G$6","v":0},{"$f":"MIN(Y)","v":0}]
[null,13,12.5,0,null,"Riferimento utente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AP17-$G$7)*TAN(RADIANS(-$G$12))+$G$6","v":0},{"$f":"MAX(Y)","v":30}]
[null,14,0,0,null,"xo =",0,{"$f":"$C$1","v":"cm"},"qo =",0,"deg"]
[null,15,null,null,null,"yo =",0,{"$f":"$C$1","v":"cm"}]
[null,16,null,null,null,"xco =",{"$f":"(G6-G18)*COS(RADIANS(J18))+(G7-G19)*SIN(RADIANS(J18))","v":0},{"$f":"$C$1","v":"cm"}]
[null,17,null,null,null,"yco =",{"$f":"-(G6-G18)*SIN(RADIANS(J18))+(G7-G19)*COS(RADIANS(J18))","v":15},{"$f":"$C$1","v":"cm"}]
[null,18,null,null,null,"Ixo =",{"$f":"G4*(G7-G19)^2+G8*COS(RADIANS(J18))^2+G9*SIN(RADIANS(J18))^2-G10*SIN(RADIANS(2*J18))","v":74304},{"$f":"$C$1&\"^4\"","v":"cm^4"}]
[null,19,null,null,null,"Iyo =",{"$f":"G4*(G6-G18)^2+G8*SIN(RADIANS(J18))^2+G9*COS(RADIANS(J18))^2+G10*SIN(RADIANS(2*J18))","v":7828.5},{"$f":"$C$1&\"^4\"","v":"cm^4"}]
[null,20,null,null,null,"Sxo =",{"$f":"G4*G21","v":2970},{"$f":"$C$1&\"³\"","v":"cm³"}]
[null,21,null,null,null,"Syo =",{"$f":"G4*G20","v":0},{"$f":"$C$1&\"³\"","v":"cm³"}]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIAGRAMMA TENSIONI NORMALI"]
[null,30]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,201.71,0]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-201.71,30]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]
[null,51]
[null,52]
[null,53]
[null,54]
[null,55]
[null,56]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,{"$f":"1+B69","v":66}]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]
[null,73]
[null,74]
[null,75]
[null,76]
[null,77]
[null,78]
[null,79]
[null,80]
[null,81]
[null,82]
[null,83]
[null,84]
[null,85]
[null,86]
[null,87]
[null,88]
[null,89]
[null,90]
[null,91]
[null,92]
[null,93]
[null,94]
[null,95]
[null,96]
[null,97]
[null,98]
[null,99]
[null,100]
[null,101]
[null,102]
[null,103]
[null,104]
[null,105]
[null,106]
[null,107]
[null,108]
[null,109]
[null,110]
[null,111]
[null,112]
[null,113]
[null,114]
[null,115]
[null,116]
[null,117]
[null,118]
[null,119]
[null,120]
[null,121]
[null,122]
[null,123]
[null,124]
[null,125]
[null,126]
[null,127]
[null,128]
[null,129]
[null,{"$f":"1+B133","v":130}]
[null,131]
[null,132]
[null,133]
[null,134]
[null,135]
[null,136]
[null,137]
[null,138]
[null,139]
[null,140]
[null,141]
[null,142]
[null,143]
[null,144]
[null,145]
[null,146]
[null,147]
[null,148]
[null,149]
[null,150]
[null,151]
[null,152]
[null,153]
[null,154]
[null,155]
[null,156]
[null,157]
[null,158]
[null,159]
[null,160]
[null,161]
[null,162]
[null,163]
[null,164]
[null,165]
[null,166]
[null,167]
[null,168]
[null,169]
[null,170]
[null,171]
[null,172]
[null,173]
[null,174]
[null,175]
[null,176]
[null,177]
[null,178]
[null,179]
[null,180]
[null,181]
[null,182]
[null,183]
[null,184]
[null,185]
[null,186]
[null,187]
[null,188]
[null,189]
[null,190]
[null,191]
[null,192]
[null,193]
[null,{"$f":"1+B197","v":194}]
[null,195]
[null,196]
[null,197]
[null,198]
[null,199]
[null,200]
[null,201]
[null,202]
[null,203]
[null,204]
[null,205]
[null,206]
[null,207]
[null,208]
[null,209]
[null,210]
[null,211]
[null,212]
[null,213]
[null,214]
[null,215]
[null,216]
[null,217]
[null,218]
[null,219]
[null,220]
[null,221]
[null,222]
[null,223]
[null,224]
[null,225]
[null,226]
[null,227]
[null,228]
[null,229]
[null,230]
[null,231]
[null,232]
[null,233]
[null,234]
[null,235]
[null,236]
[null,237]
[null,238]
[null,239]
[null,240]
[null,241]
[null,242]
[null,243]
[null,244]
[null,245]
[null,246]
[null,247]
[null,248]
[null,249]
[null,250]
[null,251]
[null,252]
[null,253]
[null,254]
[null,255]
[null,256]
[null,257]
[null,{"$f":"1+B261","v":258}]
[null,259]
[null,260]
[null,261]
[null,262]
[null,263]
[null,264]
[null,265]
[null,266]
[null,267]
[null,268]
[null,269]
[null,270]
[null,271]
[null,272]
[null,273]
[null,274]
[null,275]
[null,276]
[null,277]
[null,278]
[null,279]
[null,280]
[null,281]
[null,282]
[null,283]
[null,284]
[null,285]
[null,286]
[null,287]
[null,288]
[null,289]
[null,290]
[null,291]
[null,292]
[null,293]
[null,294]
[null,295]
[null,296]
[null,297]
[null,298]
[null,299]
[null,300]
[null,301]
[null,302]
[null,303]
[null,304]
[null,305]
[null,306]
[null,307]
[null,308]
[null,309]
[null,310]
[null,311]
[null,312]
[null,313]
[null,314]
[null,315]
[null,316]
[null,317]
[null,318]
[null,319]
[null,320]
[null,321]
[null,{"$f":"1+B325","v":322}]
[null,323]
[null,324]
[null,325]
[null,326]
[null,327]
[null,328]
[null,329]
[null,330]
[null,331]
[null,332]
[null,333]
[null,334]
[null,335]
[null,336]
[null,337]
[null,338]
[null,339]
[null,340]
[null,341]
[null,342]
[null,343]
[null,344]
[null,345]
[null,346]
[null,347]
[null,348]
[null,349]
[null,350]
[null,351]
[null,352]

{"sheet":"Simbologia","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Simbologia e formule"]
[null,null,null,null,"Input coordinate locations "]
[null,null,null,null,"At the beginning of segment ","xi, yi"]
[null,null,null,null,"At the end of segment ","xj, yj"]
[null,null,null,null,"Cross-section total height ","H = ymax-ymin"]
[null,null,null,null,"Cross-section total width ","W = xmax-xmin"]
[null,null,null,null,"Total cross-section area ","A = S (yi-yj)(xi+xj)/2"]
[null,null,null,null,"Perimeter ","P = S sqrt[(yi-yj)²+(xi-xj)²]"]
[null,null,null,null,"Location of centroid with respect ","xc = S[(yi-yj)/8*((xi+xj)²+(xj-xi)²/3)]/A"]
[null,null,null,null," to the origin of reference axes ","yc = S[(xj-xi)/8*((yi+yj)²+(yj-yi)²/3)]/A"]
[null,null,null,null,"Moments of inertia about centroidal axes ","Ix = S(xj-xi)(yi+yj)(yj²+yi²)/12 - Ayc²"]
[null,null,null,null,"parallel to references axes ","Iy = S(yj-yi)(xi+xj)(xj²+xi²)/12 - Axc²"]
[null,null,null,null,"Product of inertia ","Ixy = S [(yj-yi)²(xj+xi)(xj²+xi²)/8 +"]
[null,null,null,null,null,"+ (yj-yi)(xjyi-xiyj)(xj²+xjxi+xi²)/3 +"]
[null,null,null,null,null,"+ (xjyi-xiyj)²(xj+xi)/4] *"]
[null,null,null,null,null,"* IF(xj=xi,0,1/(xj-xi)) - Axcyc"]
[null,null,null,null,"Section modulus ","Sxtop = Ix/(ymax-yc)"]
[null,null,null,null,"with respect to cenroidal axes ","Sxbot = Ix/(yc-ymin)"]
[null,null,null,null,"parallel to reference axes ","Syright = Iy/(xmax-xc)"]
[null,null,null,null,null,"Syleft = Iy/(xc-xmin)"]
[null,null,null,null,"Angle between principal and reference axes ","qp = (1/2)tan-1(-2Ixy/(Ix-Iy))"]
[null,null,null,null," Principal moments of inertia ","Ixp = Ixcos²qp+Iysin²qp - Ixysin(2qp)"]
[null,null,null,null,null,"Iyp = Ix+Iy-Iyp"]
[null,null,null,null,"Polar moment of inertia ","Ip = Ix+Iy"]
[null,null,null,null,"Location of custom axes orgin from ref. axes ","xo, yo"]
[null,null,null,null,"Angle between custom and ref. axes ","qo"]
[null,null,null,null,"First moment of inertia ","qxo = Ayco"]
[null,null,null,null,"with respect to custom axes ","qyo = Axco"]
[null,null,null,null,"Location of centroid with respect ","xco = (xc-xo)cosqo + (yc-yo)sinqo"]
[null,null,null,null," to the origin of custom axes ","yco = -(xc-xo)sinqo + (yc-yo)cosqo"]