jofiferreira
New Member
- Joined
- Feb 15, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
- MacOS
Hello everyone,
I'm new here on this forum, I have been through some others forums but lately they have lost the shine I think. I'm a person that likes to learn new methods to achieve my needs.
Currently I working on a dashboard and I'm "stuck" on a problem and I would like to have your input on how to make it simple.
So I have a database that is broken in 4 milestones, for each milestone I have the following columns:
- Work complete (yes or no)
- Day (year, month, day), this records the day the above was changed from no to yes.
- Year (referent to where day falls)
- Week (referent to where day falls)
- Company, where there user belongs
Like I said, each milestone has the same structure with same information (referent to that milestone).
Brief explanation how this works. I may have company A closing milestone 1, company B closing milestone 2..... So idea is to have 1 or more pivot tables per milestone to understand production.
My problem/s are:
- Problem 1: Can I have one single filter that filters the 4 milestones according with however closed them, having in mind that a column per milestone will have that data for each milestone.
- Problem 2: Same as above but for this it will be for the year. When I try to use a timeline it is only referent to one milestone, even if I connect it with the other pivot table it wont be accurate because only filter based on the milestone where the timeline was selected.
I have looked around on the forum, web in general but couldn't find anything. Either I'm not using the correct terms, or there is not info out there.
Milestone 1 - CABLE
Milestone 2 - SPLICE
Milestone 3 - TEST
Idea is to have a dashboard with the numbers for all 4 milestones and being able to filter by company. At this moment and as example I have only cable and splice and to filter the company I need to have one slicer or filter per milestone. Idea would be to have one slicer that when filtering it would apply to all 4 milestones. Same idea for the year.
Any help would be very appreciated.
I'm trying to attach a sample file but doesn't open the Option, see below.
I'm new here on this forum, I have been through some others forums but lately they have lost the shine I think. I'm a person that likes to learn new methods to achieve my needs.
Currently I working on a dashboard and I'm "stuck" on a problem and I would like to have your input on how to make it simple.
So I have a database that is broken in 4 milestones, for each milestone I have the following columns:
- Work complete (yes or no)
- Day (year, month, day), this records the day the above was changed from no to yes.
- Year (referent to where day falls)
- Week (referent to where day falls)
- Company, where there user belongs
Like I said, each milestone has the same structure with same information (referent to that milestone).
Brief explanation how this works. I may have company A closing milestone 1, company B closing milestone 2..... So idea is to have 1 or more pivot tables per milestone to understand production.
My problem/s are:
- Problem 1: Can I have one single filter that filters the 4 milestones according with however closed them, having in mind that a column per milestone will have that data for each milestone.
- Problem 2: Same as above but for this it will be for the year. When I try to use a timeline it is only referent to one milestone, even if I connect it with the other pivot table it wont be accurate because only filter based on the milestone where the timeline was selected.
I have looked around on the forum, web in general but couldn't find anything. Either I'm not using the correct terms, or there is not info out there.
Milestone 1 - CABLE
Milestone 2 - SPLICE
Milestone 3 - TEST
Idea is to have a dashboard with the numbers for all 4 milestones and being able to filter by company. At this moment and as example I have only cable and splice and to filter the company I need to have one slicer or filter per milestone. Idea would be to have one slicer that when filtering it would apply to all 4 milestones. Same idea for the year.
Any help would be very appreciated.
I'm trying to attach a sample file but doesn't open the Option, see below.
| Sample.xlsx | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
| 1 | CELL_NE | SUPPLIED_UC | EXECUTED_FOOTAGE | CABLED | DATE_CABLED | DATE_W_CABLED - Copy | DATE_W_CABLED | SP_CABLED | SPLICED | DATE_SPLICED | DATE_W_SPLICED - Copy | DATE_W_SPLICED | SP_SPLICED | TESTED | DATE_TESTED | DATE_W_TESTED - Copy | DATE_W_TESTED | SP_TESTED | ||
| 2 | NYX6AK112_P11 | 9 | 0 | yes | 12/31/2021 | 2021 | 52 | COMPANY A | yes | 1/6/2022 | 2021 | 52 | COMPANY G | yes | 1/6/2022 | 2021 | 52 | COMPANY H | ||
| 3 | NYX6AK121_P09 | 1 | 0 | yes | 12/31/2021 | 2021 | 52 | COMPANY C | yes | 1/6/2022 | 2021 | 52 | COMPANY A | yes | 1/6/2022 | 2021 | 52 | COMPANY H | ||
| 4 | NYX6AK122_P14 | 4 | 0 | yes | 12/31/2021 | 2021 | 52 | COMPANY G | yes | 1/6/2022 | 2021 | 52 | COMPANY A | yes | 1/6/2022 | 2021 | 52 | COMPANY H | ||
| 5 | NYX8CC005_P01 | 11 | 196 | yes | 1/28/2022 | 2022 | 4 | COMPANY A | yes | 2/11/2022 | 2022 | 6 | COMPANY A | no | ||||||
| 6 | NYX8CC005_P02 | 6 | 250 | yes | 1/25/2022 | 2022 | 4 | COMPANY A | no | no | ||||||||||
| 7 | NYX8CC005_P03 | 18 | 166 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | yes | 12/30/2021 | 2021 | 52 | COMPANY A | no | ||||||
| 8 | NYX8CC005_P04 | 6 | 166 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | yes | 12/30/2021 | 2021 | 52 | COMPANY A | no | ||||||
| 9 | NYX8CC005_P05 | 8 | 250 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | yes | 12/30/2021 | 2021 | 52 | COMPANY A | no | ||||||
| 10 | NYX8CC005_P07 | 14 | 196 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | yes | 12/30/2021 | 2021 | 52 | COMPANY A | no | ||||||
| 11 | NYX8CC005_P08 | 12 | 196 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | yes | 12/30/2021 | 2021 | 52 | COMPANY A | no | ||||||
| 12 | NYX8CC005_P09 | 6 | 196 | yes | 12/28/2021 | 2021 | 51 | COMPANY A | no | no | ||||||||||
| 13 | NYX8CC033_P05 | 9 | 165 | yes | 1/26/2022 | 2022 | 4 | COMPANY F | yes | 2/7/2022 | 2022 | 6 | COMPANY A | yes | 2/8/2022 | 2022 | 6 | COMPANY E | ||
| 14 | NYX8CC033_P06 | 10 | 165 | yes | 1/26/2022 | 2022 | 4 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY A | no | ||||||
| 15 | NYX8CC033_P07 | 12 | 165 | yes | 1/26/2022 | 2022 | 4 | COMPANY F | yes | 2/9/2022 | 2022 | 6 | COMPANY A | no | ||||||
| 16 | NYX8CC033_P08 | 13 | 165 | yes | 12/31/2021 | 2021 | 52 | COMPANY C | no | no | ||||||||||
| 17 | NYX8CC033_P11 | 10 | 165 | yes | 12/31/2021 | 2021 | 52 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 18 | NYX8CC033_P12 | 7 | 165 | yes | 12/31/2021 | 2021 | 52 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 19 | NYX8CC033_P14 | 14 | 295 | yes | 1/27/2022 | 2022 | 4 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 20 | NYX8CC060_P01 | 12 | 195 | yes | 1/25/2022 | 2022 | 4 | COMPANY F | yes | 2/4/2022 | 2022 | 5 | COMPANY B | no | ||||||
| 21 | NYX8CC060_P02 | 12 | 195 | yes | 1/25/2022 | 2022 | 4 | COMPANY G | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 22 | NYX8CC060_P07 | 7 | 468 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY B | no | ||||||
| 23 | NYX8CC060_P08 | 8 | 468 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY B | no | ||||||
| 24 | NYX8CC060_P09 | 12 | 468 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY B | no | ||||||
| 25 | NYX8CC060_P10 | 12 | 468 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY B | no | ||||||
| 26 | NYX8CC038_P26 | 0 | 680 | yes | 2/10/2022 | 2022 | 6 | COMPANY G | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 27 | NYX8CC038_P28 | 1 | 680 | yes | 2/10/2022 | 2022 | 6 | COMPANY G | yes | 2/11/2022 | 2022 | 6 | COMPANY B | no | ||||||
| 28 | NYX8CC039_P01 | 3 | 637 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 29 | NYX8CC039_P02 | 2 | 0 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 30 | NYX8CC039_P09 | 3 | 0 | yes | 1/24/2022 | 2022 | 4 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 31 | NYX8CC039_P10 | 3 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 32 | NYX8CC039_P11 | 2 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 33 | NYX8CC039_P12 | 2 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 34 | NYX8CC039_P13 | 2 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 35 | NYX8CC039_P14 | 3 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 36 | NYX8CC039_P15 | 8 | 0 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/1/2022 | 2022 | 5 | COMPANY B | ||
| 37 | NYX8CC039_P16 | 2 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 38 | NYX8CC039_P17 | 0 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY B | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 39 | NYX8CC039_P18 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 40 | NYX8CC039_P19 | 3 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 41 | NYX8CC039_P20 | 1 | 206 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 42 | NYX8CC039_P21 | 1 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 43 | NYX8CC039_P22 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 44 | NYX8CC039_P26 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 45 | NYX8CC039_P27 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 46 | NYX8CC039_P28 | 1 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 47 | NYX8CC039_P29 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 48 | NYX8CC039_P30 | 4 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 49 | NYX8CC039_P31 | 2 | 198 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/2/2022 | 2022 | 5 | COMPANY B | ||
| 50 | NYX8CC039_P32 | 1 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 51 | NYX8CC039_P33 | 1 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 52 | NYX8CC039_P34 | 2 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 53 | NYX8CC039_P35 | 1 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY B | ||
| 54 | NYX8CC039_P36 | 3 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 55 | NYX8CC039_P37 | 4 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 56 | NYX8CC039_P38 | 4 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 57 | NYX8CC039_P39 | 1 | 267 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 58 | NYX8CC039_P40 | 4 | 246 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 59 | NYX8CC039_P41 | 3 | 246 | yes | 12/28/2021 | 2021 | 51 | COMPANY G | yes | 12/30/2021 | 2021 | 52 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 60 | NYX8CC039_P42 | 2 | 198 | yes | 2/1/2022 | 2022 | 5 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 61 | NYX8CC039_P43 | 1 | 198 | yes | 2/1/2022 | 2022 | 5 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 62 | NYX8CC039_P44 | 4 | 198 | yes | 2/1/2022 | 2022 | 5 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 63 | NYX8CC039_P45 | 2 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 64 | NYX8CC039_P46 | 2 | 198 | yes | 2/1/2022 | 2022 | 5 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 65 | NYX8CC039_P47 | 3 | 198 | yes | 2/1/2022 | 2022 | 5 | COMPANY G | yes | 2/2/2022 | 2022 | 5 | COMPANY C | yes | 2/2/2022 | 2022 | 5 | COMPANY F | ||
| 66 | NYX8CC039_P48 | 2 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 67 | NYX8CC039_P49 | 1 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 68 | NYX8CC039_P50 | 3 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 69 | NYX8CC039_P51 | 2 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 70 | NYX8CC039_P52 | 1 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 2/4/2022 | 2022 | 5 | COMPANY C | yes | 2/4/2022 | 2022 | 5 | COMPANY F | ||
| 71 | NYX8CC039_P53 | 2 | 196 | yes | 1/20/2022 | 2022 | 3 | COMPANY G | yes | 1/31/2022 | 2022 | 5 | COMPANY C | yes | 2/2/2022 | 2022 | 5 | COMPANY F | ||
| 72 | NYX8CX010_P01 | 8 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 73 | NYX8CX010_P02 | 3 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 74 | NYX8CX010_P03 | 4 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 75 | NYX8CX010_P15 | 3 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 76 | NYX8CX010_P16 | 3 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 77 | NYX8CX010_P18 | 5 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 78 | NYX8CX010_P20 | 0 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 79 | NYX8CX010_P35 | 0 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 80 | NYX8CX010_P40 | 0 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 81 | NYX8CX010_P41 | 4 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 82 | NYX8CX010_P44 | 4 | 731 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY C | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 83 | NYX8CX012_P15 | 5 | 780 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 84 | NYX8CX012_P16 | 7 | 685 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY F | ||
| 85 | NYX8CX012_P17 | 10 | 685 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 86 | NYX8CX012_P18 | 6 | 685 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 87 | NYX8CX012_P19 | 6 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 88 | NYX8CX012_P20 | 7 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 89 | NYX8CX012_P21 | 6 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 90 | NYX8CX012_P24 | 1 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 91 | NYX8CX012_P25 | 9 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 92 | NYX8CX012_P26 | 4 | 703 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/21/2022 | 2022 | 3 | COMPANY E | yes | 1/21/2022 | 2022 | 3 | COMPANY B | ||
| 93 | NYX8CX009_P22 | 2 | 588 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 94 | NYX8CX009_P23 | 1 | 480 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 95 | NYX8CX009_P24 | 3 | 588 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 96 | NYX8CX009_P54 | 2 | 588 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 97 | NYX8CX009_P76 | 3 | 480 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 98 | NYX8CX009_P77 | 6 | 542 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 99 | NYX8CX020_P04 | 1 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 100 | NYX8CX020_P08 | 2 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 101 | NYX8CX020_P09 | 3 | 675 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 102 | NYX8CX020_P10 | 7 | 675 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 103 | NYX8CX020_P11 | 1 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 104 | NYX8CX020_P12 | 11 | 675 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 105 | NYX8CX020_P13 | 7 | 675 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY E | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 106 | NYX8CX020_P21 | 0 | 495 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 107 | NYX8CX020_P22 | 6 | 495 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 108 | NYX8CX020_P23 | 2 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 109 | NYX8CX020_P24 | 0 | 1012 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 110 | NYX8CX020_P25 | 2 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 111 | NYX8CX020_P26 | 7 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 112 | NYX8CX020_P27 | 4 | 1012 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 113 | NYX8CX020_P28 | 5 | 1012 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 114 | NYX8CX020_P33 | 5 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 115 | NYX8CX020_P34 | 7 | 749 | yes | 1/10/2022 | 2022 | 2 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 116 | NYX8CX020_P35 | 5 | 858 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 117 | NYX8CX014_P01 | 5 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 118 | NYX8CX014_P03 | 5 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 119 | NYX8CX014_P04 | 4 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 120 | NYX8CX014_P06 | 7 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 121 | NYX8CX014_P08 | 3 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 122 | NYX8CX014_P09 | 3 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 123 | NYX8CX014_P10 | 2 | 709 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 124 | NYX8CX014_P11 | 0 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 125 | NYX8CX014_P13 | 0 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 126 | NYX8CX014_P15 | 6 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 127 | NYX8CX014_P17 | 0 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 128 | NYX8CX014_P18 | 12 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 129 | NYX8CX014_P19 | 8 | 709 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 130 | NYX8CX014_P20 | 4 | 709 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 131 | NYX8CX014_P21 | 1 | 709 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 132 | NYX8CX014_P23 | 0 | 709 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 133 | NYX8CX014_P24 | 3 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 134 | NYX8CX014_P27 | 12 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 135 | NYX8CX014_P28 | 1 | 825 | yes | 1/21/2022 | 2022 | 3 | COMPANY G | yes | 1/24/2022 | 2022 | 4 | COMPANY D | yes | 1/24/2022 | 2022 | 4 | COMPANY B | ||
| 136 | NYX8CJ002_P02 | 0 | 380 | yes | 2/9/2022 | 2022 | 6 | COMPANY B | no | no | ||||||||||
| 137 | NYX8CJ039_P02 | 8 | 289 | yes | 2/8/2022 | 2022 | 6 | COMPANY B | no | no | ||||||||||
| 138 | NYX8CL016_P03 | 12 | 661 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/5/2022 | 2022 | 5 | COMPANY E | no | ||||||
| 139 | NYX8CL016_P04 | 12 | 661 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/5/2022 | 2022 | 5 | COMPANY E | no | ||||||
| 140 | NYX8CL016_P07 | 1 | 472 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/9/2022 | 2022 | 6 | COMPANY E | yes | 2/9/2022 | 2022 | 6 | COMPANY A | ||
| 141 | NYX8CL016_P10 | 11 | 472 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY E | no | ||||||
| 142 | NYX8CL016_P11 | 11 | 472 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY E | no | ||||||
| 143 | NYX8CL022_P01 | 1 | 300 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/7/2022 | 2022 | 6 | COMPANY E | yes | 2/10/2022 | 2022 | 6 | COMPANY A | ||
| 144 | NYX8CL022_P15 | 3 | 522 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY E | no | ||||||
| 145 | NYX8CL022_P16 | 2 | 522 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY E | no | ||||||
| 146 | NYX8CL022_P17 | 3 | 522 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/10/2022 | 2022 | 6 | COMPANY E | yes | 2/10/2022 | 2022 | 6 | COMPANY A | ||
| 147 | NYX8CL022_P19 | 7 | 567 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/5/2022 | 2022 | 5 | COMPANY E | no | ||||||
| 148 | NYX8CL022_P20 | 8 | 567 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/11/2022 | 2022 | 6 | COMPANY E | no | ||||||
| 149 | NYX8CL022_P21 | 11 | 567 | yes | 2/2/2022 | 2022 | 5 | COMPANY F | yes | 2/5/2022 | 2022 | 5 | COMPANY E | yes | 2/10/2022 | 2022 | 6 | COMPANY A | ||
| 150 | NYX8CL032_P10 | 1 | 634 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/6/2022 | 2022 | 6 | COMPANY E | yes | 2/11/2022 | 2022 | 6 | COMPANY A | ||
| 151 | NYX8CL032_P15 | 1 | 634 | yes | 2/5/2022 | 2022 | 5 | COMPANY F | yes | 2/10/2022 | 2022 | 6 | COMPANY E | yes | 2/10/2022 | 2022 | 6 | COMPANY A | ||
Sample | ||||||||||||||||||||
