VBA - Google Sheets

	A	B	C	D	E	F	G	H	I
1
2	Air Republic	Name	2026-2027	2027-2028	2028-2029	2029-2030	2030-2031	2031-2032	Awards
3	1	Devin Booker	58.06	61.02	69.88	75.47	FA		2024 Champion
4	2	Jamal Murray	54.46	58.49	62.52	FA			2012 Champion
5	3	Paul George	54.13	56.59	FA				2011 Champion
6	4	Pascal Siakam	48.93	52.3	FA				2025 Runner Up
7	5	Domatus Sabonis	48.07	51.21	FA
8	6	Lauri Markkanen	46.11	49.83	53.54	FA
9	7	Kevin Durant	43.9	46.1	FA
10	8	James Harden	40.25	TBD
11	9	Jalen Brunson	37.74	40.54	43.33	FA
12	10	Mikal Bridges	33.48	36.16	38.84	41.52	FA
13	11	DeMar DeRozan	25.74	FA
14	12	Jabari Smith	23.64	21.75	23.64	25.54	27.43	FA
15	13	Josh Hart	20.92	22.38	FA
16	14	Ivica Zubac	19.55	21	FA
17	15	Andrew Nembhard	19.55	21	FA
18	16	Nickeal Alexander Walker	14.4	15.16	15.92	FA
19	17	Zaccharie Risacher	12.37	15.61	FA
20	18	Nate Ament	4.37	4.59	4.81	7.12	FA
21	19	Nikola Vucevic	FA Rights
22	20	Collin Gillespie	FA Rights
23		Cut Players	10.68	0
24		Total	616.35	573.73	312.48	149.65	27.43	0
25		Salary Cap	351.47	351.47	351.47	351.47	351.47	351.47
26		CapSpace	-264.88	-222.26	38.99	201.82	324.04	351.47
27		Hard Cap
28
29	Exceptions	MLE (26.36)
30
31
32
33		Cut Players:
34		Klay Thompson	5.44
35		Grayson Allen	5.24
36
37
38
39		Total	10.68	0
40
41		Draft Picks IN
42		2027 1st
43		2027 1st (Mallards)
44		2027 1st (DC)
45		2027 2nd
46		2028 1st (huskies)
47		2028 1st (elks)
48		2029 1st
49		2029 2nd
50		2030 1st
51		2030 2nd (dome)
52		2031 1st
53		2031 2nd
54		Draft Picks OUT
55		2028 1st (mallards)
56		2028 2nd (huskies)
57		2030 2nd (Dome)
58
59
60	Bruce Campbell's	Name	2026-2027	2027-2028	2028-2029	2029-2030	2030-2031	2031-2032	Awards
61	1	Nikola Jokic	57.72	FA					2025 Champion
62	2	Bam Adebayo	51.94	56.09	60.25	FA			2024 Runner Up
63	3	Darius Garland	41.23	FA		FA			2013 Runner Up
64	4	Shai Gilgeous Alexander	40.81	63.71	68.8	73.9	79	FA	2006 Runner Up
65	5	Alperen Sengun	35.64	37.34	39.04	FA		FA	2016 3rd Place
66	6	Immanuel Quickley	32.5	32.5	32.5	FA			2022 3rd Place
67	7	Derrick White	30.35	32.6	34.84	FA
68	8	Cam Johnson	23.63	FA
69	9	Jakob Poetl	19.5	25.91	28.17	30.42	FA
70	10	Nikola Jovic	13.93	15.04	16.16	FA
71	11	Cooper Flagg	12.1	12.67	15.98	FA
72	12	Stephon Castle	11.11	14.04	FA
73	13	Tidjane Salaun	8.24	10.45	FA
74	14	Jarace Walker	7.07	FA
75	15	Brayden Burries	5.01	5.35	5.61	5.95	FA
76	16	Ja'Kobe Walters	3.99	6.14	FA
77	17	Christian Anderson	2.89	3.03	3.18	5.39	FA
78	18	Josh Minott	2.59	4.5	FA
79	19	Jaylen Wells	2.3	2.49	FA
80	20	Ousman Dieng	FA Rights
81		Dominick Barlow	FA Rights
82		Cut Players
83		Total	402.55	321.86	304.53	115.66	79	0
84		Salary Cap	351.47	351.47	351.47	351.47	351.47	351.47
85		CapSpace	-51.08	29.61	46.94	235.81
86		Hard Cap
87
88	Exceptions	MLE (26.36)
89		PE (29.12)
90
91		Cut Players:
92
93
94
95
96
97
98		Total
99
100		Draft Picks IN