Why does life have to read history?

Beijing Daily Client | Author Han Sheng

History inspires wisdom. Wisdom is based on the understanding and comprehension level of human nature, things and truth.

Understanding of people

People’s social attributes determine that people have to deal with each other all the time. Therefore, knowing people is an important aspect of being in the world. High-level leaders need to know people better.

Han Xin, the genius commander who helped Emperor Gaozu Liu Bang conquer the world, paid special attention to the analysis and grasp of people. After the hongmen banquet, liu bang was sent to hanzhong, and Han Xin was appointed as the general to command the army under the strong recommendation of Xiao He and others. Liu Bang summoned Han Xin to analyze the odds of fighting against Xiang Yu. Han Xin, who is about to go to war, did not analyze the military issues such as the strength of the two sides, but directly asked Liu Bang to compare the qualities of the top leaders of both sides, and proposed that the top leaders should meet the four indicators of "courage, toughness, benevolence and strength". Therefore, Han Xin pays more attention to the leader’s character accomplishment than the obvious material conditions. Based on this, Han Xin thinks that Liu Bang can be a leader. At that time, when the strength between the enemy and the enemy was wide, this was simply an unexpected inference.

What is the basis of Han Xin? He noticed Xiang Yu’s aristocratic background. Nobles are "expensive" because they are knowledgeable, educated and humble, which is the same at all times and in all countries. This is the spirit of "expensive" and the characteristic of Xiang Yu. Although he is all-powerful on the battlefield, a thousand people are invincible with a roar, but he is gentle and polite to people. Everyone can see the advantages of Xiang Yu, but few people can see the other side of his personality, that is, he is too "cherishing things." Xiang Yu’s inheritance was laid down by himself, which was hard-won and cherished. Therefore, he was reluctant to divide people and was not atmospheric enough. When he won the award, he always put the reward in his hand and weighed it repeatedly. At the end of the award, it was quite different from the expectations of his subordinates and caused dissatisfaction. In the long run, the more men fight, the more boring they will be, and they will leave Germany. This is the fate of Xiang Yu, who can’t unite people closely. Therefore, he will go into decline. On the contrary, Liu Bang started from scratch and made some gains by the efforts of all. These things are not his own savings, so he knows very well that things are done by everyone, and things are divided by everyone. After the division, people are excited and can do even more next time. Therefore, the team will become more and more brave, and talents from all over the world will come in an endless stream. Xiang Yu and Liu Bang have different ways to analyze and deal with problems, so Liu Bang will eventually win. Han Xin’s analysis was incisive and fully proved in the Chu-Han War. Han Xin understood the truth that "the world belongs to the world" from the perspective of human nature, and anyone who wants to take it for himself will be spurned.

In human society, knowing people’s wisdom is the first thing to learn, and knowing people can do things.But this is only one dimension. Can it be invincible only by popularity?

Or Han Xin. When he led an army across half of China in the north and arrived in Shandong today, a strategist named Kuai Tong came to visit and asked him why he was struggling with Xiang Yu. Kuai Tong analyzed the world situation and thought that three armed groups, Liu Bang, Xiang Yu and Han Xin, had been formed at that time. Although Han Xin was a subordinate of Liu Bang, his prominent position depended on the existence of Xiang Yu. Therefore, Kuai Tong advised Han Xin to let Xiang Yu go, so as to promote a tripartite confrontation and ensure his own safety and interests. However, Han Xin explicitly refused, because he read Liu Bang’s kindness of "driving me with his car, clothing me with his clothes, and eating me with his food", and he could not betray Li Yi. Obviously, Han Xin always believed in judging people, so as to defeat all his military opponents, and extended it to the political field, trusting Liu Bang and his "righteousness", showing his political naivety. Most of the problems that military strategists think about are local plane dimensions at that time, while politicians are much more complicated and profound. They are not at the same level, so military strategists are often no match for politicians. As a bystander of political strategists, Kuai Tong saw this clearly, while Han Xin didn’t realize that he was just a soldier, and Liu Bangze was going to be a soldier until Liu Bang deprived him of the King of Qi after the Battle of Gaixia, and even later he was stripped of the packet of the King of Chu and relegated to the vacant position of the imperial court, but it was too late. A general is a strategist who does things, while a general is a politician who commands the overall situation.

