Visual Basic For Applications Research Articles

Kombinasi Metode AHP dan Metode OCRA Pada Sistem Pendukung Keputusan Pemberian Reward Pada Karyawan

In carrying out their work, every officer or employee certainly has competence that can be relied on. Competence becomes the provision and capital for employees to work professionally. This competency must continue to be honed and improved for employees so that employees' contributions to the agency or organization in the future will be even better. Competence is the main variable that an employee must have in carrying out his work so that the competence he has can help employees carry out their work according to predetermined targets. It is stated that competence is a basic characteristic possessed by a person that directly influences performance or can predict excellent performance. It could be said that competence is what outstanding performers do more often and more. Decision Making on Giving Rewards to PT. Matahari Department store is still not good. This is because subjective elements dominate so that employees with good performance do not have the opportunity to obtain these rewards. In order to provide rewards to employees more precisely and evenly, researchers created a more systematic program design in a Visual Basic Net application system. 2010 by applying a combination of AHP and OCRA methods, where this method makes decisions based on the highest value of each alternative and the values of previously determined criteria. A decision support system is an interactive system that supports decisions in the decision-making process through alternatives obtained from the results of data processing, information and model design using a combination of AHP and Ocra methods. A trial was carried out to enter a data sample of 10 candidates for receiving the reward. With the Decision Support System, it can provide recommendations for reward recipients based on ranking, from 10 potential reward recipients based on the highest ranking, namely: Alternative 1 with a value of 0, Alternative 2 with a value of 0.0339.

Shared PV Systems in Multi-Scaled Communities

In past years, Sweden has been facing a rapid growth of photovoltaic cells, and the total PV installation capacity increased from 300 kW to 1090 MW (2006–2020). The increased number of PV users was a result of active support from the Swedish government with an aim of achieving multiple sustainable goals regarding renewable energy. This project evaluates the profitability of shared PV systems in communities of different sizes in Sweden. This study aimed to contribute to the literature by filling the research gap of presenting the financial benefits at different community scales. The electricity use profiles consisted of hourly measured electricity use that was derived from 1067 individual Swedish apartments. The profiles were then used to create multi-scaled communities with shared PV systems. The mid-market price model was implemented to simulate electricity trading among prosumers in the community using Visual Basic Applications (VBA) in MS Excel. Further, the electricity costs were used for Life Cycle Cost (LCC) assessment. To demonstrate the increase in profitability, the LCC results of households with shared PV systems were compared to households that own PV individually and households that do not own a PV system. The evaluation showed the financial benefits of shared PV systems in comparison with individually owned PV systems. This study also demonstrated the increase in profitability and the reduction in payback time for the average household if sharing a PV system as part of a larger community.

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

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 PM2.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%.

Development of Decision Support System (DSS) for Greenhouse Ventilation and Cooling Control

The confined heat created by the sunlight and ambient temperature is one of the obstacles to greenhouses in the tropics. A conservatory in tropical regions thus requires a proper ventilation and cooling system to provide an ideal greenhouse temperature to support crop production. The main objective of this study is to develop a Decision Support System (DSS) for optimum greenhouse ventilation and cooling control. An equation model to predict the temperature inside was developed by considering heat generation and heat loss inside the greenhouse. The accuracy of the equation model was validated with secondary data from the on-field greenhouse by statistical evaluation metrics. The statistical evaluation proved that the equation model is good with 2.11°C of Root Mean Square Error (RMSE), 6.22% of Percent BIAS (PBIAS) and 0.94 of Nash-Sutcliffe efficiency (NSE) value. A DSS using Microsoft Excel with Visual Basic for Applications (VBA) is developed based on the equation model to provide the ventilation and cooling system information. Input required for the DSS is a climatic condition, dimension and covering greenhouse material. The output of the DSS is the temperature inside the greenhouse, natural ventilation design, forced ventilation, active cooling system design using an evaporative pad and fan, and fogging system. The DSS can be used as an approach for ventilation and cooling design recommendation for the optimum temperature inside the greenhouse.

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

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.

