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

{"sheet":"Application statistics","index":0,"n_rows":35,"n_cols":21,"rows_kept":35}
[]
[]
["Sum of Applications",null,null,"Sum of Applicants",null,null,"Sum of Applicants",{"$nulls":3},"Sum of Applicants",{"$nulls":3},"Sum of Applicants",{"$nulls":3},"Sum of Applications"]
["Country (home)","Total",null,"Country (home)","Total",null,"Origin  - Sub-region","Total",null,null,"Origin - Region","Total",null,null,"Origin","Total",null,null,"Programme","Total"]
[" ",1,null," ",1,{"$nulls":5},"#N/A",1,null,null,"Abroad",{"v":1,"d":"100%"},null,null," ",1]
["Grand Total",1,null,"Grand Total",1,{"$nulls":9},"Grand Total",{"v":1,"d":"100%"},null,null,"Grand Total",1]
[]
[]
[]
[{"$nulls":14},"Sum of Applications"]
[{"$nulls":14},"Recommendations","Total"]
[{"$nulls":14},3,1]
[{"$nulls":15},0]
[{"$nulls":14},"Grand Total",1]
[]
[]
[]
[]
[{"$nulls":14},"Sum of Applications"]
[{"$nulls":14},"Recommendations","Total"]
[{"$nulls":14},3,{"v":1,"d":"100%"}]
[{"$nulls":15},{"v":0,"d":"0%"}]
[{"$nulls":14},"Grand Total",{"v":1,"d":"100%"}]
{"$rows_empty":7}
[{"$nulls":18},"Sum of Applications"]
[{"$nulls":18},"Programme","AreaProj","Total"]
[{"$nulls":18}," "," ",1]
[{"$nulls":18},"  Total",null,1]
[{"$nulls":18},"Grand Total",null,1]

