excel files.zip (25.4 KB)
Foreach annual {
Bool checkError = false
array[String] errorAnnualColumn =
array(String] error QuarterlyColumn =
Filter quarterly (with same NRIC and month)
If (filter count > O){
Foreach Column {
If (annualColumnValue I= quarterlyColumnValue) {
checkError = true
errorAnnualColumn add annualColumn[index] errorQuarterlyColumn add quarterlyColumn[index]
If (checkError) (
Add data row for annual
Set column value to errorAnnualColumn
Set table value to “annual”
Add data row for quarterly
Set column value to errorQuarterlyColumn
Set table value to “quarterly”
Add an empty row into errorTable
}
Delete current quarterly row
}else{
Add data row for annual
Set column value to errorAnnualColumn
Set table vatue to “annual”
Add an empty row into errorTable
}
Delete current annual row
}
compare the excel files and find the unmatched data and put it in this format in a new excel file
| NRIC | Month | MFEC/PA/SG | No Of Patient Days | Funded(Home) | Non Funded(Home) | Funded(Hosp.) | Non Funded(Hosp.) | Bill Size | MOH Subsidy(Submitted) | GST Charged | MOH Subvention computed | Home Leave | Hosp Leave | SP | AIC/MOH | GST Absorbed | Row | Column |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| (annual data) non matched data only | ||||||||||||||||||
| (quarterly data) non matched data only | ||||||||||||||||||
| (annual data) non matched data only | ||||||||||||||||||
| (quarterly data) non matched data only |