{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["40229","25905","47895","SALIM_BALANCE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"40229","index":0,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["م","DATE التاريخ","NO TRUCK رقم السيارة ","NO TICKET رقم الفاتورة ","DESTINATION الموقع","CRUCHER الكسارة","MATERIAL المادة","NETWET الوزن","RATE سعر الطن","TOTAL الاجمالى","FUJ ت/فجيرة","SAEEDY ت/ساعدي","DHAID ت/الذيد","ZUBAIR ت/الزبير","ALGHAIL  ت/الغيل","KADRAA  ت/كدرة","DIESEL الديزل","SALARY الراتب"]
[{"$f":"IF(B2=\"\",\"\",MAX($A$1:A1)+1)","v":1},"2019-03-01",40229,141340,"AL QUOZ","AL FUTTAIM","Road base",71.900000000000006,{"$f":"IF(B2=\"\",\"\",(IF(AND(F2=\"RIDI SIDI\"),16.65,IF(AND(F2=\"CENTRAL\",E2=\"DUBAI\"),19,IF(AND(F2=\"CENTRAL\",E2=\"JEBEL ALI\"),21,IF(AND(F2=\"AL RAWASI\"),16.65,IF(AND(F2=\"AL NAKHEEL\"),16.65,IF(AND(F2=\"WB\"),22.6,IF(AND(F2=\"AL BARRAK\",E2=\"DUCON\"),21.97,IF(AND(F2=\"AL KAWTHER\",E2=\"DUCON\"),21.97,IF(AND(F2=\"AL KAWTHER\"),22.5,IF(AND(F2=\"AL FUTTAIM\",E2=\"JEBEL ALI\"),8.75,IF(AND(F2=\"AL FUTTAIM\",E2=\"MAFRAQ\"),16,IF(AND(F2=\"AL FUTTAIM\",E2=\"AL QUOZ\"),7.7,IF(AND(F2=\"AL FUTTAIM\",E2=\"MUSSAFAH\"),16.9,IF(AND(F2=\"AL FUTTAIM\",E2=\"NAD AL SHEBA\"),8.5,IF(AND(F2=\"AL FUTTAIM\",E2=\"MAHAWI\"),16.9,IF(AND(F2=\"AL RAWDA\",E2=\"MADAM\"),24.5,)))))))))))))))))*1)","v":7.7},{"$f":"IF(B2=\"\",\"\",I2*H2)","v":553.63000000000011},null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B3=\"\",\"\",MAX($A$1:A2)+1)","v":2},"2019-03-01",40229,141363,"AL QUOZ","AL FUTTAIM","Road base",76.98,7.7,592.74600000000009,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B4=\"\",\"\",MAX($A$1:A3)+1)","v":3},"2019-03-02",40229,899558,"DUCON","AL BARRAK","Road base",72.34,21.97,1589.3098,510,null,420.5,null,null,null,0,90]
[{"$f":"IF(B5=\"\",\"\",MAX($A$1:A4)+1)","v":4},"2019-03-02",40229,2213550,"Cement Factory","AL NAKHEEL","Road base",77.400000000000006,16.649999999999999,1288.71,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B6=\"\",\"\",MAX($A$1:A5)+1)","v":5},"2019-03-03",40229,2213622,"Cement Factory","AL NAKHEEL","Road base",72.239999999999995,16.649999999999999,1202.7959999999998,null,300,null,null,null,null,0,100]
[{"$f":"IF(B7=\"\",\"\",MAX($A$1:A6)+1)","v":6},"2019-03-03",40229,2213839,"Cement Factory","AL NAKHEEL","Road base",73.86,16.649999999999999,1229.7689999999998,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B8=\"\",\"\",MAX($A$1:A7)+1)","v":7},"2019-03-03",40229,141446,"JEBEL ALI","AL FUTTAIM","Road base",74,8.75,647.5,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B9=\"\",\"\",MAX($A$1:A8)+1)","v":8},"2019-03-04",40229,2213866,"Cement Factory","AL NAKHEEL","Road base",74.52,16.649999999999999,1240.7579999999998,null,300,null,null,null,null,0,100]
[{"$f":"IF(B10=\"\",\"\",MAX($A$1:A9)+1)","v":9},"2019-03-04",40229,2213907,"Cement Factory","AL RAWASI","Road base",76.34,16.649999999999999,1271.0609999999999,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B11=\"\",\"\",MAX($A$1:A10)+1)","v":10},"2019-03-04",40229,2213953,"Cement Factory","AL RAWASI","Road base",76.38,16.649999999999999,1271.7269999999999,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B12=\"\",\"\",MAX($A$1:A11)+1)","v":11},"2019-03-04",40229,141622,"JEBEL ALI","AL FUTTAIM","Road base",77.319999999999993,8.75,676.55,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B13=\"\",\"\",MAX($A$1:A12)+1)","v":12},"2019-03-05",40229,2214077,"Cement Factory","AL RAWASI","Road base",76.680000000000007,16.649999999999999,1276.722,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B14=\"\",\"\",MAX($A$1:A13)+1)","v":""},null,40229,2214150,"Cement Factory","AL RAWASI","Road base",80.040000000000006,"","",null,300,null,null,null,null,0,100]
[{"$f":"IF(B15=\"\",\"\",MAX($A$1:A14)+1)","v":""},null,40229,2214211,"Cement Factory","AL RAWASI","Road base",77.760000000000005,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B16=\"\",\"\",MAX($A$1:A15)+1)","v":""},null,40229,2214268,"Cement Factory","AL RAWASI","Road base",77.599999999999994,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B17=\"\",\"\",MAX($A$1:A16)+1)","v":""},null,40229,2214325,"Cement Factory","AL RAWASI","Road base",76.28,"","",null,300,null,null,null,null,0,100]
[{"$f":"IF(B18=\"\",\"\",MAX($A$1:A17)+1)","v":""},null,40229,2214492,"Cement Factory","AL RAWASI","Road base",73.739999999999995,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B19=\"\",\"\",MAX($A$1:A18)+1)","v":""},null,40229,141848,"JEBEL ALI","AL FUTTAIM","Road base",74.459999999999994,"","",null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B20=\"\",\"\",MAX($A$1:A19)+1)","v":""},null,40229,2214596,"Cement Factory","AL RAWASI","Road base",79.36,"","",null,300,null,null,null,null,0,100]
[{"$f":"IF(B21=\"\",\"\",MAX($A$1:A20)+1)","v":""},null,40229,2214749,"Cement Factory","AL NAKHEEL","Road base",76.2,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B22=\"\",\"\",MAX($A$1:A21)+1)","v":""},null,40229,2214823,"Cement Factory","AL RAWASI","Road base",80.5,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B23=\"\",\"\",MAX($A$1:A22)+1)","v":""},null,40229,2214685,"Cement Factory","AL RAWASI","Road base",73.959999999999994,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B24=\"\",\"\",MAX($A$1:A23)+1)","v":""},null,40229,2214907,"Cement Factory","AL RAWASI","Road base",76.12,"","",null,300,null,null,null,null,0,100]
[{"$f":"IF(B25=\"\",\"\",MAX($A$1:A24)+1)","v":""},null,40229,2215086,"Cement Factory","AL RAWASI","Road base",83.86,"","",null,300,420.5,null,null,null,0,75]
[null,{"$f":"SUBTOTAL(2,B2:B25)","v":12},null,null,null,null,null,{"$f":"SUBTOTAL(9,H2:H25)","v":1829.84},{"$f":"SUBTOTAL(9,I2:I25)*1","v":171.42000000000002},{"$f":"SUBTOTAL(9,J2:J25)","v":12841.278799999998},510,5400,7569,0,0,2750,0,1970]

