Excel计算引起的误差分析及解决方法

Excel电子表格以其实用性、易用性、高效性在工作中被大量应用。使用Excel进行数学计算,省去了手工计算的繁琐过程,提高了工作效率。在某些情况下,Excel计算的结果与实际真值存在误差。笔者结合工作实践,深入了解Excel计算方式,对Excel的计算误差进行了分析,并摸索出一套解决方法。     

应用Excel自动生成产品质量监督检验报表

本文主要介绍了如何应Excel进行统计操作,自动生成产品质量监督检验报表,其中包括Excel函数的应用、VBA编程以及Excel高级操作.     

Excel在财务报表中的应用

Excel软件具有强大的计算与统计功能,是财务人员必须掌握的工具.对于财务报表编制的相关工作更是联系紧密.本文也正是以Excel在财务报表中的应用为研究对象,对应用中的相关问题进行了分析.文章从Excel的应用功能分析谈起,阐述了Excel的应用功能功能结构.最后介绍了与财务报表相关的Excel函数.希望本文的研究能够给财务人员的工作带来指导和帮助.     

在SQL Server 2000和Excel 2002中通过XML发布企业数据

本文描述如何利用Microsoft SQL Server 2000和Excel 2002中的功能通过XML将企业数据发布到Excel 2002。本文详尽地描述了示例代码，以阐释如何用SQLXML生成一种可由Excel 2002直接读取的格式的XML数据。这种格式被称为“Excel XML电子表格架构”或“XML-SS”。Excel 2002和Office Web Spreadsheet组件支持这种XML格式。     

Matlab与Excel相结合实现标准铂电阻温度计检定数据处理

标准铂电阻温度计检定数据处理复杂,常规的基于Excel电子表格的数据处理方法显得繁琐.Madab具有强大的数值计算功能,且提供了Excel Link插件,使Matlab命令可以在Excel环境中编辑调用.采用Excel管理标准铂电阻温度计相关常数和检测数据,采用Matlab命令进行数据处理,解决了偏差甬数系数的求解、温...     

基于VBA的线路纵断面图的自动绘制

在对线路纵断面图的构成要素进行分析的基础上,利用VBA对AutoCAD的自主定制,编制了自动绘制线路纵断面图的程序,实现了线路纵断面图自动绘制。首先将绘制线路纵断面图有关的数据组织成若干个Excel表,然后建立AutoCAD与Excel之间的通信,最后通过Excel的对象模型实现对Excel数据表的访问。     

Excel函数在成绩分析管理中的运用

函数作为Excel处理数据的一个最重要手段,其强大的功能体现在对数据的自动处理和计算方面。然而在实际工作中,很多人因为对Excel函数功能不了解而无法高效地完成一些工作。本文以Excel函数在成绩分析表中的应用为例讨论了Excel中常用函数的功能、使用方法。     

利用EXCEL功能实现压力传感器性能参数运算

以线性压力传感器为例,详细介绍了如何建立和设置Excel电子表格;详细介绍了如何利用Excel的内置函数来设计运算,实现压力传感器各项性能参数;介绍了如何运用已经设计好的Excel电子表格来实现对一个压力传感器性能参数的运算。     

Excel在中职数学课程中的应用

文章以用Excel绘制指数函数和对数函数曲线为例，阐述了Excel在中职数学课程的具体应用。     

借助Excel2010让成绩分析更加可视化

结合实例介绍了Excel2010快速分析数据的数据条、图标集、迷你图以及数据快速筛选、显示和删除重复项等新功能,探讨了Excel2010在学生成绩分析中的应用技巧及经验,让广大教师认识Excel2010可视化分析学生数据的功能,并能很好地利用它们处理数据。     

Unconventional fractional quantum Hall effect in monolayer and bilayer graphene

The commensurability condition is applied to determine the hierarchy of fractional fillings of Landau levels in monolayer and in bilayer graphene. The filling rates for fractional quantum Hall effect (FQHE) in graphene are found in the first three Landau levels in one-to-one agreement with the experimental data. The presence of even denominator filling fractions in the hierarchy for FQHE in bilayer graphene is explained. Experimentally observed hierarchy of FQHE in the first and second Landau levels in monolayer graphene and in the zeroth Landau level in bilayer graphene is beyond the conventional composite fermion interpretation but fits to the presented nonlocal topology commensurability condition.     

