{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Comment remplir","Déclaration_BGAD","Liste_territoire"],"not_rendered":{"images":2,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Comment remplir","index":0,"n_rows":5,"n_cols":2,"rows_kept":5}
[]
[1,"Choisir l'année (cellule C3), l'unité d'aménagement (Cellule C4) et inscrire le numéro du BGAd (Cellule C5);"]
[2,"Inscrire le numéro de client auquel est destiné la MLNU (Colonne C);"]
[3,"Inscrire les volumes attribués à ce client pour chaque catégorie de MLNU (Colonne D à H);"]
[4,"Identification de l'ingénieur forestier et signature profesionelle en B42, F42 et I42"]

{"sheet":"Déclaration_BGAD","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"merged":[[0,0,0,11],[2,0,2,1],[2,2,2,3],[3,0,3,1],[3,2,3,3],[4,0,4,1],[4,2,4,3],[6,3,6,11],[7,3,7,4],[7,5,7,6],[7,7,7,11],[36,1,38,10],[41,1,41,3],[41,5,41,6],[41,8,41,10]]}
["Déclaration professionnelle de la MLNU"]
[]
["Année de récolte :",null,"2021-2022"]
["Unité d'aménagement :"]
["No. Du BGAd :"]
[]
[{"$nulls":3},"Répartition des volumes"]
[{"$nulls":3},"MLNU-RG",null,"MLNU-ND Qualité «U»",null,"MLNU Déclarée"]
["Code Essence","Nom essence","No. Client","Superficies traitées «V»","Superficies non traitées non justifiées «W»","Ententes\nOM MLNU","Entente allègement copeaux","MLNU-ND\nQualité \"X\"","MLNU-RG","MLNU-RG\nQualité \"W\"","MLNU-ND\nQualité \"U\"","Total du Client"]
["010","Épinette (autre que Norvège)",{"$nulls":6},{"$f":"SUM(D10:E10)","v":0},{"$f":"E10","v":0},{"$f":"SUM(F10:G10)","v":0},{"$f":"SUM(H10,I10,K10)","v":0}]
["014","Épinette de Norvège",{"$nulls":6},{"$f":"SUM(D11:E11)","v":0},{"$f":"E11","v":0},0,{"$f":"SUM(H11,I11,K11)","v":0}]
["030","Mélèze laricin",{"$nulls":6},0,0,0,0]
["043","Pin gris et sylvestre",{"$nulls":6},0,0,{"$f":"SUM(F13:G13)","v":0},0]
["060","Sapin baumier",{"$nulls":6},0,0,0,0]
["190","Peuplier (autre que Baumier)",{"$nulls":6},0,0,0,0]
["191","Peuplier baumier",{"$nulls":6},0,0,{"$f":"SUM(F16:G16)","v":0},0]
["105","Bouleau blanc ",{"$nulls":6},0,0,0,0]
["104","Bouleau jaune",{"$nulls":6},0,0,0,0]
["132","Érable à sucre",{"$nulls":6},0,0,0,0]
["133","Érable rouge",{"$nulls":6},0,0,0,0]
["135","Érables - Autres ",{"$nulls":6},0,0,0,0]
["120","Chêne ",{"$nulls":6},0,0,0,0]
["141","Frêne d’Amérique (blanc)",{"$nulls":6},0,0,0,0]
["142","Frêne noir",{"$nulls":6},0,0,0,0]
["150","Hêtre",{"$nulls":6},0,0,0,0]
["160","Noyer",{"$nulls":6},0,0,0,0]
["165","Caryer",{"$nulls":6},0,0,0,0]
["170","Orme",{"$nulls":6},0,0,0,0]
["180","Ostryer de Virginie",{"$nulls":6},0,0,0,0]
["110","Cerisier tardif",{"$nulls":6},0,0,0,0]
["210","Tilleul d’Amérique",{"$nulls":6},0,0,0,0]
["041","Pin blanc",{"$nulls":6},0,0,0,0]
["042","Pin rouge",{"$nulls":6},0,0,0,0]
["050","Pruche de l’Est",{"$nulls":6},0,0,0,0]
["080","Thuya occidental",{"$nulls":6},0,0,0,0]
[]
[null,"Je déclare que les volumes de matière ligneuse non utilisée indiqués à cette déclaration couvrent l'ensemble des secteurs d'intervention de l'UA sous la responsabilité du BGAd indiqué à cette déclaration et que ces volumes sont déterminés en conformité à la règlementation en vigueur et à l'instruction sur la «Gestion des superficies des activités d'aménagement forestier»."]
[]
[]
[]
[null,"Signature :",{"$nulls":3},"Numéro de permis :",null,null,"Date :"]

{"sheet":"Liste_territoire","index":2,"n_rows":149,"n_cols":1,"rows_kept":149}
["01171"]
["01272"]
["02371"]
["02471"]
["02571"]
["02651"]
["02661"]
["02662"]
["02663"]
["02664"]
["02665"]
["02666"]
["02751"]
["03153"]
["03171"]
["03351"]
["03451"]
["03571"]
["04151"]
["04251"]
["04351"]
["04352"]
["05151"]
["06151"]
["06271"]
["06452"]
["06471"]
["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"]
["09471"]
["09551"]
["09751"]
["011001"]
["011050"]
["011070"]
["011071"]
["011072"]
["11161"]
["11262"]
["11263"]
["012050"]
["012051"]
["012070"]
["012071"]
["012072"]
["012073"]
["023050"]
["023070"]
["024070"]
["024071"]
["025050"]
["025051"]
["025070"]
["025071"]
["026002"]
["031050"]
["031051"]
["031071"]
["033070"]
["033071"]
["041070"]
["041071"]
["042001"]
["042050"]
["043001"]
["043002"]
["051001"]
["061070"]
["061071"]
["062070"]
["064050"]
["064070"]
["071070"]
["072070"]
["072071"]
["073001"]
["073050"]
["073070"]
["081002"]
["081003"]
["081005"]
["081006"]
["081007"]
["081008"]
["081009"]
["081011"]
["082002"]
["082003"]
["082004"]
["082050"]
["082051"]
["083001"]
["085002"]
["085003"]
["085004"]
["085005"]
["085006"]
["085007"]
["085008"]
["085009"]
["085010"]
["085011"]
["085012"]
["085013"]
["085082"]
["086001"]
["086002"]
["086003"]
["086004"]
["086005"]
["086050"]
["093050"]
["093070"]
["096001"]
["097050"]
["097070"]
["111001"]
["111002"]
["111003"]
["111070"]
["112001"]
["112002"]
["112003"]
["112050"]
["141082"]