Merge two Excel to calculate the capacity of teams for purpose of planning sprints
€30-250 EUR
착불
Hello,
I've currently an ugly but working Excel that calculates the upcoming capacity available for work that must be done. The work is organized per team in sprints of two weeks. Six sprints form a release. There are four releases per year.
Today, I input the presence and absence of every teammember. In order to task each member to update his holiday (absence) himself, I would like to have the input form more user-friendly. Today, the input is a 0 or 1 in a vertical scroll sheet. I rapidly is hard to track updates.
I found a beautiful template for Holiday input. Each teammember can input per month his holiday. However, the sheet must find the right data to calculate the capacity.
I've attached a requirements document as well as the AS-IS and the Holiday sheet
프로젝트 ID: #20929889
프로젝트 소개
이 일자리에 대한 프리랜서 34 명의 평균 입찰가: €135
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl 기타
Hello I am interested in this project . I have read and understand the project details . And ,I am confident that I can do this perfectly . Lets discuss more in chat .Looking forward to hearing from you soon . Many T 기타
Hello I am an excel expert and have completed more than 100 projects in excel. I will send you a few samples of my past work for your kind perusal if required. I have read the job posting and understood the requireme 기타
Hello, I have gone through your project description and understood what has to be done in this task and can give you a complete assurance that I can do the job. I have sound experience in performing such kind of work 기타
Sir, I am well versed in these kind of jobs and can do your project as per requirement. **I am ready to start Waiting to hear from you. Regards
Hi There, I can help you to build template for Holiday input, i have see and read your description and sample file excel, i have many experience build template for company reporting, i also expert using excel formulas, 기타
Hi Good Day! A serious freelancer here. One of my task as a Project management Officer in Accenture is to prepare a Capacity Plan. Using our data in Timesheet, leave and Holiday Tracker, I generate our Monthly Foreca 기타
€ 30 ONLY!!! In just 6 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LEAST 기타
Hi. Great app writer for your projects. I have writen excel app, macro, vba for many years. I am ready to write your project. Thank you for visiting my profile
HI, I'M ABLE TO COMPLETE THIS PROJECT WITHIN 1 DAY FOR 80€. I already completed projects like this one, check my feedbacks here on Freelancer. Contact me for more information. Below my cover letter. Hi, I'm Nick, an e 기타
Hi there, I like the sounds of your project and have looked at your attached excel files. I have recently started freelancing and completing tasks just like this one. Check out my profile. I look forward to working wit 기타
Hi, My name is Alessio. I am experienced Data Analyst and Macro/Acces Developer. I have done similar jobs . I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, 기타
Hello Sir, I have corporate experience of 2 years in data analysis where most of the work was on excel. I have a good knowledge of excel and SQL. I will be very helpful to you in doing this project and the tasks relate 기타
I read your project description and the requirements file. I can do this as per your requirement. Hye! I am MBA with 10 years excel experience vba and dashboards. Send me message to show a sample for your work. Regards
Hi There, I saw your requirement and screenshot. , I am ready to work on your Data Entry Project as according to your need. I am pretty certain, I can do this for you. I am having extensive experience in Data Entry and 기타