Every year-end or holiday, Microsoft founder Bill Gates Bill Gates will continue their "book selection" in the traditional personal social media platforms, recommended books of the year list of books he had in mind for everyone.

Not long ago, Bill Gates once again to share with you the five books, compared with previous years of books, five book clear "Technology sense of" full, contains two great science fiction, and discuss the future development of technology books let us work together to preview it!

Klara and the Sun

– Kazuo Ishiguro

This is caused by

The Nobel Prize in Literature

Winner Kazuo Ishiguro newly published science fiction story takes place in a dystopian future,

It tells the story of the friendship between the generated artificial intelligence robot Clara with a sick little girl.

Gates Book Review – "

Power is not evil robot

Instead, they can serve as companions to accompany people. This book got me thinking, has a super intelligent robot lives will be like – we had them as a technology, or

More important things

. "

Project Hail Mary

– Andy Weir

Project Hail Mary from the "Mission to Mars" The Marsian author Andy Weir (Andy Weir) hand, and "Mission to Mars" This book also appeared in the 2020 Bill Gates

Summer reading list

superior. It tells the story of a high school science teacher awoke to find himself in another galaxy,

Also take up the task of lifting the earth crisis.

Gates Book Review – "The story is about how he uses science and engineering to

save the world

. This book is very interesting, I’ll read it all weekend. "

Hamnet

– Maggie O’Farrell

This year, Bill Gates is recommended only a single book

Historical novel

The author wrote it with a fictional way how sad tear a family, explain how Shakespeare was writing his sorrow into power.

Gates Book Review – "If you’re a fan of Shakespeare, you’ll love this touching novel,

It tells the story of Shakespeare’s personal life affect the creation of one of his most famous plays.

"

A

Thousand Brains: A New Theory of Intelligence

– Jeff Hawkins

From technology entrepreneurs Hawkins (Jeff Hawkins) this book

More superficial

Way to introduce the sophisticated mode of operation of the human cerebral cortex,

More imagination and provides clues for the future of machine learning and artificial intelligence.

Gates Book Review – "Hawkins identity may be best known for co-inventor of the PalmPilot, but he spent a few years time to study

Neuroscience and machine learning

The link between this book is the best introduction to his thought. "

The Code Breaker: Jennifer Doudna, Gene Editing, and the Future of the Human Race

– Walter Isaacson

It was awarded in 2020

Nobel Prize in Chemistry

Jennifer Doudna biography of the story,

She was "God scalpel said," the CRISPR gene editing technology has attracted attention.

Gates Book Review – "CRISPR gene editing system over the past decade

Coolest, perhaps most importantly,

One scientific breakthroughs. This book is about the Nobel laureate biochemist Jennifer Doudna and her colleagues is how to find it.

Author Isaacson nicely highlights the most important ethical issues in genetic editing.

"

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.

Wen | Chen Gen

In the era of a large change in the past 100 years, artificial intelligence serves as the core technology of the new round of technology revolution and the industry revolution. For the importance of global development, artificial intelligence technology determines that the international leadership of the big country is almost one inevitable. However, the uncertainty of artificial intelligence development has also exacerbated the difficulty of technical risk management, bringing new challenges for global governance.

First, the high productivity of artificial intelligence also means high fortification.Wealth accumulation and speed and international strength contrast will have a more obvious partial wild, that is, the rich country is rich, the strong country is more strong, and the poor country is the stronger, the weak country weakens, resulting in more wealth unevenness and unfair Incorrectization, more conflict with conflict and conflict and terrorism, this is a greater uncertainty and governance of global governance.

Second, artificially intelligent high execution also means high destructive power.If the new weapons and network viruses, there is an endless body condition that has the human body conditions and the unknown tired action, which will bring benefits to the implementation tasks of various countries, but may also be used by some forces, thus giving international Society has brought serious safety hazards, and may even bring disasters to the entire human society.

Finally, the high intelligence of artificial intelligence also means high political. Advanced artificial intelligence gives the technical owner’s outstanding additional advantages, robotic industry, gene sequencing, automatic driving, intelligent finance, smart city, big data processing, natural language processing, image identification, intelligent military system and other artificial intelligence, Change the country’s core competitiveness and economic and social and industrial structure, thereby changing the power structure in many fields.

