Spreadsheet: 59370d1259857899-date-help-training-file
Sheet: Example

 | REASON FOR NO CREDIT
 | MEMBERS PRESENT AT OTHER TRNG |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | HOURS NOT CREDITED TOWARDS CO TRNG |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | NON-CREDITABLE COMPANY TRAINING (Hrs)
 | EXAMPLE TRAINING                                                          INSTRUCTIONS: Type only in the green shaded areas on this worksheet. Start by with filling in each member’s name on this shift, then Level (EMT, [NAME]) and the start date of employment. Then type in the date and then the name of each training session you had in the last 12 months for this shift. Next to each members name put the actual number of hours they were present for each training the corresponding training above. Each shift has its own worksheet and so use a different worksheet for each shift. |  |  |  |  |  |  | TRAINING DATE | 2007-01-12 00:00:00 | 2007-01-15 00:00:00 | 2007-01-18 00:00:00 | 2007-01-21 00:00:00 | 2007-01-24 00:00:00 | 2007-01-27 00:00:00 | 2007-01-30 00:00:00 | 2007-02-02 00:00:00 | 2007-02-05 00:00:00 | 2007-02-08 00:00:00 | 2007-02-11 00:00:00 | 2007-02-14 00:00:00 | 2007-02-17 00:00:00
 |  |  |  |  | DRIVERS LICENSE EXPIRES | STATE LICENSE EXPIRES | CPR EXPIRES | TRAINING COURSE | Ladders | SCBA | Hoses & Nozzles | [NAME] | PPE | Forcible Entry | Wildland  Interface | Master [NAME] | Exposures | [NAME]-up | Command and Accountability | Officer Leadership | Ropes & Knots
 | Start Date | Individual Hrs | Employee Name | Level
#N/A | 1988-12-05 00:00:00 | 43 | [NAME] |  | 2009-12-01 00:00:00 |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5
 | 1991-03-15 00:00:00 | 43 | [NAME] |  | 2009-12-02 00:00:00 |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5
 | 1991-03-15 00:00:00 | 43 | [NAME] |  | 2009-12-03 00:00:00 |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 |  | 5
 | 1994-06-19 00:00:00 | 39 | [NAME] |  | 2009-12-04 00:00:00 |  |  |  | 3 | 5 | 3 |  | 3 | 3 | 3 |  | 4 | 0 | 5 | 5 | 5
 | 1992-07-12 00:00:00 | 33 | [NAME] |  | 2009-12-05 00:00:00 |  |  |  | 3 |  | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 |  | 5
 | 1983-03-15 00:00:00 | 45 | [NAME] |  | 2009-12-06 00:00:00 |  |  |  | 3 | 5 | 3 |  | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5 | 5
 | 1997-04-14 00:00:00 | 48 | [NAME] |  | 2009-12-07 00:00:00 |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5 | 5
 | 1989-03-15 00:00:00 | 27 | [NAME] |  | 2009-12-08 00:00:00 |  |  |  | 3 | 5 | 3 | 3 |  | 3 | 3 |  | 4 | 3
 | 2003-03-15 00:00:00 | 48 | [NAME] |  | 2009-12-09 00:00:00 |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5 | 5
 | 1985-10-03 00:00:00 | 40 | [NAME] |  | 2009-12-10 00:00:00 |  |  |  | 3 |  |  | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5 | 5
 | 2007-02-11 00:00:00 | 15 | [NAME] |  | 2009-12-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
#N/A |  | 0 |  |  | 2009-12-12 00:00:00
#N/A |  | 0 |  |  | 2009-12-13 00:00:00
#N/A |  | 0 |  |  | 2009-12-14 00:00:00
#N/A |  | 0 |  |  | 2009-12-15 00:00:00
#N/A |  | 0 |  |  | 2009-12-16 00:00:00
#N/A |  | 0 |  |  | 2009-12-17 00:00:00
#N/A |  | 0 |  |  | 2009-12-18 00:00:00
#N/A |  | 0 |  |  | 2009-12-19 00:00:00
#N/A |  | 0 |  |  | 2009-12-20 00:00:00
 |  | 424 | Total Hours | 424 |  |  |  |  | 30 | 40 | 27 | 24 | 27 | 30 | 30 | 24 | 40 | 27 | 45 | 45 | 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | NUMBER OF PERSONNEL ATTENDING EACH TRAINING SESSION |  |  |  |  |  |  |  | 10 | 8 | 9 | 8 | 9 | 10 | 10 | 8 | 10 | 9 | 9 | 9 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | ACTUAL LENGTH OF EACH TRAINING SESSION IN HOURS |  |  |  |  |  |  |  | 3 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 4 | 3 | 5 | 5 | 5
 | TOTAL PERSONS ATTENDING ALL TRAINING SESSIONS |  |  | 116
 | TOTAL NUMBER OF TRAINING SESSIONS |  |  | 13
 | AVG PERSONNEL ATTENDING EACH TRAINING SESSION |  |  | 8.923076923076923
 | TOTAL TRAINING HOURS |  |  | 424
 | TOTAL NUMBER OF PERSONNEL |  |  | 11
 | PERSONNEL MEETING MINIMUM TRAINING |  |  | 11
 | PERSONNEL MEETING MINIMUM TRAINING |  |  | 1
 | AVERAGE LENGTH OF TRAINING SESSION |  |  | 3.655172413793104