Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

To access this requirement please follow the links below. Your proposal will also need to be uploaded via the Delta Website Below:

https://www.delta-esourcing.com/tenders/UK-UK-London:-Research-and-development-services-and-related-consultancy-services./NXH7S7888M

To respond to this opportunity, please click here: https://www.delta-esourcing.com/respond/NXH7S7888M GO-2015113-PRO-7275398 TKR-2015113-PRO-7275397

If you have any queries with access please contact

Delta Helpdesk

Tel: 0845 270 7050

Email: helpdesk@delta-esourcing.com

Web: http://www.bipsolutions.com/contactform.html

Hours: 8.30am to 5.30pm Monday to Friday

DECC is looking for a contractor or contractors to:

•carry out a partial formula audit; and,

•reconstruct a set of Microsoft Excel work books

using DECC standard model quality assurance guidance and spreadsheet template

https://www.gov.uk/government/collections/quality-assurance-tools-and-guidance-in-decc.

The workbooks are known as “backing sheets”. They calculate a set of input parameters for eight sectors of a whole system energy model built in the TIMES software. N.B there is no requirement for the contractor to be familiar with this software.

The final output of the project will be a set of reconfigured work books that:

•are structured according to agreed best-practice, following key principles such as high levels of transparency and easy traceability;

•contain as few workbooks and worksheets as possible but no fewer;

•are well documented, with:

oin-model documentation (N.B. high level documentation describing the structure of the model will be supplied) of each of the calculations and assumptions (with sources) in the input work books; oinput variables identified and referenced; and,

•include the facility for ranges for the most “important” variables - for uncertainty analysis.

The existing work book structure is complex for each sector there are many interlinked work books. There are approximately 285 work books. The complexity of each sector varies.

The table below shows approximate numbers of equations in each of the sectorial models.

Agriculture324

Electricity1899

Industry5513

Processes1634

Residential4115

Resources733

Services2814

Transport6406

For background information, the full specification and further information on this project please see the ITT.

The successful bidder will need project management expertise to deliver the evaluation, in particular because a significant proportion of the core funding for this project is allocated to the financial year 2014-15. Break points will be built into the contract

Additional information: https://www.delta-esourcing.com/tenders/UK-UK-London:-Research-and-development-services-and-related-consultancy-services./NXH7S7888M

To respond to this opportunity, please click here: https://www.delta-esourcing.com/respond/NXH7S7888M GO-2015113-PRO-7275398 TKR-2015113-PRO-7275397

If you have any queries with access please contact

Delta Helpdesk

Tel: 0845 270 7050

Email: helpdesk@delta-esourcing.com

Web: http://www.bipsolutions.com/contactform.html

Contract will be for 3 months until the end of March 2016, with an option to extend by the Authority for a further month

To respond to this opportunity, please respond to the BIP Solutions link above and return tenders via it please, along with 2 hard copies to the address on this advert by 15:00hrs on 7th December 2015.