{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["البيانات","البودرة","تم الصرف","اسماء موظفي الدائرة"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"البيانات","index":0,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["ت","القسم","الشعبة","تاريخ الصرف","رقم الهوية","اسم الموظف","الراتب الاسمي","الحوافز/المخصصات","مبلغ الراتب الكلي","الحالة"]
[1,"الحسابات","الرواتب","2018-06-20",12,"حارث1",525,0,{"$f":"G2+H2","v":525},"تم صرف الراتب"]
[2,"المخازن","م1","2018-06-20",15,"حارث2",520,0,{"$f":"G3+H3","v":520}]
[3,"التصاميم","م1","2018-06-20",18,"حارث3",521,0,521]
[4,"الإدارة","م1","2018-06-20",22,"حارث4",530,0,530]
[5,"القانونية","م1","2018-06-20",24,"حارث5",600,0,600]
[6,"الصادرة","م1","2018-06-20",27,"حارث6",602,0,602]
[7,"الصيانة","م1","2018-06-20",30,"حارث7",500,0,500]
[8,"الاستعلامات","م1","2018-06-20",35,"حارث8",504,0,504]
[9,"التدقيق","م1","2018-06-20",36,"حارث9",506,0,506]
[10,"المباني","م1","2018-06-20",39,"حارث10",508,0,508]
[11,"الاقسام خارج المقر","م1","2018-06-20",40,"حارث11",510,0,510,"تم صرف الراتب"]
[12,"الاليات","م1","2018-06-20",45,"حارث12",512,10,522]

{"sheet":"البودرة","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["رقم الهوية","اسم الموظف",null,null,null,null,null,null,null,null,"يوجد زر استدعاء بيانات من شيت البيانات"]
[{"$f":"INDEX('اسماء موظفي الدائرة'!$A$2:$A$100,MATCH($B$2,'اسماء موظفي الدائرة'!$B$2:$B$100,0))","v":12},"حارث1",null,null,null,null,null,null,null,null,"وعند استدعاء البيانات اريد وضع إشارة في شيت البيانات بانه تم صرف الراتب"]
[null,null,null,null,null,null,null,null,null,null,"مع ترحيل بياناته الى شيت تم الصرف"]
["ت","القسم","الشعبة","تاريخ الصرف","رقم الهوية","اسم الموظف","الراتب الاسمي","الحوافز/المخصصات","مبلغ الراتب الكلي","الحالة"]
[11,"الاقسام خارج المقر","م1",43271,40,"حارث11",510,0,510]
[1,"الحسابات","الرواتب",43271,12,"حارث1",525,0,525]

{"sheet":"تم الصرف","index":2,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,{"$f":"SUM(G4:G749)","v":1035},null,{"$f":"SUM(I4:I749)","v":1035}]
["ت","القسم","الشعبة","تاريخ الصرف","رقم الهوية","اسم الموظف","الراتب الاسمي","الحوافز/المخصصات","مبلغ الراتب الكلي","الحالة"]
[11,"الاقسام خارج المقر","م1","2018-06-20",40,"حارث11",510,0,510,"تم صرف الراتب"]
[1,"الحسابات","الرواتب","2018-06-20",12,"حارث1",525,0,525,"تم صرف الراتب"]

{"sheet":"اسماء موظفي الدائرة","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["رقم الهوية","اسم الموظف"]
[12,"حارث1",null,null,{"$f":"$B$2:INDEX($B$2:$B$100,COUNTA($B$2:$B$100))","v":"حارث1"}]
[15,"حارث2"]
[18,"حارث3"]
[22,"حارث4"]
[24,"حارث5"]
[27,"حارث6"]
[30,"حارث7"]
[35,"حارث8"]
[36,"حارث9"]
[39,"حارث10"]
[40,"حارث11"]
[45,"حارث12"]