Spreadsheet: 883323d1731936915-dynamic-drop-down-using-tables-testworkbook-alexhen-
Sheet: Job Details

Job Details | JobNumber | Date | Payment Status | Activity Number | Activity Description | Materials Cost | Labour Estimate | Details | Actual Labour | Activity Status
Job-100001 - Cust No:100001 - Fred Head : - Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] |  |  |  | 1 | Fix | 0 | 2.5 | Scalpings - 3 off [NAME] Gravel - 2.5cm  7 off [NAME] off 200mm x 25mm x 3.6m |  | Completed
Job-100001 - Cust No:100001 - Fred Head : - Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] |  |  |  | 2 | Make | 0 | 2 | Sleepers - 36 off [NAME] Lining - 25m Soil - 4 off Bulk Bags |  | Ongoing
Job-100001 - Cust No:100001 - Fred Head : - Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] |  |  |  | 3 | Repair | 0 | 1.5 | Post Mix - 3 bags Cement - 1 bag Builders Sand - 5 bags Slabs - 900mm x 900mm - 5 off |  | Ongoing
Job-100001 - Cust No:100001 - Fred Head : - Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] |  |  |  | 4 | Put up | 0 | 1 | Post Mix - 2 bags Posts - 3 off Fence Panel |  | Planned
Job-100002 - Cust No:100002 - [NAME] Remove Bath and Install Shower |  |  |  | 1 | Take Down | 0 | 1 | [NAME] Prep Walls |  | Completed
Job-100002 - Cust No:100002 - [NAME] Remove Bath and Install Shower |  |  |  | 2 | Install | 0 | 2 | [NAME] Install Plumbing |  | Completed
Job-100002 - Cust No:100002 - [NAME] Remove Bath and Install Shower |  |  |  | 3 | Tile | 0 | 1 | [NAME] |  | Completed
Job-100002 - Cust No:100002 - [NAME] Remove Bath and Install Shower |  |  |  | 4 | Carpet | 0 | 0.5 | [NAME] |  | Completed
[NAME] mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate |  |  |  | 1 | Eject |  | 0.25 | Wire wool into gaps and wire to cover |  | Completed
[NAME] mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate |  |  |  | 2 | Repair | 0 | 0.1 | Add membrane under slates |  | Completed
[NAME] mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate |  |  |  | 3 | Install | 5.13 | 0.6 | Dig holes. Level. Fix fences and gate furniture |  | Completed
Job-100004 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 1 | Remove cupboard | 0 | 0.4 | Remove cupboard from bedroom |  | Completed
Job-100004 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 2 | Remove door | 0 | 0.8 | Remove panelling from door. Potentially fit new timber |  | Completed
Job-100004 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 3 | Repair Door | 0 | 0.5 | Backfill old light holes and make good |  | Completed
Job-100004 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 4 | Fix Door | 0 | 0.8 | [NAME] |  | Completed
Job-100004 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 5 | Install | 0 | 0.3 | Assemble IKEA table |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 1 | Tile | 0 | 0.8 | Make partition using available materials |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 2 | Carpet | 0 | 0.1 | Hang Picture in bathroom |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 3 | Eject | 0 | 0.5 | Fix skirting and make good |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 4 | Repair | 0 | 0.1 | Fix to specified locations |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 5 | Install | 0 | 0.2 | Remove old baton from ceiling, Make good and secure new rail to wall |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 6 | Remove cupboard | 0 | 0.4 | Fit edging to bathroom floor |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 7 | Remove door | 0 | 0.2 | Fix to wall using drywall fixings |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 8 | Repair Door | 0 | 0.2 | [NAME] |  | Completed
Job-100005 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 9 | Fix Door | 0 | 0.2 | Cut, shape and sand and fit hidden brackets |  | Completed
Job-100006 - Cust No:100004 - Jason Station : - General House Improvements and fixes |  |  |  | 1 | Install | 0 | 0.6 | Cut, shape, fix batons and install |  | Planned