{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["invoice","ترحيل الفواتير","codes","Customers"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":"invoice","index":0,"n_rows":163,"n_cols":13,"rows_kept":163,"cut":false,"hidden":false,"merged":[[4,2,4,3],[2,2,2,3],[162,6,162,7],[161,6,161,7],[160,6,160,7],[159,6,159,7],[1,7,4,7]]}
[]
[]
[null,null,"التاريخ",null,{"$f":"TODAY()","v":"2021-08-13"},"رقم الفاتورة",105]
[]
[null,null,"اسم العميل",null,null,"نقدي"]
[]
[]
[]
[null,null,"ترقيم",null,"اسم الصنف",null,"السعر","القيمة",null,"ترقيم الكود الصنف الكمية السعر القيمة"]
[null,null,{"$f":"IF(D10=\"\",\"\",ROW()-9)","v":""},null,{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,codes!$A$2:$E$1000,2,0))","v":""},null,{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,codes!$A$2:$E$1000,4,0))","v":""},{"$f":"IFERROR(F10*G10,\"\")","v":""},null,"1 2 ريمة حرشة 25 20 2000 40000",1,null,10]
[null,null,{"$f":"IF(D11=\"\",\"\",ROW()-9)","v":""},null,{"$f":"IF(D11=\"\",\"\",VLOOKUP(D11,codes!A3:E1001,2,0))","v":""},null,{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,codes!$A$2:$E$1000,4,0))","v":""},{"$f":"IFERROR(F11*G11,\"\")","v":""},null,"2 13 طحين ريمة 10 كلو 20 820 16400",1,null,11]
[null,null,"",null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,codes!A4:E1002,2,0))","v":""},null,{"$f":"IF($D12=\"\",\"\",VLOOKUP($D12,codes!$A$2:$E$1000,4,0))","v":""},{"$f":"IFERROR(F12*G12,\"\")","v":""},null,"5 28 سميدة رقيق 1 2550 2550",1,null,12]
[null,null,"",null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,codes!A5:E1003,2,0))","v":""},null,{"$f":"IF($D13=\"\",\"\",VLOOKUP($D13,codes!$A$2:$E$1000,4,0))","v":""},"",null,"9 698 تيد امو 18 4 2160 8640",1,null,13]
[null,null,"",null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,codes!A6:E1004,2,0))","v":""},null,{"$f":"IF($D14=\"\",\"\",VLOOKUP($D14,codes!$A$2:$E$1000,4,0))","v":""},"",null,"15 91 تاي سبع حمر 2 1800 3600",1,null,14]
[null,null,"",null,{"$f":"IF(D15=\"\",\"\",VLOOKUP(D15,codes!A7:E1005,2,0))","v":""},null,{"$f":"IF($D15=\"\",\"\",VLOOKUP($D15,codes!$A$2:$E$1000,4,0))","v":""},"",null,"16 145 فول 5 150 750",1,null,15]
[null,null,"",null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,codes!A8:E1006,2,0))","v":""},null,{"$f":"IF($D16=\"\",\"\",VLOOKUP($D16,codes!$A$2:$E$1000,4,0))","v":""},"",null,"4 590 نخالة مستفبل 25 2 1850 3700",1,null,16]
[null,null,"",null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,codes!A9:E1007,2,0))","v":""},null,{"$f":"IF($D17=\"\",\"\",VLOOKUP($D17,codes!$A$2:$E$1000,4,0))","v":""},"",null,null,1,null,17]
[null,null,"",null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,codes!A10:E1008,2,0))","v":""},null,{"$f":"IF($D18=\"\",\"\",VLOOKUP($D18,codes!$A$2:$E$1000,4,0))","v":""},"",null,"21 42 زيت ليو 1 لتر 2 3260 6520",1,null,18]
[null,null,"",null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,codes!A11:E1009,2,0))","v":""},null,{"$f":"IF($D19=\"\",\"\",VLOOKUP($D19,codes!$A$2:$E$1000,4,0))","v":""},"",null,"22 103 بريكة 1 760 760",1,null,19]
[null,null,"",null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,codes!A12:E1010,2,0))","v":""},null,{"$f":"IF($D20=\"\",\"\",VLOOKUP($D20,codes!$A$2:$E$1000,4,0))","v":""},"",null,"28 30 سكر مقرط صفر 20 120 2400",1,null,20]
[null,null,"",null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,codes!A13:E1011,2,0))","v":""},null,{"$f":"IF($D21=\"\",\"\",VLOOKUP($D21,codes!$A$2:$E$1000,4,0))","v":""},"",null,"29 25 سنيدة عبار 1 4700 4700",1,null,21]
[null,null,"",null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,codes!A14:E1012,2,0))","v":""},null,{"$f":"IF($D22=\"\",\"\",VLOOKUP($D22,codes!$A$2:$E$1000,4,0))","v":""},"",null,"23 382 بيمو درهم مخلط 1 11500 11500",1,null,22]
[null,null,"",null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,codes!A15:E1013,2,0))","v":""},null,{"$f":"IF($D23=\"\",\"\",VLOOKUP($D23,codes!$A$2:$E$1000,4,0))","v":""},"",null,"31 109 اوني نص كيلو 10 140 1400",1,null,23]
[null,null,"",null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,codes!A16:E1014,2,0))","v":""},null,{"$f":"IF($D24=\"\",\"\",VLOOKUP($D24,codes!$A$2:$E$1000,4,0))","v":""},"",null,"14 96 البلار كبير 10 1240 12400",1,null,24]
[null,null,"",null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,codes!A17:E1015,2,0))","v":""},null,{"$f":"IF($D25=\"\",\"\",VLOOKUP($D25,codes!$A$2:$E$1000,4,0))","v":""},"",null,"33 275 زبدة اديال 1 2100 2100",1,null,25]
[null,null,"",null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,codes!A18:E1016,2,0))","v":""},null,{"$f":"IF($D26=\"\",\"\",VLOOKUP($D26,codes!$A$2:$E$1000,4,0))","v":""},"",null,"27 227 كوجاك 1 700 700",1,null,26]
[null,null,"",null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,codes!A19:E1017,2,0))","v":""},null,{"$f":"IF($D27=\"\",\"\",VLOOKUP($D27,codes!$A$2:$E$1000,4,0))","v":""},"",null,"12 160 خمارة اديال 1 760 760",1,null,27]
[null,null,"",null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,codes!A20:E1018,2,0))","v":""},null,{"$f":"IF($D28=\"\",\"\",VLOOKUP($D28,codes!$A$2:$E$1000,4,0))","v":""},"",null,"11 105 ليكوش دلع كبير 8 1240 9920",1,null,28]
[null,null,"",null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,codes!A21:E1019,2,0))","v":""},null,{"$f":"IF($D29=\"\",\"\",VLOOKUP($D29,codes!$A$2:$E$1000,4,0))","v":""},"",null,"17 1 عدس 5 180 900",1,null,29]
[null,null,"",null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,codes!A22:E1020,2,0))","v":""},null,{"$f":"IF($D30=\"\",\"\",VLOOKUP($D30,codes!$A$2:$E$1000,4,0))","v":""},"",null,"35 701 جفيل ماكسيس لتر 1 1 1740 1740",1,null,30]
[null,null,"",null,{"$f":"IF(D31=\"\",\"\",VLOOKUP(D31,codes!A23:E1021,2,0))","v":""},null,{"$f":"IF($D31=\"\",\"\",VLOOKUP($D31,codes!$A$2:$E$1000,4,0))","v":""},"",null,"32 55 زبداة ليلية صغيرا 1 1800 1800",1,null,31]
[null,null,"",null,{"$f":"IF(D32=\"\",\"\",VLOOKUP(D32,codes!A24:E1022,2,0))","v":""},null,{"$f":"IF($D32=\"\",\"\",VLOOKUP($D32,codes!$A$2:$E$1000,4,0))","v":""},"",null,"30 16 صابون منجل صغر 1 840 840",1,null,32]
[null,null,"",null,{"$f":"IF(D33=\"\",\"\",VLOOKUP(D33,codes!A25:E1023,2,0))","v":""},null,{"$f":"IF($D33=\"\",\"\",VLOOKUP($D33,codes!$A$2:$E$1000,4,0))","v":""},"",null,"13 159 خميرة حبوب رفيعة 1 1200 1200",1,null,34]
[null,null,"",null,{"$f":"IF(D34=\"\",\"\",VLOOKUP(D34,codes!A26:E1024,2,0))","v":""},null,{"$f":"IF($D34=\"\",\"\",VLOOKUP($D34,codes!$A$2:$E$1000,4,0))","v":""},"",null,"34 211 حناء 10 108 1080",1,null,35]
[null,null,"",null,{"$f":"IF(D35=\"\",\"\",VLOOKUP(D35,codes!A27:E1025,2,0))","v":""},null,{"$f":"IF($D35=\"\",\"\",VLOOKUP($D35,codes!$A$2:$E$1000,4,0))","v":""},"",null,"38 215 بولة فلبس 40 66 2640",1,null,36]
[null,null,"",null,{"$f":"IF(D36=\"\",\"\",VLOOKUP(D36,codes!A28:E1026,2,0))","v":""},null,{"$f":"IF($D36=\"\",\"\",VLOOKUP($D36,codes!$A$2:$E$1000,4,0))","v":""},"",null,"6 29 سميدة غليظة 1 2650 2650",1,null,37]
[null,null,"",null,{"$f":"IF(D37=\"\",\"\",VLOOKUP(D37,codes!A29:E1027,2,0))","v":""},null,{"$f":"IF($D37=\"\",\"\",VLOOKUP($D37,codes!$A$2:$E$1000,4,0))","v":""},"",null,"20 45 زيت لوسيور 1 لتر 1 3840 3840",1,null,38]
[null,null,"",null,{"$f":"IF(D38=\"\",\"\",VLOOKUP(D38,codes!A30:E1028,2,0))","v":""},null,{"$f":"IF($D38=\"\",\"\",VLOOKUP($D38,codes!$A$2:$E$1000,4,0))","v":""},"",null,"40 62 حليب سليم صغير 6 570 3420",1,null,39]
[null,null,"",null,{"$f":"IF(D39=\"\",\"\",VLOOKUP(D39,codes!A31:E1029,2,0))","v":""},null,{"$f":"IF($D39=\"\",\"\",VLOOKUP($D39,codes!$A$2:$E$1000,4,0))","v":""},"",null,"41 480 كلنكس نيكي 4 200 800",1,null,40]
[null,null,"",null,null,null,null,null,null,"42 530 كلنكس طامبو15 4 320 1280",1,null,41]
[null,null,{"$f":"IF(NOT(ISBLANK(E41)),COUNTA(E$10:E41),\"\")","v":""},null,null,null,null,null,null,"24 381 بيمو مخلط 10 2 960 1920",1,null,42]
[null,null,{"$f":"IF(NOT(ISBLANK(E42)),COUNTA(E$10:E42),\"\")","v":""},null,null,null,null,null,null,"18 60 حمص غليظ 3 310 930",1,null,43]
[null,null,{"$f":"IF(NOT(ISBLANK(E43)),COUNTA(E$10:E43),\"\")","v":""},null,null,null,null,null,null,"19 3 مطيشة حوك صغيرا 50 33 1650",1,null,44]
[null,null,{"$f":"IF(NOT(ISBLANK(E44)),COUNTA(E$10:E44),\"\")","v":""},null,null,null,null,null,null,"7 31 سكر قلب 8 8 1920 15360",1,null,45]
[null,null,{"$f":"IF(NOT(ISBLANK(E45)),COUNTA(E$10:E45),\"\")","v":""},null,null,null,null,null,null,"8 82 تيد 18 حمر 1 2260 2260",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E46)),COUNTA(E$10:E46),\"\")","v":""},null,null,null,null,null,null,"43 228 حجرة صغير 1 360 360",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E47)),COUNTA(E$10:E47),\"\")","v":""},null,null,null,null,null,null,"37 550 خرقوم اديال صغير 2 570 1140",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E48)),COUNTA(E$10:E48),\"\")","v":""},null,null,null,null,null,null,"46 121 ملح 1 300 300",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E49)),COUNTA(E$10:E49),\"\")","v":""},null,null,null,null,null,null,"47 128 بيمو ميروندينة 1 درهم 2 1200 2400",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E50)),COUNTA(E$10:E50),\"\")","v":""},null,null,null,null,null,null,"48 364 ززوار ارديوم 3 86 258",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E51)),COUNTA(E$10:E51),\"\")","v":""},null,null,null,null,null,null,"36 125 مسكة فلاش 2 280 560",1,null,159]
[49,null,{"$f":"IF(NOT(ISBLANK(E52)),COUNTA(E$10:E52),\"\")","v":""},null,null,null,null,null,null,"49 592 ريمة فلور 25 3 2000 6000",1,null,159]
[32,null,{"$f":"IF(NOT(ISBLANK(E53)),COUNTA(E$10:E53),\"\")","v":""},null,null,null,null,null,null,"50 653 الوبية مصر 5 320 1600",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E54)),COUNTA(E$10:E54),\"\")","v":""},null,null,null,null,null,null,"51 242 بيمو ميروندينة 2 درهم 1 1560 1560",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E55)),COUNTA(E$10:E55),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E56)),COUNTA(E$10:E56),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E57)),COUNTA(E$10:E57),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E58)),COUNTA(E$10:E58),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E59)),COUNTA(E$10:E59),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E60)),COUNTA(E$10:E60),\"\")","v":""},null,null,null,null,null,null,"39 361 ماء زهر مزيان 10 90 900",1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E61)),COUNTA(E$10:E61),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E62)),COUNTA(E$10:E62),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E63)),COUNTA(E$10:E63),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E64)),COUNTA(E$10:E64),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E65)),COUNTA(E$10:E65),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E66)),COUNTA(E$10:E66),\"\")","v":""},null,null,null,null,null,null,null,1,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E67)),COUNTA(E$10:E67),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E68)),COUNTA(E$10:E68),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E69)),COUNTA(E$10:E69),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E70)),COUNTA(E$10:E70),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E71)),COUNTA(E$10:E71),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E72)),COUNTA(E$10:E72),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E73)),COUNTA(E$10:E73),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E74)),COUNTA(E$10:E74),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E75)),COUNTA(E$10:E75),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E76)),COUNTA(E$10:E76),\"\")","v":""},null,null,null,null,null,null,"45 267 كنور اديال مخلط 8 10 120 1200",null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E77)),COUNTA(E$10:E77),\"\")","v":""},null,null,null,null,null,null,"44 230 حجرة تلكموند 1 300 300",null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E78)),COUNTA(E$10:E78),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E79)),COUNTA(E$10:E79),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E80)),COUNTA(E$10:E80),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E81)),COUNTA(E$10:E81),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E82)),COUNTA(E$10:E82),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E83)),COUNTA(E$10:E83),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E84)),COUNTA(E$10:E84),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E85)),COUNTA(E$10:E85),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E86)),COUNTA(E$10:E86),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E87)),COUNTA(E$10:E87),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E88)),COUNTA(E$10:E88),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E89)),COUNTA(E$10:E89),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E90)),COUNTA(E$10:E90),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E91)),COUNTA(E$10:E91),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E92)),COUNTA(E$10:E92),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E93)),COUNTA(E$10:E93),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E94)),COUNTA(E$10:E94),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E95)),COUNTA(E$10:E95),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E96)),COUNTA(E$10:E96),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E97)),COUNTA(E$10:E97),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E98)),COUNTA(E$10:E98),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E99)),COUNTA(E$10:E99),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E100)),COUNTA(E$10:E100),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E101)),COUNTA(E$10:E101),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E102)),COUNTA(E$10:E102),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E103)),COUNTA(E$10:E103),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E104)),COUNTA(E$10:E104),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E105)),COUNTA(E$10:E105),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E106)),COUNTA(E$10:E106),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E107)),COUNTA(E$10:E107),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E108)),COUNTA(E$10:E108),\"\")","v":""},null,null,null,null,null,null,"26 127 مسكة 2 ريل 3 280 840",null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E109)),COUNTA(E$10:E109),\"\")","v":""},null,null,null,null,null,null,"25 63 حلوة 2 مخلط 5 290 1450",null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E110)),COUNTA(E$10:E110),\"\")","v":""},null,null,null,null,null,null,"10 79 تيد اريال 17 1 2320 2320",null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E111)),COUNTA(E$10:E111),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E112)),COUNTA(E$10:E112),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E113)),COUNTA(E$10:E113),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E114)),COUNTA(E$10:E114),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E115)),COUNTA(E$10:E115),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E116)),COUNTA(E$10:E116),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E117)),COUNTA(E$10:E117),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E118)),COUNTA(E$10:E118),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E119)),COUNTA(E$10:E119),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E120)),COUNTA(E$10:E120),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E121)),COUNTA(E$10:E121),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E122)),COUNTA(E$10:E122),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E123)),COUNTA(E$10:E123),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E124)),COUNTA(E$10:E124),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E125)),COUNTA(E$10:E125),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E126)),COUNTA(E$10:E126),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E127)),COUNTA(E$10:E127),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E128)),COUNTA(E$10:E128),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E129)),COUNTA(E$10:E129),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E130)),COUNTA(E$10:E130),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E131)),COUNTA(E$10:E131),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E132)),COUNTA(E$10:E132),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E133)),COUNTA(E$10:E133),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E134)),COUNTA(E$10:E134),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E135)),COUNTA(E$10:E135),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E136)),COUNTA(E$10:E136),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E137)),COUNTA(E$10:E137),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E138)),COUNTA(E$10:E138),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E139)),COUNTA(E$10:E139),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E140)),COUNTA(E$10:E140),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E141)),COUNTA(E$10:E141),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E142)),COUNTA(E$10:E142),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E143)),COUNTA(E$10:E143),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E144)),COUNTA(E$10:E144),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E145)),COUNTA(E$10:E145),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E146)),COUNTA(E$10:E146),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E147)),COUNTA(E$10:E147),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E148)),COUNTA(E$10:E148),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E149)),COUNTA(E$10:E149),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E150)),COUNTA(E$10:E150),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E151)),COUNTA(E$10:E151),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E152)),COUNTA(E$10:E152),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E153)),COUNTA(E$10:E153),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E154)),COUNTA(E$10:E154),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E155)),COUNTA(E$10:E155),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E156)),COUNTA(E$10:E156),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E157)),COUNTA(E$10:E157),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E158)),COUNTA(E$10:E158),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,{"$f":"IF(NOT(ISBLANK(E159)),COUNTA(E$10:E159),\"\")","v":""},null,null,null,null,null,null,null,null,null,159]
[null,null,null,null,null,"الإجمالي",174831,null,null,null,1]
[null,null,null,null,null,"الباقي",null,null,null,null,1]
[null,null,null,null,null,"دفع",null,null,null,null,1]
[null,null,null,null,null,"المجموع",174831,null,null,null,1]

