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!

Compétences : Excel, Gestion de Projet

en voir plus : 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

Concernant l'employeur :
( 2 commentaires ) Warrington, United Kingdom

Nº du projet : #15647611

Décerné à:


Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% GBP en 2 jours
(620 Commentaires)

18 freelance font une offre moyenne de £162 pour ce travail


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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(145 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(51 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(38 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(133 Commentaires)

I am a professional freelancer having expertise in MS Excel and I can complete your task effectively and efficiently in a timely manner. Portfolio: https://www.freelancer.in/u/KavTan.html Relevant Skills and Experien Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(37 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 0 jours
(77 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(25 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(45 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(9 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(2 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(1 Évaluation)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(1 Évaluation)

A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(1 Évaluation)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)