南京新茶外卖论坛

Five group honors with the highest gold content in the football world.

Fifth place, five major league champions. Including Premier League champions, La Liga champions, Bundesliga champions, Serie A champions and French champions. The Premier League is the hardest to win in recent ten years, but it doesn’t mean that the winning team is the strongest, such as leicester city in the 15-16 season. La Liga, however, has the highest level of technical flow. No matter whether it is Real Madrid or Barcelona or even Atletico Madrid, it has the strength to compete for the Champions League before, so it was crowned as the top three in the Western Conference. The three teams also won all La Liga titles in the past 20 years. The last time other teams won the prize dates back to Valencia in 2004. The Bundesliga is the most stable, Bayern has won 11 consecutive championships, Ligue 1 and Serie A Om Tang Nuo, but the attention is slightly lower. Messi and Robben won the most prizes in the five major league titles, with 11 seats. Messi’s 12 seats should not be a big problem. It is worth mentioning that Cristiano Ronaldo wants seven seats.

Fourth place, champion of the America’s Cup, Europe and South America are the two best places for football on earth, and America has no weaknesses. This is also a fact. Many people will say that the America’s Cup has been held too many times, so it has no gold content. This is a misunderstanding, and it may be a double standard. First of all, every year in the Champions League, some people think that the gold content is the highest. There is one more America’s Cup, but it has been devalued by some people. What can it be if it is not a double standard? Secondly, there are not many America’s Cup. It will be held normally in 2015, and the centennial America’s Cup in 2016 will be held normally in 2019. In order to keep pace with the European Cup, 2023 will be held in 2021 in advance. Apart from the centennial America’s Cup, the math football teacher doesn’t know much. As for the level, there is not much difference with the European Cup. Anyway, there are often dark horses killed halfway and finally won the championship. Italy, the former European Cup champion, was swept 3-0 by Argentina, the America’s Cup champion, and it can also be seen that this is the case. Normal people know that.

Third place, the Champions League trophy. It’s too big to be a cup, and the level of competition in the Champions League is very high. If it’s hard to say, it must be difficult. It’s hard to win the championship for the teams in the five major leagues and other European leagues. Many teams even qualify for the competition. But it’s simple to say, as long as you are in the giants and the various fronts are extremely luxurious, anyway, the Champions League will be held every year, and you will come back next year if you don’t win this year. For a team like Real Madrid, it’s like cutting leeks. It’s not who is strong, but everyone is strong and profound. Ten people with a giant baby can win the championship. Besides, everyone is at the top level, so if you want to win the Champions League, the platform is very important. Many people have never worked hard for a lifetime, such as Luo, but some people are lucky to stay in Real Madrid and run cups every year. In fact, leaving Real Madrid is just like that. Like Ramos and Pepe. Heng Tuo is the player who has won the Champions League the most times, with a total of six times. No one has ever come before and touched porcelain. Of course, the gold content of the Champions League can also rank third. After all, the economic level is there, but it must be said that the highest is indeed kilometers away. Otherwise, the wind support of the six Champions League has long been the first in history, which is as funny and timid as James thinking that he is the leader when he wins a championship.

Second place, European Cup. The European Cup is the second largest event in sports, but it is not necessarily how high the level of competition can be and how horrible the difficulty of winning the championship can be. Otherwise, it will not always be a dark horse, the third place in the group will not be able to win the championship, and the European and American Super Cup will not be defeated by the America’s Cup. However, its influence and commercial value are really good, and its gold content ranks second, which is barely enough.

