上海夜网论坛

1905 movie network feature "The true meaning of life does not lie in the peak and glory,

But keep running, don’t stop. "

— — This is the sports inspirational film.

The attitude towards life that I want to convey.

The film "Beyond", which is supervised by and starring, is one of the few films focusing on sprint in China. The film tells the story of sprinter Hao Chao’s self-transcendence again with his willpower after he fell from the peak to the trough. The film combines sports, blood, persistence, youth, reality and other elements, and truly shows the athletes’ strength and the choices and challenges they face in the beautiful memories of youth and the cruelty of reality.

"Running under the Fireworks"

Ryan’s Strength Deduces Two-sided Life

Hao Chao, a former flying man, collapsed after retiring and became a greasy uncle. When facing his younger brother who regarded him as an opponent and idol, he only wanted to make a profit. Even though life has given Hao a reason to surpass himself, when his beloved sport reappears in his life and his younger brother needs his encouragement, he still expresses his love for sprinting with actions, which is a kind of inheritance of sportsmanship.

Under the gorgeous fireworks, middle-aged Hao Chao ran hard and kept calling his younger brother Wu Tianyi to "run, don’t stop". At the same time, the classic moment of Hao Chao’s sprint on the 100-meter track was also interspersed. Extremely explosive performances and wonderful editing have become the biggest tears in the whole film.

Hao Chao can get back on his feet, not only because of the strong character honed by the experience of sports students, but also because of the encouragement of family and friends. Hao Chao saw his high-spirited self from his younger brother, and also drew strength from his best friend Niu Tieju.

"Every weight I tried to lift,

Can make me remember it for a lifetime, because I really like it. "

"Run 100 meters in 47 steps"

　This is the unique romance of sports people.

Beyond is not only a sports inspirational film, but also integrates the unique romance of sports people into it. In the movie, Hao Chao explained the skill of running 100 meters in 47 steps. Why is it "47 steps"? Ryan also unveiled the hidden egg for the audience.

Regarding this figure, the film contains a lot of design and ingenuity. At the beginning of the film, young Hao Chaoyue proposed to Qi Yueyue for a gold medal, and the day when Hao Chaoyue proposed was April 7. In addition, Hao Chao wears the number cloth of "47", and the name of their son Hao Siqi also comes from the homonym of this number "47".

Manfred Weber, Chairman of the European People’s Party Group of the European Parliament, and Ursula von der Leyen, President of the European Commission, posted on social media on October 9 to talk about the Hungarian political situation. Weber even directly called Hungarian Prime Minister Orban "a thing of the past", while Hungarian opposition leader Peter magyar and his party "are the future". On October 11th, Orban pointed out in an interview that Weber and Ursula von der Leyen were "openly expressing their intention to subvert the current Hungarian government". Orban said that although he had long felt that the two men "had this idea", it was "unusual" to make such a public statement.

On the day of Weber and Ursula von der Leyen’s posting, Orban made a speech in the European Parliament, pointing out that the EU is currently facing many problems such as competitiveness and illegal immigration, and refuted Ursula von der Leyen’s accusations against the Hungarian government on the spot. (CCTV News)

Yidong ET is a pure electric vehicle with hatchback design. The car has been unveiled at the 2018 Guangdong Auto Show, and it is finally officially confirmed that it will be officially listed on May 11 this year. Yidong ET is based on the design of Changan classic hatchback Yidong XT. Vehicle size information: the length, width and height of the vehicle are//,and the wheelbase is.

Appearance, the car uses a closed air intake grille, which is the biggest appearance difference from the fuel version. This design can easily distinguish whether it is a new energy vehicle or not, with high recognition. In addition, Yidong ET also optimizes many details. Chrome plating is added to the triangular decoration under the lamp group, and the layering of lines is very obvious. Especially the very slender and harmonious sides and 17-inch wheels enhance the overall appearance of the vehicle. Quite a bit sporty.

