{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["B2 ResearcherIDs","Confidential"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"B2 ResearcherIDs","index":0,"n_rows":55,"n_cols":26,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,25,1,27],[2,25,2,27],[1,11,1,16],[1,2,1,3],[1,4,1,10],[1,17,1,19],[1,20,1,23]]}
[]
[null,null,"Project Information",null,"B2 Teammember and their ResearcherIDs",{"$nulls":6},"B3 Teammembers working for the project",{"$nulls":5},"B4 Professional future",null,null,"B5 Start & end date and FTEs",{"$nulls":4},"^1 FTE means 1 person is working full-time for the entire project period;"]
[null,"Employee No","Project Acronym","Partner number ","First Name","Second Name","Teammember: Position ","ORCID","Scopus Author Identifier","Web of Science ResearcherID","Other (Please specify)","Initials","Gender","Position in the project","Explanation in case of *other","Existing / hired","Person months","Future position","Future Sector","Comment if *other","Start date","End date","Project length [months]","FTEs ^","Comments"]
[null,"Example:","MyProject","P1","Mickey","Mouse","Main contact person for this project","1234-5678-9101-1121",12345678901,"X-1234-1234",null,{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":"MiMo"},"Transgender","Leadership position",null,"Existing staff",12,"Leadership position","new organisation: education",null,"2025-01-01","2026-12-31",{"$f":"IF(OR(ISBLANK(U4), ISBLANK(V4)), \"Date missing\", DATEDIF(U4,V4,\"M\")+1)","v":24},{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W4,\"\")","v":0.5}]
[null,"Example:","MyProject","P2","Donald","Duck","Team member","0123-4567-8910-1112",1234567890,"X-0123-0123",null,{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":"DoDu"},"Prefer not to disclose","Recognised Researcher (R2)",null,"Newly hired ",24,"Entrepreneur","new organisation: industry",null,"2025-06-01","2028-05-31",{"$f":"IF(OR(ISBLANK(U5), ISBLANK(V5)), \"Date missing\", DATEDIF(U5,V5,\"M\")+1)","v":36},{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W5,\"\")","v":0.66666666666666663}]
[null,1,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W6,\"\")","v":""}]
[null,2,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W7,\"\")","v":""}]
[null,3,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W8,\"\")","v":""}]
[null,4,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W9,\"\")","v":""}]
[null,5,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W10,\"\")","v":""}]
[null,6,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W11,\"\")","v":""}]
[null,7,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W12,\"\")","v":""}]
[null,8,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W13,\"\")","v":""}]
[null,9,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W14,\"\")","v":""}]
[null,10,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W15,\"\")","v":""}]
[null,11,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W16,\"\")","v":""}]
[null,12,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W17,\"\")","v":""}]
[null,13,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W18,\"\")","v":""}]
[null,14,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W19,\"\")","v":""}]
[null,15,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W20,\"\")","v":""}]
[null,16,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W21,\"\")","v":""}]
[null,17,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W22,\"\")","v":""}]
[null,18,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W23,\"\")","v":""}]
[null,19,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W24,\"\")","v":""}]
[null,20,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W25,\"\")","v":""}]
[null,21,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W26,\"\")","v":""}]
[null,22,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W27,\"\")","v":""}]
[null,23,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W28,\"\")","v":""}]
[null,24,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W29,\"\")","v":""}]
[null,25,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W30,\"\")","v":""}]
[null,26,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W31,\"\")","v":""}]
[null,27,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W32,\"\")","v":""}]
[null,28,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W33,\"\")","v":""}]
[null,29,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W34,\"\")","v":""}]
[null,30,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W35,\"\")","v":""}]
[null,31,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},{"$f":"IF(OR(ISBLANK(U36), ISBLANK(V36)), \"Date missing\", DATEDIF(U36,V36,\"M\")+1)","v":"Date missing"},{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W36,\"\")","v":""}]
[null,32,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W37,\"\")","v":""}]
[null,33,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W38,\"\")","v":""}]
[null,34,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W39,\"\")","v":""}]
[null,35,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W40,\"\")","v":""}]
[null,36,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W41,\"\")","v":""}]
[null,37,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W42,\"\")","v":""}]
[null,38,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W43,\"\")","v":""}]
[null,39,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W44,\"\")","v":""}]
[null,40,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W45,\"\")","v":""}]
[null,41,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W46,\"\")","v":""}]
[null,42,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W47,\"\")","v":""}]
[null,43,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W48,\"\")","v":""}]
[null,44,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W49,\"\")","v":""}]
[null,45,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W50,\"\")","v":""}]
[null,46,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W51,\"\")","v":""}]
[null,47,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W52,\"\")","v":""}]
[null,48,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W53,\"\")","v":""}]
[null,49,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W54,\"\")","v":""}]
[null,50,{"$nulls":9},{"$f":"LEFT(ResID[[#This Row],[First Name]],2)&LEFT(ResID[[#This Row],[Second Name]],2)","v":""},{"$nulls":10},"Date missing",{"$f":"IFERROR(ResID[[#This Row],[Person months]]/W55,\"\")","v":""}]

{"sheet":"Confidential","index":1,"n_rows":75,"n_cols":2,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
[]
["Gender","Woman"]
[null,"Man"]
[null,"Transgender"]
[null,"Additional gender category/identity"]
[null,"Prefer not to disclose"]
[null,"N/A"]
[]
["Position in the project","Entrepreneur"]
[null,"Leadership position"]
[null,"Leading Researcher (R4) "]
[null,"Established Researcher (R3)"]
[null,"Recognised Researcher (R2)"]
[null,"PhD student"]
[null,"Master's student"]
[null,"Bachelor student"]
[null,"Support and/or technical staff"]
[null,"Other*"]
[]
["Exisiting / hired","Newly hired "]
[null,"Existing staff"]
[]
["Yes/No","Yes"]
[null,"No"]
[]
["Professional future","Entrepreneur"]
[null,"Leadership position"]
[null,"Leading Researcher (R4) "]
[null,"Established Researcher (R3)"]
[null,"Recognised Researcher (R2)"]
[null,"PhD student"]
[null,"Master's student"]
[null,"Bachelor student"]
[null,"Support and/or technical staff"]
[null,"Between jobs"]
[null,"Without any news"]
[null,"Other*"]
[null,"N/A"]
[]
["Sector","Same organisation: permanent position "]
[null,"Same organisation: temporary position"]
[null,"New organisation: industry"]
[null,"New organisation: academia"]
[null,"New organisation: public sector"]
[null,"New organisation: education"]
[null,"Other*"]
[]
["Location","in same country*"]
[null,"abroad, European*"]
[null,"abroad, non-European*"]
[]
["Position","Main contact person for this project"]
[null,"PI / Group Leader"]
[null,"Team member"]
[]
["Partner #","P1"]
[null,"P2"]
[null,"P3"]
[null,"P4"]
[null,"P5"]
[null,"P6"]
[null,"P7"]
[null,"P8"]
[null,"P9"]
[null,"P10"]
[null,"P11"]
[null,"P12"]
[]
[]
["Project Acronym","AGROSOIL"]
[null,"CerealBio"]
[null,"CROP BOOSTERS"]
[null,"FarmScan"]
[null,"MethTrack"]
[null,"ORACLE"]