基于Excel函数的库存管理新方法  

New Method of the Inventory Management Based on Excel Functions

作　　者：冯丽娜[1] 王刚[1] 张晓明[1] 

机构地区：[1]沈阳大学信息工程学院,沈阳110044

出　　处：《办公自动化（综合月刊）》2010年第6期45-47,共3页Office Informatization

摘　　要：本文介绍了一种以Excel办公软件为平台,以Excel函数为工具,应用于库存管理的新方法-Excel函数编程法。通过某厂焊接设备及配件库存管理实例,介绍用该方法自动生成各种统计报表的编程过程,并与该方法相比对其它方法的优缺点进行分析。This article describes a newprogramming method-Excel functional programming method,applied to inventory management,office software excel 2003 as a platform and excel function as a tool.This paper introduces the programming process of this method by an example that equipment and accessories inventory of welding and soldering are managed in a factory,this method can generate automatically to various statistical reports.Finally,it analyzes the advantages and disadvantages of this method comparing with other methods.

关 键 词：EXCEL函数 库存管理 自动生成 统计报表 Excel函数编程法 

分 类 号：TP317.1[自动化与计算机技术—计算机软件与理论]