Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Sports Team Excel Template Soccer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
llong@zaltec.com - 15 Nov 2006 21:16 GMT
I have created a soccer form for my church soccer team that I would
like to share with anyone who might need it.

It has 4 sheets. They are: Player Information, Lineup, Handouts and
Schedule. Everything is pretty much automated after you enter the
player/coach/schedule information manually. I created this spreadsheet
because we need to make sure everyone got equal playing time (it's for
rec. leagues only) and wasn't out two consecutive periods.

The Player information page is self explanatory.

The LineUp Page allows you to just click on the box with the players
name to insert him/her into one of the positions. If the player shows
up in red, you have that player in twice in the same quarter.
It will also show on the right side of this page how many periods each
player is scheduled to play and it has a box to remove a player from
the specific game if they are unavailable.
It also shows which players should be on the bench for each quarter.
This really helps with the little kids because it is easier to see who
is out than who is in. If they are on the bench for two consecutive
quarters, their name will show up in red to let you know. We try not to
make a player sit out for two consecutive periods.

The Handout sheet is desidgned to be printed, cut out and handed out to
the players before each game so they will know what position to go to
each quarter without the coach having to tell them. All of the
information on this sheet is automatically inserted based on the
lineup. This is mostly for the younger kids.

The schedule page is self explanatory.

I have worked on this for some time to get it working correctly and
thought I would share it with anyone who may need it.

I also have created the same type sheet for basketball and baseball.

You can email me at llong@zaltec.com if you would like me to send you
the template.
Paul Ballou - 16 Nov 2006 07:39 GMT
http://office.microsoft.com/en-us/templates/FX100595491033.aspx
If you want to share it then you might try to submit here using the Submit
templates link....
Signature

Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

>I have created a soccer form for my church soccer team that I would
> like to share with anyone who might need it.
[quoted text clipped - 34 lines]
> You can email me at llong@zaltec.com if you would like me to send you
> the template.
llong@zaltec.com - 16 Nov 2006 20:52 GMT
Normally I would, but this is an Excel 2003 file and they only accept
office 2007 templates.

> http://office.microsoft.com/en-us/templates/FX100595491033.aspx
> If you want to share it then you might try to submit here using the Submit
[quoted text clipped - 41 lines]
> > You can email me at l...@zaltec.com if you would like me to send you
> > the template.- Hide quoted text -- Show quoted text -
Paul Ballou - 17 Nov 2006 08:21 GMT
If you would email it to me A26runner@aol.com I will pass it on to my
brother who coaches soccer

Thanks

Signature

Paul Ballou
MVP Office
http://office.microsoft.com/home
http://www.freeserifsoftware.com/
http://www.ballousgiftshop.com

> Normally I would, but this is an Excel 2003 file and they only accept
> office 2007 templates.
[quoted text clipped - 48 lines]
>> > You can email me at l...@zaltec.com if you would like me to send you
>> > the template.- Hide quoted text -- Show quoted text -

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.