{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["المقدمة","الهدف الاستراتيجى","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","Sheet5","التقرير العام"],"not_rendered":{"charts":22,"images":1,"macros":1,"external_links":0,"defined_names":21,"comments":20,"pivot_tables":1},"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"الخبرات العلمية والعملية\n•\tخبير ومدرب EXCEL مالي ومحاسبي \n•\tحاصل على بكالوريوس التجارة ودبلوم الدارسات العليا في المحاسبة والمراجعة جامعة القاهرة .\n•\tعملت في المجال المالى والمحاسبى الى ان وصلت الى CFO  \n•\tخبير اكسيل معترف به في مجتمع مايكروسوفت اكسيل وحصلت على العديد من الجوائز منها MCC(Content Creator) \n•\tحاصل على شهادة خبير اكسيل  MOS expert excel 2010\n•\tخبير  اكسيل معتمد في العديد من المنتديات العربية والأجنبي \n•\tمؤسس مدونة خبير اكسيل وصفحة وجروب خبير اكسيل على الفيس بوك \n•\tحاصل على  تدريب مدربين   British Accreditation Board  &TOT \n•\tقدمت مواضيع للماليين  مثل تحليل الحساسية بالاكسيل وتحليل التنبؤات بالاكسيل وتحليل التعادل ....الخ وموضوعات اخرى تهم المحاسبين والمدراء الماليين .\n•\tقدمت دورات في العديد من الشركات والاقسام والمستويات الإدارية المختلفة داخل الشركات. \n•\tقدمت العديد من النماذج المالية للشركات.\nوما توفيقي الا بالله"]

{"sheet":"الهدف الاستراتيجى","index":1,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[0,0,0,3]]}
["تحليل مؤشرات الاداء KPI"]
["اسم الشركة","شركة خبير اكسيل محمد الريفى "]
["فترة التطبيق","2018-01-01","الى ",{"$f":"EOMONTH(B3-1,1)","v":"2018-01-31"}]
["نطاق التطبيق","العاملين فى خدمة العملاء والمبيعات (مديرى مبيعات الفروع)"]
["الهدف الاستراتيجى","زيادة المبيعات لتغطية الزيادة فى المصروفات التى حدثت فى الفترة الاخيره"]
["الغرض الاستراتيجى","اتخاذ القرار السليم فى وقتة "]
["المؤشرات","المؤشر الاول","المؤشر الثانى","المؤشر الثالث"]
["النسبة",0.9,0.75,0.5]
["شكل المؤشر","الافضل","الاكثر حدوثا","الاسوء"]
["رد الفعل","منح حوافز عالية","التشجيع للوصول للهدف","البحث عن السبب والمعالجه"]
[null,null,null,"KPI Module Powered By Mohamed Elrify"]
[]
["للتواصل"]
["خبير اكسيل ",null,null,"https://www.facebook.com/xlxpert/"]
["اكاديمية خبير اكسيل",null,null,"https://www.facebook.com/excelexpertacademy/"]
["جروب خبير اكسيل ",null,null,"https://www.facebook.com/groups/GROUP.xlxpert/"]
["الصفحة الشخصية",null,null,"https://www.facebook.com/mohamed.elrify2"]
["لينكدان",null,null,"https://www.linkedin.com/in/mohamed-elrify/"]
["البريد الالكترونى",null,null,"xl.financial@gmail.com"]
["التليفون",null,null,"0201026059594"]

