Team File: Difference between revisions
Vinkesteijn (talk | contribs) No edit summary |
Vinkesteijn (talk | contribs) No edit summary |
||
| (12 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{ | [[Category:Info pages]] {{Template:New Skin Box}} | ||
== Use of Team File == | ''→ Go! [[Introduction Game play|Introduction to Game Play]]''</div><br> | ||
{{Template:New Skin Box}} | |||
== Use of Team File == | |||
The Team File is a very important file for you. Most of your work is done in this file. Of course, there also will be 'live' activities, as well as some other tasks. | The Team File is a very important file for you. Most of your work is done in this file. Of course, there also will be 'live' activities, as well as some other tasks. | ||
This file is a Google Spreadsheet, very similar to an Excel spreadsheet, and is stored in the cloud. You can work with different people, on different devices at the same time. You could use the [https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.sheets&hl=en Google app]. <br> | This file is a Google Spreadsheet, very similar to an Excel spreadsheet, and is stored in the cloud. You can work with different people, on different devices at the same time. You could use the [https://play.google.com/store/apps/details?id=com.google.android.apps.docs.editors.sheets&hl=en Google app]. <br> | ||
| Line 6: | Line 8: | ||
'''Just a few remarks:''' | '''Just a few remarks:''' | ||
* On the tabs Dashboard and Results you have no edit rights. The operating review will be calculated for you automatically. | |||
* You can change all content in the Team File as many times as you want, until the deadline. | * You can change all content in the Team File as many times as you want, until the deadline. | ||
* Be sure to decide who will do the 'last edit'. | * Be sure to decide who will do the 'last edit'. | ||
* Only work in the designated cells. Do not change the layout, add cells, add tabs, rename the file, etc. | * Only work in the designated cells (light green). Do not change the layout, add cells, add tabs, rename the file, etc. | ||
* To correct an error, you can go back many steps with ''Control-Z''. | * To correct an error, you can go back many steps with ''Control-Z''. | ||
* To work smoothly, use the Chrome browser | * To work smoothly, use the Chrome browser | ||
| Line 14: | Line 17: | ||
* Working on your Team File is the most optimal when you are logged in with a Google account. Then you can also use the ''version history'' in the menu and your ‘menu’ will offer more options. | * Working on your Team File is the most optimal when you are logged in with a Google account. Then you can also use the ''version history'' in the menu and your ‘menu’ will offer more options. | ||
* There is no ‘Save' button: Everything is saved automatically. | * There is no ‘Save' button: Everything is saved automatically. | ||
* You can copy/paste from Word, but the layout will | * You can copy/paste from Word, but the layout will not show-up as in Word. | ||
* Next row in a cel with text will be (Windows) Alt + Enter or (Mac) Ctrl + Option + Enter | |||
* Pictures: Use ''insert image'' from the menu. | * Pictures: Use ''insert image'' from the menu. | ||
* Just upload '''one''' | * Just upload '''one''' Team picture and '''one''' new hotel logo, as requested. Pictures should be less then 150 kb. | ||
* As in reality, you cannot change things in the past, so do '''not''' change decisions in any Year if a year has passed | * As in reality, you cannot change things in the past, so do '''not''' change decisions in any Year if a year has passed (it will be greyed-out as well) | ||
* If a year has passed or is not yet 'available', it will be greyed out. | * If a year has passed or is not yet 'available', it will also be greyed out. | ||
<br>Your Team File looks somewhat (all Games are a bit different) like this: | <br>Your Team File looks somewhat (all Games are a bit different) like this: | ||
[[Image: | </div><br> | ||
[[Image: example_new_team_file_first_page_2025 year1 .jpg|thumb|600px|center]] <center>''Team File tab Year 1''</center> | |||
<br> | |||
{{Template:New Skin Box}} | |||
== The Team File structure == | |||
In each game, the assignments will tell you exactly what you are required to do, in which year and when. To get an impression of a completed Team File, you can check: <br> | In each game, the assignments will tell you exactly what you are required to do, in which year and when. To get an impression of a completed Team File, you can check: <br> | ||
<center>[https://docs.google.com/spreadsheets/d/1WbkRvaXj7mJqxD_T4GlpFzavczEeXouUy-xI_1_KKJw Example of a Team File after | <center>[https://docs.google.com/spreadsheets/d/1WbkRvaXj7mJqxD_T4GlpFzavczEeXouUy-xI_1_KKJw Example of a Team File after 5 Years of playing]</center> | ||
By no means this is the perfect Team File; it is just an example. | By no means this is the perfect Team File; it is just an example. | ||
The [[Team File|Team File]], for which you have a private login, is the most important file during game play. In here you will find 4 tabs (bottom of screen): | The [[Team File|Team File]], for which you have a private login, is the most important file during game play. In here you will find 4 tabs (bottom of screen): | ||
* [[Year | * [[Year 1]] tab is where you start making strategic choices, introduce your hotel, your strategy. | ||
* [[Year | * [[Year 2-3-4-5]] tab is where you make your decisions about Years 1-2-3-4 and give [[Explanations]] each year, after the Strategic choices in Year 0. Some competitions / games might have games have less, or more 'years'. | ||
* [[Dashboard]] tab is where you can find an overview of the most important financial results. | * [[Dashboard]] tab is where you can find an overview of the most important financial results. | ||
* [[Results]] tab is where you will find an operating review and other details about results and costs after each year. | * [[Results]] tab is where you will find an operating review and other details about results and costs after each year. | ||
== Editing == | == Editing == | ||
As a Management Team, you fill out all your decisions and explanations in your Team File. If you have problems with copy/paste, please read | As a Management Team, you fill out all your decisions and explanations in your Team File. If you have problems with copy/paste, please read | ||
[https://support.google.com/docs/answer/161768?co=GENIE.Platform%3DDesktop&hl=en Google Docs Help]. There are a lot of tutorials on YouTube about working in Google Spreadsheets. <br> | [https://support.google.com/docs/answer/161768?co=GENIE.Platform%3DDesktop&hl=en Google Docs Help]. There are a lot of tutorials on YouTube about working in Google Spreadsheets. <br> | ||
| Line 40: | Line 47: | ||
Each Year has its own deadline: You are not allowed to work on assignments or change decisions, after the deadline.<br> | Each Year has its own deadline: You are not allowed to work on assignments or change decisions, after the deadline.<br> | ||
There are specific moments in each competition, when all your results will be made visible to you in your Team File, which will mean: | There are specific moments in each competition, when all your results will be made visible to you in your Team File, which will mean: | ||
* On the [[Dashboard]] tab some short [[Coach comment|comments by your coach]] and | * On the [[Dashboard]] tab some short [[Coach comment|comments by your coach and your marks]] and seven graphs on your results | ||
* On the [[Results]] tab | * On the [[Results]] tab | ||
** your operating review (revenues and costs) | ** your operating review (revenues and costs) | ||
| Line 50: | Line 57: | ||
<br> | <br> | ||
''→ Go! Following the Introduction to the Hotel? Step 07/10 is the page [[Business competition|Business competition, click here]]'' | ''→ Go! Following the Introduction to the Hotel? Step 07/10 is the page [[Business competition|Business competition, click here]]'' | ||
< | </div><hr><br> | ||
< | {{footer}} | ||
Latest revision as of 19:12, 8 May 2025
Use of Team File
The Team File is a very important file for you. Most of your work is done in this file. Of course, there also will be 'live' activities, as well as some other tasks.
This file is a Google Spreadsheet, very similar to an Excel spreadsheet, and is stored in the cloud. You can work with different people, on different devices at the same time. You could use the Google app.
You just fill out the requested cells; it's easy.
Just a few remarks:
- On the tabs Dashboard and Results you have no edit rights. The operating review will be calculated for you automatically.
- You can change all content in the Team File as many times as you want, until the deadline.
- Be sure to decide who will do the 'last edit'.
- Only work in the designated cells (light green). Do not change the layout, add cells, add tabs, rename the file, etc.
- To correct an error, you can go back many steps with Control-Z.
- To work smoothly, use the Chrome browser
- A number of cells are blocked; just work in the prewritten cells-locations
- Working on your Team File is the most optimal when you are logged in with a Google account. Then you can also use the version history in the menu and your ‘menu’ will offer more options.
- There is no ‘Save' button: Everything is saved automatically.
- You can copy/paste from Word, but the layout will not show-up as in Word.
- Next row in a cel with text will be (Windows) Alt + Enter or (Mac) Ctrl + Option + Enter
- Pictures: Use insert image from the menu.
- Just upload one Team picture and one new hotel logo, as requested. Pictures should be less then 150 kb.
- As in reality, you cannot change things in the past, so do not change decisions in any Year if a year has passed (it will be greyed-out as well)
- If a year has passed or is not yet 'available', it will also be greyed out.
Your Team File looks somewhat (all Games are a bit different) like this:

The Team File structure
In each game, the assignments will tell you exactly what you are required to do, in which year and when. To get an impression of a completed Team File, you can check:
By no means this is the perfect Team File; it is just an example.
The Team File, for which you have a private login, is the most important file during game play. In here you will find 4 tabs (bottom of screen):
- Year 1 tab is where you start making strategic choices, introduce your hotel, your strategy.
- Year 2-3-4-5 tab is where you make your decisions about Years 1-2-3-4 and give Explanations each year, after the Strategic choices in Year 0. Some competitions / games might have games have less, or more 'years'.
- Dashboard tab is where you can find an overview of the most important financial results.
- Results tab is where you will find an operating review and other details about results and costs after each year.
Editing
As a Management Team, you fill out all your decisions and explanations in your Team File. If you have problems with copy/paste, please read
Google Docs Help. There are a lot of tutorials on YouTube about working in Google Spreadsheets.
Deadlines and results
Each Year has its own deadline: You are not allowed to work on assignments or change decisions, after the deadline.
There are specific moments in each competition, when all your results will be made visible to you in your Team File, which will mean:
- On the Dashboard tab some short comments by your coach and your marks and seven graphs on your results
- On the Results tab
- your operating review (revenues and costs)
- your hotel's key metrics
- market information by Top Research, when bought.
All the results in your operating review and your dashboard are compiled automatically; you don't have to do that yourself! Once a year is closed you get to see the data when the coaches make them visible. Mouseover cells with small black triangles, to show 'the logic'. As a team you focus on the decisions and of course you try to look ahead to what you expect in terms of results and justify all your cost and price decisions.
→ Go! Following the Introduction to the Hotel? Step 07/10 is the page Business competition, click here