# Signup

### Add a comment »56 comments to this article

1. Awesome

2. Good site

3. IT IS A GREAT SITE.

4. HELLO

5. I am a human

6. Lets get this started

7. 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”)

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

9. Thanks.
Looking forward to learning.

10. 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.

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

12. 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.

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

14. YES

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

16. human

17. 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

18. 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.

19. I am a human

20. looking to document our bowling club championships

21. 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

22. 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

23. 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.

24. 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

25. I want to pratice

26. 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

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

28. 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.

29. How to see the result formula

30. I am a human

31. 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

32. Test

33. Please

34. Please let me sign in for my hobby.

35. 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.

36. This is Great

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

38. 47CYBU

39. 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.

• 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

40. 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.

41. 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

42. 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)}

43. 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)}

44. One day tournament, lets hope this works

45. Malhi

46. mil gracias por compartir su trabajo….

47. 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

48. Very nice site!

49. Very nice site!

50. Very nice site!

51. 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

52. 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

53. 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.

54. GREAT SITE

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

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