2023 popcorn credits.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	scout	sales	donations	total sales w/ donations	amount over 700	scout credit	dues	dues discount	dues owed	popcorn coupon code	need to update donations?	code email sent?	extra discount after dues for future activities	discounts @ future events
2	Cole Robertson	1,967.53	194.74	2,162.27	1,462.27	391.227	240	391.227	0.00				151.23	51.84	more than $500?	20
3	Jacob Effinger	1,250.00	31.4	1,281.40	581.4	298.14	240	240	0.00				58.14	51.84	more than 700?	15
4	chris evans	1,043.36	65.57	1,108.93	408.93	280.893	240	240	0.00				40.89	7.35
5	Jayaditya Singh	1016.91	261.584	$1,278.49	$578.49	$447.47	$240.00	$447.47	$0.00				207.47	21.84	185.63
6	Alexander Evans	949.58	96.821	1,046.40	346.4	274.6401	240	240	0.00				34.64
7	Rishvanth Ravikumar	855.73	190.588	$1,046.32	$346.32	$366.21	$240.00	$366.21	$0.00				126.21
8	Samuel Roh	791.91	131.8	923.71	223.71	262.371	240	240	0.00				22.37	7.35
9	Dhilan Prempeh	737.33	62.356	$799.69	$99.69	$279.89	$150.00	$279.89	$0.00				129.89
10	Parker Knight	734.55	64.45	799	99	249.9	240	240	0.00				9.90
11	Emma Ho	732.78	118	850.78	150.78	255.078	240	240	0.00				15.08
12	Ian Fung	694.43	93.81	788.24	88.24	248.824	240	240	0.00				8.82	8.82
13	Kipton Knight	693.55	64.45	758	58	245.8	150	150	0.00				95.80
14	Max Sheffield	669.58	99.45	769.03	69.03	246.903	240	240	0.00				6.90
15	Rohan Shah	656.81	136.931	$793.74	$93.74	$277.81	$240.00	$277.81	$0.00		y	y	37.81
16	Kaitlin Ferguson	650.18	65.23	715.41	15.41	$254.37	240	240	0.00				14.37
17	Riaan Kailat	560.74	84.1	644.84	0	225.694	240	225.69	14.31	kailatdues		y	0.00
18	harish sundaravadivel	513.64	115.757	$629.40	$0.00	$220.29	$240.00	$220.29	$19.71	sundaravdues	y	y	0.00
19	Olivia Dobson	508.17	67.17	575.34	0	201.369	240	201.37	38.63	dobsondues		y	0.00
20	Emma Treweeke	465.14	101.051	$566.19	$0.00	$198.17	$240.00	$198.17	$41.83	treweekedues	y	y	0.00
21	abigail haynes	445.31	54.56	499.87	0	174.9545	240	174.95	65.05	haynesdues		y	0.00
22	Hudson Treweeke	438.27	101.051	$539.32	$0.00	$188.76	$240.00	$188.76	$51.24	treweekedues	y	y	0.00
23	henry haynes	395.31	54.57	449.88	0	157.458	240	157.46	82.54	haynesdues		y	0.00		216.28
24	Aidan Chiu	391.67	60.83	452.5	0	158.375	240	158.38	81.62	chiudues		y	0.00		$347.14
25	Isabella Dobson	387	53.88	440.88	0	154.308	240	154.31	85.69	dobsondues		y	0.00		146.67
26	Calvin woehler	349.83	48.278	$398.11	$0.00	$139.34	$150.00	$139.34	$10.66	woehlerdues	y	y	0.00
27	James Squittieri	323		323	0	113.05	240	113.05	126.95	squittieridues		y	0.00
28	Henry Blunt	237.3	38.52	275.82	0	96.537	240	96.54	143.46	bluntdues		y	0.00
29	Nilesha Buwaneka	223.9	40.91	264.81	0	92.6835	240	92.6835	147.32	buwanekadues		y	0.00
30	Ethan LaPorte	209.83	50.921	$260.75	$0.00	$91.26	$240.00	$91.26	$148.74	laportedues	y	y	0.00
31	Aadit Arora	140.42	34.2	$174.62	$0.00	$61.12	$240.00	$61.12	$178.88	aroradues	y	y	0.00
32	Oliver Needham	130.54	21.46	152	0	53.2	240	53.2	186.80	needhamdues		y	0.00
33	Owen Nichols	128.18	27.63	155.81	0	54.5335	240	54.53	185.47			n	0.00
34	Avash Momtahan	123.92	19.250	$143.17	$0.00	$50.11	$150.00	$50.11	$99.89	momtahandues	y	y	0.00
35	Noah Olivieri	121.17	44.25	165.42	0	57.897	150	57.9	92.10	olivieridues		y	0.00
36	Preston Lee	103.54	15.5	119.04	0	41.664	150	41.66	108.34	leedues		y	0.00
37	Rowan Lee	103.54	17.05	120.59	0	42.2065	150	42.21	107.79	leedues		y	0.00
38	Gideon Comis	96.77	7.15	103.92	0	36.372	240	36.37	203.63	comisdues		y	0.00
39	Mihael Stoyanov	85.57	10	95.57	0	33.4495	240	33.45	206.55	stoyanovdues			0.00
40	Richard baumann	82	0	82	0	28.7	150	28.7	121.30			n	0.00
41	Antonio LeBlanc	56.54	7.75	64.29	0	22.5015	240	22.5015	217.50	leblancdues		y	0.00
42	Henry Son	43.92	6.41	50.33	0	17.6155	240	17.62	222.38	sondues		y	0.00
43	Hugh Son	43.92	6.41	50.33	0	17.6155	240	17.62	222.38	sondues		y	0.00
44	Connor Arnold	41.77	7.15	48.92	0	17.122	240	17.12	222.88	arnolddues			0.00
45								#REF!					#REF!
46			2772.986335
47										414.95
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100