Find possible missing data based on prior data

[sycodiz]

I am looking to create a code that will find possible missing data based on prior data. Let me explain a little.

If every Wednesday and Thursday I receive a vendor- we'll say Frito Lay- I have a pattern. If I miss a day, I would like the code to tell me I may be missing a day.

The data I receive is similar to this...

Vend #	Vendor	PWS Date	Invoice Date	Cost	Retail
143	Frito Lay	1/16/2017	1/16/2017	100	150
143	Frito Lay	1/19/2017	1/19/2017	80	130
143	Frito Lay	1/26/2017	1/26/2017	90	140
143	Frito Lay	1/30/2017	1/30/2017	80	130
143	Frito Lay	2/6/2017	2/6/2017	90	140
143	Frito Lay	2/9/2017	2/9/2017	100	150
143	Frito Lay	2/13/2017	2/13/2017	100	150
143	Frito Lay	2/16/2017	2/16/2017	100	150
21	Soda Guy	1/6/2017	1/6/2017	1000	1500
21	Soda Guy	1/13/2017	1/13/2017	800	1300
21	Soda Guy	1/27/2017	1/27/2017	1200	1700
21	Soda Guy	2/3/2017	2/3/2017	900	1400

<tbody>
</tbody>

The code should look at each vendor number separately. Then it will find the pattern of every time this vendor delivers. If a date is missing, I need it to tell me that.

By the way I have no clue on how to do this. I know how to write simple code but this is way too complex for me. I have no idea if this can even be created. Please let me know if anyone can help.
Thanks in advance!

 

[DILIPandey]

Hi Sycodiz,

You can have another column with below formula which can give you Day as well and then you can easily find out if any a Wed or Thur is missing.

= text (a1,"DDDD")

where a1 would be the date as per your table.

You can also use conditional formatting applied on your table and for that you need to define the days for each vendor.


Regards,
DILIPandey

 

[sycodiz]

That will help out a lot when we manually have to look. The problem lies when we don't know the days in advance and we have over 1000 stores. Thanks again.

 

[Eric W]

Are the patterns you're expecting weekly, monthly, or something else? Let's say they're weekly. I could write a program that reads your data, and pulls out all the dates for a given vendor. Say we have a year of data. Then we create a table with 7 entries, one for each day of the week. We add up all the Sundays and put them in the first bucket, all the Mondays and put them in the second bucket, etc. At the end you'd have something like:

Sunday: 0
Monday: 1
Tuesday: 48
Wednesday: 4
Thursday: 47
Friday: 3
Saturday: 0

Based on that table, we can say that Tuesdays and Thursdays are the most common days you get an invoice. We'd actually calculate something like 48/52 = 92%, and we look at weekdays with a threshold of over 50%. Finally, we can see that there are 48 Tuesdays out of 52, so we'd create a list of the 4 Tuesdays missing, and the 5 Thursdays missing, and that list should be what you're looking for. I'd expect that you'd get a pattern similar to the one above, where the missing invoices were actually just presented a day late, but you'd need to manually check that out.

It would be a bit more complicated since we're not going to be looking at exactly a year. We'd probably want to set an upper limit of a year, so that if the patterns change over time, the program would gradually adapt.

If you're looking for monthly patterns, you'd create a table of 31 entries and use the same type of logic.


Let me know what you think.

 

[sycodiz]

Yes looking for something very similar. We usually run this report 90 or 180 days. We are looking for weekly trends. This is what the data actually looks like. Could not find a place to attach file. Changed some real data but the cells are all there. The columns that we care about are C, E, F, I, and K. All the rest are there because that is how the file downloads to us. I believe this file was run for about 90 days. Thanks for all your help!

