The Department for Business, Energy and Industrial Strategy (BEIS): Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

  The Department for Business, Energy and Industrial Strategy (BEIS) is using Delta eSourcing to run this tender exercise

Notice Summary
Title: Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets
Notice type: Contract Notice
Authority: The Department for Business, Energy and Industrial Strategy (BEIS)
Nature of contract: Services
Procedure: Open
Short Description: 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.
Published: 03/11/2015 14:11
Please note that the deadline for response to this opportunity has passed. However, you can still register or log-into the Delta eSourcing solution to prepare your Supplier Profile for future opportunities.

View Full Notice

UK-London: Research and development services and related consultancy services.

Section I: Contracting Authority
   I.1)Name, Addresses and Contact Point(s):
      Department of Energy and Climate Change (DECC)
      3 Whitehall Place,, London, SW1Y 2AW, United Kingdom
      Tel. +44 3000685688, Email: alec.waterhouse@decc.gsi.gov.uk, URL: www.decc.gsi.gov.uk
      Contact: Alec Waterhouse, Attn: Alec Waterhouse
      Electronic Access URL: www.delta-esourcing.com
      Electronic Submission URL: www.delta-esourcing.com

      Further information can be obtained at: As Above       
      Specifications and additional documents: As Above       
      Tenders or requests to participate must be sent to: As Above       
   
   I.2)Type of the contracting authority:
      Ministry or any other national or federal authority, including their regional or local sub-divisions

   I.3) Main activity:
      General Public Services

   I.4) Contract award on behalf of other contracting authorities:
      The contracting authority is purchasing on behalf of other contracting authorities: No

Section II: Object Of The Contract: SERVICES
   II.1)Description
      II.1.1)Title attributed to the contract by the contracting authority: Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets
      II.1.2)Type of contract and location of works, place of delivery or of performance: SERVICES         
         Service Category: 8

         Region Codes: UK - UNITED KINGDOM         
      II.1.3) Information about a public contract, a framework or a dynamic purchasing system:The notice involves a public contract                                                       
      
      II.1.5)Short description of the contract or purchase:
      Research and development services and related consultancy services. Research services. Research and development consultancy services. Research consultancy services. Design and execution of research and development. Market research services. Economic research services. Economic impact assessment. Spreadsheets and enhancement software package. Financial consultancy, financial transaction processing and clearing-house services. 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.
         
      II.1.6)Common Procurement Vocabulary:
         73000000 - Research and development services and related consultancy services.
         
         73110000 - Research services.
         
         73200000 - Research and development consultancy services.
         
         73210000 - Research consultancy services.
         
         73300000 - Design and execution of research and development.
         
         79310000 - Market research services.
         
         79311400 - Economic research services.
         
         79311410 - Economic impact assessment.
         
         48990000 - Spreadsheets and enhancement software package.
         
         66170000 - Financial consultancy, financial transaction processing and clearing-house services.
         

      II.1.7) Information about Government Procurement Agreement (GPA):
         The contract is covered by the Government Procurement Agreement (GPA): Yes       
      II.1.8)Lots:
         This contract is divided into lots: No
      II.1.9)Information about variants:
         Variants will be accepted: Not Provided   
   
   II.2)Quantity Or Scope Of The Contract
      II.2.1)Total quantity or scope:
      Contract will be for 3 months until the end of March 2016, with an option to extend by the Authority for a further month.                  
         Estimated value excluding VAT:
         Range between: 240,000 and 270,000
         Currency: GBP
               
      
      II.2.2)Options: Not Provided         
         II.2.3)Information about renewals:
            This contract is subject to renewal: Not Provided         
   II.3)Duration Of The Contract Or Time-Limit For Completion      
         Duration in months: 3 (from the award of the contract)

   Information About Lots
               
Section III: Legal, Economic, Financial And Technical Information
   III.1)Conditions relating to the contract
      III.1.1)Deposits and guarantees required:
      Not Provided
      
      III.1.2)Main financing conditions and payment arrangements and/or reference to the relevant provisions governing them:
      Not Provided
      
      III.1.3)Legal form to be taken by the group of economic operators to whom the contract is to be awarded:
      Not Provided
      
      III.1.4)Other particular conditions:
         The performance of the contract is subject to particular conditions: Not Provided      
   III.2)Conditions For Participation
      III.2.1)Personal situation of economic operators, including requirements relating to enrolment on professional or trade registers:
      Not Provided      
      III.2.2)Economic and financial capacity
         Economic and financial capacity - means of proof required:         
         Not Provided
      
      III.2.3)Technical capacity
         Technical capacity - means of proof required         
         Not Provided      
      III.2.4)Information about reserved contracts: Not Provided   
   III.3)Conditions Specific To Service Contracts
      III.3.1)Information about a particular profession:
         Execution of the service is reserved to a particular profession: Not Provided      
      III.3.2)Staff responsible for the execution of the service:
         Legal persons should indicate the names and professional qualifications of the staff responsible for the execution of the service: Not Provided
Section IV: Procedure
   IV.1)Type Of Procedure
      IV.1.1)Type of procedure: Open
   
   IV.2)Award Criteria
      IV.2.1)Award criteria:      
         The most economically advantageous tender in terms of
            The criteria stated in the specifications, in the invitation to tender or to negotiate or in the descriptive document

      IV.2.2)Information about electronic auction:
         An electronic auction will be used: Not Provided
   IV.3)Administrative Information
      IV.3.1)File reference number attributed by the contracting authority: TRN 1053B/07/2015      
      IV.3.2)Previous publication(s) concerning the same contract: No

      IV.3.3)Conditions for obtaining specifications and additional documents or descriptive document:

      Date: 04/12/2015
      Time-limit for receipt of requests for documents or for accessing documents: 17:00
         Payable documents: No       
      
      IV.3.4)Time-limit for receipt of tenders or requests to participate
         Date: 07/12/2015
         Time: 15:00      
      IV.3.6)Language(s) in which tenders or requests to participate may be drawn up:         English
         
      IV.3.7)Minimum time frame during which the tenderer must maintain the tender
         Duration in month(s): 6
      
      IV.3.8)Conditions for opening tenders
         Date: 07/12/2015
         Time: 16:00


Section VI: Complementary Information

   VI.1)This Is A Recurrent Procurement: No
   VI.2)Information about European Union funds:
      The contract is related to a project and/or programme financed by European Union funds: No       
   VI.3)Additional Information: The contracting authority considers that this contract may be suitable for economic operators that are small or medium enterprises (SMEs). However, any selection of tenderers will be based solely on the criteria set out for the procurement.
For more information about this opportunity, please visit the Delta eSourcing portal at:
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
   
   VI.4)Procedures For Appeal
      VI.4.1)Body responsible for appeal procedures:
      Department of Energy and Climate Change (DECC)
      3 Whitehall Place, London, SW1Y 2AW, United Kingdom
      Tel. +44 3000685688, Email: alec.waterhouse@decc.gsi.gov.uk, URL: www.decc.gov.uk

      VI.4.2)Lodging of appeals: Not Provided   
   
      VI.4.3)Service from which information about the lodging of appeals may be obtained:
            Not Provided

   VI.5) Date Of Dispatch Of This Notice: 03/11/2015

ANNEX A

View any Notice Addenda


Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets

UK-London: Research and development services and related consultancy services.

Section I: Contracting Authority
   Title: UK-London: Research and development services and related consultancy services.
   I.1)Name, Addresses And Contact Point(s)
      Department of Energy and Climate Change (DECC)
      3 Whitehall Place,, London, SW1Y 2AW, United Kingdom
      Tel. +44 3000685688, Email: alec.waterhouse@decc.gsi.gov.uk, URL: www.decc.gsi.gov.uk
      Contact: Alec Waterhouse, Attn: Alec Waterhouse
   
   I.2)Type Of Purchasing Body
      Not Provided      
      
Section II: Object Of The Contract
   II.1)Description
      II.1.1)Title attributed to the contract by the contracting authority/entity: Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets
      II.1.2)Short description of the contract or purchase:
      Research and development services and related consultancy services. Research services. Research and development consultancy services. Research consultancy services. Design and execution of research and development. Market research services. Economic research services. Economic impact assessment. Spreadsheets and enhancement software package. Financial consultancy, financial transaction processing and clearing-house services. 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.
      
      II.1.3)Common procurement vocabulary:
      73000000 - Research and development services and related consultancy services.
      
      73110000 - Research services.
      
      73200000 - Research and development consultancy services.
      
      73210000 - Research consultancy services.
      
      73300000 - Design and execution of research and development.
      
      79310000 - Market research services.
      
      79311400 - Economic research services.
      
      79311410 - Economic impact assessment.
      
      48990000 - Spreadsheets and enhancement software package.
      
      66170000 - Financial consultancy, financial transaction processing and clearing-house services.
      
      
Section IV: Procedure
   IV.1) Type of Procedure
      IV.1.1)Type of procedure (as stated in the original notice): Open       
   IV.2)Administrative Information
      IV.2.1)File reference number attributed by the contracting authority/entity: TRN 1053B/07/2015      
      IV.2.2)Notice reference for electronically submitted notice
         Original Notice sent via: OJS eSender

         Notice Reference: 2016 - 173512
      IV.2.3)Notice to which this publication refers: Not Provided      
      IV.2.4)Date of dispatch of the original Notice: 12/02/2016
      
Section VI: Complementary Information
   1: Complementary Information
      VI.1)This notice involves: Correction


      VI.3)Information to be corrected or added
         VI.3.1) Modification of original information submitted by the contracting authority
         VI.3.2) In the original Notice

         VI.3.3)Text to be corrected in the original notice:
            
            Place of text to be modified: V.3)Name And Address Of Economic Operator To Whom The Contract Has Been Awarded:
            
            Instead of: Email: jason.palmer@carltd.com
Internet address: www.carltd.com ->
            
            Read: Email: jason.palmer@cambridgeenergy.org.uk
Internet address: www.cambridgeenergy.org.uk

         VI.3.4)Dates to be corrected in the original notice: Not Provided

         VI.3.5)Addresses and contact points to be corrected:
            Not Provided
            
         VI.3.6)Text to be added in the original notice: Not Provided
      VI.4)Other additional information:      
      The contracting authority considers that this contract may be suitable for economic operators that are small or medium enterprises (SMEs). However, any selection of tenderers will be based solely on the criteria set out for the procurement.
To view this notice, please click here:
https://www.delta-esourcing.com/delta/viewNotice.html?noticeId=194720658
GO-2016311-PRO-7899071 TKR-2016311-PRO-7899070

      VI.5)Date of dispatch: 11/03/2016

View Award Notice

UK-London: Research and development services and related consultancy services.

Section I: Contracting Authority
   Title: UK-London: Research and development services and related consultancy services.
   I.1)Name, Addresses and Contact Point(s):
      Department of Energy and Climate Change (DECC)
      3 Whitehall Place,, London, SW1Y 2AW, United Kingdom
      Tel. +44 3000685688, Email: alec.waterhouse@decc.gsi.gov.uk, URL: www.decc.gsi.gov.uk
      Contact: Alec Waterhouse, Attn: Alec Waterhouse
      Electronic Access URL: www.delta-esourcing.com
      Electronic Submission URL: www.delta-esourcing.com

   I.2)Type of the contracting authority:
      Ministry or any other national or federal authority, including their regional or local sub-divisions

   I.3) Main activity:
      Not Provided

   I.4) Contract award on behalf of other contracting authorities:
      The contracting authority is purchasing on behalf of other contracting authorities: No

