Office 95技术讲座(九)——Excel 95图形与图表

Excel 7.0 for Windows 95(简称Excel 95)为用户提供了基本的图形对象(例如,直线、矩形、圆、椭圆、多边形等),用户既可以在工作表中绘制各种图形对象,也可以根据需要对图形对象进行格式化,并将其放置在工作表的任何位置。Excel 95还为用户提供了便捷的图表生成技术,可以根据工作表中的数据方便快捷地生成各种直观的图表(例如,柱形图、饼图、线图等),也可以根据需要自定义图表对象并将其放置在工作表的任何位置。特别值得一提的是,Excel 95新增的数据地图功能,用户可以根据含有地理信息(例如国家或城市名称)的数据表格生成一幅世界地图或中国地图,在地图中指定的地理位置上生成图表。在本讲中,我们将简要介绍Excel 95图形、图表的主要功能和实现这些功能的便捷途径。     

Excel 5.0的图形及图表

Excel 5.0 For Windows为用户提供了基本的图形对象,用户可以在工作表中绘制各种图形。例如直线、矩形、圆、椭圆、弧线、不规则图形、文字框等等。特别值得一提的是:Excel为用户提供了便捷的图表技术,可以根据工作表中的数据方便快速地生成各种直观的图表,用图形表示出数据,可以很清楚地从图表中看出销售的趋势,股市的动荡,各公司所占市场的份额等等。这些图表可以在工作表中生成,也可以在图表表格中生成。在工作表中生成的图表我们把它称为嵌入式图表(Embedded Chart),     

Excel 5.0的高级功能——数据分析、数据管理、宏、定制Excel

尽管Excel 5.0制作电子表格及图表的功能非常强大,但如果仅能单纯地把数据做成表格形式,并用图表表示出来,那么,它还不能算作最好的电子表格软件。正是因为有强大的数据分析、管理的功能,并且有能够进行自动化处理的宏编程功能,Excel 5.0才被认为是目前功能最为完备的通用电子表格软件,本文仅就其这方面功能作一扼要介绍。     

Excel2000图表修饰和链接技术

引言 Microsoft Excel是一个拥有大量用户的电子表格应用软件,在企业办公、数据处理等方面都有非常强大的功能,特别是在最新的Excel 2000中,又增加了新的实用功能。但是,对于如何把图表装饰成美观的图片以及与工作表生成链接,许多人可能知之甚少。本文介绍了这方面的内容,相信会有很多读者对此感兴趣。     

使用Excel编制有线电视地埋工程概预算表

在有线电视地埋工程中，经常要编制工程概预算表。但专业的概预算编制软件不但价格昂贵，还有一定的局限性。在实际工作中，我们可以使用Excel来编制工程概预算表。Excel是微软公司出品的Office系列办公软件中的一个组件，确切地说，它是一个电子表格软件，可以用来制作电子表格、完成许多复杂的数据运算，进行数据的分析和预测并且具有强大的制作图表的功能。下面是我使用Excel编制有线电视管道地埋工程概预算表的步骤。     

Excel在工资管理中的应用

本文分析了Excel在工资管理中的重要作用,并从数据的录入、函数处理到最后的图表展现都作了分析,展现了Excel的强大数据表格处理功能.     

利用中文Excel 5.0实现标准化考试的阅卷评分及统计分析

Microsoft公司的中文Excel 5.0是目前Windows环境下最受欢迎、功能最为完备的电子表格软件之一,它集数据管理、制表、绘图于一身,既可作为数据库使用,又可完成多种多样的表格和图表设计,进行复杂的数据计算与分析,其使用环境赏心悦目,操作方便、快捷。我们可以利用Excel 5.0的强大功能来实现标准化试卷的阅卷、评分与试卷分析等繁杂的工作。整个过程,可以分为建立数据表、阅卷评分操作、统计分析等几个方面。     

便捷调用Excel VBA代码

Excel VBA是Microsoft Excel内部设置的一个程序编写语言,利用好Excel VBA可以快捷的拓展Excel的程序功能,从而更好的实现Office自动化,促进工作效率的提高.在Microsoft Excel中有多种内置工具,掌握它们的使用方法,用户可以更容易的调用和使用VBA.本例主要解析使用Excel的宏录制器功能来调用和编写VBA的方法.     

