{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Calcul des taux (formules)","Aide suppl. (volets I et II)","Traitements admissibles","Réductions zones-bandes","Versions du fichier","Menus","Majorations applicables"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":68,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calcul des taux (formules)","index":0,"n_rows":1048573,"n_cols":23,"rows_kept":4500,"cut":true,"hidden":false,"merged":[[1048522,0,1048522,8],[1048528,0,1048528,1],[1048528,2,1048528,3],[1048528,4,1048528,5],[1048529,0,1048529,5],[1048537,2,1048537,3],[1048537,4,1048537,5],[1048538,0,1048538,5],[1048521,0,1048521,8],[1048523,0,1048523,1],[1048523,2,1048523,3],[1048523,4,1048523,5],[1048524,0,1048524,1],[1048524,2,1048524,3],[1048524,4,1048524,5],[1048525,0,1048525,1],[1048525,2,1048525,3],[1048525,4,1048525,5],[1048526,0,1048526,1],[1048526,2,1048526,3],[1048526,4,1048526,5],[1048527,0,1048527,1],[1048527,2,1048527,3],[1048527,4,1048527,5],[1048547,0,1048547,5],[1048530,0,1048530,8],[1048532,0,1048532,1],[1048532,2,1048532,3],[1048532,4,1048532,5],[1048533,0,1048533,1],[1048533,2,1048533,3],[1048533,4,1048533,5],[1048534,0,1048534,1],[1048534,2,1048534,3],[1048534,4,1048534,5],[1048535,0,1048535,1],[1048535,2,1048535,3],[1048535,4,1048535,5],[1048536,0,1048536,1],[1048536,2,1048536,3],[1048536,4,1048536,5],[1048531,0,1048531,8],[1048537,0,1048537,1],[1048544,0,1048544,1],[1048544,2,1048544,3],[1048544,4,1048544,5],[1048545,0,1048545,1],[1048545,2,1048545,3],[1048545,4,1048545,5],[1048546,0,1048546,1],[1048546,2,1048546,3],[1048546,4,1048546,5],[1048539,0,1048539,8],[1048540,0,1048540,8],[1048541,0,1048541,1],[1048541,2,1048541,3],[1048541,4,1048541,5],[1048542,0,1048542,1],[1048542,2,1048542,3],[1048542,4,1048542,5],[1048543,0,1048543,1],[1048543,2,1048543,3],[1048543,4,1048543,5],[131,0,131,8],[167,6,167,8],[168,0,169,5],[168,6,169,8],[170,0,170,5],[170,6,170,8],[161,6,161,8],[133,0,133,5],[136,0,136,5],[132,0,132,5],[134,0,134,5],[159,6,160,8],[158,6,158,8],[158,0,158,5],[159,0,160,5],[154,0,154,8],[143,0,143,5],[144,0,144,5],[145,0,145,5],[148,0,148,8],[146,0,146,4],[155,6,157,8],[155,0,157,5],[135,0,135,5],[180,0,180,8],[181,0,182,8],[172,0,172,8],[173,0,175,5],[173,6,175,8],[177,0,178,5],[177,6,178,8],[179,0,179,5],[179,6,179,8],[176,0,176,5],[176,6,176,8],[54,0,54,8],[55,0,55,8],[57,0,57,8],[50,0,50,5],[58,0,58,8],[51,0,51,8],[69,0,69,8],[64,4,64,5],[66,4,66,5],[67,4,67,5],[56,0,56,5],[60,0,60,8],[65,4,65,5],[64,0,64,1],[65,0,65,1],[64,2,64,3],[65,2,65,3],[53,0,53,3],[59,0,59,5],[52,0,52,8],[31,0,31,8],[12,0,12,4],[6,0,6,5],[7,0,7,5],[8,0,8,5],[30,0,30,8],[24,0,24,8],[26,0,26,8],[28,0,28,8],[25,0,25,8],[27,0,27,8],[29,0,29,8],[33,0,33,5],[49,0,49,5],[47,0,47,5],[34,0,34,5],[32,0,32,4],[48,0,48,5],[43,0,43,2],[43,3,43,5],[39,0,39,8],[46,0,46,8],[40,6,40,8],[43,6,43,8],[35,0,35,5],[40,0,40,5],[83,0,83,5],[78,0,78,5],[79,0,79,5],[80,0,80,5],[81,0,81,5],[82,0,82,5],[63,0,63,1],[62,2,62,3],[63,2,63,3],[77,0,77,5],[71,0,71,5],[73,0,73,5],[72,0,72,5],[74,0,74,5],[75,0,75,5],[76,0,76,5],[68,0,68,5],[66,0,66,1],[67,0,67,1],[66,2,66,3],[67,2,67,3],[70,0,70,8],[85,0,85,5],[87,0,87,5],[137,0,137,5],[138,0,138,5],[149,0,149,5],[150,0,150,5],[151,0,151,5],[139,0,139,5],[140,0,140,5],[141,0,141,5],[142,0,142,5],[102,0,102,5],[124,0,124,5],[100,0,100,5],[101,0,101,5],[110,0,110,5],[114,0,114,5],[111,0,111,5],[112,0,112,5],[129,0,129,5],[126,0,126,5],[116,0,116,5],[117,0,117,5],[104,0,104,5],[119,0,119,5],[106,0,106,5],[118,0,118,5],[109,0,109,8],[127,0,127,8],[121,0,121,5],[123,0,123,5],[120,0,120,5],[122,0,122,5],[152,0,152,8],[0,0,0,8],[11,0,11,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[17,0,17,8],[19,0,19,8],[21,0,21,8],[23,0,23,8],[5,0,5,5],[1,0,1,4],[2,0,2,8],[3,0,3,5],[4,0,4,8],[16,0,16,8],[18,0,18,8],[20,0,20,8],[22,0,22,8],[107,0,107,5],[108,0,108,5],[128,0,128,5],[113,0,113,5],[115,0,115,5],[161,0,161,5],[147,0,147,5],[61,0,61,8],[84,0,84,4],[103,0,103,4],[125,0,125,4],[86,0,86,8],[90,0,90,8],[105,0,105,8],[130,0,130,5],[93,0,93,5],[94,0,94,5],[95,0,95,5],[99,0,99,5],[62,4,62,5],[63,4,63,5],[62,0,62,1],[96,0,96,5],[97,0,97,5],[98,0,98,5],[88,0,88,5],[89,0,89,5],[91,0,91,5],[92,0,92,5],[171,0,171,8],[162,0,162,8],[153,0,153,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8],[36,0,36,8],[37,0,37,8],[33,6,33,8],[34,6,34,8],[35,6,35,8],[38,0,38,8],[41,0,41,8],[42,0,42,8],[44,0,44,8],[45,0,45,8],[47,6,47,8],[48,6,48,8],[49,6,49,8],[163,0,163,8],[164,0,166,5],[164,6,166,8],[167,0,167,5]],"bounds":{"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0}}
[]
["\nAnnexe au rapport et au calcul des taux d'investissement pour les coupes partielles\n2017-2018"]
[" *** Veuillez saisir les informations dans les cellules blanches (Planification et BGAD) et jaunes (Ministère) ***"]
["Contexte d'utilisation",null,null,null,null,null,null,null,"Inscrire une valeur"]
["Identification"]
["UA"]
["Secteur d'intervention"]
["Unité de compilation"]
["Numéro de la prescription"]
["Traitement (Code DICA)",null,null,null,null,null,null,null,"Inscrire une valeur"]
["Traitement (Code RATF)"]
["Formule à utiliser pour le calcul"]
[{"$f":"\"Choix de la formule en fonction du code DICA  -  \"&I10","v":"Choix de la formule en fonction du code DICA  -  Inscrire une valeur"},null,null,null,null,{"$f":"IFERROR(VLOOKUP(I10,Menus!A259:F360,6,FALSE),\"F_Utilisateur\")","v":"F_Utilisateur"},null,null,"Inscrire une valeur"]
["Constante et formule utilisées pour déterminer le taux d'investissement"]
["Constante 1"]
["C1 = - 0,0385P + (325,112 / P) + 4,2221"]
["Constante 2"]
["C2 = - 0,0483P + (325,112/P) + 4,8778"]
["Formule 1"]
["Valeur = ( C1 + (4,797vr-0,682 - 7,388vp-0,391)) x P"]
["Formule 2"]
["Valeur = ( C1 + (14,195vr-0,237 - 10,053vp-0,237) - 0,43) x P"]
["Formule 4"]
["Valeur = ( C2 + (10,847vr-0,526 - 6,406vp-0,563) - 0,43) x P"]
["Formule 5"]
["Valeur = ( C2 + (10,523vr-0,535 - 6,406vp-0,563) - 0,43) x P"]
["Formule 6"]
["Valeur = ( C2 + (7,538vr-0,534 - 6,227vp-0,564) x P  "]
["Formule 7"]
["Valeur = ( C2 + (7,388vr-0,643 - 6,227vp-0,564) x P"]
["Intrants"]
["Intrants (Toutes)"]
["Sélection des tiges à récolter",null,null,null,null,{"$f":"IFERROR((VLOOKUP(I13,Menus!A214:C219,2,FALSE)),\"\")","v":""}]
["Volume à prélever, m3/ha net (P)"]
["Volume moyen des tiges du peuplement avant la récolte, m3/tige brut (vp)"]
["Volume moyen des tiges à récolter, m3/tige brut (vr)"]
[{"$f":"\"Majorations et/ou réductions admissibles pour la formule retenue  « \"&I13&\" »\"","v":"Majorations et/ou réductions admissibles pour la formule retenue  « Inscrire une valeur »"}]
[{"$f":"VLOOKUP('Calcul des taux (formules)'!I13,'Majorations applicables'!A2:G8,7,FALSE)","v":"Inscrire une valeur à la cellule I13"}]
["Réduction selon le ratio des trouées récoltées sous forme de CPRS (EMR1)"]
["Réduction EMR1 (F4-F5-F6-F7)"]
["Ratio des trouées sous forme de CPRS (%)"]
["Réduction pour les bandes non traitées (BNT1)"]
["Formule utilisée pour calculer la proportion que la coupe partielle représente par rapport au secteur (Pr)"]
["Pr (%) = BP / (BP + BE + ZNT )",null,null,"Selon les valeurs inscrites à G48-G49-G50",null,null,{"$f":"IFERROR(IF(EXACT(G48,\"\"),\"\",IF(EXACT($G$48,0),0,IF($G$48>0,($G$48/SUM($G$48:$G$50)),0))),0)","v":""}]
["Formule utilisée pour cacluler la réduction (BNT1)"]
["BNT1 = (0,8 x Pr2) - (1,8 x Pr) + 1"]
["Majoration BNT1 (F4-F5-F6-F7)"]
["BP : Largeur de la zone ou bande partiellement récoltée (m)"]
["BE : Largeur de la zone ou bande entièrement récoltée (m)"]
["ZNT : Largeur de la zone ou bande non traitée (m)"]
["Inscrire les renseignements dans la colonne associée au contexte d'utilisation",null,null,null,null,null,"Planification","BGAD","Ministère"]
["Majorations pour les opérations manuelles (MAN)"]
["Majoration MAN (F1)"]
["Type d'opérations ",null,null,null,{"$f":"IF(I13=\"Formule 1\",\"Majoration_MAN_F1\",\"Majoration_MAN_DIFF_F1\")","v":"Majoration_MAN_DIFF_F1"}]
["Majoration pour le rubannage des sentiers (RUB1)"]
["Majoration RUB1 (F1-F2-F4-F5-F7)"]
["Espacement entre les sentiers (m)"]
["Majoration pour l'hébergement (H1)"]
["Majoration H1 (F1-F2-F4-F5-F6-F7)"]
["Hébergement (3,2%)"]
["Majoration en fonction de la pente (PE2)"]
["Majoration en fonction de la pente (PE2) (Toutes)"]
["Classe de pente numérique",null,{"$f":"IF(OR(I4=\"\",I4=\"Inscrire une valeur\"),\"Contexte requis (cellule I4)\",\"Taux calculé ($/ha)\"&\" - \"&I4)","v":"Contexte requis (cellule I4)"},null,{"$f":"IF(OR(I4=\"\",I4=\"Inscrire une valeur\"),\"Contexte requis (cellule I4)\",\"Écart ($/ha)\"&\" - \"&I4)","v":"Contexte requis (cellule I4)"},null,"Superficie (ha)","Superficie (ha)","Superficie (ha)"]
["Pente A",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE)*VLOOKUP(A64,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C64-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE))),0)","v":0}]
["Pente B",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE)*VLOOKUP(A65,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C65-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE))),0)","v":0}]
["Pente C",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE)*VLOOKUP(A66,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C66-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE))),0)","v":0}]
["Pente D",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE)*VLOOKUP(A67,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C67-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE))),0)","v":0}]
["Pente E",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE)*VLOOKUP(A68,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C68-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,20,FALSE))),0)","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM(G64:G68)","v":0},{"$f":"SUM(H64:H68)","v":0},{"$f":"SUM(I64:I68)","v":0}]
["Totaux"]
["Totaux (F1)"]
["Taux de base exécution ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0}]
["Taux MAN ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,11,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR(((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,12,FALSE))/$G$34,0))),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,13,FALSE))/$G$34),0)),0)","v":0}]
["Taux RUB1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,14,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,15,FALSE))/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,16,FALSE))/$G$34,0)),0)","v":0}]
["Taux H1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,17,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR(((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,18,FALSE))/$G$34,0))),0)","v":0},{"$f":"IFERROR(((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,19,FALSE))/$G$34,0))),0)","v":0}]
["Sous-total exécution ($/m3)",null,null,null,null,null,{"$f":"IFERROR((SUM($G$72:$G$75)),0)","v":0},{"$f":"IFERROR((SUM($H$72:$H$75)),0)","v":0},{"$f":"IFERROR((SUM($I$72:$I$75)),0)","v":0}]
["Sous-total exécution ($/ha)",null,null,null,null,null,{"$f":"IFERROR(($G$76*$G$34),0)","v":0},{"$f":"IFERROR(($H$76*$G$34),0)","v":0},{"$f":"IFERROR(($I$76*$G$34),0)","v":0}]
["Majoration pour la pente PE2 ($/m³)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69/$G$34),0)),0)","v":0}]
["Majoration pour la pente PE2 ($/ha)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69),0)),0)","v":0}]
["Total des majorations à l'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$73:$G$75,$G$78)","v":0},{"$f":"SUM($H$73:$H$75,$H$78)","v":0},{"$f":"SUM($I$73:$I$75,$I$78)","v":0}]
["Total des majorations à l'exécution ($/ha)",null,null,null,null,null,{"$f":"SUM($G$73:$G$75,$G$78)*$G$34","v":0},{"$f":"SUM($H$73:$H$75,$H$78)*$G$34","v":0},{"$f":"SUM($I$73:$I$75,$I$78)*$G$34","v":0}]
["Taux d'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$76,$G$78)","v":0},{"$f":"SUM($H$76,$H$78)","v":0},{"$f":"SUM($I$76,$I$78)","v":0}]
["Taux d'exécution ($/ha)",null,null,null,null,null,{"$f":"SUM($G$77,$G$79)","v":0},{"$f":"SUM($H$77,$H$79)","v":0},{"$f":"SUM($I$77,$I$79)","v":0}]
["Tous les critères sont atteints1 (Oui ou Non)",null,null,null,null,null,"S/O"]
["Plancher d'investissement de 39$/ha (Oui, Non ou Sans Objet)",null,null,null,null,{"$f":"IFERROR((IF(AND(I88<=39,I84<>\"\"),\"Question_2_Moins_de_39\",IF(I88>=39,\"Question_2_39_et_plus\",\"Question_2\"))),\"Question_2\")","v":"Question_2"},"S/O","S/O"]
["Pourcentage d'investissement",null,null,null,null,null,{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9}]
["Résumé de l'investissement"]
["Taux global à payer ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"IF($G$69<>0,IF(ROUND(($G$83*$G$86),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($G$83*$G$86),2)),0)","v":0},{"$f":"IFERROR((IF($H$69<>0,IF($H$84<>\"\",IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($H$69<>0,IF(ROUND(($H$83*$H$86),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($H$83*$H$86),2)),0),0),0),0)),0)","v":0},{"$f":"IFERROR((IF($I$69<>0,IF($I$4=Menus!$A$560,IF($I$69<>0,IF(AND(ROUND(($I$83*(IF($I$84<>\"\",$I$84,0))*$I$86),2)<'Majorations applicables'!$B$41,$I$85=\"Oui\"),'Majorations applicables'!$B$41,ROUND(($I$83*(IF($I$84<>\"\",$I$84,0))*$I$86),2)),0),0),0)),0)","v":0}]
["Superficie (ha)",null,null,null,null,null,{"$f":"IF($I$13=\"Formule 1\",ROUND($G$69,2),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(IF($I$13=\"Formule 1\",ROUND($H$69,2),0)),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(IF($I$13=\"Formule 1\",ROUND($I$69,2),0)),0)),0)","v":0}]
["Montant total à payer ($)",null,null,null,null,null,{"$f":"ROUND(($G$88*$G$89),2)","v":0},{"$f":"ROUND(($H$88*$H$89),2)","v":0},{"$f":"ROUND(($I$88*$I$89),2)","v":0}]
["Totaux (F2)"]
["Taux de base exécution  ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0}]
["Taux RUB1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,14,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,15,FALSE))/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,16,FALSE))/$G$34,0)),0)","v":0}]
["Taux H1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,17,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR(((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,18,FALSE))/$G$34,0))),0)","v":0},{"$f":"IFERROR(((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,19,FALSE))/$G$34,0))),0)","v":0}]
["Sous-total exécution ($/m3)",null,null,null,null,null,{"$f":"IFERROR((SUM($G$92:$G$94)),0)","v":0},{"$f":"IFERROR((SUM($H$92:$H$94)),0)","v":0},{"$f":"IFERROR((SUM($I$92:$I$94)),0)","v":0}]
["Sous-total exécution ($/ha)",null,null,null,null,null,{"$f":"IFERROR(($G$95*$G$34),0)","v":0},{"$f":"IFERROR(($H$95*$G$34),0)","v":0},{"$f":"IFERROR(($I$95*$G$34),0)","v":0}]
["Majoration pour la pente PE2 ($/m³)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/I$69/$G$34),0)),0)","v":0}]
["Majoration pour la pente PE2 ($/ha)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69),0)),0)","v":0}]
["Total des majorations à l'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$93:$G$94,$G$97)","v":0},{"$f":"SUM($H$93:$H$94,$H$97)","v":0},{"$f":"SUM($I$93:$I$94,$I$97)","v":0}]
["Total des majorations à l'exécution ($/ha)",null,null,null,null,null,{"$f":"SUM($G$93:$G$94,$G$97)*$G$34","v":0},{"$f":"SUM($H$93:$H$94,$H$97)*$G$34","v":0},{"$f":"SUM($I$93:$I$94,$I$97)*$G$34","v":0}]
["Taux d'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$95,$G$97)","v":0},{"$f":"SUM($H$95,$H$97)","v":0},{"$f":"SUM($I$95,$I$97)","v":0}]
["Taux d'exécution ($/ha)",null,null,null,null,null,{"$f":"SUM($G$96,$G$98)","v":0},{"$f":"SUM($H$96,$H$98)","v":0},{"$f":"SUM($I$96,$I$98)","v":0}]
["Tous les critères sont atteints1 (Oui ou Non)",null,null,null,null,null,"S/O"]
["Plancher d'investissement de 39$/ha (Oui, Non ou Sans Objet)",null,null,null,null,{"$f":"IFERROR((IF(AND(I107<=39,I103<>\"\"),\"Question_2_Moins_de_39\",IF(I107>=39,\"Question_2_39_et_plus\",\"Question_2\"))),\"Question_2\")","v":"Question_2"},"S/O","S/O"]
["Pourcentage d'investissement",null,null,null,null,null,{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9}]
["Résumé de l'investissement"]
["Taux global à payer ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"IF($G$69<>0,IF(ROUND(($G$102*$G$105),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($G$102*$G$105),2)),0)","v":0},{"$f":"IFERROR((IF($H$69<>0,IF($H$103<>\"\",IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($H$69<>0,IF(ROUND(($H$102*$H$105),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND((H102*H105),2)),0),0),0),0)),0)","v":0},{"$f":"IFERROR((IF($I$69<>0,IF($I$4=Menus!$A$560,IF($I$69<>0,IF(AND(ROUND(($I$102*(IF($I$103<>\"\",$I$103,0))*$I$105),2)<'Majorations applicables'!$B$41,$I$104=\"Oui\"),'Majorations applicables'!$B$41,ROUND((I102*(IF($I$103<>\"\",$I$103,0))*$I$105),2)),0),0),0)),0)","v":0}]
["Superficie (ha)",null,null,null,null,null,{"$f":"IF($I13=\"Formule 2\",ROUND($G$69,2),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(IF($I$13=\"Formule 2\",ROUND($H$69,2),0)),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(IF($I$13=\"Formule 2\",ROUND($I$69,2),0)),0)),0)","v":0}]
["Montant total à payer ($)",null,null,null,null,null,{"$f":"ROUND(($G$107*$G$108),2)","v":0},{"$f":"ROUND(($H$107*$H$108),2)","v":0},{"$f":"ROUND(($I$107*$I$108),2)","v":0}]
["Totaux (F4-F5-F7)"]
["Taux de base exécution  ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0}]
["Taux EMR1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34),0)),0)","v":0}]
["Taux BNT1 (%)",null,null,null,null,null,{"$f":"IFERROR(IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)),0)","v":0}]
["Taux BNT1 ($/m³)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)),0)","v":0}]
["Taux RUB1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,14,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,15,FALSE))/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,16,FALSE))/$G$34,0)),0)","v":0}]
["Taux H1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,17,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR(((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,18,FALSE))/$G$34,0))),0)","v":0},{"$f":"IFERROR(((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,19,FALSE))/$G$34,0))),0)","v":0}]
["Sous-total exécution ($/m3)",null,null,null,null,null,{"$f":"IFERROR((SUM($G$111:$G$112,$G$114:$G$116)),0)","v":0},{"$f":"IFERROR((SUM($H$111:$H$112,$H$114:$H$116)),0)","v":0},{"$f":"IFERROR((SUM($I$111:$I$112,$I$114:$I$116)),0)","v":0}]
["Sous-total exécution ($/ha)",null,null,null,null,null,{"$f":"IFERROR(($G$117*$G$34),0)","v":0},{"$f":"IFERROR(($H$117*$G$34),0)","v":0},{"$f":"IFERROR(($I$117*$G$34),0)","v":0}]
["Majoration pour la pente PE2 ($/m³)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/G$69/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/H$69/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69/$G$34,0)),0)","v":0}]
["Majoration pour la pente PE2 ($/ha)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69,0)),0)","v":0}]
["Total des majorations et réductions à l'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$112,$G$114:$G$116,$G$119)","v":0},{"$f":"SUM($H$112,$H$114:$H$116,$H$119)","v":0},{"$f":"SUM($I$112,$I$114:$I$116,$I$119)","v":0}]
["Total des majorations et réductions à l'exécution ($/ha)",null,null,null,null,null,{"$f":"SUM($G$112,$G$114:$G$116,$G$119)*$G$34","v":0},{"$f":"SUM($H$112,$H$114:$H$116,$H$119)*$G$34","v":0},{"$f":"SUM($I$112,$I$114:$I$116,$I$119)*$G$34","v":0}]
["Taux d'exécution ($/m³)",null,null,null,null,null,{"$f":"IF($G$44=0,0,SUM($G$117,$G$119))","v":0},{"$f":"IF($G$44=0,0,SUM($H$117,$H$119))","v":0},{"$f":"IF($G$44=0,0,SUM($I$117,$I$119))","v":0}]
["Taux d'exécution ($/ha)",null,null,null,null,null,{"$f":"IF($G$44=0,0,SUM($G$118,$G$120))","v":0},{"$f":"IF($G$44=0,0,SUM($H$118,$H$120))","v":0},{"$f":"IF($G$44=0,0,SUM($I$118,$I$120))","v":0}]
["Tous les critères sont atteints1 (Oui ou Non)",null,null,null,null,null,"S/O"]
["Plancher d'investissement de 39$/ha (Oui, Non ou Sans Objet)",null,null,null,null,{"$f":"IFERROR((IF(AND(I129<=39,I125<>\"\"),\"Question_2_Moins_de_39\",IF(I129>=39,\"Question_2_39_et_plus\",\"Question_2\"))),\"Question_2\")","v":"Question_2"},"S/O","S/O"]
["Pourcentage d'investissement",null,null,null,null,null,{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9}]
["Résumé de l'investissement"]
["Taux global à payer ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"IFERROR((IF($G$69<>0,IF(ROUND(($G$124*$G$127),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($G$124*$G$127),2)),0)),0)","v":0},{"$f":"IFERROR((IF($H$69<>0,IF(H125<>\"\",IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($H$69<>0,IF(ROUND(($H$124*$H$127),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($H$124*$H$127),2)),0),0),0),0)),0)","v":0},{"$f":"IFERROR((IF($I$69<>0,IF($I$4=Menus!$A$560,IF($I$69<>0,IF(AND(ROUND((I124*(IF($I$125<>\"\",$I$125,0))*$I$127),2)<'Majorations applicables'!$B$41,$I$126=\"Oui\"),'Majorations applicables'!$B$41,ROUND(($I$124*(IF($I$125<>\"\",$I$125,0))*$I$127),2)),0),0),0)),0)","v":0}]
["Superficie (ha)",null,null,null,null,null,{"$f":"IF(OR(I$13=\"Formule 4\",I$13=\"Formule 5\",I$13=\"Formule 7\"),ROUND($G$69,2),0)","v":0},{"$f":"IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF(OR($I13=\"Formule 4\",$I13=\"Formule 5\",$I13=\"Formule 7\"),ROUND($H$69,2),0),0)","v":0},{"$f":"IF($I$4=Menus!$A$560,IF(OR($I13=\"Formule 4\",$I13=\"Formule 5\",$I13=\"Formule 7\"),ROUND($I$69,2),0),0)","v":0}]
["Montant total à payer ($)",null,null,null,null,null,{"$f":"ROUND(($G$129*$G$130),2)","v":0},{"$f":"ROUND(($H$129*$H$130),2)","v":0},{"$f":"ROUND(($I$129*$I$130),2)","v":0}]
["Totaux (F6)"]
["Taux de base exécution  ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$H$1048573,8,FALSE)/$G$34),0)),0)","v":0}]
["Taux EMR1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,9,FALSE))/$G$34),0)),0)","v":0}]
["Taux BNT1 (%)",null,null,null,null,null,{"$f":"IFERROR(IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,IF($G$48>0,-(('Majorations applicables'!$B$19*POWER($G$44,'Majorations applicables'!$B$20))-('Majorations applicables'!$B$21*$G$44)+1),IF(AND(OR(EXACT($G$48,0),(EXACT($G$48,\"\"))),OR($G$49>0,$G$50>0)),\"Valider BNT1\",0)),0)),0)","v":0}]
["Taux BNT1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,10,FALSE))/$G$34,0)),0)","v":0}]
["Taux H1 ($/m3)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,17,FALSE))/$G$34,0)","v":0},{"$f":"IFERROR(((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,18,FALSE))/$G$34,0))),0)","v":0},{"$f":"IFERROR(((IF($I$4=Menus!$A$560,(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$T$1048573,19,FALSE))/$G$34,0))),0)","v":0}]
["Sous-total exécution ($/m3)",null,null,null,null,null,{"$f":"IFERROR((SUM($G$133:$G$134,$G$136:$G$137)),0)","v":0},{"$f":"IFERROR((SUM($H$133:$H$134,$H$136:$H$137)),0)","v":0},{"$f":"IFERROR((SUM($I$133:$I$134,$I$136:$I$137)),0)","v":0}]
["Sous-total exécution ($/ha)",null,null,null,null,null,{"$f":"IFERROR(($G$138*$G$34),0)","v":0},{"$f":"IFERROR(($H$138*$G$34),0)","v":0},{"$f":"IFERROR(($I$138*$G$34),0)","v":0}]
["Majoration pour la pente PE2 ($/m³)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69/$G$34),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69/$G$34),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69/$G$34),0)),0)","v":0}]
["Majoration pour la pente PE2 ($/ha)",null,null,null,null,null,{"$f":"IFERROR((SUMPRODUCT($E$1048525:$E$1048529,$G$64:$G$68)/$G$69),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(SUMPRODUCT($E$1048534:$E$1048538,$H$64:$H$68)/$H$69),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(SUMPRODUCT($E$1048543:$E$1048547,$I$64:$I$68)/$I$69),0)),0)","v":0}]
["Total des majorations et réductions à l'exécution ($/m³)",null,null,null,null,null,{"$f":"SUM($G$134,$G$136:$G$137,$G$140)","v":0},{"$f":"SUM($H$134,$H$136:$H$137,$H$140)","v":0},{"$f":"SUM($I$134,$I$136:$I$137,$I$140)","v":0}]
["Total des majorations et réductions à l'exécution ($/ha)",null,null,null,null,null,{"$f":"$G$142*$G$34","v":0},{"$f":"$H$142*$G$34","v":0},{"$f":"$I$142*$G$34","v":0}]
["Taux d'exécution ($/m³)",null,null,null,null,null,{"$f":"IF($G$44=0,0,SUM($G$138,$G$140))","v":0},{"$f":"IF($G$44=0,0,SUM($H$138,$H$140))","v":0},{"$f":"IF($G$44=0,0,SUM($I$138,$I$140))","v":0}]
["Taux d'exécution ($/ha)",null,null,null,null,null,{"$f":"IF($G$44=0,0,SUM($G$139,$G$141))","v":0},{"$f":"IF($G$44=0,0,SUM($H$139,$H$141))","v":0},{"$f":"IF($G$44=0,0,SUM($I$139,$I$141))","v":0}]
["Tous les critères sont atteints1 (Oui ou Non)",null,null,null,null,null,"S/O"]
["Plancher d'investissement de 39$/ha (Oui, Non ou Sans Objet)",null,null,null,null,{"$f":"IFERROR((IF(AND(I150<=39,I146<>\"\"),\"Question_2_Moins_de_39\",IF(I150>=39,\"Question_2_39_et_plus\",\"Question_2\"))),\"Question_2\")","v":"Question_2"},"S/O","S/O"]
["Pourcentage d'investissement",null,null,null,null,null,{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9},{"$f":"'Majorations applicables'!$A$30","v":0.9}]
["Résumé de l'investissement"]
["Taux global à payer ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"IFERROR((IF($G$69<>0,IF(ROUND(($G$145*$G$148),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($G$145*$G$148),2)),0)),0)","v":0},{"$f":"IFERROR((IF($H$69<>0,IF($H$146<>\"\",IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),IF($H$69<>0,IF(ROUND(($H$145*$H$148),2)<'Majorations applicables'!$B$41,'Majorations applicables'!$B$41,ROUND(($H$145*$H$148),2)),0),0),0),0)),0)","v":0},{"$f":"IFERROR((IF($I$69<>0,IF($I$4=Menus!$A$560,IF($I$69<>0,IF(AND(ROUND((I145*(IF($I$146<>\"\",$I$146,0))*$I$148),2)<'Majorations applicables'!$B$41,$I$147=\"Oui\"),'Majorations applicables'!$B$41,ROUND(($I$145*(IF($I$146<>\"\",$I$146,0))*$I$148),2)),0),0),0)),0)","v":0}]
["Superficie (ha)",null,null,null,null,null,{"$f":"IF($I$13=\"Formule 6\",ROUND($G$69,2),0)","v":0},{"$f":"IFERROR((IF(OR($I$4=Menus!$A$559,$I$4=Menus!$A$560),(IF($I$13=\"Formule 6\",ROUND($H$69,2),0)),0)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$560,(IF($I$13=\"Formule 6\",ROUND($I$69,2),0)),0)),0)","v":0}]
["Montant total à payer ($)",null,null,null,null,null,{"$f":"ROUND(($G$150*$G$151),2)","v":0},{"$f":"ROUND(($H$150*$H$151),2)","v":0},{"$f":"ROUND(($I$150*$I$151),2)","v":0}]
[]
["Section réservée à l'usage de la Planification"]
["J'atteste que les renseignements fournis dans ce document afin de calculer les taux d'investissement sont complets et conformes à la vérité, au meilleur de mes connaissances."]
[]
[]
[]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"}]
[]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)"]
["Section réservée à l'usage du BGAD"]
["J'atteste que les renseignements fournis dans ce document afin de calculer les taux d'investissement sont complets et conformes à la vérité, au meilleur de mes connaissances."]
[]
[]
[]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"}]
[]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)"]
["Section réservée à l'usage du Ministère"]
["J'atteste que les renseignements fournis dans ce document afin de calculer les taux d'investissement sont complets et conformes à la vérité, au meilleur de mes connaissances."]
[]
[]
[]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"}]
[]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)"]
[]
["(1) Si un ou plusieurs des critères établis à la prescription ne sont pas atteints, veuillez inscrire \"Non\". À la suite du dépôt de votre rapport, le responsable du dossier à l'unité de gestion communiquera avec vous dans les meilleurs délais pour vous indiquer, le cas échéant, le montant de l'aide qui pourrait vous être accordé pour l'exécution des travaux. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Majoration en fonction de la pente (PE2) - Planification"]
["Classe de pente numérique",null,{"$f":"\"Taux calculé ($/ha)\"&\" - \"&I1048465","v":"Taux calculé ($/ha) - "},null,{"$f":"\"Écart ($/ha)\"&\" - \"&I1048465","v":"Écart ($/ha) - "},null,"Superficie (ha)","Superficie (ha)","Superficie (ha)"]
["Pente A",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE)*VLOOKUP(A1048525,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048525-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE))),0)","v":0},null,{"$f":"$G$64","v":0},{"$f":"$H$64","v":0},{"$f":"$I$64","v":0}]
["Pente B",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE)*VLOOKUP(A1048526,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048526-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE))),0)","v":0},null,{"$f":"$G$65","v":0},{"$f":"$H$65","v":0},{"$f":"$I$65","v":0}]
["Pente C",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE)*VLOOKUP(A1048527,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048527-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE))),0)","v":0},null,{"$f":"$G$66","v":0},{"$f":"$H$66","v":0},{"$f":"$I$66","v":0}]
["Pente D",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE)*VLOOKUP(A1048528,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048528-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE))),0)","v":0},null,{"$f":"$G$67","v":0},{"$f":"$H$67","v":0},{"$f":"$I$67","v":0}]
["Pente E",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE)*VLOOKUP(A1048529,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048529-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,21,FALSE))),0)","v":0},null,{"$f":"$G$68","v":0},{"$f":"$H$68","v":0},{"$f":"$I$68","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM($G$64:$G$68)","v":0},{"$f":"SUM($H$64:$H$68)","v":0},{"$f":"SUM($I$64:$I$68)","v":0}]
[]
["Majoration en fonction de la pente (PE2)  - BGAD"]
["Classe de pente numérique",null,{"$f":"\"Taux calculé ($/ha)\"&\" - \"&I1048474","v":"Taux calculé ($/ha) - "},null,{"$f":"\"Écart ($/ha)\"&\" - \"&I1048474","v":"Écart ($/ha) - "},null,"Superficie (ha)","Superficie (ha)","Superficie (ha)"]
["Pente A",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE)*VLOOKUP(A1048534,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048534-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE))),0)","v":0},null,{"$f":"$G$64","v":0},{"$f":"$H$64","v":0},{"$f":"$I$64","v":0}]
["Pente B",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE)*VLOOKUP(A1048535,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048535-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE))),0)","v":0},null,{"$f":"$G$65","v":0},{"$f":"$H$65","v":0},{"$f":"$I$65","v":0}]
["Pente C",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE)*VLOOKUP(A1048536,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048536-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE))),0)","v":0},null,{"$f":"$G$66","v":0},{"$f":"$H$66","v":0},{"$f":"$I$66","v":0}]
["Pente D",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE)*VLOOKUP(A1048537,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048537-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE))),0)","v":0},null,{"$f":"$G$67","v":0},{"$f":"$H$67","v":0},{"$f":"$I$67","v":0}]
["Pente E",null,{"$f":"IFERROR((VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE)*VLOOKUP(A1048538,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048538-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,22,FALSE))),0)","v":0},null,{"$f":"$G$68","v":0},{"$f":"$H$68","v":0},{"$f":"$I$68","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM($G$64:$G$68)","v":0},{"$f":"SUM($H$64:$H$68)","v":0},{"$f":"SUM($I$64:$I$68)","v":0}]
[]
["Majoration en fonction de la pente (PE2) - Ministère"]
["Classe de pente numérique",null,{"$f":"\"Taux calculé ($/ha)\"&\" - \"&I1048483","v":"Taux calculé ($/ha) - "},null,{"$f":"\"Écart ($/ha)\"&\" - \"&I1048483","v":"Écart ($/ha) - "},null,"Superficie (ha)","Superficie (ha)","Superficie (ha)"]
["Pente A",null,{"$f":"IFERROR((VLOOKUP($I$13,$A$1048565:$W$1048573,23,FALSE)*VLOOKUP(A1048543,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048543-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,23,FALSE))),0)","v":0},null,{"$f":"$G$64","v":0},{"$f":"$H$64","v":0},{"$f":"$I$64","v":0}]
["Pente B",null,{"$f":"IFERROR((VLOOKUP($I$13,$A$1048565:$W$1048573,23,FALSE)*VLOOKUP(A1048544,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048544-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,23,FALSE))),0)","v":0},null,{"$f":"$G$65","v":0},{"$f":"$H$65","v":0},{"$f":"$I$65","v":0}]
["Pente C",null,{"$f":"IFERROR((VLOOKUP($I$13,$A$1048565:$W$1048573,23,FALSE)*VLOOKUP(A1048545,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048545-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,23,FALSE))),0)","v":0},null,{"$f":"$G$66","v":0},{"$f":"$H$66","v":0},{"$f":"$I$66","v":0}]
["Pente D",null,{"$f":"IFERROR((VLOOKUP($I$13,$A$1048565:$W$1048573,23,FALSE)*VLOOKUP(A1048546,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048546-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,23,FALSE))),0)","v":0},null,{"$f":"$G$67","v":0},{"$f":"$H$67","v":0},{"$f":"$I$67","v":0}]
["Pente E",null,{"$f":"IFERROR((VLOOKUP($I$13,$A$1048565:$W$1048573,23,FALSE)*VLOOKUP(A1048547,'Majorations applicables'!$A$11:$B$15,2,FALSE)),0)","v":0},null,{"$f":"IFERROR((C1048547-(VLOOKUP($I$13,'Calcul des taux (formules)'!$A$1048565:$W$1048573,23,FALSE))),0)","v":0},null,{"$f":"$G$68","v":0},{"$f":"$H$68","v":0},{"$f":"$I$68","v":0}]
["Total",null,null,null,null,null,{"$f":"SUM($G$64:$G$68)","v":0},{"$f":"SUM($H$64:$H$68)","v":0},{"$f":"SUM($I$64:$I$68)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Item","Équation_Texte","A","B","C","E","F","Équation_Calcul_ha","EMR1_Brut_ha","BNT1_Brut_ha","MAN_Brut_ha_PLANIF","MAN_Brut_ha_BGAD","MAN_Brut_ha_MINISTERE","RUB1_Brut_ha_PLANIF","RUB1_Brut_ha_BGAD","RUB1_Brut_ha_MINISTERE","H2_Brut_ha_PLANIF","H2_Brut_ha_BGAD","H2_Brut_ha_MINISTERE","Somme_Brute_ha","Somme_Brute_ha_PLANIF","Somme_Brute_ha_BGAD","Somme_Brute_ha_MINISTERE"]
["C1","-0,0385P+(325,112/P)+4,2221",-3.85E-2,325.11200000000002,4.2221000000000002,null,null,{"$f":"IFERROR((C1048565*'Calcul des taux (formules)'!G34+(D1048565/'Calcul des taux (formules)'!G34)+E1048565),0)","v":0},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["C2","-0,0483P+(325,112/P)+4,8778",-4.8300000000000003E-2,325.11200000000002,4.8777999999999997,null,null,{"$f":"IFERROR((C1048566*'Calcul des taux (formules)'!$G$34+(D1048566/'Calcul des taux (formules)'!$G$34)+E1048566),0)","v":0},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["Formule 1","( C1 + (4,797vr-0,682 - 7,388vp-0,391))x P",4.7969999999999997,-0.68200000000000005,7.3879999999999999,-0.39100000000000001,null,{"$f":"IFERROR(((H1048565+(C1048567*POWER('Calcul des taux (formules)'!$G$36,D1048567))-(E1048567*POWER('Calcul des taux (formules)'!$G$35,F1048567)))*'Calcul des taux (formules)'!$G$34),0)","v":0},"N/A","N/A",{"$f":"IFERROR(($H$1048567*VLOOKUP(G54,Menus!$A$228:$C$230,2,0)),0)","v":0},{"$f":"IFERROR(($H$1048567*VLOOKUP(H54,Menus!$A$228:$C$230,2,0)),0)","v":0},{"$f":"IFERROR(($H$1048567*VLOOKUP(I54,Menus!$A$228:$C$230,2,0)),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!G$57<15,'Calcul des taux (formules)'!G$57=Menus!$A$234,'Calcul des taux (formules)'!G$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!G$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!H$57<15,'Calcul des taux (formules)'!H$57=Menus!$A$234,'Calcul des taux (formules)'!H$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!H$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!I$57<15,'Calcul des taux (formules)'!I$57=Menus!$A$234,'Calcul des taux (formules)'!I$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!I$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((SUM(H1048567:K1048567,N1048567)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048567:J1048567,L1048567,O1048567)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048567:J1048567,M1048567,P1048567)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048567:K1048567,N1048567,Q1048567),IF($I$4=Menus!$A$559,SUM(H1048567:J1048567,L1048567,O1048567,R1048567),IF($I$4=Menus!$A$560,SUM(H1048567:J1048567,M1048567,P1048567,S1048567),0)))),0)","v":0},{"$f":"IFERROR((SUM(H1048567:K1048567,N1048567,Q1048567)),0)","v":0},{"$f":"IFERROR((SUM(H1048567:J1048567,L1048567,O1048567,R1048567)),0)","v":0},{"$f":"IFERROR((SUM(H1048567:J1048567,M1048567,P1048567,S1048567)),0)","v":0}]
["Formule 2","( C1 + (14,195vr-0,237 - 10,053vp-0,237)-0,43) x P",14.195,-0.23699999999999999,10.053000000000001,-0.23699999999999999,0.43,{"$f":"IFERROR(((H1048565+(C1048568*POWER('Calcul des taux (formules)'!$G$36,D1048568))-(E1048568*POWER('Calcul des taux (formules)'!$G$35,F1048568))-G1048568)*'Calcul des taux (formules)'!$G$34),0)","v":0},"N/A","N/A","N/A","N/A","N/A",{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!G$57<15,'Calcul des taux (formules)'!G$57=Menus!$A$234,'Calcul des taux (formules)'!G$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!G$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!H$57<15,'Calcul des taux (formules)'!H$57=Menus!$A$234,'Calcul des taux (formules)'!H$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!H$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!I$57<15,'Calcul des taux (formules)'!I$57=Menus!$A$234,'Calcul des taux (formules)'!I$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!I$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((SUM(H1048568:K1048568,N1048568)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048568:J1048568,L1048568,O1048568)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048568:J1048568,M1048568,P1048568)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048568:K1048568,N1048568,Q1048568),IF($I$4=Menus!$A$559,SUM(H1048568:J1048568,L1048568,O1048568,R1048568),IF($I$4=Menus!$A$560,SUM(H1048568:J1048568,M1048568,P1048568,S1048568),0)))),0)","v":0},0,0,{"$f":"IFERROR((SUM(H1048568:J1048568,M1048568,P1048568,S1048568)),0)","v":0}]
["Formule 4","( C2 + (10,847vr-0,526 - 6,406vp-0,563)-0,43) x P",10.847,-0.52600000000000002,6.4059999999999997,-0.56299999999999994,0.43,{"$f":"IFERROR(((H1048566+(C1048569*POWER('Calcul des taux (formules)'!$G$36,D1048569))-(E1048569*POWER('Calcul des taux (formules)'!$G$35,F1048569))-G1048569)*'Calcul des taux (formules)'!$G$34),0)","v":0},{"$f":"(H1048569*(-'Calcul des taux (formules)'!$G$41))","v":0},{"$f":"IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49>0,'Calcul des taux (formules)'!$G$50>0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048569+I1048569)),IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49=0,'Calcul des taux (formules)'!$G$50=0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048569+I1048569)),0))","v":0},"N/A","N/A","N/A",{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!G$57<15,'Calcul des taux (formules)'!G$57=Menus!$A$234,'Calcul des taux (formules)'!G$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!G$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!H$57<15,'Calcul des taux (formules)'!H$57=Menus!$A$234,'Calcul des taux (formules)'!H$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!H$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!I$57<15,'Calcul des taux (formules)'!I$57=Menus!$A$234,'Calcul des taux (formules)'!I$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!I$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((SUM(H1048569:K1048569,N1048569)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048569:J1048569,L1048569,O1048569)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048569:J1048569,M1048569,P1048569)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048569:K1048569,N1048569,Q1048569),IF($I$4=Menus!$A$559,SUM(H1048569:J1048569,L1048569,O1048569,R1048569),IF($I$4=Menus!$A$560,SUM(H1048569:J1048569,M1048569,P1048569,S1048569),0)))),0)","v":0},0,0,0]
["Formule 5","( C2 + (10,523vr-0,535 - 6,406vp-0,563)-0,43) x P",10.523,-0.53500000000000003,6.4059999999999997,-0.56299999999999994,0.43,{"$f":"IFERROR(((H1048566+(C1048570*POWER('Calcul des taux (formules)'!$G$36,D1048570))-(E1048570*POWER('Calcul des taux (formules)'!$G$35,F1048570))-G1048570)*'Calcul des taux (formules)'!$G$34),0)","v":0},{"$f":"(H1048570*(-'Calcul des taux (formules)'!$G$41))","v":0},{"$f":"IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49>0,'Calcul des taux (formules)'!$G$50>0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048570+I1048570)),IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49=0,'Calcul des taux (formules)'!$G$50=0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048570+I1048570)),0))","v":0},"N/A","N/A","N/A",{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!G$57<15,'Calcul des taux (formules)'!G$57=Menus!$A$234,'Calcul des taux (formules)'!G$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!G$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!H$57<15,'Calcul des taux (formules)'!H$57=Menus!$A$234,'Calcul des taux (formules)'!H$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!H$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!I$57<15,'Calcul des taux (formules)'!I$57=Menus!$A$234,'Calcul des taux (formules)'!I$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!I$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((SUM(H1048570:K1048570,N1048570)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048570:J1048570,L1048570,O1048570)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048570:J1048570,M1048570,P1048570)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048570:K1048570,N1048570,Q1048570),IF($I$4=Menus!$A$559,SUM(H1048570:J1048570,L1048570,O1048570,R1048570),IF($I$4=Menus!$A$560,SUM(H1048570:J1048570,M1048570,P1048570,S1048570),0)))),0)","v":0},0,0,0]
["Formule 6","( C2 + (7,538vr-0,534 - 6,227vp-0,564) x P",7.5380000000000003,-0.53400000000000003,6.2270000000000003,-0.56399999999999995,null,{"$f":"IFERROR(((H1048566+(C1048571*POWER('Calcul des taux (formules)'!$G$36,D1048571))-(E1048571*POWER('Calcul des taux (formules)'!$G$35,F1048571)))*'Calcul des taux (formules)'!$G$34),0)","v":0},{"$f":"(H1048571*(-'Calcul des taux (formules)'!$G$41))","v":0},{"$f":"IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49>0,'Calcul des taux (formules)'!$G$50>0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048571+I1048571)),IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49=0,'Calcul des taux (formules)'!$G$50=0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048571+I1048571)),0))","v":0},"N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IFERROR((SUM(H1048571:K1048571,N1048571)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048571:J1048571,L1048571,O1048571)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048571:J1048571,M1048571,P1048571)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048571:K1048571,N1048571,Q1048571),IF($I$4=Menus!$A$559,SUM(H1048571:J1048571,L1048571,O1048571,R1048571),IF($I$4=Menus!$A$560,SUM(H1048571:J1048571,M1048571,P1048571,S1048571),0)))),0)","v":0},0,0,0]
["Formule 7","( C2 + (7,388vr-0,643 - 6,227vp-0,564) x P",7.3879999999999999,-0.64300000000000002,6.2270000000000003,-0.56399999999999995,null,{"$f":"IFERROR(((H1048566+(C1048572*POWER('Calcul des taux (formules)'!$G$36,D1048572))-(E1048572*POWER('Calcul des taux (formules)'!$G$35,F1048572)))*'Calcul des taux (formules)'!$G$34),0)","v":0},{"$f":"(H1048572*(-'Calcul des taux (formules)'!$G$41))","v":0},{"$f":"IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49>0,'Calcul des taux (formules)'!$G$50>0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048572+I1048572)),IF(AND('Calcul des taux (formules)'!$G$48>0,OR('Calcul des taux (formules)'!$G$49=0,'Calcul des taux (formules)'!$G$50=0)),(-('Majorations applicables'!$B$19*POWER('Calcul des taux (formules)'!$G$44,'Majorations applicables'!$B$20)-('Majorations applicables'!$B$21*'Calcul des taux (formules)'!$G$44)+1)*(H1048572+I1048572)),0))","v":0},"N/A","N/A","N/A",{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!G$57<15,'Calcul des taux (formules)'!G$57=Menus!$A$234,'Calcul des taux (formules)'!G$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!G$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!H$57<15,'Calcul des taux (formules)'!H$57=Menus!$A$234,'Calcul des taux (formules)'!H$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!H$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((IF(OR('Calcul des taux (formules)'!I$57<15,'Calcul des taux (formules)'!I$57=Menus!$A$234,'Calcul des taux (formules)'!I$57=\"\"),0,'Majorations applicables'!$B$26*POWER('Calcul des taux (formules)'!I$57,'Majorations applicables'!$B$27))),0)","v":0},{"$f":"IFERROR((SUM(H1048572:K1048572,N1048572)*SUM(VLOOKUP($G$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048572:J1048572,L1048572,O1048572)*SUM(VLOOKUP($H$60,Menus!$A$223:$B$224,2,FALSE))),0)","v":0},{"$f":"IFERROR((SUM(H1048572:J1048572,M1048572,P1048572)*VLOOKUP($I$60,Menus!$A$223:$B$224,2,FALSE)),0)","v":0},{"$f":"IFERROR((IF($I$4=Menus!$A$558,SUM(H1048572:K1048572,N1048572,Q1048572),IF($I$4=Menus!$A$559,SUM(H1048572:J1048572,L1048572,O1048572,R1048572),IF($I$4=Menus!$A$560,SUM(H1048572:J1048572,M1048572,P1048572,S1048572),0)))),0)","v":0},0,0,0]
["Inscrire une valeur","Veuillez inscrire une formule à G12"]

{"sheet":"Aide suppl. (volets I et II)","index":1,"n_rows":181,"n_cols":103,"rows_kept":181,"cut":false,"hidden":false,"merged":[[11,0,11,5],[66,0,66,5],[66,6,66,8],[67,0,68,5],[67,6,68,8],[21,0,21,5],[42,0,42,5],[63,6,65,8],[58,0,58,5],[58,6,58,8],[48,0,48,8],[56,0,57,5],[56,6,57,8],[59,0,59,8],[60,0,60,8],[61,0,61,8],[69,0,69,5],[69,6,69,8],[80,0,80,5],[80,6,80,8],[70,0,70,8],[71,0,71,8],[72,0,72,8],[73,0,73,8],[74,0,76,5],[74,6,76,8],[77,0,77,5],[77,6,77,8],[78,0,79,5],[78,6,79,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[3,6,3,8],[4,0,4,8],[7,0,7,5],[63,0,65,5],[52,0,54,5],[52,6,54,8],[55,0,55,5],[55,6,55,8],[47,0,47,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[62,0,62,8],[22,0,26,2],[22,3,22,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[19,0,20,2],[19,3,19,5],[20,3,20,5],[13,0,13,5],[0,0,0,8],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[5,0,5,5],[1,0,1,5],[18,0,18,8],[12,0,12,8],[6,0,6,5],[2,0,2,8],[3,0,3,5],[8,6,8,8],[9,6,9,8],[10,6,10,8],[10,0,10,5],[9,0,9,5],[8,0,8,5],[36,0,36,5],[44,0,44,5],[45,0,45,5],[46,0,46,5],[37,0,37,5],[38,0,38,5],[39,0,39,5],[40,0,40,5],[41,0,41,5],[43,0,43,8],[27,0,27,5],[32,0,32,5],[33,0,33,5],[34,0,34,5],[35,0,35,5],[28,0,28,5],[30,0,30,5],[31,0,31,5],[29,0,29,8]]}
[]
[" Annexe au rapport et au calcul de l'aide supplémentaire à l’aménagement des forêts feuillues et mixtes et\n2017-2018"]
[" *** Veuillez saisir les informations dans les cellules blanches (Planification et BGAD) et jaunes (Ministère) ***"]
["Contexte d'utilisation",null,null,null,null,null,"Inscrire une valeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UAF","Zone","Taux","OUI"]
["Identification"]
["UA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NON"]
["Secteur d'intervention",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01151",151,0]
["Unité de compilation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01152",152,0]
["Numéro de la prescription",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01251",153,0]
["Traitement (code DICA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01252",154,0]
["Traitement (Code RATF)"]
["Inscrire les renseignements dans la colonne associée au contexte d'utilisation",null,null,null,null,null,"Planification","BGAD","Ministère"]
["Admissibilité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01253",155,0]
["Secteur d'intervention feuillu ou mixte à dominance feuillue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01254",156,0]
["Selon la prescription, la composition visée est feuillue ou mixte feuillue",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02251",157,0]
["Admissible à l'aide financière pour les coupes partielles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02351",158,0]
["Pourcentage de récupération des bois de trituration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02352",180,0]
["Superficie admissible (ha)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02451",181,80]
["Volet I : Mesure d'accès au marché (bois de trituration)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02452",182,0]
["Aide supplémentaire pour les bois de trituration livrés selon la zone de tarification",null,null,"Zone de tarification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02651",184,200]
[null,null,null,"Proportion des bois assignée à ce calcul (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02661",185,80]
["Sous-total selon la zone de tarification ($/ha)",null,null,null,null,null,{"$f":"IFERROR((VLOOKUP(G20,Menus!$A$370:$B$555,2,FALSE)*G17*G21),0)","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),(VLOOKUP(H20,Menus!$A$370:$B$555,2,FALSE)*H17*H21),0)),0)","v":0},{"$f":"IFERROR((IF($G$4=Menus!$A$560,(VLOOKUP(I20,Menus!$A$370:$B$555,2,FALSE)*I17*I21),0)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02662",186,80]
["Aide supplémentaire pour les bois de trituration livrés à une autre destination",null,null,"Proportion des bois assignée à ce calcul (%)",null,null,{"$f":"IF(G21=\"\",\"\",1-G21)","v":""},{"$f":"IF(H21=\"\",\"\",1-H21)","v":""},{"$f":"IF(I21=\"\",\"\",1-I21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02664",190,220]
[null,null,null,"Destination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02665",191,220]
[null,null,null,"Numéro de projet de mesurage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02666",192,140]
[null,null,null,"Volume déclaré (m³)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02751",193,80]
[null,null,null,"Distance (km)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03151",194,20]
["Sous-total aide autre destination ($/ha)",null,null,null,null,null,{"$f":"IFERROR((IF(G24=\"\",0,IF((('Majorations applicables'!$A$33*G27)-'Majorations applicables'!$A$34)<0,0,IF((('Majorations applicables'!$A$33*G27)-'Majorations applicables'!$A$34)<280,(('Majorations applicables'!$A$33*G27)-'Majorations applicables'!$A$34),280))*G23)*G17),0)","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),IF(H24=\"\",0,IF((('Majorations applicables'!$A$33*H27)-'Majorations applicables'!$A$34)<0,0,IF((('Majorations applicables'!$A$33*H27)-'Majorations applicables'!$A$34)<280,(('Majorations applicables'!$A$33*H27)-'Majorations applicables'!$A$34),280))*H23)*H17,0)),0)","v":0},{"$f":"IFERROR((IF($G$4=Menus!$A$560,IF(I24=\"\",0,IF((('Majorations applicables'!$A$33*I27)-'Majorations applicables'!$A$34)<0,0,IF((('Majorations applicables'!$A$33*I27)-'Majorations applicables'!$A$34)<280,(('Majorations applicables'!$A$33*I27)-'Majorations applicables'!$A$34),280))*I23)*I17,0)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03152",195,0]
["Taux global pour l'aide volet I ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"IF(AND(G14=\"OUI\",G15=\"OUI\",G16=\"OUI\"),G22+G28,0)","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),IF(AND(H14=\"OUI\",H15=\"OUI\",H16=\"OUI\"),H22+H28,0),0)),0)","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),IF(AND(I14=\"OUI\",I15=\"OUI\",I16=\"OUI\"),I22+I28,0),0)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03153",240,0]
["Volet II : Transport et mesurage optimisés des bois feuillus en longueur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03351",241,60]
["Transport des bois feuillus en longueur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03451",242,140]
["Proportion des bois feuillus transportés en longueur (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03453",243,140]
["Destination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03551",244,260]
["Numéro de projet de mesurage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04151",245,260]
["Volume déclaré (m³)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04251",246,260]
["Sous-total aide au transport ($/ha)",null,null,null,null,null,{"$f":"IF(AND(G14=\"Oui\",G15=\"Oui\",G16=\"Oui\",G31=\"Oui\",G34<>\"\"),'Majorations applicables'!$B$37,0)*G32","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),IF(AND(H14=\"Oui\",H15=\"Oui\",H16=\"Oui\",H31=\"Oui\",H34<>\"\"),'Majorations applicables'!$B$37,0)*H32,0)),0)","v":0},{"$f":"IFERROR((IF($G$4=Menus!$A$560,IF(AND(I14=\"Oui\",I15=\"Oui\",I16=\"Oui\",I31=\"Oui\",I34<>\"\"),'Majorations applicables'!$B$37,0)*I32,0)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04351",247,280]
["Mesurage optimisé des bois feuillus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04352",250,260]
["Proportion des bois feuillus mesurés (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05151",251,280]
["Destination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06151",252,280]
["Numéro de projet de mesurage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06152",253,280]
["Volume déclaré (m³)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06251",254,280]
["Sous-total aide au mesurage optimisé ($/ha)",null,null,null,null,null,{"$f":"IF(G38<=G32,(IF(AND(G14=\"OUI\",G15=\"OUI\",G16=\"OUI\",G37=\"OUI\",G40<>\"\"),'Majorations applicables'!$B$38,0)*G38),0)","v":0},{"$f":"IFERROR((IF(OR($G$4=Menus!$A$559,$G$4=Menus!$A$560),IF(H38<=H32,(IF(AND(H14=\"OUI\",H15=\"OUI\",H16=\"OUI\",H37=\"OUI\",H40<>\"\"),'Majorations applicables'!$B$38,0)*H38),0),0)),0)","v":0},{"$f":"IFERROR((IF($G$4=Menus!$A$560,IF(I38<=I32,(IF(AND(I14=\"OUI\",I15=\"OUI\",I16=\"OUI\",I37=\"OUI\",I40<>\"\"),'Majorations applicables'!$B$38,0)*I38),0),0)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06252",255,120]
["Taux global pour l'aide volet II ($/ha) - taux à inscrire à l'état d'avancement et au RATF",null,null,null,null,null,{"$f":"G42+G36","v":0},{"$f":"H42+H36","v":0},{"$f":"I42+I36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06451",256,200]
["Résumé de l'aide supplémentaire",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06452",257,280]
["Grand total aide volet I ($)",null,null,null,null,null,{"$f":"G29*G18","v":0},{"$f":"H29*H18","v":0},{"$f":"I29*I18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07151",258,280]
["Grand total aide volet II ($)",null,null,null,null,null,{"$f":"G43*G18","v":0},{"$f":"H43*H18","v":0},{"$f":"I43*I18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07152",259,280]
["Grand total admissible ($)",null,null,null,null,null,{"$f":"G46+G45","v":0},{"$f":"H46+H45","v":0},{"$f":"I46+I45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07251",260,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07351",261,280]
["Section réservée à l'usage de la Planification",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07352",262,280]
["Remarques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07451",263,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08251",266,200]
["J'atteste que les renseignements fournis dans ce document afin de calculer l'aide supplémentaire sont complets et conformes à la vérité, au meilleur de mes connaissances.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08665",276,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08666",277,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08751",278,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08762",279,280]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08763",280,280]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08764",281,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09351",282,280]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09352",283,280]
["Section réservée à l'usage du BGAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09451",284,280]
["Remarques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09452",285,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09551",286,280]
["J'atteste que les renseignements fournis dans ce document afin de calculer l'aide supplémentaire sont complets et conformes à la vérité, au meilleur de mes connaissances.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09751",287,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11161",288,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11262",289,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11263",290,280]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,291,280]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,292,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,0]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,351,0]
["Section réservée à l'usage du Ministère",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,352,40]
["Remarques",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,353,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,354,120]
["J'atteste que les renseignements fournis dans ce document afin de calculer l'aide supplémentaire sont complets et conformes à la vérité, au meilleur de mes connaissances.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,355,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,356,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,357,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,60]
["Nom et prénom de l'ingénieur forestier",null,null,null,null,null,"No de permis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,451,0]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-08-08"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,452,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,453,0]
["Signature de l'ingénieur forestier",null,null,null,null,null,"Date (AAAA-MM-JJ)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,454,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,455,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,456,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,457,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,458,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,459,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,460,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,461,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,551,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,650,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,651,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,652,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,653,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,654,200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,655,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,656,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,657,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,658,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,659,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660,160]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,661,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,662,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,751,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,752,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,753,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,754,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,755,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,756,260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,757,260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,758,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,851,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,852,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,853,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,854,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,855,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,856,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,857,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,858,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,859,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,860,260]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,861,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,862,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,863,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,864,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,865,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,866,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,867,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,868,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,869,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,870,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,871,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,872,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,873,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,874,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,875,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,876,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,877,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,878,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,879,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,880,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,881,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,882,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,883,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,884,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,885,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,886,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,887,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,888,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,889,240]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,890,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,891,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,892,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,950,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,951,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,952,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,953,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,954,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,955,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,956,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,957,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,960,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,961,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,962,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,963,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,964,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,965,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,966,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,967,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,980,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,981,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,982,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,983,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,984,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,985,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,986,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,987,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,990,280]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,995,0]

{"sheet":"Traitements admissibles","index":2,"n_rows":132,"n_cols":7,"rows_kept":132,"cut":false,"hidden":false,"merged":[[117,4,118,4],[119,4,120,4],[121,4,126,4],[106,2,116,2],[106,3,108,3],[106,4,108,4],[109,3,116,3],[109,4,110,4],[111,4,116,4],[117,3,118,3],[119,3,131,3],[117,2,131,2],[93,4,94,4],[95,4,100,4],[54,2,64,2],[54,3,56,3],[54,4,56,4],[57,3,64,3],[57,4,58,4],[59,4,64,4],[65,3,66,3],[67,3,68,3],[67,4,68,4],[69,4,74,4],[80,4,82,4],[83,3,90,3],[83,4,84,4],[85,4,90,4],[91,4,92,4],[18,0,53,0],[18,1,53,1],[18,3,27,3],[18,4,23,4],[24,4,27,4],[28,3,30,3],[28,4,30,4],[31,4,32,4],[33,4,38,4],[44,2,53,2],[44,3,45,3],[46,3,47,3],[46,4,47,4],[48,3,53,3],[48,4,53,4],[31,3,43,3],[18,2,43,2],[3,0,8,0],[3,1,8,1],[3,2,8,2],[3,3,8,3],[15,0,15,6],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,6],[3,4,8,4],[9,0,14,0],[9,1,14,1],[9,2,14,2],[9,3,14,3],[9,4,14,4],[0,0,0,6],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[106,1,131,1],[106,0,131,0],[54,0,79,0],[93,3,105,3],[91,2,105,2],[80,1,105,1],[80,0,105,0],[80,2,90,2],[80,3,82,3],[54,1,79,1],[69,3,79,3],[65,2,79,2],[91,3,92,3]]}
["Éclaircies commerciales : traitements admissibles 2017-2018"]
["Compositions","Sélections des tiges à récolter","Patrons d'intervention","Structures cibles","Traitements","Codes DICA","Formules à utiliser"]
[]
["SEPM, mixtes à tendance résineuse  et feuillus intolérants","--","Uniforme","Régulière","Éclaircie commerciale","EC_SEL-BAS",1]
[null,null,null,null,null,"EC_SEL-HAUT",1]
[null,null,null,null,null,"EC_SEL-NEUTRE",1]
[null,null,null,null,null,"EC_MIXTE-BAS",1]
[null,null,null,null,null,"EC_MIXTE-HAUT",1]
[null,null,null,null,null,"EC_MIXTE-NEUTRE",1]
["Feuillus tolérants, autres résineux et mixtes à tendance feuillue","--","Uniforme","Régulière","Éclaircie commerciale","EC_SEL-BAS",2]
[null,null,null,null,null,"EC_SEL-HAUT",2]
[null,null,null,null,null,"EC_SEL-NEUTRE",2]
[null,null,null,null,null,"EC_MIXTE-BAS",2]
[null,null,null,null,null,"EC_MIXTE-HAUT",2]
[null,null,null,null,null,"EC_MIXTE-NEUTRE",2]
["Autres coupes partielles : traitements admissibles 2017-2018"]
["Compositions","Sélections des tiges à récolter","Patrons d'intervention","Structures cibles","Traitements","Codes DICA","Formules à utiliser"]
[]
["Feuillus tolérants, autres résineux et mixtes à tendance feuillue","Martelage","Uniforme","Jardinée / gestion par arbres","Coupe de jardinage par pieds d'arbres ou pieds d'arbres et groupes d'arbres","CJP-AM",4]
[null,null,null,null,null,"CJP-HQ",4]
[null,null,null,null,null,"CJP-QM",4]
[null,null,null,null,null,"CJPG-AM",4]
[null,null,null,null,null,"CJPG-HQ",4]
[null,null,null,null,null,"CJPG-QM",4]
[null,null,null,null,"Éclaircie jardinatoire par pieds d'arbres ou pieds d'arbres et groupes d'arbres","EJ_P-CLAS",4]
[null,null,null,null,null,"EJ_P-INI",4]
[null,null,null,null,null,"EJ_PG-CLAS",4]
[null,null,null,null,null,"EJ_PG-INI",4]
[null,null,null,"Régulière","Coupe progressive régulière","CPR_U-PR",4]
[null,null,null,null,null,"CPR_U-ENS",4]
[null,null,null,null,null,"CPR_U_SEC",4]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent","CPI_CP-ENS_U",4]
[null,null,null,null,null,"CPI_CP-SEC_U",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",4]
[null,null,null,null,null,"CPI_RL-2I_SEC",4]
[null,null,null,null,null,"CPI_RL-3I_ENS",4]
[null,null,null,null,null,"CPI_RL-3I_SEC",4]
[null,null,null,null,null,"CPI_RL-MUL",4]
[null,null,null,null,null,"CPI_RL-PR",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase d'ensemencement","1INR_ENS",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase secondaire ou d'abri","1INR_SEC",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel multiples phases","1INR_MUL",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 2 interventions multiples phases","2I_MUL",4]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 3 interventions multiples phases","3I_MUL",4]
[null,null,"Par bandes ou par trouées","Jardinée / gestion avec cohortes juxtaposées","Coupe de jardinage par bande avec éclaircie dans la matrice résiduelle","CJB-EMR",4]
[null,null,null,null,"Coupe de jardinage par troués avec éclaircie dans la matrice résiduelle","CJT-EMR",4]
[null,null,null,"Régulière","Coupe progressive régulière par bandes ou trouées","CPR_BA",4]
[null,null,null,null,null,"CPR_T",4]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",4]
[null,null,null,null,null,"CPI_RL-2I_SEC",4]
[null,null,null,null,null,"CPI_RL-3I_ENS",4]
[null,null,null,null,null,"CPI_RL-3I_SEC",4]
[null,null,null,null,null,"CPI_RL-MUL",4]
[null,null,null,null,null,"CPI_RL-PR",4]
["Feuillus tolérants, autres résineux et mixtes à tendance feuillue","Opérateur","Uniforme","Régulière","Coupe progressive régulière","CPR_U-PR",5]
[null,null,null,null,null,"CPR_U-ENS",5]
[null,null,null,null,null,"CPR_U_SEC",5]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent","CPI_CP-ENS_U",5]
[null,null,null,null,null,"CPI_CP-SEC_U",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",5]
[null,null,null,null,null,"CPI_RL-2I_SEC",5]
[null,null,null,null,null,"CPI_RL-3I_ENS",5]
[null,null,null,null,null,"CPI_RL-3I_SEC",5]
[null,null,null,null,null,"CPI_RL-MUL",5]
[null,null,null,null,null,"CPI_RL-PR",5]
[null,null,"Par bandes ou par trouées","Jardinée / gestion avec cohortes juxtaposées","Coupe de jardinage par bande avec éclaircie dans la matrice résiduelle","CJB-EMR",5]
[null,null,null,null,"Coupe de jardinage par troués avec éclaircie dans la matrice résiduelle","CJT-EMR",5]
[null,null,null,"Régulière","Coupe progressive régulière par bandes ou trouées","CPR_BA",5]
[null,null,null,null,null,"CPR_T",5]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",5]
[null,null,null,null,null,"CPI_RL-2I_SEC",5]
[null,null,null,null,null,"CPI_RL-3I_ENS",5]
[null,null,null,null,null,"CPI_RL-3I_SEC",5]
[null,null,null,null,null,"CPI_RL-MUL",5]
[null,null,null,null,null,"CPI_RL-PR",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase d'ensemencement","1INR_ENS",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase secondaire ou d'abri","1INR_SEC",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel multiples phases","1INR_MUL",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 2 interventions multiples phases","2I_MUL",5]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 3 interventions multiples phases","3I_MUL",5]
["SEPM, mixtes à tendance résineuse  et feuillus intolérants","Opérateur","Uniforme","Régulière","Coupe progressive régulière","CPR_U-PR",6]
[null,null,null,null,null,"CPR_U-ENS",6]
[null,null,null,null,null,"CPR_U_SEC",6]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent","CPI_CP-ENS_U",6]
[null,null,null,null,null,"CPI_CP-SEC_U",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",6]
[null,null,null,null,null,"CPI_RL-2I_SEC",6]
[null,null,null,null,null,"CPI_RL-3I_ENS",6]
[null,null,null,null,null,"CPI_RL-3I_SEC",6]
[null,null,null,null,null,"CPI_RL-MUL",6]
[null,null,null,null,null,"CPI_RL-PR",6]
[null,null,"Par bandes ou par trouées","Régulière","Coupe progressive régulière par bandes ou trouées","CPR_BA",6]
[null,null,null,null,null,"CPR_T",6]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent par bandes","CPI_CP-ENS_B",6]
[null,null,null,null,null,"CPI_CP-SEC_B",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",6]
[null,null,null,null,null,"CPI_RL-2I_SEC",6]
[null,null,null,null,null,"CPI_RL-3I_ENS",6]
[null,null,null,null,null,"CPI_RL-3I_SEC",6]
[null,null,null,null,null,"CPI_RL-MUL",6]
[null,null,null,null,null,"CPI_RL-PR",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase d'ensemencement","1INR_ENS",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase secondaire ou d'abri","1INR_SEC",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel multiples phases","1INR_MUL",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 2 interventions multiples phases","2I_MUL",6]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 3 interventions multiples phases","3I_MUL",6]
["SEPM, mixtes à tendance résineuse  et feuillus intolérants","Martelage","Uniforme","Régulière","Coupe progressive régulière","CPR_U-PR",7]
[null,null,null,null,null,"CPR_U-ENS",7]
[null,null,null,null,null,"CPR_U_SEC",7]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent","CPI_CP-ENS_U",7]
[null,null,null,null,null,"CPI_CP-SEC_U",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",7]
[null,null,null,null,null,"CPI_RL-2I_SEC",7]
[null,null,null,null,null,"CPI_RL-3I_ENS",7]
[null,null,null,null,null,"CPI_RL-3I_SEC",7]
[null,null,null,null,null,"CPI_RL-MUL",7]
[null,null,null,null,null,"CPI_RL-PR",7]
[null,null,"Par bandes ou par trouées","Régulière","Coupe progressive régulière par bandes ou trouées","CPR_BA",7]
[null,null,null,null,null,"CPR_T",7]
[null,null,null,"Irrégulière","Coupe progressive irrégulière à couvert permanent par bandes","CPI_CP-ENS_B",7]
[null,null,null,null,null,"CPI_CP-SEC_B",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente","CPI_RL-2I_ENS",7]
[null,null,null,null,null,"CPI_RL-2I_SEC",7]
[null,null,null,null,null,"CPI_RL-3I_ENS",7]
[null,null,null,null,null,"CPI_RL-3I_SEC",7]
[null,null,null,null,null,"CPI_RL-MUL",7]
[null,null,null,null,null,"CPI_RL-PR",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase d'ensemencement","1INR_ENS",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel phase secondaire ou d'abri","1INR_SEC",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 1 intervention et abandon du volume résiduel multiples phases","1INR_MUL",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 2 interventions multiples phases","2I_MUL",7]
[null,null,null,null,"Coupe progressive irrégulière à régénération lente en 3 interventions multiples phases","3I_MUL",7]

{"sheet":"Réductions zones-bandes","index":3,"n_rows":58,"n_cols":40,"rows_kept":58,"cut":false,"hidden":false,"merged":[[17,11,17,12],[0,0,0,26],[3,0,3,1],[4,0,5,1],[7,0,7,1],[11,1,11,9],[11,22,11,36],[12,44,13,48],[14,13,14,16],[14,39,14,42],[15,11,15,12],[16,11,16,12],[39,10,39,11],[39,22,39,36],[18,31,18,32],[29,23,29,24],[29,25,29,26],[29,27,29,28],[29,29,29,32],[29,33,29,35],[33,1,33,15],[33,26,33,30],[34,26,35,30],[36,18,36,20],[18,11,18,12],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,11],[50,12,50,14],[40,44,41,48],[42,39,42,42],[43,4,46,16],[46,31,46,32],[48,31,48,32],[62,30,62,33],[57,23,57,24],[57,25,57,26],[57,27,57,28],[57,29,57,32],[57,33,57,35],[59,21,59,27]]}
["Coupes partielles : exemples de calculs de réductions pour bandes ou zones non traitées"]
[]
["Définition des termes utilisés dans la feuille de calcul :"]
["Bandes* :",null,"Forme étroite et allongée donnée par une coupe qui traverse toute la largeur ou la longueur d'un peuplement ou d'un secteur d'intervention"]
[null,null,"Note 1 : Une bande peut être coupée totalement, coupée partiellement ou résiduelle (non coupée)"]
[null,null,"Note 2 : La largeur d'une bande équivaut minimalement à la demi-hauteur d'un arbre mature (généralement, 10 mètres et plus)"]
[null,null,"*Inspiré du glossaire du Guide sylvicole du Québec"]
["Zones :",null,"Même définition que le terme bande à l'exception du non-respect de la largeur minimale (moins de 10 mètres)"]
[]
["1er cas : Coupe progressive uniforme (avec zones non traitées de moins de 10 mètres de largeur)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2e cas : Coupe progressive par bandes (plus de 10 mètres de largeur)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande partiellement récoltée (15 m)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande partiellement récoltée (15m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande entièrement récoltée (0 m)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande entièrement récoltée (0 m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Zone non traitée (5 m)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande non traitée (15m)"]
[null,null,null,"5m         5m",null,"5m         5m",null,"5m         5m",null,null,null,null,null,"Sentier de débardage (maintenant inclus dans la largeur de la bande)",null,null,null,null,null,null,null,null,null,null,null,"5m","5m",null,null,"5m",null,"5m",null,null,null,null,null,null,null,"Sentier de débardage (maintenant inclus dans la largeur de la bande)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BP : Largeur de la zone ou bande partiellement récoltée (m) : 15 m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BP : Largeur de la zone ou bande partiellement récoltée (m) : 15 m"]
[null,null,null,null,null,null,null,null,null,null,null,"BE : Largeur de la zone ou bande entièrement récoltée (m) : 0 m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BE : Largeur de la zone ou bande entièrement récoltée (m) : 0 m"]
[null,null,null,null,null,null,null,null,null,null,null,"ZNT : Largeur de la zone ou bande non traitée (m) : 5 m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZNT : Largeur de la zone ou bande non traitée (m) : 15 m"]
[null,null,null,null,null,null,null,null,null,null,null,"Résultat : réduction du taux de 10%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résultat : réduction du taux de 30%"]
[]
[]
[]
[]
[null,null,"5m","I--15 m--I","5m","I--15 m--I","5m","I--15 m--I","5m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 m",null,"I-----15 m-----I",null,"15 m",null,"I-----15 m-----I",null,null,null,"15 m"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul de la réduction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"À inscrire dans la feuille de calcul : cellules G47, G48 et G49"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3e cas : Coupe totale par bandes alternes (plus de 10 mètres de largeur)"]
[]
[]
[]
[]
[null,null,null,null,"Non financé, aucune coupe partielle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande entièrement récoltée (15m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bande non traitée (15m)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sentier de débardage (maintenant inclus dans la largeur de la bande)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5m","5m",null,null,"5m",null,"5m",null,null,null,null,null,null,"BP : Largeur de la zone ou bande partiellement récoltée (m) : 0 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BE : Largeur de la zone ou bande entièrement récoltée (m) : 15 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZNT : Largeur de la zone ou bande non traitée (m) : 15 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résultat : non financé"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 m",null,"I-----15 m-----I",null,"15 m",null,"I-----15 m-----I",null,null,null,"15 m"]

{"sheet":"Versions du fichier","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,16],[8,2,8,16],[9,2,9,15],[14,2,14,16],[18,2,18,16]]}
["Suivi des versions du fichier de l’annexe au rapport et au calcul des taux d'investissement pour les coupes partielles et de l'aide supplémentaire à l'aménagement des forêts feuillues et mixtes 2017-2018"]
[]
["Version 1","Nom du fichier :","Calcul_de_l_aide_financiere_2017-2018_Consultation_2017-03-22.xlsm"]
[null,"Date de mise en ligne :"," 2017-03-22"]
[null,"Remarques :","• Version initiale proposée pour la période de consultation"]
[]
["Version 2","Nom du fichier :","Calcul_de_l_aide_financiere_2017-2018_2017-04-27.xlsm"]
[null,"Date de mise en ligne :"," 2017-04-27"]
[null,"Remarques :","• Onglet «Calcul des taux (formules)», formule 1 et 2 : Correction d'une coquille dans la formule présentant la valeur «Total à payer ($/ha)» inscrites à G84 et G101"]
[null,null,"• Le cas d'utilisation «Copier un onglet» est géré pour les onglets «Calcul des taux (formules)» et «Aide suppl. (volets I et II)». Les onglets copiés fonctionnent de la même manière que l'onglet natif (calculs et boutons)"]
[null,null,"• Onglet «Calcul des taux (formules)», un plancher d'investissement de 39$/ha a été mis en place pour toutes les formules"]
[]
["Version 3","Nom du fichier :","Calcul_de_l_aide_financiere_2017-2018_2017-06-27.xlsm"]
[null,"Date de mise en ligne :","2017-06-27"]
[null,"Remarques :","• Modifications afin de permettre trois contextes d'utilisation : Planification, BGAD et Ministère"]
[]
["Version 4","Nom du fichier :","Calcul_de_l_aide_financiere_2017-2018_2017-08-08.xlsm"]
[null,"Date de mise en ligne :","2017-08-08"]
[null,"Remarques :","• Modifications afin de permettre l'utilisation de deux décimales pour les superficies des volets I et II"]

{"sheet":"Menus","index":5,"n_rows":566,"n_cols":6,"rows_kept":566,"cut":false,"hidden":true,"merged":[]}
["Question"]
["Oui"]
["Non"]
[]
[]
["UA"]
["01151"]
["01152"]
["01251"]
["01252"]
["01253"]
["01254"]
["02251"]
["02351"]
["02352"]
["02451"]
["02452"]
["02551"]
["02651"]
["02661"]
["02662"]
["02663"]
["02664"]
["02665"]
["02666"]
["02751"]
["03151"]
["03152"]
["03153"]
["03351"]
["03451"]
["03453"]
["03551"]
["04151"]
["04251"]
["04351"]
["04352"]
["05151"]
["06151"]
["06152"]
["06251"]
["06252"]
["06451"]
["06452"]
["07151"]
["07152"]
["07251"]
["07351"]
["07352"]
["07451"]
["08151"]
["08152"]
["08251"]
["08351"]
["08451"]
["08462"]
["08551"]
["08562"]
["08651"]
["08652"]
["08663"]
["08664"]
["08665"]
["08666"]
["08751"]
["08762"]
["08763"]
["08764"]
["09351"]
["09352"]
["09451"]
["09452"]
["09551"]
["09751"]
["11161"]
["11262"]
["11263"]
[]
[]
["Codes_Dica"]
["1INR_ENS"]
["1INR_SEC"]
["1INR_MUL"]
["2I_MUL"]
["3I_MUL"]
["CJB-EMR"]
["CJP-AM"]
["CJP-HQ"]
["CJP-QM"]
["CJPG-AM"]
["CJPG-HQ"]
["CJPG-QM"]
["CJT-EMR"]
["CPI_CP-ENS_B"]
["CPI_CP-ENS_U"]
["CPI_CP-SEC_B"]
["CPI_CP-SEC_U"]
["CPI_RL-2I_ENS"]
["CPI_RL-2I_SEC"]
["CPI_RL-3I_ENS"]
["CPI_RL-3I_SEC"]
["CPI_RL-MUL"]
["CPI_RL-PR"]
["CPR_BA"]
["CPR_T"]
["CPR_U-ENS"]
["CPR_U-PR"]
["CPR_U_SEC"]
["EC_MIXTE-BAS"]
["EC_MIXTE-HAUT"]
["EC_MIXTE-NEUTRE"]
["EC_SEL-BAS"]
["EC_SEL-HAUT"]
["EC_SEL-NEUTRE"]
["EJ_P-CLAS"]
["EJ_P-INI"]
["EJ_PG-CLAS"]
["EJ_PG-INI"]
["Inscrire une valeur"]
[]
[]
["Codes_RATF"]
["CJBM"]
["CJBMO"]
["CJPAM"]
["CJPGAM"]
["CJPGHQ"]
["CJPGQM"]
["CJPHQ"]
["CJPQM"]
["CJTM"]
["CJTMO"]
["CPIENSBMSF"]
["CPIENSBOSF"]
["CPIL2ENOFM"]
["CPIL2ENOSF"]
["CPIL2SEOFM"]
["CPIL2SEOSF"]
["CPIL3ENOFM"]
["CPIL3ENOSF"]
["CPIL3SEOFM"]
["CPIL3SEOSF"]
["CPILMULOFM"]
["CPILMULOSF"]
["CPIRL2EN"]
["CPIRL2ENFM"]
["CPIRL2ENSF"]
["CPIRL2SE"]
["CPIRL2SEFM"]
["CPIRL2SESF"]
["CPIRL3EN"]
["CPIRL3ENFM"]
["CPIRL3ENSF"]
["CPIRL3SE"]
["CPIRL3SEFM"]
["CPIRL3SESF"]
["CPIRLMUL"]
["CPIRLMULFM"]
["CPIRLMULSF"]
["CPIRLPR"]
["CPIRLPRFM"]
["CPIRLPROFM"]
["CPIRLPROSF"]
["CPIRLPRSF"]
["CPISECBMSF"]
["CPISECBOSF"]
["CPIUENS"]
["CPIUENSFM"]
["CPIUENSOFM"]
["CPIUENSOSF"]
["CPIUENSSF"]
["CPIUSEC"]
["CPIUSECFM"]
["CPIUSECOFM"]
["CPIUSECOSF"]
["CPIUSECSF"]
["CPRBAMFM"]
["CPRBAMSF"]
["CPRBAOFM"]
["CPRBAOSF"]
["CPRTMFM"]
["CPRTMSF"]
["CPRTOFM"]
["CPRTOSF"]
["CPRUENS"]
["CPRUENSFM"]
["CPRUENSOFM"]
["CPRUENSOSF"]
["CPRUENSSF"]
["CPRUPR"]
["CPRUPRFM"]
["CPRUPROFM"]
["CPRUPROSF"]
["CPRUPRSF"]
["CPRUSEC"]
["CPRUSECFM"]
["CPRUSECOFM"]
["CPRUSECOSF"]
["CPRUSECSF"]
["ECMIXBASPR"]
["ECMIXHAUPR"]
["ECMIXNEUPR"]
["ECSELBASPR"]
["ECSELHAUPR"]
["ECSELNEUPR"]
["EJPCLAS"]
["EJPGCLAS"]
["EJPGINI"]
["EJPINI"]
["Inscrire une valeur"]
[]
[]
["Identification des tiges à récolter","Indirect","Valeur_menu_déroulant"]
["Formule 1","Selection_Formule_1","Sans objet"]
["Formule 2","Selection_Formule_2","Sans objet"]
["Formule 4","Selection_Formule_4","Martelage"]
["Formule 5","Selection_Formule_5","Opérateur"]
["Formule 6","Selection_Formule_6","Opérateur"]
["Formule 7","Selection_Formule_7","Martelage"]
[]
[]
["H1"]
["AVEC hébergement",3.2000000000000001E-2]
["SANS hébergement",0]
[]
[]
["MAN"]
["Opérations MANUELLES",0.36,"Majoration_MAN_F1"]
["Opérations MÉCANISÉES",0,"Majoration_MAN_F1"]
["Sans objet",0,"Majoration_MAN_DIFF_F1"]
[]
[]
["RUB"]
["Pas de rubannage des sentiers"]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[]
[]
["Formules"]
["Formule 1"]
["Formule 2"]
["Formule 4"]
["Formule 5"]
["Formule 6"]
["Formule 7"]
["Inscrire une valeur"]
[]
[]
["Code_DICA_vs_Formules","Formule_fin",null,"Valeur_pour_Indirect","DICA_sans_caractères_spéciaux","Indirect"]
["CJB-EMR",4,"Formule_4_CJB-EMR","Formule 4","CJB_EMR","F_CJB_EMR"]
["CJB-EMR",5,"Formule_5_CJB-EMR","Formule 5","CJB_EMR","F_CJB_EMR"]
["CJP-AM",4,"Formule_4_CJP-AM","Formule 4","CJP_AM","F_CJP_AM"]
["CJPG-AM",4,"Formule_4_CJPG-AM","Formule 4","CJPG_AM","F_CJPG_AM"]
["CJPG-HQ",4,"Formule_4_CJPG-HQ","Formule 4","CJPG_HQ","F_CJPG_HQ"]
["CJPG-QM",4,"Formule_4_CJPG-QM","Formule 4","CJPG_QM","F_CJPG_QM"]
["CJP-HQ",4,"Formule_4_CJP-HQ","Formule 4","CJP_HQ","F_CJP_HQ"]
["CJP-QM",4,"Formule_4_CJP-QM","Formule 4","CJP_QM","F_CJP_QM"]
["CJT-EMR",4,"Formule_4_CJT-EMR","Formule 4","CJT_EMR","F_CJT_EMR"]
["CJT-EMR",5,"Formule_5_CJT-EMR","Formule 5","CJT_EMR","F_CJT_EMR"]
["CPI_CP-ENS_B",6,"Formule_6_CPI_CP-ENS_B","Formule 6","CPI_CP_ENS_B","F_CPI_CP_ENS_B"]
["CPI_CP-ENS_B",7,"Formule_7_CPI_CP-ENS_B","Formule 7","CPI_CP_ENS_B","F_CPI_CP_ENS_B"]
["CPI_CP-ENS_U",4,"Formule_4_CPI_CP-ENS_U","Formule 4","CPI_CP_ENS_U","F_CPI_CP_ENS_U"]
["CPI_CP-ENS_U",5,"Formule_5_CPI_CP-ENS_U","Formule 5","CPI_CP_ENS_U","F_CPI_CP_ENS_U"]
["CPI_CP-ENS_U",6,"Formule_6_CPI_CP-ENS_U","Formule 6","CPI_CP_ENS_U","F_CPI_CP_ENS_U"]
["CPI_CP-ENS_U",7,"Formule_7_CPI_CP-ENS_U","Formule 7","CPI_CP_ENS_U","F_CPI_CP_ENS_U"]
["CPI_CP-SEC_B",6,"Formule_6_CPI_CP-SEC_B","Formule 6","CPI_CP_SEC_B","F_CPI_CP_SEC_B"]
["CPI_CP-SEC_B",7,"Formule_7_CPI_CP-SEC_B","Formule 7","CPI_CP_SEC_B","F_CPI_CP_SEC_B"]
["CPI_CP-SEC_U",4,"Formule_4_CPI_CP-SEC_U","Formule 4","CPI_CP_SEC_U","F_CPI_CP_SEC_U"]
["CPI_CP-SEC_U",5,"Formule_5_CPI_CP-SEC_U","Formule 5","CPI_CP_SEC_U","F_CPI_CP_SEC_U"]
["CPI_CP-SEC_U",6,"Formule_6_CPI_CP-SEC_U","Formule 6","CPI_CP_SEC_U","F_CPI_CP_SEC_U"]
["CPI_CP-SEC_U",7,"Formule_7_CPI_CP-SEC_U","Formule 7","CPI_CP_SEC_U","F_CPI_CP_SEC_U"]
["CPI_RL-2I_ENS",4,"Formule_4_CPI_RL-2I_ENS","Formule 4","CPI_RL_2I_ENS","F_CPI_RL_2I_ENS"]
["CPI_RL-2I_ENS",5,"Formule_5_CPI_RL-2I_ENS","Formule 5","CPI_RL_2I_ENS","F_CPI_RL_2I_ENS"]
["CPI_RL-2I_ENS",6,"Formule_6_CPI_RL-2I_ENS","Formule 6","CPI_RL_2I_ENS","F_CPI_RL_2I_ENS"]
["CPI_RL-2I_ENS",7,"Formule_7_CPI_RL-2I_ENS","Formule 7","CPI_RL_2I_ENS","F_CPI_RL_2I_ENS"]
["CPI_RL-2I_SEC",4,"Formule_4_CPI_RL-2I_SEC","Formule 4","CPI_RL_2I_SEC","F_CPI_RL_2I_SEC"]
["CPI_RL-2I_SEC",5,"Formule_5_CPI_RL-2I_SEC","Formule 5","CPI_RL_2I_SEC","F_CPI_RL_2I_SEC"]
["CPI_RL-2I_SEC",6,"Formule_6_CPI_RL-2I_SEC","Formule 6","CPI_RL_2I_SEC","F_CPI_RL_2I_SEC"]
["CPI_RL-2I_SEC",7,"Formule_7_CPI_RL-2I_SEC","Formule 7","CPI_RL_2I_SEC","F_CPI_RL_2I_SEC"]
["CPI_RL-3I_ENS",4,"Formule_4_CPI_RL-3I_ENS","Formule 4","CPI_RL_3I_ENS","F_CPI_RL_3I_ENS"]
["CPI_RL-3I_ENS",5,"Formule_5_CPI_RL-3I_ENS","Formule 5","CPI_RL_3I_ENS","F_CPI_RL_3I_ENS"]
["CPI_RL-3I_ENS",6,"Formule_6_CPI_RL-3I_ENS","Formule 6","CPI_RL_3I_ENS","F_CPI_RL_3I_ENS"]
["CPI_RL-3I_ENS",7,"Formule_7_CPI_RL-3I_ENS","Formule 7","CPI_RL_3I_ENS","F_CPI_RL_3I_ENS"]
["CPI_RL-3I_SEC",4,"Formule_4_CPI_RL-3I_SEC","Formule 4","CPI_RL_3I_SEC","F_CPI_RL_3I_SEC"]
["CPI_RL-3I_SEC",5,"Formule_5_CPI_RL-3I_SEC","Formule 5","CPI_RL_3I_SEC","F_CPI_RL_3I_SEC"]
["CPI_RL-3I_SEC",6,"Formule_6_CPI_RL-3I_SEC","Formule 6","CPI_RL_3I_SEC","F_CPI_RL_3I_SEC"]
["CPI_RL-3I_SEC",7,"Formule_7_CPI_RL-3I_SEC","Formule 7","CPI_RL_3I_SEC","F_CPI_RL_3I_SEC"]
["CPI_RL-MUL",4,"Formule_4_CPI_RL-MUL","Formule 4","CPI_RL_MUL","F_CPI_RL_MUL"]
["CPI_RL-MUL",5,"Formule_5_CPI_RL-MUL","Formule 5","CPI_RL_MUL","F_CPI_RL_MUL"]
["CPI_RL-MUL",6,"Formule_6_CPI_RL-MUL","Formule 6","CPI_RL_MUL","F_CPI_RL_MUL"]
["CPI_RL-MUL",7,"Formule_7_CPI_RL-MUL","Formule 7","CPI_RL_MUL","F_CPI_RL_MUL"]
["CPI_RL-PR",4,"Formule_4_CPI_RL-PR","Formule 4","CPI_RL_PR","F_CPI_RL_PR"]
["CPI_RL-PR",5,"Formule_5_CPI_RL-PR","Formule 5","CPI_RL_PR","F_CPI_RL_PR"]
["CPI_RL-PR",6,"Formule_6_CPI_RL-PR","Formule 6","CPI_RL_PR","F_CPI_RL_PR"]
["CPI_RL-PR",7,"Formule_7_CPI_RL-PR","Formule 7","CPI_RL_PR","F_CPI_RL_PR"]
["CPR_BA",4,"Formule_4_CPR_BA","Formule 4","CPR_BA","F_CPR_BA"]
["CPR_BA",5,"Formule_5_CPR_BA","Formule 5","CPR_BA","F_CPR_BA"]
["CPR_BA",6,"Formule_6_CPR_BA","Formule 6","CPR_BA","F_CPR_BA"]
["CPR_BA",7,"Formule_7_CPR_BA","Formule 7","CPR_BA","F_CPR_BA"]
["CPR_T",4,"Formule_4_CPR_T","Formule 4","CPR_T","F_CPR_T"]
["CPR_T",5,"Formule_5_CPR_T","Formule 5","CPR_T","F_CPR_T"]
["CPR_T",6,"Formule_6_CPR_T","Formule 6","CPR_T","F_CPR_T"]
["CPR_T",7,"Formule_7_CPR_T","Formule 7","CPR_T","F_CPR_T"]
["CPR_U_SEC",4,"Formule_4_CPR_U_SEC","Formule 4","CPR_U_SEC","F_CPR_U_SEC"]
["CPR_U_SEC",5,"Formule_5_CPR_U_SEC","Formule 5","CPR_U_SEC","F_CPR_U_SEC"]
["CPR_U_SEC",6,"Formule_6_CPR_U_SEC","Formule 6","CPR_U_SEC","F_CPR_U_SEC"]
["CPR_U_SEC",7,"Formule_7_CPR_U_SEC","Formule 7","CPR_U_SEC","F_CPR_U_SEC"]
["CPR_U-ENS",4,"Formule_4_CPR_U-ENS","Formule 4","CPR_U_ENS","F_CPR_U_ENS"]
["CPR_U-ENS",5,"Formule_5_CPR_U-ENS","Formule 5","CPR_U_ENS","F_CPR_U_ENS"]
["CPR_U-ENS",6,"Formule_6_CPR_U-ENS","Formule 6","CPR_U_ENS","F_CPR_U_ENS"]
["CPR_U-ENS",7,"Formule_7_CPR_U-ENS","Formule 7","CPR_U_ENS","F_CPR_U_ENS"]
["CPR_U-PR",4,"Formule_4_CPR_U-PR","Formule 4","CPR_U_PR","F_CPR_U_PR"]
["CPR_U-PR",5,"Formule_5_CPR_U-PR","Formule 5","CPR_U_PR","F_CPR_U_PR"]
["CPR_U-PR",6,"Formule_6_CPR_U-PR","Formule 6","CPR_U_PR","F_CPR_U_PR"]
["CPR_U-PR",7,"Formule_7_CPR_U-PR","Formule 7","CPR_U_PR","F_CPR_U_PR"]
["EC_MIXTE-BAS",1,"Formule_1_EC_MIXTE-BAS","Formule 1","EC_MIXTE_BAS","F_EC_MIXTE_BAS"]
["EC_MIXTE-BAS",2,"Formule_2_EC_MIXTE-BAS","Formule 2","EC_MIXTE_BAS","F_EC_MIXTE_BAS"]
["EC_MIXTE-HAUT",1,"Formule_1_EC_MIXTE-HAUT","Formule 1","EC_MIXTE_HAUT","F_EC_MIXTE_HAUT"]
["EC_MIXTE-HAUT",2,"Formule_2_EC_MIXTE-HAUT","Formule 2","EC_MIXTE_HAUT","F_EC_MIXTE_HAUT"]
["EC_MIXTE-NEUTRE",1,"Formule_1_EC_MIXTE-NEUTRE","Formule 1","EC_MIXTE_NEUTRE","F_EC_MIXTE_NEUTRE"]
["EC_MIXTE-NEUTRE",2,"Formule_2_EC_MIXTE-NEUTRE","Formule 2","EC_MIXTE_NEUTRE","F_EC_MIXTE_NEUTRE"]
["EC_SEL-BAS",1,"Formule_1_EC_SEL-BAS","Formule 1","EC_SEL_BAS","F_EC_SEL_BAS"]
["EC_SEL-BAS",2,"Formule_2_EC_SEL-BAS","Formule 2","EC_SEL_BAS","F_EC_SEL_BAS"]
["EC_SEL-HAUT",1,"Formule_1_EC_SEL-HAUT","Formule 1","EC_SEL_HAUT","F_EC_SEL_HAUT"]
["EC_SEL-HAUT",2,"Formule_2_EC_SEL-HAUT","Formule 2","EC_SEL_HAUT","F_EC_SEL_HAUT"]
["EC_SEL-NEUTRE",1,"Formule_1_EC_SEL-NEUTRE","Formule 1","EC_SEL_NEUTRE","F_EC_SEL_NEUTRE"]
["EC_SEL-NEUTRE",2,"Formule_2_EC_SEL-NEUTRE","Formule 2","EC_SEL_NEUTRE","F_EC_SEL_NEUTRE"]
["EJ_P-CLAS",4,"Formule_4_EJ_P-CLAS","Formule 4","EJ_P_CLAS","F_EJ_P_CLAS"]
["EJ_PG-CLAS",4,"Formule_4_EJ_PG-CLAS","Formule 4","EJ_PG_CLAS","F_EJ_PG_CLAS"]
["EJ_PG-INI",4,"Formule_4_EJ_PG-INI","Formule 4","EJ_PG_INI","F_EJ_PG_INI"]
["EJ_P-INI",4,"Formule_4_EJ_P-INI","Formule 4","EJ_P_INI","F_EJ_P_INI"]
["1INR_ENS",4,"Formule_4_1INR_ENS","Formule 4","1INR_ENS","F_1INR_ENS"]
["1INR_ENS",5,"Formule_5_1INR_ENS","Formule 5","1INR_ENS","F_1INR_ENS"]
["1INR_ENS",6,"Formule_6_1INR_ENS","Formule 6","1INR_ENS","F_1INR_ENS"]
["1INR_ENS",7,"Formule_7_1INR_ENS","Formule 7","1INR_ENS","F_1INR_ENS"]
["1INR_SEC",4,"Formule_4_1INR_SEC","Formule 4","1INR_SEC","F_1INR_SEC"]
["1INR_SEC",5,"Formule_5_1INR_SEC","Formule 5","1INR_SEC","F_1INR_SEC"]
["1INR_SEC",6,"Formule_6_1INR_SEC","Formule 6","1INR_SEC","F_1INR_SEC"]
["1INR_SEC",7,"Formule_7_1INR_SEC","Formule 7","1INR_SEC","F_1INR_SEC"]
["1INR_MUL",4,"Formule_4_1INR_MUL","Formule 4","1INR_MUL","F_1INR_MUL"]
["1INR_MUL",5,"Formule_5_1INR_MUL","Formule 5","1INR_MUL","F_1INR_MUL"]
["1INR_MUL",6,"Formule_6_1INR_MUL","Formule 6","1INR_MUL","F_1INR_MUL"]
["1INR_MUL",7,"Formule_7_1INR_MUL","Formule 7","1INR_MUL","F_1INR_MUL"]
["2I_MUL",4,"Formule_4_2I_MUL","Formule 4","2I_MUL","F_2I_MUL"]
["2I_MUL",5,"Formule_5_2I_MUL","Formule 5","2I_MUL","F_2I_MUL"]
["2I_MUL",6,"Formule_6_2I_MUL","Formule 6","2I_MUL","F_2I_MUL"]
["2I_MUL",7,"Formule_7_2I_MUL","Formule 7","2I_MUL","F_2I_MUL"]
["3I_MUL",4,"Formule_4_3I_MUL","Formule 4","3I_MUL","F_3I_MUL"]
["3I_MUL",5,"Formule_5_3I_MUL","Formule 5","3I_MUL","F_3I_MUL"]
["3I_MUL",6,"Formule_6_3I_MUL","Formule 6","3I_MUL","F_3I_MUL"]
["3I_MUL",7,"Formule_7_3I_MUL","Formule 7","3I_MUL","F_3I_MUL"]
[null,1,"Formule_1_Utilisateur","Formule 1","Utilisateur","F_Utilisateur"]
[null,2,"Formule_2_Utilisateur","Formule 2","Utilisateur","F_Utilisateur"]
[null,4,"Formule_4_Utilisateur","Formule 4","Utilisateur","F_Utilisateur"]
[null,5,"Formule_5_Utilisateur","Formule 5","Utilisateur","F_Utilisateur"]
[null,6,"Formule_6_Utilisateur","Formule 6","Utilisateur","F_Utilisateur"]
[null,7,"Formule_7_Utilisateur","Formule 7","Utilisateur","F_Utilisateur"]
[]
[]
["Zone de tarification","Taux"]
[151,0]
[152,0]
[153,0]
[154,0]
[155,0]
[156,0]
[157,0]
[158,0]
[180,0]
[181,60]
[182,0]
[183,0]
[184,200]
[185,80]
[186,60]
[187,140]
[190,240]
[191,220]
[192,140]
[193,80]
[194,20]
[195,0]
[240,0]
[241,60]
[242,160]
[243,160]
[244,240]
[245,240]
[246,260]
[247,280]
[250,280]
[251,280]
[252,280]
[253,280]
[254,280]
[255,120]
[256,200]
[257,280]
[258,280]
[259,280]
[260,280]
[261,280]
[262,280]
[263,280]
[264,280]
[265,280]
[266,180]
[267,280]
[268,280]
[269,280]
[270,280]
[271,280]
[272,280]
[273,280]
[274,280]
[275,280]
[276,280]
[277,280]
[278,280]
[279,280]
[280,280]
[281,280]
[282,280]
[283,280]
[284,280]
[285,280]
[286,280]
[287,280]
[288,280]
[289,280]
[290,280]
[291,280]
[292,280]
[350,20]
[351,0]
[352,20]
[353,40]
[354,120]
[355,200]
[356,260]
[357,260]
[450,80]
[451,0]
[452,0]
[453,0]
[454,0]
[455,0]
[456,0]
[457,0]
[458,60]
[459,60]
[460,200]
[461,260]
[551,0]
[650,0]
[651,60]
[652,200]
[653,140]
[654,200]
[655,40]
[656,140]
[657,140]
[658,220]
[659,280]
[660,160]
[661,40]
[662,0]
[750,0]
[751,40]
[752,220]
[753,280]
[754,100]
[755,60]
[756,280]
[757,280]
[758,280]
[850,0]
[851,0]
[852,0]
[853,0]
[854,0]
[855,0]
[856,100]
[857,100]
[858,100]
[859,180]
[860,280]
[861,220]
[862,280]
[863,280]
[864,280]
[865,280]
[866,280]
[867,280]
[868,280]
[869,280]
[870,280]
[871,280]
[872,280]
[873,280]
[874,280]
[875,280]
[876,280]
[877,280]
[878,280]
[879,280]
[880,280]
[881,280]
[882,280]
[883,280]
[884,280]
[885,280]
[886,280]
[887,280]
[888,280]
[889,280]
[890,280]
[891,280]
[892,280]
[950,280]
[951,280]
[952,280]
[953,280]
[954,280]
[955,280]
[956,280]
[957,280]
[960,280]
[961,280]
[962,280]
[963,280]
[964,280]
[965,280]
[966,280]
[967,280]
[970,280]
[980,280]
[981,280]
[982,280]
[983,280]
[984,280]
[985,280]
[986,280]
[987,280]
[990,280]
[995,0]
[]
["Rôles"]
["Planification"]
["BGAD"]
["Ministère"]
["Inscrire une valeur"]
[]
["Question_2"]
["Oui"]
["Non"]
["Sans objet"]

{"sheet":"Majorations applicables","index":6,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Formule","M1","M2","M3","M4","M5","Total"]
["Formule 1","MAN","RUB1","H1","PE2",null,{"$f":"B2&\" - \"&C2&\" - \"&D2&\" - \"&E2","v":"MAN - RUB1 - H1 - PE2"}]
["Formule 2","RUB1","H1","PE2",null,null,{"$f":"B3&\" - \"&C3&\" - \"&D3","v":"RUB1 - H1 - PE2"}]
["Formule 4","EMR1","BNT1","RUB1","H1","PE2",{"$f":"B4&\" - \"&C4&\" - \"&D4&\" - \"&E4&\" - \"&F4","v":"EMR1 - BNT1 - RUB1 - H1 - PE2"}]
["Formule 5","EMR1","BNT1","RUB1","H1","PE2",{"$f":"B5&\" - \"&C5&\" - \"&D5&\" - \"&E5&\" - \"&F5","v":"EMR1 - BNT1 - RUB1 - H1 - PE2"}]
["Formule 6","EMR1","BNT1","H1","PE2",null,{"$f":"B6&\" - \"&C6&\" - \"&D6&\" - \"&E6","v":"EMR1 - BNT1 - H1 - PE2"}]
["Formule 7","EMR1","BNT1","RUB1","H1","PE2",{"$f":"B7&\" - \"&C7&\" - \"&D7&\" - \"&E7&\" - \"&F7","v":"EMR1 - BNT1 - RUB1 - H1 - PE2"}]
["Inscrire une valeur",null,null,null,null,null,"Inscrire une valeur à la cellule I13"]
[]
["PE2"]
["Pente A",{"$f":"(0+1)","v":1}]
["Pente B",{"$f":"(0+1)","v":1}]
["Pente C",{"$f":"(1+0.007)","v":1.0069999999999999}]
["Pente D",{"$f":"(1+0.026)","v":1.026}]
["Pente E",{"$f":"(1+0.061)","v":1.0609999999999999}]
[]
["BNT1"]
["Formule","BNT1 = (0,8 x Pr2) - (1,8 x Pr) + 1"]
["C1",0.8]
["C2",2]
["C3",1.8]
["C4",1]
[]
["RUB1"]
["Formule","1135*ESP-1"]
["C1",1135]
["C2",-1]
[]
["PCT Investissement"]
[0.9]
[]
["Volet I (Transport)"]
[1.776]
[413]
[]
["Volet II"]
["Bois transporté en longueur",45]
["Mesurage  optimisé",75]
[]
["Plancher d'investissement"]
["Travaux techniques",39]