43 results about "Spreadsheet software" patented technology

A distributed spreadsheet application executes at a server and a client in a network. The networked spreadsheet application can generally be used without requiring a user to install any specific spreadsheet software prior to using the application. In one implementation, the spreadsheet application may include a client engine that executes within browser programs of a plurality of client computing devices and server logic. The server logic may be configured to distribute the client engines to the plurality of client computing devices of the spreadsheet application when requested through the browser programs of each of the plurality of client computing devices. The server logic synchronizes a single spreadsheet document that is simultaneously open at the plurality of client computing devices.

The invention provides advanced software architected to leverage the operational data volumes from information technology (IT), intelligent devices and machines supported and maintained by IT or end users for use by business groups or individuals in order to create low Total Cost of Operation (TCO) processes that enable data sources to be transferred, modified, and computations performed based on the needs of the end users operating independently or within the enterprise data assets to cost-effectively capture any data source and place that within the enterprise's standard data structures and processes. The invention provides the end user options with capability to re-structure, copy, and re-position data for ongoing corporate applications via a selection of options methodology that is supported by usage of the end user's versions of spreadsheet software.

A distributed spreadsheet application executes at a server and a client in a network. The networked spreadsheet application can generally be used without requiring a user to install any specific spreadsheet software prior to using the application. In one implementation, the spreadsheet application may include a client engine that executes within browser programs of a plurality of client computing devices and server logic. The server logic may be configured to distribute the client engines to the plurality of client computing devices of the spreadsheet application when requested through the browser programs of each of the plurality of client computing devices. The server logic synchronizes a single spreadsheet document that is simultaneously open at the plurality of client computing devices.

An electronic medical records system is implemented in spreadsheet software utilizing an electronic master patient form adaptable to a physician preferences, storing patient records in that form in an electronic folder and interacting with software modules to automate physician office administrative tasks.

A method of displaying data on a multilevel screen display is disclosed. The method comprises assigning screen designation codes to respective groups of data, and determining the physical screen on which each group of data is displayed. The screens may comprise layered liquid crystal displays. The method is suitable for use with spreadsheet software, where a user is able to see overlaying spreadsheets simultaneously.

The invented software system and method is an easy-to-use, browser-based solution, providing casual business computer users the ability to create, modify, and monitor business processes, much like spreadsheet software allows users to quickly complete complex math calculations. It is built on a “fill in the table” interface so any user can create a customized process within minutes, without having to understand how to flow chart or program a computer. Automatic alerts regarding work to be done, sent through a normal email client, are included as part of the product's feature set as well as a chronological history and a variety of default reports. Processes are easy to set up, deploy, and control, and participation in those processes is simple and fast. Any process can be immediately launched and is saved as a template for later use or modification. Templates can be shared or sold to other users, as well. Briefly, the invented system and method includes software running on a server accessible via a network, e.g. a local area network (LAN) or wide area network (WAN) such as the world-wide web by subscribing and logged on one or more proximate (centralized) or remote (distributed) users with laptops, desktops or workstations. The software features a friendly user interface with toolboxes, menus and buttons for patterned templating of processes and tasks and for management and oversight of the same. Process authors can construct templated processes in a table-drive manner that is parse-able by a process compiler and executable by a process engine. Process users can create task assignees chosen at will or from their own address books. Task assignees can use the software to follow optionally check-listed task steps and start / stop dates and times can be monitored and logged. Finally, reports can be generated. E-mail is the preferred conveyance of task-notification messages among various users of the invented software.

A script-based application generation for spreadsheet software reads from one or more spreadsheets rendered by a spreadsheet program, description written in said text-based language, the text-based language for describing user interfaces, data models and / or workflow models or combinations thereof The text-based language is independent of the spreadsheet program. The description is parsed and from the description one or more user interfaces, data model or workflow model or combinations thereof are generated in the spreadsheet program.

The invention describes programming methods that allow unmodified web-browsers to reproduce the rich display, interactivity, printing, and reliability only found previously with specialist electronic form software. Embodiments of the inventions include improving the display of forms created with images and HTML form elements, enhanced control of entry of data in form fields, enhanced printing, multipage forms working offline, and forms and data being saved offline.

An efficient method and system, which uses a Key Identifier (Key-ID), Region Identifier (Region-ID) and Cell Collection Expression (CCE) to establish a spreadsheet software base for automated data manipulation within an electronic spreadsheet program or the like. A Key-ID is either part of or the entire content of a cell or group of cells drawn from an existing spreadsheet database or inserted into the database by manual prior art spreadsheet data operations or through simple programming. The purpose of the Key-ID is to organize and separate spreadsheet data into manageable data sets of similar construct. The Region-ID is used to specify the region containing the Key-ID and is defined using the Row or Column Identifier (RC-ID) and optional Identifiers-Sheet Identifier, File Identifier, Directory Identifier. The CCE represents or identifies the cell(s) containing the Key-ID within a region of interest specified by the Region-ID and is composed of CCE elements. Each CCE element is a single cell location containing the Key-ID within a manageable data set and is used as a reference point for data manipulation. By assigning a standard coordinate system to each data set with the CCE element as the origin (0,0), the location of the target cells (source and / or destination cells), which must be identified in any spreadsheet data operation, can be specified based on their relative location to the origin in each data set. As each data set can be identified using a single CCE, the fixed relative location of the target cells to the CCE element will allow any spreadsheet data operation to be performed on every data set within the database systematically and automatically by combining the invention with existing spreadsheet capability.

Spreadsheet-based tools for converting dimensional quantities from one set of dimensional units to another quickly and efficiently as well as correctly and automatically performing mathematical calculations using dimensional and dimensionless quantities are described. More particularly, the computer-based systems, methods and spreadsheet software perform mathematical calculations with both dimensional and dimensionless quantities, allowing extensive flexibility and customization so that both the user input and the computer output use the units that are most useful and convenient.

A data display system (10) and a patent map forming system (20) give evaluation values obtained by a predetermined evaluation axis or an arbitrarily set evaluation value in cooperation with each other, and forms a map sheet (MS) on the basis of the evaluation values. The data display system (10) acquires a first-class identification code such as a publication number from a basic data sheet (DS) obtained by listing bibliographical information or the like of a patent input by a spreadsheet software (22) from an input file, and an identification code conversion unit converts (12) the first-class identification code into a second-class identification code. A patent data server (SV) is directly accessed by the second-class identification code to read an abstract, a representative drawing, all documents, drawings, and the like, serving as detailed data, thereby displaying these data on a display (DP).

With spreadsheet software, such as the MICROSOFT EXCEL, a radar chart can be compiled by the use of data in a table made.

A script-based application generation for spreadsheet software reads from one or more spreadsheets rendered by a spreadsheet program, description written in said text-based language, the text-based language for describing user interfaces, data models and / or workflow models or combinations thereof. The text-based language is independent of the spreadsheet program. The description is parsed and from the description one or more user interfaces, data model or workflow model or combinations thereof are generated in the spreadsheet program.

A fully-integrated computer-aided method for sizing and building paper reels from which a plurality of smaller rolls of paper are created. Data pertaining to the measurements of paper reels and the rolls to be built therefrom is entered into a computer programmed with electronic spreadsheet software, which stores, validates and computes measurement values so that the diameter of the paper reel from which the smaller paper reels are being built is of the correct size to minimize waste.

According to certain aspects, the invention provides advanced software architected to leverage the operational data volumes from IT, intelligent devices and machines supported and maintained by IT or end users for use by business groups or individuals in order to create a low Total Cost of Operation (TCO) processes that enable data sources to be transferred, modified, and computations performed based on the needs of the end users operating independently or within the enterprise data assets To cost effectively capture any data source and place within the enterprise' standard data structures and processes. According to another aspect, the invention provides the end user options with capability to re-structure, copy, and re-position data for corporate and end users for ongoing corporate applications via a selection of options methodology that is supported by usage of the end user versions of spreadsheet software. The purpose is to reduce or eliminate conventional programming or parameter requirements needed in current software solutions to work with data from incompatible sources. One advantage is that the invention can significantly reduce the cost from using and re-formatting these numerous, rapidly growing, incompatible volumes of operational data and information. In one implementation, the invention achieves this with. a solution supporting the end user's data criteria without being impacted by IT complexity, security and data risk issues.

