42 results about "Spread sheet" patented technology

A system for extracting a number of data elements from one or more data sources. A text representing tables using a markdown language is extracted from spreadsheets and or other grid-based documents. The text is provided to a language model with a prompt. The prompt may be a chain-of-thoughts prompt. The prompt includes several requests and / or steps that cause the language model to extract one or more tables from the spreadsheet and output the tables using the markdown language or a different markdown language. The tables extracted from the spreadsheet are converted into table chunks and indexed for retrieval by a retrieval augmented architecture. When a prompt to extract particular information from the spreadsheet is provided, one or more relevant table chunks are identified and provided to a language model for extraction. Using the language model to separate tables improves information extraction accuracy while maintaining downstream instructions.

A client device for managing a distributed document is described. The client device comprises a transfer processor configured to exchange content data with a database, a spreadsheet processor configured to execute a file-based spreadsheet application, and a target processor configured to monitor content locations within a user interface. The transfer processor is configured to receive first content data that includes pre-existing data for a spreadsheet displayed by the application. The target processor is configured to populate first content locations with the first content data according to the identified content locations and capture second content data that is not included in the pre-existing data using content locations identified by a content profile. The content profile identifies content locations for the spreadsheet as displaying static content or user-based content. The transfer processor is configured to store the second content data in the database.

The invention relates to the technical field of data processing, discloses a processing method and device for importing spreadsheet data into a database based on a Java persistent layer framework, equipment and a medium, and aims to solve the problem of low automation degree of importing the spreadsheet data into the database in the prior art. The method comprises the following steps: analyzing spreadsheet data needing to be read, putting the spreadsheet data of each row into a row object, setting an attribute format of each row object as a uniform character string format, obtaining a column value from the row object, and mapping the column value through an object relation configured by a Java-based persistent layer framework, so as to obtain the data of the spreadsheet; according to the method, the spreadsheet data is mapped into the field object of the corresponding table, and the data in the field object is written into the database table, so that the expandability and the automation degree of importing the spreadsheet data into the database are improved, and the method can be applied to but not limited to the medical health field, the financial field and the insurance field.

In a case where query information is stored in a cache sheet when recalculation is performed on a cell, a spreadsheet device (100) acquires an answer stored in the cache sheet in association with the query information, as a value to be stored in the cell in place of transmitting a query to an external server and acquiring an answer.

Aspects described herein may be used with local spreadsheet applications, web, and / or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code / no-code techniques, a designer can create custom and / or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static / read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

Aspects described herein may be used with local spreadsheet applications, web, and / or cloud-based spreadsheet solutions, to create complex custom software applications. Spreadsheets themselves lack the conceptual framework to be used as a platform tool to build custom or complex software applications. Using the methods and systems described herein using low-code / no-code techniques, a designer can create custom and / or complex software applications using one or more spreadsheets as the underlying blueprints for the software application. The resultant software application may be static / read-only, or may be interactive to allow users to dynamically add, delete, edit, or otherwise amend application data, e.g., via one or more online web pages or via a mobile application. Data transfer may be one-way or bi-directional between the blueprint spreadsheets and the resultant software application, thereby allowing amended data to be transferred from the software application back into spreadsheet form.

The invention provides an Excel multi-table continuous repeating data processing system and method, and belongs to the technical field of spreadsheet automation. According to the method, background colors of original table cells are removed through preprocessing; traversing the same Sheet in multiple tables by adopting a sliding window algorithm (the window length N is greater than or equal to 5), and detecting continuously repeated numerical values, texts or formulas in the row or column direction; color marking is carried out based on repeated source differentiation (the same as Sheet marking yellow, cross-Sheet marking red, and RGB self-definition is supported); through picture zooming, gray scale conversion and Hash value comparison, duplicate picture deduplication is realized, and a new table is positioned according to original coordinate parameters; and finally generating a new Excel file which retains original table merging cells, frame styles, font formats and formula structures. According to the method, the three technical problems of continuous repeated region detection missing, picture redundant storage and structure migration distortion are solved, the data processing efficiency and precision are remarkably improved, and the method is suitable for complex scenes in multiple fields such as financial audit, supply chain management and scientific research.