In terms of interior, Yidong ET also maintains most of the same characteristics as Yidong XT. The cool version is equipped with a full LCD instrument panel and a 10-inch central control panel (the cool version is 7 inches), but don’t worry, cruise control and ESC body stability system are standard in all departments. In terms of configuration, the new car is equipped with Changan in-call 3.0 in-vehicle interconnection system, and also provides a series of safety configurations such as front airbag/front and rear integrated side air curtain/battery intelligent electric heating system. And tire pressure monitoring.

In terms of power, the new car is driven by pure electricity, equipped with a ternary lithium-ion battery pack with a capacity of 52.6kWh, with a maximum power of 100kW(136Ps) and a peak torque of 235 Nm. The top speed can reach 140 km/h. The gearbox is matched with a fixed speed ratio single-speed gearbox.

If the friends have any ideas, you can leave a message below to discuss.

Yang Mi

Co-produced by Lime Moe Film, Lime Moe Yuexin, Penguin Film and Television, adapted from the novel "The Queen of Shake" by Tianxia Guiyuan, written by Xie Yanyan, co-directed by Yang Wenjun, Xie Ze and Li Cai, Yang Xiaopei served as the chief producer, Yang Mi and Ruan Jingtian starred, Liu Yijun and Wang Jinsong starred in particular, Gao Weiguang, Lai Yi, Zhang Yachin, Hu Ke, Gao Hanyu, Huang Youming, Li Yixiao, Jiang Long and other co-starring TV series "Shake" is currently being broadcast on Zhejiang Satellite TV’s China Blue Week broadcast theater, and the countdown to the end this week. The "Five Continents Burning War" that lasted nearly two months is about to usher in the ultimate peak showdown. Fu Yao (played by Yang Mi) is still moving forward bravely, and the imposing red blood continues to burn. While fans at home and abroad are reluctant to close, they are also eagerly looking forward to the final direction of the plot. The positive energy of "Fu Yao" has spread in an all-round way, and in the midsummer of this year, with a high realistic temperature, it has won the affirmation of the majority of audiences and the recognition of official media.

"Shake" Reality Core Triggers Strong Resonance: Inspirational Growth Explodes Positive Energy

"Fu Yao" runs through the theme of "shaping personal value with an independent spirit and changing destiny with a pure heart" with a realistic and in-depth growth process. Just like the progress of the workplace in real life, many people will encounter confusion, misunderstanding, betrayal and even framing on the road of growth. Fu Yao uses sincere and passionate adventures to break through obstacles with tenacious beliefs, and constantly strives to achieve transformation. In addition, each character in "Fuyao" is fresh and independent, and many viewers can find their own shadows in it: Fuyao’s fearlessness and courage "although tens of thousands of people have passed away", does not change his mind for good and evil in the world, and becomes stronger under the polishing of hardships and trials; Wuji (Ruan Jingtian) "has the world in his heart and will never live up to" dedication and belief, bears the heavy responsibility of protecting the people of five continents, and gradually finds his true self in the rush to solve difficulties, and understands what he wants; Zhan Beiye (Gao Weiguang) and Yalanzhu (Zhang Yachin) accompany each other, step through the ups and downs, and finally fall in love; Zong Yue (Lai Yi) puts down hatred and embraces in the selfless dedication of Qi Yun (Yuan Yuxuan) Life. The unique charm of "Fu Yao" is that through the growth and transformation of characters and the integration of modern values, it stimulates the power of reality to lead the audience to produce more and deeper insights and thinking, so as to form a positive interaction with audiences at home and abroad.

Ethan Ruan

Drama fans are reluctant to part with "Shake" Countdown: "Five Blessings" cp high torture is about to kill each other

