Prize Ranking
Budget: $30 – $250 AUD
This project requires the skills of a VBA expert. A knowledge of golf would be a bonus. It involves copying exported data into a spreadsheet and then determining prize category winners based on sort criteria.
The sequence is as follows:
1. Data from worksheets ‘1_SatAM’ to ‘8_36Gross’ are to be copied into worksheet ‘RankAll’ as shown. Column lengths will vary depending on field size, but they should all follow sequentially, even if (say) ‘1_SatAM to ‘4_SunPM’ are blank. Cell values at the bottom of all external sheets which don’t have a position ID are excluded. GA and Daily handicaps which are shown as text +values are to be changed to negative values and the handicap designated as ‘Scr’ to be assigned zero in the spreadsheet. Note that all the scores in columns G to R, are in countback order in terms of prize allocation.
2. Columns S and T denoted by ‘Senior’ and ‘Junior’ are a lookup/match values from the DOB worksheet.
3. If any cell in Row 2 is not named, then columns are blank.
4. Column B, ‘ID’ should have sequential numbering so that filtering back to original data can be done.
5. Columns F, U and V are user-defined.
6. Columns Y and Z are used defined, with the ‘value’ sorted in descending order. List length is variable.
7. Columns AA, AB, AC, AD and AE are suggested sort criteria.
8. The requirement is to list the “Winners’ and corresponding ‘Scores’ based on the sort criteria. The ‘Win Again?’ (Y) allows a player to win a second prize from the list, otherwise one player one prize, i.e., if a player has already won a prize, the next player on the specific category list is selected. If he has already won a prize, then the next, etc, etc.
9. Suggest two macros, ‘Input Data” and ‘FindWinners”.
Trust the above is clear.
The sequence is as follows:
1. Data from worksheets ‘1_SatAM’ to ‘8_36Gross’ are to be copied into worksheet ‘RankAll’ as shown. Column lengths will vary depending on field size, but they should all follow sequentially, even if (say) ‘1_SatAM to ‘4_SunPM’ are blank. Cell values at the bottom of all external sheets which don’t have a position ID are excluded. GA and Daily handicaps which are shown as text +values are to be changed to negative values and the handicap designated as ‘Scr’ to be assigned zero in the spreadsheet. Note that all the scores in columns G to R, are in countback order in terms of prize allocation.
2. Columns S and T denoted by ‘Senior’ and ‘Junior’ are a lookup/match values from the DOB worksheet.
3. If any cell in Row 2 is not named, then columns are blank.
4. Column B, ‘ID’ should have sequential numbering so that filtering back to original data can be done.
5. Columns F, U and V are user-defined.
6. Columns Y and Z are used defined, with the ‘value’ sorted in descending order. List length is variable.
7. Columns AA, AB, AC, AD and AE are suggested sort criteria.
8. The requirement is to list the “Winners’ and corresponding ‘Scores’ based on the sort criteria. The ‘Win Again?’ (Y) allows a player to win a second prize from the list, otherwise one player one prize, i.e., if a player has already won a prize, the next player on the specific category list is selected. If he has already won a prize, then the next, etc, etc.
9. Suggest two macros, ‘Input Data” and ‘FindWinners”.
Trust the above is clear.