For some reason, the logic behind the spreadsheet schedule I am making is very confusing to translate to the spreadsheet. I am going to be servicing computers for about a hundred users, while their computers are being serviced, they will be borrowing one of two loaner computers. The normal stretch for servicing the computers is three days, but it could be shorter or longer. The two loaner computers get loaned out based on what loaner computer is available when that user brings in their computer.
I am making a schedule that it like the following:
Col A: User Name
Col B: Date user is to bring in their computer
Col C: Date user is intended to pick up their computer
Col D: What loaner computer in to be given to that user to use in the meantime (Loaner 1 or Loaner 2)
Say the list look like this
Row 1: Johnny Apple, 05/01/2019, 05/03/2019, Loaner 1
Row 2: Kevin Bicycle, 05/01/2019, 05/03/2019, Loaner 2
Row 3: Larry Cat, 05/04/2019, 05/07/2019, Loaner 1
Row 4: Marvin Dot, 05/04/2019, 05/07/2019, Loaner 2
Row 5: Nancy Egg, 05/08/2019, 05/11/2019, Loaner 1
Row 6: Ollie Fawn, 05/08/2019, 05/11/2019, Loaner 2
Row 7: Pat Green, 05/12/2019, 05/15/2019, Loaner 1
Row 8: Randy Holly, 05/12/2019, 05/15/2019, Loaner 2
Now, without any needed alterations to the schedule, the schedule seems obvious and predictable. However, I have to allow for a situation like, say, Larry Cat's computer actually ends up taking 7 days to service, so the full three days are extended by four. That means that the following alternation to the schedule would automatically recalculate to:
Row 1: Johnny Apple, 05/01/2019, 05/03/2019, Loaner 1
Row 2: Kevin Bicycle, 05/01/2019, 05/03/2019, Loaner 2
Row 3: Larry Cat, 05/04/2019, 05/11/2019, Loaner 1
Row 4: Marvin Dot, 05/04/2019, 05/07/2019, Loaner 2
Row 5: Nancy Egg, 05/08/2019, 05/11/2019, Loaner 2
Row 6: Ollie Fawn, 05/12/2019, 05/15/2019, Loaner 1
Row 7: Pat Green, 05/12/2019, 05/15/2019, Loaner 2
Row 8: Randy Holly, 05/16/2019, 05/19/2019, Loaner 1
Can someone help this novice work out this logic is Excel? I cannot seem to work out how I would get a spreadsheet to work out this logic?
Timothy
Bookmarks