I am looking for a performance metrics (KPI) to measure the construction work progress.
The excel will have a dashboard spreadsheet
the 2nd spreadsheet will have all the taks
Simply the dashboard based on numerical numbers and color coded.
if a task is >70 then the task goes green.
if a task between 40 to 69 the color task indication is yellow.
if a task between < 39 the color task indication is red
38 freelancers are bidding on average $27 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
Hey, The price is low i know, Because because i just started and i need evaluation the get more work. Thank you for your understanding. PS: I am the man for this job :D
I didn't see the tasks you mentioned in the spreadsheet you attached. If you provide those tasks, and specify how they relate to the spreadsheet you attached, the dashboard should be easy to create.