ActieX组件支持IE

Sybase公司12月8日正式宣布交付Formula One 5.0和First Impression 5.0。这些电子表格和制图ActiveX组件是Sybase公司基于组件的开发工具——Powersoft Visual Components产品线中的旗舰产品。 First Impression和Formula One 5.0版提供了对Internet的支持,     

Formula One ActiveX控件和Datastore对象的使用与结合

Formula One ActiveX《以下简称:Formula)是可视化的电子表格控件,具有很强的数据表现功能,但是它不能直接对数据库进行访问和信息处理。Datastore系统对象是PB5.0独有的不可视数据窗口控件,具有和一般Datawindow控件一样的数据访问和处理能力,由于它是不可视的,因而也无     

用Formula One在PB中实现可视化图表

本文介绍了电子表格控件Formula One ActiveX的主要特点，分析了集装箱船舶积载及其可视化需求，重点阐述如何使用该控件在PB中实现集装箱船舶积载可视化，用表格和图表方式直观地体现集装箱船舶积载过程和数据，主要包括：模板设计技术，数据记录表设计，箱位在平面图中坐标转换计算方法，集装箱信息在平面图的表示与积载操作图表显示等。     

一种基于区域分布树的电子表格最少重算算法

当电子表格技术被应用于服务器端的计算时，计算的性能显得尤为重要，行之有效的重算算法能够大大提高电子表格在服务器端的计算能力。本文针对电子表格软件Formuia One 6．1中采取的增量持续最小重算算法在性能上的瓶颈，提出了一种新的基于区域分布四叉树的最少重算算法，并有效地提高了电子表格计算的性能，并讨论了算法的复杂度，给出了三组算法的实验对比测试结果。     

基于Web数据库的图形报表技术研究

分析了基于Web平台数据库图形报表系统的实现技术并提出了基于Web平台图形报表系统的架构，阐述了Java Servlet技术、Formula One组件技术，基于前面所述架构和Servlet、Formula One等技术给出了制作图形报表的方法和实现技术。研究了对Web应用极具前途的XML数据库的模式及查询，得出了初步的结果。     

基于ActiveX控件的动态报表实现

地基监测在现代高层建筑工程中非常必要,而其数据的处理和动态报表的制作一直是个难题.文中就这个问题的解决开发了地基监测信息系统,并通过Formula One控件成功地解决了对选定变化的单元格区域的合并,设计和实现了动态报表.文章分析了地基监测的发展趋势.在此基础上,阐述了一个处理其数据和制作动态报表的系统,并详细介绍了利用ActiveX控件来动态实现制作报表的方法,最后指出利用Formula One控件可以很好地解决这一类动态报表的设计和实现的问题.     

利用Formula One控件实现数据窗口及其信息交换

为了满足一定的数据组织格式以及实现数据交换与共享,在数据窗口设计中引入了Formula One ActiveX控件.介绍了一种通用的设计方法,在此基础上实现一个应用实例,并对其开发程序的性能进行了总结.     

基于ActiveX控件的动态报表实现

地基监测在现代高层建筑工程中非常必要，而其数据的处理和动态报表的制作一直是个难题。文中就这个问题的解决开发了地基监测信息系统，并通过Formula One控件成功地解决了对选定变化的单元格区域的合并，设计和实现了动态报表。文章分析了地基监测的发展趋势。在此基础上，阐述了一个处理其数据和制作动态报表的系统，并详细介绍了利用Actjvex控件来动态实现制作报表的方法，最后指出利用Formula One控件可以很好地解决这一类动态报表的设计和实现的问题。     

用Visual Basic 6.0语言开发液-液相平衡关联与预测计算软件

利用Visual Basic6.0语言开发液－液相平衡关联与预测计算软件。软件利用Formula One6.0控件，可以很方使地从Excel直接导入和输出数据，解决了需大量输入相平衡数据的问题，软件可在Windows 9X操作平台下独立运行，具有界面友好、操作方便、运行可靠稳定等优点。     

和速度相关和激情有染 6款男士动心腕表

IWC工程师计时腕表银箭特别版 IWC万国表与梅赛德斯AMG马石油F1车队（MERCEDES AMG PETRONAS Formula One Team）开展全新合作,并以此为契机推出经全面改进的2013年工程师系列腕表。     

Complex petrogenetic modeling using spreadsheet software

Continuous melting and open-system fractional crystallization modeling can be performed readily using spreadsheet software. Separate portions of the spreadsheet are used for a distribution coefficient matrix, calculation of the bulk distribution coefficients, and a work area for the entry of data and the calculation of new compositions and mineral mass fractions. The relative ease of creating the models in the spreadsheet format, the ability to recalculate quickly the model when any of the variables are changed, and the graphics capabilities of the software, demonstrate the advantages of this approach as opposed to writing a computer program for the same task.     

Performance evaluation of manufacturing systems: a spreadsheet model