To provide a 3D CAD and spreadsheet software which allow for understanding a phenomenon by quantizing the phenomenon and making the phenomenon three-dimensional and allow for deepening understanding of a more abstruse and complicated phenomenon.SOLUTION: A method for displaying a three-dimensional graph includes drawing a circle with a radius R with an origin O as a center in a plane including an X axis and a Y axis of Cartesian coordinates, setting a point Op (0, 0, p) and equally dividing the circle and a segment from the origin O to the point Op by N, and properly setting N, p, and r. When an n-th measured value is denoted as Kn, coordinates (r.Kn.cos(2π.n / N), r.Kn.sin(2π.n / N), p.n / N) of arbitrary data Dn to be inputted are calculated by spreadsheet software, and the data is read in. When a point adjacent to the point Dn is denoted as a point D(n+1) and an N-th point from the point Dn is denoted as D(n+N) and a point having coordinates (0,0,p.n / N) is denoted as On, a segment from On to Dn, a segment from Dn to D(n+1), and a segment from Dn to D(n+N) are automatically plotted.SELECTED DRAWING: Figure 7

The present disclosure provides an information processing method and apparatus, a terminal, and a storage medium. The information processing method includes: receiving a first condition in an input box of a filter function of a spreadsheet, where the first condition corresponds to a corresponding column of the spreadsheet; obtaining data of each cell of the column corresponding to the first condition, and filtering the data based on the first condition to obtain a filtering result of the data; and outputting result data based on the filter function and the filtering result of the data. By using the filter function of the spreadsheet, multi-condition data filtering and statistics can be achieved, and the statistical requirements of users for table data can be met.

A shielding member (1) that suppresses penetration of noise into a vehicle interior both in a spread sheet state as a single sheet and in a folded state. The shielding member (1) comprises a flexible sheet member (2) that has a plurality of plate parts (3a, 3b) and an intermediate part (4) located between adjacent plate parts (3a, 3b). The sheet member (2) is foldable around the intermediate part (4) and can selectively assume a state in which the sheet member (2) is spread as a single plate and a state in which the plurality of plate parts (3a, 3b) are folded over each other. The plate parts (3a, 3b), with the exception of the intermediate part (4), contain a sound-absorbing layer (6a).

The application discloses a kind of multi-dimension data management method and system based on spreadsheet, method includes: in response to the editing operation instruction of the spreadsheet displayed to client, update the table structure and table data of spreadsheet;Editing operation instruction at least includes one of the drag instruction for dragging the row, column of spreadsheet to freely combine, the hidden filter instruction for hiding filter row, column and the sorting instruction for sorting the data of row, column;Capture the timestamp corresponding to editing operation instruction, with timestamp as index, updated table structure and table data as history data modification record, store the mapping relationship between index and history data modification record;Through mapping relationship, trace history data modification record.Therefore, by using the embodiment of the application, multi-dimension operation can meet the needs of enterprise to inventory management refinement, individualization, while can track to operator and modification history, improve the security and reliability of data.

The invention belongs to the technical field of charging piles, and discloses a charging pile communication message analysis method, which comprises the following steps: selecting a target spreadsheet file corresponding to a charging pile communication message from a plurality of preset spreadsheet files, and inputting the charging pile communication message into the target spreadsheet file; the method comprises the steps of determining an initial byte position and a byte length of each field in a communication message, presetting a field interception function taking the initial byte position and the byte length as parameters for each field, performing field-by-field interception on the communication message by calling the field interception function, and performing field-by-field interception on the communication message. Each field obtained by interception is output; carrying out system conversion on the intercepted field to obtain starting time and ending time; and determining a corresponding rate time period according to the starting time and the ending time, calculating and generating a rate amount according to the rate time period and a preset charging rule, and outputting the rate amount. The problems of low efficiency and poor accuracy during manual analysis are solved.

