Very complicated challenge, yet a really interesting one

[wardjdim]

Hello all

I have a tough task, which looks like a riddle for the average person. I know several things about excel, but although I have a book around VBA, I haven't managed to resolve the problem I have right here

Let me explain myself a bit better, and I hope that there will be here enough brains to provide me with the solution. The task is the following. I have the data of several different leagues in a sport. This means that I have League #1 (which consists of 16 teams, playing once a week in 8 different matches, 2 opponents each time, while every week each team might play home or away matches against a different opponent each time), League #2 (same situation, but with different teams and maybe this time 14 teams instead of 16), League 3... until, let's say League 20

Then I have several teams participating in these leagues who compete against each other in a multi-league competition (let's say something similar to the Champions League).

In order to get my data (which I will explain further in the 2nd post), I need to:
1) Create a file for the results of each simple league
2) Create a file for the results of each multi-league
3) Create a file for the results of each team that participates in each simple league only
4) Create a file for the results of each team that participates in both a simple and a multi-league (this would consist of two or three different sheets in the same file)
5) Rank the participants, regarding several different factors, which come out of the results. Rank them a) in the respective league (this would consist of several different factors interfering in order to create rankings of any kind (pretty much ranking per different column), b) overall (again many different rankings and categorizations)

The rankings have to be considered on a matchday basis


This is the introduction. I have several files with data that would provide rather interesting explanations for any of the previous points. If anyone is kind enough to let me know whether they understood the complication of the statement, please encourage me by asking a question or giving me the go-ahead

I apologize for the length of the thread and appreciate your time

 

[wardjdim]

http://www.4shared.com/file/0R09DMuF/1_online.html
http://www.4shared.com/file/GGfsHQzG/2_online.html
http://www.4shared.com/file/Gq6nNN4X/3_online.html


So, the 1st link is depicting a league. Let's say league
#1 with participants and results from 2 matchdays

The 2nd link is league #2

The 3rd link is a multi-league with participants of leagues 1 and 2, in different colors

Column A is matchday, B is the name of the home team, C the name of the away team, D is the home team PTS (instead of "GOALS"), E the away team PTS, F is the home margin (meaning by how many PTS did the home team win. If they lost, then it is a negative number), G is the away margin (if they lost, again negative), H is how many points does the home team get at the end of the match (2 in a win, 1 in a loss), I is how many points does the away team get after the match is over

For the first two files, I need to create the ranking. The teams with 2 points are ranked higher than the teams with one points and then, if after the 2nd match, there are teams with 2 wins, thus 4 points, they would rank at the top, while the ones with 3 or 2 points would rank lower. If two or more teams have the same points, then the one with the higher margin would rank higher, followed by the rest. This would require 18 rows, one for each team, to be refreshed after each matchday. I would also need one sheet for each team, in order to follow each team's results individually

For the third file, I need to create the same ranking and also keep files for each team separately, in different sheets. However, the addition is that I would need to transfer data from the previous two files in order to add their respective league results to the multi-league results

Is there enough explanation for this task?

Thanks a lot once again

 

[wardjdim]

Please, let me know if I am not explaining something clearly

 

[shg]

What you're asking for is broad in scope -- something that you might consider hiring a consultant to do.

Unless someone takes a particular interest, you're more likely to get help if you ask a narrow, specific question.

 

[diddi]

i agree with shg.
you are asking for a software package, not a bit of a hand with a problem in your project. plan out your project and then once you have a structure and have something to work from you may be able to elicit some help with a specific problem (or find references in old threads.)

 

[wardjdim]

Hi and thank you very much for your replies

I am not so sure how the specific question is so difficult to resolve. It is as if we take two sheets and we consider a specific space of sheet #1 as the field where the changes take place and they affect another field in sheet #2

Anyway, if this is so complicated, can you please explain me what exactly do I need to do in order to hire someone to do the job for me?

Thanks again for your time

 

[wardjdim]

Well, no chance to get assistance on that? Or information on how would I get it done through someone I need to pay

I researched online and made sure that it requires macros to do it

Any further info would be highly appreciated