| （Physical Education Department，Wuhan University of Technology，Huaxia College，Wuhan 430223，China) Abstract: Starting with working out a scientific sports games registration form, in an Excel workbook, the author fully utilized Excel function combinations to classify, transfer and summarize registration data, to establish connections between various worksheets in the workbook, and to realize the purpose of automatically generating athlete numbers, athlete lists, number correspondence forms, and the forms of heat and lane assignment for athletes who compete in various sports competition events. As for small sports events such as college campus sports games, such Excel function combinations greatly improve the accuracy and efficiency of compilation of such a sports games order brochure.
Key words: sports management；campus sports games；order brochure；Excel function |
