CN109492276A - The method for calculating air-conditioning duct processing technology based on VBA module in Excel - Google Patents
The method for calculating air-conditioning duct processing technology based on VBA module in Excel Download PDFInfo
- Publication number
- CN109492276A CN109492276A CN201811245949.2A CN201811245949A CN109492276A CN 109492276 A CN109492276 A CN 109492276A CN 201811245949 A CN201811245949 A CN 201811245949A CN 109492276 A CN109492276 A CN 109492276A
- Authority
- CN
- China
- Prior art keywords
- excel
- module
- data
- interface
- userform
- 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.)
- Granted
Links
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 method disclosed by the invention for calculating air-conditioning duct processing technology based on VBA module in Excel, specific calculate comprise the following processes: exploitation VBA module；CATIA data processing module, data format conversion module and computing module are defined in Excel worksheet；Operational controls are arranged in design software interface and each functional area in Excel；The coordinate point data that CATIA format is imported in the forms of Excel worksheet, the included formula of the formula and Excel being arranged by computing module calculate the result of each technological parameter and show that calculating ties and exports csv file in the text box at the interface UserForm.Method disclosed by the invention solves the problem that existing calculation method process is cumbersome, and artificial a large amount of repetitive operation is needed to cause working efficiency low.
Description
Technical field
The invention belongs to mechanical engineering technical fields, are related to a kind of based on VBA module calculating air-conditioning duct processing in Excel
The method of technique.
Background technique
Pipelines of automobile air conditioner is three-D space structure, hollow aluminum pipe, end sealing structure comprising bending (pier nose, bulge,
Rise mouth, necking), sealed groove (crimping with air conditioner rubber pipe), pressure switch, refrigerant charging valve, fixed bracket is (with Al pipe butt welding
Or it is hinged) etc. structures, pipeline trend changed according to the arrangement of the systems such as engine, intercooler, radiator, driver's cabin,
The parameter of aluminum pipe: spatial point, caliber, wall thickness, radius bend, end sealing mode (using Principle of Plastic Molding processing pier nose,
The structures such as bulge, the mouth that rises, necking), sebific duct parameter: length, specification, applicable aluminum pipe specification.Pipeline machining coordinate point is general at present
All over using coordinate points derived from CATIA are manually pasted in Excel table by hand, calculated using pre-set formula, so
Export csv file by hand afterwards；It is that manual calculation is calculated by inquiring various technological parameters with calculator that technological parameter, which calculates then,
Raw material length needed for processing and aluminum pipe length parameter required when processing, this calculation method process is cumbersome, exists big
Repetitive operation is measured, use is very inconvenient, reduces working efficiency.
Summary of the invention
The object of the present invention is to provide a kind of method for calculating air-conditioning duct processing technology based on VBA module in Excel, solutions
Existing calculation method process of having determined is cumbersome, the problem for needing artificial a large amount of repetitive operation to cause working efficiency low.
The technical scheme adopted by the invention is that calculating the side of air-conditioning duct processing technology based on VBA module in Excel
Method, specific calculate comprise the following processes:
(1) VBA module is developed: in the Visual Basic editing machine that Excel is carried, foundation and Microsoft
The interface UserForm, ThisWorkbook module and the worksheet module of data call in Excel, the ThisWorkbook mould
The interface UserForm is loaded when block starts for Excel macro document, the worksheet module is used to switch the work in Excel
Table, the interface UserForm are set as multi-page, calculate the page and technique for the interface UserForm to be divided into technological parameter
The parameter query page, the technological parameter, which calculates page setup, order button, text box and list box；
(2) CATIA data processing module, data format conversion module and computing module, institute are defined in Excel worksheet
CATIA data processing module is stated to be used to for the coordinate point data that CATIA software exports being stored in the worksheet of Excel, it is described
Computing module is provided with the calculation formula of spatial point spacing, space line angle, arc length, pipeline centerline length, described
Data conversion module is used to be converted to the result that data computation module calculates the file of output CSV format；
(3) operational controls, including UserForm circle are arranged in design software interface and each functional area in Excel
Each functional area in face and triggering call control, import the memory block of coordinate point data for the CATIA data processing module
Domain, for the zoning of the computing module, and the data storage areas for exporting calculated result CSV format；
(4) CATIA format is imported in the forms of Excel worksheet or through the interface UserForm of VBA module
Coordinate point data, user's inputting process parameters on the interface UserForm, the computing module of the Excel worksheet according to
The included formula of the formula and Excel that the technological parameter of input is arranged by computing module calculates the result of each technological parameter simultaneously
And calculated result is shown in the text box at the interface UserForm and passes through the order button at the interface UserForm
Export csv file.
Other features of the invention also reside in,
ThisWorkbook module is used to judge the number of book opened in Excel when Excel macro document is closed
Amount directly exits if book quantity is 1 and does not prompt to save, and otherwise only closes work at present book.
Worksheet module realizes hidden page diverter tool column by specific code, freezes worksheet switching shortcut key taboo
The only random switch operating table of user, the encryption VBA module, prevent user from arbitrarily modifying journey by VisualBasic editing machine
Sequence and work table structure.
The technological parameter at the interface UserForm calculate the order button being arranged on the page include select file, removing, calculating,
Export data and the trigger button exited；It is respectively set in the interface UserForm there are four text box, is used for inputting process parameters
With display calculated result, first text box is used to displaing coordinate data, length of straigh line, spatial point angle；Second text
Frame is used to input mould specification, aluminum pipe material length, pier nose specification, withholds parameter；Third text box be used to show sebific duct length and
Specification；Technological parameter needed for 4th text box extracts engineering drawing, copies to worksheet convenient for user by hand；It is described
The list box being arranged in the interface UserForm can also be obtained from the worksheet of Excel automatically and be sat for storing coordinate data
Mark data.
In second text box on the interface UserForm after inputting process parameters, call Excel's by computed push-buttom
Computing module, and what is be arranged in Excel shows for computing module zoning as a result, then in output calculated result
The data storage areas of CSV format after selection capitalization or small letter option, exports csv file by export data button.
Data and technological parameter that button is used to quickly remove selection are removed, for starting new calculating；Exit button is used
Interface is calculated in closing, and defaults and does not save worksheet.
Technological parameter query page calls the photo of Excel storage inside, and shows difference according to the parameter of user's selection
Query result.
Data extraction module is set in Excel, for the calculated result of data computation module to be automatically copied into system
Clipbook can call the data of data extraction module to paste by the data button everywhere on the interface UserForm
In text box on the interface UserForm, to show calculated result.
The invention has the advantages that being solved based on the method that VBA module in Excel calculates air-conditioning duct processing technology
Existing calculation method process is cumbersome, the problem for needing artificial a large amount of repetitive operation to cause working efficiency low.It can simplify
Pipeline processing technology calculating process, coordinate point data are read from csv file automatically by control, and number can be completed in an operation interface
Process is exported according to reading, parameter selection, calculating, result, easy to operate, computational efficiency and accuracy greatly improve, and save for user
The plenty of time is saved, and mistake can be avoided to greatest extent, the file of different-format can be exported as needed.
Detailed description of the invention
Fig. 1 is the calculation flow chart of calling work list processing CATIA coordinate point data of the invention；
Fig. 2 is the structural schematic diagram of VBA module in Excel of the invention；
Fig. 3 is the schematic diagram at the interface UserForm in VBA module of the invention.
Specific embodiment
The following describes the present invention in detail with reference to the accompanying drawings and specific embodiments.
The method that air-conditioning duct processing technology is calculated based on VBA module in Excel of the invention, as depicted in figs. 1 and 2,
Specific calculate comprises the following processes:
(1) VBA module is developed: in the Visual Basic editing machine that Excel is carried, foundation and Microsoft
The interface UserForm, ThisWorkbook module and the worksheet module of data call in Excel, ThisWorkbook module are used
The interface UserForm is loaded when the starting of Excel macro document, worksheet module is used to switch the worksheet in Excel,
The interface UserForm is set as multi-page, and for the interface UserForm to be divided into, technological parameter calculates the page and technological parameter is inquired
The page, technological parameter, which calculates page setup, order button, text box and list box；
(2) CATIA data processing module, data format conversion module and computing module are defined in Excel worksheet,
CATIA data processing module calculates mould for the coordinate point data that CATIA software exports to be stored in the worksheet of Excel
Block is provided with the calculation formula of spatial point spacing, space line angle, arc length, pipeline centerline length, and data convert mould
Block is used to be converted to the result that data computation module calculates the file of output CSV format；
(3) design software interface and each functional area in Excel are arranged operational controls, including are used for UserForm circle
Each functional area in face and triggering call control, import the storage region of coordinate point data for CATIA data processing module, use
In computing module zoning, and the data storage areas for exporting calculated result CSV format；
(4) CATIA format is imported in the forms of Excel worksheet or through the interface UserForm of VBA module
Coordinate point data, user's inputting process parameters on the interface UserForm, the computing module of Excel worksheet is according to the work of input
The included formula of formula and Excel that skill parameter is arranged by computing module calculate the result of each technological parameter and
Calculated result is shown in the text box at the interface UserForm and csv file is exported by the order button at the interface UserForm.
Wherein, ThisWorkbook module is used to judge the book opened in Excel when Excel macro document is closed
Quantity, if book quantity be 1, directly exit and do not prompt to save, otherwise only close work at present book.
Wherein, worksheet module realizes that hidden page diverter tool column, to freeze worksheet switching fast by specific code
Prompt key forbids the random switch operating table of user, encryption VBA module, prevents user from arbitrarily modifying by VisualBasic editing machine
Program and work table structure.
Wherein, as shown in figure 3, it includes selection that the technological parameter at the interface UserForm, which calculates the order button being arranged on the page,
File, removing, calculating, export data and the trigger button exited；It is respectively set in the interface UserForm there are four text box, is used
In inputting process parameters and display calculated result, first text box is used to displaing coordinate data, length of straigh line, spatial point folder
Angle；Second text box is used to input mould specification, aluminum pipe material length, pier nose specification, withholds parameter；Third text box is used to show
Show sebific duct length and specification；Technological parameter needed for 4th text box extracts engineering drawing, copies to work convenient for user by hand
Table；The list box being arranged in the interface UserForm can also be obtained from the worksheet of Excel automatically for storing coordinate data
Coordinate data.
Wherein, it is called after inputting process parameters by computed push-buttom in second text box on the interface UserForm
The computing module of Excel, and what is be arranged in Excel shows by computing module zoning as a result, then based on output
After selecting capitalization or small letter option, CSV text is exported by export data button for the data storage areas for calculating result CSV format
Part.
Wherein, data and technological parameter that button is used to quickly remove selection are removed, for starting new calculating；Exit by
Button is defaulted for closing the interface UserForm and does not save worksheet, and the warning dialog box is not popped up.
Wherein, technological parameter query page calls the photo of Excel storage inside, and is shown according to the parameter that user selects
Different query results.
Data extraction module is set in Excel, for the calculated result of data computation module to be automatically copied into system
Clipbook can call the data of data extraction module to paste by the data button everywhere on the interface UserForm
In text box on the interface UserForm, to show calculated result.
The method concrete operations example for calculating air-conditioning duct processing technology based on VBA module in Excel of the invention is as follows:
Data processing region is defined in Excel worksheet, including external data is read in, coordinate calculates, format is converted etc.
Module: user is stored in excel document from the coordinate point data that CATIA software exports, and file suffixes is entitled " .CSV ", coordinate
For data from Excel read-in programme, user selects technological parameter, then calculates, final result is shown on the interface UserForm
Out, csv file can also be exported, makes engineering drawing for importeding into CATIA software.
(1) CATIA coordinate point data ingress area is defined within sheet1, and user need to be by coordinate points derived from CATIA
Data paste sheet1, can also be led automatically by the select file button select file on the interface UserForm by software
Enter to the region sheet1 (B:B).
(2) it is sheet2 that data zoning is defined in Excel worksheet, and data operation is mainly included using Excel
Function and setting formula, by assignment on the interface UserForm, applied exemplary formula and code are as follows:
Data screening inquiry :=INDEX (AG:AG, MATCH (C4, R:R, 0))+C10；
Data selectively input :=ROUND (INDIRECT (" B " &ROW (B4) * 3-2), 1)；
Spatial point spacing:
=IF (AND (E3=E4, F3=F4, G3=G4), SQRT (((E3-E2) ^2)+((F3-F2) ^2)+((G3-G2)
^2)))；
Space line angle:
=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)))
Arc length calculates:
=IF (AND (E4=E5, F4=F5, G4=G5), ((180-K3) * 3.1415926*C $ 2/180))
Cell assignment: Sheets (" A ") [C4]=Me.ComboBox1.Value
Discovery has a chat software and component collisions when practical debugging, causes calculating to be unable to operate normally, use is specific
The code ends conflict procedure.
(3) output csv file is defined as worksheet sheet3, finally passes through export button output file by user；CSV text
Part output: derived file type only need to be selected, the data in specified region will be exported as interchangeable file format [Amiga] automatically by program
CSV (CSV formatted data is used to data being poured into CATIA engineering drawing), and it is automatically saved to the catalogue where macro document, text
Part title is made of coordinate points head and the tail capitalization English letter+random number, avoids repeating；After document creation, file institute is automatically opened
File, and prompt file to save and successfully prompt.
In the method for calculating air-conditioning duct processing technology based on VBA module in Excel of the invention, by Excel
VBA module is set, and Excel macro document is opened by VB program, and forms are not shown when VB program is run, and program is visited automatically when starting
It asks server, and is compared with version information in program installation directory, pop-up attention program updates if version information is inconsistent.
After program compiling, the packing function of being carried using VB program, creation installation exe installation procedure.It can be selected in user after program installation
The installation directory selected generates some installation files, and the file of installation directory cannot be deleted, and otherwise program is unable to operate normally.
The present invention has many advantages, such as to reduce mistake compared with the prior art, saves the time, maintain easily data, is easy；If
Software need to be entered data by hand using the prior art, and sets technological parameter by hand, then obtained calculated result, obtained
Calculated result can not export into file, can only be replicated by hand paste, and process is cumbersome, be easy error.There are also following by the present invention
The utility model has the advantages that
(1) All Files are packaged into exe installation procedure, are easily installed use and edition upgrading；
(2) installation procedure includes the parameter and formula of excel book storage, version information, program assembly etc.；
(3) the technological parameter photo of excel worksheet storage, for being shown to forms, this function can avoid photo storage
To local directory, prevent file from accidentally being deleted；
(4) visualization interface is created by VBA, and the code based on visual basic language maintains easily, and powerful,
It is the first choice of software secondary development.
Claims (8)
1. the method for calculating air-conditioning duct processing technology based on VBA module in Excel, which is characterized in that specific calculate includes such as
Lower process:
(1) VBA module is developed: in the Visual Basic editing machine that Excel is carried, in foundation and Microsoft Excel
The interface UserForm, ThisWorkbook module and the worksheet module of data call, the ThisWorkbook module are used for
The interface UserForm is loaded when Excel macro document starts, the worksheet module is used to switch the worksheet in Excel, described
The interface UserForm is set as multi-page, and for the interface UserForm to be divided into, technological parameter calculates the page and technological parameter is inquired
The page, the technological parameter, which calculates page setup, order button, text box and list box；
(2) CATIA data processing module, data format conversion module and computing module are defined in Excel worksheet, it is described
CATIA data processing module is for the coordinate point data that CATIA software exports to be stored in the worksheet of Excel, the meter
Calculate the calculation formula that module is provided with spatial point spacing, space line angle, arc length, pipeline centerline length, the number
It is used to be converted to the result that data computation module calculates the file of output CSV format according to conversion module；
(3) operational controls are arranged, including the interface UserForm in design software interface and each functional area in Excel
Each functional area and triggering call control, import the storage region of coordinate point data for the CATIA data processing module, use
In the zoning of the computing module, and the data storage areas for exporting calculated result CSV format；
(4) coordinate of CATIA format is imported in the forms of Excel worksheet or through the interface UserForm of VBA module
Point data, user's inputting process parameters on the interface UserForm, the computing module of the Excel worksheet is according to input
The formula that is arranged by computing module of technological parameter and the included formula of Excel calculate each technological parameter result and
Calculated result is shown in the text box at the interface UserForm and is exported by the order button at the interface UserForm
Csv file.
2. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as described in claim 1, feature exist
In, the ThisWorkbook module is used to judge the quantity of book opened in Excel when Excel macro document is closed,
If book quantity is 1, directly exits and do not prompt to save, otherwise only closes work at present book.
3. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as described in claim 1, feature exist
In the worksheet module realizes hidden page diverter tool column by specific code, freezes worksheet switching shortcut key taboo
The only random switch operating table of user, the encryption VBA module, prevent user from arbitrarily modifying journey by VisualBasic editing machine
Sequence and work table structure.
4. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as described in claim 1, feature exist
Technological parameter in, the interface UserForm calculate the order button being arranged on the page include select file, removing, calculating,
Export data and the trigger button exited；Text box there are four being respectively set in the interface UserForm, for inputting technique
Parameter and display calculated result, first text box are used to displaing coordinate data, length of straigh line, spatial point angle；Second
Text box is used to input mould specification, aluminum pipe material length, pier nose specification, withholds parameter；Third text box is used to show that sebific duct is long
Degree and specification；Technological parameter needed for 4th text box extracts engineering drawing, copies to worksheet convenient for user by hand；It is described
The list box being arranged in the interface UserForm can also be obtained from the worksheet of Excel automatically and be sat for storing coordinate data
Mark data.
5. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as claimed in claim 4, feature exist
In, in second text box on the interface UserForm after inputting process parameters, pass through computed push-buttom call Excel meter
Module is calculated, and what is be arranged in Excel shows for computing module zoning as a result, then in output calculated result CSV
The data storage areas of format after selection capitalization or small letter option, exports csv file by export data button.
6. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as claimed in claim 4, feature exist
In the data and technological parameter removed button and be used to quickly remove selection, for starting new calculating；The exit button
Interface is calculated for closing, and defaults and does not save worksheet.
7. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as described in claim 1, feature exist
In the technological parameter query page calls the photo of Excel storage inside, and is shown according to the parameter that user selects different
Query result.
8. the method for calculating air-conditioning duct processing technology based on VBA module in Excel as described in claim 1, feature exist
In data extraction module being set in Excel, for the calculated result of the data computation module to be automatically copied into cutting for system
Pasting board, by the data button everywhere on the interface UserForm can call data extraction module data paste it is described
In text box on the interface UserForm, to show calculated result.
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 true CN109492276A (en) | 2019-03-19 |
| CN109492276B 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) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532502A (en) * | 2019-08-26 | 2019-12-03 | 盐城工学院 | A kind of mechanical equation based on Excel indicates the application method of system and 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 |
| CN113704973A (en) * | 2021-08-03 | 2021-11-26 | 人本股份有限公司 | VBA-based bearing life data automatic processing device |
Citations (8)
| 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 |
| US20030125826A1 (en) * | 2001-12-28 | 2003-07-03 | 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 |
| US20060015805A1 (en) * | 2004-07-16 | 2006-01-19 | Humenansky Brian S | 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 |
| 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 |
| US20180171761A1 (en) * | 2016-12-19 | 2018-06-21 | Conocophillips Company | Subsurface modeler workflow and tool |
-
2018
- 2018-10-24 CN CN201811245949.2A patent/CN109492276B/en active Active
Patent Citations (8)
| 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 |
| US20030125826A1 (en) * | 2001-12-28 | 2003-07-03 | 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 |
| US20060015805A1 (en) * | 2004-07-16 | 2006-01-19 | Humenansky Brian S | Spreadsheet user-interface for an enterprise planning system having multi-dimensional data store |
| CN101366031A (en) * | 2005-07-22 | 2009-02-11 | 空中客车法国公司 | Method and device for simulating bending of a tube |
| US20080126018A1 (en) * | 2006-08-22 | 2008-05-29 | Bor-Tsuen Lin | Method for constructing object by stacking up functional feature |
| US20180171761A1 (en) * | 2016-12-19 | 2018-06-21 | Conocophillips Company | Subsurface modeler workflow and tool |
| 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)
| Title |
|---|
| SELAMI DEMIR 等: "Excel VBA-Based Solution to Pipe Flow Measurement Problem", 《SPREADSHEETS IN EDUCATION》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532502A (en) * | 2019-08-26 | 2019-12-03 | 盐城工学院 | A kind of mechanical equation based on Excel indicates the application method of system and 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 |
| CN113704973A (en) * | 2021-08-03 | 2021-11-26 | 人本股份有限公司 | VBA-based bearing life data automatic processing device |
| CN113704973B (en) * | 2021-08-03 | 2024-03-15 | 人本股份有限公司 | Bearing life data automatic processing device based on VBA |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109492276B (en) | 2022-11-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109492276A (en) | The method for calculating air-conditioning duct processing technology based on VBA module in Excel | |
| JP4738067B2 (en) | CAD data creation apparatus and method | |
| CN108465964B (en) | Three-dimensional white car body welding process card compiling method based on welding spot structured data | |
| CN103064403A (en) | Method and system of electronic control unit (ECU) hardware-in-loop simulation automated testing | |
| CN104123400A (en) | Global-Local detail finite element method based on force method | |
| KR20100071361A (en) | Project management device and method for architecture modeling tool of application software on autosar and computer readable recording medium therefor | |
| CN113360965A (en) | Revit-based automatic modeling method and system for assembly type shear wall | |
| CN110688798B (en) | Deformation prediction method, device, equipment and storage medium for shell structural part | |
| KR20150030810A (en) | Method of generating pmi in light model | |
| CN112597670B (en) | Data input method and device of rainstorm flood management model software | |
| CN101419635A (en) | Method for automatically generating digital-analog conduit welding clamp intelligence system | |
| CN101894024B (en) | Model bank-based model element consistency ensuring method | |
| CN106777641B (en) | Rapid modeling method for reinforcing plate with inverted right angle | |
| CN102779036B (en) | For the Software tool of automatic technology | |
| CN114326642B (en) | Interface matching method, device, equipment and medium for nuclear power DCS system | |
| CN115203805A (en) | Air duct model generation method and device based on BIM technology and readable medium | |
| CN115599908A (en) | Method and system for labeling unstructured data document | |
| KR20210132938A (en) | System for analyzing pipe system of ship on web platform | |
| Picco et al. | A fast response performance simulation screening tool in support of early stage building design | |
| WO2020264249A1 (en) | Multiphysics automated support generation for additively manufactured components | |
| López-Gómez et al. | Multjparameter nonlinear eigenvalue problems: positive solutions to elliptic lotka-volterra systems | |
| CN114860235B (en) | Method for coupling commercial software and self-programming software | |
| CN109086548A (en) | A kind of solution about hydro-structure three-dimensional arrangement of reinforcement | |
| KR102538081B1 (en) | 3D transforming system and method of setting drawing for shipbuilding | |
| JP3245515B2 (en) | Drawing information management device |
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 |