Archive for the ‘Reference’ Category

Binary – ASCII conversion

Posted on Wednesday 23rd March 2011 under Reference by

This page has bidirectional binary – ASCII conversion. This is useful if you are following @cjsupercomputer.

Geograph

Posted on Monday 14th September 2009 under Reference by

A project sponsored by the OS to relate photographs to each grid square.
How long before somebody finds a way of exploiting / monetising this?
Geograph.

Windows page file defragmentation

Posted on Monday 4th June 2007 under Reference by

This SysInternals utility allows you to defrag the Windows page file and other files normally locked.

Ray’s A point about chicken feed

Posted on Tuesday 29th May 2007 under Reference by

Alternatives to feeding layers’ pellets.

ZamZar free online file conversion

Posted on Monday 26th March 2007 under Reference by

ZamZar on-line file conversion looks like a handy tool for occasional conversions to other file formats. Their privacy policy claims that they don’t share email details, but I would be cautious about sending client confidential information to their servers for conversion. Links to converted documents are mailed back – and could be intercepted on the way, and there isn’t a secure sockets connection option when uploading.

ESC/POS control for customer display cursor

Posted on Wednesday 14th February 2007 under Reference by

OK, so Epson’s support proved to be useless – “isn’t there a DIP switch on the back” and “we don’t do programming here” seemed to be the best they can offer.

Inspiration led me to lookup the ESC/POS sequences for cursor display – not DC2 & DC4 as previously though, they use the ASCII US (31 decimal) commands:

USC 3167n select/cancel cursor display
n=0,1 (48,49 decimal)

So, back to uedit and try to work out what difference 0, 1, (48 & 49 decimal)  make to the thing…

15/02/2007: answer: None at all!

RSS feed plugin for WordPress

Posted on Monday 15th January 2007 under Reference by

Plug in page.

10 minute SEO check

Posted on Sunday 14th January 2007 under Reference by

Must spend some more time following this up:

http://www.sarahfreelance.co.uk/2006/02/28/10-minute-seo-check/

UTW performance fix

Posted on Sunday 14th January 2007 under Reference by

Aparently UTW suffers from an expensive query – this site has a fix:

http://ocaoimh.ie/2006/09/27/simple-utw-performance-boost/

Excel code snippets for file, path and tab names in cells

Posted on Thursday 11th January 2007 under Reference by

From xlDynamic.com

File path, file and worksheet name:

=CELL("filename",A1)

File path only:

=LEFT(CELL("filename",A1),FIND("[",CELL("filename",A1),1)-1)

File name only:

=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,

FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

The sheet name:

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Restriction: this technique only works for workbooks that have been saved at least once.