In this paper, we describe the spreadsheet modeling of manufacturing systems which are represented by multi-server and multi-product open networks. The spreadsheet software is characterized by easy data manipulation, on-screen numerical and visual feedback, fast calculation (what-if analysis), and its availability. So far, most spreadsheet models of this type have been used to solve static and deterministic problems in manufacturing systems, ignoring most of the uncertainties. We propose here that a spreadsheet can be implemented for capturing not only static features but also stochastic behaviour of manufacturing systems. The experiments show that the results from the spreadsheet model are reasonably close to those from the other existing approaches. The proposed spreadsheet model could be applied by an engineer to the modeling of manufacturing systems, especially for a first-cut design stage, utilizing his/her own spreadsheet software.     

Visual information chunking in spreadsheet calculation

Spreadsheet calculation causes a heavy memory load, since it is necessary to remember complex cell and calculation systems. A series of experiments were carried out to study the role of visual information chunking in spreadsheet calculation. The experiments showed that a possibility to visual information chunking substantially decreases the memory load caused by spreadsheet calculation. If subjects are able to induce the structure of a formula or a network of connected formulas, they usually learn it fast. The surface structure of a formula may cause subjects essential difficulties in chunking. Badly ordered formula networks, in which cell layers are embedded within each other and references cross each other, are difficult to learn and remember. Subjects are not able to abstract the deep structure and encode formula networks.     

一种类Spreadsheet结构的信息汇聚方法

SpreadSheet样式的数据操作具有很好的可用性,但在SpreadSheet结构中如何表示并操纵XML数据以及如何使用复制、粘贴、移动等简单操作表示复杂的XQuery查询是两个难点问题。提出一种基于XML模式的操作表示方法,将复杂的XQuery查询语句分解为XML模式上的粘贴节点、移动节点等操作,从而可以表示XQuery语言的核心语句FLOWR。在Spreadsheet结构中将XML模式显示为嵌套表格,用户在嵌套表格上的操作转换为XML模式上的操作。使用该方法可以构造多数据源的XQuery查询,并实现了概念验证的原型系统。与当前流行的XQuery查询构造工具相比较,原型系统更适合于无编程经验的最终用户构造XQuery查询。     

A proposed method to use electronic spreadsheets to develop quality control charts

The combination of the personal computer and spreadsheet software provide an inexpensive and accurate capability to use control charts for the quality contol average and standard deviation. The popular spreadsheet program, Lotus 17ndash;2–3, is limited to graphing six variables. Eight are needed to graph both the average and standard deviation control charts on a single screen. This article examines several methods to overcome this limitation. All calculation needed are performed and a series of charts are drawn for the readers examination.     

基于VB设计的风能资源评估软件

文章介绍了一个基于VB编程的风能资源评估软件,阐述了用VB编程的计算机程序实现对风电场测风数据的分析计算及其使用方法,进而达到对风能资源各参数的计算的简化。由NRG软件得到的现场测风数据导出并保存在Excel表格里,通过VB编程,调用Excel表格里的数据,并在复杂计算中调用MATLAB完成复杂公式的计算,最终实现风资源参数自动计算的效果。根据新疆吐鲁番地区小草湖风电场一年的测风数据,对该软件进行了计算演示。     

The electronic spreadsheet as a didactic learning enhancement

A variety of quantitative techniques (such as capital budgeting or linear programming) may be understood more fully by students when they are able to work through relatively simple applications of the techniques by hand. Unfortunately, such manual computations are inherently susceptible to arithmetic errors. The authors propose that students use the electronic spreadsheet to work out these types of problems during their initial learning stage. An advantage of the electronic spreadsheet for this purpose is the automatic calculation of data by the program thereby eliminating the usual arithmetic errors. As long as appropriate formulas are correctly entered into the spreadsheet, the results should be correct.The method presented by the authors does not yield general solutions to capital budgeting or to linear programming problems. Rather, the methodology requires the student to think through the solution process while removing some of the usual drudgery and potential inaccuracies of manual solutions.     

MATNORM: Calculating NORM using composition matrices

This paper discusses the implementation of an entirely new set of formulas to calculate the CIPW norm. MATNORM does not involve any sophisticated programming skill and has been developed using Microsoft Excel spreadsheet formulas. These formulas are easy to understand and a mere knowledge of the if-then-else construct in MS-Excel is sufficient to implement the whole calculation scheme outlined below. The sequence of calculation used here differs from that of the standard CIPW norm calculation, but the results are very similar. The use of MS-Excel macro programming and other high-level programming languages has been deliberately avoided for simplicity.     

Spreadsheet template approach for nonlinear regression estimation

Industrial Engineers may encounter variables which are nonlinearly related such that the relationship cannot be transformed to one which is linear in the unknown parameters. One instance where this can occur is a learning curve which approaches a non-zero asymptote. This paper presents a spreadsheet template for implementing the Gauss-Newton Method for solving such nonlinear regression estimation problems.