2007 Men's Bracket

[gohawks011]

How do you add a player on the 2007 men's bracket w/tracker?

 

[Johnbes]

Hi, With the template open in Excel, press F1 to bring up help. You'll see
a link for more information on this template. If that Help article doesn't
give you what you want let me know. Note that the tracker template can track
results of up to 5 players. Is the issue you want to have more than 5
players tracked at a time?

Thanks,
John

 

[jhyzy]

I would like to know how to track more than 5 players at a time using excel
2002 and the 2007 Tournamet template

 

[Johnbes]

Currently 5 is the upper limit, I'll pass that suggestion along to the
Template author and see if they can produce a template with more users. How
many users are in the pool you'd like to track?

Thanks,
John

 

[jhyzy]

I think at least 20 would be ideal the main point would be to be able to add
as many as someone might need, at the present time I don't even know how
many players I may have

 

[Johnbes]

Agreed, its a very simple design that basically hardcodes 5 users. I'll see
what it takes to plug in some more users without breaking the logic of the
worksheet. Going forward having an interactive way to ad users is the way to
go.

Thanks,
John

 

[Johnbes]

Hi, I updated the template with some new cell reference logic and submitted
the updated version through the Customer Submitted Template site. It will
prop in less than 48 hours to the 'Template categories > More categories >
Tournament brackets' category. The updated version has room for 32 players
now. If you want to add more columns, simply copy and paste player 32 as
many times as you'd like to the end of the Tracker worksheet.

Send me a mail at (e-mail address removed) if you'd like to get a copy right
away. I do plan on adding the 1st round teams to the sheet when they are
announced on the 11th.

Thanks,
John

 

[Johnbes]

Hi, I created the NCAA bracket template with team names and 32 users. Its
available for download at http://temp.johnbescom.officelive.com/default.aspx
in 2003 and 2007 format. Note, the Florida A&M-Niagara winner still needs to
be decided in the West, so you'll need to edit the first spot in the West
bracket.

If you can't access the website, feel free to email me at
(e-mail address removed).

I also uploaded the 2007 team/32 user version to Office.Microsoft.com, it
should be available for download from Office Online within 48 hours.

Thanks,
John

 

[jhyzy]

Thanks John, I see he update with the teams, but still only five players in
the tracker. I will give it some time to see if the 32 player tracker posts

Jay

 

[Johnbes]

That's strange, give the new location a try at http://www.johnbes.com.

Thanks,
John