{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Flessione rettangolare","Nascosto"," Sezione in C.A."],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Flessione rettangolare","index":0,"n_rows":150,"n_cols":21,"rows_kept":150,"cut":false,"hidden":false,"merged":[[53,4,53,6],[57,1,57,2],[55,1,55,2],[54,1,54,2],[15,18,15,19],[20,2,20,3],[20,1,21,1],[16,1,16,2],[28,1,28,2],[45,1,45,2],[47,1,47,2],[49,1,49,2],[50,1,50,2],[30,1,30,2],[19,1,19,6],[20,5,21,6],[4,12,4,14],[8,18,8,19],[9,18,9,19],[10,18,10,19],[15,1,15,2],[7,17,7,19],[14,1,14,2],[11,1,11,2],[14,23,14,26],[8,20,8,21],[9,20,9,21],[10,20,10,21],[11,20,11,21],[94,1,94,4],[94,5,97,5],[15,20,15,21],[16,20,16,21],[12,20,12,21],[13,20,13,21],[90,9,91,9],[33,1,33,3],[34,1,34,2],[41,1,41,2],[39,1,39,2],[38,1,38,2],[31,1,31,2],[37,1,37,2],[40,1,40,2],[14,20,14,21],[90,2,91,2],[90,8,92,8],[35,1,35,2],[43,1,43,2],[44,1,44,2],[36,1,36,2],[56,1,56,2],[51,1,51,2],[86,1,86,10],[87,1,87,10],[61,9,62,9],[89,1,89,10],[48,1,48,2],[52,1,52,2],[53,1,53,2],[58,1,58,2],[120,7,120,8],[100,8,102,8],[113,7,113,9],[100,2,101,2],[99,1,99,10],[0,1,0,10],[10,1,10,2],[9,1,9,4],[7,2,7,3],[7,5,7,7],[6,1,6,10],[20,4,21,4],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Vers. 1.0 Gennaio 2016"]
[]
[null,"Cliente:","Ing. Mario Rossi",null,"Cantiere:","Via Mario Rossi, 4 - 80100 Napoli",null,null,"Rif. Strutt.:","58-T316"]
[]
[null,"Dati di Input Sezione"]
[null,"Altezza ( H )",null,1000,"mm"]
[null,"Base ( B )",null,400,"mm"]
[null,"Area di acciaio in trazione As",null,3000,"mm2"]
[null,"Area di acciaio in compressione A's",null,100,"mm2"]
[null,"Copriferro ( d1=d2 )",null,20,"mm"]
[null,"Altezza utile ( d )",null,{"$f":"D11-D15","v":980},"mm"]
[null,"Area di lamina Af",null,{"$f":"D45*D38*D44","v":280},"mm2"]
[]
[]
[null,"Materiali "]
[null,null,"Resistenze ",null,"Moduli elastici"]
[null,null,"Medie","Calcolo"]
[null,"Calcestruzzo fcm [MPa]",30,{"$f":"+C23/C26","v":25},{"$f":"22000*(C23/10)^0.3","v":30588.561746950003},"fck",{"$f":"C23-8","v":22}]
[null,null,null,null,null,"fctm",{"$f":"0.3*(G23)^(2/3)","v":2.3554273231619072}]
[null,"Acciaio fym [MPa]",391,{"$f":"+C25/C26","v":325.83333333333337},210000,"esy",{"$f":"D25/E25","v":1.5515873015873017E-3}]
[null,"Fattore di confidenza FC",{"$f":"+LOOKUP(Nascosto!AB6,Nascosto!Z6:Z8,Nascosto!AA6:AA8)","v":1.2}]
[]
[]
[null,"Momento iniziale agente in sezione prima dell'applicazione delle fibre M0 [kNm]",null,0]
[]
[null,"Materiale ",null,"Tipo di fibra","Esposizione"]
[null,11,null,{"$f":"LOOKUP(B32,Nascosto!R23:R38,Nascosto!AA23:AA38)","v":"Carbonio"},1]
[]
[null,"CARATTERISTICHE FRP"]
[null,"s caratteristica di rottura",null,{"$f":"LOOKUP($B$32,Nascosto!R23:R38,Nascosto!S23:S38)","v":3100}]
[null,"e caratteristica di rottura, efk",null,{"$f":"LOOKUP($B$32,Nascosto!R23:R47,Nascosto!V23:$V47)","v":1.8235294117647058E-2}]
[null,"Modulo elastico",null,{"$f":"LOOKUP($B$32,Nascosto!R23:R38,Nascosto!T23:T38)","v":170000}]
[null,"Spessore equivalente tessuto secco ( tf )",null,{"$f":"LOOKUP($B$32,Nascosto!R23:R38,Nascosto!U23:U38)","v":1.4}]
[null,"Coefficiente di sicurezza per distacco FRP ( gf,d )",null,1.2]
[null,"Coefficiente parziale del materiale ( gf )",null,1.1000000000000001]
[null,"Fattore di conversione ambientale (ha)",null,{"$f":"LOOKUP(E32,Nascosto!AD18:AD20,Nascosto!AG18:AG20)","v":0.85}]
[null,"s calcolo, ff,d",null,{"$f":"D35/D39*D41","v":2195.8333333333335}]
[]
[null,"Larghezza rinforzo ( bf )",null,200]
[null,"N° strati rinforzo  ( n )",null,1]
[null,"Coefficiente per condizione di carico  ( kq )",null,"Carico concentrato"]
[]
[null,"kb",null,{"$f":"IF(((2-D50)/(1+D50))^0.5>1,((2-D50)/(1+D50))^0.5,1)","v":1}]
[null,"kG",null,{"$f":"LOOKUP(B32,Nascosto!R23:R40,Nascosto!AB23:AB40)","v":2.3E-2}]
[null,"bf / b",null,{"$f":"+IF(D44/D12>=0.25,D44/D12,0.25)","v":0.5}]
[null,"ffdd,2  Resist. di prog al distacco FRP (mod 2)",null,{"$f":"IF(D46=Nascosto!AA11,+Nascosto!AC11/D39*SQRT(D37*2*D48*0.1/(D45*D38)/C26*SQRT(C23*G24)),Nascosto!AC12/D39*SQRT(D37*2*D48*0.1/(D45*D38)/C26*SQRT(C23*G24)))","v":343.7172373317091}]
[null,"ef,dd  Deformazione max di distacco FRP",null,{"$f":"D51/D37","v":2.0218661019512302E-3}]
[null,"e0    lembo teso CLS all'applicazione dell'FRP",null,{"$f":"+G70","v":0}]
[null,"esy - e0",null,{"$f":"+G25-G70","v":1.5515873015873017E-3},{"$f":"+IF(D52>=D54,\"\",\"Equazione4.7\")","v":""}]
[null,"Gfd   Energia specifica di frattura",null,{"$f":"+D48*D49*SQRT(C23*G24)/C26","v":0.1611172615126848}]
[null,"fbd   Resist. di prog. adesione FRP-CLS",null,{"$f":"2*D55/0.25","v":1.2889380921014784}]
[null,"led    Lunghezza ottimale di ancoraggio",null,{"$f":"+MAX(((SQRT((PI()^2*D37*D45*D38*D55)/2))/1.25/D56),200)","v":269.9928837758282}]
[null,"ffdd   Resist. di prog. al distacco FRP (mod 1)",null,{"$f":"+SQRT(2*D37*D55/(D45*D38))/D39","v":164.84099619013702}]
[null,"e calcolo, efd",null,{"$f":"+MAX(MIN(D41*D36/D40,D52),D54)","v":2.0218661019512302E-3}]
[]
[null,null,null,"Calcolo della deformazione iniziale eo"]
[null,"Coefficiente di omogeneizzazione acciaio-cls",null,null,null,15,null,"ipotesi 1: asse neutro taglia soletta","yc [mm]","Premere CTRL+ b per trovare l'asse neutro in ipotesi 1","Inerzia [mm4]"]
[null,"Posizione dell'asse neutro della sezione in C.A. (equazione Sn=0)",null,null,null,null,null,{"$f":"D12*I63*I63*0.5+F62*D14*(I63-D15)-F62*D13*(D16-I63)","v":0},367.6550139231872,null,{"$f":"D12/3*I63^3+F62*D14*(I63-D15)^2+F62*D13*(D16-I63)^2","v":23680917224.333977}]
[]
[null,null,null,null,null,null,null,"asse neutro effettivo"]
[null,null,null,null,null,null,null,{"$f":"I63","v":367.6550139231872},"mm"]
[]
[null,"Momento di inerzia della sezione in C.A.",null,null,null,{"$f":"K63","v":23680917224.333977},"mm4  "]
[null,"Deformazione nel calcestruzzo compresso: eco",null,null,null,null,{"$f":"D29*1000000/(E23*F68)*H66","v":0}]
[null,"Deformazione della fibra inferiore della sezione in c.a.: eo",null,null,null,null,{"$f":"G69*(D11-H66)/H66","v":0}]
[]
[null,"Posto:","yc  = profondità dell'asse neutro"]
[null,null,"yel = la profondità dell'asse neutro in corrispondenza del cls allo 0,35% e dell'acciaio al limite elastico"]
[null,null,null,"yel = ",{"$f":"0.0035/(0.0035+G25)*D16","v":678.99450117831884},"cm"]
[null,null,"yc,bilanc =","la profondità dell'asse neutro per rottura bilanciata",null,null,null,null,"xbilanc=0.0035/(0.0035+efd,u+eo)"]
[null,null,null,"yc,bilanc =",{"$f":"+J76*D11","v":633.8436925812498},"cm",null,null,"xbilanc = yc,bilanc / H =",{"$f":"0.0035/(0.0035+D59+G70)","v":0.63384369258124984}]
[]
[null,"Regioni di Rottura"]
[null,"Regione 1","yc < yc,bilan","deformazione cls",null,"< 0.0035"]
[null,null,null,"deformazione lamina =",null,null,{"$f":"+D59","v":2.0218661019512302E-3}]
[null,"Regione 2","yc > yc,bilan","deformazione cls =",null,{"$f":" 0.0035","v":3.5000000000000001E-3}]
[null,null,"yc < yc,el","deformazione acciaio compresa tra es,el e 0.01"]
[null,"Regione 3","yc > yc,el","deformazione cls =",null,{"$f":" 0.0035","v":3.5000000000000001E-3}]
[null,null,"yc < d","acciaio elastico"]
[]
[]
[null,"Output: calcolo dell'asse neutro a rottura e del momento ultimo (yc, Mu)"]
[null,"E' una procedura iterativa in cui si ipotizza un valore per yc e si verifica che corrisponda  Nu=0 (rottura in flessione semplice)"]
[]
[]
[null,"yc ","regione","y","l","s's ","ss ","sf ","Premere CTRL+q ","eq. Traslazione","MRd"]
[null,"mm",null,"ad.","ad.","MPa","MPa","MPa",null,null,"kN m"]
[null,{"$f":"B103","v":213.50486679162836},{"$f":"C103","v":1},0.8,0.41599999999999998,{"$f":"IF(D14=0,0,+F103)","v":104.46421342474446},{"$f":"IF(D13=0,0,G103)","v":325.83333333333337},{"$f":"H103","v":343.71723733170916},null,{"$f":"J103","v":644744.52922262263},{"$f":"K103","v":1534.1268926019293}]
[]
[null,"Sezione non Rinforzata",null,null,null,null,null,null,null,"ec",{"$f":"K105","v":5.488632218315822E-4}]
[null,"yc ","s's ","ss ","MRd ",null,null,null,null,"e's",{"$f":"K106","v":4.9744863535592602E-4}]
[null,"mm","MPa","MPa","kN m",null,null,null,null,"es",{"$f":"K107","v":1.9704515154755739E-3}]
[null,{"$f":"' Sezione in C.A.'!A41","v":118.11458333333334},{"$f":"' Sezione in C.A.'!E41","v":325.83333333333337},{"$f":"' Sezione in C.A.'!F41","v":325.83333333333337},{"$f":"' Sezione in C.A.'!J41","v":910.86922297222236},null,null,null,null,"efrp",{"$f":"K108","v":2.0218661019512302E-3}]
[]
[]
[null,"yc ","regione","y","l","s's ","ss ","sf ",null,"eq. Traslazione","Mu "]
[null,"[mm]",null,"ad.","ad.","MPa","MPa","MPa",null,null,"[kN m]"]
[null,213.50486679162836,{"$f":"IF($B$103<E76,1,IF($B$103<$E$74,2,3))","v":1},0.8,0.41599999999999998,{"$f":"IF(C103=1,IF($D$59/($D$11-$B$103)*($B$103-$D$15)>$G$25,$D$25,$E$25*$D$59/($D$11-$B$103)*($B$103-$D$15)),IF(OR($C$103=2,$C$103=3),IF(0.0035/$B$103*($B$103-$D$15)>$G$25,$D$25,$E$25*0.0035/$B$103*($B$103-$D$15))))","v":104.46421342474446},{"$f":"IF(OR($C$103=1,$C$103=2),$D$25,$E$25*(0.0035/$B$103*($D$16-$B$103)))","v":325.83333333333337},{"$f":"IF($C$103=1,$D$59*$D$37,$D$37*(0.0035/$B$103*($D$11-$B$103)-$G$70))","v":343.71723733170916},null,{"$f":"$D$103*$D$12*$B$103*$D$23+$D$14*$F$103-$D$13*$G$103-$D$17*$H$103","v":644744.52922262263},{"$f":"($D$103*$D$12*$B$103*$D$23*($D$16-$E$103*$B$103)+$D$14*$F$103*($D$16-$D$15)+$D$17*$H$103*$D$15)/1000000","v":1534.1268926019293}]
[null,"x=yc/H",null,null,null,null,null,null,"zona 1","zona 2"]
[null,{"$f":"B103/$D$11","v":0.21350486679162836},null,null,null,null,null,"eps cls",{"$f":"+I108/(D11-B103)*(B103)+G69","v":5.488632218315822E-4},3.5000000000000001E-3,{"$f":"+IF(AND($I$108=$D$59,$I$105<0.0035)=TRUE,I105,J105)","v":5.488632218315822E-4}]
[null,null,null,null,null,null,null,"eps acciaio comp",{"$f":"+I108/(D11-B103)*(B103-D15)+G69/(H66)*(H66-D15)","v":4.9744863535592602E-4},{"$f":"+J105/B103*(B103-D15)","v":3.1721386212319137E-3},{"$f":"+IF(AND($I$108=$D$59,$I$105<0.0035)=TRUE,I106,J106)","v":4.9744863535592602E-4}]
[null,null,null,null,null,null,null,"eps acciaio teso",{"$f":"+I108/(D11-B103)*(D16-B103)+G70/(D11-H66)*(D16-H66)","v":1.9704515154755739E-3},{"$f":"+J105/B103*(D16-B103)","v":1.2565207559636258E-2},{"$f":"+IF(AND($I$108=$D$59,$I$105<0.0035)=TRUE,I107,J107)","v":1.9704515154755739E-3}]
[null,null,null,null,null,null,null,"eps frp",{"$f":"+D59","v":2.0218661019512302E-3},{"$f":"+J105/B103*(D11-B103)-G70","v":1.2893068938404344E-2},{"$f":"+IF(AND($I$108=$D$59,$I$105<0.0035)=TRUE,I108,J108)","v":2.0218661019512302E-3}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0,{"$f":"+D11","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"+D12","v":400},{"$f":"+D11","v":1000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"T133","v":400},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,{"$f":"U132","v":1000}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As'",{"$f":"+D12/3","v":133.33333333333334},{"$f":"+D11-D15","v":980}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D12/3*2","v":266.66666666666669},{"$f":"+U143","v":980}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As",{"$f":"D12/3","v":133.33333333333334},{"$f":"+D15","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12/3*2","v":266.66666666666669},{"$f":"+U145","v":20}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Af",{"$f":"T134/2-D44/2","v":100},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T134/2+D44/2","v":300},0]

{"sheet":"Nascosto","index":1,"n_rows":63,"n_cols":33,"rows_kept":63,"cut":false,"hidden":true,"merged":[[5,0,5,2],[1,7,1,11]]}
["valori dei coeff. Adimens."]
[]
[null,null,null,null,null,null,null,null,"cls",null,"E","acciaio"]
[null,null,null,null,null,null,15,1,{"$f":"G4*0.85*0.83/1.5","v":7.0549999999999997},"C 12/15",{"$f":"22000*((0.83*G4+8)/10)^0.3","v":27266.580375060337},"Feb32k",{"$f":"315/(1.15)","v":273.91304347826087},3200]
[null,null,null,null,null,null,20,2,9.4066666666666663,"C 16/20",{"$f":"22000*((0.83*G5+8)/10)^0.3","v":28820.612943655724},"Feb38k",{"$f":"375/(1.15)","v":326.08695652173918},3800,null,null,null,null,null,null,null,null,null,"dist",null,null,"FC",null,null,null,"Table 9.1"]
["Tabella 10.2",null,null,null,null,null,25,3,11.758333333333333,"C 20/25",30200.493207846379,"Feb44k",{"$f":"430/(1.15)","v":373.91304347826087},4400,null,null,null,null,"Sistema di rinforzo certificato",null,null,null,1,1.2,null,1,1,2,null,null,"Exposure Conditions","Fiber Type","Envir. Red. Fact."]
["x","y","l",null,null,null,30,4,14.11,"C 25/30",31447.161439943484,"B 450C",{"$f":"450/1.15","v":391.304347826087},4500,null,null,null,null,"Sistema di rinforzo non certificato",null,null,null,2,1.5,null,2,1.2,null,null,1,"A. Aggressivo","Basalto",0.5]
[4.9999999999999004E-3,0.37178,0.34745999999999999,null,null,null,35,5,16.461666666666666,"C 28/35",32588.107818695287,"Da prove in situ",{"$f":"+'Flessione rettangolare'!C25/'Flessione rettangolare'!#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,3,1.35,null,null,2,null,"Carbonio",0.85]
[9.9999999999998996E-3,0.37178,0.34745999999999999,null,null,null,40,6,18.813333333333333,"C 32/40",33642.777677364676,null,null,null,null,null,null,null,"Interna - Vetro\\Epossidica",null,null,null,1,0.75,null,null,null,null,null,3,null,"Vetro",0.5]
[1.4999999999999901E-2,0.37178,0.34745999999999999,null,null,null,45,7,21.164999999999999,"C 35/45",34625.485235412678,null,null,null,null,null,null,null,"Interna - Arammidica\\Epossidica",null,null,null,2,0.85,null,null,"kq",2,null,null,"Esterna","Basalto",0.65]
[0.02,0.37178,0.34745999999999999,null,null,null,50,8,23.516666666666666,"C 40/50",35547.105284319208,null,null,null,null,null,null,null,"Interna - Carbonio\\Epossidica",null,null,null,3,0.95,null,1,"Carico distribuito",null,1.25,null,null,"Carbonio",0.85]
[2.5000000000000001E-2,0.37178,0.34745999999999999,null,null,null,55,9,25.868333333333329,"C 45/55",36416.113897745636,null,null,null,null,null,null,null,"Esterna - Vetro\\Epossidica",null,null,null,4,0.65,null,2,"Carico concentrato",null,1,null,null,"Vetro",0.65]
[0.03,0.37178,0.34745999999999999,null,null,null,null,10,{"$f":"'Flessione rettangolare'!C23/'Flessione rettangolare'!#REF!","v":{"$error":"#REF!"}},"Da prove in situ",{"$f":"22000*('Flessione rettangolare'!C23/10)^0.3","v":30588.561746950003},null,null,null,null,null,null,null,"Esterna - Arammidica\\Epossidica",null,null,null,5,0.75,null,null,null,null,null,null,"Interna","Basalto",0.75]
[3.5000000000000003E-2,0.37178,0.34745999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Esterna - Carbonio\\Epossidica",null,null,null,6,0.85,null,null,"KG",null,null,null,null,"Carbonio",0.95]
[0.04,0.37178,0.34745999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A. Aggressivo - Vetro\\Epossidica",null,null,null,7,0.5,null,null,"Lamina",2.3E-2,null,null,null,"Vetro",0.75]
[4.4999999999999998E-2,0.37178,0.34745999999999999,null,"xbilanc",{"$f":"'Flessione rettangolare'!J76","v":0.63384369258124984},"yc/H",null,null,null,null,null,null,null,null,null,null,null,"A. Aggressivo - Arammidica\\Epossidica",null,null,null,8,0.7,null,null,"Tessuto",3.6999999999999998E-2]
[0.05,0.37178,0.34745999999999999,null,"yc",{"$f":"'Flessione rettangolare'!D11*F16","v":633.8436925812498},null,null,null,null,null,null,null,null,null,null,null,null,"A. Aggressivo - Carbonio\\Epossidica",null,null,null,9,0.85]
[5.5E-2,0.37178,0.34745999999999999,null,"xbilanc",{"$f":"F17/'Flessione rettangolare'!D16","v":0.6467792781441325},"yc/d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"A. Aggressivo",null,{"$f":"INDEX(AF7:AG9,MATCH('Flessione rettangolare'!D32,AF7:AF9,0),2)","v":0.85}]
[0.06,0.37178,0.34745999999999999,null,"yc",{"$f":"'Flessione rettangolare'!D16*F18","v":633.8436925812498},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Esterna",null,{"$f":"INDEX(AF10:AG12,MATCH('Flessione rettangolare'!D32,AF10:AF12,0),2)","v":0.85}]
[6.5000000000000002E-2,0.37178,0.34745999999999999,null,"Valori che si usano solo per la sezione in c.a. con lamina",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Interna",null,{"$f":"INDEX(AF13:AG15,MATCH('Flessione rettangolare'!D32,AF13:AF15,0),2)","v":0.95}]
[7.0000000000000007E-2,0.37178,0.34745999999999999,null,"per fissare la regione di rottura",null,null,null,null,null,null,null,null,null,null,null,null,"tessuti","sigma ","E","s","eps","larghezza",null,null,null,null,"KG"]
[7.4999999999999997E-2,0.37178,0.34745999999999999]
[0.08,0.37178,0.34745999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R22+1","v":1},4840,89000,0.14299999999999999,3.15E-2,null,"MapeWrap B UNI-AX 400",null,null,"Basalto",3.6999999999999998E-2]
[{"$f":"AVERAGE(A23,A25)","v":8.4999999999999992E-2},{"$f":"AVERAGE(B23,B25)","v":0.39238499999999998},{"$f":"AVERAGE(C23,C25)","v":0.34861999999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4840,89000,0.218,3.15E-2,null,"MapeWrap B UNI-AX 600",null,null,"Basalto",3.6999999999999998E-2]
[0.09,0.41299000000000002,0.34977999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,5340,256000,0.13100000000000001,{"$f":"+S25/T25","v":2.0859374999999999E-2},null,"MapeWrap C UNI-AX 240 - E 256",null,null,"Carbonio",3.6999999999999998E-2]
[{"$f":"AVERAGE(A25,A27)","v":9.5000000000000001E-2},{"$f":"AVERAGE(B25,B27)","v":0.43283000000000005},{"$f":"AVERAGE(C25,C27)","v":0.35102500000000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,5340,256000,0.16400000000000001,{"$f":"+S26/T26","v":2.0859374999999999E-2},null,"MapeWrap C UNI-AX 300 - E 256",null,null,"Carbonio",3.6999999999999998E-2]
[0.1,0.45267000000000002,0.35227000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5340,256000,0.32800000000000001,{"$f":"+S27/T27","v":2.0859374999999999E-2},null,"MapeWrap C UNI-AX 600 - E 256",null,null,"Carbonio",3.6999999999999998E-2]
[{"$f":"AVERAGE(A27,A29)","v":0.10500000000000001},{"$f":"AVERAGE(B27,B29)","v":0.47167500000000001},{"$f":"AVERAGE(C27,C29)","v":0.35360999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,4830,230000,0.13300000000000001,{"$f":"+S28/T28","v":2.1000000000000001E-2},null,"MapeWrap C UNI-AX 240 - E 230",null,null,"Carbonio",3.6999999999999998E-2]
[0.11,0.49068000000000001,0.35494999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,4830,230000,0.16600000000000001,2.1000000000000001E-2,null,"MapeWrap C UNI-AX 300 - E 230",null,null,"Carbonio",3.6999999999999998E-2]
[{"$f":"AVERAGE(A29,A31)","v":0.11499999999999999},{"$f":"AVERAGE(B29,B31)","v":0.50876999999999994},{"$f":"AVERAGE(C29,C31)","v":0.35639500000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,4830,230000,0.33300000000000002,2.1000000000000001E-2,null,"MapeWrap C UNI-AX 600 - E 230",null,null,"Carbonio",3.6999999999999998E-2]
[0.12,0.52685999999999999,0.35783999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,4410,390000,0.16400000000000001,1.1307692307692309E-2,null,"MapeWrap C UNI-AX HM 300",null,null,"Carbonio",3.6999999999999998E-2]
[{"$f":"AVERAGE(A31,A33)","v":0.125},{"$f":"AVERAGE(B31,B33)","v":0.54396},{"$f":"AVERAGE(C31,C33)","v":0.35940499999999997},null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,4410,390000,0.32900000000000001,{"$f":"+S32/T32","v":1.1307692307692309E-2},null,"MapeWrap C UNI-AX HM 600",null,null,"Carbonio",3.6999999999999998E-2]
[0.13,0.56106,0.36097000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,3100,170000,1.4,{"$f":"+S33/T33","v":1.8235294117647058E-2},null,"Carboplate E 170",null,null,"Carbonio",2.3E-2]
[{"$f":"AVERAGE(A33,A35)","v":0.13500000000000001},{"$f":"AVERAGE(B33,B35)","v":0.57708999999999999},{"$f":"AVERAGE(C33,C35)","v":0.36266500000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,3300,200000,1.4,{"$f":"+S34/T34","v":1.6500000000000001E-2},null,"Carboplate E 200",null,null,"Carbonio",2.3E-2]
[0.14000000000000001,0.59311999999999998,0.36436000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,2500,250000,1.4,{"$f":"+S35/T35","v":0.01},null,"Carboplate E 250",null,null,"Carbonio",2.3E-2]
[{"$f":"AVERAGE(A35,A37)","v":0.14500000000000002},{"$f":"AVERAGE(B35,B37)","v":0.60797999999999996},{"$f":"AVERAGE(C35,C37)","v":0.36621000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,2560,80000,0.11799999999999999,{"$f":"S36/T36","v":3.2000000000000001E-2},null,"MapeWrap G UNI-AX 300",null,null,"Vetro",3.6999999999999998E-2]
[0.15,0.62283999999999995,0.36806,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,2560,80000,0.35399999999999998,{"$f":"S37/T37","v":3.2000000000000001E-2},null,"MapeWrap G UNI-AX 900 ",null,null,"Vetro",3.6999999999999998E-2]
[{"$f":"AVERAGE(A37,A39)","v":0.155},{"$f":"AVERAGE(B37,B39)","v":0.63643999999999989},{"$f":"AVERAGE(C37,C39)","v":0.37007499999999999},null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,2700,270000,0.16700000000000001,{"$f":"+S38/T38","v":0.01},null,"Esempio CNR DT 200 R1/2013",null,null,"carbonio",3.6999999999999998E-2]
[0.16,0.65003999999999995,0.37208999999999998]
[{"$f":"AVERAGE(A39,A41)","v":0.16335},{"$f":"AVERAGE(B39,B41)","v":0.65839000000000003},{"$f":"AVERAGE(C39,C41)","v":0.37355499999999997}]
[0.16669999999999999,0.66674,0.37502000000000002]
[{"$f":"AVERAGE(A41,A43)","v":0.16835},{"$f":"AVERAGE(B41,B43)","v":0.67062500000000003},{"$f":"AVERAGE(C41,C43)","v":0.37577000000000005}]
[0.17,0.67451000000000005,0.37652000000000002]
[{"$f":"AVERAGE(A43,A45)","v":0.17499999999999999},{"$f":"AVERAGE(B43,B45)","v":0.68540000000000001},{"$f":"AVERAGE(C43,C45)","v":0.37889}]
[0.18,0.69628999999999996,0.38125999999999999]
[{"$f":"AVERAGE(A45,A47)","v":0.185},{"$f":"AVERAGE(B45,B47)","v":0.70604},{"$f":"AVERAGE(C45,C47)","v":0.383685}]
[0.19,0.71579000000000004,0.38611000000000001]
[{"$f":"AVERAGE(A47,A49)","v":0.19500000000000001},{"$f":"AVERAGE(B47,B49)","v":0.72456000000000009},{"$f":"AVERAGE(C47,C49)","v":0.38851000000000002}]
[0.2,0.73333000000000004,0.39090999999999998]
[{"$f":"AVERAGE(A49,A51)","v":0.20500000000000002},{"$f":"AVERAGE(B49,B51)","v":0.7412700000000001},{"$f":"AVERAGE(C49,C51)","v":0.39324999999999999}]
[0.21,0.74921000000000004,0.39559]
[{"$f":"AVERAGE(A51,A53)","v":0.215},{"$f":"AVERAGE(B51,B53)","v":0.75642500000000001},{"$f":"AVERAGE(C51,C53)","v":0.39785000000000004}]
[0.22,0.76363999999999999,0.40011000000000002]
[{"$f":"AVERAGE(A53,A55)","v":0.22500000000000001},{"$f":"AVERAGE(B53,B55)","v":0.77022499999999994},{"$f":"AVERAGE(C53,C55)","v":0.40227500000000005}]
[0.23,0.77681,0.40444000000000002]
[{"$f":"AVERAGE(A55,A57)","v":0.23499999999999999},{"$f":"AVERAGE(B55,B57)","v":0.78285000000000005},{"$f":"AVERAGE(C55,C57)","v":0.40650500000000001}]
[0.24,0.78888999999999998,0.40856999999999999]
[{"$f":"AVERAGE(A57,A59)","v":0.245},{"$f":"AVERAGE(B57,B59)","v":0.79444500000000007},{"$f":"AVERAGE(C57,C59)","v":0.41053499999999998}]
[0.25,0.8,0.41249999999999998]
[{"$f":"AVERAGE(A59,A61)","v":0.2545},{"$f":"AVERAGE(B59,B61)","v":0.80463499999999999},{"$f":"AVERAGE(C59,C61)","v":0.41418500000000003}]
[0.25900000000000001,0.80927000000000004,0.41587000000000002]
[{"$f":"AVERAGE(A61,A63)","v":0.25914999999999999},{"$f":"AVERAGE(B61,B63)","v":0.80940000000000001},{"$f":"AVERAGE(C61,C63)","v":0.415935}]
[0.25929999999999997,0.80952999999999997,0.41599999999999998]

{"sheet":" Sezione in C.A.","index":2,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":true,"merged":[[11,0,11,1],[38,6,40,7],[5,11,5,13],[36,0,36,9],[9,0,10,1],[35,0,35,9],[12,0,12,1],[13,0,13,1],[32,6,32,8],[9,2,10,2],[9,3,10,3],[9,5,9,7],[7,8,8,8],[7,9,8,9],[3,18,3,22],[14,14,14,17],[22,11,22,15],[3,14,3,17],[14,11,14,12],[15,11,15,12],[12,11,12,12],[16,11,16,12],[3,11,3,13],[8,11,8,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[13,11,13,12],[57,5,57,6],[37,0,37,9],[38,1,39,1],[50,5,50,7],[0,0,0,9],[2,5,3,7],[7,0,8,1],[7,2,8,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[2,0,2,3],[1,0,1,9],[7,3,8,3],[6,0,6,1],[7,5,8,7]]}
["I. Calcolo del momento ultimo per sezione a T in  C.A.+FRP"]
["Dati di input"]
["Dati Sezione",null,null,null,null,"Materiali ",null,null,"Tensioni di calcolo","Moduli elastici"]
[null,null,null,null,null,null,null,null,"MPa","MPa"]
["altezza H",null,{"$f":"+'Flessione rettangolare'!D11","v":1000},"mm",null,"cls classe",3,null,{"$f":"+'Flessione rettangolare'!D23","v":25}]
["copriferro d1=d2",null,{"$f":"+'Flessione rettangolare'!D15","v":20},"mm",null,"acciaio",3,null,{"$f":"+'Flessione rettangolare'!D25","v":325.83333333333337},{"$f":"+'Flessione rettangolare'!E25","v":210000}]
["altezza utile d",null,{"$f":"C5-C6","v":980},"mm",null,"es,el",{"$f":"I6/J6","v":1.5515873015873017E-3}]
["Area di acciaio in trazione As",null,{"$f":"'Flessione rettangolare'!D13","v":3000},"mm2",null,"per acciaio qualsiasi inserire il valore medio della resistenza cilindrica ottenute mediante prove in situ ridotto mediante opportuni coefficienti di confidenza secondo quanto indicato dal cap. 11 del O.P.C.M. 3431",null,null,300,"MPa"]
[]
["Area di acciaio in compressione A's",null,{"$f":"'Flessione rettangolare'!D14","v":100},"mm2",null,"per cls qualsiasi inserire il valore medio della resistenza cilindrica ottenute mediante prove in situ ridotto mediante opportuni coefficienti di confidenza secondo quanto indicato dal cap. 11 del O.P.C.M. 3431",null,null,20,"MPa"]
[]
["Base B",null,{"$f":"+'Flessione rettangolare'!D12","v":400},"mm"]
[]
[]
[]
[]
[]
[]
["Posto:"]
["yc  = profondità dell'asse neutro"]
["yel = la profondità dell'asse neutro in corrispondenza del cls allo 0,35% e dell'acciaio al limite elastico"]
[null,"yc,bil =",{"$f":"G23*C7","v":50.072992700729927},"mm",null,"xbilanc=0.0035/(0.0035+esy)"]
[null,null,null,null,null,"xbilanc = yc,bilanc /d =",{"$f":"0.0035/(0.0035+0.065)","v":5.1094890510948905E-2}]
["yc,bilanc =","la profondità dell'asse neutro per rottura bilanciata"]
["yc,el =",{"$f":"0.0035/(0.0035+G7)*C7","v":678.99450117831884},"mm"]
[]
["Regioni di Rottura"]
["Regione 1","yc < yc,bilan","deformazione cls",null,"< 0.0035",null,{"$f":"IF(A41>C13,1,2)","v":1}]
[null,null,"deformazione lamina =",null,null,{"$f":"0.01","v":0.01}]
["Regione 2","yc > yc,bilan","deformazione cls =",null,{"$f":" 0.0035","v":3.5000000000000001E-3}]
[null,"yc < yc,el","deformazione acciaio compresa tra es,el e 0.01"]
["Regione 3","yc > yc,el","deformazione cls =",null,{"$f":" 0.0035","v":3.5000000000000001E-3}]
[null,"yc < d","acciaio elastico"]
[]
[]
["Output: calcolo dell'asse neutro a rottura e del momento ultimo (yc, Mu)"]
["E' una procedura iterativa in cui si ipotizza un valore per yc e si verifica che corrisponda  Nu=0 (rottura in flessione semplice)"]
["IPOTESI 1:  l'ASSE NEUTRO TAGLIA LA SOLETTA"]
["yc ","regione","y","l","s's ","ss ","Premere CTRL+r per imporre N=0 e ricavare yc e Mu",null,"eq. Traslazione","Mu "]
["[mm]",null,"ad.","ad.","MPa","MPa",null,null,null,"[kN m]"]
[118.11458333333334,{"$f":"IF($A$41<$C$22,1,IF($A$41<$B$25,2,3))","v":2},0.8,0.41599999999999998,{"$f":"+IF(ABS(I44)>G7,I6,I44*J6)","v":325.83333333333337},{"$f":"IF(OR($B$41=1,$B$41=2),$I$6,$J$6*(0.0035/$A$41*($C$7-$A$41)))","v":325.83333333333337},null,null,{"$f":"$C$41*$C$12*$A$41*$I$5+$C$10*$E$41-$C$8*$F$41","v":0},{"$f":"($C$41*$C$12*$A$41*$I$5*($C$7-$D$41*$A$41)+$C$10*$E$41*($C$7-$C$6))/1000000","v":910.86922297222236}]
["x = yc/H",null,null,null,{"$f":"+IF(ABS(I44)>G7,I6,I44*J6)","v":325.83333333333337},null,null,"zona 1","zona 2"]
[{"$f":"$A$41/$C$5","v":0.11811458333333334},null,null,null,null,null,"eps cls",{"$f":"+H45/(C7-A41)*(A41)","v":1.3704209521277241E-3},3.5000000000000001E-3]
[null,null,null,null,null,null,"eps acciaio comp.",{"$f":"+H45/(C7-A41)*(A41-C6)","v":1.138371544941444E-3},{"$f":"0.0035*($A$41-C6)/$A$41","v":2.9073551459564335E-3}]
[null,null,null,null,null,null,"eps acciaio teso",0.01,{"$f":"0.0035*($C$7-$A$41)/$A$41","v":2.5539597848134754E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["L'ipotesi che l'asse neutro taglia la soletta è corretta: ipotesi 1 ok!"]