{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","الخلاصة","Repport"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Main","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["تاريخ العملية","اسم العميل","مبيعات","مقبوضات"]
["01.01.2018","احمد",300]
["01.02.2018","احمد",1000,500]
["01.01.2018","عمر",800,null,null,"`"]
["01.02.2018","عمر",null,300]
["02.03.2018","محمد ",null,500]
["02.03.2018","احمد",null,300]
["11.03.2018","محمد ",500]
["11.03.2018","عمر",null,500]
["12.03.2018","احمد",1200]
["13.03.2018","عمر",900]
["14.03.2018","احمد",500]
["15.03.2019","محمد ",300]
["15.03.2018","عمر",800]
["16.03.2018","محمد ",500]
["13.03.2018","محمد ",2000]
["14.03.2018","عمر",700]
["15.03.2019","احمد",null,500]
["15.03.2018","محمد ",300]
["16.03.2018","حمزة",800]
["01.01.2018","احمد",1000]
["01.02.2018","محمد ",1500]
["01.01.2018","عمر",null,1200]
["01.02.2018","عمر",null,1300]
["02.03.2018","محمد ",null,3000]
["02.03.2018","احمد",null,700]
["11.03.2018","محمد ",null,2000]
["11.03.2018","عمر",null,1500]
["12.03.2018","احمد",null,300]
["13.03.2018","عمر",700]
["14.03.2018","احمد",null,700]
["15.03.2019","محمد ",600]
["15.03.2018","عمر",200]
["16.03.2018","محمد ",null,400]
["13.03.2018","محمد ",300]
["14.03.2018","عمر",null,1000]
["15.03.2019","احمد",null,500]
["15.03.2018","محمد ",null,1100]
["16.03.2018","حمزة",null,500]
[]
[null,null,{"$f":"SUBTOTAL(9,C2:C40)","v":14900},{"$f":"SUBTOTAL(9,D2:D40)","v":16800}]
[]
[null,null,"للشركة عند الزبائن",null,{"$f":"C41-D41","v":-1900}]

{"sheet":"الخلاصة","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[[5,6,8,13]]}
["اسم العميل","مدين / - دائن "]
[]
[null,null,null,"المطلوب "]
[]
[]
[null,null,null,"احمد",{"$f":"(SUMIF(Main!$B$2:$D$40,الخلاصة!D6,Main!$C$2:$C$40)-(SUMIF(Main!$B$2:$D$40,الخلاصة!D6,Main!$D$2:$D$40)))","v":500},null,"استطعت استخلاص النتائج بالمثال التالي كما يلي و لكن ان كان بالإمكان تحقيق ما ارغب به ارجو مساعدتي لشرح الفكرة و شكرا "]
[null,null,null,"محمد",{"$f":"(SUMIF(Main!$B$2:$D$40,الخلاصة!D7,Main!$C$2:$C$40)-(SUMIF(Main!$B$2:$D$40,الخلاصة!D7,Main!$D$2:$D$40)))","v":0}]
[null,null,null,"عمر",{"$f":"(SUMIF(Main!$B$2:$D$40,الخلاصة!D8,Main!$C$2:$C$40)-(SUMIF(Main!$B$2:$D$40,الخلاصة!D8,Main!$D$2:$D$40)))","v":-1700}]
[null,null,null,"حمزة",{"$f":"(SUMIF(Main!$B$2:$D$40,الخلاصة!D9,Main!$C$2:$C$40)-(SUMIF(Main!$B$2:$D$40,الخلاصة!D9,Main!$D$2:$D$40)))","v":300}]

{"sheet":"Repport","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["اسم العميل","مدين / - دائن "]
["احمد",-500]
["عمر",1700]
["محمد ",1000]
["حمزة",-300]