Frazier Law - Weekly Reporting Sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Frazier 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	0	0	0	0	0	0	0	$0		#DIV/0!		30%	$1,750		$15,050

3	6/1/2021	1	0	1	1	0	0	0	$150		0%
4	6/2/2021	4	0	2	0	0	0	2	$4,400		100%
5	6/3/2021	3	1	0	0	0			$404		#DIV/0!
6	6/4/2021			1	0	0	1	1	$500		100%
7
8	Weekly Totals	8	1	4	1	0	1	3	$5,454		100%	$3,675.00
9	Weekly Rates		13%	50%	13%	0%	13%
10	Running Total Hire Rate										#REF!
11
12	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
13	6/7/2021	1	1	1	0	0	0	1	$0		100%
14	6/8/2021	2	2	0	0	0	0	0	$0		#DIV/0!
15	6/9/2021	1	0	1	0	0	0	1	$2,000		100%
16	6/10/2021	2	0	2	0	0	2	0	$0		0%
17	6/11/2021	2	1	0	0	0	0	0	$0		#DIV/0!
18
19	Weekly Totals	8	4	4	0	0	2	2	$2,000		50%	$1,400.00
20	Weekly Rates		50%	50%	0%	0%	25%
21	Running Total Hire Rate										#REF!
22
23	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
24	6/14/2021	1	2	0	0	0	0	0	$0		#DIV/0!
25	6/15/2021	2	0	1	0	0	0	1	$400		100%
26	6/16/2021	1	0	2	0	0	1	1	$200		50%
27	6/17/2021	3	0%	200%	0%	0%	0%	2	$500		100%
28	6/18/2021	0	0%	200%	0%	0%	100%	1	$150		50%
29
30	Weekly Totals	7	2	7	0	0	2	5	$1,250		71%	$5,075.00
31	Weekly Rates		29%	100%	0%	0%	29%
32	Running Total Hire Rate										#REF!
33
34	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
35	6/21/2021	1	0	0	0	0	0	0	$0		#DIV/0!
36	6/22/2021	0	1	0	0	0	0	1	$850		#DIV/0!
37	6/23/2021	1	0%	0%	0%	0%	0%	0	$0		#DIV/0!
38	6/24/2021	1	0%	100%	0%	0%	100%	0	$0		0%
39	6/25/2021	2	0	1	0	0	0	2	$960		200%
40
41	Weekly Totals	5	1	2	0	0	1	3	$1,810		150%	$4,200.00
42	Weekly Rates		20%	40%	0%	0%	20%
43	Running Total Hire Rate										#REF!
44
45	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
46	6/28/2021	3	1	2	0	1	0	1	$0		50%
47	6/29/2021										#DIV/0!
48	6/30/2021										#DIV/0!
49	7/1/2021										#DIV/0!
50	7/2/2021										#DIV/0!
51
52	Weekly Totals	3	1	2	0	1	0	1	$0		50%	$700.00
53	Weekly Rates		33%	67%	0%	33%	0%
54	Running Total Hire Rate										#REF!
55
56	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
57	7/5/2021										#DIV/0!
58	7/6/2021										#DIV/0!
59	7/7/2021										#DIV/0!
60	7/8/2021										#DIV/0!
61	7/9/2021										#DIV/0!
62
63	Weekly Totals	0	0	0	0	0	0	0	$0		0%	$0.00
64	Weekly Rates		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
65	Running Total Hire Rate										#REF!
66
67	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
68	7/12/2021										#DIV/0!
69	7/13/2021										#DIV/0!
70	7/14/2021										#DIV/0!
71	7/15/2021										#DIV/0!
72	7/16/2021										#DIV/0!
73
74	Weekly Totals	0	0	0	0	0	0	0	$0		0%	$0.00
75	Weekly Rates		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
76	Running Total Hire Rate										#REF!
77
78	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
79	7/19/2021										#DIV/0!
80	7/20/2021										#DIV/0!
81	7/21/2021										#DIV/0!
82	7/22/2021										#DIV/0!
83	7/23/2021										#DIV/0!
84
85	Weekly Totals	0	0	0	0	0	0	0	$0		0%	$0.00
86	Weekly Rates		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
87	Running Total Hire Rate										#REF!
88
89	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected	Total Sale Value	Hired Rate
90	7/26/2021										#DIV/0!
91	7/27/2021										#DIV/0!
92	7/28/2021										#DIV/0!
93	7/29/2021										#DIV/0!
94	7/30/2021										#DIV/0!
95
96	Weekly Totals
97	Weekly Rates		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
98
99	Frazier Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected	Total Sale Value	Hired Rate
100	8/2/2021										#DIV/0!