{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","Procurement Review Tool","List of contracts","List of contracts -unl"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Guidance","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,0,8,1],[9,0,9,1],[1,0,1,1],[21,0,21,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[22,0,22,1],[29,0,29,1],[26,0,26,1],[24,0,24,1],[12,0,12,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1]]}
[null,"Issued: November 2014"]
["Guidance -Procurement Review"]
[]
["Objective(s):"]
["The objective of the review is to assess the adequacy of the procurement systems and procedures used for health products procured through Global Fund grants to obtain assurance that procurement for Global Fund grant programs is undertaken efficiently and effectively.\nSpecifically, the aim is to determine:"]
["a) the availability of adequate technical capacity and existence of appropriate internal control procedures within the procuring entity;"]
["b) that procurement planning is adequate and there are no material delays in the supply of goods due to poor planning;"]
["c) compliance of PR procurement procedures with Global Fund requirements for openness, transparency, and competitiveness; including adherence to grant procurement guidelines as laid out in the grant agreements with the GF, the procurement manual of the program implementation unit of the procuring entity, the GF PSM policy handbook and best practice; "]
["d) technical specifications, tendering procedures and contracts awarded for procurement of goods and services (health products, non-health products, services and civil works) conform to formal written procurement procedures/guidelines and/or best practice and services of assured quality are obtained at the lowest possible prices; "]
["e) if there are adequate controls in place to minimize the risk of fraud and corruption"]
[]
["Scope:"]
["The Procurement Review Tool represents a comprehensive procurement review.  The Global Fund Country Team and the LFA should agree on whether a full review (i.e. all of the checklist questions) or a partial review (i.e. focus on some specific areas only), is required."]
[]
["Output/Deliverables and timing of deliverables:"]
["The report should address each of the points listed under the scope of review/list of tasks above and include:"]
["1. A detailed description and analysis of issues/risks identified.  The LFA should explain the context and root causes of the issues identified, providing background information as necessary and prioritise the list of issues in an executive summary according to their significance."]
["2. Recommendations for addressing issues identified.  Recommendations should be:"]
["a) Detailed – with all the relevant information included"]
["b) Specific and contextualised"]
["c) Time-bound"]
["d) Prioritized based on the level of risk"]
["e) Identifying the main entity responsible for implementation"]
[]
["The LFA should use the Procurement Review Tool to document all relevant information, findings and recommedations from the review."]
[]
["Should the review identify clear evidence of fraud, the LFA should ensure it uses the GF communication protocol to inform the GF Secretariat and the OIG to allow consideration of evidence collection and other issues relevant to a possible criminal investigation."]
[]
["Service Delivery"]
["This task should be undertaken by the LFA PSM Expert who is accountable for the technical content of this report. S/he can be supported, as needed, by other LFA team members in the planning and during the verification.  The LoE for this task, including report writing, depends on which elements of the ToR and the number of procurement transactions are included in the review, as agreed between the Global Fund Country Team and the LFA. "]

{"sheet":"Procurement Review Tool","index":1,"n_rows":179,"n_cols":23,"rows_kept":179,"cut":false,"hidden":false,"merged":[[70,6,70,9],[69,1,69,3],[69,4,69,5],[69,6,69,9],[64,1,64,3],[64,4,64,5],[64,6,64,9],[68,1,68,3],[68,6,68,9],[66,1,66,3],[66,4,66,5],[66,6,66,9],[65,6,65,9],[63,1,63,3],[63,4,63,5],[63,6,63,9],[60,1,60,3],[60,4,60,5],[60,6,60,9],[62,1,62,3],[62,4,62,5],[62,6,62,9],[61,6,61,9],[61,1,61,3],[61,4,61,5],[57,1,57,3],[57,4,57,5],[57,6,57,9],[58,1,58,3],[58,4,58,5],[58,6,58,9],[55,1,55,3],[55,4,55,5],[55,6,55,9],[56,1,56,3],[56,4,56,5],[56,6,56,9],[54,1,54,3],[54,4,54,5],[54,6,54,9],[48,1,48,3],[48,4,48,5],[48,6,48,9],[53,1,53,3],[49,1,49,3],[49,4,49,5],[49,6,49,9],[50,1,50,3],[50,4,50,5],[50,6,50,9],[53,4,53,5],[53,6,53,9],[52,1,52,3],[52,4,52,5],[52,6,52,9],[32,6,32,9],[30,1,30,3],[31,1,31,3],[31,4,31,5],[31,6,31,9],[47,1,47,3],[47,4,47,5],[47,6,47,9],[45,1,45,3],[45,4,45,5],[45,6,45,9],[41,1,41,3],[40,6,40,9],[41,6,41,9],[41,4,41,5],[42,1,42,3],[42,6,42,9],[42,4,42,5],[40,1,40,3],[40,4,40,5],[3,4,3,9],[4,4,4,9],[5,4,5,9],[6,4,6,9],[7,4,7,9],[21,1,21,3],[22,1,22,3],[26,1,26,3],[18,1,18,3],[18,4,18,5],[18,6,18,9],[20,1,20,3],[20,4,20,5],[16,4,16,5],[11,4,11,9],[12,4,12,9],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[16,1,16,3],[16,6,16,9],[15,4,15,5],[15,1,15,3],[15,6,15,9],[13,1,13,3],[13,8,13,9],[13,4,13,5],[13,6,13,7],[25,1,25,3],[25,4,25,5],[25,6,25,9],[21,4,21,5],[22,4,22,5],[20,6,22,9],[26,4,26,5],[26,6,26,9],[78,1,78,3],[78,4,78,5],[78,6,78,9],[28,1,28,3],[73,1,73,3],[73,4,73,5],[73,6,73,9],[28,6,28,9],[28,4,28,5],[36,1,36,3],[36,4,36,5],[36,6,36,9],[30,4,30,5],[30,6,30,9],[34,4,34,5],[34,6,34,9],[34,1,34,3],[38,1,38,3],[38,4,38,5],[38,6,38,9],[32,1,32,3],[32,4,32,5],[90,0,90,3],[90,4,90,5],[91,0,91,3],[91,4,91,5],[92,0,92,3],[71,6,71,9],[82,0,82,3],[83,0,83,3],[132,18,132,24],[82,4,82,5],[83,4,83,5],[129,0,129,1],[129,2,129,9],[76,1,76,3],[76,4,76,5],[76,6,76,9],[72,1,72,3],[72,4,72,5],[72,6,72,9],[74,1,74,3],[74,4,74,5],[74,6,74,9],[80,4,80,5],[88,4,88,5],[71,1,71,3],[71,4,71,5],[65,1,65,3],[65,4,65,5],[68,4,68,5],[86,0,86,3],[86,4,86,5],[87,0,87,3],[87,4,87,5],[88,0,88,3],[70,1,70,3],[70,4,70,5],[106,1,106,8],[128,0,128,5],[128,6,128,9],[116,0,116,9],[117,1,117,9],[118,1,118,9],[124,1,124,9],[125,1,125,9],[126,1,126,9],[107,1,107,8],[108,1,108,8],[109,1,109,8],[111,1,111,8],[112,1,112,8],[119,1,119,9],[120,1,120,9],[121,1,121,9],[122,1,122,9],[123,1,123,9],[110,1,110,8],[113,1,113,8],[9,4,9,9],[9,1,9,3],[1,0,1,9],[39,1,39,3],[39,4,39,5],[39,6,39,9],[79,1,79,3],[104,1,104,8],[105,1,105,8],[84,0,84,3],[85,0,85,3],[94,0,94,9],[95,1,95,9],[96,1,96,9],[97,1,97,9],[84,4,84,5],[85,4,85,5],[103,0,103,8],[98,1,98,9],[99,1,99,9],[80,0,80,3],[81,0,81,3],[81,4,81,5],[92,4,92,5]]}
[{"$nulls":9},"Issued: November 2014"]
["Procurement Review Tool"]
[]
[null,"Country:"]
[null,"Disease:"]
[null,"Grant Number:"]
[null,"Principal Recipient:"]
[null,"Sub-Recipient (If applicable)"]
[]
[null,"Procurement review method",null,null,"Please specify which method was used in completing the review, e.g. document desk review, attendance (as observer) of bid opening or bids evaluation/supplier selection committee meetings, as relevant"]
[]
[null,"Procurement package name"]
[null,"Procurement package number"]
[null,"Estimated budget of the procurement package (US$ or EUR)",null,null,"Select"]
[]
[{"$nulls":6},"Comments Section"]
[1,"Procuring Entity, and its role in grant implementation",null,null,"Please choose from a list",null,"Please specify the name of procurement entity."]
[]
[{"$f":"A17+1","v":2},"Type of procurement",null,null,"Please choose from a list",null,"Please provide more details."]
[]
[{"$f":"A19+1","v":3},"Is the procurement in line with:",{"$nulls":4},"Please verify the approved PSM plan, workplan and budget and comment as necessary (Are the quantities of products in line with the PSM plan? Please flag if the quantities of products procured significantly differ from those indicated in a PSM plan).\nCheck whether there is a systematic review and update of the forecasting and quantification prior to the initiation of the procurement process to ensure appropriateness of quantities."]
[3.1,"Approved PSM plan ",null,null,"Please choose from a list"]
[3.2,"Work plan and budget",null,null,"Please choose from a list"]
[]
[]
[4,"Procurement method",null,null,"Please choose from a list",null,"Please provide more details if necessary.\n"]
[{"$f":"A26+0.1","v":4.0999999999999996},"Is the chosen procurement method in line with the applicable procurement policies?",null,null,"Please choose from a list",null,"Please check whether the chosen procurement method complies with the instruction/conditions and threshold presented in an applicable procurement manual."]
[]
[5,"Procurement request raised on and by (please insert date and entity if applicable)",null,null,"2013-01-01",null,"Please give the date and name of the requisitioner (organization or official's position) (DD/MM/YYYY)"]
[]
[6,"Was the bidding document appropriate for this procurement? (e.g. right template as provided by a national legislation, right format, included relevant clauses, etc.)",null,null,"Please choose from a list",null,"Please review the bidding document verifying its compliance with the standard template and its quality and appropriateness for the procurement."]
[6.1,"Were the supplier selection (evaluation) and qualification criteria well defined to ensure fair competition and clearly presented in the document?",null,null,"Please choose from a list",null,"Please verify existence of evaluation criteria in the bidding. \nIf evaluation and suppliers' selection criteria are included in the bidding document, please comment on reasonableness and adequacy of these criteria."]
[6.2,"If a bid security was requested, was the amount of the bid security in line with the guidance presented in the applicable procurement norms?",null,null,"Please choose from a list",null,"Please comment."]
[]
[7,"Were the technical specifications neutral and non-restrictive to ensure fair competition? Were the technical specifications reviewed and/or approved by the supplier selection/procurement committee? (if applicable)",null,null,"Please choose from a list",null,"Please review the technical specifications and comment accordingly."]
[]
[8," If supplier pre-qualification was undertaken for this procurement,  was the pre-qualification process fair and objective?",null,null,"Please choose from a list",null,"Please comment."]
[]
[9,"If applicable, was the procurement publicly advertised in line with requirements of applicable procurement norms? Was a bids distribution register maintained?",null,null,"Please choose from a list",null,"Please check relevant information - including - request a copy of a newspaper ad, printout from a portal, e-mail confirmation on publication, bids distribution register, etc."]
[9.1,"Was the bidding period (time given to bidders to prepare their bids) in line with the applicable procurement norms?",null,null,"Please choose from a list",null,"Please comment."]
[9.1999999999999993,"Date of advertising",{"$nulls":4},"Please enter the date (DD/MM/YYYY)"]
[9.3000000000000007,"Bids submission deadline",{"$nulls":4},"Please enter the date (DD/MM/YYYY)"]
[9.4,"Bidding period Nr of days",{"$nulls":4},{"$f":"E42-E41","v":0}]
[]
[]
[10,"If the bidding documents were amended (or otherwise modified)  during the bidding stage, were the amendments or modifications communicated to all bidders in line with the instructions presented in the applicable procurement norms?",null,null,"Please choose from a list",null,"Please comment and give details."]
[]
[11,"Were bids opened publicly? (if applicable)",null,null,"Please choose from a list",null,"Please comment. \nPlease request and review the relevant information - minutes of bid opening, attendance register, etc.(Please note that as per certain procurement norms, certain procurement methods do not require a public opening of bids). Please consult the applicable procurement norms."]
[11.1,"Was the minimum information (e.g. bidders' names, total bid prices, etc.) captured and documented in the minutes of the bid opening?",null,null,"Please choose from a list",null,"Please verify relevant documents and comment accordingly. Please answer this question only if a public bid opening was organized"]
[11.2,"How many quotations/bids were received?",null,null,"Please choose from a list",null,"Please comment. \nPlease request and review the relevant information - minutes of bid opening, attendance register, etc.(Please note that as per certain procurement norms, certain procurement methods do not require a public opening of bids). Please consult"]
[11.3,"Was a bids submission register maintained?",null,null,"Please choose from a list",null,"Please check the register if available and comment accordingly."]
[]
[12,"Was the evaluation of bids carried out by  an evaluation committee?",null,null,"Please choose from a list",null,"Please review the bids evaluation process and comment accordingly."]
[12.1,"Was the evaluation of bids carried out fairly and objectively?",null,null,"Please choose from a list",null,"Please review relevant documents, including the evaluation report and annexes and comment accordingly."]
[12.2,"Are the evaluation stages,  evaluation committee decisions and final outcome of the bids evaluation process  well documented and captured in a final evaluation report?",null,null,"Please choose from a list",null,"Please review the evaluation report and comment accordingly."]
[12.3,"Were there any complaints/bid protests raised by any bidders and if yes, were they handled appropriately?",null,null,"Please choose from a list",null,"Please comment and give details, if applicable"]
[12.4,"The lowest evaluated bidder: name and total bid price",{"$nulls":4},"Please give the final evaluated price of the lowest evaluated bid, specify bidder's name in the comment (in this cell). \nPlease indicate the amount in US$ or EUR in Cell E:57 and specify the currency in this comment box."]
[12.5,"Please give the date of finalization of the bids evaluation process",{"$nulls":4},"Please insert the date and provide comments, as relevant (DD/MM/YYYY)"]
[12.6,"Please give the date of issuance of notification of contract award (if it was issued) ",{"$nulls":4},"Please insert the date and provide comments, as relevant (DD/MM/YYYY)"]
[]
[13,"Was the contract awarded to the lowest evaluated bidder?",null,null,"Please choose from a list",null,"Please comment."]
[13.1,"Total contract price",{"$nulls":4},"Please specify in US$ or EUR (the same currency as in cell \"E:14\" above). Please specify the currency in the comment box."]
[13.2,"Please give the date of contract award",{"$nulls":4},"Please insert the date (DD/MM/YYYY) and provide comments, as relevant."]
[13.3,"Are the contract terms in line with the provisions of the bidding document and the selected bidder's bid?",null,null,"Please choose from a list",null,"Please verify the contract and comment accordingly. Please check the contractual terms and conditions with those presented in the bidding documents and in the lowest evaluated bidder's bid."]
[13.4,"Was the contract amended or otherwise modified during the implementation?",null,null,"Please choose from a list",null,"Please verify with particular attention to: i) quantity modifications, ii) unit cost variation, iii) delivery time/conditions modification, iv) removal of certain line items from the contract."]
[13.5,"What payment method and terms were used in the contract and were these terms appropriate? ",null,null,"Please choose from a list",null,"Please verify the contract and comment accordingly. (payment method: wire transfer, cashier's check, cash, letter of credit, combination of these methods, etc, payment terms: XX % advance payment, XX % upon delivery, etc.)"]
[13.6,"Was a performance security requested and was its amount appropriate (in line with the instructions prescribed by applicable procurement norms?)",null,null,"Please choose from a list",null,"Please verify the amount of performance security and comment if the amount was in line with the instructions provided in the applicable procurement norms."]
[]
[14.1,"Did both parties (procuring entity and supplier) comply with the contract terms and conditions?",null,null,"Please choose from a list",null,"Please verify relevant documents and comment accordingly. Consider also the below questions in  section \"additional comments\" section."]
[14.2,"Did the supplier supply the goods in line with the contract requirements (specifications, quantity, delivery terms and timing)?",null,null,"Please choose from a list",null,"Please comment. Please verify shipping/delivery documents, acceptance documents, inspection documents. \nIn case of delays in the delivery of the goods and where applicable, was the liquidated damages clause revoked by the purchaser?"]
[14.3,"Were the supplied goods adequately and objectively inspected? (and if applicable necessary tests performed to ensure product quality)",null,null,"Please choose from a list",null,"Please comment. Please request relevant documents such as acceptance certifications, inspection certificates, etc."]
[14.4,"When was the last shipment received? ",{"$nulls":4},"Please provide the delivery date (dd/mm/yyyy)."]
[14.5,"Was the payment to the supplier issued on time?",null,null,"Please choose from a list",null,"Please verify and comment accordingly. Was the payment issued in line with the terms and conditions outlined in the supply contract?"]
[14.6,"The last payment under the contract was issued on",{"$nulls":4},"Please provide the payment date."]
[14.7,"Are the prices paid by the procuring entity reasonable?",null,null,"Please choose from a list",null,"Where applicable, for high value items, please verify the prices against reputable international price references, local market prices, etc.\nPlease provide detailed information (e.g. price paid by the PR vs. reference price and its source)."]
[]
[15,"If applicable, were the products entered into the PQR?",null,null,"Please choose from a list",null,"Please comment (applicable only to those products that are required to be entered into the PQR system)"]
[]
[16,"Completeness of the procurement file: Is the procurement file complete and the relevant documents available? ",null,null,"Please choose from a list",null,"Please list if any document was missing from the procurement file or was not provided for the LFA's review."]
[]
["Timelines",null,null,null,"Dates",null,"Days"]
["Procurement request raised on",null,null,null,{"$f":"E29","v":"2013-01-01"}]
["Bid opportunity advertised on",null,null,null,{"$f":"E41","v":"00:00:00"},null,{"$f":"E83-E82","v":-41275}]
["Bids submission deadline",null,null,null,{"$f":"E42","v":"00:00:00"},null,{"$f":"E84-E83","v":0}]
["Evaluation was finalized on",null,null,null,{"$f":"E58","v":"00:00:00"},null,0]
["Contract was signed on",null,null,null,{"$f":"E63","v":"00:00:00"},null,0]
["the Last shipm. under the cont. received on",null,null,null,{"$f":"E72","v":"00:00:00"},null,0]
["The last payment under the contract",null,null,null,{"$f":"E74","v":"00:00:00"},null,0]
["Total procurement lead time (month)",{"$nulls":5},{"$f":"SUM(G83:G88)/30.4","v":-1357.7302631578948}]
[]
["Total budget (estimated)",null,null,null,{"$f":"G14","v":0}]
["Total contract price",null,null,null,{"$f":"E62","v":0}]
["Ratio (est./actual):",null,null,null,{"$f":"E92/E91","v":{"$error":"#DIV/0!"}}]
[]
["Additional Comments"]
[1,"Please insert additional comments related to the procurement process (including for example if the instructions on segregation of functions (as applicable) was respected, potential conflict of interests (if observed, completeness of a procurement file, any other observation that was not covered by the questionnaire above, but in the LFA's opinion needs to be reported)\ne.g. comment if there are signs of collusion among bidders (e.g. bids of very similar format with similar mistakes/typos, signatures, etc.) and if any losses arose from negligence, financial malpractice, other mismanagement "]
[2,"Rows can be added as necessary"]
[3]
[4]
[5]
[]
[]
[]
["Findings",{"$nulls":8},"Importance"]
[1,"Please summarize the key findings from above sections. Add rows as necessary",{"$nulls":7},"Please choose "]
[2,{"$nulls":8},"Please choose "]
[3,{"$nulls":8},"Please choose "]
[4,{"$nulls":8},"Please choose "]
[5,{"$nulls":8},"Please choose "]
[6,{"$nulls":8},"Please choose "]
[7,{"$nulls":8},"Please choose "]
[8,{"$nulls":8},"Please choose "]
[9,{"$nulls":8},"Please choose "]
[10,{"$nulls":8},"Please choose "]
[]
[]
["Recommendations"]
[1,"Please summarize the key recommendations for the Global Fund Secretariat and for the PR"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[]
["Overall Recommendation",{"$nulls":5},"Please choose "]
["Comment",null,"Please provide a brief justification for the above recommendation"]
[]
[]
[{"$nulls":18},"Data"]
[{"$nulls":18},"Procurement type",null,"Procuring Entity",null,"Yes/No"]
[{"$nulls":18},"Please choose from a list",null,"Please choose from a list",null,"Please choose from a list"]
[{"$nulls":18},"Pharmaceutical products",null,"Principal Recipient",null,"Yes"]
[{"$nulls":18},"Health products and equipment",null,"Sub-Recipient",null,"No"]
[{"$nulls":18},"Goods",null,"Procurement Agent",null,"Not Applicable"]
[{"$nulls":18},"Civil works",null,"Partner/Counterpart",null,"Partially"]
[{"$nulls":18},"Technical Services",null,"Not applicable",null,"Could not be verified"]
[{"$nulls":18},"Consulting Services"]
[]
[{"$nulls":18},"Procurement Method",null,"Currency",null,"Quantification"]
[{"$nulls":18},"Please choose from a list",null,"Select",null,"Please choose from a list"]
[{"$nulls":18},"Request for Quotation/Shopping",null,"US$",null,"Morbidity"]
[{"$nulls":18},"National Competitive Bidding/Tender",null,"EUR",null,"Past Consumption"]
[{"$nulls":18},"International Competitive Bidding/Tender",null,null,null,"Mixed"]
[{"$nulls":18},"Limited Competitive Bidding",null,null,null,"Other"]
[{"$nulls":18},"Request for Proposals",null,null,null,"Not Applicable"]
[{"$nulls":18},"Direct procurement"]
[{"$nulls":18},"Other"]
[]
[{"$nulls":18},"Numbers",null,"Payment method",null,"Payment term"]
[{"$nulls":18},"Please choose from a list",null,"Please choose from a list",null,"Please choose from a list"]
[{"$nulls":18},1,null,"Wire transfer",null,"Advance Payment 100 %"]
[{"$nulls":18},2,null,"Cashier's check",null,"100% on delivery"]
[{"$nulls":18},3,null,"Letter of Credit",null,"Advance 20% and 80% on delivery"]
[{"$nulls":18},4,null,"Cash",null,"Other"]
[{"$nulls":18},5,null,"Combination of the above"]
[{"$nulls":18},6]
[{"$nulls":18},7]
[{"$nulls":18},8,null,"Importance",null,"Recommendation:"]
[{"$nulls":18},9,null,"Please choose ",null,"Please choose "]
[{"$nulls":18},10,null,"Critical",null,"No Findings, the LFA recommends approval of the procurement"]
[{"$nulls":18},11,null,"Significant",null,"Minor findings, the LFA recommends approval of the procurement"]
[{"$nulls":18},12,null,"minor",null,"Significant finds, the LFA does not recommend approval of the procurement."]
[{"$nulls":18},13,null,"insignificant/observation"]
[{"$nulls":18},14]
[{"$nulls":18},15]
[{"$nulls":18},16]
[{"$nulls":18},17]
[{"$nulls":18},18]
[{"$nulls":18},19]
[{"$nulls":18},20]
[{"$nulls":18},21]
[{"$nulls":18},22]
[{"$nulls":18},23]
[{"$nulls":18},24]
[{"$nulls":18},25]

{"sheet":"List of contracts","index":2,"n_rows":43,"n_cols":19,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,3,4,5],[5,3,5,5],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[1,3,1,5],[2,3,2,5],[3,3,3,5]]}
[]
[null,"Country:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E4)=TRUE,\"\",'Procurement Review Tool'!E4)","v":""}]
[null,"Disease:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E5)=TRUE,\"\",'Procurement Review Tool'!E5)","v":""}]
[null,"Grant Number:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E6)=TRUE,\"\",'Procurement Review Tool'!E6)","v":""}]
[null,"Principal Recipient:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E7)=TRUE,\"\",'Procurement Review Tool'!E7)","v":""}]
[null,"Sub-Recipient (If applicable)",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E8)=TRUE,\"\",'Procurement Review Tool'!E8)","v":""}]
[]
[null,"List of procurement contracts","Period covered from",null,"to"]
[]
["N","Contract/package name ","Contract ref number","estim. Budget (US$/Eur)","procurement method","contract value (if avarded)","current status","Selected for review"]
[1,{"$nulls":5},"Please choose"]
[2,{"$nulls":5},"Please choose"]
[3,{"$nulls":5},"Please choose"]
[4,{"$nulls":5},"Please choose"]
[5,{"$nulls":5},"Please choose"]
[6,{"$nulls":5},"Please choose"]
[7,{"$nulls":5},"Please choose"]
[8,{"$nulls":5},"Please choose"]
[9,{"$nulls":5},"Please choose"]
[10,{"$nulls":5},"Please choose"]
[11,{"$nulls":5},"Please choose"]
{"$rows_empty":17}
[{"$nulls":14},"Please choose",null,null,null,"Yes"]
[{"$nulls":14},"1 Bidding stage",null,null,null,"No"]
[{"$nulls":14},"2 Evaluation stage"]
[{"$nulls":14},"3 Contract implementation stage"]
[{"$nulls":14},"4 Finalized"]

