Spreadsheet: 776338d1649689488-indirect-function-crew-plan-sample
Sheet: Crewlist

 |  | Location: | NL HXG - Hardinxveld-Giessendam |  | Project: | Mobilisation @ Neptune Repair
 | # | 1st name | Last name | Country | Country code (ISO) | Rank | Company | Cabin | Concatenate | Signed on | Sign off | Date of Birth | Passportnr | Expire date | Medical expire date | Seamandbook 1 (Country code + nr) | Expire date | Seamandbook 2 (Country code + nr) | Expire date | NOK name full | NOK phonenr (incl landcode) | STCW Basic Safety nr | Expire date | STCW Medical First Aid nr | Expire date | STCW Advanced Fire Fighting nr | Expire date | More certs---> insert columns
 | 1 |  |  |  |  |  |  | 3.1A
 |  |  |  |  |  |  |  | 3.1B
 |  |  |  |  |  |  |  | 3.2A
 |  |  |  |  |  |  |  | 3.2B
 |  |  |  |  |  |  |  | 3.3A
 |  |  |  |  |  |  |  | 3.3B
 |  |  |  |  |  |  |  | 3.4A
 |  |  |  |  |  |  |  | 3.4B
 |  |  |  |  |  |  |  | 3.5A
 |  |  |  |  |  |  |  | 3.5B
 |  |  |  |  |  |  |  | 3.6A
 |  |  |  |  |  |  |  | 3.6B
 |  |  |  |  |  |  |  | 3.8A
 |  |  |  |  |  |  |  | 3.8B
 |  |  |  |  |  |  |  | 3.9A
 |  |  |  |  |  |  |  | 3.9B
 |  |  |  |  |  |  |  | 3.10A
 |  |  |  |  |  |  |  | 3.10B
 |  |  |  |  |  |  |  | 3.11A
 |  |  |  |  |  |  |  | 3.11B
 |  |  |  |  |  |  |  | 3.12A
 |  |  |  |  |  |  |  | 3.12B
 |  |  |  |  |  |  |  | 3.13A
 |  |  |  |  |  |  |  | 3.13B
 |  |  |  |  |  |  |  | 4.1A
 |  |  |  |  |  |  |  | 4.1B
 |  |  |  |  |  |  |  | 4.2A
 |  |  |  |  |  |  |  | 4.2B
 |  |  |  |  |  |  |  | 4.3A
 |  |  |  |  |  |  |  | 4.3B
 |  |  |  |  |  |  |  | 4.4A
 |  |  |  |  |  |  |  | 4.4B
 |  |  |  |  |  |  |  | 4.5A
 |  |  |  |  |  |  |  | 4.5B
 |  |  |  |  |  |  |  | 4.6A
 |  |  |  |  |  |  |  | 4.6B
 |  |  |  |  |  |  |  | 4.8A
 |  |  |  |  |  |  |  | 4.8B
 |  |  |  |  |  |  |  | 4.9A
 |  |  |  |  |  |  |  | 4.9B
 |  |  |  |  |  |  |  | 4.10A
 |  |  |  |  |  |  |  | 4.10B
 |  |  |  |  |  |  |  | 4.11A
 |  |  |  |  |  |  |  | 4.11B
 |  |  |  |  |  |  |  | 4.12A
 |  |  |  |  |  |  |  | 4.12B
 |  |  |  |  |  |  |  | 4.13A
 |  |  |  |  |  |  |  | 4.13B
 |  |  |  |  |  |  |  | 5.1A
 |  |  |  |  |  |  |  | 5.1B
 | 27 |  |  |  |  |  |  | 5.2A
 | 28 |  |  |  |  |  |  | 5.2B
 | 29 |  |  |  |  |  |  | 5.3A
 | 30 |  |  |  |  |  |  | 5.3B
 | 31 |  |  |  |  |  |  | 5.4A
 | 32 |  |  |  |  |  |  | 5.4B
 | 33 |  |  |  |  |  |  | 5.5A
 | 34 |  |  |  |  |  |  | 5.5B
 | 35 |  |  |  |  |  |  | 5.6A
 | 36 |  |  |  |  |  |  | 5.6B
 | 37 |  |  |  |  |  |  | 5.8A
 | 38 |  |  |  |  |  |  | 5.8B
 | 39 |  |  |  |  |  |  | 5.9A
 | 40 |  |  |  |  |  |  | 5.9B
 | 41 |  |  |  |  |  |  | 5.10A
 | 42 |  |  |  |  |  |  | 5.10B
 | 43 |  |  |  |  |  |  | 5.11A
 | 44 |  |  |  |  |  |  | 5.11B
 | 45 |  |  |  |  |  |  | 5.12A
 | 46 |  |  |  |  |  |  | 5.12B
 | 47 |  |  |  |  |  |  | 5.13A
 | 48 |  |  |  |  |  |  | 5.13B
 | 49 |  |  |  |  |  |  | 6.1A
 | 50 | test name 1 | lastname 1 | Lithuania |  | AB | this company | 6.2A |  | 2022-01-24 00:00:00 | 2022-04-12 00:00:00 | 1961-12-24 00:00:00 | 1234567 | 2023-09-05 00:00:00 |  | LT - JK040618 | 2023-08-08 00:00:00
 | 51 | test name 2 | lastname 2 | Brazil |  | Engineer | this company | 6.3A |  | 2022-03-23 00:00:00
 | 52 | testname 3 | lastname 3 | Ukraine |  | Rating | this company | 6.4A |  | 2022-03-31 00:00:00
 | 53 | test name 4 | lastname 4 | Netherlands |  | Bargemaster | this company | 6.5A |  | 2022-03-22 00:00:00 |  |  | 9876543 | 2025-08-05 00:00:00 | 2023-10-11 00:00:00 | NL [PHONE] | 2027-07-11 00:00:00 | CY338902 | 2032-02-02 00:00:00 | [NAME] Heide | +[PHONE] | 202175144-01 | 2026-10-14 00:00:00 | 202175599-01 | 2026-10-19 00:00:00 | 202176193-01 | 2026-10-29 00:00:00
 | 54 | test name 5 | lastname 5 | Germany |  | Chief Engineer | this company | 6.6A |  | 2022-03-15 00:00:00
 | 55 | testname 6 | lastname 6 | Latvia |  | AB | this company | 6.8A |  | 2022-02-01 00:00:00 | 2022-04-12 00:00:00 | 1976-03-01 00:00:00 | 1254896 | 2025-03-01 00:00:00 |  | LV - 271997 | 2029-07-10 00:00:00 | NL 02545953 | 2022-03-28 00:00:00
 | 53 | testname 8 | lastname 7 | Belgium |  | Winch Operator | this company | 6.9A |  | 2022-04-12 00:00:00
 | 57 |  |  |  |  |  |  | 6.10A
 | 58 |  |  |  |  |  |  | 6.11A
 | 59 |  |  |  |  |  |  | 6.12A
 | 60 |  |  |  |  |  |  | 6.13A