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 :
Deadline :
Tender Awarded :
Awarded date :
Contract Start :
Contract End :
Tender Regions
CPV Codes
48990000 - Spreadsheets and enhancement software package
79310000 - Market research services
66170000 - Financial consultancy, financial transaction processing and clearing-house services
73300000 - Design and execution of research and development
73110000 - Research services
73200000 - Research and development consultancy services
73210000 - Research consultancy services
79311410 - Economic impact assessment
79311400 - Economic research services
73000000 - Research and development services and related consultancy services
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
Tender Lot Details
2 Tender Lots
Workflows
Status :
Procedure :
Suitable for SME :
Nationwide :
Assign to :
Tender Progress :
Details
Notice Type :
Tender Identifier :
Tenderbase ID :
Low Value :
High Value :
Buyer Information
Procurement contact
Name :
Phone :
Email :
Possible Competitors
1 Possible Competitors
