Spreadsheet: 68227d1268762541-consolidating-columns-from-multiple-sheets-budget-example
Sheet: Facilities

 | 2010 FACILITIES BUDGET |  |  |  |  |  |  |  |  |  |  | Page: 29.1
 |  |  | Supplies | Contract | Mtce 1 | Misc | Cleaning | Mtce II | Utilities | Common
 |  |  |  | Work | Labour | Costs | Contracts | Labour |  | Costs
 | Project | SITE | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 |  | TOTAL
[PHONE]-120000 | 0346-08 | Facilities Supervisor |  |  |  |  |  |  |  | 97875 |  | 97875
[PHONE]-120000 | 0346-09 | Manager -  Facilities |  |  |  |  |  |  |  | 0 |  | 0
 | 0346-10 | Sub-foreman/Tech Asst |  |  |  |  |  |  |  | 79165 |  | 79165
[PHONE]-120000 | 0347-08 | Vehicle Expense |  |  |  |  |  |  |  | 22229 |  | 22229
[PHONE]-120000 | 0301 | City Hall | 15000 | 22000 |  | 54500 | 47500 | 50000 | 50200 | 7200 |  | 246400
[PHONE]-120000 | 0302 | City Houses | 3000 | 10200 |  |  |  | 6000 | 900 |  |  | 20100
[PHONE]-120000 | 0303 | [NAME] | 8500 | 23600 |  | 1000 |  | 25000 | 14000 | 140637 |  | 212737
[PHONE]-120000 | 0304 | Gen Tool Repair & Replacement | 6000 |  |  |  |  |  |  |  |  | 6000
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0306 | [NAME] | 15000 | 10000 |  |  | 67800 | 14000 | 54000 | 65000 |  | 225800
[PHONE]-120000 | 0307 | Fire Hall # 1 | 5000 | 6000 |  |  | 5200 | 6000 | 21800 | 5400 |  | 49400
[PHONE]-120000 | 0308 | Fire Hall # 2 | 2000 | 2500 |  |  | 2300 | 4000 | 17500 |  |  | 28300
[PHONE]-120000 | 0309 | Emergency Measures | 1000 | 1500 |  |  |  |  |  |  |  | 2500
[PHONE]-120501 | 0310 | Dog Pound | 1500 | 2000 |  |  |  | 2000 | 1600 |  |  | 7100
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0311 | Yards & Warehouse | 12000 | 25000 |  |  | 27000 | 22900 | 56800 | 4000 |  | 147700
[PHONE]-120000 | 0312 | Westminster Centre | 4000 | 5000 |  |  | 5700 | 7800 | 8700 |  |  | 31200
[PHONE]-120000 | 0313 | [NAME] | 1000 | 500 |  |  | 3000 | 2500 | 6000 |  |  | 13000
[PHONE]-120501 | 0314 | Sports Training Centre | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0316 | Community Centre | 80000 | 40000 | 66015 |  | 4000 | 135900 | 145300 |  |  | 471215
[PHONE]-120000 | 0317 | Edmonton Ave Centre | 1500 | 2500 |  |  | 1200 | 2000 | 11000 |  |  | 18200
[PHONE]-120000 | 0318 | [NAME] | 1000 | 1000 |  |  | 0 | 2000 | 0 |  |  | 4000
[PHONE]-120000 | 0319 | Curling Club Building | 1500 | 2500 |  |  |  | 2000 |  |  |  | 6000
 |  |  |  |  |  |  |  |  |  |  |  | -
 | 0320 | Indoor Soccer Facility |  |  |  |  |  |  |  | 10000 |  | 10000
