Spreadsheet: 69748d1270374225-nested-if-and-formula-sample1
Sheet: Blank

Employee: |  |  |  |  |  |  | Op #:
Pay Period: 03/22/10 - 04/04/10 |  |  |  |  |  | Check Date: 04/08/10
 | Regular | Split | U.F.G. | Holiday | O/T | Vac | Sick | Off | Msg %
Week 1 | 08:49:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 00:11:00 | 0
Rate |  | 1 | 1 | 0 | 0 | 0 | 0
Rate 1 | $7.25 | $7.25 | $7.25 | $7.25 | 0 | 0 | 0
Week 2 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 | 0
Rate |  | 1 | 1 | 0 | 0 | 0 | 0
Rate 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0
Total Hours Week 1 |  |  |  |  |  |  | Hours Scheduled Week 1
Day | Date | In | Out | Total |  |  | In | Out | Late
Mon | 2010-03-22 00:00:00 | 12:00:00 | 21:00:00 | 09:00:00 |  |  | 06:00:00 | 14:00:00 | 0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Tue | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Wed | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Thu | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Fri | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Sat | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Sun | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 09:00:00 |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  | 7.25
Total Hours Week 2 |  |  |  |  |  |  | Hours Scheduled Week 2
Day | Date | In | Out | Total |  |  | In | Out | Late
Mon | 2010-03-29 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Tue | 2010-03-30 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Wed | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 06:00:00 | 14:00:00 | -0.25
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Thu | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Fri | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Sat | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
Sun | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  | [NAME]
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Mon | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Mon | 2010-03-29 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tue | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tue | 2010-03-30 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wed | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wed | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thu | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thu | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Fri | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Fri | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sat | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sat | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sun | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sun | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Up For Grabs Hours Week 1 |  |  |  |  |  | Up For Grabs Hours Week 2
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Mon | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Mon | 2010-03-29 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tue | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tue | 2010-03-30 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wed | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wed | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thu | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thu | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Fri | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Fri | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sat | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sat | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sun | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sun | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Holiday Hours Week 1 |  |  |  |  |  | Holiday Hours Week
Day | Date | In | Out | Total |  | Day | Date | In | Out | Total
Mon | 2010-03-22 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Mon | 2010-03-29 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Tue | 2010-03-23 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Tue | 2010-03-30 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Wed | 2010-03-24 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Wed | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Thur | 2010-03-25 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Thu | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Fri | 2010-03-26 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Fri | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sat | 2010-03-27 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sat | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Sun | 2010-03-28 00:00:00 |  |  | 1900-01-01 00:00:00 |  | Sun | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  |  | 1900-01-01 00:00:00
Excess Off Time Week 1 |  |  |  |  |  | Excess Off Time Week 2
Day | Date | Off | Allowed | Excess |  | Day | Date | Off | Allowed | Excess
Mon | 2010-03-22 00:00:00 | 00:45:00 | 00:34:00 | 00:11:00 |  | Mon | 2010-03-29 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Tue | 2010-03-23 00:00:00 |  | 0 | 0 |  | Tue | 2010-03-30 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Wed | 2010-03-24 00:00:00 |  | 0 | 0 |  | Wed | 2010-03-31 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Thu | 2010-03-25 00:00:00 |  | 0 | 0 |  | Thu | 2010-04-01 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Fri | 2010-03-26 00:00:00 |  | 0 | 0 |  | Fri | 2010-04-02 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Sat | 2010-03-27 00:00:00 |  | 0 | 0 |  | Sat | 2010-04-03 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
Sun | 2010-03-28 00:00:00 |  | 0 | 0 |  | Sun | 2010-04-04 00:00:00 |  | 0 | 0
 |  |  | 0 | 0 |  |  |  |  | 0 | 0
 |  | 00:45:00 | 00:34:00 | 00:11:00 |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
Percent of Messages Week 1 |  |  |  |  |  | Precent of Messages Week 2
Day | Date | MT | CA | % |  | Day | Date | MT | CA | %
Mon | 2010-03-27 00:00:00 |  |  | 0 |  | Mon | 2010-03-29 00:00:00 |  |  | 0
Tue | 2010-03-28 00:00:00 |  |  | 0 |  | Tue | 2010-03-30 00:00:00 |  |  | 0
Wed | 2010-03-29 00:00:00 |  |  | 0 |  | Wed | 2010-03-31 00:00:00 |  |  | 0
Thu | 2010-03-30 00:00:00 |  |  | 0 |  | Thu | 2010-04-01 00:00:00 |  |  | 0
Fri | 2010-03-31 00:00:00 |  |  | 0 |  | Fri | 2010-04-02 00:00:00 |  |  | 0
Sat | 2010-04-01 00:00:00 |  |  | 0 |  | Sat | 2010-04-03 00:00:00 |  |  | 0
Sun | 2010-04-02 00:00:00 |  |  | 0 |  | Sun | 2010-04-04 00:00:00 |  |  | 0
 |  | 0 | 0 | 0 |  |  |  | 0 | 0 | 0