Excel Calibration Database .xls file

Re: Excel Calibration Database attached

ferkoattila said:

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?

Click to expand...

You will need Excel 2007 or newer for this file type.

Re: Excel Calibration Database attached

Hodgepodge said:

You will need Excel 2007 or newer for this file type.

Click to expand...

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.

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.

Re: Excel Calibration Database attached

Nice Programme....
I am not seeing how to add my equipment to
your sheet....
-Bill

Re: Excel Calibration Database attached

zac2944 said:

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.

Click to expand...

I would like to change the "Equipment" data ....
specifically the instrument I.D. _ ownership _ and _ description....

any clue?

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.

Re: Excel Calibration Database attached

Hi Zac.
This looks like a handy little database which we think we'll give a go. We've been looking at the CalDueDates worksheet and it doesn't seem to have any code to auto update off the InstrumentLog one.
We were going to write something to do it but figured you might have already done it.
If you have would mind posting the revised updated version?
Many thanks, Aaron

Re: Excel Calibration Database attached

Sorry, but I haven't used that database in a while. You're on your own for updates.

Re: Excel Calibration Database attached

Thanks Zac.
We'll develop it and repost for anyone else who may find it useful.
What did you end up using instead?
Cheers, Aaron.

Re: Excel Calibration Database attached

AGDNZ said:

<snip> We'll develop it and repost for anyone else who may find it useful. <snip>

Click to expand...

That would be very much appreciated!