{"sheet":"1","index":2,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,4,1,6],[1,7,1,8],[5,1,5,8],[40,1,40,3],[40,4,40,6],[2,2,2,3],[3,2,3,3],[4,2,4,3],[1,1,1,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","محمد الريفى",null,"التارجيت الشهرى المطلوب",null,100,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":197}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":0.78800000000000003}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"التشجيع للوصول للهدف"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},100,50,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":50},{"$f":"IFERROR(E8/D8,\"\")","v":0.5}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'1'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},150,147,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":3},{"$f":"IFERROR(E9/D9,\"\")","v":0.98}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'1'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'1'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'1'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'1'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'1'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'1'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'1'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'1'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'1'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'1'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'1'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'1'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'1'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'1'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'1'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'1'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'1'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'1'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'1'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'1'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'1'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'1'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'1'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'1'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'1'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'1'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'1'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'1'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'1'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":250},{"$f":"SUM(E8:E38)","v":197},{"$f":"Table1[[#This Row],[التارجيت]]-Table1[[#This Row],[المحقق]]","v":53},{"$f":"IFERROR(E39/D39,\"\")","v":0.78800000000000003}]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":125},{"$f":"AVERAGE(E8:E38)","v":98.5},null,{"$f":"AVERAGE(G8:G38)","v":0.74}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":150},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"û"}]

{"sheet":"2","index":3,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","على",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'2'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'2'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'2'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'2'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'2'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'2'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'2'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'2'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'2'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'2'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'2'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'2'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'2'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'2'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'2'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'2'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'2'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'2'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'2'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'2'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'2'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'2'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'2'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'2'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'2'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'2'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'2'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'2'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'2'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'2'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table13[[#This Row],[التارجيت]]-Table13[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"3","index":4,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","ابراهيم",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'3'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'3'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'3'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'3'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'3'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'3'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'3'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'3'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'3'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'3'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'3'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'3'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'3'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'3'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'3'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'3'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'3'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'3'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'3'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'3'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'3'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'3'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'3'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'3'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'3'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'3'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'3'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'3'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'3'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'3'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14[[#This Row],[التارجيت]]-Table14[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"4","index":5,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","حسن",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'4'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'4'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'4'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'4'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'4'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'4'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'4'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'4'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'4'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'4'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'4'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'4'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'4'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'4'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'4'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'4'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'4'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'4'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'4'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'4'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'4'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'4'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'4'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'4'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'4'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'4'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'4'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'4'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'4'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'4'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145[[#This Row],[التارجيت]]-Table145[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"5","index":6,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","خليل",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'5'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'5'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'5'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'5'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'5'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'5'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'5'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'5'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'5'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'5'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'5'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'5'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'5'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'5'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'5'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'5'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'5'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'5'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'5'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'5'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'5'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'5'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'5'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'5'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'5'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'5'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'5'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'5'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'5'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'5'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table1456[[#This Row],[التارجيت]]-Table1456[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"6","index":7,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'6'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'6'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'6'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'6'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'6'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'6'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'6'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'6'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'6'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'6'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'6'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'6'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'6'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'6'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'6'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'6'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'6'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'6'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'6'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'6'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'6'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'6'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'6'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'6'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'6'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'6'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'6'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'6'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'6'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'6'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table18[[#This Row],[التارجيت]]-Table18[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"7","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'7'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'7'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'7'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'7'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'7'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'7'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'7'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'7'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'7'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'7'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'7'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'7'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'7'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'7'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'7'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'7'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'7'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'7'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'7'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'7'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'7'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'7'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'7'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'7'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'7'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'7'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'7'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'7'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'7'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'7'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14567[[#This Row],[التارجيت]]-Table14567[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"8","index":9,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'8'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'8'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'8'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'8'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'8'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'8'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'8'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'8'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'8'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'8'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'8'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'8'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'8'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'8'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'8'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'8'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'8'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'8'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'8'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'8'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'8'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'8'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'8'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'8'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'8'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'8'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'8'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'8'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'8'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'8'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145679[[#This Row],[التارجيت]]-Table145679[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"9","index":10,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'9'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'9'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'9'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'9'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'9'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'9'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'9'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'9'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'9'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'9'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'9'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'9'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'9'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'9'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'9'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'9'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'9'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'9'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'9'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'9'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'9'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'9'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'9'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'9'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'9'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'9'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'9'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'9'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'9'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'9'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14567910[[#This Row],[التارجيت]]-Table14567910[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"10","index":11,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","هلال",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'10'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'10'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'10'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'10'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'10'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'10'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'10'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'10'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'10'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'10'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'10'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'10'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'10'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'10'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'10'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'10'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'10'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'10'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'10'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'10'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'10'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'10'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'10'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'10'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'10'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'10'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'10'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'10'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'10'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'10'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145679101122[[#This Row],[التارجيت]]-Table145679101122[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"11","index":12,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","هلال",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'11'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'11'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'11'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'11'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'11'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'11'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'11'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'11'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'11'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'11'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'11'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'11'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'11'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'11'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'11'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'11'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'11'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'11'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'11'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'11'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'11'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'11'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'11'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'11'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'11'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'11'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'11'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'11'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'11'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'11'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table1456791011[[#This Row],[التارجيت]]-Table1456791011[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"12","index":13,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'12'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'12'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'12'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'12'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'12'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'12'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'12'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'12'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'12'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'12'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'12'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'12'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'12'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'12'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'12'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'12'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'12'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'12'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'12'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'12'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'12'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'12'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'12'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'12'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'12'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'12'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'12'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'12'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'12'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'12'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145679101112[[#This Row],[التارجيت]]-Table145679101112[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"13","index":14,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'13'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'13'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'13'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'13'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'13'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'13'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'13'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'13'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'13'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'13'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'13'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'13'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'13'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'13'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'13'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'13'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'13'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'13'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'13'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'13'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'13'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'13'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'13'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'13'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'13'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'13'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'13'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'13'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'13'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'13'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14567910111213[[#This Row],[التارجيت]]-Table14567910111213[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"14","index":15,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'14'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'14'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'14'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'14'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'14'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'14'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'14'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'14'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'14'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'14'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'14'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'14'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'14'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'14'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'14'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'14'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'14'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'14'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'14'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'14'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'14'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'14'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'14'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'14'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'14'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'14'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'14'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'14'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'14'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'14'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table1456791011121314[[#This Row],[التارجيت]]-Table1456791011121314[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"15","index":16,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'15'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'15'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'15'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'15'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'15'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'15'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'15'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'15'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'15'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'15'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'15'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'15'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'15'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'15'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'15'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'15'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'15'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'15'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'15'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'15'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'15'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'15'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'15'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'15'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'15'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'15'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'15'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'15'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'15'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'15'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145679101112131415[[#This Row],[التارجيت]]-Table145679101112131415[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"16","index":17,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم","حسين",null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'16'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'16'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'16'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'16'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'16'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'16'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'16'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'16'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'16'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'16'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'16'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'16'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'16'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'16'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'16'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'16'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'16'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'16'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'16'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'16'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'16'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'16'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'16'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'16'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'16'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'16'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'16'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'16'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'16'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'16'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14567910111213141516[[#This Row],[التارجيت]]-Table14567910111213141516[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"17","index":18,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'17'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'17'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'17'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'17'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'17'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'17'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'17'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'17'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'17'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'17'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'17'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'17'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'17'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'17'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'17'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'17'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'17'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'17'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'17'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'17'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'17'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'17'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'17'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'17'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'17'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'17'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'17'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'17'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'17'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'17'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table1456791011121314151617[[#This Row],[التارجيت]]-Table1456791011121314151617[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"18","index":19,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'18'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'18'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'18'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'18'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'18'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'18'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'18'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'18'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'18'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'18'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'18'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'18'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'18'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'18'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'18'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'18'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'18'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'18'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'18'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'18'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'18'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'18'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'18'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'18'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'18'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'18'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'18'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'18'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'18'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'18'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table145679101112131415161718[[#This Row],[التارجيت]]-Table145679101112131415161718[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"19","index":20,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'19'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'19'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'19'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'19'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'19'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'19'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'19'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'19'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'19'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'19'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'19'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'19'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'19'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'19'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'19'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'19'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'19'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'19'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'19'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'19'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'19'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'19'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'19'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'19'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'19'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'19'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'19'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'19'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'19'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'19'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table14567910111213141516171819[[#This Row],[التارجيت]]-Table14567910111213141516171819[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"20","index":21,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,1,5,8],[40,1,40,3],[40,4,40,6],[1,1,1,3],[1,4,1,6],[1,7,1,8],[2,2,2,3],[3,2,3,3],[4,2,4,3]]}
[]
[null,"معلومات عن الموظف",null,null,"معلومات استراتيجية",null,null,"مؤشر الاداء"]
[null,"الاسم",null,null,"التارجيت الشهرى المطلوب",null,null,"اجمالى التارجيت المحقق",{"$f":"$E$39","v":0}]
[null,"الفرع",null,null,"متوسط مبيعات اخر 6 شهور",null,null,"النسبة المحققة",{"$f":"G39","v":""}]
[null,"القسم",null,null,"نسبة التطوير (الزيادة)",null,{"$f":"IFERROR(G3/G4-1,\"\")","v":""},"القرار الادارى",{"$f":"IF($I$4>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF($I$4>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF($I$4>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"منح حوافز عالية"}]
[]
[null,"التاريخ","اليوم","التارجيت","المحقق","الفرق","نسبة الهدف","الاجراء","ملاحظات"]
[null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"TEXT(B8,\"dddd\")","v":"الإثنين"},null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E8/D8,\"\")","v":""}]
[null,{"$f":"IF($B8<'الهدف الاستراتيجى'!$D$3,'20'!$B8+1,\"\")","v":"2018-01-02"},{"$f":"TEXT(B9,\"dddd\")","v":"الثلاثاء"},null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},{"$f":"IFERROR(E9/D9,\"\")","v":""}]
[null,{"$f":"IF($B9<'الهدف الاستراتيجى'!$D$3,'20'!$B9+1,\"\")","v":"2018-01-03"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B10<'الهدف الاستراتيجى'!$D$3,'20'!$B10+1,\"\")","v":"2018-01-04"},"الخميس",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B11<'الهدف الاستراتيجى'!$D$3,'20'!$B11+1,\"\")","v":"2018-01-05"},"الجمعة",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B12<'الهدف الاستراتيجى'!$D$3,'20'!$B12+1,\"\")","v":"2018-01-06"},"السبت",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B13<'الهدف الاستراتيجى'!$D$3,'20'!$B13+1,\"\")","v":"2018-01-07"},"الأحد",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B14<'الهدف الاستراتيجى'!$D$3,'20'!$B14+1,\"\")","v":"2018-01-08"},"الإثنين",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B15<'الهدف الاستراتيجى'!$D$3,'20'!$B15+1,\"\")","v":"2018-01-09"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B16<'الهدف الاستراتيجى'!$D$3,'20'!$B16+1,\"\")","v":"2018-01-10"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B17<'الهدف الاستراتيجى'!$D$3,'20'!$B17+1,\"\")","v":"2018-01-11"},"الخميس",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B18<'الهدف الاستراتيجى'!$D$3,'20'!$B18+1,\"\")","v":"2018-01-12"},"الجمعة",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B19<'الهدف الاستراتيجى'!$D$3,'20'!$B19+1,\"\")","v":"2018-01-13"},"السبت",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B20<'الهدف الاستراتيجى'!$D$3,'20'!$B20+1,\"\")","v":"2018-01-14"},"الأحد",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B21<'الهدف الاستراتيجى'!$D$3,'20'!$B21+1,\"\")","v":"2018-01-15"},"الإثنين",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B22<'الهدف الاستراتيجى'!$D$3,'20'!$B22+1,\"\")","v":"2018-01-16"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B23<'الهدف الاستراتيجى'!$D$3,'20'!$B23+1,\"\")","v":"2018-01-17"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B24<'الهدف الاستراتيجى'!$D$3,'20'!$B24+1,\"\")","v":"2018-01-18"},"الخميس",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B25<'الهدف الاستراتيجى'!$D$3,'20'!$B25+1,\"\")","v":"2018-01-19"},"الجمعة",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B26<'الهدف الاستراتيجى'!$D$3,'20'!$B26+1,\"\")","v":"2018-01-20"},"السبت",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B27<'الهدف الاستراتيجى'!$D$3,'20'!$B27+1,\"\")","v":"2018-01-21"},"الأحد",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B28<'الهدف الاستراتيجى'!$D$3,'20'!$B28+1,\"\")","v":"2018-01-22"},"الإثنين",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B29<'الهدف الاستراتيجى'!$D$3,'20'!$B29+1,\"\")","v":"2018-01-23"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B30<'الهدف الاستراتيجى'!$D$3,'20'!$B30+1,\"\")","v":"2018-01-24"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B31<'الهدف الاستراتيجى'!$D$3,'20'!$B31+1,\"\")","v":"2018-01-25"},"الخميس",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B32<'الهدف الاستراتيجى'!$D$3,'20'!$B32+1,\"\")","v":"2018-01-26"},"الجمعة",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B33<'الهدف الاستراتيجى'!$D$3,'20'!$B33+1,\"\")","v":"2018-01-27"},"السبت",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B34<'الهدف الاستراتيجى'!$D$3,'20'!$B34+1,\"\")","v":"2018-01-28"},"الأحد",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B35<'الهدف الاستراتيجى'!$D$3,'20'!$B35+1,\"\")","v":"2018-01-29"},"الإثنين",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B36<'الهدف الاستراتيجى'!$D$3,'20'!$B36+1,\"\")","v":"2018-01-30"},"الثلاثاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,{"$f":"IF($B37<'الهدف الاستراتيجى'!$D$3,'20'!$B37+1,\"\")","v":"2018-01-31"},"الأربعاء",null,null,{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,"المجموع ",null,{"$f":"SUM(D8:D38)","v":0},{"$f":"SUM(E8:E38)","v":0},{"$f":"Table1456791011121314151617181920[[#This Row],[التارجيت]]-Table1456791011121314151617181920[[#This Row],[المحقق]]","v":0},""]
[null,"المتوسط اليومى",null,{"$f":"AVERAGE(D8:D38)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E8:E38)","v":{"$error":"#DIV/0!"}},null,{"$f":"AVERAGE(G8:G38)","v":{"$error":"#DIV/0!"}}]
[null,"توزيع التارجيت بشكل صحيح",null,null,{"$f":"D39-G3","v":0},null,null,{"$f":"IF($E$41=0,CHAR(252),CHAR(251))","v":"ü"}]

