Dear ANOs,
Lt.
Jais Kurian, ANO of St. Stephen's College Uzhavoor, Kerala has
prepared an excel program for the easy preparation of Washing
Allowance Abstract. You can download it from the download
link. The following things have to be kept in mind while using it.
- Change the name of your school/college
- Change the months and year
- When you add the Regtl. No./ NCC No. please add only the number, avoiding the prefixes like KER/SD/13/150666 etc. This way we can save space.
- Change the ranks
- Type or copy names to the 'Names' column. If possible reduce the font size to save space.
- Now comes the most important part – ADD DATA TO THE 'PARADE HELD' AND 'PARADE ATTENDED' COLUMNS ONLY. DO NOT EDIT THE '%' COLUMN, 'TOTAL' COLUMN, 'GRAND TOTAL' COLUMN AND THE 'LAST ROW'.
- For e.g. when you add the number of parades held and the number of parades attended by the cadet, the percentage and amount would appear automatically.
- Check the print preview to make sure that the whole document comes in one page.
- Save the document with an appropriate name.
THE EXCEL PROGRAM FOR THE EASY
PREPARATION OF WASHING ALLOWANCE
