{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["File validation tool","Validation result details"],"not_rendered":{"charts":0,"images":1,"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":"File validation tool","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,11],[10,0,10,11]]}
["Procedure to validate the upload file"]
["1. Click  the \"Select upload file to validate\" button."]
["2. Choose the upload file in the pop up box."]
["3. The upload file format will be validated against the definition in the \"RemitReturn\" worksheet of the \"Annex H _specification\" Excel."]
["4. A message box will be prompted to show the overall validation result. The result of each detail record is shown in the \"Validation result details\" worksheet."]
["5. If the overall validation result is failed:"]
[null,"a. Please refer to the \"Validation result details\" worksheet to see which record(s) has/have exception."]
[null,"b. Correct the upload file according to the \"Annex H _specification\" Excel."]
[null,"c. Clean the \"Validation result details\" worksheet."]
[null,"d. Start from step 1 again."]
["Note: This validation tool may not be able to validate all possible errors of the upload file, as it is designed for all insurers and for all reporting periods. \n             During the actual upload, the Levy System will perform a more specific validation on the upload file. "]

{"sheet":"Validation result details","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Validation Result:","******* Congratulation ******* All records of the input file has passed the format checking."]
["FormType|CompanyRegNum|BusinessType|ReportingBasis|RelevantPeriodFrom|RelevantPeriodTo|DateOfRemittance|ReportingCurrency|PaymentReferenceNum|CaseType|SubRelevantPeriod|PolicyCount|PremiumAmount|ApplicableLevyRate|LevyAmount|TotalLevyRemittance","Format OK"]
["HRR|F123456|GB|ARB|01/04/2018|30/09/2018|30/11/2018|HKD|478372|LEV|04/2018|100|5000000.00||5000.00|10700.00","Format OK"]