Author Archives: Philipp

Weekly Diary

This template is dedicated to Natasha. She sent me an e-mail and was looking for a diary with excel or excel-template. I made a research and found out, that many people are seeking for a spreadsheet with an overview of the week and a small place for notes.

So here we go – this is a very simple excel-template with a weekly diary. Just fill it out in excel or print it and do it manually.

Continue reading

Budget-Planner for College Students

College has almost started and so I had the idea to make a budget-planner for college-students with an excel-template.

My own studies are long ago and everything seems to be more expensive now. No good news for parents who want to support their children with payments for the college. But how much does it really cost? What expenses are there? Continue reading

Mortgage Excel-Template

This excel-template calculates your mortgage. Just fill out the left side on top of table and the rest will calculated automatically.

For everyone planning to buy a house or flat, this is a really important calculation. Don’t be to optimistic with your financial income. What if you lose your job, what if you have to sell the house because you have to move to another place because of your work? To do you have some extra-money for some unexpected repairs? Don’t forget, that you might need some money for an illness or operation. What about making holidays or paying the college for the children.

There are many aspects that should be respected – but to be honest – an own house is fantastic 🙂

So here is the Excel-Template for the mortgage-calculation: Continue reading

Simple Budget Template Household

To have an overview of your finances you need to have a budget-planner for your household. Only this way you can discover where you really spent your money. Sure, you can use a normal pocketbook, but calculate per hand is not as comfortable as an excelsheet. In this excel-template everything calculates automatically. Just fill out the first sheet with your income-data and fixed expenses. Then switch to the month we have and put in the expenses you have.

That’s all..

Overview of the budget-template in excel

Overview of the budget-template in excel

The details of each month of the budget-planner

The details of each month of the budget-planner

Download the Budget-Template for Excel here

[give_form id=”853″]

By the way – if you want to have a more detailed version of the household-planner, look here. I’ve already made one.

Weekly rota with excel

You need a little calendar with an overview of your weekly activities? Here we go: I made an excel-template with a weekly rota. You can write down your goals or todos, appointments and so on.

Just click on the download-link below and you get it for free! Chose between an excel-file, an excel-template-file or a pdf. User with Internet-Explorer please take the zip-file as other files seems to make problems..

Continue reading

Diet Plan as Excel Template

Do you want to lose weight or just maintain records of what you have eaten per week or you are planning to eat? Then this diet plan Excel template is just right for you. Either print the Excel template and write by hand all the foods or do it directly in Excel. Keep track of your eating habits and do not forget to enter everything 🙂

Have a look at the screenshot of the diet plan excel template

Diet plan Excel template


Diet plan Excel template

Download the diet plan template for free





Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

More diet plan templates in the network

A little research showed that there are other good diet plan templates to download:

Software List as Excel Template

This time I offer you one more list as Excel template. This template will help you catalogue your software, keep track of your software licenses, registration numbers, user names, passwords and Internet addresses. However, the user name is not always important for the software catalog; Adobe software is directly connected to a user name or e-mail address. Other software online services, such as Dropbox, work by sending an e-mail and password combination.

As usual, you can download this Excel template free of charge.

Have a look at the screenshot of the software list excel template

Your software list Excel template


Your software list Excel template

Download the software list template for free





