Northern California Home & Landscape.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			Northern California Home & Landscape
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	DAY 1 Friday 2/5
4	Building B	Danny	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	0	0	#DIV/0!
5	10x20 endcap
6		JC	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
7
8		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
9
10	Building C	Adam	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
11	10x20 corner
12		Chris	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
13
14		Hung	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
15
16	Pavillion	Sarah	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
17	10x10 corner
18		Karin	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
19
20	Day 4 Totals		0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	#VALUE!	#VALUE!	#VALUE!
21	DAY 2 Saturday 2/6
22	Building B	Danny	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	0	0	#DIV/0!
23	10x20 endcap
24		JC	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
25
26		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
27
28	Building C	Adam	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
29	10x20 corner
30		Chris	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
31
32		Hung	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
33
34	Pavillion	Sarah	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
35	10x10 corner
36		Karin	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
37
38	Day 5 Totals		0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	#VALUE!	#VALUE!	#VALUE!
39	DAY 3 Sunday 2/7
40	Building B	Danny	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	0	0	#DIV/0!
41	10x20 endcap
42		JC	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
43
44		Jeremy	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
45
46	Building C	Adam	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
47	10x20 corner
48		Chris	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
49
50		Hung	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
51
52	Pavillion	Sarah	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
53	10x10 corner
54		Karin	-	-	-	-	#VALUE!	-	-	-	-	-	-	#VALUE!	-	-	-	#VALUE!	-	-	#VALUE!	#VALUE!	#VALUE!
55
56	Day 3 Totals		0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	#VALUE!	#VALUE!	#VALUE!
57
58	Building B	EVENT TOTAL	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#VALUE!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!
59	Building C	EVENT TOTAL	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!
60	Pavillion	EVENT TOTAL	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!
61	Grand Totals		0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0
62	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
63	JC	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
64	Jeremy	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
65	Adam	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
66	Sarah	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
67	Hung	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
68	Danny	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	0%
69	Chris	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	#DIV/0!
70	Karin	3	0	0	0	0	#DIV/0!	0	0	0	0	0	0	#DIV/0!	0	0	0	#DIV/0!	0	0	0	0	#DIV/0!	0	#DIV/0!
71
72		24
73
74		Show Stats	2022	2023	2024	2025	2026	Year/Year Growth	2027	Year/Year Growth
75		CPO	46571	57160	44055	58188	74771	70%	0	-100%
76		# Orders	77	91	82	84	97	18%	0	-100%
77		Service Calls	6	21	5	0	7	40%	0	-100%
78		Direct Scheduled	0	#REF!	#REF!	#REF!	0	#REF!	0	#DIV/0!
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100