Accompanied by the continued enthusiasm of audiences at home and abroad, "Fuyao" is about to usher in the final battle. Many netizens said, "After reading this week’s preview, the plot is abusive, Fuyao knows the ultimate secret of himself, and the fate of life and death is difficult to choose. I feel sorry for Wufu cp to kill each other and book", "In the past two months, I have gone through fire and water with Fuyao and traveled to five continents. Through the growth of Fuyao to improve my own vision of things, I can’t bear to see Fuyao", "Fuyao and Wuji go hand in hand, and we can’t get tired of facing the wind and rain together. The ending is coming soon. Looking forward to Wufu cp overcoming the difficulties together before sending sugar". In the latest plot preview, the eldest grandson (Wang Jinsong) "worked hard" and coerced Fuyao to kill each other with the Empress of Yuan (Chuanzi), with the intention of making Wuji cut off the affair between his children, "Even if everyone betrays each other, let him walk alone like steel"; Fuyao tried his best to influence the eldest grandson, "From beginning to end, Wuji has always regarded you as his biological father. He respects you, loves you, and even feels sorry for you. He has been cautious all the way from Taiyuan and dare not relax in the slightest. It is because he is afraid of failing your expectations. Because you are the person he respects the most in his heart," how will Fuyao solve the "dead end" under the dilemma? In addition, Fuyao will face a cruel attack: his own life affects the safety of the people of Wuzhou, and the person he loves the most in front of him is actually "born as an enemy". The problem of the fate of the "Five Blessings" cp is completely spread out, and it is difficult to escape mutual abuse. Unknown plot, full of suspense, which is exciting.

"Fu Yao" tells the story of an ordinary girl who was born at the bottom, Fu Yao, who set off down the mountain to rescue her companions and embarked on an adventure in five continents. During this process, she accidentally met the eldest grandson Wuji, and stood side by side in love with him; the two adhered to the belief that "although thousands of people are gone", they went through hardships and overcame thorns, and finally succeeded in fighting against an unfair fate.

　　"Wanda Group is considering the sale of 20 shopping malls in Shanghai, Jiangsu, Zhejiang and other places. Each project is seeking a valuation of about 700 million yuan to 800 million yuan, depending on the location and business. The price of a shopping mall in Shanghai may be as high as 1 billion yuan."

　　As the only Chinese film shortlisted for the main competition of this year’s Cannes International Film Festival, the film "The Wild Goose Lake", directed by Diao Yinan and starring Hu Ge, Gui Lunmei, Liao Fan and Wan Qian, held its world premiere on May 18 local time.

　　"The Wild Goose Lake" is Diao Yinan’s masterpiece that has been polished for many years after the Berlin Golden Bear Award film "Fireworks in the Day". It was started in Wuhan on April 28, 2018 and took nearly half a year to shoot.

　　In the film, several star actors have contributed ground-breaking performances. Hu Ge tanned himself and lost weight in a short period of time. Gui Lunmei experienced life in Wuhan two months in advance and learned to speak the authentic Wuhan dialect.

　　The Wild Goose Lake poster

　　Creative inspiration predates "Daylight Fireworks", and news brings imagination to life

　　"In the face of framed and wanted fugitives, the story summary given by the crew of" The Wild Goose Lake "is:" In the face of framed and wanted fugitives, the escape for survival becomes a story of seeking death and running back and self-redemption. "Hu Ge plays Zhou Zenong, the leader of the desperate car theft gang, and Gui Lunmei plays a dusty woman who will do anything to exchange for freedom. The two join forces on the road to escape and play a" gamble "of fate. The contradictions of human nature and the emotional tension in an extreme state are full. Suspicion, betrayal, love, loyalty, conscience, complex emotional temptations, and ups and downs in the evolution of actions interweave a strange visual landscape.

　　The Wild Goose Lake

　　Diao Yinan’s perspective is set in the urban village of the bustling city, the fading marginal industries and crowds, the crime genre blends the cold atmosphere of the film noir, and the romance of the gangster film, which is more extreme in style than the previous work "Fireworks in the Day".

　　"The rivers and lakes exist in the infinitely stretched fringes around these cities." Diao Yinan believes that the "almost instinctive" choice of this fringe is also "the choice of romance, and the romance that only exists in the rivers and lakes is a profound romance." In addition, it is also a choice of space, "such a space can lead characters and stories, waiting for them to open up. I put a dark part of myself into it, trying to find comfort."

　　The Wild Goose Lake is on the cover of the fifth day of the Cannes Film Festival