Perancangan Aplikasi Kata Lintas: Teka-teki Silang Dengan Menerapkan Aplikasi Fisher Yates

Crossword puzzle is a word game which is usually in the form of a series of empty spaces in the form of black and white squares, the objective of this game is to fill the white boxes with letters, form certain words or phrases, by completing clues that lead to to a specific answer. The type of crossword puzzle game is currently developing, one of which is a cross word crossword puzzle, in this game the collection of letters is random and the user will look for a word from the random letters. However, it is still not known what randomization algorithm was used to make the crossword game application to scramble the letters so that they can become random letters that will be compiled by the user. After seeing some previous research, choosing the Fisher Yates Shuffle Algorithm which is applied using the Visual Basic Application as a solution is considered very appropriate, where this algorithm will initialize letters first to numbers then the initialized letters are randomized using an algorithm, and the user guesses the series of letters that are used has been scrambled before.

Development of Visual Basic Application PPT Media Based on Cooperative Model Type of NHT to Increase Motivation and Mastery of Physics Concepts

This development research aims to create a product in the form of Power Point Visual Basic Application (PPT VBA) media based on the Numbered Heads Together (NHT) cooperative model on valid, practical, and effective business and energy materials, so that it can be used to measure motivation and mastery of concepts. students at school. The type of research used is research and development (Research & Development) with the ADDIE model, namely analysis, design, development, implementation, and evaluation. Data collection techniques were obtained from the results of filling out the validation sheet by 6 validators, namely 3 expert validators and 3 practitioner validators using a Likert scale. Practicality is obtained from the results of student response questionnaires. Effectiveness was obtained from a learning motivation questionnaire and a concept mastery test. Validity is obtained from the results of the validity assessment by expert validators and practitioners, namely 84% and 89%, respectively, with very valid categories. Practicality is obtained from the results of the student response questionnaire with an average value of 99.45% in the very practical category and gets a positive response. The effectiveness is obtained from the results of the motivation questionnaire after learning with an average value of 71.09% in the high category and the results of the concept mastery test calculated using N-Gain getting an average value of 0.59 in the medium category. So that it can be concluded, the development of PPT Visual Basic Application media based on the cooperative model of the NHT type is valid, practical, and effective to increase learning motivation and mastery of students' concepts on business and energy materials in school learning

Determination of CO2 solubility in Perna perna mussel and analysis of the suitability of the ideal and non-ideal gas models

In SGS (Soluble Gas Stabilization) processes, the carbon dioxide (CO2) is dissolved into the food product under controlled temperature, pressure, and gas/product ratio. The prediction of CO2 solubility can be achieved using a computational code using equations of state from experimental data on CO2 concentration in food. In this work, the solubility of CO2 in Perna perna mussels was obtained using Ideal Gas law and Virial, Van der Waals, Soave-Redlich-Kwong, and Peng-Robinson equations. The SGS process was performed at varying system pressure (200–600 kPa), temperature (0–6 °C), and gas/product (g/p) (mussels) ratio (1:1–5:1) in the cooked and shucked mussels for 65 h. A total of 11 experiments, arranged in a 2³ experimental design, with triplicate runs at the central point, were performed. The compressibility factor indicated that the Ideal Gas state is a good approximation only for experiments 1, 2, 5, and 6. It was observed that the pressure and the gas/product ratio exert a more significant influence on the CO2 solubilization process in the mussel. Visual Basic for Applications (VBA) to perform thermodynamic calculations showed to be a great resource regarding complex calculations.

General Radiography Image Quality Scorecard