Section II: Object Of The Contract
   II.1)Description
      II.1.1)Title attributed to the contract by the contracting authority: Quality Assurance and Redevelopment of UK TIMES Industry Input Spreadsheets      
      II.1.2)Type of contract and location of works:
         SERVICES
         
         Service Category: 8
         
         Region Codes: UK - UNITED KINGDOM         
      II.1.3)Information about a framework or a dynamic purchasing system:
         Not Provided          
      II.1.4)Short description of the contract or purchase(s):
         Research and development services and related consultancy services. Research services. Research and development consultancy services. Research consultancy services. Design and execution of research and development. Market research services. Economic research services. Economic impact assessment. Spreadsheets and enhancement software package. Financial consultancy, financial transaction processing and clearing-house services. 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.
      II.1.5)Common procurement vocabulary:
         73000000 - Research and development services and related consultancy services.
         73110000 - Research services.
         73200000 - Research and development consultancy services.
         73210000 - Research consultancy services.
         73300000 - Design and execution of research and development.
         79310000 - Market research services.
         79311400 - Economic research services.
         79311410 - Economic impact assessment.
         48990000 - Spreadsheets and enhancement software package.
         66170000 - Financial consultancy, financial transaction processing and clearing-house services.
      II.1.6)Information about Government Procurement Agreement (GPA):
         The contract is covered by the Government Procurement Agreement (GPA): Yes
   
   II.2)Total Final Value Of Contract(s)
      II.2.1) Total final value of the contract(s)
         Value: 265,150
         Currency: GBP
         Excluding VAT: Yes

      
Section IV: Procedure
   IV.1) Type Of Procedure
      IV.1.1)Type of procedure: Open
   IV.2)Award Criteria
      IV.2.1)Award criteria: The most economically advantageous tender in terms of:
               
         Criteria - Weighting
         
         Understanding the Requirement - 10
         Methodology - 10
         Skills and Expertise of the team allocated to this requirement - 40
         Addressing Challenges and Risks - 10
         Management and Delivery - 10
         Price - 20
         
      IV.2.2)Information about electronic auction:
         An electronic auction will be used: Not Provided
   
   IV.3)Administrative Information
      IV.3.1)File reference number attributed by the contracting authority: TRN 1053B/07/2015         
      IV.3.2)Previous publication(s) concerning the same contract: No


Section V: Award Of Contract
      
   1: Award And Contract Value
      Contract No: 1

      V.1)Date Of Contract Award: 12/01/2016      
      V.2) Information About Offers
         Number Of Offers Received: 14          
         Number Of Offers Received By Electronic Means: 14       
      V.3)Name And Address Of Economic Operator To Whom The Contract Has Been Awarded:
         Official name: Cambridge Energy
         Postal address: 2 Cowper Road
         Town: Cambridge
         Postal code: CB1 3SN
         Country: United Kingdom
         Email: jason.palmer@carltd.com
         Telephone: +44 1223460475
         Internet address: www.carltd.com
      V.4)Information On Value Of Contract
         Total final value of the contract
            Value: 265,150
            Currency: GBP
      V.5)Information about subcontracting:
         The contract is likely to be subcontracted: Not Provided

Section VI: Complementary Information
   VI.1)Information about European Union funds:
      The contract is related to a project and/or programme financed by European Union funds: No
   
   VI.2)Additional Information:
      The contracting authority considers that this contract may be suitable for economic operators that are small or medium enterprises (SMEs). However, any selection of tenderers will be based solely on the criteria set out for the procurement.
To view this notice, please click here:
https://www.delta-esourcing.com/delta/viewNotice.html?noticeId=189728504
GO-2016212-PRO-7751051 TKR-2016212-PRO-7751050   
   VI.3.1)Body responsible for appeal procedures:
      Department of Energy and Climate Change (DECC)
      3 Whitehall Place, London, SW1Y 2AW, United Kingdom
      Tel. +44 3000685688, Email: alec.waterhouse@decc.gsi.gov.uk, URL: www.decc.gov.uk
   VI.3.2)Lodging of appeals: Not Provided    
   VI.3.3)Service from which information about the lodging of appeals may be obtained:
      Not Provided
   
   VI.4)Date Of Dispatch Of This Notice: 12/02/2016