Badgley Law - Weekly Reporting Sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected	Total Sale Value	Hired Rate	Weekly TCR Dollars Generated	Starting Hire Rate	Average Case Value	Running Hire Rate	Total TCR Dollars Generated
2	5/31/2021										#DIV/0!		42%	$2,000		$181,520

3	6/1/2021										#DIV/0!
4	6/2/2021										#DIV/0!
5	6/3/2021										#DIV/0!
6	6/4/2021										#DIV/0!
7
8	Weekly Totals	0	0	0	0	0	0	0	$0		#DIV/0!
9	Weekly Rates		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
10	Running Total Hire Rate										#REF!
11
12	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
13	6/7/2021	2	1	1	1	0	0	0	$0		#DIV/0!
14	6/8/2021	0	0	0	0	0	0	1	$0		#DIV/0!
15	6/9/2021	3	0	3	0	0	2	1	$200		33%
16	6/10/2021	1	0	1	0	0	0	1	$0		100%
17	6/11/2021	0	0	0	0	0	0	2	$873		#DIV/0!
18
19	Weekly Totals	6	1	5	1	0	2	5	$1,073		125%	$6,640.00
20	Weekly Rates		17%	83%	17%	0%	33%
21	Running Total Hire Rate										#REF!
22
23	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
24	6/14/2021	4	2	2	0	0	1	2	$0		100%
25	6/15/2021	0	0	0	0	0	0	1	$0		#DIV/0!
26	6/16/2021	4	0	4	1	0	3	0	$0		0%
27	6/17/2021	1	0%	100%	0%	0%	100%	0	$0		0%
28	6/18/2021	1	0%	100%	0%	0%	100%	0	$0		0%
29
30	Weekly Totals	10	2	8	1	0	6	3	$0		43%	$120.00
31	Weekly Rates		20%	80%	10%	0%	60%
32	Running Total Hire Rate										#REF!
33
34	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
35	6/21/2021	1	0	1	0	0	0	1	$0		100%
36	6/22/2021	3	1	2	0	0	2	1	$0		50%
37	6/23/2021	1	0%	100%	0%	0%	0%	1	$199		100%
38	6/24/2021	2	0%	200%	0%	0%	200%	0	$0		0%
39	6/25/2021	2	0	2	1	0	1	0	$0		0%
40
41	Weekly Totals	9	1	8	1	0	5	3	$199		43%	$120.00
42	Weekly Rates		11%	89%	11%	0%	56%
43	Running Total Hire Rate										#REF!
44
45	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
46	6/28/2021	4	0	3	0	1	2	1	$0		33%
47	6/29/2021	2	0	2	0	0	1	1	$276		50%
48	6/30/2021	3	100%	200%	0%	0%	100%	2	$2,577		100%
49	7/1/2021	4	100%	300%	0%	0%	200%	2	$0		67%
50	7/2/2021	2	0	2	0	0	0	2	$1,057		100%
51
52	Weekly Totals	15	2	12	0	1	6	8	$3,910		67%	$5,920.00
53	Weekly Rates		13%	80%	0%	7%	40%
54	Running Total Hire Rate										#REF!
55
56	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
57	7/5/2021	0	0	0	0	0	0	0	$0		#DIV/0!
58	7/6/2021	5	0	5	1	0	2	2	$2,000		50%
59	7/7/2021	4	0%	400%	0%	0%	300%	1	$0		25%
60	7/8/2021	5	0%	500%	0%	0%	200%	3	$838		60%
61	7/9/2021	3	0	3	0	0	3	0	$0		0%
62
63	Weekly Totals	17	0	17	1	0	10	6	$2,838		38%	-$1,440.00
64	Weekly Rates		0%	100%	6%	0%	59%
65	Running Total Hire Rate										#REF!
66
67	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
68	7/12/2021	3	1	2	0	0	2	0	$0		0%
69	7/13/2021	2	0	2	0	0	2	0	$0		0%
70	7/14/2021	3	100%	200%	0%	0%	100%	2	$0		100%
71	7/15/2021	3	200%	100%	0%	0%	100%	0	$0		0%
72	7/16/2021	3	0	2	2	0	0	2	$2,410		0%
73
74	Weekly Totals	14	4	9	2	0	6	4	$2,410		57%	$2,120.00
75	Weekly Rates		29%	64%	14%	0%	43%
76	Running Total Hire Rate										#REF!
77
78		Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
79	7/19/2021	3	1	2	1	0	1	1	$1,535		100%
80	7/20/2021	3	0	3	0	0	1	3	$945		100%
81	7/21/2021	3	1	2	1	0	1	0	$0		0%
82	7/22/2021	0	0%	0%	0%	0%	0%	1	$0		#DIV/0!
83	7/23/2021	4	3	3	0	0	2	1	$150		33%
84
85	Weekly Totals	13	5	10	2	0	5	6	$2,630		75%	$5,280.00
86	Weekly Rates		38%	77%	15%	0%	38%
87	Running Total Hire Rate										#REF!
88
89	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
90	7/26/2021	1	1	0	0	0	0	0	$0		#DIV/0!
91	7/27/2021	5	1	4	0	1	3	1	$0		25%
92	7/28/2021	2	0	2	1	0	0	1	$0		100%
93	7/29/2021	4	100%	300%	100%	0%	300%	0	$0		0%
94	7/30/2021										#DIV/0!
95
96	Weekly Totals	12	3	9	2	1	6	2	$0		29%	-$1,880.00
97	Weekly Rates		25%	75%	17%	8%	50%
98	Running Total Hire Rate										#REF!
99
100	Badgley Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate