Linking microcomputers and dedicated word processing systems for increased productivity

With the decline in cost of hardware, more and more professionals are acquiring personal computers at their desk. Most common uses of these office computers are word processing and spreadsheet (e.g. LOTUS 123, MULTIMATE, FRAMEWORK, etc.¹) applications. Professionals typically generate text directly on the personal computer (in lieu of hand written copy) and use spreadsheet programs to tabulate and analyze collected field data. A problem in some offices is integrating text and data prepared on the personal computer with existing dedicated word processing systems which have existed in many office environments for some time. One solution is to have the text and tabulated data retyped into the word processing system, however, this approach is not an effective use of resources.

The Industrial Hygiene Section, Industrywide Studies Branch (DSHEFS), NIOSH has developed procedures for electronically linking personal microcomputers with an office-wide word processing system. Using a commercially available hardware “board” (which may be inserted into an open slot in an IBM-PC or compatible), the rough copy report and tabulated spreadsheet data can be electronically linked and “uploaded” from a microcomputer to the word processing system. At NIOSH, a WANG word processing system is the office-wide system for preparing and publishing final reports. This system is not readily compatible with IBM-PC (or similar) microcomputers; however, using MULTIMATE (a commercially available word processing program) and the hardware board, documents can be readily transferred to the WANG virtually unchanged from the copy generated on the microcomputer. Importantly, spreadsheet data can be similarly transferred and linked to a document on the WANG wordprocessing system.

This paper describes the sequence of steps, along with necessary hardware and software, to achieve the integration of written documents and numerical data (analyzed by LOTUS 123) from a microcomputer to a office-wide WANG word processing system.     

A microcomputer database system for facilities design

A data base management system which is dedicated to plant layout type data, and should be useful to the practicing industrial engineer, is presented. The data items utilized in the data base for this microcomputer software represent only a minimal subset of the data which one would want for the creation of a proper, industrial facility design; however, they were felt to represent a good starting point for the creation of a microcomputer data base system which would aid a layout engineer. The Knowledgeman software (Micro Data Base Systems, Inc.) was used for this project; it consists of a relational database and an electronic spreadsheet. Two plant layout examples are presented to demonstrate the use of the software.     

32位微机实验系统的设计与开发

为了利用现有的微机原理实验箱进行32位微机原理实验教学,该文介绍了一种32位微机原理实验系统的设计方法,该方法通过微机系统内部PCI总线扩展出低速ISA总线接口信号,从而将微机系统内的部分资源引出并利用,对实验箱上的模块进行操作并进行实验。利用该实验系统可全面支持＂微机原理与应用＂及＂微机接口技术＂的各项实验内容。     

Peer taught microcomputer skills: An untapped resource for stretching the budget

This article presents a solution to the problem of providing students with microcomputer education without significant increases in funding. One method of providing students with software training is through peer teachers. Students teaching other students to use software is an untapped resource that should be carefully considered. The article describes an approach in which students who were familiar with Lotus ^1-2-3®1 were enlisted to teach other students the Lotus® spreadsheet software. Significant savings in faculty time were obtained through the peer teaching approach.     

激光电源的单片机控制软、硬件设计

本文主要叙述了以89C51为核心的激光电源单片机控制系统。介绍了用单片机控制激光电源的软、硬件设计新方法,尤其是将数据库的软件工程设计方法用于单片机系统,使整体设计简单、明了,此法具有一般性。文中给出了激光电源系统的硬件原理框图、数据流图、软件流程图和主要结果。     

A microcomputer-based decision support system for the management of lumber mill production

Production management for a lumber mill includes the choice of saw patterns, as well as drying, sorting, grading and materials handling operations. The decision support system developed for an existing mill includes a linear programming (LP) model, data base software and a spreadsheet aid for detailed production scheduling. The LP model was structured to minimize total production cost subject to constraints on the available supply of raw material, the required output of timber, the available saw patterns and capacities on production facilities and materials handling operations. The LP solution is used by the spreadsheet support program to schedule product flow on a daily basis. The system was implemented on a microcomputer.     

一种提高系统搜索效率的BM改进算法

针对在线式微机防误系统中字符串匹配的特点以及BM算法匹配性能不足的问题,提出一种BM改进算法——WBM算法,以进一步缩短算法的匹配时间。去掉好后缀规则,适当改进坏字符规则,构建适用于系统维护的框架网络数据结构环境,将WBM算法应用于框架网络,实现基于该算法的微机防误系统软件。实验比对结果表明,WBM算法在BM、WBM、BMH、QS这4种对比算法中速度最快,且同硬件测试CPU使用率为0.76%,应用该算法使搜索时间缩短为3.9 s,搜索准确度提高到99.5%,能明显提高知识在计算机中搜索的效率,与框架网络相结合后,进一步节省了微机防误系统的维护时间。     

微处理机控制铣床刀具补偿进给

本文介绍了用微处理机实现数控机床刀具补偿的一个应用实例,叙述了用于刀具补偿的 专用单板计算机的软件和硬件设计思想,介绍了以通用单板机为手段的简易开发方法.     

