Alternative Scenario Management Patents (Class 715/213)
-
Patent number: 11972005Abstract: 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: GrantFiled: June 30, 2021Date of Patent: April 30, 2024Inventor: Lee David Buckland
-
Patent number: 11782928Abstract: 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: GrantFiled: June 30, 2020Date of Patent: October 10, 2023Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Pak On Chan, Sharada Shirish Acharya
-
Patent number: 11645227Abstract: 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: GrantFiled: July 21, 2022Date of Patent: May 9, 2023Assignee: DealVector, Inc.Inventors: Subhrojit Nag, Manish Kumawat
-
Patent number: 11645228Abstract: 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: GrantFiled: July 21, 2022Date of Patent: May 9, 2023Assignee: DealVector, Inc.Inventors: Subhrojit Nag, Manish Kumawat
-
Patent number: 11645229Abstract: 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: GrantFiled: July 21, 2022Date of Patent: May 9, 2023Assignee: DealVector, Inc.Inventors: Subhrojit Nag, Manish Kumawat
-
Patent number: 11630948Abstract: 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: GrantFiled: February 12, 2021Date of Patent: April 18, 2023Assignee: Google LLCInventors: Joseph J. Kaptur, Zachary E. Lloyd
-
Patent number: 11500839Abstract: 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: GrantFiled: September 30, 2020Date of Patent: November 15, 2022Assignee: Amazon Technologies, Inc.Inventors: Venkata Rao Pedapati, Adrian Kwok, Anupam Srivastava, Wilfred Xavier Zhi Zhiang Wee, Helbert Fonseca Maich
-
Patent number: 11481451Abstract: 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: GrantFiled: May 21, 2019Date of Patent: October 25, 2022Assignee: JPMORGAN CHASE BANK, N.A.Inventors: Matthew Yazdi, Manish Doshi, Fazil Syed, Smitha Vijayendra, Grant Poladian, Yue Lin
-
Patent number: 11423218Abstract: 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: GrantFiled: December 10, 2020Date of Patent: August 23, 2022Assignee: Microsoft Technology Licensing, LLCInventors: Michelle Elena Keslin, Christopher John Gross, Joseph Mcdaid, Andrew James Becker, Su-Piao Bill Wu
-
Patent number: 11347936Abstract: 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: GrantFiled: November 19, 2020Date of Patent: May 31, 2022Assignee: International Business Machines CorporationInventor: Jin Leem
-
Patent number: 11308269Abstract: 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: GrantFiled: August 24, 2020Date of Patent: April 19, 2022Assignee: HITPS LLCInventors: Todd Rodgers, Harish Krishnaswamy
-
Patent number: 11281687Abstract: 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: GrantFiled: January 17, 2020Date of Patent: March 22, 2022Assignee: SIGMA COMPUTING, INC.Inventors: Max H. Seiden, Jason D. Frantz, Donald Huang
-
Patent number: 11227106Abstract: 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: GrantFiled: July 24, 2019Date of Patent: January 18, 2022Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: 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: 11228656Abstract: 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: GrantFiled: October 23, 2020Date of Patent: January 18, 2022Assignee: Express Scripts Strategic Development, Inc.Inventors: Johnu Celestine, Surya Teja Reddy Kotha, Dmitry Milman, Robert W. Scanlon, Daniel E. Powers, David Erickson
-
Patent number: 11106866Abstract: 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: GrantFiled: June 27, 2018Date of Patent: August 31, 2021Assignee: ZEBRYSInventors: Christophe Genolini, Aygul Abakirova
-
Patent number: 11100280Abstract: 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: GrantFiled: October 10, 2019Date of Patent: August 24, 2021Assignee: Bank of America CorporationInventors: Tim Zhao, Akshay Patel, Indrani Mohanty
-
Patent number: 11087015Abstract: 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: GrantFiled: December 4, 2020Date of Patent: August 10, 2021Inventor: Lee David Buckland
-
Patent number: 11017014Abstract: 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: GrantFiled: May 21, 2016Date of Patent: May 25, 2021Assignee: Box, Inc.Inventors: Cody D. Ebberson, Reshma K. Ebberson
-
Patent number: 10922482Abstract: 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: GrantFiled: August 5, 2019Date of Patent: February 16, 2021Assignee: GOOGLE LLCInventors: Joseph J. Kaptur, Zachary E. Lloyd
-
Patent number: 10891434Abstract: 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: GrantFiled: November 21, 2018Date of Patent: January 12, 2021Assignee: Microsoft Technology Licensing, LLCInventors: Simon L. Peyton Jones, Advait Sarkar, Andrew Gordon, Richard Matthew McCutchen
-
Patent number: 10853558Abstract: 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: GrantFiled: February 20, 2019Date of Patent: December 1, 2020Assignee: Adobe Inc.Inventors: Rohit Kumar Dubey, Anurag Singh, Aman Arora
-
Patent number: 10775985Abstract: 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: GrantFiled: December 29, 2016Date of Patent: September 15, 2020Assignee: KONICA MINOLTA LABORATORY U.S.A., INC.Inventor: Howard Rubin
-
Patent number: 10726201Abstract: 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: GrantFiled: June 29, 2018Date of Patent: July 28, 2020Assignee: Microsoft Technology Licensing, LLCInventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
-
Patent number: 10699068Abstract: 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: GrantFiled: June 29, 2018Date of Patent: June 30, 2020Assignee: Microsoft Technology Licensing, LLCInventors: Christopher John Gross, Johnny Campbell, Claudio Vittorio Russo
-
Patent number: 10558744Abstract: 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: GrantFiled: November 20, 2017Date of Patent: February 11, 2020Assignee: Real Innovations International LLCInventor: Andrew Thomas
-
Patent number: 10496740Abstract: 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: GrantFiled: June 29, 2018Date of Patent: December 3, 2019Assignee: Microsoft Technology Licensing, LLCInventors: Christopher John Gross, Jeffrey James Duzak, Andrew James Becker, Claudio Vittorio Russo, Andrew Donald Gordon
-
Patent number: 10489506Abstract: 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: GrantFiled: May 20, 2016Date of Patent: November 26, 2019Assignee: BlackBerry LimitedInventors: Marcin Cietwierkowski, Nazih Almalki, Robert George Oliver, Zhe Chen, Andrew Michael Inwood
-
Patent number: 10467337Abstract: 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: GrantFiled: October 27, 2015Date of Patent: November 5, 2019Assignee: Kinaxis Inc.Inventors: Syed Ali Haider, Christopher David Burt, Matthew S. Chmiel, David Dewar, Ryan Christopher McCluskey
-
Patent number: 10462206Abstract: 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: GrantFiled: November 20, 2017Date of Patent: October 29, 2019Assignee: Real Innovations International LLCInventor: Andrew Thomas
-
Patent number: 10229750Abstract: 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: GrantFiled: January 18, 2017Date of Patent: March 12, 2019Assignee: Bank of America CorporationInventors: Akshay Patel, Kanika Vij
-
Patent number: 9747266Abstract: 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: GrantFiled: January 31, 2011Date of Patent: August 29, 2017Assignee: Microsoft Technology Licensing, LLCInventors: Raymond E. Ozzie, Jack E. Ozzie, Paresh S. Suthar, Raman Narayanan, Matthew S. Augustine
-
Patent number: 8942731Abstract: 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: GrantFiled: January 14, 2013Date of Patent: January 27, 2015Assignee: Sony CorporationInventors: Mitsuru Takehara, Yoichiro Sako, Masamichi Asukai, Taiji Ito, Akinobu Sugino, Akane Sano, Yoshiteru Kamatani, Kazunori Hayashi, Takayasu Kon, Yasunori Kamada
-
Patent number: 8782509Abstract: 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: GrantFiled: July 24, 2013Date of Patent: July 15, 2014Assignee: Huawei Technologies Co., Ltd.Inventor: Wenfang Tang
-
Patent number: 8730264Abstract: 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: GrantFiled: September 26, 2011Date of Patent: May 20, 2014Assignee: Google Inc.Inventor: Brian Cornell
-
Patent number: 8725738Abstract: 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: GrantFiled: October 29, 2010Date of Patent: May 13, 2014Assignee: Gemvision Corporation, LLCInventor: Jeffrey High
-
Patent number: 8725604Abstract: 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: GrantFiled: October 22, 2009Date of Patent: May 13, 2014Assignee: Thomson Reuters (Tax & Accounting) Services, Inc.Inventor: Michael Knighton
-
Patent number: 8707156Abstract: 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: GrantFiled: April 2, 2009Date of Patent: April 22, 2014Assignee: Business Objects, S.A.Inventors: Wei Xue, Shuai Zhao, Leo Chi-Lok Yu
-
Patent number: 8533583Abstract: 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: GrantFiled: January 22, 2010Date of Patent: September 10, 2013Assignee: Casio Computer Co., Ltd.Inventors: Kouji Miyahara, Koji Nishitani, Hideki Takamura, Noriyoshi Katsumura
-
Patent number: 8527865Abstract: 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: GrantFiled: May 23, 2008Date of Patent: September 3, 2013Assignee: Microsoft CorporationInventors: Baomin Li, George Yan, Mark Yang
-
Patent number: 8515923Abstract: 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: GrantFiled: April 2, 2007Date of Patent: August 20, 2013Assignee: Xerox CorporationInventors: John C Wenn, Daniel W Manchala, Leonid Orlov
-
Patent number: 8484549Abstract: 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: GrantFiled: June 5, 2009Date of Patent: July 9, 2013Assignee: Palantir Technologies, Inc.Inventors: Brandon Burr, Derek Cicerone, Kevin Simler
-
Patent number: 8468442Abstract: 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 thType: GrantFiled: February 8, 2011Date of Patent: June 18, 2013Assignee: RR Donnelley Financial, Inc.Inventors: Stefan Chopin, Robert Krugman, Marc Strausberg, Leslie Barrett
-
Patent number: 8436871Abstract: 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: GrantFiled: April 18, 2008Date of Patent: May 7, 2013Assignee: General Electric CompanyInventor: Robert Joseph Alberte
-
Patent number: 8402361Abstract: 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: GrantFiled: September 30, 2008Date of Patent: March 19, 2013Assignee: Oracle International CorporationInventor: Joseph H. Goldberg
-
Patent number: 8385894Abstract: 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: GrantFiled: October 27, 2011Date of Patent: February 26, 2013Assignee: Sony CorporationInventors: Mitsuru Takehara, Yoichiro Sako, Masamichi Asukai, Taiji Ito, Akinobu Sugino, Akane Sano, Yoshiteru Kamatani, Kazunori Hayashi, Takayasu Kon, Yasunori Kamada
-
Patent number: 8356242Abstract: 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: GrantFiled: January 12, 2009Date of Patent: January 15, 2013Assignee: SAP AGInventor: Gregory Paul Andrews
-
Patent number: 8312105Abstract: 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: GrantFiled: April 28, 2009Date of Patent: November 13, 2012Assignee: International Business Machines CorporationInventors: Michael N. Abernethy, Jr., Travis M. Grigsby, Jacob L. Moilanen, Nazgol Sedghi
-
Patent number: 8266518Abstract: 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: GrantFiled: January 16, 2008Date of Patent: September 11, 2012Assignee: Raytheon CompanyInventor: Joseph Di Beneditto
-
Patent number: 8255789Abstract: 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: GrantFiled: September 30, 2008Date of Patent: August 28, 2012Assignee: Apple Inc.Inventors: Peter Glen Berger, Yaniv Gur
-
Patent number: 8250460Abstract: 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: GrantFiled: September 29, 2011Date of Patent: August 21, 2012Assignee: Google Inc.Inventors: Ronald Ho, Fuzzy Khosrowshahi