{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Essences du groupe SEPM","SEPMacro","PET et HEG","PRU THO et Trituration","PET Macro","Feuillus bois d’œuvre et pins","Feuillus_Macro","Fonctionnement"],"not_rendered":{"images":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Essences du groupe SEPM","index":0,"n_rows":197,"n_cols":20,"rows_kept":197,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"SEPM"]
[null,1,10,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},{"$f":"IF(L3=\"FFM\",H3,0)","v":0},{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",36]
[null,2,{"$nulls":6},{"$f":"IF(H4>0,IF(H4>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},{"v":15000,"d":"15,000"}]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",null,{"$f":"+T3","v":36},"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":15000},null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":36},900,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,43,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},1,"",""]
[{"$nulls":8},"",0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":10},{"$f":"IF(L62=\"FFM\",H62,0)","v":0},{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":36},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":15000},null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"L63","v":36},900,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},{"$f":"IF(L67=\"FFM\",H67,0)","v":0},{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},{"$f":"IF(L68=\"FFM\",H68,0)","v":0}]
[{"$nulls":10},{"$f":"IF(L69=\"FFM\",H69,0)","v":0}]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,{"$f":"IF(L70=\"FFM\",H70,0)","v":0},"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,60,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},{"$f":"IF(L71=\"FFM\",H71,0)","v":0},{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,"",""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",""]
[{"$nulls":10},{"$f":"IF(L96=\"FFM\",H96,0)","v":0},{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":36},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":15000},null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"L97","v":36},900,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,30,{"$nulls":5},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},"",""]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,"",""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":36},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":15000},null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"L130","v":36},990,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]
{"$rows_empty":57}
[{"$nulls":10},"MP :PAS"]

{"sheet":"SEPMacro","index":1,"n_rows":139,"n_cols":20,"rows_kept":139,"hidden":true,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"SEPM"]
[null,1,10,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",36]
[null,2,{"$nulls":6},{"$f":"IF(H4>0,IF(H4>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},10000]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",null,36,"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",7500,null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":36},890,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,43,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},1,{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},36,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",7500,null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"IF(L64>15,L63*2,L63)","v":36},900,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,60,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},1,{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},""]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},36,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",7500,null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"IF(L98>15,L97*2,L97)","v":36},900,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,30,{"$nulls":5},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},""]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},36,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",7500,null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"IF(L131>15,L130*2,L130)","v":36},990,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]

{"sheet":"PET et HEG","index":2,"n_rows":139,"n_cols":20,"rows_kept":139,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[31,12,32,14],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"PET et HEG"]
[null,1,190,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",10]
[null,2,{"$nulls":6},"",{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},{"v":10000,"d":"10,000"}]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",null,{"$f":"+T3","v":10},"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":10},900,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[{"$nulls":12},{"$f":"IF(J33=1,\"Inscrire le FacteurUtilisé\",\"\")","v":""}]
[{"$nulls":6},"N Éch Calculé",null,null,{"$f":"IF(ISERROR(L33),1,0)","v":0},null,{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,150,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(H38>0,IF(H38>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},""]
[{"$nulls":8},{"$f":"IF(H39>0,IF(H39>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",{"$f":"IF($L$64<16,1,2)","v":1},"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":10},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"+L63","v":10},1000,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,190,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},""]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":10},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"+L97","v":10},600,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,150,{"$nulls":5},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},""]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":10},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"+L130","v":10},1200,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]

{"sheet":"PRU THO et Trituration","index":3,"n_rows":139,"n_cols":20,"rows_kept":139,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[31,12,32,14],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"PRU THO et Trituration"]
[null,1,50,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",20]
[null,2,{"$nulls":6},"",{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},{"v":10000,"d":"10,000"}]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",null,{"$f":"+T3","v":20},"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":20},900,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[{"$nulls":12},{"$f":"IF(J33=1,\"Inscrire le FacteurUtilisé\",\"\")","v":""}]
[{"$nulls":6},"N Éch Calculé",null,null,{"$f":"IF(ISERROR(L33),1,0)","v":0},null,{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,80,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(H38>0,IF(H38>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},""]
[{"$nulls":8},{"$f":"IF(H39>0,IF(H39>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",{"$f":"IF($L$64<16,1,2)","v":1},"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":10},{"$f":"IF(L62=\"FFM\",H62,0)","v":0},{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":20},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"+L63","v":20},1000,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,50,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},""]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":20},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"+L97","v":20},600,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,80,{"$nulls":5},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},""]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},{"$f":"IF(AND(H106>0,H106<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L106>0,L106<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,4,{"$nulls":6},"",0,0,"","",1,"",{"$f":"IF(AND(H107>0,H107<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L107>0,L107<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":20},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":10000},null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"+L130","v":20},1200,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]

