{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ACHAT","VENTE","STATISTIQUE","Feuil2"],"not_rendered":{"charts":0,"images":1,"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":"ACHAT","index":0,"n_rows":578,"n_cols":15,"rows_kept":578,"cut":false,"hidden":false,"merged":[[355,1,355,2],[355,4,355,5],[355,8,355,9],[355,11,355,12],[366,1,366,2],[366,4,366,5],[366,8,366,9],[366,11,366,12],[353,0,353,2],[353,3,353,4],[353,7,353,9],[353,10,353,11],[354,0,354,2],[354,3,354,4],[354,7,354,9],[354,10,354,11],[351,0,351,2],[351,3,351,5],[351,7,351,9],[351,10,351,12],[352,0,352,2],[352,3,352,4],[352,7,352,9],[352,10,352,11],[349,0,349,2],[349,3,349,5],[349,7,349,9],[349,10,349,12],[350,0,350,2],[350,3,350,5],[350,7,350,9],[350,10,350,12],[347,0,347,5],[347,7,347,12],[348,0,348,2],[348,3,348,5],[348,7,348,9],[348,10,348,12],[321,1,321,2],[321,4,321,5],[321,8,321,9],[321,11,321,12],[332,1,332,2],[332,4,332,5],[332,8,332,9],[332,11,332,12],[319,0,319,2],[319,3,319,4],[319,7,319,9],[319,10,319,11],[320,0,320,2],[320,3,320,4],[320,7,320,9],[320,10,320,11],[317,0,317,2],[317,3,317,5],[317,7,317,9],[317,10,317,12],[318,0,318,2],[318,3,318,4],[318,7,318,9],[318,10,318,11],[315,0,315,2],[315,3,315,5],[315,7,315,9],[315,10,315,12],[316,0,316,2],[316,3,316,5],[316,7,316,9],[316,10,316,12],[313,0,313,5],[313,7,313,12],[314,0,314,2],[314,3,314,5],[314,7,314,9],[314,10,314,12],[287,1,287,2],[287,4,287,5],[287,8,287,9],[287,11,287,12],[298,1,298,2],[298,4,298,5],[298,8,298,9],[298,11,298,12],[285,0,285,2],[285,3,285,4],[285,7,285,9],[285,10,285,11],[286,0,286,2],[286,3,286,4],[286,7,286,9],[286,10,286,11],[283,0,283,2],[283,3,283,5],[283,7,283,9],[283,10,283,12],[284,0,284,2],[284,3,284,4],[284,7,284,9],[284,10,284,11],[281,0,281,2],[281,3,281,5],[281,7,281,9],[281,10,281,12],[282,0,282,2],[282,3,282,5],[282,7,282,9],[282,10,282,12],[279,0,279,5],[279,7,279,12],[280,0,280,2],[280,3,280,5],[280,7,280,9],[280,10,280,12],[253,1,253,2],[253,4,253,5],[253,8,253,9],[253,11,253,12],[264,1,264,2],[264,4,264,5],[264,8,264,9],[264,11,264,12],[251,0,251,2],[251,3,251,4],[251,7,251,9],[251,10,251,11],[252,0,252,2],[252,3,252,4],[252,7,252,9],[252,10,252,11],[249,0,249,2],[249,3,249,5],[249,7,249,9],[249,10,249,12],[250,0,250,2],[250,3,250,4],[250,7,250,9],[250,10,250,11],[247,0,247,2],[247,3,247,5],[247,7,247,9],[247,10,247,12],[248,0,248,2],[248,3,248,5],[248,7,248,9],[248,10,248,12],[245,0,245,5],[245,7,245,12],[246,0,246,2],[246,3,246,5],[246,7,246,9],[246,10,246,12],[219,1,219,2],[219,4,219,5],[219,8,219,9],[219,11,219,12],[230,1,230,2],[230,4,230,5],[230,8,230,9],[230,11,230,12],[217,0,217,2],[217,3,217,4],[217,7,217,9],[217,10,217,11],[218,0,218,2],[218,3,218,4],[218,7,218,9],[218,10,218,11],[215,0,215,2],[215,3,215,5],[215,7,215,9],[215,10,215,12],[216,0,216,2],[216,3,216,4],[216,7,216,9],[216,10,216,11],[213,0,213,2],[213,3,213,5],[213,7,213,9],[213,10,213,12],[214,0,214,2],[214,3,214,5],[214,7,214,9],[214,10,214,12],[211,0,211,5],[211,7,211,12],[212,0,212,2],[212,3,212,5],[212,7,212,9],[212,10,212,12],[185,1,185,2],[185,4,185,5],[185,8,185,9],[185,11,185,12],[196,1,196,2],[196,4,196,5],[196,8,196,9],[196,11,196,12],[183,0,183,2],[183,3,183,4],[183,7,183,9],[183,10,183,11],[184,0,184,2],[184,3,184,4],[184,7,184,9],[184,10,184,11],[181,0,181,2],[181,3,181,5],[181,7,181,9],[181,10,181,12],[182,0,182,2],[182,3,182,4],[182,7,182,9],[182,10,182,11],[179,0,179,2],[179,3,179,5],[179,7,179,9],[179,10,179,12],[180,0,180,2],[180,3,180,5],[180,7,180,9],[180,10,180,12],[177,0,177,5],[177,7,177,12],[178,0,178,2],[178,3,178,5],[178,7,178,9],[178,10,178,12],[151,1,151,2],[151,4,151,5],[151,8,151,9],[151,11,151,12],[162,1,162,2],[162,4,162,5],[162,8,162,9],[162,11,162,12],[149,0,149,2],[149,3,149,4],[149,7,149,9],[149,10,149,11],[150,0,150,2],[150,3,150,4],[150,7,150,9],[150,10,150,11],[147,0,147,2],[147,3,147,5],[147,7,147,9],[147,10,147,12],[148,0,148,2],[148,3,148,4],[148,7,148,9],[148,10,148,11],[145,0,145,2],[145,3,145,5],[145,7,145,9],[145,10,145,12],[146,0,146,2],[146,3,146,5],[146,7,146,9],[146,10,146,12],[143,0,143,5],[143,7,143,12],[144,0,144,2],[144,3,144,5],[144,7,144,9],[144,10,144,12],[117,1,117,2],[117,4,117,5],[117,8,117,9],[117,11,117,12],[128,1,128,2],[128,4,128,5],[128,8,128,9],[128,11,128,12],[115,0,115,2],[115,3,115,4],[115,7,115,9],[115,10,115,11],[116,0,116,2],[116,3,116,4],[116,7,116,9],[116,10,116,11],[113,0,113,2],[113,3,113,5],[113,7,113,9],[113,10,113,12],[114,0,114,2],[114,3,114,4],[114,7,114,9],[114,10,114,11],[111,0,111,2],[111,3,111,5],[111,7,111,9],[111,10,111,12],[112,0,112,2],[112,3,112,5],[112,7,112,9],[112,10,112,12],[109,0,109,5],[109,7,109,12],[110,0,110,2],[110,3,110,5],[110,7,110,9],[110,10,110,12],[83,1,83,2],[83,4,83,5],[83,8,83,9],[83,11,83,12],[94,1,94,2],[94,4,94,5],[94,8,94,9],[94,11,94,12],[81,0,81,2],[81,3,81,4],[81,7,81,9],[81,10,81,11],[82,0,82,2],[82,3,82,4],[82,7,82,9],[82,10,82,11],[79,0,79,2],[79,3,79,5],[79,7,79,9],[79,10,79,12],[80,0,80,2],[80,3,80,4],[80,7,80,9],[80,10,80,11],[77,0,77,2],[77,3,77,5],[77,7,77,9],[77,10,77,12],[78,0,78,2],[78,3,78,5],[78,7,78,9],[78,10,78,12],[75,0,75,5],[75,7,75,12],[76,0,76,2],[76,3,76,5],[76,7,76,9],[76,10,76,12],[42,10,42,12],[42,7,42,9],[42,3,42,5],[42,0,42,2],[48,7,48,9],[48,0,48,2],[47,7,47,9],[47,0,47,2],[48,10,48,11],[48,3,48,4],[47,10,47,11],[47,3,47,4],[46,10,46,11],[46,7,46,9],[46,3,46,4],[46,0,46,2],[49,11,49,12],[49,8,49,9],[41,7,41,12],[41,0,41,5],[45,10,45,12],[45,7,45,9],[45,3,45,5],[45,0,45,2],[44,10,44,12],[44,7,44,9],[44,3,44,5],[44,0,44,2],[43,10,43,12],[43,7,43,9],[43,3,43,5],[43,0,43,2],[49,4,49,5],[49,1,49,2],[60,1,60,2],[60,4,60,5],[60,8,60,9],[60,11,60,12],[13,0,13,2],[9,0,9,2],[9,3,9,5],[9,10,9,12],[10,3,10,5],[10,10,10,12],[10,0,10,2],[13,3,13,4],[13,10,13,11],[13,7,13,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[11,10,11,12],[12,3,12,4],[12,10,12,11],[12,7,12,9],[11,3,11,5],[11,0,11,2],[7,0,7,5],[7,7,7,12],[8,3,8,5],[8,10,8,12],[8,7,8,9],[8,0,8,2],[12,0,12,2],[26,1,26,2],[14,0,14,2],[26,4,26,5],[26,8,26,9],[26,11,26,12],[14,3,14,4],[14,7,14,9],[14,10,14,11],[15,1,15,2],[15,4,15,5],[15,8,15,9],[15,11,15,12],[381,0,381,5],[381,7,381,12],[382,0,382,2],[382,3,382,5],[382,7,382,9],[382,10,382,12],[383,0,383,2],[383,3,383,5],[383,7,383,9],[383,10,383,12],[384,0,384,2],[384,3,384,5],[384,7,384,9],[384,10,384,12],[385,0,385,2],[385,3,385,5],[385,7,385,9],[385,10,385,12],[386,0,386,2],[386,3,386,4],[386,7,386,9],[386,10,386,11],[387,0,387,2],[387,3,387,4],[387,7,387,9],[387,10,387,11],[388,0,388,2],[388,3,388,4],[388,7,388,9],[388,10,388,11],[389,1,389,2],[389,4,389,5],[389,8,389,9],[389,11,389,12],[400,1,400,2],[400,4,400,5],[400,8,400,9],[400,11,400,12],[415,0,415,5],[415,7,415,12],[416,0,416,2],[416,3,416,5],[416,7,416,9],[416,10,416,12],[417,0,417,2],[417,3,417,5],[417,7,417,9],[417,10,417,12],[418,0,418,2],[418,3,418,5],[418,7,418,9],[418,10,418,12],[419,0,419,2],[419,3,419,5],[419,7,419,9],[419,10,419,12],[420,0,420,2],[420,3,420,4],[420,7,420,9],[420,10,420,11],[421,0,421,2],[421,3,421,4],[421,7,421,9],[421,10,421,11],[422,0,422,2],[422,3,422,4],[422,7,422,9],[422,10,422,11],[423,1,423,2],[423,4,423,5],[423,8,423,9],[423,11,423,12],[434,1,434,2],[434,4,434,5],[434,8,434,9],[434,11,434,12],[449,0,449,5],[449,7,449,12],[450,0,450,2],[450,3,450,5],[450,7,450,9],[450,10,450,12],[451,0,451,2],[451,3,451,5],[451,7,451,9],[451,10,451,12],[452,0,452,2],[452,3,452,5],[452,7,452,9],[452,10,452,12],[453,0,453,2],[453,3,453,5],[453,7,453,9],[453,10,453,12],[454,0,454,2],[454,3,454,4],[454,7,454,9],[454,10,454,11],[455,0,455,2],[455,3,455,4],[455,7,455,9],[455,10,455,11],[456,0,456,2],[456,3,456,4],[456,7,456,9],[456,10,456,11],[457,1,457,2],[457,4,457,5],[457,8,457,9],[457,11,457,12],[468,1,468,2],[468,4,468,5],[468,8,468,9],[468,11,468,12],[483,0,483,5],[483,7,483,12],[484,0,484,2],[484,3,484,5],[484,7,484,9],[484,10,484,12],[485,0,485,2],[485,3,485,5],[485,7,485,9],[485,10,485,12],[486,0,486,2],[486,3,486,5],[486,7,486,9],[486,10,486,12],[487,0,487,2],[487,3,487,5],[487,7,487,9],[487,10,487,12],[488,0,488,2],[488,3,488,4],[488,7,488,9],[488,10,488,11],[489,0,489,2],[489,3,489,4],[489,7,489,9],[489,10,489,11],[490,0,490,2],[490,3,490,4],[490,7,490,9],[490,10,490,11],[491,1,491,2],[491,4,491,5],[491,8,491,9],[491,11,491,12],[502,1,502,2],[502,4,502,5],[502,8,502,9],[502,11,502,12],[517,0,517,5],[517,7,517,12],[518,0,518,2],[518,3,518,5],[518,7,518,9],[518,10,518,12],[519,0,519,2],[519,3,519,5],[519,7,519,9],[519,10,519,12],[520,0,520,2],[520,3,520,5],[520,7,520,9],[520,10,520,12],[521,0,521,2],[521,3,521,5],[521,7,521,9],[521,10,521,12],[522,0,522,2],[522,3,522,4],[522,7,522,9],[522,10,522,11],[523,0,523,2],[523,3,523,4],[523,7,523,9],[523,10,523,11],[524,0,524,2],[524,3,524,4],[524,7,524,9],[524,10,524,11],[525,1,525,2],[525,4,525,5],[525,8,525,9],[525,11,525,12],[536,1,536,2],[536,4,536,5],[536,8,536,9],[536,11,536,12],[551,0,551,5],[551,7,551,12],[552,0,552,2],[552,3,552,5],[552,7,552,9],[552,10,552,12],[553,0,553,2],[553,3,553,5],[553,7,553,9],[553,10,553,12],[554,0,554,2],[554,3,554,5],[554,7,554,9],[554,10,554,12],[555,0,555,2],[555,3,555,5],[555,7,555,9],[555,10,555,12],[556,0,556,2],[556,3,556,4],[556,7,556,9],[556,10,556,11],[557,0,557,2],[557,3,557,4],[557,7,557,9],[557,10,557,11],[558,0,558,2],[558,3,558,4],[558,7,558,9],[558,10,558,11],[559,1,559,2],[559,4,559,5],[559,8,559,9],[559,11,559,12],[570,1,570,2],[570,4,570,5],[570,8,570,9],[570,11,570,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-1","v":"2015-08-17"}]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,1,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C5","v":1},null,null,null,null,{"$f":"IF(IF(Plage=$O$1,INDIRECT(ADDRESS(ROW(Plage)+14,4)),0)<>0,MATCH(IF(Plage=$O$1,INDIRECT(ADDRESS(ROW(Plage)+14,4)),0),STATISTIQUE!$A$1:$A$20,0),0)","v":0}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F6","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"NZAOU",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D9=\"\",\"\",D9)","v":"NZAOU"}]
[" PRENOM (S):",null,null,"KELLY",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D10=\"\",\"\",D10)","v":"KELLY"}]
["ADRESSE et TELEPHONE:",null,null,"06 401 74 19",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 401 74 19"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D13=\"\",\"\",D13)","v":"FRANCE"}]
["Motif:",null,null,"TOURISME",null,null,null,"Motif:",null,null,{"$f":"IF(D14=\"\",\"\",D14)","v":"TOURISME"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",650,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B16=\"\",\"\",B16)","v":650},null,"TAUX 2",{"$f":"IF(E16=\"\",\"\",E16)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B21*A21","v":0},100,null,{"$f":"E21*D21","v":0},null,10000,{"$f":"IF(B21=\"\",\"\",B21)","v":""},{"$f":"IF(C21=\"\",\"\",C21)","v":0},100,{"$f":"IF(E21=\"\",\"\",E21)","v":""},{"$f":"IF(F21=\"\",\"\",F21)","v":0}]
[5000,null,{"$f":"B22*A22","v":0},50,null,{"$f":"E22*D22","v":0},null,5000,{"$f":"IF(B22=\"\",\"\",B22)","v":""},{"$f":"IF(C22=\"\",\"\",C22)","v":0},50,{"$f":"IF(E22=\"\",\"\",E22)","v":""},{"$f":"IF(F22=\"\",\"\",F22)","v":0}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D15=\"CFAO\",(C21+C22+C23+C24+C25),IF(D15=\"DOLLARS\",(F21+F22+F23+F24+F25+F26),IF(D15=\"EURO\",(C25+C26+F21+F22+F23+F24+F25),IF(D15=\"LIVRE STERLING\",(F22+F23+F24+F25),\"\"))))","v":20},null,"Net à Payer",{"$f":"IF(D15=\"CFAO\",B27,IF(D15=\"DOLLARS\",(((F21+F22)*E16)+((F23+F24+F25+F26)*B16)),IF(D15=\"EURO\",(((C25+C26+F21+F22)*E16)+((F23+F24+F25)*B16)),IF(D15=\"LIVRE STERLING\",((F22*E16)+((F23+F24+F25)*B16)),\"\"))))","v":13000},null,null,"Valeur Total",{"$f":"IF(B27=\"\",\"\",B27)","v":20},null,"Net à Payer",{"$f":"IF(E27=\"\",\"\",E27)","v":13000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,2,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C39","v":2}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F40","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"LOUNGOUALA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D43=\"\",\"\",D43)","v":"LOUNGOUALA"}]
[" PRENOM (S):",null,null,"BERTIN",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D44=\"\",\"\",D44)","v":"BERTIN"}]
["ADRESSE et TELEPHONE:",null,null,"06 628 98 09",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 628 98 09"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D47=\"\",\"\",D47)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D48=\"\",\"\",D48)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B50=\"\",\"\",B50)","v":""},null,"TAUX 2",{"$f":"IF(E50=\"\",\"\",E50)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B55*A55","v":0},100,null,{"$f":"E55*D55","v":0},null,10000,{"$f":"IF(B55=\"\",\"\",B55)","v":""},{"$f":"IF(C55=\"\",\"\",C55)","v":0},100,{"$f":"IF(E55=\"\",\"\",E55)","v":""},{"$f":"IF(F55=\"\",\"\",F55)","v":0}]
[5000,null,{"$f":"B56*A56","v":0},50,2,{"$f":"E56*D56","v":100},null,5000,{"$f":"IF(B56=\"\",\"\",B56)","v":""},{"$f":"IF(C56=\"\",\"\",C56)","v":0},50,{"$f":"IF(E56=\"\",\"\",E56)","v":2},{"$f":"IF(F56=\"\",\"\",F56)","v":100}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D49=\"CFAO\",(C55+C56+C57+C58+C59),IF(D49=\"DOLLARS\",(F55+F56+F57+F58+F59+F60),IF(D49=\"EURO\",(C59+C60+F55+F56+F57+F58+F59),IF(D49=\"LIVRE STERLING\",(F56+F57+F58+F59),\"\"))))","v":100},null,"Net à Payer",{"$f":"IF(D49=\"CFAO\",B61,IF(D49=\"DOLLARS\",(((F55+F56)*E50)+((F57+F58+F59+F60)*B50)),IF(D49=\"EURO\",(((C59+C60+F55+F56)*E50)+((F57+F58+F59)*B50)),IF(D49=\"LIVRE STERLING\",((F56*E50)+((F57+F58+F59)*B50)),\"\"))))","v":65600},null,null,"Valeur Totale",{"$f":"IF(B61=\"\",\"\",B61)","v":100},null,"Net à Payer",{"$f":"IF(E61=\"\",\"\",E61)","v":65600}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,3,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C73","v":3}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F74","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"DIOP",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D77=\"\",\"\",D77)","v":"DIOP"}]
[" PRENOM (S):",null,null,"KALIFA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D78=\"\",\"\",D78)","v":"KALIFA"}]
["ADRESSE et TELEPHONE:",null,null,null,null,null,null,"ADRESSE et TELEPHONE:",null,null,""]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"ANGLETERRE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D81=\"\",\"\",D81)","v":"ANGLETERRE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D82=\"\",\"\",D82)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B84=\"\",\"\",B84)","v":""},null,"TAUX 2",{"$f":"IF(E84=\"\",\"\",E84)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B89*A89","v":0},100,2,{"$f":"E89*D89","v":200},null,10000,{"$f":"IF(B89=\"\",\"\",B89)","v":""},{"$f":"IF(C89=\"\",\"\",C89)","v":0},100,{"$f":"IF(E89=\"\",\"\",E89)","v":2},{"$f":"IF(F89=\"\",\"\",F89)","v":200}]
[5000,null,{"$f":"B90*A90","v":0},50,null,{"$f":"E90*D90","v":0},null,5000,{"$f":"IF(B90=\"\",\"\",B90)","v":""},{"$f":"IF(C90=\"\",\"\",C90)","v":0},50,{"$f":"IF(E90=\"\",\"\",E90)","v":""},{"$f":"IF(F90=\"\",\"\",F90)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D83=\"CFAO\",(C89+C90+C91+C92+C93),IF(D83=\"DOLLARS\",(F89+F90+F91+F92+F93+F94),IF(D83=\"EURO\",(C93+C94+F89+F90+F91+F92+F93),IF(D83=\"LIVRE STERLING\",(F90+F91+F92+F93),\"\"))))","v":200},null,"Net à Payer",{"$f":"IF(D83=\"CFAO\",B95,IF(D83=\"DOLLARS\",(((F89+F90)*E84)+((F91+F92+F93+F94)*B84)),IF(D83=\"EURO\",(((C93+C94+F89+F90)*E84)+((F91+F92+F93)*B84)),IF(D83=\"LIVRE STERLING\",((F90*E84)+((F91+F92+F93)*B84)),\"\"))))","v":131200},null,null,"Valeur Totale",{"$f":"IF(B95=\"\",\"\",B95)","v":200},null,"Net à Payer",{"$f":"IF(E95=\"\",\"\",E95)","v":131200}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,4,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C107","v":4}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F108","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"IBOUANGA DOUKEBA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D111=\"\",\"\",D111)","v":"IBOUANGA DOUKEBA"}]
[" PRENOM (S):",null,null,"CHRISTIAN",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D112=\"\",\"\",D112)","v":"CHRISTIAN"}]
["ADRESSE et TELEPHONE:",null,null,"06 970 33 43",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 970 33 43"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D115=\"\",\"\",D115)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D116=\"\",\"\",D116)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",650,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B118=\"\",\"\",B118)","v":650},null,"TAUX 2",{"$f":"IF(E118=\"\",\"\",E118)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B123*A123","v":0},100,null,{"$f":"E123*D123","v":0},null,10000,{"$f":"IF(B123=\"\",\"\",B123)","v":""},{"$f":"IF(C123=\"\",\"\",C123)","v":0},100,{"$f":"IF(E123=\"\",\"\",E123)","v":""},{"$f":"IF(F123=\"\",\"\",F123)","v":0}]
[5000,null,{"$f":"B124*A124","v":0},50,null,{"$f":"E124*D124","v":0},null,5000,{"$f":"IF(B124=\"\",\"\",B124)","v":""},{"$f":"IF(C124=\"\",\"\",C124)","v":0},50,{"$f":"IF(E124=\"\",\"\",E124)","v":""},{"$f":"IF(F124=\"\",\"\",F124)","v":0}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D117=\"CFAO\",(C123+C124+C125+C126+C127),IF(D117=\"DOLLARS\",(F123+F124+F125+F126+F127+F128),IF(D117=\"EURO\",(C127+C128+F123+F124+F125+F126+F127),IF(D117=\"LIVRE STERLING\",(F124+F125+F126+F127),\"\"))))","v":20},null,"Net à Payer",{"$f":"IF(D117=\"CFAO\",B129,IF(D117=\"DOLLARS\",(((F123+F124)*E118)+((F125+F126+F127+F128)*B118)),IF(D117=\"EURO\",(((C127+C128+F123+F124)*E118)+((F125+F126+F127)*B118)),IF(D117=\"LIVRE STERLING\",((F124*E118)+((F125+F126+F127)*B118)),\"\"))))","v":13000},null,null,"Valeur Totale",{"$f":"IF(B129=\"\",\"\",B129)","v":20},null,"Net à Payer",{"$f":"IF(E129=\"\",\"\",E129)","v":13000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,5,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C141","v":5}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F142","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"BALENDA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D145=\"\",\"\",D145)","v":"BALENDA"}]
[" PRENOM (S):",null,null,"JEAN PAUL G",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D146=\"\",\"\",D146)","v":"JEAN PAUL G"}]
["ADRESSE et TELEPHONE:",null,null,"TCHIMBAMBA / 05 567 67 04",null,null,null,"ADRESSE et TELEPHONE:",null,null,"TCHIMBAMBA / 05 567 67 04"]
["N° PASSEPORT:",null,null,"14DL31245",null,null,null,"N° PASSEPORT:",null,null,"14DL31245"]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D149=\"\",\"\",D149)","v":"FRANCE"}]
["Motif:",null,null,"Etudes",null,null,null,"Motif:",null,null,{"$f":"IF(D150=\"\",\"\",D150)","v":"Etudes"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B152=\"\",\"\",B152)","v":""},null,"TAUX 2",{"$f":"IF(E152=\"\",\"\",E152)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B157*A157","v":0},100,2,{"$f":"E157*D157","v":200},null,10000,{"$f":"IF(B157=\"\",\"\",B157)","v":""},{"$f":"IF(C157=\"\",\"\",C157)","v":0},100,{"$f":"IF(E157=\"\",\"\",E157)","v":2},{"$f":"IF(F157=\"\",\"\",F157)","v":200}]
[5000,null,{"$f":"B158*A158","v":0},50,null,{"$f":"E158*D158","v":0},null,5000,{"$f":"IF(B158=\"\",\"\",B158)","v":""},{"$f":"IF(C158=\"\",\"\",C158)","v":0},50,{"$f":"IF(E158=\"\",\"\",E158)","v":""},{"$f":"IF(F158=\"\",\"\",F158)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,1,500,5,null,0,null,500,1,500,5,"",0]
[200,2,400,1,null,0,null,200,2,400,1,"",0]
["Valeur Totale",{"$f":"IF(D151=\"CFAO\",(C157+C158+C159+C160+C161),IF(D151=\"DOLLARS\",(F157+F158+F159+F160+F161+F162),IF(D151=\"EURO\",(C161+C162+F157+F158+F159+F160+F161),IF(D151=\"LIVRE STERLING\",(F158+F159+F160+F161),\"\"))))","v":1100},null,"Net à Payer",{"$f":"IF(D151=\"CFAO\",B163,IF(D151=\"DOLLARS\",(((F157+F158)*E152)+((F159+F160+F161+F162)*B152)),IF(D151=\"EURO\",(((C161+C162+F157+F158)*E152)+((F159+F160+F161)*B152)),IF(D151=\"LIVRE STERLING\",((F158*E152)+((F159+F160+F161)*B152)),\"\"))))","v":721600},null,null,"Valeur Totale",{"$f":"IF(B163=\"\",\"\",B163)","v":1100},null,"Net à Payer",{"$f":"IF(E163=\"\",\"\",E163)","v":721600}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,6,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C175","v":6}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F176","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"LUDOVIC",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D179=\"\",\"\",D179)","v":"LUDOVIC"}]
[" PRENOM (S):",null,null,"MALEKA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D180=\"\",\"\",D180)","v":"MALEKA"}]
["ADRESSE et TELEPHONE:",null,null,"05 302 06 73",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 302 06 73"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D183=\"\",\"\",D183)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D184=\"\",\"\",D184)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",650,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B186=\"\",\"\",B186)","v":650},null,"TAUX 2",{"$f":"IF(E186=\"\",\"\",E186)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B191*A191","v":0},100,null,{"$f":"E191*D191","v":0},null,10000,{"$f":"IF(B191=\"\",\"\",B191)","v":""},{"$f":"IF(C191=\"\",\"\",C191)","v":0},100,{"$f":"IF(E191=\"\",\"\",E191)","v":""},{"$f":"IF(F191=\"\",\"\",F191)","v":0}]
[5000,null,{"$f":"B192*A192","v":0},50,null,{"$f":"E192*D192","v":0},null,5000,{"$f":"IF(B192=\"\",\"\",B192)","v":""},{"$f":"IF(C192=\"\",\"\",C192)","v":0},50,{"$f":"IF(E192=\"\",\"\",E192)","v":""},{"$f":"IF(F192=\"\",\"\",F192)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,1,10,null,1000,"",0,10,1,10]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D185=\"CFAO\",(C191+C192+C193+C194+C195),IF(D185=\"DOLLARS\",(F191+F192+F193+F194+F195+F196),IF(D185=\"EURO\",(C195+C196+F191+F192+F193+F194+F195),IF(D185=\"LIVRE STERLING\",(F192+F193+F194+F195),\"\"))))","v":10},null,"Net à Payer",{"$f":"IF(D185=\"CFAO\",B197,IF(D185=\"DOLLARS\",(((F191+F192)*E186)+((F193+F194+F195+F196)*B186)),IF(D185=\"EURO\",(((C195+C196+F191+F192)*E186)+((F193+F194+F195)*B186)),IF(D185=\"LIVRE STERLING\",((F192*E186)+((F193+F194+F195)*B186)),\"\"))))","v":6500},null,null,"Valeur Totale",{"$f":"IF(B197=\"\",\"\",B197)","v":10},null,"Net à Payer",{"$f":"IF(E197=\"\",\"\",E197)","v":6500}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,7,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C209","v":7}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F210","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"MBOUNGOU",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D213=\"\",\"\",D213)","v":"MBOUNGOU"}]
[" PRENOM (S):",null,null,"MAKANGA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D214=\"\",\"\",D214)","v":"MAKANGA"}]
["ADRESSE et TELEPHONE:",null,null,"06 441 32 00",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 441 32 00"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D217=\"\",\"\",D217)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D218=\"\",\"\",D218)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",650,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B220=\"\",\"\",B220)","v":650},null,"TAUX 2",{"$f":"IF(E220=\"\",\"\",E220)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B225*A225","v":0},100,null,{"$f":"E225*D225","v":0},null,10000,{"$f":"IF(B225=\"\",\"\",B225)","v":""},{"$f":"IF(C225=\"\",\"\",C225)","v":0},100,{"$f":"IF(E225=\"\",\"\",E225)","v":""},{"$f":"IF(F225=\"\",\"\",F225)","v":0}]
[5000,null,{"$f":"B226*A226","v":0},50,null,{"$f":"E226*D226","v":0},null,5000,{"$f":"IF(B226=\"\",\"\",B226)","v":""},{"$f":"IF(C226=\"\",\"\",C226)","v":0},50,{"$f":"IF(E226=\"\",\"\",E226)","v":""},{"$f":"IF(F226=\"\",\"\",F226)","v":0}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D219=\"CFAO\",(C225+C226+C227+C228+C229),IF(D219=\"DOLLARS\",(F225+F226+F227+F228+F229+F230),IF(D219=\"EURO\",(C229+C230+F225+F226+F227+F228+F229),IF(D219=\"LIVRE STERLING\",(F226+F227+F228+F229),\"\"))))","v":20},null,"Net à Payer",{"$f":"IF(D219=\"CFAO\",B231,IF(D219=\"DOLLARS\",(((F225+F226)*E220)+((F227+F228+F229+F230)*B220)),IF(D219=\"EURO\",(((C229+C230+F225+F226)*E220)+((F227+F228+F229)*B220)),IF(D219=\"LIVRE STERLING\",((F226*E220)+((F227+F228+F229)*B220)),\"\"))))","v":13000},null,null,"Valeur Totale",{"$f":"IF(B231=\"\",\"\",B231)","v":20},null,"Net à Payer",{"$f":"IF(E231=\"\",\"\",E231)","v":13000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,8,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C243","v":8}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F244","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"ZAKETE",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D247=\"\",\"\",D247)","v":"ZAKETE"}]
[" PRENOM (S):",null,null,"VICTOIRE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D248=\"\",\"\",D248)","v":"VICTOIRE"}]
["ADRESSE et TELEPHONE:",null,null,"06 996 86 25",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 996 86 25"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D251=\"\",\"\",D251)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D252=\"\",\"\",D252)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B254=\"\",\"\",B254)","v":""},null,"TAUX 2",{"$f":"IF(E254=\"\",\"\",E254)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B259*A259","v":0},100,1,{"$f":"E259*D259","v":100},null,10000,{"$f":"IF(B259=\"\",\"\",B259)","v":""},{"$f":"IF(C259=\"\",\"\",C259)","v":0},100,{"$f":"IF(E259=\"\",\"\",E259)","v":1},{"$f":"IF(F259=\"\",\"\",F259)","v":100}]
[5000,null,{"$f":"B260*A260","v":0},50,1,{"$f":"E260*D260","v":50},null,5000,{"$f":"IF(B260=\"\",\"\",B260)","v":""},{"$f":"IF(C260=\"\",\"\",C260)","v":0},50,{"$f":"IF(E260=\"\",\"\",E260)","v":1},{"$f":"IF(F260=\"\",\"\",F260)","v":50}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D253=\"CFAO\",(C259+C260+C261+C262+C263),IF(D253=\"DOLLARS\",(F259+F260+F261+F262+F263+F264),IF(D253=\"EURO\",(C263+C264+F259+F260+F261+F262+F263),IF(D253=\"LIVRE STERLING\",(F260+F261+F262+F263),\"\"))))","v":150},null,"Net à Payer",{"$f":"IF(D253=\"CFAO\",B265,IF(D253=\"DOLLARS\",(((F259+F260)*E254)+((F261+F262+F263+F264)*B254)),IF(D253=\"EURO\",(((C263+C264+F259+F260)*E254)+((F261+F262+F263)*B254)),IF(D253=\"LIVRE STERLING\",((F260*E254)+((F261+F262+F263)*B254)),\"\"))))","v":98400},null,null,"Valeur Totale",{"$f":"IF(B265=\"\",\"\",B265)","v":150},null,"Net à Payer",{"$f":"IF(E265=\"\",\"\",E265)","v":98400}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,9,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C277","v":9}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F278","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"IBOUA ",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D281=\"\",\"\",D281)","v":"IBOUA "}]
[" PRENOM (S):",null,null,"PAMELA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D282=\"\",\"\",D282)","v":"PAMELA"}]
["ADRESSE et TELEPHONE:",null,null,"06 660 09 29",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 660 09 29"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D285=\"\",\"\",D285)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D286=\"\",\"\",D286)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B288=\"\",\"\",B288)","v":""},null,"TAUX 2",{"$f":"IF(E288=\"\",\"\",E288)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B293*A293","v":0},100,null,{"$f":"E293*D293","v":0},null,10000,{"$f":"IF(B293=\"\",\"\",B293)","v":""},{"$f":"IF(C293=\"\",\"\",C293)","v":0},100,{"$f":"IF(E293=\"\",\"\",E293)","v":""},{"$f":"IF(F293=\"\",\"\",F293)","v":0}]
[5000,null,{"$f":"B294*A294","v":0},50,2,{"$f":"E294*D294","v":100},null,5000,{"$f":"IF(B294=\"\",\"\",B294)","v":""},{"$f":"IF(C294=\"\",\"\",C294)","v":0},50,{"$f":"IF(E294=\"\",\"\",E294)","v":2},{"$f":"IF(F294=\"\",\"\",F294)","v":100}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D287=\"CFAO\",(C293+C294+C295+C296+C297),IF(D287=\"DOLLARS\",(F293+F294+F295+F296+F297+F298),IF(D287=\"EURO\",(C297+C298+F293+F294+F295+F296+F297),IF(D287=\"LIVRE STERLING\",(F294+F295+F296+F297),\"\"))))","v":100},null,"Net à Payer",{"$f":"IF(D287=\"CFAO\",B299,IF(D287=\"DOLLARS\",(((F293+F294)*E288)+((F295+F296+F297+F298)*B288)),IF(D287=\"EURO\",(((C297+C298+F293+F294)*E288)+((F295+F296+F297)*B288)),IF(D287=\"LIVRE STERLING\",((F294*E288)+((F295+F296+F297)*B288)),\"\"))))","v":65600},null,null,"Valeur Totale",{"$f":"IF(B299=\"\",\"\",B299)","v":100},null,"Net à Payer",{"$f":"IF(E299=\"\",\"\",E299)","v":65600}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,10,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C311","v":10}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F312","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"MIZIDIP",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D315=\"\",\"\",D315)","v":"MIZIDIP"}]
[" PRENOM (S):",null,null,"GIN G",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D316=\"\",\"\",D316)","v":"GIN G"}]
["ADRESSE et TELEPHONE:",null,null,"05 573 84 18",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 573 84 18"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D319=\"\",\"\",D319)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D320=\"\",\"\",D320)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B322=\"\",\"\",B322)","v":""},null,"TAUX 2",{"$f":"IF(E322=\"\",\"\",E322)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B327*A327","v":0},100,1,{"$f":"E327*D327","v":100},null,10000,{"$f":"IF(B327=\"\",\"\",B327)","v":""},{"$f":"IF(C327=\"\",\"\",C327)","v":0},100,{"$f":"IF(E327=\"\",\"\",E327)","v":1},{"$f":"IF(F327=\"\",\"\",F327)","v":100}]
[5000,null,{"$f":"B328*A328","v":0},50,null,{"$f":"E328*D328","v":0},null,5000,{"$f":"IF(B328=\"\",\"\",B328)","v":""},{"$f":"IF(C328=\"\",\"\",C328)","v":0},50,{"$f":"IF(E328=\"\",\"\",E328)","v":""},{"$f":"IF(F328=\"\",\"\",F328)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D321=\"CFAO\",(C327+C328+C329+C330+C331),IF(D321=\"DOLLARS\",(F327+F328+F329+F330+F331+F332),IF(D321=\"EURO\",(C331+C332+F327+F328+F329+F330+F331),IF(D321=\"LIVRE STERLING\",(F328+F329+F330+F331),\"\"))))","v":100},null,"Net à Payer",{"$f":"IF(D321=\"CFAO\",B333,IF(D321=\"DOLLARS\",(((F327+F328)*E322)+((F329+F330+F331+F332)*B322)),IF(D321=\"EURO\",(((C331+C332+F327+F328)*E322)+((F329+F330+F331)*B322)),IF(D321=\"LIVRE STERLING\",((F328*E322)+((F329+F330+F331)*B322)),\"\"))))","v":65600},null,null,"Valeur Totale",{"$f":"IF(B333=\"\",\"\",B333)","v":100},null,"Net à Payer",{"$f":"IF(E333=\"\",\"\",E333)","v":65600}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,11,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C345","v":11}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F346","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"FOPA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D349=\"\",\"\",D349)","v":"FOPA"}]
[" PRENOM (S):",null,null,"NADINE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D350=\"\",\"\",D350)","v":"NADINE"}]
["ADRESSE et TELEPHONE:",null,null,"04 001 42 99",null,null,null,"ADRESSE et TELEPHONE:",null,null,"04 001 42 99"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D353=\"\",\"\",D353)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D354=\"\",\"\",D354)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",null,null,"TAUX 2",656,null,null,"TAUX 1",{"$f":"IF(B356=\"\",\"\",B356)","v":""},null,"TAUX 2",{"$f":"IF(E356=\"\",\"\",E356)","v":656}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B361*A361","v":0},100,null,{"$f":"E361*D361","v":0},null,10000,{"$f":"IF(B361=\"\",\"\",B361)","v":""},{"$f":"IF(C361=\"\",\"\",C361)","v":0},100,{"$f":"IF(E361=\"\",\"\",E361)","v":""},{"$f":"IF(F361=\"\",\"\",F361)","v":0}]
[5000,null,{"$f":"B362*A362","v":0},50,1,{"$f":"E362*D362","v":50},null,5000,{"$f":"IF(B362=\"\",\"\",B362)","v":""},{"$f":"IF(C362=\"\",\"\",C362)","v":0},50,{"$f":"IF(E362=\"\",\"\",E362)","v":1},{"$f":"IF(F362=\"\",\"\",F362)","v":50}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D355=\"CFAO\",(C361+C362+C363+C364+C365),IF(D355=\"DOLLARS\",(F361+F362+F363+F364+F365+F366),IF(D355=\"EURO\",(C365+C366+F361+F362+F363+F364+F365),IF(D355=\"LIVRE STERLING\",(F362+F363+F364+F365),\"\"))))","v":50},null,"Net à Payer",{"$f":"IF(D355=\"CFAO\",B367,IF(D355=\"DOLLARS\",(((F361+F362)*E356)+((F363+F364+F365+F366)*B356)),IF(D355=\"EURO\",(((C365+C366+F361+F362)*E356)+((F363+F364+F365)*B356)),IF(D355=\"LIVRE STERLING\",((F362*E356)+((F363+F364+F365)*B356)),\"\"))))","v":32800},null,null,"Valeur Totale",{"$f":"IF(B367=\"\",\"\",B367)","v":50},null,"Net à Payer",{"$f":"IF(E367=\"\",\"\",E367)","v":32800}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,12,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C379","v":12}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F380","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"DIAMESSO",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D383=\"\",\"\",D383)","v":"DIAMESSO"}]
[" PRENOM (S):",null,null,"ORNELLA TANIA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D384=\"\",\"\",D384)","v":"ORNELLA TANIA"}]
["ADRESSE et TELEPHONE:",null,null,"01 049 57 27 ",null,null,null,"ADRESSE et TELEPHONE:",null,null,"01 049 57 27 "]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"FRANCE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D387=\"\",\"\",D387)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D388=\"\",\"\",D388)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX 1",650,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B390=\"\",\"\",B390)","v":650},null,"TAUX 2",{"$f":"IF(E390=\"\",\"\",E390)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B395*A395","v":0},100,null,{"$f":"E395*D395","v":0},null,10000,{"$f":"IF(B395=\"\",\"\",B395)","v":""},{"$f":"IF(C395=\"\",\"\",C395)","v":0},100,{"$f":"IF(E395=\"\",\"\",E395)","v":""},{"$f":"IF(F395=\"\",\"\",F395)","v":0}]
[5000,null,{"$f":"B396*A396","v":0},50,null,{"$f":"E396*D396","v":0},null,5000,{"$f":"IF(B396=\"\",\"\",B396)","v":""},{"$f":"IF(C396=\"\",\"\",C396)","v":0},50,{"$f":"IF(E396=\"\",\"\",E396)","v":""},{"$f":"IF(F396=\"\",\"\",F396)","v":0}]
[2000,null,0,20,2,40,null,2000,"",0,20,2,40]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D389=\"CFAO\",(C395+C396+C397+C398+C399),IF(D389=\"DOLLARS\",(F395+F396+F397+F398+F399+F400),IF(D389=\"EURO\",(C399+C400+F395+F396+F397+F398+F399),IF(D389=\"LIVRE STERLING\",(F396+F397+F398+F399),\"\"))))","v":40},null,"Net à Payer",{"$f":"IF(D389=\"CFAO\",B401,IF(D389=\"DOLLARS\",(((F395+F396)*E390)+((F397+F398+F399+F400)*B390)),IF(D389=\"EURO\",(((C399+C400+F395+F396)*E390)+((F397+F398+F399)*B390)),IF(D389=\"LIVRE STERLING\",((F396*E390)+((F397+F398+F399)*B390)),\"\"))))","v":26000},null,null,"Valeur Totale",{"$f":"IF(B401=\"\",\"\",B401)","v":40},null,"Net à Payer",{"$f":"IF(E401=\"\",\"\",E401)","v":26000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,13,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C413","v":13}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F414","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"KIBIADI",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D417=\"\",\"\",D417)","v":"KIBIADI"}]
[" PRENOM (S):",null,null,"MAX CHANCELVY",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D418=\"\",\"\",D418)","v":"MAX CHANCELVY"}]
["ADRESSE et TELEPHONE:",null,null,"06 930 43 23",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 930 43 23"]
["N° PASSEPORT:",null,null,"AO391464",null,null,null,"N° PASSEPORT:",null,null,"AO391464"]
["Provenance des devises:",null,null,"ANGLETERRE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D421=\"\",\"\",D421)","v":"ANGLETERRE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D422=\"\",\"\",D422)","v":"Tourisme"}]
["Devise:",null,null,"LIVRE STERLING",null,null,null,"Devise:",null,null,"LIVRE STERLING"]
["TAUX 1",600,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B424=\"\",\"\",B424)","v":600},null,"TAUX 2",{"$f":"IF(E424=\"\",\"\",E424)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B429*A429","v":0},100,null,{"$f":"E429*D429","v":0},null,10000,{"$f":"IF(B429=\"\",\"\",B429)","v":""},{"$f":"IF(C429=\"\",\"\",C429)","v":0},100,{"$f":"IF(E429=\"\",\"\",E429)","v":""},{"$f":"IF(F429=\"\",\"\",F429)","v":0}]
[5000,null,{"$f":"B430*A430","v":0},50,null,{"$f":"E430*D430","v":0},null,5000,{"$f":"IF(B430=\"\",\"\",B430)","v":""},{"$f":"IF(C430=\"\",\"\",C430)","v":0},50,{"$f":"IF(E430=\"\",\"\",E430)","v":""},{"$f":"IF(F430=\"\",\"\",F430)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,2,10,null,500,"",0,5,2,10]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D423=\"CFAO\",(C429+C430+C431+C432+C433),IF(D423=\"DOLLARS\",(F429+F430+F431+F432+F433+F434),IF(D423=\"EURO\",(C433+C434+F429+F430+F431+F432+F433),IF(D423=\"LIVRE STERLING\",(F430+F431+F432+F433),\"\"))))","v":10},null,"Net à Payer",{"$f":"IF(D423=\"CFAO\",B435,IF(D423=\"DOLLARS\",(((F429+F430)*E424)+((F431+F432+F433+F434)*B424)),IF(D423=\"EURO\",(((C433+C434+F429+F430)*E424)+((F431+F432+F433)*B424)),IF(D423=\"LIVRE STERLING\",((F430*E424)+((F431+F432+F433)*B424)),\"\"))))","v":6000},null,null,"Valeur Totale",{"$f":"IF(B435=\"\",\"\",B435)","v":10},null,"Net à Payer",{"$f":"IF(E435=\"\",\"\",E435)","v":6000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,14,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C447","v":14}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F448","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"ILAMA M ",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D451=\"\",\"\",D451)","v":"ILAMA M "}]
[" PRENOM (S):",null,null,"ARLY L ",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D452=\"\",\"\",D452)","v":"ARLY L "}]
["ADRESSE et TELEPHONE:",null,null,"05 644 83 31",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 644 83 31"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"ANGLETERRE",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D455=\"\",\"\",D455)","v":"ANGLETERRE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D456=\"\",\"\",D456)","v":"Tourisme"}]
["Devise:",null,null,"LIVRE STERLING",null,null,null,"Devise:",null,null,"LIVRE STERLING"]
["TAUX 1",600,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B458=\"\",\"\",B458)","v":600},null,"TAUX 2",{"$f":"IF(E458=\"\",\"\",E458)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B463*A463","v":0},100,null,{"$f":"E463*D463","v":0},null,10000,{"$f":"IF(B463=\"\",\"\",B463)","v":""},{"$f":"IF(C463=\"\",\"\",C463)","v":0},100,{"$f":"IF(E463=\"\",\"\",E463)","v":""},{"$f":"IF(F463=\"\",\"\",F463)","v":0}]
[5000,null,{"$f":"B464*A464","v":0},50,null,{"$f":"E464*D464","v":0},null,5000,{"$f":"IF(B464=\"\",\"\",B464)","v":""},{"$f":"IF(C464=\"\",\"\",C464)","v":0},50,{"$f":"IF(E464=\"\",\"\",E464)","v":""},{"$f":"IF(F464=\"\",\"\",F464)","v":0}]
[2000,null,0,20,3,60,null,2000,"",0,20,3,60]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,4,20,null,500,"",0,5,4,20]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D457=\"CFAO\",(C463+C464+C465+C466+C467),IF(D457=\"DOLLARS\",(F463+F464+F465+F466+F467+F468),IF(D457=\"EURO\",(C467+C468+F463+F464+F465+F466+F467),IF(D457=\"LIVRE STERLING\",(F464+F465+F466+F467),\"\"))))","v":80},null,"Net à Payer",{"$f":"IF(D457=\"CFAO\",B469,IF(D457=\"DOLLARS\",(((F463+F464)*E458)+((F465+F466+F467+F468)*B458)),IF(D457=\"EURO\",(((C467+C468+F463+F464)*E458)+((F465+F466+F467)*B458)),IF(D457=\"LIVRE STERLING\",((F464*E458)+((F465+F466+F467)*B458)),\"\"))))","v":48000},null,null,"Valeur Totale",{"$f":"IF(B469=\"\",\"\",B469)","v":80},null,"Net à Payer",{"$f":"IF(E469=\"\",\"\",E469)","v":48000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,15,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C481","v":15}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F482","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"NDOUR",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D485=\"\",\"\",D485)","v":"NDOUR"}]
[" PRENOM (S):",null,null,"OUSMANE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D486=\"\",\"\",D486)","v":"OUSMANE"}]
["ADRESSE et TELEPHONE:",null,null,"05 567 00 59",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 567 00 59"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"SÉNÉGAL",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D489=\"\",\"\",D489)","v":"SÉNÉGAL"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D490=\"\",\"\",D490)","v":"Tourisme"}]
["Devise:",null,null,"CFAO",null,null,null,"Devise:",null,null,"CFAO"]
["TAUX 1",null,null,"TAUX 2",1,null,null,"TAUX 1",{"$f":"IF(B492=\"\",\"\",B492)","v":""},null,"TAUX 2",{"$f":"IF(E492=\"\",\"\",E492)","v":1}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,10,{"$f":"B497*A497","v":100000},100,null,{"$f":"E497*D497","v":0},null,10000,{"$f":"IF(B497=\"\",\"\",B497)","v":10},{"$f":"IF(C497=\"\",\"\",C497)","v":100000},100,{"$f":"IF(E497=\"\",\"\",E497)","v":""},{"$f":"IF(F497=\"\",\"\",F497)","v":0}]
[5000,null,{"$f":"B498*A498","v":0},50,null,{"$f":"E498*D498","v":0},null,5000,{"$f":"IF(B498=\"\",\"\",B498)","v":""},{"$f":"IF(C498=\"\",\"\",C498)","v":0},50,{"$f":"IF(E498=\"\",\"\",E498)","v":""},{"$f":"IF(F498=\"\",\"\",F498)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D491=\"CFAO\",(C497+C498+C499+C500+C501),IF(D491=\"DOLLARS\",(F497+F498+F499+F500+F501+F502),IF(D491=\"EURO\",(C501+C502+F497+F498+F499+F500+F501),IF(D491=\"LIVRE STERLING\",(F498+F499+F500+F501),\"\"))))","v":100000},null,"Net à Payer",{"$f":"IF(D491=\"CFAO\",B503,IF(D491=\"DOLLARS\",(((F497+F498)*E492)+((F499+F500+F501+F502)*B492)),IF(D491=\"EURO\",(((C501+C502+F497+F498)*E492)+((F499+F500+F501)*B492)),IF(D491=\"LIVRE STERLING\",((F498*E492)+((F499+F500+F501)*B492)),\"\"))))","v":100000},null,null,"Valeur Totale",{"$f":"IF(B503=\"\",\"\",B503)","v":100000},null,"Net à Payer",{"$f":"IF(E503=\"\",\"\",E503)","v":100000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,16,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C515","v":16}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F516","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"BOUKAKA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D519=\"\",\"\",D519)","v":"BOUKAKA"}]
[" PRENOM (S):",null,null,"EMILE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D520=\"\",\"\",D520)","v":"EMILE"}]
["ADRESSE et TELEPHONE:",null,null,"06 498 62 44",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 498 62 44"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"ÉTATS-UNIS",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D523=\"\",\"\",D523)","v":"ÉTATS-UNIS"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D524=\"\",\"\",D524)","v":"Tourisme"}]
["Devise:",null,null,"DOLLARS",null,null,null,"Devise:",null,null,"DOLLARS"]
["TAUX 1",500,null,"TAUX 2",null,null,null,"TAUX 1",{"$f":"IF(B526=\"\",\"\",B526)","v":500},null,"TAUX 2",{"$f":"IF(E526=\"\",\"\",E526)","v":""}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B531*A531","v":0},100,null,{"$f":"E531*D531","v":0},null,10000,{"$f":"IF(B531=\"\",\"\",B531)","v":""},{"$f":"IF(C531=\"\",\"\",C531)","v":0},100,{"$f":"IF(E531=\"\",\"\",E531)","v":""},{"$f":"IF(F531=\"\",\"\",F531)","v":0}]
[5000,null,{"$f":"B532*A532","v":0},50,null,{"$f":"E532*D532","v":0},null,5000,{"$f":"IF(B532=\"\",\"\",B532)","v":""},{"$f":"IF(C532=\"\",\"\",C532)","v":0},50,{"$f":"IF(E532=\"\",\"\",E532)","v":""},{"$f":"IF(F532=\"\",\"\",F532)","v":0}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,2,10,null,500,"",0,5,2,10]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D525=\"CFAO\",(C531+C532+C533+C534+C535),IF(D525=\"DOLLARS\",(F531+F532+F533+F534+F535+F536),IF(D525=\"EURO\",(C535+C536+F531+F532+F533+F534+F535),IF(D525=\"LIVRE STERLING\",(F532+F533+F534+F535),\"\"))))","v":10},null,"Net à Payer",{"$f":"IF(D525=\"CFAO\",B537,IF(D525=\"DOLLARS\",(((F531+F532)*E526)+((F533+F534+F535+F536)*B526)),IF(D525=\"EURO\",(((C535+C536+F531+F532)*E526)+((F533+F534+F535)*B526)),IF(D525=\"LIVRE STERLING\",((F532*E526)+((F533+F534+F535)*B526)),\"\"))))","v":5000},null,null,"Valeur Totale",{"$f":"IF(B537=\"\",\"\",B537)","v":10},null,"Net à Payer",{"$f":"IF(E537=\"\",\"\",E537)","v":5000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU D'ACHAT N°",null,17,null,null,null,null,"BORDEREAU D'ACHAT N°",null,{"$f":"C549","v":17}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F550","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"KOFFI",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D553=\"\",\"\",D553)","v":"KOFFI"}]
[" PRENOM (S):",null,null,"HESSOU",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D554=\"\",\"\",D554)","v":"HESSOU"}]
["ADRESSE et TELEPHONE:",null,null,"06 400 40 94",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 400 40 94"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Provenance des devises:",null,null,"CONGO,RD",null,null,null,"Provenance des devises:",null,null,{"$f":"IF(D557=\"\",\"\",D557)","v":"CONGO,RD"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D558=\"\",\"\",D558)","v":"Tourisme"}]
["Devise:",null,null,"DOLLARS",null,null,null,"Devise:",null,null,"DOLLARS"]
["TAUX 1",null,null,"TAUX 2",600,null,null,"TAUX 1",{"$f":"IF(B560=\"\",\"\",B560)","v":""},null,"TAUX 2",{"$f":"IF(E560=\"\",\"\",E560)","v":600}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B565*A565","v":0},100,null,{"$f":"E565*D565","v":0},null,10000,{"$f":"IF(B565=\"\",\"\",B565)","v":""},{"$f":"IF(C565=\"\",\"\",C565)","v":0},100,{"$f":"IF(E565=\"\",\"\",E565)","v":""},{"$f":"IF(F565=\"\",\"\",F565)","v":0}]
[5000,null,{"$f":"B566*A566","v":0},50,1,{"$f":"E566*D566","v":50},null,5000,{"$f":"IF(B566=\"\",\"\",B566)","v":""},{"$f":"IF(C566=\"\",\"\",C566)","v":0},50,{"$f":"IF(E566=\"\",\"\",E566)","v":1},{"$f":"IF(F566=\"\",\"\",F566)","v":50}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D559=\"CFAO\",(C565+C566+C567+C568+C569),IF(D559=\"DOLLARS\",(F565+F566+F567+F568+F569+F570),IF(D559=\"EURO\",(C569+C570+F565+F566+F567+F568+F569),IF(D559=\"LIVRE STERLING\",(F566+F567+F568+F569),\"\"))))","v":50},null,"Net à Payer",{"$f":"IF(D559=\"CFAO\",B571,IF(D559=\"DOLLARS\",(((F565+F566)*E560)+((F567+F568+F569+F570)*B560)),IF(D559=\"EURO\",(((C569+C570+F565+F566)*E560)+((F567+F568+F569)*B560)),IF(D559=\"LIVRE STERLING\",((F566*E560)+((F567+F568+F569)*B560)),\"\"))))","v":30000},null,null,"Valeur Totale",{"$f":"IF(B571=\"\",\"\",B571)","v":50},null,"Net à Payer",{"$f":"IF(E571=\"\",\"\",E571)","v":30000}]
[]
["Caissier",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]

