Signup

Add a comment »64 comments to this article

  1. Looking for a ten teams playing each other home and away format

    Reply

  2. Need to organise a tournament and need draws to be tabled up.

    Reply

  3. Dziękuję za pomoc.

    Reply

  4. Good day

    I would like to sign up for the sport tournament template

    Reply

  5. yu

    Reply

  6. LIKE TO SEE HOW IT WORKS

    Reply

  7. Thanks

    Reply

  8. Thank you

    Reply

  9. Awesome

    Reply

  10. Good site

    Reply

  11. IT IS A GREAT SITE.

    Reply

  12. HELLO

    Reply

  13. I am a human

    Reply

  14. Lets get this started

    Reply

  15. in Exercise 1 for this question
    sum of items transported to NY, Baltimore and Philadelphia:

    This gives me correct answer
    =sum(sumif(G2:G25,{“NY”,”Boston”,”Philadelphia”),E2:E25))

    But I want to learn what is wrong in the following approach as it returns 0

    =SUMIFS(E2:E25,G2:G25,”NY”,G2:G25,”Boston”,G2:G25,”Philadelphia”)

    Reply

  16. I am into sport and do advance scheduling, with budgets, logistics plans.

    Reply

  17. Thanks.
    Looking forward to learning.

    Reply

  18. Is there any way to unprotect theeating diary workbook I’ve been working on? I have added a bunch of new columns which show up in the statistic’s pivot table fields, but they are grayed out and not included in the table and totals. It may be a problem with the workbook being protected or could be a problem with formulas, although the columns and entry amounts show up in the eating diary. I’d appreciate help with this.

    Reply

  19. why can’t I use the templates I just paid for?

    Reply

  20. Oops! Sorry, Did not realize a comment was required. Thought that the stuff above was proof of humanity. I did enter the correct CAPTCHA crap. I hate technology.

    Reply

  21. Would like to use this for strat-o-matic baseball league with my grandsons.

    Reply

  22. YES

    Reply

  23. I am not sure what you want here. I would like to use thw excel templates

    Reply

  24. human

    Reply

  25. Hi

    Excellent sports tournament spread sheet.
    I have doctored it slightly so all the Tables appear on 1 sheet for printing purposes.

    As we have a different scoring system could you please let me have the password for the option sheet.

    Thx
    Geoff

    Reply

  26. Thank you for sharing your knowledge with us. In one reply messages you said that you will provide us password for option sheet if we signup. So I signup, thanks.

    Reply

  27. I am a human

    Reply

  28. looking to document our bowling club championships

    Reply

  29. Thinking of setting up a tournament (football/Soccer UK) for next June 2019 with either 8 or 10 teams invited, either size would have two groups of 4 or 5 teams playing each other one in group stages listing in league showing, then going into knockout stages with higher teams in each group playing for Cup and lower teams playing for Shield , do you have something already set up in a template for this ?

    kind regards
    Keith

    Reply

  30. Great site for excel inservice. We will have a interschool sports carnival in two weeks time. The sports are Soccer, Touch Footy, Volleyball, Basketball (boys and girls ), netball (girls only) and Athletics (girls and boys).
    The point system for all sport will be the Medal Tally Point System. 1st place – Gold, 2nd place – Silver and 3rd place – Bronze.
    The school with the highest number of Gold should be the winner.

    As such I need assistance for a template. Thank you

    Reply

  31. I like the spreadsheet and have opt for the 10 team double robin. I’m hosting a table tennis tournament where each team hold 3 players. I would like to record the data under the team A for each player vs team B player. So it’s A: 3 players vs B: 3 players and one set of doubles. Ten point system (Team A vs Team B 6:4) Matches are played best-out-of 5.

    Reply

  32. Hi, I was wondering if I made a donation, if you could change a few things for how wins and losses are calculated for a league I run. if you are interested, please email me when you get a chance

    Reply

  33. I want to pratice

    Reply

  34. Hi,
    I have a tournament coming up where there are 10 teams playing 9 rounds. As the top 5 teams are somewhat more proficient than the 6 to 10 teams, is it possible to structure the XL spreadsheet draw that when the top 5 teams play the bottom 5, the top 5 automatically have an 8 point handicap but when the top 5 play against the other top 5 teams it’s even Stevens??
    Cheers

    Reply

  35. Can you please make template for cricket points table
    Thanks

    Reply

  36. Hi. I Need format for 16 teams- Group A, B, C, and D – 4 TEAMS IN EACH-
    2 ADVANCE FROM EACH GROUP FOR QUATER, SEMIS AND THAN FINAL.

    please help me.

    Reply

  37. How to see the result formula

    Reply

  38. I am a human

    Reply

  39. Good morning

    I downloaded a file so I can play a tournament with my young students. I cannot save the file because it needs a password. Do you give out the Passwords? If yes… could you please send me the Password to the Excel file? I have a very small class of six kids with special needs.

    greets from Switzerland

    Karl von Arb

    Reply

  40. Test

    Reply

  41. Please

    Reply

  42. Please let me sign in for my hobby.

    Reply

  43. 12 TEAMS PLAYING EACH WEEK.
    3 TEAMS PLAY EACH OTHER, A V B, A V C, B V C.
    ON 1 PITCH OVER 1 HOUR
    20 MINUTES EACH GAME.
    TEMPLATE FOR 12 TEAM HOME AND AWAY.

    Reply

  44. This is Great

    Reply

  45. How may I get further assistance from you on time?

    Reply

  46. 47CYBU

    Reply

  47. Hello,
    I am inquiring about the tournament spreadsheet, which is great and sort of what I am looking for. I am part of a football league and would like to be able to create a schedule for our parks. I like your spreadsheet but I would like to modify it for an “X” number of teams (more then 15) for a 10 game season with 10 fields per week (each park has their own field). It would also need to have 5 home games for each parks. I was wondering if it would be possible for you and me to collaborate on this. I have something already created but it is all manual and it requires a lot of review to ensure we do not have duplicate games or schedule a 2 teams to play at home on the same day who play against each other.

    Reply

    • Hello,

      I’m glad you like my spreadsheets 🙂 Unfortunately I can’t help you. I left the world of Microsoft and now I’m focusing on Linux.

      Jan

      Reply

  48. Hello Sir,

    Good day to you.
    I have to make football league table for 20 teams, round robin (home & away) and 4 fields in 6/7 weeks matchday. Can you help me with that.
    Thank you, Sir.

    Reply

  49. Hi Your table is great I look after a Lawn Bowling League which scores a bit differently to football our league is based upon the following ranking
    1. Number of points
    2. The difference between shots for and against

    I am not able to adjust your table maybe you can help me please

    Reply

  50. Sports tournament is a great excel template.
    And I want to use him for our billiards club.
    Now I need to make some chances to the sheet.
    I hope I can explain it well.

    Each player has a maximum score, we call it moyenne.
    If a player wins a match, he will get 2 points.
    He also get his moyenne he receives 1 point. He receives a total of 3 points.

    If a player has lost, but he gets his moyenne he get 1 point.

    At a draw both players get 1 point. And also, both players have their moyenne, both player get 1 point.

    {= IF ((home = W4) * (home score> = moyenne), 1, 0)}

    Reply

  51. Sports tournament is a great excel template.
    And I want to use him for our billiards club.
    Now I need to make some adjustments to the sheet.
    I hope I can explain it well.

    Each player has a maximum score, we call it average.
    If a player wins a match, he will get 2 points.
    He also won his moyenne he receives 1 point. He receives a total of 3 points.

    If a player has lost, but he gets his moyenne get 1 point.

    At a draw both players get 1 point. And here too, both players have their moyenne get both player 1 point.

    {= IF ((home = W4) * (home score> = moyenne), 1, 0)}

    Reply

  52. One day tournament, lets hope this works

    Reply

  53. Malhi

    Reply

  54. mil gracias por compartir su trabajo….

    Reply

  55. Hi there I will be running a one day tournament, so may need some assistance with points etc and how it all works. Entries do close end of the week so I will be able to tell you then.

    Thanks

    Reply

  56. Very nice site!

    Reply

  57. Very nice site!

    Reply

  58. Very nice site!

    Reply

  59. It is also possible that Zynga’s chosen advertising network is to blame if we consider the case of the New York Times’ website efdfgceebbbe

    Reply

  60. hi fantastic site,
    im bowls fixtures sec and i use this ten team template which is great thanks, but we play each other twice home and away, please could you tell me how to get the template to work for home and away
    regards colin

    Reply

  61. Hi
    We have a tournament with the following format can not figure out formula for this. We need two separate tables for the pools because the top two teams from each pool play in the semi finals with the 3rd team in each pool eliminated
    2 POOLS WITH THREE TEAMS IN EACH POOL
    ALL TEAMS PLAY EVERY OTHER TEAM IN THEIR POOL ONCE PLUS ONE TEAM FROM THE OTHER POOL.

    Reply

  62. GREAT SITE

    Reply

  63. Thanks a lot for the vast info/knowledge one could benefit from your website.

    Reply



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress