+ Reply to Thread
Results 1 to 6 of 6

This is a discussion on Spreadsheets within the Tools of the Trade forum, part of the Football Statistics and History Forum category; Hi all The most useful thing I've found in my 60 years of collecting football stats is a spreadsheet. I prefer Excel 2003 but I've ...

  1. #1
    Barry Atrill is offline 11v11 Forum Member
    Join Date
    Sep 2006
    Location
    South-East Hants, UK
    Posts
    9

    Default Spreadsheets

    Hi all

    The most useful thing I've found in my 60 years of collecting football stats is a spreadsheet.

    I prefer Excel 2003 but I've tried 2007, OpenOffice and Google Docs, but always go back to Excel 2003.

    Barry

  2. #2
    ted
    ted is offline Nursery Member
    Join Date
    May 2011
    Posts
    2

    Default

    openoffice/libreoffice for me - it's free and (almost) as good as excel - if I need to do harder number crunching, I'd switch to 'proper' stuff like R anyway.

  3. #3
    FabriceL is offline 11v11 Forum Member
    Join Date
    Sep 2011
    Posts
    3

    Lightbulb Spreadsheets are great is you don't work with other people...what about new tools?

    I'm the founder of YouFoot (youfoot.com). We worked very hard to create apps that allow to commentate matches. There are 3 apps:

    - Entering the score (fast, easy, but not much stats generated except: Table of rankings, Series, Victory charts...)
    -Match report (what a referee report would contain: goals, booking, substitutions... it generates a lot more stats like Goal Distribution, etc...)
    - Play-by-play commentary (where you detail all plays in a match: Goals, corners, free kicks, shots, corners...)

    The last two generate a lot of stats and a live commentaries in multiple languages (with an AI)

    The main benefits of this approach is:
    + Great looking stats
    + All data can be traced back to individual football actions
    + It's always 1 clic away. It's free. It's collaborative.

    Here are some tutorial videos:
    Tutorials & FAQ

    I look forward feedbacks!
    Note all content generated through YouFoot is open and sharable. You can export any stats you produce in YoUFoot to your website - if this is of interest to you, just contact us.

  4. #4
    deepdale1881 is offline 11v11 Forum Member
    Join Date
    Sep 2011
    Location
    North west England
    Posts
    4

    Default I need a formula in Excel to calculate results - any ideas?

    New member here: glad to be aboard.

    I use Excel 2007 for my various stats sheets and I need a formula that will automatically insert W, D or L into a cell depending on the result of a match. I can do this as a True/False statement for W/L or D but not for all three. Anyone any ideas?

    Thanks.

    Deepdale1881

  5. #5
    FabriceL is offline 11v11 Forum Member
    Join Date
    Sep 2011
    Posts
    3

    Lightbulb W / D / L : youfoot will do that for you in all calendars :)

    We also do the heavy lifting for hundred of stats (especially when slicing them in different ways: per season, per competition, per match...). Don't hesistate to give us feedback too, we have a common passion!

    With regard to your excel question here is a formula that works for your purpose:

    I used a simple set up:
    Cell A1= score for home team
    Cell B1 = score of away team

    Then in C1 I entered:
    =IF(A1>B1;"W";IF(A1<B1;"L";IF(A1=B1;"D")))

    It's using nested IF logical checks. There are probably many ways to go about this, but this works.

  6. #6
    FabriceL is offline 11v11 Forum Member
    Join Date
    Sep 2011
    Posts
    3

    Default

    In case you want to take a look at some stats our apps can generate, here is a team that comments its matchs play-by-play and the resulting stats:
    Portal - Team | YouFoot
    (stats are generated automatically, you just describe actions as shown in How can you become a football commentator? - YouTube)

+ Reply to Thread

Posting Permissions

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