league table without macros

**gdh82** · 06-30-2006, 05:03 AM

Dear All,

My first post on this forum... I'm after a league table spreadsheet that automatically sorts after entering results but I also want a spreadsheet that doesn't use macros (pcs at work prevent the use of macros - I understand why but its a pain still!).

I know this is possible from looking at this excellent freeware world cup 2006 spreadsheet: http://www.footballsupportersinterna...06/planner.htm

Ideally I'd like to adapt this spreadsheet for my needs but having unhid all of the worksheets I'm blown away by just how complicated it is: For each world cup group the worksheet is 9 PAGES LONG of what seems like duplicated tables!!!

Could anyone help me understand this please or even point me to a similar but simpler league table spreadsheet that doesn't contain macros.

Any help appreciated...thanks in advance.

Garry

Toppers · 06-30-2006, 08:30 AM

As far as I am aware, there is no way of automatically triggering a sort
without a macro. I have a World Cup spreadsheet in which the only code
required is the sort and the sort "trigeer" i.e. an event which causes the
sort to be executed.

"gdh82" wrote:

>
> Dear All,
>
> My first post on this forum... I'm after a league table spreadsheet
> that automatically sorts after entering results but I also want a
> spreadsheet that doesn't use macros (pcs at work prevent the use of
> macros - I understand why but its a pain still!).
>
> I know this is possible from looking at this excellent freeware world
> cup 2006 spreadsheet:
> http://www.footballsupportersinterna...06/planner.htm
>
> Ideally I'd like to adapt this spreadsheet for my needs but having
> unhid all of the worksheets I'm blown away by just how complicated it
> is: For each world cup group the worksheet is 9 PAGES LONG of what
> seems like duplicated tables!!!

>
> Could anyone help me understand this please or even point me to a
> similar but simpler league table spreadsheet that doesn't contain
> macros.
>
> Any help appreciated...thanks in advance.
>
> Garry
>
>
> --
> gdh82
> ------------------------------------------------------------------------
> gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
> View this thread: http://www.excelforum.com/showthread...hreadid=557213
>
>

Bob Phillips · 06-30-2006, 10:50 AM

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

--
HTH

Bob Phillips

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

"Toppers" <Toppers@discussions.microsoft.com> wrote in message
news:D686A24F-6C26-4270-9B59-0C33C1738444@microsoft.com...
> As far as I am aware, there is no way of automatically triggering a sort
> without a macro. I have a World Cup spreadsheet in which the only code
> required is the sort and the sort "trigeer" i.e. an event which causes the
> sort to be executed.
>
> "gdh82" wrote:
>
> >
> > Dear All,
> >
> > My first post on this forum... I'm after a league table spreadsheet
> > that automatically sorts after entering results but I also want a
> > spreadsheet that doesn't use macros (pcs at work prevent the use of
> > macros - I understand why but its a pain still!).
> >
> > I know this is possible from looking at this excellent freeware world
> > cup 2006 spreadsheet:
> >
http://www.footballsupportersinterna...06/planner.htm
> >
> > Ideally I'd like to adapt this spreadsheet for my needs but having
> > unhid all of the worksheets I'm blown away by just how complicated it
> > is: For each world cup group the worksheet is 9 PAGES LONG of what
> > seems like duplicated tables!!!

> >
> > Could anyone help me understand this please or even point me to a
> > similar but simpler league table spreadsheet that doesn't contain
> > macros.
> >
> > Any help appreciated...thanks in advance.
> >
> > Garry
> >
> >
> > --
> > gdh82
> > ------------------------------------------------------------------------
> > gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
> > View this thread:
http://www.excelforum.com/showthread...hreadid=557213
> >
> >

**gdh82** · 07-01-2006, 04:46 AM

Thanks Topper and Bob Phillips for your replies - its much appreciated.

You can do it if you are prepared to have the sorted data as a separate
table, so you have one data capture table unsorted, one sorted display.

