久久亚洲国产成人影院-久久亚洲国产的中文-久久亚洲国产高清-久久亚洲国产精品-亚洲图片偷拍自拍-亚洲图色视频

Global EditionASIA 中文雙語Fran?ais
China
Home / China / Henan floods

College student's spreadsheet saves many lives

By CAO CHEN | China Daily | Updated: 2021-07-24 06:45
Share
Share - WeChat
A real-time excel spreadsheet developed by a college student is posted online to allow rescuers to find locations of those trapped by rising waters caused by downpours in Henan province. [Photo from the internet]

When an unprecedented rainstorm inundated Zhengzhou in Henan province on the afternoon of July 20, rescuing people trapped by the rising waters became a race against time, but finding them was complicated by the immense scale of the disaster and the lack of readily available information on their whereabouts.

That evening, a real-time excel spreadsheet was posted online, allowing rescuers to find the locations of those who were trapped.

Over the next 24 hours, this spreadsheet became a figurative bridge over troubled waters.

It was uploaded at 8:57 pm on July 20 on Tencent Docs, a free online document platform that permits multi-person collaboration. During its first day online, it was updated more than 270 times, and as of 7 pm, July 22, it had been viewed 6.5 million times.

The information contained was categorized and prioritized according to urgency.

For example, pregnant women about to give birth, infants and the elderly, were listed as urgently requiring rescue. Warnings about dangerous locations, like places with downed electricity cables, were also posted, as were the contact numbers and locations of temporary rescue shelters and of volunteers waiting to help.

Hundreds were rescued as a result, and the spreadsheet raised the hopes of the rest of the country as it closely followed the disaster relief work in Henan.

The document's creator, a graduate student in finance at the Shanghai University of Finance and Economics called Li Rui, has since been hailed as an unsung hero.

At 7:56 pm on July 20, as the scale of the disaster unfolding in her hometown was becoming apparent, the 22-year-old posted on Sina Weibo that she wanted to help those in need.

She then posted a Moment on her WeChat account asking for volunteers to help her collect information on people in need, create a priority list, and then connect them with rescuers and follow up on their situations.

Thirty-three students from the university, many of them her friends, responded to Li's appeal and an hour later, the spreadsheet was born.

To make things work more smoothly, Li divided the volunteers into two groups. One was responsible for collecting and verifying information, while the other was composed of volunteers from Henan province who were in charge of assisting rescue efforts.

"At first, we collected real-time information on Weibo on our own, which led us to repeat entries. We then used Python to maximize efficiency," Li said. "I also reminded volunteers to enter precise, concise information, to make it easy to understand."

Management of the document was later taken over by a team at Tencent, as the amount of data continued to accumulate.

To speed up communication, the Tencent team reached out to volunteer and rescue organizations and media groups, and created six group chats with over 200 members each on WeChat, which were a mix of Li's schoolmates and friends, as well as people from all over the country.

The availability and circulation of information is crucial in an emergency. The team at Tencent Docs said they learned that firsthand during their efforts to curb the spread of COVID-19 last year, when neighborhood committees, schools, and companies used online documents to record the latest information about the outbreak.

According to Tencent, 33 document templates for use in disasters are now available, and have been provided to local governments, rescue agencies, and social organizations.

On July 20, the technical team doubled the number of people able to edit a shared document at the same time, which made work easier and raised hopes.

"I felt terrible when I saw a message from a woman about to give birth. She must have been desperately worried that her child might not survive because of the deadly floods," recalled Jing Yujie, one of the volunteers from the university, who duly recorded the woman's details on the spreadsheet.

As a result the woman and her child were rescued.

"My hometown suffered flooding in 2018. I have always been grateful to the rescuers and people who donated food and clothing. I hope everyone will do their best to help each other whenever natural disasters occur," Jing said.

Li sent the first message to a person seeking help at 10:38 pm on July 20.

"It was not until 1:08 the next morning that I finally got a reply saying that he had been rescued and wanted to send us his thanks," she said. "Despite the really late nights, replies like that are real gifts, and this experience has inspired me to choose a career that contributes to the overall well-being of society," she said.

Top
BACK TO THE TOP
English
Copyright 1995 - . All rights reserved. The content (including but not limited to text, photo, multimedia information, etc) published in this site belongs to China Daily Information Co (CDIC). Without written authorization from CDIC, such content shall not be republished or used in any form. Note: Browsers with 1024*768 or higher resolution are suggested for this site.
License for publishing multimedia online 0108263

Registration Number: 130349
FOLLOW US
 
主站蜘蛛池模板: 国产免费久久精品久久久 | 亚洲一区2区三区4区5区 | 亚洲另类激情综合偷自拍图 | 久久亚洲精品一区成人 | 国产一区二区三区视频在线观看 | 日韩欧美视频在线一区二区 | 欧美日韩中文字幕在线视频 | 看色网站| 91色久 | 欧美激情伦妇在线观看 | 成人在线观看网址 | 欧美成人观看 | 99热国产免费 | 午夜天堂视频 | 国产一区二区三区手机在线观看 | 欧美在线一区二区 | 色老头一区二区三区在线观看 | 欧美视频自拍偷拍 | 欧美成人在线网站 | 国产精品成人一区二区不卡 | 美女黄网站色一级毛片 | 天堂8资源8在线 | 91久久福利国产成人精品 | 在线成人欧美 | 精品色视频| 99精品视频免费观看 | 国产成人精品男人的天堂网站 | 成人av手机在线观看 | 亚洲在线视频观看 | 国产精品揄拍一区二区 | 中文字幕亚洲精品日韩精品 | 中文字幕亚洲在线 | 美日韩一区二区三区 | 六月成人网| 18免费网站 | 玖草在线资源 | 国产一区二区三区精品久久呦 | 香港全黄一级毛片在线播放 | 亚洲午夜大片 | 欧美一级做 | 三级视频在线观看 |