What you get
- One sheet per caste category: 1G, 2A, 2B, 3A, 3B, GM, S1–S4, ST, with the same columns as your existing workbook.
- Students are grouped by their claimed category (OPN goes to GM). In each sheet, government seats come first, then private, then others. Each group is sorted by rank.
- Rows are colour-coded by seat type. Fees use Indian digit grouping and dates are real Excel dates. A red cell means ACTUAL doesn't match FEES FOR.
- Each sheet has a frozen header and filters, and prints landscape. A SUMMARY sheet with totals is added at the end.
- For allotment lists, you can filter to a single college before downloading. Non-caste seats (OPN, NRI, ME, PHM…) go to an OTHERS sheet.