Spreadsheet: 729417d1619084252-sumifs-function-seeing-the-records-that-make-up-a-result-bathrooms-project-budget-analysis-audit-of-sumifs-making-up-totals
Sheet: Invoices

Supplier | Transaction | Date | Invoice | Description | Workstream | Budget | Units | Measure | Cost Each | Amount | VAT | Total Cost | Notes
[NAME] | Expenditure | 2021-03-16 00:00:00 | 03A09810 | Screws | Sundry | [NAME]
[NAME] | Expenditure | 2021-03-16 00:00:00 | 03A09810 | Masonry nails | Wall tiling - General | [NAME] |  |  |  | 4.3
[NAME] | Expenditure | 2021-03-16 00:00:00 | 03A09810 | Cladding | Floor tiling - Family Bathroom | [NAME] | 6.6 | [NAME] | 2.961
B&Q | Expenditure |  |  | Trim for corners | Wall tiling - Both Bathrooms | [NAME] | 4 | Lengths | 5.9 |  |  | 23.6
Co-Op | Expenditure | 2021-03-15 00:00:00 |  | Non permanent marker pens | Tiling - general | [NAME] |  |  |  |  |  | 2.25
B&Q | Expenditure | 2021-03-15 00:00:00 |  | Basic Tile Cutter | Tiling - general | [NAME] |  |  |  |  |  | -50 | Return
B&Q | Expenditure | 2021-03-15 00:00:00 |  | Intermediate Tile Cutter | Tiling - general | [NAME] |  |  |  |  |  | 70
B&Q | Expenditure | 2021-03-13 00:00:00 | 0337 1305 130502 | Tile adhesive | Wall tiling - General | [NAME] |  |  |  |  |  | 22
B&Q | Expenditure | 2021-03-13 00:00:00 | 0337 1305 130502 | Edge angle trim | Wall tiling - Both Bathrooms | [NAME] | 4 | Lengths | 18.75 |  |  | 75
[NAME] | Committed | 2021-03-16 00:00:00 |  | Emergency help with broken pipe | [NAME] | [NAME] |  |  |  |  |  | 60 | Estimate
Axminster | Expenditure | 2021-03-19 00:00:00 |  | Abrasive sponge | Wall tiling - General | [NAME] |  |  |  |  |  | 3.98
Axminster | Expenditure | 2021-03-19 00:00:00 |  | Scraper (Starlock) | Wall tiling - General | [NAME] |  |  |  |  |  | 6.7
Axminster | Expenditure | 2021-03-19 00:00:00 |  | Sanding sheets | Wall tiling - General | [NAME] |  |  |  |  |  | 3.6
Axminster | Expenditure | 2021-03-19 00:00:00 |  | Tile drills | Wall tiling - General | [NAME] |  |  |  |  |  | 21.98
Axminster | Expenditure | 2021-03-19 00:00:00 |  | [NAME] | Sundry | [NAME] |  |  |  |  |  | 209.96
B&Q | Expenditure | 2021-04-09 00:00:00 | 0212 1305 130503 | Edge angle trim | Wall tiling - Both Bathrooms | [NAME] | 3 |  |  |  |  | -56.25 | Return
B&Q | Expenditure | 2021-04-09 00:00:00 | 0212 1305 130503 | Edge angle trim | Wall tiling - Both Bathrooms | [NAME] | 2 |  |  |  |  | -11.8 | Return
B&Q | Expenditure | 2021-04-09 00:00:00 | 0212 1305 130503 | Expanding Foam | Sunk Costs | [NAME] |  |  |  |  |  | -8.22 | Return
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Taps | Taps and Fittings | Taps, fittings etc.
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Tile adhesive | Wall tiling - General | [NAME] |  |  |  |  |  | 10.5
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Dulux Stain Blocker | Decoration | [NAME] |  |  |  |  |  | 23
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Roller | Decoration | [NAME] |  |  |  |  |  | 7
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Rolling tray | Decoration | [NAME] |  |  |  |  |  | 3.5
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Dust Sheet | Decoration | [NAME] |  |  |  |  |  | 1.73
B&Q | Expenditure | 2021-04-09 00:00:00 | 30636185 | Rawplugs | Sundry | [NAME] |  |  |  |  |  | 5.28
B&Q | Expenditure | 2021-04-15 00:00:00 | 31624103 | Wall Tiles | Extra Wall Tiles | [NAME] | 3 |  | 12 |  |  | 36
B&Q | Expenditure | 2021-04-15 00:00:00 | 31716661 | Flexible Tile Adhesive - Grey | Floor tiling - Family Bathroom |  |  |  |  |  |  | 24
B&Q | Expenditure | 2021-04-15 00:00:00 | 31716661 | Toilet Seat | Taps and Fittings |  |  |  |  |  |  | 38
B&Q | Expenditure | 2021-04-15 00:00:00 | 31716661 | Flexible Grout - Grey | Floor tiling - Family Bathroom |  |  |  |  |  |  | 16
B&Q | Expenditure | 2021-04-15 00:00:00 | 31716661 | Cistern Lever | Taps and Fittings |  |  |  |  |  |  | 5.98
B&Q | Expenditure | 2021-04-15 00:00:00 | 31716661 | Cistern Lever | Taps and Fittings |  |  |  |  |  |  | 8.45
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | [NAME] | Sunk Costs |  |  |  |  |  |  | -40.5
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | Tile Adhesive - Grey | Sunk Costs |  |  |  |  |  |  | -10.95
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | Circular cutting blade | Sunk Costs |  |  |  |  |  |  | -15.47
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | Tile Spacers | Sunk Costs |  |  |  |  |  |  | -3.99
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | [NAME] | Sunk Costs |  |  |  |  |  |  | -18
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | Sealant Smoother | Sunk Costs |  |  |  |  |  |  | -1.32
B&Q | Expenditure | 2021-04-15 00:00:00 | 30816702 | [NAME] for tiles | Sunk Costs |  |  |  |  |  |  | -4.99
Screwfix | Expenditure | 2021-04-15 00:00:00 | A7734589868 | Speedfit Tap Connector | Taps and Fittings |  |  |  |  |  |  | 5.87
Toolstation | Expenditure | 2021-04-15 00:00:00 | QA4652783873 | Pipe Collars | Taps and Fittings |  |  |  |  |  |  | 8.56
[NAME] | Committed | 2021-04-15 00:00:00 |  | Visit with parts and to review about job | [NAME] |  |  |  |  |  |  | 30
Blanchfords | Prediction | 2021-04-15 00:00:00 |  | Parts supplied by [NAME] | Taps and Fittings |  |  |  |  |  |  | 45
 | Prediction |  |  | Medicine Cabinet | Medicine Cabinet |  |  |  |  |  |  | 100
[NAME] | Prediction |  |  | Help Reinstalling Bathroom | [NAME] |  |  |  |  |  |  | 150
B&Q | Expenditure | 2021-04-20 00:00:00 | 31509199 | [NAME] | Sunk Costs |  |  |  |  |  |  | -13.5
Screwfix | Expenditure | 2021-04-20 00:00:00 | A7754450693 | [NAME] and Chain | Taps and Fittings |  |  |  |  |  |  | 3.03
B&Q | Expenditure | 2021-04-22 00:00:00 | 30816702 | Masking Tape | Decoration |  |  |  |  |  |  | 7
B&Q | Expenditure | 2021-04-22 00:00:00 | 30816702 | Paint brushes - for bath handle | Taps and Fittings |  |  |  |  |  |  | 5.94
B&Q | Expenditure | 2021-04-22 00:00:00 | 30816702 | 15mm Coupler | Taps and Fittings |  |  |  |  |  |  | 1.54