Spreadsheet: 681564d1591636658-index-a-datasheet-to-create-an-invoice-using-1-criterion-test_data_3
Sheet: DataSheet

SITE NUMBER | SITE NAME | HOUSE TYPE | COLOUR | BRICK PRICE | Month Invoiced | CONGRETE PRICE | Month Invoiced | CEMENT PRICE | Month Invoiced | SAND PRICE | Month Invoiced | GARAGE NAME | GARAGE PRICE | Month Invoiced | LEAD PRICE | Month Invoiced | ANCILLARY WORKS | Month Invoiced | DAY WORKS | Month Invoiced | YEARLY INCREASE 1 | Month Invoiced | YEARLY INCREASE 2 | Month Invoiced | YEARLY INCREASE 3 | Month Invoiced
1 | Birmingham | Detached | Red | 10500 |  | 1000 |  | 500 | 2020-10-01 00:00:00 | 150 | 2020-10-01 00:00:00 | Double | 5000 | 2020-01-01 00:00:00 | 1000 | 2020-03-01 00:00:00 | 858 | 2020-12-01 00:00:00 | 250 | 2020-01-01 00:00:00 | 250 | 2020-01-01 00:00:00 | 275 | 2020-07-01 00:00:00 | 258 | 2020-07-01 00:00:00
2 | Norfolk | Semi | Amber | 7500 |  | 700 |  | 300 | 2020-10-01 00:00:00 | 100 | 2020-10-01 00:00:00 | Single | 2500 |  | 750 |  | 655 |  | 125 |  | 125 |  | 265 |  | 215
3 | Solihull | Semi | Grey | 7500 | 2020-08-01 00:00:00 | 700 | 2020-06-01 00:00:00 | 300 | 2020-07-01 00:00:00 | 100 | 2020-08-01 00:00:00 | Single | 2500 | 2020-02-01 00:00:00 | 750 | 2020-06-01 00:00:00 | 958 | 2020-07-01 00:00:00 | 124 | 2020-07-01 00:00:00 | 250 | 2020-03-01 00:00:00 | 269 | 2020-08-01 00:00:00 | 215 | 2020-08-01 00:00:00
4 | [NAME] | Bungalow | Grey | 8000 | 2020-07-01 00:00:00 | 500 | 2020-02-01 00:00:00 | 250 | 2020-04-01 00:00:00 | 75 | 2020-12-01 00:00:00 | No garage | 0 | 2020-11-01 00:00:00 | 500 | 2020-07-01 00:00:00 | 659 | 2020-04-01 00:00:00 | 845 | 2020-08-01 00:00:00 | 125 | 2020-08-01 00:00:00 | 258 | 2020-07-01 00:00:00 | 265 | 2020-07-01 00:00:00
5 | Liverpool | Terrace | Red | 5000 | 2020-08-01 00:00:00 | 350 | 2020-07-01 00:00:00 | 125 | 2020-07-01 00:00:00 | 75 | 2020-11-01 00:00:00 | No garage | 0 | 2020-11-01 00:00:00 | 350 | 2020-07-01 00:00:00 | 215 | 2020-05-01 00:00:00 | 659 | 2020-12-01 00:00:00 | 250 | 2020-09-01 00:00:00 | 245 | 2020-08-01 00:00:00 | 875 | 2020-08-01 00:00:00
6 | [NAME] | Detached | [NAME] | 10500 | 2020-12-01 00:00:00 | 1000 | 2020-02-01 00:00:00 | 500 | 2020-04-01 00:00:00 | 150 | 2020-11-01 00:00:00 | Triple | 7000 | 2020-12-01 00:00:00 | 1000 | 2020-08-01 00:00:00 | 526 | 2020-08-01 00:00:00 | 215 | 2020-11-01 00:00:00 | 150 | 2020-10-01 00:00:00 | 263 | 2020-12-01 00:00:00 | 458 | 2020-12-01 00:00:00
7 | Leeds | Semi | Red | 7500 | 2020-07-01 00:00:00 | 700 | 2020-06-01 00:00:00 | 300 | 2020-09-01 00:00:00 | 100 | 2020-12-01 00:00:00 | Single | 2500 | 2020-01-01 00:00:00 | 750 | 2020-08-01 00:00:00 | 826 | 2020-07-01 00:00:00 | 845 | 2020-03-01 00:00:00 | 200 | 2020-01-01 00:00:00 | 248 | 2020-07-01 00:00:00 | 514 | 2020-07-01 00:00:00
8 | Edinburgh | Semi | Red | 7500 | 2020-11-01 00:00:00 | 700 | 2020-07-01 00:00:00 | 300 | 2020-10-01 00:00:00 | 100 | 2020-09-01 00:00:00 | Single | 2500 | 2020-01-01 00:00:00 | 750 | 2020-01-01 00:00:00 | 261 | 2020-07-01 00:00:00 | 5169 | 2020-07-01 00:00:00 | 175 | 2020-09-01 00:00:00 | 216 | 2020-11-01 00:00:00 | 958 | 2020-11-01 00:00:00
9 | Southampton | Bungalow | Red | 8000 | 2020-07-01 00:00:00 | 500 | 2020-09-01 00:00:00 | 250 | 2020-12-01 00:00:00 | 75 | 2020-11-01 00:00:00 | Single | 2000 | 2020-07-01 00:00:00 | 500 | 2020-01-01 00:00:00 | 236 | 2020-02-01 00:00:00 | 2156 | 2020-07-01 00:00:00 | 185 | 2020-10-01 00:00:00 | 259 | 2020-07-01 00:00:00 | 514 | 2020-07-01 00:00:00
10 | Plymouth | Semi | Red | 7500 | 2020-01-01 00:00:00 | 700 | 2020-11-01 00:00:00 | 300 | 2020-04-01 00:00:00 | 100 | 2020-01-01 00:00:00 | Single | 2000 | 2020-08-01 00:00:00 | 750 | 2020-12-01 00:00:00 | 213 | 2020-03-01 00:00:00 | 51 | 2020-06-01 00:00:00 | 195 | 2020-11-01 00:00:00 | 256 | 2020-01-01 00:00:00 | 261 | 2020-01-01 00:00:00