Getting vernier and micrometer measurements in to an Excel spreadsheet 2

[HiEnd]

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

 

[unclesyd]

I can't offer any specific information but i can tell you there i equipment available for this.
I doubt that I have any information stiil aroud but will look.

 

[THEaceofspades]

Hi HiEnd
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?????

 

[HiEnd]

Dear Unclesyd
If you can help that will be most appreciated

 

[analogkid2digitalman]

Check out the software and hardware wedge products from Microridge. The wedges can collect, parse, and format data and act as if someone typed it in at the keyboard. They can also save data to directly to a disk file.

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

 

[Compositepro]

I had to do something similar with data from a universal test machine. I can't give any details, as this was a few years ago, but once you have data in your computer Excel should be able to manipulate it any way you want. You have to understand your data format and Excel. Your data is probably in ASCII with some character delimiting the data fields. Consult a book or expert in Excel. I was surprised at how easy it turned-out to be. All the data was placed in columns, and what wasn't data just displayed as text.

 

[shawnpeter]

old school method: use the keyboard

 

[THEaceofspades]

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