PaperworkDate_1	textbox35	VendorID	VendorName	InvoiceNo	InvoiceDate	Status	Source	Quantity	ExtCost	RetailInv	textbox38	CostInv	textbox5	expense	adjustment_type	textbox102	textbox119	textbox13	textbox34	textbox37	textbox40	textbox41	textbox42	textbox43	textbox15	textbox121
Date of Entry: 12/12/2016	Purchase	1013	Grocery Vendor	1280520508	12/12/2016	Posted	Imp@Host	$2,116.61				$2,079.84		$36.77			$2,079.84		Purchase(s) Total	$2,116.61				$2,079.84		$36.77
Date of Entry: 12/15/2016	Purchase	1012	Novelty Vendor	SI332997	12/15/2016	Posted	Imp@Host	$2,009.21	$2,009.21	$3,764.41	46.63%					$3,764.41			Purchase(s) Total	$6,076.09	$5,996.09	$9,064.04	33.85%			$80.00
Date of Entry: 12/15/2016	Purchase	1012	Novelty Vendor	SI333001	12/15/2016	Posted	Imp@Host	$3,986.88	$3,986.88	$5,299.63	24.77%					$5,299.63			Purchase(s) Total	$6,076.09	$5,996.09	$9,064.04	33.85%			$80.00
Date of Entry: 1/1/2017	Purchase	1002	Ice Cream Vendor	8033516738	12/16/2016	Posted	Imp@Host	$434.00	$434.00	$714.20	39.23%					$714.20			Purchase(s) Total	$2,789.89	$2,689.68	$4,676.57	42.49%	$82.33		$17.88
Date of Entry: 1/1/2017	Purchase	1004	Energy Drink Vendor	3131635112	12/16/2016	Posted	Imp@Host	$1,323.90	$1,323.90	$2,175.36	39.14%					$2,175.36			Purchase(s) Total	$2,789.89	$2,689.68	$4,676.57	42.49%	$82.33		$17.88
Date of Entry: 12/16/2016	Purchase	1005	Soda Vendor	4195126301	12/16/2016	Posted	Imp@Host	$4,718.69	$4,718.69	$8,718.77	45.88%			$0.00		$8,718.77			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1006	Soda Vendor 2	7735670016	12/16/2016	Posted	Imp@Host	$748.59	$748.59	$1,324.10	43.46%			$0.00		$1,324.10			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1006	Soda Vendor 2	7735670017	12/16/2016	Posted	Imp@Host	$0.00						$0.00					Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1010	Beer Vendor	437810	12/16/2016	Posted	Imp@Host	$4,519.93	$4,519.93	$5,665.30	20.22%					$5,665.30			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1010	Beer Vendor	437811	12/16/2016	Posted	Imp@Host	$250.25	$250.25	$634.99	60.59%					$634.99			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1011	Cost Food Vendor	12151811	12/16/2016	Posted	Imp@Host	$5,741.19				$5,453.19		$288.00			$5,453.19		Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1011	Cost Food Vendor	12163828	12/16/2016	Posted	Imp@Host	$68.48				$68.48		$0.00			$68.48		Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1011	Cost Food Vendor	12163852	12/16/2016	Posted	Imp@Host	$51.36				$51.36		$0.00			$51.36		Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1011	Cost Food Vendor	12164064	12/16/2016	Posted	Imp@Host	($45.12)				($45.12)		$0.00			($45.12)		Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1013	Grocery Vendor	1286547911	12/16/2016	Posted	Imp@Host	$203.39	$203.39	$353.41	42.45%					$353.41			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1016	Soda Vendor 3	90218303	12/16/2016	Posted	Imp@Host	$2,517.90	$2,517.90	$3,611.04	30.27%					$3,611.04			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1017	Chip Vendor 2	75441091	12/16/2016	Posted	Imp@Host	$277.77	$277.77	$435.27	36.18%					$435.27			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1018	Novelty Vendor 2	1665605633	12/16/2016	Posted	Imp@Host	$4,476.20	$4,476.20	$7,993.35	44.00%					$7,993.35			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1019	Beer Vendor 2	457759	12/16/2016	Posted	Imp@Host	$117.44	$117.44	$160.99	27.05%					$160.99			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1019	Beer Vendor 2	457760	12/16/2016	Posted	Imp@Host	$12,810.27	$12,810.27	$15,681.69	18.31%					$15,681.69			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1020	Energy Drink Vendor 2	1947-1569	12/16/2016	Posted	Imp@Host	$1,123.30	$1,123.30	$2,004.51	43.96%					$2,004.51			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/16/2016	Purchase	1020	Energy Drink Vendor 2	1947-1570	12/16/2016	Posted	Imp@Host	$34.90	$34.90	$62.16	43.85%					$62.16			Purchase(s) Total	$37,614.54	$31,798.63	$46,645.58	31.83%	$5,527.91		$288.00
Date of Entry: 12/17/2016	Purchase	1013	Grocery Vendor	1280547731	12/17/2016	Posted	Imp@Host	$45,746.03	$39,678.17	$53,941.76	26.44%	$1,246.82		$4,821.04		$53,941.76	$1,246.82		Purchase(s) Total	$46,126.03	$39,678.17	$53,941.76	26.44%	$1,246.82		$5,201.04
Date of Entry: 12/17/2016	Purchase	1013	Grocery Vendor	1282547731	12/17/2016	Posted	Imp@Host	$380.00						$380.00					Purchase(s) Total	$46,126.03	$39,678.17	$53,941.76	26.44%	$1,246.82		$5,201.04
Date of Entry: 12/20/2016	Purchase	1003	Propane Vendor	8485001256	12/20/2016	Posted	Imp@Host	$210.42	$210.42	$419.79	49.87%					$419.79			Purchase(s) Total	$210.42	$210.42	$419.79	49.87%
Date of Entry: 12/21/2016	Purchase	1012	Novelty Vendor	SC208761	12/20/2016	Posted	Imp@Host	($21.35)	($21.35)	($40.15)	46.82%					($40.15)			Purchase(s) Total	$896.16	$1,086.16	$1,570.84	30.85%			($190.00)
Date of Entry: 12/21/2016	Purchase	1008	Chip Vendor	36996014	12/21/2016	Posted	Imp@Host	$1,206.03	$1,206.03	$1,755.52	31.30%					$1,755.52			Purchase(s) Total	$896.16	$1,086.16	$1,570.84	30.85%			($190.00)
Date of Entry: 12/21/2016	Purchase	1008	Chip Vendor	36996072	12/21/2016	Posted	Imp@Host	($98.52)	($98.52)	($144.53)	31.83%					($144.53)			Purchase(s) Total	$896.16	$1,086.16	$1,570.84	30.85%			($190.00)
Date of Entry: 12/21/2016	Purchase	1013	Grocery Vendor	1282551767	12/21/2016	Posted	Imp@Host	($190.00)						($190.00)					Purchase(s) Total	$896.16	$1,086.16	$1,570.84	30.85%			($190.00)
Date of Entry: 12/22/2016	Purchase	1010	Beer Vendor	438231	12/22/2016	Posted	Imp@Host	$5,353.77	$5,353.77	$5,484.59	2.39%					$5,484.59			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1010	Beer Vendor	438232	12/22/2016	Posted	Imp@Host	$67.45	$67.45	$226.20	70.18%					$226.20			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1011	Cost Food Vendor	12210943	12/22/2016	Posted	Imp@Host	$2,066.54				$2,066.54		$0.00			$2,066.54		Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1011	Cost Food Vendor	12210944	12/22/2016	Posted	Imp@Host	$7.39	$7.39	$0.00				$0.00		$0.00			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1011	Cost Food Vendor	12210945	12/22/2016	Posted	Imp@Host	$176.09				$176.09		$0.00			$176.09		Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1011	Cost Food Vendor	12221908	12/22/2016	Posted	Imp@Host	$17.16				$17.16		$0.00			$17.16		Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1013	Grocery Vendor	1280551767	12/22/2016	Posted	Imp@Host	$7,245.88	$4,920.75	$7,974.60	38.29%	$919.52		$1,405.61		$7,974.60	$919.52		Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1016	Soda Vendor 3	84746401	12/22/2016	Posted	Imp@Host	$777.90	$777.90	$611.71	-27.17%					$611.71			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1017	Chip Vendor 2	75441114	12/22/2016	Posted	Imp@Host	$112.60	$112.60	$177.10	36.42%					$177.10			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/22/2016	Purchase	1019	Beer Vendor 2	462199	12/22/2016	Posted	Imp@Host	$23.40	$23.40	$23.40	0.00%					$23.40			Purchase(s) Total	$15,848.18	$11,263.26	$14,497.60	22.31%	$3,179.31		$1,405.61
Date of Entry: 12/23/2016	Purchase	1008	Chip Vendor	36996071	12/23/2016	Posted	Imp@Host	$436.74	$436.74	$695.40	37.20%					$695.40			Purchase(s) Total	$436.74	$436.74	$695.40	37.20%
Date of Entry: 12/25/2016	Purchase	1013	Grocery Vendor	1280554498	12/25/2016	Posted	Imp@Host	$3,145.20	$2,390.19	$4,507.91	46.98%			$755.01		$4,507.91			Purchase(s) Total	$2,965.20	$2,390.19	$4,507.91	46.98%			$575.01
Date of Entry: 12/25/2016	Purchase	1013	Grocery Vendor	1282554498	12/25/2016	Posted	Imp@Host	($180.00)						($180.00)					Purchase(s) Total	$2,965.20	$2,390.19	$4,507.91	46.98%			$575.01
Date of Entry: 12/26/2016	Purchase	1007	Sandwich Vendor	12235827	12/26/2016	Posted	Imp@Host	$154.00	$154.00	$246.08	37.42%					$246.08			Purchase(s) Total	$1,264.01	$1,264.01	$2,038.56	37.99%
Date of Entry: 12/26/2016	Purchase	1008	Chip Vendor	36996103	12/26/2016	Posted	Imp@Host	$678.93	$678.93	$1,084.87	37.42%					$1,084.87			Purchase(s) Total	$1,264.01	$1,264.01	$2,038.56	37.99%
Date of Entry: 12/26/2016	Purchase	1008	Chip Vendor	36996127	12/26/2016	Posted	Imp@Host	($16.72)	($16.72)	($26.08)	35.89%					($26.08)			Purchase(s) Total	$1,264.01	$1,264.01	$2,038.56	37.99%
Date of Entry: 12/26/2016	Purchase	1008	Chip Vendor	36996129	12/26/2016	Posted	Imp@Host	$193.94	$193.94	$313.67	38.17%					$313.67			Purchase(s) Total	$1,264.01	$1,264.01	$2,038.56	37.99%
Date of Entry: 12/26/2016	Purchase	1009	Milk Vendor	14666319	12/26/2016	Posted	Imp@Host	$253.86	$253.86	$420.02	39.56%					$420.02			Purchase(s) Total	$1,264.01	$1,264.01	$2,038.56	37.99%
Date of Entry: 12/27/2016	Purchase	1005	Soda Vendor	4135016809	12/27/2016	Posted	Imp@Host	$387.90	$387.90	$732.37	47.03%			$0.00		$732.37			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1005	Soda Vendor	4135016810	12/27/2016	Posted	Imp@Host	$849.65	$849.65	$995.52	14.65%					$995.52			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1005	Soda Vendor	4135016811	12/27/2016	Posted	Imp@Host	$0.00	$0.00	$211.60	100.00%					$211.60			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1006	Soda Vendor 2	7736472224	12/27/2016	Posted	Imp@Host	$239.73	$239.73	$372.16	35.58%					$372.16			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1008	Chip Vendor	36996137	12/27/2016	Posted	Imp@Host	$199.92	$199.92	$336.24	40.54%					$336.24			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1011	Cost Food Vendor	12265817	12/27/2016	Posted	Imp@Host	$3,814.59				$3,812.14		$2.45			$3,812.14		Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1011	Cost Food Vendor	12277474	12/27/2016	Posted	Imp@Host	$92.71				$92.71		$0.00			$92.71		Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1014	Bread Vendor	84195417543	12/27/2016	Posted	Imp@Host	$49.34	$33.80	$27.86	-21.32%	$15.54				$27.86	$15.54		Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1014	Bread Vendor	84195417545	12/27/2016	Posted	Imp@Host	$281.28	$281.28	$487.28	42.28%					$487.28			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/27/2016	Purchase	1014	Bread Vendor	84195417547	12/27/2016	Posted	Imp@Host	$321.74	$321.74	$564.10	42.96%					$564.10			Purchase(s) Total	$13,528.11	$9,605.27	$11,402.13	15.76%	$3,920.39		$2.45
Date of Entry: 12/28/2016	Purchase	1010	Beer Vendor	438648	12/28/2016	Posted	Imp@Host	$53.08	$53.08	$69.04	23.12%					$69.04			Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1010	Beer Vendor	438651	12/28/2016	Posted	Imp@Host	$28.80	$28.80	$37.96	24.13%					$37.96			Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1011	Cost Food Vendor	12277963	12/28/2016	Posted	Imp@Host	$145.87				$145.87		$0.00			$145.87		Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1011	Cost Food Vendor	12289034	12/28/2016	Posted	Imp@Host	$55.84				$55.84		$0.00			$55.84		Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1011	Cost Food Vendor	12289179	12/28/2016	Posted	Imp@Host	$76.57				$76.57		$0.00			$76.57		Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1013	Grocery Vendor	1282559948	12/28/2016	Posted	Imp@Host	($10.00)						($10.00)					Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1013	Grocery Vendor	1286559948	12/28/2016	Posted	Imp@Host	($23.49)	($23.49)	($41.85)	43.87%					($41.85)			Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1019	Beer Vendor 2	466092	12/28/2016	Posted	Imp@Host	$32.00	$32.00	$59.76	46.45%					$59.76			Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/28/2016	Purchase	1019	Beer Vendor 2	466094	12/28/2016	Posted	Imp@Host	$23.40	$23.40	$32.28	27.51%					$32.28			Purchase(s) Total	$382.07	$113.79	$157.19	27.61%	$278.28		($10.00)
Date of Entry: 12/29/2016	Purchase	1011	Cost Food Vendor	12289703	12/29/2016	Posted	Imp@Host	$3,915.42				$3,851.96		$63.46			$3,851.96		Purchase(s) Total	$7,094.44	$2,052.87	$4,239.77	51.58%	$4,751.90		$289.67
Date of Entry: 12/29/2016	Purchase	1011	Cost Food Vendor	12289704	12/29/2016	Posted	Imp@Host	$14.48				$14.48		$0.00			$14.48		Purchase(s) Total	$7,094.44	$2,052.87	$4,239.77	51.58%	$4,751.90		$289.67
Date of Entry: 12/29/2016	Purchase	1013	Grocery Vendor	1280559948	12/29/2016	Posted	Imp@Host	$3,164.54	$2,052.87	$4,239.77	51.58%	$885.46		$226.21		$4,239.77	$885.46		Purchase(s) Total	$7,094.44	$2,052.87	$4,239.77	51.58%	$4,751.90		$289.67
Date of Entry: 12/29/2016	Purchase	1018	Novelty Vendor 2	1659807763	12/29/2016	Posted	Imp@Host	$0.00	$0.00	$0.00						$0.00			Purchase(s) Total	$7,094.44	$2,052.87	$4,239.77	51.58%	$4,751.90		$289.67
Date of Entry: 1/1/2017	Purchase	1005	Soda Vendor	4135017111	12/30/2016	Posted	Imp@Host	$969.22	$903.54	$1,767.11	48.87%	$65.68		$0.00		$1,767.11	$65.68		Purchase(s) Total	$2,789.89	$2,689.68	$4,676.57	42.49%	$82.33		$17.88
Date of Entry: 12/30/2016	Purchase	1011	Cost Food Vendor	12303283	12/30/2016	Posted	Imp@Host	$35.80				$35.80		$0.00			$35.80		Purchase(s) Total	$3,270.86	$2,492.58	$2,749.85	9.36%	$773.84		$4.44
Date of Entry: 12/30/2016	Purchase	1016	Soda Vendor 3	48841519	12/30/2016	Posted	Imp@Host	$162.00	$162.00	$211.60	23.44%					$211.60			Purchase(s) Total	$3,270.86	$2,492.58	$2,749.85	9.36%	$773.84		$4.44
Date of Entry: 12/30/2016	Purchase	1016	Soda Vendor 3	87443951	12/30/2016	Posted	Imp@Host	$907.37	$169.33	$263.25	35.68%	$738.04				$263.25	$738.04		Purchase(s) Total	$3,270.86	$2,492.58	$2,749.85	9.36%	$773.84		$4.44
Date of Entry: 12/31/2016	Purchase	1008	Chip Vendor	36996184	12/31/2016	Posted	Imp@Host	$104.76	$104.76	$148.22	29.32%					$148.22			Purchase(s) Total	$110.00	$104.76	$148.22	29.32%			$5.24
Date of Entry: 1/1/2017	Purchase	1014	Bread Vendor	84195417616	1/1/2017	Posted	Imp@Host	$44.89	$28.24	$19.90	-41.91%	$16.65				$19.90	$16.65		Purchase(s) Total	$2,789.89	$2,689.68	$4,676.57	42.49%	$82.33		$17.88
Date of Entry: 1/2/2017	Purchase	1004	Energy Drink Vendor	3131700201	1/2/2017	Posted	Imp@Host	$81.42	$81.42	$139.26	41.53%					$139.26			Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/2/2017	Purchase	1008	Chip Vendor	36996197	1/2/2017	Posted	Imp@Host	$242.09	$242.09	$342.13	29.24%					$342.13			Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/2/2017	Purchase	1009	Milk Vendor	14714518	1/2/2017	Posted	Imp@Host	($15.35)	($15.35)	($27.04)	43.23%					($27.04)			Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/2/2017	Purchase	1009	Milk Vendor	14714519	1/2/2017	Posted	Imp@Host	$227.25	$227.25	$271.72	16.37%					$271.72			Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/2/2017	Purchase	1011	Cost Food Vendor	1014737	1/2/2017	Posted	Imp@Host	$3,803.10				$3,739.76		$63.34			$3,739.76		Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/2/2017	Purchase	1011	Cost Food Vendor	1014738	1/2/2017	Posted	Imp@Host	$31.12				$31.12		$0.00			$31.12		Purchase(s) Total	$4,369.63	$535.41	$726.07	26.26%	$3,770.88		$63.34
Date of Entry: 1/3/2017	Purchase	1001	Pie Vendor	1423751	1/3/2017	Posted	Imp@Host	$71.00	$71.00	$131.35	45.95%					$131.35			Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1005	Soda Vendor	4135017301	1/3/2017	Posted	Imp@Host	$1,472.40	$525.22	$872.23	39.78%	$947.18		$0.00		$872.23	$947.18		Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1013	Grocery Vendor	1280564675	1/3/2017	Posted	Imp@Host	$2,325.10	$693.36	$1,459.50	52.49%	$763.40		$868.34		$1,459.50	$763.40		Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1014	Bread Vendor	84195417665	1/3/2017	Posted	Imp@Host	$85.89	$85.89	$140.14	38.71%					$140.14			Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1014	Bread Vendor	84195417666	1/3/2017	Posted	Imp@Host	($16.87)	($16.87)	($23.42)	27.97%					($23.42)			Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1014	Bread Vendor	84195417667	1/3/2017	Posted	Imp@Host	$29.78	$4.78	$0.00		$25.00				$0.00	$25.00		Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1016	Soda Vendor 3	94598020	1/3/2017	Posted	Imp@Host	$506.10	$506.10	$762.10	33.59%					$762.10			Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/3/2017	Purchase	1020	Energy Drink Vendor 2	1937-2466	1/3/2017	Posted	Imp@Host	$679.20	$679.20	$1,207.44	43.75%					$1,207.44			Purchase(s) Total	$5,155.05	$2,548.68	$4,549.34	43.98%	$1,735.58		$870.79
Date of Entry: 1/4/2017	Purchase	1002	Ice Cream Vendor	8030047885	1/4/2017	Posted	Imp@Host	$228.02	$228.02	$387.34	41.13%					$387.34			Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/4/2017	Purchase	1002	Ice Cream Vendor	8030047886	1/4/2017	Posted	Imp@Host	($1.59)	($1.59)	($2.99)	46.82%					($2.99)			Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/4/2017	Purchase	1007	Sandwich Vendor	12235999	1/4/2017	Posted	Imp@Host	$52.16	$52.16	$80.36	35.09%					$80.36			Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/4/2017	Purchase	1008	Chip Vendor	36996229	1/4/2017	Posted	Imp@Host	$312.76	$312.76	$443.99	29.56%					$443.99			Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/4/2017	Purchase	1013	Grocery Vendor	1282568833	1/4/2017	Posted	Imp@Host	($20.00)						($20.00)					Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/4/2017	Purchase	1013	Grocery Vendor	1286568833	1/4/2017	Posted	Imp@Host	($34.95)						($34.95)					Purchase(s) Total	$539.95	$591.35	$908.70	34.92%			($51.40)
Date of Entry: 1/5/2017	Purchase	1009	Milk Vendor	14732331	1/5/2017	Posted	Imp@Host	($1.32)	($1.32)	($1.99)	33.67%					($1.99)			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1009	Milk Vendor	14732332	1/5/2017	Posted	Imp@Host	$112.22	$112.22	$197.53	43.19%					$197.53			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1009	Milk Vendor	14732333	1/5/2017	Posted	Imp@Host	$6.15	$6.15	$11.96	48.58%					$11.96			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1010	Beer Vendor	439270	1/5/2017	Posted	Imp@Host	$2,477.90	$2,477.90	$3,155.77	21.48%					$3,155.77			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1010	Beer Vendor	439271	1/5/2017	Posted	Imp@Host	$193.15	$193.15	$571.96	66.23%					$571.96			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1011	Cost Food Vendor	1043108	1/5/2017	Posted	Imp@Host	$2,789.10				$2,734.40		$54.70			$2,734.40		Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1011	Cost Food Vendor	1055635	1/5/2017	Posted	Imp@Host	$40.78				$40.78		$0.00			$40.78		Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1013	Grocery Vendor	1280568833	1/5/2017	Posted	Imp@Host	$8,970.33	$7,398.20	$9,883.13	25.14%	$463.83		$1,108.30		$9,883.13	$463.83		Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/5/2017	Purchase	1019	Beer Vendor 2	471446	1/5/2017	Posted	Imp@Host	$2,137.31	$2,137.31	$2,501.00	14.54%					$2,501.00			Purchase(s) Total	$16,727.48	$12,323.61	$16,319.36	24.48%	$3,239.01		$1,164.86
Date of Entry: 1/6/2017	Purchase	1005	Soda Vendor	4135017611	1/6/2017	Posted	Imp@Host	$1,357.42	$1,131.08	$2,200.16	48.59%	$226.34		$0.00		$2,200.16	$226.34		Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1005	Soda Vendor	4135017613	1/6/2017	Posted	Imp@Host	($18.96)	($18.96)	($36.00)	47.33%					($36.00)			Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1008	Chip Vendor	36996262	1/6/2017	Posted	Imp@Host	$203.92	$203.92	$291.68	30.09%					$291.68			Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1011	Cost Food Vendor	1056682	1/6/2017	Posted	Imp@Host	$171.20				$171.20		$0.00			$171.20		Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1011	Cost Food Vendor	1068916	1/6/2017	Posted	Imp@Host	$27.24				$27.24		$0.00			$27.24		Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1014	Bread Vendor	84195417730	1/6/2017	Posted	Imp@Host	$56.50	$21.51	$0.00		$34.99				$0.00	$34.99		Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1014	Bread Vendor	84195417732	1/6/2017	Posted	Imp@Host	$36.20	$36.20	$55.99	35.35%					$55.99			Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/6/2017	Purchase	1016	Soda Vendor 3	88062918	1/6/2017	Posted	Imp@Host	$533.15	$460.50	$733.89	37.25%	$72.65				$733.89	$72.65		Purchase(s) Total	$2,368.53	$1,834.25	$3,264.92	43.82%	$532.42		$1.86
Date of Entry: 1/9/2017	Purchase	1008	Chip Vendor	36996296	1/9/2017	Posted	Imp@Host	$353.80	$353.80	$523.26	32.39%					$523.26			Purchase(s) Total	$5,595.87	$2,836.05	$3,197.28	11.30%	$2,718.60		$41.22
Date of Entry: 1/9/2017	Purchase	1009	Milk Vendor	14745384	1/9/2017	Posted	Imp@Host	($10.61)	($10.61)	($16.45)	35.50%					($16.45)			Purchase(s) Total	$5,595.87	$2,836.05	$3,197.28	11.30%	$2,718.60		$41.22
Date of Entry: 1/9/2017	Purchase	1009	Milk Vendor	14745385	1/9/2017	Posted	Imp@Host	$117.86	$117.86	$190.47	38.12%					$190.47			Purchase(s) Total	$5,595.87	$2,836.05	$3,197.28	11.30%	$2,718.60		$41.22
Date of Entry: 1/9/2017	Purchase	1011	Cost Food Vendor	1080771	1/9/2017	Posted	Imp@Host	$2,638.94				$2,601.44		$37.50			$2,601.44		Purchase(s) Total	$5,595.87	$2,836.05	$3,197.28	11.30%	$2,718.60		$41.22
Date of Entry: 1/9/2017	Purchase	1011	Cost Food Vendor	1092650	1/9/2017	Posted	Imp@Host	$117.16				$117.16		$0.00			$117.16		Purchase(s) Total	$5,595.87	$2,836.05	$3,197.28	11.30%	$2,718.60		$41.22
Date of Entry: 1/10/2017	Purchase	1005	Soda Vendor	4135017906	1/10/2017	Posted	Imp@Host	$762.49	$488.39	$899.04	45.68%	$274.10		$0.00		$899.04	$274.10		Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1011	Cost Food Vendor	1106028	1/10/2017	Posted	Imp@Host	$68.47				$68.47		$0.00			$68.47		Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1014	Bread Vendor	84195417818	1/10/2017	Posted	Imp@Host	$68.18	$21.51	$0.00		$46.67				$0.00	$46.67		Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1014	Bread Vendor	84195417820	1/10/2017	Posted	Imp@Host	$75.71	$75.71	$128.06	40.88%					$128.06			Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1014	Bread Vendor	84195417821	1/10/2017	Posted	Imp@Host	($19.19)	($19.19)	($30.37)	36.81%					($30.37)			Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1016	Soda Vendor 3	93398210	1/10/2017	Posted	Imp@Host	$841.32	$500.70	$750.22	33.26%	$340.62				$750.22	$340.62		Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/10/2017	Purchase	1020	Energy Drink Vendor 2	W-7118481	1/10/2017	Posted	Imp@Host	$216.20	$216.20	$384.12	43.72%					$384.12			Purchase(s) Total	$2,014.87	$1,283.32	$2,131.07	39.78%	$729.86		$1.69
Date of Entry: 1/11/2017	Purchase	1006	Soda Vendor 2	7736501618	1/11/2017	Posted	Imp@Host	$158.15	$158.15	$284.04	44.32%					$284.04			Purchase(s) Total	$1,521.35	$1,496.87	$1,809.85	17.29%			$24.48
Date of Entry: 1/11/2017	Purchase	1008	Chip Vendor	36996336	1/11/2017	Posted	Imp@Host	$332.20	$332.20	$480.94	30.93%					$480.94			Purchase(s) Total	$1,521.35	$1,496.87	$1,809.85	17.29%			$24.48
Date of Entry: 1/11/2017	Purchase	1008	Chip Vendor	36996358	1/11/2017	Posted	Imp@Host	($38.48)	($38.48)	($55.13)	30.20%					($55.13)			Purchase(s) Total	$1,521.35	$1,496.87	$1,809.85	17.29%			$24.48
Date of Entry: 1/11/2017	Purchase	1013	Grocery Vendor	1282576014	1/11/2017	Posted	Imp@Host	$20.00						$20.00					Purchase(s) Total	$1,521.35	$1,496.87	$1,809.85	17.29%			$24.48
Date of Entry: 1/12/2017	Purchase	1003	Propane Vendor	8485001571	1/12/2017	Posted	Imp@Host	$110.22	$110.22	$219.89	49.87%					$219.89			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1009	Milk Vendor	14773909	1/12/2017	Posted	Imp@Host	($24.58)	($24.58)	($40.59)	39.44%					($40.59)			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1009	Milk Vendor	14773910	1/12/2017	Posted	Imp@Host	$59.35	$59.35	$104.42	43.16%					$104.42			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1010	Beer Vendor	439828	1/12/2017	Posted	Imp@Host	$1,477.33	$1,477.33	$1,859.06	20.53%					$1,859.06			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1010	Beer Vendor	439829	1/12/2017	Posted	Imp@Host	$69.95	$69.95	$170.64	59.01%					$170.64			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1011	Cost Food Vendor	1111001	1/12/2017	Posted	Imp@Host	$3,020.71				$2,996.97		$23.74			$2,996.97		Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1011	Cost Food Vendor	1123053	1/12/2017	Posted	Imp@Host	$99.92				$99.92		$0.00			$99.92		Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1013	Grocery Vendor	1280576014	1/12/2017	Posted	Imp@Host	$6,803.68	$5,097.17	$8,360.67	39.03%	$389.90		$1,316.61		$8,360.67	$389.90		Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1017	Chip Vendor 2	75441173	1/12/2017	Posted	Imp@Host	$170.14	$170.14	$255.34	33.37%					$255.34			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1019	Beer Vendor 2	476898	1/12/2017	Posted	Imp@Host	$1,704.64	$1,704.64	$2,110.84	19.24%					$2,110.84			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/12/2017	Purchase	1019	Beer Vendor 2	476899	1/12/2017	Posted	Imp@Host	$65.44	$65.44	$95.52	31.49%					$95.52			Purchase(s) Total	$15,391.68	$10,558.41	$15,060.79	29.89%	$3,486.79		$1,346.48
Date of Entry: 1/13/2017	Purchase	1002	Ice Cream Vendor	8030137071	1/13/2017	Posted	Imp@Host	$79.50	$79.50	$159.50	50.16%					$159.50			Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/13/2017	Purchase	1005	Soda Vendor	4183234607	1/13/2017	Posted	Imp@Host	$1,133.58	$1,133.58	$1,941.76	41.62%			$0.00		$1,941.76			Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/13/2017	Purchase	1008	Chip Vendor	36996359	1/13/2017	Posted	Imp@Host	$158.18	$158.18	$227.93	30.60%					$227.93			Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/13/2017	Purchase	1014	Bread Vendor	84195417857	1/13/2017	Posted	Imp@Host	$19.89	$2.39	$0.00		$17.50				$0.00	$17.50		Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/13/2017	Purchase	1014	Bread Vendor	84195417859	1/13/2017	Posted	Imp@Host	$10.00	$10.00	$14.75	32.20%					$14.75			Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/13/2017	Purchase	1016	Soda Vendor 3	94870917	1/13/2017	Posted	Imp@Host	$1,075.40	$557.85	$858.12	34.99%	$517.55				$858.12	$517.55		Purchase(s) Total	$2,480.86	$1,941.50	$3,202.06	39.37%	$535.05		$4.31
Date of Entry: 1/16/2017	Purchase	1006	Soda Vendor 2	8518703012	1/16/2017	Posted	Imp@Host	$0.00						$0.00					Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/16/2017	Purchase	1008	Chip Vendor	36996399	1/16/2017	Posted	Imp@Host	$304.37	$304.37	$439.30	30.71%					$439.30			Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/16/2017	Purchase	1008	Chip Vendor	36996441	1/16/2017	Posted	Imp@Host	($127.08)	($127.08)	($192.37)	33.94%					($192.37)			Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/16/2017	Purchase	1009	Milk Vendor	14791016	1/16/2017	Posted	Imp@Host	($4.29)	($4.29)	($6.58)	34.80%					($6.58)			Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/16/2017	Purchase	1009	Milk Vendor	14791017	1/16/2017	Posted	Imp@Host	$133.94	$133.94	$182.77	26.72%					$182.77			Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/16/2017	Purchase	1011	Cost Food Vendor	1157999	1/16/2017	Posted	Imp@Host	$3,924.44				$3,901.34		$23.10			$3,901.34		Purchase(s) Total	$4,233.83	$306.94	$423.12	27.46%	$3,901.34		$25.55
Date of Entry: 1/17/2017	Purchase	1005	Soda Vendor	4135018510	1/17/2017	Posted	Imp@Host	$882.99	$783.85	$1,414.81	44.60%	$99.14		$0.00		$1,414.81	$99.14		Purchase(s) Total	$1,288.41	$1,171.02	$1,814.81	35.47%	$115.53		$1.86
Date of Entry: 1/17/2017	Purchase	1014	Bread Vendor	84195417942	1/17/2017	Posted	Imp@Host	$23.56	$7.17	$0.00		$16.39				$0.00	$16.39		Purchase(s) Total	$1,288.41	$1,171.02	$1,814.81	35.47%	$115.53		$1.86
Date of Entry: 1/18/2017	Purchase	1008	Chip Vendor	36996442	1/18/2017	Posted	Imp@Host	$364.69	$364.69	$530.81	31.30%					$530.81			Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/18/2017	Purchase	1008	Chip Vendor	36996468	1/18/2017	Posted	Imp@Host	($2.08)	($2.08)	($2.98)	30.20%					($2.98)			Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/18/2017	Purchase	1013	Grocery Vendor	1280582913	1/18/2017	Posted	Imp@Host	$11,310.74	$9,885.09	$10,301.76	4.04%	$236.15		$1,189.50		$10,301.76	$236.15		Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/18/2017	Purchase	1013	Grocery Vendor	1282582913	1/18/2017	Posted	Imp@Host	($290.00)						($290.00)					Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/18/2017	Purchase	1020	Energy Drink Vendor 2	W-7129622	1/18/2017	Posted	Imp@Host	$510.80	$510.80	$723.00	29.35%					$723.00			Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/18/2017	Purchase	1020	Energy Drink Vendor 2	7129622	1/18/2017	Posted	Imp@Store	$510.80	$510.80	$909.48	43.84%					$909.48			Purchase(s) Total	$12,408.50	$11,269.30	$12,462.07	9.57%	$236.15		$903.05
Date of Entry: 1/19/2017	Purchase	1009	Milk Vendor	14804063	1/19/2017	Posted	Imp@Store	($29.04)	($29.04)	($30.43)	4.57%					($30.43)			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1009	Milk Vendor	14804064	1/19/2017	Posted	Imp@Store	$91.40	$91.40	$137.00	33.28%					$137.00			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1010	Beer Vendor	440397	1/19/2017	Posted	Imp@Host	$1,336.66	$1,336.66	$1,684.56	20.65%					$1,684.56			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1010	Beer Vendor	440398	1/19/2017	Posted	Imp@Host	$133.55	$133.55	$396.86	66.35%					$396.86			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1011	Cost Food Vendor	1187705	1/19/2017	Posted	Imp@Host	$3,069.15				$3,022.26		$46.89			$3,022.26		Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1011	Cost Food Vendor	1187705	1/19/2017	Posted	Imp@Host	$3,069.15				$3,022.26		$46.89			$3,022.26		Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1014	Bread Vendor	84195417956	1/19/2017	Posted	Imp@Store	$153.64	$153.64	$258.50	40.56%					$258.50			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1014	Bread Vendor	84195417957	1/19/2017	Posted	Imp@Store	($35.65)	($35.65)	($58.24)	38.79%					($58.24)			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/19/2017	Purchase	1019	Beer Vendor 2	482226	1/19/2017	Posted	Imp@Host	$2,082.63	$2,082.63	$2,670.39	22.01%					$2,670.39			Purchase(s) Total	$6,809.70	$3,733.19	$5,058.64	26.20%	$3,022.26		$54.25
Date of Entry: 1/20/2017	Purchase	1005	Soda Vendor	4135018815	1/20/2017	Posted	Imp@Store	$770.89	$770.89	$1,371.79	43.80%					$1,371.79			Purchase(s) Total	$3,809.73	$3,469.82	$4,690.71	26.03%	$333.74		$6.17
Date of Entry: 1/20/2017	Purchase	1008	Chip Vendor	36996470	1/20/2017	Posted	Imp@Store	$142.50	$142.50	$198.72	28.29%					$198.72			Purchase(s) Total	$3,809.73	$3,469.82	$4,690.71	26.03%	$333.74		$6.17
Date of Entry: 1/20/2017	Purchase	1014	Bread Vendor	84195417980	1/20/2017	Posted	Imp@Host	$13.12	$13.12	$11.94	-9.88%					$11.94			Purchase(s) Total	$3,809.73	$3,469.82	$4,690.71	26.03%	$333.74		$6.17
Date of Entry: 1/20/2017	Purchase	1016	Soda Vendor 3	95577012	1/20/2017	Posted	Imp@Host	$1,000.80	$667.06	$1,133.26	41.14%	$333.74				$1,133.26	$333.74		Purchase(s) Total	$3,809.73	$3,469.82	$4,690.71	26.03%	$333.74		$6.17
Date of Entry: 1/22/2017	Purchase	1013	Grocery Vendor	1280585509	1/22/2017	Posted	Imp@Host	$1,489.89	$1,188.66	$1,726.81	31.16%			$301.23		$1,726.81			Purchase(s) Total	$1,491.64	$1,188.66	$1,726.81	31.16%			$302.98
Date of Entry: 1/22/2017	Purchase	1013	Grocery Vendor	1282585509	1/22/2017	Posted	Imp@Host	($10.00)						($10.00)					Purchase(s) Total	$1,491.64	$1,188.66	$1,726.81	31.16%			$302.98
Date of Entry: 1/23/2017	Purchase	1006	Soda Vendor 2	8518704423	1/23/2017	Posted	Imp@Host	$159.40	$159.40	$303.36	47.46%					$303.36			Purchase(s) Total	$8,369.50	$4,280.85	$4,733.74	9.57%	$4,079.74		$8.91
Date of Entry: 1/23/2017	Purchase	1006	Soda Vendor 2	8518704424	1/23/2017	Posted	Imp@Host	$0.00						$0.00					Purchase(s) Total	$8,369.50	$4,280.85	$4,733.74	9.57%	$4,079.74		$8.91
Date of Entry: 1/23/2017	Purchase	1008	Chip Vendor	36996501	1/23/2017	Posted	Imp@Store	$113.98	$113.98	$163.16	30.14%					$163.16			Purchase(s) Total	$8,369.50	$4,280.85	$4,733.74	9.57%	$4,079.74		$8.91
Date of Entry: 1/23/2017	Purchase	1009	Milk Vendor	619700011	1/23/2017	Posted	Imp@Store	$88.72	$88.72	$142.22	37.62%					$142.22			Purchase(s) Total	$8,369.50	$4,280.85	$4,733.74	9.57%	$4,079.74		$8.91
Date of Entry: 2/1/2017	Purchase	1009	Milk Vendor	619700010	1/23/2017	Posted	Ent@Host	($5.88)	($5.88)	($11.97)	50.88%					($11.97)			Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 1/23/2017	Purchase	1011	Cost Food Vendor	1224910	1/23/2017	Posted	Imp@Host	$4,081.76				$4,079.74		$2.02			$4,079.74		Purchase(s) Total	$8,369.50	$4,280.85	$4,733.74	9.57%	$4,079.74		$8.91
Date of Entry: 1/24/2017	Purchase	1001	Pie Vendor	1217973	1/24/2017	Posted	Imp@Store	$37.00	$37.00	$68.45	45.95%					$68.45			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1001	Pie Vendor	1217976	1/24/2017	Posted	Imp@Store	$13.00	$13.00	$24.05	45.95%					$24.05			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1005	Soda Vendor	4135019108	1/24/2017	Posted	Imp@Host	$858.36	$404.45	$699.32	42.17%	$453.91		$0.00		$699.32	$453.91		Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1014	Bread Vendor	84195418052	1/24/2017	Posted	Imp@Store	$12.00	$7.56	$3.98	-89.95%	$4.44				$3.98	$4.44		Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1014	Bread Vendor	84195418054	1/24/2017	Posted	Imp@Store	$80.50	$80.50	$138.98	42.08%					$138.98			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1014	Bread Vendor	84195418055	1/24/2017	Posted	Imp@Store	($4.44)	($4.44)	($7.96)	44.22%					($7.96)			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1014	Bread Vendor	84195418056	1/24/2017	Posted	Imp@Store	$48.96	$48.96	$85.92	43.02%					$85.92			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1016	Soda Vendor 3	95437967	1/24/2017	Posted	Imp@Store	$480.14	$317.14	$541.93	41.48%	$163.00				$541.93	$163.00		Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/24/2017	Purchase	1020	Energy Drink Vendor 2	W-7148029	1/24/2017	Posted	Imp@Host	$554.90	$554.90	$745.68	25.58%					$745.68			Purchase(s) Total	$2,084.14	$1,459.07	$2,300.35	36.57%	$621.35		$3.72
Date of Entry: 1/25/2017	Purchase	1003	Propane Vendor	2406603668	1/25/2017	Posted	Imp@Host	$127.20	$127.20	$232.90	45.38%					$232.90			Purchase(s) Total	$10,471.56	$8,789.99	$9,808.37	10.38%	$675.14		$1,006.43
Date of Entry: 1/25/2017	Purchase	1013	Grocery Vendor	1280589118	1/25/2017	Posted	Imp@Host	$9,022.70	$7,356.54	$8,200.47	10.29%	$675.14		$991.02		$8,200.47	$675.14		Purchase(s) Total	$10,471.56	$8,789.99	$9,808.37	10.38%	$675.14		$1,006.43
Date of Entry: 1/25/2017	Purchase	1013	Grocery Vendor	1282589118	1/25/2017	Posted	Imp@Host	$10.00						$10.00					Purchase(s) Total	$10,471.56	$8,789.99	$9,808.37	10.38%	$675.14		$1,006.43
Date of Entry: 1/26/2017	Purchase	1005	Soda Vendor	4115139105	1/26/2017	Posted	Imp@Store	$3,473.60	$3,473.60	$4,401.28	21.08%					$4,401.28			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1008	Chip Vendor	36996541	1/26/2017	Posted	Imp@Store	$574.75	$574.75	$849.37	32.33%					$849.37			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1009	Milk Vendor	619700174	1/26/2017	Posted	Imp@Store	($22.30)	($22.30)	($41.09)	45.73%					($41.09)			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1009	Milk Vendor	619700175	1/26/2017	Posted	Imp@Store	$106.62	$106.62	$149.97	28.91%					$149.97			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1010	Beer Vendor	440970	1/26/2017	Posted	Imp@Host	$2,285.27	$2,285.27	$2,806.23	18.56%					$2,806.23			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1010	Beer Vendor	440971	1/26/2017	Posted	Imp@Host	$132.35	$132.35	$372.98	64.52%					$372.98			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1011	Cost Food Vendor	1255626	1/26/2017	Posted	Imp@Host	$3,529.53				$3,387.67		$141.86			$3,387.67		Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1011	Cost Food Vendor	1255627	1/26/2017	Posted	Imp@Host	$26.80				$26.80		$0.00			$26.80		Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1017	Chip Vendor 2	75441214	1/26/2017	Posted	Imp@Store	$110.49	$110.49	$165.22	33.13%					$165.22			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/26/2017	Purchase	1019	Beer Vendor 2	487611	1/26/2017	Posted	Imp@Host	$2,716.88	$2,716.88	$2,960.64	8.23%					$2,960.64			Purchase(s) Total	$12,936.78	$9,377.66	$11,664.60	19.61%	$3,414.47		$144.65
Date of Entry: 1/27/2017	Purchase	1002	Ice Cream Vendor	8030277193	1/27/2017	Posted	Imp@Store	$89.50	$89.50	$159.50	43.89%					$159.50			Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1005	Soda Vendor	4191382904	1/27/2017	Posted	Imp@Store	$1,098.84	$1,049.27	$2,008.90	47.77%	$49.57				$2,008.90	$49.57		Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1011	Cost Food Vendor	1271373	1/27/2017	Posted	Imp@Host	$71.55	$6.51	$14.70	55.71%	$65.04		$0.00		$14.70	$65.04		Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1014	Bread Vendor	84195418120	1/27/2017	Posted	Imp@Store	$48.05	$25.85	$19.90	-29.90%	$22.20				$19.90	$22.20		Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1014	Bread Vendor	84195418122	1/27/2017	Posted	Imp@Store	$20.00	$20.00	$29.50	32.20%					$29.50			Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1014	Bread Vendor	84195418123	1/27/2017	Posted	Imp@Store	($6.72)	($6.72)	($8.97)	25.08%					($8.97)			Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/27/2017	Purchase	1016	Soda Vendor 3	96405964	1/27/2017	Posted	Ent@Host	$626.19	$481.29	$817.74	41.14%	$144.90				$817.74	$144.90		Purchase(s) Total	$1,951.55	$1,665.70	$3,041.27	45.23%	$281.71		$4.14
Date of Entry: 1/28/2017	Purchase	1008	Chip Vendor	36996589	1/28/2017	Posted	Imp@Store	$531.94	$531.94	$750.74	29.14%					$750.74			Purchase(s) Total	$537.77	$531.94	$750.74	29.14%			$5.83
Date of Entry: 1/29/2017	Purchase	1013	Grocery Vendor	1280591541	1/29/2017	Posted	Imp@Host	$45.95	$7.68	$0.00				$38.27		$0.00			Purchase(s) Total	$535.02	$449.06	$371.00	-21.04%	$133.92		($47.96)
Date of Entry: 1/29/2017	Purchase	1013	Grocery Vendor	1280591542	1/29/2017	Posted	Imp@Host	$575.30	$441.38	$371.00	-18.97%	$133.92				$371.00	$133.92		Purchase(s) Total	$535.02	$449.06	$371.00	-21.04%	$133.92		($47.96)
Date of Entry: 1/29/2017	Purchase	1013	Grocery Vendor	1282591541	1/29/2017	Posted	Imp@Host	($100.00)						($100.00)					Purchase(s) Total	$535.02	$449.06	$371.00	-21.04%	$133.92		($47.96)
Date of Entry: 1/30/2017	Purchase	1006	Soda Vendor 2	8518705806	1/30/2017	Posted	Imp@Host	$0.00						$0.00					Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1006	Soda Vendor 2	8518705805	1/30/2017	Posted	Imp@Store	$218.67	$218.67	$417.72	47.65%					$417.72			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1008	Chip Vendor	36996648	1/30/2017	Posted	Imp@Host	($1.18)	($1.18)	($1.49)	20.81%					($1.49)			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1008	Chip Vendor	36996618	1/30/2017	Posted	Imp@Store	$329.20	$329.20	$427.68	23.03%					$427.68			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1009	Milk Vendor	619700277	1/30/2017	Posted	Imp@Store	($2.23)	($2.23)	($3.29)	32.22%					($3.29)			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1009	Milk Vendor	619700278	1/30/2017	Posted	Imp@Store	$144.78	$144.78	$218.29	33.68%					$218.29			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1011	Cost Food Vendor	1293362	1/30/2017	Posted	Imp@Host	$3,379.51	$7.39	$9.90	25.35%	$3,221.90		$150.22		$9.90	$3,221.90		Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1011	Cost Food Vendor	1293363	1/30/2017	Posted	Imp@Host	$192.11				$192.11		$0.00			$192.11		Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1012	Novelty Vendor	SI342861	1/30/2017	Posted	Imp@Host	$396.15	$396.15	$639.83	38.09%					$639.83			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/30/2017	Purchase	1018	Novelty Vendor 2	1759807923	1/30/2017	Posted	Imp@Host	$1,062.10	$1,062.10	$1,893.75	43.92%					$1,893.75			Purchase(s) Total	$6,697.34	$3,128.63	$4,627.39	32.39%	$3,414.01		$154.70
Date of Entry: 1/31/2017	Purchase	1005	Soda Vendor	4135019713	1/31/2017	Posted	Imp@Store	$884.53	$706.65	$1,320.03	46.47%	$177.88				$1,320.03	$177.88		Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 1/31/2017	Purchase	1014	Bread Vendor	84195418191	1/31/2017	Posted	Imp@Host	$38.78	$25.46	$15.92	-59.92%	$13.32				$15.92	$13.32		Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 1/31/2017	Purchase	1014	Bread Vendor	84195418193	1/31/2017	Posted	Imp@Host	$165.61	$165.61	$281.13	41.09%					$281.13			Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 1/31/2017	Purchase	1014	Bread Vendor	84195418194	1/31/2017	Posted	Imp@Host	($85.50)	($85.50)	($138.47)	38.25%					($138.47)			Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 1/31/2017	Purchase	1016	Soda Vendor 3	98864560	1/31/2017	Posted	Imp@Store	$464.90	$319.80	$548.67	41.71%	$145.10				$548.67	$145.10		Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 1/31/2017	Purchase	1020	Energy Drink Vendor 2	W-7165894	1/31/2017	Posted	Imp@Host	$506.10	$506.10	$714.48	29.17%					$714.48			Purchase(s) Total	$1,980.00	$1,638.12	$2,741.76	40.25%	$336.30		$5.58
Date of Entry: 2/1/2017	Purchase	1003	Propane Vendor	8.52413E+11	2/1/2017	Posted	Ent@Host	$110.22	$110.22	$219.89	49.87%					$219.89			Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 2/1/2017	Purchase	1008	Chip Vendor	36996647	2/1/2017	Posted	Imp@Store	$240.43	$240.43	$350.71	31.44%					$350.71			Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 2/1/2017	Purchase	1008	Chip Vendor	36996676	2/1/2017	Posted	Imp@Store	($9.44)	($9.44)	($13.52)	30.18%					($13.52)			Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 2/1/2017	Purchase	1013	Grocery Vendor	1280595487	2/1/2017	Posted	Imp@Host	$7,157.60	$5,807.99	$7,332.45	20.79%	$453.46		$896.15		$7,332.45	$453.46		Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 2/1/2017	Purchase	1013	Grocery Vendor	1282595487	2/1/2017	Posted	Imp@Host	($20.00)						($20.00)					Purchase(s) Total	$93.77	($1,240.15)	($2,339.19)	46.98%	$453.46		$880.46
Date of Entry: 2/2/2017	Purchase	1005	Soda Vendor	4145010011	2/2/2017	Posted	Ent@Host	$1,321.26	$1,232.32	$2,249.98	45.23%	$88.94				$2,249.98	$88.94		Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1008	Chip Vendor	36996677	2/2/2017	Posted	Ent@Host	$306.64	$306.64	$460.76	33.45%					$460.76			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1010	Beer Vendor	441532	2/2/2017	Posted	Imp@Host	$1,696.28	$1,696.28	$2,199.85	22.89%					$2,199.85			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1010	Beer Vendor	441533	2/2/2017	Posted	Imp@Host	$7.35	$7.35	$13.14	44.06%					$13.14			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1011	Cost Food Vendor	2013936	2/2/2017	Posted	Imp@Host	$3,360.07	$6.51	$14.70	55.71%	$3,313.32		$40.24		$14.70	$3,313.32		Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1014	Bread Vendor	84195418242	2/2/2017	Posted	Ent@Host	$21.40	$20.29	$11.94	-69.93%	$1.11				$11.94	$1.11		Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1014	Bread Vendor	84195418244	2/2/2017	Posted	Ent@Host	$44.13	$44.13	$82.60	46.57%					$82.60			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1014	Bread Vendor	84195418246	2/2/2017	Posted	Ent@Host	$153.96	$153.96	$268.60	42.68%					$268.60			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1016	Soda Vendor 3	48841515	2/2/2017	Posted	Ent@Host	$300.00	$300.00	$211.60	-41.78%					$211.60			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1019	Beer Vendor 2	493016	2/2/2017	Posted	Imp@Host	$3,519.26	$3,519.26	$4,422.48	20.42%					$4,422.48			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/2/2017	Purchase	1019	Beer Vendor 2	493017	2/2/2017	Posted	Imp@Host	$79.08	$79.08	$74.64	-5.95%					$74.64			Purchase(s) Total	$10,302.35	$6,855.02	$9,100.81	24.68%	$3,403.37		$43.96
Date of Entry: 2/3/2017	Purchase	1002	Ice Cream Vendor	8030347257	2/3/2017	Posted	Imp@Store	$92.68	$92.68	$157.16	41.03%					$157.16			Purchase(s) Total	$805.68	$587.20	$953.30	38.40%	$217.55		$0.93
Date of Entry: 2/3/2017	Purchase	1016	Soda Vendor 3	21688414	2/3/2017	Posted	Imp@Store	$712.07	$494.52	$796.14	37.89%	$217.55				$796.14	$217.55		Purchase(s) Total	$805.68	$587.20	$953.30	38.40%	$217.55		$0.93
Date of Entry: 2/5/2017	Purchase	1013	Grocery Vendor	1280598726	2/5/2017	Posted	Imp@Host	$2,016.89	$1,139.67	$2,317.81	50.83%	$457.76		$419.46		$2,317.81	$457.76		Purchase(s) Total	$2,005.00	$1,139.67	$2,317.81	50.83%	$457.76		$407.57
Date of Entry: 2/5/2017	Purchase	1013	Grocery Vendor	1282598726	2/5/2017	Posted	Imp@Host	($30.00)						($30.00)					Purchase(s) Total	$2,005.00	$1,139.67	$2,317.81	50.83%	$457.76		$407.57
Date of Entry: 2/6/2017	Purchase	1004	Energy Drink Vendor	3131703701	2/6/2017	Posted	Imp@Store	$54.60	$54.60	$87.96	37.93%					$87.96			Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1005	Soda Vendor	4145010306	2/6/2017	Posted	Imp@Store	$1,091.66	$866.20	$1,659.87	47.82%	$225.46				$1,659.87	$225.46		Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1006	Soda Vendor 2	8579907208	2/6/2017	Posted	Imp@Store	$256.52	$256.52	$464.28	44.75%					$464.28			Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1008	Chip Vendor	36996713	2/6/2017	Posted	Ent@Store	$404.78	$404.78	$606.38	33.25%					$606.38			Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1009	Milk Vendor	619700537	2/6/2017	Posted	Imp@Store	$3.92	$3.92	$7.98	50.88%					$7.98			Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1009	Milk Vendor	619700538	2/6/2017	Posted	Imp@Store	$116.85	$116.85	$165.33	29.32%					$165.33			Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/6/2017	Purchase	1011	Cost Food Vendor	2051907	2/6/2017	Posted	Imp@Host	$4,005.68	$11.40	$20.58	44.61%	$3,918.62		$75.66		$20.58	$3,918.62		Purchase(s) Total	$7,968.18	$3,746.58	$5,164.16	27.45%	$4,144.08		$77.52
Date of Entry: 2/7/2017	Purchase	1001	Pie Vendor	1215955	2/7/2017	Posted	Imp@Store	$26.00	$26.00	$48.10	45.95%					$48.10			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1001	Pie Vendor	1215958	2/7/2017	Posted	Imp@Store	$13.00	$13.00	$24.05	45.95%					$24.05			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1003	Propane Vendor	1.18485E+11	2/7/2017	Posted	Ent@Store	$210.42	$210.42	$419.79	49.87%					$419.79			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1007	Sandwich Vendor	12236596	2/7/2017	Posted	Imp@Store	$170.08	$170.08	$270.00	37.01%					$270.00			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1007	Sandwich Vendor	12236597	2/7/2017	Posted	Imp@Store	($3.53)	($3.53)	($5.69)	37.96%					($5.69)			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1014	Bread Vendor	84195418331	2/7/2017	Posted	Imp@Store	$20.88	$7.56	$3.98	-89.95%	$13.32				$3.98	$13.32		Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1014	Bread Vendor	84195418333	2/7/2017	Posted	Imp@Store	$160.25	$160.25	$270.62	40.78%					$270.62			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/7/2017	Purchase	1014	Bread Vendor	84195418334	2/7/2017	Posted	Imp@Store	($33.81)	($33.81)	($61.69)	45.19%					($61.69)			Purchase(s) Total	$6,245.59	$6,230.41	$9,265.53	32.76%	$13.32		$1.86
Date of Entry: 2/8/2017	Purchase	1008	Chip Vendor	36996762	2/8/2017	Posted	Imp@Store	$331.26	$331.26	$486.24	31.87%					$486.24			Purchase(s) Total	$332.87	$330.08	$484.55	31.88%			$2.79
Date of Entry: 2/8/2017	Purchase	1008	Chip Vendor	36996781	2/8/2017	Posted	Imp@Store	($1.18)	($1.18)	($1.69)	30.18%					($1.69)			Purchase(s) Total	$332.87	$330.08	$484.55	31.88%			$2.79
Date of Entry: 2/9/2017	Purchase	1009	Milk Vendor	619700699	2/9/2017	Posted	Imp@Store	($2.15)	($2.15)	($3.29)	34.65%					($3.29)			Purchase(s) Total	$5,825.67	$3,511.36	$4,528.36	22.46%	$2,310.59		$3.72
Date of Entry: 2/9/2017	Purchase	1009	Milk Vendor	619700700	2/9/2017	Posted	Imp@Store	$113.38	$113.38	$192.45	41.09%					$192.45			Purchase(s) Total	$5,825.67	$3,511.36	$4,528.36	22.46%	$2,310.59		$3.72
Date of Entry: 2/9/2017	Purchase	1011	Cost Food Vendor	2082021	2/9/2017	Posted	Imp@Host	$2,310.59				$2,310.59		$0.00			$2,310.59		Purchase(s) Total	$5,825.67	$3,511.36	$4,528.36	22.46%	$2,310.59		$3.72
Date of Entry: 2/9/2017	Purchase	1019	Beer Vendor 2	4500025	2/9/2017	Posted	Imp@Host	$32.00	$32.00	$59.76	46.45%					$59.76			Purchase(s) Total	$5,825.67	$3,511.36	$4,528.36	22.46%	$2,310.59		$3.72
Date of Entry: 2/9/2017	Purchase	1019	Beer Vendor 2	498865	2/9/2017	Posted	Imp@Host	$3,368.13	$3,368.13	$4,279.44	21.30%					$4,279.44			Purchase(s) Total	$5,825.67	$3,511.36	$4,528.36	22.46%	$2,310.59		$3.72
Date of Entry: 2/10/2017	Purchase	1005	Soda Vendor	4145010611	2/10/2017	Posted	Imp@Store	$1,247.22	$1,108.71	$2,179.62	49.13%	$138.51				$2,179.62	$138.51		Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1005	Soda Vendor	4145010612	2/10/2017	Posted	Imp@Store	($44.16)	($44.16)	($66.72)	33.81%					($66.72)			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1008	Chip Vendor	36996782	2/10/2017	Posted	Imp@Store	$299.88	$299.88	$440.62	31.94%					$440.62			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1014	Bread Vendor	84195418386	2/10/2017	Posted	Imp@Store	$31.22	$17.90	$11.94	-49.92%	$13.32				$11.94	$13.32		Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1014	Bread Vendor	84195418388	2/10/2017	Posted	Imp@Store	$90.31	$90.31	$164.97	45.26%					$164.97			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1014	Bread Vendor	84195418390	2/10/2017	Posted	Imp@Store	$20.40	$20.40	$35.80	43.02%					$35.80			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1014	Bread Vendor	8419548389	2/10/2017	Posted	Imp@Store	($7.79)	($7.79)	($12.94)	39.80%					($12.94)			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1016	Soda Vendor 3	98731666	2/10/2017	Posted	Imp@Store	$877.78	$516.58	$868.45	40.52%	$361.20				$868.45	$361.20		Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/10/2017	Purchase	1017	Chip Vendor 2	75441247	2/10/2017	Posted	Imp@Store	$101.96	$101.96	$156.79	34.97%					$156.79			Purchase(s) Total	$2,626.79	$2,103.79	$3,778.53	44.32%	$513.03		$9.97
Date of Entry: 2/12/2017	Purchase	1013	Grocery Vendor	1280607709	2/12/2017	Posted	Imp@Host	$2,026.32	$1,729.41	$2,170.74	20.33%	$47.94		$248.97		$2,170.74	$47.94		Purchase(s) Total	$2,026.32	$1,729.41	$2,170.74	20.33%	$47.94		$248.97
Date of Entry: 2/13/2017	Purchase	1006	Soda Vendor 2	8518708607	2/13/2017	Open	Imp@Store	$325.10	$325.10	$617.16	47.32%					$617.16			Purchase(s) Total	$844.67	$844.67	$1,383.33	38.94%
Date of Entry: 2/13/2017	Purchase	1008	Chip Vendor	36996819	2/13/2017	Open	Imp@Store	$422.96	$422.96	$607.70	30.40%					$607.70			Purchase(s) Total	$844.67	$844.67	$1,383.33	38.94%
Date of Entry: 2/13/2017	Purchase	1008	Chip Vendor	36996861	2/13/2017	Open	Imp@Store	($10.83)	($10.83)	($15.32)	29.31%					($15.32)			Purchase(s) Total	$844.67	$844.67	$1,383.33	38.94%
Date of Entry: 2/13/2017	Purchase	1009	Milk Vendor	619700793	2/13/2017	Open	Imp@Store	$107.44	$107.44	$173.79	38.18%					$173.79			Purchase(s) Total	$844.67	$844.67	$1,383.33	38.94%

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col><col><col span="2"><col><col><col span="6"><col></colgroup>

 

