Laputka Law - Weekly Reporting Sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Laputka 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/3/2021										#DIV/0!		40%	$2,500		$526,500

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