{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["مخطط1","الحركة","التقرير"],"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":"الحركة","index":1,"n_rows":746,"n_cols":5,"rows_kept":746,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"حركة الحسابات  للفترة من 01-01 إلى 31-12-2016"]
[null,"رقم الفاتورة","تاريخ الفاتورة","المدين","الدائن"]
["عميل15",204,"2016-01-05",4812.6899999999996]
["عميل18",206,"2016-01-05",2155.1680000000001]
["عميل12",193,"2016-01-07",1792.98]
["عميل19",85945,"2016-01-12",3661.625]
["عميل20",85946,"2016-01-12",2295.25]
["عميل17",86554,"2016-01-23",5668.5]
["عميل2",86619,"2016-01-24",7705.375]
["عميل14",244,"2016-01-23",5013.55]
["عميل5",251,"2016-01-24",4688.95]
["عميل3",252,"2016-01-24",2155.1680000000001]
["عميل14",2766,"2016-01-25",null,30514.777999999998]
["عميل14",266,"2016-02-01",2825.5]
["عميل13",305,"2016-02-11",4766.07]
["عميل6",2911,"2016-02-20",null,30882.543000000001]
["عميل6",326,"2016-02-21",4812.6899999999996]
["عميل10",327,"2016-02-21",2070.4580000000001]
["عميل17",88342,"2016-02-22",5246.5]
["عميل2",88539,"2016-02-24",2186]
["عميل16",342,"2016-02-28",1760.288]
["عميل17",367,"2016-03-06",5344.1329999999998]
["عميل20",89515,"2016-03-07",6524.1850000000004]
["عميل15",89521,"2016-03-07",33553.25]
["عميل6",3058,"2016-03-08",null,19081.718000000001]
["عميل14",381,"2016-03-09",20190.187999999998]
["عميل4",3098,"2016-03-15",null,47181.856]
["عميل16",90164,"2016-03-15",9454.375]
["عميل13",391,"2016-03-15",4960.6229999999996]
["عميل14",90582,"2016-03-21",6512.5]
["عميل1",400,"2016-03-21",2724.5079999999998]
["عميل5",414,"2016-03-27",4766.07]
["عميل3",91148,"2016-03-29",8853.25]
["عميل6",426,"2016-03-31",3273.12]
["عميل3",446,"2016-04-05",4859.8100000000004]
["عميل15",3254,"2016-04-06",null,60740.514000000003]
["عميل5",482,"2016-04-17",1936.45]
["عميل16",485,"2016-04-17",4688.95]
["عميل14",92294,"2016-04-18",5246.5]
["عميل13",502,"2016-04-26",4983.55]
["عميل15",507,"2016-04-27",2668.0129999999999]
["عميل6",93035,"2016-04-28",2514.25]
["عميل2",93036,"2016-04-28",11913.25]
["عميل3",93048,"2016-04-28",7104.25]
["عميل10",93077,"2016-04-30",1849.5]
["عميل19",93839,"2016-05-11",9235.375]
["عميل4",544,"2016-05-10",5013.55]
["عميل4",3425,"2016-05-03",null,27656.393]
["عميل20",3477,"2016-05-10",null,23381.25]
["عميل2",94836,"2016-05-24",10483.5]
["عميل14",94830,"2016-05-24",16831.5]
["عميل19",94734,"2016-05-24",1809]
["عميل15",3616,"2016-05-26",null,14248.924999999999]
["عميل4",580,"2016-05-24",3659.143]
["عميل20",585,"2016-05-24",4812.6899999999996]
["عميل15",591,"2016-05-24",4983.55]
["عميل2",599,"2016-05-31",2915.4830000000002]
["عميل5",600,"2016-05-31",2223.2950000000001]
["عميل16",95666,"2016-06-09",5137.25]
["عميل10",95665,"2016-06-09",14481.875]
["عميل12",95457,"2016-06-04",3114.875]
["عميل13",95452,"2016-06-04",305]
["عميل18",95470,"2016-06-05",10653]
["عميل19",3713,"2016-06-07",null,73851.035999999993]
["عميل19",616,"2016-06-02",12060]
["عميل5",96349,"2016-06-18",15839]
["عميل19",96077,"2016-06-14",4536.125]
["عميل6",633,"2016-06-11",2910.7]
["عميل15",637,"2016-06-12",4766.07]
["عميل5",640,"2016-06-12",4688.95]
["عميل19",647,"2016-06-14",11963.794]
["عميل3",656,"2016-06-14",4812.6899999999996]
["عميل8",657,"2016-06-14",3109.7]
["عميل15",96600,"2016-06-22",3935]
["عميل14",96616,"2016-06-22",21531.25]
["عميل4",3870,"2016-06-23",null,72246.153999999995]
["عميل20",97048,"2016-06-30",1248.5]
["عميل8",97054,"2016-06-30",21531.25]
["عميل4",97051,"2016-06-30",118]
["عميل15",96768,"2016-06-26",15839]
["عميل3",3922,"2016-06-30",null,49133.86]
["عميل17",669,"2016-06-23",4859.8100000000004]
["عميل4",670,"2016-06-23",2968.8]
["عميل14",695,"2016-07-03",4812.6899999999996]
["عميل2",97653,"2016-07-13",3060.5]
["عميل11",97413,"2016-07-11",2251.5]
["عميل19",3965,"2016-07-05",null,27710.44]
["عميل9",717,"2016-07-14",2797.4]
["عميل14",718,"2016-07-14",1361.635]
["عميل19",719,"2016-07-14",2750.5030000000002]
["عميل5",98491,"2016-07-28",6558]
["عميل13",98541,"2016-07-28",3279]
["عميل2",758,"2016-07-28",5004.43]
["عميل15",762,"2016-07-28",4688.95]
["عميل6",779,"2016-07-31",40122.949999999997]
["عميل13",4212,"2016-08-07",null,28071.751]
["عميل6",98932,"2016-08-06",279]
["عميل4",800,"2016-08-02",4688.95]
["عميل5",807,"2016-08-03",1324.2629999999999]
["عميل5",99604,"2016-08-16",225.5]
["عميل10",836,"2016-08-15",3134.2979999999998]
["عميل11",837,"2016-08-15",4859.8100000000004]
["عميل13",100087,"2016-08-25",11804]
["عميل5",100088,"2016-08-25",2951.25]
["عميل4",860,"2016-08-21",4766.07]
["عميل11",861,"2016-08-21",4736.07]
["عميل4",877,"2016-08-29",4859.8100000000004]
["عميل6",878,"2016-08-29",4688.95]
["عميل6",4396,"2016-08-29",null,27694.128000000001]
["عميل13",100446,"2016-09-01",3060.5]
["عميل11",917,"2016-09-06",4812.6899999999996]
["عميل13",939,"2016-09-10",4688.95]
["عميل2",948,"2016-09-19",4859.8100000000004]
["عميل9",101314,"2016-09-21",118]
["عميل11",101306,"2016-09-21",7760.25]
["عميل15",4523,"2016-09-18",null,57544.9]
["عميل2",101568,"2016-09-24",17377.75]
["عميل10",966,"2016-09-21",4889.8100000000004]
["عميل1",102521,"2016-10-10",4536.125]
["عميل11",988,"2016-10-01",4812.6899999999996]
["عميل19",1030,"2016-10-09",4718.95]
["عميل5",4698,"2016-10-10",null,59262.51]
["عميل19",102650,"2016-10-13",14754.75]
["عميل9",1034,"2016-10-12",4766.07]
["عميل5",1042,"2016-10-15",4766.07]
["عميل4",103741,"2016-10-31",15919.5]
["عميل8",1067,"2016-10-22",1086.07]
["عميل15",1070,"2016-10-25",4642.33]
["عميل17",1080,"2016-10-26",4812.6899999999996]
["عميل16",1084,"2016-10-30",2910.7]
["عميل19",1085,"2016-10-30",4688.95]
["عميل13",103956,"2016-11-02",21640.5]
["عميل16",103957,"2016-11-02",1257.125]
["عميل2",1115,"2016-11-05",2856.558]
["عميل11",4981,"2016-11-09",null,90499.83]
["عميل3",105087,"2016-11-21",8907.625]
["عميل2",1136,"2016-11-12",3120.1]
["عميل9",1141,"2016-11-15",4983.55]
["عميل10",1160,"2016-11-20",4889.8100000000004]
["عميل19",105758,"2016-11-30",28362.125]
["عميل12",1166,"2016-11-22",141]
["عميل7",1167,"2016-11-22",1323.31]
["عميل1",1184,"2016-11-27",4983.55]
["عميل18",1190,"2016-11-30",4936.93]
["عميل7",1210,"2016-12-07",1715.963]
["عميل5",1215,"2016-12-08",4843.1899999999996]
["عميل14",106377,"2016-12-12",2951.25]
["عميل11",5315,"2016-12-15",null,64504.557999999997]
["عميل12",1225,"2016-12-12",4766.07]
["عميل20",1251,"2016-12-19",1947.4749999999999]
["عميل13",107226,"2016-12-28",6284.625]
["عميل7",1256,"2016-12-25",4688.95]
["عميل2",1267,"2016-12-28",14805.718000000001]
["عميل9",1269,"2016-12-28",5137.79]
["عميل13",108561,"2017-01-18",27870.25]
["عميل5",1321,"2017-01-16",4983.55]
["عميل11",1328,"2017-01-16",4766.07]
["عميل3",1335,"2017-01-18",5060.67]
["عميل7",5640,"2017-01-23",null,47141.031000000003]
["عميل5",1352,"2017-01-28",4766.07]
["عميل19",1353,"2017-01-28",7676.9129999999996]
["عميل19",1358,"2017-01-29",21470.187999999998]
["عميل3",109433,"2017-02-02",3935]
["عميل14",109578,"2017-02-05",22624.25]
["عميل18",1366,"2017-02-01",5060.67]
["عميل10",1370,"2017-02-01",70.5]
["عميل8",110499,"2017-02-18",13661.75]
["عميل5",5852,"2017-02-15",null,108284.13099999999]
["عميل12",1409,"2017-02-18",5060.67]
["عميل16",1414,"2017-02-20",4688.95]
["عميل19",1417,"2017-02-20",1354.2629999999999]
["عميل1",1445,"2017-02-28",4766.07]
["عميل5",111661,"2017-03-08",3067.0940000000001]
["عميل14",111664,"2017-03-08",28143.625]
["عميل7",1461,"2017-03-04",141]
["عميل5",1470,"2017-03-07",5013.55]
["عميل7",6079,"2017-03-14",null,29531.703000000001]
["عميل17",111957,"2017-03-13",10372]
["عميل8",111965,"2017-03-13",1778.04]
["عميل18",112376,"2017-03-18",4536.125]
["عميل8",1478,"2017-03-13",5184.41]
["عميل20",1490,"2017-03-15",4766.07]
["عميل1",1502,"2017-03-17",7511.55]
["عميل7",113418,"2017-03-29",225.5]
["عميل16",113429,"2017-03-29",18361.5]
["عميل5",6184,"2017-03-26",null,63001.913999999997]
["عميل10",1522,"2017-03-26",4812.6899999999996]
["عميل7",1525,"2017-03-28",281.5]
["عميل10",1526,"2017-03-28",4983.55]
["عميل5",6355,"2017-04-10",null,10077.74]
["عميل11",114260,"2017-04-09",1889.5]
["عميل3","113418/5661","2017-04-09",1967.5]
["عميل2",114587,"2017-04-13",4536.125]
["عميل13",1581,"2017-04-13",5479.01]
["عميل2",1601,"2017-04-19",4812.6899999999996]
["عميل16",115169,"2017-04-22",19563.75]
["عميل20",115654,"2017-04-29",4590.5]
["عميل5",1607,"2017-04-22",4936.93]
["عميل6",116142,"2017-05-07",4590.5]
["عميل2",1629,"2017-05-03",4766.07]
["عميل6",1645,"2017-05-07",4642.33]
["عميل8",6521,"2017-05-03",null,29955.55]
["عميل16",6590,"2017-05-14",null,43919.004999999997]
["عميل10",116823,"2017-05-16",1248.5]
["عميل8",116814,"2017-05-16",22077.5]
["عميل16",116939,"2017-05-18",4317.125]
["عميل16",1675,"2017-05-14",4936.93]
["عميل6",1684,"2017-05-16",4812.6899999999996]
["عميل5",6669,"2017-05-24",null,9356.57]
["عميل10",1708,"2017-05-24",4642.33]
["عميل5",1722,"2017-05-30",4812.6899999999996]
["عميل4",118948,"2017-06-15",1530.5]
["عميل3",118947,"2017-06-15",13006.25]
["عميل2",6762,"2017-06-06",null,37392.745000000003]
["عميل7",1758,"2017-06-11",4766.07]
["عميل20",1765,"2017-06-13",4859.8100000000004]
["عميل19",119688,"2017-06-24",4590.5]
["عميل8",6884,"2017-06-21",null,19080.900000000001]
["عميل7",1786,"2017-06-21",4766.07]
["عميل15",1808,"2017-06-28",4859.8100000000004]
["عميل12",119898,"2017-07-02",4317.125]
["عميل17",120597,"2017-07-08",18799]
["عميل12",1819,"2017-07-01",4866.05]
["عميل15",1820,"2017-07-01",3548.46]
["عميل9",1843,"2017-07-06",4812.6899999999996]
["عميل19",120873,"2017-07-13",4590.5]
["عميل7",121451,"2017-07-23",5427]
["عميل3",121456,"2017-07-23",1772.44]
["عميل8",7076,"2017-07-19",null,46127.095000000001]
["عميل4",1854,"2017-07-11",4688.95]
["عميل4",1874,"2017-07-20",4889.8100000000004]
["عميل16",121609,"2017-07-27",3057.4340000000002]
["عميل16",121623,"2017-07-27",9945.75]
["عميل20",121666,"2017-07-29",9016.875]
["عميل1",1878,"2017-07-22",141]
["عميل2",1884,"2017-07-31",4812.6899999999996]
["عميل10",122372,"2017-08-10",14044.375]
["عميل7",1887,"2017-08-02",4812.6899999999996]
["عميل19",7181,"2017-08-03",null,32891.14]
["عميل18",1918,"2017-08-15",281.5]
["عميل4",1922,"2017-08-15",4766.07]
["عميل4",7327,"2017-08-24",null,57920.063999999998]
["عميل1",123321,"2017-08-27",4590.5]
["عميل12",1937,"2017-08-21",7423.12]
["عميل13",1945,"2017-08-26",4812.6899999999996]
["عميل16",1952,"2017-08-30",4718.95]
["عميل16",123819,"2017-09-06",16011.875]
["عميل3",124432,"2017-09-14",4699.75]
["عميل19",7439,"2017-09-14",null,26592.83]
["عميل6",1975,"2017-09-13",70.5]
["عميل1",1978,"2017-09-13",4889.8100000000004]
["عميل14",1996,"2017-09-24",4859.8100000000004]
["عميل6",125239,"2017-10-02",3279]
["عميل8",7554,"2017-10-03",null,16082.375]
["عميل9",2026,"2017-10-08",3348.7249999999999]
["عميل20",125904,"2017-10-11",1312]
["عميل19",125887,"2017-10-11",1783.473]
["عميل3",126026,"2017-10-12",1034.18]
["عميل16",126021,"2017-10-12",1055.5]
["عميل1",126022,"2017-10-12",965]
["عميل5",126393,"2017-10-18",1608]
["عميل17",126422,"2017-10-18",2186]
["عميل14",126429,"2017-10-18",14317.75]
["عميل13",2034,"2017-10-11",4766.07]
["عميل11",2037,"2017-10-14",141]
["عميل10",2038,"2017-10-14",4936.93]
["عميل6",2047,"2017-10-17",6899.55]
["عميل4",7690,"2017-10-19",null,17728.37]
["عميل16",126982,"2017-10-29",3114.875]
["عميل18",127080,"2017-10-30",7322.75]
["عميل8",127098,"2017-10-30",5387]
["عميل18",2054,"2017-10-25",4859.8100000000004]
["عميل9",2069,"2017-10-30",7068.91]
["عميل14",7759,"2017-11-01",null,44354.178]
["عميل7",2093,"2017-11-05",4936.93]
["عميل14",2095,"2017-11-05",70.5]
["عميل8",128162,"2017-11-13",8482.5]
["عميل7",128471,"2017-11-13",11530.625]
["عميل12",2103,"2017-11-12",3208.6]
["عميل11",2109,"2017-11-13",7238.27]
["عميل19",2122,"2017-11-20",4859.8100000000004]
["عميل18",7976,"2017-11-29",null,51690.144999999997]
["عميل11",129106,"2017-12-04",4645.375]
["عميل13",2149,"2017-12-04",4859.8100000000004]
["عميل6",2156,"2017-12-05",5060.67]
["عميل15",2168,"2017-12-09",6829.87]
["عميل20",129975,"2017-12-11",6667.25]
["عميل7",130026,"2017-12-12",1421.25]
["عميل12",2175,"2017-12-12",14912.133]
["عميل19",130581,"2017-12-19",4918.25]
["عميل19",8141,"2017-12-21",null,45874.66]
["عميل2",131195,"2017-12-26",23919]
["عميل9",131205,"2017-12-26",32515.125]
["عميل7",131569,"2017-12-28",5028]
["عميل2",2198,"2017-12-21",4766.07]
["عميل8",2200,"2017-12-27",7098.91]
["عميل10",2206,"2017-12-28",4718.95]
["عميل13",132042,"2018-01-08",3770.875]
["عميل14",132034,"2018-01-08",1248.5]
["عميل15",132027,"2018-01-08",2774]
["عميل2",132028,"2018-01-08",201]
["عميل13",132418,"2018-01-11",1045.5]
["عميل1",8315,"2018-01-10",null,19830.383000000002]
["عميل3",2228,"2018-01-06",6829.87]
["عميل4",133362,"2018-01-18",10774]
["عميل1",2249,"2018-01-16",4812.6899999999996]
["عميل13",2256,"2018-01-20",7068.91]
["عميل6",2262,"2018-01-20",4642.33]
["عميل4",133525,"2018-01-21",2623.5]
["عميل12",133529,"2018-01-21",14645.5]
["عميل16",133532,"2018-01-21",4590.5]
["عميل20",134503,"2018-01-31",4060.5]
["عميل5",2269,"2018-01-25",15111.343000000001]
["عميل9",2273,"2018-01-30",6899.55]
["عميل12",8412,"2018-01-24",null,93915.8]
["عميل15",135045,"2018-02-05",5519.375]
["عميل19",2276,"2018-02-04",923.79499999999996]
["عميل2",8539,"2018-02-08",null,49157.43]
["عميل10",135809,"2018-02-12",4809]
["عميل12",136325,"2018-02-19",1202.25]
["عميل10",136305,"2018-02-19",884.5]
["عميل16",2309,"2018-02-12",4766.07]
["عميل15",2312,"2018-02-14",6999.23]
["عميل7",2325,"2018-02-20",4812.6899999999996]
["عميل11",137081,"2018-02-28",2372]
["عميل8",136694,"2018-02-25",2623.5]
["عميل2",137494,"2018-03-03",3224.625]
["عميل15",2347,"2018-03-03",7068.91]
["عميل14",2353,"2018-03-04",4812.6899999999996]
["عميل13",2268,"2018-03-10",4642.33]
["عميل11",8738,"2018-03-11",null,28469.24]
["عميل20",138254,"2018-03-11",1147.875]
["عميل20",138255,"2018-03-11",4426.875]
["عميل19",2380,"2018-03-15",7068.91]
["عميل20",2385,"2018-03-19",4859.8100000000004]
["عميل13",138926,"2018-03-18",1803.375]
["عميل4",138941,"2018-03-18",19236]
["عميل9",138919,"2018-03-18",14150.5]
["عميل17",8832,"2018-03-21",null,25323.305]
["عميل19",2395,"2018-03-27",4532.2780000000002]
["عميل2",2399,"2018-03-29",4766.07]
["عميل9",2403,"2018-03-29",3669.2379999999998]
["عميل13",139997,"2018-03-29",11421.375]
["عميل1",140197,"2018-04-02",5300.875]
["عميل8",8908,"2018-04-01",null,47118.595000000001]
["عميل16",2410,"2018-04-01",4983.55]
["عميل9",2426,"2018-04-09",2038.7180000000001]
["عميل15",2432,"2018-04-10",4688.95]
["عميل20",140899,"2018-04-15",4754.625]
["عميل14",141232,"2018-04-18",151]
["عميل1",141231,"2018-04-18",1729]
["عميل6",2439,"2018-04-17",211.5]
["عميل16",2447,"2018-04-18",4983.55]
["عميل20",9067,"2018-04-23",null,34673.385999999999]
["عميل16",141579,"2018-04-21",1872.5]
["عميل14",141599,"2018-04-21",6120.5]
["عميل20",141881,"2018-04-25",2404.5]
["عميل20",142123,"2018-04-28",18033.75]
["عميل6",2459,"2018-04-22",4766.07]
["عميل17",2464,"2018-04-25",4812.6899999999996]
["عميل10",142727,"2018-05-05",7432]
["عميل8",2479,"2018-05-02",4889.8100000000004]
["عميل6",2502,"2018-05-09",4936.93]
["عميل4",143431,"2018-05-13",11257.75]
["عميل15",9232,"2018-05-16",null,26550.343000000001]
["عميل5",144107,"2018-05-20",8306.5]
["عميل10",9294,"2018-05-23",null,58533.5]
["عميل4",144760,"2018-05-27",2295.25]
["عميل14",2521,"2018-05-22",4766.07]
["عميل3",2531,"2018-05-24",5937.1130000000003]
["عميل1",2534,"2018-05-24",23130.544000000002]
["عميل11",2547,"2018-05-30",4936.93]
["عميل1",145853,"2018-06-06",19126.75]
["عميل1",2566,"2018-06-04",4889.8100000000004]
["عميل4",2568,"2018-06-04",45724.3]
["عميل1",2573,"2018-06-06",4766.07]
["عميل12",146626,"2018-06-14",5956.875]
["عميل1",2599,"2018-06-14",4889.8100000000004]
["عميل13",147523,"2018-06-26",11804]
["عميل13",147532,"2018-06-26",10875.125]
["عميل14",2608,"2018-06-23",2065.56]
["عميل13",2609,"2018-06-23",4983.55]
["عميل4",2618,"2018-06-24",4718.95]
["عميل8",2635,"2018-06-28",4936.93]
["عميل11",9591,"2018-06-28",null,123879.337]
["عميل10",148181,"2018-07-02",19236]
["عميل1",148805,"2018-07-08",5465]
["عميل13",2656,"2018-07-05",4766.07]
["عميل1",2669,"2018-07-10",4936.93]
["عميل5","9714+9718","2018-07-11",null,45293.87]
["عميل8","9714+9718","2018-07-11",null,17403.169999999998]
["عميل11",149406,"2018-07-14",5410.125]
["عميل12",2684,"2018-07-18",4983.55]
["عميل12",150226,"2018-07-22",15684.125]
["عميل4",150752,"2018-07-26",11858.375]
["عميل12",9830,"2018-07-24",null,59862.398000000001]
["عميل13",2704,"2018-07-30",4983.55]
["عميل6",2718,"2018-07-31",4983.55]
["عميل12",151797,"2018-08-07",10000.625]
["عميل15",2742,"2018-08-07",4889.8100000000004]
["عميل5",152296,"2018-08-12",3497.5]
["عميل15","س10028","2018-08-14",null,42493.15]
["عميل5",153233,"2018-08-19",15957]
["عميل7",2759,"2018-08-28",4812.6899999999996]
["عميل7",154475,"2018-09-02",4590.5]
["عميل20",154479,"2018-09-02",16831.5]
["عميل14",155796,"2018-09-10",11694.75]
["عميل16",2779,"2018-09-04",2152.94]
["عميل6","س10328","2018-09-18",null,57770.285000000003]
["عميل17",156583,"2018-09-18",18470.75]
["عميل7",2811,"2018-09-13",5137.79]
["عميل4",2809,"2018-09-13",4936.93]
["عميل18",2814,"2018-09-13",4936.93]
["عميل9",2826,"2018-09-16",2599.4499999999998]
["عميل10",2840,"2018-09-20",13230.9]
["عميل5",157417,"2018-09-23",7104.25]
["عميل3",2853,"2018-09-24",5060.67]
["عميل11",2864,"2018-09-29",4936.93]
["عميل6","س10458","2018-09-29",null,31458.79]
["عميل15",159131,"2018-10-04",4207.875]
["عميل3",2892,"2018-10-08",4718.95]
["عميل10",2906,"2018-10-10",2836.2629999999999]
["عميل17",2907,"2018-10-10",2235.4]
["عميل17","س10567","2018-10-09",null,53011.375]
["عميل2",160257,"2018-10-13",17760.375]
["عميل5",2931,"2018-10-15",4936.93]
["عميل5",2934,"2018-10-15",4936.93]
["عميل3",160992,"2018-10-21",13880.75]
["عميل8",161415,"2018-10-28",2951.25]
["عميل11",161394,"2018-10-28",9181]
["عميل4",2962,"2018-10-24",4688.95]
["عميل14",2964,"2018-10-25",2539.3000000000002]
["عميل12",2971,"2018-10-29",5013.55]
["عميل6",2972,"2018-10-29",35079.61]
["عميل10",2976,"2018-10-29",4983.55]
["عميل8",2982,"2018-10-31",2240.3200000000002]
["عميل16","س10784","2018-11-01",null,51305.597999999998]
["عميل19",3003,"2018-11-06",1088.905]
["عميل9",3014,"2018-11-07",4889.8100000000004]
["عميل7",3020,"2018-11-10",4812.6899999999996]
["عميل14",3021,"2018-11-10",4889.8100000000004]
["عميل1",163213,"2018-11-10",10274]
["عميل12",163211,"2018-11-10",9618]
["عميل4",163210,"2018-11-10",11804]
["عميل3",163193,"2018-11-10",3121]
["عميل5",3040,"2018-11-19",4983.55]
["عميل15","س10971","2018-11-24",null,67766.434999999998]
["عميل4",164591,"2018-11-26",7322.75]
["عميل13",164592,"2018-11-26",7923.875]
["عميل16",3041,"2018-11-21",70.5]
["عميل19",3050,"2018-11-25",4859.8100000000004]
["عميل16",3068,"2018-11-29",4766.07]
["عميل18",3081,"2018-12-04",17638.45]
["عميل2",3091,"2018-12-04",4983.55]
["عميل6",3092,"2018-12-04",4889.8100000000004]
["عميل18",3103,"2018-12-10",4766.07]
["عميل9",166230,"2018-12-10",15629.25]
["عميل9",166249,"2018-12-10",16503.75]
["عميل15",166251,"2018-12-10",4918.25]
["عميل4",166276,"2018-12-10",4098.625]
["عميل15","س11171","2018-12-10",null,79335.865000000005]
["عميل2",3117,"2018-12-13",4936.93]
["عميل3",3128,"2018-12-18",4983.55]
["عميل12",3137,"2018-12-20",2806.0479999999998]
["عميل1",167746,"2018-12-22",1913.125]
["عميل5",167750,"2018-12-22",19454.5]
["عميل6",168076,"2018-12-27",10274]
["عميل13",168087,"2018-12-27",23389]
["عميل6",3144,"2018-12-23",211.5]
["عميل17",3145,"2018-12-23",4889.8100000000004]
["عميل7",3149,"2018-12-23",3731.2379999999998]
["عميل20",3162,"2018-12-26",4859.8100000000004]
["عميل14",3164,"2018-12-26",2569.375]
["عميل4",168639,"2019-01-01",10492.5]
["عميل20",168647,"2019-01-01",1624.98]
["عميل5",168981,"2019-01-03",1105.5]
["عميل10",168961,"2019-01-03",18130.5]
["عميل8",168963,"2019-01-03",1624.98]
["عميل1",168686,"2019-01-02",1401.2139999999999]
["عميل19",168707,"2019-01-02",3169.75]
["عميل2",168716,"2019-01-02",10437.625]
["عميل18",168736,"2019-01-02",14262.875]
["عميل17",169694,"2019-01-08",40.5]
["عميل18",3172,"2019-01-01",3303.36]
["عميل3",3179,"2019-01-01",21852.715]
["عميل20",3180,"2019-01-01",5060.67]
["عميل15",3181,"2019-01-01",4983.55]
["عميل1",3201,"2019-01-06",15247.135]
["عميل9",3224,"2019-01-10",5107.29]
["عميل16","س11414","2019-01-01",null,157446.141]
["عميل11","س11605","2019-01-17",null,112697.35400000001]
["عميل7",3229,"2019-01-13",4889.8100000000004]
["عميل8",3230,"2019-01-13",4766.07]
["عميل6",3235,"2019-01-14",70.5]
["عميل17",171596,"2019-01-22",4098.625]
["عميل19",171595,"2019-01-22",14700.375]
["عميل18",171590,"2019-01-22",15137.375]
["عميل19",3274,"2019-01-28",4936.93]
["عميل20",3281,"2019-01-31",4889.8100000000004]
["عميل9",3284,"2019-01-31",3829.2]
["عميل9",3286,"2019-01-31",4812.6899999999996]
["عميل7","س11754","2019-01-30",null,48810.544999999998]
["عميل13",174642,"2019-02-07",15192.25]
["عميل18",174608,"2019-02-07",4044.25]
["عميل1",3291,"2019-02-02",4766.07]
["عميل5",3293,"2019-02-02",3733.0749999999998]
["عميل16",3303,"2019-02-05",492.5]
["عميل1",3304,"2019-02-05",141]
["عميل18",175831,"2019-02-14",11913.25]
["عميل14",175848,"2019-02-14",12241]
["عميل8","س11979","2019-02-19",null,72390.523000000001]
["عميل15",3329,"2019-02-12",25552.748]
["عميل19",3330,"2019-02-12",4812.6899999999996]
["عميل1",3356,"2019-02-19",4843.1899999999996]
["عميل6",3365,"2019-02-21",17778.150000000001]
["عميل18",3375,"2019-02-25",4718.95]
["عميل19",3376,"2019-02-25",4983.55]
["عميل17","س12111","2019-03-03",null,61290.78]
["عميل8",3412,"2019-03-05",1246.213]
["عميل1",3413,"2019-03-05",70.5]
["عميل10",3421,"2019-03-07",5060.67]
["عميل12",3425,"2019-03-07",21102.39]
["عميل14",179558,"2019-03-11",11585.5]
["عميل10",180500,"2019-03-16",6241.5]
["عميل19",180536,"2019-03-17",9891.375]
["عميل10",3431,"2019-03-11",3467.913]
["عميل6",3432,"2019-03-11",4812.6899999999996]
["عميل9",3438,"2019-03-11",4936.93]
["عميل7",3450,"2019-03-12",2569.375]
["عميل2","س12308","2019-03-19",null,22419.102999999999]
["عميل17",183247,"2019-03-30",31367.75]
["عميل2",183237,"2019-03-30",30056.25]
["عميل12",183238,"2019-03-30",10929.5]
["عميل20",3478,"2019-03-24",4889.8100000000004]
["عميل10",3500,"2019-03-28",2789.6750000000002]
["عميل19",3501,"2019-03-28",5432.39]
["عميل6",3502,"2019-03-28",3538.8]
["عميل15",184399,"2019-04-08",13661.75]
["عميل3",3507,"2019-04-02",4936.93]
["عميل6",3525,"2019-04-07",211.5]
["عميل5",3537,"2019-04-07",1938.4]
["عميل6",3551,"2019-04-10",422.5]
["عميل3","س12499","2019-04-01",null,41059.648000000001]
["عميل8","س12652","2019-04-14",null,93941.104999999996]
["عميل11",185937,"2019-04-15",10532.5]
["عميل13",185944,"2019-04-16",2658.62]
["عميل19",185892,"2019-04-15",18361.5]
["عميل10",185874,"2019-04-15",24372.75]
["عميل4",185852,"2019-04-15",8962.5]
["عميل5",3552,"2019-04-16",4889.8100000000004]
["عميل12",3558,"2019-04-16",985.56500000000005]
["عميل11",3563,"2019-04-16",18123.373]
["عميل17",3571,"2019-04-18",5231.53]
["عميل14",3572,"2019-04-18",6971.66]
["عميل11",3587,"2019-04-18",1846.94]
["عميل7",3588,"2019-04-18",5107.29]
["عميل17",188600,"2019-04-28",28362.125]
["عميل3",188621,"2019-04-28",14536.25]
["عميل3",189335,"2019-05-02",2292.9160000000002]
["عميل16",189352,"2019-05-02",14317.75]
["عميل7",189353,"2019-05-02",8962.5]
["عميل7",190411,"2019-05-09",1624.98]
["عميل8",190381,"2019-05-09",7437]
["عميل3",190391,"2019-05-09",9809]
["عميل12",3638,"2019-05-04",422.5]
["عميل13",3667,"2019-05-09",4889.8100000000004]
["عميل11",3669,"2019-05-09",5060.67]
["عميل13","س13001","2019-05-09",null,111455.607]
["عميل10",3611,"2019-04-24",1617.5730000000001]
["عميل17",3631,"2019-04-29",4889.8100000000004]
["عميل11",192496,"2019-05-22",23553.125]
["عميل9",192427,"2019-05-22",18143]
["عميل12",3674,"2019-05-11",4812.6899999999996]
["عميل12",3676,"2019-05-11",3171.9549999999999]
["عميل6",3684,"2019-05-11",1475.7750000000001]
["عميل10",3693,"2019-05-14",4688.95]
["عميل7",3699,"2019-05-18",4936.93]
["عميل15",3705,"2019-05-18",3232.3649999999998]
["عميل7",3709,"2019-05-18",2762.9]
["عميل19","س13090","2019-05-19",null,86492.565000000002]
["عميل17",192892,"2019-05-25",13065]
["عميل1",193664,"2019-05-30",11819]
["عميل19",3739,"2019-05-28",3262.2750000000001]
["عميل5",3740,"2019-05-28",4859.8100000000004]
["عميل14",3745,"2019-05-28",4766.07]
["عميل19",194346,"2019-06-08",1401.2139999999999]
["عميل9",194372,"2019-06-08",11038.75]
["عميل8",194374,"2019-06-08",17869.625]
["عميل16",194375,"2019-06-08",765.25]
["عميل3",194909,"2019-06-10",13334]
["عميل8",3774,"2019-06-11",12060]
["عميل6",3778,"2019-06-11",5107.29]
["عميل18",3782,"2019-06-11",2170.0929999999998]
["عميل4",3783,"2019-06-11",4936.93]
["عميل8",3784,"2019-06-11",422.5]
["عميل4",3796,"2019-06-12",5385.27]
["عميل16",3797,"2019-06-13",141]
["عميل12",196023,"2019-06-16",4261.5]
["عميل6",196038,"2019-06-16",3249.46]
["عميل11",196175,"2019-06-17",10164.75]
["عميل16","س13354","2019-06-13",null,95089.425000000003]
["عميل15","س13405","2019-06-18",null,44408.839]
["عميل5",197253,"2019-06-23",17760.375]
["عميل12",197261,"2019-06-23",333]
["عميل17",3822,"2019-06-23",4812.6899999999996]
["عميل17",3823,"2019-06-25",4983.55]
["عميل7",3824,"2019-06-26",5060.67]
["عميل13",3838,"2019-06-29",638.375]
["عميل15","س13498","2019-06-25",null,47898.792999999998]
["عميل6",198297,"2019-07-02",16066.25]
["عميل4",198298,"2019-07-02",874.5]
["عميل1",198302,"2019-07-02",14536.25]
["عميل12",3856,"2019-07-04",4889.8100000000004]
["عميل11",3883,"2019-07-10",4983.55]
["عميل18",3884,"2019-07-10",2204.8330000000001]
["عميل9",3885,"2019-07-10",4812.6899999999996]
["عميل17",200409,"2019-07-18",2802.4279999999999]
["عميل6",200424,"2019-07-18",12350.25]
["عميل13",200425,"2019-07-18",5792.75]
["عميل3","س13715","2019-07-16",null,89915.91]
["عميل6",3916,"2019-07-18",4812.6899999999996]
["عميل17",200591,"2019-07-20",12951.375]
["عميل20",200600,"2019-07-20",8798.375]
["عميل2",200585,"2019-07-20",7978.75]
["عميل18",200722,"2019-07-22",20438.25]
["عميل13",200729,"2019-07-22",6830.875]
["عميل4",200730,"2019-07-22",2186]
["عميل18","س13796","2019-07-24",null,42649.000999999997]
["عميل3",3925,"2019-07-21",2931.9]
["عميل5",3932,"2019-07-23",4812.6899999999996]
["عميل15",3933,"2019-07-23",4936.93]
["عميل10",3935,"2019-07-27",4889.8100000000004]
["عميل4","س13855","2019-07-30",null,71865.145000000004]
["عميل2",202284,"2019-08-01",4372]
["عميل19",202291,"2019-08-01",17214.125]
["عميل12",202586,"2019-08-05",4372]
["عميل18",3978,"2019-08-07",4889.8100000000004]
["عميل16",3962,"2019-08-08",4812.6899999999996]
["عميل14",3985,"2019-08-08",4936.93]
["عميل16",203967,"2019-08-18",5028]
["عميل7",203961,"2019-08-18",333]
["عميل12",203962,"2019-08-18",14591.125]
["عميل1","س13963","2019-08-07",null,26475.935000000001]
["عميل20",3999,"2019-08-19",14132.407999999999]
["عميل10",4014,"2019-08-20",2386.1999999999998]
["عميل5",4015,"2019-08-20",4889.8100000000004]
["عميل15",4016,"2019-08-20",4983.55]
["عميل16",205129,"2019-08-25",5465]
["عميل3",205138,"2019-08-25",23170.5]
["عميل5",4036,"2019-08-27",4812.6899999999996]
["عميل17",4042,"2019-08-27",4936.93]
["عميل18",4061,"2019-08-28",14652.423000000001]
["عميل8",4062,"2019-08-28",70.5]
["عميل12",4063,"2019-08-28",211.5]
["عميل10",4064,"2019-08-28",141]
["عميل2",4065,"2019-08-28",352]
["عميل8","س14148","2019-08-28",null,53095.963000000003]
["عميل18",206431,"2019-09-02",6940.625]
["عميل11",206419,"2019-09-02",15847.75]
["عميل13",207015,"2019-09-08",3935]
["عميل11",207021,"2019-09-08",21531.25]
["عميل11",207519,"2019-09-11",15847.75]
["عميل15",4069,"2019-09-03",4766.07]
["عميل18",4070,"2019-09-03",4936.93]
["عميل5",4088,"2019-09-08",4766.07]
["عميل7",4099,"2019-09-10",4936.93]
["عميل16","س14285","2019-09-15",null,98563.478000000003]
["عميل15",4112,"2019-09-19",4812.6899999999996]
["عميل11",208401,"2019-09-21",4645.375]
["عميل9",208463,"2019-09-23",4044.25]
["عميل20",208803,"2019-09-26",1147.875]
["عميل20","س14365","2019-09-25",null,60475.065000000002]
["عميل12",4115,"2019-09-21",4983.55]
["عميل7",4137,"2019-09-22",4718.95]
["عميل5",4150,"2019-09-28",4889.8100000000004]
["عميل9",210195,"2019-10-03",8743.5]
["عميل15",210203,"2019-10-03",24263.5]
["عميل7",210794,"2019-10-08",27979.5]
["عميل16",210798,"2019-10-08",10929.5]
["عميل10",4154,"2019-10-01",4889.8100000000004]
["عميل4",4173,"2019-10-07",4936.93]
["عميل3",4177,"2019-10-08",4812.6899999999996]
["عميل20",4195,"2019-10-15",1640.9280000000001]
["عميل5",4207,"2019-10-19",4812.6899999999996]
["عميل19",4208,"2019-10-19",4936.93]
["عميل17",4219,"2019-10-20",4936.93]
["عميل15",4223,"2019-10-20",8242.4580000000005]
["عميل16",212544,"2019-10-20",13224.75]
["عميل13",213484,"2019-10-27",6646.38]
["عميل2",213465,"2019-10-27",9005]
["عميل5",213870,"2019-10-29",5732.6090000000004]
["عميل5",213908,"2019-10-29",14754.75]
["عميل5",213886,"2019-10-29",12241]
["عميل3",213881,"2019-10-29",6776.5]
["عميل8",214130,"2019-10-30",7651]
["عميل3",4235,"2019-10-28",4983.55]
["عميل15",4248,"2019-10-31",4859.8100000000004]
["عميل7",4251,"2019-10-31",4936.93]
["عميل8",214569,"2019-11-02",29291]
["عميل10",4268,"2019-11-05",1088.905]
["عميل19",4273,"2019-11-06",4983.55]
["عميل16",4274,"2019-11-06",4983.55]
["عميل20",216474,"2019-11-13",23061.25]
["عميل14",216454,"2019-11-13",10328.375]
["عميل14",216457,"2019-11-13",14754.75]
["عميل19","س14823","2019-11-03",null,106339.86500000001]
["عميل16","س14892","2019-11-10",null,115382.215]
["عميل7",4299,"2019-11-13",281.5]
["عميل10",4306,"2019-11-16",5137.79]
["عميل2",4307,"2019-11-16",4020]
["عميل2",4320,"2019-11-20",4983.55]
["عميل19",218492,"2019-11-25",10929.5]
["عميل20",218493,"2019-11-25",6339.5]
["عميل20",4340,"2019-11-23",4889.8100000000004]
["عميل11",4355,"2019-11-27",4889.8100000000004]
["عميل11",4356,"2019-11-27",2427.9580000000001]
["عميل5",4366,"2019-11-30",19414.599999999999]
["عميل3",219250,"2019-12-01",5683.5]
["عميل11",4379,"2019-12-03",13146.955]
["عميل9",4387,"2019-12-04",4936.93]
["عميل11",4388,"2019-12-04",4688.95]
["عميل13",4389,"2019-12-04",2483.3000000000002]
["عميل15",4406,"2019-12-05",5013.55]
["عميل14",220632,"2019-12-07",8634.25]
["عميل20",221356,"2019-12-11",2623.5]
["عميل11",221529,"2019-12-12",23279.75]
["عميل10","س15163","2019-12-03",null,107804.03]
["عميل8","س15270","2019-12-12",null,83575.252999999997]
["عميل5",222606,"2019-12-18",20329]
["عميل15",4452,"2019-12-16",5013.55]
["عميل11",4475,"2019-12-19",4936.93]
["عميل5",223496,"2019-12-25",8033.125]
["عميل3",223930,"2019-12-28",27323.5]
["عميل13",223983,"2019-12-29",25465.75]
["عميل19",4489,"2019-12-25",5060.67]
["عميل1",4506,"2019-12-28",5137.79]
["عميل7",4519,"2019-12-30",5013.55]
["عميل15",225622,"2020-01-09",27105]
["عميل2",225615,"2020-01-09",6776.5]
["عميل9","س15544","2020-01-07",null,137401.52499999999]
["عميل4",4526,"2020-01-04",5184.41]
["عميل7",4543,"2020-01-11",2414.3229999999999]
["عميل20",4550,"2020-01-12",5013.55]
["عميل3",4570,"2020-01-14",14909.612999999999]
["عميل2",4571,"2020-01-14",1223.81]

