{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["check","product"],"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":"check","index":0,"n_rows":22,"n_cols":26,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COLUMN()","v":1},{"$f":"COLUMN()","v":2},{"$f":"COLUMN()","v":3},{"$f":"COLUMN()","v":4},{"$f":"COLUMN()","v":5},{"$f":"COLUMN()","v":6},{"$f":"COLUMN()","v":7},{"$f":"COLUMN()","v":8},{"$f":"COLUMN()","v":9},{"$f":"COLUMN()","v":10},{"$f":"COLUMN()","v":11},{"$f":"COLUMN()","v":12},{"$f":"COLUMN()","v":13},{"$f":"COLUMN()","v":14},{"$f":"COLUMN()","v":15},{"$f":"COLUMN()","v":16},{"$f":"COLUMN()","v":17},{"$f":"COLUMN()","v":18},{"$f":"COLUMN()","v":19},{"$f":"COLUMN()","v":20},{"$f":"COLUMN()","v":21}]
[]
[null,null,null,null,null,null,{"$f":"SUM(G6:G10001)","v":355},{"$f":"SUM(H6:H10001)","v":102},null,null,{"$f":"SUM(K6:K10001)","v":7604},null,null,{"$f":"SUM(N6:N10001)","v":17}]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G6:G10001)","v":355},{"$f":"SUBTOTAL(9,H6:H10001)","v":102},null,null,{"$f":"SUBTOTAL(9,K6:K10001)","v":7604},null,null,{"$f":"SUBTOTAL(9,N6:N10001)","v":17}]
["التاريخ","المصنع","رقم الخط","المشرف","اسم المنتج","الماركة","عدد العمال","عدد ساعات العمل","نسبة الهدف","المستهدف","المحقق","نسبة التحقيق","معدل الفرد","الوقت المهدر","سبب  الفقد","ملاحظات","تكلفه الساعه","تكلفه القطعه","اجمالى التكلفه","month","day","الحالة ",null,null,null,"all"]
["2021-10-05","اكاي",1,"بنداري","مروحة استاند عادة 18\"","دريم",20,6,5,{"$f":"G6*H6*I6","v":600},600,{"$f":"K6/J6","v":1},{"$f":"K6/G6/H6","v":5},1,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A6),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A6))+SUMIFS(N:N,T:T,MONTH(A6)))","v":15.126050420168067},{"$f":"Q6/M6","v":3.0252100840336134},{"$f":"R6*K6","v":1815.126050420168},{"$f":"MONTH(A6)","v":10},{"$f":"DAY(A6)","v":5},null,null,null,null,{"$f":"T6&B6&E6&F6","v":"10اكايمروحة استاند عادة 18\"دريم"}]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",20,5,6,600,600,1,6,2,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A7),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A7))+SUMIFS(N:N,T:T,MONTH(A7)))","v":15.126050420168067},2.5210084033613445,1512.6050420168067,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",20,7,7,980,150,0.15306122448979592,1.0714285714285714,0,null,null,{"$f":"VLOOKUP(MONTH(A8),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A8))+SUMIFS(N:N,T:T,MONTH(A8)))","v":15.126050420168067},14.117647058823529,2117.6470588235293,10,5]
["2021-10-05","اكاي",1,"بنداري","مروحة استاند عادة 18\"","دريم",20,6,5,600,501,0.83499999999999996,4.1749999999999998,1,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A9),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A9))+SUMIFS(N:N,T:T,MONTH(A9)))","v":15.126050420168067},3.62300608866301,1815.126050420168,10,5]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",21,5,6,630,700,1.1111111111111112,6.666666666666667,2,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A10),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A10))+SUMIFS(N:N,T:T,MONTH(A10)))","v":15.126050420168067},2.26890756302521,1588.2352941176471,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",22,7,7,1078,150,0.1391465677179963,0.97402597402597402,0,null,null,{"$f":"VLOOKUP(MONTH(A11),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A11))+SUMIFS(N:N,T:T,MONTH(A11)))","v":15.126050420168067},15.529411764705882,2329.4117647058824,10,5]
["2021-10-05","اكاي",1,"بنداري","مروحة استاند عادة 18\"","دريم",20,6,5,600,501,0.83499999999999996,4.1749999999999998,1,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A12),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A12))+SUMIFS(N:N,T:T,MONTH(A12)))","v":15.126050420168067},3.62300608866301,1815.126050420168,10,5]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",21,5,6,630,700,1.1111111111111112,6.666666666666667,2,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A13),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A13))+SUMIFS(N:N,T:T,MONTH(A13)))","v":15.126050420168067},2.26890756302521,1588.2352941176471,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",22,7,7,1078,150,0.1391465677179963,0.97402597402597402,0,null,null,{"$f":"VLOOKUP(MONTH(A14),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A14))+SUMIFS(N:N,T:T,MONTH(A14)))","v":15.126050420168067},15.529411764705882,2329.4117647058824,10,5]
["2021-10-05","اكاي",1,"بنداري","مروحة استاند عادة 18\"","دريم",20,6,5,600,501,0.83499999999999996,4.1749999999999998,1,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A15),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A15))+SUMIFS(N:N,T:T,MONTH(A15)))","v":15.126050420168067},3.62300608866301,1815.126050420168,10,5]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",21,5,6,630,700,1.1111111111111112,6.666666666666667,2,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A16),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A16))+SUMIFS(N:N,T:T,MONTH(A16)))","v":15.126050420168067},2.26890756302521,1588.2352941176471,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",22,7,7,1078,150,0.1391465677179963,0.97402597402597402,0,null,null,{"$f":"VLOOKUP(MONTH(A17),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A17))+SUMIFS(N:N,T:T,MONTH(A17)))","v":15.126050420168067},15.529411764705882,2329.4117647058824,10,5]
["2021-10-05","اكاي",1,"بنداري","مروحة استاند عادة 18\"","دريم",20,6,5,600,501,0.83499999999999996,4.1749999999999998,1,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A18),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A18))+SUMIFS(N:N,T:T,MONTH(A18)))","v":15.126050420168067},3.62300608866301,1815.126050420168,10,5]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",21,5,6,630,700,1.1111111111111112,6.666666666666667,2,"تغيير منتج",null,{"$f":"VLOOKUP(MONTH(A19),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A19))+SUMIFS(N:N,T:T,MONTH(A19)))","v":15.126050420168067},2.26890756302521,1588.2352941176471,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",22,7,7,1078,150,0.1391465677179963,0.97402597402597402,0,null,null,{"$f":"VLOOKUP(MONTH(A20),[1]مالي!A:D,4,FALSE)/(SUMIFS(H:H,T:T,MONTH(A20))+SUMIFS(N:N,T:T,MONTH(A20)))","v":15.126050420168067},15.529411764705882,2329.4117647058824,10,5]
["2021-10-05","اكاي",2,"محمود","مروحة حائط عادة 18\"","دريم",21,5,6,630,700,1.1111111111111112,6.666666666666667,2,"تغيير منتج",null,17.142857142857142,2.5714285714285712,1799.9999999999998,10,5]
["2021-10-05","اكاي",3,"محمود","مبرد","دريم",22,7,7,1078,150,0.1391465677179963,0.97402597402597402,0,null,null,17.142857142857142,17.599999999999998,2639.9999999999995,10,5]

{"sheet":"product","index":1,"n_rows":7,"n_cols":38,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,{"$f":"COLUMN()","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COLUMN()","v":37}]
[]
[null,null,null,null,null,{"$f":"SUM(G3:AK3)","v":0}]
["الشهر","الشركة","كود المنتج","اسم المنتج","الماركة","الإنتاج ",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"all"]
["10","اكاي",null,"مروحة استاند عادة 18\"","دريم"]
["10","اكاي",null,"مروحة حائط عادة 18\"","دريم"]
["10","اكاي",null,"مبرد","دريم"]