In Progress

Modify my Excel based Project Resource Management Tool

I am a project manager and have an excel workbook that lets me plan how project resources (people) will be utilised across lots of different projects at any point in time.

Basically, you list a set of people who are available to work on projects by name and job type. You then allocate people by job type to your individual projects and state how much of their time is roughly needed. The spreadsheet then enables you to see a rolled up view of how each type of resource is under or over allocated at any point in time. You can then adjust the timing of some of your projects to ensure that you can get as much work done as possible with the people you have.

It’s a really cool tool but it has some limits. The main ones are:

- The number of resource types is limited to 10

- The number of projects is limited to 25

Please can you provide me with a quote for modifying this workbook to;

- expand the maximum number of resource types to 50 and

- expand the maximum number of projects to 200.

I’ve attached a blank copy of the spreadsheet to review.

Many thanks!

Skills: Excel, Project Management

See more: resource scheduling software, free project management templates excel 2007, resource allocation software free, best resource management software, project management dashboard excel, free excel project management tracking templates, resource management tools free, resource allocation software, Excel based project , window based project library management, excel based project, excel based project userform, excel based project management software, sort excel based project, excel based inventory management project

About the Employer:
( 1 review ) Warrington, United Kingdom

Project ID: #15647611

Awarded to:

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En More

£150 GBP in 2 days
(511 Reviews)
8.0

19 freelancers are bidding on average £161 for this job

paris2785

Hello. My name's Paris. I read your brief, inspected the attached spreadsheet and I know what it needs to be done to expand its capabilities to accommodate 50 resource types and up to 200 projects. Relevant Skills and More

£140 GBP in 3 days
(112 Reviews)
6.4
axiomswb

I have expertise in Excel.. Client's satisfaction is my first priority and believe in long-term relationship with my clients. Thanks Relevant Skills and Experience Excel,vb,Vba,web scraping,sql Proposed Milestones £1 More

£150 GBP in 4 days
(31 Reviews)
5.5
KavTan

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: [url removed, login to view] Relevant Skills and Experien More

£250 GBP in 5 days
(37 Reviews)
5.2
£50 GBP in 3 days
(62 Reviews)
5.2
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project Relevant Skills and Experience Excel, Project Management Proposed Milestones £144 GBP - Excel, Project Management Send me a More

£144 GBP in 3 days
(31 Reviews)
4.8
nwss1986

Hi, I can start the work right now and can deliver in a [url removed, login to view] is your workbook macro enabled? Relevant Skills and Experience I have been working on excel automation jobs for some years and have sound knowledge in More

£72 GBP in 0 days
(43 Reviews)
4.6
£250 GBP in 3 days
(42 Reviews)
4.7
jasalaz100

Immediate [url removed, login to view], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

£144 GBP in 3 days
(6 Reviews)
3.6
£150 GBP in 3 days
(9 Reviews)
4.2
£150 GBP in 3 days
(5 Reviews)
3.5
riccardopepe

Hi. I'm very interested in this project. It seems an easy task, and I have some question about it and about what exactly the workbook does. Please contact me and we can discuss about the project. Relevant Skills and E More

£100 GBP in 3 days
(2 Reviews)
2.5
mirajagravat

Greetings, I am a professional with expert knowledge of Excel (formulas and Macros) , would love to share my work if requested. Thank You. Relevant Skills and Experience Excel (Formulas and Macros) Project Management More

£155 GBP in 4 days
(0 Reviews)
0.0
devinblood

Hi, I am a developer, I will do this, however I need you to be available to give me feedback, lucky I'm on GMT too, and I'll need some dummy data to work with, please pm me if you're interested. Relevant Skills and E More

£222 GBP in 5 days
(0 Reviews)
0.0
vw968052vw

Hello I can extend the capabilities of current tool and add 1 month free support Let me know if I can help Thanks

£194 GBP in 10 days
(0 Reviews)
0.0
Betty96

Hey, I am interested in working on your project. Kindly message me to discuss further.

£38 GBP in 1 day
(0 Reviews)
0.0
£250 GBP in 3 days
(0 Reviews)
0.0
£222 GBP in 7 days
(0 Reviews)
0.0
malleshmadhu79

A proposal has not yet been provided

£222 GBP in 5 days
(0 Reviews)
0.0