{"sheet":"PET Macro","index":4,"n_rows":139,"n_cols":20,"rows_kept":139,"hidden":true,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"PET PRU THO HEG Trituration"]
[null,1,190,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",20]
[null,2,{"$nulls":6},"",{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",""]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},10000]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",0,20,"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",10000,null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":20},960,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,50,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},{"$f":"IF(H38>0,IF(H38>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},""]
[{"$nulls":8},{"$f":"IF(H39>0,IF(H39>$F$65,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",{"$f":"IF($L$64<16,1,2)","v":1},"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},20,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",10000,null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"+L63","v":20},1000,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,80,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},""]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",""]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},20,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",10000,null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"+L97","v":20},600,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,150,{"$nulls":5},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$F$132),\"volume inférieur à\"&\" \"&$F$132 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},""]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",""]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},20,"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",10000,null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"+L130","v":20},1200,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]

{"sheet":"Feuillus bois d’œuvre et pins","index":5,"n_rows":197,"n_cols":20,"rows_kept":197,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"Feuillus bois d’œuvre et pins"]
[null,1,104,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",46]
[null,2,{"$nulls":6},{"$f":"IF(H4>0,IF(H4>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",{"$f":"IF(AND(H4>0,H4<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L4>0,L4<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},{"v":4500,"d":"4,500"}]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",{"$f":"IF(AND(H27>0,H27<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L27>0,L27<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",null,{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":4500},null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":46},1120,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,105,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},1,{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},{"$f":"IF(AND(H38>0,H38<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L38>0,L38<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",{"$f":"IF(AND(H61>0,H61<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L61>0,L61<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":10},{"$f":"IF(L62=\"FFM\",H62,0)","v":0},{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":4500},null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"L63","v":46},1040,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,132,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},1,{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},{"$f":"IF(AND(H72>0,H72<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L72>0,L72<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",{"$f":"IF(AND(H95>0,H95<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L95>0,L95<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":4500},null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"L97","v":46},1125,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,{"$nulls":6},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},{"$f":"IF(AND(H105>0,H105<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L105>0,L105<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",{"$f":"IF(AND(H128>0,H128<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L128>0,L128<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":4500},null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"L130","v":46},1100,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]
{"$rows_empty":57}
[{"$nulls":10},"MP :PAS"]

{"sheet":"Feuillus_Macro","index":6,"n_rows":197,"n_cols":20,"rows_kept":197,"hidden":true,"merged":[[0,11,0,12],[1,18,1,19],[2,15,2,16],[2,18,3,18],[2,19,3,19],[3,15,3,16],[4,15,4,16],[4,18,6,18],[5,15,5,16],[6,15,6,16],[7,15,7,16],[7,18,8,18],[8,15,8,16],[9,15,9,16],[9,18,10,18],[9,19,10,19],[10,15,10,16],[11,15,11,16],[12,15,12,16],[13,15,13,16],[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[26,15,26,16],[27,14,29,14],[27,15,29,15],[28,6,28,8],[28,12,29,12],[29,6,29,8],[30,5,30,6],[30,7,30,8],[32,6,32,8],[36,15,36,16],[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[46,15,46,16],[47,15,47,16],[48,15,48,16],[49,15,49,16],[50,15,50,16],[51,15,51,16],[52,15,52,16],[53,15,53,16],[54,15,54,16],[55,15,55,16],[56,15,56,16],[57,15,57,16],[58,15,58,16],[59,15,59,16],[60,15,60,16],[61,14,63,14],[61,15,63,15],[62,6,62,8],[62,12,63,12],[63,6,63,8],[64,5,64,6],[64,7,64,8],[66,6,66,8],[70,15,70,16],[71,15,71,16],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[77,15,77,16],[78,15,78,16],[79,15,79,16],[80,15,80,16],[81,15,81,16],[82,15,82,16],[83,15,83,16],[84,15,84,16],[85,15,85,16],[86,15,86,16],[87,15,87,16],[88,15,88,16],[89,15,89,16],[90,15,90,16],[91,15,91,16],[92,15,92,16],[93,15,93,16],[94,15,94,16],[95,14,97,14],[95,15,97,15],[96,6,96,8],[96,12,97,12],[97,6,97,8],[98,5,98,6],[98,7,98,8],[100,6,100,8],[103,15,103,16],[104,15,104,16],[105,15,105,16],[106,15,106,16],[107,15,107,16],[108,15,108,16],[109,15,109,16],[110,15,110,16],[111,15,111,16],[112,15,112,16],[113,15,113,16],[114,15,114,16],[115,15,115,16],[116,15,116,16],[117,15,117,16],[118,15,118,16],[119,15,119,16],[120,15,120,16],[121,15,121,16],[122,15,122,16],[123,15,123,16],[124,15,124,16],[125,15,125,16],[126,15,126,16],[127,15,127,16],[128,14,130,14],[128,15,130,15],[129,6,129,8],[129,12,130,12],[130,6,130,8],[131,5,131,6],[131,7,131,8],[136,6,136,8],[136,14,136,15],[137,14,137,15],[139,6,139,7]]}
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillonné",null,{"$f":"IF(L2=\"FFM\",H2,0)","v":0},"N éch","Pas","Facteur CVM","Prélèvement calculé",{"$nulls":3},"SEPM"]
[null,1,104,{"$nulls":5},{"$f":"IF(H3>0,IF(H3>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I3=\"Oui\",H3,0)","v":0},0,{"$f":"IF(H3>0,IF(I3=\"Oui\",ROUND(+H3*M$31/P$31,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H3>0,L3<>\"FFM\"),IF(L3<5,ROUNDDOWN(+H3*M$31/5/N3,-3),P$31/N3),\"\")","v":""},{"$f":"IF($L$30<16,1,2)","v":1},{"$f":"IF(L3=\"FFM\",0,IF(H3>0,+H3*M$31/M3,\"\"))","v":""},{"$f":"IF(AND(H3>0,H3<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L3>0,L3<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""},null,null,"Nombre de prélèvements requis par essence désignée",46]
[null,2,{"$nulls":6},{"$f":"IF(H4>0,IF(H4>$F$31,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I4=\"Oui\",H4,0)","v":0},0,"",{"$f":"IF(AND(H4>0,L4<>\"FFM\"),IF(L4<5,ROUNDDOWN(+H4*M$31/5/N4,-3),P$31/N4),\"\")","v":""},1,"",{"$f":"IF(AND(H4>0,H4<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L4>0,L4<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Nombre de prélèvements minimum par projet"]
[null,4,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},5]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Volume maximum FFM (m³/projet) (Volontaire)"]
[null,7,{"$nulls":6},"",0,0,"","",1,"","",{"$nulls":3},3000]
[null,8,{"$nulls":6},"",0,0,"","",1,"","",null,null,"Partie de chargement \n Facteur applicable si CVM > 15 ",2]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H19>0,L19<>\"FFM\"),IF(L19<5,ROUNDDOWN(+H19*M$31/5/N19,-3),P$31/N19),\"\")","v":""},1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",{"$f":"IF(AND(H27>0,H27<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L27>0,L27<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",null,null,"Oui",0,{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",null,null,"Non",1,15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":3000},null,{"$f":"SUM(J3:J27)","v":0},null,null,2,{"$f":"+L29","v":46},890,null,{"$f":"+M31*H31","v":0},{"$f":"ROUNDDOWN(+O31/L31,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O3:O27)","v":0}]
[]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,null,105,{"$nulls":5},{"$f":"IF(H37>0,IF(H37>$F$65,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I37=\"Oui\",H37,0)","v":0},{"$f":"IF(L37=\"FFM\",H37,0)","v":0},{"$f":"IF(H37>0,IF(I37=\"Oui\",ROUND(+H37*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H37>0,L37<>\"FFM\"),IF(L37<5,ROUNDDOWN(+H37*M$65/5/N37,-3),P$65/N37),\"\")","v":""},{"$f":"IF($L$64<16,1,2)","v":1},{"$f":"IF(L37=\"FFM\",0,IF(H37>0,+H37*M$65/M37,\"\"))","v":""},{"$f":"IF(AND(H37>0,H37<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L37>0,L37<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H38>0,IF(I38=\"Oui\",ROUND(+H38*M$65/P$65,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H38>0,L38<>\"FFM\"),IF(L38<5,ROUNDDOWN(+H38*M$65/5/N38,-3),P$65/N38),\"\")","v":""},1,{"$f":"IF(L38=\"FFM\",0,IF(H38>0,+H38*M$65/M38,\"\"))","v":""},{"$f":"IF(AND(H38>0,H38<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L38>0,L38<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":8},"",0,0,{"$f":"IF(H39>0,IF(I39=\"Oui\",ROUND(+H39*M$65/P$65,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L39=\"FFM\",0,IF(H39>0,+H39*M$65/M39,\"\"))","v":""},""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",""]
[{"$nulls":8},"",0,0,"","",1,"",{"$f":"IF(AND(H61>0,H61<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L61>0,L61<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":3000},null,{"$f":"SUM(J37:J61)","v":0},null,null,{"$f":"IF(L65=\"FFM\",H65,0)","v":0},{"$f":"IF(L64>15,L63*2,L63)","v":46},900,null,{"$f":"+M65*H65","v":0},{"$f":"ROUNDDOWN(+O65/L65,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":3},0,{"$f":"SUM(O37:O61)","v":0}]
[{"$nulls":10},0]
[{"$nulls":10},0]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,0,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,132,{"$nulls":5},{"$f":"IF(H71>0,IF(H71>$F$99,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I71=\"Oui\",H71,0)","v":0},0,{"$f":"IF(H71>0,IF(I71=\"Oui\",ROUND(+H71*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H71>0,L71<>\"FFM\"),IF(L71<5,ROUNDDOWN(+H71*M$99/5/N71,-3),P$99/N71),\"\")","v":""},{"$f":"IF($L$98<16,1,2)","v":1},{"$f":"IF(L71=\"FFM\",0,IF(H71>0,+H71*M$99/M71,\"\"))","v":""},{"$f":"IF(AND(H71>0,H71<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L71>0,L71<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H72>0,IF(H72>$F$99,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H72>0,IF(I72=\"Oui\",ROUND(+H72*M$99/P$99,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H72>0,L72<>\"FFM\"),IF(L72<5,ROUNDDOWN(+H72*M$99/5/N72,-3),P$99/N72),\"\")","v":""},1,{"$f":"IF(L72=\"FFM\",0,IF(H72>0,+H72*M$99/M72,\"\"))","v":""},{"$f":"IF(AND(H72>0,H72<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L72>0,L72<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},"",0,0,{"$f":"IF(H73>0,IF(I73=\"Oui\",ROUND(+H73*M$99/P$99,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L73=\"FFM\",0,IF(H73>0,+H73*M$99/M73,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"",{"$f":"IF(AND(H95>0,L95<>\"FFM\"),IF(L95<5,ROUNDDOWN(+H95*M$99/5/N95,-3),P$99/N95),\"\")","v":""},1,"",{"$f":"IF(AND(H95>0,H95<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L95>0,L95<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":10},0,{"$nulls":3},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":3000},null,{"$f":"SUM(J71:J95)","v":0},{"$nulls":3},{"$f":"IF(L98>15,L97*2,L97)","v":46},900,null,{"$f":"+M99*H99","v":0},{"$f":"ROUNDDOWN(+O99/L99,-3)","v":0}]
[]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O71:O95)","v":0}]
[]
[null,"Demande","Essence","UAM","Façonnage","Type","Op\ntion","Volume","Échantillon",null,null,"N éch","Pas","CVM","Prélèvement calculé"]
[null,1,{"$nulls":6},{"$f":"IF(H104>0,IF(H104>$F$132,\"Oui\",\"Non\"),\"\")","v":""},{"$f":"IF(I104=\"Oui\",H104,0)","v":0},{"$f":"IF(L104=\"FFM\",H104,0)","v":0},{"$f":"IF(H104>0,IF(I104=\"Oui\",ROUND(+H104*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H104>0,L104<>\"FFM\"),IF(L104<5,ROUNDDOWN(+H104*M$132/5/N104,-3),P$132/N104),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L104=\"FFM\",0,IF(H104>0,+H104*M$132/M104,\"\"))","v":""},{"$f":"IF(AND(H104>0,H104<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L104>0,L104<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,2,{"$nulls":6},{"$f":"IF(H105>0,IF(H105>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H105>0,IF(I105=\"Oui\",ROUND(+H105*M$132/P$132,0),\"FFM\"),\"\")","v":""},{"$f":"IF(AND(H105>0,L105<>\"FFM\"),IF(L105<5,ROUNDDOWN(+H105*M$132/5/N105,-3),P$132/N105),\"\")","v":""},{"$f":"IF($L$131<16,1,2)","v":1},{"$f":"IF(L105=\"FFM\",0,IF(H105>0,+H105*M$132/M105,\"\"))","v":""},{"$f":"IF(AND(H105>0,H105<=$T$9),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L105>0,L105<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[null,3,{"$nulls":6},{"$f":"IF(H106>0,IF(H106>$F$132,\"Oui\",\"Non\"),\"\")","v":""},0,0,{"$f":"IF(H106>0,IF(I106=\"Oui\",ROUND(+H106*M$132/P$132,0),\"FFM\"),\"\")","v":""},"",1,{"$f":"IF(L106=\"FFM\",0,IF(H106>0,+H106*M$132/M106,\"\"))","v":""},""]
[null,4,{"$nulls":6},"",0,0,"","",1,"",""]
[null,5,{"$nulls":6},"",0,0,"","",1,"",""]
[null,6,{"$nulls":6},"",0,0,"","",1,"",""]
[null,7,{"$nulls":6},"",0,0,"","",1,"",""]
[null,8,{"$nulls":6},"",0,0,"","",1,"",""]
[null,9,{"$nulls":6},"",0,0,"","",1,"",""]
[null,10,{"$nulls":6},"",0,0,"","",1,"",""]
[null,11,{"$nulls":6},"",0,0,"","",1,"",""]
[null,12,{"$nulls":6},"",0,0,"","",1,"",""]
[null,13,{"$nulls":6},"",0,0,"","",1,"",""]
[null,14,{"$nulls":6},"",0,0,"","",1,"",""]
[null,15,{"$nulls":6},"",0,0,"","",1,"",""]
[null,16,{"$nulls":6},"",0,0,"","",1,"",""]
[null,17,{"$nulls":6},"",0,0,"","",1,"",""]
[null,18,{"$nulls":6},"",0,0,"","",1,"",""]
[null,19,{"$nulls":6},"",0,0,"","",1,"",""]
[null,20,{"$nulls":6},"",0,0,"","",1,"",""]
[null,21,{"$nulls":6},"",0,0,"","",1,"",""]
[null,22,{"$nulls":6},"",0,0,"","",1,"",""]
[null,23,{"$nulls":6},"",0,0,"","",1,"",""]
[null,24,{"$nulls":6},"",0,0,"","",1,"",""]
[null,25,{"$nulls":6},"",0,0,"","",1,"",{"$f":"IF(AND(H128>0,H128<=$F$132),\"volume inférieur à\"&\" \"&$T$9 &\" m³\"&\" = FFM\",IF(AND(L128>0,L128<5),\" Calcul d'un PAS pour min 5 échantillon\",\"\"))","v":""}]
[{"$nulls":14},"Masse Échantillonnée","PAS pour plus de 5"]
[{"$nulls":6},"Nbre Éch Minimum",{"$nulls":4},{"$f":"+T3","v":46},"Facteur utilisé"]
[{"$nulls":6},"CVM",{"$nulls":4},15]
[{"$nulls":4},"Total > ",{"$f":"+T9","v":3000},null,{"$f":"SUM(J104:J128)","v":0},{"$nulls":3},{"$f":"IF(L131>15,L130*2,L130)","v":46},990,null,{"$f":"+M132*H132","v":0},{"$f":"ROUNDDOWN(+O132/L132,-3)","v":0}]
[{"$nulls":6},"N Éch Calculé",{"$nulls":4},{"$f":"SUM(O104:O128)","v":0}]
[]
[]
[]
[{"$nulls":6},"Tot client",{"$nulls":4},{"$f":"+L101+L67+L33+L133","v":0},null,null,"Volume en FFM",null,{"$f":"SUM(K3:K27,K37:K61,K71:K95,K104:K128)","v":0},{"$f":"+Q137/(Q137+Q138)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":14},"Volume Échantillonné",null,{"$f":"SUM(H104:H128,H71:H95,H37:H61,H3:H27)-Q137","v":0}]
[{"$nulls":16},{"$f":"+Q138+Q137","v":0}]
{"$rows_empty":57}
[{"$nulls":10},"MP :PAS"]

{"sheet":"Fonctionnement","index":7,"n_rows":2,"n_cols":6,"rows_kept":2,"merged":[[1,5,2,7]]}
[]
[{"$nulls":5},"Cellule Automatisée mais modifiable"]