{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["اليومية","ورقة2","حسب_الشهر"],"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":"اليومية","index":0,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["الشهر","العميل","رقم الفاتورة","دائن","مدين"]
["2018-01-01","علي","001/01",5000]
["2018-02-01","علي","001/02",null,300]
["2018-03-01","سمير","001/03",8000]
["2018-01-01","سمير","002/01",3000]
["2018-02-01","علي","002/02",14000]
["2018-03-01","علي","002/03",9000]
["2018-01-01","رضا","003/01",1500]
["2018-02-01","رضا","003/02",8000]
["2018-03-01","رضا","003/03",null,1500]
["2018-01-01","علي","004/01",6000]
["2018-02-01","سمير","004/02",null,600]
["2018-03-01","رضا","004/03",2000]
["2018-01-01","رضا","005/01",8000]
["2018-02-01","رضا","005/02",null,1000]
["2018-03-01","علي","005/03",null,3000]
["2018-01-01","سمير","006/01",null,1000]
["2018-02-01","سمير","006/02",2500]
["2018-03-01","سمير","006/03",4200]
["2018-01-01","علي","007/01",null,1200]
["2018-02-01","سمير","007/02",300]
["2018-03-01","سمير","007/03",null,1200]
["2018-01-01","رضا","008/01",4000]
["2018-02-01","علي","008/02",900]
["2018-03-01","علي","008/03",null,1000]
["2018-01-01","سمير","009/01",2000]
["2018-02-01","علي","009/02",1500]
["2018-03-01","رضا","009/03",null,1000]
["2018-01-01","سمير","010/01",null,500]
["2018-02-01","سمير","010/02",2600]
["2018-03-01","سمير","010/03",8000]
["2018-01-01","رضا","011/01",null,750]
["2018-02-01","رضا","011/02",2200]
["2018-03-01","رضا","011/03",4000]
["2018-01-01","رضا","012/01",1100]
["2018-02-01","علي","012/02",500]
["2018-03-01","علي","012/03",5100]
["2018-01-01","علي","013/01",8000]
["2018-02-01","رضا","013/02",null,800]
["2018-03-01","رضا","013/03",null,600]
["2018-01-01","رضا","014/01",null,8500]
["2018-02-01","سمير","014/02",null,940]
["2018-03-01","علي","014/03",null,1200]
["2018-01-01","سمير","015/01",900]
["2018-02-01","رضا","015/02",500]
["2018-03-01","سمير","015/03",null,400]

{"sheet":"ورقة2","index":1,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"2018-01-01","فواتير شهر "]
[]
[null,"رقم الفاتورة","دائن","مدين"]
[null,"001/01",5000]
[null,"002/01",3000]
[null,"003/01",1500]
[null,"004/01",6000]
[null,"005/01",8000]
[null,"006/01",null,1000]
[null,"007/01",null,1200]
[null,"008/01",4000]
[null,"009/01",2000]
[null,"010/01",null,500]
[null,"011/01",null,750]
[null,"012/01",1100]
[null,"013/01",8000]
[null,"014/01",null,8500]
[null,"015/01",900]
[]
[null,null,{"$f":"SUM(C30:C44)","v":33000}]
[null,"2018-02-01","فواتير شهر "]
[]
[null,"رقم الفاتورة","دائن","مدين"]
[null,"001/02",null,300]
[null,"002/02",14000]
[null,"003/02",8000]
[null,"004/02",null,600]
[null,"005/02",null,1000]
[null,"006/02",2500]
[null,"007/02",300]
[null,"008/02",900]
[null,"009/02",1500]
[null,"010/02",2600]
[null,"011/02",2200]
[null,"012/02",500]
[null,"013/02",null,800]
[null,"014/02",null,940]
[null,"015/02",500]
[]
[]
[null,"2018-03-01","فواتير شهر "]
[]
[null,"رقم الفاتورة","دائن","مدين"]
[null,"001/03",8000]
[null,"002/03",9000]
[null,"003/03",null,1500]
[null,"004/03",2000]
[null,"005/03",null,3000]
[null,"006/03",4200]
[null,"007/03",null,1200]
[null,"008/03",null,1000]
[null,"009/03",null,1000]
[null,"010/03",8000]
[null,"011/03",4000]
[null,"012/03",5100]
[null,"013/03",null,600]
[null,"014/03",null,1200]
[null,"015/03",null,400]

{"sheet":"حسب_الشهر","index":2,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"ممكن تغيير المدى عن طريق الإضافة من بيانات التحقق من الصحة قائمة "]
[null,null,null,null,null,null,null,null,null,"تحت العمود j"]
[null,null,"2018-02-01",null,null,null,null,null,null,"الشهر","العميل"]
[null,null,null,null,{"$f":"SUM(E7:E5000)","v":33000},{"$f":"SUM(F7:F5000)","v":3640},null,null,null,"2018-01-01","رضا"]
[null,null,"رقم الفاتورة","العميل","دائن","مدين",null,null,null,"2018-02-01","سمير"]
[null,null,"001/02","علي",null,300,null,null,null,"2018-03-01","علي"]
[null,null,"002/02","علي",14000]
[null,null,"003/02","رضا",8000]
[null,null,"004/02","سمير",null,600]
[null,null,"005/02","رضا",null,1000]
[null,null,"006/02","سمير",2500]
[null,null,"007/02","سمير",300]
[null,null,"008/02","علي",900]
[null,null,"009/02","علي",1500]
[null,null,"010/02","سمير",2600]
[null,null,"011/02","رضا",2200]
[null,null,"012/02","علي",500]
[null,null,"013/02","رضا",null,800]
[null,null,"014/02","سمير",null,940]
[null,null,"015/02","رضا",500]