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

The invention discloses a multi-dimensional data management method and system based on a spreadsheet, and the method comprises the steps: responding to an editing operation instruction of the spreadsheet displayed by a client, and updating the table structure and table data of the spreadsheet; the editing operation instruction at least comprises one of a dragging instruction for dragging rows and columns of the spreadsheet to carry out free combination, a hiding and screening instruction for hiding and screening the rows and the columns and a sorting instruction for sorting data of the rows and the columns; capturing a timestamp corresponding to the editing operation instruction, taking the timestamp as an index, taking the updated table structure and table data as historical data modification records, and storing a mapping relation between the index and the historical data modification records; and tracing the historical data modification record through the mapping relationship. Therefore, by adopting the embodiment of the invention, multi-dimensional operation can meet the requirements of enterprises on refinement and individuation of inventory management, meanwhile, operators and modification history can be tracked, and the security and reliability of data are improved.

The present disclosure relates to adding machine understanding to spreadsheet data. A method for generating chart recommendations based on machine understanding of spreadsheet data includes determining a data set, each piece of data including the content of a cell in one or more cells of a column of a spreadsheet presented to a user. The method also determines an entity type associated with the column based on the data set. The entity type represents the semantic meaning of the data set in the column of the spreadsheet. The method also identifies at least one icon in a plurality of charts that is related to the entity type associated with the column. The method then provides the identified chart for presentation to the user.

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 embodiment of the invention discloses a data processing method and device based on a generative large language model. The method comprises the steps that a spreadsheet area and an assistant bar area are displayed on a target display interface; acquiring a spreadsheet operation description input by a user from the assistant bar area, and calling the target generative large language model to perform operation analysis processing on the spreadsheet operation description to obtain target table operation information; and determining a target editing script based on the target table operation information, and calling the target editing script to perform target table operation processing on the spreadsheet region. The steps of executing operation processing on the spreadsheet area by the user are simplified, the spreadsheet operation description is obtained through the assistant column area so as to identify the operation expected by the user, the operation is autonomously executed on the spreadsheet area, additional intervention of the user is not needed, continuous iteration updating of a spreadsheet software version is solved, and the user experience is improved. And the learning cost of the user is high.

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.

To enable a sheet to be safely, easily, quickly, and reliably spread over a vehicle cargo bed.SOLUTION: A device A includes a pair of support posts 1 erected on both rear sides of a work area and used as a mounting base B. From a position on the mounting base B that is reachable by a worker in the work area P, a sheet guide 2 extends obliquely via a curved section 20 toward the work area to a position above the far end of a vehicle cargo bed in the work area. A sheet hanger 3 to transfer a sheet is movably arranged on the sheet guide 2 and is driven by a sheet hanger drive device 4.SELECTED DRAWING: Figure 1

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 application discloses a method, device, equipment and storage medium for preventing spreadsheet formula calculation from being stuck, and relates to the field of computer technology. Specifically, it includes: determining a formula to be calculated according to a spreadsheet; determining the number of formula references of the formula to be calculated according to the formula to be calculated; determining a first formula according to the number of formula references, calculating the first formula, obtaining and storing the calculation result, and updating the first formula and the second formula; determining to respond to user operations according to a first preset rule, and executing a first preset action according to the user's operation type; determining that there is a circular reference formula and the preset number of iterations has not been reached, iteratively calculating the circular reference formula, determining to respond to user operations according to a second preset rule, and executing a second preset action according to the user's operation type. The present disclosure can realize responding to user operations during the calculation process of a spreadsheet, improving user experience, and avoiding invalid calculations and improving calculation efficiency after the spreadsheet is re-edited.

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.

To improve efficiency and accuracy of bill processing by a system including photographing of a bill, confirmation of information, automatic reflection, and transmission of an original.SOLUTION: A system includes: means for photographing a bill and confirming whether or not necessary information is prepared; means for automatically reflecting it on a spread sheet; and means for sending only an original to a person in charge.SELECTED DRAWING: Figure 1

The utility model discloses a broadband omnidirectional ceiling antenna, and belongs to the field of antennas. The broadband omnidirectional ceiling antenna provided by the utility model comprises a reflection bottom plate, an oscillator assembly and a feed assembly, the oscillator assembly is installed above the reflection bottom plate, the oscillator assembly comprises a cup-shaped oscillator and a spectrum spreading sheet, the cup-shaped oscillator encloses an accommodating space with a top opening, and the spectrum spreading sheet is connected with the cup-shaped oscillator and is arranged at the opening position of the accommodating space; the feed assembly comprises a connecting seat, an insulating pad and a coaxial cable, the connecting seat is fixed with the reflection bottom plate, the connecting seat is of a hollow structure, the coaxial cable penetrates through a hollow area of the connecting seat to be connected with the cup-shaped vibrator, and the insulating pad is arranged on the periphery of the coaxial cable in a sleeving mode and clamped between the cup-shaped vibrator and the connecting seat. According to the utility model, the oscillator is designed to be of a cup-shaped structure with an opening at the top, and the spread spectrum sheet is arranged at the opening at the top of the oscillator to carry out spread spectrum processing on signals, so that the oscillator can cover frequency bands of 698-806 MHz and 3700-4200 MHz, and spread spectrum capacity expansion of indoor distributed communication network coverage is realized.

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.

The invention relates to the technical field of information big data, in particular to a method and device for processing multi-version spreadsheet import. The method for processing multi-version spreadsheet import comprises the steps that a sheet sample of a to-be-processed spreadsheet is analyzed into a report outer layer data structure and a report inner layer data structure so as to correspond to network version report parameters; based on the report outer layer data structure of the to-be-processed spreadsheet, calculating a first similarity score between the report name of the to-be-processed spreadsheet and each network edition report name, and selecting all network edition reports corresponding to the first similarity scores greater than a first set threshold value; according to the report outer layer data structure, matching the to-be-processed spreadsheet with all the screened network edition reports, and selecting the successfully matched network edition reports as candidate matching tables; and performing report inner-layer data structure similarity matching to obtain a final corresponding table. The multi-period data continuity is ensured, and the manual intervention workload is reduced.

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.