{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["يناير","فبراير","مارس","ابريل","مايو","يونيو","يوليو","اغسطس","سبتمبر","اكتوبر","نوفمبر","ديسمبر","البيان المجمع","ملاحظات"],"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":"يناير","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-01-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-01-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-01-03","محمود السيد",200,"سدد",330]
["2020-01-04","عبد الله فراج",340,"لم يسدد",561]
["2020-01-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-01-06","على عبد الله صابر",1700,"سدد",2805]
["2020-01-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-01-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-01-09","على عبد الله صابر",3334,"سدد",5501.0999999999995]
["2020-01-10","احمد محمد مرزوق",444,"لم يسدد",732.59999999999991]
["2020-01-11","على عبد الله صابر",55,"سدد",90.75]

{"sheet":"فبراير","index":1,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-02-01","هبة محمد",100,"سدد",{"$f":"C4*1.65","v":165}]
["2020-02-02","مصطفى السيد",230,"سدد",{"$f":"C5*1.65","v":379.5}]
["2020-02-03","محمد مرتجى",400,"سدد",660]
["2020-02-04","احمد السيد",500,"لم يسدد",825]
["2020-02-05","السيد احمد السيد",600,"سدد",990]
["2020-02-06","هند الشوبكى",990,"سدد",1633.5]

{"sheet":"مارس","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-03-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-03-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-03-03","محمود السيد",200,"سدد",330]
["2020-03-04","عبد الله فراج",340,"لم يسدد",561]
["2020-03-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-03-06","على عبد الله صابر",1700,"سدد",2805]
["2020-03-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-03-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"ابريل","index":3,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-04-01","محمد السيد احمد",400,"سدد",230]

{"sheet":"مايو","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-05-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-05-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-05-03","محمود السيد",200,"سدد",330]
["2020-05-04","عبد الله فراج",340,"لم يسدد",561]
["2020-05-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-05-06","على عبد الله صابر",1700,"سدد",2805]
["2020-05-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-05-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-05-09","محمود الشويحى",1000,"سدد",1650]

{"sheet":"يونيو","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-06-01","محمد على",300,"سدد",{"$f":"C4*1.65","v":495}]
["2020-06-02","على محمد على",400,"سدد",{"$f":"C5*1.65","v":660}]
["2020-06-03","محمود السيد",200,"سدد",330]
["2020-06-04","عبد الله فراج",340,"لم يسدد",561]
["2020-06-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-06-06","على عبد الله صابر",1700,"سدد",2805]
["2020-06-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-06-08","كريم احمد السيد",4000,"لم يسدد",6600]

{"sheet":"يوليو","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["يوليو"]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-07-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-07-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-07-03","محمود السيد",200,"سدد",330]
["2020-07-04","عبد الله فراج",340,"لم يسدد",561]
["2020-07-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-07-06","على عبد الله صابر",1700,"سدد",2805]
["2020-07-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-07-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"اغسطس","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-08-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-08-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-08-03","محمود السيد",200,"سدد",330]
["2020-08-04","عبد الله فراج",340,"لم يسدد",561]
["2020-08-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-08-06","على عبد الله صابر",1700,"سدد",2805]
["2020-08-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-08-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"سبتمبر","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-09-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-09-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-09-03","محمود السيد",200,"سدد",330]
["2020-09-04","عبد الله فراج",340,"لم يسدد",561]
["2020-09-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-09-06","على عبد الله صابر",1700,"سدد",2805]
["2020-09-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-09-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"اكتوبر","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-10-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-10-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-10-03","محمود السيد",200,"سدد",330]
["2020-10-04","عبد الله فراج",340,"لم يسدد",561]
["2020-10-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-10-06","على عبد الله صابر",1700,"سدد",2805]
["2020-10-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-10-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"نوفمبر","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-11-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-11-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-11-03","محمود السيد",200,"سدد",330]
["2020-11-04","عبد الله فراج",340,"لم يسدد",561]
["2020-11-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-11-06","على عبد الله صابر",1700,"سدد",2805]
["2020-11-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-11-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"ديسمبر","index":11,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-12-01","محمد على",20,"سدد",{"$f":"C4*1.65","v":33}]
["2020-12-02","على محمد على",150,"سدد",{"$f":"C5*1.65","v":247.5}]
["2020-12-03","محمود السيد",200,"سدد",330]
["2020-12-04","عبد الله فراج",340,"لم يسدد",561]
["2020-12-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-12-06","على عبد الله صابر",1700,"سدد",2805]
["2020-12-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-12-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"البيان المجمع","index":12,"n_rows":94,"n_cols":5,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[]
[]
["التاريخ","اسم العميل","المبلغ","حالة السداد","القيمة بعد الضريبة"]
["2020-01-01","محمد على",20,"سدد",33]
["2020-01-02","على محمد على",150,"سدد",247.5]
["2020-01-03","محمود السيد",200,"سدد",330]
["2020-01-04","عبد الله فراج",340,"لم يسدد",561]
["2020-01-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-01-06","على عبد الله صابر",1700,"سدد",2805]
["2020-01-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-01-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-01-09","على عبد الله صابر",3334,"سدد",5501.0999999999995]
["2020-01-10","احمد محمد مرزوق",444,"لم يسدد",732.59999999999991]
["2020-01-11","على عبد الله صابر",55,"سدد",90.75]
["2020-02-01","هبة محمد",100,"سدد",165]
["2020-02-02","مصطفى السيد",230,"سدد",379.5]
["2020-02-03","محمد مرتجى",400,"سدد",660]
["2020-02-04","احمد السيد",500,"لم يسدد",825]
["2020-02-05","السيد احمد السيد",600,"سدد",990]
["2020-02-06","هند الشوبكى",990,"سدد",1633.5]
["2020-03-01","محمد على",20,"سدد",33]
["2020-03-02","على محمد على",150,"سدد",247.5]
["2020-03-03","محمود السيد",200,"سدد",330]
["2020-03-04","عبد الله فراج",340,"لم يسدد",561]
["2020-03-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-03-06","على عبد الله صابر",1700,"سدد",2805]
["2020-03-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-03-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-04-01","محمد السيد احمد",400,"سدد",230]
["2020-05-01","محمد على",20,"سدد",33]
["2020-05-02","على محمد على",150,"سدد",247.5]
["2020-05-03","محمود السيد",200,"سدد",330]
["2020-05-04","عبد الله فراج",340,"لم يسدد",561]
["2020-05-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-05-06","على عبد الله صابر",1700,"سدد",2805]
["2020-05-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-05-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-05-09","محمود الشويحى",1000,"سدد",1650]
["2020-06-01","محمد على",300,"سدد",495]
["2020-06-02","على محمد على",400,"سدد",660]
["2020-06-03","محمود السيد",200,"سدد",330]
["2020-06-04","عبد الله فراج",340,"لم يسدد",561]
["2020-06-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-06-06","على عبد الله صابر",1700,"سدد",2805]
["2020-06-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-06-08","كريم احمد السيد",4000,"لم يسدد",6600]
["2020-07-01","محمد على",20,"سدد",33]
["2020-07-02","على محمد على",150,"سدد",247.5]
["2020-07-03","محمود السيد",200,"سدد",330]
["2020-07-04","عبد الله فراج",340,"لم يسدد",561]
["2020-07-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-07-06","على عبد الله صابر",1700,"سدد",2805]
["2020-07-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-07-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-08-01","محمد على",20,"سدد",33]
["2020-08-02","على محمد على",150,"سدد",247.5]
["2020-08-03","محمود السيد",200,"سدد",330]
["2020-08-04","عبد الله فراج",340,"لم يسدد",561]
["2020-08-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-08-06","على عبد الله صابر",1700,"سدد",2805]
["2020-08-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-08-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-09-01","محمد على",20,"سدد",33]
["2020-09-02","على محمد على",150,"سدد",247.5]
["2020-09-03","محمود السيد",200,"سدد",330]
["2020-09-04","عبد الله فراج",340,"لم يسدد",561]
["2020-09-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-09-06","على عبد الله صابر",1700,"سدد",2805]
["2020-09-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-09-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-10-01","محمد على",20,"سدد",33]
["2020-10-02","على محمد على",150,"سدد",247.5]
["2020-10-03","محمود السيد",200,"سدد",330]
["2020-10-04","عبد الله فراج",340,"لم يسدد",561]
["2020-10-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-10-06","على عبد الله صابر",1700,"سدد",2805]
["2020-10-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-10-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-11-01","محمد على",20,"سدد",33]
["2020-11-02","على محمد على",150,"سدد",247.5]
["2020-11-03","محمود السيد",200,"سدد",330]
["2020-11-04","عبد الله فراج",340,"لم يسدد",561]
["2020-11-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-11-06","على عبد الله صابر",1700,"سدد",2805]
["2020-11-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-11-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]
["2020-12-01","محمد على",20,"سدد",33]
["2020-12-02","على محمد على",150,"سدد",247.5]
["2020-12-03","محمود السيد",200,"سدد",330]
["2020-12-04","عبد الله فراج",340,"لم يسدد",561]
["2020-12-05","مصطفى محمد الفقى",290,"سدد",478.5]
["2020-12-06","على عبد الله صابر",1700,"سدد",2805]
["2020-12-07","احمد محمد مرزوق",399,"سدد",658.34999999999991]
["2020-12-08","كريم احمد السيد",209,"لم يسدد",344.84999999999997]

{"sheet":"ملاحظات","index":13,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["م","اسم الملاحظة"]