Excel Spreadsheet for Project Management (Resource allocations)

I need an Excel spreadsheet that will calculate resource (people) allocations over time for multiple projects. I have already started the spreadsheet by creating the data entry tabs and need someone to finish the spreadsheet by creating the analysis/calculation tabs. See attached. There are user instructions in the tabs so you can see how I envision the spreadsheet to work, as well as, "Notes to the Developer (you)" on various topics. If you can think of a better way to do the data entry then that's okay as well, but please check with me first - I just wanted to be able to give you enough information to start on the project and be efficient.

Please look at the attached spreadsheet to see how I would like the spreadsheet to work:

1. Go to Resources tab to enter resources/people (there are user instructions)

2. Go to each of the Project tabs to enter work tasks and resource allocations (there are user instructions)

3. Go to Analysis tabs to see total resource allocations (These are the tabs that I want the Developer to create)

Some requirements of the spreadsheet:

1. You must be able to add additional projects to the spreadsheet

2. You must be able to add people/resources

3. You must be able to add Tasks for each project

4. Provide instructions on how to do the above


Evner: Excel, Projekt Ledelse

Se mere: project management spreadsheet, need someone to do a excel project, how to start developer in excel, developer project management, how to do data analysis, developer in excel, topics in project management, spreadsheet 2, excel developer, excel calculation, analysis excel spreadsheet, developer excel, data entry analysis excel, excel spreadsheet check check, check spreadsheet, time resource management, excel data management, check check spreadsheet, create tab excel, data analysis excel spreadsheet, spreadsheet developer, project excel spreadsheet, spreadsheet data analysis, data analysis project excel, excel analysis project

Om arbejdsgiveren:
( 20 bedømmelser ) United States

Projekt ID: #5981456

Tildelt til:


Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$194 USD på 1 dag
(83 bedømmelser)

27 freelancere byder i gennemsnit $162 på dette job


PMP certified project manager, MBA in marketing and professional business consultant and analyst in the field of project management, marketing and branding, operations,finance, legal, health and team management/ traini Flere

$263 USD in 10 dage
(27 bedømmelser)

Hi there. I have looked at the sheet and I have a few suggestions to make. One of them is to have a single project sheet and a single analysis sheet. We can identify the project using an ID and use the same in analysis Flere

$160 USD in 3 dage
(39 bedømmelser)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

$200 USD in 6 dage
(57 bedømmelser)

Hi, I am well versed with Excel and creation of sheets like this. I have also used VBA extensively for Excel, MS Word etc.. for creation of macros. I have more than 10 years of experience to my credit. I fu Flere

$150 USD in 3 dage
(43 bedømmelser)

Hi! I think you have done half the work right. However, I suggest a few changes keeping in mind your requirements as well as to keep it simple so that you can add or modify later. Given the current structure we have t Flere

$150 USD in 7 dage
(25 bedømmelser)

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [login to view URL] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$250 USD in 3 dage
(24 bedømmelser)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel dat Flere

$242 USD in 5 dage
(4 bedømmelser)

Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. I can do following for you 1. Based on the input data with just a click all sheet will be updated 2. y Flere

$157 USD in 3 dage
(7 bedømmelser)

Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportu Flere

$250 USD in 5 dage
(12 bedømmelser)

Hey Gary, thanks for invite. I did look at your excel, and I think this can be done in few days. As it's 1am here and I'm very tired, I can't start working right away, and I would like to discuss a bit more what is e Flere

$200 USD in 3 dage
(20 bedømmelser)

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. _____I'm civil engineer (mag. ing. aedif. in Europe, or Master of Science in Civil Engineering) working Flere

$200 USD in 5 dage
(11 bedømmelser)

Hello, my name is Cristian, I have a degree in Business and I work with excel every day. I have much experience with spreadsheets and formulas. Excel expert here!. Greetings.

$133 USD in 5 dage
(12 bedømmelser)

Hello. How you think if we do it by simple way, setting formula only? We will do step-by-step as below: 1) insert a new row under that activity for each person assigned to the activity: we can develop macro to add b Flere

$77 USD in 3 dage
(8 bedømmelser)

Can amend some column? I already see your attachment, I suggest in Tab "Project 1" Column A insert Task Name, Column B insert Person Name, than use pivot table to do analysis, the result will be much more better and ea Flere

$50 USD in 3 dage
(5 bedømmelser)

I pursued civil engineering and worked as a project engineer for 2 [login to view URL] I pursued MBA in operations and Finance. So I have very good knowledge of Project Management and also very good skills in Excel/VBA. I can Flere

$79 USD in 3 dage
(2 bedømmelser)

Hi Thanks for the opportunity to bid on your project. I am an experienced Excel based model developer and I would be able to substantially automate your spreadsheet using a combination of Excel functionality and VB Flere

$133 USD in 3 dage
(1 bedømmelse)

I am a certified project manager professional. I am skilled in excel. I can start working right now. please let me know your questions.

$250 USD in 5 dage
(3 bedømmelser)

A proposal has not yet been provided

$155 USD in 3 dage
(2 bedømmelser)

I am a prodigy in using Microsoft Excel to provide effective and efficient spreadsheet for analysis.

$157 USD in 3 dage
(0 bedømmelser)

Bir öneri henüz sağlanmadı

$150 USD in 3 dage
(0 bedømmelser)