Spreadsheet: 42452d1241019605-if-date-1-is-48hrs-before-date-2-return-1-we-blank-template-1-v4-test
Sheet: A Client

A Client | Company Name - Office_Name - Weekend 06 (02/05/09 - 03/05/09)
CLIENT: | A Client | WORKSITE: | [NAME]
PURCHASE ORDER NO: | 12345 | ACCESS @: | Piccadilly Station
REQUESTER: | [NAME] | DEPOT: | [NAME]
QS: | [NAME] | WORK DETAILS: | Re-Rail
SHIFT(S) OFFERED: | 4 | SHIFT(S) OFFERED ON: | 2009-04-27 00:00:00 | 10:30:00
SHIFT(S) FILLED: | 3 | P/O RECEIVED ON: | 2009-04-27 00:00:00 | 14:30:00
SHIFT(S) CANCELLED: | 1 | SHIFT(S) CANCELLED ON: | 2009-04-28 00:00:00 | 09:30:00
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
Sat 2300 - Sun 1100 | PTS | Name 1 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
 | UTF PTS | Name 2 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | CANCELLED PTS | Name 3 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | DNG PTS | Name 4 | [NAME] | 8 | 16 | LTD | OT2 | 0 | 0 | 0
 | SITE CONTACT: | [NAME] | [NAME]
CLIENT: | A Client | WORKSITE: | [NAME]
PURCHASE ORDER NO: | 12345 | ACCESS @: | Piccadilly Station
REQUESTER: | [NAME] | DEPOT: | [NAME]
QS: | [NAME] | WORK DETAILS: | Re-Rail
SHIFT(S) OFFERED: | 4 | SHIFT(S) OFFERED ON: | 2009-04-29 00:00:00 | 10:30:00
SHIFT(S) FILLED: | 4 | P/O RECEIVED ON: | 2009-05-05 00:00:00 | 14:30:00
SHIFT(S) CANCELLED: | 0 | SHIFT(S) CANCELLED ON:
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
Start: 02/05/09 23:00 | PTS | Name 1 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
Finish: 03/05/09 11:00 | PTS | Name 2 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
 | PTS | Name 3 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
 | PTS | Name 4 | [NAME] | 8 | 16 | LTD | OT2 | 12 | 96 | 192
 | SITE CONTACT: | [NAME] | [NAME]
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT:
CLIENT | A Client | WORKSITE
MRF |  | ACCESS @
REQUESTER |  | DEPOT
QS |  | WORK DETAILS
DAY / TIME | JOB TYPE | CANDIDATE | Mobile Number | Pay Rate | Inv Rate | Pay Method | TRC | Hrs | Pay | Invoice
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0
 | SITE CONTACT: