MS Project 2010 – Project Windows off screen, can’t restore or view – data is missing!

25th October, 2012 – 9:44 am

I’ve had an issue with MS Project where I mimimise the window within project of my active project and then no matter what I do with views or zoom I can’t seem to restore it.

Not found the root of the problem but you can restore your precious project plan via VBA.

EDIT – the code had some none ascii chars and I’ve updated the title to cover more issues I’ve solved with the code in solution 2 in the office. It seems to be an issue where you switch from multiple monitors to a single and back (e.g. undocking your laptop – something PMs do multiple times a day!)

Read more…


The Didsbury Dozen 2012 – with a Route Guide Booklet and Map

10th August, 2012 – 10:16 am

After careful debate we’ve decided to stick with the more classic route.  It features a few gastro pubs, a trendy bar and a McSpoons but we like it.

Here is an updated guide:  The Didsbury Dozen August 2012 – if you print it off it folds into a nice four page booklet.

 

The Didsbury Dozen - a full colour route guide with map and directions

The Didsbury Dozen – a full colour route guide with map and directions

We’re starting at 1300hrs in the Woodstock – see you there!

Read more…


PHP date function – output a friendly UK style date with ordinal date suffix and ‘hrs’ suffix on time

14th April, 2012 – 5:53 pm

This post is more to remind me in the future but perhaps someone else will find it useful?

I like the UK date format – I like to fight the Americanism of not using the ordinal suffix and I also like ‘hrs’ on 24-hour clock times.

Sun 18th Mar 19:00hrs

Read more…


Create 100 different images Containing a Number – The Image Equivalent of Lorem Ipsum

15th March, 2012 – 10:53 am

Often I get asked to design things which require displaying of products and I don’t yet have the images.  I’ve written a script to do just that.  If you’re not a PHP coder and don’t want to tweak the code and run it yourself bug  just want a zip with 100 – 600 random images – here it is.

I needed some filler in a test site and found using the same image for all products doesn’t help prove that the solution will work. What I needed was a 100 (or 600!) meaningful(ish) jpgs.

This script produces just that with random background colours and contains a number.

Here is the output – the colours please me greatly.

100 randomly coloured images with a number

Useful for filler for beta sites.

Read more…


Exporting MS Project 2007 Tasks to MS Excel with Indenting

26th January, 2012 – 2:12 pm

Apparently MS Project 2010 fixes this issue but I’ve often wanted to copy the tasks complete with  the indenting to Excel to provide a quick and dirty report for non-project users.

 

When you use copy and paste you loose the formatting – grrr!  Here is a quick and dirty solution.

  1. Insert column into Project (right click on the  grey header bar above your tasks and choose  Insert Column
  2. Select Field Name: Outline Level 
  3. Now select and copy your tasks including this column to Excel.
  4. For my formulas Col A = ID, Col B = Outline Level, Col C = task name, adjust yours accordingly!
  5. Insert in the next free column the following formula =CONCATENATE(REPT(”   “,B1-1),C1)
  6. There you go – quick and dirty as I said!
MS Project Tasks Formatted in Excel

MS Project Tasks Formatted in Excel

 


Moving PHP Solutions from Windows to Linux

17th December, 2011 – 11:16 am

I’m currently building a ticketing / holiday booking application in my spare time in PHP / MySQL.  When I started in PHP I used Linux for my development platform because my laptop ran, the rather terrible, Windows Vista.  I’ve since upgraded to Windows 7 and find myself using this instead of my Linux share now (oh the shame!).

I develop using the excellent WAMP Server  and then copy up to a cheapie Linux host I have.  What could possibly go wrong?!

Well for a start there are obvious configuration difference issues (trying to keep the same versions of PHP and its extensions.  I have the error settings set to be as verbose as possible to try and trap issues in my coding before I set the code lose on the server (these are not exposed on the website so that you don’t expose the error out to web visitors – security risks) but aside from that I’d expect PHP that runs fine and dandy hosted on my Windows dev platform to be the same on the Linux server – BIG ASSUMPTION!

com_create_guid – Creating GUIDS – Works on Windows, Not on Linux

Read more…


VII Worcester Wassail – 10th December 2011

8th December, 2011 – 9:43 pm

Saturday 10th December brings the seventh annual Worcester Wassail.  Twelve pints in the loyal city – we return every year just to completely ruin ourselves.

 

You can download our route guide here.

Worcester_Wassail_Dec_2011

Read more…


Plotting Numbers of Bugs Raised Each Day From a BugTracker in Excel

7th December, 2011 – 4:31 pm

I had a requirement to plot the number of bugs raised on each day on a graph to show how many are raised.   The bugs were stored in the very wonderful BugTracker.NET .  The problem was I had a list of bugs with a date time.

ID

MIN(dateUpdated)

2

11/04/2011 09:10

4

12/04/2011 16:48

14

18/04/2011 21:03

15

20/04/2011 07:14

16

20/04/2011 20:30

17

20/04/2011 20:30

 

Here is how I solved it.

Read more…


The Didsbury Dozen 19th November 2011

18th November, 2011 – 1:08 pm

This is a departure from our standard route – we’re going classic.  With the reopening of Ye Olde Cock it’s *almost* possible to do a proper pub crawl in just East Didsbury again.  This is going to be controversial as a lot of people love The Metropolitan (not me!).

As we’re going back to basics I thought it would be nice to have a classic route guide too – so I found the oldest one I could and have kept the text largely the same.

The Didsbury Dozen Nov 2011 Route Guide

We’re starting at 1300hrs in the Woodstock – see you there!

The route is:

  1. The Woodstock (Barlow Moor Road)
  2. The Nelson (Barlow Moor Road) 
  3. The (Famous) Crown (Wilmslow Road)
  4. The Didsbury (Wilmslow Road)
  5. Ye Olde Cock Inn (Wilmslow Road)
  6. The Royal Oak (Wilmslow Road)
  7. Fletcher Moss (aka The Albert) (William Street) 
  8. The (John) Milson Rhodes (School Lane) 
  9. The Dog & Partridge (Wilmslow Road)
  10. The Slug & Lettuce (Wilmslow Road) 
  11. The Station (Wilmslow Road)
  12. O’Neills (Wilmslow Road) 

 


A Really Pleasant Day on the East Lancs Railway – Steam Rail Pub Crawl!

19th September, 2011 – 12:30 pm

If you’ve seen any other page on this site you’ll be aware I like nothing better that a pubcrawl.  The never-grown-up-kid in me quite likes trains too.  Add the two together and you have a Rail Ale Trail!

Now – throw in a steam train and you have something really special!  So here is my (unofficial) version of the ELR Rail Ale Trail.  The ELR folk do actually run guided tours – this route is based around their leaflet with some tweaks with a number of stops on the Metro with some varying degrees of pub quality!   We took the trip on a blue weekend – if you want to follow my timings ensure you check on their very well designed calendar – if you’re doing this in the summer there are more services so it might not have to be such an early start!!!

Read more…