Technology, life, programming, travel and money.

Posts Tagged ‘Excel’

2016 and 2017 staff holiday Excel planner and one page Excel calendar

2016 and 2017 staff holiday Excel planner and one page Excel calendar

The requests for the 2016 excel staff holiday planning spreadsheet have been coming in so I have made it as well 2017 one. Also I’ve uploaded the 2016/2017 one page excel calendars. Staff holiday planner First up here are my free spreadsheet that can help you track staff leave/holiday, training, sick days, offsite days, etc. They come [...]

2014 and 2015 Excel staff holiday planner and one page Excel calendar

2014 and 2015 Excel staff holiday planner and one page Excel calendar

I’ve been getting loads of requests for the 2014 versions of my staff holiday planning spreadsheet, and the one page Excel calendar. I thought it was about time I created them. And for good measure I did the 2015 version as well. Staff holiday planner First up here are my latest free spreadsheet that can help you track staff holidays, [...]

Batch conversion of historical foreign currency values into a native currency

Batch conversion of historical foreign currency values into a native currency

Maybe you are in the situation where you have received payments in a variety of currencies, and now you need to convert the payment values into another currency (perhaps your own native currency). But your task is made more complicated by the fact that you need to use the exchange rate at the date the payment was received, rather than totalling [...]

2013 one page Excel calendar

2013 one page Excel calendar

I’ve started getting requests for a 2013 version of my one page Excel calendar, so here it is! If you want the previous 2012 one page Excel calendar click on the link. As always you get the whole year in a very simple one page Excel spreadsheet. There are two versions. One is plain, the other has the UK bank holidays marked. 2013 one [...]

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 [...]

2013 Staff holiday planner spreadsheet

2013 Staff holiday planner spreadsheet

At the time of writing it nearing the end of 2011 so some of you may be searching for my previous staff holiday planner for 2012. If you are planning very far ahead (or if you are reading this in 2012/2013) you might want my 2013 staff planner. This is my latest free spreadsheet that can help you track staff holidays, training, sick days and [...]

2012 Excel week numbers calendar

2012 Excel week numbers calendar

We are nearly half way through 2011 so you might have already started planning for 2012. This easy to read one page Excel calendar has the whole of 2012 on one page, with a good sized box for each day of the week – each day has five free cells for your use. It has the week numbers down the side – the week numbers are written according to [...]

Amazon CloudFront and S3 maximum cost

Amazon CloudFront and S3 maximum cost

When using utility computing platforms such as Amazon CloudFront, S3, EC2, or similar platforms from other companies, you are charged according to how much usage you or other people make of the files and services you publicly expose. If you configure your files or services to be private only to you then you can easily control the cost. But when [...]

2012 staff holiday planning spreadsheet

2012 staff holiday planning spreadsheet

This staff holiday planning spreadsheet is a 2012 updated version of my 2011 staff holiday planner. This time the formulas for calculating the remaining holiday are in the default sheet - if you don’t need them you can just delete the columns. As before the calendar planner shows the whole year left to right, with employee name down the [...]

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 [...]

 Page 1 of 3  1  2  3 »