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:

creating a sheet named CircularFile.ods or CircularFile.xls******

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.A2>0;Imperial.A2;"") =IF (Imperial.A3>0;Imperial.A3;"") =IF (Imperial.A4>0;Imperial.A4;"") =IF (Imperial.A5>0;Imperial.A5;"") =IF (Imperial.B5>0;Imperial.B5;"") =IF (Imperial.C5>0;Imperial.C5;"") =IF (Imperial.D5>0;Imperial.D5;"") =IF (Imperial.E5>0;Imperial.E5;"") =IF (Imperial.F5>0;Imperial.F5;"") =IF (Imperial.G5>0;Imperial.G5;"") =IF (Imperial.A6>0;Imperial.A6;"") =IF (Imperial.B6>0;Imperial.B6;"") =IF (Imperial.C6>0;Imperial.C6;"") =IF (Imperial.D6>0;Imperial.D6;"") =IF (Imperial.E6>0;Imperial.E6;"") =IF (Imperial.F6>0;Imperial.F6;"") =IF (Imperial.G6>0;Imperial.G6;"") =IF (Imperial.A7>0;Imperial.A7;"") Millimeters Millimeters Millimeters Millimeters =IF (Imperial.A8>0;Imperial.A8;"") =IF (Imperial.B8>0;Imperial.B8*25.4;"") =IF (Imperial.C8>0;Imperial.C8*25.4;"") =IF (Imperial.D8>0;Imperial.D8*25.4;"") =IF (Imperial.E8>0;Imperial.E8*25.4;"") =IF (Imperial.F8>0;Imperial.F8;"") =IF (Imperial.G8>0;Imperial.G8;"") =IF (Imperial.A9>0;Imperial.A9;"") =IF (Imperial.B9>0;Imperial.B9*25.4;"") =IF (Imperial.C9>0;Imperial.C9*25.4;"") =IF (Imperial.D9>0;Imperial.D9*25.4;"") =IF (Imperial.E9>0;Imperial.E9*25.4;"") =IF (Imperial.F9>0;Imperial.F9;"") =IF (Imperial.G9>0;Imperial.G9;"") =IF (Imperial.A10>0;Imperial.A10;"") =IF (Imperial.B10>0;Imperial.B10*25.4;"") =IF (Imperial.C10>0;Imperial.C10*25.4;"") =IF (Imperial.D10>0;Imperial.D10*25.4;"") =IF (Imperial.E10>0;Imperial.E10*25.4;"") =IF (Imperial.F10>0;Imperial.F10;"") =IF (Imperial.G10>0;Imperial.G10;"") =IF (Imperial.A11>0;Imperial.A11;"") =IF (Imperial.B11>0;Imperial.B11*25.4;"") =IF (Imperial.C11>0;Imperial.C11*25.4;"") =IF (Imperial.D11>0;Imperial.D11*25.4;"") =IF (Imperial.E11>0;Imperial.E11*25.4;"") =IF (Imperial.F11>0;Imperial.F11;"") =IF (Imperial.G11>0;Imperial.G11;"") =IF (Imperial.A12>0;Imperial.A12;"") =IF (Imperial.B12>0;Imperial.B12*25.4;"") =IF (Imperial.C12>0;Imperial.C12*25.4;"") =IF (Imperial.D12>0;Imperial.D12*25.4;"") =IF (Imperial.E12>0;Imperial.E12*25.4;"") =IF (Imperial.F12>0;Imperial.F12;"") =IF (Imperial.G12>0;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.A2>0,Imperial.A2,"") =IF (Imperial.A3>0,Imperial.A3,"") =IF (Imperial.A4>0,Imperial.A4,"") =IF (Imperial.A5>0,Imperial.A5,"") =IF (Imperial.B5>0,Imperial.B5,"") =IF (Imperial.C5>0,Imperial.C5,"") =IF (Imperial.D5>0,Imperial.D5,"") =IF (Imperial.E5>0,Imperial.E5,"") =IF (Imperial.F5>0,Imperial.F5,"") =IF (Imperial.G5>0,Imperial.G5,"") =IF (Imperial.A6>0,Imperial.A6,"") =IF (Imperial.B6>0,Imperial.B6,"") =IF (Imperial.C6>0,Imperial.C6,"") =IF (Imperial.D6>0,Imperial.D6,"") =IF (Imperial.E6>0,Imperial.E6,"") =IF (Imperial.F6>0,Imperial.F6,"") =IF (Imperial.G6>0,Imperial.G6,"") =IF (Imperial.A7>0,Imperial.A7,"") Millimeters Millimeters Millimeters Millimeters =IF (Imperial.A8>0,Imperial.A8,"") =IF (Imperial.B8>0,Imperial.B8*25.4,"") =IF (Imperial.C8>0,Imperial.C8*25.4,"") =IF (Imperial.D8>0,Imperial.D8*25.4,"") =IF (Imperial.E8>0,Imperial.E8*25.4,"") =IF (Imperial.F8>0,Imperial.F8,"") =IF (Imperial.G8>0,Imperial.G8,"") =IF (Imperial.A9>0,Imperial.A9,"") =IF (Imperial.B9>0,Imperial.B9*25.4,"") =IF (Imperial.C9>0,Imperial.C9*25.4,"") =IF (Imperial.D9>0,Imperial.D9*25.4,"") =IF (Imperial.E9>0,Imperial.E9*25.4,"") =IF (Imperial.F9>0,Imperial.F9,"") =IF (Imperial.G9>0,Imperial.G9,"") =IF (Imperial.A10>0,Imperial.A10,"") =IF (Imperial.B10>0,Imperial.B10*25.4,"") =IF (Imperial.C10>0,Imperial.C10*25.4,"") =IF (Imperial.D10>0,Imperial.D10*25.4,"") =IF (Imperial.E10>0,Imperial.E10*25.4,"") =IF (Imperial.F10>0,Imperial.F10,"") =IF (Imperial.G10>0,Imperial.G10,"") =IF (Imperial.A11>0,Imperial.A11,"") =IF (Imperial.B11>0,Imperial.B11*25.4,"") =IF (Imperial.C11>0,Imperial.C11*25.4,"") =IF (Imperial.D11>0,Imperial.D11*25.4,"") =IF (Imperial.E11>0,Imperial.E11*25.4,"") =IF (Imperial.F11>0,Imperial.F11,"") =IF (Imperial.G11>0,Imperial.G11,"") =IF (Imperial.A12>0,Imperial.A12,"") =IF (Imperial.B12>0,Imperial.B12*25.4,"") =IF (Imperial.C12>0,Imperial.C12*25.4,"") =IF (Imperial.D12>0,Imperial.D12*25.4,"") =IF (Imperial.E12>0,Imperial.E12*25.4,"") =IF (Imperial.F12>0,Imperial.F12,"") =IF (Imperial.G12>0,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

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

On Nov 18, 1:44=A0am, Winston wrote: [^ original, the rest copied and pasted from a .txt file. Michael, try replying to this.]

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

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","Translucent 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

[ ... ]

Thickness","Length",,"Notes","Source","Posted","By"

(0.045? size)",11/18/2008,"Winston"

size)",11/18/2008,"Winston"

