{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Truss","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Truss","index":0,"n_rows":89,"n_cols":19,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[null,"NOTES:","Yellow cells: input; White cells: output",null,null,null,"WARNING - THIS WORKSHEET IS NOT LOCKED"]
[null,null,"Do not skip lines when entering joints or members",null,null,null,"Make changes at your own risk"]
[]
[]
[null,"JOINTS",null,null,"FORCES",null,"DISPLACEMENTS",null,"OUTPUT"]
[null,null,"x","y","Fx","Fy","BC: δx","BC: δy","dx","dy","Fx","Fy"]
[null,"A",-90,0,null,null,0,0,0,0,1.3096723705530167E-10,7499.9999999988504]
[null,"B",0,12,null,-15000,null,null,0.13260637184947169,-3.4010747490418747]
[null,"C",90,0,null,null,null,0,0.53006297882411402,0,null,7499.999999998865]
[null,"D",0,0,null,null,null,null,0.29008936009753017,-3.4010747490418751]
[null,"E",50,0,null,null,null,null,0.31203972301019356,-2.6534357858722002]
[null,"F",-50,0,null,null,null,null,1.7560290330130731E-2,-2.9217160760446217]
[null,"G"]
[null,"H"]
[null,"I"]
[null,"J"]
[null,"K"]
[null,"L"]
[null,"M"]
[null,"N"]
[null,"O"]
[null,"P"]
[null,"Q"]
[null,"R"]
[null,"S"]
[null,"T"]
[null,"U"]
[null,"V"]
[null,"W"]
[null,"X"]
[null,"Y"]
[null,"Z",null,null,null,null,null,null,null,null,null,null,null,2.1,"Target Factor of Safety",null,"Black = Pass",null,"(Truss graphing - Brian Neumeyer, Summer 2015)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red = Fail, yielding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blue = Fail, buckling"]
[null,"MEMBERS",null,null,null,null,null,{"$f":"SUM(H37:H86)","v":234.45442378201435},"TOTAL WEIGHT",null,null,null,null,null,null,null,"Orange = Fail both"]
[null,"Joint 1","Joint 2","Matl ID","Sect ID","Force","Length","Weight","Stress","FS-Yield","FS-Buckling",null,"MATERIALS"]
[1,"A","B",1,3,-56747.797314072144,90.796475702529335,13.384913793147867,-105088.51354457803,0.42,"0.08 E",null,"ID","E","Sy"]
[{"$f":"A37+1","v":2},"B","C",1,10,-56747.797314072093,90.796475702529335,79.522579969465284,-18347.170162971903,2.4,"1.56 J",null,1,30000000,44000]
[{"$f":"A38+1","v":3},"A","F",1,12,56249.999999991262,40,48.4,13170.217747598048,3.34,null,null,2]
[4,"D","E",1,12,56249.999999991196,50,60.5,13170.217747598033,3.34,null,null,3]
[5,"B","D",1,12,4.7417625381740436E-9,12,14.52,1.1102230246251565E-9,">100",null,null,4]
[6,"B","F",1,1,4.5067328588112253E-11,51.419840528729765,4.8334650097005971,1.310096761282333E-10,">100",null,null,5]
[7,"E","B",1,1,0,51.419840528729765,4.8334650097005971,0,">100"]
[8,"F","D",1,1,56249.99999999124,50,4.6999999999999993,163517.44186043966,0.27,null,null,"SECTIONS"]
[9,"E","C",1,1,56249.999999991458,40,3.7599999999999993,163517.4418604403,0.27,null,null,"ID","Label","Area","Rgyr","Uwgt"]
[10,null,null,null,null,null,null,null,null,null,null,null,1,"1x1/8",0.34399999999999997,0.313,{"$f":"1.128/12","v":9.3999999999999986E-2}]
[11,null,null,null,null,null,null,null,null,null,null,null,2,"1x1/4",0.58899999999999997,0.28000000000000003,{"$f":"2.003/12","v":0.16691666666666669}]
[12,null,null,null,null,null,null,null,null,null,null,null,3,"1-1/2x1/8",0.54,0.48799999999999999,{"$f":"1.769/12","v":0.14741666666666667}]
[13,null,null,null,null,null,null,null,null,null,null,null,4,"1-1/2x1/4",0.98199999999999998,0.45100000000000001,{"$f":"3.338/12","v":0.27816666666666667}]
[14,null,null,null,null,null,null,null,null,null,null,null,5,"2x1/8",0.73599999999999999,0.66400000000000003,{"$f":"2.67/12","v":0.2225}]
[15,null,null,null,null,null,null,null,null,null,null,null,6,"2x1/4",1.3740000000000001,0.625,{"$f":"4.673/12","v":0.38941666666666669}]
[16,null,null,null,null,null,null,null,null,null,null,null,7,"2-1/2x1/8",0.93300000000000005,0.84099999999999997,{"$f":"3.05/12","v":0.25416666666666665}]
[17,null,null,null,null,null,null,null,null,null,null,null,8,"2-1/2x1/4",1.7669999999999999,0.8,{"$f":"6.008/12","v":0.5006666666666667}]
[18,null,null,null,null,null,null,null,null,null,null,null,9,"3x1/4",2.16,0.97599999999999998,{"$f":"7.343/12","v":0.61191666666666666}]
[19,null,null,null,null,null,null,null,null,null,null,null,10,"3x3/8",3.093,0.93799999999999994,{"$f":"10.51/12","v":0.87583333333333335}]
[20,null,null,null,null,null,null,null,null,null,null,null,11,"4x3/16",2.246,1.35,{"$f":"7.654/12","v":0.63783333333333336}]
[21,null,null,null,null,null,null,null,null,null,null,null,12,"4x3/8",4.2709999999999999,1.2889999999999999,{"$f":"14.52/12","v":1.21}]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[]
[]
[null,"Worksheet password is \"TrussLock\" - make chages at your own risk."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}