Excel Templates

Mortgage Payment Calculator

Posted on September 13, 2009
Filed Under Finance | 2 Comments

This is just a simple mortgage payment calculator that will help you calculate your monthly payment quickly. This spreadsheet is a continuation of several financial calculator spreadsheets that I created in relation with teaching my nephew learning some built-in excel financial function and use it for her school purposes.

There are many mortgage payment tools available in internet, either online or created in excel spreadsheet provided by bank, financial institution or unrelated parties…. like me .

Tags: monthly mortgage payment, Mortgage, mortgage payment table

Chinese Gender Chart

Posted on September 13, 2009
Filed Under Calendar | 3 Comments

Based on ancient stories, Chinese gender chart was found in a royal tomb over 700 years before present. The royal tomb is near Beijing, China. Now, the chart is kept in the Institute of Science in Beijing. And stories said that this chart is created as Chinese ancient statistic results of birth gender. And after that, it is used to plan and predict gender of Chinese children.

How accurate is the chart ? Nobody can guarantee the accuracy of this chart. So, use it as a side reference or just a statistic chart to check whether your children now is the same with what the chart say. Don’t use it as a real reference. Always trust your doctor for your real reference.

Tags: chinese birth gender, chinese conception calendar, chinese conception chart, chinese gender calculator, chinese gender calendar, chinese gender prediction

Restaurant Reservations

Posted on September 12, 2009
Filed Under Calendar | 7 Comments

Following my reservation spreadsheets on hotel, car, and banquet hall which based on day reservations, this reservation spreadsheet is based on hour reservation. The basic reservation scheme is the same, but I put tables number, smoking and non-smoking preferences, and table capacities as parameters in this spreadsheet. But, the formula will work only on the table number.

This spreadsheet consists of two worksheets. To customize this spreadsheet, go into availability worksheet and put your tables information in table type, capacity, and table number columns. And you can custom the display of reservation time here, by change the time step value (in minutes). After you finished entering all information, you can go to restaurant reservation worksheet to start your reservation log. You can custom the column in this worksheet except the table number because this is the reference of the formula. Once you fill the reservation or you want to see the reservation information, go back to the availability worksheet and slide the date to the date of reservation.

Tags: cafe, cafe reservation, free reservation spreadsheet, hourly reservation, printable reservation, reservations, restaurant