Calvins calibration Tracker
$10-30 USD
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
Project ID: #27527402
About the project
Awarded to:
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
2 freelancers are bidding on average $20 for this job
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