Spreadsheet: 117355d1312713309-excel-2008-almost-solved-vlookup-offset-match-and-countif-copy-of-student-records-and-database
Sheet: Student Sheet

 |  | Member's Name |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Branch No
 |  | Membership No |  |  |  |  |  |  |  |  |  |  |  |  |  | 0981
OCEAN DIVER TRAINING RECORD |  |  |  |  |  |  |  |  |  |  |  |  |  | SPORTS DIVER TRAINING RECORD
Code |  | Description of Training |  |  |  |  |  | Date |  | Instructor & No |  |  |  | Code |  | Description of Training |  |  |  |  |  | Date |  | Instructor & No
SC1 |  | Self Certification Of Fitness To Dive Confirmed |  |  |  |  |  |  |  |  |  |  |  | ST1 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sports Diving
OT1 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | ST2 |  | [NAME]
 |  | Ocean Diver Training |  |  |  |  |  |  |  |  |  |  |  |  |  | Diver Rescue
OS1 |  | Sheltered Water Lesson |  |  |  |  |  |  |  |  |  |  |  | SS1 |  | Sheltered Water Lesson
 |  | Being Underwater |  |  |  |  |  |  |  |  |  |  |  |  |  | Rescue Skills
OT2 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | SO1 |  | Open Water Lesson
 |  | Diving Equipment And Diving Signals |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive Rescue
OS2 |  | Sheltered Water Lesson |  |  |  |  |  |  |  |  |  |  |  | ST3 |  | [NAME]
 |  | Basic Sills |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment And Techniques
OT3 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | ST4 |  | [NAME]
 |  | The Body And Effects Of Diving |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
OS3 |  | Sheltered Water Lesson |  |  |  |  |  |  |  |  |  |  |  | SO2 |  | Opening Water Lesson
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Use Of SMB
OT4 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | SO3 |  | Open Water Lesson
 |  | Planning To Go Diving |  |  |  |  |  |  |  |  |  |  |  |  |  | Simulated Decompression Dive