Here you may find this template in different file formats (.xls, .xlsx, .xltx, .pdf and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a .pdf or zip file.

[give_form id=”853″]

More software list templates in the network

A little research showed that there are other good software list templates to download:

Phone List as Excel Template

When I researched what people search for on my website, I got aware that they need a phone list.  I have decided to complete it quite fast in order to make it available in the shortest time possible. It is very simple, but you have all necessary fields and columns in a common form of the Excel template 🙂

As usual, the template is free.

Have a look at the screenshot of the phone list excel template

Phone list Excel template


Phone list Excel template

Download the phone list template for free





Here you may find this template in different file formats (.xls, .xlsx, .xltx, .pdf and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a .pdf or zip file.

[give_form id=”853″]

More phone list templates in the network

A little research showed that there are other good phone list templates to download:

To-Do List Excel Template

A to-do list is definitely essential for everyday office use. How could I forget to create such a necessary template! The research results on my website show that people search for “to-do”, “to-do list”. Well, it’s time I created a to-do list Excel template!

Have a look at the screenshot of the to-do list excel template

To-do list Excel template


To-do list Excel template

Download the to-do list template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More to-do list templates in the network

A little research showed that there are other good to-do list templates to download:

Yahtzee Excel Template

Why should we almost always use Excel for boring things like invoices, expense reports or plans? Why should we not try to entertain ourselves with such games as Yahtzee, for example? That’s what I was thinking about when I watched my some people close to me playing the dice game Yahtzee on the lakeshore.

Today there is an Excel template for Yahtzee!

In addition, I’ll explain the rules, the probabilities of individual throwing combinations and refer you to sources where you can play Yahtzee online in the browser for free 🙂

But first preview the Excel template.

Update: Thanks to Laura there is a new Yahtzee-template with automatic calculation! Have a look here.

Have a look at the screenshot of the Yahtzee excel template

Excel template for Yahtzee


Excel template for Yahtzee

Download the Yahtzee template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, .pdf and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a .pdf or zip file.

New Excel-template with automatic calculation:

New Yahtzee-template

[give_form id=”853″]

Let me explain you the rules:

The aim of the game is to dice as many points as possible. You may roll with 5 dice. Each player has three attempts to reach his respective target. After the first roll the player may put aside those dice which he needs for the combination and continue playing with the remaining ones. After every roll the player may change the planned combination.

Example:

  1. The player rolls: 1 6 3 5 6.
  2. He puts two sixes aside and rolls the remaining three dice further.
  3. In the second roll the player gets: 1 3 6.
  4. He puts the six aside and now has 3 sixes collected.
  5. In the third attempt he rolls 2 and 5.
  6. Now he can enter 18 in the upper section in the “Sixes” row (3 x 6 = 18) or 25 in the “Three-of-a-Kind” area in the lower section (3 x 6 + 2 + 5).

In the upper section you should note that there is a bonus when you have collected a total of 63 or more points. The 63 is selected on the following basis: when you have collected 3 numbers in each row, the final total will be 63. (3*1) + (3*2) + (3*3) + (3*4) + (3*5) + (3*6) = 63. So, beware when you reach a lower total with one number, you have to create 4 of the same value with another higher number again in order to get the bonus.

Three-of-a-Kind

Three dice of the same value should be rolled. As a result, all scores will be noted.

Four-of-a-Kind

Four dice of the same value should be rolled. As a result, all scores will be noted.

Full House

3 and 2 dice of the same value should be rolled. There are 25 points for it.

Small Straight

4 dice with consecutive numbers should be rolled (1, 2, 3, 4 or 2, 3, 4, 5 or 3, 4, 5, 6). There are 30 points for it.

Large Straight

5 dice with consecutive numbers should be rolled (1, 2, 3, 4, 5 or 2, 3, 4, 5, 6). There are 40 points for it.

Yahtzee

5 dice of the same value should be rolled. There are 50 points for it.

If you have rolled a second Yahtzee, you get 50 extra points, and you can use a joker in the lower section. Joker: If, for example, you do not have full house, you can record 25 points.

 

You may use other sources for playing Yahtzee online:

It’s a free source for playing Yahtzee online just in your browser:

http://www.yahtzee-game.com/

or take your chance here, also with explanation of rules and absolutely free:

http://www.yahtzeeonline.org/

Here you may read about Yahtzee variations:

http://www.wikihow.com/Play-Yahtzee

Free Attendance Record Excel Template

For the control of attendance I have created an Excel template which can help you check and note the attendance record per peg or initials. In the template for 2013 there are 12 spreadsheets with the respective months from January to December 2013 and the corresponding weekdays. For more details, please, refer to the screenshot.

Update: There is a new attendance-record-template online for 2015

Have a look at the screenshot of the attendance record excel template

Attendance record as Excel template


Attendance record as Excel template

Download the attendance record template for free


Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

Update: attendance record Excel template for 2014

Attendance record as Excel template for 2014


Attendance record as Excel template for 2014

Download the attendance record 2014 template for free

Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

New attendance record for 2015

Attendance-Record for 2015

Attendance-Record for 2015

Download the excel-files here

Attendance Record Excel Template for Students

According to my research, I have found out that there is a need for attendance record Excel templates. They can help you register the presence of students. Therefore, I have designed Excel templates for this purpose.

Have a look at the screenshot of the attendance record excel template

Attendance record Excel template for students


Attendance record Excel template for students

Download the attendance record template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More attendance record templates in the network

A little research showed that there are other good attendance record templates to download:

Excel Template for Interest Calculator

This calculator will help enter your savings rate, the savings period and the interest rate, and Excel will calculate your net savings after the saving period. Increase your interest rate, and you will immediately see how much faster you could reach the result of being a millionaire.

Now we just need a secure system that really creates a high interest rate 🙂

Have a look at the screenshot of the interest calculator excel template

Excel template for the calculation of interest and compound interest


Excel template for the calculation of interest and compound interest

Download the interest calculator template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More interest calculator templates in the network

A little research showed that there are other good interest calculator templates to download:

Excel Template for Invoice

So, I have also made an Excel template for invoice creation. The summation and percentage calculation are automatic. The tax can be  at 0%, 5% or 20% and can be changed to any value you like. Just switch to spreadshett “VAT setting” and change 0, 5 or 20 to another number.

Have a look at the screenshot of the invoice excel template

invoice excel-template for free

invoice excel-template for free

Change the tax in vat-spreadsheet

Change the tax in vat-spreadsheet

Download the invoice template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More invoice templates in the network

A little research showed that there are other good invoice templates to download:

Free Cashbook as Excel Template

This cashbook has similar functions to the already published household account book, but it is developed for entrepreneurs and/or companies in which cashbook management is a necessary procedure. This is the point why I have created this Excel template. The cashbook is free and can be downloaded in the section “Download”. It sums expenditures and income, determines current cash balance and even takes into account opening cash balance.

Inspired by a comment, I have created the second cashbook template. This takes into account VAT rates of 7%, 19% or 0%. You can find it at the end of the article.

Have a look at the screenshot of the cashbook excel template

Cashbook Excel template


Cashbook Excel template

Download the cashbook template for free


Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

Cashbook with VAT Excel Template

As it is mentioned above, here is an Excel template of a cashbook with VAT. As I needed more columns in this template, I have created it in a landscape mode.

VAT-cashbook Excel template


VAT-cashbook Excel template

Download the cashbook with VAT template for free

Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

Update: Tax Law

In accordance with the new legislation, cashbook management in Excel is not authorized or is not recognized as such. The cashbook does not meet the “principles of proper accounting” and the company cannot be estimated on that account. The following also concerns associations, small businesses and freelancers.

Those who manage this book in Excel should print it and enter all the numbers by hand. Since then there should be nothing to complain about.

 

Project Management with Excel Templates

Those who do not want to deal with an extensive Microsoft project may make the first steps that are important for project management and project planning using these Excel templates. You may divide the project into subtasks and provide it with the date and time. The whole timeline is then plotted on colored background cells of the Excel template. In this template it is offered as an example. In the template there are two spreadsheets for the months of January to June and July to December 2013.

Continue reading

Exact Daily Interest Calculator as an Excel Template

A few days ago I was asked by some reader to create an Excel template for the calculation of daily interest. I think that the following can make other interested, that’s why I have programmed an interest calculator as a template. Everything is very simple: if you enter principal, interest rate, beginning and end dates, interest and interest days are issued automatically.

Continue reading

Inventory List as Excel Template

For any company it is essential to hold the inventory in an inventory or stock list. For this purpose I have created an inventory list as an Excel template. All values are automatically calculated. You can create a new row with a Tab key when you select J9 cell and then use the Tab key.

The Tab key is located here:

Add a row in the Excel template with the Tab key

Add a row in the Excel template with the Tab key

The whole picture looks like this in live:

YouTube

By loading the video, you agree to YouTube's privacy policy.
Learn more

Load video

Have a look at the screenshot of the inventory list excel template

Inventory list Excel template


Inventory list Excel template

Download the inventory list template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More inventory list templates in the network

A little research showed that there are other good inventory list templates to download:

Duty Roster as Excel Template

Today I have released a duty roster, staff deployment plan or plan of work, depending on the way you want to call it 🙂

The duty roster is divided into 7 spreadsheets – one for each day of the week. There you will find three shifts into which you can enter an employee. As always, this Excel template is free and can be downloaded in different Excel file formats. But first, please, preview.

Continue reading

Blood Pressure Chart as an Excel Template

Today I have dedicated myself to a medical topic. I mean, to Excel templates for recording blood pressure and hearts including the calculation of corresponding mean values. An annual overview and automatic diagram creation complete the Excel template.

Have a look at the screenshots of the blood pressure chart as an excel template

Blood pressure chart as an Excel template, overview

Blood pressure chart as an Excel template, overview

Blood pressure chart as an Excel template, detailed view

Blood pressure chart as an Excel template, detailed view

Download the blood pressure chart template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More blood pressure chart templates in the network

A little research showed that there are other blood pressure chart templates to download:

Although they are not so well-designed as mine, but maybe they have more features than mine 🙂

Receipt Excel Template

In most cases a receipt is not required as most shops are equipped with an electronic checkout. However, at trade shows, flea markets, etc. a receipt may be helpful. If there is no receipt book, this Excel template can serve by quickly providing you with a receipt.

In the upper part there is your company’s name and data; in the other fields you may enter the amount and the recipient’s name. The rest (date, value added tax, amount) can be automatically filled in the Excel receipt. The copy will automatically get all the values from the original. Then just print and sign it 🙂

Have a look at the screenshot of the receipt excel template

Receipt Excel template


Receipt Excel template

Download the receipt template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More receipt templates in the network

A little research showed that there are other good receipt templates to download:

Household Budget Planner as Excel Template

Although I have already created an Excel template for a household book, but a template for a household budget planner in Excel was missing. I have recently designed this template as an Excel template, and I hope that I have not forgotten any necessary criteria. The template is divided into main sections such as auto, home and life. These sections can be filled in each month. The Excel template simply calculates the sum of all costs and subtracts them from the revenues. At the end you will get an idea of whether you are still within your budget or not.

Have a look at the screenshot of the household budget planner as excel template

“Household budget planner” Excel template


“Household budget planner” Excel template

Download the household budget planner template for free




Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

[give_form id=”853″]

More household budget planner templates in the network

A little research showed that there are other good household budget planner templates to download: