{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["17","Chef","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"17","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[9,15,15,18]]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,255)","v":"17"},{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY()),A1)","v":"2020-07-17"},{"$f":"TEXT(B1,\"ddd\")","v":"Fri"},null,{"$f":"SUBTOTAL(9,E3:E30000)","v":16200},{"$f":"SUBTOTAL(9,F3:F30000)","v":0},2100,75,0,0,30,200,0,150]
["Chef","Type","Qty","Column1","بندق","بندق صحيح","عين جمل","عين جمل صحيح","لوز","لوز صحيح","فسدق","فسدق صحيح","لوز شرائح","بيكان"]
[1,"سينامون رول",150,null,{"$f":"IF($C3=\"\",\"\",INDEX(Data!D2:D9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":1050},{"$f":"IF($C3=\"\",\"\",INDEX(Data!E2:E9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!F2:F9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":2100},{"$f":"IF($C3=\"\",\"\",INDEX(Data!G2:G9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":75},{"$f":"IF($C3=\"\",\"\",INDEX(Data!H2:H9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!I2:I9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!J2:J9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!K2:K9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!L2:L9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0},{"$f":"IF($C3=\"\",\"\",INDEX(Data!M2:M9,MATCH($B$3,Data!$B$2:$B$9,0))*$C3)","v":0}]
[1,"دوناتس",30,null,{"$f":"IF($C4=\"\",\"\",INDEX(Data!D3:D10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":150},{"$f":"IF($C4=\"\",\"\",INDEX(Data!E3:E10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!F3:F10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!G3:G10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!H3:H10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!I3:I10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!J3:J10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!K3:K10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!L3:L10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0},{"$f":"IF($C4=\"\",\"\",INDEX(Data!M3:M10,MATCH($B$3,Data!$B$2:$B$9,0))*$C4)","v":0}]
[2,"تارت سينامون",1,null,{"$f":"IF($C5=\"\",\"\",INDEX(Data!D4:D11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!E4:E11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!F4:F11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!G4:G11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!H4:H11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!I4:I11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!J4:J11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":30},{"$f":"IF($C5=\"\",\"\",INDEX(Data!K4:K11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!L4:L11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0},{"$f":"IF($C5=\"\",\"\",INDEX(Data!M4:M11,MATCH($B$3,Data!$B$2:$B$9,0))*$C5)","v":0}]
[4,"برالينا",30,null,{"$f":"IF($C6=\"\",\"\",INDEX(Data!D5:D12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":15000},{"$f":"IF($C6=\"\",\"\",INDEX(Data!E5:E12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!F5:F12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!G5:G12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!H5:H12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!I5:I12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!J5:J12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!K5:K12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!L5:L12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0},{"$f":"IF($C6=\"\",\"\",INDEX(Data!M5:M12,MATCH($B$3,Data!$B$2:$B$9,0))*$C6)","v":0}]
[6,"كيك",50,null,{"$f":"IF($C7=\"\",\"\",INDEX(Data!D6:D13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!E6:E13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!F6:F13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!G6:G13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!H6:H13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!I6:I13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!J6:J13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!K6:K13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":200},{"$f":"IF($C7=\"\",\"\",INDEX(Data!L6:L13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":0},{"$f":"IF($C7=\"\",\"\",INDEX(Data!M6:M13,MATCH($B$3,Data!$B$2:$B$9,0))*$C7)","v":150}]
[2,"برالينا",null,null,{"$f":"IF($C8=\"\",\"\",INDEX(Data!D7:D14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!E7:E14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!F7:F14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!G7:G14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!H7:H14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!I7:I14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!J7:J14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!K7:K14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!L7:L14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""},{"$f":"IF($C8=\"\",\"\",INDEX(Data!M7:M14,MATCH($B$3,Data!$B$2:$B$9,0))*$C8)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"الفلترة تكون من Chef اريد اخفاء العواميد من E3:N1000 او اكثر اذا كان العمود لا يحتوى على قيم بعد الفلترة مثال: لو انا فلترت على رقم 1 حيكون فيه عواميد مكسرات فارغة اريد اخفائها بماكرو حتى اطبع على طول بدون العمل على لك يدويا"]

{"sheet":"Chef","index":1,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Chef"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Data","index":2,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Chef","Type",null,"بندق","بندق صحيح","عين جمل","عين جمل صحيح","لوز","لوز صحيح","فسدق","فسدق صحيح","لوز شرائح","بيكان"]
[1,"سينامون رول",null,7,null,14,0.5]
[2,"دوناتس",null,5]
[4,"تارت سينامون",null,null,null,null,null,null,null,30]
[5,"برالينا",null,500]
[6,"كيك",null,null,null,null,null,null,null,null,4,null,3]