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, turn excel based project management software web based, net window based project college management system, vb net based human resource management project source code download, human resource management project aspnet, project time management excel

About the Employer:
( 2 reviews ) Warrington, United Kingdom

Project ID: #15647611

Awarded to:


Expert Excel Programmer on and have been featured by the freelancer community Relevant Skills and Experience I am an En More

£150 GBP in 2 days
(620 Reviews)

18 freelancers are bidding on average £162 for this job


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
(145 Reviews)
£150 GBP in 3 days
(51 Reviews)

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
(38 Reviews)
£50 GBP in 3 days
(133 Reviews)

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: Relevant Skills and Experien More

£250 GBP in 5 days
(37 Reviews)

Hi, I can start the work right now and can deliver in a [login to view URL] 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
(77 Reviews)

Immediate [login to view URL], 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
(25 Reviews)
£250 GBP in 3 days
(45 Reviews)
£150 GBP in 3 days
(9 Reviews)

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)

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
(1 Review)

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

£38 GBP in 1 day
(1 Review)

A proposal has not yet been provided

£222 GBP in 5 days
(1 Review)

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)

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)
£250 GBP in 3 days
(0 Reviews)
£222 GBP in 7 days
(0 Reviews)