{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["وصل ","سعر"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["     "," ","محلات الخفاجي 07814539337  ابي غرق "]
[null,"الاسم ",null,null,"التاريخ ",{"$f":"TODAY()","v":"2019-11-11"}]
["ت ","المادة ","الحجم","الكمية ","سعر المفرد ","المجموع ","الملاحظات "]
[1,"حجر كوسرة ",{"$f":"IF(AND(B4=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B4,[1]المفرد!A:A,0)))","v":"عدد"},3,{"$f":"IF(AND(B4=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B4,سعر!A:A,0)))","v":30000},{"$f":"IF(OR(D4=\"\",E4=\"\"),\"\",D4*E4)","v":90000}]
[2,"مصابيح شحن ",{"$f":"IF(AND(B5=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B5,[1]المفرد!A:A,0)))","v":"باكيت "},3,{"$f":"IF(AND(B5=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B5,سعر!A:A,0)))","v":5000},{"$f":"IF(OR(D5=\"\",E5=\"\"),\"\",D5*E5)","v":15000}]
[3,"صبغ ",{"$f":"IF(AND(B6=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B6,[1]المفرد!A:A,0)))","v":"باكيت "},12,{"$f":"IF(AND(B6=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B6,سعر!A:A,0)))","v":5000},60000]
[4,"مصابيح عادية ",{"$f":"IF(AND(B7=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B7,[1]المفرد!A:A,0)))","v":"كغم "},2,{"$f":"IF(AND(B7=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B7,سعر!A:A,0)))","v":2000},4000]
[5,"صبغ ",{"$f":"IF(AND(B8=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B8,[1]المفرد!A:A,0)))","v":"عدد"},5,{"$f":"IF(AND(B8=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B8,سعر!A:A,0)))","v":5000},25000]
[6,"سبانة ",{"$f":"IF(AND(B9=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B9,[1]المفرد!A:A,0)))","v":"سيت "},5,{"$f":"IF(AND(B9=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B9,سعر!A:A,0)))","v":12000},60000]
[7,"تانكي ",{"$f":"IF(AND(B10=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B10,[1]المفرد!A:A,0)))","v":"عدد"},2,{"$f":"IF(AND(B10=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B10,سعر!A:A,0)))","v":50000},100000]
[8,"دريل همر ",{"$f":"IF(AND(B11=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B11,[1]المفرد!A:A,0)))","v":"عدد"},3,{"$f":"IF(AND(B11=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B11,سعر!A:A,0)))","v":100000},300000]
[9,"ريمونت ",{"$f":"IF(AND(B12=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B12,[1]المفرد!A:A,0)))","v":"عدد"},2,{"$f":"IF(AND(B12=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B12,سعر!A:A,0)))","v":1500},3000]
[10,"سبانة ",{"$f":"IF(AND(B13=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B13,[1]المفرد!A:A,0)))","v":"سيت "},3,{"$f":"IF(AND(B13=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B13,سعر!A:A,0)))","v":12000},36000]
[11,"تانكي ",{"$f":"IF(AND(B14=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B14,[1]المفرد!A:A,0)))","v":"عدد"},6,{"$f":"IF(AND(B14=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B14,سعر!A:A,0)))","v":50000},300000]
[12,"طباعة",{"$f":"IF(AND(B15=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B15,[1]المفرد!A:A,0)))","v":"عدد"},3,{"$f":"IF(AND(B15=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B15,سعر!A:A,0)))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[13,"نشار ",{"$f":"IF(AND(B16=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B16,[1]المفرد!A:A,0)))","v":"عدد"},8,{"$f":"IF(AND(B16=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B16,سعر!A:A,0)))","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[14,null,{"$f":"IF(AND(B17=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B17,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B17=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B17,سعر!A:A,0)))","v":""},""]
[15,null,{"$f":"IF(AND(B18=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B18,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B18=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B18,سعر!A:A,0)))","v":""},""]
[16,null,{"$f":"IF(AND(B19=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B19,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B19=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B19,سعر!A:A,0)))","v":""},""]
[17,null,{"$f":"IF(AND(B20=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B20,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B20=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B20,سعر!A:A,0)))","v":""},""]
[18,null,{"$f":"IF(AND(B21=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B21,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B21=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B21,سعر!A:A,0)))","v":""},""]
[19,null,{"$f":"IF(AND(B22=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B22,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B22=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B22,سعر!A:A,0)))","v":""},""]
[20,null,{"$f":"IF(AND(B23=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B23,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B23=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B23,سعر!A:A,0)))","v":""},""]
[21,null,{"$f":"IF(AND(B24=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B24,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B24=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B24,سعر!A:A,0)))","v":""},""]
[22,null,{"$f":"IF(AND(B25=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B25,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B25=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B25,سعر!A:A,0)))","v":""},""]
[23,null,{"$f":"IF(AND(B26=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B26,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B26=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B26,سعر!A:A,0)))","v":""},""]
[24,null,{"$f":"IF(AND(B27=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B27,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B27=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B27,سعر!A:A,0)))","v":""},""]
[25,null,{"$f":"IF(AND(B28=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B28,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B28=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B28,سعر!A:A,0)))","v":""},""]
[26,null,{"$f":"IF(AND(B29=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B29,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B29=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B29,سعر!A:A,0)))","v":""},""]
[27,null,{"$f":"IF(AND(B30=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B30,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B30=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B30,سعر!A:A,0)))","v":""},""]
[28,null,{"$f":"IF(AND(B31=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B31,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B31=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B31,سعر!A:A,0)))","v":""},""]
[29,null,{"$f":"IF(AND(B32=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B32,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B32=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B32,سعر!A:A,0)))","v":""},""]
[30,null,{"$f":"IF(AND(B33=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B33,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B33=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B33,سعر!A:A,0)))","v":""},""]
[42,null,{"$f":"IF(AND(B34=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B34,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B34=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B34,سعر!A:A,0)))","v":""}]
[43,null,{"$f":"IF(AND(B35=\"\"),\"\",INDEX([1]المفرد!C:C,MATCH([1]A4!B35,[1]المفرد!A:A,0)))","v":""},null,{"$f":"IF(AND(B35=\"\"),\"\",INDEX(سعر!B:B,MATCH('وصل '!B35,سعر!A:A,0)))","v":""},""]
[null,"المجموع ",null,null,null,{"$f":"SUM(F4:F35)","v":{"$error":"#N/A"}},{"$f":"NoToTxt(F36,\"دينار \",\"فلس \")","v":{"$error":"#VALUE!"}}]
[null,"الواصل ",null,null,30000,null,{"$f":"IF(AND(E37=\"\"),\"\",NoToTxt(E37,\"دينار \",\"فلس \"))","v":"فقط ثلاثون ألف دينار "}]
[null,"الباقي ",null,null,null,{"$f":"F36-E37","v":{"$error":"#N/A"}},{"$f":"NoToTxt(F38,\"دينار \",\"فلس \")","v":{"$error":"#VALUE!"}}]
["الغلط والسهو مرجوع للطرفين ...................."]

{"sheet":"سعر","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["المادة ","سعر المفرد ","الحجم ",{"$f":"TODAY()","v":"2019-11-11"}]
["حجر كوسرة ",30000,"عدد"]
["مصابيح شحن ",5000,"باكيت "]
["مصابيح عادية ",2000,"باكيت "]
["بسامير ",3000,"كغم "]
["تانكي ",50000,"عدد"]
["حجر قطع ",1500,"عدد"]
["سبانة ",12000,"سيت "]
["صبغ ",5000,"عدد"]
["دريل همر ",100000,"عدد"]
["ريمونت ",1500,"عدد"]
["طابعة ",20000,"عدد"]
["منشار ",200,"عدد"]
["جداحة ",9000,"باكيت "]
["واير كهرباء سيمنز ",1000,"متر "]