Spreadsheet: 882168d1730409548-random-sample-of-rows-and-assigning-teams-individuals-sample-peer-review
Sheet: Sampler

 |  |  |  |  |  |  | Attempt #1 |  |  |  |  |  |  | Attempt #2
 |  |  |  |  |  |  | This section filters the source data first for sample size. Then randomly assigns a person to do the review. |  |  |  |  |  |  | This section produces a list of reviewers first.  Then filters the data to randomly assign charts to each person.
 |  |  |  |  |  |  |  | Filter - (in H10) I tried to use ranking to randomly select the sample size in B5.  This does not work if the person has fewer than that. |  |  |  |  |  |  | [NAME]in Q10) a random list of staff is produced based on the sample size in B5
Press F9 to Refresh |  |  |  |  |  |  |  |  | Con- Data filter does not include more rows in the event that people have less than sample size. |  |  |  |  |  |  | Pro- this appears to work, and has the correct number of charts to be reviewed for each person.
charts sampled | 2 |  |  |  |  |  |  | Assigning Reviewer- In K10 I tried to use a method to assign a reviewer with [NAME] and Rank. |  |  |  |  |  |  | Filter - (in H10) I tried to use ranking to randomly select the sample size in B5.  This does not work if the person has fewer than that.
 |  |  |  |  |  |  |  |  | Con- The reviewers assigned does not seem to be even distribution, sometimes even assigns 0 charts to a person. |  |  |  |  |  |  | Con- Data filter does not include more rows in the event that people have less than sample size.
This is where I am verifying my sample totals. |  |  |  |  |  |  |  |  | Pro - It does work partially, in that it assigns a reviewer other than the staff in column J (not duplicate) |  |  |  |  |  |  | Cons- Does not assign chart correctly, staff may get their own chart.
 |  | Attempt 1 | Attempt 1 | Attempt 2 | Attempt 2
Staff | # Charts | # Sampled | # to review | # Sampled | # to review |  | Rand | Cert Dt | Participant ID | Staff | Reviewer | Check |  | Cert Dt | Participant ID | Staff | Reviewer | Check
BERTHA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ANGEL
CECILIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BERTHA
CRYSTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BERTHA
DANIELA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CECILIA
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CECILIA
GUADALUPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRYSTAL
KARLA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CRYSTAL
KENDRA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DANIELA
Melinda |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DANIELA
Nicole |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
PRISCILLA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GUADALUPE
REBECCA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GUADALUPE
Rosmy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KARLA
Violeta |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KARLA
(16 staff) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KENDRA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melinda
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melinda
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicole
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nicole
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRISCILLA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REBECCA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rosmy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Violeta
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Violeta