From an excel with results, create a simulation of a soccer league

[John_Stones87]

Hola!

Tengo la intención de hacer un proyecto y no sé como empezar.

El proyecto trata de que al executar el programa, entro un excel en el qué sólo he puesto unos resultados aleatorios entre 10 partidos y 20 equipos diferentes. 

Una vez seleccionado el excel, el programa tendrà diferentes apartados en los qué cada uno dividirà una cierta información a a pratir de los resultados del excel.

Estos aparatados són; una clasificación dónde los equipos van a estar ordenador según si han ganado, perdido o emptado y también por los goles a favor y en contra.

Alguien me podria ayudar?

Gracias

¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨¨

Hello!

I have the intention to make a project and I don't know how to start.

The project is that when executing the program, I enter an excel in which I have only put some random results between 10 matches and 20 different teams. 

Once the excel is selected, the program will have different sections in which each one will divide some information from the excel results.

These sections are; a classification where the teams will be sorted according to whether they have won, lost or drawn and also by the goals for and against.

Could someone help me?

Thanks

[JimB.]

What's the question? Have you tried to do this and gotten stuck somewhere?

[billko]

---

@John_Stones87 wrote:

Good

Someone would know how to make a project where you insert an excel, in which you only put some results.

And when inserting the excel tea it generates like the statistics of a soccer league With their classification, goals for, against, games played, highest scoring team,... 

---

Is English your first language?  I am having difficulty understanding your question and explanation.  If this is true, it may be better if you posted in your native language.  I am sure there are people who could read it and be able to help.  🙂

[John_Stones87]

The project is that when executing the program, I enter an excel in which I have only put some random results between 10 matches and 20 different teams. 

Once the excel is selected, the program will have different sections in which each one will divide some information from the excel results.

These sections are; a classification where the teams will be sorted according to whether they have won, lost or drawn and also by the goals for and against.

Could someone help me?

Thanks

[billko]

So I have to apologize for somehow not seeing your first post, where you actually did post in your native language.

So it seems that you want to sort the teams by a few different parameters.  Seems pretty straightforward.  So are you having problems getting the data out of the spreadsheet or are you having problems sorting the teams?

Again, my apologies for not seeing the first post.

[John_Stones87]

No hace falta que se disculpe.

Tengo el problema de no saber como hacer, que una vez puesto el excel, se puedan observar las diferentes informaciones.

Sabe como lo tendria qué hacer?

Gracias!

Le ruego que no se disculpa

Gracias por tú ayuda

´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´´

No need to apologize.

I have the problem of not knowing how to make, that once the excel is placed, the different information can be observed.

Do you know how to do it?

Thank you!

I beg your pardon

Thank you for your help

[billko]

Whether or not this is a real Excel spreadsheet, or if it's just a text file delimited file of some sort will drastically affect how you pull out the data, but however that happens, you will end up with a 2D array that should represent teams and stats.

For now, maybe create a constant of two teams and two stats - forget about getting it out of the file for now - and concentrate on your sorting algorithm.

I hope this gets you started.

[billko]

Assuming the teams are arranged in rows and the data in columns, it might be useful to think of each row as a record, and each column as a field in that record - and how you might take that info to create a cluster that represents a record... (And make it a typedef'd control so when the cluster evolves, so do all its copies.)