{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAI","REP"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":1,"comments":1,"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":"SAI","index":0,"n_rows":20,"n_cols":26,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,14,9,15],[0,1,0,3],[1,1,1,3],[9,6,9,8],[9,10,9,11],[9,12,9,13]]}
[null,"SAISIE",null,null,null,null,null,"Saisir : Date, Client, Code Article, Quantité et Etat; puis VALIDER"]
[]
[]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(L4*N4,\"\")","v":0}]
[]
[]
["Etat","Date","Fiche","N° Fiche","CLIENT","Réf.","N°","Code","Désignation Article","Unité","Quantité","P.U. HT","Mt HT Brut","% Remise","Mt Remise","Mt HT Net","%TVA","Mt TVA ","Mt TTC","Arrondi","Mt Payé","P.U. TTC","Observation","Jour","Mois ","Ordre"]
["Payé","2021-03-27",{"$f":"D8","v":"03-326"},{"$f":"LEFT(LOOKUP(\"9\",[1]CTS!E$35:E$100002),2)&TEXT(VALUE(RIGHT(LOOKUP(\"9\",[1]CTS!E$35:E$100002),3))+1,\"-000\")","v":"03-326"},"CLIENT",{"$f":"IF(ISNA(INDEX(#REF!,MATCH(H9,#REF!,0))),\"\",INDEX(#REF!,MATCH(H9,#REF!,0)))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K9*L9,\"\")","v":0},{"$f":"O9/M9","v":{"$error":"#DIV/0!"}},0,{"$f":"IFERROR(M9-O9,\"\")","v":0},0.19,{"$f":"IFERROR(P9*Q9,\"\")","v":0},{"$f":"IFERROR(P9+R9,\"\")","v":0},null,{"$f":"IFERROR(S9-T9,\"\")","v":0},{"$f":"U9/K9","v":{"$error":"#DIV/0!"}},null,{"$f":"TEXT(B8,\"jj\")","v":"27"},{"$f":"TEXT(B8,\"mm\")","v":"03"},1]
[null,null,null,null,{"$f":"IFERROR(INDEX(#REF!,MATCH(E8,#REF!,0)),\"\")","v":""}]
[]
[{"$f":"A8","v":"Payé"},{"$f":"B8","v":"2021-03-27"},null,{"$f":"D8","v":"03-326"},{"$f":"CLIENT","v":"CLIENT"},null,null,null,null,null,null,null,{"$f":"SUM(M13:M9995)","v":0},{"$f":"SUM(N13:N9995)","v":0},{"$f":"SUM(O13:O9995)","v":0},{"$f":"SUM(P13:P9995)","v":0},null,{"$f":"SUM(R13:R9995)","v":0},{"$f":"SUM(S13:S9995)","v":0},{"$f":"SUM(T13:T9995)","v":0},{"$f":"SUM(U13:U9995)","v":0},null,null,{"$f":"TEXT([2]!SAI_32[[#This Row],[Colonne2]],\"jj\")","v":"27"},{"$f":"TEXT(B8,\"mm\")","v":"03"}]
[null,null,{"$f":"D12","v":"03-326"}]
[null,null,{"$f":"C13","v":"03-326"}]
[null,null,{"$f":"C14","v":"03-326"}]
[null,null,"03-326"]
[null,null,"03-326"]
[null,null,"03-326"]
[null,null,"03-326"]
[null,null,"03-326"]

{"sheet":"REP","index":1,"n_rows":7,"n_cols":26,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Etat","Date","Fiche","N° Fiche","CLIENT","Réf.","N°","Code","Désignation Article","Unité","Quantité","P.U. HT","Mt HT Brut","% Remise","Mt Remise","Mt HT Net","%TVA","Mt TVA ","Mt TTC","Arrondi","Mt Payé","P.U. TTC","Observation","Jour","Mois ","Ordre"]
[null,null,null,null,null,null,null,null,null,null,null,null,15.9,{"$error":"#DIV/0!"},0,15.9,null,3.0209999999999999,18.920999999999999,0,18.920999999999999,null,null,27]
[null,null,null,null,null,null,1,"1-essai","essai",3,12.5,null,0,{"$error":"#DIV/0!"},0,0,0.19,0,0,null,0,0,null,27]
[null,null,null,null,null,null,2,"2-essai","essai2","U",2,7.95,15.9,0,0,15.9,0.19,3.0209999999999999,18.920999999999999,null,18.920999999999999,9.4604999999999997,null,27]