{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Reference","Inventory","Robot Notes","CAW"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Reference","index":0,"n_rows":64,"n_cols":19,"rows_kept":64,"cut":false,"hidden":false,"merged":[[9,2,9,3],[7,6,7,7],[7,2,7,3],[6,6,6,7],[4,8,4,9],[3,10,3,11],[3,12,3,13],[5,14,5,15],[6,14,6,15],[7,14,7,15],[8,14,8,15],[3,2,3,3],[6,2,6,3],[4,2,4,3],[5,2,5,3],[10,2,10,3],[9,14,9,15],[10,17,10,18],[12,4,12,5],[11,8,11,9],[10,6,10,7],[11,2,11,3],[12,2,12,3],[16,2,16,3],[2,2,2,3],[13,2,13,3],[60,2,60,3],[59,2,59,3],[18,2,18,3],[17,2,17,3],[26,2,26,3],[31,2,31,3],[61,2,61,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[58,2,58,3],[27,12,27,13],[33,12,33,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[19,12,19,13],[9,12,9,13],[13,12,13,13],[23,12,23,13],[48,12,48,13],[49,12,49,13],[53,12,53,13],[44,12,44,13],[1,6,1,7],[1,8,1,9],[0,0,0,1],[0,2,0,3],[0,4,0,13],[0,14,0,15],[1,4,1,5],[1,2,1,3],[1,14,1,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[22,14,22,15],[3,14,3,15],[4,14,4,15],[17,14,17,15],[18,14,18,15],[2,14,2,15],[27,14,27,15],[26,14,26,15],[8,2,8,3],[8,8,8,9],[13,4,13,5],[13,6,13,7],[13,14,13,15],[14,10,14,11],[14,2,14,3],[14,6,14,7],[15,2,15,3],[15,14,15,15],[38,12,38,13],[39,12,39,13],[1,12,1,13],[1,10,1,11],[2,12,2,13],[2,10,2,11],[18,6,18,7],[19,4,19,5],[9,8,9,9],[10,8,10,9],[17,6,17,7],[2,6,2,7],[26,4,26,5],[25,4,25,5],[28,4,28,5],[24,6,24,7],[25,17,25,18],[22,17,22,18],[6,17,6,18],[2,17,2,18],[14,17,14,18],[0,17,0,18],[1,17,1,18],[28,17,28,18],[18,17,18,18]]}
["Electrical",null,"Pneumatics",null,"Motion",{"$nulls":9},"Hardware",null,"Framing","Fasteners"]
["Motors","Control System","Compressor",null,"Gears",null,"Sprockets & Chain",null,"Belts & Pulleys",null,"Transmission",null,"Wheels",null,"Hubs",null,"VersaFrame","Bolts"]
[{"$f":"HYPERLINK(\"Electrical\\Motors\\CIM.pdf\",\"CIM\")","v":"CIM"},"Battery","Drawing",null,{"$f":"HYPERLINK(\"Motion\\Gears\\CIM%20Gears.pdf\",\"CIM\")","v":"CIM"},"11,12,13,14","#35 Sprockets",null,"HTD","5mm","Calculators",null,"Traction",null,".5\" Hex Vex Pro",null,"Tubing","4-40"]
["Shaft: 8mm, 2mm Keyway","12V","User Manual",null,"775Pro 32 DP",12.0,{"$f":"HYPERLINK(\"Motion\\Sprockets\\#35 Hub.pdf\",\"Hub\")","v":"Hub"},"12,15","Width","9, 15 mm","Motors",null,"Stealth Wheels",null,".5\" Hex AM Full",null,"1 x 1 x .04    (Holes 4 Sides)","Diameter","0.112"]
["Free RPM: 5330","17 Amp Hour","AM Information",null,{"$f":"HYPERLINK(\"Motion\\Gears\\.5%20Hex%20Gears.pdf\",\".5\"\" Hex\")","v":".5\" Hex"},"18,20,24,30,34,",{"$f":"HYPERLINK(\"Motion\\Sprockets\\#35 Double Sprocket Hub.pdf\",\"Double + Hub\")","v":"Double + Hub"},"12,15","Pulleys",null,"CIM",0.0,"Diameter","2\" or 4\" ",".5\" Hex AM Lightened",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\Tubing%201%20x%201%20x%20.1.pdf\",\"1 x 1 x .10     (Holes 2 Sides)\")","v":"1 x 1 x .10     (Holes 2 Sides)"},"Hole Drill Size","1 / 8"]
["Free A: 2.7","13.8 Pounds","2.11\" x 5.94\" x 4.53\"",null,null,"36,40,42,44,50,",{"$f":"HYPERLINK(\"Motion\\Sprockets\\#35 Plate.pdf\",\"Plate\")","v":"Plate"},"22,24,26,28,30,",{"$f":"HYPERLINK(\"Motion\\Pulleys\\HTD%20Timing%20Pulley.pdf\",\"Hub\")","v":"Hub"},"18,24,30,36","Mini CIM",0.0,"Bore",".5\", .375\", 8mm",".375\" Hex AM",null,"1 x 2 x .10    (Holes Short Sides)","Tap Drill Size","3 / 32"]
["Stall A: 131","3\" x 7.1\" x 6.6\"","2.4 Pounds Weight",null,null,"54,60,64,72,84","32,33,36,42,44,48,54,60  .",null,"Versa",{"$f":"HYPERLINK(\"Motion\\Pulleys\\VersaPulley%2042t.pdf\",\"42\")","v":"42"},"2 CIM 1 MiniCIM",0.0,"Durometer","50A, 60A, 77A ","Snowblower",null,"Holes Spaceing =  1\"","6-32"]
["Stall in-lbs: 21.33","roboRIO","Required Components",null,{"$f":"HYPERLINK(\"Motion\\Gears\\.5%20Hex%20Gears%20Versa.pdf\",\".5\"\" Hex Versa\")","v":".5\" Hex Versa"},"48,50,54,60,64","#35 Chain",null,null,{"$f":"HYPERLINK(\"Motion\\Pulleys\\VersaPulley%2060t.pdf\",\"60\")","v":"60"},"1 CIM 2 MiniCIM",0.0,"C of Friction","1.14, 0.87, 0.92","10mm 4mm Keyway",null,"Hole Diameter = .163\"","Diameter",0.138]
["Weight: 2.8","5.637\" x 5.754\" x 1.355\"","Pressure Relief Valve",null,null,"66,70,72,84","Height:",".358\"","Belts",null,"Bag",0.0,"Thickness","1\"","8mm 2mm Keyway",null,"Brackets","Hole Drill Size","5 / 32"]
[{"$f":"HYPERLINK(\"Electrical/Motors/Mini%20CIM.pdf\",\"Mini CIM\")","v":"Mini CIM"},{"$f":"HYPERLINK(\"Electrical\\Control%20System\\roboRIO%20Overview.pdf\",\"Overview\")","v":"Overview"},"Pressure Switch",null,".375\" Hex 32 DP","20,40,60,80","Width:",".463\"","60,70,80,90,100,104,110,120,130,140,",null,"775Pro",0.0,"BaneBots Wheels",null,"Collars",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\30%20Degree.pdf\",\"30 Degree\")","v":"30 Degree"},"Tap Drill Size","7 / 64"]
["Shaft: 8mm, 2mm Keyway",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\roboRIO%20User%20Manual.pdf\",\"User Manual\")","v":"User Manual"},"Pressure Vent Plug",null,{"$f":"HYPERLINK(\"Motion\\Gears\\.375%20Hex%20Gears.pdf\",\".375\"\" Hex 20 DP\")","v":".375\" Hex 20 DP"},"14,18,20,24,30,","#25 Sprockets",null,"150,160,170,180,190,200,225,250",null,"Snowblower",0.0,"Diameter",null,{"$f":"HYPERLINK(\"Hardware\\Collars\\Vex%20Pro%20Collars.pdf\",\"Vex Pro\")","v":"Vex Pro"},".25\" Thick",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\45%20Degree.pdf\",\"45 Degree\")","v":"45 Degree"},"8-32"]
["Free RPM: 5840",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\120%20Amp%20Breaker.pdf\",\"120 Amp Breaker\")","v":"120 Amp Breaker"},"Pressure Gauge",null,null,"34,36,40,42,50",{"$f":"HYPERLINK(\"Motion\\Sprockets\\#25 Hub.pdf\",\"Hub\")","v":"Hub"},"16,18,22","Calculators",null,"AM 9015",0.0,"Bore",".5\" Hex",{"$f":"HYPERLINK(\"Hardware\\Collars\\.5%20Hex%20AndyMark.pdf\",\"AM .5\"\" Hex\")","v":"AM .5\" Hex"},".30\" Thick",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\60%20Degree.pdf\",\"60 Degree\")","v":"60 Degree"},"Diameter",0.164]
["Free A: 3","2.9\" x 1.9\" x 1.5\"","Pressure Regulator",null,"Calculators",null,{"$f":"HYPERLINK(\"Motion\\Sprockets\\#25 Plate.pdf\",\"Plate\")","v":"Plate"},"32,34,36,38,40,","Tooth Pitch",5.0,"RS 775",0.0,"Thickness",null,"AM .375\" Hex",".30\" Thick",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\90%20Degree.pdf\",\"90 Degree\")","v":"90 Degree"},"Hole Drill Size","11 / 64"]
["Stall A: 89",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\PDP.pdf\",\"Power Distribution Panel\")","v":"Power Distribution Panel"},"Clippard Tank",null,"Gear 1",null,"42,44,48,54,58,60,64,66,72  .",null,"Pulley 1 Teeth",18.0,"Total Motors",{"$f":"L5+L6+L7+L8+L9+L10+L11+L12+L13","v":0},"Colson",null,"Couplers",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\120%20Degree.pdf\",\"120 Degree\")","v":"120 Degree"},"Tap Drill Size","9 / 64"]
["Stall in-lbs: 12.4","7.586\" x 4.759\" x 1.423\"","35 Cubic Inches Air",null,"Diametral Pitch",0.0,"#25 Chain",null,"Pulley 2 Teeth",18.0,"Reductions",null,"Diameter x Thickness",null,{"$f":"HYPERLINK(\"Hardware\\Couplers\\.5%20Hex%20Coupler.pdf\",\".5\"\" Hex - .5\"\" Hex\")","v":".5\" Hex - .5\" Hex"},"1.5\" Long",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\135%20Degree.pdf\",\"135 Degree\")","v":"135 Degree"},"10-32 & 10-24"]
["Weight: 2.16","8 40A","2.5\" to 2.75\" Diameter x 12.25\"",null,"Tooth Count",0.0,"Height:",".232\"","Teeth on belt","Center Distance",1.0,1.0,"1.625x0.875, 2.5x1.25, 3x0.875, ",null,"Spacers",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\150%20Degree.pdf\",\"150 Degree\")","v":"150 Degree"},"Diameter",0.19]
[{"$f":"HYPERLINK(\"Electrical/Motors/Bag.pdf\",\"Bag\")","v":"Bag"},"8 20A-30A","0.64 Pounds Weight",null,"Outer Diameter",{"$f":"(F16+2)/F15","v":"#DIV/0!"},"Width:",".354\"",60.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I17-Reference!$J$14-Reference!$J$15+SQRT((2*I17-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":4.134},1.0,1.0,"3x1.5, 3.5x1.25, 4x0.875, 4x1.5, 4x2",null,{"$f":"HYPERLINK(\"Hardware\\Spacers\\Spacers.pdf\",\"Vex Pro Hex\")","v":"Vex Pro Hex"},".5\" and .375\"",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\T%20Long.pdf\",\"T Long\")","v":"T Long"},"Hole Drill Size","3 / 16"]
["Shaft: 4mm",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Voltage%20Regulator%20Module.pdf\",\"Voltage Regulator Module\")","v":"Voltage Regulator Module"},"Calculators",null,"Pitch Diameter",{"$f":"F16/F15","v":"#DIV/0!"},"Calculators",null,70.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I18-Reference!$J$14-Reference!$J$15+SQRT((2*I18-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":5.119},1.0,1.0,"Bore",".5\" Hex",".0625, .125, .25, .5, 1, 2",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\T%20Short.pdf\",\"T Short\")","v":"T Short"},"Tap Drill Size","5 / 32"]
["Free RPM: 13,180","2.22\" x 2.03\" x .784\"","Power",null,"Pitch Radius",{"$f":"F18/2","v":"#DIV/0!"},"Number of Whole Links ",null,80.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I19-Reference!$J$14-Reference!$J$15+SQRT((2*I19-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":6.103},1.0,1.0,"C of Friction",1.0,"Bearings",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\+%20Gusset.pdf\",\"Plus Gusset\")","v":"Plus Gusset"},".25-20"]
["Free A: 1.8","2 5V 500mA","Cylinder Bore",0.0,"Gear 2",null,"Chain Pitch",0.375,90.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I20-Reference!$J$14-Reference!$J$15+SQRT((2*I20-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":7.087},1.0,1.0,"Vex Pro Traction Wheels",null,".5\" Hex",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\Corner%20Gusset.pdf\",\"Corner Gusset\")","v":"Corner Gusset"},"Diameter",0.25]
["Stall A: 53","2 5V 2A","Rod Diameter",0.0,"Diametral Pitch",0.0,"Sprocket #1 Teeth",12.0,100.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I21-Reference!$J$14-Reference!$J$15+SQRT((2*I21-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":8.071},1.0,1.0,"Diameter","6\"",".375\" Hex",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\Bearing%20End.pdf\",\"Bearing End\")","v":"Bearing End"},"Hole Drill Size","1 / 4"]
["Stall in-lbs: 3.5","2 12V 500mA","# of Cylinders",0.0,"Tooth Count",0.0,"Sprocket #2 Teeth",12.0,104.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I22-Reference!$J$14-Reference!$J$15+SQRT((2*I22-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":8.465},1.0,1.0,"Bore","1.125\" & Versa","Shaft",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\Bearing%20Side.pdf\",\"Bearing Side\")","v":"Bearing Side"},"Tap Drill Size","13 / 64"]
["Weight: 0.71","2 12V 2A","Distance From Perpendicular  ",null,"Outer Diameter",{"$f":"(F22+2)/F21","v":"#DIV/0!"},"Center Distance (Inches)",12.0,110.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I23-Reference!$J$14-Reference!$J$15+SQRT((2*I23-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":9.056},1.0,1.0,"Thickness","1\", 1.5\", 2\"","Thunderhex .5\" Hex Shaft",null,{"$f":"HYPERLINK(\"Framing\\VersaFrame\\VersaPlanetary%20Face%20Mount.pdf\",\"VersaPlanetary Face Mount\")","v":"VersaPlanetary Face Mount"},"M4"]
[{"$f":"HYPERLINK(\"Electrical\\Motors\\775pro.pdf\",\"775Pro\")","v":"775Pro"},{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Pneumatic%20Control%20Module.pdf\",\"Pneumatic Control Module\")","v":"Pneumatic Control Module"},"to Cylinder to Pivot",null,"Pitch Diameter",{"$f":"F22/F21","v":"#DIV/0!"},"Result: Number Whole Links",{"$f":"SUM(2*H23/H20+H21/2+H22/2+((H21-H22)/(2*3.14159))^2/(H23/H20))","v":76},120.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I24-Reference!$J$14-Reference!$J$15+SQRT((2*I24-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":10.04},"Mechanism Path Diameter (in)",null,"AM High Grip Wheels",null,".201\" Hole","1 / 4\" - 20 Tap",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\VersaPlanetary%20Side%201%20Inch.pdf\",\"VersaPlanetary Side Mount 1\"\"\")","v":"VersaPlanetary Side Mount 1\""},"Diameter",4.0]
["Shaft: 5mm","2.72\" x 2.24\" x .774\"",0.0,null,"Pitch Radius",{"$f":"F24/2","v":"#DIV/0!"},"Center to Center Distance",null,130.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I25-Reference!$J$14-Reference!$J$15+SQRT((2*I25-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":11.024},"(Wheel etc.)",0.0,"Diameter","6\"",".5\" Hex Shaft",".5774\" Across",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\VersaPlanetary%20Side%202%20Inch.pdf\",\"VersaPlanetary Side Mount 2\"\"\")","v":"VersaPlanetary Side Mount 2\""},"Hole Drill Size","3 / 16"]
["Free RPM: 18,730","8 Solenoid Outputs","Mechanism Path Diameter (in)",null,"Center Distance",null,"Chain Pitch",0.375,140.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I26-Reference!$J$14-Reference!$J$15+SQRT((2*I26-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":12.008},"RPM",{"$f":"(L5/L14*5330 + L6/L14*5840 + L7/L14*5437 + L9/L14*13180 + L10/L14*18730 + L11/L14*100 + L12/L14*16000 + L13/L14*5700 + L8/L14*5593)*(K16/L16)*(K17/L17)*(K18/L18)*(K19/L19)*(K20/L20)*(K21/L21)*(K22/L22)*(K23/L23)","v":"#DIV/0!"},"Bore","1.125\" & Hub",".375\" Hex Shaft",".4330\" Across",{"$f":"HYPERLINK(\"Framing\\VersaFrame\\VersaPlanetary%20Side%20Mount.pdf\",\"VersaPlanetary Side Mount\")","v":"VersaPlanetary Side Mount"},"M5"]
["Free A: 0.7","1 Pressure Switch Input",0.0,null,{"$f":"F19+F25","v":"#DIV/0!"},null,"Sprocket #1 Teeth",12.0,150.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I27-Reference!$J$14-Reference!$J$15+SQRT((2*I27-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":12.993},"RPS",{"$f":"L26/60","v":"#DIV/0!"},"Thickness","1\"","All Shaft 7075",null,null,"Diameter",5.0]
["Stall A: 134","1 Compressor Output","Force / Cylinder",null,".003 Center Add",{"$f":"E27+0.003","v":"#DIV/0!"},"Sprocket #2 Teeth",12.0,160.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I28-Reference!$J$14-Reference!$J$15+SQRT((2*I28-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":13.977},"Feet / Second",{"$f":"L29/12","v":"#DIV/0!"},"AM Rubber Treaded Wheel",null,"Adapters",null,null,"Hole Drill Size","7 / 32"]
["Stall in-lbs: 6.28",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Talon%20SR.pdf\",\"Talon SR\")","v":"Talon SR"},"Force Total",null,"Will Gear 1 & 4 Hit?",null,"Links",61.0,170.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I29-Reference!$J$14-Reference!$J$15+SQRT((2*I29-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":14.961},"Inches / Second",{"$f":"L27*3.141592654*L25","v":"#DIV/0!"},"Diameter","8\"",{"$f":"HYPERLINK(\"Hardware\\Adapters\\8mm%20to%20.5%20Hex.pdf\",\"8mm to .5\"\" Hex\")","v":"8mm to .5\" Hex"},"1\" Long",null,"Bolt Sizes"]
["Weight: 0.8","2.73\" x 1.90\" x 1.15\"","Torque in / lbs",null,"Gear 1 DP",0.0,"Result: Center Distance (Inches)",{"$f":"SUM(H26/8) * (2*H29-H27-H28 + SQRT((2*H29-H27-H28)^2-(8/3.14159^2)*((H27-H28)^2)) )","v":9.1875},180.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I30-Reference!$J$14-Reference!$J$15+SQRT((2*I30-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":15.945},"Drive Adjusted",{"$f":"L28*0.81","v":"#DIV/0!"},"Bore","1.125\" & Hub",null,null,null,"CIM","10-32"]
[{"$f":"HYPERLINK(\"Electrical/Motors/AndyMark%209015.pdf\",\"AndyMark 9015\")","v":"AndyMark 9015"},"PWM","Pounds @ Path",null,"Gear 1 Tooth",0.0,null,null,190.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I31-Reference!$J$14-Reference!$J$15+SQRT((2*I31-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":16.93},"Stall in / lbs",{"$f":"(L5*21.33 + L6*12.4 + L7*6.23 + L8*5.23 + L9*3.5 + L10*6.28 + L11*70 + L12*3.79 + L13*2.1875)/(K16/L16)*(K17/L17)*(K18/L18)*(K19/L19)*(K20/L20)*(K21/L21)*(K22/L22)","v":0},"Thickness","1\"",null,null,null,"Mini CIM","10-32"]
["Shaft: .125\"","Talon SRX","Air Usage",null,"Gear 2 DP",0.0,null,null,200.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I32-Reference!$J$14-Reference!$J$15+SQRT((2*I32-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":17.914},"Pounds @ Path",{"$f":"L31/L25","v":"#DIV/0!"},"Durometer","65A",null,null,null,"Bag","M4-6H"]
["Free RPM: 16,000","2.75\" x 1.185\" x 0.96\"","Cylinder Bore",0.0,"Gear 2 Tooth",0.0,null,null,225.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I33-Reference!$J$14-Reference!$J$15+SQRT((2*I33-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":20.375},"Free Current",{"$f":"(L5*2.7 + L6*3 + L7*8.4 + L8*8.7 + L9*1.8 + L10*0.7 + L11*5 + L12*1.2 + L13*0)","v":0},"C of Friction",1.0,null,null,null,"775Pro","M4-6H"]
["Free A: 1.2",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Talon%20SRX.pdf\",\"Drawing\")","v":"Drawing"},"Stroke",0.0,"Gear 3 DP",0.0,null,null,250.0,{"$f":"ROUNDUP(SUM(Reference!$J$13/8)*(2*I34-Reference!$J$14-Reference!$J$15+SQRT((2*I34-Reference!$J$14-Reference!$J$15)^2-(8/3.14159^2)*((Reference!$J$14-Reference!$J$15)^2)))/25.4,3)","v":22.835},"Stall Current",{"$f":"(L5*131 + L6*89 + L7*351 + L8*309 + L9*53 + L10*134 + L11*24 + L12*63.8 + L13*22)","v":0},"Pneumatic",{"$nulls":4},"Snowblower","M5x0.8"]
["Stall A: 63.8",{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Talon%20SRX%20User%20Guide.pdf\",\"User Guide\")","v":"User Guide"},"# of Uses",0.0,"Gear 3 Tooth",0.0,{"$nulls":6},"Diameter","7.65\"",null,null,null,"roboRIO","4-40"]
["Stall in-lbs: 3.79","PWM","# of Cylinders",0.0,"Gear 4 DP",0.0,{"$nulls":6},"Bore","1.125\" & Hub",null,null,null,"120 A Breaker","1 / 4\""]
["Weight: 0.5","CAN","Cylinder Bore",0.0,"Gear 4 Tooth",0.0,{"$nulls":6},"Thickness","2\"",null,null,null,"PDP","10-32 or 10-24"]
[{"$f":"HYPERLINK(\"Electrical/Motors/Snowblower.pdf\",\"Snowblower\")","v":"Snowblower"},{"$f":"HYPERLINK(\"Electrical\\Control%20System\\Victor%20SP.pdf\",\"Victor SP\")","v":"Victor SP"},"Stroke",0.0,"Answer",{"$f":"IF(F39>0,\"Yes\",\"No\")","v":"#DIV/0!"},{"$nulls":6},"C of Friction",0.93,null,null,null,"Voltage RM","6-32"]
["Shaft: 10mm With Flats","2.5\" x 1.125\" x 0.875\"","# of Uses",0.0,"Clearance",{"$f":"(((F33/F32)/2+(F35/F34)/2))-(((F31+2)/F30)/2+((F37+2)/F36)/2)","v":"#DIV/0!"},{"$nulls":6},"Omni",{"$nulls":4},"Pneumatic CM","6-32"]
["Free RPM: 100","PWM","# of Cylinders",0.0,"1 & 2 on axle, 3 & 4 on axle",{"$nulls":7},"AM Omni",{"$nulls":4},"Talon SR","6-32"]
["Free A: 5","Radio","Cylinder Bore",0.0,"Mesh Pairs: 0&1, 2&3, 4&5",{"$nulls":7},"Diameter","8\"",null,null,null,"Talon SRX","8-32"]
["Stall A: 24","3.75” x 2.75” x 1”","Stroke",0.0,{"$nulls":8},"Bore","1.125\" & Hub",null,null,null,"Victor SP","8-32"]
["Stall in-lbs: 70","Light","# of Uses",0.0,{"$nulls":8},"Thickness","2\"",null,null,null,"VersaHub","8-32"]
["Weight: 1.11","Dimensions","# of Cylinders",0.0,{"$nulls":8},"Durometer","80A",null,null,null,"AM Hub","10-32 or 10-24"]
["RS775",null,"Cylinder Bore",0.0,{"$nulls":8},"Vex Pro Omni",{"$nulls":4},"ThunderHex","1 / 4\""]
["Shaft: 5mm",null,"Stroke",0.0,{"$nulls":8},"Diameter","3.25\", 4\", 6\", 8\"",null,null,null,"VersaPlanetary","8-32"]
["Free RPM: 5700",null,"# of Uses",0.0,{"$nulls":8},"Bore","1.125\" & Versa",null,null,null,"PG Gearboxes","M4x0.7"]
["Stall A: 22",null,"# of Cylinders",0.0,{"$nulls":8},"Thickness","1.5\"",null,null,null,"Rivets"]
["Stall in-lbs: 2.1875",null,"Cylinder Bore",0.0,{"$nulls":8},"Mecanum",{"$nulls":4},"VersaFrame","5 / 32"]
["Weight: 0.81",null,"Stroke",0.0,{"$nulls":8},"AM Mecanum"]
[null,null,"# of Uses",0.0,{"$nulls":8},"Diameter","8\""]
[null,null,"# of Cylinders",0.0,{"$nulls":8},"Bore","1.125\" & Hub"]
[null,null,"Cylinder Bore",0.0,{"$nulls":8},"Thickness","3\""]
[null,null,"Stroke",0.0,{"$nulls":8},"Vex Pro Mecanum"]
[null,null,"# of Uses",0.0,{"$nulls":8},"Diameter","4\", 6\", 8\""]
[null,null,"# of Cylinders",0.0,{"$nulls":8},"Bore for 4\"",".5\" Hex"]
[null,null,"Compressor?",0.0,{"$nulls":8},"Bore for 6\" & 8\"","1.125\" & Versa"]
[null,null,"Clippard Tanks",0.0,{"$nulls":8},"Thickness","2.25\""]
[null,null,"Air Available Initial"]
[null,null,{"$f":"D58*35","v":0}]
[null,null,"Air Generated During Match"]
[null,null,{"$f":"D57*140","v":0}]
[null,null,"Total Air",{"$f":"D60 + D62+SUM(C62,C60)","v":0}]
[null,null,"Air Used",{"$f":"(3.141592654*((D33/2)^2)*D34*D35*D36) + (3.141592654*((D37/2)^2)*D38*D39*D40) + (3.141592654*((D41/2)^2)*D42*D43*D44) + (3.141592654*((D45/2)^2)*D46*D47*D48) + (3.141592654*((D49/2)^2)*D50*D51*D52) + (3.141592654*((D53/2)^2)*D54*D55*D56)","v":0}]

{"sheet":"Inventory","index":1,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[[39,8,39,9],[44,8,44,9],[38,8,38,9],[33,8,33,9],[15,8,15,9],[16,8,16,9],[49,8,49,9],[53,8,53,9],[19,8,19,9],[23,8,23,9],[48,8,48,9],[19,10,19,11],[20,10,20,11],[9,10,9,11],[8,10,8,11],[7,10,7,11],[15,10,15,11],[13,10,13,11],[3,10,3,11],[4,10,4,11],[17,10,17,11],[5,10,5,11],[25,3,25,4],[26,3,26,4],[28,3,28,4],[13,8,13,9],[14,8,14,9],[14,13,14,14],[9,8,9,9],[2,8,2,9],[3,8,3,9],[27,8,27,9],[13,3,13,4],[19,3,19,4],[12,3,12,4],[22,10,22,11],[21,10,21,11],[18,10,18,11],[27,10,27,11],[18,13,18,14],[22,13,22,14],[25,13,25,14],[28,13,28,14],[26,10,26,11],[6,10,6,11],[6,13,6,14],[10,13,10,14],[0,10,0,11],[1,10,1,11],[1,8,1,9],[0,0,0,1],[0,3,0,9],[1,3,1,4],[0,13,0,14],[1,13,1,14],[2,13,2,14],[2,10,2,11]]}
["Electrical",null,"Pneumatics","Motion",{"$nulls":6},"Hardware",null,"Framing","Fasteners"]
["Motors","Control System",null,"Gears",null,"Sprockets & Chain","Belts & Pulleys","Gearboxes","Wheels",null,null,null,"VersaFrame","Bolts"]

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

{"sheet":"CAW","index":3,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[9,10,9,12],[8,10,8,12],[6,0,6,14],[7,0,7,14]]}
[]
[]
[]
[]
[]
[]
["2016 FIRST Robotics Competition"]
["Bill of Materials"]
["Team Name:",null,null,null,"Team #:",null,null,null,"Date:"]
["Event:",null,null,null,"City:",null,null,null,"State:"]
[]
["Item",null,"Description",null,"Material",null,"Source",null,"Quantity",null,"Measurement",null,"Unit Price",null,"Total Price"]
["Major System Names Here",null,"Describe the Part \n(Axle, Bearing, Lifter, Solenoid)",null,"What is it made from",null,"Where did you buy it\n(Home Depot, AndyMark, Supply House, Etc.)",null,"How Many",null,"Piece, Inch, Etc.",null,"Cost Per Unit ($)"]
["Subsystem 1:"]
[{"$nulls":14},{"$f":"I15*M15","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":12},"Subtotals:",null,{"$f":"SUM(O15:O22)","v":0}]
["Subsystem 2:"]
[{"$nulls":14},{"$f":"I25*M25","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":12},"Subtotals:",null,{"$f":"SUM(O25:O32)","v":0}]
["Subsystem 3:"]
[{"$nulls":14},{"$f":"I35*M35","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":12},"Subtotals:",null,{"$f":"SUM(O35:O42)","v":0}]
["Subsystem 4:"]
[{"$nulls":14},{"$f":"I45*M45","v":0}]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":12},"Subtotals:",null,{"$f":"SUM(O45:O52)","v":0}]
[]
[{"$nulls":12},"Totals:",null,{"$f":"O23+O43+O33+O53","v":0}]