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 ~