McCranie Law - Weekly Reporting Sheet

	A	B	C	D	E	G	H	I	J	K	L	M	N	O	P	Q
1	Mccranie 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/10/2021	14	2	12	3	0	5	5	$13,750		56%		36%	$4,800		$3,950,264

3	5/11/2021	7	1	6	1	0	3	2	$30,900		40%
4	5/12/2021	12	2	10	6	0	2	2	$11,500		50%
5	5/13/2021	13	2	11	1	0	5	5	$6,500		50%
6	5/14/2021	17	4	13	6	0	1	6	$10,800		86%
7
8	Weekly Totals	63	11	52	17	0	16	20	$73,450		57%	$35,520.00
9	Weekly Rates		17%	83%	27%	0%	25%
10	Running Total Hire Rate										#REF!
11
12	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
13	5/17/2021	10	3	7	3	0	2	3	$1,500		75%
14	5/18/2021	9	1	8	1	0	4	2	$4,750		29%
15	5/19/2021	4	0	4	2	0	2	0	$0		0%
16	5/20/2021	17	5	11	3	2	6	1	$3,500		13%
17	5/21/2021	12	4	8	2	1	3	3	$6,000		50%
18
19	Weekly Totals	52	13	38	11	3	17	9	$15,750		33%	-$3,456.00
20	Weekly Rates		25%	73%	21%	6%	33%
21	Running Total Hire Rate										#REF!
22
23	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
24	5/24/2021	11	3	6	2	0	6	0	$0		0%
25	5/25/2021	8	0	6	2	3	2	0	$0		0%
26	5/26/2021	9	4	5	3	0	2	1	$500		50%
27	5/27/2021	6	1	5	2	1	0	3	$4,050		100%
28	5/28/2021	12	200%	1000%	300%	100%	300%	4	$3,500		57%
29
30	Weekly Totals	46	10	32	12	5	13	8	$8,050		40%	$3,840.00
31	Weekly Rates		22%	70%	26%	11%	28%
32	Running Total Hire Rate										#REF!
33
34	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
35	5/31/2021	CLOSED
36	6/1/2021	15	5	10	6	0	2	1	$2,000		25%
37	6/2/2021	22	3	19	8	2	6	5	$7,000		45%
38	6/3/2021	15	100%	1400%	600%	0%	500%	3	$6,650		38%
39	6/4/2021	14	7	7	3	0	2	2	$4,500		50%
40
41	Weekly Totals	66	16	50	23	2	15	11	$20,150		41%	$6,144.00
42	Weekly Rates		24%	76%	35%	3%	23%
43	Running Total Hire Rate										#REF!
44
45	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
46	6/7/2021	10	3	7	4	2	1	0	$0		0%
47	6/8/2021	11	2	9	4	0	4	2	$8,500		40%
48	6/9/2021	10	2	8	3	1	3	1	$1,000		20%
49	6/10/2021	7	200%	500%	0%	100%	300%	1	$3,500		20%
50	6/11/2021	10	1	9	4	1	3	2	$12,500		40%
51
52	Weekly Totals	48	10	38	15	5	14	6	$25,500		26%	-$10,944.00
53	Weekly Rates		21%	79%	31%	10%	29%
54	Running Total Hire Rate										#REF!
55
56	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
57	6/14/2021	7	0	7	4	0	1	2	$3,000		67%
58	6/15/2021	11	3	8	0	4	1	3	$7,500		38%
59	6/16/2021	13	1	12	6	1	4	1	$1,000		17%
60	6/17/2021	10	100%	900%	100%	200%	500%	2	$1,300		25%
61	6/18/2021	6	0	6	5	0	2	1	$1,000		100%
62
63	Weekly Totals	47	5	42	16	7	13	9	$13,800		35%	-$1,728.00
64	Weekly Rates		11%	89%	34%	15%	28%
65	Running Total Hire Rate										#REF!
66
67	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
68	6/21/2021	19	4	15	7	1	5	2	$2,000		25%
69	6/22/2021	11	0	7	5	1	3	0			0%
70	6/23/2021	18	6	12	4	0	3	5	$7,850		63%
71	6/24/2021	9	100%	700%	200%	0%	500%	0			0%
72	6/25/2021	10	1	9	6	0	4	2	$800		67%
73
74	Weekly Totals	67	12	50	24	2	20	9	$10,650		35%	-$1,728.00
75	Weekly Rates		18%	75%	36%	3%	30%
76	Running Total Hire Rate								Total Hires		72
77									Total Shows		$252
78
79									New Hire Rate		#REF!
80
81	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
82	6/28/2021	11	300%	800%	100%	100%	200%	4	$10,700		57%
83	6/29/2021	11	2	9	5	2	1	1	$7,500		25%
84	6/30/2021	13	4	10	5	2	2	1	$700		20%
85	7/1/2021	7	1	6	2	2	1	1	$2,000		25%
86	7/2/2021	14	3	11	2	2	3	4	$7,650		44%
87
88	Weekly Totals	56	1300%	4400%	1500%	900%	900%	11	$28,550		38%	$2,688.00
89	Weekly Rates		23%	79%	27%	16%	16%
90	Running Total Hire Rate										#REF!
91
92	Mccranie Law	Total Sets	No Shows	Total Shows	Non-Qualified	Rescheduled	No Hire	Hired	Total $ Collected		Hired Rate
93	7/5/2021										#DIV/0!
94	7/6/2021	25	5	20	4	2	5	9	$9,550		56%
95	7/7/2021	14	1	13	5	0	3	5	$7,450		63%
96	7/8/2021	14	2	12	7	0	4	0	$0		0%
97	7/9/2021	15	4	11	5	1	1	4	$6,535		67%
98
99	Weekly Totals	68	1200%	5600%	2100%	300%	1300%	18	$23,535		51%	$25,920.00
100	Weekly Rates		18%	82%	31%	4%	19%