The invention relate to a method for making a high-score Excel lottery ticket,

Menu bar-File-New-A new workbook pane appears on the right-Native template-A template dialog box appears-Electronic scheme table-Select lucky draw-OK-Edit interface appearance mode and Microsoft? Excel？ –? Book 1 "parallel imports" Microsoft? Excel？ –? REPORT9 1 "Operating procedures:

The worksheet has four tabs: Lottery, Settings, Lottery Results and Candidate List.

Notes and precautions:

1. This lottery program can draw a lottery for a group of candidate lists according to user settings.

2. Enter all candidate lists in the "Candidate List" worksheet, with one line for each person and no blank lines.

3, in the "Settings" worksheet:

① Set the number of "awards" (from "grand prize" to "fifth prize" * *, with a maximum of 6 awards), with a maximum of 5,000 single-level winners, and the total number of winners cannot exceed the number of candidates in the "shortlist".

② Select "Draw Order" by default or as required.

③ Key points of "lottery method": draw all winners in a group at a time, or draw several winners in the same group at a time.

(4) After setting, click the "Setting Complete" button, and the program will automatically transfer to the "Lottery" worksheet.

4. In the "Lucky Draw" worksheet:

(1) Click the "Start Lottery" button-the program will automatically change all the unselected candidate lists under the "This Winning List" in the upper right corner according to the "Lottery Order" in the settings-click the "Stop" button (originally the "Start Lottery" button) to display the winning list of the same level in the "This Winning List".

② Once the lottery begins, please complete the whole lottery process, and don't quit the program halfway;

③ After the lottery of each award is completed, the "Continue to Draw" button will become the "Draw End" button.

5. You can see the winners of each award in the "Lottery Results" worksheet.

6. Press the "Print Winner List" button in the "Lucky Draw" worksheet to print out the winners list of each award.

7. This plan does not support duplicate awards. ?