{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Invoice","Transfer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,9,20,10],[19,5,20,8],[2,5,2,6],[2,3,2,4],[4,1,4,2],[5,1,5,2],[6,1,6,2],[4,8,4,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[7,1,7,2],[4,4,4,5],[5,4,5,5],[18,0,18,2],[18,3,18,10],[6,4,6,5],[0,0,1,2]]}
[]
[]
[null,null,null,20196001,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,"عنوان الشحن :"]
[]
["م","أسم الصنف","الكمية ","نوع الوحدة","السعر  قبل الضريبة ","الضريبة 14% ","السعر بعد الضريبة","خصم الحمولة","خصم نقدي","السعر بعد الخصم","اجمالى القيمة"]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$11:B11))","v":""},null,null,null,null,{"$f":"$E11*14%","v":0},{"$f":"$E11+$F11","v":0},null,null,{"$f":"$G11-($H11+$I11)","v":0},{"$f":"$C11*$J11","v":0}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$11:B12))","v":""},null,null,null,null,{"$f":"$E12*14%","v":0},{"$f":"$E12+$F12","v":0},null,null,{"$f":"$G12-($H12+$I12)","v":0},{"$f":"$C12*$J12","v":0}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,$B$11:B13))","v":""},null,null,null,null,0,0,null,null,0,{"$f":"$C13*$J13","v":0}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,$B$11:B14))","v":""},null,null,null,null,0,0,null,null,0,0]
[{"$f":"IF(B15=\"\",\"\",SUBTOTAL(3,$B$11:B15))","v":""},null,null,null,null,0,0,null,null,0,0]
[{"$f":"IF(B16=\"\",\"\",SUBTOTAL(3,$B$11:B16))","v":""},null,null,null,null,0,0,null,null,0,0]
[{"$f":"IF(B17=\"\",\"\",SUBTOTAL(3,$B$11:B17))","v":""},null,null,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K17)","v":0}]
["اجمـــالى المستحق ",null,null,{"$f":"CurrText($K$18,1,\"جنيهاً\",\"جنيهات\",1,\"قرشاً\",\"قروش\",2)","v":"ХЭС جنيهاً"}]
[null,null,null,null,null,"............................................",null,null,null,"توقيع المستلم"]

{"sheet":"Transfer","index":1,"n_rows":8,"n_cols":20,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["رقم الفاتورة","كود العميل","اسم العميل","عنوان العميل","عنوان الشحن","تاريخ الفاتورة","تاريخ الاستحقاق","تاريخ التسليم","طريقة الدفع ","م","أسم الصنف","الكمية ","نوع الوحدة","السعر  قبل الضريبة ","الضريبة 14% ","السعر بعد الضريبة","خصم الحمولة","خصم نقدي","السعر بعد الخصم","اجمالى القيمة"]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",1,"للللللل",10,"فففففف",20,2.8000000000000003,22.8,1,2,19.8,6711.84]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",2,"غغغغغ",15,"ممممممم",30,4.2,34.200000000000003,3,2,29.200000000000003]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",3,"تتتتتت",17,"ششششششش",40,5.6000000000000005,45.6,2,4,39.6]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",4,"مممممم",18,"ءءءءءءءء",50,7.0000000000000009,57,3,5,49]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",5,"ىىىىىىىىى",20,"ىىىىىىىىى",60,8.4,68.400000000000006,1,6,61.400000000000006]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",6,"ةةةةةةةة",21,"تتتتتتتت",70,9.8000000000000007,79.8,4,2,73.8]
[20196000,1001,"رضا سعد","الفجالة","العتبة","2018-06-01","2018-10-12","2018-10-15","نقدى",7,"ئئئئئئئئئ",22,"غغغغغغغغغغغ",73,10.220000000000001,83.22,3,1,79.22]