OS4 |  | Sheltered Water Lesson |  |  |  |  |  |  |  |  |  |  |  | ST5 |  | [NAME]
 |  | Beyond [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Air Planning And Systems
OT5 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | SO4 |  | Open Water Lesson
 |  | Going Diving |  |  |  |  |  |  |  |  |  |  |  |  |  | Compass Navigation/DSMB Deployment
OS5 |  | Sheltered Water Lesson |  |  |  |  |  |  |  |  |  |  |  | ST6 |  | [NAME]
 |  | Safety Skills |  |  |  |  |  |  |  |  |  |  |  |  |  | Going Diving
OT6 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | S05 |  | Open Water Lesson
 |  | What [NAME] If? |  |  |  |  |  |  |  |  |  |  |  |  |  | Diving Leading/Basic Sills Review
OO1 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  | SDTA
 |  | The First Open Water Dive |  |  |  |  |  |  |  |  |  |  |  |  |  | Theory Assessment
OT7 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | SP1 |  | Dry Practical Lesson
 |  | Enjoying Your Diving |  |  |  |  |  |  |  |  |  |  |  |  |  | Assistant Dive Marshal
OO2 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  | To ensure that students receive experience in a range of conditions, the Open Water dives must include five conditions from the following, appropriate to the local conditions in which they will subsequently be diving
 |  | The Second Open Water Dive
OO3 |  | Open Water Lesson
 |  | The Third Open Water Dive |  |  |  |  |  |  |  |  |  |  |  | SDE1
OO4 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  |  |  | Shelving Shore Dive
 |  | The Fourth Open Water Dive |  |  |  |  |  |  |  |  |  |  |  | SDE2
ODTA |  | Assessment |  |  |  |  |  |  |  |  |  |  |  |  |  | Steep Shore Dive
 |  | Theory Assessment |  |  |  |  |  |  |  |  |  |  |  | SDE3
OO5 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive Using A Short Line
 |  | The Fifth Open Water Dive |  |  |  |  |  |  |  |  |  |  |  | SDE4
To ensure that students receive experience in a range of conditions, the Open Water dives must include four conditions from the following, appropriate to the local conditions in which they will subsequently be diving: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drift Dive
OD01 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE6
 |  | Shelving Shore Dive |  |  |  |  |  |  |  |  |  |  |  |  |  | Small Boat Dive
OD02 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE7
 |  | Steep Shore Dive |  |  |  |  |  |  |  |  |  |  |  |  |  | Large Boat Dive
OD03 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE8
 |  | Low [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Wall Dive
OD04 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE9
 |  | Drift Dive |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive In Protection Clothing
OD05 |  |  |  |  |  |  |  |  |  |  |  |  |  | SDE10 |  | Minimum Of Dive Dives/150 Minutes Confirmed Since Qualifying As Ocean Diver
 |  | Small Boat Dive
OD06
 |  | Large Boat Dive
OD07
 |  | Wall Dive |  |  |  |  |  |  |  |  |  |  |  | SDPQE1 |  | Depth Progression
OD08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25m
 |  | Dive In Protective Clothing |  |  |  |  |  |  |  |  |  |  |  | SDPQE2 |  | Depth Progression
OD09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30m
 |  | Maximum Depth Achieved In Training |  |  |  |  |  |  |  |  |  |  |  | SDPQE3 |  | Depth Progression
OD10 |  | Minimum Of Four/Five Dives 120 Minutes Confirmed |  |  |  |  |  |  |  |  |  |  |  |  |  | 35m
OD11
 |  | Depth Progression To 20m
DIVE LEADER TRAINING RECORD |  |  |  |  |  |  |  |  |  |  |  |  |  | DIVE LEADER TRAINING RECORD QUALIFYING DIVES
Code |  | Description of Training |  |  |  |  |  | Date |  | Instructor & No |  |  |  | Code | Date |  | Instructor & No |  |  | Code |  | Date |  | Instructor & No
DT1 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Boat Dives
 |  | The Role Of The Dive Leader |  |  |  |  |  |  |  |  |  |  |  | DLBQ1 |  |  |  |  |  | DLBQ4
DO1 |  | Open Water Lesson
 |  | DSMB Use |  |  |  |  |  |  |  |  |  |  |  | DLBQ2 |  |  |  |  |  | DLBQ5
DO2 |  | Open Water Lesson
 |  | Dive Leading Demonstration |  |  |  |  |  |  |  |  |  |  |  | DLBQ3 |  |  |  |  |  | DLBQ6
DO3 |  | Open Water Lesson
 |  | Dive Leading Practice |  |  |  |  |  |  |  |  |  |  |  | Dive Leading
DT2 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | DLLQ1 |  |  |  |  |  | DLBQ4
 |  | Cardio Pulmonary Resuscitation
DT3 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | DLLQ2 |  |  |  |  |  | DLLQ5
 |  | Oxygen And Diving Incidents
DT4 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | DLLQ6
 |  | Casualty Assessment
DT5 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Depth Experience (greater than those perfomed under skills training for AD)
 |  | Oxygen Administration Equipment |  |  |  |  |  |  |  |  |  |  |  | DLD25M1 |  |  |  |  |  | DLD25M6
DT6 |  | [NAME]
 |  | Oxygen Administration In Practice |  |  |  |  |  |  |  |  |  |  |  | DLD25M2 |  |  |  |  |  | DLD25M7
DT7 |  | [NAME]
 |  | Use Of Oxygen Administration Equipment |  |  |  |  |  |  |  |  |  |  |  | DLD25M3 |  |  |  |  |  | DLD25M8
DT8 |  | [NAME]
 |  | Diving Planning |  |  |  |  |  |  |  |  |  |  |  | DLD25M4 |  |  |  |  |  | DLD25M9
DO4 |  | Open Water Lesson
 |  | Shot Recovery By Simple Lift |  |  |  |  |  |  |  |  |  |  |  | DLD25M5 |  |  |  |  |  | DLD25M10
DT9 |  | [NAME]
 |  | Rescue Management Part 1
D05 |  | Open Water Lesson
 |  | Rescue Management Scenarios |  |  |  |  |  |  |  |  |  |  |  | POST QUALIFICATION EXPERIENCE:
DT10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Code |  | Description of Training |  |  |  |  |  | Date |  | Instructor & No
 |  | Helicopter Operations |  |  |  |  |  |  |  |  |  |  |  | DLPQE1
DT11 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Depth Progression - 40m
 |  | Rescue Management Part 2 |  |  |  |  |  |  |  |  |  |  |  | DLPQE2
D06 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  |  |  | Depth Progression - 45m
 |  | Diving And Rescue Skills Review |  |  |  |  |  |  |  |  |  |  |  | DLPQE3
DO7 |  | Open Water Lesson |  |  |  |  |  |  |  |  |  |  |  |  |  | Depth Progression - 50m
 |  | Rescue Skills Review
DT12 |  | [NAME]
 |  | The Role Of The Dive Marshal
DLTA
 |  | Theory Assessment
DP1 |  | Dry Practical Lesson
 |  | Dive Marshalling 1
DP2 |  | Dry Practical Lesson
 |  | Dive Marshalling 2
To ensure that students receive experience in a range of conditions, the Open Water dives must include four conditions from the following appropriate to the local conditions in which they will subsequently be diving:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Award1
DL01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assistant Diving Instructor
 |  | Planned Decompression Dive |  |  |  |  |  |  |  |  |  |  |  | Award2
DL02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assistant Open Water Instructor
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Award3
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Theory Instructor
 |  | Low [NAME] |  |  |  |  |  |  |  |  |  |  |  | Award4
DL04 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Practical Instructor
 |  | Night Dive |  |  |  |  |  |  |  |  |  |  |  | Award5
DL05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open water Instructor
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Award6
DL06 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assistance Advanced Instructor
 |  | Drift Dive |  |  |  |  |  |  |  |  |  |  |  | Award7
DL07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Advanced Instructor
 |  | Wall Dive |  |  |  |  |  |  |  |  |  |  |  | Award8
DL08 |  | Minimum Of Twenty Dives/600 Minutes Confirmed Since Qualifying As Sports Diver |  |  |  |  |  |  |  |  |  |  |  |  |  | First Class Diver
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Award9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | National Instructor
ADVANCED DIVER QUALIFYING  TRAINING RECORD QUALIFYING DIVES |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVANCED DIVER QUALIFYING  TRAINING RECORD
Code | Date |  | Instructor & No |  |  | Code | Date |  |  | Instructor & No |  |  |  | Code |  | Description of Training |  |  |  |  |  | Date |  | Instructor & No
Boat Dives |  |  |  |  |  |  |  |  |  |  |  |  |  | AT1 |  | [NAME]
ADVBQ1 |  |  |  |  |  | ADVBQ6 |  |  |  |  |  |  |  |  |  | The Role Of The Advanced Diver
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AT2 |  | [NAME]
[NAME] |  |  |  |  |  | ADVBQ7 |  |  |  |  |  |  |  |  |  | Advanced Diving
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AT3 |  | [NAME]
ADVBQ3 |  |  |  |  |  | ADVBQ8 |  |  |  |  |  |  |  |  |  | Organising Diving From Different Platforms
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AP1 |  | Dry Practical Lesson
ADVBQ4 |  |  |  |  |  | ADVBQ9 |  |  |  |  |  |  |  |  |  | Expedition Planning
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AT4 |  | [NAME]
ADVBQ5 |  |  |  |  |  | ADVBQ-10 |  |  |  |  |  |  |  |  |  | Review Of Diving Conditions And On Site First Aid
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A01 |  | Open Water Lesson
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diving And Rescue Skills Review
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A02 |  | Open Water Lesson
Dive Leading |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rescue Kills An Management Review
Depth Experience (greater than those perfomed under skills training for AD) |  |  |  |  |  |  |  |  |  |  |  |  |  | AP2 |  | Dry Practical Lesson
ADVDL1 |  |  |  |  |  | ADVDL6 |  |  |  |  |  |  |  |  |  | Dive Marshalling And Planning
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVTH01
ADVDL2 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Theory Assessment
 |  |  |  |  |  |  |  |  |  |  |  |  |  | To ensure that students receive experience in a range of conditions, the Open Water dives must include four conditions from the following appropriate to the local conditions in which they will subsequently be diving:
ADVDL3 |  |  |  |  |  | [NAME]
ADVDL4 |  |  |  |  |  | ADVDL9 |  |  |  |  |  |  |  | ADVD01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Decompression Dive (1)
ADVDL5 |  |  |  |  |  | ADVDL10 |  |  |  |  |  |  |  | ADVD02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Decompression Dive (2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVD03
Depth Experience (greater than thos performed under skills training for AD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned Decompression Dive (3)
ADVDE1 |  |  |  |  |  | ADVDE4 |  |  |  |  |  |  |  | ADVD04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive In Tidal Waters (1)
ADVDE2 |  |  |  |  |  | ADVDE5 |  |  |  |  |  |  |  | ADVD05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive In Tidal Waters (2)
ADVDE3 |  |  |  |  |  | ADVDE6 |  |  |  |  |  |  |  | ADVD06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dive In Tidal Waters (3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVD07
Dive Management |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drift Dive (1)
ADVDM-2D |  |  |  |  |  | ADVDM-US2 |  |  |  |  |  |  |  | ADVD08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drift Dive (2)
ADVDM-US1 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | ADVD09
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drift Dive (3)
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | In addition to the above, a further six dives should include at least three of the following conditions:  Navigation - Search Dive - Mixed Gas Dive - Advanced Deompression Dive - Surface Location Dive
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ADVDAHOC6