Because of this, as a big country as the development and application of artificial intelligence, China and the United States play an extremely important role in artificial intelligence, and both parties have unique advantages that other countries cannot copy.How to prevent or reduce artificial intelligence technological advances on the negative impact of global sustainable development and strategic stability requires the work of China and the United States.

In fact, competition in the field of artificial intelligence is not an absolute zero and game, and there is a cooperative development and mutual benefit between parties. China is relatively leading in experimental research and results, and the United States is more leading in basic research and cutting-edge technology exploration. There is a broad cooperative space in both parties.

To this end, China and the United States should be in-depth thinking, work together to launch a formal dialogue on the application of artificial intelligence in safety and economic sectors.Promote the transparency of artificial intelligence research and development, driving its beneficial results to achieve reasonable allocation in a global scale, to minimize the competitive situation that may lead to catastrophic conflicts, and promote the formation of reasonable, benign competition and cooperative relations.

As Kissinger said, China and the United States are the most capable of impacting world progress and peace in technology, political experience and history, and solving the important issues in both parties in cooperation will be China and the United States. Common responsibility for peace and progress.

Editing the Initiator: Most of the modules contained in your resume, but you have to write a good resume, but it is not so easy. So as the B-terminal product manager, how to write a highlight, and practical, can fully display your ability? In this article, the author sumizes a resume writing guide for the use of the B-terminating B-terminal product manager, and let’s take a look.

I. Introduction

The resume this thing sounds very simple, but it is difficult to write. Because thousands of people, everyone has their own preferences and understanding of resumes. This article is a summary of my individual’s resume on the B-terminal product manager, and many of whom have compared personal emotional color, so if you have different opinions, you can adjust it.

This article is mainly suitable for product manager reading, learning from B-terminal agency, learning from learning, not suitable for new people in the school, because I am not very familiar with the school, there is no saying, so new people Pay attention to reading when reading …

Second, the resume structure

I use the same structure in the three versions, but also similar to the commercial system of product managers on the market, a total of 5 large modules, as shown below:

Many people will entangle whether to write self-evaluation, my suggestion is to write, self-evaluation is a key module in your resume, you should reflect your highlight in this place, concentrate the essence, not to let the interviewer work and work and Exploition in the project experience.

Some people will put this module in the end, my suggestion is in front, this is the same as "the words" in the "Pyramid Principle", first out of the show, it is right.

Basic information This piece is basically less than going to turn, but some details need to be noted that I have marked, such as gender, age, working years, job hunting, these needs to be carefully checked.

Next, let’s take a look at the basic information I wrote in the virtual resume I wrote. This resume is written in MarkDown, so I use a table mode to renderate the layout of this fragmentation.

The resume owner is "Mai Feifei" and "Mai Xiaofei", which refers to the product manager for more than 5 years, respectively, and the overall structure of the resume. It is only some experience and personal highlights. It will be different.

Basic information of Mai Feifei

Basic information of Mai Xiaofei

Self-evaluation is a wave of king bombings, don’t write some "lively, optimism, hard work, high conscious, strong implementation ability, and brave enough to accept new challenges", you have to pinch this piece, The words are said to pick out the contents.

For B-terminal product managers, I suggested to write from big to small structures. That is to write from the industry / company, then the project / department, and finally go to the individual’s hierarchy, so that the HR or interviewer is more inseparable, it also meets the MECE principle, more structural.

Mai Fei’s self-evaluation

Mai Xiaofei’s self-evaluation

Some of the self-evaluation in the picture may be very long because I deliberately wrote some introductors to do some inspiration. Everyone pays attention to the reduction, control space and text density when writing. If you have other bright spots or additional to add, you can also put it here, such as some excellent works, awards or very matched jobs.

Work experience is my longest module because simple write work experience is very simple, but it is necessary to put out the things and grades made in a company, but also the content of virtual creation, it is too difficult to me.

