{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["مخطط1","Haraka","Takrir"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"مخطط1","index":0,"reason":"not_a_worksheet"}],"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":"Haraka","index":1,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"حركة الحسابات  للفترة من 01-01 إلى 31-12-2016"]
[null,"رقم الفاتورة","تاريخ الفاتورة","المدين","الدائن"]
["عميل9",204,"2016-01-05",4812.6899999999996]
["عميل15",206,"2016-01-05",2155.1680000000001]
["عميل11",193,"2016-01-07",1792.98]
["عميل14",85945,"2016-01-12",3661.625]
["عميل5",85946,"2016-01-12",2295.25]
["عميل12",86554,"2016-01-23",5668.5]
["عميل11",86619,"2016-01-24",7705.375]
["عميل1",244,"2016-01-23",5013.55]
["عميل2",251,"2016-01-24",4688.95]
["عميل5",252,"2016-01-24",2155.1680000000001]
["عميل9",2766,"2016-01-25",null,30514.777999999998]
["عميل5",266,"2016-02-01",2825.5]
["عميل9",305,"2016-02-11",4766.07]
["عميل7",2911,"2016-02-20",null,30882.543000000001]
["عميل18",326,"2016-02-21",4812.6899999999996]
["عميل4",327,"2016-02-21",2070.4580000000001]
["عميل18",88342,"2016-02-22",5246.5]
["عميل13",88539,"2016-02-24",2186]
["عميل5",342,"2016-02-28",1760.288]
["عميل14",367,"2016-03-06",5344.1329999999998]
["عميل12",89515,"2016-03-07",6524.1850000000004]
["عميل14",89521,"2016-03-07",33553.25]
["عميل12",3058,"2016-03-08",null,19081.718000000001]
["عميل9",381,"2016-03-09",20190.187999999998]
["عميل8",3098,"2016-03-15",null,47181.856]
["عميل19",90164,"2016-03-15",9454.375]
["عميل8",391,"2016-03-15",4960.6229999999996]
["عميل19",90582,"2016-03-21",6512.5]
["عميل1",400,"2016-03-21",2724.5079999999998]
["عميل12",414,"2016-03-27",4766.07]
["عميل5",91148,"2016-03-29",8853.25]
["عميل10",426,"2016-03-31",3273.12]
["عميل8",446,"2016-04-05",4859.8100000000004]
["عميل8",3254,"2016-04-06",null,60740.514000000003]
["عميل13",482,"2016-04-17",1936.45]
["عميل12",485,"2016-04-17",4688.95]
["عميل1",92294,"2016-04-18",5246.5]
["عميل2",502,"2016-04-26",4983.55]
["عميل12",507,"2016-04-27",2668.0129999999999]
["عميل15",93035,"2016-04-28",2514.25]
["عميل8",93036,"2016-04-28",11913.25]
["عميل13",93048,"2016-04-28",7104.25]
["عميل9",93077,"2016-04-30",1849.5]
["عميل12",93839,"2016-05-11",9235.375]
["عميل6",544,"2016-05-10",5013.55]
["عميل2",3425,"2016-05-03",null,27656.393]
["عميل15",3477,"2016-05-10",null,23381.25]
["عميل11",94836,"2016-05-24",10483.5]
["عميل10",94830,"2016-05-24",16831.5]
["عميل3",94734,"2016-05-24",1809]
["عميل20",3616,"2016-05-26",null,14248.924999999999]
["عميل6",580,"2016-05-24",3659.143]
["عميل17",585,"2016-05-24",4812.6899999999996]
["عميل14",591,"2016-05-24",4983.55]
["عميل16",599,"2016-05-31",2915.4830000000002]
["عميل6",600,"2016-05-31",2223.2950000000001]

{"sheet":"Takrir","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,0,24,1],[26,4,26,6],[0,1,1,2]]}
[null,"كشف حركة الديون للفترة :",null,"من","الي"]
[null,null,null,"2016-01-30","2016-05-31"]
[]
["ت","العملاء","رصيد اول مدة","الحركة المدينة","الحركة الدائنة","صافي الدين","عدد الحركات"]
[1,"عميل1",null,7971.0079999999998,null,7971.0079999999998,2]
[2,"عميل2",null,4983.55,27656.393,-22672.843000000001,2]
[3,"عميل3",null,1809,null,1809,1,null,null,null,null,"  "]
[4,"عميل4",null,2070.4580000000001,null,2070.4580000000001,1]
[5,"عميل5",null,13439.038,null,13439.038,3]
[6,"عميل6",null,10895.987999999999,null,10895.987999999999,3]
[7,"عميل7",null,null,30882.543000000001,-30882.543000000001,1]
[8,"عميل8",null,21733.683000000001,107922.37,-86188.686999999991,5]
[9,"عميل9",null,26805.757999999998,null,26805.758000000002,3]
[10,"عميل10",null,20104.62,null,20104.62,2]
[11,"عميل11",null,10483.5,null,10483.5,1]
[12,"عميل12",null,27882.593000000001,19081.718000000001,8800.875,6]
[13,"عميل13",null,11226.7,null,11226.7,3]
[14,"عميل14",null,43880.933000000005,null,43880.932999999997,3]
[15,"عميل15",null,2514.25,23381.25,-20867,2]
[16,"عميل16",null,2915.4830000000002,null,2915.4830000000002,1]
[17,"عميل17"]
[18,"عميل18"]
[19,"عميل19"]
[20,"عميل20"]
["الاجمالي الكلي",null,{"$f":"SUBTOTAL(9,C5:C24)","v":0},{"$f":"SUBTOTAL(9,D5:D24)","v":208716.56200000003},{"$f":"SUBTOTAL(9,E5:E24)","v":208924.27399999998},{"$f":"SUBTOTAL(9,F5:F24)","v":-207.7119999999959}]
[]
[null,null,null,null,"لجنة الديون / ............................."]