{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الفاتورة","الأصناف"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":10,"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":"الفاتورة","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,1],[55,0,55,2],[56,0,56,2],[57,0,57,2]]}
["إســـــــــــم ولـــــــــــــــقب الزبــــــــــــــــــــــــون:",null,null,"رقــــــــــم الفاتورة:",1]
["السيد:","أمين",null,"تاريــــخ الفاتورة:","2020-08-23"]
[",",",",",",",",","]
["الرقم","الصنف","الكمية","السعر","المجموع",null,null,"الاكتفاء فقط بإضافة الكمية المحددة دون إعادة ترحيل الصنف"]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,$B$5:B5))","v":1},"كراس 64 صفحة",3,30,{"$f":"IF(C5<>\"\",C5*D5,\"\")","v":90},null,null,"مثال: عند إضافة 02 كراس 64 صفحة إلى الفاتورة"]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$5:B6))","v":2},"كراس 96 صفحة",3,35,{"$f":"IF(C6<>\"\",C6*D6,\"\")","v":105}]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$5:B7))","v":3},"كراس 192 صفحة",6,80,480]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$5:B8))","v":4},"كراس 192 صفحة خيط",2,80,160]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$5:B9))","v":5},"كراس 120 صفحة",4,40,160]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$5:B10))","v":""},null,null,null,""]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$5:B11))","v":""},null,null,null,""]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$5:B12))","v":""},null,null,null,""]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,$B$5:B13))","v":""},null,null,null,""]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,$B$5:B14))","v":""},null,null,null,""]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,$B$5:B15))","v":""},null,null,null,""]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,$B$5:B16))","v":""},null,null,null,""]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,$B$5:B17))","v":""},null,null,null,""]
[{"$f":"IF(B18=\"\",\"\",SUBTOTAL(3,$B$5:B18))","v":""},null,null,null,""]
[{"$f":"IF(B19=\"\",\"\",SUBTOTAL(3,$B$5:B19))","v":""},null,null,null,""]
[{"$f":"IF(B20=\"\",\"\",SUBTOTAL(3,$B$5:B20))","v":""},null,null,null,""]
[{"$f":"IF(B21=\"\",\"\",SUBTOTAL(3,$B$5:B21))","v":""},null,null,null,""]
[{"$f":"IF(B22=\"\",\"\",SUBTOTAL(3,$B$5:B22))","v":""},null,null,null,""]
[{"$f":"IF(B23=\"\",\"\",SUBTOTAL(3,$B$5:B23))","v":""},null,null,null,""]
[{"$f":"IF(B24=\"\",\"\",SUBTOTAL(3,$B$5:B24))","v":""},null,null,null,""]
[{"$f":"IF(B25=\"\",\"\",SUBTOTAL(3,$B$5:B25))","v":""},null,null,null,""]
[{"$f":"IF(B26=\"\",\"\",SUBTOTAL(3,$B$5:B26))","v":""},null,null,null,""]
[{"$f":"IF(B27=\"\",\"\",SUBTOTAL(3,$B$5:B27))","v":""},null,null,null,""]
[{"$f":"IF(B28=\"\",\"\",SUBTOTAL(3,$B$5:B28))","v":""},null,null,null,""]
[{"$f":"IF(B29=\"\",\"\",SUBTOTAL(3,$B$5:B29))","v":""},null,null,null,""]
[{"$f":"IF(B30=\"\",\"\",SUBTOTAL(3,$B$5:B30))","v":""},null,null,null,""]
[{"$f":"IF(B31=\"\",\"\",SUBTOTAL(3,$B$5:B31))","v":""},null,null,null,""]
[{"$f":"IF(B32=\"\",\"\",SUBTOTAL(3,$B$5:B32))","v":""},null,null,null,""]
[{"$f":"IF(B33=\"\",\"\",SUBTOTAL(3,$B$5:B33))","v":""},null,null,null,""]
[{"$f":"IF(B34=\"\",\"\",SUBTOTAL(3,$B$5:B34))","v":""},null,null,null,""]
[{"$f":"IF(B35=\"\",\"\",SUBTOTAL(3,$B$5:B35))","v":""},null,null,null,""]
[{"$f":"IF(B36=\"\",\"\",SUBTOTAL(3,$B$5:B36))","v":""},null,null,null,""]
[{"$f":"IF(B37=\"\",\"\",SUBTOTAL(3,$B$5:B37))","v":""},null,null,null,""]
[{"$f":"IF(B38=\"\",\"\",SUBTOTAL(3,$B$5:B38))","v":""},null,null,null,""]
[{"$f":"IF(B39=\"\",\"\",SUBTOTAL(3,$B$5:B39))","v":""},null,null,null,""]
[{"$f":"IF(B40=\"\",\"\",SUBTOTAL(3,$B$5:B40))","v":""},null,null,null,""]
[{"$f":"IF(B41=\"\",\"\",SUBTOTAL(3,$B$5:B41))","v":""},null,null,null,""]
[{"$f":"IF(B42=\"\",\"\",SUBTOTAL(3,$B$5:B42))","v":""},null,null,null,""]
[{"$f":"IF(B43=\"\",\"\",SUBTOTAL(3,$B$5:B43))","v":""},null,null,null,""]
[{"$f":"IF(B44=\"\",\"\",SUBTOTAL(3,$B$5:B44))","v":""},null,null,null,""]
[{"$f":"IF(B45=\"\",\"\",SUBTOTAL(3,$B$5:B45))","v":""},null,null,null,""]
[{"$f":"IF(B46=\"\",\"\",SUBTOTAL(3,$B$5:B46))","v":""},null,null,null,""]
[{"$f":"IF(B47=\"\",\"\",SUBTOTAL(3,$B$5:B47))","v":""},null,null,null,""]
[{"$f":"IF(B48=\"\",\"\",SUBTOTAL(3,$B$5:B48))","v":""},null,null,null,""]
[{"$f":"IF(B49=\"\",\"\",SUBTOTAL(3,$B$5:B49))","v":""},null,null,null,""]
[{"$f":"IF(B50=\"\",\"\",SUBTOTAL(3,$B$5:B50))","v":""},null,null,null,""]
[{"$f":"IF(B51=\"\",\"\",SUBTOTAL(3,$B$5:B51))","v":""},null,null,null,""]
[{"$f":"IF(B52=\"\",\"\",SUBTOTAL(3,$B$5:B52))","v":""},null,null,null,""]
[{"$f":"IF(B53=\"\",\"\",SUBTOTAL(3,$B$5:B53))","v":""},null,null,null,""]
[{"$f":"IF(B54=\"\",\"\",SUBTOTAL(3,$B$5:B54))","v":""},null,null,null,""]
[{"$f":"IF(B55=\"\",\"\",SUBTOTAL(3,$B$5:B55))","v":""},null,null,null,""]
[null,null,null,"المجمــــــــــــــــــوع:",{"$f":"SUM(E5:E55)","v":995}]

{"sheet":"الأصناف","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["قائمة الأصنـــاف وســعر البــيع ( جمــلة، نـصف جمـلة و تجزئة)"]
["الرقم","المادة","الثمن",1,"تجزئة","نصف جملة ","جملة",null,"الكمية","القيمة"]
[1,"كراس 64 صفحة",{"$f":"IF($D$2=1,E3,IF($D$2=2,F3,IF($D$2=3,G3,\"\")))","v":30},null,30,22,"21,07",null,513,10808]
[2,"كراس 96 صفحة",35,null,35,27,"26,30",null,73,1920]
[{"$f":"IF(B5=\"\",\"\",SUBTOTAL(3,$B$3:B5))","v":3},"كراس 120 صفحة",40,null,40,33,31.49,null,500,{"$f":"G5*I5","v":15745}]
[{"$f":"IF(B6=\"\",\"\",SUBTOTAL(3,$B$3:B6))","v":4},"كراس 192 صفحة",80,null,80,70,58.22,null,216,12575.52]
[{"$f":"IF(B7=\"\",\"\",SUBTOTAL(3,$B$3:B7))","v":5},"كراس 192 صفحة خيط",80,null,80,74,69.989999999999995,null,70,4899.2999999999993]