Follow us on Twitter
twitter icon@FreshPatents


Spreadsheet patents

      

This page is updated frequently with new Spreadsheet-related patent applications.




 Spreadsheet visualization for controlling an industrial process patent thumbnailSpreadsheet visualization for controlling an industrial process
A data processing system for controlling an industrial process includes a cross software platform layer including a data acquisition (da) add-in and calculation add-in coupled to receive measured field data from a field layer including a process data link or communication interface unit (ciu) coupled to processing equipment in the plant having associated field devices including sensors for providing measured field data and actuators configured to run the industrial process. A processor implements a da algorithm to provide the da add-in, a calculation algorithm to provide the calculation add-in, and a visualization algorithm all stored in a memory associated with the processor.
Honeywell International Inc.


 Interactive graphical surface-rendering data visualization tools for tabular data and spreadsheets patent thumbnailInteractive graphical surface-rendering data visualization tools for tabular data and spreadsheets
Graphical tools and primitives are provided for visualization of graphical surfaces from tabular data such as in a spreadsheet. The invention can be used for simple business analysis as well as advanced engineering and science.

 Simulation system, simulation method, and simulation program patent thumbnailSimulation system, simulation method, and simulation program
In a conventional quantitative plan simulation, it is practically impossible to prepare a spreadsheet-type data input template applicable to all types of plans. Thus, a quantitative plan simulation system is required to handle a plurality of spreadsheets containing variously-formatted data.
Integratto Inc.


 Automatic generation of documentary content patent thumbnailAutomatic generation of documentary content
Embodiments are directed towards generating an interactive target document based on a static source document. The source document may be a textbook.
Az, Llc


 Dynamic disaggregation and aggregation of spreadsheet data patent thumbnailDynamic disaggregation and aggregation of spreadsheet data
A computer-implemented method for disaggregating data in a spreadsheet or other data structure hosted on a client computing device includes providing an analyzer module as a plug-in or add-in to a spreadsheet application on a client computing device. The analyzer module locally performs disaggregation and aggregation processes on data in the spreadsheet on the client computing device.
Business Objects Software, Ltd.


 Techniques to present a dynamic formula bar in a spreadsheet patent thumbnailTechniques to present a dynamic formula bar in a spreadsheet
Various embodiments are generally directed to techniques and apparatuses to present a dynamic formula bar in a spreadsheet application. Some embodiments are particularly directed to presenting a dynamic formula bar in a spreadsheet application that may improve usability in particular with large display sizes and/or touchscreen interfaces.
Microsoft Technology Licensing, Llc


 Systems and methods for electronically generating submittal registers patent thumbnailSystems and methods for electronically generating submittal registers
A system and method for generating a submittal register for various construction projects or other items is disclosed. Among other things, the system and method include inputting the construction project specifications in a file format, such as pdf, into a web application interface to convert the same to a text file, applying an algorithm to the text file, identifying all required submittals into a spreadsheet, running a quality control check of the generated spreadsheet, applying an analysis program to the spreadsheet, generating final submittal register by the program, and delivering the final submittal register..
Pype Inc


 Spreadsheet with dynamic cell dimensions generated by a spreadsheet template based on remote application values patent thumbnailSpreadsheet with dynamic cell dimensions generated by a spreadsheet template based on remote application values
A method for generating a spreadsheet is disclosed. The method comprises locking a grid area comprising selected cells of the spreadsheet to prevent data entry into said cells by a user; performing an authentication operation to authenticate the user with a remote application; if the authentication operation authenticates the user then retrieving row and column header information from the remote application in response to said communication displaying said row and column header information from the remote application; and selectively unlocking cells of the grid area with row and column header information..
Apttex Corporation


 Facilitating interaction with a spreadsheet patent thumbnailFacilitating interaction with a spreadsheet
Facilitating interaction with a spreadsheet it provided. One or more input cells of a spreadsheet displayed on a display device of a computer system are automatically detected.
International Business Machines Corporation


 Encoding a spreadsheet program for stream processing patent thumbnailEncoding a spreadsheet program for stream processing
A method, system and computer readable program product are disclosed for encoding a function in a spreadsheet program to execute stream processing on a computing system. In embodiments of the invention, the method comprises encoding one or more formulas in one or more cells of the spreadsheet program, each of the formulas supporting data windows and stream partitioning; designating a first group of cells of the spreadsheet program as input cells for holding input values for the one or more formulas; and designating a second group of cells of the spreadsheet program as output cells for holding output values of the one or more formulas.
International Business Machines Corporation


Spreadsheet compiler for stream processing

A method, system and computer readable program product are disclosed for compiling a spreadsheet to execute stream processing in a computing system. In an embodiment, the method comprises extracting a function from the spreadsheet, said function supporting data windows and stream partitioning in the computing system; and identifying input cells of the spreadsheet for holding input values for the function, and identifying output cells of the spreadsheet for holding output values of the function.
International Business Machines Corporation

Automated helmet gas bladder maintenance system and method

A system and method for easily and frequently checking the gas bladder pressure levels in a sports player's helmet and refilling them to maintain optimum head protection for the player. The system and method involve an electronic hand-held gas pump that wirelessly communicates with an adjacent wireless device that comprises a software application for controlling pump operation.

Parameterizing and working with math equations in a spreadsheet application

The present disclosure is directed to a spreadsheet application with an enhanced understanding of mathematical equations using a mathematical engine and a calculation engine. The disclosed spreadsheet application has many enhanced features, such as, but not limited to: analyzing complex equations, identifying dependencies, converting mathematical notation to spreadsheet notation, connecting variables in an equation to other cells of the spreadsheet, solving or simplifying equations, recommending different display representations of data, and a providing a math display mode..
Microsoft Technology Licensing, Llc

Renderable text extraction tool

Methods for converting an adobe™ pdf document into an editable document is provided. Methods may receive an adobe™ pdf document and displaying the adobe™ pdf document.
Bank Of America Corporation

Automated computer visualization and interaction with big data

Embodiments described herein provide enhanced computer- and network-based methods, techniques, and systems for automatically accessing large bodies of potentially disparate data in a compelling environment without the limitations of access provided by spreadsheet systems and in a uniform manner for all types of data. Example embodiments provide an automated data visualization system (“advs”), which enables users to access data typically provided by backend systems of organizations in an environment that automatically presents the data using user interface patterns that align with the data.
Socrata, Inc.

Systems and methods of mapping storage facilities

In some embodiments, systems and methods are provided herein useful to map storage facilities. Some embodiments a display device; a computer readable memory; and a control circuit to: cause the display device to display a spreadsheet user interface; receive a sectional spreadsheet comprising: a reference location for a section of the storage facility, dimension information for each of a plurality of storage spaces distributed along the section, and a plurality of storage space identifiers specified in different cells of the sectional spreadsheet; determine three dimensional coordinates for each of the plurality of storage spaces based on a cell location of each of the plurality of storage space identifiers, the reference location, and the dimension information; and associate the three dimensional coordinates of each of the plurality of storage spaces with the storage space identifier of each of the plurality of storage spaces in the computer readable memory..
Wal-mart Stores, Inc.

Systems and methods for creating an n-dimensional model table in a spreadsheet

Systems and methods are provided to for automatically generating an n dimensional model table in a spreadsheet program. A model table function or add-in is executed as part of a spreadsheet program.

Techniques for providing user interface enhancements for spreadsheets and tables

