Spreadsheet: 192534d1352451980-conditional-format-a-referenced-cell-personnel-listing-template
Sheet: timeware Personnel data

employee_id | user_id | badge | first_name | middle_name | last_name | paylink | ni_code | [NAME] | badge_expiry | Sex | passport_number | visa_number | known_as | union_name | union_details | union_number | address | postcode | home_tel | mobile_tel | pager_number | e_mail | nok_name | nok_tel | bank_name | bank_address | bank_tel | account_name | account_number | account_sort_code | pension_name | pension_number | pension_details | pension_date_of_entry | pension_voluntary_contribution | vehicle_registration_number | vehicle_make_and_model | driving_licence_number | driving_endorsements_last_checked | driving_endorsements_review | driving_endorsements_review_rfa | driving_endorsement_details | date_started_with_company | appraisal_next | appraisal_next_rfa | appraisal_comment | doctor_name | doctor_address | doctor_tel | blood_group | disability_details | disability_rating | medication_details | vts_user_name | [NAME] | vts_administrator | wti_status | wti_opted_out_date | wti_opted_out_review_date | wti_opted_out_review_date_rfa | wti_opt_out_letter | wti_night_shift_worker | [NAME] | employee_grouping_id | employee_status | employee_title | employee_religion | employee_nationality | employee_ethnic_origin | employee_marital_status | employee_vehicle_ownership | company_grouping_01 | company_grouping_02 | company_grouping_03 | company_grouping_04 | company_grouping_05 | company_grouping_06 | [NAME] | company_grouping_08 | company_grouping_09 | company_grouping_10 | period_schedule_allocation_week | absence_entitlement | period_schedule | selected | secondary_employment | secondary_employment_identifier | flexitime_balance_date | flexitime_balance | personal_information_portal | enrolment_state | retirement_age_rfa | years_service_rfa | email_policy | terminal_policy | badge_activation | remuneration | years_service_rfa | email_policy_id | badge_activation | remuneration_id
9 | 1 | 9553403 | [NAME] | [NAME] | [NAME] | PY/00012 | NM062685C | 9/12/1966 | 11/29/2012  7:08:27 AM | Male | 782838 | 092834 | [NAME], [NAME] |  |  |  | 2 Fieldhouse Road Rochdale Lancashire | hxzdgsd | 01706 658 222 | +783726482 | 02983423 | [EMAIL] | Lauren | 01706 658 222 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 6/19/2002 |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  |  |  |  | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | [NAME] | 8842 | 0 | 0 |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fswiss [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  | Employee | Mr | Catholic | Dutch | White | Separated |  | DRAWING OFFICE | MONTHLY |  | [NAME] |  |  |  |  |  |  | 1 | MONTHLY | DO Early | 0 | 0 |  |  |  | All Employees | 0 | 0 | 0 |  | Attendance \ Jobcosting | 8/14/2012  8:09:27 AM
19 | 1 | 9550480 | [NAME] |  | Albone | PY/00061 | NI/00060 | 8/24/1966 | 11/23/2012  6:51:27 AM | Male |  |  | Albone, [NAME] |  |  |  | 5 Fieldhouse Road Rochdale Lancashire | OL12 9LW |  | +783726482 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 10/25/2004 |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  |  |  |  | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | [NAME] | 1965 | 0 | 0 |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  | Employee |  |  | African |  |  |  | DRAWING OFFICE | MONTHLY | LOLOLOL | [NAME] | Support |  |  |  |  |  | 1 | MONTHLY | DO Early | 0 | 0 |  |  |  | All Employees | 0 | 0 | 0 |  | Attendance \ Jobcosting | 9/4/2012  8:46:27 AM
22 | 1 | 9553942 | Zoran |  | Krcunovic | [NAME] | px237137b | 7/12/1962 | 11/7/2012  7:06:42 AM | Male |  |  | Krcunovic, [NAME] |  |  |  | 7 Fieldhouse Road Rochdale Lancashire | jgrthj | 01706 658 222 | +783726482 |  | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 7/3/2006 |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  |  |  |  | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | [NAME] | 1970 | 0 | 0 |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  | Employee |  |  |  |  | Married |  | DRAWING OFFICE | MONTHLY |  | [NAME] |  |  |  |  |  |  | 1 | MONTHLY | DO Early | 0 | 0 |  |  |  | All Employees | 0 | 0 | 0 |  | Attendance \ Jobcosting | 10/5/2012  7:08:42 AM
27 | 1 | 9555064 | George |  | Noon | PY/00092 | NI/00092 | 9/29/1952 | 2/15/2013  5:08:42 AM | Male |  |  | Noon, George |  |  |  | 9 Fieldhouse Road Rochdale Lancashire | 345345 | 01706 658 222 | +783726482 |  | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 9/20/2010 |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  |  |  |  | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | [NAME] | 5025 | 0 | 0 |  |  | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } | 0 | {\rtf1\ansi\ansicpg1252\deff0\deflang2057{\fonttbl{\f0\fnil\fcharset0 MS [NAME];}} \viewkind4\uc1\pard\f0\fs17  \par } |  | Employee - Not Clocking |  |  |  | White | Married |  | DRAWING OFFICE | MONTHLY |  |  |  |  |  |  |  |  | 1 | MONTHLY | 08:00 16:00 | 0 | 0 |  |  |  | All Employees | 0 | 0 | 0 |  | Attendance \ Jobcosting | 8/29/2012  6:06:42 AM