 |
|
| Metalworking (rec.crafts.metalworking) Discuss various aspects of working with metal, such as machining, welding, metal joining, screwing, casting, hardening/tempering, blacksmithing/forging, spinning and hammer work, sheet metal work. |
| Reply |
|
|
|
LinkBack | Thread Tools | Display Modes |
|
#1
Posted to rec.crafts.metalworking
|
|||
|
|||
McGyver resource: The Circular File
I just know that Thursday of next week, I will need a piece
of 3/16" OD stainless tubing about two inches long with say, 0.01" thick walls. I won't remember the two pieces of perfectly suitable stainless tubing that I almost threw away tonight, each 4.5" long. Until I open my Circular File that is. This spreadsheet is intended to be an open resource for all denizens of RCM and other folks who make models and prototypes. I encourage you to wander around your shop measuring all your Things, so that all can have a way to easily make stuff using "Stock On Hand". Upload your .CSV version to RCM and I will integrate it and present the total for everyone. As you see, the premier version of the sheet has only two items. That is just a format suggestion. I expect that with your participation, we can have this up to 10,000 items in no time. N O T E S I wrote the original in OpenOffice Calc (.ods) I renamed the first tab (sheet) "Imperial" and the second tab (sheet) "Metric" The metric sheet automatically converts from imperial. I suggest the following 'second sheet' example for Excel users: =IF (Imperial.B80,Imperial.B8*25.4,"") And for OpenOffice users: =IF (Imperial.B80;Imperial.B8*25.4;"") *****Copy and save the following as 'CircularFile.csv' then import it ****** "This is The Circular File",,,,,, "A source for Free or Cheap Materials",,,,,, "All trademarks are the property of their respective owners.",,,,,, ,,,,,, ,"Nominal","Nominal","Nominal","Nominal",, "Material","Diameter or Width","Depth","Wall Thickness","Length","Notes","Source" ,"Inches +- 0.01”","Inches +- 0.01”","Inches +- 0.002”","Inches",, "Stainless Steel?",0.1875,,0.01,4.5,"Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece" "HDPE?",1.67,,0.033,1.67,"“Cup” shape. One end open","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash" *****Copy and save the above as 'CircularFile.csv' then import it ****** As always, I look forward to your helpful corrections and suggestions. Thanks! --Winston |
|
#2
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
I've appended the first few lines of the second tab (sheet) so
that you can copy it and paste into your spreadsheet to do metric conversion. If you are using Excel, please paste the Excel version shown underneath the OpenOffice version. --Winston Winston wrote: I just know that Thursday of next week, I will need a piece of 3/16" OD stainless tubing about two inches long with say, 0.01" thick walls. I won't remember the two pieces of perfectly suitable stainless tubing that I almost threw away tonight, each 4.5" long. Until I open my Circular File that is. This spreadsheet is intended to be an open resource for all denizens of RCM and other folks who make models and prototypes. I encourage you to wander around your shop measuring all your Things, so that all can have a way to easily make stuff using "Stock On Hand". Upload your .CSV version to RCM and I will integrate it and present the total for everyone. As you see, the premier version of the sheet has only two items. That is just a format suggestion. I expect that with your participation, we can have this up to 10,000 items in no time. N O T E S I wrote the original in OpenOffice Calc (.ods) I renamed the first tab (sheet) "Imperial" and the second tab (sheet) "Metric" The metric sheet automatically converts from imperial. I suggest the following 'second sheet' example for Excel users: =IF (Imperial.B80,Imperial.B8*25.4,"") And for OpenOffice users: =IF (Imperial.B80;Imperial.B8*25.4;"") *****Copy and save the following as 'CircularFile.csv' then import it, creating a sheet named CircularFile.ods or CircularFile.xls****** "This is The Circular File",,,,,, "A source for Free or Cheap Materials",,,,,, "All trademarks are the property of their respective owners.",,,,,, ,,,,,, ,"Nominal","Nominal","Nominal","Nominal",, "Material","Diameter or Width","Depth","Wall Thickness","Length","Notes","Source" ,"Inches +- 0.01”","Inches +- 0.01”","Inches +- 0.002”","Inches",, "Stainless Steel?",0.1875,,0.01,4.5,"Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece" "HDPE?",1.67,,0.033,1.67,"“Cup” shape. One end open","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash" *****Copy and save the above as 'CircularFile.csv' then import it, creating a sheet named CircularFile.ods or CircularFile.xls****** For OpenOffice users: **Copy and paste the following as the second sheet in 'CircularFile.ods'** This is The Circular File, Metric Version =IF (Imperial.A20;Imperial.A2;"") =IF (Imperial.A30;Imperial.A3;"") =IF (Imperial.A40;Imperial.A4;"") =IF (Imperial.A50;Imperial.A5;"") =IF (Imperial.B50;Imperial.B5;"") =IF (Imperial.C50;Imperial.C5;"") =IF (Imperial.D50;Imperial.D5;"") =IF (Imperial.E50;Imperial.E5;"") =IF (Imperial.F50;Imperial.F5;"") =IF (Imperial.G50;Imperial.G5;"") =IF (Imperial.A60;Imperial.A6;"") =IF (Imperial.B60;Imperial.B6;"") =IF (Imperial.C60;Imperial.C6;"") =IF (Imperial.D60;Imperial.D6;"") =IF (Imperial.E60;Imperial.E6;"") =IF (Imperial.F60;Imperial.F6;"") =IF (Imperial.G60;Imperial.G6;"") =IF (Imperial.A70;Imperial.A7;"") Millimeters Millimeters Millimeters Millimeters =IF (Imperial.A80;Imperial.A8;"") =IF (Imperial.B80;Imperial.B8*25.4;"") =IF (Imperial.C80;Imperial.C8*25.4;"") =IF (Imperial.D80;Imperial.D8*25.4;"") =IF (Imperial.E80;Imperial.E8*25.4;"") =IF (Imperial.F80;Imperial.F8;"") =IF (Imperial.G80;Imperial.G8;"") =IF (Imperial.A90;Imperial.A9;"") =IF (Imperial.B90;Imperial.B9*25.4;"") =IF (Imperial.C90;Imperial.C9*25.4;"") =IF (Imperial.D90;Imperial.D9*25.4;"") =IF (Imperial.E90;Imperial.E9*25.4;"") =IF (Imperial.F90;Imperial.F9;"") =IF (Imperial.G90;Imperial.G9;"") =IF (Imperial.A100;Imperial.A10;"") =IF (Imperial.B100;Imperial.B10*25.4;"") =IF (Imperial.C100;Imperial.C10*25.4;"") =IF (Imperial.D100;Imperial.D10*25.4;"") =IF (Imperial.E100;Imperial.E10*25.4;"") =IF (Imperial.F100;Imperial.F10;"") =IF (Imperial.G100;Imperial.G10;"") =IF (Imperial.A110;Imperial.A11;"") =IF (Imperial.B110;Imperial.B11*25.4;"") =IF (Imperial.C110;Imperial.C11*25.4;"") =IF (Imperial.D110;Imperial.D11*25.4;"") =IF (Imperial.E110;Imperial.E11*25.4;"") =IF (Imperial.F110;Imperial.F11;"") =IF (Imperial.G110;Imperial.G11;"") =IF (Imperial.A120;Imperial.A12;"") =IF (Imperial.B120;Imperial.B12*25.4;"") =IF (Imperial.C120;Imperial.C12*25.4;"") =IF (Imperial.D120;Imperial.D12*25.4;"") =IF (Imperial.E120;Imperial.E12*25.4;"") =IF (Imperial.F120;Imperial.F12;"") =IF (Imperial.G120;Imperial.G12;"") **Copy and paste the above as the second sheet in 'CircularFile.ods' ** For Excel users: **Copy and paste the following as the second sheet in 'CircularFile.xls'** This is The Circular File, Metric Version =IF (Imperial.A20,Imperial.A2,"") =IF (Imperial.A30,Imperial.A3,"") =IF (Imperial.A40,Imperial.A4,"") =IF (Imperial.A50,Imperial.A5,"") =IF (Imperial.B50,Imperial.B5,"") =IF (Imperial.C50,Imperial.C5,"") =IF (Imperial.D50,Imperial.D5,"") =IF (Imperial.E50,Imperial.E5,"") =IF (Imperial.F50,Imperial.F5,"") =IF (Imperial.G50,Imperial.G5,"") =IF (Imperial.A60,Imperial.A6,"") =IF (Imperial.B60,Imperial.B6,"") =IF (Imperial.C60,Imperial.C6,"") =IF (Imperial.D60,Imperial.D6,"") =IF (Imperial.E60,Imperial.E6,"") =IF (Imperial.F60,Imperial.F6,"") =IF (Imperial.G60,Imperial.G6,"") =IF (Imperial.A70,Imperial.A7,"") Millimeters Millimeters Millimeters Millimeters =IF (Imperial.A80,Imperial.A8,"") =IF (Imperial.B80,Imperial.B8*25.4,"") =IF (Imperial.C80,Imperial.C8*25.4,"") =IF (Imperial.D80,Imperial.D8*25.4,"") =IF (Imperial.E80,Imperial.E8*25.4,"") =IF (Imperial.F80,Imperial.F8,"") =IF (Imperial.G80,Imperial.G8,"") =IF (Imperial.A90,Imperial.A9,"") =IF (Imperial.B90,Imperial.B9*25.4,"") =IF (Imperial.C90,Imperial.C9*25.4,"") =IF (Imperial.D90,Imperial.D9*25.4,"") =IF (Imperial.E90,Imperial.E9*25.4,"") =IF (Imperial.F90,Imperial.F9,"") =IF (Imperial.G90,Imperial.G9,"") =IF (Imperial.A100,Imperial.A10,"") =IF (Imperial.B100,Imperial.B10*25.4,"") =IF (Imperial.C100,Imperial.C10*25.4,"") =IF (Imperial.D100,Imperial.D10*25.4,"") =IF (Imperial.E100,Imperial.E10*25.4,"") =IF (Imperial.F100,Imperial.F10,"") =IF (Imperial.G100,Imperial.G10,"") =IF (Imperial.A110,Imperial.A11,"") =IF (Imperial.B110,Imperial.B11*25.4,"") =IF (Imperial.C110,Imperial.C11*25.4,"") =IF (Imperial.D110,Imperial.D11*25.4,"") =IF (Imperial.E110,Imperial.E11*25.4,"") =IF (Imperial.F110,Imperial.F11,"") =IF (Imperial.G110,Imperial.G11,"") =IF (Imperial.A120,Imperial.A12,"") =IF (Imperial.B120,Imperial.B12*25.4,"") =IF (Imperial.C120,Imperial.C12*25.4,"") =IF (Imperial.D120,Imperial.D12*25.4,"") =IF (Imperial.E120,Imperial.E12*25.4,"") =IF (Imperial.F120,Imperial.F12,"") =IF (Imperial.G120,Imperial.G12,"") **Copy and paste the above as the second sheet in 'CircularFile.xls' ** As always, I look forward to your helpful corrections and suggestions. Thanks! --Winston |
|
#3
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
OK everybody, I've added a couple of columns and five more entries.
Let me clarify: I don't want to share any of your treasure. I don't want to share any of mine with you, necessarily. I want us to create a huge index of materials, as a mental springboard that we can use when we are casting about for a cheap or free way to make something. Reduce, Reuse, Recycle! This list is sorted in ascending order of outside diameter (or width). You could just as easily re-sort your sheet by material or any other criteria. Example: I need six 1" long un-threaded spacers to clear 1/4-20 screws so I can quickly bolt together a prototype. Weight isn't critical but it would be nice if the spacers were somewhat conductive, electrically speaking. The Circular File tells me I can potentially use slices of 1/8" iron pipe to make my spacers for No Money. You can be Famous! Each of your entries will be immortalized with your name or handle plus the date you added it! (Is this exciting or what?) *****Copy and save the following as 'CircularFile.csv' then import it ****** "This is The Circular File",,,,,,,,, "A source for Inexpensive Materials",,,,,,,,, "All trademarks are the property of their respective owners.",,,,,,,,, ,,,,,,,,, ,"Nominal Outside","Nominal","Nominal","Nominal",,,,, "Material","Diameter or Width","Depth","Wall Thickness","Length",,"Notes","Source","Posted","By " ,"Inches +- 0.003”","Inches +- 0.003”","Inches +- 0.002”","Inches","Shape",,,, "Steel",0.045,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (0.045” size)",11/18/2008,"Winston" "Steel",0.062,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (1/16” size)",11/18/2008,"Winston" "Stainless Steel",0.1875,,0.01,4.5,"Pipe","Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece",11/18/2008,"Winston" "Steel",0.366,,0.048,9,"Pipe","Available in many lengths","NPS 1/8” pipe. An electric lamp part, between the base and harp",11/18/2008,"Winston" "Aluminum",1.244,,0.028,1.93,"Cup and Lid","Matte oxide finish","Metal 35 mm film canister W/ threaded lid",11/18/2008,"Winston" "Plastic",1.26,,0.05,2.013,"Cup and Lid","Light Gray body, Black cap","Plastic 35 mm film canister W/Snap Lid",11/18/2008,"Winston" "HDPE",1.67,,0.033,1.67,"Cup","Translucent white color","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash",11/18/2008,"Winston" *****Copy and save the above as 'CircularFile.csv' then import it ****** As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#4
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Nov 18, 1:44*am, Winston wrote:
[^ original, the rest copied and pasted from a .txt file. Michael, try replying to this.] ... This spreadsheet is intended to be an open resource for all denizens of RCM and other folks who make models and prototypes. I encourage you to wander around your shop measuring all your Things, so that all can have a way to easily make stuff using "Stock On Hand". Upload your .CSV version to RCM and I will integrate it and present the total for everyone. This is the table I use most. Rather than a spreadsheet it's on a CAD drawing with full-sized section drawings to cut and paste. Brass pipe seems to be very close to these numbers. Iron pipe is sloppier and not always round, especially at the weld line, but it's easy to buy locally on nights and weekends. The numbers are from Machinery's Handbook 23, pp 2380, 2381, which also give Moment of Inertia, Radius of Gyration, Sectional Modulus, etc. Notice that 1" fits easily into 1-1/4", also 1-1/2" into 2", and 3/4" may be a tight fit into 1". To make then telescope well, bore a cap for the larger pipe and turn one down for the end of the inner one. 1/4", 3/8" and 1/2" brass pipe nipples can be bored to make bearings for 3/8", 1/2" and 5/8" shafts. Pipe OD ID 40 ID 80 1/8 0.405 0.269 0.215 1/4 0.540 0.364 0.302 3/8 0.675 0.493 0.423 1/2 0.840 0.622 0.546 3/4 1.050 0.824 0.742 1 1.315 1.049 0.957 1-1/4 1.660 1.380 1.278 1-1/2 1.900 1.610 1.500 2 2.375 2.067 1.939 Jim Wilkins |
|
#5
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Jim Wilkins wrote:
(Pipe information) Thanks Jim! Here is the updated file: *****Copy and save the following as 'CircularFile.csv' then import it ****** "This is The Circular File",,,,,,,,,, "A source for Inexpensive Materials",,,,,,,,,, "All trademarks are the property of their respective owners.",,,,,,,,,, ,,,,,,,,,, ,"Nom. Outside","Nom.","Nom. Inside","Nom.","Nom.",,,,, ,"Diameter or Width","Depth","Diameter","Wall Thk.","Length",,,,, ,"Inches","Inches","Inches","Inches","Inches",, ,,, "Material","+- 0.003”","+- 0.003”","+- 0.003”","+- 0.002”","+- 0.2”","Shape","Notes","Source","Posted","By" "Steel",0.045,,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (0.045” size)",11/18/2008,"Winston" "Steel",0.062,,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (1/16” size)",11/18/2008,"Winston" "Stainless Steel",0.1875,,0.1675,0.01,4.5,"Pipe","Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece",11/18/2008,"Winston" "Steel",0.366,,0.27,0.048,9,"Pipe","Available in many lengths","NPS 1/8” pipe. An electric lamp part, between the base and harp",11/18/2008,"Winston" "Steel or Brass",0.405,,0.269,0.068,120,"Pipe","SCH 40 1/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.405,,0.215,0.095,120,"Pipe","SCH 80 1/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.54,,0.302,0.119,120,"Pipe","SCH 80 1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.54,,0.364,0.088,120,"Pipe","SCH 40 1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.675,,0.423,0.126,120,"Pipe","SCH 80 3/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.675,,0.493,0.091,120,"Pipe","SCH 40 3/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.84,,0.546,0.147,120,"Pipe","SCH 80 1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.84,,0.622,0.109,120,"Pipe","SCH 40 1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.05,,0.824,0.113,120,"Pipe","SCH 40 3/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.05,,0.742,0.154,120,"Pipe","SCH 80 3/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Aluminum",1.244,,1.188,0.028,1.93,"Cup and Lid","Matte oxide finish","Metal 35 mm film canister W/ threaded lid",11/18/2008,"Winston" "Plastic",1.26,,1.16,0.05,2.013,"Cup and Lid","Light Gray body, Black cap","Plastic 35 mm film canister W/Snap Lid",11/18/2008,"Winston" "Steel or Brass",1.315,,1.049,0.133,120,"Pipe","SCH 40 1” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.315,,0.957,0.179,120,"Pipe","SCH 80 1” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.66,,1.38,0.14,120,"Pipe","SCH 40 1-1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.66,,1.278,0.191,120,"Pipe","SCH 80 1-1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "HDPE",1.67,,1.604,0.033,1.67,"Cup","Transluce nt white color","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash",11/18/2008,"Winston" "Steel or Brass",1.9,,1.5,0.2,120,"Pipe","SCH 80 1-1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.9,,1.61,0.145,120,"Pipe","SCH 40 1-1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",2.375,,2.067,0.154,120,"Pipe","SCH 40 2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",2.375,,1.939,0.218,120,"Pipe","SCH 80 2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" ,,,,,,,,,, ,,,,,,,,,, ,,,,,,,,,, ,,,,,,,,,, "Note 1: “Black” and galvanized Iron Pipe, Brass Pipe",,,,,,,,,, "Brass pipe seems to be very close to these numbers. Iron pipe is sloppier and not always round, especially at the weld line, but it's easy to buy locally on nights and weekends.",,,,,,,,,, "The numbers are from Machinery's Handbook 23, pp 2380, 2381, which also give Moment of Inertia, Radius of Gyration, Sectional Modulus, etc.",,,,,,,,,, "Notice that 1"" fits easily into 1-1/4"", also 1-1/2"" into 2"", and ¾"" may be a tight fit into 1"". To make them telescope well, bore a cap for the larger pipe and turn one down for the end of the",,,,,,,,,, "inner one. 1/4"", 3/8"" and 1/2"" brass pipe nipples can be bored to make bearings for 3/8"", 1/2"" and 5/8"" shafts. Jim Wilkins 11/19/2008",,,,,,,,,, *****Copy and save the preceding as 'CircularFile.csv' then import it ****** As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#6
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-19, Winston wrote:
OK everybody, I've added a couple of columns and five more entries. [ ... ] *****Copy and save the following as 'CircularFile.csv' then import it ****** "This is The Circular File",,,,,,,,, "A source for Inexpensive Materials",,,,,,,,, "All trademarks are the property of their respective owners.",,,,,,,,, ,,,,,,,,, ,"Nominal Outside","Nominal","Nominal","Nominal",,,,, "Material","Diameter or Width","Depth","Wall Thickness","Length",,"Notes","Source","Posted","By " ,"Inches +- 0.003”","Inches +- 0.003”","Inches +- 0.002”","Inches","Shape",,,, "Steel",0.045,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (0.045” size)",11/18/2008,"Winston" "Steel",0.062,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (1/16” size)",11/18/2008,"Winston" "Stainless Steel",0.1875,,0.01,4.5,"Pipe","Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece",11/18/2008,"Winston" "Steel",0.366,,0.048,9,"Pipe","Available in many lengths","NPS 1/8” pipe. An electric lamp part, between the base and harp",11/18/2008,"Winston" "Aluminum",1.244,,0.028,1.93,"Cup and Lid","Matte oxide finish","Metal 35 mm film canister W/ threaded lid",11/18/2008,"Winston" "Plastic",1.26,,0.05,2.013,"Cup and Lid","Light Gray body, Black cap","Plastic 35 mm film canister W/Snap Lid",11/18/2008,"Winston" "HDPE",1.67,,0.033,1.67,"Cup","Translucent white color","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash",11/18/2008,"Winston" *****Copy and save the above as 'CircularFile.csv' then import it ****** I have a question. Are the lines folded before you read it into the newsreader? I think that an attachment might preserve the lines better. (I've read it into Sun's StarOffice (their version of OpenOffice) and it seems happy enough anyway. I don't know whether I will every have the time to do the kind of inventory needed, however. And I'm not accustomed to using spreadsheets, so I may have a learning curve. In particular, it is not clear how I was supposed to add the "second page" for metric materials. The first thought was to use my preferred text edtior on the raw file, but that probably would miss some things which would flag it as the "second page". At least it does not require a Windows program, at which point I would have simply walked off. :-) Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#7
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
(...) I have a question. Are the lines folded before you read it into the newsreader? No, many are single line monsters, but I think I know what you mean. You should find the same thing I did; that the wrapped lines automagically 'unfold' when pasted into a text editor. No worries. I think that an attachment might preserve the lines better. (I've read it into Sun's StarOffice (their version of OpenOffice) and it seems happy enough anyway. I would be pleased to post it as an attachment, but I don't know how well that would comply to the group charter. As you imply, I would like to keep the list as safe and universally useful as possible. I don't know whether I will every have the time to do the kind of inventory needed, however. And I'm not accustomed to using spreadsheets, so I may have a learning curve. I add one item at a time. My earlier posts look like I was angling for everyone to inventory every- thing in their shop. Not The Case. I'm mostly looking for mass produced parts that are normally thrown away which have some potential for reuse. The precision shafts in old 5.25" floppy drives, for instance. You are a smart cookie, DoN. That spreadsheet learning curve looks flat to me. In particular, it is not clear how I was supposed to add the "second page" for metric materials. The first thought was to use my preferred text edtior on the raw file, but that probably would miss some things which would flag it as the "second page". You intuit properly. The second page is handled just as the first was. Highlight the text and save it (CTRL-C). Open your favorite text editor and paste (CTRL-V). Save the new file as say, 'Metric.csv' Pop open the spreadsheet you created (with the Imperial information) and open the 'page two' tab (or sheet). Tell the spreadsheet program to open your file named 'Metric.csv'. It should ask you a couple questions about delimiters. After you accept the defaults, it should display the conversions properly. Just resize the column width and Bob's your uncle. Let me caution you that at this very early stage, the sheet is still in flux. Mismatches between versions will happen. When in doubt, just tell me you want both sheets and I will post matching versions. At least it does not require a Windows program, at which point I would have simply walked off. :-) I'm trying to 'tune for maximum usefulness' so a Wintel specific answer would be a non-starter. The first 10,000 items will be the hardest. --Winston |
|
#8
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Here is the latest version with both sheets.
*****Copy and save the following as 'CircularFile.csv' then import it on to Page one which you will rename 'Imperial'****** "This is The Circular File",,,,,,,,,, "A source for Inexpensive Materials",,,,,,,,,, "All trademarks are the property of their respective owners.",,,,,,,,,, ,,,,,,,,,, ,"Nom. Outside",,"Nom. Inside",,,,,,, ,"Diameter","Nom.","Diameter","Nom.","Nom.",,,, , ,"or Width","Depth","or Width","Wall Thk.","Length",,,,, ,"Inches","Inches","Inches","Inches","Inches",, ,,, "Material","+- 0.003”","+- 0.003”","+- 0.003”","+- 0.002”","+- 0.2”","Shape","Notes","Source","Posted","By" "Steel",0.045,,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (0.045” size)",11/18/2008,"Winston" "Steel",0.062,,,,36,"Solid Wire","Copper plated","ER70S-2 TIG filler rod (1/16” size)",11/18/2008,"Winston" "Stainless Steel",0.1875,,0.1675,0.01,4.5,"Pipe","Light oxidation one end","Solder cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece",11/18/2008,"Winston" "Steel",0.366,,0.27,0.048,9,"Pipe","Available in many lengths","NPS 1/8” pipe. An electric lamp part, between the base and harp",11/18/2008,"Winston" "Steel or Brass",0.405,,0.215,0.095,120,"Pipe","SCH 80 1/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.405,,0.269,0.068,120,"Pipe","SCH 40 1/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel",0.503,0.503,0.393,0.055,240,"Box Tube",,"Commodity 'Half inch box or square tube'",11/19/2008,"Winston" "Steel or Brass",0.54,,0.302,0.119,120,"Pipe","SCH 80 1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.54,,0.364,0.088,120,"Pipe","SCH 40 1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.675,,0.423,0.126,120,"Pipe","SCH 80 3/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.675,,0.493,0.091,120,"Pipe","SCH 40 3/8” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.84,,0.546,0.147,120,"Pipe","SCH 80 1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",0.84,,0.622,0.109,120,"Pipe","SCH 40 1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.05,,0.824,0.113,120,"Pipe","SCH 40 3/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.05,,0.742,0.154,120,"Pipe","SCH 80 3/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Aluminum",1.244,,1.188,0.028,1.93,"Cup and Lid","Matte oxide finish","Metal 35 mm film canister W/ threaded lid",11/18/2008,"Winston" "Plastic",1.26,,1.16,0.05,2.013,"Cup and Lid","Light Gray body, Black cap","Plastic 35 mm film canister W/Snap Lid",11/18/2008,"Winston" "Steel or Brass",1.315,,1.049,0.133,120,"Pipe","SCH 40 1” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.315,,0.957,0.179,120,"Pipe","SCH 80 1” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.66,,1.38,0.14,120,"Pipe","SCH 40 1-1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.66,,1.278,0.191,120,"Pipe","SCH 80 1-1/4” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "HDPE",1.67,,1.604,0.033,1.67,"Cup","Transluce nt white color","Protective cap from a 200 mL dispenser of GoJo Provon Antibacterial Handwash",11/18/2008,"Winston" "Steel or Brass",1.9,,1.5,0.2,120,"Pipe","SCH 80 1-1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",1.9,,1.61,0.145,120,"Pipe","SCH 40 1-1/2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",2.375,,1.939,0.218,120,"Pipe","SCH 80 2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Steel or Brass",2.375,,2.067,0.154,120,"Pipe","SCH 40 2” Note 1","Black or galvanized “Iron” also brass pipe",11/19/2008,"Jim Wilkins" "Aluminum, Plastic Coated",3.5,,,0.004,8.12,"Sheet",,"Cola can, slit open and laid flat",11/19/2008,"Winston" ,,,,,,,,,, ,,,,,,,,,, "Note 1: “Black” and galvanized Iron Pipe, Brass Pipe",,,,,,,,,, "Brass pipe seems to be very close to these numbers. Iron pipe is sloppier and not always round, especially at the weld line, but it's easy to buy locally on nights and weekends.",,,,,,,,,, "The numbers are from Machinery's Handbook 23, pp 2380, 2381, which also give Moment of Inertia, Radius of Gyration, Sectional Modulus, etc.",,,,,,,,,, "Notice that 1"" fits easily into 1-1/4"", also 1-1/2"" into 2"", and ¾"" may be a tight fit into 1"". To make them telescope well, bore a cap for the larger pipe and turn one down for the end of the",,,,,,,,,, "inner one. 1/4"", 3/8"" and 1/2"" brass pipe nipples can be bored to make bearings for 3/8"", 1/2"" and 5/8"" shafts. Jim Wilkins 11/19/2008",,,,,,,,,, *****Copy and save the preceding as 'CircularFile.csv' then import it ****** *****Copy and save the following as 'MetricPage.csv' then import it on to page two which you will rename 'Metric'****** "This is The Circular File, Metric Version. Don't Sort This Sheet. Sort the Imperial sheet only!",,,,,,,,,,,, "=IF (Imperial.A20;Imperial.A2;"""")",,,,,,,,,,,, "=IF (Imperial.A30;Imperial.A3;"""")",,,,,,,,,,,, ,,,,,,,,,,,, "=IF (Imperial.A40;Imperial.A4;"""")","=IF (Imperial.B40;Imperial.B4;"""")",,"=IF (Imperial.D50;Imperial.D5;"""")","=IF (Imperial.E50;Imperial.E5;"""")","=IF (Imperial.F50;Imperial.F5;"""")",,,,,,, "=IF (Imperial.A60;Imperial.A6;"""")","=IF (Imperial.B50;Imperial.B5;"""")","=IF (Imperial.C60;Imperial.C6;"""")","=IF (Imperial.D60;Imperial.D6;"""")","=IF (Imperial.E60;Imperial.E6;"""")","=IF (Imperial.F60;Imperial.F6;"""")","=IF (Imperial.G60;Imperial.G6;"""")","=IF (Imperial.H60;Imperial.H6;"""")","=IF (Imperial.I60;Imperial.I6;"""")","=IF (Imperial.J60;Imperial.J6;"""")","=IF (Imperial.K60;Imperial.K6;"""")",, ,"=IF (Imperial.B60;Imperial.B6;"""")","=IF (Imperial.C70;Imperial.C7;"""")","=IF (Imperial.D70;Imperial.D7;"""")","=IF (Imperial.E70;Imperial.E7;"""")","=IF (Imperial.F70;Imperial.F7;"""")",,,,,,, "=IF (Imperial.A70;Imperial.A7;"""")","=IF (Imperial.B70;Imperial.B7;"""")","=IF (Imperial.C80;Imperial.C8;"""")",,,,,,,,,"=IF (Imperial.L70;Imperial.L7;"""")", ,"mm","mm","mm","mm","mm",,,,,,, "=IF (Imperial.A90;Imperial.A9;"""")",,"=IF (Imperial.C100;Imperial.C10*25.4;"""")","=IF (Imperial.D100;Imperial.D10*25.4;"""")","=IF (Imperial.E100;Imperial.E10*25.4;"""")",,"=IF (Imperial.G90;Imperial.G9;"""")","=IF (Imperial.H90;Imperial.H9;"""")","=IF (Imperial.I90;Imperial.I9;"""")","=IF (Imperial.J90;Imperial.J9;"""")","=IF (Imperial.K90;Imperial.K9;"""")","=IF (Imperial.L100;Imperial.L10;"""")","=IF (Imperial.M100;Imperial.M10;"""")" "=IF (Imperial.A100;Imperial.A10;"""")","=IF (Imperial.B100;Imperial.B10*25.4;"""")","=IF (Imperial.C100;Imperial.C10*25.4;"""")","=IF (Imperial.D100;Imperial.D10*25.4;"""")","=IF (Imperial.E100;Imperial.E10*25.4;"""")","=IF (Imperial.F100;Imperial.F10*25.4;"""")","=IF (Imperial.G100;Imperial.G10;"""")","=IF (Imperial.H100;Imperial.H10;"""")","=IF (Imperial.I100;Imperial.I10;"""")","=IF (Imperial.J100;Imperial.J10;"""")","=IF (Imperial.K100;Imperial.K10;"""")",, "=IF (Imperial.A110;Imperial.A11;"""")","=IF (Imperial.B110;Imperial.B11*25.4;"""")","=IF (Imperial.C110;Imperial.C11*25.4;"""")","=IF (Imperial.D110;Imperial.D11*25.4;"""")","=IF (Imperial.E110;Imperial.E11*25.4;"""")","=IF (Imperial.F110;Imperial.F11*25.4;"""")","=IF (Imperial.G110;Imperial.G11;"""")","=IF (Imperial.H110;Imperial.H11;"""")","=IF (Imperial.I110;Imperial.I11;"""")","=IF (Imperial.J110;Imperial.J11;"""")","=IF (Imperial.K110;Imperial.K11;"""")",, "=IF (Imperial.A120;Imperial.A12;"""")","=IF (Imperial.B120;Imperial.B12*25.4;"""")","=IF (Imperial.C120;Imperial.C12*25.4;"""")","=IF (Imperial.D120;Imperial.D12*25.4;"""")","=IF (Imperial.E120;Imperial.E12*25.4;"""")","=IF (Imperial.F120;Imperial.F12*25.4;"""")","=IF (Imperial.G120;Imperial.G12;"""")","=IF (Imperial.H120;Imperial.H12;"""")","=IF (Imperial.I120;Imperial.I12;"""")","=IF (Imperial.J120;Imperial.J12;"""")","=IF (Imperial.K120;Imperial.K12;"""")",, "=IF (Imperial.A130;Imperial.A13;"""")","=IF (Imperial.B130;Imperial.B13*25.4;"""")","=IF (Imperial.C130;Imperial.C13*25.4;"""")","=IF (Imperial.D130;Imperial.D13*25.4;"""")","=IF (Imperial.E130;Imperial.E13*25.4;"""")","=IF (Imperial.F130;Imperial.F13*25.4;"""")","=IF (Imperial.G130;Imperial.G13;"""")","=IF (Imperial.H130;Imperial.H13;"""")","=IF (Imperial.I130;Imperial.I13;"""")","=IF (Imperial.J130;Imperial.J13;"""")","=IF (Imperial.K130;Imperial.K13;"""")",, "=IF (Imperial.A140;Imperial.A14;"""")","=IF (Imperial.B140;Imperial.B14*25.4;"""")","=IF (Imperial.C140;Imperial.C14*25.4;"""")","=IF (Imperial.D140;Imperial.D14*25.4;"""")","=IF (Imperial.E140;Imperial.E14*25.4;"""")","=IF (Imperial.F140;Imperial.F14*25.4;"""")","=IF (Imperial.G140;Imperial.G14;"""")","=IF (Imperial.H140;Imperial.H14;"""")","=IF (Imperial.I140;Imperial.I14;"""")","=IF (Imperial.J140;Imperial.J14;"""")","=IF (Imperial.K140;Imperial.K14;"""")",, "=IF (Imperial.A150;Imperial.A15;"""")","=IF (Imperial.B150;Imperial.B15*25.4;"""")","=IF (Imperial.C150;Imperial.C15*25.4;"""")","=IF (Imperial.D150;Imperial.D15*25.4;"""")","=IF (Imperial.E150;Imperial.E15*25.4;"""")","=IF (Imperial.F150;Imperial.F15*25.4;"""")","=IF (Imperial.G150;Imperial.G15;"""")","=IF (Imperial.H150;Imperial.H15;"""")","=IF (Imperial.I150;Imperial.I15;"""")","=IF (Imperial.J150;Imperial.J15;"""")","=IF (Imperial.K150;Imperial.K15;"""")",, "=IF (Imperial.A160;Imperial.A16;"""")","=IF (Imperial.B160;Imperial.B16*25.4;"""")","=IF (Imperial.C160;Imperial.C16*25.4;"""")","=IF (Imperial.D160;Imperial.D16*25.4;"""")","=IF (Imperial.E160;Imperial.E16*25.4;"""")","=IF (Imperial.F160;Imperial.F16*25.4;"""")","=IF (Imperial.G160;Imperial.G16;"""")","=IF (Imperial.H160;Imperial.H16;"""")","=IF (Imperial.I160;Imperial.I16;"""")","=IF (Imperial.J160;Imperial.J16;"""")","=IF (Imperial.K160;Imperial.K16;"""")",, "=IF (Imperial.A170;Imperial.A17;"""")","=IF (Imperial.B170;Imperial.B17*25.4;"""")","=IF (Imperial.C170;Imperial.C17*25.4;"""")","=IF (Imperial.D170;Imperial.D17*25.4;"""")","=IF (Imperial.E170;Imperial.E17*25.4;"""")","=IF (Imperial.F170;Imperial.F17*25.4;"""")","=IF (Imperial.G170;Imperial.G17;"""")","=IF (Imperial.H170;Imperial.H17;"""")","=IF (Imperial.I170;Imperial.I17;"""")","=IF (Imperial.J170;Imperial.J17;"""")","=IF (Imperial.K170;Imperial.K17;"""")",, "=IF (Imperial.A180;Imperial.A18;"""")","=IF (Imperial.B180;Imperial.B18*25.4;"""")","=IF (Imperial.C180;Imperial.C18*25.4;"""")","=IF (Imperial.D180;Imperial.D18*25.4;"""")","=IF (Imperial.E180;Imperial.E18*25.4;"""")","=IF (Imperial.F180;Imperial.F18*25.4;"""")","=IF (Imperial.G180;Imperial.G18;"""")","=IF (Imperial.H180;Imperial.H18;"""")","=IF (Imperial.I180;Imperial.I18;"""")","=IF (Imperial.J180;Imperial.J18;"""")","=IF (Imperial.K180;Imperial.K18;"""")",, "=IF (Imperial.A190;Imperial.A19;"""")","=IF (Imperial.B190;Imperial.B19*25.4;"""")","=IF (Imperial.C190;Imperial.C19*25.4;"""")","=IF (Imperial.D190;Imperial.D19*25.4;"""")","=IF (Imperial.E190;Imperial.E19*25.4;"""")","=IF (Imperial.F190;Imperial.F19*25.4;"""")","=IF (Imperial.G190;Imperial.G19;"""")","=IF (Imperial.H190;Imperial.H19;"""")","=IF (Imperial.I190;Imperial.I19;"""")","=IF (Imperial.J190;Imperial.J19;"""")","=IF (Imperial.K190;Imperial.K19;"""")",, "=IF (Imperial.A200;Imperial.A20;"""")","=IF (Imperial.B200;Imperial.B20*25.4;"""")","=IF (Imperial.C200;Imperial.C20*25.4;"""")","=IF (Imperial.D200;Imperial.D20*25.4;"""")","=IF (Imperial.E200;Imperial.E20*25.4;"""")","=IF (Imperial.F200;Imperial.F20*25.4;"""")","=IF (Imperial.G200;Imperial.G20;"""")","=IF (Imperial.H200;Imperial.H20;"""")","=IF (Imperial.I200;Imperial.I20;"""")","=IF (Imperial.J200;Imperial.J20;"""")","=IF (Imperial.K200;Imperial.K20;"""")",, "=IF (Imperial.A210;Imperial.A21;"""")","=IF (Imperial.B210;Imperial.B21*25.4;"""")","=IF (Imperial.C210;Imperial.C21*25.4;"""")","=IF (Imperial.D210;Imperial.D21*25.4;"""")","=IF (Imperial.E210;Imperial.E21*25.4;"""")","=IF (Imperial.F210;Imperial.F21*25.4;"""")","=IF (Imperial.G210;Imperial.G21;"""")","=IF (Imperial.H210;Imperial.H21;"""")","=IF (Imperial.I210;Imperial.I21;"""")","=IF (Imperial.J210;Imperial.J21;"""")","=IF (Imperial.K210;Imperial.K21;"""")",, "=IF (Imperial.A220;Imperial.A22;"""")","=IF (Imperial.B220;Imperial.B22*25.4;"""")","=IF (Imperial.C220;Imperial.C22*25.4;"""")","=IF (Imperial.D220;Imperial.D22*25.4;"""")","=IF (Imperial.E220;Imperial.E22*25.4;"""")","=IF (Imperial.F220;Imperial.F22*25.4;"""")","=IF (Imperial.G220;Imperial.G22;"""")","=IF (Imperial.H220;Imperial.H22;"""")","=IF (Imperial.I220;Imperial.I22;"""")","=IF (Imperial.J220;Imperial.J22;"""")","=IF (Imperial.K220;Imperial.K22;"""")",, "=IF (Imperial.A230;Imperial.A23;"""")","=IF (Imperial.B230;Imperial.B23*25.4;"""")","=IF (Imperial.C230;Imperial.C23*25.4;"""")","=IF (Imperial.D230;Imperial.D23*25.4;"""")","=IF (Imperial.E230;Imperial.E23*25.4;"""")","=IF (Imperial.F230;Imperial.F23*25.4;"""")","=IF (Imperial.G230;Imperial.G23;"""")","=IF (Imperial.H230;Imperial.H23;"""")","=IF (Imperial.I230;Imperial.I23;"""")","=IF (Imperial.J230;Imperial.J23;"""")","=IF (Imperial.K230;Imperial.K23;"""")",, "=IF (Imperial.A240;Imperial.A24;"""")","=IF (Imperial.B240;Imperial.B24*25.4;"""")","=IF (Imperial.C240;Imperial.C24*25.4;"""")","=IF (Imperial.D240;Imperial.D24*25.4;"""")","=IF (Imperial.E240;Imperial.E24*25.4;"""")","=IF (Imperial.F240;Imperial.F24*25.4;"""")","=IF (Imperial.G240;Imperial.G24;"""")","=IF (Imperial.H240;Imperial.H24;"""")","=IF (Imperial.I240;Imperial.I24;"""")","=IF (Imperial.J240;Imperial.J24;"""")","=IF (Imperial.K240;Imperial.K24;"""")",, "=IF (Imperial.A250;Imperial.A25;"""")","=IF (Imperial.B250;Imperial.B25*25.4;"""")","=IF (Imperial.C250;Imperial.C25*25.4;"""")","=IF (Imperial.D250;Imperial.D25*25.4;"""")","=IF (Imperial.E250;Imperial.E25*25.4;"""")","=IF (Imperial.F250;Imperial.F25*25.4;"""")","=IF (Imperial.G250;Imperial.G25;"""")","=IF (Imperial.H250;Imperial.H25;"""")","=IF (Imperial.I250;Imperial.I25;"""")","=IF (Imperial.J250;Imperial.J25;"""")","=IF (Imperial.K250;Imperial.K25;"""")",, "=IF (Imperial.A260;Imperial.A26;"""")","=IF (Imperial.B260;Imperial.B26*25.4;"""")","=IF (Imperial.C260;Imperial.C26*25.4;"""")","=IF (Imperial.D260;Imperial.D26*25.4;"""")","=IF (Imperial.E260;Imperial.E26*25.4;"""")","=IF (Imperial.F260;Imperial.F26*25.4;"""")","=IF (Imperial.G260;Imperial.G26;"""")","=IF (Imperial.H260;Imperial.H26;"""")","=IF (Imperial.I260;Imperial.I26;"""")","=IF (Imperial.J260;Imperial.J26;"""")","=IF (Imperial.K260;Imperial.K26;"""")",, "=IF (Imperial.A270;Imperial.A27;"""")","=IF (Imperial.B270;Imperial.B27*25.4;"""")","=IF (Imperial.C270;Imperial.C27*25.4;"""")","=IF (Imperial.D270;Imperial.D27*25.4;"""")","=IF (Imperial.E270;Imperial.E27*25.4;"""")","=IF (Imperial.F270;Imperial.F27*25.4;"""")","=IF (Imperial.G270;Imperial.G27;"""")","=IF (Imperial.H270;Imperial.H27;"""")","=IF (Imperial.I270;Imperial.I27;"""")","=IF (Imperial.J270;Imperial.J27;"""")","=IF (Imperial.K270;Imperial.K27;"""")",, "=IF (Imperial.A280;Imperial.A28;"""")","=IF (Imperial.B280;Imperial.B28*25.4;"""")","=IF (Imperial.C280;Imperial.C28*25.4;"""")","=IF (Imperial.D280;Imperial.D28*25.4;"""")","=IF (Imperial.E280;Imperial.E28*25.4;"""")","=IF (Imperial.F280;Imperial.F28*25.4;"""")","=IF (Imperial.G280;Imperial.G28;"""")","=IF (Imperial.H280;Imperial.H28;"""")","=IF (Imperial.I280;Imperial.I28;"""")","=IF (Imperial.J280;Imperial.J28;"""")","=IF (Imperial.K280;Imperial.K28;"""")",, "=IF (Imperial.A290;Imperial.A29;"""")","=IF (Imperial.B290;Imperial.B29*25.4;"""")","=IF (Imperial.C290;Imperial.C29*25.4;"""")","=IF (Imperial.D290;Imperial.D29*25.4;"""")","=IF (Imperial.E290;Imperial.E29*25.4;"""")","=IF (Imperial.F290;Imperial.F29*25.4;"""")","=IF (Imperial.G290;Imperial.G29;"""")","=IF (Imperial.H290;Imperial.H29;"""")","=IF (Imperial.I290;Imperial.I29;"""")","=IF (Imperial.J290;Imperial.J29;"""")","=IF (Imperial.K290;Imperial.K29;"""")",, "=IF (Imperial.A300;Imperial.A30;"""")","=IF (Imperial.B300;Imperial.B30*25.4;"""")","=IF (Imperial.C300;Imperial.C30*25.4;"""")","=IF (Imperial.D300;Imperial.D30*25.4;"""")","=IF (Imperial.E300;Imperial.E30*25.4;"""")","=IF (Imperial.F300;Imperial.F30*25.4;"""")","=IF (Imperial.G300;Imperial.G30;"""")","=IF (Imperial.H300;Imperial.H30;"""")","=IF (Imperial.I300;Imperial.I30;"""")","=IF (Imperial.J300;Imperial.J30;"""")","=IF (Imperial.K300;Imperial.K30;"""")",, "=IF (Imperial.A310;Imperial.A31;"""")","=IF (Imperial.B310;Imperial.B31*25.4;"""")","=IF (Imperial.C310;Imperial.C31*25.4;"""")","=IF (Imperial.D310;Imperial.D31*25.4;"""")","=IF (Imperial.E310;Imperial.E31*25.4;"""")","=IF (Imperial.F310;Imperial.F31*25.4;"""")","=IF (Imperial.G310;Imperial.G31;"""")","=IF (Imperial.H310;Imperial.H31;"""")","=IF (Imperial.I310;Imperial.I31;"""")","=IF (Imperial.J310;Imperial.J31;"""")","=IF (Imperial.K310;Imperial.K31;"""")",, "=IF (Imperial.A320;Imperial.A32;"""")","=IF (Imperial.B320;Imperial.B32*25.4;"""")","=IF (Imperial.C320;Imperial.C32*25.4;"""")","=IF (Imperial.D320;Imperial.D32*25.4;"""")","=IF (Imperial.E320;Imperial.E32*25.4;"""")","=IF (Imperial.F320;Imperial.F32*25.4;"""")","=IF (Imperial.G320;Imperial.G32;"""")","=IF (Imperial.H320;Imperial.H32;"""")","=IF (Imperial.I320;Imperial.I32;"""")","=IF (Imperial.J320;Imperial.J32;"""")","=IF (Imperial.K320;Imperial.K32;"""")",, "=IF (Imperial.A330;Imperial.A33;"""")","=IF (Imperial.B330;Imperial.B33*25.4;"""")","=IF (Imperial.C330;Imperial.C33*25.4;"""")","=IF (Imperial.D330;Imperial.D33*25.4;"""")","=IF (Imperial.E330;Imperial.E33*25.4;"""")","=IF (Imperial.F330;Imperial.F33*25.4;"""")","=IF (Imperial.G330;Imperial.G33;"""")","=IF (Imperial.H330;Imperial.H33;"""")","=IF (Imperial.I330;Imperial.I33;"""")","=IF (Imperial.J330;Imperial.J33;"""")","=IF (Imperial.K330;Imperial.K33;"""")",, "=IF (Imperial.A340;Imperial.A34;"""")","=IF (Imperial.B340;Imperial.B34*25.4;"""")","=IF (Imperial.C340;Imperial.C34*25.4;"""")","=IF (Imperial.D340;Imperial.D34*25.4;"""")","=IF (Imperial.E340;Imperial.E34*25.4;"""")","=IF (Imperial.F340;Imperial.F34*25.4;"""")","=IF (Imperial.G340;Imperial.G34;"""")","=IF (Imperial.H340;Imperial.H34;"""")","=IF (Imperial.I340;Imperial.I34;"""")","=IF (Imperial.J340;Imperial.J34;"""")","=IF (Imperial.K340;Imperial.K34;"""")",, "=IF (Imperial.A350;Imperial.A35;"""")","=IF (Imperial.B350;Imperial.B35*25.4;"""")","=IF (Imperial.C350;Imperial.C35*25.4;"""")","=IF (Imperial.D350;Imperial.D35*25.4;"""")","=IF (Imperial.E350;Imperial.E35*25.4;"""")","=IF (Imperial.F350;Imperial.F35*25.4;"""")","=IF (Imperial.G350;Imperial.G35;"""")","=IF (Imperial.H350;Imperial.H35;"""")","=IF (Imperial.I350;Imperial.I35;"""")","=IF (Imperial.J350;Imperial.J35;"""")","=IF (Imperial.K350;Imperial.K35;"""")",, ,,,,,"=IF (Imperial.F360;Imperial.F36*25.4;"""")","=IF (Imperial.G360;Imperial.G36;"""")","=IF (Imperial.H360;Imperial.H36;"""")","=IF (Imperial.I360;Imperial.I36;"""")","=IF (Imperial.J360;Imperial.J36;"""")","=IF (Imperial.K360;Imperial.K36;"""")",, "=IF (Imperial.A370;Imperial.A37;"""")","=IF (Imperial.B380;Imperial.B38*25.4;"""")","=IF (Imperial.C380;Imperial.C38*25.4;"""")","=IF (Imperial.E380;Imperial.E38*25.4;"""")","=IF (Imperial.F380;Imperial.F38*25.4;"""")","=IF (Imperial.G380;Imperial.G38;"""")","=IF (Imperial.H380;Imperial.H38;"""")","=IF (Imperial.H370;Imperial.H37;"""")","=IF (Imperial.I370;Imperial.I37;"""")","=IF (Imperial.J370;Imperial.J37;"""")",,, "=IF (Imperial.A380;Imperial.A38;"""")",,,,,,,,,,,, "=IF (Imperial.A390;Imperial.A39;"""")",,,,,,,,,,,, "=IF (Imperial.A420;Imperial.A42;"""")",,,,,,,,,,,, "=IF (Imperial.A430;Imperial.A43;"""")",,,,,,,,,,,, "=IF (Imperial.A430;Imperial.A43;"""")",,,,,,,,,,,, "=IF (Imperial.A450;Imperial.A45;"""")",,,,,,,,,,,, "=IF (Imperial.A460;Imperial.A46;"""")","=IF (Imperial.B470;Imperial.B47*25.4;"""")","=IF (Imperial.C470;Imperial.C47*25.4;"""")","=IF (Imperial.E470;Imperial.E47*25.4;"""")","=IF (Imperial.F470;Imperial.F47*25.4;"""")","=IF (Imperial.G470;Imperial.G47;"""")","=IF (Imperial.H470;Imperial.H47;"""")","=IF (Imperial.I470;Imperial.I47;"""")","=IF (Imperial.J470;Imperial.J47;"""")","=IF (Imperial.K470;Imperial.K47;"""")",,, "=IF (Imperial.A470;Imperial.A47;"""")","=IF (Imperial.B480;Imperial.B48*25.4;"""")","=IF (Imperial.C480;Imperial.C48*25.4;"""")","=IF (Imperial.E480;Imperial.E48*25.4;"""")","=IF (Imperial.F480;Imperial.F48*25.4;"""")","=IF (Imperial.G480;Imperial.G48;"""")","=IF (Imperial.H480;Imperial.H48;"""")","=IF (Imperial.I480;Imperial.I48;"""")","=IF (Imperial.J480;Imperial.J48;"""")","=IF (Imperial.K480;Imperial.K48;"""")",,, "=IF (Imperial.A480;Imperial.A48;"""")",,,,,,,,,,,, "=IF (Imperial.A490;Imperial.A49;"""")",,,,,,,,,,,, *****Copy and save the preceding as 'MetricPage.csv' then import it ****** Remember to globally replace the semicolon delimiters with commas if you are using Excel rather than OpenOffice. As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#9
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-20, Winston wrote:
DoN. Nichols wrote: (...) I have a question. Are the lines folded before you read it into the newsreader? No, many are single line monsters, but I think I know what you mean. You should find the same thing I did; that the wrapped lines automagically 'unfold' when pasted into a text editor. No worries. Well ... cut and paste into jove using CDE as the window manager leaves the folds in place. The first time, the folds wound up breaking pairs of quote marks, and things were rather broken up. The second time, (for whatever reason) the line breaks were not between quote mark pairs, and things were fine when I opened it in StarOffice. I think that an attachment might preserve the lines better. (I've read it into Sun's StarOffice (their version of OpenOffice) and it seems happy enough anyway. I would be pleased to post it as an attachment, but I don't know how well that would comply to the group charter. As you imply, I would like to keep the list as safe and universally useful as possible. I think that attachments of plain text (which is what this is) are fine. attachment of binaries (images, compiled programs, and the sort are non-starters -- including Windows .DOC files, which have a lot of binary garbage in the, and the possibility of macro viruses as well. :-) I don't know whether I will every have the time to do the kind of inventory needed, however. And I'm not accustomed to using spreadsheets, so I may have a learning curve. I add one item at a time. My earlier posts look like I was angling for everyone to inventory every- thing in their shop. Not The Case. I'm mostly looking for mass produced parts that are normally thrown away which have some potential for reuse. Oh -- not things like the remaining lengths of hex 12L14 (6' and less) and other purchased bar or sheet stock. The precision shafts in old 5.25" floppy drives, for instance. O.K. There are also nice bearings in hard drives as well --sometime difficult to extract cleanly. You are a smart cookie, DoN. That spreadsheet learning curve looks flat to me. Given the motivation. About the only spreadsheet which I have used is sc (Spreadsheet Calculator) which came in source code format, and to which I added a "modulo" operator to make calculating time values easier when I was producing a couple of recordings (60 minutes each on two cassettes). That was back in about 1984 or so, and I've used that only a couple of times sense. Spreadsheets just don't seem to be tailored to do what I want -- I use either C language programs, shell scripts, or programs like awk and sed processing plain text files to do things which I want. In particular, it is not clear how I was supposed to add the "second page" for metric materials. The first thought was to use my preferred text editor on the raw file, but that probably would miss some things which would flag it as the "second page". You intuit properly. The second page is handled just as the first was. Highlight the text and save it (CTRL-C). Hmm ... already an assumption for how a program works which does not fit mutt (my e-mail client) or slrn (my newsreader). :-) Open your favorite text editor and paste (CTRL-V). Again -- CTRL-V is not how paste would work in my system. I would just highlight in the one window, and then a single middle mouse button click would paste that into another window -- even one logged into a different system. Save the new file as say, 'Metric.csv' O.K. Pop open the spreadsheet you created (with the Imperial information) and open the 'page two' tab (or sheet). O.K. I had not noticed that. Tell the spreadsheet program to open your file named 'Metric.csv'. It should ask you a couple questions about delimiters. After you accept the defaults, it should display the conversions properly. Just resize the column width and Bob's your uncle. O.K. Let me caution you that at this very early stage, the sheet is still in flux. Mismatches between versions will happen. When in doubt, just tell me you want both sheets and I will post matching versions. Good enough. At least it does not require a Windows program, at which point I would have simply walked off. :-) I'm trying to 'tune for maximum usefulness' so a Wintel specific answer would be a non-starter. :-) The first 10,000 items will be the hardest. :-) BTW Is the GoJo container empty or still loaded with GoJo? Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#10
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
On 2008-11-20, Winston wrote: DoN. Nichols wrote: (...) The second time, (for whatever reason) the line breaks were not between quote mark pairs, and things were fine when I opened it in StarOffice. I took your advice and published the latest version as an attachment. I've eliminated the second tab (or sheet) so both the Imperial and Metric versions are on the same page. Please let me know if this works better for you. I know it worked better for me! (...) Oh -- not things like the remaining lengths of hex 12L14 (6' and less) and other purchased bar or sheet stock. I'm not going to dictate what materials show up in the sheet. If you find it is useful, then it goes in. Example: Jim Wilkins added various sizes of iron and brass pipe along with some excellent usage notes. Example: I added 1/2" square tube stock. I found it to be very useful, so it's in. Having said that, I would like emphasize that the larger goal is to provide millions of 'eureka' moments. I want to give us hobbyists cheap or free sources of parts that we might not have thought about before. Example: The 4 mm diameter, 88 mm long precision shafts I scrapped out of the aforementioned floppy drives work perfectly as 'tommy bars' for adjusting my lathe chucks. Their extra length allows my weak, tired old hands to properly adjust the chucks much more easily that do the stock bars provided for the purpose. Those shafts will show up in the next edition of the Circular File. O.K. There are also nice bearings in hard drives as well --sometime difficult to extract cleanly. That is the area we need to explore. Magnets I extracted from HD voicecoil drives work great holding up prints, for example. The super flat disks themselves could see second life as fancy hubcaps for your next robot. The flat pancake motor in the floppy drives are just begging for a purpose! I just want us to take greater advantage of the stuff we might otherwise throw away. (...) Spreadsheets just don't seem to be tailored to do what I want -- I use either C language programs, shell scripts, or programs like awk and sed processing plain text files to do things which I want. After the Circular File firms up in structure, feel free to write an awk script to convert the .csv for use in your favorite database program. No one said you must use it in spreadsheet form!  The spreadsheet is just the most convenient format I could envision. Now that everything is on one page, the Circular File just became much more accessible for everybody. And thanks you you, DoN the distribution process is much cleaner because it is an attachment rather than inline. (...) BTW Is the GoJo container empty or still loaded with GoJo? I'm on my last bottle, but never fear because I ordered a new case of them yesterday! That is good stuff! --Winston |
|
#11
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-21, Winston wrote:
DoN. Nichols wrote: On 2008-11-20, Winston wrote: DoN. Nichols wrote: (...) The second time, (for whatever reason) the line breaks were not between quote mark pairs, and things were fine when I opened it in StarOffice. I took your advice and published the latest version as an attachment. I've eliminated the second tab (or sheet) so both the Imperial and Metric versions are on the same page. Aha! That explains why it did not split into two sheets in StarOffice -- and perhaps why when I tried to split it into two with an editor and read it in as you suggested (modulo some difference in OpenOffice vs StarOffice) it would only save one sheet at a time. Please let me know if this works better for you. I know it worked better for me! It did indeed. [ ... ] Having said that, I would like emphasize that the larger goal is to provide millions of 'eureka' moments. I want to give us hobbyists cheap or free sources of parts that we might not have thought about before. So -- the purpose is to give others ideas on what to save and (possibly) what to use them for, not to make a nationwide or worldwide pool of parts which would require shipping back and forth. [ ... ] O.K. There are also nice bearings in hard drives as well --sometime difficult to extract cleanly. That is the area we need to explore. Magnets I extracted from HD voicecoil drives work great holding up prints, for example. I've got a bunch of those super magnets doing various things up here (including holding a sheet of posterboard to a really rack to keep the sun from shining in my eyes while I'm working at the computer. Two magnets allow me to position it firmly. another holds an aluminum yardstick to the rack. Others control the run of cables. (And none are used for storing floppies to the rack. :-) The super flat disks themselves could see second life as fancy hubcaps for your next robot. Or be used as rotors in Tesla turbines. :-) The flat pancake motor in the floppy drives are just begging for a purpose! I just want us to take greater advantage of the stuff we might otherwise throw away. Good enough. (...) Spreadsheets just don't seem to be tailored to do what I want -- I use either C language programs, shell scripts, or programs like awk and sed processing plain text files to do things which I want. After the Circular File firms up in structure, feel free to write an awk script to convert the .csv for use in your favorite database program. No one said you must use it in spreadsheet form! O.K. That sounds reasonable and flexible. The spreadsheet is just the most convenient format I could envision. Now that everything is on one page, the Circular File just became much more accessible for everybody. And thanks you you, DoN the distribution process is much cleaner because it is an attachment rather than inline. (...) BTW Is the GoJo container empty or still loaded with GoJo? I'm on my last bottle, but never fear because I ordered a new case of them yesterday! That is good stuff! But are you listing the empty containers for future use? I'm keeping the clear plastic boxes for Trader Joe's chocolates for storing small parts related to a given project. Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#12
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
On 2008-11-21, Winston wrote: (...) Please let me know if this works better for you. I know it worked better for me! It did indeed. Good! Having said that, I would like emphasize that the larger goal is to provide millions of 'eureka' moments. I want to give us hobbyists cheap or free sources of parts that we might not have thought about before. So -- the purpose is to give others ideas on what to save and (possibly) what to use them for, Every user will have their own purposes, I think. I really hope to be amazed and gratified to hear how folks use this tool. I'm here to learn (tm). My favorite scenario goes something like: I'm sketching away on CAD when I realize that I need a float for my latest methane digester project. Nothing fancy, just a part for a proof-of-concept model. A smallish hollow non-conductive... something. I pop open my Circular File sheet and sort on materials. In the generic 'Plastic' category there isn't much but EUREKA! In the HDPE parts there are several bottles that would fill the bill nicely. I sort through my carefully organized bottle container and There It Is! I am good to go, quickly and for No Money. Another example: Fiona Schwartz (not her real name) finds that she needs a couple square inches of aluminum, thicker than foil but much thinner than any of her sheet stock, say 3 to 5 thou or so. She cranks up her copy of the Circular File and sorts it by 'Material' and 'Nominal Wall Thickness'. Viola! She might not have considered it before, but she sees an entry for an aluminum cola can at 0.004" wall thickness. The polymer coating won't interfere with her application, so she finishes her cola and snips out her prototype parts quickly and for No Money! (...)not to make a nationwide or worldwide pool of parts which would require shipping back and forth. As you imply, it's just not practical to pay 8 smackers to ship a part that most would describe as worthless. I'm willing to listen to ways that we could share parts economically but that was never on my radar as a top ten goal. (...) I've got a bunch of those super magnets doing various things up here (including holding a sheet of posterboard to a really rack to keep the sun from shining in my eyes while I'm working at the computer. Two magnets allow me to position it firmly. another holds an aluminum yardstick to the rack. Others control the run of cables. I have one that holds my DMM leads for perfect accessibility on my workbench and half a dozen more holding up paper for ready reference. (And none are used for storing floppies to the rack. :-) So.. that wouldn't work? The super flat disks themselves could see second life as fancy hubcaps for your next robot. Or be used as rotors in Tesla turbines. :-) YEAH! (...) BTW Is the GoJo container empty or still loaded with GoJo? I'm on my last bottle, but never fear because I ordered a new case of them yesterday! That is good stuff! But are you listing the empty containers for future use? I'm keeping the clear plastic boxes for Trader Joe's chocolates for storing small parts related to a given project. That's what I'm talking about! I finally figured out I can refill the GoJo containers from a 1 gallon jug and save 38 smackers per dozen. I'm a recycling kinda guy. Wait till I free up some of those containers; they will get filed. You bet the empty gallon bottle will go in the file, too. --Winston |
|
#13
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Nov 22, 2:31*am, Winston wrote:
DoN. Nichols wrote: On 2008-11-21, Winston wrote:..... Having said that, I would like emphasize that the larger goal is to provide millions of 'eureka' moments. I want to give us hobbyists cheap or free sources of parts that we might not have thought about before. I bought an assortment of gas and TIG rod from my welding supplier to use as small-diameter shafts and bent shapes. He had steel up to 1/4', brass and stainless to 3/16". My favorite scenario goes something like: I'm sketching away on CAD when I realize that I need ..... There is a psychology experiment that shows most people think of objects in terms of what they are meant to do, rather than as shapes and materials that can be modified or used for a different purpose. I noticed that recently when I snagged some 2-1/2" exhaust pipe cut-offs before the owner put them out in the trash. A bystander's girlfriend wondered why on Earth I wanted discarded rubbish, I saw them as weldable wall thickness and an ID to fit over 2" pipe. Exhaust fittings are another local source for tubing although they aren't accurately round. Aircraft Spruce sells boxes of assorted chrome-moly tubing cutoffs. Someone once mentioned here that blacksmiths go a step further and see steel as shapeless mass, like modeling clay. * *I've got a bunch of those super magnets doing various things ... (And none are used for storing floppies to the rack. :-)... So.. that wouldn't work? * --Winston I stuck a defective floppy to a cabinet with a bright red magnet as a sight gag once, in a government lab. No one ever picked up on it. |
|
#14
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Sat, 22 Nov 2008 06:24:59 -0800 (PST), Jim Wilkins
wrote: snip I stuck a defective floppy to a cabinet with a bright red magnet as a sight gag once, in a government lab. No one ever picked up on it. I stuck a very important floppy to a cork board with a stick pin. This was back in the 5-1/4 days when most floppies had dust jackets too. I was very careful to poke it through the read slot in the case and index hole in the media, dust jacket and all. When the guy came to pick it up we told him it was stuck up on the message board waiting for him. The look on his face when he spotted it and the push-pin was priceless -- Leon Fisk Grand Rapids MI/Zone 5b Remove no.spam for email |
|
#15
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Jim Wilkins wrote:
(...) I bought an assortment of gas and TIG rod from my welding supplier to use as small-diameter shafts and bent shapes. He had steel up to 1/4', brass and stainless to 3/16". We are on the same frequency, Jim. If you happened to mike some leftover scraps of that rod, I would be pleased to add it to the File. My favorite scenario goes something like: I'm sketching away on CAD when I realize that I need ..... There is a psychology experiment that shows most people think of objects in terms of what they are meant to do, rather than as shapes and materials that can be modified or used for a different purpose. I noticed that recently when I snagged some 2-1/2" exhaust pipe cut-offs before the owner put them out in the trash. A bystander's girlfriend wondered why on Earth I wanted discarded rubbish, I saw them as weldable wall thickness and an ID to fit over 2" pipe. That is exactly my point. We are surrounded by resources. We are unaware of too many of them. Exhaust fittings are another local source for tubing although they aren't accurately round. Aircraft Spruce sells boxes of assorted chrome-moly tubing cutoffs. / Broken Record If someone wanted to measure the tubing from one of those assortments, I would love to list those sizes in the File, with a pointer to the source. Broken Record/ Someone once mentioned here that blacksmiths go a step further and see steel as shapeless mass, like modeling clay. And why not? (...) I stuck a defective floppy to a cabinet with a bright red magnet as a sight gag once, in a government lab. No one ever picked up on it. You can bet there were many pairs of rolling eyes. --Winston |
|
#16
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-22, Winston wrote:
DoN. Nichols wrote: On 2008-11-21, Winston wrote: [ ... ] Having said that, I would like emphasize that the larger goal is to provide millions of 'eureka' moments. I want to give us hobbyists cheap or free sources of parts that we might not have thought about before. So -- the purpose is to give others ideas on what to save and (possibly) what to use them for, Every user will have their own purposes, I think. I really hope to be amazed and gratified to hear how folks use this tool. I'm here to learn (tm). So the reason for wanting submissions from others is to get other ideas of what to enter in your personal copy of the list -- not to find items in other's collections. My favorite scenario goes something like: I'm sketching away on CAD when I realize that I need a float for my latest methane digester project. Nothing fancy, just a part for a proof-of-concept model. A smallish hollow non-conductive... something. I pop open my Circular File sheet and sort on materials. In the generic 'Plastic' category there isn't much but EUREKA! In the HDPE parts there are several bottles that would fill the bill nicely. I sort through my carefully organized bottle container and There It Is! I am good to go, quickly and for No Money. O.K. But you also have to remember to remove it from the list (or perhaps add a "count" field, and decrement the count to zero when you take the only one -- that way, the entry is there for future additions of more of the same. This could save the number of lines needed when you have several (or many) of identical or near-identical items. Another interesting (and possibly useful) field would be "personal/for-trade" to remind yourself that you want to hold on to something, or to let someone else nearby (say another member of the local metalworking club) know that there is a possibility of exchange for a given item. Hmm ... perhaps with provisions for a "many" entry instead of a numerical count -- for things like crimp terminals of a given size in a plastic bin. (I've got insulated crimp ring, fork, and spade terminals in wire sizes from 28 Ga to 4/0 and lots of different hole/slot sizes.) Another example: Fiona Schwartz (not her real name) finds that she needs a couple square inches of aluminum, thicker than foil but much thinner than any of her sheet stock, say 3 to 5 thou or so. She cranks up her copy of the Circular File and sorts it by 'Material' and 'Nominal Wall Thickness'. Viola! She might not have considered it before, but she sees an entry for an aluminum cola can at 0.004" wall thickness. The polymer coating won't interfere with her application, so she finishes her cola and snips out her prototype parts quickly and for No Money! Also -- scrap left over from aluminum siding on a house is fairly thin, with a fairly tough plastic skin. I've got one strip of this stapled to the wall to the left of my surface grinder with the bottom two inches folded up into a 'V' to capture the grinding dust otherwise slung against the wall. (...)not to make a nationwide or worldwide pool of parts which would require shipping back and forth. As you imply, it's just not practical to pay 8 smackers to ship a part that most would describe as worthless. I'm willing to listen to ways that we could share parts economically but that was never on my radar as a top ten goal. O.K. Because if I started entering my hex and round bar stock in about 6' lengths, especially the 12L14 -- that would not be going anywhere. It is for *my* future (and as yet unknown) projects. :-) Same for the 5" long 6" diameter 12L14 cylinder -- left from a 6" long one bought from an on-line drops source to make a part for my Nichols horizontal mill. I don't know what it will be used for, but I do remember that it cost more in the shipping than in the material cost. (...) I've got a bunch of those super magnets doing various things up here (including holding a sheet of posterboard to a really rack to keep the sun from shining in my eyes while I'm working at the computer. Two magnets allow me to position it firmly. another holds an aluminum yardstick to the rack. Others control the run of cables. I have one that holds my DMM leads for perfect accessibility on my workbench and half a dozen more holding up paper for ready reference. Hmm ... my (Fluke) DMM leads appear to be tin-plated brass, so the strongest magnet around would do little to hold them. :-) (And none are used for storing floppies to the rack. :-) So.. that wouldn't work? Of course it would -- as long as you wanted the data which was on them to be gone for security reasons. :-) [ ... ] BTW Is the GoJo container empty or still loaded with GoJo? I'm on my last bottle, but never fear because I ordered a new case of them yesterday! That is good stuff! But are you listing the empty containers for future use? I'm keeping the clear plastic boxes for Trader Joe's chocolates for storing small parts related to a given project. That's what I'm talking about! I finally figured out I can refill the GoJo containers from a 1 gallon jug and save 38 smackers per dozen. I'm a recycling kinda guy. Wait till I free up some of those containers; they will get filed. You bet the empty gallon bottle will go in the file, too. At a recent gathering of the local metalworking club (combination yard sale and picnic) I picked up a 1 gallon can which had held "Flux-Off" (for cleaning printed circuit boards after soldering them), and which came with a right-angle faucet. I expect to (after running some compressed air through it for a while to get rid of the remaining solvent dregs) pour in one of my remaining two gallons of Vactra No.2 waylube and store it on a shelf where the faucet can be used to deliver just the right amount without having to lift and tilt the container. (Some 2x4 will be cut to form supports to match the curve of the container.) So -- this is yet another thing which (could go in the list -- except that it already has a planned use. I knew what I was going to use it for when I bought it. :-) BTW As the list grows, it might be good to have a web site, or an FTP site to save it for downloads, and just post the URL. Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#17
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
(...) So the reason for wanting submissions from others is to get other ideas of what to enter in your personal copy of the list -- not to find items in other's collections. That is almost exactly right. Right now, I see that my 'personal copy' of the list will be virtually the same as everyone else's copy. Perhaps as much as one revision later than everyone else's -- but that only means I have one or two more items listed than those shown on the distributed list. I figure that Monday afternoon, I will want a free - or low cost part for a project. I won't necessarily know that I already own several of these parts because they are cleverly disguised as something else. I will end up driving to my local store to pay full list for a tiny bag of parts which are duplicates! That is hugely inefficient in terms of time and money. The Circular File will reveal how I might be able to uncover these parts without ever having to turn the ignition key. I am not interested in the actual physical parts in your collection. Even if you agreed to be my parts warehouse for free, it would be a non-starter because the cost of shipping tends to be some huge multiple of the value of a typical part. I would be time and money ahead just by picking up those parts during a grocery run. I'm keeping my eyes and ears open to ways to change that equation so that I can trade my box of 10-32 socket head machine screws for your box of 6 mm hex nuts, without having to pay shipping, but I don't see how that is even possible; it is not my reason for the File right now. (...) O.K. But you also have to remember to remove it from the list (or perhaps add a "count" field, and decrement the count to zero when you take the only one -- that way, the entry is there for future additions of more of the same. This could save the number of lines needed when you have several (or many) of identical or near-identical items. I did not envision the Circular File as an inventory, local or global. The only reason that a Circular File entry would fall off the list is if that source dried up for a significant number of users. When most soft drinks are packaged in pure plastic cans, our note about the 4 thousanths aluminum sheet source will disappear, for example. If the Circular File evolves into a Global Inventory, that's fine. There are significant stumbling blocks though and as we've seen, most of them are huge show-stoppers. I admit I just don't see that happening. Another interesting (and possibly useful) field would be "personal/for-trade" to remind yourself that you want to hold on to something, or to let someone else nearby (say another member of the local metalworking club) know that there is a possibility of exchange for a given item. That's far outside the 'project charter' as it stands right now. Hmm ... perhaps with provisions for a "many" entry instead of a numerical count -- for things like crimp terminals of a given size in a plastic bin. (I've got insulated crimp ring, fork, and spade terminals in wire sizes from 28 Ga to 4/0 and lots of different hole/slot sizes.) Have a look at Jim Wilkins' File entries on pipe. He shows us that we can make assemblies that telescope or form axles using a very inexpensive part which many of us already have. You probably could combine his entry with a bicycle inner tube to form a rolling - seal pneumatic actuator for (all together now) No Money! (...) Also -- scrap left over from aluminum siding on a house is fairly thin, with a fairly tough plastic skin. I've got one strip of this stapled to the wall to the left of my surface grinder with the bottom two inches folded up into a 'V' to capture the grinding dust otherwise slung against the wall. Excellent! How wide is it and how thick? What is a typical length? What are some trade names for that material? How did you locate the piece you have and what advice would you give to someone who needs to locate a couple feet of it next week? I see folks using that stuff to make a control panel, for instance. (...)not to make a nationwide or worldwide pool of parts which would require shipping back and forth. As you imply, it's just not practical to pay 8 smackers to ship a part that most would describe as worthless. I'm willing to listen to ways that we could share parts economically but that was never on my radar as a top ten goal. O.K. Because if I started entering my hex and round bar stock in about 6' lengths, especially the 12L14 -- that would not be going anywhere. It is for *my* future (and as yet unknown) projects. :-) Good! Same for the 5" long 6" diameter 12L14 cylinder -- left from a 6" long one bought from an on-line drops source to make a part for my Nichols horizontal mill. I don't know what it will be used for, but I do remember that it cost more in the shipping than in the material cost. So tell me how you used a discharged fire extinguisher bottle as a plant sprayer! That's the kinda thing I'm looking for. Oh, I see you kinda did, below. Hmm ... my (Fluke) DMM leads appear to be tin-plated brass, so the strongest magnet around would do little to hold them. :-) I have my DMM leads looped over the protruding end of one of those magnets. Works Great! (And none are used for storing floppies to the rack. :-) So.. that wouldn't work? Of course it would -- as long as you wanted the data which was on them to be gone for security reasons. :-) Write Only Memory? Kewl! [ ... ] At a recent gathering of the local metalworking club (combination yard sale and picnic) I picked up a 1 gallon can which had held "Flux-Off" (for cleaning printed circuit boards after soldering them), and which came with a right-angle faucet. I expect to (after running some compressed air through it for a while to get rid of the remaining solvent dregs) pour in one of my remaining two gallons of Vactra No.2 waylube and store it on a shelf where the faucet can be used to deliver just the right amount without having to lift and tilt the container. (Some 2x4 will be cut to form supports to match the curve of the container.) So -- this is yet another thing which (could go in the list -- except that it already has a planned use. I knew what I was going to use it for when I bought it. :-) It should go in the Circular File anyway. The idea is to make others aware of your novel use of this can! BTW As the list grows, it might be good to have a web site, or an FTP site to save it for downloads, and just post the URL. I agree. Any takers? --Winston |
|
#18
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Nov 22, 6:06*pm, Winston wrote:
Jim Wilkins wrote: ...assortment of gas and TIG rod ... We are on the same frequency, Jim. If you happened to mike some leftover scraps of that rod, I would be pleased to add it to the File. The 3/16" steel measures 0.1864, the 5/32" brass is 0.1531. I suspect that the size within a package is consistent but not that close to nominal, after all it's only welding rod, not ground drill rod. ...Aircraft Spruce sells boxes of assorted chrome-moly tubing cutoffs. If someone wanted to measure the tubing from one of those assortments, I would love to list those sizes in the File, with a pointer to the source. They are assorted cutoffs of 4130 tubing. You get whatever they send, apparently meant for welding practice. The box I received runs from 1/8" to 2-1/4" with most of the pieces 1/2" and 5/8". There was also one unmarked 1-1/2" solid round and one square tube. I don't design home projects to exact size. I figure a range and pick something within it out of the scrap bin. Here are two good examples; http://picasaweb.google.com/KB1DAL/Wheels I got the stainless steel pipe for the stacker wheels as cutoff scrap from a weldor friend. The hub ID was the size the most crooked piece cleaned up to after welding. The axles were turned to fit easily within the needle rollers. Their raw stock could have been anything large enough that fit a collet, since I don't like to do delicate work next to spinning chuck jaws. The sawmill track wheels are scrap plasma cutouts, the shiny finish is from turning their hardened surface after welding up the starting slit. The water-pipe hubs were bored to fit over the bolt shank and needle bearings. Nothing was made to a drawing dimension, each fits the previous part. The CAD drawings merely document whatever I did at the machine so I could design the next assembly to fit. I'm not trying to attack your spreadsheet inventory idea, but for the way I work digging through the racks and looking at the pieces is more efficient than creating and sifting through probably incomplete or outdated text. Each piece is its own best description. I use my CAD .usr library to catalog material like water pipe that needs more detail than just "5/8 316L", "0.505 Al", "1-1/8 12L14??" written on the piece itself with a Sharpie (which tolerates the rustproofing spray). Some of the stock still has the vendor's paper tag attached, taped so it doesn't fly off when spinning in the lathe. Jim Wilkins |
|
#19
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Jim Wilkins wrote:
The 3/16" steel measures 0.1864, the 5/32" brass is 0.1531. OK, those two are now in the File. Thanks! ...Aircraft Spruce sells boxes of assorted chrome-moly tubing cutoffs. In the File. Thanks! I don't design home projects to exact size. I figure a range and pick something within it out of the scrap bin. (...) The sawmill track wheels are scrap plasma cutouts(...) Very cool! Nice looking projects. I'm not trying to attack your spreadsheet inventory idea, I didn't think you were. The idea is to provide future metalworkers a pointer to the sources we uncover, not necessarily to create an exhaustive inventory of every possible part. I use my CAD .usr library to catalog material like water pipe that needs more detail than just "5/8 316L", "0.505 Al", "1-1/8 12L14??" written on the piece itself with a Sharpie (which tolerates the rustproofing spray). Good tips. --Winston |
|
#20
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Sat, 22 Nov 2008 22:29:28 -0800, Winston wrote:
DoN. Nichols wrote: .... BTW As the list grows, it might be good to have a web site, or an FTP site to save it for downloads, and just post the URL. I agree. Any takers? The rec.crafts.metalworking wiki at http://www.metalworker.org/ allows file uploads and would be an appropriate site for such files in .csv and/or .ods format. For wiki file upload instructions, see http://www.metalworker.org/Uploading_a_PDF. Perhaps you could get iggy to create a new-entries web page with a submissions form and a CGI application to merge new entries into the cumulative spreadsheet or database file. -- jiw |
|
#21
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
James Waldby wrote:
On Sat, 22 Nov 2008 22:29:28 -0800, Winston wrote: DoN. Nichols wrote: ... BTW As the list grows, it might be good to have a web site, or an FTP site to save it for downloads, and just post the URL. I agree. Any takers? The rec.crafts.metalworking wiki at http://www.metalworker.org/ allows file uploads and would be an appropriate site for such files in .csv and/or .ods format. I get an error on that: (".csv" is not a recommended image file format.) For wiki file upload instructions, see http://www.metalworker.org/Uploading_a_PDF. Perhaps you could get iggy to create a new-entries web page with a submissions form and a CGI application to merge new entries into the cumulative spreadsheet or database file. That might turn the File into an inventory. That would not be good, IMNSHO. --Winston |
|
#22
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-23, Winston wrote:
DoN. Nichols wrote: [ ... ] I am not interested in the actual physical parts in your collection. Even if you agreed to be my parts warehouse for free, it would be a non-starter because the cost of shipping tends to be some huge multiple of the value of a typical part. I would be time and money ahead just by picking up those parts during a grocery run. O.K. If you want another suggestion for recycling parts, consider the caps from jug-filled water coolers in offices and such. They slip over the neck of the bottle and then their skirt is heat-shrunk to grip the bottle neck, and to open it you tear along a pre-made weak line from a tab. Normally, the cap just goes in a nearby trash can when it is removed. I started collecting them back before I retired. Cut off the remains of the skirts, and you have a collection of small-parts trays (screws, etc) to use when disassembling something. I've got red, green, and blue ones to keep parts from different sub-assemblies separated. Two of them stay in the carrying case for my Milwaukee power screwdriver (the small style used to be AEG, now Milwaukee and Panasonic based on MSC catalog entries. I would have three different colors there if there were room. I'm keeping my eyes and ears open to ways to change that equation so that I can trade my box of 10-32 socket head machine screws for your box of 6 mm hex nuts, without having to pay shipping, but I don't see how that is even possible; it is not my reason for the File right now. Time to work on the project of duplicating the Enterprise's transporter. :-) (...) O.K. But you also have to remember to remove it from the list (or perhaps add a "count" field, and decrement the count to zero when you take the only one -- that way, the entry is there for future additions of more of the same. This could save the number of lines needed when you have several (or many) of identical or near-identical items. I did not envision the Circular File as an inventory, local or global. The only reason that a Circular File entry would fall off the list is if that source dried up for a significant number of users. When most soft drinks are packaged in pure plastic cans, our note about the 4 thousanths aluminum sheet source will disappear, for example. O.K. If the Circular File evolves into a Global Inventory, that's fine. There are significant stumbling blocks though and as we've seen, most of them are huge show-stoppers. I admit I just don't see that happening. O.K. Another interesting (and possibly useful) field would be "personal/for-trade" to remind yourself that you want to hold on to something, or to let someone else nearby (say another member of the local metalworking club) know that there is a possibility of exchange for a given item. That's far outside the 'project charter' as it stands right now. Certainly for national or world-wide use -- but for a local metalworking club were things get shared around it could be a different matter. Ours covers Northern VA, DC, and Southern MD, and there are often posts of "Does anyone have X -- preferably in Northern VA?" on the mailing list. Hmm ... perhaps with provisions for a "many" entry instead of a numerical count -- for things like crimp terminals of a given size in a plastic bin. (I've got insulated crimp ring, fork, and spade terminals in wire sizes from 28 Ga to 4/0 and lots of different hole/slot sizes.) Have a look at Jim Wilkins' File entries on pipe. He shows us that we can make assemblies that telescope or form axles using a very inexpensive part which many of us already have. You probably could combine his entry with a bicycle inner tube to form a rolling - seal pneumatic actuator for (all together now) No Money! :-) (...) Also -- scrap left over from aluminum siding on a house is fairly thin, with a fairly tough plastic skin. I've got one strip of this stapled to the wall to the left of my surface grinder with the bottom two inches folded up into a 'V' to capture the grinding dust otherwise slung against the wall. Excellent! How wide is it and how thick? What is a typical length? That is determined by the area from which it was a remnant. What are some trade names for that material? How did you locate the piece you have and what advice would you give to someone who needs to locate a couple feet of it next week? O.K. The house was expanded by a contractor some years ago (near fifteen now, I think), and I kept the scrap left over from putting aluminum siding over the existing house and the new part. Most of it comes pre-crimped to look like clapboard, but there are pieces used for covering the trim. I think that my widest piece is 12 or 18" wide. And I think that it originally comes in long rolls. So the source would be a construction site. It might even be what is rolled to form gutters by the machine towed behind a truck on a trailer. I see folks using that stuff to make a control panel, for instance. O.K. The white version would take a nice set of Kroy labels for the controls. If you use thick aluminum you can engrave labels in it, but if you simply want something to cover extra holes in the panel, this would be great. [ ... ] So tell me how you used a discharged fire extinguisher bottle as a plant sprayer! That's the kinda thing I'm looking for. I don't have one of those -- yet. :-) Oh, I see you kinda did, below. And the use above for water cooler bottle caps. Hmm ... my (Fluke) DMM leads appear to be tin-plated brass, so the strongest magnet around would do little to hold them. :-) I have my DMM leads looped over the protruding end of one of those magnets. Works Great! O.K. I've got two Fluke DMMs -- one is the 27, and that lives in a carrying case with the probes, extra leads, and the clamp-on ammeter head. The other is the 37 (same functions) but it is designed for bench use and has a storage compartment for the leads and other accessories (including the temperature probe head, which used to live in the other case.) (And none are used for storing floppies to the rack. :-) So.. that wouldn't work? Of course it would -- as long as you wanted the data which was on them to be gone for security reasons. :-) Write Only Memory? Kewl! :-) [ ... ] At a recent gathering of the local metalworking club (combination yard sale and picnic) I picked up a 1 gallon can which had held "Flux-Off" (for cleaning printed circuit boards after soldering them), and which came with a right-angle faucet. I expect to (after running some compressed air through it for a while to get rid of the remaining solvent dregs) pour in one of my remaining two gallons of Vactra No.2 waylube and store it on a shelf where the faucet can be used to deliver just the right amount without having to lift and tilt the container. (Some 2x4 will be cut to form supports to match the curve of the container.) So -- this is yet another thing which (could go in the list -- except that it already has a planned use. I knew what I was going to use it for when I bought it. :-) It should go in the Circular File anyway. The idea is to make others aware of your novel use of this can! O.K. BTW I also save the wax off Gouda cheese, melt and save it, and use it for protective dip for cutting tools at need. BTW As the list grows, it might be good to have a web site, or an FTP site to save it for downloads, and just post the URL. I agree. Any takers? That would hit problems here -- the incoming copies in e-mail would quickly grow over the size of my incoming e-mail limit -- to keep viruses out of small mailing lists hosted on my systems. It is already up to 10,877 bytes, and my limit is 30k -- so we are a third of the way there. But either an FTP site or a web page could serve. Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#23
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Nov 23, 4:27*pm, Winston wrote:
Jim Wilkins wrote: The 3/16" steel measures 0.1864, the 5/32" brass is 0.1531. OK, those two are now in the File. *Thanks!... --Winston Those are NOT the correct decimal equivalents of the fractions. I gave them to point out that welding rod is not drawn to exact controlled diameter. List it by it's nominal fractional size, or just remember the welding store as a source. |
|
#24
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Jim Wilkins wrote:
On Nov 23, 4:27 pm, Winston wrote: Jim Wilkins wrote: The 3/16" steel measures 0.1864, the 5/32" brass is 0.1531. OK, those two are now in the File. Thanks!... --Winston Those are NOT the correct decimal equivalents of the fractions. I gave them to point out that welding rod is not drawn to exact controlled diameter. List it by it's nominal fractional size, or just remember the welding store as a source. I understood that TIG rod isn't made out of "pin gauge" stock. I think everyone 'gets' that. It's more accurate to indicate that a particular piece of TIG filler was ~ 0.003,3" smaller than nominal than to imply that it was within +- 0.000,01" , yes? --Winston |
|
#25
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
O.K. If you want another suggestion for recycling parts, consider the caps from jug-filled water coolers in offices and such. Excellent! O.D.? I.D.? Thickness at the middle of the crown? Is that HDPE? Generic 'plastic'? Time to work on the project of duplicating the Enterprise's transporter. :-) A.D. 2015: "Engineer DoN. Nichols demonstrated the first reliable Matter - Energy - Matter Codec this afternoon. Attendees celebrated as Mr. Nichols announced the end of the fifty - cent hex nut." (...) That's far outside the 'project charter' as it stands right now. Certainly for national or world-wide use -- but for a local metalworking club were things get shared around it could be a different matter. Ours covers Northern VA, DC, and Southern MD, and there are often posts of "Does anyone have X -- preferably in Northern VA?" on the mailing list. We have a small price / performance issue here. Who arbitrates disagreements about: * quality * quantity * description accuracy * finish * availability * condition * location * delivery date * yada yada yada? To quote a great philosopher: "It ain't me, babe." Feel free to start a Geek 'Tradio'. I agree that it would be very useful. It is much too big a 'Mission Creep' for me. [ ... ] Oh, I see you kinda did, below. And the use above for water cooler bottle caps. Thank you! (...) BTW I also save the wax off Gouda cheese, melt and save it, and use it for protective dip for cutting tools at need. You *are* good! (...) But either an FTP site or a web page could serve. We are in violent agreement. --Winston |
|
#26
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On 2008-11-24, Winston wrote:
DoN. Nichols wrote: O.K. If you want another suggestion for recycling parts, consider the caps from jug-filled water coolers in offices and such. Excellent! O.D.? I.D.? Thickness at the middle of the crown? Is that HDPE? Generic 'plastic'? You keep asking these questions (or at least I see them) when I am upstairs at my computer -- not downstairs with the shop. And I had a major schlump blocking access to the shop door earlier, when I pulled out a metal suitcase full of crimping tools. I just had to dig that out sooner than I had planned, to get my digital calipers. OD: 2.258" ID: 1.997" (at bottom of lip, which is like a pair of "( )" separated by about 2".) THICKNESS: 0.102" (at center where there is a plastic pimple 0.063" (closer to the rim). HDPE? Who knows? It is a flexible plastic, even fifteen years after collection. It has heat-shrink capability to shrink the skirt against the neck of the original bottle. Only visible marking is UL12 (for the blue one in my hand at the moment.) I've also nipped a hole in the rim of one, and used it as protection over the positive terminal of a large strorage battery in a UPS whose metal lid was too close to the terminals. [ ... ] That's far outside the 'project charter' as it stands right now. Certainly for national or world-wide use -- but for a local metalworking club were things get shared around it could be a different matter. Ours covers Northern VA, DC, and Southern MD, and there are often posts of "Does anyone have X -- preferably in Northern VA?" on the mailing list. We have a small price / performance issue here. Who arbitrates disagreements about: * quality Determined by the person looking for it * quantity What is available and what is needed? * description accuracy Visual examination before hand-over. * finish ditto * availability Determined by the one offering. * condition What is there -- the searcher determines whether it is adequate for his purposes. (Most often it is whether it is large enough and the right material for the project. One example was someone looking for an old water heater to make a digester for bio-diesel, and I had just replaced one, and wanted a home for it. he came by and we got it out of the cellar and up the steps to the ground level together. He knew that it leaked, and it was still what he needed. * location Where it is at the moment. Smaller things may be carried to the monthly meetings (I'll be at one tomorrow night, and may not have time to answer). * delivery date exchange at meetings -- or the person wanting it drives to the home of the person offering it. (I did this quite recently for a foot of railroad rail, to make a small anvil.) * yada yada yada? Whatever -- settled between those of good will. (Typically, this starts with a post to the club's (e-)mailing list saying "Does anyone have 'X' at least Y x Z in size, and someone else says "no -- but can you use Q?" and another says -- "Yes -- but I'll need help to dig it out." To quote a great philosopher: "It ain't me, babe." This is just a possible use for your tool -- to help people tell whether they *do* have what is needed -- and can spare it. Feel free to start a Geek 'Tradio'. I agree that it would be very useful. It already exists. It is much too big a 'Mission Creep' for me. O.K. It is just a way that people might use what you have started. [ ... ] BTW I also save the wax off Gouda cheese, melt and save it, and use it for protective dip for cutting tools at need. You *are* good! That nice red wax is not something to waste. :-) But either an FTP site or a web page could serve. We are in violent agreement. O.K. Enjoy, DoN. -- Email: | Voice (all times): (703) 938-4564 (too) near Washington D.C. | http://www.d-and-d.com/dnichols/DoN.html --- Black Holes are where God is dividing by zero --- |
|
#27
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
DoN. Nichols wrote:
On 2008-11-24, Winston wrote: DoN. Nichols wrote: O.K. If you want another suggestion for recycling parts, consider the caps from jug-filled water coolers in offices and such. Excellent! Thanks, DoN. It's in the File. (...) This is just a possible use for your tool -- to help people tell whether they *do* have what is needed -- and can spare it. That is terrific! (...) BTW I also save the wax off Gouda cheese, melt and save it, and use it for protective dip for cutting tools at need. You *are* good! That nice red wax is not something to waste. :-) It's in the File! I wonder if anyone has made candles using that stuff? --Winston |
|
#28
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Nov 25, 1:58*am, Winston wrote:
DoN. Nichols wrote: * *O.K. *If you want another suggestion for recycling parts, consider the caps from jug-filled water coolers in offices and such. I saved a lot of those but never found a good use for them. BTW * * * *I also save the wax off Gouda cheese, I wonder if anyone has made candles using that stuff? --Winston The urethane wax in a toilet bowl ring is more flexible than paraffin wax. In the (cheap) kitchen department there are cutting boards for thick plastic, strainers with stainless steel screening, and SS pots and pans. $1 pots made good front hub dust shields for my old truck; http://picasaweb.google.com/KB1DAL/Parts# Grade 5 and 8 bolts can be turned and threaded with HSS on a lathe and can save a lot of rough turning when you need a large-head on a smaller shank, for instance to make a saw arbor or milling cutter holder. Jim Wilkins |
|
#29
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Sun, 07 Dec 2008 21:55:23 -0800, the infamous Winston
scrawled the following: This 'Comma Separated Values' file is an open resource for us folks who make stuff. It is an index to parts that you can re-use for little or No Money. I encourage you to wander around, measuring all manner of recyclable Things. Upload your measurements, descriptions and hints to RCM; I will integrate and present the total for everyone. New entries today: A source of 0.003" HDPE sheet and a source of 0.034" neoprene sheet. 1) Copy the attachment to your 'Circular File' folder. 2) Start your spreadsheet program. (This should work in Excel too.) 3) Open the *.csv file in your spreadsheet program. 4) Adjust column width to suit. Column A, with its 11.75" width, is a bit wide for my tastes, TYVM.  As always, I look forward to your helpful record entries, corrections and suggestions. I'm curious about the whipped cream can. What are your thoughts on it? Are you saving a source of nitrous oxide for someone, or?!? -- At current market valuations (GM is worth less than Mattel) the Chinese government can afford to buy GM with petty cash. --Bertel Shmitt on kencan7 blogspot |
|
#30
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Larry Jaques graciously gifted us with:
(...) Column A, with its 11.75" width, is a bit wide for my tastes, TYVM. I might have forgotten to mention this but: 4) Adjust column width to suit. (You are welcome.) I'm curious about the whipped cream can. What are your thoughts on it? Are you saving a source of nitrous oxide for someone, or?!? Nah silly. Use your imagination! 1) Rivet fins on, sand, prime and paint; it's a Rocket Ship. 2) Snip it; it's a source of thin shields for the UHF section of your down - converter project, or as laminate for that custom transformer you always wanted to build. 3) Install RC receiver, batteries, motor; drive your cat crazy! 4) Cut out the front and back. Replace the front with a translucent plastic copy of the original product artwork, add LEDs; make suggestive yet tasteful (g) lighting sconces for your boudoir. 5) Modify and slide it into a decapitated 16 oz H2O2 bottle; add lenses and make a spyglass. 6) Snip off the top and grind the raw metal back to the seam. Sand, prime and seal to make a nifty brush cup. 7) Cut a square in the side near the bottom to accommodate a Peltier cell and heat sinks to keep your 500 mL water bottle chilly. 8) Snip off the top and bottom of two cans and TIG them end - to - end. Invert one bottom and TIG it back on to the body of the can to make a spherical reflector. Amaze your friends with the gain of your new cantenna. Hey, you asked for my thoughts. This is the best I can do until they show up. --Winston |
|
#31
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Mon, 08 Dec 2008 14:14:58 -0800, the infamous Winston
scrawled the following: Larry Jaques graciously gifted us with: (...) Column A, with its 11.75" width, is a bit wide for my tastes, TYVM. I might have forgotten to mention this but: 4) Adjust column width to suit. (You are welcome.) No, I quoted it with my reply, didn't I? I'm curious about the whipped cream can. What are your thoughts on it? Are you saving a source of nitrous oxide for someone, or?!? Nah silly. Use your imagination! 1) Rivet fins on, sand, prime and paint; it's a Rocket Ship. DANGER, Will Robinson! Can is pressurized! 2) Snip it; it's a source of thin shields for the UHF section of your down - converter project, or as laminate for that custom transformer you always wanted to build. 3) Install RC receiver, batteries, motor; drive your cat crazy! 4) Cut out the front and back. Replace the front with a translucent plastic copy of the original product artwork, add LEDs; make suggestive yet tasteful (g) lighting sconces for your boudoir. 5) Modify and slide it into a decapitated 16 oz H2O2 bottle; add lenses and make a spyglass. 6) Snip off the top and grind the raw metal back to the seam. Sand, prime and seal to make a nifty brush cup. 7) Cut a square in the side near the bottom to accommodate a Peltier cell and heat sinks to keep your 500 mL water bottle chilly. 8) Snip off the top and bottom of two cans and TIG them end - to - end. Yeah, that's extremely good TIG practice. Invert one bottom and TIG it back on to the body of the can to make a spherical reflector. Amaze your friends with the gain of your new cantenna. Creamy goodness for your WiFi connection? Hmm... Izzat anything like a Pringles Yagi? Hey, you asked for my thoughts. This is the best I can do until they show up. Wull, that 'splains that. Carry on! (Carrion?) -- At current market valuations (GM is worth less than Mattel) the Chinese government can afford to buy GM with petty cash. --Bertel Shmitt on kencan7 blogspot |
|
#32
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Larry Jaques wrote:
On Mon, 08 Dec 2008 14:14:58 -0800, the infamous Winston scrawled the following: Larry Jaques graciously gifted us with: (...) No, I quoted it with my reply, didn't I? Yup. That you did. I'm curious about the whipped cream can. What are your thoughts on it? Are you saving a source of nitrous oxide for someone, or?!? Nah silly. Use your imagination! 1) Rivet fins on, sand, prime and paint; it's a Rocket Ship. DANGER, Will Robinson! Can is pressurized! That's what 1/16" drill bits are for. They tend to equilibrate differentials. I doubt the emptied can has much in the way of pressure, by definition. (...) 8) Snip off the top and bottom of two cans and TIG them end - to - end. Yeah, that's extremely good TIG practice. Heck, the seam at that point is ~0.064" thick. Hardly a 'razorblade' trick. Invert one bottom and TIG it back on to the body of the can to make a spherical reflector. Amaze your friends with the gain of your new cantenna. Creamy goodness for your WiFi connection? Hmm... Izzat anything like a Pringles Yagi? Sorta Kinda. I see that it wouldn't necessarily work for 2.4 GHz due to it's small diameter. Be OK for 5 GHz though. Hmmm. http://www.saunalahti.fi/elepal/antenna2calc.php Wull, that 'splains that. Carry on! (Carrion?) There's a joke in there somewhere.... --Winston |
|
#33
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
At long last, I've posted this off line.
Browse to: http://mysite.verizon.net/reswoead/id1.html In honor of Iggy's electrolysis experiments, I have a source of carbon electrodes. Search under 'Graphite'. As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#34
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Today, we've immortalized those ingenious and frugal folks who have
found seemingly endless ways to fabricate plastic washers. Browse to: http://mysite.verizon.net/reswoead/id1.html As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#35
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Today, we have three more thicknesses of HDPE plastic available.
Browse to: http://mysite.verizon.net/reswoead/id1.html As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#36
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Today, we added steel brake line and a new column for relevant
internet links. Browse to: http://mysite.verizon.net/reswoead/id1.html As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#37
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Today, we are up to 75 items after adding several sizes of PVC pipe.
Only 9925 items to go before the File starts to become useful, so don't be shy with your suggestions! Browse to: http://mysite.verizon.net/reswoead/id1.html As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#38
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
We are surrounded by expensive parts cleverly disguised as trash.
For example, that plastic cup you need for your prototype hazard flasher can be had for thousands of dollars in tooling fees and weeks of waiting. Or, you can just re-purpose the tub that held the sugar glaze in the cinnamon rolls you baked yesterday. This spreadsheet is intended to be an open resource for all denizens of RCM and other folks who make models and prototypes. With your participation, we can have this up to 10,000 items in no time. Get your copy free from: http://mysite.verizon.net/reswoead/id1.html As always, I look forward to your helpful record entries, corrections and suggestions. Thanks! --Winston |
|
#39
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
On Mar 6, 10:07*am, Winston wrote:
We are surrounded by expensive parts cleverly disguised as trash. --Winston I don't have the specs but plastic electrical conduit is nice stuff to turn and thread and the expanded slip joint on one end is useful. |
|
#40
Posted to rec.crafts.metalworking
|
|||
|
|||
|
McGyver resource: The Circular File
Jim Wilkins wrote:
On Mar 6, 10:07 am, Winston wrote: We are surrounded by expensive parts cleverly disguised as trash. --Winston I don't have the specs but plastic electrical conduit is nice stuff to turn and thread and the expanded slip joint on one end is useful. Thanks Jim, I've added several sizes to the File for the next release. --Winston -- Don't *faff*, dear. |
| Reply |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Thanks for creating this resource | Home Ownership | |||
| Industry Equipment Resource | Woodworking | |||
| Online resource for Elm | Woodturning | |||
| resource for tapping and die-ing | Metalworking | |||
Linear Mode
