{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil2","index":0,"n_rows":88,"n_cols":33,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,22,1,23],[1,25,1,26],[1,28,1,29],[1,7,1,8],[1,10,1,11],[1,13,1,14],[1,16,1,17],[1,19,1,20],[3,0,4,5],[5,0,5,5],[6,0,6,5],[3,31,7,31],[3,32,7,32]]}
[]
[null,null,null,null,null,null,null,"HICHAM",null,null,"LEILA",null,null,"MOHAMMED",null,null,"ABEDERRAHIM",null,null,"YOUSSOUFIA",null,null,"CASABLANCA",null,null,"BRAHIM",null,null,"OUARZAZATE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIN","NOM"]
[]
[]
[]
[null,"Code ","Description","Remarques sur l’article","Unité","Qté"]
[null,"F1",null,null,null,6,"C",5000,{"$f":"IF(G9=\"c\",F9*H9,\"\")","v":30000},"D ",0,{"$f":"IF(J9=\"c\",F9*K9,\"\")","v":""},"N.C, propose longueur de 5,8 ML au lieu de 12 M + matière",1000,{"$f":"IF(M9=\"c\",F9*N9,\"\")","v":""},"C",912.84,{"$f":"IF(P9=\"c\",F9*Q9,\"\")","v":5477.04},"D",0,{"$f":"IF(S9=\"c\",F9*T9,\"\")","v":""},"N.C, propose longueur de 6 M au lieu de 12 M + matière ",1450,{"$f":"IF(V9=\"c\",F9*W9,\"\")","v":""},"D",0,{"$f":"IF(Y9=\"c\",F9*Z9,\"\")","v":""},"C",2725,{"$f":"IF(AB9=\"c\",F9*AC9,\"\")","v":16350},null,{"$f":"MIN(I9,L9,O9,R9,U9,X9,AA9,AD9)","v":5477.04},"ABEDERRAHIM"]
[null,"F2",null,null,null,6,"C",15000,{"$f":"IF(G10=\"c\",F10*H10,\"\")","v":90000},"C",13500,{"$f":"IF(J10=\"c\",F10*K10,\"\")","v":81000},"N.C, propose longueur de 4,7 ML au lieu de 6M",1900,{"$f":"IF(M10=\"c\",F10*N10,\"\")","v":""},"C",847.8,{"$f":"IF(P10=\"c\",F10*Q10,\"\")","v":5086.7999999999993},"C",1188,{"$f":"IF(S10=\"c\",F10*T10,\"\")","v":7128},"D",0,{"$f":"IF(V10=\"c\",F10*W10,\"\")","v":""},"D",0,{"$f":"IF(Y10=\"c\",F10*Z10,\"\")","v":""},"C",2026,{"$f":"IF(AB10=\"c\",F10*AC10,\"\")","v":12156},null,{"$f":"MIN(I10,L10,O10,R10,U10,X10,AA10,AD10)","v":5086.7999999999993},"ABEDERRAHIM"]
[null,"F3",null,null,null,2,"C",250.7,501.4,"C",90,180,"C",164,328,"C",9.42,18.84,"D",0,"","D",0,"","\nN.C, propose matière A 105",41.47,18.84,"D ",336,"",null,18.84,"ABEDERRAHIM;BRAHIM"]
[null,"F4",null,null,null,2,"C",425.5,851,"C",305,610,"C",300,600,"C",41.46,82.92,"C",332,664,"C ",350,"","C",393.25,786.5,"C",336,672,null,82.92,"ABEDERRAHIM"]
[null,"F5",null,null,null,3,"C",862.5,2587.5,"C",2310,6930,"C",1464,4392,"C",440.88,1322.6399999999999,"C",1078,3234,"D",0,"","D",0,"","C",362,1086,null,1086,"OUARZAZATE"]
[null,"F6",null,null,null,9,"C",545.5,4909.5,"C",370,3330,"C",310,2790,"C",null,null,"C",332,2988,"C ",230,"","C",250.25,2252.25,"C",362,3258,null,2252.25,"BRAHIM"]
[null,"F7",null,null,null,34,"C",560,19040,"D",0,"","C",1799,61166,"C",3136.5,106641,"D",0,"","C ",440,"","D",0,"","C",334,11356,null,11356,"OUARZAZATE"]
[null,"F8",null,null,null,48,"C",320,15360,"D",0,"","C",205,9840,"C",235.2,11289.599999999999,"D",0,"","C ",88,"","D",0,"","C",60,2880,null,2880,"OUARZAZATE"]
[null,"F9",null,null,null,16,"C",230,3680,"C",140,2240,"C",90,1440,"C",68,1088,"D",0,"","N.C, propose matière 316 L au lieu de 304 L",132,"","N.C, propose matière 316 L au lieu de 304 L",150.15,"","C",120,1920,null,1088,"ABEDERRAHIM"]
[null,"F10",null,null,null,18,"C",250,4500,"C",114,2052,"C",233,4194,"C",95.4,1717.2,"D",0,"","D",0,""," N.C, propose matière A 105",48.62,"","D",1181,"",null,1717.2,"ABEDERRAHIM"]
[null,"F11",null,null,null,1,"C",2200,2200,"C",900,900,"C",700,700,"C",75.36,75.36,"C",1194,1194,"C ",1080,"","C",1229.8,1229.8,"C",1181,1181,null,75.36,"ABEDERRAHIM"]
[null,"F12",null,null,null,2,"C",390,780,"D",0,"","C",432,864,"C",24.5,49,"C",746,1492,"D",0,"","D",0,"","C",445,890,null,49,"ABEDERRAHIM"]
[null,"F13",null,null,null,4,"C",4200,16800,"C",2990,11960,"C",1464,5856,"C",587.84,2351.36,"C",1078,4312,"D",0,"","D",0,"","C",1145,4580,null,2351.36,"ABEDERRAHIM"]
[null,"F14",null,null,null,36,"C",150,5400,"D",0,"","C",26,936,"C",169.56,6104.16,"D",0,"","C ",36,"","D",0,"","C",64,2304,null,936,"MOHAMMED"]
[null,"F15",null,null,null,48,"C",180,8640,"D",0,"","C",38,1824,"C",268.8,12902.400000000001,"D",0,"","C ",49,"","D",0,"","C",94,4512,null,1824,"MOHAMMED"]
[null,"F16",null,null,null,72,"C",350,25200,"D",0,"","C",55,3960,"C",392.4,28252.799999999999,"D",0,"","C ",74,"","D",0,"","C",116,8352,null,3960,"MOHAMMED"]
[null,"F17",null,null,null,270,"C",640,172800,"D",0,"","C",80,21600,"C",2613.6,705672,"C",0,0,"C ",100,"","D",0,"","C",195,52650,null,0,"YOUSSOUFIA"]
[null,"F18",null,null,null,48,"C",1200,57600,"D",0,"","C",320,15360,"C",1316.16,63175.680000000008,"D",0,"","C ",301,"","D",0,"","C",674,32352,null,15360,"MOHAMMED"]
[null,"F19",null,null,null,12,"C",8500,102000,"D",0,"","C",43,516,"C",15,180,"D",0,"","D",0,"","D",0,"","C",99,1188,null,180,"ABEDERRAHIM"]
[null,"F20",null,null,null,15,"C",505,7575,"D",0,"","C",40,600,"C",30,450,"D",0,"","D",0,"","C",48.62,729.3,"C",126,1890,null,450,"ABEDERRAHIM"]
[null,"F21",null,null,null,15,"C",675.75,10136.25,"D",0,"","C",20,300,"C",62.25,933.75,"D",0,"","C ",26,"","D",0,"","C",28,420,null,300,"MOHAMMED"]
[null,"F22",null,null,null,30,"C",560,16800,"D",0,"","C",25,750,"C",94.5,2835,"D",0,"","C ",30,"","D",0,"","C",31,930,null,750,"MOHAMMED"]
[null,"F23",null,null,null,8,"C",1500,12000,"D",0,"","C",618,4944,"C",256.24,2049.92,"D ",0,"","D",0,"","C",536.25,4290,"C",166,1328,null,1328,"OUARZAZATE"]
[null,"F24",null,null,null,7,"C",520,3640,"D",0,"","C",275,1925,"C",23.8,166.6,"D",0,"","D",0,"","N.C, propose matière A234  au lieu de A420",41.47,"","C",24,168,null,166.6,"ABEDERRAHIM"]
[null,"F25",null,null,null,15,"C",680,10200,"D",0,"","N.C, propose extrémité BW au lieu de SW",81,"","C",31.5,472.5,"D",0,"","C ",23,"","C",48.62,729.3,"C",60,900,null,472.5,"ABEDERRAHIM"]
[null,"F26",null,null,null,18,"C",950,17100,"D",0,"","N.C, propose extrémité BW au lieu de SW",20,"","C",74.7,1344.6000000000001,"D",0,"","C ",40,"","D",0,"","C",91,1638,null,1344.6000000000001,"ABEDERRAHIM"]
[null,"F27",null,null,null,15,"C",1530,22950,"D",0,"","N.C, propose extrémité BW au lieu de SW",25,"","C",107.4,1611,"D",0,"","C ",64,"","C",41.47,622.04999999999995,"C",114,1710,null,622.04999999999995,"BRAHIM"]
[null,"F28",null,null,null,15,"C",1860,27900,"D",0,"","C",200,3000,"C",116.25,1743.75,"D",0,"","C ",70,"","D",0,"","C",122,1830,null,1743.75,"ABEDERRAHIM"]
[null,"F29",null,null,null,6,"C",2500,15000,"D",0,"","C",312,1872,"C",99.48,596.88,"D",0,"","C ",162,"","C",183.04,1098.24,"C",154,924,null,596.88,"ABEDERRAHIM"]
[null,"F30",null,null,null,2,"C",2840,5680,"D",0,"","C",458,916,"C",24.12,48.24,"D",0,"","C ",120,"","C",80.08,160.16,"C",83,166,null,48.24,"ABEDERRAHIM"]
[null,"F31",null,null,null,15,"C",5400,81000,"D",0,"","D",0,"","C",675,10125,"D",0,"","D",0,"","D",0,"","C",119,1785,null,1785,"OUARZAZATE"]
[null,"F32",null,null,null,8,"C",8500,68000,"D",0,"","D",0,"","C",0,0,"D ",0,"","D",0,"","D",0,"","C",126,1008,null,0,"ABEDERRAHIM"]
[null,"F33",null,null,null,12,"C",1850,22200,"D",0,"","D",0,"","C",300,3600,"D",0,"","D",0,"","D",0,"","C",130,1560,null,1560,"OUARZAZATE"]
[null,"F34",null,null,null,8,"C",4350,34800,"D",0,"","D",0,"","C",0,0,"D ",0,"","D",0,"","D",0,"","C",138,1104,null,0,"ABEDERRAHIM"]
[null,"F35",null,null,null,10,"C",685,6850,"D",0,"","D",0,"","C",350,3500,"D",0,"","D",0,"","D",0,"","C",146,1460,null,1460,"OUARZAZATE"]
[null,"F36",null,null,null,5,"C",1850,9250,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",154,770,null,0,"ABEDERRAHIM"]
[null,"F37",null,null,null,30,"C",2800,84000,"D",0,"","D",0,"","C",1260,37800,"D",0,"","D",0,"","D",0,"","C",130,3900,null,3900,"OUARZAZATE"]
[null,"F38",null,null,null,8,"C",3400,27200,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",197,1576,null,0,"ABEDERRAHIM"]
[null,"F39",null,null,null,14,"C",4300,60200,"D",0,"","C",0,0,"C",350,4900,"D",0,"","D",150,"","C",214.5,3003,"C",205,2870,null,0,"MOHAMMED"]
[null,"F40",null,null,null,6,"C",2570,15420,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",335,2010,null,0,"ABEDERRAHIM"]
[null,"F41",null,null,null,1,"C",5600,5600,"C",6000,6000,"C",2400,2400,"C",327.84,327.84,"C",2972,2972,"D",0,"","D",0,"","C",4836,4836,null,327.84,"ABEDERRAHIM"]
[null,"F42",null,null,null,2,"C",6580,13160,"C",11200,22400,"C",4950,9900,"C",1424.4,2848.8,"C",6024,12048,"D",0,"","D",0,"","C",9066,18132,null,2848.8,"ABEDERRAHIM"]
[null,"F43",null,null,null,4,"C",{"$f":"8500*6","v":51000},204000,"C",20400,81600,"C",10500,42000,"C",5906.4,23625.599999999999,"C",12404,49616,"D",0,"","D",0,"","C",18738,74952,null,23625.599999999999,"ABEDERRAHIM"]
[null,"F44",null,null,null,8,"C",{"$f":"8500*6","v":51000},408000,"C",28900,231200,"C",16650,133200,"C",17545.919999999998,140367.35999999999,"C",17621,140968,"D",0,"","D",0,"","C",26802,214416,null,133200,"MOHAMMED"]
[null,"F45",null,null,null,1,"C",{"$f":"8500*6","v":51000},51000,"C",52000,52000,"D ",0,"","C",3856.14,3856.14,"C",32402,32402,"D",0,"","D",0,"","C",47124,47124,null,3856.14,"ABEDERRAHIM"]
[null,"F46",null,null,null,4,"C",0,0,"C",920,3680,"C",350,1400,"C",67.84,271.36,"C",284.45,1137.8,"D ",0,"","D ",0,"","C",433,1732,null,0,"HICHAM"]
[null,"F47",null,null,null,6,"C",0,0,"C",2450,14700,"C",750,4500,"C",337.5,2025,"C",793,4758,"D",0,"","D",0,"","C",1377,8262,null,0,"HICHAM"]
[null,"F48",null,null,null,8,"C",0,0,"C",4200,33600,"C",1600,12800,"C",904.32,7234.56,"C",1449,11592,"D",0,"","D",0,"","C",2242,17936,null,0,"HICHAM"]
[null,"F49",null,null,null,4,"C",0,0,"C",3800,15200,"C",1208,4832,"C",452.16,1808.64,"C",2029,8116,"D",0,"","D",0,"","C",1731,6924,null,0,"HICHAM"]
[null,"F50",null,null,null,6,"C",0,0,"C",6600,39600,"C",1740,10440,"C",859.14,5154.84,"D",0,"","D",0,"","D",0,"","C",1731,10386,null,0,"HICHAM"]
[null,"F51",null,null,null,2,"C",0,0,"C",3400,6800,"C",1351,2702,"C",192.2,384.4,"D",0,"","D",0,"","D",0,"","C",1809,3618,null,0,"HICHAM"]
[null,"F52",null,null,null,8,"C",0,0,"D",0,"","C",745,5960,"C",362,2896,"C",482,3856,"D",0,"","D",0,"","C",1023,8184,null,0,"HICHAM"]
[null,"F53",null,null,null,8,"C",0,0,"D",0,"","C",792,6336,"C",467.2,3737.6,"D",0,"","D",0,"","D",0,"","C",1102,8816,null,0,"HICHAM"]
[null,"F54",null,null,null,2,"C",0,0,"D",0,"","C",1450,2900,"C",79.2,158.4,"C",409,818,"D",0,"","D",0,"","C",787,1574,null,0,"HICHAM"]
[null,"F55",null,null,null,2,"C",0,0,"D",0,"","C",488,976,"C",90.6,181.2,"C",479,958,"D",0,"","D",0,"","C",866,1732,null,0,"HICHAM"]
[null,"F56",null,null,null,12,"C",0,0,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",113,1356,null,0,"HICHAM;ABEDERRAHIM"]
[null,"F57",null,null,null,10,"C",0,0,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",119,1190,null,0,"HICHAM;ABEDERRAHIM"]
[null,"F58",null,null,null,10,"C",0,0,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",166,1660,null,0,"HICHAM;ABEDERRAHIM"]
[null,"F59",null,null,null,12,"C",0,0,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",215,2580,null,0,"HICHAM;ABEDERRAHIM"]
[null,"F60",null,null,null,5,"C",0,0,"D",0,"","D",0,"","C",0,0,"D",0,"","D",0,"","D",0,"","C",327,1635,null,0,"HICHAM;ABEDERRAHIM"]
[null,"F61",null,null,null,12,"C",0,0,"D",0,"","D",172,"","C",84,1008,"C",349,4188,"D",0,"","D",0,"","C",244,2928,null,0,"HICHAM"]
[null,"F62",null,null,null,10,"C",0,0,"D",0,"","C",320,3200,"C",400,4000,"C",746,7460,"D",0,"","D",0,"","C",453,4530,null,0,"HICHAM"]
[null,"F63",null,null,null,10,"C",0,0,"D",0,"","N.C, épaisseur 5 mm AU LIEU DE 6,05 MM ",540,"","C",791.3,7913,"C",1078,10780,"D",0,"","D",0,"","C",1023,10230,null,0,"HICHAM"]
[null,"F64",null,null,null,12,"C",0,0,"D",0,"","N.C, collet épisseur de 5 MM au lieu de 6,2 MM",650,"","C",723.48,8681.76,"C",1327,15924,"D",0,"","D",0,"","C",1337,16044,null,0,"HICHAM"]
[null,"F65",null,null,null,5,"C",0,0,"D",0,"","N.C, collet épisseur de 5 MM au lieu de 7,11 MM",1400,"","C",565.20000000000005,2826,"C",2173,10865,"D",0,"","D",0,"","C",2399,11995,null,0,"HICHAM"]
[null,"F66",null,null,null,36,"C",138,{"$f":"IF(G74=\"c\",F74*H74,\"\")","v":4968},"D",0,{"$f":"IF(J74=\"c\",F74*K74,\"\")","v":""},"C",91,{"$f":"IF(M74=\"c\",F74*N74,\"\")","v":3276},"C",219.6,{"$f":"IF(P74=\"c\",F74*Q74,\"\")","v":7905.5999999999995},"D",0,{"$f":"IF(S74=\"c\",F74*T74,\"\")","v":""},"D",0,{"$f":"IF(V74=\"c\",F74*W74,\"\")","v":""},"D",0,{"$f":"IF(Y74=\"c\",F74*Z74,\"\")","v":""},"C",187,{"$f":"IF(AB74=\"c\",F74*AC74,\"\")","v":6732},null,{"$f":"MIN(I74,L74,O74,R74,U74,X74,AA74,AD74)","v":3276},"MOHAMMED"]
[null,"F67",null,null,null,24,"C",224.25,{"$f":"IF(G75=\"c\",F75*H75,\"\")","v":5382},"D",0,{"$f":"IF(J75=\"c\",F75*K75,\"\")","v":""},"C",103,{"$f":"IF(M75=\"c\",F75*N75,\"\")","v":2472},"C",225.6,{"$f":"IF(P75=\"c\",F75*Q75,\"\")","v":5414.4},"D",0,{"$f":"IF(S75=\"c\",F75*T75,\"\")","v":""},"D",0,{"$f":"IF(V75=\"c\",F75*W75,\"\")","v":""},"D",0,{"$f":"IF(Y75=\"c\",F75*Z75,\"\")","v":""},"C",248,{"$f":"IF(AB75=\"c\",F75*AC75,\"\")","v":5952},null,{"$f":"MIN(I75,L75,O75,R75,U75,X75,AA75,AD75)","v":2472},"MOHAMMED"]
[null,"F68",null,null,null,24,"C",290.5,{"$f":"IF(G76=\"c\",F76*H76,\"\")","v":6972},"D",0,{"$f":"IF(J76=\"c\",F76*K76,\"\")","v":""},"C",141,{"$f":"IF(M76=\"c\",F76*N76,\"\")","v":3384},"C",264,{"$f":"IF(P76=\"c\",F76*Q76,\"\")","v":6336},"D",0,{"$f":"IF(S76=\"c\",F76*T76,\"\")","v":""},"D",0,{"$f":"IF(V76=\"c\",F76*W76,\"\")","v":""},"D",0,{"$f":"IF(Y76=\"c\",F76*Z76,\"\")","v":""},"C",366,{"$f":"IF(AB76=\"c\",F76*AC76,\"\")","v":8784},null,{"$f":"MIN(I76,L76,O76,R76,U76,X76,AA76,AD76)","v":3384},"MOHAMMED"]
[null,"F69",null,null,null,12,"C",11200,{"$f":"IF(G77=\"c\",F77*H77,\"\")","v":134400},"D",0,{"$f":"IF(J77=\"c\",F77*K77,\"\")","v":""},"C",25,{"$f":"IF(M77=\"c\",F77*N77,\"\")","v":300},"C",46.2,{"$f":"IF(P77=\"c\",F77*Q77,\"\")","v":554.40000000000009},"D",0,{"$f":"IF(S77=\"c\",F77*T77,\"\")","v":""},"C ",38,{"$f":"IF(V77=\"c\",F77*W77,\"\")","v":""},"D",0,{"$f":"IF(Y77=\"c\",F77*Z77,\"\")","v":""},"C",187,{"$f":"IF(AB77=\"c\",F77*AC77,\"\")","v":2244},null,{"$f":"MIN(I77,L77,O77,R77,U77,X77,AA77,AD77)","v":300},"MOHAMMED"]
[null,"F70",null,null,null,20,"C",3500,{"$f":"IF(G78=\"c\",F78*H78,\"\")","v":70000},"D",0,{"$f":"IF(J78=\"c\",F78*K78,\"\")","v":""},"C",1635,{"$f":"IF(M78=\"c\",F78*N78,\"\")","v":32700},"C",249,{"$f":"IF(P78=\"c\",F78*Q78,\"\")","v":4980},"D ",0,{"$f":"IF(S78=\"c\",F78*T78,\"\")","v":""},"D",0,{"$f":"IF(V78=\"c\",F78*W78,\"\")","v":""},"D",0,{"$f":"IF(Y78=\"c\",F78*Z78,\"\")","v":""},"D",0,{"$f":"IF(AB78=\"c\",F78*AC78,\"\")","v":""},null,{"$f":"MIN(I78,L78,O78,R78,U78,X78,AA78,AD78)","v":4980},"ABEDERRAHIM"]
[]
[null,null,null,"Montant","Nbre"]
[null,null,null,{"$f":"+I20","v":780},1]
[null,null,null,{"$f":"O19+O22+O23+O24+O25+O29+O30+O49+O50+O70+O75+O77+O78+O61+O59+O55+O28+O27+O17+O12+O74+O57+O51+O52","v":281044},25]
[null,null,null,{"$f":"U73+U72+U63+U62+U60+U56+U54+U21+U10+U53","v":88992.8},10]
[null,null,null,{"$f":"X14+X26+X33+X34+X36","v":{"$error":"#VALUE!"}},5]
[null,null,null,{"$f":"AA38+AA35","v":782.20999999999992},2]
[null,null,null,{"$f":"AD68+AD67+AD66+AD65+AD64+AD48+AD47+AD46+AD45+AD44+AD43+AD42+AD41+AD40+AD39+AD37+AD32+AD31+AD15+AD13+AD69+AD71+AD58+AD16+AD9","v":84100},25]
[null,null,null,{"$f":"L11+L18","v":2232},2]
[null,null,null,{"$f":"SUM(D81:D86)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E81:E87)","v":70}]