　　When it comes to creative inspiration, Diao Yinan said that the idea of filming this story was even before "Fireworks in the Daylight". Many years ago, Diao Yinan heard a foreign song on the sofa one day. "I thought that I was a fugitive who was hunted down and had a bounty, and I wanted to run to the beach, run to find my first love, and let her kill me to receive the bounty." Later, Diao Yinan himself felt that this imagination was too hypocritical, so he gave up. Until a few years later, there was a coverage of a fugitive who escaped from prison and found that he was worth 100,000 when he saw the wanted notice, so he asked someone to report that he left the money to his relatives. "My imagination became news, and I think it might be possible to shoot it without being so hypocritical."

　　Hu Ge drank alcohol before the red carpet to "crush", Gui Lunmei’s Wuhan words made others "stressed out"

　　Liao Fan and Gui Lunmei had previously reaped glory in Berlin through their collaboration with Diao Yinan in "Fireworks by Day", and the film’s male lead, Hu Ge, was the first to bring a work to the red carpet at Cannes.

　　Hu Ge, who has appeared in more TV dramas in the past, was asked this time about his feelings of participating in the Cannes Film Festival. Hu Ge admitted that he had "mixed feelings": "First of all, I was nervous. Before going on the red carpet, I drank a sip of wine from the director’s pocket in the car, and I was shocked." In addition, Hu Ge also expressed the excitement of walking on the Cannes red carpet. "For every actor, this is something to be excited about. I am also very touched. When we walked into the film palace and the entire audience applauded, you felt respected. You felt that you chose this industry and this career, and everything was worth it."

　　’The Wild Goose Lake ‘crew walks the red carpet at Cannes

　　The Wuhan dialect performances of the actors in the film became the focus of attention in the post-screening media interviews. Talking about the preparations for the film’s dialect performances, each actor said that they felt "stressed" because they found that Gui Lunmei had spoken the Wuhan dialect very accurately when they entered the group.

　　The last time Gui Lunmei participated in the performance of "Fireworks in the Daytime", although Diao Yinan set the identity background of a foreigner for her characters, the Mandarin lines with Taiwanese accent still made her characters show a sense of disobedience in the icy Northeast. At this point, Gui Lunmei began to make breakthroughs in dialect performances, learning dialects and experiencing life in Wuhan two months before the start of filming. Gui Lunmei recalls that she was not able to learn Wuhan dialect at first, but walking around the village in the city, chatting with the locals, and thinking about the way they speak and pronounce gave her some knowledge. At the same time, she believes that the dialect does close the distance between the actors and the characters. "Wuhan dialect helps my performance. This language is very powerful, and speaking lines in this language can give the characters some hostility."

　　Hu Ge, Liao Fan, Wan Qian, Qi Dao and other creators later said that when they entered the group, they found that Gui Lunmei’s Wuhan dialect was very authentic and felt the pressure of "not falling behind", so they worked harder to learn dialects.

　　The Wild Goose Lake

　　When Hu Ge first learned to speak Wuhan dialect, he realized that he had learned it "exactly the same", but the teacher was not satisfied, and he was annoyed by it for a while. But one day he had a flash of inspiration and proposed to change his identity and teach the teacher to speak Shanghai dialect. In the process of the teacher imitating Shanghai dialect, Hu Ge "fully realized the feeling of him teaching me", and gradually realized his problem and found a solution.

　　Liao Fan introduced that everyone experienced life separately before the shooting in Wuhan, and he went to the criminal police team because he played the police. "The feeling of listening to the local criminal police chat every day is very inspiring to me." Wan Qian changed all the conversations in her life to speak Wuhan dialect, and then went to study lines to achieve "the process of quantitative change to qualitative change".

1905 movie network news More than 20 years ago, a movie was born out of nowhere, and it became a classic memory in the hearts of a generation with its nonsensical funny style. Recently, Wu Mengda, who played Pigsy, and Jiang Yuecheng, who played Junior Brother Sha, actually combined to play Westward Journey after many years. As soon as the news came out, many fans were excited. It is reported that,The Return of the True and False Monkey KingJiang Yihan is the chief producer, new director Luo Le is the director, and Chen Banghe is the chief planner. According to the recent media visit, the film also gathers Du Yiheng, He Gang, Cheng Ye, Jin Qiaoqiao, Gu Shangwei, Huang Yifei, Hu Linxi, Sun Cong, Bai Narisu and many other well-known domestic actors to participate. Unlike previous Journey to the West works, the film incorporates new creative elements such as magic, action, and comedy, striving to break "aesthetic fatigue" and bring audiences a different viewing experience.

