{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["PSA - Award Contract","Suppliers","Documents","Example - Award Contract","PSA Team Use","Data Validation Sheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PSA - Award Contract","index":0,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,2,2,23],[7,8,7,11],[11,6,11,11],[13,2,13,7],[16,9,16,11],[35,2,36,23],[32,21,32,23],[20,9,20,11],[9,8,9,11],[29,7,29,9],[15,9,15,11],[15,2,15,4],[17,15,18,21],[29,2,29,6],[18,2,18,4],[20,2,20,4],[22,2,22,4],[8,15,15,23],[13,9,13,11],[24,9,24,11],[30,21,30,23],[18,9,18,11],[27,15,28,23],[31,21,31,23],[22,9,22,11],[30,2,32,11],[20,15,21,23],[22,15,24,23],[24,2,24,6],[26,2,27,6],[27,9,27,11]]}
[]
[]
[null,null,"PSA - Awarded Contract"]
[]
[]
[]
[]
[null,null,"*Primary Ref (Bravo Project Code):",null,null,null,null,null,"N/A",null,null,null,null,null,null,"Approval for publication statement:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I confirm that the uploaded documents and information contain and require no protective marking and have been approved and cleared for publication, and may be freely published.\nI confirm that Contracts Finder (www.gov.uk/contracts-finder) is not responsible or liable for the contents and accuracy of the attached documents and information. \nI understand that it is neither Contracts Finder's (www.gov.uk/contracts-finder) responsibility to protectively mark documents submitted nor to check that any appropriate marking has been made. I understand that this is an automated process and businesslink.gov.uk cannot check the contents and accuracy of the attached documents.\nI also understand that all fields in this spreadsheet must be completed and confirm that I have done so, and that failure to do so will result in the request for publication being returned to the sender."]
[null,null,"Ref if not on Bravo:",null,null,null,null,null,"WatAmb_ProjLitRev_WA1"]
[]
[null,null,"Contract Title:",null,null,null,"Scoping review of projections and futures relevant to management of water and water ecosystems in England "]
[]
[null,null,"Date tenders were sent for publication:   ",null,null,null,null,null,null,"2021-08-25"]
[]
[null,null,"Contract Duration:",null,null,null,null,"Start Date:",null,"2021-10-06"]
[null,null,null,null,null,null,null,"End Date:",null,"2022-02-09"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I would like this contract published and agree with above publication statement:   "]
[null,null,"Date Contract Awarded :",null,null,null,null,null,null,"2021-10-06",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,null,"Actual Award Value: ",null,null,null,null,null,null,"£24382 + VAT",null,null,null,null,null,"If you answered No to the above please state a reason for non publication below:"]
[]
[null,null,"Procedure Type:",null,null,null,null,null,null,"Open procedure (OJEU)"]
[]
[null,null,"Checked for release by:",null,null,null,null,null,null,"Project manager"]
[]
[null,null,"Procurement Contact Name or Client Name (if no Procurement Contact):"]
[null,null,null,null,null,null,null,null,null,"David Forrow",null,null,null,null,null,"SaCT Team Use Only:\n(Please do not enter any information into the fields below)"]
[]
[null,null,"Additional information:",null,null,null,null,{"$f":"IF(L30>3000, \"exceeds limit\",\"\")","v":""},null,null,null,{"$f":"LEN(C31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Received:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Published:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actioned by:"]
[]
[]
[null,null,"List of Suppliers must now be completed on Sheet 2 - Suppliers, and then the list of any documents on Sheet 3 - Documents"]

{"sheet":"Suppliers","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,3,7]]}
["Please enter below the details of all awarded Suppliers"]
["Please fill in all the details in the table below as they are required for publication. If there are multiple suppliers and you do not know the awarded value likely for each supplier then divide the contract value equally between each supplier."]
[]
[]
["Supplier Name","Address / Postcode","Is the Supplier Likely to Sub-Contract?","Reference","Reference number","Awarded Value","is the Supplier a SME? ","is the Supplier a VCSE? "]
["HR Wallingford","HR Wallingford Ltd UK,  Howbery Park, Wallingford, Oxfordshire, UK, OX108BA","No","Companies House number",2562099,"£24382 + VAT","No","No"]

{"sheet":"Documents","index":2,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,3,1]]}
["Please enter below the details of all documents you would like published"]
["The Filename should be the exact name of the document that you will be sending through. The Title to show on Contracts Finder is the name the document will have when it is published and people look at this particular contract."]
[]
[]
[]
["Filename","Title to show on Contracts Finder"]

{"sheet":"Example - Award Contract","index":3,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,2,2,23],[7,8,7,11],[8,15,15,23],[9,8,9,11],[11,6,11,11],[13,2,13,7],[13,9,13,11],[15,2,15,4],[15,9,15,11],[26,2,27,6],[27,9,27,11],[27,15,28,23],[16,9,16,11],[17,15,18,21],[18,2,18,4],[18,9,18,11],[20,2,20,4],[20,9,20,11],[20,15,21,23],[22,2,22,4],[22,9,22,11],[22,15,24,23],[24,2,24,6],[24,9,24,11],[35,2,35,23],[29,2,29,6],[29,7,29,9],[30,2,32,11],[30,21,30,23],[31,21,31,23],[32,21,32,23]]}
[]
[]
[null,null,"PSA - Awarded Contract EXAMPLE ONLY"]
[]
[]
[]
[]
[null,null,"*Primary Ref (Bravo Project Code):",null,null,null,null,null,"n/a",null,null,null,null,null,null,"Approval for publication statement:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I confirm that the uploaded documents and information contain and require no protective marking and have been approved and cleared for publication, and may be freely published.\nI confirm that Contracts Finder (www.gov.uk/contracts-finder) is not responsible or liable for the contents and accuracy of the attached documents and information. \nI understand that it is neither Contracts Finder's (www.gov.uk/contracts-finder) responsibility to protectively mark documents submitted nor to check that any appropriate marking has been made. I understand that this is an automated process and businesslink.gov.uk cannot check the contents and accuracy of the attached documents.\nI also understand that all fields in this spreadsheet must be completed and confirm that I have done so, and that failure to do so will result in the request for publication being returned to the sender."]
[null,null,"Ref if not on Bravo:",null,null,null,null,null,"Example001"]
[]
[null,null,"Contract Title:",null,null,null,"Fabrication and Installation of steel support structure at Bristol depot 1"]
[]
[null,null,"*Date tenders were sent for publication:   ",null,null,null,null,null,null,"2018-03-02"]
[]
[null,null,"Contract Duration:",null,null,null,null,"Start Date:",null,"2018-08-01"]
[null,null,null,null,null,null,null,"End Date:",null,"2019-07-31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I would like this contract published and agree with above publication statement:   "]
[null,null,"*Date Contract Awarded :",null,null,null,null,null,null,"2018-03-12",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,null,"*Actual Award Value: ",null,null,null,null,null,null,25000,null,null,null,null,null,"If you answered No to the above please state a reason for non publication below:"]
[]
[null,null,"*Procedure Type:",null,null,null,null,null,null,"Open (non OJEU)",null,null,null,null,null,"THIS IS AN EXAMPLE FORM ONLY"]
[]
[null,null,"Checked for release by:",null,null,null,null,null,null,"Commercial lead / Project manager / Team member"]
[]
[null,null,"Procurement Contact Name or Client Name (if no Procurement Contact):"]
[null,null,null,null,null,null,null,null,null,"Commercial lead / Project manager / Team member",null,null,null,null,null,"SaCT Team Use Only:\n(Please do not enter any information into the fields below)"]
[]
[null,null,"Additional information:",null,null,null,null,{"$f":"IF(L30>3000, \"exceeds limit\",\"\")","v":""},null,null,null,{"$f":"LEN(C31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Received:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Published:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actioned by:"]
[]
[]
[null,null,"List of Suppliers must now be completed on Sheet 3 - Suppliers, and then the list of documents on Sheet 4 - Documents"]

{"sheet":"PSA Team Use","index":4,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["This list will automatically complete from the form and the PSA Team will use it to copy onto the record of contracts published"]
[]
["Date Published","Reference Number","Contract Title","Region","Procurement Contact","Total value of the contract (£)","Start Date","End Date","Duration of the contract\n(Months)","Name of supplier (s)\n","Categorisation - PSPES Master Category - Level 1\n","Categorisation - PSPES  - Level 2\n","Date Tenders were published","Published On Contracts Finder? (Yes/No)","If not Published then reason for Non Publication"]
[{"$f":"TODAY()","v":"2021-10-12"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(E4,'Data Validation Sheet'!#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"Suppliers!A6 & \"|\" & Suppliers!A7 & \"|\" & Suppliers!A8 & \"|\" & Suppliers!A9 & \"|\" & Suppliers!A10 & \"|\" & Suppliers!A11 & \"|\" & Suppliers!A12 & \"|\" & Suppliers!A13 & \"|\" & Suppliers!A14 & \"|\" & Suppliers!A15 & \"|\" & Suppliers!A16 & \"|\" & Suppliers!A17 & \"|\" & Suppliers!A18 & \"|\" & Suppliers!A19 & \"|\" & Suppliers!A20","v":"HR Wallingford||||||||||||||"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Data Validation Sheet","index":5,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Yes"]
["No"]
[]
[]
[]
[]
["Days"]
["Months"]
[]
[]
[]
["Open procedure (OJEU)"]
["Restricted procedure (OJEU)"]
["Competitive procedure with negotiation (OJEU)"]
["Competitive dialogue (OJEU)"]
["Negotiated procedure without prior publication (OJEU)"]
["Innovation partnership (OJEU)"]
["Open (non OJEU)"]
["Competitive quotation (non OJEU)"]
["Call off from a framework agreement"]
["Call off from a dynamic purchasing system"]
["Catalogue purchase"]
["Single tender action (non OJEU)"]
["Other"]