{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["acc","الخلاصة","net"],"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":"acc","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["معلومات أخرى","معلومات أخرى","مقبوضات","معلومات أخرى","مبيعات","نوع العميل ",null,"اسم العميل",null,null,null,"تاريخ العملية"]
[null,null,null,null,300,"زبون",null,"احمد",null,null,null,"01.01.2018"]
[null,null,1000,null,null,"شريك",null,"احمد",null,null,null,"01.02.2018"]
[null,null,null,null,800,"زبون","`","عمر",null,null,null,"01.01.2018"]
[null,null,300,null,null,"زبون",null,"عمر",null,null,null,"01.02.2018"]
[null,null,500,null,null,"زبون",null,"محمد ",null,null,null,"02.03.2018"]
[null,null,300,null,null,"زبون",null,"احمد",null,null,null,"02.03.2018"]
[null,null,null,null,500,"زبون",null,"محمد ",null,null,null,"11.03.2018"]
[null,null,500,null,null,"زبون",null,"عمر",null,null,null,"11.03.2018"]
[null,null,null,null,1000,"شريك",null,"احمد",null,null,null,"12.03.2018"]
[null,null,null,null,900,"زبون",null,"عمر",null,null,null,"13.03.2018"]
[null,null,null,null,500,"زبون",null,"احمد",null,null,null,"14.03.2018"]
[null,null,null,null,300,"زبون",null,"محمد ",null,null,null,"15.03.2019"]
[null,null,null,null,800,"زبون",null,"عمر",null,null,null,"15.03.2018"]
[null,null,null,null,500,"زبون",null,"محمد ",null,null,null,"16.03.2018"]
[null,null,null,null,2000,"زبون",null,"محمد ",null,null,null,"13.03.2018"]
[null,null,null,null,700,"زبون",null,"عمر",null,null,null,"14.03.2018"]
[null,null,500,null,null,"زبون",null,"احمد",null,null,null,"15.03.2019"]
[null,null,null,null,300,"زبون",null,"محمد ",null,null,null,"15.03.2018"]
[null,null,null,null,800,"شريك",null,"حمزة",null,null,null,"16.03.2018"]
[null,null,null,null,1000,"زبون",null,"احمد",null,null,null,"01.01.2018"]
[null,null,null,null,1500,"زبون",null,"محمد ",null,null,null,"01.02.2018"]
[null,null,1200,null,null,"زبون",null,"عمر",null,null,null,"01.01.2018"]
[null,null,1300,null,null,"زبون",null,"عمر",null,null,null,"01.02.2018"]
[null,null,3000,null,null,"زبون",null,"محمد ",null,null,null,"02.03.2018"]
[null,null,700,null,null,"زبون",null,"احمد",null,null,null,"02.03.2018"]
[null,null,2000,null,null,"زبون",null,"محمد ",null,null,null,"11.03.2018"]
[null,null,1500,null,null,"زبون",null,"عمر",null,null,null,"11.03.2018"]
[null,null,300,null,null,"زبون",null,"احمد",null,null,null,"12.03.2018"]
[null,null,null,null,700,"زبون",null,"عمر",null,null,null,"13.03.2018"]
[null,null,700,null,null,"زبون",null,"احمد",null,null,null,"14.03.2018"]
[null,null,null,null,600,"زبون",null,"محمد ",null,null,null,"15.03.2019"]
[null,null,null,null,200,"زبون",null,"عمر",null,null,null,"15.03.2018"]
[null,null,400,null,null,"زبون",null,"محمد ",null,null,null,"16.03.2018"]
[null,null,null,null,300,"زبون",null,"محمد ",null,null,null,"13.03.2018"]
[null,null,1000,null,null,"زبون",null,"عمر",null,null,null,"14.03.2018"]
[null,null,500,null,null,"زبون",null,"احمد",null,null,null,"15.03.2019"]
[null,null,1100,null,null,"زبون",null,"محمد ",null,null,null,"15.03.2018"]
[null,null,500,null,null,"شريك",null,"حمزة",null,null,null,"16.03.2018"]
[null,null,100,null,null,"زبون",null,"بكري",null,null,null,"18.03.2019"]

{"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(acc!$B$2:$E$51,الخلاصة!D6,acc!$E$2:$E$51)-(SUMIF(acc!$B$2:$E$51,الخلاصة!D6,acc!$C$2:$C$51)))","v":0},null,"استطعت استخلاص النتائج بالمثال التالي كما يلي و لكن ان كان بالإمكان تحقيق ما ارغب به ارجو مساعدتي لشرح الفكرة و شكرا "]
[null,null,null,"محمد",{"$f":"(SUMIF(acc!$B$2:$E$51,الخلاصة!D7,acc!$E$2:$E$51)-(SUMIF(acc!$B$2:$E$51,الخلاصة!D7,acc!$C$2:$C$51)))","v":0}]
[null,null,null,"عمر",{"$f":"(SUMIF(acc!$B$2:$E$51,الخلاصة!D8,acc!$E$2:$E$51)-(SUMIF(acc!$B$2:$E$51,الخلاصة!D8,acc!$C$2:$C$51)))","v":0}]
[null,null,null,"حمزة",{"$f":"(SUMIF(acc!$B$2:$E$51,الخلاصة!D9,acc!$E$2:$E$51)-(SUMIF(acc!$B$2:$E$51,الخلاصة!D9,acc!$C$2:$C$51)))","v":0}]

{"sheet":"net","index":2,"n_rows":27,"n_cols":351,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["    حدد من هنا ماذا تريد",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,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,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,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,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,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,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,null,null,null,null,null,"شريك"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["احمد",1200]
["عمر",1700]
["محمد ",1000]
["بكري",100]