Закрыт

Merge two Excel to calculate the capacity of teams for purpose of planning sprints

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

Квалификация: Excel, Обработка данных, Visual Basic, Ввод данных

Показать больше merge excel files, excel calculate work hours days, merge excel documents delete duplicates, use excel calculate stat, merge excel sheets, merge excel databases, merge excel files delete duplicates, merge excel files download, macro excel calculate range, excel project capacity building, merge excel data pdf form, merge excel files remove doubles, excel calculate statistics, logarithmic regression excel calculate, merge excel row sheets, vbscript merge excel files, merge excel documents contacts, excel calculate regression

О работодателе:
( 2 отзыв(-а, -ов) ) Brussels, Belgium

ID проекта: #20929889

36 фрилансеров(-а) в среднем готовы выполнить эту работу за €134

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Больше

€250 EUR за 3 дней(-я)
(723 отзывов(-а))
8.5
schoudhary1553

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 Больше

€220 EUR за 4 дней(-я)
(341 отзывов(-а))
8.0
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that will combine the functionality fo both the attached spr Больше

€220 EUR за 7 дней(-я)
(219 отзывов(-а))
7.3
zekovicm

Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed Больше

€185 EUR за 4 дней(-я)
(135 отзывов(-а))
7.3
sadekhosen77

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 Больше

€100 EUR за 2 дней(-я)
(89 отзывов(-а))
6.5
rohitpithisaria

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 Больше

€250 EUR за 7 дней(-я)
(120 отзывов(-а))
6.7
dvcontact

Hi, Would you like to see a quick demo of your project on developing your Excel form to a user-friendly form that will calculate the capacity of upcoming available work to be done based on the monthly holiday data ente Больше

€150 EUR за 3 дней(-я)
(50 отзывов(-а))
6.3
Nidhijain123

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 Больше

€140 EUR за 7 дней(-я)
(121 отзывов(-а))
6.4
sonarkaushik

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

€98 EUR за 2 дней(-я)
(103 отзывов(-а))
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]

€150 EUR за 2 дней(-я)
(118 отзывов(-а))
5.9
nvchien94

Hello there, I am an Excel expert with highly skill at VBA Excel and formulas. I did many project before with complicated migration and I can create this one for you. Honestly I did not look carefully at your attachme Больше

€200 EUR за 5 дней(-я)
(126 отзывов(-а))
5.8
umairabdillah12

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, Больше

€110 EUR за 7 дней(-я)
(8 отзывов(-а))
4.4
paulodayto08

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 Больше

€150 EUR за 3 дней(-я)
(30 отзывов(-а))
4.1
writingapp

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

€90 EUR за 3 дней(-я)
(9 отзывов(-а))
4.1
AnowarRatul

€ 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 Больше

€30 EUR за 1 день
(17 отзывов(-а))
3.4
nikopolidis

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 Больше

€50 EUR за 1 день
(2 отзывов(-а))
2.7
broncomaddie

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 Больше

€60 EUR за 3 дней(-я)
(2 отзывов(-а))
2.4
nzadeh

Greetings. I've read your project description and the files attached. I am an expert in Excel and data entry. I can ensure you that you can rely on my skills which will be helping me to develop your project. I hope to Больше

€30 EUR за 1 день
(3 отзывов(-а))
2.0
Sengar2322

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 Больше

€111 EUR за 3 дней(-я)
(1 отзыв)
1.7
alemarta92

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, Больше

€100 EUR за 3 дней(-я)
(2 отзывов(-а))
1.9