Data Test Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
Sample87.59%88.88%
4
Vendor 1N/A0.00%
5
Vendor 2 N/A0.00%
6
Vendor 3 N/A0.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/AN/AN/A25%N/AN/AN/A
11
Industry25.00%95.92%N/AN/AN/A24%N/AN/AN/A
12
Company Name 15.00%82.65%N/AN/AN/A12%N/AN/AN/A
13
Tech Stack 10.00%97.96%N/AN/AN/A10%N/AN/AN/A
14
Title5.00%80.61%N/AN/AN/A4%N/AN/AN/A
15
Employee Count20.00%68.37%N/AN/AN/A14%N/AN/AN/A
16
Custom10.00%0.00%N/AN/AN/A0%N/AN/AN/A
17
Custom20.00%0.00%N/AN/AN/A0%N/AN/AN/A
18
Custom30.00%0.00%N/AN/AN/A0%N/AN/AN/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
Loading...
 
 
 
Overview
sample
vendor1
vendor2
vendor3