Spreadsheet: 51783d1251386039-percentage-of-one-column-based-on-set-data-of-another-column-example-worksheet
Sheet: Sheet1

Count | Last Name | First Name | Equal Opportunity | OPSEC | SAEDA | Ethics | Accident Avoidance | WNSF: S | CRM | At lvl 1 | CBT
Yes | Person 1 |  | 2009-08-09 00:00:00 |  |  |  |  |  |  | 2009-08-09 00:00:00 | 2009-07-09 00:00:00
Yes | Person 2 |  |  |  |  |  |  |  |  |  | 2009-07-09 00:00:00
Yes | Person 3 |  | 2009-08-09 00:00:00 | 2009-03-01 00:00:00 | 2009-04-02 00:00:00 | 2009-02-09 00:00:00 |  | 2009-04-16 00:00:00 | 2009-03-01 00:00:00 | 2009-06-09 00:00:00 | 2009-02-09 00:00:00
Yes | Person 4 |  | 2009-07-09 00:00:00 |  | 2009-06-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 |  | 2008-07-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00
Yes | Person 5 |  | 2009-08-09 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-03-01 00:00:00 |  | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2009-06-09 00:00:00 | 2009-01-09 00:00:00
No | Person 6 |  | 2009-08-09 00:00:00 |  |  |  |  |  |  |  | 2009-07-09 00:00:00
Yes | Person 7 |  | 2009-07-09 00:00:00 | 2009-03-01 00:00:00 | 2009-04-03 00:00:00 | 2009-02-09 00:00:00 |  | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2008-05-08 00:00:00 | 2009-02-09 00:00:00
Yes | Person 8 |  |  | 2009-03-01 00:00:00 | 2009-04-09 00:00:00 | 2009-02-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-03-01 00:00:00 | 2009-04-09 00:00:00 | 2009-01-09 00:00:00
Yes | Person 9 |  | 2009-07-09 00:00:00 | 2008-10-07 00:00:00 | 2009-04-01 00:00:00 | 2008-10-08 00:00:00 | 2008-11-08 00:00:00 | 2009-04-09 00:00:00 | 2008-10-08 00:00:00 | 2009-05-09 00:00:00 | 2009-01-09 00:00:00
Yes | Person 10 |  | 2009-07-09 00:00:00 | 2009-03-01 00:00:00 | 2008-11-08 00:00:00 | 2009-03-01 00:00:00 | 2008-11-08 00:00:00 | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2008-11-08 00:00:00 | 2009-03-01 00:00:00
No | Person 11 |  | 2009-07-09 00:00:00 | 2009-03-01 00:00:00 | 2009-04-07 00:00:00 | 2009-06-09 00:00:00 | 2008-05-01 00:00:00 | 2009-05-09 00:00:00 | 2009-03-09 00:00:00 | 2009-07-09 00:00:00 | 2009-02-09 00:00:00
Yes | Person 12 |  |  | 2009-02-01 00:00:00 | 2009-06-09 00:00:00 | 2009-02-09 00:00:00 |  | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2009-06-09 00:00:00 | 2009-01-09 00:00:00
Yes | Person 13 |  | 2009-08-09 00:00:00 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 |  | 2009-07-09 00:00:00 | 2009-07-09 00:00:00 | 2009-07-09 00:00:00
No | Person 14 |  | 2009-07-09 00:00:00 | 2008-11-07 00:00:00 | 2009-04-01 00:00:00 | 2008-11-08 00:00:00 | 2008-12-08 00:00:00 | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2008-12-08 00:00:00 | 2008-05-08 00:00:00
No | Person 15 |  |  | 2009-03-01 00:00:00 | 2009-03-02 00:00:00 | 2009-03-01 00:00:00 | 2007-10-01 00:00:00 | 2009-04-09 00:00:00 | 2009-03-09 00:00:00 | 2009-03-09 00:00:00 | 2009-03-01 00:00:00
Yes | Person 16 |  | 2009-07-09 00:00:00 | 2008-12-07 00:00:00 | 2008-12-09 00:00:00 | 2008-12-08 00:00:00 | 2008-06-08 00:00:00 | 2009-05-01 00:00:00 | 2009-03-01 00:00:00 | 2008-12-08 00:00:00 | 2008-07-08 00:00:00
Yes | Person 17 |  | 2009-08-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-03-09 00:00:00 | 2009-05-09 00:00:00 | 2009-05-09 00:00:00 | 2009-05-09 00:00:00 | 2008-08-08 00:00:00 | 2009-01-09 00:00:00
No | Person 18 |  |  | 2009-03-01 00:00:00 | 2009-07-09 00:00:00 | 2009-03-01 00:00:00 | 2009-07-09 00:00:00 | 2009-05-09 00:00:00 | 2009-03-09 00:00:00 | 2009-06-09 00:00:00 | 2009-03-09 00:00:00
Yes | Person 19 |  |  | 2009-02-28 00:00:00 | 2008-11-08 00:00:00 | 2009-02-09 00:00:00 |  | 2009-04-09 00:00:00 | 2009-03-01 00:00:00 | 2009-06-09 00:00:00 | 2009-01-09 00:00:00
Yes | Person 20 |  |  | 2009-02-28 00:00:00 | 2008-11-08 00:00:00 | 2009-07-09 00:00:00 |  | 2008-11-08 00:00:00 | 2009-07-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00
% Trained |  |  |  | ??% | ??% | ??% | ??% | ??% | ??% | ??% | ??%