Resource Planning Excel Spreadsheet
Bütçe $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
Bu iş için 21 freelancer ortalamada $148 teklif veriyor
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
Hi, Good day. I understand you need a good resource planning spreadsheet work done in Excel. An excel work that provides accurate computations, analysis and great presentation while being easy to understand. I will lik Daha Fazla
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 Daha Fazla
=-----------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 Daha Fazla
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 Daha Fazla
Hi There, I'm Nizwan. I had review your sample file of the project and understand your job requirement. I had similar experience on designed Man-hour Project utilization excel model. I feel, I'm suitable candidate for Daha Fazla
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 Daha Fazla
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 Daha Fazla
