{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Bf3p1","Projects","Definition & Examples","BackEnd","Lists","Help"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Bf3p1","index":0,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Numéro du bridge","Données de base","Total courant","Résultats intermédiaires","Données support","Données positives au dessus","Données positives au dessous","Données négatives au dessus","Données négatives au dessous","Position des labels","Texte des labels","ymin pour le bridge courant","Numéro du bridge courant","Numéro de la ligne courante"]

{"sheet":"Projects","index":1,"n_rows":499,"n_cols":12,"rows_kept":499,"cut":false,"hidden":false,"merged":[[13,1,13,7],[7,1,7,2],[26,1,26,6]]}
[]
[null,"Transparency Declaration 2019 - Interactions with Patient Groups"]
[]
[]
[]
[]
[null,"Please enter your Country OR Global Division/Function"]
[null,"Austria/Public Affairs and Patient Advocacy"]
[]
[null,"Display/Hide Patient Group Definition & General Instructions",null,"+"]
[]
[null,"Patient Group Definition"]
[]
[null,"Patient Groups include patient associations. They are organisations which focus on specific diseases or aspects of healthcare, representing and/or supporting the needs of patients and/or caregivers. These groups are mainly composed of patients and or caregivers (family/friends), but can also be composed of consumers, seniors, women, minority populations or caregivers and may be led by advocacy professionals who may or may not have personal association with a given disease. Note some associations can be both a Medical or Scientific Association and  a Patient Association in different parts (e.g. national/international vs. local), in this case it will be considered as one or the other based upon whether an activity or event is largely planned and intended for Health Care Professionals or patients. For the purposes of this exercise the \"patient\" activities/events should be included."]
[]
[null,"General Instructions"]
[]
[null,"For each project, all fields should be completed. A red \"X\" in column A indicates that some fields are missing. Please make sure you fix any rows that have an red \"X\" in them.  All rows with information in them need to be completed , without an red \"X\".  "]
[null,"All activities commissioned during 2017 should be listed with a separate entry for each interaction."]
[null,"For multiple year projects initiated prior to 2018 where payments have been made in 2017, these payments should be included with the sum of payment for 2018."]
[null,"Do not leave blank rows between projects."]
[null,"For Financial support (Direct) in European affiliates, we recommend you consult your affiliate NAYA transparency officer to extract and provide you with direct payments (SAP expenses), from the NAYA EU Platform (tagged “YV48_ HCO PatientAssociatÂ°)"]
[]
[null,"Help for specific columns will automatically appear in the blue section below by clicking on any column",null,null,null,null,2]
[]
[null,{"$f":"IFERROR(INDEX(HelpTitles,MATCH(ProjectsCurrentColumn,HelpColumns,0)),\"\")","v":"Patient Group Headquarters"}]
[null,{"$f":"IFERROR(INDEX(HelpMessages,MATCH(ProjectsCurrentColumn,HelpColumns,0)),\"\")","v":"Please enter Country where Patient Group HQ is located. If group is Pan-European or International in remit, enter \"Pan-European\" or \"International\" as the Geography irrespective of specific HQ location."},null,null,null,null,null,{"$f":"IF(CheckLength($H$37:$H$499)=FALSE,\"Caution : please limit Description of Interaction to a maximum of \"&MaxCharactersDescriptionInteraction & \" characters\",\"\")","v":""}]
[null,"For more detail, please see Definition & Examples worksheet"]
[]
[null,"Check"]
[]
[null,{"$f":"IF(NbOfErrorRows>0,\"X\",\"OK\")","v":"OK"},{"$f":"IF(B32=\"OK\",\"\",IF(NbOfErrorRows=1,\"Caution: 1 row is not completed properly. If all fields are completed, make sure you did not enter both a financial and non-financial contribution. Also, make sure you respected the length limit of the Description of Interaction.\",\"Caution: \"&NbOfErrorRows&\" rows are not completed properly. If all fields are completed, make sure you did not enter both a financial and non-financial contribution. Also, make sure you respected the length limit of the Description of Interaction.\"))","v":""}]
[null,{"$f":"COUNTIF(A:A,\"X\")","v":0}]
[null,"Sanofi Interactions with Patient Groups in 2019"]
[null,"Geography (Patient Group HQ)","Name of Patient Group","English Translation\n(non-official)","Patient Group Website","Category of Support","Types/Purpose of Support","Description of Interaction","Therapeutic Area","Currency","Financial Contribution 1","Non-Financial Contribution 2"]
[]
[null,"Austria","Myelom und Lymphomhilfe Österreich","Austrian Myeloma- & Lymphomahelp",null,"Financial Support (Direct)","Project Funding","We provided support for a project (Mitgliedermagazin)","Other Diseases (Genzyme commissioned)","Euro",5000]
[{"$f":"(IF(COUNTA($B38:$L38)=0,IF(OR(ROW(B38)<=LastRowIF,AND($A37=\"X\",ROW($B37)<LastRowIF)),\"X\",\"\"),IF(OR(B38=\"\",C38=\"\",D38=\"\",F38=\"\",G38=\"\",H38=\"\",I38=\"\",J38=\"\",COUNTA(K38:L38)=0,COUNTA(K38:L38)=2,LEN(H38)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""},"Austria","Selbsthilfe Darmkrebs","Selfhelp Group Colon Cancer",null,"Financial Support (Direct)","Project Funding","We provided support for a project (SHD-Website – www.selbsthilfe-darmkrebs.at)","Oncology","Euro",3300]
[null,"Austria","Diabär - Verein für Diabetiker der Universitätskinderklinik Graz","Organization for Diabetics of the University Childrens Clinic Graz",null,"Financial Support (Direct)","Project Funding","We provided support for a project (Gruppenleiterschulung)","Diabetes","Euro",5000]
["","Austria","Österreichischer Diabetikervereinigung (ÖDV)","Austrian Diabetes Assiciation",null,"Financial Support (Direct)","Project Funding","We provided support to enable the patient group to pursue its stated objectives","Diabetes","Euro",5000]
[{"$f":"(IF(COUNTA($B41:$L41)=0,IF(OR(ROW(#REF!)<=LastRowIF,AND($A40=\"X\",ROW($B40)<LastRowIF)),\"X\",\"\"),IF(OR(#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",COUNTA(K41:L41)=0,COUNTA(K41:L41)=2,LEN(#REF!)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":{"$error":"#REF!"}},"Austria","wir sind diabetes - Dachorganisation der Diabetes Selbsthilfe Österreich","we are diabetes - umbrella organization of Austrian diabetes self-help organisations",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Diabetes","Euro",5000]
[{"$f":"(IF(COUNTA($B42:$L42)=0,IF(OR(ROW(B42)<=LastRowIF,AND($A41=\"X\",ROW(#REF!)<LastRowIF)),\"X\",\"\"),IF(OR(B42=\"\",C42=\"\",D42=\"\",F42=\"\",G42=\"\",H42=\"\",I42=\"\",J42=\"\",COUNTA(K42:L42)=0,COUNTA(K42:L42)=2,LEN(H42)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""},"Austria","Morbus Fabry Selbsthilfegruppe Österreich","Morbus Fabry Selfhelp Group",null,"Financial Support (Direct)","Core/General Funding","Patient Meeting 12.-14.7.2019// homepage//Counselling services for members// attendace of conferences concerning the disease","Rare Diseases","Euro",5000]
[{"$f":"(IF(COUNTA($B43:$L43)=0,IF(OR(ROW(B43)<=LastRowIF,AND($A42=\"X\",ROW($B42)<LastRowIF)),\"X\",\"\"),IF(OR(B43=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",COUNTA(K43:L43)=0,COUNTA(K43:L43)=2,LEN(#REF!)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":{"$error":"#REF!"}},"Austria","OÖ Diabetiker Selbsthilfegruppe Bezirk Braunau","Self-help Group Diabetes Braunau (Upper Austria)",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Diabetes","Euro",250]
["","Austria","Österreichische Krebshilfe","Austrian Cancer Help",null,"Financial Support (Direct)","Project Funding","We provided support for a project (Loose Tie)","Oncology","Euro",10000]
["","Austria","Österreichische Diabetes Gesellschaft","Austrian Diabetes Society",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Diabetes","Euro",370]
[{"$f":"(IF(COUNTA($B46:$L46)=0,IF(OR(ROW(B41)<=LastRowIF,AND($A45=\"X\",ROW($B45)<LastRowIF)),\"X\",\"\"),IF(OR(B41=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",#REF!=\"\",COUNTA(K46:L46)=0,COUNTA(K46:L46)=2,LEN(#REF!)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":{"$error":"#REF!"}},"Austria","Gesellschaft für MukoPolySaccharidosen und ähnliche Erkrankungen","Association for MPS and similar diseases",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Rare Diseases","Euro",5000]
[null,"Austria","Multiple Sklerose Gesellschaft Niederösterreich","Multiple Sclerosis Association Lower Austria",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",1500]
[null,"Austria","Multiple Sklerose Gesellschaft Kärnten","Multiple Sclerosis Association Carinthia",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",1000]
[null,"Austria",null,"Austrian Gaucher Association (Österreichische Gaucher Gesellschaft)",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Rare Diseases","Euro",5250]
[null,"Austria","Gesellschaft für MukoPolySaccharidosen und ähnliche Erkrankungen","Association for MPS and similar diseases",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Rare Diseases","Euro",800]
[null,"Austria","Verein zur Förderung  der Allergiefortbildung","Association for furthering allergy education",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Asthma","Euro",2200]
[null,"Austria","Multiple Sklerose Gesellschaft Niederösterreich","Multiple Sclerosis Association Lower Austria",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",1500]
[null,"Austria","Multiple Sklerose Gesellschaft Wien","Multiple Sclerosis Association Vienna",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",2600]
[null,"Austria","Multiple Sklerose Gesellschaft Wien","Multiple Sclerosis Association Vienna",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",2600]
[null,"Austria","Multiple Sklerose Gesellschaft Wien","Multiple Sclerosis Association Vienna",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Multiple Sclerosis","Euro",1800]
[{"$f":"(IF(COUNTA($B56:$L56)=0,IF(OR(ROW(B56)<=LastRowIF,AND($A55=\"X\",ROW($B55)<LastRowIF)),\"X\",\"\"),IF(OR(B56=\"\",C56=\"\",D56=\"\",F56=\"\",G56=\"\",H56=\"\",I56=\"\",J56=\"\",COUNTA(K56:L56)=0,COUNTA(K56:L56)=2,LEN(H56)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""},"Austria","Multiple Sklerose Gesellschaft Oberösterreich","Multiple Sclerosis Association Upper Austria",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Multiple Sclerosis","Euro",2000]
[null,"Austria","Multiple Sklerose Gesellschaft Burgenland","Multiple Sclerosis Association Burgenland",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Multiple Sclerosis","Euro",1000]
[null,"Austria","Multiple Sklerose Gesellschaft Niederösterreich","Multiple Sclerosis Association Lower Austria",null,"Financial Support (Direct)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Multiple Sclerosis","Euro",1500]
["","Austria","Pro Rare Austria - Allianz für seltene Erkrankungen","Pro Rare Austria - Alliance for rare diseases ",null,"Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Rare Diseases","Euro",5000]
[""]
[]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B100:$L100)=0,IF(OR(ROW(B100)<=LastRowIF,AND($A99=\"X\",ROW($B99)<LastRowIF)),\"X\",\"\"),IF(OR(B100=\"\",C100=\"\",D100=\"\",F100=\"\",G100=\"\",H100=\"\",I100=\"\",J100=\"\",COUNTA(K100:L100)=0,COUNTA(K100:L100)=2,LEN(H100)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B164:$L164)=0,IF(OR(ROW(B164)<=LastRowIF,AND($A163=\"X\",ROW($B163)<LastRowIF)),\"X\",\"\"),IF(OR(B164=\"\",C164=\"\",D164=\"\",F164=\"\",G164=\"\",H164=\"\",I164=\"\",J164=\"\",COUNTA(K164:L164)=0,COUNTA(K164:L164)=2,LEN(H164)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B228:$L228)=0,IF(OR(ROW(B228)<=LastRowIF,AND($A227=\"X\",ROW($B227)<LastRowIF)),\"X\",\"\"),IF(OR(B228=\"\",C228=\"\",D228=\"\",F228=\"\",G228=\"\",H228=\"\",I228=\"\",J228=\"\",COUNTA(K228:L228)=0,COUNTA(K228:L228)=2,LEN(H228)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B292:$L292)=0,IF(OR(ROW(B292)<=LastRowIF,AND($A291=\"X\",ROW($B291)<LastRowIF)),\"X\",\"\"),IF(OR(B292=\"\",C292=\"\",D292=\"\",F292=\"\",G292=\"\",H292=\"\",I292=\"\",J292=\"\",COUNTA(K292:L292)=0,COUNTA(K292:L292)=2,LEN(H292)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B356:$L356)=0,IF(OR(ROW(B356)<=LastRowIF,AND($A355=\"X\",ROW($B355)<LastRowIF)),\"X\",\"\"),IF(OR(B356=\"\",C356=\"\",D356=\"\",F356=\"\",G356=\"\",H356=\"\",I356=\"\",J356=\"\",COUNTA(K356:L356)=0,COUNTA(K356:L356)=2,LEN(H356)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B420:$L420)=0,IF(OR(ROW(B420)<=LastRowIF,AND($A419=\"X\",ROW($B419)<LastRowIF)),\"X\",\"\"),IF(OR(B420=\"\",C420=\"\",D420=\"\",F420=\"\",G420=\"\",H420=\"\",I420=\"\",J420=\"\",COUNTA(K420:L420)=0,COUNTA(K420:L420)=2,LEN(H420)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"(IF(COUNTA($B484:$L484)=0,IF(OR(ROW(B484)<=LastRowIF,AND($A483=\"X\",ROW($B483)<LastRowIF)),\"X\",\"\"),IF(OR(B484=\"\",C484=\"\",D484=\"\",F484=\"\",G484=\"\",H484=\"\",I484=\"\",J484=\"\",COUNTA(K484:L484)=0,COUNTA(K484:L484)=2,LEN(H484)>MaxCharactersDescriptionInteraction),\"X\",\"\")))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Definition & Examples","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,0,10,0],[15,0,16,0],[17,0,18,0]]}
["DEFINITIONS AND EXAMPLES "]
[]
["PATIENT GROUPS DEFINITION\nPatient Groups include patient associations. They are organisations which focus on specific diseases or aspects of healthcare, representing and/or supporting the needs of patients and/or caregivers. These groups are mainly composed of patients and or caregivers (family/friends), but can also be composed of consumers, seniors, women, minority populations or caregivers and may be led by advocacy professionals who may or may not have personal association with a given disease. Note some associations can be both a Medical or Scientific Association and  a Patient Association in different parts (e.g. national/international vs. local), in this case it will be considered as one or the other based upon whether an activity or event is largely planned and intended for Health Care Professionals or patients. For the purposes of this exercise the \"patient\" activities/events should be included. "]
[]
["CATEGORIES OF SUPPORT",null,"TYPES/PURPOSE OF SUPPORT \nFunding is provided a) to help the patient group cover day-to -day operational costs of the organisation (described as core/general funding) and/or b) to specifically help fund an identified project/ activity or series of projects within the scope of the patient group (described as project funding) or represents c) a payment relating to resources/time provided by the patient group or a member of the group (described as contracted services/fees for services) in connection with a specific issue/event identified by Sanofi (e.g. press event, advisory board or round-table discussion)  ",null,"EXAMPLES",null,"BRIEF DESCRIPTION OF NATURE OF SUPPORT/\nUSE STANDARD DESCRIPTIONS WHEREVER POSSIBLE (can be customised if necessary):\nPLEASE KEEP DESCRIPTIONS SHORT (3 lines max)\n\n\n\n\n"]
[]
["FINANCIAL SUPPORT "]
[]
["Financial Support (direct) relates to a financial payment made by Sanofi to a patient group  ",null,"Project Funding",null,"a) We provided financial support towards a free telephone helpline for cancer services. b) We provided funding for a long-term programme on diabetes prevention and care c) We provided financial support towards the patient group's annual meeting. ",null,"We provided support\ntowards the patient group's meeting(s)/seminar(s)\nfor a patient-care related project\nfor a project (insert name)\nfor research on disease(s)\n\n"]
[null,null,"Core/ General Funding",null,"We provided financial support to enable the group to work on its stated aims and activities in 2010",null,"We provided support to enable the patient group to pursue its stated objectives"]
[null,null,"Contracted Services/ Fees for Services",null,"The president of the patient group  was a round-table participant in a panel discussion on healthcare cost-containment during an internal company seminar (where honorarium paid directly by the company).",null,"A representative from the patient group provided a service to the company by (complete e.g. being a speaker in a panel discussion)"]
["Financial Support (indirect) relates to a financial payment made by a third party/vendor (e.g. a public relations/communications or logistics agency) on behalf of the company to a patient group",null,"Contracted Services/ Fees for Services",null,"The president of the patient association  was a round-table participant in a panel discussion on healthcare cost-containment during an internal Sanofi seminar (where honorarium paid by agency on behalf of the Group).",null,"A representative from the patient group provided a service to the company by (complete e.g. being a speaker in a panel discussion)"]
[]
["NON-FINANCIAL SUPPORT "]
[]
["Non - Financial Support (indirect) relates to services support provided by a third party/vendor (e.g. a public relations/communications or logistics agency) to a patient group where the third party fees/costs are paid by Sanofi",null,"Project Funding",null,"We provided an amount of communications agency time to patient group x to work on an awareness campaign conducted by the association",null,"Third - party support provided by (specify if for example a communications or public relations agency) on our behalf for (complete by adding purpose….)"]
[null,null,"Core/General Funding",null,"We provided an amount of communications agency time to patient group x to facilitate ongoing communications work of the patient group",null,"Third - party support provided by (specify if for example a communications or public relations agency) on our behalf for (complete by adding purpose….)"]
["Non-Financial Support (in-kind) relates to in-kind support provided by the company to a patient group such as meeting space in a facility belonging to the company, or regular or significant support provided by company/ volunteers on company time such as sharing business-skills. Note: it is not necessary to attribute/estimate a financial value for this support, unless an invoice exists for expenses incurred. ",null,"Project Funding",null,"a) We ran a workshop for patient group x for parents with diabetic children. b) We provided its business skills to explain how to construct a communications plan c)The patient group participated in an event facilitated by the Group in the European Parliament (dialogue platform with health stakeholders and exhibition focusing on daily challenges of patients lives\" (no financial estimate/attribution of value of in-kind benefit required) d) We covered travel/accomodation costs relating to participating in \"Daily challenges in Patient's lives\" event in the European Parliament facilitated by the company (insert level of expenses) ",null,"We provided in-kind support in the form of (complete …. ) "]
[null,null,"Core/General Funding",null,"Regular volunteering"]
[]
["Note: Therapeutic Area - Rare Disease catagory includes  Pompe, Fabry, MPS, Gaucher and Niemann-Pick diseases. FH and Thyroid cancer activities undertaken by Genzyme should also be entered as Rare Disease, in line with the Genzyme Rare Disease Business Unit organisation. "]

{"sheet":"BackEnd","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Number of projects in the template",{"$f":"COUNTA(OFFSET(FirstRowIF,0,0,1000))","v":23}]
["Number of printing pages of the Information Form",{"$f":"IF(MOD($B$1,23)=0,QUOTIENT($B$1,23),QUOTIENT($B$1,23)+1)","v":1}]
["Last row of the Information Form",{"$f":"ROW(FirstRowIF)+B1","v":59}]
["Number of maximum characters in the description of interaction",180]

{"sheet":"Lists","index":4,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Geography","Currency","Category of Support","Type of Support","Nature of Support","Therapeutic Area"]
["International","Algerian Dinar","Financial Support (Direct)","Core/General Funding","We provided support to enable the patient group to pursue its stated objectives","Asthma"]
["Pan European","Argentine Peso","Financial Support (Indirect)","Project Funding","We provided support towards the patient group's meeting(s)/seminar(s)","Atopic Dermatitis"]
["Albania","Australian Dollar","Non-Financial Support (In-kind)","Contracted Services/ Fees for Service","We provided support for a patient-care related project","Cardiovascular"]
["Australia","Bangladeshi Taka","Non Financial Support (Indirect)",null,"We provided support for a project (insert name)","Diabetes"]
["Austria","Bosnian Mark",null,null,"We provided support for research on disease(s)","Multiple Sclerosis"]
["Belgium","Brazilian Real",null,null,"A representative from the patient group provided a service to the company by (complete e.g. being a speaker in a panel discussion)","Oncology"]
["Bosnia and Herzegovina","British Pound Sterling",null,null,"Third - party support provided by (specify if for example a communications or public relations agency) on our behalf for (complete by adding purpose….)","Rare Diseases"]
["Brazil","Bulgarian Lev",null,null,"We provided in-kind support in the form of (complete …. ) ","Rheumatoid Arthritis"]
["Bulgaria","Canadian Dollar",null,null,null,"Vaccines"]
["Canada","CFA-Franc (BCEAO)",null,null,null,"Other Diseases (Sanofi commissioned)"]
["Croatia","Chilean Peso",null,null,null,"Other Diseases (Genzyme commissioned)"]
["Cyprus","Chinese Renminbi Yuan",null,null,null,"Not focusing on a disease (Sanofi commissioned)"]
["Czech Republic","Colombian Peso",null,null,null,"Not focusing on a disease (Genzyme commissioned)"]
["Denmark","Costa Rican Colón"]
["Egypt","Croatian Kuna"]
["Estonia","Czech Koruna"]
["Finland","Danish Krone"]
["France","Dominican Peso"]
["Germany","Egyptian Pound"]
["Greece","Euro"]
["Hungary","Guatemalan Quetzal"]
["Ireland","Hong Kong Dollar"]
["Italy","Hungarian Forint"]
["Japan","Icelandian Krone"]
["Latvia","Indian Rupee"]
["Lithuania","Indonesian Rupiah"]
["Macedonia","Iranian Rial"]
["Malta","Iraqian Dinar"]
["Montenegro","Israelian Shekel"]
["Netherlands","Japanese Yen"]
["Norway","Jordanian Dinar"]
["Poland","Kambodjan Riel"]
["Portugal","Kazachstani Tenge"]
["Romania","Kenyan Shilling"]
["Russia","Lebanese Pound"]
["Serbia","Lithuanian Litas"]
["Slovakia","Macedonian Denar"]
["Slovenia","Malaysian Ringgit"]
["Spain","Mexican Peso"]
["Sweden","Moroccan Dihram"]
["Switzerland","New Zealand Dollar"]
["Turkey","Nigerian Naira"]
["Ukraine","Norwegian Kroner"]
["United Kingdom","Pakistani Rupee"]
["United States","Panaman Balboa"]
[null,"Paraguayan Guarani"]
[null,"Peruvian Sol"]
[null,"Philippine Peso"]
[null,"Polish Zloty"]
[null,"Romanian Leu"]
[null,"Russian Ruble"]
[null,"Saudi Arabian Riyal"]
[null,"Serbian Dinar"]
[null,"Singaporian Dollar"]
[null,"South African Rand"]
[null,"South Korean Won"]
[null,"Sri Lankan Rupee"]
[null,"Swedish Krona"]
[null,"Swiss Franc"]
[null,"Taiwanese Dollar"]
[null,"Thai Baht"]
[null,"Tunisian Dinar"]
[null,"Turkish Lira"]
[null,"Ukraine Hryvnia"]
[null,"United Arab Emirates Dirham"]
[null,"United States Dollar"]
[null,"Uruguayan Peso"]
[null,"Venezuelan Bolivar Forte"]
[null,"Vietnamese Dong"]

{"sheet":"Help","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Column","Column Name","Help Title","Help Message"]
[{"$f":"COLUMN(Projects!$B$35)","v":2},{"$f":"INDEX(Projects!$35:$35,1,$A2)","v":"Geography (Patient Group HQ)"},"Patient Group Headquarters","Please enter Country where Patient Group HQ is located. If group is Pan-European or International in remit, enter \"Pan-European\" or \"International\" as the Geography irrespective of specific HQ location."]
[{"$f":"COLUMN(Projects!$C$35)","v":3},{"$f":"INDEX(Projects!$35:$35,1,$A3)","v":"Name of Patient Group"},"Name of Patient Group","Please enter official name of Patient Group in your local language."]
[{"$f":"COLUMN(Projects!$D$35)","v":4},{"$f":"INDEX(Projects!$35:$35,1,$A4)","v":"English Translation\n(non-official)"},"English Translation","Please provide an English translation of Patient Group's name."]
[{"$f":"COLUMN(Projects!$E$35)","v":5},{"$f":"INDEX(Projects!$35:$35,1,$A5)","v":"Patient Group Website"},"Patient Group Website","Please enter the Patient Group's website (if applicable)."]
[{"$f":"COLUMN(Projects!$F$35)","v":6},{"$f":"INDEX(Projects!$35:$35,1,$A6)","v":"Category of Support"},"Explanation of Support","Financial: payment made by Sanofi (direct) or by a third party on behalf of Sanofi (indirect) to a Patient Group.\nFor Financial support (Direct) in European affiliates, we recommend you consult your affiliate NAYA transparency officer to extract and provide you with direct payments (SAP expenses), from the NAYA EU Platform (tagged “YV48_ HCO PatientAssociatÂ°)\nNon-financial: Indirect - support services provided by a third party/vendor (e.g. PR/Comms/Logistics agency) to a Patient Group. \nNon-financial : In-kind - support provided by Sanofi (e.g. meeting space) or significant support provided by company such as sharing of business skill/know-how."]
[{"$f":"COLUMN(Projects!$G$35)","v":7},{"$f":"INDEX(Projects!$35:$35,1,$A7)","v":"Types/Purpose of Support"},"Explanation of Type of Support","Core/ General Funding helps cover day-to-day operational costs. \nProject Funding: funds an identified project/ activity or series of projects. \nContracted Services/ Fees for Service: covers payment for specific request from Sanofi (e.g. a board or round table discussion)."]
[{"$f":"COLUMN(Projects!$H$35)","v":8},{"$f":"INDEX(Projects!$35:$35,1,$A8)","v":"Description of Interaction"},"Interaction","Please select a general description in drop- down/scroll down menu, and complete manually if necessary. In exceptional cases, enter a free text description by scrolling down to the bottom of the list of options and BRIEFLY describing the interaction. (3 lines max)."]
[{"$f":"COLUMN(Projects!$I$35)","v":9},{"$f":"INDEX(Projects!$35:$35,1,$A9)","v":"Therapeutic Area"},"Therapeutic Area","Please select appropriate option."]
[{"$f":"COLUMN(Projects!$J$35)","v":10},{"$f":"INDEX(Projects!$35:$35,1,$A10)","v":"Currency"},"Support Currency","Please enter currency of transaction (generally local currency)."]
[{"$f":"COLUMN(Projects!$K$35)","v":11},{"$f":"INDEX(Projects!$35:$35,1,$A11)","v":"Financial Contribution 1"},"Financial Contribution","Use only if support is Financial (Direct or Indirect), i.e. payment made by Sanofi directly to Patient Group (or by a third party on behalf of Sanofi) Do not use decimals or commas."]
[{"$f":"COLUMN(Projects!$L$35)","v":12},{"$f":"INDEX(Projects!$35:$35,1,$A12)","v":"Non-Financial Contribution 2"},"Non-Financial Contribution","Use only if support is Non-financial (Indirect or In-kind), i.e. provision of services made by Sanofi (or by a third party paid by Sanofi to Patient Group). Only enter an in-kind value if there is an invoiced amount. Do not use decimals or commas."]