{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Promoter Procurement Plan","Procurement Plan","Field comparison","Data","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"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":"Promoter Procurement Plan","index":0,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[11,13,12,13],[22,1,22,2],[23,1,23,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[11,14,12,14],[4,1,4,2],[4,3,4,15],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12],[11,15,12,15],[8,1,10,15],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,11,7],[11,8,12,8]]}
[]
[]
[]
[]
[null,"Project Name:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"*","Note: Please check PUM, Appendix C-7"]
[null,"Procurement plan"]
[]
[]
[null,"Nº","Contract Name","Prom Tender Identifier","Contract Type","Estimated amount (€)","Financing",null,"Procurement Method","Tender Documents","Published in OJEU?","Estimated publication date","Estimated bid submission date","Estimated contract award date","Estimated contract end date","Procurement Status"]
[null,null,null,null,null,null,"% financed by EIB","Other Financiers"]
[null,{"$f":"IF(ISNUMBER(B13),B13+1,1)","v":1}]
[]
[]
[null,"Fields"]
[null,"Nº",null,"Arbitrary number that is assigned consecutively"]
[null,"Contract Name",null,"Scope of the contract or short description"]
[null,"Prom Tender Identifier",null,"Code or reference used by the promoter to refer to the contract (if any)"]
[null,"Contract Type",null,"Type of contract being procured, works: goods or services"]
[null,"Estimated Amount",null,"Estimation of contract value by the promoter"]
[null,"% financed by EIB",null,"Share of the contract that will be financed by EIB, in accordance with the financing plan of the project"]
[null,"Other Financiers",null,"Other IFIs or MDBs that will be jointly co-financing the contract, if any"]
[null,"Procurement Method",null,"Procurement method used, chosen among the ones available under 3.3 of the Guide to Procurement"]
[null,"Tender Documents",null,"Type of standard tender documents used, whether they are based on other IFI's templates or national templates"]
[null,"Published in OJEU",null,"Flag showing whether the tender notice will be published in the Official Journal of the European Union"]
[null,"Estimated publication date",null,"Promoter's estimation of the date of publication of the tender notice"]
[null,"Estimated bid submission date",null,"Promoter's estimation of the date of bid submission"]
[null,"Estimated contract award date",null,"Promoter's estimation of the date of contract award"]
[null,"Estimated contract end date",null,"Promoter's estimation of the date of contract end"]
[null,"Procurement Status",null,"Status of the procurement proces (not started - tender notice not yet published, ongoing - tender notice started but contract not yet signed or contract signed)"]

{"sheet":"Procurement Plan","index":1,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":true,"merged":[[13,10,14,10],[13,11,14,11],[13,12,14,12],[13,13,14,13],[13,16,14,16],[13,4,14,4],[13,5,14,5],[13,6,13,7],[13,8,14,8],[13,9,14,9],[1,1,1,10],[2,1,2,2],[3,1,3,2],[4,1,4,2],[3,8,3,10],[4,6,4,7],[4,8,4,10],[2,3,2,10],[3,3,3,5],[4,3,4,5],[5,6,8,10],[5,1,5,2],[6,1,8,2],[3,6,3,7],[13,14,14,14],[10,1,12,18],[5,3,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[13,15,14,15],[13,17,14,17],[13,18,14,18],[13,1,14,1],[13,2,14,2],[13,3,14,3]]}
[]
[null,"Project Information"]
[null,"Project name:"]
[null,"Project SERAPIS No: ",null,null,null,null,"PJ Contact person:"]
[null,"Project Procurement Risk at appraisal:",null,null,null,null,"Division:"]
[null,"Country:"]
[null,"Project Cost",null,"PIC"]
[null,null,null,"NIC"]
[null,null,null,"EIC"]
[]
[null,"Procurement plan"]
[]
[]
[null,"Nº","Contract Name","Prom Tender Identifier","Contract Type","Estimated amount (€)","Financing",null,"Procurement Method","Tender Documents","Published in OJEU?","Estimated publication date","Estimated submission of bids date","Estimated contract award date","Estimated contract end date","Procurement Status","Review procedure","Risk Scoring","Comment"]
[null,null,null,null,null,null,"% financed by EIB","Other Financiers"]
[null,{"$f":"IF(ISNUMBER(B15),B15+1,1)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$5=0,\"\",$D$5)","v":""}]

{"sheet":"Field comparison","index":2,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Fields in Contract Log"]
[null,null,null,null,null,null,null,null,null,null,null,"Missing are:"]
[null,"Contract Number",null,null,null,null,null,null,"Nº",null,null,"Estimated bid submission date",null,null,null,"Required by the Guide, maybe we can get rid of it?"]
[null,"Contract Name",null,null,null,null,null,null,"Scope",null,null,"Advertised in the OJEU",null,null,null,"Maybe irrelevant?"]
[null,"Contract Group",null,"(works goods services)",null,null,null,null,"Group",null,null,"Other Financiers",null,null,null,"Good to know at all times, probably should include"]
[null,"Review Procedure",null,"(exante, expost, batch)",null,null,null,null,"Review",null,null,"Risk Scoring",null,null,null,"Should include"]
[null,"Tender Procedure",null,null,null,null,null,null,"Method"]
[null,"Prom Tender Identifier",null,null,null,null,null,null,"Prom Tender Identifier"]
[null,"Comment",null,null,null,null,null,null,"Comments",null,null,"New fields needed are:"]
[null,"Eligible FI numbers",null,null,null,null,null,null,null,null,null,"Estimated publication date"]
[null,null,null,null,null,null,null,null,null,null,null,"Estimated award date"]
[null,null,null,null,null,null,null,null,null,null,null,"Estimated amount in EUR"]
[null,"PQ documented/request for expression of interest date:",null,null,null,null,null,null,null,null,null,"Maybe another comment field"]
[null,"Request for Non-Objection to PQ/shortlist date:",null,null,null,null,null,null,null,null,null,"Tickbox to indicate procurement has started?"]
[null,"Non-Objection to PQ/shortlist date"]
[null,"Tender No Comment date"]
[null,"Request for Non-Objection to tech. proposals eval. report date:"]
[null,"Non-Objection to technical proposals evaluation report date:"]
[null,"Advertisement Published in OJEU date:",null,null,null,null,null,null,"Estimated publication date"]
[null,"Award Notice Published in OJEU date"]
[null,"Request for Non-Objection to Award the contract date"]
[null,"Non-Objection to Award the contract date"]
[]
[null,"Contract Awarded",null,"(tickbox)",null,null,null,null,"Estimated award date"]
[null,"Contract award date "]
[null,"Covenant of integrity",null,"(tickbox)"]
[]
[]
[null,"Company Name"]
[null,"Parent holding"]
[null,"Company Share"]
[null,"Company Country"]
[]
[]
[null,"Amount as awarded in the contract",null,null,null,null,null,null,"Estimated amount in EUR"]
[null,"Currency"]
[null,"% Financed by EIB",null,null,null,null,null,null,"% Financed by EIB"]
[]
[]
[null,"Amendments"]

{"sheet":"Data","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
["Group","Adevertised in OJEU?","Procedure","Review","Risk Scoring","Status"]
["Works","Yes","Open International procedure","Ex ante","Low","Not started"]
["Services","No","Restricted International procedure","Batch of small contracts","Medium","Ongoing"]
["Supplies",null,"Negotiated procedure WITH publication OJEU","Ex post monitoring","High","Contract awarded"]
["Other",null,"Negotiated procedure WITHOUT publication OJEU",null,null,"Cancelled"]
[null,null,"National Competitive Bidding"]
[null,null,"Local Shopping or Direct Contracting"]
[null,null,"No contract (force account, direct labour)"]
[null,null,"Not applicable"]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}