Spreadsheet: 134733d1325604696-help-modifying-formula-to-remove-the-need-for-helper-columns-monthtest
Sheet: Sheet2

Rest Number | Franchisee | Rest Type | Started | Audit Start Time | AudtorNum | Quarter | [NAME] | Score | Month | Year
2201 | Franchise 1 | Franchise | 2010-01-26 00:00:00 | 13:39:00 | 9728 | 1 | 1 | 91 | 1 | 2010
1874 | Franchise 1 | Franchise | 2010-02-03 00:00:00 | 13:34:00 | 9734 | 1 | 1 | 76 | 2 | 2010
2079 | Franchise 1 | Franchise | 2010-02-04 00:00:00 | 10:15:00 | 9766 | 1 | 1 | 88 | 2 | 2010
1493 | Franchise 1 | Franchise | 2010-02-23 00:00:00 | 16:31:00 | 9496 | 1 | 1 | 85 | 2 | 2010
1495 | Franchise 1 | Franchise | 2010-02-25 00:00:00 | 17:15:00 | 1081 | 1 | 1 | 79 | 2 | 2010
1490 | Franchise 1 | Franchise | 2010-02-26 00:00:00 | 15:23:00 | 9471 | 1 | 1 | 91 | 2 | 2010
1494 | Franchise 1 | Franchise | 2010-03-02 00:00:00 | 14:53:00 | 9496 | 1 | 1 | 82 | 3 | 2010
1533 | Franchise 1 | Franchise | 2010-03-02 00:00:00 | 13:31:00 | 9558 | 1 | 1 | 91 | 3 | 2010
1491 | Franchise 1 | Franchise | 2010-03-08 00:00:00 | 10:01:00 | 9471 | 1 | 1 | 88 | 3 | 2010
1492 | Franchise 1 | Franchise | 2010-03-12 00:00:00 | 10:54:00 | 9354 | 1 | 1 | 85 | 3 | 2010
1873 | Franchise 1 | Franchise | 2010-03-13 00:00:00 | 11:00:00 | 391 | 1 | 1 | 91 | 3 | 2010
1875 | Franchise 1 | Franchise | 2010-03-18 00:00:00 | 13:50:00 | 9410 | 1 | 1 | 67 | 3 | 2010
1495 | Franchise 1 | Franchise | 2010-05-17 00:00:00 | 09:15:00 | 1081 | 2 | 1 | 61 | 5 | 2010
1493 | Franchise 1 | Franchise | 2010-06-06 00:00:00 | 11:38:00 | 9496 | 2 | 1 | 82 | 6 | 2010
1494 | Franchise 1 | Franchise | 2010-06-06 00:00:00 | 13:57:00 | 9496 | 2 | 1 | 76 | 6 | 2010
1490 | Franchise 1 | Franchise | 2010-06-08 00:00:00 | 11:40:00 | 9471 | 2 | 1 | 82 | 6 | 2010
1491 | Franchise 1 | Franchise | 2010-06-08 00:00:00 | 16:32:00 | 9471 | 2 | 1 | 88 | 6 | 2010
2201 | Franchise 1 | Franchise | 2010-06-09 00:00:00 | 13:36:00 | 9728 | 2 | 1 | 88 | 6 | 2010
1873 | Franchise 1 | Franchise | 2010-06-11 00:00:00 | 13:00:00 | 1081 | 2 | 1 | 82 | 6 | 2010
2079 | Franchise 1 | Franchise | 2010-06-11 00:00:00 | 12:30:00 | 9766 | 2 | 1 | 49 | 6 | 2010
1875 | Franchise 1 | Franchise | 2010-06-12 00:00:00 | 09:59:00 | 9410 | 2 | 1 | 85 | 6 | 2010
1874 | Franchise 1 | Franchise | 2010-06-15 00:00:00 | 14:36:00 | 9734 | 2 | 1 | 79 | 6 | 2010
1492 | Franchise 1 | Franchise | 2010-06-16 00:00:00 | 09:37:00 | 9354 | 2 | 1 | 100 | 6 | 2010
1533 | Franchise 1 | Franchise | 2010-06-17 00:00:00 | 15:37:00 | 9558 | 2 | 1 | 97 | 6 | 2010
1493 | Franchise 1 | Franchise | 2010-08-18 00:00:00 | 14:51:00 | 9354 | 3 | 1 | 76 | 8 | 2010
1494 | Franchise 1 | Franchise | 2010-08-19 00:00:00 | 13:58:00 | 9354 | 3 | 1 | 97 | 8 | 2010
1490 | Franchise 1 | Franchise | 2010-09-04 00:00:00 | 12:25:00 | 9471 | 3 | 1 | 94 | 9 | 2010
1492 | Franchise 1 | Franchise | 2010-09-07 00:00:00 | 15:23:00 | 9354 | 3 | 1 | 94 | 9 | 2010
1491 | Franchise 1 | Franchise | 2010-09-07 00:00:00 | 14:58:00 | 9471 | 3 | 1 | 76 | 9 | 2010
2201 | Franchise 1 | Franchise | 2010-09-09 00:00:00 | 10:34:00 | 9728 | 3 | 1 | 94 | 9 | 2010
1873 | Franchise 1 | Franchise | 2010-09-11 00:00:00 | 12:27:00 | 9645 | 3 | 1 | 91 | 9 | 2010
1495 | Franchise 1 | Franchise | 2010-09-12 00:00:00 | 11:30:00 | 1081 | 3 | 1 | 85 | 9 | 2010
2079 | Franchise 1 | Franchise | 2010-09-13 00:00:00 | 10:33:00 | 9766 | 3 | 1 | 100 | 9 | 2010
1874 | Franchise 1 | Franchise | 2010-09-13 00:00:00 | 10:01:00 | 9734 | 3 | 1 | 91 | 9 | 2010
1533 | Franchise 1 | Franchise | 2010-09-13 00:00:00 | 15:16:00 | 9558 | 3 | 1 | 100 | 9 | 2010
1875 | Franchise 1 | Franchise | 2010-09-15 00:00:00 | 19:16:00 | 9410 | 3 | 1 | 91 | 9 | 2010
1490 | Franchise 1 | Franchise | 2010-10-18 00:00:00 | 16:46:00 | 9471 | 4 | 1 | 94 | 10 | 2010
2201 | Franchise 1 | Franchise | 2010-10-20 00:00:00 | 11:04:00 | 9728 | 4 | 1 | 97 | 10 | 2010
1873 | Franchise 1 | Franchise | 2010-10-22 00:00:00 | 13:19:00 | 9448 | 4 | 1 | 97 | 10 | 2010
1533 | Franchise 1 | Franchise | 2010-10-26 00:00:00 | 14:28:00 | 9558 | 4 | 1 | 97 | 10 | 2010
2201 | Franchise 1 | Franchise | 2011-02-10 09:58:00 | 2011-02-10 09:58:00 | 9728 | 1 | 1 | 94 | 2 | 2011
1490 | Franchise 1 | Franchise | 2011-02-11 13:46:00 | 2011-02-11 13:46:00 | 9471 | 1 | 1 | 80 | 2 | 2011
1491 | Franchise 1 | Franchise | 2011-02-17 15:00:00 | 2011-02-17 15:00:00 | 9471 | 1 | 1 | 64 | 2 | 2011
1874 | Franchise 1 | Franchise | 2011-02-19 14:36:00 | 2011-02-19 14:36:00 | 9734 | 1 | 1 | 93 | 2 | 2011
1494 | Franchise 1 | Franchise | 2011-02-19 17:00:00 | 2011-02-19 17:00:00 | 9496 | 1 | 1 | 73 | 2 | 2011
1492 | Franchise 1 | Franchise | 2011-02-22 09:42:00 | 2011-02-22 09:42:00 | 9354 | 1 | 1 | 85 | 2 | 2011
1493 | Franchise 1 | Franchise | 2011-02-23 15:18:00 | 2011-02-23 15:18:00 | 9496 | 1 | 1 | 94 | 2 | 2011
1495 | Franchise 1 | Franchise | 2011-02-24 09:35:00 | 2011-02-24 09:35:00 | 1081 | 1 | 1 | 83 | 2 | 2011
1875 | Franchise 1 | Franchise | 2011-03-01 14:51:00 | 2011-03-01 14:51:00 | 9410 | 1 | 1 | 87 | 3 | 2011
1873 | Franchise 1 | Franchise | 2011-03-08 16:25:00 | 2011-03-08 16:25:00 | 9410 | 1 | 1 | 85 | 3 | 2011