{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Pivotal Tables","Drop-down Lists","Type of agreement","Currency rates","Collaboration list"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":49,"comments":0,"pivot_tables":2},"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":"Pivotal Tables","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
["Partnering Status","Signed"]
[]
["Count of Partner name","Year of Signature date"]
["Type of agreement",2012,2013,1900,1990,2014,"Grand Total"]
["Amendment",26,5,null,10,1,42]
["CDA",26,null,null,44,null,70]
["Collaboration agreement",79,37,null,null,5,121]
["Consortium agreement",7,5,null,12,1,25]
["In-license agreement",7,7,null,14,null,28]
["MTA",36,18,null,24,null,78]
["Other (please specify in comments)",16,9,1,17,null,43]
["Out-license agreement",3,1,null,1,null,5]
["Sponsored Innovation Agreement",14,4,null,53,null,71]
["Umbrella Grant Agreement",null,1,null,12,null,13]
["Grand Total",214,87,1,187,7,496]
[]
[]
["Partnering Status","Not signed - on hold"]
[]
["Count of Partner name"]
["Type of agreement","Total"]
["CDA",1]
["Collaboration agreement",8]
["Consortium agreement",1]
["In-license agreement",1]
["MTA",5]
["Other (please specify in comments)",2]
["Grand Total",18]

{"sheet":"Drop-down Lists","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Type of partner","Type of agreement","Country of C P&I contact"," Unit\n(accountable for delivery\nand budget owner)","Partnering status","Currency for costs","Key Partner","Zone","Time criticality","Deal complexity","Type of Budget","Type of contracts"]
["Academia & consortia","Amendment","France","Access Platform","Signed","EUR","Key Partner","North America","Fast track","Very complex","Central Pool Budget","Amendment"]
["Biotech","CDA","Germany","Aging","Not signed - in negotiation","USD","Other","Europe","Standard track","Standard complexity","Unit Discretionnary Budget","CDA"]
["Foundation","Collaboration agreement","US","APAC","Not signed - on hold","CHF",null,"Asia/Pacific","Lower degree of urgency","Low complexity","Unit Sourcing Budget","MTA"]
["Other","Consortium agreement","China","Bio-Therapeutics","Not signed - stopped","GBP",null,"RoW",null,null,"In Kind","Consortium Agreement"]
[null,"Grant",".","Clin Supplies",null,"CNY",null,"North America & Europe",null,null,"No Funding","Umbrella Grant Agreement"]
[null,"License",null,"CSO",".","JPY",null,null,null,null,null,"In-license Agreement"]
[null,"MTA",null,"CV & Fibrosis ",".","KRW",null,null,null,null,null,"Sponsored Innovation Agreement"]
[null,"Other (please specify in comments)",null,"Diabetes",null,"RMB",null,null,null,null,null,"Evaluation"]
[null,"Sponsored Innovation Agreement",null,"DPUs",".","INR",null,null,null,null,null,"Grant"]
[null,"Umbrella Grant Agreement",null,"DSAR",null,"CAND",null,null,null,null,null,"Out-license"]
[null,null,null,"E2C",null,".",null,null,null,null,null,"Other (please specify in comments)"]
[null,null,null,"Exploratory",null,null,null,null,null,null,null,"In-license Agreement"]
[null,null,null,"Genzyme",null,null,null,null,null,null,null,"Collaboration Agreement"]
[null,null,null,"HR"]
[null,null,null,"Immuno Inf."]
[null,null,null,"Inf. Diseases"]
[null,null,null,"LGCR"]
[null,null,null,"Oncology"]
[null,null,null,"Ophtha"]
[null,null,null,"Reg Med"]
[null,null,null,"S&I"]
[null,null,null,"Sanofi Pasteur"]
[null,null,null,"Translational Sciences"]
[null,null,null,"TPR"]
[null,null,null,"Other"]

