{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Application statistics","Gender statistics","Data","Country codes","Vejledning"],"not_rendered":{"charts":2,"images":6,"defined_names":3,"pivot_tables":17},"read":"whole","date_system":"1900"}

{"sheet":"Application statistics","index":0,"n_rows":22,"n_cols":20,"rows_kept":22}
[]
[]
["Sum of Applications",null,null,"Sum of Applicants",null,null,"Sum of Applicants",{"$nulls":3},"Sum of Applicants",{"$nulls":3},"Sum of Applicants","Total",null,null,"Sum of Applications"]
["Country (home)","Total",null,"Country (home)","Total",null,"Origin - sub-region","Total",null,null,"Origin - region","Total",null,null,"Total",{"v":1,"d":"100%"},null,null,"Programme","Total"]
[" ",1,null," ",1,null,"#N/A",1,null,null,"#N/A",1,{"$nulls":6}," ",1]
["Grand Total",1,null,"Grand Total",1,{"$nulls":13},"Grand Total",1]
[]
[]
[]
[{"$nulls":14},"Sum of Applications"]
[{"$nulls":14},"Recommendations","Total"]
[{"$nulls":14},3,1]
[{"$nulls":14},"Grand Total",1]
[]
[]
[]
[]
[]
[{"$nulls":14},"Sum of Applications"]
[{"$nulls":14},"Recommendations","Total"]
[{"$nulls":14},3,{"v":1,"d":"100%"}]
[{"$nulls":14},"Grand Total",{"v":1,"d":"100%"}]

{"sheet":"Gender statistics","index":1,"n_rows":48,"n_cols":13,"rows_kept":48}
[]
[]
["Sum of Applications","Gender",{"$nulls":3},"Sum of Applications","Gender"]
["Programme"," ","Grand Total",null,null,"Edu level prg"," ","Grand Total"]
[" ",1,1,null,null," ",1,1]
["Grand Total",1,1,null,null,"Grand Total",1,1]
[]
[]
[]
[]
[{"$nulls":5},"Sum of Applications","Gender"]
[{"$nulls":5},"Edu level prg"," ","Grand Total"]
[{"$nulls":5}," ",{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[{"$nulls":5},"Grand Total",{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[]
[]
[]
[{"$nulls":10},"Average of Age","Gender"]
[{"$nulls":5},"Average of Age","Gender",{"$nulls":3},"Edu level prg"," ","Grand Total"]
[{"$nulls":5},"Edu level prg"," ","Grand Total",null,null," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":5}," ",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Grand Total",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":5},"Grand Total",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Sum of Applications","Gender"]
["Company name"," ","Grand Total"]
[" ",{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
["Grand Total",{"v":1,"d":"100%"},{"v":1,"d":"100%"},null,null,"Sum of Applications","Gender"]
[{"$nulls":6}," ","Grand Total"]
[{"$nulls":5},"Total",1,1]
{"$rows_empty":8}
[{"$nulls":5},"Sum of Applications","Gender"]
[{"$nulls":6}," ","Grand Total"]
[{"$nulls":5},"Total",{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[]
[]
[]
[]
["Average of Age","Gender"]
["Programme"," ","Grand Total"]
[" ",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Grand Total",{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"Data","index":2,"n_rows":398,"n_cols":60,"rows_kept":398}
["AppCount","Origin - region","Origin - sub-region","Origin","Recommendations","Applications","Applicants","Age","Docs","Company name","Vacancy","Candidate ID","First name","Last name","Country (home)","E-mail","Country of citizenship","Gender","Date of birth","Edu name","Edu institution","Edu country","Edu status","Edu date","Acad supplementary information","Previous PhD enrolment institution and country","Enrol industrial PhD company app","Enrol hours/week and reason","AreaProj","Project title","Ref1 name","Ref1 position","Ref1 institution","Ref1 email","R1s","Ref2 name","Ref2 position","Ref2 institution","Ref2 email","R2s","Ref3 name","Ref3 position","Ref3 institution","Ref3 email","R3s","Academic background","Acad.Assessment (=AA for Managers)","Edu level prg","Edu grade point average prg","Enrol start prg","Enrol credit transfer (months) prg","Funding suggestion prg","Main supervisor prg","Co-supervisor1 name prg","Co-supervisor1 position prg","Co-supervisor1 institution prg","Co-supervisor1 email prg","Last workflow location","Last workflow status","UpdateCode"]
[{"$f":"IF($F2,COUNTIF($P:$P,$P2),0)","v":1},{"$f":"IF($F2,IFERROR(VLOOKUP($Q2,CountryCodes[],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF($F2,IFERROR(VLOOKUP($Q2,CountryCodes[],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($F2,IF(Q2=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":"Abroad"},{"$f":"IF($F2,IF(AI2=\"\",0,1)+IF(AN2=\"\",0,1)+IF(AS2=\"\",0,1),\"\")","v":3},{"$f":"IF(L2=\"\",0,1)","v":1},{"$f":"IF($F2,1/$A2,0)","v":1},{"$f":"IF($F2,IF(ISBLANK(S2),\"?\",DAYS360(S2,NOW())/360),\"\")","v":{"$error":"#VALUE!"}},{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L2&\"&CandidateUpdateCode=\"&BH2&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[0,{"$f":"IF($F3,VLOOKUP($Q3,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F3,VLOOKUP($Q3,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L3&\"&CandidateUpdateCode=\"&BH3&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F4,VLOOKUP($Q4,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F4,VLOOKUP($Q4,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F5,VLOOKUP($Q5,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F5,VLOOKUP($Q5,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F6,VLOOKUP($Q6,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F6,VLOOKUP($Q6,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F7,VLOOKUP($Q7,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F7,VLOOKUP($Q7,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F8,VLOOKUP($Q8,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F8,VLOOKUP($Q8,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F9,VLOOKUP($Q9,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F9,VLOOKUP($Q9,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F10,VLOOKUP($Q10,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F10,VLOOKUP($Q10,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F11,VLOOKUP($Q11,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F11,VLOOKUP($Q11,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F12,VLOOKUP($Q12,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F12,VLOOKUP($Q12,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F13,VLOOKUP($Q13,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F13,VLOOKUP($Q13,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F14,VLOOKUP($Q14,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F14,VLOOKUP($Q14,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F15,VLOOKUP($Q15,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F15,VLOOKUP($Q15,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F16,VLOOKUP($Q16,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F16,VLOOKUP($Q16,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F17,VLOOKUP($Q17,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F17,VLOOKUP($Q17,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F18,VLOOKUP($Q18,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F18,VLOOKUP($Q18,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F19,VLOOKUP($Q19,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F19,VLOOKUP($Q19,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F20,VLOOKUP($Q20,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F20,VLOOKUP($Q20,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F21,VLOOKUP($Q21,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F21,VLOOKUP($Q21,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F22,VLOOKUP($Q22,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F22,VLOOKUP($Q22,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F23,VLOOKUP($Q23,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F23,VLOOKUP($Q23,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F24,VLOOKUP($Q24,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F24,VLOOKUP($Q24,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F25,VLOOKUP($Q25,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F25,VLOOKUP($Q25,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F26,VLOOKUP($Q26,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F26,VLOOKUP($Q26,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F27,VLOOKUP($Q27,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F27,VLOOKUP($Q27,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F28,VLOOKUP($Q28,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F28,VLOOKUP($Q28,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F29,VLOOKUP($Q29,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F29,VLOOKUP($Q29,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F30,VLOOKUP($Q30,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F30,VLOOKUP($Q30,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F31,VLOOKUP($Q31,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F31,VLOOKUP($Q31,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F32,VLOOKUP($Q32,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F32,VLOOKUP($Q32,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F33,VLOOKUP($Q33,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F33,VLOOKUP($Q33,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F34,VLOOKUP($Q34,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F34,VLOOKUP($Q34,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F35,VLOOKUP($Q35,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F35,VLOOKUP($Q35,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F36,VLOOKUP($Q36,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F36,VLOOKUP($Q36,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F37,VLOOKUP($Q37,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F37,VLOOKUP($Q37,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F38,VLOOKUP($Q38,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F38,VLOOKUP($Q38,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F39,VLOOKUP($Q39,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F39,VLOOKUP($Q39,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F40,VLOOKUP($Q40,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F40,VLOOKUP($Q40,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F41,VLOOKUP($Q41,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F41,VLOOKUP($Q41,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F42,VLOOKUP($Q42,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F42,VLOOKUP($Q42,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F43,VLOOKUP($Q43,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F43,VLOOKUP($Q43,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F44,VLOOKUP($Q44,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F44,VLOOKUP($Q44,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F45,VLOOKUP($Q45,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F45,VLOOKUP($Q45,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F46,VLOOKUP($Q46,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F46,VLOOKUP($Q46,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F47,VLOOKUP($Q47,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F47,VLOOKUP($Q47,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F48,VLOOKUP($Q48,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F48,VLOOKUP($Q48,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F49,VLOOKUP($Q49,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F49,VLOOKUP($Q49,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F50,VLOOKUP($Q50,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F50,VLOOKUP($Q50,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F51,VLOOKUP($Q51,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F51,VLOOKUP($Q51,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F52,VLOOKUP($Q52,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F52,VLOOKUP($Q52,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F53,VLOOKUP($Q53,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F53,VLOOKUP($Q53,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F54,VLOOKUP($Q54,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F54,VLOOKUP($Q54,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F55,VLOOKUP($Q55,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F55,VLOOKUP($Q55,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F56,VLOOKUP($Q56,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F56,VLOOKUP($Q56,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F57,VLOOKUP($Q57,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F57,VLOOKUP($Q57,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F58,VLOOKUP($Q58,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F58,VLOOKUP($Q58,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F59,VLOOKUP($Q59,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F59,VLOOKUP($Q59,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F60,VLOOKUP($Q60,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F60,VLOOKUP($Q60,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F61,VLOOKUP($Q61,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F61,VLOOKUP($Q61,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F62,VLOOKUP($Q62,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F62,VLOOKUP($Q62,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F63,VLOOKUP($Q63,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F63,VLOOKUP($Q63,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F64,VLOOKUP($Q64,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F64,VLOOKUP($Q64,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F64,IF(Q64=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F64,IF(AI64=\"\",0,1)+IF(AN64=\"\",0,1)+IF(AS64=\"\",0,1),\"\")","v":""},{"$f":"IF(L64=\"\",0,1)","v":0},{"$f":"IF($F64,1/$A64,0)","v":0},{"$f":"IF($F64,IF(ISBLANK(S64),\"?\",DAYS360(S64,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F65,VLOOKUP($Q65,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F65,VLOOKUP($Q65,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F66,COUNTIF($P:$P,$P66),0)","v":0},{"$f":"IF($F66,VLOOKUP($Q66,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F66,VLOOKUP($Q66,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F67,VLOOKUP($Q67,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F67,VLOOKUP($Q67,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L67&\"&CandidateUpdateCode=\"&BH67&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F68,VLOOKUP($Q68,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F68,VLOOKUP($Q68,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F69,VLOOKUP($Q69,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F69,VLOOKUP($Q69,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F70,VLOOKUP($Q70,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F70,VLOOKUP($Q70,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F71,VLOOKUP($Q71,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F71,VLOOKUP($Q71,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F72,VLOOKUP($Q72,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F72,VLOOKUP($Q72,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F73,VLOOKUP($Q73,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F73,VLOOKUP($Q73,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F74,VLOOKUP($Q74,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F74,VLOOKUP($Q74,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F75,VLOOKUP($Q75,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F75,VLOOKUP($Q75,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F76,VLOOKUP($Q76,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F76,VLOOKUP($Q76,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F77,VLOOKUP($Q77,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F77,VLOOKUP($Q77,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F78,VLOOKUP($Q78,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F78,VLOOKUP($Q78,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F79,VLOOKUP($Q79,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F79,VLOOKUP($Q79,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F80,VLOOKUP($Q80,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F80,VLOOKUP($Q80,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F81,VLOOKUP($Q81,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F81,VLOOKUP($Q81,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F82,VLOOKUP($Q82,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F82,VLOOKUP($Q82,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F83,VLOOKUP($Q83,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F83,VLOOKUP($Q83,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F84,VLOOKUP($Q84,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F84,VLOOKUP($Q84,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F85,VLOOKUP($Q85,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F85,VLOOKUP($Q85,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F86,VLOOKUP($Q86,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F86,VLOOKUP($Q86,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F87,VLOOKUP($Q87,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F87,VLOOKUP($Q87,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F88,VLOOKUP($Q88,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F88,VLOOKUP($Q88,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F89,VLOOKUP($Q89,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F89,VLOOKUP($Q89,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F90,VLOOKUP($Q90,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F90,VLOOKUP($Q90,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F91,VLOOKUP($Q91,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F91,VLOOKUP($Q91,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F92,VLOOKUP($Q92,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F92,VLOOKUP($Q92,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F93,VLOOKUP($Q93,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F93,VLOOKUP($Q93,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F94,VLOOKUP($Q94,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F94,VLOOKUP($Q94,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F95,VLOOKUP($Q95,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F95,VLOOKUP($Q95,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F96,VLOOKUP($Q96,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F96,VLOOKUP($Q96,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F97,VLOOKUP($Q97,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F97,VLOOKUP($Q97,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F98,VLOOKUP($Q98,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F98,VLOOKUP($Q98,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F99,VLOOKUP($Q99,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F99,VLOOKUP($Q99,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F100,VLOOKUP($Q100,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F100,VLOOKUP($Q100,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F101,VLOOKUP($Q101,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F101,VLOOKUP($Q101,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F102,VLOOKUP($Q102,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F102,VLOOKUP($Q102,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F103,VLOOKUP($Q103,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F103,VLOOKUP($Q103,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F104,VLOOKUP($Q104,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F104,VLOOKUP($Q104,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F105,VLOOKUP($Q105,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F105,VLOOKUP($Q105,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F106,VLOOKUP($Q106,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F106,VLOOKUP($Q106,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F107,VLOOKUP($Q107,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F107,VLOOKUP($Q107,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F108,VLOOKUP($Q108,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F108,VLOOKUP($Q108,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F109,VLOOKUP($Q109,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F109,VLOOKUP($Q109,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F110,VLOOKUP($Q110,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F110,VLOOKUP($Q110,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F111,VLOOKUP($Q111,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F111,VLOOKUP($Q111,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F112,VLOOKUP($Q112,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F112,VLOOKUP($Q112,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F113,VLOOKUP($Q113,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F113,VLOOKUP($Q113,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F114,VLOOKUP($Q114,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F114,VLOOKUP($Q114,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F115,VLOOKUP($Q115,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F115,VLOOKUP($Q115,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F116,VLOOKUP($Q116,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F116,VLOOKUP($Q116,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F117,VLOOKUP($Q117,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F117,VLOOKUP($Q117,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F118,VLOOKUP($Q118,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F118,VLOOKUP($Q118,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F119,VLOOKUP($Q119,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F119,VLOOKUP($Q119,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F120,VLOOKUP($Q120,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F120,VLOOKUP($Q120,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F121,VLOOKUP($Q121,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F121,VLOOKUP($Q121,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F122,VLOOKUP($Q122,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F122,VLOOKUP($Q122,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F123,VLOOKUP($Q123,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F123,VLOOKUP($Q123,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F124,VLOOKUP($Q124,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F124,VLOOKUP($Q124,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F125,VLOOKUP($Q125,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F125,VLOOKUP($Q125,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F126,VLOOKUP($Q126,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F126,VLOOKUP($Q126,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F127,VLOOKUP($Q127,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F127,VLOOKUP($Q127,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F128,VLOOKUP($Q128,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F128,VLOOKUP($Q128,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F128,IF(Q128=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F128,IF(AI128=\"\",0,1)+IF(AN128=\"\",0,1)+IF(AS128=\"\",0,1),\"\")","v":""},{"$f":"IF(L128=\"\",0,1)","v":0},{"$f":"IF($F128,1/$A128,0)","v":0},{"$f":"IF($F128,IF(ISBLANK(S128),\"?\",DAYS360(S128,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F129,VLOOKUP($Q129,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F129,VLOOKUP($Q129,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F130,COUNTIF($P:$P,$P130),0)","v":0},{"$f":"IF($F130,VLOOKUP($Q130,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F130,VLOOKUP($Q130,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F131,VLOOKUP($Q131,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F131,VLOOKUP($Q131,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L131&\"&CandidateUpdateCode=\"&BH131&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F132,VLOOKUP($Q132,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F132,VLOOKUP($Q132,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F133,VLOOKUP($Q133,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F133,VLOOKUP($Q133,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F134,VLOOKUP($Q134,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F134,VLOOKUP($Q134,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F135,VLOOKUP($Q135,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F135,VLOOKUP($Q135,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F136,VLOOKUP($Q136,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F136,VLOOKUP($Q136,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F137,VLOOKUP($Q137,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F137,VLOOKUP($Q137,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F138,VLOOKUP($Q138,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F138,VLOOKUP($Q138,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F139,VLOOKUP($Q139,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F139,VLOOKUP($Q139,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F140,VLOOKUP($Q140,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F140,VLOOKUP($Q140,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F141,VLOOKUP($Q141,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F141,VLOOKUP($Q141,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F142,VLOOKUP($Q142,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F142,VLOOKUP($Q142,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F143,VLOOKUP($Q143,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F143,VLOOKUP($Q143,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F144,VLOOKUP($Q144,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F144,VLOOKUP($Q144,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F145,VLOOKUP($Q145,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F145,VLOOKUP($Q145,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F146,VLOOKUP($Q146,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F146,VLOOKUP($Q146,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F147,VLOOKUP($Q147,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F147,VLOOKUP($Q147,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F148,VLOOKUP($Q148,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F148,VLOOKUP($Q148,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F149,VLOOKUP($Q149,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F149,VLOOKUP($Q149,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F150,VLOOKUP($Q150,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F150,VLOOKUP($Q150,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F151,VLOOKUP($Q151,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F151,VLOOKUP($Q151,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F152,VLOOKUP($Q152,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F152,VLOOKUP($Q152,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F153,VLOOKUP($Q153,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F153,VLOOKUP($Q153,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F154,VLOOKUP($Q154,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F154,VLOOKUP($Q154,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F155,VLOOKUP($Q155,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F155,VLOOKUP($Q155,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F156,VLOOKUP($Q156,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F156,VLOOKUP($Q156,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F157,VLOOKUP($Q157,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F157,VLOOKUP($Q157,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F158,VLOOKUP($Q158,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F158,VLOOKUP($Q158,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F159,VLOOKUP($Q159,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F159,VLOOKUP($Q159,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F160,VLOOKUP($Q160,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F160,VLOOKUP($Q160,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F161,VLOOKUP($Q161,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F161,VLOOKUP($Q161,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F162,VLOOKUP($Q162,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F162,VLOOKUP($Q162,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F163,VLOOKUP($Q163,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F163,VLOOKUP($Q163,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F164,VLOOKUP($Q164,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F164,VLOOKUP($Q164,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F165,VLOOKUP($Q165,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F165,VLOOKUP($Q165,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F166,VLOOKUP($Q166,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F166,VLOOKUP($Q166,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F167,VLOOKUP($Q167,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F167,VLOOKUP($Q167,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F168,VLOOKUP($Q168,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F168,VLOOKUP($Q168,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F169,VLOOKUP($Q169,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F169,VLOOKUP($Q169,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F170,VLOOKUP($Q170,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F170,VLOOKUP($Q170,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F171,VLOOKUP($Q171,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F171,VLOOKUP($Q171,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F172,VLOOKUP($Q172,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F172,VLOOKUP($Q172,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F173,VLOOKUP($Q173,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F173,VLOOKUP($Q173,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F174,VLOOKUP($Q174,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F174,VLOOKUP($Q174,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F175,VLOOKUP($Q175,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F175,VLOOKUP($Q175,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F176,VLOOKUP($Q176,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F176,VLOOKUP($Q176,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F177,VLOOKUP($Q177,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F177,VLOOKUP($Q177,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F178,VLOOKUP($Q178,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F178,VLOOKUP($Q178,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F179,VLOOKUP($Q179,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F179,VLOOKUP($Q179,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F180,VLOOKUP($Q180,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F180,VLOOKUP($Q180,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F181,VLOOKUP($Q181,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F181,VLOOKUP($Q181,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F182,VLOOKUP($Q182,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F182,VLOOKUP($Q182,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F183,VLOOKUP($Q183,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F183,VLOOKUP($Q183,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F184,VLOOKUP($Q184,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F184,VLOOKUP($Q184,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F185,VLOOKUP($Q185,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F185,VLOOKUP($Q185,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F186,VLOOKUP($Q186,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F186,VLOOKUP($Q186,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F187,VLOOKUP($Q187,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F187,VLOOKUP($Q187,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F188,VLOOKUP($Q188,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F188,VLOOKUP($Q188,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F189,VLOOKUP($Q189,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F189,VLOOKUP($Q189,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F190,VLOOKUP($Q190,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F190,VLOOKUP($Q190,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F191,VLOOKUP($Q191,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F191,VLOOKUP($Q191,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F192,VLOOKUP($Q192,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F192,VLOOKUP($Q192,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F192,IF(Q192=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F192,IF(AI192=\"\",0,1)+IF(AN192=\"\",0,1)+IF(AS192=\"\",0,1),\"\")","v":""},{"$f":"IF(L192=\"\",0,1)","v":0},{"$f":"IF($F192,1/$A192,0)","v":0},{"$f":"IF($F192,IF(ISBLANK(S192),\"?\",DAYS360(S192,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F193,VLOOKUP($Q193,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F193,VLOOKUP($Q193,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F194,COUNTIF($P:$P,$P194),0)","v":0},{"$f":"IF($F194,VLOOKUP($Q194,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F194,VLOOKUP($Q194,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F195,VLOOKUP($Q195,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F195,VLOOKUP($Q195,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L195&\"&CandidateUpdateCode=\"&BH195&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F196,VLOOKUP($Q196,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F196,VLOOKUP($Q196,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F197,VLOOKUP($Q197,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F197,VLOOKUP($Q197,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F198,VLOOKUP($Q198,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F198,VLOOKUP($Q198,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F199,VLOOKUP($Q199,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F199,VLOOKUP($Q199,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F200,VLOOKUP($Q200,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F200,VLOOKUP($Q200,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F201,VLOOKUP($Q201,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F201,VLOOKUP($Q201,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F202,VLOOKUP($Q202,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F202,VLOOKUP($Q202,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F203,VLOOKUP($Q203,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F203,VLOOKUP($Q203,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F204,VLOOKUP($Q204,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F204,VLOOKUP($Q204,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F205,VLOOKUP($Q205,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F205,VLOOKUP($Q205,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F206,VLOOKUP($Q206,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F206,VLOOKUP($Q206,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F207,VLOOKUP($Q207,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F207,VLOOKUP($Q207,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F208,VLOOKUP($Q208,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F208,VLOOKUP($Q208,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F209,VLOOKUP($Q209,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F209,VLOOKUP($Q209,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F210,VLOOKUP($Q210,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F210,VLOOKUP($Q210,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F211,VLOOKUP($Q211,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F211,VLOOKUP($Q211,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F212,VLOOKUP($Q212,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F212,VLOOKUP($Q212,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F213,VLOOKUP($Q213,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F213,VLOOKUP($Q213,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F214,VLOOKUP($Q214,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F214,VLOOKUP($Q214,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F215,VLOOKUP($Q215,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F215,VLOOKUP($Q215,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F216,VLOOKUP($Q216,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F216,VLOOKUP($Q216,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F217,VLOOKUP($Q217,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F217,VLOOKUP($Q217,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F218,VLOOKUP($Q218,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F218,VLOOKUP($Q218,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F219,VLOOKUP($Q219,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F219,VLOOKUP($Q219,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F220,VLOOKUP($Q220,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F220,VLOOKUP($Q220,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F221,VLOOKUP($Q221,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F221,VLOOKUP($Q221,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F222,VLOOKUP($Q222,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F222,VLOOKUP($Q222,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F223,VLOOKUP($Q223,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F223,VLOOKUP($Q223,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F224,VLOOKUP($Q224,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F224,VLOOKUP($Q224,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F225,VLOOKUP($Q225,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F225,VLOOKUP($Q225,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F226,VLOOKUP($Q226,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F226,VLOOKUP($Q226,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F227,VLOOKUP($Q227,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F227,VLOOKUP($Q227,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F228,VLOOKUP($Q228,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F228,VLOOKUP($Q228,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F229,VLOOKUP($Q229,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F229,VLOOKUP($Q229,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F230,VLOOKUP($Q230,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F230,VLOOKUP($Q230,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F231,VLOOKUP($Q231,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F231,VLOOKUP($Q231,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F232,VLOOKUP($Q232,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F232,VLOOKUP($Q232,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F233,VLOOKUP($Q233,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F233,VLOOKUP($Q233,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F234,VLOOKUP($Q234,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F234,VLOOKUP($Q234,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F235,VLOOKUP($Q235,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F235,VLOOKUP($Q235,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F236,VLOOKUP($Q236,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F236,VLOOKUP($Q236,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F237,VLOOKUP($Q237,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F237,VLOOKUP($Q237,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F238,VLOOKUP($Q238,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F238,VLOOKUP($Q238,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F239,VLOOKUP($Q239,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F239,VLOOKUP($Q239,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F240,VLOOKUP($Q240,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F240,VLOOKUP($Q240,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F241,VLOOKUP($Q241,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F241,VLOOKUP($Q241,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F242,VLOOKUP($Q242,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F242,VLOOKUP($Q242,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F243,VLOOKUP($Q243,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F243,VLOOKUP($Q243,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F244,VLOOKUP($Q244,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F244,VLOOKUP($Q244,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F245,VLOOKUP($Q245,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F245,VLOOKUP($Q245,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F246,VLOOKUP($Q246,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F246,VLOOKUP($Q246,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F247,VLOOKUP($Q247,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F247,VLOOKUP($Q247,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F248,VLOOKUP($Q248,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F248,VLOOKUP($Q248,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F249,VLOOKUP($Q249,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F249,VLOOKUP($Q249,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F250,VLOOKUP($Q250,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F250,VLOOKUP($Q250,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F251,VLOOKUP($Q251,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F251,VLOOKUP($Q251,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F252,VLOOKUP($Q252,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F252,VLOOKUP($Q252,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F253,VLOOKUP($Q253,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F253,VLOOKUP($Q253,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F254,VLOOKUP($Q254,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F254,VLOOKUP($Q254,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F255,VLOOKUP($Q255,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F255,VLOOKUP($Q255,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F256,VLOOKUP($Q256,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F256,VLOOKUP($Q256,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F256,IF(Q256=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F256,IF(AI256=\"\",0,1)+IF(AN256=\"\",0,1)+IF(AS256=\"\",0,1),\"\")","v":""},{"$f":"IF(L256=\"\",0,1)","v":0},{"$f":"IF($F256,1/$A256,0)","v":0},{"$f":"IF($F256,IF(ISBLANK(S256),\"?\",DAYS360(S256,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F257,VLOOKUP($Q257,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F257,VLOOKUP($Q257,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F258,COUNTIF($P:$P,$P258),0)","v":0},{"$f":"IF($F258,VLOOKUP($Q258,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F258,VLOOKUP($Q258,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F259,VLOOKUP($Q259,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F259,VLOOKUP($Q259,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L259&\"&CandidateUpdateCode=\"&BH259&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F260,VLOOKUP($Q260,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F260,VLOOKUP($Q260,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F261,VLOOKUP($Q261,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F261,VLOOKUP($Q261,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F262,VLOOKUP($Q262,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F262,VLOOKUP($Q262,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F263,VLOOKUP($Q263,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F263,VLOOKUP($Q263,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F264,VLOOKUP($Q264,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F264,VLOOKUP($Q264,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F265,VLOOKUP($Q265,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F265,VLOOKUP($Q265,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F266,VLOOKUP($Q266,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F266,VLOOKUP($Q266,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F267,VLOOKUP($Q267,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F267,VLOOKUP($Q267,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F268,VLOOKUP($Q268,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F268,VLOOKUP($Q268,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F269,VLOOKUP($Q269,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F269,VLOOKUP($Q269,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F270,VLOOKUP($Q270,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F270,VLOOKUP($Q270,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F271,VLOOKUP($Q271,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F271,VLOOKUP($Q271,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F272,VLOOKUP($Q272,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F272,VLOOKUP($Q272,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F273,VLOOKUP($Q273,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F273,VLOOKUP($Q273,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F274,VLOOKUP($Q274,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F274,VLOOKUP($Q274,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F275,VLOOKUP($Q275,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F275,VLOOKUP($Q275,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F276,VLOOKUP($Q276,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F276,VLOOKUP($Q276,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F277,VLOOKUP($Q277,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F277,VLOOKUP($Q277,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F278,VLOOKUP($Q278,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F278,VLOOKUP($Q278,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F279,VLOOKUP($Q279,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F279,VLOOKUP($Q279,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F280,VLOOKUP($Q280,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F280,VLOOKUP($Q280,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F281,VLOOKUP($Q281,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F281,VLOOKUP($Q281,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F282,VLOOKUP($Q282,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F282,VLOOKUP($Q282,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F283,VLOOKUP($Q283,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F283,VLOOKUP($Q283,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F284,VLOOKUP($Q284,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F284,VLOOKUP($Q284,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F285,VLOOKUP($Q285,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F285,VLOOKUP($Q285,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F286,VLOOKUP($Q286,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F286,VLOOKUP($Q286,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F287,VLOOKUP($Q287,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F287,VLOOKUP($Q287,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F288,VLOOKUP($Q288,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F288,VLOOKUP($Q288,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F289,VLOOKUP($Q289,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F289,VLOOKUP($Q289,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F290,VLOOKUP($Q290,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F290,VLOOKUP($Q290,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F291,VLOOKUP($Q291,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F291,VLOOKUP($Q291,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F292,VLOOKUP($Q292,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F292,VLOOKUP($Q292,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F293,VLOOKUP($Q293,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F293,VLOOKUP($Q293,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F294,VLOOKUP($Q294,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F294,VLOOKUP($Q294,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F295,VLOOKUP($Q295,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F295,VLOOKUP($Q295,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F296,VLOOKUP($Q296,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F296,VLOOKUP($Q296,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F297,VLOOKUP($Q297,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F297,VLOOKUP($Q297,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F298,VLOOKUP($Q298,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F298,VLOOKUP($Q298,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F299,VLOOKUP($Q299,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F299,VLOOKUP($Q299,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F300,VLOOKUP($Q300,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F300,VLOOKUP($Q300,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F301,VLOOKUP($Q301,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F301,VLOOKUP($Q301,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F302,VLOOKUP($Q302,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F302,VLOOKUP($Q302,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F303,VLOOKUP($Q303,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F303,VLOOKUP($Q303,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F304,VLOOKUP($Q304,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F304,VLOOKUP($Q304,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F305,VLOOKUP($Q305,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F305,VLOOKUP($Q305,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F306,VLOOKUP($Q306,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F306,VLOOKUP($Q306,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F307,VLOOKUP($Q307,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F307,VLOOKUP($Q307,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F308,VLOOKUP($Q308,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F308,VLOOKUP($Q308,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F309,VLOOKUP($Q309,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F309,VLOOKUP($Q309,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F310,VLOOKUP($Q310,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F310,VLOOKUP($Q310,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F311,VLOOKUP($Q311,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F311,VLOOKUP($Q311,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F312,VLOOKUP($Q312,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F312,VLOOKUP($Q312,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F313,VLOOKUP($Q313,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F313,VLOOKUP($Q313,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F314,VLOOKUP($Q314,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F314,VLOOKUP($Q314,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F315,VLOOKUP($Q315,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F315,VLOOKUP($Q315,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F316,VLOOKUP($Q316,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F316,VLOOKUP($Q316,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F317,VLOOKUP($Q317,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F317,VLOOKUP($Q317,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F318,VLOOKUP($Q318,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F318,VLOOKUP($Q318,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F319,VLOOKUP($Q319,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F319,VLOOKUP($Q319,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F320,VLOOKUP($Q320,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F320,VLOOKUP($Q320,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F320,IF(Q320=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F320,IF(AI320=\"\",0,1)+IF(AN320=\"\",0,1)+IF(AS320=\"\",0,1),\"\")","v":""},{"$f":"IF(L320=\"\",0,1)","v":0},{"$f":"IF($F320,1/$A320,0)","v":0},{"$f":"IF($F320,IF(ISBLANK(S320),\"?\",DAYS360(S320,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F321,VLOOKUP($Q321,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F321,VLOOKUP($Q321,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F322,COUNTIF($P:$P,$P322),0)","v":0},{"$f":"IF($F322,VLOOKUP($Q322,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F322,VLOOKUP($Q322,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F323,VLOOKUP($Q323,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F323,VLOOKUP($Q323,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L323&\"&CandidateUpdateCode=\"&BH323&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F324,VLOOKUP($Q324,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F324,VLOOKUP($Q324,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F325,VLOOKUP($Q325,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F325,VLOOKUP($Q325,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F326,VLOOKUP($Q326,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F326,VLOOKUP($Q326,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F327,VLOOKUP($Q327,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F327,VLOOKUP($Q327,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F328,VLOOKUP($Q328,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F328,VLOOKUP($Q328,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F329,VLOOKUP($Q329,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F329,VLOOKUP($Q329,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F330,VLOOKUP($Q330,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F330,VLOOKUP($Q330,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F331,VLOOKUP($Q331,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F331,VLOOKUP($Q331,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F332,VLOOKUP($Q332,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F332,VLOOKUP($Q332,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F333,VLOOKUP($Q333,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F333,VLOOKUP($Q333,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F334,VLOOKUP($Q334,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F334,VLOOKUP($Q334,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F335,VLOOKUP($Q335,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F335,VLOOKUP($Q335,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F336,VLOOKUP($Q336,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F336,VLOOKUP($Q336,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F337,VLOOKUP($Q337,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F337,VLOOKUP($Q337,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F338,VLOOKUP($Q338,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F338,VLOOKUP($Q338,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F339,VLOOKUP($Q339,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F339,VLOOKUP($Q339,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F340,VLOOKUP($Q340,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F340,VLOOKUP($Q340,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F341,VLOOKUP($Q341,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F341,VLOOKUP($Q341,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F342,VLOOKUP($Q342,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F342,VLOOKUP($Q342,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F343,VLOOKUP($Q343,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F343,VLOOKUP($Q343,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F344,VLOOKUP($Q344,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F344,VLOOKUP($Q344,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F345,VLOOKUP($Q345,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F345,VLOOKUP($Q345,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F346,VLOOKUP($Q346,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F346,VLOOKUP($Q346,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F347,VLOOKUP($Q347,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F347,VLOOKUP($Q347,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F348,VLOOKUP($Q348,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F348,VLOOKUP($Q348,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F349,VLOOKUP($Q349,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F349,VLOOKUP($Q349,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F350,VLOOKUP($Q350,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F350,VLOOKUP($Q350,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F351,VLOOKUP($Q351,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F351,VLOOKUP($Q351,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F352,VLOOKUP($Q352,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F352,VLOOKUP($Q352,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F353,VLOOKUP($Q353,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F353,VLOOKUP($Q353,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F354,VLOOKUP($Q354,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F354,VLOOKUP($Q354,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F355,VLOOKUP($Q355,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F355,VLOOKUP($Q355,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F356,VLOOKUP($Q356,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F356,VLOOKUP($Q356,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F357,VLOOKUP($Q357,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F357,VLOOKUP($Q357,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F358,VLOOKUP($Q358,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F358,VLOOKUP($Q358,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F359,VLOOKUP($Q359,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F359,VLOOKUP($Q359,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F360,VLOOKUP($Q360,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F360,VLOOKUP($Q360,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F361,VLOOKUP($Q361,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F361,VLOOKUP($Q361,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F362,VLOOKUP($Q362,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F362,VLOOKUP($Q362,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F363,VLOOKUP($Q363,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F363,VLOOKUP($Q363,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F364,VLOOKUP($Q364,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F364,VLOOKUP($Q364,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F365,VLOOKUP($Q365,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F365,VLOOKUP($Q365,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F366,VLOOKUP($Q366,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F366,VLOOKUP($Q366,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F367,VLOOKUP($Q367,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F367,VLOOKUP($Q367,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F368,VLOOKUP($Q368,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F368,VLOOKUP($Q368,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F369,VLOOKUP($Q369,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F369,VLOOKUP($Q369,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F370,VLOOKUP($Q370,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F370,VLOOKUP($Q370,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F371,VLOOKUP($Q371,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F371,VLOOKUP($Q371,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F372,VLOOKUP($Q372,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F372,VLOOKUP($Q372,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F373,VLOOKUP($Q373,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F373,VLOOKUP($Q373,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F374,VLOOKUP($Q374,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F374,VLOOKUP($Q374,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F375,VLOOKUP($Q375,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F375,VLOOKUP($Q375,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F376,VLOOKUP($Q376,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F376,VLOOKUP($Q376,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F377,VLOOKUP($Q377,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F377,VLOOKUP($Q377,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F378,VLOOKUP($Q378,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F378,VLOOKUP($Q378,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F379,VLOOKUP($Q379,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F379,VLOOKUP($Q379,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F380,VLOOKUP($Q380,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F380,VLOOKUP($Q380,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F381,VLOOKUP($Q381,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F381,VLOOKUP($Q381,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F382,VLOOKUP($Q382,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F382,VLOOKUP($Q382,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F383,VLOOKUP($Q383,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F383,VLOOKUP($Q383,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F384,VLOOKUP($Q384,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F384,VLOOKUP($Q384,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($F384,IF(Q384=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($F384,IF(AI384=\"\",0,1)+IF(AN384=\"\",0,1)+IF(AS384=\"\",0,1),\"\")","v":""},{"$f":"IF(L384=\"\",0,1)","v":0},{"$f":"IF($F384,1/$A384,0)","v":0},{"$f":"IF($F384,IF(ISBLANK(S384),\"?\",DAYS360(S384,NOW())/360),\"\")","v":""},"Docs"]
[0,{"$f":"IF($F385,VLOOKUP($Q385,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F385,VLOOKUP($Q385,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($F386,COUNTIF($P:$P,$P386),0)","v":0},{"$f":"IF($F386,VLOOKUP($Q386,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F386,VLOOKUP($Q386,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F387,VLOOKUP($Q387,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F387,VLOOKUP($Q387,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&L387&\"&CandidateUpdateCode=\"&BH387&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,{"$f":"IF($F388,VLOOKUP($Q388,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F388,VLOOKUP($Q388,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F389,VLOOKUP($Q389,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F389,VLOOKUP($Q389,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F390,VLOOKUP($Q390,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F390,VLOOKUP($Q390,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F391,VLOOKUP($Q391,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F391,VLOOKUP($Q391,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F392,VLOOKUP($Q392,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F392,VLOOKUP($Q392,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F393,VLOOKUP($Q393,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F393,VLOOKUP($Q393,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F394,VLOOKUP($Q394,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F394,VLOOKUP($Q394,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F395,VLOOKUP($Q395,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F395,VLOOKUP($Q395,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F396,VLOOKUP($Q396,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F396,VLOOKUP($Q396,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F397,VLOOKUP($Q397,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F397,VLOOKUP($Q397,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($F398,VLOOKUP($Q398,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($F398,VLOOKUP($Q398,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]

{"sheet":"Country codes","index":3,"n_rows":254,"n_cols":5,"rows_kept":254}
["Country (ARH3)","ISO2","Land","Region","Sub-region"]
["Aaland islands","ax","Ålandsøerne","Europe","Northern Europe"]
["Afghanistan","af","Afghanistan","Asia","South-central Asia"]
["Albania","al","Albanien","Europe","Southern Europe"]
["Algeria","dz","Algeriet","Africa","Northern Africa"]
["American Samoa","as","Samoa, Amerikansk Samoa","Oceania","Polynesia"]
["Andorra","ad","Andorra","Europe","Southern Europe"]
["Angola","ao","Angola","Africa","Middle Africa"]
["Anguilla","ai","Anguilla","Latin America and the Caribbean","Caribbean"]
["Antarctica","aq","Antarktis","Antarctic","Antarctic"]
["Antigua and Barbuda","ag","Antigua og Barbuda","Latin America and the Caribbean","Caribbean"]
["Argentina","ar","Argentina","Latin America and the Caribbean","South America"]
["Armenia","am","Armenien","Asia","Western Asia"]
["Aruba","aw","Aruba","Latin America and the Caribbean","Caribbean"]
["Australia","au","Australien","Oceania","Australia and New Zealand"]
["Austria","at","Østrig","Europe","Western Europe"]
["Azerbaijan","az","Aserbajdsjan, Azerbajdjan","Asia","Western Asia"]
["Bahamas","bs","Bahamas","Latin America and the Caribbean","Caribbean"]
["Bahrain","bh","Bahrain","Asia","Western Asia"]
["Bangladesh","bd","Bangladesh","Asia","South-central Asia"]
["Barbados","bb","Barbados","Latin America and the Caribbean","Caribbean"]
["Belarus","by","Belarus (Hviderusland)","Europe","Eastern Europe"]
["Belgium","be","Belgien","Europe","Western Europe"]
["Belize","bz","Belize","Latin America and the Caribbean","Central America"]
["Benin","bj","Benin","Africa","Western Africa"]
["Bermuda","bm","Bermuda","Northern America","Northern America"]
["Bhutan","bt","Bhutan","Asia","South-central Asia"]
["Bolivia","bo","Bolivia","Latin America and the Caribbean","South America"]
["Bonaire, Sint Eustatius and Saba","bq","Bonaire, Sint Eustatius og Saba","Latin America and the Caribbean","Caribbean"]
["Bosnia and Herzegovina","ba","Bosnien-Herzegovina","Europe","Southern Europe"]
["Botswana","bw","Botswana","Africa","Southern Africa"]
["Bouvet Island","bv","Bouvet øen","Antarctic","Antarctic"]
["Brazil","br","Brasilien","Latin America and the Caribbean","South America"]
["British Virgin Islands","io","Jomfruøerne","Africa","Eastern Africa"]
["Brunei","bn","Brunei","Asia","South-eastern Asia"]
["Bulgaria","bg","Bulgarien","Europe","Eastern Europe"]
["Burkina Faso","bf","Burkina Faso","Africa","Western Africa"]
["Burundi","bi","Burundi","Africa","Eastern Africa"]
["Cambodia","kh","Cambodja","Asia","South-eastern Asia"]
["Cameroon","cm","Cameroun","Africa","Middle Africa"]
["Canada","ca","Canada","Northern America","Northern America"]
["Cape Verde","cv","Kap Verde","Africa","Western Africa"]
["Cayman Islands","ky","Caymanøerne","Latin America and the Caribbean","Caribbean"]
["Central African Republic","cf","Den Centralafrikanske Republik","Africa","Middle Africa"]
["Chad","td","Tchad","Africa","Middle Africa"]
["Chile","cl","Chile","Latin America and the Caribbean","South America"]
["China","cn","Kina","Asia","Eastern Asia"]
["Christmas Island","cx","Juleøen","Asia","South-eastern Asia"]
["Cocos (Keeling) Islands","cc","Cocosøerne","Asia","South-eastern Asia"]
["Colombia","co","Colombia","Latin America and the Caribbean","South America"]
["Comoros","km","Comorerne","Africa","Eastern Africa"]
["Congo, Democratic Republic of","cd","Congo, Den Demokratiske Republik (DR Congo)","Africa","Middle Africa"]
["Congo, Republic of","cg","Congo, Republikken (Congo Brazzaville)","Africa","Middle Africa"]
["Cook Islands","ck","Cookøerne","Oceania","Polynesia"]
["Costa Rica","cr","Costa Rica","Latin America and the Caribbean","Central America"]
["Cote d'Ivoire","ci","Elfenbenskysten","Africa","Western Africa"]
["Croatia","hr","Kroatien","Europe","Southern Europe"]
["Cuba","cu","Cuba","Latin America and the Caribbean","Caribbean"]
["Curaçao","cw","Curaçao","Latin America and the Caribbean","Caribbean"]
["Cyprus","cy","Cypern","Asia","Western Asia"]
["Czech Republic","cz","Tjekkiet","Europe","Eastern Europe"]
["Denmark","dk","Danmark","Europe","Northern Europe"]
["Djibouti","dj","Djibouti","Africa","Eastern Africa"]
["Dominica","dm","Dominica","Latin America and the Caribbean","Caribbean"]
["Dominican Republic","do","Dominikanske Republik, Den","Latin America and the Caribbean","Caribbean"]
["East Timor","tl","Østtimor","Asia","South-eastern Asia"]
["Ecuador","ec","Ecuador","Latin America and the Caribbean","South America"]
["Egypt","eg","Egypten","Africa","Northern Africa"]
["El Salvador","sv","El Salvador","Latin America and the Caribbean","Central America"]
["Equatorial Guinea","gq","Ækvatorialguinea","Africa","Middle Africa"]
["Eritrea","er","Eritrea","Africa","Eastern Africa"]
["Estonia","ee","Estland","Europe","Northern Europe"]
["Ethiopia","et","Etiopien","Africa","Eastern Africa"]
["Falkland Islands (Malvinas)","fk","Falklandsøerne","Latin America and the Caribbean","South America"]
["Faroe Islands","fo","Færøerne","Europe","Northern Europe"]
["Fiji","fj","Fiji","Oceania","Melanesia"]
["Finland","fi","Finland","Europe","Northern Europe"]
["France","fr","Frankrig","Europe","Western Europe"]
["French Guiana","gf","Fransk Guyana","Latin America and the Caribbean","South America"]
["French Polynesia","pf","Fransk Polynesien, Fransk Oceanien","Oceania","Polynesia"]
["French Southern Territories and Antarctic Lands","tf","Franske besiddelser i det sydlige Indiske Ocean","Antarctic","Antarctic"]
["Gabon","ga","Gabon","Africa","Middle Africa"]
["Gambia","gm","Gambia","Africa","Western Africa"]
["Georgia","ge","Georgien","Asia","Western Asia"]
["Germany","de","Tyskland","Europe","Western Europe"]
["Ghana","gh","Ghana","Africa","Western Africa"]
["Gibraltar","gi","Gibraltar","Europe","Southern Europe"]
["Greece","gr","Grækenland","Europe","Southern Europe"]
["Greenland","gl","Grønland","Northern America","Northern America"]
["Grenada","gd","Grenada","Latin America and the Caribbean","Caribbean"]
["Guadeloupe","gp","Guadeloupe","Latin America and the Caribbean","Caribbean"]
["Guam","gu","Guam","Oceania","Micronesia"]
["Guatemala","gt","Guatemala","Latin America and the Caribbean","Central America"]
["Guernsey","gg","Guernsey","Europe","Northern Europe"]
["Guinea","gn","Guinea","Africa","Western Africa"]
["Guinea-Bissau","gw","Guinea-Bissau","Africa","Western Africa"]
["Guyana","gy","Guyana","Latin America and the Caribbean","South America"]
["Haiti","ht","Haiti","Latin America and the Caribbean","Caribbean"]
["Heard Island and McDonald Islands","hm","Heard- og McDonaldøerne","Antarctic","Antarctic"]
["Holy See (Vatican City State)","va","Vatikanstaten","Europe","Southern Europe"]
["Honduras","hn","Honduras","Latin America and the Caribbean","Central America"]
["Hong Kong","hk","Hongkong","Asia","Eastern Asia"]
["Hungary","hu","Ungarn","Europe","Eastern Europe"]
["Iceland","is","Island","Europe","Northern Europe"]
["India","in","Indien","Asia","South-central Asia"]
["Indonesia","id","Indonesien","Asia","South-eastern Asia"]
["Iran","ir","Iran","Asia","South-central Asia"]
["Iraq","iq","Irak","Asia","Western Asia"]
["Ireland","ie","Irland","Europe","Northern Europe"]
["Isle of Man","im","Isle of Man","Europe","Northern Europe"]
["Israel","il","Israel","Asia","Western Asia"]
["Italy","it","Italien","Europe","Southern Europe"]
["Ivory Coast","ci","Elfenbenskysten","Africa","Western Africa"]
["Jamaica","jm","Jamaica","Latin America and the Caribbean","Caribbean"]
["Japan","jp","Japan","Asia","Eastern Asia"]
["Jersey","je","Jersey","Europe","Northern Europe"]
["Jordan","jo","Jordan","Asia","Western Asia"]
["Kazakhstan","kz","Kasakhstan","Asia","South-central Asia"]
["Kenya","ke","Kenya","Africa","Eastern Africa"]
["Kiribati","ki","Kiribati","Oceania","Micronesia"]
["Korea, North","kp","Nordkorea","Asia","Eastern Asia"]
["Korea, South","kr","Sydkorea","Asia","Eastern Asia"]
["Kuwait","kw","Kuwait","Asia","Western Asia"]
["Kyrgyzstan","kg","Kirgisistan","Asia","South-central Asia"]
["Laos","la","Laos","Asia","South-eastern Asia"]
["Latvia","lv","Letland","Europe","Northern Europe"]
["Lebanon","lb","Libanon","Asia","Western Asia"]
["Lesotho","ls","Lesotho","Africa","Southern Africa"]
["Liberia","lr","Liberia","Africa","Western Africa"]
["Libya","ly","Libyen","Africa","Northern Africa"]
["Liechtenstein","li","Liechtenstein","Europe","Western Europe"]
["Lithuania","lt","Litauen","Europe","Northern Europe"]
["Luxembourg","lu","Luxembourg","Europe","Western Europe"]
["Macau","mo","Macao","Asia","Eastern Asia"]
["Macedonia, The Former Yugoslav Republic of","mk","Makedonien, Den Tidligere Jugoslaviske Republik","Europe","Southern Europe"]
["Madagascar","mg","Madagaskar","Africa","Eastern Africa"]
["Malawi","mw","Malawi","Africa","Eastern Africa"]
["Malaysia","my","Malaysia","Asia","South-eastern Asia"]
["Maldives","mv","Maldiverne","Asia","South-central Asia"]
["Mali","ml","Mali","Africa","Western Africa"]
["Malta","mt","Malta","Europe","Southern Europe"]
["Marshall Islands","mh","Marshalløerne","Oceania","Micronesia"]
["Martinique","mq","Martinique","Latin America and the Caribbean","Caribbean"]
["Mauritania","mr","Mauretanien","Africa","Western Africa"]
["Mauritius","mu","Mauritius","Africa","Eastern Africa"]
["Mayotte","yt","Mayotte","Africa","Eastern Africa"]
["Mexico","mx","Mexico","Latin America and the Caribbean","Central America"]
["Micronesia, Federated States of","fm","Mikronesisike Stater, De Forenede","Oceania","Micronesia"]
["Moldova","md","Moldavien","Europe","Eastern Europe"]
["Monaco","mc","Monaco","Europe","Western Europe"]
["Mongolia","mn","Mongoliet","Asia","Eastern Asia"]
["Montenegro","me","Montenegro","Europe","Southern Europe"]
["Montserrat","ms","Montserrat","Latin America and the Caribbean","Caribbean"]
["Morocco","ma","Marokko","Africa","Northern Africa"]
["Mozambique","mz","Mozambique","Africa","Eastern Africa"]
["Myanmar (Burma)","mm","Myanmar","Asia","South-eastern Asia"]
["Namibia","na","Namibia","Africa","Southern Africa"]
["Nauru","nr","Nauru","Oceania","Micronesia"]
["Nepal","np","Nepal","Asia","South-central Asia"]
["Netherlands","nl","Holland (Nederlandene)","Europe","Western Europe"]
["Netherlands Antilles","an","De Nederlandske Antiller","Latin America and the Caribbean","Caribbean"]
["New Caledonia","nc","Ny Kaledonien","Oceania","Melanesia"]
["New Zealand","nz","New Zealand","Oceania","Australia and New Zealand"]
["Nicaragua","ni","Nicaragua","Latin America and the Caribbean","Central America"]
["Niger","ne","Niger","Africa","Western Africa"]
["Nigeria","ng","Nigeria","Africa","Western Africa"]
["Niue","nu","Niue","Oceania","Polynesia"]
["Norfolk Island","nf","Norfolk Island","Oceania","Australia and New Zealand"]
["Northern Mariana Islands","mp","Nordmarianerne","Oceania","Micronesia"]
["Norway","no","Norge","Europe","Northern Europe"]
["Oman","om","Oman","Asia","Western Asia"]
["Pakistan","pk","Pakistan","Asia","South-central Asia"]
["Palau","pw","Belau","Oceania","Micronesia"]
["Palestinian Sovereign Areas","ps","Palæstinensiske selvstyre områder","Asia","Western Asia"]
["Panama","pa","Panama","Latin America and the Caribbean","Central America"]
["Papua New Guinea","pg","Papua Ny Guinea","Oceania","Melanesia"]
["Paraguay","py","Paraguay","Latin America and the Caribbean","South America"]
["Peru","pe","Peru","Latin America and the Caribbean","South America"]
["Philippines","ph","Filippinerne","Asia","South-eastern Asia"]
["Pitcairn Islands","pn","Pitcairn","Oceania","Polynesia"]
["Poland","pl","Polen","Europe","Eastern Europe"]
["Portugal","pt","Portugal","Europe","Southern Europe"]
["Puerto Rico","pr","Puerto Rico","Latin America and the Caribbean","Caribbean"]
["Qatar","qa","Qatar","Asia","Western Asia"]
["Réunion","re","Réunion","Africa","Eastern Africa"]
["Romania","ro","Rumænien","Europe","Eastern Europe"]
["Russia","ru","Rusland","Europe","Eastern Europe"]
["Rwanda","rw","Rwanda","Africa","Eastern Africa"]
["Saint Barthélemy","bl","Saint Barthélemy","Latin America and the Caribbean","Caribbean"]
["Saint Helena","sh","Saint Helena","Africa","Western Africa"]
["Saint Kitts and Nevis","kn","Saint Kitts og Nevis","Latin America and the Caribbean","Caribbean"]
["Saint Lucia","lc","Saint Lucia","Latin America and the Caribbean","Caribbean"]
["Saint Martin (French part)","mf","Saint Martin","Latin America and the Caribbean","Caribbean"]
["Saint Pierre and Miquelon","pm","Saint Pierre og Miquelon","Northern America","Northern America"]
["Saint Vincent and the Grenadines","vc","Saint Vincent og Grenadinerne","Latin America and the Caribbean","Caribbean"]
["Samoa","ws","Samoa, Vest Samoa","Oceania","Polynesia"]
["San Marino","sm","San Marino","Europe","Southern Europe"]
["Sao Tome and Principe","st","São Tomé og Príncipe","Africa","Middle Africa"]
["Saudi Arabia","sa","Saudi-Arabien","Asia","Western Asia"]
["Senegal","sn","Senegal","Africa","Western Africa"]
["Serbia","rs","Serbien","Europe","Southern Europe"]
["Seychelles","sc","Seychellerne","Africa","Eastern Africa"]
["Sierra Leone","sl","Sierra Leone","Africa","Western Africa"]
["Singapore","sg","Singapore","Asia","South-eastern Asia"]
["Sint Maarten (Dutch part)","sx","Sint Maarten","Latin America and the Caribbean","Caribbean"]
["Slovakia","sk","Slovakiet","Europe","Eastern Europe"]
["Slovenia","si","Slovenien","Europe","Southern Europe"]
["Solomon Islands","sb","Salomonøerne","Oceania","Melanesia"]
["Somalia","so","Somalia","Africa","Eastern Africa"]
["South Africa","za","Sydafrika","Africa","Southern Africa"]
["South Georgia and the South Sandwich Islands","gs","Syd Georgia og De Sydlige Sandwichøer","Latin America and the Caribbean","South America"]
["South Sudan","ss","Sydsudan","Africa","Eastern Africa"]
["Spain","es","Spanien","Europe","Southern Europe"]
["Sri Lanka","lk","Sri Lanka","Asia","South-central Asia"]
["Sudan","sd","Sudan","Africa","Northern Africa"]
["Suriname","sr","Surinam","Latin America and the Caribbean","South America"]
["Svalbard and Jan Mayen","sj","Svalbard og Jan Mayen","Europe","Northern Europe"]
["Swaziland","sz","Swaziland","Africa","Southern Africa"]
["Sweden","se","Sverige","Europe","Northern Europe"]
["Switzerland","ch","Schweiz","Europe","Western Europe"]
["Syria","sy","Syrien","Asia","Western Asia"]
["Taiwan","tw","Taiwan","Asia","Eastern Asia"]
["Tajikistan","tj","Tadsjikistan","Asia","South-central Asia"]
["Tanzania","tz","Tanzania","Africa","Eastern Africa"]
["Thailand","th","Thailand","Asia","South-eastern Asia"]
["Togo","tg","Togo","Africa","Western Africa"]
["Tokelau","tk","Tokelau","Oceania","Polynesia"]
["Tonga","to","Tonga","Oceania","Polynesia"]
["Trinidad and Tobago","tt","Trinidad og Tobago","Latin America and the Caribbean","Caribbean"]
["Tunisia","tn","Tunesien","Africa","Northern Africa"]
["Turkey","tr","Tyrkiet","Asia","Western Asia"]
["Turkmenistan","tm","Turkmenistan","Asia","South-central Asia"]
["Turks and Caicos Islands","tc","Turks- og Caicosøerne","Latin America and the Caribbean","Caribbean"]
["Tuvalu","tv","Tuvalu","Oceania","Polynesia"]
["Uganda","ug","Uganda","Africa","Eastern Africa"]
["Ukraine","ua","Ukraine","Europe","Eastern Europe"]
["United Arab Emirates","ae","De Forenede Arabiske Emirater","Asia","Western Asia"]
["United Kingdom","gb","Storbritannien","Europe","Northern Europe"]
["United States","us","USA","Northern America","Northern America"]
["United States Minor Outlying Islands","um","USA's mindre fjerntliggende ø'er","Oceania","Polynesia"]
["Uruguay","uy","Uruguay","Latin America and the Caribbean","South America"]
["Uzbekistan","uz","Usbekistan","Asia","South-central Asia"]
["Vanuatu","vu","Vanuatu","Oceania","Melanesia"]
["Venezuela","ve","Venezuela","Latin America and the Caribbean","South America"]
["Vietnam","vn","Vietnam","Asia","South-eastern Asia"]
["Virgin Islands, British","vg","Jomfruøer, De Britiske","Latin America and the Caribbean","Caribbean"]
["Virgin Islands, U.S.","vi","Jomfruøer, De Amerikanske","Latin America and the Caribbean","Caribbean"]
["Wallis and Futuna","wf","Wallis og Futunaøerne","Oceania","Polynesia"]
["Western Sahara","eh","Vestsahara","Africa","Northern Africa"]
["Yemen","ye","Yemen","Asia","Western Asia"]
["Zambia","zm","Zambia","Africa","Eastern Africa"]
["Zimbabwe","zw","Zimbabwe","Africa","Eastern Africa"]
["Stateless","xx","Statsløs","Unknown","Unknown"]
["Unknown","zz","Ukendt","Unknown","Unknown"]

{"sheet":"Vejledning","index":4,"n_rows":88,"n_cols":13,"rows_kept":88}
[null,null,"Generering af rapport i PhD Planneren samt efterfølgende behandling i Excel",{"$nulls":9},"Kopi af Data-fanebladet til upload på hovedopslaget opslaget"]
[]
[null,"1.","I PhD Planneren",{"$nulls":8},"10.","I regnearket du lige har gemt i trin 9:"]
[null,null,"a: Tjek at alle program-opslag har status \"Awaits school assessment\"",{"$nulls":9},"a: Højreklik på fanebladet \"Data\" og vælg \"Move or Copy...\""]
[null,null,"b: Vælg \"Kampagnestyring\"  » \"Rapporter og diagrammer\"",{"$nulls":9},"b: Vælg To book: \"(new book)\""]
[null,null,"c: Kør rapporten \"PHD Application and Programme Data\" i mappen \"PHD\"",{"$nulls":9},"c: Sæt kryds i \"Create a copy\""]
[null,null,"d: Åbn regnearket",{"$nulls":9},"d: Tryk \"OK\""]
[]
[null,"2.","Åbn \"Template for Application and Programme Data\"",{"$nulls":8},"11.","Gem det nye regneark"]
[]
[null,"3.","I regnearket fra PhD Planneren:",{"$nulls":8},"12.","I det nye regneark:"]
[null,null,"a: Højreklik på fanebladet og vælg \"Move or Copy...\"",{"$nulls":9},"a: Udpeg hele søjle H: Age (markér hele søjlen)"]
[null,null,"b: Vælg To book: \"Template for Application and Programme Data\"",{"$nulls":9},"b: Kopier den - tryk <ctrl> + c"]
[null,null,"c: Vælg Before sheet: \"Country codes\"",{"$nulls":9},"c: Højreklik og vælg \"Paste Special…\" » \"Values (V)\""]
[null,null,"d: Tryk \"OK\"",{"$nulls":9},"    ELLER"]
[null,null,"NB: Hvis du ikke kan se sheetet \"Country codes\", så er det sandsynligvis, fordi \"Template for ",{"$nulls":9},"    Klik på \"Paste\"-knappen på Home-faneb øverst og vælg \"Values (V)."]
[null,null,"Application and Programme Data\" er skrivebeskyttet. Gem \"Template for Application and Programme ",{"$nulls":9},"    (ligesom i punkt 6)"]
[null,null,"Data\" og prøv igen.",{"$nulls":9},"d: Tryk \"OK\""]
[]
[null,null,"Fanebladet i regnearket fra PhD Planneren flyttes nu ind i  \"Template for Application and",{"$nulls":8},"13.","Slet søjle A-G. Dvs. til, men ikke med Age-kolonnen."]
[null,null,"Programme Data\" (eller hvad du har valgt at kalde regnearket), og der arbejdes videre i ",{"$nulls":9},"Age er nu blevet til søjle A."]
[null,null,"\"Template for Application and Programme Data\"."]
[{"$nulls":11},"14.","Hvis ikke der allerede er filtre på kolonnerne, gør således for at aktivere filtrene:"]
[{"$nulls":12},"Marker celle A1 (Age-cellen):"]
[null,"4.","På fanebladet \"Report-x\" i dette regneark vælges alle celler fra og med dem i dem i den første blå",{"$nulls":9},"a: Klik på celle A1 for at markere den"]
[null,null," række til, men ikke med, cellerne i den sidste blå række.",{"$nulls":9},"b: Klik på Data-fanen foroven og klik på \"Filter\"-knappen"]
[null,null,"Brug musen til at udpege området. Eller brug tastaturet således:"]
[null,null,"a: Udpeg den blå celle \"Company name\" (A5)"]
[null,null,"b: Hold <ctrl>+<Skift> nede og tryk højre pil"]
[null,null,"c: Behold <ctrl>+<Skift> nede og tryk pil ned"]
[null,null,"d: Behold <skift> nede, slip <ctrl> og tryk pil op"]
[]
[null,"5.","Kopier det markerede område - tryk <ctrl> + c"]
[{"$nulls":12},"Der kommer nu pile ved siden af overskrifterne i række 1. Pilene indikerer at man kan  "]
[null,"6.","Dataene fra fanebladet \"Report-x\" skal nu indsættes på fanebladet \"Data\".",{"$nulls":9},"sortere værdierne i kolonnerne."]
[null,null,"a: Klik på fanebladet \"Data\" på den grønne celle \"Company name\""]
[null,null,"b: Højreklik og vælg \"Paste Special…\" » \"Values (V)\"",{"$nulls":8},"15.","Hvis ikke den øverst række allerede er fastlås, gør således for at fastlåse den:"]
[null,null,"    ELLER",{"$nulls":9},"a: Klik på View-fanen øverst, klik på \"Freeze Panes\" » \"Freeze Top Row\" "]
[null,null,"    Klik på \"Paste\"-knappen på Home-faneb øverst og vælg \"Values (V)."]
{"$rows_empty":13}
[{"$nulls":12},"Den øverste række kan nu ses, ligegyldigt hvor langt der scrolles ned."]
[]
[{"$nulls":11},"16.","Slet evt. søjler, der ikke skal bruges."]
[{"$nulls":12},"MEN slet under ingen omstændigheder søjlerne Docs og UpdateCode!!!"]
[{"$nulls":12},"Hvis de slettes, kan man ikke klikke på Docs og se vedhæftninger."]
[]
[{"$nulls":11},"17.","Gem regnearket"]
[{"$nulls":12},"Sorter evt. på \"Academic assessment\" og fjern de rækker med ansøgere, der ikke er \"Qualified\"."]
[{"$nulls":12},"Evt. kan man lave en kopi af regnearket, hvor man kun beholder ansøgere,  der er \"Not qualified\""]
[]
[null,"7.","Tjek at kolonnerne A-I er fyldt ud for alle ansøgere. Hvis ikke, så markér den nederste"]
[null,null,"udfyldte række. Placér musen nederst til højre i markeringen. Der kommer et lille plus frem."]
[null,null,"Dobbeltklik mens plusset er fremme."]
{"$rows_empty":9}
[null,"8.","Klik på Data-fanen øverst, og tryk \"Refresh All\"."]
{"$rows_empty":8}
[null,"9.","Tjek at tabellerne på de første to faneblade (Application statistics og Gender statistics)"]
[null,null,"er blevet opdateret."]
[]
[null,"10.","Gem regnearket (dette regneark skal nu bruges som grundlag for at lave et nyt regneark,"]
[null,null,"som skal uploades på ansøgningsrundens hovedopslag)."]