cartridge from Metcal MX-500 and SP-200 MX-RM3E handpiece",11/18/2008,"Winston"

electric lamp part, between the base and harp",11/18/2008,"Winston"

film canister W/ threaded lid",11/18/2008,"Winston"

35 mm film canister W/Snap Lid",11/18/2008,"Winston" 200 mL dispenser of GoJo Provon Antibacterial Handwash",11/18/2008,"Winston"

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.

(...)

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 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 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.

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.

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

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","Translucent 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.A2>0;Imperial.A2;"""")",,,,,,,,,,,, "=IF (Imperial.A3>0;Imperial.A3;"""")",,,,,,,,,,,, ,,,,,,,,,,,, "=IF (Imperial.A4>0;Imperial.A4;"""")","=IF (Imperial.B4>0;Imperial.B4;"""")",,"=IF (Imperial.D5>0;Imperial.D5;"""")","=IF (Imperial.E5>0;Imperial.E5;"""")","=IF (Imperial.F5>0;Imperial.F5;"""")",,,,,,, "=IF (Imperial.A6>0;Imperial.A6;"""")","=IF (Imperial.B5>0;Imperial.B5;"""")","=IF (Imperial.C6>0;Imperial.C6;"""")","=IF (Imperial.D6>0;Imperial.D6;"""")","=IF (Imperial.E6>0;Imperial.E6;"""")","=IF (Imperial.F6>0;Imperial.F6;"""")","=IF (Imperial.G6>0;Imperial.G6;"""")","=IF (Imperial.H6>0;Imperial.H6;"""")","=IF (Imperial.I6>0;Imperial.I6;"""")","=IF (Imperial.J6>0;Imperial.J6;"""")","=IF (Imperial.K6>0;Imperial.K6;"""")",, ,"=IF (Imperial.B6>0;Imperial.B6;"""")","=IF (Imperial.C7>0;Imperial.C7;"""")","=IF (Imperial.D7>0;Imperial.D7;"""")","=IF (Imperial.E7>0;Imperial.E7;"""")","=IF (Imperial.F7>0;Imperial.F7;"""")",,,,,,, "=IF (Imperial.A7>0;Imperial.A7;"""")","=IF (Imperial.B7>0;Imperial.B7;"""")","=IF (Imperial.C8>0;Imperial.C8;"""")",,,,,,,,,"=IF (Imperial.L7>0;Imperial.L7;"""")", ,"mm","mm","mm","mm","mm",,,,,,, "=IF (Imperial.A9>0;Imperial.A9;"""")",,"=IF (Imperial.C10>0;Imperial.C10*25.4;"""")","=IF (Imperial.D10>0;Imperial.D10*25.4;"""")","=IF (Imperial.E10>0;Imperial.E10*25.4;"""")",,"=IF (Imperial.G9>0;Imperial.G9;"""")","=IF (Imperial.H9>0;Imperial.H9;"""")","=IF (Imperial.I9>0;Imperial.I9;"""")","=IF (Imperial.J9>0;Imperial.J9;"""")","=IF (Imperial.K9>0;Imperial.K9;"""")","=IF (Imperial.L10>0;Imperial.L10;"""")","=IF (Imperial.M10>0;Imperial.M10;"""")" "=IF (Imperial.A10>0;Imperial.A10;"""")","=IF (Imperial.B10>0;Imperial.B10*25.4;"""")","=IF (Imperial.C10>0;Imperial.C10*25.4;"""")","=IF (Imperial.D10>0;Imperial.D10*25.4;"""")","=IF (Imperial.E10>0;Imperial.E10*25.4;"""")","=IF (Imperial.F10>0;Imperial.F10*25.4;"""")","=IF (Imperial.G10>0;Imperial.G10;"""")","=IF (Imperial.H10>0;Imperial.H10;"""")","=IF (Imperial.I10>0;Imperial.I10;"""")","=IF (Imperial.J10>0;Imperial.J10;"""")","=IF (Imperial.K10>0;Imperial.K10;"""")",, "=IF (Imperial.A11>0;Imperial.A11;"""")","=IF (Imperial.B11>0;Imperial.B11*25.4;"""")","=IF (Imperial.C11>0;Imperial.C11*25.4;"""")","=IF (Imperial.D11>0;Imperial.D11*25.4;"""")","=IF (Imperial.E11>0;Imperial.E11*25.4;"""")","=IF (Imperial.F11>0;Imperial.F11*25.4;"""")","=IF (Imperial.G11>0;Imperial.G11;"""")","=IF (Imperial.H11>0;Imperial.H11;"""")","=IF (Imperial.I11>0;Imperial.I11;"""")","=IF (Imperial.J11>0;Imperial.J11;"""")","=IF (Imperial.K11>0;Imperial.K11;"""")",, "=IF (Imperial.A12>0;Imperial.A12;"""")","=IF (Imperial.B12>0;Imperial.B12*25.4;"""")","=IF (Imperial.C12>0;Imperial.C12*25.4;"""")","=IF (Imperial.D12>0;Imperial.D12*25.4;"""")","=IF (Imperial.E12>0;Imperial.E12*25.4;"""")","=IF (Imperial.F12>0;Imperial.F12*25.4;"""")","=IF (Imperial.G12>0;Imperial.G12;"""")","=IF (Imperial.H12>0;Imperial.H12;"""")","=IF (Imperial.I12>0;Imperial.I12;"""")","=IF (Imperial.J12>0;Imperial.J12;"""")","=IF (Imperial.K12>0;Imperial.K12;"""")",, "=IF (Imperial.A13>0;Imperial.A13;"""")","=IF (Imperial.B13>0;Imperial.B13*25.4;"""")","=IF (Imperial.C13>0;Imperial.C13*25.4;"""")","=IF (Imperial.D13>0;Imperial.D13*25.4;"""")","=IF (Imperial.E13>0;Imperial.E13*25.4;"""")","=IF (Imperial.F13>0;Imperial.F13*25.4;"""")","=IF (Imperial.G13>0;Imperial.G13;"""")","=IF (Imperial.H13>0;Imperial.H13;"""")","=IF (Imperial.I13>0;Imperial.I13;"""")","=IF (Imperial.J13>0;Imperial.J13;"""")","=IF (Imperial.K13>0;Imperial.K13;"""")",, "=IF (Imperial.A14>0;Imperial.A14;"""")","=IF (Imperial.B14>0;Imperial.B14*25.4;"""")","=IF (Imperial.C14>0;Imperial.C14*25.4;"""")","=IF (Imperial.D14>0;Imperial.D14*25.4;"""")","=IF (Imperial.E14>0;Imperial.E14*25.4;"""")","=IF (Imperial.F14>0;Imperial.F14*25.4;"""")","=IF (Imperial.G14>0;Imperial.G14;"""")","=IF (Imperial.H14>0;Imperial.H14;"""")","=IF (Imperial.I14>0;Imperial.I14;"""")","=IF (Imperial.J14>0;Imperial.J14;"""")","=IF (Imperial.K14>0;Imperial.K14;"""")",, "=IF (Imperial.A15>0;Imperial.A15;"""")","=IF (Imperial.B15>0;Imperial.B15*25.4;"""")","=IF (Imperial.C15>0;Imperial.C15*25.4;"""")","=IF (Imperial.D15>0;Imperial.D15*25.4;"""")","=IF (Imperial.E15>0;Imperial.E15*25.4;"""")","=IF (Imperial.F15>0;Imperial.F15*25.4;"""")","=IF (Imperial.G15>0;Imperial.G15;"""")","=IF (Imperial.H15>0;Imperial.H15;"""")","=IF (Imperial.I15>0;Imperial.I15;"""")","=IF (Imperial.J15>0;Imperial.J15;"""")","=IF (Imperial.K15>0;Imperial.K15;"""")",, "=IF (Imperial.A16>0;Imperial.A16;"""")","=IF (Imperial.B16>0;Imperial.B16*25.4;"""")","=IF (Imperial.C16>0;Imperial.C16*25.4;"""")","=IF (Imperial.D16>0;Imperial.D16*25.4;"""")","=IF (Imperial.E16>0;Imperial.E16*25.4;"""")","=IF (Imperial.F16>0;Imperial.F16*25.4;"""")","=IF (Imperial.G16>0;Imperial.G16;"""")","=IF (Imperial.H16>0;Imperial.H16;"""")","=IF (Imperial.I16>0;Imperial.I16;"""")","=IF (Imperial.J16>0;Imperial.J16;"""")","=IF (Imperial.K16>0;Imperial.K16;"""")",, "=IF (Imperial.A17>0;Imperial.A17;"""")","=IF (Imperial.B17>0;Imperial.B17*25.4;"""")","=IF (Imperial.C17>0;Imperial.C17*25.4;"""")","=IF (Imperial.D17>0;Imperial.D17*25.4;"""")","=IF (Imperial.E17>0;Imperial.E17*25.4;"""")","=IF (Imperial.F17>0;Imperial.F17*25.4;"""")","=IF (Imperial.G17>0;Imperial.G17;"""")","=IF (Imperial.H17>0;Imperial.H17;"""")","=IF (Imperial.I17>0;Imperial.I17;"""")","=IF (Imperial.J17>0;Imperial.J17;"""")","=IF (Imperial.K17>0;Imperial.K17;"""")",, "=IF (Imperial.A18>0;Imperial.A18;"""")","=IF (Imperial.B18>0;Imperial.B18*25.4;"""")","=IF (Imperial.C18>0;Imperial.C18*25.4;"""")","=IF (Imperial.D18>0;Imperial.D18*25.4;"""")","=IF (Imperial.E18>0;Imperial.E18*25.4;"""")","=IF (Imperial.F18>0;Imperial.F18*25.4;"""")","=IF (Imperial.G18>0;Imperial.G18;"""")","=IF (Imperial.H18>0;Imperial.H18;"""")","=IF (Imperial.I18>0;Imperial.I18;"""")","=IF (Imperial.J18>0;Imperial.J18;"""")","=IF (Imperial.K18>0;Imperial.K18;"""")",, "=IF (Imperial.A19>0;Imperial.A19;"""")","=IF (Imperial.B19>0;Imperial.B19*25.4;"""")","=IF (Imperial.C19>0;Imperial.C19*25.4;"""")","=IF (Imperial.D19>0;Imperial.D19*25.4;"""")","=IF (Imperial.E19>0;Imperial.E19*25.4;"""")","=IF (Imperial.F19>0;Imperial.F19*25.4;"""")","=IF (Imperial.G19>0;Imperial.G19;"""")","=IF (Imperial.H19>0;Imperial.H19;"""")","=IF (Imperial.I19>0;Imperial.I19;"""")","=IF (Imperial.J19>0;Imperial.J19;"""")","=IF (Imperial.K19>0;Imperial.K19;"""")",, "=IF (Imperial.A20>0;Imperial.A20;"""")","=IF (Imperial.B20>0;Imperial.B20*25.4;"""")","=IF (Imperial.C20>0;Imperial.C20*25.4;"""")","=IF (Imperial.D20>0;Imperial.D20*25.4;"""")","=IF (Imperial.E20>0;Imperial.E20*25.4;"""")","=IF (Imperial.F20>0;Imperial.F20*25.4;"""")","=IF (Imperial.G20>0;Imperial.G20;"""")","=IF (Imperial.H20>0;Imperial.H20;"""")","=IF (Imperial.I20>0;Imperial.I20;"""")","=IF (Imperial.J20>0;Imperial.J20;"""")","=IF (Imperial.K20>0;Imperial.K20;"""")",, "=IF (Imperial.A21>0;Imperial.A21;"""")","=IF (Imperial.B21>0;Imperial.B21*25.4;"""")","=IF (Imperial.C21>0;Imperial.C21*25.4;"""")","=IF (Imperial.D21>0;Imperial.D21*25.4;"""")","=IF (Imperial.E21>0;Imperial.E21*25.4;"""")","=IF (Imperial.F21>0;Imperial.F21*25.4;"""")","=IF (Imperial.G21>0;Imperial.G21;"""")","=IF (Imperial.H21>0;Imperial.H21;"""")","=IF (Imperial.I21>0;Imperial.I21;"""")","=IF (Imperial.J21>0;Imperial.J21;"""")","=IF (Imperial.K21>0;Imperial.K21;"""")",, "=IF (Imperial.A22>0;Imperial.A22;"""")","=IF (Imperial.B22>0;Imperial.B22*25.4;"""")","=IF (Imperial.C22>0;Imperial.C22*25.4;"""")","=IF (Imperial.D22>0;Imperial.D22*25.4;"""")","=IF (Imperial.E22>0;Imperial.E22*25.4;"""")","=IF (Imperial.F22>0;Imperial.F22*25.4;"""")","=IF (Imperial.G22>0;Imperial.G22;"""")","=IF (Imperial.H22>0;Imperial.H22;"""")","=IF (Imperial.I22>0;Imperial.I22;"""")","=IF (Imperial.J22>0;Imperial.J22;"""")","=IF (Imperial.K22>0;Imperial.K22;"""")",, "=IF (Imperial.A23>0;Imperial.A23;"""")","=IF (Imperial.B23>0;Imperial.B23*25.4;"""")","=IF (Imperial.C23>0;Imperial.C23*25.4;"""")","=IF (Imperial.D23>0;Imperial.D23*25.4;"""")","=IF (Imperial.E23>0;Imperial.E23*25.4;"""")","=IF (Imperial.F23>0;Imperial.F23*25.4;"""")","=IF (Imperial.G23>0;Imperial.G23;"""")","=IF (Imperial.H23>0;Imperial.H23;"""")","=IF (Imperial.I23>0;Imperial.I23;"""")","=IF (Imperial.J23>0;Imperial.J23;"""")","=IF (Imperial.K23>0;Imperial.K23;"""")",, "=IF (Imperial.A24>0;Imperial.A24;"""")","=IF (Imperial.B24>0;Imperial.B24*25.4;"""")","=IF (Imperial.C24>0;Imperial.C24*25.4;"""")","=IF (Imperial.D24>0;Imperial.D24*25.4;"""")","=IF (Imperial.E24>0;Imperial.E24*25.4;"""")","=IF (Imperial.F24>0;Imperial.F24*25.4;"""")","=IF (Imperial.G24>0;Imperial.G24;"""")","=IF (Imperial.H24>0;Imperial.H24;"""")","=IF (Imperial.I24>0;Imperial.I24;"""")","=IF (Imperial.J24>0;Imperial.J24;"""")","=IF (Imperial.K24>0;Imperial.K24;"""")",, "=IF (Imperial.A25>0;Imperial.A25;"""")","=IF (Imperial.B25>0;Imperial.B25*25.4;"""")","=IF (Imperial.C25>0;Imperial.C25*25.4;"""")","=IF (Imperial.D25>0;Imperial.D25*25.4;"""")","=IF (Imperial.E25>0;Imperial.E25*25.4;"""")","=IF (Imperial.F25>0;Imperial.F25*25.4;"""")","=IF (Imperial.G25>0;Imperial.G25;"""")","=IF (Imperial.H25>0;Imperial.H25;"""")","=IF (Imperial.I25>0;Imperial.I25;"""")","=IF (Imperial.J25>0;Imperial.J25;"""")","=IF (Imperial.K25>0;Imperial.K25;"""")",, "=IF (Imperial.A26>0;Imperial.A26;"""")","=IF (Imperial.B26>0;Imperial.B26*25.4;"""")","=IF (Imperial.C26>0;Imperial.C26*25.4;"""")","=IF (Imperial.D26>0;Imperial.D26*25.4;"""")","=IF (Imperial.E26>0;Imperial.E26*25.4;"""")","=IF (Imperial.F26>0;Imperial.F26*25.4;"""")","=IF (Imperial.G26>0;Imperial.G26;"""")","=IF (Imperial.H26>0;Imperial.H26;"""")","=IF (Imperial.I26>0;Imperial.I26;"""")","=IF (Imperial.J26>0;Imperial.J26;"""")","=IF (Imperial.K26>0;Imperial.K26;"""")",, "=IF (Imperial.A27>0;Imperial.A27;"""")","=IF (Imperial.B27>0;Imperial.B27*25.4;"""")","=IF (Imperial.C27>0;Imperial.C27*25.4;"""")","=IF (Imperial.D27>0;Imperial.D27*25.4;"""")","=IF (Imperial.E27>0;Imperial.E27*25.4;"""")","=IF (Imperial.F27>0;Imperial.F27*25.4;"""")","=IF (Imperial.G27>0;Imperial.G27;"""")","=IF (Imperial.H27>0;Imperial.H27;"""")","=IF (Imperial.I27>0;Imperial.I27;"""")","=IF (Imperial.J27>0;Imperial.J27;"""")","=IF (Imperial.K27>0;Imperial.K27;"""")",, "=IF (Imperial.A28>0;Imperial.A28;"""")","=IF (Imperial.B28>0;Imperial.B28*25.4;"""")","=IF (Imperial.C28>0;Imperial.C28*25.4;"""")","=IF (Imperial.D28>0;Imperial.D28*25.4;"""")","=IF (Imperial.E28>0;Imperial.E28*25.4;"""")","=IF (Imperial.F28>0;Imperial.F28*25.4;"""")","=IF (Imperial.G28>0;Imperial.G28;"""")","=IF (Imperial.H28>0;Imperial.H28;"""")","=IF (Imperial.I28>0;Imperial.I28;"""")","=IF (Imperial.J28>0;Imperial.J28;"""")","=IF (Imperial.K28>0;Imperial.K28;"""")",, "=IF (Imperial.A29>0;Imperial.A29;"""")","=IF (Imperial.B29>0;Imperial.B29*25.4;"""")","=IF (Imperial.C29>0;Imperial.C29*25.4;"""")","=IF (Imperial.D29>0;Imperial.D29*25.4;"""")","=IF (Imperial.E29>0;Imperial.E29*25.4;"""")","=IF (Imperial.F29>0;Imperial.F29*25.4;"""")","=IF (Imperial.G29>0;Imperial.G29;"""")","=IF (Imperial.H29>0;Imperial.H29;"""")","=IF (Imperial.I29>0;Imperial.I29;"""")","=IF (Imperial.J29>0;Imperial.J29;"""")","=IF (Imperial.K29>0;Imperial.K29;"""")",, "=IF (Imperial.A30>0;Imperial.A30;"""")","=IF (Imperial.B30>0;Imperial.B30*25.4;"""")","=IF (Imperial.C30>0;Imperial.C30*25.4;"""")","=IF (Imperial.D30>0;Imperial.D30*25.4;"""")","=IF (Imperial.E30>0;Imperial.E30*25.4;"""")","=IF (Imperial.F30>0;Imperial.F30*25.4;"""")","=IF (Imperial.G30>0;Imperial.G30;"""")","=IF (Imperial.H30>0;Imperial.H30;"""")","=IF (Imperial.I30>0;Imperial.I30;"""")","=IF (Imperial.J30>0;Imperial.J30;"""")","=IF (Imperial.K30>0;Imperial.K30;"""")",, "=IF (Imperial.A31>0;Imperial.A31;"""")","=IF (Imperial.B31>0;Imperial.B31*25.4;"""")","=IF (Imperial.C31>0;Imperial.C31*25.4;"""")","=IF (Imperial.D31>0;Imperial.D31*25.4;"""")","=IF (Imperial.E31>0;Imperial.E31*25.4;"""")","=IF (Imperial.F31>0;Imperial.F31*25.4;"""")","=IF (Imperial.G31>0;Imperial.G31;"""")","=IF (Imperial.H31>0;Imperial.H31;"""")","=IF (Imperial.I31>0;Imperial.I31;"""")","=IF (Imperial.J31>0;Imperial.J31;"""")","=IF (Imperial.K31>0;Imperial.K31;"""")",, "=IF (Imperial.A32>0;Imperial.A32;"""")","=IF (Imperial.B32>0;Imperial.B32*25.4;"""")","=IF (Imperial.C32>0;Imperial.C32*25.4;"""")","=IF (Imperial.D32>0;Imperial.D32*25.4;"""")","=IF (Imperial.E32>0;Imperial.E32*25.4;"""")","=IF (Imperial.F32>0;Imperial.F32*25.4;"""")","=IF (Imperial.G32>0;Imperial.G32;"""")","=IF (Imperial.H32>0;Imperial.H32;"""")","=IF (Imperial.I32>0;Imperial.I32;"""")","=IF (Imperial.J32>0;Imperial.J32;"""")","=IF (Imperial.K32>0;Imperial.K32;"""")",, "=IF (Imperial.A33>0;Imperial.A33;"""")","=IF (Imperial.B33>0;Imperial.B33*25.4;"""")","=IF (Imperial.C33>0;Imperial.C33*25.4;"""")","=IF (Imperial.D33>0;Imperial.D33*25.4;"""")","=IF (Imperial.E33>0;Imperial.E33*25.4;"""")","=IF (Imperial.F33>0;Imperial.F33*25.4;"""")","=IF (Imperial.G33>0;Imperial.G33;"""")","=IF (Imperial.H33>0;Imperial.H33;"""")","=IF (Imperial.I33>0;Imperial.I33;"""")","=IF (Imperial.J33>0;Imperial.J33;"""")","=IF (Imperial.K33>0;Imperial.K33;"""")",, "=IF (Imperial.A34>0;Imperial.A34;"""")","=IF (Imperial.B34>0;Imperial.B34*25.4;"""")","=IF (Imperial.C34>0;Imperial.C34*25.4;"""")","=IF (Imperial.D34>0;Imperial.D34*25.4;"""")","=IF (Imperial.E34>0;Imperial.E34*25.4;"""")","=IF (Imperial.F34>0;Imperial.F34*25.4;"""")","=IF (Imperial.G34>0;Imperial.G34;"""")","=IF (Imperial.H34>0;Imperial.H34;"""")","=IF (Imperial.I34>0;Imperial.I34;"""")","=IF (Imperial.J34>0;Imperial.J34;"""")","=IF (Imperial.K34>0;Imperial.K34;"""")",, "=IF (Imperial.A35>0;Imperial.A35;"""")","=IF (Imperial.B35>0;Imperial.B35*25.4;"""")","=IF (Imperial.C35>0;Imperial.C35*25.4;"""")","=IF (Imperial.D35>0;Imperial.D35*25.4;"""")","=IF (Imperial.E35>0;Imperial.E35*25.4;"""")","=IF (Imperial.F35>0;Imperial.F35*25.4;"""")","=IF (Imperial.G35>0;Imperial.G35;"""")","=IF (Imperial.H35>0;Imperial.H35;"""")","=IF (Imperial.I35>0;Imperial.I35;"""")","=IF (Imperial.J35>0;Imperial.J35;"""")","=IF (Imperial.K35>0;Imperial.K35;"""")",, ,,,,,"=IF (Imperial.F36>0;Imperial.F36*25.4;"""")","=IF (Imperial.G36>0;Imperial.G36;"""")","=IF (Imperial.H36>0;Imperial.H36;"""")","=IF (Imperial.I36>0;Imperial.I36;"""")","=IF (Imperial.J36>0;Imperial.J36;"""")","=IF (Imperial.K36>0;Imperial.K36;"""")",, "=IF (Imperial.A37>0;Imperial.A37;"""")","=IF (Imperial.B38>0;Imperial.B38*25.4;"""")","=IF (Imperial.C38>0;Imperial.C38*25.4;"""")","=IF (Imperial.E38>0;Imperial.E38*25.4;"""")","=IF (Imperial.F38>0;Imperial.F38*25.4;"""")","=IF (Imperial.G38>0;Imperial.G38;"""")","=IF (Imperial.H38>0;Imperial.H38;"""")","=IF (Imperial.H37>0;Imperial.H37;"""")","=IF (Imperial.I37>0;Imperial.I37;"""")","=IF (Imperial.J37>0;Imperial.J37;"""")",,, "=IF (Imperial.A38>0;Imperial.A38;"""")",,,,,,,,,,,, "=IF (Imperial.A39>0;Imperial.A39;"""")",,,,,,,,,,,, "=IF (Imperial.A42>0;Imperial.A42;"""")",,,,,,,,,,,, "=IF (Imperial.A43>0;Imperial.A43;"""")",,,,,,,,,,,, "=IF (Imperial.A43>0;Imperial.A43;"""")",,,,,,,,,,,, "=IF (Imperial.A45>0;Imperial.A45;"""")",,,,,,,,,,,, "=IF (Imperial.A46>0;Imperial.A46;"""")","=IF (Imperial.B47>0;Imperial.B47*25.4;"""")","=IF (Imperial.C47>0;Imperial.C47*25.4;"""")","=IF (Imperial.E47>0;Imperial.E47*25.4;"""")","=IF (Imperial.F47>0;Imperial.F47*25.4;"""")","=IF (Imperial.G47>0;Imperial.G47;"""")","=IF (Imperial.H47>0;Imperial.H47;"""")","=IF (Imperial.I47>0;Imperial.I47;"""")","=IF (Imperial.J47>0;Imperial.J47;"""")","=IF (Imperial.K47>0;Imperial.K47;"""")",,, "=IF (Imperial.A47>0;Imperial.A47;"""")","=IF (Imperial.B48>0;Imperial.B48*25.4;"""")","=IF (Imperial.C48>0;Imperial.C48*25.4;"""")","=IF (Imperial.E48>0;Imperial.E48*25.4;"""")","=IF (Imperial.F48>0;Imperial.F48*25.4;"""")","=IF (Imperial.G48>0;Imperial.G48;"""")","=IF (Imperial.H48>0;Imperial.H48;"""")","=IF (Imperial.I48>0;Imperial.I48;"""")","=IF (Imperial.J48>0;Imperial.J48;"""")","=IF (Imperial.K48>0;Imperial.K48;"""")",,, "=IF (Imperial.A48>0;Imperial.A48;"""")",,,,,,,,,,,, "=IF (Imperial.A49>0;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

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 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. :-)

Oh -- not things like the remaining lengths of hex 12L14 (6' and less) and other purchased bar or sheet stock.

O.K. There are also nice bearings in hard drives as well

--sometime difficult to extract cleanly.

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.

Hmm ... already an assumption for how a program works which does not fit mutt (my e-mail client) or slrn (my newsreader). :-)

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.

O.K.

O.K. I had not noticed that.

O.K.

Good enough.

:-)

:-)

BTW Is the GoJo container empty or still loaded with GoJo?

Enjoy, DoN.

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!

(...)

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.

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.

(...)

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.

(...)

I'm on my last bottle, but never fear because I ordered a new case of them yesterday! That is good stuff!

--Winston

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.

It did indeed.

[ ... ]

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.

[ ... ]

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. :-)

Or be used as rotors in Tesla turbines. :-)

Good enough.

O.K. That sounds reasonable and flexible.

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.

(...)

Good!

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!

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 have one that holds my DMM leads for perfect accessibility on my workbench and half a dozen more holding up paper for ready reference.

So.. that wouldn't work? :)

YEAH!

(...)

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

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".

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 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 :)

Jim Wilkins wrote: (...)

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.

That is exactly my point. We are surrounded by resources. We are unaware of too many of them.

/ 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/

And why not? :)

(...)

You can bet there were many pairs of rolling eyes.

--Winston

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.

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.)

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.

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.

Hmm ... my (Fluke) DMM leads appear to be tin-plated brass, so the strongest magnet around would do little to hold them. :-)

Of course it would -- as long as you wanted the data which was on them to be gone for security reasons. :-)

[ ... ]

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.

DoN. Nichols wrote: (...)

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.

(...)

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.

That's far outside the 'project charter' as it stands right now.

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!

(...)

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.

Good!

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.

I have my DMM leads looped over the protruding end of one of those magnets. Works Great!

Write Only Memory? Kewl!

It should go in the Circular File anyway. The idea is to make others aware of your novel use of this can!

I agree. Any takers? :)

--Winston

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.

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;

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

OK, those two are now in the File. Thanks!

In the File. Thanks!

(...)

Very cool! Nice looking projects.

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.

Good tips.

--Winston

...

The rec.crafts.metalworking wiki at allows file uploads and would be an appropriate site for such files in .csv and/or .ods format. For wiki file upload instructions, see . 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.