Excel template for managing Project team allocation
$30-250 USD
Thanh toán khi bàn giao
The excel template should have the option to list all the resources across multiple projects, edit/manage their allocations, and calculate the forcasted monthly costs (burnrate) for each project.
Each resource (team member) would have:
Employee ID
Employee Name
Role
Project allocated (could be more than 1)
Allocation % (for each allocated project)
Allocation Start Date (for each allocated project)
Allocation End Date [Conservative estimate] (for each allocated project)
Allocation End Date [Conservative estimate] Confirmed? (Y/N)
Allocation End Date [Realistic estimate] (for each allocated project)
Daily Rate (Salary for each working day)
There should a calendar view for the list of resources to visually view/edit the allocation at a week level detail.
Color differentiated for each project.
Depending on the allocation across each month (Depending on the 'Allocation End date [Realistic estimate]), there should be a monthly burnrate calculation for each project.
Resources whose 'Allocation End Date [Conservative estimate]' is less than a month and the allocation end date is not confirmed should be highlighted, so either their end date is extended or the end date is confirmed.
It would be better to discuss the project requirements on a call to understand better.
ID dự án: #37247921
Về dự án
Được trao cho:
40 freelancer chào giá trung bình$145 cho công việc này
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Thêm
I understand you are looking for a developer to create an Excel template that can manage team allocations across multiple projects, edit/manage their allocations, and calculate the forecasted monthly costs (burnrate) f Thêm
Hi, I have gone through the Job details and am interested in taking it up. I might need to contact you for more details, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on Thêm
Hi there! My name is Abu and I am a Virtual Admin Manager offering dedicated services to you and your esteemed company. With the option for full-time engagement, I present a proficient Virtual Assistant available on an Thêm
Hello there, My name is Ehtisham and I am an Electrical Engineer and Data Scientist with extensive experience in Excel, Python, Wordpress, Electrical Engineering and MATLAB. I understand you are looking for an Excel te Thêm
Greetings, I'm ready to start the job. I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. Are you looking Thêm
Hey sir, it seems that you want to create an Excel template for allocation. Calculations will be done depending on the start and end of each project for each team member. You also want to differentiate projects by colo Thêm
Yes! You are on Right Bid. I have Read All Project details and descriptions regarding Excel template for managing Project team allocation I will save your time by letting my work speak for you. If I am lucky enough t Thêm
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
I am a highly skilled data entry specialist with more than six years of experience. My expertise lies in accurately inputting data into spreadsheets, databases, and other digital platforms. I have a keen eye for detail Thêm
Hello! My name is Kamal and I am an experienced freelancer with excellent knowledge in typing, VBA programming, data analyst and Excel works. I have 5.5 years of experience in these areas. I understand that you are lo Thêm
Hello there! My name is Pradeep and I'm a highly skilled Excel freelancer with over 15 years of experience in using Microsoft Excel to solve complex business problems. I have worked on a lot of complex projects and hav Thêm
In the name of Allah Hello, Insha Allah I can do it with a professional managing Project team allocation in less than 60 min, Thanks to Allah
Hello! My name is Garima and I love to hear about your project for data entry/image to pdf. As an experienced in this skills in copy typing, data entry, Excel and PDF, i have work on this role and i am so happy to work Thêm
I understand that you are looking for an Excel template to manage Project team allocation and calculate a forecasted monthly cost (burnrate). I am confident that my skillset, experience and expertise make me the best f Thêm
Hi Sir, I have gone through your requirement. I have excellent skill of Data entry and I will do it correctly. I have completed many projects of data entry. Immediately available to start work and will complete the wor Thêm
