CN109492276B - Method for calculating air conditioner pipeline machining process based on VBA module in Excel - Google Patents

Method for calculating air conditioner pipeline machining process based on VBA module in Excel Download PDF

Info

Publication number
CN109492276B
CN109492276B CN201811245949.2A CN201811245949A CN109492276B CN 109492276 B CN109492276 B CN 109492276B CN 201811245949 A CN201811245949 A CN 201811245949A CN 109492276 B CN109492276 B CN 109492276B
Authority
CN
China
Prior art keywords
module
excel
calculation
data
interface
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201811245949.2A
Other languages
Chinese (zh)
Other versions
CN109492276A (en
Inventor
路聕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shaanxi Tide Auto Air Cond Co ltd
Original Assignee
Shaanxi Tide Auto Air Cond Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shaanxi Tide Auto Air Cond Co ltd filed Critical Shaanxi Tide Auto Air Cond Co ltd
Priority to CN201811245949.2A priority Critical patent/CN109492276B/en
Publication of CN109492276A publication Critical patent/CN109492276A/en
Application granted granted Critical
Publication of CN109492276B publication Critical patent/CN109492276B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F30/00—Computer-aided design [CAD]
    • G06F30/10—Geometric CAD
    • G06F30/17—Mechanical parametric or variational design
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F2113/00—Details relating to the application field
    • G06F2113/14—Pipes

Landscapes

  • Physics & Mathematics (AREA)
  • Geometry (AREA)
  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Pure & Applied Mathematics (AREA)
  • Mathematical Optimization (AREA)
  • Mathematical Analysis (AREA)
  • Computer Hardware Design (AREA)
  • Evolutionary Computation (AREA)
  • General Engineering & Computer Science (AREA)
  • Computational Mathematics (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for calculating an air conditioner pipeline machining process based on a VBA module in Excel, which comprises the following steps of: developing a VBA module; defining a CATIA data processing module, a data format conversion module and a calculation module in an Excel worksheet; designing a software interface and each functional area in Excel, and setting an operation control; and (3) importing coordinate point data in a CATIA format into a window body of an Excel worksheet, calculating results of all process parameters through a formula set by a calculation module and a formula carried by the Excel, displaying a calculation result in a text box of a UserForm interface, and exporting a CSV file. The method disclosed by the invention solves the problems that the existing calculation method is complicated in process and needs a large amount of manual repetitive work, so that the working efficiency is low.

Description

Method for calculating air conditioner pipeline machining process based on VBA module in Excel
Technical Field
The invention belongs to the technical field of mechanical engineering, and relates to a method for calculating an air conditioner pipeline machining process based on a VBA module in Excel.
Background
The automobile air conditioner pipeline is of a three-dimensional structure and comprises a bent hollow aluminum pipe, a pipe end sealing structure (pier head, bulge, expansion opening and contraction opening), a sealing groove (in compression joint with an air conditioner rubber pipe), a pressure switch, a refrigerant filling valve, a fixed support (welded or hinged with the aluminum pipe) and other structures, the pipeline trend changes according to the arrangement of a whole automobile engine, an intercooler, a radiator, a cab and other systems, and the parameters of the aluminum pipe: space point, pipe diameter, wall thickness, bend radius, pipe end sealing mode (pier head, bulge, mouth expanding, necking and other structures processed by utilizing the plastic forming principle), rubber pipe parameters: length, specification, applicable aluminum tube specification. At present, coordinate points derived by CATIA are manually pasted into an Excel table by a common pipeline processing coordinate point by hand, a preset formula is used for calculation, and then a CSV file is manually derived; the calculation of the technological parameters is manual calculation, the length of the raw materials required by processing and the length parameters required by processing the aluminum pipes are calculated by a calculator by inquiring various technological parameters, the calculation method has complicated process, a large amount of repeated work exists, the use is very inconvenient, and the work efficiency is reduced.
Disclosure of Invention
The invention aims to provide a method for calculating an air conditioner pipeline machining process based on a VBA module in Excel, and solves the problems that the existing calculating method is complex in process and low in working efficiency due to the fact that a large amount of repeated work is needed manually.
The technical scheme adopted by the invention is that the method for calculating the air conditioner pipeline machining process based on the VBA module in Excel comprises the following specific calculation processes:
(1) Developing a VBA module: establishing a UserForm interface, a ThisWorkbook module and a worksheet module which are called with data in Microsoft Excel in a Visual Basic editor of the Excel, wherein the ThisWorkbook module is used for loading the UserForm interface when an Excel macro file is started, the worksheet module is used for switching a worksheet in the Excel, the UserForm interface is set into multiple pages and used for dividing the UserForm interface into a technological parameter calculation page and a technological parameter query page, and the technological parameter calculation page is provided with a command button, a text frame and a list frame;
(2) The method comprises the steps that a CATIA data processing module, a data format conversion module and a calculation module are defined in an Excel worksheet, the CATIA data processing module is used for storing coordinate point data output by CATIA software in the Excel worksheet, the calculation module is provided with calculation formulas of space point intervals, space straight line angles, arc lengths and pipeline center line lengths, and the data conversion module is used for converting results calculated by the data calculation module into files in an output CSV format;
(3) Designing a software interface and each functional area in Excel, and setting operation controls, including each functional area and a trigger call control of the UserForm interface, a storage area for the CATIA data processing module to import coordinate point data, a calculation area for the calculation module, and a data storage area for outputting a CSV format of a calculation result;
(4) The method comprises the steps that coordinate point data in a CATIA format are imported into a window body of an Excel worksheet or a UserForm interface of a VBA module, a user inputs process parameters on the UserForm interface, a calculation module of the Excel worksheet calculates results of the process parameters according to the input process parameters through a formula set by the calculation module and a formula carried by the Excel, the calculation results are displayed in a text box of the UserForm interface, and a CSV file is exported through a command button of the UserForm interface.
Yet another feature of the present invention is that,
the ThisWorkbook module is used for judging the number of the workbooks opened in the Excel when the Excel macro file is closed, if the number of the workbooks is 1, directly quitting without prompting storage, and otherwise, only closing the current workbook.
The worksheet module realizes hiding a page switching toolbar through specific codes, freezing a worksheet switching shortcut key to prohibit a user from switching worksheets at will, and encrypting the VBA module, so that the user is prevented from modifying programs and worksheet structures at will through a visual basic editor.
The command buttons arranged on the technical parameter calculation page of the UserForm interface comprise trigger buttons for selecting files, clearing, calculating, exporting data and exiting; the UserForm interface is respectively provided with four text boxes for inputting process parameters and displaying calculation results, and the first text box is used for displaying coordinate data, straight line segment length and space point included angle; the second text box is used for inputting the specification of the die, the length of the aluminum pipe, the specification of the pier head and the buckling parameters; the third text box is used for displaying the length and specification of the rubber tube; extracting process parameters required by the engineering drawing by the fourth text box, so that a user can conveniently and manually copy the process parameters to a worksheet; the list box arranged in the UserForm interface is used for storing coordinate data, and the coordinate data can be automatically acquired from a worksheet of Excel.
After inputting the process parameters into a second text box on the UserForm interface, calling a calculation module of Excel through a calculation button, displaying the result in a calculation area of the calculation module arranged in the Excel, and then outputting a data storage area in a CSV format of the calculation result, selecting an uppercase or lowercase option, and then exporting the CSV file through an export data button.
The clear button is used for quickly clearing the selected data and the process parameters and starting new calculation; the exit button is used to close the computing interface and by default does not save the worksheet.
And calling the photos stored in the Excel by the process parameter query page, and displaying different query results according to the parameters selected by the user.
The Excel is internally provided with a data extraction module which is used for automatically copying the calculation result of the data calculation module to a clipboard of the system, and the data of the data extraction module can be called and pasted to a text box on a UserForm interface through a data-to-data button on the UserForm interface so as to display the calculation result.
The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel has the advantages that the problems that the existing calculating method is complex in process and low in working efficiency due to the fact that a large amount of repeated work is needed manually are solved. The method has the advantages that the calculation process of the pipeline processing technology can be simplified, coordinate point data are automatically read from the CSV file by the control, the data reading, parameter selection, calculation and result output processes can be completed by one operation interface, the operation is simple and convenient, the calculation efficiency and accuracy are greatly improved, a large amount of time is saved for a user, human errors can be avoided to the maximum extent, and files in different formats can be output according to needs.
Drawings
FIG. 1 is a computational flow diagram of the present invention for processing CATIA coordinate point data by calling a worksheet;
FIG. 2 is a schematic diagram of the structure of the VBA module in Excel according to the present invention;
FIG. 3 is a schematic diagram of a UserForm interface in a VBA module of the invention.
Detailed Description
The present invention will be described in detail below with reference to the accompanying drawings and specific embodiments.
The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel comprises the following specific calculation processes as shown in figures 1 and 2:
(1) Developing a VBA module: establishing a UserForm interface, a ThisWorkbook module and a worksheet module which are called with data in Microsoft Excel in a Visual Basic editor of the Excel, wherein the ThisWorkbook module is used for loading the UserForm interface when an Excel macro file is started, the worksheet module is used for switching a worksheet in the Excel, the UserForm interface is set into multiple pages and used for dividing the UserForm interface into a technological parameter calculation page and a technological parameter query page, and the technological parameter calculation page is provided with a command button, a text frame and a list frame;
(2) The method comprises the steps that a CATIA data processing module, a data format conversion module and a calculation module are defined in an Excel worksheet, the CATIA data processing module is used for storing coordinate point data output by CATIA software in the Excel worksheet, the calculation module is provided with calculation formulas of space point intervals, space straight line angles, arc lengths and pipeline center line lengths, and the data conversion module is used for converting results calculated by the data calculation module into files in an output CSV format;
(3) Designing a software interface and each functional area in Excel, and setting operation controls, wherein the operation controls comprise each functional area and a trigger calling control for a UserForm interface, a storage area for a CATIA data processing module to import coordinate point data, a calculation area for a calculation module, and a data storage area for outputting a CSV format of a calculation result;
(4) The method comprises the steps that coordinate point data in a CATIA format are imported into a window body of an Excel worksheet or through a UserForm interface of a VBA module, a user inputs process parameters on the UserForm interface, a calculation module of the Excel worksheet calculates results of the process parameters through a formula set by the calculation module and a formula carried by the Excel according to the input process parameters, the calculation results are displayed in a text box of the UserForm interface, and a CSV file is exported through a command button of the UserForm interface.
The ThisWorkbook module is used for judging the number of the workbooks opened in the Excel when the Excel macro file is closed, if the number of the workbooks is 1, directly quitting without prompting to save, and otherwise, only closing the current workbook.
The worksheet module can hide the page switching toolbar through specific codes, freeze the worksheet switching shortcut key to prohibit a user from switching worksheets at will, encrypt the VBA module, and prevent the user from modifying programs and worksheet structures at will through the visual basic editor.
As shown in fig. 3, the command buttons set on the process parameter calculation page of the UserForm interface include trigger buttons for selecting a file, clearing, calculating, exporting data, and exiting; the UserForm interface is respectively provided with four text boxes for inputting process parameters and displaying calculation results, and the first text box is used for displaying coordinate data, straight line segment length and space point included angle; the second text box is used for inputting the specification of the die, the length of the aluminum pipe, the specification of the pier head and the buckling parameters; the third text box is used for displaying the length and specification of the rubber tube; extracting process parameters required by the engineering drawing by the fourth text box, so that a user can manually copy the process parameters to a worksheet conveniently; a list box arranged in the UserForm interface is used for storing coordinate data, and the coordinate data can be automatically obtained from a worksheet of Excel.
After the process parameters are input into a second text box on the UserForm interface, a calculation module of Excel is called through a calculation button, a result is displayed in a calculation area of the calculation module arranged in the Excel, and then a data storage area in a CSV format of the output calculation result is selected, and the CSV file is exported through an export data button.
Wherein, the clear button is used for rapidly clearing the selected data and the process parameters for starting new calculation; the exit button is used to close the UserForm interface and by default does not save the worksheet and does not pop up a warning dialog.
The process parameter query page calls photos stored in the Excel, and displays different query results according to parameters selected by a user.
And a data extraction module is arranged in the Excel and is used for automatically copying the calculation result of the data calculation module to a clipboard of the system, and data of the data extraction module can be called to be pasted to a text box on the UserForm interface through a data-to-data button on the UserForm interface so as to display the calculation result.
The specific operation example of the method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel is as follows:
defining a data processing area in an Excel worksheet, wherein the data processing area comprises modules for reading external data, calculating coordinates, converting formats and the like: coordinate point data output by a user from CATIA software is stored in an Excel document, the suffix name of a file is ". CSV", the coordinate data is read into a program from the Excel, the user selects process parameters, then calculation is carried out, the final result is displayed on a Userform interface, and a CSV file can also be output and is used for importing the data into CATIA software to make an engineering drawing.
(1) The CATIA coordinate point data import area is defined to be located in the sheet1, a user needs to paste coordinate point data exported by the CATIA into the sheet1, a file can be selected through a file selection button on a user form interface, and the coordinate point data import area is automatically imported into the sheet1 (B: B) area through software.
(2) Defining a data calculation area as sheet2 in an Excel worksheet, wherein data operation mainly applies Excel self-carried functions and set formulas, and assignment is performed on a user form interface, and the applied typical formulas and codes are as follows:
and (3) data screening and querying: = INDEX (AG: AG, MATCH (C4, R: R, 0)) + C10;
and (3) selective input of data: = ROUND (INDIRECT ("B" & ROW (B4) × 3-2), 1);
space point spacing:
＝IF(AND(E3＝E4,F3＝F4,G3＝G4),,SQRT(((E3-E2)^2)+((F3-F2)^2)+((G3-G2)^2)))；
the included angle of the space straight line is as follows:
＝IF(AND(E4＝E5,F4＝F5,G4＝G5),,ABS(180-((180*(ACOS(((E3-E2)*(E4-E3)+(F3-F2)*(F4-F3)+(G3-G2)*(G4-G3))/((SQRT((E2-E3)^2+(F2-F3)^2+(G2-G3)^2))*(SQRT((E4-E3)^2+(F4-F3)^2+(G4-G3)^2))))))/3.1415926)))
calculating the length of the arc:
＝IF(AND(E4＝E5,F4＝F5,G4＝G5),,((180-K3)*3.1415926*C$2/180))
and (4) cell assignment: sheets ("a") [ C4] = me
When actual debugging is carried out, a chat software is found to conflict with the components, so that the calculation cannot be normally operated, and a conflict program is ended by using a specific code.
(3) Outputting a CSV file to be defined as a worksheet sheet3, and finally outputting the file by a user through an export button; and (3) outputting the CSV file: only by selecting the type of the exported file, the program automatically exports the data in the designated area to an exchangeable file format CSV (CSV format data is used for pouring the data into a CATIA engineering drawing), and automatically stores the data in a directory where the macro file is located, and the file name consists of capital English letters of coordinate points and random numbers, so that the repetition is avoided; after the file is created, the folder where the file is located is automatically opened, and a prompt that the file is stored successfully is given.
According to the method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel, the VBA module is arranged in the Excel, an Excel macro file is opened through a VB program, a window is not displayed when the VB program runs, a server is automatically accessed when the program is started and is compared with version information in a program installation directory, and if the version information is inconsistent, the program is prompted to be updated through popup. After the program is compiled, the VB program is used for self-contained packaging function to create an installation exe installation program. After the program is installed, some installation files can be generated in an installation directory selected by a user, the files of the installation directory cannot be deleted, and otherwise, the program cannot run normally.
Compared with the prior art, the invention has the advantages of error reduction, time saving, convenient data maintenance, simplicity and convenience and the like; if the prior art is used, data needs to be manually input into software, process parameters need to be manually set, then a calculation result is obtained, the obtained calculation result cannot be output into a file and can only be manually pasted and copied, the process is complicated, and errors are easy to occur. The invention also has the following beneficial effects:
(1) All files are packed into an exe installation program, so that the installation and the use and the version upgrading are facilitated;
(2) The installation program comprises parameters and formulas stored in the excel workbook, version information, program components and the like;
(3) The process parameter photos stored in the excel worksheet are used for being displayed on a window body, so that the photos can be prevented from being stored in a local directory, and files can be prevented from being deleted by mistake;
(4) The visual interface is created by VBA, the code based on visual basic language is convenient to maintain, and the visual basic language is powerful in function and is the first choice for secondary software development.

Claims (8)

1. The method for calculating the air conditioner pipeline machining process based on the VBA module in Excel is characterized by comprising the following specific calculation steps:
(1) Developing a VBA module: in a Visual Basic editor carried by Excel, establishing a UserForm interface, a ThisWorkbook module and a worksheet module which are called by data in the Microsoft Excel, wherein the ThisWorkbook module is used for loading the UserForm interface when an Excel macro file is started, the worksheet module is used for switching a worksheet in the Excel, the UserForm interface is set into multiple pages and used for dividing the UserForm interface into a technological parameter calculation page and a technological parameter query page, and the technological parameter calculation page is provided with a command button, a text box and a list box;
(2) The method comprises the steps that a CATIA data processing module, a data format conversion module and a calculation module are defined in an Excel worksheet, the CATIA data processing module is used for storing coordinate point data output by CATIA software in the Excel worksheet, the calculation module is provided with calculation formulas of space point intervals, space straight line angles, arc lengths and pipeline center line lengths, and the data format conversion module is used for converting results calculated by the data calculation module into files outputting CSV formats;
(3) Designing a software interface and each functional area in Excel, and setting operation controls, including each functional area and a trigger call control of the UserForm interface, a storage area for the CATIA data processing module to import coordinate point data, a calculation area for the calculation module, and a data storage area for outputting a CSV format of a calculation result;
(4) The method comprises the steps that coordinate point data in a CATIA format are imported into a window body of an Excel worksheet or a UserForm interface of a VBA module, a user inputs process parameters on the UserForm interface, a calculation module of the Excel worksheet calculates results of the process parameters according to the input process parameters through a formula set by the calculation module and a formula carried by the Excel, the calculation results are displayed in a text box of the UserForm interface, and a CSV file is exported through a command button of the UserForm interface.
2. The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel as recited in claim 1, wherein the ThisWorkbook module is used for judging the number of workbooks opened in the Excel when the Excel macro file is closed, if the number of the workbooks is 1, the process of directly exiting is not prompted for storage, otherwise, only the current workbook is closed.
3. The method for calculating the air conditioning pipeline machining process based on the VBA module in Excel according to claim 1, wherein the worksheet module is used for hiding a page switching toolbar through specific codes, freezing a worksheet switching shortcut key to prohibit a user from switching worksheets at will, and encrypting the VBA module to prevent the user from modifying programs and worksheet structures at will through a VisualBasic editor.
4. The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel of claim 1, wherein the command buttons arranged on the process parameter calculation page of the UserForm interface comprise trigger buttons for selecting files, clearing, calculating, exporting data and exiting; the UserForm interface is respectively provided with four text boxes for inputting process parameters and displaying calculation results, and the first text box is used for displaying coordinate data, straight line segment length and space point included angle; the second text box is used for inputting the specification of the die, the length of the aluminum pipe, the specification of the pier head and the buckling parameters; the third text box is used for displaying the length and specification of the rubber tube; extracting process parameters required by the engineering drawing by the fourth text box, so that a user can conveniently and manually copy the process parameters to a worksheet; the list box arranged in the UserForm interface is used for storing coordinate data, and the coordinate data can be automatically acquired from a worksheet of Excel.
5. The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel according to claim 4, wherein after process parameters are input into a second text box on the UserForm interface, the calculation module of the Excel is called through a calculation button, a result is displayed in a calculation area arranged in the Excel and used for the calculation module, then a data storage area in a CSV format for outputting the calculation result is selected, and after an upper case or lower case option is selected, a CSV file is exported through a data export button.
6. The method for calculating the air conditioning pipeline machining process based on the VBA in Excel module according to claim 4, wherein the clear button is used for quickly clearing the selected data and process parameters for starting a new calculation; the exit button is used to close the computing interface and by default does not save the worksheet.
7. The method for calculating the air conditioner pipeline machining process based on the VBA module in the Excel as recited in claim 1, wherein the process parameter query page calls a photo stored in the Excel, and displays different query results according to parameters selected by a user.
8. The method for calculating the air conditioner pipeline processing technology based on the VBA module in the Excel according to claim 1, wherein a data extraction module is arranged in the Excel and is used for automatically copying the calculation result of the data calculation module to a clipboard of a system, and data of the data extraction module can be called to be pasted into a text box on the UserForm interface through a data button from place to place on the UserForm interface so as to display the calculation result.
CN201811245949.2A 2018-10-24 2018-10-24 Method for calculating air conditioner pipeline machining process based on VBA module in Excel Active CN109492276B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811245949.2A CN109492276B (en) 2018-10-24 2018-10-24 Method for calculating air conditioner pipeline machining process based on VBA module in Excel

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811245949.2A CN109492276B (en) 2018-10-24 2018-10-24 Method for calculating air conditioner pipeline machining process based on VBA module in Excel

Publications (2)

Publication Number Publication Date
CN109492276A CN109492276A (en) 2019-03-19
CN109492276B true CN109492276B (en) 2022-11-25

Family

ID=65691820

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811245949.2A Active CN109492276B (en) 2018-10-24 2018-10-24 Method for calculating air conditioner pipeline machining process based on VBA module in Excel

Country Status (1)

Country Link
CN (1) CN109492276B (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110532502B (en) * 2019-08-26 2023-05-30 盐城工学院 Mechanical formula representation system based on Excel and use method of mechanical formula representation system
CN110890159A (en) * 2019-11-23 2020-03-17 潍坊学院 Method for evaluating antibacterial drug combination effect by using Excel function
CN111507077A (en) * 2020-03-17 2020-08-07 唐山钢铁集团高强汽车板有限公司 Method for automatically generating production records of galvanized outlet
CN112819309A (en) * 2021-01-25 2021-05-18 江西五十铃汽车有限公司 Employee performance scoring and payroll calculation system based on EXCEL software
CN113704973B (en) * 2021-08-03 2024-03-15 人本股份有限公司 Bearing life data automatic processing device based on VBA

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6167406A (en) * 1998-05-08 2000-12-26 Allen-Bradley Company, Llc System, method and article of manufacture for building an enterprise-wide data model
CN101366031A (en) * 2005-07-22 2009-02-11 空中客车法国公司 Method and device for simulating bending of a tube
CN108009359A (en) * 2017-12-01 2018-05-08 中国空气动力研究与发展中心高速空气动力研究所 A kind of boundary layer parameters computational methods and system based on Excel

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6778871B2 (en) * 2001-12-28 2004-08-17 Quickpen International, Inc. Piping and structural component design and fabrication system
US20050132305A1 (en) * 2003-12-12 2005-06-16 Guichard Robert D. Electronic information access systems, methods for creation and related commercial models
US7213199B2 (en) * 2004-07-16 2007-05-01 Cognos Incorporated Spreadsheet user-interface for an enterprise planning system having multi-dimensional data store
US20080126018A1 (en) * 2006-08-22 2008-05-29 Bor-Tsuen Lin Method for constructing object by stacking up functional feature
EP3555798A4 (en) * 2016-12-19 2020-01-01 ConocoPhillips Company Subsurface modeler workflow and tool

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6167406A (en) * 1998-05-08 2000-12-26 Allen-Bradley Company, Llc System, method and article of manufacture for building an enterprise-wide data model
CN101366031A (en) * 2005-07-22 2009-02-11 空中客车法国公司 Method and device for simulating bending of a tube
CN108009359A (en) * 2017-12-01 2018-05-08 中国空气动力研究与发展中心高速空气动力研究所 A kind of boundary layer parameters computational methods and system based on Excel

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
Excel VBA-Based Solution to Pipe Flow Measurement Problem;Selami Demir 等;《Spreadsheets in Education》;20180228;第1-16页 *

Also Published As

Publication number Publication date
CN109492276A (en) 2019-03-19

Similar Documents

Publication Publication Date Title
CN109492276B (en) Method for calculating air conditioner pipeline machining process based on VBA module in Excel
JPH0594537A (en) Method for processing graph
US20130290837A1 (en) Method and Apparatus for Correcting Document Formatting Based on Source Document
JPH07281862A (en) Icon converter and icon conversion method
US20100306706A1 (en) Visual-editing toolbar menu while using text editor
CN102270197A (en) Touch translation system and method thereof
CN102693281A (en) AUTOCAD-based method for generating auxiliary line in PDMS
JPH04178833A (en) Method for supporting software reuse
US5530947A (en) Graphics processing system having function for operating and editing data of a vector graphic and data of an image
CN104123400A (en) Global-Local detail finite element method based on force method
EP1001336A2 (en) Method and apparatus for amplifying design information into software products
CN104508616A (en) Text input method and device and terminal
GB2509552A (en) Entering handwritten musical notation on a touchscreen and providing editing capabilities
WO2010016148A1 (en) Three-dimensional cad model creating device and program
EP1003097A2 (en) Method and apparatus for storing data as liquid information
CN108363779A (en) A kind of method of batch autocad file intelligence inserting block
CN117807969A (en) Engineering quantity information acquisition method, device and storage medium
JP2987071B2 (en) Confirmation application form creation system
JP3788818B2 (en) Display graphic editing system
JPH02176853A (en) Character processor
CN104573179A (en) Generating method for corrugated board based on AUTOCAD in PDMS (Plant Design Management System)
KR20230174497A (en) Automatic creation and correlation of Excel sheet-linked drawing tables available in Aveva Marine Drafting
JPH0216671A (en) Document preparation supporting device
CN116166263A (en) Dial plate generation method, monitoring large disc generation method and product
JP2539070B2 (en) Compiler processor

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant