There were several questions came into my inbox asking on how to make flags in my World Cup 2014 spreadsheets changed dynamically based on country names. I have made a draft on how to create that function one year ago but never had a chance to finish and publish it until now. Because I think, I would rather make a video version of this tutorial to accompany my tutorial article.
Here is the step on creating the excel function, without macros, that will make you change image dynamically based on certain cell value. There are two excel functions used in this spreadsheets (VLOOKUP and INDIRECT) to form dynamic image function. And with a simple trick to combine it with Linked Picture function, you can easily implement it into your excel spreadsheet. You can find online resources or your excel help file to understand those excel functions, if you need more explanation about them.
These are 2014/2015 academic calendars that you can download and use for your school academic scheduling purposes. There are no major modification in these calendars. Based on your feedback, I have created additional calendars that will give you more options on selecting the most suitable one for your school planning.
Newly created additional calendars are :
- Academic Calendars that start on Monday in every week. You can choose between Monday or Sunday as the first day of the week.
- Linear Academic Calendars. With these calendars, you will have another type of calendars that will show your school events in linear layout.
12/13 Month Academic Calendars
For you who are new on using these calendars, these are excel calendars which give you a flexibility to mark its date based on your school academic planning. You can mark just a single date or mark consecutive dates based on your start and end date of you school event period.
Marking Single Date
- Go to Exam-Holiday-Event worksheet
- Type the date and its description in Exam, Holiday, and Important Event Table. Each table will represent different color marker in your calendar. You can change their titles to suit your needs.
Marking Consecutive Dates
- Go to Exam-Holiday-Event worksheet
- There are 3 tables with different color at the rightside of the worksheet where you can type your start and end date to mark your event period.
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.
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.