Posts Tagged ‘free’

2018 and 2019 staff holiday Excel planner and one page Excel calendar

Tuesday, January 17th, 2017

It is only January 2017, but I’ve already had my first request for a 2018 staff holiday calendars (I know some people have holiday years that overlap calendar years). So here are the staff holiday planning spreadsheets for both 2018 and 2019. Also I’ve uploaded the 2018/2019 one page excel calendars.

Staff holiday planner

First up are my free spreadsheet that can help you track staff leave/holiday, training, sick days, maternity/paternity, offsite days, etc.

2018 2019 staff holiday planner

They come set up with formulas that can automatically track the total number of holiday days remaining (columns C&D) for each employee. If you don’t want to use this simply delete those columns.

The default formula subtracts 1 or 0.5 from the remaining holiday if the employee cells contain the words ‘holiday’ or ‘half. You can copy and paste (ctrl-c, ctrl-v) the coloured tags (holiday, half, training, etc) from the top left into the staff planning cells and the totals are automatically updated.

Note that the formulas measure the tags from the very start column (which is the year before) to the very end column (which is the year after). If you want it to be fixed to the calendar year then you’ll have to tweak the formulas.

See the old 2012 planner for some customisation examples.

The week numbers are based on ISO 8601, and the top and left parts of the staff planner are frozen so you can always see them – this makes navigation easy. You can download them from here:

Download 2018 staff holiday planner spreadsheet – 12kb
Download 2019 staff holiday planner spreadsheet – 12kb

You’ll need to use a relatively modern spreadsheet package such as Excel 2007 or LibreOffice (which is free) to view the whole calendar. This is because the staff holiday planner has over 365 columns and some old spreadsheet package such as Excel 97 don’t support that many columns. One workaround if you are forced to use Excel 97 at work is for you to use LibreOffice at home to split the spreadsheet into 2, one part for H1, and one for H2.

One page Excel calendar

In these Excel spreadsheets you’ll get the whole year on a single page. You should be able to print it onto a single sheet of A4 paper if you wanted to.

2018 2019 one page excel calendar

You can load the XLS using any version of Microsoft Excel from 97 onwards, or using the free OpenOffice or LibreOffice.

2018 one page Excel calendar – 4kb
2019 one page Excel calendar – 4kb

The one page Excel spreadsheet calendars and the staff holiday planners are zipped up. If your OS won’t automatically open the zip files you can download the free 7-Zip to unzip them for you.

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

Monday, December 2nd, 2013

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, training, sick days and offsite days.

2014 excel staff holiday planner

They come configured with formulas that can automatically track the total number of holiday days remaining (columns C&D) for each employee. If you don’t want to use this simply delete those columns.

The default formula subtracts 1 or 0.5 from the remaining holiday if the employee cells contain the words ‘holiday’ or ‘half. You can copy and paste (ctrl-c, ctrl-v) the coloured tags (holiday, half, training, etc) from the top left into the staff planning cells and the totals are automatically updated.
It is easy to customise the formulas if you want to factor in sick days for example. See the 2012 planner for more example formulas. Note that the 2014/2015 calendar formulas count the entire row (which includes the last bit of the year before and the first bit of the year after), whereas the 2012 calendar formulas just count the 2012 year. You can adjust the formulas to suit your requirements.

As always the week numbers are based on ISO 8601, and the top and left parts of the staff planner are frozen so you can always see them – this makes navigation easy. Here is the download link:

Download 2014 staff holiday planner spreadsheet – 21kb
Download 2015 staff holiday planner spreadsheet – 21kb

As the staff holiday planner has over 365 columns you won’t see the whole year if you open it with an old spreadsheet package such as Excel 97. You’ll need to use a more modern spreadsheet package such as Excel 2007 or OpenOffice (which is free). One workaround if you are forced to use Excel 97 at work is for you to use OpenOffice at home to split the spreadsheet into 2, one part for H1, and one for H2.

One page Excel calendar

As always you get the whole year in a very simple one page Excel spreadsheet.

2014 one page excel calendar
You should be able to load the XLS using any version of Microsoft Excel from 97 onwards, or using the free OpenOffice or LibreOffice.