A system and method for providing user enhancements for spreadsheets and tables. In one implementation, the system detects a semantic organization event related to one or more data cells in a content-view of the spreadsheet or table.
Dropbox, Inc.

Spreadsheet tool manager for collaborative modeling

According to an embodiment of the present invention, a computer-implemented method for collaborative management of a plurality of modeling tools is described. The method may include receiving, via a processor, a modeling tool request from a user for a modeling tool configured to operate in a spreadsheet application, determining, via an inventory manager, whether a tool record exists matching the modeling tool request, building, via a tool creation module, a new modeling tool configured to operate in the spreadsheet application responsive to determining that a tool record does not exist, and updating, via the inventory manager, a tool record in an inventory database if a tool record does not exist that matches the modeling tool request..
Hamilton Sundstrand Space Systems International, Inc.

Automatic insights for spreadsheets

Automatically identifying insights from a dataset and presenting the insights graphically and in natural language text ranked by importance is provided. Different data types and structures in the dataset are automatic recognized and matched with a corresponding specific analysis type.
Microsoft Technology Licensing, Llc.

Application/document collaboration in a multi-device environment

Application/document collaboration in a multi-device environment is provided. An application and associated document or other content, for example, a spreadsheet application and associated spreadsheet documents and content may be displayed on one or more endpoint display devices.
Microsoft Technology Licensing, Llc

Spreadsheet with unit based math

A system for performing units-based math for spreadsheet cell values includes a processor. The processor is to host a spreadsheet document; parse a formula containing a first measure, a first unit of measure, and an operator; in the event that the first unit of measure and the operator are compatible, determine a resulting measure by applying the operator to the first measure; determine a resulting unit of measure; and associate the resulting measure with the resulting unit of measure..
Workday, Inc.

Spreadsheet with unit based conversions

A system for converting units of measure for spreadsheet cell values includes a processor. The processor is to host a spreadsheet document; associate a first measure and a first unit of measure; associate a second measure and a second unit of measure; determine whether the first unit of measure and the second unit of measure are comparable; and convert the first measure or the second measure into a third measure in the event that the first unit of measure and the second unit of measure are comparable..
Workday, Inc.

Spreadsheet with unit parsing

A system for parsing units of measure for spreadsheet cell values includes a processor. The processor is to host a spreadsheet document; receive a cell value entered into a cell of the spreadsheet document; parse the cell value to determine whether the cell value includes at least a measure and a unit of measure; and associate a valid measure and a valid unit of measure with the cell in the event that the measure and the unit of measure are valid..
Workday, Inc.

Distributed computing system

The present disclosure deals with a method, system and computer readable medium to calculate suggested data, distribute the suggested data over a distributed computing system and update terminals the new suggested data. The application gathers data from shared folders on the central server and calculates the suggested data.
Wal-mart Stores, Inc.

Collaboration database service in conjunction with productivity applications

A collaboration database service allows end users to create and collaborate on custom databases as any other type of productivity content (presentations, word processing documents, spreadsheets, etc.). Providing a more data centric experience rather than formatting centric may allow for a malleable experience.
Microsoft Technology Licensing, Llc

Automatically adjusting spreadsheet formulas and/or formatting

In some embodiments, if a master row is associated with tabular data, a formatting operation replicates formatting from the master row in any new row created at the same level of hierarchy in the tabular data. In some embodiments, the tabular data editor allows users to specify whether formatting set by a user edit in a cell before application of a master row results in a merger or override.
Smartsheet.com, Inc.

Oligonucleotides and methods for detecting kras and pik3ca mutations

Provided are oligonucleotides that are capable of detecting kras and pik3ca mutations in both cancer patients and healthy individuals with high specificity in kpcr assays. When the oligonucleotides are used as forward primers in conjunction with a defined genotyping algorithm spreadsheet, the primers are capable of enhancing detection of kras codon 12, 13, and 61 and pik3ca codon 542, 545, and 1047 single nucleotide polymorphisms (snps) in a background of wild-type sequences.
Siemens Healthcare Diagnostics Inc.

Application module for managing jobs asynchronously

A method to synchronize data between a spreadsheet application and a marketplace application is disclosed. The method includes receiving a request to synchronize data items between the spreadsheet application and the marketplace application, the data items relating to a type of listing of items associated with the marketplace application.
Ebay Inc.

Method and apparatus providing contextual suggestion in planning spreadsheet

Embodiments relate to methods and apparatuses providing contextual suggestion in the environment of a user interface to a planning spreadsheet. Particular embodiments feature an interface engine that is in communication with an underlying data model.
Sap Se

Information-processing equipment based on a spreadsheet

An engineering tool includes a spreadsheet editor configured to display a definition in cells of a spreadsheet, and to edit the definition by setting allocation data of a device to a cell among the cells of the spreadsheet or by setting a calculation defined in some cells among the cells of the spreadsheet in reference to other cells among the cells of the spreadsheet; and an executable module file generator configured to generate, based on the edited definition, an executable module file configured to be executed in an execution environment of a controller in order for the controller to control the device.. .
Mitsubishi Electric Corporation

Streaming data on charts

Systems and methods for charting streaming data and/or attributes of streaming data associated with a spreadsheet are provided. For instance, when streaming data is associated with a spreadsheet, the streaming data may be treated as a new type of data within the spreadsheet.
Microsoft Technology Licensing, Llc

Video on charts

Systems and methods for charting videos and/or attributes of videos associated with a spreadsheet are provided. For instance, when a video is associated with a spreadsheet, the video may be treated as a new type of data within the spreadsheet.
Microsoft Technology Licensing, Llc

Images on charts

Systems and methods for charting images and/or attributes of images associated with a spreadsheet are provided. For instance, when an image is associated with a spreadsheet, the image may be treated as a new type of data within the spreadsheet.
Microsoft Technology Licensing, Llc

Modern spreadsheet arrays

The present disclosure provides a novel approach for creating and referencing arrays as implemented in a spreadsheet application. Aspects of the present disclosure include, but are not limited to: referencing arrays, creating dynamic arrays, collapsing values of an array into a single cell, spilling values of an array to a table, referencing one or more values in collapsed arrays, visually indicating no spill errors while maintaining calculation capabilities thereon, and implicit intersection of data..
Microsoft Technology Licensing, Llc

Suggesting a set of operations applicable to a selected range of data in a spreadsheet

A smart selection engine is provided. The smart selection engine may run in the context of a spreadsheet application on any device, service, or general endpoint capable of running the spreadsheet application.
Microsoft Technology Licensing, Llc

Calculations on images within cells in spreadsheets

Described herein is a system and method for associating images with one or more cells in a spreadsheet application. As described, one or more images may be associated with a single cell in a spreadsheet application or it may be associated with a range of cells in the spreadsheet application.
Microsoft Technology Licensing, Llc.

Calculations on sound associated with cells in spreadsheets

Described herein is a system and method for associating audio files with one or more cells in a spreadsheet application. As described, one or more audio files may be associated with a single cell in a spreadsheet application or it may be associated with a range of cells in the spreadsheet application.
Microsoft Technology Licensing, Llc.

Decks, cards, and mobile ui

The present disclosure provides a novel approach to displaying spreadsheets on mobile devices (e.g., cell phones, tablets, etc.) so that they are more easily viewable by the user. Aspects of the present disclosure provide multiple different views of a spreadsheet and simple transitions among those views.
Microsoft Technology Licensing, Llc

Notifications for rich data types

The present disclosure is directed to systems and methods for implementing notifications for rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data.
Microsoft Technology Licensing, Llc

Autodetection of types and patterns

The present disclosure describes pattern detections for storing multiple values in a compound object. A compound object is a value that stores multiple values in a single cell, wherein those multiple values are organized according to a defined structure.
Microsoft Technology Licensing, Llc

Enriched compound data objects

The present disclosure relates to enriching a compound object with data provided by a third party service, database, or local database. In some embodiments, this is performed by receiving an entry of a value in a cell of a spreadsheet; determining whether the value is related to information provided by a service; based on a determination that the value is related to information provided by the service, selecting the service; displaying a field selection user interface; receiving a selection of one or more fields from the field selection user interface; receiving one or more values associated with the selected one or more fields; and enriching a compound object based on the selected one or more fields and associated one or more values..
Microsoft Technology Licensing, Llc

Compound data objects

The present disclosure describes a value referred to as a compound object that stores multiple values in a single cell, wherein those multiple values are organized according to a defined structure. The compound object may store multiple values according to a known defined data structure such as, for example, a record, vector, matrix, table, or array.
Microsoft Technology Licensing, Llc

Rich data types

The present disclosure is directed to systems and methods for implementing rich data types in a spreadsheet application. Generally, a value being of a rich data type is as a type of value that has context and established relationships with other types of data.
Microsoft Technology Licensing, Llc

Videos associated with cells in spreadsheets

Systems for associating videos with cells of a spreadsheet are provided. Both dynamic data and static data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Operations on dynamic data associated with cells in spreadsheets

Systems for performing operations on dynamic data associated with cells of a spreadsheet are provided. Both dynamic data and static data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Streaming data associated with cells in spreadsheets

Systems for associating streaming data with cells of a spreadsheet are provided. Both dynamic data and static data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Generating sound files and transcriptions for use in spreadsheet applications

Systems for associating audio files with cells of a spreadsheet are provided. Both audio files and data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Operations on sound files associated with cells in spreadsheets

Systems for associating audio files with cells of a spreadsheet are provided. Both audio files and data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Sound associated with cells in spreadsheets

Systems for associating audio files with cells of a spreadsheet are provided. Both audio files and data may be associated with a single cell of the spreadsheet.
Microsoft Technology Licensing, Llc

Images and additional data associated with cells in spreadsheets

Systems and methods for associated one or more images with one or more cells of a spreadsheet are described. As described, a plurality of images may be associated with a single cell or a single image may be associated with a range of cells.
Microsoft Technology Licensing, Llc

Operations on images associated with cells in spreadsheets

Systems and methods for associated one or more images with one or more cells of a spreadsheet are described. As described, a plurality of images may be associated with a single cell or a single image may be associated with a range of cells.
Microsoft Technology Licensing, Llc

Images associated with cells in spreadsheets

Systems and methods for associated one or more images with one or more cells of a spreadsheet are described. As described, a plurality of images may be associated with a single cell or a single image may be associated with a range of cells.
Microsoft Technology Licensing, Llc

Sound on charts

Systems and methods for charting audio files and/or attributes of audio files associated with a spreadsheet are provided. For instance, when an audio file is associated with a spreadsheet, the audio file may be treated as a new type of data within the spreadsheet.
Microsoft Technology Licensing, Llc

Automated structured cloud datatester

Data in different, respective ranges of spreadsheet file cells is compared, and a scope of a formula determined with respect to selected cells of the ranges of cells, wherein the formula pulls input data from selected cells of one range of cells and either pulls input data or generates output data to selected cells of the other range of cells. A review flag is automatically generated in association with data in a flagged cell in response to determining: that the flagged cell is omitted from a consecutive plurality of input data rows or columns; that the selected formula input cells are not consecutive within one of the ranges of cells; and that a high percentage of data values in corresponding cell rows or columns match but that and a location of the flagged cell is shifted from a corresponding cell within the other range..
International Business Machines Corporation

Discussion-based document collaboration

A document collaboration apparatus and method allows users to create, edit, manage, collaborate, and communicate over sets of documents, such as word processor documents, spreadsheets, or other types of documents. A set of documents is obtained and split into a series of fragments that are stored in a secure way in a combination of a relational database and an unstructured content store.

Stream-enabled spreadsheet as a circuit

Converting data transformations entered in a spreadsheet program into a circuit representation of those transformations. The circuit representation can run independently of the spreadsheet program to transform input data into output data.
International Business Machines Corporation

Open fiori apps out of ms excel

The present disclosure provides methods and systems for transferring data entries in a spreadsheet application to a business application for use and analysis. A user device may send a request for creation of a variant based on selected data within the spreadsheet application.
Sap Se

Whatif one-page multi-y axis graphing system for automated optimization and sensitivity analysis

A graphing system (fig. 2) and method (200) for generating a one-page multi-y axis graph (207) for analyzing alternate scenarios.

Framework for data extraction by examples

Various technologies described herein pertain to controlling automated programming for extracting data from an input document. Examples indicative of the data to extract from the input document can be received.
Microsoft Technology Licensing, Llc

System and managing collaboration in a networked secure exchange environment

In embodiments of the present invention improved capabilities are described for securely viewing computer data content, such as documents, presentations, spreadsheets, emails, blog entries, texts, and the like, wherein a secure exchange server is controlled by an intermediate business entity, and access to retention restricted computer data content is granted to a user of a second business entity when the secure exchange server receives appropriate login authentication data, wherein the retention restricted computer data content is accessible to the at least one user of the second business entity as limited by the content retention restriction, which is provided by a user of a third business entity.. .
Intralinks, Inc.

Representing and manipulating hierarchical data

A methodology for representing hierarchical relationships between data in cells utilizes formatting of rows, columns, and cell borders, as well as blank rows. Such formatting and data table structure can be manipulated manually by a user, or automatically by software code, or via some combination of the two.
Power Modes Pty. Ltd.

User interface for creating a spreadsheet data summary table

A graphical user interface for creating a data summary table includes a field pane including a list of a plurality of fields, and a layout pane including a plurality of zones. The zones represent areas of the data summary table, and the layout pane allows a field of the plurality of fields from the field pane to be added to a first zone of the zones.
Microsoft Technology Licensing, Llc

Planning for manufacturing environments

Embodiments presented herein provide techniques for executing a block-based workflow to perform a planning process for a semiconductor manufacturing environment. The block-based workflow includes a plurality of blocks that specify a set of operations for performing the planning process.
Applied Materials, Inc.

System and process for generating an internet application

System for converting a spreadsheet in a first format to a second format comprising: a server including a storage means adapted to store the spreadsheet in the second format and store an associated template; a data set associated with the spreadsheet in the second format, such that the data set is adapted to be associated with the template to be displayed on a client device; and wherein when data is associated with the template, changes made via the client device to the associated data is recorded in realtime in both the spreadsheet in the second format and template. A process for generating an output for a webpage, comprising: selecting a spreadsheet and a template stored by a server, the spreadsheet comprising a data set; associating the data set with an element in the template, such that when the data is associated with the template, changes made to the associated data is recorded in realtime in both the spreadsheet and template; and generating the output comprising the data associated with the template..
Ytml Consulting Pty Ltd

File-level commenting

Various embodiments provide a commenting system for multiple users to provide and share comments to shared content items. For example, users can share a web link to a collection of content items, such as documents, spreadsheets, photos, and any other media, with other users stored in an online content management system.
Dropbox, Inc.

