ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Days into season12You Choose the Day
2
Year2018-192019-202020-212021-222022-232023-242024-252025-26
3
Signing Bonus$0$0$0
4
Salary$7,500,000$7,500,000$15,000,000
5
Cap Hit$10,520,231$9,837,838$9,837,838
6
7
Today60Current Day
8
Year2018-192019-202020-212021-222022-232023-242024-252025-26
9
Signing Bonus$2,000,000$8,300,000$3,500,000$3,500,000$3,500,000$3,500,000
10
Salary$1,000,000$3,700,000$5,500,000$2,500,000$2,500,000$2,500,000
11
Cap Hit$10,280,000$6,945,946$6,945,946$6,945,946$6,945,946$6,945,946
12
DateDays into SeasonToday
13
2018-10-0312023-04-25In both tables you can adjust the salary and signing bonus in each year to get your desired contract, and the formulas will determine the cap hits for you. On the top table you can choose the date signed, and on the bottom table the date is automatically set to whatever day it currently is. Below is a table that will help you determine which number to input for "Days into season". If the first sheet is busy you can use one of the others.
14
2018-10-042
15
2018-10-053
16
2018-10-064
17
2018-10-075
18
2018-10-086
19
2018-10-097
20
2018-10-108
21
2018-10-119
22
2018-10-1210
23
2018-10-1311
24
2018-10-1412
25
2018-10-1513
26
2018-10-1614
27
2018-10-1715
28
2018-10-1816
29
2018-10-1917
30
2018-10-2018
31
2018-10-2119
32
2018-10-2220
33
2018-10-2321
34
2018-10-2422
35
2018-10-2523
36
2018-10-2624
37
2018-10-2725
38
2018-10-2826
39
2018-10-2927
40
2018-10-3028
41
2018-10-3129
42
2018-11-0130
43
2018-11-0231
44
2018-11-0332
45
2018-11-0433
46
2018-11-0534
47
2018-11-0635
48
2018-11-0736
49
2018-11-0837
50
2018-11-0938
51
2018-11-1039
52
2018-11-1140
53
2018-11-1241
54
2018-11-1342
55
2018-11-1443
56
2018-11-1544
57
2018-11-1645
58
2018-11-1746
59
2018-11-1847
60
2018-11-1948
61
2018-11-2049
62
2018-11-2150
63
2018-11-2251
64
2018-11-2352
65
2018-11-2453
66
2018-11-2554
67
2018-11-2655
68
2018-11-2756
69
2018-11-2857
70
2018-11-2958
71
2018-11-3059
72
2018-12-0160
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