{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pivot Table","البيانات","فرز وجمع"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Pivot Table","index":0,"n_rows":63,"n_cols":4,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of المبلغ"]
["الشعبة","اسم الموظف","رقم الهوية","Total"]
["الانتاج","قيصر188",387,100000]
[null,"قيصر254",453,150000]
[null,"قيصر283",482,150000]
[null,"قيصر297",496,150000]
[null,"قيصر342",541,150000]
[null,"قيصر422",621,150000]
[null,"قيصر423",622,150000]
[null,"قيصر441",640,150000]
[null,"قيصر444",643,150000]
[null,"قيصر482",681,150000]
["الانتاج Total",null,null,1450000]
["التدقيق","قيصر13",212,100000]
[null,"قيصر150",349,100000]
[null,"قيصر296",495,100000]
[null,"قيصر371",570,100000]
[null,"قيصر432",631,100000]
[null,"قيصر439",638,100000]
[null,"قيصر470",669,100000]
[null,"قيصر54",253,100000]
["التدقيق Total",null,null,800000]
["الحسابات","قيصر12",211,175000]
[null,"قيصر128",327,175000]
[null,"قيصر173",372,175000]
[null,"قيصر18",217,175000]
[null,"قيصر240",439,175000]
[null,"قيصر262",461,175000]
[null,"قيصر293",492,175000]
[null,"قيصر31",230,175000]
[null,"قيصر333",532,175000]
[null,"قيصر376",575,175000]
[null,"قيصر474",673,175000]
[null,"قيصر52",251,175000]
[null,"قيصر96",295,175000]
["الحسابات Total",null,null,2275000]
["الصيانة","قيصر244",443,110000]
[null,"قيصر284",483,110000]
[null,"قيصر327",526,110000]
[null,"قيصر33",232,110000]
[null,"قيصر343",542,110000]
[null,"قيصر69",268,110000]
[null,"قيصر89",288,110000]
["الصيانة Total",null,null,770000]
["الكهرباء","قيصر100",299,100000]
[null,"قيصر167",366,100000]
[null,"قيصر234",433,100000]
[null,"قيصر266",465,100000]
[null,"قيصر291",490,100000]
[null,"قيصر328",527,100000]
[null,"قيصر364",563,100000]
["الكهرباء Total",null,null,700000]
["المكتب الخاص","قيصر115",314,200000]
[null,"قيصر211",410,125000]
[null,"قيصر251",450,125000]
[null,"قيصر273",472,125000]
[null,"قيصر303",502,125000]
[null,"قيصر390",589,125000]
[null,"قيصر419",618,125000]
["المكتب الخاص Total",null,null,950000]
["Grand Total",null,null,6945000]

{"sheet":"البيانات","index":1,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["اسم الموظف","رقم الهوية","1","2","3","4","الشعبة","المبلغ"]
["قيصر100",299,null,null,null,null,"الكهرباء",100000]
["قيصر115",314,null,null,null,null,"المكتب الخاص",200000]
["قيصر12",211,null,null,null,null,"الحسابات",175000]
["قيصر128",327,null,null,null,null,"الحسابات",175000]
["قيصر13",212,null,null,null,null,"التدقيق",100000]
["قيصر150",349,null,null,null,null,"التدقيق",100000]
["قيصر167",366,null,null,null,null,"الكهرباء",100000]
["قيصر173",372,null,null,null,null,"الحسابات",175000]
["قيصر18",217,null,null,null,null,"الحسابات",175000]
["قيصر188",387,null,null,null,null,"الانتاج",100000]
["قيصر211",410,null,null,null,null,"المكتب الخاص",125000]
["قيصر234",433,null,null,null,null,"الكهرباء",100000]
["قيصر240",439,null,null,null,null,"الحسابات",175000]
["قيصر244",443,null,null,null,null,"الصيانة",110000]
["قيصر251",450,null,null,null,null,"المكتب الخاص",125000]
["قيصر254",453,null,null,null,null,"الانتاج",150000]
["قيصر262",461,null,null,null,null,"الحسابات",175000]
["قيصر266",465,null,null,null,null,"الكهرباء",100000]
["قيصر273",472,null,null,null,null,"المكتب الخاص",125000]
["قيصر283",482,null,null,null,null,"الانتاج",150000]
["قيصر284",483,null,null,null,null,"الصيانة",110000]
["قيصر291",490,null,null,null,null,"الكهرباء",100000]
["قيصر293",492,null,null,null,null,"الحسابات",175000]
["قيصر296",495,null,null,null,null,"التدقيق",100000]
["قيصر297",496,null,null,null,null,"الانتاج",150000]
["قيصر303",502,null,null,null,null,"المكتب الخاص",125000]
["قيصر31",230,null,null,null,null,"الحسابات",175000]
["قيصر327",526,null,null,null,null,"الصيانة",110000]
["قيصر328",527,null,null,null,null,"الكهرباء",100000]
["قيصر33",232,null,null,null,null,"الصيانة",110000]
["قيصر333",532,null,null,null,null,"الحسابات",175000]
["قيصر342",541,null,null,null,null,"الانتاج",150000]
["قيصر343",542,null,null,null,null,"الصيانة",110000]
["قيصر364",563,null,null,null,null,"الكهرباء",100000]
["قيصر371",570,null,null,null,null,"التدقيق",100000]
["قيصر376",575,null,null,null,null,"الحسابات",175000]
["قيصر390",589,null,null,null,null,"المكتب الخاص",125000]
["قيصر419",618,null,null,null,null,"المكتب الخاص",125000]
["قيصر422",621,null,null,null,null,"الانتاج",150000]
["قيصر423",622,null,null,null,null,"الانتاج",150000]
["قيصر432",631,null,null,null,null,"التدقيق",100000]
["قيصر439",638,null,null,null,null,"التدقيق",100000]
["قيصر441",640,null,null,null,null,"الانتاج",150000]
["قيصر444",643,null,null,null,null,"الانتاج",150000]
["قيصر470",669,null,null,null,null,"التدقيق",100000]
["قيصر474",673,null,null,null,null,"الحسابات",175000]
["قيصر482",681,null,null,null,null,"الانتاج",150000]
["قيصر52",251,null,null,null,null,"الحسابات",175000]
["قيصر54",253,null,null,null,null,"التدقيق",100000]
["قيصر69",268,null,null,null,null,"الصيانة",110000]
["قيصر89",288,null,null,null,null,"الصيانة",110000]
["قيصر96",295,null,null,null,null,"الحسابات",175000]

{"sheet":"فرز وجمع","index":2,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["اسم الموظف","رقم الهوية","1","2","3","4","الشعبة","المبلغ",null,"الشعبة","المبلغ"]
["قيصر188",387,null,null,null,null,"الانتاج",100000,null,"الانتاج",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":1450000}]
["قيصر254",453,null,null,null,null,"الانتاج",150000,null,"التدقيق",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":800000}]
["قيصر283",482,null,null,null,null,"الانتاج",150000,null,"الحسابات",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":2275000}]
["قيصر297",496,null,null,null,null,"الانتاج",150000,null,"الصيانة",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":770000}]
["قيصر342",541,null,null,null,null,"الانتاج",150000,null,"الكهرباء",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":700000}]
["قيصر422",621,null,null,null,null,"الانتاج",150000,null,"المكتب الخاص",{"$f":"SUMIF(Sort_Sum[[الشعبة]:[المبلغ]],شعب[[#This Row],[الشعبة]],Sort_Sum[المبلغ])","v":950000}]
["قيصر423",622,null,null,null,null,"الانتاج",150000]
["قيصر441",640,null,null,null,null,"الانتاج",150000]
["قيصر444",643,null,null,null,null,"الانتاج",150000]
["قيصر482",681,null,null,null,null,"الانتاج",150000]
["قيصر13",212,null,null,null,null,"التدقيق",100000]
["قيصر150",349,null,null,null,null,"التدقيق",100000]
["قيصر296",495,null,null,null,null,"التدقيق",100000]
["قيصر371",570,null,null,null,null,"التدقيق",100000]
["قيصر432",631,null,null,null,null,"التدقيق",100000]
["قيصر439",638,null,null,null,null,"التدقيق",100000]
["قيصر470",669,null,null,null,null,"التدقيق",100000]
["قيصر54",253,null,null,null,null,"التدقيق",100000]
["قيصر12",211,null,null,null,null,"الحسابات",175000]
["قيصر128",327,null,null,null,null,"الحسابات",175000]
["قيصر173",372,null,null,null,null,"الحسابات",175000]
["قيصر18",217,null,null,null,null,"الحسابات",175000]
["قيصر240",439,null,null,null,null,"الحسابات",175000]
["قيصر262",461,null,null,null,null,"الحسابات",175000]
["قيصر293",492,null,null,null,null,"الحسابات",175000]
["قيصر31",230,null,null,null,null,"الحسابات",175000]
["قيصر333",532,null,null,null,null,"الحسابات",175000]
["قيصر376",575,null,null,null,null,"الحسابات",175000]
["قيصر474",673,null,null,null,null,"الحسابات",175000]
["قيصر52",251,null,null,null,null,"الحسابات",175000]
["قيصر96",295,null,null,null,null,"الحسابات",175000]
["قيصر244",443,null,null,null,null,"الصيانة",110000]
["قيصر284",483,null,null,null,null,"الصيانة",110000]
["قيصر327",526,null,null,null,null,"الصيانة",110000]
["قيصر33",232,null,null,null,null,"الصيانة",110000]
["قيصر343",542,null,null,null,null,"الصيانة",110000]
["قيصر69",268,null,null,null,null,"الصيانة",110000]
["قيصر89",288,null,null,null,null,"الصيانة",110000]
["قيصر100",299,null,null,null,null,"الكهرباء",100000]
["قيصر167",366,null,null,null,null,"الكهرباء",100000]
["قيصر234",433,null,null,null,null,"الكهرباء",100000]
["قيصر266",465,null,null,null,null,"الكهرباء",100000]
["قيصر291",490,null,null,null,null,"الكهرباء",100000]
["قيصر328",527,null,null,null,null,"الكهرباء",100000]
["قيصر364",563,null,null,null,null,"الكهرباء",100000]
["قيصر211",410,null,null,null,null,"المكتب الخاص",125000]
["قيصر251",450,null,null,null,null,"المكتب الخاص",125000]
["قيصر273",472,null,null,null,null,"المكتب الخاص",125000]
["قيصر303",502,null,null,null,null,"المكتب الخاص",125000]
["قيصر390",589,null,null,null,null,"المكتب الخاص",125000]
["قيصر419",618,null,null,null,null,"المكتب الخاص",125000]
["قيصر115",314,null,null,null,null,"المكتب الخاص",200000]