Spreadsheet: 89739d1289485496-formula-for-dates-pb-data
Sheet: Tracker

 | DATE BOOKED | Time Booked | REF NO | BOOKED BY | SIGNED | DATE PACK IN | PACK BACK | FOLLOW UP CALL
 | 2010-11-04 00:00:00 |  | 27381 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 10am | 27493 | Ade | Signed
 | 2010-11-04 00:00:00 | 10am | 27481 | Pav | Signed
 | 2010-11-04 00:00:00 | 10am | 27447 | [NAME] | Failed |  |  | NOT INTERESTED
 | 2010-11-04 00:00:00 | 11am | 27410 | Lucas | Signed
 | 2010-11-04 00:00:00 | 11am | 27505 | Lucas | Signed
 | 2010-11-04 00:00:00 | 11am | 27488 | Pav | Failed
 | 2010-11-04 00:00:00 | 11am | 23613 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 1pm | 27296 | Ade | Failed
 | 2010-11-04 00:00:00 | 1pm | 20610 | Pav | Signed
 | 2010-11-04 00:00:00 | 1pm | 27507 | [NAME] | Failed
 | 2010-11-04 00:00:00 | 2pm | 27499 | [NAME] | Failed
 | 2010-11-04 00:00:00 | 2pm | 23354 | [NAME] | Signed |  |  | NOT INTERESTED
 | 2010-11-04 00:00:00 | 2.30pm | 27282 | Pav | Ref QD
 | 2010-11-04 00:00:00 | 3pm | 27516 | Asad | Signed
 | 2010-11-04 00:00:00 | 4pm | 27502 | Pav | Signed
 | 2010-11-04 00:00:00 | 5pm | 27532 | Ade | Signed
 | 2010-11-04 00:00:00 | 5pm | 27453 | Kiren | Failed
 | 2010-11-04 00:00:00 | 5.30pm | 27515 | Ade | [NAME]
 | 2010-11-04 00:00:00 | 6pm | 27514 | Asad | Ref QD
 | 2010-11-04 00:00:00 | 6pm | 13924 | Bex | Signed
 | 2010-11-04 00:00:00 | 6pm | 27044 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 6.30pm | 27487 | Raj | Signed
 | 2010-11-04 00:00:00 | 6.30pm | 27523 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 7pm | 27376 | [NAME] | Failed
 | 2010-11-04 00:00:00 | 7pm | 27409 | [NAME] | Not Booked
 | 2010-11-04 00:00:00 | 7pm | 27522 | Ade | Signed
 | 2010-11-04 00:00:00 | 7pm | 27542 | Asad | Signed
 | 2010-11-04 00:00:00 | 7pm | 27531 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 7pm | 27538 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 7.45pm | 27217 | Raj | Signed
 | 2010-11-04 00:00:00 | 8pm | 27437 | Raj | Passed 2 Mani
 | 2010-11-04 00:00:00 | 8pm | 21601 | Ade | Failed
 | 2010-11-04 00:00:00 | 8pm | 27087 | [NAME] | Signed
 | 2010-11-04 00:00:00 | 8.30pm | 27551 | Pav | Signed
 | 2010-11-04 00:00:00 | 8.30pm | 27498 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 9am | 27503 | Raj | Signed
 | 2010-11-05 00:00:00 | 9.30am | 27421 | Ade | Signed
 | 2010-11-05 00:00:00 | 9.30am | 27519 | [NAME] | Failed
 | 2010-11-05 00:00:00 | 10am | 23628 | Fahmida | Failed
 | 2010-11-05 00:00:00 | 10am | 27552 | [NAME] | [NAME]
 | 2010-11-05 00:00:00 | 10am | 27558 | Asad | Failed
 | 2010-11-05 00:00:00 | 10am | 25372 | Pav | Signed
 | 2010-11-05 00:00:00 | 10am | 27554 | [NAME] | Failed
 | 2010-11-05 00:00:00 | 11am | 27559 | Pav | Failed
 | 2010-11-05 00:00:00 | 11am | 27492 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 11am | 27561 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 12pm | 27549 | Asad | Signed
 | 2010-11-05 00:00:00 | 12pm | 27521 | Pav | Signed
 | 2010-11-05 00:00:00 | 12pm | 27566 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 1pm | 27398 | [NAME] | Failed
 | 2010-11-05 00:00:00 | 2pm | 27537 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 2pm | 27568 | [NAME] | [NAME]
 | 2010-11-05 00:00:00 | 2pm | 27567 | Asad | Failed
 | 2010-11-05 00:00:00 | 3pm | 27166 | Fahmida | Passed 2 Mani
 | 2010-11-05 00:00:00 | 3.30pm | 27254 | Fahmida | Not Booked |  |  | REBOOKED
 | 2010-11-05 00:00:00 | 4pm | 19092 | Pav | Signed
 | 2010-11-05 00:00:00 | 4.30pm | 27517 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 6pm | 27590 | Asad | Re-Arranged
 | 2010-11-05 00:00:00 | 6pm | 27282 | Fahmida | Re-Arranged
 | 2010-11-05 00:00:00 | 6.30pm | 27510 | Lucas | Failed
 | 2010-11-05 00:00:00 | 7pm | 27582 | [NAME] | Signed
 | 2010-11-05 00:00:00 | 7pm | 27593 | Asad | Signed
 | 2010-11-05 00:00:00 | 7pm | 27589 | [NAME] | [NAME]
 | 2010-11-05 00:00:00 | 8pm | 27599 | Asad | [NAME]
 | 2010-11-05 00:00:00 | 8pm | 27570 | Raj | Signed
 | 2010-11-06 00:00:00 | 9am | 27251 | Fahmida | Failed
 | 2010-11-06 00:00:00 | 9am | 27545 | Raj | Signed
 | 2010-11-06 00:00:00 | 9.30am | 27485 | Fahmida | Failed
 | 2010-11-06 00:00:00 | 10.30am | 26084 | Fahmida | Failed
 | 2010-11-06 00:00:00 | 12pm | 27298 | Kiren | Signed
 | 2010-11-06 00:00:00 | 12pm | 27556 | Raj | Signed
 | 2010-11-06 00:00:00 | 1pm | 27098 | Fahmida | Failed
 | 2010-11-06 00:00:00 | 3pm | 27501 | Becky | Signed
 | 2010-11-06 00:00:00 | 3pm | 27555 | [NAME] | Failed
 | 2010-11-07 00:00:00 | 10am | 27529 | Ade | Signed
 | 2010-11-07 00:00:00 | 10.30am | 27591 | Pav | Signed
 | 2010-11-07 00:00:00 | 12pm | 27430 | [NAME] | Failed
 | 2010-11-07 00:00:00 | 2pm | 27594 | [NAME] | Not Booked
 | 2010-11-08 00:00:00 | 9.30am | 27597 | [NAME] | Signed
 | 2010-11-08 00:00:00 | 10am | 27478 | Ade | Passed 2 Mani
 | 2010-11-08 00:00:00 | 10am | 27544 | [NAME] | Signed
 | 2010-11-08 00:00:00 | 10am | 27547 | Raj | Failed
 | 2010-11-08 00:00:00 | 11am | 27571 | Pav | [NAME]
 | 2010-11-08 00:00:00 | 11am | 27578 | Raj | Re-Arranged
 | 2010-11-08 00:00:00 | 11am | 27562 | [NAME] | Signed
 | 2010-11-08 00:00:00 | 11am | 27560 | [NAME] | Failed
 | 2010-11-08 00:00:00 | 11.30am | 27535 | Pav | Failed
 | 2010-11-08 00:00:00 | 12pm | 27385 | Fahmida | Signed
 | 2010-11-08 00:00:00 | 12pm | 27464 | Kiren | Re-Arranged
 | 2010-11-08 00:00:00 | 2pm | 27506 | [NAME] | [NAME]
 | 2010-11-08 00:00:00 | 2.30pm | 24328 | Bex | Failed
 | 2010-11-08 00:00:00 | 4pm | 27546 | [NAME] | Signed
 | 2010-11-08 00:00:00 | 6pm | 27619 | Ade | Re-Arranged
 | 2010-11-08 00:00:00 | 6.30pm | 27461 | [NAME] | Failed
 | 2010-11-08 00:00:00 | 6.15pm | 27612 | Asad | Re-Arranged
 | 2010-11-08 00:00:00 | 6.30pm | 27624 | Becky | Signed
 | 2010-11-08 00:00:00 | 6.30pm | 27502 | Fahmida | Signed
 | 2010-11-08 00:00:00 | 7pm | 27512 | Ade | Signed
 | 2010-11-08 00:00:00 | 7pm | 27618 | Asad | ????
 | 2010-11-08 00:00:00 | 7pm | 27613 | [NAME] | ????
 | 2010-11-08 00:00:00 | 7pm | 27615 | Lucas | Signed
 | 2010-11-08 00:00:00 | 7.30pm | 27604 | Lucas | ????
 | 2010-11-08 00:00:00 | 8pm | 27602 | [NAME] | Signed
 | 2010-11-08 00:00:00 | 8.30pm | 27401 | Ade | ????
 | 2010-11-09 00:00:00 | 9am | 27629 | [NAME] | Signed
 | 2010-11-09 00:00:00 | 9am | 27607 | Raj | Signed
 | 2010-11-09 00:00:00 | 9.30am | 27642 | Pav | Re-Arranged
 | 2010-11-09 00:00:00 | 10am | 27575 | Pav | Failed
 | 2010-11-09 00:00:00 | 10am | 27592 | [NAME] | [NAME]
 | 2010-11-09 00:00:00 | 10am | 27572 | [NAME] | Failed
 | 2010-11-09 00:00:00 | 10.30am | 27606 | Kiren | Failed
 | 2010-11-09 00:00:00 | 10.30am | 27533 | Raj | Failed
 | 2010-11-09 00:00:00 | 10.30am | 27638 | Lucas | [NAME]
 | 2010-11-09 00:00:00 | 11am | 27576 | [NAME] | Signed
 | 2010-11-09 00:00:00 | 11am | 27608 | Pav | Failed
 | 2010-11-09 00:00:00 | 11am | 27541 | Raj | Failed
 | 2010-11-09 00:00:00 | 11am | 27580 | [NAME] | Failed
 | 2010-11-09 00:00:00 | 11am | 27236 | [NAME] | Signed
 | 2010-11-09 00:00:00 | 12pm | 27627 | Asad | Signed
 | 2010-11-09 00:00:00 | 1pm | 27617 | [NAME]
 | 2010-11-09 00:00:00 | 1.30pm | 27643 | Ade | Failed
 | 2010-11-09 00:00:00 | 2pm | 17828 | Lucas
 | 2010-11-09 00:00:00 | 2pm | 27645 | [NAME] | Signed
 | 2010-11-09 00:00:00 | 3pm | 27648 | Becky | Signed
 | 2010-11-09 00:00:00 | 3pm | 27654 | Becky | Signed
 | 2010-11-09 00:00:00 | 3pm | 27495 | [NAME] | [NAME]
 | 2010-11-09 00:00:00 | 3pm | 27230 | [NAME] | Failed
 | 2010-11-09 00:00:00 | 4pm | 27662 | [NAME] | Re-Arranged
 | 2010-11-09 00:00:00 | 4pm | 27659 | Lucas | Signed |  |  | NO ANSWER
 | 2010-11-09 00:00:00 | 4pm | 27601 | Raj | Signed
 | 2010-11-09 00:00:00 | 5pm | 27661 | [NAME] | Re-Arranged
 | 2010-11-09 00:00:00 | 5pm | 27658 | [NAME] | [NAME]
 | 2010-11-09 00:00:00 | 5.30pm | 27626 | [NAME] | Failed |  |  | NO ANSWER
 | 2010-11-09 00:00:00 | 6pm | 27644 | Asad | Failed |  |  |  | appointment 2day
 | 2010-11-09 00:00:00 | 6pm | 22301 | Pav | Failed |  |  | DROPPED
 | 2010-11-09 00:00:00 | 6.30pm | 27666 | Asad | Signed
 | 2010-11-09 00:00:00 | 6.30pm | 27663 | Becky | Failed |  |  | REBOOKED
 | 2010-11-09 00:00:00 | 6.30pm | 27563 | Ade | Not Booked
 | 2010-11-09 00:00:00 | 6.30pm | 18859 | [NAME] | Failed |  |  | REBOOKED
 | 2010-11-09 00:00:00 | 7pm | 27526 | [NAME] | Signed
 | 2010-11-09 00:00:00 | 7pm | 27520 | Lucas | Failed
 | 2010-11-09 00:00:00 | 7pm | 27636 | Asad | Re-Arranged
 | 2010-11-09 00:00:00 | 7.30pm | 27500 | Lucas | Failed
 | 2010-11-09 00:00:00 | 7.30pm | 27640 | Ade | Failed |  |  | REBOOKED
 | 2010-11-09 00:00:00 | 8.30pm | 22606 | Pav | Signed
 | 2010-11-10 00:00:00 | 9am | 27254 | Raj | Failed
 | 2010-11-10 00:00:00 | 9.30am | 27642 | Pav | Signed
 | 2010-11-10 00:00:00 | 10am | 27650 | Ade | Failed
 | 2010-11-10 00:00:00 | 10am | 27654 | Kiren | Signed
 | 2010-11-10 00:00:00 | 10am | 27667 | Pav | Signed
 | 2010-11-10 00:00:00 | 11am | 27656 | [NAME] | Failed
 | 2010-11-10 00:00:00 | 11am | 27282 | Pav | Signed |  |  |  | [NAME] ADDED
 | 2010-11-10 00:00:00 | 11.30am | 27669 | Ade | Signed
 | 2010-11-10 00:00:00 | 11.30am | 27511 | Raj | Failed
 | 2010-11-10 00:00:00 | 11.30am | 27669 | Ade | Signed
 | 2010-11-10 00:00:00 | 12pm | 27620 | Lucas | [NAME]
 | 2010-11-10 00:00:00 | 12pm | 27578 | [NAME] | Failed
 | 2010-11-10 00:00:00 | 1pm | 27670 | [NAME] | Signed
 | 2010-11-10 00:00:00 | 2pm | 27682 | Asad | Re-Arranged
 | 2010-11-10 00:00:00 | 2pm | 17828 | Raj | Failed
 | 2010-11-10 00:00:00 | 2pm | 25247 | Asad | Signed
 | 2010-11-10 00:00:00 | 2.30pm | 27680 | [NAME] | Failed
 | 2010-11-10 00:00:00 | 3pm | 27495 | Raj | Failed
 | 2010-11-10 00:00:00 | 3.30pm | 27665 | Pav | Signed
 | 2010-11-10 00:00:00 | 3.30pm | 27571 | Pav | [NAME]
 | 2010-11-10 00:00:00 | 4pm | 27567 | Raj | Re-Arranged
 | 2010-11-10 00:00:00 | 4pm | 27475 | Raj | Failed
 | 2010-11-10 00:00:00 | 4.30pm | 27689 | [NAME] | Signed
 | 2010-11-10 00:00:00 | 5.30pm | 20116 | Lucas | Failed
 | 2010-11-10 00:00:00 | 6pm | 27581 | [NAME] | Failed
 | 2010-11-10 00:00:00 | 6pm | 18912 | Pav | Signed |  |  |  | PAV - RESOLD
 | 2010-11-10 00:00:00 | 6pm | 27652 | Raj | ????
 | 2010-11-10 00:00:00 | 6pm | 27681 | Asad | Failed
 | 2010-11-10 00:00:00 | 6.30pm | 27703 | [NAME] | Signed
 | 2010-11-10 00:00:00 | 6.30pm | 27510 | [NAME] | Failed
 | 2010-11-10 00:00:00 | 6.30pm | 20094 | [NAME] | ????
 | 2010-11-10 00:00:00 | 7pm | 27685 | [NAME] | Not Booked
 | 2010-11-10 00:00:00 | 7pm | 27704 | Asad | Signed
 | 2010-11-10 00:00:00 | 7pm | 27702 | [NAME] | Signed
 | 2010-11-10 00:00:00 | 7pm | 27677 | [NAME] | [NAME]
 | 2010-11-10 00:00:00 | 7pm | 27675 | Lucas | Signed
 | 2010-11-10 00:00:00 | 7.30pm | 27691 | Lucas | Re-Arranged
 | 2010-11-10 00:00:00 | 7.30pm | 27473 | Fahmida | Signed
 | 2010-11-10 00:00:00 | 8pm | 27694 | [NAME] | Re-Arranged
 | 2010-11-10 00:00:00 | 9pm | 27708 | Asad | Re-Arranged
 | 2010-11-10 00:00:00 | 9pm | 27389 | Raj | Re-Arranged