A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

league table without macros



 
 
Thread Tools Display Modes
  #11  
Old July 3rd, 2006, 01:31 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.


Thanks very much for emailing me the spreadsheet - it runs fine on
the work pcs (which don't allow macros). I especially like how easy it
is to add/delete teams.

I'd like to know more about how it works - where is the hidden table?

The only downside in my opinion is that it doesn't create the fixtures
- ideally a fixture grid (home teams-vertical, away teams-horizontal).
I have a spreadsheet (with macros thought) that does that which I'd
gladly share - I'd like to have a go at merging elements of both
spreadsheets ?

Alternatively, could Bob incorporate a fixture grid into the
spreadsheet he's developing ?


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

  #12  
Old July 3rd, 2006, 01:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the results
format is what you mean.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

I have my own football league table which works without macros. It isn't
that complicated. As Bob suggests, it basically has one "hidden" table
and another table "sorted" in order to view

It has a list of fixtures. As you enter results the table updates based
on 3 points for a win and usual rules to split ties, i.e. goal
difference followed by goals scored.


Thanks very much for emailing me the spreadsheet - it runs fine on
the work pcs (which don't allow macros). I especially like how easy it
is to add/delete teams.

I'd like to know more about how it works - where is the hidden table?

The only downside in my opinion is that it doesn't create the fixtures
- ideally a fixture grid (home teams-vertical, away teams-horizontal).
I have a spreadsheet (with macros thought) that does that which I'd
gladly share - I'd like to have a go at merging elements of both
spreadsheets ?

Alternatively, could Bob incorporate a fixture grid into the
spreadsheet he's developing ?


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:

http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213



  #13  
Old July 3rd, 2006, 04:25 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


Bob Phillips Wrote:
Daddy,

I am in the middle of creating my own, but a couple of questions on how
you
address certain points.

Do you allow for different points scoring systems? I do, by just having
a
data sheet with the points for home and away wins, and a draw. How
about
you?

How do you manage the change of teams over year to year?

How do manage the fact that say you have created the table for 20 teams
and
someone else wants to setup a 22 team table? I am thinking here
specifically
of ensuring the derived data automatically picks up the extra data.

Thanks

Bob


Hi Bob,

To answer your questions.

I created the spreadsheet originally for my own use. It currently only
caters for the standard points system, i.e. 3 points for a win and 1
for a draw but I believe that can be modified fairly easily.

In my sheet you need to list the teams and also the fixtures although I
think gdh82's suggestion of a fixture grid might be a good idea.

The teamlist has to be modified if the teams change, e.g. due to
promotion relegation but it accommodates any number of teams up to 30.

I certainly can't claim it's a work of art (or if it is, it's more of a
Dali that a da Vinci!) but I think it does a reasonable job, perhaps a
good job with some modifications. I can send you a copy if you wish.

If you don't mind, I'll have a look at your VBA version any see if I
can nick any ideas


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213

  #14  
Old July 3rd, 2006, 04:58 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

Please send me a copy. At the very least it will give me ideas on adding
teams as the OP said he liked the way that works.

I will post mine at my website when finished. If you wish I will post yours
also, so that people can see different approaches, and hopefully learn from
studying both.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"daddylonglegs"
wrote in message
news:daddylonglegs.2adlfz_1151940601.8475@excelfor um-nospam.com...

Bob Phillips Wrote:
Daddy,

I am in the middle of creating my own, but a couple of questions on how
you
address certain points.

Do you allow for different points scoring systems? I do, by just having
a
data sheet with the points for home and away wins, and a draw. How
about
you?

How do you manage the change of teams over year to year?

How do manage the fact that say you have created the table for 20 teams
and
someone else wants to setup a 22 team table? I am thinking here
specifically
of ensuring the derived data automatically picks up the extra data.

Thanks

Bob


Hi Bob,

To answer your questions.

I created the spreadsheet originally for my own use. It currently only
caters for the standard points system, i.e. 3 points for a win and 1
for a draw but I believe that can be modified fairly easily.

In my sheet you need to list the teams and also the fixtures although I
think gdh82's suggestion of a fixture grid might be a good idea.

The teamlist has to be modified if the teams change, e.g. due to
promotion relegation but it accommodates any number of teams up to 30.

I certainly can't claim it's a work of art (or if it is, it's more of a
Dali that a da Vinci!) but I think it does a reasonable job, perhaps a
good job with some modifications. I can send you a copy if you wish.

If you don't mind, I'll have a look at your VBA version any see if I
can nick any ideas


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:

http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213



  #15  
Old July 4th, 2006, 07:55 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the
results
format is what you mean.


That's the exactly the perfect layout, Bob !! In fact it turns out I
have been using this spreadsheet of yours and didn't even know it. I
really like it - its just that I can't use it on the work pcs because
they won't allow macros to run

Thanks again for the helpful responses - look forward to more news on
the subject...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

  #16  
Old July 4th, 2006, 10:46 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

You can at least rest assured that my no-macro version will input the scores
in the same way G

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the
results
format is what you mean.


That's the exactly the perfect layout, Bob !! In fact it turns out I
have been using this spreadsheet of yours and didn't even know it. I
really like it - its just that I can't use it on the work pcs because
they won't allow macros to run

Thanks again for the helpful responses - look forward to more news on
the subject...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:

http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213



  #17  
Old July 4th, 2006, 10:49 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

BTW, I haven't received any email address for you yet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

I am not sure what layout you mean. Take a look at my VBA version,
http://www.xldynamic.com/source/xld.LeagueTable.html, and see if the
results
format is what you mean.


That's the exactly the perfect layout, Bob !! In fact it turns out I
have been using this spreadsheet of yours and didn't even know it. I
really like it - its just that I can't use it on the work pcs because
they won't allow macros to run

Thanks again for the helpful responses - look forward to more news on
the subject...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:

http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213



  #18  
Old July 4th, 2006, 01:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


Thanks for pointing this out but I did pm my email details on 2 July and
have re-forwarded them again just now (hope I'm doing it right?)

You can at least rest assured that my no-macro version will input the
scores in the same way G


Great stuff ! Can't wait...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213

  #19  
Old July 4th, 2006, 03:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

I still haven't got it, but I have just posted a first-cut at

http://www.xldynamic.com/example code/xld.league_table_sans_vba.xls

Give it a try and let me know how it goes. When we are happy, I will add it
to the main page, a VBA and a non-VBA version.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"gdh82" wrote in
message ...

Thanks for pointing this out but I did pm my email details on 2 July and
have re-forwarded them again just now (hope I'm doing it right?)

You can at least rest assured that my no-macro version will input the
scores in the same way G


Great stuff ! Can't wait...


--
gdh82
------------------------------------------------------------------------
gdh82's Profile:

http://www.excelforum.com/member.php...o&userid=35902
View this thread: http://www.excelforum.com/showthread...hreadid=557213



  #20  
Old July 4th, 2006, 03:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


gdh82 Wrote:
And could I ask, daddylonglegs - how do I look at the hidden table in
your spreadsheet ? I'd like to try and understand it better but can't
find it ???


Hi gdh,

it's not actually hidden (although it can be) - its just a few columns
over to the right on the table worksheet, just scroll across until you
find it...


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=557213

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
three table database ricardozelaya Database Design 3 April 25th, 2006 12:15 AM
Table Design A. Williams Database Design 3 April 29th, 2005 07:02 PM
Seeking some expert advice. HD87glide Using Forms 14 March 23rd, 2005 11:11 PM
Here's a shocker Mike Labosh General Discussion 2 October 26th, 2004 05:04 PM
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM


All times are GMT +1. The time now is 03:42 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.