Find Jobs
Hire Freelancers

Excel Spreadsheet Model

£20-250 GBP

完了済み
投稿日: 5年以上前

£20-250 GBP

完了時にお支払い
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?
プロジェクト ID: 17372517

プロジェクトについて

35個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 reference is because you are trying the change the value of the cell, which is dependent on the current value..This is an issue due to the static nature of excel formulas. I also see, that currently to check any probability you are going to the sheet of the home club and then looking down to find the away club and then calculating the probability What you really need is a Macro, built into excel. This will help getting rid of your circular references. Also it will give you an easier interface to: 1> Enter the final results of any match and the Home Attack Home Defense Away Attack Away Defense will change automatically based on the updated results 2> Select any two clubs, and it will also give the latest numbers on Home Attack Home Defense Away Attack Away Defense and the corresponding probability. This project requires someone has an excellent understanding of excel and VBA and also understands basic statistics. I have over 15 years experience, creating customized excel based solutions for companies like Volvo, Walmart, Pratt and Whitney, Accenture etc My price is aligned to the quality of work I provide. Of-course you can try some of the £100-£200 bidders and hopefully they wont waste your time, or you can msg me and I will be happy to address your queries. Amin
£400 GBP 3日以内
4.9 (6 レビュー)
4.3
4.3
この仕事に35人のフリーランサーが、平均£143 GBPで入札しています
ユーザーアバター
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 professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel, Mathematics, Statistics We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
£210 GBP 3日以内
4.9 (376 レビュー)
8.1
8.1
ユーザーアバター
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 Liverpool changes, and so on .... So not sur if the new scores have to changes the old statistiques.. no ?
£200 GBP 5日以内
4.9 (290 レビュー)
7.7
7.7
ユーザーアバター
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 agreed deadline. Check out my profile, portfolio, and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£150 GBP 3日以内
4.9 (135 レビュー)
7.4
7.4
ユーザーアバター
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 that you've made a good start by using VLOOKUP formulas. However, in order to fully take advantage of Excel power you're going to need some code. Here is where I come! I'm a very skilled Excel VBA developer. I write code that manipulates data and returns useful data instantly. What I suggest is having a macro-enabled Excel file (your file converted to a .xlsb file) that will update Home Attach, home Defense and other values based on actual scores. I can provide additional functionality if you're interested. Let's have a chat to talk to explain my plan to you. Paris Pallas
£140 GBP 3日以内
4.9 (253 レビュー)
7.6
7.6
ユーザーアバター
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日以内
5.0 (275 レビュー)
7.1
7.1
ユーザーアバター
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 part of your job before you award the project. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. If you are satisfied with the result, you can go ahead and award the project. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
£150 GBP 3日以内
4.9 (58 レビュー)
6.5
6.5
ユーザーアバター
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日以内
4.9 (50 レビュー)
6.7
6.7
ユーザーアバター
Hello. I can help with model. Let's discuss details.................................................................................
£100 GBP 3日以内
4.9 (105 レビュー)
6.8
6.8
ユーザーアバター
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 deliver you quality work.
£250 GBP 1日以内
4.8 (117 レビュー)
6.5
6.5
ユーザーアバター
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日以内
4.7 (80 レビュー)
6.4
6.4
ユーザーアバター
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 we could discuss further details about your soccer statistics. Kind regards, Luis Romero
£80 GBP 5日以内
5.0 (145 レビュー)
5.7
5.7
ユーザーアバター
Hi, I'm an engineer in statistics. I'm interested and available to work on your project. Waiting for your contact. Regards.
£99 GBP 5日以内
5.0 (37 レビュー)
5.4
5.4
ユーザーアバター
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, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana
£200 GBP 3日以内
4.8 (80 レビュー)
5.8
5.8
ユーザーアバター
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
£110 GBP 3日以内
5.0 (22 レビュー)
5.3
5.3
ユーザーアバター
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 expertise with years of experience in designing high quality, automated and dynamic Excel based templates & dashboard including Budgeting, Forecasting, Analysis, Reporting and Variables Optimization. Well-versed and significant knowledge of utilization of advance level tools of Excel including VB and Macro.
£100 GBP 2日以内
4.6 (83 レビュー)
5.8
5.8
ユーザーアバター
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日以内
4.8 (26 レビュー)
5.2
5.2
ユーザーアバター
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 further details Best, Yash
£200 GBP 3日以内
5.0 (6 レビュー)
4.3
4.3
ユーザーアバター
I am an organized, experienced professional with more than fifteen years of experience. I have held titles such as Publishing Assistant, Administrative Assistant, Office Administrator, Insurance Administrator, and Graphic Design Artist. I am well-trained in Microsoft Office programs (specializing in Excel) and Photoshop, creating and editing all types of printed material. I design items like t-shirts, banners, brochures, flyers, promotional materials, textbooks, and various other graphic design projects. I am a detail-oriented person that believes in completing a project on time and to the satisfaction of the customer. I am a natural English-speaking person located in the EST of the U.S. Please contact me if you would like any other details about my work history or abilities. I look forward to hearing from you regarding this job opportunity. Thank you.
£111 GBP 5日以内
5.0 (8 レビュー)
3.8
3.8
ユーザーアバター
Hello I think the way around this is to build a macro with a button where we solidify the table before new results are input. There would be two tables, one master and one that's done just before the last round of results which would be hardcoded values. This gets around the circular reference issue. Then once we update for new results which changes the averages then we press a button and solidify those averages for the next set of fixtures. I'm happy to discuss this further. Hopefully it shouldn't take me long to implement. I hope to hear back from you soon. Kind regards Steve
£111 GBP 3日以内
5.0 (8 レビュー)
4.0
4.0
ユーザーアバター
Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions, graphs, pivot tables and Macros using VBA. I perfectly know what you need, we just have to set the details and I’ll start working immediately The most important thing is that I can do the job, quickly and well done. Please, contact me and let's talk about how I could help for your project.
£60 GBP 3日以内
5.0 (14 レビュー)
3.5
3.5

クライアントについて

UNITED KINGDOMのフラグ
Stevenage, United Kingdom
5.0
78
お支払い方法確認済み
メンバー登録日:5月 10, 2007

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。