Spreadsheet: 882464d1730845582-random-sample-of-rows-and-assigning-teams-individuals-sample-peer-review
Sheet: Desired Output - case of 4

 |  |  |  |  |  |  |  |  |  |  | What my desired output looks like
Press F9 to Refresh
charts sampled | 4
This is where I am verifying my sample totals.
 |  | Attempt 2 | Attempt 2 | assigned reports
Staff | # Charts | # Sampled | # to review | prepare as many columns as needed in B5 |  |  |  |  |  | report index | Cert Dt | Participant ID | Staff | Reviewer | Check
 |  |  |  | 18 | 25 | 5 | 46
BERTHA |  |  |  | 3 | 35 | 43 | 15 |  |  | 3 | 2024-09-06 00:00:00 |  |  | BERTHA
CECILIA |  |  |  | 4 | 57 | 55 | 10 |  |  | 4 | 2024-09-07 00:00:00 |  |  | CECILIA
CRYSTAL |  |  |  | 24 | 17 | 51 | 34 |  |  | 24 | 2024-09-11 00:00:00 |  |  | CRYSTAL
DANIELA |  |  |  | 54 | 56 | 36 | 9 |  |  | 54 | 2024-09-13 00:00:00 |  |  | DANIELA
[NAME] |  |  |  | 23 | 53 | 26 | 52 |  |  | 23 | 2024-09-13 00:00:00 |  |  | [NAME]
GUADALUPE |  |  |  | 11 | 8 | 32 | 42 |  |  | 11 | 2024-09-18 00:00:00 |  |  | GUADALUPE
KARLA |  |  |  | 27 | 30 | 44 | 50 |  |  | 27 | 2024-09-18 00:00:00 |  |  | KARLA
KENDRA |  |  |  | 48 | 58 | 49 | 29 |  |  | 48 | 2024-09-18 00:00:00 |  |  | KENDRA
Melinda |  |  |  | 2 | 59 | 28 | 60 |  |  | 2 | 2024-09-20 00:00:00 |  |  | Melinda
Nicole |  |  |  | 41 | 14 | 63 | 21 |  |  | 41 | 2024-09-28 00:00:00 |  |  | Nicole
[NAME] |  |  |  | 12 | 1 | 31 | 7 |  |  | 12 | 2024-09-24 00:00:00 |  |  | [NAME]
PRISCILLA |  |  |  | 37 | 61 | 22 | 16 |  |  | 37 | 2024-09-26 00:00:00 |  |  | PRISCILLA
REBECCA |  |  |  | 39 | 20 | 47 | 6 |  |  | 39 | 2024-09-30 00:00:00 |  |  | REBECCA
Rosmy |  |  |  | 40 | 45 | 38 | 33 |  |  | 40 | 2024-09-03 00:00:00 |  |  | Rosmy
Violeta |  |  |  | 62 | 64 | 19 | 13 |  |  | 62 | 2024-09-03 00:00:00 |  |  | Violeta
(16 staff) |  |  |  |  |  |  |  |  |  | 25 | 2024-09-03 00:00:00 |  |  | ANGEL
 |  |  |  |  |  |  |  |  |  | 35 | 2024-09-04 00:00:00 |  |  | BERTHA
there are 2 people reviewed more than once, but that is ok |  |  |  |  |  |  |  |  |  | 57 | 2024-09-04 00:00:00 |  |  | CECILIA
because there were two people with only 1 chart to sample |  |  |  |  |  |  |  |  |  | 17 | 2024-09-04 00:00:00 |  |  | CRYSTAL
 |  |  |  |  |  |  |  |  |  | 56 | 2024-09-05 00:00:00 |  |  | DANIELA
standard deviation as a measure of dispersion |  |  |  |  |  |  |  |  |  | 53 | 2024-09-06 00:00:00 |  |  | [NAME]
aim - minimize |  |  |  |  |  |  |  |  |  | 8 | 2024-09-06 00:00:00 |  |  | GUADALUPE
 |  |  |  |  |  |  |  |  |  | 30 | 2024-09-09 00:00:00 |  |  | KARLA
