{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Note d'information","Données réelles","Données prévisionnelles"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1490,"comments":2,"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":"Note d'information","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,32,5]]}
[]
[null,"Note d'information :"]
[null,"\nPour chaque entreprise partenaire du consortium (demandeur d'aide) développant une activité dans le cadre du projet, il est demandé de compléter les onglets suivants :\n     - Données réelles;\n     - Données prévisionnelles.\n\nPour chacun de ces deux onglets, les cellules sur fond jaune ou blanche sont à renseigner. Les Cellules grisées sont à laisser en l'état.\nLes produits sont à comptabiliser positivement, les charges négativement.\n\nDonnées réelles :\nCet onglet vise à présenter les bilans et comptes de résultat du partenaire au titre des trois derniers exercices comptables. \nLa source d'information privilégiée est la liasse fiscale. Néanmoins, en l'absence de cette dernière, les comptes annuels peuvent faire office de référence.\nRappel : les copies des liasses fiscales des trois derniers exercices (ou comptes annuels) sont également des pièces à fournir au dossier (confère annexe 3b).\n\nDonnées prévisionnelles :\nCet onglet vise à présenter les hypothèses de marché, les comptes de résultat prévisionnels ainsi que le plan de financement du partenaire.\nL'information est présentée sur une base trimestrielle jusqu'au dernier exercice comptable concerné par le projet, puis annuelle sur les années suivantes.\nAfin de mieux appréhender l'impact du projet sur l'activité du partenaire, ainsi que sur son plan de financement, une distinction des comptes de résultat prévisionnels projet/hors projet vous est demandée.\n\nNous vous invitons à anticiper toute question pouvant découler de l'analyse approfondie de ces deux onglets en documentant de manière appropriée l'annexe 3b."]

