The system shall allow users to select a folder containing two excel files that they want to compare.
The system shall compare the two sets of data and check for the differences in each category.
The system shall compare the required fields from the selected excel files, and check for the discrepancy for each field.
Required Fields:
- NRIC Number + Month
- MFEC/ PA/ SG
- No Of Patient Days
- Funded (Home Leave)
- Non Funded (Home Leave)
- Funded (Hosp. Leave)
- Non Funded (Hosp. Leave)
- Bill Size
- MOH Subsidy (Submitted)
- GST Charged
- MOH Subvention computed
- Home Leave
- SP
- AIC/MOH
- GST Absorbed
- MT Subsidy Tier / Sub %
The system shall highlight the cells with different data for the two different files.
The system shall present all the different data in a new excel sheet and organize it in a way that is easier for clients to compare data.