7 results about "Spreadsheet software" patented technology

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.

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.

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.