View Single Post
  #32   Report Post  
Posted to microsoft.public.excel.misc
gdh82 gdh82 is offline
external usenet poster
 
Posts: 1
Default league table without macros


Jon23 Wrote:
I tried finding the 'hidden' table by scrolling right but couldn't find
it, and can anyone tell me how to use the 'adj score'?


Hi Jon23,

To find the 'hidden table' make sure you're on the 'table' tab and
scroll right and its just off screen. The 'adj score' is the clever
idea by daddylonglegs and his explanation of it is:

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


I've actually got a question myself too - for you Jon23, daddylonglegs
or bob phillips or anyone else that might be able to help ?

I really like the ease with which I can add and delete teams using
daddylonglegs' spreadsheet - there's simply a 'teamlist' tab where
teams can be added and deleted - its so elegant! *I would like to
take this feature and add it to bob phillips' spreadsheet (which
displays the fixtures in a grid) - could anyone help me in trying to do
this ammendment ?*

Any help with this would be much appreciated...

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