{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["W-Tree","Stress_Data","Catia","data","Help"],"not_rendered":{"charts":0,"images":67,"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":"W-Tree","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
["ID","Number of Loading Points:",7,null,"Space:",3,null,null,null,"Unit L:","in"]
["9F","Loading Direction:","X",null,"Input Dialog:","Up-left",null,null,null,"Unit W:","lb"]
[null,"Warning Length:",2,null,"Catia Scale:",25.4,null,null,null,"Decimal L:",2]
[null,"Factors","3*1.15*1.1",null,null,null,null,null,null,"Decimal W:",0]
[]
["ID","Name","Weight","X","Y","Z","Load","Row","Col","Dist","Rod"]
[1,"Structure",300,606.90930000000003,-79.787289999999999,243.42179999999999]
[2,"Payload 1",150,600.79999999999995,-71,221.92]
[3,"Payload 2",150,600.79999999999995,-87.45,221.92]
[4,"Payload 3",150,613.20000000000005,-71,201.92]
[5,"Payload 4",150,613.20000000000005,-87.45,201.92]
[6,"Structure 2",110,618.47,-78.900000000000006,256.2]
[7,"Item of Mass",36,629.67999999999995,-68.599999999999994,267.87]

{"sheet":"Stress_Data","index":1,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":true,"merged":[[8,9,8,15],[8,1,8,6]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Nomenclature"]
[null,null,null,null,null,null,null,null,null,"D = Diameter",null,null,null,"Iyy = Moment of Inertia"]
[null,null,null,null,null,null,null,null,null,"F_max = Allowable tensile stress (Ftu)",null,null,null,"c = Distance from neutral axis to extreme fiber"]
[null,"Enter rod and beam information.",null,null,null,null,null,null,null,"P_max = Allowable load",null,null,null,"M_Max = Allowable bending moment"]
[]
[null,"Available Rod",null,null,null,null,null,null,null,"Available Beam"]
[null,"No.","Name","D","F_max","P_max","Use",null,null,"No.","Name","Iyy","c","F_max","M_max","Use"]
[null,1,"3/8\" Rod",0.375,45000,{"$f":"IF(C11<>\"\",0.25*PI()*D11^2*E11,\"\")","v":4970.097752749477},"x",null,null,1,"2\" CH",6.3E-2,0.71,45000,{"$f":"IF(K11<>\"\",N11*L11/M11,\"\")","v":3992.9577464788736},"x"]
[null,2,"1/2\" Rod",0.5,45000,{"$f":"IF(C12<>\"\",0.25*PI()*D12^2*E12,\"\")","v":8835.7293382212938},"x",null,null,2,"3\" CH",0.247,1.06,45000,{"$f":"IF(K12<>\"\",N12*L12/M12,\"\")","v":10485.849056603773},"x"]
[null,3,null,null,null,"",null,null,null,3,"3\" CH (x2)",0.49399999999999999,1.5,45000,14820,"x"]
[null,4,null,null,null,"",null,null,null,4,"2\" Tube",0.85,1,45000,38250,"x"]
[null,5,null,null,null,"",null,null,null,5,"2\" CH (x4)",0.91400000000000003,1,45000,41130,"x"]
[null,6,null,null,null,"",null,null,null,6,null,null,null,null,""]
[null,7,null,null,null,"",null,null,null,7,null,null,null,null,""]
[null,8,null,null,null,"",null,null,null,8,null,null,null,null,""]
[null,9,null,null,null,"",null,null,null,9,null,null,null,null,""]
[null,10,null,null,null,"",null,null,null,10,null,null,null,null,""]
[null,11,null,null,null,"",null,null,null,11,null,null,null,null,""]
[null,12,null,null,null,"",null,null,null,12,null,null,null,null,""]
[null,13,null,null,null,"",null,null,null,13,null,null,null,null,""]
[null,14,null,null,null,"",null,null,null,14,null,null,null,null,""]
[null,15,null,null,null,"",null,null,null,15,null,null,null,null,""]
[null,16,null,null,null,"",null,null,null,16,null,null,null,null,""]
[null,17,null,null,null,"",null,null,null,17,null,null,null,null,""]
[null,18,null,null,null,"",null,null,null,18,null,null,null,null,""]
[null,19,null,null,null,"",null,null,null,19,null,null,null,null,""]
[null,20,null,null,null,"",null,null,null,20,null,null,null,null,""]

{"sheet":"Catia","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Type","X1","Y1","Z1","X2","Y2","Z2","Name"]
["Rod",606.90930000000003,-79.787289999999999,243.42179999999999,640.79930000000002,-79.787289999999999,243.42179999999999,"Rod 1"]
["Rod",600.79999999999995,-71,221.92,620.79999999999995,-71,221.92,"Rod 2"]
["Rod",600.79999999999995,-87.45,221.92,620.79999999999995,-87.45,221.92,"Rod 3"]
["Rod",613.20000000000005,-71,201.92,633.20000000000005,-71,201.92,"Rod 4"]
["Rod",613.20000000000005,-87.45,201.92,633.20000000000005,-87.45,201.92,"Rod 5"]
["Rod",618.47,-78.900000000000006,256.2,638.47,-78.900000000000006,256.2,"Rod 6"]
["Rod",629.67999999999995,-68.599999999999994,267.87,638.46999999999991,-68.599999999999994,267.87,"Rod 7"]
["Rod",620.79999999999995,-79.224999999999994,221.92,640.79999999999995,-79.224999999999994,221.92,"Rod 8"]
["Rod",633.20000000000005,-79.224999999999994,201.92,653.20000000000005,-79.224999999999994,201.92,"Rod 9"]
["Rod",638.47,-76.360273972602741,259.07753424657534,653.20000000000005,-76.360273972602741,259.07753424657534,"Rod 10"]
["Rod",640.79930000000002,-79.506145000000004,232.67089999999999,670.79930000000002,-79.506145000000004,232.67089999999999,"Rod 11"]
["Rod",653.20000000000005,-78.2872197309417,220.63076233183855,670.80000000000007,-78.2872197309417,220.63076233183855,"Rod 12"]
["Rod",670.79930000000002,-78.986412045889097,227.53715105162522,690.79930000000002,-78.986412045889097,227.53715105162522,"Rod 13"]
["Beam",620.79999999999995,-71,221.92,620.79999999999995,-87.45,221.92,"Beam 8"]
["Beam",633.20000000000005,-71,201.92,633.20000000000005,-87.45,201.92,"Beam 9"]
["Beam",638.47,-78.900000000000006,256.2,638.46999999999991,-68.599999999999994,267.87,"Beam 10"]
["Beam",640.79930000000002,-79.787289999999999,243.42179999999999,640.79999999999995,-79.224999999999994,221.92,"Beam 11"]
["Beam",653.20000000000005,-79.224999999999994,201.92,653.20000000000005,-76.360273972602741,259.07753424657534,"Beam 12"]
["Beam",670.79930000000002,-79.506145000000004,232.67089999999999,670.80000000000007,-78.2872197309417,220.63076233183855,"Beam 13"]

{"sheet":"data","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["9F"]

{"sheet":"Help","index":4,"n_rows":673,"n_cols":14,"rows_kept":673,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"1. Input Data"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"ID:",null,null,"Any strings. (Leave it blank if you don't need whiffletree ID.)"]
[null,null,null,null,null,"This will be used to show each whiffletree ID."]
[]
[null,null,"Number of Loading Point:",null,null,"Whole number only."]
[null,null,null,null,null,"Enter number of items (lowest level of loading points)."]
[]
[null,null,"Loading Direction:",null,null,"Select loading direction from X, Y, and Z."]
[]
[null,null,"Warning Length:",null,null,"Any numbers."]
[null,null,null,null,null,"Warning message will appear if whiffletree length (either side) becomes less than specified value."]
[]
[null,null,"Factors:",null,null,"Any numbers separated by \"*\"."]
[null,null,null,null,null,"This will be a factor to be multiplied into the weight when making whiffletree."]
[null,null,null,null,null,"You can input more than one factor separated by \"*\"."]
[null,null,null,null,null,"For example, entering \"2\" means output load will be weight x 2."]
[null,null,null,null,null,"For example, entering \"2*1.15\" (literally means 2 times 1.15) means output load will be weight x 2 x 1.15."]
[null,null,null,null,null,"You can enter as many factors as you want separated by \"*\"."]
[null,null,null,null,null,"The above example shows 3 x 1.15 x 1.1 (which gives you overall factor 3.795)."]
[]
[null,null,"Space:",null,null,"Select space from 3, 4, and 5."]
[null,null,null,null,null,"This is an initial space of items shown in whiffletree diagram."]
[]
[null,null,"Input Dialog:",null,null,"Select either \"Up-left\" or \"Center\"."]
[null,null,null,null,null,"This is a location of Input Dialog box when making whiffletree."]
[null,null,null,null,null,"Recommended value is \"Up-left\"."]
[]
[null,null,"Catia Scale:",null,null,"Any numbers."]
[null,null,null,null,null,"The value is used to scale the dimensions when output to Catia."]
[]
[null,null,"Unit L:",null,null,"Any strings."]
[null,null,null,null,null,"Specified unit will appear in whiffletree diagram for length."]
[]
[null,null,"Unit W:",null,null,"Any strings."]
[null,null,null,null,null,"Specified unit will appear in whiffletree diagram for weight."]
[]
[null,null,"Decimal L:",null,null,"Select one from 0, 1, 2, and 3."]
[null,null,null,null,null,"This will be a significant digit for length shown in whiffletree diagram."]
[]
[null,null,"Decimal W:",null,null,"Select one from 0, 1, 2, and 3."]
[null,null,null,null,null,"This will be a significant digit for weight shown in whiffletree diagram."]
[]
[]
[null,"2. Making Whiffletree"]
[]
[null,null,"You will be using the following buttons."]
[]
[]
[]
[]
[null,null,"1. Enter items, weight, and locations."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"You need to fill out yellow cells only."]
[]
[null,null,null,"ID:","Must start from 1 and increased by 1."]
[null,null,null,null,"The last ID should be equal to \"Number of Loading Point\" in the top input field."]
[]
[null,null,null,"Name:","Enter description of items."]
[]
[null,null,null,"Weight:","Enter weight of items."]
[]
[null,null,null,"X, Y, Z:","Enter location of items."]
[null,null,null,null,"Dimensions same as \"Loading Direction\" in the top input field may not be left blank."]
[]
[]
[null,null,"2. Click \"Start/Start over\""]
[]
[]
[]
[null,null,null,"You will see the first level of whiffletree is drawn as well as \"Load\" in the table."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3. Click \"Whiffletree\" or \"Multi-Whiffletree\""]
[]
[]
[]
[]
[null,null,null,"\"Whiffletree\" is just to make one whiffletree connection."]
[null,null,null,"\"Multi-Whiffletree\" is to repeat \"Whiffletree\" until all whiffletrees are complete or use cancel it without clicking \"Whiffletree\" for each connection."]
[]
[null,null,null,"In the dialog box, enter the first ID. In this example, we will connect ID=2 and ID=3."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Then, enter the second ID."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Table and Whiffletree Diagram will be updated."]
[null,null,null,"You see new ID=8."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4. Repeat the same process until all whiffletrees are connected."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"5. Once all whiffletrees are connected, you will be asked if you want to complete the whiffletree."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Clicking \"Yes\" finalize the whiffletree."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"If you click \"No\", then you can do the same thing later by clicking \"Finish/Update\"."]
[]
[null,null,"6. You can modify the whiffletree."]
[]
[null,null,null,"After completing whiffletree, you can change the followings:",null,null,null,null,null,"Weight"]
[null,null,null,null,null,null,null,null,null,"X"]
[null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,"Z"]
[null,null,null,null,null,null,null,null,null,"Factors"]
[]
[null,null,null,"In this example, we modify the Structure weight (ID=1) from 250.00 to 300.00."]
[null,null,null,"Once you change it, click \"Modify\"."]
[]
[]
[]
[]
[null,null,null,"Program automatically asks you if you want to update the Whiffletree (Click \"Yes\" is recommended.)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Then, Table and Whiffletree Diagram will be updated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Clear and Clear All"]
[]
[]
[]
[]
[null,null,"1. \"Clear\" means you clear everything except for initial loading items."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"First-level items will not be cleared."]
[]
[]
[null,null,"2. \"Clear All\" means everything will be erased. (Confirmation dialog will appear.)"]
[]
[]
[null,null,null,null,null,null,"Everything (except for top input field) will be cleared."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"4. Using ID"]
[]
[null,null,"The \"ID\" button toggles ID on and off on the whiffletree diagram."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This ID will be used."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"ID will appear."]
[]
[]
[null,"5. Using Material Function"]
[]
[]
[]
[]
[null,null,"1. Enter material data first. Click \"Data\" to go to material data entry page."]
[]
[]
[]
[]
[null,null,null,"Data entry page:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Entering \"D\" and \"F_max\" will calculate P_max.",null,null,null,null,null,"Entering \"Iyy\", \"c\", and \"F_max\" will calculate M_max."]
[null,null,null,null,"Choose \"x\" if the material is available.",null,null,null,null,null,"Choose \"x\" if the material is available."]
[]
[]
[null,null,"2. Click \"Material\" and available rod and beam will be displayed in whiffletree diagram."]
[]
[]
[]
[]
[null,null,null,"Material will be chosen for rod and beam from weakest material to the strongest material."]
[null,null,null,"If no \"x\" mark is chosen for a particular material in data, the material will not be used and never appear in the whiffletree diagram."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"If there is no material that meets strength requirement, it will be displayed like this:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Material will be displayed."]
[]
[null,null,"3. Check load and bending moment."]
[]
[]
[]
[]
[null,null,null,"When \"Material\" is toggled, you see \"MT\" button (usually the button appears as \"Data\")."]
[]
[null,null,null,"\"MT\" means moment or bending moment in whiffletree beam."]
[]
[null,null,null,"Clicking \"MT\" will show load and bending moment in the diagram."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Bending moment in the beam."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Once clicking \"MT\" button, the button becomes back to \"Data\" button."]
[]
[]
[null,"6. Export to Catia"]
[]
[]
[]
[]
[null,null,"1. Enter Rod"]
[]
[null,null,null,"Click Rod to change the whiffletree diagram to edit mode."]
[]
[]
[]
[]
[null,null,null,"Rod length appear in reds as well as X (or Y or Z, depending on the selected loading direction) appear in blue."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2. Enter rod length in the very first level."]
[]
[null,null,null,"A. Directly enter rod length (without units) in the diagram."]
[null,null,null,"B. Enter rod length so that X dimensions are the same between the connected rods. (Don't enter X values, see the next step.)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Enter rod length directly in the diagram."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"8.79 = 618.47 + 20 - 629.68"]
[]
[null,null,"3. Click \"Edit/Update Tree\""]
[]
[]
[]
[]
[null,null,null,"Diagram will be updated with new X dimensions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4. Repeat it for the 2nd level, 3rd level, and so on."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"5. Click \"Check\" when all rods length up to the highest level are complete."]
[]
[]
[]
[]
[null,null,null,"If everything is good, then, you will see the following diagram and Catia button will be activated."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Otherwise, you will see such a message. Check the rod length."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"6. Open \"Catia Part\" in Catia."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"7. Click Catia."]
[]
[]
[]
[]
[null,null,"8. Whiffletree geometry data is created in the Catia Part by points and lines."]