{"sheet":"25905","index":1,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["م","DATE التاريخ","NO TRUCK رقم السيارة ","NO TICKET رقم الفاتورة ","DESTINATION الموقع","CRUCHER الكسارة","MATERIAL المادة","NETWET الوزن","RATE سعر الطن","TOTAL الاجمالى","FUJ ت/فجيرة","SAEEDY ت/ساعدي","DHAID ت/الذيد","ZUBAIR ت/الزبير","ALGHAIL  ت/الغيل","KADRAA  ت/كدرة","DIESEL الديزل","SALARY الراتب"]
[{"$f":"IF(B2=\"\",\"\",MAX($A$1:A1)+1)","v":1},"2019-03-01",25905,141336,"MUSSAFAH","AL FUTTAIM","Road base",78.540000000000006,{"$f":"(IF(AND(F2=\"RIDI SIDI\"),\"16.65\",IF(AND(F2=\"CENTRAL\",E2=\"DUBAI\"),\"19\",IF(AND(F2=\"CENTRAL\",E2=\"JEBEL ALI\"),\"21\",IF(AND(F2=\"AL RAWASI\"),\"16.65\",IF(AND(F2=\"AL NAKHEEL\"),\"16.65\",IF(AND(F2=\"WB\"),\"22.60\",IF(AND(F2=\"AL BARRAK\",E2=\"DUCON\"),\"21.97\",IF(AND(F2=\"AL KAWTHER\",E2=\"DUCON\"),\"21.97\",IF(AND(F2=\"AL KAWTHER\"),\"22.5\",IF(AND(F2=\"AL FUTTAIM\",E2=\"JEBEL ALI\"),\"8.75\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MAFRAQ\"),\"16\",IF(AND(F2=\"AL FUTTAIM\",E2=\"AL QUOZ\"),\"7.70\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MUSSAFAH\"),\"16.90\",IF(AND(F2=\"AL FUTTAIM\",E2=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MAHAWI\"),\"16.90\",IF(AND(F2=\"AL RAWDA\",E2=\"MADAM\"),\"24.50\",)))))))))))))))))*1","v":16.899999999999999},{"$f":"IF(B2=\"\",\"\",I2*H2)","v":1327.326},null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B3=\"\",\"\",MAX($A$1:A2)+1)","v":2},"2019-03-02",25905,141432,"JEBEL ALI","AL FUTTAIM","Road base",75.94,8.75,664.47500000000002,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B4=\"\",\"\",MAX($A$1:A3)+1)","v":3},"2019-03-02",25905,141383,"AL QUOZ","AL FUTTAIM","Road base",76.58,7.7,589.66600000000005,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B5=\"\",\"\",MAX($A$1:A4)+1)","v":4},"2019-03-03",25905,141489,"MAFRAQ","AL FUTTAIM","Road base",77.2,16,1235.2,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B6=\"\",\"\",MAX($A$1:A5)+1)","v":5},"2019-03-03",25905,141448,"AL QUOZ","AL FUTTAIM","Road base",76.540000000000006,7.7,589.35800000000006,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B7=\"\",\"\",MAX($A$1:A6)+1)","v":6},"2019-03-04",25905,141619,"JEBEL ALI","AL FUTTAIM","Road base",78.48,8.75,686.7,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B8=\"\",\"\",MAX($A$1:A7)+1)","v":7},"2019-03-04",25905,141566,"AL QUOZ","AL FUTTAIM","Road base",75.38,{"$f":"IF(B2=\"\",\"\",(IF(AND(F8=\"RIDI SIDI\"),\"16.65\",IF(AND(F8=\"CENTRAL\",E8=\"DUBAI\"),\"19\",IF(AND(F8=\"CENTRAL\",E8=\"JEBEL ALI\"),\"21\",IF(AND(F8=\"AL RAWASI\"),\"16.65\",IF(AND(F8=\"AL NAKHEEL\"),\"16.65\",IF(AND(F8=\"WB\"),\"22.60\",IF(AND(F8=\"AL BARRAK\",E8=\"DUCON\"),\"21.97\",IF(AND(F8=\"AL KAWTHER\",E8=\"DUCON\"),\"21.97\",IF(AND(F8=\"AL KAWTHER\"),\"22.5\",IF(AND(F8=\"AL FUTTAIM\",E8=\"JEBEL ALI\"),\"8.75\",IF(AND(F8=\"AL FUTTAIM\",E8=\"MAFRAQ\"),\"16\",IF(AND(F8=\"AL FUTTAIM\",E8=\"AL QUOZ\"),\"7.70\",IF(AND(F8=\"AL FUTTAIM\",E8=\"MUSSAFAH\"),\"16.90\",IF(AND(F8=\"AL FUTTAIM\",E8=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F8=\"AL FUTTAIM\",E8=\"MAHAWI\"),\"16.90\",IF(AND(F8=\"AL RAWDA\",E8=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":7.7},580.42599999999993,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B9=\"\",\"\",MAX($A$1:A8)+1)","v":8},"2019-03-05",25905,141733,"MAFRAQ","AL FUTTAIM","Road base",74.900000000000006,{"$f":"IF(B3=\"\",\"\",(IF(AND(F9=\"RIDI SIDI\"),\"16.65\",IF(AND(F9=\"CENTRAL\",E9=\"DUBAI\"),\"19\",IF(AND(F9=\"CENTRAL\",E9=\"JEBEL ALI\"),\"21\",IF(AND(F9=\"AL RAWASI\"),\"16.65\",IF(AND(F9=\"AL NAKHEEL\"),\"16.65\",IF(AND(F9=\"WB\"),\"22.60\",IF(AND(F9=\"AL BARRAK\",E9=\"DUCON\"),\"21.97\",IF(AND(F9=\"AL KAWTHER\",E9=\"DUCON\"),\"21.97\",IF(AND(F9=\"AL KAWTHER\"),\"22.5\",IF(AND(F9=\"AL FUTTAIM\",E9=\"JEBEL ALI\"),\"8.75\",IF(AND(F9=\"AL FUTTAIM\",E9=\"MAFRAQ\"),\"16\",IF(AND(F9=\"AL FUTTAIM\",E9=\"AL QUOZ\"),\"7.70\",IF(AND(F9=\"AL FUTTAIM\",E9=\"MUSSAFAH\"),\"16.90\",IF(AND(F9=\"AL FUTTAIM\",E9=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F9=\"AL FUTTAIM\",E9=\"MAHAWI\"),\"16.90\",IF(AND(F9=\"AL RAWDA\",E9=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":16},1198.4000000000001,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B10=\"\",\"\",MAX($A$1:A9)+1)","v":9},"2019-03-05",25905,141667,"JEBEL ALI","AL FUTTAIM","Road base",76.900000000000006,8.75,672.875,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B11=\"\",\"\",MAX($A$1:A10)+1)","v":10},"2019-03-05",25905,141700,"AL QUOZ","AL FUTTAIM","Road base",74.88,7.7,576.57600000000002,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B12=\"\",\"\",MAX($A$1:A11)+1)","v":11},"2019-03-05",25905,141666,"JEBEL ALI","AL FUTTAIM","Road base",76.92,8.75,673.05000000000007,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B13=\"\",\"\",MAX($A$1:A12)+1)","v":12},"2019-03-06",25905,2214219,"Cement Factory","AL RAWASI","Road base",82.64,16.649999999999999,1375.9559999999999,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B14=\"\",\"\",MAX($A$1:A13)+1)","v":13},"2019-03-06",25905,2214293,"Cement Factory","AL RAWASI","Road base",86.96,16.649999999999999,1447.8839999999998,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B15=\"\",\"\",MAX($A$1:A14)+1)","v":14},"2019-03-07",25905,2214336,"Cement Factory","AL NAKHEEL","Road base",75.92,16.649999999999999,1264.068,null,300,null,null,null,null,0,100]
[{"$f":"IF(B16=\"\",\"\",MAX($A$1:A15)+1)","v":15},"2019-03-07",25905,2214392,"Cement Factory","AL RAWASI","Road base",82.76,16.649999999999999,1377.954,null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B17=\"\",\"\",MAX($A$1:A16)+1)","v":16},"2019-03-08",25905,2214574,"Cement Factory","AL RAWASI","Road base",84.7,16.649999999999999,1410.2549999999999,null,300,null,null,null,null,0,100]
[{"$f":"IF(B18=\"\",\"\",MAX($A$1:A17)+1)","v":""},null,25905,141951,"MAFRAQ","AL FUTTAIM","Road base",77.56,16,"",null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B19=\"\",\"\",MAX($A$1:A18)+1)","v":""},null,25905,2214865,"Cement Factory","AL RAWASI","Road base",85.08,16.649999999999999,"",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B20=\"\",\"\",MAX($A$1:A19)+1)","v":""},null,25905,142033,"MUSSAFAH","AL FUTTAIM","Road base",79.52,16.899999999999999,"",null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B21=\"\",\"\",MAX($A$1:A20)+1)","v":""},null,25905,142150,"MUSSAFAH","AL FUTTAIM","Road base",76.599999999999994,16.899999999999999,"",null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B22=\"\",\"\",MAX($A$1:A21)+1)","v":""},null,25905,142095,"JEBEL ALI","AL FUTTAIM","Road base",79.12,8.75,"",null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B23=\"\",\"\",MAX($A$1:A22)+1)","v":""},null,25905,2215384,"Cement Factory","AL RAWASI","Road base",81.599999999999994,16.649999999999999,"",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B24=\"\",\"\",MAX($A$1:A23)+1)","v":""},null,25905,2215226,"Cement Factory","AL RAWASI","Road base",73.36,"","",null,300,420.5,null,null,null,0,75]
[{"$f":"IF(B25=\"\",\"\",MAX($A$1:A24)+1)","v":""},null,25905,142380,"MUSSAFAH","AL FUTTAIM","Road base",80.760000000000005,"","",null,null,420.5,null,null,550,0,180]
[null,{"$f":"SUBTOTAL(2,B2:B25)","v":16},null,null,null,null,null,{"$f":"SUBTOTAL(9,H2:H25)","v":1888.8399999999997},289.8,15670.168999999998,0,2400,9251,0,0,8800,0,2530]