The present application relates to a key structure and a keyboard. The key structure comprises a key cap, a light emitting unit, and a light spreading sheet. The light spreading sheet is arranged between the light emitting unit and the key cap. Light emitted by the light emitting unit forms a light pattern on a first surface of the light spreading sheet after passing through the light spreading sheet. The light pattern comprises a first light spot, and a position of a normal projection of the first light spot on a projection plane parallel to the light spreading sheet is different from a position of a normal projection of the light emitting unit on the projection plane.

The invention provides an intelligent integration method, device and equipment for a flying book spreadsheet and a system data table, and the method comprises the steps: responding to the triggering of reading the spreadsheet, and loading pre-configured reading task parameters which comprise a flying book access token, a sheet name of the spreadsheet and a parameter configuration table preset for a reading task, the parameter configuration table is used for recording a first mapping relation between a spreadsheet column header and a system data table field; acquiring spreadsheet data based on the fly book access token and a sheet name of the spreadsheet, and extracting a column header field from the spreadsheet data; through at least one matching operation of annotation matching, synonym matching and parameter configuration table matching, constructing a second mapping relationship between the column header field and the system data table field; and writing the spreadsheet data into the system data table based on the second mapping relation. Through the method disclosed by the invention, automatic integration between the spreadsheet and the system data table can be realized.

According to an embodiment, the present invention provides a method for converting spreadsheet files into structured workbooks. The method includes receiving a spreadsheet file and identifying tables within it. Metadata associated with the tables is extracted and matched using fuzzy matching to identify standard objects and reports. The method further includes extracting formulas, selecting templates based on identified objects and reports, and creating a dependency graph. A topological sort is performed on the dependency graph to resolve dependencies. A workbook is generated, including sheets based on the processed tables and dependency graphs, and stored in non-volatile memory. A detailed report is also generated, documenting the conversion process. There are other embodiments as well.

The invention relates to the technical field of ultra-thin aluminum profile extrusion dies, in particular to a uniform heat treatment system and method for a one-die multi-output ultra-thin aluminum profile extrusion die, the uniform heat treatment system comprises a die assembly, a soaking assembly is arranged on the outer side of the die assembly, the soaking assembly comprises soaking boxes which are symmetrically arranged up and down, and the die assembly is arranged in the two soaking boxes; the rear sides of the two soaking boxes are rotationally connected through a hinge, the front sides of the two soaking boxes are connected through a buckle in a clamped mode, a plurality of arc-shaped soaking grooves are formed in the inner walls of the soaking boxes at equal intervals, and the multiple soaking grooves correspond to the mold assemblies in position. A uniform heat conduction layer is formed through thermal expansion of the metal soaking piece to guarantee heating uniformity of the mold, sealing of the heating cavity and uniform introduction of cooling airflow are achieved through linkage of thermal expansion and cold contraction of the metal soaking piece and the cooling holes, thermal stress is reduced fundamentally, mold defects are avoided, the service life of the mold is prolonged, and the qualified rate of aluminum profile products is increased.

Methods and systems are provided for giving a name to an expression within a cell formula so that the said expression can be represented by the given name in all subsequent references within the cell formula in a spreadsheet application. In the edit mode, a user may enter any expression within a formula by its given name after defining it once anywhere in that formula. In the view mode, the cell formula may display all named expressions by their given names, with the definitions of the said names displayed as sub-formulas along with the computed value of the expressions. Features may be implemented as an add-in, a macro, a function, a direct modification of the spreadsheet application, or any combination thereof. Implementations may be used with electronic spreadsheet applications generally, including programs such as Microsoft Excel, Google Sheets, Lotus 123, but not limited to such.

A system for extracting a number of data elements from one or more data sources. A text representing tables using a markdown language is extracted from spreadsheets and or other grid-based documents. The text is provided to a language model with a prompt. The prompt may be a chain-of-thoughts prompt. The prompt includes several requests and / or steps that cause the language model to extract one or more tables from the spreadsheet and output the tables using the markdown language or a different markdown language. The tables extracted from the spreadsheet are converted into table chunks and indexed for retrieval by a retrieval augmented architecture. When a prompt to extract particular information from the spreadsheet is provided, one or more relevant table chunks are identified and provided to a language model for extraction. Using the language model to separate tables improves information extraction accuracy while maintaining downstream instructions.

