检索结果-内蒙古大学图书馆

Supply Chain Management of Outsourcing Module Components Decision-Making using Analytical Hierarchy Process and visual basic application in Automotive Body-in-White Welding Assembly Line

引用

INTERNATIONAL JOURNAL OF AUTOMOTIVE AND MECHANICAL ENGINEERING 2022年第3期19卷 9909-9920页

作者： Fudzin, F. Mokhtar, A. A. Muhammad, M. Univ Teknol PETRONAS Mech Engn Sri Iskandar 32600 Perak Malaysia

Supply Chain Management (SCM) has gained the attention of business organizations as it affects corporate efficiency and competitive advantage. Component outsourcing is an important element of SCM practices and is considered to be a multi-criteria decision-making problem (MCDM) in vendor selection processes. However, decision-making on the selection of vendors is crucial, as the outsourcing program is influenced by multiple technical and commercial criteria of vendors. Developing an Excel-based Analytic Hierarchy Process (AHP) model for vendor selection therefore helps to simplify selection processes. In this paper, a visual basic application (VBA) Excel-based AHP model was developed, which multiple criteria, sub-criteria and vendors and simultaneously compared with multiple main criteria, sub-criteria and alternatives for vendor selection. The model was validated with a case study of selecting a vendor for module components of body-in-white (BIW) in automotive industry as industrial application. As a result, vendor A is the best vendor since it has the highest overall score of 0.35206. Whereas vendor B is 0.239, vendor C is 0.126, vendor D is 0.146 and vendor E 0.135. In addition, the model is capable of resolving other MCDM problems. This paper provides resources such as AHP methodology, validating method and VBA code programming to readers in developing their own VBA Excel-based model.

关键词： Analytical hierarchy process visual basic application Supply chain management Outsourcing module Vendor selection

来源：评论

学校读者我要写书评

暂无评论

Indoor Air Quality Diagnosis Program for School Multi-Purpose Activity and Office Spaces

引用

ENERGIES 2022年第21期15卷 8134页

作者： Lee, Yeo-Kyung Kim, Young Il Kim, Ga-Hyeon Seoul Natl Univ Sci & Technol Grad Sch Dept Architectural Engn Seoul 01811 South Korea Seoul Natl Univ Sci & Technol Sch Architecture Seoul 01811 South Korea Seoul Natl Univ Sci & Technol Sch Architecture Architectural Engn Program Seoul 01811 South Korea

This study presents a simple indoor air quality diagnosis program for school office spaces, which are occupied for long durations by teachers, and indoor sports facilities, whose utilization has been on the rise in response to high concentrations of pollutants in outdoor air. The proposed program was made with visual basic for applications (VBA) and Microsoft Excel. This program requires inputs which can be easily determined or measured even by nonexperts and can check the current status of indoor air quality such as CO2 and PM2.5 concentrations and predict the effect if changes are made. In addition, it is possible to diagnose indoor air quality before and after class and compare it with the initial plan so that if it exceeds the indoor air quality maintenance standard range, it can be improved by using a ventilation system and an air purifier. The development of the program was divided into four stages. First, prior research on the influencing factors was investigated. Second, influencing factors affecting the changes in PM(2.5 )and CO2 concentrations were selected by category to accommodate the various factors, and those selected as input were presented. Third, mass and concentration conservation equations were utilized to derive PM2.5 and CO2 concentration prediction equations according to activity and passage of time, and a VBA code was used for constructing the program. For verification of the developed program, the calculation results were compared with the measured data. The mean absolute percentage error (MAPE) was 19.47% for PM2.5 concentration. In order to improve accuracy, Simulation 2, in which the wind speed and indoor/outdoor air pressure difference are corrected, is presented. The MAPE of PM2.5 concentration by the corrected Simulation 2 was lowered 5.15%.

关键词： carbon dioxide PM2.5 indoor air quality diagnosis program multipurpose activity office energy recovery ventilation visual basic application

来源：评论

学校读者我要写书评

暂无评论

Developing An "Eco-Electricity" application to Assess Environmental Impact of Power Plants

Developing An "Eco-Electricity" Application to Assess Enviro...

引用

IEEE International Conference on Electro Information Technology (EIT)

作者： Albalawi, Omar H. Houshyar, Azim White, Bob E. Asumadu, Johnson Western Michigan Univ Kalamazoo MI 49008 USA

ISBN: (纸本)9781728153179

