{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Commande","Articles","Reçu","Caisse"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Commande","index":0,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,6,17,7],[18,6,20,7],[3,6,6,7],[0,9,1,11],[12,10,14,11],[1,6,2,7],[10,6,11,7],[12,6,14,7],[3,9,5,11],[15,6,15,7]]}
["Référence","Famille","Désignation","Qté","Prix","Stock",{"$f":"IF(Caisse!M3>2000,\"Versement Banque à prévoir!\",\"\")","v":""},null,null,{"$f":"TODAY()","v":"2014-05-11"},null,null,null,null,null,2014,"Moyen de paiement"]
[null,{"$f":"IF($A2=\"\",\"\",VLOOKUP($A2,base,2,FALSE))","v":""},{"$f":"IF($A2=\"\",\"\",VLOOKUP($A2,base,3,FALSE))","v":""},null,{"$f":"IF($A2=\"\",\"\",VLOOKUP($A2,base,5,FALSE)*D2)","v":""},{"$f":"IF($A2=\"\",\"\",VLOOKUP($A2,base,6,FALSE)-D2)","v":""},"Total Facture",null,null,null,null,null,null,null,null,null,"Espèces"]
[null,"","",null,{"$f":"IF($A3=\"\",\"\",VLOOKUP($A3,base,5,FALSE)*D3)","v":""},{"$f":"IF($A3=\"\",\"\",VLOOKUP($A3,base,6,FALSE)-D3)","v":""},null,null,null,null,null,null,null,null,null,null,"Chèques"]
[null,"","",null,{"$f":"IF($A4=\"\",\"\",VLOOKUP($A4,base,5,FALSE)*D4)","v":""},{"$f":"IF($A4=\"\",\"\",VLOOKUP($A4,base,6,FALSE)-D4)","v":""},{"$f":"IF(SUM(E2:E24)=0,\"\",SUM(E2:E24))","v":""},null,null,41770.790196759262,null,null,null,null,null,null,"Cartes"]
[null,"","",null,{"$f":"IF($A5=\"\",\"\",VLOOKUP($A5,base,5,FALSE)*D5)","v":""},{"$f":"IF($A5=\"\",\"\",VLOOKUP($A5,base,6,FALSE)-D5)","v":""}]
[null,"","",null,{"$f":"IF($A6=\"\",\"\",VLOOKUP($A6,base,5,FALSE)*D6)","v":""},{"$f":"IF($A6=\"\",\"\",VLOOKUP($A6,base,6,FALSE)-D6)","v":""}]
[null,"","",null,{"$f":"IF($A7=\"\",\"\",VLOOKUP($A7,base,5,FALSE)*D7)","v":""},{"$f":"IF($A7=\"\",\"\",VLOOKUP($A7,base,6,FALSE)-D7)","v":""}]
[null,"","",null,{"$f":"IF($A8=\"\",\"\",VLOOKUP($A8,base,5,FALSE)*D8)","v":""},{"$f":"IF($A8=\"\",\"\",VLOOKUP($A8,base,6,FALSE)-D8)","v":""}]
[null,"","",null,{"$f":"IF($A9=\"\",\"\",VLOOKUP($A9,base,5,FALSE)*D9)","v":""},{"$f":"IF($A9=\"\",\"\",VLOOKUP($A9,base,6,FALSE)-D9)","v":""}]
[null,"","",null,{"$f":"IF($A10=\"\",\"\",VLOOKUP($A10,base,5,FALSE)*D10)","v":""},{"$f":"IF($A10=\"\",\"\",VLOOKUP($A10,base,6,FALSE)-D10)","v":""}]
[null,"","",null,{"$f":"IF($A11=\"\",\"\",VLOOKUP($A11,base,5,FALSE)*D11)","v":""},{"$f":"IF($A11=\"\",\"\",VLOOKUP($A11,base,6,FALSE)-D11)","v":""},"Somme Reçue"]
[null,"","",null,{"$f":"IF($A12=\"\",\"\",VLOOKUP($A12,base,5,FALSE)*D12)","v":""},{"$f":"IF($A12=\"\",\"\",VLOOKUP($A12,base,6,FALSE)-D12)","v":""}]
[null,"","",null,{"$f":"IF($A13=\"\",\"\",VLOOKUP($A13,base,5,FALSE)*D13)","v":""},{"$f":"IF($A13=\"\",\"\",VLOOKUP($A13,base,6,FALSE)-D13)","v":""}]
[null,"","",null,{"$f":"IF($A14=\"\",\"\",VLOOKUP($A14,base,5,FALSE)*D14)","v":""},{"$f":"IF($A14=\"\",\"\",VLOOKUP($A14,base,6,FALSE)-D14)","v":""}]
[null,"","",null,{"$f":"IF($A15=\"\",\"\",VLOOKUP($A15,base,5,FALSE)*D15)","v":""},{"$f":"IF($A15=\"\",\"\",VLOOKUP($A15,base,6,FALSE)-D15)","v":""}]
[null,"","",null,{"$f":"IF($A16=\"\",\"\",VLOOKUP($A16,base,5,FALSE)*D16)","v":""},{"$f":"IF($A16=\"\",\"\",VLOOKUP($A16,base,6,FALSE)-D16)","v":""}]
[null,"","",null,{"$f":"IF($A17=\"\",\"\",VLOOKUP($A17,base,5,FALSE)*D17)","v":""},{"$f":"IF($A17=\"\",\"\",VLOOKUP($A17,base,6,FALSE)-D17)","v":""},"A rendre"]
[null,"","",null,{"$f":"IF($A18=\"\",\"\",VLOOKUP($A18,base,5,FALSE)*D18)","v":""},{"$f":"IF($A18=\"\",\"\",VLOOKUP($A18,base,6,FALSE)-D18)","v":""}]
[null,"","",null,{"$f":"IF($A19=\"\",\"\",VLOOKUP($A19,base,5,FALSE)*D19)","v":""},{"$f":"IF($A19=\"\",\"\",VLOOKUP($A19,base,6,FALSE)-D19)","v":""},{"$f":"IF(G13>0,G4-G13,\"\")","v":""}]
[null,"","",null,{"$f":"IF($A20=\"\",\"\",VLOOKUP($A20,base,5,FALSE)*D20)","v":""},{"$f":"IF($A20=\"\",\"\",VLOOKUP($A20,base,6,FALSE)-D20)","v":""},null,null,{"$f":"IF(G13=\"\",\"\",IF(G13<G4,\"Somme reçue insuffisante!!!\",\"\"))","v":""}]
[null,"","",null,{"$f":"IF($A21=\"\",\"\",VLOOKUP($A21,base,5,FALSE)*D21)","v":""},{"$f":"IF($A21=\"\",\"\",VLOOKUP($A21,base,6,FALSE)-D21)","v":""}]
[null,"","",null,{"$f":"IF($A22=\"\",\"\",VLOOKUP($A22,base,5,FALSE)*D22)","v":""},{"$f":"IF($A22=\"\",\"\",VLOOKUP($A22,base,6,FALSE)-D22)","v":""}]
[null,"","",null,{"$f":"IF($A23=\"\",\"\",VLOOKUP($A23,base,5,FALSE)*D23)","v":""},{"$f":"IF($A23=\"\",\"\",VLOOKUP($A23,base,6,FALSE)-D23)","v":""},"Amélioration  du fichier,"]
[null,null,null,null,null,null,"AJOUT d'un feuillet \"Caisse\" permettant d'attribuer un N° de Facture  et de sauvegarder les opérations comptables."]
[null,null,null,null,null,null,"En cliquant sur \"Fin de journée\" on autorise la fermeture de la caisse (après OK)."]
[null,null,null,null,null,null,"    -Total  recette de la journée en colonne G (dont Espèces col H, Chèques col I, Cartes col J)."]
[null,null,null,null,null,null,"    -Montant de la caisse en cellule M3 (somme recettes en espèces + caisse départ à initialiser en case M1)."]
[null,null,null,null,null,null,"PRIX unitaire sur le Reçu ainsi que le N° de facture sous la forme: N°/année-mois, ainsi que le moyen de paiement."]
[null,null,null,null,null,null,"Si Récup ancien Appareil, le valoriser lors de la facturation en encaissant seulement la différence. Notification de la ristourne sur le Reçu,"]
[null,null,null,null,null,null,"Moyen de paiement obligatoire en cellule G16 (bleue) du feuillet\"Commande\" par liste déroulante."]
[null,null,null,null,null,null,"Visualisation stocks en col F du feuillet \"Commande\" (si <10 se met en rouge) + gestion avec Bouton de commande MAJ."]
[null,null,null,null,null,null,"Si Montant Caisse >2000, message en cellule G1 \"Versement banque à prévoir\". Voir Bouton de commande \"Versement banque\"."]
[null,null,null,null,null,null,"Fin de mois. Copie de la caisse vers une nouvelle feuille Caisse_N°mois. Calcul recettes espèces, chèques, cartes. Voir Bouton de commande \"Changement de mois\"."]
[null,null,null,null,null,null,"Fin d'année. Sauvegarde de l'année écoulée et création d'un nouveau fichier pour la nouvelle année. Voir Bouton de commande\"Changement d'année\"."]

