Excel Templates | Excel Spreadsheets


Free Excel Templates

2012 Formula 1 Calendar and Championship Tracker

Posted on February 29, 2012
Filed Under Sports | 8 Comments

Share

Formula 1 season 2012 will be started in less than a month. As usual, the first race will take place in Australia. Sebastian Vettel will try to retain his 2011 crown. He will compete with 5 other former champions, Fernando Alonso with his Ferrari, Jenson Button and Lewis Hamilton on their McLaren, Michael Schumacher on his Mercedes and the Iceman, Kimi Raikkonen, now with Lotus. And with surprising pre-season test results in Barcelona this week, Vettel won’t have an easy season like last year.

Every teams has improved their cars, and will make all drivers become a strong contender to Vettel. Even though those 6 F1 Champions are still in favour to win F1 2012 trophy. And there are interesting facts I found when adding a new F1 race winners in this spreadsheet. The previous five drivers who become the pole sitter at Australian GP for the past five years were crowned as F1 champions by the end of those seasons, as you can see in table below.

YearPole PositionWinnerF1 Champion
2011Sebastian VettelSebastian VettelSebastian Vettel
2010Sebastian VettelJenson ButtonSebastian Vettel
2009Jenson ButtonJenson ButtonJenson Button
2008Lewis HamiltonLewis HamiltonLewis Hamilton
2007Kimi RaikkonenKimi RaikkonenKimi Raikkonen

Interesting, isn’t it? Will the driver who get the pole position in this Australian GP crowned as F1 Champion by the end of 2012 season ? We’ll see.

Read more

Tags: , , , ,

Project Gantt Chart Template

Posted on February 25, 2012
Filed Under Productivity | 2 Comments

Share

It has been 2.5 years since I released my first Gantt Chart template for excel. There were many feedback come to me directly through email or via my comment box to add more features and function to ease them creating their plan. With the release of Excel 2007/2010, most of those requirement and features are becoming easy to accomplish, especially the requirement of having more than three conditions to be implemented in one cell. Instead of updating the Gantt Chart post, I decided to publish a new post, because there are major changes have been made in the new Gantt Chart. This Gantt Chart templates are still created without Macro, but require Microsoft Excel 2007/2010 to make all the functions working well.

Below are short guidance about features and how to use this template :
Read more

Tags: , , , , , , ,

Simple To Do List

Posted on November 5, 2011
Filed Under Other | 4 Comments

Share

There are several to do list templates that you can find as part of my excel templates. For example in my daily planner template and gantt chart template. But, if you need a more simple and standalone to do list template, you can use this one. I called it simple because there is no time or date references inside this template. There are only task name and completion status that you have to fill. It is will be more suitable for kind of jobs or tasks that have to be finished without any strict completion time or date or to be finished within one day or short period of time.

There are two kind of templates available. The first one is a single to-do list where it is more suitable to be used for single person. Inside it, there are 26 rows that you can use to fill your tasks. There are no excel formula inside the table. Just type the number, type your tasks name, and type a completion status once you finished your tasks. You can put word “done” or type “v” or any other characters. Remember to leave the status column blank when the tasks are not finished yet. The reason why you have to leave it blank, because the completion bar on top of the table will calculate the percentage of finished job by counting the number of columns that is not blank. You can modify this excel formula to suit your needs.
Read more

Tags: , , , ,

Page 2 of 4412345...102030...Last »