{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. Contact details","2. Questionnaire INS","Outputs INS","Score","Sheet1"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":55,"comments":1,"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":"1. Contact details","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,1,3,5],[28,2,28,5],[42,3,42,4],[42,1,42,2],[41,4,41,5],[40,4,40,5],[29,4,29,5],[30,4,30,5],[31,2,31,5],[32,2,32,5],[33,3,33,5],[34,3,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[39,4,39,5]]}
[]
[]
[]
[null,"Food Inspection Company / Quality Survey"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Name and function of the person who filled the questionnaire"]
[null,"Date of the questionnaire filling"]
[]
[]
[null,"Company Name"]
[null,"Respondent",null,"Title "]
[null,"Phone Number",null,"Fax Number"]
[null,"Address"]
[null,"City, Country"]
[]
[]
[null,"Contact ",null,"Title "]
[null,"Phone Number",null,"Fax "]
[null,null,null,"E-Mail"]
[]
[null,"Emergency Recall contact ",null,"Business Number "]
[null,"Title ",null,"Home Number "]
[null," E-Mail",null,"Fax"]

{"sheet":"2. Questionnaire INS","index":1,"n_rows":267,"n_cols":27,"rows_kept":267,"cut":false,"hidden":false,"merged":[[139,17,139,20],[140,17,260,20],[0,8,0,13]]}
[null,null,null,null,null,null,null,null,"RFP  N99-12-051 Annex VI : Technical questionnaire Inspection company"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-03-06"}]
["Yes/No Question","FT","Doc","Info to output",null,null,null,null,"Question                                                                   Please tick the question with an 'x'","Yes","No","Documents               provided (X)","Remarks","Name of the document provided",null,"score",null,"Answer expected",0,1,2,"Further comments from the corrector",null,"Score FT","Final Score"]
[{"$f":"COUNTIF(A5:A291,\"X\")","v":65},{"$f":"COUNTIF(B5:B291,\"X\")","v":21},{"$f":"COUNTIF(C5:C291,\"X\")","v":14},{"$f":"COUNTIF(D5:D291,\"X\")","v":52}]
[null,null,null,null,null,null,null,null,"1)      Inspection service",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y6:Y50)/22","v":0}]
[null,null,null,null,null,null,null,null,"a)      Main Activity",null,null,null,"Percentage (%)"]
["x",null,null,"x",null,null,null,null,"·         Food and Agro products",null,null,null,null,null,null,{"$f":"IF(J7=\"x\", 1*M7/100,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T7=\"x\",0.5,IF(U7=\"x\",1,0))","v":0},{"$f":"IF(S7=\"x\",X7,IF(T7=\"x\",X7,IF(U7=\"x\",X7,P7)))","v":0}]
["x",null,null,"x",null,null,null,null,"·         Pharmaceutical products",null,null,null,null,null,null,{"$f":"IF(J8=\"x\", 0.5*M8/100,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T8=\"x\",0.5,IF(U8=\"x\",1,0))","v":0},{"$f":"IF(S8=\"x\",X8,IF(T8=\"x\",X8,IF(U8=\"x\",X8,P8)))","v":0}]
["x",null,null,"x",null,null,null,null,"·         Construction material",null,null,null,null,null,null,null,null,"for our information"]
["x",null,null,"x",null,null,null,null,"·         Other : please specify on the cell below",null,null,null,null,null,null,null,null,"for our information"]
[null,null,null,null,null,null,null,null,"b)      Food Inspection","x"]
["x",null,null,null,null,null,null,null,"Do you inspect the following commodities?"]
["x",null,null,"x",null,null,null,null,"·         Cereal (grains)",null,null,null,null,null,null,{"$f":"IF(J13=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T13=\"x\",0.5,IF(U13=\"x\",1,0))","v":0},{"$f":"IF(S13=\"x\",X13,IF(T13=\"x\",X13,IF(U13=\"x\",X13,P13)))","v":0}]
["x",null,null,"x",null,null,null,null,"·         Cereal products (flours, fortified blended foods)",null,null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"IF(T14=\"x\",0.5,IF(U14=\"x\",1,0))","v":0},0]
["x",null,null,"x",null,null,null,null,"·         Biscuits",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Pulses",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Oil / Fat",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Can products",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Milk (dry powder)",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Minerals and Vitamins",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Others: sugar & salt.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"Does your inspectors fill in an inspection checklist",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null,"Please provide your sampling procedure",null,null,null,null,null,null,0,null,"check the reference",null,null,null,null,null,{"$f":"IF(T23=\"x\",0.5,IF(U23=\"x\",1,0))","v":0},0]
["x",null,null,null,null,null,null,null,"Do you subcontract inspection to another inspection company.If yes, please go to section 8.",null,null,null,null,null,null,null,null,"it is not recommended that an inspection company subcontract another inspection company. Is the reason receivable?",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"c)       Factory Inspection/Audit","x"]
["x",null,null,"x",null,null,null,null,"Is the company experienced in GMP audit?",null,null,null,null,null,null,{"$f":"IF(J26=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"If yes, does the company have a qualified staff? (specify the qualification)",null,null,null,null,null,null,0,null,"are the qualifications provided relevant?",null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null,"Can you please provide the CV of such auditor?",null,null,null,null,null,null,0,null,"are the CV provided in adequation?",null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"Is the company experienced with HACCP audit?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,"x",null,null,null,null,null,"If yes, does the company have an accredited staff? (provide a copy of the accreditation, scope, validity date)",null,null,null,null,null,null,0,null,"are the qualifications provided relevant?",null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null,"Can you please provide the CV of such auditor?( The CV should mentioned the number of audits performed and the type of audits)",null,null,null,null,null,null,0,null,"are the CV provided in adequation?",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"d)      Fumigation supervizion"]
[null,null,null,"x",null,null,null,null,"i)        Does the company perform fumigation",null,null,null,null,null,null,{"$f":"IF(J33=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"ii)       Do you have a license to perform fumigation",null,null,null,null,null,null,{"$f":"IF(J34=\"x\", 1,0)","v":0},null,"yes",null,null,null,null,null,0,0]
[null,null,"x",null,null,null,null,null,"iii)     If yes, please provide a copy",null,null,null,null,null,null,{"$f":"IF(J35=\"x\", 1,0)","v":0},null,"please check the relevance of the document",null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"iv)     Does the company have the skills to perform fumigation supervision?",null,null,null,null,null,null,{"$f":"IF(J36=\"x\", 1,0)","v":0},null,"is a document provided to attest it",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"2)      Certification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y38:Y50)/13","v":0}]
["x",null,null,"x",null,null,null,null,"Accreditations (National or International)",null,null,null,null,null,null,{"$f":"IF(J38=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,"x",null,null,null,null,null,"Please list them and attached them along with their scope",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"Certifications (International)",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"Please list them and attached them along with their scope",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"a)      ISO 9001",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"b)      ISO 17020",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"Is the company audited?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"If yes please specify frequency: __________________",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"scope of audit: ________________________________",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"Is the company part of one of the following association, if yes, which one (circle the name) & provide a copy of the membership.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"c)       Gafta",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"d)      Fosfa",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"e)      Others? Please specify",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"3)      Company details",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"SUM(Y53:Y54)/2","v":0}]
[null,null,null,"x",null,null,null,null,"a)      Age of the company",null,null,null,null,null,null,0,null,"for our information"]
[null,"x","x",null,null,34,null,null,"b)      Year of business registration (attached a copy of the certificate of incorporation, memorandum of association, articles of association and trading licences for the last two years)",null,null,null,null,null,null,{"$f":"IF(J53=\"x\", 1,0)","v":0},null,"Were the document provided?",null,null,null,null,null,{"$f":"IF(T53=\"x\",0.5,IF(U53=\"x\",1,0))","v":0},0]
[null,"x","x",null,null,null,null,null,"c)       Provide copies of Audited Accounts for the last two years. Misrepresentation of financial background can lead to disqualification of proposals.",null,null,null,null,null,null,{"$f":"IF(J54=\"x\", 1,0)","v":0},null,"Were the document provided?",null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"d)      Number of samples handled per year",null,null,null,null,null,null,{"$f":"IF(J55=\"x\", 1,0)","v":0},null,"for our information"]
[null,null,null,"x",null,null,null,null,"e)      Number of samples handled last year",null,null,null,null,null,null,{"$f":"IF(J56=\"x\", 1,0)","v":0},null,"for our information"]
[null,null,null,"x",null,35,null,null,"f)       Number of inspection per year",null,null,null,null,null,null,{"$f":"IF(J57=\"x\", 1,0)","v":0},null,"for our information"]
[null,null,null,"x",null,36,null,null,"g)      Number of inspection last year",null,null,null,null,null,null,null,null,"for our information"]
[null,null,null,"x",null,37,null,null,"h)      Number of analysis carried out",null,null,null,null,null,null,null,null,"for our information"]
[null,null,null,null,null,"37a",null,null,"4)      Staffing and Training",null,null,null,"Number of staff",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y61:Y75)/12","v":0}]
[null,null,null,"x",null,null,null,null,"a)      How many people are permanently employed?",null,null,null,null,null,null,null,null,"for our information",null,null,null,null,null,null,null,null,{"$f":"IF(M61>0,1,0)","v":0}]
[null,null,null,"x",null,null,null,null,"b)      How many people are casually employed?",null,null,null,null,null,null,null,null,"for our information",null,null,null,null,null,null,null,null,{"$f":"IF(AA61>0,1-(M61/(M61+M62)),0)","v":0}]
[null,null,null,null,null,null,null,null,"c)     Do you have in-country inspectors",null,null,null,null,null,null,{"$f":"IF(J63=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T63=\"x\",0.5,IF(U63=\"x\",1,0))","v":0},0]
[null,null,null,null,null,null,null,null,"d) If yes, lease specify how many"]
[null,"x",null,null,null,"3b",null,null,"c)       Please provide your organizational chart with job description",null,null,null,null,null,null,null,null,"Please check the document, Are the document provided relevant?",null,null,null,null,null,{"$f":"IF(T65=\"x\",0.5,IF(U65=\"x\",1,0))","v":0},0]
[null,"x",null,null,null,4,null,null,"d)      Please provide information on average year of experience per function",null,null,null,null,null,null,{"$f":"IF(J66=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,5,null,null,"e)      Is staff training implemented?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"f)       If yes, can you provide a proof of staff attendance to training as training content?",null,null,null,null,null,null,0,null,"Please check the document, Are the document provided relevant?",null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"g)      Do you evaluate training needs?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null," If yes, please explain.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"h)      Do you have documented trainings records?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"i)       Can the company dedicate more than one inspector for WFP large quantity contract",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,{"$f":"IF(S72=\"x\",X72,IF(T72=\"x\",X72,IF(U72=\"x\",X72,P72)))","v":0}]
["x",null,null,null,null,null,null,null,"j)        Does your staff sign a ‘code of ethics’ policy’?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null,"k)      If yes, can you provide a draft copy of the policy?",null,null,null,null,null,null,0,null,"Please check the relevance of the document",null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"l)        Please provide a list of staff names and their respective CVs that you would like to dedicate to WFP food / factory inspections",null,null,null,null,null,null,null,null,"Please check the relevance of the document",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"5)      Equipment available for inspection purpose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y77:Y95)/18","v":0}]
["x",null,null,null,null,null,null,null,"a)      Do you have the following equipments?"]
["x",null,null,null,null,null,null,null,"·         Grain divider, type:",null,null,null,null,null,null,{"$f":"IF(J78=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,{"$f":"IF(T78=\"x\",0.5,IF(U78=\"x\",1,0))","v":0},0]
["x",null,null,null,null,null,null,null,"·         Flour divider, type:",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Spears, type(s)",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Sampling scoop, type(s)",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Sterilization equipment, type:",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Sample container(s), type(s):",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Sample seal(s), type(s):",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Seal coding, please explain:",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Moisture meter",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Thermometer",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Scale",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"·         Sieves",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         Aflatoxin test kit",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"·         GMO test kit",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"b)      Is there a maintenance schedule implemented for the different equipment?",null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,"x",null,null,null,null,null,"c)       If yes submit a copy of the schedule",null,null,null,null,null,null,0,null,"Please check the copy of the schedule",null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"d)      Is there a calibration routine?",null,null,null,null,null,null,{"$f":"IF(J94=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,"x",null,null,null,null,null,"e)      If yes submit a copy of the schedule",null,null,null,null,null,null,null,null,"please check the copy of the schedule",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"6)      Quality management system",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y97:Y101)/5","v":0}]
["x",null,null,null,null,null,null,null,"a)      Does the company have internal quality assurance policy?",null,null,null,null,null,null,{"$f":"IF(J97=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null," If yes, please provide an attached copy",null,null,null,null,null,null,{"$f":"IF(J98=\"x\", 1,0)","v":0},null,"please check the relevance of the document",null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"b)      Does the company keep record of data? (individual personnel file, certificate of training, NC Report, Warning).  ",null,null,null,null,null,null,{"$f":"IF(J99=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,"x",null,null,null,null,null,"If yes, please provide an example as attachment.",null,null,null,null,null,null,{"$f":"IF(J100=\"x\", 1,0)","v":0},null,"please check the relevance of the document",null,null,null,null,null,0,0]
[null,"x","x",null,null,null,null,null,"c)       What is the procedure followed by the company in case of non-conforming results? Please attached procedure:",null,null,null,null,null,null,{"$f":"IF(J101=\"x\", 1,0)","v":0},null,"please check the relevance of the answer provided",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"7)      Food Analysis",null,null,null,null,null,null,null,null,"for our information",null,null,null,null,null,null,{"$f":"SUM(Y103:Y115)/9","v":0}]
["x",null,null,"x",null,null,null,null,"a)      Does the company own a lab?",null,null,null,null,null,null,{"$f":"IF(J103=\"x\", 1,0)","v":0},null,"for our information",null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"b)      If yes please specify the total size of the lab in square meter",null,null,null,null,null,null,null,null,"for our information"]
["x",null,null,"x",null,null,null,null,"c)       Do you have a Chemical lab",null,null,null,null,null,null,{"$f":"IF(J105=\"x\", 1,0)","v":0},null,"for our information",null,null,null,null,null,0,0]
[null,null,null,"x",null,null,null,null,"d)      If yes please specify the size",null,null,null,null,null,null,null,null,"for our information"]
["x",null,null,null,null,null,null,null,"e)      Do you perform grading",null,null,null,null,null,null,{"$f":"IF(J107=\"x\", 1,0)","v":0},null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"f)       Do you have a Microbiology lab",null,null,null,null,null,null,{"$f":"IF(J108=\"x\", 1,0)","v":0},null,"for our information",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"g)      If yes, please specify the size",null,null,null,null,null,null,null,null,"for our information"]
[null,null,null,null,null,null,null,null,"h)      Are there others sections in your lab?",null,null,null,null,null,null,{"$f":"IF(J110=\"x\", 1,0)","v":0},null,"for our information",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"i)        If yes, please specify",null,null,null,null,null,null,null,null,"for our information"]
["x",null,null,"x",null,null,null,null,"j)        Is your laboratory ISO 17025 accredited?",null,null,null,null,null,null,{"$f":"IF(J112=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"k)      If yes, please provide the certificates and scope of work",null,null,null,null,null,null,null,null,"please check that the scope of work is related to food analysis",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"l)        Equipment available for testing purpose",null,null,null,null,null,null,{"$f":"IF(J114=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"m)    Do you subcontract food analysis?",null,null,null,null,null,null,{"$f":"IF(J115=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"n)      If yes, go to section 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y103:Y115)","v":0}]
[null,null,null,null,null,null,null,null,"8)      Subcontracted company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y118:Y139)/19","v":2.6315789473684209E-2}]
[null,null,null,"x",null,null,null,null,"a)      Please provide a list of your subcontracted Company"]
[null,null,null,null,null,null,null,null,"Name ",null,null,null,"Country"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has the company been approved by WFP?",null,null,null,null,null,{"$f":"IF(T120=\"x\",0.5,IF(U120=\"x\",1,0))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has the company been approved by WFP?",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has the company been approved by WFP?",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Has the company been approved by WFP?",null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"b)      Are the laboratories approved on a written procedure?",null,null,null,null,null,null,{"$f":"IF(J124=\"x\", 1,0)","v":0},null,"please check the procedure",null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"c)       If yes, can you summarize the procedure and decision criteria?",null,null,null,null,null,null,0,null,"please check the relevance of the procedure",null,"x",null,null,null,0.5,0.5]
[null,"x",null,null,null,null,null,null,"d)      If you subcontract food inspection please specify the reason.",null,null,null,null,null,null,0,null,"According to you is the reason receivable?",null,null,null,null,null,0,0]
["x",null,null,null,null,null,null,null,"e)      Please specify for which commodities does the company subcontract food analysis :",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"i)         Grain/Pulses",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"ii)       Processed Foods (Flour / Fortified Blended Foods / Biscuits)",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"iii)      Fortification (minerals & vitamins)",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"iv)      Fat/Oil",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"v)       Can food",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
["x",null,null,"x",null,null,null,null,"vi)      Other, please precise",null,null,null,null,null,null,0,null,"for our information",null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"f)       In case of several subcontracted laboratories, please explain the management of the analysis between the different laboratories (e.g. by commodity, geographical zone…)",null,null,null,null,null,null,null,null,"Does this organiziation seems suitable?",null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"g)      In case of subcontracted laboratory (ies) please precise the timely provision of the lab analysis report per commodity type",null,null,null,null,null,null,null,null,"for our information",null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"è Please precise it for each sub contracted laboratory.",null,null,null,null,null,null,{"$f":"IF(J136=\"x\", 1,0)","v":0},null,"According to you is the reason receivable?",null,null,null,null,null,0,{"$f":"IF(S136=\"x\",X136,IF(T136=\"x\",X136,IF(U136=\"x\",X136,P136)))","v":0}]
[null,"x",null,null,null,null,null,null,"h)      In case of subcontracted laboratory (ies) localized in a different country: are the samples likely to be held by Customs? If yes, please specify the measures that will be taken to mitigate the problem and ensure that the analysis is not delayed further. Please precise it for each laboratory localized in a different country.",null,null,null,null,null,null,{"$f":"IF(J137=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,"x",null,null,null,null,null,null,"i)        In case of subcontracted laboratory (ies) localized in a different country, please precise the samples export constraints (e.g. restricted types of commodities can be exported….)",null,null,null,null,null,null,{"$f":"IF(J138=\"x\", 1,0)","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,"9)      Test offered by the company à please complete the table",null,null,null,null,null,null,null,null,"for our information"]
[null,null,null,null,null,null,null,null,"Test","Yes (in-house)","Yes outsourced (please provide in which laboratory)","No","Please specify on which commodity","Method of analysis"]
[null,null,null,null,null,null,null,1,"Moisture",null,null,null,null,null,null,null,null,"Check if the inspection company can performed the analysis related to  the commodities considered (cf specifications of the product considered)"]
[null,null,null,null,null,null,null,2,"Broken kernel"]
[null,null,null,null,null,null,null,3,"Damaged kernel"]
[null,null,null,null,null,null,null,4,"Foreign matters"]
[null,null,null,null,null,null,null,5,"Other type of grains"]
[null,null,null,null,null,null,null,6,"Other colour of grains"]
[null,null,null,null,null,null,null,7,"Shrunken grain (wheat)"]
[null,null,null,null,null,null,null,8,"Sprouted grains"]
[null,null,null,null,null,null,null,10,"Noxious seeds"]
[null,null,null,null,null,null,null,11,"Heat damaged grain"]
[null,null,null,null,null,null,null,12,"Milling degree (rice)"]
[null,null,null,null,null,null,null,13,"Toxins: Aflatoxin B & G"]
[null,null,null,null,null,null,null,14,"Toxin: Aflatoxin M"]
[null,null,null,null,null,null,null,15,"Toxins: DON"]
[null,null,null,null,null,null,null,16,"Toxins: Zea"]
[null,null,null,null,null,null,null,17,"Toxins: Ochratoxin"]
[null,null,null,null,null,null,null,18,"Ergot (wheat)"]
[null,null,null,null,null,null,null,19,"Hagberg Falling number"]
[null,null,null,null,null,null,null,20,"Zeleny index"]
[null,null,null,null,null,null,null,21,"Grain size (pulses)"]
[null,null,null,null,null,null,null,22,"Insect damaged grains"]
[null,null,null,null,null,null,null,23,"Test weight"]
[null,null,null,null,null,null,null,null,"WHEAT / WHEAT FLOUR"]
[null,null,null,null,null,null,null,24,"Wet gluten"]
[null,null,null,null,null,null,null,25,"Gluten index"]
[null,null,null,null,null,null,null,26,"W"]
[null,null,null,null,null,null,null,27,"P/L"]
[null,null,null,null,null,null,null,28,"Fatty acid"]
[null,null,null,null,null,null,null,null,"COMPOSITION"]
[null,null,null,null,null,null,null,29,"Crude Protein"]
[null,null,null,null,null,null,null,30,"Crude Fiber"]
[null,null,null,null,null,null,null,31,"Crude Fat"]
[null,null,null,null,null,null,null,32,"Ash"]
[null,null,null,null,null,null,null,33,"Granulation"]
[null,null,null,null,null,null,null,34,"Urease index"]
[null,null,null,null,null,null,null,null,"FORTIFICATION"]
[null,null,null,null,null,null,null,35,"Vitamin A"]
[null,null,null,null,null,null,null,36,"Vitamin E"]
[null,null,null,null,null,null,null,37,"Vitamin D"]
[null,null,null,null,null,null,null,38,"Vitamin C "]
[null,null,null,null,null,null,null,39,"Thiamin"]
[null,null,null,null,null,null,null,40,"Riboflavin"]
[null,null,null,null,null,null,null,41,"Folic Acid"]
[null,null,null,null,null,null,null,42,"Niacin"]
[null,null,null,null,null,null,null,43,"Pyridoxine"]
[null,null,null,null,null,null,null,44,"Vitamin B12"]
[null,null,null,null,null,null,null,45,"Iron"]
[null,null,null,null,null,null,null,46,"Zinc"]
[null,null,null,null,null,null,null,47,"Calcium"]
[null,null,null,null,null,null,null,null,"HEAVY METALS"]
[null,null,null,null,null,null,null,48,"Lead"]
[null,null,null,null,null,null,null,49,"Mercury"]
[null,null,null,null,null,null,null,50,"Arsenic"]
[null,null,null,null,null,null,null,51,"Cadmium"]
[null,null,null,null,null,null,null,null,"RANCIDITY"]
[null,null,null,null,null,null,null,52,"Peroxide Value"]
[null,null,null,null,null,null,null,53,"Free Fatty Acid"]
[null,null,null,null,null,null,null,54,"Anisidine Value"]
[null,null,null,null,null,null,null,null,"OTHER TESTS"]
[null,null,null,null,null,null,null,55,"Organoleptic taste"]
[null,null,null,null,null,null,null,56,"Radioactivity"]
[null,null,null,null,null,null,null,57,"Melamine"]
[null,null,null,null,null,null,null,58,"GMO test"]
[null,null,null,null,null,null,null,null,"PESTICIDES"]
[null,null,null,null,null,null,null,59,"Carbamate group"]
[null,null,null,null,null,null,null,60,"Organochlorine group"]
[null,null,null,null,null,null,null,61,"Organophosphorus group"]
[null,null,null,null,null,null,null,62,"Pyrethroid group"]
[null,null,null,null,null,null,null,null,"MICROBIOLOGY"]
[null,null,null,null,null,null,null,63,"Aerobic Plate count"]
[null,null,null,null,null,null,null,64,"Total Coliform, "]
[null,null,null,null,null,null,null,65,"E. coli"]
[null,null,null,null,null,null,null,66,"Salmonella"]
[null,null,null,null,null,null,null,67,"Staph aureus, cp"]
[null,null,null,null,null,null,null,68,"Bacilus cereus"]
[null,null,null,null,null,null,null,69,"Enterobacter sakazakii"]
[null,null,null,null,null,null,null,70,"Yeast & Molds"]
[null,null,null,null,null,null,null,71,"Toxins from E. Coli"]
[null,null,null,null,null,null,null,72,"Toxins from B. Cereus"]
[null,null,null,null,null,null,null,73,"Toxins from Staph"]
[null,null,null,null,null,null,null,74,"Listeria monocytogenes"]
[null,null,null,null,null,null,null,75,"Clostridium botulinum"]
[null,null,null,null,null,null,null,null,"OIL / FAT"]
[null,null,null,null,null,null,null,74,"Water and impurities in oil"]
[null,null,null,null,null,null,null,75,"Insoluble impurities in oil"]
[null,null,null,null,null,null,null,76,"Acid value of oil"]
[null,null,null,null,null,null,null,77,"Oil colour: "]
[null,null,null,null,null,null,null,78,"Soap content"]
[null,null,null,null,null,null,null,79,"Taste"]
[null,null,null,null,null,null,null,80,"Iodine value (Wijs)"]
[null,null,null,null,null,null,null,81,"Saponification"]
[null,null,null,null,null,null,null,82,"Unsaponifiable matter"]
[null,null,null,null,null,null,null,83,"Refractive index at 40° C"]
[null,null,null,null,null,null,null,84,"Relative density of oil at 27° C"]
[null,null,null,null,null,null,null,85,"Melting point at 24° C maximum"]
[null,null,null,null,null,null,null,86,"Specific weight at 20° C"]
[null,null,null,null,null,null,null,87,"Erucic acid"]
[null,null,null,null,null,null,null,88,"Linolenic acid"]
[null,null,null,null,null,null,null,89,"Linoleic acid"]
[null,null,null,null,null,null,null,90,"Delta-7-stigmasterol"]
[null,null,null,null,null,null,null,91,"BHT/BHA"]
[null,null,null,null,null,null,null,null,"MILK (DSM & FFM)"]
[null,null,null,null,null,null,null,92,"Titratable acidity in ml of decinormal NaOHsolution"]
[null,null,null,null,null,null,null,93,"Lactates"]
[null,null,null,null,null,null,null,94,"Phosphatase test"]
[null,null,null,null,null,null,null,95,"Insolubility index"]
[null,null,null,null,null,null,null,96,"Burnt particles"]
[null,null,null,null,null,null,null,97,"Buttermilk test"]
[null,null,null,null,null,null,null,98,"Whey test"]
[null,null,null,null,null,null,null,null,"CAN FISH"]
[null,null,null,null,null,null,null,99,"Ingredient (liquid/sauce)"]
[null,null,null,null,null,null,null,100,"Fish species"]
[null,null,null,null,null,null,null,101,"Number of fish"]
[null,null,null,null,null,null,null,102,"The contents of cans"]
[null,null,null,null,null,null,null,103,"Can size"]
[null,null,null,null,null,null,null,104,"Can seam, lid (tightness rate, integrity rate, test V&P, side scam examination"]
[null,null,null,null,null,null,null,105,"Quality of the cans and carton boxes"]
[null,null,null,null,null,null,null,106,"Incubation Test"]
[null,null,null,null,null,null,null,107,"Colouring Test for Para red, Rhodamine B, SUDAN red dyes (I, II, III and IV)"]
[null,null,null,null,null,null,null,108,"physical inspection (gross, drained weights, aspect, cleanliness, colour, impurity, inner fish conditions, etc)"]
[null,null,null,null,null,null,null,null,"Other tests (please use this section to mentioned the tests you can offer to WFP)"]
[]
[null,null,null,null,null,null,null,null,"Signature: ","……………………………………………………………"]
[]
[]
[null,null,null,null,null,null,null,null,"…….……..……………….……………."]
[null,null,null,null,null,null,null,null,"(Name of the Inspection Company and official stamp)."]

{"sheet":"Outputs INS","index":2,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":true,"merged":[[58,1,58,14],[59,1,59,14],[56,1,56,4],[56,5,56,9],[56,10,56,14],[57,1,57,4],[57,5,57,9],[57,10,57,14],[54,1,54,4],[54,5,54,9],[54,10,54,14],[55,1,55,4],[55,5,55,9],[55,10,55,14],[51,2,51,3],[51,4,51,5],[51,7,51,8],[51,10,51,12],[52,1,52,14],[53,1,53,4],[53,5,53,9],[53,10,53,14],[48,1,48,4],[48,5,48,7],[48,8,48,11],[48,12,48,14],[49,1,49,14],[50,2,50,3],[50,4,50,5],[50,7,50,8],[50,10,50,12],[45,1,45,4],[45,5,45,6],[45,7,45,11],[45,12,45,14],[46,1,46,14],[47,1,47,4],[47,5,47,7],[47,8,47,11],[47,12,47,14],[42,1,42,4],[42,5,42,7],[42,8,42,11],[42,12,42,14],[43,1,43,14],[44,1,44,4],[44,5,44,6],[44,7,44,11],[44,12,44,14],[39,1,39,4],[39,5,39,6],[39,7,39,11],[39,12,39,14],[40,1,40,14],[41,1,41,4],[41,5,41,7],[41,8,41,11],[41,12,41,14],[36,1,36,2],[36,3,36,6],[36,7,36,10],[36,11,36,14],[37,1,37,14],[38,1,38,4],[38,5,38,6],[38,7,38,11],[38,12,38,14],[33,1,33,2],[33,3,33,6],[33,7,33,13],[34,1,34,14],[35,1,35,2],[35,3,35,6],[35,7,35,10],[35,11,35,14],[31,1,31,2],[31,3,31,6],[31,7,31,13],[32,1,32,2],[32,3,32,6],[32,7,32,13],[28,1,28,14],[29,1,29,2],[29,3,29,6],[29,7,29,13],[30,1,30,2],[30,3,30,6],[30,7,30,13],[26,1,26,2],[26,3,26,6],[26,7,26,13],[27,1,27,2],[27,3,27,6],[27,7,27,13],[24,2,24,3],[24,4,24,5],[24,7,24,8],[24,10,24,12],[25,1,25,6],[25,7,25,14],[21,1,21,4],[21,5,21,7],[21,8,21,11],[21,12,21,14],[22,1,22,14],[23,2,23,3],[23,4,23,5],[23,7,23,8],[23,10,23,12],[20,1,20,4],[20,5,20,7],[20,8,20,11],[20,12,20,14],[4,1,4,14],[5,1,5,6],[6,1,6,6],[6,7,12,8],[7,1,7,6],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6],[0,1,0,14],[1,1,1,5],[1,6,1,9],[1,11,1,14],[2,1,2,2],[2,3,2,6],[2,7,2,13],[18,1,18,14],[19,1,19,14],[3,1,3,14]]}
[null,"Outputs ETQ"]
[null,"Inspection Company Name",null,null,null,null,{"$f":"'1. Contact details'!C29","v":0},null,null,null,"Country",{"$f":"'1. Contact details'!C33","v":0}]
[null,"Grade",null,{"$f":"Score!B17","v":"C"},null,null,null,"Initial Score",null,null,null,null,null,null,{"$f":"Score!B16/100","v":0}]
[null,{"$f":"IF(VENDASS_RATING=\"\", \"\",IF(VENDASS_RATING=\"C\",Score!J27,IF(VENDASS_RATING=\"D\",Score!K27,\"Based on the technical information provided, the vendor can be consider in the approved vendor's list. It is strongly suggested to visit the vendor's facility. \" )))","v":""}]
[null,"Score details"]
[null,"Section",null,null,null,null,null,null,null,"Points obtained","Max Points",null,null,"Satisfactory answers"]
[null,"1.  Inspection services",null,null,null,null,null,null,null,{"$f":"Score!B9","v":0},25,null,null,{"$f":"J7/K7","v":0}]
[null,"2.  Certification",null,null,null,null,null,null,null,{"$f":"Score!B10","v":0},10,null,null,{"$f":"J8/K8","v":0}]
[null,"3. Company details",null,null,null,null,null,null,null,{"$f":"Score!B11","v":0},5,null,null,0]
[null,"4. Staff and Training",null,null,null,null,null,null,null,{"$f":"Score!B12","v":0},10,null,null,0]
[null,"5. Equipment Available for testing purpose",null,null,null,null,null,null,null,{"$f":"Score!B13","v":0},20,null,null,0]
[null,"6. Quality Management System",null,null,null,null,null,null,null,{"$f":"Score!B14","v":0},10,null,null,0]
[null,"7. Food Analysis",null,null,null,null,null,null,null,{"$f":"Score!B15","v":0},20,null,null,0]
[]
[]
[]
[]
[]
[null,"Food Inspection",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data to output  Only  from the inspection company questionnaire"]
[null,"Main Activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data to output  Only from the lab  questionnaire"]
[null,"Food and Agro products",null,null,null,"Pharmaceutical products",null,null,"Construction Material",null,null,null,null,null,null,null,null,"Data to output from both questionnaires"]
[null,{"$f":"'2. Questionnaire INS'!M7/100","v":0},null,null,null,{"$f":"'2. Questionnaire INS'!M8/100","v":0},null,null,{"$f":"'2. Questionnaire INS'!M9/100","v":0},null,null,null,{"$f":"'2. Questionnaire INS'!M10/100","v":0}]
[null,"Commodities inspected"]
[null,"Cereal (grain)","Cereal products (flours, fortified blended foods)",null,"Biscuits",null,"Pulses","Oil/Fat",null,"Can Products","Milk                     (dry Powder)",null,null,"Minerals and Vitamins","Sugar    &Salt"]
[null,{"$f":"IF('2. Questionnaire INS'!J13=\"x\",\"yes\",IF('2. Questionnaire INS'!K13=\"x\",\"no\",\"\"))","v":""},{"$f":"IF('2. Questionnaire INS'!I14=\"x\",\"yes\",IF('2. Questionnaire INS'!J14=\"x\",\"no\",\"\"))","v":""},null,{"$f":"IF('2. Questionnaire INS'!J15=\"x\",\"yes\",IF('2. Questionnaire INS'!K15=\"x\",\"no\",\"\"))","v":""},null,{"$f":"IF('2. Questionnaire INS'!J16=\"x\",\"yes\",IF('2. Questionnaire INS'!K16=\"x\",\"no\",\"\"))","v":""},{"$f":"IF('2. Questionnaire INS'!J17=\"x\",\"yes\",IF('2. Questionnaire INS'!K17=\"x\",\"no\",\"\"))","v":""},null,{"$f":"IF('2. Questionnaire INS'!J18=\"x\",\"yes\",IF('2. Questionnaire INS'!K18=\"x\",\"no\",\"\"))","v":""},{"$f":"IF('2. Questionnaire INS'!J19=\"x\",\"yes\",IF('2. Questionnaire INS'!K19=\"x\",\"no\",\"\"))","v":""},null,null,{"$f":"IF('2. Questionnaire INS'!J20=\"x\",\"yes\",IF('2. Questionnaire INS'!K20=\"x\",\"no\",\"\"))","v":""},{"$f":"IF('2. Questionnaire INS'!J21=\"x\",\"yes\",IF('2. Questionnaire INS'!K21=\"x\",\"no\",\"\"))","v":""}]
[null,"Factory Audit",null,null,null,null,null,"Fumigation services"]
[null,"GMP Audit",null,{"$f":"IF('2. Questionnaire INS'!J26=\"x\",\"yes\",IF('2. Questionnaire INS'!K26=\"x\",\"no\",\"\"))","v":""},null,null,null,"Fumigation",null,null,null,null,null,null,{"$f":"IF('2. Questionnaire INS'!J33=\"x\",\"yes\",IF('2. Questionnaire INS'!K33=\"x\",\"no\",\"\"))","v":""}]
[null,"HACCP Audit",null,{"$f":"IF('2. Questionnaire INS'!J29=\"x\",\"yes\",IF('2. Questionnaire INS'!K29=\"x\",\"no\",\"\"))","v":""},null,null,null,"Fumigation supervision",null,null,null,null,null,null,{"$f":"IF('2. Questionnaire INS'!J36=\"x\",\"yes\",IF('2. Questionnaire INS'!K36=\"x\",\"no\",\"\"))","v":""}]
[null,"Certifications/ Accreditations"]
[null,"Gafta Member",null,{"$f":"IF('2. Questionnaire INS'!J48=\"x\",\"yes\",IF('2. Questionnaire INS'!K48=\"x\",\"no\",\"\"))","v":""},null,null,null,"ISO 9001",null,null,null,null,null,null,{"$f":"IF('2. Questionnaire INS'!J42=\"x\",\"yes\",IF('2. Questionnaire INS'!K42=\"x\",\"no\",\"\"))","v":""}]
[null,"Fosfa Member",null,{"$f":"IF('2. Questionnaire INS'!J49=\"x\",\"yes\",IF('2. Questionnaire INS'!K49=\"x\",\"no\",\"\"))","v":""},null,null,null,"ISO 17020",null,null,null,null,null,null,{"$f":"IF('2. Questionnaire INS'!J43=\"x\",\"yes\",IF('2. Questionnaire INS'!K43=\"x\",\"no\",\"\"))","v":""}]
[null,"AOAC",null,null,null,null,null,"ISO 17025"]
[null,"AACC",null,null,null,null,null,"Others"]
[null,"ICC",null,null,null,null,null,"Others"]
[null,"Company details"]
[null,"Age of the company",null,"Number of inspection carried out per year",null,null,null,"Number of analysis carried out per year",null,null,null,"Quantity of commodities  handled over the last year (MT)"]
[null,{"$f":"'2. Questionnaire INS'!M52","v":0},null,{"$f":"'2. Questionnaire INS'!M57","v":0},null,null,null,{"$f":"'2. Questionnaire INS'!M55","v":0}]
[null,"Staffing and Training"]
[null,"Number of permanent staff",null,null,null,"Number of casual staff",null,"In country Staff",null,null,null,null,"Training Programme implemented"]
[null,{"$f":"'2. Questionnaire INS'!M61","v":0},null,null,null,{"$f":"'2. Questionnaire INS'!M62","v":0},null,{"$f":"IF('2. Questionnaire INS'!J63=\"x\",'2. Questionnaire INS'!M64,IF('2. Questionnaire INS'!K63=\"x\",\"no\",\"\"))","v":""},null,null,null,null,{"$f":"IF('2. Questionnaire INS'!J67=\"x\",\"yes\",IF('2. Questionnaire INS'!K67=\"x\",\"no\",\"\"))","v":""}]
[null,"Equipment"]
[null,"GMO test kit",null,null,null,{"$f":"IF('2. Questionnaire INS'!J91=\"x\",\"yes\",IF('2. Questionnaire INS'!K91=\"x\",\"no\",\"\"))","v":""},null,null,"Aflatoxin test kit",null,null,null,{"$f":"IF('2. Questionnaire INS'!J90=\"x\",\"yes\",IF('2. Questionnaire INS'!K90=\"x\",\"no\",\"\"))","v":""}]
[null,"Further Comments"]
[null,"Quality Management System"]
[null,"Quality Policy",null,null,null,"Code of Ethics policy"]
[null,{"$f":"IF('2. Questionnaire INS'!J97=\"x\",\"yes\",IF('2. Questionnaire INS'!K97=\"x\",\"no\",\"\"))","v":""},null,null,null,{"$f":"IF('2. Questionnaire INS'!J73=\"x\",\"yes\",IF('2. Questionnaire INS'!K73=\"x\",\"no\",\"\"))","v":""}]
[null,"Food Analysis"]
[null,"In-house laboratory",null,null,null,"Microbiology Lab",null,null,"Chemical Lab",null,null,null,"ISO 17025 accredited"]
[null,{"$f":"IF('2. Questionnaire INS'!J103=\"x\",\"yes\",IF('2. Questionnaire INS'!K103=\"x\",\"no\",\"\"))","v":""},null,null,null,{"$f":"IF('2. Questionnaire INS'!J108=\"x\",\"yes\",IF('2. Questionnaire INS'!K108=\"x\",\"no\",\"\"))","v":""},null,null,{"$f":"IF('2. Questionnaire INS'!J105=\"x\",\"yes\",IF('2. Questionnaire INS'!K105=\"x\",\"no\",\"\"))","v":""},null,null,null,{"$f":"IF('2. Questionnaire INS'!J112=\"x\",\"yes\",IF('2. Questionnaire INS'!K112=\"x\",\"no\",\"\"))","v":""}]
[null,"Commodities analyzed"]
[null,"Cereal (grain)","Cereal products (flours, fortified blended foods)",null,"Biscuits",null,"Pulses","Oil/Fat",null,"Can Products","Milk (dry Powder)",null,null,"Minerals and Vitamins","Sugar&Salt"]
[]
[null,"Subcontracted Company"]
[null,"Name",null,null,null,"Type (INS or LAB)",null,null,null,null,"Country"]
[null,{"$f":"'2. Questionnaire INS'!I120","v":0},null,null,null,{"$f":"IF('2. Questionnaire INS'!K120=\"x\",\"LAB\",IF('2. Questionnaire INS'!J120=\"x\",\"INS\",\"\"))","v":""},null,null,null,null,{"$f":"'2. Questionnaire INS'!M120","v":0}]
[null,{"$f":"'2. Questionnaire INS'!I121","v":0},null,null,null,{"$f":"IF('2. Questionnaire INS'!K122=\"x\",\"LAB\",IF('2. Questionnaire INS'!J122=\"x\",\"INS\",\"\"))","v":""},null,null,null,null,{"$f":"'2. Questionnaire INS'!M121","v":0}]
[null,{"$f":"'2. Questionnaire INS'!I122","v":0},null,null,null,{"$f":"IF('2. Questionnaire INS'!K120=\"x\",\"LAB\",IF('2. Questionnaire INS'!J120=\"x\",\"INS\",\"\"))","v":""},null,null,null,null,{"$f":"'2. Questionnaire INS'!M122","v":0}]
[null,{"$f":"'2. Questionnaire INS'!I123","v":0},null,null,null,{"$f":"IF('2. Questionnaire INS'!K126=\"x\",\"LAB\",IF('2. Questionnaire INS'!J126=\"x\",\"INS\",\"\"))","v":""},null,null,null,null,{"$f":"'2. Questionnaire INS'!M123","v":0}]
[null,"Further Comments from the corrector"]

{"sheet":"Score","index":3,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[21,11,21,13],[4,3,7,3],[6,0,6,2],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[6,5,7,5],[9,5,11,5]]}
[]
[null,null,null,null,null,null,null,"AND",null,"OR",null,"AND",null,"OR"]
[null,null,null,null,null,"Part","Criteria","A","B","C","D","A","B","C","D"]
[null,null,null,null,null,"Score",null,"[80;100]","[50;80[","[20;50[","[0;20[","[80;100]","[50;80[","[20;50[","[0;20["]
["Score summary",null,null,"Satisfactory answer per part"]
[null,null,null,null,null,"Food Inspection - Main Activity","Food Inspection",{"$f":"IF('2. Questionnaire INS'!M7>90,1,0)","v":0},null,{"$f":"IF('2. Questionnaire INS'!M7=0,1,0)","v":1},null,"100% Food Inspection",null,"Not specialized in Food Inspection"]
[null,null,null,null,null,"Factory Audit","GMP audit",{"$f":"IF('2. Questionnaire INS'!J26=\"X\",1,0)","v":0},null,null,null,"X"]
[null,"Points allocated","Points",null,null,null,"HACCP Audit",{"$f":"IF('2. Questionnaire INS'!J29=\"X\",1,0)","v":0},null,null,null,"X"]
["1.Inspection service",{"$f":"'2. Questionnaire INS'!Y5*C9","v":0},25,{"$f":"B9/C9","v":0}]
["2.  Certification",{"$f":"'2. Questionnaire INS'!Y37*C10","v":0},10,{"$f":"B10/C10","v":0},null,"Certifications","ISO 17020",{"$f":"IF('2. Questionnaire INS'!J43=\"x\",1,0)","v":0},null,null,null,"x"]
["3. Company details",{"$f":"'2. Questionnaire INS'!Y51*C11","v":0},5,0,null,null,"GAFTA",{"$f":"IF('2. Questionnaire INS'!J48=\"x\",1,0)","v":0},{"$f":"IF('2. Questionnaire INS'!J48=\"x\",1,0)","v":0},null,null,"x","X"]
["4. Staff and Training",{"$f":"'2. Questionnaire INS'!Y60*C12","v":0},10,0,null,null,"FOSFA",{"$f":"IF('2. Questionnaire INS'!J49=\"x\",1,0)","v":0},null,null,null,"X"]
["5. Equipment Available for testing purpose",{"$f":"'2. Questionnaire INS'!Y76*C13","v":0},20,0]
["6. Quality Management System",{"$f":"'2. Questionnaire INS'!Y96*C14","v":0},10,0]
["7. Food Analysis",{"$f":"IF('2. Questionnaire INS'!J115=\"x\",(0.5*'2. Questionnaire INS'!Y102+0.5*'2. Questionnaire INS'!Y117),'2. Questionnaire INS'!Y102)*C15","v":0},20,0,null,"Staff","Repartition Permanent staff/Total Staff (%)",{"$f":"IF('2. Questionnaire INS'!AA62>0.6,1,0)","v":0},{"$f":"IF('2. Questionnaire INS'!AA62>0.3,1,0)","v":0},{"$f":"IF('2. Questionnaire INS'!AA62<0.3,1,0)","v":1},null,">60%",">30%","<30%"]
["TOTAL",{"$f":"SUM(B9:B15)","v":0},{"$f":"SUM(C9:C15)","v":100},null,null,"Equipment ","GMO Test kit",null,null,null,null,"x"]
["GRADE",{"$f":"IF(H25=TRUE,\"A\",IF(I25=TRUE,\"B\",IF(J25=TRUE,\"C\",IF(K25=TRUE,\"D\",\"\"))))","v":"C"},null,null,null,"Equipment ","GMO Test kit",{"$f":"IF('2. Questionnaire INS'!J91=\"x\",1,0)","v":0},null,null,null,"X"]
[null,null,null,null,null,null,"Aflatoxin test kit",{"$f":"IF('2. Questionnaire INS'!J90=\"x\",1,0)","v":0},null,null,null,"X"]
[]
[]
[null,null,null,null,null,"Laboratory","The laboratory used is  ISO 17025  accredited with a scope of work related to Food analysis",{"$f":"IF('2. Questionnaire INS'!J112=\"x\",1,0)","v":0},null,null,null,"x"]
[]
[null,null,null,null,null,"Laboratory","The laboratory used has  been approved by WFP",{"$f":"IF(SUM('2. Questionnaire INS'!S120:S123)<1,1,0)","v":1},null,null,null,"x","x"]
[null,null,null,null,null,null,"TOTAL",{"$f":"IF(SUM(H6:H23)>10, 1, 0)","v":0},{"$f":"IF(SUM(I6:I23)>1, 1, 0)","v":0},{"$f":"IF(SUM(J6:J23)>0,1,0)","v":1},{"$f":"IF(SUM(K6:K23)>0,1,0)","v":0}]
[null,null,null,null,null,null,"Score",{"$f":"AND(H24=1,B16>80)","v":false},{"$f":"AND(I24=1,B16>50)","v":false},{"$f":"OR(J24=1,B16>20)","v":true},{"$f":"OR(K24=1,B16<20)","v":true}]
[null,null,null,null,null,null,null,{"$f":"IF(H25=TRUE,\"A\",\"-\")","v":"-"},{"$f":"IF(I25=TRUE,\"B\",\"-\")","v":"-"},{"$f":"IF(J25=TRUE,\"C\",\"-\")","v":"C"},{"$f":"IF(K25=TRUE,\"D\",\"-\")","v":"D"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J24>1,\"The company was graded C because, the vendor is not specialized in food inspection or because the data provided are not sufficient to include him in the WFP's approved list. Please contact the vendor if further clarifications are needed.\", \"\")","v":""},{"$f":"IF(K24>1,\"The company was graded D because  the information provided are not sufficient to include the vendor in WFP's approved list. Indeed, the score obtained at the questionnaire is inferior at 20%. Please contact the vendor to ask further clarifications\", \"\")","v":""}]

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