{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stock","Facture_Devis","Mouv_ventes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":"Stock","index":0,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,16]]}
["STOCK "]
["Ref Piéces","Produits","Casier","Quantité Reçue","Pieces Stock","Prix achat HT","Taux TVA","Total Achat HT","Marge HT","Prix Vente HT","Total Stock tva 20 HT","Total Stock TTC","Total Stock tva 7 HT","Total Stock tva 7 TTC","Total Stock BoutiqueTTC","Nbre Pieces","Date derniére Modification"]
["AAA","aaaaaaaaaaaaaaa","case1",2,6,81,20,{"$f":"SUM(E3*F3)","v":486},{"$f":"SUM(J3/F3)","v":1.7901234567901234},145,{"$f":"SUMIF(G3:G1048576,\"20\",H3:H1048576)","v":5393},{"$f":"SUM(K3*1.2)","v":6471.5999999999995},{"$f":"SUMIF(G3:G1048576,\"7\",H3:H1048576)","v":6171},41820.98605324074,{"$f":"SUM(L3,N3)","v":48292.586053240739},1,"2014-06-28T02:34:08"]
["BBB","bbbbbbbbbbbbbb","case2",3,-8,88,7,{"$f":"SUM(E4*F4)","v":-704},{"$f":"SUM(J4/F4)","v":1.6590909090909092},146,null,null,null,"2014-06-30T23:39:55",null,2,"2014-06-28T02:34:08"]
["CCC","ccccccccccccccccccc","case3",4,16,78,7,1248,1.8846153846153846,147,null,null,null,"2014-06-30T13:44:07",null,3,"2014-06-28T02:34:08"]
["DDD","dddddddddddddd","case4",5,-3,88,20,-264,1.6818181818181819,148,null,null,null,"2014-06-30T23:39:55",null,4,"2014-06-28T02:34:08"]
["EEE","une balancoire","case5",6,18,-6,20,-108,-24.833333333333332,149,null,null,null,null,null,5,"2014-06-28T01:11:33"]
["FFF","jus de pomme","case6",7,11,2,7,22,75,150,null,null,null,"2014-06-30T13:38:43",null,6,"2014-06-28T02:34:08"]
["GGGG","hgfjfhj","case7",8,17,4,7,68,37.75,151,null,null,null,"2014-06-30T13:44:07",null,9,"2014-06-23T22:53:01"]
["HHH","dddddddddddddd","case8",9,20,2,20,40,76,152,null,null,null,null,null,10,"2014-06-24T00:42:05"]
["IIII","fgdgbg","case9",10,20,17,20,340,9,153,null,null,null,null,null,16,"2014-06-04T13:36:23"]
["JJJJJ","hgfjfhj","case10",11,20,4,7,80,38.5,154,null,null,null,null,null,17,"2014-06-04T13:39:14"]
["KKKK","ffruidsi","case11",12,20,28,7,560,5.5357142857142856,155,null,null,null,null,null,19,"2014-06-04T13:40:02"]
["LLLL","bbbbbbbbbbbbbb","case12",13,20,92,20,1840,1.6956521739130435,156,null,null,null,null,null,20,"2014-06-04T13:42:32"]
["MMM","ccccccccccccccccccc","case13",14,19,78,20,1482,2.0128205128205128,157,null,null,null,"2014-06-29T00:59:37",null,21,"2014-06-04T13:43:39"]
["NNN","aaaaaaaaaaaaaaa","case14",15,19,83,7,1577,1.9036144578313252,158,null,null,null,"2014-06-29T00:59:37",null,22,"2014-06-05T21:59:08"]
["OOO","aaaaaaaaaaaaaaa","case15",16,20,83,7,1660,1.9156626506024097,159,null,null,null,null,null,23,"2014-06-05T21:59:22"]
["PPPP","aaaaaaaaaaaaaaa","case16",17,19,83,20,1577,1.927710843373494,160,null,null,null,"2014-06-29T00:59:37",null,24,"2014-06-05T22:18:08"]
["QQQQ","aaaaaaaaaaaaaaa","case1",18,20,83,7,1660,1.9397590361445782,161,null,null,null,null,null,25,"2014-06-23T22:49:10"]
["RRRR",null,null,null,null,10,20,0,16.2,162,null,null,null,null,null,26]
["DUIEJEJD","cahuettes","case8",5,15,78,null,null,null,356,null,null,null,null,null,27,"2014-06-28T21:13:40"]
["OOO","aaaaaaaaaaaaaaa","case15",16,36,83,null,null,null,159,null,null,null,null,null,28,"2014-06-28T21:15:32"]
["CCC","ccccccccccccccccccc","case3",4,20,78,null,null,null,147,null,null,null,"2014-06-30T13:44:07",null,29,"2014-06-28T21:18:01"]
["DDD","dddddddddddddd","case4",5,2,88,null,null,null,148,null,null,null,"2014-06-30T23:39:55",null,31,"2014-06-28T21:18:42"]
["GGGG","hgfjfhj","case7",8,25,4,null,null,null,151,null,null,null,"2014-06-30T13:44:07",null,32,"2014-06-28T21:36:53"]

{"sheet":"Facture_Devis","index":1,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,4,3,6],[7,0,7,1],[13,0,13,6]]}
[null,null,null,null,null,null,null,null,{"$f":"LEFT(Type,3)","v":""},null,"nom","Prenom"]
["Slogan de société",null,null,null,null,null,null,null,null,null,"PIERRE","JEAN"]
[7,null,null,null,null,null,null,null,null,null,"CP","Ville"]
["Adresse",null,null,null,{"$f":"\"DATE : \"& TEXT(TODAY(),\"jj mmm aaaa\")","v":"DATE : 03 juil 2014"}]
["Code postal, Ville",null,{"$f":"CONCATENATE(\"N° \",Type,\" :\",IF(Type=\"FACTURE\",N°_fact,N°_devis))","v":{"$error":"#NAME?"}},{"$f":"IF(Type=\"FACTURE\",N°_fact,N°_devis)","v":{"$error":"#NAME?"}}]
["Téléphone (229) 95952623"]
["Télécopie (229) 97772302"]
["CLIENT "]
[]
[]
[]
[]
[{"$f":"CONCATENATE(Type,\" N° : \",TEXT(IF(Type=\"FACTURE\",N°_fact,N°_devis),\"00000\"))","v":{"$error":"#NAME?"}}]
[]
["Ref Piéces","Désignation Piéces","Qtée","Prix U.HT","Remise","Tva","MONTANT HT"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",SUM(D21-(D21*E21)/100)*C21)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(A23=\"\",\"\",SUM(D23-(D23*E23)/100)*C23)","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"Mouv_ventes","index":2,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Statistiques  Ventes Articles",null,null,null,null,null,null,null,null,null,null,"Ventes 1 er trimestre","Ventes 2 eme trimestre","Ventes 3eme trimestre","Ventes 4eme trimestre"]
["Ref Piéces","Désignation Piéces","Qtée","Date Vente","Nom","Prénom","N° Facture",null,"Ref Piéces","Nombre ventes",{"$f":"IF(D2=\"\",\"\",INT((MONTH(D2)-1)/3)+1)","v":{"$error":"#VALUE!"}},{"$f":"SUMIF(trim_stat,\"1\",stat_quant)","v":2},{"$f":"SUMIF(trim_stat,\"2\",stat_quant)","v":0},{"$f":"SUMIF(trim_stat,\"3\",stat_quant)","v":0},{"$f":"SUMIF(trim_stat,\"4\",stat_quant)","v":0}]
["FFF","jus de pomme",1,"2014-03-07","PIERRE","JEAN",null,null,"FFF",{"$f":"SUMPRODUCT(($A$3:$A$4=I3)*($C$3:$C$4))","v":1},{"$f":"IF(D3=\"\",\"\",INT((MONTH(D3)-1)/3)+1)","v":1},{"$f":"SUMPRODUCT(($A$3:$A$9=I3)*($C$3:$C$9))","v":1}]
["EEE","une balancoire",1,"2014-03-07","PIERRE","JEAN",null,null,"EEE",{"$f":"SUMPRODUCT(($A$3:$A$4=I4)*($C$3:$C$4))","v":1},{"$f":"IF(D4=\"\",\"\",INT((MONTH(D4)-1)/3)+1)","v":1},{"$f":"SUMIF(trim_stat,\"1\",stat_quant)","v":2}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUMIF(trim_stat,\"1\",stat_quant)","v":2}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUMIF(trim_stat,\"1\",stat_quant)","v":2}]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"SUMIF(trim_stat,\"1\",stat_quant)","v":2}]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]