2014 one page Excel calendar – 13kb
2015 one page Excel calendar – 13kb

The one page Excel spreadsheet calendars and the staff holiday planners are zipped up. If your OS won’t automatically open the zip files you can download the free 7-Zip to unzip them for you.

The 2016 versions of these spreadsheets are here: http://www.reviewmylife.co.uk/blog/2015/08/30/2016-and-2017-staff-holiday-excel-planner-and-one-page-excel-calendar/.

Send a single fax online

Thursday, April 19th, 2012

If you don’t have a fax machine and need to send a single fax you might be looking at online fax services. I was in this position and found that most online fax services are subscription based, aimed at businesses that regularly need to send and receive faxes. I only wanted to send one fax, and didn’t fancy walking to the local copy shop to do it (it probably would have been cheaper, but you have to factor in the time of travelling there as well).

I looked at a few sites but settled on FaxZero.com. They have a free fax service that will insert an advert on the fax cover page, and a paid service with no ads. The faxes are sent at a higher priority with the paid service as well. The paid service is $1.99 per fax, and you can pay using PayPal. There are no additional costs which is good if you just need to send a one-off fax.

faxzero online fax sending

You don’t need to register, you just enter your name, email, receiver’s name, fax number, and then attach an image, .doc or PDF of your fax. I attached a JPEG. I then paid my $1.99 via PayPal.

The confirm page tells you that the fax should be sent in the next 30 minutes. You also get an email with a link to the status page.

About 10 minutes later I got a confirmation email telling me that the fax had been delivered. And more importantly I heard a short time later from the recipient that the fax had been received.

faxzero online fax success

I’ve used the FaxZero service twice, and both times the fax has got through pretty quickly. I do think $1.99 is a bit expensive if you are just sending a single page, but it does work, and you could always try the free fax option if the price bothers you.

2013 one page Excel calendar

Thursday, April 12th, 2012

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.

2013 staff holiday calendar

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 page Excel calendar – blank
2013 one page Excel calendar – with UK bank holidays

You should be able to load the XLS using any version of Microsoft Excel from 97 onwards, or using the free OpenOffice or LibreOffice.

The one page Excel spreadsheet calendars are zipped up. If you OS won’t automatically open the zip files you can download the free 7-Zip to unzip them for you.

Monthly Excel planner

Monday, December 19th, 2011

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 delete the extra days. If you need a different time range it is very easy to edit as well.

monthly excel planner

You can either use this on screen, or print it out. With Microsoft Excel there is an easy option to specify that you want the planner to fit on a single A4 sheet of paper. In the ‘Page Setup’ window set the orientation to Landscape and tell it to fit to 1 page wide by 1 page tall. Here is the free download link:

Download monthly Excel planner – 9kB zipped

I’ve saved this as a Microsoft Excel 97 XLS file so it should work in all old or new version of Microsoft Excel or OpenOffice.

2013 Staff holiday planner spreadsheet

Friday, November 18th, 2011

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 offsite days.

2013 staff holiday planner spreadsheet

It comes configured with formulas that can automatically track the total number of holiday days remaining (columns C&D) for each employee. If you don’t want to use this simply delete those columns.

The default formula subtracts 1 or 0.5 from the remaining holiday if the employee cells contain the words ‘holiday’ or ‘half. You can copy and paste (ctrl-c, ctrl-v) the coloured tags (holiday, half, training, etc) from the top left into the staff planning cells and the totals are automatically updated.

It is easy to customise the formulas if you want to factor in sick days for example. See the 2012 planner for more example formulas. Note that the 2013 calendar formulas count the entire row (which includes the last bit of 2012 and the first bit of 2014), whereas the 2012 calendar formulas just count the 2012 year. You can adjust the formulas to suit your requirements.

As always the week numbers are based on ISO 8601, and the top and left parts of the staff planner are frozen so you can always see them – this makes navigation easy. Here is the download link:

Download 2013 staff holiday planner spreadsheet – 23kb

