{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Saisie","Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"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":"Saisie","index":0,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"SAISIE",null,null,null,null,null,null,"Fiche 104 (Lignes 5 à 9) à transférer dans feuille \"Report\" à la suite des transferts déjà faits"]
[null,null,null,null,null,null,null,null,null,"(Faut-il un bouton de transfert ?)"]
[]
["N° Ordre","Réf. Mois","Date","N°  Fiche","N° Fiche","Client","Réf. Art.","N° Art.","Code Article","Désignation Article","Unité","Quantité","Prix Unité HT","Montant HT Brut","Indice","Remise %","Remise Montant","Montant HT Net","Taux TVA","Montant TVA ","Montant TTC"]
["C","03","2017-03-02",null,104,"COMPTOIR",null,null,1,{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I5,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I5,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I5,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I5,[1]ART!$B:$B,0)))","v":""},null,null,{"$f":"SUMIF(A:A,O:O,N:N)","v":1380},{"$f":"O6","v":1},null,null,{"$f":"N5-Q5","v":1380},{"$f":"S6","v":0.19},{"$f":"R5*S5","v":262.2},{"$f":"R5+T5","v":1642.2}]
[1,{"$f":"IF(C6<>\"\",\"\",IF(B5=\"\",B5,B5))","v":"03"},null,{"$f":"IF(E6<>\"\",\"\",IF(D5=\"\",E5,D5))","v":104},null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I6,[1]ART!$B:$B,0)))","v":0},"1","PP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I6,[1]ART!$B:$B,0)))","v":"Traçage Noir & Blanc / Papier "},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I6,[1]ART!$B:$B,0)))","v":"ML"},3,160,{"$f":"L6*M6","v":480},{"$f":"Saisie[[#This Row],[N° Ordre]]","v":1},{"$f":"IF(E6<>\"\",\"\",IF(P5=\"\",P5,P5))","v":0},null,{"$f":"IF($N6=\"\",\"\",$N6-$Q6)","v":480},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I6,[1]ART!$B:$B,0)))","v":0.19},{"$f":"IFERROR(R6*S6,\"\")","v":91.2},{"$f":"IFERROR(R6+T6,\"\")","v":571.20000000000005}]
[{"$f":"A6","v":1},"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I7,[1]ART!$B:$B,0)))","v":0},"2","C3",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I7,[1]ART!$B:$B,0)))","v":"Copie Noir & Blanc A3-R /  Papier "},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I7,[1]ART!$B:$B,0)))","v":"U"},20,10,200,{"$f":"Saisie[[#This Row],[N° Ordre]]","v":1},0,null,{"$f":"IF($N7=\"\",\"\",$N7-$Q7)","v":200},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I7,[1]ART!$B:$B,0)))","v":0.19},38,238]
[{"$f":"A7","v":1},"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I8,[1]ART!$B:$B,0)))","v":0},"3","I4",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I8,[1]ART!$B:$B,0)))","v":"Impression Noir & Blanc A4-R /  Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I8,[1]ART!$B:$B,0)))","v":"U"},5,20,100,{"$f":"Saisie[[#This Row],[N° Ordre]]","v":1},0,null,100,{"$f":"S5","v":0.19},19,119]
[{"$f":"A8","v":1},"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I9,[1]ART!$B:$B,0)))","v":0},"4","NP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I9,[1]ART!$B:$B,0)))","v":"Numérisation Noir & Blanc de plan ou carte"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I9,[1]ART!$B:$B,0)))","v":"ML"},2,300,600,{"$f":"Saisie[[#This Row],[N° Ordre]]","v":1},0,null,600,{"$f":"S6","v":0.19},114,714]
[1,{"$f":"IF(C10<>\"\",\"\",IF(B9=\"\",B9,B9))","v":"03"},null,{"$f":"IF(E10<>\"\",\"\",IF(D9=\"\",E9,D9))","v":104},null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I10,[1]ART!$B:$B,0)))","v":""},"5",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F10,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F10,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I10,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I10,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I10,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A10,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I10,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A10,$A:$A,0)-2,8,1,1),FALSE)))","v":""},{"$f":"IFERROR(L10*M10,\"\")","v":""},{"$f":"A10","v":1},null,{"$f":"IFERROR(N10*P10,\"\")","v":""},"",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I10,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I11,[1]ART!$B:$B,0)))","v":""},"6",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F11,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F11,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I11,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I11,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I11,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A11,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I11,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A11,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I11,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I12,[1]ART!$B:$B,0)))","v":""},"7",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F12,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F12,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I12,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I12,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I12,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A12,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I12,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A12,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I12,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I13,[1]ART!$B:$B,0)))","v":""},"8",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F13,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F13,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I13,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I13,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I13,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A13,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I13,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A13,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I13,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I14,[1]ART!$B:$B,0)))","v":""},"9",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F14,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F14,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I14,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I14,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I14,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A14,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I14,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A14,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I14,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I15,[1]ART!$B:$B,0)))","v":""},"10",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F15,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F15,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I15,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I15,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I15,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A15,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I15,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A15,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I15,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I16,[1]ART!$B:$B,0)))","v":""},"11",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F16,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F16,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I16,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I16,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I16,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A16,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I16,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A16,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I16,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I17,[1]ART!$B:$B,0)))","v":""},"12",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F17,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F17,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I17,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I17,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I17,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A17,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I17,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A17,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I17,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I18,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I18,[1]ART!$B:$B,0)))","v":""},"13",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F18,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F18,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I18,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I18,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I18,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I18,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I18,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A18,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I18,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A18,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I18,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I18,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I19,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I19,[1]ART!$B:$B,0)))","v":""},"14",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F19,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F19,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I19,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I19,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I19,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I19,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I19,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A19,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I19,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A19,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I19,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I19,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I20,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I20,[1]ART!$B:$B,0)))","v":""},"15",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F20,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F20,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I20,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I20,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I20,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I20,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I20,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A20,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I20,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A20,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I20,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I20,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I21,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I21,[1]ART!$B:$B,0)))","v":""},"16",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F21,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F21,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I21,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I21,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I21,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I21,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I21,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A21,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I21,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A21,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I21,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I21,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I22,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I22,[1]ART!$B:$B,0)))","v":""},"17",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F22,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F22,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I22,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I22,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I22,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I22,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I22,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A22,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I22,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A22,$A:$A,0)-2,8,1,1),FALSE)))","v":""},{"$f":"IFERROR(L22*M22,\"\")","v":""},{"$f":"A22","v":1},null,{"$f":"IFERROR(N22*P22,\"\")","v":""},"",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I22,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I22,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I23,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I23,[1]ART!$B:$B,0)))","v":""},"18",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F23,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F23,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I23,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I23,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I23,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I23,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I23,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A23,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I23,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A23,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I23,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I23,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I24,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I24,[1]ART!$B:$B,0)))","v":""},"19",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F24,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F24,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I24,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I24,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I24,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I24,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I24,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A24,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I24,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A24,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I24,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I24,[1]ART!$B:$B,0)))","v":""}]
[1,"03",null,104,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I25,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I25,[1]ART!$B:$B,0)))","v":""},"20",{"$f":"IF(ISNA(INDEX([1]ART!$B:$B,MATCH(F25,[1]ART!$M:$M,0))),\"\",INDEX([1]ART!$B:$B,MATCH(F25,[1]ART!$M:$M,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I25,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I25,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I25,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I25,[1]ART!$B:$B,0)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($I25,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A25,$A:$A,0)-2,8,1,1),FALSE)),\"\",(VLOOKUP($I25,[1]ART!$B:$G,3+OFFSET($A:$A,MATCH($A25,$A:$A,0)-2,8,1,1),FALSE)))","v":""},"",1,null,"","",{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I25,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I25,[1]ART!$B:$B,0)))","v":""}]

{"sheet":"Report","index":1,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"REPORT",null,null,null,null,null,"  COMPTOIR SAISIE"]
[]
[]
["N° Ordre","Réf. Mois","Date","N°  Fiche","N° Fiche","Client","Réf. Art.","N° Art.","Code Article","Désignation Article","Unité","Quantité","Prix Unité HT","Montant HT  Brut","Indice","Remise %","Remise Montant","Montant HT Net","Taux TVA","Montant TVA ","Montant TTC"]
["C","03","2017-03-02",null,101,"COMPTOIR",null,null,1,{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I5,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I5,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I5,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I5,[1]ART!$B:$B,0)))","v":""},null,null,{"$f":"SUMIF(A:A,O:O,N:N)","v":3820},{"$f":"O6","v":1},null,null,{"$f":"N5-Q5","v":2440},{"$f":"S6","v":0.19},{"$f":"R5*S5","v":463.6},{"$f":"R5+T5","v":2903.6}]
[1,{"$f":"IF(C6<>\"\",\"\",IF(B5=\"\",B5,B5))","v":"03"},null,{"$f":"IF(E6<>\"\",\"\",IF(D5=\"\",E5,D5))","v":101},null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I6,[1]ART!$B:$B,0)))","v":0},"1","C3",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I6,[1]ART!$B:$B,0)))","v":"Copie Noir & Blanc A3-R /  Papier "},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I6,[1]ART!$B:$B,0)))","v":"U"},3,10,{"$f":"L6*M6","v":30},{"$f":"CTS[[#This Row],[N° Ordre]]","v":1},{"$f":"Saisie[[#This Row],[Remise Montant]]/Saisie[[#This Row],[Montant HT Brut]]","v":0},null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":30},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I6,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I6,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":5.7},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":35.700000000000003}]
[{"$f":"A6","v":1},"03",null,101,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I7,[1]ART!$B:$B,0)))","v":0},"2","TP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I7,[1]ART!$B:$B,0)))","v":"Tirage Noir & Blanc / Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I7,[1]ART!$B:$B,0)))","v":"ML"},20,80,1600,{"$f":"CTS[[#This Row],[N° Ordre]]","v":1},{"$f":"IF(E7<>\"\",\"\",IF(P6=\"\",P6,P6))","v":0},null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":1600},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I7,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I7,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":304},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":1904}]
[{"$f":"A7","v":1},"03",null,101,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I8,[1]ART!$B:$B,0)))","v":0},"3","PP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I8,[1]ART!$B:$B,0)))","v":"Traçage Noir & Blanc / Papier "},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I8,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I8,[1]ART!$B:$B,0)))","v":"ML"},5,160,800,{"$f":"CTS[[#This Row],[N° Ordre]]","v":1},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":800},{"$f":"S5","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":152},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":952}]
[{"$f":"A8","v":1},"03",null,101,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I9,[1]ART!$B:$B,0)))","v":0},"4","C4",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I9,[1]ART!$B:$B,0)))","v":"Copie Noir & Blanc A4-R /  Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I9,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I9,[1]ART!$B:$B,0)))","v":"U"},2,5,10,{"$f":"CTS[[#This Row],[N° Ordre]]","v":1},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":10},{"$f":"S6","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":1.9},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":11.9}]
["C","03","2017-03-02",null,{"$f":"LOOKUP(9^9,E4:E9)+1","v":102},"COMPTOIR",null,null,1,{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I10,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I10,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I10,[1]ART!$B:$B,0)))","v":""},null,null,{"$f":"SUMIF(A:A,O:O,N:N)","v":5250},{"$f":"O11","v":2},null,null,{"$f":"N10-Q10","v":5250},{"$f":"S11","v":0.19},{"$f":"R10*S10","v":997.5},{"$f":"R10+T10","v":6247.5}]
[{"$f":"LOOKUP(9^9,A5:A10)+1","v":2},"03",null,102,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I11,[1]ART!$B:$B,0)))","v":0},"6","1-P4XB",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I11,[1]ART!$B:$B,0)))","v":"Papier A4 / 080 gr / 500 f. extra blanc Xeropap Bleu"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I11,[1]ART!$B:$B,0)))","v":"U"},6,400,2400,{"$f":"CTS[[#This Row],[N° Ordre]]","v":2},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":2400},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I11,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I11,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":456},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":2856}]
[2,"03",null,102,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I12,[1]ART!$B:$B,0)))","v":0},"7","C8",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I12,[1]ART!$B:$B,0)))","v":"Copie Noir & Blanc A4-RV /  Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I12,[1]ART!$B:$B,0)))","v":"U"},15,10,{"$f":"L12*M12","v":150},{"$f":"CTS[[#This Row],[N° Ordre]]","v":2},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":150},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I12,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I12,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":28.5},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":178.5}]
[2,"03",null,102,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I13,[1]ART!$B:$B,0)))","v":0},"8","TP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I13,[1]ART!$B:$B,0)))","v":"Tirage Noir & Blanc / Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I13,[1]ART!$B:$B,0)))","v":"ML"},6,80,{"$f":"IFERROR(L13*M13,\"\")","v":480},{"$f":"CTS[[#This Row],[N° Ordre]]","v":2},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":480},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I13,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I13,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":91.2},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":571.20000000000005}]
[2,"03",null,102,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I14,[1]ART!$B:$B,0)))","v":0},"9","PP",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I14,[1]ART!$B:$B,0)))","v":"Traçage Noir & Blanc / Papier "},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I14,[1]ART!$B:$B,0)))","v":"ML"},12,160,{"$f":"IFERROR(L14*M14,\"\")","v":1920},{"$f":"CTS[[#This Row],[N° Ordre]]","v":2},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":1920},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I14,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I14,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":364.8},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":2284.8000000000002}]
[2,"03",null,102,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I15,[1]ART!$B:$B,0)))","v":0},"10","N3",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I15,[1]ART!$B:$B,0)))","v":"Numérisation Noir & Blanc A3 à plat"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I15,[1]ART!$B:$B,0)))","v":"U"},5,60,{"$f":"IFERROR(L15*M15,\"\")","v":300},{"$f":"CTS[[#This Row],[N° Ordre]]","v":2},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":300},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I15,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I15,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":57},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":357}]
["C","03","2017-03-02",null,{"$f":"LOOKUP(9^9,E10:E15)+1","v":103},"COMPTOIR",null,null,1,{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I16,[1]ART!$B:$B,0)))","v":""},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I16,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I16,[1]ART!$B:$B,0)))","v":""},null,null,{"$f":"SUMIF(A:A,O:O,N:N)","v":250},{"$f":"O17","v":3},null,null,{"$f":"N16-Q16","v":250},{"$f":"S17","v":0.19},{"$f":"R16*S16","v":47.5},{"$f":"R16+T16","v":297.5}]
[{"$f":"LOOKUP(9^9,A11:A16)+1","v":3},"03",null,103,null,null,{"$f":"IF(ISNA(INDEX([1]ART!$M:$M,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$M:$M,MATCH(I17,[1]ART!$B:$B,0)))","v":0},"12","C4",{"$f":"IF(ISNA(INDEX([1]ART!$C:$C,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$C:$C,MATCH(I17,[1]ART!$B:$B,0)))","v":"Copie Noir & Blanc A4-R /  Papier"},{"$f":"IF(ISNA(INDEX([1]ART!$D:$D,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$D:$D,MATCH(I17,[1]ART!$B:$B,0)))","v":"U"},50,5,{"$f":"IFERROR(L17*M17,\"\")","v":250},{"$f":"CTS[[#This Row],[N° Ordre]]","v":3},0,null,{"$f":"CTS[[#This Row],[Montant HT  Brut]]-CTS[[#This Row],[Remise Montant]]","v":250},{"$f":"IF(ISNA(INDEX([1]ART!$H:$H,MATCH(I17,[1]ART!$B:$B,0))),\"\",INDEX([1]ART!$H:$H,MATCH(I17,[1]ART!$B:$B,0)))","v":0.19},{"$f":"CTS[[#This Row],[Montant HT Net]]*CTS[[#This Row],[Taux TVA]]","v":47.5},{"$f":"CTS[[#This Row],[Montant HT Net]]+CTS[[#This Row],[Montant TVA ]]","v":297.5}]