可在线更新的多用途数据采集系统的设计

介绍了一种可在线更新的多用途数据采集系统的设计方案。对微控制器、传惑器信号采集、脉冲信号采集等硬件电路进行了详细描述,同时也阐述了系统的软件设计思想,并着重说明了编译原理相关机制在系统中的应用。通过系统,用户可根据需要在上位机定制公式并随时下载到下位机进行采集运算,使数据采集系统具备了计算方法及相关参数的在线更新功能,扩展了系统的应用场合。     

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.     

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.     

高精度风扇转速测试仪的研制

介绍一种基于89C51单片机系统的高精度风扇转速测试仪的测量原理、硬件组成和软件设计.该仪表采用在中低速时测速精度较高的M/T测速法,应用反射式激光传感器对信号进行采集,使系统在宽量程范围内实现了对风扇转速高精度、实时、方便地快速在线测量.     

动态数据访问方式探讨

随着计算机网络技术的日益“平民化”和软件信息化的发展,以及由各种在线功能如在线翻译、在线杀毒等联想到的给用户带来的方便,基于Web下的软件开发（网络化软件）成为时下的研究热点。而此过程中必须要面对的一个难题是制作的软件如何在客户端访问,即实现服务器端软件与浏览器（IE）的“无缝焊接”,这就涉及到动态数据访问技术。本文将着眼于实际工程和系统开发的需要,详细地分析和对比了动态数据访问几种方式,特别是基于PHP的动态数据访问方式。     

一种电子扫描压力测量系统

为了满足风洞试验以及工业对多点、快速、高精度压力测量的要求，作者开发了ＥＳＰＭＳ－１型电子扫描压力测量系统。本文介绍了该系统的结构及特点、传感器信号的放大及选通、三点校准原理、系统软件及系统联调等。该系统特别适用于风洞、发动机等实验，也可用于各种测控系统中。     

Interactive software to solving the resource balancing problem

The proposed paper presents a software developed for the microcomputer to solving the resource balancing problems. The developed software is an interactive concept program and can be used by people with or no experience in the computer programming. The program consists of two linked modulus which are working complementary. The program is designed in the “MENU” concept and for the practical using, the data files option proposed for the running of the program with the same production network. The designed program is flexible and with a low cost microcomputer system, the program is definitly an economic and practical tool to solving the resource balancing problems. To identify the potential ability of the proposed software and to indicate how the software can be used a complete example will be discribed.     

如何利用Excel实现工资核算

Excel是一款处理数据、制作报表的电子表格软件。它使用起来方便,不仅可以用于个人事务性处理,而且在财务、统计领域得到了广泛应用。作者根据本单位的实际情况,利用Excel设计工资核算,使用起来非常方便。月底工资管理部门所要做的工作,只是在"变动项"工作表中输入职工工资中的变动数据,其他各项处理均由系统自动完成。     

基于GSM的水位与降雨量在线监测系统

本文设计的基于GSM水位与降雨量在线监测系统,是通过现有的GSM网络,利用短消息方式,进行单片机和TC35模块开发的远程数据采集;实现了远距离采集数据与GSM无线数据传输技术相结合,完成江河、湖泊及水库等水位和该区域降雨量的远程在线监测,摆脱有线困扰,能够实现水文站的无人值守功能.     

Statistical games and software tools for quality assurance based on statistical process control

This paper proposes two kinds of statistical games constructed to show how to achieve quality assurance system based on SPC(statistical process control) by using simple models and software tools. Proposed games are Coin Shooting Game and Paper Glider Releasing Game. These games can be played on a table using simple materials, and are easy to play. These are described by showing actual data.

Participants of these games get necessary outputs timely by using prepared software tools so that they can execute an effective and efficient decision. These save time and also raise the level of understanding how to achieve quality assurance system based on SPC.     

统计分析软件驱动的可重构SPC系统

全面集成化的制造企业信息系统需要多样化、敏捷化的统计过程控制（Statistical Process Control,SPC）系统,以实现基于数据的产品质量管理决策。基于领域分析构造了SPC领域模型,设计了基于通用统计分析软件平台的可重构SPC系统框架,以具有扩展点的组件化可重构架构满足制造企业应用模式和配置模式的可重构需求。然后采用SPSS（Statistical Package for the Social Science,社会科学统计软件包）实现了可重构SPC系统,通过引入SPSS组件,执行SPSS Syntax命令,实现对SPC的可视化统计分析。最后以加工误差分析实例说明系统的有效性,为全面质量控制提供了一种数字化应用。     

Cost management system based on EUC concept

Based on the End User Computing (EUC) concept, this paper proposes a generic system using simple macro routines of a spreadsheet software (Microsoft Excel) that can be used in a practical way between the different users of each level of an organization. This system is not only for managers, but also for employees in order to supply common information and enable simulations and decision making in the scope of each level's responsibilities. As a cost accounting system model, this paper discusses the possibility to use it in 4 different departments : Purchasing, Parts-production, Assembly and Sales departments.