Forum Discussion
I need someone that know NFL Playoffs Brackets works
I have code on file called 2019 NFL playoffs brackets have vba code. look at picture of 2020 NFL playoffs system first before you look at 2020 NFL playoffs brackets this file need vba codes ...
sf49ers19238597 Instead of VBA I just used spreadsheet formulas. see attached.
- I look at file. the formula is look at wrong place in divisional round it should look at score that are in green color area I put score .
Thanks Yousf49ers19238597 I looked at the file and did find a 'bug' but i don't think it is what you think. The RANK for the divisional round is actually looking at the cells to the right of the scores that LOOK blank but actually have formulas in them to pull the rank of the winner. Because of how you said it works, it doesn't fill it in until all 3 results are completed (i.e. not smart enough to say if rank 2 won that it must be the lowest rank ...). The 'bug' i did find was that when I copied the formulas from the upper bracket to the lower bracket I missed moving 1 range in each. That has been corrected in the attached.
- i saw file in divisional need to change teams around teams higher seed should be on top line. teams on bottom be on top line.lower seeds should be on bottom
should look something like this
DIVISIONAL ROUND
AFC
4 Bengals
1 TITANS
3 BILLS
2 CHIEFS
NFC
6 49ERS
1 PACKERS
5 RAMS
2 BUCCANEERS
Thanks you
- Thank you. I wounding how I do as vba code
Thanks You- I wouldn't.
a) why use VBA when worksheet functions do the job?
b) how would you 'trigger' the VBA? If you do it on every change on the worksheet you introduce a lot of overhead and if you add a button then that is an extra step
c) you could use 'onchange' and determine what has changed on the sheet and only update that part of the bracket, but that get pretty complicated and you are essentially trying to recreate what Excel already does with worksheet functions- every time I put in the score
Thanks You
