Spreadsheet: 135061d1325793246-generate-warning-if-values-not-met-daily-timesheet-v2
Sheet: PFS

Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | 6-2
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  | ABBOT A |  |  | 06:00:00 | 14:00:00 |  |  | 700 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CONTROL PANEL
 |  | BARRY B |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | CAZIZ C |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6-2 | 6.58 |  | Shift | Machine |  |  | 6-2 | 2-10 | Days | Nights
 |  | DELTA D |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-10 | 6.58 |  |  |  |  | A | 0.1713 | 0.1713 | 0.1713 | 0.179865
 |  | ECHO E |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days | 6.23 |  | 6-2 | 1 |  | B | 0.1596 | 0.1596 | 0.1596 | 0.16758
 |  | FINN F |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights |  |  | 2-10 | 2 |  | C | 0.1369 | 0.1369 | 0.1369 | 0.143745
 |  | GRACE G |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days | 3 |  | 1 | 0.3813 | 0.3813 | 0.54 | 0.54
 |  | HOOPER H |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights | 4 |  | 2 | 0.3813 | 0.3813 | 0.367 | 0.367
 |  | INNIS I |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0.61 | 0.61 | 0.61 | 0.61
 |  | JEEP J |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0.3813 | 0.3813 | 0.367 | 0.367
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | 2-10
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  | KELLY K |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  | LIMA L |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | MOOR M |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | NORIE N |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | OTTER O |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | PETTLE P |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | QUEEN Q |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | [NAME] R |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | STONE S |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  | TAMMY T |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 2 |  | Shift :- | 6-2
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 2 |  | Shift :- | 2-10
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 3 |  | Shift :- | Days
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 08:00:00 | 16:30:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 4 |  | Shift :- | 6-2
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2012-01-02 00:00:00 |  |  | Machine :- | 4 |  | Shift :- | 2-10
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
Date :- |  | 2011-12-06 00:00:00 |  |  | Machine :- | 1 |  | Shift :- | Nights
Production
Clock no |  | Operator | Grade |  | In | Out | In | Out | Total Pairs | SMV | Pence per minute | Timework Minuits | Pay Average | Piecework Earnings | Timework Earnings | Pay Average Earnings | Total  Daily Earnings | Machine | Shift | Basic Rate | Date |  |  |  |  |  |  |  | Team Leader | Time Only |  | Piecework Minuites | Timework Minuits | Pay Average | Total Minuites | ContractedMinuites | [NAME]  (+OT / -Under)
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  | 1250 |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  | 06:00:00 | 14:00:00 |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | Total [NAME] | Total Hours Worked | Total Contract Hours | Overtime + Short - |  |  | Wage Earned | Time Only