{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Goodman ","teoria"],"not_rendered":{"charts":1,"images":7,"macros":0,"external_links":0,"defined_names":1,"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":"Goodman ","index":0,"n_rows":27,"n_cols":26,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,4,2,13]]}
[]
[null,"Diagrama de Goodman"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D22","v":16074.64925228143},0]
[null,null,"Datos de las varillas",null,null,"Referencias - UTS (psi)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y4","v":16074.64925228143},{"$f":"+D24","v":44041.990204408306}]
[null,null,"Grado de Acero","Alta Res.",null,"C",90000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+Z5","v":44041.990204408306}]
[null,null,"UTS (psi) ",{"$f":"VLOOKUP(D6,F6:G12,2,0)","v":140000},null,"K",90000]
[null,null,"Fs, Factor de servicio",1,1,"D",115000]
[null,null,"A",4,0.9,"D Alloy",120000]
[null,null,"B",0.5625,0.8,"D Especial",125000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"200/1.75","v":114.28571428571429}]
[null,null,null,null,null,"Alta Res.",140000]
[null,null,null,null,null,"Ingresar otra"]
[]
[]
[null,null,"(*) Datos a ser ingresados o seleccionados"]
[null,null,null,"Tramo 1","Tramo 2","Tramo 3","Tramo 4"]
[null,null,"Diametro varilla (pulg) (*)",1,0.875,0.75,1]
[null,null,"area-pulg 2",{"$f":"+PI()*D17^2/4","v":0.78539816339744828},{"$f":"+PI()*E17^2/4","v":0.6013204688511713},{"$f":"+PI()*F17^2/4","v":0.44178646691106466},{"$f":"+PI()*G17^2/4","v":0.78539816339744828},null,null,null,null,null,null,null,null,null,null,null,null,null,"Sadm","Smin"]
[null,null,"Carga mínima (lbs) (*)",12625,6148,1935,-2899,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+($D$7/$D$9+$D$10*V19)*$D$8","v":94062.5},105000,null,0,0]
[null,null,"Carga máxima (lbs) (*)",28652,20855,14356,6894,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+($D$7/$D$9+$D$10*V20)*$D$8","v":35000},0,null,105000,{"$f":"+X20","v":105000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tension maxima admisible",null,null,null,null,null,null,{"$f":"+($D$7/$D$9+$D$10*V21)*$D$8","v":31236.244189894678},{"$f":"+G22-3000","v":-6691.1214401872367},null,0,{"$f":"+D7/4","v":35000}]
[null,null,"Smin, Tensión mínima (psi)",{"$f":"+D19/D18","v":16074.64925228143},{"$f":"+E19/E18","v":10224.165513184367},{"$f":"+F19/F18","v":4379.9440338889599},{"$f":"+G19/G18","v":-3691.1214401872367}]
[null,null,"Smax, Tensión máxima (psi)",{"$f":"+D20/D18","v":36480.859435751881},{"$f":"+E20/E18","v":34682.005819365644},{"$f":"+F20/F18","v":32495.336718609771},{"$f":"+G20/G18","v":8777.7134214042126}]
[null,null,"Tensión máxima admisible (psi)",{"$f":"($D$10*D22+($D$7/$D$9))*$D$8","v":44041.990204408306},{"$f":"($D$10*E22+($D$7/$D$9))*$D$8","v":40751.093101166203},{"$f":"($D$10*F22+($D$7/$D$9))*$D$8","v":37463.718519062539},{"$f":"($D$10*G22+($D$7/$D$9))*$D$8","v":32923.744189894678}]
[null,null,"% de Goodman",{"$f":"+(D23-D22)/(D24-D22)","v":0.72964427395513942},{"$f":"+(E23-E22)/(E24-E22)","v":0.80118905630745818},{"$f":"+(F23-F22)/(F24-F22)","v":0.84982421510945394},{"$f":"+(G23-G22)/(G24-G22)","v":0.3405402326902805}]
[]
[null,null,"Observaciones"]

{"sheet":"teoria","index":1,"n_rows":239,"n_cols":1,"rows_kept":239,"cut":false,"hidden":false,"merged":[[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[5,0,5,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[42,0,42,4],[43,0,43,4],[44,0,44,4],[45,0,45,4],[46,0,46,4],[47,0,47,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4],[40,0,40,4],[41,0,41,4],[54,0,54,4],[55,0,55,4],[56,0,56,4],[57,0,57,4],[58,0,58,4],[59,0,59,4],[48,0,48,4],[49,0,49,4],[50,0,50,4],[51,0,51,4],[52,0,52,4],[53,0,53,4],[66,0,66,4],[67,0,67,4],[68,0,68,4],[69,0,69,4],[70,0,70,4],[71,0,71,4],[60,0,60,4],[61,0,61,4],[62,0,62,4],[63,0,63,4],[64,0,64,4],[65,0,65,4],[78,0,78,4],[79,0,79,4],[80,0,80,4],[81,0,81,4],[82,0,82,4],[83,0,83,4],[72,0,72,4],[73,0,73,4],[74,0,74,4],[75,0,75,4],[76,0,76,4],[77,0,77,4],[90,0,90,4],[91,0,91,4],[92,0,92,4],[93,0,93,4],[94,0,94,4],[95,0,95,4],[84,0,84,4],[85,0,85,4],[86,0,86,4],[87,0,87,4],[88,0,88,4],[89,0,89,4],[102,0,102,4],[103,0,103,4],[104,0,104,4],[105,0,105,4],[106,0,106,4],[107,0,107,4],[96,0,96,4],[97,0,97,4],[98,0,98,4],[99,0,99,4],[100,0,100,4],[101,0,101,4],[114,0,114,4],[115,0,115,4],[116,0,116,4],[117,0,117,4],[118,0,118,4],[119,0,119,4],[108,0,108,4],[109,0,109,4],[110,0,110,4],[111,0,111,4],[112,0,112,4],[113,0,113,4],[126,0,126,4],[127,0,127,4],[128,0,128,4],[129,0,129,4],[130,0,130,4],[131,0,131,4],[120,0,120,4],[121,0,121,4],[122,0,122,4],[123,0,123,4],[124,0,124,4],[125,0,125,4],[138,0,138,4],[139,0,139,4],[140,0,140,4],[141,0,141,4],[142,0,142,4],[143,0,143,4],[132,0,132,4],[133,0,133,4],[134,0,134,4],[135,0,135,4],[136,0,136,4],[137,0,137,4],[150,0,150,4],[151,0,151,4],[152,0,152,4],[153,0,153,4],[154,0,154,4],[155,0,155,4],[144,0,144,4],[145,0,145,4],[146,0,146,4],[147,0,147,4],[148,0,148,4],[149,0,149,4],[162,0,162,4],[163,0,163,4],[164,0,164,4],[165,0,165,4],[166,0,166,4],[167,0,167,4],[156,0,156,4],[157,0,157,4],[158,0,158,4],[159,0,159,4],[160,0,160,4],[161,0,161,4],[174,0,174,4],[175,0,175,4],[176,0,176,4],[177,0,177,4],[178,0,178,4],[179,0,179,4],[168,0,168,4],[169,0,169,4],[170,0,170,4],[171,0,171,4],[172,0,172,4],[173,0,173,4],[186,0,186,4],[187,0,187,4],[188,0,188,4],[189,0,189,4],[190,0,190,4],[191,0,191,4],[180,0,180,4],[181,0,181,4],[182,0,182,4],[183,0,183,4],[184,0,184,4],[185,0,185,4],[198,0,198,4],[199,0,199,4],[200,0,200,4],[201,0,201,4],[202,0,202,4],[203,0,203,4],[192,0,192,4],[193,0,193,4],[194,0,194,4],[195,0,195,4],[196,0,196,4],[197,0,197,4],[210,0,210,4],[211,0,211,4],[212,0,212,4],[213,0,213,4],[214,0,214,4],[215,0,215,4],[204,0,204,4],[205,0,205,4],[206,0,206,4],[207,0,207,4],[208,0,208,4],[209,0,209,4],[222,0,222,4],[223,0,223,4],[224,0,224,4],[225,0,225,4],[226,0,226,4],[227,0,227,4],[216,0,216,4],[217,0,217,4],[218,0,218,4],[219,0,219,4],[220,0,220,4],[221,0,221,4],[234,0,234,4],[235,0,235,4],[236,0,236,4],[237,0,237,4],[238,0,238,4],[228,0,228,4],[229,0,229,4],[230,0,230,4],[231,0,231,4],[232,0,232,4],[233,0,233,4]]}
["Diagrama de Goodman modificado. "]
["Consiste en las rectas trazadas hasta Se (límite de resistencia a la fatiga), arriba y abajo del "]
["origen "]
["El esfuerzo medio está representado en el eje horizontal, los demás esfuerzos en el eje vertical. "]
["La línea de esfuerzo medio con una pendiente de 1, va del origen a la resistencia última de la "]
["pieza. La resistencia de fluencia, ser indica en ambos ejes puesto que la cadencia sería el "]
["criterio de falla si smax fuese mayor a Sy. "]
["Diagrama de fatiga con cuatro criterios de falla. "]
["Para cada criterio, los puntos sobre y fuera de la línea respectiva indican una falla. "]
["Se tienen la línea de Soderberg, la de Goodman modificada, la de Gerber y la de fluencia o "]
["cadencia.  "]
["Relación de Soderberg. "]
["Relación de Goodman. "]
["Relación de Gerber. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6\\"]
["6\\"]
["6X"]
["6H"]
["/tQHD\u0003GH\u0003IOXHQFLD"]
["/tQHD\u0003GH\u0003*HUEHU"]
["/tQHD\u0003GH\u0003*RRGPDQ"]
["/tQHD\u0003GH\u00036RGHUEHUJ"]
["6P"]
["6D"]
["P"]
["(VIXHU]R\u0003PHGLR"]
["Como las resistencias Sa y Sm, pueden colocarse en términos de los esfuerzos sa y sm, "]
["haciendo uso de un factor de seguridad n, como: "]
["Las relaciones descritas, pueden escribirse consecuentemente de la siguiente manera: "]
["La línea de esfuerzo seguro, se traza paralelamente a la línea de Goodman modificada, por "]
["ejemplo la que pasa por A, representando el lugar geométrico de todos los conjuntos de "]
["esfuerzos sa, sm con un factor n de seguridad. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Algunos usos: "]
["a) Con sm constante, determinar n. "]
["En una barra circular de 1.5” AISI1050 (Sy=84 kpsi, Su=100kpsi) estirada en frío, sometida a "]
["tensiones fluctuantes que originan: "]
["sm=4.53 kpsi, sa=4.53 kpsi y un l"]
["ímite de fatiga d"]
["el 50% de Se=20 kpsi. "]
["Se grafica: "]
["Obteniéndose Sa=19,049 kpsi y con n=Sa/"]
["sa, n=4.215."]
[0]
[20]
[40]
[60]
[80]
[100]
[120]
[0]
[10]
[20]
[19049]
["Sa("]
["Sm)"]
["4.53"]
["Sm"]
["b) Con sa constante, determinar n. "]
["Se grafica: "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]
[20]
[40]
[60]
[80]
[100]
[120]
[0]
[10]
[20]
["4.53"]
["Sa1("]
["Sm1)"]
["77.35"]
["Sm1"]
["Obteniéndose con "]
["sa=Sa=4."]
["53 kpsi, a Sm=77.35 kpsi y con n=Sm/sm, n=17.075. "]
["c) Con sa/sm constante, determinar n. "]
["Se grafican Sa=ASm donde A="]
["a/"]
["m=constante, y "]
[", resultando en su "]
["intersección: "]
["Sm=16667 kips, por lo que n=Sm/sm es n=3.679. "]
[0]
[20]
[40]
[60]
[80]
[100]
[120]
[0]
[10]
[20]
[25]
[0]
["a"]
[16667]
["Sa("]
["Sm)"]
["Sa1("]
["Sm)"]
[120]
[0]
[16667]
["m"]
["Sm"]
["Conclusión. "]
["Como pudo observarse, el enfoque gráfico y algebraico, basado en los diagramas que "]
["representan los criterios de falla mostrados, resulta de fácil y rápido uso, para efectos de "]
["cálculo de coeficientes de seguridad y estimaciones de vida de un material. "]