完了

Excel Spreadsheet Model

I am trying to create a model in excel for football goals, that updates itself as the season progresses.

Each team has 4 elements

Home Attack – How good are they at scoring goals when they are at home

Home Defence – How good are they at defending goals when they are at home

Away Attack – How good are they at scoring goals when they are at home

Away Defence – How good are they at defending goals when they are at home

This gives a table like shown below:

Home Attack Home Defence Away Attack Away Defence

Manchester City 1.43 0.68 1.89 0.46

Arsenal 1.41 0.66 1.60 1.33

Manchester United 1.69 1.08 1.18 0.96

Liverpool 1.69 1.08 1.61 0.88

Tottenham 1.69 1.08 1.47 0.71

Chelsea 1.67 1.00 1.18 0.67

Everton 1.86 1.03 1.00 0.80

Brighton 1.63 1.19 0.61 1.10

Newcastle United 1.64 1.08 0.95 1.10

Leicester 1.59 1.02 1.13 0.99

West Ham 1.69 1.08 0.85 1.27

Watford 1.69 1.08 1.09 0.96

Crystal Palace 1.69 1.08 1.02 1.10

Burnley 1.53 0.94 0.76 0.99

Bournemouth 1.65 0.96 0.80 1.24

Huddersfield 1.69 1.08 0.66 1.06

Fulham 1.67 0.93 0.47 1.24

Cardiff 1.59 1.03 0.71 1.24

Southampton 1.69 1.08 0.85 0.99

Wolves 2.18 1.08 0.66 0.99

As each game happens the values will change. Let’s take an example.

Arsenal v Liverpool

Arsenal Home

Home Attack 1.41 Home Defence 0.66

Liverpool Away

Away Attack 1.61 Away Defence 0.88

The score is Arsenal 2 -1 Liverpool.

Liverpool should concede .88 goals when they are playing away. However Arsenal have scored 2. Which is 2.26 times better.(1/.88*2). Therefore Arsenals Home Attack average will increase, and need to be updated.

Let’s say that Arsenals Home Attack rating is now 1.6, this will need to be replicated in all of the past games when they have been at home, which in turn affect the Away defence rating for all of the teams that they have played.

The same principle applies for the Home Defence, Away Attack and Away Defence figures.

I have tried to build a model but I keep getting circular references. I have attached my attempt.

I am looking for someone to build this model for me if it is possible?

スキル: エクセル, 数学, 統計

さらに表示: example depreciation excel spreadsheet, excel spreadsheet pile cap design bs8110 example, market research excel spreadsheet example, spreadsheet modeling course, spreadsheet modelling examples, excel modeling, excel modelling examples, how to develop a spreadsheet model, spreadsheet modeling wiki, spreadsheet modeling cornell, spreadsheet modeling online course: excel 2013 answers, data entry, excel, visual basic for apps, microsoft excel, example bookstore excel spreadsheet, example excel spreadsheet market research, excel spreadsheet rotten tomatoes score, excel spreadsheet example questionnaire, excel spreadsheet sir epidemic model

採用者について:
( 76件のレビュー ) Stevenage, United Kingdom

プロジェクトID: #17372517

アワード:

aminw

Hi Alan, I went through your requirement and the excel file. Its a great idea to quantify team skills to calculate the probabilities for any match. The reason you are getting the circular ref もっと

£400 GBP 3日以内
(6レビュー)
4.3

37人のフリーランサーが、このジョブに平均£142で入札しています

schoudhary1553

Hi there, Warm Greetings We came along with your request for Excel Spreadsheet Model and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professional もっと

£210 GBP 3日以内
(279件のレビュー)
7.6
bouslimi1979

Hi, I think that we have to proceed with VBA maro, not just formula. Also have some ambiguity : if Arcenal percentage will change, they will also for example change MU rates, and since MU changes, so it will also Liver もっと

£200 GBP 5日以内
(246件のレビュー)
7.4
paris2785

Hi, there. I'm Paris Pallas, a very skilled and experienced Excel developer. Thank you for this detailed brief! I seldom read such thorough briefs. I downloaded and reviewed your attached spreadsheet and I can say tha もっと

£140 GBP 3日以内
(152件のレビュー)
6.8
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

£250 GBP 5日以内
(203件のレビュー)
6.8
koolsidz

Hello :) My Credentials: 20+ of Excel/VBA Experience. [login to view URL] [login to view URL] I am an Visual Basic/MS-Excel Expert besides being an MVP もっと

£122 GBP 7日以内
(148件のレビュー)
6.5
zekovicm

Hi there,I am Miljan,Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the ag もっと

£150 GBP 3日以内
(82件のレビュー)
6.8
Vasilchenko

Hello. I can help with model. Let's discuss details.................................................................................

£100 GBP 3日以内
(81件のレビュー)
6.2
£150 GBP 1日以内
(57件のレビュー)
6.3
seoguru17

I am going through with the requirement and I would like to discuss further for better understanding of the project to deliver 100%

£150 GBP 3日以内
(62件のレビュー)
6.2
archanaoswal

I have excellent command on MS Excel and can fix the issues you are facing and build the Excel model as per your requirement. I have completed complex projects in Excel before. For instance - Get match details, odd もっと

£200 GBP 3日以内
(68件のレビュー)
5.5
usmanhassan123

PhD in statistics and computer science having seven years of experience in Excel models designing. I already designed many excel models like: Waterfall Excel model. you are at right place. please come in inbox I can もっと

£250 GBP 1日以内
(56件のレビュー)
5.9
beltran0404

Hello, I am Luis and it will be my pleasure to assist you with this project. I can help you to solve your current Excel issue and upgrade some other details if it is necessary. Please contact me by chat and then もっと

£80 GBP 5日以内
(93件のレビュー)
5.2
dvcontact

Hi, You won’t select the right candidate without knowing what your project on building a model in Excel for football goals that updates itself as the season progresses will look like. Fortunately, I can complete a par もっと

£150 GBP 3日以内
(32件のレビュー)
5.5
daniyal3214

I can easily design that model with high level of automation and dynamic layout. I am a professional Data Analyst, Financial Modeling and MS Excel expert. MS Excel is the area of my expertise. I posses years of experti もっと

£100 GBP 2日以内
(43件のレビュー)
5.2
antoinepal

Hello, I am an experienced Data Analyst with advanced excel skills. I have build such models in the past in excel. I can deliver you quality work. Just give me the opportunity to show you what i can do. Thanks.

£130 GBP 2日以内
(15件のレビュー)
4.6
£145 GBP 2日以内
(24件のレビュー)
4.5
Valuesolutions

Hello, i have read the details provided..please contact me to discuss more on the project deadline and some other few things

£150 GBP 3日以内
(18件のレビュー)
4.7
cyash61

Hello there, I am a data analytics consultant with more than 6 years of experience working with clients tey globe. With over 40 models built in the past, I am well positioned to take up this role. Please ping for fu もっと

£200 GBP 3日以内
(6件のレビュー)
4.3
cranius

Hi there, I have develop on going soccer statistics tool for betting in the past. It was based on a csv import containing league information. Based on your description I can certainly help you on this project. As r もっと

£98 GBP 4日以内
(11件のレビュー)
3.8
£250 GBP 3日以内
(10件のレビュー)
4.0