Calibration Due Reminder Base on Excel

"Is there anyway..."

Of course there is. Get a task scheduler.

Can you not schedule it on Microsoft Outlook?

Write a macro for the excel spreadsheet.

Basically, something like:

Col1 for equipment, Col2 for start date, Col4 for period in days, then compute days from "start date" to "today" and divide by the period in Col4 and look at the remainder -use mod 15 for 15 day cycle to do this etc. Every time the answer (i.e.the remainder of the division) is one less than the period, have excel send a reminder as required (I've not done the last step but can't imagine it's too hard) as you can do almost anything with the vb language that the macro is written in.

The macro could be run automatically each day the spreadsheet is started, or it could be fired up each day within an "always on" excel spreadsheet.

A bit of Googling should find you what you are after.

I just Googled "excel scheduling" and the choices were extensive.

Googling "scheduling email excel" also had lots of choices for further reading.

Happy Googling.

Until you find a more preferrable way to do what you want to do, why not just:

- add a column in your Excel(R) task list, and title it ''Due Date'';

- insert a new row under each line-item which you want to "track";

- copy each line item row to be ''tracked'' into the blank line below it;

- enter the relevant due-date for each line-item into the relevent due-date cell;

- and, when all your additions are entered, ''Sort'' the spreadsheet on Due-Date?

(... and repeat the cycle as for as long as is necessary...

... Maybe you won't have to buy anything else, unless you really need to...)

Or just use Outlook or similar. Highly likely that it is in the OPs PC already and not being used to its full capabilities.

This is for work, therefore, easy is not a cop-out, it is efficient.

Good suggestion by the way. It won't send automated alerts though....

Thank you. I appreciate your supportive statement of my relatively ''old-school'' approach. ( REALLY old-school might involve a deck of index cards... )

It is implied that since the OP wants to apprise the relevant persons via email from his Excel(R) spreadsheet that all said relevant persons are on the same local net.

It is also highly probable the OP has the option to email them directly, on an appropriate time table, after he first re-sorts ( a copy? of ) his task-list database and making the necessary updates himself ( ie: "Well, this due-date just passed, so I'll advance it's due-date another month. Oh yeah, I just remembered to add a new line-item for the new (equipment) just installed last week to start out the record keeping properly. And I'll check for maintenance checks that will have to be done this week..., etc.)

Therefore, a (weekly ?) reminder could be sent to each of them just by varying the contents of the CC: field in his email.

No new software, equipment, money, or other new materials are needed to do the basic maintence scheduling function, unless there are dozens and dozens of such checks to be done each week, that is...