{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Explications","Nature","Base de coûts","Amortissements","Description des couts ","Plan d'affaires","Financement entreprise","Synthese","Aide prévisionnelle","CheckList","Synthèse par LOT"],"not_rendered":{"charts":11,"images":6,"macros":1,"external_links":2,"defined_names":20,"comments":4,"pivot_tables":25},"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":"Explications","index":0,"n_rows":31,"n_cols":494,"rows_kept":31,"cut":false,"hidden":false,"merged":[[29,3,29,10],[30,3,30,10],[14,493,14,499],[1,1,2,12],[13,493,13,499],[4,493,4,499],[6,493,6,499],[7,493,11,499],[3,493,3,499],[4,3,4,10],[9,3,9,10],[5,3,5,6],[5,7,5,10],[6,3,6,6],[6,7,6,10],[25,3,27,10],[13,3,13,10],[10,3,10,10],[18,3,21,10],[17,3,17,10],[24,3,24,10],[15,3,15,10],[14,3,14,10]]}
[]
[null,"Annexe 2\nInvestissements d'Avenir ADEME",null,null,null,null,null,null,null,null,null,null,null,null,"Garder la protection",null,"Oui"]
[]
[null,null,null,null,null,null,null,"version 2.6 ADEME du 30 septembre 2019",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Principes généraux"]
[null,null,null,"  Principes généraux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le document contient 3 types d'onglets :\n1/ Onglets blancs : aide au remplissage de la base de données\n2/ Onglets bleus : informations à compléter par les partenaires\n3/ Onglets gris : tableaux d'évaluation destinés à l'ADEME et automatiquement générés (aucune action des partenaires)"]
[null,null,null,"Le document contient 2 types d'onglets :",null,null,null,"Les onglets bleus contiennent 2 types de cellules  :"]
[null,null,null,"1/ Onglets blancs : aide au remplissage de la base coûts\n\n2/ Onglets bleus : informations à compléter par le porteur de projet\n\n",null,null,null,"1/ Cellules blanches, qui doivent être complétées par le porteur de projet des différentes informations demandées,\n\n2/ Celulles Grises, qui contiennent des formules de calcul découlant des informations rentrées dans les cellules blanches,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Catégorie d'aide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1/ RI (Recherche industrielle) et DE (Développement expérimental)\n\n\n\n3/ PE (Protection de l'Environnement)\n\n"]
[]
[null,null,null," Onglet \"Nature\" : Définitions de la typologie des coûts"]
[null,null,null,"\n1/ Se familiariser avec les différentes natures de coûts possibles\n\n2/ Se familiariser avec les définitions des coûts \"Non retenus\", \"Non éligibles et \"Eligibles\""]
[]
[]
[null,null,null,"  Onglet \"Base de coûts\" : Compléter la base de coûts du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\n"]
[null,null,null,"A L'ATTENTION DU PORTEUR DE PROJET:\n\n- L'unité de temps pour décrire le découpage de l'ensemble du projet sur chaque ligne a été fixée ausemestre.Si une tache se déroule sur 2 ans, soit 4 semestres, décomposer les coûts en 4 semestres soit 4 lignes pour la même tâche.\n\n- Ne renseigner qu'une valeur par cellule.\n\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le tableau de l'onglet \"Synthèse\" est à insérer dans le dossier de candidature."]
[null,null,null,"1/ Remplir chaque ligne en précisant :\n\n- les informations liées à la structure du planning du projet dans les colonnes A à G,\n\n- le détail des coûts, dans les colonnes H à AB.\n\nLes coûts sont à exprimer hors TVA sauf pour les dépenses de sous-traitance en cas de non assujettissement à la TVA  ou d'assujettissement partiel du bénéficiaire et pour les frais de missions qui doivent toujours être exprimés en TTC.\n\n2/ En cas de besoin, une zone libre a été laissée à l'usage du porteur de projet pour transmettre à l'ADEME des commentaires pertinents pour l'instruction."]
[]
[null,null,null,"  Onglet \"Amortissements\" : Tableau d'amortissement des capex et des équipements de R&D"]
[null,null,null,"Renseigner par lot, par tâche, par sous-tâche et par partenaire  :\n\n- la désignation et la description des differents biens acquis pour le projet,\n\n- la valeur d'acquisition, le semestre projet d'acquisition et la durée d'amortissement comptable (en semestre),\n\n- l'estimation de la part d'utilisation du bien affectée au projet (%) et la durée d'utilisation dans le cadre du projet en semestre,\n"]
[]
[]
[]
[]
[]
[null,null,null,"  Onglet \"Descriptions des coûts\" : Tableau de description des coûts"]
[null,null,null,"Renseigner par lot, par tâche, par sous-tache et par partenaire  :\n\n- La nature des coûts, les fournisseurs pressentis, la localisation, les biens achetés et leur montant,\n\n- Tout autre commentaire necessaire à l'instruction et à la bonne compréhension des coûts par l'ADEME"]
[]
[]
[]
[null,null,null," Onglets \"Plan d'affaires\" et \"Financement entreprise\""]
[null,null,null,"-Plan d'affaires : Concerne les prévisions d'activités de l'entreprise et du projet \n\n- Financement entreprise :  Concerne le prévisionnel de l'entreprise sur l'intégralité de son activité, chaque année, projet déposé inclus."]

{"sheet":"Nature","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[6,1,6,6],[9,1,9,2],[8,1,8,2],[9,3,9,4],[8,3,8,4],[8,5,8,6],[9,5,9,6]]}
[]
[null,"Définition des différents types de nature des coûts (colonnes S à Y de l'onglet \"base de coûts\")"]
[]
[null,"Salaires chargés non environnés","Frais connexes","Coûts de sous-traitance","Contribution aux amortissements","Coûts de refacturation interne","Frais de mission","Autres coûts"]
[null,"Dépenses de personnel employés exclusivement pour le projet, comprenant les salaires, les charges sociales afférentes et les indémnités de stage, hors frais généraux.","Les frais connexes sont les dépenses qui concourent à la réalisation du projet sans toutefois pouvoir être directement attribués à celui-ci.\n\nLe montant des frais connexes est forfaitaire et est calculé de la façon suivante :\n20% des salaires chargés non environnés","La sous-traitance s’effectue entre entreprises différentes (= SIREN différents), y compris membres d’un même groupe.\n\nSont éligibles les coûts de la recherche contractuelle, des connaissances techniques et d'achat de brevets et les coûts des prestations de services utilisés exclusivement pour l'activité du projet.\n\n","Coûts des instruments et du matériel utilisés pour le projet.\n\nSeuls les coûts d'amortissements correspondant à la durée du projet, calculés conformément aux pratiques comptables, sont admissibles.\n","La refacturation interne s’effectue au sein d’une même entreprise (= même SIREN).\n\nLa refacturation interne peut être éligible sous réserve :\n\n- d'être calculée sur une base précise d'unités identifiées (heure/lots/etc.),\n- d'être justifiée de façon précise quant à sa quotité affectée au projet,\n- de pouvoir faire l'objet d'une certification par un commissaire aux comptes ou expert-comptable.","Frais des déplacements liés à la réalisation du projet.\n\nFrais réels dont les justificatifs seront à fournir. Ils doivent être prévus et exprimés en TTC.","Autres frais d'exploitation résultant directement de l'activité du projet.\n\nCe sont les coûts des instruments et du matériel utilisés pour les besoins du projet. \n\nSi les instruments et le matériel ne sont pas utilisés pendant toute leur durée de vie pour le projet, alors seuls les coûts d'amortissement correspondant à la durée du projet, calculés conformément aux pratiques comptables, sont jugés admissibles"]
[]
[null,"Définition des catégories de coûts (colonne AB \"classification\"de l'onglet \"base de coûts\")"]
[]
[null,"Eligibles (DE)",null,"Non éligibles (NE)",null,"Non retenu (NR)"]
[null,"Les dépenses éligibles et retenues sont détaillées dans le régime d’aide de l’ADEME exempté de notification n° SA.59357 disponible en ligne, relatif aux aides à la Recherche, au Développement et à l’Innovation (RDI) et à la protection de l’environnement (LDE).\n\nLe dépenses du projet devront relever intégralement d’une ou de plusieurs catégories suivantes, définies dans le précédant régime :\n- recherche fondamentale ;\n- recherche industrielle ;\n- développement expérimental ;\n- études de faisabilité.\n\nA titre d'exemple, les dépenses d'industrialisation ne seraient pas éligibles.\n\nLien: https://ec.europa.eu/competition/state_aid/cases1/202046/289299_2204854_21_1.pdf",null,"Les coûts suivants ne sont pas éligibles dans le cas général : \n- les dépenses de communication/marketing, d’homologation/certification/normalisation, de dépôt de brevet ou de mise aux normes ;\n- les coûts de génie civil et les pertes d’exploitation dans la plupart des cas ;\n- Certaines dépenses d'industrialisations ;\n- une partie des investissements (cf. FAQ, notamment amortissement hors projet)\n\nCette liste n’est pas exhaustive. ",null,"Les coûts hors projet ou non necéssaire au projet ou considéré comme tel suite l’instruction approfondie du projet par les instructeurs de l’ADEME."]

{"sheet":"Base de coûts","index":2,"n_rows":156,"n_cols":34,"rows_kept":156,"cut":false,"hidden":false,"merged":[[1,4,1,6],[2,4,2,6],[0,0,0,4]]}
["Base de données des coûts du projet",null,null,null,null,null,null,"Homme.mois cat 1","Homme.mois cat 2","Homme.mois cat 3","Homme.mois cat 4","Homme.mois cat 5","Total Homme.mois",null,null,null,null,null,"Salaires chargés non environnés","Frais connexes","Coûts de sous-traitance","Contribution aux amortissements","Coût de refacturation interne","Frais de Mission","Autres coûts","Commentaires","Total des coûts",null,null,"Total coûts éligibles et retenus","Total coûts non éligibles","Total coûts non retenus","Total coûts non éligibles et non retenus","Aide totale"]
[null,null,null,null,"TOTAL =>",null,null,{"$f":"SUM(H10:H157)","v":0},{"$f":"SUM(I10:I157)","v":0},0,0,0,0,null,null,null,null,null,{"$f":"SUM(S10:S157)","v":0},{"$f":"SUM(T5:T155)","v":0},0,0,0,0,0,null,{"$f":"SUM(AA5:AA155)","v":0},null,null,{"$f":"SUM(AD10:AD157)","v":0},0,0,0,0]
[null,null,null,"NOM DU PROJET A RENSEIGNER","SOUS-TOTAL =>",null,null,{"$f":"SUBTOTAL(9,H10:H157)","v":0},{"$f":"SUBTOTAL(9,I10:I157)","v":0},0,0,0,0,null,null,null,null,null,{"$f":"SUBTOTAL(9,S10:S157)","v":0},{"$f":"SUBTOTAL(9,T5:T155)","v":0},0,0,0,0,0,null,{"$f":"SUBTOTAL(9,AA5:AA155)","v":0},null,null,{"$f":"SUBTOTAL(9,AD10:AD156)","v":0},{"$f":"SUBTOTAL(9,AE10:AE157)","v":0},0,0,0]
[]
[null,null,null,"CATEGORIE D'ENTREPRISE A SELECTIONNER\n<=Sélectionner \"PE\" ou \"ME\""]
[null,null,null,"Effectif de l'entreprise en ETP"]
[null,null,null,"Durée du projet (en mois)"]
[]
[null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES",null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES",null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
["Lot","Tache","Sous-tache","Intitulé de l'activité","Semestre","Livrable","Etape-clef","Homme.mois cat 1","Homme.mois cat 2","Homme.mois cat 3","Homme.mois cat 4","Homme.mois cat 5","Total Homme.mois","Salaires cat 1","Salaires cat 2","Salaires cat 3","Salaires cat 4","Salaires cat 5","Salaires chargés non environnés","Frais connexes (forfaitaires)","Coûts de sous-traitance","Contributions aux amortissements","Coûts de refacturation interne","Frais de mission","Autres coûts","Commentaires","Total des coûts","Classification","Taux aide","Total coûts éligibles et retenus","Total coûts non éligibles","Total coûts non retenus","Total coûts non éligibles et non retenus","Aide totale"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H11:L11)","v":0},null,null,null,null,null,{"$f":"H11*N11+I11*O11+J11*P11+K11*Q11+L11*R11","v":0},{"$f":"20%*S11","v":0},null,null,null,null,null,null,{"$f":"S11+SUM(T11:Y11)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB11=\"DE\",AA11,0)","v":0},{"$f":"IF(AB11=\"NE\",AA11,0)","v":0},{"$f":"IF(AB11=\"NR\",AA11,0)","v":0},{"$f":"AE11+AF11","v":0},{"$f":"AD11*AC11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H12:L12)","v":0},null,null,null,null,null,{"$f":"H12*N12+I12*O12+J12*P12+K12*Q12+L12*R12","v":0},{"$f":"20%*S12","v":0},null,null,null,null,null,null,{"$f":"S12+SUM(T12:Y12)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB12=\"DE\",AA12,0)","v":0},{"$f":"IF(AB12=\"NE\",AA12,0)","v":0},{"$f":"IF(AB12=\"NR\",AA12,0)","v":0},{"$f":"AE12+AF12","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H13:L13)","v":0},null,null,null,null,null,{"$f":"H13*N13+I13*O13+J13*P13+K13*Q13+L13*R13","v":0},{"$f":"20%*S13","v":0},null,null,null,null,null,null,{"$f":"S13+SUM(T13:Y13)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB13=\"DE\",AA13,0)","v":0},{"$f":"IF(AB13=\"NE\",AA13,0)","v":0},{"$f":"IF(AB13=\"NR\",AA13,0)","v":0},{"$f":"AE13+AF13","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,{"$f":"AD43*AC43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,{"$f":"AD75*AC75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H77:L77)","v":0},null,null,null,null,null,{"$f":"H77*N77+I77*O77+J77*P77+K77*Q77+L77*R77","v":0},{"$f":"20%*S77","v":0},null,null,null,null,null,null,{"$f":"S77+SUM(T77:Y77)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB77=\"DE\",AA77,0)","v":0},{"$f":"IF(AB77=\"NE\",AA77,0)","v":0},{"$f":"IF(AB77=\"NR\",AA77,0)","v":0},{"$f":"AE77+AF77","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,{"$f":"AD107*AC107","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,{"$f":"AD139*AC139","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H141:L141)","v":0},null,null,null,null,null,{"$f":"H141*N141+I141*O141+J141*P141+K141*Q141+L141*R141","v":0},{"$f":"20%*S141","v":0},null,null,null,null,null,null,{"$f":"S141+SUM(T141:Y141)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB141=\"DE\",AA141,0)","v":0},{"$f":"IF(AB141=\"NE\",AA141,0)","v":0},{"$f":"IF(AB141=\"NR\",AA141,0)","v":0},{"$f":"AE141+AF141","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,0,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H155:L155)","v":0},null,null,null,null,null,{"$f":"H155*N155+I155*O155+J155*P155+K155*Q155+L155*R155","v":0},{"$f":"20%*S155","v":0},null,null,null,null,null,null,{"$f":"S155+SUM(T155:Y155)","v":0},null,{"$f":"IF(C$5=\"ME\",0.35,IF(C$5=\"PE\",0.45,0))","v":0},{"$f":"IF(AB155=\"DE\",AA155,0)","v":0},{"$f":"IF(AB155=\"NE\",AA155,0)","v":0},{"$f":"IF(AB155=\"NR\",AA155,0)","v":0},{"$f":"AE155+AF155","v":0},0]
[null,null,null,"NE PAS COPIER/COLLER DE LIGNE EN-DESSOUS"]

{"sheet":"Amortissements","index":3,"n_rows":56,"n_cols":32,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
["Tableau d'amortissement d'équipements de R&D"]
["(comptes éligibles du PGC : 6122, 6135 et 6811)",null,null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
[null,null,null,null,null,null,null,"ONGLET A REMPLIR OBLIGATOIREMENT"]
["Lot","Tache","Sous-tâche","Intitulé de l'activité","Désignation et description\nde l'équipement amorti","Valeur d'acquisition (€)","Semestre projet d'acquisition","Durée d'amortissement comptable (en semestre)","Amortissement semestriel (€)","Nombre de semestre d'utilisation dans le cadre du projet ","Part d'utilisation affectée au projet (%)","Contribution aux amortissements sur le semestre (€)","Commentaires"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(F5/H5,\"\")","v":""},null,null,{"$f":"IFERROR(I5*K5*J5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(F6/H6,\"\")","v":""},null,null,{"$f":"IFERROR(I6*K6*J6,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(F49/H49,\"\")","v":""},null,null,{"$f":"IFERROR(I49*K49*J49,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(F50/H50,\"\")","v":""},null,null,{"$f":"IFERROR(I50*K50*J50,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR",null,null,null,"NR"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(F51/H51,\"\")","v":""},null,null,{"$f":"IFERROR(I51*K51*J51,\"\")","v":""}]
[null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[null,null,null,null,null,null,null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,"",null,null,""]
[null,null,"NE PAS COPIER/COLLER DE LIGNE EN-DESSOUS"]

{"sheet":"Description des couts ","index":4,"n_rows":95,"n_cols":30,"rows_kept":95,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[94,6,94,10],[94,0,94,1],[94,2,94,5]]}
["Description des coûts"]
[null,null,null,null,null,null,null,null,null,"PASSER LA SOURIS SUR LES CELLULES BLEUES POUR VISUALISER LES COMMENTAIRES"]
[null,null,null,null,null,null,null,"ONGLET A REMPLIR OBLIGATOIREMENT"]
["Lot","Tache","Sous-tâche","Intitulé de l'activité","Semestre d'utilisation","Nature des coûts","Fournisseur pressenti","Localisation","Bien acheté","Montant unitaire (€)","Commentaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"NE PAS COPIER/COLLER DE LIGNE EN-DESSOUS"]

{"sheet":"Plan d'affaires","index":5,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[20,1,34,1],[60,2,60,3],[61,2,61,3],[64,2,64,3],[54,2,54,3],[55,2,55,3],[58,2,58,3],[59,2,59,3],[47,2,47,3],[48,2,48,3],[51,2,51,3],[46,2,46,3],[56,2,56,3],[38,2,38,3],[42,2,42,3],[53,2,53,3],[73,2,73,3],[66,1,69,1],[70,1,73,1],[67,2,67,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[66,2,66,3],[8,1,18,1],[8,2,8,10],[9,2,11,2],[12,2,14,2],[15,2,17,2],[18,2,18,3],[7,2,7,3],[34,2,34,3],[21,2,21,3],[25,2,25,3],[22,2,22,3],[27,2,27,3],[28,2,28,3],[33,2,33,3],[30,2,30,3],[32,2,32,3],[23,2,23,3],[24,2,24,3],[26,2,26,3],[31,2,31,3],[29,2,29,3],[20,2,20,3],[36,1,48,1],[50,1,64,1],[39,2,39,3],[41,2,41,3],[45,2,45,3],[63,2,63,3],[52,2,52,3],[62,2,62,3],[57,2,57,3],[50,2,50,3],[36,2,36,3],[43,2,43,3],[44,2,44,3],[40,2,40,3]]}
[null,"Prévision d'activités de l'entreprise et du projet  : OBLIGATOIRE"]
[null,"Copier / coller le 1er tableau (CHIFFRE D'AFFAIRES ISSU DU PROJET) dans le dossier de candidature (PARTIE 2, paragraphe 8)"]
[null,"Durée à considérer pour le remplisage = Durée du projet + 3 ans "]
[null,"Remplir les cases en blanche et l'année de départ. L'année de départ = année du dépôt du projet"]
[null,"Charges à comptabiliser en négatif, produits en positif"]
[]
[]
[null,null,"Montants exprimés en (€)",null,"Année de départ",{"$f":"IF($E$8=\"Année de départ\",\"\",E8+1)","v":""},{"$f":"IF($E$8=\"Année de départ\",\"\",F8+1)","v":""},"","","",""]
[null,"PROJET","CHIFFRE D'AFFAIRES ISSU DU PROJET\nà décliner par unité d'œuvre : produits, services, royalties, licences, … "]
[null,null,"-Unité d'œuvre 1 : (remplir la définiton)","Chiffre d'affaire / an",{"$f":"E12*E11","v":0},{"$f":"F12*F11","v":0},0,0,0,0,0]
[null,null,null,"Nombre d'unités vendue / an"]
[null,null,null,"Prix unitaire"]
[null,null,"-Unité d'œuvre 2:\n(remplir la définiton)","Chiffre d'affaire / an",{"$f":"E14*E15","v":0},{"$f":"F14*F15","v":0},0,0,0,0,0]
[null,null,null,"Nombre d'unités vendue / an"]
[null,null,null,"Prix unitaire"]
[null,null,"-Unité d'œuvre 3:\n(remplir la définiton)","Chiffre d'affaire / an",{"$f":"E17*E18","v":0},{"$f":"F17*F18","v":0},0,0,0,0,0]
[null,null,null,"Nombre d'unités vendue / an"]
[null,null,null,"Prix unitaire"]
[null,null,"TOTAL CHIFFRE D'AFFAIRES GENERE PAR LES RESULTATS DU PROJET",null,{"$f":"SUM(E10,E13,E16)","v":0},0,0,0,0,0,0]
[]
[null,"PROJET","Autres produits liés au projet (dont subventions d'exploit.)"]
[null,null,"Produits du projet",null,{"$f":"E19+E21","v":0},0,0,0,0,0,0]
[null,null,"Achats (marchandises et matières premières)"]
[null,null," +/- Variation de stock de matières et marchandises (inclus prod. Immobilisée et stockée)"]
[null,null,"Charges du personnel (Salaires & cotisations sociales)"]
[null,null,"Sous-traitance"]
[null,null,"Refacturation interne"]
[null,null,"Frais de mission"]
[null,null,"Crédit-bail et location"]
[null,null,"Frais connexes"]
[null,null,"Impôts, taxes et versements assimilés"]
[null,null,"Autres produits et charges d'exploitation"]
[null,null,"Excédent brut d'exploitation projet",null,{"$f":"E22+SUM(E23:E32)","v":0},{"$f":"F22+SUM(F23:F32)","v":0},0,0,0,0,0]
[null,null,"Dotations aux amortissements d'exploitation"]
[null,null,"Dotations aux provisions"]
[]
[null,"HORS PROJET","TOTAL CHIFFRE D'AFFAIRE  HORS PROJET "]
[null,null,null,"dont subventions d'exploitation reçues"]
[null,null,"Achats (marchandises et matières premières)"]
[null,null," +/- Variation de stock de matières et marchandises (inclus prod. Immobilisée et stockée)"]
[null,null,"Charges du personnel (Salaires & cotisations sociales)"]
[null,null,"Sous-traitance"]
[null,null,"Crédit-bail et location"]
[null,null,"Autres charges externes"]
[null,null,"Impôts, taxes et versements assimilés"]
[null,null,"Autres produits et charges d'exploitation"]
[null,null,"Excédent brut d'exploitation hors projet",null,{"$f":"E37+SUM(E39:E46)","v":0},0,0,0,0,0,0]
[null,null,"Dotations aux amortissements d'exploitation (dont épréciations)"]
[null,null,"Dotations aux provisions (pour risques et charges)"]
[]
[null,"TOTAL ENTREPRISE","Chiffre d'affaires total",null,{"$f":"E37+E19","v":0},0,0,0,0,0,0]
[null,null,"Excédent brut d'exploitation total",null,{"$f":"E47+E33","v":0},0,0,0,0,0,0]
[null,null,"Excédent brut d'exploitation/chiffre d'affaires total",null,{"$f":"IFERROR(E52/E51,\"\")","v":""},"","","","","",""]
[null,null,"Produits financiers"]
[null,null,"Charges financières"]
[null,null,"Amortissements et provisions financières"]
[null,null,"Résultat courant avant impôts total entreprise",null,{"$f":"E47+E33+SUM(E54:E56)+SUM(E34:E35,E48:E49)","v":0},0,0,0,0,0,0]
[null,null,"Résultat courant avant impôts/chiffre d'affaires total",null,{"$f":"IFERROR(E57/E51,\"\")","v":""},"","","","","",""]
[null,null,"Produits exceptionnels"]
[null,null,"Charges exceptionnelles"]
[null,null,"Amortissements et provisions exceptionnelles"]
[null,null,"Impôts sur les bénéfices (dont crédit impôt recherche)"]
[null,null,"RESULTAT DE L'EXERCICE",null,{"$f":"E57+SUM(E59:E62)","v":0},0,0,0,0,0,0]
[null,null,"Résultat de l'exercice/chiffre d'affaires total",null,{"$f":"IFERROR(E63/E51,\"\")","v":""},"","","","","",""]
[null,null,"CAF",null,{"$f":"E63-E56-E61-E48-E49-E35-E34","v":0},0,0,0,0,0,0]
[]
[null,"PROJET","Emplois créés grâce au projet :",null,{"$f":"SUM(E68:E70)","v":0},0,0,0,0,0,0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]
[null,"ENTREPRISE","Effectif global de l'entreprise :",null,{"$f":"SUM(E72:E74)","v":0},0,0,0,0,0,0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]

{"sheet":"Financement entreprise","index":6,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[16,17,16,22],[17,17,17,22],[21,17,21,22],[24,17,24,23],[18,17,19,23],[20,17,20,23],[22,17,23,23],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[13,7,14,7],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,23,4],[22,5,22,6],[23,5,23,6],[7,2,7,6],[8,2,8,6],[9,2,9,6],[13,5,13,6],[14,5,14,6],[11,2,11,6],[12,2,12,6],[10,2,10,6],[13,2,14,4],[13,1,18,1],[8,1,9,1],[10,1,12,1],[18,2,18,6],[15,2,15,6],[16,2,16,6],[17,2,17,6]]}
[null,null," Plan de financement prévisionnel de l'entreprise (phases R&D et d’exploitation des résultats) : OBLIGATOIRE"]
[null,null,null,"Remplir les cases en blanche et l'année de départ. L'année de départ = année du dépôt du projet"]
[null,null,null,"Concerne le prévisionnel de l'entreprise sur l'intégralité de son activité, chaque année, projet déposé inclus."]
[null,null,null,"Dépenses =  dépenses matériels ou immatériels"]
[]
[]
[]
[null,null,"Montants exprimés en (€)",null,null,null,null,{"$f":"IF($I$8=\"Année de départ\",\"\",I8-1)","v":""},"Année de départ",{"$f":"IF($I$8=\"Année de départ\",\"\",I8+1)","v":""},"","","","",""]
[null,"PROJET","Dépenses du projet déposé - (Etude, R&D, investissements, essais...)"]
[null,null,"Dépenses post projet déposé - (Investissements, lancement industriel et commercial …)"]
[null,"HORS PROJET","Dépenses liées à la R&D de l'entreprise (hors dépenses liées au projet déposé)"]
[null,null,"Autres investissements de l'entreprise (hors projets R&D, hors dépenses liées au projet déposé)"]
[null,null,"Dépenses courantes de l'entreprise (hors projets R&D et dépenses liées projet déposé) dont charges/produits financiers et exceptionnels et impôts"]
[null,"ENTREPRISE","Besoin en fonds de roulement ",null,null,"Augmentation (+)"]
[null,null,null,null,null,"Diminution (-)"]
[null,null,"Remboursement de crédits"]
[null,null,"Remboursement d'avances récupérables (Concours d'innovation + autres)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Information sur les versements de l'aide (à titre indicatif, qui pourra être recalculé durant l'instruction ) :"]
[null,null,"Divers (dont distribution de dividendes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projet dont le coût total < 1 M€ : "]
[null,null,"TOTAL DES BESOINS",null,null,null,null,null,{"$f":"SUM(I9:I18)","v":0},0,0,0,0,0,0,null,null," - 1er versement lors de l'année de dépôt du projet, correspondant à 70% du montant de l'aide dans la limite de 200 k€ maximum,"]
[null,null,"Augmentation de capital"]
[null,null,"Apports en comptes courants",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - 2e versement correspondant au complémentaire de l'aide, à la clôture du projet "]
[null,null,"Chiffre d'affaires total",null,null,null,null,null,{"$f":"'Plan d''affaires'!E51","v":0},{"$f":"'Plan d''affaires'!F51","v":0},{"$f":"'Plan d''affaires'!G51","v":0},{"$f":"'Plan d''affaires'!H51","v":0},{"$f":"'Plan d''affaires'!I51","v":0},{"$f":"'Plan d''affaires'!J51","v":0},{"$f":"'Plan d''affaires'!K51","v":0},null,null,"Projet dont le coûts total ≥ 1 M€ : "]
[null,null,"Emprunts ",null,null,"Déjà négociés",null,null,null,null,null,null,null,null,null,null,null," - 1er versement lors de l'année de dépôt du projet, correspondant à 70% du montant de l'aide dans la limite de 200 k€ maximum,"]
[null,null,null,null,null,"Restant à négocier"]
[null,null,"Versements Aide Concours d'innovation  *",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Dernier versement correspondant au minimum à 20% de l'aide, lors du solde du projet"]
[null,null,"Autres aides publiques prévues (dont Crédit Impôt Recherche)",null,null,null,null,null,null,null,null,null,null,null,null,null,null," - Un versement par année sur la durée du projet (valeur moyenne, par an, sur le montant restant)"]
[null,null,"TOTAL DES RESSOURCES",null,null,null,null,null,{"$f":"SUM(I20:I26)","v":0},0,0,0,0,0,0]
[null,null,"SOLDE DE TRESORERIE",null,null,null,null,null,{"$f":"I27-I19","v":0},0,0,0,0,0,0]
[null,null,"TRESORERIE FIN DE PERIODE CUMULEE",null,null,null,null,null,{"$f":"H29+I28","v":0},0,0,0,0,0,0]

{"sheet":"Synthese","index":7,"n_rows":102,"n_cols":20,"rows_kept":102,"cut":false,"hidden":false,"merged":[[0,3,0,7]]}
[null,null,null,"Synthèse des coûts du projet"]
[null,null,null,"Copier / coller ce tableau dans le dossier de candidature"]
[null,null,null,"Valeurs"]
[null,null,null,"Salaires chargés environnés :",0]
[null,null,null,"Frais connexes (forfaitaires) :",0]
[null,null,null,"Coûts de sous-traitance :"]
[null,null,null,"Contributions aux amortissements :"]
[null,null,null,"Frais de mission :"]
[null,null,null,"Coûts de refacturation interne :"]
[null,null,null,"Autres coûts :"]
[null,null,null,"Total des coûts :",0]
[]
[]
[]
[null,null,null,"Étiquettes de lignes","Total des coûts :"]
[null,null,null,"(vide)",0]
[null,null,null,"Total général",0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Étiquettes de lignes","Total des coûts :",null,null,null,"Étiquettes de lignes","Total des coûts :"]
[null,null,null,"(vide)",0,null,null,null,"(vide)",0]
[null,null,null,"Total général",0,null,null,null,"Total général",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Étiquettes de lignes"," Total coûts éligibles et retenus"," Total coûts non éligibles et non retenus",null,null,null,null,null,null,"Total des coûts :","Étiquettes de colonnes"]
[null,null,null,"(vide)",0,0,null,null,null,null,null,null,"Étiquettes de lignes","(vide)","Total général"]
[null,null,null,"Total général",0,0,null,null,null,null,null,null,"(vide)",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total général",0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Étiquettes de lignes","Somme de Total.Homme"]
[null,null,null,"(vide)",0,null,null,null," ",null,null,null,"Étiquettes de lignes","Salaires chargés environnés :","Frais connexes (forfaitaires) :","Coûts de sous-traitance :","Contributions aux amortissements :","Frais de mission :","Coûts de refacturation interne :","Autres coûts :"]
[null,null,null,"Total général",0,null,null,null,null,null,null,null,"(vide)",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total général",0,0]

{"sheet":"Aide prévisionnelle","index":8,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,2,0,6]]}
[null,null,"Aide prévisionnelle au projet"]
[]
[null,null,"Coûts totaux","Assiette retenue des coûts éligibles","Montant d'aide totale"]
[null,null,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," % subvention/aide totale"," % d'avance remboursable/aide total"," % aide totale/ coûts éligibles et retenus"," Effet levier"]
[null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,null,"Valeurs"]
[null,null,"Total Homme.mois ",0]
[null,null,"Coûts totaux (€)",0]
[null,null,"Coûts éligibles et retenus (€)",0]
[null,null,"Aide totale (€)",0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Contrôle de cohérence"]
[null,null,"Part de subvention (%)",{"$f":"IFERROR(D25/D27,\"\")","v":""},{"$f":"IFERROR(E25/E27,\"\")","v":""},"","","","","",""]
[null,null,"Part d'avances remboursables (%)",{"$f":"IFERROR(D26/D27,\"\")","v":""},"","","","","","",{"$f":"IFERROR(K27/K26,\"\")","v":""}]
[null,null,"Taux d'aide globale (%)",{"$f":"IFERROR(D27/D19,\"\")","v":""},"","","","","","",""]
[null,null,"Taux d'aide RI",{"$f":"IFERROR(D25/(D$21+D$22)/D$31,\"\")","v":""},"","","","","","",{"$f":"IFERROR(K25/K21,\"\")","v":""}]
[null,null,"Taux d'aide DE",{"$f":"IFERROR(D26/(D$21+D$22)/D$32,\"\")","v":""},"","","","","",null,{"$f":"IFERROR(K26/K22,\"\")","v":""}]
[null,null,"Taux d'aide PE",{"$f":"IFERROR(D26/(D$24)/D$32,\"\")","v":""},"","","","",""]
[]
[]
[]
[]
[null,null,"Étiquettes de lignes"]
[null,null,"(vide)"]
[null,null,"Total"]

{"sheet":"CheckList","index":9,"n_rows":86,"n_cols":13,"rows_kept":86,"cut":false,"hidden":true,"merged":[[82,1,82,2],[82,3,82,4],[82,6,82,7],[82,8,82,9],[43,2,43,4],[56,2,56,4],[79,1,79,3],[68,1,68,3],[69,2,69,4],[70,2,70,4],[1,1,1,3],[7,1,7,3],[13,1,13,3],[8,2,8,4],[14,2,14,4],[24,2,24,4],[29,1,29,3],[42,1,42,3],[55,1,55,3],[23,1,23,3]]}
[]
[null,"Contrôle Nb Homme.mois",null,null,null,null,"Paramètre"]
[null,null,"Part des ETP projet par rapport ETP entreprise :",null,null,{"$f":"IF(MAX(C6)<G3,1,0)","v":1},0.3]
[null,null,"Total Homme.mois "]
[null,null,0]
[null,"(ETPprojet)/ (ETPentreprise)",{"$f":"IFERROR(C5/('Base de coûts'!C6*'Base de coûts'!C7),\"\")","v":""}]
[]
[null,"Contrôle des salaires",null,null,null,null,"Paramètre"]
[null,null,"Salaires par catégorie Inférieurs à 15 000 € :",null,null,{"$f":"IF(MAX(B12:M12)>G9,0,1)","v":1},15000]
[]
[null,"Max de Salaires cat 1","Max de Salaires cat 2","Max de Salaires cat 3","Max de Salaires cat 4","Max de Salaires cat 5"]
[]
[]
[null,"Contrôle coûts de gestion projet",null,null,null,null,"Paramètre"]
[null,null,"Inférieur à 7% sur le projet et 7% par partenaire :",null,null,{"$f":"IF(MAX(C22:N22)>G15,0,1)","v":1},7.0000000000000007E-2]
[]
[null,"Intitulé de l'activité","(Tous)"]
[]
[null,"Total des coûts "]
[null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M21/(#REF!),\"\")","v":""}]
[]
[null,"Contrôle sous-traitance",null,null,null,null,"Paramètre"]
[null,null,"Part de la sous-traitance par rapport au cout total :",null,null,{"$f":"IFERROR(IF(MAX(B28:G28)>G25,0,1),0)","v":0},0.3]
[]
[null,"Somme de soustrait/couts tot"]
[null,{"$error":"#DIV/0!"}]
[]
[null,"Contrôle des frais mission",null,null,null,null,"Paramètre"]
[null,null,"Frais de missions inférieur à 800€/homme.mois :",null,null,{"$f":"IF(MAX(C34:G41)>G31,0,1)","v":1},800]
[]
[null,"Étiquettes de lignes","Somme de frais mission/Tot.Hommes.mois"]
[null,"(vide)",0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Contrôle des coûts eligible et retenu"]
[null,null,"Coûts éligibles et retenus =  Total coûts RI+Total coûts DE+Coûts PE Admissibles :",null,null,{"$f":"IF(AVERAGE(G47:G55)<1,0,1)","v":1}]
[]
[null," Total coûts éligibles et retenus"]
[null,0,null,null,null,null,{"$f":"IF(ROUND(C47+E47+D47,2)=ROUND(F47,2),1,0)","v":1}]
[null,null,null,null,null,null,{"$f":"IF(ROUND(C48+E48+D48,2)=ROUND(F48,2),1,0)","v":1}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"IF(ROUND(C50+E50+D50,2)=ROUND(F50,2),1,0)","v":1}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,1]
[]
[]
[]
[null,"Controle des coûts non éligibles et non retenus"]
[null,null,"Coûts non éligibles et non retenus = Total coûts NE+Total coûts NR+Coûts PE non Admissibles :",null,null,{"$f":"IF(AVERAGE(G60:G67)<1,0,1)","v":1}]
[]
[null,"Total coûts non éligibles "," Total coûts non retenus"," Total coûts non éligibles et non retenus"]
[null,0,0,0,null,null,{"$f":"IF(ROUND(C60+E60+D60,2)=ROUND(F60,2),1,0)","v":1}]
[null,null,null,null,null,null,{"$f":"IF(ROUND(C61+E61+D61,2)=ROUND(F61,2),1,0)","v":1}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"IF(ROUND(C63+E63+D63,2)=ROUND(F63,2),1,0)","v":1}]
[null,null,null,null,null,null,{"$f":"IF(ROUND(C64+E64+D64,2)=ROUND(F64,2),1,0)","v":1}]
[null,null,null,null,null,null,1]
[]
[]
[]
[null,"Controle % Sub et % AR"]
[null,null,"Contrôle du % subvention par partenaire :",null,null,{"$f":"IFERROR(IF(AVERAGE(C76:K76)<1,0,1),0)","v":0}]
[null,null,"Contrôle du % AR par partenaire :",null,null,{"$f":"IFERROR(IF(AVERAGE(C77:K77)<1,0,1),0)","v":0}]
[null,"Valeurs"]
[null," % de subvention",{"$error":"#NAME?"}]
[null," % d'AR",{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((HLOOKUP(J73,Matrice_clefs,7,FALSE)*(1-HLOOKUP(J73,Matrice_clefs,5,FALSE)))=J74,\"\")","v":""},{"$f":"IFERROR((HLOOKUP(K73,Matrice_clefs,7,FALSE)*(1-HLOOKUP(K73,Matrice_clefs,5,FALSE)))=K74,\"\")","v":""}]
[]
[]
[]
[]
[null,"Contrôle amortissement et des coûts"]
[]
[]
[null,"BDD",null,"Onglet Amortissements",null,null,"BDD",null,"Onglet Description des coûts"]
[null,"Étiquettes de lignes","Contributions aux amortissements :","Étiquettes de lignes","Contribution aux amortissements sur le semestre (€) ",null,"Étiquettes de lignes","Somme de Description des couts","Étiquettes de lignes","Montant unitaire (€) "]
[null,"Total général",null,"(vide)",0,null,"Total général",0,"(vide)"]
[null,null,null,"Total général",0,null,null,null,"Total général"]

{"sheet":"Synthèse par LOT","index":10,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Étiquettes de colonnes"]
[null,null,"   ",null,"Total en €","Groupe2",null,"Total en €","Total des dépenses pour l'opération en €"]
["Étiquettes de lignes","Valeurs","Total RI","Total DE",null,"Total NE","Total NR",null,null,null,"Contrôles :"]
["Total Salaires chargés non environnés :",null,null,null,null,null,null,null,0,null,"Salaires chargés non environnés :",{"$f":"IF(SUMIF(B6:B200,\"Salaires chargés non environnés :\",F6:F200)=SUMIF(A6:A200,\"Total Salaires chargés non environnés :\",F6:F200),1,0)","v":1}]
["Total Frais connexes (forfaitaires) :",null,null,null,null,null,null,null,0,null,"Dont salaires chargés non environnés personnels permanents :",{"$f":"IF(SUMIF(B6:B200,\"Dont salaires chargés non environnés personnels permanents :\",F6:F200)=SUMIF(A6:A200,\"Total Dont salaires chargés non environnés personnels permanents :\",F6:F200),1,0)","v":1}]
["Total Coûts de sous-traitance :",null,null,null,null,null,null,null,0,null,"Frais connexes (forfaitaires) :",{"$f":"IFERROR(IF(IF(OR(HLOOKUP(B1,Matrice_clefs,2,FALSE)=\"ER 40%*coûts complets\",HLOOKUP(B1,Matrice_clefs,2,FALSE)=\"GE\",HLOOKUP(B1,Matrice_clefs,2,FALSE)=\"ME\",HLOOKUP(B1,Matrice_clefs,2,FALSE)=\"PE\"),0.2*SUMIF(A3:A200,\"Total Salaires chargés non environnés :\",E3:E200),4%*SUMIF(A3:A200,\"Total Contribution aux amortissements :\",E3:E200)+8%*(SUMIF(A3:A200,\"Total Coûts de sous-traitance :\",E3:E200)+SUMIF(A3:A200,\"Total Coûts de refacturation interne :\",E3:E200)+SUMIF(A3:A200,\"Total Frais de mission :\",E3:E200)+SUMIF(A3:A200,\"Total Salaires chargés non environnés :\",E3:E200)-SUMIF(A3:A200,\"Total Dont salaires chargés non environnés personnels permanents :\",E3:E200)))=SUMIF(A3:A200,\"Total Frais connexes (forfaitaires) :\",E3:E200),1,0),0)","v":0}]
["Total Contributions aux amortissements :",null,null,null,null,null,null,null,0,null,"Coûts de sous-traitance :",{"$f":"IF(SUMIF(B6:B200,\"Coûts de sous-traitance :\",F6:F200)=SUMIF(A6:A200,\"Total Coûts de sous-traitance :\",F6:F200),1,0)","v":1}]
["Total Coûts de refacturation interne :",null,null,null,null,null,null,null,0,null,"Contributions aux amortissements :",{"$f":"IF(SUMIF(B6:B200,\"Contributions aux amortissements :\",F6:F200)=SUMIF(A6:A200,\"Total Contributions aux amortissements :\",F6:F200),1,0)","v":1}]
["Total Frais de mission :",null,null,null,null,null,null,null,0,null,"Coûts de refacturation interne :",{"$f":"IF(SUMIF(B6:B200,\"Coûts de refacturation interne :\",F6:F200)=SUMIF(A6:A200,\"Total Coûts de refacturation interne :\",F6:F200),1,0)","v":1}]
["Total Autres coûts :",null,null,null,null,null,null,null,0,null,"Frais de mission :",{"$f":"IF(SUMIF(B6:B200,\"Frais de mission :\",F6:F200)=SUMIF(A6:A200,\"Total Frais de mission :\",F6:F200),1,0)","v":1}]
["Total Coûts totaux :",null,null,null,null,null,null,null,0]