{"text_format":"3","workbook":"xlsx","n_sheets":17,"sheets":["Accueil","Cartouche d'identification","0-Présentation typeaction","1-Investissements","2-Frais généraux","3-Contributions en nature","4-Amortissement","5-Tx forf personnel+autoconst","6-Coût unitaire bananes","7-Coût unitaire cannes à sucre","Liste des MP","Syn DP Bénéficiaire","Demande Avance","Avance_Instructeur"," DÉPENSES-Syn DP Instruct","RESSOURCES-Syn DP Instruc","Tableau de bord-Instructeur"],"not_rendered":{"images":1,"defined_names":870},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":34,"n_cols":29,"rows_kept":34,"merged":[[6,21,6,22],[7,0,7,23],[8,0,8,23],[9,0,9,23],[11,0,11,23],[13,5,13,16],[15,5,15,6],[15,7,15,16],[16,5,16,6],[16,7,16,16],[17,5,17,6],[17,7,17,16],[18,5,18,6],[18,7,18,16],[19,5,19,6],[19,7,19,16],[20,5,20,6],[20,7,20,16],[21,5,21,6],[21,7,21,16],[23,1,23,22],[25,1,25,22],[26,1,26,22],[27,1,27,22],[28,1,28,22],[29,1,29,22],[30,1,30,22],[32,1,32,22],[33,1,33,22]]}
[]
[{"$nulls":28},"Pas de marché public"]
[{"$nulls":28},"Marché à procédure adaptée (MAPA)"]
[{"$nulls":28},"Marché innovant"]
[{"$nulls":28},"Marché à procédure formalisée"]
[]
[]
["STRATEGIE REGIONALE GUADELOUPE FEADER 2023-2027"]
["Mesure 73.01 : Investissements dans les entreprises agricoles (« on farm »)"]
["Annexe financière à la demande de paiement"]
[{"$nulls":9},"Version :",{"$f":"'Cartouche d''identification'!C4","v":"v2.3"}]
["Cette version de l'annexe financière est à utiliser pour toutes les demandes de paiement"]
[]
[{"$nulls":5},"Identification de l'objet de la demande de paiement. A renseigner par le porteur et corriger par l'instrcuteur si besoin"]
[]
[{"$nulls":5},"INTITULE DE L'OPERATION"]
[{"$nulls":5},"NUMERO DU DOSSIER EUROPAC"]
[{"$nulls":5},"NOM DU DEMANDEUR OU DE LA STRUCTURE PORTEUSE"]
[{"$nulls":5},"NATURE DE LA DEMANDE DE PAIEMENT",null,"CHOISIR LA NATURE DE LA DEMANDE DE PAIEMENT"]
[{"$nulls":5},"NUMERO DE LA DEMANDE DE PAIEMENT"]
[{"$nulls":5},"DATE DU DEPOT DE LA DEMANDE DE PAIEMENT SUR EUROPAC"]
[{"$nulls":5},"PERIODE DE REALISATION COUVERTE PAR LA DEMANDE DE PAIEMENT"]
[]
[null,"Les onglets de la présente feuille de calcul Excel constituent une part intégrante de la demande de paiement. Ils doivent être complétés avec l'ensemble des dépenses pour lesquelles un remboursement est demandé à la présente demande de paiement. "]
[]
[null,"Consignes d'utilisation"]
[null,"De façon générale:\n- Il est conseillé de compléter les onglets de celui le plus à gauche \"Accueil\" vers l'onglet le plus à droite \"Syn dep bénéficiaire\" (l'onglet \"Syn dep instructeur\" étant réservé à l'administration) ;\n- Il faut impérativement compléter toutes les cases non-verrouillées (cases blanches) pour permettre l'instruction du dossier.\n- Si la nature de la demande est une avance, veuillez remplir uniquement l'onglet \"Demande Avance\"."]
[null,"Accueil\nSaisir les informations nécessaires à l'identification de l'objet de la demande de paiement (ci-dessus)."]
[null,"Dépenses réalisées présentées - onglets 1 à 7 :\nCes onglets sont à compléter uniquement si vous êtes concernés par le poste de dépense en question.\nPour chaque poste de dépense (onglets 1 à 7), se positionner sur l'onglet correspondant et renseigner une ligne complète par dépense dans le tableau :\n- chaque ligne correspond à une dépense, aucune ne pouvant être regroupée. \n- les cases blanches sont à saisir et les informations nécessaires doivent y être portées (par exemple, pour un montant financier renseigner au maximum 2 décimales) ;\n- les cases bleu clair ne sont pas à saisir et sont calculées à partir des informations saisies. \n- Sur chaque onglet, une ligne grisée vous servira d'exemple. Elle est pré-renseignée afin de vous guider dans la saisie des lignes de dépenses.\n"]
[null,"Synthèse des dépenses du bénéficiaire - onglet \"Syn DP bénéficiaire\"\nUne fois toutes les dépenses présentées, se rendre dans l'onglet de synthèse.\nl'onglet est en partie complété automatiquement à partir des informations saisies dans les autres onglets (une fois les types d'action renseignés) :\n- vérifier les montants groupés par poste de dépense et par type d'action ;\n- renseigner les financements connus conformément à l'annexe financière à la convention attributive de l'aide signée par le porteur de projet et la Région ;\n- enregistrer le présent document, puis le verser dans EUROPAC à destination du service instructeur. "]
[null,"Synthèse des dépenses instruites - onglets \"Syn DP instructeur\"\nCes onglets sont entièrement réservé à l'administration."]
[]
[null,"Rappels généraux et points de vigilance"]
[null,". Pour chaque dépense, les justificatifs appropriés seront à joindre au dossier de demande de paiement sur le système d'information EUROPAC. En cas d'absence des justificatifs, le service instructeur écartera les montants des dépenses concernées.\n. Lorsque la dépense présentée fait l'objet d'un marché public avec règlement de consultation et cahier des charges et dans le cas où les pièces liées aux marchés publics n'ont pas été transmises à la demande d'aide, ces dernières doivent être transmises à la demande de paiement. \n. Lorsqu'une dépense présentée est supérieure à celle conventionnée, le bénéficiaire doit apporter une explication supplémentaire permettant de justifier de l'augmentation du prix. Le service instructeur considérera l'effectivité des arguments avancés et plafonnera, le cas échéant, la dépense au montant conventionné. "]

{"sheet":"Cartouche d'identification","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"hidden":true}
[]
[{"$nulls":4},"Nom","Date de la modification","Version","Validé par","Commentaires"]
[null,"Nom du fichier","Annexe_financière_DP_73.01",null,"Marvin ELISE","2017-03-15","v0",null,"Initialisation du fichier"]
[null,"Version","v2.3",null,"EY","2026-04-01","v0.1",null,"Modification, adaptation au programme 2023/2027"]
[null,"Date de création","2017-03-15",null,"Sylvie DEJEAN","2026-05-12","v0.2",null,"Correction(calcul des dépenses et des montants à verser)"]
[null,"Propriétaire","Chef(fe) du service appui au programme",null,"Ludovic TARET","2026-05-21","v0.3",null,"Correction(onglets poste de dépense) + Commentaire Instructeur"]
[null,"Responsable","Chargé(e) des systèmes d'informations Europe",null,"Sylvie DEJEAN","2026-05-26","v0.4",null,"Correction(calcul des dépenses et des montants à verser)"]
[null,"Auteur","Marvin ELISE",null,"Ludovic TARET","2026-06-03","v0.5"]
[null,"Emplacement du fichier modèle","https://laguadeloupe.sharepoint.com/:f:/r/sites/PARTAGEINTERFONDS-PartagedocumentaireFEADER/Shared%20Documents/FEADER%2023-27/DSGC/Documents%20types/FP%2015%20-%20DP/Feuilles%20de%20calcul%20DP?csf=1&web=1&e=GXMADQ",null,"Sylvie DEJEAN","2026-06-16","v0.6",null,"Correction des erreurs identifié par la région"]
[{"$nulls":4},"Ludovic TARET","2026-06-19","v0.7",null,"Correction des calculs de coût des plantations canne et banane + ajout de colonne (n°pacage,n°siret,tonnage,nombre de plants)"]
[{"$nulls":4},"Sylvie DEJEAN","2026-07-02","v0.8",null,"Correction de l'onglet Depense Instructeur et du tableau de bord Instructeur"]
[{"$nulls":4},"Ludovic TARET","2026-07-17","v1","Marion BECMONT","Mise en production"]
[{"$nulls":4},"Ludovic TARET","2026-07-18","v2","Marion BECMONT","Après validation de l'ASP"]
[{"$nulls":4},"Ludovic TARET","2026-07-21","v2.1",null,"Ajout du tableau total à payer pour cette DP dans tableau de bord"]
[{"$nulls":4},"Ludovic TARET","2026-07-24","v2.2",null,"retour ASP modif tableau de bord en S16 et T16"]
[{"$nulls":4},"Ludovic TARET","2026-08-11","v2.3",null,"Prise en compte du cas de MOP"]

{"sheet":"0-Présentation typeaction","index":2,"n_rows":104,"n_cols":11,"rows_kept":104,"hidden":true,"merged":[[1,1,1,3],[3,0,11,0],[12,0,15,0],[16,0,103,0]]}
[]
[null,"Présentation des types d'actions et des postes de dépenses pour le dispositif 73.01"]
[null,"Type d'action","Onglet (Poste de dépense)","Modalités de prise en compte",{"$nulls":3},"Référentiel des listes déroulantes pour les types d'action (onglets 1 à 7 + synthèses)",null,null,"Référentiel des listes déroulantes pour les postes de dépense"]
["Postes de dépenses et types d'actions pour le dispositif 73.01","Modernisation des installations et mécanisation : équipement, de modernisation, et de sécurisation des exploitations et des groupements agricoles guadeloupéens\n(Modernisation installations / mécanisation)",null,{"$f":"IF(OR(C4=\"1-Investissements\",C4=\"2-Frais généraux\",C4=\"3-Contributions en nature\",C4=\"4-Amortissement\"),\"Au réel\",IF(OR(C4=\"5-Tx forf personnel+autoconst\",C4=\"6-Coût unitaire bananes\",C4=\"7-Coût unitaire cannes à sucre\"),\"OCS\",\"\"))","v":""},{"$nulls":3},"Modernisation installations / mécanisation",null,null,"1-Investissements"]
[null,"Construction et aménagement des bâtiments\n(Construction / aménagement bâtiments)",null,"",{"$nulls":3},"Construction / aménagement bâtiments",null,null,"2-Frais généraux"]
[null,"Plantations pérennes",null,"",{"$nulls":3},"Plantations pérennes",null,null,"3-Contributions en nature"]
[null,"Irrigation (investissements de production à la parcelle, type pilotage, goutte à goutte, aspersion ; retenues individuelles, forages, pompes, réseaux de transport et \ndistribution)",null,"",{"$nulls":3},"Irrigation",null,null,"4-Amortissement"]
[null,"Performance énergétique",null,"",{"$nulls":3},"Performance énergétique",null,null,"5-Tx forf personnel+autoconst"]
[null,"Transformation et commercialisation de la production agricole de l'exploitation agricole\n(Transformation / Commercialisation)",null,"",{"$nulls":3},"Transformation / Commercialisation",null,null,"6-Coût unitaire bananes"]
[null,"Amélioration foncière",null,"",{"$nulls":3},"Amélioration foncière",null,null,"7-Coût unitaire cannes à sucre"]
[null,"Diversification des activités de l’exploitation tels que l'agritourisme, l'accueil à la ferme (gîtes)\n(Diversification des activités - gîtes ruraux)",null,"",{"$nulls":3},"Diversification des activités - gîtes ruraux"]
[null,"Diversification des activités de l’exploitation tels que l'agritourisme, l'accueil à la ferme (hors gîtes)\n(Diversification des activités - hors gîtes ruraux)",null,"",{"$nulls":3},"Diversification des activités - hors gîtes ruraux"]
["Exemple","Construction / aménagement bâtiments","1-Investissements","Au réel"]
[null,"Construction / aménagement bâtiments","2-Frais généraux","Au réel"]
[null,"Plantations pérennes","6-Coût unitaire bananes","OCS"]
[null,"Plantations pérennes","7-Coût unitaire cannes à sucre","OCS"]
["Saisir vos choix dans les cases blanches à l'aide des menus déroulants.\n\nPour chaque type d'action sélectionné en colonne B, indiquer en colonne C les postes de dépenses présentés.\n\nLa colonne D se complète automatiquement en fonction du poste de dépense sélectionné en colonne C par rapport aux modalités de prise en compte possibles.",null,null,""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},{"$f":"IF(OR(C68=\"1-Investissements\",C68=\"2-Frais généraux\",C68=\"3-Contributions en nature\",C68=\"4-Amortissement\"),\"Au réel\",IF(OR(C68=\"5-Tx forf personnel+autoconst\",C68=\"6-Coût unitaire bananes\",C68=\"7-Coût unitaire cannes à sucre\"),\"OCS\",\"\"))","v":""}]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]
[{"$nulls":3},""]

