Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

About

Department of Energy and Climate Change (DECC) awarded a contract to Cambridge Energy for quality assurance and redevelopment of UK TIMES industry input spreadsheets.

The work involved a partial formula audit and reconstruction of approximately 285 Microsoft Excel workbooks (backing sheets) that calculate input parameters for eight sectors of a whole system energy model built in TIMES software.

The redevelopment followed DECC standard model quality assurance guidance and spreadsheet template, aiming for best-practice structure with high transparency, traceability, minimal workbooks, in-model documentation of calculations and assumptions with sources, identified input variables, and facilities for uncertainty analysis ranges.

The contract value was AUD 265,150.