Westward Journey CP reunion and then memories kill, Wu Mengda Jiang Yuecheng studio catch up and chat non-stop

The Westward Journey IP has been continuously adapted and put on the screen. It has to be said that thanks to the deep-rooted "Westward Journey complex" in everyone’s heart, many classic works such as the 86 version of "Journey to the West" and the 95 version of "Westward Journey" still make fans forget. Recently, another Westward Journey film and television work, "The Return of the True and False Monkey King’s God of War", has attracted people’s attention. In addition to the story and style of the film itself, it is even more surprising that the film also gathers Wu Mengda and Jiang Yuecheng.

When it comes to Wu Mengda and Jiang Yuecheng, I believe that those who have seen "Journey to the West" will not be unfamiliar. Wu Mengda once played "Pigsy" in the film, and Jiang Yuecheng, who was the executive director at the time, played "Sha Wujing". The two left a deep impression on fans with their humorous and funny performances. The crew of the same frame sage killing "True and False Monkey King: The Return of the God of War" can be said to have reunited after a lapse of 24 years, and instantly set off a wave of memory killing, which made many netizens sigh "Our childhood is back".

When old friends gathered, Wu Mengda and Jiang Yuecheng were also very excited. On the set, they started to catch up with each other every minute, laughing and recalling the past, and the scene was non-stop. Uncle Da bluntly said "with you around, I am not the ugliest", which caused a lot of laughter in the audience. For Jiang Yuecheng, who has been a director for many years, Uncle Da directly ridiculed, "Fortunately you are behind the scenes, if you were an actor at that time, I would not have eaten", which is very funny. As for the remarks of the outside world that the two became more and more similar, Jiang Yuecheng also called out "I am Wu Mengda" in person. The two came and went, and they clashed with each other, which was really hilarious. Although we haven’t seen each other for many years, the friendship between the two has not diminished. Talking about the past filming time, Uncle Da expressed his gratitude to Jiang Yuecheng for helping him a lot in the crew. This time, he served as the producer of this film, and he is very confident about the final quality of the film.

tacit cooperation to rebuild screen boutiques, luxury lineup to help Westward Journey

After many years, Wu Mengda and Jiang Yuecheng, who worked together again, still have a full understanding, and with full marks, Uncle Da’s skills have not been reduced, and his superb performance has won the unanimous affirmation of the main creative team. With the loving interpretation of his old partner, Jiang Yuecheng, who is the producer, is also full of confidence in the film’s finished effect. As for how wonderful the film is, Jiang Yuecheng said that he will not give spoilers for the time being, "Wait until everyone goes to the theater to see how ingenious the movie is, and what interesting interactions the two of us have in it."

In addition to Wu Mengda and Jiang Yuecheng’s two golden partners, the film also specially invited Jin Qiaoqiao, Huang Yifei and other familiar "drama bones" to join the audience, and at the same time gathered Du Yiheng, He Gang, Cheng Ye, Gu Shangwei, Hu Linxi, Sun Cong, Bai Narisu and other outstanding young actors, the film lineup can be called luxurious. Jin Qiaoqiao once played the kind-hearted and noble "Peacock Princess" in the 86 version of Westward Journey, with beautiful dancing and stunning everyone, while Huang Yifei, as Xingye’s "Royal Gold Medal Green Leaf", has been in the movie for decades and has countless masterpieces. What wonderful performances the two will offer this time, is also very exciting.

At present, the film has been shot for more than half, according to the production team, the atmosphere of the whole crew during the shooting process is very harmonious, and everyone is like old friends and more like relatives. All the behind-the-scenes staff perform their duties, are serious and responsible, unslack, professional and dedicated, and even Uncle Da can’t stop praising them. This is the most attentive crew he has seen in the decades of filming, whether it is from the investment of the characters’ money in the film or the dedication of every behind-the-scenes staff, "I completely feel the careful preparation of the producer and the main creative team, and I believe this film will open a new chapter in the journey to the west."