[Eric W]

This is very rough, but it does show the concept.

Sub Chk4Patterns()
Dim s1 As Worksheet
Dim tbl As Variant, Dict As Object, DOW As Variant
Dim i As Long, j As Long, k As Long, w As Long, r As Long, ID As Variant
Dim UsedDays As Object, MinD As Long, MaxD As Long, WCtr(7) As Long, NumWeeks As Double

    Set s1 = Worksheets("Sheet1")
    
    s1.Activate
    tbl = Range("A2:F" & Cells(Rows.Count, "A").End(xlUp).Row).Value
    
    Sheets.Add After:=s1
    
    Set Dict = CreateObject("Scripting.Dictionary")
    DOW = Array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
    
    On Error Resume Next
    For i = 1 To UBound(tbl)
        Dict.Add tbl(i, 3), tbl(i, 4)
    Next i
    
    ID = Dict.keys
    For i = 0 To UBound(ID)
        Cells(1, i * 8 + 1) = ID(i)
        Cells(1, i * 8 + 2) = Dict(ID(i))
        For j = 1 To 7
            Cells(2, i * 8 + j) = DOW(j - 1)
        Next j
        MinD = 999999
        MaxD = 0
        Set UsedDays = CreateObject("Scripting.Dictionary")
        Erase WCtr
        
        For j = 1 To UBound(tbl)
            If tbl(j, 3) = ID(i) Then
                If tbl(j, 6) < MinD Then MinD = tbl(j, 6)
                If tbl(j, 6) > MaxD Then MaxD = tbl(j, 6)
                w = WorksheetFunction.Weekday(tbl(j, 6))
                WCtr(w) = WCtr(w) + 1
                UsedDays.Add CLng(tbl(j, 6)), 1
            End If
        Next j
        
        NumWeeks = (MaxD - MinD) / 7
        Cells(1, i * 8 + 4) = NumWeeks
        
        For j = 1 To 7
            Cells(3, i * 8 + j) = WCtr(j)
            If (WCtr(j) > (NumWeeks / 2) And WCtr(j) < NumWeeks) Or WCtr(j) > NumWeeks Then
                r = 5
                For k = MinD To MaxD
                    If WorksheetFunction.Weekday(k) = j Then
                        If Not UsedDays.exists(k) Then
                            Cells(r, i * 8 + j) = Format(k, "mm/dd/yy")
                            r = r + 1
                        End If
                    End If
                Next k
            End If
        Next j
        
    Next i
    
    Set Dict = Nothing
    Set UsedDays = Nothing
        
End Sub

It creates a new sheet with the results. It creates a table for each Vendor. The vendor ID and name are in the top row, followed by the number of weeks found for that vendor. (Last date found - first date found) / 7. Then it creates a table with the number of dates for each day of the week. If that number is between the number of weeks / 2 and the number of weeks, it will list out missing dates in that range. Basically just scroll to the right and look for dates.

Hope this helps.

 

[sycodiz]

I forgot to reply- this worked great! Appreciate your help!