Work experience is highlighted,What is the main thing to do, then make any achievements?. If some content is not very easy to write, then refine some keywords, used to match the job description in the recruitment information, try to let HR see you have done this piece.

There is dry goods to write dry goods, there is no dry goods, you can write keywords, or you can bold keywords and increase visual implies.

Mai Fei’s work experience

Whether this module is to add "Company introduction" and "work performance", I asked some friends, everyone is not the same, so I have two versions, everyone compares to see if I want to choose one Content. I can’t write two versions, write multiple resumes, cross-type delivery, see which effect is good.

Mai boats work experience personal recommendations work experience and project experience can write separately, more work is to look at your past experience to be what the company until how long, what about outstanding contributions; and whether the project experience is emphasized and job requirements match the value which items you have done in the past, experience and current job whether these projects need is match fit, and have not done any items from 0-1, if there is enough experience and richness so on.

Project experience resume is the second most important content, I think it is the first "self-evaluation."

To experience it is difficult to write the project, because the project is too eat this stuff up vertical experience, and many people experience in the project will increase the realism write some data, but this can easily be caught little mistake during the interview, if the data not familiar with the blind or made, impact on the interview is still getting bigger.

STAR project experience are generally used to write the law, the truth is easier said than done, I sometimes not very good grasp. Because some projects may not have the results, or achievements expressed some projects are fundamentally bad.

Mai Feifei project experience 1

Mai Feifei project experience 2

About STAR project experience is the law of writing, there are many variants, so I wrote two templates, we can compare and see in the end what is more appropriate.

Mai boats of project experience 1

Mai boats of project experience 2

About project experience this piece, I wrote a long time to find a lot of resumes learn from this content piece, and found that in fact a lot of people are content to write the contents of specialized jargon or words of surgery. Read up on the feeling I did not say to what point, but the actual viewing resume when it seems not affect my subjective feelings on this resume.

A small amount of jargon explained resume appears, in fact, does not affect how I feel about the whole resume, as long as you can pass in place some key words, other innocuous content will not look at your resume when a closer look.

End of the article I will put some jargon and terminology of my collection, there are times when nothing resume writing, or what there is no inspiration, they can learn from it.

In view of space reasons, I suggest that educational experience and credentials can be combined together to write, if you experience a lot of education, there are many certificate, and then it split into two modules is also possible.

This piece of content will basically not overturned, a point to note is that the issue of education. Sometimes the company will first pay greater attention to education, so it is best marked on the resume that he is full-time or part-time. Frank, it could reduce HR and the interviewer resume screening of trouble, but also disguised himself saves time.

Third, the supplemental content

Cliches is good, but still have to pay attention to control the tempo and length, do not write too many false big empty of content. The following excerpts from the network, part of my own finishing.

