{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Feuille de calcul","Entrée Cépée","Données de base","Essences - Arbres","Essences - Conifères"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":134,"comments":0,"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":"Feuille de calcul","index":0,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,15],[52,7,52,8],[53,7,53,8],[2,5,2,6],[29,14,29,15],[2,7,2,9],[27,14,27,15]]}
["CALCUL DE LA VALEUR COMPENSATOIRE"]
[]
[null,null,null,"Numéro de parcelle :",null,"Personne demandeuse :",null,null,null,null,null,"Date de la demande :"]
[]
[]
["N° d'arbre","Type","Genre","Espèce précise","Situation","Classe","Etat sanitaire","Cépée ?\n(cliquer)","Ø Tronc en cm","Ø Couronne en m","Hauteur en m","Circonférence","Situation","Indice","Etat sanitaire/ressenti sur place","Francs"]
[1,null,null,null,null,{"$f":"IF(D7=\"\",\"\",IF(B7=\"Feuillus\",VLOOKUP(D7,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B7=\"Conifères\",VLOOKUP(D7,'Essences - Conifères'!B3:C130,2,FALSE))))","v":""},null,null,null,null,null,{"$f":"IF(I7=\"\",\"\",ROUNDUP(I7*3.14159265359,0))","v":""},{"$f":"IF(E7=\"\",\"\",IF(E7='Données de base'!$F$28,'Données de base'!$E$28,IF(E7='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},{"$f":"IF(L7=\"\",\"\",IF(L7<=30,4,IF(L7<=40,5.6,IF(L7<=50,8,IF(L7<=60,11.2,IF(L7<=70,15.2,IF(L7<=80,20,IF(L7<=90,25.6,IF(L7<=100,32,IF(L7<=110,38,IF(L7<=120,44,IF(L7<=130,50,IF(L7<=140,56,IF(L7<=150,60,IF(L7<=160,64,IF(L7<=170,68,IF(L7<=180,72,IF(L7<=190,76,IF(L7<=200,80,IF(L7<=220,84,IF(L7<=240,88,IF(L7<=260,92,IF(L7<=280,96,IF(L7<=300,100,IF(L7<=320,104,IF(L7<=340,108,IF(L7<=360,112,IF(L7<=380,116,IF(L7<=400,120,IF(L7<=420,124,IF(L7<=440,128,IF(L7<=460,132,IF(L7<=480,136,IF(L7<=500,140,IF(L7<=600,160,IF(L7<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""},{"$f":"IF(G7=\"\",\"\",VLOOKUP(G7,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},{"$f":"IF(L7=\"\",\"\",N7*G7*M7*F7)","v":""}]
[2,null,null,null,null,{"$f":"IF(D8=\"\",\"\",IF(B8=\"Feuillus\",VLOOKUP(D8,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B8=\"Conifères\",VLOOKUP(D8,'Essences - Conifères'!B4:C131,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E8=\"\",\"\",IF(E8='Données de base'!$F$28,'Données de base'!$E$28,IF(E8='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},{"$f":"IF(L8=\"\",\"\",IF(L8<=30,4,IF(L8<=40,5.6,IF(L8<=50,8,IF(L8<=60,11.2,IF(L8<=70,15.2,IF(L8<=80,20,IF(L8<=90,25.6,IF(L8<=100,32,IF(L8<=110,38,IF(L8<=120,44,IF(L8<=130,50,IF(L8<=140,56,IF(L8<=150,60,IF(L8<=160,64,IF(L8<=170,68,IF(L8<=180,72,IF(L8<=190,76,IF(L8<=200,80,IF(L8<=220,84,IF(L8<=240,88,IF(L8<=260,92,IF(L8<=280,96,IF(L8<=300,100,IF(L8<=320,104,IF(L8<=340,108,IF(L8<=360,112,IF(L8<=380,116,IF(L8<=400,120,IF(L8<=420,124,IF(L8<=440,128,IF(L8<=460,132,IF(L8<=480,136,IF(L8<=500,140,IF(L8<=600,160,IF(L8<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""},{"$f":"IF(G8=\"\",\"\",VLOOKUP(G8,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},{"$f":"IF(L8=\"\",\"\",N8*G8*M8*F8)","v":""}]
[3,null,null,null,null,{"$f":"IF(D9=\"\",\"\",IF(B9=\"Feuillus\",VLOOKUP(D9,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B9=\"Conifères\",VLOOKUP(D9,'Essences - Conifères'!B5:C132,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E9=\"\",\"\",IF(E9='Données de base'!$F$28,'Données de base'!$E$28,IF(E9='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G9=\"\",\"\",VLOOKUP(G9,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[4,null,null,null,null,{"$f":"IF(D10=\"\",\"\",IF(B10=\"Feuillus\",VLOOKUP(D10,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B10=\"Conifères\",VLOOKUP(D10,'Essences - Conifères'!B6:C133,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E10=\"\",\"\",IF(E10='Données de base'!$F$28,'Données de base'!$E$28,IF(E10='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G10=\"\",\"\",VLOOKUP(G10,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[5,null,null,null,null,{"$f":"IF(D11=\"\",\"\",IF(B11=\"Feuillus\",VLOOKUP(D11,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B11=\"Conifères\",VLOOKUP(D11,'Essences - Conifères'!B7:C134,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E11=\"\",\"\",IF(E11='Données de base'!$F$28,'Données de base'!$E$28,IF(E11='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G11=\"\",\"\",VLOOKUP(G11,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[6,null,null,null,null,{"$f":"IF(D12=\"\",\"\",IF(B12=\"Feuillus\",VLOOKUP(D12,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B12=\"Conifères\",VLOOKUP(D12,'Essences - Conifères'!B8:C135,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E12=\"\",\"\",IF(E12='Données de base'!$F$28,'Données de base'!$E$28,IF(E12='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G12=\"\",\"\",VLOOKUP(G12,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[7,null,null,null,null,{"$f":"IF(D13=\"\",\"\",IF(B13=\"Feuillus\",VLOOKUP(D13,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B13=\"Conifères\",VLOOKUP(D13,'Essences - Conifères'!B9:C136,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E13=\"\",\"\",IF(E13='Données de base'!$F$28,'Données de base'!$E$28,IF(E13='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G13=\"\",\"\",VLOOKUP(G13,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[8,null,null,null,null,{"$f":"IF(D14=\"\",\"\",IF(B14=\"Feuillus\",VLOOKUP(D14,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B14=\"Conifères\",VLOOKUP(D14,'Essences - Conifères'!B10:C137,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E14=\"\",\"\",IF(E14='Données de base'!$F$28,'Données de base'!$E$28,IF(E14='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[9,null,null,null,null,{"$f":"IF(D15=\"\",\"\",IF(B15=\"Feuillus\",VLOOKUP(D15,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B15=\"Conifères\",VLOOKUP(D15,'Essences - Conifères'!B11:C138,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E15=\"\",\"\",IF(E15='Données de base'!$F$28,'Données de base'!$E$28,IF(E15='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G15=\"\",\"\",VLOOKUP(G15,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[10,null,null,null,null,{"$f":"IF(D16=\"\",\"\",IF(B16=\"Feuillus\",VLOOKUP(D16,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B16=\"Conifères\",VLOOKUP(D16,'Essences - Conifères'!B12:C139,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E16=\"\",\"\",IF(E16='Données de base'!$F$28,'Données de base'!$E$28,IF(E16='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G16=\"\",\"\",VLOOKUP(G16,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[11,null,null,null,null,{"$f":"IF(D17=\"\",\"\",IF(B17=\"Feuillus\",VLOOKUP(D17,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B17=\"Conifères\",VLOOKUP(D17,'Essences - Conifères'!B13:C140,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E17=\"\",\"\",IF(E17='Données de base'!$F$28,'Données de base'!$E$28,IF(E17='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G17=\"\",\"\",VLOOKUP(G17,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[12,null,null,null,null,{"$f":"IF(D18=\"\",\"\",IF(B18=\"Feuillus\",VLOOKUP(D18,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B18=\"Conifères\",VLOOKUP(D18,'Essences - Conifères'!B14:C141,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E18=\"\",\"\",IF(E18='Données de base'!$F$28,'Données de base'!$E$28,IF(E18='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G18=\"\",\"\",VLOOKUP(G18,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[13,null,null,null,null,{"$f":"IF(D19=\"\",\"\",IF(B19=\"Feuillus\",VLOOKUP(D19,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B19=\"Conifères\",VLOOKUP(D19,'Essences - Conifères'!B15:C142,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E19=\"\",\"\",IF(E19='Données de base'!$F$28,'Données de base'!$E$28,IF(E19='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G19=\"\",\"\",VLOOKUP(G19,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[14,null,null,null,null,{"$f":"IF(D20=\"\",\"\",IF(B20=\"Feuillus\",VLOOKUP(D20,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B20=\"Conifères\",VLOOKUP(D20,'Essences - Conifères'!B16:C143,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E20=\"\",\"\",IF(E20='Données de base'!$F$28,'Données de base'!$E$28,IF(E20='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G20=\"\",\"\",VLOOKUP(G20,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[15,null,null,null,null,{"$f":"IF(D21=\"\",\"\",IF(B21=\"Feuillus\",VLOOKUP(D21,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B21=\"Conifères\",VLOOKUP(D21,'Essences - Conifères'!B17:C144,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E21=\"\",\"\",IF(E21='Données de base'!$F$28,'Données de base'!$E$28,IF(E21='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G21=\"\",\"\",VLOOKUP(G21,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[16,null,null,null,null,{"$f":"IF(D22=\"\",\"\",IF(B22=\"Feuillus\",VLOOKUP(D22,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B22=\"Conifères\",VLOOKUP(D22,'Essences - Conifères'!B18:C145,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E22=\"\",\"\",IF(E22='Données de base'!$F$28,'Données de base'!$E$28,IF(E22='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G22=\"\",\"\",VLOOKUP(G22,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[17,null,null,null,null,{"$f":"IF(D23=\"\",\"\",IF(B23=\"Feuillus\",VLOOKUP(D23,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B23=\"Conifères\",VLOOKUP(D23,'Essences - Conifères'!B19:C146,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E23=\"\",\"\",IF(E23='Données de base'!$F$28,'Données de base'!$E$28,IF(E23='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G23=\"\",\"\",VLOOKUP(G23,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[18,null,null,null,null,{"$f":"IF(D24=\"\",\"\",IF(B24=\"Feuillus\",VLOOKUP(D24,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B24=\"Conifères\",VLOOKUP(D24,'Essences - Conifères'!B20:C147,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E24=\"\",\"\",IF(E24='Données de base'!$F$28,'Données de base'!$E$28,IF(E24='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G24=\"\",\"\",VLOOKUP(G24,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[19,null,null,null,null,{"$f":"IF(D25=\"\",\"\",IF(B25=\"Feuillus\",VLOOKUP(D25,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B25=\"Conifères\",VLOOKUP(D25,'Essences - Conifères'!B21:C148,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E25=\"\",\"\",IF(E25='Données de base'!$F$28,'Données de base'!$E$28,IF(E25='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G25=\"\",\"\",VLOOKUP(G25,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[20,null,null,null,null,{"$f":"IF(D26=\"\",\"\",IF(B26=\"Feuillus\",VLOOKUP(D26,'Essences - Arbres'!$B$3:$C$314,2,FALSE),IF(B26=\"Conifères\",VLOOKUP(D26,'Essences - Conifères'!B22:C149,2,FALSE))))","v":""},null,null,null,null,null,"",{"$f":"IF(E26=\"\",\"\",IF(E26='Données de base'!$F$28,'Données de base'!$E$28,IF(E26='Données de base'!$F$29,'Données de base'!$E$29,'Données de base'!$E$30)))","v":""},"",{"$f":"IF(G26=\"\",\"\",VLOOKUP(G26,'Données de base'!$A$12:$H$21,2,FALSE))","v":""},""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant réclamé selon base de calcul",{"$f":"SUM(P7:P26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant proposé"]

{"sheet":"Entrée Cépée","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,3,2,6],[24,3,24,4],[25,4,25,5]]}
[]
[]
[null,null,null,"Entrée cépée"]
[null,null,null,"N° embranchement","Ø Tronc en cm","Circonférence","Indice"]
[null,null,null,1,null,{"$f":"IF(E5=\"\",\"\",ROUNDUP(E5*3.14159265359,0))","v":""},{"$f":"IF(F5=\"\",\"\",IF(F5<=30,4,IF(F5<=40,5.6,IF(F5<=50,8,IF(F5<=60,11.2,IF(F5<=70,15.2,IF(F5<=80,20,IF(F5<=90,25.6,IF(F5<=100,32,IF(F5<=110,38,IF(F5<=120,44,IF(F5<=130,50,IF(F5<=140,56,IF(F5<=150,60,IF(F5<=160,64,IF(F5<=170,68,IF(F5<=180,72,IF(F5<=190,76,IF(F5<=200,80,IF(F5<=220,84,IF(F5<=240,88,IF(F5<=260,92,IF(F5<=280,96,IF(F5<=300,100,IF(F5<=320,104,IF(F5<=340,108,IF(F5<=360,112,IF(F5<=380,116,IF(F5<=400,120,IF(F5<=420,124,IF(F5<=440,128,IF(F5<=460,132,IF(F5<=480,136,IF(F5<=500,140,fI(E5<=600,160,IF(F5<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,2,null,"",{"$f":"IF(F6=\"\",\"\",IF(F6<=30,4,IF(F6<=40,5.6,IF(F6<=50,8,IF(F6<=60,11.2,IF(F6<=70,15.2,IF(F6<=80,20,IF(F6<=90,25.6,IF(F6<=100,32,IF(F6<=110,38,IF(F6<=120,44,IF(F6<=130,50,IF(F6<=140,56,IF(F6<=150,60,IF(F6<=160,64,IF(F6<=170,68,IF(F6<=180,72,IF(F6<=190,76,IF(F6<=200,80,IF(F6<=220,84,IF(F6<=240,88,IF(F6<=260,92,IF(F6<=280,96,IF(F6<=300,100,IF(F6<=320,104,IF(F6<=340,108,IF(F6<=360,112,IF(F6<=380,116,IF(F6<=400,120,IF(F6<=420,124,IF(F6<=440,128,IF(F6<=460,132,IF(F6<=480,136,IF(F6<=500,140,fI(E6<=600,160,IF(F6<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,3,null,"",{"$f":"IF(F7=\"\",\"\",IF(F7<=30,4,IF(F7<=40,5.6,IF(F7<=50,8,IF(F7<=60,11.2,IF(F7<=70,15.2,IF(F7<=80,20,IF(F7<=90,25.6,IF(F7<=100,32,IF(F7<=110,38,IF(F7<=120,44,IF(F7<=130,50,IF(F7<=140,56,IF(F7<=150,60,IF(F7<=160,64,IF(F7<=170,68,IF(F7<=180,72,IF(F7<=190,76,IF(F7<=200,80,IF(F7<=220,84,IF(F7<=240,88,IF(F7<=260,92,IF(F7<=280,96,IF(F7<=300,100,IF(F7<=320,104,IF(F7<=340,108,IF(F7<=360,112,IF(F7<=380,116,IF(F7<=400,120,IF(F7<=420,124,IF(F7<=440,128,IF(F7<=460,132,IF(F7<=480,136,IF(F7<=500,140,fI(E7<=600,160,IF(F7<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,4,null,"",{"$f":"IF(F8=\"\",\"\",IF(F8<=30,4,IF(F8<=40,5.6,IF(F8<=50,8,IF(F8<=60,11.2,IF(F8<=70,15.2,IF(F8<=80,20,IF(F8<=90,25.6,IF(F8<=100,32,IF(F8<=110,38,IF(F8<=120,44,IF(F8<=130,50,IF(F8<=140,56,IF(F8<=150,60,IF(F8<=160,64,IF(F8<=170,68,IF(F8<=180,72,IF(F8<=190,76,IF(F8<=200,80,IF(F8<=220,84,IF(F8<=240,88,IF(F8<=260,92,IF(F8<=280,96,IF(F8<=300,100,IF(F8<=320,104,IF(F8<=340,108,IF(F8<=360,112,IF(F8<=380,116,IF(F8<=400,120,IF(F8<=420,124,IF(F8<=440,128,IF(F8<=460,132,IF(F8<=480,136,IF(F8<=500,140,fI(E8<=600,160,IF(F8<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,5,null,"",{"$f":"IF(F9=\"\",\"\",IF(F9<=30,4,IF(F9<=40,5.6,IF(F9<=50,8,IF(F9<=60,11.2,IF(F9<=70,15.2,IF(F9<=80,20,IF(F9<=90,25.6,IF(F9<=100,32,IF(F9<=110,38,IF(F9<=120,44,IF(F9<=130,50,IF(F9<=140,56,IF(F9<=150,60,IF(F9<=160,64,IF(F9<=170,68,IF(F9<=180,72,IF(F9<=190,76,IF(F9<=200,80,IF(F9<=220,84,IF(F9<=240,88,IF(F9<=260,92,IF(F9<=280,96,IF(F9<=300,100,IF(F9<=320,104,IF(F9<=340,108,IF(F9<=360,112,IF(F9<=380,116,IF(F9<=400,120,IF(F9<=420,124,IF(F9<=440,128,IF(F9<=460,132,IF(F9<=480,136,IF(F9<=500,140,fI(E9<=600,160,IF(F9<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,6,null,"",{"$f":"IF(F10=\"\",\"\",IF(F10<=30,4,IF(F10<=40,5.6,IF(F10<=50,8,IF(F10<=60,11.2,IF(F10<=70,15.2,IF(F10<=80,20,IF(F10<=90,25.6,IF(F10<=100,32,IF(F10<=110,38,IF(F10<=120,44,IF(F10<=130,50,IF(F10<=140,56,IF(F10<=150,60,IF(F10<=160,64,IF(F10<=170,68,IF(F10<=180,72,IF(F10<=190,76,IF(F10<=200,80,IF(F10<=220,84,IF(F10<=240,88,IF(F10<=260,92,IF(F10<=280,96,IF(F10<=300,100,IF(F10<=320,104,IF(F10<=340,108,IF(F10<=360,112,IF(F10<=380,116,IF(F10<=400,120,IF(F10<=420,124,IF(F10<=440,128,IF(F10<=460,132,IF(F10<=480,136,IF(F10<=500,140,fI(E10<=600,160,IF(F10<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,7,null,"",{"$f":"IF(F11=\"\",\"\",IF(F11<=30,4,IF(F11<=40,5.6,IF(F11<=50,8,IF(F11<=60,11.2,IF(F11<=70,15.2,IF(F11<=80,20,IF(F11<=90,25.6,IF(F11<=100,32,IF(F11<=110,38,IF(F11<=120,44,IF(F11<=130,50,IF(F11<=140,56,IF(F11<=150,60,IF(F11<=160,64,IF(F11<=170,68,IF(F11<=180,72,IF(F11<=190,76,IF(F11<=200,80,IF(F11<=220,84,IF(F11<=240,88,IF(F11<=260,92,IF(F11<=280,96,IF(F11<=300,100,IF(F11<=320,104,IF(F11<=340,108,IF(F11<=360,112,IF(F11<=380,116,IF(F11<=400,120,IF(F11<=420,124,IF(F11<=440,128,IF(F11<=460,132,IF(F11<=480,136,IF(F11<=500,140,fI(E11<=600,160,IF(F11<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,8,null,"",{"$f":"IF(F12=\"\",\"\",IF(F12<=30,4,IF(F12<=40,5.6,IF(F12<=50,8,IF(F12<=60,11.2,IF(F12<=70,15.2,IF(F12<=80,20,IF(F12<=90,25.6,IF(F12<=100,32,IF(F12<=110,38,IF(F12<=120,44,IF(F12<=130,50,IF(F12<=140,56,IF(F12<=150,60,IF(F12<=160,64,IF(F12<=170,68,IF(F12<=180,72,IF(F12<=190,76,IF(F12<=200,80,IF(F12<=220,84,IF(F12<=240,88,IF(F12<=260,92,IF(F12<=280,96,IF(F12<=300,100,IF(F12<=320,104,IF(F12<=340,108,IF(F12<=360,112,IF(F12<=380,116,IF(F12<=400,120,IF(F12<=420,124,IF(F12<=440,128,IF(F12<=460,132,IF(F12<=480,136,IF(F12<=500,140,fI(E12<=600,160,IF(F12<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,9,null,"",{"$f":"IF(F13=\"\",\"\",IF(F13<=30,4,IF(F13<=40,5.6,IF(F13<=50,8,IF(F13<=60,11.2,IF(F13<=70,15.2,IF(F13<=80,20,IF(F13<=90,25.6,IF(F13<=100,32,IF(F13<=110,38,IF(F13<=120,44,IF(F13<=130,50,IF(F13<=140,56,IF(F13<=150,60,IF(F13<=160,64,IF(F13<=170,68,IF(F13<=180,72,IF(F13<=190,76,IF(F13<=200,80,IF(F13<=220,84,IF(F13<=240,88,IF(F13<=260,92,IF(F13<=280,96,IF(F13<=300,100,IF(F13<=320,104,IF(F13<=340,108,IF(F13<=360,112,IF(F13<=380,116,IF(F13<=400,120,IF(F13<=420,124,IF(F13<=440,128,IF(F13<=460,132,IF(F13<=480,136,IF(F13<=500,140,fI(E13<=600,160,IF(F13<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,10,null,"",{"$f":"IF(F14=\"\",\"\",IF(F14<=30,4,IF(F14<=40,5.6,IF(F14<=50,8,IF(F14<=60,11.2,IF(F14<=70,15.2,IF(F14<=80,20,IF(F14<=90,25.6,IF(F14<=100,32,IF(F14<=110,38,IF(F14<=120,44,IF(F14<=130,50,IF(F14<=140,56,IF(F14<=150,60,IF(F14<=160,64,IF(F14<=170,68,IF(F14<=180,72,IF(F14<=190,76,IF(F14<=200,80,IF(F14<=220,84,IF(F14<=240,88,IF(F14<=260,92,IF(F14<=280,96,IF(F14<=300,100,IF(F14<=320,104,IF(F14<=340,108,IF(F14<=360,112,IF(F14<=380,116,IF(F14<=400,120,IF(F14<=420,124,IF(F14<=440,128,IF(F14<=460,132,IF(F14<=480,136,IF(F14<=500,140,fI(E14<=600,160,IF(F14<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,11,null,"",{"$f":"IF(F15=\"\",\"\",IF(F15<=30,4,IF(F15<=40,5.6,IF(F15<=50,8,IF(F15<=60,11.2,IF(F15<=70,15.2,IF(F15<=80,20,IF(F15<=90,25.6,IF(F15<=100,32,IF(F15<=110,38,IF(F15<=120,44,IF(F15<=130,50,IF(F15<=140,56,IF(F15<=150,60,IF(F15<=160,64,IF(F15<=170,68,IF(F15<=180,72,IF(F15<=190,76,IF(F15<=200,80,IF(F15<=220,84,IF(F15<=240,88,IF(F15<=260,92,IF(F15<=280,96,IF(F15<=300,100,IF(F15<=320,104,IF(F15<=340,108,IF(F15<=360,112,IF(F15<=380,116,IF(F15<=400,120,IF(F15<=420,124,IF(F15<=440,128,IF(F15<=460,132,IF(F15<=480,136,IF(F15<=500,140,fI(E15<=600,160,IF(F15<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,12,null,"",{"$f":"IF(F16=\"\",\"\",IF(F16<=30,4,IF(F16<=40,5.6,IF(F16<=50,8,IF(F16<=60,11.2,IF(F16<=70,15.2,IF(F16<=80,20,IF(F16<=90,25.6,IF(F16<=100,32,IF(F16<=110,38,IF(F16<=120,44,IF(F16<=130,50,IF(F16<=140,56,IF(F16<=150,60,IF(F16<=160,64,IF(F16<=170,68,IF(F16<=180,72,IF(F16<=190,76,IF(F16<=200,80,IF(F16<=220,84,IF(F16<=240,88,IF(F16<=260,92,IF(F16<=280,96,IF(F16<=300,100,IF(F16<=320,104,IF(F16<=340,108,IF(F16<=360,112,IF(F16<=380,116,IF(F16<=400,120,IF(F16<=420,124,IF(F16<=440,128,IF(F16<=460,132,IF(F16<=480,136,IF(F16<=500,140,fI(E16<=600,160,IF(F16<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,13,null,"",{"$f":"IF(F17=\"\",\"\",IF(F17<=30,4,IF(F17<=40,5.6,IF(F17<=50,8,IF(F17<=60,11.2,IF(F17<=70,15.2,IF(F17<=80,20,IF(F17<=90,25.6,IF(F17<=100,32,IF(F17<=110,38,IF(F17<=120,44,IF(F17<=130,50,IF(F17<=140,56,IF(F17<=150,60,IF(F17<=160,64,IF(F17<=170,68,IF(F17<=180,72,IF(F17<=190,76,IF(F17<=200,80,IF(F17<=220,84,IF(F17<=240,88,IF(F17<=260,92,IF(F17<=280,96,IF(F17<=300,100,IF(F17<=320,104,IF(F17<=340,108,IF(F17<=360,112,IF(F17<=380,116,IF(F17<=400,120,IF(F17<=420,124,IF(F17<=440,128,IF(F17<=460,132,IF(F17<=480,136,IF(F17<=500,140,fI(E17<=600,160,IF(F17<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,14,null,"",{"$f":"IF(F18=\"\",\"\",IF(F18<=30,4,IF(F18<=40,5.6,IF(F18<=50,8,IF(F18<=60,11.2,IF(F18<=70,15.2,IF(F18<=80,20,IF(F18<=90,25.6,IF(F18<=100,32,IF(F18<=110,38,IF(F18<=120,44,IF(F18<=130,50,IF(F18<=140,56,IF(F18<=150,60,IF(F18<=160,64,IF(F18<=170,68,IF(F18<=180,72,IF(F18<=190,76,IF(F18<=200,80,IF(F18<=220,84,IF(F18<=240,88,IF(F18<=260,92,IF(F18<=280,96,IF(F18<=300,100,IF(F18<=320,104,IF(F18<=340,108,IF(F18<=360,112,IF(F18<=380,116,IF(F18<=400,120,IF(F18<=420,124,IF(F18<=440,128,IF(F18<=460,132,IF(F18<=480,136,IF(F18<=500,140,fI(E18<=600,160,IF(F18<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,15,null,"",{"$f":"IF(F19=\"\",\"\",IF(F19<=30,4,IF(F19<=40,5.6,IF(F19<=50,8,IF(F19<=60,11.2,IF(F19<=70,15.2,IF(F19<=80,20,IF(F19<=90,25.6,IF(F19<=100,32,IF(F19<=110,38,IF(F19<=120,44,IF(F19<=130,50,IF(F19<=140,56,IF(F19<=150,60,IF(F19<=160,64,IF(F19<=170,68,IF(F19<=180,72,IF(F19<=190,76,IF(F19<=200,80,IF(F19<=220,84,IF(F19<=240,88,IF(F19<=260,92,IF(F19<=280,96,IF(F19<=300,100,IF(F19<=320,104,IF(F19<=340,108,IF(F19<=360,112,IF(F19<=380,116,IF(F19<=400,120,IF(F19<=420,124,IF(F19<=440,128,IF(F19<=460,132,IF(F19<=480,136,IF(F19<=500,140,fI(E19<=600,160,IF(F19<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,16,null,"",{"$f":"IF(F20=\"\",\"\",IF(F20<=30,4,IF(F20<=40,5.6,IF(F20<=50,8,IF(F20<=60,11.2,IF(F20<=70,15.2,IF(F20<=80,20,IF(F20<=90,25.6,IF(F20<=100,32,IF(F20<=110,38,IF(F20<=120,44,IF(F20<=130,50,IF(F20<=140,56,IF(F20<=150,60,IF(F20<=160,64,IF(F20<=170,68,IF(F20<=180,72,IF(F20<=190,76,IF(F20<=200,80,IF(F20<=220,84,IF(F20<=240,88,IF(F20<=260,92,IF(F20<=280,96,IF(F20<=300,100,IF(F20<=320,104,IF(F20<=340,108,IF(F20<=360,112,IF(F20<=380,116,IF(F20<=400,120,IF(F20<=420,124,IF(F20<=440,128,IF(F20<=460,132,IF(F20<=480,136,IF(F20<=500,140,fI(E20<=600,160,IF(F20<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,17,null,"",{"$f":"IF(F21=\"\",\"\",IF(F21<=30,4,IF(F21<=40,5.6,IF(F21<=50,8,IF(F21<=60,11.2,IF(F21<=70,15.2,IF(F21<=80,20,IF(F21<=90,25.6,IF(F21<=100,32,IF(F21<=110,38,IF(F21<=120,44,IF(F21<=130,50,IF(F21<=140,56,IF(F21<=150,60,IF(F21<=160,64,IF(F21<=170,68,IF(F21<=180,72,IF(F21<=190,76,IF(F21<=200,80,IF(F21<=220,84,IF(F21<=240,88,IF(F21<=260,92,IF(F21<=280,96,IF(F21<=300,100,IF(F21<=320,104,IF(F21<=340,108,IF(F21<=360,112,IF(F21<=380,116,IF(F21<=400,120,IF(F21<=420,124,IF(F21<=440,128,IF(F21<=460,132,IF(F21<=480,136,IF(F21<=500,140,fI(E21<=600,160,IF(F21<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,18,null,"",{"$f":"IF(F22=\"\",\"\",IF(F22<=30,4,IF(F22<=40,5.6,IF(F22<=50,8,IF(F22<=60,11.2,IF(F22<=70,15.2,IF(F22<=80,20,IF(F22<=90,25.6,IF(F22<=100,32,IF(F22<=110,38,IF(F22<=120,44,IF(F22<=130,50,IF(F22<=140,56,IF(F22<=150,60,IF(F22<=160,64,IF(F22<=170,68,IF(F22<=180,72,IF(F22<=190,76,IF(F22<=200,80,IF(F22<=220,84,IF(F22<=240,88,IF(F22<=260,92,IF(F22<=280,96,IF(F22<=300,100,IF(F22<=320,104,IF(F22<=340,108,IF(F22<=360,112,IF(F22<=380,116,IF(F22<=400,120,IF(F22<=420,124,IF(F22<=440,128,IF(F22<=460,132,IF(F22<=480,136,IF(F22<=500,140,fI(E22<=600,160,IF(F22<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,19,null,"",{"$f":"IF(F23=\"\",\"\",IF(F23<=30,4,IF(F23<=40,5.6,IF(F23<=50,8,IF(F23<=60,11.2,IF(F23<=70,15.2,IF(F23<=80,20,IF(F23<=90,25.6,IF(F23<=100,32,IF(F23<=110,38,IF(F23<=120,44,IF(F23<=130,50,IF(F23<=140,56,IF(F23<=150,60,IF(F23<=160,64,IF(F23<=170,68,IF(F23<=180,72,IF(F23<=190,76,IF(F23<=200,80,IF(F23<=220,84,IF(F23<=240,88,IF(F23<=260,92,IF(F23<=280,96,IF(F23<=300,100,IF(F23<=320,104,IF(F23<=340,108,IF(F23<=360,112,IF(F23<=380,116,IF(F23<=400,120,IF(F23<=420,124,IF(F23<=440,128,IF(F23<=460,132,IF(F23<=480,136,IF(F23<=500,140,fI(E23<=600,160,IF(F23<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,20,null,"",{"$f":"IF(F24=\"\",\"\",IF(F24<=30,4,IF(F24<=40,5.6,IF(F24<=50,8,IF(F24<=60,11.2,IF(F24<=70,15.2,IF(F24<=80,20,IF(F24<=90,25.6,IF(F24<=100,32,IF(F24<=110,38,IF(F24<=120,44,IF(F24<=130,50,IF(F24<=140,56,IF(F24<=150,60,IF(F24<=160,64,IF(F24<=170,68,IF(F24<=180,72,IF(F24<=190,76,IF(F24<=200,80,IF(F24<=220,84,IF(F24<=240,88,IF(F24<=260,92,IF(F24<=280,96,IF(F24<=300,100,IF(F24<=320,104,IF(F24<=340,108,IF(F24<=360,112,IF(F24<=380,116,IF(F24<=400,120,IF(F24<=420,124,IF(F24<=440,128,IF(F24<=460,132,IF(F24<=480,136,IF(F24<=500,140,fI(E24<=600,160,IF(F24<=700,180,\"calculer avec une valeur de 20 par 100cm de circonférence\"))))))))))))))))))))))))))))))))))))","v":""}]
[null,null,null,"Circonférence totale",null,{"$f":"SUM(F5:F24)","v":0}]
[null,null,null,null,"Indice total",null,{"$f":"SUM(G5:G24)","v":0}]

{"sheet":"Données de base","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[28,5,28,7],[29,5,29,7],[27,5,27,7],[27,1,27,2],[17,1,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[32,1,32,2],[31,1,31,2],[30,1,30,2],[29,1,29,2],[28,1,28,2],[16,1,16,7],[11,1,11,7],[12,1,12,7],[13,1,13,7],[14,1,14,7],[15,1,15,7]]}
[]
["CLASSE"]
[]
["La classe est définie selon l'essence de l'arbre. Le lien ci-dessous permet d'accéder au document officiel."]
["https://www.founex.ch/fileadmin/Documents/Arbres/Valeurs_reference_arbres_2023.pdf"]
[]
[]
["ETAT SANITAIRE (extrait de la norme USSP1974)"]
[]
["L'état sanitaire doit être défini selon les critères suivants :"]
[]
[10,"Beaux arbres solitaires,en allées ou en groupes, protégés par des lois ou règlements; arbres historiques ou monuments naturels, d'une grande importance quand à leur rareté, leur forme ou leur emplacement dans une ville, un village ou dans un site."]
[9,"Arbres isolés, en allées ou en groupes, important pour la beauté d'une ville, village ou d'un site ou se trouvant dans des zones protégées, sains et vigoureux. Ensembles d'arbres où l'enlèvement d'un sujet porte préjudice à l'unité. "]
[8,"Sains et vigoureux."]
[7,"Sains et vigoureux mais légèrement endommagés par la taille ou lors d'un accident."]
[6,"Sains, croissance moyenne."]
[5,"Sains, croissance moyenne, difformes."]
[4,"Croissance faible inhérente à leur emplacement mais qui peuvent survivre encore un certain temps.."]
[3,"Croissance faible endommagés, partie pourries, tronc évidés..."]
[2,"Sans force, endommagés, peu viable"]
[0.5,"Mort"]
[null,"Ajout personnel"]
[]
[]
[]
[]
[null,null,null,null,"SITUATION"]
[null,null,null,null,9,"Zone centrale"]
[null,null,null,null,8,"Zone d'habitation de très faible densité, zone affectée à des besoins publics, PPA 1, 3, 4, 5, 6 et 9"]
[null,null,null,null,5,"Zone agricole, zone de verdure, zone viticole, zone de tourisme et loisirs, PPA 2, 7 et 8"]

{"sheet":"Essences - Arbres","index":3,"n_rows":314,"n_cols":7,"rows_kept":314,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,3,0,4]]}
["Arbres et arbustes",null,"Abattages","Fournitures"]
[null,null,"\"Classification des espèces et variétés\"","Arbustes","Arbres d'avenues",null,"Liste Famille"]
["Acer","buergerianum",6,7,null,null,"Acer"]
[null,"campestre",6,4.0999999999999996,85,null,"Aesculus"]
[null,"‘Elsrijk’",6,84,null,null,"Ailanthus"]
[null,"cappadocicum",6,6,85,null,"Albizia"]
[null,"davidii",6,7,null,null,"Alnus"]
[null,"griseum",7,8.1,null,null,"Amelanchier"]
[null,"japonicum 'Aconitifolium'",8,9.1,null,null,"Aronia"]
[null,"negundo",4,5,83,null,"Aucuba"]
[null,"negundo en cultivars",4,5,85,null,"Berberis"]
[null,"palmatum",8.1,null,null,null,"Betula"]
[null,"palmatum en cultivars",8.1,10.1,null,null,"Buxus"]
[null,"platanoides",4,3.1,84,null,"Callicarpa"]
[null,"platanoïde ‘Crimson King’",8,5,85,null,"Calycanthus"]
[null,"Platanoïde ‘Schwedleri’",7,5,84,null,"Caragana"]
[null,"cultivars à feuillage vert",5,84,null,null,"Carpinus"]
[null,"cultivars à feuillage panaché ou rouge",7,85,null,null,"Castanea"]
[null,"platanoïde ‘Globosum’",9,85,null,null,"Catalpa"]
[null,"pseudoplatanus",4,3.1,83,null,"Celtis"]
[null,"rubrum",6,6,85,null,"Cercidiphyllum"]
[null,"rufinerve",6,7,83,null,"Cercis"]
[null,"saccharinum",5,5,83,null,"Chaenomeles"]
[null,"saccharinum Wieri",5,5,83,null,"Chimonanthus"]
[null,"shirasawanum 'Aureum'",5,10.1,null,null,"Chionanthus"]
[null,"tataricum ssp. ginnala",5,5,85,null,"Cladratris"]
[null,"triflorum",7,8.1,null,null,"Clerodendrum"]
["Aesculus","x carnea 'Briotii'",8,7,85,null,"Colutea"]
[null,"flava",8,7,86,null,"Cornus_alba"]
[null,"hippocastanum",4,83,null,null,"Cornus"]
[null,"hippocastanum ‘Baumannii’",6,6,84,null,"Corylus"]
[null,"parviflora",9,null,null,null,"Cotinus"]
[null,"pavia ‘Atrosanguinea’",9,8,null,null,"Crataegus"]
["Ailanthus","altissima",4,null,"liste noire*",null,"Cydonia"]
["Albizia","julibrissin",6,8,86,null,"Davidia"]
["Alnus","Alnus cordata",3,3.1,84,null,"Deutzia"]
[null,"glutinosa",3,3.1,83,null,"Diervilla"]
[null,"glutinosa ‘Imperalis’",4,5,85,null,"Diospyros"]
[null,"incana",3,3.1,null,null,"Elaeagnus "]
["Amelanchier","‘Ballerina’",9,6,87,null,"Eriobotrya"]
[null,"laevis",9,6,87,null,"Euonymus"]
[null,"lamarckii (syn. canadensis)",9,6,87,null,"Exochorda"]
[null,"rotundifolia (syn. ovalis)",9,6,null,null,"Fagus"]
["Aronia","Aronia spp.",5,null,null,null,"Forsythia"]
["Aucuba","Aucuba japonica",8.1,null,null,null,"Frangula"]
[null,"Aucuba en cultivars",8.1,9,null,null,"Fraxinus"]
["Berberis","spp sauf nains",null,4,null,null,"Gleditsia"]
["Betula","albosinensis",6,5,84,null,"Gymnocladus"]
[null,"ermanii",6,5,null,null,"Halesia"]
[null,"humilis",6,6,null,null,"Hamamelis"]
[null,"Betula nigra",4,5,84,null,"Heptacodium "]
[null,"papyrifera",4,5,null,null,"Hibiscus"]
[null,"pendula (syn. verrucosa)",4,4,84,null,"Hippophaë"]
[null,"pendula ‘Crispa’",4,5,null,null,"Ilex"]
[null,"Pendula ‘Fastigiata’",8,6,null,null,"Itea"]
[null,"Pendula ‘Tristis’",4,4,null,null,"Juglans"]
[null,"Pendula ‘Youngii’",8,85,null,null,"Koelreuteria"]
[null,"Betula pubescens",4,5,84,null,"Kolkwitzia"]
[null,"utilis ‘Doorenbos’",5,5,84,null,"Laburnum"]
[null,"utilis ‘Jacquemontii’",5,5,84,null,"Lagerstroemia"]
["Buxus","sempervirens",null,9.1,null,null,"Ligustrum"]
[null,"Sempervirens \"Argenteovariegata\"",null,null,null,null,"Liquidambar"]
[null,"Sempervirens ‘Rotundifolia’",null,9.1,null,null,"Liriodendron"]
[null,"Sempervirens 'Handwortensis'",null,9.1,null,null,"Lonicera"]
["Callicarpa","Callicarpa spp",null,5,null,null,"Magnolia"]
["Calycanthus","Calycanthus spp",null,6,null,null,"Malus"]
["Caragana","Caragana arborescens",null,4,null,null,"Mespilus"]
["Carpinus","betulus et cultivars",6,5,85,null,"Morus"]
[null,"Carpinus formé en parasol",6,null,86,null,"Nothofagus"]
["Castanea","sativa",9,6,85,null,"Nyssa"]
[null,"variétés greffées",9,8,87,null,"Osmanthus"]
["Catalpa","bignonioides",7,5,84,null,"Parrotia"]
[null,"bigonoioides ‘Nana’ (syn. bungei)",7,null,85,null,"Parrotiopsis"]
["Celtis","australis",8,null,85,null,"Paulownia"]
[null,"occidentalis",8,null,85,null,"Philadelphus"]
["Cercidiphyllum","Cercidiphyllum japonicum",9,6,85,null,"Physocarpus"]
[null,"‘Pendulum’",7,null,null,null,"Platanus"]
["Cercis","canadensis & cultivars",9,9,86,null,"Populus"]
[null,"siliquastrum",9,7,86,null,"Prunus"]
["Chaenomeles","japonica sauf nains",null,5,null,null,"Pterocarya"]
["Chimonanthus","praecox",null,7,null,null,"Pyrus"]
["Chionanthus","retusus",null,8,null,null,"Quercus"]
[null,"virginicus",null,8,null,null,"Rhamnus"]
["Cladratris","kentukea (syn. lutea)",9,7,85,null,"Ribes"]
["Clerodendrum","trichotomum",9,6,86,null,"Robinia"]
["Colutea","arborescens",5,null,null,null,"Salix"]
["Cornus_alba","‘Elegantissima’",null,4,null,null,"Sambucus"]
[null,"‘Sibirica’",5,null,null,null,"Sorbus"]
[null,"‘Spaethii’",4,null,null,null,"Spiraea"]
[null,"alternifolia",7,null,null,null,"Staphylea"]
[null,"‘Ascona’",9.1,null,null,null,"Stewartia"]
[null,"controversa",7,7,86,null,"Styphnolobium"]
[null,"‘Variegata’",8,9.1,87,null,"Styrax"]
[null,"florida",8.1,null,null,null,"Syringa"]
[null,"florida cultivars",9,null,null,null,"Tamarix"]
[null,"kousa",7,null,null,null,"Tetradium"]
[null,"kousa cultivars",8,null,null,null,"Tilia"]
["Cornus","mas",9,5,87,null,"Ulmus"]
[null,"nuttallii",9.1,null,null,null,"Viburnum"]
[null,"sanguinea",3,null,null,null,"Viburnum"]
[null,"sanguinea ‘Winter Flame’",3,5,null,null,"Vitex"]
["Corylus","avellana & cultivars",null,3,null,null,"Weigela"]
[null,"colurna & cultivars",6,5,84,null,"Zelkova"]
[null,"maxima & cultivars",6,4]
["Cotinus","coggygria & cultivars",null,6]
["Crataegus","laevigata (=oxyacantha)",8,3,86]
[null,"x lavalleei",8,5,86]
[null,"x lavalleei ‘Carrierei’",8,6,86]
[null,"x media \"Paul Scarlet\"",8,5,86]
[null,"x persimilis ‘Splendens’",8,6,86]
["Cydonia","oblonga et variétés à fruits",null,5,85]
["Davidia","involucrata",9,7,86]
["Deutzia","Deutzia espèces érigées",null,3]
["Diervilla","splendens",null,5]
["Diospyros","kaki",6,6,85]
["Elaeagnus ","angustifolia",null,5]
[null,"commutata",null,6]
[null,"ebbingei",null,8]
[null,"ebbingi cultivars",null,9]
[null,"pungens",null,8]
["Eriobotrya","japonica",null,8]
["Euonymus","alatus",null,7]
[null,"europaeus",null,4]
["Exochorda","racemosa & cultivars",null,6]
["Fagus","Fagus sylvatica",7,5,85]
[null,"‘Aspleniifolia’",9,7,86]
[null,"‘Atropunicea’ de semis",9,6,86]
[null,"‘Dawyck’",9,6,86]
[null,"‘Laciniata’",9,7,86]
[null,"\"Pendula\"",9,6,86]
[null,"‘Purple Fountain’",9,8,86]
[null,"‘Purpurea Pendula’",9,8,86]
[null,"‘Purpurea Tricolor’",9,7,86]
[null,"Rohan Obelisk'",9,7,86]
[null,"'Rohanii'",9,7,86]
[null,"Swat Magret'",9,7,86]
["Forsythia","Forsythia espèces érigées",null,4]
["Frangula","alnus",null,3]
["Fraxinus","angustifolia ‘Raywood’",6,null,84]
[null,"excelsior",4,3.1,83]
[null,"cultivars",6,85]
[null,"ornus & cultivars",6,5,85]
["Gleditsia","triacanthos",7,6,84]
[null,"triacanthos en cultivars",7,7,85]
["Gymnocladus","dioica",7,7,86]
["Halesia","carolina",null,8.1]
["Hamamelis","Hamamelis spp.",null,8.1]
["Heptacodium ","miconioides (syn. jasminoides)",null,7]
["Hibiscus","syriacus en variétés",null,6]
["Hippophaë","rhamnoides & cultivars",null,4]
["Ilex","aquifolium",9,8,87]
[null,"à feuilles panachées",9,9.1]
[null,"x meserveae & cultivars",9,9]
[null,"verticillata",9,7]
["Itea","viriginica",null,7]
["Juglans","Juglans nigra",6,null,85]
[null,"regia de semis",6,null,84]
[null,"de greffe",6,null,86]
["Koelreuteria","paniculata & cultivars",9,7,86]
["Kolkwitzia","amabilis & cultivars",null,5]
["Laburnum","alpinum",null,6]
[null,"anagyroides",null,4]
[null,"watereri 'Vossii'",null,6]
["Lagerstroemia","indica",8,7,87]
["Ligustrum","delavayanum",null,5]
[null,"japonicum",8,4,84]
[null,"ovalifolium",8,3]
[null,"vulgare",8,3]
["Liquidambar","styraciflua & cultivars",9,6,86]
[null,"Liquidambar formé en parasol",9,null,87]
["Liriodendron","tulipifera",9,6,84]
[null,"tulipifera ‘Aureomarginatum’",9,8,85]
[null,"tulipifera ‘Fastigiatum’",9,7,85]
["Lonicera","frangrantissima",null,4]
[null,"x purpusii",null,4]
[null,"tatarica",null,3]
[null,"xylosteoides"]
[null,"xylosteum",null,3]
["Magnolia","grandiflora & cultivars",9,9,86]
[null,"kobus",9,7,86]
[null,"liliiflora ‘Nigra’",9,8]
[null,"x loebneri & cultivars",9,8,86]
[null,"sieboldii",9,9]
[null,"x soulangeana & cultivars",9,8,86]
[null,"stellata",9,8.1]
[null,"stellate ‘Rosea’",9,10]
[null,"stellata ‘Susan’",9,8.1]
["Malus","d’ornement spp.",7,5,85]
[null,"domestica (pommier à fruits)",7,null,85]
["Mespilus","germanica",7,5,86]
["Morus","alba & cv",5,5,85]
[null,"Morus ‘Pendula’",9,7,85]
[null,"Morus nigra",5,8,85]
["Nothofagus","antarctica",7,6,86]
["Nyssa","sylvatica",9,7,86]
["Osmanthus","Osmanthus x burkwoodii",null,8]
[null,"heterophyllus",null,8]
[null,"heterophyllus ‘Purpureus’",null,8.1]
["Parrotia","persica & cultivars",8,7,86]
["Parrotiopsis","jaquemontiana",null,8]
["Paulownia","tomentosa",4,null,"liste noire*"]
["Philadelphus","Philadelphus espèces érigées",null,4]
["Physocarpus","opulifolius",null,3]
["Platanus","x hispanica",4,null,83]
[null,"x 'Vallis Clausa'",4,null,85]
[null,"formé en parasol",4,null,86]
["Populus","alba",3,3,83]
[null,"nigra et cultivars",3,3.1,83]
[null,"tremula et cultivars",4,3.1,83]
["Prunus","‘Accolade’",5,5,84]
[null,"avium",4,4.0999999999999996,83]
[null,"avium et cerasus (Cerisier à fruits)",4,null,83]
[null,"avium ‘Plena’",4,5,84]
[null,"x blireana",4,5,84]
[null,"cerasifera ‘Woodii’",4,4.0999999999999996,85]
[null,"domestica (prunier à fruits)",4,null,85]
[null,"eminens ‘Umbraculifera’",5,null,85]
[null,"eminens ‘Kiku-shidare-zakura’",5,6,85]
[null,"lusitanica",null,8]
[null,"lusitanica ‘Angustifolia’, 'Myrtifolia'",null,8.1]
[null,"maackii & cultivars",4,5,84]
[null,"mahaleb",4,5,85]
[null,"Okame'",5,5,84]
[null,"padus & cultivars",4,4.0999999999999996,84]
[null,"padus 'Pandora'",5,5,84]
[null,"sargentii",5,5]
[null,"serrula & cultivars",4,5,84]
[null,"serrulata var",5,5,84]
[null,"spinosa",3]
[null,"x subhirtella & cultivars",5,5,84]
[null,"‘Umineko’",5,84]
[null,"virginiana",4,5,85]
[null,"x yedoensis",5,6,84]
["Pterocarya","fraxinifolia & cultivars",7,5,84]
["Pyrus","calleryana",4,6,85]
[null,"communis (Poirier à fruits)",4,null,85]
[null,"salicifolia",5,6,87]
["Quercus","cerris",9,null,86]
[null,"castaneifolia",9,7,86]
[null,"coccinea",9,87]
[null,"frainetto",9,6,86]
[null,"glauca (=myrsinifolia)",9,8,86]
[null,"ilex",9,8,86]
[null,"palustris",9,null,86]
[null,"petraea",9,6,86]
[null,"phellos",9,7,87]
[null,"phillyroides",7]
[null,"pontica",9,8]
[null,"pubescens",9,6,85]
[null,"robur",9,6,85]
[null,"robur en cultivars",9,6,86]
[null,"rubra",9,6,85]
[null,"turneri x Pseudoturneri",9,8,86]
["Rhamnus","cathartica",null,3]
["Ribes","spp",null,4]
["Robinia","hispida",9,6,85]
[null,"margaretta \" Casque Rouge\"",4,3.1,83]
[null,"pseudoacacia",4,null,"liste noire*"]
[null,"pseudoacacia ‘Frisia’",4,4.0999999999999996,84]
["Salix","alba & cultivars",4,4,83]
[null,"babylonica (=pendula)",4,4,83]
[null,"caprea & cultivars",4,84]
[null,"cinerea",4]
[null,"daphnoides",4,4,84]
[null,"eleagnos",null,4]
[null,"eleagnos 'Erythroflexuosa'",null,4]
[null,"purpurea sauf nains",null,3]
[null,"rosmarinifolia",null,4]
[null,"x sepulcralis ‘Chrysocoma’(= a. Tristis)",4,null,83]
["Sambucus","nigra",null,3]
[null,"racemosa",null,3]
["Sorbus","aria & cultivars",4,5,86]
[null,"aucuparia & cultivars",5,4.0999999999999996,85]
[null,"intermedia & cultivars",5,5,85]
[null,"torminalis",5,6,86]
[null,"wilmoriana",5,5,85]
["Spiraea","Spiraea espèces érigées",null,4]
["Staphylea","Staphylea spp.",null,7]
["Stewartia","pseudocamellia",null,8]
["Styphnolobium","japonicum (syn. Sophora)",8,5,85]
[null,"japonicum ‘Pendula’",9,null,86]
["Styrax","japonicus",null,7]
["Syringa","Syringa spp.",null,7]
["Tamarix","Tamarix spp.",null,4]
["Tetradium","danieli",null,5]
["Tilia","cordata",5,4.0999999999999996,85]
[null,"‘Greenspire’",5,4.0999999999999996,84]
[null,"x europaea & cultivars",5,4.0999999999999996,84]
[null,"‘Pallida’",5,4.0999999999999996,84]
[null,"platyphyllos & cultivars",4,4.0999999999999996,84]
[null,"tomentosa & cultivars",4,4.0999999999999996,84]
["Ulmus","‘Camperdownii’",4,null,85]
[null,"glabra (=campestris, scabra))",4,null,83]
[null,"x hollandica ‘Wredei’",5,6,86]
[null,"minor (=carpinifolia)",4,null,83]
[null,"cultivars résistants (p.ex. Lobel, Columella)",5,null,84]
["Viburnum","x bodnantense & cultivars",null,5]
[null,"x burkwoodii",null,7]
["Viburnum","x carlcephalum"," "," "]
[null,"carlesii & cultivars",null,8]
[null,"carlesii 'Eskimo'",null,8]
[null,"farreri & cultivars",null,6]
[null,"henryi",null,8]
[null,"x \"Hilleri Wiinton\"",null,8]
[null,"lantana",null,4]
[null,"opulus",null,3]
[null,"opulus ‘Roseum’",null,4]
[null,"opulus ‘Xanthocarpum’",null,6]
[null,"plicatum & cultivars",null,8.1]
[null,"pragense",null,7]
[null,"tinus & cultivars",null,8.1]
["Vitex","agnuscastus",null,6]
["Weigela","espèces érigées",null,4]
["Zelkova","spp.",6,null,84]

{"sheet":"Essences - Conifères","index":4,"n_rows":130,"n_cols":7,"rows_kept":130,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,3,0,4]]}
["Conifères",null,"Abattages","Fournitures"]
[null,null,"\"Classification des espèces et variétés\"","Formes naturelles","Arbres d'avenues",null,"Liste Famille"]
["Abies","alba & cultivars",7,68,null,null,"Abies"]
[null,"concolor",9,71,null,null,"Araucaria"]
[null,"koreana",9,72,null,null,"Calocedrus"]
[null,"nordmanniana",9,70,null,null,"Cedrus"]
[null,"pinsapo",9,72,null,null,"Cephalotaxus"]
[null,"pinsapo  'Glauca'",10,null,null,null,"Chamaecyparis"]
[null,"procera",9,73,null,null,"Chamaecyparis"]
["Araucaria","araucana ",10,74,null,null,"Cryptomeria"]
["Calocedrus","decurrens",7,68,null,null,"x_Cupressocyparis"]
[null,"Calocedrus ‘Columnaris’",7,71,null,null,"Cupressus"]
["Cedrus","deodara & cultivars",8,69,null,null,"Ginkgo"]
[null,"Cedrus ‘Aurea’",9,70,null,null,"Juniperus"]
[null,"libani",9,69.099999999999994,null,null,"Larix"]
[null,"ssp. atlantica",8,69.099999999999994,null,null,"Metasequoia"]
[null,"libani ‘Atlantica Aurea’",9,71,null,null,"Picea"]
[null,"libani ‘Atlantica Pendula'",10,null,null,null,"Pinus"]
[null,"libani ‘Fastigiata’",9,70,null,null,"Platycladus"]
[null,"libani ‘Glauca’",9,69.099999999999994,null,null,"Pseudostuga"]
[null,"libani ‘Glauca Pendula’",10,71,null,null,"Sciadopitys"]
["Cephalotaxus","harringtonii & cultivars",null,71,null,null,"Sequoia"]
["Chamaecyparis","lawsoniana",6,null,null,null,"Sequoiadendron"]
[null,"lawsoniana ‘Alumigold’",7,69.099999999999994,null,null,"Taxodium"]
[null,"lawsoniana ‘Alumii’",7,68,null,null,"Taxus"]
[null,"lawsoniana ‘Blue Surprise’",7,70.099999999999994,null,null,"Thuja"]
[null,"lawsoniana ‘Columnaris’",7,68,null,null,"Thujopsis"]
[null,"lawsoniana ‘Erecta Aurea’",7,70,null,null,"Tsuga"]
[null,"lawsoniana ‘Erecta Viridis’",7,68]
[null,"lawsoniana ‘Green Pillar’",7,68]
[null,"lawsoniana ‘Ivonne’",7,69.099999999999994]
[null,"lawsoniana ‘Intertexta’",7,69]
[null,"lawsoniana ‘Lane’",7,69.099999999999994]
[null,"lawsoniana ‘Pelt’s Blue’",7,68]
[null,"lawsoniana ‘Pembury Blue’",7,70]
[null,"lawsoniana ‘Stewartii’",9,69.099999999999994]
["Chamaecyparis","nootkatensis ‘Glauca’",9,69]
[null,"Chamaecyparis ‘Pendula’",9,70]
[null,"obtusa sauf nains",null,72]
["Cryptomeria","japonica ‘Araucarioides’",null,71]
[null,"japonica ‘Elegans’",9,70]
[null,"japonica ‘Elegans Viridis’",9,70]
["x_Cupressocyparis","leylandii & cultivars",3,67]
[null,"leylandii ‘Castlewellan Gold’",3,68]
["Cupressus","arizonica",7,68]
[null,"sempervirens & cv",7,68]
["Ginkgo","biloba",7,68,86]
[null,"Ginkgo cv greffés sauf nains",7,70,87]
["Juniperus","communis \"Gold Cone\"",null,70]
[null,"communis ‘Hibernica’",null,69.099999999999994]
[null,"communis ‘Oblonga Pendula’",null,70]
[null,"communis ‘Sentinel’",null,70.099999999999994]
[null,"communis ‘Suecica’",null,69.099999999999994]
[null,"scopulorum ‘Blue Arrow’",null,68]
[null,"scopulorum ‘Skyrocket’",null,68]
[null,"scopulorum ‘Springbank’",null,70]
[null,"virginiana ‘Glauca’",7,69]
["Larix","decidua",5,67]
[null,"Larix ‘Pendula’",7,70]
[null,"kaempferi (=leptolepsis)",5,67]
[null,"kaempferi ‘Diana’",7,71]
[null,"kaempferi ‘Pendula’",7,70.099999999999994]
["Metasequoia","glybtostroboides",6,68,84]
["Picea","abies",3,68]
[null,"abies ‘Aurea’",69.099999999999994,69.099999999999994]
[null,"abies ‘Cranstonii’",null,70.099999999999994]
[null,"abies ‘Inversa’",null,71]
[null,"abies ‘Pendula Major’",null,70]
[null,"abies ‘Pyramidata’",7,69]
[null,"breweriana",7,72.099999999999994]
[null,"engelmannii",7,72]
[null,"likiangensis var. rubescens",8,72]
[null,"omorika",7,67]
[null,"omorika ‘Pendula’",7,70]
[null,"orientalis",8,69]
[null,"orientalis ‘Atrovirens’",8,70]
[null,"polita",8,72]
[null,"pungens",8,70]
[null,"bleu de semis",9,70]
[null,"cv greffés",9,72]
[null,"smithiana",8,72]
[null,"sitchensis",7,72]
["Pinus","aristata",null,74]
[null,"banksiana",9,71]
[null,"cembra",10,72]
[null,"contorta & cultivas",10,70]
[null,"densiflora",10,70]
[null,"heldreichii",9,71]
[null,"heldreichii ‘Satellit’",null,72]
[null,"mugo",9,70.099999999999994]
[null,"ssp. mugo",9,71]
[null,"mugo ‘Rigi’",null,71]
[null,"ssp. uncinata",9,70.099999999999994]
[null,"nigra ssp. Nigra & cultivars",6,69,85]
[null,"nigra ‘Pyramidalis’",6,71]
[null,"parviflora ‘Glauca’",6,72]
[null,"parviflora ‘Negishi’",8,73]
[null,"peuce",9,71]
[null,"pinea",8,70]
[null,"strobus",7,74]
[null,"sylvestris",8,69,85]
[null,"Pinus ‘Fastigiata’",8,71]
[null,"Pinus ‘Norska’",8,70,70]
[null,"Pinus ‘Watereri’",null,72]
[null,"wallichiana (=griffithii)",9,70]
[null,"Pinus ‘Densa’",null,71]
["Platycladus","orientalis (syn. Thuja orientalis)",7,68]
[null,"cv greffés sauf nains",7,70]
["Pseudostuga","menziensii",6,69]
["Sciadopitys","verticillata",10,73]
["Sequoia","sempervirens",8,68,84]
["Sequoiadendron","giganteum",8,70,84]
[null,"giganteum ‘Pendulum’",8,72]
["Taxodium","distichum",9,70,84]
[null,"distichum ‘Nutans’",9,72,85]
[null,"distichum ‘Pendens’",9,70]
["Taxus","baccata",9,70.099999999999994,87]
[null,"baccata ‘Fastigiata’",9,71]
[null,"baccata ‘Fastigiata Aurea’",9,72]
[null,"baccata ‘Fastigiata Robusta’",9,71]
[null,"x media \"Hicksii\"",null,70.099999999999994]
["Thuja","occidentalis",5,67]
[null,"occidentalis ‘Brabant’",5,67]
[null,"occidentalis ‘Columna’",5,68]
[null,"occidentalis ‘Fastigiata’",6,68]
[null,"occidentalis ‘Smaragd’ (syn. Emeraude)",5,68]
[null,"plicata ‘Atrovirens’ & \"Zebrina\"",6,67]
["Thujopsis","dolabrata",9,71]
["Tsuga","canadensis",8,70]
[null,"diversifolia",8,71]