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

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.

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

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 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 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 invention discloses a data line processing method and device for a spreadsheet based on a dynamic step size, and the method comprises the steps: obtaining a target data line selected by a user, an insertion position, and the total line number of inserted data lines in response to a data line insertion instruction of an original spreadsheet displayed by an MES system by the user; wherein the sequence numbers between adjacent data rows in the original spreadsheet are discontinuous and have equal differences, and have dynamically adjusted step lengths; determining a reference interval according to the target data row and the insertion position; determining row intervals among the inserted data rows according to the reference interval; calculating a target sorting number of each inserted data line according to a progressive increase mode through the line interval and the total line number; and storing a mapping relationship between the target sorting number of each inserted data row and the row data of each inserted data row. Therefore, by adopting the embodiment of the invention, when the data in the online spreadsheet in the MES system is updated, the normal response speed and performance of the MES system can be kept.

The present disclosure provides a method, device and equipment for intelligent integration of Feishu spreadsheet and system data table, the method comprising: in response to a trigger for reading the spreadsheet, loading pre-configured reading task parameters, the reading task parameters comprising a Feishu access token, a sheet name of the spreadsheet and a parameter configuration table preset for the reading task, the parameter configuration table being used to record a first mapping relationship between column headers of the spreadsheet and fields of the system data table; based on the Feishu access token and the sheet name of the spreadsheet, obtaining spreadsheet data and extracting column header fields from the spreadsheet data; through at least one of annotation matching, synonym matching and parameter configuration table matching, constructing a second mapping relationship between the column header fields and the fields of the system data table; and based on the second mapping relationship, writing the spreadsheet data into the system data table. Through the method of the present disclosure, automatic integration between the spreadsheet and the system data table can be achieved.

The invention discloses a large-model-based spreadsheet dialogue method and system, and the method comprises the steps: receiving a spreadsheet file uploaded by a user, carrying out the structural processing of a spreadsheet through an analysis tool, obtaining a standardized Dataframe object, and extracting summary information from the Dataframe object; in response to the received natural language question of the user for the spreadsheet, inputting the summary information and the user question as context into the large model, and generating an executable code for processing the question by the large model; extracting and executing an executable code, if code execution fails, triggering the loop calling of the large model to generate a modified new code, and executing again until a successful execution result is obtained or a preset iteration frequency is reached; and inputting the execution result and the user question into the large model as a context, and generating a user-oriented final natural language reply by the large model. According to the method, the coping capacity of the model to a complex data processing task is remarkably improved.

The invention provides a multi-subtable spreadsheet automatic analysis method based on multi-agent workflow, and relates to the technical field of table analysis. The multi-agent workflow-based multi-sub-table spreadsheet automatic analysis method comprises the following steps of: creating an analysis task corresponding to an original report by using an entry agent, identifying sub-tables in the original report by using a document analysis agent, organizing structured sub-table data according to a business view angle to form different view angle data, and storing the different view angle data in a database; and performing cleaning, aggregation and index calculation on each piece of business view data to generate a structured analysis result, generating analysis icons by using a tabulation agent and a drawing agent, and aggregating obtained analysis texts and icons to generate a complete analysis report file. According to the method, the automation degree and the consistency of complex spreadsheet analysis, index calculation and report generation can be improved, and the traceability and the recheckability of results are improved.

A method of implementing a spreadsheet includes, by a processor of a computing device, executing programming instructions that cause the computing device to output a prompt that comprises a plurality of candidate programming languages. When the system receives, in response to the prompt, a user selection of one of the candidate programming languages, it will display a user interface comprising a first interface area that displays one or more sheets of a spreadsheet. Each of the sheets comprises a plurality of cells, at least some of which comprise code in the spreadsheet formula language that references functions or data in the selected programming language.

The application discloses a diffusion connection device for a rare earth barium copper oxygen coating conductor and relates to the technical field of superconducting electrical engineering. The device comprises a bottom plate, electrodes, a base, a heating assembly, a cover plate, a pressing block and a thermocouple. The base is installed on the bottom plate, and the base is provided with a groove for installing the heating assembly. The heating assembly comprises two heating units symmetrically arranged in an up-down direction. The heating unit comprises a heat insulation bottom plate, a heating sheet and a heat insulation cover plate which are sequentially stacked. The heat insulation cover plate is embedded with a heat spreading sheet. The electrodes are connected with the two heating sheets for heating the heating sheets. The two heating units are used for placing the rare earth barium copper oxygen coating conductor. The thermocouple is in contact with the two heat spreading sheets. The cover plate is provided with a protrusion at the bottom end, which is matched with the groove. The lower surface of the protrusion is provided with a heating groove. The cover plate is provided with a through hole matched with the pressing block. The application can realize a rapid and accurate temperature control process, the temperature field of the heating area is uniform, the negative influence of the high-temperature process on the superconducting performance of the coating conductor is relieved, and the joint resistance is reduced.