{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Publication","ScienceEvent","SH_Engage","Dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":20,"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":"Publication","index":0,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3]]}
["Project Name:"]
["No. (cont.)","First author name\n[Name, Initials]","Year\n[YYYY]","Title","Journal / Book Title / …","Publication type","DOI /ISBN / …","URL","Publication status","EJP SOIL acknowledged","Partners involved (organisation short name / acronym)","Countries outside consortium involved (use 2 letter code)","Open access (OA)  ","Comments"]
["Example 1","Doe, J.",2024,"This is an example ","Template","Article",38246396,null,"under review","Yes","P1, P2, P5","US, PL, UK","no OA, specify reasons in 'comments'","This is an example, please delete before submission"]

{"sheet":"ScienceEvent","index":1,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,2,0,4]]}
["Project Name:"]
["No. (cont.)","Name of Scientific Event","Type of event","Start date of event\n[dd.mm.yyyy]","Last date of event\n[dd.mm.yyyy]","Event organised by project consortium member?","Presenter(s)/ organiser (s)\n[Name, Initials]","Dissemination to Scientific Community","If applicable: DOI, ISBN, URL etc","2021 joint call acknowledged","Partners involved (organisation short name / acronym)","Scale of event / audience (please give further details in 'comments')","Countries outside consortium involved (use 2 letter code)","Comments"]
[1,"This is an example event","Science fair","2023-03-01","2023-03-04",null,"John Doe","Oral presentations at scientific congress","G) Oral presentations at scientific congress","Yes","P1, P5","National","ES, DE","This is an example, please delete before submission"]

{"sheet":"SH_Engage","index":2,"n_rows":18,"n_cols":31,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,5,0,12],[0,24,0,30],[0,2,0,4]]}
["Project Name:",{"$nulls":4},"You can find categories of stakeholders in Column Y -AE",{"$nulls":18},"Stakeholder Categories"]
["No. (cont.)","Type/event","Time frame (before project start, during project, after project…)","Date [dd.mm.yyyy]","Level of engagement","Primary audience / type of stakeholder (main category)","Primary audience / type of stakeholder - \nspecify","No of people (primary audience) reached (estimation)","primary audience = part of project consortium?","Secondary audience / type of stakeholder","Secondary audience / type of stakeholder - \nspecify","No of people (secondary audience) reached (estimation)","secondary audience = part of project consortium?","Name of organisation(s) (e.g. company name) or stakeholder (no personal details!)","Scale","Material targeted to respective stakeholder (policy briefs, practice briefs, other); please list and indicate number","Material number","Expected Impact ON AUDIENCE (not on your project)","Link to webpage or document","Partners involved (organisation short name / acronym)","Description\n(e.g. meeting with local advicors to inform about project results; provision of data by stakeholders, use of field/experiments allowed by stakeholders, involvement of stakeholders through participatory meetings, interviews)","Comments",null,null,"Government_Policy","ServiceProviders_Associations_NGOs","Industry / private sector","Research","Environment and agriculture","Education","General Public"]
[1,"Seminar / symposium","during the project","2023-01-01","information","Government_Policy","Government (e.g. ministry)","21-50","No","Industry_PrivateSector","Agri-business","1-20","No","federal ministry for education and research Germany, Bayer, local farmers, local public","National","Brochure, flyer",40,"Gain of knowledge",null,"P1, P5","Workshop (Oct 2019) to inform parties about project and possible benefits of application of our developed harvesting method",null,null,null,"Government/Policy","advisory services, general","Aerospace","Industrial Research","Farmers (crops&plants)","Pre-school","Associations"]
[{"$nulls":24},"Government (e.g. ministry)","Agricultural advisory services / extension services","Agri-business","Public and private research institutions and universities","Farmers (fisheries)","Schools","Citizen"]
[{"$nulls":24},"Legislation ","Charity","Biotech industry","others","Farmers (forestry)","Students","Consumers"]
[{"$nulls":24},"Policy maker","Foundations","Breeders, animal/livestock",null,"Farmers (horticulture and landscaping )","Trainees, apprentices","Local communities"]
[{"$nulls":24},"Public administration / governmental authorities","Industry associations","Breeders, plant",null,"Farmers (livestock)","others","others"]
[{"$nulls":24},"Standardisation / certification","NGOs","Chemical Industry",null,"others"]
[{"$nulls":24},"others","Public associations","Computing, IT, AI"]
[{"$nulls":25},"others","Engineering companies"]
[{"$nulls":26},"Food industry"]
[{"$nulls":26},"Hospitality Sector"]
[{"$nulls":26},"Manufacturers"]
[{"$nulls":26},"Pharma industry"]
[{"$nulls":26},"Process engineering companies"]
[{"$nulls":26},"Retailers"]
[{"$nulls":26},"Seed companies"]
[{"$nulls":26},"others"]

