改性脲醛树脂胶原料配比和成本计算系统的开发  

System development of raw material ratio and cost of modified urea formaldehyde resin

作　　者：韩书广[1] 周兆兵[1] 崔举庆[1] 

机构地区：[1]南京林业大学木材工业学院,江苏南京210037

出　　处：《南京林业大学学报（自然科学版）》2012年第4期165-167,共3页Journal of Nanjing Forestry University：Natural Sciences Edition

基　　金：江苏省苏北科技发展专项资金(BC2010482);国家自然科学基金项目(30972307)

摘　　要：通过Excel内嵌的VBA(visual basic for aplication)在Microsoft Excel 2003工作表中建立了三聚氰胺改性脲醛树脂胶的原料组分配比及生产成本计算系统,利用该系统可自动实现组分配比与生产成本的计算,并以此与专业数学计算软件Matlab计算的结果进行对比。结果表明,该系统的计算结果与专业数学计算软件Matlab的计算结果相一致,具有较高的准确度和可靠性。所设计的系统适用范围广,操作简单,而且具有通用性和开放性,可以编制出酚醛树脂胶、三聚氰胺胶等其他胶黏剂生产的原料组分配比及生产成本计算程序。Raw material ratio and cost of modified urea formaldehyde（MUF） resin by ＂nelamine could be calculated au- tomatically by the calculating system, which was compiled based on Excel VBA （visual basic for application）in this pa- per. And the calculating results were as same as the professional data processing software Matlab＇s, this meant the calcu- lating system based on Excel VBA is highly accurate and reliable. The calculating system had advantages of wide appli- cability, easy operation, generality and openness, which could also be extended to calculating the raw material ratio and the cost of phenol formaldehyde resin and melamine formaldehyde resin.

关 键 词：EXCEL VBA 改性脲醛树脂胶 原料配比 生产成本 计算程序 

分 类 号：TQ433.431[化学工程]