The 2014 world Cup: Own schedule with Excel to create

The 2014 world Cup is at the door! The Overview of all events to keep you with a schedule that you create in Excel. Here, you will learn how it's done.

Step 1: world Cup groups to enter

GA map of the world Cup in 2014 with all the information you find here. First, create a table, in the groups field.

1. Open Excel with a new document.
2. Click at the bottom left with a right-click on the "table 1" and then click "Rename". For the title, type "groups".
3. Here, you enter the groups as seen in the picture. For each group, you need the columns "winners" and "Second".

Step 2: Group Stage

The new table / table rename the New table / table rename next, enter the matches of the group stage in your document.

1. Rename "table 2" to "group stage". (As explained above)
2. Enter the meetings, as in the example below, ordered by groups.

For Example: Group A

Meeting of the group A meeting of the group A In the Following, we explain to them the example of the group A step-by-step, how the meetings here.

1. In A1 write "group A".
2. Select the cells B2 and C2, click with the right mouse button and select "format cells".
3. Click on the tab "orientation" and put a check mark in the "merge cells". Confirm with "OK".
4. Now enter in the connected cells "result", and at the top, choose the alignment, "Centered".
5. In the cells A3 to A8 and D3 to D8 enter the meetings as in the picture.

Step 3: create finals

The second round, The second round, in order not To each team individually in the final rounds, enter the need to create a reference that does this for you.

1. Create the tables, "the next round", "the quarter-finals", "semi-finals" and "Finale & the game for 3rd place". A new table, you can use the small icon at the bottom next to the Table to create.
2. As soon as the Gruppenplatzierungen fixed, enter the first and runner-up in the Leaderboard.
3. Look in the schedule to, anyone against whom in the round of play. The first round would be, for example, "the winner of group A" against the "second group B".
4. Set the Overview for the knockout stages exactly as it was from the group stage to know.
5. Instead of the individual teams to enter, refer to the cells in which the group winners and second have entered. Write it in the desired cell "=", click on the table "groups" and then on the first or second team. Then confirm with Enter.
6. Behind the meetings of the Achtelfinals enter the following formula: "=IF(B3>C3;A3;D3)". To determine the winner. (The references are valid for the example in the picture)
7. The following final rounds create according to the same scheme, as the knockout stages. This time, they point to the cells in which the winner of the previous finals.

2014 World Cup Internet The 2014 world Cup: Own schedule with Excel to create

The 2014 world Cup: Own schedule with Excel to create

By David Amoyal → Friday, May 16, 2014

The 2014 world Cup is at the door! The Overview of all events to keep you with a schedule that you create in Excel. Here, you will learn how...

World Cup betting game with Excel

Who in the world Cup really want to share the excitement, the power in a betting game. How to use Excel your own betting game design, to be with your friends, colleagues and Acquaintances for the bet to tap here.

Step 1: A game plan for the 2014 world Cup create

First of all you need a game plan. For this, follow to the best of this guide.

Step 2: columns for the game to insert

World Cup betting game for the group A world Cup betting game for the group A When the Board is completely created, next, add columns for the tips of the players and for the points achieved. The Following is the procedure for the example of A group explains.

• In the table "group stage," first, connect the second and third cell to the right of the double cell, in the "result" and fill in "tips".
• In the cell next to carry you "points".
• Then, highlight the range of A2 to G8 (refers to the image) with the mouse.
• Click with the right mouse button and select "format cells".
• Now click on the tab "frame" and then preferences on "the Inside". Confirm with "OK".
• If you want, you can now even the width of the cells, in the tips and results to be entered to adjust. This is, by all the columns in the top bar with the mouse narrow drag.
• At the end of each group and each table, you can still have a cell for the total score of the insert. Here are the points achieved overall and registered.

Step 3: Plan to finish and print
Only a table in Excel Only print a table in Excel print next, repeat the second step for the other groups, and the final rounds. Then print for each game round the table, and bear your tips. A single table, you can print it out:

• Click on the desired table and press [Ctrl] + [P] on the keyboard.
• In the print menu, select "Print", the Option "Selected sheets".
• If all the settings are correct, press "Print".
• The file if you do not want to print, you can take your Excel-betting game with different screen name to save, and then the points manually.
• So that no one can cheat should be the administrator, the typed results with a cell protection. How to explain to you this Tip.

For Excel professionals: points automatically calculate
You can also use a formula to calculate the points. The following instructions, it is a lot of knowledge advance interested can here a lot about the different capabilities of Excel to read.

