+ Reply to Thread
Results 1 to 8 of 8

Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

  1. 08-15-2019, 11:15 AM #1
    zakwebb47
    zakwebb47 is offline
    Registered User
    Join Date
    08-15-2019
    Location
    England
    MS-Off Ver
    Several different types
    Posts
    7

    Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    Hi everyone,

    I made my own similar version of Super 6 with my colleagues at work and am trying to create a spreadsheet. I have 14 players this season (including myself), 37 weeks each consisting of 10 fixtures each. 5 points for correct score, and 2 points for correct result.

    I want the spreadsheet to be able to automatically work the points out when I type the results in, and I would like to be able to see a weekly league table and an overall league table (as I have weekly prizes and an overall season prize).

    Any chance someone could help me with this please? I would be so grateful!

    I can send me current (terrible manual) spreadsheet over as an example of what I've done so far if needed.

    Thanks, Zak
    Reply With QuoteRegister To Reply
  2. 08-15-2019, 11:53 AM #2
    zakwebb47
    zakwebb47 is offline
    Registered User
    Join Date
    08-15-2019
    Location
    England
    MS-Off Ver
    Several different types
    Posts
    7

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    I found the formula I required on a different thread which works perfectly!
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If anyone could maybe still help with the setting up an automatic league table, that would be amazing thank you.

    I used to be able to do this but haven't used excel properly like this for around 3 years now
    Reply With QuoteRegister To Reply
  3. 08-15-2019, 12:27 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,856

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 08-15-2019, 12:28 PM #4
    zakwebb47
    zakwebb47 is offline
    Registered User
    Join Date
    08-15-2019
    Location
    England
    MS-Off Ver
    Several different types
    Posts
    7

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    Also, does anyone know how, if I leave the actual results box blank (fixtures haven't been played yet), how I can make the points for each person '0' for that gameweek. I know it's something to do with '=BLANK' or =IF'BLANK make '0' but can't remember how exactly. I need to add this on to the current formula. Apologies for sounding stupid.
    Currently it's making anyone that has predicted a score draw, automatically have 2 points, and any 0-0 draws are 5 points, which obviously affects the league table.

    Many thanks again
    Reply With QuoteRegister To Reply
  5. 08-15-2019, 12:33 PM #5
    zakwebb47
    zakwebb47 is offline
    Registered User
    Join Date
    08-15-2019
    Location
    England
    MS-Off Ver
    Several different types
    Posts
    7

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    Please see attached. Thank you.

    Sheet1 is the one I've been working on and with examples. Week 1 in this sheet is complete, and week 2 I've inserted some 'predicitons' and left the actual results blank as the fixtures are yet to be played.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 06-07-2021, 03:35 PM #6
    blairduncan1
    blairduncan1 is offline
    Registered User
    Join Date
    06-07-2021
    Location
    Scotland
    MS-Off Ver
    Excel
    Posts
    2
    Hi Zak,

    Did you ever get an excel sheet together, I am running a Euro predictor with super6 scoring and have about 40-50 entries so could really do with an excel sheet for this.

    Any help greatly appreciated.

    Thanks

    Blair
    Reply With QuoteRegister To Reply
  7. 06-08-2021, 02:31 AM #7
    kvsrinivasamurthy
    kvsrinivasamurthy is offline
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,710

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    In H2 then copy to all range

    =IF(AND(ISBLANK($D2),ISBLANK($E2)),"",IF(OR((D2>E2)-(F2>G2),(D2<E2)-(F2<G2)),0,IF(AND(D2=F2,E2=G2),5,2)))
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.
    Reply With QuoteRegister To Reply
  8. 04-01-2022, 04:50 PM #8
    mrbutler88
    mrbutler88 is offline
    Registered User
    Join Date
    04-01-2022
    Location
    Blackpool, England
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Football Score Predictor - Similar to Super 6 but with 10 fixtures a week

    Why can't I download this file?
    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)

Similar Threads

  1. [SOLVED] IF & AND Functions - Correct Score Predictor
    By johnmcluckie23 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-02-2018, 02:41 AM
  2. CSAT Score Predictor
    By kiki burgh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-08-2017, 03:20 AM
  3. DFS Football Predictor Model
    By jester2itrfe in forum Excel General
    Replies: 1
    Last Post: 09-22-2015, 08:34 PM
  4. Football goal predictor spreadsheet - need help with a formula that outputs WIN/LOSE/DRAW
    By Str1keman in forum Excel General
    Replies: 2
    Last Post: 06-15-2015, 10:26 AM
  5. Football Predictor
    By EMcK in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-27-2014, 08:17 PM
  6. Football League Predictor Workbook
    By oliverhj in forum Excel General
    Replies: 5
    Last Post: 08-17-2010, 10:27 AM
  7. Football fixtures and league creator
    By richardvilla in forum Excel General
    Replies: 2
    Last Post: 07-18-2009, 08:48 AM

Tags for this Thread

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