Time dependent “out of office” email replies
How can Outlook be made to send “out of office” replies after a certain time each day?
April fools’ day tips for the public sector
This post was originally written for Comms2Point0 and was published on https://comms2point0.co.uk/comms2point0/2022/3/30/april-fools-day-for-the-public-sector. A massive thank you to Darren Caveney for publishing it.I have reproduced it here with the tweets embedded as part of my own personal archive of my work. I am a big fan of social media pranks – especially on April Fools’ Day. …
Recreating Kinetic Typography… using PowerPoint??!!
A friend of mine works in the NHS. She is an awesome writer, but worries as she struggles to produce video content for her social media channels. When I sent her this fantastic piece of award-winning kinetic typography written by Thread And Fable, and designed by Lynn PR, she loved it – and responded: Jeeez, …
Recreating Kinetic Typography… using PowerPoint??!! Read More »
Index/Match postcodes to find local authorities
Andrew… I’ve got a list of postcodes… Is there a way to use Excel to find out which local authority they are all in…? Yes… but first a few caveats! (or just skip to the code) Excel is a “quick and dirty” solution – If you are doing this properly you’d use GIS, but Excel …
Twitter export cleaning and data conversion
This is another note to self, on how to clean performance data extracted from Twitter Analytics. Tweet ID Due to the length of Twitter ID’s Excel turns the ID into scientific notation and so the ID is not exactly right.Luckily, that can be extracted from the Permanent Link using the following excel formula: Twitter account …
Facebook data export date conversion
One of the things that I have to do regularly is export data from Facebook pages of Facebook posts. I import the data to Excel to clean it and analyse it. One of the frustrations with this is that some of the dates in the data source get formatted as US dates, and some of …
How many palindromic postcodes are there?
The map goddess @AngharadStone posed an interesting poser on Twitter last night. @AngharadStone Good question. Do you mean the full postcode or just the first part? B, BB, DD, E, G, LL, M, N, NN, S, SS, W. — BX Postcode Area (@BXpostcodearea) December 31, 2016 It seemed like an interesting problem, so I thought …
What proportion of local people follow police accounts on Facebook?
This tweet caught my eye earlier this month: @AccLeicsPolice @nickkeane @TrueBlueLine Better version with Scotland. CoLP is at over 800… pic.twitter.com/aK8FcVDDQJ — Alex Ray (@AlexJTRay) December 3, 2016 For each of the police forces in the UK (ex BTP, Civil Nuclear Constabulary and City of London*) Alex has worked out the proportion of people served …
What proportion of local people follow police accounts on Facebook? Read More »
Diversity in police emoji….
Unicode (the standards body that decides what emoji are available) have released guidelines to address the lack of diversity in emoji. The ethnicity guidelines were released last year (and at the end of August the last major vendor – Google – implemented them). The gender guidelines are not yet ratified, but vendors are already starting …
Twitter and Facebook could be just about to change crime reporting forever…
In the last week Twitter has quietly announced a little change that could should have an enormous impact on how the public contacts public sector organisations in the future. The rumours are that Facebook is heading in the same direction.