The first place, of course, is the World Cup. It is almost impossible to eat grapes to say that the World Cup has no gold content. Under the background of sour grapes and the hopeless resurrection of Mu Rongfu, first of all, the World Cup is held every four years. How many four years can a person have in his life? Besides, athletes have not yet. Those who have participated in six World Cups and participated in more than a dozen competitions in the Champions League. Secondly, is the World Cup really just for 32 teams to play for a month? The top 32 players who can enter the finals are all kicked in from the qualifiers, and no one has the privilege except the host. For example, the top 40 players in Asia need to play in groups first, and the top 12 players will be decided, and then the top 12 players will play in groups to decide four and a half places. This round trip involves all teams in almost all countries and regions in the world, and it will take three or four years, but it is really funny that some people say that there is no gold content. Finally, everyone who knows football knows that only one athlete can be as full of energy and go all out as playing the World Cup in other events, and all teams on the World Cup stage, even if their strength is weak, can burst into amazing fighting capacity. As for the influence of the World Cup, needless to say, it may be second only to the Riyadh victory in the Saudi Super League.

A paradox lies before Mourinho.

Is Rome useless or useless? In March, halfway through the Devil’s schedule, Mourinho is worried about a long list of injuries. At present, there are important players absent from the third-line positions except the goalkeeper. The media are talking about the need for Rome to make a rotation, but this is Mourinho’s embarrassment.

Rotation. Who? Take the midfield as an example. I’m afraid Marty Camara himself can’t remember the last time he played. Mourinho would rather let Cristante and Ma Diqi fight repeatedly than send him to play. Even the teenager Tasirovich has temporarily replaced him, while Camara has almost disappeared. Some media rumors that he is injured, but since 2023, he has been healthy enough to enter the big list and sit on the bench. Some critics say that Rome will use him only if it is necessary, mainly because he is worried that his appearances will be full.

Not only Camara, but also young players such as volpato and Tacirovich, who had been highly anticipated by Mourinho, have lost their chances in the standing list after a period of tempering. Young Beauvais was once in Mourinho’s plan, but he still couldn’t play the main role after the game was tempered. Rome had hoped to use him and volpato as additions to the purchase of Fratesi during the winter transfer.

Also gradually disappearing in the starting lineup is celik, the winner of the bid. celik has not played in four games since he came out after Rome defeated Verona’s substitute Solbakken 1-0 on February 20th. Some media have analyzed that the confidence of Turks has been affected since the goal against cremona, and the strong comeback of Karsdorp and the rapid growth of Zalewski have compressed the space of celik.

Of course, for coach Jose Mourinho, he is more aware of different tactics and player arrangements for different opponents, just like when he played against Real Society, he used Karsdorp accurately, which inspired the fighting spirit and energy of the Dutch. Similarly, Camara, Tasirovich and celik do not mean that they have been completely abandoned. They can only play when Mourinho thinks fit. In the past, many media questioned that Mourinho often went his own way and didn’t know how to rotate. In fact, Rome suffered from rotation at many times this season. In the two games against cremona, it happened that Mourinho tried to rotate, and the result was without exception.

This is also Mourinho’s embarrassment, rotation? Losing, not rotating? Lack of physical strength may lose the game. In desperation, he had to give up his own ban, so as to encourage and infect the only main lineup, and let them believe that they have the ability to conquer everything and believe in the strength of team and blood. However, his inner helplessness has long been revealed. At the press conference after the Europa League match, he envied Bayern’s substitute lineup and said that even if those people only gave him one player, it would be good. This is also his difficulty to some extent. In Rome, it is not that no one is available. The real problem is that some people are really useless.

Of course, this is not all the expenses that Zhu Ting needs to deduct. Zhu Ting also needs to pay 1.5%-3% of the agent fees and some miscellaneous expenses of the players’ union. Moreover, because of the talent cultivation, Zhu Ting also needs to pay part of the salary to the Henan mother team. After a full calculation, Zhu Ting’s 1.2 million euros will actually be deducted by nearly 50%, which means that Zhu Ting actually gets 600,000 euros (equivalent to about RMB 4.2 million). But now Zhu Ting obviously doesn’t care about this. To tell the truth, if she wants to make money, Zhu Ting will stay in China. Her annual salary is at least over $1 million, and her income is more than that of studying abroad. Moreover, at home, Zhu Ting has more time to attend business activities, which is also a large amount of income. But for 28-year-old Zhu Ting, she deserves her last chance to fight for her dream. Zhu Ting also knows that if she wants to lead the China women’s volleyball team out of the trough, she must become.