{"sheet":"ترحيل الفواتير","index":1,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","تاريخ الفاتورة","اسم العامل","ترقيم الفاتورة","الكود الصنف","اسم الصنف","الكمية","السعر","القيمة","مجموع الفاتورة"]
[101,{"$f":"NOW()","v":"2021-08-13T08:48:34.420"},"يعقوب",1,8,"قهوة",12,27,324,{"$f":"IF(D2=1,SUMIF(A:A,A2,I:I),\"\")","v":424}]
[101,{"$f":"NOW()","v":"2021-08-13T08:48:34.420"},"يعقوب",2,6,"زيت",4,25,100,{"$f":"IF(D3=1,SUMIF(A:A,A3,I:I),\"\")","v":""}]
[103,"2021-08-13T08:48:34.420","إبراهيم",1,3,"تيد",12,22,264,564]
[103,"2021-08-13T08:48:34.420","إبراهيم",2,2,"حليب",2,21,42,""]
[103,"2021-08-13T08:48:34.420","إبراهيم",3,5,"سردين",5,24,120,""]
[103,"2021-08-13T08:48:34.420","إبراهيم",4,4,"صابون",6,23,138,""]
[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":"codes","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["الكود","اسم الصنف","الوحدة","سعر البيع","سعر الشراء"]
[1,"سكر",null,20,1]
[2,"حليب",null,21,2]
[3,"تيد",null,22,3]
[4,"صابون",null,23,4]
[5,"سردين",null,24,5]
[6,"زيت",null,25,6]
[7,"شاي",null,26,7]
[8,"قهوة",null,27,8]
[9,"زبدة",null,28,9]

{"sheet":"Customers","index":3,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
["حمادي سوق",null,null,null,null,null,300000,"صحراوي صاحب عزيز ","اجل"]
["والدشريف ستاسيون",null,null,null,null,null,null,null,"نقدي"]
["شلح ريبعة",0,null,null,null,null,"والد شريف",35200,"اجل"]
["عياد تمسنا",null,null,null,null,null,null,null,"نقدي"]
["تازي اريبعة"]
["الماموني"]
["العطار تمسنا"]
["بن الرحال"]
["محمد نور"]
["عبدالقارة "]
["براهيم"]
["اسم العامل"]
["إبراهيم"]
["يعقوب"]
["عيسى"]
["يوسف"]
["إلياس"]
["إسماعيل"]
["حسن"]
["علي"]
["زكريّا"]
["خاليد"]
["سعيد"]
["محمد"]
["عبدالطيف"]