1. Responsible for requirements gathering and analysis, functional design and optimization iterations and outputs corresponding documentation, to promote the development team on the test line.
2. 0-1 responsible for product research, Competitive Analysis, product architecture and functional design.
3. Integrated front and back office business processes and product functional design, make products according to business restructuring plan.
4. 0-1 responsible for the demand for research, process, functional design, coordination of resources, promote the development of the product line, get the demand side feedback, follow up subsequent optimization products.
5. Closed-loop project management, combing the project needs, coordinate business resources to promote the project on time and on line, and track user feedback, combined with custom business scene and have optimized product strategy, to ensure product quality and effectiveness.
6. Xx responsible for the design of new features, functionality has been updated iteration. Familiar with Axure, Xmind output tools such as product design project prototypes, PRD, organizational needs assessment.
7. Cross-sectoral coordination and communication, and promote close cooperation UI, developers, operators and other personnel, time and shelf life to reach the needs of landing on the line and follow the subsequent iterative optimization work.
8. Xx user is responsible for product research, butt-related business, combing scenarios, business process and user needs and build demand pool, and outputs a flowchart brain map, the demand loop, constantly optimize the product user experience.
9. Summary analysis of competing products, development of competing products daily attention and industry trends, product planning and product positioning.
10. Continue to focus on the new line of functional data and analysis, continuous construction and optimized according to business needs and performance data to improve product strategy.
11. Tracking on-line data, with some data analysis capabilities to understand the AB test design process, and summarize results.
12. Brainstorming and evaluation, AB output test design, track, analyze, summarize new and old versions of data on-line, data mining features behind user behavior, merit-based on-line.
13. Responsible for the overall business platform product planning, functional design and development team collaboration, to promote the realization of the project landing.
14. Responsible for the core business (xxx module, xxx modules, etc.) carding business processes, product finishing logical rules, develop and implement programs and other projects iteration.
15. Responsible for product requirements analysis and management, combing business processes, the design and planning of the corresponding product features, write documentation requirements, coordination within the organization and external resources to achieve product goals and project management.
16. Responsible for collecting user feedback, monitoring service module (xxx module, xxx module), analyzes user data, tracking product performance and progress feedback, timely adjustment of product strategy.
17. Xxx is mainly responsible for the overall planning and supply chain planning iterative versions of related products, including: Market Analysis, Competitive Analysis, prototype and PRD organize, and collaborate and R & D team, complete version of the product line development.
18. Responsible for product lifecycle management, including internal publicity, promotion and training on the product line to protect business people familiar with product features and functionality to help solve business problems.
19. Orders operational data analysis, improved scheme is proposed to improve the ease of use of the system, improve the user experience ordering system.
20. Determine the development plan, coordinate project resources, track project progress, to successfully complete the project and achieve goals.
21. Mainly responsible for the company’s order OMS system, the product demand analysis and system design work of warehousing WMS system, participating in the integrated plan of upstream related systems and project management work in multi-projects.
22. Responsible for conducting daily demand communication and organizing relevant documents with each business unit, providing product side solutions. Responsible for communication with regional information division and business units, follow-up project plans and progress.

For the things that the data class needs the door to the door, it is not good to be stuck in the interview. For B-terminal products, this piece should be cautious, don’t write data, because B-terminal data is often sensitive or less easily reflected in the achievements.

1. Through the optimization iteration of product / XX functions, the ease of use of products is improved, and the order rate is improved, enabling the company’s unity, and the transformation of orders will increase XX%.
2. After optimizing the XX function / launch XX function, upgrade DAU, upgrade from XX% to XX%
3. With XX initiative, the re-purchase rate is increased from XX% to XX%.
4. With XX initiative, the XX page has increased to XX%.
5. Through the online line of XXX, the demand for XXX is met, and the company’s core customers are introduced to the company.
6. The XXX feature has opened the XXX and XXX two systems, which promotes the increase in the increase in the amount of increase and the increase in the volume, and the amount of XXX is increased in half a year.

Detailed project experience Description When you are fit, talk, your resume can’t write so much, your resume picked up the business background of the project. What kind of crowd, what kind of person, what product is to do, what kind of modules, the main functions, what kind of user can contact your product, how to use it. If the product level of the product is very large, you can refer to the product’s user-level and some good-looking data on your resume.

Reference on this piece of resume is as follows, this content is basically my own finishing:

1. From 0 to 1 to the various work of the project, including business research, feasibility analysis, demand analysis, output project research report, forming overall product side programs, warehouse on-site testing, special training, assessment, practical, online Quality tracking, etc.
2. Optimize the process of warehouse operations, including procurement, supplier returns, guests retreat, bunk room transfer, library, inventory adjustment, inventory payment and other processes.
3. From 0 to 1 to the project, including the project pre-service business demand research, business process carding, system plan sorting, demand document finishing, system prototype design.
4. Follow the progress of system development, coordinate resources, and ensure that the product project is completed on time and delivered high quality. Product function test, business person training, internal product preaching, etc. before the system is online.
5. From 0 to 1 to the work of the project, responsible for procurement business research, output project research report, forming overall solutions, online function testing, business person training, online function optimization iteration, etc.
6. Optimize the procurement process, including procurement applications, purchase orders, procurement returns, procurement source management, procurement depals and other processes.
7. Optimize the financial management part of the process, including the procedure, payment, payment, inventory accounting, multi-service data payment, etc.
8. Responsible for the product planning and design of the special line small package business, including: supplier docking, trajectory platform docking, ERP docking and other upstream links.
9. In combination with business unit requirements, introduce more international logistics, docking logistics providers interface, acquisition, tracking number, and trajectory information.
10. Improve the circulation relationship between logistics orders and logistics states, and make visual reports present logistics trajectory and their proper effect.
11. Connect the online base information and status mapping of the mainstream cross-border e-commerce platform.
12. Improve the order-margin, the optimal logistics method match, the intelligent trial rule configuration, improve the order performance efficiency, save the operating costs.
13. Optimize order performance traffic and state flow, improve the functional operation of order profit accounting rules and dismantling orders.
14. Optimize the order refund process, open the order after-sales and customer service, warehouse, and financial roles complete business interaction chain.
15. Responsible for the demand analysis of OMS, WMS, Operation Platform, system product program planning, functional design, demand, iterative management, external customers, internal teams and system docking organization coordination.
16. Responsible for platforms from 0 to 1 demand analysis, program planning, function design, iterative management. Complete the platform-based XXXX docking item, XXX docking items. 17. Responsible for WMS and APP system plan planning, demand research analysis, system design, demand management.

Fourth, summary

There are many articles on the resumes on the market, and the content is more information, which is a difficult thing to find a good information.

So in order to avoid the next time you look for a similar tutorial, I will still have to write a tutorial. On the one hand, I will meet the needs of my future, and I can communicate with you in advance, open my own Idea.

By writing this slow thinking process, you will make a summary of this piece of knowledge. It is very big for my personal help, and it is also hope that my contribution can bring some help to friends who need it, because I have a public The positioning is the comparison of vertical and grounding, if you are also a supply chain-related product, then some cases you can take it.

My name is Vitamin ,. Former PHPER, I have done online education products, and I have also done more than 4 years of cross-border warehousing logistics, and is currently a supply chain product manager in foreign trade SAAS. Mainly focused on WMS / OMS / TMS / BMS / ERP and other fields, sharing the supply chain related product knowledge.

This article is published in everyone who is product manager. It is prohibited from reprint without author license

Questtery from unsplash, based on CC0 protocol

Author: Science and Technology BB

Recently, my mood is really bad, and I don’t say a pile of things. I recently girlfriend, I can’t move it, I will have a flame mountain every time I go home.

