After much searching on this forum, I have decided to post and hope someone is able to help. I have players' shifts tagged, with a start time and an end time.
<colgroup><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
And then I have events during the game with time stamped data.
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Ideally, next to the time stamped event, I want it to return the 6 players that were in the game when that event happened. In the actual file there will be many more players with their shifts tagged than the five I used for an example there.
Hope someone can help, thanks!
| Start | Duration | End | ||||||||
| GRETZKY | 1 | 0 | 20 | 0 | 10 | EV | H | 20:00 | 00:10 | 19:50 |
| SAKIC | 1 | 0 | 20 | 0 | 10 | EV | H | 20:00 | 00:10 | 19:50 |
| YZERMAN | 1 | 0 | 20 | 0 | 10 | EV | H | 20:00 | 00:10 | 19:50 |
| LEMIEUX | 1 | 0 | 20 | 0 | 14 | EV | H | 20:00 | 00:14 | 19:46 |
| MESSIER | 1 | 0 | 20 | 0 | 14 | EV | H | 20:00 | 00:14 | 19:46 |
| ROY | 1 | 0 | 20 | 0 | 305 | EV | H | 20:00 | 05:05 | 14:55 |
<colgroup><col><col><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
And then I have events during the game with time stamped data.
| 1 | 19:51 | SH | For | 19:51 | 19 | 51 |
| 1 | 19:33 | SH | Penalty | 19:33 | 19 | 33 |
| 1 | 19:26 | SH | For | 19:26 | 19 | 26 |
| 1 | 19:04 | SH | Penalty | 19:04 | 19 | 4 |
| 1 | 18:53 | SH | Against | 18:53 | 18 | 53 |
| 1 | 18:46 | SH | Penalty | 18:46 | 18 | 46 |
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
Ideally, next to the time stamped event, I want it to return the 6 players that were in the game when that event happened. In the actual file there will be many more players with their shifts tagged than the five I used for an example there.
Hope someone can help, thanks!
