The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Calibration and Metrology Software and Hardware
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access

Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
calibration software, microsoft excel .xls .xlsx spreadsheet, calibration (general topics), databases
Reply
 
Thread Tools Search this Thread Rate Thread Content Display Modes
  #1  
Old 18th August 2011, 03:05 PM
zac2944 zac2944 is offline
Involved in Discussions

 
Registration Date: May 2010
Location: Upstate NY
 
Posts: 31
Thanks Given to Others: 9
Thanked 47 Times in 9 Posts
Karma Power: 21
Karma: 245
zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.
Look! Excel Calibration Database .xls file

Attached is a database I created in Excel for tracking calibration of basic inspection equipment. I'm by no means an expert with excel or calibration, but I though others might find this useful or be able to improve on it. I have picked up a lot of useful info from this site and hopefully this can give back some.

File is Excel 2010, any protected sheets have a blank password.

Feedback and questions are welcome.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: xlsm Calibration Database.xlsm (955.6 KB, 2777 views)

Sponsored Links
  #2  
Old 18th August 2011, 04:35 PM
Marc's Avatar
Marc Marc is online now
Your Elsmar Cove Host

 
Registration Date: Jan 1996
Location: West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,128
Thanks Given to Others: 9,565
Thanked 5,222 Times in 3,308 Posts
Blog Entries: 4
Karma Power: 400
Karma: 32252
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Re: Excel Calibration Database attached

We appreciate your sharing this!

__________________

A Search is a terrible thing to waste!
One Test is Worth 1000 Expert Opinions - The plural of anecdote is not data - Correlation does not imply Causation
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Thanks to Marc for your informative Post and/or Attachment!
Sponsored Links

  #3  
Old 19th August 2011, 11:49 PM
simonyeeklang's Avatar
simonyeeklang simonyeeklang is offline
Welcome Simon Yee

 
Registration Date: May 2011
Location: Klang, Selangor, Malaysia
 
Posts: 41
Thanks Given to Others: 0
Thanked 3 Times in 3 Posts
Karma Power: 18
Karma: 25
simonyeeklang has less than 100 Karma points so far.
Send a message via MSN to simonyeeklang Send a message via Yahoo to simonyeeklang
Re: Excel Calibration Database attached

Hi, in the Instrument what type of information to type in? Alpha and numeric cant key in? Thanks simon yee
Thanks to simonyeeklang for your informative Post and/or Attachment!
  #4  
Old 22nd August 2011, 02:16 PM
zac2944 zac2944 is offline
Involved in Discussions

 
Registration Date: May 2010
Location: Upstate NY
 
Posts: 31
Thanks Given to Others: 9
Thanked 47 Times in 9 Posts
Karma Power: 21
Karma: 245
zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.
Re: Excel Calibration Database attached

This field should be a drop down selection.

Based on a PM I received it appears that there may be issues with the macros. I was afraid this might happen.

I will have to try downloading the file onto another computer to work out the bugs.
Thank You to zac2944 for your informative Post and/or Attachment!
  #5  
Old 23rd September 2011, 10:52 AM
zac2944 zac2944 is offline
Involved in Discussions

 
Registration Date: May 2010
Location: Upstate NY
 
Posts: 31
Thanks Given to Others: 9
Thanked 47 Times in 9 Posts
Karma Power: 21
Karma: 245
zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.zac2944 is appreciated, and has over 200 Karma points.
Re: Excel Calibration Database attached

Just an update. I have been able to load this program on several PCs and run it without any issues.

To learn more about this spreadsheet and how it works you'll have to view some of the hidden tabs (File\Options\Advanced\Show Sheet Tabs, in '07), and check out the macros.

By updating the dropdown lists via the hidden tab you should be able to customize this sheet pretty easy.
Thank You to zac2944 for your informative Post and/or Attachment!
  #6  
Old 23rd September 2011, 01:18 PM
silentrunning's Avatar
silentrunning silentrunning is offline
Q. A. Manager

 
Registration Date: Apr 2007
Location: Sarasota, Florida
 
Posts: 538
Thanks Given to Others: 480
Thanked 301 Times in 189 Posts
Karma Power: 87
Karma: 2103
silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.silentrunning is appreciated, and has over 1700 Karma points.
Re: Excel Calibration Database attached

It downloaded fine for me. This is great food for thought. Thanks.

__________________

Doug
W4JDZ
  #7  
Old 27th September 2011, 08:22 AM
ferkoattila ferkoattila is offline
Getting Involved (6 to 9 Posts)

 
Registration Date: Sep 2011
Location: Oradea, Romania Europe
 
Posts: 7
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 12
Karma: 10
ferkoattila has less than 100 Karma points so far.
Re: Excel Calibration Database attached

Hello all,

I need calibration database software. Can anybody help with this???
  #8  
Old 28th September 2011, 08:08 AM
Marc's Avatar
Marc Marc is online now
Your Elsmar Cove Host

 
Registration Date: Jan 1996
Location: West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,128
Thanks Given to Others: 9,565
Thanked 5,222 Times in 3,308 Posts
Blog Entries: 4
Karma Power: 400
Karma: 32252
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.Marc is appreciated, and has over 1700 Karma points.
Question Re: Excel Calibration Database attached

Are you referring to the one in this thread?

__________________

A Search is a terrible thing to waste!
One Test is Worth 1000 Expert Opinions - The plural of anecdote is not data - Correlation does not imply Causation
We can't solve problems by using the same kind of thinking we used when we created them. - Unknown
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > ISO (International Organization for Standardization) Standards > ISO 17025 - General Metrology, Measurement Device, Calibration and Test Laboratories > Calibration and Metrology Software and Hardware

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
RPN Ranking - Put a formula in an access database or Excel .xls spreadsheet Spanner Excel .xls Spreadsheet Templates and Tools 12 2nd September 2008 12:55 AM
Customer Concerns Trend Database to Share .xls Excel file Crusader Customer Complaints including ISO 10002 17 29th March 2008 12:31 PM
Validation through Cgk Excel .xls file needed luciano Excel .xls Spreadsheet Templates and Tools 4 18th October 2006 08:09 AM
Formatting an Excel .xls spreadsheet to alarm out-of-calibration status Jennifer Kirley Excel .xls Spreadsheet Templates and Tools 11 10th May 2006 02:35 AM
Excel .xls spreadsheet file for Gage R&R for Variable Data sxbalasu Excel .xls Spreadsheet Templates and Tools 6 28th April 2006 03:29 AM



The time now is 11:20 AM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272