Reading Gauge Output Into Excel .xls - Mitutoyo digital plunger type depth gauges

M

M Greenaway

#1
Hi All

We have some Mitutoyo digital plunger type depth gauges which have an output lead running through a multiplexer and outputting via an RS232 lead into the COM port of a PC, and the data output is currently being read by some SPC software.

Due to a requirement for a bulk inspection process I would like to simply take the output from the gauge and dump it into Excel.

Has anyone achieved this, and what are the basic steps ?
 
Elsmar Forum Sponsor

CarolX

Trusted Information Resource
#2
We have tried, several years ago, but with out any success. Does your software allow for exporting to Excel?
 
T

The Moose

#3
M Greenaway said:
Hi All

We have some Mitutoyo digital plunger type depth gauges which have an output lead running through a multiplexer and outputting via an RS232 lead into the COM port of a PC, and the data output is currently being read by some SPC software.

Due to a requirement for a bulk inspection process I would like to simply take the output from the gauge and dump it into Excel.

Has anyone achieved this, and what are the basic steps ?
Hi, we currently do this using a piece of software called Winwedge (from a company called Taltech) it's a data acquisition program which allows collection of data via the RS232 and also allows the program to output to the instrument via RS 232 (we use it so that when a specific barcode is entered the gauge assigned to that barcode is the only one which will work). I would need to check with the IT guys the specifics of setting it up, but can find out more if required.

Best of luck anyway
 
M

M Greenaway

#4
I have some Windmill software that alludes to doing the same thing, but the set up is somewhat beyond my limited IT knowledge.

Keeps talking about handshakes and request/receive, etc, etc
 

gard2372

Quite Involved in Discussions
#5
SPC output into Excel

We have this and curently use them as well. We have no problem putting the data into Excel. Contact your IT department have them set it up for you if you are not very computer literate. Also, get a foot pedal to click each data entry which will free up the inspector/operator's hands to handle the parts.

http://www.spcanywhere.com/asdwedge.html


Rob
 
#6
This is what we ordered as part of a corrective action to input acceptable values into an Excel spreadsheet (with conditional formatting if desired) as opposed to having operators peruse long lists of "tape readouts" for NC dimensional values . . .

264-012-10 Mitutoyo USB Data Input Tool
C-FS35-06 Mitutoyo Footswitch
also, see cable 05CZA662, which leads into the Input Tool from the gage
 
Thread starter Similar threads Forum Replies Date
N Correct reading for analog pressure gauge ISO 17025 related Discussions 2
J Japan registration need manual without temperature reading Japan Medical Device Regulations 0
U Calculate acceptance of equipment reading after calibration General Measurement Device and Calibration Topics 2
U Calculate acceptance of calibration reading Measurement Uncertainty (MU) 1
A Federal 700B-26 Gage Block Comparator is not reading properly General Measurement Device and Calibration Topics 0
O Supply chain strategy or commodity strategy reading recommendations Supplier Quality Assurance and other Supplier Issues 6
L Procedure for Comparing the Monitor Reading with Laboratory Result Statistical Analysis Tools, Techniques and SPC 4
Marc The "Reading Room" forum is still here The Reading Room 5
F DMM - Capacitance - +/- % of reading + digits? Measurement Uncertainty (MU) 3
E Uncertainty Budget with a mixture of kg and % Reading Measurement Uncertainty (MU) 4
C ISO 9001 Reading Material for Service/Small Organisations ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
AnaMariaVR2 Vacation Reading: Summer Book Report The Reading Room 0
O How can I use reading from calibration certificate in measurement Calibration Frequency (Interval) 7
K Is reading the Elsmar Cove a legitimate work related activity Coffee Break and Water Cooler Discussions 19
J Calibration of Micrometer Reading up to Three Decimals General Measurement Device and Calibration Topics 3
G Please recommend preparatory reading for AS9100 Rev C Lead Assessor Course AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 16
I ISO 9001:2008 Reading Material - Financial KPO with customers from all over the world ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
E Blueprint Reading Exam Training - Internal, External, Online and Distance Learning 1
E Absolute to Relative Uncertainty - Expressing the U as a percent of the reading Measurement Uncertainty (MU) 5
S Feedback from reading Jennifer Kirley's suggested 'motivation' reading links The Reading Room 2
S Aversion of reading The Reading Room 7
K Technicians Mis-reading Vernier Micrometers General Measurement Device and Calibration Topics 9
G Try reading this - A real brain teaser Brain Teasers and Puzzles 16
F Reading recommendation for ISO 9001, please Book, Video, Blog and Web Site Reviews and Recommendations 8
C UUT resolution and reporting uncertainty for each reading Measurement Uncertainty (MU) 2
G Calibrating a reflectometer - Scale uncertainty with reading? Measurement Uncertainty (MU) 1
R Copy of TS16949:1999 for reading purpose IATF 16949 - Automotive Quality Systems Standard 7
G Proofreading System (CCD camera reading labels) vs. 21 CFR part11 Qualification and Validation (including 21 CFR Part 11) 8
S Should we consider Precision of Machine Reading when setting Inspection Specs? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
Crusader Who has a 'Kindle' electronic reading device? Coffee Break and Water Cooler Discussions 7
Govind What is a Proof Reading Ratio? Japanese Customer Questionnaire General Measurement Device and Calibration Topics 10
G Cl 8.2 Monitoring and measurement - articles & related reading material? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
C Need Help Reading Engineering Drawings Document Control Systems, Procedures, Forms and Templates 24
Q Blueprint reading, Implied use? Drawing shows an implied orientation Manufacturing and Related Processes 17
ScottK Reading the writing on the wall in regard to your position, are you good at it? Career and Occupation Discussions 7
Crusader Layered Process Audits - Recommended Reading? Process Audits and Layered Process Audits 24
K Applicability of P Chart & U Chart - After encoding data I get no reading Statistical Analysis Tools, Techniques and SPC 1
M Are laptops part of ME SYSTEMS? Reading of IEC 60601-1 IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
B Star Wars Books - Anyone Else read/reading them? Coffee Break and Water Cooler Discussions 5
1 Anybody have a a Template or Boilerplate for "Basic Blueprint Reading"? Training - Internal, External, Online and Distance Learning 3
W Is a reading room a good idea for the Elsmar Cove? The Reading Room 40
Claes Gefvenberg Reading ability - The prospective auditor could not read Training - Internal, External, Online and Distance Learning 25
T QPD (Quality Policy Deployment) reading recomendations? Book, Video, Blog and Web Site Reviews and Recommendations 1
K Crystal Ball Methodology - reading customers' minds? IATF 16949 - Automotive Quality Systems Standard 24
apestate Recommended Reading List - Research and reading on the subject of quality Book, Video, Blog and Web Site Reviews and Recommendations 6
N Any recommended further reading for ISO/IEC 17025? ISO 17025 related Discussions 6
N Blueprint reading training - Does anybody have any recommendations? Training - Internal, External, Online and Distance Learning 6
D Funnies - You are not reading this Funny Stuff - Jokes and Humour 3
D Measuring Instruments - Training employees on reading measuring instruments Training - Internal, External, Online and Distance Learning 1
J Gauge Management - with ambiguous requirements & no support ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10

Similar threads

Top Bottom