Spreadsheet: 178381d1346776682-help-on-entering-data-from-one-sheet-based-on-multiple-criteria-12-13-budget-test-9-4-12
Sheet: Student Worker Pay

Name | Dept | Title | Timesheet Start Date | Timesheet End Date | Valid | Rate | Hours | Days | Pay | Due  Date | Date  Submitted | Late
Marquez, [NAME] | Earth Sciences |  | 2012-06-01 00:00:00 | 2012-06-29 00:00:00 |  | 8 | 56 | 14 |  | 2012-06-30 00:00:00 | 2012-07-30 00:00:00
Andrzejewski, Britnee | Animal |  | 2012-07-10 00:00:00 | 2012-07-31 00:00:00 |  | 8.75 | 37 | 16 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Eccles, Samantha | Animal |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 87 | 18 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-06 00:00:00 | 2012-07-26 00:00:00 |  | 12.5 | 46 | 8 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Lopez, Blanca | Animal |  | 2012-07-06 00:00:00 | 2012-07-27 00:00:00 |  | 8 | 27 | 6 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-03 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 113 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Moore, [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-23 00:00:00 |  | 8.75 | 17 | 5 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], Orlando | Animal |  | 2012-07-06 00:00:00 | 2012-07-25 00:00:00 |  | 8 | 31.5 | 5 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
Smith, Lindsey | Animal |  | 2012-07-02 00:00:00 | 2012-07-03 00:00:00 |  | 13.27 | 17 | 4 |  | 2012-07-31 00:00:00 | 2012-08-13 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-09 00:00:00 | 2012-07-30 00:00:00 |  | 8 | 41 | 7 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
[NAME], [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-23 00:00:00 |  | 10 | 70 | 9 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Weeks, [NAME] | Animal |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 10 | 30 | 5 |  | 2012-07-31 00:00:00 | 2012-08-02 00:00:00
Zayas, Samantha | Biology |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 8.75 | 34 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Earth Sciences |  | 2012-07-06 00:00:00 | 2012-07-19 00:00:00 |  | 8 | 24 | 6 |  | 2012-07-31 00:00:00 | 2012-08-15 00:00:00
Marquez, [NAME] | Earth Sciences |  | 2012-07-06 00:00:00 | 2012-07-28 00:00:00 |  | 8 | 39 | 8 |  | 2012-07-31 00:00:00 | 2012-07-30 00:00:00
Payne, [NAME] | Earth Sciences |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 8 | 62 | 18 |  | 2012-07-31 00:00:00 | 2012-08-01 00:00:00
Randall, [NAME] | Grants |  | 2012-07-02 00:00:00 | 2012-07-26 00:00:00 |  | 8 | 40 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Redinger, [NAME] | Grants |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 8.75 | 56.5 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Aceves, Teresa | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 12.5 | 136 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Acosta, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-27 00:00:00 |  | 10 | 31.5 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Balsiger, Joel | Horticulture |  | 2012-07-18 00:00:00 | 2012-07-30 00:00:00 |  | 8.75 | 34 | 5 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Castaneda, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 10 | 120 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], Adrian | Horticulture |  | 2012-07-11 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 86 | 11 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 88.5 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 72 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-07-05 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 72 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-25 00:00:00 |  | 10 | 74 | 15 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Machaca, Patty | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 8.75 | 92 | 14 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Meraz, Stephen | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 127 | 16 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Porras, Victoria | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 10 | 92.5 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Tamillo, Blanca | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 62 | 9 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Weber, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-30 00:00:00 |  | 10 | 90.25 | 12 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Winslow, [NAME] | Horticulture |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 115.5 | 18 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Math |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 8.75 | 68 | 16 |  | 2012-07-31 00:00:00 | 2012-07-24 00:00:00
[NAME], [NAME] | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 67 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 8.75 | 79 | 17 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Ruiz, Briana | NSD |  | 2012-07-02 00:00:00 | 2012-07-31 00:00:00 |  | 10 | 65.75 | 16 |  | 2012-07-31 00:00:00 | 2012-07-30 00:00:00
Solis, Robyn | Wildlife |  | 2012-07-07 00:00:00 | 2012-07-24 00:00:00 |  | 8.75 | 15 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
Ybanez, [NAME] | Wildlife |  | 2012-07-05 00:00:00 | 2012-07-25 00:00:00 |  | 8.75 | 15 | 6 |  | 2012-07-31 00:00:00 | 2012-07-31 00:00:00
[NAME], [NAME] | Math |  | 2012-08-01 00:00:00 | 2012-08-02 00:00:00 |  | 8.75 | 8 | 2 |  | 2012-08-31 00:00:00 | 2012-08-01 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  | 10 | 76 | 12 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Lopez, Blanca | Animal |  | 2012-08-07 00:00:00 | 2012-08-24 00:00:00 |  | 8 | 35.75 | 7 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Porras, Victoria | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 102.5 | 14 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 89 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Jordan, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 89 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Weber, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 106.5 | 15 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Winslow, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 98.75 | 16 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Tamillo, Blanca | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  | 10 | 57 | 9 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  | 10 | 75.25 | 13 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Aceves, Teresa | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 12.5 | 75 | 15 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Acosta, [NAME] | Horticulture |  | 2012-08-21 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 35.5 | 6 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Castaneda, [NAME] | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-15 00:00:00 |  | 10 | 80 | 10 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], Adrian | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 98 | 16 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Eccles, Samantha | Animal |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 114 | 19 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], Shannon | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 86 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 122 | 18 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Smith, Lindsey | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 13.27 | 57 | 17 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-08 00:00:00 | 2012-08-24 00:00:00 |  | 12.5 | 27 | 7 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 88 | 11 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Balsiger, Joel | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 8.75 | 63 | 12 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Machaca, Patty | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  | 8.75 | 82.5 | 14 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
[NAME], [NAME] | NSD |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 89 | 21 |  | 2012-08-31 00:00:00 | 2012-08-29 00:00:00
Randall, [NAME] | Grants |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  | 8 | 39.5 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Redinger, [NAME] | Grants |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  | 8.75 | 55 | 15 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Pawlak, Mary | Horticulture |  | 2012-08-27 00:00:00 | 2012-08-30 00:00:00 |  | 10 | 25 | 4 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | RVT |  | 2012-08-27 00:00:00 | 2012-08-29 00:00:00 |  | 10 | 19 | 3 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Andrzejewski, Britnee | Animal |  | 2012-08-02 00:00:00 | 2012-08-21 00:00:00 |  | 8.75 | 38 | 6 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | Earth Sciences |  | 2012-08-02 00:00:00 | 2012-08-25 00:00:00 |  | 8 | 38 | 6 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | NSD |  | 2012-08-01 00:00:00 | 2012-08-30 00:00:00 |  | 8.75 | 49 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | NSD |  | 2012-09-04 00:00:00 | 2012-09-06 00:00:00 |  | 8.75 | 7 | 2 |  | 2012-09-30 00:00:00 | 2012-08-30 00:00:00
Mowery, Blair | Animal |  | 2012-08-27 00:00:00 | 2012-08-31 00:00:00 |  | 8 | 10 | 3 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Meraz, Stephen | Horticulture |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  | 10 | 96 | 12 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Moore, [NAME] | Animal |  | 2012-08-06 00:00:00 | 2012-08-31 00:00:00 |  | 8.75 | 39 | 9 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], [NAME] | Animal |  | 2012-08-01 00:00:00 | 2012-08-29 00:00:00 |  | 8 | 54 | 10 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
[NAME], Orlando | Animal |  | 2012-08-01 00:00:00 | 2012-08-24 00:00:00 |  | 8 | 82 | 11 |  | 2012-08-31 00:00:00 | 2012-08-30 00:00:00
Marquez, [NAME] | Earth Sciences |  | 2012-08-01 00:00:00 | 2012-08-22 00:00:00 |  | 8 | 50.5 | 10 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
Ruiz, Briana | NSD |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10 | 40.25 | 12 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
Antillon, [NAME] | Physics Engineering |  | 2012-08-21 00:00:00 | 2012-08-27 00:00:00 |  | 8.75 | 5.5 | 3 |  | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
[NAME], [NAME] | Physics Engineering |  | 2012-08-01 00:00:00 | 2012-08-31 00:00:00 |  | 10
Randall, [NAME] | Grants |  | 2012-08-27 00:00:00 | 2012-08-31 00:00:00