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
  #21  
Old July 5th, 2006, 12:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


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...


Sorry about that (v. embarassing!)

As for the hidden table, I'm impressed by how consise it is (so much
less convoluted than the world cup spreadsheets I've seen. There's a
number of functions I'll need to look up to help me understand it (!)
but for now could I ask what the adg score represents ? Thanks again.


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

  #22  
Old July 5th, 2006, 01: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


Fantastic - its works a dream on the pcs at work (that is soo good to
see!) I've got a couple of thoughts of possible tweaks, if I may.
The main one is to ask if its possible to includea separate worksheet
containing the teamlist (akin to daddylonglegs' table) so the user can
easily add/delete/rename teams? Many thanks again. Garry


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

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

I'll take a look at that. It's a good idea to manage the teams, better than
my suggestion.

What are the others?

--
HTH

Bob Phillips

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

"gdh82" wrote in
message ...

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


Fantastic - its works a dream on the pcs at work (that is soo good to
see!) I've got a couple of thoughts of possible tweaks, if I may.
The main one is to ask if its possible to includea separate worksheet
containing the teamlist (akin to daddylonglegs' table) so the user can
easily add/delete/rename teams? Many thanks again. Garry


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

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



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


gdh82 Wrote:
Sorry about that (v. embarassing!)

As for the hidden table, I'm impressed by how consise it is (so much
less convoluted than the world cup spreadsheets I've seen). There's a
number of functions that I haven't used before so I'll need to look
them up to help me understand it (!) but for now could I ask what the
adg score represents ? Thanks again.


Hi gdh, I'm sure Bob can produce something rather superior to mine but
to answer your question....

"Adg score" should really be "adj score" meaning "adjusted score".
Basically the number of points is adjusted by a very small amount based
on goal difference or goals scored which ensures that when there is a
tie on points the team with the best goal difference has a slightly
higher "adj score" and is therefore ranked higher.

Similarly if both points and goal difference are equal then the team
with the most goals scored will have a slightly higher "adj score"
ensuring, again, that the correct team is ranked higher.


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

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

I use a points, goal difference, goals scored, row algorithm to ensure
unique ranking in mine.

--
HTH

Bob Phillips

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

"daddylonglegs"
wrote in message
news:daddylonglegs.2ah72n_1152108607.7943@excelfor um-nospam.com...

gdh82 Wrote:
Sorry about that (v. embarassing!)

As for the hidden table, I'm impressed by how consise it is (so much
less convoluted than the world cup spreadsheets I've seen). There's a
number of functions that I haven't used before so I'll need to look
them up to help me understand it (!) but for now could I ask what the
adg score represents ? Thanks again.


Hi gdh, I'm sure Bob can produce something rather superior to mine but
to answer your question....

"Adg score" should really be "adj score" meaning "adjusted score".
Basically the number of points is adjusted by a very small amount based
on goal difference or goals scored which ensures that when there is a
tie on points the team with the best goal difference has a slightly
higher "adj score" and is therefore ranked higher.

Similarly if both points and goal difference are equal then the team
with the most goals scored will have a slightly higher "adj score"
ensuring, again, that the correct team is ranked higher.


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

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



  #26  
Old July 6th, 2006, 11:43 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


"Adg score" should really be "adj score" meaning "adjusted score".
Basically the number of points is adjusted by a very small amount based
on goal difference or goals scored which ensures that when there is a
tie on points the team with the best goal difference has a slightly
higher "adj score" and is therefore ranked higher.


Thanks for explaining that, daddylonglegs. IMO that's a really original
way around the problem - I would never have thought of approaching it
like that in a million years! My eyes are being opened...


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

  #27  
Old July 6th, 2006, 12:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


Bob Phillips Wrote:
I'll take a look at that. It's a good idea to manage the teams, better
than my suggestion.

What are the others?


My only other suggestions concern the layout of the table so I guess
this is only my particular preferences and others may disagree.

For my purposes I've been using your league table for about 6-10
players which reduces the size of the fixture grid considerably so I'd
like to have the table on the same page as the fixtures. Ideally this
need only be the 'overall & pts' columns of the table. This is simply
a practical issue when printing off a hardcopy for the office
noticeboard.

I also think the table would look better if it could have alternating
shaded backgrounds for each of rows - just to guide the eye.

The table worksheet has the default orientation as portrait rather than
landscape, by the way.

Finally I did tend to find that with the macro version of the
spreadsheet I'd get run-time errors occasionally after added/deleting
teams and once the errors had started I generally would have to resort
to an earlier version of the spreadsheet. I guess, though, this won't
be an issue with the non-macro version?

Hope I'm not sounding too picky - just take this as constructive
feedback - as I'm already very impressed with your excellent
spreadsheet and am grateful of your willingness to help. Garry


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

  #28  
Old July 6th, 2006, 05:52 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros

Garry,

What I could do is to put the table and the results on the same page, in
separate windows, and the user could then close the second window if they
didn't want it, or it is a small table. The teams table would be separate
though still.

The line shading should be easy with CF, and I will set to landscape.

As for the VBA version, you don't know the sequence of events that caused by
any chance, I would like to fix it.

--
HTH

Bob Phillips

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

"gdh82" wrote in
message ...

Bob Phillips Wrote:
I'll take a look at that. It's a good idea to manage the teams, better
than my suggestion.

What are the others?


My only other suggestions concern the layout of the table so I guess
this is only my particular preferences and others may disagree.

For my purposes I've been using your league table for about 6-10
players which reduces the size of the fixture grid considerably so I'd
like to have the table on the same page as the fixtures. Ideally this
need only be the 'overall & pts' columns of the table. This is simply
a practical issue when printing off a hardcopy for the office
noticeboard.

I also think the table would look better if it could have alternating
shaded backgrounds for each of rows - just to guide the eye.

The table worksheet has the default orientation as portrait rather than
landscape, by the way.

Finally I did tend to find that with the macro version of the
spreadsheet I'd get run-time errors occasionally after added/deleting
teams and once the errors had started I generally would have to resort
to an earlier version of the spreadsheet. I guess, though, this won't
be an issue with the non-macro version?

Hope I'm not sounding too picky - just take this as constructive
feedback - as I'm already very impressed with your excellent
spreadsheet and am grateful of your willingness to help. Garry


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

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



  #29  
Old July 7th, 2006, 02:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default league table without macros


Bob Phillips Wrote:

What I could do is to put the table and the results on the same page,
in
separate windows, and the user could then close the second window if
they
didn't want it, or it is a small table. The teams table would be
separate
though still.

As for the VBA version, you don't know the sequence of events that
caused by
any chance, I would like to fix it.



Thanks again or the further post, Bob. Sounds good to me- would it
possible to print the two separate windows as one page of hardcopy ?

As a very basic workaround on the VBA version I'd simply added a few
'=' operators to the right of the fixture grid that linked to the
relevant cells in the table worksheet. This then gave me the table on
the same worksheet as the fixture grid.

I'm afraid I don't know the exact sequence but I think it was a
combination of adding the table to the fixture worksheet and
adding/deleting teams that caused the run-time errors. Perhaps I was
putting the table in a place where the fixtures overlapped ? Sorry I
can't be more sure than that.

Cheers
Garry


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

  #30  
Old July 15th, 2006, 04:46 PM posted to microsoft.public.excel.misc
gdh82
external usenet poster
 
Posts: 1
Default league table without macros


Hi Bob,

I know its only been a week since the last post and its really
brilliant that you're looking into this at all, but I just wanted to
follow this up and ask how the spreadsheet was going?

Hope I didn't sound too pedantic about the layout issues as really they
are secondary. The only key thing (I think) that needs to be added to
the non-macro version is a tab that can used to add/delete teams.

Look forward to your next post on the subject.
Thanks again
Garry


--
gdh82
------------------------------------------------------------------------
gdh82's Profile: http://www.excelforum.com/member.php...o&userid=35902
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 09:22 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.