Resource Planning Excel Spreadsheet
Budget $30-250 AUD
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.
Instructions
1. Extend to Jul 2021 (all views)
2. Dashboard
a. Resource Overview
i. Table 1: calculate data
1. Tech Scheduled
2. Project Planned Hours
3. Project Scheduled Hours
4. Variances
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
Hi, Greetings! ✅checked your project details: Resource Planning Excel Spreadsheet ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projec More
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.
I can perfectly help you in developing a Resource Planning Sheet. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and More
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!
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse More
Hello! I have read your requirement carefully, so I am very interested your project. I have rich experience with data processing using Excel VBA. I will finish your Excel VBA project in time with high quality Hope your More
=-----------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.
Hello, I have read your project details / instructions and have gone through the attached "Resource Planning" spreadsheet. I am highly interested in your project and would love to work on "Resource Planning Excel Sprea More
I have made something very similar for the firm I work for. Lets chat and see if we can get this done.
Hello, I am graduated in advanced excel and I will be able to do this job for you quickly, after receiving the data and everything. If you hire me you will not regret it, I will do my best to make it the way you want i More
Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call me a "Prince of Excel". I promise I will More
Handle the staff including manage related to staff which is, handle human resource task as a handle staff card, recorded sick leave of staff. I also manage staff allowance, create every official letter that required fr More
