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
36 freelancers are bidding on average €134 for this job
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]
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