The cooperation between all the actors is also very pleasant. The young actors are not late and do not leave early, and the filming is hard and does not complain. Not only do they take care of the staff, but they also show great respect to Uncle Da, Huang Yifei and other seniors. For example, after the filming is over, Du Yiheng immediately helps Uncle Da to take a stool and help him sit down, which can be said to be literate and virtuous. The old seniors who are both virtuous and virtuous have no airs at all, do not play big cards, and are very supportive and caring to the younger generation. In interviews, many staff members said that "the whole crew is very warm".

Such a loving crew, working together to create a high-quality screen, I believe it will not disappoint the fans who have been looking forward to it! It is reported that the movie Great Sage Killing series "True and False Monkey King: Return of the God of War" is currently being filmed in Hengdian, and will be completed in the future. Three generations of old, middle-aged and young people will play on the same stage. What unexpected surprises will it bring to everyone? We can only wait for the theaters to find out when it is released.

　　Whenever people mention the Beijing-Hangzhou Grand Canal, they can’t help but call it "beautiful". In fact, the beautiful Beijing-Hangzhou Grand Canal, apart from its antiquity and civilization, has a unique flavor for its shiplocks. Especially in the northern Jiangsu Canal, it can be said that there are ten locks and ten landscapes. They are like ten bright pearls embedded in the 404-kilometer Grand Canal, and the ancient Grand Canal is decorated with beautiful scenery, which is particularly enchanting. In the 1980s, as a member of maintaining social order in the northern Jiangsu section of the Beijing-Hangzhou Grand Canal, I fought, patrolled, lived on the Grand Canal, and had zero contact with ten shiplocks along the way, and fully felt their unique scenery, mood and taste.

　　In the spring of 1980, after I retired from the army, I was assigned to the Shao Bo Police Station of Jiangsu Canal Public Security Bureau (No.8 Gangkou Road, Huaiyin City). The police station is located on the bank of Shao Bo Lake in the lower reaches of Hongze Lake with beautiful scenery. Together with Shaobo Ship Lock, it hides in a thick cedar and tall unlined upper garment forest. If it weren’t for the loud "cry" of ships coming and going, it would be a paradise. The police station and the lock management office are located in a small courtyard next to the lock, surrounded by a circle of antique glazed tile walls, fan-shaped wall holes and a small round door, which wraps three rows of bungalows (two rows are the rooms for the lock management office and one row is the place for the police station). Since then, I have camped in the police station and stayed with Shaobo Ship Lock day and night.

　　Shaobo Ship Lock was first built in 1934. Although the old lock has been scrapped, there is still an old lock wall standing along the river on the east bank of the canal. On this site, there is the autograph of "Jiang Zhongzheng", with three Chinese characters one meter square, embedded in the canal bank with cast iron, which fully shows how much attention the Kuomintang government paid to the development of canal transportation and water conservancy. Later, the ship lock was built in 1962. The lock chamber made of reinforced concrete and four watchtowers, like "Four donkey kong", stood on the Grand Canal. Because I was single, I had to take Zhajia as my home and guard the Subei Canal with the "Four donkey kong".

　　The scenery of the ship lock in those days was unique and charming. In the early morning, I can stroll by the Shao Bo Lake near the gate and feel the beautiful scenery of the lake overlooking the lake, with vast smoke waves and little fish sails; Walking up and down the lock, smelling the passing ships burning small stoves and making breakfast, the smoke and rice fragrance floating out are refreshing and appetizing. In addition to its architectural beauty, scenic beauty and greening beauty, the ship lock also has the unique beauty in the lock room, which is constantly presented to me.

　　The first is the beauty of "fishing for money".