{"sheet":"VENTE","index":1,"n_rows":340,"n_cols":13,"rows_kept":340,"cut":false,"hidden":false,"merged":[[49,0,49,2],[49,3,49,5],[49,7,49,9],[49,10,49,12],[60,1,60,2],[60,4,60,5],[60,8,60,9],[60,11,60,12],[46,0,46,2],[46,3,46,4],[46,7,46,9],[46,10,46,11],[47,0,47,2],[47,3,47,4],[47,7,47,9],[47,10,47,11],[48,0,48,2],[48,3,48,4],[48,7,48,9],[48,10,48,11],[43,0,43,2],[43,3,43,5],[43,7,43,9],[43,10,43,12],[44,0,44,2],[44,3,44,5],[44,7,44,9],[44,10,44,12],[45,0,45,2],[45,3,45,5],[45,7,45,9],[45,10,45,12],[26,1,26,2],[26,4,26,5],[26,8,26,9],[26,11,26,12],[15,3,15,5],[15,0,15,2],[41,0,41,5],[41,7,41,12],[42,0,42,2],[42,3,42,5],[42,7,42,9],[42,10,42,12],[13,0,13,2],[13,3,13,4],[13,7,13,9],[13,10,13,11],[14,0,14,2],[14,3,14,4],[14,7,14,9],[14,10,14,11],[15,7,15,9],[15,10,15,12],[10,0,10,2],[10,3,10,5],[10,7,10,9],[10,10,10,12],[11,0,11,2],[11,3,11,5],[11,7,11,9],[11,10,11,12],[12,0,12,2],[12,3,12,4],[12,7,12,9],[12,10,12,11],[7,0,7,5],[7,7,7,12],[8,0,8,2],[8,3,8,5],[8,7,8,9],[8,10,8,12],[9,0,9,2],[9,3,9,5],[9,7,9,9],[9,10,9,12],[77,0,77,2],[77,3,77,5],[77,7,77,9],[77,10,77,12],[78,0,78,2],[78,3,78,5],[78,7,78,9],[78,10,78,12],[75,0,75,5],[75,7,75,12],[76,0,76,2],[76,3,76,5],[76,7,76,9],[76,10,76,12],[81,0,81,2],[81,3,81,4],[81,7,81,9],[81,10,81,11],[82,0,82,2],[82,3,82,4],[82,7,82,9],[82,10,82,11],[79,0,79,2],[79,3,79,5],[79,7,79,9],[79,10,79,12],[80,0,80,2],[80,3,80,4],[80,7,80,9],[80,10,80,11],[109,0,109,5],[109,7,109,12],[110,0,110,2],[110,3,110,5],[110,7,110,9],[110,10,110,12],[83,0,83,2],[83,3,83,5],[83,7,83,9],[83,10,83,12],[94,1,94,2],[94,4,94,5],[94,8,94,9],[94,11,94,12],[113,0,113,2],[113,3,113,5],[113,7,113,9],[113,10,113,12],[114,0,114,2],[114,3,114,4],[114,7,114,9],[114,10,114,11],[111,0,111,2],[111,3,111,5],[111,7,111,9],[111,10,111,12],[112,0,112,2],[112,3,112,5],[112,7,112,9],[112,10,112,12],[117,0,117,2],[117,3,117,5],[117,7,117,9],[117,10,117,12],[128,1,128,2],[128,4,128,5],[128,8,128,9],[128,11,128,12],[115,0,115,2],[115,3,115,4],[115,7,115,9],[115,10,115,11],[116,0,116,2],[116,3,116,4],[116,7,116,9],[116,10,116,11],[145,0,145,2],[145,3,145,5],[145,7,145,9],[145,10,145,12],[146,0,146,2],[146,3,146,5],[146,7,146,9],[146,10,146,12],[143,0,143,5],[143,7,143,12],[144,0,144,2],[144,3,144,5],[144,7,144,9],[144,10,144,12],[149,0,149,2],[149,3,149,4],[149,7,149,9],[149,10,149,11],[150,0,150,2],[150,3,150,4],[150,7,150,9],[150,10,150,11],[147,0,147,2],[147,3,147,5],[147,7,147,9],[147,10,147,12],[148,0,148,2],[148,3,148,4],[148,7,148,9],[148,10,148,11],[177,0,177,5],[177,7,177,12],[178,0,178,2],[178,3,178,5],[178,7,178,9],[178,10,178,12],[151,0,151,2],[151,3,151,5],[151,7,151,9],[151,10,151,12],[162,1,162,2],[162,4,162,5],[162,8,162,9],[162,11,162,12],[181,0,181,2],[181,3,181,5],[181,7,181,9],[181,10,181,12],[182,0,182,2],[182,3,182,4],[182,7,182,9],[182,10,182,11],[179,0,179,2],[179,3,179,5],[179,7,179,9],[179,10,179,12],[180,0,180,2],[180,3,180,5],[180,7,180,9],[180,10,180,12],[185,0,185,2],[185,3,185,5],[185,7,185,9],[185,10,185,12],[196,1,196,2],[196,4,196,5],[196,8,196,9],[196,11,196,12],[183,0,183,2],[183,3,183,4],[183,7,183,9],[183,10,183,11],[184,0,184,2],[184,3,184,4],[184,7,184,9],[184,10,184,11],[213,0,213,2],[213,3,213,5],[213,7,213,9],[213,10,213,12],[214,0,214,2],[214,3,214,5],[214,7,214,9],[214,10,214,12],[211,0,211,5],[211,7,211,12],[212,0,212,2],[212,3,212,5],[212,7,212,9],[212,10,212,12],[217,0,217,2],[217,3,217,4],[217,7,217,9],[217,10,217,11],[218,0,218,2],[218,3,218,4],[218,7,218,9],[218,10,218,11],[215,0,215,2],[215,3,215,5],[215,7,215,9],[215,10,215,12],[216,0,216,2],[216,3,216,4],[216,7,216,9],[216,10,216,11],[245,0,245,5],[245,7,245,12],[246,0,246,2],[246,3,246,5],[246,7,246,9],[246,10,246,12],[219,0,219,2],[219,3,219,5],[219,7,219,9],[219,10,219,12],[230,1,230,2],[230,4,230,5],[230,8,230,9],[230,11,230,12],[249,0,249,2],[249,3,249,5],[249,7,249,9],[249,10,249,12],[250,0,250,2],[250,3,250,4],[250,7,250,9],[250,10,250,11],[247,0,247,2],[247,3,247,5],[247,7,247,9],[247,10,247,12],[248,0,248,2],[248,3,248,5],[248,7,248,9],[248,10,248,12],[253,0,253,2],[253,3,253,5],[253,7,253,9],[253,10,253,12],[264,1,264,2],[264,4,264,5],[264,8,264,9],[264,11,264,12],[251,0,251,2],[251,3,251,4],[251,7,251,9],[251,10,251,11],[252,0,252,2],[252,3,252,4],[252,7,252,9],[252,10,252,11],[281,0,281,2],[281,3,281,5],[281,7,281,9],[281,10,281,12],[282,0,282,2],[282,3,282,5],[282,7,282,9],[282,10,282,12],[279,0,279,5],[279,7,279,12],[280,0,280,2],[280,3,280,5],[280,7,280,9],[280,10,280,12],[285,0,285,2],[285,3,285,4],[285,7,285,9],[285,10,285,11],[286,0,286,2],[286,3,286,4],[286,7,286,9],[286,10,286,11],[283,0,283,2],[283,3,283,5],[283,7,283,9],[283,10,283,12],[284,0,284,2],[284,3,284,4],[284,7,284,9],[284,10,284,11],[313,0,313,5],[313,7,313,12],[314,0,314,2],[314,3,314,5],[314,7,314,9],[314,10,314,12],[287,0,287,2],[287,3,287,5],[287,7,287,9],[287,10,287,12],[298,1,298,2],[298,4,298,5],[298,8,298,9],[298,11,298,12],[317,0,317,2],[317,3,317,5],[317,7,317,9],[317,10,317,12],[318,0,318,2],[318,3,318,4],[318,7,318,9],[318,10,318,11],[315,0,315,2],[315,3,315,5],[315,7,315,9],[315,10,315,12],[316,0,316,2],[316,3,316,5],[316,7,316,9],[316,10,316,12],[321,0,321,2],[321,3,321,5],[321,7,321,9],[321,10,321,12],[332,1,332,2],[332,4,332,5],[332,8,332,9],[332,11,332,12],[319,0,319,2],[319,3,319,4],[319,7,319,9],[319,10,319,11],[320,0,320,2],[320,3,320,4],[320,7,320,9],[320,10,320,11]]}
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,1,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C5","v":1}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F6","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"CAMPISI ",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D9=\"\",\"\",D9)","v":"CAMPISI "}]
[" PRENOM (S):",null,null,"SANTOR ROSARIO",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D10=\"\",\"\",D10)","v":"SANTOR ROSARIO"}]
["ADRESSE et TELEPHONE:",null,null,"05 652 60 86",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 652 60 86"]
["N° PASSEPORT:",null,null,"YA2328140",null,null,null,"N° PASSEPORT:",null,null,"YA2328140"]
["Destination des devises:",null,null,"ITALIE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D13=\"\",\"\",D13)","v":"ITALIE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D14=\"\",\"\",D14)","v":"Tourisme"}]
["Devise:",null,null,"DOLLARS",null,null,null,"Devise:",null,null,"DOLLARS"]
["TAUX Moyen de VENTE",null,null,640,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D16=\"\",\"\",D16)","v":640}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B21*A21","v":0},100,5,{"$f":"E21*D21","v":500},null,10000,{"$f":"IF(B21=\"\",\"\",B21)","v":""},{"$f":"IF(C21=\"\",\"\",C21)","v":0},100,{"$f":"IF(E21=\"\",\"\",E21)","v":5},{"$f":"IF(F21=\"\",\"\",F21)","v":500}]
[5000,null,{"$f":"B22*A22","v":0},50,null,{"$f":"E22*D22","v":0},null,5000,{"$f":"IF(B22=\"\",\"\",B22)","v":""},0,50,{"$f":"IF(E22=\"\",\"\",E22)","v":""},0]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,1,5,null,500,"",0,5,1,5]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D15=\"CFAO\",(C21+C22+C23+C24+C25),IF(D15=\"DOLLARS\",(F21+F22+F23+F24+F25+F26),IF(D15=\"EURO\",(C25+C26+F21+F22+F23+F24+F25),IF(D15=\"LIVRE STERLING\",(F22+F23+F24+F25),\"\"))))","v":505},null,"Net à Payer",{"$f":"PRODUCT(D16,B27)","v":323200},null,null,"Valeur Totale",{"$f":"IF(B27=\"\",\"\",B27)","v":505},null,"Net à Payer",{"$f":"IF(E27=\"\",\"\",E27)","v":323200}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,2,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C39","v":2}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F40","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"LUCIANO ",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D43=\"\",\"\",D43)","v":"LUCIANO "}]
[" PRENOM (S):",null,null,"OPORSCU",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D44=\"\",\"\",D44)","v":"OPORSCU"}]
["ADRESSE et TELEPHONE:",null,null,"05 514 19 98",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 514 19 98"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Destination des devises:",null,null,"ITALIE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D47=\"\",\"\",D47)","v":"ITALIE"}]
["Motif:",null,null,"Professionnel",null,null,null,"Motif:",null,null,{"$f":"IF(D48=\"\",\"\",D48)","v":"Professionnel"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D50=\"\",\"\",D50)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B55*A55","v":0},100,2,{"$f":"E55*D55","v":200},null,10000,{"$f":"IF(B55=\"\",\"\",B55)","v":""},{"$f":"IF(C55=\"\",\"\",C55)","v":0},100,{"$f":"IF(E55=\"\",\"\",E55)","v":2},{"$f":"IF(F55=\"\",\"\",F55)","v":200}]
[5000,null,{"$f":"B56*A56","v":0},50,null,{"$f":"E56*D56","v":0},null,5000,{"$f":"IF(B56=\"\",\"\",B56)","v":""},{"$f":"IF(C56=\"\",\"\",C56)","v":0},50,{"$f":"IF(E56=\"\",\"\",E56)","v":""},{"$f":"IF(F56=\"\",\"\",F56)","v":0}]
[2000,null,0,20,4,80,null,2000,"",0,20,4,80]
[1000,null,0,10,2,20,null,1000,"",0,10,2,20]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,2,400,1,null,0,null,200,2,400,1,"",0]
["Valeur Totale",{"$f":"IF(D49=\"CFAO\",(C55+C56+C57+C58+C59),IF(D49=\"DOLLARS\",(F55+F56+F57+F58+F59+F60),IF(D49=\"EURO\",(C59+C60+F55+F56+F57+F58+F59),IF(D49=\"LIVRE STERLING\",(F56+F57+F58+F59),\"\"))))","v":700},null,"Net à Payer",{"$f":"PRODUCT(D50,B61)","v":486500},null,null,"Valeur Total",{"$f":"IF(B61=\"\",\"\",B61)","v":700},null,"Net à Payer",{"$f":"IF(E61=\"\",\"\",E61)","v":486500}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,3,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C73","v":3}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F74","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"FOUNDOUMOUNA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D77=\"\",\"\",D77)","v":"FOUNDOUMOUNA"}]
[" PRENOM (S):",null,null,"EXAUCE ELON",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D78=\"\",\"\",D78)","v":"EXAUCE ELON"}]
["ADRESSE et TELEPHONE:",null,null,"06 975 64 17",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 975 64 17"]
["N° PASSEPORT:",null,null,"OA0072462",null,null,null,"N° PASSEPORT:",null,null,"OA0072462"]
["Destination des devises:",null,null,"MAROC",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D81=\"\",\"\",D81)","v":"MAROC"}]
["Motif:",null,null,"Etudes",null,null,null,"Motif:",null,null,{"$f":"IF(D82=\"\",\"\",D82)","v":"Etudes"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D84=\"\",\"\",D84)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B89*A89","v":0},100,2,{"$f":"E89*D89","v":200},null,10000,{"$f":"IF(B89=\"\",\"\",B89)","v":""},{"$f":"IF(C89=\"\",\"\",C89)","v":0},100,{"$f":"IF(E89=\"\",\"\",E89)","v":2},{"$f":"IF(F89=\"\",\"\",F89)","v":200}]
[5000,null,{"$f":"B90*A90","v":0},50,30,{"$f":"E90*D90","v":1500},null,5000,{"$f":"IF(B90=\"\",\"\",B90)","v":""},{"$f":"IF(C90=\"\",\"\",C90)","v":0},50,{"$f":"IF(E90=\"\",\"\",E90)","v":30},{"$f":"IF(F90=\"\",\"\",F90)","v":1500}]
[2000,null,0,20,10,200,null,2000,"",0,20,10,200]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,2,10,null,500,"",0,5,2,10]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D83=\"CFAO\",(C89+C90+C91+C92+C93),IF(D83=\"DOLLARS\",(F89+F90+F91+F92+F93+F94),IF(D83=\"EURO\",(C93+C94+F89+F90+F91+F92+F93),IF(D83=\"LIVRE STERLING\",(F90+F91+F92+F93),\"\"))))","v":1910},null,"Net à Payer",{"$f":"PRODUCT(D84,B95)","v":1327450},null,null,"Valeur Total",{"$f":"IF(B95=\"\",\"\",B95)","v":1910},null,"Net à Payer",{"$f":"IF(E95=\"\",\"\",E95)","v":1327450}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,4,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C107","v":4}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F108","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"NKOUKABAKA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D111=\"\",\"\",D111)","v":"NKOUKABAKA"}]
[" PRENOM (S):",null,null,"GLADYS",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D112=\"\",\"\",D112)","v":"GLADYS"}]
["ADRESSE et TELEPHONE:",null,null,"05 530 96 20",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 530 96 20"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Destination des devises:",null,null,"FRANCE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D115=\"\",\"\",D115)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D116=\"\",\"\",D116)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D118=\"\",\"\",D118)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B123*A123","v":0},100,1,{"$f":"E123*D123","v":100},null,10000,{"$f":"IF(B123=\"\",\"\",B123)","v":""},{"$f":"IF(C123=\"\",\"\",C123)","v":0},100,{"$f":"IF(E123=\"\",\"\",E123)","v":1},{"$f":"IF(F123=\"\",\"\",F123)","v":100}]
[5000,null,{"$f":"B124*A124","v":0},50,null,{"$f":"E124*D124","v":0},null,5000,{"$f":"IF(B124=\"\",\"\",B124)","v":""},{"$f":"IF(C124=\"\",\"\",C124)","v":0},50,{"$f":"IF(E124=\"\",\"\",E124)","v":""},{"$f":"IF(F124=\"\",\"\",F124)","v":0}]
[2000,null,0,20,2,40,null,2000,"",0,20,2,40]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D117=\"CFAO\",(C123+C124+C125+C126+C127),IF(D117=\"DOLLARS\",(F123+F124+F125+F126+F127+F128),IF(D117=\"EURO\",(C127+C128+F123+F124+F125+F126+F127),IF(D117=\"LIVRE STERLING\",(F124+F125+F126+F127),\"\"))))","v":140},null,"Net à Payer",{"$f":"PRODUCT(D118,B129)","v":97300},null,null,"Valeur Total",{"$f":"IF(B129=\"\",\"\",B129)","v":140},null,"Net à Payer",{"$f":"IF(E129=\"\",\"\",E129)","v":97300}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,5,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C141","v":5}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F142","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"MAKOUMBOU",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D145=\"\",\"\",D145)","v":"MAKOUMBOU"}]
[" PRENOM (S):",null,null,"FULGENCE I",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D146=\"\",\"\",D146)","v":"FULGENCE I"}]
["ADRESSE et TELEPHONE:",null,null,"06 649 56 98 ",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 649 56 98 "]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Destination des devises:",null,null,"FRANCE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D149=\"\",\"\",D149)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D150=\"\",\"\",D150)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D152=\"\",\"\",D152)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B157*A157","v":0},100,1,{"$f":"E157*D157","v":100},null,10000,{"$f":"IF(B157=\"\",\"\",B157)","v":""},{"$f":"IF(C157=\"\",\"\",C157)","v":0},100,{"$f":"IF(E157=\"\",\"\",E157)","v":1},{"$f":"IF(F157=\"\",\"\",F157)","v":100}]
[5000,null,{"$f":"B158*A158","v":0},50,1,{"$f":"E158*D158","v":50},null,5000,{"$f":"IF(B158=\"\",\"\",B158)","v":""},{"$f":"IF(C158=\"\",\"\",C158)","v":0},50,{"$f":"IF(E158=\"\",\"\",E158)","v":1},{"$f":"IF(F158=\"\",\"\",F158)","v":50}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,1,10,null,1000,"",0,10,1,10]
[500,null,0,5,1,5,null,500,"",0,5,1,5]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D151=\"CFAO\",(C157+C158+C159+C160+C161),IF(D151=\"DOLLARS\",(F157+F158+F159+F160+F161+F162),IF(D151=\"EURO\",(C161+C162+F157+F158+F159+F160+F161),IF(D151=\"LIVRE STERLING\",(F158+F159+F160+F161),\"\"))))","v":185},null,"Net à Payer",{"$f":"PRODUCT(D152,B163)","v":128575},null,null,"Valeur Total",{"$f":"IF(B163=\"\",\"\",B163)","v":185},null,"Net à Payer",{"$f":"IF(E163=\"\",\"\",E163)","v":128575}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,6,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C175","v":6}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F176","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"KONDE MUAKE",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D179=\"\",\"\",D179)","v":"KONDE MUAKE"}]
[" PRENOM (S):",null,null,"PIERRE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D180=\"\",\"\",D180)","v":"PIERRE"}]
["ADRESSE et TELEPHONE:",null,null,"05 559 63 31",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 559 63 31"]
["N° PASSEPORT:",null,null,"OB0112091",null,null,null,"N° PASSEPORT:",null,null,"OB0112091"]
["Destination des devises:",null,null,"BELGIQUE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D183=\"\",\"\",D183)","v":"BELGIQUE"}]
["Motif:",null,null,"Professionnel",null,null,null,"Motif:",null,null,{"$f":"IF(D184=\"\",\"\",D184)","v":"Professionnel"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D186=\"\",\"\",D186)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B191*A191","v":0},100,2,{"$f":"E191*D191","v":200},null,10000,{"$f":"IF(B191=\"\",\"\",B191)","v":""},{"$f":"IF(C191=\"\",\"\",C191)","v":0},100,{"$f":"IF(E191=\"\",\"\",E191)","v":2},{"$f":"IF(F191=\"\",\"\",F191)","v":200}]
[5000,null,{"$f":"B192*A192","v":0},50,2,{"$f":"E192*D192","v":100},null,5000,{"$f":"IF(B192=\"\",\"\",B192)","v":""},{"$f":"IF(C192=\"\",\"\",C192)","v":0},50,{"$f":"IF(E192=\"\",\"\",E192)","v":2},{"$f":"IF(F192=\"\",\"\",F192)","v":100}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,13,2600,1,null,0,null,200,13,2600,1,"",0]
["Valeur Totale",{"$f":"IF(D185=\"CFAO\",(C191+C192+C193+C194+C195),IF(D185=\"DOLLARS\",(F191+F192+F193+F194+F195+F196),IF(D185=\"EURO\",(C195+C196+F191+F192+F193+F194+F195),IF(D185=\"LIVRE STERLING\",(F192+F193+F194+F195),\"\"))))","v":2900},null,"Net à Payer",{"$f":"PRODUCT(D186,B197)","v":2015500},null,null,"Valeur Total",{"$f":"IF(B197=\"\",\"\",B197)","v":2900},null,"Net à Payer",{"$f":"IF(E197=\"\",\"\",E197)","v":2015500}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,7,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C209","v":7}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F210","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"MBOUNGOU",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D213=\"\",\"\",D213)","v":"MBOUNGOU"}]
[" PRENOM (S):",null,null,"YACINTHE",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D214=\"\",\"\",D214)","v":"YACINTHE"}]
["ADRESSE et TELEPHONE:",null,null,null,null,null,null,"ADRESSE et TELEPHONE:",null,null,""]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Destination des devises:",null,null,"FRANCE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D217=\"\",\"\",D217)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D218=\"\",\"\",D218)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D220=\"\",\"\",D220)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B225*A225","v":0},100,null,{"$f":"E225*D225","v":0},null,10000,{"$f":"IF(B225=\"\",\"\",B225)","v":""},{"$f":"IF(C225=\"\",\"\",C225)","v":0},100,{"$f":"IF(E225=\"\",\"\",E225)","v":""},{"$f":"IF(F225=\"\",\"\",F225)","v":0}]
[5000,null,{"$f":"B226*A226","v":0},50,null,{"$f":"E226*D226","v":0},null,5000,{"$f":"IF(B226=\"\",\"\",B226)","v":""},{"$f":"IF(C226=\"\",\"\",C226)","v":0},50,{"$f":"IF(E226=\"\",\"\",E226)","v":""},{"$f":"IF(F226=\"\",\"\",F226)","v":0}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,1,10,null,1000,"",0,10,1,10]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D219=\"CFAO\",(C225+C226+C227+C228+C229),IF(D219=\"DOLLARS\",(F225+F226+F227+F228+F229+F230),IF(D219=\"EURO\",(C229+C230+F225+F226+F227+F228+F229),IF(D219=\"LIVRE STERLING\",(F226+F227+F228+F229),\"\"))))","v":30},null,"Net à Payer",{"$f":"PRODUCT(D220,B231)","v":20850},null,null,"Valeur Total",{"$f":"IF(B231=\"\",\"\",B231)","v":30},null,"Net à Payer",{"$f":"IF(E231=\"\",\"\",E231)","v":20850}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,8,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C243","v":8}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F244","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"GOMA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D247=\"\",\"\",D247)","v":"GOMA"}]
[" PRENOM (S):",null,null,"SAHARA",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D248=\"\",\"\",D248)","v":"SAHARA"}]
["ADRESSE et TELEPHONE:",null,null,"CENTRE VILLE",null,null,null,"ADRESSE et TELEPHONE:",null,null,"CENTRE VILLE"]
["N° PASSEPORT:",null,null,"OA0021896",null,null,null,"N° PASSEPORT:",null,null,"OA0021896"]
["Destination des devises:",null,null,"FRANCE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D251=\"\",\"\",D251)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D252=\"\",\"\",D252)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,673,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D254=\"\",\"\",D254)","v":673}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B259*A259","v":0},100,null,{"$f":"E259*D259","v":0},null,10000,{"$f":"IF(B259=\"\",\"\",B259)","v":""},{"$f":"IF(C259=\"\",\"\",C259)","v":0},100,{"$f":"IF(E259=\"\",\"\",E259)","v":""},{"$f":"IF(F259=\"\",\"\",F259)","v":0}]
[5000,null,{"$f":"B260*A260","v":0},50,20,{"$f":"E260*D260","v":1000},null,5000,{"$f":"IF(B260=\"\",\"\",B260)","v":""},{"$f":"IF(C260=\"\",\"\",C260)","v":0},50,{"$f":"IF(E260=\"\",\"\",E260)","v":20},{"$f":"IF(F260=\"\",\"\",F260)","v":1000}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D253=\"CFAO\",(C259+C260+C261+C262+C263),IF(D253=\"DOLLARS\",(F259+F260+F261+F262+F263+F264),IF(D253=\"EURO\",(C263+C264+F259+F260+F261+F262+F263),IF(D253=\"LIVRE STERLING\",(F260+F261+F262+F263),\"\"))))","v":1000},null,"Net à Payer",{"$f":"PRODUCT(D254,B265)","v":673000},null,null,"Valeur Total",{"$f":"IF(B265=\"\",\"\",B265)","v":1000},null,"Net à Payer",{"$f":"IF(E265=\"\",\"\",E265)","v":673000}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,9,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C277","v":9}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F278","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"ETOU",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D281=\"\",\"\",D281)","v":"ETOU"}]
[" PRENOM (S):",null,null,"MALAINE B",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D282=\"\",\"\",D282)","v":"MALAINE B"}]
["ADRESSE et TELEPHONE:",null,null,"06 675 39 37 ",null,null,null,"ADRESSE et TELEPHONE:",null,null,"06 675 39 37 "]
["N° PASSEPORT:",null,null,"OA01298461",null,null,null,"N° PASSEPORT:",null,null,"OA01298461"]
["Destination des devises:",null,null,"CHINE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D285=\"\",\"\",D285)","v":"CHINE"}]
["Motif:",null,null,"Affaire",null,null,null,"Motif:",null,null,{"$f":"IF(D286=\"\",\"\",D286)","v":"Affaire"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D288=\"\",\"\",D288)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B293*A293","v":0},100,6,{"$f":"E293*D293","v":600},null,10000,{"$f":"IF(B293=\"\",\"\",B293)","v":""},{"$f":"IF(C293=\"\",\"\",C293)","v":0},100,{"$f":"IF(E293=\"\",\"\",E293)","v":6},{"$f":"IF(F293=\"\",\"\",F293)","v":600}]
[5000,null,{"$f":"B294*A294","v":0},50,1,{"$f":"E294*D294","v":50},null,5000,{"$f":"IF(B294=\"\",\"\",B294)","v":""},{"$f":"IF(C294=\"\",\"\",C294)","v":0},50,{"$f":"IF(E294=\"\",\"\",E294)","v":1},{"$f":"IF(F294=\"\",\"\",F294)","v":50}]
[2000,null,0,20,null,0,null,2000,"",0,20,"",0]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,null,0,null,500,"",0,5,"",0]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D287=\"CFAO\",(C293+C294+C295+C296+C297),IF(D287=\"DOLLARS\",(F293+F294+F295+F296+F297+F298),IF(D287=\"EURO\",(C297+C298+F293+F294+F295+F296+F297),IF(D287=\"LIVRE STERLING\",(F294+F295+F296+F297),\"\"))))","v":650},null,"Net à Payer",{"$f":"PRODUCT(D288,B299)","v":451750},null,null,"Valeur Total",{"$f":"IF(B299=\"\",\"\",B299)","v":650},null,"Net à Payer",{"$f":"IF(E299=\"\",\"\",E299)","v":451750}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]
[]
[]
[]
[]
["BORDEREAU DE VENTE N°",null,10,null,null,null,null,"BORDEREAU DE VENTE N°",null,{"$f":"C311","v":10}]
["Agence:","Lmumba",null,"            Pointe-Noire le",null,"2015-08-17",null,"Agence:","Lmumba",null,"            Pointe-Noire le",null,{"$f":"F312","v":"2015-08-17"}]
[]
["INFORMATIONS DU CLIENT",null,null,null,null,null,null,"INFORMATIONS DU CLIENT"]
["NOM (S) :",null,null,"NKOUKABAKA",null,null,null,"NOM (S) :",null,null,{"$f":"IF(D315=\"\",\"\",D315)","v":"NKOUKABAKA"}]
[" PRENOM (S):",null,null,"GLADYS",null,null,null," PRENOM (S):",null,null,{"$f":"IF(D316=\"\",\"\",D316)","v":"GLADYS"}]
["ADRESSE et TELEPHONE:",null,null,"05 530 96 20",null,null,null,"ADRESSE et TELEPHONE:",null,null,"05 530 96 20"]
["N° PASSEPORT:",null,null,null,null,null,null,"N° PASSEPORT:",null,null,""]
["Destination des devises:",null,null,"FRANCE",null,null,null,"Destination des devises:",null,null,{"$f":"IF(D319=\"\",\"\",D319)","v":"FRANCE"}]
["Motif:",null,null,"Tourisme",null,null,null,"Motif:",null,null,{"$f":"IF(D320=\"\",\"\",D320)","v":"Tourisme"}]
["Devise:",null,null,"EURO",null,null,null,"Devise:",null,null,"EURO"]
["TAUX Moyen de VENTE",null,null,695,null,null,null,"TAUX Moyen de VENTE",null,null,{"$f":"IF(D322=\"\",\"\",D322)","v":695}]
[]
[]
["BILLETAGE",null,null,null,null,null,null,"BILLETAGE"]
["Coupures","Quantité","Valeur","Coupures","Quantité","Valeur",null,"Coupures","Quantité","Valeur","Coupures","Quantité","Valeur"]
[10000,null,{"$f":"B327*A327","v":0},100,null,{"$f":"E327*D327","v":0},null,10000,{"$f":"IF(B327=\"\",\"\",B327)","v":""},{"$f":"IF(C327=\"\",\"\",C327)","v":0},100,{"$f":"IF(E327=\"\",\"\",E327)","v":""},{"$f":"IF(F327=\"\",\"\",F327)","v":0}]
[5000,null,{"$f":"B328*A328","v":0},50,null,{"$f":"E328*D328","v":0},null,5000,{"$f":"IF(B328=\"\",\"\",B328)","v":""},{"$f":"IF(C328=\"\",\"\",C328)","v":0},50,{"$f":"IF(E328=\"\",\"\",E328)","v":""},{"$f":"IF(F328=\"\",\"\",F328)","v":0}]
[2000,null,0,20,1,20,null,2000,"",0,20,1,20]
[1000,null,0,10,null,0,null,1000,"",0,10,"",0]
[500,null,0,5,1,5,null,500,"",0,5,1,5]
[200,null,0,1,null,0,null,200,"",0,1,"",0]
["Valeur Totale",{"$f":"IF(D321=\"CFAO\",(C327+C328+C329+C330+C331),IF(D321=\"DOLLARS\",(F327+F328+F329+F330+F331+F332),IF(D321=\"EURO\",(C331+C332+F327+F328+F329+F330+F331),IF(D321=\"LIVRE STERLING\",(F328+F329+F330+F331),\"\"))))","v":25},null,"Net à Payer",{"$f":"PRODUCT(D322,B333)","v":17375},null,null,"Valeur Total",{"$f":"IF(B333=\"\",\"\",B333)","v":25},null,"Net à Payer",{"$f":"IF(E333=\"\",\"\",E333)","v":17375}]
[]
["Caissier ",null,null,null,null,"Client",null,"Caissier",null,null,null,null,"Client"]
[]
[]
[]
[]
["."]