Purpose: To describe the Image Quality Audit Framework and highlight the impact of Image Quality Audit.Methods: Radiographers trained in Image Interpretation were recruited to review the radiographic images retrospectively. An Image Quality form was created using “Visual Basic Application” in Microsoft Excel to record the auditors’ findings. There were nine criteria which grade the quality of the images based on technical and clinical aspects. Each criterion consisted of 3-point Likert scale or closed-ended question. The auditors randomly reviewed 5% of the total number of examinations performed by the auditees. The responses were stored, and the programme generated a scorecard automatically. A second auditor was asked to review the images if there is a disagreement between the auditor and auditee in the score achieved.Results: The framework enabled a holistic analysis and accurate identification of radiographer's areas of improvement. Corrective action plans were developed to improve the radiographers’ skill. Continuous active learning was achieved when the auditor and auditee review the results together.Conclusion: A robust clinical audit comprising of both Image Quality and Reject Rate Analysis can improve the quality of images produced. This brings value to the patients by increasing the accuracy of the patient's diagnosis, which allows more targeted treatment. Purpose: To describe the Image Quality Audit Framework and highlight the impact of Image Quality Audit. Methods: Radiographers trained in Image Interpretation were recruited to review the radiographic images retrospectively. An Image Quality form was created using “Visual Basic Application” in Microsoft Excel to record the auditors’ findings. There were nine criteria which grade the quality of the images based on technical and clinical aspects. Each criterion consisted of 3-point Likert scale or closed-ended question. The auditors randomly reviewed 5% of the total number of examinations performed by the auditees. The responses were stored, and the programme generated a scorecard automatically. A second auditor was asked to review the images if there is a disagreement between the auditor and auditee in the score achieved. Results: The framework enabled a holistic analysis and accurate identification of radiographer's areas of improvement. Corrective action plans were developed to improve the radiographers’ skill. Continuous active learning was achieved when the auditor and auditee review the results together. Conclusion: A robust clinical audit comprising of both Image Quality and Reject Rate Analysis can improve the quality of images produced. This brings value to the patients by increasing the accuracy of the patient's diagnosis, which allows more targeted treatment.

Response surface based reliability analysis of critical lateral buckling force of subsea pipelines

Pipeline lateral Out-of-Straightness (OoS) can act as buckle trigger in unburied (exposed) subsea pipelines. Determining the Critical Buckling Force (CBF) of the pipeline is a computationally challenging task due to the inherent uncertainties in contributing parameters which requires utilising reliability-based approaches. This implies the need for a novel framework to develop the response surface (RS) of the CBF of a nominally straight pipeline with rogue lateral OoS which is the subject of this paper and so far, has not been fully explored in the literature. The contributing parameters in CBF are narrowed down through sensitivity studies and the trend of the CBF variation versus OoS curvature and soil lateral mobilisation is established. A novel and structured approach is taken to select the RS sample points. To calculate the CBF of a pipeline with arbitrary design variables, a kriging-based surrogate model is adopted and automated by deploying a Visual Basic Application script. The framework is fully implemented for 6″ to 14” pipelines. Monte Carlo simulation is utilised to show some applications of the RS such as reliability of the buckle initiation at engineered buckling sites and susceptibility of lateral buckling considering target reliability limits.

Soil database for development of soil properties envelope

Residual soils are commonly found in unsaturated condition, and they are associated with high variability. It is necessary to develop a soil database for simplicity of geotechnical analyses and design with respect to cost optimization. This study focused on developing a framework for creating a soil database based on boreholes from different projects, locations and time in Singapore. The soil database was developed utilizing user-friendly and low-cost platforms, i.e. Microsoft Access and Visual Basic Application (VBA). The developed soil database was used to generate saturated and unsaturated soil properties envelopes in Singapore. The developed soil properties envelopes were evaluated by the results from experimental works in this study. The five-parameter logistic curve was chosen as the best-fitting function to develop envelopes with reference to the boxplot. The analyses indicated that soils located at deeper depths have lesser percentage of fine particles which results in a higher saturated permeability, effective friction angle and unsaturated ϕb angle. The results from statistical analyses indicate certain upper limit, typical and lower limit for air-entry value (AEV) for residual soils from Jurong Formation, Bukit Timah Granite and Old Alluvium. Residual soils from each formation located at the ground surface produced the highest AEV while soils at deeper depths exhibit a lower AEV.