　　Unlike now, toll collectors on the gates are all in remote dispatching stations or central command rooms, using computers to complete the tasks of registering and charging passing ships. At that time, the toll collectors on the gates were all beautiful women with special skills. Each of them carried a ballot box, held a wallet and put a long rope (cotton) on their wrists. After calculating the cost of crossing the gates according to the number and tonnage of ships crossing the gates, they tore off the quota invoice and clamped it with iron clips. With the waving of their arms, the long rope flew out of a dazzling arc and landed on the docked bow accurately. The boatmen are always happy to accept invoices, change into banknotes, and then throw them at the toll collectors with iron clips. The beauty toll collectors pulled hard by inertia, and the long rope crossed a beautiful arc in the air and fell into their arms.

　　The second is the beauty of releasing water.

　　The water level difference between the upstream and downstream of a ship lock is usually several meters or more than ten meters. When the ship enters and exits, it must pass through the gate entry, gate closing and water release from downstream to upstream, and then open the gate and leave the gate after the water level is equal to that of the upstream. The release of water from the lock chamber is a scene of the lock. When the lock workers turn on the hoist (the button was manually operated in those days, but now it is controlled by the computer), the river in the upper reaches is like a runaway wild horse, rushing out from the lock wall, and the big waves, the noise and the water mist constitute a symphony of the lock. Under the refraction of sunlight, water mist can sometimes form a seven-color rainbow over the ship lock, which is beautiful and dreamlike. And I often worry about the safety of the ship in the lock room under this beautiful scenery. In fact, there is no need to worry. Before the fleet entered the lock, the broadcast on the watchtower reminded: "Attention, comrades of the crew, the lock is about to release water. Please put on your life jacket, fasten the cable and take the bamboo pick. Pay attention to safety. " The beauty announcer of the ship lock, the gentle and drizzling reminder, made the passing crew full of enjoyment in their vigilance.

　　The third is the beauty of rock climbing.

　　In those days, you had to climb the approach pier of the ship lock and hand in the navigation book to the gate workers before registering for crossing the gate. After entering the lock, you have to climb the lock surface along the lock wall and take away the navigation book. When the ship lock is in low water, it is thirty or fifty meters away from the lock surface. When the crew members walk on the Grand Canal all the year round, they will inevitably climb up and down at the lock. In the long run, they will all practice a unique skill of "rock climbing". Whenever the lock releases water, you can always see many crew members climbing. The simple costume, the vigorous figure, the bronze skin and the protruding muscles, like geckos, walk up and down the lock, vividly showing a "rock climbing map" of the lock.

　　The fourth is the beauty of lookout.

　　There are four watchtowers at the four corners of the lock. The one in the southeast is the command tower, also called the dispatching tower. Climbing to the top of the tower, the surrounding scenery is unobstructed. Looking to the west is the rippling Shaobo Lake, and the derricks of Subei Oilfield are dotted in the distance. Looking eastward, the ancient town of Shao Bo is near by the river, and the big docks, Dawang Temple and Shiban Street where Emperor Yangdi and Qianlong set foot in ancient times can be vividly seen. Looking to the south, the Grand Canal suddenly widened, connecting with Shaobo Lake, and flowing to the ancient city of Yangzhou against the backdrop of the slate of the east bank canal levee. Looking to the north, the Grand Canal floats from the north like a silver ribbon, and flows to the ancient town of Shao Bo in the guise of green trees on the west bank canal levee.

　　The above four beauties can be said to be the common beauty of Subei Canal and ten shiplocks. Of course, apart from the similarities, there are also many characteristics that show the beauty of individuality. As for the difference of beautiful scenery, it should be that ten shiplocks are different. For example, Shiqiao Ship Lock in Yangzhou is famous for its royal garden style. Its rockery pavilion, small bridges and flowing water echo the ship lock architecture, and its pines, cypresses and winding paths add color to Shiqiao Ship Lock. In the last century, she was included in Yangzhou, an important place to receive foreign guests. I also served as the security guard for delegations from Romania, Albania and North Korea under the arrangement of the police station.