{"sheet":"STATISTIQUE","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[14,3,14,4],[14,5,14,6]]}
[null,null,null,null,null,null,null,null,null,{"$f":"TODAY()-1","v":"2015-08-17"}]
[]
[]
[null,null,null,"STATISTIQUE DES OPERATIONS DE CHANGE"]
[]
[null,null,null,null,null,null,null,"Pointe-Noire, le","2015-08-17"]
["Agence","Lumumba"]
[]
[]
["DEVISE","OUVERTURE","APPRO","VALEUR ACHAT","Montant ACHAT","VALEUR VENTE","Montant VENTE","RAPATRIE","CLOTURE"]
["CFAO",2000,null,{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A11)*IF(ISNUMBER(ACHAT!$B$22:$B$100021),ACHAT!$B$22:$B$100021,0))","v":100000},{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A11)*IF(ISNUMBER(ACHAT!$E$22:$E$100021),ACHAT!$E$22:$E$100021,0))","v":100000},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A11)*IF(ISNUMBER(VENTE!$B$22:$B$100021),VENTE!$B$22:$B$100021,0))","v":0},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A11)*IF(ISNUMBER(VENTE!$E$22:$E$100021),VENTE!$E$22:$E$100021,0))","v":0},null,{"$f":"(B11+C11+D11)-(F11+H11)","v":102000}]
["DOLLARS",918,null,{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A12)*IF(ISNUMBER(ACHAT!$B$22:$B$100021),ACHAT!$B$22:$B$100021,0))","v":60},{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A12)*IF(ISNUMBER(ACHAT!$E$22:$E$100021),ACHAT!$E$22:$E$100021,0))","v":35000},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A12)*IF(ISNUMBER(VENTE!$B$22:$B$100021),VENTE!$B$22:$B$100021,0))","v":505},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A12)*IF(ISNUMBER(VENTE!$E$22:$E$100021),VENTE!$E$22:$E$100021,0))","v":323200},null,{"$f":"(B12+C12+D12)-(F12+H12)","v":473}]
["EURO",7050,null,{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A13)*IF(ISNUMBER(ACHAT!$B$22:$B$100021),ACHAT!$B$22:$B$100021,0))","v":1910},{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A13)*IF(ISNUMBER(ACHAT!$E$22:$E$100021),ACHAT!$E$22:$E$100021,0))","v":1252300},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A13)*IF(ISNUMBER(VENTE!$B$22:$B$100021),VENTE!$B$22:$B$100021,0))","v":7540},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A13)*IF(ISNUMBER(VENTE!$E$22:$E$100021),VENTE!$E$22:$E$100021,0))","v":5218300},null,1420]
["Livre Sterling",30,null,{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A14)*IF(ISNUMBER(ACHAT!$B$22:$B$100021),ACHAT!$B$22:$B$100021,0))","v":90},{"$f":"SUMPRODUCT((ACHAT!$M$1:$M$100000=$J$1)*(ACHAT!$D$10:$D$100009=$A14)*IF(ISNUMBER(ACHAT!$E$22:$E$100021),ACHAT!$E$22:$E$100021,0))","v":54000},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A14)*IF(ISNUMBER(VENTE!$B$22:$B$100021),VENTE!$B$22:$B$100021,0))","v":0},{"$f":"SUMPRODUCT((VENTE!$M$1:$M$100000=$J$1)*(VENTE!$D$10:$D$100009=$A14)*IF(ISNUMBER(VENTE!$E$22:$E$100021),VENTE!$E$22:$E$100021,0))","v":0},null,120]
["XAF",3172870,107500,{"$f":"E14+E13+E12+E11","v":1441300},null,{"$f":"G14+G13+G12+G11","v":5541500},null,2325000,{"$f":"(B15+C15+F15)-(D15+H15)","v":5055570}]
[]
[null,"Chef d'agence",null,null,null,null,null,"Caissier"]
[]
[]
[]
[]
[]
["MOTIFS DE RAPATRIEMENT",null,null,null,null,"PROVENANCE DE L'APPROVISIONNEMENT"]
["_",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,"_"]
[]
[]
["."]