[PHONE]-120000 | 0321 | Tennis Facility |  |  |  |  |  |  |  |  |  | 0
[PHONE]-120000 | 0322 | Tennis Courts |  |  |  |  |  |  |  |  |  | 0
[PHONE]-120000 | 0323 | Bathhouses | 50000 | 15000 |  |  | 102000 | 65000 | 7600 |  |  | 239600
[PHONE]-120000 | 0324 | 500 Edmonton Ave | 1000 |  |  |  |  | 2500 |  |  |  | 3500
[PHONE]-120000 | 0325 | Boat House # 2 Skaha | 500 |  |  |  |  | 3000 |  |  |  | 3500
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0326 | Marina - Okanagan | 500 | 0 |  |  |  | 2500 |  |  |  | 3000
[PHONE]-120000 | 0327 | - Skaha | 500 | 1000 |  |  |  | 2500 |  | 3600 |  | 7600
[PHONE]-120000 | 0328 | [NAME] | 25000 | 11000 | 276015 | 1000 | 4000 | 40000 | 68800 | 8500 |  | 434315
[PHONE]-120000 | 0329 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
[PHONE]-120000 | 0330 | [NAME] Main St |  | 3800 |  |  |  |  |  |  |  | 3800
[PHONE]-120000 | 0334 | [NAME] | 2500 | 100 |  |  |  | 3500 | 1100 |  |  | 7200
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0335 | Lawn Bowling Club | 0 |  |  |  |  | 0 |  |  |  | 0
[PHONE]-120000 | 0336 | OK River Channel Sign |  |  |  |  |  |  |  |  |  | 0
[PHONE]-120000 | 0338 | Skaha Solar Time Piece |  |  |  |  |  |  |  |  |  | 0
[PHONE]-120000 | 0339 | Mobile Concession/Washroom | 500 | 1000 |  |  |  | 4000 |  |  |  | 5500
[PHONE]-120000 | 0340 | SS Sicamous |  | 1500 |  |  |  | 4500 |  |  |  | 6000
 |  |  |  |  |  |  |  |  |  |  |  | -
