{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ExplodedBOM","FlatBOM","PartSpecs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":1},"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":"ExplodedBOM","index":0,"n_rows":189,"n_cols":10,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["QtyScalar","ParentLine",".","BOM Level","Part","Qty","UOM","Qty_Exploded","Vendor","Phantom"]
[{"$f":"F2","v":1},1,null,0,"(SUPERBOM)",1,"ea",{"$f":"F2*A2","v":1},null,{"$f":"IF(MID(ExplodedBOM!$E2,1,1)=\"(\",TRUE,FALSE)","v":true}]
[{"$f":"IF(MID(E2,1,1)=\"(\",F2*A2,\n      IF(D3<D2,INDIRECT(\"A\" & B3+1),A2)\n)","v":1},{"$f":"SUMPRODUCT(MAX(ROW($2:3)*($D$2:D3=(D3-1))))","v":2},null,1,"(post)",3,"ea",{"$f":"F3*A3","v":3},null,{"$f":"IF(MID(ExplodedBOM!$E3,1,1)=\"(\",TRUE,FALSE)","v":true}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:4)*($D$2:D4=(D4-1))))","v":3},null,2,"2020-800mm",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E4,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:5)*($D$2:D5=(D5-1))))","v":3},null,2,"open_rail-700mm",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E5,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:6)*($D$2:D6=(D6-1))))","v":3},null,2,"scrw_m5_10 (open_rail_kit_excess)",15,"ea",45,null,{"$f":"IF(MID(ExplodedBOM!$E6,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:7)*($D$2:D7=(D7-1))))","v":3},null,2,"nut_extr_m5 (open_rail_kit_excess)",15,"ea",45,null,{"$f":"IF(MID(ExplodedBOM!$E7,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:8)*($D$2:D8=(D8-1))))","v":3},null,2,"rp_base_vertex",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E8,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:9)*($D$2:D9=(D9-1))))","v":3},null,2,"motor_nema_17",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E9,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:10)*($D$2:D10=(D10-1))))","v":3},null,2,"belt_gt2_1700mm",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E10,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:11)*($D$2:D11=(D11-1))))","v":3},null,2,"gear_drive_belt_gt2",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E11,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:12)*($D$2:D12=(D12-1))))","v":3},null,2,"scrw_m3_set",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E12,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:13)*($D$2:D13=(D13-1))))","v":3},null,2,"2020-300mm",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E13,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:14)*($D$2:D14=(D14-1))))","v":3},null,2,"scrw_m4_10",8,"ea",24,null,{"$f":"IF(MID(ExplodedBOM!$E14,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:15)*($D$2:D15=(D15-1))))","v":3},null,2,"wshr_m4",10,"ea",30,null,{"$f":"IF(MID(ExplodedBOM!$E15,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:16)*($D$2:D16=(D16-1))))","v":3},null,2,"nut_extr_m4",10,"ea",30,null,{"$f":"IF(MID(ExplodedBOM!$E16,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:17)*($D$2:D17=(D17-1))))","v":3},null,2,"scrw_m3_12",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E17,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:18)*($D$2:D18=(D18-1))))","v":3},null,2,"wshr_m3",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E18,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:19)*($D$2:D19=(D19-1))))","v":3},null,2,"scrw_m4_12",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E19,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:20)*($D$2:D20=(D20-1))))","v":3},null,2,"(carriage)",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E20,1,1)=\"(\",TRUE,FALSE)","v":true}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:21)*($D$2:D21=(D21-1))))","v":20},null,3,"rp_plate_slider",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E21,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:22)*($D$2:D22=(D22-1))))","v":20},null,3,"open_rail_shim",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E22,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:23)*($D$2:D23=(D23-1))))","v":20},null,3,"open_rail_wheel_delrin",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E23,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:24)*($D$2:D24=(D24-1))))","v":20},null,3,"open_rail_wheel_sst",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E24,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:25)*($D$2:D25=(D25-1))))","v":20},null,3,"open_rail_bearing",8,"ea",24,null,{"$f":"IF(MID(ExplodedBOM!$E25,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:26)*($D$2:D26=(D26-1))))","v":20},null,3,"open_rail_spacer_bearing",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E26,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:27)*($D$2:D27=(D27-1))))","v":20},null,3,"open_rail_shim_eccentric",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E27,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:28)*($D$2:D28=(D28-1))))","v":20},null,3,"open_rail_scrw_m5_std_wheel_mnt",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E28,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:29)*($D$2:D29=(D29-1))))","v":20},null,3,"open_rail_nut_m5",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E29,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:30)*($D$2:D30=(D30-1))))","v":20},null,3,"rp_flag_carriage",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E30,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:31)*($D$2:D31=(D31-1))))","v":20},null,3,"nut_m3_jam",3,"ea",9,null,{"$f":"IF(MID(ExplodedBOM!$E31,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:32)*($D$2:D32=(D32-1))))","v":20},null,3,"wshr_m3",3,"ea",9,null,{"$f":"IF(MID(ExplodedBOM!$E32,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:33)*($D$2:D33=(D33-1))))","v":20},null,3,"nut_m3",3,"ea",9,null,{"$f":"IF(MID(ExplodedBOM!$E33,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:34)*($D$2:D34=(D34-1))))","v":20},null,3,"scrw_m3_20",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E34,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:35)*($D$2:D35=(D35-1))))","v":20},null,3,"rp_ram",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E35,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:36)*($D$2:D36=(D36-1))))","v":2},null,1,"(rods)",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E36,1,1)=\"(\",TRUE,FALSE)","v":true}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:37)*($D$2:D37=(D37-1))))","v":36},null,2,"rod_carbon_330mm",1,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E37,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:38)*($D$2:D38=(D38-1))))","v":36},null,2,"rod_ends",2,"ea",12,"klj",{"$f":"IF(MID(ExplodedBOM!$E38,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:39)*($D$2:D39=(D39-1))))","v":36},null,2,"scrw_m3_15",2,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E39,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:40)*($D$2:D40=(D40-1))))","v":36},null,2,"wshr_m3",4,"ea",24,null,{"$f":"IF(MID(ExplodedBOM!$E40,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:41)*($D$2:D41=(D41-1))))","v":36},null,2,"scrw_m4_set_20",2,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E41,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:42)*($D$2:D42=(D42-1))))","v":2},null,1,"(bed)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E42,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:43)*($D$2:D43=(D43-1))))","v":42},null,2,"pcb_heater",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E43,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:44)*($D$2:D44=(D44-1))))","v":42},null,2,"switch_thermal",1,"ea",1,"150C NC Temperature Switch Ceramic Thermostat KSD301 2 Pcs",{"$f":"IF(MID(ExplodedBOM!$E44,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:45)*($D$2:D45=(D45-1))))","v":42},null,2,"scrw_finish_#6",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E45,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:46)*($D$2:D46=(D46-1))))","v":42},null,2,"bracket_heater_sppt_wood",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E46,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:47)*($D$2:D47=(D47-1))))","v":42},null,2,"bed_glass",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E47,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:48)*($D$2:D48=(D48-1))))","v":42},null,2,"(assy_bed_block)",3,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E48,1,1)=\"(\",TRUE,FALSE)","v":true}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:49)*($D$2:D49=(D49-1))))","v":48},null,3,"scrw_m3_20",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E49,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:50)*($D$2:D50=(D50-1))))","v":48},null,3,"nut_m3",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E50,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:51)*($D$2:D51=(D51-1))))","v":48},null,3,"tab_felt",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E51,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:52)*($D$2:D52=(D52-1))))","v":48},null,3,"rp_block_bed",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E52,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:53)*($D$2:D53=(D53-1))))","v":48},null,3,"scrw_m4_12",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E53,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:54)*($D$2:D54=(D54-1))))","v":48},null,3,"wshr_m4",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E54,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:55)*($D$2:D55=(D55-1))))","v":48},null,3,"nut_extr_m4",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E55,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:56)*($D$2:D56=(D56-1))))","v":42},null,2,"(kit_bed_install)",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E56,1,1)=\"(\",TRUE,FALSE)","v":true}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:57)*($D$2:D57=(D57-1))))","v":56},null,3,"wshr_m4",3,"ea",18,null,{"$f":"IF(MID(ExplodedBOM!$E57,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:58)*($D$2:D58=(D58-1))))","v":56},null,3,"scrw_m4_15",1,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E58,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:59)*($D$2:D59=(D59-1))))","v":56},null,3,"spring_m4",1,"ea",6,"http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461",{"$f":"IF(MID(ExplodedBOM!$E59,1,1)=\"(\",TRUE,FALSE)","v":false}]
[6,{"$f":"SUMPRODUCT(MAX(ROW($2:60)*($D$2:D60=(D60-1))))","v":56},null,3,"nut_extr_m4",1,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E60,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:61)*($D$2:D61=(D61-1))))","v":2},null,1,"(post_top)",3,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E61,1,1)=\"(\",TRUE,FALSE)","v":true}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:62)*($D$2:D62=(D62-1))))","v":61},null,2,"rp_upper_vertex",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E62,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:63)*($D$2:D63=(D63-1))))","v":61},null,2,"2020-371mm",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E63,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:64)*($D$2:D64=(D64-1))))","v":61},null,2,"nut_extr_m4",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E64,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:65)*($D$2:D65=(D65-1))))","v":61},null,2,"scrw_m4_15",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E65,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:66)*($D$2:D66=(D66-1))))","v":61},null,2,"wshr_m4",8,"ea",24,null,{"$f":"IF(MID(ExplodedBOM!$E66,1,1)=\"(\",TRUE,FALSE)","v":false}]
[{"$f":"IF(MID(E66,1,1)=\"(\",F66*A66,\n      IF(D67<D66,INDIRECT(\"A\" & B67+1),A66)\n)","v":3},{"$f":"SUMPRODUCT(MAX(ROW($2:67)*($D$2:D67=(D67-1))))","v":61},null,2,"wshr_m4_fender",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E67,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:68)*($D$2:D68=(D68-1))))","v":61},null,2,"nut_m4",1,"ea",{"$f":"F68*A68","v":3},null,{"$f":"IF(MID(ExplodedBOM!$E68,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:69)*($D$2:D69=(D69-1))))","v":61},null,2,"bearing_624z",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E69,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:70)*($D$2:D70=(D70-1))))","v":61},null,2,"scrw_m4_25",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E70,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:71)*($D$2:D71=(D71-1))))","v":61},null,2,"scrw_m4_12",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E71,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:72)*($D$2:D72=(D72-1))))","v":61},null,2,"(assy_opto)",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E72,1,1)=\"(\",TRUE,FALSE)","v":true}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:73)*($D$2:D73=(D73-1))))","v":72},null,3,"rp_opto_mount",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E73,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:74)*($D$2:D74=(D74-1))))","v":72},null,3,"open_rail_shim",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E74,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:75)*($D$2:D75=(D75-1))))","v":72},null,3,"scrw_m4_15",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E75,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:76)*($D$2:D76=(D76-1))))","v":72},null,3,"nut_extr_m4",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E76,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:77)*($D$2:D77=(D77-1))))","v":72},null,3,"wshr_m4_fender",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E77,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:78)*($D$2:D78=(D78-1))))","v":72},null,3,"wshr_m4",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E78,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:79)*($D$2:D79=(D79-1))))","v":72},null,3,"wshr_m4",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E79,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:80)*($D$2:D80=(D80-1))))","v":72},null,3,"scrw_m3_12",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E80,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:81)*($D$2:D81=(D81-1))))","v":72},null,3,"wshr_m3",4,"ea",12,null,{"$f":"IF(MID(ExplodedBOM!$E81,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:82)*($D$2:D82=(D82-1))))","v":72},null,3,"nut_m3",2,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E82,1,1)=\"(\",TRUE,FALSE)","v":false}]
[3,{"$f":"SUMPRODUCT(MAX(ROW($2:83)*($D$2:D83=(D83-1))))","v":72},null,3,"pcb_opto",1,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E83,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:84)*($D$2:D84=(D84-1))))","v":2},null,1,"(assy_pwr_spply)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E84,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:85)*($D$2:D85=(D85-1))))","v":84},null,2,"power_supply",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E85,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:86)*($D$2:D86=(D86-1))))","v":84},null,2,"rp_bracket_pwr_spply_tab",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E86,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:87)*($D$2:D87=(D87-1))))","v":84},null,2,"bracket_power_supply_stablity_xy",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E87,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:88)*($D$2:D88=(D88-1))))","v":84},null,2,"scrw_m4_10",5,"ea",5,null,{"$f":"IF(MID(ExplodedBOM!$E88,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:89)*($D$2:D89=(D89-1))))","v":84},null,2,"nut_extr_m4",5,"ea",5,null,{"$f":"IF(MID(ExplodedBOM!$E89,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:90)*($D$2:D90=(D90-1))))","v":84},null,2,"wshr_m4",5,"ea",5,null,{"$f":"IF(MID(ExplodedBOM!$E90,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:91)*($D$2:D91=(D91-1))))","v":2},null,1,"(kit_spool_extruder_mount_framing)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E91,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:92)*($D$2:D92=(D92-1))))","v":91},null,2,"bracket_tee_2020",9,"ea",9,null,{"$f":"IF(MID(ExplodedBOM!$E92,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:93)*($D$2:D93=(D93-1))))","v":91},null,2,"nut_extr_m5 (open_rail_kit_excess)",{"$f":"F92*2","v":18},"ea",18,null,{"$f":"IF(MID(ExplodedBOM!$E93,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:94)*($D$2:D94=(D94-1))))","v":91},null,2,"scrw_m5_10 (open_rail_kit_excess)",{"$f":"F92*2","v":18},"ea",18,null,{"$f":"IF(MID(ExplodedBOM!$E94,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:95)*($D$2:D95=(D95-1))))","v":91},null,2,"2020-200mm",3,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E95,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:96)*($D$2:D96=(D96-1))))","v":91},null,2,"2020-300mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E96,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:97)*($D$2:D97=(D97-1))))","v":91},null,2,"2020-50mm",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E97,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:98)*($D$2:D98=(D98-1))))","v":91},null,2,"2020-134mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E98,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:99)*($D$2:D99=(D99-1))))","v":91},null,2,"rp_extruder_join_upper",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E99,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:100)*($D$2:D100=(D100-1))))","v":91},null,2,"rp_extruder_join_lower",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E100,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:101)*($D$2:D101=(D101-1))))","v":91},null,2,"wshr_m4",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E101,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:102)*($D$2:D102=(D102-1))))","v":91},null,2,"scrw_m4_10",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E102,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:103)*($D$2:D103=(D103-1))))","v":2},null,1,"(kit_dual_extruder)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E103,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:104)*($D$2:D104=(D104-1))))","v":103},null,2,"(kit_extruder_hw)",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E104,1,1)=\"(\",TRUE,FALSE)","v":true}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:105)*($D$2:D105=(D105-1))))","v":104},null,3,"nut_extr_m5 (open_rail_kit_excess)",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E105,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:106)*($D$2:D106=(D106-1))))","v":104},null,3,"scrw_m5_10 (open_rail_kit_excess)",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E106,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:107)*($D$2:D107=(D107-1))))","v":104},null,3,"scrw_m3_10",4,"ea",8,null,{"$f":"IF(MID(ExplodedBOM!$E107,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:108)*($D$2:D108=(D108-1))))","v":104},null,3,"nut_m3",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E108,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:109)*($D$2:D109=(D109-1))))","v":104},null,3,"scrw_m3_25",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E109,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:110)*($D$2:D110=(D110-1))))","v":104},null,3,"scrw_m3_35",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E110,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:111)*($D$2:D111=(D111-1))))","v":104},null,3,"bearing_608z",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E111,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:112)*($D$2:D112=(D112-1))))","v":104},null,3,"drive_filament_dia",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E112,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:113)*($D$2:D113=(D113-1))))","v":104},null,3,"scrw_m3_set",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E113,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:114)*($D$2:D114=(D114-1))))","v":104},null,3,"scrw_m3_50",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E114,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:115)*($D$2:D115=(D115-1))))","v":104},null,3,"spring_m3_extruder",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E115,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:116)*($D$2:D116=(D116-1))))","v":104},null,3,"wshr_m3",4,"ea",8,null,{"$f":"IF(MID(ExplodedBOM!$E116,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:117)*($D$2:D117=(D117-1))))","v":104},null,3,"nut_m3_jam",2,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E117,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:118)*($D$2:D118=(D118-1))))","v":104},null,3,"open_rail_nut_m5",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E118,1,1)=\"(\",TRUE,FALSE)","v":false}]
[2,{"$f":"SUMPRODUCT(MAX(ROW($2:119)*($D$2:D119=(D119-1))))","v":104},null,3,"fitting_one_touch_4mm",1,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E119,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:120)*($D$2:D120=(D120-1))))","v":103},null,2,"(kit_extruder_1)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E120,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:121)*($D$2:D121=(D121-1))))","v":120},null,3,"rp_idler",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E121,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:122)*($D$2:D122=(D122-1))))","v":120},null,3,"rp_idler_strut",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E122,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:123)*($D$2:D123=(D123-1))))","v":120},null,3,"rp_idler_boss_bearing_8mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E123,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:124)*($D$2:D124=(D124-1))))","v":120},null,3,"motor_nema_17_geared_5.18_1",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E124,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:125)*($D$2:D125=(D125-1))))","v":120},null,3,"tubing_4mm_bowden_1000mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E125,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:126)*($D$2:D126=(D126-1))))","v":103},null,2,"(kit_extruder_2)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E126,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:127)*($D$2:D127=(D127-1))))","v":126},null,3,"rp_idler_mirrored",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E127,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:128)*($D$2:D128=(D128-1))))","v":126},null,3,"rp_idler_strut",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E128,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:129)*($D$2:D129=(D129-1))))","v":126},null,3,"rp_idler_boss_bearing_8mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E129,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:130)*($D$2:D130=(D130-1))))","v":126},null,3,"motor_nema_17_geared_5.18_1",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E130,1,1)=\"(\",TRUE,FALSE)","v":false}]
[{"$f":"IF(MID(E130,1,1)=\"(\",F130*A130,\n      IF(D131<D130,INDIRECT(\"A\" & B131+1),A130)\n)","v":1},{"$f":"SUMPRODUCT(MAX(ROW($2:131)*($D$2:D131=(D131-1))))","v":126},null,3,"tubing_4mm_bowden_1000mm",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E131,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:132)*($D$2:D132=(D132-1))))","v":2},null,1,"(kit_dual_spool_mount)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E132,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:133)*($D$2:D133=(D133-1))))","v":132},null,2,"rod_threaded_8mm-271mm",1,"ea",{"$f":"F133*A133","v":1},null,{"$f":"IF(MID(ExplodedBOM!$E133,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:134)*($D$2:D134=(D134-1))))","v":132},null,2,"rp_bracket_axle_spool",3,"ea",3,null,{"$f":"IF(MID(ExplodedBOM!$E134,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:135)*($D$2:D135=(D135-1))))","v":132},null,2,"scrw_m4_10",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E135,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:136)*($D$2:D136=(D136-1))))","v":132},null,2,"wshr_m4",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E136,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:137)*($D$2:D137=(D137-1))))","v":132},null,2,"nut_extr_m4",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E137,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:138)*($D$2:D138=(D138-1))))","v":2},null,1,"(assy_end_effector)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E138,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:139)*($D$2:D139=(D139-1))))","v":138},null,2,"(kit_dual_hot_end)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E139,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:140)*($D$2:D140=(D140-1))))","v":139},null,3,"extruder_maker_gear",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E140,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:141)*($D$2:D141=(D141-1))))","v":139},null,3,"fitting_one_touch_4mm",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E141,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:142)*($D$2:D142=(D142-1))))","v":139},null,3,"nut_extr_m5 (open_rail_kit_excess)",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E142,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:143)*($D$2:D143=(D143-1))))","v":138},null,2,"bracket_hot_end_groovemount_dual",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E143,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:144)*($D$2:D144=(D144-1))))","v":138},null,2,"nut_m4",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E144,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:145)*($D$2:D145=(D145-1))))","v":138},null,2,"scrw_m4_15",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E145,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:146)*($D$2:D146=(D146-1))))","v":138},null,2,"wshr_m4",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E146,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:147)*($D$2:D147=(D147-1))))","v":138},null,2,"nut_m3",6,"ea",6,null,{"$f":"IF(MID(ExplodedBOM!$E147,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:148)*($D$2:D148=(D148-1))))","v":138},null,2,"(assy_ee_fan)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E148,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:149)*($D$2:D149=(D149-1))))","v":148},null,3,"scrw_m4_25",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E149,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:150)*($D$2:D150=(D150-1))))","v":148},null,3,"wshr_m4",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E150,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:151)*($D$2:D151=(D151-1))))","v":148},null,3,"nut_m4",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E151,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:152)*($D$2:D152=(D152-1))))","v":148},null,3,"rp_mount_fan_ee",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E152,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:153)*($D$2:D153=(D153-1))))","v":148},null,3,"fan_40mm_12VDC",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E153,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:154)*($D$2:D154=(D154-1))))","v":148},null,3,"scrw_m3_15",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E154,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:155)*($D$2:D155=(D155-1))))","v":148},null,3,"wshr_m3",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E155,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:156)*($D$2:D156=(D156-1))))","v":148},null,3,"nut_m3",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E156,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:157)*($D$2:D157=(D157-1))))","v":148},null,3,"spring_m4",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E157,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:158)*($D$2:D158=(D158-1))))","v":2},null,1,"(kit_lower_electronics)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E158,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:159)*($D$2:D159=(D159-1))))","v":158},null,2,"(RAMPS)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E159,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:160)*($D$2:D160=(D160-1))))","v":159},null,3,"pcb_arduino_mega",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E160,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:161)*($D$2:D161=(D161-1))))","v":159},null,3,"pcb_RAMPS_stack",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E161,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:162)*($D$2:D162=(D162-1))))","v":158},null,2,"rp_bracket_RAMPS",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E162,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:163)*($D$2:D163=(D163-1))))","v":158},null,2,"scrw_m3_20",5,"ea",5,null,{"$f":"IF(MID(ExplodedBOM!$E163,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:164)*($D$2:D164=(D164-1))))","v":158},null,2,"nut_m3",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E164,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:165)*($D$2:D165=(D165-1))))","v":158},null,2,"wshr_m3",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E165,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:166)*($D$2:D166=(D166-1))))","v":158},null,2,"fan_40mm_12VDC",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E166,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:167)*($D$2:D167=(D167-1))))","v":158},null,2,"rp_fan_mount_motor_drivers",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E167,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:168)*($D$2:D168=(D168-1))))","v":158},null,2,"pcb_fan_extension_board",1,"ea",{"$f":"F168*A168","v":1},null,{"$f":"IF(MID(ExplodedBOM!$E168,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:169)*($D$2:D169=(D169-1))))","v":158},null,2,"pcb_sd_ramps_extension_board",1,"ea",{"$f":"F169*A169","v":1},null,{"$f":"IF(MID(ExplodedBOM!$E169,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:170)*($D$2:D170=(D170-1))))","v":2},null,1,"(kit_frame_strut)",4,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E170,1,1)=\"(\",TRUE,FALSE)","v":true}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:171)*($D$2:D171=(D171-1))))","v":170},null,2,"rp_bracket_lateral_sppt",1,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E171,1,1)=\"(\",TRUE,FALSE)","v":false}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:172)*($D$2:D172=(D172-1))))","v":170},null,2,"rp_bracket_lateral_sppt_mirrored",1,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E172,1,1)=\"(\",TRUE,FALSE)","v":false}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:173)*($D$2:D173=(D173-1))))","v":170},null,2,"2020-371mm",1,"ea",4,null,{"$f":"IF(MID(ExplodedBOM!$E173,1,1)=\"(\",TRUE,FALSE)","v":false}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:174)*($D$2:D174=(D174-1))))","v":170},null,2,"wshr_4mm",2,"ea",8,null,{"$f":"IF(MID(ExplodedBOM!$E174,1,1)=\"(\",TRUE,FALSE)","v":false}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:175)*($D$2:D175=(D175-1))))","v":170},null,2,"scrw_m4_10",2,"ea",8,null,{"$f":"IF(MID(ExplodedBOM!$E175,1,1)=\"(\",TRUE,FALSE)","v":false}]
[4,{"$f":"SUMPRODUCT(MAX(ROW($2:176)*($D$2:D176=(D176-1))))","v":170},null,2,"scrw_m4_8",2,"ea",8,null,{"$f":"IF(MID(ExplodedBOM!$E176,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:177)*($D$2:D177=(D177-1))))","v":2},null,1,"(kit_ducting)",1,"ea",1,"F.75X1.5LG6 (panduit / panduct)",{"$f":"IF(MID(ExplodedBOM!$E177,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:178)*($D$2:D178=(D178-1))))","v":177},null,2,"wire_raceway_5in",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E178,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:179)*($D$2:D179=(D179-1))))","v":177},null,2,"wire_raceway_8in",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E179,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:180)*($D$2:D180=(D180-1))))","v":177},null,2,"wire_raceway_10in",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E180,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:181)*($D$2:D181=(D181-1))))","v":177},null,2,"wire_raceway_25in",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E181,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:182)*($D$2:D182=(D182-1))))","v":177},null,2,"wire_wrap_10ft",1,"ea",1,"http://www.amazon.com/Vaisis-Spiral-Harness-Outside-Diameter/dp/B003PR6KUO/ref=sr_1_17?s=electronics&ie=UTF8&qid=1391851443&sr=1-17&keywords=cable+wrap",{"$f":"IF(MID(ExplodedBOM!$E182,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:183)*($D$2:D183=(D183-1))))","v":177},null,2,"nut_extr_m4",14,"ea",{"$f":"F183*A183","v":14},null,{"$f":"IF(MID(ExplodedBOM!$E183,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:184)*($D$2:D184=(D184-1))))","v":177},null,2,"scrw_m4_8",14,"ea",14,null,{"$f":"IF(MID(ExplodedBOM!$E184,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:185)*($D$2:D185=(D185-1))))","v":177},null,2,"wshr_m4",14,"ea",14,null,{"$f":"IF(MID(ExplodedBOM!$E185,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:186)*($D$2:D186=(D186-1))))","v":2},null,1,"(misc parts)",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E186,1,1)=\"(\",TRUE,FALSE)","v":true}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:187)*($D$2:D187=(D187-1))))","v":186},null,2,"cable_ribbon_10_conductor_15ft",2,"ea",2,null,{"$f":"IF(MID(ExplodedBOM!$E187,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:188)*($D$2:D188=(D188-1))))","v":186},null,2,"2020_cap",16,"ea",16,null,{"$f":"IF(MID(ExplodedBOM!$E188,1,1)=\"(\",TRUE,FALSE)","v":false}]
[1,{"$f":"SUMPRODUCT(MAX(ROW($2:189)*($D$2:D189=(D189-1))))","v":186},null,2,"epoxy_two_part",1,"ea",1,null,{"$f":"IF(MID(ExplodedBOM!$E189,1,1)=\"(\",TRUE,FALSE)","v":false}]

