sdsadas

On October 16th, Beijing time, according to the latest report of the NBA’s famous Woshen, Golden State Warriors reached a contract renewal agreement with Poole and Wiggins at the same time. Poole signed a four-year contract of $140 million, while Wiggins significantly reduced his salary and signed a four-year contract of $109 million. Golden State Warriors spent $249 million to keep Poole and Wiggins at the same time, which is undoubtedly a huge surprise for Golden State Warriors’ road to championship in the next few years!

After the news of the famous God Woshen broke the news, according to several ESPN sources, Golden State Warriors and Jordan Poole formally reached a four-year and $140 million early contract renewal agreement. The guaranteed amount of the contract is USD 123 million, with an incentive clause. After the incentive clause is completed, the contract amount can be expanded to 140 million.

Jordan Poole was selected by Golden State Warriors with the 28th overall pick in the first round of the 2019 draft, and then signed a four-year, $10.09 million rookie contract with the Warriors. At present, there is one year left in the rookie contract, which is worth $3.9 million. The new contract will not take effect until the 2023-24 season. 2? In the 2001-22 regular season, Poole played 30 minutes per game with 18.5 points, 3.4 rebounds, 4 assists and 0.8 steals. In the playoffs, he played 27.5 minutes per game with 17.0 points, 2.8 rebounds, 3.8 assists and 0.8 steals.

Subsequently, the American media StatMuse exposed a set of data, ranking the top six in the average annual salary of 2019 rookie’s early contract renewal, and Morant, Zion and Garland’s average annual salary was $38.86 million, which tied for the top three. Poole’s average annual salary after renewal is as high as $35 million, ranking fourth, followed by Hiro’s average annual salary of $30 million and Barrett’s average annual salary of $26.79 million.

At the same time, after Poole’s 4-year contract extension of $140 million, Golden State Warriors will have four players with annual salary exceeding $28 million in 2023-24 season, and these four players are rookies cultivated by Golden State Warriors themselves: Curry’s annual salary is $52 million, Clay’s annual salary is $43 million, Poole’s annual salary is $35 million, and Chasing Dreams Green’s annual salary is $28 million. The success rate of rookie like Golden State can be said to be the only one in the league.

In addition, according to the famous story of God Wo, Golden State Warriors renewed their contract with All-Star Wiggins for four years, with a contract value of 109 million dollars. Wiggins will be tied with Golden State Warriors for five years, with a total contract value of 143 million dollars. Mouth Wiggins earned $33.6 million this season. The salary of the new contract will be reduced to $24.3 million in the first year and $26.3 million in the second year. Golden State Warriors gave Mouth Wiggins the option in the last year.

Kou Wiggins was the No.1 draft pick in 2014. On the day he was selected, he was traded to Timberwolves by Cavaliers. He stayed there for six years until he was traded to Golden State Warriors in 2020. In the 2021-22 season, Wiggins played the masterpiece of his career, averaging 17.2 points, 4.5 rebounds and 2.2 assists per game. He was selected as an NBA All-Star for the first time.

Wiggins’ performance in the playoffs was even more amazing, averaging 16.5 points, 7.5 rebounds and 1.8 assists per game, with a shooting percentage of 46.9%, a 3-point shooting percentage of 33.3% and a free throw percentage of 64.6%. His performance was comprehensive and stable. Wiggins’ total positive and negative value in the playoffs is as high as +140, which is superior to all playoff players, even higher than Curry, ranking first in the league!

After learning that Poole renewed the Golden State Warriors for $140 million in four years, many experts and fans thought Wiggins would leave, but Wiggins chose to reduce his salary by nearly $10 million a year and renew the Golden State Warriors. We have to sigh, Wiggins is sure to be true love to Golden State Warriors, but Golden State Warriors are like many media descriptions to Wiggins, like breaking a bone and getting a big bargain!

In the past season, Poole and Wiggins both played the most time in Golden State Warriors, Wiggins played 2,329 minutes, Poole played 2,283 minutes, which shows their importance to Golden State Warriors. Golden State Warriors stayed with $249 million. Wiggins, 27, and Poole, 23, when Curry, Clay, and Dream Chasing are all getting old, the successors of Golden State Warriors, have quietly taken their place.

