{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ech_Dyn"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ech_Dyn","index":0,"n_rows":39,"n_cols":30,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,10,13,11],[14,10,14,11],[12,10,12,11],[22,10,22,11],[23,10,23,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[0,3,2,10],[8,10,8,11],[9,10,9,11],[10,10,10,11],[11,10,11,11],[4,9,4,11],[4,4,4,7],[6,8,6,9],[6,3,6,7],[3,3,3,11],[6,10,6,11],[7,10,7,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[31,10,31,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[30,10,30,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[24,10,24,11],[25,10,25,11],[26,10,26,11]]}
[null,null,null,"Suivi des Plans\nd'Échantillonnages Dynamisés"]
[]
[]
[null,null,null,"Activer les Macros pour que le tableau se complète automatiquement avec de nouvelles pages."]
[null,null,null,"Réf. :",null,null,null,null,"Dés. :"]
[]
[null,"Qté","Qté","Echantillonnage (100% / Niv II / S-4)",null,null,null,null,"Décision",null,"Observations",null,null,"Règles up-down",null,null,null,null,"Règles down-up",null,null,null,null,null,"Tables d'échantillonage"]
[null,"Présentée","à Prélever",1,"Renforcé","Normal","Allégé","Sondage","Accepté","Refusé","et détails éventuels des défauts observés",null,null,1,"Renforcé","Normal","Allégé",null,"Sondage","Allégé","Normal","Renforcé",null,"Mémoire","Effectif min","Effectif max","Renforcé","Normal","Allégé","Sondage"]
[null,null,{"$f":"IF(B9=\"SAP\",\"SAP\",IF(B9=\"\",\"\",IF(D9=\"X\",B9,IF(E9=\"X\",MIN(B9,VLOOKUP(B9,$Y$9:$AD$39,3,TRUE)),IF(F9=\"X\",VLOOKUP(B9,$Y$9:$AD$39,4,TRUE),IF(G9=\"X\",VLOOKUP(B9,$Y$9:$AD$39,5,TRUE),IF(H9=\"X\",VLOOKUP(B9,$Y$9:$AD$39,6,TRUE))))))))","v":""},"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,1,1,1]
[null,null,"",{"$f":"IF(COUNTIF(I9:J9,\"X\")=0,\"\",IF(N10+SUM(S10:V10)=0,D9,IF(N10=1,\"X\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J9,\"X\")>=5,1-SUM(S10:V10),0)","v":0},{"$f":"IF(COUNTIF(J$9:J9,\"X\")>=2,IF(N10=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(J9,\"X\")>=1,IF(SUM(N10:O10)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(J9,\"X\")>=1,IF(SUM(N10:O10)>0,0,1),0)","v":0},null,{"$f":"IF(COUNTIF(I$9:I9,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I9,\"X\")>=10,IF(S10=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I9,\"X\")>=5,IF(SUM(S10:T10)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I9,\"X\")>=2,IF(SUM(S10:U10)>0,0,IF(D9=\"X\",1,0)),0)","v":0},null,{"$f":"IF(SUM(N10:V10)=0,\"!\",\"\")","v":"!"},2,8,4,2,2,2]
[null,null,"",{"$f":"IF(COUNTIF(I10:J10,\"X\")=0,\"\",IF(N11+SUM(S11:V11)=0,D10,IF(N11=1,\"X\",\"\")))","v":""},{"$f":"IF(COUNTIF(I10:J10,\"X\")=0,\"\",IF(SUM(N11:O11)+SUM(S11:V11)=0,E10,IF(AND(D11<>\"X\",O11=1),\"X\",IF(V11=1,\"X\",\"\"))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J10,\"X\")>=5,1-SUM(S11:V11),0)","v":0},{"$f":"IF(COUNTIF(J$9:J10,\"X\")>=2,IF(N11=1,0,1),0)","v":0},0,0,null,{"$f":"IF(COUNTIF(I$9:I10,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I10,\"X\")>=10,IF(S11=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I10,\"X\")>=5,IF(SUM(S11:T11)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I10,\"X\")>=2,IF(SUM(S11:U11)>0,0,IF(D10=\"X\",1,0)),0)","v":0},null,{"$f":"IF(SUM(N11:V11)=0,\"!\",\"\")","v":"!"},9,15,6,3,2,2]
[null,null,"",{"$f":"IF(COUNTIF(I11:J11,\"X\")=0,\"\",IF(N12+SUM(S12:V12)=0,D11,IF(N12=1,\"X\",\"\")))","v":""},{"$f":"IF(COUNTIF(I11:J11,\"X\")=0,\"\",IF(SUM(N12:O12)+SUM(S12:V12)=0,E11,IF(AND(D12<>\"X\",O12=1),\"X\",IF(V12=1,\"X\",\"\"))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J11,\"X\")>=5,1-SUM(S12:V12),0)","v":0},{"$f":"IF(COUNTIF(J$9:J11,\"X\")>=2,IF(N12=1,0,1),0)","v":0},0,0,null,{"$f":"IF(COUNTIF(I$9:I11,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I11,\"X\")>=10,IF(S12=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I11,\"X\")>=5,IF(SUM(S12:T12)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(I10:I11,\"X\")>=2,IF(SUM(S12:U12)>0,0,IF(D11=\"X\",1,0)),0)","v":0},null,"!",16,25,10,5,2,2]
[null,null,"","","",null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J12,\"X\")>=5,1-SUM(S13:V13),0)","v":0},{"$f":"IF(COUNTIF(J$9:J12,\"X\")>=2,IF(N13=1,0,1),0)","v":0},0,0,null,{"$f":"IF(COUNTIF(I$9:I12,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I12,\"X\")>=10,IF(S13=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I12,\"X\")>=5,IF(SUM(S13:T13)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(I11:I12,\"X\")>=2,IF(SUM(S13:U13)>0,0,IF(D12=\"X\",1,0)),0)","v":0},null,"!",26,50,16,8,3,2]
[null,null,"","","",{"$f":"IF(COUNTIF(I13:J13,\"X\")=0,\"\",IF(SUM(N14:P14)+SUM(S14:V14)=0,F13,IF(AND(COUNTIF(D14:E14,\"X\")=0,P14=1),\"X\",IF(U14=1,\"X\",\"\"))))","v":""},null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J13,\"X\")>=5,1-SUM(S14:V14),0)","v":0},{"$f":"IF(COUNTIF(J$9:J13,\"X\")>=2,IF(N14=1,0,1),0)","v":0},0,0,null,{"$f":"IF(COUNTIF(I$9:I13,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I13,\"X\")>=10,IF(S14=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I$9:I13,\"X\")>=5,IF(SUM(S14:T14)>0,0,1),0)","v":0},0,null,"!",51,90,26,13,5,3]
[null,null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J14,\"X\")>=5,1-SUM(S15:V15),0)","v":0},{"$f":"IF(COUNTIF(J10:J14,\"X\")>=2,IF(N15=1,0,1),0)","v":0},0,{"$f":"IF(COUNTIF(J14,\"X\")>=1,IF(SUM(N15:O15)>0,0,1),0)","v":0},null,{"$f":"IF(COUNTIF(I$9:I14,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I14,\"X\")>=10,IF(S15=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I10:I14,\"X\")>=5,IF(SUM(S15:T15)>0,0,1),0)","v":0},0,null,"!",91,150,40,20,8,3]
[null,null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J15,\"X\")>=5,1-SUM(S16:V16),0)","v":0},0,0,{"$f":"IF(COUNTIF(J15,\"X\")>=1,IF(SUM(N16:O16)>0,0,1),0)","v":0},null,{"$f":"IF(COUNTIF(I$9:I15,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I15,\"X\")>=10,IF(S16=1,0,1),0)","v":0},0,0,null,"!",151,280,64,32,13,3]
[null,null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J16,\"X\")>=5,1-SUM(S17:V17),0)","v":0},0,0,0,null,{"$f":"IF(COUNTIF(I$9:I16,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I16,\"X\")>=10,IF(S17=1,0,1),0)","v":0},0,0,null,"!",281,500,100,50,20,3]
[null,null,"","","","",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J17,\"X\")>=5,1-SUM(S18:V18),0)","v":0},0,0,0,null,{"$f":"IF(COUNTIF(I$9:I17,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I17,\"X\")>=10,IF(S18=1,0,1),0)","v":0},0,0,null,"!",501,1200,160,80,32,5]
[null,null,"","","","",{"$f":"IF(COUNTIF(I18:J18,\"X\")=0,\"\",IF(AND(COUNTIF(D19:F19,\"X\")=0,Q19=1),\"X\",IF(T19=1,\"X\",\"\")))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTIF(J$9:J18,\"X\")>=5,1-SUM(S19:V19),0)","v":0},0,0,0,null,{"$f":"IF(COUNTIF(I$9:I18,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I$9:I18,\"X\")>=10,IF(S19=1,0,1),0)","v":0},0,0,null,"!",1201,3200,250,125,50,5]
[null,null,"","","","","",null,null,null,null,null,null,{"$f":"IF(COUNTIF(J10:J19,\"X\")>=5,1-SUM(S20:V20),0)","v":0},0,0,0,null,{"$f":"IF(COUNTIF(I$9:I19,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I10:I19,\"X\")>=10,IF(S20=1,0,1),0)","v":0},0,0,null,"!",3201,10000,400,200,80,5]
[null,null,"","","","","",null,null,null,null,null,null,{"$f":"IF(COUNTIF(J11:J20,\"X\")>=5,1-SUM(S21:V21),0)","v":0},0,0,0,null,{"$f":"IF(COUNTIF(I$9:I20,\"X\")>=15,1,0)","v":0},0,0,0,null,"!",10001,35000,630,315,125,5]
[null,null,"","","","",{"$f":"IF(COUNTIF(I21:J21,\"X\")=0,\"\",IF(AND(COUNTIF(D22:F22,\"X\")=0,Q22=1),\"X\",IF(T22=1,\"X\",\"\")))","v":""},null,null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I$9:I21,\"X\")>=15,1,0)","v":0},0,0,0,null,"!",35001,150000,1000,500,200,8]
[null,null,"","","","",{"$f":"IF(COUNTIF(I22:J22,\"X\")=0,\"\",IF(AND(COUNTIF(D23:F23,\"X\")=0,Q23=1),\"X\",IF(T23=1,\"X\",\"\")))","v":""},null,null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I$9:I22,\"X\")>=15,1,0)","v":0},0,0,{"$f":"IF(COUNTIF(I21:I22,\"X\")>=2,IF(SUM(S23:U23)>0,0,IF(D22=\"X\",1,0)),0)","v":0},null,"!",150001,500000,1600,800,315,8]
[null,null,"","","","","",{"$f":"IF(COUNTIF(I23:J23,\"X\")=0,\"\",IF(R24=1,\"X\",IF(S24=1,\"X\",\"\")))","v":""},null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I$9:I23,\"X\")>=15,1,0)","v":0},0,0,{"$f":"IF(COUNTIF(I22:I23,\"X\")>=2,IF(SUM(S24:U24)>0,0,IF(D23=\"X\",1,0)),0)","v":0},null,"!",500001,1E+20,2500,1250,500,8]
[null,null,"","","","","",{"$f":"IF(COUNTIF(I24:J24,\"X\")=0,\"\",IF(R25=1,\"X\",IF(S25=1,\"X\",\"\")))","v":""},null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I10:I24,\"X\")>=15,1,0)","v":0},0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I11:I25,\"X\")>=15,1,0)","v":0},0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,{"$f":"IF(COUNTIF(J22:J26,\"X\")>=2,IF(N27=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(J26,\"X\")>=1,IF(SUM(N27:O27)>0,0,1),0)","v":0},0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","",{"$f":"IF(COUNTIF(I30:J30,\"X\")=0,\"\",IF(SUM(N31:P31)+SUM(S31:V31)=0,F30,IF(AND(COUNTIF(D31:E31,\"X\")=0,P31=1),\"X\",IF(U31=1,\"X\",\"\"))))","v":""},"","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","",{"$f":"IF(COUNTIF(I31:J31,\"X\")=0,\"\",IF(SUM(N32:P32)+SUM(S32:V32)=0,F31,IF(AND(COUNTIF(D32:E32,\"X\")=0,P32=1),\"X\",IF(U32=1,\"X\",\"\"))))","v":""},"","",null,null,null,null,null,0,0,0,0,null,{"$f":"IF(COUNTIF(I17:I31,\"X\")>=15,1,0)","v":0},0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"","","","","","",null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,"!"]
[null,null,"",{"$f":"IF(COUNTIF(I38:J38,\"X\")=0,\"\",IF(N39+SUM(S39:V39)=0,D38,IF(N39=1,\"X\",\"\")))","v":""},{"$f":"IF(COUNTIF(I38:J38,\"X\")=0,\"\",IF(SUM(N39:O39)+SUM(S39:V39)=0,E38,IF(AND(D39<>\"X\",O39=1),\"X\",IF(V39=1,\"X\",\"\"))))","v":""},{"$f":"IF(COUNTIF(I38:J38,\"X\")=0,\"\",IF(SUM(N39:P39)+SUM(S39:V39)=0,F38,IF(AND(COUNTIF(D39:E39,\"X\")=0,P39=1),\"X\",IF(U39=1,\"X\",\"\"))))","v":""},{"$f":"IF(COUNTIF(I38:J38,\"X\")=0,\"\",IF(AND(COUNTIF(D39:F39,\"X\")=0,Q39=1),\"X\",IF(T39=1,\"X\",\"\")))","v":""},{"$f":"IF(COUNTIF(I38:J38,\"X\")=0,\"\",IF(R39=1,\"X\",IF(S39=1,\"X\",\"\")))","v":""},null,null,null,null,null,{"$f":"IF(COUNTIF(J29:J38,\"X\")>=5,1-SUM(S39:V39),0)","v":0},{"$f":"IF(COUNTIF(J34:J38,\"X\")>=2,IF(N39=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(J38,\"X\")>=1,IF(SUM(N39:O39)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(J38,\"X\")>=1,IF(SUM(N39:O39)>0,0,1),0)","v":0},null,{"$f":"IF(COUNTIF(I24:I38,\"X\")>=15,1,0)","v":0},{"$f":"IF(COUNTIF(I29:I38,\"X\")>=10,IF(S39=1,0,1),0)","v":0},{"$f":"IF(COUNTIF(I34:I38,\"X\")>=5,IF(SUM(S39:T39)>0,0,1),0)","v":0},{"$f":"IF(COUNTIF(I37:I38,\"X\")>=2,IF(SUM(S39:U39)>0,0,IF(D38=\"X\",1,0)),0)","v":0},null,{"$f":"IF(SUM(N39:V39)=0,\"!\",\"\")","v":"!"}]