Excel Templates | Excel Spreadsheets


Free Excel Templates

Travel Request Form

Posted on July 15, 2009
Filed Under Finance | 3 Comments

Share

In a medium to big scale company, there are Business Travel Standard Operating Procedures (SOP) that need to be followed when you being sent to other cities or other countries to represent your company business. The SOP will start from the justification of business travel, business travel preparation and business travel report.

Usually, finance or GA department will ask you to fill business travel request form as a condition to issue the cash advance or allowance needed for the travel. And in some companies, there are already a rule about cash advance allocation which usually based on employee position.

There are plenty of travel request form available in internet from the complex one with many information needs to be filled until the simple one. And I made a simple travel request form, that can be used as one of your references.

There are two worksheets inside the spreadsheet, as follows :

Request Form Worksheet
This is a form that you can fill with your cash advance request. There is a budget column which linked with the company rules budget that can be used as your request reference. I put Group function on that cell, so you can hide or unhide the column by clicking the “-” (negative sign) or “+” (positive sign). And there are cells with blue colors that contain formula that will automatically calculate the total days of your business travel and the total amount of your request.

Travel Request Form

Company Rules Worksheet
If you have company rules that is used as company business travel reference, you use this worksheet to copy the rules. If you don’t have company rules, you can start by filling the cells with reasonable budget.

Read more

Tags: , , , , ,

Student Attendance Record

Posted on July 15, 2009
Filed Under Education | 3 Comments

Share

These student attendance records is created to help teachers keep track of attendance of their students. There are two models created here, weekly and monthly.

Weekly attendance record is a simple form that can be used for record the attendance of students for five days period. The formula being used here is the basic sum formula that will sum the student attendance based on its category.

Weekly Attendance Record

The monthly attendance record is created with excel formula and conditional formatting which will give you the customize record or report that can be used monthly. Set your targeted month and year, and the date column will adjust automatically to give you the day name of the given date. And there is conditional formatting in the column that will turn the cell color into grey color if the given date is Sunday or holiday. The holiday itself will refer to the date in the holiday worksheet where you can custom it.

Read more

Tags: , , , , , , , , ,

Bundesliga Fixtures 2009/2010

Posted on July 14, 2009
Filed Under Soccer, Sports | 21 Comments

Share

I think I have to explain to all of you that I cannot make the English premiership fixtures 2009/2010 due to license issue. Last year, English FA have warned me not to make and release the premier league fixtures for public unless I paid for the license. All parties that release the fixtures offline and online have to had a license. And it is not cheap. So, I am very sorry that I cannot do that eventhough I really want to make it. And please don’t be disappointed, because it is their rule and we have to respect it.

And, there are still other European league that so far I haven’t found any license issues with their fixtures, and Bundesliga is one of them. So, following La Liga and Ligue 1, this template is the third one that is already filled with fixtures by this date. The different between Bundesliga and the other two is on the number of teams that get involved in competition where Bundesliga only consist of 18 teams. And due to the new layouts, I have to do some slight modification to make it work with 18 teams.

Bundesliga Fixtures

In this template, there are League Table, Fixtures and Results, Team Fixtures and Results, and Team Setup worksheets as seen in the pictures which already filled with dummy results. I think I don’t have to explain the function of all of these worksheets, because it is the same. You can go to La Liga and Ligue 1 Fixtures post about the detail explanation of each worksheets.

Read more

Tags: , , , , , , , , , , ,

Page 29 of 42« First...1020...2728293031...40...Last »