在PowerBuilder中自动调用Excel处理与打印表格

Microsoft公司的Office办公软件中的Excel是一种专业的电子表格处理软件，Microsoft公司对它的Office软件系列都提供了对自动化技术的支持，这样就可以通过其他高级编程语言调用Office软件系列，利用其成熟而可靠的技术与功能来轻松实现特定功能。现将通过自动化技术，实现在PowerBuilder中调用Excel来实现表格的输出与打印。     

运用Excel简化CATV工程预算

在CATV网络建设中会产生大量繁锁的工程预算,而Excel电子表格软件可以帮助用户建立、编辑、计算和管理各种类型的电子表格以及对数据进行自动处理,也可以产生与原始数据链接的各种类型的图表.利用Excel软件的强大数据综合处理能力,建立一个预算模板,预算时只要在模板中输入需要预算的数据,就可以快而准确的得到我们想要的预算表.     

Resolution Enhancement Technology:Integrated Process Solutions using OPC

DUV lithography, using the 248 nm wavelength, is a viable manufacturing option for devices with features at 130 nm and less. Given the low kl value of the lithography, integrated process development is a necessary method for achieving acceptable process latitude. The application of assist features for rule based OPC requires the simultaneous optimization of the mask, illumination optics and the resist.Described in this paper are the details involved in optimizing each of these aspects for line and space imaging.A reference pitch is first chosen to determine how the optics will be set. The ideal sigma setting is determined by a simple geometrically derived expression. The inner and outer machine settings are determined, in turn,with the simulation of a figure of merit. The maximum value of the response surface of this FOM occurs at the optimal sigma settings. Experimental confirmation of this is shown in the paper.Assist features are used to modify the aerial image of the more isolated images on the mask. The effect that the diffraction of the scattering bars (SBs) has on the image intensity distribution is explained. Rules for determining the size and placement of SBs are also given.Resist is optimized for use with off-axis illumination and assist features. A general explanation of the material' s effect is discussed along with the affect on the through-pitch bias. The paper culminates with the showing of the lithographic results from the fully optimized system.     

Cost-effective test solutions for smart card and other integrated flash applications

From its emergence in the late 1980s as a lower cost alternative to early EEPROM technologies, flash memory has evolved to higher densities and speedsand rapidly growing acceptance in mobile applications.In the process, flash memory devices have placed increased test requirements on manufacturers. Today, as flash device test grows in importance in China, manufacturers face growing pressure for reduced cost-oftest, increased throughput and greater return on investment for test equipment. At the same time, the move to integrated flash packages for contactless smart card applications adds a significant further challenge to manufacturers seeking rapid, low-cost test.     

Theoretical analysis of the relationship between the Brillouin gain coefficient and the strain in the optical-fiber sensors

The relation between the power of the Brillouin signal and the strain is one of the bases of the distributed fiber sensors of temperature and strain. The coefficient of the Bfillouin gain can be changed by the temperature and the strain that will affect the power of the Brillouin scattering. The relation between the change of the Brillouin gain coefficient and the strain is thought to be linear by many researchers. However, it is not always linear based on the theoretical analysis and numerical simulation. Therefore, errors will be caused if the relation between the change of the Brillouin gain coefficient and the strain is regarded as to be linear approximately for measuring the temperature and the strain. For this reason, the influence of the parameters on the Brillouin gain coefficient is proposed through theoretical analysis and numerical simulation.     

An improved parallel thinning algorithm with two subiterations

The parallel thinning algorithm with two subiterations is improved in this paper. By analyzing the notions of connected components and passes, a conclusion is drawn that the number of passes and the number of eight-connected components are equal. Then the expression of the number of eight-connected components is obtained which replaces the old one in the algorithm. And a reserving condition is proposed by experiments, which alleviates the excess deletion where a diagonal line and a beeline intersect. The experimental results demonstrate that the thinned curve is almost located in the middle of the original curve connectivelv with single pixel width and the processing speed is high.     

Novel fiber-optical interferometer with miniaturized probe for in-hole measurements

