{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["STOCK MAGASIN","PRODUITS VENDUS","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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 MAGASIN","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["AL RAZAQ: STOCK MAGASIN"]
["DATE","PRODUIT","PHONES","REFERENCE","Q.INITIALE","PRIX.V.U","PRIX V.TOT."]
["2018-10-02","SYSTEME CHARGER","SONY","X10 Mini",2,50000,{"$f":"SUM(E3*F3)","v":100000}]
["2018-10-02","LCD","iPHONE","iPhone X  ",5,250000,1250000]
["2018-10-02","LCD","SAMSUNG","GALAXY A3 (2015)",10,150000,{"$f":"SUM(E5*F5)","v":1500000}]
["2018-10-02","COVER","iPHONE","iPhone 4s",3,5000,15000]
["2018-10-02","PROTECTOR","iPHONE","iPhone X  ",50,10000,500000]
["2018-10-02","BATTERY","SAMSUNG","GALAXY A7 (2015)",6,30000,180000]
["2018-10-02","LCD","iPHONE","iPhone X  ",3,250000,750000]
["Total",null,null,null,{"$f":"SUBTOTAL(109,[Q.INITIALE])","v":79}]

{"sheet":"PRODUITS VENDUS","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["AL RAZAQ : PRODUITS VENDUS"]
["DATE","PRODUIT","PHONES","REFERENCE","QUANTITE","PRIX.V.U","PRIX V.TOT."]
["2018-10-02","PROTECTOR","iPHONE","iPhone X  ",3,10000,{"$f":"SUM(E3*F3)","v":30000}]
["2018-10-02","LCD","SAMSUNG","GALAXY A3 (2015)",2,150000,{"$f":"SUM(E4*F4)","v":300000}]
["2018-10-03","BATTERY","SAMSUNG","GALAXY A7 (2015)",2,30000,{"$f":"SUM(E5*F5)","v":60000}]
["2018-10-03","LCD","SAMSUNG","GALAXY A3 (2015)",1,150000,{"$f":"SUM(E6*F6)","v":150000}]
[null,null,null,null,null,null,{"$f":"SUM(E7*F7)","v":0}]
["Total",null,null,null,{"$f":"SUBTOTAL(109,[QUANTITE])","v":8},null,{"$f":"SUBTOTAL(109,[PRIX V.TOT.])","v":540000}]

{"sheet":"Feuil3","index":2,"n_rows":152,"n_cols":15,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
["PRODUITS","PHONES","SAMSUNG","iPHONES","SONY","LG","HUAWEI","HTC","NOKIA","LENOVO","TECHNO","PLAYSTATION4","PLAYSTATION3","PLAYSTATION2","XBOX360"]
["USB CABLE","SAMSUNG","GALAXY A3 (2015)","iPhone 4","Xperia X1","LG G2","A199 ","Desire","Nokia edge 2018","Lenovo K5 ","Phantom 6","WIRE ","WIRE","WIRE","WIRE"]
["PROTECTOR","iPHONE","GALAXY A5 (2015)","iPhone 4s","Xperia X2","LG KP 500","Ascend D2 ","Desire C","Nokia edge 2017","Lenovo K900 ","Phantom 6 plus","WIRELESS","WIRELESS","WIRELESS","WIRELESS"]
["COVER","SONY","GALAXY A7 (2015)","iPhone 4s ","Xperia X8","LG KS20","Ascend G300 ","Desire HD","Nokia 10","Lenovo S920 ","Phantom 8","USB","USB","USB","USB"]
["LCD","LG","GALAXY A8(2015)","iPhone 5 ","Xperia X10 ","LG G3","Ascend G330 ","Desire S","Nokia 9","Lenovo Vibe X ","Camon C9"]
["FLASH DISK","HUAWEI","GALAXY A3 (2016) ","iPhone 5c  ","X10 Mini","LG G4","Ascend G350 ","Desire V","Nokia 8 Sirocco","Lenovo Vibe Z ","Camon CM"]
["CHARGER","HTC","GALAXY A5 (2016) ","iPhone 5s  ","X10 Mini pro","LG G5","Ascend G510 ","Desire Z","Nokia 8",null,"Camon Cx"]
["SYSTEME CHARGER","NOKIA","GALAXY A7 (2016) ","iPhone 6 ","Xperia Arc","Nexus 4","Ascend G520 ","Desire X","Nokia 7.1 ",null,"Camon Cx Air"]
["EARPHONE","LENOVO","GALAXY A8 (2016) ","iPhone 6 Plus  ","Xperia Play","Nexus 5","Ascend G525 ","Desire U","Nokia  7 Plus",null,"WX3F LTE"]
["HEADPHONE","TECHNO","GALAXY A9 (2016)","iPhone 6s ","Xperia Pro","Nexus 5X","Ascend G600 ","Desire P","Nokia 6.1 Plus",null,"WX3 P"]
["CASING","WD","GALAXY A9 PRO(2016)","iPhone 6s Plus  ","Xperia Kyno/Neo","LG Viewty","Ascend G615 ","Desire Q","Nokia 6.1",null,"Spark"]
["LAPTOP","HP","GALAXY A3(2017) ","iPhone SE ","Xperia Mini Pro","LG Viewty Smart","Ascend G700 ","Desire","Nokia 5.1 Plus",null,"Spark 2"]
["MOUSE WIRE","DELL"," GALAXY A5 (2017) ","iPhone 7  ","Xperia Ray","Optimus Chic ","Ascend Mate ","Desire 200","Nokia 2.1",null,"Spark pro"]
["MOUSE WIRELESS","LENOVO L.","GALAXY A7(2017) ","iPhone 7 Plus  ","Xperia arc S","Optimus Net ","Ascend Mate 7","Desire 300","Nokia 2",null,"L9 plus"]
["BLUETOOTH SPEAKER","TOSHIBA","GALAXY A6 (2018) ","iPhone 8  ","Xperia Kyno V/Neo V","Optimus 2X ","Ascend P1 ","Desire 500","Nokia 1"]
["BLUETOOTH ","ACER","GALAXY A6+(2018) ","iPhone 8 Plus  ","Xperia Active","Optimus 3D ","Ascend P1S ","Desire 600","Nokia Lumia 900"]
["BATTERY","PLAYSTATION4","GALAXY A7 (2018) ","iPhone X  ","Modèles Sony","Optimus Black ","Ascend P2","Desire 601","Nokia Lumia 920"]
["SIM TRAY","PLAYSTATION3","GALAXY A8 (2018) ","iPhone XS","Xperia S","Optimus 4X HD ","Ascend P6 ","Desire 608T","Nokia Lumia 925"]
["CAR MP3","PLAYSTATION2","GALAXY A8+ (2018) ","iPhone XS Max ","Xperia sola","Optimus Vu ","Ascend P7 ","Desire 709D","Nokia Lumia 928"]
["CAR CHARGER","USB PORT","GALAXY A8 (2018) ","iPhone XR","Xperia U","Optimus Vu II ","Ascend Y201 ","Desire 7060","Nokia Lumia 1020"]
["HDMI CABLE","XBOX360","GALAXY GRAND",null,"Xperia P","Optimus Vu II Plus ","Ascend Y100 ","Desire 7088","Nokia Lumia 950"]
["PRINTER CABLE",null,"GALAXY GRAND",null,"Xperia neo L","Optimus 3D Max ","Boulder ","Dream","Nokia lumia 650"]
["MEMORY CARD",null,"GALAXY GRAND 2",null,"Xperia go","Optimus Sol ","Blaze ","Evo 4G","Nokia Lumia 640"]
["BACK COVER",null,"GALAXY GRAND NEO",null,"Xperia Acro HD / acro S","Optimus Hub ","Honor ","HTC Evo 3D","Nokia Lumia 550"]
["LAPTOP SPEAKER",null,"GALAXY GRAND PRIME",null,"Xperia ion","Optimus One ","Honor 2 ","Hero","Nokia Lumia 540"]
["GLASS",null,"GALAXT GRAND PRIME DUOS",null,"Xperia tipo dual","Optimus Me ","Honor 3 ","Incredible"]
["TOUCH",null,"GALAXY GRAND PRIME VE",null,"Xperia tipo","Optimus Chat ","Honor 6 ","Incredible S"]
["MOBILE SPEAKER",null,"GALAXY GRAND MAX",null,"Xperia miro","Optimus LTE ","Honor 3C","Legend"]
["HOUSING",null,"GALAXY GRAND PRIME PLUS",null,"Sony Xperia miro","Optimus LTE II ","Honor Holly ","Magic"]
["JOYSTICKER ",null,"GALAXY GRAND PRIME PRO",null,"Xperia Tablet S","Optimus LTE III ","Ideos X5 ","Pyramid"]
["MAC CHARGER",null,"GALAXY J1 (2015)",null,"Xperia T","Prada 3.0","Sonic ","Rhyme"]
["HOUSING",null,"GALAXY J1 ACE",null,"Xperia TX","Optimus G ","U956 ","Tattoo"]
[null,null,"GALAXY J1 (2016)",null,"Xperia J","Optimus G Pro ","Mate 20 pro","Wildfire"]
[null,null,"GALAXY J1 MINI",null,"Xperia V","Optimus GJ ",null,"Wildfire S"]
[null,null,"GALAXY J1 NXT",null,"Xperia Z","Optimus GK",null,"Explorer"]
[null,null,"GALAXY J1 MINI PRIME",null,"Xperia ZL","Optimus L9 ",null,"HTC Butterfly"]
[null,null,"GALAXY J2 (2015)",null,"Xperia Z Tablet","Optimus L7 ",null,"HTC Butterfly S"]
[null,null,"GALAXY J2 (2017)",null,"Xperia E","Optimus L5 ",null,"E1"]
[null,null,"GALAXY J2 (2016)",null,"Xperia L","Optimus L3 ",null,"First"]
[null,null,"GALAXY J2 PRO (2016)",null,"Xperia SP","Optimus L9 II ",null,"HTC Sensation"]
[null,null,"GALAXY J2 PRIME",null,"Xperia M","Optimus L7 II ",null,"HTC Sensation XE"]
[null,null,"GALAXY J2 PRO (2018)",null,"Xperia ZR","Optimus L7",null,"HTC Sensation XL"]
[null,null,"GALAXY J2 CORE",null,"Xperia Z Ultra","Optimus L5 II ",null,"One X"]
[null,null,"GALAXY J3 (2016)",null,"Xperia Z1","Optimus L4 II ",null,"One X+"]
[null,null,"GALAXY J3 PRO",null,"Xperia Z1f","Optimus L3 II ",null,"One XL"]
[null,null,"GALAXY J3 (2017)",null,"Xperia Z1 Compact","Optimus L1 II ",null,"One S"]
[null,null,"GALAXY J3 PRO (2017)",null,"Xperia Z2","Optimus F7 ",null,"One SV"]
[null,null,"GALAXY J3 EMERGE",null,"Xperia Z2 Tablet","Optimus F5",null,"One V"]
[null,null,"GALAXY J3 PRIME",null,"Xperia E1",null,null,"HTC Legend)"]
[null,null,"GALAXY J3 ECLIPSE",null,"Xperia M2",null,null,"One M7"]
[null,null,"GALAXY J3 (2018)",null,"Xperia M2 Aqua",null,null,"One Mini"]
[null,null,"GALAXY J4",null,"Xperia T2 Ultra",null,null,"One Max"]
[null,null,"GALAXY J5 (2015)",null,"Xperia E3",null,null,"One (M8)"]
[null,null,"GALAXY J5 (2016)",null,"Xperia T3",null,null,"One M8s"]
[null,null,"GALAXY J5 PRIME (2016)",null,"Xperia Z3",null,null,"One Mini 2"]
[null,null,"GALAXY J5 / J5 PRO (2017)",null,"Xperia Z3 Compact",null,null,"One M9"]
[null,null,"GALAXY J6",null,"Xperia Z3 Tablet Compact",null,null,"One A9"]
[null,null,"GALAXY J7 (2015)",null,"Xperia Z3v",null,null,"HTC 10 (2016)"]
[null,null,"GALAXY J7 (2016)",null,"Xperia Z4 Tablet"]
[null,null,"GALAXY J7 PRIME",null,"Xperia E4"]
[null,null,"GALAXY J7 PERX",null,"Xperia E4g"]
[null,null,"GALAXY J7 V",null,"Xperia C4"]
[null,null,"GALAXY J7 MAX",null,"Xperia M4 Aqua"]
[null,null,"GALAXY J7 / J7 PRO (2017)",null,"Xperia Z4/Z3+"]
[null,null,"GALAXY J7+",null,"Xperia C5 ultra"]
[null,null,"GALAXY J7 DUO",null,"Xperia C5 ultra dual"]
[null,null,"GALAXY J7 (2018)",null,"Xperia M5"]
[null,null,"GALAXY J MAX",null,"Xperia Z5"]
[null,null,"GALAXY J8",null,"Xperia Z5 Compact"]
[null,null,"GALAXY C5 ",null,"Xperia Z5 Premium"]
[null,null,"GALAXY C5 PRO ",null,"Xperia E5"]
[null,null,"GALAXY C7 (2016) ",null,"Xperia X"]
[null,null,"GALAXY C7 (2017)",null,"Xperia X Performance"]
[null,null,"GALAXY C7 PRO ",null,"Xperia XA"]
[null,null,"GALAXY C9 PRO",null,"Xperia XA Ultra"]
[null,null,"GALAXY ON",null,"Xperia XZ"]
[null,null,"GALAXY ON 5 (2015) ",null,"Xperia X Compact"]
[null,null,"GALAXY ON 5 (2016",null,"Xperia XA1"]
[null,null,"GALAXY ON 5 (2017) ",null,"Xperia XA1 Ultra"]
[null,null,"GALAXY ON 6 OR J6 (2018) ",null,"Xperia XZ Premium"]
[null,null,"GALAXY ON 7 (2015) ",null,"Xperia L1"]
[null,null,"GALAXY ON 7 (2016) ",null,"Xperia XA1+"]
[null,null,"GALAXY ON 7 (2017) ",null,"Xperia XZ1"]
[null,null,"GALAXY ON 7 PRIME ",null,"Xperia XZ1 Compact"]
[null,null,"GALAXY ON MAX",null,"Xperia XZs"]
[null,null,"GALAXY ON NXT",null,"Xperia XA2"]
[null,null,"GALAXY XCOVER S5690",null,"Xperia XA2 Ultra"]
[null,null,"GALAXY XCOVER 2",null,"Xperia L2"]
[null,null,"GALAXY XCOVER 3",null,"Xperia XZ2"]
[null,null,"GALAXY XCOVER 3 VE",null,"Xperia XZ2 Compact"]
[null,null,"GALAXY XCOVER 4",null,"Xperia XA2 Plus"]
[null,null,"GALAXY S",null,"Xperia XZ3"]
[null,null,"GALAXY S2"]
[null,null,"GALAXY S3"]
[null,null,"GALAXY S3 MINI"]
[null,null,"GALAXY S3NEO"]
[null,null,"GALAXY S3NEO+"]
[null,null,"GALAXY S4"]
[null,null,"GALAXY S4 MINI"]
[null,null,"GALAXY S5"]
[null,null,"GALAXY S5MINI"]
[null,null,"GALAXY S5 NEO"]
[null,null,"GALAXY S6"]
[null,null,"GALAXY S6 EDGE"]
[null,null,"GALAXY S7"]
[null,null,"GALAXY S7 EDGE"]
[null,null,"GALAXY S8"]
[null,null,"GALAXY S8+"]
[null,null,"GALAXY S9"]
[null,null,"GALAXY S9+"]
[null,null,"GALAXY ACE "]
[null,null,"GALAXY ACE DUOS "]
[null,null,"GALAXY ACE PLUS "]
[null,null,"GALAXY ACE 2 "]
[null,null,"GALAXY ACE 3 "]
[null,null,"GALAXY ACE 4"]
[null,null,"GALAXY E5 "]
[null,null,"GALAXY E7"]
[null,null,"GALAXY NOTE"]
[null,null,"GALAXY NOTE EDGE"]
[null,null,"GALAXY NOTE2"]
[null,null,"GALAXY NOTE3"]
[null,null,"GALAXY NOTE4"]
[null,null,"GALAXY NOTE5"]
[null,null,"GALAXY NOTE6"]
[null,null,"GALAXY NOTE7"]
[null,null,"GALAXY NOTE8"]
[null,null,"GALAXY ALPHA"]
[null,null,"GALAXY MEGA 6.3"]
[null,null,"GALAXY TAB 2 7.0"]
[null,null,"GALAXY TAB 2 10.1"]
[null,null,"GALAXY TAB 3 8.0"]
[null,null,"GALAXY TAB 3 10.1"]
[null,null,"GALAXY TAB 4 7.0"]
[null,null,"GALAXY TAB 4 8.0"]
[null,null,"GALAXY TAB 4 10.1"]
[null,null,"GALAXY TAB S 10.5"]
[null,null,"GALAXY TAB S 8.4"]
[null,null,"GALAXY TAB S2 9.7"]
[null,null,"GALAXY TAB S2 8.0"]
[null,null,"GALAXY TAB S2 REFRESH 9.7"]
[null,null,"GALAXY TAB S2 REFRESH 8.0"]
[null,null,"GALAXY TAB S3"]
[null,null,"GALAXY TAB S4"]
[null,null,"GALAXY TAB A 8.0 (2015)"]
[null,null,"GALAXY TAB A 9.7"]
[null,null,"GALAXY TAB A 7.0 (2016)"]
[null,null,"GALAXY TAB A 10.1 (2016)"]
[null,null,"GALAXY TAB A 8.0 (2017)"]
[null,null,"GALAXY TAB A 10.5 (2018)"]
[null,null,"GALAXY TAB ACTIVE"]
[null,null,"GALAXY TAB ACTIVE2"]