{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Feuil1","29-01-2020","30-01-2020","31-01-2020","01-02-2020","Menu"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[13,0,16,0],[16,2,16,3],[16,6,16,7],[18,1,18,7],[0,0,1,7],[8,1,8,2],[8,5,8,6],[9,1,9,2],[9,5,9,6],[10,1,10,3],[10,5,10,7],[12,1,12,3],[12,5,12,7],[17,1,17,3],[17,5,17,7],[11,1,11,7]]}
[]
[]
["Caburants","Super 1","super 2 ","super3",null,"Gasoil 1","Gasoil 2","GASOIL 3"]
["index arrivée",25,45,60,null,14,12,58]
["index départ",15,32,45,null,11,10,20]
["sorties",{"$f":"B4-B5","v":10},{"$f":"C4-C5","v":13},15,null,{"$f":"F4-F5","v":3},{"$f":"G4-G5","v":2},{"$f":"H4-H5","v":38}]
["retour en cuve",0,0,0,null,0,0,0]
["vente par pome",{"$f":"B6-B7","v":10},{"$f":"C6-C7","v":13},{"$f":"D6-D7","v":15},null,{"$f":"F6-F7","v":3},{"$f":"G6-G7","v":2},{"$f":"H6-H7","v":38}]
["sorties par produit",{"$f":"B8+C8","v":23},null,{"$f":"D8+E8","v":15},null,{"$f":"F8+G8","v":5},null,{"$f":"H8","v":38}]
["Chiffres d'affaire par produit",{"$f":"B9*670","v":15410},null,{"$f":"D9*630","v":9450},null,{"$f":"F9*570","v":2850},null,{"$f":"H9*540","v":20520}]
["Chiffres d'affaire par carburant",{"$f":"B10+D10","v":24860},null,null,null,{"$f":"F10+H10","v":23370}]
["Recette Lubrifiant",{"$f":"Q15","v":0}]
["Recette Total",{"$f":"B11","v":24860},null,null,null,{"$f":"F11","v":23370}]
["Credit","SUPER",0,{"$f":"C14*670","v":0},null,"Gasoil ",20,{"$f":"G14*540","v":10800}]
[null,"SUPER",null,{"$f":"C15*670","v":0},null,"Gasoil ",0,{"$f":"G15*540","v":0}]
[null,"SUPER",null,{"$f":"C16*630","v":0},null,"Gasoil ",0,{"$f":"G16*570","v":0}]
[null,null,{"$f":"SUM(D14:D16)","v":0},null,null,null,{"$f":"SUM(H14:H16)","v":10800}]
[null,{"$f":"B13-C17","v":24860},null,null,null,{"$f":"F13-G17","v":12570}]
["Vente au comptant",{"$f":"B18+F18+B12","v":37430}]

{"sheet":"29-01-2020","index":1,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,1,10,3],[10,5,10,7],[0,3,2,19],[0,20,0,25],[1,20,1,25],[2,20,2,25],[3,4,10,4],[3,8,40,8],[3,13,19,15],[3,16,4,25],[5,16,6,18],[5,19,6,20],[5,21,6,22],[5,23,6,25],[7,16,8,18],[7,19,8,20],[7,21,8,22],[7,23,8,25],[9,16,10,18],[9,19,10,20],[9,21,10,22],[9,23,10,25],[11,0,11,7],[11,16,12,18],[11,19,12,20],[11,21,12,22],[11,23,12,25],[12,1,12,3],[12,4,18,4],[12,5,12,7],[13,1,13,3],[13,5,13,7],[13,16,14,18],[13,19,14,20],[13,21,14,22],[13,23,14,25],[14,1,14,3],[14,5,14,7],[15,1,15,3],[15,5,15,7],[15,16,16,18],[15,19,16,22],[15,23,16,25],[16,1,16,3],[16,5,16,7],[17,1,17,3],[17,5,17,7],[17,16,17,18],[17,19,17,22],[17,23,17,25],[18,1,18,3],[18,5,18,7],[18,9,19,12],[18,16,18,18],[18,19,18,22],[18,23,18,25],[19,0,19,7],[19,16,19,18],[19,19,19,22],[19,23,19,25],[20,9,20,10],[20,11,40,11],[20,12,20,14],[20,15,40,15],[20,16,20,18],[21,16,21,18],[21,19,21,22],[21,23,21,25],[22,9,23,9],[22,10,23,10],[22,12,23,13],[22,14,23,14],[22,16,22,18],[20,19,20,22],[20,23,20,25],[22,19,22,22],[22,23,22,25],[24,19,24,22],[24,23,24,25],[27,23,27,25],[28,9,29,9],[28,10,29,10],[28,12,29,13],[28,14,29,14],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[23,4,24,4],[23,5,24,5],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[25,16,26,25],[26,9,27,9],[26,10,27,10],[26,12,27,13],[26,14,27,14],[27,0,28,0],[23,23,23,25],[24,9,25,9],[24,10,25,10],[24,12,25,13],[24,14,25,14],[24,16,24,18],[25,6,26,6],[25,7,26,7],[23,6,24,6],[23,7,24,7],[23,16,23,18],[23,19,23,22],[28,23,28,25],[28,16,28,18],[28,19,28,22],[27,7,28,7],[27,16,27,18],[27,19,27,22],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[27,5,28,5],[27,6,28,6],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[30,23,30,25],[31,23,31,25],[32,9,33,9],[32,10,33,10],[32,12,33,13],[29,7,30,7],[29,16,29,22],[29,23,29,25],[30,9,31,9],[30,10,31,10],[33,23,34,25],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,6],[31,7,32,7],[31,16,31,22],[30,12,31,13],[30,14,31,14],[30,16,30,22],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[35,4,36,4],[35,5,36,5],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[36,23,36,25],[35,23,35,25],[36,16,36,18],[36,19,36,22],[33,6,34,6],[33,7,34,7],[33,16,34,18],[33,19,34,22],[32,14,33,14],[32,16,32,22],[35,19,35,22],[36,9,37,9],[36,10,37,10],[36,12,37,13],[36,14,37,14],[34,9,35,9],[34,10,35,10],[34,12,35,13],[34,14,35,14],[35,6,36,6],[32,23,32,25],[39,0,40,0],[39,1,40,5],[37,6,38,6],[37,7,38,7],[37,16,37,18],[35,7,36,7],[35,16,35,18],[38,23,38,25],[39,6,40,7],[39,10,40,10],[39,16,40,25],[37,19,37,22],[37,23,37,25],[38,9,40,9],[38,12,40,13],[38,14,40,14],[38,16,38,18],[38,19,38,22],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5]]}
["Retour",null,null,"JOURNAL DE VENTES"]
[]
[]
["Colonne1","Colonne2","Colonne3","Colonne4",null,"Colonne6","Colonne7","Colonne8",null,"Colonne10","Colonne11","Colonne12","Colonne13",null,null,null,"Récapitulatif des ventes"]
["CARBURANTS","SUPER 1","SUPER 2","SUPER 3",null,"GASOIL 1","GASOIL 2","Gasoil3",null,null,"VENTE à CREDITS"]
["Index arrivée",38174,6576,27398,null,12385,5224,98302,null,"CLIENTS","PRODUIT","QUANTITEE","MONTANT",null,null,null,"Produits",null,null,"Litrage",null,"P.U",null,"Montant"]
["Index départ",38008,6551,27383,null,12380,5224,98052,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*570","v":0}]
["Sorties",{"$f":"B6-B7","v":166},{"$f":"C6-C7","v":25},{"$f":"D6-D7","v":15},null,{"$f":"F6-F7","v":5},{"$f":"G6-G7","v":0},{"$f":"H6-H7","v":250},null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*570","v":0},null,null,null,"Super en Gros",null,null,{"$f":"D10","v":15},null,0,null,{"$f":"T8*V8","v":0}]
["Retour en cuve",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*570","v":0}]
["Vente par pompe",{"$f":"B8-B9","v":166},{"$f":"C8-C9","v":25},{"$f":"D8-D9","v":15},null,{"$f":"F8-F9","v":5},{"$f":"G8-G9","v":0},{"$f":"H8-H9","v":250},null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Super en detail",null,null,{"$f":"SUM(B10:C10)","v":191},null,0,null,{"$f":"T10*V10","v":0}]
["Vente par produit",{"$f":"SUM(B10:D10)","v":206},null,null,null,{"$f":"SUM(F10:H10)","v":255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*540","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en Gros",null,null,{"$f":"H10","v":250},null,0,null,{"$f":"T12*V12","v":0}]
["Stock jauge ouverture",0,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*540","v":0}]
["Entrée de stock",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en detail",null,null,{"$f":"SUM(F10:G10)","v":5},null,0,null,{"$f":"T14*V14","v":0}]
["Cumul de stock",{"$f":"B13+B14","v":0},null,null,null,{"$f":"F13+F14","v":0},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*670","v":0}]
["Sorties par produit",{"$f":"B11","v":206},null,null,null,{"$f":"F11","v":255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*670","v":0},null,null,null,"Total Carburants",null,null,null,null,null,null,{"$f":"SUM(X8:Z15)","v":0}]
["Stock theorique",{"$f":"B15-B16","v":-206},null,null,null,{"$f":"F15-F16","v":-255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935[[#This Row],[Colonne12]]*670","v":0}]
["Stock jauge fermeture",0,null,null,null,0,null,null,null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,M5:M17)","v":0},null,null,null,"1.Recette carburant",null,null,null,null,null,null,{"$f":"X16","v":0}]
["Ecart",{"$f":"B18-B17","v":206},null,null,null,{"$f":"F18-F17","v":255},null,null,null,null,null,null,null,null,null,null,"2.Recette Lubrifiants",null,null,null,null,null,null,{"$f":"G40","v":0}]
["Lubrifiants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.recette Boutique",null,null,null,null,null,null,{"$f":"K40","v":0}]
["Désignation","Stock ouverture","Entrée","Stock total","Stock fermeture","Vente","P.U","Montant",null,"ACTIVTES DES BAIES",null,null,"DETAIL DES CREDITS PAYES CE JOURS CI",null,null,null,"4.Cumul recettes",null,null,null,null,null,null,{"$f":"SUM(X18:Z20)","v":0}]
["PERFO HDX 700",0,0,{"$f":"SUM(B22:C23)","v":0},0,{"$f":"D22-E22","v":0},null,{"$f":"F22*G22","v":0},null,"DESIGNATION","MONTANT",null,"NOM & PRENOM DU CLIENT",null,"MONTANT",null,"5.Credit de la journée (à deduire)",null,null,null,null,null,null,{"$f":"M18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.Vente au comptant",null,null,null,null,null,null,{"$f":"X21-X22","v":0}]
["ATLANTIS 5000 (4L)",0,0,{"$f":"SUM(B24:C25)","v":0},0,{"$f":"D24-E24","v":0},null,{"$f":"F24*G24","v":0},null,null,null,null,null,null,null,null,"7.Credits anterieurs ancaissés",null,null,null,null,null,null,{"$f":"O39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.Total des encaissements",null,null,null,null,null,null,{"$f":"X23+X24","v":0}]
["ATLANTIS 5000 (1L)",0,0,{"$f":"SUM(B26:C27)","v":0},0,{"$f":"D26-E26","v":0},null,{"$f":"F26*G26","v":0},null,null,null,null,null,null,null,null,"DEPENSE DE LA JOURNEE (A DEDUIRE)"]
[]
["EVOLUTION 300 (5L)",0,0,{"$f":"SUM(B28:C29)","v":0},0,{"$f":"D28-E28","v":0},null,{"$f":"F28*G28","v":0},null,null,null,null,null,null,null,null,"RATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPRO-GROUPE",null,null,null,null,null,null,{"$f":"T29*570","v":0}]
["EVOLUTION 300 (1L)",0,0,{"$f":"SUM(B30:C31)","v":0},0,{"$f":"D30-E30","v":0},null,{"$f":"F30*G30","v":0},null,null,null,null,null,null,null,null,"FACTURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVERS"]
["GEAR ELF",0,0,{"$f":"SUM(B32:C33)","v":0},0,{"$f":"D32-E32","v":0},null,{"$f":"F32*G32","v":0},null,null,null,null,null,null,null,null,"REMISE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAIRE ET DEPLACEMENT GERANT"]
["ELFMATIC",0,0,{"$f":"SUM(B34:C35)","v":0},0,{"$f":"D34-E34","v":0},null,{"$f":"F34*G34","v":0},null,null,null,null,null,null,null,null,"Total des depenses",null,null,null,null,null,null,{"$f":"SUM(X28:Z33)","v":0}]
[]
["BRAKE FLUID",0,0,{"$f":"SUM(B36:C37)","v":0},0,{"$f":"D36-E36","v":0},null,{"$f":"F36*G36","v":0},null,null,null,null,null,null,null,null,"10.Montant net en caisse",null,null,null,null,null,null,{"$f":"X25-X34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.Versement banque"]
["ATF",0,0,{"$f":"SUM(B38:C39)","v":0},0,{"$f":"D38-E38","v":0},null,{"$f":"F38*G38","v":0},null,null,null,null,null,null,null,null,"12.Solde en caisse fin journée",null,null,null,null,null,null,{"$f":"X36-X37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(O23:O38)","v":0},null,"13.Ecart de caisse"]
["TOTAL",null,null,null,null,null,{"$f":"SUM(H22:H39)","v":0},null,null,null,{"$f":"SUM(K23:K38)","v":0},null,null,null,null,null,"OBSERVATIONS"]

{"sheet":"30-01-2020","index":2,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,40,0],[39,1,40,5],[39,6,40,7],[39,10,40,10],[39,16,40,25],[37,19,37,22],[37,23,37,25],[38,9,40,9],[38,12,40,13],[38,14,40,14],[38,16,38,18],[38,19,38,22],[38,23,38,25],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,7,38,7],[37,16,37,18],[36,9,37,9],[36,10,37,10],[36,12,37,13],[36,14,37,14],[36,16,36,18],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[33,6,34,6],[33,7,34,7],[33,16,34,18],[33,19,34,22],[33,23,34,25],[34,9,35,9],[34,10,35,10],[34,12,35,13],[34,14,35,14],[35,6,36,6],[36,23,36,25],[35,7,36,7],[35,16,35,18],[35,19,35,22],[35,23,35,25],[36,19,36,22],[32,9,33,9],[32,10,33,10],[32,12,33,13],[32,14,33,14],[32,16,32,22],[32,23,32,25],[31,6,32,6],[31,7,32,7],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[31,16,31,22],[29,7,30,7],[29,16,29,22],[29,23,29,25],[30,9,31,9],[30,10,31,10],[30,12,31,13],[30,14,31,14],[30,16,30,22],[30,23,30,25],[31,23,31,25],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[27,5,28,5],[27,6,28,6],[23,1,24,1],[23,2,24,2],[23,3,24,3],[25,16,26,25],[26,9,27,9],[26,10,27,10],[26,12,27,13],[26,14,27,14],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[28,16,28,18],[28,19,28,22],[28,23,28,25],[27,7,28,7],[27,16,27,18],[27,19,27,22],[27,23,27,25],[28,9,29,9],[28,10,29,10],[28,12,29,13],[28,14,29,14],[22,16,22,18],[22,19,22,22],[22,23,22,25],[24,19,24,22],[24,23,24,25],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[23,6,24,6],[23,7,24,7],[23,16,23,18],[23,19,23,22],[23,23,23,25],[24,9,25,9],[24,10,25,10],[24,12,25,13],[24,14,25,14],[24,16,24,18],[23,0,24,0],[20,9,20,10],[20,11,40,11],[20,12,20,14],[20,15,40,15],[20,16,20,18],[20,19,20,22],[20,23,20,25],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[23,4,24,4],[23,5,24,5],[21,16,21,18],[21,19,21,22],[21,23,21,25],[22,9,23,9],[22,10,23,10],[22,12,23,13],[22,14,23,14],[17,19,17,22],[17,23,17,25],[18,1,18,3],[18,5,18,7],[18,9,19,12],[18,16,18,18],[18,19,18,22],[18,23,18,25],[19,0,19,7],[19,16,19,18],[19,19,19,22],[19,23,19,25],[11,19,12,20],[11,21,12,22],[11,23,12,25],[12,1,12,3],[12,4,18,4],[12,5,12,7],[13,1,13,3],[13,5,13,7],[15,1,15,3],[15,5,15,7],[15,16,16,18],[15,19,16,22],[15,23,16,25],[16,1,16,3],[16,5,16,7],[13,16,14,18],[13,19,14,20],[13,21,14,22],[13,23,14,25],[14,1,14,3],[14,5,14,7],[17,1,17,3],[17,5,17,7],[17,16,17,18],[0,3,2,19],[0,20,0,25],[1,20,1,25],[2,20,2,25],[3,4,10,4],[3,8,40,8],[3,13,19,15],[3,16,4,25],[5,16,6,18],[5,19,6,20],[9,16,10,18],[9,19,10,20],[9,21,10,22],[9,23,10,25],[10,1,10,3],[10,5,10,7],[5,21,6,22],[5,23,6,25],[7,16,8,18],[7,19,8,20],[7,21,8,22],[7,23,8,25],[11,0,11,7],[11,16,12,18]]}
["Retour",null,null,"JOURNAL DE VENTES"]
[]
[]
["Colonne1","Colonne2","Colonne3","Colonne4",null,"Colonne6","Colonne7","Colonne8",null,"Colonne10","Colonne11","Colonne12","Colonne13",null,null,null,"Récapitulatif des ventes"]
["CARBURANTS","SUPER 1","SUPER 2","SUPER 3",null,"GASOIL 1","GASOIL 2","Gasoil3",null,null,"VENTE à CREDITS"]
["Index arrivée",38174,6576,27398,null,12385,5224,98302,null,"CLIENTS","PRODUIT","QUANTITEE","MONTANT",null,null,null,"Produits",null,null,"Litrage",null,"P.U",null,"Montant"]
["Index départ",38008,6551,27383,null,12380,5224,98052,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*570","v":0}]
["Sorties",{"$f":"B6-B7","v":166},{"$f":"C6-C7","v":25},{"$f":"D6-D7","v":15},null,{"$f":"F6-F7","v":5},{"$f":"G6-G7","v":0},{"$f":"H6-H7","v":250},null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*570","v":0},null,null,null,"Super en Gros",null,null,{"$f":"D10","v":15},null,0,null,{"$f":"T8*V8","v":0}]
["Retour en cuve",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*570","v":0}]
["Vente par pompe",{"$f":"B8-B9","v":166},{"$f":"C8-C9","v":25},{"$f":"D8-D9","v":15},null,{"$f":"F8-F9","v":5},{"$f":"G8-G9","v":0},{"$f":"H8-H9","v":250},null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Super en detail",null,null,{"$f":"SUM(B10:C10)","v":191},null,0,null,{"$f":"T10*V10","v":0}]
["Vente par produit",{"$f":"SUM(B10:D10)","v":206},null,null,null,{"$f":"SUM(F10:H10)","v":255},null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*540","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en Gros",null,null,{"$f":"H10","v":250},null,0,null,{"$f":"T12*V12","v":0}]
["Stock jauge ouverture",0,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*540","v":0}]
["Entrée de stock",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en detail",null,null,{"$f":"SUM(F10:G10)","v":5},null,0,null,{"$f":"T14*V14","v":0}]
["Cumul de stock",{"$f":"B13+B14","v":0},null,null,null,{"$f":"F13+F14","v":0},null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*670","v":0}]
["Sorties par produit",{"$f":"B11","v":206},null,null,null,{"$f":"F11","v":255},null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*670","v":0},null,null,null,"Total Carburants",null,null,null,null,null,null,{"$f":"SUM(X8:Z15)","v":0}]
["Stock theorique",{"$f":"B15-B16","v":-206},null,null,null,{"$f":"F15-F16","v":-255},null,null,null,null,null,null,{"$f":"Tableau37341926666880899353[[#This Row],[Colonne12]]*670","v":0}]
["Stock jauge fermeture",0,null,null,null,0,null,null,null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,M5:M17)","v":0},null,null,null,"1.Recette carburant",null,null,null,null,null,null,{"$f":"X16","v":0}]
["Ecart",{"$f":"B18-B17","v":206},null,null,null,{"$f":"F18-F17","v":255},null,null,null,null,null,null,null,null,null,null,"2.Recette Lubrifiants",null,null,null,null,null,null,{"$f":"G40","v":0}]
["Lubrifiants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.recette Boutique",null,null,null,null,null,null,{"$f":"K40","v":0}]
["Désignation","Stock ouverture","Entrée","Stock total","Stock fermeture","Vente","P.U","Montant",null,"ACTIVTES DES BAIES",null,null,"DETAIL DES CREDITS PAYES CE JOURS CI",null,null,null,"4.Cumul recettes",null,null,null,null,null,null,{"$f":"SUM(X18:Z20)","v":0}]
["PERFO HDX 700",0,0,{"$f":"SUM(B22:C23)","v":0},0,{"$f":"D22-E22","v":0},null,{"$f":"F22*G22","v":0},null,"DESIGNATION","MONTANT",null,"NOM & PRENOM DU CLIENT",null,"MONTANT",null,"5.Credit de la journée (à deduire)",null,null,null,null,null,null,{"$f":"M18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.Vente au comptant",null,null,null,null,null,null,{"$f":"X21-X22","v":0}]
["ATLANTIS 5000 (4L)",0,0,{"$f":"SUM(B24:C25)","v":0},0,{"$f":"D24-E24","v":0},null,{"$f":"F24*G24","v":0},null,null,null,null,null,null,null,null,"7.Credits anterieurs ancaissés",null,null,null,null,null,null,{"$f":"O39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.Total des encaissements",null,null,null,null,null,null,{"$f":"X23+X24","v":0}]
["ATLANTIS 5000 (1L)",0,0,{"$f":"SUM(B26:C27)","v":0},0,{"$f":"D26-E26","v":0},null,{"$f":"F26*G26","v":0},null,null,null,null,null,null,null,null,"DEPENSE DE LA JOURNEE (A DEDUIRE)"]
[]
["EVOLUTION 300 (5L)",0,0,{"$f":"SUM(B28:C29)","v":0},0,{"$f":"D28-E28","v":0},null,{"$f":"F28*G28","v":0},null,null,null,null,null,null,null,null,"RATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPRO-GROUPE",null,null,null,null,null,null,{"$f":"T29*570","v":0}]
["EVOLUTION 300 (1L)",0,0,{"$f":"SUM(B30:C31)","v":0},0,{"$f":"D30-E30","v":0},null,{"$f":"F30*G30","v":0},null,null,null,null,null,null,null,null,"FACTURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVERS"]
["GEAR ELF",0,0,{"$f":"SUM(B32:C33)","v":0},0,{"$f":"D32-E32","v":0},null,{"$f":"F32*G32","v":0},null,null,null,null,null,null,null,null,"REMISE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAIRE ET DEPLACEMENT GERANT"]
["ELFMATIC",0,0,{"$f":"SUM(B34:C35)","v":0},0,{"$f":"D34-E34","v":0},null,{"$f":"F34*G34","v":0},null,null,null,null,null,null,null,null,"Total des depenses",null,null,null,null,null,null,{"$f":"SUM(X28:Z33)","v":0}]
[]
["BRAKE FLUID",0,0,{"$f":"SUM(B36:C37)","v":0},0,{"$f":"D36-E36","v":0},null,{"$f":"F36*G36","v":0},null,null,null,null,null,null,null,null,"10.Montant net en caisse",null,null,null,null,null,null,{"$f":"X25-X34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.Versement banque"]
["ATF",0,0,{"$f":"SUM(B38:C39)","v":0},0,{"$f":"D38-E38","v":0},null,{"$f":"F38*G38","v":0},null,null,null,null,null,null,null,null,"12.Solde en caisse fin journée",null,null,null,null,null,null,{"$f":"X36-X37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(O23:O38)","v":0},null,"13.Ecart de caisse"]
["TOTAL",null,null,null,null,null,{"$f":"SUM(H22:H39)","v":0},null,null,null,{"$f":"SUM(K23:K38)","v":0},null,null,null,null,null,"OBSERVATIONS"]

{"sheet":"31-01-2020","index":3,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,40,0],[39,1,40,5],[39,6,40,7],[39,10,40,10],[39,16,40,25],[37,19,37,22],[37,23,37,25],[38,9,40,9],[38,12,40,13],[38,14,40,14],[38,16,38,18],[38,19,38,22],[38,23,38,25],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,7,38,7],[37,16,37,18],[36,9,37,9],[36,10,37,10],[36,12,37,13],[36,14,37,14],[36,16,36,18],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[33,6,34,6],[33,7,34,7],[33,16,34,18],[33,19,34,22],[33,23,34,25],[34,9,35,9],[34,10,35,10],[34,12,35,13],[34,14,35,14],[35,6,36,6],[36,23,36,25],[35,7,36,7],[35,16,35,18],[35,19,35,22],[35,23,35,25],[36,19,36,22],[32,9,33,9],[32,10,33,10],[32,12,33,13],[32,14,33,14],[32,16,32,22],[32,23,32,25],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[31,6,32,6],[31,7,32,7],[31,16,31,22],[29,7,30,7],[29,16,29,22],[29,23,29,25],[30,9,31,9],[30,10,31,10],[30,12,31,13],[30,14,31,14],[30,16,30,22],[30,23,30,25],[31,23,31,25],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[27,5,28,5],[27,6,28,6],[23,1,24,1],[23,2,24,2],[23,3,24,3],[25,16,26,25],[26,9,27,9],[26,10,27,10],[26,12,27,13],[26,14,27,14],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[28,16,28,18],[28,19,28,22],[28,23,28,25],[27,7,28,7],[27,16,27,18],[27,19,27,22],[27,23,27,25],[28,9,29,9],[28,10,29,10],[28,12,29,13],[28,14,29,14],[22,16,22,18],[22,19,22,22],[22,23,22,25],[24,19,24,22],[24,23,24,25],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[23,6,24,6],[23,7,24,7],[23,16,23,18],[23,19,23,22],[23,23,23,25],[24,9,25,9],[24,10,25,10],[24,12,25,13],[24,14,25,14],[24,16,24,18],[23,0,24,0],[20,9,20,10],[20,11,40,11],[20,12,20,14],[20,15,40,15],[20,16,20,18],[20,19,20,22],[20,23,20,25],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[23,4,24,4],[23,5,24,5],[21,16,21,18],[21,19,21,22],[21,23,21,25],[22,9,23,9],[22,10,23,10],[22,12,23,13],[22,14,23,14],[17,19,17,22],[17,23,17,25],[18,1,18,3],[18,5,18,7],[18,9,19,12],[18,16,18,18],[18,19,18,22],[18,23,18,25],[19,0,19,7],[19,16,19,18],[19,19,19,22],[19,23,19,25],[11,19,12,20],[11,21,12,22],[11,23,12,25],[12,1,12,3],[12,4,18,4],[12,5,12,7],[13,1,13,3],[13,5,13,7],[15,1,15,3],[15,5,15,7],[15,16,16,18],[15,19,16,22],[15,23,16,25],[16,1,16,3],[16,5,16,7],[13,16,14,18],[13,19,14,20],[13,21,14,22],[13,23,14,25],[14,1,14,3],[14,5,14,7],[17,1,17,3],[17,5,17,7],[17,16,17,18],[0,3,2,19],[0,20,0,25],[1,20,1,25],[2,20,2,25],[3,4,10,4],[3,8,40,8],[3,13,19,15],[3,16,4,25],[5,16,6,18],[5,19,6,20],[9,16,10,18],[9,19,10,20],[9,21,10,22],[9,23,10,25],[10,1,10,3],[10,5,10,7],[5,21,6,22],[5,23,6,25],[7,16,8,18],[7,19,8,20],[7,21,8,22],[7,23,8,25],[11,0,11,7],[11,16,12,18]]}
["Retour",null,null,"JOURNAL DE VENTES"]
[]
[]
["Colonne1","Colonne2","Colonne3","Colonne4",null,"Colonne6","Colonne7","Colonne8",null,"Colonne10","Colonne11","Colonne12","Colonne13",null,null,null,"Récapitulatif des ventes"]
["CARBURANTS","SUPER 1","SUPER 2","SUPER 3",null,"GASOIL 1","GASOIL 2","Gasoil3",null,null,"VENTE à CREDITS"]
["Index arrivée",25,45,60,null,14,12,58,null,"CLIENTS","PRODUIT","QUANTITEE","MONTANT",null,null,null,"Produits",null,null,"Litrage",null,"P.U",null,"Montant"]
["Index départ",15,32,45,null,11,10,20,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*570","v":0}]
["Sorties",{"$f":"B6-B7","v":10},{"$f":"C6-C7","v":13},{"$f":"D6-D7","v":15},null,{"$f":"F6-F7","v":3},{"$f":"G6-G7","v":2},{"$f":"H6-H7","v":38},null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*570","v":0},null,null,null,"Super en Gros",null,null,{"$f":"D10","v":15},null,0,null,{"$f":"T8*V8","v":0}]
["Retour en cuve",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*570","v":0}]
["Vente par pompe",{"$f":"B8-B9","v":10},{"$f":"C8-C9","v":13},{"$f":"D8-D9","v":15},null,{"$f":"F8-F9","v":3},{"$f":"G8-G9","v":2},{"$f":"H8-H9","v":38},null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Super en detail",null,null,{"$f":"SUM(B10:C10)","v":23},null,0,null,{"$f":"T10*V10","v":0}]
["Vente par produit",{"$f":"SUM(B10:D10)","v":38},null,null,null,{"$f":"SUM(F10:H10)","v":43},null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*540","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en Gros",null,null,{"$f":"H10","v":38},null,0,null,{"$f":"T12*V12","v":0}]
["Stock jauge ouverture",0,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*540","v":0}]
["Entrée de stock",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en detail",null,null,{"$f":"SUM(F10:G10)","v":5},null,0,null,{"$f":"T14*V14","v":0}]
["Cumul de stock",{"$f":"B13+B14","v":0},null,null,null,{"$f":"F13+F14","v":0},null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*670","v":0}]
["Sorties par produit",{"$f":"B11","v":38},null,null,null,{"$f":"F11","v":43},null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*670","v":0},null,null,null,"Total Carburants",null,null,null,null,null,null,{"$f":"SUM(X8:Z15)","v":0}]
["Stock theorique",{"$f":"B15-B16","v":-38},null,null,null,{"$f":"F15-F16","v":-43},null,null,null,null,null,null,{"$f":"Tableau373419266668808993534[[#This Row],[Colonne12]]*670","v":0}]
["Stock jauge fermeture",0,null,null,null,0,null,null,null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,M5:M17)","v":0},null,null,null,"1.Recette carburant",null,null,null,null,null,null,{"$f":"X16","v":0}]
["Ecart",{"$f":"B18-B17","v":38},null,null,null,{"$f":"F18-F17","v":43},null,null,null,null,null,null,null,null,null,null,"2.Recette Lubrifiants",null,null,null,null,null,null,{"$f":"G40","v":0}]
["Lubrifiants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.recette Boutique",null,null,null,null,null,null,{"$f":"K40","v":0}]
["Désignation","Stock ouverture","Entrée","Stock total","Stock fermeture","Vente","P.U","Montant",null,"ACTIVTES DES BAIES",null,null,"DETAIL DES CREDITS PAYES CE JOURS CI",null,null,null,"4.Cumul recettes",null,null,null,null,null,null,{"$f":"SUM(X18:Z20)","v":0}]
["PERFO HDX 700",0,0,{"$f":"SUM(B22:C23)","v":0},0,{"$f":"D22-E22","v":0},null,{"$f":"F22*G22","v":0},null,"DESIGNATION","MONTANT",null,"NOM & PRENOM DU CLIENT",null,"MONTANT",null,"5.Credit de la journée (à deduire)",null,null,null,null,null,null,{"$f":"M18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.Vente au comptant",null,null,null,null,null,null,{"$f":"X21-X22","v":0}]
["ATLANTIS 5000 (4L)",0,0,{"$f":"SUM(B24:C25)","v":0},0,{"$f":"D24-E24","v":0},null,{"$f":"F24*G24","v":0},null,null,null,null,null,null,null,null,"7.Credits anterieurs ancaissés",null,null,null,null,null,null,{"$f":"O39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.Total des encaissements",null,null,null,null,null,null,{"$f":"X23+X24","v":0}]
["ATLANTIS 5000 (1L)",0,0,{"$f":"SUM(B26:C27)","v":0},0,{"$f":"D26-E26","v":0},null,{"$f":"F26*G26","v":0},null,null,null,null,null,null,null,null,"DEPENSE DE LA JOURNEE (A DEDUIRE)"]
[]
["EVOLUTION 300 (5L)",0,0,{"$f":"SUM(B28:C29)","v":0},0,{"$f":"D28-E28","v":0},null,{"$f":"F28*G28","v":0},null,null,null,null,null,null,null,null,"RATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPRO-GROUPE",null,null,null,null,null,null,{"$f":"T29*570","v":0}]
["EVOLUTION 300 (1L)",0,0,{"$f":"SUM(B30:C31)","v":0},0,{"$f":"D30-E30","v":0},null,{"$f":"F30*G30","v":0},null,null,null,null,null,null,null,null,"FACTURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVERS"]
["GEAR ELF",0,0,{"$f":"SUM(B32:C33)","v":0},0,{"$f":"D32-E32","v":0},null,{"$f":"F32*G32","v":0},null,null,null,null,null,null,null,null,"REMISE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAIRE ET DEPLACEMENT GERANT"]
["ELFMATIC",0,0,{"$f":"SUM(B34:C35)","v":0},0,{"$f":"D34-E34","v":0},null,{"$f":"F34*G34","v":0},null,null,null,null,null,null,null,null,"Total des depenses",null,null,null,null,null,null,{"$f":"SUM(X28:Z33)","v":0}]
[]
["BRAKE FLUID",0,0,{"$f":"SUM(B36:C37)","v":0},0,{"$f":"D36-E36","v":0},null,{"$f":"F36*G36","v":0},null,null,null,null,null,null,null,null,"10.Montant net en caisse",null,null,null,null,null,null,{"$f":"X25-X34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.Versement banque"]
["ATF",0,0,{"$f":"SUM(B38:C39)","v":0},0,{"$f":"D38-E38","v":0},null,{"$f":"F38*G38","v":0},null,null,null,null,null,null,null,null,"12.Solde en caisse fin journée",null,null,null,null,null,null,{"$f":"X36-X37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(O23:O38)","v":0},null,"13.Ecart de caisse"]
["TOTAL",null,null,null,null,null,{"$f":"SUM(H22:H39)","v":0},null,null,null,{"$f":"SUM(K23:K38)","v":0},null,null,null,null,null,"OBSERVATIONS"]

{"sheet":"01-02-2020","index":4,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,0,40,0],[39,1,40,5],[39,6,40,7],[39,10,40,10],[39,16,40,25],[37,19,37,22],[37,23,37,25],[38,9,40,9],[38,12,40,13],[38,14,40,14],[38,16,38,18],[38,19,38,22],[38,23,38,25],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[37,7,38,7],[37,16,37,18],[36,9,37,9],[36,10,37,10],[36,12,37,13],[36,14,37,14],[36,16,36,18],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[33,6,34,6],[33,7,34,7],[33,16,34,18],[33,19,34,22],[33,23,34,25],[34,9,35,9],[34,10,35,10],[34,12,35,13],[34,14,35,14],[35,6,36,6],[36,23,36,25],[35,7,36,7],[35,16,35,18],[35,19,35,22],[35,23,35,25],[36,19,36,22],[32,9,33,9],[32,10,33,10],[32,12,33,13],[32,14,33,14],[32,16,32,22],[32,23,32,25],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[31,6,32,6],[31,7,32,7],[31,16,31,22],[29,7,30,7],[29,16,29,22],[29,23,29,25],[30,9,31,9],[30,10,31,10],[30,12,31,13],[30,14,31,14],[30,16,30,22],[30,23,30,25],[31,23,31,25],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[27,5,28,5],[27,6,28,6],[23,1,24,1],[23,2,24,2],[23,3,24,3],[25,16,26,25],[26,9,27,9],[26,10,27,10],[26,12,27,13],[26,14,27,14],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[28,16,28,18],[28,19,28,22],[28,23,28,25],[27,7,28,7],[27,16,27,18],[27,19,27,22],[27,23,27,25],[28,9,29,9],[28,10,29,10],[28,12,29,13],[28,14,29,14],[22,16,22,18],[22,19,22,22],[22,23,22,25],[24,19,24,22],[24,23,24,25],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[23,6,24,6],[23,7,24,7],[23,16,23,18],[23,19,23,22],[23,23,23,25],[24,9,25,9],[24,10,25,10],[24,12,25,13],[24,14,25,14],[24,16,24,18],[23,0,24,0],[20,9,20,10],[20,11,40,11],[20,12,20,14],[20,15,40,15],[20,16,20,18],[20,19,20,22],[20,23,20,25],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[21,7,22,7],[23,4,24,4],[23,5,24,5],[21,16,21,18],[21,19,21,22],[21,23,21,25],[22,9,23,9],[22,10,23,10],[22,12,23,13],[22,14,23,14],[17,19,17,22],[17,23,17,25],[18,1,18,3],[18,5,18,7],[18,9,19,12],[18,16,18,18],[18,19,18,22],[18,23,18,25],[19,0,19,7],[19,16,19,18],[19,19,19,22],[19,23,19,25],[11,19,12,20],[11,21,12,22],[11,23,12,25],[12,1,12,3],[12,4,18,4],[12,5,12,7],[13,1,13,3],[13,5,13,7],[15,1,15,3],[15,5,15,7],[15,16,16,18],[15,19,16,22],[15,23,16,25],[16,1,16,3],[16,5,16,7],[13,16,14,18],[13,19,14,20],[13,21,14,22],[13,23,14,25],[14,1,14,3],[14,5,14,7],[17,1,17,3],[17,5,17,7],[17,16,17,18],[0,3,2,19],[0,20,0,25],[1,20,1,25],[2,20,2,25],[3,4,10,4],[3,8,40,8],[3,13,19,15],[3,16,4,25],[5,16,6,18],[5,19,6,20],[9,16,10,18],[9,19,10,20],[9,21,10,22],[9,23,10,25],[10,1,10,3],[10,5,10,7],[5,21,6,22],[5,23,6,25],[7,16,8,18],[7,19,8,20],[7,21,8,22],[7,23,8,25],[11,0,11,7],[11,16,12,18]]}
["Retour",null,null,"JOURNAL DE VENTES"]
[]
[]
["Colonne1","Colonne2","Colonne3","Colonne4",null,"Colonne6","Colonne7","Colonne8",null,"Colonne10","Colonne11","Colonne12","Colonne13",null,null,null,"Récapitulatif des ventes"]
["CARBURANTS","SUPER 1","SUPER 2","SUPER 3",null,"GASOIL 1","GASOIL 2","Gasoil3",null,null,"VENTE à CREDITS"]
["Index arrivée",38174,6576,27398,null,12385,5224,98302,null,"CLIENTS","PRODUIT","QUANTITEE","MONTANT",null,null,null,"Produits",null,null,"Litrage",null,"P.U",null,"Montant"]
["Index départ",38008,6551,27383,null,12380,5224,98052,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*570","v":0}]
["Sorties",{"$f":"B6-B7","v":166},{"$f":"C6-C7","v":25},{"$f":"D6-D7","v":15},null,{"$f":"F6-F7","v":5},{"$f":"G6-G7","v":0},{"$f":"H6-H7","v":250},null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*570","v":0},null,null,null,"Super en Gros",null,null,{"$f":"D10","v":15},null,0,null,{"$f":"T8*V8","v":0}]
["Retour en cuve",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*570","v":0}]
["Vente par pompe",{"$f":"B8-B9","v":166},{"$f":"C8-C9","v":25},{"$f":"D8-D9","v":15},null,{"$f":"F8-F9","v":5},{"$f":"G8-G9","v":0},{"$f":"H8-H9","v":250},null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Super en detail",null,null,{"$f":"SUM(B10:C10)","v":191},null,0,null,{"$f":"T10*V10","v":0}]
["Vente par produit",{"$f":"SUM(B10:D10)","v":206},null,null,null,{"$f":"SUM(F10:H10)","v":255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*540","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en Gros",null,null,{"$f":"H10","v":250},null,0,null,{"$f":"T12*V12","v":0}]
["Stock jauge ouverture",0,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*540","v":0}]
["Entrée de stock",null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*540","v":0},null,null,null,"Gasoil en detail",null,null,{"$f":"SUM(F10:G10)","v":5},null,0,null,{"$f":"T14*V14","v":0}]
["Cumul de stock",{"$f":"B13+B14","v":0},null,null,null,{"$f":"F13+F14","v":0},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*670","v":0}]
["Sorties par produit",{"$f":"B11","v":206},null,null,null,{"$f":"F11","v":255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*670","v":0},null,null,null,"Total Carburants",null,null,null,null,null,null,{"$f":"SUM(X8:Z15)","v":0}]
["Stock theorique",{"$f":"B15-B16","v":-206},null,null,null,{"$f":"F15-F16","v":-255},null,null,null,null,null,null,{"$f":"Tableau3734192666688089935345[[#This Row],[Colonne12]]*670","v":0}]
["Stock jauge fermeture",0,null,null,null,0,null,null,null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,M5:M17)","v":0},null,null,null,"1.Recette carburant",null,null,null,null,null,null,{"$f":"X16","v":0}]
["Ecart",{"$f":"B18-B17","v":206},null,null,null,{"$f":"F18-F17","v":255},null,null,null,null,null,null,null,null,null,null,"2.Recette Lubrifiants",null,null,null,null,null,null,{"$f":"G40","v":0}]
["Lubrifiants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.recette Boutique",null,null,null,null,null,null,{"$f":"K40","v":0}]
["Désignation","Stock ouverture","Entrée","Stock total","Stock fermeture","Vente","P.U","Montant",null,"ACTIVTES DES BAIES",null,null,"DETAIL DES CREDITS PAYES CE JOURS CI",null,null,null,"4.Cumul recettes",null,null,null,null,null,null,{"$f":"SUM(X18:Z20)","v":0}]
["PERFO HDX 700",0,0,{"$f":"SUM(B22:C23)","v":0},0,{"$f":"D22-E22","v":0},null,{"$f":"F22*G22","v":0},null,"DESIGNATION","MONTANT",null,"NOM & PRENOM DU CLIENT",null,"MONTANT",null,"5.Credit de la journée (à deduire)",null,null,null,null,null,null,{"$f":"M18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.Vente au comptant",null,null,null,null,null,null,{"$f":"X21-X22","v":0}]
["ATLANTIS 5000 (4L)",0,0,{"$f":"SUM(B24:C25)","v":0},0,{"$f":"D24-E24","v":0},null,{"$f":"F24*G24","v":0},null,null,null,null,null,null,null,null,"7.Credits anterieurs ancaissés",null,null,null,null,null,null,{"$f":"O39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8.Total des encaissements",null,null,null,null,null,null,{"$f":"X23+X24","v":0}]
["ATLANTIS 5000 (1L)",0,0,{"$f":"SUM(B26:C27)","v":0},0,{"$f":"D26-E26","v":0},null,{"$f":"F26*G26","v":0},null,null,null,null,null,null,null,null,"DEPENSE DE LA JOURNEE (A DEDUIRE)"]
[]
["EVOLUTION 300 (5L)",0,0,{"$f":"SUM(B28:C29)","v":0},0,{"$f":"D28-E28","v":0},null,{"$f":"F28*G28","v":0},null,null,null,null,null,null,null,null,"RATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPRO-GROUPE",null,null,null,null,null,null,{"$f":"T29*570","v":0}]
["EVOLUTION 300 (1L)",0,0,{"$f":"SUM(B30:C31)","v":0},0,{"$f":"D30-E30","v":0},null,{"$f":"F30*G30","v":0},null,null,null,null,null,null,null,null,"FACTURES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DIVERS"]
["GEAR ELF",0,0,{"$f":"SUM(B32:C33)","v":0},0,{"$f":"D32-E32","v":0},null,{"$f":"F32*G32","v":0},null,null,null,null,null,null,null,null,"REMISE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAIRE ET DEPLACEMENT GERANT"]
["ELFMATIC",0,0,{"$f":"SUM(B34:C35)","v":0},0,{"$f":"D34-E34","v":0},null,{"$f":"F34*G34","v":0},null,null,null,null,null,null,null,null,"Total des depenses",null,null,null,null,null,null,{"$f":"SUM(X28:Z33)","v":0}]
[]
["BRAKE FLUID",0,0,{"$f":"SUM(B36:C37)","v":0},0,{"$f":"D36-E36","v":0},null,{"$f":"F36*G36","v":0},null,null,null,null,null,null,null,null,"10.Montant net en caisse",null,null,null,null,null,null,{"$f":"X25-X34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.Versement banque"]
["ATF",0,0,{"$f":"SUM(B38:C39)","v":0},0,{"$f":"D38-E38","v":0},null,{"$f":"F38*G38","v":0},null,null,null,null,null,null,null,null,"12.Solde en caisse fin journée",null,null,null,null,null,null,{"$f":"X36-X37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(O23:O38)","v":0},null,"13.Ecart de caisse"]
["TOTAL",null,null,null,null,null,{"$f":"SUM(H22:H39)","v":0},null,null,null,{"$f":"SUM(K23:K38)","v":0},null,null,null,null,null,"OBSERVATIONS"]

{"sheet":"Menu","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"2020-02-01",null,{"$f":"B3+10","v":"2020-02-11"},null,{"$f":"D3+11","v":"2020-02-22"}]
[null,{"$f":"B3+1","v":"2020-02-02"},null,{"$f":"D3+1","v":"2020-02-12"},null,{"$f":"F3+1","v":"2020-02-23"}]
[null,{"$f":"B4+1","v":"2020-02-03"},null,{"$f":"D4+1","v":"2020-02-13"},null,{"$f":"F4+1","v":"2020-02-24"}]
[null,"2020-02-04",null,"2020-02-14",null,"2020-02-25"]
[null,"2020-02-05",null,"2020-02-15",null,"2020-02-26"]
[null,"2020-02-06",null,"2020-02-16",null,"2020-02-27"]
[null,"2020-02-07",null,"2020-02-17",null,"2020-02-28"]
[null,"2020-02-08",null,"2020-02-18",null,"2020-02-29"]
[null,"2020-02-09",null,"2020-02-19",null,"2020-01-30"]
[null,"2020-02-10",null,"2020-02-20",null,"2020-01-31"]
[null,null,null,"2020-02-21"]