Skip to content

Toolkit: Excel macro - Clean This Chart

01-Dec-07

Over the years, I’ve built up a toolkit of essential software, gadgets and reference material. This “toolkit” series introduces some particular favorites that you, too, might find useful.
Excel macro: Clean This Chart
A macro for Microsoft Excel, available free from Juice Analytics.
The macro creates an extra option in Excel’s “Format” menu.
When activated, the macro converts [...]

For better web sites, support your local web worker

16-Nov-07

M’colleagues Usability Guy and Zeebleblibbet are running an online survey this month. Inspired by the recent A List Apart survey, it’s designed to find out some basic information about who ‘does web’ at this university.
Usability Guy commented on an internal discussion list:
We… spend much money on technology, hardware, processes, buildings etc. but how much time [...]

Web search usage trends

10-Oct-07

Two simple graphs provide useful information for planning of promotional campaigns, system maintenance and hardware upgrades.
Our web search engine is Ultraseek Server 3.1, last upgraded in 2000. Every day, just before midnight, it emails me a text file containing the day’s activity log:

date and time of search
collection searched
number of results
search term

This week, I’ve been collating [...]