{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["print","DATA","amin","Name 1","Name 2","Name 3","Name 4","Name 5","Name 6","Name 7","Name 8","Officena"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":21,"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":"print","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["العميل :","حاتم"]
[]
["التاريخ","البيـــــــــــــــــــــــــــــــــــان","مدين","دائن"]
[]
["2016-09-06","120 كيلو مطابخ ألوان 1520 - 3050",1200,0]
["2021-01-03","مدفوعات من الحساب",null,800]
[]
[null,"اجمالي",1200,800]
[null,"الصــافي ..... مدين",400]

{"sheet":"DATA","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"أدخل اسم الحساب","Officena"]
[]
["حساب العميل","مدين","دائن","البيان","التاريخ","إجمالي المبالغ المدينة","إجمالي المبالغ الدائنة","قائمة بدون تكرار ومرتبة أبجديا"]
["Name 5",492,236,"150 كيلو 15060","2016-09-03",{"$f":"IF($H6=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H6)*(B$6:B$200)))","v":200},{"$f":"IF($H6=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H6)*(C$6:C$200)))","v":30},"amin"]
["Name 4",71,24,"مدفوعات من الحساب","2016-09-04",{"$f":"IF($H7=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H7)*(B$6:B$200)))","v":305},{"$f":"IF($H7=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H7)*(C$6:C$200)))","v":787},"Name 1"]
["Name 3",262,390,"مواصلات - غذاء - نثريات","2016-09-04",670,503,"Name 2"]
["Name 2",326,308,"60 كيلو لون 3050","2016-09-04",307,661,"Name 3"]
["Name 2",48,147,"50 كيلو لون س س س","2016-09-05",71,24,"Name 4"]
["Name 2",296,48,"30 كيلو لون ش ش ش","2016-09-05",492,236,"Name 5"]
["Name 6",378,278,"40 كيلو لون م م م م ","2016-09-05",779,359,"Name 6"]
["Name 8",382,131,"مدفوعات من الحساب","2016-09-05",407,128,"Name 7"]
["Name 3",45,271,"مواصلات - غذاء - نثريات","2016-09-05",382,131,"Name 8"]
["Name 7",407,128,"مدفوعات من الحساب","2016-09-05",180,70,"Officena"]
["Name 6",401,81,"75 كيلو لون ض ض ض","2016-09-05",{"$f":"IF($H16=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H16)*(B$6:B$200)))","v":""},{"$f":"IF($H16=\"\",\"\",SUMPRODUCT(($A$6:$A$200=$H16)*(C$6:C$200)))","v":""}]
["Name 1",145,448,"مدفوعات من الحساب","2016-09-05","",""]
["Name 1",160,339,"300 كيلو لون ه و م ن ت ","2016-09-06","",""]
["Officena",180,70,"300 كيلو لون ه و م ن ت ","2016-09-06","",""]
["amin",200,30,"sdf",null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]
[null,null,null,null,null,"",""]

{"sheet":"amin","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"amin"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,null,"sdf",200,30]
[null,null,null,"SUM",200,30]
[null,null,null,"TOTAL",170]

{"sheet":"Name 1","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 1"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-05","مدفوعات من الحساب",145,448]
[2,null,"2016-09-06","300 كيلو لون ه و م ن ت ",160,339]
[null,null,null,"SUM",305,787]
[null,null,null,"TOTAL",-482]

{"sheet":"Name 2","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 2"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-04","60 كيلو لون 3050",326,308]
[2,null,"2016-09-05","50 كيلو لون س س س",48,147]
[3,null,"2016-09-05","30 كيلو لون ش ش ش",296,48]
[null,null,null,"SUM",670,503]
[null,null,null,"TOTAL",167]

{"sheet":"Name 3","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 3"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-04","مواصلات - غذاء - نثريات",262,390]
[2,null,"2016-09-05","مواصلات - غذاء - نثريات",45,271]
[null,null,null,"SUM",307,661]
[null,null,null,"TOTAL",-354]

{"sheet":"Name 4","index":6,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 4"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-04","مدفوعات من الحساب",71,24]
[null,null,null,"SUM",71,24]
[null,null,null,"TOTAL",47]

{"sheet":"Name 5","index":7,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 5"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-03","150 كيلو 15060",492,236]
[null,null,null,"SUM",492,236]
[null,null,null,"TOTAL",256]

{"sheet":"Name 6","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 6"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-05","40 كيلو لون م م م م ",378,278]
[2,null,"2016-09-05","75 كيلو لون ض ض ض",401,81]
[null,null,null,"SUM",779,359]
[null,null,null,"TOTAL",420]

{"sheet":"Name 7","index":9,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 7"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-05","مدفوعات من الحساب",407,128]
[null,null,null,"SUM",407,128]
[null,null,null,"TOTAL",279]

{"sheet":"Name 8","index":10,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Name 8"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-05","مدفوعات من الحساب",382,131]
[null,null,null,"SUM",382,131]
[null,null,null,"TOTAL",251]

{"sheet":"Officena","index":11,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Officena"]
[]
[]
[]
[null,null,"التاريخ","البيان","مدين","دائن"]
[1,null,"2016-09-06","300 كيلو لون ه و م ن ت ",180,70]
[null,null,null,"SUM",180,70]
[null,null,null,"TOTAL",110]