{"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 app"," ","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 app"," ","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 app"," ","Grand Total"]
[{"$nulls":5},"Edu level app"," ","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":5},"Origin - Region","(blank)"," ","Grand Total"]
[{"$nulls":6},0,null,0]
[{"$nulls":5},"#N/A",null,1,1]
[{"$nulls":5},"Grand Total",0,1,1]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Sum of Applications","Gender"]
[{"$nulls":5},"Origin - Region","(blank)"," ","Grand Total"]
[{"$nulls":6},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":5},"#N/A",{"v":0,"d":"0%"},{"v":1,"d":"100%"},{"v":1,"d":"100%"}]
[{"$nulls":5},"Grand Total",{"v":0,"d":"0%"},{"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":"Multiple Apps","index":2,"n_rows":55,"n_cols":8,"rows_kept":55}
["AppCount","(All)"]
[]
["Count of E-mail"]
["E-mail","First name","Last name","Candidate ID","Project title","Programme","Total","Mult. applications"]
[{"$nulls":7},{"$f":"F5&IF(AND(ISBLANK(A6),NOT(ISBLANK(G6))),\", \"&H6,\"\")","v":""}]
[{"$nulls":7},{"$f":"F6&IF(AND(ISBLANK(A7),NOT(ISBLANK(G7))),\", \"&H7,\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]

{"sheet":"Data","index":3,"n_rows":400,"n_cols":59,"rows_kept":400}
["AppCount","Mult. applications","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 level app","Edu status","Edu date","Edu grade point average app","Acad supplementary information","Previous PhD enrolment institution and country","Enrol start app","Enrol credit transfer (months) app","Enrol industrial PhD company app","Enrol hours/week and reason","Funding support app","AreaProj","Project title","Project abstract","Main supervisor app","Co-supervisor1 app","Co-sup1 pos app","Co-sup1 inst app","Co-sup1 em app","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","Registration date","UpdateCode"]
[{"$f":"IF($G2,COUNTIF($Q:$Q,$Q2),0)","v":1},{"$f":"IF($G2,IFERROR(VLOOKUP(Q2,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G2,IFERROR(VLOOKUP($R2,CountryCodes[],4,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G2,IFERROR(VLOOKUP($R2,CountryCodes[],5,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G2,IF(R2=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":"Abroad"},{"$f":"IF($G2,IF(AU2=\"\",0,1)+IF(AZ2=\"\",0,1)+IF(BE2=\"\",0,1),\"\")","v":3},{"$f":"IF(M2=\"\",0,1)","v":1},{"$f":"IF($G2,1/$A2,0)","v":1},{"$f":"IF($G2,IF(ISBLANK(T2),\"?\",DAYS360(T2,NOW())/360),\"\")","v":{"$error":"#VALUE!"}},{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M2&\"&CandidateUpdateCode=\"&BG2&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "]
[0,{"$f":"IF($G3,IFERROR(VLOOKUP(Q3,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G3,VLOOKUP($R3,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G3,VLOOKUP($R3,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G3,IF(R3=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G3,IF(AU3=\"\",0,1)+IF(AZ3=\"\",0,1)+IF(BE3=\"\",0,1),\"\")","v":""},{"$f":"IF(M3=\"\",0,1)","v":0},{"$f":"IF($G3,1/$A3,0)","v":0},{"$f":"IF($G3,IF(ISBLANK(T3),\"?\",DAYS360(T3,NOW())/360),\"\")","v":""},{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M3&\"&CandidateUpdateCode=\"&BG3&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G4,VLOOKUP($R4,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G4,VLOOKUP($R4,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G5,VLOOKUP($R5,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G5,VLOOKUP($R5,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G6,VLOOKUP($R6,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G6,VLOOKUP($R6,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G7,VLOOKUP($R7,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G7,VLOOKUP($R7,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G8,VLOOKUP($R8,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G8,VLOOKUP($R8,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G9,VLOOKUP($R9,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G9,VLOOKUP($R9,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G10,VLOOKUP($R10,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G10,VLOOKUP($R10,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G11,VLOOKUP($R11,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G11,VLOOKUP($R11,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G12,VLOOKUP($R12,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G12,VLOOKUP($R12,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G13,VLOOKUP($R13,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G13,VLOOKUP($R13,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G14,VLOOKUP($R14,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G14,VLOOKUP($R14,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G15,VLOOKUP($R15,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G15,VLOOKUP($R15,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G16,VLOOKUP($R16,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G16,VLOOKUP($R16,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G17,VLOOKUP($R17,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G17,VLOOKUP($R17,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G18,VLOOKUP($R18,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G18,VLOOKUP($R18,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G19,VLOOKUP($R19,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G19,VLOOKUP($R19,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G20,VLOOKUP($R20,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G20,VLOOKUP($R20,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G21,VLOOKUP($R21,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G21,VLOOKUP($R21,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G22,VLOOKUP($R22,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G22,VLOOKUP($R22,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G23,VLOOKUP($R23,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G23,VLOOKUP($R23,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G24,VLOOKUP($R24,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G24,VLOOKUP($R24,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G25,VLOOKUP($R25,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G25,VLOOKUP($R25,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G26,VLOOKUP($R26,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G26,VLOOKUP($R26,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G27,VLOOKUP($R27,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G27,VLOOKUP($R27,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G28,VLOOKUP($R28,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G28,VLOOKUP($R28,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G29,VLOOKUP($R29,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G29,VLOOKUP($R29,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G30,VLOOKUP($R30,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G30,VLOOKUP($R30,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G31,VLOOKUP($R31,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G31,VLOOKUP($R31,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G32,VLOOKUP($R32,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G32,VLOOKUP($R32,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G33,VLOOKUP($R33,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G33,VLOOKUP($R33,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G34,VLOOKUP($R34,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G34,VLOOKUP($R34,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G35,VLOOKUP($R35,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G35,VLOOKUP($R35,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G36,VLOOKUP($R36,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G36,VLOOKUP($R36,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G37,VLOOKUP($R37,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G37,VLOOKUP($R37,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G38,VLOOKUP($R38,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G38,VLOOKUP($R38,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G39,VLOOKUP($R39,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G39,VLOOKUP($R39,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G40,VLOOKUP($R40,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G40,VLOOKUP($R40,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G41,VLOOKUP($R41,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G41,VLOOKUP($R41,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G42,VLOOKUP($R42,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G42,VLOOKUP($R42,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G43,VLOOKUP($R43,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G43,VLOOKUP($R43,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G44,VLOOKUP($R44,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G44,VLOOKUP($R44,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G45,VLOOKUP($R45,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G45,VLOOKUP($R45,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G46,VLOOKUP($R46,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G46,VLOOKUP($R46,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G47,VLOOKUP($R47,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G47,VLOOKUP($R47,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G48,VLOOKUP($R48,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G48,VLOOKUP($R48,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G49,VLOOKUP($R49,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G49,VLOOKUP($R49,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G50,VLOOKUP($R50,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G50,VLOOKUP($R50,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G51,VLOOKUP($R51,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G51,VLOOKUP($R51,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G52,VLOOKUP($R52,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G52,VLOOKUP($R52,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G53,VLOOKUP($R53,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G53,VLOOKUP($R53,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G54,VLOOKUP($R54,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G54,VLOOKUP($R54,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G55,VLOOKUP($R55,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G55,VLOOKUP($R55,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G56,VLOOKUP($R56,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G56,VLOOKUP($R56,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G57,VLOOKUP($R57,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G57,VLOOKUP($R57,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G58,VLOOKUP($R58,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G58,VLOOKUP($R58,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G59,VLOOKUP($R59,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G59,VLOOKUP($R59,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G60,VLOOKUP($R60,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G60,VLOOKUP($R60,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G61,VLOOKUP($R61,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G61,VLOOKUP($R61,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G62,VLOOKUP($R62,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G62,VLOOKUP($R62,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G63,VLOOKUP($R63,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G63,VLOOKUP($R63,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G64,VLOOKUP($R64,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G64,VLOOKUP($R64,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G65,VLOOKUP($R65,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G65,VLOOKUP($R65,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G66,COUNTIF($Q:$Q,$Q66),0)","v":0},"",{"$f":"IF($G66,VLOOKUP($R66,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G66,VLOOKUP($R66,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G67,IFERROR(VLOOKUP(Q67,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G67,VLOOKUP($R67,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G67,VLOOKUP($R67,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G67,IF(R67=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G67,IF(AU67=\"\",0,1)+IF(AZ67=\"\",0,1)+IF(BE67=\"\",0,1),\"\")","v":""},{"$f":"IF(M67=\"\",0,1)","v":0},{"$f":"IF($G67,1/$A67,0)","v":0},{"$f":"IF($G67,IF(ISBLANK(T67),\"?\",DAYS360(T67,NOW())/360),\"\")","v":""},{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M67&\"&CandidateUpdateCode=\"&BG67&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G68,VLOOKUP($R68,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G68,VLOOKUP($R68,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G69,VLOOKUP($R69,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G69,VLOOKUP($R69,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G70,VLOOKUP($R70,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G70,VLOOKUP($R70,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G71,VLOOKUP($R71,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G71,VLOOKUP($R71,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G72,VLOOKUP($R72,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G72,VLOOKUP($R72,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G73,VLOOKUP($R73,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G73,VLOOKUP($R73,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G74,VLOOKUP($R74,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G74,VLOOKUP($R74,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G75,VLOOKUP($R75,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G75,VLOOKUP($R75,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G76,VLOOKUP($R76,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G76,VLOOKUP($R76,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G77,VLOOKUP($R77,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G77,VLOOKUP($R77,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G78,VLOOKUP($R78,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G78,VLOOKUP($R78,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G79,VLOOKUP($R79,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G79,VLOOKUP($R79,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G80,VLOOKUP($R80,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G80,VLOOKUP($R80,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G81,VLOOKUP($R81,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G81,VLOOKUP($R81,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G82,VLOOKUP($R82,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G82,VLOOKUP($R82,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G83,VLOOKUP($R83,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G83,VLOOKUP($R83,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G84,VLOOKUP($R84,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G84,VLOOKUP($R84,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G85,VLOOKUP($R85,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G85,VLOOKUP($R85,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G86,VLOOKUP($R86,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G86,VLOOKUP($R86,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G87,VLOOKUP($R87,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G87,VLOOKUP($R87,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G88,VLOOKUP($R88,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G88,VLOOKUP($R88,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G89,VLOOKUP($R89,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G89,VLOOKUP($R89,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G90,VLOOKUP($R90,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G90,VLOOKUP($R90,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G91,VLOOKUP($R91,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G91,VLOOKUP($R91,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G92,VLOOKUP($R92,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G92,VLOOKUP($R92,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G93,VLOOKUP($R93,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G93,VLOOKUP($R93,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G94,VLOOKUP($R94,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G94,VLOOKUP($R94,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G95,VLOOKUP($R95,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G95,VLOOKUP($R95,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G96,VLOOKUP($R96,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G96,VLOOKUP($R96,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G97,VLOOKUP($R97,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G97,VLOOKUP($R97,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G98,VLOOKUP($R98,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G98,VLOOKUP($R98,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G99,VLOOKUP($R99,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G99,VLOOKUP($R99,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G100,VLOOKUP($R100,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G100,VLOOKUP($R100,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G101,VLOOKUP($R101,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G101,VLOOKUP($R101,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G102,VLOOKUP($R102,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G102,VLOOKUP($R102,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G103,VLOOKUP($R103,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G103,VLOOKUP($R103,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G104,VLOOKUP($R104,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G104,VLOOKUP($R104,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G105,VLOOKUP($R105,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G105,VLOOKUP($R105,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G106,VLOOKUP($R106,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G106,VLOOKUP($R106,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G107,VLOOKUP($R107,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G107,VLOOKUP($R107,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G108,VLOOKUP($R108,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G108,VLOOKUP($R108,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G109,VLOOKUP($R109,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G109,VLOOKUP($R109,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G110,VLOOKUP($R110,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G110,VLOOKUP($R110,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G111,VLOOKUP($R111,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G111,VLOOKUP($R111,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G112,VLOOKUP($R112,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G112,VLOOKUP($R112,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G113,VLOOKUP($R113,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G113,VLOOKUP($R113,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G114,VLOOKUP($R114,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G114,VLOOKUP($R114,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G115,VLOOKUP($R115,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G115,VLOOKUP($R115,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G116,VLOOKUP($R116,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G116,VLOOKUP($R116,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G117,VLOOKUP($R117,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G117,VLOOKUP($R117,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G118,VLOOKUP($R118,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G118,VLOOKUP($R118,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G119,VLOOKUP($R119,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G119,VLOOKUP($R119,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G120,VLOOKUP($R120,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G120,VLOOKUP($R120,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G121,VLOOKUP($R121,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G121,VLOOKUP($R121,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G122,VLOOKUP($R122,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G122,VLOOKUP($R122,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G123,VLOOKUP($R123,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G123,VLOOKUP($R123,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G124,VLOOKUP($R124,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G124,VLOOKUP($R124,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G125,VLOOKUP($R125,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G125,VLOOKUP($R125,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G126,VLOOKUP($R126,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G126,VLOOKUP($R126,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G127,VLOOKUP($R127,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G127,VLOOKUP($R127,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G128,VLOOKUP($R128,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G128,VLOOKUP($R128,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G129,VLOOKUP($R129,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G129,VLOOKUP($R129,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G130,COUNTIF($Q:$Q,$Q130),0)","v":0},"",{"$f":"IF($G130,VLOOKUP($R130,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G130,VLOOKUP($R130,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G131,IFERROR(VLOOKUP(Q131,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G131,VLOOKUP($R131,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G131,VLOOKUP($R131,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G131,IF(R131=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G131,IF(AU131=\"\",0,1)+IF(AZ131=\"\",0,1)+IF(BE131=\"\",0,1),\"\")","v":""},{"$f":"IF(M131=\"\",0,1)","v":0},{"$f":"IF($G131,1/$A131,0)","v":0},{"$f":"IF($G131,IF(ISBLANK(T131),\"?\",DAYS360(T131,NOW())/360),\"\")","v":""},{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M131&\"&CandidateUpdateCode=\"&BG131&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G132,VLOOKUP($R132,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G132,VLOOKUP($R132,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G133,VLOOKUP($R133,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G133,VLOOKUP($R133,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G134,VLOOKUP($R134,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G134,VLOOKUP($R134,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G135,VLOOKUP($R135,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G135,VLOOKUP($R135,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G136,VLOOKUP($R136,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G136,VLOOKUP($R136,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G137,VLOOKUP($R137,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G137,VLOOKUP($R137,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G138,IFERROR(VLOOKUP(Q138,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G138,VLOOKUP($R138,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G138,VLOOKUP($R138,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G138,IF(R138=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G138,IF(AU138=\"\",0,1)+IF(AZ138=\"\",0,1)+IF(BE138=\"\",0,1),\"\")","v":""},{"$f":"IF(M138=\"\",0,1)","v":0},0,{"$f":"IF($G138,IF(ISBLANK(T138),\"?\",DAYS360(T138,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G139,VLOOKUP($R139,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G139,VLOOKUP($R139,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G140,VLOOKUP($R140,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G140,VLOOKUP($R140,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G141,VLOOKUP($R141,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G141,VLOOKUP($R141,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G142,VLOOKUP($R142,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G142,VLOOKUP($R142,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G143,VLOOKUP($R143,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G143,VLOOKUP($R143,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G144,VLOOKUP($R144,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G144,VLOOKUP($R144,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G145,VLOOKUP($R145,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G145,VLOOKUP($R145,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G146,VLOOKUP($R146,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G146,VLOOKUP($R146,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G147,VLOOKUP($R147,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G147,VLOOKUP($R147,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G148,VLOOKUP($R148,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G148,VLOOKUP($R148,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G149,VLOOKUP($R149,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G149,VLOOKUP($R149,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G150,VLOOKUP($R150,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G150,VLOOKUP($R150,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G151,VLOOKUP($R151,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G151,VLOOKUP($R151,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G152,VLOOKUP($R152,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G152,VLOOKUP($R152,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G153,VLOOKUP($R153,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G153,VLOOKUP($R153,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G154,VLOOKUP($R154,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G154,VLOOKUP($R154,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G155,VLOOKUP($R155,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G155,VLOOKUP($R155,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G156,VLOOKUP($R156,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G156,VLOOKUP($R156,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G157,VLOOKUP($R157,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G157,VLOOKUP($R157,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G158,VLOOKUP($R158,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G158,VLOOKUP($R158,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G159,IFERROR(VLOOKUP(Q159,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G159,VLOOKUP($R159,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G159,VLOOKUP($R159,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G159,IF(R159=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G159,IF(AU159=\"\",0,1)+IF(AZ159=\"\",0,1)+IF(BE159=\"\",0,1),\"\")","v":""},{"$f":"IF(M159=\"\",0,1)","v":0},0,{"$f":"IF($G159,IF(ISBLANK(T159),\"?\",DAYS360(T159,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G160,VLOOKUP($R160,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G160,VLOOKUP($R160,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G161,VLOOKUP($R161,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G161,VLOOKUP($R161,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G162,VLOOKUP($R162,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G162,VLOOKUP($R162,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G163,VLOOKUP($R163,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G163,VLOOKUP($R163,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G164,VLOOKUP($R164,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G164,VLOOKUP($R164,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G165,VLOOKUP($R165,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G165,VLOOKUP($R165,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G166,VLOOKUP($R166,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G166,VLOOKUP($R166,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G167,VLOOKUP($R167,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G167,VLOOKUP($R167,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G168,VLOOKUP($R168,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G168,VLOOKUP($R168,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G169,VLOOKUP($R169,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G169,VLOOKUP($R169,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G170,VLOOKUP($R170,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G170,VLOOKUP($R170,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G171,VLOOKUP($R171,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G171,VLOOKUP($R171,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G172,VLOOKUP($R172,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G172,VLOOKUP($R172,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G173,VLOOKUP($R173,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G173,VLOOKUP($R173,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G174,VLOOKUP($R174,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G174,VLOOKUP($R174,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G175,VLOOKUP($R175,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G175,VLOOKUP($R175,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G176,VLOOKUP($R176,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G176,VLOOKUP($R176,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G177,VLOOKUP($R177,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G177,VLOOKUP($R177,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G178,VLOOKUP($R178,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G178,VLOOKUP($R178,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G179,VLOOKUP($R179,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G179,VLOOKUP($R179,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G180,VLOOKUP($R180,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G180,VLOOKUP($R180,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G181,VLOOKUP($R181,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G181,VLOOKUP($R181,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G182,VLOOKUP($R182,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G182,VLOOKUP($R182,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G183,VLOOKUP($R183,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G183,VLOOKUP($R183,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G184,VLOOKUP($R184,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G184,VLOOKUP($R184,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G185,VLOOKUP($R185,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G185,VLOOKUP($R185,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G186,VLOOKUP($R186,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G186,VLOOKUP($R186,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G187,VLOOKUP($R187,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G187,VLOOKUP($R187,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G188,VLOOKUP($R188,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G188,VLOOKUP($R188,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G189,VLOOKUP($R189,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G189,VLOOKUP($R189,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G190,VLOOKUP($R190,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G190,VLOOKUP($R190,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G191,VLOOKUP($R191,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G191,VLOOKUP($R191,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G192,VLOOKUP($R192,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G192,VLOOKUP($R192,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G193,VLOOKUP($R193,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G193,VLOOKUP($R193,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G194,VLOOKUP($R194,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G194,VLOOKUP($R194,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G195,COUNTIF($Q:$Q,$Q195),0)","v":0},"",{"$f":"IF($G195,VLOOKUP($R195,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G195,VLOOKUP($R195,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,{"$f":"IF($G195,1/$A195,0)","v":0},"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M195&\"&CandidateUpdateCode=\"&BG195&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G196,VLOOKUP($R196,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G196,VLOOKUP($R196,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G197,VLOOKUP($R197,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G197,VLOOKUP($R197,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G198,VLOOKUP($R198,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G198,VLOOKUP($R198,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G199,VLOOKUP($R199,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G199,VLOOKUP($R199,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G200,VLOOKUP($R200,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G200,VLOOKUP($R200,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G201,VLOOKUP($R201,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G201,VLOOKUP($R201,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G202,VLOOKUP($R202,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G202,VLOOKUP($R202,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G203,VLOOKUP($R203,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G203,VLOOKUP($R203,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G204,VLOOKUP($R204,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G204,VLOOKUP($R204,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G205,VLOOKUP($R205,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G205,VLOOKUP($R205,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G206,VLOOKUP($R206,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G206,VLOOKUP($R206,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G207,VLOOKUP($R207,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G207,VLOOKUP($R207,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G208,VLOOKUP($R208,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G208,VLOOKUP($R208,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G209,VLOOKUP($R209,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G209,VLOOKUP($R209,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G210,VLOOKUP($R210,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G210,VLOOKUP($R210,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G211,VLOOKUP($R211,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G211,VLOOKUP($R211,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G212,VLOOKUP($R212,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G212,VLOOKUP($R212,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G213,VLOOKUP($R213,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G213,VLOOKUP($R213,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G214,VLOOKUP($R214,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G214,VLOOKUP($R214,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G215,VLOOKUP($R215,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G215,VLOOKUP($R215,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G216,IFERROR(VLOOKUP(Q216,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G216,VLOOKUP($R216,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G216,VLOOKUP($R216,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G216,IF(R216=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G216,IF(AU216=\"\",0,1)+IF(AZ216=\"\",0,1)+IF(BE216=\"\",0,1),\"\")","v":""},{"$f":"IF(M216=\"\",0,1)","v":0},0,{"$f":"IF($G216,IF(ISBLANK(T216),\"?\",DAYS360(T216,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G217,VLOOKUP($R217,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G217,VLOOKUP($R217,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G218,VLOOKUP($R218,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G218,VLOOKUP($R218,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G219,VLOOKUP($R219,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G219,VLOOKUP($R219,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G220,VLOOKUP($R220,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G220,VLOOKUP($R220,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G221,VLOOKUP($R221,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G221,VLOOKUP($R221,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G222,VLOOKUP($R222,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G222,VLOOKUP($R222,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G223,VLOOKUP($R223,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G223,VLOOKUP($R223,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G224,VLOOKUP($R224,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G224,VLOOKUP($R224,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G225,VLOOKUP($R225,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G225,VLOOKUP($R225,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G226,VLOOKUP($R226,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G226,VLOOKUP($R226,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G227,VLOOKUP($R227,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G227,VLOOKUP($R227,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G228,VLOOKUP($R228,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G228,VLOOKUP($R228,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G229,VLOOKUP($R229,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G229,VLOOKUP($R229,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G230,VLOOKUP($R230,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G230,VLOOKUP($R230,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G231,VLOOKUP($R231,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G231,VLOOKUP($R231,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G232,VLOOKUP($R232,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G232,VLOOKUP($R232,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G233,VLOOKUP($R233,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G233,VLOOKUP($R233,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G234,VLOOKUP($R234,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G234,VLOOKUP($R234,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G235,VLOOKUP($R235,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G235,VLOOKUP($R235,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G236,VLOOKUP($R236,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G236,VLOOKUP($R236,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G237,VLOOKUP($R237,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G237,VLOOKUP($R237,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G238,VLOOKUP($R238,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G238,VLOOKUP($R238,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G239,VLOOKUP($R239,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G239,VLOOKUP($R239,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G240,VLOOKUP($R240,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G240,VLOOKUP($R240,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G241,VLOOKUP($R241,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G241,VLOOKUP($R241,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G242,VLOOKUP($R242,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G242,VLOOKUP($R242,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G243,VLOOKUP($R243,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G243,VLOOKUP($R243,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G244,VLOOKUP($R244,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G244,VLOOKUP($R244,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G245,VLOOKUP($R245,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G245,VLOOKUP($R245,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G246,VLOOKUP($R246,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G246,VLOOKUP($R246,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G247,VLOOKUP($R247,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G247,VLOOKUP($R247,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G248,VLOOKUP($R248,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G248,VLOOKUP($R248,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G249,VLOOKUP($R249,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G249,VLOOKUP($R249,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G250,VLOOKUP($R250,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G250,VLOOKUP($R250,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G251,VLOOKUP($R251,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G251,VLOOKUP($R251,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G252,VLOOKUP($R252,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G252,VLOOKUP($R252,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G253,VLOOKUP($R253,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G253,VLOOKUP($R253,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G254,VLOOKUP($R254,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G254,VLOOKUP($R254,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G255,VLOOKUP($R255,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G255,VLOOKUP($R255,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G256,VLOOKUP($R256,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G256,VLOOKUP($R256,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G257,VLOOKUP($R257,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G257,VLOOKUP($R257,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G258,VLOOKUP($R258,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G258,VLOOKUP($R258,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G259,COUNTIF($Q:$Q,$Q259),0)","v":0},"",{"$f":"IF($G259,VLOOKUP($R259,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G259,VLOOKUP($R259,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,{"$f":"IF($G259,1/$A259,0)","v":0},"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M259&\"&CandidateUpdateCode=\"&BG259&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G260,VLOOKUP($R260,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G260,VLOOKUP($R260,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G261,VLOOKUP($R261,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G261,VLOOKUP($R261,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G262,VLOOKUP($R262,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G262,VLOOKUP($R262,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G263,VLOOKUP($R263,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G263,VLOOKUP($R263,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G264,VLOOKUP($R264,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G264,VLOOKUP($R264,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G265,VLOOKUP($R265,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G265,VLOOKUP($R265,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G266,VLOOKUP($R266,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G266,VLOOKUP($R266,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G267,VLOOKUP($R267,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G267,VLOOKUP($R267,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G268,VLOOKUP($R268,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G268,VLOOKUP($R268,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G269,VLOOKUP($R269,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G269,VLOOKUP($R269,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G270,VLOOKUP($R270,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G270,VLOOKUP($R270,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G271,VLOOKUP($R271,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G271,VLOOKUP($R271,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G272,VLOOKUP($R272,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G272,VLOOKUP($R272,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G273,VLOOKUP($R273,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G273,VLOOKUP($R273,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G274,VLOOKUP($R274,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G274,VLOOKUP($R274,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G275,VLOOKUP($R275,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G275,VLOOKUP($R275,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G276,VLOOKUP($R276,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G276,VLOOKUP($R276,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G277,VLOOKUP($R277,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G277,VLOOKUP($R277,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G278,VLOOKUP($R278,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G278,VLOOKUP($R278,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G279,VLOOKUP($R279,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G279,VLOOKUP($R279,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G280,IFERROR(VLOOKUP(Q280,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G280,VLOOKUP($R280,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G280,VLOOKUP($R280,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G280,IF(R280=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G280,IF(AU280=\"\",0,1)+IF(AZ280=\"\",0,1)+IF(BE280=\"\",0,1),\"\")","v":""},{"$f":"IF(M280=\"\",0,1)","v":0},0,{"$f":"IF($G280,IF(ISBLANK(T280),\"?\",DAYS360(T280,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G281,VLOOKUP($R281,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G281,VLOOKUP($R281,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G282,VLOOKUP($R282,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G282,VLOOKUP($R282,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G283,VLOOKUP($R283,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G283,VLOOKUP($R283,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G284,VLOOKUP($R284,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G284,VLOOKUP($R284,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G285,VLOOKUP($R285,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G285,VLOOKUP($R285,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G286,VLOOKUP($R286,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G286,VLOOKUP($R286,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G287,VLOOKUP($R287,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G287,VLOOKUP($R287,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G288,VLOOKUP($R288,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G288,VLOOKUP($R288,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G289,VLOOKUP($R289,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G289,VLOOKUP($R289,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G290,VLOOKUP($R290,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G290,VLOOKUP($R290,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G291,VLOOKUP($R291,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G291,VLOOKUP($R291,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G292,VLOOKUP($R292,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G292,VLOOKUP($R292,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G293,VLOOKUP($R293,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G293,VLOOKUP($R293,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G294,VLOOKUP($R294,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G294,VLOOKUP($R294,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G295,VLOOKUP($R295,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G295,VLOOKUP($R295,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G296,VLOOKUP($R296,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G296,VLOOKUP($R296,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G297,VLOOKUP($R297,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G297,VLOOKUP($R297,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G298,VLOOKUP($R298,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G298,VLOOKUP($R298,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G299,VLOOKUP($R299,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G299,VLOOKUP($R299,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G300,VLOOKUP($R300,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G300,VLOOKUP($R300,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G301,VLOOKUP($R301,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G301,VLOOKUP($R301,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G302,VLOOKUP($R302,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G302,VLOOKUP($R302,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G303,VLOOKUP($R303,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G303,VLOOKUP($R303,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G304,VLOOKUP($R304,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G304,VLOOKUP($R304,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G305,VLOOKUP($R305,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G305,VLOOKUP($R305,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G306,VLOOKUP($R306,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G306,VLOOKUP($R306,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G307,VLOOKUP($R307,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G307,VLOOKUP($R307,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G308,VLOOKUP($R308,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G308,VLOOKUP($R308,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G309,VLOOKUP($R309,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G309,VLOOKUP($R309,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G310,VLOOKUP($R310,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G310,VLOOKUP($R310,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G311,VLOOKUP($R311,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G311,VLOOKUP($R311,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G312,VLOOKUP($R312,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G312,VLOOKUP($R312,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G313,VLOOKUP($R313,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G313,VLOOKUP($R313,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G314,VLOOKUP($R314,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G314,VLOOKUP($R314,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G315,VLOOKUP($R315,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G315,VLOOKUP($R315,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G316,VLOOKUP($R316,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G316,VLOOKUP($R316,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G317,VLOOKUP($R317,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G317,VLOOKUP($R317,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G318,VLOOKUP($R318,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G318,VLOOKUP($R318,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G319,VLOOKUP($R319,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G319,VLOOKUP($R319,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G320,VLOOKUP($R320,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G320,VLOOKUP($R320,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G321,VLOOKUP($R321,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G321,VLOOKUP($R321,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G322,VLOOKUP($R322,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G322,VLOOKUP($R322,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G323,COUNTIF($Q:$Q,$Q323),0)","v":0},"",{"$f":"IF($G323,VLOOKUP($R323,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G323,VLOOKUP($R323,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,{"$f":"IF($G323,1/$A323,0)","v":0},"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M323&\"&CandidateUpdateCode=\"&BG323&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G324,VLOOKUP($R324,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G324,VLOOKUP($R324,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G325,VLOOKUP($R325,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G325,VLOOKUP($R325,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G326,VLOOKUP($R326,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G326,VLOOKUP($R326,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G327,VLOOKUP($R327,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G327,VLOOKUP($R327,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G328,VLOOKUP($R328,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G328,VLOOKUP($R328,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G329,VLOOKUP($R329,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G329,VLOOKUP($R329,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G330,VLOOKUP($R330,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G330,VLOOKUP($R330,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G331,VLOOKUP($R331,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G331,VLOOKUP($R331,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G332,VLOOKUP($R332,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G332,VLOOKUP($R332,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G333,VLOOKUP($R333,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G333,VLOOKUP($R333,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G334,VLOOKUP($R334,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G334,VLOOKUP($R334,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G335,VLOOKUP($R335,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G335,VLOOKUP($R335,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G336,VLOOKUP($R336,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G336,VLOOKUP($R336,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G337,VLOOKUP($R337,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G337,VLOOKUP($R337,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G338,VLOOKUP($R338,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G338,VLOOKUP($R338,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G339,VLOOKUP($R339,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G339,VLOOKUP($R339,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G340,VLOOKUP($R340,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G340,VLOOKUP($R340,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G341,IFERROR(VLOOKUP(Q341,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G341,VLOOKUP($R341,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G341,VLOOKUP($R341,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G341,IF(R341=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G341,IF(AU341=\"\",0,1)+IF(AZ341=\"\",0,1)+IF(BE341=\"\",0,1),\"\")","v":""},{"$f":"IF(M341=\"\",0,1)","v":0},0,{"$f":"IF($G341,IF(ISBLANK(T341),\"?\",DAYS360(T341,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G342,VLOOKUP($R342,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G342,VLOOKUP($R342,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G343,VLOOKUP($R343,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G343,VLOOKUP($R343,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G344,VLOOKUP($R344,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G344,VLOOKUP($R344,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G345,VLOOKUP($R345,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G345,VLOOKUP($R345,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G346,VLOOKUP($R346,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G346,VLOOKUP($R346,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G347,VLOOKUP($R347,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G347,VLOOKUP($R347,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G348,VLOOKUP($R348,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G348,VLOOKUP($R348,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G349,VLOOKUP($R349,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G349,VLOOKUP($R349,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G350,VLOOKUP($R350,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G350,VLOOKUP($R350,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G351,VLOOKUP($R351,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G351,VLOOKUP($R351,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G352,VLOOKUP($R352,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G352,VLOOKUP($R352,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G353,VLOOKUP($R353,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G353,VLOOKUP($R353,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G354,VLOOKUP($R354,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G354,VLOOKUP($R354,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G355,VLOOKUP($R355,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G355,VLOOKUP($R355,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G356,VLOOKUP($R356,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G356,VLOOKUP($R356,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"," "]
[0,"",{"$f":"IF($G357,VLOOKUP($R357,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G357,VLOOKUP($R357,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G358,VLOOKUP($R358,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G358,VLOOKUP($R358,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G359,VLOOKUP($R359,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G359,VLOOKUP($R359,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G360,VLOOKUP($R360,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G360,VLOOKUP($R360,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G361,VLOOKUP($R361,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G361,VLOOKUP($R361,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G362,VLOOKUP($R362,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G362,VLOOKUP($R362,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G363,VLOOKUP($R363,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G363,VLOOKUP($R363,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G364,VLOOKUP($R364,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G364,VLOOKUP($R364,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G365,VLOOKUP($R365,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G365,VLOOKUP($R365,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G366,VLOOKUP($R366,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G366,VLOOKUP($R366,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G367,VLOOKUP($R367,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G367,VLOOKUP($R367,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G368,VLOOKUP($R368,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G368,VLOOKUP($R368,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,{"$f":"IF($G369,IFERROR(VLOOKUP(Q369,mult,8,FALSE),\"\"),\"\")","v":""},{"$f":"IF($G369,VLOOKUP($R369,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G369,VLOOKUP($R369,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},{"$f":"IF($G369,IF(R369=\"Denmark\",\"Denmark\",\"Abroad\"),\"\")","v":""},{"$f":"IF($G369,IF(AU369=\"\",0,1)+IF(AZ369=\"\",0,1)+IF(BE369=\"\",0,1),\"\")","v":""},{"$f":"IF(M369=\"\",0,1)","v":0},0,{"$f":"IF($G369,IF(ISBLANK(T369),\"?\",DAYS360(T369,NOW())/360),\"\")","v":""},"Docs"]
[0,"",{"$f":"IF($G370,VLOOKUP($R370,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G370,VLOOKUP($R370,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G371,VLOOKUP($R371,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G371,VLOOKUP($R371,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G372,VLOOKUP($R372,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G372,VLOOKUP($R372,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G373,VLOOKUP($R373,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G373,VLOOKUP($R373,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G374,VLOOKUP($R374,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G374,VLOOKUP($R374,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G375,VLOOKUP($R375,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G375,VLOOKUP($R375,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G376,VLOOKUP($R376,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G376,VLOOKUP($R376,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G377,VLOOKUP($R377,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G377,VLOOKUP($R377,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G378,VLOOKUP($R378,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G378,VLOOKUP($R378,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G379,VLOOKUP($R379,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G379,VLOOKUP($R379,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G380,VLOOKUP($R380,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G380,VLOOKUP($R380,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G381,VLOOKUP($R381,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G381,VLOOKUP($R381,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G382,VLOOKUP($R382,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G382,VLOOKUP($R382,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G383,VLOOKUP($R383,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G383,VLOOKUP($R383,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G384,VLOOKUP($R384,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G384,VLOOKUP($R384,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G385,VLOOKUP($R385,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G385,VLOOKUP($R385,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G386,VLOOKUP($R386,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G386,VLOOKUP($R386,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[{"$f":"IF($G387,COUNTIF($Q:$Q,$Q387),0)","v":0},"",{"$f":"IF($G387,VLOOKUP($R387,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G387,VLOOKUP($R387,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,{"$f":"IF($G387,1/$A387,0)","v":0},"",{"$f":"HYPERLINK(\"https://app.researchplanner.net/Peoplexs22/eFormportal/eForm.cfm?CandidateUpdateID=\"&M387&\"&CandidateUpdateCode=\"&BG387&\"&Locale=en&CustomFormID=11612\",\"Docs\")","v":"Docs"}]
[0,"",{"$f":"IF($G388,VLOOKUP($R388,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G388,VLOOKUP($R388,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G389,VLOOKUP($R389,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G389,VLOOKUP($R389,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G390,VLOOKUP($R390,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G390,VLOOKUP($R390,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G391,VLOOKUP($R391,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G391,VLOOKUP($R391,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G392,VLOOKUP($R392,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G392,VLOOKUP($R392,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G393,VLOOKUP($R393,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G393,VLOOKUP($R393,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G394,VLOOKUP($R394,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G394,VLOOKUP($R394,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G395,VLOOKUP($R395,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G395,VLOOKUP($R395,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G396,VLOOKUP($R396,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G396,VLOOKUP($R396,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G397,VLOOKUP($R397,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G397,VLOOKUP($R397,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G398,VLOOKUP($R398,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G398,VLOOKUP($R398,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G399,VLOOKUP($R399,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G399,VLOOKUP($R399,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]
[0,"",{"$f":"IF($G400,VLOOKUP($R400,'Country codes'!$A$1:$E$247,4,FALSE),\"\")","v":""},{"$f":"IF($G400,VLOOKUP($R400,'Country codes'!$A$1:$E$247,5,FALSE),\"\")","v":""},"","",0,0,"","Docs"]

{"sheet":"Country codes","index":4,"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":5,"n_rows":80,"n_cols":5,"rows_kept":80,"merged":[[1,0,1,1],[1,3,1,4]]}
[]
["Genering af rapport i PhD Planneren samt efterfølgende behandling af data i excel ",null,null,"Kopi af Data-fanebladet til udsplitning og upload på de enkelte programopslag"]
[]
["1.","I PhD Planneren:",null,"10.","I det samlede regneark:"]
[null,"a: Tjek at alle programopslag har status \"Awaits prog. assessment\"",null,null,"a: Højreklik på fanebladet \"Data\" og vælg \"Move or Copy...\""]
[null,"b: Vælg \"Kampagnestyring\" » \"Rapporter og diagrammer\"",null,null,"b: Vælg To book: \"(new book)\""]
[null,"c: Kør rapporten \"Application Data\" i mappen PHD",null,null,"c: Sæt kryds i \"Create a copy\""]
[null,"d: Åbn regnearket",null,null,"d: Tryk \"OK\""]
[]
["2.","Åbn \"Template for Application Data\" ",null,"11.","Gem det nye regneark"]
[]
["3.","I regnearket fra PhD Planneren:",null,"12.","I det nye regneark:"]
[null,"a: Højreklik på fanebladet og vælg \"Move or Copy...\"",null,null,"a: Udpeg hele søjle I: Age"]
[null,"b: Vælg To book: \"Template for Application Data\"",null,null,"b: Kopier den - tryk <ctrl> + c"]
[null,"c: Vælg Before sheet: \"Country Codes\"",null,null,"c: Højreklik og vælg \"Paste Speciel…\" » \"Values (V)\""]
[null,"d: Tryk \"OK\"",null,null,"    ELLER"]
[{"$nulls":4},"    Klik på \"Paste\"-knappen på Home-fanen øverst og vælg \"Values (V)\" "]
[null,"Fanebladet i regnearket fra PhD Planneren flyttes nu ind i \"Template for Application Data\", og der arbejdes videre i \"Template for Application Data\":",null,null,"    (Ligesom i punkt 6)\nd: Tryk \"OK\""]
[]
["4.","På fanebladet \"Report-X\" vælges alle celler fra og med cellerne i den første blå række til, men ikke med cellerne i den sidste blå række. \nBrug musen eller til at udpege området. Eller brug tastaturet således:",null,"13.","Slet søjle A-H. Dvs. til, men ikke med Age-kolonnen.\nAge er nu blevet til søjle A"]
[null,"a: Udpeg den blå celle \"Company name\" (A5)",null,"14.","Hvis ikke der allerede er filtre på kolonnerne, gør således for at aktivere filtrene:"]
[null,"b: Hold <ctrl>+<Skift> nede og tryk på højre pil",null,null,"Marker celle A1 (Age-cellen):"]
[null,"c: Behold <ctrl>+<Skift> nede og tryk på pil ned",null,null,"a: Klik på celle A1 for at markere den"]
[null,"d: Behold <skift> nede, slip <ctrl> og tryk pil op",null,null,"b: Klik på Data-fanen foroven og klik på \"Filter\"-knappen"]
[]
["5.","Kopier det markerede område - tryk <ctrl> + c"]
[]
["6.","Dataene fra fanebladet \"Report-X\" skal nu indsættes på fanebladet \"Data\":"]
[null,"a: Klik på fanebladet \"Data\" på den grønne celle \"Company name\""]
[null,"b: Højreklik og vælg \"Paste Speciel…\" » \"Values (V)\""]
[null,"    ELLER"]
[null,"    Klik på \"Paste\"-knappen på Home-fanen øverst og vælg \"Values (V)\"",null,null,"Der kommer nu pile ved siden af overskrifterne i række 1. Pilene indikerer at man kan  "]
[{"$nulls":4},"sortere værdierne i kolonnerne."]
[]
[]
[{"$nulls":3},"15.","Hvis ikke den øverst række allerede er fastlås, gør således for at fastlåse den:"]
[{"$nulls":4},"a: Klik på View-fanen øverst, klik på \"Freeze Panes\" » \"Freeze Top Row\" "]
{"$rows_empty":13}
[{"$nulls":4},"Den øverste række kan nu ses, ligegyldigt hvor langt der scrolles ned."]
[]
[{"$nulls":3},"16.","Slet evt søjler der ikke skal bruges. \nMen slet under ingen omstædigheder søjlerne Docs og UpdateCode!!!!"]
[null,"Tjek, at kolonnerne A-J er fyldt ud for alle ansøgere. Hvis ikke, så marker den ",null,null,"Hvis de slettes, kan man ikke klikke på Docs og se vedhæftninger."]
[null,"nederste udfyldte række. Placér musen nederst til højre i markeringen, der kommer et plus "]
[null,"frem, og dobbeltklik så.",null,"17.","Gem regnearket"]
[]
[{"$nulls":3},"18.","Klip hvert programs ansøgere ud i et separat excelark:"]
[{"$nulls":4},"For hvert program:"]
[{"$nulls":4},"a: Klik på pilen ved siden af Vacancy » Vælg programmet » Tryk \"OK\""]
[]
[]
[]
[]
["7.","Klik på Data-fanen øverst, og tryk \"Refresh All\"."]
{"$rows_empty":8}
["8.","Tjek at tabellerne på de første tre faneblade (Application statistics, Gender statistics og ",null,null,"b: Marker alle rækkerne inklusiv den øverste med overskrifterne"]
[null,"Mulitple Apps) er blevet opdateret.",null,null,"c: Tryk <ctrl> + c for at kopiere dem"]
["9.","Gem regnearket",null,null,"d: Åbn et nyt regneark"]
[{"$nulls":4},"e: Klik på celle A1 i det nye regneark"]
[null,"BEMÆRK:\nRapporten medtager ikke ansøgere med status: \"Legal rejected\"\nProgrammer uden ansøgere medtages ikke i rapporten",null,null,"f: Tryk <ctrl> + v for at indsætte programmets data \nDet kan være nødvendigt at indsætte med Keep Source formatting, for at Docs-links virker:  Højreklik i celle A1 og vælg \"Paste Speciel…\" » Keep Source Formatting."]
[{"$nulls":4},"g: Indsæt evt. filtre ligesom i punkt 14"]
[{"$nulls":4},"h: Gem regnearket - navngiv det med programmets navn"]