Excel File Requirements

Required Sheets

• 'Sort' sheet - Contains prize categories and amounts • 'Ranklist' sheet - Contains player information

Sheet Requirements

Sort Sheet: Must have 'Prize' and 'Prize Money' columns Ranklist Sheet Columns: Required columns in the same order: • Rank • Serial No. • Title • Name • Gender • Rating (IRtg) • Club • Age • Type • Special Prize 1 (Gr) • Special Prize 2 (Gr) • Special Prize 3 (Gr) • Points

Category Naming Rules

1. Rating Categories • Use "Below_" prefix (e.g., Below_1800, Below_2000) • Ratings must be numeric values 2. Women's Categories • Use "W" for women's categories • Player must have 'F' in gender column • Leave Type column empty for general women's prizes 3. Club Categories • Club + gender: Append _M or _F (e.g., GOA_M, GOA_F) • Club + gender + age: Use exact format (e.g., GOA_F07, GOA_U15) • Club names must match exactly between sheets 4. Unrated Category • Use "Un" for unrated players • Only players with 0 rating are considered

Mode 1:

Initial Excel Sheet Setup • Create a new Excel file with three sheets: • Sheet1: Enter the Tournament Name here. • Sheet2: Rename it to "SORT". • Sheet3: Rename it to "RANKLIST". • Paste the final rank list in the "RANKLIST" sheet. • The "Rank" column must not be left blank. The following columns must be present in this specific order, even if some values are blank: • Rank • Serial No. • Title • Name • Gender • Rating (IRtg) • Club • Age • Type • Special Prize 1 (Gr) • Special Prize 2 (Gr) • Special Prize 3 (Gr) • Points SORT Sheet Prize Entry Guidelines In the "SORT" sheet, enter prize details as per the tournament brochure: • For Main Prizes, label as: Example: Main_1, Main_2, Main_3, etc. • For Rating Category Prizes (start from the highest rating category): Example: Below_1800_1, Below_1600_1, etc. • For Unrated Players: Example: Un_1, Un_2, etc. • For Veteran Categories: If 55 years and above: S55_1 If above 55 years: S56_1 (Follow the classification provided in the brochure.) • For Women’s Prizes: Example: Use SP_1, SP_2, etc. In the "Group" column of the Ranklist sheet, mark these entries as SP. • For Physically Challenged or similar special categories: Use PC_1, PC_2, etc. • For Club/Regional Prizes: Use Kar_1, Kar_2, etc. • For Age Group Prizes: Use U07_1, U09_1, etc. • If the prize is a Trophy or Medal, still enter it under "SORT" with the term "Trophy". • If a Trophy is awarded instead of prize money, add ₹1 to the prize money to differentiate.

Mode 2:

• Special Considerations for Age Categories • Begin with the highest age category when listing in the SORT sheet. • Even if the prize is a Trophy or Medal, assign differentiated numerical values like 500, 400, etc., to maintain prize order. • Start from the highest age group. Give value less than the least prize money. For example U18_1 value 1010 U16_ value 1009 U14_1 value 1008 likevwise for remaining categories and no if prizes • These numerical values will help in sorting and differentiating prize levels, even if the actual prize is non-monetary.

Important Notes

• Category names must match exactly between sheets • Rank and Rating columns must contain numeric values • For disabilities, use PC or VC in the Special Prizes column • Age categories must use exact format (e.g., F07, not F7) • Minor formatting or header corrections can be done later during the output phase