This article presents an "Eco-Electricity" application that was created in a visual basic application (VBA) to assess various power plant technology on the basis of their environmental performance. The application uses a quantitative model [1] that incorporates crucial factors that influence different life cycle phases of a power plant. By combining different techniques of the life cycle cost of various power plants, the application determines the power plant capital cost. Also, the application deals with the negative environmental impact of a power plant as a cost. This impact cost will be accountable as power plant expenses. Using the application will assist decision-makers, companies, and governments in reducing the adverse effect of different power plant systems on the environment and society.

关键词： Life cycle cost (LCC) Electric power plant visual basic application Sustainability Quantitative model

来源：评论

学校读者我要写书评

暂无评论

Mastering VBA for Microsoft® Office 365® 19

引用

2019年

作者： Richard Mansfield

ISBN: (数字)9781119579366

ISBN: (纸本)9781119579335

Customize and ramp-up Office 365 applications NOTE: Please click Downloads (located in the menu on the left) to download “Full Code Download.” The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint. Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have been modified during the three years since the last version of this book. Various elements within VBA have been deprecated or replaced, and the surface UI changed as well. The updated 2019 edition covers topics such as: • Recording macros and getting started with VBA • Learning how to work with VBA • Using loops and functions • Using message boxes, input boxes, and dialog boxes • Creating effective code • XML-based files, ActiveX, the developer tab, content controls, add-ins, embedded macros, and security Written for all levels of Microsoft Office 365 users, Mastering VBA Microsoft Office 365: 2019 Edition explains how to customize and automate the Office suite of applications.

关键词： Microsoft 365 VBA Microsoft 365 visual basic application Microsoft language Microsoft 365 Word Microsoft 365 Excel Microsoft 365 PowerPoint Microsoft 365 Outlook Microsoft programming language Recording macros understanding VBA

来源：评论

学校读者我要写书评

暂无评论

基于现有证书系统的记录电子化及其证书导出方法研究

引用

工业计量 2020年第1期30卷 69-71页

作者：吴风云广州计量检测技术研究院

随着现代检测技术的发展,信息化和自动化的检测方法得到越来越多的运用,传统的手写原始记录已然不能满足实际需要。而电子记录具有工作效率高,出错率低以及良好的可查询管理等特点在诸多领域得到了广泛使用。文章主要分享了一种基于现... 详细信息

随着现代检测技术的发展,信息化和自动化的检测方法得到越来越多的运用,传统的手写原始记录已然不能满足实际需要。而电子记录具有工作效率高,出错率低以及良好的可查询管理等特点在诸多领域得到了广泛使用。文章主要分享了一种基于现有的证书系统,仅通过Office办公软件实现原始记录电子化并将电子记录数据导入现有的证书系统的方法。该方法简单可行,不需要对现有的证书系统进行修改升级,也不需要采购新的软件或者设备,具有很好的经济效益。

关键词：记录电子化 visual basic application HTTP协议

来源：评论

学校读者我要写书评

暂无评论

大学物理实验报告自动批阅系统设计

引用

船海工程 2009年第2期38卷 98-100页

作者：赵龙辽宁工程技术大学理学院辽宁阜新123000

本文介绍了大学物理实验报告自动批阅系统的设计思想和实现方法,对系统的开发要求、基本功能、结构组成和实现方式作了详细的阐述.

关键词：实验报告 visual basic application Excel度

来源：评论

学校读者我要写书评

暂无评论

Raceway design and simulation system (RDSS): An event-based program to simulate the day-to-day operations of multiple-tank raceways

引用

AQUACULTURAL ENGINEERING 2008年第2-3期39卷 59-71页

作者： Wang, Yin-Han Turton, Richard Semmens, Ken Borisova, Tatiana W Virginia Univ Dept Chem Engn Morgantown WV 26506 USA W Virginia Univ Ctr Agr Nat Resources & Community Dev Morgantown WV 26506 USA Univ Florida Dept Food & Resource Econ Gainesville FL 32611 USA

A software program, called Raceway Design and Simulation System (RDSS), has been built using visual basic for applications in Microsoft(R) Excel. The purpose of the software is to allow users to manage their raceways more efficiently by providing a tool to simulate the operation of an existing raceway or to predict conditions in a raceway under a wide variety of operating conditions. The program simulates the conditions in a system of multiple tanks that may be arranged in sets of parallel raceways with serial water flow. The user may specify the use of overflow weirs or customized oxygen injection points in order to reoxygenate the water flow from succeeding tanks in each raceway. During the course of the simulation, the user may specify the size, number, location, and price of any new fish introduced into any raceway tank. Subsequent movement of fish between tanks or removal of part or all of a cohort is tracked by the program. Input data required include properties of the influent water such as temperature, flowrate, dissolved oxygen, pH, total ammonia nitrogen, and salinity. Fish growth is predicted using these input data and stocking information that is provided by the user. Fish mortality may be specified for each tank in a raceway. In addition, the costs of food, the purchase cost of fish, and the revenue from the sale of fish are also tracked. A comprehensive user manual is included with the software that provides information on the basic operation of the program, all the programming features, troubleshooting and, the various error messages that the user may encounter when using the program. (C) 2008 Elsevier B.V. All rights reserved.

