This is the source code to a simple application that makes it quick to look up all the codes and acronyms that are used in the 'UK TIMES' energy system model.

See https://decc.github.io/uk-times-acronyms for an online version.

You can download an example excel file.

To create one from scratch:

1. Download this query file
2. Open it (either during the download, or by double clicking it)
3. If promoted with a security concern, 'Enable'
4. Right click on the worksheet tab and 'Move or Copy' it to the workbook you want it to be part of

1. Download this query file
2. In Excel, create a new, blank, worksheet
3. choose the 'data' menu, then 'get external data'
4. Choose the uk_times_acronyms.iqy from wherever you saved it.
5. Click 'ok'

1. Unfortunately, Excel does not automatically create a named range for the query (CHECK ON PC)
2. So, first step is to create a named range to cover the table
3. Next step is to use a VLOOKUP to get the name for a code

Edit the codes.tsv file in this folder in Excel (If you have made edits in an external data table elsewhere, just copy and paste them over the contents of the codes.tsv file - it will be fine).

Either send your modified version to [email protected] or, if you know what you are doing, make a pull request.

Please report bugs on http://github.com/decc/uk-times-acronyms