{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home","Materials","Help"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":1,"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":"Home","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,11,25,12],[1,7,3,20],[2,0,3,0],[2,1,2,2],[1,0,1,5],[2,5,3,5],[2,3,2,4],[27,9,28,9],[29,9,30,9],[31,9,32,9],[25,7,25,9],[27,7,28,7],[29,7,30,7],[31,7,32,7],[27,8,28,8],[29,8,30,8],[31,8,32,8],[26,11,27,11],[28,11,29,11],[30,11,31,11],[26,12,27,12],[28,12,29,12],[30,12,31,12]]}
[]
["Truss analysis",null,null,null,null,null,null,"Bridge Truss Analysis"]
["Truss member","Failure Point",null,"Force",null,"Failure Rating"]
[null,"Compression","Tension","Force (lbs.)","Type"]
[1,20000,50000,16821.26007277182,"Tension",2.9724289252821094]
[2,20000,50000,17830.500057578585,"Tension",2.8041838332373779]
[3,20000,50000,26745.750086367876,"Tension",1.8694558888249186]
[4,20000,50000,35661.000115157171,"Tension",1.4020919166186889]
[5,20000,50000,14689.000047433996,"Tension",3.4039076750315922]
[6,20000,50000,11016.750035575496,"Tension",4.5385435667087899]
[7,20000,50000,7344.500023716997,"Tension",6.8078153500631853]
[8,20000,50000,6928.7874487239642,"Tension",7.2162698552988838]
[9,40000,25000,8915.2500287892926,"Tension",2.8041838332373779]
[10,40000,25000,8915.2500287892926,"Tension",2.8041838332373779]
[11,40000,25000,8.5709217501062085E-14,"Compression",4.6669426190367834E+17]
[12,40000,25000,8915.2500287892908,"Compression",4.4866941331798049]
[13,40000,25000,3672.2500118584985,"Compression",10.892504560101097]
[14,40000,25000,0,"Zero","N/A"]
[15,40000,25000,3672.2500118584985,"Tension",6.8078153500631853]
[16,40000,25000,3672.2500118584985,"Tension",6.8078153500631853]
[17,30000,50000,0,"Zero","N/A"]
[18,30000,50000,16821.26007277182,"Compression",1.7834573551692656]
[19,30000,50000,14264.4,"Tension",3.5052298028658759]
[20,30000,50000,16821.26007277182,"Compression",1.7834573551692656]
[21,30000,50000,14264.4,"Tension",3.5052298028658759]
[22,30000,50000,16821.26007277182,"Compression",1.7834573551692656,null,"Active Forces",null,null,null,"Bridge Materials"]
[23,30000,50000,20140,"Tension",2.4826216484607744,null,"Type","Weight (lbs)","Distance",null,"Top (Compresison)","Stainless Steel"]
[24,30000,50000,6928.7874487239642,"Compression",4.3297619131793299,null,"Person",140,14]
[25,30000,50000,5875.6,"Tension",8.5097692150588866,null,null,null,null,null,"Middle","Heat Treated Carbon Steel"]
[26,30000,50000,6928.7874487239642,"Compression",4.3297619131793299,null,"Car",4000,23]
[27,30000,50000,5875.6,"Tension",8.5097692150588866,null,null,null,null,null,"Bottom (Tension)","Weathering Steel"]
[28,30000,50000,6928.7874487239642,"Compression",4.3297619131793299,null,"Truck",6000,38]
[29,30000,50000,0,"Zero","N/A"]
[]
[null,null,null,null,null,"Failure rating"]
[null,null,null,null,null,{"$f":"MIN(F5:F33)","v":1.4020919166186889}]

{"sheet":"Materials","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,4,2,5],[3,4,3,5],[0,0,1,2]]}
["Bridge Materials"]
[]
[null,null,null,null,"Total Materials"]
[null,null,null,null,{"$f":"COUNT(B7:B94)","v":4}]
[]
["Material","Tension","Compression"]
["Carbon Steel",20000,40000]
["Heat Treated Carbon Steel",50000,30000]
["Stainless Steel",50000,20000]
["Weathering Steel",25000,40000]

{"sheet":"Help","index":2,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Instructions:"]
[]
[null,null,null,null,null,null,null,null,null,"The purpose of this workbook is to perform truss analysis on a simple bridge."]
[]
[null,null,null,null,null,null,null,null,null,"Start by adjusting the horizontal position of the car, person and truck using the arrows next to them. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"You can also adjust the materials of the upper middle, and lower trusses using a drop down menu (this affects their Failure point)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Experiment with the adjustable values and observe the results, or use this application in a real bridge building project"]
[]
[null,null,null,null,null,null,null,null,null,"Table Description:"]
[]
[null,null,null,null,null,null,null,null,null,"Pressing the Compute button on the right side of the sheet will update the values of the table on the left based off of the changes you have made"]
[]
[null,null,null,null,null,null,null,null,null,"The Truss member column of the table labels which row of data on the table corresponds to which truss member in the picture"]
[]
[null,null,null,null,null,null,null,null,null,"The Failure point columns of the table tell you how much force that member can sustain before it fails. It has 2 values depending on if the force is tension (pulling apart) or compression (crushing)"]
[]
[null,null,null,null,null,null,null,null,null,"The Force columns of the table give you the amount of force acting on the object and if that force is tension or compression"]
[]
[null,null,null,null,null,null,null,null,null,"The Failure rating column of the table tells you if this member is taking more force than it can handle. If the Force acting on it exceeds the Failure point, then this value will be less than 1."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"There is a box at the bottom that gives you the overall Failure point of the entire truss, which will be the member with the lowest Failure rating"]
[]
[null,null,null,null,null,null,null,null,null,"Any failed Truss members will be colored red in the diagram"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Adding/Removing Materials:"]
[]
[null,null,null,null,null,null,null,null,null,"On the Materials sheet, you can add or remove materials for the truss members on the home sheet"]
[]
[null,null,null,null,null,null,null,null,null,"To remove a material, first press the remove material button and then select the name of the material that you would like to remove "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"To add a material, first press the add material button and then fill out the fields in the popup window for the name of the material and its failure point depending on compression or tension"]