Awarded

Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

Descriptions

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.

Timeline

Published Date :

15th Feb 2016 9 years ago

Deadline :

12th Jan 2016 9 years ago

Tender Awarded :

1 Supplier

Awarded date :

12th Jan 2016

Contract Start :

18th Jan 2016

Contract End :

31st Mar 2016

Tender Regions

Keywords

advanced spreadsheet tools

pivot table enhancer

macro-enabled workbook

add-in integration

data consolidation tool

formula auditing software

cell styling suite

spreadsheet templating engine

graphing extension

workbook protector

financial consulting

transaction processing

clearinghouse operations

payment consultancy

trade clearinghouse

financial advisory

back-office processing

deal processing

financial operations consulting

clearinghouse facilitation

R&D services

innovation consultancy

feasibility studies

technology development

scientific advisory

experimental design

product innovation

applied research

industrial consultancy

development support

research studies

scientific analysis

literature review

knowledge acquisition

academic investigation

project evaluation

data interpretation

exploratory research

technical review

strategic research planning

R&D planning

innovation strategy

project roadmap

funding advisory

commercialization consulting

technology trend analysis

proposal development

policy advisory

market relevance study

development oversight

scientific consulting

academic research advice

evaluation support

proposal refinement

expert review

methodology guidance

field research advisory

data analysis consulting

study design review

research planning

R&D implementation

experimental execution

innovation delivery

technical program management

end-to-end research services

product testing delivery

project coordination

prototype realization

development execution

market research services

consumer research

product testing

focus groups

market segmentation studies

brand research

competitive analysis

market surveys

consumer insights

market trend analysis

economic research

economic study services

macro-economic analysis

economic impact studies

policy economic evaluation

econometric research

socio-economic analysis

economic forecasting

economic policy assessment

economic consultancy

economic impact assessment

cost-benefit analysis services

socioeconomic impact studies

economic evaluation

policy impact analysis

project economic appraisal

economic consequence assessment

financial-economic impact

socioeconomic evaluation

economic effects analysis

Let’s Get you Started ✍

Get to see all tender details more briefly

Already have an account ?

Workflows

Status :

Awarded

Assign to :

Tender Progress :

0%

Details

Notice Type :

Open opportunity

Tender Identifier :

IT-378-246-T: 2024 - 001

TenderBase ID :

310724019

Low Value :

£100K

High Value :

£1000K

Region :

North Region

Attachments :

Buyer Information

Address :

Liverpool Merseyside , Merseyside , L13 0BQ

Website :

N/A

Procurement Contact

Name :

Tina Smith

Designation :

Chief Executive Officer

Phone :

0151 252 3243

Email :

tina.smith@shared-ed.ac.uk

Possible Competitors

1 Possible Competitors