Excel软件在缺少中转库的批量图书倒架中的应用——以天津外国语大学图书馆为例  

Application of Excel Software in Bulk Book Reshelving without Intermediate Warehouse——A Case Study of Tianjin Foreign Studies University Library

作　　者：赵琪 Zhao Qi(Tianjin Foreign Studies University,Tianjin 300204,China)

机构地区：[1]天津外国语大学,天津300204

出　　处：《办公自动化》2024年第14期90-93,共4页Office Informatization

摘　　要：随着图书馆藏书量、阅览量、容纳读者量的增加,天津外国语大学图书馆专业文献阅览室与时俱进,为更好地服务于馆藏建设,将传统闭架管理模式转变为开架管理模式,由此带来需要大规模倒架的问题,在缺少中转库的情况下,通过使用Excel软件对图书信息进行数据化、建立索引库、预置中转空间、进行模拟排架,避免重复排架,大大提高倒架效率,降低人力成本。With the increase in the volume of library collections,readership,and the number of readers accommodated,the professional literature reading room of Tianjin Foreign Studies University Library keeps pace with the times.In order to better serve the collection construction,the traditional closed-stack management mode has been transformed into an open-stack management mode,which brings about the problem of large-scale reshelving.In the absence of an intermediate warehouse,Excel software is used to digitize book information,establish an index database,pre-set intermediate spaces,and simulate shelving to avoid duplicate shelving,greatly improving shelving efficiency and reducing labor costs.

关 键 词：EXCEL软件 排架模拟 交互倒架 科学测算 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术] G258.6[自动化与计算机技术—计算机科学与技术]