{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Requirement","Raw Data","Date & Amount & Type","Date & Amount"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Requirement","index":0,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Case Number","Situation","Action"]
[1,"If any rows (with different expense number) of both Expense Date (Column Q) and Line Amount (Column L) have the same value","Create a tab (Name: Date & Amount) and copy and paste the related rows to this tab"]
[2,"If any rows (with different expense number) of Expense Date (Column Q), Line Amount (Column L) and Expense Type (Column K) have the same value","Create a tab (Name: Date & Amount & Type) and copy and paste the related rows to this tab"]
[3,"If any rows (with different expense number) of Expense Date (Column Q), Line Amount (Column L), Expense Type (Column K) and Claimant Name (Column B) have the same value","Create a tab (Name: Date & Amount & Type & Name) and copy and paste the related rows to this tab"]
[4,"If Expense Type (Column K) contains PROF.FEE, and;\nIf any rows (with different expense number)of  Claimant Name (Column B) have the same value","Create a tab (Name: Professional Fees) and copy and paste the related rows to this tab"]

{"sheet":"Raw Data","index":1,"n_rows":15,"n_cols":47,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Expense Number","Claimant Name","Report Submitted Date","Expense Report Date","Purpose","Purpose","Status","Amount (HKD)","Currency","Line Number","Expense Type","Line Amount (HKD)","Receipt Amount (Before Tax)","Line Currency","Exchange Rate","Justification","Expense Date","Allocation Number","Allocation Amount","Expense Allocation","Employee (If not the claims)","Departure Location","Destination","Mode of Transportation","Purpose of Journey","Name of Guest Company","Most Senior Participant","Purpose of Entertainment","Cost Per Head","Cost Per Head (Before Tax)","Number of Participants","Name and Position of Participants","TAR Approved Number","Reason of Guest No. Diff","Reason of Other Related Expense","ABC Approval Reference Number","Additional Approver 1","Additional Approver 2","EAP Approver 3","Additional Approver 4","Additional Approver 5","Additional Approver - CEO","Additional Approver - AAE","HR Division 1","HR Division 2","HR Division 3","HR Division 4"]
["ENC00001","A, BC  (Tom)_ENC00001",null,null,null,null,null,null,null,null,"Oversea Travel - Taxi",102,null,null,null,null,"2024/01/06"]
["ENC00001","A, BC  (Tom)_ENC00001",null,null,null,null,null,null,null,null,"Oversea Travel - Taxi",102,null,null,null,null,"2024/01/06"]
["ENC00003","A, KY  (Jack)_ENC00003",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1004,null,null,null,null,"2024/01/07"]
["ENC00003","A, KY  (Jack)_ENC00003",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1004,null,null,null,null,"2024/01/07"]
["ENC00005","D, AB (Max)_ENC00005",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",500,null,null,null,null,"2024/01/08"]
["ENC00006","K, LB (Dave)_ENC00006",null,null,null,null,null,null,null,null,"Meal",807,null,null,null,null,"2024/07/09"]
["ENC00007","K, LB (Dave)_ENC00006",null,null,null,null,null,null,null,null,"Meal",807,null,null,null,null,"2024/07/09"]
["ENC00008","K, LB (Dave)_ENC00006",null,null,null,null,null,null,null,null,"Meal",807,null,null,null,null,"2024/07/09"]
["ENC00012","I, OP (Ren)_ENC00012",null,null,null,null,null,null,null,null,"PROF.FEE",500000,null,null,null,null,"2024/05/13"]
["ENC00013","O, PD (Ian)_ENC00013",null,null,null,null,null,null,null,null,"PROF.FEE",1000,null,null,null,null,"2024/09/13"]
["ENC00015","I, OP (Ren)_ENC00015",null,null,null,null,null,null,null,null,"PROF.FEE",500000,null,null,null,null,"2024/05/13"]
["ENC00002","B, YU (Ken)_ENC00002",null,null,null,null,null,null,null,null,"Oversea Travel - Bus",102,null,null,null,null,"2024/01/06"]
["ENC00003","A, KY  (Jack)_ENC00003",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1000,null,null,null,null,"2024/01/07"]
["ENC00004","C, AD (Mary)_ENC00004",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1000,null,null,null,null,"2024/01/07"]

{"sheet":"Date & Amount & Type","index":2,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ENC00003","A, KY  (Jack)_ENC00003",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1000,null,null,null,null,"2024-01-07"]
["ENC00004","C, AD (Mary)_ENC00004",null,null,null,null,null,null,null,null,"Oversea Travel - Entertainment",1000,null,null,null,null,"2024-01-07"]

{"sheet":"Date & Amount","index":3,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["ENC00001","A, BC  (Tom)_ENC00001",null,null,null,null,null,null,null,null,"Oversea Travel - Taxi",102,null,null,null,null,"2024-01-06"]
["ENC00002","B, YU (Ken)_ENC00002",null,null,null,null,null,null,null,null,"Oversea Travel - Bus",102,null,null,null,null,"2024-01-06"]