VORP Spreadsheet 2020
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Sheet Explanations
2
Player VORP: Shows the VORP numbers for each player on the DMB disk. In addition, the original team shows whose roster a player was immediately after the draft (and before any trades processed). The current team field shows what roster the player is currently on.
3
Trade Log:Shows the VORP transactions for each trade. There are two rows, one for each side of the trade.
4
Trade Summary:Shows the summary VORP table, inlucding number of trades for each team, the starting and current VORP totals, and the amount of VORP traded and acquired. Remember, 110 is the limit for either dealing or acquiring. This table is sorted in team number order (Akron is Team 0, Flagstaff 23).
5
Team 1 and Team 2:This is the trade analyzer. Here is where you can check individual trade proposals.
6
7
How the Trade Analyzer Works:
1. First, you have to set the teams in each sheet. You need to set the team in two places. There is a drop-down menu in cell D1. Set this to one team and the current VORP numbers for that team will populate in E1.
8
2. Select the same team in the filter in cell D5. This will load the current roster. Make sure any 'x' in Column E are erased prior to doing this, or else the cap numbers will not be right.
9
(Make sure Steps 1 and 2 are done on each sheet)
10
3. Once you have both sheets set up, you can select players to trade by simply typing a lowercase x next to the player(s). You'll notice VORP dealt (B4) and acquired (E4) will increase as appropriate. In addition, in the other sheet, the VORP acquired and dealt will update as well. As these cells update, cell H1 will update to show what your current projected cap numbers will be (current value plus trade).
11
12
13
14
15
16
17
18
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...