Today, micro-system technology and the development of new MEMS （Micro-Electro-Mechanical Systems） are emerging rapidly. In order for this development to become a success in the long run, measurement systems have to ensure product quality. Most often, MEMS have to be tested by means of functionality or destructive tests. One reason for this is that there are no suitable systems or sensing probes available which can be used for the measurement of quasi inaccessible features like small holes or cavities. We present a measurement system that could be used for these kinds of measurements. The system combines a fiber optical, miniaturized sensing probe with low-coherence interferometry, so that absolute distance measurements with nanometer accuracy are possible.     

Development of the readout system for waveguide multilayer optical card

Waveguide multilayer optical card （WMOC） is a novel storage device of three-dimensional optical information. An advanced readout system fitting for the WMOC is introduced in this paper. The hardware mainly consists of the light source for reading, WMOC, motorized stages addressing unit, microscope imaging unit, CCD detecting unit and PC controlling ＆ processing unit. The movement of the precision motorized stage is controlled by the computer through Visual Basic （VB） language in software. A control panel is also designed to get the layer address and the page address through which the position of the motorized stages can be changed. The WMOC readout system is easy to manage and the readout result is directly displayed on computer monitor.     

Study of waveguide coupling efficiency in hybrid silicon lasers

This paper presents a new method to increase the waveguide coupling efficiency in hybrid silicon lasers. We find that the propagation constant of the InGaAsP emitting layer can be equal to that of the Si resonant layer through improving the design size of the InP waveguide. The coupling power achieves 42% of the total power in the hybrid lasers when the thickness of the bonding layer is 100 nm. Our result is very close to 50% of the total power reported by Intel when the thickness of the thin bonding layer is less than 5 nm. Therefore, our invariable coupling power technique is simpler than Intel＇s.     

Collinear phase-matching study of terahertz-wave generation via difference frequency mixed in GaAs and Inp

The collinearly phase-matching condition of terahertz-wave generation via difference frequency mixed in GaAs and InP is theoretically studied. In collinear phase-matching, the optimum phase-matching wave hands of these two crystals are calculated. The optimum phase-matching wave bands in GaAs and lnP are 0.95-1.38μm and 0.7-0.96μm respectively. The influence of the wavelength choice of the pump wave on the coherent length in THz-wave tuning is also discussed. The influence of the temperature alteration on the phase-matching and the temperature tuning properties in GaAs crystal are calculated and analyzed. It can serve for the following experiments as a theoretical evidence and a reference as well.     

Effects of the alloy compositions on the phonon-polaritons in ternary mixed crystals

Composition dependence of bulk and surface phonon-polaritons in ternary mixed crystals are studied in the framework of the modified random-element-isodisplacement model and the Bom-Huang approximation. The numerical results for Several Ⅱ - Ⅵ and Ⅲ- Ⅴ compound systems are performed, and the polariton frequencies as functions of the compositions for ternary mixed crystals AlxGa1-xAs, GaPxAS1-x, ZnSxSe1-x, GaAsxSb1-x, GaxIn1-xP, and ZnxCd1-xS as examples are given and discussed. The results show that the dependence of the energies of two branches of bulk phonon-polaritons which have phonon-like characteristics, and surface phonon-polaritons on the compositions of ternary mixed crystals are nonlinear and different from those of the corresponding binary systems.     

New insert layer structure OLEDs

An insert layer structure organic electroluminescent device（OLED） based on a new luminescent material （Zn（salen）） is fabricated. The configuration of the device is ITO/CuPc/NPD/Zn（salen）/Liq/LiF/A1/CuPc/NPD/Zn（salen）/Liq/LiF/A1. Effective insert electrode layers comprising LiF（1nm）/Al（5 nm） are used as a single semitransparent mirror, and bilayer cathode LiF（1 nm）/A1（100 nm） is used as a reflecting mirror. The two mirrors form a Fabry-Perot microcavity and two emissive units. The maximum brightness and luminous efficiency reach 674 cd/m^2 and 2.652 cd/A, respectively, which are 2.1 and 3.7 times higher than the conventional device, respectively. The superior brightness and luminous efficiency over conventional single-unit devices are attributed to microcavity effect.