Variable calculated rows based on input fields

[rxberry1530]

Hi Guys,

My first post to this forum. I am helping our CYO program input data to populate gym availability for our basketball teams. Up until now, they have been doing it manually and it takes a full time person several days to put the data into a format that can then be uploaded to the system. For each gym (there are 10) there are 7 days a week and each day has a start time and end time. The day and time needs to be in the 09/09/2016 17:00 format. I would like to create one worksheet with variable fields where I can put the start date, end date, each day of the week practice start and end time. Given those inputs, I should be able to create the needed input into the system.

I have been able to create a 450 row spreadsheet for one gym, but the number of practices per day is consistent so my reference is easy. When I move to another gym that may have 3 practice session instead of 5, my model will not work. Is there a way to create variable results based on data driven input fields?

Here is what my input looks like:

Gym Name Burton Valley
Start date 9/1/2016 Thursday
End Date 11/16/2016
Practice Time 1:00

Start Time End Time Sessions
Monday 17:00 21:00 4:00
Tuesday 17:00 21:00 4:00
Wednesday 17:00 21:00 4:00
Thursday 17:00 21:00 4:00
Friday 17:00 21:00 4:00
Saturday 8:00 20:00 12:00
Sunday 12:00 20:00 8:00

Here is what final data needs to be:

Burton Valley Start Date End Date Day
Burton Valley 9/1/2016 17:00 9/1/2016 18:00 Thu
Burton Valley 9/1/2016 18:00 9/1/2016 19:00 Thu
Burton Valley 9/1/2016 19:00 9/1/2016 20:00 Thu
Burton Valley 9/1/2016 20:00 9/1/2016 21:00 Thu
Burton Valley 9/2/2016 17:00 9/2/2016 18:00 Fri
Burton Valley 9/2/2016 18:00 9/2/2016 19:00 Fri
Burton Valley 9/2/2016 19:00 9/2/2016 20:00 Fri

Thanks for any help you can give.

Rick

[dflak]

It would help a lot if you could include a sample spreadsheet with sample data. Also a: this is what I have and this is what I want mockup would help.