As the staff holiday planner has over 365 columns you won’t see the whole year if you open it with an ancient spreadsheet package such as Excel 97. You’ll need to use a more modern spreadsheet package such as Excel 2007 or OpenOffice (which is free). One workaround if you are forced to use Excel 97 at work is for you to use OpenOffice at home to split the spreadsheet into 2, one part for 2013 H1, and one for 2013 H2.

Ad Logger ‘click logging’ plugin for WordPress

Tuesday, October 4th, 2011

Ad Logger for WordPress is a new plugin for logging clicks on iframe adverts and other social network buttons. At the moment it can log Google AdSense / Amazon Associates adverts, and Facebook, Twitter and Google +1 social media buttons. It also has a ‘catch-all’ mode which will log any other iframe clicks.

Clicks stats in one place – You can get statistics for all these services individually but Ad Logger allows you to see all the clicks in one place. It will however give you different number; Ad Logger counts raw clicks, whereas your ad/social media provider will count valid clicks.

Raw click logs – With Ad Logger you can see the raw logs which will give you information that your ad/social media provider probably won’t allow you to see such as IP address, page referrer, and browser agent.

Reports – Ad Logger has an AJAX UI to allow you to move through the results easily. As well as seeing the log you can view reports showing the which browser, referrer, page, IP most of your clicks come from. And you can filter the results to show all the logs for a specific IP, page, iframe type, etc by clicking on the type icon, or the ⇓ arrows.

Click bombing protection – As it has access to the raw click logs Ad Logger can help you to combat intentional or accidental AdSense ‘click bombing’ by disabling adverts if too many clicks are registered. It can disable ads that you may have inserted using the Ad Injection plugin, or by dynamically hiding the div that you have put the adverts into.

Ad Logger’s main UI

Here is the main UI, from top to bottom you can see the yellow message bar which I use to highlight the latest updates, then the navigation buttons. To the right of the navigation buttons are the report links.
Next is the main log table – you can see it combines clicks from AdSense, Amazon Associates, Facebook, Twitter and Google +1. You can click on the type icon or the ⇓ arrows to filter your results.
Under the table you can set how many rows are shown at once.
Next are the boxes to select which iframes are logged.
Then the optional click blocking preferences.
Finally you can configure what information is shown in the log table, and what information gets stored to the database.

ad logger main ui

Example Ad Logger report

This is the type report and shows how many clicks occurred on each type of iframe. Here you can see that there were 27 clicks on Facebook like buttons, and 5 on Google +1.

ad logger type report

Filtered report

By clicking on any of the ‘type’ icons you can filter your results to just that type. Here I clicked on the Facebook icon and so am just seeing Facebook button clicks.

ad logger filtered

How does it work?

Ad Logger works by using JavaScript to monitor whether a click has ‘probably’ occurred. I say probably because this method isn’t 100% accurate. It is pretty good though. It notes when the mouse pointer has entered the iframe, and then listens for a ‘blur’ even which corresponds quite well to someone clicking on the ad/social button.

Ad Logger does not modify your original ad code, so hopefully won’t break your ad provider’s TOS. I can’t however guarantee this, so you have to make a judgement call as to whether you think it is safe for you to use.

Results are stored in a new table in your WordPress database. This table can be cleared of data at any time, and it will be automatically deleted if you uninstall the plugin. The plugin limits the size of the table to 100,000 rows (this will be configurable in a later release).

If you have configured click blocking then Ad Logger will use a cookie to count how many clicks have occurred. If the limit is reached then Ad Logger can then set another cookie which will prevent Ad Injection’s ads from being added to new pages, and/or it can remove the div containing the ads from the current page.

How much does it cost?

Nothing! £0, $0! You are however welcome to make a donation via the plugin UI if you find it useful. I have spent several hundred hours of my own time producing this plugin, which I have now released under a GPLv2 licence.

How do I install Ad Logger?

Ad Logger is available for free from the WordPress plugin repository.

The easiest way to install it by searching for ‘Ad Logger’ from the ‘Add New’ link in the ‘Plugins’ section of the WordPress UI.

Future planned features

