Skiers who are easily injured at the freezing point

Jiang Tao practiced slope obstacle skills at Beijing Nanshan Ski Resort. Photo courtesy of respondents
During the Beijing Winter Olympics, an orthopedic surgeon wrote in Weibo: Today, 9 operations, 7 were skiing, 4 anterior cruciate ligaments were broken, 1 patella was dislocated, 1 ankle joint was injured, and 1 meniscus was injured. He sighed with emotion: "At the end of the snowy road is orthopedics." This quip was posted on Weibo Hot Search.
When people praise the fashionable men and women in the ski resort on social media, they will not think that skiing is a sport with high risk factor when they look at the bright snow clothes and red faces set off by the "natural reflector". According to the survey data of the National Trauma Data Center, there are 17 million skiers in the United States every year, with 200,000 emergency visits and 7,000 hospitalizations due to skiing injuries. China’s survey data also shows that the injury rate of skiing is 14%. It is reported that every 1000 skiers have an average daily injury of 0.5-3 cases. Judging from the incidence of injuries, skiing has a greater risk of injuries than swimming and mountain climbing.
Every winter, the rehabilitation center of the Institute of Sports Medicine of the State Sports General Administration always welcomes more patients from ski resorts. Qi Tianyi, a rehabilitation therapist who has worked here for many years, told the reporter of China Youth Daily and China Youth Network that skiing is characterized by high kinetic energy and high potential energy, which is easy to cause serious injuries. The injuries he saw caused by skiing were mainly clavicle fracture, rotator cuff injury, wrist fracture and anterior cruciate ligament rupture of knee joint. The sports injury characteristics of snowboarders are different from those of snowboarders. Snowboarding skiers often have wrist injuries because they have more movements with their hands on the ground, and the probability of injury is as high as 20.4-37.8%. However, snowboarders often suffer from knee ligament injury because of good fixation below the knee joint. The comprehensive injury rate of anterior cruciate ligament and medial collateral ligament of adult knee joint is 33.1%.
The athletes of the national training team of the front double-board freestyle skiing platform experienced the rupture of the anterior cruciate ligament of the knee joint. At that time, he was just doing a familiar warm-up action. "I heard a bang in my ear the moment I landed. I don’t know what was disconnected, but it came to my ears, and that’s the sound. " The severe pain attacked him and stopped after a few minutes, replacing it with a feeling of numbness. He thought he was better and continued to slide for a while, but found that it was wrong. "The thigh and calf seemed to be detached." This year, Gao Shang underwent anterior cruciate ligament reconstruction and meniscus suture, which requires transplanting a ligament from the thigh to the knee.
Studies have shown that the knee accounts for about one-third of all public skiing injuries. According to Qi Tianyi, this mainly exists in the snowboarding event. Before the 1980s, skiing equipment was not sophisticated enough, and more injuries were caused to the feet. Later, the equipment became more and more wrapped, and the position of the injuries began to move upwards. "Better wrapping below the knee joint is disastrous for the knee joint. During the exercise, more torque will be transmitted to the knee joint, so the injury rate of the knee joint is on the rise. "
Qi Tianyi was once employed by the Winter Sports Management Center of the State General Administration of Sport, and has done sports rehabilitation for athletes such as Sui Wenjing and Han Cong. Every year before winter, the head teacher will always say, "There are many broken legs and hands recently, so we should get busy." Different from the acute injuries in winter sports, the patients they receive in summer are more chronic strain. It has been a long time to rehabilitate skiers, and Qi Tianyi himself has "entered the pit". He likes double board freestyle skiing and can make a simple 180-degree turn on the platform. He became a "friend of a rehabilitation teacher" for skiers, and sometimes he caught patients who came to ski again before they recovered. Later, in his hospital, he was responsible for most cases of skiing injuries.
The patient who impressed Qi Tianyi the most was a skier who had torn the anterior cruciate knee joint, medial collateral ligament and lateral collateral ligament. That patient was injured around 2017. Because of the deep degree of injury, he did not intervene in rehabilitation treatment in time, and he still can’t complete the whole squat movement until now.
Athletes are noble and have the habit of writing sports summaries. After the reconstruction of the anterior cruciate ligament of the knee, the 19-year-old athlete, who has been snowing for 7 years, wrote: "It was hard for me to accept at first, but I didn’t expect my body to be so’ fragile’ sometimes." Fragility is unfamiliar to him. In the past five years, he felt that he had been in good health. Although he was tired after skiing, he could recover the next day. The injury made him feel "particularly helpless".
When he was recovering, he watched skiing videos on social networking sites, and he liked Henrik harlaut, a Swedish freestyle skier best. This is his idol that has never changed since he came into contact with skiing at the age of 12. They like the same music, even their dressing styles are similar-wide sleeves and hip-hop style. Noble imitates Henrik harlaut’s skiing style, and feels that he skates naturally and smoothly.
This year, he watched almost all the snow events in the Beijing Winter Olympics. "Very emotional", he was so close to them, and now they stand in the Olympic Games. In July, 2020, Gao Shang fell behind the training due to a muscle strain in his right thigh, leaving the national training team and returning to the provincial team.
Guo Jingduo, a former freestyle skiing slope obstacle skill and national training team athlete with big platform, had similar experience with him. Last summer, when training in Chengdu dry snow field, he landed on his back, fractured his spine and suffered a sharp pain in his back for an instant. His teammates came to see him. He was so painful that he couldn’t speak, had difficulty breathing, and felt numb in his legs and couldn’t move. The operation finally left a wound in the center of his back. The doctor said that this position is very dangerous, and it will almost lead to paralysis of the lower body. This injury directly prompted him to choose to retire.
Half a year after the injury, Guo Jingduo resumed his normal exercise and life to a certain extent, but he could not completely return to the past. The most terrible thing is fear. "This is not a question of whether we can continue the game, but that we almost can’t live a normal life." In the Beijing Winter Olympics, he became a technical official in Zhangjiakou Division, and went up the mountain to maintain the snow trail at 5 am every day. He witnessed many athletes younger than him win medals. When Su Yiming won the silver, he was at the scene, "very envious".
During the Beijing Winter Olympics, Qi Tianyi watched the game on the screen. He called those athletes who got along with each other day and night and brought them back to health personally "biological athletes". During the athletes’ rehabilitation training, they spend all the time together except sleeping.
They didn’t talk about their fear of injury, but Qi Tianyi could see it from their reaction. For example, resisting training and not wanting to leave the room. In the face of pain, some people don’t understand and doubt at first, and keep thinking "why are you hurt"; Then there is sadness and depression; Finally, some people began to rebuild their confidence and know "what should I do now?"
In January, Jiang Tao was at Beijing Nanshan Ski Resort. Photo courtesy of respondents
In the amateur skiing circle outside the competitive sports field, some people are still "dead" with injuries. Jiang Tao, a 49-year-old skier, has experienced muscle fracture, brachial plexus injury, concussion and shoulder glenoid lip tear. He always felt that 80% of the injuries could be avoided. "Most injuries are caused by doing things beyond your ability, recklessness, or sheer ignorance."
After 10 years of skiing, Jiang Tao knows more and more about his body. He always keeps an ice pack at home, and every time he goes skiing, he will ice his joints. He found that "people’s feelings about their bodies are very subtle". Jiang Tao regards injuries as part of skiing. Due to the right brachial plexus injury, his right arm is only half as strong as his left arm. It took him half a year to recover. At first, he couldn’t hold chopsticks, brush his teeth and take care of himself. But he doesn’t feel that these injuries have cost him anything. Because he likes skiing, he accepted these pains and disabilities together.
He learned to get along with his fears. Every time I come back to the snowy road after recovery, I always have the shadow of injury in my heart. With this kind of fear, the action will not be done well. But you know that fear and anxiety will pass. He gradually "accepted it". When this action is repeated for the second time and the third time, and he can land smoothly, he will know that the hurdle in his heart has slowly passed.
He figured out the reason for his injury: once he made a breakthrough, he would fall into excitement, "thinking that he is very powerful and wants to be a better one." This time, you will often get hurt. He observed the training of professional ski teams, and after one action was made twice, the coach would ask the athletes to stop and practice for other actions. He gradually realized that in sports, he should also be restrained and sober. Now when skiing, he often says to his companions, "You remind me not to get excited."
On February 28, I was in the noble of rehabilitation training. Photo courtesy of respondents
As a friend and rehabilitation therapist of Jiang Tao, Qi Tianyi was very pleased to see that he would protect himself more and more. For novice skiers, Qi Tianyi told them to be "ready to go again". This is the famous saying of Raymond Li, a famous sports rehabilitation teacher. Ordinary people want to ski, first of all, they should have sufficient physical reserves, and secondly, they should warm up for about 15-20 minutes. After warm-up, the choice of equipment is also very important. When skiing, even ordinary people can easily reach a high speed of more than 50 kilometers per hour, and appropriate equipment can give people maximum protection. For example, helmets can reduce the death rate of concussion by 60%.
Qi Tianyi also saw that even though the injury brought great pain to people, many people regarded rehabilitation as a new turning point in their lives. Some patients went to the University of Southern California to study for a degree in rehabilitation after undergoing rehabilitation treatment. The above-mentioned patient, who was unable to squat completely due to serious injury, did not leave the ski resort and became the owner of the ski shop, promoting scientific winter sports.
Jiang Tao, 49, is used to injuries. At first, he was injured and didn’t dare to go home. He wanted to stay in a hotel near the snow field for one night. Now his family can’t support him, but they can understand him. He can’t explain why he likes skiing. He thought, from a very young age, people were divided into two groups, one likes sliding slides and the other doesn’t. "You say why people slide, what’s the point, why do you like this? This is human nature and there is nothing to explain. "
The 19-year-old Gao feels that his sports career is still long, and he still regards the Olympic Games as his dream. He knew that someone who fell might not get up again, but he didn’t.
Zhongqingbao Zhongqingwang Trainee Reporter Guo Yujie Source: China Youth Daily
Source: China Youth Daily
Reporting/feedback

