ABCDEFGHIJKLMNOPQRSTUVWX
1
Spreadsheet Rules11Rules for Mock 1.011Rules for Mock 2.0
2
To Do List:Add your own column for things you are going to do laterNo TradesNo Trades
3
If you do something on someone else's list, let them know and mark it green4 hours to pick between 10am to 10pm for local time.4 hours to pick between 10am to 10pm for local time.
4
ParticipantsAdd yourself to either GM or War Room of a teamCan be in 2 Teams due to lack of numbersCan be in 2 Teams due to lack of numbers
5
Please fill out GM list before adding yourself to a war roomPeople who support the team have priority for teamsPeople who support the team have priority for teams
6
Big BoardBig Board is a horizontal input where you can add either your own or a pro website/analyst big boardDraft order will be Mean Average to decide Playoff teams and then Median average to decide who wins the match up. Draft order will be Mean Average to decide Playoff teams and then Median average to decide who wins the match up.
7
Please put the date of the input of the Big Board in the title so we can see when it was last updated.
8
To add your own, please select "Zac" column and right click, then click "insert 1 left" for a your own column. Name it after you and put the date of when you did the power rankings
9
BPABPA is a protected sheet where it uses formulas to take the data from the vertical big board and makes it into a horizontal board
10
Team TrackerTeam Tracker will be a Protected sheet which tracks the positions and players most mock drafted to each team.
11
Betting Odds for SuperbowlLike the Big board, you can have your own power rankings and also input bookies odds or pro websites/analysts power rankings
12
To add your own, please select "Zac" column and right click, then click "insert 1 left" for a your own column. Name it after you and put the date of when you did the power rankings
13
Asterisks next to team name means team has traded a pick
14
(Sheet will be locked until SM1 is over)
15
SM1 MDSM1 MD (Slack Mock 1 Mock Draft) will be where you input everyone's selections in the google sheet. Each Mock Draft will have their own tab of this.
16
Copy Names directly from SM1 BPA
17
SM1 BPASM1 BPA (Slack Mock 1 Best Player Available) will be the Horizontal Big Board as of the time of the mock draft. This means that you can track who's already been selected and make a selection based of BPA. Like SM1 MD, each mock draft will have their own unique BPA from the time of date of the mock.
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