The invention discloses several new functions of a spreadsheet. On the basis of the currently general spreadsheet software such as excel or wps and the like, several new functions of combining cells, increasing lines of the spreadsheet, deleting English characters, Chinese characters and numeric characters, screening according to occurrence number of characters and the like are added. According to the new functions disclosed by the invention, service efficiency of a user can be improved, and unnecessary space waste of the spreadsheet is reduced.

A data display system (10) and a patent map forming system (20) give evaluation values obtained by a predetermined evaluation axis or an arbitrarily set evaluation value in cooperation with each other, and forms a map sheet (MS) on the basis of the evaluation values. The data display system (10) acquires a first-class identification code such as a publication number from a basic data sheet (DS) obtained by listing bibliographical information or the like of a patent input by a spreadsheet software (22) from an input file, and an identification code conversion unit converts (12) the first-class identification code into a second-class identification code. A patent data server (SV) is directly accessed by the second-class identification code to read an abstract, a representative drawing, all documents, drawings, and the like, serving as detailed data, thereby displaying these data on a display (DP).

This invention disclose a device for displaying and operating electronic forms including a device displaying and operating work lists, a device for displaying work list labels in the work book, a device for longitudinally rolling the work list, a device for horizontally rolling to operate the work list a device for altering size of the work list, said device includes devices displaying and operating work list based on ordinary mode, printing preview and page-by-page preview and the device displaying and operating the work book in the electronic form information data of the work book.

The present invention provides an application generation apparatus and an application generation method. The application generation apparatus of the present invention includes: determination means that determines whether a URL is input into a preset cell among a plurality of cells composing a spreadsheet displayed by executing spreadsheet software; and generation means that causes another terminal to acquire an HTML file based on URL information included in code information, and generates a parameter file for defining an application having a function of displaying a browser based on the HTML file, in a case in which the determination means determines that the URL is input.

The invention discloses an efficient acquiring method and system for gas chromatographic retention indices. The method comprises a data acquisition step of acquiring retention data of an n-alkane sample and retention time RTx of unknown compounds through gas chromatographic analysis, a data input step of reading the carbon number, the retention time and the retention indices of the n-alkanes and the retention time RTx of the unknown compounds obtained in step A, and sequentially inputting the data into table cells of Excel, and a retention indices calculating step of setting a function in the Excel for judgment, and calculating the retention indices RI of the unknown compounds according to a corresponding formula in the corresponding table cells of the Excel if the retention time RTx of the unknown compounds is between the retention time of Cn and Cn+1 n-alkanes. The system comprises a gas chromatographic analysis module, a data input module and a data calculating module. By virtue of the method and the system disclosed by the invention, the Excel is used for simply and quickly calculating the retention indices of the unknown compounds in batches by reading the gas chromatographic analysis data.

According to the present invention, even a user lacking the knowledge of semiconductor testing apparatus can easily generate a test program, and easily perform alternation and correction of the test program. In the present invention, a microprogram of a spreadsheet software being one of the commonly used application software is used to create the test program. Therefore, even a user lacking the knowledge of semiconductor testing apparatus can easily generate a test program, and easily perform alternation and correction of the test program. When the alternation and the correction of the test program are performed, only setting conditions of each sheet are altered and corrected, and the alternation and the correction of the test program are easily performed.

The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides an optimization process executed by spreadsheet functions of a spreadsheet application, and arranged in a functional paradigm for computing optimal parameters for a parameterized system modelled by variables, parameters, and dependent formulas.

The diagram creation device of the present invention ensures a good response irrespective of the volume of data while realizing a wide variety of display modes of figures or tables based on data acquired from a database. The function treating section 41 of the diagram creation device 1 returns a data produced by a content of an instruction input into a cell C of a worksheet A of a spreadsheet soft (add-in section 142a). The data treating section 43 acquires data specified by a function and an entire time-series data having a code which forms argument of the function from a local database 143 and then stores into a data caching section 121. The data acquired from the local database 143 are computed to produce a computed data and stored into a computed data caching section 122. When data specified by the function exists within the data caching section 121 or a computed data caching section 122, the data treating section 43 preferentially acquires them.

