HXL use cases

HXL is not a specific application or database, but a way to help spreadsheets make sense to any software. With machine-readable tags, people can use software to merge and compare data, to visualise, to analyse, to summarise, to find errors, to spot trends, and many other uses that we haven’t imagined yet. The page presents a few hypothetical high-level use cases, but it is not meant to be exhaustive.

Use case: Building a common operating picture

Goal
An information-management specialist in an OCHA country office needs to create a spreadsheet every week listing all of the relief activities in a crisis response (a “3W” — Who-What-Where — report).
Problem
Different clusters, and organisations operating outside the cluster system, all provide their 3W information in slightly different formats. Merging them into a single report is a time-consuming and error-prone manual process.
HXL’s role
If all of the spreadsheets contain HXL hashtags, the IM specialist can use a simple software tool to merge the spreadsheets into one master 3W report, even if the spreadsheets use different column headers (e.g. “ADM3” vs “County”) in different orders. The software tool can also flag potential errors for review, e.g. if a column that should contain a number actually contains text.

Use case: Inter-cluster coordination

Goal
The WASH, Education, CCCM, and Protection clusters in a country want to share information monthly to help plan for the needs of children who have been displaced from their homes.
Problem
Each cluster already has part of the information required, but all use different formats and different sets of data. Putting the data into a format that each-other can use becomes a new task (and a new reporting channel) for each cluster, without adding any other value to what they were already doing (such as collecting new types of information).
HXL’s role
If each cluster is already adding HXL hashtags to their existing reports, then the other clusters can use the tags to find the specific information they need and import it into their own systems, without asking each of the other clusters to produce a new kind of report.

Use case: Creating visual reports

Coming soon

Use case: Early-warning alerts

Coming soon

Use case: Advocacy web site

Coming soon