{"sheet":"Articles","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Référence","Famille","Désignation","Fournisseur","Tarif Unitaire","Stock","Stock_Dep","Sorties","Stock_New"]
["111B","Sellerie","Collier Nylon/Bleu/35-45","Dog'S Shop",2,"20",{"$f":"F2","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A2,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A2,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G2-H2","v":20}]
["111N","Sellerie","Collier Nylon/Noir/35-45","Dog's shop",0,"20",{"$f":"F3","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A3,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A3,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G3-H3","v":20},"Colonnes G, H et I masquées"]
["111R","Sellerie","Collier Nylon/Rouge/45-60","Dog's shop",0,"20",{"$f":"F4","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A4,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A4,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G4-H4","v":20},"Elles servent à recalculer le stock"]
["111V","Sellerie","Collier Nylon/Vert/45-60","Dog'S Shop",0,"20",{"$f":"F5","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A5,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A5,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G5-H5","v":20}]
["112B","Sellerie","Collier Cuir Strass/Bleu/35-45","Dog'S Shop",0,"20",{"$f":"F6","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A6,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A6,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G6-H6","v":20}]
["112N","Sellerie","Collier Cuir Strass/Noir/35-45","Dog'S Shop",0,"20",{"$f":"F7","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A7,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A7,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G7-H7","v":20}]
["112R","Sellerie","Collier Cuir Strass/Rouge/60-85","Dog'S Shop",0,"20",{"$f":"F8","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A8,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A8,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G8-H8","v":20}]
["211B","Coussinerie","Coussin Rectangle/Bleu/50-70","Pet Shop",0,"20",{"$f":"F9","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A9,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A9,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G9-H9","v":20}]
["211BL","Coussinerie","Coussin Rectangle/Blanc/50-70","Pet Shop",0,"20",{"$f":"F10","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A10,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A10,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G10-H10","v":20}]
["211N","Coussinerie","Coussin Rectangle/Noir/50-70","Pet Shop",0,"20",{"$f":"F11","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A11,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A11,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G11-H11","v":20}]
["211R","Coussinerie","Coussin Rectangle/Rouge/50-70","Pet Shop",0,"20",{"$f":"F12","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A12,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A12,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G12-H12","v":20}]
["221BL","Coussinerie","Coussin Rond/Blanc/60","Pet Shop",0,20,{"$f":"F13","v":20},{"$f":"IF(ISERROR(VLOOKUP(A13,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A13,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G13-H13","v":20}]
["221R","Coussinerie","Coussin Rond/Rouge/60","Pet Shop",0,20,{"$f":"F14","v":20},{"$f":"IF(ISERROR(VLOOKUP(A14,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A14,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G14-H14","v":20}]
["221V","Coussinerie","Coussin Rond/Vert/60","Pet Shop",0,20,{"$f":"F15","v":20},{"$f":"IF(ISERROR(VLOOKUP(A15,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A15,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G15-H15","v":20}]
["CRAP15","Alimentation","Croquette/Puppy/15Kg","Nutri Dog",0,"20",{"$f":"F16","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A16,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A16,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G16-H16","v":20}]
["CRAP3","Alimentation","Croquette/Puppy/3Kg","Nutri Dog",0,"20",{"$f":"F17","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A17,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A17,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G17-H17","v":20}]
["CRP15","Alimentation","Croquette/Adulte Poulet/15Kg","Nutri Dog",0,"20",{"$f":"F18","v":"20"},{"$f":"IF(ISERROR(VLOOKUP(A18,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A18,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G18-H18","v":20}]
["CRP3","Alimentation","Croquette/Adulte Poulet/3Kg","Nutri Dog",0,20,{"$f":"F19","v":20},{"$f":"IF(ISERROR(VLOOKUP(A19,Commande!$A$2:$D$24,4,FALSE)),0,VLOOKUP(A19,Commande!$A$2:$D$24,4,FALSE))","v":0},{"$f":"G19-H19","v":20}]