2023 Shanghai Civil Service -Summer Class Course Shiner

2023 Shanghai Civil Service Summer Class

01

Summer series

Suitable object

(1) Zero foundation, candidates who are relatively weak in Shanghai civil servants’ examinations

(2) In the preliminary examination, I hope to focus on training during the summer vacation to quickly improve the ability to take the test

(3) Xiaobai, candidates who are committed to the post of civil servants for freshmen

(4) Candidates who need to follow, guide, and urge the test ability to improve the ability to improve the ability to improve

Form of class

Famous teachers of Huazhi, concentrated training, face -to -face teaching, classroom interaction, and on -site questioning and services to make students experience better.

Series features/highlights

· Scientific planning

Make full use of the summer time to reasonably plan courses, and choose courses scientifically to maximize the effect of learning in a limited time.

Construction framework

Understand the essence and answer methods of each type of question, establish a complete knowledge system, and avoid moving hard.

· Comb

Reading, careful investigation, and comparison of outlines, carry out key knowledge, conduct carpet -style review, and fully familiarize with the test content.

·Filling in the gaps

Help students find vulnerabilities or symptoms, provide targeted suggestions, and timely check the leakage.

· Focus on refining

Grasp the "key points", break each, make full use of the summer follow -up learning, and establish a diversified knowledge system.

