Data Migration from Visual Basic Interfaces to Excel Tables Prevent Conflict Using Proposed Models

In Small and Medium Enterprises (SMEs), all the reporting tasks are carried out in Microsoft Excel. The employees spend all of their time working on the reports and in the case of an error in the report; a tremendous amount of their time is incurred on the detection of that error. At one of the leather footwear companies in Lahore, Pakistan, report automation was carried out using visual basic for Application (VBA) in Microsoft Excel. The purpose of automation was to increase the reporting efficiency and minimize the chance of error. The authors automated the generation of production plan papers, which used to take 3.11 minutes to be made per plan paper. 3.11 minutes were required just for a single order of only one footwear article). This research provides the framework for the automation of manual reporting in Microsoft Excel. This automation was conducted by using VBA in Microsoft Excel. In the VBA code, the loops and conditional statements were used to program the manual activities to be performed in the report. Initially, the manual method was demonstrated in detail then way of report automation was the focus of discussion. The comparison of both methods was conducted in terms of time utilization. The manual method encompassed a series of activities whereas; the automated template included the buttons with few clicks. A time study of report-making by manual and automated method was conducted which indicated that the automated method was 1.36 minutes faster than the manual method. This research contributes to the provision of a detailed framework, with the help of which any manual work in Microsoft Excel can be automated. It was also indicated by this research that SMEs who cannot afford the implementation of Enterprise Resource Planning (ERP) software, have the option of VBA in Microsoft Excel by which they can enhance their reporting efficiency and office employees` productivity.

From the Publisher: Microsoft's Excel is not only a powerful spreadsheet and graphics tool - it contains a programming language called Visual Basic for Application (VBA). VBA allows you to automate simple tasks, but also enables you to create full-featured applications that make Excel users more productive. In Definitive Guide to Excel VBA, 2nd Edition, Michael Kofler provides the definitive coverage VBA for Excel by showing how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it nevertheless covers advanced topics needed for users already familiar with VBA.First, Kofler introduces VBA and shows examples of the kinds of tasks that can be performed. He then introduces the Excel object model, focusing on the unique characteristics of programming and debugging code associated with a spreadsheet. The next few chapters cover menus, toolbars, forms and templates - the tools for creating customized user interfaces and full-featured applications. Kofler then moves on to a broad range of advanced topics, including automating graphs and diagrams, accessing external databases from Excel and analyzing data using grouping and pivot-tables. He even covers ActiveX automation and the access of Web Services using the Web Service Toolkit. Throughout the book the author never loses sight of the real-world problems faced by Excel programmers. The author shows how to avoid undocumented or poorly documented problems that arise when programming Excel using VBA - the kind of practical knowledge that is usually gained only through hard-won experience.

Введение. Создание методик автоматизированного поиска скважин-кандидатов для геолого-технических мероприятий становится популярным направлением среди специалистов по разработке нефтяных и газовых месторождений. Такие методики позволяют определить четкие правила (критерии) оценки потенциала внедрения геолого-технических мероприятий на тех или иных объектах разработки и сократить трудозатраты профильных специалистов. Целью работы является создание методики и заложение ее в программный продукт по автоматизированному выбору скважин-кандидатов для гидравлического разрыва пласта в условиях разрабатываемых объектов ООО «Харампурнефтегаз». Материалы и методы. Работа разделена на две части: статистический анализ ретроспективных данных (вся история геолого-технических мероприятий на объекте исследования) и оценка потенциала гидравлического разрыва пласта на будущий период разработки объекта. Первая часть работы основана на применении методов математической статистики. Далее по полученным в результате математического анализа данным подготовлен программный продукт на базе Microsoft Excel c использованием Visual Basic for Applications (VBA), который позволяет оценить потенциал скважин объекта разработки к внедрению такого геолого-технологического мероприятия, как гидравлический разрыв пласта. Результаты. Проведенный статистический анализ ретроспективных данных по месторождениям позволил определить критерии оценки потенциала скважин для гидравлического разрыва пласта. С помощью программного продукта подготовлен рейтинг скважин для поведения ГТМ-ГРП, сокращены трудозатраты профильных специалистов на выбор скважин-кандидатов. Заключение. Использование методик автоматизированного поиска скважин-кандидатов для гидравлического разрыва пласта подтверждено на практике в условиях объектов, разрабатываемых ООО «Харампурнефтегаз». Целью дальнейшего исследования является подготовка аналогичной методики для других видов геолого-технических мероприятий, применяемых на рассматриваемых месторождениях. Introduction. Creating methods for automated search of well candidates for well interventions is becoming popular among reservoir engineers. Such methods allow to define clear rules (criteria) for assessing the well intervention potential at certain development targets and reduce the labor costs of subject matter experts. The purpose of the study is to create a software product for automated selection of well candidates for hydraulic fracturing in the conditions of reservoirs developed by Kharampurneftegaz. Materials and Methods. The study is fundamentally divided into two parts: running a statistical analysis of historical data (the entire history of well interventions at the studied target) and assessing the potential of hydraulic fracturing for the future development period of the target. The first part is based on mathematical statistics methods. Further, based on the mathematical analysis data, a software product based on Microsoft Excel using Visual Basic for Applications (VBA) was created which allows to assess the potential of hydraulic fracturing in the wells of the development target. Results. The statistical analysis of field historical data allowed to determine the criteria for assessing the potential of wells for hydraulic fracturing. The created software product made it possible to reduce the labor costs of subject matter experts for selecting well candidates. Conclusion. The use of automated selection of well candidates for hydraulic fracturing has been confirmed in the field in the conditions of reservoirs developed by Kharampurneftegaz. The purpose of further research is to create a similar methodology for other types of well interventions applied in the fields in question.

Chapter 9 - VBA User-Defined Functions

Statistical analysis plays a crucial role in several areas, including engineering, where it helps in making impartial decisions to optimize production processes. Analysis of Variance (ANOVA) is often used to compare sample groups, allowing the simultaneous evaluation of several means, although it does not identify which groups differ from each other. Post-hoc tests, such as Tukey's test, solve this problem, but their reliability decreases with larger amounts of groups. In this work, a new function was developed for Microsoft (MS) Excel, taking advantage of integration with Visual Basic for Applications (VBA), to simplify direct comparisons between sample groups. This function makes it possible to perform an ANOVA for two sample groups based on the provided size, mean, and standard deviation, generating the P value as a result, which can be directly compared to the significance level adopted by each user. The developed function proved to be effective and resulted in significant productivity gains due to its integration with native MS Excel functions.

The purpose of this research is to create modules Response Surface Method (RSM) in Microsoft Excel by using Visual Basic Application programming language. Microsoft Excel has the facility to calculate the statistical problems. Analysis in Microsoft Excel is also relatively complete and procedure more easily and generally Microsoft Excel is available at almost any computer, as part of Microsoft Office. However, Microsoft Excel has not been able to solve problems related to this Response Surface Method. So the finishing will be the existence of a RSM modules in Microsoft Excel. Modules have been made will be applied to find the optimum conditions of membrane polyurethane (PU) in brackish water desalination process. The optimum conditions were determined by the membrane flux and percent rejection. With the RSM modules, it can be determined stationary point and the Response Surface characteristics so it can be used to determine whether the type of stationary point of maximum, minimum or saddle point.

Multi-tiered storage systems today are integrating Solid State Disks (SSD) on top of traditional rotational hard disks for performance enhancement due to the significant IO improvements in SSD technology. It is widely recognized that automated data migration between SSD and HDD plays a critical role in effective integration of SSD into multi-tiered storage systems. Furthermore, effective data migration has to take into account of application specific workload characteristics, deadlines, and IO profiles. An important and interesting challenge for automated data migration in multi-tiered storage systems is how to fully release the power of data migration while guaranteeing the migration deadline is critical to maximizing the performance of SSD-enabled multi-tiered storage system. In this paper, we present an adaptive look ahead data migration model that can incorporate application specific characteristics and I/O profiles as well as workload deadlines. Our adaptive data migration model has three unique features. First, it incorporates a set of key factors that may impact on the performance of look ahead migration efficiency in our formal model develop. Second, our data migration model can adaptively determine the optimal look ahead window size, based on several parameters, to optimize the effectiveness of look ahead migration. Third, we formally and experimentally show that the adaptive data migration model can improve overall system performance and resource utilization while meeting workload deadlines. Through our trace driven experimental study, we compare the adaptive look ahead migration approach with the basic migration model and show that the adaptive migration model is effective and efficient for continuously improving and tuning of the performance and scalability of multi-tier storage systems.

Earlier a new rough set theory for very large databases was proposed by T.Y. Lin (1996). In this paper the authors attempt to evaluate the performance of such a rough set theory for a very large database. ORACLE, a relational database management system (RDBMS), is the market leader in open system databases. Windows NT has been growing into the data server environment and is a strong contender for decision support system applications with its open and cost-effective architecture. So ORACLE running under Windows NT was used in this report. The main goal of this research is to formulate a suitable rough set theory for very large databases.

An extended relational document retrieval model

Cancer has been the major and increasing cause of premature death and years of life lost. Various studies suggested the correlation between the aging process and cancer genesis. To evaluate the performance of the articles and to identify and compare the top-cited articles on aging and cancer, a cross-sectional bibliometric analysis was performed. Top-cited articles that were indexed in the Core databases in Web of Science were utilized to identify articles published from inception to September 3, 2022. The top 100 most-cited articles on aging and cancer were evaluated for their specific characteristics. Both Microsoft Office Excel and Visual Basic for Applications were used to analyze the number of publications and scientific cooperations among authors over time. The query identified the top 100 most-cited articles from the 368,504 articles. The top cited articles accumulated 308,106 citations. The citations per article ranged from 39,141 to 1040. Thirty journals published these 100 articles, with the Ca-A Cancer Journal for Clinicians publishing the largest number. Most articles have focused on the trend analysis of incidence, survival outcomes, and prognosis of cancer from different origins. Co-authorship analysis revealed intense collaborative activity between United States authoritative academic institutions and scholars. The present study is the first to analyze most cited papers in "aging and cancer." The historical trends, current status, and future direction in the field of older patients with cancer are systematically summarized. The occurrence and development of cancer is correlated with aging.

As a result of population growth and finite energy resources, renewable energy fuels and sustainable food supplies have become a hot topic. The demand for grains and oilseed supplies have increased because they are currently the most popular biomass for renewable fuels production. Models of grain processing systems are useful in predicting how the quality of raw ingredients affect the yield and quality of the finish products. Two models, which are soybean processing model and corn-to-ethanol model developed at Iowa State University, are of interest for this thesis. However, at the start of this thesis work, neither model was available for the public, nor had either model been optimized to be user-friendly. The objective of this thesis is to improve the usability of two grain processing models mentioned above. Both models were developed and modified using Microsoft Excel and run by using Visual Basic for Applications (VBA) coding. The first paper focuses on the soybean processing model. It is a solvent extraction plant model that evaluates the estimated processing value (EPV) of raw soybeans by predicting the yield and quality of soybean products, based on the amino acid profile of the soybeans. In this thesis, the option of soybean extruding-expelling system was added to the model and made interchangeable with solvent extraction parameters. The model interface was modified for more effective application and better user experience. A dataset was obtained from a soybean expeller to test the functionality of the model, and results were successfully generated. The second paper focuses on the corn-to-ethanol model. This model enabled the comparison of products values under different processing scenarios, including conventional dry-grind ethanol process, and front-end/backend fractionations as add-on operations to conventional ethanol plants, by predicting the quantity and nutritional compositions of all products. The usability of this model was improved by modifying its user interface, adding pricing components, and modifying some calculations. The functionality of this model will need to be validated in the future. Additionally, the compositions of the products predicted in both models can be entered into the U.S. Pork Center of Excellence, National Swine Nutrition Guide feed formulation software, which is attached as a part of the models. This is part of a larger project to create interoperable analysis tools for several grain processes. The end goal of the models is to be used as extension tools for Iowa State University and decision-making tools for grain processors.

The BCFD program was developed for the analysis of digitized objects using a box-counting algorithm, which has the largest number of applications among the fractal methods in the geosciences. Counting is performed by scanning of image pixels in boxes of different sizes, and the number of boxes is determined automatically from the image resolution. The program calculates the fractal dimension D of the objects in the image, along with the coefficient of determination R2 . Input files are thus transferred to ubiquitous BMP images, in a 1-bit monochrome format. The program outputs the results on screen, into a text file and optionally also directly into MS Excel, where the data can be further used in charts or other calculations. It was tested with three fractal and three Euclidean objects with known theoretical values, plus three geological image data (a natural river network and two fracture networks), and gave results with very high or perfect theoretical accuracy. Application of data values obtained is presented with several examples. BCFD is written in Visual Basic 6.0. The source code is freely available, and is open for any modifications or integration with other software packages that are powered by Visual Basic for Applications (VBA) or its equivalent.

Due to severe water scarcity, water resources used in agricultural sector have been reduced markedly in Hetao irrigation district. Application of water-saving practices (WSPs) is required for the sustainable agricultural development. The human activities including WSPs and increase of groundwater abstraction can lower down the groundwater table, which is helpful to the salinity control. Meanwhile, an excessively large groundwater table depth may result in negative impact on crop growth and fragile ecological environment. In this paper, the Jiefangzha irrigation system in Hetao irrigation district was selected as a typical area, a groundwater flow model based on ArcInfo Geographic Information System (GIS) was developed and implemented to quantify the effect of human activities on the groundwater system in this area. The pre- and post-processing of model data was performed efficiently by using the available GIS tools. The time-variant data in boundary conditions was further edited in Microsoft Excel with programs of Visual Basic for Application (VBA). The model was calibrated and validated with independent data sets. Application of the model indicated that it can well describe the effect of human activities on groundwater dynamics in Jiefangzha irrigation system.

In this article, we report on the implementation of a computerized scheduling tool to optimize staffing for patient transport at the Mayo Clinic. The tool was developed and implemented in Microsoft Excel and Visual Basic for Applications and includes an easy-to-use interface. The tool allows transport management to consider the trade-offs between patient waiting time and staffing levels. While improved staffing efficiency was a desire of the project, it was important that patient service quality was also maintained. The results show that staffing could be reduced while maintaining historical patient service levels.

Microsoft Excel and Visual Basic for Applications were used to model process time variability in a cell culture facility. A deterministic simulation had already established that the plant had sufficient buffer, media, water and CIP (clean-in-place) capacity. The Excel model was built to answer the question, How many batches per year can be expected, as a minimum, knowing that random failures occur and that processing time variability results in a failed batch if a queue exceeds a set value? Aspects to be presented: a) simplifying assumptions that drilled into the question of interest, b) use of VBA to create the multi-batch per year simulation, c) drawing timelines on the screen that speak to the customer without requiring simulation jargon, d) design of modeling experiments that simulated 250 years of operation with a variety of assumptions, and e) use of statistical functions to obtain confidence intervals and probability data.