基于Excel-VBA的精准扶贫明白卡批量制作程序开发  

Development of Batch Production Program for Accurate Poverty Alleviation Clear Card Based on Excel-VBA

作　　者：单正 何兆科 钱均贵 尹承勇 邓维娟 

机构地区：[1]中国电建集团昆明勘测设计研究院有限公司

出　　处：《科技创新与应用》2020年第9期41-42,共2页Technology Innovation and Application

摘　　要：精准扶贫是我国全面建成小康社会、实现中华民族伟大"中国梦"的重要保障措施。为进一步建立健全精准识别、精准帮扶机制,实现"全面小康不落一人"的总体目标,澜沧拉祜族自治县采用精准扶贫"明白卡"精准管理建档立卡贫困户,实现贫困户信息化管理,"明白卡"具体展示出贫困户"两不愁、三保障"基本情况和精准帮扶情况。但"明白卡"的填写内容涉及广泛,数据处理工作量大。运用Excel-VBA实现数据的半自动化处理功能,可以极大地提高"明白卡"制作的工作效率和质量。文章以东河乡邦敢村2018年度精准扶贫"明白卡"批量制作为实例,简要论述运用Excel-VBA开发设计"明白卡"制作程序的基本思路、技术要点和方法。Accurate poverty alleviation is an important safeguard measure for our country to build a well-off society in an allround way and to realize the great "Chinese Dream" of the Chinese nation. In order to further establish and improve the mechanism of accurate identification and precise assistance, and to achieve the overall goal of "being well-off in an all-round way", Lancang Lahu Autonomous County adopts accurate poverty alleviation "clear card" to accurately manage and establish a card for poor households, so as to achieve information-based management of poor households, and the "clear card" concretely shows the basic situation of "two worries, three guarantees" and accurate assistance for poor households. However, the filling content of the "clear card" involves a wide range of contents, and the workload of data processing is heavy. Using Excel-VBA to realize the semi-automatic data processing function can greatly improve the work efficiency and quality of "clear card" production. Taking the batch production of accurate poverty alleviation "clear card" in Bangkang Village, Donghe Township in 2018 as an example, this paper briefly discusses the basic ideas, technical points and methods of using Excel-VBA to develop and design the production program of "clear card".

关 键 词：精准扶贫 Excel-VBA 明白卡 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]