· Consolidate review

Strengthen the exercise simulation questions, real questions, and prediction questions, and consolidate the content of what they have learned.

02

Weekend series

Suitable object

(1) Candidates who are weaker in Shanghai Civil Service Examination

(2) In the preliminary examination, candidates who have not learned much about the Shanghai civil servant exam

(3) Candidates who want the system to review and improve a comprehensive improvement

(4) Candidates who need to write a full -process system for writing or interviews, and hope that candidates who have bonuses and protocol guarantees

(5) Students who need to follow, guide, and urge the test ability to improve the ability to improve the test.

Form of class

Opposite the offline: Facing teaching, classroom interaction, questioning and services on the spot, making students experience better.

Series features/highlights

Learn through

Offline Huazhi senior teachers have taught the skills and strategies of admitting the skills and strategies to learn the theoretical skills and lay a solid foundation.

· Practice

Provide a sufficient quantity to preserve questions, consolidate high after class, and practice the questions.

Test

Simulation simulation exams, you can practice, calm, and stable test room mentality.

· Separate teaching

Basic-Title Sea-Sprint-Interview, Stage Learning, layer up, strength prediction.

· Science learning

Consolidate the basic mastery method+sprint knowledge large combing+pre -test training.

· Answer

Follow -up questions, questions and answers, questioning questions, questioning of classrooms, questioning after class, assignment questions, all efficiency guarantee within 24 hours;

Chief

Huazhi senior teachers have been taught in person to help learn more.

King of Find more than VLOOKUP, do you know for CP functions?

During our daily tabulation, it is often used.Find the work of reference related data.

In fact, this is also one of most small partners in touch.

For example, according to the corresponding results of the employee name, according to the number of item numbers in one item, the corresponding sales, etc.

Today, I will introduce you to a very powerful function combination to achieve this feature.

They are INDEX + MATCH combination.

The specific application scenario is as follows:

01 正 正 查

The correct point here is:Find reference target values ??from left to right.

That is, the lookup value is on the left and the return value is on the right.

As shown below, it is the performance watch of the company employee in the first quarter. We now want to find the corresponding performance according to the name.

Write the following formula in [F2] cell:

=INDEX (C2: C7, Match (E2, B2: B7, 0)))

Formula analysis:

First look up Liu Yan in the [B2: B7] in the [B2: B7], return to the number 2;

This number 2 is then used as the second parameter of the index function, meaning returning to the value of the first parameter in the cell area in the cell area in the cell region.

There are three parameters: Match functions:

Match (lookup value, find area, lookup type)

The MATCH function is specifically used to find a value, where you are in a region or group, and return a number.

This number that is usually returned as a parameter of other functions.

Here, the returned numbers are used as the parameter of INDEX.

If the lookup type of the third parameter is 0, it means an exact lookup.

INDEX usually has three parameters:

Index (Returned area, line number, list number)