Technology is disclosed herein for the integration of spreadsheet environments and LLM services. In an implementation, an application receives a natural language input from a user associated with a spreadsheet. The application generates a prompt based on the user input and at least a portion of the spreadsheet. The prompt includes a statement of the problem, a request for an LLM service to identify preparatory steps before generating a solution to the problem, and a request to include the preparatory steps in output that includes the solution to problem. The application service receives a reply to the prompt from the LLM service that includes the output. The application service implements the preparatory steps with respect to data in the spreadsheet and implements the solution to the problem with respect to the data in the spreadsheet.

An enhanced multidimensional data management system significantly reduces the resources required to convert a spreadsheet into an enterprise collaborative system. A spreadsheet may be imported as is without modifications. Additional information that cannot be automatically inferred about the data model used in the spreadsheet is obtained. Dimensions, timescale, and measure data are clearly defined and located. The spreadsheet is kept in the system in the form of both a spreadsheet and as a multidimensional data structure such as an online analytical processing (OLAP) cube or structure. This duality allows the spreadsheet to be manipulated as if it was an OLAP cube, modifying iterations within the dimensions, and the OLAP cube to be computed as if it was a spreadsheet.

The invention discloses a stamping production scheduling management method and device, equipment and a storage medium, and belongs to the technical field of production management. A welding locking plan worksheet, a stamping rolling worksheet, a stamping production scheduling plan worksheet and a sheet pulling worksheet involved in the method are different worksheets in the same spreadsheet workbook, so that the uniform spreadsheet workbook is adopted in the method, data such as a welding plan, a rolling inventory, a stamping plan and sheet requirements are managed in a centralized manner, and the workload of a welding machine is reduced. Stamping production scheduling planning is automatically completed, manual production scheduling planning is not needed, a professional production scheduling system does not need to be purchased, and therefore the production scheduling efficiency can be improved, and the cost can be reduced. Moreover, through the automatic process design of the welding plan, the rolling inventory, the stamping plan and the plate demand, data linkage and page jump among a plurality of worksheets are realized, the scheduling scheme can be quickly adjusted, and the scheduling efficiency and the response speed are greatly improved.

The technology disclosed relates to accessing external data, including massive amounts of data stored in the cloud, in spreadsheet cells: accessing external data direct via a formulaic variable in a spreadsheet, specifying an ordered progression for the accessed external data, selectively propagating data accessed using the formulaic variable vertically or horizontally, within a propagation pattern responsive to normal A$1, $A1 and $A$1 spreadsheet conventions. Two or more external data fields, responsive to the formulaic variable, have an ordered sequence relationship that nests ordering of vectors of the propagated data; and the ordering according to the ordered sequence relationship is maintained during replication by copy and paste. In another disclosed method, the external data is generated using an implicit join of data from at least two external data sources to generate multiple adjoining vectors of spreadsheet cells of data responsive to selection parameters in the formulaic variable.

The present teachings include techniques and systems for processing spreadsheets at the level of a worksheet or another collection of cells, including the fragmenting of spreadsheets. For example, a spreadsheet may include one or more input worksheets, output worksheets, and / or transient worksheets, where transient worksheets utilize input data in input worksheets to facilitate creation of output data in output worksheets. In particular, fragmenting a spreadsheet may include determining, for each output worksheet, what input and transient worksheets are needed to create output data in the output worksheet, and then creating a plurality of fragments therefrom. Thus, fragmenting a spreadsheet may include a temporal and / or physical decoupling of the spreadsheet's worksheets. This can be useful for, inter alia, understanding the relationships between a plurality of worksheets, isolating certain processing tasks, editing or interchanging worksheets, and / or for improving computational performance, e.g., by routing particular fragments to appropriate computational resources for processing thereof.

