Find Jobs
Hire Freelancers

Resource Planning Excel Spreadsheet

$30-250 AUD

Closed
Posted over 3 years ago

$30-250 AUD

Paid on delivery
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
Project ID: 28266367

About the project

19 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average $147 AUD for this job
User Avatar
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 projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast
$180 AUD in 3 days
4.9 (390 reviews)
8.2
8.2
User Avatar
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
4.9 (329 reviews)
7.7
7.7
User Avatar
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 Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$100 AUD in 1 day
4.7 (111 reviews)
6.7
6.7
User Avatar
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
4.9 (56 reviews)
5.3
5.3
User Avatar
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 myself for this project. please contact with me. Thanks.
$40 AUD in 1 day
4.9 (24 reviews)
5.0
5.0
User Avatar
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 Spreadsheet" project. I understand your requirements and would be pleased to discuss further. You can initiate the chat or send me a message so that we can move forward. I assure you accuracy and quality work. Looking forward for working with you. Regards, Hamid
$55 AUD in 3 days
5.0 (11 reviews)
4.1
4.1
User Avatar
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 like to assist you on this project. I have delivered similar projects here on freelancer (evidenced in my reviews) and can share sample of my work with you. A Little More About Me I am a young, intuitive, savvy and smart Business Consultant currently practicing in the Consulting Service line at a Big 4 financial services firm (one of the four biggest professional services companies globally) with experience cutting across Business Consulting, Agro Business Management and the Food Industry. My areas of competency include; Financial Risk Modeling, Financial Data Analysis, Corporate Advisory Services, Management Consulting, Business Plan and Report Writing. Based on my current role at work, I have been involved in extensive model development, financial modeling and data analysis, market research, writing of case-studies, development and writing of excellent articles, proposals, analysis reports and provision of contents for different clients (most especially online web related types), all in native English. I look forward to enjoying an excellent professional relationship with you on this project of yours. Thank you. Best Regards, Emmanuel
$89 AUD in 3 days
5.0 (4 reviews)
3.2
3.2
User Avatar
=-----------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
4.9 (8 reviews)
3.2
3.2
User Avatar
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
5.0 (1 review)
1.7
1.7
User Avatar
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 delivered on your project. Appreciate it if we can arrange a chat for interview. I looking forward to getting hired by you Best regards Nizwan
$125 AUD in 3 days
0.0 (0 reviews)
0.6
0.6
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 it. Thanks.
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 from manager and also do every task company including filing, handle every license company and etc related to administration management.
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a Senior Planning Engineer with 14+ years experience in project planning & Resource Planning for Projects. Very well verse in MS Project and also Microsoft Office, especially excel. Have build multiple high level resource planning & schedules for various projects in multiple fields of industries. I would be glad to help you on your needs. Best Regards, Shahril
$250 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
SYDNEY OLYMPIC PARK, Australia
0.0
0
Payment method verified
Member since May 23, 2019

Client Verification

Other jobs from this client

Blog / Content Writing
$30-250 AUD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.