Excel Templates | Excel Spreadsheets


Free Excel Templates

Shift Schedules

Posted on July 18, 2009
Filed Under Other | 2 Comments

Share

Based on the definition in wiki, shift work is an employment practice designed to make use of the 24 hours of the clock, rather than a standard working day. The term shift work includes both long-term night shifts and work schedules in which employees change or rotate shifts.

The common shift pattern are “the three shift system” where a day may be divided into three shifts, each of eight hours, and each employee works just one of those shifts; they might for example be 00:00 to 08:00, 08:00 to 16:00, 16:00 to 24:00. Generally, “first shift” refers to the day shift, with “second shift” running from late afternoon to midnight or so, and “third shift” being the night shift. On occasion, more complex schedules are used, sometimes involving employees changing shifts, in order to operate during weekends as well, in which case there will be four or more sets of employees. And there are some of websites provide a nice tool to help you managing your shift work schedules. And there are some simple excel spreadsheets also available that can be used to manage your shift.

Shift Work Schedules

The shift schedules I made is a weekly shift schedule for one week period and based on the condition that in one day period, a company might need two kind of shift patterns, usually it is applicable to retail stores, where one shift pattern is created for that retail store employee that have direct relation with customers, and the other shift pattern is applicable to its security people. And there are working hour calculator next to the name of shift worker to help you monitor the working hour of the worker whether it meets your company regulation or not.

Read more

Tags: , , , , , , , ,

Travel Expenses Report

Posted on July 18, 2009
Filed Under Finance | 4 Comments

Share

Following my travel request form for requesting advance needed for business travel, this excel spreadsheet is the complement of that request form where you can put your daily expenses here and the formula in report worksheet will automate the sum calculation for you. If you want a more detailed daily expenses spreadsheet you can see my travel expenses daily tracker that I used for my business travel daily log.

Travel Report

Since this is just a simple spreadsheet where there is no complex formula inside, I think you can use it easily. Just type in your daily expenses summary in the daily expenses summary worksheet and you will get the total summary in expenses report worksheet. Complete the report worksheet with your identity, departure and return date, description, advance taken (based on travel request form) and number of units.

Read more

Tags: , , , ,

Monthly Planner

Posted on July 17, 2009
Filed Under Calendar | 18 Comments

Share

This monthly planner is created with different approach compare to weekly planner and daily planner template I have posted earlier. It is created based on the monthly event calendar with additional column for time so it can be used as a planner instead of just calendar.

You can make this planner as a printable blank planner or you can add to-do list in this planner for one month period. There are maximum 3 to-do list that can be inserted in the planner due to layout consideration. I will make the planner with more than 3 to-do list later, because I don’t want to change the original monthly calendar that I used as its basic template too much, because to accommodate more than 3 to-do list I have to change the structure of the column and formula. You can put also hour information in the to-do list column as seen in picture.

Monthly Planner

And there is a holiday and an event column that will shown up in the planner. Since I only spare one cell to be filled next to the date inside the planner, there is only one event or one holiday can be shown up. If both event and holiday share the same date, the cell will show the event information because I put priority of event is higher than holiday.

Read more

Tags: , , , , ,

Page 27 of 42« First...1020...2526272829...40...Last »