{"sheet":"Type of agreement","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Type of agreement","Definition","Examples"]
["Umbrella Grant Agreement","Agreement by which Sanofi provides financial support to a 3rd party, in the context of a broad partnership with no pre-agreed terms for either existing or generated IP rights. The agreement typically stipulates a governance with a joint steering committee for the review and decisions on future agreements","Salk Umbrella, Cal Tech Umbrella, Charite Umbrella, ATIP Avenir Umbrella, AVIESAN Umbrella"]
["Grant","Sanofi provides financial support to a third party activities , without receiving any rights on the results of such activities, or any compensation whatsoever","ATIP-Avenir"]
["Sponsored Innovation Agreement","Typically implemented under an Umbrella Grant Agreement. IP rights covering the results arising out the performance of the research or development program are owned and/or used per agreement between the parties.","All  Agreements for Awards under Framework deals e.g. Salk, Cal Tech, MIT, Harvard and future Stanford , UCSF "]
["Collaboration agreement","Performance of a jointly defined research or development program by the parties (where part of the research or development program can be performed by Sanofi) to which Sanofi researchers may participate/contribute. \nIP rights covering the results arising out the performance of the research or development program are owned and/or used per agreement between the parties.\nFunding of the research or development program is agreed between the parties (generally supported by Sanofi)","All SRA’swhich contain non-exclusive licenses and options for exclusivity. e.g.  UNC, MIT, Rutgers etc..REQUIRES an AED\nSRA’s with fixed negotiated terms for exclusive licenses- Sunnybrook, Traversa, Belfer,  REQUIRES an AIF"]
["Consortium agreement","Sanofi cooperates with several third parties to perform certain predefined R&D activities, with or without innovative activity, and the IP rights covering the results of such activities are shared and used per agreement between all the parties. Partners of the consortium are usually in-part funded by a state or international organization","LIVIMODE, EUTRAF, Natural Products, POLYCAT"]
["In-license agreement","Sanofi receives the right to use a third party’s pre-existing IP rights for research and/or development and/or manufacturing and/or commercialization purposes","All Tools/Technologies- Xenogen Imaging, Abbott Tet Element, BACMAM vectors"]
["Out-license agreement","A third party receives the right to use Sanofi’s  pre-existing IP rights for research and/or development and/or manufacturing and/or commercialization purposes","GPCR Technology Patent- BioInvenu "]
["CDA","Confidentiality Disclosure Agreement"]
["MTA","Material Transfer Agreement"]
["Amendment","Amendment to renew, extend or modify an existing agreement"]
["Other (please specify in comments)","Any other type of agreement than the ones described above"]

{"sheet":"Currency rates","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Exchange rates (2012 budget rates)"]
["Currency","$ amount","€ amount",null,"1 EUR="]
["EUR",{"$f":"C3*$E$4","v":1.4},{"$f":"1/E3","v":1},null,1]
["USD",1,0.7142857142857143,null,1.4]
["CHF",1.2962962962962961,0.92592592592592582,null,1.08]
["USD",1.6279069767441861,1.1627906976744187,null,0.86]
["CNY",0.16091954022988506,0.1149425287356322,null,8.6999999999999993]
["JPY",1.1965811965811967E-2,8.5470085470085479E-3,null,117]
["KRW",9.0322580645161286E-4,6.4516129032258064E-4,null,1550]
["INR",2.222222222222222E-2,1.5873015873015872E-2,null,63]
[]
[null,{"$f":"157.5/1.4","v":112.50000000000001}]

