Getting vernier and micrometer measurements in to an Excel spreadsheet
Getting vernier and micrometer measurements in to an Excel spreadsheet
(OP)
Please help. Seems such a simple problem, but cannot find an easy answer.
We machine components which we then measure - length, width, thickness.
We use verniers and micrometers.
We want the Excel spreadsheet to have a row for each component, that is L, W, T
We have connected the verniers and micrometers to a PC and can capture the data - but unfortunately we can only achieve a long single column - not a two dimensional spreadsheet, where each row refers to a single component.
Our spreadsheet has some simple programming, so we can easily check the sizing against the desired dimensions.
Can anyone recommend a multiplexer, software, or other option to help get the data automatically into a spreadsheet.
Many thanks
We machine components which we then measure - length, width, thickness.
We use verniers and micrometers.
We want the Excel spreadsheet to have a row for each component, that is L, W, T
We have connected the verniers and micrometers to a PC and can capture the data - but unfortunately we can only achieve a long single column - not a two dimensional spreadsheet, where each row refers to a single component.
Our spreadsheet has some simple programming, so we can easily check the sizing against the desired dimensions.
Can anyone recommend a multiplexer, software, or other option to help get the data automatically into a spreadsheet.
Many thanks





RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
I doubt that I have any information stiil aroud but will look.
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
It seems to me we are in the same boat. I have 18 computers with "Ubuntu 9.04 Netbook remix" on the shop floor and am having trouble automatically inputting my neasurements onto an Openoffice spreadsheet. We use Mitutoyo instruments and the best result is usually a garble of datamix fom the different measuring instruments. Our cnc staff inputs by measurements by hand and my spreadsheet will compensate for temperature and also gives a "scrap" or "pass" as well as an offset change for the cnc machine if you are close to the edge of your tolerance.
Can anyone help us?????
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
If you can help that will be most appreciated
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
In Excel there is an option on which direction (ie down, left) the cursor advances when hitting enter. Some sime macro programming can advance the cursor back to the left column and down a row when 3 entries are completed.
-AK2DM
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"It's the questions that drive us"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
RE: Getting vernier and micrometer measurements in to an Excel spreadsheet
"old school method: use the keyboard "
Thanx shawnpeter
Operator keyboard input takes up more time than if the instruments do the input.
I am trying to teach myself java and C++ in the hopes that it might be usefull to sort the measuring data other than spreadsheet manipulation.