{"sheet":"Dropdowns","index":3,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":true,"merged":[]}
[]
[null,"PublicationType","Article","Yes"]
[null,null,"Review","No"]
[null,null,"Proceeding Paper"]
[null,null,"Editorial Material"]
[null,null,"Letter"]
[null,null,"Book"]
[null,null,"Book Section /contribution to a book"]
[null,null,"Thesis"]
[null,null,"Others (please specify in 'comments')"]
[]
[]
[null,"Diss_to_Scientists","Oral presentations at scientific congress"]
[null,null,"Poster presentations at scientific congress"]
[null,null,"Other dissemination format to scientific community (specify in 'comments')"]
[]
[null,"ScienceEvent_type","Conference"]
[null,null,"Seminar / symposium"]
[null,null,"Workshop"]
[null,null,"Roundtable"]
[null,null,"Debate"]
[null,null,"Science fair"]
[null,null,"Open day"]
[null,null,"Talk, presentation"]
[null,null,"Other, please specify in comments"]
[]
[null,"Publication_Status","in preparation"]
[null,null,"submitted"]
[null,null,"under review"]
[null,null,"accepted, in press"]
[null,null,"published"]
[]
[null,"Outcomes","1. International patents obtained","=C140"]
[null,null,"2. International patents pending","=C141"]
[null,null,"3. National patents obtained","=C140"]
[null,null,"4. National patents pending","=C143"]
[null,null,"5. Operating licences (obtained / transferred)","=C144"]
[null,null,"6. pilots","=C137"]
[null,null,"7. new products and services","=C134","=C135"]
[null,null,"8. Software and any other prototype","=C132","=C136"]
[null,null,"8b. Database, model","=C130","=C133"]
[null,null,"9. Company creations or spin-offs","=C138"]
[null,null,"10. New collaborative projects - please fill in columns e) and g)","=C113"]
[null,null,"11. Scientific symposiums"]
[null,null,"12. Others (e.g. new project, new contract,…please specify in column g)"]
[]
[null,"Scale","Regional"]
[null,null,"National"]
[null,null,"European"]
[null,null,"International"]
[]
[null,"Level_of_engagement","information"]
[null,null,"consultation"]
[null,null,"involvement"]
[null,null,"collaboration"]
[]
[null,"timeframe","before the project"]
[null,null,"during the project"]
[null,null,"foreseen after the end of the project"]
[]
[null,"open_access","no OA, specify reasons in 'comments'"]
[null,null,"OA, green route"]
[null,null,"OA, gold route"]
[null,null,"N.A. please specify in 'comments'"]
[]
[null,"Event_type","Conference"]
[null,null,"Seminar / symposium"]
[null,null,"Workshop"]
[null,null,"Roundtable"]
[null,null,"Debate"]
[null,null,"Science fair"]
[null,null,"Open day"]
[null,null,"Interview for press/media"]
[null,null,"Talk, presentation"]
[null,null,"Consultation of stakeholders"]
[null,null,"Other"]
[]
[null,"Material","None"]
[null,"(=Material to reach audience)","Policy briefs"]
[null,null,"Practice briefs"]
[null,null,"Other briefs, articles"]
[null,null,"Brochure, flyer"]
[null,null,"Newsletter"]
[null,null,"Magazine, journal, press release"]
[null,null,"Broadcasts, e.g. Radio, TV, podcast "]
[null,null,"Social media, e.g. (project) webpage, twitter, knowledge incubator ...."]
[null,null,"Other"]
[]
[null,"Primary_audience","Government_Policy","Government_Policy","ServiceProviders_Associations_NGOs","Industry / private sector","Research","Environment and agriculture","Education","General Public"]
[null,null,"ServiceProviders_Associations_NGOs","Government/Policy","advisory services, general","Aerospace","Industrial Research","Farmers (crops&plants)","Pre-school","Associations"]
[null,null,"Industry_PrivateSector","Government (e.g. ministry)","Agricultural advisory services / extension services","Agri-business","Public and private research institutions and universities","Farmers (fisheries)","Schools","Citizen"]
[null,null,"Research","Legislation ","Charity","Biotech industry","others","Farmers (forestry)","Students","Consumers"]
[null,null,"Environment_Agriculture","Policy maker","Foundations","Breeders, animal/livestock",null,"Farmers (horticulture and landscaping )","Trainees, apprentices","Local communities"]
[null,null,"Education","Public administration / governmental authorities","Industry associations","Breeders, plant",null,"Farmers (livestock)","others","others"]
[null,null,"General_Public","Standardisation / certification","NGOs","Chemical Industry",null,"others"]
[null,null,null,"others","Public associations","Computing, IT, AI"]
[null,"Number_Audience","1-20",null,"others","Engineering companies"]
[null,null,"21-50",null,null,"Food industry"]
[null,null,"51-100",null,null,"Hospitality Sector"]
[null,null,"101-500",null,null,"Manufacturers"]
[null,null,"more than 500",null,null,"Pharma industry"]
[{"$nulls":5},"Process engineering companies"]
[{"$nulls":5},"Retailers"]
[null,"Expected_Impact","Decision influenced",null,null,"Seed companies"]
[null,null,"Technology / methodology applied",null,null,"others"]
[null,null,"New collaborative projects possible"]
[null,null,"Change of views / opinions"]
[null,null,"Gain of knowledge"]
[null,null,"Request for further information"]
[null,null,"Don't know "]
[null,null,"Other"]
[]
[null,"Grants_Awards_Fellowship_followUp","Grant"]
[null,null,"Fellowship"]
[null,null,"Prize"]
[null,null,"Award"]
[null,null,"Membership"]
[null,null,"Follow-up project"]
[]
[null,"Influence_Policy_Practice","Citation in policy documents"]
[null,null,"Citation in guidelines"]
[null,null,"Citation in systematic reviews"]
[null,null,"Support of governmental work /advisor"]
[null,null,"Act as advisor (non-governmental) "]
[null,null,"Influence of regulations"]
[null,null,"Harmonisation /standardisation of technologies"]
[null,null,"Harmonisation /standardisation of data"]
[null,null,"Other"]
[]
[null,"Biol_Chem_product","Cell line"]
[null,null,"Genotype"]
[null,null,"Seed"]
[null,null,"Microorganism (ie bacteria, archea,..)"]
[null,null,"Plant virus"]
[null,null,"Antiserum"]
[null,null,"Molecule"]
[null,null,"Compound"]
[null,null,"Other"]
[]
[null,"Software_Technology_Pilot","Database "]
[null,null,"Analysis"]
[null,null,"Software "]
[null,null,"Model"]
[null,null,"New product (non-biological)"]
[null,null,"New/ improved technique/ methodology"]
[null,null,"New / improved standard / regulation"]
[null,null,"New / improved service"]
[null,null,"Prototype"]
[null,null,"Pilots"]
[null,null,"Other"]
[]
[null,"IPR_Patent_License","International patents obtained"]
[null,null,"International patents pending"]
[null,null,"National patents obtained"]
[null,null,"National patents pending"]
[null,null,"Operating licences (obtained / transferred)"]
[null,null,"Copyright"]
[null,null,"Industrial design right"]
[null,null,"Plant variety"]
[null,null,"Trademark"]