Editorial - Asia Pacific Microwave Conference 2007 (APMC'07)

The Asia Pacific Microwave Conference was first convened in New Delhi in 1986 and then in Beijing in 1988. It was established to foster a close dialogue among engineers and academia in various applied electromagnetic disciplines inside and outside the Asia Pacific Region. It was also designed to serve as a conduit for channelling advanced technologies into the region, in particular, the developing countries. Starting from the fourth one held in 1992 in Sydney, APMC has been held annually throughout the major cities in the region. Thus after APMC'07 held in Bangkok in December 2007, the APMC series of annual conferences continues its successful run at scheduled dates and venues in the Asia Pacific region: APMC'08 in December 2008 in Hong Kong; APMC'09 in December 2009 in Singapore, APMC'10 in Yokohama, Japan; APMC'11 in Melbourne, Australia and APMC'12 in Taipei, Taiwan.     

Microbial stability evaluation of cement-based waste forms at different waste to cement ratio

An evaluation of the effect of differences in chromium nitrate to cement ratio on the microbial stability of a chromium nitrate/cement waste form, as reflected in the leaching of chromium, calcium, magnesium and aluminum; was carried out in this study. An increase in the proportion of chromium in the waste form from 4.8 to 8.7% had no noticeable effect on microbial stability, with the total chromium leached essentially unchanged. Further increases in the proportion of chromium in the waste form from 8.7 to 10.7%, and from 10.7 to 15.9% resulted in a substantial decrease in microbial stability, with 3-fold and 1.3-fold increase in the total chromium leached, respectively, observed. For calcium, increases in the chromium proportion were accompanied with increases in the total calcium leached even though the increases were not in direct proportion to the increases in chromium proportion. For magnesium and aluminum, increases in the proportion of chromium within the range 4.8-10.7% were accompanied with increases in the total respective metals leached, with minor variation for each metal. On the whole, the maximum percentage chromium leached from the different waste forms was substantially lower than those of the other metals.     

铝合金的动态再结晶

本文展现了当前铝及铝合金动态再结晶研究的一些进展。分析了铝合金动态再结晶的特点和材料状态,形变条件对动态再结晶的影响。指出了铝合金动态再结晶研究在理论,实际生产中的意义和铝合金动态再结晶研究的方向。     

Investigation of collaborative research trends in Indian medical sciences: 1900–1945

The decade beginning 1925 is important in the history of medical science in modern India. This is evident from the bibliometric study of the publications in theIndian Medical Gazette, from 1900 to 1945. The paper studies the evolution of collaboration in the field of medical sciences during this period. In order to do so the study determines the: (i) pattern of collaboration in basic and applied research in medical science; (ii) trends in the multiplicity of authors; and (iii) the type of collaboration for the period 1900–1945. The collaborative and authorship trends discussed in the paper suggests that medical science was still in the developing stage in India in the period 1900–1945, and there was a possibility of its expansion in the near future.     

21世纪之初工程哲学在东西方的同时兴起

科学哲学和技术哲学都是首先在欧美国家兴起的,可是,工程哲学却是于21世纪之初在中国和欧美发达国家同时兴起和基本同步发展的。文章简要介绍了2002年以来工程哲学在中国和欧美国家发展的重要事件和已经发表的重要著作,最后,简要评论了东、西方工程哲学发展的主要特点。     

Leukaemia following childhood radiation exposure in the Japanese atomic bomb survivors and in medically exposed groups

Incidence and mortality risks of radiation-associated leukaemia are surveyed in the Japanese atomic bomb (A-bomb) survivors exposed in early childhood and in utero. Leukaemia incidence and mortality risks are also surveyed in 16 other studies of persons who received appreciable doses of ionizing radiation in the course of treatment in childhood and for whom there is adequate dosimetry and cancer incidence or mortality follow-up. Relative risks tend to be lower in the medical series than in the Japanese A-bomb survivors. The relative risks in the medical studies tend to diminish with increasing average therapy dose. After taking account of cell sterilisation and dose fractionation, the apparent differences between the relative risks for leukaemia in the Japanese A-bomb survivors and in the medical series largely disappear. This suggests that cell sterilisation largely accounts for the discrepancy between the relative risks in the Japanese data and the medical studies. Excess absolute risk has also been assessed in four studies, and there is found to be more variability in this measure than in excess relative risk. In particular, there is a substantial difference between the absolute risk in the Japanese atomic bomb survivor data and those in three other (European) populations. In summary, the relative risks of leukaemia in studies of persons exposed to appreciable doses of ionizing radiation in the course of treatment for a variety of malignant and non-malignant conditions in childhood are generally less than those in the Japanese A-bomb survivor data. The effects of cell sterilisation can largely explain the discrepancy between the Japanese and the medical series.     

Generalized model of resonant polymer-coated microcantilevers in viscous liquid media

Expressions describing the resonant frequency and quality factor of a dynamically driven, polymer-coated microcantilever in a viscous liquid medium have been obtained. These generalized formulas are used to describe the effects the operational medium and the viscoelastic coating have on the device sensitivity when used in liquid-phase chemical sensing applications. Shifts in the resonant frequency are normally assumed proportional to the mass of sorbed analyte in the sensing layer. However, the expression for the frequency shift derived in this work indicates that the frequency shift is also dependent on changes in the sensing layer's loss and storage moduli, changes in the moment of inertia, and changes in the medium of operation's viscosity and density. Not accounting for these factors will lead to incorrect analyte concentration predictions. The derived expressions are shown to reduce to well-known formulas found in the literature for the case of an uncoated cantilever in a viscous liquid medium and the case of a coated cantilever in air or in a vacuum. The theoretical results presented are then compared to available chemical sensor data in aqueous and viscous solutions.     

Q235焊接钢板受剪声发射时频特性分析

Q235钢板在工程中应用广泛,为了研究焊接对于Q235钢板性能的影响,开展了焊接试样和完整试样的受剪实验,利用数字声发射系统对实验过程的声发射信号进行实时采集。根据声发射计数率划分不同阶段,采用魏格纳-维尔分布,平滑伪魏格纳-维尔分布,对信号进行时频分析。实验结果表明:受剪实验中,焊接试样与完整试样的声发射特性明显不同,主要表现在受剪过程的各阶段中声发射信号能量集中的频带不同,弹性变形阶段信号时频带主要集中在80~100 k Hz附近;钢板塑性变形阶段时频带集中在100~140 k Hz范围内;焊缝塑性变形阶段,时频能量主要集中的频带范围在300~350 k Hz之间,部分能量较弱的信号分布在100 k Hz附近频段。     

Difference in the Definitions of Coherence in the Space-time Domain and in the Space-frequency Domain

Abstract

Coherence in the space-time domain and in the space-frequency domain are compared and found to be non-equivalent. Coherence in the space-time domain is sufficient for coherence in the space-frequency domain. Coherence in the space-frequency domain is not sufficient for coherence in the space-time domain. The source spectrum as well as coherence in the space-frequency domain effect coherence in the space-time domain. The coherence in the radiation field from two very different localized sources is studied. It is found that the fields are coherent throughout the far field region only if the sources are monochromatic.