Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Journal of Anhui University of Technology(Social Sciences)》 2007-01
Add to Favorite Get Latest Update

The Application of Excel in Optimization of Parameters about Smoothing Methods

WU Xiao-hua(School of Economics,AHUT,Ma'anshan 243002,Anhui,China)  
The smoothing methods are applied extensively to the prediction,the most important of which is to select smoothing coefficient and it is also the most difficult one.It is very convenient to choose the superior smooth coefficient by means of Excel.
【CateGory Index】: C81
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 10 Hits
1 WANG You-liang①,ZHONG Lai-xing②(①College of information science and engineering Shandong Agricultural University,Taian 271018,China;②Shandong university of science and technology Tai An City checks area,Taian 271019,China);Pit horizontal deformation forecasting technology[J];Science of Surveying and Mapping;2008-05
2 WANG Zhi-jun1,2,GU Chong-shi1,2,LIU Hong-cai3 (1.College of Water Conservancy and Hydropower Engineering,Hohai University,Nanjing 210098,China;2.National Engineering Research Center of Water Resources Efficient Utilization and Engineering Safety,Nanjing 210098,China;3.Fresh Water Fisheries Research Institute of Shandong Province,Jinan 250117,China);Estimation of Loss-of-life Caused by Dam Break Based on Fuzzy Matter-element and Exponential Smoothing Method[J];Journal of Yangtze River Scientific Research Institute;2009-01
3 SHANG Xiao-si1,LIN Wei-dong2,TANG Yan-kui1(1.Guangxi University,Nanning530004,China;2.Guangxi Prefecture Research Institute of Environmental Protection,Nanning 530022,China);Development and Application of a Combined Water Quality Prediction Model Based on Exponential Smoothing and GM(1,1)——A Case Study of Iron and Manganese Levels in Yongjiang River[J];Environmental Science & Technology;2011-01
4 WANG Hai-tao(School of Environment and Energy Engineering, Anhui University of Architecture, Hefei 230601, China);Evaluation of Degradation Effectiveness of Cerium-Titanium Dioxide Photocatalytic Paint for Indoor Formaldehyde and Establishment of Model for Predicting Degradation Rate[J];Materials Protection;2013-05
5 Wang Haitao1 Zhang Hao2 Zhu Qingming2(1.School of Environment and Energy Engineering,Anhui University of Architecture,Hefei 230601,China; 2.School of Civil Engineering and Architecture,Anhui University of Technology,Maanshan 243032,China);Effect of light sources on photocatalytic degradation of formaldehyde solution and prediction model[J];Chinese Journal of Environmental Engineering;2012-12
6 ZHAO Yong-gang,CAO Hong-xia,WEI Xin-guang (Key Laboratory of Agricultural Soil and Water Engineering in Arid Areas,Northwest A & F University,Yangling,712100,China);Agricultural Water Consumption Forecast in Shiyang River Basin Based on Combined Model[J];Yellow River;2012-01
7 LI Zun-jian1,SU Dao-wu2(1.Taian Municipal Administration Engineering Department,Taian 271000,China;2.Donge Water Conservancy Bureau,Donge 252201,China);APPLICATION EXPONENTIAL SMOOTHING MODEL FORECASTING HORIZONTAL DEFORMATION[J];Journal of Shandong Agricultural University(Natural Science Edition);2009-04
8 ZHAO Li-Zhong1,SU Dao-Wu2(1.College of Information Science and Engineering,Shandong Agricultural University,Taian 271018,China 2.Donge Water Conservancy Bureau,Donge 252201,China);THE PIT DEFORMATION CURVE FITTING AND TIME-SERIES DYNAMIC ANALYSIS[J];Journal of Shandong Agricultural University(Natural Science Edition);2010-01
9 Chi Xiuwen1,Fu Tao1,Pan Jielin1,Lin Chi2,Wang Shuping3,Cai Guanghuang3(1.School of Resource and Enviroment Engineering,Wuhan University of Technology,Wuhan,Hubei 430070,China;2.Group of Urban Construction Investment Development Ltd.in Wuhan City,Wuhan,Hubei 430050,China;3.Mechanization Co.of Wuhan Civicism,Wuhan,Hubei 430012,China);Application of Exponential Smoothing in Predicting Horizontal Displacement of Pile Head in Deep Foundation Retaining Structure[J];Construction Technology;2010-S2
10 XU Jian-xin1,YAN Yong1,YAN Fu-hai2 (1.North China University of Water Conservancy and Electric Power,Zhengzhou 450011,China;2.Water Conservancy Bureau of Shangcheng,Shangcheng 465350,He'nan,China);The Application of Exponential Smoothing Model in GDP Prediction of Typical City[J];Water Conservancy Science and Technology and Economy;2008-07
【Citations】
Chinese Journal Full-text Database 1 Hits
1 LIU Jian-zhi(Hunan Vocational College of Commerce,Changsha 410205,China);Use of Excel to Solve the Problems of Linear Programming[J];Journal of Hunan Agricultural University;2005-05
【Co-citations】
Chinese Journal Full-text Database 2 Hits
1 HUANG Chun-hong et al(Key Laboratory of Zoology in Hunan Colleges,Life Science College of Hunan Arts and Science University,Changde,Hunan 415000);Problems and Solutions in Feed Formulation Designed by Professional Formula Software[J];Journal of Anhui Agricultural Sciences;2012-05
2 Chen Xue-ling(College of Nuclear Technology and Automated Engineering,Chengdu University of Technology,Chengdu 610059,China);The Application of Excel Programming Solver to Facilities Location[J];Industrial Engineering Journal;2010-02
【Co-references】
Chinese Journal Full-text Database 10 Hits
1 YAN Ming et al(College of Resource and Environment,Southwest University,Chongqing 400716);Application of Grey Predicted Model Based on the Excel in Land Use Planning[J];Journal of Anhui Agricultural Sciences;2007-12
2 BI Ye, GE Yun-shan, HAN Xiu-kun(School of Mechanical and Vehicular Engineering, Beijing Institute of Technology, Beijing 100081, China);Analysis of emission pollutants from Beijing taxi based on MOBILE 6.2[J];Journal of Safety and Environment;2007-02
3 ZHAO Xiao-guang~1,XU Zhen-cheng~2,WANG Xuan~1,WANG Jun-neng~3 (1 Chinese Research Academy of Environmental Sciences,Beijing, 100012,China;2 South China Institute of Environmental Sciences. MEP,Guangzhou 510655,China;3 Hunan Agricultural University, Resources and environment science institute,Changsha 410128,China);Analysis of Beijing cars with license plates allowed on the streets on air quality impact[J];Journal of Safety and Environment;2010-04
4 Luan Ying,Lü Baozeng(Northeast Agricultural University,Harbin 150030,China);The Research on Urban Drainage System Management Mode Innovation[J];Environmental Science and Management;2008-01
5 Liu Yang,Guo Jianbin(Subject of Ecological Environment Engineering in Soil and Water Conservation Collegeof Beijing Foresty University,Beijing 100083,China);The Research of Ecological Environment Pollution Caused By The Automobilism[J];Environmental Science and Management;2008-12
6 YANG Hao,ZHONG Yan,QIAN Da lin (College of Traffic and Transport, Northern Jiaotong University, Beijing 100044,China);Forecasting Model About Travel Time of Cars in Traffic Section of Road[J];Journal of Northern Jiaotong University;2001-02
7 Ma Yun(Department of Economic Management,Northern Jiaotong University,Beijing 100044);The Characteristics of Demand for Transport and The Peculiarity of Transportation Demand Analysis[J];JOURNAL OF NORTHERN JIAOTONG UNIVERSITY;1994-03
8 MA Yintao~ 1 , Alexis.K.H.LAU~ 2 , Peter.K.K.LOUIE~ 3 , LI Tanfeng~ 4 , LUAN Shengji~ 1, ~ 1 The Key Laboratory of Urban Human Residential Environmental Science and Technology, Shenzhen Graduate School, Peking University, Shenzhen 518055; ~ 2 Atmospheric Research Center of Hong Kong University of Science and Technology, Hong Kong; ~ 3 Environmental Protection Department, Hong Kong; ~ 4 School of Transportation Engineering of Tongji University, Shanghai 200092;;Application of Vehicular Emission Models and Comparison of Their Adaptability[J];Acta Scientiarum Naturalium Universitatis Pekinensis;2008-02
9 QI Ying(School of Business, Beijing Institute of Machinery, Beijing 100085, China);Predetermination and application of Linear Exponential Smoothing Model[J];Journal of Beijing Institute of Machinery;2004-04
10 Xie Kaigui He Bin (Department of system Engineering & Appiled Mathemtics, Chongqing University ,Chongqing 400044) Zheng Jiming (Department of Basic Courses,Chongqing University of Posts and Telecommunications,Chongqing 400065);Discussing about the Method of Model Constructing of Gray Forecasting Model[J];Journal of Chongqing University of Posts and Telecommunications;1998-03
China Proceedings of conference Full-text Database 1 Hits
1 JIYANG beibei SUN Lijun (Tongji University,Shanghai 200092);Theoretical Basis of Traffic Congestion Pricing and Its' Implementation Countermeasure Research in China[A];[C];2005
【Secondary References】
Chinese Journal Full-text Database 10 Hits
1 Feng Yang,Yin Di,Luo Bing(Dept.of Command Automation,Naval University of Engineering,Wuhan 430033,China);Forecasting Model for Spare Parts with Intermittent Demand Based on SES[J];Ordnance Industry Automation;2011-02
2 LI Zun-jian①,ZHAO Li-zhong②,WANG You-liang②(①Taian Municipal Administration Engineering Department,Taian 271000,China; ②China University or Mining and Technology,Beijing 100083,China);The high buildings distortion observation technical design[J];Science of Surveying and Mapping;2009-S2
3 DENG Qi1,WANG Qi2,HUANG Qi-fei2(1.Tsinghua University,Beijing 100084,China; 2.Chinese Research Academy of Environmental Science,Beijing 100012,China);Application of GM(1,1) in Forecasting Quantity of Industrial Solid Waste[J];Environmental Science & Technology;2012-06
4 Chen Xibing (China Kaolin Co., Ltd. Suzhou 215151);Preliminary Investigation on Strip Mining Method for Guanshan Kaolin Mine under Cemetery Group in Suzhou[J];Non-Metallic Mines;2010-04
5 WU Xiao-zhi,LI Zhong-quan,XU Tong(Zhongshan Vocational College,Guangdong Zhongshan 528404);The Research on the Influence of Zhongshan Bonded Logistics Center on the Regional Economy in the Pearl River West[J];Northern Economy and Trade;2011-06
6 XIAO Gui-yuan1,2,LIU Li-long2(1.Key Laboratory of Road and Traffic Engineering,Ministry of Education,Tongji University,Shanghai 201804,China;2.a.College of Civil Engineering,b.Guangxi Key Laboratory of Detection and Test of Architectural Engineering,c.Guangxi Key Laboratory for Spatial Information and Geomatics,Guilin University of Technology,Guilin 541004,China);Application of Dynamic Fuzzy Neural Network to Deformation Prediction[J];Journal of Guilin University of Technology;2011-03
7 HAN Sen,LI Na,LI Bo,HUO Ming,HAN Wei-wei(Key Laboratory for Special Area Highway Engineering of Ministry of Education,Chang'an University,Xi'an 710064,China);Test study on skid resistance attenuation of cement concrete pavements[J];Journal of Guangxi University(Natural Science Edition);2010-06
8 WANG Hai-tao(School of Environment and Energy Engineering, Anhui University of Architecture, Hefei 230601, China);Evaluation of Degradation Effectiveness of Cerium-Titanium Dioxide Photocatalytic Paint for Indoor Formaldehyde and Establishment of Model for Predicting Degradation Rate[J];Materials Protection;2013-05
9 ;Water Environmental Capacity Calculation and Prediction of the Upstream of Yongjiang River[J];Environmental Protection Science;2012-02
10 WANG Qi,WANG Hua-lan(College of Traffic and Transportation Engineering,Lanzhou Jiaotong University,Lanzhou 730070,China);Combination Forecasting of Vehicle Population Based on the Entropy Method[J];Technology & Economy in Areas of Communications;2009-06
【Secondary Citations】
Chinese Journal Full-text Database 4 Hits
1 Yang Hui-ying,Ren Dong-Mei(Northeast China Institute of Electric Power Engineering, Jilin 132002,China; Jilin Experimental and Vocational Senior School, Jilin 132021, China);By Using Microsoft Excel To Solve Equations[J];Journal of Changchun Teachers College;2004-10
2 LIU Gui-lian (Shanxi Industrial Vocation-Technical College, Datong,037003);Exploration the Mathematical Model by Using Excel to Solve the Problems of Economic Management[J];Journal of Hebei Fnergy Institute of Vocation and Technology;2004-04
3 XU Hai-xia1,REN Hong-song 2, (1College of Bio-Engineering, Shihezi University, Shihezi 832003, China;2 Department of Agronomy, College of Agriculture, Shihezi University, Shihezi 832003, China);The application of EXCEL and "Plan to ask and solve" function in fitting curve equation[J];Agriculture Network Information;2004-02
4 Gu?Yunyun (Shanghai Sports Technical College,Shanghai 200030);TWO SORTS OF APPLICATIONS USING EXCEL SOLVER[J];Computer Applications and Software;2005-01
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved