Spreadsheet: 53817d1253737265-flag-exceptions-flagging-1-2
Sheet: TEST

 |  | I'd like to 'test' those cells which are highlighted yellow |  |  | *Note I removed all formulas from the spreadheet as they were linking to external sources
 |  | I'd like to 'flag' the cells based on the following criteria:
 | 1 | [NAME] is greater than 15% = URGENT ATTENTION
 | 2 | [NAME] is between 10% and 15% = flagged as an FYI
 | 3 | variance is between -10% and -15% = flagged as an FYI
 | 4 | [NAME] is less than -15% = NEEDS ATTENTION
 |  |  | 5 | 6 |  | 7 | 8 |  |  |  |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  |  | FY Jul 2010 |  |  | FY Aug 2010 |  |  |  | FY 2010 YTD |  | FY Sep 2010 |  | FY Oct 2010 |  | FY Nov 2010 |  | FY Dec 2010 |  | FY Jan 2010 |  | FY Feb 2010 |  | FY Mar 2010 |  | FY Apr 2010 |  | FY May 2010 |  | FY Jun 2010
 |  |  | Actual | Budget | [NAME] | Actual | Budget | [NAME] |  | [NAME] |  | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget | Forecast | Budget
153210
 |  | Labour - 153210
 | 700000 | Salaries | 92181.69 | 96459.2418833336 | -4277.551883333595 | 90491.86 | 103055.441883334 | -12563.581883334 |  | -16841.13376666763 |  | 96453.9966000001 | 121251.751883334 | 108911.239933333 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334 | 114650.3066 | 121251.751883334
 | 700001 | Salaries - Fixed | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | -900 | -900 | -1800 | -1800 | -2700 | -2700 | -3600 | -3600 | -4500 | -4500 | -5400 | -5400 | -6000 | -6000
 | 700003 | Salaries Indirect-Hourly | 1341.15 | 0 | 1341.15 | 3384.46 | 0 | 3384.46 |  | 4725.610000000001 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 700004 | Overtime Indirect-Hourly | 12373.53 | 0 | 12373.53 | 13941.87 | 0 | 13941.87 |  | 26315.4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 702004 | Vacation | 6577.760000000002 | 618.865632 | 5958.894368000002 | 5378.98 | 677.29969854 | 4701.680301459999 |  | 10660.57466946 |  | 659.986834032 | 659.986834032 | 683.070653376 | 683.070653376 | 671.528743704 | 671.528743704 | 659.986834032 | 659.986834032 | 562.60512 | 562.60512 | 579.917984508 | 579.917984508 | 710.476391196 | 710.476391196 | 608.048240508 | 608.048240508 | 597.230849016 | 597.230849016 | 665.033270688 | 665.033270688
 | 702006 | Payroll Tax - CPP | 1509.15 | 809.3126542814 | 699.8373457186001 | 1564.01 | 913.7154104305 | 650.2945895695 |  | 1350.1319352881 |  | 938.5408215018 | 938.5408215018 | 967.10704794 | 967.10704794 | 933.7797837621 | 933.7797837621 | 949.4231934783 | 949.4231934783 | 814.7538402696 | 814.7538402696 | 817.1343591395 | 817.1343591395 | 969.4875668099 | 969.4875668099 | 893.3109629747 | 893.3109629747 | 857.6031799269 | 857.6031799269 | 909.9745950636 | 909.9745950636
 | 702007 | Payroll Tax - EI | 608.93 | 333.5349120675 | 275.3950879325 | 627.49 | 376.5615024805 | 250.9284975195 |  | 526.3235854520001 |  | 386.7925809826 | 386.7925809826 | 398.565328848 | 398.565328848 | 384.8304563383 | 384.8304563383 | 391.2774373123 | 391.2774373123 | 335.7773402323 | 335.7773402323 | 336.7584025544 | 336.7584025544 | 399.5463911701 | 399.5463911701 | 368.1523968623 | 368.1523968623 | 353.4364620305 | 353.4364620305 | 375.0198331171 | 375.0198331171
 | 702008 | Payroll Tax - EHT | 2506.5 | 318.8201365351 | 2187.6798634649 | 2992.25 | 359.9484950181 | 2632.3015049819 |  | 4819.9813684468 |  | 369.7282024098 | 369.7282024098 | 380.98156434 | 380.98156434 | 367.8526420881 | 367.8526420881 | 374.0151974308 | 374.0151974308 | 320.9636340456 | 320.9636340456 | 321.9014142065 | 321.9014142065 | 381.9193445009 | 381.9193445009 | 351.9103793537 | 351.9103793537 | 337.8436769409 | 337.8436769409 | 358.4748404796 | 358.4748404796
 | 799994 | Annual Merit Incr. (July) | 0 | 3258.5474597087 | -3258.5474597087 | 0 | 3258.5474597087 | -3258.5474597087 |  | -6517.0949194174 |  | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087 | 0 | 3258.5474597087
 | 799995 | Annual Promo's (July) | 0 | 647.140814125 | -647.140814125 | 0 | 647.140814125 | -647.140814125 |  | -1294.28162825 |  | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125 | 0 | 647.140814125
 | 799996 | Annual Sal. [NAME] (July) | 0 | 832.2421215333 | -832.2421215333 | 0 | 832.2421215333 | -832.2421215333 |  | -1664.4842430666 |  | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333 | 0 | 832.2421215333
 | 799998 | Mid-Yr Promo's (Jan) | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 327.8645853568 | 287.728556215 | 327.8645853568 | 287.728556215 | 327.8645853568 | 287.728556215 | 327.8645853568 | 287.728556215 | 327.8645853568 | 287.728556215 | 327.8645853568 | 287.728556215
 | 799999 | Mid-Yr Sal. [NAME] (Jan) | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 316.1112668754 | 277.4140376349 | 316.1112668754 | 277.4140376349 | 316.1112668754 | 277.4140376349 | 316.1112668754 | 277.4140376349 | 316.1112668754 | 277.4140376349 | 316.1112668754 | 277.4140376349
 |  | Subtotal - Wages - 153210 | 117098.71 | 103277.7056135846 | 13821.0043864154 | 118380.92 | 110120.8973851701 | 8260.022614829897 |  | 22081.0270012453 |  | 98809.04503892628 | 128344.7307176272 | 111340.964527837 | 128419.406873205 | 117008.2982258925 | 128347.6739045935 | 116125.0092622534 | 127464.3849409544 | 115528.3823867797 | 126788.9248070984 | 114649.9946126406 | 125910.5370329593 | 114155.7121459091 | 125416.2545662278 | 113015.7044319309 | 124276.2468522496 | 112040.3966201465 | 123300.9390404652 | 111602.7849915805 | 122863.3274118992
 | 702010 | RRSP | 1438.52 | 152.7928994674 | 1285.7271005326 | 2255.01 | 156.0905879451 | 2098.9194120549 |  | 3384.6465125875 |  | 161.586735408 | 161.586735408 | 161.586735408 | 161.586735408 | 161.586735408 | 161.586735408 | 156.0905879451 | 156.0905879451 | 153.89212896 | 153.89212896 | 153.89212896 | 153.89212896 | 176.975948304 | 176.975948304 | 161.586735408 | 161.586735408 | 153.89212896 | 153.89212896 | 169.281341856 | 169.281341856
 | 702016 | Health/Dental | 7899.56 | 1780.92756 | 6118.63244 | 0 | 1780.92756 | -1780.92756 |  | 4337.70488 |  | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756 | 1780.92756
 | 702018 | Workers Comp. Insurance | 1809.31 | 259.9610344056 | 1549.3489655944 | 466.36 | 293.4964651686 | 172.8635348314 |  | 1722.2125004258 |  | 301.4706881188 | 301.4706881188 | 310.646506308 | 310.646506308 | 299.9413850872 | 299.9413850872 | 304.9662379052 | 304.9662379052 | 261.7088092987 | 261.7088092987 | 262.4734608145 | 262.4734608145 | 311.4111578238 | 311.4111578238 | 286.9423093191 | 286.9423093191 | 275.4725365826 | 275.4725365826 | 292.2948699295 | 292.2948699295
 | 702019 | Other Benefits | 0 | 24780.2460922336 | -24780.2460922336 | 0 | 26757.0171903252 | -26757.0171903252 |  | -51537.2632825588 |  | 23881.4199937118 | 31133.6674072457 | 26940.1947831889 | 31133.6674072457 | 28428.404889882 | 31220.5126495952 | 28222.2733265665 | 30993.9938469865 | 28872.5755614508 | 31673.911947208 | 28988.2363759563 | 31800.8691025243 | 27891.1117055468 | 30594.3540447897 | 28215.2464264622 | 30951.6373680615 | 28872.5755614508 | 31673.911947208 | 28222.8797864622 | 30959.2707280615
 | 704000 | Bonuses | 10073.14 | 8509.5208333333 | 1563.6191666667 | 12474.93 | 9114.2083333333 | 3360.721666666701 |  | 4924.340833333401 |  | 9864.9166666666 | 11129.8333333333 | 11275.8541666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333 | 11880.5416666666 | 11129.8333333333
 | 704003 | Gain Sharing | 69.84 | 301 | -231.16 | 45.68 | 301 | -255.32 |  | -486.48 |  | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301 | 301
 | 706000 | Stock Compensation | 7042.88 | 6874.76475 | 168.1152499999998 | 7468.69 | 7330.1025 | 138.5874999999996 |  | 306.7027500000004 |  | 6578.48 | 6396.8305 | 7175.23 | 7015.82625 | 7309.47 | 7177.818 | 6693.27 | 6496.75175 | 7033.13 | 6862.0905 | 7135.42 | 7026.08175 | 6772.53 | 6580.21475 | 6967.9 | 6812.82325 | 8257.96 | 8151.80025 | 6658.22 | 6477.6705
 | 706001 | LT Other Incentive | 999.38 | 939.5833333333 | 59.79666666670005 | 999.38 | 939.5833333333 | 59.79666666670005 |  | 119.5933333334001 |  | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333 | 999.375 | 939.5833333333
 |  | Subtotal - Benefits - 153210 | 29332.63 | 43598.7965027732 | -14266.1665027732 | 23710.05 | 46672.42597010551 | -22962.3759701055 |  | -37228.54247287869 |  | 43869.1766439052 | 52144.8995574391 | 48944.8147515715 | 52773.0711256283 | 51161.2472370438 | 53011.202996757 | 50338.4443790834 | 52103.1466495034 | 51283.1507263761 | 53102.94761213329 | 51501.8661923974 | 53394.66066896539 | 50113.8730383412 | 51814.30012758409 | 50593.5196978559 | 52364.3338894552 | 52521.74445366 | 54406.4210894172 | 50304.5202249143 | 52049.8616665136
 |  | Total Labour Costs - 153210 | 146431.34 | 146876.5021163578 | -445.1621163577984 | 142090.97 | 156793.3233552756 | -14702.35335527561 |  | -15147.51547163339 |  | 142678.2216828315 | 180489.6302750663 | 160285.7792794085 | 181192.4779988333 | 168169.5454629363 | 181358.8769013505 | 166463.4536413368 | 179567.5315904578 | 166811.5331131558 | 179891.8724192317 | 166151.860805038 | 179305.1977019247 | 164269.5851842503 | 177230.5546938119 | 163609.2241297868 | 176640.5807417048 | 164562.1410738065 | 177707.3601298824 | 161907.3052164948 | 174913.1890784128
 |  | Overhead - 153210
 | 711002 | Referral Bonus | 0 | 0 | 0 | 906.54 | 0 | 906.54 |  | 906.54 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 890001 | Building Occupancy Allocation | 8594.47 | 0 | 8594.47 | 12256 | 0 | 12256 |  | 20850.47 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 990001 | Building Occupancy Allocation | 0 | 7598.376068696 | -7598.376068696 | 0 | 7002.371541572 | -7002.371541572 |  | -14600.747610268 |  | 6265.0188679246 | 7702.608701044 | 6250.3571428571 | 7000.18149636 | 6481.8518518518 | 6899.99999832 | 6638.182795699 | 7006.7531461464 | 6540.0523560209 | 6991.50977107 | 6450 | 6917.785585564 | 6740.0179856115 | 7117.938521914 | 6375.3975903615 | 6810.4168197752 | 5831.875 | 6268.538592782 | 6445.3846153846 | 6746.392861836
 |  | Total Overhead Costs - 153210 | 8594.47 | 7598.376068696 | 996.0939313039989 | 13162.54 | 7002.371541572 | 6160.168458428001 |  | 7156.262389732001 |  | 6265.0188679246 | 7702.608701044 | 6250.3571428571 | 7000.18149636 | 6481.8518518518 | 6899.99999832 | 6638.182795699 | 7006.7531461464 | 6540.0523560209 | 6991.50977107 | 6450 | 6917.785585564 | 6740.0179856115 | 7117.938521914 | 6375.3975903615 | 6810.4168197752 | 5831.875 | 6268.538592782 | 6445.3846153846 | 6746.392861836
Total Costs - 153210 |  |  | 155025.81 | 154474.8781850538 | 550.9318149462006 | 155253.51 | 163795.6948968476 | -8542.184896847604 |  | -7991.253081901392 |  | 148943.2405507561 | 188192.2389761103 | 166536.1364222656 | 188192.6594951933 | 174651.3973147881 | 188258.8768996705 | 173101.6364370358 | 186574.2847366042 | 173351.5854691767 | 186883.3821903017 | 172601.860805038 | 186222.9832874887 | 171009.6031698618 | 184348.4932157259 | 169984.6217201483 | 183450.99756148 | 170394.0160738065 | 183975.8987226644 | 168352.6898318794 | 181659.5819402488