+ Reply to Thread
Results 1 to 31 of 31

Help to automate ranking of tied teams in sports scoring program

Hybrid View

  1. 06-01-2012, 04:20 PM #1
    alan_stephen75@
    alan_stephen75@ is offline
    Registered User
    Join Date
    04-06-2007
    Location
    Glasgow, Scotland
    MS-Off Ver
    2003 / 2007
    Posts
    83

    Re: Help to automate ranking of tied teams in sports scoring program

    I think I can follow your ideas and very clever indeed and I don't know how you managed to do it so quickly, however it doesn't seem to take into account the LSD, if you enter say185 insted of 23.9 into K26 this would increase the LSD total and therefore should make it 2nd rank instead of 1st but it doesn't so there is something not quite right.

    Also I haven't tried it all yet but wondering if there is any way that it would only put the Final Rank number position when it's the last game and leave it empty until then as that the only time it counts and how difficult is it to make it 1st, 2nd, 3rd etc. Again many thanks and apologies for making it so difficult. Regards
    Reply With QuoteRegister To Reply
  2. 06-02-2012, 02:54 AM #2
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Re: Help to automate ranking of tied teams in sports scoring program

    Hi Alan

    Sort out for you.
    Rank only come up once finals results put in of the season.

    NO NEED LSD!

    W or L will do it.
    I have upload sample 2
    Look on C39 to C42
    All 4 teams on 5W and 3L.
    All team play against each other:
    1 SVK 2W 1L
    2 FIN 2W 1L
    3 ITA 1W 2L
    4 GER 1W 2L
    If you look close
    Why SVK TOP? cos SVK beat FIN
    Same with ITA beat GER go 3rd place.
    This will work without LSD.

    How I did it so fast?
    I run 8 ball pool league and Competition.
    I done this 2 year ago. But not W or L.
    That why it didn't take me long to show you how it work.
    If you click on micope21 and look for Visit Homepage.
    This will go to my website.
    page 1 to 12 I put in W or L or 8 ball.
    Rest of the page does it automatic.

    Any problem? let me know.

    Cheers
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1