• Calculation of the points calculation of the points With this formula, you can use the points, which is a hint that it brings to calculate: "=IF((AND(B3=E3;C3=F3));3;IF((B3-E3)=(C3-F3);2;IF(AND((B3 C3)>0;(E3 F3)>0);1;IF(AND((C3 B3)>0;(F3 E3)>0);1;0))))". The Zellbezeichnungen you must, of course, to your table. The above formula refers to the example in the picture.
• The scoring system used to look like this:
• You get three points for a correct result, two points for the correct difference, one point for the correct winner, otherwise zero points.
• The points achieved let you Excel at the end of each group and at the end of each table will be automatically calculated. To do this, use the formula. (=SUM(number1;number2;...))

Points add up and find placements
Finally, you need a formula, with the points of the single player added. To the rankings of 1, 2 and 3, use another formula.

• Create a table in which all players, and the total score will be listed
• Use the formula=SUM(number1;number2;...)"to the points aggregated
• Behind the General score, add the following formula for the rankings:
• "=IF(KGRÖSSTE([field];1);1;IF(KGRÖSSTE([field];2);2;IF(KGRÖSSTE([field];3);3;"")))".
• Where in the formula "[]", enter the range of cells, in which the General score of the player are registered.
• Note: If you have formulas in Excel, copy, "slipping" the cell references. Do you want a formula always fixed on a cell, you can with the "$" character.
• From A7 when you Copy to the right B7. The"$" character prevents. $A7 remains A7, B$8 remains B8.

2014 World Cup Internet Online World Cup betting game with Excel World Cup Betting with Excel

World Cup betting game with Excel

By David Amoyal →

Who in the world Cup really want to share the excitement, the power in a betting game. How to use Excel your own betting game design, to b...

Football world Cup 2014: The best Info pages

The football world Cup 2014 will be the event of the year. So you are well informed through the world Cup is coming, you will find here the best websites with comprehensive information.

FIFA informed around the soccer world Cup of 2014 in Brazil

The most important information about the world Cup, you get, among other things, on the official Website of FIFA.

• Here you will find the eight football world Cup groups and see a well-structured tables, anyone against whom plays. Also a Board in PDF is available for Download.
• For each group, you can get detailed information. Including Top Stories, Hintegrundberichten and Interviews, analyses of the group and, of course, the results of games.
• If you are looking for the host country Brazil are interested in, can be found on the website of the FIF lot of information to the country under the heading "destination".

Kicker.de - Known Alternative with a lot of info for the world Cup 2014

Kicker.de for many football Fans will be the first point of contact. Also about the world Cup reported the Fußballmagazin with articles, Videos and Interviews.

• The football magazine offers you Fußballjournalismus with lots of background articles and beautiful Features. So you can find on the page, such as a table of all the world Cup players and their gate. There is also a small history lesson to the world-Play from Germany since 1934.
• Popular is the page, of course, also because of their Live-Score-Ticker.

11freunde.de Entertaining information about the world Cup

Also the Football magazin 11freunde.de has its own bottom to the world Cup with a lot of different information and Reports.

• At 11freunde.de available in many articles of the Humor in the first place. So there are lots of columns and, for example, a round of introductions of all previous world Cup song.
• But the hard facts you get on the Fußballportal: There is a Live Ticker and, of course, also a Board.

Alternative Info pages for the football world Cup in 2014

Also you can find in the net:

• The Info page wm2014 provides you with all the Relevant information. You can on a Brasielienkarte see where the stages are. In the detailed information about the stages, read something about the capacities and construction of individual stages.
• You are only interested in the DFB-Eleven? On the official site of the DFB you can find all the News about the national team of Joachim Loew.

What Info page is for me the Best?

• Do you want to just check when Germany to the next game need to take, you are on the FIFA page correctly. Here you can find all groups-information and dates on overviewable shown.
• You are more likely to messages about the world Cup interested and want to journalistic recherschierte to read the article, you can contact Kicker.de keep.
• For all that about football like to laugh, we recommend 11freunde.de. But also here you will find, of course, well-researched News.

If you are within the family or in the circle of friends tap want to see you in our practical Tip "world Cup betting game with Excel" a guide.

2014 World Cup Alternative Info pages for the football world Cup in 2014 FIFA Info page for the 2014 world Cup Internet Online

Football world Cup 2014: The best Info pages

By David Amoyal →

The football world Cup 2014 will be the event of the year. So you are well informed through the world Cup is coming, you will find here th...