My ICT coursework - HELP!!!!!!!!
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: My ICT coursework - HELP!!!!!!!!

  1. #1
    Guest

    Default

     
    Righ, here goes. For my ICT coursework for college, I have to make a system where I have a league table for my sunday league football (or soccer) team. What I need to do is somehow design a system where I can enter the results and it automatically updates the league table. Does anyone know how I might go about this because my teacher's a muppet and I dont get any help from him.

  2. #2
    Guest

    Default

    which college do u go to

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    East Sussex
    Posts
    33
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've seen this question more than once. If you use the search feature on this page and enter 'league as the keyword you might be able to find your answer there.


  4. #4
    Guest

    Default

    I go to Thomas Rotherham College in Rotherham, England.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    Sounds like you want to gwet someone to do all the work to me if thats the case directly post ANY FOOTBALL LEAGUES avalible and leave email ULD ill email at least 3 i have even FULL world cup.

    That will get an A in any exam, but i have no education and suffer as a result so offer you full support to help.

    explain exactly what you want,

    IE one division, number of teams and so on...

    than i can help....


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    Guest

    Default

    Ive got the league table I'm doin I just need to work out how to get it to update itself if I type the results in. Is it possible to do that on Excel?

  7. #7
    Guest

    Default

    I'll e-mail everything to you Jack ok?

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Anon,

    yes, this is possible, I've done it with the current Premiership and Div 2 footie leagues

    In a nutshell, points are awarded if team scores more goals than team b and shared if they are equal. This forms the basis of the league ranking, defaulting to goal difference if their points are equal, so you'd need to factor in goals scored and goals conceded.

    if you put these scores in seperate cells, you can use this as a basis for allocating points and goal difference.

    try thinking about having all yoru teams down one axis and along another axis (say 10 x 10)

    this leaves you with 100 cells, or 100 matches, less the 10 where each team can't play themselves - you'll end up with a grid of home and away ties into which you can slot your scores.

    You can then interrogate these 100 slots with =if functions to gets goals scored, goals conceded and points earned

    then you can sum them for each team and consolidate this info in a summary.

    However, as leagues generally look better with the best team at the top and Celtic at the bott, ooops, I mean the worst team at the bottom, you need to sort this info by points and goal difference.

    Research the =RANK function which will achieve this objective without the need for any manual sorting or macros for sorting

    key functions would be :

    =IF
    =RANK
    =VLOOKUP

    and a lot of trial and error.

    However, having done the trial and error a few times now, I can guarentee you can produce an automatically-updating league table, sorted top to bottom, in a single sheet with just those 3 formulae and the usual favourites like + / - / x

    Have a think - if you really can't figure anything out and Jack doesn't send you a premiership league table, give me a shout and I'll send it to you to let you see the mechanics of it


  9. #9
    New Member
    Join Date
    Oct 2009
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: My ICT coursework - HELP!!!!!!!!

      
    thanks for sharing this Custom Term Paper with us.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com