Automating equipment tracking, preventative and predictive maintenance tracking activities. Develop schedule that updates needed maintenance each time spreadsheet is opened. Reset maintenance schedule each time activities are completed. One click daily and weekly work assignments based on preset maintenance schedules. One click reports.
Update: This has turned into developing real-time asset management system to use on a touch screen. Touch and drag feature on the assets images. Links to associated asset reports embedded in the movable asset image. Automated hypothetical hours calculated on a daily bases based on the floor position of the asset taking into consideration that some positions have higher run time than others. Using that accumulated hourly data to drive a visual asset meter / graph towards a predetermined asset total hour service point. Pooling of repair logs for 61 independent asset sheets to generate summary reports for a given date range. I've completed the structural elements and now need to automate the reporting processes along with fine tuning a few algorithms.
14 freelancers are bidding on average $145 for this job
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills. can make you your VBA as you have explained
Hi i am programmer and I am ready to facilities equipment management systems i will provide you 100% satisfied and quality result . i am waiting for your response . when you want to start work ?