Spreadsheet: 735962d1623283914-formula-to-pull-specific-information-from-a-cell-with-unrequired-info-lots-of-it-sample-file
Sheet: Sheet1

I want to be able to paste this report, samples on rows 2 & 3. But I need to pull information from [NAME] I need the reference number only, found in the cell beginning withreferenceNumber (19. for example. End result should look like example below
Booking ID (6024644), Object ([PHONE]), 6024644 Offloaded (false), [NAME] (false), 6024644 OnDemandBus (false), 6024644 SMSonApproachSent (null), 6024644 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024644 Status (COMPLETED), 6024644 queueEntryTime (null), 6024644 allowedZones (), 6024644 [NAME] (false), 6024644 EntryType ([NAME]), 6024644 PhoneID (), 6024644 Is [NAME]? (false), 6024644 Is AutoDispatch? (true), 6024644 Reward Stars (null), 6024644 Reward [NAME] (null), 6024644 Priority (NORMAL), 6024644 Pickup (Fri Jun 04 09:00:00 AEST 2021 [[PHONE]] PRE - release time (600), class (class java.util.Date)), 6024644 Passenger # (1), 6024644 Addresses [# 2] (( [Address] ID (15039972) BookingID (6024644) Pass (1) DriverInfo () Name (LOVE smith) Phone ([PHONE]) Location ((-42.8489, 147.3006)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 09:00:00 AEST 2021 [[PHONE]]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (PERONNE AVE) Area (MOONAH) GEO (99 PERONNE AVE, MOONAH),( [Address] ID (15039973) BookingID (6024644) Pass (0) DriverInfo () Name (LOVE smith) Phone ([PHONE]) Location ((-42.8896, 147.3195)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART DAY SURGERY 10 WARNEFORD ST) Area (SOUTH HOBART) GEO (HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH [NAME])), 6024644 Attributes ( Attributes: (Attribute ID[15], State[Ticked];)), 6024644 BookingFares ([BookingFares] bookingId (6024644) referenceNumber (19557616) fareAmount (0.0) extrasAmount (0.0) accountAmount (0.0) requiresAccountRef (true) fixedPriceOnly (false) maxSubsidyPercent (0) maxSubsidyCents (0) requiresOdometer (false) m_bookingPayments obj ([[BookingPayments] bookingId (6024644) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19557616) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)]) [BookingPayments] bookingId (6024644) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19557616) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)), 6024644 Plotted? [NAME] (0) [NAME] (0) Time (null), 6024644 Client (Client Id (12877), Phone (NULL), Names (), Emails (), AccountIds (), Notes (NULL), DriverInfo (NULL) HashCodeWithAddresses ([PHONE]) HashCode ([PHONE]), Addresses (), Include Drivers (), [NAME] (), Include Vehicles (), [NAME] (), Attributes ()), 6024644 m_vehicleId (0), [NAME] (null), 6024644 Offer (none), 6024644 Job (none), 6024644 Updates (1) ([BookingUpdate] Date (2021-06-03 16:59:18.0), operatorId (3001430), [NAME] (Booking Created), [NAME] details ([Existing Client]), debug (false));, 6024644 History (5), 6024644 ([BookingHistory] ID (28612958) status (QUEUED) offerId (0) when (2021-06-04 08:50:01.0) driverId (0) vehicleId (0) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (PreBooking Queued at 04/06/21 [NAME]) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28612960) status (OFFERED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) [NAME] (Same Zone - Waiting Longest) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28612965) status (BOOKED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason () [NAME] (7231092) jobSentDate (null) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28613097) status (ENGAGED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason (Started with DIGITAL IO) [NAME] (7231092) jobSentDate (2021-06-04 08:50:05.0) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (2021-06-04 08:57:26.0) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28613268) status (COMPLETED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason (Completed with DIGITAL IO) [NAME] (7231092) jobSentDate (2021-06-04 08:50:05.0) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (2021-06-04 08:57:26.0) jobCompleteDate (2021-06-04 09:11:31.0)); | False | 6024644 | [NAME] 04 09:00:00 AEST 2021 | 99 PERONNE AVE, MOONAH | LOVE [NAME] | HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART | 2021-06-04 08:50:01 | 2021-06-04 08:57:26 | 2021-06-04 09:11:31 | 77 | 3001313 | COMPLETED | [NAME]
Booking ID (6024636), Object ([PHONE]), 6024636 Offloaded (false), [NAME] (false), 6024636 OnDemandBus (false), 6024636 SMSonApproachSent (null), 6024636 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024636 Status (COMPLETED), 6024636 queueEntryTime (null), 6024636 allowedZones (), 6024636 [NAME] (false), 6024636 EntryType ([NAME]), 6024636 PhoneID (), 6024636 Is [NAME]? (false), 6024636 Is AutoDispatch? (true), 6024636 Reward Stars (null), 6024636 Reward [NAME] (null), 6024636 Priority (HIGH), 6024636 Pickup (Fri Jun 04 10:45:00 AEST 2021 [[PHONE]] PRE - release time (900), class (class java.util.Date)), 6024636 Passenger # (1), 6024636 Addresses [# 2] (( [Address] ID (15042907) BookingID (6024636) Pass (1) DriverInfo (please drive down steep driveway to the unit , please call on arrival [PHONE]/ ) Name ([NAME] smith) Phone (62479334) Location ((-42.9025, 147.4589)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 10:45:00 AEST 2021 [[PHONE]]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (OAKDOWNS PARADE) Area (OAKDOWNS) GEO (99 OAKDOWNS PARADE, OAKDOWNS),( [Address] ID (15042908) BookingID (6024636) Pass (0) DriverInfo () Name ([NAME] smith) Phone (62479334) Location ((-42.8808, 147.3293)) Source (ZONEDEFAULT) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART CARDIOLOGY 25 ARGYLE ST) Area (HOBART) GEO (HOBART CARDIOLOGY 25 ARGYLE ST, HOBART)), 6024636 Attributes ( Attributes: (Attribute ID[15], State[Ticked];Attribute ID[16], State[Ticked];Attribute ID[18], State[Ticked];)), 6024636 BookingFares ([BookingFares] bookingId (6024636) referenceNumber (19555284) fareAmount (0.0) extrasAmount (0.0) accountAmount (0.0) requiresAccountRef (true) fixedPriceOnly (false) maxSubsidyPercent (0) maxSubsidyCents (0) requiresOdometer (false) m_bookingPayments obj ([[BookingPayments] bookingId (6024636) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19555284) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)]) [BookingPayments] bookingId (6024636) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19555284) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)), 6024636 Plotted? [NAME] (0) [NAME] (0) Time (null), 6024636 Client (Client Id (279492), Phone (NULL), Names (), Emails (), AccountIds (), Notes (NULL), DriverInfo (NULL) HashCodeWithAddresses ([PHONE]) HashCode ([PHONE]), Addresses (), Include Drivers (), [NAME] (), Include Vehicles (), [NAME] (), Attributes ()), 6024636 m_vehicleId (0), [NAME] (null), 6024636 Offer (none), 6024636 Job (none), 6024636 Updates (2) ([BookingUpdate] Date (2021-06-03 16:55:18.0), operatorId (3001430), [NAME] (Booking Created), [NAME] details ([Existing Client]), debug (false)); ([BookingUpdate] Date (2021-06-04 10:39:07.0), operatorId (-101), [NAME] (Booking Updated), [NAME] details ([Priority changed from NORMAL to HIGH.]), debug (false));, 6024636 History (9), 6024636 ([BookingHistory] ID (28614270) status (QUEUED) offerId (0) when (2021-06-04 10:30:01.0) driverId (0) vehicleId (0) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (PreBooking Queued at 04/06/21 10:30:01) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614273) status (OFFERED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason (Searching Surrounding Zones) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614280) status (BOOKED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason () [NAME] (7231421) jobSentDate (null) jobBookedDate (2021-06-04 10:30:04.0) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614462) status (RESUBMITTED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason (OTHER - Penalty 20 m) [NAME] (7231421) jobSentDate (2021-06-04 10:30:04.0) jobBookedDate (2021-06-04 10:30:04.0) jobPickupDate (null) jobCompleteDate (2021-06-04 10:39:03.0));, 6024636 ([BookingHistory] ID (28614463) status (QUEUED) offerId (9977753) when (2021-06-04 10:39:05.0) driverId (3000698) vehicleId (31) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (Vehicle 075 has Resubmitted 1 times - No longer eligible) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614466) status (OFFERED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (URGENT: Searching Surrounding Zones) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614469) status (BOOKED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason () [NAME] (7231455) jobSentDate (null) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614652) status (ENGAGED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (Started with DIGITAL IO) [NAME] (7231455) jobSentDate (2021-06-04 10:39:14.0) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (2021-06-04 10:47:50.0) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28615169) status (COMPLETED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (Completed with DIGITAL IO) [NAME] (7231455) jobSentDate (2021-06-04 10:39:14.0) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (2021-06-04 10:47:50.0) jobCompleteDate (2021-06-04 11:10:22.0)); | False | 6024636 | [NAME] 04 10:45:00 AEST 2021 | 99 OAKDOWNS PARADE, OAKDOWNS | PHil smith | HOBART CARDIOLOGY 25 ARGYLE ST, HOBART | 2021-06-04 10:39:11 | 2021-06-04 10:47:50 | 2021-06-04 11:10:22 | 116 | 3003433 | COMPLETED | [NAME]
Example
Booking ID (6024644), Object ([PHONE]), 6024644 Offloaded (false), [NAME] (false), 6024644 OnDemandBus (false), 6024644 SMSonApproachSent (null), 6024644 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024644 Status (COMPLETED), 6024644 queueEntryTime (null), 6024644 allowedZones (), 6024644 [NAME] (false), 6024644 EntryType ([NAME]), 6024644 PhoneID (), 6024644 Is [NAME]? (false), 6024644 Is AutoDispatch? (true), 6024644 Reward Stars (null), 6024644 Reward [NAME] (null), 6024644 Priority (NORMAL), 6024644 Pickup (Fri Jun 04 09:00:00 AEST 2021 [[PHONE]] PRE - release time (600), class (class java.util.Date)), 6024644 Passenger # (1), 6024644 Addresses [# 2] (( [Address] ID (15039972) BookingID (6024644) Pass (1) DriverInfo () Name (LOVE smith) Phone ([PHONE]) Location ((-42.8489, 147.3006)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 09:00:00 AEST 2021 [[PHONE]]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (PERONNE AVE) Area (MOONAH) GEO (99 PERONNE AVE, MOONAH),( [Address] ID (15039973) BookingID (6024644) Pass (0) DriverInfo () Name (LOVE smith) Phone ([PHONE]) Location ((-42.8896, 147.3195)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART DAY SURGERY 10 WARNEFORD ST) Area (SOUTH HOBART) GEO (HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH [NAME])), 6024644 Attributes ( Attributes: (Attribute ID[15], State[Ticked];)), 6024644 BookingFares ([BookingFares] bookingId (6024644) referenceNumber (19557616) fareAmount (0.0) extrasAmount (0.0) accountAmount (0.0) requiresAccountRef (true) fixedPriceOnly (false) maxSubsidyPercent (0) maxSubsidyCents (0) requiresOdometer (false) m_bookingPayments obj ([[BookingPayments] bookingId (6024644) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19557616) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)]) [BookingPayments] bookingId (6024644) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19557616) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)), 6024644 Plotted? [NAME] (0) [NAME] (0) Time (null), 6024644 Client (Client Id (12877), Phone (NULL), Names (), Emails (), AccountIds (), Notes (NULL), DriverInfo (NULL) HashCodeWithAddresses ([PHONE]) HashCode ([PHONE]), Addresses (), Include Drivers (), [NAME] (), Include Vehicles (), [NAME] (), Attributes ()), 6024644 m_vehicleId (0), [NAME] (null), 6024644 Offer (none), 6024644 Job (none), 6024644 Updates (1) ([BookingUpdate] Date (2021-06-03 16:59:18.0), operatorId (3001430), [NAME] (Booking Created), [NAME] details ([Existing Client]), debug (false));, 6024644 History (5), 6024644 ([BookingHistory] ID (28612958) status (QUEUED) offerId (0) when (2021-06-04 08:50:01.0) driverId (0) vehicleId (0) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (PreBooking Queued at 04/06/21 [NAME]) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28612960) status (OFFERED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) [NAME] (Same Zone - Waiting Longest) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28612965) status (BOOKED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason () [NAME] (7231092) jobSentDate (null) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (null) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28613097) status (ENGAGED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason (Started with DIGITAL IO) [NAME] (7231092) jobSentDate (2021-06-04 08:50:05.0) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (2021-06-04 08:57:26.0) jobCompleteDate (null));, 6024644 ([BookingHistory] ID (28613268) status (COMPLETED) offerId (9977373) when (2021-06-04 08:50:01.0) driverId (3001313) vehicleId (77) offerZone (97) offerLoc ((-42.8477, 147.2959)) endReason (Completed with DIGITAL IO) [NAME] (7231092) jobSentDate (2021-06-04 08:50:05.0) jobBookedDate (2021-06-04 08:50:04.0) jobPickupDate (2021-06-04 08:57:26.0) jobCompleteDate (2021-06-04 09:11:31.0)); | 19557616 | 6024644 | [NAME] 04 09:00:00 AEST 2021 | 99 PERONNE AVE, MOONAH | LOVE [NAME] | HOBART DAY SURGERY 10 WARNEFORD ST, SOUTH HOBART | 2021-06-04 08:50:01 | 2021-06-04 08:57:26 | 2021-06-04 09:11:31 | 77 | 3001313 | COMPLETED | [NAME]
Booking ID (6024636), Object ([PHONE]), 6024636 Offloaded (false), [NAME] (false), 6024636 OnDemandBus (false), 6024636 SMSonApproachSent (null), 6024636 FleetIdUnique (FleetIdUnique{fleetId=69, productionServerId=3}), 6024636 Status (COMPLETED), 6024636 queueEntryTime (null), 6024636 allowedZones (), 6024636 [NAME] (false), 6024636 EntryType ([NAME]), 6024636 PhoneID (), 6024636 Is [NAME]? (false), 6024636 Is AutoDispatch? (true), 6024636 Reward Stars (null), 6024636 Reward [NAME] (null), 6024636 Priority (HIGH), 6024636 Pickup (Fri Jun 04 10:45:00 AEST 2021 [[PHONE]] PRE - release time (900), class (class java.util.Date)), 6024636 Passenger # (1), 6024636 Addresses [# 2] (( [Address] ID (15042907) BookingID (6024636) Pass (1) DriverInfo (please drive down steep driveway to the unit , please call on arrival [PHONE]/ ) Name ([NAME] smith) Phone (62479334) Location ((-42.9025, 147.4589)) Source (GEOCODE) ZoneID (-1) UBD Ref () RequiredTime (Fri Jun 04 10:45:00 AEST 2021 [[PHONE]]) isPickup (true) isPrebooked (true) SiteType (class com.celltrack.smartMove.geocode.GeoAddress) SitePrefix (99) Site (OAKDOWNS PARADE) Area (OAKDOWNS) GEO (99 OAKDOWNS PARADE, OAKDOWNS),( [Address] ID (15042908) BookingID (6024636) Pass (0) DriverInfo () Name ([NAME] smith) Phone (62479334) Location ((-42.8808, 147.3293)) Source (ZONEDEFAULT) ZoneID (-1) UBD Ref () RequiredTime (null [NULL]) isPickup (false) isPrebooked (false) SiteType (class com.celltrack.smartMove.geocode.GeoAddressPlace) SitePrefix () Site (HOBART CARDIOLOGY 25 ARGYLE ST) Area (HOBART) GEO (HOBART CARDIOLOGY 25 ARGYLE ST, HOBART)), 6024636 Attributes ( Attributes: (Attribute ID[15], State[Ticked];Attribute ID[16], State[Ticked];Attribute ID[18], State[Ticked];)), 6024636 BookingFares ([BookingFares] bookingId (6024636) referenceNumber (19555284) fareAmount (0.0) extrasAmount (0.0) accountAmount (0.0) requiresAccountRef (true) fixedPriceOnly (false) maxSubsidyPercent (0) maxSubsidyCents (0) requiresOdometer (false) m_bookingPayments obj ([[BookingPayments] bookingId (6024636) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19555284) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)]) [BookingPayments] bookingId (6024636) [NAME] (1) PaymentType (2) == BookingPaymentsType (Account/Voucher) [NAME] (23) ReferenceNumber (19555284) PaymentAmount (0.0) PaymentPercent (1000) PaymentMaxAmount (0.0) RequiresRef (1) [NAME] (0)), 6024636 Plotted? [NAME] (0) [NAME] (0) Time (null), 6024636 Client (Client Id (279492), Phone (NULL), Names (), Emails (), AccountIds (), Notes (NULL), DriverInfo (NULL) HashCodeWithAddresses ([PHONE]) HashCode ([PHONE]), Addresses (), Include Drivers (), [NAME] (), Include Vehicles (), [NAME] (), Attributes ()), 6024636 m_vehicleId (0), [NAME] (null), 6024636 Offer (none), 6024636 Job (none), 6024636 Updates (2) ([BookingUpdate] Date (2021-06-03 16:55:18.0), operatorId (3001430), [NAME] (Booking Created), [NAME] details ([Existing Client]), debug (false)); ([BookingUpdate] Date (2021-06-04 10:39:07.0), operatorId (-101), [NAME] (Booking Updated), [NAME] details ([Priority changed from NORMAL to HIGH.]), debug (false));, 6024636 History (9), 6024636 ([BookingHistory] ID (28614270) status (QUEUED) offerId (0) when (2021-06-04 10:30:01.0) driverId (0) vehicleId (0) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (PreBooking Queued at 04/06/21 10:30:01) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614273) status (OFFERED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason (Searching Surrounding Zones) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614280) status (BOOKED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason () [NAME] (7231421) jobSentDate (null) jobBookedDate (2021-06-04 10:30:04.0) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614462) status (RESUBMITTED) offerId (9977753) when (2021-06-04 10:30:01.0) driverId (3000698) vehicleId (31) offerZone (36) offerLoc ((-42.8563, 147.3874)) endReason (OTHER - Penalty 20 m) [NAME] (7231421) jobSentDate (2021-06-04 10:30:04.0) jobBookedDate (2021-06-04 10:30:04.0) jobPickupDate (null) jobCompleteDate (2021-06-04 10:39:03.0));, 6024636 ([BookingHistory] ID (28614463) status (QUEUED) offerId (9977753) when (2021-06-04 10:39:05.0) driverId (3000698) vehicleId (31) offerZone (0) offerLoc ((0.0000, 0.0000)) endReason (Vehicle 075 has Resubmitted 1 times - No longer eligible) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614466) status (OFFERED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (URGENT: Searching Surrounding Zones) [NAME] (0) jobSentDate (null) jobBookedDate (null) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614469) status (BOOKED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason () [NAME] (7231455) jobSentDate (null) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (null) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28614652) status (ENGAGED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (Started with DIGITAL IO) [NAME] (7231455) jobSentDate (2021-06-04 10:39:14.0) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (2021-06-04 10:47:50.0) jobCompleteDate (null));, 6024636 ([BookingHistory] ID (28615169) status (COMPLETED) offerId (9977810) when (2021-06-04 10:39:11.0) driverId (3003433) vehicleId (116) offerZone (36) offerLoc ((-42.8661, 147.4238)) endReason (Completed with DIGITAL IO) [NAME] (7231455) jobSentDate (2021-06-04 10:39:14.0) jobBookedDate (2021-06-04 10:39:13.0) jobPickupDate (2021-06-04 10:47:50.0) jobCompleteDate (2021-06-04 11:10:22.0)); | 19555284 | 6024636 | [NAME] 04 10:45:00 AEST 2021 | 99 OAKDOWNS PARADE, OAKDOWNS | PHil smith | HOBART CARDIOLOGY 25 ARGYLE ST, HOBART | 2021-06-04 10:39:11 | 2021-06-04 10:47:50 | 2021-06-04 11:10:22 | 116 | 3003433 | COMPLETED | [NAME]