{"sheet":"Feuil2","index":3,"n_rows":154,"n_cols":1,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
["AFGHANISTAN"]
["AFRIQUE DU SUD"]
["ALBANIE"]
["ABOU DHABI"]
["ALGÉRIE"]
["ALLEMAGNE"]
["ANGLETERRE"]
["ANGOLA"]
["ARABIE SAOUDITE"]
["ARGENTINE"]
["ARMÉNIE"]
["AUSTRALIE"]
["BANGLADESH"]
["BELGIQUE"]
["BÉNIN"]
["BOLIVIE"]
["BOSNIE-HERZÉGOVINE"]
["BOTSWANA"]
["BRÉSIL"]
["BULGARIE"]
["BURKINA FASO"]
["BURUNDI"]
["CAMBODGE"]
["CAMEROUN"]
["CANADA"]
["CAP-VERT"]
["CENTRAFRIQUE"]
["CHILI"]
["CHINE"]
["CHYPRE"]
["COLOMBIE"]
["COMORES"]
["CONGO,RD"]
["CORÉE, RÉPUBLIQUE DE"]
["CORÉE DU NORD"]
["COSTA RICA"]
["CÔTE D’IVOIRE"]
["CROATIE"]
["CUBA"]
["DANEMARK"]
["DJIBOUTI"]
["DOMINIQUE"]
["DUBAÏ"]
["ECOSSE"]
["ÉGYPTE"]
["ÉQUATEUR"]
["ÉRYTHRÉE"]
["ESPAGNE"]
["ÉTATS-UNIS"]
["ÉTHIOPIE"]
["FINLANDE"]
["FRANCE"]
["GABON"]
["GAMBIE"]
["GHANA"]
["GRÈCE"]
["GRENADE"]
["GUADELOUPE"]
["GUATEMALA"]
["GUINÉEGUINÉE-BISSAU"]
["GUINÉE ÉQUATORIALE"]
["GUYANA"]
["HAÏTI"]
["HONDURAS"]
["HONG KONG"]
["HONGRIE"]
["INDE"]
["INDONÉSIE"]
["IRAN"]
["IRAQ"]
["IRLANDE"]
["IRLANDE DU NORD"]
["ISLANDE"]
["ISRAËL"]
["ITALIE"]
["JAMAÏQUE"]
["JAPON"]
["KAZAKHSTAN"]
["KENYA"]
["KOWEÏT"]
["LESOTHO"]
["LIBAN"]
["LIBÉRIA"]
["LIBYE"]
["LITUANIE"]
["LUXEMBOURG"]
["MACÉDOINE"]
["MADAGASCAR"]
["MALAISIE"]
["MALAWI"]
["MALI"]
["MALTE"]
["MAROC"]
["MARTINIQUE"]
["MAURICE"]
["MAURITANIE"]
["MAYOTTE"]
["MEXIQUE"]
["MONACO"]
["MONGOLIE"]
["MONTÉNÉGRO"]
["MOZAMBIQUE"]
["NAMIBIE"]
["NÉPAL"]
["NICARAGUA"]
["NIGER"]
["NIGÉRIA"]
["NORVÈGE"]
["NOUVELLE-CALÉDONIE"]
["NOUVELLE-ZÉLANDE"]
["OUGANDA"]
["PAKISTAN"]
["PARAGUAY"]
["PAYS-BAS"]
["PAYS DE GALLES"]
["PÉROU"]
["PHILIPPINES"]
["POLOGNE"]
["PORTO RICO"]
["PORTUGAL"]
["QATAR"]
["RÉUNION"]
["ROUMANIE"]
["RUSSIE, FÉDÉRATION DE"]
["RWANDA"]
["SAO TOMÉ-ET-PRINCIPE"]
["SÉNÉGAL"]
["SERBIE"]
["SEYCHELLES"]
["SIERRA LEONE"]
["SINGAPOUR"]
["SLOVÉNIE"]
["SOMALIE"]
["SOUDAN"]
["SOUDAN DU SUD"]
["SUÈDE"]
["SUISSE"]
["SWAZILAND"]
["SYRIE"]
["TADJIKISTAN"]
["TAÏWAN"]
["TANZANIE, DAR ES SALAM"]
["TCHAD"]
["TCHÈQUE, RÉPUBLIQUE"]
["THAÏLANDE"]
["TOGO"]
["TUNISIE"]
["TURQUIE"]
["UKRAINE"]
["URUGUAY"]
["VENEZUELA"]
["VIET NAM"]
["ZAMBIE"]
["ZIMBABWE"]