Alternative Scenario Management Patents (Class 715/213)
  • Patent number: 11972005
    Abstract: System and methods are disclosed for the management and security of data variations in an electronic spreadsheet. Keeping all relevant information in a single document, with granular controls to protect and secure access based on each individual or their role within an organization, eliminates the need for workarounds, and simplifies the management of the contained data. Tracking data as it is being entered, also allows the system to notify the user when protected information is detected, and appropriate action to be taken to ensure compliance with any requirements.
    Type: Grant
    Filed: June 30, 2021
    Date of Patent: April 30, 2024
    Inventor: Lee David Buckland
  • Patent number: 11782928
    Abstract: Computerized systems are provided for detecting one or more tables and performing information extraction and analysis on any given table. Information can be extracted from one or more cells or fields of a table and feature vectors representing individual cells, rows, and/or columns of the table can be derived and concatenated together. In this way, embodiments can use some or all of the “context” or values contained in various feature vectors representing some or all of a single table as signals or factors to consider when generating a decision statistic, such as a classification prediction, for a particular cell.
    Type: Grant
    Filed: June 30, 2020
    Date of Patent: October 10, 2023
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Pak On Chan, Sharada Shirish Acharya
  • Patent number: 11645227
    Abstract: A file management system may include a file server that performs calculations of a spreadsheet file instance to generate a dataset that includes values in the spreadsheet file instance. The file management system also may include an application operating at a client device that is in communication with the file server via a network. The application may receive, via the network, a version of the dataset comprising the values generated by the calculations performed by the server. The application may visualize a spreadsheet at the user interface. The visualized spreadsheet may display at least a subset of the values. In one case, protected contents of one or more cells in the spreadsheet may be converted to other values when displayed at the user interface.
    Type: Grant
    Filed: July 21, 2022
    Date of Patent: May 9, 2023
    Assignee: DealVector, Inc.
    Inventors: Subhrojit Nag, Manish Kumawat
  • Patent number: 11645228
    Abstract: A file management system may include a file server that performs calculations of a spreadsheet file instance to generate a dataset that includes values in the spreadsheet file instance. The file management system also may include an application operating at a client device that is in communication with the file server via a network. The application may receive, via the network, a version of the dataset comprising the values generated by the calculations performed by the server. The application may visualize a spreadsheet at the user interface. The visualized spreadsheet may display at least a subset of the values. In one case, protected contents of one or more cells in the spreadsheet may be converted to other values when displayed at the user interface.
    Type: Grant
    Filed: July 21, 2022
    Date of Patent: May 9, 2023
    Assignee: DealVector, Inc.
    Inventors: Subhrojit Nag, Manish Kumawat
  • Patent number: 11645229
    Abstract: A file management system may include a file server that performs calculations of a spreadsheet file instance to generate a dataset that includes values in the spreadsheet file instance. The file management system also may include an application operating at a client device that is in communication with the file server via a network. The application may receive, via the network, a version of the dataset comprising the values generated by the calculations performed by the server. The application may visualize a spreadsheet at the user interface. The visualized spreadsheet may display at least a subset of the values. In one case, protected contents of one or more cells in the spreadsheet may be converted to other values when displayed at the user interface.
    Type: Grant
    Filed: July 21, 2022
    Date of Patent: May 9, 2023
    Assignee: DealVector, Inc.
    Inventors: Subhrojit Nag, Manish Kumawat
  • Patent number: 11630948
    Abstract: A method of processing data of a collaborative electronic document having a tabular structure includes identifying a first cell in the tabular structure of the collaborative electronic document, the first cell having a first cell identifier and including a formula having a first function call, the first function call including an argument comprising a plurality of formula elements, wherein the plurality of formula elements comprise a second cell identifier and a first string.
    Type: Grant
    Filed: February 12, 2021
    Date of Patent: April 18, 2023
    Assignee: Google LLC
    Inventors: Joseph J. Kaptur, Zachary E. Lloyd
  • Patent number: 11500839
    Abstract: Aspects are described to generate indexing on columns including links to other columns in a different table. One aspect describes a computer-implemented method comprising identifying, for a workbook comprising a plurality of cells and tables stored in a spreadsheet structure, a query comprising a formula, parsing the formula to identify, as one operand, a heterogeneous column of links in a first table of the plurality of tables to a column in a second table of the plurality of tables and at least one operator, automatically generating a virtual column for the heterogeneous column, the virtual column being inaccessible to a user, storing the generated virtual column, evaluating the function of the virtual column for each row of the first table, generating an inaccessible virtual index for the virtual column, storing the virtual index, and evaluating the formula based on the virtual index to generate a result.
    Type: Grant
    Filed: September 30, 2020
    Date of Patent: November 15, 2022
    Assignee: Amazon Technologies, Inc.
    Inventors: Venkata Rao Pedapati, Adrian Kwok, Anupam Srivastava, Wilfred Xavier Zhi Zhiang Wee, Helbert Fonseca Maich
  • Patent number: 11481451
    Abstract: Systems and methods for ingesting and enhancing data in a distributed processing framework. The system includes at least a data ingestion system configured to access data or datasets from one or more data sources. The data is accessed via the data ingestion system and includes metadata defining a plurality of attributes. The attributes are identified in the metadata, via the data ingestion system, and may be applied to the data or dataset for enhancing the data or dataset. Application of the attributes to the data results in enhancements that may include joining the data, enriching the data, or other enhancements accomplished via manipulation of the data via the data ingestion system.
    Type: Grant
    Filed: May 21, 2019
    Date of Patent: October 25, 2022
    Assignee: JPMORGAN CHASE BANK, N.A.
    Inventors: Matthew Yazdi, Manish Doshi, Fazil Syed, Smitha Vijayendra, Grant Poladian, Yue Lin
  • Patent number: 11423218
    Abstract: A formula abstraction system is described. The system includes detecting a user-generated formula in a cell of a spreadsheet document, generating a graphical user interface that queries entries of a custom function based on the user-generated formula, forming the custom function by abstracting the user-generated formula to the custom function based on the entries, and storing the custom function in a function library of the spreadsheet document. The custom function applies the user-generated formula in a user-selected cell of the spreadsheet document.
    Type: Grant
    Filed: December 10, 2020
    Date of Patent: August 23, 2022
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Michelle Elena Keslin, Christopher John Gross, Joseph Mcdaid, Andrew James Becker, Su-Piao Bill Wu
  • Patent number: 11347936
    Abstract: A value is received that is in at least one cell of a spreadsheet. The spreadsheet includes data across a plurality of rows and a plurality of columns. A subsection of the spreadsheet in which to search for the value is received. The subsection includes less than all columns and less than all rows. The subsection is searched for all cells that contain the value. All cells within the subsection that contain the value are provided.
    Type: Grant
    Filed: November 19, 2020
    Date of Patent: May 31, 2022
    Assignee: International Business Machines Corporation
    Inventor: Jin Leem
  • Patent number: 11308269
    Abstract: Provided methods and systems allow dynamic rendering of a reflexive questionnaire based on a modifiable spreadsheet for users with little to no programming experience and knowledge. Some methods comprise receiving a modifiable spreadsheet with multiple rows, each row comprising rendering instructions for a reflexive questionnaire from a first computer, such as a data type cell, statement cell, logic cell, and a field identifier; rendering a graphical user interface, on a second computer, comprising a label and an input element corresponding to the rendering instructions of a first row of the spreadsheet; receiving an input from the second computer; evaluating the input against the logic cell of the spreadsheet; in response to the input complying with the logic cell of the spreadsheet, dynamically rendering a second label and a second input element to be displayed on the graphical user interface based on the logic of the first row.
    Type: Grant
    Filed: August 24, 2020
    Date of Patent: April 19, 2022
    Assignee: HITPS LLC
    Inventors: Todd Rodgers, Harish Krishnaswamy
  • Patent number: 11281687
    Abstract: Compiling a database query including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse; converting, by the query compiler, the state specification into a worksheet algebra including determining a first order of operations for elements within the state specification, wherein the worksheet algebra comprises the first order of operations over a nested table; converting, by the query compiler, the worksheet algebra into a database query; and sending the database query to the data warehouse.
    Type: Grant
    Filed: January 17, 2020
    Date of Patent: March 22, 2022
    Assignee: SIGMA COMPUTING, INC.
    Inventors: Max H. Seiden, Jason D. Frantz, Donald Huang
  • Patent number: 11227106
    Abstract: Systems, methods, and software are disclosed herein for enhancing functions and formulas in spreadsheets. A computing apparatus detects a beginning of a formula in a cell of a spreadsheet. In response to detecting the beginning of the formula, the computing apparatus identifies one or more vector representations of a context of the cell and supplies the one or more vector representations as input to one or more machine learning models. The one or more machine learning models produce output comprising one or more suggested functions for the formula and one or more suggested operands, which the computing apparatus presents in a user interface to the spreadsheet.
    Type: Grant
    Filed: July 24, 2019
    Date of Patent: January 18, 2022
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Andrew William Stegmaier, Johnny Campbell, Joseph John McDaid, Christian Canton, Vikas Yadav, Sjoerd Roelof de Jong, Robert David Ohn Tinn, Marc Manuel Johannes Brockschmidt, Juliana Patricia Vicente Franco, Sneha Khullar
  • Patent number: 11228656
    Abstract: An event processing system is provided for providing resilient message processing using asynchronous communications. The event processing device includes a processor and a memory. The event processing device is in communication with a publisher microservice and subscriber microservices. The processor is configured to receive an event including a collection of data from the publisher microservice. The processor is also configured to process the event to identify a recipient microservice. The processor is configured to update a queue with a queue entry for each of the at least one recipient microservices for the event. Each queue entry is associated with a priority. The processor is also configured to attempt to transmit the event to each of the at least one recipient microservices until a transmission confirmation message is received. The processor is further configured to update the queue by removing the queue entry for which the transmission confirmation message is received.
    Type: Grant
    Filed: October 23, 2020
    Date of Patent: January 18, 2022
    Assignee: Express Scripts Strategic Development, Inc.
    Inventors: Johnu Celestine, Surya Teja Reddy Kotha, Dmitry Milman, Robert W. Scanlon, Daniel E. Powers, David Erickson
  • Patent number: 11106866
    Abstract: The invention relates to the field of data representation, for example for spreadsheet applications. The invention comprises accessing a dataset comprising values of variables for a plurality of objects. The invention further comprises generating a raw representation of the value, and a synthetic representation of the values for a variable, which depends on the type of variable. The synthetic representation of values comprises a plurality of elements, each elements corresponding to a plurality of values of the variable for a plurality of objects. The invention comprises receiving from a user a selection of an element of the synthetic representation, and selecting the corresponding plurality of objects. The type of synthetic representation being dependent upon the type of variable, the invention allows the user to easily and intuitively select objects interest him/her.
    Type: Grant
    Filed: June 27, 2018
    Date of Patent: August 31, 2021
    Assignee: ZEBRYS
    Inventors: Christophe Genolini, Aygul Abakirova
  • Patent number: 11100280
    Abstract: A method for consolidating DDT spreadsheets is provided. The spreadsheets may be for testing with a test executable program. Methods may store a plurality of DDT spreadsheets in a collective DDT folder. Methods may create a single collective spreadsheet. Methods may store the single collective spreadsheet in the collective DDT folder. Methods may identify a plurality of empty cells within each DDT spreadsheet. Methods may enter a filler entry into each cell determined to be empty. Methods may copy each sheet that includes at least one test executable into the single collective spreadsheet. Methods may process each test executable included in the single collective spreadsheet. Methods may place the results of each test executable in a column orthogonal to the test executable row. Methods may copy each test executable and the results of each test executable into the plurality of DDT spreadsheets from which the test executable were copied.
    Type: Grant
    Filed: October 10, 2019
    Date of Patent: August 24, 2021
    Assignee: Bank of America Corporation
    Inventors: Tim Zhao, Akshay Patel, Indrani Mohanty
  • Patent number: 11087015
    Abstract: System and methods are disclosed for the management and security of data variations in an electronic spreadsheet. Keeping all relevant information in a single document, with granular controls to protect and secure access based on each individual or their role within an organization, eliminates the need for workarounds, and simplifies the management of the contained data. Tracking data as it is being entered, also allows the system to notify the user when protected information is detected, and appropriate action to be taken to ensure compliance with any requirements.
    Type: Grant
    Filed: December 4, 2020
    Date of Patent: August 10, 2021
    Inventor: Lee David Buckland
  • Patent number: 11017014
    Abstract: Systems for accessing medical imagery from a cloud-based facility using a browser-like application. A first user (e.g., a physician) identifies a first plurality of medical digital information files that are organized in a first storage structure. The first user's requests a set of first digital information views of the identified medical digital information of the first storage structure wherein the plurality of first digital information views are described by a respective first set of logical view attributes that are associated with the files organized in the first storage structure. A second user (e.g., a second physician) requests a second plurality of digital information views of the first storage structure wherein the second plurality of digital information. The system sends the first digital information views to the first user, and sends the second digital information views to the second user.
    Type: Grant
    Filed: May 21, 2016
    Date of Patent: May 25, 2021
    Assignee: Box, Inc.
    Inventors: Cody D. Ebberson, Reshma K. Ebberson
  • Patent number: 10922482
    Abstract: A method of processing data represented as an electronic spreadsheet includes identifying a first cell of a first sheet of the electronic spreadsheet, the first cell having a first cell identifier and including a formula having a first function call, the first function call including an argument having a plurality of formula elements that comprise a second cell identifier. The method further includes identifying, based on the second cell identifier, a second cell that includes a function identifier, and identifying a value of the second cell, wherein the value of the second cell is a string corresponding to a function name corresponding to a second function call to be used in the argument of the first function call.
    Type: Grant
    Filed: August 5, 2019
    Date of Patent: February 16, 2021
    Assignee: GOOGLE LLC
    Inventors: Joseph J. Kaptur, Zachary E. Lloyd
  • Patent number: 10891434
    Abstract: Methods for generation and execution of elastic sheet-defined functions and arrays are performed by systems, devices, and apparatuses. Elastic sheet-defined functions are generated from inelastic defined functions. Specific notations for tile ranges and range references of inputs for an inelastic function are generated, and heights, widths, rows, and columns of the inputs are modified with delta variables. Constraints for the delta variables are generated and mapped to solve for a constraints solution for a given inelastic function. Based on the constraints solution, an elastic sheet-defined function is generated that takes dynamic input ranges of different sizes. Elastic sheet-defined functions are executed to prevent overlap of tiles and ranges for variables by generating new sheets for tiles and ranges, dynamically moving tiles and ranges, and assigning cells as arrays. Software programming arrays are also dynamically sized in a similar manner.
    Type: Grant
    Filed: November 21, 2018
    Date of Patent: January 12, 2021
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Simon L. Peyton Jones, Advait Sarkar, Andrew Gordon, Richard Matthew McCutchen
  • Patent number: 10853558
    Abstract: Techniques for transforming digital text content using expressions are described. According to various implementations, a text editor system determines that digital text content of a digital document is modified via application of a particular style that differs from other digital text content of the digital document. The text editor system identifies a pattern characteristic to the modified digital text content, and generates a digital expression that identifies the pattern, and generates a style expression that combines the digital expression with a digital style that represents style attributes descriptive of the style modification applied to the modified text content. The text editor system applies the style expression to search digital text content, identify matching digital text content that matches the digital expression, and transform the matching digital text content by applying the digital style to modify the matching digital text content.
    Type: Grant
    Filed: February 20, 2019
    Date of Patent: December 1, 2020
    Assignee: Adobe Inc.
    Inventors: Rohit Kumar Dubey, Anurag Singh, Aman Arora
  • Patent number: 10775985
    Abstract: A method for managing a dialog box. The method includes: displaying, on a display screen, the dialog box including a transparency GUI widget; obtaining a transparency setting specified by a user of the application, where the user interacts with the transparency GUI widget to specify the transparency setting; and adjusting the transparency of the dialog box on the display screen based on the transparency setting.
    Type: Grant
    Filed: December 29, 2016
    Date of Patent: September 15, 2020
    Assignee: KONICA MINOLTA LABORATORY U.S.A., INC.
    Inventor: Howard Rubin
  • Patent number: 10726201
    Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.
    Type: Grant
    Filed: June 29, 2018
    Date of Patent: July 28, 2020
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
  • Patent number: 10699068
    Abstract: In non-limiting examples of the present disclosure, systems, methods and devices for interacting with lambda functions are presented. An indication to store a lambda function may be received. The lambda function may comprise: executable information that is specific to a first spreadsheet application instance, executable information that is generic to spreadsheet application instances, and metadata describing the functionality of the lambda function. The lambda function may be stored, and an indication to apply the stored lambda function to data in a separate spreadsheet application instance may be received. The stored lambda function may be provided to the separate spreadsheet application instance for execution.
    Type: Grant
    Filed: June 29, 2018
    Date of Patent: June 30, 2020
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Christopher John Gross, Johnny Campbell, Claudio Vittorio Russo
  • Patent number: 10558744
    Abstract: Systems and methods and methods for providing real-time data to a spreadsheet applications (SSAPPs) are disclosed. In an example, a spreadsheet application (SSAPP) obtains subscribed data from a server through the persistent connection between the SSAPP and the server via a TCP socket. The subscribed data can be propagated to the server from a data source. The SSAPP can perform an action on the subscribed data, such as presenting a representation based on the subscribed data to a user. When the data source propagates updated data to the server, the server can send the updates to the SSAPP in real time over the TCP socket. The SSAPP can also send data do the server over the TCP socked by, for example, extracting contents from a set of cells, processing the contents to produce a result, and transmitting the result to the server via the persistent connection.
    Type: Grant
    Filed: November 20, 2017
    Date of Patent: February 11, 2020
    Assignee: Real Innovations International LLC
    Inventor: Andrew Thomas
  • Patent number: 10496740
    Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.
    Type: Grant
    Filed: June 29, 2018
    Date of Patent: December 3, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
  • Patent number: 10489506
    Abstract: Message corrections are effected on a user electronic device using a touch-based user interface. In response to user input in a messaging application input field indicating that a replacement or correction operation is to be carried out, the device identifies multiple strings corresponding to the correction in at least one previous message sent by the messaging application. These strings are presented in context in a user interface in a visually distinguished manner, such as highlighting. The strings may be presented with replacement text. The user then confirms which strings are to be corrected by touch input at the location of the string in the user interface. In response to the touch input, the previous message is updated with the desired changes. The updated message can then be sent to a recipient. The user interface can be used in find and replace or spellcheck operations in an editing or composition application.
    Type: Grant
    Filed: May 20, 2016
    Date of Patent: November 26, 2019
    Assignee: BlackBerry Limited
    Inventors: Marcin Cietwierkowski, Nazih Almalki, Robert George Oliver, Zhe Chen, Andrew Michael Inwood
  • Patent number: 10467337
    Abstract: Large and complex data sets can be difficult to view on devices with small screens, such as on smartphones, or in small windows on devices with large screens. The presently disclosed systems, methods and apparatus can determine characteristics associated with a display used to display a requested resource. Based on these determined characteristics, the systems and methods can determine whether the requested resource should be reformatted to fit the display. The requested resource can be reformatted to allow a user to consume complex data on a small display easily and effectively. In some embodiments, this can be done by ensuring that the current data context, previously provided by row/column headers, are always in view in a compact format.
    Type: Grant
    Filed: October 27, 2015
    Date of Patent: November 5, 2019
    Assignee: Kinaxis Inc.
    Inventors: Syed Ali Haider, Christopher David Burt, Matthew S. Chmiel, David Dewar, Ryan Christopher McCluskey
  • Patent number: 10462206
    Abstract: Systems and methods and methods for providing real-time data to a spreadsheet applications (SSAPPs) are disclosed. In an example, a spreadsheet application (SSAPP) obtains subscribed data from a server through the persistent connection between the SSAPP and the server via a TCP socket. The subscribed data can be propagated to the server from a data source. The SSAPP can perform an action on the subscribed data, such as presenting a representation based on the subscribed data to a user. When the data source propagates updated data to the server, the server can send the updates to the SSAPP in real time over the TCP socket. The SSAPP can also send data do the server over the TCP socked by, for example, extracting contents from a set of cells, processing the contents to produce a result, and transmitting the result to the server via the persistent connection.
    Type: Grant
    Filed: November 20, 2017
    Date of Patent: October 29, 2019
    Assignee: Real Innovations International LLC
    Inventor: Andrew Thomas
  • Patent number: 10229750
    Abstract: A memory management architecture in a testing environment including a memory cache and a hard drive is provided. The hard drive may be configured to receive a high-volume set of production data including computer-readable spreadsheet files in varied file formats. The memory cache comprised in the memory management architecture may be configured to receive and store from the hard drive a first subset of the high-volume set of production data. This form of retrieval allows for not having to receive from off-site or from an external source. The memory management architecture may also include a diagnostic tool that may be used for data analysis. The diagnostic tool may analyze and test the fields listed on the field list, for any errors and/or omissions. When the data analysis and testing is complete, the diagnostic tool may then generate a data analysis summary report based on the analysis.
    Type: Grant
    Filed: January 18, 2017
    Date of Patent: March 12, 2019
    Assignee: Bank of America Corporation
    Inventors: Akshay Patel, Kanika Vij
  • Patent number: 9747266
    Abstract: Systems, methods, data structures and/or the like are provided for placing copy data, supplemental, and/or additional data on a clipboard, for example. The copy data may comprise a reference to supplemental data, such as HTML data (e.g., a social media data from an HTML social media webpage). The supplemental data may be retrieved using the reference, and placed within the clipboard. In this way, the copy data and the supplemental data may be available within the clipboard.
    Type: Grant
    Filed: January 31, 2011
    Date of Patent: August 29, 2017
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Raymond E. Ozzie, Jack E. Ozzie, Paresh S. Suthar, Raman Narayanan, Matthew S. Augustine
  • Patent number: 8942731
    Abstract: There is provided an information delivery apparatus including a receiving portion to receive location information of a mobile communication terminal at a given time and acquired date and time of the location information from the terminal, an event information storage portion to store event information including an event place, date and time, a delivery terminal selecting portion to select the mobile communication terminal to which the event information is to be delivered based on the location information and the acquired date and time of the location information and on the event place, date and time, and an event information delivery portion to deliver the event information to the selected mobile communication terminal. The delivery terminal selecting portion selects the mobile communication terminal whose location indicated by location information is within a predetermined range and whose acquired date and time of the location information are before the event date and time.
    Type: Grant
    Filed: January 14, 2013
    Date of Patent: January 27, 2015
    Assignee: Sony Corporation
    Inventors: Mitsuru Takehara, Yoichiro Sako, Masamichi Asukai, Taiji Ito, Akinobu Sugino, Akane Sano, Yoshiteru Kamatani, Kazunori Hayashi, Takayasu Kon, Yasunori Kamada
  • Patent number: 8782509
    Abstract: Embodiments of the present invention provide a table graphics management method and apparatus. The table graphics management method includes: displaying a table on a display apparatus; detecting a control track for the table input by an input device; determining a moving direction of the control track according to the detected control track; and along the moving direction of the control track, transposing original information in the frames of the row that are sequentially arranged along the first dimension into the frames of the column that are sequentially arranged along the second dimension, and transposing original information in the frames of the column that are sequentially arranged along the second dimension into the frames of the row that are sequentially arranged along the first dimension, so as to acquire a transposed table; and displaying a transposed table on the display apparatus.
    Type: Grant
    Filed: July 24, 2013
    Date of Patent: July 15, 2014
    Assignee: Huawei Technologies Co., Ltd.
    Inventor: Wenfang Tang
  • Patent number: 8730264
    Abstract: A plurality of graphics objects are assigned to a quad-tree structure corresponding to a display. It is determined whether another graphics object overlaps with a display area corresponding to a node of the quad-tree structure. When the other graphics object overlaps with the display area, it is determined whether the other graphics object intersects with any graphics objects belonging to the node.
    Type: Grant
    Filed: September 26, 2011
    Date of Patent: May 20, 2014
    Assignee: Google Inc.
    Inventor: Brian Cornell
  • Patent number: 8725738
    Abstract: A system for organizing and searching data, representing objects, in a database. The data is organized into subsets according to the objects' characteristics. A value is assigned to each subset member according to the degree it possesses the relevant characteristic. Each subset is organized into a linear progression according to the characteristic values of the subset member. Next, a beginning subset is selected. A portion of the selected subset is displayed as a linear progression, along which the searcher may scroll to view the subset members. Selecting an object from the linear progression will prompt the system to determine whether the object is a member of other subsets. If so, a portion of those subsets will be displayed as linear progressions intersecting the original linear progression at the selected object. The searcher may either continue scrolling along the original linear progression or begin scrolling along an intersecting linear progression.
    Type: Grant
    Filed: October 29, 2010
    Date of Patent: May 13, 2014
    Assignee: Gemvision Corporation, LLC
    Inventor: Jeffrey High
  • Patent number: 8725604
    Abstract: The present invention provides a system and method of generating a set of tax schedule information comprising: (a) providing an Excel interface, the Excel interface being associated with a set of commands and functions; (b) accessing a separate database, the separate database storing a set of data, the set of data having been defined using the set of commands and functions; (c) manipulating the set of data according to the set of commands and functions to generate the set of tax schedule information; and (d) storing the set of tax schedule information in a separate database. This embodiment may further include one or more of the following: using at least one entry from the set of tax schedule information to populate a tax schedule; wherein the separate database is an XML database; wherein the set of tax schedule information is based, at least in part, on a set of tags associated with the XML database.
    Type: Grant
    Filed: October 22, 2009
    Date of Patent: May 13, 2014
    Assignee: Thomson Reuters (Tax & Accounting) Services, Inc.
    Inventor: Michael Knighton
  • Patent number: 8707156
    Abstract: A render engine for a spreadsheet application is described. The render engine facilitates the rendering of cell regions containing data that are maintained by both a spreadsheet application (user-defined cell region) and/or a third-party application (application-defined cell region). In particular, an embodiment of the render engine facilitates the repositioning of one or more existing cell regions within a spreadsheet interface, when the insertion of a new cell region is determined to cause a layout conflict with one or more existing cell regions. Repositioning of the existing cell regions is achieved without overwriting any cell information, and without breaking any formulas contained within an affected cell.
    Type: Grant
    Filed: April 2, 2009
    Date of Patent: April 22, 2014
    Assignee: Business Objects, S.A.
    Inventors: Wei Xue, Shuai Zhao, Leo Chi-Lok Yu
  • Patent number: 8533583
    Abstract: Disclosed is an application software generation device to generate an application software for a data collection device having a reading unit to read discrimination information to carry out collection of data based on the discrimination information including a table data generation unit to generate table data for defining arbitrary items, an application software generation unit to generate an application software which is executed by the data collection device in order to collect the data based on the item which is defined in the table data and a transfer unit to transfer the generated application software to the data collection device.
    Type: Grant
    Filed: January 22, 2010
    Date of Patent: September 10, 2013
    Assignee: Casio Computer Co., Ltd.
    Inventors: Kouji Miyahara, Koji Nishitani, Hideki Takamura, Noriyoshi Katsumura
  • Patent number: 8527865
    Abstract: Architecture includes for translating server calculations into client application formulas. The architecture determines dependencies, performs formulae translation, and processes data retrieval queries using the translated formulae. In one implementation, the architecture translates performance management server calculations into spreadsheet application formulas so that the impact of changes can be reflected immediately. Moreover, this technique does not require updating and querying of the performance management server. An algorithm is provided that allows translation of the backend formula (e.g., MDX—multidimensional expressions) directly into the spreadsheet application such that the impact on calculated values by an input change can be reflected instantaneously in the sheet.
    Type: Grant
    Filed: May 23, 2008
    Date of Patent: September 3, 2013
    Assignee: Microsoft Corporation
    Inventors: Baomin Li, George Yan, Mark Yang
  • Patent number: 8515923
    Abstract: A document repository management system for an institution having a defined organization is provided. The document repository management system has (a) a first database containing an organization chart and organizational chart information including information identifying individuals in the defined organization, (b) a second database containing accessible documents, (c) programs for controlling requested access to each document of the accessible documents in the second database, and (d) programs for mapping, to the organization chart and the organizational chart information of the first database, each requested access to each document of the accessible documents, thereby enabling efficient management of the document repository based on historical tracking of actual usage of each document by individuals and groups on the organization chart.
    Type: Grant
    Filed: April 2, 2007
    Date of Patent: August 20, 2013
    Assignee: Xerox Corporation
    Inventors: John C Wenn, Daniel W Manchala, Leonid Orlov
  • Patent number: 8484549
    Abstract: In an embodiment, a computer-implemented method facilitates optimization analysis and sensitivity analysis of a data model. The method comprises a computer: receiving first data identifying a value function, a plurality of parameters for the value function, and one or more specific parameter values for one or more of the parameters; storing a data model based on the value function and the specific parameter values; determining which parameters of the data model are capable of taking variable values; receiving second data identifying one or more selected parameters; receiving third data specifying a value selection approach for each of the selected parameters; determining a plurality of result values by substituting, based on the value selection approach, a plurality of input values for each of the selected parameters and evaluating the value function using the selected parameters and the substituted values; generating and causing displaying a table of the result values.
    Type: Grant
    Filed: June 5, 2009
    Date of Patent: July 9, 2013
    Assignee: Palantir Technologies, Inc.
    Inventors: Brandon Burr, Derek Cicerone, Kevin Simler
  • Patent number: 8468442
    Abstract: A method of viewing information associated with data in a spreadsheet, includes providing a document including data and information associated with the data, parsing the document to retrieve the associated information, processing the associated information to break the associated information down into at least one sentence, categorizing the at least one sentence to determine whether the at least one sentence corresponds to at least one category in a taxonomy corresponding to the data, assigning an association strength to the categorized at least one sentence, the association strength indicating a likelihood that the categorized at least one sentence actually corresponds to the at least one category in the taxonomy, filtering the at least one categorized sentence based on the association strength to determine whether to match the categorized at least one sentence with the at least one category in the taxonomy and outputting only the categorized at least one sentence matched with the at least one category in th
    Type: Grant
    Filed: February 8, 2011
    Date of Patent: June 18, 2013
    Assignee: RR Donnelley Financial, Inc.
    Inventors: Stefan Chopin, Robert Krugman, Marc Strausberg, Leslie Barrett
  • Patent number: 8436871
    Abstract: A sortable and space efficient graphical user interface and a system for the efficient display of sortable data are disclosed herein. The graphical user interface may include at least one column, at least one row and a data cell defined by the intersection of at least one column and at least one row. First and second data may be displayed in the data cell. A first header is associated with the first column and identifies the first data. A second header is associated with the first column and identifies the second data. In the system for displaying sortable data, a graphical user interface is displayed upon a graphical display. A table is displayed as at least a portion of the graphical user interface, the table having a column with a plurality of rows, each row displaying first and second data and a first header associated with a first data and a second header associated with the second data.
    Type: Grant
    Filed: April 18, 2008
    Date of Patent: May 7, 2013
    Assignee: General Electric Company
    Inventor: Robert Joseph Alberte
  • Patent number: 8402361
    Abstract: Methods, systems, and machine-readable mediums are disclosed for viewing multiply-dimensioned data. In one embodiment, a method is disclosed which comprises displaying multiply-dimensioned data in a table format, the table format having a plurality of rows, a plurality of columns, and a plurality of cells displaying data, a first column of the plurality of columns including data having at least two hierarchical levels. Data for at least a first set of the plurality of cells is displayed in a graphical format, the first set including cells in the first column, the graphical format of the cells in the first set in the first column indicating a hierarchical level associated with the cell data and a mechanism is displayed for a first one of the rows to display at least one additional row having data in the first column associated with a lower hierarchical level of the first row data.
    Type: Grant
    Filed: September 30, 2008
    Date of Patent: March 19, 2013
    Assignee: Oracle International Corporation
    Inventor: Joseph H. Goldberg
  • Patent number: 8385894
    Abstract: An information delivery apparatus is provided, including a receiving portion to receive location information of a mobile communication terminal at a given time and acquired date and time of the location information from the terminal, an event information storage portion to store event information including an event place, date and time, a delivery terminal selecting portion to select the mobile communication terminal to which the event information is to be delivered based on the location information and the acquired date and time of the location information and on the event place, date and time, and an event information delivery portion to deliver the event information to the selected mobile communication terminal. The delivery terminal selecting portion selects the mobile communication terminal whose location indicated by location information is within a predetermined range and whose acquired date and time of the location information are before the event date and time.
    Type: Grant
    Filed: October 27, 2011
    Date of Patent: February 26, 2013
    Assignee: Sony Corporation
    Inventors: Mitsuru Takehara, Yoichiro Sako, Masamichi Asukai, Taiji Ito, Akinobu Sugino, Akane Sano, Yoshiteru Kamatani, Kazunori Hayashi, Takayasu Kon, Yasunori Kamada
  • Patent number: 8356242
    Abstract: A method, system, and article of manufacture for quickly and easily obtaining information about a list of elements. One embodiment of the invention comprises receiving a selection of at least one desired summary function, generating a configuration file containing the at least one desired summary function, receiving a selection of a list of numbers, copying the list of numbers into a clipboard, parsing the configuration file to extract the least one desired function, calculating the at least one desired summary function using the list of desired numbers to generate summary information, displaying the summary information in a pop-up window, and replacing the selected list of numbers with the summary information. The results window may be a pop-window, a hover-help window, or a clipboard.
    Type: Grant
    Filed: January 12, 2009
    Date of Patent: January 15, 2013
    Assignee: SAP AG
    Inventor: Gregory Paul Andrews
  • Patent number: 8312105
    Abstract: Provided is a method for displaying information such as lists of data, files and icons in a window of a graphical user interface (GUI). Unlike a typical display methodology, which arranges items in a “machine-dependent” sorting order, the disclosed technology provides a “natural” sorting order. The list, or names associated with the files or icons are incorporated into a query and the query is transmitted to a web service. The web service parses the query to determine a natural order appropriate to the material represented by the list, files, or icons rearranges the list, files or icons into the natural order and returns a response to the originator of the query. The operating system or GUI that originated the query receives the response, parses the response and displays the list, files or icons in the corresponding natural order.
    Type: Grant
    Filed: April 28, 2009
    Date of Patent: November 13, 2012
    Assignee: International Business Machines Corporation
    Inventors: Michael N. Abernethy, Jr., Travis M. Grigsby, Jacob L. Moilanen, Nazgol Sedghi
  • Patent number: 8266518
    Abstract: A tool set is provided that uses a series of modules (e.g. spreadsheet workbooks) for assessing risks/threats to and attacks against a project and developing countermeasures against such risks/threats/attacks. The project may cover a wide berth of functionality from alarm systems, computer security, building projects, etc. The roll up feature of the spreadsheet may be employed to evaluate changing scenarios in a short period of time. Ranked threats and countermeasures operable to defeat such threats may be displayed in a tree diagram generated by one or more of the modules.
    Type: Grant
    Filed: January 16, 2008
    Date of Patent: September 11, 2012
    Assignee: Raytheon Company
    Inventor: Joseph Di Beneditto
  • Patent number: 8255789
    Abstract: Heuristic based feature degradation and/or restoration is disclosed. In some embodiments, a feature is provided with respect to a set of spreadsheet cells. The feature consumes processing power. If a degradation threshold associated providing the feature is satisfied, the feature is at least partially degraded so that an expected latency of providing the feature is at least in part avoided. If a restoration threshold associated with providing the feature is satisfied, the feature is at least partially restored for the set of cells.
    Type: Grant
    Filed: September 30, 2008
    Date of Patent: August 28, 2012
    Assignee: Apple Inc.
    Inventors: Peter Glen Berger, Yaniv Gur
  • Patent number: 8250460
    Abstract: 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.
    Type: Grant
    Filed: September 29, 2011
    Date of Patent: August 21, 2012
    Assignee: Google Inc.
    Inventors: Ronald Ho, Fuzzy Khosrowshahi