At present, the Chengdu World Table Tennis Championships, which has attracted the attention of table tennis fans all over the world, has decided the final king. China Guoping, the king of the world table tennis world, won the championship of men’s team and women’s team without accident. This result is also the embodiment of Guoping’s top strength. However, although the champion belongs to Guoping, for some defeated players of Guoping, they have to find something else to show their unconvinced. No, Japanese table tennis, which has been suppressed by national table tennis, came back to China, and the Japanese media released a list of male table tennis players in the World Table Tennis Championships. Funny thing is, in this list, Malone, who won all seven games in the World Table Tennis Championships, was directly ranked fourth. At present, Fan Zhendong, which ranks first in the world, is directly ignored by the Japanese media, and can’t even enter the top five. As for the number one player, I believe you should have guessed it.

Chengdu World Table Tennis Championships, as a major competition this season, almost all the top table tennis players in the world came to Chengdu to participate in this table tennis feast. As the host country and the top table tennis team in the world, Guoping is naturally the favorite of the champion. However, neither the men’s team nor the women’s team let the fans down. In their own home court, Guoping won two championships in a sweeping way. Of course, compared with the women’s team, there are still some waves in the men’s team’s championship.

In the semi-final with the Japanese men’s team, the China men’s team encountered the biggest challenge since the start of the game. Japan’s first brother, Chinese-American Zhang Benzhi, is in very good shape in this World Table Tennis Championships, especially in this Sino-Japanese table tennis semi-final. In order to test Wang Chuqin, the national table tennis coaching staff arranged for Wang Chuqin to serve as the second single against Zhang Benzhihe. Wang Chuqin, like Zhang Benzhihe, is a post-00 player, which can also be regarded as a confrontation between new forces in the future table tennis world. But what I didn’t expect was that Wang Chuqin lost completely in this post-00 showdown.

If Wang Chuqin’s loss is understandable, then the number one player in the world, the key player of China team, the loss of a single Fan Zhendong made the fans feel nervous. In the face of Zhang Benzhihe, Fan Zhendong lost his former swagger and was defeated by Zhang Benzhihe. In the end, although Guoping still relied on its overall strength, it eliminated the Japanese team and advanced to the final. However, this five-game game still made many fans sigh: Fortunately, there is only one Japanese team, Zhang Benzhi and He.

It was Zhang Benzhihe’s performance that completely stunned the Japanese media after the game. After the World Table Tennis Championships, the Japanese media "Tokyo Satellite TV" produced a ranking of men’s table tennis strength in the World Table Tennis Championships. To tell you the truth, this ranking is a bit interesting. He is convinced of the players’ victory in the World Table Tennis Championships as a basis for ranking. In other words, whoever wins more games will be in the top position. That’s right, there is such a funny situation. No one of the main players in table tennis can enter the top three. After all, the seven wins of seven battles, which are as strong as Malone’s, can only be ranked fourth because of too few wins. Fan Zhendong, the number one in the world, can’t even get into the top five in this ranking.

Not surprisingly, in this ranking, the number one player in Japan’s team is naturally Zhang Benzhi and He. He ranked first with 11 wins and 1 loss, and was called the strongest men’s singles player in this World Table Tennis Championships. The second place is Huang Zhen Ting, a Hong Kong player from China who scored 8 wins and 3 losses. The third place is Qiu Dang from Germany, whose record is 8 wins and 4 losses.

To be honest, this ranking is totally unreasonable. After all, because of the strength of national table tennis, all the five main players have strong strength, basically taking turns to play. In this way, Malone’s chances of playing will naturally be less. However, Malone only played seven games, but he won all. Just because he played a few games less than Zhang Benzhi, is he weaker than Zhang Benzhi in strength? It can only be said that this is just the self-satisfaction of the Japanese media, which specially found an angle that is beneficial to Japanese players to make such a ranking. However, it is difficult for them to think of such an angle.

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 ~