From Han Xin, we can see the limitations of being confined to knowing people. People are fickle, the most difficult to grasp, and those who want to be independent of the world just by looking at people will eventually be defeated by others. One-sided people are prone to paranoia, and will fall into the mire of rule by man, making it difficult to achieve great things.

A clear understanding and prediction of the situation

Situation analysis is a comprehensive judgment on physical geography, social sentiment, strength growth and decline and other factors. Su Qin’s analysis of the situation between the six countries and Qin in the Warring States Period is a classic.

After Shang Yang’s political reform, Qin’s military strength increased greatly, and it was militaristic and constantly attacked six countries. The six countries passively defended themselves and adopted the policy of forbearance and submission in succession, trying to ease the attack of Qin. Su Qin, a strategist, felt very strange. If the six countries were United, their territory would account for 4/5 of China, and manpower and material resources would also account for 4/5. Why should they yield to Qin? Concession is to fill Qin’s endless desires with limited land. Although it can be delayed for a while, it will surely die. He persuaded the six countries to unite against Qin one by one, and went to Qi, a big eastern country, to analyze the situation to the king of Qi: Qi has Mount Tai in the south, Langya in the east, Qinghe in the west and Bohai in the north, which is called a country with four blockades; The territory is vast, reaching more than 2,000 miles, with hundreds of thousands of elite soldiers, a mountain of grain, rich people, busy traffic, shoulder to shoulder, curtain-raising, sweating and high spirits. No one can compare the strength of Qi, but it makes people feel ashamed to succumb to Qin.

Su Qin’s situation analysis is based on two points: first, the mountains and rivers win; second, the human and material conditions. The former is congenital, while the latter can be changed. But all changes should be based on respecting nature and conforming to the law, that is, adapting to local conditions. Generally speaking, China or the world has only an abstract meaning. In order to survive and develop properly in China, we must first have a deep understanding of China’s natural conditions, which will form the basis of decision-making, and then consider using nature for social development. By combining nature with people, we can see many mysterious problems clearly. Su Qin was familiar with the geography of China, so he accurately pointed out the weaknesses of Qin Jun’s marching operations and the countermeasures. According to the danger of Guanzhong, the state of Qin is surrounded by mountains and waters, and it is more than self-sufficient. However, if it wants to attack the six countries far away, it must pass through the dangerous mountains, and the roads are rugged and vulnerable to attack. So why are South Korea and Wei unwilling to actively resist? Su Qin analyzed: Korea and Wei are blocking Qin’s eastward advancement, and Qin is determined to win, while Korea and Wei are resisting Qin Jun alone, and even if they win, they will suffer heavy casualties, not to mention defeat. Therefore, Korea and Wei are doing their best to resist Qin’s eastward advancement, in addition to defending the country from extinction, they are still guarding the door for the eastern countries; But if you submit to Qin, you can reduce losses and lead the disaster to the east. Su Qin revealed the key of geopolitics through the relationship between geographical situation and national interests. Therefore, even from their own interests, the eastern countries should resolutely support Korea and Wei, so as to help each other and protect themselves. If they have ulterior motives and try to lead Qin’s disaster to other countries,At most, we can only delay the time of being divided by one. When the truth was made clear, the kings of the six countries saw clearly the gains and losses, so they accepted Su Qin’s suggestion and formed a "vertical and horizontal" alliance to jointly resist Qin, which made Qin dare not covet the East for more than ten years.

Knowing people and analyzing the situation is basically based on the immediate understanding of the local area at that time, which belongs to plane thinking. People and interests change at any time, so do interpersonal or international relations. Therefore, we must understand the principle of interests, but we must never rely solely on interests. It is also inevitable that Su Qin’s "Union" alliance will collapse immediately after his death. In order to make this alliance stronger, we must have a deep understanding of the history, culture and traditions of various countries. Mutual understanding and respect are the basis for establishing an interest coordination mechanism. Many conflicts are caused by mutual ignorance or even judging each other based on self-imagination.With historical thinking, our understanding will change from plane to three-dimensional, and with depth, we will have a more important understanding, thus entering the third level.

A profound understanding of history