The invention discloses an automatic processing system for fracture toughness test results of metallic materials. The automatic processing system comprises a data input and output system and a report sending system which is in communication with the data input and output system, wherein the data input and output system comprises a data input window and a result output window; a textbox and other contents of the data input window are designed according to paper original data; the result output window outputs the test results in sequence, judges whether the test results are valid or not, and calculates data results according to validity criteria; the report sending system comprises a report input window and a report output window, a textbox and other contents of the report input window are designed according to paper test reports, and the report output window outputs the test results and data. The automatic processing system is based on Excel spreadsheet software and can store and calculate the input data and send the reports, and therefore full automation of data processing of fracture toughness tests of the metallic materials and report sending can be achieved.

The application generation apparatus of the present invention includes: determination means that determines whether a URL is input into a preset cell among a plurality of cells composing a spreadsheet displayed by executing spreadsheet software; and generation means that causes another terminal to acquire an HTML file based on URL information included in code information, and generates a parameter file for defining an application having a function of displaying a browser based on the HTML file, in a case in which the determination means determines that the URL is input.

The present disclosure provides a method, an apparatus, and a computer program product to interact with a spreadsheet application for computing the value of a formula that depends explicitly or implicitly on one or more cells designated as variables, based on provided values for the variables, and without modifying any data of the spreadsheet application. In one aspect, the present disclosure provides a method for computing numerical solution of an equation system modelled by one or more variables, parameters, and dependent formulas in a spreadsheet application, using a spreadsheet function of the spreadsheet application.

A machining data generator generates NC machining data specifying machining operations for shaping the external shape of a piston. The machining data generator uses a machining data sheet (provided by a spreadsheet software) describing noncircular part shape data on the shape of a noncircular part and condition data (machining condition data and shape data on shapes of parts other than the noncircular part necessary for shaping the overall shape of the piston). The machining data sheet is prepared beforehand. A machining data generation program reads the machining data sheet in step S4, recognizes directives “start cell” and “end cell” defining a cell region and described in the machining data sheet and fetches matrix data from the cell region in step S5, and fetches condition data other than the noncircular part shape data from the machining data sheet, and calculates NC machining data to be given to a NC machine tool on the basis of the condition data and the noncircular part shape data in step S6. Data management work for individually managing the noncircular part shape data and the other condition data is not necessary, those data can be collectively managed, and the relevant data can be collectively entered.

A machining data generator generates NC machining data specifying machining operations for shaping the external shape of a piston. The machining data generator uses a machining data sheet (provided by a spreadsheet software) describing noncircular part shape data on the shape of a noncircular part and condition data (machining condition data and shape data on shapes of parts other than the noncircular part necessary for shaping the overall shape of the piston). The machining data sheet is prepared beforehand. A machining data generation program reads the machining data sheet in step S4, recognizes directives “start cell” and “end cell” defining a cell region and described in the machining data sheet and fetches matrix data from the cell region in step S5, and fetches condition data other than the noncircular part shape data from the machining data sheet, and calculates NC machining data to be given to a NC machine tool on the basis of the condition data and the noncircular part shape data in step S6. Data management work for individually managing the noncircular part shape data and the other condition data is not necessary, those data can be collectively managed, and the relevant data can be collectively entered.

The embodiment of the invention provides an application development system and method based on a database and spreadsheet software. The system comprises an application designer, a processor and a database; the application designer is used for constructing a logical relationship of data and obtaining a table file with the logical relationship; the processor is used for managing and executing logicof the form file; and the database is used for storing the operation parameters in the application designer and the processor and storing the user data. By installing the application designer, the processor and the database, the processor and the application designer are authenticated, logic design is carried out on the application designer according to user requirements to generate a form file, and the form file generation application is released to process data of the database to obtain a processing result. The interface and logic can be separated, software design is specialized, compatibility is good, and secondary development of the application is facilitated; and cross-server operation and distributed calculation can be realized, complex applications can be constructed, and differentuse requirements of users can be met.

To provide a controller for changing the control operation of the controller, without having to rewrite the control program. A processing-setting contents storage file which is generated through the use of a point list prepared by spreadsheet software, and an I / O list is converted in data by a file-converting part, and stored in a storage part. Then, an alarm control processing part performs a control processing, based on the data.