Spreadsheet: 153483d1335937916-lock-a-cell-reference-to-a-different-worksheet-from-where-the-cell-is-located-copy-calculator-copy
Sheet: TEMPLATE

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Month |  | File: XXXXX
 |  | Start Date | End Date |  |  |  |  |  |  |  |  |  |  | Year
Weeks in invoice period | 0
WASTE SERVICES | Claim  Week 1 | Actual Week 1 | Claim  Week 2 | Actual Week 2 | Claim  Week 3 | Actual Week 3 | Claim  Week 4 | Actual Week 4 | Claim Week 5 | Actual Week 5 | CLAIM Services | ACTUAL Services | Tender Rate | Current Rate (inc R&F) | Claim Total | Actual Total (inc R&F)
GARBAGE
Domestic Garbage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.863 | 0.9411 | 0 | 0
NON Domestic Garbage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.863 | 0.9411 | 0 | 0
RECYCLING (Includes Processing)
Domestic Recycling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.917 | 2.0905 | 0 | 0
NON Domestic Recycling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.917 | 2.0905 | 0 | 0
ORGANICS
Domestic Organics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.593 | 0.6465 | 0 | 0
Additional / Non Domestic Organics | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.593 | 0.6465 | 0 | 0
BULKY WASTE
Domestic Bulky Waste | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.239 | 2.4416 | 0 | 0
PUBLIC PLACE GARBAGE
Parks & Reserves - Weekly | 0 | 244 | 0 | 244 | 0 | 244 | 0 | 244 | 0 | 0 | 0 | 976 | 2.218 | 2.4188 | 0 | 2360.7488
Streets and Roadsides - Daily | 0 | 931 | 0 | 931 | 0 | 931 | 0 | 931 | 0 | 0 | 0 | 3724 | 2.218 | 2.4188 | 0 | 9007.6112
Streets and Roadsides - Weekly | 0 | 148 | 0 | 148 | 0 | 148 | 0 | 148 | 0 | 0 | 0 | 592 | 2.218 | 2.4188 | 0 | 1431.9296
[NAME] (garbage) | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 20 | 0 | 0 | 0 | 80 | 2.218 | 2.4188 | 0 | 193.504
Roadsides - Attunga (Recycling) | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 20 | 0 | 0 | 0 | 40 | 2.218 | 2.4188 | 0 | 96.75200000000001
SPECIAL EVENTS
(NAME OF EVENT)
Garbage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.095 | 2.2846 | 0 | 0
Recycling | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.095 | 2.2846 | 0 | 0
[NAME] (per bin) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.325 | 0.3544 | 0 | 0
Delivery (LOCATION) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
TRANSFER STATION SERVICES |  |  |  |  |  |  |  |  |  |  | Claimed | Actual
[NAME] 15cuM - per month |  |  |  |  |  |  |  |  |  |  | 0 | 9 | 130 | 141.7666 | 0 | 1275.8994
[NAME] 20cuM - per month |  |  |  |  |  |  |  |  |  |  | 0 | 6 | 130 | 141.7666 | 0 | 850.5996
GARBAGE TRANSFER - SCHEDULED
???? Transfer Station | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 4 | 4 | 225 | 245.3653 | 981.4612 | 981.4612
???? Transfer Station | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 0 | 0 | 8 | 8 | 192.5 | 209.9236 | 1679.3888 | 1679.3888
???? Transfer Station | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 9 | 9 |  | 203.4847 | 1831.3623 | 1831.3623
???? Transfer Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
???? Transfer Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 225 | 245.3653 | 0 | 0
GARBAGE TRANSFER - AT CALL
???? Transfer Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 450 | 245.3653 | 0 | 0
???? Transfer Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 385 | 419.8474 | 0 | 0
???? Transfer Station | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 450 | 490.7307 | 0 | 0
RECYCLING COLLECTION - SCHEDULED
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 275 | 299.8909 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 272.6282 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 275 | 299.8909 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 272.6282 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
RECYCLING COLLECTION - AT CALL
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 436.2051 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 550 | 599.782 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 436.2051 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 545.2563 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 218.1026 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 436.2051 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 550 | 599.782 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500 | 545.2563 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 436.2051 | 0 | 0
RECYCLING - PROCESSING FEE
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
???? | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 54.5256 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub | 19709.2569
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GST | 1970.92569
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | 21680.18259
Accounts Voucher Requisition |  | Project |  | Amount
Domestic Garbage Collection |  | RVCW12 | 1495 | 0
Domestic Recycling Service |  | RVCW12 | 2211 | 0 |  |  |  |  |  |  | Prepared By:
Domestic Organics Collections |  | RVCW12 | 1714 | 0
Domestic Bulky Waste Collections |  | RVCW12 | 1762 | 0
Additional Organics Collections |  | RVCW12 | 1714 | 0 |  |  |  |  |  |  | Authorised:
Non Domestic Garbage Collection |  | RVCW13 | 1324 | 0
NON Domestic Recycling Services |  | RVCW13 | 5045 | 0
Litter [NAME] |  | RVCW13 | 5047 | 10439.5408
Litter [NAME] |  | RVCW13 | 5048 | 2360.7488
[NAME] |  | [NAME] | 1598 | 290.256
Special Events Services |  | RVCW13 | 3413 | 0 |  |  |  |  |  |  | Date:
Special Events Services - CMF |  | RVCW13 | 5046
Temporary Collection - Garbage
???? - Waste |  | RVLC11 | 1324 | 1264.9944
???? - Waste |  | RVLC10 | 1324 | 1962.922
???? - Waste |  | RVLC12 | 1324 | 141.7666
???? - Waste |  | RVLC07 | 1324 | 2114.8955
???? - Waste |  | RVLC14 | 1324 | 0
???? - Recycling |  | RVLC03 | 5045 | 141.7666
???? - Recycling |  | RVLC11 | 5045 | 141.7666
???? - Recycling |  | RVLC10 | 5045 | 141.7666
???? - Recycling |  | RVLC09 | 5045 | 141.7666
???? - Recycling |  | RVLC07 | 5045 | 141.7666
???? - Recycling |  | RVLC04 | 5045 | 141.7666
???? - Recycling |  | RVLC05 | 5045 | 141.7666
???? - Recycling |  | [NAME] | 5045 | 141.7666
 |  |  |  | 1970.925689999999
 |  |  |  | 21680.18258999999