Spreadsheet: 538190d1505447210-pulling-unique-data-from-a-table-a-certain-number-of-times-advanced-s666v2-interpretting-data
Sheet: Source Data

Source Data
 |  |  | Job 1 |  |  | Job 2 |  |  | Job 3
Datestamp | Name | Payable Hours | Job 1 | Code 1 | Hours | Job 2 | Code 2 | Hours | Job 3 | Code 3 | Hours
July | [NAME] | 10.5 |  |  | 10.5
July | Jury [NAME] | 10.5 | 252 - Kay Rd Cut-down |  | 8 | 250 - 132 Kay Rd Subdivision |  | 2.5
July | Jury [NAME] | 10.5 | 247 - Dixon Stage 5 |  | 3 | 250 - 132 Kay Rd Subdivision |  | 7.5
July | [NAME] | 10.5 | 250 - 132 Kay Rd Subdivision |  | 9.5 | 252 - Kay Rd Cut-down |  | 0.5
July | Jury [NAME] | 8.67 | 250 - 132 Kay Rd Subdivision |  | 8.67
July | [NAME] | 8.75 | 250 - 132 Kay Rd Subdivision |  | 8.75
July | [NAME] | 6.5 | 250 - 132 Kay Rd Subdivision |  | 6.5
July | Jury [NAME] | 6.5 | 250 [NAME] |  | 6.5
July | [NAME] | 10.5 | 253 - 116 Kay Rd Subdivision |  | 8 | 253 - 116 Kay Rd Subdivision |  | 2
July | Jury [NAME] | 11.25 | 252 - Kay Rd Cut-down | 02-Roading | 11.25
July | Jury [NAME] | 10.25 | 252 - Kay Rd Cut-down | 03-Stormwater | 10.5 | 250 - 132 Kay Rd Subdivision | 01-Earthworks | 10.5
July | [NAME] | 10.75 | 250 - 132 Kay Rd Subdivision | 08-Other | 10.75
July | [NAME] | 10.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 2 | 253 - 116 Kay Rd Subdivision | 08-Other | 8.5
July | [NAME] | 10 | 250 - 132 Kay Rd Subdivision | 08-Other | 10
July | [NAME] | 10.75 | 250 - 132 Kay Rd Subdivision | 08-Other | 10.75
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision | 07-Environmental | 3 | 247 - Dixon Stage 5 | 05-Water | 6
July | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 08-Other | 8.5
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 9
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8
August | [NAME] | 8.25 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 8.25
August | [NAME] | 8.25 | 001 - Office | 08-Other | 1 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 7.25
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8.5
August | [NAME] | 9.5 | 250 - 132 Kay Rd Subdivision | 02-Roading | 9.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 08-Other | 8.5
August | [NAME] | 10 | 250 - 132 Kay Rd Subdivision | 02-Roading | 10
August | [NAME] | 8.75 | 250 - 132 Kay Rd Subdivision | 08-Other | 8.75
August | Jury [NAME] | 8.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8.75
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 08-Other | 8.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 08-Other | 8.5
August | Jury [NAME] | 8.33 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8.33
August | [NAME] | 3 | 250 - 132 Kay Rd Subdivision | 02-Roading | 3
August | Jury [NAME] | 5.5 | 250 - 132 Kay Rd Subdivision | 02-Roading | 4 | 001 - Office | 08-Other | 1.5
August | [NAME] | 5.5 | 257 - Bridge Repairs | 08-Other | 5.5
August | Jury [NAME] | 6.25 | 250 - 132 Kay Rd Subdivision | 02-Roading | 2 | 001 - Office | 08-Other | 4.25
August | [NAME] | 6.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 2.5 | 257 - Bridge Repairs | 08-Other | 4.25
August | [NAME] | 6.5 | 250 - 132 Kay Rd Subdivision | 08-Other | 1.5 | 257 - Bridge Repairs | 08-Other | 5
August | [NAME] | 7.25 | 250 - 132 Kay Rd Subdivision | 02-Roading | 7.25
August | Jury [NAME] | 7 | 250 - 132 Kay Rd Subdivision | 08-Other | 4 | 001 - Office | 08-Other | 3
August | [NAME] | 7.5 | 247 - Dixon Stage 5 | 08-Other | 2.5 | 001 - Office | 08-Other | 5
August | [NAME] | 4.5 | 001 - Office | 08-Other | 4.5
August | Jury [NAME] | 7 | 001 - Office | 08-Other | 7
August | [NAME] | 7.25 | 257 - Bridge Repairs | 08-Other | 1 | 001 - Office | 08-Other | 6.25
August | [NAME] | 7 | 001 - Office | 08-Other | 7
August | [NAME] | 7.75 | 250 - 132 Kay Rd Subdivision | 07-Environmental | 5 | 252 - Kay Rd Cut-down | 02-Roading | 2.75
August | Jury [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 02-Roading | 4 | 252 - Kay Rd Cut-down | 02-Roading | 3.5 | 247 - Dixon Stage 5 | 08-Other | 1
August | [NAME] | 8.5 | 001 - Office | 08-Other | 5 | 250 - 132 Kay Rd Subdivision | 08-Other | 3.5
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision | 02-Roading | 6 | 247 - Dixon Stage 5 | 08-Other | 3
August | [NAME] | 8.75 | 257 - Bridge Repairs | 08-Other | 8.75
August | Jury [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 7.5
August | [NAME] | 7.75 | 257 - Bridge Repairs | 07-Environmental | 7.75
August | [NAME] | 7.75 | 257 - Bridge Repairs | 08-Other | 7.75
August | [NAME] | 8.75 | 257 - Bridge Repairs | 08-Other | 8.75
August | [NAME] | 7 | 250 - 132 Kay Rd Subdivision | 02-Roading | 7
August | Jury [NAME] | 7.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 7.75
August | [NAME] | 8.75 | 257 - Bridge Repairs | 08-Other | 8.75
August | Jury [NAME] | 7.25 | 250 - 132 Kay Rd Subdivision | 09-Other | 6 | 252 - Kay Rd Cut-down | 02-Roading | 1.25
August | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 7.5
August | [NAME] | 7.5 | 252 - Kay Rd Cut-down | 02-Roading | 3 | 250 - 132 Kay Rd Subdivision | 09-Other | 4.5
August | [NAME] | 7.25 | 250 - 132 Kay Rd Subdivision | 09-Other | 7.25 |  | 0
August | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 7.5
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8
August | [NAME] | 8.5 | 252 - Kay Rd Cut-down | 02-Roading | 4 | 250 - 132 Kay Rd Subdivision | 02-Roading | 4.5
August | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision |  | 7.5
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 8 | 252 - Kay Rd Cut-down | 02-Roading | 2 | 250 - 132 Kay Rd Subdivision | 02-Roading | 6
August | Jury [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 7 | 250 - 132 Kay Rd Subdivision | 01-Earthworks | 7
August | [NAME] | 8 | 252 - Kay Rd Cut-down | 02-Roading | 2.5 | 253 - 116 Kay Rd Subdivision | 07-Environmental | 5.5
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 8
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8.5
August | Jury [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 02-Roading | 8
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision | 02-Roading | 9
August | Jury [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 8.5
August | [NAME] | 8.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 5.75 | 257 - Bridge Repairs | 09-Other | 3
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 8.5
August | Jury [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August |  | 9.5 | 250 - 132 Kay Rd Subdivision | 08-Variation | 9.5
August | [NAME] | 11.5 | 257 - Bridge Repairs | 09-Other | 11.5
August | [NAME] | 9.25 | 247 - Dixon Stage 5 | 07-Environmental | 5.5 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 3.75
August | [NAME] | 8.75 | 250 - 132 Kay Rd Subdivision | 09-Other | 8.75
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 8.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision | 08-Variation | 4 | 257 - Bridge Repairs | 08-Variation | 4.5
August | [NAME] | 10.75 | 257 - Bridge Repairs | 09-Other | 10.75
August | [NAME] | 10 | 247 - Dixon Stage 5 | 09-Other | 6 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 4
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision | 09-Other | 8
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision |  | 3 | 247 - Dixon Stage 5 |  | 6
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 8 | 257 - Bridge Repairs |  | 6 | 001 - Office |  | 1 | 250 - 132 Kay Rd Subdivision |  | 1
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision |  | 8 | 001 - Office |  | 1
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision |  | 7.5
August | [NAME] | 8 | 250 - 132 Kay Rd Subdivision |  | 8
August | [NAME] | 5 | 250 - 132 Kay Rd Subdivision |  | 5
August | [NAME] | 5 | 250 - 132 Kay Rd Subdivision |  | 5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 8.5 | 250 - 132 Kay Rd Subdivision |  | 8.5
August | [NAME] | 8.25 | 250 - 132 Kay Rd Subdivision |  | 8.25
August | [NAME] | 8.25 | 250 - 132 Kay Rd Subdivision |  | 8.25
August | [NAME] | 5 | 257 - Bridge Repairs |  | 5
August | [NAME] | 5 | 257 - Bridge Repairs |  | 5
August | [NAME] | 6.5 | 257 - Bridge Repairs |  | 6.5
August | [NAME] | 6.5 | 250 - 132 Kay Rd Subdivision |  | 6.5
August | [NAME] | 7 | 250 - 132 Kay Rd Subdivision | 08-Other | 4 | 001 - Office | 08-Other | 3
August | [NAME] | 7 | 250 - 132 Kay Rd Subdivision |  | 7
August | [NAME] | 4.5 | 001 - Office |  | 4.5
August | [NAME] | 9 | 250 - 132 Kay Rd Subdivision |  | 9
August | [NAME] | 7.75 | 257 - Bridge Repairs |  | 7.75
August | [NAME] | 8.75 | 257 - Bridge Repairs |  | 8.75
August | [NAME] | 7.25 | 250 - 132 Kay Rd Subdivision |  | 7.25
August | Jury [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 7.5
August | [NAME] | 9.25 | 257 - Bridge Repairs | 09-Other | 9.25
August | [NAME] | 9 | 257 - Bridge Repairs | 09-Other | 9
August | [NAME] | 9 | 257 - Bridge Repairs | 06-Concrete | 9
August | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 7.5
August | Jury [NAME] | 6.25 | 257 - Bridge Repairs | 09-Other | 6.25
August | [NAME] | 11.25 | 257 - Bridge Repairs | 09-Other | 11.25
August | [NAME] | 10.25 | 257 - Bridge Repairs | 08-Variation | 10.25
August | [NAME] | 11.25 | 257 - Bridge Repairs | 09-Other | 11.25
August | [NAME] | 8.5 | 257 - Bridge Repairs | 09-Other | 8.5
August | [NAME] | 7.17 | 257 - Bridge Repairs | 09-Other | 7.17
August | [NAME] | 6 | 250 - 132 Kay Rd Subdivision | 09-Other | 6
August | [NAME] | 7 | 250 - 132 Kay Rd Subdivision | 02-Roading | 7
August | Jury [NAME] | 8.5 | 257 - Bridge Repairs | 09-Other | 2 | 250 - 132 Kay Rd Subdivision | 02-Roading | 6.5
August | [NAME] | 8.5 | 257 - Bridge Repairs | 09-Other | 8.5
August | [NAME] | 4.25 | 258 - Blackwood RoW | 05-Water | 4.25
August | [NAME] | 6.5 | 258 - Blackwood RoW | 09-Other | 6.5
August | [NAME] | 6 | 258 - Blackwood RoW | 09-Other | 6
August | [NAME] | 7 | 258 - Blackwood RoW | 05-Water | 7
August | [NAME] | 10.5 | 258 - Blackwood RoW | 09-Other | 10.5
August | Jury [NAME] | 10.5 | 258 - Blackwood RoW | 08-Variation | 10.5
August | [NAME] | 7.5 | 258 - Blackwood RoW | 09-Other | 7.5
August | [NAME] | 10.25 | 258 - Blackwood RoW | 09-Other | 10.25
August | [NAME] | 10.5 | 258 - Blackwood RoW | 01-Earthworks | 10.5
August | [NAME] | 10.5 | 258 - Blackwood RoW | 09-Other | 10.5
September | [NAME] | 5.5 | 258 - Blackwood RoW | 09-Other | 2 | 252 - Kay Rd Cut-down | 09-Other | 3.5
September | [NAME] | 9.5 | 258 - Blackwood RoW | 09-Other | 9.5
September | [NAME] | 9.5 | 258 - Blackwood RoW | 01-Earthworks | 9.5
September | [NAME] | 9.5 | 252 - Kay Rd Cut-down | 02-Roading | 3 | 258 - Blackwood RoW | 09-Other | 6.5
September | Jury [NAME] | 9.5 | 258 - Blackwood RoW | 08-Variation | 9.5
September | [NAME] | 7 | 252 - Kay Rd Cut-down | 02-Roading | 3 | 258 - Blackwood RoW | 09-Other | 4
September | Jury [NAME] | 7.75 | 258 - Blackwood RoW | 09-Other | 7.75
September | [NAME] | 8.25 | 258 - Blackwood RoW | 05-Water | 8.25
September | [NAME] | 7.75 | 258 - Blackwood RoW | 09-Other | 7.75
September | [NAME] | 8.5 | 258 - Blackwood RoW | 09-Other | 5 | 256 - Beale Street | 09-Other | 3.5
September | [NAME] | 7.75 | 258 - Blackwood RoW | 09-Other | 7.75
September | [NAME] | 9 | 258 - Blackwood RoW | 02-Roading | 9
September | Jury [NAME] | 11.5 | 258 - Blackwood RoW | 09-Other | 11.5
September | [NAME] | 11.5 | 258 - Blackwood RoW | 08-Variation | 11.5
September | [NAME] | 10 | 258 - Blackwood RoW | 09-Other | 10
September | [NAME] | 10 | 258 - Blackwood RoW | 09-Other | 10
September | Jury [NAME] | 10.25 | 258 - Blackwood RoW | 02-Roading | 10.25
September | [NAME] | 4.5 | 258 - Blackwood RoW | 09-Other | 4.5
September | [NAME] | 10.25 | 250 - 132 Kay Rd Subdivision | 09-Other | 7 | 258 - Blackwood RoW | 09-Other | 3.25
September | [NAME] | 9.5 | 258 - Blackwood RoW | 02-Roading | 9.5
September | [NAME] | 10.25 | 253 - 116 Kay Rd Subdivision | 09-Other | 5 | 258 - Blackwood RoW | 02-Roading | 5.25
September | Jury [NAME] | 10 | 258 - Blackwood RoW | 02-Roading | 10
September | [NAME] | 8 | 258 - Blackwood RoW | 02-Roading | 8
September | [NAME] | 9.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 7 | 258 - Blackwood RoW | 09-Other | 2.5
September | [NAME] | 10 | 258 - Blackwood RoW | 02-Roading | 10
September | [NAME] | 9.5 | 258 - Blackwood RoW | 02-Roading | 9.5
September | [NAME] | 7.5 | 001 - Office/Yard | 10-Meeting | 7.5
September | [NAME] | 4 | 258 - Blackwood RoW | 09-Other | 2 | 001 - Overheads | 09-Other | 2
September | [NAME] | 9.75 | 250 - 132 Kay Rd Subdivision | 09-Other | 2 | 258 - Blackwood RoW | 09-Other | 7.75
September | [NAME] | 9.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 2.5 | 258 - Blackwood RoW | 04-Sewer | 7.25
September | [NAME] | 10.25 | 258 - Blackwood RoW | 04-Sewer | 4 | 250 - 132 Kay Rd Subdivision | 09-Other | 2 | 001 - Overheads | 001 - Offsite Expenses | 4.25
September | Jury [NAME] | 9.75 | 250 - 132 Kay Rd Subdivision | 02-Roading | 3 | 258 - Blackwood RoW | 04-Sewer | 6.75
September | [NAME] | 5.75 | 252 - Kay Rd Cutdown | 09-Other | 3.5 | 250 - 132 Kay Rd Subdivision |  | 2.25
September | [NAME] | 8 | 252 - Kay Rd Cutdown | 02-Roading | 7 | 250 - 132 Kay Rd Subdivision
September | [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 7.5
September | Jury [NAME] | 7.5 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 7.5
September | [NAME] | 9.75 | 258 - Blackwood RoW | 04-Sewer | 9.75
September | [NAME] | 7.5 | 258 - Blackwood RoW | 02-Roading | 3 | 250 - 132 Kay Rd Subdivision |  | 4.5
September | [NAME] | 7.5 | 258 - Blackwood RoW | 09-Other | 3 | 253 - 116 Kay Rd Subdivision |  | 4.5
September | [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 11
September | [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 09-Other | 11
September | [NAME] | 8 | 252 - Kay Rd Cutdown | 02-Roading | 3 | 250 - 132 Kay Rd Subdivision |  | 5
September | [NAME] | 9 | 250 - 132 Kay Rd Subdivision | 02-Roading | 9
September | [NAME] | 11 | 253 - 116 Kay Rd Subdivision | 03-Stormwater | 11
September | Jury [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 11
September | [NAME] | 11 | 253 - 116 Kay Rd Subdivision | 03-Stormwater | 11
September | [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 06-Concrete | 11
September | Jury [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 11
September | [NAME] | 11 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 11
September | [NAME] | 10.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 10.5
September | [NAME] | 9.5 | 253 - 116 Kay Rd Subdivision | 03-Stormwater | 9.5
September | Elijah Graham | 8 | 252 - Kay Rd Cutdown | 03-Stormwater | 1.5 | 257 - Bridge Repairs |  | 6.5
September | [NAME] | 10.25 | 250 - 132 Kay Rd Subdivision | 03-Stormwater | 5 | 258 - Blackwood RoW |  | 5.25
September | [NAME] | 9.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 9.5
September | [NAME] | 10.5 | 250 - 132 Kay Rd Subdivision | 09-Other | 9.5 | 252 - Kay Rd Cutdown |  | 1
September | Jury [NAME] | 9.75 | 258 - Blackwood RoW | 04-Sewer | 9.75
September | [NAME] | 11 | 258 - Blackwood RoW | 04-Sewer | 11
September | [NAME] | 5 | 258 - Blackwood RoW | 02-Roading | 5
September | [NAME] | 11 | 253 - 116 Kay Rd Subdivision | 03-Stormwater | 11
September | Jury [NAME] | 5.5 | 258 - Blackwood RoW | 02-Roading | 5.5