联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺

食品科学 ›› 2012, Vol. 33 ›› Issue (16): 91-95.

联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺

田亚新1，韩晓云1，王运来1，康传红2,*

1.黑龙江大学生命科学学院 2.黑龙江大学化学化工与材料学院

收稿日期:2011-09-16 修回日期:2012-07-16 出版日期:2012-08-25 发布日期:2012-09-07
通讯作者: 康传红 E-mail:kangchh@163.com
基金资助:
黑龙江省教育厅科学技术研究项目;黑龙江大学青年科学基金项目

Optimization of Extraction Program of Sea Buckthorn Seeds Proanthocyanidins by Combining Uniform Design and Microsoft Excel

Received:2011-09-16 Revised:2012-07-16 Online:2012-08-25 Published:2012-09-07

摘要/Abstract

摘要： 提出一个基于均匀设计方法和Microsoft Excel的LINEST函数进行试验设计优化的方法。本实验通过均匀设计方法设计沙棘籽原花色素提取工艺，然后通过LINEST函数计算多元回归方程，该方法可避免因为使用其他专业数据处理软件的花费和固定算法限制。验证实验表明：沙棘籽原花色素的提取率提高了16.43%，该方法可应用到其他实验方面。

关键词: 优化, 均匀设计, LINEST, 回归方程, 原花色素

Abstract: A novel optimization method based on uniform design and function LINEST of Microsoft Excel was proposed to explore the extraction of proanthocyanidins from sea buckthorn seeds. The proposed multiple regression equation was calculated with the function LINEST. This method was not only a flexible method, but also could avoid high expenditure and fixed algorithm while using other professional software for data processing. The validation experiments showed that the extraction rate of proanthocyanidins from sea buckthorn seeds revealed an increase by 16.43%. This method is easy to extend and may hold promise for other scientific applications.

Key words: optimization, uniform design, LINEST, regression equation, proanthocyanidins

中图分类号:

田亚新1，韩晓云1，王运来1，康传红2,*. 联合均匀设计法和Microsoft Excel优化沙棘籽原花色素提取工艺[J]. 食品科学, 2012, 33(16): 91-95.

参考文献

[1]Fang K T.The uniform design: application of number-theoretic methods in experimental design[J].Acta Math Appl Sinica,1980,3:363-372
[2]Fang K T.Theory, Method and applications of the uniform design[J].International Journal of Reliability, Quality & Safety Engineering,2002,9:305-
[3]Liang Y Z, Fang K T, Xu Q S.Uniform design and its applications in chemistry and chemical engineering[J].Chemometr Intell Lab,2001,58:43-57
[4] http://office.microsoft.com/en-us/excel/HP052091551033.aspx?pid=CH06252831103
[5]Tian C, Nan P, Chen J K, Zhong Y.Volatile composition of Chinese Hippophae rhamnoides and its chemotaxonomic implications[J].Biochem. Syst. Ecol,2004,32:431-441
[6]Tang X R, Tigerstedt P M A.Variation of physical and chemical characters within an elite sea buckthorn (Hippophae rhamnoides L) breeding population[J].. Sci. Hortic,2001,88:203-214
[7]Ranjith A, Kumar K S, Venugopalan V V, et al.Fatty acids, tocols, and carotenoids in pulp oil of three sea buckthorn species (Hippophae rhamnoides, H-salicifolia, and H-tibetana) grown in the Indian Himalayas[J].J. Am. Oil Chem. Soc,2006,83:359-364
[8]Gao X Q, Ohlander M, Jeppsson N, et al.Changes in antioxidant effects and their relationship to phytonutrients in fruits of sea buckthorn (Hippophae rhamnoides L) during maturation[J].. J.Agr.Food.Chem,2000,48:1485-1490
[9]Negi P S, Chauhan A S, Sadia G A, et al.Antioxidant and antibacterial activities of various seabuckthorn (Hippophae rhamnoides L) seed extracts[J].. Food Chem,2005,92:119-124
[10]Suomela J P, Ahotupa M, Yang B, et al.Absorption of flavonols derived from sea buckthorn (Hippophae rhamnoides L) and their effect on emerging risk factors for cardiovascular disease in humans[J].. J.Agr.Food.Chem,2006,54:7364-7369
[11]Ganju L, Padwad Y, Singh R, et al.Sawhney, Anti-inflammatory activity of Seabuckthorn (Hippophae rhamnoides) leaves[J].Int. Immunopharmacol,2005,5:1675-1684
[12]Porter L J, Hrstich L N, Chan B G.The conversion of procyanidins and prodelphinidins to cyanidin and delphinidin[J].Phytochemistry,1986,25:223-230
[13]Dalzell S A, Kerven GL.A rapid method for the measurement of Leucaena spp proanthocyanidins by the proanthocyanidin (butanol/HCl) assay[J].J. Sci. Food Agric,1998,78:405-416
[14]Porter L J, Hrstich L N, Chan B G.The conversion of proanthocyanidins and prodelphenidins to cyanidins and delphenidins[J].Phytochemistry,1986,25:223-230
[15] Ministry of Health P.R China. Health food testing and evaluative technical criterion. Beijing, 2003, p274-275
[16] Fang K T. Uniform Design and Uniform Design Tables[M]. Beijing: Science Press, 1994
[17]Kagan A, Markham E.A better approach to designing an RTD interface with a spreadsheet[J].EDN,2008,Sep 18:56-57
[18]Li Y B, Shen Q P, Li H, Design of spatial decision support systems for property professionals using MapObjects and Excel[J].[J].Automation in construction,2004,13:565-