{"sheet":"Reçu","index":2,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,5],[26,0,26,4],[27,0,27,4],[28,0,28,4],[1,0,1,2],[1,3,1,5]]}
["FACTURE"]
[{"$f":"Commande!J1","v":"2014-05-11"},null,null,{"$f":"Commande!J4","v":41770.790196759262}]
["Réf.","Famille","Désignation","Qté","P. U.","Prix"]
[{"$f":"IF(Commande!A2<>\"\",Commande!A2,\"\")","v":""},{"$f":"IF(Commande!A2<>\"\",Commande!B2,\"\")","v":""},{"$f":"IF(Commande!A2<>\"\",Commande!C2,\"\")","v":""},{"$f":"IF(Commande!D2<>\"\",Commande!D2,\"\")","v":""},{"$f":"IF(A4=\"\",\"\",VLOOKUP(A4,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A2<>\"\",Commande!E2,\"\")","v":""}]
[{"$f":"IF(Commande!A3<>\"\",Commande!A3,\"\")","v":""},{"$f":"IF(Commande!A3<>\"\",Commande!B3,\"\")","v":""},{"$f":"IF(Commande!A3<>\"\",Commande!C3,\"\")","v":""},{"$f":"IF(Commande!D3<>\"\",Commande!D3,\"\")","v":""},{"$f":"IF(A5=\"\",\"\",VLOOKUP(A5,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A3<>\"\",Commande!E3,\"\")","v":""}]
[{"$f":"IF(Commande!A4<>\"\",Commande!A4,\"\")","v":""},{"$f":"IF(Commande!A4<>\"\",Commande!B4,\"\")","v":""},{"$f":"IF(Commande!A4<>\"\",Commande!C4,\"\")","v":""},{"$f":"IF(Commande!D4<>\"\",Commande!D4,\"\")","v":""},{"$f":"IF(A6=\"\",\"\",VLOOKUP(A6,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A4<>\"\",Commande!E4,\"\")","v":""}]
[{"$f":"IF(Commande!A5<>\"\",Commande!A5,\"\")","v":""},{"$f":"IF(Commande!A5<>\"\",Commande!B5,\"\")","v":""},{"$f":"IF(Commande!A5<>\"\",Commande!C5,\"\")","v":""},{"$f":"IF(Commande!D5<>\"\",Commande!D5,\"\")","v":""},{"$f":"IF(A7=\"\",\"\",VLOOKUP(A7,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A5<>\"\",Commande!E5,\"\")","v":""}]
[{"$f":"IF(Commande!A6<>\"\",Commande!A6,\"\")","v":""},{"$f":"IF(Commande!A6<>\"\",Commande!B6,\"\")","v":""},{"$f":"IF(Commande!A6<>\"\",Commande!C6,\"\")","v":""},{"$f":"IF(Commande!D6<>\"\",Commande!D6,\"\")","v":""},{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A6<>\"\",Commande!E6,\"\")","v":""}]
[{"$f":"IF(Commande!A7<>\"\",Commande!A7,\"\")","v":""},{"$f":"IF(Commande!A7<>\"\",Commande!B7,\"\")","v":""},{"$f":"IF(Commande!A7<>\"\",Commande!C7,\"\")","v":""},{"$f":"IF(Commande!D7<>\"\",Commande!D7,\"\")","v":""},{"$f":"IF(A9=\"\",\"\",VLOOKUP(A9,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A7<>\"\",Commande!E7,\"\")","v":""}]
[{"$f":"IF(Commande!A8<>\"\",Commande!A8,\"\")","v":""},{"$f":"IF(Commande!A8<>\"\",Commande!B8,\"\")","v":""},{"$f":"IF(Commande!A8<>\"\",Commande!C8,\"\")","v":""},{"$f":"IF(Commande!D8<>\"\",Commande!D8,\"\")","v":""},{"$f":"IF(A10=\"\",\"\",VLOOKUP(A10,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A8<>\"\",Commande!E8,\"\")","v":""}]
[{"$f":"IF(Commande!A9<>\"\",Commande!A9,\"\")","v":""},{"$f":"IF(Commande!A9<>\"\",Commande!B9,\"\")","v":""},{"$f":"IF(Commande!A9<>\"\",Commande!C9,\"\")","v":""},{"$f":"IF(Commande!D9<>\"\",Commande!D9,\"\")","v":""},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A9<>\"\",Commande!E9,\"\")","v":""}]
[{"$f":"IF(Commande!A10<>\"\",Commande!A10,\"\")","v":""},{"$f":"IF(Commande!A10<>\"\",Commande!B10,\"\")","v":""},{"$f":"IF(Commande!A10<>\"\",Commande!C10,\"\")","v":""},{"$f":"IF(Commande!D10<>\"\",Commande!D10,\"\")","v":""},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A10<>\"\",Commande!E10,\"\")","v":""}]
[{"$f":"IF(Commande!A11<>\"\",Commande!A11,\"\")","v":""},{"$f":"IF(Commande!A11<>\"\",Commande!B11,\"\")","v":""},{"$f":"IF(Commande!A11<>\"\",Commande!C11,\"\")","v":""},{"$f":"IF(Commande!D11<>\"\",Commande!D11,\"\")","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A11<>\"\",Commande!E11,\"\")","v":""}]
[{"$f":"IF(Commande!A12<>\"\",Commande!A12,\"\")","v":""},{"$f":"IF(Commande!A12<>\"\",Commande!B12,\"\")","v":""},{"$f":"IF(Commande!A12<>\"\",Commande!C12,\"\")","v":""},{"$f":"IF(Commande!D12<>\"\",Commande!D12,\"\")","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A12<>\"\",Commande!E12,\"\")","v":""}]
[{"$f":"IF(Commande!A13<>\"\",Commande!A13,\"\")","v":""},{"$f":"IF(Commande!A13<>\"\",Commande!B13,\"\")","v":""},{"$f":"IF(Commande!A13<>\"\",Commande!C13,\"\")","v":""},{"$f":"IF(Commande!D13<>\"\",Commande!D13,\"\")","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A13<>\"\",Commande!E13,\"\")","v":""}]
[{"$f":"IF(Commande!A14<>\"\",Commande!A14,\"\")","v":""},{"$f":"IF(Commande!A14<>\"\",Commande!B14,\"\")","v":""},{"$f":"IF(Commande!A14<>\"\",Commande!C14,\"\")","v":""},{"$f":"IF(Commande!D14<>\"\",Commande!D14,\"\")","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A14<>\"\",Commande!E14,\"\")","v":""}]
[{"$f":"IF(Commande!A15<>\"\",Commande!A15,\"\")","v":""},{"$f":"IF(Commande!A15<>\"\",Commande!B15,\"\")","v":""},{"$f":"IF(Commande!A15<>\"\",Commande!C15,\"\")","v":""},{"$f":"IF(Commande!D15<>\"\",Commande!D15,\"\")","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A15<>\"\",Commande!E15,\"\")","v":""}]
[{"$f":"IF(Commande!A16<>\"\",Commande!A16,\"\")","v":""},{"$f":"IF(Commande!A16<>\"\",Commande!B16,\"\")","v":""},{"$f":"IF(Commande!A16<>\"\",Commande!C16,\"\")","v":""},{"$f":"IF(Commande!D16<>\"\",Commande!D16,\"\")","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A16<>\"\",Commande!E16,\"\")","v":""}]
[{"$f":"IF(Commande!A17<>\"\",Commande!A17,\"\")","v":""},{"$f":"IF(Commande!A17<>\"\",Commande!B17,\"\")","v":""},{"$f":"IF(Commande!A17<>\"\",Commande!C17,\"\")","v":""},{"$f":"IF(Commande!D17<>\"\",Commande!D17,\"\")","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A17<>\"\",Commande!E17,\"\")","v":""}]
[{"$f":"IF(Commande!A18<>\"\",Commande!A18,\"\")","v":""},{"$f":"IF(Commande!A18<>\"\",Commande!B18,\"\")","v":""},{"$f":"IF(Commande!A18<>\"\",Commande!C18,\"\")","v":""},{"$f":"IF(Commande!D18<>\"\",Commande!D18,\"\")","v":""},{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A18<>\"\",Commande!E18,\"\")","v":""}]
[{"$f":"IF(Commande!A19<>\"\",Commande!A19,\"\")","v":""},{"$f":"IF(Commande!A19<>\"\",Commande!B19,\"\")","v":""},{"$f":"IF(Commande!A19<>\"\",Commande!C19,\"\")","v":""},{"$f":"IF(Commande!D19<>\"\",Commande!D19,\"\")","v":""},{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A19<>\"\",Commande!E19,\"\")","v":""}]
[{"$f":"IF(Commande!A20<>\"\",Commande!A20,\"\")","v":""},{"$f":"IF(Commande!A20<>\"\",Commande!B20,\"\")","v":""},{"$f":"IF(Commande!A20<>\"\",Commande!C20,\"\")","v":""},{"$f":"IF(Commande!D20<>\"\",Commande!D20,\"\")","v":""},{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A20<>\"\",Commande!E20,\"\")","v":""}]
[{"$f":"IF(Commande!A21<>\"\",Commande!A21,\"\")","v":""},{"$f":"IF(Commande!A21<>\"\",Commande!B21,\"\")","v":""},{"$f":"IF(Commande!A21<>\"\",Commande!C21,\"\")","v":""},{"$f":"IF(Commande!D21<>\"\",Commande!D21,\"\")","v":""},{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A21<>\"\",Commande!E21,\"\")","v":""}]
[{"$f":"IF(Commande!A22<>\"\",Commande!A22,\"\")","v":""},{"$f":"IF(Commande!A22<>\"\",Commande!B22,\"\")","v":""},{"$f":"IF(Commande!A22<>\"\",Commande!C22,\"\")","v":""},{"$f":"IF(Commande!D22<>\"\",Commande!D22,\"\")","v":""},{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A22<>\"\",Commande!E22,\"\")","v":""}]
[{"$f":"IF(Commande!A23<>\"\",Commande!A23,\"\")","v":""},{"$f":"IF(Commande!A23<>\"\",Commande!B23,\"\")","v":""},{"$f":"IF(Commande!A23<>\"\",Commande!C23,\"\")","v":""},{"$f":"IF(Commande!D23<>\"\",Commande!D23,\"\")","v":""},{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A23<>\"\",Commande!E23,\"\")","v":""}]
[null,{"$f":"IF(Commande!A24<>\"\",Commande!B24,\"\")","v":""},{"$f":"IF(Commande!A24<>\"\",Commande!C24,\"\")","v":""},{"$f":"IF(Commande!D24<>\"\",Commande!D24,\"\")","v":""},{"$f":"IF(A26=\"\",\"\",VLOOKUP(A26,Articles!$A$2:$F$30,5,FALSE))","v":""},{"$f":"IF(Commande!A24<>\"\",Commande!E24,\"\")","v":""}]
["Total Facture",null,null,null,null,{"$f":"Commande!G4","v":""}]
["Somme Reçue",null,null,null,null,{"$f":"Commande!G13","v":0}]
["Somme Rendue",null,null,null,null,{"$f":"IF(Commande!G19<0,Commande!G19,0)","v":0}]
["Paiement:",{"$f":"IF(Commande!G16=\"\",\"\",Commande!G16)","v":""},null,"TK N°:"]

{"sheet":"Caisse","index":3,"n_rows":3,"n_cols":22,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,11,4,11],[2,12,4,12]]}
["N° de TK","date","Heure","Total TK","Paiement",null,"Recettes :"," Espèces","Chèques","Cartes","Vrst Banque","Caisse Départ",1000,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2014-05-11"}]
[{"$f":"COUNT(A1,A65000)","v":0},null,null,null,null,"TOTAL JOURNEE"]
[null,null,null,null,null,null,null,null,null,null,null,"Montant Caisse",{"$f":"SUMIF($E$3:$E$65000,Commande!$Q$2,$D$3:$D$65000)+$M$1-SUM($K$3:$K$65000)","v":1000}]