{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FICHE CONTRAT","RECAP CONTRAT","Feuil1","NOTE","Feuil8"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"FICHE CONTRAT","index":0,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[40,4,40,9],[38,0,38,9],[34,0,34,1],[35,0,35,1],[33,5,33,9],[33,0,33,1],[31,0,31,9],[0,0,0,9],[4,0,4,9],[24,0,24,9],[12,4,12,6],[26,3,26,6],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[69,0,69,9],[71,0,81,9],[6,3,6,9],[8,1,8,2],[8,3,9,3],[8,4,8,5],[8,7,8,9],[10,2,11,2],[6,2,7,2],[55,0,55,2],[55,3,56,3],[55,4,56,4],[12,1,12,2],[20,1,21,4],[53,0,53,9],[55,5,56,5]]}
["FICHE CONTRAT INSTITUT LANGEVIN"]
[]
[null,null,null,null,null,null,null,"STATUT *"]
[]
["INFORMATIONS GENERALES"]
[]
["Acronyme du projet *",null,"Titre complet du projet"]
[]
["Responsable Scientifique  *",null,null,"Coordinateur Scientifique\n (si différent)",null,null,"Laboratoire"]
[]
["Organisme de Gestion  *",null,"Code EOTP/Réf Tutelle",null,"Financement  *","Privé","DÉPENSES A JUSTIFIER : ",{"$f":"IF(F11=\"Public\",\"OUI\",\"NON\")","v":"NON"},"Mention pouvant être effacée"]
[]
["Type de Projet  *",null,null,"Sous Catégorie"]
[]
[]
["Date de Début  *",null,"Date de Fin  *",null,"Date de Signature",null,null,"Durée du contrat",{"$f":"DATEDIF(B16,D16,\"ym\")&\" mois\"","v":"0 mois"}]
[]
[null,"N°","Date "]
["Avenant"]
[]
["Autres partenaires  *"]
[]
[]
[]
["Partie propre au CNRS"]
[]
[null,null,null,"CODE BFC - EOTP"]
[null,null,null,"Personnel",null,"Toutes dépenses"]
[null,null,null,{"$f":"IF(B11=\"CNRS\",(CONCATENATE(D11,\"1\")),\"\")","v":""},null,{"$f":"IF(B11=\"CNRS\",(CONCATENATE(D11,\"2\")),\"\")","v":""}]
[]
[]
["BUDGET"]
[]
["Montant total avec frais de gestion (assiette)  *",null,null,null,null,"Répartition des dépenses"]
["Frais de Gestion  *",null,null,"%",null,"Personnel","sur Personne Mois","Équipement","Mission","Fonctionnement"]
["Montant disponible pour l'unité (hors frais)",null,{"$f":"C34-C35","v":0}]
[]
[]
["MISES EN PLACE DE CREDITS"]
[]
[null,null,null,null,"Répartition des encaissements par année"]
["Mise en place","Personnel","Toutes dépenses",null,{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+1))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+2))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+3))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+4))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+5))","v":""}]
[]
[]
[]
[]
[]
[]
[]
["Total versé",{"$f":"SUM(B43:B49)","v":0},{"$f":"SUM(C43:C49)","v":0}]
["Reste à verser",{"$f":"F36-B50","v":0},{"$f":"SUM(H36:J36)-C50","v":0}]
[]
[]
["PERSONNEL SUR LE PROJET"]
[]
["Personne recrutée",null,null,"Salaire mensuel dont taxes et charges (€)","Nombre homme/mois sur projet","Coût total"]
["Nom","Prénom","Fonction"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total : "]
[null,null,null,null,"Total : "]
[]
[]
["OBSERVATIONS"]

{"sheet":"RECAP CONTRAT","index":1,"n_rows":2,"n_cols":24,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Nom du projet","RESPONSABLE SCIENTIFIQUE","Type de projet","Financement","Organisme de Gestion ","Date signature","Code / Référence tutelle","Date début","Date fin","Durée","Budget total du projet","Budget / Allocation. Part labo","Encaissé 2014","Report 2014-2015","Encaissé 2015","Report 2015-2016","Encaissé 2016","Reste à encaisser","Prévision 2017","Prévision 2018","Prévision 2019","Justification","Observations","STATUT"]

{"sheet":"Feuil1","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Type","Sous-Catégorie",null,null,"Organisme de Gestion","Financement",null,null,"Type_SansDoublons","SousCat_SansDoublons"]
["ANR (hors PIA)","ANRi",null,null,"CNRS","Privé",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I1,Type),0)-1,,1),\"\")","v":"ANR (hors PIA)"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J1,SousCat),0)-1,,1),\"\")","v":""}]
["ANR (hors PIA)","ANRS",null,null,"CNRS/PSL - ESPCI","Public",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I2,Type),0)-1,,1),\"\")","v":"Collectivités territoriales"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J2,SousCat),0)-1,,1),\"\")","v":""}]
["ANR (hors PIA)","JCJC",null,null,"ESPCI",null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I3,Type),0)-1,,1),\"\")","v":"Financements public hors tutelles"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J3,SousCat),0)-1,,1),\"\")","v":""}]
["ANR (hors PIA)","PRC",null,null,"FPGG",null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I4,Type),0)-1,,1),\"\")","v":"Financements Union Européenne"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J4,SousCat),0)-1,,1),\"\")","v":""}]
["ANR (hors PIA)","PRCE",null,null,"FPGG - ESPCI ",null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I5,Type),0)-1,,1),\"\")","v":"Industries"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J5,SousCat),0)-1,,1),\"\")","v":""}]
["Collectivités territoriales","C NANO",null,null,"INSERM",null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I6,Type),0)-1,,1),\"\")","v":"Autres"},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J6,SousCat),0)-1,,1),\"\")","v":""}]
["Collectivités territoriales","Pôle de Compétitivité",null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I7,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J7,SousCat),0)-1,,1),\"\")","v":""}]
["Collectivités territoriales","SESAME",null,null,null,null,null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I8,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J8,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Défi Imagine",null,null,null,"Fonction",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I9,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J9,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Défi Instrumentation aux limites",null,null,null,"Chargé de recherche",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I10,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J10,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","PICS",null,null,null,"Chercheur",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I11,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J11,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Plan Cancer",null,null,null,"Directeur de Recherche",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I12,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J12,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Thèses",null,null,null,"Doctorant",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I13,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J13,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Ville de Paris \"Émergences\"",null,null,null,"Enseignant-chercheur",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I14,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J14,SousCat),0)-1,,1),\"\")","v":""}]
["Financements public hors tutelles","Autres",null,null,null,"Ingénieur",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I15,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J15,SousCat),0)-1,,1),\"\")","v":""}]
["Financements Union Européenne","FP7",null,null,null,"Ingénieur de recherche",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I16,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J16,SousCat),0)-1,,1),\"\")","v":""}]
["Financements Union Européenne","H2020",null,null,null,"Maître de conférence",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I17,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J17,SousCat),0)-1,,1),\"\")","v":""}]
["Financements Union Européenne","ERC (à détailler sur la fiche)",null,null,null,"MC contractuel",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I18,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J18,SousCat),0)-1,,1),\"\")","v":""}]
["Financements Union Européenne","Bourse Marie Curie",null,null,null,"Post-doctorant",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I19,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J19,SousCat),0)-1,,1),\"\")","v":""}]
["Financements Union Européenne","Autres (préciser sur la fiche)",null,null,null,"Professeur",null,null,{"$f":"IFERROR(OFFSET(Type,MATCH(0,COUNTIF(I$1:I20,Type),0)-1,,1),\"\")","v":""},{"$f":"IFERROR(OFFSET(SousCat,MATCH(0,COUNTIF(J$1:J20,SousCat),0)-1,,1),\"\")","v":""}]
["Industries","Convention de Collaboration"]
["Industries","Prestation de Services",null,null,null,null,null,null,"Statut"]
["Industries","CIFRE",null,null,null,null,null,null,"DEPOSÉ"]
["Autres",null,null,null,null,null,null,null,"VALIDÉ"]
[null,null,null,null,null,null,null,null,"REFUSÉ"]
[null,null,null,null,null,null,null,null,"ARCHIVÉ"]