The Golden State Warriors dropped $249 million and renewed Poole and Wiggins at the same time. We also have to admire the courage of Lakob, the owner of Golden State Warriors. Because, according to the analysis of salary expert Bobby Marks, if Dream Pursuit chooses to implement the option of 27.6 million players in 23-24 season, the total salary of 12 players in Golden State Warriors in 23-24 season will reach 215 million, and the luxury tax will reach 268 million, totaling 483 million. Once there are 14 full players, the total salary and luxury tax will probably exceed 500 million dollars.

Marcus Thompson II, the team reporter of Golden State, published the salary details of Golden State Warriors in the 23-24 season, which confirmed the above statement: Curry 51.9 million, Clay 43.2 million, Poole 28 million (estimated), dream-chasing: 27.6 million (if the player option is implemented), Wiggins 24.3 million, Wiseman 12.1 million, Rooney 7.5 million and Kuminga 60.

If the 14-member roster is completed, the luxury tax that Golden State Warriors will have to pay in 2023-2024 will exceed $275 million, which is higher than the combined salaries of Knicks and Grizzlies this year. As we all know, Lakob, the owner of Golden State Warriors, only spent 450 million dollars when he acquired Golden State Warriors in 2010. The total salary next year will exceed the total value of the team that year. Lakob is really rich and willful!

After renewing Poole and Wiggins at the same time, the salary space of Golden State Warriors can be said to be an unprecedented explosion! What about the next dream catcher Green who is facing a contract renewal? Referring to the first year after the renewal of the contract, the annual salary of Brother Wilkins will be reduced to 24.3 million USD. Dreamcatcher Green must reduce his salary if he wants to stay in Golden State for a long time!

I have always wanted to buy a tablet to chase the vetera, occasionally write a note.Recently, I have to buy a netizen explosive struggle to spend more than 10 billion subsidies. Small pαd 11 inch is 862 yuan, and it is inevitable.

But all the e-products have been purchased in Jingdong, and there are very few a lot of water.But this time I rushed on this low price, I would like to turn over the seller’s various comments, and I found that comments can be.I want to try it.

The order was sent on the third day.Is SF!

The packaging is slightly thin.

Back display configuration

charger

Boot

Clear.Try to put a look of love

It is particularly clear, it is 2K, and the sound quality can also be.Try to install a few applications, very smooth!

Overall, I feel that it is not bad.It seems that I still haven’t turned it!After all, there is a hundred oceans, it is also more satisfied!

What is worth buying app all net shop shopping prices

After the mobile phone market has been shuffled, it is already a game of giants. The share of major manufacturers is relatively stable. The market continues to force, and the online market has also launched a sub-brand to deal with, for example, there is no price-effective Vivo, IQOO has a strong good hand, from the entry to the high end, there are different gear products, such as the iQOO Z5, the author, the author saw it has 1439 yuan "true price", still worth it Purchase.

As an entry product, iQOO Z5 is very good, equipped with the Snapdragon 778G processor, supplemented by LPPDR5 + UFS3.1, and therefore called "full blood version", performance is more than other divo dragons 778G, Especially when the game and big file read / write speed, when installing the download app, there will be a certain advantage, using a 6.67-inch LCD screen, support 120Hz refresh rate, support DC dimming and Rhine TUV low blue-ray certification, show the effect in the overall size.

The battery life is also the selling point of the machine, built-in 5000mAh big battery, does not play games, one day can not be a problem, 44W flash charge can meet the needs of users, the back is 64 million + 8 million +2 million pixels Support 10x digital zoom, up to 4K video recording, although than many high-end flagships, but in the thousand-yuan machine, the Z-axis motor and stereo donkey blessing, also make it a good audio and video experience .

In terms of appearance, IQOO Z5 is a hidden opening screen, and the COF package has made it a lot of width in the chin, so it looks very coordinated, the back camera is a common rectangular module, but the three color matching have their own craft, "blue The origin of the origin is heavier, "Boli Chen" is not easy to contaminate the fingerprint, and "dream space" is more interested, similar to the design of the Roman column, so that the entire rear cover has three-dimensional, with a certain gradient treatment, The value is quite high.

Overall, the ethnographic performance on the market is good, and the major manufacturers have a model worth considering. It is like a red rice with Note10 Pro this all-round player, and there is a 120W fast charge like Note11 Pro +, OPPO home Realme There are also several real sauce machines, of course, comprehensive price, configuration, appearance, I still prefer iQOO Z5, third-party platforms, only 1400 yuan, more than 400 yuan than official channels, everyone thinks cost-effective, welcome to messages.

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 ~