camoz
28th February 2013, 04:09 PM
Hi all,
So today I looked around for a downloadable excel file to do quick conversions from fractions of an inch to mm's, but I also wanted to specify how accurate I wanted it to round to (eg to 16ths or 1000ths of an inch), I also wanted it to tell me what the difference between the closes imperial and the actual mm I entered (I often use this when I want to drill a hole and want to know how tight or loose it will end up being (I like the conversion button on the callipers, but it doesn't help me to know it is 0.3125 inches when what I really want to know is that it is 5/16).
Anyway all I could find were internet ones and nothing that I could customise, so I thought it was time I made my own. At the bottom I also added an imperial to mm converter, which allows me to put in feet and inches with fractions of inches, should I want to change a US based plan etc.
I do have a computer in the garage (I know who does that, I mainly use it for music), but I also thought I should do a bit of a printed reference chart to 128ths so I can see at a glance, or if my hands are covered in glue etc.
I had a bit of a search on the forum, so I apologise if I am adding something that already exists, but I thought it might help others that perhaps are not as used to putting formulas into an excel spread sheet (some of these formulas are a bit advanced). I have tried not to make it too fancy (no macros, blocked cells etc. to prevent messages from popping up on people, and I figured if you accidentally copy over a cell and save the file, you can always come back and download another one anyway).
Please note it is relatively untested (not much too it, so everything should be correct with the math, but if you do find anything wrong, please let me know and I will change it for everyone).
I have saved it as an older version (for anyone that has excel 97 or later), but I only have the 2010 version, (it told me that some formatting might change when I saved it as the older version, so if the borders or something is wrong let me know)
Below is a picture of what it looks like:
255971
This is the excel File with the converter:
255972
And the chart I made to print out:
255973
Cheers,
Camo
So today I looked around for a downloadable excel file to do quick conversions from fractions of an inch to mm's, but I also wanted to specify how accurate I wanted it to round to (eg to 16ths or 1000ths of an inch), I also wanted it to tell me what the difference between the closes imperial and the actual mm I entered (I often use this when I want to drill a hole and want to know how tight or loose it will end up being (I like the conversion button on the callipers, but it doesn't help me to know it is 0.3125 inches when what I really want to know is that it is 5/16).
Anyway all I could find were internet ones and nothing that I could customise, so I thought it was time I made my own. At the bottom I also added an imperial to mm converter, which allows me to put in feet and inches with fractions of inches, should I want to change a US based plan etc.
I do have a computer in the garage (I know who does that, I mainly use it for music), but I also thought I should do a bit of a printed reference chart to 128ths so I can see at a glance, or if my hands are covered in glue etc.
I had a bit of a search on the forum, so I apologise if I am adding something that already exists, but I thought it might help others that perhaps are not as used to putting formulas into an excel spread sheet (some of these formulas are a bit advanced). I have tried not to make it too fancy (no macros, blocked cells etc. to prevent messages from popping up on people, and I figured if you accidentally copy over a cell and save the file, you can always come back and download another one anyway).
Please note it is relatively untested (not much too it, so everything should be correct with the math, but if you do find anything wrong, please let me know and I will change it for everyone).
I have saved it as an older version (for anyone that has excel 97 or later), but I only have the 2010 version, (it told me that some formatting might change when I saved it as the older version, so if the borders or something is wrong let me know)
Below is a picture of what it looks like:
255971
This is the excel File with the converter:
255972
And the chart I made to print out:
255973
Cheers,
Camo