Automated testing of webpages

A test script may be written in a test script configuration spreadsheet. A plurality of test scripts may be listed in a test suite spreadsheet.
American Express Travel Related Services Company, Inc.

Embedding a representation of an item in a host

Functionality is described for creating objects that represent respective items provided in a store. The objects can be embedded in various hosts, such as network-accessible pages (e.g., web pages), network-accessible journals (e.g., blogs), messages (e.g., emails), and so on.
Microsoft Technology Licensing, Llc

Automated helmet gas bladder maintenance system and method

A system and method for easily and frequently checking the gas bladder pressure levels in a sports player's helmet and refilling them to maintain optimum head protection for the player. The system and method involve an electronic hand-held gas pump that wirelessly communicates with an adjacent wireless device that comprises a software application for controlling pump operation.

Method for converting ooxml formatted spreadsheets to html for web presentation

A method for converting an electronic document (ed) having a first format includes comparing an original width of the ed with a predetermined width and an original length of the ed with a predetermined length; splitting the ed into pieces in a width direction when the original width is greater than the predetermined width, and splitting the ed into pieces in a length direction when the original length is greater than the predetermined length, wherein each piece has a width and length less than or equal to the predetermined width and length; storing information representing geometric relationships of the pieces; converting the pieces from the first format into a second format; outputting the converted pieces as first output eds; and outputting a second output ed having the second format, wherein the second output ed incorporates the first output eds according to the information when displayed by a viewer application.. .
Konica Minolta Laboratory U.s.a., Inc.

Method and system to provide related data

Methods and systems of providing related information to a source document are described. The method may include accessing the source document displayed to a user in a graphical user interface (gui) of a client device.
Knoema Corporation

Integrating a construction jobsite system with external tools

Systems and methods presented herein can allow a user to integrate an existing construction jobsite system with external tools, such as spreadsheet software or a database. An integration platform can allow a user to create, select, and configure plugins that interface with a wrapper on the construction jobsite system to translate procedure calls, files, and data between the construction jobsite system and the external tools.
Applied Software Technology, Inc.

Enhanced mechanisms for managing multidimensional data

An enhanced multidimensional data management system significantly reduces the resources required to convert a spreadsheet into an enterprise collaborative system. A spreadsheet may be imported as is without modifications.
Planisware Sas

Apparatus, system and presenting views of a user's data using summary tables

An article, apparatus and methods are disclosed. The device and related methods involve a computing device including a program, such as a word processing program or spreadsheet program, configured to organize, through primary and other designations, table data and display, or otherwise use, the table of data.
Apple Inc.

Methods and systems for dynamic graph generating

A computer system and method for interrogating and analyzing data. The system may recognize the software application containing data and will search for visible and hidden data including headers and labels; and may further interrogate and analyze visible data.

Method and computing device for maintaining dependencies among reference elements

The disclosure is generally directed to a method and computing device for maintaining dependencies among multiple reference elements (e.g., formulas of a table or spreadsheet). In various embodiments, prior to a reevaluation operation carried out on the reference elements, a computing device receives an input of a reference element via a user interface (e.g., receives a user's input of a formula), assigns the reference element to a group based on the dependency between the reference element and one or more other reference elements, and assigns the reference element to a location within a dependency graph to which the other reference elements are assigned.
Workiva Inc.

Variable formatting of values

Variable formatting for cells in computer spreadsheets, tables, and other documents is provided. For a selected range of cells, cell formats vary with the value in each cell (or an associated value).
Microsoft Technology Licensing, Llc

Slicer elements for filtering tabular data

Slicers are configured to filter tabular data arranged in columns. A user may use the slicers to filter tabular data from a client application and/or a server based application/service.
Microsoft Technology Licensing, Llc

Systems and methods for forecasting based upon time series data

The present invention relates to systems and methods for forecasting using time series datasets. A composite may be generated by receiving datasets, normalizing them, and receiving formula configurations in order to combine the datasets together.
Prevedere, Inc

Computer implemented transforming data

The present disclosure includes techniques pertaining to computer implemented systems and methods for transforming data. In one embodiment, data sources are specified by a user and copies of specified data are received in local storage.

Computer implemented data usage monitoring

The present disclosure includes techniques pertaining to computer implemented systems and methods for data usage monitoring. In one embodiment, user manipulations of spreadsheets are translated into backend actions and executed against spreadsheet data.
Sap Se

Computer implemented automatic generation of data transformations

The present disclosure includes techniques pertaining to computer implemented systems and methods for automatic generation of data transformations. In one embodiment, a user manipulates a spreadsheet of data in a user interface.

Software test automation system and method

A method for testing a software application is provided. The method may comprise associating a plurality of controls on a software application screen with testing actions to be performed on the controls, thereby creating a plurality of test steps, and generating a test component.
Turnkey Solutions Corp.

Database system and object manipulation representing placement layers and parts

The technology disclosed relates to manipulating and visualizing database objects that represent layers and parts of layers in an insurance or other risk transfer program. In particular, a special purpose database system replaces manual use of spreadsheets and supports data visualization.
Onrisk, Inc.

Non-collaborative filters in a collaborative document

Systems and methods for viewing filters on a collaborative spreadsheet stored on a cloud computing service include accessing, from each of a plurality of client computers, a first sheet of a spreadsheet stored on a cloud computing service, where a plurality of filters is associated with the first sheet. A first client computer in the plurality of client computers receives a command by a first user to apply a first filter in the plurality of filters to the first sheet, and applies the first filter to the first sheet on the first client computer.
Google Inc.

Method and system for dashboard for event management

In one example, we describe a method and system for dashboard for event management. In one example, we describe a method and system for a synoptic dashboard for public safety answering points, which comprises: a) a dynamic filter criteria definition, tailorable both at psap and user level; b) a real-time query & mash-up engine, to combine structured data search and field-tracked feedbacks; and c) an in-place active spreadsheet.

Smart fill

A smart fill feature is provided, which may be utilized to provide suggestions to a user and to prepopulate fill results in a spreadsheet. Characteristics associated with a set of data may be recognized and used to help determine fill results suggestions may be determined from internal and or/external data sources, and may use contextual information in a data set to determine what a user may be trying to accomplish.
Microsoft Technology Licensing, Llc

Method and system for platform for event management

In one example, we describe a method and system for dashboard for event management. In one example, we describe a method and system for a synoptic dashboard for public safety answering points, which comprises: a) a dynamic filter criteria definition, tailorable both at psap and user level; b) a real-time query & mash-up engine, to combine structured data search and field-tracked feedbacks; and c) an in-place active spreadsheet.

Analysis with embedded electronic spreadsheets

A computer system includes a processor and a data store coupled to the processor. A user interface module is configured to provide a user interface of a first application executed by the processor.
Microsoft Technology Licensing, Llc

Systems and methods for automating securities trading

A method, system and computer program product for automatic securities trading. A graphical user interface comprising one or more spreadsheets is provided.
Tevel Apolo Trade Technologies Ltd.

Finding unique formula sets in spreadsheets

Spreadsheets include cells arranged in rows and columns and various formulas contained within one or more of the cells. Systems and methods are provided for identifying and utilizing functionally unique formulas within the spreadsheets, as well as corresponding unique formula sets.
Microsoft Technology Licensing, Llc

Hierarchical display-server system and method

