To modify one of the sheets in the excel workbook linked below, you'll need to know some basics about excel formulas. In excel, you can type "=rand()" into a cell (without the quotation marks) and when you hit enter, you will see a random number between 0 and 1. So, in order to generate a random number between 0 and ten, you need to multiply the random number that excel generates by ten like this:
To generate a random number between 5 and 15, try this:
With these simple techniques, you should be able to modify the tables in the excel workbook below (see tabs along bottom for different existing sheets) to suit the needs of your sampling design. Good luck!