2010 Calendar
Posted on October 27, 2009
Filed Under Calendar | 9 Comments
Year 2010 is about to come. An excel calendar 2009 that I created last year is the first calendar I made. There are many types I made for 2009 calendars, like monthly, three monthly, six monthly where you can customize those calendars with your events and holidays.
This calendar is the first 2010 excel calendar type I release. This is a one page, 12 month calendar where you can colorize the date based on your reminders, events and holidays. There is two worksheets in this calendar. The first worksheet is reminder-event-holiday worksheet where you can put your reminders, events and holidays in corresponding columns. If you put the same dates for those three, the first priority will go to reminder, then event and the last priority is holiday. The color of the dates will be the same with the corresponding column colors.
Calorie Counter
Posted on October 27, 2009
Filed Under Health | 3 Comments
This calorie counter spreadsheet is a tool that you can use to count your daily calorie intake. By selecting food or drink item in the list, you can see how many calories you will absorb if you eat or drink those item.
Guidance to use this spreadsheet is simple. Just select your food or drink item, input their estimated weight in oz, and the excel formula will show you the estimated calories for those item. The food and drink database are collected from many sources in internet where I cannot guarantee whether the calorie value per oz is really measured. So, don’t use it as a real reference.
Household Expenses
Posted on October 27, 2009
Filed Under Finance | 3 Comments
This is basically just a strip version of my household budget spreadsheet where it is only can be used to track and record your expenses without budget consideration. It consist of three worksheets, category worksheet, daily income and expenses worksheet and monthly expenses worksheet.
You can start to customize your spreadsheet by going to category worksheet and define your categories. Define your group category first, followed by subcategory and category. You can simplify the written category if you fill those categories are too detail, or you can customize based on your criteria. You don’t have to create all the categories in the beginning, since probably you can’t remember all. You can customize again while you recording your expenses and find there is no suitable category for that expenses.
Read more
