Hi I have multiple app iD's in 1st column, in 2nd column I have Java and Windows applications. In 3rd column I need to update the Java teams as J1 - J8 , and windows team as W1, W2. In 4th column I have number of sprints , where 1 sprint = 2 weeks ( i.e. 10 workdays). In 5th column I have Start date and in 6th column I need to calculate the end dates , where end dates = sprints * Start date . The start date for 1st occurence of the Teams J1 - J8 I know.
The problem is that if 1st Java application starts on 04/03/2017 , then I need to assign it as J1 through code and also calculate end date and update in the respective colums. Similar for J2- J8. But if J1 completes before start date of J2, suppose it finishes on 04/27/2017, then before J2 starts on 5/1/2017 , we need to assign another app to J1 from 04/28/2017. Similarly it goes for other teams. Everything I need to do through code.
Please help me as I need to submit it by tomorrow.
The 1st Start dates are given as follows in mm/dd/yyyy format:-
Start Date J1 = 4/3/2017
Start Date J2 = 5/1/2017
Start Date J3 = 5/1/2017
Start Date J4 = 6/5/2017
Start Date J5 = 6/5/2017
Start Date J6 = 6/5/2017
Start Date J7 = 9/4/2017
Start Date J8 = 9/4/2017
Start Date W1 = 4/3/2017
Start Date W2 = 5/1/2017
Bookmarks