{"sheet":"1-Investissements","index":3,"n_rows":109,"n_cols":42,"rows_kept":109,"merged":[[1,2,1,6],[2,2,2,6],[4,0,4,17],[5,1,5,4],[5,5,5,11],[5,12,5,14],[5,15,5,16],[5,18,5,21],[5,23,5,30],[5,31,5,32],[5,33,5,34],[5,35,5,37],[5,38,5,41],[6,0,7,0]]}
[]
[null,null,"Investissements matériels et immatériels"]
[null,null,"À compter du 1er janvier 2024, les seuils de procédure formalisée sont les suivants :\n• 143 000 € HT pour les marchés de fournitures et de services des autorités publiques centrales ;\n• 221 000 € HT pour les marchés de fournitures et de services des autres pouvoirs adjudicateurs et pour les marchés publics de fournitures des autorités publiques centrales opérant dans le domaine de la défense ;\n• 443 000 € HT pour les marchés de fournitures et de services des entités adjudicatrices et pour les marchés de fournitures et de services passés dans le domaine de la défense ou de la sécurité ;\n• 5 382 000 € HT à 5 538 000 € HT pour les marchés de travaux et pour les contrats de concessions."]
[]
["Partie à remplir par le bénéficiaire - Instruction des dépenses d'investissements matériels et immatériels conventionnées",{"$nulls":17},"Partie réservée à l'administration - Instruction des dépenses d'investissements matériels et immatériels conventionnées"]
[null,"IDENTIFICATION DE LA DÉPENSE",{"$nulls":3},"FACTURES ou PIECES EQUIVALENTES",{"$nulls":6},"MONTANT DEMANDÉS",null,null,"RÉFÉRENCES DU PAIEMENT",null,"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",{"$nulls":3},"CONVENTION","FACTURES ET PIECES EQUIVALENTES",{"$nulls":7},"PAIEMENT",null,"SUIVI DES DEMANDES DE PAIEMENT",null,"CONTRÔLE DES MONTANTS",null,null,"CONCLUSION"]
["Numéro de la dépense","Description de la dépense","S'agit-il d'un achat de terrain hors terrain à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier?","Taux d'affectation à l'opération","Type d'action concerné","Référence de la facture ou pièce équivalente - HORS MARCHÉS PUBLICS","Présence d'un marché public","Seuil du marché public","Référence des pièces de marché public, LE CAS ÉCHÉANT","Emetteur","% de récupération de la TVA ","Date de réalisation physique de l'opération","Montant HT demandé","Montant TVA demandé","Montant TTC demandé","Référence du justificatif du paiement","Date de paiement ","Commentaires","Description de la dépense","S'agit-il d'un achat de terrain hors terrain à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier?","Taux d'affectation à l'opération","Type d'action concerné","La dépense est-elle conventionnée ?","La facture ou la pièce équivalente - HORS MARCHÉ PUBLIC  - est-elle conforme ? ","% de récupération de la TVA (si récupérée)","Présence d'un marché public","Seuil du marché public","Montant du marché public","En cas de marché public, %  des irrégularités identifiées si présentes","Emetteur","La date de réalisation est-elle conforme avec la convention ? ","Le justificatif de paiment est-il conforme ?","La date de paiement est-elle conforme ?","Montant conventionné","Montant des dépenses retenues cumulées au titre des précédentes DP","Montant HT demandé","Montant TVA demandé","Montant TTC demandé","Montant éligible ","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[null,"Type de dépense (acquisition de matériel, location, acquisition de brevets, logiciels…)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(choisir \"Oui\" s'il s'agit d'un achat de terrain hors terrain à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ;\nchoisir \"Non\" s'il ne s'agit pas d'un achat de terrain ou s'il s'agit d'un achat de terrain à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou d'un terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier)\nLe plafond de l'achat de terrain ne s'applique que pour la somme des lignes pour lesquelles la réponse est \"Oui\".\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(Si la dépense est affectée partiellement à l'opération, préciser le taux de proratisation retenu ex: 50%). \nSi la dépense est intégralement liée à l'opération, préciser 100%) \n\nAttention : la dépense présentée doit êtreconforme à la convention ou au dernier avenant à la convention","Nom du type d'action à sélectionner dans le menu déroulant, en cohérence avec les éléments saisis dans l'onglet 0.\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(information présente sur le justificatif joint)","(absence ou type de marché public à sélectionner dans le menu déroulant)\nSi oui, renseigner l'onglet \"Liste MP\"","Pour les marchés publics de travaux ou de fournitures et de services, la valeur est-elle supérieure aux seuils rappelés en encart ci-dessus ?","(information présente sur le justificatif joint)\n\nConformément à l'onglet \"Liste MP","(nom de l'entreprise, de la structure émettrice de la facture ou de tout autre  justificatif de la dépense retenu)","Si vous ne récupérez pas la TVA, indiquez 0% \n\nSi vous récupérez partiellement la TVA, indiquez le % idoine\n\nSi vous récupérez totalement la TVA, indiquez 100%","Cette date diffère de la date d'acquittement. Il s'agit de la date à laquelle l'équipement/la prestation/le livrable a effectivement été obtenu.","(montant hors taxes de la facture, en euros)","Rentrer le montant de TVA éligible (celle qui n'est pas récupérée) NB : Attention à bien prendre en compte manuellement le taux de récupération de la TVA ","(saisie automatique)","(Nom du document justificatif joint)","  = date d'acquittement (attention, la date du paiement doit être antérieure à la date de fin de la période d'éligibilité des dépenses covnentionnée)","(le cas échéant, pour préciser un point saillant au Service Instructeur)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Saisir OUI ou NON\nVérifier la conformité de la dépense présentée vis-à-vis de la convention ou du dernier avenant à la convention - au regard des critères suivants \n\n- Nom de la dépense\n- Description de la dépense\n- Type d'action rattaché \n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.\nNB2 : Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0.","Saisir OUI ou NON","(report automatique de la demande. Corriger les informations des cellules selon la pièce justificative fournie)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)\nSi oui, contrôler l'onglet \"Liste MP\"","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(A rentrer par l'instructeur)","Sur la base du contrôle de régularité de la commande publique effectué par l'équipe spécialisée.\nConformément à l'onglet \"Liste MP","Report automatique à corriger le cas échéant ","La réalisation de la dépense a eu lieu durnat la période de réalisation conventionnée ? ","Saisir OUI ou NON","Date de paiement incluse dans la période conventionnée d'éligibilité des dépenses ?","Indiquer le montant présent sur la convention","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","(report automatique de la demande. Corriger les informations le cas échéant)","(report automatique de la demande. Corriger les informations le cas échéant)","Calcul automatique","Calcul automatique\nImportant : en cas de dépassement de la différence entre le  montant conventionné et les montants des DP précédentes, la justification ou non d'un tel dépassement est laissé à la libre appréciation du service instructeur. Si celle-ci est jugée valable, le service peut supprimer la formule et saisir manuellement le montant estimé éligible. ","Calcul automatique","Calcul automatique\n\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée lors de la phase d'instruction.\nEx: identification d'une sanction…)"]
["Exemple","Chaînage carré","Non",{"v":1,"d":"100%"},"Construction / aménagement bâtiments","TEST2024","Pas de marché public","Non concerné","NA","Fer Plus",{"v":0,"d":"0%"},null,{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(AND(M9=\"\", N9=\"\"), \"\",(M9+N9)*D9)","v":{"v":3900,"d":"3,900.00 €"}},"Nom_du_document","2024-12-10","NA","Chaînage carré","Non",{"v":1,"d":"100%"},{"$f":"IF(E9=\"\",\"\",E9)","v":"Construction / aménagement bâtiments"},"Oui","Oui",{"v":0,"d":"0%"},"Pas de marché public",{"$f":"IF(H9=0,\"\",H9)","v":"Non concerné"},{"v":10,"d":"10.00 €"},{"v":0,"d":"0.00%"},"xxx","Oui","Oui","Oui",{"v":3900,"d":"3,900.00 €"},null,{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"},{"v":3900,"d":"3,900.00 €"},{"$f":"IF(B9=\"\",\"\",IF(OR(W9=\"Non\",X9=\"Non\",AE9=\"Non\",AF9=\"Non\",AG9=\"Non\"), 0, IF(AL9<=AH9-AI9, AL9-AC9*AB9,AH9-AI9)))","v":{"v":3900,"d":"3,900.00 €"}},{"v":0,"d":"0.00 €"}]
[1,{"$nulls":13},{"$f":"IF(AND(M10=\"\", N10=\"\"), \"\",(M10+N10)*D10)","v":""},{"$nulls":3},{"$f":"IF(B10=\"\",\"\",B10)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},{"$f":"IF(D10=\"\",\"\",D10)","v":""},"",null,null,{"$f":"IF(K10=\"\",\"\",K10)","v":""},{"$f":"IF(G10=0,\"\",G10)","v":""},"",null,null,{"$f":"IF(J10=\"\",\"\",J10)","v":""},{"$nulls":5},{"$f":"IF(M10=\"\",\"\",M10)","v":""},"",{"$f":"IF(AND(AJ10=\"\", AK10=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ10,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK10,CHAR(160),\"\"))),0))*U10)","v":""},{"$f":"IF(B10=\"\",\"\",IF(OR(W10=\"Non\",X10=\"Non\",AE10=\"Non\",AF10=\"Non\",AG10=\"Non\"), 0, IF(AL10<=AH10-AI10, AL10-AC10*AB10,AH10-AI10)))","v":""},{"$f":"IF(OR(O10=\"\",AM10=\"\"),\"\",O10-AM10)","v":""},{"$f":"IF(AND(AI10=\"\",AM10=\"\"),\"\",AM10+AI10)","v":""}]
[2,{"$nulls":13},{"$f":"IF(AND(M11=\"\", N11=\"\"), \"\",(M11+N11)*D11)","v":""},{"$nulls":3},{"$f":"IF(B11=\"\",\"\",B11)","v":""},{"$f":"IF(C11=\"\",\"\",C11)","v":""},{"$f":"IF(D11=\"\",\"\",D11)","v":""},"",null,null,"",{"$f":"IF(G11=0,\"\",G11)","v":""},{"$f":"IF(H11=0,\"\",H11)","v":""},null,null,{"$f":"IF(J11=\"\",\"\",J11)","v":""},{"$nulls":5},{"$f":"IF(M11=\"\",\"\",M11)","v":""},"",{"$f":"IF(AND(AJ11=\"\", AK11=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ11,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK11,CHAR(160),\"\"))),0))*U11)","v":""},{"$f":"IF(B11=\"\",\"\",IF(OR(W11=\"Non\",X11=\"Non\",AE11=\"Non\",AF11=\"Non\",AG11=\"Non\"), 0, IF(AL11<=AH11-AI11, AL11-AC11*AB11,AH11-AI11)))","v":""},{"$f":"IF(OR(O11=\"\",AM11=\"\"),\"\",O11-AM11)","v":""},{"$f":"IF(AND(AI11=\"\",AM11=\"\"),\"\",AM11+AI11)","v":""}]
[3,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[4,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[5,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[6,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","",{"$f":"IF(AND(AJ15=\"\", AK15=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ15,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK15,CHAR(160),\"\"))),0))*U15)","v":""},{"$f":"IF(B15=\"\",\"\",IF(OR(W15=\"Non\",X15=\"Non\",AE15=\"Non\",AF15=\"Non\",AG15=\"Non\"), 0, IF(AL15<=AH15-AI15, AL15-AC15*AB15,AH15-AI15)))","v":""},{"$f":"IF(OR(O15=\"\",AM15=\"\"),\"\",O15-AM15)","v":""},""]
[7,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":6},"","","","",""]
[8,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(M17=\"\",\"\",M17)","v":""},"","","","",""]
[9,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[10,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[11,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[12,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[13,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[14,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[15,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[16,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[17,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[18,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[19,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[20,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[21,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[22,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[23,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[24,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[25,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[26,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[27,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[28,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[29,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[30,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[31,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"",{"$f":"IF(G40=0,\"\",G40)","v":""},{"$f":"IF(H40=0,\"\",H40)","v":""},null,null,"",{"$nulls":5},"","","","","",""]
[32,{"$nulls":13},"",{"$nulls":3},{"$f":"IF(B41=\"\",\"\",B41)","v":""},{"$f":"IF(C41=\"\",\"\",C41)","v":""},{"$f":"IF(D41=\"\",\"\",D41)","v":""},"",null,null,"","","",null,null,{"$f":"IF(J41=\"\",\"\",J41)","v":""},{"$nulls":5},"","",{"$f":"IF(AND(AJ41=\"\", AK41=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ41,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK41,CHAR(160),\"\"))),0))*U41)","v":""},"","",{"$f":"IF(AND(AI41=\"\",AM41=\"\"),\"\",AM41+AI41)","v":""}]
[33,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[34,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[35,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[36,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[37,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","",{"$f":"IF(OR(O46=\"\",AM46=\"\"),\"\",O46-AM46)","v":""},""]
[38,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[39,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[40,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(M49=\"\",\"\",M49)","v":""},"","","","",""]
[41,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[42,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[43,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[44,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[45,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[46,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[47,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[48,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[49,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[50,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[51,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[52,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[53,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[54,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[55,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[56,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[57,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[58,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[59,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[60,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[61,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[62,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[63,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"",{"$f":"IF(G72=0,\"\",G72)","v":""},{"$f":"IF(H72=0,\"\",H72)","v":""},null,null,"",{"$nulls":5},"","","","","",""]
[64,{"$nulls":13},"",{"$nulls":3},{"$f":"IF(B73=\"\",\"\",B73)","v":""},{"$f":"IF(C73=\"\",\"\",C73)","v":""},{"$f":"IF(D73=\"\",\"\",D73)","v":""},"",null,null,"","","",null,null,{"$f":"IF(J73=\"\",\"\",J73)","v":""},{"$nulls":5},"","",{"$f":"IF(AND(AJ73=\"\", AK73=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ73,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK73,CHAR(160),\"\"))),0))*U73)","v":""},"","",{"$f":"IF(AND(AI73=\"\",AM73=\"\"),\"\",AM73+AI73)","v":""}]
[65,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,{"$f":"IF(K74=\"\",\"\",K74)","v":""},"","",null,null,"",{"$nulls":5},"","","","","",""]
[66,{"$nulls":13},{"$f":"IF(AND(M75=\"\", N75=\"\"), \"\",(M75+N75)*D75)","v":""},{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","",{"$f":"IF(B75=\"\",\"\",IF(OR(W75=\"Non\",X75=\"Non\",AE75=\"Non\",AF75=\"Non\",AG75=\"Non\"), 0, IF(AL75<=AH75-AI75, AL75-AC75*AB75,AH75-AI75)))","v":""},"",""]
[67,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[68,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[69,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","",{"$f":"IF(OR(O78=\"\",AM78=\"\"),\"\",O78-AM78)","v":""},""]
[70,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[71,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[72,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(M81=\"\",\"\",M81)","v":""},"","","","",""]
[73,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[74,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[75,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[76,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[77,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[78,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[79,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[80,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[81,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[82,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[83,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[84,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[85,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[86,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[87,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[88,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[89,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[90,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[91,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[92,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[93,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[94,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[95,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[96,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","",{"$f":"IF(AND(AJ105=\"\", AK105=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AJ105,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AK105,CHAR(160),\"\"))),0))*U105)","v":""},"","",""]
[97,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[98,{"$nulls":13},"",{"$nulls":3},"","","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[99,{"$nulls":13},"",{"$nulls":3},"","","",{"$f":"IF(E108=\"\",\"\",E108)","v":""},null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[100,{"$nulls":9},"Total",null,{"$f":"SUM(M10:M108)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N10:N108)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(O10:O108)","v":{"v":0,"d":"0.00 €"}},{"$nulls":18},"Total",{"$f":"SUM(AI10:AI108)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]

{"sheet":"2-Frais généraux","index":4,"n_rows":105,"n_cols":40,"rows_kept":105,"merged":[[0,0,0,16],[0,17,0,39],[1,1,1,3],[1,4,1,10],[1,11,1,13],[1,14,1,15],[1,17,1,19],[1,21,1,28],[1,29,1,30],[1,31,1,32],[1,33,1,35],[1,36,1,39],[2,0,3,0]]}
["Partie à remplir par le bénéficiaire - Présentation des dépenses de frais généraux conventionnés\nLa dépense de diagnostic énergie-gaz à effet de serre de l’exploitation ou de l'entreprise est plafonnée à 1 500 € HT\nLes frais généraux ne sont pas mobilisables pour le type d'action \"Plantations pérennes\" pour la banane et la canne à sucre : ne mobiliser que les OCS de type coûts unitaires correspondants en onglets 6 et 7",{"$nulls":16},"Partie réservée à l'administration - Instruction des frais généraux conventionnés (selon les modalités définies dans la notice)\nLa dépense de diagnostic énergie-gaz à effet de serre de l’exploitation ou de l'entreprise est plafonnée à 1 500 € HT\nLes frais généraux ne sont pas mobilisables pour le type d'action \"\"Plantations pérennes\"\" pour la banane et la canne à sucre : ne mobiliser que les OCS de type coûts unitaires correspondants en onglets 6 et 7\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t"]
[null,"IDENTIFICATION DE LA DÉPENSE",null,null,"FACTURES ou PIECES EQUIVALENTES",{"$nulls":6},"MONTANT DEMANDÉS",null,null,"RÉFÉRENCES DU PAIEMENT",null,"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",null,null,"CONVENTION","FACTURES ET PIECES EQUIVALENTES",{"$nulls":7},"PAIEMENT",null,"SUIVI DES DEMANDES DE PAIEMENT",null,"CONTRÔLE DES MONTANTS",null,null,"CONCLUSION"]
["Numéro de la dépense","Description de la dépense","Taux d'affectation à l'opération","Type d'action concerné","Référence de la facture ou pièce équivalente - HORS MARCHÉS PUBLICS","Présence d'un marché public","Seuil du marché public","Référence des pièces de marché public, LE CAS ÉCHÉANT","Emetteur","% de récupération de la TVA ","Date de réalisation physique de l'opération","Montant HT demandé","Montant TVA demandé","Montant TTC demandé","Référence du justificatif du paiement","Date de paiement ","Commentaires","Description de la dépense","Taux d'affectation à l'opération","Type d'action concerné","La dépense est-elle conventionnée ","La facture ou la pièce équivalente - HORS MARCHÉ PUBLIC  - est-elle conforme ? ","% de récupération de la TVA (si avéré)","Présence d'un marché public","Seuil du marché public","Montant du marché public","En cas de marché public, %  des irrégularités identifiées si présentes","Emetteur","La date de réalisation est-elle conforme avec la convention ? ","Le justificatif de paiment est-il conforme ?","La date de paiement est-elle conforme ?","Montant conventionné","Montant des dépenses retenues cumulées au titre des précédentes DP","Montant HT demandé","Montant TVA demandé","Montant TTC demandé","Montant éligible ","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[null,"Type de dépense (études préalabes à la réalisation d'un investissement matériel, diagnostics, assistance à maitrise d'ouvrage, honoraires de consultants…)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(Si la dépense est affectée partiellement à l'opération, préciser le taux de proratisation retenu ex: 50%). \nSi la dépense est intégralement liée à l'opération, préciser 100%) \nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(nom du type d'action à sélectionner dans le menu déroulant, en cohérence avec les éléments saisis dans l'onglet 0)\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(information présente sur le justificatif joint)","(absence ou type de marché public à sélectionner dans le menu déroulant)\nSi oui, renseigner l'onglet \"Liste MP\"","Pour les marchés publics de travaux ou de fournitures et de services, la valeur est-elle supérieure aux seuils rappelés en encart ci-dessus ?","(information présente sur le justificatif joint)\n\nConformément à l'onglet \"Liste MP","(nom de l'entreprise, de la structure émettrice de la facture ou de tout autre  justificatif de la dépense retenu)","Si vous ne récupérez pas la TVA, indiquez 0% \n\nSi vous récupérez partiellement la TVA, indiquez le % idoine\n\nSi vous récupérez totalement la TVA, indiquez 100%","Cette date diffère de la date d'acquittement. Il s'agit de la date à laquelle l'équipement/la prestation/le livrable a effectivement été obtenu.","(montant hors taxes de la facture, en euros)","Rentrer le montant de TVA éligible (celle qui n'est pas récupérée) NB : Attention à bien prendre en compte manuellement le taux de récupération de la TVA ","(saisie automatique)","(Nom du document justificatif joint)","  = date d'acquittement (attention, la date du paiement doit être antérieure à la date de fin de la période d'éligibilité des dépenses covnentionnée)","(le cas échéant, pour préciser un point saillant au Service Instructeur)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Saisir OUI ou NON\nVérifier la conformité de la dépense présentée vis-à-vis de la convention ou du dernier avenant à la convention - au regard des critères suivants \n\n- Nom de la dépense\n- Description de la dépense\n- Type d'action rattaché \n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.\nNB2 : Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0.","Saisir OUI ou NON","(report automatique de la demande. Corriger les informations des cellules selon la pièce justificative fournie)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)\nSi oui, contrôler l'onglet \"Liste MP\"","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(A rentrer par l'instructeur)","Sur la base du contrôle de régularité de la commande publique effectué par l'équipe spécialisée.\nConformément à l'onglet \"Liste MP","Report automatique à corriger le cas échéant ","La réalisation de la dépense a eu lieu durnat la période de réalisation conventionnée ? ","Saisir OUI ou NON","Date de paiement incluse dans la période conventionnée d'éligibilité des dépenses ?","Indiquer le montant présent sur la convention","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","(report automatique de la demande. Corriger les informations le cas échéant)","(report automatique de la demande. Corriger les informations le cas échéant)","Calcul automatique","Calcul automatique\nImportant : en cas de dépassement de la différence entre le  montant conventionné et les montants des DP précédentes, la justification ou non d'un tel dépassement est laissé à la libre appréciation du service instructeur. Si celle-ci est jugée valable, le service peut supprimer la formule et saisir manuellement le montant estimé éligible. ","Calcul automatique","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée lors de la phase d'instruction.\nEx: identification d'une sanction…)"]
["Exemple","Etude de faisabilité",{"v":1,"d":"100%"},"Modernisation installations / mécanisation","F558115102","Pas de marché public","Non concerné","Non concerné","EkoXpertise",{"v":0,"d":"0%"},"2025-02-05",{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(AND(L5=\"\", M5=\"\"), \"\",(L5+M5)*C5)","v":{"v":3900,"d":"3,900.00 €"}},45238,"2024-12-10",null,{"$f":"IF(B5=\"\",\"\",B5)","v":"Etude de faisabilité"},{"v":1,"d":"100%"},"Modernisation installations / mécanisation","Oui","Oui",{"v":0,"d":"0%"},{"$f":"IF(F5=0,\"\",F5)","v":"Pas de marché public"},{"$f":"IF(G5=0,\"\",G5)","v":"Non concerné"},{"v":10,"d":"10.00 €"},{"v":0,"d":"0.00%"},"xx","Oui","Oui","Oui",{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"},{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"},{"v":3900,"d":"3,900.00 €"},{"$f":"IF(B5=\"\",\"\",IF(OR(U5=\"Non\",V5=\"Non\",AC5=\"Non\",AD5=\"Non\",AE5=\"Non\"),0,IF(AJ5<=(AF5-AG5),AJ5-AA5,AF5-AG5)))","v":{"v":3900,"d":"3,900.00 €"}},{"v":0,"d":"0.00 €"}]
[1,{"$nulls":12},{"$f":"IF(AND(L6=\"\", M6=\"\"), \"\",(L6+M6)*C6)","v":""},{"$nulls":3},"",{"$f":"IF(C6=\"\",\"\",C6)","v":""},{"$f":"IF(D6=\"\",\"\",D6)","v":""},null,null,{"$f":"IF(J6=\"\",\"\",J6)","v":""},"","",null,null,{"$f":"IF(I6=\"\",\"\",I6)","v":""},{"$nulls":5},{"$f":"IF(L6=\"\",\"\",L6)","v":""},{"$f":"IF(M6=\"\",\"\",M6)","v":""},{"$f":"IF(AND(AH6=\"\", AI6=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH6,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI6,CHAR(160),\"\"))),0))*S6)","v":""},{"$f":"IF(B6=\"\",\"\",IF(OR(U6=\"Non\",V6=\"Non\",AC6=\"Non\",AD6=\"Non\",AE6=\"Non\"),0,IF(AJ6<=(AF6-AG6),AJ6-AA6*Z6,AF6-AG6)))","v":""},{"$f":"IF(OR(N6=\"\",AK6=\"\"),\"\",N6-AK6)","v":""},{"$f":"IF(AND(AG6=\"\",AK6=\"\"),\"\",AK6+AG6)","v":""}]
[2,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,{"$f":"IF(I7=\"\",\"\",I7)","v":""},{"$nulls":5},{"$f":"IF(L7=\"\",\"\",L7)","v":""},{"$f":"IF(M7=\"\",\"\",M7)","v":""},{"$f":"IF(AND(AH7=\"\", AI7=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH7,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI7,CHAR(160),\"\"))),0))*S7)","v":""},{"$f":"IF(B7=\"\",\"\",IF(OR(U7=\"Non\",V7=\"Non\",AC7=\"Non\",AD7=\"Non\",AE7=\"Non\"),0,IF(AJ7<=(AF7-AG7),AJ7-AA7,AF7-AG7)))","v":""},{"$f":"IF(OR(N7=\"\",AK7=\"\"),\"\",N7-AK7)","v":""},""]
[3,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,{"$f":"IF(I8=\"\",\"\",I8)","v":""},{"$nulls":5},{"$f":"IF(L8=\"\",\"\",L8)","v":""},"",{"$f":"IF(AND(AH8=\"\", AI8=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH8,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI8,CHAR(160),\"\"))),0))*S8)","v":""},{"$f":"IF(B8=\"\",\"\",IF(OR(U8=\"Non\",V8=\"Non\",AC8=\"Non\",AD8=\"Non\",AE8=\"Non\"),0,IF(AJ8<=(AF8-AG8),AJ8-AA8,AF8-AG8)))","v":""},{"$f":"IF(OR(N8=\"\",AK8=\"\"),\"\",N8-AK8)","v":""},""]
[4,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[5,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[6,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[7,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":6},"","","","",""]
[8,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(L13=\"\",\"\",L13)","v":""},"","","","",""]
[9,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[10,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[11,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[12,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[13,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[14,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[15,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[16,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[17,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[18,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[19,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[20,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[21,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[22,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[23,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[24,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[25,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[26,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[27,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[28,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[29,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[30,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[31,{"$nulls":12},"",{"$nulls":3},{"$f":"IF(B36=\"\",\"\",B36)","v":""},"",{"$f":"IF(D36=\"\",\"\",D36)","v":""},null,null,"",{"$f":"IF(F36=0,\"\",F36)","v":""},{"$f":"IF(G36=0,\"\",G36)","v":""},null,null,"",{"$nulls":5},"","","","","",""]
[32,{"$nulls":12},"",{"$nulls":3},"",{"$f":"IF(C37=\"\",\"\",C37)","v":""},"",null,null,{"$f":"IF(J37=\"\",\"\",J37)","v":""},"","",null,null,"",{"$nulls":5},"","",{"$f":"IF(AND(AH37=\"\", AI37=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH37,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI37,CHAR(160),\"\"))),0))*S37)","v":""},"",{"$f":"IF(OR(N37=\"\",AK37=\"\"),\"\",N37-AK37)","v":""},""]
[33,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[34,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[35,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[36,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[37,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[38,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[39,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[40,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(L45=\"\",\"\",L45)","v":""},"","","","",""]
[41,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[42,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[43,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[44,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[45,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[46,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[47,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[48,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[49,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[50,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[51,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[52,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[53,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[54,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[55,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[56,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[57,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[58,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[59,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[60,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[61,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[62,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[63,{"$nulls":12},"",{"$nulls":3},{"$f":"IF(B68=\"\",\"\",B68)","v":""},"",{"$f":"IF(D68=\"\",\"\",D68)","v":""},null,null,"",{"$f":"IF(F68=0,\"\",F68)","v":""},{"$f":"IF(G68=0,\"\",G68)","v":""},null,null,"",{"$nulls":5},"","","","","",""]
[64,{"$nulls":12},"",{"$nulls":3},"",{"$f":"IF(C69=\"\",\"\",C69)","v":""},"",null,null,{"$f":"IF(J69=\"\",\"\",J69)","v":""},"","",null,null,"",{"$nulls":5},"","",{"$f":"IF(AND(AH69=\"\", AI69=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH69,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI69,CHAR(160),\"\"))),0))*S69)","v":""},"",{"$f":"IF(OR(N69=\"\",AK69=\"\"),\"\",N69-AK69)","v":""},""]
[65,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,{"$f":"IF(I70=\"\",\"\",I70)","v":""},{"$nulls":5},"","","","","",{"$f":"IF(AND(AG70=\"\",AK70=\"\"),\"\",AK70+AG70)","v":""}]
[66,{"$nulls":12},{"$f":"IF(AND(L71=\"\", M71=\"\"), \"\",(L71+M71)*C71)","v":""},{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"",{"$f":"IF(M71=\"\",\"\",M71)","v":""},"",{"$f":"IF(B71=\"\",\"\",IF(OR(U71=\"Non\",V71=\"Non\",AC71=\"Non\",AD71=\"Non\",AE71=\"Non\"),0,IF(AJ71<=(AF71-AG71),AJ71-AA71,AF71-AG71)))","v":""},"",""]
[67,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[68,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[69,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[70,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[71,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[72,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},{"$f":"IF(L77=\"\",\"\",L77)","v":""},"","","","",""]
[73,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[74,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[75,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[76,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[77,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[78,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[79,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[80,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[81,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[82,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[83,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[84,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[85,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[86,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[87,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[88,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[89,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[90,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[91,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[92,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[93,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[94,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[95,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[96,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","",{"$f":"IF(AND(AH101=\"\", AI101=\"\"), \"\",(IFERROR(VALUE(TRIM(SUBSTITUTE(AH101,CHAR(160),\"\"))),0)+IFERROR(VALUE(TRIM(SUBSTITUTE(AI101,CHAR(160),\"\"))),0))*S101)","v":""},"",{"$f":"IF(OR(N101=\"\",AK101=\"\"),\"\",N101-AK101)","v":""},""]
[97,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[98,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[99,{"$nulls":12},"",{"$nulls":3},"","","",null,null,"","","",null,null,"",{"$nulls":5},"","","","","",""]
[100,{"$nulls":8},"Total",null,{"$f":"SUM(L6:L104)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(M6:M104)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(N6:N104)","v":{"v":0,"d":"0.00 €"}},{"$nulls":17},"Total",{"$f":"SUM(AG6:AG104)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]

{"sheet":"3-Contributions en nature","index":5,"n_rows":106,"n_cols":25,"rows_kept":106,"merged":[[0,0,0,9],[0,10,0,24],[1,1,1,5],[1,6,1,8],[1,10,1,14],[1,16,1,18],[1,19,1,20],[1,21,1,24],[2,0,3,0]]}
["Partie à remplir par le bénéficiaire - Présentation des dépenses de contributions en nature conventionnées\nAttention, les frais couverts par l'OCS 20% et les coûts unitaires pour la banane et la canne à sucre ne doivent pas être présentés dans cet onglet sous la forme de contributions en nature",{"$nulls":9},"Partie réservée à l'administration - Instruction des contributions en nature conventionnées\nAttention, les frais couverts par l'OCS 20% et les coûts unitaires pour la banane et la canne à sucre ne doivent pas être présentés dans cet onglet sous la forme de contributions en nature"]
[null,"IDENTIFICATION DE LA DÉPENSE",{"$nulls":4},"MONTANT DEMANDÉS et CONTRÔLES DES JUSTIFICATIFS",null,null,"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",{"$nulls":4},"CONVENTION","CONTRÔLE DES MONTANTS ET DES JUSTIFICATIFS",null,null,"SUIVI DES DEMANDES DE PAIEMENT",null,"CONCLUSION"]
["Numéro de la dépense","Description de la contribution en nature","Type d'action concerné","Taux d'affectation à l'opération\n(%)","Valeur de la contribution","Date de réalisation physique de l'opération","Justificatif d'affectation à l'opération","Justificatif de la valeur de la contribution","Montant demandé ","Commentaires","Description de la contribution en nature","Type d'action concerné","Taux d'affectation à l'opération\n(%)","Valeur de la contribution","La date de réalisation est-elle conforme avec la convention ? ","La contribution en nature est-elle conventionnée ?","Le justificatif d'affectation à l'opération est-il conforme ?","Justificatif de la valeur de la contribution est-il conforme ?","Montant demandé","Montant conventionné","Montant des dépenses retenues cumulées au titre des précédentes DP","Montant éligible ","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[null,"(nature de la contribution apportée à l'opération.\nEx: terrain, bien immeuble, équipement…)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(reprendre les types d'actions choisis tel que rempli dans l'onglet 0-Presentation poste-typeaction)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(si la dépense est affectée partiellement à l'opération, préciser le taux de proratisation retenu ex: 50% ; si la dépense est intégralement liée à l'opération préciser 100%)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(montant unitaire de la contribution en nature applicable en euro)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","Cette date diffère de la date d'acquittement. Il s'agit de la date à laquelle l'équipement/la prestation/le livrable a effectivement été obtenu.","(ex: attestation d’affectation du bien à l’opération…)","(Nécessaire si différent du justificatif présenté en demande d'aide : pour les terrains et biens immeubles, certificat d’un expert indépendant qualifié;\npour les services, biens d’équipement ou de matières premières: prix catalogue, devis, etc.)","taux d'affectation à l'opération x Valeur de la contribution","(le cas échéant, pour préciser un point saillant au Service Instructeur)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","La réalisation de la dépense a eu lieu durnat la période de réalisation conventionnée ? ","Saisir OUI ou NON\nVérifier la conformité de la dépense présentée vis-à-vis de la convention ou du dernier avenant à la convention - au regard des critères suivants \n\n- Nom de la dépense\n- Description de la dépense\n- Type d'action rattaché \n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.\nNB2 : Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0.","Saisir OUI ou NON","Saisir OUI ou NON","Calcul automatique","Indiquer le montant présent sur la convention","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","Calcul automatique\nImportant : en cas de dépassement de la différence entre le  montant conventionné et les montants des DP précédentes, la justification ou non d'un tel dépassement est laissé à la libre appréciation du service instructeur. Si celle-ci est jugée valable, le service peut supprimer la formule et saisir manuellement le montant estimé éligible. ","Calcul automatique","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée lors de la phase d'instruction.\nEx: identification d'une sanction…)"]
["Exemple","Hangar","Transformation / Commercialisation",{"v":0.05,"d":"5.00%"},{"v":1000,"d":"1,000.00 €"},"2025-02-05","Attestation d'affectation du bien à l'opération","Estimation de la valeur locative du bien par un expert indépendant habilité",{"$f":"IF(D5=\"\",\"\",D5*E5)","v":{"v":50,"d":"50.00 €"}},null,{"$f":"IF(B5=\"\",\"\",B5)","v":"Hangar"},"Transformation / Commercialisation",{"v":0.05,"d":"5.00%"},{"v":1000,"d":"1,000.00 €"},"Oui","Oui","Oui","Oui",{"v":3900,"d":"3,900.00 €"},{"v":3900,"d":"3,900.00 €"},null,{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"}]
[1,{"$nulls":7},{"$f":"IF(D6=\"\",\"\",D6*E6)","v":""},null,"","",{"$f":"IF(D6=\"\",\"\",D6)","v":""},{"$f":"IF(E6=\"\",\"\",E6)","v":""},{"$nulls":4},{"$f":"IF(OR(M6=\"\", N6=\"\"), \"\", IF(ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M6,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N6,CHAR(160),\"\"))),0),2)=0, \"\", ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M6,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N6,CHAR(160),\"\"))),0),2)))","v":""},null,null,{"$f":"IF(B6=\"\",\"\",IF(OR(P6=\"Non\",O6=\"Non\",Q6=\"Non\",R6=\"Non\"),0,\nIF(S6<=T6-U6,S6,T6-U6)))","v":""},{"$f":"IF(OR(I6=\"\",V6=\"\"),\"\",I6-V6)","v":""},{"$f":"IF(AND(V6=\"\",U6=\"\"),\"\",V6+U6)","v":""}]
[2,{"$nulls":7},{"$f":"IF(E7=\"\",\"\",E7*#REF!)","v":""},null,{"$f":"IF(B7=\"\",\"\",B7)","v":""},"",{"$f":"IF(D7=\"\",\"\",D7)","v":""},"",{"$nulls":4},{"$f":"IF(OR(M7=\"\", N7=\"\"), \"\", IF(ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M7,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N7,CHAR(160),\"\"))),0),2)=0, \"\", ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M7,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N7,CHAR(160),\"\"))),0),2)))","v":""},null,null,{"$f":"IF(B7=\"\",\"\",IF(OR(P7=\"Non\",O7=\"Non\",Q7=\"Non\",R7=\"Non\"),0,\nIF(S7<=T7-U7,S7,T7-U7)))","v":""},{"$f":"IF(OR(I7=\"\",V7=\"\"),\"\",I7-V7)","v":""},""]
[3,{"$nulls":7},{"$f":"IF(E8=\"\",\"\",E8*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,{"$f":"IF(B8=\"\",\"\",IF(OR(P8=\"Non\",O8=\"Non\",Q8=\"Non\",R8=\"Non\"),0,\nIF(S8<=T8-U8,S8,T8-U8)))","v":""},"",""]
[4,{"$nulls":7},{"$f":"IF(E9=\"\",\"\",E9*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,{"$f":"IF(B9=\"\",\"\",IF(OR(#REF!=\"Non\",O9=\"Non\",Q9=\"Non\",R9=\"Non\"),0,\nIF(S9<=T9-U9,S9,T9-U9)))","v":""},"",""]
[5,{"$nulls":7},{"$f":"IF(E10=\"\",\"\",E10*#REF!)","v":""},null,{"$f":"IF(B10=\"\",\"\",B10)","v":""},{"$f":"IF(C10=\"\",\"\",C10)","v":""},"","",{"$nulls":4},"",null,null,{"$f":"IF(B10=\"\",\"\",IF(OR(P9=\"Non\",O10=\"Non\",Q10=\"Non\",R10=\"Non\"),0,\nIF(S10<=T10-U10,S10,T10-U10)))","v":""},"",""]
[6,{"$nulls":7},{"$f":"IF(E11=\"\",\"\",E11*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[7,{"$nulls":7},{"$f":"IF(E12=\"\",\"\",E12*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[8,{"$nulls":7},{"$f":"IF(E13=\"\",\"\",E13*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[9,{"$nulls":7},{"$f":"IF(E14=\"\",\"\",E14*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[10,{"$nulls":7},{"$f":"IF(E15=\"\",\"\",E15*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[11,{"$nulls":7},{"$f":"IF(E16=\"\",\"\",E16*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[12,{"$nulls":7},{"$f":"IF(E17=\"\",\"\",E17*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[13,{"$nulls":7},{"$f":"IF(E18=\"\",\"\",E18*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[14,{"$nulls":7},{"$f":"IF(E19=\"\",\"\",E19*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[15,{"$nulls":7},{"$f":"IF(E20=\"\",\"\",E20*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[16,{"$nulls":7},{"$f":"IF(E21=\"\",\"\",E21*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[17,{"$nulls":7},{"$f":"IF(E22=\"\",\"\",E22*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[18,{"$nulls":7},{"$f":"IF(E23=\"\",\"\",E23*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[19,{"$nulls":7},{"$f":"IF(E24=\"\",\"\",E24*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[20,{"$nulls":7},{"$f":"IF(E25=\"\",\"\",E25*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[21,{"$nulls":7},{"$f":"IF(E26=\"\",\"\",E26*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[22,{"$nulls":7},{"$f":"IF(E27=\"\",\"\",E27*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[23,{"$nulls":7},{"$f":"IF(E28=\"\",\"\",E28*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[24,{"$nulls":7},{"$f":"IF(E29=\"\",\"\",E29*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[25,{"$nulls":7},{"$f":"IF(E30=\"\",\"\",E30*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[26,{"$nulls":7},{"$f":"IF(E31=\"\",\"\",E31*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[27,{"$nulls":7},{"$f":"IF(E32=\"\",\"\",E32*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[28,{"$nulls":7},{"$f":"IF(E33=\"\",\"\",E33*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[29,{"$nulls":7},{"$f":"IF(E34=\"\",\"\",E34*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[30,{"$nulls":7},{"$f":"IF(E35=\"\",\"\",E35*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[31,{"$nulls":7},{"$f":"IF(E36=\"\",\"\",E36*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[32,{"$nulls":7},{"$f":"IF(E37=\"\",\"\",E37*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[33,{"$nulls":7},{"$f":"IF(E38=\"\",\"\",E38*#REF!)","v":""},null,"","","","",{"$nulls":4},{"$f":"IF(OR(M38=\"\", N38=\"\"), \"\", IF(ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M38,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N38,CHAR(160),\"\"))),0),2)=0, \"\", ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M38,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N38,CHAR(160),\"\"))),0),2)))","v":""},null,null,"",{"$f":"IF(OR(I38=\"\",V38=\"\"),\"\",I38-V38)","v":""},{"$f":"IF(AND(V38=\"\",U38=\"\"),\"\",V38+U38)","v":""}]
[34,{"$nulls":7},{"$f":"IF(E39=\"\",\"\",E39*#REF!)","v":""},null,"","","",{"$f":"IF(E39=\"\",\"\",E39)","v":""},{"$nulls":4},"",null,null,"","",""]
[35,{"$nulls":7},{"$f":"IF(E40=\"\",\"\",E40*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[36,{"$nulls":7},{"$f":"IF(E41=\"\",\"\",E41*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[37,{"$nulls":7},{"$f":"IF(E42=\"\",\"\",E42*#REF!)","v":""},null,{"$f":"IF(B42=\"\",\"\",B42)","v":""},{"$f":"IF(C42=\"\",\"\",C42)","v":""},"","",{"$nulls":4},"",null,null,"","",""]
[38,{"$nulls":7},{"$f":"IF(E43=\"\",\"\",E43*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[39,{"$nulls":7},{"$f":"IF(E44=\"\",\"\",E44*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[40,{"$nulls":7},{"$f":"IF(E45=\"\",\"\",E45*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[41,{"$nulls":7},{"$f":"IF(E46=\"\",\"\",E46*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[42,{"$nulls":7},{"$f":"IF(E47=\"\",\"\",E47*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[43,{"$nulls":7},{"$f":"IF(E48=\"\",\"\",E48*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[44,{"$nulls":7},{"$f":"IF(E49=\"\",\"\",E49*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[45,{"$nulls":7},{"$f":"IF(E50=\"\",\"\",E50*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[46,{"$nulls":7},{"$f":"IF(E51=\"\",\"\",E51*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[47,{"$nulls":7},{"$f":"IF(E52=\"\",\"\",E52*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[48,{"$nulls":7},{"$f":"IF(E53=\"\",\"\",E53*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[49,{"$nulls":7},{"$f":"IF(E54=\"\",\"\",E54*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[50,{"$nulls":7},{"$f":"IF(E55=\"\",\"\",E55*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[51,{"$nulls":7},{"$f":"IF(E56=\"\",\"\",E56*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[52,{"$nulls":7},{"$f":"IF(E57=\"\",\"\",E57*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[53,{"$nulls":7},{"$f":"IF(E58=\"\",\"\",E58*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[54,{"$nulls":7},{"$f":"IF(E59=\"\",\"\",E59*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[55,{"$nulls":7},{"$f":"IF(E60=\"\",\"\",E60*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[56,{"$nulls":7},{"$f":"IF(E61=\"\",\"\",E61*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[57,{"$nulls":7},{"$f":"IF(E62=\"\",\"\",E62*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[58,{"$nulls":7},{"$f":"IF(E63=\"\",\"\",E63*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[59,{"$nulls":7},{"$f":"IF(E64=\"\",\"\",E64*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[60,{"$nulls":7},{"$f":"IF(E65=\"\",\"\",E65*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[61,{"$nulls":7},{"$f":"IF(E66=\"\",\"\",E66*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[62,{"$nulls":7},{"$f":"IF(E67=\"\",\"\",E67*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[63,{"$nulls":7},{"$f":"IF(E68=\"\",\"\",E68*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[64,{"$nulls":7},{"$f":"IF(E69=\"\",\"\",E69*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[65,{"$nulls":7},{"$f":"IF(E70=\"\",\"\",E70*#REF!)","v":""},null,"","","","",{"$nulls":4},{"$f":"IF(OR(M70=\"\", N70=\"\"), \"\", IF(ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M70,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N70,CHAR(160),\"\"))),0),2)=0, \"\", ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(M70,CHAR(160),\"\"))),0),2)*ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(N70,CHAR(160),\"\"))),0),2)))","v":""},null,null,{"$f":"IF(B70=\"\",\"\",IF(OR(P70=\"Non\",O70=\"Non\",Q70=\"Non\",R70=\"Non\"),0,\nIF(S70<=T70-U70,S70,T70-U70)))","v":""},{"$f":"IF(OR(I70=\"\",V70=\"\"),\"\",I70-V70)","v":""},{"$f":"IF(AND(V70=\"\",U70=\"\"),\"\",V70+U70)","v":""}]
[66,{"$nulls":7},{"$f":"IF(E71=\"\",\"\",E71*#REF!)","v":""},null,"","",{"$f":"IF(D71=\"\",\"\",D71)","v":""},{"$f":"IF(E71=\"\",\"\",E71)","v":""},{"$nulls":4},"",null,null,"","",""]
[67,{"$nulls":7},{"$f":"IF(E72=\"\",\"\",E72*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[68,{"$nulls":7},{"$f":"IF(E73=\"\",\"\",E73*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[69,{"$nulls":7},{"$f":"IF(E74=\"\",\"\",E74*#REF!)","v":""},null,{"$f":"IF(B74=\"\",\"\",B74)","v":""},{"$f":"IF(C74=\"\",\"\",C74)","v":""},"","",{"$nulls":4},"",null,null,"","",""]
[70,{"$nulls":7},{"$f":"IF(E75=\"\",\"\",E75*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[71,{"$nulls":7},{"$f":"IF(E76=\"\",\"\",E76*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[72,{"$nulls":7},{"$f":"IF(E77=\"\",\"\",E77*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[73,{"$nulls":7},{"$f":"IF(E78=\"\",\"\",E78*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[74,{"$nulls":7},{"$f":"IF(E79=\"\",\"\",E79*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[75,{"$nulls":7},{"$f":"IF(E80=\"\",\"\",E80*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[76,{"$nulls":7},{"$f":"IF(E81=\"\",\"\",E81*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[77,{"$nulls":7},{"$f":"IF(E82=\"\",\"\",E82*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[78,{"$nulls":7},{"$f":"IF(E83=\"\",\"\",E83*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[79,{"$nulls":7},{"$f":"IF(E84=\"\",\"\",E84*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[80,{"$nulls":7},{"$f":"IF(E85=\"\",\"\",E85*#REF!)","v":""},null,{"$f":"IF(B85=\"\",\"\",B85)","v":""},{"$f":"IF(C85=\"\",\"\",C85)","v":""},"","",{"$nulls":4},"",null,null,"","",""]
[81,{"$nulls":7},{"$f":"IF(E86=\"\",\"\",E86*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[82,{"$nulls":7},{"$f":"IF(E87=\"\",\"\",E87*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[83,{"$nulls":7},{"$f":"IF(E88=\"\",\"\",E88*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[84,{"$nulls":7},{"$f":"IF(E89=\"\",\"\",E89*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[85,{"$nulls":7},{"$f":"IF(E90=\"\",\"\",E90*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[86,{"$nulls":7},{"$f":"IF(E91=\"\",\"\",E91*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[87,{"$nulls":7},{"$f":"IF(E92=\"\",\"\",E92*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[88,{"$nulls":7},{"$f":"IF(E93=\"\",\"\",E93*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[89,{"$nulls":7},{"$f":"IF(E94=\"\",\"\",E94*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[90,{"$nulls":7},{"$f":"IF(E95=\"\",\"\",E95*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[91,{"$nulls":7},{"$f":"IF(E96=\"\",\"\",E96*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[92,{"$nulls":7},{"$f":"IF(E97=\"\",\"\",E97*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[93,{"$nulls":7},{"$f":"IF(E98=\"\",\"\",E98*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[94,{"$nulls":7},{"$f":"IF(E99=\"\",\"\",E99*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[95,{"$nulls":7},{"$f":"IF(E100=\"\",\"\",E100*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[96,{"$nulls":7},{"$f":"IF(E101=\"\",\"\",E101*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[97,{"$nulls":7},{"$f":"IF(E102=\"\",\"\",E102*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"",{"$f":"IF(OR(I102=\"\",V102=\"\"),\"\",I102-V102)","v":""},""]
[98,{"$nulls":7},{"$f":"IF(E103=\"\",\"\",E103*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[99,{"$nulls":7},{"$f":"IF(E104=\"\",\"\",E104*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[100,{"$nulls":7},{"$f":"IF(E105=\"\",\"\",E105*#REF!)","v":""},null,"","","","",{"$nulls":4},"",null,null,"","",""]
[{"$nulls":7},"Total",{"$f":"SUM(I6:I105)","v":{"v":0,"d":"0.00 €"}},{"$nulls":8},"Total",{"$f":"SUM(S6:S105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(T6:T105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(U6:U105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(V6:V105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(W6:W105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(X6:X105)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"4-Amortissement","index":6,"n_rows":106,"n_cols":23,"rows_kept":106,"merged":[[0,0,0,8],[0,9,0,22],[1,1,1,3],[1,4,1,7],[1,9,1,11],[1,13,1,16],[1,17,1,18],[1,19,1,22],[2,0,3,0]]}
["Partie à remplir par le bénéficiaire - Présentation des dépenses d'amortissement conventionnées",{"$nulls":8},"Partie réservée à l'administration - Instruction des dépenses d'amortissement conventionnées"]
[null,"IDENTIFICATION DE LA DÉPENSE",null,null,"MONTANT DEMANDÉS et CONTRÔLES DES JUSTIFICATIFS",{"$nulls":3},"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",null,null,"CONVENTION","CONTRÔLE DES MONTANTS et DES JUSTIFICATIFS",{"$nulls":3},"SUIVI DES DEMANDES DE PAIEMENT",null,"CONCLUSION"]
["Numéro de la dépense","Description du bien amorti","Taux d'affectation à l'opération sur la durée présentée","Type d'action concerné","Durée totale de l’amortissement demandé","Montant de la charge d'amortissement demandé","Justificatif de la modalité d'amortissement","L'actif amorti a-t-il reçu des subventions publiques ?","Commentaires","Description du bien amorti","Taux d'affectation à l'opération sur la durée présentée","Type d'action concerné","La dépense est-elle conventionnée ?","Le justificatif de la modalité d'amortissement est-il conforme ?","L'actif amorti a-t-il reçu des subventions publiques ?","La durée d’amortissement présentée est-elle conforme ?","Montant de la charge d'amortissement demandé","Montant de la charge d'amortissement conventionné","Montant des dépenses retenues cumulées au titre des précédentes DP","Montant de la charge d'amortissement éligible ","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[null,"(nature du bien)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(si la dépense est affectée partiellement à l'opération, préciser le taux de proratisation retenu ex: 50% ; si la dépense est intégralement liée à l'opération préciser 100%)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(reprendre les types d'actions choisis tel que rempli dans l'onglet 0-Presentation poste-typeaction)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","en année(s)\n(cette durée ne doit pas être supérieure à la durée d'amortissement conventionnée)","A renseigner conformément à la convention ou à son dernier avenant. Pour rappel, le calcul est le suivant\n [(coût total de l'amortissement / durée totale de l'amortissement) x durée d'amortissement présentée ] x taux d'affectation à l'opération)","(Nécessaire si différent du justificatif présenté en demande d'aide, ex : plan d'amortissement prévisionnel, etc.)","Saisir OUI ou NON \n(cela doit être supporté par une attestation sur l’honneur du bénéficiaire qui atteste que le bien amorti n’a pas fait l’objet de subventions publiques)","(le cas échéant, pour préciser un point saillant au Service Instructeur)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Saisir OUI ou NON\nVérifier la conformité de la dépense présentée vis-à-vis de la convention ou du dernier avenant à la convention - au regard des critères suivants \n\n- Nom de la dépense\n- Description de la dépense\n- Type d'action rattaché \n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.\nNB2 : Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0.","Saisir OUI ou NON ","Saisir OUI ou NON ","Saisir OUI ou NON ","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Indiquer le montant présent sur la convention","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","Calcul automatique\nImportant : en cas de dépassement de la différence entre le  montant conventionné et les montants des DP précédentes, la justification ou non d'un tel dépassement est laissé à la libre appréciation du service instructeur. Si celle-ci est jugée valable, le service peut supprimer la formule et saisir manuellement le montant estimé éligible. ","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée lors de la phase d'instruction.\nEx: identification d'une sanction…)"]
["Exemple","Hangar",{"v":1,"d":"100%"},"Performance énergétique","2",{"v":2000,"d":"2,000.00 €"},"Plan d'amortissement","Non",null,"Hangar",{"v":1,"d":"100%"},"Performance énergétique","Oui","Oui","Non","Oui",{"$f":"IF(F5=\"\",\"\",F5*K5)","v":{"v":2000,"d":"2,000.00 €"}},{"v":3000,"d":"3,000.00 €"},null,{"v":3900,"d":"3,900.00 €"},{"v":0,"d":"0.00 €"}]
[1,{"$nulls":8},{"$f":"IF(B6=\"\",\"\",B6)","v":""},{"$f":"IF(C6=\"\",\"\",C6)","v":""},"",null,null,{"$f":"IF(H6=\"\",\"\",H6)","v":""},null,"",null,null,{"$f":"IF(B6=\"\",\"\",IF(M6=\"Non\", 0,IF(N6=\"Non\", 0, IF(O6=\"Oui\", 0, IF(P6=\"Non\", 0, IF(Q6<=(R6-S6), Q6, IF(Q6>(R6-S6), (R6-S6), \"Erreur\")))))))","v":""},{"$f":"IF(OR(F6=\"\",T6=\"\"),\"\",F6-T6)","v":""},{"$f":"IF(AND(S6=\"\",T6=\"\"),\"\",T6+S6)","v":""}]
[2,{"$nulls":8},{"$f":"IF(B7=\"\",\"\",B7)","v":""},{"$f":"IF(C7=\"\",\"\",C7)","v":""},{"$f":"IF(D7=\"\",\"\",D7)","v":""},null,null,{"$f":"IF(H7=\"\",\"\",H7)","v":""},null,{"$f":"IF(F7=\"\",\"\",F7*K7)","v":""},null,null,{"$f":"IF(B7=\"\",\"\",IF(M7=\"Non\", 0,IF(N7=\"Non\", 0, IF(O7=\"Oui\", 0, IF(P7=\"Non\", 0, IF(Q7<=(R7-S7), Q7, IF(Q7>(R7-S7), (R7-S7), \"Erreur\")))))))","v":""},{"$f":"IF(OR(F7=\"\",T7=\"\"),\"\",F7-T7)","v":""},{"$f":"IF(AND(S7=\"\",T7=\"\"),\"\",T7+S7)","v":""}]
[3,{"$nulls":8},{"$f":"IF(B8=\"\",\"\",B8)","v":""},"",{"$f":"IF(D8=\"\",\"\",D8)","v":""},null,null,{"$f":"IF(H8=\"\",\"\",H8)","v":""},null,"",null,null,{"$f":"IF(B8=\"\",\"\",IF(M8=\"Non\", 0,IF(N8=\"Non\", 0, IF(O8=\"Oui\", 0, IF(P8=\"Non\", 0, IF(Q8<=(R8-S8), Q8, IF(Q8>(R8-S8), (R8-S8), \"Erreur\")))))))","v":""},"",""]
[4,{"$nulls":9},"","",null,null,"",null,"",null,null,"","",""]
[5,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[6,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[7,{"$nulls":9},"","",null,null,"",null,"",null,null,"","",""]
[8,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[9,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[10,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[11,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[12,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[13,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[14,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[15,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[16,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[17,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[18,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[19,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[20,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[21,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[22,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[23,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[24,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[25,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[26,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[27,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[28,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[29,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[30,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[31,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[32,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[33,{"$nulls":8},"","","",null,null,"",null,{"$f":"IF(F38=\"\",\"\",F38*K38)","v":""},null,null,{"$f":"IF(B38=\"\",\"\",IF(M38=\"Non\", 0,IF(N38=\"Non\", 0, IF(O38=\"Oui\", 0, IF(P38=\"Non\", 0, IF(Q38<=(R38-S38), Q38, IF(Q38>(R38-S38), (R38-S38), \"Erreur\")))))))","v":""},{"$f":"IF(OR(F38=\"\",T38=\"\"),\"\",F38-T38)","v":""},{"$f":"IF(AND(S38=\"\",T38=\"\"),\"\",T38+S38)","v":""}]
[34,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[35,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[36,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[37,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[38,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[39,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[40,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[41,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[42,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[43,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[44,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[45,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[46,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[47,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[48,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[49,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[50,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[51,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[52,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[53,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[54,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[55,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[56,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[57,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[58,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[59,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[60,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[61,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[62,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[63,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[64,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[65,{"$nulls":8},"","","",null,null,"",null,{"$f":"IF(F70=\"\",\"\",F70*K70)","v":""},null,null,{"$f":"IF(B70=\"\",\"\",IF(M70=\"Non\", 0,IF(N70=\"Non\", 0, IF(O70=\"Oui\", 0, IF(P70=\"Non\", 0, IF(Q70<=(R70-S70), Q70, IF(Q70>(R70-S70), (R70-S70), \"Erreur\")))))))","v":""},{"$f":"IF(OR(F70=\"\",T70=\"\"),\"\",F70-T70)","v":""},{"$f":"IF(AND(S70=\"\",T70=\"\"),\"\",T70+S70)","v":""}]
[66,{"$nulls":8},{"$f":"IF(B71=\"\",\"\",B71)","v":""},"",{"$f":"IF(D71=\"\",\"\",D71)","v":""},null,null,{"$f":"IF(H71=\"\",\"\",H71)","v":""},null,"",null,null,"","",""]
[67,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[68,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[69,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[70,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[71,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[72,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[73,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[74,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[75,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[76,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[77,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[78,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[79,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[80,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[81,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[82,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[83,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[84,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[85,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[86,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[87,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[88,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[89,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[90,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[91,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[92,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[93,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[94,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[95,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[96,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[97,{"$nulls":8},"","","",null,null,"",null,"",null,null,{"$f":"IF(B102=\"\",\"\",IF(M102=\"Non\", 0,IF(N102=\"Non\", 0, IF(O102=\"Oui\", 0, IF(P102=\"Non\", 0, IF(Q102<=(R102-S102), Q102, IF(Q102>(R102-S102), (R102-S102), \"Erreur\")))))))","v":""},{"$f":"IF(OR(F102=\"\",T102=\"\"),\"\",F102-T102)","v":""},""]
[98,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[99,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[100,{"$nulls":8},"","","",null,null,"",null,"",null,null,"","",""]
[{"$nulls":4},"Total",{"$f":"SUM(F6:F105)","v":{"v":0,"d":"0.00 €"}},{"$nulls":9},"Total",{"$f":"SUM(Q6:Q105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(R6:R105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(S6:S105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(T6:T105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(U6:U105)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(V6:V105)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"5-Tx forf personnel+autoconst","index":7,"n_rows":15,"n_cols":16,"rows_kept":15,"merged":[[0,0,0,5],[0,6,0,15],[1,0,1,5],[1,6,1,15],[2,0,3,0],[5,3,13,3]]}
["Dépenses couvertes par application d'une option de coûts simplifiés (OCS) - taux forfaitaire de 20% des dépenses directes de l’opération pour couvrir les éventuelles dépenses de personnel et d’auto-construction.\nPour le type d'action \"Plantations pérennes\" pour la banane et la canne à sucre : ne mobiliser que les OCS de type coûts unitaires correspondants en onglets 6 et 7",{"$nulls":5},"Dépenses couvertes par application d'une option de coûts simplifiés (OCS) - taux forfaitaire de 20% des dépenses directes de l’opération pour couvrir les éventuelles dépenses de personnel et d’auto-construction.\nPour le type d'action \"Plantations pérennes\" pour la banane et la canne à sucre : ne mobiliser que les OCS de type coûts unitaires correspondants en onglets 6 et 7"]
["Partie à remplir par le bénéficiaire - Présentation des dépenses de personnel et d'autoconstruction conventionnées prises en compte par application d'un taux forfaitaire",{"$nulls":5},"Partie réservée à l'administration - Instruction des dépenses de personnel et d'autoconstruction conventionnées prises en compte par application d'un taux forfaitaire"]
["Numéro de la dépense","Type d'action concerné","Montant des dépenses présentées servant de base de calcul","Souhaitez-vous bénéficier du taux forfaitaire de 20% des dépenses directes de l’opération pour couvrir des dépenses de personnel et/ou d’auto-construction?","Montant de l'OCS demandé","Commentaire(s)","Type d'action concerné","La dépense est-elle conventionnée en taux forfaitaire ?","OCS conventionné ","OCS cumulé au titre des précédentes DP","Montant des dépenses éligibles servant de base de calcul","Montant demandé de l'OCS","Montant éligible de l'OCS","Montant écarté","OCS final cumulé  au titre des DP instruites à date","Commentaires du Service Instructeur"]
[null,"(nom du type d'action)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(saisie automatique sur la base des informations déclarées dans les onglets précédents)","sélectionner Oui ou Non dans la liste déroulante ;\nsi l'opération mobilise des frais de personnel et/ou d'autoconstruction sélectionner \"Oui\" et justifier le caractère nécessaire des frais couverts par l'OCS dans une note rattachée au plan de financement","(saisie automatique, par application du taux forfaitaire de 20% des investissements, des frais généraux, des amortissements et des contributions en nature afin de couvrir les frais de personnel directs  et des frais d'autoconstruction)\n","(toute précision pertinente le cas échéant pour la compréhension de l'action prévue...)\nPrécisez la nature de la plantation pérenne concernée par la ligne de dépense le cas échéant","(nom du type d'action à sélectionner dans le menu déroulant, en cohérence avec les éléments saisis dans l'onglet 0)","Saisir OUI ou NON\nVérifier la conformité de la dépense présentée vis-à-vis de la convention ou du dernier avenant à la convention - au regard des critères suivants \n- Type d'action rattaché \n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.\nNB2 : Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0.","Indiquer le montant présent sur la convention","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Calcul automatique\nImportant : en cas de dépassement de la différence entre le  montant conventionné et les montants des DP précédentes, la justification ou non d'un tel dépassement est laissé à la libre appréciation du service instructeur. Si celle-ci est jugée valable, le service peut supprimer la formule et saisir manuellement le montant estimé éligible. ","(report automatique de la demande. Corriger les informations des cellules selon les modalités d'instruction)","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée et/ou toute révision de la dépense lors de la phase d'instruction.\nEx: motif d'inéligibilité, révision du poste de dépense, correction du numéro de devis, absence de devis opposable…)"]
["Exemple","Construction / aménagement bâtiments",{"v":30000,"d":"30,000.00 €"},"Oui",{"$f":"IF(AND(C5<>\"\",$D$6=\"Oui\"),IFERROR(C5*0.2,\"\"),\"\")","v":{"v":6000,"d":"6,000.00 €"}},null,"Construction / aménagement bâtiments","Oui",{"$nulls":5},{"$f":"IF(OR(E5=\"\",M5=\"\"),\"\",E5-M5)","v":""}]
[1,"Modernisation installations / mécanisation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B6)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B6)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B6)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B6)","v":{"v":0,"d":"0.00 €"}},"Oui",{"$f":"IF(AND(C6<>\"\",$D$6=\"Oui\"),IFERROR(C6*0.2,\"\"),\"\")","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(B6=\"\",\"\",B6)","v":"Modernisation installations / mécanisation"},{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G6)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G6)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G6)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G6)","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(K6*0.2,\"\")","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(B6=\"\",\"\",IF(H6=\"Non\",0,IF(L6<=(I6-J6),L6,IF(L6>(I6-J6),(I6-J6),\"Erreur\"))))","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"IF(AND(J6=\"\",M6=\"\"),\"\",M6+J6)","v":{"v":0,"d":"0.00 €"}}]
[2,"Construction / aménagement bâtiments",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B7)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B7)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B7)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B7)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(AND(C7<>\"\",$D$6=\"Oui\"),IFERROR(C7*0.2,\"\"),\"\")","v":{"v":0,"d":"0.00 €"}},null,"Construction / aménagement bâtiments",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G7)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G7)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G7)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G7)","v":{"v":0,"d":"0.00 €"}},{"$f":"IFERROR(K7*0.2,\"\")","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(AND(J7=\"\",M7=\"\"),\"\",M7+J7)","v":{"v":0,"d":"0.00 €"}}]
[3,"Plantations pérennes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B8)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B8)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B8)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B8)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"IF(AND(C8<>\"\",$D$6=\"Oui\"),IFERROR(C8*0.2,\"\"),\"\")","v":{"v":0,"d":"0.00 €"}},null,"Plantations pérennes",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G8)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G8)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G8)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G8)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(AND(J8=\"\",M8=\"\"),\"\",M8+J8)","v":{"v":0,"d":"0.00 €"}}]
[4,"Irrigation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B9)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B9)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B9)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B9)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Irrigation",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G9)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G9)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G9)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G9)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[5,"Performance énergétique",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B10)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B10)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B10)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B10)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Performance énergétique",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G10)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G10)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G10)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G10)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[6,"Transformation / Commercialisation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B11)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B11)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B11)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B11)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Transformation / Commercialisation",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G11)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G11)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G11)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G11)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[7,"Amélioration foncière",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B12)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B12)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B12)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B12)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Amélioration foncière",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G12)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G12)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G12)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G12)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[8,"Diversification des activités - gîtes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B13)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B13)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B13)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B13)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Diversification des activités - gîtes",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G13)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G13)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G13)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G13)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[9,"Diversification des activités - hors gîtes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'5-Tx forf personnel+autoconst'!B14)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'5-Tx forf personnel+autoconst'!B14)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'5-Tx forf personnel+autoconst'!B14)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'5-Tx forf personnel+autoconst'!B14)","v":{"v":0,"d":"0.00 €"}},null,{"v":0,"d":"0.00 €"},null,"Diversification des activités - hors gîtes",{"$nulls":3},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,'5-Tx forf personnel+autoconst'!G14)+SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G14)+SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,'5-Tx forf personnel+autoconst'!G14)+SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,'5-Tx forf personnel+autoconst'!G14)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Montant présenté ",{"$f":"SUM(C6:C14)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(E6:E14)","v":{"v":0,"d":"0.00 €"}},null,null,"Total",{"$f":"SUM(I6:I14)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(O6:O14)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"6-Coût unitaire bananes","index":8,"n_rows":26,"n_cols":34,"rows_kept":26,"merged":[[0,0,0,13],[0,14,0,33],[1,3,1,10],[1,11,1,12],[1,14,1,24],[1,26,1,27],[1,28,1,29],[1,30,1,33],[2,0,3,0]]}
["Partie à remplir par le bénéficiaire - Présentation des dépenses conventionnées de coût unitaire pour la plantation pérenne \"banane\"",{"$nulls":13},"Partie réservée à l'administration - Instruction des dépenses conventionnées de coût unitaire pour la plantation pérenne \"banane\""]
[{"$nulls":3},"IDENTIFICATION DE LA DÉPENSE",{"$nulls":7},"MONTANT DEMANDÉS et CONTRÔLES DES JUSTIFICATIFS",null,"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",{"$nulls":10},"CONVENTION","CONTRÔLE DES MONTANTS et DES JUSTIFICATIFS",null,"SUIVI DES DEMANDES DE PAIEMENT",null,"CONCLUSION"]
["Numéro du conseil","N°PACAGE","N° SIRET","Type d'action concerné","Parcelle","Ilot","Surface demandée","Nombre de plants livrés ","Densité","Présence d'un amendement organique","Date de plantation ","Coût unitaire total demandé en €","Référence de la pièce justificative ","Commentaire","N°PACAGE","N° SIRET","Type d'action concerné","Parcelle","Ilot","Surface demandée","Nombre de plants livrés ","Densité","Présence d'un amendement organique","Date de plantation ","La date de réalisation est-elle conforme avec la convention ? ","La dépense est-elle conventionnée ? ","Les  pièces justificatives sont-elle conformes ?","Coût unitaire total demandé en €","Coût unitaire total conventionné en €","Montant des dépenses retenues cumulées au titre des précédentes DP","Coût unitaire total  éligible en €","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[{"$nulls":3},"(nom du type d'action à sélectionner dans le menu déroulant, en cohérence avec les éléments saisis dans l'onglet 0)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","numéro de la parcelle","numéro de l'îlot","(en ha)","(plants)","(plants/ha)","(Répondre OUI ou NON dans le menu déroulant)\n \nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","Préciser la date à laquelle a eu lieu la plantation. Pour rappel, les bénéficiaires d'une aide au titre des plantations pérennes doivent garantir que la plantation durera 5 ans à partir de sa plantation. ","(Montant en €)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(Nom du document joint)","(le cas échéant, pour préciser un point saillant au Service Instructeur)",null,null,"(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","La réalisation de la dépense a eu lieu durnat la période de réalisation conventionnée ? ","OUI ou NON\nVérifier la conformité de la facture au regard des critères suivants \n(Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0). \n\n- Type d'action rattaché\n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.","Saisir OUI ou NON ","(saisie automatique à corriger selon les modalités d'instruction)","Copier coller le montant présent sur la convention.","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée et/ou toute révision de la dépense lors de la phase d'instruction.\nEx: motif d'inéligibilité, révision du poste de dépense, correction du numéro de devis, absence de devis opposable…)"]
["Exemple",null,null,"Plantations pérennes",1,1,{"v":1,"d":"1.00"},1850,{"$f":"IF(G5=0,\"\",H5/G5)","v":{"v":1850,"d":"1850.00"}},"Oui","2025-01-01",{"$f":"IF(I5=\"\",\"\",IF(J5=\"OUI\",IF(I5>=1850,10400*G5,(I5/1850)*10400*G5),IF(I5>=1850,8600*G5,(I5/1850)*8600*G5)))","v":{"v":10400,"d":"10,400.00 €"}},"XX",{"$nulls":3},"Plantations pérennes",{"$f":"IF(E5=\"\",\"\",E5)","v":1},1,{"$f":"IF(I5<1850,U5/1850,G5)","v":1},{"$f":"IF(H5=\"\",\"\",H5)","v":1850},{"$f":"IF(T5=0,\"\",U5/T5)","v":1850},{"$f":"IF(J5=\"\",\"\",J5)","v":"Oui"},{"$f":"IF(K5=\"\",\"\",K5)","v":"2025-01-01"},"Oui","Oui","Oui",{"$f":"IF(V5=\"\",\"\",IF(W5=\"OUI\",IF(V5>=1850,10400*T5,(V5/1850)*10400*T5),IF(V5>=1850,8600*T5,(V5/1850)*8600*T5)))","v":{"v":10400,"d":"10,400.00 €"}},{"v":10400,"d":"10,400.00 €"},null,{"$f":"IF(T5=\"\",\"\",IF(Z5=\"Non\",0, IF(Y5=\"Non\",0,IF(AA5=\"Non\",0,IF(AB5<=(AC5-AD5),AB5,IF(AB5>(AC5-AD5),(AC5-AD5)))))))","v":{"v":10400,"d":"10,400.00 €"}},{"$f":"IF(OR(L5=\"\",AC5=\"\"),\"\",ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(L5,CHAR(160),\"\"))),0),2)-ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(AC5,CHAR(160),\"\"))),0),2))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(AND(AD5=\"\",AE5=\"\"),\"\",AE5+AD5)","v":{"v":10400,"d":"10,400.00 €"}}]
[1,{"$nulls":7},{"$f":"IF(G6=0,\"\",H6/G6)","v":""},null,null,{"$f":"IF(I6=\"\",\"\",IF(J6=\"OUI\",IF(I6>=1850,10400*G6,(I6/1850)*10400*G6),IF(I6>=1850,8600*G6,(I6/1850)*8600*G6)))","v":""},null,null,{"$f":"IF(B6=\"\",\"\",B6)","v":""},{"$f":"IF(C6=\"\",\"\",C6)","v":""},{"$f":"IF(D6=\"\",\"\",D6)","v":""},"","",{"$f":"IF(I6<1850,U6/1850,G6)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H6=\"\",\"\",H6)","v":""},{"$f":"IF(T6=0,\"\",U6/T6)","v":""},{"$f":"IF(J6=\"\",\"\",J6)","v":""},{"$f":"IF(K6=\"\",\"\",K6)","v":""},{"$nulls":3},{"$f":"IFERROR(\n    _xlfn.IFS(\n        W6=\"Oui\", 10400 * T6,\n        W6=\"Non\", 8600 * T6\n    ),\n\"\")","v":""},null,null,{"$f":"IF(T6=\"\",\"\",IF(OR(Z6=\"Non\",Y6=\"Non\",AA6=\"Non\"),0,MIN(AB6,AC6-AD6)))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(OR(L6=\"\",AE6=\"\"),\"\",ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(L6,CHAR(160),\"\"))),0),2)-ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(AE6,CHAR(160),\"\"))),0),2))","v":""},{"v":0,"d":"0.00 €"}]
[2,{"$nulls":7},{"$f":"IF(G7=0,\"\",H7/G7)","v":""},null,null,{"$f":"IF(I7=\"\",\"\",IF(J7=\"OUI\",IF(I7>=1850,10400*G7,(I7/1850)*10400*G7),IF(I7>=1850,8600*G7,(I7/1850)*8600*G7)))","v":""},null,null,{"$f":"IF(B7=\"\",\"\",B7)","v":""},{"$f":"IF(C7=\"\",\"\",C7)","v":""},"","","",{"$f":"IF(I7<1850,U7/1850,G7)","v":{"v":0,"d":"0.00"}},{"$f":"IF(H7=\"\",\"\",H7)","v":""},{"$f":"IF(T7=0,\"\",U7/T7)","v":""},{"$f":"IF(J7=\"\",\"\",J7)","v":""},{"$f":"IF(K7=\"\",\"\",K7)","v":""},{"$nulls":3},{"$f":"IFERROR(\n    _xlfn.IFS(\n        W7=\"Oui\", 10400 * T7,\n        W7=\"Non\", 8600 * T7\n    ),\n\"\")","v":""},null,null,{"$f":"IF(T7=\"\",\"\",IF(OR(Z7=\"Non\",Y7=\"Non\",AA7=\"Non\"),0,MIN(AB7,AC7-AD7)))","v":{"v":0,"d":"0.00 €"}},"",{"v":0,"d":"0.00 €"}]
[3,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[4,{"$nulls":7},"",null,null,"",null,null,"","","",{"$f":"IF(E9=\"\",\"\",E9)","v":""},null,{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[5,{"$nulls":7},"",null,null,"",null,null,"","","","",{"$f":"IF(F10=\"\",\"\",F10)","v":""},{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[6,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[7,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[8,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[9,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[10,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[11,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[12,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[13,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[14,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[15,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[16,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[17,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[18,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[19,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[20,{"$nulls":7},"",null,null,"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[{"$nulls":8},{"$f":"SUM(L6:L25)","v":{"v":0,"d":"0.00 €"}},"Total présenté",null,{"$f":"SUM(L6:L25)","v":{"v":0,"d":"0.00 €"}},{"$nulls":15},{"$f":"SUM(AB6:AB25)","v":{"v":0,"d":"0.00 €"}},"Total",{"$f":"SUM(AD6:AD25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AE6:AE25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AF6:AF25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AG6:AG25)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"7-Coût unitaire cannes à sucre","index":9,"n_rows":26,"n_cols":36,"rows_kept":26,"merged":[[0,0,0,14],[0,15,0,35],[1,1,1,11],[1,12,1,13],[1,15,1,26],[1,28,1,29],[1,30,1,31],[1,32,1,35],[2,0,3,0]]}
["Partie à remplir par le bénéficiaire - Présentation des dépenses conventionnées de coût unitaire pour la plantation pérenne \"canne à sucre\"",{"$nulls":14},"Partie réservée à l'administration - Instruction des dépenses conventionnées de coût unitaire pour la plantation pérenne \"canne à sucre\""]
[null,"IDENTIFICATION DE LA DÉPENSE",{"$nulls":10},"MONTANT DEMANDÉS et CONTRÔLES DES JUSTIFICATIFS",null,"COMMENTAIRES","IDENTIFICATION DE LA DÉPENSE",{"$nulls":11},"CONVENTION","CONTRÔLE DES MONTANTS et DES JUSTIFICATIFS",null,"SUIVI DES DEMANDES DE PAIEMENT",null,"CONCLUSION"]
["Numéro du conseil","N°PACAGE","N° SIRET","Type d'action concerné","Parcelle","Ilot","Surface","Tonnage livré","Densité","La plantation est-elle à Marie-Galante ?","La plantation est-elle à simple rang ou double rang ?","Date de plantation ","Coût unitaire  total demandé en €","Référence de la pièce justificative ","Commentaire","N°PACAGE","N° SIRET","Type d'action concerné","Parcelle","Ilot","Surface demandée","Tonnage livré","Densité","La plantation est-elle à Marie-Galante ?","La plantation est-elle à simple rang ou double rang ?","Date de plantation ","La date de réalisation est-elle conforme avec la convention ? ","La dépense est-elle conventionnée ? ","Les pièces justificatives sont-elles conformes ?","Coût unitaire total demandé en €","Cout unitaire total conventionné en €","Montant des dépenses retenues cumulées au titre des précédentes DP","Coût unitaire total éligible en €","Montant écarté","Montant final des dépenses retenues cumulées au titre des DP instruites à date","Commentaires du Service Instructeur"]
[{"$nulls":3},"(nom du type d'action à sélectionner dans le menu déroulant, en cohérence avec les éléments saisis dans l'onglet 0)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","numéro de la parcelle","numéro de l'îlot","(en ha)","(En tonnes)","(En tonnes/ha)","(Répondre OUI ou NON dans le menu déroulant)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","(Répondre simple ou double dans le menu déroulant)\n\nAttention : la dépense présentée doit être conforme à la convention ou au dernier avenant à la convention","Préciser la date à laquelle a eu lieu la plantation. Pour rappel, les bénéficiaires d'une aide au titre des plantations pérennes doivent garantir que la plantation durera 5 ans à partir de sa plantation. ","(Montant en €)","(Nom du document joint)","(le cas échéant, pour préciser un point saillant au Service Instructeur)",null,null,"(saisie automatique à corriger selon les modalités d'instruction)","numéro de la parcelle","numéro de l'îlot","(saisie automatique à corriger selon les modalités d'instruction)","(En tonnes)","(En tonnes/ha)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique à corriger selon les modalités d'instruction)","La réalisation de la dépense a eu lieu durnat la période de réalisation conventionnée ? ","OUI ou NON\nVérifier la conformité de la facture au regard des critères suivants \n(Si au moins un des critères ci-dessous n'est pas conforme au conventionnement, mettre NON. Le montant tombera alors à 0). \n\n- Type d'action rattaché\n\nNB : Le porteur devra faire une demande d'avenant en cas de manquement sur un des critères.","Saisir OUI ou NON ","(saisie automatique à corriger selon les modalités d'instruction)","Copier coller le montant présent sur la convention.","A renseigner par l'instructeur sur la base de l'annexe financière de la dernière demande de paiement. En cas de première demande de paiement, remplir 0 dans la cellule.","(saisie automatique à corriger selon les modalités d'instruction)","(saisie automatique)","Calcul automatique\nSera utile pour renseigner la colonne \"montant des dépenses retenues cumulées au titre des précédentes DP\" de la prochaine DP ","(une observation est à apporter par le Service Instructeur pour toute correction apportée et/ou toute révision de la dépense lors de la phase d'instruction.\nEx: motif d'inéligibilité, révision du poste de dépense, correction du numéro de devis, absence de devis opposable…)"]
["Exemple",null,null,"Plantations pérennes",1,1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"$f":"IF(G5=0,\"\",H5/G5)","v":{"v":8,"d":"8.00"}},"OUI","Simple","2025-01-01",{"$f":"IFERROR(IF(J5=\"NON\",IF(K5=\"Simple\",2976*IF(I5>=8,1,I5/8),IF(K5=\"Double\",4114*IF(I5>=15,1,I5/15),\"\")),IF(J5=\"OUI\",IF(K5=\"Simple\",3650*IF(I5>=8,1,I5/8),IF(K5=\"Double\",4554*IF(I5>=15,1,I5/15),\"\")),\"\"))*G5,\"\")","v":{"v":3650,"d":"3,650.00 €"}},"XX",{"$nulls":3},"Plantations pérennes",1,1,{"$f":"IF(G5=\"\",\"\",G5)","v":{"v":1,"d":"1.00"}},{"v":8,"d":"8.00"},{"$f":"IF(U5=0,\"\",V5/U5)","v":{"v":8,"d":"8.00"}},{"$f":"IF(J5=\"\",\"\",J5)","v":"OUI"},{"$f":"IF(K5=\"\",\"\",K5)","v":"Simple"},"2025-01-01","Oui","Oui","Oui",{"$f":"IFERROR(\n    IF(X5=\"NON\",\n        IF(Y5=\"Simple\",\n            2976 * IF(W5>=8, 1, W5/8),\n            IF(Y5=\"Double\",\n                4114 * IF(W5>=15, 1, W5/15),\n                \"\"\n            )\n        ),\n        IF(X5=\"OUI\",\n            IF(Y5=\"Simple\",\n                3650 * IF(W5>=8, 1, W5/8),\n                IF(Y5=\"Double\",\n                    4554 * IF(W5>=15, 1, W5/15),\n                    \"\"\n                )\n            ),\n            \"\"\n        )\n    ) * U5,\n\"\")","v":{"v":3650,"d":"3,650.00 €"}},{"v":3650,"d":"3,650.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(U5=\"\",\"\",IF(AB5=\"Non\",0,IF(AA5=\"Non\",0,IF(AC5=\"Non\",0,IF(AD5<=(AE5-AF5),AD5,IF(AD5>(AE5-AF5),(AE5-AF5)))))))","v":{"v":3650,"d":"3,650.00 €"}},{"$f":"IF(OR(AD5=\"\",AG5=\"\"),\"\",ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(AD5,CHAR(160),\"\"))),0),2)-ROUND(IFERROR(VALUE(TRIM(SUBSTITUTE(AG5,CHAR(160),\"\"))),0),2))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(AND(AF5=\"\",AG5=\"\"),\"\",AG5+AF5)","v":{"v":3650,"d":"3,650.00 €"}}]
[1,{"$nulls":7},{"$f":"IF(G6=0,\"\",H6/G6)","v":""},{"$nulls":3},{"$f":"IFERROR(IF(J6=\"NON\",IF(K6=\"Simple\",2976*IF(I6>=8,1,I6/8),IF(K6=\"Double\",4114*IF(I6>=15,1,I6/15),\"\")),IF(J6=\"OUI\",IF(K6=\"Simple\",3650*IF(I6>=8,1,I6/8),IF(K6=\"Double\",4554*IF(I6>=15,1,I6/15),\"\")),\"\"))*G6,\"\")","v":""},null,null,{"$f":"IF(B6=\"\",\"\",B6)","v":""},"",{"$f":"IF(D6=\"\",\"\",D6)","v":""},{"$f":"IF(E6=\"\",\"\",E6)","v":""},{"$f":"IF(F6=\"\",\"\",F6)","v":""},{"$f":"IF(Y6=\"Simple\",IF(I6<8,V6/8,G6),IF(I6<15,V6/15,G6))","v":{"v":0,"d":"0.00"}},{"$f":"IF(H6=\"\",\"\",H6)","v":""},{"$f":"IF(U6=0,\"\",V6/U6)","v":""},"","",{"$f":"IF(L6=\"\",\"\",L6)","v":""},{"$nulls":3},{"$f":"IFERROR(\n    _xlfn.IFS(\n        X6=\"NON\",\n            _xlfn.IFS(\n                Y6=\"Simple\", 2976 * U6,\n                Y6=\"Double\", 4114 * U6\n            ),\n        X6=\"OUI\",\n            _xlfn.IFS(\n                Y6=\"Simple\", 3650 * U6,\n                Y6=\"Double\", 4554 * U6\n            )\n    ),\n\"\")","v":""},null,null,{"$f":"IF(\n    AND(U6<>\"\", AB6=\"Oui\", AA6=\"Oui\", AC6=\"Oui\"),\n    MIN(AD6, AE6-AF6),\n    0\n)","v":{"v":0,"d":"0.00 €"}},"",{"v":0,"d":"0.00 €"}]
[2,{"$nulls":7},{"$f":"IF(G7=0,\"\",H7/G7)","v":""},{"$nulls":3},{"$f":"IFERROR(IF(J7=\"NON\",IF(K7=\"Simple\",2976*IF(I7>=8,1,I7/8),IF(K7=\"Double\",4114*IF(I7>=15,1,I7/15),\"\")),IF(J7=\"OUI\",IF(K7=\"Simple\",3650*IF(I7>=8,1,I7/8),IF(K7=\"Double\",4554*IF(I7>=15,1,I7/15),\"\")),\"\"))*G7,\"\")","v":""},null,null,"","","","","",{"$f":"IF(Y7=\"Simple\",IF(I7<8,V7/8,G7),IF(I7<15,V7/15,G7))","v":{"v":0,"d":"0.00"}},"",{"$f":"IF(U7=0,\"\",V7/U7)","v":""},"","","",{"$nulls":3},{"$f":"IFERROR(\n    _xlfn.IFS(\n        X7=\"NON\",\n            _xlfn.IFS(\n                Y7=\"Simple\", 2976 * U7,\n                Y7=\"Double\", 4114 * U7\n            ),\n        X7=\"OUI\",\n            _xlfn.IFS(\n                Y7=\"Simple\", 3650 * U7,\n                Y7=\"Double\", 4554 * U7\n            )\n    ),\n\"\")","v":""},null,null,{"$f":"IF(\n    AND(U7<>\"\", AB7=\"Oui\", AA7=\"Oui\", AC7=\"Oui\"),\n    MIN(AD7, AE7-AF7),\n    0\n)","v":{"v":0,"d":"0.00 €"}},"",{"v":0,"d":"0.00 €"}]
[3,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[4,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[5,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[6,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[7,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[8,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[9,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[10,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[11,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[12,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[13,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[14,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[15,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[16,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[17,{"$nulls":7},"",{"$nulls":3},"",null,null,{"$f":"IF(B22=\"\",\"\",B22)","v":""},"","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[18,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[19,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[20,{"$nulls":7},"",{"$nulls":3},"",null,null,"","","","","",{"v":0,"d":"0.00"},"","","","","",{"$nulls":3},"",null,null,{"v":0,"d":"0.00 €"},"",{"v":0,"d":"0.00 €"}]
[{"$nulls":10},"Total présenté",null,{"$f":"SUM(M6:M25)","v":{"v":0,"d":"0.00 €"}},{"$nulls":15},"Total",{"$f":"SUM(AD6:AD25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AE6:AE25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AF6:AF25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AG6:AG25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AH6:AH25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(AI6:AI25)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Liste des MP","index":10,"n_rows":2,"n_cols":11,"rows_kept":2,"merged":[[0,0,0,4],[0,5,0,10]]}
["Partie à remplir par le bénéficiaire - liste des marchés publics relatifs aux dépenses du projet",{"$nulls":4},"Partie réservée à l'administration  - liste des marchés publics relatifs aux dépenses du projet"]
["Nom du marché","Pièces transmises de marchés ","Date du marché","Montant HT du marché ","Le marché est-il lié à une dépense couverte par une OCS ?","Nom du marché","Pièces transmises de marchés ","Date du marché","Montant HT du marché ","Le marché est-il lié à une dépense couverte par une OCS ?","Irrégularité identifiée à la suite du contrôle de la cellule marchés publics"]

{"sheet":"Syn DP Bénéficiaire","index":11,"n_rows":39,"n_cols":10,"rows_kept":39,"merged":[[0,0,0,17],[2,0,2,9],[3,0,3,9],[4,0,4,2],[4,3,4,9],[9,1,9,6],[16,0,16,8],[17,0,17,6],[18,0,18,2],[18,3,18,6],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,5,20,5],[19,6,20,6],[33,1,33,7],[34,1,34,4],[34,5,34,7],[36,1,36,3]]}
["Tableau récapitulatif des dépenses prévisionnelles de l'opération au titre de cette DP\n(données à titre informatif ne valant ni promesse d'attribution de l'aide, ni contractualisation des montants indiqués)"]
[]
["ÉTAPE 1. CONTRÔLE DES MONTANTS PRÉSENTÉS\nVérifiez que les informations ci-dessous sont conformes aux dépenses présentées dans les onglets précédents"]
["SYNTHÈSE DES DÉPENSES PRÉSENTÉES"]
["Synthèse de l'opération\n(donnée à titre informatif ne valant ni promesse d'attribution de l'aide, ni contractualisation des montants indiqués)",null,null,"Ventilation par poste de dépense"]
["Montant présenté HT","Montant présenté TVA","Montant présenté TTC","Investissements","Frais généraux","Contributions en nature ","Amortissement","Taux forfaitaire personnel + autoconstruction","Coût unitaire bananes","Coût unitaire cannes à sucre"]
[{"$f":"'1-Investissements'!M109+'2-Frais généraux'!L105+'3-Contributions en nature'!I106+'4-Amortissement'!F106+'5-Tx forf personnel+autoconst'!E15+'6-Coût unitaire bananes'!L26+'7-Coût unitaire cannes à sucre'!M26","v":0},{"$f":"'1-Investissements'!N109+'2-Frais généraux'!M105","v":0},{"$f":"A7+B7","v":0},{"$f":"'1-Investissements'!O109","v":{"v":0,"d":"0.00 €"}},{"$f":"'2-Frais généraux'!N105","v":{"v":0,"d":"0.00 €"}},{"$f":"'3-Contributions en nature'!I106","v":{"v":0,"d":"0.00 €"}},{"$f":"'4-Amortissement'!F106","v":{"v":0,"d":"0.00 €"}},{"$f":"'5-Tx forf personnel+autoconst'!E15","v":{"v":0,"d":"0.00 €"}},{"$f":"'6-Coût unitaire bananes'!L26","v":{"v":0,"d":"0.00 €"}},{"$f":"'7-Coût unitaire cannes à sucre'!M26","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[null,"ÉTAPE 2 :  COMPLÉTER LES INFORMATIONS LIEES A D'AUTRES EVENTUELS FINANCEURS CONVENTIONNES\nCompléter les cellules blanches ci-dessous. Le cas échéant, ajouter autant de lignes que de financeurs publics ou privés existants. "]
[null,"Montant du financement public autre que FEADER/Région versé au titre de la DP, le cas échéant","Identité du/des financeur(s) public(s) autre(s) que FEADER/Région, justificatif présenté","Pièce justificative permettant d'attester de la réception du financement  ?","Montant du financement privé versé au titre de cette DP le cas échéant\n\nPour les opérations bénéficiant d'une aide venant d'un organisme privé, par exemple des donations ou du mécénat, saisir ce montant","Identité du/des financeur(s) privé(s)","Pièce justificative permettant d'attester de la réception du financement  ?"]
[]
[]
[]
[null,{"$f":"SUM(B12:B14)","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"SUM(E12:E14)","v":{"v":0,"d":"0.00 €"}}]
[]
["Attention : L'instructeur instruira les dépenses présentées et appliquera d'autres règles financières (les règles de non-profit et de contrôle des contributions en nature au cumulé des dépenses, des contributions en nature et des financeurs privés déjà présentés).\nCette opération est susceptible de faire diminuer le montant d'aide publique qui vous sera versé par rapport à celui que vous présentez ci-dessus.\nPour toute information complémentaire, rapprochez-vous du service instructeur via la messagerie d'EUROPAC."]
["ÉTAPE 3 : VENTILATION DES DEPENSES EN RESSOURCES\n Ces informations sont présentées à titre informatif et seront soumises à une instruction pouvant modifier les données présentées. "]
["Synthèse de l'opération présentée par  type d'action",null,null,"Détail des montants demandés à la demande de paiement par type d'action\n(données à titre informatif ne valant pas remboursement des dépenses présentées)"]
["Type d'action","Dépenses présentées","Part du type d'action sur le total des dépenses présentées (en %)","Taux d'Aide Publique (TAP) réglementaire du dispositif","Montant d'aide publique prévisionnel","Montant d'aide FEADER","Montant des cofinanceurs"]
[{"$nulls":3},"Saisir dans cette colonne le TAP applicable à chaque type d'action.","TAP réglementaire du dispositif x Dépenses présentées"]
["Modernisation installations / mécanisation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A22)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A22)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A22)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A22)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A22)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A22)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A22)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(B22=0,0,B22/$B$31)","v":{"v":0,"d":"0.00%"}},null,{"$f":"D22*B22","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C22=0,0,ROUNDDOWN(E22*0.85,2))","v":{"v":0,"d":"0.00 €"}},{"$f":"E22-F22","v":{"v":0,"d":"0.00 €"}}]
["Construction / aménagement bâtiments",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A23)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A23)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A23)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A23)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A23)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A23)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A23)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(B23=0,0,B23/$B$31)","v":{"v":0,"d":"0.00%"}},null,{"$f":"D23*B23","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C23=0,0,ROUNDDOWN(E23*0.85,2))","v":{"v":0,"d":"0.00 €"}},{"$f":"E23-F23","v":{"v":0,"d":"0.00 €"}}]
["Plantations pérennes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A24)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A24)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A24)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A24)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A24)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A24)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A24)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Irrigation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A25)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A25)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A25)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A25)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A25)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A25)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A25)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Performance énergétique",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A26)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A26)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A26)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A26)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A26)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A26)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A26)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Transformation / Commercialisation",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A27)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A27)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A27)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A27)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A27)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A27)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A27)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Amélioration foncière",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A28)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A28)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A28)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A28)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A28)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A28)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A28)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Diversification des activités - gîtes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A29)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A29)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A29)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A29)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A29)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A29)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A29)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Diversification des activités - hors gîtes",{"$f":"SUMIFS('1-Investissements'!$O$10:$O$108,'1-Investissements'!$E$10:$E$108,'Syn DP Bénéficiaire'!A30)+SUMIFS('2-Frais généraux'!$N$6:$N$104,'2-Frais généraux'!$D$6:$D$104,'Syn DP Bénéficiaire'!A30)+SUMIFS('3-Contributions en nature'!$I$6:$I$105,'3-Contributions en nature'!$C$6:$C$105,'Syn DP Bénéficiaire'!A30)+SUMIFS('4-Amortissement'!$F$6:$F$105,'4-Amortissement'!$D$6:$D$105,'Syn DP Bénéficiaire'!A30)+SUMIFS('5-Tx forf personnel+autoconst'!$E$6:$E$14,'5-Tx forf personnel+autoconst'!$B$6:$B$14,'Syn DP Bénéficiaire'!A30)+SUMIFS('6-Coût unitaire bananes'!$L$6:$L$25,'6-Coût unitaire bananes'!$D$6:$D$25,'Syn DP Bénéficiaire'!A30)+SUMIFS('7-Coût unitaire cannes à sucre'!$M$6:$M$25,'7-Coût unitaire cannes à sucre'!$D$6:$D$25,'Syn DP Bénéficiaire'!A30)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
["Total des dépenses",{"$f":"SUM(B22:B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C22:C30)","v":{"v":0,"d":"0%"}},null,{"$f":"SUM(E22:E30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F22:F30)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[]
[]
[null,"ÉTAPE 4 : SAISIR SUR EUROPAC\nReportez les informations financières ci-dessous dans l'onglet « Dépenses prévisionnelles » de Europac"]
[null,"Total des dépenses et des ressources",{"$nulls":3},"Montant d'aide publique nationale et FEADER"]
[null,"Total général = coût global du projet",{"$f":"B31","v":{"v":0,"d":"0.00 €"}},"Total des subventions demandées",{"$f":"F37+G37","v":{"v":0,"d":"0.00 €"}},"Montant FEADER","Région",{"$f":"C12","v":0}]
[null,"Montant des financeurs privés",{"$nulls":3},{"$f":"F31","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(G31>=H37,G31-H37,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"B12","v":{"v":0,"d":"0.00 €"}}]
[null,{"$f":"F12","v":0},{"$f":"F13","v":0},{"$f":"F14","v":0},"Apport du porteur de projet (autofinancement et emprunt)"]
[null,{"$f":"E12","v":{"v":0,"d":"0.00 €"}},{"$f":"E13","v":{"v":0,"d":"0.00 €"}},{"$f":"E14","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C36-F37-G37-H37-B39-C39-D39>=0,C36-F37-G37-H37-B39-C39-D39,0)","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Demande Avance","index":12,"n_rows":19,"n_cols":8,"rows_kept":19,"merged":[[1,1,1,4],[2,1,2,3],[15,1,15,7],[16,1,16,4],[16,5,16,7],[18,1,18,3]]}
[]
[null,"Partie à remplir par le bénéficiaire"]
[null,"Versements des financeurs publics autres que Région au titre de l'avance (financeur en dissocié)",null,null,"Montant d'aide publique demandé au titre de l'avance"]
[null,"Nom du financeur","Montant","Pièce justificative permettant d'attester de la réception du financement  ?","Informations à remplir concernant votre demande d'avance"]
[]
[null,null,{"$f":"SUM(C5:C5)","v":{"v":0,"d":"0.00 €"}},null,","]
[]
[]
[null,"Calcul montant de subvention"]
[null,"Nom du financeur","Montant Part nationale cofinancée","Montant FEADER "]
[null,{"$f":"B5","v":0},{"$f":"C5","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(G3=\"KO\",C6,ROUNDDOWN(C11*0.85/0.15,2))","v":{"v":0,"d":"0.00 €"}}]
[null,"Région",{"$f":"E5-D13-C11","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUNDDOWN((E5-D11-C11)*0.85,2)","v":{"v":0,"d":"0.00 €"}}]
[null,"Total",{"$f":"SUM(C11:C12)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D11:D12)","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[null,"SAISIR SUR EUROPAC\nReportez les informations financières ci-dessous dans l'onglet « Dépenses prévisionnelles » de Europac"]
[null,"Total des dépenses et des ressources",{"$nulls":3},"Montant d'aide publique nationale et FEADER"]
[null,"Total général = coût global du projet",{"v":0,"d":"0.00 €"},"Total des subventions demandées",{"$f":"E5","v":{"v":0,"d":"0.00 €"}},"Montant FEADER","Région",{"$f":"B5","v":0}]
[{"$nulls":5},{"$f":"D13","v":{"v":0,"d":"0.00 €"}},{"$f":"C12","v":{"v":0,"d":"0.00 €"}},{"$f":"C11","v":{"v":0,"d":"0.00 €"}}]

{"sheet":"Avance_Instructeur","index":13,"n_rows":30,"n_cols":8,"rows_kept":30,"hidden":true,"merged":[[1,1,1,4],[2,1,2,3],[8,1,8,7],[9,1,9,4],[9,5,9,6]]}
[]
[null,"Reprise des données complétées par le bénéficiaire"]
[null,"Versements des financeurs publics autres que Région au titre de l'avance (financeur en dissocié)",null,null,"Montant d'aide publique demandé au titre de l'avance"]
[null,"Nom du financeur","Montant","Pièce justificative permettant d'attester de la réception du financement  ?","Informations à remplir concernant votre demande d'avance"]
[null,{"$f":"'Demande Avance'!B5","v":0},{"$f":"'Demande Avance'!C5","v":0},{"$f":"'Demande Avance'!D5","v":0},{"$f":"'Demande Avance'!E5","v":0}]
[null,null,{"$f":"SUM(C5:C5)","v":{"v":0,"d":"0.00 €"}},null,","]
[]
[]
[null,"Partie à remplir par l'instructeur"]
[null,"Financeurs en dissociés",{"$nulls":3},"Montants d'aide Région et FEADER conventionnés",null,"Total"]
[null,"Nom du financeur","Montant avance versé","Pièce justificative permettant d'attester de la réception du financement  ?","Montant conventionné financeur public externe","Montant Région","Montant FEADER","Montant de subvention"]
[null,{"$f":"B5","v":{"v":0,"d":"0.00 €"}},{"$f":"C5","v":0},null,{"$f":"'Tableau de bord-Instructeur'!C6","v":0},{"$f":"'Tableau de bord-Instructeur'!C7","v":0},{"$f":"'Tableau de bord-Instructeur'!C8","v":0},{"$f":"E13+F12+G12","v":0}]
[null,null,{"$f":"SUM(C12:C12)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(E12:E12)","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[null,"Calcul du montant de l'avance",{"$nulls":4},"Contrôle"]
[null,"Taux maximal de l'avance \nTaux maximal règlementaire de 50%, pouvant être diminué par certains régimes d'aide d'État.","Montant Maximum théorique Avance\nMinimum entre montant demandé par le bénéficiaire et 50% du montant conventionné","Montant financement public externe","Montant Région","Montant FEADER  ","Vérification avec prise en compte montant VE total et Montant FEADER"]
[null,{"v":0.5,"d":"50%"},{"$f":"IF(OR('Tableau de bord-Instructeur'!C19<>\"Avance\",E5=0),0,MIN(E5,IF(C12>ROUND(H12*B18,2),0,ROUND(H12*B18,2))))","v":{"v":0,"d":"0.00 €"}},{"$f":"MIN(C13,C18*0.15)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(D18<C18*0.15,MIN(C18-D18-F18,F12),0)","v":{"v":0,"d":"0.00 €"}},{"$f":"MIN(ROUNDDOWN(C18*0.85,2),G12)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF((F18+E18+C5)<=C18,\"OK\",\"KO\")","v":"OK"}]
[]
[null,"Résultat après contrôle","Montant FEADER","Montant financement public externe","Montant mobilisable aux DP suivantes"]
[null,"Ajustement du montant si résultat KO",{"$f":"IF(C12>=C18,0,IF(G18=\"KO\",C18-C13,\"\"))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C21=\"\",\"\",ROUNDUP(C21*0.15/0.85,2))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(D21=\"\",\"\",C13-D21)","v":{"v":0,"d":"0.00 €"}}]
[]
[]
[null,"Montants d'avance à saisir dans EUROPAC"]
[null,"Nom du financeur","Montant Part nationale cofinancée","Montant FEADER ","Contrôle Taux de cofi"]
[null,{"$f":"B12","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(G18=\"KO\",D21,ROUNDUP(D18,2))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(G18=\"KO\",C21,ROUNDDOWN(C26*0.85/0.15,2))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(D26=ROUNDDOWN((C26+D26)*0.85,2),\"OK\",\"KO\")","v":"OK"}]
[null,"Région",{"$f":"IF(G18=\"OK\",E18,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUNDDOWN(C27*0.85/0.15,2)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(D27=ROUNDDOWN((C27+D27)*0.85,2),\"OK\",\"KO\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C26:C27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D26:D27)","v":{"v":0,"d":"0.00 €"}}]
[]
[null,"Montant d'avance retenu",{"$f":"C28+D28","v":{"v":0,"d":"0.00 €"}}]

{"sheet":" DÉPENSES-Syn DP Instruct","index":14,"n_rows":79,"n_cols":13,"rows_kept":79,"hidden":true,"merged":[[5,11,5,12],[8,1,8,3],[8,4,8,5],[8,6,8,8],[8,11,8,12],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,9,5],[9,6,9,8],[11,11,11,12],[25,34,25,37],[26,35,27,35]]}
[null,"Partie réservée à l'administration - Récapitulatif des dépenses de l'opération retenues au titre de cette DP"]
[]
[]
[null,"Stade de la DP traitée"]
[null,{"$f":"Accueil!H19","v":"CHOISIR LA NATURE DE LA DEMANDE DE PAIEMENT"}]
[{"$nulls":11},"Plafond achat terrain et Frais Généraux applicable au Solde"]
[{"$nulls":11},"Montant éligibles hors achat de terrain et hors FG",{"$f":"G12+G15+G16+G17+G18+G19","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":11},"Plafond global 20%",{"$f":"M7/0.8-M7","v":{"v":0,"d":"0.00 €"}}]
[null,"3. RENSEIGNEMENT DU MONTANT CONVENTIONNÉ ET DU MONTANT ÉLIGIBLE RETENU CUMULÉ au titre des DP précédentes",null,null,"4. POSTE DE DÉPENSE : MONTANT DES DÉPENSES ÉLIGIBLES RETENUES",null,"RIF au Solde",{"$nulls":4},"Répartition du montant plafond"]
[null,"Postes de dépense","Montant des dépenses conventionnées\nA renseigner par l'instructeur sur la base de l'annexe financière à la convention ou au dernier avenant en vigueur","Montant des dépenses éligibles retenues cumulées au titre des précédentes DP\n(Recopier les valeurs des cellules F12 à F19 de la DP précédente)","Détermination du montant éligible cumulé",null,"Détermination du montant éligible après application des RIF au Solde\nPlafond et Compensation de 15% entre les postes de dépenses",{"$nulls":4},"Montant plafond FG",{"$f":"$M$8*10/20","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"Montant des dépenses éligibles de la DP\n(Montants après instruction dans les onglets par poste de dépense)","Montant dépenses éligibles cumulées","Plafond Dépenses\n(Plafonnement de G13 et G14)","Plafond Compensation 15%","Calcul intermédiaire","Montant éligible retenu pour montant subvention",null,"Montant plafond Achat de terrain",{"$f":"$M$8*10/20","v":{"v":0,"d":"0.00 €"}}]
[null,"Investissements hors achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs",null,null,{"$f":"SUMIF('1-Investissements'!T10:T108,\"Non\",'1-Investissements'!AM10:AM108)","v":{"v":0,"d":"0.00 €"}},{"$f":"D12+E12","v":{"v":0,"d":"0.00 €"}},{"$f":"F12","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(OR($B$5=\"Acompte\",$B$5=\"Avance\"),G12,MIN(G12,C12*1.15))","v":{"v":0,"d":"0.00 €"}},{"$f":"MIN(G12,H12)-C12","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($B$5=\"Avance\",0,IF($B$5=\"Acompte\",MIN(F12,C12),IF($I$20<0,H12,H12-H12/$H$20*$I$20)))","v":{"$error":"#DIV/0!"}},null,"Montants plafonnés intermédiaires"]
[null,"Investissement en achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ",null,null,{"$f":"SUMIF('1-Investissements'!T10:T108,\"Oui\",'1-Investissements'!AM10:AM108)","v":{"v":0,"d":"0.00 €"}},{"$f":"D13+E13","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(OR(B5=\"Acompte\",B5=\"Avance\"),F13,IF(F14>=M13,M14,F13/0.9-F13))","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(OR($B$5=\"Acompte\",$B$5=\"Avance\"),G13,MIN(G13,C13*1.15))","v":{"v":0,"d":"0.00 €"}},{"$f":"MIN(G13,H13)-C13","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($B$5=\"Avance\",0,IF($B$5=\"Acompte\",MIN(F13,C13),IF($I$20<0,H13,H13-H13/$H$20*$I$20)))","v":{"$error":"#DIV/0!"}},null,"Plaf. Interm. FG",{"$f":"MIN(M10,F14)","v":{"v":0,"d":"0.00 €"}}]
[null,"Frais généraux ",null,null,{"$f":"'2-Frais généraux'!AK105","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"IF(OR(B5=\"Acompte\",B5=\"Avance\"),F14,IF(F13>=M14,M13,F14/0.9-F14))","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"},null,"Plaf. Interm. Terrain",{"$f":"MIN(M11,F13)","v":{"v":0,"d":"0.00 €"}}]
[null,"Contributions en nature ",null,null,{"$f":"'3-Contributions en nature'!V106","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"F15","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"}]
[null,"Amortissement",null,null,{"$f":"'4-Amortissement'!T106","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"}]
[null,"Taux forfaitaire personnel + autoconstruction",null,null,{"$f":"'5-Tx forf personnel+autoconst'!M15","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"}]
[null,"Coût unitaire bananes",null,null,{"$f":"'6-Coût unitaire bananes'!AE26","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"}]
[null,"Coût unitaire cannes à sucre",null,null,{"$f":"'7-Coût unitaire cannes à sucre'!AG26","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"SUM(C12:C19)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(F12:F19)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(G12:G19)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"ROUND(SUM(J12:J19),2)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Montants instruits par Action à la DP"]
[null,null,"Investissements hors achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs","Investissement en achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ","Frais généraux ","Contributions en nature ","Amortissement","Taux forfaitaire personnel + autoconstruction","Coût unitaire bananes","Coût unitaire cannes à sucre","Total"]
[null,"Modernisation installations / mécanisation",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B25,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B25,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B25)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C25:J25)","v":{"v":0,"d":"0.00 €"}}]
[null,"Construction / aménagement bâtiments",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B26,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B26,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B26)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(C26:J26)","v":{"v":0,"d":"0.00 €"}}]
[null,"Plantations pérennes",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B27,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B27,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B27)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B27)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Irrigation",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B28,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B28,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B28)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B28)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Performance énergétique",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B29,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B29,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B29)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B29)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Transformation / Commercialisation",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B30,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B30,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B30)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B30)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Amélioration foncière",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B31,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B31,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B31)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B31)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B31)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B31)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B31)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B31)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - gîtes ruraux",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B32,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B32,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B32)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B32)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B32)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B32)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B32)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B32)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - hors gîtes ruraux",{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B33,'1-Investissements'!$T$10:$T$108,\"Non\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('1-Investissements'!$AM$10:$AM$108,'1-Investissements'!$V$10:$V$108,B33,'1-Investissements'!$T$10:$T$108,\"Oui\")","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('2-Frais généraux'!$AK$6:$AK$104,'2-Frais généraux'!$T$6:$T$104,B33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('3-Contributions en nature'!$V$6:$V$105,'3-Contributions en nature'!$L$6:$L$105,B33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('4-Amortissement'!$T$6:$T$105,'4-Amortissement'!$L$6:$L$105,B33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('5-Tx forf personnel+autoconst'!$M$6:$M$14,'5-Tx forf personnel+autoconst'!$G$6:$G$14,B33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('6-Coût unitaire bananes'!$AE$6:$AE$25,'6-Coût unitaire bananes'!$Q$6:$Q$25,B33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIFS('7-Coût unitaire cannes à sucre'!$AG$6:$AG$25,'7-Coût unitaire cannes à sucre'!$R$6:$R$25,B33)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[null,"Total",{"$f":"SUM(C25:C33)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D25:D33)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[]
[null,"Montants instruits de la DP précédente Reciopier le tableau \"Montants instruits en cumulés\" de la DP précédente"]
[null,null,"Investissements hors achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs","Investissement en achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ","Frais généraux ","Contributions en nature ","Amortissement","Taux forfaitaire personnel + autoconstruction","Coût unitaire bananes","Coût unitaire cannes à sucre","Total"]
[null,"Modernisation installations / mécanisation",{"$nulls":8},{"$f":"SUM(C39:J39)","v":{"v":0,"d":"0.00 €"}}]
[null,"Construction / aménagement bâtiments",{"$nulls":8},{"$f":"SUM(C40:J40)","v":{"v":0,"d":"0.00 €"}}]
[null,"Plantations pérennes",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Irrigation",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Performance énergétique",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Transformation / Commercialisation",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Amélioration foncière",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - gîtes ruraux",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - hors gîtes ruraux",{"$nulls":8},{"v":0,"d":"0.00 €"}]
[null,"Total",{"$f":"SUM(C39:C47)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D39:D47)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[]
[null,"Montants instruits en cumulés"]
[null,null,"Investissements hors achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs","Investissement en achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ","Frais généraux ","Contributions en nature ","Amortissement","Taux forfaitaire personnel + autoconstruction","Coût unitaire bananes","Coût unitaire cannes à sucre","Total"]
[null,"Modernisation installations / mécanisation",{"$f":"C39+C25","v":{"v":0,"d":"0.00 €"}},{"$f":"D39+D25","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(C53:J53)","v":{"v":0,"d":"0.00 €"}}]
[null,"Construction / aménagement bâtiments",{"$f":"C40+C26","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(C54:J54)","v":{"v":0,"d":"0.00 €"}}]
[null,"Plantations pérennes",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Irrigation",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Performance énergétique",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Transformation / Commercialisation",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Amélioration foncière",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - gîtes ruraux",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Diversification des activités - hors gîtes ruraux",{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"Total",{"$f":"SUM(C53:C61)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D53:D61)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[]
[null,"Montants dépenses plafonnés et Montant de subvention calculé"]
[null,null,"Investissements hors achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs","Investissement en achat de terrain hors achat à des fins de protection de l’environnement et de préservation des sols riches en carbone, ou terrain pour de jeunes agriculteurs acquis au moyen d’instrument financier ","Frais généraux ","Contributions en nature ","Amortissement","Taux forfaitaire personnel + autoconstruction","Coût unitaire bananes","Coût unitaire cannes à sucre","Total","TAP","Montant subvention"]
[null,"Modernisation installations / mécanisation",{"$f":"IF(C$62=$J$12,C53,C53/C$62*$J$12)","v":{"$error":"#DIV/0!"}},{"$f":"IF(D$62=$J$13,D53,D53/D$62*$J$13)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E$62=$J$14,E53,E53/E$62*$J$14)","v":{"$error":"#DIV/0!"}},{"$f":"IF(F$62=$J$15,F53,F53/F$62*$J$15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(G$62=$J$16,G53,G53/G$62*$J$16)","v":{"$error":"#DIV/0!"}},{"$f":"IF(H$62=$J$17,H53,H53/H$62*$J$17)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I$62=$J$18,I53,I53/I$62*$J$18)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J$62=$J$19,J53,J53/J$62*$J$19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C67:J67)","v":{"$error":"#DIV/0!"}},{"v":0.8,"d":"80%"},{"$f":"K67*L67","v":{"$error":"#DIV/0!"}}]
[null,"Construction / aménagement bâtiments",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$f":"K68*L68","v":{"$error":"#DIV/0!"}}]
[null,"Plantations pérennes",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Irrigation",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Performance énergétique",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Transformation / Commercialisation",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Amélioration foncière",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Diversification des activités - gîtes ruraux",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Diversification des activités - hors gîtes ruraux",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"v":0.8,"d":"80%"},{"$error":"#DIV/0!"}]
[null,"Total",{"$f":"SUM(C67:C75)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D67:D75)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"ROUND(SUM(C76:J76),2)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(SUM(M67:M75),2)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Contrôle saisie des montants",{"$f":"IF(K76=J20,\"OK\",\"Il convient de revoir les montants recopier de la DP précédente\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"RESSOURCES-Syn DP Instruc","index":15,"n_rows":15,"n_cols":9,"rows_kept":15,"hidden":true,"merged":[[0,1,0,10],[1,1,1,10]]}
[null,"Partie réservée à l'administration - Récapitulatif des ressources de l'opération retenues au titre de cette DP"]
[]
[]
[]
[null,"Identification du financement externe privé"]
[null,"Identité des financeurs privés\n\nLes justificatifs sont obligatoires ","Montant de financement privé conventionné dans la DJ ou le dernier avenant\nAttention, si un financeur non conventionné verse au porteur un montant au titre du projet, il faut impérativement faire un avenant","Montant de financement privé déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes","Montant de financement privé versé au titre de la DP selon le porteur","Montant de financement privé versé et instruit par l'instructeur au titre de la DP\nAttention, si le montant versé par le financeur porte sur un périmètre différent du projet éligible au FEADER, il ne faut renseigner ici que le montant correspondant au périmètre du projet éligible au FEADER - conformément à la convention","Commentaire de l'instructeur\nCompléter ici les éventuels commentaires concernant le contrôle du périmètre du financement par rapport à celui de l'opération FEADER + les événetuelles différences avec le montant conventionné","Montant de financement privé déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes (y compris cette DP)\nSera utile pour renseigner la colonne \"Montant de financement privé déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes\" de la prochaine DP ","Contrôle"]
[null,{"$f":"'Syn DP Bénéficiaire'!F12","v":0},null,null,{"$f":"'Syn DP Bénéficiaire'!E12","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"F7+D7","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C7<H7, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]
[null,{"$f":"'Syn DP Bénéficiaire'!F13","v":0},null,null,{"$f":"'Syn DP Bénéficiaire'!E13","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"F8+D8","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C8<H8, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]
[null,{"$f":"'Syn DP Bénéficiaire'!F14","v":0},null,null,{"$f":"'Syn DP Bénéficiaire'!E14","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"F9+D9","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C9<H9, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C7:C9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D7:D9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E7:E9)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F7:F9)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(H7:H9)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C10<H10, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]
[]
[null,"Identification du financement externe public"]
[null,"Identité des financeurs public\n\nLes justificatifs sont obligatoires ","Montant de financement public conventionné dans la DJ ou le dernier avenant\nAttention, si un financeur non conventionné verse au porteur un montant au titre du projet, il faut impérativement faire un avenant","Montant de financement public déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes","Montant de financement public versé au titre de la DP selon le porteur","Montant de financement public versé et instruit par l'instructeur au titre de la DP\nAttention, si le montant versé par le financeur porte sur un périmètre différent du projet éligible au FEADER, il ne faut renseigner ici que le montant correspondant au périmètre du projet éligible au FEADER - conformément à la convention","Commentaire de l'instructeur\nCompléter ici les éventuels commentaires concernant le contrôle du périmètre du financement par rapport à celui de l'opération FEADER + les événetuelles différences avec le montant conventionné","Montant de financement public déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes (y compris cette DP)\nSera utile pour renseigner la colonne \"Montant de financement privé déjà versé au porteur et instruit par l'instructeur, cumulé au titre des DP précédentes\" de la prochaine DP ","Contrôle"]
[null,{"$f":"'Syn DP Bénéficiaire'!C12","v":0},null,null,{"$f":"'Syn DP Bénéficiaire'!B12","v":{"v":0,"d":"0.00 €"}},null,null,{"$f":"F14+D14","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C14<H14, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]
[null,"Total",{"$f":"SUM(C14:C14)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(D14:D14)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(E14:E14)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(F14:F14)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(H14:H14)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(C15<H15, \"KO : Il y a un surfinancement, il faut faire un avenant\",\"OK\")","v":"OK"}]

{"sheet":"Tableau de bord-Instructeur","index":16,"n_rows":42,"n_cols":34,"rows_kept":42,"hidden":true,"merged":[[1,1,1,2],[1,4,1,5],[2,4,2,5],[10,6,10,7],[11,8,11,10],[12,1,12,2],[12,5,12,7],[12,8,12,10],[12,11,12,13],[12,17,12,20],[12,23,12,26],[12,29,12,32],[18,11,18,14],[19,4,19,7],[20,5,20,7],[24,1,24,2],[25,1,25,2],[26,1,26,2],[29,5,29,8],[31,4,31,7],[31,8,31,10],[31,11,31,13],[38,4,38,5],[38,6,38,10],[39,4,39,5],[39,6,39,10],[40,4,40,5],[40,6,40,10],[41,4,41,5],[41,6,41,10]]}
[]
[null,"Montants conventionnés\nà compléter",null,null,"Le porteur est-il Maitre d'Ouvrage Public ?"]
[null,"Montant total des dépenses"]
[null,"Contribution en nature",null,null,{"$f":"IF(E3=\"Oui\", \"Nom du MOP :\", \"\")","v":""}]
[null,"Montant financements privés"]
[null,"Montant financement public externe (dissocié)"]
[null,{"$f":" \"Montant \" & IF(E3=\"Oui\",\"MOP \"&F4,\"Région\")","v":"Montant Région"}]
[null,"Montant FEADER"]
[null,"Montant subvention",{"$f":"C6+C7+C8","v":0}]
[]
[null,"Contôle",{"$f":"IF(C23<(I17+J17+K17), \"Le montant de subvention calculé est inférieur au montant déjà payé.\",\"OK\")","v":{"$error":"#DIV/0!"}},{"$nulls":3},"La DP précédente est une Avance  :\nI11 à compléter si C11 n'est pas OK",null,"Non"]
[{"$nulls":8},"Saisir les montants déjà payés au titre des DP précédentes",{"$nulls":8},"Montant de subvention au titre de la DP",null,{"$f":"IF(AND(I11=\"Oui\",C19<>\"Solde\"),0,C23-I17-J17-K17)","v":{"$error":"#DIV/0!"}}]
[null,"Demande de paiement",{"$nulls":3},"Montant calculé cumulé",null,null,"Montant déjà payé",null,null,"Montant à payer",null,null,{"$f":"IF(OR(P15=\"KO\",P16=\"KO\"),\"Le taux de cofinancement n'est pas respecté, une régularisation du plan de financement est nécessaire\",\"\")","v":{"$error":"#DIV/0!"}},null,null,"calcul intermédiaire 1",{"$nulls":5},"calcul intermédiaire 2",{"$nulls":5},"calcul intermédiaire 3"]
[null,"Dépenses éligibles retenues cumulé",{"$f":"' DÉPENSES-Syn DP Instruct'!K76","v":{"$error":"#DIV/0!"}},null,null,"PP","FEADER","Top-up","PP","FEADER","Top-up","PP","FEADER","Top-up","Montant sub cumulé(DP actuelle inclus)","Ctrl Taux de Cofi",null,null,"PP","FEADER","Top-up","Total",null,null,"PP","FEADER","Top-up","Total",null,null,"PP","FEADER","Top-up","Total"]
[null,"Contribution privées",{"$f":"'RESSOURCES-Syn DP Instruc'!H10","v":0},null,"Département",{"$f":"IF($C$19=\"Avance\",Avance_Instructeur!C26,AE15)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($C$19=\"Avance\",Avance_Instructeur!D26,AF15)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($C$19=\"Avance\",0,AG15)","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"ROUND(F15-I15,2)","v":{"v":0,"d":"0.00 €"}},{"$f":"ROUND(G15-J15,2)","v":{"v":0,"d":"0.00 €"}},{"$error":"#DIV/0!"},{"$f":"SUM(I15:N15)","v":{"$error":"#DIV/0!"}},{"$f":"IF(M15=0,\"OK\",IF(ROUNDDOWN((L15+M15)*0.85,2)=M15,\"OK\",\"KO\"))","v":"OK"},null,"Département",{"$f":"IF(OR($J$17=C8,C6=\"\"),0,IF(T18<C17,T18,C17))","v":0},{"$f":"IF(OR(J17=$C$8,C6=\"\"),0,MIN(ROUNDDOWN(S15*0.85/0.15,2),T17))","v":0},null,{"$f":"ROUND(S15+T15+U15,2)","v":0},null,"Département",{"$f":"Z15*0.15/0.85","v":0},{"$f":"T15+J15","v":0},{"$f":"IF(' DÉPENSES-Syn DP Instruct'!B5=\"Solde\",C17-Y15,IF(Z17=C8,MIN(C23-Y17-Z17,C17-Y15),0))","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Y15+Z15+AA15,2)","v":{"$error":"#DIV/0!"}},null,"Département",{"$f":"MIN(Y15,C6)","v":0},{"$f":"IF(Y15=AE15,Z15,ROUNDDOWN(AE15/0.15*0.85,2))","v":0},{"$f":"AA15","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AE15+AF15+AG15,2)","v":{"$error":"#DIV/0!"}}]
[null,"Contribution en nature cumulé",{"$f":"' DÉPENSES-Syn DP Instruct'!J15","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(E3=\"Oui\",\"MOP \"&F4,\"Région\")","v":"Région"},{"$f":"IF($C$19=\"Avance\",Avance_Instructeur!C27,AE16)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Avance\",Avance_Instructeur!D27,AF16)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Avance\",0,AA16)","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"ROUND(F16-I16,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(I16:N16)","v":{"$error":"#DIV/0!"}},{"$f":"IF(M16=0,\"OK\",IF(ROUNDDOWN((L16+M16)*0.85,2)=M16,\"OK\",\"KO\"))","v":{"$error":"#DIV/0!"}},null,"Région",{"$f":"IF(OR(J17=C8,V15=T12,C7=\"\"),0,ROUNDUP(T16*0.15/0.85,2))","v":{"$error":"#DIV/0!"}},{"$f":"IF(OR(S16=0,J17=C8),0,ROUNDDOWN(T17-T15,2))","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(S16+T16+U16,2)","v":{"$error":"#DIV/0!"}},null,"Région",{"$f":"S16+I16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"IF(Z17=C8,MIN(C23-AB15-Y16-Z16,C7-Y16),0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(Y16+Z16+AA16,2)","v":{"$error":"#DIV/0!"}},null,"Région",{"$f":"MIN(Y17-AE15,C7)","v":{"$error":"#DIV/0!"}},{"$f":"IF(Y16=AE16,Z16,ROUNDDOWN(AE16/0.15*0.85,2))","v":{"$error":"#DIV/0!"}},{"$f":"AA16","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AE16+AF16+AG16,2)","v":{"$error":"#DIV/0!"}}]
[null,"Montant des VE",{"$f":"'RESSOURCES-Syn DP Instruc'!H15","v":0},null,"TOTAL",{"$f":"F15+F16","v":{"$error":"#DIV/0!"}},{"$f":"G15+G16","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUM(I15:I16)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,"TOTAL",{"$f":"SUM(S15:S16)","v":{"$error":"#DIV/0!"}},{"$f":"IF(J17=C8,0,MIN(T12*0.85,C8-J17))","v":0},{"$f":"U15+U16","v":0},{"$f":"SUM(V15:V16)","v":{"$error":"#DIV/0!"}},null,"TOTAL",{"$f":"SUM(Y15:Y16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(Z15:Z16)","v":{"$error":"#DIV/0!"}},{"$f":"AA15+AA16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AB15:AB16)","v":{"$error":"#DIV/0!"}},null,"TOTAL",{"$f":"SUM(AE15:AE16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AF15:AF16)","v":{"$error":"#DIV/0!"}},{"$f":"AG15+AG16","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AH15:AH16)","v":{"$error":"#DIV/0!"}}]
[null,"Montant de subvention cumulé avant plafonnement",{"$f":"' DÉPENSES-Syn DP Instruct'!M76","v":{"$error":"#DIV/0!"}},{"$nulls":14},"Montant PP max",null,{"$f":"ROUND(T12*0.15,2)","v":{"$error":"#DIV/0!"}}]
[null,"Objet de la DP",{"$f":"' DÉPENSES-Syn DP Instruct'!B5","v":"CHOISIR LA NATURE DE LA DEMANDE DE PAIEMENT"},{"$nulls":8},"Total à payer pour cette DP"]
[null,"Plafonnement acompte 90%",{"$f":"IF(C19=\"Acompte\",ROUND(C9*0.9,2),\"\")","v":""},null,"Montant à reporter à la DP suivante dans Montant déjà payé",{"$nulls":6},"PP","FEADER","Top-up","Montant sub"]
[null,"Plafonnement règle de non profit uniquement au Solde",{"$f":"IF(C19=\"Solde\",MIN(C14-C15-C16),\"\")","v":""},null,null,"Montants à prendre en compte DP suivante",{"$nulls":5},{"$f":"L17","v":{"$error":"#DIV/0!"}},{"$f":"M17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUM(L21:N21)","v":{"$error":"#DIV/0!"}}]
[null,"Plafonnement subvention CN",{"$f":"C14-C16","v":{"$error":"#DIV/0!"}},null,null,"PP","FEADER","Top-up"]
[null,"Montant subvention cumulé après plafonnement",{"$f":"MIN(C9,C18,C20,C21,C22)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(E15=\"\",\"\",E15)","v":"Département"},{"$f":"IF($C$19=\"Solde\",\"\",I15+L15)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($C$19=\"Solde\",\"\",J15+M15)","v":{"v":0,"d":"0.00 €"}},{"$error":"#DIV/0!"}]
[{"$nulls":4},{"$f":"IF(E3=\"Oui\",\"MOP \"&F4,\"Région\")","v":"Région"},{"$f":"IF($C$19=\"Solde\",\"\",I16+L16)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Solde\",\"\",J16+M16)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Solde\",\"\",K16+N16)","v":{"$error":"#DIV/0!"}}]
[null,"Contrôle montant VE ",null,null,"TOTAL",{"$f":"IF($C$19=\"Solde\",\"\",I17+L17)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Solde\",\"\",J17+M17)","v":{"$error":"#DIV/0!"}},{"$f":"IF($C$19=\"Solde\",\"\",K17+N17)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(C17<=C6,\"\",\"Le montant est supérieur au montant conventionné vérifier les saisies\")","v":""}]
[null,{"$f":"IF(OR(C19=\"Avance\",C19=\"Acompte\"),\"\",IF(L15+F15=C17,\"La totalité des VE a été pris en compte au Solde\",\"Il convient de régulariser le dossier car la totalité des VE n'a pas été pris en compte dans le calcul\"))","v":"La totalité des VE a été pris en compte au Solde"}]
[{"$nulls":4},"SI régularisation des montants nécessaire sélectionner \"Oui\""]
[]
[{"$nulls":4},"Et saisir un motif :"]
[]
[{"$nulls":4},"Montant calculé cumulé",{"$nulls":3},"Montant déjà payé",null,null,"Montant à payer"]
[{"$nulls":5},"PP","FEADER","Top-up","PP","FEADER","Top-up","PP","FEADER","Top-up","Montant sub"]
[{"$nulls":4},{"$f":"E15","v":"Département"},{"$nulls":3},{"$f":"IF($I$28=\"Oui\",I15,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF($I$28=\"Oui\",J15,0)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"IF(I28=\"Oui\",F34-I34,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(J28=\"Oui\",G34-J34,0)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"SUM(I34:N34)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},{"$f":"IF(E3=\"Oui\",\"MOP \"&F4,\"Région\")","v":"Région"},{"$nulls":3},{"$f":"IF($I$28=\"Oui\",I16,0)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"IF(I29=\"Oui\",F35-I35,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(J29=\"Oui\",G35-J35,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"IF(K29=\"Oui\",H35-K35,0)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(I35:N35)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":4},"TOTAL",{"$f":"F34+F35","v":{"v":0,"d":"0.00 €"}},{"$f":"G34+G35","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"$f":"SUM(I34:I35)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"$f":"SUM(N34:N35)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]
[]
[{"$nulls":4},"Contrôles"]
[{"$nulls":4},"Montant PP du financeur en dissocié  : ",null,{"$f":"IF(I28=\"Oui\",IF((I34+L34)=C6,\"Totalité des VE pris en compte\",IF((F34+I34)<C6,\"Le montant des VE est supérieur au montant calculé un OR devra être émis\",\"Le montant calculé est supérieur au montant des VE, il est nécessaire de revoir les valeurs\")),\"\")","v":""}]
[{"$nulls":4},"Montant de subvention",null,{"$f":"IF(I28=\"Oui\",IF(O34=C23,\"Le montant de subvention après reventilation est égal au montant calculé\",\"Le montant de subvention après reventilation est différent de celui calculé nécessité de revoir les valeurs\"),\"\")","v":""}]
[{"$nulls":4},"Montant FEADER",null,{"$f":"IF(AND(I28=\"Oui\",(J36+M36)>C8),\"Le montant de FEADER après reventilation est supérieur au montant conventionné\",\"\")","v":""}]
[{"$nulls":4},{"$f":" \"Montant \" & IF(E3=\"Oui\",\"MOP \"&F4,\"Région\")","v":"Montant Région"},null,{"$f":"IF(AND(I28=\"Oui\",(I35+K35+L35+N35)>C7),\"Le montant de Région après reventilation est supérieur au montant conventionné\",\"\")","v":""}]