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
NQA-USA
NQA-USA
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

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 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: 13
Karma: 10
ferkoattila has less than 100 Karma points so far.
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 Marc is online now
Your Elsmar Cove Host

 
Registration Date: Jan 1996
Location: Olde West Chester - Southern Ohio - USA
Age: 64
 
Posts: 24,343
Thanks Given to Others: 9,902
Thanked 5,436 Times in 3,409 Posts
Blog Entries: 4
Karma Power: 400
Karma: 33322
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.
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

__________________

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

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

 
Registration Date: Jul 2008
Location: Phoenix, Arizona, U.S.A.
Age: 43
 
Posts: 281
Thanks Given to Others: 635
Thanked 245 Times in 149 Posts
Karma Power: 61
Karma: 3775
Hodgepodge is appreciated, and has over 1700 Karma points.
Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.Hodgepodge is appreciated, and has over 1700 Karma points.
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.

__________________

None of the secrets of success will work unless you do. - Fortune Cookie
Thanks to Hodgepodge for your informative Post and/or Attachment!
  #12  
Old 30th September 2011, 01:16 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: 13
Karma: 10
ferkoattila has less than 100 Karma points so far.
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 zac2944 is offline
Involved in Discussions

 
Registration Date: May 2010
Location: Upstate NY
 
Posts: 31
Thanks Given to Others: 9
Thanked 49 Times in 9 Posts
Karma Power: 22
Karma: 255
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

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 sigmoid59 is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Jan 2012
 
Posts: 2
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 12
Karma: 10
sigmoid59 has less than 100 Karma points so far.
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 sigmoid59 is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Jan 2012
 
Posts: 2
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 12
Karma: 10
sigmoid59 has less than 100 Karma points so far.
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 zac2944 is offline
Involved in Discussions

 
Registration Date: May 2010
Location: Upstate NY
 
Posts: 31
Thanks Given to Others: 9
Thanked 49 Times in 9 Posts
Karma Power: 22
Karma: 255
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

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 09:53 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".