Elsmar Cove Forum Header Graphic 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
Miner's MSA (Measurement Systems Analysis) Blog 
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

Wooden Line

Excel Calibration Database .xls file - Page 2

Wooden Line
Search the Elsmar Cove
Search Elsmar
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
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
  #9  
Old 28th September 2011, 08:15 AM
ferkoattila

 
 
Posts: 7
Re: Excel Calibration Database attached

no, cause for me isn't work this one. I downloaded it, but my office did not open it. Do you have some offer, what software i should use?

Sponsored Links
  #10  
Old 28th September 2011, 08:23 AM
Marc's Avatar
Marc

 
 
Posts: 24,322
I Say... Re: Excel Calibration Database attached

These are the only two we have here, I think:

Calibration Databases

You might want to read through these threads:

Calibration Database Discussion Threads

All Calibration Database Discussion Threads
Thanks to Marc for your informative Post and/or Attachment!
Sponsored Links

  #11  
Old 29th September 2011, 08:37 PM
Hodgepodge's Avatar
Hodgepodge

 
 
Posts: 281
Re: Excel Calibration Database attached

Quote:
In Reply to Parent Post by ferkoattila View Post

no, cause for me isn't work this one. I downloaded it, but my office did not open it. Do you have some offer, what software i should use?
You will need Excel 2007 or newer for this file type.
Thanks to Hodgepodge for your informative Post and/or Attachment!
  #12  
Old 30th September 2011, 01:16 AM
ferkoattila

 
 
Posts: 7
Re: Excel Calibration Database attached

Quote:
In Reply to Parent Post by Hodgepodge View Post

You will need Excel 2007 or newer for this file type.
I know, but if you download the capability pack for Office 2007 i shuld work, but it dosant. Never minde, the MS Acces database is perfect.
  #13  
Old 5th October 2011, 10:01 AM
zac2944

 
 
Posts: 31
Re: Excel Calibration Database attached

The database Marc linked is very well done, and was an inspiration for the one I posted.

It was not my intention for the file I posted to be a one-size-fits-all type of database. I designed it specifically for my needs. What I think is most benificial are the macros the run the database. I've been able to use them in many other applications, and with some modification I think others may find them useful.

I'm a VBA/macros noob, and put everything together like a Frankenstien based on google searche results, but the code is pretty simple and should be easy enough for a beginner to figure out with a little effort.
Thanks to zac2944 for your informative Post and/or Attachment!
  #14  
Old 10th April 2012, 03:47 PM
sigmoid59

 
 
Posts: 2
Re: Excel Calibration Database attached

Nice Programme....
I am not seeing how to add my equipment to
your sheet....
-Bill
  #15  
Old 11th April 2012, 10:00 AM
sigmoid59

 
 
Posts: 2
Re: Excel Calibration Database attached

Quote:
In Reply to Parent Post by zac2944 View Post

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.
I would like to change the "Equipment" data ....
specifically the instrument I.D. _ ownership _ and _ description....

any clue?
  #16  
Old 31st May 2012, 02:42 PM
zac2944

 
 
Posts: 31
Re: Excel Calibration Database attached

Sorry for the delay in response. Haven't been to the Cove in a while.

A few things to get started:

-I'm using Excel '07/'10
-If sheets are protected with try blank " ", or "password". Just click Review>Unprotect sheet to edit
-Flie>Options>Advanced>Show sheet tabs

On the InstrumentLog tab you should be able to change any and all data.

This is a rather crude database, so you'll have to change code and tables manually.

Hope that helps. Good luck.
Thanks to zac2944 for your informative Post and/or Attachment!
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 08:42 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
NOTE: This forum uses "cookies".