Product
Patsnap Eureka
For R&D, Patsnap Eureka makes reading and utilizing patents & technical documents easy.
Patsnap Eureka AIR
Designed for self-driven R&D workflows. Generate viable solutions, solve complex R&D challenges, empower your innovation with AI.
Patsnap Eureka Materials
Designed for material experts only. Revolutionize your material R&D, from search, analyze, to developing new materials.
Feature
TechResearch
Generate reliable direction feasibility study reports for your R&D in just a few steps.
TechSeek
Discover and master advanced knowledge NOW. Basics, ideas, possibilities, all at once.
TechMind
As an expert in R&D Theories, TechMind can generates customized viable solutions instantly.
TechRisk
Analyze your overall solution with one click, know your potential R&D risks in advance.
TechMonitor
Get weekly tech updates, stay abreast of the latest tech innovations and key insights.
Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
65 results about "Pivot table" patented technology
Efficacy Topic
Property
Owner
Technical Advancement
Application Domain
Technology Topic
Technology Field Word
Patent Country/Region
Patent Type
Patent Status
Application Year
Inventor
A pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.
Method and implementation for referencing of dynamic data within spreadsheet formulas
InactiveUS20060069696A1Adaptable to changeSnap fastenersData processing applicationsElectronic formDisplay device
The present invention relates to a new type of structured name within a spreadsheet program that allows users to refer to tables, columns of data within tables, headers of tables, totals from tables, PivotTables®, and portions of PivotTable® data by the data's headers. Embodiments of the present invention comprise a method for referring to a set of data that comprises receiving one or more semantic designations, wherein the one or more semantic designations name a set of context information that describes one or more items of data in a data structure, automatically creating a structural reference, and associating the context information with the structural reference. Other embodiments of the present invention relate to an interaction with a user interface for displaying on a display device a structural reference to data in a spreadsheet that comprises receiving one or more semantic designations from the user that refer to one or more elements of the data structure, creating a structural reference to the elements of the data structure, and displaying the structural reference as a collection of the one or more semantic designations.
Owner:MICROSOFT TECH LICENSING LLC
Dynamic Pivot Table Creation and Modification
InactiveUS20140019842A1Disadvantages can be reduced eliminatedProblems be reduced eliminatedText processingSpecial data processing applicationsData setComputer science
In an exemplary embodiment, a method includes determining a plurality of field identifiers of a data set. A plurality of field cells that each correspond to a field identifier of the plurality of field identifiers are generated and displayed within an available fields region. A column field region and a row field region are displayed. A first field cell of the plurality of field cells is moved from the available fields region to the column field region or the row field region in response to a first input from a user. The pivot table is updated to include one or more rows or columns corresponding to the first field cell upon detection of the movement of the first field cell to the column field region or the row field region.
Owner:BANK OF AMERICA CORP
Data analysis method
InactiveUS20090327851A1Simple methodText processingSpecial data processing applicationsData setElectronic form
A data analysis method is disclosed. The method comprises aggregating related data tables with dissimilar data structures, and combining the tables, and data structures, into a single table that incorporates all the individual data structures. The single table is then analyzed via a pivot table function of a spreadsheet program, such as Microsoft Excel. The method is suited for quickly comparing related but dissimilar sets of data—an important task in virtually every field of human endeavor, from manufacturing to health care to financial services. The present invention provides an improved way to quickly access important strategic information using multiple sources of data.
Owner:RAPOSO STEVEN
Data analysis expressions
ActiveUS20110087954A1Well formedMemory adressing/allocation/relocationText processingElectronic formData profiling
Methods and systems are disclosed for receiving and processing data analysis expressions. A particular method includes receiving a data analysis expression at a pivot table of a spreadsheet. The data analysis expression is executed for a particular cell of the pivot table by determining a context associated with the particular cell, calculating a value of the data analysis expression based on the context, and outputting the calculated value at the particular cell.
Owner:MICROSOFT TECH LICENSING LLC
Enterprise structure configurator
ActiveUS20090063549A1Easy to identifyCommerceSpecial data processing applicationsUser interfaceData structure
Tools for configuring an enterprise applications. In one aspect, the tools provide a user interface to allow an implementer describe, based on an interview with executives of the organization, an enterprise structure of an organization, and a data structure generator to configure the enterprise application to reflect this enterprise structure. In one aspect, these tools can allow a general case to guide the default assignment of intersections of legal and managerial reporting structures to a business unit, allowing the minimum number of business units to fulfill both the external and managerial responsibilities. The tools may implement a pivot table approach to provide an interface for the user to provide such input.
Owner:ORACLE INT CORP
Creating pivot tables from tabular data
InactiveUS20090210430A1Data processing applicationsDigital data processing detailsData setData source
System and method of simultaneously creating and managing a plurality of OLAP cubes in real time, each from a different tabular data source, comprising, for each cube, defining the table columns as either dimensions or measures of the cube using at least one of predefined semantics and data formats, generating the cube using said defined dimensions and measures, updating the cube when the respective data source is modified and deleting the cube according to predefined criteria.
Owner:PANORAMA SOFTWARE
Game table having a pivoting table section for chess and backgammon and having storage compartments therein
A game table for playing different types of games. The game table includes a frame section having a centrally-located opening with a rotatable table section mounted therein. The game table further includes a pair of pivot pins for rotating the table section being cooperatively mounted on the table section and the frame section for rotating the table section up to 360° relative to the frame section. The table section includes a first playing surface on the top surface thereof and a second playing surface on the bottom surface thereof; wherein the first and second playing surfaces include a first game board and a second and different game board, respectively, thereon. The frame section and the table section include a pull-out stop pin for retaining the table section in a horizontal plane relative to the frame section. The pull-out stop pin is movable between a retaining position and a non-retaining position for allowing the table section to rotate. Additionally, the frame section includes storage compartments on opposing sides of the opening in the frame section.
Owner:BIBI REUBEN
Method and system for using page-based object flow verification in regression test
InactiveCN101526916AQuality assuranceReduce manual testing timeSoftware testing/debuggingRegression testingProgramming language
The invention provides a method for using page-based object flow verification in a regression test, which comprises the following steps: recording a test automation script operated by a functional flow, and generating an object pivot table from different pages according to the operation sequence of a main functional flow; during the execution of a new round of regression test, generating an object historical table of an operation page of the function value; and contrasting the pivot table with the object historical table to determine whether the pivot table and the object historical table have differences in the same functional page and the sate and sequence of the same object and generating and outputting a test difference report. The invention provides a device for using the page-based object flow verification in the regression test. The invention can greatly reduce time for manual test and increase in the test number due to frequency program correction, ensures program quality and avoids test risks.
Owner:ALIBABA GRP HLDG LTD
Pivot analysis with XML/XSL mechanism
InactiveUS20060101329A1Reduce memory requirementsSimple working processData processing applicationsNatural language data processingXSLTRelational database
A pivot analysis with an XML / XSL mechanism is disclosed. The pivot analysis is utilized to acquire the raw data from a relational database and then the raw data is converted into a XML data by a pivot transformation mechanism. Furthermore, the XSL / XSLT mechanism is configured to modify the XML data and thus the post processing of the pivot tables, for instance, a row calculation and a column calculation can be performed.
Owner:INFOPOWER
Creating pivot tables from tabular data
InactiveUS8121975B2Data processing applicationsDigital data processing detailsData setTheoretical computer science
System and method of simultaneously creating and managing a plurality of OLAP cubes in real time, each from a different tabular data source, comprising, for each cube, defining the table columns as either dimensions or measures of the cube using at least one of predefined semantics and data formats, generating the cube using said defined dimensions and measures, updating the cube when the respective data source is modified and deleting the cube according to predefined criteria.
Owner:PANORAMA SOFTWARE
User interface method and apparatus for data from data cubes and pivot tables
Systems, methods, and computer readable media provide space-efficient user interfaces to data cubes and pivot table information. Because the user interfaces are more efficient in usage of display area, smaller displays can be used more effectively in reviewing such data. The user interfaces provide a multi-dimensional navigation approach among dimensions represented in the data, which allows users to more easily maintain context when reviewing large pivot table reports, and the like. Other user interface features that ease review of such reports on smaller devices also are disclosed.
Owner:SAP AG
Generating A Pivot Table From An Aggregated Data Set
InactiveUS20130179443A1Disadvantages can be reduced eliminatedProblems be reduced eliminatedDigital data information retrievalDigital data processing detailsData setData value
In an exemplary embodiment, a method includes receiving a request to access a data set comprising a plurality of data entries. A data entry comprises one or more data values that are each associated with a field identifier of a plurality of field identifiers. The method may further include, determining the plurality of field identifiers of the data set. A plurality of formatting preferences associated with the plurality of field identifiers may be received. A request to generate a first aggregated data set comprising an aggregation of two or more data entries of the plurality of data entries may be communicated. The aggregation may be based on the plurality of formatting preferences. A pivot table may be generated according to the formatting preferences and the aggregated data set. The first pivot table may comprise at least one column field, a plurality of row fields, and a plurality of table entries.
Owner:BANK OF AMERICA CORP
Game table having a pivoting table section for chess and backgammon and having storage compartments therein
A game table for playing different types of games. The game table includes a frame section having a centrally-located opening with a rotatable table section mounted therein. The game table further includes a pair of pivot pins for rotating the table section being cooperatively mounted on the table section and the frame section for rotating the table section up to 360° relative to the frame section. The table section includes a first playing surface on the top surface thereof and a second playing surface on the bottom surface thereof; wherein the first and second playing surfaces include a first game board and a second and different game board, respectively, thereon. The frame section and the table section include a pull-out stop pin for retaining the table section in a horizontal plane relative to the frame section. The pull-out stop pin is movable between a retaining position and a non-retaining position for allowing the table section to rotate. Additionally, the frame section includes storage compartments on opposing sides of the opening in the frame section.
Owner:BIBI REUBEN
Anomaly detection in data perspectives
InactiveUS20050288883A1Precise positioningImprove satisfactionMathematical modelsData processing applicationsData setDrill down
The present invention leverages curve fitting data techniques to provide automatic detection of data anomalies in a “data tube” from a data perspective, allowing, for example, detection of data anomalies such as on-screen, drill down, and drill across data anomalies in, for example, pivot tables and / or OLAP cubes. It determines if data substantially deviates from a predicted value established by a curve fitting process such as, for example, a piece-wise linear function applied to the data tube. A threshold value can also be employed by the present invention to facilitate in determining a degree of deviation necessary before a data value is considered anomalous. The threshold value can be supplied dynamically and / or statically by a system and / or a user via a user interface. Additionally, the present invention provides an indication to a user of the type and location of a detected anomaly from a top level data perspective.
Owner:MICROSOFT TECH LICENSING LLC
Method and system for automatically generating template based spreadsheet pivot tables
For applications of web-based analytics and business intelligence reporting, methods and systems are provided for exporting a data table as a spreadsheet pivot table by automatic creation of formatted spreadsheet pivot tables with application specific initial views. The views are specified by templates allowing a user to view multiple pivot tables in a single spreadsheet book. Pivot tables are created by a remote server that performs the exporting of the data table so that a user can save the pre created pivot table in his / her local machine. In one embodiment of the invention, the data table on which a pivot table is subject to have a limited number of rows of a spreadsheet data sheet. In another embodiment, the data table on which a pivot table is subject to can exceed the limit of the number of rows of a spreadsheet data sheet.
Owner:PATEL DILIP
User interface method and apparatus for data from data cubes and pivot tables
Systems, methods, and computer readable media provide space-efficient user interfaces to data cubes and pivot table information. Because the user interfaces are more efficient in usage of display area, smaller displays can be used more effectively in reviewing such data. The user interfaces provide a multi-dimensional navigation approach among dimensions represented in the data, which allows users to more easily maintain context when reviewing large pivot table reports, and the like. Other user interface features that ease review of such reports on smaller devices also are disclosed.
Owner:MELLMO
Anomaly detection in data perspectives
InactiveUS20060106560A1Precise positioningEasy to determineMathematical modelsData processing applicationsData setDrill down
The present invention leverages curve fitting data techniques to provide automatic detection of data anomalies in a “data tube” from a data perspective, allowing, for example, detection of data anomalies such as on-screen, drill down, and drill across data anomalies in, for example, pivot tables and / or OLAP cubes. It determines if data substantially deviates from a predicted value established by a curve fitting process such as, for example, a piece-wise linear function applied to the data tube. A threshold value can also be employed by the present invention to facilitate in determining a degree of deviation necessary before a data value is considered anomalous. The threshold value can be supplied dynamically and / or statically by a system and / or a user via a user interface. Additionally, the present invention provides an indication to a user of the type and location of a detected anomaly from a top level data perspective.
Owner:MICROSOFT TECH LICENSING LLC
Analysis view for pivot table interfacing
InactiveUS20160253308A1Text processingSpecial data processing applicationsGraphicsProgramming language
Various methods, systems and storage devices are used for creating and utilizing an analysis view for pivot table interfacing. The analysis view can be created with a visualization that reflects data summarized in the pivot table automatically in response to detecting user input directed at a particular data field (i.e., cell) of the pivot table and without requiring any additional user input, such as user input required to navigate a chart wizard or any other graphics interface. The visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed, unless it is first dragged outside of the boundaries of the analysis view window and without requiring additional user input for separately closing and / or removing the transient object.
Owner:MICROSOFT TECH LICENSING LLC
Enterprise structure configurator
Tools for configuring an enterprise applications. In one aspect, the tools provide a user interface to allow an implementer describe, based on an interview with executives of the organization, an enterprise structure of an organization, and a data structure generator to configure the enterprise application to reflect this enterprise structure. In one aspect, these tools can allow a general case to guide the default assignment of intersections of legal and managerial reporting structures to a business unit, allowing the minimum number of business units to fulfill both the external and managerial responsibilities. The tools may implement a pivot table approach to provide an interface for the user to provide such input.
Owner:ORACLE INT CORP
Enhanced pivot table creation and interaction
ActiveUS20180239748A1Simplify creationText processingSpecial data processing applicationsInteraction systemsElectronic form
Systems, methods, and software are disclosed herein for enhanced pivot table creation and interaction. In an implementation, a view including a formula bar is rendered in a user interface to a spreadsheet application. In response to receiving a user initialization input, the view is rendered to hide the formula bar and display a configuration bar configured to receive at least one pivot table parameter. A pivot table is generated based on the at least one pivot table parameter. The view is rendered to display the formula bar after generation of the pivot table.
Owner:MICROSOFT TECH LICENSING LLC
Interactive analysis of mass spectrometry data
This invention relates to graphical user-interactive analysis of data, including in particular, mass spectrographic data analysis, as well as methods and software for generating and using such. One aspect provides user-customizable reports, including methods and apparatuses for generating customizable pivot tables and graphs specific to mass spectrographic data.
Owner:PROTEIN METRICS LLC
Drill Press with Pivotable Table
InactiveUS20150283620A1Easy to useQuick fixDrilling/boring measurement devicesThread cutting machinesDrillPivot table
A drill press with pivot table(s) includes a support column and a collar disposed on an outer periphery of the support column. The outer periphery of the support column and the collar delimit a first groove therebetween. A base connects to the support column. The outer periphery of the support column and the base delimit a second groove therebetween. A pivotal device is movable relative to the support column. The pivotal device has various fixed pivoting and sliding positions relative to the support column. A first work platform connects to the pivotal device. The first work platform is movable relative to the pivotal device. A second work platform connects to the pivotal device. The second work platform is movable relative to the pivotal device.
Owner:CHANG LEE CHENG
Therapeutic system
InactiveUS20100063427A1Relieve pressureComfortable supportChiropractic devicesVibration massageEngineeringVisual perception
The therapeutic system provides an oscillatory, pivoting table for applying motion-induced therapeutic sensory stimuli to a user. Further, therapeutic audio and visual output may be provided to the user during the application of the therapeutic sensory stimuli. The therapeutic system includes a base having an upper vertex. A tabletop is pivotally mounted to the upper vertex of the base, and the upper surface of the tabletop is adapted for supporting the user. At least one piston is provided, with the lower end thereof being mounted within the base, and the upper end thereof being pivotally mounted to a lower surface of the tabletop in order to pivot the table with respect to the base in a controlled, oscillatory manner. Oscillation of the table at a user-controlled frequency and angle induces the therapeutic sensory stimuli in the user.
Owner:INGRAO JASON V +1
Skyline inquiry method based on multi-tenant data base in SaaS environment
InactiveCN103150327AImprove scalabilityEarly removalSpecial data processing applicationsData librarySkyline
The invention discloses a skyline inquiry method based on a multi-tenant data base in SaaS environment. The method comprises the following steps that (1) a data base based on multi-tenant facing the SaaS environment is built; (2) a B+ tree index array is built on a pivot table; (3) each candidate link is built according to the B+ tree index array, and candidate nodes are sequentially traversed in turns on each candidate link; and (4) when a Skyline object is traversed, the node is output, in addition, the node is deleted from each candidate link, and the operation returns to the third step if the candidate link is not completed. The skyline inquiry method provided by the invention has great improvement in aspects of reaction time, compatibility and efficiency.
Owner:SCHOOL OF SOFTWARE & MICROELECTRONICS AT WUXI PEKING UNIV
Data analysis expressions
Owner:MICROSOFT TECH LICENSING LLC
Representation of people in a spreadsheet
A spreadsheet includes a native spreadsheet object that represents a person. The person object may be used within a spreadsheet just as any other spreadsheet objects are utilized. For example, the person object may be integrated with spreadsheet formulas and other spreadsheet objects such as charts, tables, pivot tables, sheets, and the like. Spreadsheet formulas may perform operations specific to a person object (e.g. send message, get contact information, get status, get other person specific information, sort, and the like). Common actions may be associated with the person object, such as initiating communication with the person represented by the person object (e.g. phone call, email, text message, collaboration invite, and the like). Social networking information may also be associated with a person object. For example, social networking posts may be included within a spreadsheet, a user may post to a social network from the spreadsheet, and the like.
Owner:MICROSOFT TECH LICENSING LLC
Method and apparatus for executing query and computer readable medium therefor
ActiveUS20170364557A1Efficient queryEfficient storageDigital data information retrievalSpecial data processing applicationsQuery statementData mining
Provided is a method for executing a query in a DBMS. The method may include: receiving a query statement for requesting BLOB data serialized to a binary large object (BLOB) type and stored in a pivot table; determining name information for one or more columns generated as a result of a pivot operation included in respective pivot columns of the pivot table by querying a pivot name table for the pivot table; determining internal storage type information of the pivot table by querying a pivot meta table for the pivot table; and generating output information for the BLOB data corresponding to the query statement based on the determined name information and internal storage type information.
Owner:TMAXTIBERO CO LTD
Interactive analysis of mass spectrometry data
Owner:PROTEIN METRICS LLC
Methods and systems for selectively retrieving data to provide a limited dataset for incorporation into a pivot table
ActiveUS10114867B2Relational databasesSpecial data processing applicationsData setRelational database
The present disclosure provides inclusive and exclusive approaches, including computer-implemented methods for selectively retrieving data from an initial dataset in a relational database to provide a limited dataset for incorporation into a pivot table. Also provided are related systems and non-transitory computer-readable recording media.
Owner:GOOGLE LLC
Touch optimized pivot table
ActiveUS8719725B2Space maximizationEasy to readText processingSpecial data processing applicationsData displayTouchscreen
Embodiments of the invention include a method of implementing a touch screen optimized pivot table. The method includes providing a view of a hierarchal table on a touch screen. The hierarchal table includes hierarchal levels and each of hierarchal levels includes corresponding data. The method further includes mapping each of the hierarchal levels to each of a corresponding region on the touch screen. Each region's view displays the corresponding data for the mapped hierarchal level. The method further includes displaying on the touch screen the corresponding data for each of the hierarchal levels in each of the mapped regions, receiving at the touch screen input to manipulate at least one of the regions on the touch screen, and in response to the received input, causing each subordinate region to the at least one manipulated region to update the corresponding data displayed in each of the subordinate regions.
Owner:ORACLE INT CORP
Who we serve
- R&D Engineer
- R&D Manager
- IP Professional
Why Patsnap Eureka
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com