{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["المصروف","تصفية-الخلاصة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["رقم السيارة","اسم المحطة","تاريخ التحميل","رقم السيارة","اسم السائق","القياسي (المفرغ)","رقم المستند","استحقاق المحطة","السلف","النقص","مبلغ النقص","صافي الاستحقاق","طلب قديم"]
[508,"الصابر","2018-11-01",508,"ضاري",41584,428468,500000,100000,null,{"$f":"J2*750","v":0},{"$f":"H2-I2-K2","v":400000}]
[508,"المحبة","2018-11-07",508,"ضاري",41702,428164,500000,150000,null,0,350000]
[508,"السلام","2018-11-10",508,"ضاري",41656,428029,500000,0,null,0,500000]
[828,"تاج القدس","2018-11-25",828,"ليث",42742,496947,400000,200000,null,0,200000]
[828,"الرحالية","2018-11-29",828,"ليث",42703,511616,400000,100000,null,0,300000]
[1419,"الجوهرة","2018-11-03",1419,"حسين",42501,476721,600000,150000,null,0,450000]
[1419,"الخالدية","2018-11-13",1419,"حسين",42695,486893,400000,50000,null,0,350000,50000]
[null,null,null,null,null,null,null,{"$f":"SUM(H2:H14)","v":3650000},{"$f":"SUM(I2:I14)","v":950000},{"$f":"SUM(J2:J14)","v":0},{"$f":"SUM(K2:K14)","v":0},2700000]
[null,null,null,null,null,null,null,null,null,null,"طلب قديم",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,"المجموع الكلي",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[508,"الخالدية","2018-11-20",null,"ضاري",null,null,400000,350000,null,null,50000]
[1419,"الأمن","2018-11-21",1419,"حسين",42785,736191,350000,200000,null,{"$f":"J14*750","v":0},{"$f":"H14-I14-K14","v":150000}]

{"sheet":"تصفية-الخلاصة","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[5,3,5,6]]}
["رقم السيارة","اسم السائق","مجموع الاستحقاق","مجموع السلف المستلمة","صافي المبلغ المتبقي","عدد النقلات","تواريخ التحميل","أسماء المحطات"]
[508,"ضاري",{"$f":"IF($A2<>\"\",SUMIF(المصروف!$D$2:$D$215,$A2,المصروف!$H$2:$H$215),\"\")","v":1500000},{"$f":"IF($A2<>\"\",SUMIF(المصروف!$D$2:$D$215,$A2,المصروف!$I$2:$I$215),\"\")","v":250000},{"$f":"C2-D2","v":1250000},{"$f":"COUNTIF(المصروف!$D$2:$D$215,A2)","v":3},{"$f":"Lookup_concat($A2,المصروف!$A$2:$A$500,المصروف!$C$2:$C$500)","v":"1/11/2018 7/11/2018 10/11/2018 20/11/2018"},{"$f":"Lookup_concat($A2,المصروف!$A$2:$A$500,المصروف!$B$2:$B$500)","v":"الصابر المحبة السلام الخالدية"}]
[828,"ليث",{"$f":"IF($A3<>\"\",SUMIF(المصروف!$D$2:$D$215,$A3,المصروف!$H$2:$H$215),\"\")","v":800000},{"$f":"IF($A3<>\"\",SUMIF(المصروف!$D$2:$D$215,$A3,المصروف!$I$2:$I$215),\"\")","v":300000},500000,{"$f":"COUNTIF(المصروف!$D$2:$D$215,A3)","v":2},{"$f":"Lookup_concat($A3,المصروف!$A$2:$A$500,المصروف!$C$2:$C$500)","v":"25/11/2018 29/11/2018"},{"$f":"Lookup_concat($A3,المصروف!$A$2:$A$500,المصروف!$B$2:$B$500)","v":"تاج القدس الرحالية"}]
[1419,"حسين",{"$f":"IF($A4<>\"\",SUMIF(المصروف!$D$2:$D$215,$A4,المصروف!$H$2:$H$215),\"\")","v":1350000},{"$f":"IF($A4<>\"\",SUMIF(المصروف!$D$2:$D$215,$A4,المصروف!$I$2:$I$215),\"\")","v":400000},950000,{"$f":"COUNTIF(المصروف!$D$2:$D$215,A4)","v":3},{"$f":"Lookup_concat($A4,المصروف!$A$2:$A$500,المصروف!$C$2:$C$500)","v":"3/11/2018 13/11/2018 21/11/2018"},{"$f":"Lookup_concat($A4,المصروف!$A$2:$A$500,المصروف!$B$2:$B$500)","v":"الجوهرة الخالدية الأمن"}]