Sonoma County Fair.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1			Sonoma County Fair
2	Date & Shift Hours	Name & Shift	Service Calls	Direct Scheduled	CPO	Orders	Ave. Order Size	RoR Orders	RoR CPO	Upsold CPO	Be Back Promises	Be Backs Orders	Be Back CPO	Be Back Convert %	PC Visit	PC Orders	PC CPO	PC Ave. Order	Referral Orders	Referral CPO	New Client CPO	New Client Orders	New Client Ave. Order	RoR Specifics

3			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
4	DAY 1 Friday
5	8/7	David	6	2	6022	9	669	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
6
7		Adam	10	0	6648	8	831	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
8
9	Day 1 Totals		16	2	12670	17	745	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	12670	17	745
10			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
11	DAY 2 Saturday
12	8/8	David	5	0	4393	8	549	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
13
14		Adam	7	0	5437	10	544	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
15
16	Day 2 Totals		12	0	9830	18	546	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	9830	18	546
17			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
18	DAY 3 Sunday
19	8/9	David	0	0	585	3	195	1	272	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
20
21		Adam	6	0	2558	4	640	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
22
23	Day 3 Totals		6	0	3143	7	449	1	272	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	3143	7	449
24			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
25	DAY 4 Monday
26	8/10	David	2	1	1994	3	665	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
27
28		Adam	6	-	1467	7	210	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
29
30	Day 4 Totals		8	1	3461	10	346	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	3461	10	346
31	Week 1 Totals		42	3	29104	52	449	1	272	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	29104	52	560
32			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
33	DAY 4 Tuesday
34	8/11	David	3	1	493	3	164	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
35
36		Adam	8	0	1973	6	329	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
37
38	Day 4 Totals		11	1	2466	9	274	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	2466	9	274
39			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
40	DAY 5 Wednesday
41	8/12	David	3	2	260	2	130	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
42
43		Adam	6	0	541	4	135	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
44
45	Day 5 Totals		9	2	801	6	134	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	801	6	134
46			-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
47	DAY 6 Thursday
48	8/13	David	2	0	380	3	127	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
49
50		Adam	3	0	942	4	236	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
51
52	Day 6 Totals		5	0	1322	7	189	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	1322	7	189
53		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
54	DAY 7 Friday
55	8/14	David	5	2	1137	6	190	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
56
57		Adam	8	0	2243	8	280	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
58
59	Day 7 Totals		13	2	3380	14	241	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	3380	14	241
60		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
61	DAY 8 Saturday
62	8/15	Sarah	1	0	427	2	214	2	292	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
63
64		Adam	8	0	3123	10	312	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
65
66	Day 8 Totals		9	0	3550	12	296	2	292	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	3550	12	296
67		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
68	DAY 8 Sunday
69	8/16	Sarah	2	1	759	2	380	1	171	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
70
71		Adam	4	0	3569	9	397	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
72
73	Day 8 Totals		6	1	4328	11	393	1	171	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	4328	11	393
74	Week 2 Totals		53	6	15847	59	393	3	463	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	15847	59	269
75	Grand Totals		95	9	44951	111	405	4	735	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	44951	111	405	1960
76	Name	# of Shifts	Service Calls	Direct Scheduled	CPO	Orders	Ave. Order Size	RoR Orders	RoR CPO	Upsold CPO	Be Back Promises	Be Backs	Be Back CPO	Be Back Convert %	PC Visit	PC Orders	PC CPO	PC Ave. Order	Referral Orders	Referral CPO	New Client CPO	New Client Orders	New Client Ave. Order	CPO per Shift	% of Show CPO
77	Adam	10	66	0	28501	70	407	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	28501	70	407	2850	-12682945%
78	David	8	26	8	15264	37	413	1	272	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	15264	37	413	1908	-3347467%
79	Jeremy	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	#VALUE!	#VALUE!	#VALUE!	0	0%
80	Sarah	2	3	1	1186	4	297	3	463	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	593	-527770%
81		23
82
83		Show Stats	2021*	Year/Year Growth	2022	Year/Year Growth	2023	Year/Year Growth	2024	Year/Year Growth	2025	Year/Year Growth	2026	Year/Year Growth
84		CPO	0	#DIV/0!	44588	#DIV/0!	86553	94%	47086	-46%	45084	-4%	45686	1%
85		# Orders	0	#DIV/0!	108	#DIV/0!	178	65%	138	-22%	113	-18%	115	2%
86		Service Calls	0	#DIV/0!	0	#DIV/0!	0	#DIV/0!	0	#DIV/0!	4	#DIV/0!	95	2275%
87		Direct Scheduled	0	#DIV/0!	0	#DIV/0!	0	#DIV/0!	95	#DIV/0!	9	-91%	9	0%
88
89			*cancelled due to COVID
90
91
92
93
94
95
96
97
98
99
100