Spreadsheet: 271880d1382096203-conditional-formatting-traffic-lights-using-formulas-trafficlights
Sheet: 2012-13 Summary

2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | Annual Target Total | Actual Total
34963.28791398538 | 36122.65888237486 | 34292.5560929268 | 42155.49175966274 | 52943.98563231473 | 35157.67374858716 | 37839.18603531033 | 36243.59285131559 | 40082.24816534129 | 48275.57029054888 | 39147.55344111989 | 64909.83484185013 | 502133.6396553378 | 425328
0 | 0 | 0 | 0 | 0 | 0 | 17.49593209179834 | 0 | 0 | 0 | 0 | 0 | 17.49593209179834 | 0
7092.473156800831 | 11387.88110118597 | 9582.911149539123 | 14485.91427018554 | 10359.08523819103 | 6410.818823029421 | 8955.095306469817 | 9296.669240655028 | 18372.13874081246 | 18445.25449057075 | 14145.81576886056 | 31109.40062536826 | 159643.4579116688 | 131892
47217.53856309205 | 48432.68920872467 | 60304.73264887319 | 55280.17994452739 | 58136.82326470661 | 53779.15154922754 | 63645.1214858067 | 62583.41646087183 | 94763.98210243564 | 55347.56214196209 | 66269.76842784352 | 96473.25721784777 | 762234.2230159189 | 567072
21818.9156454428 | 33088.95811633689 | 43379.88497654477 | 30203.44670119541 | 35375.76050132137 | 55161.56793036214 | 54721.63173408336 | 54808.65544216326 | 68850.43010068651 | 62345.48456347359 | 54978.95458094621 | 63825.27447305694 | 578558.9647656132 | 623532
 |  | 2525.050568917396 | 7061.231738311896 | 7810.333908691829 | 11153.96074183298 | 7607.908535401345 | 12077.13180279034 | 21498.60729763057 | 12135.5878336328 | 20405.95488859342 | 15683.69340819005
41856.26247998188 | 60872.56419699092 | 72040.54247802722 | 79251.47417046026 | 114800.818471069 | 81087.36085592597 | 67153.33806266535 | 58726.25234426657 | 67432.19804731355 | 32676.41725690983 | 38282.01536110257 | 34671.98624993304 | 748851.2299746461 | 600082
597.8329863970049 | 589.9738036591613 | 661.1898566607575 | 809.1923328355869 | -81.71569148012709 | -85.71530140963499 | 0 | 0 | 0 | 0 | 0 | 0 | 2490.757986662749 | 0
56003.42999067376 | 36442.85833991638 | 32967.07511386109 | 32045.38789271777 | 29160.82818819393 | 31801.06254538586 | 23364.97073123741 | 21999.19720896654 | 35971.58106096288 | 38371.24209749543 | 34287.31753700018 | 59639.78797940435 | 432054.7386858156 | 400361
31267.5930889857 | 42621.82543101761 | 42582.8596802886 | 40058.44925643288 | 42957.80930365602 | 39926.18739660798 | 31817.19908629457 | 40315.32107790019 | 51957.50868910114 | 32930.08866728122 | 44311.06127236549 | 64797.81452206867 | 505543.717472 | 578986
13008.50113527053 | 22291.05081881008 | 19010.75901186887 | 24377.94766099346 | 40779.37273475327 | 67920.11911458349 | 23387.54612748489 | 47184.69917258744 | 42537.22990823395 | 49452.8153888099 | 70986.25343850555 | 75040.03603299588 | 495976.3305448974 | 758385
-459.9734950770747 | -279.2290545096244 | -465.1898616281127 | -107.6637256399891 | -310.0007978373075 | 301.7178609619152 | 1658.727239283721 | 2696.743749197642 | 3213.405013886719 | 4119.702362233021 | 3961.337912118527 | 5214.036702555038 | 19543.61390554447 | 69544
31913.14666853192 | 51185.26997857462 | 55930.08719012241 | 58639.69963822362 | 45721.87499483302 | 36383.74541995059 | 27407.6598142552 | 30551.8224300033 | 36403.66822818448 | 37466.0218966611 | 45507.77229680429 | 80932.13512574321 | 538042.9036818878 | 445282
12358.30805361259 | 26642.1076207964 | 25739.88542360673 | 30278.87988476483 | 32013.09494319074 | 30862.30856434754 | 24207.03301126848 | 24911.05949736826 | 37533.19339054603 | 27596.43423267659 | 26730.38765687697 | 40924.75682682522 | 339797.4491058804 | 244510