Calvins calibration Tracker

Completed Posted 3 years ago Paid on delivery
Completed Paid on delivery

I repair and maintain medical equipment. Our corporate software tracks the medical equipment. But we have testing equipment that is tracked but not in a very transparent way. I am trying to make a spreadsheet that lists all test meters, person allocated to , clinic allocated to but here are the columns I need help with.... I want to track the calibration dates. All meters have an annual calibration requirement. So there is a column for last calibration and next due calibration. I want each meter’s row to be green if the calibration is 90 days or more before due, yellow if 45 days away, and red if 30 day’s away and another color maybe a darker red if overdue. I can’t figure out the conditional formatting to make this work. I also need the sheet to be able to accept new meters if the team buys more testing equipment. I have a sheet prepared, with some formatting if needed

Excel

Project ID: #27527402

About the project

2 proposals Remote project Active 3 years ago

Awarded to:

kingqueen369

Hi, Greetings! ✅checked your project details Calvins calibration Tracker ✅Completed Time : 24 hours(independent and fast workers only) or your requirement deadline . I would like to work on your project and want to be More

$15 USD in 1 day
(4 Reviews)
2.4

2 freelancers are bidding on average $20 for this job

khorshedswitchbd

Dear Sir, I'm interested to work with your project. I saw your work instruction and confidently tell you that I will be able to hard work in your project. I should be complete my work within the company deadline. sinc More

$25 USD in 2 days
(0 Reviews)
0.0