Spreadsheet: 121145d1315864499-stop-duplicates-with-datavalidation-if-entered-by-a-formula-didb
Sheet: Sheet3

 | Day |  | Monday |  | Num | Venue | Company Name | Description | Pax | Status | Contact Name | Contact Number | Notes |  |  |  | E-Mail | Rate | Extra | Basic Rate | Total |  | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday
 | Date |  | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-02 00:00:00 | 1900-01-03 00:00:00 | 1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00 | 1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00 | 1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00 | 1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00
 | Conference 1 |  |  |  | 1 | Conference 1 | Clearmark | Conf (Gov) FD | 100 | Completed | Henk | [PHONE] |  |  |  |  | [EMAIL] | 375 | 10000 | 15000
 | Pax |  |  |  | 2 | Conference 3 | Bulls | Conf (Corp) FD | 50 | Completed | Nadia | 0123456 |  |  |  |  | [EMAIL] | 200 | 5000 | 15000
 | Rate |  |  |  | 3 | Conference 2 | DIDB | Conf (Gov) HD | 15 | Quotation | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 375 | 6000 | 15000
 | Contact Name |  |  |  | 4 | Conference 4 | [NAME] | Conf (Corp) HD | 20 | Confirmed | Christie | [PHONE] |  |  |  |  | [EMAIL] | 450 | 5000 | 15000
 | Contact Number |  |  |  | 5 | Banquet 1 | Nokia | Wedding | 60 | Provisional | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 450 | 3500 | 15000
 | Description |  |  |  | 6 | Chapel | DTI | Wedding | 250 | Completed | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 275 | 2500 | 15000
 | Conference 2 |  |  |  | 7 | Banquet 2 | LG | Function | 5 | Provisional | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 375 | 4500 | 15000
 | Pax |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Rate |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Name |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Number |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Description |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Conference 3 |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Pax |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Rate |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Name |  |  |  | 16
 | Contact Number |  |  |  | 17
 | Description |  |  |  | 18
 | Conference 4 |  |  |  | 19
 | Pax |  |  |  | 20
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Banquet 1
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Banquet 2
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Chapel
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Chapel (15h00)
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Chapel (17h00)
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Board Room
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Gazebo
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Transport
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description