{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Payroll Comment","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":27,"defined_names":523,"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":"Main","index":0,"n_rows":3,"n_cols":30,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["#","E.No.","Name","Total Salary","Rejoining","Advance Leave","Social Insurance","Over Time","Deduction","Earning","Comments",null,"Basic Salary","Total Allowance",null,"Old Salary","Increment","Social Allow","Child Allow","Enc - Allow","COLA Allow","Financial Support","Special Allow","Supervision Allow","Transport Allow","Food Allow","Accom Allow","Hiring Date","Position","Department"]
[1,139,"Osama Mahmoud Hashem Mahmoud",503.5,"","",null,0,"",null,"",null,453.5,50,null,489,14.5,null,null,null,50,null,null,null,null,null,null,"2007-04-26","Reception Supervisor","Reception"]
[2,168,"Peter Hanna Noshi Zaki",219.25,"2025-01-24","",null,0,"",null,"3 - عودة من الإجازة",null,169.25,50,null,213.75,5.5,null,null,null,50,null,null,null,null,null,null,"2018-07-15","Receptionist","Reception"]

{"sheet":"Payroll Comment","index":1,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,5,11,8]]}
["#","Emp. No.","Name","Total salary","Rejoining / Start Vacation","Advance Leave","Social Insurance","Over Time","Deduction","Earning","Amount","Comments","Amount","Diff","Comments",null,null,null,null,null,null,"Hiring Date","Department","Position"]
[{"$f":"IF(C2=\"\",\"\",SUBTOTAL(3,$C$2:C2))","v":1},139,{"$f":"VLOOKUP($B2,Main!$B$1:$P$65536,2,0)","v":"Osama Mahmoud Hashem Mahmoud"},{"$f":"VLOOKUP($B2,Main!$B$1:$AH$65536,3,0)","v":503.5},{"$f":"VLOOKUP(B2,Main!$B$1:$AG$65536,4,0)","v":""},{"$f":"VLOOKUP(B2,Main!$B$1:$AG$65536,5,0)","v":""},{"$f":"VLOOKUP(B2,Main!$B$1:$AG$65536,6,0)","v":0},{"$f":"VLOOKUP(B2,Main!$B$1:$I$65536,7,0)","v":0},{"$f":"VLOOKUP(B2,Main!$B$1:$I$65536,8,0)","v":""},null,{"$f":"IF(E2=0,(D2-G2+H2-I2+J2),(U2*D2/T2))","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP(B2,Main!B$1:K$65536,10,0)","v":""},{"$f":"VLOOKUP(B2,#REF!,40,0)","v":{"$error":"#REF!"}},{"$f":"M2-K2","v":{"$error":"#REF!"}},{"$f":"IF(M2=K2,\"OK\",\"Error\")","v":{"$error":"#REF!"}},null,null,{"$f":"EOMONTH(E2,-1)+1","v":{"$error":"#VALUE!"}},{"$f":"EOMONTH(E2,0)","v":{"$error":"#VALUE!"}},{"$f":"NETWORKDAYS.INTL(R2,S2,16)","v":{"$error":"#VALUE!"}},{"$f":"NETWORKDAYS.INTL(E2,S2,16)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($B2,Main!$B$1:$P$65536,5,0)","v":""},{"$f":"VLOOKUP($B2,Main!$B$1:$AD$65536,29,0)","v":"Reception"},{"$f":"VLOOKUP($B2,Main!$B$1:$AD$65536,28,0)","v":"Reception Supervisor"}]
[{"$f":"IF(C3=\"\",\"\",SUBTOTAL(3,$C$2:C3))","v":2},168,{"$f":"VLOOKUP($B3,Main!$B$1:$P$65536,2,0)","v":"Peter Hanna Noshi Zaki"},{"$f":"VLOOKUP($B3,Main!$B$1:$AH$65536,3,0)","v":219.25},{"$f":"VLOOKUP(B3,Main!$B$1:$AG$65536,4,0)","v":"2025-01-24"},{"$f":"VLOOKUP(B3,Main!$B$1:$AG$65536,5,0)","v":""},{"$f":"VLOOKUP(B3,Main!$B$1:$AG$65536,6,0)","v":0},{"$f":"VLOOKUP(B3,Main!$B$1:$I$65536,7,0)","v":0},{"$f":"VLOOKUP(B3,Main!$B$1:$I$65536,8,0)","v":""},{"$f":"IFERROR(VLOOKUP(B3,Main!$B$1:$I$65536,9,0),\"\")","v":""},{"$f":"IF(E3=0,(D3-G3+H3-I3+J3),(U3*D3/T3))","v":50.596153846153847},{"$f":"VLOOKUP(B3,Main!B$1:K$65536,10,0)","v":"3 - عودة من الإجازة"},{"$f":"VLOOKUP(B3,#REF!,40,0)","v":{"$error":"#REF!"}},{"$f":"M3-K3","v":{"$error":"#REF!"}},{"$f":"IF(M3=K3,\"OK\",\"Error\")","v":{"$error":"#REF!"}},null,null,{"$f":"EOMONTH(E3,-1)+1","v":"2025-01-01"},{"$f":"EOMONTH(E3,0)","v":"2025-01-31"},{"$f":"NETWORKDAYS.INTL(R3,S3,16)","v":26},{"$f":"NETWORKDAYS.INTL(E3,S3,16)","v":"1900-01-06"},{"$f":"VLOOKUP($B3,Main!$B$1:$P$65536,5,0)","v":""},{"$f":"VLOOKUP($B3,Main!$B$1:$AD$65536,29,0)","v":"Reception"},{"$f":"VLOOKUP($B3,Main!$B$1:$AD$65536,28,0)","v":"Receptionist"}]
[]
[]
[]
[]
[null,null,null,null,null,"المعادلة اللي عليها السهم دي معادلة If\nشغاله كويس في الخليه K3 \nومش شغاله في الخلية K2"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}