After Liu Bang defeated Xiang Yu, he chose Luoyang as the capital of the Western Han Dynasty. There are three main points in his basis: first, Luoyang is among the best in the world; Second, there are Zhongtiao Mountain, Xiaoshan Mountain, Xiong ‘er Mountain and Waifang Mountain in the southwest of Luoyang, with the Yellow River in the north and Chenggao in the east, which can be held; Third, the Eastern Zhou Dynasty took it as its capital and had a historical tradition. Deep down, Liu Bang still has a yearning to be on a par with the Zhou Dynasty. These three points are all reasonable from the perspective of the right place and the right time. However, the truth of a thing must match its nature and scale. If it is a small country, Luoyang has a really good terrain; However, if it is a unified central dynasty, the hinterland of the landscape package around Luoyang is too small to maneuver, which is a "death". The third is even more important. Liu (Lou), Liu Bang’s adviser, analyzed that after the founding of the Zhou Dynasty, the princes and chiefs of the Shang Dynasty and its previous generation were enfeoffed, which showed their tolerance and justice, so they won the support of all parties, and their capital was the center of all nations coming to the DPRK, basically without fortification; However, you have been fighting bloody battles for several years, and the society is full of sorrow and hatred. Therefore, the capital needs heavy defense, which is incomparable with the Zhou Dynasty. You can’t choose Luoyang with incomplete terrain as the capital. Liu Bang understood the truth and immediately made his capital in Chang ‘an, Guanzhong.

Since entering the imperial country, whether the capital is properly chosen or not is related to the rise and fall of the dynasty or even the success or failure. Xiang Yu established the Kingdom of Western Chu, with its capital in Pengcheng. This is a land of four wars, and from the perspective of being the capital, it is actually a lower domain. However, Xiang Yu ignored the history and the situation of mountains and rivers, and even cooked and killed the advisers who advised him to make his capital in Guanzhong, and went his own way. As a result, the regime of Xi Chu did not have peace for a year, and he committed suicide in Wujiang River just a few years later. Vision and pattern determine the scale and success or failure of the cause.

It is extremely important to learn to look at problems historically. History teaches us to look at problems completely and systematically and avoid fragmented thinking.When many people think about a problem, they only extract some fragments closely related to it, but don’t understand it from the whole process. People who lack historical thinking only see trees instead of forests, but they can’t see through the essence when they see problems. Based on the fragmented thinking of a specific time and space, the opinions and conclusions are often tempting to fall into the trap. Sadly, people who fail are often convinced of their one-sided views. Sima Qian lamented Xiang Yu’s death, which is a great historian’s regret for paranoid politicians.

Zhang Liang became an outstanding strategist in the early Han Dynasty because he not only knew how to judge people and understand the geographical situation of mountains and rivers, but also knew how to grasp its context from the whole process of historical development, see through the phenomenon, directly attack the essence, and analyze it from three dimensions: interest relationship, geopolitics and historical tradition, thus surpassing Su Qin and Han Xin and assisting Liu Bang in establishing a stable Han Dynasty.

Studying history is the advanced stage of life, and we go in step by step. Our life and our understanding of the whole society are gradually improving, so we must read history in life.

(The author is a professor of history at Fudan University)

Drogba celebrated his 45th birthday, and Blue Bridge won the title and helped Chelsea win 12 important trophies.

Live broadcast: On March 12th, Drogba celebrated his 45th birthday. The official Chelsea media showed a cartoon of Drogba bringing back the big ear cup for the Blues and sent birthday wishes to the legendary star.

Chelsea’s official social media wrote: "We hope you had a happy birthday."

Drogba played for the Blues twice before and after, and scored 157 goals for Chelsea in 341 games during his first time. In 2014-15, Drogba returned to Stamford Bridge and won the fourth Premier League title in his career. In addition, during his time at Chelsea, Drogba also won four FA Cup titles and three Carling Cup titles. What is important is that in 2012, Drogba helped the Blues beat Bayern and won the first Champions League trophy in the team’s history.

(Sky)

The amount involved is 53 million! Spanish prosecutors sued Barcelona for bribing referees.

According to the Spanish newspaper El Paí s reported on the 11th, on Friday, local time, Spanish prosecutors formally sued Barcelona La Liga for sports fraud and commercial corruption, involving 7.3 million euros (about 53 million yuan).

The accused included two former club presidents, Sandro Rosell and Josep Bartomeu, who were suspected of bribing former Spanish Football Association officials to gain partiality in the match.

After learning this news, Barcelona’s arch-rival Real Madrid Club immediately announced that it would hold an emergency board meeting to decide how to respond to the incident.