{"sheet":"التقرير","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,0,24,1],[26,4,26,6],[0,1,1,2],[1,5,1,15],[3,8,3,13]]}
[null,"كشف حركة الديون للفترة :",null,"من","الي"]
[null,null,null,"2020-01-01","2020-01-31","المطلوب جمع الحركة الدائنة والمدينة لكل عميل علي حسب التاريخ  (من  الي)  أحيانا أسبوع او شهر او سنة"]
[]
["ت","العملاء","رصيد اول مدة","الحركة المدينة","الحركة الدائنة","صافي الدين","ملاحظات",null,"وكذلك رصيد اول مدة"]
[1,"عميل1",null,null,null,{"$f":"C5+D5-E5","v":0}]
[2,"عميل2",null,null,null,{"$f":"C6+D6-E6","v":0}]
[3,"عميل3",null,null,null,0]
[4,"عميل4",null,null,null,0]
[5,"عميل5",null,null,null,0]
[6,"عميل6",null,null,null,0]
[7,"عميل7",null,null,null,0]
[8,"عميل8",null,null,null,0]
[9,"عميل9",null,null,null,0]
[10,"عميل10",null,null,null,0]
[11,"عميل11",null,null,null,0]
[12,"عميل12",null,null,null,0]
[13,"عميل13",null,null,null,0]
[14,"عميل14",null,null,null,0]
[15,"عميل15",null,null,null,0]
[16,"عميل16",null,null,null,0]
[17,"عميل17",null,null,null,0]
[18,"عميل18",null,null,null,0]
[19,"عميل19",null,null,null,0]
[20,"عميل20",null,null,null,0]
["الاجمالي الكلي",null,{"$f":"SUBTOTAL(9,C5:C24)","v":0},{"$f":"SUBTOTAL(9,D5:D24)","v":0},{"$f":"SUBTOTAL(9,E5:E24)","v":0},{"$f":"SUBTOTAL(9,F5:F24)","v":0}]
[]
[null,null,null,null,"لجنة الديون / ............................."]