[PHONE]-120000 | 0341 | Vandalism - Public Facil |  | 20000 |  |  |  |  |  |  |  | 20000
[PHONE]-120000 | 0342 | Vandalism - Rec Facil |  | 5000 |  |  |  |  |  |  |  | 5000
[PHONE]-120000 | 0343 | Library/Museum Complex | 35500 | 30000 |  |  | 60400 | 21800 | 43700 |  |  | 191400
[PHONE]-120000 | 0344 | Walking Pier | 2500 |  |  |  |  | 4500 |  |  |  | 7000
 | 0345 | Wine/Information Visitors Centre | 500 | 1000 |  |  |  | 4000 |  |  |  | 5500
 |  |  | 277000 | 243700 | 342030 | 56500 | 330100 | 439900 | 509000 | 443606 |  | 2641836
 |  | Actual | Supplies | Contract | Mtce 1 | Misc | Cleaning | Mtce II | Utilities | Common
 |  | Feb 5 |  | Work | Labour | Costs | Contracts | Labour |  | Costs
 | Project |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 |  | TOTAL
 | - | - | - | - | - | - | - | - | - | - |  | -
 | 0346-08 | Facilities Supervisor |  |  |  |  |  |  |  | 0 |  | 0
 | 0346-09 | Manager -  Facilities |  |  |  |  |  |  |  | 0 |  | 0
 | 0346-10 | Sub-foreman/Tech Asst |  |  |  |  |  |  |  | 7388 |  | 7388
 | 0347-08 | Vehicle Expense |  |  |  |  |  |  |  | 0 |  | 0
 | 0348 | Standby | 0 |  |  |  |  |  |  |  |  | 0
 | 0301 | City Hall | 282 | 2594 |  | 0 | 0 | 4689 | 0 | 0 |  | 7565
 | 0302 | City Houses | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
 | 0303 | [NAME] | 380 | 4620 |  | 0 |  | 1825 | 0 | 2391 |  | 9216
 | 0304 | Gen Tool Repair & Replacement | 0 |  |  |  |  |  |  |  |  | 0
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0306 | [NAME] | 0 | 660 |  | 0 | 0 | 1162 | 0 | 0 |  | 1822
 | 0307 | Fire Hall # 1 | 266 | 0 |  |  | 0 | 965 | 0 | 0 |  | 1231
 | 0308 | Fire Hall # 2 | 0 | 0 |  |  | 0 | 83 | 0 |  |  | 83
 | 0309 | Emergency Measures | 0 | 0 |  |  |  |  |  |  |  | 0
 | 0310 | Dog Pound | 0 | 0 |  |  |  | 325 | 0 |  |  | 325
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0311 | Yards & Warehouse | 302 | 2474 |  |  | 0 | 1437 | 0 |  |  | 4213
 | 0312 | Westminster Centre | 0 | 660 |  |  | 993 | 345 | 0 |  |  | 1998
 | 0313 | [NAME] | 11 | 0 |  |  | 160 | 0 | 0 |  |  | 171
 | 0314 | Sports Training Centre | 0 | 0 |  | 0 | 0 | 0 | 0 | -100 |  | -100
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0316 | Community Centre | 3391 | 1316 | 32204 |  | 0 | 1175 | 0 |  |  | 38086
 | 0317 | Edmonton Ave Centre | 0 | 0 |  |  | 0 | 230 | 0 |  |  | 230
 | 0318 | [NAME] | 0 | 0 |  |  | 0 | 46 | 0 |  |  | 46
 | 0319 | Curling Club Building | 0 | 0 |  |  |  | 92 |  |  |  | 92
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0320 | Indoor Soccer Facility |  |  |  |  |  |  |  | 0 |  | 0
 | 0321 | Tennis Facility | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
 | 0322 | Tennis Courts | 0 |  |  |  |  | 0 |  |  |  | 0
 | 0323 | Bathhouses | 99 | 5350 | 0 |  | 11249 | 3861 | 0 |  |  | 20559
 | 0324 | 500 Edmonton Ave | 660 |  |  |  |  | 138 | 0 |  |  | 798
 | 0325 | Boat House # 2 Skaha | 0 |  |  |  |  | 0 |  |  |  | 0
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0326 | Marina - Okanagan | 0 | 0 |  | 0 |  | 0 |  |  |  | 0
 | 0327 | - Skaha | 0 | 660 |  | 0 | 0 | 0 | 0 | 0 |  | 660
 | 0328 | [NAME] | 276 | 2272 | 20479 | 138 | 0 | 3893 | 0 | 0 |  | 27058
 | 0329 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | 0330 | [NAME] Main St |  | 0 |  |  |  |  |  |  |  | 0
 | 0334 | [NAME] | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0335 | Lawn Bowling Club | 0 |  |  |  |  | 0 |  |  |  | 0
 | 0336 | OK River Channel Sign |  |  |  |  |  |  |  |  |  | 0
 | 0338 | Skaha Solar Time Piece |  |  |  |  |  |  |  |  |  | 0
 | 0339 | Mobile Concession/Washroom | 0 | 0 |  |  |  | 0 |  |  |  | 0
 | 0340 | SS Sicamous |  | 660 |  |  |  |  |  |  |  | 660
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0341 | Vandalism - Public Facil |  | 1144 |  |  |  |  |  |  |  | 1144
 | 0342 | Vandalism - Rec Facil |  | 0 |  |  |  |  |  |  |  | 0
 | 0343 | Library/Museum Complex | 0 | 660 |  |  | 3383 | 2048 | 0 |  |  | 6091
 | 0344 | Walking Pier | 39 |  |  |  |  | 221 |  |  |  | 260
 | 0345 | Wine/Information Visitors Centre | 136 | 1441 | 0 | 0 | 0 | 92 | 0 | 0 |  | 1669
 |  |  | - | - | - | - | - | - | - | - |  | -
 |  |  | 5842 | 24511 | 52683 | 138 | 15785 | 22627 | 0 | 9679 |  | 131265
 |  |  | = | = | = | = | = | = | = | = |  | =
 |  | Variance - Over/(Under) | Supplies | Contract | Mtce 1 | Misc | Cleaning | Mtce II | Utilities | Common
 |  | Feb 5 |  | Work | Labour | Costs | Contracts | Labour |  | Costs
 | Project |  | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 |  | TOTAL
 | - | - | - | - | - | - | - | - | - | - | - | -
 | 0346-08 | Facilities Supervisor |  |  |  |  |  |  |  | -97875 |  | -97875
 | 0346-09 | Manager -  Facilities |  |  |  |  |  |  |  | 0 |  | 0
 | 0346-10 | Sub-foreman/Tech Asst |  |  |  |  |  |  |  | -71777 |  | -71777
 | 0347-08 | Vehicle Expense |  |  |  |  |  |  |  | -22229 |  | -22229
 | 0301 | City Hall | -14718 | -19406 |  | -54500 | -47500 | -45311 | -50200 | -7200 |  | -238835
 | 0302 | City Houses | -3000 | -10200 |  |  |  | -6000 |  |  |  | -19200
 | 0303 | [NAME] | -8120 | -18980 |  | -1000 |  | -23175 | -14000 | -138246 |  | -203521
 | 0304 | Gen Tool Repair & Replacement | -6000 |  |  |  |  |  |  |  |  | -6000
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0306 | [NAME] | -15000 | -9340 |  | 0 | -67800 | -12838 | -54000 | -65000 |  | -223978
 | 0307 | Fire Hall # 1 | -4734 | -6000 |  |  | -5200 | -5035 | -21800 | -5400 |  | -48169
 | 0308 | Fire Hall # 2 | -2000 | -2500 |  |  | -2300 | -3917 | -17500 |  |  | -28217
 | 0309 | Emergency Measures | -1000 | -1500 |  |  |  |  |  |  |  | -2500
 | 0310 | Dog Pound | -1500 | -2000 |  |  |  | -1675 | -1600 |  |  | -6775
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0311 | Yards & Warehouse | -11698 | -22526 |  |  | -27000 | -21463 | -56800 |  |  | -139487
 | 0312 | Westminster Centre | -4000 | -4340 |  |  | -4707 | -7455 | -8700 |  |  | -29202
 | 0313 | [NAME] | -989 | -500 |  |  | -2840 | -2500 | -6000 |  |  | -12829
 | 0314 | Sports Training Centre | 0 | 0 |  | 0 | 0 | 0 | 0 | -100 |  | -100
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0316 | Community Centre | -76609 | -38684 | -33811 |  | -4000 | -134725 | -145300 |  |  | -433129
 | 0317 | Edmonton Ave Centre | -1500 | -2500 |  |  | -1200 | -1770 | -11000 |  |  | -17970
 | 0318 | [NAME] | -1000 | -1000 |  |  | 0 | -1954 | 0 |  |  | -3954
 | 0319 | Curling Club Building | -1500 | -2500 |  |  |  | -1908 |  |  |  | -5908
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0320 | Indoor Soccer Facility |  |  |  |  |  |  |  | -10000 |  | -10000
 | 0321 | Tennis Facility | 0 | 0 |  |  |  | 0 | 0 |  |  | 0
 | 0322 | Tennis Courts | 0 |  |  |  |  | 0 |  |  |  | 0
 | 0323 | Bathhouses | -49901 | -9650 | 0 |  | -90751 | -61139 | -7600 |  |  | -219041
 | 0324 | 500 Edmonton Ave | -340 |  |  |  |  | -2362 | 0 |  |  | -2702
 | 0325 | Boat House # 2 Skaha | -500 |  |  |  |  | -3000 |  |  |  | -3500
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0326 | Marina - Okanagan | -500 | 0 |  |  |  | -2500 |  |  |  | -3000
 | 0327 | - Skaha | -500 | -340 |  | 0 |  | -2500 |  | -3600 |  | -6940
 | 0328 | [NAME] | -24724 | -8728 | -255536 | -862 | -4000 | -36107 | -68800 | -8500 |  | -407257
 | 0329 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 | 0330 | [NAME] Main St |  | -3800 |  |  |  |  |  |  |  | -3800
 | 0334 | [NAME] | -2500 | -100 |  |  |  | -3500 | -1100 |  |  | -7200
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0335 | Lawn Bowling Club | 0 |  |  |  |  | 0 |  |  |  | 0
 | 0336 | OK River Channel Sign |  |  |  |  |  |  |  |  |  | 0
 | 0338 | Skaha Solar Time Piece |  |  |  |  |  |  |  |  |  | 0
 | 0339 | Mobile Concession/Washroom | -500 | -1000 |  |  |  | -4000 |  |  |  | -5500
 | 0340 | SS Sicamous |  | -840 |  |  |  |  |  |  |  | -840
 |  |  | - | - | - | - | - | - | - | - |  | -
 | 0341 | Vandalism - Public Facil |  | -18856 |  |  |  |  |  |  |  | -18856
 | 0342 | Vandalism - Rec Facil |  | -5000 |  |  |  |  |  |  |  | -5000
 | 0343 | Library/Museum Complex | -35500 | -29340 |  |  | -57017 | -19752 | -43700 |  |  | -185309
 | 0344 | Walking Pier | -2461 |  |  |  |  | -4279 |  |  |  | -6740
 | 0345 | Wine/Information Visitors Centre | -364 | 441 |  |  | 0 | -3908 | 0 |  |  | -3831
 |  |  | - | - | - | - | - | - | - | - | - | -
 |  |  | -271158 | -219189 | -289347 | -56362 | -314315 | -412773 | -508100 | -429927 | 0 | -2501171
 |  |  | = | = | = | = | = | = | = | = | = | =