Excel Templates | Excel Spreadsheets

Formula 1 Race Schedule and Championship Dashboard 2014

Posted on March 7, 2014
Filed Under Sports | Leave a Comment

The same with year 2013, Formula 1 season 2014 will be started from Melbourne, Australia, on 16th March. There are still 19 races, but two Asia circuits are dropped (Korea and India), and new Europe circuits are added (Austria and Russia). One things that you have to be aware is, double points will be awarded at the season finale in Yas Marina, Abu Dhabi. Yes, FIA took this decision because they want the race still attractive until the end of the season, with thoughts of Sebastian Vettel, Red Bull, has dominated last season races. But, with plenty of new technical regulations will be implemented in this season, will Red Bull still dominate the race? It is still questionable, since they struggled in pre-season test. Decision has been made, but I wonder if it is implemented 4 years earlier. Felipe Massa should be a Champion in 2008, and Fernando Alonso should lift his third Championship trophy in 2012.

F1 2014 Dashboard Formula 1 Race Schedule and Championship Dashboard 2014

There are plenty of regulations have been changed for the past 10 years. In 2003, 8 top drivers are awarded points to make other drivers can compete with Michael Schumacher-Ferrari (in 2002, Michael Schumacher has grabbed his Championship trophy with 6 races to go). In 2010, the point system is changed again, from 10 into 25 points for race winner. And the results? Sebastian Vettel – Red Bull dominated Formula 1 races. Anyway, we should respect how FIA reacted to make this biggest car race event in the world still become the most attractive event. And new machine regulations (V8 to V6 is already obvious) should make it happened, since all team are started from zero on developing their Formula-1 car where the outcome can be seen in pre-season test where no drivers or constructors were dominating the test session. If you want to know more about those new 2014 regulations, you can go to Formula-1 official website.

Read more

World Cup 2014 Office Pool

Posted on March 3, 2014
Filed Under Sports | Leave a Comment

Following the release of World Cup 2014 Schedule and Scoresheet, I created another template, World Cup 2014 Office Pool, that is ready to be downloaded now. I made some changes and add some features based on feedback I received from you who used my previous Euro 2012 pool template. Features included options to exclude extra time and penalty shoot out in knock out stages match result. And, there are separate leaderboards for group and knock out stages which will give you some flexibilities on managing your game in this tournament.

WC2014 Pool World Cup 2014 Office Pool

You can follow short guidance below to use this spreadsheet :

Go to Setup worksheet. This is a worksheet where you have to setup all the parameter before you play the game.
There is a filename box. It will be used if you plan to rename the file as another name. And remember not to forget replacing it if you have saved the filename as another name or you cannot move between individual player tabs.

WC2014 Pool Setup World Cup 2014 Office Pool

Go to Group Stages Prediction part
Set points for any prediction results. You can change the default points based on your own criteria.
o Point for correct match result (win-draw-loss) with correct score prediction
o Point for correct match result (win-loss) with correct score difference prediction or correct draw prediction only
o Point for correct match result (win-loss) prediction only

Go to Knock Out Stages Prediction part
You can set points differently on any knock out stages. The point classification remains the same with previous classification in Group stages. But, in this knock out round stages, you will option to include/exclude extra time and penalty kick scores as part of your game. For example, if you want all of your players to predict only normal time results, you can exclude both options and points will be given based on those options.

Read more

World Cup 2014 Schedule and Scoresheet

Posted on March 2, 2014
Filed Under Sports | Leave a Comment

Perhaps, this is the template that you might be waiting for. This is a FIFA World Cup 2014 Schedule and Scoresheet that you can use to record all World Cup football matches results which will be held in Brazil, in June 2014. Actually, I have finished this template in December 2013, but I decided to create several models of schedule and scoresheet templates.

World Cup 2014 Schedule and Scoresheet – New Template
This is a new template, release at 1st April 2014. I received some feedback regarding a plain layout of my original template and asked me to create more attractive layout. Then, here it is. I made major changes in its layout, as you can see in picture below. Hope you’ll like it.

World Cup 2014 Schedule and Scoresheet with National Flag Knock Out Bracket 2 V1.63 World Cup 2014 Schedule and Scoresheet

As you can seeĀ  above, I re-designed the knock out stages layout, from table model to bracket model. I put some dummy scores to show you how it looks when the tournament is ended. Other changes are :
> Venue information : There are venue information which will inform you the city where the match is played
> Feature to highlight group, country and venue matches : You can highlight some of group matches based on one or those three parameter. Just delete your selection to remove the highlight
> Feature to add your own language : There is additional worksheet where you can translate the English language used in Tournament worksheet into your own language. Select CUSTOM in language selection before translate it. Don’t use the same country name which already available in language selection or the formula in tournament worksheet will get confused.
> Group color mark in knock out stages. Those 8 Groups will have different color. You can see the color in their standing table header. This color will be placed in knock out stages to inform you from which group the country that advance into the next round.
> There is only two type of box scores in this knock out bracket. Normal/Extra time and Penalty Kick box score. If the matches are ended in normal and extra time period, type the total score in those green boxes. The penalty kick box score will appear if the score until extra time is draw. Enter penalty shoot out result in those pink boxes to reveal the winner.

There are two spreadsheets with different knock out brackets. One spreadsheet with direct team name to replace group winners/runner ups bracket, and the other one with empty bracket that you might need if you want to print it and fill it manually. It is up to you to choose which one that you want to use for this tournament.

Read more

Page 3 of 5412345...102030...Last »