A computing system includes a hierarchical set of servers. The hierarchical set includes a master server and one or more slave server.
Netzyn, Inc.

Provide insensitive summary for an encrypted document

An insensitive summary of an encrypted electronic document, such as email, is provided. The insensitive summary provides a summary of the encrypted electronic document without providing sensitive information, such as passwords.
Ca, Inc.

Systems, methods and articles for a web-based spreadsheet application

Methods, systems and articles of manufacture for creating an electronic spreadsheet using a web-based spreadsheet application. A web-server hosting a web-based spreadsheet website comprises one or more computer(s) having at least one computer processor, memory, data storage and a network communication device (e.g.
Intuit Inc.

Automated data conversion and presentation utility

Automated generation of business reports and, more specifically, automatic generation of slide show presentation reports in which data presented in the reports is automatically retrieved from spreadsheet application files and inserted into appropriate locations within designated slides of the slide sheet presentation. Moreover, automatic formatting (aligning, positioning and the like) of the data inserted in the slide show presentation occurs, such that, once formatted the presentation is ready to be disseminated without further manual intervention.
Bank Of America Corporation

Automated software application generation and deployment

The disclosure includes systems and methods for automated software generation and deployment, which can include automatically generating, without human interaction, an application based on one or more structured data source, which can include a table, spreadsheet, database, or the like. Applications can be generated for smartphones or other suitable devices.
Solvebot, Inc.

Identifying syntaxes of disparate components of a computer-to-computer message

A method identifies syntaxes of disparately syntaxed components of a message file. One or more processors receive a message at a computer, where the message comprises disparately syntaxed components.
International Business Machines Corporation

Locking spreadsheet cells

In some embodiments, an option to lock one or more associated cells is provided with respect to each different group of cells in a single sheet of a spreadsheet application. One or more locked cells of a group of cells do not scroll out of view at least while a portion of the group of cells is viewable in a given display view..
Apple Inc.

Generating scenes and tours in a spreadsheet application

Concepts and technologies are described herein for generating scenes and tours in a spreadsheet application. In accordance with the concepts and technologies disclosed herein, a computer system executes a visualization component.
Microsoft Technology Licensing, Llc

Aggregation and tracked changes of information from multiple databases using unique identification method

A system and method for combining data from multiple reports into a single spreadsheet. The system and method include downloading at least two reports to a computing device and opening the at least two reports using the computing device.
Northrop Grumman Systems Corporation

Cell view mode for outsized cells

Embodiments provide electronic spreadsheet viewing and interaction features and functionalities, but the embodiments are not so limited. In an embodiment, a computer-implemented method can be configured to provide a cell view launch indicator or interface that alerts a user that a selected cell includes additional content not being currently displayed.

Presentation of content from within spreadsheet application

A spreadsheet application may enable a user to organize, analyze, and store data in a tabular form. In some situations, the user may want to provide a brief presentation of the data to one or more recipients.
Microsoft Technology Licensing, Llc

Efficient copy paste in a collaborative spreadsheet

Systems and methods are disclosed herein for editing a collaborative spreadsheets hosted on a server. Multiple users may edit the spreadsheet, resulting in situations of intersecting or conflicting edits.
Google Inc.

Formula and function generation and use in electronic spreadsheets

spreadsheet formula and function creation and use with electronic computing devices are provided. When a user moves content (e.g., a spreadsheet cell) into a spreadsheet formula/function bar, a cell reference for the content may automatically be created and disposed in the formula/function bar, and if a user enters a math operation in a spreadsheet cell, corresponding operation sentence structure (syntax) may be automatically inserted into the formula/function bar.
Microsoft Technology Licensing, Llc

Asset management system for outdoor luminaires

Systems, methods and articles for providing automatic collection of asset management data of outdoor illumination systems. A central asset management system organizes the collected data into electronic reports (e.g., spreadsheets, maps) presentable to a user.
Express Imaging Systems, Llc

System and accessing rich objects via spreadsheets

One embodiment of the present invention sets forth a method for providing access to a data object from within a spreadsheet included in a spreadsheet application. The method includes associating the data object with a first cell of the spreadsheet, wherein the data object is related to a parameter, and the first cell is identified by a cell reference, receiving an input that is related to a second cell of the spreadsheet and includes an expression that specifies the parameter and the first cell reference, and replacing the first cell reference specified by the expression with the data object, wherein a value for the second cell may be determined by applying the parameter to the data object specified in the expression..
Palantir Technologies, Inc.

Data analysis expressions

Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet.
Microsoft Technology Licensing, Llc

Transdocument views and environment

This invention provides means to easily create, edit, and display documents that have very sophisticated capabilities. Every element, including for example, every pixel of every letter can edited by the most powerful and appropriate editor and can point to more information regarding that element.

Data processing device and method

Data processing device and method. The device includes: a spreadsheet of data displaying row for displaying a part of data retrieved from a database and a hyper row for expressing the remaining data; a data processor configured to calculate the value of the formula based on the data retrieved from the database.
International Business Machines Corporation

Self-service model designer for federated financial planning and analysis

A methods and apparatuses for creating a federated multidimensional business planning model may comprise: creating, via a computing device, a first multidimensional business planning model; creating, via a computing device, a second multidimensional business planning model; integrating, via a computing device, the first multidimensional business planning model with the second multidimensional business planning model, wherein the integrating comprises mapping, via a computing device, dimensions of the first multidimensional business planning model to the second multidimensional business planning model, utilizing user input through a model map spreadsheet worksheet defining, via a computing device, at least one source dimension in the first multidimensional business planning model corresponding with at least one target dimension in the second multidimensional business planning model.. .
Host Analytics, Inc.

Configuration management of industrial data

Systems and techniques for storing, managing and/or displaying industrial data are presented. A controller component stores configuration data associated with a plurality of product types for a product generated based on at least one manufacturing process in a nested data structure.
Rockwell Automation Technologies, Inc.

System and managing collaboration in a networked secure exchange environment

In embodiments of the present invention improved capabilities are described for securely viewing computer data content, such as documents, presentations, spreadsheets, emails, blog entries, texts, and the like, wherein a secure exchange server is controlled by an intermediate business entity, and access to retention restricted computer data content is granted to a user of a second business entity when the secure exchange server receives appropriate login authentication data, wherein the retention restricted computer data content is accessible to the at least one user of the second business entity as limited by the content retention restriction, which is provided by a user of a third business entity.. .
Intralinks, Inc.

Plug and play camera configuration tool for internet protocol cameras with export to third-party video management software support, batch firmware update, and other capabilities

A camera configuration tool that facilitates a method for configuring and managing internet protocol (ip) cameras across a network. A software program scans a network to discover a plurality of ip cameras, wherein camera data for each of the plurality of ip cameras is retrieved and added to a camera table as a camera item that is selectable.
Sentry360

System for and controllably disclosing sensitive data

System and method of producing a collection of possibilities that agree on information that must be disclosed (disclosable information) and disagree with a sufficient degree of diversity as defined by a policy to protect the sensitive information. A policy defines: what information is possible, what information the recipient would believe, what information is sensitive (to protect), what information is disclosable (to share) and sufficiency conditions that specify the degree of ambiguity required to consider the sensitive information protected.

Managing objects in panorama display to navigate spreadsheet

A panorama display application shows objects from a spreadsheet such as charts in primary screen of a mobile device adjoined by left and right virtual screens. The application overlays interaction controls such as sort and filter functions on the object.
Microsoft Technology Licensing, Llc

Peer to peer spreadsheet processing

A distributed system and process for sharing a spreadsheet model. A spreadsheet to be shared is configured by defining input fields, processing parameters for the input fields, and output fields, and a template including the input and output fields is created.
Purple Robot Software, Inc.

Automatically adjusting spreadsheet formulas and/or formatting

In some embodiments, a computer-implemented spreadsheet management method is provided that automatically copies formatting and formulas from appropriate peer rows to an updated row. In some embodiments, the method automatically determines which peer rows, if any, should be used as the source of copied formatting and formulas.
Smartsheet.com, Inc.

Method for determining in vivo tissue biomarker characteristics using multiparameter mri matrix creation and big data analytics

A method for determining mri biomarkers for in vivo issue includes the steps of obtaining raw data concerning the in vivo tissue from a mri machine; processing the raw data to obtain parameter maps; when applicable, registering images such that the exact same tissue at serial points can be analyzed; applying a grid over a region of interest to create sub-regions of interest (srois); inserting parameter measures for each sroi into a spreadsheet program to create a large 3d data matrix; applying standard big-data analytics including data mining and statistics of matrix measures to find patterns of measurement values or measure changes (which may include established biomarkers). A medical imaging software program is used to obtain the parameter maps from the raw data and place multiple grids over the srois.
Cubisme Imaging, Llc

Html5-based document format with parts architecture

One embodiment of a web-based word processor, spreadsheet, and presentations computer program that creates documents in an html5-based document format that breaks documents into parts and pages in order to make documents easy for use on laptops, tablets, and smartphones, and which chooses document parts from twenty one different types of parts, with each parts type taking advantage of the various features of html5 in different ways. Other embodiments are described and shown..

Presenting dataset of spreadsheet in form based view

A dataset of a spreadsheet is presented in a form based view. The dataset is detected in the spreadsheet.
Microsoft Corporation

Interfacing with a relational database for multi-dimensional analysis via a spreadsheet application

Systems, methods, and computer-readable mediums are presented that may provide for an interface to a relational database. A request may be received for data stored in a relationship database, wherein the request is received from a spreadsheet application.
Oracle International Corporation

Rules editor

A rules editor for creating rules for a software application. The editor is suitable for running on a computing device having at least a processor, a memory, a display device and an input device.
Aptitude Software Limited

Validation of formulas with external sources

A method validates a formula within a spreadsheet. A formula type, of an identified formula from a spreadsheet, is identified.
International Business Machines Corporation

Voice-messaging with attachments

A network method for using a network telephone voice-mail service, by which a caller may leave a voice-message that includes the identification of an attachment, which may include, as examples only, audio, video, text, programs, spreadsheets and graphic attachments. A video, text, spreadsheet or graphic attachment may be converted to an audible attachment to the voice-mail at the caller's or the voice-mail subscriber's request.
At&t Intellectual Property Ii, L.p.

Data mining in a business intelligence document

A business intelligence document provides functionality for testing a hypothesis on aggregated data in a business intelligence document (e.g., a spreadsheet-like document), wherein one or more of the input data values and transformation properties are designated as constrained (e.g., invariant or constrained within a range, set, enumeration, or domain). The hypothesis, which is articulated as a data mining assertion, is input through the user interface of the business intelligence document (e.g., via an expression interface or properties of a row, column, or cell) and solved over the aggregated data.
Microsoft Technology Licensing, Llc

Database management system based on a spreadsheet concept deployed in an object grid

A method for interacting with a database stored in an object grid is described. The database is given attributes of a spreadsheet.
International Business Machines Corporation

Stream-enabled spreadsheet as a circuit

Converting data transformations entered in a spreadsheet program into a circuit representation of those transformations. The circuit representation can run independently of the spreadsheet program to transform input data into output data.
International Business Machines Corporation

System and operating a computer application with spreadsheet functionality

The present invention provides a method for operating a computer application with spreadsheet functionality. The method comprising receiving one or more inputs in one or more cells by the spreadsheet application, parsing the received inputs for the one or more cells of the spreadsheet, constructing a dependency graph for the one or more parsed input cells, evaluating at least one of the one or more parsed input cells based on one or more criteria in the dependency graph, reconstructing the dependency graph until all of the one or more input cells are evaluated, and returning an output to the spreadsheet application..

Apparatus, system, and visualizing telecommunications resources

Aspects of the present disclosure involve systems, methods, computer program products, for obtaining information concerning a telecommunications network from various databases and/or informational spreadsheets, aggregating the information into a database, and displaying the information to aid in providing a telecommunication service to a customer. In one embodiment, the information in the database may be provided to an administrator of the telecommunications network through a user interface available to the administrator.
Level 3 Communications, Llc

Persistently self-replicating cells

The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi-dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size.
International Business Machines Corporation

Recall and triggering system for control of on-air content at remote locations

There is provided a recall and triggering system and method for the control of on-air graphics at remote locations. The system including a television network and an affiliated station, the television network configured to insert a command into a video and transmit the video including the command to the affiliated station, and the affiliated station configured to receive the video including the command from the television network, store the video in the memory, detect the command from the video stored in the memory, retrieve the data from a database based on the command, modify the video using the data to generate a modified video, and transmit the modified video to a display device.
Disney Enterprises, Inc.

Representation of people in a spreadsheet

A spreadsheet includes a native spreadsheet object that represents a person. The person object may be used within a spreadsheet just as any other spreadsheet objects are utilized.
Microsoft Technology Licensing, Llc

Interaction between web gadgets and spreadsheets

Gadgets integrate with spreadsheets and the spreadsheet calculation engine. A gadget is bound to a range of cells (one or more) within a sheet.
Microsoft Technology Licensing, Llc

Information processing apparatus and non-transitory computer readable medium

An information processing apparatus includes a detection unit, a combining unit, and a definition unit. The detection unit detects a character acceptance frame from a spreadsheet having the character acceptance frame.
Fuji Xerox Co., Ltd.

Distributed document co-authoring and processing

A method and a device are disclosed including plug-in software components that are integrated with document processing software suites. The plug-in software components provide a set of integrated interfaces for collaborative document processing in conjunction with multiple remote file, data, and application service providers.

Composite data creation with refinement suggestions

A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected.
Informatica Corporation

Apparatus and quantification of replicative lifespan and observation of senescene

The present invention teaches an apparatus and method for the automated study of senescence of cells. The apparatus includes a plurality of plates, customized with a flow-through hole, arranged on a platform.
Cytospan Technologies Corporation

System and managing data and data models

An exemplary embodiment of the present system and method provides a non-transitory, tangible computer readable storage medium having stored thereon computer-executable instructions. When executed by a computer, the instructions cause the computer to perform a number of steps of, which include: receiving a spreadsheet model; analyzing the spreadsheet model to determine one or more properties of the spreadsheet model; providing a first user interface on the basis of the determined properties, the first user interface enables configuration information to be specified for one or more cells of the spreadsheet model; receiving configuration information for the cells; and storing the spreadsheet model and the configuration information..

Memtag(s), automated creation of a timeline archive for improving personal, business and government productivity and communications

The present invention defines the memtag archive, which provides a single point of review and archive for all information that relates to a unique user of electronic devices, to efficiently keep track of the user's important information and communications. The invention presents an important improvement to browser and browser history, email domain, word processing, spreadsheet programs, social nets and social net timelines and the like..

A framework for enabling user-defined functions

A computer program product for use in conjunction with a spreadsheet application program comprises a framework having a library of defined functions. The spreadsheet application is, in use, executed in a first process in memory on a computer and the function is, in use, held in a second process, which second process is independent of the first process.
Ariadne Insight Limited

Method for logical organization of worksheets

According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet.
International Business Machines Corporation

Method for logical organization of worksheets

According to one embodiment of the present invention, methods, systems and computer-readable media of accessing data within a spreadsheet are provided. A set of attributes is assigned to each worksheet of a plurality of worksheets within the spreadsheet.
International Business Machines Corporation

Analytics report segments and controls

Analytics report segments and controls techniques are described in which an analytics module enables retrieval and manipulation of analytics data for a marketing service within a host application, such as a spreadsheet application. The analytics module provides an interactive dialog for insertion of form controls into documents designed as filters for analytics data embedded in the documents.

Spreadsheet data transfer objects

Various systems and methods are disclosed for automatically generating a spreadsheet template to store information usable to generate one or more data transfer objects for input to a system under test. One such method involves identifying one or more properties of a data transfer object to be input to a software system under test.

Cross reference to related application

Various data source locations storing files can be accessed and/or crawled. At each location, files can be identified.
Plusamp, Inc.

Enhanced indicators for identifying affected data

Technologies are described herein for displaying one or more visual indicators to assist users in identifying cells of a spreadsheet that are affected by an operation. In embodiments disclosed herein, an application is configured to receive a request to perform an operation on at least one cell of the spreadsheet.
Microsoft Corporation

Framework for data extraction by examples

Various technologies described herein pertain to controlling automated programming for extracting data from an input document. Examples indicative of the data to extract from the input document can be received.
Microsoft Technology Licensing, Llc

Associating captured image data with a spreadsheet

A spreadsheet application associates data obtained from a captured image with a spreadsheet. For example, one or more images of physical data may be captured and translated into electronic data that is automatically associated with one or more spreadsheets.
Microsoft Technology Licensing, Llc

Spreadsheet tool for dimensional calculations

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..

Display device, control method, and control program

According to one of aspects, a display device includes: a display unit configured to three-dimensionally display a planar object for executing processings related to spreadsheet, by displaying images respectively corresponding to both eyes of a user by being worn; a storage unit configured to store a rule in which operation to the object and a processing included in the processings are associated with each other; a detection unit configured to detect the operation; and a control unit configured to determine the processing to be executed according to the operation detected by the detection unit, based on the rule.. .
Kyocera Corporation

Dimension calculation a semiconductor device

An automatic calculation method for thickness calculation of a deposition layer in a fin-type field-effect transistor (finfet) is disclosed through mapping edge lines onto an excel spreadsheet. The similar method is also applied to the thickness calculation of superlattice or multiple quantum well for a light emitting diode (led).
Materials Analysis Technology Inc

Method and spatiotemporal valuation of real estate

A method and apparatus for valuing every property in a predetermined geographic region at regular intervals and storing those valuations for ready access later in a layered data stratum, using customary sources of property valuation data to create a new layers of the data stratum and using the data stored in the one or more layers of the data stratum for the creation of tables, spreadsheets and maps for evaluations of changes and trends in property valuation.. .
Corelogic Solutions, Llc

Spreadsheet to webpage conversion system and method

A spreadsheet to web page conversion system and method is disclosed for remotely programming and configuring control and monitoring devices. The approach is based on receiving a web page from a monitoring device via a configuration computer.
Rockwell Automation Technologies, Inc.

Verifying file versions in a networked computing environment

Embodiments of the present invention provide an approach for identifying a most recent version of an electronic file (e.g., prior to or while the electronic file is being opened). In one embodiment, an application programming interface (api), plug-in, or the like, can enable both file management tools and on-line repositories to exchange file information.
International Business Machines Corporation

Converting spreadsheet applications to web-based applications

A networked version of a spreadsheet application can be automatically created from an existing “conventional” spreadsheet. In one implementation, a server may obtain a data file, where the data file represents a networked version of a spreadsheet application that was converted from the “conventional” application and the data file defines characteristics of the networked version of the spreadsheet application including logic and interactivity attributes of cells in the networked version of the spreadsheet application.
Google Inc.

Database generation from a spreadsheet

A machine may generate a database from a spreadsheet, track the data from its cells as values of variables, and provide such values to authorized users. The machine may receive an upload spreadsheet that was generated by modification of a source spreadsheet by inclusion of control codes, such as a first control code that labels a column of owner names, a second control code that labels a column of measures, and a third control code that labels a column of values of those measures.
Xovertime, Inc.

Systems and methods for mutations and operational transforms in a collaborative spreadsheet environment

Mutations representing spreadsheet edit operations are received at a server from client computers of collaborators and also at a collaborator's client computer from other collaborators and the server. Different mutations may conflict, i.e., provide contradictory instructions on how a spreadsheet is to be edited.
Google Inc.

Systems and methods for mutations and operational transforms in a collaborative spreadsheet environment

Mutations representing spreadsheet edit operations are received at a server from client computers of collaborators and also at a collaborator's client computer from other collaborators and the server. Different mutations may conflict, i.e., provide contradictory instructions on how a spreadsheet is to be edited.
Google Inc.

Systems and methods for mutations and operational transforms in a collaborative spreadsheet environment

Mutations representing spreadsheet edit operations are received at a server from client computers of collaborators and also at a collaborator's client computer from other collaborators and the server. Different mutations may conflict, i.e., provide contradictory instructions on how a spreadsheet is to be edited.
Google Inc.

Dynamically sizing chunks in a partially loaded spreadsheet model

A method for managing a dynamically-sized chunked spreadsheet model on a server includes creating, on the server, a plurality of chunks representing a spreadsheet, where a first chunk in the plurality of chunks includes a first range of cells in the spreadsheet. The method further includes storing on the server a mutation log for the spreadsheet, and receiving a first plurality of mutations from a plurality of client computers, where the first plurality of mutations are stored in the mutation log.
Google Inc.

Resolving mutations in a partially-loaded spreadsheet model

A method of resolving mutations in a partially-loaded spreadsheet model includes loading onto a client computer a first chunk of a spreadsheet stored on a server, where the first chunk represents a first range of cells in the spreadsheet, and requesting a second chunk of the spreadsheet from the server, where the second chunk represents a second range of cells in the spreadsheet. The method further includes storing a plurality of pending user mutations on the client computer generated by a user on the client computer, where the plurality of pending user mutations are applied to the first chunk, and receiving from the server a plurality of collaborator mutations and the second chunk.
Google Inc.

Automatic relationship detection for spreadsheet data items

A system for automatically detecting relationships in spreadsheet data is disclosed. The system may be configured to analyze data items in the spreadsheet to determine whether two or more data items are unrelated.
Microsoft Technology Licensing, Llc

Validation of formulas with external sources

A method, system, and/or computer program product validates a formula within a spreadsheet. A formula type, of an identified formula from a spreadsheet, is identified.
International Business Machines Corporation

Web-based spreadsheet interaction with large data set

A computer-implemented method for presenting data is disclosed. The method includes receiving at a data server sub-system, from a browser on a remote client computing system, a request for data stored in a central data store; retrieving the requested data from the central data store and providing data corresponding to the requested data to a spreadsheet presentation sub-system that is in communication with the data server sub-system and with the browser on the remote client computing system; and providing a document key to the browser on the remote client computing system so that the browser can request from the presentation sub-system a spreadsheet document that displays the data corresponding to the requested data..
Google Inc.

System and providing online data management services

First, second, and third sets of spreadsheet cells are defined in a display, the first and second sets being separated by a first boundary having a selected orientation, the second and third sets being separated by a second boundary having the selected orientation. A selected scrolling function is disabled within selected sets among the first, second and third sets of cells in accordance with an alternating pattern..

Transfer of data between applications using intermediate user interface

Methods, systems, computer-readable media, and apparatuses for transfer of customer information between a first user interface and a third user interface by way of a second user interface are provided. In some embodiments, customer information may be imported into an intermediate user interface from a text-based user interface based on a first mapping associating portions of the text-based user interface with portions of an intermediate user interface.
Bank Of America Corporation

Representing and manipulating hierarchical data

A methodology for representing hierarchical relationships between data in cells utilizes formatting of rows, columns, and cell borders, as well as blank rows. Such formatting and data table structure can be manipulated manually by a user, or automatically by software code, or via some combination of the two.

Interaction with spreadsheet application function tokens

Interaction with spreadsheet formula/function tokens is provided. Functions and formulas may be tokenized into individual components and/or arguments.
Microsoft Corporation

Touch/gesture-enabled interaction with electronic spreadsheets

Touch/gesture-enabled interaction and navigation with electronic spreadsheets is provided. Navigation of, finding content in, and interacting with spreadsheets and spreadsheet objects is enhanced via a variety of touch/gesture interactions that allow users to more fully utilize and appreciate spreadsheet functionality and content.
Microsoft Corporation

Formula and function generation and use in electronic spreadsheets

spreadsheet formula and function creation and use with electronic computing devices are provided. When a user moves content (e.g., a spreadsheet cell) into a spreadsheet formula/function bar, a cell reference for the content may automatically be created and disposed in the formula/function bar, and if a user enters a math operation in a spreadsheet cell, corresponding operation sentence structure (syntax) may be automatically inserted into the formula/function bar.
Microsoft Corporation

Automated messaging tool

A system and method for an automatic messaging system which automatically sends emails or pages to groups of people with specific data from a database. Other messaging tools may be utilized.
At&t Intellectual Property I, L.p.

Method for inserting or deleting cells, rows or columns in spreadsheet and a device therefor

Disclosed is a method for inserting or deleting cells, rows or columns in a spreadsheet, comprising: obtaining touch and click information on a touch screen; determining target cells or target rows or columns; obtaining moving information about a touch point on the touch screen; according to a preset logic for judging operation type, judging that the operation to be performed is an insertion operation or a deletion operation; and determining locations and number of cells, rows or columns to be inserted or deleted, and performing an insertion or deletion operation. In addition, also disclosed is a device for inserting or deleting cells, rows or columns in a spreadsheet, including: an information acquisition module, a target determination module, an operation type judgment module and an operation execution module.
Beijing Kingsoft Office Software Co., Ltd

Status viewer

In various embodiments, methods, systems, and non-transitory computer-readable media are disclosed that allow developers to providing spreadsheets in a desktop integration framework that include error reports for validations. In various embodiments, a modeless error viewer is provided that allows end users to view an errors list for any failed row at the same time as the user corrects these errors..
Oracle International Corporation

Systems and methods for benchmarking internal supplier diversity goals

Apparatus, methods and media for benchmarking diverse spend opportunities are provided. A method according to the invention preferably includes receiving financial data corresponding to entity diverse spend and financial data corresponding to total entity spend.
Bank Of America Corporation

File-level commenting

Various embodiments provide a commenting system for multiple users to provide and share comments to shared content items. For example, users can share a web link to a collection of content items, such as documents, spreadsheets, photos, and any other media, with other users stored in an online content management system.

Risk driven product development process system

The other new tools in this invention include interaction matrix, integration matrix, spreadsheet of market requirement analysis, and fmeas templates.. .

Targeted advertising services method

A method and apparatus for providing an automatically upgradeable software application includes targeted advertising based upon demographics and user interaction with the computer. The software application includes a display region used for banner advertising that is downloaded over a network such as the internet.
B.e. Technology, L.l.c.

Indexing spreadsheet structural attributes for searching

Technologies are described herein for extracting and/or calculating statistics regarding attributes present in a spreadsheet document and indexing the structural or functional attributes. A search component is also provided for receiving search queries of attributes to search an index to find spreadsheet documents having attributes that meet the search query requirements..
Microsoft Corporation

System for and methods of teaching and learning foreign languages online using spreadsheets created by web-based document creating software

Novel systems/methods for generating language learning lessons is disclosed in the present application. A learner is allowed to speak out loud a sentence in a foreign language while an instructor types down exactly how the sentence is spoken in a first column on an instruction sheet.

Fluid movement tracking system, especially suitable for water and crude oil produced in connection with oil and gas well operations

A fluid movement tracking system, enabling tracking of fluids moved between a pickup location and a disposal location by tank truck, utilizes identifiers, typically quick response or “qr” codes, mounted on fluid containers (commonly tanks) to provide information about fluid type, container capacity and location, etc. The qr codes are scanned by an optical reader on a handheld portable computing device, for example a tablet device, using a wireless mobile operating system such as the android system.

Techniques to present a dynamic formula bar in a spreadsheet

Various embodiments are generally directed to techniques and apparatuses to present a dynamic formula bar in a spreadsheet application. Some embodiments are particularly directed to presenting a dynamic formula bar in a spreadsheet application that may improve usability in particular with large display sizes and/or touchscreen interfaces.
Microsoft Corporation

Micro browser spreadsheet viewer

Various technologies and techniques are disclosed for displaying and managing spreadsheets on mobile devices. An optimized search can be performed.
Microsoft Technology Licensing, Llc.

Using spreadsheets as a basis for enhanced application development

Systems, methods, and software are disclosed herein for designing applications. In an implementation, a method comprises examining a spreadsheet to identify a plurality of spreadsheet components of the spreadsheet with which to generate a plurality of application components for potential inclusion in a software application under design.
Microsoft Corporation

Systems and methods for parsing unknown codes obtained from a customizable spreadsheet application interface

An improvement in a customizable spreadsheet application is provided. The improvement preferably provides an interface between the customizable spreadsheet application and a third party financial institution application.

Extracting relational data from semi-structured spreadsheets

Relational data is extracted from spreadsheets. A relational data extraction program is synthesized, where this synthesized program is consistent with examples of relational data associated with a spreadsheet.
Microsoft Corporation



Spreadsheet topics:
  • Spreadsheet
  • Spreadsheets
  • Computing Device
  • Distributed
  • Operating System
  • Processing Device
  • Computer Program
  • Programming Language
  • Executable
  • Memory Device
  • Digital Processing
  • Drill Down
  • User Interface
  • Subscriber
  • Visualization


  • Follow us on Twitter
    twitter icon@FreshPatents

    ###

    This listing is a sample listing of patent applications related to Spreadsheet for is only meant as a recent sample of applications filed, not a comprehensive history. There may be associated servicemarks and trademarks related to these patents. Please check with patent attorney if you need further assistance or plan to use for business purposes. This patent data is also published to the public by the USPTO and available for free on their website. Note that there may be alternative spellings for Spreadsheet with additional patents listed. Browse our RSS directory or Search for other possible listings.


    2.3211

    file did exist - 12030

    2 - 1 - 251