StephenM123
New Member
- Joined
- Apr 19, 2019
- Messages
- 8
Afternoon all,
I'm looking for a bit of help on the following.
I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether.
I would like to create some sort of custom calendar, using only formula from a list of data, extract provided below.
The list currently extends some 1000 rows and will continue to expand.
<colgroup><col style="mso-width-source:userset;mso-width-alt:6400;width:131pt" width="175"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 175"]Employee Name[/TD]
[TD="width: 124"]Department Name[/TD]
[TD="width: 96"]Status[/TD]
[TD="class: xl67, width: 75"]Date[/TD]
[TD="width: 43"]Hours[/TD]
[TD="width: 119"]Process[/TD]
[TD="width: 64"]Day/Night[/TD]
[TD="width: 64"]Business[/TD]
[TD="width: 75"]Week[/TD]
[TD="width: 64"]Year[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]17/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
</tbody>
What I would ideally like to be able to do is pull a list of which employee is off on each day in to something similar to the format below.
I'm really struggling with how I pick up the next 'employee name' value in the lists.
[TABLE="width: 405"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]10/03/2019[/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD][/TD]
[TD]12/03/2019[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD][/TD]
[TD]Employee 2[/TD]
[TD][/TD]
[TD]Employee 3[/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD][/TD]
[TD]Employee 5[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[/TR]
[TR]
[TD]Employee 6[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Ideally after this I would like to split it out by if they work day shift or night shift as well but I should hopefully be able to do that once I get started.
Any helps on what I'm looking for would be greatly appreciated.
Thank you!
I'm looking for a bit of help on the following.
I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether.
I would like to create some sort of custom calendar, using only formula from a list of data, extract provided below.
The list currently extends some 1000 rows and will continue to expand.
Employee 1 | Out | Active | Production | Days | Pogs |
Employee 2 | Out | Active | Production | Nights | Tazo |
Employee 3 | Out | Active | Production | Days | Pogs |
Employee 3 | Out | Active | Production | Days | Pogs |
Employee 4 | Out | Active | Production | Days | Pogs |
Employee 5 | Out | Active | Production | Nights | Pogs |
Employee 6 | Out | Active | Production | Days | Pogs |
Employee 7 | Out | Active | Production | Days | Tazo |
Employee 7 | Out | Active | Production | Days | Tazo |
Employee 7 | Out | Active | Production | Days | Tazo |
Employee 8 | Out | Active | Production | Days | Tazo |
Employee 9 | Out | Active | Production | Nights | Tazo |
Employee 10 | Out | Active | Production | Nights | Tazo |
<colgroup><col style="mso-width-source:userset;mso-width-alt:6400;width:131pt" width="175"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col style="mso-width-source:userset;mso-width-alt:3510;width:72pt" width="96"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:1572;width:32pt" width="43"> <col style="mso-width-source:userset;mso-width-alt:4352;width:89pt" width="119"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 175"]Employee Name[/TD]
[TD="width: 124"]Department Name[/TD]
[TD="width: 96"]Status[/TD]
[TD="class: xl67, width: 75"]Date[/TD]
[TD="width: 43"]Hours[/TD]
[TD="width: 119"]Process[/TD]
[TD="width: 64"]Day/Night[/TD]
[TD="width: 64"]Business[/TD]
[TD="width: 75"]Week[/TD]
[TD="width: 64"]Year[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]11/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]12/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]13/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]17/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
[TD="class: xl67, align: right"]10/03/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]2019[/TD]
</tbody>
What I would ideally like to be able to do is pull a list of which employee is off on each day in to something similar to the format below.
I'm really struggling with how I pick up the next 'employee name' value in the lists.
[TABLE="width: 405"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]10/03/2019[/TD]
[TD][/TD]
[TD]11/03/2019[/TD]
[TD][/TD]
[TD]12/03/2019[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD][/TD]
[TD]Employee 2[/TD]
[TD][/TD]
[TD]Employee 3[/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD][/TD]
[TD]Employee 5[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[/TR]
[TR]
[TD]Employee 6[/TD]
[TD][/TD]
[TD]Employee 7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee10
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Ideally after this I would like to split it out by if they work day shift or night shift as well but I should hopefully be able to do that once I get started.
Any helps on what I'm looking for would be greatly appreciated.
Thank you!