Spreadsheet: 69787d1270444612-nested-if-and-formula-sample1
Sheet: Sheet1

Employee: |  | [NAME] |  |  |  |  | Op #: | 63
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 | #N/A | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | #N/A | 0
Rate | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 1 | 10 | 11 | 11 | 15 | 15 | 10 | 10
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 | 10 | 11 | 11 | 15 | 15 | 10 | 10
Rate 2 | 10 | 11 | 11 | 15 | 15 | 10 | 10
Total Hours Week 1 |  |  |  |  |  |  | Hours Scheduled Week 1
Day | Date | In | Out | Total |  |  | In | Out | Late
Mon | 2010-03-22 00:00:00 | 06:00:00 | 14:00:00 | 0 |  |  | 0 | 0 | 0
 |  |  |  | X |  |  | 0 | 0 | 0
Tue | 2010-03-23 00:00:00 | 06:00:00 | 14:00:00 | X |  |  | 06:00:00 | 14:00:00 | 0
 |  |  |  | X |  |  | 0 | 0 | 0
Wed | 2010-03-24 00:00:00 |  |  | X |  |  | 07:00:00 | 14:00:00 | -0.2916666666666667
 |  |  |  | X |  |  | 0 | 0 | 0
Thu | 2010-03-25 00:00:00 |  |  | X |  |  | 07:30:00 | 15:30:00 | -0.3125
 |  |  |  | X |  |  | 0 | 0 | 0
Fri | 2010-03-26 00:00:00 |  |  | X |  |  | 07:00:00 | 14:00:00 | -0.2916666666666667
 |  |  |  | X |  |  | 0 | 0 | 0
Sat | 2010-03-27 00:00:00 |  |  | X |  |  | 07:00:00 | 15:00:00 | -0.2916666666666667
 |  |  |  | X |  |  | 0 | 0 | 0
Sun | 2010-03-28 00:00:00 |  |  | X |  |  | 0 | 0 | 0
 |  |  |  | X |  |  | 0 | 0 | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0
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 |  |  | 0 | 0 | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 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 | 0 | 0
Wed | 2010-03-31 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 07:00:00 | 14:00:00 | -0.2916666666666667
 |  |  |  | 1900-01-01 00:00:00 |  |  | 15:00:00 | 18:00:00 | -0.625
Thu | 2010-04-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 07:00:00 | 14:00:00 | -0.2916666666666667
 |  |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 0
Fri | 2010-04-02 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 07:00:00 | 14:00:00 | -0.2916666666666667
 |  |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 0
Sat | 2010-04-03 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 07:00:00 | 15:00:00 | -0.2916666666666667
 |  |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 0
Sun | 2010-04-04 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 0
 |  |  |  | 1900-01-01 00:00:00 |  |  | 0 | 0 | 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 | #N/A | #N/A |  | 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 | #N/A | #N/A |  |  |  | 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