constraint: number of self-reviews = 0 |  |  |  |  |  |  |  |  |  | 58 | 2024-09-16 00:00:00 |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  | 59 | 2024-09-25 00:00:00 |  |  | Melinda
 |  |  |  |  |  |  |  |  |  | 14 | 2024-09-25 00:00:00 |  |  | Nicole
 |  |  |  |  |  |  |  |  |  | 1 | 2024-09-26 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 61 | 2024-09-26 00:00:00 |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  | 20 | 2024-09-23 00:00:00 |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  | 45 | 2024-09-20 00:00:00 |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  | 64 | 2024-09-20 00:00:00 |  |  | Violeta
 |  |  |  |  |  |  |  |  |  | 5 | 2024-09-21 00:00:00 |  |  | ANGEL
 |  |  |  |  |  |  |  |  |  | 43 | 2024-09-22 00:00:00 |  |  | BERTHA
 |  |  |  |  |  |  |  |  |  | 55 | 2024-09-23 00:00:00 |  |  | CECILIA
 |  |  |  |  |  |  |  |  |  | 51 | 2024-09-24 00:00:00 |  |  | CRYSTAL
 |  |  |  |  |  |  |  |  |  | 36 | 2024-09-25 00:00:00 |  |  | DANIELA
 |  |  |  |  |  |  |  |  |  | 26 | 2024-09-26 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 32 | 2024-09-27 00:00:00 |  |  | GUADALUPE
 |  |  |  |  |  |  |  |  |  | 44 | 2024-09-28 00:00:00 |  |  | KARLA
 |  |  |  |  |  |  |  |  |  | 49 | 2024-09-29 00:00:00 |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  | 28 | 2024-09-30 00:00:00 |  |  | Melinda
 |  |  |  |  |  |  |  |  |  | 63 | 2024-10-01 00:00:00 |  |  | Nicole
 |  |  |  |  |  |  |  |  |  | 31 | 2024-10-02 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 22 | 2024-10-03 00:00:00 |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  | 47 | 2024-10-04 00:00:00 |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  | 38 | 2024-10-05 00:00:00 |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  | 19 | 2024-10-06 00:00:00 |  |  | Violeta
 |  |  |  |  |  |  |  |  |  | 46 | 2024-10-07 00:00:00 |  |  | ANGEL
 |  |  |  |  |  |  |  |  |  | 15 | 2024-10-08 00:00:00 |  |  | BERTHA
 |  |  |  |  |  |  |  |  |  | 10 | 2024-10-09 00:00:00 |  |  | CECILIA
 |  |  |  |  |  |  |  |  |  | 34 | 2024-10-10 00:00:00 |  |  | CRYSTAL
 |  |  |  |  |  |  |  |  |  | 9 | 2024-10-11 00:00:00 |  |  | DANIELA
 |  |  |  |  |  |  |  |  |  | 52 | 2024-10-12 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 42 | 2024-10-13 00:00:00 |  |  | GUADALUPE
 |  |  |  |  |  |  |  |  |  | 50 | 2024-10-14 00:00:00 |  |  | KARLA
 |  |  |  |  |  |  |  |  |  | 29 | 2024-10-15 00:00:00 |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  | 60 | 2024-10-16 00:00:00 |  |  | Melinda
 |  |  |  |  |  |  |  |  |  | 21 | 2024-10-17 00:00:00 |  |  | Nicole
 |  |  |  |  |  |  |  |  |  | 7 | 2024-10-18 00:00:00 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 16 | 2024-10-19 00:00:00 |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  | 6 | 2024-10-20 00:00:00 |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  | 33 | 2024-10-21 00:00:00 |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  | 13 | 2024-10-22 00:00:00 |  |  | Violeta