{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["viga","aux","IPE","HEB"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"viga","index":0,"n_rows":139,"n_cols":25,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["MATERIALS",null,null,null,"SLAB",null,null,null,"STEEL BEAM",null,null,null,"GEOMETRY",null,null,null,"LOADS",null,null,null,"ELASTIC INTERNAL FORCES",null,null,null,"Análisis plástico de solicitaciones: (suponemos clase 1, aunque clase 2 permite redistribuciones grandes)"]
["CONCRETE",null,null,null,"upper thickness","[mm]",60,null,"rank","[-]","primary",null,"L","[m]",6,null,"flooring","[kN/m2]",1,null,"Miso,ELU","[kNm]",{"$f":"$S$20*$O$2^2/8","v":254.24958375000003},null,"Tipo de solicitación para clase de sección: se entiende que siempre es flexión, no compresión (en tracción no hay abolladura)"]
["fck","[N/mm2]",25,null,"height ribs","[mm]",60,null,"type","[-]","HEB",null,"similar Ladj","[-]","N",null,"walls","[kN/m2]",1,null,"Vel,ELU,pers,A","[kN]",{"$f":"$S$20*$O$2*N24","v":127.12479187500001}]
["cement","[-]","normal",null,"width ribs","[mm]",100,null,"size","[mm]",200,null,"Ladj,diff,A","[m]",0,null,"other G","[kN/m2]",null,null,"Vel,ELU,pers,B","[kN]",{"$f":"$S$20*$O$2*N25","v":211.87465312500001},null,"Se calcula la resistencia a positivos, y se obtiene la curva de momentos compatible"]
["exposition to RH","[-]","none",null,"dist ribs","[mm]",210,null,"following rank type","[-]","IPE",null,"Ladj,diff,B","[m]",2.4,null,"Q","[kN/m2]",3,null,"Mel,ELU,pers,A","[kNm]",{"$f":"$S$20*$O$2^2*N26","v":0},null,"con las cargas (i.e. que cumple momento isostático) y los apoyos, y se la hace pasar por el M resistente"]
["RH","[-]",0.5,null,"total depth","[mm]",{"$f":"G2+G3","v":120},null,"following rank size","[mm]",100,null,"similar transv. range","[-]","N",null,"cathegory Q","-","use A-B, snow high",null,"Mel,ELU,pers,C","[kNm]",{"$f":"$S$20*$O$2^2*N27","v":127.12479187500001},null,"a positivos (reducido un poco en el caso de pin-fix para considerar que la \"panza\" se alcanza un poco "]
["t0","[days]",7,null,"full/empty","[-]",{"$f":"IF(G3=0,1,G4/G5)","v":0.47619047619047616},null,"following rank dist","[m]",1.5,null,"transv. range left","[m]",5,null,"partition walls","-","average",null,"Mel,ELU,pers,B","[kNm]",{"$f":"$S$20*$O$2^2*N28","v":254.24958375000003},null,"hacia el extremo apoyado), calculándose los M negativos solicitación (primero en B y luego en A)"]
["Creep code","[-]","average",null,"eq. thickness","[mm]",{"$f":"G2+G7*G3","v":88.571428571428569},null,"following rank weight","[kN/m]",{"$f":"IF(K6=0,0,0.01*IF(K5=aux!K2,INDEX(IPE!B3:B21,MATCH(K6,IPE!A3:A21,0)),IF(K5=aux!K3,INDEX(HEB!B3:B21,MATCH(K6,HEB!A3:A21,0)))))","v":8.1000000000000003E-2},null,"transv. range diff (right)","[m]",5.85,null,"steel profiles","[kN/m2]",{"$f":"K11/((O14+O15)/1000)+IF(K2=aux!C2,0,K8/K7)","v":0.16699539170506913},null,"Mel,ELS,pers,A","[kNm]",{"$f":"$S$25*$O$2^2*N26","v":0},null,"Esto permitiría teóricamente redistribuciones negativas (i.e. hacia arriba),"]
["γc","[-]",1.5,null,"r top","[mm]",20,null,"BEAM PROPERTIES",null,null,null,"Ladj,A","[m]",{"$f":"IF(O3=aux!A1,O2,IF(O4=0,O2,O4))","v":6},null,"slab","[kN/m2]",{"$f":"25*G8/1000","v":2.2142857142857144},null,"Mel,ELS,pers,C","[kNm]",{"$f":"$S$25*$O$2^2*N27","v":90.097762500000016},null,"En cualquier caso, se ofrece el valor de Md+,C (positivo solictación en CV)"]
["fcd","[N/mm2]",{"$f":"C3/C9","v":16.666666666666668},null,"r wave","[mm]",25,null,"class (bending)","[-]",{"$f":"IF(K3=aux!K2,INDEX(IF(C36=aux!B2,IPE!X3:X21,IF(C36=aux!B3,IPE!Y3:Y21,IPE!Z3:Z21)),MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(IF(C36=aux!B2,HEB!X3:X21,IF(C36=aux!B3,HEB!Y3:Y21,HEB!Z3:Z21)),MATCH(K4,HEB!A3:A21,0))))","v":1},null,"Ladj,B","[m]",{"$f":"IF(O3=aux!A1,O2,IF(O5=0,O2,O5))","v":2.4},null,"G","[kN/m2]",{"$f":"SUM(S2:S4)+SUM(S8:S9)","v":4.3812811059907837},null,"Mel,ELS,pers,B","[kNm]",{"$f":"$S$25*$O$2^2*N28","v":180.19552500000003},null,"para que se pueda obligar a que no aparezca ahí una rótula plástica."]
["fcm","[N/mm2]",{"$f":"C3+8","v":33},null,"# φ","[mm]",6,null,"weight","[kN/m]",{"$f":"0.01*IF(K3=aux!K2,INDEX(IPE!B3:B21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!B3:B21,MATCH(K4,HEB!A3:A21,0))))","v":0.61299999999999999},null,"Lmed,A","[m]",{"$f":"AVERAGE(O2,O9)","v":6},null,"γG","-",1.35,null,"manual","[Y/N]","N"]
["Ecm,28","[N/mm2]",{"$f":"22000*((C3+8)/10)^0.3","v":31475.806210019346},null,"distance","[mm]",200,null,"b","[mm]",{"$f":"IF(K3=aux!K2,INDEX(IPE!D3:D21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!D3:D21,MATCH(K4,HEB!A3:A21,0))))","v":200},null,"Lmed,B","[m]",{"$f":"AVERAGE(O2,O10)","v":4.2},null,"γQ","-",1.5,null,"Vel,ELU,pers,A","[kN]"]
["s (coef. cem)","[-]",{"$f":"IF(C4=aux!V2,aux!W2,IF(C4=aux!V3,aux!W3,aux!W4))","v":0.25},null,"φ ribs","[mm]",0,null,"h","[mm]",{"$f":"K4","v":200},null,"transv. range right","[m]",{"$f":"IF(O6=aux!A1,O7,O8)","v":5.85},null,"Ψ1","-",{"$f":"IF(S6=aux!G2,aux!H2,IF(S6=aux!G3,aux!H3,IF(S6=aux!G4,aux!H4,IF(S6=aux!G5,aux!H5))))","v":0.5},null,"Vel,ELU,pers,B","[kN]",null,null,"La evaluación de la interacción por cortante se hace"]
["t ∞","[days]",10000,null,"each n ribs","[-]",0,null,"tf","[mm]",{"$f":"IF(K3=aux!K2,INDEX(IPE!F3:F21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!F3:F21,MATCH(K4,HEB!A3:A21,0))))","v":15},null,"b,left","[mm]",{"$f":"O7/2*1000","v":2500},null,"Ψ2","-",{"$f":"IF(S6=aux!G2,aux!I2,IF(S6=aux!G3,aux!I3,IF(S6=aux!G4,aux!I4,IF(S6=aux!G5,aux!I5))))","v":0.3},null,"Mel,ELU,pers,A","[kNm]",null,null,"sobre la distribución de solicitaciones elástica;"]
["βcc","[-]",{"$f":"EXP(C13*(1-(28/C14)^0.5))","v":1.2671512154708973},null,"deck thickness","[mm]",0.8,null,"tw","[mm]",{"$f":"IF(K3=aux!K2,INDEX(IPE!E3:E21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!E3:E21,MATCH(K4,HEB!A3:A21,0))))","v":9},null,"b,right","[mm]",{"$f":"O13/2*1000","v":2925},null,"ηfi","-",{"$f":"S17/S16","v":0.5647080041679714},null,"Mel,ELU,pers,C","[kNm]",null,null,"puede ser una simplificación suficiente."]
["Creep factor EC4","[-]",{"$f":"1+C17*C18","v":2.9576274306783441},null,"eq deck thickness","[mm]",{"$f":"G15*(G5+2*G3)/G5","v":1.2571428571428571},null,"tw,eq","[mm]",{"$f":"K20/K17","v":10.639058823529414},null,null,null,null,null,"P,ELU,pers","[kN/m2]",{"$f":"S10*S11+S5*S12","v":10.41472949308756},null,"Mel,ELU,pers,B","[kNm]"]
["ΨL","[-]",1.1000000000000001,null,null,null,null,null,"hw","[mm]",{"$f":"K13-2*K14","v":170},null,"BOUNDARY CONDITIONS",null,null,null,"P,ELU,acc","[kN/m2]",{"$f":"S10+S5*S13","v":5.8812811059907837},null,"Mel,ELS,pers,A","[kNm]",null,null,"Para el cálculo de conectores, se podría hacer por capacidad,"]
["ϕt","[-]",{"$f":"C19*C22","v":1.7796613006166764},null,"STUDS",null,null,null,"A","[mm2]",{"$f":"IF(K3=aux!K2,INDEX(IPE!H3:H21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!H3:H21,MATCH(K4,HEB!A3:A21,0))))","v":7808.64},null,"constraint A","pin",null,null,"P,ELS,pers","[kN/m2]",{"$f":"S10+S5","v":7.3812811059907837},null,"Mel,ELS,pers,C","[kNm]",null,null,"es decir, para que siempre tuvieran más resistencia que las"]
["ϕ0","[-]",{"$f":"C20*16.8/(C11)^0.5/(0.1+C7^0.2)","v":1.8559172673663049},null,"n in a row","[-]",1,null,"A,flange","[mm2]",{"$f":"K12*K14","v":3000},null,"constraint B","fix",null,null,"P,ELS,cuasi","[kN/m2]",{"$f":"S10+S14*S5","v":5.281281105990784},null,"Mel,ELS,pers,B","[kNm]",null,null,"piezas, pero parece exagerado sobre todo cuando hay mucha"]
["ϕRH","[-]",{"$f":"(1+(1-C6)/(0.1*C21^(1/3))*IF(C11<=35,1,(35/C11)^0.7))*IF(C11<=35,1,(35/C11)^0.2)","v":1},null,"b0","[mm]",0,null,"A,web","[mm2]",{"$f":"K18-2*K19","v":1808.6400000000003},null,"global constraint",{"$f":"IF(CONCATENATE(N18,\"-\",N19)=\"fix-pin\",\"IMPOSSIBLE\",CONCATENATE(N18,\"-\",N19))","v":"pin-fix"},null,null,"q,ELU,pers","[kN/m]",{"$f":"S16*($O$14+$O$15)/1000","v":56.499907500000006},null,"Vel,ELU,pers,A","[kN]",{"$f":"IF($W$11=aux!$A$2,W3,W12)","v":127.12479187500001},null,"sobrerresistencia a momento."]
["h0","[mm]",{"$f":"2*P36*G8/IF(C5=aux!X2,2*P36,IF(OR(C5=aux!X3,C5=aux!X4),P36,1E-99))","v":2.2585714285714284E+104},null,"diam","[mm]",16,null,"I","[mm4]",{"$f":"10000*IF(K3=aux!K2,INDEX(IPE!I3:I21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!I3:I21,MATCH(K4,HEB!A3:A21,0))))","v":56961700},null,"factor L A",{"$f":"IF(N20=aux!L2,aux!M2,IF(N20=aux!L3,aux!M3,IF(N20=aux!L4,aux!M4,IF(N20=aux!L5,aux!M5))))","v":0.85},null,null,"q,ELU,acc","[kN/m]",{"$f":"S17*($O$14+$O$15)/1000","v":31.905950000000001},null,"Vel,ELU,pers,B","[kN]",{"$f":"IF($W$11=aux!$A$2,W4,W13)","v":211.87465312500001},null,"Se calcula a partir de las solicitaciones elásticas, suponiendo"]
["βc(t,t0)","[-]",{"$f":"((C14-C7)/(C23+C14-C7))^0.3","v":0.95891197948826579},null,"h","[mm]",90,null,"Npl,Rd","[kN]",{"$f":"IF(K3=aux!K2,INDEX(IF(C36=aux!B2,IPE!AA3:AA21,IF(C36=aux!B3,IPE!AB3:AB21,IF(C36=aux!B4,IPE!AC3:AC21))),MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(IF(C36=aux!B2,HEB!AA3:AA21,IF(C36=aux!B3,HEB!AB3:AB21,IF(C36=aux!B4,HEB!AC3:AC21))),MATCH(K4,HEB!A3:A21,0))))","v":2045.12},null,"factor L C",{"$f":"IF(N20=aux!L2,aux!N2,IF(N20=aux!L3,aux!N3,IF(N20=aux!L4,aux!N4,IF(N20=aux!L5,aux!N5))))","v":0.85},null,null,"q,ELS,slab","[kN/m]",{"$f":"(S8+S9)*($O$14+$O$15)/1000","v":12.91845},null,"Mel,ELU,pers,A","[kNm]",{"$f":"IF($W$11=aux!$A$2,W5,W14)","v":0},null,"que el eje neutro es el mismo que para la situación última, es decir,"]
["βH","[-]",{"$f":"MIN(1.5*(1+(1.2*C6)^18)*C21+250*IF(C11<=35,1,(35/C11)^0.5),1500*IF(C11<=35,1,(35/C11)^0.5))","v":1500},null,"hmax","[mm]",{"$f":"G6-G9","v":100},null,"Vpl,Rd","[kN]",{"$f":"IF(K3=aux!K2,INDEX(IF(C36=aux!B2,IPE!AJ3:AJ21,IF(C36=aux!B3,IPE!AK3:AK21,IF(C36=aux!B4,IPE!AL3:AL21))),MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(IF(C36=aux!B2,HEB!AJ3:AJ21,IF(C36=aux!B3,HEB!AK3:AK21,IF(C36=aux!B4,HEB!AL3:AL21))),MATCH(K4,HEB!A3:A21,0))))","v":375.55},null,"factor L B",{"$f":"IF(N20=aux!L2,aux!O2,IF(N20=aux!L3,aux!O3,IF(N20=aux!L4,aux!O4,IF(N20=aux!L5,aux!O5))))","v":0.5},null,null,"q,ELS,G-self_weight","[kN/m]",{"$f":"(S10-S8-S9)*($O$14+$O$15)/1000","v":10.85},null,"Mel,ELU,pers,C","[kNm]",{"$f":"IF($W$11=aux!$A$2,W6,W15)","v":127.12479187500001},null,"como si en esa situación se pudiera asumir diagramas rectangulares"]
["Creep factor EHE-08","[-]",{"$f":"1+C25","v":2.2899855584986826},null,"h/d","[-]",{"$f":"G22/G21","v":5.625},null,"Ma,pl,Rd","[kNm]",{"$f":"IF(K3=aux!K2,INDEX(IF(C36=aux!B2,IPE!AD3:AD21,IF(C36=aux!B3,IPE!AE3:AE21,IF(C36=aux!B4,IPE!AF3:AF21))),MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(IF(C36=aux!B2,HEB!AD3:AD21,IF(C36=aux!B3,HEB!AE3:AE21,IF(C36=aux!B4,HEB!AF3:AF21))),MATCH(K4,HEB!A3:A21,0))))","v":168.29},null,"factor V A",{"$f":"IF(N20=aux!L2,aux!P2,IF(N20=aux!L3,aux!P3,IF(N20=aux!L4,aux!P4,IF(N20=aux!L5,aux!P5))))","v":0.375},null,null,"q,ELS,Q","[kN/m]",{"$f":"S5*($O$14+$O$15)/1000","v":16.274999999999999},null,"Mel,ELU,pers,B","[kNm]",{"$f":"IF($W$11=aux!$A$2,W7,W16)","v":254.24958375000003},null,"a menor fcd y fsd en vez de diagramas triangulares"]
["λ","[-]",{"$f":"C26/(1+50*C29)","v":1.2899855584986828},null,"α","[-]",{"$f":"IF(G24<4,0.2*(G24+1),1)","v":1},null,"c/t web limit bending+compression","[-]",null,null,"factor V B",{"$f":"IF(N20=aux!L2,aux!Q2,IF(N20=aux!L3,aux!Q3,IF(N20=aux!L4,aux!Q4,IF(N20=aux!L5,aux!Q5))))","v":0.625},null,null,"q,ELS,pers","[kN/m]",{"$f":"S18*($O$14+$O$15)/1000","v":40.043450000000007},null,"Mel,ELS,pers,A","[kNm]",{"$f":"IF($W$11=aux!$A$2,W8,W17)","v":0},null,"Se supone, conservadoramente, que en vigas paralelas a las ondas"]
["ξ","[-]",{"$f":"2-0.3","v":1.7},null,"Prd","[kN]",{"$f":"MIN(0.8*C46*PI()/4*G21^2/C47,0.29*G25*G21^2*(C3*C12)^0.5/C47)/1000","v":52.684927400399211},null,"c/t flange limit","[-]",null,null,"factor M A",{"$f":"IF(N20=aux!L2,aux!R2,IF(N20=aux!L3,aux!R3,IF(N20=aux!L4,aux!R4,IF(N20=aux!L5,aux!R5))))","v":0},null,null,"q,ELS,cuasi","[kN/m]",{"$f":"S19*($O$14+$O$15)/1000","v":28.650950000000005},null,"Mel,ELS,pers,C","[kNm]",{"$f":"IF($W$11=aux!$A$2,W9,W18)","v":90.097762500000016},null,"el espacio para conectores es una onda, es decir, se desprecia la "]
["d eq","[mm]",{"$f":"O41+K13/2","v":220},null,"hsc","[mm]",{"$f":"MIN(G22,G3+75)","v":90},null,null,null,null,null,"factor M C",{"$f":"IF(N20=aux!L2,aux!S2,IF(N20=aux!L3,aux!S3,IF(N20=aux!L4,aux!S4,IF(N20=aux!L5,aux!S5))))","v":6.25E-2},null,null,null,null,null,null,"Mel,ELS,pers,B","[kNm]",{"$f":"IF($W$11=aux!$A$2,W10,W19)","v":180.19552500000003},null,"posible separación de chapas en el apoyo lateral en la viga"]
["As'","[mm2]",{"$f":"H37+P36*G16","v":1783.1060213568574},null,"k (kl or kt)","[-]",{"$f":"IF(G3=0,1,IF(K2=aux!C2,MIN(0.7/(G19)^0.5*G4/G3*(G27/G3-1),0.6),IF(K2=aux!C3,MIN(0.6*G4/G3*(G27/G3-1),1))))","v":0.5},null,null,null,null,null,"factor M B",{"$f":"IF(N20=aux!L2,aux!T2,IF(N20=aux!L3,aux!T3,IF(N20=aux!L4,aux!T4,IF(N20=aux!L5,aux!T5))))","v":0.125},null,null,null,null,null,null,"interaction V-M A","[Y/N]",{"$f":"IF(W20>0.5*$K$23,aux!A1,aux!A2)","v":"N"}]
["ρ'","[-]",{"$f":"C28/(P36*C27)","v":6.3568842116109E-3},null,"Prd,eff","[kN]",{"$f":"G26*G28","v":26.342463700199605},null,null,null,null,null,null,null,null,null,null,null,null,null,"interaction V-M B","[Y/N]",{"$f":"IF(W21>0.5*$K$23,aux!A1,aux!A2)","v":"Y"},null,"El cálculo de la flecha se hace con I+;"]
["Creep factor","[-]",{"$f":"IF(C8=aux!AC2,C16,IF(C8=aux!AC3,C24,AVERAGE(C16,C24)))","v":2.6238064945885133},null,null,null,null,null,null,null,null,null,"EFFECTIVE WIDTH",null,{"$f":"CONCATENATE(\"A (\",N18,\")\")","v":"A (pin)"},"C",{"$f":"CONCATENATE(\"B (\",N19,\")\")","v":"B (fix)"},null,null,null,"ρ interaction A","-",{"$f":"IF(W28=aux!A1,(2*W20/K23-1)^2,0)","v":0},null,"para voladizos puede ser del lado de la inseguridad,"]
["STEEL (REINFORCEMENT)",null,null,null,"COMPOSITE SECTION STIFNESS",null,null,null,null,null,null,null,"Le,A","[mm]",{"$f":"O11*N21*1000","v":5100},{"$f":"O2*N22*1000","v":5100},{"$f":"N23*1000*(IF(N20=aux!L2,O2,O12))","v":2100},null,null,null,"ρ interaction B","-",{"$f":"IF(W28=aux!A1,(2*W21/K23-1)^2,0)","v":0},null,"por lo que se toma una beff mitad de la considerada"]
["fyk","[N/mm2]",500,null,"Section","[-]","A","C","C","B",null,null,"be,left","[mm]",{"$f":"MIN($O$31/8,O14)","v":637.5},{"$f":"MIN($P$31/8,O14)","v":637.5},{"$f":"MIN($Q$31/8,O14)","v":262.5},null,null,null,null,null,null,null,"en negativos"]
["γs,reinf","[-]",1.1499999999999999,null,"Sign bending","[-]",{"$f":"aux!AB3","v":"-"},{"$f":"aux!AB2","v":"+"},{"$f":"aux!AB2","v":"+"},{"$f":"aux!AB3","v":"-"},null,null,"be,right","[mm]",{"$f":"MIN($O$31/8,O15)","v":637.5},{"$f":"MIN($P$31/8,O15)","v":637.5},{"$f":"MIN($Q$31/8,O15)","v":262.5}]
["fyd","[N/mm2]",{"$f":"C32/C33","v":434.78260869565219},null,"time","[-]",{"$f":"aux!AA4","v":"any"},{"$f":"aux!AA2","v":"short"},{"$f":"aux!AA3","v":"long"},{"$f":"aux!AA4","v":"any"},null,null,"βleft","[-]",{"$f":"IF(N18=aux!F3,MIN(1,0.55+0.025*O31/P36),1)","v":0.65},1,{"$f":"IF(N19=aux!F3,MIN(1,0.55+0.025*Q31/P36),1)","v":1},null,null,null,null,null,null,null,"El cálculo de la losa en situación persistente mejor hacerlo con tablas"]
["STEEL (PROFILE)",null,null,null,"Ac,net","[mm2]",{"$f":"IF(G33=aux!$AB$2,$O$36*$G$8-G37,0)","v":0},{"$f":"IF(H33=aux!$AB$2,$P$36*$G$8-H37,0)","v":112748.32255007171},{"$f":"IF(I33=aux!$AB$2,$P$36*$G$8-I37,0)","v":112748.32255007171},{"$f":"IF(J33=aux!$AB$2,$Q$36*$G$8-J37,0)","v":0},null,null,"βright","[-]",{"$f":"IF(N18=aux!F3,MIN(1,0.55+0.025*O31/P36),1)","v":0.65},1,{"$f":"IF(N19=aux!F3,MIN(1,0.55+0.025*Q31/P36),1)","v":1},null,null,null,null,null,null,null,"(la HANSA MT60 es muy completa), puesto que el comportamiento es"]
["fsk","[N/mm2]",275,null,"Ac,net,hom","[mm2]",{"$f":"G35/IF(G34=aux!$AA$2,$C$42,$C$43)","v":0},{"$f":"H35/IF(H34=aux!$AA$2,$C$42,$C$43)","v":16899.258814718149},{"$f":"I35/IF(I34=aux!$AA$2,$C$42,$C$43)","v":6440.7412854462145},{"$f":"J35/IF(J34=aux!$AA$2,$C$42,$C$43)","v":0},null,null,"beff","[mm]",{"$f":"G20+O34*O32+O35*O33","v":828.75},{"$f":"G20+P34*P32+P35*P33","v":1275},{"$f":"G20+Q34*Q32+Q35*Q33","v":525},null,null,null,null,null,null,null,"de conexión parcial con la chapa, no total. Además, estas tablas tienen en"]
["γs,profile","[-]",1.05,null,"As,reinf","[mm2]",{"$f":"PI()/4*($O$37*$G$11^2+$C$57*$D$57^2+IF(OR($K$2=aux!E2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2))","v":117.16177102481433},{"$f":"PI()/4*($P$37*$G$11^2+IF(OR($K$2=aux!E2,$G$13=0),0,$P$36/($G$14*$G$5)*$G$13^2))","v":180.24887849971438},{"$f":"PI()/4*($P$37*$G$11^2+IF(OR($K$2=aux!F2,$G$13=0),0,$P$36/($G$14*$G$5)*$G$13^2))","v":180.24887849971438},{"$f":"PI()/4*($Q$37*$G$11^2+$K$57*$L$57^2+IF(OR($K$2=aux!E2,$G$13=0),0,$Q$36/($G$14*$G$5)*$G$13^2))","v":526.60946855798909},null,null,"n. reinf. grill","[mm]",{"$f":"O36/$G$12","v":4.1437499999999998},{"$f":"P36/$G$12","v":6.375},{"$f":"Q36/$G$12","v":2.625},null,null,null,null,null,null,null,"cuenta el estado límite de cortante y rasante, la flecha según el apuntalamiento, etc."]
["fsd","[N/mm2]",{"$f":"C36/C37","v":261.90476190476187},null,"As,prof","[mm2]",{"$f":"$K$18","v":7808.64},{"$f":"$K$18","v":7808.64},{"$f":"$K$18","v":7808.64},{"$f":"$K$18","v":7808.64}]
["fsd,eff,A","[N/mm2]",{"$f":"$C$38*(1-W30)","v":261.90476190476187},null,"cdg","[mm]",{"$f":"(G36*$G$8/2+G37*$G$9+G38*($O$41+$K$13/2))/(G36+G37+G38)","v":217.04353516755526},{"$f":"(H36*$G$8/2+H37*$G$9+H38*($O$41+$K$13/2))/(H36+H37+H38)","v":99.240070234395176},{"$f":"(I36*$G$8/2+I37*$G$9+I38*($O$41+$K$13/2))/(I36+I37+I38)","v":139.0706887928101},{"$f":"(J36*$G$8/2+J37*$G$9+J38*($O$41+$K$13/2))/(J36+J37+J38)","v":207.36427816481194},null,null,"FIBRES",null,null,null,null,null,null,null,null,null,null,null,"FALTA"]
["fsd,eff,B","[N/mm2]",{"$f":"$C$38*(1-W31)","v":261.90476190476187},null,"d,c","[mm]",{"$f":"$G$8/2-G39","v":-172.75782088184098},{"$f":"$G$8/2-H39","v":-54.954355948680892},{"$f":"$G$8/2-I39","v":-94.784974507095825},{"$f":"$G$8/2-J39","v":-163.07856387909766},null,null,"top wave","[mm]",{"$f":"G2","v":60},null,null,null,null,null,null,null,null,null,"cálculo con tipo de sección distinto a 1 (no se permite solicitaciones plásticas)"]
["Es","[N/mm2]",210000,null,"d,reinf","[mm]",{"$f":"IF(AND($G$11=0,$G$13=0),0,(($O$37*$G$11^2+$C$57*$D$57^2)*$G$9+IF(OR($K$2=aux!E2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2*($O$41-$G$10)))/(($O$37*$G$11^2+$C$57*$D$57^2)+IF(OR($K$2=aux!E2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2))-G39)","v":-197.04353516755526},{"$f":"IF(AND($G$11=0,$G$13=0),0,(($O$37*$G$11^2+$C$57*$D$57^2)*$G$9+IF(OR($K$2=aux!F2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2*($O$41-$G$10)))/(($O$37*$G$11^2+$C$57*$D$57^2)+IF(OR($K$2=aux!F2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2))-H39)","v":-79.240070234395176},{"$f":"IF(AND($G$11=0,$G$13=0),0,(($O$37*$G$11^2+$C$57*$D$57^2)*$G$9+IF(OR($K$2=aux!G2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2*($O$41-$G$10)))/(($O$37*$G$11^2+$C$57*$D$57^2)+IF(OR($K$2=aux!G2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2))-I39)","v":-119.0706887928101},{"$f":"IF(AND($G$11=0,$G$13=0),0,(($O$37*$G$11^2+$C$57*$D$57^2)*$G$9+IF(OR($K$2=aux!H2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2*($O$41-$G$10)))/(($O$37*$G$11^2+$C$57*$D$57^2)+IF(OR($K$2=aux!H2,$G$13=0),0,$O$36/($G$14*$G$5)*$G$13^2))-J39)","v":-187.36427816481194},null,null,"bottom wave","[mm]",{"$f":"G6","v":120},null,null,null,null,null,null,null,null,null,"ver qué conflicto puede surgir entre grandes redistribuciones y flecha con solicitaciones elásticas"]
["n,28","[-]",{"$f":"C41/C12","v":6.6717909812633494},null,"d,prof","[mm]",{"$f":"($O$44-$K$13/2)-G39","v":2.9564648324447376},{"$f":"($O$44-$K$13/2)-H39","v":120.75992976560482},{"$f":"($O$44-$K$13/2)-I39","v":80.929311207189897},{"$f":"($O$44-$K$13/2)-J39","v":12.635721835188065},null,null,"bottom upper flange","[mm]",{"$f":"O41+K14","v":135},null,null,null,null,null,null,null,null,null,"calcular redistribución media de la solución elegida"]
["n,1000","[-]",{"$f":"C42*C30","v":17.505488507175848},null,"bc,net,hom,eq","[mm]",{"$f":"G36/$G$8","v":0},{"$f":"H36/$G$8","v":190.79808339197911},{"$f":"I36/$G$8","v":72.718046771166939},{"$f":"J36/$G$8","v":0},null,null,"bottom web","[mm]",{"$f":"O44-K14","v":305}]
["ε steel material","-",{"$f":"(235/C36)^0.5","v":0.92441627773717538},null,"Ic,net,hom,eq","[mm4]",{"$f":"G43*$G$8^3/12","v":0},{"$f":"H43*$G$8^3/12","v":11047746.748941591},{"$f":"I43*$G$8^3/12","v":4210579.8471522527},{"$f":"J43*$G$8^3/12","v":0},null,null,"bottom","[mm]",{"$f":"O41+K13","v":320}]
["STEEL (STUDS)",null,null,null,"Is,prof","[mm4]",{"$f":"$K$21","v":56961700},{"$f":"$K$21","v":56961700},{"$f":"$K$21","v":56961700},{"$f":"$K$21","v":56961700}]
["fu,studs","[N/mm2]",450,null,"I no connect","[mm4]",{"$f":"G45+G44","v":56961700},{"$f":"H45+H44","v":68009446.748941585},61172279.847152255,56961700]
["γv","[-]",1.25,null,"I,hom, full connect","[mm4]",{"$f":"G44+G36*G40^2+G37*G41^2+G45+G38*G42^2","v":61578893.909844212},{"$f":"H44+H36*H40^2+H37*H41^2+H45+H38*H42^2","v":234049761.72629243},{"$f":"I44+I36*I40^2+I37*I41^2+I45+I38*I42^2","v":172735774.78683037},{"$f":"J44+J36*J40^2+J37*J41^2+J45+J38*J42^2","v":76695260.590224579}]
[null,null,null,null,"ΔI full connection","[mm4]",{"$f":"G47-G46","v":4617193.9098442122},{"$f":"H47-H46","v":166040314.97735083},111563494.9396781,19733560.590224579]
[null,null,null,null,"I,hom","[mm4]",{"$f":"G46+A60*G48","v":61578893.909844212},{"$f":"H46+E60*H48","v":134425572.73988193},{"$f":"I46+E60*I48","v":105797677.8230235},{"$f":"J46+I60*J48","v":76695260.590224579}]
[null,null,null,null,"I,hom/Is,prof","[-]",{"$f":"G49/G45","v":1.0810578671255284},{"$f":"H49/H45","v":2.3599290881396082},{"$f":"I49/I45","v":1.8573476181894764},{"$f":"J49/J45","v":1.3464355977828011}]
[null,null,null,null,"EI","[Nmm2]",{"$f":"$C$41*G49","v":12931567721067.285},{"$f":"$C$41*H49","v":28229370275375.207},{"$f":"$C$41*I49","v":22217512342834.934},{"$f":"$C$41*J49","v":16106004723947.162}]
[null,null,null,null,"EI,eq","[Nmm2]",null,{"$f":"IF(N20=aux!$L$2,J51,IF(N20=aux!$L$3,H51,IF(N20=aux!$L$4,0.75*H51+0.25*J51,0.25*(G51+J51)+0.5*H51)))","v":25198528887518.195},{"$f":"IF(N20=aux!$L$2,J51,IF(N20=aux!$L$3,I51,IF(N20=aux!$L$4,0.75*I51+0.25*J51,0.25*(G51+J51)+0.5*I51)))","v":20689635438112.988}]
[null,null,null,null,"Stiffness improvement",null,null,{"$f":"H52/($C$41*$K$21)","v":2.1065557155504067},{"$f":"I52/($C$41*$K$21)","v":1.7296196130878072}]
[]
["ULS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIRE"]
[null,null,"n","φ",null,null,null,null,null,null,"n","φ",null,null,null,null,null,null,null,null,null,null,{"$f":"I1","v":"STEEL BEAM"}]
["α web class","A",null,null,"α web class","C",null,null,"α web class","B",4,12,null,null,null,null,null,null,null,null,null,null,"Am","[mm]",{"$f":"IF(K3=aux!K2,INDEX(IPE!AN3:AN21,MATCH(K4,IPE!A3:A21,0)),IF(K3=aux!K3,INDEX(HEB!AN3:AN21,MATCH(K4,HEB!A3:A21,0))))","v":951.09733552923251}]
[{"$f":"IF(AND(D58>$O$42,D58<$O$43,ABS(MIN(B64:B65))>MAX(B64:B65)),ABS(MIN(B64:B65))/(ABS(MIN(B64:B65))+MAX(B64:B65)),0)","v":0.55376907557647481},"y","[mm]",210.85925715199929,{"$f":"IF(AND(H58>$O$42,H58<$O$43,ABS(MIN(F64:F65))>MAX(F64:F65)),ABS(MIN(F64:F65))/(ABS(MIN(F64:F65))+MAX(F64:F65)),0)","v":0},"y","[mm]",132.33523636363637,{"$f":"IF(AND(L58>$O$42,L58<$O$43,ABS(MIN(J64:J65))>MAX(J64:J65)),ABS(MIN(J64:J65))/(ABS(MIN(J64:J65))+MAX(J64:J65)),0)","v":0.74167699127887865},"y","[mm]",178.91491148259064,null,null,null,null,null,null,null,null,null,null,"V","[mm2]",{"$f":"K18","v":7808.64}]
["η,A","N","z","M","η,C","N","z","M","η,B","N","z","M",null,null,null,null,null,null,null,null,null,null,"Am/V","[m]",{"$f":"1000*Y57/Y58","v":121.80063820706711}]
[1,"[kN]","[mm]","[kNm]",0.4,"[kN]","[mm]","[kNm]",1,"[kN]","[mm]","[kNm]",null,null,null,null,null,null,null,null,null,null,"γmed","-",{"$f":"IF(N20=aux!L2,(1-1/L72)*C33+1/L72*C37,IF(N20=aux!L3,(1-1/H72)*C9+1/H72*C37,IF(N20=aux!L4,AVERAGE((1-1/L72)*C33+1/L72*C37,(1-1/H72)*C9+1/H72*C37),AVERAGE((1-1/L72)*C33+1/L72*C37,(1-1/H72)*C9+1/H72*C37,(1-1/D72)*C33+1/D72*C37))))","v":1.1339020495270682}]
["upper slab",{"$f":"A60*PI()/4*($O$37*$G$11^2+C57*D57^2)*$C$34/1000","v":50.939900445571446},{"$f":"G9","v":20},{"$f":"B61*C61/1000","v":1.018798008911429},null,{"$f":"E60*-P36*C10/1000*(IF(H58<O40,H58,O40))","v":-510},{"$f":"IF(H58<O40,H58/2,O40/2)","v":30},{"$f":"F61*G61/1000","v":-15.3},null,{"$f":"I60*PI()/4*(Q37*G11^2+K57*L57^2)*C34/1000","v":228.96063850347352},{"$f":"G9","v":20},{"$f":"J61*K61/1000","v":4.5792127700694696},null,null,null,null,null,null,null,null,null,null,"μfi","-",{"$f":"S15/Y60*A77","v":0.3644483975629379}]
["ribs",{"$f":"A60*IF(OR($K$2=aux!$C$2,$G$13=0),0,PI()/4*$O$36/($G$14*$G$5)*$G$13^2*$C$34*IF(D58>($O$41-$G$10),1,-1))/1000","v":0},{"$f":"O41-G10","v":95},0,null,{"$f":"E60*-G7*P36*C10/1000*(IF(H58<O40,0,IF(H58<O41,H58-O40,O41-O40)))","v":-242.85714285714283},{"$f":"IF(H58<O41,O40+G7*0.5*(H58-O40),O40+G7*0.5*G3)","v":74.285714285714278},-18.04081632653061,null,{"$f":"I60*IF(OR($K$2=aux!$C$2,$G$13=0),0,PI()/4*$O$36/($G$14*$G$5)*$G$13^2*$C$34*IF(L58>($O$41-$G$10),1,-1))/1000","v":0},{"$f":"O41-G10","v":95},0,null,null,null,null,null,null,null,null,null,null,"d/λp (table)","[m2K/W]",0.1]
["top flange",{"$f":"$K$19*$C$38/1000*IF(D58<$O$41,-1,IF(D58>$O$42,1,2/$K$14*(D58-$O$41)-1))","v":785.71428571428555},{"$f":"O41+K14/2","v":127.5},100.1785714285714,null,{"$f":"$K$19*$C$38/1000*IF(H58<$O$41,1,IF(H58>$O$42,-1,-2/$K$14*(H58-$O$41)+1))","v":-506.54857142857185},{"$f":"O41+K14/2","v":127.5},-64.584942857142906,null,{"$f":"$K$19*$C$38/1000*IF(L58<$O$41,-1,IF(L58>$O$42,1,2/$K$14*(L58-$O$41)-1))","v":785.71428571428555},{"$f":"O41+K14/2","v":127.5},100.1785714285714,null,null,null,null,null,null,null,null,null,null,"R","min",90]
["top web | full web",{"$f":"IF(D58>$O$43,0,$K$20*$C$39/1000*IF(D58<$O$42,-1,IF(D58>$O$43,1,(D58-$O$42)/$K$17)))","v":211.37576406292885},{"$f":"IF(D58<O42,AVERAGE(O42:O43),O42+(D58-O42)/2)","v":172.92962857599963},36.553132369370417,null,{"$f":"IF(H58>$O$43,0,$K$20*$C$38/1000*IF(H58<$O$42,1,IF(H58>$O$43,-1,-(H58-$O$42)/$K$17)))","v":473.69142857142856},{"$f":"IF(H58<O42,AVERAGE(O42:O43),O42+(H58-O42)/2)","v":220},104.21211428571428,null,{"$f":"IF(L58>$O$43,0,$K$20*$C$40/1000*IF(L58<$O$42,-1,IF(L58>$O$43,1,(L58-$O$42)/$K$17)))","v":122.36539503397759},{"$f":"IF(L58<O42,AVERAGE(O42:O43),O42+(L58-O42)/2)","v":156.95745574129532},19.206161075311655,null,null,null,null,null,null,null,null,null,null,"λp","[w/mK]",1.2E-2]
["bottom web | full web",{"$f":"-$K$16*$C$39/1000*IF(D58<$O$42,0,IF(D58>$O$43,$K$17,$O$43-D58))","v":-262.31566450849976},{"$f":"IF(D58>O43,AVERAGE(O42:O43),D58+0.5*(O43-D58))","v":257.92962857599963},-67.658981916343862,null,{"$f":"$K$16*$C$38/1000*IF(H58<$O$42,0,IF(H58>$O$43,$K$17,$O$43-H58))","v":0},{"$f":"IF(H58>O43,AVERAGE(O42:O43),H58+0.5*(O43-H58))","v":218.66761818181817},0,null,{"$f":"-$K$16*$C$40/1000*IF(L58<$O$42,0,IF(L58>$O$43,$K$17,$O$43-L58))","v":-351.32603353745105},{"$f":"IF(L58>O43,AVERAGE(O42:O43),L58+0.5*(O43-L58))","v":241.95745574129532},-85.005953210402637,null,null,null,null,null,null,null,null,null,null,"d paint","[mm]",{"$f":"1000*Y62*Y64","v":1.2}]
["bottom flange",{"$f":"$K$19*$C$38/1000*IF(D58<$O$43,-1,IF(D58>$O$44,1,2/$K$14*(D58-$O$43)-1))","v":-785.71428571428555},{"$f":"O44-K14/2","v":312.5},-245.53571428571422,null,{"$f":"$K$19*$C$38/1000*IF(H58<$O$43,1,IF(H58>$O$44,-1,-2/$K$14*(H58-$O$43)+1))","v":785.71428571428555},{"$f":"O44-K14/2","v":312.5},245.53571428571422,null,{"$f":"$K$19*$C$38/1000*IF(L58<$O$43,-1,IF(L58>$O$44,1,2/$K$14*(L58-$O$43)-1))","v":-785.71428571428555},{"$f":"O44-K14/2","v":312.5},-245.53571428571422,null,null,null,null,null,null,null,null,null,null,null,"max",3]
["Nd,ELU [kN]",{"$f":"SUM(B61:B66)","v":0},"Mr-,ELU [kNm]",{"$f":"IF(N20=aux!$L$5,SUM(D61:D66),0)","v":0},"Nd,ELU [kN]",{"$f":"SUM(F61:F66)","v":0},"Mr+,ELU [kNm]",{"$f":"IF(N20=aux!L2,0,SUM(H61:H66))","v":251.82206938775499},"Nd,ELU [kN]",{"$f":"SUM(J61:J66)","v":0},"Mr-,ELU [kNm]",{"$f":"IF(N20=aux!$L$3,0,SUM(L61:L66))","v":-206.57772222216431},null,null,null,null,null,null,null,null,null,null,"SLAB"]
[null,null,"Mel,d,ELU [kNm]",{"$f":"-W5","v":0},null,null,"Mel,d,ELU [kNm]",{"$f":"W6","v":127.12479187500001},null,null,"Mel,d,ELU [kNm]",{"$f":"-W7","v":-254.24958375000003},null,null,null,null,null,null,null,null,null,null,"L","[m]",1.95]
[null,null,"Mel,ELS,pers [kNm]",{"$f":"-W25","v":0},null,null,"Mel,ELS,pers [kNm]",{"$f":"W26","v":90.097762500000016},null,null,"Mel,ELS,pers [kNm]",{"$f":"-W27","v":-180.19552500000003},null,null,null,null,null,null,null,null,null,null,"constraint left",null,"fix"]
[null,null,"elast. capac. ULS",{"$f":"IF(D68=0,1,D67/D68)","v":1},null,null,"elast. capac. ULS",{"$f":"IF(H68=0,1,H67/H68)","v":1.9809044771956679},null,null,"elast. capac. ULS",{"$f":"IF(L68=0,1,L67/L68)","v":0.81249974601842112},null,null,null,null,null,null,null,null,null,null,"constraint right",null,"fix"]
[null,null,"elast. capac. SLS",{"$f":"IF(D69=0,1,D67/D69)","v":1},null,null,"elast. capac. SLS",{"$f":"IF(H69=0,1,H67/H69)","v":2.7949869386351849},null,null,"elast. capac. SLS",{"$f":"IF(L69=0,1,L67/L69)","v":1.1464087258668842},null,null,null,null,null,null,null,null,null,null,"global constraint",null,{"$f":"CONCATENATE(Y69,\"-\",Y70)","v":"fix-fix"}]
["qR [kN/m]",null,"Mr/Mar",{"$f":"ABS(D67/$K$24)","v":0},null,null,"Mr/Mar",{"$f":"ABS(H67/$K$24)","v":1.4963578904733199},null,null,"Mr/Mar",{"$f":"ABS(L67/$K$24)","v":1.227510382210258},null,null,null,null,null,null,null,null,null,null,"U-","[kN/m]",{"$f":"(1000/G12)*PI()/4*G11^2*C32/1000","v":70.685834705770347}]
[{"$f":"2/O2^2*(-D67-L67+2*H67+2*ABS((D67*L67-D67*H67-L67*H67+H67^2)^0.5))","v":77.207607529601006},null,"Mpl type",{"$f":"IF(viga!$A$79=aux!$AG$2,aux!AH2,IF(viga!$A$79=aux!$AG$3,aux!AH3,IF(viga!$A$79=aux!$AG$4,aux!AH4,IF(viga!$A$79=aux!$AG$5,aux!AH5,IF(viga!$A$79=aux!$AG$6,aux!AH6,IF(viga!$A$79=aux!$AG$7,aux!AH7,IF(viga!$A$79=aux!$AG$8,aux!AH8,IF(viga!$A$79=aux!$AG$9,aux!AH9,IF(viga!$A$79=aux!$AG$10,aux!AH10,IF(viga!$A$79=aux!$AG$11,aux!AH11,IF(viga!$A$79=aux!$AG$12,aux!AH12,IF(viga!$A$79=aux!$AG$13,aux!AH13,IF(viga!$A$79=aux!$AG$14,aux!AH14,IF(viga!$A$79=aux!$AG$18,aux!AH18,IF(viga!$A$79=aux!$AG$15,aux!AH15,IF(viga!$A$79=aux!$AG$16,aux!AH16,IF(viga!$A$79=aux!$AG$20,aux!AH20,IF(viga!$A$79=aux!$AG$17,aux!AH17,IF(viga!$A$79=aux!$AG$19,aux!AH19,aux!AH21)))))))))))))))))))","v":"el"},null,null,"Mpl type",{"$f":"IF(viga!$A$79=aux!$AG$2,aux!AI2,IF(viga!$A$79=aux!$AG$3,aux!AI3,IF(viga!$A$79=aux!$AG$4,aux!AI4,IF(viga!$A$79=aux!$AG$5,aux!AI5,IF(viga!$A$79=aux!$AG$6,aux!AI6,IF(viga!$A$79=aux!$AG$7,aux!AI7,IF(viga!$A$79=aux!$AG$8,aux!AI8,IF(viga!$A$79=aux!$AG$9,aux!AI9,IF(viga!$A$79=aux!$AG$10,aux!AI10,IF(viga!$A$79=aux!$AG$11,aux!AI11,IF(viga!$A$79=aux!$AG$12,aux!AI12,IF(viga!$A$79=aux!$AG$13,aux!AI13,IF(viga!$A$79=aux!$AG$14,aux!AI14,IF(viga!$A$79=aux!$AG$18,aux!AI18,IF(viga!$A$79=aux!$AG$15,aux!AI15,IF(viga!$A$79=aux!$AG$16,aux!AI16,IF(viga!$A$79=aux!$AG$20,aux!AI20,IF(viga!$A$79=aux!$AG$17,aux!AI17,IF(viga!$A$79=aux!$AG$19,aux!AI19,aux!AI21)))))))))))))))))))","v":"cal"},null,null,"Mpl type",{"$f":"IF(viga!$A$79=aux!$AG$2,aux!AJ2,IF(viga!$A$79=aux!$AG$3,aux!AJ3,IF(viga!$A$79=aux!$AG$4,aux!AJ4,IF(viga!$A$79=aux!$AG$5,aux!AJ5,IF(viga!$A$79=aux!$AG$6,aux!AJ6,IF(viga!$A$79=aux!$AG$7,aux!AJ7,IF(viga!$A$79=aux!$AG$8,aux!AJ8,IF(viga!$A$79=aux!$AG$9,aux!AJ9,IF(viga!$A$79=aux!$AG$10,aux!AJ10,IF(viga!$A$79=aux!$AG$11,aux!AJ11,IF(viga!$A$79=aux!$AG$12,aux!AJ12,IF(viga!$A$79=aux!$AG$13,aux!AJ13,IF(viga!$A$79=aux!$AG$14,aux!AJ14,IF(viga!$A$79=aux!$AG$18,aux!AJ18,IF(viga!$A$79=aux!$AG$15,aux!AJ15,IF(viga!$A$79=aux!$AG$16,aux!AJ16,IF(viga!$A$79=aux!$AG$20,aux!AJ20,IF(viga!$A$79=aux!$AG$17,aux!AJ17,IF(viga!$A$79=aux!$AG$19,aux!AJ19,aux!AJ21)))))))))))))))))))","v":"R"},null,null,null,null,null,null,null,null,null,null,"U+","[kN/m]",{"$f":"IF(G13=0,Y72,(1000/(G5*G14))*PI()/4*G13^2*C32/1000)","v":70.685834705770347}]
["overstrength",null,"Mpl,d,ELU [kNm]",{"$f":"IF(D73=aux!$AF$2,D68,IF(D73=aux!$AF$3,D67,IF(D73=aux!$AF$4,(2*L74-$S$20*$O$2^2)/2+(2*$S$20*$O$2^2*(H74-L74))^0.5,D68-($H$68-$H$67))))","v":0},null,null,"Mpl,d,ELU [kNm]",{"$f":"IF(H73=aux!$AF$2,H68,IF(H73=aux!$AF$3,H67,IF(H73=aux!$AF$4,(D74+L74)/2+(D74-L74)^2/(2*$S$20*$O$2^2)+$S$20*$O$2^2/8)))","v":161.45099431632866},null,null,"Mpl,d,ELU [kNm]",{"$f":"IF(L73=aux!$AF$2,L68,IF(L73=aux!$AF$3,L67,IF(L73=aux!$AF$4,(2*D74-$S$20*$O$2^2)/2+(2*$S$20*$O$2^2*(H74-D74))^0.5,L68-($H$68-$H$67))))","v":-206.57772222216431},null,null,null,null,null,null,null,null,null,null,"d-","[mm]",{"$f":"G6-G9","v":100}]
[{"$f":"A73/S20","v":1.3665085651618278},null,"Mpl/Mr",{"$f":"IF(N20=aux!$L$5,D74/D67,\"\")","v":""},null,null,"Mpl/Mr",{"$f":"IF(N20=aux!L2,\"\",H74/H67)","v":0.64113123487888912},null,null,"Mpl/Mr",{"$f":"IF(N20=aux!$L$3,\"\",L74/L67)","v":1},null,null,null,null,null,null,null,null,null,null,"d+","[mm]",{"$f":"IF(G13=0,G9,G6-G10)","v":20}]
["μ",null,"Fc,max [kN]",{"$f":"IF(N20=aux!$L$5,B61+B62,\"\")","v":""},null,null,"Fc,max [kN]",{"$f":"IF(N20=aux!L2,\"\",F61+F62)","v":-752.85714285714289},null,null,"Fc,max [kN]",{"$f":"IF(N20=aux!$L$3,\"\",J61+J62)","v":228.96063850347352},null,null,null,null,null,null,null,null,null,null,"b-","[mm]",{"$f":"1000*G7","v":476.19047619047615}]
[{"$f":"1/A75","v":0.73179197371629767},null,"Fc,real [kN]",{"$f":"IF(N20=aux!$L$5,D76*D75,\"\")","v":""},null,null,"Fc,real [kN]",{"$f":"IF(N20=aux!L2,\"\",H76*H75)","v":-482.68022968739228},null,null,"Fc,real [kN]",{"$f":"IF(N20=aux!$L$3,\"\",L76*L75)","v":228.96063850347352},null,null,null,null,null,null,null,null,null,null,"b+","[mm]",1000]
["type redistribution",null,"V studs [kN]",{"$f":"D77","v":""},null,null,"V studs [kN]",{"$f":"IF(N20=aux!L2,\"\",-2*H77)","v":965.36045937478457},null,null,"V studs [kN]",{"$f":"IF(N20=aux!$L$3,\"\",L77)","v":228.96063850347352},null,null,null,null,null,null,null,null,null,null,"z-","[mm]",{"$f":"Y74-Y72*1000/(2*Y76*$C$3)","v":97.031194942357644}]
[{"$f":"IF(AND(D70>=1,H70>=1,L70>=1),aux!AG2,IF(A75<1,aux!AG3,IF(AND(D70<1,L70>=1,H70>=1,L70<=H70,ABS(D68-D67)<2*(H67-H68)),aux!AG4,IF(AND(D70<1,L70>=1,H70>=1,L70<=H70,ABS(D68-D67)>=2*(H67-H68)),aux!AG5,IF(AND(L70<1,D70>=1,H70>=1,D70<=H70,ABS(L68-L67)<2*(H67-H68)),aux!AG6,IF(AND(L70<1,D70>=1,H70>=1,D70<=H70,ABS(L68-L67)>=2*(H67-H68)),aux!AG7,IF(AND(D70<1,L70<1,H70>=1,D70<=L70),aux!AG8,IF(AND(L70<1,D70<1,H70>=1,L70<=D70),aux!AG9,IF(AND(D70<1,H70>=1,L70>=1,H70<=L70,ABS(D68-D67)<2*(H67-H68)),aux!AG10,IF(AND(D70<1,H70>=1,L70>=1,H70<=L70,ABS(D68-D67)>=2*(H67-H68)),aux!AG11,IF(AND(L70<1,H70>=1,D70>=1,H70<=D70,ABS(L68-L67)<2*(H67-H68)),aux!AG12,IF(AND(L70<1,H70>=1,D70>=1,H70<=D70,ABS(L68-L67)>=2*(H67-H68)),aux!AG13,IF(AND(D70<1,H70<1,L70>=1,D70<=H70),aux!AG14,IF(AND(H70<1,D70>=1,L70>=1,D70<=L70,ABS(D67-D68)<H68-H67),aux!AG18,IF(AND(H70<1,D70<1,L70>=1,H70<=D70),aux!AG15,IF(AND(L70<1,H70<1,D70>=1,L70<=H70),aux!AG16,IF(AND(H70<1,L70>=1,D70>=1,L70<D70,ABS(L67-L68)<H68-H67),aux!AG20,IF(AND(H70<1,L70<1,D70>=1,H70<=L70),aux!AG17,IF(AND(H70<1,D70>=1,L70>=1,D70<=L70,ABS(D67-D68)>=H68-H67),aux!AG19,IF(AND(H70<1,L70>=1,D70>=1,L70<D70,ABS(L67-L68)>=H68-H67),aux!AG21))))))))))))))))))))","v":"b AC1"},null,"n studs [-]",{"$f":"IF(N20=aux!$L$5,D78/($G$29*$G$19),\"\")","v":""},null,null,"n studs [-]",{"$f":"IF(N20=aux!L2,\"\",H78/($G$29*$G$19))","v":36.646551756184813},null,null,"n studs [-]",{"$f":"IF(N20=aux!$L$3,\"\",L78/($G$29*$G$19))","v":8.691694182793487},null,null,null,null,null,null,null,null,null,null,"z+","[mm]",{"$f":"Y75-Y73*1000/(2*Y77*$C$3)","v":18.586283305884592}]
["mean redistribution",null,"Length [m]",{"$f":"IF(N20=aux!$L$5,MIN(-1/$S$20*((-$S$20*$O$2/2+($D$74-$L$74)/$O$2)+(($S$20*$O$2/2-($D$74-$L$74)/$O$2)^2+2*$S$20*$D$74)^0.5),-1/$S$20*((-$S$20*$O$2/2+($D$74-$L$74)/$O$2)-(($S$20*$O$2/2-($D$74-$L$74)/$O$2)^2+2*$S$20*$D$74)^0.5)),\"\")","v":""},null,null,"Length [m]",{"$f":"IF(N20=aux!L2,\"\",O2-IF(D80=\"\",0,D80)-IF(L80=\"\",0,L80))","v":4.7812503809723692},null,null,"Length [m]",{"$f":"IF(N20=aux!$L$3,\"\",$O$2-MAX(-1/$S$20*((-$S$20*$O$2/2+($D$74-$L$74)/$O$2)+(($S$20*$O$2/2-($D$74-$L$74)/$O$2)^2+2*$S$20*$D$74)^0.5),-1/$S$20*((-$S$20*$O$2/2+($D$74-$L$74)/$O$2)-(($S$20*$O$2/2-($D$74-$L$74)/$O$2)^2+2*$S$20*$D$74)^0.5)))","v":1.2187496190276308},null,null,null,null,null,null,null,null,null,null,"Mr-","[kNm/m]",{"$f":"Y72*Y78/1000","v":6.8587310069988714}]
[{"$f":"IF(N20=aux!L4,1-L74/L68,IF(N20=aux!L5,1-AVERAGE(L89,D74)/L68,0))","v":0.18750025398157888},null,"s studs [mm]",{"$f":"IF(N20=aux!$L$5,D80*1000/D79,\"\")","v":""},null,null,"s studs [mm]",{"$f":"IF(N20=aux!L2,\"\",H80*1000/H79)","v":130.46931162262604},null,null,"s studs [mm]",{"$f":"IF(N20=aux!$L$3,\"\",L80*1000/L79)","v":140.220029996031},null,null,null,null,null,null,null,null,null,null,"Mr+","[kNm/m]",{"$f":"Y73*Y79/1000","v":1.313786949554377}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miso,R","[kNm/m]",{"$f":"IF(Y71=aux!L3,Y81,IF(Y71=aux!L4,Y80/2+Y81,IF(Y71=aux!L5,Y80+Y81)))","v":8.1725179565532482}]
["SLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miso,d","[kNm/m]",{"$f":"S17*Y68^2/8","v":2.7954464256912441}]
["scaffolding","[Y/N]","N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"use (μ)","-",{"$f":"Y83/Y82","v":0.34205448560069251}]
["factor δ elastic","-",{"$f":"IF(N20=aux!L2,aux!U2,IF(N20=aux!L3,aux!U3,IF(N20=aux!L4,aux!U4,IF(N20=aux!L5,aux!U5))))","v":5.4054054054054057E-3}]
["factor δ redist","-",{"$f":"IF(MIN(D71,H71,L71)<1,IF(N20=aux!L4,IF(L71<H71,aux!U4*L71+aux!U3*(1-L71),aux!U4*H71+aux!U6*(1-H71)),IF(AVERAGE(L71,D71)<H71,aux!U5*AVERAGE(L71,D71)+aux!U3*(1-AVERAGE(L71,D71)),aux!U5*H71+aux!U7*(1-H71))),C85)","v":5.4054054054054057E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hacer fuego para cualquier perfil"]
["δslab,short","[mm]",{"$f":"IF(AND(OR(N20=aux!L2,N20=aux!L3),C86<C85),\"\",IF(C84=aux!A1,0,C85*S22*(O2*1000)^4/(C41*K21)))","v":7.5655663583692423}]
["δG,short","[mm]",{"$f":"IF(C87=\"\",\"\",C85*(O2*1000)^4*S23/H52)","v":3.0163923055960096}]
["δpers,long","[mm]",{"$f":"IF(C87=\"\",\"\",C86*(O2*1000)^4*S25/I52)","v":13.558508651357185}]
["δcuasi,long","[mm]",{"$f":"IF(C87=\"\",\"\",C86*(O2*1000)^4*S26/I52)","v":9.7010660531148574},"L/δ","limit","overdesign"]
["δact","[mm]",{"$f":"IF(C87=\"\",\"\",C89-C88)","v":10.542116345761176},{"$f":"IF(C87=\"\",\"\",IF(C91=0,\"\",$O$2*1000/C91))","v":569.14568225311882},{"$f":"IF(S7=aux!D2,aux!E2,IF(S7=aux!D3,aux!E3,IF(S7=aux!D4,aux!E4)))*(IF(N20=aux!L2,0.5,1))","v":400},{"$f":"IF(C87=\"\",\"Instable\",IF(D91=\"\",\"\",D91/E91))","v":1.4228642056327971}]
["δinst","[mm]",{"$f":"IF(C87=\"\",\"\",C85*(O2*1000)^4*S24/H52)","v":4.5245884583940139},{"$f":"IF(C87=\"\",\"\",IF(C92=0,\"\",$O$2*1000/C92))","v":1326.0874563892773},{"$f":"350*(IF(N20=aux!L2,0.5,1))","v":350},{"$f":"IF(D92=\"\",\"Instable\",D92/E92)","v":3.7888213039693639}]
["δtot","[mm]",{"$f":"IF(C87=\"\",\"\",C90+C87)","v":17.2666324114841},{"$f":"IF(C87=\"\",\"\",IF(C93=0,\"\",$O$2*1000/C93))","v":347.49103687464719},{"$f":"300*(IF(N20=aux!L2,0.5,1))","v":300},{"$f":"IF(D93=\"\",\"Instable\",D93/E93)","v":1.1583034562488239}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["factor beff",0.05]
["factor cross section",0.25]
["BENDING MOMENT GRAPHIC"]
["x/L","x","beff","beff graph-","beff graph+","Mr-","Mr+","Mel,d,ELU","Mpl,d,ELU","Mr,ELU","Mel,ELS,pers"]
["-","[m]","[mm]","-","-","[kNm]","[kNm]","[kNm]","[kNm]","[kNm]","[kNm]"]
[0,{"$f":"A110*$O$2","v":0},{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A110<0.25,$O$36+A110/0.25*($P$36-$O$36),IF(A110<0.75,$P$36,$Q$36+(1-A110)/0.25*($P$36-$Q$36))))","v":828.75},{"$f":"-E110","v":-41.4375},{"$f":"C110*$B$105","v":41.4375},{"$f":"$D$67+A110*($L$67-$D$67)","v":0},{"$f":"$H$67","v":251.82206938775499},{"$f":"$D$68+($S$20*$O$2/2-($D$68-$L$68)/$O$2)*B110-$S$20*B110^2/2","v":0},{"$f":"$D$74+($S$20*$O$2/2-($D$74-$L$74)/$O$2)*B110-$S$20*B110^2/2","v":0},{"$f":"$D$67+($A$73*$O$2/2-($D$67-$L$67)/$O$2)*B110-$A$73/2*B110^2","v":0},{"$f":"$D$69+($S$25*$O$2/2-($D$69-$L$69)/$O$2)*B110-$S$25*B110^2/2","v":0}]
[0.05,0.30000000000000004,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A111<0.25,$O$36+A111/0.25*($P$36-$O$36),IF(A111<0.75,$P$36,$Q$36+(1-A111)/0.25*($P$36-$Q$36))))","v":918},{"$f":"-E111","v":-45.900000000000006},45.900000000000006,{"$f":"$D$67+A111*($L$67-$D$67)","v":-10.328886111108217},251.82206938775499,35.594941725000012,37.978534801391802,55.683618326700653,25.227373500000006]
[0.1,0.60000000000000009,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A112<0.25,$O$36+A112/0.25*($P$36-$O$36),IF(A112<0.75,$P$36,$Q$36+(1-A112)/0.25*($P$36-$Q$36))))","v":1007.25},-50.362500000000004,50.362500000000004,-20.657772222216433,251.82206938775499,66.104891775000013,70.872077927783593,104.41855197573722,46.850836500000014]
[0.15,0.89999999999999991,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A113<0.25,$O$36+A113/0.25*($P$36-$O$36),IF(A113<0.75,$P$36,$Q$36+(1-A113)/0.25*($P$36-$Q$36))))","v":1096.5},-54.825000000000003,54.825000000000003,-30.986658333324645,251.82206938775499,91.529850150000016,98.680629379175372,146.20480094710967,64.870389000000003]
[0.2,1.2000000000000002,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A114<0.25,$O$36+A114/0.25*($P$36-$O$36),IF(A114<0.75,$P$36,$Q$36+(1-A114)/0.25*($P$36-$Q$36))))","v":1185.75},-59.287500000000001,59.287500000000001,-41.315544444432867,251.82206938775499,111.86981685000003,121.4041891555672,181.04236524081807,79.286031000000023]
[0.25,1.5,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A115<0.25,$O$36+A115/0.25*($P$36-$O$36),IF(A115<0.75,$P$36,$Q$36+(1-A115)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-51.644430555541078,251.82206938775499,127.124791875,139.04275725695896,208.93124485686229,90.097762500000002]
[0.3,1.7999999999999998,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A116<0.25,$O$36+A116/0.25*($P$36-$O$36),IF(A116<0.75,$P$36,$Q$36+(1-A116)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-61.973316666649289,251.82206938775499,137.29477522500002,151.59633368335074,229.87143979524251,97.305583499999997]
[0.35,2.0999999999999996,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A117<0.25,$O$36+A117/0.25*($P$36-$O$36),IF(A117<0.75,$P$36,$Q$36+(1-A117)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-72.3022027777575,251.82206938775499,142.37976689999999,159.06491843474254,243.86295005595861,100.90949400000001]
[0.4,2.4000000000000004,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A118<0.25,$O$36+A118/0.25*($P$36-$O$36),IF(A118<0.75,$P$36,$Q$36+(1-A118)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-82.631088888865733,251.82206938775499,142.37976690000002,161.44851151113434,250.90577563901064,100.90949400000001]
[0.45,2.7,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A119<0.25,$O$36+A119/0.25*($P$36-$O$36),IF(A119<0.75,$P$36,$Q$36+(1-A119)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-92.959974999973937,251.82206938775499,137.29477522500005,158.74711291252615,250.9999165443985,97.305583500000012]
[0.5,3,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A120<0.25,$O$36+A120/0.25*($P$36-$O$36),IF(A120<0.75,$P$36,$Q$36+(1-A120)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-103.28886111108216,251.82206938775499,127.124791875,150.96072263891793,244.14537277212236,90.097762499999988]
[0.55000000000000004,3.3000000000000003,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A121<0.25,$O$36+A121/0.25*($P$36-$O$36),IF(A121<0.75,$P$36,$Q$36+(1-A121)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-113.61774722219037,251.82206938775499,111.86981685000001,138.08934069030965,230.34214432218204,79.28603099999998]
[0.6,3.5999999999999996,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A122<0.25,$O$36+A122/0.25*($P$36-$O$36),IF(A122<0.75,$P$36,$Q$36+(1-A122)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-123.94663333329858,251.82206938775499,91.529850150000073,120.1329670667015,209.59023119457783,64.870388999999989]
[0.65,3.9000000000000004,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A123<0.25,$O$36+A123/0.25*($P$36-$O$36),IF(A123<0.75,$P$36,$Q$36+(1-A123)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-134.2755194444068,251.82206938775499,66.104891774999942,97.091601768093199,181.88963338930932,46.850836500000014]
[0.7,4.1999999999999993,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A124<0.25,$O$36+A124/0.25*($P$36-$O$36),IF(A124<0.75,$P$36,$Q$36+(1-A124)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-144.604405555515,251.82206938775499,35.594941725000069,68.965244794485159,147.24035090637688,25.227373500000056]
[0.75,4.5,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A125<0.25,$O$36+A125/0.25*($P$36-$O$36),IF(A125<0.75,$P$36,$Q$36+(1-A125)/0.25*($P$36-$Q$36))))","v":1275},-63.75,63.75,-154.93329166662323,251.82206938775499,0,35.753896145876865,105.64238374578019,0]
[0.8,4.8000000000000007,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A126<0.25,$O$36+A126/0.25*($P$36-$O$36),IF(A126<0.75,$P$36,$Q$36+(1-A126)/0.25*($P$36-$Q$36))))","v":1125},-56.25,56.25,-165.26217777773147,251.82206938775499,-40.679933400000095,-2.5424441777314541,57.095731907519394,-28.831284000000096]
[0.85,5.0999999999999996,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A127<0.25,$O$36+A127/0.25*($P$36-$O$36),IF(A127<0.75,$P$36,$Q$36+(1-A127)/0.25*($P$36-$Q$36))))","v":975},-48.75,48.75,-175.59106388883967,251.82206938775499,-86.444858475000046,-45.923776176339629,1.6003953915947022,-61.266478499999948]
[0.9,5.4,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A128<0.25,$O$36+A128/0.25*($P$36-$O$36),IF(A128<0.75,$P$36,$Q$36+(1-A128)/0.25*($P$36-$Q$36))))","v":825},-41.25,41.25,-185.91994999994787,251.82206938775499,-137.29477522499997,-94.390099849947774,-60.843625801994449,-97.305583500000068]
[0.95,5.6999999999999993,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A129<0.25,$O$36+A129/0.25*($P$36-$O$36),IF(A129<0.75,$P$36,$Q$36+(1-A129)/0.25*($P$36-$Q$36))))","v":675.00000000000011},-33.750000000000007,33.750000000000007,-196.24883611105608,251.82206938775499,-193.22968364999997,-147.941415198556,-130.23633167324715,-136.94859899999994]
[1,6,{"$f":"IF($N$20=aux!$L$2,$Q$36,IF(A130<0.25,$O$36+A130/0.25*($P$36-$O$36),IF(A130<0.75,$P$36,$Q$36+(1-A130)/0.25*($P$36-$Q$36))))","v":525},-26.25,26.25,-206.57772222216431,251.82206938775499,-254.24958375000006,-206.5777222221642,-206.57772222216431,-180.19552500000009]
[]
[]
["CROSS SECTION GRAPHIC","A","C","B"]
["top",{"$f":"-$B$106*$D$58","v":-52.714814287999822},{"$f":"-$B$106*$H$58","v":-33.083809090909092},{"$f":"-$B$106*$L$58","v":-44.72872787064766}]
["top wave",{"$f":"$B$134+$B$106*O40","v":-37.714814287999822},{"$f":"$C$134+$B$106*O40","v":-18.083809090909092},{"$f":"$D$134+$B$106*O40","v":-29.72872787064766}]
["bottom wave",{"$f":"$B$134+$B$106*O41","v":-22.714814287999822},{"$f":"$C$134+$B$106*O41","v":-3.0838090909090923},{"$f":"$D$134+$B$106*O41","v":-14.72872787064766}]
["bottom flange",{"$f":"$B$134+$B$106*O42","v":-18.964814287999822},{"$f":"$C$134+$B$106*O42","v":0.66619090909090772},{"$f":"$D$134+$B$106*O42","v":-10.97872787064766}]
["bottom web",{"$f":"$B$134+$B$106*O43","v":23.535185712000178},{"$f":"$C$134+$B$106*O43","v":43.166190909090908},{"$f":"$D$134+$B$106*O43","v":31.52127212935234}]
["bottom",{"$f":"$B$134+$B$106*O44","v":27.285185712000178},{"$f":"$C$134+$B$106*O44","v":46.916190909090908},{"$f":"$D$134+$B$106*O44","v":35.27127212935234}]

{"sheet":"aux","index":1,"n_rows":21,"n_cols":36,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Y","fsk","family","walls","L/δ max","constraint","Q cathegory","Ψ1","Ψ2","φ","profile type","global constraint","factor L A","factor L C","factor L B","factor V A","factor V B","factor M A","factor M C","factor M B","facfor δ","cement","s","exposition to RH","factor panza","class","time term","bending sign","Creep code","type redistibution",null,"M type","type redistribution","MA","MC","MB"]
["N",235,"secondary","brittle",500,"fix","snow low",0.2,0,5,"IPE","free-fix",2,2,2,0,1,0,0,0.5,{"$f":"1/8","v":0.125},"fast",0.2,"top and bottom",{"$f":"128/144","v":0.88888888888888884},1,"short","+","EC4","AB",null,"el","overdesign all",{"$f":"AF2","v":"el"},{"$f":"AF2","v":"el"},{"$f":"AF2","v":"el"}]
[null,275,"primary","average",400,"pin","use A-B, snow high",0.5,0.3,6,"HEB","pin-pin",0.85,1,0.85,0.5,0.5,0,{"$f":"1/8","v":0.125},0,{"$f":"5/384","v":1.3020833333333334E-2},"normal",0.25,"top",null,"≥2","long","-","EHE-08","AC",null,"R","fail",{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"},{"$f":"AF3","v":"R"}]
[null,335,null,"no",300,"free","use C-D-E",0.7,0.6,8,null,"pin-fix",0.85,0.85,0.5,{"$f":"3/8","v":0.375},{"$f":"5/8","v":0.625},0,{"$f":"1/16","v":6.25E-2},{"$f":"1/8","v":0.125},{"$f":"1/185","v":5.4054054054054057E-3},"slow",0.38,"bottom",null,null,"any",null,"average","BC",null,"cal","a BC1",{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"},{"$f":"AF2","v":"el"}]
[null,null,null,null,null,null,"use G",0,0,10,null,"fix-fix",0.5,0.7,0.5,0.5,0.5,{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"1/24","v":4.1666666666666664E-2},{"$f":"1/12","v":8.3333333333333329E-2},{"$f":"1/384","v":2.6041666666666665E-3},null,null,"none",null,null,null,null,null,null,null,"esp","a BC2",{"$f":"AF3","v":"R"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,"pin-plasticHinge-fix",null,{"$f":"1/128+1/96","v":1.8229166666666664E-2},null,null,null,null,null,null,null,null,null,null,null,"b AC1",{"$f":"AJ4","v":"el"},{"$f":"AI4","v":"cal"},{"$f":"AH4","v":"R"}]
[null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,"fix-plastic-Hinge-fix",null,{"$f":"1/128","v":7.8125E-3},null,null,null,null,null,null,null,null,null,null,null,"b AC2",{"$f":"AJ5","v":"cal"},{"$f":"AI5","v":"R"},{"$f":"AH5","v":"R"}]
[null,null,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ab C",{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"},{"$f":"AF3","v":"R"}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ba C",{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"},{"$f":"AF3","v":"R"}]
[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,"a CB1",{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"},{"$f":"AF2","v":"el"}]
[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,"a CB2",{"$f":"AF3","v":"R"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[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,"b CA1",{"$f":"AJ10","v":"el"},{"$f":"AI10","v":"cal"},{"$f":"AH10","v":"R"}]
[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,"b CA2",{"$f":"AJ11","v":"cal"},{"$f":"AI11","v":"R"},{"$f":"AH11","v":"R"}]
[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,"ac B",{"$f":"AF3","v":"R"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[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,"ca B",{"$f":"AF3","v":"R"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[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,"bc A",{"$f":"AJ14","v":"cal"},{"$f":"AI14","v":"R"},{"$f":"AH14","v":"R"}]
[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,"cb A",{"$f":"AJ15","v":"cal"},{"$f":"AI15","v":"R"},{"$f":"AH15","v":"R"}]
[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,"c AB1",{"$f":"AF3","v":"R"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[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,"c AB2",{"$f":"AF5","v":"esp"},{"$f":"AF3","v":"R"},{"$f":"AF4","v":"cal"}]
[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,"c BA1",{"$f":"AJ18","v":"cal"},{"$f":"AI18","v":"R"},{"$f":"AH18","v":"R"}]
[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,"c BA2",{"$f":"AJ19","v":"cal"},{"$f":"AI19","v":"R"},{"$f":"AH19","v":"esp"}]

{"sheet":"IPE","index":2,"n_rows":20,"n_cols":40,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["series","weight","h","b","tw","tf","r","A","I strong","Wel strong","Wpl strong","i strong","Av strong","I weak","Wel weak","Wpl weak","i weak","ss","It","Iw","class, compression",null,null,"class, bending",null,null,"Npl,Rd",null,null,"Mpl,Rd strong",null,null,"Mpl,Rd weak",null,null,"Vpl,Rd strong",null,null,null,"perimeter non protected"]
["-","[kp/m]","[mm]","[mm]","[mm]","[mm]","[mm]","[mm2]","[cm4]","[cm3]","[cm3]","[mm]","[mm2]","[cm4]","[cm3]","[cm3]","[mm]","[mm]","[cm4]","[]","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335",null,"[mm]"]
[80,6,80,46,3.8,5.2,5,764.38,80.14,20.03,23.22,32.380000000000003,357.74,8.49,3.69,5.82,10.54,20.059999999999999,0.7,0.12,1,1,1,1,1,1,171.1,200.2,258.39999999999998,5.2,6.08,7.85,1.3,1.52,1.97,46.23,54.09,69.83,null,{"$f":"3*D3-2*E3+2*C3+(2*PI()-8)*G3","v":281.81592653589792}]
[100,8.1,100,55,4.0999999999999996,5.7,7,1032.4000000000001,171.01,34.200000000000003,39.409999999999997,40.700000000000003,508.57,15.92,5.79,9.15,12.42,23.7,1.2,0.35,1,1,1,1,1,1,231.1,270.39999999999998,349,8.82,10.32,13.32,2.0499999999999998,2.4,3.09,65.72,76.900000000000006,99.27,null,344.78229715025714]
[120,10.37,120,64,4.4000000000000004,6.3,7,1321.1,317.75,52.96,60.73,49.04,630.62,27.67,8.65,13.58,14.47,25.2,1.74,0.89,1,1,1,1,1,1,295.7,346,446.7,13.59,15.9,20.53,3.04,3.56,4.59,81.489999999999995,95.36,123.1,null,411.18229715025711]
[140,12.9,140,73,4.7,6.9,7,1642.68,541.22,77.319999999999993,88.34,57.4,764.31,44.92,12.31,19.25,16.54,26.7,2.4500000000000002,1.98,1,1,2,1,1,1,367.6,430.2,555.4,19.77,23.14,29.87,4.3099999999999996,5.04,6.51,98.76,115.6,149.19999999999999,null,477.58229715025715]
[160,15.77,160,82,5,7.4,9,2009.26,869.29,108.66,123.86,65.78,965.86,68.31,16.66,26.1,18.440000000000001,30.34,3.6,3.96,1,1,2,1,1,1,449.7,526.20000000000005,679.3,27.72,32.44,41.88,5.84,6.84,8.82,124.8,146,188.5,null,540.54866776461631]
[180,18.8,180,91,5.3,8,9,2394.86,1316.96,146.33000000000001,166.41,74.16,1125.26,100.85,22.16,34.6,20.52,31.84,4.79,7.43,1,2,3,1,1,1,536,627.20000000000005,809.7,37.25,43.58,56.26,7.74,9.06,11.7,145.4,170.2,219.7,null,606.94866776461629]
[200,22.36,200,100,5.6,8.5,12,2848.64,1943.17,194.32,220.64,82.59,1400.24,142.37,28.47,44.61,22.36,36.659999999999997,6.98,12.99,1,2,3,1,1,1,637.6,746.1,963.1,49.38,57.79,74.599999999999994,9.98,11.68,15.08,180.9,211.7,273.3,null,668.19822368615496]
[220,26.2,220,110,5.9,9.1999999999999993,12,3337.28,2771.84,251.99,285.41000000000003,91.14,1588.36,204.89,37.25,58.11,24.78,38.36,9.07,22.67,2,2,3,1,1,1,746.9,874,1128,63.88,74.75,96.49,13.01,15.22,19.649999999999999,205.2,240.2,310,null,737.59822368615505]
[240,30.71,240,120,6.2,9.8000000000000007,15,3911.98,3891.62,324.3,366.65,99.74,1914.74,283.63,47.27,73.92,26.93,43.37,12.88,37.39,2,3,4,1,1,1,875.5,1025,"-",82.06,96.03,124,16.54,19.36,24.99,247.4,289.5,373.8,null,801.84777960769384]
[270,36.07,270,135,6.6,10.199999999999999,15,4594.8599999999997,5789.78,428.87,484,112.25,2214.1799999999998,419.87,62.2,96.95,30.23,44.57,15.94,70.58,2,3,4,1,1,1,1028,1203,"-",108.3,126.8,163.6,21.7,25.39,32.78,286.10000000000002,334.8,432.2,null,906.04777960769377]
[300,42.25,300,150,7.1,10.7,15,5381.56,8356.1,557.07000000000005,628.36,124.61,2568.5300000000002,603.78,80.5,125.22,33.5,46.07,20.12,125.93,3,4,4,1,1,1,1204,"-","-",140.6,164.6,212.4,28.03,32.799999999999997,42.34,331.9,388.4,501.4,null,1010.0477796076938]
[330,49.15,330,160,7.5,11.5,18,6261.14,11766.89,713.15,804.33,137.09,3081.39,788.14,98.52,153.68,35.479999999999997,51.59,28.15,199.1,3,4,4,1,1,1,1401,"-","-",180,210.7,271.89999999999998,34.39,40.25,51.96,398.2,465.9,601.5,null,1094.0973355292326]
[360,57.1,360,170,8,12.7,18,7273.44,16265.62,903.65,1019.15,149.54,3514.24,1043.45,122.76,191.1,37.880000000000003,54.49,37.32,313.58,3,4,4,1,1,1,1628,"-","-",228.1,266.89999999999998,344.6,42.77,50.05,64.61,454.1,531.4,686,null,1183.0973355292326]
[400,66.31,400,180,8.6,13.5,21,8447.06,23128.35,1156.42,1307.1500000000001,165.47,4270.16,1317.82,146.41999999999999,229,39.5,60.2,51.08,490.05,4,4,4,1,1,1,"-","-","-",292.60000000000002,342.3,441.9,51.25,59.98,77.42,551.79999999999995,645.70000000000005,833.5,null,1286.7468914507713]
[450,77.58,450,190,9.4,14.6,21,9882.7800000000007,33742.910000000003,1499.69,1701.79,184.78,5085.22,1675.86,176.41,276.38,41.18,63.2,66.87,791.01,4,4,4,1,1,1,"-","-","-",380.9,445.7,575.4,61.86,72.39,93.44,657.1,768.9,992.6,null,1415.1468914507714]
[500,90.69,500,200,10.199999999999999,16,21,11552.86,48198.5,1927.94,2194.12,204.25,5988.06,2141.6799999999998,214.17,335.88,43.06,66.8,89.29,1249.3699999999999,4,4,4,1,1,1,"-","-","-",491.1,574.6,741.8,75.17,87.97,113.6,773.8,905.5,1169,null,1543.5468914507712]
[550,105.52,550,210,11.1,17.2,24,13442.52,67116.460000000006,2440.6,2787.01,223.45,7235.04,2667.58,254.06,400.54,44.55,73.62,123.24,1884.1,4,4,4,1,1,1,"-","-","-",623.79999999999995,729.9,942.3,89.64,104.9,135.4,934.9,1094,1412,null,1666.59644737231]
[600,122.45,600,220,12,19,24,15599.36,92083.4,3069.45,3512.4,242.96,8379.36,3387.34,307.94,485.65,46.6,78.12,165.42,2845.53,4,4,4,1,1,1,"-","-","-",786.1,919.9,1188,108.7,127.2,164.2,1083,1267,1636,null,1794.79644737231]

{"sheet":"HEB","index":3,"n_rows":21,"n_cols":40,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["series","weight","h","b","tw","tf","r","A","I strong","Wel strong","Wpl strong","i strong","Av strong","I weak","Wel weak","Wpl weak","i weak","ss","It","Iw","class, compression",null,null,"class, bending",null,null,"Npl,Rd",null,null,"Mpl,Rd strong",null,null,"Mpl,Rd weak",null,null,"Vpl,Rd strong",null,null,null,"perimeter non protected"]
["-","[kp/m]","[mm]","[mm]","[mm]","[mm]","[mm]","[mm2]","[cm4]","[cm3]","[cm3]","[mm]","[mm2]","[cm4]","[cm3]","[cm3]","[mm]","[mm]","[cm4]","[]","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335","S235","S275","S335",null,"[mm]"]
[100,20.399999999999999,100,100,6,10,12,2603.84,449.54,89.91,104.21,41.55,903.84,167.27,33.450000000000003,51.42,25.35,40.06,9.25,3.38,1,1,1,1,1,1,582.76,681.96,880.35,23.32,27.29,35.229999999999997,11.51,13.47,17.39,116.79,136.66999999999999,176.43,null,{"$f":"3*D3-2*E3+2*C3+(2*PI()-8)*G3","v":467.39822368615501}]
[120,26.7,120,120,6.5,11,12,3400.84,864.37,144.06,165.21,50.41,1096.3399999999999,317.52,52.92,80.97,30.56,42.56,13.84,9.41,1,1,1,1,1,1,761.14,890.7,1149.81,36.979999999999997,43.27,55.86,18.12,21.21,27.37,141.66999999999999,165.78,214,null,566.39822368615501]
[140,33.700000000000003,140,140,7,12,12,4295.84,1509.23,215.6,245.43,59.27,1307.8399999999999,549.66999999999996,78.52,119.78,35.770000000000003,45.06,20.059999999999999,22.48,1,1,1,1,1,1,961.45,1125.0999999999999,1452.4,54.93,64.28,82.98,26.81,31.37,40.5,168.99,197.76,255.29,null,665.39822368615501]
[160,42.6,160,160,8,13,15,5425.5,2492,311.5,353.97,67.77,1759.5,889.23,111.15,169.96,40.479999999999997,51.57,31.24,47.94,1,1,1,1,1,1,1214.28,1420.96,1834.34,79.22,92.71,119.67,38.04,44.51,57.46,227.36,266.06,343.45,null,758.24777960769381]
[180,51.2,180,180,8.5,14,15,6525.5,3831.13,425.68,481.45,76.62,2024.5,1362.85,151.43,231.01,45.7,54.07,42.16,93.75,1,1,1,1,1,1,1460.47,1709.06,2206.2399999999998,107.75,126.09,162.78,51.7,60.5,78.099999999999994,261.60000000000002,306.13,395.18,null,857.24777960769381]
[200,61.3,200,200,9,15,18,7808.64,5696.17,569.62,642.54999999999995,85.41,2483.64,2003.37,200.34,305.81,50.65,60.09,59.28,171.13,1,1,1,1,1,1,1747.65,2045.12,2640.06,143.81,168.29,217.24,68.44,80.09,103.39,320.93,375.55,484.8,null,951.09733552923251]
[220,71.5,220,220,9.5,16,18,9104.64,8090.96,735.54,827.05,94.27,2792.64,2843.26,258.48,393.88,55.88,62.59,76.569999999999993,295.42,1,1,1,1,1,1,2037.71,2384.5500000000002,3078.24,185.1,216.61,279.62,88.15,103.16,133.16999999999999,360.86,422.28,545.12,null,1050.0973355292326]
[240,83.2,240,240,10,17,21,10599.26,11259.29,938.27,1053.1500000000001,103.07,3323.26,3922.66,326.89,498.42,60.83,68.599999999999994,102.69,486.95,1,1,1,1,1,1,2372.2199999999998,2776,3583.56,235.7,275.82,356.06,111.55,130.54,168.51,429.42,502.51,648.70000000000005,null,1143.9468914507713]
[260,93,260,260,10,17.5,24,11845.36,14919.41,1147.6500000000001,1282.9100000000001,112.23,3760.36,5134.51,394.96,602.25,65.84,73.12,123.78,753.65,1,1,1,1,1,1,2651.1,3102.36,4004.86,287.13,336,433.75,134.79,157.72999999999999,203.62,485.9,568.61,734.02,null,1238.79644737231]
[280,103,280,280,10.5,18,24,13137.36,19270.25,1376.45,1534.43,121.11,4110.3599999999997,6594.52,471.04,717.57,70.849999999999994,74.62,143.72,1130.1500000000001,1,1,1,1,1,1,2940.27,3440.74,4441.68,343.42,401.88,518.78,160.6,187.94,242.61,531.13,621.53,802.34,null,1337.79644737231]
[300,117,300,300,11,19,27,14908.94,25165.65,1677.71,1868.67,129.91999999999999,4743.9399999999996,8562.82,570.85,870.14,75.790000000000006,80.63,185.05,1687.79,1,1,1,1,1,1,3336.76,3904.72,5040.6400000000003,418.23,489.41,631.79,194.75,227.89,294.19,613,717.33,926.01,null,1431.6460032938489]
[320,127,320,300,11.5,20.5,27,16135.44,30823.51,1926.47,2149.2399999999998,138.21,5178.1899999999996,9238.82,615.91999999999996,939.1,75.67,84.13,225.07,2068.71,1,1,1,1,1,1,3611.27,4225.95,5455.32,481.02,562.9,726.65,210.18,245.95,317.5,669.11,783,1010.78,null,1470.6460032938489]
[340,134,340,300,12,21.5,27,17090.939999999999,36656.36,2156.2600000000002,2408.11,146.44999999999999,5609.94,9689.93,646,985.72,75.3,86.63,257.2,2453.63,1,1,1,1,1,1,3825.12,4476.2,5778.37,538.96,630.69000000000005,814.17,220.61,258.16000000000003,333.27,724.9,848.28,1095.06,null,1509.6460032938489]
[360,142,360,300,12.5,22.5,27,18064.439999999999,43193.42,2399.63,2682.99,154.63,6060.69,10141.16,676.08,1032.49,74.930000000000007,89.13,292.45,2883.25,1,1,1,1,1,1,4042.99,4731.16,6107.5,600.48,702.69,907.11,231.08,270.41000000000003,349.08,783.14,916.44,1183.04,null,1548.6460032938489]
[400,155,400,300,13.5,24,27,19778.939999999999,57680.480000000003,2884.02,3231.74,170.77,6998.94,10819.03,721.27,1104.04,73.959999999999994,93.13,355.75,3817.15,1,1,1,1,1,1,4426.72,5180.2,6687.17,723.29,846.41,1092.6400000000001,247.09,289.14999999999998,373.27,904.38,1058.32,1366.19,null,1626.6460032938489]
[450,171,450,300,14,26,27,21798.94,79887.520000000004,3550.56,3982.37,191.44,7966.94,11721.32,781.42,1197.6600000000001,73.33,97.63,440.48,5258.45,1,1,2,1,1,1,4878.8100000000004,5709.25,7370.12,891.29,1043,1346.42,268.05,313.67,404.92,1029.46,1204.69,1555.14,null,1725.6460032938489]
[500,187,500,300,14.5,28,27,23864.94,107175.73,4287.03,4814.57,211.92,8982.94,12623.91,841.59,1291.6500000000001,72.73,102.13,538.44000000000005,7017.7,1,2,2,1,1,1,5341.2,6250.34,8068.62,1077.55,1260.96,1627.78,289.08,338.29,436.7,1160.74,1358.32,1753.46,null,1824.6460032938489]
[550,199,550,300,15,29,27,25406.94,136690.81,4970.57,5590.61,231.95,10007.94,13076.89,871.79,1341.14,71.739999999999995,104.63,600.33000000000004,8855.76,1,2,3,1,1,1,5686.32,6654.2,8589.9699999999993,1251.23,1464.21,1890.16,300.16000000000003,351.25,453.43,1293.19,1513.31,1953.54,null,1923.6460032938489]
[600,212,600,300,15.5,30,27,26996.94,171041.04,5701.37,6425.14,251.71,11081.94,13530.24,902.02,1391.06,70.790000000000006,107.13,667.18,10965.38,2,2,4,1,1,1,6042.17,7070.63,"-",1438.01,1682.77,2172.31,311.33,364.32,470.31,1431.97,1675.71,2163.19,null,2022.6460032938489]