Data Test Template

	A	B	C	D	E	F	G	H	I	J
1	Instructions							Results
2	#1: Enter your columns under the "Field" title, and their corresponding weighting. #2: Click on the "vendor1" sheet, and enter the results from your first vendor. Do the same for vendor2 and vendor 3 with your other vendor. Ensure that the fields are mapped correctly. #3: Return to this sheet and you'll see the overall match rate AND weighted match rate for each vendor in the "Results" matrix, with the breakdown below.							Name	Overall Match Rate	Weight Match Rate
3								Sample	87.59%	88.88%
4								Vendor 1	N/A	0.00%
5								Vendor 2	N/A	0.00%
6								Vendor 3	N/A	0.00%
7
8
9	Need to Have	Weighting	Match Rate (sample)	Match Rate (V1)	Match Rate (V2)	Match Rate (V3)	Total (sample)	Total (V1)	Total (V2)	Total (V3)
10	First Name	25.00%	100.00%	N/A	N/A	N/A	25%	N/A	N/A	N/A
11	Industry	25.00%	95.92%	N/A	N/A	N/A	24%	N/A	N/A	N/A
12	Company Name	15.00%	82.65%	N/A	N/A	N/A	12%	N/A	N/A	N/A
13	Tech Stack	10.00%	97.96%	N/A	N/A	N/A	10%	N/A	N/A	N/A
14	Title	5.00%	80.61%	N/A	N/A	N/A	4%	N/A	N/A	N/A
15	Employee Count	20.00%	68.37%	N/A	N/A	N/A	14%	N/A	N/A	N/A
16	Custom1	0.00%	0.00%	N/A	N/A	N/A	0%	N/A	N/A	N/A
17	Custom2	0.00%	0.00%	N/A	N/A	N/A	0%	N/A	N/A	N/A
18	Custom3	0.00%	0.00%	N/A	N/A	N/A	0%	N/A	N/A	N/A
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100