Fifa world cup 2018 excel download

*
Click to lớn see more
*
Cliông chồng khổng lồ see more
*
Click lớn see more
*
Click to see more
*
Cliông chồng to see more
*
Cliông chồng lớn see more

World Cup Schedule và Scoresheet is an excel spreadsheet to lớn traông xã the schedule and record actual results that you might have sầu been waiting for. Since 2008, I have committed khổng lồ create và provide free fixtures and score sheets for soccer tournaments và leagues. Starting with a simple Euro 2008 and then continued with World Cup 2010, those score sheets have been expanded to lớn have sầu more nice-to-have sầu features to accompany people tracking their favorite teams during that global soccer events. Thanks to lớn Microsoft, too, since they have sầu added more features & functions khổng lồ make creating this spreadsheet easier.

Bạn đang xem: Fifa world cup 2018 excel download

About FIFA World Cup itself, there are not many changes from the number of teams và regulation since 1998, the first time FIFA allow 32 teams khổng lồ participate in the sự kiện. Although, it could be changed by 2026 where 48 teams could compete in the 23rd World Cup.

Template Contents

This template package includes three files:

World Cup Schedule and Scoresheet No Flag FunctionsWorld Cup Schedule and ScoresheetWorld Cup Scoresheet Top Scorer

How To Use The Template

This World Cup Schedule và Scoresheet is my 3rd World Cup spreadsheet. Compare with the previous two spreadsheets, I have added a few features khổng lồ help you personalize this spreadsheet. Furthermore, lớn match more on official group tie-breaker regulation.

*

To start using this template, you can go khổng lồ the upper part of this worksheet to phối your language và timezone. And if you can"t find one, you can personalize it by yourself from Custom Language worksheet.

*

You can customize this spreadsheet by setting its language lớn meet your own language and its timezone lớn fit your own time. I use Google translator tool khổng lồ translate English terms khổng lồ particular language. That translator tool might not translate those words/terms correctly, so you can retype incorrect translation into proper one.

*
Modifying LanguageSelect language that you want lớn correct in cell C7Type new translation for terms that you want khổng lồ correct in E column. You don"t have khổng lồ retype all terms. Just terms that you want to modify.Go to Tournament worksheet và select MY LANGUAGE to lớn change all terms to lớn your new translation language.Modifying Match TimeType your city time difference with Moscow in cell E4. If your time is ahead of Moscow you can put "+" sign in cell D4. If your time is lagging behind Moscow, you can put "-" sign in cell D4.Go khổng lồ Tournament worksheet & select MY CITY to adjust match time with your local time.

Beside those two options, you can also highlights particular group matches, team names and match venues by selecting it from respective dropdown các mục above score sheet table.

After you personalize this tournament worksheet, you can start typing actual results into respective boxes. You can play around with scores lớn see ranking movement of each countries in their respective groups.

Group Standings Simulation

Based on FIFA regulation, actual rankings of teams in each group are determined as follows (regulations Article 32.5):

points obtained in all group matches;goal difference in all group matches;number of goals scored in all group matches;points obtained in the group matches between the teams concerned;goal difference in the group matches between the teams concerned;number of goals scored in the group matches between the teams concerned;fair play points (first yellow card: minus 1 point; indirect red card (second yellow card): minus 3 points; direct red card: minus 4 points; yellow thẻ & direct red card: minus 5 points);drawing of lots by the FIFA Organising Committee.

I have sầu simulated on how each team will rank based on tie-breaker regulation above in their respective sầu groups in this World Cup Schedule and Scoresheet.

*

In Group A, each team has different points. Their rankings will be determined without problem based on rule no 1. It is applied to Group B as well.

In Group C, the top two teams are having similar points. But, France will be put on top because they have sầu better goal difference than Denmark (rule no 2).

In Group D, Argentimãng cầu is put on top because they never lost. The remaining three teams are sharing similar points. Since Nigeria and Iceland have better goal difference than Croatia, Croatia is eliminated. Both Nigeria & Icelvà have similar goal difference and goal scored. And there is no winner in their match. It means, their ranking will be decided by fair play points (rule no 7) since the application of rule 1-6 doesn"t yield a clear winner.

*

Put fair play points next khổng lồ respective sầu team in Custom Language worksheet. You can go lớn FIFA website khổng lồ get the value if it goes khổng lồ that situation. I put -10 for Nigeria và -12 for Icelvà lớn simulate the situation. Since Nigeria have sầu higher fair play points (-10 against -12), then Nigeria is qualified & Iceland is eliminated. This situation also happened in Group E where Brazil is sharing similar record with Costa Rica. Brazil is through because they have sầu better fair play points (-10 against -11). You can see it applied in the second image above.

