{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["الفاتورة","مخزن الفواتير"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"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":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,10,1,12],[6,6,6,8],[29,0,30,1],[29,5,30,5],[1,0,1,2],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,5,4,5],[1,3,1,5],[3,3,4,3],[3,4,4,4],[9,9,9,11]]}
[]
[null,null,null,"عهده المشتريات والمصروفات اليوميه",null,null,null,null,null,null,"ارغب بطباعه الصفحه الحاليه فقط بدون عد الفلوس المرتجعه"]
["اليوم","الاحد","المبلغ",10000,"التاريخ","2021-10-06"]
["م","الصنف","الكمية","المجموع","اجمالي","ملاحظات"]
[]
[{"$f":"IF(B6<>\"\",_xlfn.AGGREGATE(3,3,B6:$B$6),\"\")","v":1},"سكر",41,111,{"$f":"IF(B6<>\"\",C6*D6,\"\")","v":4551},"عطار"]
[{"$f":"IF(B7<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B7),\"\")","v":2},"زيت",20,252,{"$f":"IF(B7<>\"\",C7*D7,\"\")","v":5040},"كريستال","عدد الفلوس المرتجعه"]
[{"$f":"IF(B8<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B8),\"\")","v":""},null,null,null,{"$f":"IF(B8<>\"\",C8*D8,\"\")","v":""},null,200,null,{"$f":"H8*G8","v":0}]
[{"$f":"IF(B9<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B9),\"\")","v":""},null,null,null,"",null,100,null,{"$f":"H9*G9","v":0}]
[{"$f":"IF(B10<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B10),\"\")","v":""},null,null,null,"",null,50,null,0,"هذي لا ارغب تطلع في الورق المطبوعه"]
[{"$f":"IF(B11<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B11),\"\")","v":""},null,null,null,"",null,20,null,0]
[{"$f":"IF(B12<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B12),\"\")","v":""},null,null,null,"",null,10,null,0]
[{"$f":"IF(B13<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B13),\"\")","v":""},null,null,null,"",null,5,null,0]
[{"$f":"IF(B14<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B14),\"\")","v":""},null,null,null,"",null,1,null,0]
[{"$f":"IF(B15<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B15),\"\")","v":""},null,null,null,"",null,"المتبقى",{"$f":"C31-I15","v":409},{"$f":"SUM(I8:I14)","v":0}]
[{"$f":"IF(B16<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B16),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B17<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B17),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B18<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B18),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B19<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B19),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B20<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B20),\"\")","v":""},null,null,null,{"$f":"IF(B20<>\"\",C20*D20,\"\")","v":""}]
[{"$f":"IF(B21<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B21),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B22<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B22),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B23<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B23),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B24<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B24),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B25<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B25),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B26<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B26),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B27<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B27),\"\")","v":""},null,null,null,""]
[{"$f":"IF(B28<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B28),\"\")","v":""}]
[{"$f":"IF(B29<>\"\",_xlfn.AGGREGATE(3,3,B$6:$B29),\"\")","v":""}]
["وهذي لا ارغب تطلع في الترحيل",null,"الباقي","المصروفات","الاجمالي"]
[null,null,{"$f":"D31-E31","v":409},{"$f":"D3","v":10000},{"$f":"SUM(E6:E29)","v":9591}]
[null,null,null,null,"التوقيع"]

{"sheet":"مخزن الفواتير","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,6],[21,8,21,11]]}
["مخزن الفواتير"]
["التاريخ","الكمية","السعر","الصنف","الكميه","السعر","المجموع","ملاحظات"]
["2021-10-06","2021-10-06","2021-10-06","سكر",41,111,4551,"عطار"]
["2021-10-06","2021-10-06","2021-10-06","زيت",20,252,5040,"كريستال","عدد الفلوس المرتجعه"]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,200,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,100,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,50,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,20,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,10,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,5,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,1,null,0]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,"المتبقى",409,0]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,null,null,"لو ينفع تخفي الفراغات"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06"]
["2021-10-06","2021-10-06","2021-10-06",null,"الباقي","المصروفات","الاجمالي"]
["2021-10-06","2021-10-06","2021-10-06",null,409,10000,9591]
["2021-10-06","2021-10-06","2021-10-06",null,null,null,"التوقيع"]