Closed

Resource Planning Excel Spreadsheet

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

Skills: Excel, Excel Macros

See more: excel spreadsheet time planning, excel spreadsheet input data mask, planning excel spreadsheet trucking, manual data input excel spreadsheet, freelance excel spreadsheet input services indianapolis indiana, i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need a 5 page pdf excel spreadsheet, i require some visual basic programming done on a team planning excel file we are using office 2010 or later, i want an excel spreadsheet written, names and phone numbers of hospital employees that i need entered into an excel spreadsheet, I have some work, in an Excel spreadsheet., I have some work, in an Excel spreadsheet. , I have some work, in an Excel spreadsheet, Word & power point, how do i insert a word document into an excel spreadsheet, free retirement planning excel spreadsheet, multiple project resource planning excel template, resource planning excel template for multiple projects, financial planning excel spreadsheet, free retirement planning excel spreadsheet uk

About the Employer:
( 0 reviews ) SYDNEY OLYMPIC PARK, Australia

Project ID: #28266367

21 freelancers are bidding on average $148 for this job

schoudhary1553

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

$180 AUD in 3 days
(380 Reviews)
8.1
(408 Reviews)
7.5
Teloquence

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.

$140 AUD in 7 days
(330 Reviews)
7.7
(291 Reviews)
7.8
(147 Reviews)
6.8
(62 Reviews)
6.6
daniyal3214

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

$100 AUD in 1 day
(102 Reviews)
6.2
sevillajk01

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!

$250 AUD in 7 days
(52 Reviews)
5.2
rIbrarahmed

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

$40 AUD in 1 day
(23 Reviews)
5.0
(4 Reviews)
3.4
Emmyope93

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 More

$89 AUD in 3 days
(4 Reviews)
3.2
sinnugan38

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

$200 AUD in 3 days
(2 Reviews)
2.3
globalgo

=-----------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

$50 AUD in 1 day
(6 Reviews)
2.2
dhruv196

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.

$111 AUD in 7 days
(1 Review)
1.7
hamidr2020

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

$55 AUD in 3 days
(5 Reviews)
1.4
AustenMMurray

I have made something very similar for the firm I work for. Lets chat and see if we can get this done.

$250 AUD in 3 days
(0 Reviews)
0.0
facchingabriel

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

$140 AUD in 7 days
(0 Reviews)
0.0
nawzin

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 More

$125 AUD in 3 days
(0 Reviews)
0.6
Sergiobusquets

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

$101 AUD in 2 days
(0 Reviews)
0.0
Dmasyithah95

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

$140 AUD in 7 days
(0 Reviews)
0.0