Spreadsheet: 92801d1292347991-compare-and-highlight-cells-based-on-date-compare-date-sample
Sheet: sheet1

Company Name | PropertyName | Run # | API | 2010-01-10 00:00:00 | 2010-02-10 00:00:00 | 2010-03-10 00:00:00 | 2010-04-10 00:00:00 | 2010-05-10 00:00:00 | 2010-06-10 00:00:00 | 2010-07-10 00:00:00 | 2010-08-10 00:00:00 | 2010-09-10 00:00:00 | 2010-10-10 00:00:00 | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | YTD
????? | JOHNSTON A #8 | 450 | 3003906836 | 0 | 0 | 0 | 0 | 0 | 897 | 711 | 630 | 548 | 0 | 0 | 0 | 2786
????? | JOHNSTON A #8 | 450 | 3003906836 | 997 | 869 | 913 | 978 | 1050 | 905 | 989 | 805 | 794 | 0 | 0 | 0 | 8300
????? | JOHNSTON A #13N | 450 | 3003930389 | 0 | 0 | 0 | 819 | 1315 | 1 | 4356 | 6827 | 5926 | 0 | 0 | 0 | 19244
????? | JOHNSTON A #13N | 450 | 3003930389 | 0 | 0 | 0 | 204 | 329 | 0 | 1089 | 1707 | 1481 | 0 | 0 | 0 | 4810
????? | JOHNSTON A #16 | 450 | 3003924739 | 418 | 371 | 383 | 359 | 320 | 292 | 319 | 333 | 340 | 0 | 0 | 0 | 3135
????? | JOHNSTON A COM C #9 | 450 | 3003906801 | 516 | 482 | 475 | 266 | 314 | 419 | 261 | 229 | 365 | 0 | 0 | 0 | 3327
????? | JOHNSTON A COM C #9 | 450 | 3003906801 | 0 | 46 | 28 | 0 | 0 | 0 | 272 | 451 | 310 | 0 | 0 | 0 | 1107
????? | JOHNSTON A COM C #9A | 450 | 3003925979 | 0 | 0 | 0 | 152 | 1339 | 0 | 6287 | 3801 | 3580 | 0 | 0 | 0 | 15159
????? | JOHNSTON A COM C #9A | 450 | 3003925979 | 0 | 0 | 0 | 2 | 15 | 0 | 69 | 42 | 39 | 0 | 0 | 0 | 167
????? | JOHNSTON A COM C #9A | 450 | 3003925979 | 0 | 0 | 0 | 13 | 118 | 0 | 553 | 335 | 315 | 0 | 0 | 0 | 1334
????? | JOHNSTON A COM C #9N | 450 | 3003930388 | 2936 | 48 | 1136 | 7288 | 5774 | 5375 | 5119 | 5088 | 4720 | 0 | 0 | 0 | 37484
????? | JOHNSTON A COM C #9N | 450 | 3003930388 | 1142 | 18 | 442 | 2834 | 2246 | 2090 | 1991 | 1979 | 1835 | 0 | 0 | 0 | 14577
????? | JOHNSTON A COM E #12 | 450 | 3003906767 | 4324 | 2443 | 1561 | 4225 | 4037 | 3758 | 4008 | 2015 | 1671 | 0 | 0 | 0 | 28042
????? | SJ 27-5 #34A | 450 | 3003923739 | 0 | 0 | 0 | 4120 | 3607 | 3217 | 2275 | 2786 | 3011 | 0 | 0 | 0 | 19016
????? | SJ 27-5 #97M | 450 | 3003923728 | 3572 | 2322 | 0 | 1561 | 2063 | 3848 | 2724 | 2995 | 3462 | 0 | 0 | 0 | 22547
????? | SJ 27-5 #97M | 450 | 3003923728 | 2011 | 1306 | 0 | 878 | 1161 | 2165 | 1532 | 1684 | 1948 | 0 | 0 | 0 | 12685
????? | SJ 27-5 #141 | 450 | 3003920465 | 3686 | 4231 | 2391 | 5186 | 4811 | 3413 | 3479 | 969 | 1969 | 0 | 0 | 0 | 30135
????? | SJ 27-5 #141N | 450 | 3003929733 | 2728 | 2473 | 2092 | 1473 | 2231 | 2496 | 2607 | 2602 | 2503 | 0 | 0 | 0 | 21205
????? | SJ 27-5 #141N | 450 | 3003929733 | 3767 | 3415 | 2890 | 2034 | 3081 | 3446 | 3599 | 3593 | 3456 | 0 | 0 | 0 | 29281
????? | SJ 28-6 #6 | 450 | 3003907048 | 0 | 0 | 40 | 0 | 7 | 0 | 845 | 1927 | 2410 | 0 | 0 | 0 | 5229
????? | SJ 28-6 #6A | 450 | 3003922186 | 353 | 401 | 216 | 696 | 618 | 607 | 603 | 590 | 685 | 0 | 0 | 0 | 4769
????? | SJ 28-6 #6A | 450 | 3003922186 | 657 | 746 | 402 | 1292 | 1149 | 1128 | 1119 | 1096 | 1271 | 0 | 0 | 0 | 8860
????? | SJ 28-6 #11 | 450 | 3003907137 | 3835 | 3978 | 2960 | 4196 | 2976 | 3522 | 3926 | 3643 | 3671 | 0 | 0 | 0 | 32707
????? | SJ 28-6 #11A | 450 | 3003922203 | 1954 | 1777 | 1881 | 1511 | 838 | 1996 | 1915 | 1796 | 1554 | 0 | 0 | 0 | 15222
????? | SJ 28-6 #22 | 450 | 3003907127 | 1773 | 2056 | 2275 | 2071 | 1861 | 1270 | 2096 | 2659 | 2113 | 0 | 0 | 0 | 18174
????? | SJ 28-6 #22A | 450 | 3003922299 | 1546 | 1235 | 943 | 680 | 1201 | 1212 | 1467 | 1221 | 1230 | 0 | 0 | 0 | 10735
????? | SJ 28-6 #22A | 450 | 3003922299 | 2136 | 1707 | 1303 | 939 | 1658 | 1674 | 2025 | 1686 | 1699 | 0 | 0 | 0 | 14827
????? | SJ 28-6 #23 | 450 | 3003907104 | 2337 | 2119 | 1623 | 1615 | 1530 | 1732 | 1965 | 1821 | 1469 | 0 | 0 | 0 | 16211
????? | SJ 28-6 #25 | 450 | 3003907098 | 2000 | 1524 | 0 | 1141 | 1410 | 1325 | 1435 | 2597 | 2647 | 0 | 0 | 0 | 14079
????? | SJ 28-6 #27 | 450 | 3003907087 | 3839 | 3563 | 3319 | 3321 | 2867 | 3396 | 3689 | 3410 | 3523 | 0 | 0 | 0 | 30927
????? | SJ 28-6 #27A | 450 | 3003922226 | 0 | 0 | 1927 | 2057 | 2248 | 2867 | 2997 | 1501 | 1659 | 0 | 0 | 0 | 15256
????? | SJ 28-6 #64 | 450 | 3003907032 | 1305 | 1228 | 1358 | 1384 | 1265 | 1120 | 890 | 674 | 678 | 0 | 0 | 0 | 9902
????? | SJ 28-6 #67A | 450 | 3003922225 | 1043 | 813 | 698 | 2168 | 2131 | 2204 | 2066 | 1850 | 389 | 0 | 0 | 0 | 13362
????? | SJ 28-6 #68 | 450 | 3003907058 | 0 | 0 | 466 | 419 | 91 | 397 | 389 | 413 | 325 | 0 | 0 | 0 | 2500
????? | SJ 28-6 #68 | 450 | 3003907058 | 1176 | 1036 | 465 | 1012 | 1147 | 1042 | 1166 | 1025 | 908 | 0 | 0 | 0 | 8977
????? | SJ 28-6 #69 | 450 | 3003906957 | 884 | 820 | 857 | 763 | 159 | 805 | 863 | 766 | 849 | 0 | 0 | 0 | 6766
????? | SJ 28-6 #69 | 450 | 3003906957 | 1718 | 1591 | 1663 | 1481 | 308 | 1562 | 1676 | 1487 | 1647 | 0 | 0 | 0 | 13133
????? | SJ 28-6 #69A | 450 | 3003922228 | 1279 | 797 | 281 | 836 | 2575 | 2116 | 2107 | 1740 | 1209 | 0 | 0 | 0 | 12940
????? | SJ 28-6 #70 | 450 | 3003906870 | 944 | 861 | 907 | 764 | 712 | 724 | 765 | 470 | 372 | 0 | 0 | 0 | 6519
????? | SJ 28-6 #70 | 450 | 3003906870 | 2202 | 2006 | 2117 | 1783 | 1663 | 1691 | 1784 | 1097 | 870 | 0 | 0 | 0 | 15213
????? | SJ 28-6 #79 | 450 | 3003907110 | 0 | 394 | 0 | 298 | 547 | 416 | 348 | 382 | 340 | 0 | 0 | 0 | 2725
????? | SJ 28-6 #79 | 450 | 3003907110 | 0 | 1928 | 0 | 1453 | 2667 | 2032 | 1696 | 1864 | 1658 | 0 | 0 | 0 | 13298
????? | SJ 28-6 #85 | 450 | 3003906900 | 463 | 0 | 0 | 0 | 0 | 39 | 616 | 1901 | 2191 | 0 | 0 | 0 | 5210
????? | SJ 28-6 #85 | 450 | 3003906900 | 726 | 0 | 0 | 176 | 7 | 17 | 263 | 814 | 940 | 0 | 0 | 0 | 2943
????? | SJ 28-6 #86 | 450 | 3003906997 | 927 | 877 | 972 | 735 | 634 | 320 | 354 | 727 | 772 | 0 | 0 | 0 | 6318
????? | SJ 28-6 #86 | 450 | 3003906997 | 2640 | 2494 | 2767 | 2091 | 1807 | 910 | 1009 | 2069 | 2196 | 0 | 0 | 0 | 17983
????? | SJ 28-6 #110 | 450 | 3003982369 | 3139 | 2829 | 2247 | 3257 | 3074 | 1200 | 1585 | 1156 | 1306 | 0 | 0 | 0 | 19793
????? | SJ 28-6 #110M | 450 | 3003927030 | 2605 | 2290 | 737 | 3910 | 3420 | 3321 | 3376 | 3088 | 3250 | 0 | 0 | 0 | 25997
????? | SJ 28-6 #110M | 450 | 3003927030 | 2822 | 2481 | 798 | 4236 | 3706 | 3598 | 3657 | 3346 | 3521 | 0 | 0 | 0 | 28165
????? | SJ 28-6 #111 | 450 | 3003982368 | 2577 | 2508 | 2536 | 891 | 9 | 0 | 3152 | 5335 | 4518 | 0 | 0 | 0 | 21526
????? | SJ 28-6 #111E | 450 | 3003930062 | 818 | 530 | 948 | 1796 | 1603 | 1217 | 855 | 2244 | 1858 | 0 | 0 | 0 | 11869
????? | SJ 28-6 #111M | 450 | 3003929660 | 2562 | 2265 | 1390 | 2421 | 2098 | 2153 | 2153 | 2002 | 2061 | 0 | 0 | 0 | 19105
????? | SJ 28-6 #111M | 450 | 3003929660 | 4364 | 3857 | 2366 | 4121 | 3573 | 3665 | 3666 | 3409 | 3510 | 0 | 0 | 0 | 32531
????? | SJ 28-6 #111P | 450 | 3003930694 | 12475 | 8575 | 12069 | 11227 | 15986 | 13695 | 13292 | 10620 | 12163 | 0 | 0 | 0 | 110102
????? | SJ 28-6 #111P | 450 | 3003930694 | 9802 | 6737 | 9483 | 8821 | 12560 | 10760 | 10444 | 8345 | 9556 | 0 | 0 | 0 | 86508
????? | SJ 28-6 #112 | 450 | 3003907099 | 1256 | 1122 | 354 | 1071 | 1151 | 1241 | 1306 | 1328 | 1241 | 0 | 0 | 0 | 10070
????? | SJ 28-6 #112 | 450 | 3003907099 | 3228 | 2884 | 909 | 2755 | 2960 | 3193 | 3360 | 3417 | 3191 | 0 | 0 | 0 | 25897
????? | SJ 28-6 #146 | 450 | 3003920274 | 2073 | 1792 | 1902 | 1780 | 1551 | 2086 | 1812 | 2181 | 1726 | 0 | 0 | 0 | 16903
????? | SJ 28-6 #146M | 450 | 3003926976 | 1695 | 1380 | 728 | 1923 | 1507 | 1551 | 1591 | 1533 | 1524 | 0 | 0 | 0 | 13432
????? | SJ 28-6 #146M | 450 | 3003926976 | 3439 | 2802 | 1476 | 3904 | 3058 | 3148 | 3229 | 3112 | 3094 | 0 | 0 | 0 | 27262
????? | SJ 28-6 #146N | 450 | 3003929583 | 619 | 508 | 0 | 642 | 503 | 487 | 161 | 641 | 670 | 0 | 0 | 0 | 4231
????? | SJ 28-6 #146N | 450 | 3003929583 | 3806 | 3114 | 0 | 3943 | 3088 | 2996 | 990 | 3941 | 4115 | 0 | 0 | 0 | 25993
????? | SJ 28-6 #157 | 450 | 3003920399 | 8288 | 6745 | 0 | 8829 | 7821 | 7363 | 8339 | 8000 | 7644 | 0 | 0 | 0 | 63029
????? | SJ 28-6 #157 | 450 | 3003920399 | 624 | 507 | 0 | 665 | 589 | 554 | 628 | 602 | 576 | 0 | 0 | 0 | 4745
????? | SJ 28-6 #157M | 450 | 3003925452 | 5222 | 4803 | 3702 | 4232 | 4027 | 2393 | 5227 | 5315 | 4308 | 0 | 0 | 0 | 39229
????? | SJ 28-6 #157M | 450 | 3003925452 | 1225 | 1126 | 869 | 992 | 945 | 561 | 1226 | 1247 | 1010 | 0 | 0 | 0 | 9201
????? | SJ 28-6 #168 | 450 | 3003920480 | 179 | 178 | 196 | 193 | 194 | 192 | 175 | 106 | 130 | 0 | 0 | 0 | 1543
????? | SJ 28-6 #168 | 450 | 3003920480 | 3418 | 3391 | 3742 | 3677 | 3673 | 3650 | 3307 | 2005 | 2488 | 0 | 0 | 0 | 29351
????? | SJ 28-6 #168E | 450 | 3003930043 | 2664 | 2477 | 1907 | 2907 | 2199 | 2362 | 2300 | 2322 | 2424 | 0 | 0 | 0 | 21562
????? | SJ 28-6 #168M | 450 | 3003927029 | 2905 | 2585 | 2746 | 2465 | 2436 | 2502 | 2565 | 2548 | 2455 | 0 | 0 | 0 | 23207
????? | SJ 28-6 #168M | 450 | 3003927029 | 4012 | 3572 | 3792 | 3405 | 3364 | 3455 | 3542 | 3520 | 3391 | 0 | 0 | 0 | 32053
????? | SJ 28-6 #170N | 450 | 3003929573 | 1787 | 1592 | 1697 | 645 | 1002 | 20 | 1039 | 2596 | 1818 | 0 | 0 | 0 | 12196
????? | SJ 28-6 #170N | 450 | 3003929573 | 9387 | 8356 | 8910 | 3391 | 5259 | 107 | 5453 | 13629 | 9545 | 0 | 0 | 0 | 64037
????? | SJ 28-6 #171 | 450 | 3003920476 | 3356 | 3101 | 2661 | 2420 | 2294 | 2268 | 1737 | 2174 | 0 | 0 | 0 | 0 | 20011
????? | SJ 28-6 #171M | 450 | 3003925919 | 1017 | 228 | 84 | 883 | 747 | 35 | 804 | 39 | 1174 | 0 | 0 | 0 | 5011
????? | SJ 28-6 #171M | 450 | 3003925919 | 3603 | 807 | 296 | 3133 | 2647 | 126 | 2848 | 138 | 4162 | 0 | 0 | 0 | 17760
????? | SJ 28-6 #179 | 450 | 3003920669 | 0 | 0 | 0 | 1308 | 1737 | 1512 | 1302 | 1173 | 1102 | 0 | 0 | 0 | 8134
????? | SJ 28-6 #179 | 450 | 3003920669 | 0 | 0 | 0 | 2563 | 3403 | 2964 | 2552 | 2298 | 2161 | 0 | 0 | 0 | 15941
????? | SJ 28-6 #179 | 450 | 3003920669 | 0 | 0 | 0 | 1360 | 1807 | 1574 | 1354 | 1220 | 1147 | 0 | 0 | 0 | 8462
????? | SJ 28-6 #179N | 450 | 3003930570 | 9016 | 5470 | 8862 | 8894 | 7005 | 3429 | 9454 | 7688 | 6932 | 0 | 0 | 0 | 66750
????? | SJ 28-6 #179N | 450 | 3003930570 | 3507 | 2126 | 3447 | 3458 | 2725 | 1333 | 3677 | 2990 | 2695 | 0 | 0 | 0 | 25958
????? | SJ 28-6 #181 | 450 | 3003920668 | 2980 | 2294 | 1351 | 0 | 2453 | 1763 | 1245 | 1039 | 865 | 0 | 0 | 0 | 13990
????? | SJ 28-6 #181M | 450 | 3003925770 | 180 | 0 | 0 | 204 | 761 | 549 | 592 | 424 | 463 | 0 | 0 | 0 | 3173
????? | SJ 28-6 #181M | 450 | 3003925770 | 1209 | 0 | 115 | 1363 | 5091 | 3677 | 3961 | 2839 | 3099 | 0 | 0 | 0 | 21354
????? | SJ 28-6 #181N | 450 | 3003930627 | 5462 | 5774 | 5005 | 6537 | 7743 | 6527 | 5856 | 5371 | 4192 | 0 | 0 | 0 | 52467
????? | SJ 28-6 #181N | 450 | 3003930627 | 10145 | 10722 | 9295 | 12139 | 14380 | 12122 | 10875 | 9975 | 7785 | 0 | 0 | 0 | 97438
????? | SJ 28-6 #183N | 450 | 3003930543 | 1522 | 1475 | 512 | 1784 | 1841 | 1727 | 4168 | 3815 | 3224 | 0 | 0 | 0 | 20068
????? | SJ 28-6 #183N | 450 | 3003930543 | 2593 | 2511 | 873 | 3037 | 3135 | 2939 | 7409 | 6781 | 5731 | 0 | 0 | 0 | 35009
????? | SJ 28-6 #204 | 450 | 3003920846 | 0 | 0 | 0 | 0 | 0 | 0 | 4514 | 6532 | 5182 | 0 | 0 | 0 | 16228
????? | SJ 28-6 #204M | 450 | 3003929767 | 520 | 355 | 220 | 448 | 397 | 418 | 473 | 467 | 429 | 0 | 0 | 0 | 3727
????? | SJ 28-6 #204M | 450 | 3003929767 | 6911 | 4723 | 2928 | 5955 | 5273 | 5560 | 6289 | 6212 | 5701 | 0 | 0 | 0 | 49552
????? | SJ 28-6 #204N | 450 | 3003930568 | 6414 | 2526 | 6552 | 5544 | 4671 | 2957 | 4832 | 3685 | 3690 | 0 | 0 | 0 | 40871
????? | SJ 28-6 #204N | 450 | 3003930568 | 6163 | 2428 | 6296 | 5326 | 4489 | 2840 | 4644 | 3541 | 3545 | 0 | 0 | 0 | 39272
????? | SJ 28-6 #205 | 450 | 3003920850 | 0 | 0 | 0 | 567 | 1721 | 1769 | 2271 | 2226 | 1914 | 0 | 0 | 0 | 10468
????? | SJ 28-6 #205 | 450 | 3003920850 | 0 | 0 | 0 | 1705 | 5164 | 5309 | 6811 | 6678 | 5744 | 0 | 0 | 0 | 31411
????? | SJ 28-6 #205M | 450 | 3003925708 | 2010 | 1886 | 2017 | 1776 | 1724 | 1840 | 2056 | 1938 | 1984 | 0 | 0 | 0 | 17231
????? | SJ 28-6 #205M | 450 | 3003925708 | 3143 | 2951 | 3155 | 2779 | 2697 | 2878 | 3215 | 3031 | 3104 | 0 | 0 | 0 | 26953
????? | SJ 28-6 #206M | 450 | 3003925766 | 1776 | 1732 | 1224 | 1784 | 1473 | 1511 | 1594 | 1492 | 1555 | 0 | 0 | 0 | 14141
????? | SJ 28-6 #206M | 450 | 3003925766 | 5942 | 5796 | 4093 | 5977 | 4929 | 5064 | 5335 | 4993 | 5209 | 0 | 0 | 0 | 47338
????? | SJ 28-6 #207 | 450 | 3003920849 | 1909 | 2064 | 1630 | 2074 | 1050 | 1299 | 1107 | 1326 | 2056 | 0 | 0 | 0 | 14515
????? | SJ 28-6 #207N | 450 | 3003929431 | 463 | 166 | 36 | 189 | 1652 | 1 | 932 | 1187 | 1458 | 0 | 0 | 0 | 6084
????? | SJ 28-6 #207N | 450 | 3003929431 | 2108 | 757 | 163 | 859 | 7525 | 4 | 4246 | 5407 | 6640 | 0 | 0 | 0 | 27709
????? | SJ 28-6 #207P | 450 | 3003930613 | 7019 | 5617 | 347 | 5024 | 6270 | 3551 | 5710 | 4798 | 4585 | 0 | 0 | 0 | 42921
????? | SJ 28-6 #207P | 450 | 3003930613 | 8932 | 7149 | 441 | 6394 | 7979 | 4519 | 7268 | 6106 | 5835 | 0 | 0 | 0 | 54623
????? | SJ 28-6 #209 | 450 | 3003920845 | 756 | 590 | 582 | 652 | 1403 | 1633 | 671 | 1260 | 1456 | 0 | 0 | 0 | 9003
????? | SJ 28-6 #209M | 450 | 3003927023 | 0 | 0 | 0 | 1507 | 274 | 0 | 1340 | 2578 | 2459 | 0 | 0 | 0 | 8158
????? | SJ 28-6 #209M | 450 | 3003927023 | 0 | 0 | 2 | 3201 | 581 | 0 | 2848 | 5478 | 5227 | 0 | 0 | 0 | 17337
????? | SJ 28-6 NP #422 | 450 | 3003925018 | 1093 | 659 | 625 | 934 | 839 | 666 | 569 | 522 | 589 | 0 | 0 | 0 | 6496
 | MONTHLY TOTALS |  |  | 258574 | 206888 | 170067 | 257151 | 277123 | 230280 | 295303 | 295106 | 283735 | 0 | 0 | 0 | 2274227