Spreadsheet: 42385d1240953576-if-cell-x-0-then-copy-range-of-cells-test-book111
Sheet: Sheet1

 |  | Ref no |  | 987654321 | Ref no 2 |  | 123456789
 |  | Pest type |  | Rats | Job Type |  | One Of Treatment
 |  | Invioce Address |  |  |  |  |  |  | Site Address
 |  | Contact name |  | mr smith |  |  |  |  | Site Contact
 |  | Client: |  | a company |  |  |  |  | Client:
 |  | Address: |  | 11 brookbond st |  |  |  |  | Site Address:
 |  | Address: |  | town |  |  |  |  | Site Address:
 |  | Address: |  | district |  |  |  |  | Site Address:
 |  | Postcode |  | wt3 8hy |  |  |  |  | Site Postcode
 |  | [NAME] |  | 213654789 |  |  |  |  | Site Tel
 |  |  |  | Add materials and labour per visit then enter total number of visits
 |  | Rodent control materials |  |  |  |  |  |  | Insect Control Materials
 |  | Ref | Qty | Description | Price | Order | Total |  | Ref | Qty | Description | Price | Order | Total
1 |  | 1 | 2.5 | item 1 | 25 | 2 | 20 |  | 11111 | 12 | other Item 1 | 26.76 | 0 | 0 |  | 6
2 |  | 2 | 7.5 | item 2 | 50 | 3 | 20 |  | 22222 | 1 | other Item 2 | 31.82 | 0 | 0 |  | 6
3 |  | 3 | 10 | item 3 | 50 | 4 | 20 |  | 33333 | 1 | other Item 3 | 6.6 | 0 | 0 |  | 6
4 |  | 4 | 25 | item 4 | 100 | 5 | 20 |  | 44444 | 1 | other Item 4 | 18.62 | 0 | 0 |  | 6
5 |  | 5 | 25 | item 5 | 100 | 25 | 100 |  | 55555 | 1 | other Item 5 | 43.84 | 0 | 0 |  | 6
5 |  | 6 | 11 | item 6 | 10 | 0 | 0 |  | 66666 | 22 | other Item 6 | 11 | 0 | 0 |  | 6
5 |  | 7 | 12 | item 7 | 20 | 0 | 0 |  | 77777 | 23 | other Item 7 | 12 | 2 | 1.043478260869565 |  | 7
5 |  | 8 | 13 | item 8 | 30 | 0 | 0 |  | 88888 | 24 | other Item 8 | 13 | 0 | 0 |  | 7
5 |  | 9 | 14 | item 9 | 40 | 0 | 0 |  | 99999 | 25 | other Item 9 | 14 | 0 | 0 |  | 7
6 |  | 10 | 15 | item 10 | 50 | 10 | 33.33333333333334 |  | 111110 | 26 | other Item 10 | 15 | 0 | 0 |  | 7
6 |  | 11 | 16 | item 11 | 60 | 0 | 0 |  | 122221 | 27 | other Item 11 | 16 | 0 | 0 |  | 7
6 |  | 12 | 17 | item 12 | 70 | 0 | 0 |  | 133332 | 28 | other Item 12 | 17 | 0 | 0 |  | 7
6 |  | 13 | 18 | item 13 | 80 | 0 | 0 |  | 144443 | 29 | other Item 13 | 18 | 0 | 0 |  | 7
6 |  | 14 | 19 | item 14 | 90 | 0 | 0 |  | 155554 | 30 | other Item 14 | 19 | 0 | 0 |  | 7
6 |  | 15 | 20 | item 15 | 100 | 0 | 0 |  | 166665 | 31 | other Item 15 | 20 | 5 | 3.225806451612903 |  | 8
6 |  | 16 | 21 | item 16 | 110 | 0 | 0 |  | 177776 | 32 | other Item 16 | 21 | 0 | 0 |  | 8
6 |  | 17 | 22 | item 17 | 120 | 0 | 0 |  | 188887 | 33 | other Item 17 | 22 | 0 | 0 |  | 8
6 |  | 18 | 23 | item 18 | 130 | 0 | 0 |  | 199998 | 34 | other Item 18 | 23 | 0 | 0 |  | 8
6 |  | 19 | 24 | item 19 | 140 | 0 | 0 |  | 211109 | 35 | other Item 19 | 24 | 0 | 0 |  | 8
6 |  | 20 | 25 | item 20 | 150 | 0 | 0 |  | 222220 | 36 | other Item 20 | 25 | 0 | 0 |  | 8
6 |  | 21 | 26 | item 21 | 160 | 0 | 0 |  | 233331 | 37 | other Item 21 | 26 | 0 | 0 |  | 8
6 |  | 22 | 27 | item 22 | 170 | 0 | 0 |  | 244442 | 38 | other Item 22 | 27 | 0 | 0 |  | 8
 |  |  |  | Rodent Materials Total |  |  | 213.3333333333333 |  |  |  | Insect Materials Total |  |  | 4.269284712482468
 |  | Labour Per Visit |  |  |  |  |  |  |  |  | Visits
 |  | Number of Men |  | Number of Hrs | [NAME] |  | Total Hrs |  |  | Total No Of Visits |  | 1
 |  | 2 |  | 1 | 10 |  | 2
 |  |  |  | Total Labour Cost |  |  | 20
 |  |  |  | Total Materials Cost |  |  | 217.6026180458158
 |  |  |  | Sub Total |  |  | 237.6026180458158
 |  |  |  | VAT @ | 15 | % | 35.64039270687238
 |  |  |  | Total |  |  | 273.2430107526882
 |  |  |  |  |  | Additional Details
 |  | this is some test text to see if it tranfers to the job sheet
 |  |  |  |  |  |  |  |  | Rats |  | Annual Contract
 |  |  |  |  |  |  |  |  | Mice |  | Short Term Contract
 |  |  |  |  |  |  |  |  | Cockroaches |  | One Of Treatment
 |  |  |  |  |  |  |  |  | Ants |  | Additional Treatment
 |  |  |  |  |  |  |  |  | Wasps