{"sheet":"47895","index":2,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["م","DATE التاريخ","NO TRUCK رقم السيارة ","NO TICKET رقم الفاتورة ","DESTINATION الموقع","CRUCHER الكسارة","MATERIAL المادة","NETWET الوزن","RATE سعر الطن","TOTAL الاجمالى","FUJ ت/فجيرة","SAEEDY ت/ساعدي","DHAID ت/الذيد","ZUBAIR ت/الزبير","ALGHAIL  ت/الغيل","KADRAA  ت/كدرة","DIESEL الديزل","SALARY الراتب"]
[{"$f":"IF(B2=\"\",\"\",MAX($A$1:A1)+1)","v":1},"2019-03-01",47895,141334,"MUSSAFAH","AL FUTTAIM","Road base",77.8,{"$f":"IF(B2=\"\",\"\",(IF(AND(F2=\"RIDI SIDI\"),\"16.65\",IF(AND(F2=\"CENTRAL\",E2=\"DUBAI\"),\"19\",IF(AND(F2=\"CENTRAL\",E2=\"JEBEL ALI\"),\"21\",IF(AND(F2=\"AL RAWASI\"),\"16.65\",IF(AND(F2=\"AL NAKHEEL\"),\"16.65\",IF(AND(F2=\"WB\"),\"22.60\",IF(AND(F2=\"AL BARRAK\",E2=\"DUCON\"),\"21.97\",IF(AND(F2=\"AL KAWTHER\",E2=\"DUCON\"),\"21.97\",IF(AND(F2=\"AL KAWTHER\"),\"22.5\",IF(AND(F2=\"AL FUTTAIM\",E2=\"JEBEL ALI\"),\"8.75\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MAFRAQ\"),\"16\",IF(AND(F2=\"AL FUTTAIM\",E2=\"AL QUOZ\"),\"7.70\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MUSSAFAH\"),\"16.90\",IF(AND(F2=\"AL FUTTAIM\",E2=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F2=\"AL FUTTAIM\",E2=\"MAHAWI\"),\"16.90\",IF(AND(F2=\"AL RAWDA\",E2=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":16.899999999999999},{"$f":"IF(B2=\"\",\"\",I2*H2)","v":1314.82},null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B3=\"\",\"\",MAX($A$1:A2)+1)","v":2},"2019-03-02",47895,141426,"MAFRAQ","AL FUTTAIM","Road base",76.78,16,1228.48,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B4=\"\",\"\",MAX($A$1:A3)+1)","v":3},"2019-03-02",47895,141380,"AL QUOZ","AL FUTTAIM","Road base",76.239999999999995,7.7,587.048,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B5=\"\",\"\",MAX($A$1:A4)+1)","v":4},"2019-03-03",47895,141532,"MAFRAQ","AL FUTTAIM","Road base",77,16,1232,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B6=\"\",\"\",MAX($A$1:A5)+1)","v":5},"2019-03-03",47895,141470,"AL QUOZ","AL FUTTAIM","Road base",75,7.7,577.5,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B7=\"\",\"\",MAX($A$1:A6)+1)","v":6},"2019-03-04",47895,141647,"MAFRAQ","AL FUTTAIM","Road base",76.84,16,1229.44,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B8=\"\",\"\",MAX($A$1:A7)+1)","v":7},"2019-03-04",47895,141596,"JEBEL ALI","AL FUTTAIM","Road base",76.84,8.75,672.35,null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B9=\"\",\"\",MAX($A$1:A8)+1)","v":8},"2019-03-05",47895,141816,"MUSSAFAH","AL FUTTAIM","Road base",77.819999999999993,16.899999999999999,1315.1579999999997,null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B10=\"\",\"\",MAX($A$1:A9)+1)","v":9},"2019-03-05",47895,141688,"AL QUOZ","AL FUTTAIM","Road base",74.16,7.7,571.03200000000004,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B11=\"\",\"\",MAX($A$1:A10)+1)","v":10},"2019-03-06",47895,141782,"AL QUOZ","AL FUTTAIM","Road base",76.38,7.7,588.12599999999998,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B12=\"\",\"\",MAX($A$1:A11)+1)","v":11},"2019-03-06",47895,141832,"MAFRAQ","AL FUTTAIM","Road base",75.36,16,1205.76,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B13=\"\",\"\",MAX($A$1:A12)+1)","v":12},"2019-03-07",47895,141897,"AL QUOZ","AL FUTTAIM","Road base",76.260000000000005,7.7,587.202,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B14=\"\",\"\",MAX($A$1:A13)+1)","v":13},"2019-03-08",47895,2214588,"Cement Factory","AL RAWASI","Road base",82.28,16.649999999999999,1369.962,null,300,null,null,null,null,0,100]
[{"$f":"IF(B15=\"\",\"\",MAX($A$1:A14)+1)","v":14},"2019-03-08",47895,141995,"MUSSAFAH","AL FUTTAIM","Road base",79.819999999999993,16.899999999999999,1348.9579999999999,null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B16=\"\",\"\",MAX($A$1:A15)+1)","v":15},"2019-03-08",47895,141953,"MAFRAQ","AL FUTTAIM","Road base",78.72,16,1259.52,null,null,420.5,null,null,550,0,160]
[{"$f":"IF(B17=\"\",\"\",MAX($A$1:A16)+1)","v":16},"2019-03-09",47895,142073,"AL QUOZ","AL FUTTAIM","Road base",76.099999999999994,7.7,585.96999999999991,null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B18=\"\",\"\",MAX($A$1:A17)+1)","v":17},"2019-03-10",47895,142116,"MUSSAFAH","AL FUTTAIM","Road base",77.400000000000006,16.899999999999999,1308.06,null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B19=\"\",\"\",MAX($A$1:A18)+1)","v":""},null,47895,142210,"AL QUOZ","AL FUTTAIM","Road base",75.06,"","",null,null,420.5,null,null,550,0,70]
[{"$f":"IF(B20=\"\",\"\",MAX($A$1:A19)+1)","v":""},null,47895,142240,"MUSSAFAH","AL FUTTAIM","Road base",78.06,"","",null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B21=\"\",\"\",MAX($A$1:A20)+1)","v":""},null,47895,901373,"DUCON","AL BARRAK","Road base",75.06,"","",530,null,420.5,null,null,null,0,90]
[{"$f":"IF(B22=\"\",\"\",MAX($A$1:A21)+1)","v":""},null,47895,142404,"MUSSAFAH","AL FUTTAIM","Road base",78.28,"","",null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B23=\"\",\"\",MAX($A$1:A22)+1)","v":""},null,47895,142446,"JEBEL ALI","AL FUTTAIM","Road base",76.92,"","",null,null,420.5,null,null,550,0,80]
[{"$f":"IF(B24=\"\",\"\",MAX($A$1:A23)+1)","v":""},null,47895,142630,"MUSSAFAH","AL FUTTAIM","Road base",75.06,"","",null,null,420.5,null,null,550,0,180]
[{"$f":"IF(B25=\"\",\"\",MAX($A$1:A24)+1)","v":""},null,47895,142517,"MUSSAFAH","AL FUTTAIM","Road base",79.36,{"$f":"IF(B25=\"\",\"\",(IF(AND(F25=\"RIDI SIDI\"),\"16.65\",IF(AND(F25=\"CENTRAL\",E25=\"DUBAI\"),\"19\",IF(AND(F25=\"CENTRAL\",E25=\"JEBEL ALI\"),\"21\",IF(AND(F25=\"AL RAWASI\"),\"16.65\",IF(AND(F25=\"AL NAKHEEL\"),\"16.65\",IF(AND(F25=\"WB\"),\"22.60\",IF(AND(F25=\"AL BARRAK\",E25=\"DUCON\"),\"21.97\",IF(AND(F25=\"AL KAWTHER\",E25=\"DUCON\"),\"21.97\",IF(AND(F25=\"AL KAWTHER\"),\"22.5\",IF(AND(F25=\"AL FUTTAIM\",E25=\"JEBEL ALI\"),\"8.75\",IF(AND(F25=\"AL FUTTAIM\",E25=\"MAFRAQ\"),\"16\",IF(AND(F25=\"AL FUTTAIM\",E25=\"AL QUOZ\"),\"7.70\",IF(AND(F25=\"AL FUTTAIM\",E25=\"MUSSAFAH\"),\"16.90\",IF(AND(F25=\"AL FUTTAIM\",E25=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F25=\"AL FUTTAIM\",E25=\"MAHAWI\"),\"16.90\",IF(AND(F25=\"AL RAWDA\",E25=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":""},"",null,null,420.5,null,null,550,0,180]
[null,{"$f":"SUBTOTAL(2,B5:B25)","v":14},null,null,null,null,null,{"$f":"SUBTOTAL(9,H5:H25)","v":1617.7799999999997},{"$f":"SUBTOTAL(9,I2:I25)","v":219.2},{"$f":"SUBTOTAL(9,J2:J25)","v":16981.385999999999},{"$f":"SUBTOTAL(9,K2:K25)","v":530},300,9671.5,0,0,12100,{"$f":"SUBTOTAL(9,Q5:Q25)","v":0},{"$f":"SUBTOTAL(9,R5:R25)","v":2670}]

