[langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

New Reply
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
  #1  
Unread 12th December 2011, 15:16
castro's Avatar
castro castro is offline
Junior Member
MS Office Version: MS Office 2007
MS Office Skill Level: New to MS Office
 
Join Date: Dec 2011
Location: viseu
Posts: 5
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 1
Thanked 0 Times in 0 Posts
Reputation: 10 (4) castro is on a distinguished road
Portugal
Default [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]
     Excel: General   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: General   

[lang=pt]Boa tarde a todos
Estou a precisar de uma grande ajuda da vossa parte.

Eu estou a organizar um torneio de futebol onde irão ser 4 ou 6 equipas.
Gostava de ter um ficheiro em excel onde registe os resultados das equipas e depois saiba a classificação automaticamente.

Dados:
Nº de equipas: 4 a 6
Irão todas jogar entre si

As tabelas deverão apresentar os resultados

Tabela de classificação:
terá de ter:
- nº de pontos
- nº de jogos
- golos marcados
- golos sofridos
- diferença entre golos marcados e golos sofridos

Será que me podem ajudar na resolução do problema?

Muito obrigado[/lang]


Last edited by f.maria; 12th December 2011 at 20:10.
The Code Cage Advertisment
Advertisement
  #2  
Unread 12th December 2011, 19:26
RoyUK's Avatar
RoyUK RoyUK is offline
Administrator
Solution Centre Professional
MS Office Version: MS Office 2003, 2007, 2010
MS Office Skill Level: Proficient with MS Office
 
Join Date: Nov 2008
Location: Derbyshire, UK
Posts: 2,686
Posts Per Day: 1.20
My Top Tip Count: 4
Thanks to others: 2
Thanked 194 Times in 192 Posts
Reputation: 3305 (66) RoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond reputeRoyUK has a reputation beyond repute
4 Top Tips
England
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Why not add a File?
Providing a file for your particular application will not only get you your answer quicker but will better illustrate your problem, usually when we can see your data (it can be dummy data but must be of the same type) and your structure it is far easier for us to give you a tailored, workable answer to your query

Fornecendo um arquivo para a sua aplicação particular, não só vai chegar a sua resposta mais rápido, mas vai ilustrar melhor o seu problema, geralmente quando podemos ver os seus dados ([I] que podem ser dados fictícios, mas deve ser do mesmo tipo [/ I]) e sua estrutura é muito mais fácil para nós dar-lhe uma resposta, adaptados viáveis ​​para sua consulta
__________________
Hope that helps, RoyUK
For tips & examples visit free excel help
DatabaseForm
About me

  #3  
Unread 12th December 2011, 19:55
Pete_UK's Avatar
Pete_UK Pete_UK is offline
Solution Centre Professional
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
 
Join Date: Mar 2009
Location: Warrington, England
Age: 62
Posts: 625
Posts Per Day: 0.30
My Top Tip Count: 0
Thanks to others: 8
Thanked 132 Times in 131 Posts
Reputation: 2587 (37) Pete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond repute
Great_Britain
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Do your teams play home and away, so that with 6 teams each would play 10 times, or is it just one match against each of the other teams (5 games, as in a weekend tournament)?

Pete

The Code Cage Advertisment
Advertisement
  #4  
Unread 13th December 2011, 10:22
castro's Avatar
castro castro is offline
Junior Member
MS Office Version: MS Office 2007
MS Office Skill Level: New to MS Office
 
Join Date: Dec 2011
Location: viseu
Posts: 5
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 1
Thanked 0 Times in 0 Posts
Reputation: 10 (4) castro is on a distinguished road
Portugal
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


[lang=pt]Bom dia
Eu queria fazer umas tabelas do género do que vai em anexo.
Já tentei alterar os nomes da tabela, mas fica tudo desconfigurado.

Eu queria ter uma tabela dos jogos onde coloco os resultados e a tabela de pontuação deveria actualizar automaticamente.

alguém me pode ajudar?

obrigado[/lang]
Attached Files To view attachments in this forum your post count must be 2 or greater. You currently have 0 posts.

  #5  
Unread 13th December 2011, 13:23
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is online now
Administrator
MS Office Version: MS Office 97 - 2013
MS Office Skill Level: Can use most of MS Office
 
Join Date: Aug 2008
Location: Manchester, England
Age: 50
Posts: 11,684
Posts Per Day: 5.02
My Top Tip Count: 11
Thanks to others: 41
Thanked 427 Times in 412 Posts
Reputation: 6454 (187) Simon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond reputeSimon Lloyd has a reputation beyond repute
11 Top Tips
Wales
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Google translation
Quote:
Originally Posted by Castro

good day
I wanted to make some tables of the kind that goes attached.
I've tried changing the table names, but everything is mangled.

I wanted to have a gaming table that holds the results and points table should update automatically.

someone help me?

__________________
Regards,
Simon Lloyd
Microsoft Office Help

Want to say thanks? then hit this How to say thanks! button in any post you want to thank
If you find one of my posts helpful then hit this one Helpful Answer in the post that helped most!



  #6  
Unread 13th December 2011, 14:30
Pete_UK's Avatar
Pete_UK Pete_UK is offline
Solution Centre Professional
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
 
Join Date: Mar 2009
Location: Warrington, England
Age: 62
Posts: 625
Posts Per Day: 0.30
My Top Tip Count: 0
Thanks to others: 8
Thanked 132 Times in 131 Posts
Reputation: 2587 (37) Pete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond repute
Great_Britain
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Hi Castro,

I've downloaded your file and it seems to do what you are asking for, so what help do you want from us?

Pete

The Code Cage Advertisment
Advertisement

To stop seeing these ads and get other benefits check This page!

  #7  
Unread 13th December 2011, 14:33
castro's Avatar
castro castro is offline
Junior Member
MS Office Version: MS Office 2007
MS Office Skill Level: New to MS Office
 
Join Date: Dec 2011
Location: viseu
Posts: 5
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 1
Thanked 0 Times in 0 Posts
Reputation: 10 (4) castro is on a distinguished road
Portugal
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Quote:
Originally Posted by Pete_UK View Post

Hi Castro,

I've downloaded your file and it seems to do what you are asking for, so what help do you want from us?

Pete

[lang=pt]Eu queria alterar os nomes nas tabelas dos jogos.
Deixa fazer a alteração, mas depois a tabela de classificação fica desconfigurada.

Será que dá para fazer umas tabelas semelhantes onde eu depois possa colocar os nomes que quero?

obrigado[/lang]

  #8  
Unread 13th December 2011, 14:43
Pete_UK's Avatar
Pete_UK Pete_UK is offline
Solution Centre Professional
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
 
Join Date: Mar 2009
Location: Warrington, England
Age: 62
Posts: 625
Posts Per Day: 0.30
My Top Tip Count: 0
Thanks to others: 8
Thanked 132 Times in 131 Posts
Reputation: 2587 (37) Pete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond repute
Great_Britain
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Google translation:

Quote:
I wanted to change the names of tables games.
Lets make the change, but then the league table is misconfigured.

Can she make some similar tables where I can then put the names I want?

Thank you

I'll need to look at it again, but the names of the teams should be independent of any named ranges.

Hope this helps.

Pete

  #9  
Unread 13th December 2011, 19:25
Pete_UK's Avatar
Pete_UK Pete_UK is offline
Solution Centre Professional
MS Office Version: MS Office 2003, 2007
MS Office Skill Level: Proficient with Excel
 
Join Date: Mar 2009
Location: Warrington, England
Age: 62
Posts: 625
Posts Per Day: 0.30
My Top Tip Count: 0
Thanks to others: 8
Thanked 132 Times in 131 Posts
Reputation: 2587 (37) Pete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond reputePete_UK has a reputation beyond repute
Great_Britain
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


Hi Castro,

I've amended your file (attached) so that you can put the names of the teams in the yellow cells (in column W), and the fixtures will automatically adjust. This is to suit seven teams, as with your original file.

Hope this helps.

Pete
Attached Files To view attachments in this forum your post count must be 2 or greater. You currently have 0 posts.

The Code Cage Advertisment
Advertisement
  #10  
Unread 13th December 2011, 22:08
castro's Avatar
castro castro is offline
Junior Member
MS Office Version: MS Office 2007
MS Office Skill Level: New to MS Office
 
Join Date: Dec 2011
Location: viseu
Posts: 5
Posts Per Day: 0.00
My Top Tip Count: 0
Thanks to others: 1
Thanked 0 Times in 0 Posts
Reputation: 10 (4) castro is on a distinguished road
Portugal
Default Re: [langtitle=pt]Como fazer uma tabela para torneio de futebol[/langtitle]

------ Register to get rid of these "In Post" ads! ------


[lang=pt]Boa noite

Sim, já funciona
Ao alterar os nomes das equipas, ele altera automaticamente.

Mas se forem só 4 equipas as tabelas ficam todos desconfiguradas.

Em principio vamos limitar o torneio só para 4 equipas.

Será que dá fazeres de maneira a que funcione bem só com quatro equipas?
(ver anexo)[/lang]
Attached Files To view attachments in this forum your post count must be 2 or greater. You currently have 0 posts.

The Code Cage Advertisment
Advertisement
New Reply
The Code Cage at Facebookhe Code Cage at Twitter


Tags
como, fazer, futebol, para, tabela, torneio, uma

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 02:35.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University