{"sheet":"List of contracts -unl","index":3,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":true,"merged":[[4,1,4,2],[4,3,4,5],[5,1,5,2],[5,3,5,5],[1,1,1,2],[1,3,1,5],[2,1,2,2],[2,3,2,5],[3,1,3,2],[3,3,3,5]]}
[]
[null,"Country:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E4)=TRUE,\"\",'Procurement Review Tool'!E4)","v":""}]
[null,"Disease:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E5)=TRUE,\"\",'Procurement Review Tool'!E5)","v":""}]
[null,"Grant Number:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E6)=TRUE,\"\",'Procurement Review Tool'!E6)","v":""}]
[null,"Principal Recipient:",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E7)=TRUE,\"\",'Procurement Review Tool'!E7)","v":""}]
[null,"Sub-Recipient (If applicable)",null,{"$f":"IF(ISBLANK('Procurement Review Tool'!E8)=TRUE,\"\",'Procurement Review Tool'!E8)","v":""}]
[]
[null,"List of procurement contracts","Period covered from",null,"to"]
[]
["N","Contract/package name ","Contract ref number","estim. Budget (US$/Eur)","procurement method","contract value (if avarded)","current status","Selected for review"]
[1,{"$nulls":5},"Please choose"]
[2,{"$nulls":5},"Please choose"]
[3,{"$nulls":5},"Please choose"]
[4,{"$nulls":5},"Please choose"]
[5,{"$nulls":5},"Please choose"]
[6,{"$nulls":5},"Please choose"]
[7,{"$nulls":5},"Please choose"]
[8,{"$nulls":5},"Please choose"]
[9,{"$nulls":5},"Please choose"]
[10,{"$nulls":5},"Please choose"]
[11,{"$nulls":5},"Please choose"]
{"$rows_empty":16}
[{"$nulls":14},"Please choose",null,null,null,"Yes"]
[{"$nulls":14},"1 Bidding stage",null,null,null,"No"]
[{"$nulls":14},"2 Evaluation stage"]
[{"$nulls":14},"3 Contract implementation stage"]
[{"$nulls":14},"4 Finalized"]