共查询到20条相似文献,搜索用时 78 毫秒
1.
2.
当前,办公自动化软件已广泛应用于各行各业的方方面面,代替了繁琐复杂的手工作业,减轻了劳动强度,提高了工作效率.在众多办公自动化软件中,微软的办公自动化软件无疑应用最为广泛,也最被人们所熟知.其中,Microsoft Excel是微软办公自动化软件的一个重要成员,其能方便地对数据进行各种处理.在土地整理工作中,对Excel的熟练掌握与灵活应用,可以极大地提高工作效率,加快工作进度,但是当前很多工作者对Excel的应用基本还停留在原始操作层面上,这与其本身的强大功能很不协调.笔者根据实际工作中的经验,介绍Excel常用而往往又被忽略的一些功能. 相似文献
3.
4.
在我们的实际工作中,因办公计算机泄密的事件屡屡发生.如何加强文件的保密性是一个亟待解决的问题.现将自己在日常工作中总结出的Excel和Word文件的加密方法与大家共同分享,以便提高个人办公文档的安全性. 相似文献
5.
在Excel数据统计报表工作中,我们往往需要按某个或某些指定条件进行数据统计,如果指定的条件很复杂,应用Excel中的"条件求和"功能,就能很方便、高效地达到所需的数据统计要求. 相似文献
6.
由于大部分工资报表都用Excel来制作,怎样用Excel来打印个人工资条呢?根据平时工作实践,笔者摸索了一个比较简单的方法,只需一个公式就可以按个人打印工资条. 相似文献
7.
水泵性能曲线试验数据在用Excel表格进行存储时,为了使水泵性能数据在Excel通用电子表中能自动进行数值计算,利用VBA对原先编制的Excel水泵性能试验数据处理表进行了二次开发.在电子表中增加了水泵试验容差等级选择和试验结果按钮,根据GB/T 3216—2005标准规定的容错等级和判别准则以及最小二乘拟合算法和插值计算算法,分别对这两个功能按钮进行了VBA编程,通过点击试验结果按钮,就可实现水泵性能试验数据的插值计算和性能判别,得到了水泵规定点和交点的性能数据及判别结果.以BQW15-30-4型潜水泵为应用实例,进行水力性能试验,并进行了性能判别及绘制性能曲线.结果表明,H-Q曲线刚好与容差十字线垂直线段下端相交,满足要求.该方法增强了Excel处理水泵试验数据的插值计算功能,省略大量曲线绘制工作. 相似文献
8.
在利用Excel进行为客户建档工作中,有时候不可避免地会对某客户信息重复记录,但Excel有一个小小的缺陷,就是无法自动识别重复的记录。为了清除这些重复记录,有的基层供电所微机员一个一个地手工删除,既费时,又费力。其实这时可以利用Excel的高级筛选功能来巧妙删除重复记录。 相似文献
9.
10.
<正>数据透视表是Excel的组件之一,它能够将数据的筛选、排序和分类汇总等操作依次完成,并生成汇总报表,是Excel强大数据处理能力的体现。从供电所自主缴费机导出的客户缴费记录通常是个流水账,由于没有汇总出某个台区或某个用户的累计缴费金额,营销人员还需要对这些数据进行分类汇总,使用Excel数据透视表可以快速完成这些工作。 相似文献
11.
12.
感官检验棉花的品级,这是农村常见的一种检测手段.它的一个主要特点就是存在不确定性.这是由于检验员的品级检验水平存在一定的差异,其中有很多因素制约着检验的结果.文章对影响感官检验结果的因素进行了系统的分析. 相似文献
13.
14.
15.
16.
《Journal of Agricultural Engineering Research》1998,69(3):249-254
A model to represent the discolouration of dried powder of carrots as a function of temperature was developed. Two types of carrots, Asian and European, containing large amount of lycopene and β-carotene, respectively, were tested. The dried powder was stored under an atmosphere with O2and at three different temperatures, 5,20 and 35°C. The surface colour of the powder was monitored during storage by a Hunter colour ratioa/b. In the proposed model, the rate of oxidation was assumed to be represented by the product of the fraction of concentration of oxidized pigment at arbitrary time and a specific rate of oxidation of pigment. The rate parameters in the proposed model were calculated by fitting the experimental data with smooth curves by trial and error at the end of the induction period but before discolouration took place. The frequency constant and activation energy, expressing the temperature dependence of the rate parameters, were expressed by the Arrhenius relation. The simulation results of a Hunter colour ratioa/bof dried powder at 25°C showed good agreement with the experimental data, suggesting that the proposed model was effective for the prediction of discolouration of dried powder of both types of carrot. The use of the induction period in the manner described may enable the shelf life of dried powder to be predicted. 相似文献
17.
18.
从灾害经济学的角度探讨了城镇供水优化调度的必要性和可能性,认为在缺水不可避免的情况下,对供水进行优化调度可以减小缺水带来的损失,产生较好的减灾效益,特别是可以大大减小严重干旱的灾害效应。并根据水资源的特性,提出了缺水损失的计算模式以及优化调度的原则和方法。 相似文献
19.
20.
The fractional outflow rate of water from the rumen, measured as the rate of disappearance of the chromium complex of ethylenediamine tetra-acetic acid, was related to a number of dietary factors. A multiple regression equation was derived which expressed fractional outflow rate as a function of the intakes of dry matter, ash, acid-detergent fibre and crude protein.The data analysed consisted of 243 observations for sheep on 59 diets, including forage, concentrate and mixed diets. The ranges covered by the data were: fractional outflow rate 0.7–3.6 day?1; dry matter intake 560–1400g/day; ash 4–30%, acid-detergent fibre 7–41%, crude protein 5–26 % of dry matter; there were no observations for sheep of less than 34 kg liveweight.The equation accounted for 56·3 % of the total variance. Between-sheep variance could not be calculated for the whole of the data but was undoubtedly substantial since, for a sixth of the data, it was known to account for 38 % of the total variance. 相似文献