| 基于Excel的营养计算器设计及应用 |
| |
| 引用本文： | 郑艳泽,翟成凯,刘亚祺,章海风,何杨,金鑫,张群,丁周波,郭延波.基于Excel的营养计算器设计及应用[J].中国食物与营养,2010(4):82-84. |
| |
| 作者姓名： | 郑艳泽 翟成凯 刘亚祺 章海风 何杨 金鑫 张群 丁周波 郭延波 |
| |
| 作者单位： | 1. 东南大学公共卫生学院营养与食品卫生学系,南京,210009
2. 中国医科大学,沈阳,110001 |
| |
| 基金项目： | 国家自然科学基金，江苏省科技厅软科学项目，江苏省卫生厅重大科研项目，江苏省科技厅社会发展项目 |
| |
| 摘 要： | 目的:应用Excel2003软件编制营养计算器,应用于膳食调查,膳食干预、饮食管理及优化。方法:以《中国食物成分表(2004版)》和《中国食物成分表(2002版)》为数据源,应用Excel2003建立食物营养成分数据库;根据实际需求建立数据库查询;根据食物净含量比例,采用函数或公式方法进行数据处理及数据引用。结果:Excel2003营养计算器可完成食物营养成分的计算,按照实际所需食谱营养标签界面的自动打印输出结果,取得良好效果。
|
| 关 键 词： | Excel 2003 食谱计算 营养计算器 膳食管理 |
Design of Nutrition Calculator Based on Excel 2003 and Its Application |
| |
| ZHENG Yan-ze,ZHAI Cheng-kai,LIU Ya-qi,ZHANG Hai-feng,HE Yang,JIN Xin,ZHANG Qun,DING Zhou-bo,GUO Yan-bo.Design of Nutrition Calculator Based on Excel 2003 and Its Application[J].Food and Nutrition in China,2010(4):82-84. |
| |
| Authors: | ZHENG Yan-ze ZHAI Cheng-kai LIU Ya-qi ZHANG Hai-feng HE Yang JIN Xin ZHANG Qun DING Zhou-bo GUO Yan-bo |
| |
| Affiliation: | ZHENG Yan-ze1,ZHAI Cheng-kai1,LIU Ya-qi1,ZHANG Hai-feng1,HE Yang2,JIN Xin1,ZHANG Qun1,DING Zhou-bo1,GUO Yan-bo1 (1 Department of Nutrition , food hygiene,School of Public Heath,Southeast University,Nanjing 210009,2 China Medical University,Shenyang 110001) |
| |
| Abstract: | Objectivel Use Excel 2003 to design a nutrition calculator used in dietary survey, dietary intervention, diet management and optimization. Methods] With ＂China of the food composition （2004 edition）＂ and ＂Chinese food composition （2002 version）＂ as the data source, Excel 2003 was apply to establish a database of food nutrient composition and to establish database query based on actual demand. According to the proportion of net content of food, Function or formula methods were used for data processing and data reference. Results] Nutrition Calculator based on Excel 2003 could complete the calculation of nutrient composition of food and real need for automatic printing output and achieved good results. |
| |
| Keywords: | Excel 2003 |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
