I want a high level resource planning spreadsheet that links resources (technicians) to projects and create a summary table report to identify any significant discrepancies between budget estimate and scheduled time. It does not need dials or graphs.
1. Extend to Jul 2021 (all views)
a. Resource Overview
i. Table 1: calculate data
1. Tech Scheduled
2. Project Planned Hours
3. Project Scheduled Hours
b. Tech Availability Summary
i. Table 2 = Total Hours by Tech from ‘Scheduling Worksheet’
c. Project Summary by month
i. Budget from Reference Data
ii. Total Scheduled Hours (and month break down)
iii. Variance of scheduled hours Vs budget
d. Tech Time by Projects Summary
i. Project Summary
ii. Technicians – total hours by tech & project from ‘Scheduling’
3. Scheduling Input
a. Ability to modify the Months & days for future use / change
b. Change formatting to assist usability
4. Tech Daily Time (Output Only)
a. Total time per tech on any given day
i. Colour coded
<6 hours (Blue)
6-8 hours (Orange)
8+ Hours (Red)
5. Test data to show it works
21 freelancers are bidding on average $148 for this job
Excel expert at your service. Please check my past reviews for your reference. Looking forward for your reply so that I can start with the implementation.
hello! I can help you with your excel project. I can create automated time tracker and gantt chart for your team. To assess my capability please do see reviews from my previous projects. thanks!
=-----------I can do ur project perfectly--- I read your project carefully and I can help you. I am Excel VBA expert. and I have 10+years experience in c, c++,etc. u can see my review. please chat with me. thank you
Hello Sir, Greetings I am good at Excel and create dashboard as per your requirement. I have done project on excel on user form, dashboard, vba. I can do it with perfection. Looking forward to hearing from you.