{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["données peuplement","graphS%","S%"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":20,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"graphS%","index":1,"reason":"not_a_worksheet"}],"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":"données peuplement","index":0,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["densité de plantation",null,"ou ","espacement moyen (m) de plantation"]
[]
["hauteur","densité","ou","espacement moyen (m)","S%"]
[5,null,null,null,{"$f":"IF(B4>0,10746/(A4*SQRT(B4)),D4/A4*100)","v":0}]
[10,null,null,null,{"$f":"IF(B5>0,10746/(A5*SQRT(B5)),D5/A5*100)","v":0}]
[10,null,null,null,0]
[13,null,null,null,0]
[13,null,null,null,0]
[16,null,null,null,0]
[16,null,null,null,0]
[19,null,null,null,0]
[19,null,null,null,0]
[23,null,null,null,0]
[23,null,null,null,0]
[25,null,null,null,0]
[]
[]
[]
[]
["Mode d'emploi"]
["les cellules en jaunes sont à remplir"]
["les hauteurs peuvent si besoin être modifiées"]
["lors d'une éclaircie, indiquez la densité avant puis après éclaircie pour la même hauteur"]
[]
["Pour toute question : Jérôme ROSA (CRPF) au 02 48 26 43 08 - 06 14 52 88 65"]
["ou jerome.rosa@crpf.fr"]

{"sheet":"S%","index":2,"n_rows":45,"n_cols":53,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
["S%",0.2,null,"S%",0.3,null,"S%",0.5,null,"S%",1,null,"S%",0.15,null,"quadrillage des absisses"]
["Ho","N",null,"Ho","N",null,"Ho","N",null,"Ho","N",null,"Ho","N",null,"N","Ho4","Ho5","Ho6","Ho7","Ho8","Ho9","Ho10","Ho11","Ho12","Ho13","Ho14","Ho15","Ho16","Ho17","Ho18","Ho19","Ho20","Ho21","Ho22","Ho23","Ho24","Ho25","Ho26","Ho27","Ho28","Ho29","Ho30","Ho31","Ho32","Ho33","Ho34","Ho35","Ho36","Ho37","Ho38","Ho39","Ho40"]
[{"$f":"$A$10/(((B3*50000)^0.5)*$B$1)/400","v":0.18995892141289811},1E-3,{"$f":"B3*50000","v":50},{"$f":"$A$10/(((50000*E3)^0.5)*$E$1)/400","v":0.12663928094193211},1E-3,null,{"$f":"$A$10/(((50000*H3)^0.5)*$H$1)/400","v":7.5983568565159254E-2},1E-3,null,{"$f":"$A$10/(((50000*K3)^0.5)*$K$1)/400","v":3.7991784282579627E-2},1E-3,null,{"$f":"$A$10/(((50000*N3)^0.5)*$N$1)/400","v":0.25327856188386422},1E-3,null,0.1,0.01,{"$f":"5/400","v":1.2500000000000001E-2},{"$f":"6/400","v":1.4999999999999999E-2},{"$f":"7/400","v":1.7500000000000002E-2},{"$f":"8/400","v":0.02},{"$f":"9/400","v":2.2499999999999999E-2},{"$f":"10/400","v":2.5000000000000001E-2},{"$f":"11/400","v":2.75E-2},{"$f":"12/400","v":0.03},{"$f":"13/400","v":3.2500000000000001E-2},{"$f":"14/400","v":3.5000000000000003E-2},{"$f":"15/400","v":3.7499999999999999E-2},{"$f":"16/400","v":0.04},{"$f":"17/400","v":4.2500000000000003E-2},{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"19/400","v":4.7500000000000001E-2},{"$f":"20/400","v":0.05},5.2499999999999998E-2,5.5E-2,5.7500000000000002E-2,0.06,6.25E-2,6.5000000000000002E-2,6.7500000000000004E-2,7.0000000000000007E-2,7.2499999999999995E-2,7.4999999999999997E-2,7.7499999999999999E-2,0.08,8.2500000000000004E-2,8.5000000000000006E-2,8.7499999999999994E-2,0.09,9.2499999999999999E-2,9.5000000000000001E-2,9.7500000000000003E-2,0.1]
[{"$f":"$A$10/(((50000*B4)^0.5)*$B$1)/400","v":8.495221224235612E-2},{"$f":"250/50000","v":5.0000000000000001E-3},{"$f":"B4*50000","v":250},{"$f":"$A$10/(((50000*E4)^0.5)*$E$1)/400","v":5.6634808161570752E-2},{"$f":"250/50000","v":5.0000000000000001E-3},null,{"$f":"$A$10/(((50000*H4)^0.5)*$H$1)/400","v":3.3980884896942454E-2},{"$f":"250/50000","v":5.0000000000000001E-3},null,{"$f":"$A$10/(((50000*K4)^0.5)*$K$1)/400","v":1.6990442448471227E-2},{"$f":"250/50000","v":5.0000000000000001E-3},null,{"$f":"$A$10/(((50000*N4)^0.5)*$N$1)/400","v":0.1132696163231415},{"$f":"250/50000","v":5.0000000000000001E-3},null,1E-3,0.01,{"$f":"5/400","v":1.2500000000000001E-2},{"$f":"6/400","v":1.4999999999999999E-2},{"$f":"7/400","v":1.7500000000000002E-2},{"$f":"8/400","v":0.02},{"$f":"9/400","v":2.2499999999999999E-2},{"$f":"10/400","v":2.5000000000000001E-2},{"$f":"11/400","v":2.75E-2},{"$f":"12/400","v":0.03},{"$f":"13/400","v":3.2500000000000001E-2},{"$f":"14/400","v":3.5000000000000003E-2},{"$f":"15/400","v":3.7499999999999999E-2},{"$f":"16/400","v":0.04},{"$f":"17/400","v":4.2500000000000003E-2},{"$f":"18/400","v":4.4999999999999998E-2},{"$f":"19/400","v":4.7500000000000001E-2},{"$f":"20/400","v":0.05},5.2499999999999998E-2,5.5E-2,5.7500000000000002E-2,0.06,6.25E-2,6.5000000000000002E-2,6.7500000000000004E-2,7.0000000000000007E-2,7.2499999999999995E-2,7.4999999999999997E-2,7.7499999999999999E-2,0.08,8.2500000000000004E-2,8.5000000000000006E-2,8.7499999999999994E-2,0.09,9.2499999999999999E-2,9.5000000000000001E-2,9.7500000000000003E-2,0.1]
[{"$f":"$A$10/(((50000*B5)^0.5)*$B$1)/400","v":1.8995892141289814E-2},0.1,{"$f":"B5*50000","v":5000},{"$f":"$A$10/(((50000*E5)^0.5)*$E$1)/400","v":1.2663928094193208E-2},0.1,null,{"$f":"$A$10/(((50000*H5)^0.5)*$H$1)/400","v":7.5983568565159256E-3},0.1,null,{"$f":"$A$10/(((50000*K5)^0.5)*$K$1)/400","v":3.7991784282579628E-3},0.1,null,{"$f":"$A$10/(((50000*N5)^0.5)*$N$1)/400","v":2.5327856188386417E-2},0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"quadrillage des ordonnées"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ho","N50","N100","N150","N200","N250","N300","N350","N400","N450","N500","N600","N700","N800","N900","N1000","N1100","N1200","N1300","N1400","N1500","N1600","N1700","N1800","N1900","N2000","N2500","N3000","N3500","N4000","N4500","N5000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,1E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,6.0000000000000001E-3,7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.2E-2,1.4E-2,1.6E-2,1.7999999999999999E-2,0.02,2.1999999999999999E-2,2.4E-2,2.5999999999999999E-2,2.8000000000000001E-2,0.03,3.2000000000000001E-2,3.4000000000000002E-2,3.5999999999999997E-2,3.7999999999999999E-2,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,1E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,6.0000000000000001E-3,7.0000000000000001E-3,8.0000000000000002E-3,8.9999999999999993E-3,0.01,1.2E-2,1.4E-2,1.6E-2,1.7999999999999999E-2,0.02,2.1999999999999999E-2,2.4E-2,2.5999999999999999E-2,2.8000000000000001E-2,0.03,3.2000000000000001E-2,3.4000000000000002E-2,3.5999999999999997E-2,3.7999999999999999E-2,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1]
[{"$f":"(20000/3^0.5)^0.5","v":107.4569931823542}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Echelle absisses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,4.5,5.5,6.5,7.5,8.5,9.5,10.5,11.5,12.5,13.5,14.5,15.5,16.5,17.5,18.5,19.5,21,22,23,24,25,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3]
[]
[]
["S%",0.25]
["Ho","N"]
[{"$f":"$A$10/(((50000*B19)^0.5)*$B$17)/400","v":0.15196713713031851},1E-3]
[{"$f":"$A$10/(((50000*B20)^0.5)*$B$17)/400","v":6.7961769793884907E-2},{"$f":"250/50000","v":5.0000000000000001E-3}]
[{"$f":"$A$10/(((50000*B21)^0.5)*$B$17)/400","v":1.5196713713031851E-2},0.1]
[]
[]
[]
[]
["Plt1"]
["Ho","N","Ho/400","N/50000"]
[0.1,{"$f":"IF('données peuplement'!B1>0,'données peuplement'!B1,(107.46/('données peuplement'!E1))^2)","v":{"$error":"#DIV/0!"}},{"$f":"A28/400","v":2.5000000000000001E-4},{"$f":"B28/50000","v":{"$error":"#DIV/0!"}}]
[{"$f":"'données peuplement'!A4","v":5},{"$f":"IF('données peuplement'!B4>0,'données peuplement'!B4,(107.46/'données peuplement'!D4)^2)","v":{"$error":"#DIV/0!"}},{"$f":"A29/400","v":1.2500000000000001E-2},{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A5","v":10},{"$f":"IF('données peuplement'!B5>0,'données peuplement'!B5,(107.46/'données peuplement'!D5)^2)","v":{"$error":"#DIV/0!"}},2.5000000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A6","v":10},{"$f":"IF('données peuplement'!B6>0,'données peuplement'!B6,(107.46/'données peuplement'!D6)^2)","v":{"$error":"#DIV/0!"}},2.5000000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A7","v":13},{"$f":"IF('données peuplement'!B7>0,'données peuplement'!B7,(107.46/'données peuplement'!D7)^2)","v":{"$error":"#DIV/0!"}},3.2500000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A8","v":13},{"$f":"IF('données peuplement'!B8>0,'données peuplement'!B8,(107.46/'données peuplement'!D8)^2)","v":{"$error":"#DIV/0!"}},3.2500000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A9","v":16},{"$f":"IF('données peuplement'!B9>0,'données peuplement'!B9,(107.46/'données peuplement'!D9)^2)","v":{"$error":"#DIV/0!"}},{"$f":"A34/400","v":0.04},{"$f":"B34/50000","v":{"$error":"#DIV/0!"}}]
[{"$f":"'données peuplement'!A10","v":16},{"$f":"IF('données peuplement'!B10>0,'données peuplement'!B10,(107.46/'données peuplement'!D10)^2)","v":{"$error":"#DIV/0!"}},0.04,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A11","v":19},{"$f":"IF('données peuplement'!B11>0,'données peuplement'!B11,(107.46/'données peuplement'!D11)^2)","v":{"$error":"#DIV/0!"}},4.7500000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A12","v":19},{"$f":"IF('données peuplement'!B12>0,'données peuplement'!B12,(107.46/'données peuplement'!D12)^2)","v":{"$error":"#DIV/0!"}},4.7500000000000001E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A13","v":23},{"$f":"IF('données peuplement'!B13>0,'données peuplement'!B13,(107.46/'données peuplement'!D13)^2)","v":{"$error":"#DIV/0!"}},5.7500000000000002E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A14","v":23},{"$f":"IF('données peuplement'!B14>0,'données peuplement'!B14,(107.46/'données peuplement'!D14)^2)","v":{"$error":"#DIV/0!"}},5.7500000000000002E-2,{"$error":"#DIV/0!"}]
[{"$f":"'données peuplement'!A15","v":25},{"$f":"IF('données peuplement'!B15>0,'données peuplement'!B15,(107.46/'données peuplement'!D15)^2)","v":{"$error":"#DIV/0!"}},6.25E-2,{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SQRT(10000/0.866)","v":107.45856927604473}]