{"sheet":"Sheet5","index":22,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["الاسم","Average of نسبة الهدف"]
["خليل",0.71666666666666667]
["ابراهيم",0.71666666666666667]
["على",0.71666666666666667]
["حسين",0.71666666666666667]
["حسن",0.71666666666666667]
["محمد الريفى",0.71666666666666667]
[0,0.71666666666666667]
["هلال",0.71666666666666667]
[null,{"$error":"#DIV/0!"}]

{"sheet":"التقرير العام","index":23,"n_rows":38,"n_cols":40,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,2,1,3],[2,2,4,3]]}
[]
["الشركة بالكامل",null,"وضع الشركة"]
["التارجيت",{"$f":"Table22[[#Totals],[التارجيت]]","v":12.5},{"$f":"IF(B5>='الهدف الاستراتيجى'!$B$8,'الهدف الاستراتيجى'!$B$10,IF(B5>='الهدف الاستراتيجى'!$C$8,'الهدف الاستراتيجى'!$C$10,IF(B5>='الهدف الاستراتيجى'!$D$8,'الهدف الاستراتيجى'!$D$10,\"\")))","v":"التشجيع للوصول للهدف"}]
["المحقق",{"$f":"Table22[[#Totals],[المحقق]]","v":9.85}]
["نسبة الهدف",{"$f":"Table22[[#Totals],[نسبة الهدف]]","v":0.78799999999999992}]
[]
["رقم الموظف","القسم","الفرع","الاسم","التارجيت","المحقق","نسبة الهدف",null,{"$f":"'الهدف الاستراتيجى'!$B$3","v":"2018-01-01"},{"$f":"IF(I$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!I$7+1,\"\")","v":"2018-01-02"},{"$f":"IF(J$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!J$7+1,\"\")","v":"2018-01-03"},{"$f":"IF(K$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!K$7+1,\"\")","v":"2018-01-04"},{"$f":"IF(L$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!L$7+1,\"\")","v":"2018-01-05"},{"$f":"IF(M$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!M$7+1,\"\")","v":"2018-01-06"},{"$f":"IF(N$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!N$7+1,\"\")","v":"2018-01-07"},{"$f":"IF(O$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!O$7+1,\"\")","v":"2018-01-08"},{"$f":"IF(P$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!P$7+1,\"\")","v":"2018-01-09"},{"$f":"IF(Q$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!Q$7+1,\"\")","v":"2018-01-10"},{"$f":"IF(R$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!R$7+1,\"\")","v":"2018-01-11"},{"$f":"IF(S$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!S$7+1,\"\")","v":"2018-01-12"},{"$f":"IF(T$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!T$7+1,\"\")","v":"2018-01-13"},{"$f":"IF(U$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!U$7+1,\"\")","v":"2018-01-14"},{"$f":"IF(V$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!V$7+1,\"\")","v":"2018-01-15"},{"$f":"IF(W$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!W$7+1,\"\")","v":"2018-01-16"},{"$f":"IF(X$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!X$7+1,\"\")","v":"2018-01-17"},{"$f":"IF(Y$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!Y$7+1,\"\")","v":"2018-01-18"},{"$f":"IF(Z$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!Z$7+1,\"\")","v":"2018-01-19"},{"$f":"IF(AA$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AA$7+1,\"\")","v":"2018-01-20"},{"$f":"IF(AB$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AB$7+1,\"\")","v":"2018-01-21"},{"$f":"IF(AC$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AC$7+1,\"\")","v":"2018-01-22"},{"$f":"IF(AD$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AD$7+1,\"\")","v":"2018-01-23"},{"$f":"IF(AE$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AE$7+1,\"\")","v":"2018-01-24"},{"$f":"IF(AF$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AF$7+1,\"\")","v":"2018-01-25"},{"$f":"IF(AG$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AG$7+1,\"\")","v":"2018-01-26"},{"$f":"IF(AH$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AH$7+1,\"\")","v":"2018-01-27"},{"$f":"IF(AI$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AI$7+1,\"\")","v":"2018-01-28"},{"$f":"IF(AJ$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AJ$7+1,\"\")","v":"2018-01-29"},{"$f":"IF(AK$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AK$7+1,\"\")","v":"2018-01-30"},{"$f":"IF(AL$7<'الهدف الاستراتيجى'!$D$3,'التقرير العام'!AL$7+1,\"\")","v":"2018-01-31"},"الاجمالى "]
[{"$f":"ROW($A1)","v":1},{"$f":"IFERROR(INDIRECT(A8&\"!C4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A8&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A8&\"!C3\"),\"\")","v":"محمد الريفى"},{"$f":"IFERROR(INDIRECT(A8&\"!D39\"),\"\")","v":250},{"$f":"IFERROR(INDIRECT(A8&\"!E39\"),\"\")","v":197},{"$f":"IFERROR(F8/E8,\"\")","v":0.78800000000000003},null,{"$f":"IFERROR(INDIRECT($A8&\"!\"&\"G\"&COLUMN(A$4)+7),\"\")","v":0.5},{"$f":"IFERROR(INDIRECT($A8&\"!\"&\"G\"&COLUMN(B$4)+7),\"\")","v":0.98},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,{"$f":"IFERROR(AVERAGE(I8:AM8),\"\")","v":0.74}]
[2,{"$f":"IFERROR(INDIRECT(A9&\"!C4\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A9&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A9&\"!C3\"),\"\")","v":"على"},{"$f":"IFERROR(INDIRECT(A9&\"!D39\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A9&\"!E39\"),\"\")","v":0},{"$f":"IFERROR(F9/E9,\"\")","v":""},null,{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(A$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(B$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(C$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(D$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(E$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(F$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(G$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(H$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(I$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(J$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(K$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(L$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(M$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(N$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(O$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(P$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(Q$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(R$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(S$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(T$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(U$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(V$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(W$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(X$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(Y$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(Z$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(AA$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(AB$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(AC$4)+7),\"\")","v":""},{"$f":"IFERROR(INDIRECT($A9&\"!\"&\"G\"&COLUMN(AD$4)+7),\"\")","v":""},null,{"$f":"IFERROR(AVERAGE(I9:AM9),\"\")","v":""}]
[3,0,0,"ابراهيم",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[4,0,0,"حسن",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[5,0,0,"خليل",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[6,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[7,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[8,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[9,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[10,0,0,"هلال",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[11,0,0,"هلال",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[12,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[13,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[14,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[15,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[16,0,0,"حسين",0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[17,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[18,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[19,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[20,0,0,0,0,0,"",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[21,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[22,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[23,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[24,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[25,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[26,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[27,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[28,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[29,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
[30,"","","","","","",null,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",null,""]
["Total",null,null,null,{"$f":"SUBTOTAL(101,Table22[التارجيت])","v":12.5},{"$f":"SUBTOTAL(101,Table22[المحقق])","v":9.85},{"$f":"Table22[[#Totals],[المحقق]]/Table22[[#Totals],[التارجيت]]","v":0.78799999999999992},null,{"$f":"IFERROR(AVERAGE(I8:I37),\"\")","v":0.5},{"$f":"IFERROR(AVERAGE(J8:J37),\"\")","v":0.98},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",0.74]