{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["السجل","البودرة","salim"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["ت","القسم","رقم الموبايل","الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
[null,null,null,"2018-12-30",1,"إبراهيم",42875,10000,1,{"$f":"I2*75","v":75},15,5]
[null,null,null,"2018-12-30",2,"إبراهيم",41878,10000,1,{"$f":"I3*75","v":75},15,5]
[null,null,null,"2018-12-30",3,"خليل",36000,10000,1,75,15,5]
[null,null,null,"2018-12-30",4,"محمد",39884,10000,2,150,15,5]
[null,null,null,"2018-12-30",5,"سليمان",42875,10000,1,75,15,5]
[null,null,null,"2018-12-30",6,"سلطان",36068,10000,1,75,15,5]
[null,null,null,"2018-12-30",7,"رائد",42914,10000,2,150,15,5]
[null,null,null,"2019-01-01",8,"علي",36068,15000,1,75,15,5]
[null,null,null,"2019-01-01",9,"عمار",35896,15000,3,225,15,5]
[null,null,null,"2019-01-01",10,"محمود",41878,15000,1,75,15,5]
[null,null,null,"2019-01-01",11,"احمد",42875,15000,1,75,15,5]
[null,null,null,"2019-01-01",12,"مهند",36068,15000,1,75,15,5]
[null,null,null,"2019-01-01",13,"حسن",36000,15000,1,75,15,5]
[null,null,null,"2019-01-01",14,"طه",34000,15000,1,75,15,5]
[null,null,null,"2019-01-01",15,"احمد",35896,15000,1,75,15,5]
[null,null,null,"2019-02-01",1,"إبراهيم",42875,10000,1,{"$f":"I17*75","v":75},15,5]
[null,null,null,"2019-02-01",2,"فرحان",41878,10000,1,75,15,5]
[null,null,null,"2019-02-01",3,"خليل",36000,10000,1,75,15,5]
[null,null,null,"2019-02-01",4,"محمد",39884,10000,2,150,15,5]
[null,null,null,"2019-02-01",5,"سليمان",42875,10000,1,75,15,5]
[null,null,null,"2019-02-01",6,"سلطان",36068,10000,1,75,15,5]
[null,null,null,"2019-02-01",7,"رائد",42914,10000,2,150,15,5]
[null,null,null,"2019-02-01",8,"علي",36068,15000,1,75,15,5]
[null,null,null,"2019-02-01",9,"عمار",35896,15000,3,225,15,5]
[null,null,null,"2019-02-01",10,"محمود",41878,15000,1,75,15,5]
[null,null,null,"2019-02-01",11,"احمد",42875,15000,1,75,15,5]
[null,null,null,"2019-02-01",12,"مهند",36068,15000,1,75,15,5]
[null,null,null,"2019-02-01",13,"حسن",36000,15000,1,75,15,5]
[null,null,null,"2019-02-01",14,"طه",34000,15000,1,75,15,5]
[null,null,null,"2019-02-01",15,"احمد",35896,15000,1,75,15,5]
[null,null,null,"2019-03-01",1,"إبراهيم",42875,10000,1,{"$f":"I32*75","v":75},15,5]
[null,null,null,"2019-03-01",2,"فرحان",41878,10000,1,75,15,5]
[null,null,null,"2019-03-01",3,"خليل",36000,10000,1,75,15,5]
[null,null,null,"2019-03-01",4,"محمد",39884,10000,2,150,15,5]
[null,null,null,"2019-03-01",5,"سليمان",42875,10000,1,75,15,5]
[null,null,null,"2019-03-01",6,"سلطان",36068,10000,1,75,15,5]
[null,null,null,"2019-03-01",7,"رائد",42914,10000,2,150,15,5]
[null,null,null,"2019-03-01",8,"علي",36068,15000,1,75,15,5]
[null,null,null,"2019-03-01",9,"عمار",35896,15000,3,225,15,5]
[null,null,null,"2019-03-01",10,"محمود",41878,15000,1,75,15,5]
[null,null,null,"2019-03-01",11,"احمد",42875,15000,1,75,15,5]
[null,null,null,"2019-03-01",12,"مهند",36068,15000,1,75,15,5]
[null,null,null,"2019-03-01",13,"حسن",36000,15000,1,75,15,5]
[null,null,null,"2019-03-01",14,"طه",34000,15000,1,75,15,5]
[null,null,null,"2019-03-01",15,"احمد",35896,15000,1,75,15,5]

{"sheet":"البودرة","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["ت","القسم","رقم الموبايل","الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي","التوقيع وتاريخ الاستلام"]
[null,null,null,"2018-12-30",1,"إبراهيم",42875,10000,1,75,15,5,{"$f":"G5+H5+K5+L5-J5","v":158460}]
[null,null,null,"2019-02-01",1,"إبراهيم",42875,10000,1,75,15,5]
[null,null,null,"2019-03-01",1,"إبراهيم",42875,10000,1,75,15,5]
[null,null,null,null,null,"المجموع",{"$f":"SUM(G2:G4)","v":128625},{"$f":"SUM(H2:H4)","v":30000},null,{"$f":"SUM(J2:J4)","v":225},{"$f":"SUM(K2:K4)","v":45},{"$f":"SUM(L2:L4)","v":15}]
["ت","القسم","رقم الموبايل","الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي","التوقيع وتاريخ الاستلام"]
[null,null,null,"2018-12-30",2,"فرحان",41878,10000,1,75,15,5,{"$f":"G10+H10+K10+L10-J10","v":155469}]
[null,null,null,"2019-02-01",2,"فرحان",41878,10000,1,75,15,5]
[null,null,null,"2019-03-01",2,"فرحان",41878,10000,1,75,15,5]
[null,null,null,null,null,"المجموع",{"$f":"SUM(G7:G9)","v":125634},{"$f":"SUM(H7:H9)","v":30000},null,{"$f":"SUM(J7:J9)","v":225},{"$f":"SUM(K7:K9)","v":45},{"$f":"SUM(L7:L9)","v":15}]
["ت","القسم","رقم الموبايل","الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي","التوقيع وتاريخ الاستلام"]
[null,null,null,"2018-12-30",3,"خليل",36000,10000,1,75,15,5,{"$f":"G15+H15+K15+L15-J15","v":137835}]
[null,null,null,"2019-02-01",3,"خليل",36000,10000,1,75,15,5]
[null,null,null,"2019-03-01",3,"خليل",36000,10000,1,75,15,5]
[null,null,null,null,null,"المجموع",{"$f":"SUM(G12:G14)","v":108000},{"$f":"SUM(H12:H14)","v":30000},null,{"$f":"SUM(J12:J14)","v":225},{"$f":"SUM(K12:K14)","v":45},{"$f":"SUM(L12:L14)","v":15}]
[]
[]
[null,null,null,null,"كود يقوم بترتيب السجل على هذا الشكل (كل رقم هوية تجمع بهذا الشكل)"]

{"sheet":"salim","index":2,"n_rows":85,"n_cols":10,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",1,"إبراهيم",42875,10000,1,75,15,5]
["2018-12-30",2,"إبراهيم",41878,10000,1,75,15,5]
["2019-02-01",1,"إبراهيم",42875,10000,1,75,15,5]
["2019-03-01",1,"إبراهيم",42875,10000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",3,"خليل",36000,10000,1,75,15,5]
["2019-02-01",3,"خليل",36000,10000,1,75,15,5]
["2019-03-01",3,"خليل",36000,10000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",4,"محمد",39884,10000,2,150,15,5]
["2019-02-01",4,"محمد",39884,10000,2,150,15,5]
["2019-03-01",4,"محمد",39884,10000,2,150,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",5,"سليمان",42875,10000,1,75,15,5]
["2019-02-01",5,"سليمان",42875,10000,1,75,15,5]
["2019-03-01",5,"سليمان",42875,10000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",6,"سلطان",36068,10000,1,75,15,5]
["2019-02-01",6,"سلطان",36068,10000,1,75,15,5]
["2019-03-01",6,"سلطان",36068,10000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2018-12-30",7,"رائد",42914,10000,2,150,15,5]
["2019-02-01",7,"رائد",42914,10000,2,150,15,5]
["2019-03-01",7,"رائد",42914,10000,2,150,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",8,"علي",36068,15000,1,75,15,5]
["2019-02-01",8,"علي",36068,15000,1,75,15,5]
["2019-03-01",8,"علي",36068,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",9,"عمار",35896,15000,3,225,15,5]
["2019-02-01",9,"عمار",35896,15000,3,225,15,5]
["2019-03-01",9,"عمار",35896,15000,3,225,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",10,"محمود",41878,15000,1,75,15,5]
["2019-02-01",10,"محمود",41878,15000,1,75,15,5]
["2019-03-01",10,"محمود",41878,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",11,"احمد",42875,15000,1,75,15,5]
["2019-01-01",15,"احمد",35896,15000,1,75,15,5]
["2019-02-01",11,"احمد",42875,15000,1,75,15,5]
["2019-02-01",15,"احمد",35896,15000,1,75,15,5]
["2019-03-01",11,"احمد",42875,15000,1,75,15,5]
["2019-03-01",15,"احمد",35896,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",12,"مهند",36068,15000,1,75,15,5]
["2019-02-01",12,"مهند",36068,15000,1,75,15,5]
["2019-03-01",12,"مهند",36068,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",13,"حسن",36000,15000,1,75,15,5]
["2019-02-01",13,"حسن",36000,15000,1,75,15,5]
["2019-03-01",13,"حسن",36000,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-01-01",14,"طه",34000,15000,1,75,15,5]
["2019-02-01",14,"طه",34000,15000,1,75,15,5]
["2019-03-01",14,"طه",34000,15000,1,75,15,5]
[]
[]
["الشهر","رقم الهوية","اسم المنتسب","الراتب","المكافات","الغياب","مبلغ الغياب","بدل الايجار","بدل النقل","الصافي"]
["2019-02-01",2,"فرحان",41878,10000,1,75,15,5]
["2019-03-01",2,"فرحان",41878,10000,1,75,15,5]