Future planned features include being able to block adverts by IP address (which will work either standalone with Ad Logger, or in conjunction with Ad Injection), more awareness of other iframe types, and possibly the ability to log non-iframe events. E.g. other advertising/affiliate link clicks.

2012 Excel week numbers calendar

Wednesday, June 15th, 2011

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 ISO 8601. If you work in a company and your projects are planned in terms of week numbers it can be very useful to have a calendar which lists them.

2012 excel week numbers calendar

I’ve frozen the days of the week lables at the top so they are always visible, and the months are alternately coloured to make it easy to see which month you are on.

There are two versions of this spreadsheet, one saved using the newer XLSX format, and one using the older Excel 97 compatible XLS format. Both file types can also be loaded in the free OpenOffice Calc spreadsheet if you don’t have Microsoft Excel.

2012 week numbers calendar (Excel 2007+ or OpenOffice)
2012 week numbers calendar (Excel 97+ or OpenOffice)

I also have a one page calendar for 2012, and a staff holiday planner for 2012 if you are looking for a slightly different calendar.

2012 staff holiday planning spreadsheet

Monday, April 11th, 2011

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.

2012 staff holiday planner xls

As before the calendar planner shows the whole year left to right, with employee name down the side. As there are 365+ columns (for the days) you’ll need a spreadsheet package like Microsoft Office 2007 or OpenOffice to view the whole year. If you try to view it with a very old package like Microsoft Office 97 the year will get truncated after 256 columns.

Week numbers are listed according to ISO 8601. The top and side areas are frozen to make navigation easier, and there are some pre-prepared categories at the top left that you can copy and paste to the relevant cells (Ctrl-c, Ctrl-v are the shortcuts). Filtering for role and staff member name is set up as well.

Download 2012 staff holiday planner – XLS 22kb

The total number of holidays for the staff member can be entered into column C, and then column D automatically shows how many holiday days are left. You can replace the formula in column D if you want behaviour different to the default.

Count full day holidays and half day holidays

This is the default formula for cell D6 which counts whole and half holiday days.

=C6-(COUNTIF(G6:NG6,”=Holiday”)+(COUNTIF(G6:NG6,”=Half”)/2))

Count holidays only

If you want to use this formula paste into cell D6 and then copy down.

=C6-(COUNTIF(G6:NG6,”=Holiday”))

Count holidays plus sick days

=C6-(COUNTIF(G6:NG6,”=Holiday”)+COUNTIF(G6:NG6,”=Sick”))

Count holidays plus sick days (with new ‘Half’ holiday value which subtracts 0.5 days)

=C6-(COUNTIF(G6:NG6,”=Holiday”)+COUNTIF(G6:NG6,”=Sick”)+(COUNTIF(G6:NG6,”=Half”)/2))

OpenOffice Err:508

If you are using OpenOffice then you need to convert the commas in the above formulas to semi-colons. e.g. =C6-(COUNTIF(G6:NG6,”=Holiday”)) would change to =C6-(COUNTIF(G6:NG6;”=Holiday”)). Formulas that are in the default spreadsheet will work, this just applies to newly added formulas.

Three point estimation spreadsheet

Saturday, February 12th, 2011

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.

three point estimation person spreadsheet

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 value as a letter. One of the spreadsheet tabs lets you set what percentage of contingency applies for each letter.

three point estimation contingency

If you like your estimates to be based on the most likely plus the contingency, you’ll see this automatically calculated for you in the first yellow columns (you may have to copy the formulas down as far as you need them).

If you prefer your estimate to be based on E/SD/Confidence values you’ll find them to the right of the sheet. Also available are the average and standard deviation (of the best/worst/most likely). The second yellow column is the 98% confidence plus contingency value.

three point estimation confidence values

Finally if you want to see a quick summary of how much work is allocated to each person there is a tab which gives you this information.

three point estimation person view

This spreadsheet is by no means ready for immediate use, you’ll probably want to customise it, remove the columns that you don’t need, and verify that the formulas do what you want and are correct. But at least it may help you produce the three point estimation spreadsheet you want more quickly.

Download the three point estimation spreadsheet – Excel XLS (16kb zipped)

It has been tested on Microsoft Excel 2007 and is a free 16kb download.