Technical note: TEOS-10 Excel – implementation of the Thermodynamic Equation Of Seawater – 2010 in Excel

Abstract. This paper and associated software implement the Thermodynamic Equation Of Seawater – 2010 (TEOS-10) in Excel for an efficient estimation of Absolute Salinity (SA), Conservative Temperature (Θ), and derived thermodynamic properties of seawater – potential density (σΘ), in situ density (ρSA,Θ,p), and sound speed (c). Vertical profile template plots for these parameters are included as is an SA–Θ diagram template, which includes plotting of the density field (computation of user-selected σΘ lines is included). Absolute Salinity can be directly measured with the aid of a densimeter (IOC, SCOR and IAPSO, 2010: p. 82), but in TEOS-10 its estimation relies on the interpolation of data from casts of seawater from the world ocean (IOC, SCOR and IAPSO, 2010), and the Excel workbook introduced here (TEOS-10 Excel, available at https://doi.org/10.5281/zenodo.4748829) includes a subset of the TEOS-10 look-up tables necessary for this estimation, namely the Absolute Salinity Anomaly [deltaSA_ref] and the Absolute Salinity Anomaly Ratio [SAAR_ref] look-up tables. As the user simply needs to paste new data into the spreadsheet to automatically compute the oceanographic parameters referred above, this tool may prove to be useful for all who are not comfortable using the full-featured TEOS-10 programming language environments (e.g. MATLAB, FORTRAN, C) but rather need a simpler way of computing fundamental properties of seawater (e.g. density, sound speed) while adhering to current standards. Returned values are the same (up to 15 decimal places; i.e. difference = 0.000000000000000) as the ones obtained with the MATLAB version of the GSW (Gibbs Sea Water) toolbox (McDougall and Barker, 2011) available at the TEOS-10 website (https://www.teos-10.org, last access: 13 April 2022). This paper describes the Excel workbook, its use, and the included VBA (Visual Basic for Applications) functions. Quality control against the GSW toolbox is also addressed, namely issues detected with the interpolated values returned by the toolbox when there are missing values in the reference look-up table. In these situations, the GSW toolbox replaces missing values with a level pressure horizontal interpolation of neighbour points, while it is clear from the testing results that vertical interpolation, which was then implemented in TEOS-10 Excel, returns a more robust solution.

Graph coloring program for variation of exam scheduling modeling at Binus University based on Welsh and Powell algorithm

In this article, we will design a computer program to solve graph colouring and to visualize the variation of exam scheduling modelling at Binus University in graphs based on the Welch and Powell Algorithm. A vertex colouring of graph G = (V, E) is an F: V → N mapping where the adjacent vertex are different colours in N, i.e. if the edge (u, v) are in E, then F (u) is not equal to F (v). The formulation of problems regarding computer programs based on a small experiment and variations in modelling exams is carried out in graph form using the Visual Basic Application.

Implementasi Algoritma Quicksort Untuk Pembangkitan Kunci Algoritma Elgamal Pada Pengamanan Data File Dokumen

A valid document is an important article containing information. Typically, documents are written on paper and the information is written in ink either by hand or using electronic media. For that we need a security system to secure the contents of the documents contained therein. In this research, a cryptographic method is used that will ensure the security of a document file. In this research, there is a security process that uses the Elgamal algorithm method as a solution to the implementation of the Quicksort algorithm method for document files. The results of this study indicate that the visual basic application can determine whether document files are safe or not. Using this method can help by securing the contents of a document file so that it is not known easily. Quicksort implementation that uses the Elgamal algorithm will be implemented using the visual basic application as evidence of the results of securing document files safely

열회수증기발생기 해석방법을 개선한 가스터빈 복합발전 성능해석 프로그램 개발

Accurate prediction of off-design performance is an important task in the design stage of gas turbine combined cycle (GTCC) power plants, and commercial software is generally used for that purpose. Most commercial software is easy to use in general but is hard to use effectively to guarantee a high accuracy because the mathematical models are very simple or not easy to be tuned to specific purposes. In the GTCC analysis, the analysis of the heat recovery steam generator (HRSG) is the major source of simulation uncertainty. To overcome the problem, a GTCC analysis program was developed, focusing on enhancing the convenience and versatility of the HRSG analysis. The program was coded with the Excel Visual Basic for applications (VBA). The program was validated through comparison with reference data. The maximum deviation from the reference data was 0.27% in the design calculation and 3.26% in the off-design calculation, which are lower in comparison to commercial software.

Simultaneous Determination of Paracetamol, Ibuprofen, and Caffeine in Tablets by Molecular Absorption Spectroscopy Combined with Classical Least Square Method.

In this paper, the classical least-squares (CLS) method with molecular absorption spectrophotometric measurement was used to determine simultaneously paracetamol (PAR), ibuprofen (IBU), and caffeine (CAF) in tablets. The absorbance spectra of the standard solutions and samples were measured over a wavelength from 220 to 300 nm with a 0.5 nm step. The concentration of PAR, IBU, and CAF in the sample solutions was calculated by using Visual Basic for Applications (VBA) and a program called CLS-Excel written in Microsoft Excel 2016. The method and the CLS-Excel program were tested on mixed standard laboratory samples with different PAR, IBU, and CAF concentration ratios, and they showed only small errors and a satisfying repeatability. An analytical procedure for tablets containing PAR, IBU, and CAF was developed. The reliability of the procedure was proved via the recovery and repeatability of the analysis results with an actual tablet sample and by comparing the mean contents of active substances in the tablets obtained from the analytical procedure with the HPLC method. The procedure is simple with a reduced cost compared with the HPLC standard method.

Optimum design of a vaulted roof steel structure using grey wolf and backtracking search optimization algorithms through application programming interface

In present study, structural formation identification of a vaulted roof steel structure is taken as optimization problem. The cost of a steel structure is directly related to the weight of the structure. Weight minimization of the vaulted roof steel structure is considered as objective function of the design problem. The design problem is intended to be as realistic as possible. Wind loads and snow loads are calculated in direction of TS EN 1991-1-4 and TS EN1991-1-3practice code specifications, respectively. And dead loads reobtained in terms of gravity. The structural design constraints of the optimization problem are determined according to American Institute of Steel Construction-Allowable Stress Design (AISC-ASD). In the design, W-shaped steel profile sections to be selected for assigning to the structural elements are considered as discrete design variables. Grey Wolf Optimizer (GWO) and Backtracking Search Optimization (BSO) algorithms that are relatively recent metaheuristic algorithms are utilized as optimizer tools to obtain the minimum weighted structural design. The vaulted roof steel structure is initially modeled in a finite element packaged software (ANSYS Workbench v18.1). Then, using the application programming interface of the software, integration of finite element model with GWO and BSO optimization algorithms encoded in Microsoft Visual Basic for Application (MS VBA v7) programming language is provided. Thus, the performances of two new generation optimization algorithms in design optimization of a vaulted roof steel structure are compared and the benefits of the application programming interface are demonstrated.

Automation of order costing analysis by using Visual Basic for applications in Microsoft Excel

In the modern world of technologies (sciences of arts), optimum operation time is the prime consideration. Technologies with greater operation time are needed to be modified or replaced as per the requirement of the current scenario. In small and medium enterprises of developing countries, almost all the reporting activities are conducted in Microsoft Excel. The manual operation in Microsoft Excel takes a long time (17.37 minutes, only if there was one order of only one article with one color) of the users; furthermore, there can also be a greater chance of error in the report. In the same way, the order costing report at the ABC footwear company of Lahore is prepared manually in Microsoft Excel which used to take a long time to be prepared along with the greater probability of errors in the report. Because of the above-mentioned reasons, the order costing report was decided to be automated with the help of visual basic for applications (VBA) in Microsoft Excel. The manual procedure including all the activities was collected from the planning and costing department of ABC Company. Moreover, all the activities were listed down and their time study was conducted. VBA macros were programmed with the objectives of automating all the manual tasks of the order costing report in Microsoft Excel and eliminating the chance of error (calculation error made by the employee). Macros, were programmed by the use of conditional statements, (i.e. if and else conditions) and various types of loops, (i.e. Do while loop and for loop). Automated decisions were made with the help of conditional statements during the operation and the conditional statements were circulated with the help of loops across the whole worksheet. Two userforms were designed for the execution of macros by the click of command buttons (having macros at their back). Total eight worksheets were incorporated into the automated template. All the programmed VBA macros were explained with the help of flowcharts made in the Microsoft Visio. After the report was automated, a time study of operations performed after each click was conducted with the help of stop watch. The data obtained by the time study was entered into Microsoft Excel so that the time of old and suggested methods could be compared. Comparison of both methods indicated that the suggested method took 85.92% less time as compared to the old method of preparing the order costing report. At the same time, the report made by the suggested method was free of errors and the workload of employees was also reduced.

Development of Dose Management Software Using Visual Basic for Applications and Dose Evaluation in the Field of Nuclear Medicine

The purpose of this study was to develop software for smooth dose management based on the Japan diagnostic reference levels (DRLs 2020) in the field of nuclear medicine. Using the programming language Visual Basic for Applications (VBA), we implemented a function for calculating actual doses, a function for comparing doses at one's own facility with those of DRLs 2020, a function for calculating appropriate doses for pediatric nuclear medicine examinations, and so on. In addition, we evaluated actual doses before and after the software implementation. The software enabled easy calculation of actual doses and comparison with DRLs 2020 for smooth dose management. Furthermore, we were able to use the results of dose evaluation to determine the dosage at our facility and to use them as a reference for optimization. In the field of nuclear medicine, it is possible to manage doses in accordance with DRLs 2020 by introducing own software into our clinical practice.

Development of a modular calculation and analysis tool for the planning process of energy efficient industrial cooling supply systems

Industrial cooling supply systems represent an essential component of many industrial production systems. Since these systems are responsible for a significant share of the final energy consumption of the industrial sector, the successful implementation of suitable energy efficiency measures can not only save costs, but also significantly reduce the CO2 emissions associated with the provision of energy. The planning and implementation of the required measures is often assisted by energy consultancies. In the potential analysis phase, existing or planned cooling supply systems are analysed and mapped in various degrees of detail to determine efficiency and flexibility potentials. To determine these potentials, temperature influences, partial machine load behaviours and waste heat utilizations have to be taken into account. Due to their high complexity, the energy and cost-related analyses are usually very time-consuming.To support energy departments and consultancies regarding such analyses, we developed a Visual Basic for Applications (VBA)-based approach and programme that can be used to compile and analyse general industrial cooling supply systems in a modular and library-oriented way. Considering time-dependent framework conditions, respective machine loads and occurring heat flows, the approach integrates predefined main characteristics (e.g., the overall system efficiency, CO2 emissions or system costs) for each configuration. Furthermore, the programme offers the possibility to compare several configurations based on user-defined criteria such as total cost or CO2 emissions and thus, to determine the most cost- or energy-efficient configuration. Within this study, we applied our approach to data of an industrial use case and analysed alternative configurations to minimize cost and CO2 emissions by maximizing the overall system efficiency and to initiate more in-depth analyses by energy departments and consultancies in a targeted manner.