关键词： Aquaculture Simulation Trout Raceway Flowing water system Production Computer model Facility management visual basic application

来源：评论

学校读者我要写书评

暂无评论

The development of novel control valve diagnostic software based on the visual basic programming language

引用

PROCEEDINGS OF THE INSTITUTION OF MECHANICAL ENGINEERS PART I-JOURNAL OF SYSTEMS AND CONTROL ENGINEERING 2000年第I2期214卷 99-127页

作者： Sharif, MA Grosvenor, RI Univ Wales Coll Cardiff Sch Engn Syst Engn Div Cardiff CF1 3NS S Glam Wales

A number of commercially available control valve fault diagnostic systems were considered by the authors and it was established that they produce test results that require specialist knowledge to interpret them fully and, therefore, to diagnose faults accurately in control valves. This provided the incentive to develop a graphical user-interface diagnostic program, as reported in this paper, which can be used easily by field technicians and operators to diagnose faults in control valves and actuators. A commercially available diagnostic system had been used to generate a large number of test results for various faults in a typical control valve and actuator. These results were incorporated into the newly developed control valve diagnostic program as its database. Then, when tests are conducted and available information is entered into the program, a diagnostic statement is produced. The statement is based on the comparison between the entered value for given valve performance parameters and those which are in the established database. In addition, an option was included which enables the user to import certain types of test data directly from the commercially available diagnostic system so that the condition of the control valve can be established with a higher degree of accuracy and without any additional hardware components. The diagnostic program has three options. They are as follows: determine condition, estimate condition and step response analysis. The determine condition option enables the types of fault to be determined with absolute certainty. However, this option can only be used if all the 12 valve performance parameters are known and are entered into the diagnostic program. On the other hand, the estimate condition option was developed in such a way that faults can be predicted when at least one of the valve's performance parameters is entered into the program. This is because, when the valve's performance parameters are entered and the estimate conditi

关键词： fault diagnosis graphical user-interface program visual basic application control valves and actuators condition monitoring

来源：评论

学校读者我要写书评

暂无评论

Automatická správa emailových účtů v MS Outlook

Automatická správa emailových účtů v MS Outlook

引用

作者： Karlubík, Peter Brno University of Technology

Tato práce se zabývá tvorbou aplikace, takzvaného makra, napsaného v jazyce VBA. Toto makro má sloužit k usnadnění a částečné automatizaci každodenní práce ve f... 详细信息

Tato práce se zabývá tvorbou aplikace, takzvaného makra, napsaného v jazyce VBA. Toto makro má sloužit k usnadnění a částečné automatizaci každodenní práce ve firmě. Hlavním cílem bylo navrhnout a vytvořit makro tak, aby mohlo být reálně využito firmou, pro kterou je určeno, tak jak bylo zamýšleno. V práci je také analyzovaná situace podniku, jak co se týče vnějšího tak vnitřního prostředí. Koncovým výsledkem je nástroj, který umožňuje automaticky spravovat emailové účty dané firmy, přebírat přílohy, roztřídit je podle typů soborů a pak je posílat k tisku. V závěru práce je zhodnocen skutečný přínos produktu.

关键词： visual basic aplikace správa emailových účtů firemní software VBA tisk emailových příloh automatizované zpracování příloh visual basic application email account management business software VBA email attachment print automatic attachment processi

来源：评论

学校读者我要写书评

暂无评论

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案：

请选择收藏分类：

通借通还

建议与咨询 留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

时间限定

文献类型

馆藏选择

核心期刊

语言

文献类型

帮助

文字说明：

检索规则说明：

检索范例：

分类表

所选分类

限定检索结果

文献类型

馆藏范围

日期分布

学科分类号

主题

机构

作者

语言

请选择保存的检索档案： 新增检索档案 确定 取消

请选择收藏分类： 新增自定义分类 确定 取消

通借通还

建议与咨询留下您的常用邮箱和电话号码，以便我们向您反馈解决方案和替代方法

请选择保存的检索档案：

请选择收藏分类：