Hello!
I'm a self-employed German-English translator working for the German government. My one great hobby is soccer. I have tried to create some systems for predicting correct scores in the English Premier league and English Championship league. However, I would love to start from scratch and have my own ranked tables of both leagues which are automatically updated every week, and then I would love to integrate my own amateurish prediction systems. Each league table would have a home and away section, e.g. Home P (Total games played), W (home games won), D (home games drawn) and L (home games lost), F (home goals for), A (home goals against), Pts. Thats 7 cols. Then extra columns with home goals for per game, home goals against per game plus home and away goals per game for the last 6 and 3 home games and away games. And exactly the same for Away games.
A big table!
Then the fixtures (pairings) and results have to be updated in the big table so that it's always up-to-date. I'm lost with the IF function. All I want to do is compare the hgf (home goals for) of the home team (T1) and the agf of the away team before they play... I then subtract one from the other and if T1 has a better home goals for per game than T2's away goals for per game (say, 1.5 vs 1) I subtract T2s from T1s and award T1's hgf/g (home goals for per game average) the difference T1 had maybe 1.2 plus the 0.5 diff. = 1.7.
The diff. between T2's away goals against per game and T1's home goals against per game are treated differently. The weaker team gets the diff. ADDED to its goals against per game. Then I add T1's hgf to T2's aga and divide the sum by 2. Then I add T2's
agf to T1s hga and divide the sum by 2. Using this system to predict correct scores in these 2 leagues made me a profut of 200 pounds last season, but I need HOURS to do it all manually... can you help me, and, if so, how much would it cost me please?
Best,
Ron Shankland
PS I'm asking about costs because I have 4 kids, all hungry, a large dog (very hungry), a house camel and a tame sheep all under my roof. So, as you can imagine, I have to watch the pennies!!! ????
Hi,
I have read your requirements and I am very interested in this project. I have required skills and experience to do this for you at reasonable price. Please feel free to contact me.
Regards,
Junaid Afsar
Graphic Designer & MS Excel Expert
Hello there
I have seen and read your project "I need an Excel expert" and I am very much interested to help.
The skill guiding ,me to handle this work are : Data Entry, Statistics, Excel, German and Data Processing
Hire me direct incase project is deleted by by c;licking this link https://www.freelancer.com/u/errandssolution
Regards
Charity
I just came across your project . I am glad to inform you that I can do this project as per your requirement.
Being experienced in the field of data entry for over 3 years, I have always maintained transparency in long-term professional relationship with client .
I can assure you that your data will be safe in my hand and I will give my 100% to your project with 0% mistakes , so please give me a chance
Thanks..
Hi,
The more I go through your job description, the more I found out how much interesting the job is, because I am a soccer lover too. And my hobby is playing soccer. Apart from these I own a team of four members, each of us are very well detailed oriented excel expert. So, I make sure to you that you will definitely get a quality work from our side.
Thanks and Great Regards
Team TechDev.
Hello sir,
It would please me to help you out with your projects.
Because honestly I consider myself obsessed with statistical predictions, and your project will ecstasize and help me improve in many ways.
Best Regards,
Anna James.