×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Getting vernier and micrometer measurements in to an Excel spreadsheet
2

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

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

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.  

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

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

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

(OP)
Dear Unclesyd
If you can help that will be most appreciated

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

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

 

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

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.

RE: Getting vernier and micrometer measurements in to an Excel spreadsheet

old school method: use the keyboard

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources