{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SAI","REP"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"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":25,"n_cols":26,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,2,22,11],[22,14,22,21],[24,2,24,11],[24,14,24,21],[0,1,0,3],[1,1,1,3],[9,6,9,8],[9,10,9,11],[9,12,9,13],[9,14,9,15]]}
[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,1,"1-P0T","Papier A0 Tirage","U",3,12,{"$f":"IFERROR(K9*L9,\"\")","v":36},{"$f":"O9/M9","v":0},0,{"$f":"IFERROR(M9-O9,\"\")","v":36},0.19,{"$f":"IFERROR(P9*Q9,\"\")","v":6.84},{"$f":"IFERROR(P9+R9,\"\")","v":42.84},2.84,{"$f":"IFERROR(S9-T9,\"\")","v":40},{"$f":"U9/K9","v":13.333333333333334},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:M9997)","v":0},{"$f":"SUM(N13:N9997)","v":0},{"$f":"SUM(O13:O9997)","v":0},{"$f":"SUM(P13:P9997)","v":0},null,{"$f":"SUM(R13:R9997)","v":0},{"$f":"SUM(S13:S9997)","v":0},{"$f":"SUM(T13:T9997)","v":0},{"$f":"SUM(U13:U9997)","v":0},null,null,{"$f":"TEXT(SAI_32[[#This Row],[Colonne2]],\"jj\")","v":"27"},{"$f":"TEXT(B8,\"mm\")","v":"03"}]
[null,null,{"$f":"D12","v":"03-326"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X12","v":"27"},{"$f":"Y12","v":"03"},1]
[null,null,{"$f":"C13","v":"03-326"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X13","v":"27"},{"$f":"Y13","v":"03"},2]
[null,null,{"$f":"C14","v":"03-326"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X14","v":"27"},"03",3]
[null,null,"03-326",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","03",4]
[null,null,"03-326",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","03",5]
[null,null,"03-326",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","03",6]
[null,null,"03-326",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","03",7]
[null,null,"03-326",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27","03",8]
[]
[]
[null,null,"Avec le bouton vert OK, je cherche à déplacer la ligne 9 (de G9 à Z9) en ligne 13 (de G13 à Z13) tout en gardant les formules contenues dans G9:Z9 (elles n'apparaissent pas toutes dans ce tableau)",null,null,null,null,null,null,null,null,null,null,null,"Avec le bouton rouge VALIDER, je veux ensuite transférer tout le tableau (de A12 à Z999) dans la feuille REP, TableauREP, en effaçant les données contenues dans le tableau rose de SAI."]
[]
[null,null,"Ceci correspond au report du 1er produit saisi, ce qui va nous permettre de saisir le 2ème produit qui sera validé par OK et déplacé en ligne 14, puis le 3ème produit qui sera validé par OK et déplacé en ligne 15….ainsi de suite jusqu'au dernier produit.",null,null,null,null,null,null,null,null,null,null,null,"La 1ère facture est ainsi archivée, et je peux retourner à la feuille SAI pour saisir la 2ème facture et ainsi de suite."]

{"sheet":"REP","index":1,"n_rows":4,"n_cols":26,"rows_kept":4,"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"]