{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","Caisse","BilanCaisse","Stock","Journal","Configuration"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Accueil","index":0,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,19],[7,12,7,13]]}
[]
[]
[]
[]
[]
[]
["Gestion Caisse & Stock V.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"© Don Pépé 2017"]

{"sheet":"Caisse","index":1,"n_rows":19,"n_cols":19,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,12,18,17],[12,12,12,13],[13,12,13,13],[13,2,13,5],[7,7,7,10],[8,12,8,13],[9,12,9,13],[16,12,16,13],[17,12,17,17],[15,14,15,15],[16,14,16,15],[0,1,1,10],[2,12,2,17],[1,12,1,17],[3,16,3,17],[4,12,4,13],[5,12,5,13],[6,12,6,13],[7,12,7,13],[14,12,14,13],[15,12,15,13],[10,12,10,13],[11,12,11,13]]}
[null,"Caisse"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Produit de l'espagne\n3 rue des arbres tombés\n82000 Rodez\n0102030405"]
[null,"Produit","Quantité","Prix U TTC","Prix total","Sock initial","Stock restant",null,"Total ",null,"Réduction",null,"Ticket de caisse"]
[null,null,null,{"$f":"IF($B4=\"\",\"\",VLOOKUP($B4,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($D4=\"\",\"\",SUM($C4*$D4))","v":""},{"$f":"IF($B4=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B4))","v":""},{"$f":"IF($D4=\"\",\"\",SUM($F4-$C4))","v":""},null,{"$f":"SUM(E4:E13)-(K4/100)","v":0},null,0,null,"Ticket n°:",0,null,null,{"$f":"NOW()","v":"2017-06-23T11:47:48.410"}]
[null,null,null,{"$f":"IF($B5=\"\",\"\",VLOOKUP($B5,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($D5=\"\",\"\",SUM($C5*$D5))","v":""},{"$f":"IF($B5=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B5))","v":""},{"$f":"IF($D5=\"\",\"\",SUM($F5-$C5))","v":""},null,null,null,null,null,"Produit",null,"Quantité","Prix U HT","Prix U TTC","Total"]
[null,null,null,{"$f":"IF($B6=\"\",\"\",VLOOKUP($B6,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B6=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B6))","v":""},"",null,"Type de règlement",null,null,null,{"$f":"IF($B4=0,\"\",$B4)","v":""},null,{"$f":"IF($C4=0,\"\",$C4)","v":""},{"$f":"IF($B4=\"\",\"\",VLOOKUP($B4,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B4=\"\",\"\",VLOOKUP($B4,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($O6=\"\",\"\",SUM($O6*$Q6))","v":""}]
[null,null,null,{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B7=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B7))","v":""},"",null,null,null,null,null,"",null,"",{"$f":"IF($B5=\"\",\"\",VLOOKUP($B5,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B5=\"\",\"\",VLOOKUP($B5,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B8=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B8))","v":""},"",{"$f":"IF(I10=\"\",\"\",IF(I10<I4,\"Somme reçue insuffisante !!!\",\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF($B6=\"\",\"\",VLOOKUP($B6,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B6=\"\",\"\",VLOOKUP($B6,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},""]
[null,null,null,{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B9=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B9))","v":""},"",null,"Somme reçue",null,null,null,"",null,"",{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B7=\"\",\"\",VLOOKUP($B7,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($O6=\"\",\"\",SUM($O6*$P6))","v":""}]
[null,null,null,{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B10=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B10))","v":""},"",null,null,null,null,null,"",null,"",{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B8=\"\",\"\",VLOOKUP($B8,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,null,{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B11=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B11))","v":""},"",null,null,null,null,null,"",null,"",{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B9=\"\",\"\",VLOOKUP($B9,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,null,{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B12=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B12))","v":""},"",null,"Somme à rendre",null,null,null,"",null,"",{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B10=\"\",\"\",VLOOKUP($B10,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,null,{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,Tableau1[[Produits]:[Rupture]],MATCH($D$3,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",{"$f":"IF($B13=\"\",\"\",SUMIFS(Stock!$K$2:$K$64999,Stock!$A$2:$A$64999,$B13))","v":""},"",null,{"$f":"IF(I10=\"\",\"\",IF(I10>0,I10-I4,\"\"))","v":""},null,null,null,"",null,"",{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B11=\"\",\"\",VLOOKUP($B11,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,{"$f":"IF(BilanCaisse!O1>=Configuration!N2,\"Versement Banque à prévoir !! \"&BilanCaisse!O1&\" €\",\"\")","v":""},null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B12=\"\",\"\",VLOOKUP($B12,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,Tableau1[[Produits]:[Rupture]],MATCH($P$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},{"$f":"IF($B13=\"\",\"\",VLOOKUP($B13,Tableau1[[Produits]:[Rupture]],MATCH($Q$5,Tableau1[[#Headers],[Produits]:[Rupture]],0),FALSE))","v":""},"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,"Type de règlement",null,{"$f":"IF($K$4=0,\"\",\"Réduction\")","v":""},null,"Total HT",{"$f":"IF(SUM(S9:S18)=0,\"\",SUM(S9:S18))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$7=\"\",\"\",$I$7)","v":""},null,{"$f":"IF($K$4=0,\"\",$K$4)","v":""},null,"Total TTC",{"$f":"IF(SUM(R6:R15)=0,\"\",SUM(R6:R15))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,"Merci de vôtre visite, a bientôt.",null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"N° siret - "]

{"sheet":"BilanCaisse","index":2,"n_rows":1,"n_cols":15,"rows_kept":1,"cut":false,"hidden":false,"merged":[[2,12,2,13]]}
["N°","Date","Heure","Total Ticket","Règlement","TOTAL JOURNEE","Recette","Espèces","Chèques","Cartes","Sortie","Fond de caisse",200,"Montant caisse",{"$f":"SUM($D$2:$D$64999)","v":0}]

{"sheet":"Stock","index":3,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Produits","Prix A HT","MB %","Prix U HT","TVA","Prix U TTC","Stock I","Entrée","Sortie","Destockage","Stock F","V S I HT","V S I TTC","V S F HT","V S F TTC","Total V HT","Total V TTC","T D HT","T D TTC","Rupture"]
["Produit_1",0.4,50,{"$f":"SUM($B2+$C2/100)","v":0.9},10,{"$f":"SUM($D2+E2/100)","v":1},100,{"$f":"IF($A2=\"\",\"\",SUMIFS(Journal!D$2:D$65000,Journal!B$2:B$65000,$A2))","v":0},{"$f":"IF(A2=\"\",\"\",SUMIFS(Journal!C$2:C$65000,Journal!B$2:B$65000,A2))","v":0},{"$f":"IF(A2=\"\",\"\",SUMIFS(Journal!E$2:E$65000,Journal!B$2:B$65000,A2))","v":0},{"$f":"IF(A2=\"\",\"\",G2+H2-I2-J2)","v":100},{"$f":"IF(A2=\"\",\"\",D2*G2)","v":90},{"$f":"IF(A2=\"\",\"\",F2*G2)","v":100},{"$f":"IF(A2=\"\",\"\",D2*K2)","v":90},{"$f":"IF(A2=\"\",\"\",F2*K2)","v":100},{"$f":"SUM($D2*$I2)","v":0},{"$f":"SUM($F2*$I2)","v":0},{"$f":"SUM($D2*$J2)","v":0},{"$f":"SUM($F2*$J2)","v":0},{"$f":"IF($K2<=Configuration!$H$2,Tableau1[[#This Row],[Produits]]&\" - Arrive en rupture\",\"\")","v":""}]
["Produit_2",0.5,50,{"$f":"SUM($B3+$C3/100)","v":1},"5,5",{"$f":"SUM($D3+E3/100)","v":1.0549999999999999},100,{"$f":"IF($A3=\"\",\"\",SUMIFS(Journal!D$2:D$65000,Journal!B$2:B$65000,$A3))","v":0},{"$f":"IF(A3=\"\",\"\",SUMIFS(Journal!C$2:C$65000,Journal!B$2:B$65000,A3))","v":0},{"$f":"IF(A3=\"\",\"\",SUMIFS(Journal!E$2:E$65000,Journal!B$2:B$65000,A3))","v":0},{"$f":"IF(A3=\"\",\"\",G3+H3-I3-J3)","v":100},{"$f":"IF(A3=\"\",\"\",D3*G3)","v":100},{"$f":"IF(A3=\"\",\"\",F3*G3)","v":105.5},{"$f":"IF(A3=\"\",\"\",D3*K3)","v":100},{"$f":"IF(A3=\"\",\"\",F3*K3)","v":105.5},{"$f":"SUM($D3*$I3)","v":0},{"$f":"SUM($F3*$I3)","v":0},{"$f":"SUM($D3*$J3)","v":0},{"$f":"SUM($F3*$J3)","v":0},{"$f":"IF($K3<=Configuration!$H$2,Tableau1[[#This Row],[Produits]]&\" - Arrive en rupture\",\"\")","v":""}]

{"sheet":"Journal","index":4,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Date","Produit","Sortie","Entrée","Destockage","Description"]
["2017-06-23T11:39:10",null,null,null,null,"Fermeture de l'application"]
["2017-06-23T11:47:48",null,null,null,null,"Fermeture de l'application"]

{"sheet":"Configuration","index":5,"n_rows":17,"n_cols":24,"rows_kept":17,"cut":false,"hidden":true,"merged":[[7,3,7,4],[8,3,8,4],[5,12,5,15],[11,12,11,15],[6,12,6,15],[7,12,7,15],[8,12,8,15],[9,12,9,15],[10,12,10,15],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[5,7,5,8],[6,7,6,8],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[5,0,5,1],[6,0,6,1],[5,3,5,4],[6,3,6,4]]}
["Configuration",null,null,"Tva",null,"Marge brut",null,"Stock mini",null,"Mode de règlement",null,"Destockage",null,"Remise en banque",null,"Mot de passe administration",null,"Onglet afficher",null,"Onglet Mois",null,"Réduction",null,"Pdf"]
[0,null,"Alimentaire","5,5",null,50,null,10,null,"Espèces",null,"Offert",null,1000,null,"admin",null,true,null,true,null,0,null,false]
[null,null,"Boisson sans alcool",10,null,null,null,null,null,"Chèques",null,"Casse",null,null,null,null,null,null,null,null,null,5]
[null,null,"Boisson alcoolisée",20,null,null,null,null,null,"Cartes",null,null,null,null,null,null,null,null,null,null,null,10,null,"Impression"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,true]
["Configuration",null,"Titre","Description",null,"Général",null,"Afficher",null,null,null,null,"Société",null,null,null,null,null,null,null,null,null,null,2]
[1,null,3,1,null,24,null,true,null,null,null,"Nom","Produit de l'espagne"]
[null,null,true,false,null,10,null,null,null,null,null,"Adresse","3 rue des arbres tombés"]
[null,null,true,true,null,"Baskerville Old Face",null,null,null,null,null,"Cp",82000]
[null,null,null,null,null,true,null,null,null,null,null,"Ville","Rodez"]
["Info",null,null,null,null,false,null,null,null,null,null,"Téléphone",102030405]
[1,null,null,null,null,null,null,null,null,null,null,"Siret"]
[]
["Info"]
["Info Caisse\n\nSortie de caisse:\nPermet de sortir une somme de la caisse.\n\nFond de caisse:\nModifit la valeur du fond de caisse."]
["Info Stock\n\nGestion des articles:\nAjout, modification, suppression d'article\n\nStock article:\nPermet de rajouter du stock à un article.\n\nDestockage:\nPermet de mettre en casse ou en offert un article."]
["Info Raz\n\nRaz Journalier:\nPermet de fermer la caisse du jour.\nIl doit y avoir au moins une vente pour fermer la caisse du jour.\n\nRaz Mensuel :\nPermet de fermer la caisse du  mois. \nBilanCaisse ne doit pas être vide, il doit contenir au moins une ligne.\nCréer automatiquement un nouvelle onglet du mois fermer.\n\nRaz Annuel:\nPermet de fermer la caisse de l'année.\nCréer automatiquement un nouveau classeur pour la nouvelle année."]