Laporta, current president of Barcelona.

In February this year, many Spanish media reported that Barcelona was in big trouble, and Spanish prosecutors were investigating its commercial corruption and violation of fair competition.

Sure enough, on Friday, local time, Spanish prosecutors formally sued Barcelona, accusing the latter of colluding with Jose Negreira, former vice chairman of the Spanish Football Association’s referee technical committee, involving a total amount of 7.3 million euros.

The referees’ technical committee is usually responsible for assigning referees for various competitions of the football association, selecting which referees will enforce the law in which post, and selecting referees to participate in international competitions.

Spanish "National News" report screenshot

According to the prosecution’s report, based on an oral secret agreement, two former presidents of Barcelona, Rosell and Bartomeu, remitted about 7.3 million euros to the consulting company owned by grella from 2001 to 2018, in order to seek "favoritism" in the penalty and result of the competition.

Rosell, Bartomeu and two other former Barcelona executives were charged with commercial corruption, unfair management (using partners’ money for illegal purposes) and forging business documents. Once convicted, they will go to jail.

It is worth noting that laporta, the current president of Barcelona, has not been charged. He served as the president of Barcelona from 2003 to 2010, but denied any illegal acts.

Team coach Harvey revealed in an interview that he had already communicated with laporta. "This is the responsibility of the management. He told me not to worry, we just need to focus on football."

Spain’s El Pais pointed out that this investigation originated from a tax inspection, and Negreira told the Spanish tax authorities that Barcelona paid the money in order to have a "neutral" penalty in the competition.

He also said in an interview with Spain’s radio Searle that he would never be partial to Barcelona when assigning referees. His job is just to help the club as a consultant and tell them how players should behave in the face of various referees.

Previously, Barcelona officials had a similar statement, saying that the club only paid an "external consultant" who provided them with "technical reports related to professional referees" and called it "a common practice of professional football clubs".

However, the Spanish prosecutor still considers the amount of 7.3 million euros suspicious because it is nowhere to be found in the club’s articles of association and has not been approved by the shareholders’ meeting.

The Associated Press (AP) analysis believes that it is indeed a routine operation in international football to obtain referee technical reports, and clubs can purchase or prepare relevant information from external companies.However, it is not a routine operation to provide large sums of money to insiders of Spanish referee law enforcement agencies to obtain reports.

Up to now, Barcelona Club has not issued the latest statement on this matter. However, an anonymous club executive told Reuters that the club had "anticipated" the accusation. "This is only the preliminary investigation and hypothesis of the prosecution, and the judicial investigation has just begun. The club will fully cooperate, but we have never bought any referee and never tried to influence the decision of any Football Association official. "

In response to the corruption scandal in Barcelona, the first to take action was its arch-enemy Real Madrid Club. The latter announced on the 11th that the board of directors will be held on March 12th local time.

Real Madrid fan magazine "Madridista Real" reported that the board of directors of Real Madrid may choose to "sever relations" with Barcelona Club, and may even decide to appear as a private prosecutor in future court trials.

The city’s fresh technology shares WiFi, which is a new choice for intelligent and convenient service in stores.

Founded in 2018, Wuhan Xianshi Technology Co., Ltd. is a technology-driven company. Its business segments include shared charging treasure, shared charging pile, unmanned container, life service, aggregate payment business, cloud computing and other industrial fields. With independent development capability, strong technical team, customer service team and rich experience in operation and promotion management, we are committed to the research and development of Internet technology and artificial intelligence equipment.

The city’s fresh technology sharing WiFi pays more attention to landing operation, which means that your customers are the end customers. All you have to do is push the ground, invite the merchants to settle in, and open the Wi-Fi code for the merchants (replace the Wi-Fi in the store). Paste the Wi-Fi code corresponding to the merchant according to the number of tables in the merchant’s store.

The business entry system is also divided into shares, which is quite attractive to developers or platform operators. Entering this area is completed by developers, because developers promote business entry with a share of profits.

For the platform operator, as long as the customers in the store scan the code to link WiFi successfully, you will get a profit, and this part of the profit is calculated automatically. Your profit is settled by Tencent’s traffic, and the following will form the effect of automatic operation. When others connect WiFi, you will get a profit, and the system operator will just enjoy the profit.

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 ~