{"sheet":"SALIM_BALANCE","index":3,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,11,82,17]]}
["م","DATE التاريخ","NO TRUCK رقم السيارة ","NO TICKET رقم الفاتورة ","DESTINATION الموقع","CRUCHER الكسارة","MATERIAL المادة","NETWET الوزن","RATE سعر الطن","TOTAL الاجمالى"]
[1,"2019-03-01",40229,141340,"AL QUOZ","AL FUTTAIM","Road base",71.900000000000006,{"$f":"IF(B2=\"\",\"\",(IF(AND(F2=\"RIDI SIDI\"),16.65,IF(AND(F2=\"CENTRAL\",E2=\"DUBAI\"),19,IF(AND(F2=\"CENTRAL\",E2=\"JEBEL ALI\"),21,IF(AND(F2=\"AL RAWASI\"),16.65,IF(AND(F2=\"AL NAKHEEL\"),16.65,IF(AND(F2=\"WB\"),22.6,IF(AND(F2=\"AL BARRAK\",E2=\"DUCON\"),21.97,IF(AND(F2=\"AL KAWTHER\",E2=\"DUCON\"),21.97,IF(AND(F2=\"AL KAWTHER\"),22.5,IF(AND(F2=\"AL FUTTAIM\",E2=\"JEBEL ALI\"),8.75,IF(AND(F2=\"AL FUTTAIM\",E2=\"MAFRAQ\"),16,IF(AND(F2=\"AL FUTTAIM\",E2=\"AL QUOZ\"),7.7,IF(AND(F2=\"AL FUTTAIM\",E2=\"MUSSAFAH\"),16.9,IF(AND(F2=\"AL FUTTAIM\",E2=\"NAD AL SHEBA\"),8.5,IF(AND(F2=\"AL FUTTAIM\",E2=\"MAHAWI\"),16.9,IF(AND(F2=\"AL RAWDA\",E2=\"MADAM\"),24.5,)))))))))))))))))*1)","v":7.7},{"$f":"IF(B2=\"\",\"\",I2*H2)","v":553.63000000000011},"BEGIN OF SHEET: 40229"]
[2,"2019-03-01",40229,141363,"AL QUOZ","AL FUTTAIM","Road base",76.98,7.7,592.74600000000009]
[3,"2019-03-02",40229,899558,"DUCON","AL BARRAK","Road base",72.34,21.97,1589.3098]
[4,"2019-03-02",40229,2213550,"Cement Factory","AL NAKHEEL","Road base",77.400000000000006,16.649999999999999,1288.71]
[5,"2019-03-03",40229,2213622,"Cement Factory","AL NAKHEEL","Road base",72.239999999999995,16.649999999999999,1202.7959999999998]
[6,"2019-03-03",40229,2213839,"Cement Factory","AL NAKHEEL","Road base",73.86,16.649999999999999,1229.7689999999998]
[7,"2019-03-03",40229,141446,"JEBEL ALI","AL FUTTAIM","Road base",74,8.75,647.5]
[8,"2019-03-04",40229,2213866,"Cement Factory","AL NAKHEEL","Road base",74.52,16.649999999999999,1240.7579999999998]
[9,"2019-03-04",40229,2213907,"Cement Factory","AL RAWASI","Road base",76.34,16.649999999999999,1271.0609999999999]
[10,"2019-03-04",40229,2213953,"Cement Factory","AL RAWASI","Road base",76.38,16.649999999999999,1271.7269999999999]
[11,"2019-03-04",40229,141622,"JEBEL ALI","AL FUTTAIM","Road base",77.319999999999993,8.75,676.55]
[12,"2019-03-05",40229,2214077,"Cement Factory","AL RAWASI","Road base",76.680000000000007,16.649999999999999,1276.722,"END OF SHEET: 40229"]
[null,12,null,null,null,null,null,1829.84,171.42000000000002,12841.278799999998,"SUM"]
[1,"2019-03-01",25905,141336,"MUSSAFAH","AL FUTTAIM","Road base",78.540000000000006,{"$f":"(IF(AND(F15=\"RIDI SIDI\"),\"16.65\",IF(AND(F15=\"CENTRAL\",E15=\"DUBAI\"),\"19\",IF(AND(F15=\"CENTRAL\",E15=\"JEBEL ALI\"),\"21\",IF(AND(F15=\"AL RAWASI\"),\"16.65\",IF(AND(F15=\"AL NAKHEEL\"),\"16.65\",IF(AND(F15=\"WB\"),\"22.60\",IF(AND(F15=\"AL BARRAK\",E15=\"DUCON\"),\"21.97\",IF(AND(F15=\"AL KAWTHER\",E15=\"DUCON\"),\"21.97\",IF(AND(F15=\"AL KAWTHER\"),\"22.5\",IF(AND(F15=\"AL FUTTAIM\",E15=\"JEBEL ALI\"),\"8.75\",IF(AND(F15=\"AL FUTTAIM\",E15=\"MAFRAQ\"),\"16\",IF(AND(F15=\"AL FUTTAIM\",E15=\"AL QUOZ\"),\"7.70\",IF(AND(F15=\"AL FUTTAIM\",E15=\"MUSSAFAH\"),\"16.90\",IF(AND(F15=\"AL FUTTAIM\",E15=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F15=\"AL FUTTAIM\",E15=\"MAHAWI\"),\"16.90\",IF(AND(F15=\"AL RAWDA\",E15=\"MADAM\"),\"24.50\",)))))))))))))))))*1","v":16.899999999999999},{"$f":"IF(B15=\"\",\"\",I15*H15)","v":1327.326},"BEGIN OF SHEET: 25905"]
[2,"2019-03-02",25905,141432,"JEBEL ALI","AL FUTTAIM","Road base",75.94,8.75,664.47500000000002]
[3,"2019-03-02",25905,141383,"AL QUOZ","AL FUTTAIM","Road base",76.58,7.7,589.66600000000005]
[4,"2019-03-03",25905,141489,"MAFRAQ","AL FUTTAIM","Road base",77.2,16,1235.2]
[5,"2019-03-03",25905,141448,"AL QUOZ","AL FUTTAIM","Road base",76.540000000000006,7.7,589.35800000000006]
[6,"2019-03-04",25905,141619,"JEBEL ALI","AL FUTTAIM","Road base",78.48,8.75,686.7]
[7,"2019-03-04",25905,141566,"AL QUOZ","AL FUTTAIM","Road base",75.38,{"$f":"IF(B15=\"\",\"\",(IF(AND(F21=\"RIDI SIDI\"),\"16.65\",IF(AND(F21=\"CENTRAL\",E21=\"DUBAI\"),\"19\",IF(AND(F21=\"CENTRAL\",E21=\"JEBEL ALI\"),\"21\",IF(AND(F21=\"AL RAWASI\"),\"16.65\",IF(AND(F21=\"AL NAKHEEL\"),\"16.65\",IF(AND(F21=\"WB\"),\"22.60\",IF(AND(F21=\"AL BARRAK\",E21=\"DUCON\"),\"21.97\",IF(AND(F21=\"AL KAWTHER\",E21=\"DUCON\"),\"21.97\",IF(AND(F21=\"AL KAWTHER\"),\"22.5\",IF(AND(F21=\"AL FUTTAIM\",E21=\"JEBEL ALI\"),\"8.75\",IF(AND(F21=\"AL FUTTAIM\",E21=\"MAFRAQ\"),\"16\",IF(AND(F21=\"AL FUTTAIM\",E21=\"AL QUOZ\"),\"7.70\",IF(AND(F21=\"AL FUTTAIM\",E21=\"MUSSAFAH\"),\"16.90\",IF(AND(F21=\"AL FUTTAIM\",E21=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F21=\"AL FUTTAIM\",E21=\"MAHAWI\"),\"16.90\",IF(AND(F21=\"AL RAWDA\",E21=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":7.7},580.42599999999993]
[8,"2019-03-05",25905,141733,"MAFRAQ","AL FUTTAIM","Road base",74.900000000000006,{"$f":"IF(B16=\"\",\"\",(IF(AND(F22=\"RIDI SIDI\"),\"16.65\",IF(AND(F22=\"CENTRAL\",E22=\"DUBAI\"),\"19\",IF(AND(F22=\"CENTRAL\",E22=\"JEBEL ALI\"),\"21\",IF(AND(F22=\"AL RAWASI\"),\"16.65\",IF(AND(F22=\"AL NAKHEEL\"),\"16.65\",IF(AND(F22=\"WB\"),\"22.60\",IF(AND(F22=\"AL BARRAK\",E22=\"DUCON\"),\"21.97\",IF(AND(F22=\"AL KAWTHER\",E22=\"DUCON\"),\"21.97\",IF(AND(F22=\"AL KAWTHER\"),\"22.5\",IF(AND(F22=\"AL FUTTAIM\",E22=\"JEBEL ALI\"),\"8.75\",IF(AND(F22=\"AL FUTTAIM\",E22=\"MAFRAQ\"),\"16\",IF(AND(F22=\"AL FUTTAIM\",E22=\"AL QUOZ\"),\"7.70\",IF(AND(F22=\"AL FUTTAIM\",E22=\"MUSSAFAH\"),\"16.90\",IF(AND(F22=\"AL FUTTAIM\",E22=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F22=\"AL FUTTAIM\",E22=\"MAHAWI\"),\"16.90\",IF(AND(F22=\"AL RAWDA\",E22=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":16},1198.4000000000001]
[9,"2019-03-05",25905,141667,"JEBEL ALI","AL FUTTAIM","Road base",76.900000000000006,8.75,672.875]
[10,"2019-03-05",25905,141700,"AL QUOZ","AL FUTTAIM","Road base",74.88,7.7,576.57600000000002]
[11,"2019-03-05",25905,141666,"JEBEL ALI","AL FUTTAIM","Road base",76.92,8.75,673.05000000000007]
[12,"2019-03-06",25905,2214219,"Cement Factory","AL RAWASI","Road base",82.64,16.649999999999999,1375.9559999999999]
[13,"2019-03-06",25905,2214293,"Cement Factory","AL RAWASI","Road base",86.96,16.649999999999999,1447.8839999999998]
[14,"2019-03-07",25905,2214336,"Cement Factory","AL NAKHEEL","Road base",75.92,16.649999999999999,1264.068]
[15,"2019-03-07",25905,2214392,"Cement Factory","AL RAWASI","Road base",82.76,16.649999999999999,1377.954]
[16,"2019-03-08",25905,2214574,"Cement Factory","AL RAWASI","Road base",84.7,16.649999999999999,1410.2549999999999,"END OF SHEET: 25905"]
[null,16,null,null,null,null,null,1888.8399999999997,289.8,15670.168999999998,"SUM"]
[1,"2019-03-01",47895,141334,"MUSSAFAH","AL FUTTAIM","Road base",77.8,{"$f":"IF(B32=\"\",\"\",(IF(AND(F32=\"RIDI SIDI\"),\"16.65\",IF(AND(F32=\"CENTRAL\",E32=\"DUBAI\"),\"19\",IF(AND(F32=\"CENTRAL\",E32=\"JEBEL ALI\"),\"21\",IF(AND(F32=\"AL RAWASI\"),\"16.65\",IF(AND(F32=\"AL NAKHEEL\"),\"16.65\",IF(AND(F32=\"WB\"),\"22.60\",IF(AND(F32=\"AL BARRAK\",E32=\"DUCON\"),\"21.97\",IF(AND(F32=\"AL KAWTHER\",E32=\"DUCON\"),\"21.97\",IF(AND(F32=\"AL KAWTHER\"),\"22.5\",IF(AND(F32=\"AL FUTTAIM\",E32=\"JEBEL ALI\"),\"8.75\",IF(AND(F32=\"AL FUTTAIM\",E32=\"MAFRAQ\"),\"16\",IF(AND(F32=\"AL FUTTAIM\",E32=\"AL QUOZ\"),\"7.70\",IF(AND(F32=\"AL FUTTAIM\",E32=\"MUSSAFAH\"),\"16.90\",IF(AND(F32=\"AL FUTTAIM\",E32=\"NAD AL SHEBA\"),\"8.50\",IF(AND(F32=\"AL FUTTAIM\",E32=\"MAHAWI\"),\"16.90\",IF(AND(F32=\"AL RAWDA\",E32=\"MADAM\"),\"24.50\",)))))))))))))))))*1)","v":16.899999999999999},{"$f":"IF(B32=\"\",\"\",I32*H32)","v":1314.82},"BEGIN OF SHEET: 47895"]
[2,"2019-03-02",47895,141426,"MAFRAQ","AL FUTTAIM","Road base",76.78,16,1228.48]
[3,"2019-03-02",47895,141380,"AL QUOZ","AL FUTTAIM","Road base",76.239999999999995,7.7,587.048]
[4,"2019-03-03",47895,141532,"MAFRAQ","AL FUTTAIM","Road base",77,16,1232]
[5,"2019-03-03",47895,141470,"AL QUOZ","AL FUTTAIM","Road base",75,7.7,577.5]
[6,"2019-03-04",47895,141647,"MAFRAQ","AL FUTTAIM","Road base",76.84,16,1229.44]
[7,"2019-03-04",47895,141596,"JEBEL ALI","AL FUTTAIM","Road base",76.84,8.75,672.35]
[8,"2019-03-05",47895,141816,"MUSSAFAH","AL FUTTAIM","Road base",77.819999999999993,16.899999999999999,1315.1579999999997]
[9,"2019-03-05",47895,141688,"AL QUOZ","AL FUTTAIM","Road base",74.16,7.7,571.03200000000004]
[10,"2019-03-06",47895,141782,"AL QUOZ","AL FUTTAIM","Road base",76.38,7.7,588.12599999999998]
[11,"2019-03-06",47895,141832,"MAFRAQ","AL FUTTAIM","Road base",75.36,16,1205.76]
[12,"2019-03-07",47895,141897,"AL QUOZ","AL FUTTAIM","Road base",76.260000000000005,7.7,587.202]
[13,"2019-03-08",47895,2214588,"Cement Factory","AL RAWASI","Road base",82.28,16.649999999999999,1369.962]
[14,"2019-03-08",47895,141995,"MUSSAFAH","AL FUTTAIM","Road base",79.819999999999993,16.899999999999999,1348.9579999999999]
[15,"2019-03-08",47895,141953,"MAFRAQ","AL FUTTAIM","Road base",78.72,16,1259.52]
[16,"2019-03-09",47895,142073,"AL QUOZ","AL FUTTAIM","Road base",76.099999999999994,7.7,585.96999999999991]
[17,"2019-03-10",47895,142116,"MUSSAFAH","AL FUTTAIM","Road base",77.400000000000006,16.899999999999999,1308.06,"END OF SHEET: 47895"]
[null,14,null,null,null,null,null,1617.7799999999997,219.2,16981.385999999999,"SUM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"الفواصل غير ضرورية "]