{"sheet":"Données réelles","index":1,"n_rows":121,"n_cols":32,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,4,1,7],[8,4,8,8],[18,2,18,3],[30,2,30,3],[31,2,31,3],[11,2,11,3],[28,2,28,3],[29,2,29,3],[2,4,2,7],[3,4,3,7],[4,4,4,7],[5,4,5,7],[25,2,25,3],[17,2,17,3],[6,4,6,7],[8,2,9,3],[10,2,10,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[19,2,19,3],[21,2,21,3],[115,2,115,3],[99,2,99,3],[91,2,91,3],[97,2,97,3],[92,2,92,3],[93,2,93,3],[106,2,106,3],[98,2,98,3],[95,2,95,3],[112,2,112,3],[89,2,89,3],[107,2,107,3],[102,2,102,3],[90,2,90,3],[110,2,110,3],[114,2,114,3],[96,2,96,3],[113,2,113,3],[103,2,103,3],[109,2,109,3],[108,2,108,3],[105,2,105,3],[101,2,101,3],[111,2,111,3],[22,2,22,3],[24,2,24,3],[26,2,26,3],[27,2,27,3],[32,2,32,3],[34,2,34,3],[35,2,35,3],[84,2,84,3],[66,2,66,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[49,2,49,3],[52,2,52,3],[42,2,42,3],[40,2,41,3],[58,2,58,3],[50,2,50,3],[68,2,68,3],[74,2,74,3],[40,4,40,8],[20,2,20,3],[44,2,44,3],[43,2,43,3],[60,2,60,3],[46,2,46,3],[104,2,104,3],[100,2,100,3],[94,2,94,3],[75,2,75,3],[47,2,47,3],[48,2,48,3],[36,2,36,3],[37,2,37,3],[23,2,23,3],[59,2,59,3],[51,2,51,3],[57,2,57,3],[53,2,53,3],[55,2,55,3],[56,2,56,3],[45,2,45,3],[88,2,88,3],[86,2,87,3],[116,2,116,3],[117,2,117,3],[118,2,118,3],[119,2,119,3],[120,2,120,3],[48,1,52,1],[79,2,79,3],[33,2,33,3],[83,2,83,3],[80,2,80,3],[82,2,82,3],[54,2,54,3],[61,2,61,3],[65,2,65,3],[71,2,71,3],[69,2,69,3],[76,2,76,3],[77,2,77,3],[73,2,73,3],[78,2,78,3],[81,2,81,3],[67,2,67,3],[70,2,70,3],[72,2,72,3]]}
[]
[null,null,"Nom du partenaire :",null,"Est-elle en procédure collective :",null,null,"Est-elle en procédure collective :"]
[null,null,"Nom du projet :",null,"Est-elle une filiale d'une entreprise :"]
[null,null,"Type d'entreprise :",0,{"$f":"IF(I3=\"non\",0,\"Nom de la maison mère :\")","v":"Nom de la maison mère :"}]
[null,null,"Nationalité :",null,{"$f":"IF(I3=\"non\",0,\"Part de la maison mère dans l'entreprise (%) :\")","v":"Part de la maison mère dans l'entreprise (%) :"}]
[null,null,"Forme juridique :",0,{"$f":"IF(I3=\"non\",0,\"Chiffre d'affaires de la maison mère (k€) :\")","v":"Chiffre d'affaires de la maison mère (k€) :"}]
[null,null,"Responsabilité :",null,{"$f":"IF(I3=\"non\",0,\"Nombre de salariés de la maison mère :\")","v":"Nombre de salariés de la maison mère :"}]
[]
[null,null,"   Bilan",null,{"$f":"IF(D4=\"Grande entreprise\",\"MONTANTS EN MILLIERS D'EUROS\",\"MONTANTS EN EUROS\")","v":"MONTANTS EN EUROS"}]
[null,null,null,null,"Clôture au :",null,"Clôture au :",null,"Clôture au :"]
[null,"Réf.","Liasses fiscales (ou arrêté comptable pour le dernier exercice)  ",null,"2021-12-31","Var. (%)",{"$f":"IFERROR(E11-365,\"jj/mm/aaaa-1\")","v":"2020-12-31"},"Var. (%)",{"$f":"IFERROR(G11-366,\"jj/mm/aaaa-2\")","v":"2019-12-31"}]
[null,null,"ACTIF"]
[null,"AA","Capital souscrit non appelé",null,null,{"$f":"IFERROR((E13-G13)/ABS(G13),0)","v":0},null,{"$f":"IFERROR((G13-I13)/ABS(I13),0)","v":0}]
[null,null,"Immobilisations incorporelles nettes",null,null,0,null,{"$f":"IFERROR((G14-I14)/ABS(I14),0)","v":0}]
[null,null,"Immobilisations corporelles nettes",null,null,0,null,{"$f":"IFERROR((G15-I15)/ABS(I15),0)","v":0}]
[null,null,"Immobilisations financières nettes",null,null,0,null,{"$f":"IFERROR((G16-I16)/ABS(I16),0)","v":0}]
[null,"BJ-BK","Actif immobilisé net",null,{"$f":"SUM(E14:E16)","v":0},0,{"$f":"SUM(G14:G16)","v":0},{"$f":"IFERROR((G17-I17)/ABS(I17),0)","v":0},0]
[null,null,"Stocks",null,null,0,null,{"$f":"IFERROR((G18-I18)/ABS(I18),0)","v":0}]
[null,null,"Créances clients",null,null,0,null,{"$f":"IFERROR((G19-I19)/ABS(I19),0)","v":0}]
[null,null,"Autres créances (dont avances versées et CCA)",null,null,0,null,{"$f":"IFERROR((G20-I20)/ABS(I20),0)","v":0}]
[null,null,"Disponibilités (dont VMP)",null,null,0,null,{"$f":"IFERROR((G21-I21)/ABS(I21),0)","v":0}]
[null,"CJ-CK","Actif circulant",null,{"$f":"SUM(E18:E21)","v":0},0,{"$f":"SUM(G18:G21)","v":0},{"$f":"IFERROR((G22-I22)/ABS(I22),0)","v":0},0]
[null,"CO-IA","TOTAL ACTIF",null,{"$f":"E13+E17+E22","v":0},0,{"$f":"G13+G17+G22","v":0},{"$f":"IFERROR((G23-I23)/ABS(I23),0)","v":0},{"$f":"I13+I17+I22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,"PASSIF",null,null,0,null,{"$f":"IFERROR((G24-I24)/ABS(I24),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grande Entreprise","EI","Limitée","Oui"]
[null,"DA","Capital social",null,null,0,null,{"$f":"IFERROR((G25-I25)/ABS(I25),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Petite et Moyenne Ent.","SNC","Illimitée","Non"]
[null,null,"Réserves",null,null,0,null,{"$f":"IFERROR((G26-I26)/ABS(I26),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EURL"]
[null,null,"Report à nouveau",null,null,0,null,{"$f":"IFERROR((G27-I27)/ABS(I27),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SA"]
[null,"DI","Résultat de l'exercice",null,{"$f":"E83","v":0},{"$f":"IFERROR((E28-G28)/ABS(G28),0)","v":0},{"$f":"G83","v":0},{"$f":"IFERROR((G28-I28)/ABS(I28),0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SAS"]
[null,null,"Autres capitaux propres",null,null,{"$f":"IFERROR((E29-G29)/ABS(G29),0)","v":0},null,{"$f":"IFERROR((G29-I29)/ABS(I29),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SASU"]
[null,"DL","Capitaux propres",null,{"$f":"SUM(E25:E29)","v":0},0,{"$f":"SUM(G25:G29)","v":0},{"$f":"IFERROR((G30-I30)/ABS(I30),0)","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCS"]
[null,"DR","Provisions pour risques et charges",null,null,0,null,{"$f":"IFERROR((G31-I31)/ABS(I31),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCA"]
[null,null,"Emprunts et dettes assimilées (échéance +1an)",null,null,0,null,{"$f":"IFERROR((G32-I32)/ABS(I32),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCP"]
[null,null,"Emprunts et dettes assimilées (échéance -1an)",null,null,0,null,{"$f":"IFERROR((G33-I33)/ABS(I33),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEL"]
[null,"EH","Concours bancaires",null,null,0,null,{"$f":"IFERROR((G34-I34)/ABS(I34),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GIE"]
[null,null,"Fournisseurs",null,null,0,null,{"$f":"IFERROR((G35-I35)/ABS(I35),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCM"]
[null,null,"Autres dettes (dont avances reçues et PCA)",null,null,0,null,{"$f":"IFERROR((G36-I36)/ABS(I36),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SCOP"]
[null,"DR+EC","Passif courant",null,{"$f":"SUM(E31:E36)","v":0},0,{"$f":"SUM(G31:G36)","v":0},{"$f":"IFERROR((G37-I37)/ABS(I37),0)","v":0},0]
[null,"EE","TOTAL PASSIF",null,{"$f":"E30+E37","v":0},0,{"$f":"G30+G37","v":0},{"$f":"IFERROR((G38-I38)/ABS(I38),0)","v":0},0]
[null,null,null,"Contrôle équilibre bilan",{"$f":"E23-E38","v":0},null,{"$f":"G23-G38","v":0},null,{"$f":"I23-I38","v":0}]
[]
[null,null," Compte de résultat",null,{"$f":"E9","v":"MONTANTS EN EUROS"}]
[null,null,null,null,"Clôture au :",null,"Clôture au :",null,"Clôture au :"]
[null,"Réf.",{"$f":"C11","v":"Liasses fiscales (ou arrêté comptable pour le dernier exercice)  "},null,{"$f":"E11","v":"2021-12-31"},"Var. (%)",{"$f":"G11","v":"2020-12-31"},"Var. (%)","2019-12-31"]
[null,"FL","Chiffre d'affaires",null,null,{"$f":"IFERROR((E44-G44)/ABS(G44),0)","v":0},null,0]
[null,"FS+FU","Achats (marchandises et matières premières)",null,null,0,null,0]
[null,"FT+FV","Variation de stocks (marchandises et MP)",null,null,0,null,0]
[null,"FM","Production stockée",null,null,0,null,0]
[null,"FN","Production immobilisée",null,null,0,null,0]
[null,"FW","Sous-traitance",null,null,0,null,0]
[null,null,"Crédit-bail",null,null,0,null,0]
[null,null,"Location",null,null,0,null,0]
[null,null,"Interim",null,null,0,null,0]
[null,null,"Autres charges externes",null,null,0,null,0]
[null,null,"Valeur ajoutée",null,{"$f":"SUM(E44:E53)","v":0},0,{"$f":"SUM(G44:G53)","v":0},0,{"$f":"SUM(I44:I53)","v":0}]
[null,null,"Valeur ajoutée/Chiffre d'affaires",null,{"$f":"IFERROR(E54/E44,0)","v":0},0,{"$f":"IFERROR(G54/G44,0)","v":0},0,{"$f":"IFERROR(I54/I44,0)","v":0}]
[null,"FO","Subventions d'exploitation reçues",null,null,0,null,0]
[null,"FX","Impôts et taxes",null,null,0,null,0]
[null,"FY+FZ","Charges de personnel",null,null,0,null,0]
[null,"FQ","Autres produits d'exploitation",null,null,0,null,0]
[null,"GE","Autres charges d'exploitation",null,null,0,null,0]
[null,null,"Excédent brut d'exploitation",null,{"$f":"E54+SUM(E56:E60)","v":0},0,{"$f":"G54+SUM(G56:G60)","v":0},0,{"$f":"I54+SUM(I56:I60)","v":0}]
[null,null,"Excédent brut d'exploitation/Chiffre d'affaires",null,{"$f":"IFERROR(E61/E44,0)","v":0},0,{"$f":"IFERROR(G61/G44,0)","v":0},0,{"$f":"IFERROR(I61/I44,0)","v":0}]
[null,"FP+GA","Dotations aux amortissements d'exploitation",null,null,0,null,0]
[null,"GB.C.D","Dotations aux provisions",null,null,0,null,0]
[null,"GF","Résultat d'exploitation",null,{"$f":"E61+SUM(E63:E64)","v":0},0,{"$f":"G61+SUM(G63:G64)","v":0},0,{"$f":"I61+SUM(I63:I64)","v":0}]
[null,null,"Résultat d'exploitation/Chiffre d'affaires",null,{"$f":"IFERROR(E65/E44,0)","v":0},0,{"$f":"IFERROR(G65/G44,0)","v":0},0,{"$f":"IFERROR(I65/I44,0)","v":0}]
[null,"GP-GN","Produits financiers",null,null,0,null,0]
[null,"GU-GQ","Charges financières",null,null,0,null,0]
[null,"GN-GS","Ecart de change",null,null,0,null,0]
[null,"GQ","Amortissements et provisions financières",null,null,0,null,0]
[null,"GV","Résultat financier",null,{"$f":"SUM(E67:E70)","v":0},0,{"$f":"SUM(G67:G70)","v":0},0,{"$f":"SUM(I67:I70)","v":0}]
[null,null,"Résultat financier/Chiffre d'affaires",null,{"$f":"IFERROR(E71/E44,0)","v":0},0,{"$f":"IFERROR(G71/G44,0)","v":0},0,{"$f":"IFERROR(I71/I44,0)","v":0}]
[null,"GW","Résultat courant avant impôts",null,{"$f":"E65+E71","v":0},0,{"$f":"G65+G71","v":0},0,{"$f":"I65+I71","v":0}]
[null,null,"Résultat courant avant impôts/Chiffre d'affaires",null,{"$f":"IFERROR(E73/E44,0)","v":0},0,{"$f":"IFERROR(G73/G44,0)","v":0},0,{"$f":"IFERROR(I73/I44,0)","v":0}]
[null,"HD","Produits exceptionnels",null,null,0,null,0]
[null,"HH-HG","Charges exceptionnelles",null,null,0,null,0]
[null,"HG","Amortissements et provisions exceptionnelles",null,null,0,null,0]
[null,"HI","Résultat exceptionnel",null,{"$f":"SUM(E75:E77)","v":0},0,{"$f":"SUM(G75:G77)","v":0},0,{"$f":"SUM(I75:I77)","v":0}]
[null,null,"Résultat exceptionnel/Chiffre d'affaires",null,{"$f":"IFERROR(E78/E44,0)","v":0},0,{"$f":"IFERROR(G78/G44,0)","v":0},0,{"$f":"IFERROR(I78/I44,0)","v":0}]
[null,"HU","Participation des salariés aux résultats",null,null,0,null,0]
[null,"HK","Impôts sur les bénéfices",null,null,0,null,0]
[null,null,"Taux d'imposition",null,{"$f":"-IFERROR(E81/(E83-E81-E80),0)","v":0},0,{"$f":"-IFERROR(G81/(G83-G81-G80),0)","v":0},0,{"$f":"-IFERROR(I81/(I83-I81-I80),0)","v":0}]
[null,"HN","RESULTAT DE L'EXERCICE",null,{"$f":"E73+E78+SUM(E80:E81)","v":0},0,{"$f":"G73+G78+SUM(G80:G81)","v":0},0,{"$f":"I73+I78+SUM(I80:I81)","v":0}]
[null,null,"Résultat de l'exercice/Chiffre d'affaires",null,{"$f":"IFERROR(E83/E44,0)","v":0},0,{"$f":"IFERROR(G83/G44,0)","v":0},0,{"$f":"IFERROR(I83/I44,0)","v":0}]
[null,null,"Effectif (ETP)",null,null,0,null,0]
[]
[null,null,"    Ratios/indicateurs",null,"Clôture au :",null,"Clôture au :",null,"Clôture au :"]
[null,null,null,null,{"$f":"E11","v":"2021-12-31"},"Var. (%)",{"$f":"G11","v":"2020-12-31"},"Var. (%)",{"$f":"I11","v":"2019-12-31"}]
[null,null,"Analyse des grandes masses du bilan"]
[null,null,"1. Fond de roulement (FR)",null,{"$f":"E30+E31+E32-E17","v":0},{"$f":"IFERROR((E90-G90)/ABS(G90),0)","v":0},{"$f":"G30+G31+G32-G17","v":0},0,{"$f":"I30+I31+I32-I17","v":0}]
[null,null,"    FR en jours de chiffre d'affaires",null,{"$f":"IFERROR(E90/E44*365.25,0)","v":0},{"$f":"IFERROR((E91-G91)/ABS(G91),0)","v":0},{"$f":"IFERROR(G90/G44*365.25,0)","v":0},0,{"$f":"IFERROR(I90/I44*365.25,0)","v":0}]
[null,null,"2. Besoin en fond de roulement (BFR)",null,{"$f":"(E22-E21)-(SUM(E35:E36)+E33)","v":0},{"$f":"IFERROR((E92-G92)/ABS(G92),0)","v":0},{"$f":"(G22-G21)-(SUM(G35:G36)+G33)","v":0},0,{"$f":"(I22-I21)-(SUM(I35:I36)+I33)","v":0}]
[null,null,"    BFR en jours de chiffre d'affaires",null,{"$f":"IFERROR(E92/E44*365.25,0)","v":0},{"$f":"IFERROR((E93-G93)/ABS(G93),0)","v":0},{"$f":"IFERROR(G92/G44*365.25,0)","v":0},0,{"$f":"IFERROR(I92/I44*365.25,0)","v":0}]
[null,null,"  a/ Crédit fournisseur (jours)",null,{"$f":"-IFERROR(E35/(E45+SUM(E49:E53))*365.25,0)","v":0},{"$f":"IFERROR((E94-G94)/ABS(G94),0)","v":0},{"$f":"-IFERROR(G35/(G45+SUM(G49:G53))*365.25,0)","v":0},0,{"$f":"-IFERROR(I35/(I45+SUM(I49:I53))*365.25,0)","v":0}]
[null,null,"  b/ Crédit clients (jours)",null,{"$f":"IFERROR(E19/E44*365.25,0)","v":0},{"$f":"IFERROR((E95-G95)/ABS(G95),0)","v":0},{"$f":"IFERROR(G19/G44*365.25,0)","v":0},0,{"$f":"IFERROR(I19/I44*365.25,0)","v":0}]
[null,null,"  c/ Rotation des stocks (jours)",null,{"$f":"-IFERROR((E18/E44)*365.25,0)","v":0},{"$f":"IFERROR((E96-G96)/ABS(G96),0)","v":0},{"$f":"-IFERROR((G18/G44)*365.25,0)","v":0},0,{"$f":"-IFERROR((I18/I44)*365.25,0)","v":0}]
[null,null,"    FR/BFR",null,{"$f":"IFERROR(E90/E92,0)","v":0},{"$f":"IFERROR((E97-G97)/ABS(G97),0)","v":0},{"$f":"IFERROR(G90/G92,0)","v":0},0,{"$f":"IFERROR(I90/I92,0)","v":0}]
[null,null,"3. Trésorerie nette (TN)",null,{"$f":"E21-E34","v":0},{"$f":"IFERROR((E98-G98)/ABS(G98),0)","v":0},{"$f":"G21-G34","v":0},0,{"$f":"I21-I34","v":0}]
[null,null,"Analyse de la capacité financière"]
[null,null,"1. Capacité d'autofinancement (CAF)",null,{"$f":"E83-E63-E64-E70-E77","v":0},{"$f":"IFERROR((E100-G100)/ABS(G100),0)","v":0},{"$f":"G83-G63-G64-G70-G77","v":0},0,{"$f":"I83-I63-I64-I70-I77","v":0}]
[null,null,"2. Emprunts/CAF",null,{"$f":"IFERROR(SUM(E32:E33)/E100,0)","v":0},{"$f":"IFERROR((E101-G101)/ABS(G101),0)","v":0},{"$f":"IFERROR(SUM(G32:G33)/G100,0)","v":0},0,{"$f":"IFERROR(SUM(I32:I33)/I100,0)","v":0}]
[null,null,"    Emprunts/excédent brut d'exploitation",null,{"$f":"IFERROR(SUM(E32:E33)/E61,0)","v":0},{"$f":"IFERROR((E102-G102)/ABS(G102),0)","v":0},{"$f":"IFERROR(SUM(G32:G33)/G61,0)","v":0},0,{"$f":"IFERROR(SUM(I32:I33)/I61,0)","v":0}]
[null,null,"3. Résultat de l'exercice/capitaux propres",null,{"$f":"IFERROR(E83/E30,0)","v":0},{"$f":"IFERROR((E103-G103)/ABS(G103),0)","v":0},{"$f":"IFERROR(G83/G30,0)","v":0},0,{"$f":"IFERROR(I83/I30,0)","v":0}]
[null,null,"4. Capitaux propres/emprunts",null,{"$f":"IFERROR(E30/(SUM(E32:E33)),0)","v":0},{"$f":"IFERROR((E104-G104)/ABS(G104),0)","v":0},{"$f":"IFERROR(G30/(SUM(G32:G33)),0)","v":0},0,{"$f":"IFERROR(I30/(SUM(I32:I33)),0)","v":0}]
[null,null,"    Capitaux propres/total bilan",null,{"$f":"IFERROR(E30/E23,0)","v":0},{"$f":"IFERROR((E105-G105)/ABS(G105),0)","v":0},{"$f":"IFERROR(G30/G23,0)","v":0},0,{"$f":"IFERROR(I30/I23,0)","v":0}]
[null,null,"    Actif circulant/Passif court terme",null,{"$f":"IFERROR(E22/SUM(E33:E36),0)","v":0},{"$f":"IFERROR((E106-G106)/ABS(G106),0)","v":0},{"$f":"IFERROR(G22/SUM(G33:G36),0)","v":0},0,{"$f":"IFERROR(I22/SUM(I33:I36),0)","v":0}]
[null,null,"Autres ratios d'exploitation"]
[null,null,"1. Charges de personnel/chiffre d'affaires",null,{"$f":"-IFERROR(E58/E44,0)","v":0},{"$f":"IFERROR((E108-G108)/ABS(G108),0)","v":0},{"$f":"-IFERROR(G58/G44,0)","v":0},0,{"$f":"-IFERROR(I58/I44,0)","v":0}]
[null,null,"    (Interim+sous-traitance)/charges de personnel",null,{"$f":"IFERROR((E52+E49)/E58,0)","v":0},{"$f":"IFERROR((E109-G109)/ABS(G109),0)","v":0},{"$f":"IFERROR((G52+G49)/G58,0)","v":0},0,{"$f":"IFERROR((I52+I49)/I58,0)","v":0}]
[null,null,"2. Résultat d'exploitation/(Actif immobilisé+BFR)",null,{"$f":"IFERROR(E65/(E17+E92),0)","v":0},{"$f":"IFERROR((E110-G110)/ABS(G110),0)","v":0},{"$f":"IFERROR(G65/(G17+G92),0)","v":0},0,{"$f":"IFERROR(I65/(I17+I92),0)","v":0}]
[null,null,"    Dotations aux amortissements/actif immobilisé",null,{"$f":"-IFERROR((E63+E64+E70+E77)/E17,0)","v":0},{"$f":"IFERROR((E111-G111)/ABS(G111),0)","v":0},{"$f":"-IFERROR((G63+G64+G70+G77)/G17,0)","v":0},0,{"$f":"-IFERROR((I63+I64+I70+I77)/I17,0)","v":0}]
[null,null,"    Crédit-bail/dotations aux amortissements d'expl",null,{"$f":"IFERROR(E50/E63,0)","v":0},{"$f":"IFERROR((E112-G112)/ABS(G112),0)","v":0},{"$f":"IFERROR(G50/G63,0)","v":0},0,{"$f":"IFERROR(I50/I63,0)","v":0}]
[null,null,"3. CAF/chiffre d'affaires",null,{"$f":"IFERROR(E100/E44,0)","v":0},{"$f":"IFERROR((E113-G113)/ABS(G113),0)","v":0},{"$f":"IFERROR(G100/G44,0)","v":0},0,{"$f":"IFERROR(I100/I44,0)","v":0}]
[null,null,"    Valeur ajoutée/effectif",null,{"$f":"IFERROR(E54/E85,0)","v":0},{"$f":"IFERROR((E114-G114)/ABS(G114),0)","v":0},{"$f":"IFERROR(G54/G85,0)","v":0},0,{"$f":"IFERROR(I54/I85,0)","v":0}]
[null,null,"    Valeur ajoutée/actif immobilisé",null,{"$f":"IFERROR(E54/E17,0)","v":0},{"$f":"IFERROR((E115-G115)/ABS(G115),0)","v":0},{"$f":"IFERROR(G54/G17,0)","v":0},0,{"$f":"IFERROR(I54/I17,0)","v":0}]
[null,null,"    Actif immobilisé/effectif",null,{"$f":"IFERROR(E17/E85,0)","v":0},{"$f":"IFERROR((E116-G116)/ABS(G116),0)","v":0},{"$f":"IFERROR(G17/G85,0)","v":0},0,{"$f":"IFERROR(I17/I85,0)","v":0}]
[null,null,"Indicateurs entreprises en difficulté"]
[null,null,"Capitaux propres / capital social",null,{"$f":"IFERROR(E30/E25,0)","v":0},{"$f":"IFERROR((E118-G118)/ABS(G118),0)","v":0},{"$f":"IFERROR(G30/G25,0)","v":0},{"$f":"IFERROR((G118-I118)/ABS(I118),0)","v":0},{"$f":"IFERROR(I30/I25,0)","v":0}]
[null,null,"Consommation des fonds propres",null,{"$f":"IFERROR(ABS(SUMIF(E25:E29,\"<0\",E25:E29)/(SUMIF(E25:E29,\">0\"))),0)","v":0},0,{"$f":"IFERROR(ABS(SUMIF(G25:G29,\"<0\",G25:G29)/(SUMIF(G25:G29,\">0\"))),0)","v":0},0,{"$f":"IFERROR(ABS(SUMIF(I25:I29,\"<0\",I25:I29)/(SUMIF(I25:I29,\">0\"))),0)","v":0}]
[null,null,"Emprunts / capitaux propres",null,{"$f":"IFERROR((SUM(E32:E33)/E30),0)","v":0},0,{"$f":"IFERROR((SUM(G32:G33)/G30),0)","v":0},0,{"$f":"IFERROR((SUM(I32:I33)/I30),0)","v":0}]
[null,null,"Charges financières/excédent brut d'exploitation",null,{"$f":"-IFERROR(E68/E61,0)","v":0},0,{"$f":"-IFERROR(G68/G61,0)","v":0},0,{"$f":"-IFERROR(I68/I61,0)","v":0}]

{"sheet":"Données prévisionnelles","index":2,"n_rows":108,"n_cols":37,"rows_kept":108,"cut":false,"hidden":false,"merged":[[81,1,83,2],[101,1,102,2],[8,1,8,2],[72,1,75,1],[72,2,72,3],[73,2,73,3],[74,2,74,3],[75,2,75,3],[76,1,79,1],[76,2,76,3],[77,2,77,3],[78,2,78,3],[79,2,79,3],[49,2,49,3],[50,2,50,3],[51,2,51,3],[54,2,54,3],[56,1,70,1],[56,2,56,3],[57,2,57,3],[58,2,58,3],[59,2,59,3],[60,2,60,3],[61,2,61,3],[62,2,62,3],[63,2,63,3],[64,2,64,3],[65,2,65,3],[66,2,66,3],[67,2,67,3],[36,2,36,3],[37,2,37,3],[68,2,68,3],[69,2,69,3],[70,2,70,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[52,2,52,3],[53,2,53,3],[40,1,54,1],[9,1,20,1],[84,1,99,1],[13,2,16,2],[17,2,20,2],[92,2,92,3],[93,2,93,3],[95,2,95,3],[22,1,23,2],[24,1,38,1],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[2,4,2,5],[3,4,3,5],[107,2,107,3],[84,2,84,3],[90,2,90,3],[97,2,97,3],[99,2,99,3],[98,2,98,3],[103,2,103,3],[104,2,104,3],[89,2,89,3],[91,2,91,3],[88,2,88,3],[96,2,96,3],[94,2,94,3],[38,2,38,3],[4,4,4,5],[5,4,5,5],[82,4,82,5],[9,2,12,2],[106,2,106,3],[86,2,86,3],[87,2,87,3],[105,2,105,3],[85,2,85,3],[22,4,22,5],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,"Partenaire :",{"$f":"'Données réelles'!D2","v":0},null,"Projet :"]
[null,null,null,null,"Date de dernière modification :"]
[null,null,"Début de projet :",null,"Investissement projet porté (k€) :"]
[null,null,"Durée projet (mois) :",null,"Taux d'aide envisagé (%) :"]
[null,null,"Fin de projet :",{"$f":"IF(D5=0,0,D4+D5*30)","v":"00:00:00"},"Montant d'aide envisagé (k€)  :"]
[]
[]
[null," Hypothèses marché",null,"Clôture au:",{"$f":"'Données réelles'!E11","v":"2021-12-31"},{"$f":"IFERROR(E9+365,\"jj/mm/aaaa+1\")","v":"2022-12-31"},{"$f":"IFERROR(F9+365,\"jj/mm/aaaa+2\")","v":"2023-12-31"},{"$f":"IFERROR(G9+365,\"jj/mm/aaaa+2\")","v":"2024-12-30"},"2025-12-30","2026-12-30","2027-12-30","2028-12-29",{"$f":"IFERROR(L9+365,\"jj/mm/aaaa+2\")","v":"2029-12-29"}]
[null,"Projet","Unité d'œuvre 1 : \n(remplir la définiton)","Prix unité d'œuvre"]
[null,null,null,"Vol. UO scenario nominal"]
[null,null,null,"CA scenario nominal",null,{"$f":"F10*F11","v":0},{"$f":"G10*G11","v":0},0,0,{"$f":"J10*J11","v":0},0,0,{"$f":"M10*M11","v":0}]
[null,null,null,"Part de marché (%)"]
[null,null,"Unité d'œuvre 2 : \n(remplir la définiton)","Prix unité d'œuvre"]
[null,null,null,"Vol. UO scenario nominal"]
[null,null,null,"CA scenario nominal",null,{"$f":"F14*F15","v":0},0,0,0,{"$f":"J14*J15","v":0},0,0,{"$f":"M14*M15","v":0}]
[null,null,null,"Part de marché (%)"]
[null,null,"Unité d'œuvre 1 : \n(remplir la définiton)","Prix unité d'œuvre"]
[null,null,null,"Vol. UO scenario nominal"]
[null,null,null,"CA scenario nominal",null,{"$f":"F18*F19","v":0},0,0,0,{"$f":"J18*J19","v":0},0,0,{"$f":"M18*M19","v":0}]
[null,null,null,"Part de marché (%)"]
[]
[null," Compte de résultat prévisionnel",null,null,"MONTANTS EN EUROS"]
[null,null,null,{"$f":"D9","v":"Clôture au:"},"2021-12-31","2022-12-31","2023-12-31","2024-12-30","2025-12-30","2026-12-30","2027-12-30","2028-12-29","2029-12-29"]
[null,"PROJET","Autres produits liés au projet (dont subventions d'exploit.)"]
[null,null,"Produits du projet",null,null,{"$f":"F20+F25","v":0},0,0,0,0,0,{"$f":"L20+L25","v":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,"Autres coûts"]
[null,null,"Frais connexes"]
[null,null,"Impôts, taxes et versements assimilés"]
[null,null,"Crédit-bail et location"]
[null,null,"Excédent brut d'exploitation projet",null,null,{"$f":"F26+SUM(F27:F36)","v":0},0,0,0,0,0,{"$f":"L26+SUM(L27:L36)","v":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,"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"]
[null,null,"Location"]
[null,null,"Interim"]
[null,null,"Autres charges externes"]
[null,null,"Subventions d'exploitation reçues"]
[null,null,"Impôts et taxes"]
[null,null,"Autres produits et charges d'exploitation"]
[null,null,"Excédent brut d'exploitation hors projet",null,null,{"$f":"F41+SUM(F42:F52)","v":0},{"$f":"G41+SUM(G42:G52)","v":0},0,0,0,0,{"$f":"L41+SUM(L42:L52)","v":0},0]
[null,null,"Dotations aux amortissements d'exploitation"]
[null,null,"Dotations aux provisions"]
[]
[null,"TOTAL ENTREPRISE","Chiffre d'affaires total",null,null,{"$f":"F41+F20","v":0},0,0,0,0,0,{"$f":"L41+L20","v":0},0]
[null,null,"Excédent brut d'exploitation total",null,null,{"$f":"F53+F37","v":0},0,0,0,0,0,{"$f":"L53+L37","v":0},0]
[null,null,"Excédent brut d'exploitation/chiffre d'affaires total",null,{"$f":"IFERROR(E58/E57,\"\")","v":""},{"$f":"IFERROR(F58/F57,\"\")","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,null,{"$f":"F53+F37+SUM(F60:F62)+SUM(F38:F39,F54:F55)","v":0},0,0,0,0,0,{"$f":"L53+L37+SUM(L60:L62)+SUM(L38:L39,L54:L55)","v":0},0]
[null,null,"Résultat courant avant impôts/chiffre d'affaires total",null,{"$f":"IFERROR(E63/E57,\"\")","v":""},{"$f":"IFERROR(F63/F57,\"\")","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,null,{"$f":"F63+SUM(F65:F68)","v":0},{"$f":"G63+SUM(G65:G68)","v":0},0,0,0,0,{"$f":"L63+SUM(L65:L68)","v":0},0]
[null,null,"Résultat de l'exercice/chiffre d'affaires total",null,{"$f":"IFERROR(E69/E57,\"\")","v":""},{"$f":"IFERROR(F69/F57,\"\")","v":""},{"$f":"IFERROR(G69/G57,\"\")","v":""},"","","","","",""]
[null,null,"CAF",null,{"$f":"E69-E62-E67-E54-E55-E39-E38","v":0},{"$f":"F69+F62+F67+F54+F55+F39+F38","v":0},{"$f":"G69+G62+G67+G54+G55+G39+G38","v":0},{"$f":"H69+H62+H67+H54+H55+H39+H38","v":0},0,0,0,{"$f":"L69+L62+L67+L54+L55+L39+L38","v":0},0]
[]
[null,"PROJET","Emplois créés grâce au projet :",null,{"$f":"SUM(E74:E76)","v":0},{"$f":"SUM(F74:F76)","v":0},0,0,0,0,0,{"$f":"SUM(L74:L76)","v":0},0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]
[null,"TOTAL ENTREPRISE","Effectif global de l'entreprise :",null,{"$f":"SUM(E78:E80)","v":0},{"$f":"SUM(F78:F80)","v":0},0,0,0,0,0,{"$f":"SUM(L78:L80)","v":0},0]
[null,null,"-R&D"]
[null,null,"-Industriel"]
[null,null,"-Autres"]
[]
[null,"Plan de financement prévisionnel"]
[null,null,null,null,"MONTANTS EN EUROS"]
[null,null,null,{"$f":"D9","v":"Clôture au:"},"2021-12-31","2022-12-31","2023-12-31","2024-12-30","2025-12-30",{"$f":"J9","v":"2026-12-30"},"2027-12-30","2028-12-29","2029-12-29"]
[null,"Total","SOLDE TRESORERIE",null,{"$f":"'Données réelles'!G98","v":0},{"$f":"E100","v":0},{"$f":"F100","v":0},0,0,0,0,0,0]
[null,null,"CAPEX projet (investissements)"]
[null,null,"BFR",null,{"$f":"'Données réelles'!E92","v":0}]
[null,null,"Remboursements emprunt"]
[null,null,"Remboursements ADEME (si avance remboursable)"]
[null,null,"Autres besoin de trésorerie (dont distribution divid.)"]
[null,null,"Total des besoins",null,null,{"$f":"SUM(F86:F90)","v":0},{"$f":"SUM(G86:G90)","v":0},0,0,0,0,0,0]
[null,null,"Augmentation de capital"]
[null,null,"Apports en comptes courants d'associés"]
[null,null,"Capacité/besoin d'autofinancement",null,{"$f":"'Données réelles'!E100","v":0},{"$f":"F69-F54-F55-F67-F62","v":0},{"$f":"G69-G54-G55-G67-G62","v":0},0,0,0,0,0,0]
[null,null,"Souscription d'emprunts"]
[null,null,"Aide ADEME (seulement avance remboursable)"]
[null,null,"Autres aides publiques prévues"]
[null,null,"Total des ressources",null,null,{"$f":"SUM(F92:F97)","v":0},{"$f":"SUM(G92:G97)","v":0},0,0,0,0,0,0]
[null,null,"FLUX DE TRESORERIE",null,null,{"$f":"F98-F91","v":0},{"$f":"G98-G91","v":0},0,0,0,0,0,0]
[null,null,"TRESORERIE FIN DE PERIODE",null,{"$f":"'Données réelles'!E98","v":0},{"$f":"F85+F99","v":0},{"$f":"G85+G99","v":0},0,0,0,0,0,0]
[]
[null,"    Ratios/indicateurs"]
[null,null,null,"Clôture au:",{"$f":"E9","v":"2021-12-31"},{"$f":"F9","v":"2022-12-31"},"2023-12-31","2024-12-30","2025-12-30",{"$f":"J9","v":"2026-12-30"},"2027-12-30","2028-12-29","2029-12-29"]
[null,null,"Résultat de l'exercice/capitaux propres",null,{"$f":"'Données réelles'!E103","v":0},{"$f":"IFERROR(SUM(F69)/('Données réelles'!$E$30+SUM($F$92:F92)),0)","v":0},{"$f":"IFERROR(SUM(G69)/('Données réelles'!$E$30+SUM($F$92:G92)),0)","v":0},{"$f":"IFERROR(SUM(H69)/('Données réelles'!$E$30+SUM($F$92:H92)),0)","v":0},{"$f":"IFERROR(SUM(I69)/('Données réelles'!$E$30+SUM($F$92:I92)),0)","v":0},{"$f":"IFERROR(SUM(J69)/('Données réelles'!$E$30+SUM($F$92:J92)),0)","v":0},{"$f":"IFERROR(SUM(K69)/('Données réelles'!$E$30+SUM($F$92:K92)),0)","v":0},{"$f":"IFERROR(SUM(L69)/('Données réelles'!$E$30+SUM($F$92:L92)),0)","v":0},{"$f":"IFERROR(SUM(M69)/('Données réelles'!$E$30+SUM($F$92:M92)),0)","v":0}]
[null,null,"Capitaux propres/emprunts",null,{"$f":"'Données réelles'!E104","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:F92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:F95)-SUM($F$88:F88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:G92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:G95)-SUM($F$88:G88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:H92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:H95)-SUM($F$88:H88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:I92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:I95)-SUM($F$88:I88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:J92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:J95)-SUM($F$88:J88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:K92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:K95)-SUM($F$88:K88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:L92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:L95)-SUM($F$88:L88)),0)","v":0},{"$f":"IFERROR(('Données réelles'!$E$30+SUM($F$92:M92))/(SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:M95)-SUM($F$88:M88)),0)","v":0}]
[null,null,"Emprunts/CAF",null,{"$f":"'Données réelles'!E101","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:F95)-SUM($F$88:F88))/SUM(F94:F94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:G95)-SUM($F$88:G88))/SUM(G94:G94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:H95)-SUM($F$88:H88))/SUM(H94:H94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:I95)-SUM($F$88:I88))/SUM(I94:I94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:J95)-SUM($F$88:J88))/SUM(J94:J94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:K95)-SUM($F$88:K88))/SUM(K94:K94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:L95)-SUM($F$88:L88))/SUM(L94:L94)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:M95)-SUM($F$88:M88))/SUM(M94:M94)),0)","v":0}]
[null,null,"Emprunts/excédent brut d'exploitation",null,{"$f":"'Données réelles'!E102","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:F95)-SUM($F$88:F88))/SUM(F58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:G95)-SUM($F$88:G88))/SUM(G58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:H95)-SUM($F$88:H88))/SUM(H58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:I95)-SUM($F$88:I88))/SUM(I58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:J95)-SUM($F$88:J88))/SUM(J58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:K95)-SUM($F$88:K88))/SUM(K58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:L95)-SUM($F$88:L88))/SUM(L58)),0)","v":0},{"$f":"IFERROR(((SUM('Données réelles'!$E$32:$E$33)+SUM($F$95:M95)-SUM($F$88:M88))/SUM(M58)),0)","v":0}]
[null,null,"CAF/chiffre d'affaires",null,{"$f":"'Données réelles'!E113","v":0},{"$f":"IFERROR(SUM(F94:F94)/SUM(F57),0)","v":0},{"$f":"IFERROR(SUM(G94:G94)/SUM(G57),0)","v":0},0,0,0,0,0,0]