Technology, life, programming, travel and money.

Posts Tagged ‘xls’

Monthly Excel planner

Monthly Excel planner

I’ve previously produced a weekly planner Excel spreadsheet, but recently I’ve needed to use a monthly planner with hourly time slots. It is a simple one page monthly planner. The times from 6am-1am are along the top, and the days of the month from 1-31 are down the side. For the months with 28, 29, or 30 days long you can just cross out or [...]

Three point estimation spreadsheet

Three point estimation spreadsheet

If you are trying to make a three point estimation spreadsheet for Excel but are struggling with the formulas, then this free Excel download that I’ve made may help you. It has fields set up for entering data such as the task name, person responsible, and then the best, worst, and most likely estimates. You can also enter a contingency [...]

2012 One Page Excel Calendar

2012 One Page Excel Calendar

At the time I write this 2010 is nearly over, which means that 2012 is just over a year away. If you are planning far in advance then you might appreciate this free downloadable 2012 one page Excel calendar. If 2012 is too far ahead then I have a 2011 one page excel calendar available for download as well. Just like in previous years this [...]

2011 monthly calendar for Excel

2011 monthly calendar for Excel

Here is a free monthly calendar for 2011. You can download it as a XLS spreadsheet for Excel, Open Office, or whatever spreadsheet application you use. I’ve previously produced a one page calendar for 2011, but I had a request to produce a month by month version, with each month on a separate tab. Here is what September 2011 looks [...]

Present and gift logging spreadsheet

Present and gift logging spreadsheet

Sometime it can be hard to think of what presents to give for birthday, Christmas, Valentines or anniversaries. Having a record of what presents you have given before can help to provide inspiration, and can help you avoid giving the same present twice. I’ve made a simple spreadsheet for logging gifts and presents. I’ve put some example [...]

Managing holiday money with an Excel burn down chart

Managing holiday money with an Excel burn down chart

If you go on a short holiday then it should be pretty easy to manage your holiday money. It isn’t too hard to track how quickly your foreign currency is running out when you are only abroad for a week or two. If you are going on holiday for a number of months then it becomes a bit harder. When I recently went on holiday for three months I [...]

Telephone call log spreadsheet

It can be well worth keeping a log of phone calls to companies such as banks, utility companies and anyone else who you have an account with. You never know when it could be useful to have this information. For example this week I received some unsolicited credit card cheques from Natwest. I have previously been sent these by Natwest and I [...]