{"sheet":"NOTE","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["2008-10-04"]
[null,{"$f":"DATEDIF(A1,A3,\"ym\")&\" mois\"","v":"7 mois"}]
["2009-05-15",null,"ou mieux "]
[]
[null,null,"http://www.techonthenet.com/excel/formulas/datediff.php"]
[]
[]
["Partir du tableau pour générer le formulaire"]
[]
["Pas besoin de la notion report"]
[]
["revoir avec marjolaine le formulaire une fois la base de faite"]

{"sheet":"Feuil8","index":4,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,0,69,9],[71,0,81,9],[34,0,34,1],[35,0,35,1],[38,0,38,9],[40,4,40,9],[53,0,53,9],[55,0,55,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[27,3,27,4],[27,5,27,6],[28,3,28,4],[28,5,28,6],[31,0,31,9],[33,0,33,1],[33,5,33,9],[10,2,11,2],[12,1,12,2],[12,4,12,6],[20,1,21,4],[24,0,24,9],[26,3,26,6],[0,0,0,9],[4,0,4,9],[6,2,7,2],[6,3,6,9],[8,1,8,2],[8,3,9,3],[8,4,8,5],[8,7,8,9]]}
["FICHE CONTRAT INSTITUT LANGEVIN"]
[]
[null,null,null,null,null,null,null,"STATUT *"]
[]
["INFORMATIONS GENERALES"]
[]
["Acronyme du projet *",null,"Titre complet du projet"]
[]
["Responsable Scientifique  *",null,null,"Coordinateur Scientifique\n (si différent)",null,null,"Laboratoire"]
[]
["Organisme de Gestion  *",null,"Code EOTP/Réf Tutelle",null,"Financement  *","Privé","DÉPENSES A JUSTIFIER : ",{"$f":"IF(F11=\"Public\",\"OUI\",\"NON\")","v":"NON"},"Mention pouvant être effacée"]
[]
["Type de Projet  *",null,null,"Sous Catégorie"]
[]
[]
["Date de Début  *",null,"Date de Fin  *",null,"Date de Signature",null,null,"Durée du contrat",{"$f":"DATEDIF(B16,D16,\"ym\")&\" mois\"","v":"0 mois"}]
[]
[null,"N°","Date "]
["Avenant"]
[]
["Autres partenaires  *"]
[]
[]
[]
["Partie propre au CNRS"]
[]
[null,null,null,"CODE BFC - EOTP"]
[null,null,null,"Personnel",null,"Toutes dépenses"]
[null,null,null,{"$f":"IF(B11=\"CNRS\",(CONCATENATE(D11,\"1\")),\"\")","v":""},null,{"$f":"IF(B11=\"CNRS\",(CONCATENATE(D11,\"2\")),\"\")","v":""}]
[]
[]
["BUDGET"]
[]
["Montant total avec frais de gestion (assiette)  *",null,null,null,null,"Répartition des dépenses"]
["Frais de Gestion  *",null,null,"%",null,"Personnel","sur Personne Mois","Équipement","Mission","Fonctionnement"]
["Montant disponible pour l'unité (hors frais)",null,{"$f":"C34-C35","v":0}]
[]
[]
["MISES EN PLACE DE CREDITS"]
[]
[null,null,null,null,"Répartition des encaissements par année"]
["Mise en place","Personnel","Toutes dépenses",null,{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+1))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+2))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+3))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+4))","v":""},{"$f":"IF(ISBLANK(B16),\"\",(YEAR(B16)+5))","v":""}]
[]
[]
[]
[]
[]
[]
[]
["Total versé",{"$f":"SUM(B43:B49)","v":0},{"$f":"SUM(C43:C49)","v":0}]
["Reste à verser",{"$f":"F36-B50","v":0},{"$f":"SUM(H36:J36)-C50","v":0}]
[]
[]
["PERSONNEL SUR LE PROJET"]
[]
["Personne recrutée",null,null,"Salaire mensuel dont taxes et charges (€)","Nombre homme/mois sur projet","Coût total"]
["Nom","Prénom","Fonction"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Total : "]
[null,null,null,null,"Total : "]
[]
[]
["OBSERVATIONS"]