Since the first parameter is a single line or a single column, the third parameter can be omitted.

If you don’t illegally, the formula can be written as this:

=INDEX (C2: C7, Match (E2, B2: B7, 0), 1)

02 reverse lookup

The reverse refer to it here is:Find reference target values ??from right to left.

That is, the lookup value is on the right, the return value is on the left.

Also as examples above, for example, we want to find Liu Yan’s employee number.

The formula is as follows:

=INDEX (A2: A7, MATCH (E2, B2: B7, 0)))

Formula analysis:

The formula of this formula is similar to the formula of the forward look, but the first parameter of the index function will change the returned area into the [A2: A7] area.

It can be seen that whether it is looking for a look, it is the same.

Just change the area of ??the first parameter of the index function into the area that needs to return.

03 two-way lookup

The two-way refers herein is:Find the reference target value from the horizontal and vertical two directions.

As shown below: It is a quarter employee payment message, and now I need to find how much Liu Yan’s salary in March is.

The formula is as follows:

=INDEX (B3: D8, Match (G3, A3: A8, 0), Match (H2, B2: D2, 0))

Formula analysis:

First look up Liu Yan in [A3: A8] in the vertical position in [A3: A8], return to the number 2;

Then use the second Match function to find the horizontal position in [B2: D2] in this area, return to the number 3;

Finally, the two numbers are respectively used as the second and third parameters of the INDEX function, meaning returning to the INDEX first parameter [B3: D8] zone "Chapter 3 of the third row in the area of ??this intersection cell, namely: 8606.

Because the two-way lookups here need to involve the position in both directions, we are hereUse two MATCH functions to locate the lines and columns.

04 more conditions

Multi-conditional lookup refers to: Find back to the corresponding target value based on 2 or more conditions, which is often used in our daily work.

As shown below: It is a sales list of all item numbers in all regions. We want to find how much the number of item numbers BH003 in Nanjing is.

Condition 1: Nanjing;

Conditions 2: The item number is BH003.

Write the following formula in the [G2] cell:

=INDEX (C2: C7, Match (E2 & F2, A2: A7 & B2: B7, 0))

Formula analysis:

The basic frame of the formula is the same as above, just first connect two conditions into a new condition form with a "&" text connection;

Then follow the ideas looking forward to the looks to the lookup and return to the sales volume in the [C2: C7] area.

Match function Find the location of "Nanjing BH003" in the newly generated array:

Match ("Nanjing BH003", 0)

Returns the number 3, then this number 3, as the second parameter of the index function, means returning the INDEX first parameter [C2: C7] The value in the cell in the cell area, that is, 72.

?

Because this is an array formula, the formula needs to be ended in the [Ctrl + Shift + Enter] three key. The braces outside the formula will be automatically generated. For small friends who use Office 365, you can end up with a three-key.

Of course, the multi-conditional lookups here can also be applied at both horizontal and vertical two directions.

In addition, no matter how many conditions, just connect multiple conditions to a new condition with a "&" text connector first, then apply the above routine.

05 interval lookup

The interval lookup refers to:If the lookup value is in a certain range, the corresponding target value is returned.

As shown below, the number of bonuses from the employee is required according to the performance interval.

Write the following formula in the [G2] cell:

=INDEX (J2: J5, Match (F2, {0; 41; 81; 121}, 1)))

Formula analysis:

This formula is especially the application of the second and third parameters of the MATCH function.

If the third parameter is 1 or omitted, the MATCH function will look for the maximum of less than or equal to the first parameter, andThe value in the second parameter must be sorted in ascending order.

The maximum value of less than 65 is 41, 41 in this constant array ({0; 41; 81; 121}) is 2, that is, the number 2 is returned to the number 2, and then the index second parameter is finally returned 2000.

Of course, here we can also write this constant number in an auxiliary column, which may be better understood.

As shown below:

06 blurry look

The fuzzy look is to realize the target value by combining with the wildcard ("?" Question mark and "*" asterisk).

As shown below: We want to find a surname Xu to open his head, and how much is the employee number of three characters.

The formula is as follows:

=Index (A2: A7, Match (E2 & "", B2: B7, 0))

Formula analysis:

Here is the key to the Match function supports the usage of wildcard.

Everyone must pay attention to:

"?" Question mark wildcard, represent any single character.

"*" Asterisk wildcard, represents any number of characters.

Here we used two "??" question marks, represent any two characters.

07 summary

Today, we have learned two powerful function combinations (INDEX + MATCH)Six kinds of findings commonly used in work:

? Positive lookup;

? Anti-(reverse) lookup;

? Two-way lookup;

Multi-conditional lookup;

Area lookup;

? Fuzzy lookup.

What is the most look for you usually use? What do you have any questions about VLOOKUP?

Welcome to usmessageOh ~