Spreadsheet: 792078d1660732302-formula-to-auto-calculate-gestation-please-help-2022-2023-screening-db-copy-ans
Sheet: Transfers In

Explanatory notes: The purpose of this spreadsheet is to act as our main ANNB screening failsafe database, monitoring each client closely to ensure seamless movement throughout the screening pathway.
Patient Details |  |  |  |  |  | Booking Details |  |  | Gestation Details |  |  | Bloods |  |  |  | ANSCT |  |  |  | Serology |  |  | Blood Group |  | First Trimester Screening |  |  |  |  |  | Second Trimester Screening |  |  |  | [NAME] |  |  |  | Anomaly Repeat |  |  | Growth |  | Referral/ Further Diagnostic Testing |  |  |  | Additional Comments | Affected by Covid-19
Surname | Forename | DOB | PASID | NHS number | Date of booking | Team | Caseload surgery | Hospital/Country transferred from | Gestation weeks | Gestation days | Live gestation from scan | Evidence for bloods from previous hospital | Taken at booking | Reason | Date taken | Resulted before 10/40 | No- reason | Sickle Cell | Thalassaemia | HIV | [NAME] | Syphillis | Group | Antibodies | Screening at previous hospital | Date | T21 | T18/13 | <PAPP-A | <PAPP-A actioned | Date | T21 | Raised AFP | [NAME] actioned | Date | Hospital | Gestation | Complete/for repeat scan/ referral | Date | Gestation | Complete/ incomplete | Date | Gestation | Reason for referral | Referred to | PND | Outcome
Seaman | Alicia | 1998-06-24 00:00:00 | [NAME] | [PHONE] | 2022-04-21 00:00:00 |  | Rosedale | NNUH | 14 | 0 |  | Y | N |  |  | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes | 2022-04-08 00:00:00 | Low risk | Low risk | N |  |  |  |  |  | 2022-06-07 00:00:00 | JPUH | 20+5 | Complete
Ram | Kiera | 1994-05-04 00:00:00 | D501200 | [PHONE] | 2022-04-21 00:00:00 |  |  | NNUH | 34 | 2 |  | Y | N |  |  | N | Late transfer in | N | N | N | N | N | B Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  | 2022-01-31 00:00:00 | NNUH | NAD |  |  |  |  | 2022-05-17 00:00:00 | 38+0
Beautyman | Caroline | 1996-10-15 00:00:00 | [NAME] | [PHONE] | 2022-04-22 00:00:00 | Rose-Quartz | [NAME] | Clacton | 24 | 1 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Neg | None | No evidence |  |  |  |  |  |  |  |  |  |  | Clacton |  |  |  |  |  | 2022-05-23 00:00:00 | 28+4
Sergeant | Jessica | 1987-02-13 00:00:00 | D328507 | [PHONE] | 2022-05-03 00:00:00 | Sapphire | Nelson Medical Centre | Huddersfield | 23 | 5 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Neg | None | Yes | 2022-05-03 00:00:00 | Low risk | Low risk |  |  |  |  |  |  |  | Huddersfield |  |  |  |  |  | 2022-06-08 00:00:00 | 28+6
Sokolova | Tatjana | 1992-02-26 00:00:00 | J267054 | [PHONE] | 2022-05-05 00:00:00 | Out of Area | Out Of Area | NNUH | 30 | 5 |  | N | Y |  |  | N | Late transfer in | N | N | N | Positive | N | O Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  | 2022-02-25 00:00:00 | NNUH | NAD |  |  |  |  | 2022-05-18 00:00:00 | 32+4
Playle | Jessica | 2004-04-18 00:00:00 | [NAME] | [PHONE] | 2022-05-10 00:00:00 | Sapphire | Nelson Medical Centre | Kent | 22 | 1 |  | N | N |  | 2022-05-26 00:00:00 | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  | 2022-05-12 00:00:00 | JPUH | 22+4 | Complete
Iamandi | Ana | 1999-12-23 00:00:00 | J234881 | [PHONE] | 2022-05-11 00:00:00 | Sapphire | Nelson Medical Centre | Romania | 37 | 0 |  | N | Y |  |  | N | Late transfer in | N | Poss AT/ID | N | N | N | O Pos | None | No evidence |  |  |  |  |  |  |  |  |  |  | Romania
[NAME]-Ure | Kayleigh | 2001-02-26 00:00:00 | J267330 | [PHONE] | 2022-05-12 00:00:00 | Opal | Beccles Medical | NNUH | 37 | 5 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | B Pos | None | Yes | 2021-11-11 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-01-12 00:00:00 | NNUH | NAD |  |  |  |  | 2022-05-13 00:00:00 | 37+6
Perrement | [NAME] | 1994-03-06 00:00:00 | [NAME] | [PHONE] | 2022-05-13 00:00:00 |  |  | NNUH | 38 | 4 |  | Y | N |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | No evidence |  |  |  |  |  |  |  |  |  |  | NNUH | NAD
Kearney | [NAME] | 1988-08-04 00:00:00 | J060151 | [PHONE] | 2022-05-22 00:00:00 | Opal | Beccles Medical | Queen [NAME] | 37 | 5 |  | N | N |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | Declined |  |  |  |  |  |  |  |  |  |  | QEH | NAD
[NAME] | Christina | 1988-06-16 00:00:00 | D512652 | [PHONE] | 2022-05-22 00:00:00 | Emerald | Out Of Area | NNUH | 36 | 0 |  | Y | N |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | Yes | 2021-12-10 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-02-03 00:00:00 | NNUH | NAD |  |  |  |  | 2022-05-24 00:00:00 | 36+2
Rock | Ebony | 1994-09-02 00:00:00 | D375834 | [PHONE] | 2022-06-09 00:00:00 | Opal | Kessingland | Pontefract | 25 | 0 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes | 2022-03-11 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-03-11 00:00:00 | Pontefract | NAD
Hollnack | Christina | 1990-05-09 00:00:00 | J268589 | [PHONE] | 2022-06-12 00:00:00 |  | High Street | Bedford | 19 | 3 |  | N | N | Telephone booking |  | N | Late transfer in | N | N | N | N | N | O Pos | None | Yes | 2022-06-12 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-06-22 00:00:00 | JPUH | 20+6 | Complete
[NAME] | Charlene | 1988-06-21 00:00:00 | D264831 | [PHONE] | 2022-06-13 00:00:00 |  | Out Of Area | NNUH | 24 | 3 |  | Y | Y |  |  | N | Late transfer in | N | N | N | N | N | B Pos | None | Yes | 2022-03-23 00:00:00 | Low risk | Low risk |  |  |  |  |  |  |  | NNUH
Graver | Charlotte | 1995-10-06 00:00:00 | D400592 | [PHONE] | 2022-07-13 00:00:00 | Opal | Beccles Medical | NNUH | 36 | 0 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Neg | None | Yes | 2022-01-31 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-03-30 00:00:00 | NNUH | NAD
Hall | Emily | 2001-06-19 00:00:00 | [NAME] | [PHONE] | 2022-07-13 00:00:00 | Sapphire | Nelson Medical Centre | NNUH | 27 | 6 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  |  | NNUH | NAD |  |  |  |  | 2022-06-21 00:00:00 | 29+0
Nicol | Jemma | 1985-07-03 00:00:00 | D095240 | [PHONE] | 2022-07-13 00:00:00 | Rose-Quartz | Crestview | Brunei | 33 | 6 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | No evidence |  |  |  |  |  |  |  |  |  |  | Brunei |  |  |  |  |  | 2022-08-04 00:00:00 | 37+0
Young | Rebecca | 1997-09-15 00:00:00 | [NAME] | [PHONE] | 2022-07-26 00:00:00 | Emerald | Park | Clacton | 18 | 1 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | B Pos | None | Yes | 2022-06-16 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-08-10 00:00:00 | JPUH | 20+2 | Complete
Reeves | Selina | 1994-06-08 00:00:00 | [NAME] | [PHONE] | 2022-08-02 00:00:00 | Ruby | Gorleston Medical Centre | NNUH | 26 | 4 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  |  | NNUH
Boxall | Gemma | 2000-04-04 00:00:00 | [NAME] | [PHONE] | 2022-08-10 00:00:00 |  | High Street | Ipswich | 24 | 5 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes | 2022-07-23 00:00:00 | Low risk | Low risk |  |  |  |  |  |  |  | Ipswich | NAD
Elbashir | [NAME] | 1984-07-11 00:00:00 | J271409 | [PHONE] | 2022-08-10 00:00:00 | Ruby | Gorleston Medical Centre | Croydon | 15 | 1 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | O Pos | None | Yes |  | Low risk | Low risk |  |  |  |  |  |  | 2022-09-16 00:00:00 | JPUH
Bithas | Christiana | 1995-10-08 00:00:00 | J061308 | [PHONE] | 2022-08-13 00:00:00 | Sapphire | Nelson Medical Centre | Southport | 31 | 4 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | AB Pos | None | Yes | 2022-04-13 00:00:00 | Low risk | Low risk |  |  |  |  |  |  | 2022-05-24 00:00:00 | Southport | NAD
[NAME] | Kylie | 1994-03-19 00:00:00 | D546849 | [PHONE] | 2022-08-13 00:00:00 | Ruby | Gorleston Medical Centre | Queen [NAME] | 15 | 1 |  | N | Y |  |  | N | Late transfer in | N | N | N | N | N | A Pos | None | Yes | 2022-07-29 00:00:00 |  |  |  |  |  |  |  |  | 2022-09-20 00:00:00 | JPUH