{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["A4 ","ورقة1","المفرد"],"not_rendered":{"charts":0,"images":4,"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":"A4 ","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["     "," ","محلات الخفاجي 07814539337  ابي غرق "]
[null,null,null,null,"التاريخ ",{"$f":"TODAY()","v":"2020-02-12"}]
["ت ","المادة ","الحجم","الكمية ","سعر المفرد ","المجموع ","الملاحظات "]
[1,null,{"$f":"IF(AND(B4=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B4,المفرد!A:A,0)))","v":""},3,{"$f":"IF(AND(B4=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B4,المفرد!A:A,0)))","v":""},{"$f":"IF(OR(D4=\"\",E4=\"\"),\"\",D4*E4)","v":""}]
[2,null,{"$f":"IF(AND(B5=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B5,المفرد!A:A,0)))","v":""},2,{"$f":"IF(AND(B5=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B5,المفرد!A:A,0)))","v":""},""]
[3,null,{"$f":"IF(AND(B6=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B6,المفرد!A:A,0)))","v":""},2,{"$f":"IF(AND(B6=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B6,المفرد!A:A,0)))","v":""},""]
[4,null,{"$f":"IF(AND(B7=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B7,المفرد!A:A,0)))","v":""},5,{"$f":"IF(AND(B7=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B7,المفرد!A:A,0)))","v":""},""]
[5,null,{"$f":"IF(AND(B8=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B8,المفرد!A:A,0)))","v":""},5,{"$f":"IF(AND(B8=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B8,المفرد!A:A,0)))","v":""},""]
[6,null,{"$f":"IF(AND(B9=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B9,المفرد!A:A,0)))","v":""},2,{"$f":"IF(AND(B9=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B9,المفرد!A:A,0)))","v":""},""]
[7,"علي 1",{"$f":"IF(AND(B10=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B10,المفرد!A:A,0)))","v":"متر "},3,{"$f":"IF(AND(B10=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B10,المفرد!A:A,0)))","v":100},300]
[8,"علي 1",{"$f":"IF(AND(B11=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B11,المفرد!A:A,0)))","v":"متر "},2,{"$f":"IF(AND(B11=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B11,المفرد!A:A,0)))","v":100},200]
[9,null,{"$f":"IF(AND(B12=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B12,المفرد!A:A,0)))","v":""},2,{"$f":"IF(AND(B12=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B12,المفرد!A:A,0)))","v":""},""]
[10,null,{"$f":"IF(AND(B13=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B13,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B13=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B13,المفرد!A:A,0)))","v":""},""]
[11,null,{"$f":"IF(AND(B14=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B14,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B14=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B14,المفرد!A:A,0)))","v":""},""]
[12,null,{"$f":"IF(AND(B15=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B15,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B15=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B15,المفرد!A:A,0)))","v":""},""]
[13,null,{"$f":"IF(AND(B16=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B16,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B16=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B16,المفرد!A:A,0)))","v":""},""]
[14,null,{"$f":"IF(AND(B17=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B17,المفرد!A:A,0)))","v":""},6,{"$f":"IF(AND(B17=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B17,المفرد!A:A,0)))","v":""},{"$f":"IF(OR(D17=\"\",E17=\"\"),\"\",D17*E17)","v":""}]
[15,null,{"$f":"IF(AND(B18=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B18,المفرد!A:A,0)))","v":""},3,{"$f":"IF(AND(B18=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B18,المفرد!A:A,0)))","v":""},""]
[16,null,{"$f":"IF(AND(B19=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B19,المفرد!A:A,0)))","v":""},8,{"$f":"IF(AND(B19=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B19,المفرد!A:A,0)))","v":""},""]
[17,null,{"$f":"IF(AND(B20=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B20,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B20=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B20,المفرد!A:A,0)))","v":""},""]
[18,null,{"$f":"IF(AND(B21=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B21,المفرد!A:A,0)))","v":""},6,{"$f":"IF(AND(B21=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B21,المفرد!A:A,0)))","v":""},{"$f":"IF(OR(D21=\"\",E21=\"\"),\"\",D21*E21)","v":""}]
[19,null,{"$f":"IF(AND(B22=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B22,المفرد!A:A,0)))","v":""},3,{"$f":"IF(AND(B22=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B22,المفرد!A:A,0)))","v":""},""]
[20,null,{"$f":"IF(AND(B23=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B23,المفرد!A:A,0)))","v":""},6,{"$f":"IF(AND(B23=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B23,المفرد!A:A,0)))","v":""},""]
[21,null,{"$f":"IF(AND(B24=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B24,المفرد!A:A,0)))","v":""},3,{"$f":"IF(AND(B24=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B24,المفرد!A:A,0)))","v":""},""]
[22,null,{"$f":"IF(AND(B25=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B25,المفرد!A:A,0)))","v":""},8,{"$f":"IF(AND(B25=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B25,المفرد!A:A,0)))","v":""},""]
[23,null,{"$f":"IF(AND(B26=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B26,المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B26=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B26,المفرد!A:A,0)))","v":""},""]
[24,null,{"$f":"IF(AND(B27=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B27,المفرد!A:A,0)))","v":""},6,{"$f":"IF(AND(B27=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B27,المفرد!A:A,0)))","v":""},{"$f":"IF(OR(D27=\"\",E27=\"\"),\"\",D27*E27)","v":""}]
[25,null,{"$f":"IF(AND(B28=\"\"),\"\",INDEX(المفرد!C:C,MATCH('A4 '!B28,المفرد!A:A,0)))","v":""},3,{"$f":"IF(AND(B28=\"\"),\"\",INDEX(المفرد!B:B,MATCH('A4 '!B28,المفرد!A:A,0)))","v":""},""]
[null,"المجموع ",null,null,null,{"$f":"SUM(F4:F16)","v":500},{"$f":"Cur(F29,\"دينار \",\"فلس \")","v":"فقط خمسمائة دينار "}]
[null,"الواصل ",null,null,465000,null,{"$f":"IF(AND(E30=\"\"),\"\",Cur(E30,\"دينار \",\"فلس \"))","v":"فقط أربعمائة وخمسة وستون ألف دينار "}]
[null,"الخصم ",null,null,600,null,{"$f":"IF(AND(E31=\"\"),\"\",Cur(E31,\"دينار \",\"فلس \"))","v":"فقط ستمائة دينار "}]
[null,"الباقي ",null,null,null,{"$f":"F29-E30-E31","v":-465100},{"$f":"Cur(F32,\"دينار \",\"فلس \")","v":"يتبقى لكم أربعمائة وخمسة وستون ألف ومائة دينار "}]
["الغلط والسهو مرجوع للطرفين ...................."]

{"sheet":"ورقة1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"المفرد","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["المادة ","العدد","الحجم ",{"$f":"TODAY()","v":"2020-02-12"}]
["علي 1",100,"متر "]
["علي 2",200,"متر "]
["علي 3",300,"متر "]
["علي 4",400,"متر "]
["علي 5",500,"متر "]
["علي 6",600,"متر "]
["علي 7",700,"متر "]
["علي 8",800,"متر "]
["علي 9",900,"متر "]
["علي 10",1000,"متر "]
["علي 11",1100,"متر "]
["علي 12",1200,"متر "]
["علي 13",1300,"متر "]
["علي 14",1400,"متر "]
["علي 15",1500,"متر "]
["علي 16",1600,"متر "]
["علي 17",1700,"متر "]
["علي 18",1800,"متر "]
["علي 19",1900,"متر "]