Mr.
186 Points
Joined May 2021
@ Rajan
Another addition to the previous post. This is for your perusal. The Summary sheet that is generated at the end has the following instructions at the bottom. My comments are in parenthesis.
Instructions
1. Verify the count of number of entries against each schedule.
(This is mostly shown correctly in the Preview except where couple of rows with data have been omitted altogether)
2. Ensure the total number of entries entered per schedule is valid and being reflected in the preview sheet.
(Entries correct but the Amount shows "NA". Again, couple of rows omitted)
3. In case this count does not match the number of entries, you may check and update the schedules.
(This here is foolishness. Blame the user!)
4. Click on ‘Save XML’ to generate the XML file if all the details are verified.
The only button available on this summary sheet is "Generate JSON". They didn't even bother editing the Summary sheet text strings!
5. All Schedules which are optional and not filled are reported as ‘Empty’ in Preview
(This is the only correct thing in the Preview but which also is categorically useless)
Anyone from Infy, if you reading this, you have not released an Excel Utility. You have released a half-baked, untested Torture Utility. Guess quality requires good coders & testers not just edicts of extra long work hours. Kindly release updated version with these things sorted out.