How complicated should this be, Bob ? Only the worldcup spreadsheet seems to have 27 versions of the table (over a 9-page worksheet) which I imagine are at varying stages of sorting? This seems too complicated ? Would you happen to know of a simpler spreadsheet by any chance ?

Bob Phillips · 07-01-2006, 05:25 AM

All of the world cup spreadsheets that I have seen are all very complicated,
probably due to in part the authors trying to give them a special look and
feel associated with Germany 2006.

I have a league table which uses VBA, but I will try and adapt it over the
next few days to be VBA free. If you send me your email address I will
notify you if and when it is done.

--
HTH

Bob Phillips

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

"gdh82" <gdh82.2a9atb_1151740202.4206@excelforum-nospam.com> wrote in
message news:gdh82.2a9atb_1151740202.4206@excelforum-nospam.com...
>
> Thanks Topper and Bob Phillips for your replies - its much appreciated.
>
> > You can do it if you are prepared to have the sorted data as a separate
> > table, so you have one data capture table unsorted, one sorted display.
>
> How complicated should this be, Bob ? Only the worldcup spreadsheet
> seems to have 27 versions of the table (over a 9-page worksheet) which
> I imagine are at varying stages of sorting? This seems too complicated
> ? Would you happen to know of a simpler spreadsheet by any chance ?
>
>
> --
> gdh82
> ------------------------------------------------------------------------
> gdh82's Profile:
http://www.excelforum.com/member.php...o&userid=35902
> View this thread: http://www.excelforum.com/showthread...hreadid=557213
>

**gdh82** · 07-02-2006, 06:11 AM

I have a league table which uses VBA, but I will try and adapt it over the
next few days to be VBA free. If you send me your email address I will
notify you if and when it is done.

Thanks very much for this offer, Bob

- I'll send you my email details shortly. Garry

**daddylonglegs** · 07-02-2006, 10:56 AM

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.

If you'd like a copy send me a PM with your email address

**gdh82** · 07-02-2006, 12:10 PM

Thanks daddylonglegs, I'd be grateful of a copy of your league spreadsheet ! PM on the way!! Thanks again Garry

Joaco · 07-02-2006, 10:15 PM

Please send me one copy to jterenas@gmail.com
Many thanks
Joaquim

"daddylonglegs" <daddylonglegs.2abmlz_1151848804.8015@excelforum-nospam.com>
wrote in message
news:daddylonglegs.2abmlz_1151848804.8015@excelforum-nospam.com...
>
> 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.
>
> If you'd like a copy send me a PM with your email address
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=557213
>

Bob Phillips · 07-03-2006, 06:45 AM

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

"daddylonglegs" <daddylonglegs.2abmlz_1151848804.8015@excelforum-nospam.com>
wrote in message
news:daddylonglegs.2abmlz_1151848804.8015@excelforum-nospam.com...
>
> 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.
>
> If you'd like a copy send me a PM with your email address
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=557213
>

**gdh82** · 07-03-2006, 09:31 AM

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, daddylonglegs - 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). would be best, I think. I have a spreadsheet (with macros thought) that does the grid 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 ?

Bob Phillips · 07-03-2006, 10:10 AM

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" <gdh82.2addcb_1151930102.2095@excelforum-nospam.com> wrote in
message news:gdh82.2addcb_1151930102.2095@excelforum-nospam.com...
>
> > 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
>

**daddylonglegs** · 07-03-2006, 12:25 PM

Originally Posted by Bob Phillips

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

Bob Phillips · 07-03-2006, 01:10 PM

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" <daddylonglegs.2adlfz_1151940601.8475@excelforum-nospam.com>
wrote in message
news:daddylonglegs.2adlfz_1151940601.8475@excelforum-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
>

**gdh82** · 07-04-2006, 03:55 AM

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

If I may suggest, Bob, take a look at daddylonglegs' spreadsheet - the means of adding/deleting/renaming teams is simplicity itself. 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 ???

Thanks again guys for the helpful responses - its appreciated and I look forward to more news on the subject...