{"sheet":"Collaboration list","index":4,"n_rows":6,"n_cols":54,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,4]]}
[null,"Agreement Meter",{"$f":"+SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]
[null,"BALI Meter",{"$f":"+SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]
[]
["GREEN : Free text\nBLUE : Select from drop-down menu\nWHITE : Automatic Formula",null,null,null,null,"DEAL COUNTER :",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET(A6:A8201,ROW(A6:A8201)-MIN(ROW(A6:A8201)),,1)),ISNUMBER(SEARCH(\"*\",A6:A8201))+0)","v":1}]
["Agreement Reference Number","Partner name","Comment on partner name/\nPrincipal Investigator","Type of partner","Country of Partner","Zone","Opportunity description/\nSubject","Negotiation status / Remarks","Next Action","Type of agreement","Specify / Comments for Other type of Agreement","Partnering Status","Agreement Status","Name of R&D-T Contact","R&D-T Contact Name","Country of R&D-T contact"," Unit\n(accountable for delivery\nand budget owner)","Name of primary internal contact","Name of additional internal contacts","Name of legal/patent contact","AED or NEXT number","Age of request","Period","Date initial EITF received","Month EITF Reception","Year EITF Reception","EITF complete start of Negotiation by R&D-T","Month EITF Completion","Year EITF Completion","Date Negotiation Completed","Month Negotiation Completed","Year Negotiation Completed","Negotiation Duration","Negotiation Duration in Days","EITFcompletion time","Date \nPatent / Legal engaged for Term Sheet","Legal engaged for agreement drafting / review","Date Agreement 1st draft or modified version received from Legal","Date Agreement proposal send to Partner","Date 1st comments received from Partner","Date CAF signing /Nexts approval by CP&I or initiation of signature process","Date Agreement Signed","Month Signed","Year signed","Signature Loop Duration","Agreement effective date (MM/DD/YYYY)","Agreement end date (MM/DD/YYYY)","Time criticality","Comments on  criticality","Deal complexity","Payment Terms","Type of Funding","Currency for costs"," Total OPEX ('000)"]
["CPI-0001",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AT6=\"\",AU6=\"\"),IF(L6=\"Signed\",\"Lack of Dates\",\"N/A\"),IF(AU6=\"No End Date\",\"Active - no end\",IF(AU6=\"End of Study\",\"Active - until end of study\",IF(AU6-AT6>0,IF(AND(AT6<(TODAY()),AU6>(TODAY()-1)),\"Active\",IF(AU6<TODAY(),\"Terminated\",\"Lack of Dates\")),\"Lack of Dates\"))))","v":"N/A"},null,{"$f":"Liste1[[#This Row],[Name of R&D-T Contact]]","v":0},null,null,null,null,null,null,{"$f":"INT(TODAY())-Liste1[[#This Row],[Date initial EITF received]]","v":42321},{"$f":"IF(Liste1[[#This Row],[Age of request]]<15,\"1. Last 2 weeks\", IF(Liste1[[#This Row],[Age of request]]<31, \"2. Last month (need to also select 'Last week')\", IF(Liste1[[#This Row],[Age of request]]<121, \"3. Last 4 months (need also to select 'Last week' and 'Last month')\", IF(Liste1[[#This Row],[Age of request]]<365, \"4. Last Year (need also to select 'Last Week', 'Last month' and 'Last 4 months')\", \"Older\"))))","v":"Older"},null,{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date initial EITF received]])),\"\",(TEXT(Liste1[[#This Row],[Date initial EITF received]],\"mmm aaaa\")))","v":""},{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date initial EITF received]])),\"\",(TEXT(Liste1[[#This Row],[Date initial EITF received]],\"aaaa\")))","v":""},null,{"$f":"IF((ISBLANK(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]])),\"\",(TEXT(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],\"mmm aaaa\")))","v":""},{"$f":"IF((ISBLANK(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]])),\"\",(TEXT(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],\"aaaa\")))","v":""},null,{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date Negotiation Completed]])),\"\",(TEXT(Liste1[[#This Row],[Date Negotiation Completed]],\"mmm aaaa\")))","v":""},{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date Negotiation Completed]])),\"\",(TEXT(Liste1[[#This Row],[Date Negotiation Completed]],\"aaaa\")))","v":""},{"$f":"IF(OR(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]]=\"\",Liste1[[#This Row],[Date Negotiation Completed]]=\"\"),\"\",DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"Y\")&IF(DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"Y\")>1,\" years, \",\" year, \")&DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"YM\") &\" months and \"&DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"MD\")&IF(DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"MD\")>1,\" days\",\" day\"))","v":""},{"$f":"IF(OR(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]]=\"\",Liste1[[#This Row],[Date Negotiation Completed]]=\"\"),\"\",(DATEDIF(Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],Liste1[[#This Row],[Date Negotiation Completed]],\"D\")))","v":""},{"$f":"IF(OR(Liste1[[#This Row],[Date initial EITF received]]=\"\",Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]]=\"\"),\"\",(DATEDIF(Liste1[[#This Row],[Date initial EITF received]],Liste1[[#This Row],[EITF complete start of Negotiation by R&D-T]],\"D\")))","v":""},null,null,null,null,null,null,null,{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date Agreement Signed]])),\"\",(TEXT(Liste1[[#This Row],[Date Agreement Signed]],\"mmm aaaa\")))","v":""},{"$f":"IF((ISBLANK(Liste1[[#This Row],[Date Agreement Signed]])),\"\",(TEXT(Liste1[[#This Row],[Date Agreement Signed]],\"aaaa\")))","v":""},{"$f":"IF(OR(Liste1[[#This Row],[Date Negotiation Completed]]=\"\",Liste1[[#This Row],[Date Agreement Signed]]=\"\"),\"\",(DATEDIF(Liste1[[#This Row],[Date Negotiation Completed]],Liste1[[#This Row],[Date Agreement Signed]],\"D\")))","v":""},null,null,null,null,null,null,null,null,0]