　　Our Huai ‘an Ship Lock is famous for its water conservancy hub, and the water interchange upstream of the ship lock is the only one in China. Huai ‘an Fanshui Station is an important project of North-to-South Water Transfer Project, which has made great contributions to continuously transporting Yangtze River water to Beijing, Tianjin, Hebei and Shandong. The Siyang Shiplock in Suqian is famous for being located in an orchard. The fragrance of fruits, cherries in spring, peaches in summer and apples in autumn make the past crew linger. The Zaohe Shiplock in Suqian is surrounded by luoma lake on the left and Zaohe Ancient Town on the right. The history that Qianlong stayed in Zaohe Palace for many times added a heavy stroke to the classical beauty of Zaohe Shiplock. The Jietai Shiplock in Xuzhou is full of flowers and trees. Entering a ship lock is like stepping into a world of flowers, a green ocean.

　　This is the canal lock that I remembered more than 30 years ago. Nowadays, many of the ten shiplocks have built three-line shiplocks and double-line shiplocks. Our two shiplocks in Huai ‘an are all three-line shiplocks, and they are the first shiplocks to realize modern management, ranking first in scientific management in China, especially in remote control, which has reached the world-class level. As the heart of ship lock command — — The Subei Navigation Management Office of Jiangsu Provincial Communications Department of Beijing-Hangzhou Canal is located on Yan ‘an East Road in the urban area, which plays an important role in the urban and economic development of Huai ‘an. Although Shidao Shiplock is not what it used to be, its aura is still there, and its scenery is more beautiful.

　　(Source/Huai’ an Literature and History Network Author/Shen Weihua)

2023 Shanghai Civil Service Summer Class

01

Summer series

Suitable object

(1) Zero foundation, candidates who are relatively weak in Shanghai civil servants’ examinations

(2) In the preliminary examination, I hope to focus on training during the summer vacation to quickly improve the ability to take the test

(3) Xiaobai, candidates who are committed to the post of civil servants for freshmen

(4) Candidates who need to follow, guide, and urge the test ability to improve the ability to improve the ability to improve

Form of class

Famous teachers of Huazhi, concentrated training, face -to -face teaching, classroom interaction, and on -site questioning and services to make students experience better.

Series features/highlights

· Scientific planning

Make full use of the summer time to reasonably plan courses, and choose courses scientifically to maximize the effect of learning in a limited time.

Construction framework

Understand the essence and answer methods of each type of question, establish a complete knowledge system, and avoid moving hard.

· Comb

Reading, careful investigation, and comparison of outlines, carry out key knowledge, conduct carpet -style review, and fully familiarize with the test content.

·Filling in the gaps

Help students find vulnerabilities or symptoms, provide targeted suggestions, and timely check the leakage.

· Focus on refining

Grasp the "key points", break each, make full use of the summer follow -up learning, and establish a diversified knowledge system.

· Consolidate review

Strengthen the exercise simulation questions, real questions, and prediction questions, and consolidate the content of what they have learned.

02

Weekend series

Suitable object

(1) Candidates who are weaker in Shanghai Civil Service Examination

(2) In the preliminary examination, candidates who have not learned much about the Shanghai civil servant exam

(3) Candidates who want the system to review and improve a comprehensive improvement

(4) Candidates who need to write a full -process system for writing or interviews, and hope that candidates who have bonuses and protocol guarantees

(5) Students who need to follow, guide, and urge the test ability to improve the ability to improve the test.

Form of class

Opposite the offline: Facing teaching, classroom interaction, questioning and services on the spot, making students experience better.

Series features/highlights

Learn through

Offline Huazhi senior teachers have taught the skills and strategies of admitting the skills and strategies to learn the theoretical skills and lay a solid foundation.

· Practice

Provide a sufficient quantity to preserve questions, consolidate high after class, and practice the questions.

Test

Simulation simulation exams, you can practice, calm, and stable test room mentality.

· Separate teaching

Basic-Title Sea-Sprint-Interview, Stage Learning, layer up, strength prediction.

· Science learning

Consolidate the basic mastery method+sprint knowledge large combing+pre -test training.

· Answer

Follow -up questions, questions and answers, questioning questions, questioning of classrooms, questioning after class, assignment questions, all efficiency guarantee within 24 hours;

Chief

Huazhi senior teachers have been taught in person to help learn more.

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 ~