15 results about "Spreadsheet software" patented technology

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.

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 invention relates to the technical field of quality inspection, in particular to a CAD quality batch inspection method, which can utilize table tool software to call an inspection module to execute standard inspection, secondary development inspection and visual feature quantity statistics on CAD files, count the total error number and the total warning number according to the results, and calculate and output scores of the CAD files; sorting the CAD files according to the error number; and according to the inspection result, generating a structured report. It can be understood that according to the technical scheme, when mass CAD file quality inspection is carried out, the wanted quality inspection result can be obtained only by operating table tool software, and operation is convenient and fast; meanwhile, self-defined secondary development inspection items can be constructed on the basis of standard inspection items, and customized design specifications of different enterprises are adapted; the checking module is called for batch checking, and the output checking result is accurate; the efficiency of CAD quality batch inspection is improved, and the accuracy of parallel engineering is improved.

The application relates to the technical field of data calculation, and provides an index calculation method and device, which comprises the following steps: storing a plurality of target index groups generated by an electronic spreadsheet software and corresponding configurable files; wherein the configurable files represent the calculation rules of the values of the plurality of original indexes for determining the values of the business indexes in the corresponding target index groups; determining an index calculation request; wherein the index calculation request carries a target index group or the identification of the target index group; determining the values of the plurality of original indexes matched by the target index group; calling a database engine to calculate the values of the plurality of original indexes matched by the target index group based on the calculation rules indicated by the configurable file matched by the target index group, so as to determine the values of the business indexes in the target index group. The configurable file of the target index group is maintained by using the electronic spreadsheet software, the dimension difficulty is reduced, the calculation process of the business indexes is converted into the execution process of the database engine, and the extension is facilitated.

To enable efficient data entry using a familiar spreadsheet software interface, and to facilitate understanding of a company's emissions and consideration of reduction measures by visualizing greenhouse gas emissions. [Solution] Server 1 comprises an input template provision unit 51, a data acquisition unit 52, and a GHG emission calculation unit 53. The input template provision unit 51 provides the user terminal with an input template in spreadsheet software format for inputting energy consumption data. The data acquisition unit 52 acquires data, including energy consumption data, entered into the input template by the user. The GHG emission calculation unit 53 calculates greenhouse gas emissions based on the data, including energy consumption data. The visualization unit 54 visualizes the calculated greenhouse gas emissions.

The invention belongs to the technical field of coal mine exploration, and particularly relates to a quantitative evaluation method for coal seam thickness stability and regularity. According to the method, the coal thickness change rate of the adjacent coal thickness points is calculated in the fixed sequence direction, a coal thickness stability index and coal thickness regularity index calculation method is provided, the dispersion degree of coal thickness parameters can be reflected, the spatial distribution characteristics and the overall change rule of the coal thickness point values are described, and the calculation accuracy is improved. Meanwhile, the influence of inconsistency of data space distribution and statistical reference is eliminated through weighting processing, and the problem that calculation results are incomparable due to different coal thickness point distances and average coal thickness differences is solved; spreadsheet software is used for batch calculation, implementation is easy, and daily work application is facilitated.

To provide a system for obtaining a desired printing result through simple processing.SOLUTION: An information processing system includes: an object arrangement unit which arranges correction objects which can identify a positional relation between print data for printing and a circumference, in at least two positions in a range of the print data, the print data being formed with an aspect ratio of a predetermined sheet size using spreadsheet software which displays a plurality of cells arranged in matrix; and a correction unit which performs correction by enlarging a printing display area so as to eliminate a margin area based on the correction objects included in the printing display area, regarding conversion data having a file format indicating a printed state on paper, in the predetermined sheet size, including the printing display area in which the print data is displayed and the margin area surrounding the printing display area, the conversion data being obtained by converting the print data.SELECTED DRAWING: Figure 1

A system is provided.SOLUTION: A system comprising: means for receiving a natural-language instruction from a user; analysis means including a generation AI for analyzing the natural-language instruction; means for generating an operation script for automatically reflecting a mathematical expression or a setting in spreadsheet software based on a result analyzed by the analysis means; and means for applying the operation script to the spreadsheet software.SELECTED DRAWING: Figure 1

This program provides the ability to identify the worksheet name, header row, target column, etc., when extracting input data within a specified range from a group of worksheets entered in a non-standard format. [Solution] The program includes: a worksheet group acquisition step of acquiring a group of worksheets including multiple worksheets in a spreadsheet software; a worksheet identification step of identifying a predetermined worksheet from the group of worksheets acquired in the worksheet group acquisition step; a first prompt creation step of creating a first prompt by including at least a part of the predetermined worksheet identified in the worksheet identification step in an instruction to identify a header row from the data entered in the worksheet; and a header row identification step of identifying a predetermined header row of a predetermined worksheet based on first output information output in response to inputting the first prompt created in the first prompt creation step into a large-scale language model.