{"sheet":"FlatBOM","index":1,"n_rows":101,"n_cols":7,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Phantom","FALSE"]
[]
["Part","Total Qty","Vendor","MFG PN","Vendor PN","Notes","URL"]
["2020_cap",16,{"$f":"VLOOKUP(A4,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A4,PartSpecs!A:Z,3,FALSE)","v":"HFC5-2020"},{"$f":"VLOOKUP(A4,PartSpecs!A:Z,4,FALSE)","v":"HFC5-2020"},{"$f":"VLOOKUP(A4,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A4,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-134mm",1,{"$f":"VLOOKUP(A5,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A5,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-134"},{"$f":"VLOOKUP(A5,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-134"},{"$f":"VLOOKUP(A5,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A5,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-200mm",3,{"$f":"VLOOKUP(A6,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A6,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-200"},{"$f":"VLOOKUP(A6,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-200"},{"$f":"VLOOKUP(A6,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A6,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-300mm",7,{"$f":"VLOOKUP(A7,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A7,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-300"},{"$f":"VLOOKUP(A7,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-300"},{"$f":"VLOOKUP(A7,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A7,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-371mm",7,{"$f":"VLOOKUP(A8,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A8,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-371"},{"$f":"VLOOKUP(A8,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-371"},{"$f":"VLOOKUP(A8,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A8,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-50mm",2,{"$f":"VLOOKUP(A9,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A9,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-50"},{"$f":"VLOOKUP(A9,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-50"},{"$f":"VLOOKUP(A9,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A9,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["2020-800mm",3,{"$f":"VLOOKUP(A10,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A10,PartSpecs!A:Z,3,FALSE)","v":"HFS5-2020-800"},{"$f":"VLOOKUP(A10,PartSpecs!A:Z,4,FALSE)","v":"HFS5-2020-800"},{"$f":"VLOOKUP(A10,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A10,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["bearing_608z",4,{"$f":"VLOOKUP(A11,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A11,PartSpecs!A:Z,3,FALSE)","v":"608z"},{"$f":"VLOOKUP(A11,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A11,PartSpecs!A:Z,5,FALSE)","v":"Easily sourced"},{"$f":"VLOOKUP(A11,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Amico-Single-Shielded-Miniature-Bearings/dp/B00843OUNI/ref=sr_1_1?ie=UTF8&qid=1391903370&sr=8-1&keywords=608z]"}]
["bearing_624z",6,{"$f":"VLOOKUP(A12,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A12,PartSpecs!A:Z,3,FALSE)","v":"624z"},{"$f":"VLOOKUP(A12,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A12,PartSpecs!A:Z,5,FALSE)","v":"Easily sourced"},{"$f":"VLOOKUP(A12,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Amico-Single-Shielded-Groove-Bearing/dp/B00AUB7M3C/ref=sr_1_1?ie=UTF8&qid=1391903417&sr=8-1&keywords=624z]"}]
["bed_glass",1,{"$f":"VLOOKUP(A13,PartSpecs!A:Z,2,FALSE)","v":"(no vendor data entered)"},{"$f":"VLOOKUP(A13,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A13,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A13,PartSpecs!A:Z,5,FALSE)","v":"300mm beds appear to be scare at the moment.  Looking into sources.  250mm from TrinityLabs may need to be an interim substitue."},{"$f":"VLOOKUP(A13,PartSpecs!A:Z,6,FALSE)","v":""}]
["belt_gt2_1700mm",3,{"$f":"VLOOKUP(A14,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A14,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A14,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A14,PartSpecs!A:Z,5,FALSE)","v":"Order by the foot. 304.8 mm / ft!"},{"$f":"VLOOKUP(A14,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/gt2-2mm-timing-belt/]"}]
["bracket_heater_sppt_wood",1,{"$f":"VLOOKUP(A15,PartSpecs!A:Z,2,FALSE)","v":"Ponoko"},{"$f":"VLOOKUP(A15,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A15,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A15,PartSpecs!A:Z,5,FALSE)","v":"Wooden piece.  Laser cutting files on GitHub & ponoko"},{"$f":"VLOOKUP(A15,PartSpecs!A:Z,6,FALSE)","v":"[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]"}]
["bracket_hot_end_groovemount_dual",1,{"$f":"VLOOKUP(A16,PartSpecs!A:Z,2,FALSE)","v":"Ponoko"},{"$f":"VLOOKUP(A16,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A16,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A16,PartSpecs!A:Z,5,FALSE)","v":"Wooden piece.  Laser cutting files on GitHub & ponoko"},{"$f":"VLOOKUP(A16,PartSpecs!A:Z,6,FALSE)","v":"[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]"}]
["bracket_power_supply_stablity_xy",1,{"$f":"VLOOKUP(A17,PartSpecs!A:Z,2,FALSE)","v":"Ponoko"},{"$f":"VLOOKUP(A17,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A17,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A17,PartSpecs!A:Z,5,FALSE)","v":"Wooden piece.  Laser cutting files on GitHub & ponoko"},{"$f":"VLOOKUP(A17,PartSpecs!A:Z,6,FALSE)","v":"[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]"}]
["bracket_tee_2020",9,{"$f":"VLOOKUP(A18,PartSpecs!A:Z,2,FALSE)","v":"Misumui"},{"$f":"VLOOKUP(A18,PartSpecs!A:Z,3,FALSE)","v":"HBLFSN5"},{"$f":"VLOOKUP(A18,PartSpecs!A:Z,4,FALSE)","v":"HBLFSN5"},{"$f":"VLOOKUP(A18,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A18,PartSpecs!A:Z,6,FALSE)","v":"[http://us.misumi-ec.com/]"}]
["cable_ribbon_10_conductor_15ft",2,{"$f":"VLOOKUP(A19,PartSpecs!A:Z,2,FALSE)","v":"SparkFun"},{"$f":"VLOOKUP(A19,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A19,PartSpecs!A:Z,4,FALSE)","v":"CAB-1064"},{"$f":"VLOOKUP(A19,PartSpecs!A:Z,5,FALSE)","v":"Used for bulk-running the opto +V, SIG, & GND to the board.  Also used for clean motor runs and I/O to the EE.  Note, some have suggested this is too thin of wire gauge.  User to decide"},{"$f":"VLOOKUP(A19,PartSpecs!A:Z,6,FALSE)","v":"[https://www.sparkfun.com/products/10647]"}]
["drive_filament_dia",2,{"$f":"VLOOKUP(A20,PartSpecs!A:Z,2,FALSE)","v":"RepRap Sources"},{"$f":"VLOOKUP(A20,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A20,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A20,PartSpecs!A:Z,5,FALSE)","v":"Mk7-like with 8mm bore to be compatible with phidgets geared steppers."},{"$f":"VLOOKUP(A20,PartSpecs!A:Z,6,FALSE)","v":"[http://reprap.org/wiki/Drive-gear]"}]
["epoxy_two_part",1,{"$f":"VLOOKUP(A21,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A21,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A21,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A21,PartSpecs!A:Z,5,FALSE)","v":"For gluing the rod ends to the carbon tubing"},{"$f":"VLOOKUP(A21,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Devcon-2-Ton-Crystal-Clear-0-84-Ounce/dp/B0006O8QQ0/ref=sr_1_1?s=toys-and-games&ie=UTF8&qid=1391907029&sr=1-1&keywords=two+part+epoxy]"}]
["extruder_maker_gear",2,{"$f":"VLOOKUP(A22,PartSpecs!A:Z,2,FALSE)","v":"MakerGear"},{"$f":"VLOOKUP(A22,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A22,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A22,PartSpecs!A:Z,5,FALSE)","v":"Make sure to configure your order for 1.75 barrel."},{"$f":"VLOOKUP(A22,PartSpecs!A:Z,6,FALSE)","v":"[http://www.makergear.com/products/extruders]"}]
["fan_40mm_12VDC",2,{"$f":"VLOOKUP(A23,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A23,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A23,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A23,PartSpecs!A:Z,5,FALSE)","v":"Most 40mm 12VDC fans should do the trick"},{"$f":"VLOOKUP(A23,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Gelid-Solutions-Silent-40mm-FN-SX04-42/dp/B00BF3S83C/ref=sr_1_6?s=electronics&ie=UTF8&qid=1391904001&sr=1-6&keywords=40mm+fan]"}]
["fitting_one_touch_4mm",4,{"$f":"VLOOKUP(A24,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A24,PartSpecs!A:Z,3,FALSE)","v":"KQ2S04-M5A"},{"$f":"VLOOKUP(A24,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A24,PartSpecs!A:Z,5,FALSE)","v":"5mm thread req'd and 4mm OD tube receptable req'd"},{"$f":"VLOOKUP(A24,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/dp/B00AM42V6U/ref=biss_dp_sa1]"}]
["gear_drive_belt_gt2",3,{"$f":"VLOOKUP(A25,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A25,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A25,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A25,PartSpecs!A:Z,5,FALSE)","v":"20 tooth or less is critical to prevent the belt from hitting the carriage"},{"$f":"VLOOKUP(A25,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/gt2-2mm-aluminum-timing-pulley-20/]"}]
["motor_nema_17",3,{"$f":"VLOOKUP(A26,PartSpecs!A:Z,2,FALSE)","v":"Ultimachine"},{"$f":"VLOOKUP(A26,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A26,PartSpecs!A:Z,4,FALSE)","v":"UMN17MTR"},{"$f":"VLOOKUP(A26,PartSpecs!A:Z,5,FALSE)","v":"Std reprap motor"},{"$f":"VLOOKUP(A26,PartSpecs!A:Z,6,FALSE)","v":"[https://ultimachine.com/content/kysan-1124090-nema-17-stepper-motor]"}]
["motor_nema_17_geared_5.18_1",2,{"$f":"VLOOKUP(A27,PartSpecs!A:Z,2,FALSE)","v":"Phidgets"},{"$f":"VLOOKUP(A27,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A27,PartSpecs!A:Z,4,FALSE)","v":"3317_1"},{"$f":"VLOOKUP(A27,PartSpecs!A:Z,5,FALSE)","v":"Extra torque required for long bowden path to hot end"},{"$f":"VLOOKUP(A27,PartSpecs!A:Z,6,FALSE)","v":"[http://www.phidgets.com/products.php?product_id=3317]"}]
["nut_extr_m4",79,{"$f":"VLOOKUP(A28,PartSpecs!A:Z,2,FALSE)","v":"Misumi"},{"$f":"VLOOKUP(A28,PartSpecs!A:Z,3,FALSE)","v":"HNTTBS5-4"},{"$f":"VLOOKUP(A28,PartSpecs!A:Z,4,FALSE)","v":"HNTTBS5-4"},{"$f":"VLOOKUP(A28,PartSpecs!A:Z,5,FALSE)","v":"Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order."},{"$f":"VLOOKUP(A28,PartSpecs!A:Z,6,FALSE)","v":""}]
["nut_extr_m5 (open_rail_kit_excess)",69,{"$f":"VLOOKUP(A29,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A29,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A29,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A29,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A29,PartSpecs!A:Z,6,FALSE)","v":""}]
["nut_m3",35,{"$f":"VLOOKUP(A30,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A30,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A30,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A30,PartSpecs!A:Z,5,FALSE)","v":"Nylon lock preferred"},{"$f":"VLOOKUP(A30,PartSpecs!A:Z,6,FALSE)","v":"[http://www.fastenal.com/web/products/details/1L2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]"}]
["nut_m3_jam",13,{"$f":"VLOOKUP(A31,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A31,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A31,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A31,PartSpecs!A:Z,5,FALSE)","v":"Jam"},{"$f":"VLOOKUP(A31,PartSpecs!A:Z,6,FALSE)","v":"[http://www.fastenal.com/web/products/details/MJ2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]"}]
["nut_m4",8,{"$f":"VLOOKUP(A32,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A32,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A32,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A32,PartSpecs!A:Z,5,FALSE)","v":"Nylon lock preferred"},{"$f":"VLOOKUP(A32,PartSpecs!A:Z,6,FALSE)","v":"[http://www.fastenal.com/web/products/details/1L2530000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]"}]
["open_rail_bearing",24,{"$f":"VLOOKUP(A33,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A33,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A33,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A33,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A33,PartSpecs!A:Z,6,FALSE)","v":""}]
["open_rail_nut_m5",14,{"$f":"VLOOKUP(A34,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A34,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A34,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A34,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A34,PartSpecs!A:Z,6,FALSE)","v":""}]
["open_rail_scrw_m5_std_wheel_mnt",12,{"$f":"VLOOKUP(A35,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A35,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A35,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A35,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A35,PartSpecs!A:Z,6,FALSE)","v":""}]
["open_rail_shim",9,{"$f":"VLOOKUP(A36,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A36,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A36,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A36,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A36,PartSpecs!A:Z,6,FALSE)","v":""}]
["open_rail_shim_eccentric",6,{"$f":"VLOOKUP(A37,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A37,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A37,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A37,PartSpecs!A:Z,5,FALSE)","v":"Stock availability can be shaky.  May need to adapt a different eccentric nut."},{"$f":"VLOOKUP(A37,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/eccentric-spacers/]"}]
["open_rail_spacer_bearing",12,{"$f":"VLOOKUP(A38,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A38,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A38,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A38,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer."},{"$f":"VLOOKUP(A38,PartSpecs!A:Z,6,FALSE)","v":""}]
["open_rail_wheel_delrin",6,{"$f":"VLOOKUP(A39,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A39,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A39,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A39,PartSpecs!A:Z,5,FALSE)","v":"Wheel kit"},{"$f":"VLOOKUP(A39,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-delrin/]"}]
["open_rail_wheel_sst",6,{"$f":"VLOOKUP(A40,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A40,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A40,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A40,PartSpecs!A:Z,5,FALSE)","v":"Wheel kit"},{"$f":"VLOOKUP(A40,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-metal/]"}]
["open_rail-700mm",3,{"$f":"VLOOKUP(A41,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A41,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A41,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A41,PartSpecs!A:Z,5,FALSE)","v":"Order the 1000mm's and cut to length"},{"$f":"VLOOKUP(A41,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/openrail-black-anodized/]"}]
["pcb_arduino_mega",1,{"$f":"VLOOKUP(A42,PartSpecs!A:Z,2,FALSE)","v":"Ultimachine"},{"$f":"VLOOKUP(A42,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A42,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A42,PartSpecs!A:Z,5,FALSE)","v":"Note: The RAMPS stack below includes a MEGA 2560.  Make sure not to double buy!"},{"$f":"VLOOKUP(A42,PartSpecs!A:Z,6,FALSE)","v":"[https://ultimachine.com/content/arduino-mega-2560-r3]"}]
["pcb_fan_extension_board",1,{"$f":"VLOOKUP(A43,PartSpecs!A:Z,2,FALSE)","v":"Geeetech"},{"$f":"VLOOKUP(A43,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A43,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A43,PartSpecs!A:Z,5,FALSE)","v":"Or make your own!  [http://cdaringe.net/blurb/cossel-fan-extension-board/ cdaringe opto-extension board]"},{"$f":"VLOOKUP(A43,PartSpecs!A:Z,6,FALSE)","v":"[http://www.geeetech.com/wiki/index.php/Reprap_Ramps1.4_RRD_Fan_Extender]"}]
["pcb_heater",1,{"$f":"VLOOKUP(A44,PartSpecs!A:Z,2,FALSE)","v":"Ultimachine"},{"$f":"VLOOKUP(A44,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A44,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A44,PartSpecs!A:Z,5,FALSE)","v":"Prusa Heater"},{"$f":"VLOOKUP(A44,PartSpecs!A:Z,6,FALSE)","v":"[https://ultimachine.com/content/prusa-pcb-heated-bed]"}]
["pcb_opto",3,{"$f":"VLOOKUP(A45,PartSpecs!A:Z,2,FALSE)","v":"Ultimachine"},{"$f":"VLOOKUP(A45,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A45,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A45,PartSpecs!A:Z,5,FALSE)","v":"Std opto's"},{"$f":"VLOOKUP(A45,PartSpecs!A:Z,6,FALSE)","v":"[https://ultimachine.com/oek]"}]
["pcb_RAMPS_stack",1,{"$f":"VLOOKUP(A46,PartSpecs!A:Z,2,FALSE)","v":"Ultimachine"},{"$f":"VLOOKUP(A46,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A46,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A46,PartSpecs!A:Z,5,FALSE)","v":"Single Z, not dual Z configuration."},{"$f":"VLOOKUP(A46,PartSpecs!A:Z,6,FALSE)","v":"[https://ultimachine.com/ramps-pre-assembled-kit-complete]"}]
["pcb_sd_ramps_extension_board",1,{"$f":"VLOOKUP(A47,PartSpecs!A:Z,2,FALSE)","v":"Geeetech"},{"$f":"VLOOKUP(A47,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A47,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A47,PartSpecs!A:Z,5,FALSE)","v":"Strongly recommended as pausing issues occur when printing via USB"},{"$f":"VLOOKUP(A47,PartSpecs!A:Z,6,FALSE)","v":"[http://www.geeetech.com/wiki/index.php/SD_for_RAMPS]"}]
["power_supply",1,{"$f":"VLOOKUP(A48,PartSpecs!A:Z,2,FALSE)","v":"Thermaltake"},{"$f":"VLOOKUP(A48,PartSpecs!A:Z,3,FALSE)","v":"TR2 TR-700"},{"$f":"VLOOKUP(A48,PartSpecs!A:Z,4,FALSE)","v":"N82E16817153167"},{"$f":"VLOOKUP(A48,PartSpecs!A:Z,5,FALSE)","v":"ATX PS.  Quiet, reliable."},{"$f":"VLOOKUP(A48,PartSpecs!A:Z,6,FALSE)","v":"[http://www.newegg.com/Product/Product.aspx?Item=N82E16817153167]"}]
["rod_carbon_330mm",6,{"$f":"VLOOKUP(A49,PartSpecs!A:Z,2,FALSE)","v":"Hobby-Lobby"},{"$f":"VLOOKUP(A49,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A49,PartSpecs!A:Z,4,FALSE)","v":"GXT5540"},{"$f":"VLOOKUP(A49,PartSpecs!A:Z,5,FALSE)","v":"Must be cut to size. 3x 1000 rods will satisfy a std build"},{"$f":"VLOOKUP(A49,PartSpecs!A:Z,6,FALSE)","v":"[http://www.hobbyexpress.com/carbon_fiber_tube_5.5_x_4.0_x_1000_mm_24247_prd1.htm?pSearchQueryId=4680220]"}]
["rod_ends",12,{"$f":"VLOOKUP(A50,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A50,PartSpecs!A:Z,3,FALSE)","v":5347},{"$f":"VLOOKUP(A50,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A50,PartSpecs!A:Z,5,FALSE)","v":"4mm OD receptable, 3mm thru-hole ball-ends"},{"$f":"VLOOKUP(A50,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Traxxas-5347-Hollow-Balls-Large/dp/B000BOLVJY]"}]
["rod_threaded_8mm-271mm",1,{"$f":"VLOOKUP(A51,PartSpecs!A:Z,2,FALSE)","v":"Grainger"},{"$f":"VLOOKUP(A51,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A51,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A51,PartSpecs!A:Z,5,FALSE)","v":"5/16\" rod is ~8mm too.  You can buy 5/16\" rod at hardware stores (i.e. Home Depot) for a couple of bucks."},{"$f":"VLOOKUP(A51,PartSpecs!A:Z,6,FALSE)","v":"[http://reprap.org/wiki/Threaded_rod]"}]
["rp_base_vertex",3,{"$f":"VLOOKUP(A52,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A52,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A52,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A52,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A52,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_block_bed",3,{"$f":"VLOOKUP(A53,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A53,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A53,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A53,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A53,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_bracket_axle_spool",3,{"$f":"VLOOKUP(A54,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A54,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A54,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A54,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A54,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_bracket_lateral_sppt",4,{"$f":"VLOOKUP(A55,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A55,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A55,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A55,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A55,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_bracket_lateral_sppt_mirrored",4,{"$f":"VLOOKUP(A56,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A56,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A56,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A56,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A56,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_bracket_pwr_spply_tab",2,{"$f":"VLOOKUP(A57,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A57,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A57,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A57,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A57,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_bracket_RAMPS",1,{"$f":"VLOOKUP(A58,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A58,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A58,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A58,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A58,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_extruder_join_lower",1,{"$f":"VLOOKUP(A59,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A59,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A59,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A59,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A59,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_extruder_join_upper",1,{"$f":"VLOOKUP(A60,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A60,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A60,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A60,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A60,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_fan_mount_motor_drivers",1,{"$f":"VLOOKUP(A61,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A61,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A61,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A61,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A61,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_flag_carriage",3,{"$f":"VLOOKUP(A62,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A62,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A62,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A62,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A62,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_idler",1,{"$f":"VLOOKUP(A63,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A63,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A63,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A63,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A63,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_idler_boss_bearing_8mm",2,{"$f":"VLOOKUP(A64,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A64,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A64,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A64,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A64,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_idler_mirrored",1,{"$f":"VLOOKUP(A65,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A65,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A65,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A65,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A65,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_idler_strut",2,{"$f":"VLOOKUP(A66,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A66,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A66,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A66,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A66,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_mount_fan_ee",1,{"$f":"VLOOKUP(A67,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A67,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A67,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A67,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A67,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_opto_mount",3,{"$f":"VLOOKUP(A68,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A68,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A68,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A68,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A68,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_plate_slider",3,{"$f":"VLOOKUP(A69,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A69,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A69,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A69,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A69,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_ram",3,{"$f":"VLOOKUP(A70,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A70,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A70,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A70,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A70,PartSpecs!A:Z,6,FALSE)","v":""}]
["rp_upper_vertex",3,{"$f":"VLOOKUP(A71,PartSpecs!A:Z,2,FALSE)","v":"RP"},{"$f":"VLOOKUP(A71,PartSpecs!A:Z,3,FALSE)","v":"RP"},{"$f":"VLOOKUP(A71,PartSpecs!A:Z,4,FALSE)","v":"RP"},{"$f":"VLOOKUP(A71,PartSpecs!A:Z,5,FALSE)","v":"Files on GitHub"},{"$f":"VLOOKUP(A71,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_finish_#6",1,{"$f":"VLOOKUP(A72,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A72,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A72,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A72,PartSpecs!A:Z,5,FALSE)","v":"Thermal switch is not required, but strongly recommended for safety"},{"$f":"VLOOKUP(A72,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_10",8,{"$f":"VLOOKUP(A73,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A73,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A73,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A73,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A73,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_12",18,{"$f":"VLOOKUP(A74,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A74,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A74,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A74,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A74,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_15",14,{"$f":"VLOOKUP(A75,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A75,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A75,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A75,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A75,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_20",17,{"$f":"VLOOKUP(A76,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A76,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A76,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A76,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A76,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_25",2,{"$f":"VLOOKUP(A77,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A77,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A77,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A77,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A77,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_35",2,{"$f":"VLOOKUP(A78,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A78,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A78,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A78,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A78,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_50",4,{"$f":"VLOOKUP(A79,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A79,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A79,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A79,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A79,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m3_set",5,{"$f":"VLOOKUP(A80,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A80,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A80,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A80,PartSpecs!A:Z,5,FALSE)","v":"Only order this if your timing pulleys and filament drive gear do not come with their own.  They nearly always do."},{"$f":"VLOOKUP(A80,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_10",47,{"$f":"VLOOKUP(A81,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A81,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A81,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A81,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A81,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_12",12,{"$f":"VLOOKUP(A82,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A82,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A82,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A82,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A82,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_15",25,{"$f":"VLOOKUP(A83,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A83,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A83,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A83,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A83,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_25",4,{"$f":"VLOOKUP(A84,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A84,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A84,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A84,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A84,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_8",22,{"$f":"VLOOKUP(A85,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A85,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A85,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A85,PartSpecs!A:Z,5,FALSE)","v":"Pan head & SST preferred when applicable. "},{"$f":"VLOOKUP(A85,PartSpecs!A:Z,6,FALSE)","v":""}]
["scrw_m4_set_20",12,{"$f":"VLOOKUP(A86,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A86,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A86,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A86,PartSpecs!A:Z,5,FALSE)","v":"Rod End Mounts"},{"$f":"VLOOKUP(A86,PartSpecs!A:Z,6,FALSE)","v":"[http://www.fastenal.com/web/products/details/MX2530020A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]"}]
["scrw_m5_10 (open_rail_kit_excess)",67,{"$f":"VLOOKUP(A87,PartSpecs!A:Z,2,FALSE)","v":"OpenBuilds"},{"$f":"VLOOKUP(A87,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A87,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A87,PartSpecs!A:Z,5,FALSE)","v":"Do not order directly for hardware.  Hardware comes kitted with your rail."},{"$f":"VLOOKUP(A87,PartSpecs!A:Z,6,FALSE)","v":"[http://openbuildspartstore.com/openrail-black-anodized/]"}]
["spring_m3_extruder",4,{"$f":"VLOOKUP(A88,PartSpecs!A:Z,2,FALSE)","v":"Home Depot"},{"$f":"VLOOKUP(A88,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A88,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A88,PartSpecs!A:Z,5,FALSE)","v":"Only 1x spring kit reqd"},{"$f":"VLOOKUP(A88,PartSpecs!A:Z,6,FALSE)","v":"[http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461]"}]
["spring_m4",7,{"$f":"VLOOKUP(A89,PartSpecs!A:Z,2,FALSE)","v":"Home Depot"},{"$f":"VLOOKUP(A89,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A89,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A89,PartSpecs!A:Z,5,FALSE)","v":"Only 1x spring kit reqd"},{"$f":"VLOOKUP(A89,PartSpecs!A:Z,6,FALSE)","v":"[http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461]"}]
["switch_thermal",1,{"$f":"VLOOKUP(A90,PartSpecs!A:Z,2,FALSE)","v":"Amazon"},{"$f":"VLOOKUP(A90,PartSpecs!A:Z,3,FALSE)","v":"Amico KSD301"},{"$f":"VLOOKUP(A90,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A90,PartSpecs!A:Z,5,FALSE)","v":"Recommended for safety"},{"$f":"VLOOKUP(A90,PartSpecs!A:Z,6,FALSE)","v":"[http://www.amazon.com/Amico-Thermostat-Temperature-Control-Celsius/dp/B007Q81IQY]"}]
["tab_felt",3,{"$f":"VLOOKUP(A91,PartSpecs!A:Z,2,FALSE)","v":"(no vendor data entered)"},{"$f":"VLOOKUP(A91,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A91,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A91,PartSpecs!A:Z,5,FALSE)","v":"This is a thermal barrier between the bed and the bed clamp.  Simply household cloth shall suffice."},{"$f":"VLOOKUP(A91,PartSpecs!A:Z,6,FALSE)","v":""}]
["tubing_4mm_bowden_1000mm",2,{"$f":"VLOOKUP(A92,PartSpecs!A:Z,2,FALSE)","v":"MakerShop"},{"$f":"VLOOKUP(A92,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A92,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A92,PartSpecs!A:Z,5,FALSE)","v":"Any common RepRap 4mm tube shall suffice"},{"$f":"VLOOKUP(A92,PartSpecs!A:Z,6,FALSE)","v":"[http://www.makershop.co.nz/PFA_4-2MM]"}]
["wire_raceway_10in",1,{"$f":"VLOOKUP(A93,PartSpecs!A:Z,2,FALSE)","v":"McMaster-Carr"},{"$f":"VLOOKUP(A93,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A93,PartSpecs!A:Z,4,FALSE)","v":"7578K73"},{"$f":"VLOOKUP(A93,PartSpecs!A:Z,5,FALSE)","v":"The 6'6\" is enough for your full build"},{"$f":"VLOOKUP(A93,PartSpecs!A:Z,6,FALSE)","v":"[http://www.mcmaster.com/#catalog/120/862/=qly4to]"}]
["wire_raceway_25in",1,{"$f":"VLOOKUP(A94,PartSpecs!A:Z,2,FALSE)","v":"McMaster-Carr"},{"$f":"VLOOKUP(A94,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A94,PartSpecs!A:Z,4,FALSE)","v":"7578K73"},{"$f":"VLOOKUP(A94,PartSpecs!A:Z,5,FALSE)","v":"The 6'6\" is enough for your full build"},{"$f":"VLOOKUP(A94,PartSpecs!A:Z,6,FALSE)","v":"[http://www.mcmaster.com/#catalog/120/862/=qly4to]"}]
["wire_raceway_5in",2,{"$f":"VLOOKUP(A95,PartSpecs!A:Z,2,FALSE)","v":"McMaster-Carr"},{"$f":"VLOOKUP(A95,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A95,PartSpecs!A:Z,4,FALSE)","v":"7578K73"},{"$f":"VLOOKUP(A95,PartSpecs!A:Z,5,FALSE)","v":"The 6'6\" is enough for your full build"},{"$f":"VLOOKUP(A95,PartSpecs!A:Z,6,FALSE)","v":"[http://www.mcmaster.com/#catalog/120/862/=qly4to]"}]
["wire_raceway_8in",1,{"$f":"VLOOKUP(A96,PartSpecs!A:Z,2,FALSE)","v":"McMaster-Carr"},{"$f":"VLOOKUP(A96,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A96,PartSpecs!A:Z,4,FALSE)","v":"7578K73"},{"$f":"VLOOKUP(A96,PartSpecs!A:Z,5,FALSE)","v":"The 6'6\" is enough for your full build"},{"$f":"VLOOKUP(A96,PartSpecs!A:Z,6,FALSE)","v":"[http://www.mcmaster.com/#catalog/120/862/=qly4to]"}]
["wire_wrap_10ft",1,{"$f":"VLOOKUP(A97,PartSpecs!A:Z,2,FALSE)","v":"McMaster-Carr"},{"$f":"VLOOKUP(A97,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A97,PartSpecs!A:Z,4,FALSE)","v":"7378K41"},{"$f":"VLOOKUP(A97,PartSpecs!A:Z,5,FALSE)","v":"Pick a color! You may use 8+ ft."},{"$f":"VLOOKUP(A97,PartSpecs!A:Z,6,FALSE)","v":"[http://www.mcmaster.com/#spiral-bundling-wrap/=qm0474]"}]
["wshr_4mm",8,{"$f":"VLOOKUP(A98,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A98,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A98,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A98,PartSpecs!A:Z,5,FALSE)","v":"SST preferred"},{"$f":"VLOOKUP(A98,PartSpecs!A:Z,6,FALSE)","v":""}]
["wshr_m3",69,{"$f":"VLOOKUP(A99,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A99,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A99,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A99,PartSpecs!A:Z,5,FALSE)","v":"SST preferred"},{"$f":"VLOOKUP(A99,PartSpecs!A:Z,6,FALSE)","v":""}]
["wshr_m4",115,{"$f":"VLOOKUP(A100,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A100,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A100,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A100,PartSpecs!A:Z,5,FALSE)","v":"SST preferred"},{"$f":"VLOOKUP(A100,PartSpecs!A:Z,6,FALSE)","v":""}]
["wshr_m4_fender",6,{"$f":"VLOOKUP(A101,PartSpecs!A:Z,2,FALSE)","v":"Fastenal"},{"$f":"VLOOKUP(A101,PartSpecs!A:Z,3,FALSE)","v":" "},{"$f":"VLOOKUP(A101,PartSpecs!A:Z,4,FALSE)","v":" "},{"$f":"VLOOKUP(A101,PartSpecs!A:Z,5,FALSE)","v":"SST preferred"},{"$f":"VLOOKUP(A101,PartSpecs!A:Z,6,FALSE)","v":"[http://www.fastenal.com/web/products/details/11511778?isPunchout=false]"}]

{"sheet":"PartSpecs","index":2,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Part","Vendor","MFG PN","Vendor PN","Notes","WikiLink","Link"]
["2020_cap","Misumi","HFC5-2020","HFC5-2020","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.",{"$f":"IF( ISBLANK(G2),\n     \"\",\n     \"[\"&G2&\"]\"\n)","v":"[http://us.misumi-ec.com/]"},"http://us.misumi-ec.com/"]
["2020-134mm","Misumi","HFS5-2020-134","HFS5-2020-134","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["2020-200mm","Misumi","HFS5-2020-200","HFS5-2020-200","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["2020-300mm","Misumi","HFS5-2020-300","HFS5-2020-300","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["2020-371mm","Misumi","HFS5-2020-371","HFS5-2020-371","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["2020-50mm","Misumi","HFS5-2020-50","HFS5-2020-50","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["2020-800mm","Misumi","HFS5-2020-800","HFS5-2020-800","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["bearing_608z","Amazon","608z"," ","Easily sourced","[http://www.amazon.com/Amico-Single-Shielded-Miniature-Bearings/dp/B00843OUNI/ref=sr_1_1?ie=UTF8&qid=1391903370&sr=8-1&keywords=608z]","http://www.amazon.com/Amico-Single-Shielded-Miniature-Bearings/dp/B00843OUNI/ref=sr_1_1?ie=UTF8&qid=1391903370&sr=8-1&keywords=608z"]
["bearing_624z","Amazon","624z"," ","Easily sourced","[http://www.amazon.com/Amico-Single-Shielded-Groove-Bearing/dp/B00AUB7M3C/ref=sr_1_1?ie=UTF8&qid=1391903417&sr=8-1&keywords=624z]","http://www.amazon.com/Amico-Single-Shielded-Groove-Bearing/dp/B00AUB7M3C/ref=sr_1_1?ie=UTF8&qid=1391903417&sr=8-1&keywords=624z"]
["bed_glass","(no vendor data entered)"," "," ","300mm beds appear to be scare at the moment.  Looking into sources.  250mm from TrinityLabs may need to be an interim substitue.",""]
["belt_gt2_1700mm","OpenBuilds"," "," ","Order by the foot. 304.8 mm / ft!","[http://openbuildspartstore.com/gt2-2mm-timing-belt/]","http://openbuildspartstore.com/gt2-2mm-timing-belt/"]
["bracket_heater_sppt_wood","Ponoko"," "," ","Wooden piece.  Laser cutting files on GitHub & ponoko","[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]","http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227"]
["bracket_hot_end_groovemount_dual","Ponoko"," "," ","Wooden piece.  Laser cutting files on GitHub & ponoko","[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]","http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227"]
["bracket_power_supply","RP","RP","RP","Files on GitHub",""]
["bracket_power_supply_stablity_xy","Ponoko"," "," ","Wooden piece.  Laser cutting files on GitHub & ponoko","[http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227]","http://www.ponoko.com/design-your-own/products/cossel-wood-plate-11227"]
["bracket_tee_2020","Misumui","HBLFSN5","HBLFSN5","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.","[http://us.misumi-ec.com/]","http://us.misumi-ec.com/"]
["cable_ribbon_10_conductor_15ft","SparkFun"," ","CAB-1064","Used for bulk-running the opto +V, SIG, & GND to the board.  Also used for clean motor runs and I/O to the EE.  Note, some have suggested this is too thin of wire gauge.  User to decide","[https://www.sparkfun.com/products/10647]","https://www.sparkfun.com/products/10647"]
["drive_filament_dia","RepRap Sources"," "," ","Mk7-like with 8mm bore to be compatible with phidgets geared steppers.","[http://reprap.org/wiki/Drive-gear]","http://reprap.org/wiki/Drive-gear"]
["epoxy_two_part","Amazon"," "," ","For gluing the rod ends to the carbon tubing","[http://www.amazon.com/Devcon-2-Ton-Crystal-Clear-0-84-Ounce/dp/B0006O8QQ0/ref=sr_1_1?s=toys-and-games&ie=UTF8&qid=1391907029&sr=1-1&keywords=two+part+epoxy]","http://www.amazon.com/Devcon-2-Ton-Crystal-Clear-0-84-Ounce/dp/B0006O8QQ0/ref=sr_1_1?s=toys-and-games&ie=UTF8&qid=1391907029&sr=1-1&keywords=two+part+epoxy"]
["extruder_maker_gear","MakerGear"," "," ","Make sure to configure your order for 1.75 barrel.","[http://www.makergear.com/products/extruders]","http://www.makergear.com/products/extruders"]
["fan_40mm_12VDC","Amazon"," "," ","Most 40mm 12VDC fans should do the trick","[http://www.amazon.com/Gelid-Solutions-Silent-40mm-FN-SX04-42/dp/B00BF3S83C/ref=sr_1_6?s=electronics&ie=UTF8&qid=1391904001&sr=1-6&keywords=40mm+fan]","http://www.amazon.com/Gelid-Solutions-Silent-40mm-FN-SX04-42/dp/B00BF3S83C/ref=sr_1_6?s=electronics&ie=UTF8&qid=1391904001&sr=1-6&keywords=40mm+fan"]
["fitting_one_touch_4mm","Amazon","KQ2S04-M5A"," ","5mm thread req'd and 4mm OD tube receptable req'd","[http://www.amazon.com/dp/B00AM42V6U/ref=biss_dp_sa1]","http://www.amazon.com/dp/B00AM42V6U/ref=biss_dp_sa1"]
["gear_drive_belt_gt2","OpenBuilds"," "," ","20 tooth or less is critical to prevent the belt from hitting the carriage","[http://openbuildspartstore.com/gt2-2mm-aluminum-timing-pulley-20/]","http://openbuildspartstore.com/gt2-2mm-aluminum-timing-pulley-20/"]
["motor_nema_17","Ultimachine"," ","UMN17MTR","Std reprap motor","[https://ultimachine.com/content/kysan-1124090-nema-17-stepper-motor]","https://ultimachine.com/content/kysan-1124090-nema-17-stepper-motor"]
["motor_nema_17_geared_5.18_1","Phidgets"," ","3317_1","Extra torque required for long bowden path to hot end","[http://www.phidgets.com/products.php?product_id=3317]","http://www.phidgets.com/products.php?product_id=3317"]
["nut_extr_m4","Misumi","HNTTBS5-4","HNTTBS5-4","Site is designed for commerical customers, but you can still setup an account.  You must manually enter the part numbers into a purchase order.",""]
["nut_extr_m5 (open_rail_kit_excess)","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",""]
["nut_m3","Fastenal"," "," ","Nylon lock preferred","[http://www.fastenal.com/web/products/details/1L2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]","http://www.fastenal.com/web/products/details/1L2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine="]
["nut_m3_jam","Fastenal"," "," ","Jam","[http://www.fastenal.com/web/products/details/MJ2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]","http://www.fastenal.com/web/products/details/MJ2510000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine="]
["nut_m4","Fastenal"," "," ","Nylon lock preferred","[http://www.fastenal.com/web/products/details/1L2530000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]","http://www.fastenal.com/web/products/details/1L2530000A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine="]
["open_rail_bearing","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",""]
["open_rail_nut_m5","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",""]
["open_rail_scrw_m5_std_wheel_mnt","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",{"$f":"IF( ISBLANK(G34),\n     \"\",\n     \"[\"&G34&\"]\"\n)","v":""}]
["open_rail_shim","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",""]
["open_rail_shim_eccentric","OpenBuilds"," "," ","Stock availability can be shaky.  May need to adapt a different eccentric nut.","[http://openbuildspartstore.com/eccentric-spacers/]","http://openbuildspartstore.com/eccentric-spacers/"]
["open_rail_spacer_bearing","OpenBuilds"," "," ","Do not order directly for hardware.  You will have excess from your wheel kits which instead use the eccentric spacer.",""]
["open_rail_wheel_delrin","OpenBuilds"," "," ","Wheel kit","[http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-delrin/]","http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-delrin/"]
["open_rail_wheel_sst","OpenBuilds"," "," ","Wheel kit","[http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-metal/]","http://openbuildspartstore.com/openbuilds-dual-v-wheel-kit-metal/"]
["open_rail-700mm","OpenBuilds"," "," ","Order the 1000mm's and cut to length","[http://openbuildspartstore.com/openrail-black-anodized/]","http://openbuildspartstore.com/openrail-black-anodized/"]
["pcb_arduino_mega","Ultimachine"," "," ","Note: The RAMPS stack below includes a MEGA 2560.  Make sure not to double buy!","[https://ultimachine.com/content/arduino-mega-2560-r3]","https://ultimachine.com/content/arduino-mega-2560-r3"]
["pcb_fan_extension_board","Geeetech"," "," ","Or make your own!  [http://cdaringe.net/blurb/cossel-fan-extension-board/ cdaringe opto-extension board]","[http://www.geeetech.com/wiki/index.php/Reprap_Ramps1.4_RRD_Fan_Extender]","http://www.geeetech.com/wiki/index.php/Reprap_Ramps1.4_RRD_Fan_Extender"]
["pcb_heater","Ultimachine"," "," ","Prusa Heater","[https://ultimachine.com/content/prusa-pcb-heated-bed]","https://ultimachine.com/content/prusa-pcb-heated-bed"]
["pcb_opto","Ultimachine"," "," ","Std opto's","[https://ultimachine.com/oek]","https://ultimachine.com/oek"]
["pcb_RAMPS_stack","Ultimachine"," "," ","Single Z, not dual Z configuration.","[https://ultimachine.com/ramps-pre-assembled-kit-complete]","https://ultimachine.com/ramps-pre-assembled-kit-complete"]
["pcb_sd_ramps_extension_board","Geeetech"," "," ","Strongly recommended as pausing issues occur when printing via USB","[http://www.geeetech.com/wiki/index.php/SD_for_RAMPS]","http://www.geeetech.com/wiki/index.php/SD_for_RAMPS"]
["power_supply","Thermaltake","TR2 TR-700","N82E16817153167","ATX PS.  Quiet, reliable.","[http://www.newegg.com/Product/Product.aspx?Item=N82E16817153167]","http://www.newegg.com/Product/Product.aspx?Item=N82E16817153167"]
["rod_carbon_330mm","Hobby-Lobby"," ","GXT5540","Must be cut to size. 3x 1000 rods will satisfy a std build","[http://www.hobbyexpress.com/carbon_fiber_tube_5.5_x_4.0_x_1000_mm_24247_prd1.htm?pSearchQueryId=4680220]","http://www.hobbyexpress.com/carbon_fiber_tube_5.5_x_4.0_x_1000_mm_24247_prd1.htm?pSearchQueryId=4680220"]
["rod_ends","Amazon",5347," ","4mm OD receptable, 3mm thru-hole ball-ends","[http://www.amazon.com/Traxxas-5347-Hollow-Balls-Large/dp/B000BOLVJY]","http://www.amazon.com/Traxxas-5347-Hollow-Balls-Large/dp/B000BOLVJY"]
["rod_threaded_8mm-271mm","Grainger"," "," ","5/16\" rod is ~8mm too.  You can buy 5/16\" rod at hardware stores (i.e. Home Depot) for a couple of bucks.","[http://reprap.org/wiki/Threaded_rod]","http://reprap.org/wiki/Threaded_rod"]
["rp_base_vertex","RP","RP","RP","Files on GitHub",""]
["rp_block_bed","RP","RP","RP","Files on GitHub",""]
["rp_bracket_axle_spool","RP","RP","RP","Files on GitHub",""]
["rp_bracket_lateral_sppt","RP","RP","RP","Files on GitHub",""]
["rp_bracket_lateral_sppt_mirrored","RP","RP","RP","Files on GitHub",""]
["rp_bracket_pwr_spply_tab","RP","RP","RP","Files on GitHub",""]
["rp_bracket_RAMPS","RP","RP","RP","Files on GitHub",""]
["rp_extruder_join_lower","RP","RP","RP","Files on GitHub",""]
["rp_extruder_join_upper","RP","RP","RP","Files on GitHub",""]
["rp_fan_mount_motor_drivers","RP","RP","RP","Files on GitHub",""]
["rp_flag_carriage","RP","RP","RP","Files on GitHub",""]
["rp_idler","RP","RP","RP","Files on GitHub",""]
["rp_idler_boss_bearing_8mm","RP","RP","RP","Files on GitHub",""]
["rp_idler_mirrored","RP","RP","RP","Files on GitHub",""]
["rp_idler_strut","RP","RP","RP","Files on GitHub",""]
["rp_mount_fan_ee","RP","RP","RP","Files on GitHub",{"$f":"IF( ISBLANK(G66),\n     \"\",\n     \"[\"&G66&\"]\"\n)","v":""}]
["rp_opto_mount","RP","RP","RP","Files on GitHub",""]
["rp_plate_slider","RP","RP","RP","Files on GitHub",""]
["rp_ram","RP","RP","RP","Files on GitHub",""]
["rp_upper_vertex","RP","RP","RP","Files on GitHub",""]
["scrw_finish_#6","Fastenal"," "," ","Thermal switch is not required, but strongly recommended for safety",""]
["scrw_m3_10","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_12","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_15","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_20","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_25","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_35","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_50","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m3_set","Fastenal"," "," ","Only order this if your timing pulleys and filament drive gear do not come with their own.  They nearly always do.",""]
["scrw_m4_10","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m4_12","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m4_15","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m4_25","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m4_8","Fastenal"," "," ","Pan head & SST preferred when applicable. ",""]
["scrw_m4_set_20","Fastenal"," "," ","Rod End Mounts","[http://www.fastenal.com/web/products/details/MX2530020A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine=]","http://www.fastenal.com/web/products/details/MX2530020A20000?searchMode=productSearch&zipcode=&filterByStore=&filterByVendingMachine="]
["scrw_m5_10 (open_rail_kit_excess)","OpenBuilds"," "," ","Do not order directly for hardware.  Hardware comes kitted with your rail.","[http://openbuildspartstore.com/openrail-black-anodized/]","http://openbuildspartstore.com/openrail-black-anodized/"]
["spring_m3_extruder","Home Depot"," "," ","Only 1x spring kit reqd","[http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461]","http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461"]
["spring_m4","Home Depot"," "," ","Only 1x spring kit reqd","[http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461]","http://www.homedepot.com/p/Everbilt-Spring-Assortment-Kit-84-Pack-15642/202045461"]
["switch_thermal","Amazon","Amico KSD301"," ","Recommended for safety","[http://www.amazon.com/Amico-Thermostat-Temperature-Control-Celsius/dp/B007Q81IQY]","http://www.amazon.com/Amico-Thermostat-Temperature-Control-Celsius/dp/B007Q81IQY"]
["tab_felt","(no vendor data entered)"," "," ","This is a thermal barrier between the bed and the bed clamp.  Simply household cloth shall suffice.",""]
["tubing_4mm_bowden_1000mm","MakerShop"," "," ","Any common RepRap 4mm tube shall suffice","[http://www.makershop.co.nz/PFA_4-2MM]","http://www.makershop.co.nz/PFA_4-2MM"]
["wire_raceway_10in","McMaster-Carr"," ","7578K73","The 6'6\" is enough for your full build","[http://www.mcmaster.com/#catalog/120/862/=qly4to]","http://www.mcmaster.com/#catalog/120/862/=qly4to"]
["wire_raceway_25in","McMaster-Carr"," ","7578K73","The 6'6\" is enough for your full build","[http://www.mcmaster.com/#catalog/120/862/=qly4to]","http://www.mcmaster.com/#catalog/120/862/=qly4to"]
["wire_raceway_5in","McMaster-Carr"," ","7578K73","The 6'6\" is enough for your full build","[http://www.mcmaster.com/#catalog/120/862/=qly4to]","http://www.mcmaster.com/#catalog/120/862/=qly4to"]
["wire_raceway_8in","McMaster-Carr"," ","7578K73","The 6'6\" is enough for your full build","[http://www.mcmaster.com/#catalog/120/862/=qly4to]","http://www.mcmaster.com/#catalog/120/862/=qly4to"]
["wire_wrap_10ft","McMaster-Carr"," ","7378K41","Pick a color! You may use 8+ ft.","[http://www.mcmaster.com/#spiral-bundling-wrap/=qm0474]","http://www.mcmaster.com/#spiral-bundling-wrap/=qm0474"]
["wshr_4mm","Fastenal"," "," ","SST preferred",""]
["wshr_m3","Fastenal"," "," ","SST preferred",{"$f":"IF( ISBLANK(G98),\n     \"\",\n     \"[\"&G98&\"]\"\n)","v":""}]
["wshr_m4","Fastenal"," "," ","SST preferred",""]
["wshr_m4_fender","Fastenal"," "," ","SST preferred","[http://www.fastenal.com/web/products/details/11511778?isPunchout=false]","http://www.fastenal.com/web/products/details/11511778?isPunchout=false"]