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.
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
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
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
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
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
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
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
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
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
Hello I can extend the capabilities of current tool and add 1 month free support Let me know if I can help Thanks