In Group F, South Korea is put on top of Sweden, because South Korea won over Sweden. Even though their group stats is similar, South Korea have the right khổng lồ advance khổng lồ the knoông chồng out rounds (stopped at rule no 4).

Xem thêm: Top 10 Quán Cà Phê Sân Vườn Bình Thạnh Giá Rẻ View Đẹp, Decor Xinh Chuẩn Sống Ảo

In Group G, winner and runner up is decided by rule no 2.

In Group H, all team have sầu similar points. Goal differences have yielded Polvà lớn become Group H Winner & Senegal lớn be eliminated. Rule no 4 has yielded Colombia lớn qualify since they defeated Japan in their match.

In 2018 year tournament, Group H produced Japan và Senegal as two teams with similar records where their ranks have khổng lồ be decided by rule no 7. How lớn apply it? Go to Custom Language worksheet và put -4 in nhật bản row & -6 in Senegal row. It will switch the position and put nhật bản above sầu Senegal. You can see sample on how rule no 7 implemented in second screenshot above.

What about if after rule no 7, teams are still tied? FIFA has khổng lồ run Rule no 8. Since it is based on drawing, you need to lớn type directly inside group standing table to make it follow the drawing result.

Knock Out Stages Simulation

There are formulas that will automatically place group winners & runner ups in respective sầu brackets. There are conditional formatting formulas that will show background colors based on their respective sầu groups. As you see in group standing table, group A has yellow color where you can see it shown as background color for Russia & Uruguay in their brackets. This color will follow them if they defeat their opponents and advance lớn the next round.

*

In this knoông xã out stages, you just need khổng lồ type actual Full Time score (normal + extra time) in light green boxes next khổng lồ team names. If full time scores is draw, then pink color boxes will be shown where you can fill it with Penalty Shoot Out result. Team who win the match will be move to the next round automatically. Their flags & background color markers will follow accordingly. Type score results until final khổng lồ complete this spreadsheet.

Watch the youtube Clip below to lớn underst& more about how to use this World Cup Schedule and Scoresheet.

I created only two World Cup Schedule and Scoresheet models. One with formulas lớn show country"s flags automatically and one without it. You may use the second one if you got slow processing issues while your Excel processing your inputted scores.

These spreadsheets are không tính tiền to lớn use. But, remember that the license is only for usage within your own businesses. You are not allowed khổng lồ distribute or resell it khổng lồ other parties.

World Cup Score Sheets with Goal Scorers Input

You might want lớn traông chồng goal scorers in World Cup. If that"s the case, you can use this spreadsheet. It has goal scorer tracker capability. I am using my previous World Cup spreadsheet since I prioritize modification for other spreadsheets. I just replaced team names và their squads. Squad names haven"t been officially announced, you need khổng lồ update it with the official ones after they are available. I will update it as well.

This spreadsheet has different format than others to lớn accommodate goal scorers.

To use it, you need to type actual scores for any completed matches. You will see goal scorer dropdown list color markers. You can select player name from that dropdown menu. If there is an own goal, you can select player with (og) bracket behind their names to lớn exclude their goals in top scorer danh mục calculation.

You can see final group standings at the bottom of the worksheet. And there are temporary top scorer danh mục at the right side where you can see names in top scorer các mục. Then, you can continue typing the score và selecting goal scorers for all matches in Knoông chồng Out Stages worksheet. There are 3 score boxes you need to lớn fill, Normal Time (NT), Extra Time (ET) và Penalty Kiông xã (PK) boxes. You will see similar background color cells with goalscorer dropdown list. The number of boxes fill follow the scores in NT and ET boxes. You don"t need to type goal scorers for PK scores since top scorer calculation won"t exclude it in top scorer menu. But, you still need to lớn type PK score lớn decide respective match winner that will advance lớn the next round.

You can see final top scorer danh mục at the top of Knoông xã Out Stages worksheet. If there are more than one player that are having similar goals, a reorder rank table will be shown to lớn allow you lớn reorder their rank based on FIFA correct order. FIFA regulate that there are other parameters, those are their assists and their playing minutes to break the similar goal ties. Since I don"t want to add more complexity inlớn the formula, I made it simple by adding reorder table to rank them manually.

See this youtube đoạn Clip to learn on how khổng lồ use World Cup Scoresheet with Topscorer.