This invention provides a method and system for deriving a power grid simulation calculation database. It acquires the original power grid simulation PSD-BPA calculation database file, accurately locates target areas and interconnection channel data, and uses Python to automatically parse the PSD-BPA database model and identify equipment parameters. Spreadsheet software is used to classify and organize data, optimize and merge nodes, and verify parameters. Based on planning requirements, the data model is dynamically adjusted using a dual-mode approach (multiple files or single file), and regional loads are scientifically allocated using capacity proportion or incremental allocation methods. Typical operating mode values ​​are calculated by setting zoning coefficients. The invention innovatively integrates power balance prediction and reactive power hierarchical zoning optimization, and iterative calculations are used to ensure database convergence and voltage qualification rate, ultimately automatically generating a high-precision derived database for multiple scenarios. This method achieves fully automated processing, significantly improving data quality and simulation efficiency, and providing strong support for power grid planning decisions.

The invention discloses an agent-based table processing method, device and equipment and a storage medium, and relates to the technical field of large language models and data process.The method comprises the steps that when a table processing problem corresponding to a to-be-processed table is received, a target Schema definition corresponding to the table processing problem is determined, the target Schema definition comprises a table building statement corresponding to the table to be processed; generating a first cue word template based on the table processing problem and the target Schema definition; and according to the cue word template, processing the table to be processed through the first intelligent agent to obtain a table processing result corresponding to the table processing problem. According to the technical scheme, the problem that data analysis and processing of traditional spreadsheet software are high in learning cost is solved, and the problems that an existing automatic tool is low in flexibility and cannot accurately understand the natural language requirement of a user are solved. Common table operation and data analysis tasks can be completed through natural language dialogues, the technical threshold is remarkably reduced, and the user experience is improved.

To provide a system for obtaining a desired printing result through simple processing.SOLUTION: A printing output adjustment system includes: an object arrangement unit which arranges correction objects which can identify a positional relation between print data for printing and a circumference, in at least two positions in a range of the print data, the print data being formed with an aspect ratio of a predetermined sheet size using spreadsheet software which displays a plurality of cells arranged in matrix; and a correction unit which performs correction by enlarging a printing display area so as to eliminate a margin area based on the correction objects included in the printing display area, regarding conversion data having a file format indicating a printed state on paper, in the predetermined sheet size, including the printing display area in which the print data is displayed and the margin area surrounding the printing display area, the conversion data being obtained by converting the print data.SELECTED DRAWING: Figure 1

The invention discloses a self-adaptive parenteral nutrient solution preparation and calculation system and a self-adaptive parenteral nutrient solution preparation and calculation method. The system is constructed in spreadsheet software, the core of the system lies in a medicine database containing a selected parameter table and an optional parameter table, dynamic maintenance and updating of a medicine list and parameters are achieved through data links (such as a VLOOKUP function), and a core formula does not need to be modified. The system further comprises a logic judgment module which configures infusion modes (all-in-one / two-in-one) through option combinations (such as calcium grouping and definite grouping). The calculation module calculates the medicine dosage according to the nutritional requirements input by the user, the called medicine parameters and the infusion mode, and the unit output module synchronously outputs the results of multiple units. The problems that a traditional calculator is poor in universality and difficult to maintain are solved, long-term use after one-time configuration is achieved, and the efficiency and accuracy of clinical parenteral nutrition prescriptions are remarkably improved.

The invention belongs to the technical field of table data management, and particularly provides an office table conversion and cleaning method and device, which liberates users of insurance companies from tedious operations by automatically executing repetitive and modeled table conversion and cleaning tasks, greatly shortens data processing time, avoids errors caused by human negligence, and improves work efficiency. The method guarantees the data quality, and is suitable for the digital operation of the office table during the transaction and maintenance of the insurance business. The target task script is called from the task script library according to the operation mode of the user in the spreadsheet software, the corresponding conversion cleaning operation is automatically executed, the user can complete batch and flow operation through the script automatically generated by the system without mastering programming knowledge, and the operation is simple and convenient. Through a real-time monitoring and feedback mechanism, timely intervention can be performed when task execution is abnormal or data goes wrong, error diffusion is prevented, and the reliability of an automatic process and the controllability of a final result are guaranteed.

In one aspect, a universal spreadsheet adapter system comprising: wherein the universal spreadsheet adapter system comprises a software architecture and a build system design for a development and integration of a plurality of third-party spreadsheet software applications; one or more spreadsheet adapter source codes of the plurality of third-party spreadsheet software applications, wherein the one or more spreadsheet adapter source codes are configured to implement one more functionalities from one or more functions exposed by a third-party spreadsheet; a spreadsheet interface configured to obtain each spreadsheet adapter source code whenever an interaction with a third-party spreadsheet is performed; a builder system configured to: obtain each spreadsheet adapter source code and generate provide a compiled production-ready build of each spread application, ands obtain a parameterized request.