The invention provides a form page generation method and device. The method comprises the steps of obtaining a spreadsheet file associated with a first service; wherein the spreadsheet file is generated based on a service demand associated with the first service; creating at least one target business model based on a plurality of business fields associated with a first financial service provided by the first business in the spreadsheet file; creating at least one target business component based on the at least one target business model; and on the basis of the at least one target business component, generating the first form page for providing the first financial service, thereby dynamically generating the first form page for providing the first financial service, reducing the time for manually designing and opening the form page, greatly improving the generation efficiency and flexibility of the form page, and improving the user experience. And the form page can be quickly adjusted when the business demand changes, so that the quick response of the financial service is realized, and the user experience is improved.

The technology disclosed relates to accessing external data, including massive amounts of data stored in the cloud, in spreadsheet cells: accessing external data direct via a formulaic variable in a spreadsheet, specifying an ordered progression for the accessed external data, selectively propagating data accessed using the formulaic variable vertically or horizontally, within a propagation pattern responsive to normal A$1, $A1 and $A$1 spreadsheet conventions. Two or more external data fields, responsive to the formulaic variable, have an ordered sequence relationship that nests ordering of vectors of the propagated data; and the ordering according to the ordered sequence relationship is maintained during replication by copy and paste. In another disclosed method, the external data is generated using an implicit join of data from at least two external data sources to generate multiple adjoining vectors of spreadsheet cells of data responsive to selection parameters in the formulaic variable.

Disclosed herein are methods, systems, and apparatus for the detection of data integrity anomalies indicative of malware for a datastore of an organization. To identify an anomaly in a file, a portion of a file is identified to be used in a vector comparison. The portion can comprise sentences or paragraphs for text files, entries, rows, or columns for spreadsheet files, or some other divisible portion of a file. A vector having multiple dimensions is generated for the portion based on the content in the portion. Each dimension of the multiple dimensions corresponds to a feature of the portion. A variation is determined between the vector and one other vector associated with one other portion of the file. One or more actions to take with respect to the file is determined based on the variation, such as malware mitigation, and the action is performed with respect to the file.

The present teachings include techniques and systems for processing spreadsheets at the level of a worksheet or another collection of cells, including the fragmenting of spreadsheets. For example, a spreadsheet may include one or more input worksheets, output worksheets, and / or transient worksheets, where transient worksheets utilize input data in input worksheets to facilitate creation of output data in output worksheets. In particular, fragmenting a spreadsheet may include determining, for each output worksheet, what input and transient worksheets are needed to create output data in the output worksheet, and then creating a plurality of fragments therefrom. Thus, fragmenting a spreadsheet may include a temporal and / or physical decoupling of the spreadsheet’s worksheets. This can be useful for, inter alia, understanding the relationships between a plurality of worksheets, isolating certain processing tasks, editing or interchanging worksheets, and / or for improving computational performance, e.g., by routing particular fragments to appropriate computational resources for processing thereof.

According to an embodiment, the present invention provides a method for converting spreadsheet files into structured workbooks. The method includes receiving a spreadsheet file and identifying tables within it. Metadata associated with the tables is extracted and matched using fuzzy matching to identify standard objects and reports. The method further includes extracting formulas, selecting templates based on identified objects and reports, and creating a dependency graph. A topological sort is performed on the dependency graph to resolve dependencies. A workbook is generated, including sheets based on the processed tables and dependency graphs, and stored in non-volatile memory. A detailed report is also generated, documenting the conversion process. There are other embodiments as well.

The present invention relates to the technical field of front-end page design, and specifically relates to a method for updating front-end fields, including: Step S1: Add fields to be updated in a spreadsheet; Step S2: Use the spreadsheet to update the back-end database; Step S3: Update the front-end page according to the updated back-end database. The beneficial effect of the present invention is that by introducing a spreadsheet, users can quickly import fields to be updated and operate on the data table structure through the spreadsheet. Subsequently, the back-end database performs field update operations according to the spreadsheet and synchronizes them to the front-end page. As a result, users do not have to modify the back-end database and the front-end page in the form of code, and only need to import fields to achieve the above process, reducing the development workload.