{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Login","ACCEUIL","Approvisionnement","Membres","Orange Money","MTN Money","Moov Money","Wari","UBA achat","UBA rechargement","Donnees approvis UBA achat","Donnees approvis UBA recharg","Donnees approvis Orange","Donnees approvis MTN","Donnees approvis WARI","Donnees approvis Moov","donnees","frais","operation"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":7,"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":"Login","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"ACCEUIL","index":1,"n_rows":2,"n_cols":14,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Bonjour Admin Lamine"]

{"sheet":"Approvisionnement","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Membres","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"User","Password","Role"]
[null,"lamine","kokprestas","Admin"]
[null,"agent","bureau","User"]
[null,"dorson",48893959,"Prog"]

{"sheet":"Orange Money","index":4,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","N° DE TELEPHONE","MONTANT DEPOT","MONTANT RETRAIT","REF DE TRANSACTION",{"$f":"SUM(C2:C92)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"MTN Money","index":5,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","N° DE TELEPHONE","MONTANT DEPOT","MONTANT RETRAIT","REF DE TRANSACTION",{"$f":"SUM(C2:C89)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Moov Money","index":6,"n_rows":1,"n_cols":22,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","N° DE TELEPHONE","MONTANT DEPOT","MONTANT RETRAIT","REF DE TRANSACTION",{"$f":"SUM(C2:C81)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Wari","index":7,"n_rows":6,"n_cols":52,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,0,6],[0,7,0,12]]}
[null,"INFORMATION SUR L'EXPEDITEUR",null,null,null,null,null,"INFORMATION SUR LE BENEFICIAIRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["DATE","NOM","PRENOMS","TYPE DE PIECE","N° DE PIECE","CONTACT","ADRESSE","NOM","PRENOMS","TYPE DE PIECE","N° DE PIECE","CONTACT","ADRESSE","MONTANT ENVOI","MONTANT RETRAIT","REF DE TRANSACTION",{"$f":"SUM(N3:N89)","v":25000}]
[]
[]
["2019-06-24",null,null,null,null,null,null,null,null,null,null,null,null,null,15000]
["2019-06-24",null,null,"Attestation d'identité",null,null,null,null,null,null,null,null,null,25000]

{"sheet":"UBA achat","index":8,"n_rows":4,"n_cols":25,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["DATE","NOM","PRENOMS","CONTACT","TYPE DE PIECE","N° PIECE","ID DE LA CARTE","NOMBRE",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,null,null,1]

{"sheet":"UBA rechargement","index":9,"n_rows":5,"n_cols":26,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["DATE","NOM","PRENOMS","CONTACT","ID DE LA CARTE","MONTANT","NOMBRE",{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[null,null,null,null,null,null,1]

{"sheet":"Donnees approvis UBA achat","index":10,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Donnees approvis UBA recharg","index":11,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Donnees approvis Orange","index":12,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","MONTANT D'APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Donnees approvis MTN","index":13,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","MONTANT D'APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Donnees approvis WARI","index":14,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","MONTANT D'APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Donnees approvis Moov","index":15,"n_rows":1,"n_cols":26,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["DATE","MONTANT D'APPROVISIONNEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"donnees","index":16,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":true,"merged":[[7,16,7,17],[7,1,7,2],[7,4,7,5],[7,7,7,8],[7,10,7,11],[7,13,7,14]]}
[null,"Date"]
[null,{"$f":"TODAY()","v":"2020-02-16"}]
[]
[]
[]
[]
[]
[null,"ORANGE MONEY",null,null,"MTN MONEY",null,null,"MOOV MONEY",null,null,"WARI",null,null,"UBA achat",null,null,"UBA Rechargement"]
[null,"TOTAL DEPOT",{"$f":"SUM('Orange Money'!C2:C45)","v":0},null,"TOTAL DEPOT",{"$f":"SUM('MTN Money'!C2:C38)","v":0},null,"TOTAL DEPOT",{"$f":"SUM('Moov Money'!C2:C34)","v":0},null,"TOTAL ENVOI",{"$f":"SUM(Wari!N3:N15)","v":25000},null,"TOTAL VENDU",{"$f":"SUM('UBA achat'!H4:H19)","v":1},null,"TOTAL RECHARGE",{"$f":"SUM('UBA rechargement'!B4:B19)","v":0}]
[null,"TOTAL RETRAIT",{"$f":"SUM('Orange Money'!D2:D45)","v":0},null,"TOTAL RETRAIT",{"$f":"SUM('MTN Money'!D2:D38)","v":0},null,"TOTAL RETRAIT",{"$f":"SUM('Moov Money'!D2:D34)","v":0},null,"TOTAL RETRAIT",{"$f":"SUM(Wari!O3:O15)","v":15000}]
[null,"TOTAL EN CAISSE",{"$f":"(C13+C10)-C9","v":0},null,"TOTAL EN CAISSE",{"$f":"(F13+F10)-F9","v":0},null,"TOTAL EN CAISSE",{"$f":"(I13+I10)-I9","v":0},null,"TOTAL EN CAISSE",{"$f":"(L13+L10)-L9","v":-10000},null,"TOTAL RESTANT",{"$f":"O13-O9","v":-1},null,"TOTAL RESTANT",{"$f":"R13-R9","v":0}]
[]
[null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis Orange'!B2:B12)","v":0},null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis MTN'!B2:B13)","v":0},null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis Moov'!B2:B13)","v":0},null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis WARI'!B2:B18)","v":0},null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis UBA achat'!B2:B14)","v":0},null,"APPROVISIONNEMENT",{"$f":"SUM('Donnees approvis UBA recharg'!B2:B15)","v":0}]

{"sheet":"frais","index":17,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Frais","Montant"]
[null,{"$f":"IF(AND(499<C4,C4<5001),250,IF(AND(5000<C4,C4<10001),500,IF(AND(1000<C4,C4<25001),1250)))","v":250},4500]

{"sheet":"operation","index":18,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["typoperation","operat",null,"operationMTN",null,null,"operationMoov",null,null,"operationWari",null,null,"operationUBA"]
["Depot","Orange_depot",null,"Depot","MTN_depot",null,"Depot","Moov_depot",null,"Envoi","Wari_envoi",null,"Rechargement","UBA_recharg"]
["Retrait","Orange_retrait",null,"Retrait","MTN_retrait",null,"Retrait","Moov_retrait",null,"Retrait","Wari_retrait",null,"Achat","UBA_achat"]
[]
[]
[]
["typpiece"]
["C.N.I."]
["Attestation d'identité"]
["Passeport"]
["Autre …"]
[]
["virement"]
["Orange"]
["MTN"]
["Moov"]
["Wari"]
["UBA"]
["KOK Tunis"]