国民经济评价在水利建设项目经济评价中的地位和作用是:在合理配置国家资源的前提下,采用影子价格、社会折现率、经济内部收益率等国民经济评价参数,从国家整体的角度分析计算项目对国民经济的净贡献,以考察项目的经济合理性。文章通过对禹州市纸坊水厂可行性研究报告中国民经济评价数据为例,探讨了利用Excel链接工作簿和函数计算功能在国民经济评价中的应用。 The status and function of the national economic evaluation in the economic evaluation of water conservancy construction projects are as follows: Under the premise of rational allocation of national resources, the national economic evaluation parameters such as shadow price, social discount rate and economic internal rate of return are used to analyze the overall national perspective Calculate the project’s net contribution to the national economy in order to examine the economic rationality of the project. The paper discusses the application of the workbook and function calculation function by Excel in the national economic evaluation by taking the data of China Civil Economic Evaluation on the Feasibility Study Report of Paper Mill W ater in Yuzhou City as an example.