Excel Templates | Excel Spreadsheets

Employee Vacation Planner

Posted on June 18, 2015
Filed Under Productivity | Leave a Comment

This is an Employee Vacation Planner template you can use to plan and track taken vacation by your employee. Setting up, planning and tracking are done in Vacation Tracker worksheet while seeing monthly summary can be done in Vacation Summary worksheet. Because of different summary report/dashboard required by many companies, I created a plain vacation table with necessary format to ease you to utilize it properly. If you think this template is fit with your requirement and you want to generate your own report, you can purchase the unlocked version where you can access all codes inside to create your own report.

Employee Vacation Planner for Excel

Getting Started
– Fill your company fiscal year start date in cell D6
– Select your attendance observation period in cell D7. There are 2 options, today or end of fiscal year. This selection is used to calculate the number of working days. You can switch this selection any time.

Customizing Vacation and Holiday Codes
– There are 4 codes (A,B,C,D) with respective colors available to be personalize to meet your company vacation codes in cell H4-H7.
– Change its code name as well as its description. For example, you can change A to L and type Leave in its description. So, if you typed L in Vacation Tracking Table, its cell color will turn into orange.
– Change holiday color code from R to H or any other letter or you can leave it as it is. Read more

2015/2016 Academic Calendar Templates

Posted on June 13, 2015
Filed Under Calendar | Leave a Comment

A new academic year is about to begin again in most countries around the world that adopt summer to summer academic year period which usually start in July until October. These are Excel Academic Calendar Templates for year 2015/2016. I created new models that will give you more options on selecting the suitable one to map your school agendas. You can see the outlook of new models in picture below.

2015/2016 Academic Calendar - Excel

As you can see in the picture, the new models will give you area to put your school agenda information in the same page with the calendar. Calendars will be divided into 2 columns at the left and right side of the page, where school agenda information will be put in the middle. There are two separate table available to be filled where the top table is allocated for fixed dates and the bottom table is allocated for consecutive dates. Dates typed in the table will be marked in the calendar with specific color, based on color code you put in color code column. Fixed and consecutive dates could have the same color because there is no restriction on the color code placement usage. It will be useful if you want to colorize your holiday and school break with the same color, for example red, to remind your students and teachers that there is no school activities in those days. You can also mark your school term, for example, if you are following a quarter system, you can divide your one year school period into 4 quarters and add any school activities marker on top of those quarter markers. I put some dates for example in August 2015 – July 2016 model. As you can see in that calendar, I typed four consecutive dates for Quarters period, 1st and 3rd quarter have brown color (color code:E4) while 2nd and 4th quarter have yellow color (E5). I put two week Christmas Break with red color and final exams of 1st Quarter with green color. And on top of the table, I put US holidays with all red color code. You can also apply this into your trimester system.

Read more

Women’s World Cup 2015 Schedule and Scoresheet

Posted on June 3, 2015
Filed Under Sports | Leave a Comment

I made this FIFA Women’s World Cup 2015 schedule and scoresheet with Soccer Tournament Creator spreadsheet. I didn’t plan to make it, but there are many requests came into my mailbox asking about Schedule and Scoresheet for this football tournament. Different from my World Cup 2014 schedule and scoresheet, I have neither created a specific template nor modified existing World Cup template, because the platform is not the same. Women’s World Cup 2015 will be joined by 24 teams while previous Men’s World Cup 2014 has 32 participants. Only the next Euro 2016 soccer tournament that will have the same number of teams. Because the tournament will begin in less than a week, and creating specific schedule and scoresheet require more new formulas and, I decided to use my Soccer Tournament Creator to form this tournament schedule and scoresheet. I think, this will be enough for you who need to track the progress of your team in this tournament.

Women's World Cup 2015 Schedule and ScoresheetWomen's World Cup 2015 Scoresheet - Knock Out Round

Women’s World Cup 2015 will be held in Canada from 6 June until 5 July 2015. There are 24 countries, divided in 6 groups, that will compete in this tournament, those are :
Group A : Canada, China PR, New Zealand, Netherlands
Group B : Germany, Ivory Coast, Norway, Thailand
Group C : Japan, Switzerland, Cameroon, Ecuador
Group D : United States, Australia, Sweden, Nigeria
Group E : Brazil, South Korea, Spain, Costa Rica
Group F : France, England, Colombia, Mexico

The 1st and 2nd position from each groups will qualify for round of 16 automatically. And the best four 3rd position will complete round of 16 brackets. After all group matches are completed, teams will be ranked based on this tie breaker rule :
1. All Matches – Highest Point
2. All Matches – Better Goal Difference
3. All Matches – Better Goals Scored
4. Team Concerned Matches – Highest Point
5. Team Concerned Matches – Better Goal Difference
6. Team Concerned Matches – Better Goals Scored
7. FIFA drawing

In round of 16, teams will be paired based on this arrangement
– Winner Group B vs 3rd Group A / C / D
– Runner-up Group A vs Runner-up Group C
– Winner Group E vs Runner-up Group D
– Winner Group F vs Runner-up Group E
– Winner Group A vs 3rd Group C / D / E
– Runner-up Group B vs Runner-up Group F
– Winner Group D vs 3rd Group B / E / F
– Winner Group C vs 3rd Group A / B / F

Read more

Page 3 of 5912345...102030...Last »