Hi team I am creating a spreadsheet that will send a notification via either email or just by a colour change in the cell.
so using forms i have a database which will be fed by the form which records the hours run by a set of compressors these comprssors require a maintenance shedule which is due in set periods of time thus when the database reaches these set points or slightly before it sends a notification thats the theory and i am sure excel can perfom this just my skills in excel dont allow it.
the setpoints would be shown in hours the periods being:
500hr service due
1000 hrs service is due or six months (whichever is sooner)
2000 hrs service is due or 12 months (whichever is sooner)
5000 hrs Major overhaul is due.
these service periods are concurrent meaning that after the hours top 5000 hours they will continue to rise or already have done so.
In this case i would be using the running hours column to trigger the notification.
This may be a little untidy atm and i plan to redo it with all the date now stored in the spreadsheet but i would rather get this right and then transpose them into the final work book.
Hi John the logger sheet was really my initial attempt at a means of creating a table that would be easy for the guys to modify so yes manually input the data there.
The other option i was exploring was to create a form which they would use that would feed in to the worksheet.
Notifications wise i was thinking maybe a email to certain team members and maybe a colour change in the cell to signify that mainenance was due.
The setpoits are hours run from installation all the current hours record are the actual hours run at this time.