Know the mountain, I have a tiger, I am biased towards the mountain! (Don’t go back, how can I come, I haven’t understood it, I maybe it is possible.

The fire is really big, how is the Sichuan hot pot? It is not a level, this is spell damage, which is far better than physical damage.

Cause: She is estimated by the fire because the weather is dry, blowing air conditioners at night, causing the body’s moisture loss, thus causing anger. In order to give the ancestors to reduce the fire, I also had a pain, and I bought a big humidifier. Using a humidifier, the dry environment in the home is really a lot, and the girlfriend is significantly smaller. Since there is an effect, it is ready to arrange to the ancestors. In order to let her in the dry weather, they are not lacking in the loss of moisture, drinking water must be necessary (buy a cup), can be in the humidifier in the humidifier, A card frozen mini humidifier (from the product test).

Demand: Humidifier, small, and portable in the office. Second, the value is not bad, otherwise not only can’t destroy the fire, it is easy to enter the oil. Humidifier is used, and cost-effective. (Satisfied, there is basically nothing)

The humidifier is mainly divided into two types of household humidifiers and industrial humidifiers.

One is an ultrasonic humidifier, one is a pure humidifier.

The chevan frog humidifier belongs to the ultrasonic humidifier category, which can disperse 5 microns water molecules, so that the skin enjoys the benefits of the benefits, one gesture to meet daily humidity demand, two rain forests are booming moisture summer air-conditioned room, winter heating dry, accompanied 365 days a year.

This humidifier has a leather handle, which is convenient to carry two spray ports. Two add water methods, which can directly open the top cover for humidifier, plus water, of course, you can also add water from the top. Add water, you can do not open the water, the open water is a little suitable for the bottle to slowly pour it, prevent water flow splash.

The package accessory manual, the data cable, and the water-absorbent (itself can be used for a long time can be replaced) is still very thoughtful, it does not need to be purchased again at least in a short time.

The chevy humidifier built into a 2000mAh built-in battery, and it can be done for 7 hours or so, and it can be inserted, and the charging hole is Micro-USB design, the back of the humidifier. If it is a Type-C port applicability will be higher.

The humidifier is turned on, click Open a single hole spray mode.

The humidifier is turned on, and the double hole spray mode can be opened if you double-click.

The humidifier top cover can be separated, convenient to water storage, the upper cover is the main functional area, and the water tank can be appropriately added according to the scale.

The water absorbers on the humidifier can be swapped, and the inside is a filter element, dirty can be replaced, always maintains hygienic, effectively inhibits the hyperplasia of bacterial viruses.

The water tank also comes with rice wheat stone, which can be fixed at the bottom of the humidifier, and countless fine small holes on the rice stone can also filter the impurities in natural water. The humidifier uses water dispenser filtration, and there is bacteriostatic silver ion and The water absorbing filter has a good antibacterial effect under the action of double protection.

This product is suitable for tap water, do not use pure water, distilled water, if the water soluble essential oil can be placed, because his fog is KHz microporous atomization piece. Atomized water without white powder, its atomization piece is also specially treated, and the anti-corrosion is done.

There is a non-slip mat design at the bottom, which can make the humidifier to be more secure and will not slip freely.

The key next to the key is a timed switch, and the length of the humidification can be set with you, and you can set 1H / 2H / 4H, no operation, after 12h, the machine will shut down by default. Meet your different needs.

【Summarize】

This humidifier positioning is portable, easy to take place, suitable for office, small square room. Simple design style, whether as humidified tools, or as a room for the room, is a good choice.

My girlfriend has had a small humidifier in the house with a small humidifier, and the skin is moist. Of course, my happiest is that my girlfriend is a lot, no longer with sleep. NS.

This small humidifier, color value and function are very good, I have a deep heart.

This is still very nice if you have a demand.

Recommended index: five stars

What is worth buying app all net shop shopping prices

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 ~

Apple usually releases a new iPhone phone in September, such as the iPhone13 series of mobile phones introduced in September this year, except for the general iPhone mobile phone, Apple will also launch the iPhonese series mobile phone.

iPhonese series mobile phone is Apple’s low-cost iPhone mobile phone, using small screen design, iPhonese series mobile phone is also known for users, such as Apple’s iPhonese2 mobile phone, unfortunately iphonese2 Mobile phone does not support 5G Internet access.

According to foreign media Macrumors, the latest report, the latest report, showing Apple’s words in the first quarter of next year, and the specific time is expected to be launched at the end of March next year.

According to Apple, I broke the news, the new iPhone is designed in appearance or the iPhone old model, based on iPhone8, equipped with a 4.7-inch screen.

Of course, the IPHONESE series is not its highlight. The brightest of the iPhonese series is hardware configuration and cheap prices. The iPhonese3 mobile phone will be equipped with more powerful processors to support 5G Internet, iPhonese3 mobile phone will be equipped with A15 processor Gao Tong X60 modem, iPhonese3 mobile phone is expected to be the cheapest 5G version of iPhone.

Work temperature is 30 ° C, and the amount of carrier flow under the long-term continuous 90% load is as follows:

1.5 square millimeters – 13A

2.5 square millimeters – 26A
4 square millimeters – 32A

6 square millimeters – 47A
16 square millimeters – 92A

25 square millimeters – 1220A

35 square millimeters – 150A

Current conversion power:

1A=220W,

10A=2200W,

So on and so forth.

For example, if the carrier traffic is 14A, it is: 220W × 14=3080W, then 1.5 square copper wire power is 3.08 kW.

Long-term current allowed by national standard:

4 square is 25-32A

6 square is 32-40A

In fact, these are the theoretical security values, and the limit value is more than these.

The maximum power allowed by the 2,5 square copper wires is: 5500W.

4 square 8000W, 6 square 9000W is no problem.

40A’s digital meter is normal 9000W absolutely no problem. The 12000W of the machine will not be burned.

03

Copper wire wires allow long-term current:

2.5 square millimeters (16A ~ 25A)
4 square millimeters (25A ~ 32A)
6 square millimeters (32A ~ 40A)

for example :

1. Each computer consumes approximately 200 ~ 300W (about 1 to 1.5a), then 10 computers need a 2.5-square millimeter copper wire power supply, otherwise a fire may occur.

2, the large 3 air conditioner consumption is approximately 3000W (about 14a), then one air conditioner requires a separate 2.5 square millimeter copper wire power supply.
3, the current housing outlet is generally 4 square millimeters of copper wire, so the home appliances open at the same time must not exceed 25A (ie 5500 watts), some people replace the wires in the house to 6 square millimeters copper wires are useless. Because the wires entering the meter are 4 square millimeters.
4. Early housing (15 years ago) The import line is generally 2.5 square millimeter aluminum wire, so the home appliances open at the same time must not exceed 13A (ie 2800 watts).

5, household appliances that are relatively large consumption are: air conditioner 5a (1.2), electric water heater 10a, microwave oven 4a, rice cooker 4a, dishwasher 8a, drying machine 10a with drying function, electric heater 4a.

Among the fire caused by the power supply, it is due to the heat of the hair, so all the joints must be welded, and the contact devices that cannot be welded 5 to 10 years must be replaced (such as socket, air switch, etc.).

04

Copper wire wire cable traffic standard cable flow oral estimation:

Take the next two o’clock in nine, and go to the next time.

Thirty-five take three o’clock, double bunom group is five.

The conditions have changed, and the high temperature is 10% off copper upgrade.

The number of tube is two or three four and eight seven six folds.

illustrate:

This mouth is not directly pointed out to various insulated lines (rubber and plastic insulation lines), but "cross-section is multiplied in a certain number" to be represented.

"Two five-point multiply by nine, go to the next time," said that various cross-sectional aluminum insulation lines of 2.5mm2 and below are about 9 times the number of carriers of the cross-section. Such as 2.5mm2 wires, the carrier flow is 2.5 × 9=22.5 (a). The multiple relationship between the carriage of 4mm2 and more wires and the number of cross-section is row, the line number is row, the multiple is successively reduced by 1, i.e., 4 × 8, 6 × 7, 10 × 6, 16 × 5, 25 × 4.

"Thirty-five Take Three Fiveth, Double Bunction] Say", it is said that 35mm2 lead traffic is 3.5 times the number of cross-section, ie 35 × 3.5=122.5 (a). Wire from 50 mm 2 and above, the multiple relationship between the amount of carrier flow and the number of cross-section becomes a set of two two lines, and the multiple is 0.5. That is, 50, 70mm2 wire has a total of 3 times the number of cross-section; 95, 120 mm2 lead traffic is 2.5 times the number of cross-sectional area, and push it according to the secondary.

"Conditions have changed, high temperature nine fold copper upgrades". The above mouth is the copper core insulation line, which is determined under the condition of 25 ° C in ambient temperature. If the aluminum core insulation line is in the area where the ambient temperature is higher than 25 ° C, the wire carrier flow can be calculated according to the above-mentioned oral calculation method, and then hits it again; when used is not an aluminum wire but the copper core insulation line, Its carrier flow is slightly larger than the same size aluminum wire, and can calculate a carrier flow than the aluminum wire in the above-mentioned oral method. For example, the flow of 25mm2 copper wire can be calculated according to 25 mm2 aluminum wire.

Tips

● Electrician advanced information package:Wiring diagram, electrical identification, e-book, PPT …

Michael Joseph Jackson can absolutely be called a symbol of a era in the history of music. His music and dance have affected generations.

Perhaps he is too talented, its life has spent the dispute, among which the skin color and appearance are the largest. Even after many years of death, some people still assume that if he does not "bleach" skin and cosmetic, will it be?

Michael Jackson was killed in the King of Samway, Klin, 1992.

Below, you will look at a group of photos, look at his life, in each period. It is worth noting that the last photo is calculated by artificial intelligence, if he does not have a skin, it looks at 50.

In 1965, Jackson Jackson was on the stage for the first time and started the legendary life.

In 1978, Michael and met the music producer Quincy Jones, two people became a boring friend.

This is 1980, and he created a photo of the famous music "treasurer".

In 1983, Michael performs "space step" on the stage, shocked the world.

In 1988, Michael and Wang Hao Dianna met, creating MTV "Moonwalker", becoming the best-selling video belt in history.

In 1991, Jackson debuted in Africa, being crowned as "Sani King". At this time his skin has become white, and it has become a turning point for a lifetime.

In 1996, he divorced with a daughter of the Cat.

In 2005, after a year of forensics, "Love Book Case" finally reported that 14 accused of him were not guilty.

In 2009, 50-year-old Michael died in the United States.

If he doesn’t have a cylinder, what will he look like when he is 50 years old? Here’s this photo is artificially intelligent to give an answer.

When do you like it? Welcome to the message below.

If you are developing project development of artificial intelligence edge, then NVIDIA’s Jetson Xavier NX platform is absolutely ideal. As a Jetson series, Jetson Xavier NX has been favored by the majority of engineers with high-cost power and cost-effectiveness of up to 21tops.

Although NVIDIA has launched the Jetson Xavier NX system module, it is still a challenge to design a stable terminal product on the basis of some artificial intelligent R & D teams that lack hardware development experience. At this point, a mature and stable hardware device has undoubtedly brought great help to users who focus on algorithms and applications. Flying Embedded AI edge computing terminal FCU 3001 came into being.

Freon embedded AI edge computing terminal FCU3001 is an artificial intelligent edge computing device equipped with NVIDIA Jetson Xavier NX, with 6-core 64-bit ARM architecture processor, with 384 Volta core and 48 Tensor cores, calculations Force up to 21TOPS, configure 8GBLPDDR4 memory and 16GbemMC storage, is ideal for high performance computing and artificial intelligence in embedded and edge systems.

The FCU3001 created by Flying Mature Hardware Design Experience will help users easily realize the batch of computing applications of artificial intelligence.

The FCU 3001 is compact, with only 178 * 110 * 55mm, which is convenient to install or embed the equipment chassis. Excellent industrial design achieves stable no-fan cooling under the premise of ensuring the firmness and durability, ensuring that the product is stably operated at 21TOPS full load force.

The FCU3001 provides a wealth of functional development, including 4xethernet, 2XUSB3.0, 2XUSB 2.0, which is convenient for access to various sensors and peripherals, such as image capture, etc. At the same time, HDMI display is also supported, and the RS485, CAN industrial bus, one-stop control of visual identification + device linkage. It can expand storage devices such as installation of TF cards, SSD hard drives, so that data storage is not limited. Support dual-band WiFi and 4G / 5G communication, more flexible with cloud communication, allowing "5G + AI" to empower industry.

Ethernet, USB, RS485, CAN, etc. on the FCU 3001, all of the ESD4 level protection capability, contact discharge ± 8kV, air discharge ± 15kV, can meet most of the application scenario requirements for electrostatic protection, allowing equipment operation and more stable reliable.

The FCU3001 provides enriched development materials and development tools, including CUDA, CUDNN, TENSORT, and optimizes the package, so that users can download and use.

(Some information show)

Freon fully considers the user’s product-based maintenance, and the FCU3001 provides users with a U disk (Windows) update operating system, in addition to supporting the NVIDIA original OTG (need to use LinuxPC) Boot logo modify tool and operation guidance to meet user customization needs.

As an artificial intelligent edge computing device that can be applied to a variety of industries, the various artificial intelligent edge computing algorithms and procedures developed by the FCU 3001 are enabled, and the "magic" can be inspired, and the user will help users open technology in the relevant field. Robot, AGV, intelligent road conditions analysis, visual inspection, unmanned driving, smart medical, smart factory, smart city, more FCU3001 strong application, waiting for you to unlock!