En cours

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

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

Concernant l'employeur :
( 1 commentaire ) Warrington, United Kingdom

N° du projet : #15647611

Décerné à :

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 Plus

150 £ GBP en 2 jours
(511 Commentaires)
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 Plus

140 £ GBP en 3 jours
(112 Commentaires)
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 Plus

150 £ GBP en 4 jours
(31 Commentaires)
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 Plus

250 £ GBP en 5 jours
(37 Commentaires)
5.2
50 £ GBP en 3 jours
(62 Commentaires)
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 Plus

144 £ GBP en 3 jours
(31 Commentaires)
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 Plus

72 £ GBP en 0 jours
(43 Commentaires)
4.6
250 £ GBP en 3 jours
(42 Commentaires)
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 Plus

144 £ GBP en 3 jours
(6 Commentaires)
3.6
150 £ GBP en 3 jours
(9 Commentaires)
4.2
150 £ GBP en 3 jours
(5 Commentaires)
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 Plus

100 £ GBP en 3 jours
(2 Commentaires)
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 Plus

155 £ GBP en 4 jours
(0 Commentaires)
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 Plus

222 £ GBP en 5 jours
(0 Commentaires)
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 en 10 jours
(0 Commentaires)
0.0
Betty96

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

38 £ GBP en 1 jour
(0 Commentaires)
0.0
250 £ GBP en 3 jours
(0 Commentaires)
0.0
222 £ GBP en 7 jours
(0 Commentaires)
0.0
malleshmadhu79

A proposal has not yet been provided

222 £ GBP en 5 jours
(0 Commentaires)
0.0