Software & IT consultancy · London EC2Write to us
Data ConsultancyConsidered software · clear advice

Overview › Instruments

Three instruments for the thoughtful.

Each runs in your browser and sends nothing to us. Accept optional storage in cookie settings if you would like your answers remembered on this device.

Instrument I Illustrative

Spreadsheet pressure check

Eight questions about a spreadsheet your organisation depends on. The index estimates how strongly it is pushing towards a proper system. You only answer about the file; you never upload it.

Do several people edit the same file at the same time?
Does only one person fully understand how it works?
Is data copied by hand between files or systems each week?
Have errors in it caused real cost or embarrassment?
Would you need to know who changed a value, and when?
Is the underlying process still changing month to month?
Does it hold personal information about customers or staff?
Are the same reports rebuilt by hand every period?

Instrument II Illustrative

Build, buy or configure

Six sliders describing your situation. The weighing shows which route your answers favour. It is a structured prompt for discussion, not a recommendation about any particular product.

Instrument III Illustrative

Column header audit

Paste only the first row of a spreadsheet or CSV export: the column names, not the data. The audit flags duplicates, ambiguous labels, awkward symbols and year-in-the-name patterns, and suggests consistent machine-friendly names.

Reading the pressure index

A high index does not mean the spreadsheet is bad; it means its job has grown. Sometimes the answer is a shared database behind the same familiar sheet.

Reading the weighing

Close results are common and honest. The tie-breaker is usually total cost of ownership, including the people needed to run it.

Reading the audit

Consistent names are the cheapest data quality improvement available. Agree them once, record them in a data dictionary, and use them everywhere.