PowerQuery在渔业科研成果奖励管理中的应用

Application of PowerQuery in the Reward Management of Fishery Scientific Research

科研奖励管理工作是渔业科研活动的重要组成部分,涉及奖励申报、奖励统计、奖励发放等流程,系统化、批量化的数据处理能力,是高效完成该项工作的必备条件。近年来,笔者们利用PowerQuery对奖励管理的各环节进行优化,实现工作效率的大幅度提高。现分享相关应用经验,以期为同行提供一定的借鉴。

Scientific research reward management is an important part in fishery scientific research,involving reward declaration,reward statistics,reward distribution and other processes,in which systematized and batch data processing capabilities are indispensable.In recent years,the authors had used PowerQuery to optimize all aspects of reward management and achieved a substantial increase in work efficiency.This paper proposes application experience on Power-Query in scientific research reward management,which may provides a valuable reference to other managerial staffs.