Find Jobs
Hire Freelancers

Resouce allocation in excel

$10-30 AUD

Closed
Posted over 6 years ago

$10-30 AUD

Paid on delivery
I have a task where i have 20+ projects, with 50+ staff to allocate to the projects. Some staff are allocated at 100% from date A to date B. Some are allocated on part projects ie 60% and 40 % across different days. I am trying to build a resource allocation excel tool where i can allocate the staff to the projects and can visually see their availability. If the visual can show green for 100% allocated or orange or red for non 100% allocated. Can something like this be built. Need helps please
Project ID: 15333656

About the project

18 proposals
Remote project
Active 6 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
18 freelancers are bidding on average $71 AUD for this job
User Avatar
I have done a similar job allocation project recently. It worked perfectly. (we used dynamic pivot tables to display the availability) I can show you samples. Contact me to discuss further. Thanks. Relevant Skills and Experience Excel, VBA, Project Management Proposed Milestones $263 AUD - job done
$263 AUD in 7 days
5.0 (140 reviews)
7.1
7.1
User Avatar
Hi Relevant Skills and Experience I am good in excel project Proposed Milestones $25 AUD - 1
$25 AUD in 1 day
4.5 (12 reviews)
4.5
4.5
User Avatar
Excel expert with extensive vba and programming experience. I can help you with your resurce allocation. Relevant Skills and Experience I have worked for several years in excel and perform daily work using vba, user forms, pivot tables, formulas, etc. Proposed Milestones $33 AUD - Since this is a small project, one milestone at the end. Additional Services Offered $1 AUD - I would start by committing to 10 day but this depends on the scope and could change 1 question I would have is how you would like the interface to look. This will drive the solution.
$33 AUD in 3 days
5.0 (1 review)
3.8
3.8
User Avatar
Hi I would like to bid for this project. I posses Data Analytics, Accountancy, Administration, Banking and Content Writing experience with Advance MS Excel Dashboards, MS & Google Office, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
$30 AUD in 2 days
5.0 (10 reviews)
3.2
3.2
User Avatar
Hello. I bid for this project because I'm a professional with lot of experience in MS Excel and VBA programming (macros) Habilidades y experiencia relevante I guarantee you an accurate job, full functionality and fast delivery, all this in exchange of a fair rate that is perfectly adjusted to your budget. Htos propuestos $25 AUD - Designing a resource allocation spreadsheet in Excel
$25 AUD in 2 days
4.7 (8 reviews)
2.8
2.8
User Avatar
Hi Dear, I can meet all your requirements as mentioned in the project description, please discuss in detail over the chat. Relevant Skills and Experience 7+ years of experience, Hands on knowledge of Advanced Excel (Comfortable With The Formulas Like - Vlookup, Hlookup, Pivot, Sumif, Countif, Sumproduct, Concatenate, If, Then, Else, Macros (VBA) Etc…) Proposed Milestones $30 AUD - post discussion please share the data
$30 AUD in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
Hi, This is Ms. Farhana. Let me introduce as a hard working data entry worker. Relevant Skills and Experience I read your job details I can do this. I have outstanding skill and proficiency in relevant field . Proposed Milestones $25 AUD - I want in one milestone.
$25 AUD in 1 day
4.8 (4 reviews)
1.9
1.9
User Avatar
I am highly skilled in Excel and have been developing spreadsheets and macros for several years.
$25 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am interested on your job posted. I am a hardworking and flexible person. Relevant Skills and Experience I have an a knowledge in excel. My working experience is a data entry. I am willing to train for the task of job you posted
$25 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Bid is for 1 day work. Relevant Skills and Experience I am a math teacher with experience in Excel, Spss and R-project. Proposed Milestones $45 AUD - excel expert
$45 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Having experience of mentioned work. We can surly achieve KPI
$30 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will do it quick using formulas. Relevant Skills and Experience Excel formulas, PT Proposed Milestones $25 AUD - Azerbaijan Please provide me sample.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi - I am confident I can provide you with a good visual tool in excel for this. I am a uk chartered accountant with 20 years finance experience in software/consulting firms. Many thanks James
$30 AUD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since May 31, 2015

Client Verification

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.