Excel Macro Research Articles

Simulation of container discharge dynamics using modified cellular automata

In the field of physical logistics, efficient and precise control of material flow during the emptying of containers such as silos and wagons is crucial. This study introduces a not conventional cellular automaton model to simulate spillage from containers. The model is implemented using Excel macros, providing a user-friendly and accessible platform for logistics professionals. By modifying the traditional cellular automaton framework, the simulation can accurately represents the dynamics of material flow during container emptying processes. The proposed method allows for fine-tuned control over the spillage by integrating specific constraints and parameters, enhancing operational efficiency and reducing material loss. The versatility of the model makes it applicable to a wide range of logistical scenarios, demonstrating its potential as a valuable tool in physical logistics management.

Use Of Information And Communication Technologies For Productivity: A Case Study In The Payments And Charges Sector Of The Federal University Of Amazonas

Background: Information and Communication Technologies (ICT) are fundamental for the modernization and efficiency of the public sector. The Federal University of Amazonas (UFAM) implemented an automation process in the Payments and Charges sector as of 2015, using tools such as Excel VBA and Macro Recorder, in order to optimize manual operations and increase productivity. This study evaluates the impact of automation on the efficiency of the sector, comparing data from 2014 (pre-automation) and 2018 (post-automation), in a context of significant staff reduction. Materials and Methods: The research is based on a case study, with data extracted from the reports of the Siape DataWarehouse system. The number of launches, the average time between each operation and the duration of the launches before and after the implementation of ICT were analyzed. The 2014 data reflects the manual scenario with seven servers performing the operations, while the 2018 data represents the automated scenario with three servers and technological tools optimizing the tasks. Results: The analysis showed that in 2014, the average time between manual entries was approximately 4 minutes, with 410 entries per month. In 2018, with automation, the time between launches was reduced to seconds, and the workload increased significantly, with up to 1060 monthly launches performed by just one server. Conclusion: Automation in UFAM's Payments sector resulted in a significant increase in productivity, compensating for the reduction in personnel. However, challenges such as continuous training of servers and maintenance of automated tools still need to be overcome to ensure the sustainability of long-term gains.

Impact of Digital Literacy, Use of AI tools and Peer Collaboration on AI Assisted Learning- Perceptions of the University students

The technology-supported education systems seamlessly integrated throughout the globe in response to the challenges posed by the Covid-19 pandemic. The swift developments of the digital tools with Artificial Intelligence (AI) support are also readily diffused among the educational communities. This research paper investigates the synergistic impact of digital literacy, the incorporation of AI tools, and Peer Supported Collaborative Learning (PSCL) on the learning perceptions of university students. The research aims to discern the implications of these technological and social facets on students' attitudes towards AI assisted learning process. Structured questionnaire-based survey among the University students were done for this descriptive research. 409 responses collected were analysed with SPSS, Excel and Process Macro. It is found that the students’ Digital Literacy, Use of AI tools and PSCL on AI assisted learning were positively correlated. The partial mediatory path through the PSCL and AI tool usage has a significant positive influence on students learning process. The insights gathered from this study can inform educators, policymakers, and institutions on optimizing the amalgamation of digital literacy, AI tools and PSCL to enhance the contemporary learning environment. As universities navigate the digital age, this research provides a nuanced understanding of the dynamics shaping students' perceptions, offering valuable insights into the multifaceted aspects of AI influencing the educational landscape

Perhitungan Ongkos Pemesinan Konvensional Menggunakan Macro Vba Excel pada Studi Kasus (Produk Roda Gigi Payung Ø65mm × Z24)

In the conventional machining process, production costs are essential to know to determine the cost of making a product in any industrial manufacturing such as the SMK N 2 PEKANBARU machining workshop. Machining production costs are calculated based on machining time per product and machining operation costs. In calculating conventional machining costs, the VBA Excel macro is an application that can be used to calculate production costs. The Ø65mm × z24 umbrella gear product which is the research case study is a product that is machined by two conventional machining processes, namely lathe machining and milling machining. From the results of the research, the cost of conventional lathe machining, namely making gear wheels, is IDR 47,841/product, and the conventional milling process, namely making Z24 gears, is IDR 40,002/product, while the machining cost for lathe mastercam simulation is IDR 33,187/product and the machining cost for milling mastercam simulation is IDR 20,340/product. Machining costs are the product of operating costs per minute (cm) and machining time (tm). So, from the results of calculating machining and production costs, it is known that the product manufacturing costs or production costs for Ø65mm × Z24 umbrella gears are in the range of IDR 111,827 - IDR 146,143/product.

Developing a Cost-Effective Surgical Scheduling System Applying Lean Thinking and Toyota's Methods for Surgery-Related Big Data for Improved Data Use in Hospitals: User-Centered Design Approach.

Surgical scheduling is pivotal in managing daily surgical sequences, impacting patient experience and hospital resources significantly. With operating rooms costing approximately US $36 per minute, efficient scheduling is vital. However, global practices in surgical scheduling vary, largely due to challenges in predicting individual surgeon times for diverse patient conditions. Inspired by the Toyota Production System's efficiency in addressing similar logistical challenges, we applied its principles as detailed in the book "Lean Thinking" by Womack and Jones, which identifies processes that do not meet customer needs as wasteful. This insight is critical in health care, where waste can compromise patient safety and medical quality. This study aims to use lean thinking and Toyota methods to develop a more efficient surgical scheduling system that better aligns with user needs without additional financial burdens. We implemented the 5 principles of the Toyota system: specifying value, identifying the value stream, enabling flow, establishing pull, and pursuing perfection. Value was defined in terms of meeting the customer's needs, which in this context involved developing a responsive and efficient scheduling system. Our approach included 2 subsystems: one handling presurgery patient data and another for intraoperative and postoperative data. We identified inefficiencies in the presurgery data subsystem and responded by creating a comprehensive value stream map of the surgical process. We developed 2 Excel (Microsoft Corporation) macros using Visual Basic for Applications. The first calculated average surgery times from intra- or postoperative historic data, while the second estimated surgery durations and generated concise, visually engaging scheduling reports from presurgery data. We assessed the effectiveness of the new system by comparing task completion times and user satisfaction between the old and new systems. The implementation of the revised scheduling system significantly reduced the overall scheduling time from 301 seconds to 261 seconds (P=.02), with significant time reductions in the revised process from 99 seconds to 62 seconds (P<.001). Despite these improvements, approximately 21% of nurses preferred the older system for its familiarity. The new system protects patient data privacy and streamlines schedule dissemination through a secure LINE group (LY Corp), ensuring seamless flow. The design of the system allows for real-time updates and has been effectively monitoring surgical durations daily for over 3 years. The "pull" principle was demonstrated when an unplanned software issue prompted immediate, user-led troubleshooting, enhancing system reliability. Continuous improvement efforts are ongoing, except for the preoperative patient confirmation step, which requires further enhancement to ensure optimal patient safety. Lean principles and Toyota's methods, combined with computer programming, can revitalize surgical scheduling processes. They offer effective solutions for surgical scheduling challenges and enable the creation of a novel surgical scheduling system without incurring additional costs.

DIGITAL TOOLS FOR MATCHING QUALIFICATIONS TO THE LEVELS OF THE NATIONAL QUALIFICATIONS FRAMEWORK

Mutual compatibility of different national qualifications frameworks (NQFs) based on their compatibility with the European Qualifications Framework (or another international one) is crucially important for the effective recognition of qualifications between states. In turn, it depends on the quality of “filling” NQF levels with qualifications. Right comparing professional (occupational) qualifications with NQF level is a non-trivial problem for standard developers. The quality of any national system of qualifications depends on the comparability of qualifications with the level of the NQF so the comparison process should be strongly argued to secure the comparability. For qualification standard developers (especially for occupational standard developers) there were no strictly justified recommendations on how to compare qualification with the NQF level. Th. Saaty’s Analytic Hierarchy Process (AHP) is developed to resolve the problem of evidence-based comparing educational or professional (occupational) qualifications with the level of the National Qualification Framework (NQF). Research results give standard developers software tools based on a strong mathematical background to determine NQF level for developed standards. It is shown that Th. Saaty’s Analytic Hierarchy Process (AHP) is close to optimal for solving the problem of qualifications comparing and therefore looks like the best option for such methods. However, AHP demands non-trivial qualifications in mathematics and computing. The key problem resolved by this research is simplifying procedures to ensure effective access to the tool for qualification standard developers with minimal qualification in mathematics and computing. It is proven that each problem of qualification comparison with NQF level may be reduced to three options of decision. At the lower level of the decision-making process, there are 3-4 descriptors of qualification. Therefore, a user should be capable of forming at most four matrices of judgments and computing the main eigenvectors with some level of accuracy. The maximal dimension of matrices is four (for example it's true for the Ukrainian case). But for some national qualification frameworks that use only three descriptors maximal dimension of matrices equals three. Therefore, some simple approximation methods for eigenvector computing may be applied using only minimal means of Microsoft Excel or analogous applications. For the most general case of four NQF descriptors, Microsoft Excel macro is developed to secure achieving any level of accuracy. Corresponding API is developed by PHP programming language. Both Excel and API are accessible for users at the website of the Institute of Educational Analytics in Kyiv. The novelty of the article is that for the first time in national and international practice, it proposes an alternative/supplementary algorithmic method for determining the level of certain full and/or partial professional qualifications by the National Qualifications Framework, thus creating prerequisites for further automation of the activities of professional standards developers.

SISTEM INFORMASI RAWAT INAP PADA KLINIK HJ NINIK KUSTIANI SAMARINDA DENGAN MENGGUNAKAN MACRO MICROSOFT EXCEL

This research aims to find out how to design and create a Microsoft Excel Macro application in the information system at the Hj Ninik Kustiani Samarinda Clinic. The object of this research is the Hj Clinic. Ninik Kustiani Samarinda. Data collection techniques are field studies and library research. The analysis tool used is the Microsoft Excel Macro (VBA) program command. The research results show that this application can make it easier to input data, save data, edit data, delete data, cancel data input, and print reports according to clinic needs. So the use of an Information System using Macro Microsoft Excel provides great benefits, especially in helping integrated or computerized work processes at the Hj Ninik Kustiani Samarinda Clinic.

SISTEM INFORMASI APOTEK DARUL HAYYI MENGGUNAKAN MACRO MICROSOFT EXCEL

This study aims to find out how to design and create pharmacy applications using Microsoft Excel Macros at Darul Hayyi Pharmacy. The object of this research is Darul Hayyi Samarinda Pharmacy. Data collection techniques are observation, interviews, and literature studies. The analysis tool used is the Microsoft Excel Macros program. The results of this study show that by applying Microsoft Excel Macros to the pharmacy information system, it can provide several advantages such as facilitating work or activities related to the Darul Hayyi Pharmacy Information System, such as inputting master data, inputting over-the-counter drug sales activities and drug sales with a doctor's prescription, and purchasing drug supplies. The speed and accuracy of accessing data makes it easy to create the reports needed. And by using Microsoft Excel Macros can minimize errors that usually occur if done manually

Designing a Human Resource Productivity Model for the Deaf Sports Federation: A Combined Delphi-Fuzzy and Interpretive Structural Modeling Approach

Objective: The objective of this study was to design a human resource productivity model for the Deaf Sports Federation using a combined Delphi-Fuzzy and Interpretive Structural Modeling approach. Methods and Materials: The methodology of this research was mixed (qualitative and quantitative). Participants included managers and officials of committees within the Deaf Sports Federation of the Islamic Republic of Iran and elites in deaf sports, including coaches, referees, and athletes. The selection of these individuals was purposeful, based on criteria of expertise and experience, representation, diversity, and cooperation potential, with 18 individuals chosen. Data collection tools were a 41-question questionnaire and a 17x17 dimensional matrix, both validated for reliability and validity. Data analysis was conducted using Delphi-Fuzzy and subsequently Interpretive Structural Modeling. It is noteworthy that for these analyses, Excel macros and the SmartISM web program were utilized respectively. Results: Findings identified 17 determinant factors related to human resource productivity in the Deaf Sports Federation, which were categorized into five levels based on interpretive structural analysis, forming a hierarchical relationship model that indicates the fundamental factors in optimizing human resources in the Deaf Sports Federation are the alignment of authority-responsibility and organizational culture, which ultimately lead to an individual’s perception of their role. Conclusions: Accordingly, in planning to enhance human resource productivity in the Deaf Sports Federation, the initial step should involve establishing a balance of authority-responsibility and promoting values that assist employees in understanding their roles.

Macros in Excel

Excel itself has very powerful functions: including printing documents, file processing, formatting and text editing; Exl has a large number of built-in functions, its operation interface is very familiar to the public, and can connect to a variety of databases. Therefore, it has become a widely used application development platform. For a task that needs to be repeated frequently in Excel, you can record all the steps of executing these tasks in the macro and turn the macro into an automatically executable task. In this way, it is unnecessary to repeat the operation, save a lot of manpower and improve the work efficiency. Today, I will study the relevant knowledge of Excel macros with you.

Training and Assistance of Village-Owned Enterprises (BUMDES) Financial Reporting in Kekeri Village, West Lombok

Village-Owned Enterprises (BUMDES) Inti Sejahtera is located in Kekeri Village, Gunungsari, West Lombok, West Nusa Tenggara. It has three activity units, including a waste management unit, a development unit, and a trade unit. Of the three existing units, only the waste management unit operates adequately and generates regular income for BUMDes. BUMDes encounters issues in terms of financial management and preparing financial reports that are transparent and adhere to accounting principles. Transaction recording is still conducted manually, hence posing challenges in preparing the necessary financial reports. On the other hand, BUMDes funding comes from PADes, so BUMDes must provide financial reports to the village government as a form of accountability. This community service aims to resolve financial management limitations at BUMDes Inti Sejahtera by providing training and assistance to managers regarding the preparation of BUMDes financial reports. The method carried out is identifying problems in BUMDes (pre-training stage), then providing practical training and assistance in preparing financial reports according to accounting principles using the Microsoft Excel Macro application, which is adapted to BUMDES transaction accounts, as well as conducting evaluation reviews and monitoring of reports prepared by the manager. The outcome of this activity is that BUMDes managers acquire the capability to independently enter transactions and make account adjustments. Furthermore, the results suggest that BUMDes managers possess the necessary knowledge and skills to prepare financial reports in accordance with accounting principles by utilizing the Microsoft Excel macro-application. It can be concluded that BUMDes Inti Sejahtera managers can improve their accounting skills and use technological information to prepare and present BUMDes financial reports.

Social categorisation of asylum seekers: Free-listing by professionals in German reception centres

Abstract Background Newly arriving asylum seekers in Germany mostly live in large reception centres. Goods and services are provided by professionals. Their social categorisations may impact discretionary decisions and determine the scope of access to health and social services. We sought to explore what social categories were mostly applied to asylum seekers in that context. Methods We conducted a modified, verbal free-listing with health care, security, translation, social work and administrative staff in two German reception centres, asking what kind of asylum seekers were there. After qualitative content analysis, categories were quantitatively mapped using the Excel Macro “Flame” showing frequencies, ranks and salience of those social categories. Results 40 professionals listed on average 16 items (min = 4, max = 31). In total 624 items were analysed. Categorisations were of individual, interactional, professional, and societal nature. Professionally relevant categories like needs were not mentioned with the highest frequencies. The leading social categorisations of asylum seekers referred to asylum seekers attitudes professionals derived from their behaviour mostly in combination with socio-demographic variables, such as countries and regions of origin and sex. The most relevant social categories were “demanding and expectant” and “polite and friendly” behaviour, also the effort to adapt to the German environment was often evaluated. The category “economic refugees” ranked forth. Conclusions Social categorisation is permeable to public and political discourses related to motives for flight, or integration efforts and chances, impacting on negotiations of deservingness. Since categorisation structures perception, it potentially influences interaction and decision-making, it can trigger empathy and support as well as rejection and discrimination. Free-listing provides a suitable tool, to explore real world categorisation without leaning on pre-given social categories. Key messages • Public health studies on bias, racism and discrimination could benefit from free-listing as useful methodological tool to explore real world social categorisation without using pre-given categories. • Health sciences should foster awareness on political and societal discourses about migrant and minority populations seeping into professional cognition, which can trigger support or discrimination.

A Multi-Criteria Sustainability Assessment of Mediterranean Rainfed Farming Systems using the IDEA Method: A Moroccan Case Study

Sustainable agriculture in arid and semi-arid regions faces unique challenges that require targeted assessment and intervention. Addressing the knowledge gap in this context, the current study evaluates the sustainability performance of 50 rainfed farms in the Zaër Region of northwestern Morocco using the innovative &lt;em&gt;Indicateurs de Durabilité des Exploitations Agricoles&lt;/em&gt;/IDEA method (indicators of farming systems sustainability), which encompasses agro-ecological, social and economic criteria to assess the three pillars of sustainability. Customized assessment criteria and a tailored scoring system, specific to the region’s context, are employed, resulting in a comprehensive grid with 18 indicators across nine components. Data analysis and visualization were facilitated using statistical methods and an Excel macro. The findings reveal limitations in the sustainability of the surveyed farms. Socio-territorial factors, including issues with product quality, insufficient farmer training, limited workforce mobilization and low social involvement, contribute to the overall sustainability challenges. Agroecologically, low crop diversification, inadequate space management, and excessive reliance on chemical inputs are identified as areas of concern. On the economic scale, low specialization levels hinder economic viability despite some financial autonomy. The study emphasizes the need for interventions to enhance sustainability in rainfed agrosystems. Recommendations are provided to address socio-territorial constraints, improve agricultural practices, and promote economic viability. The findings have implications for policymakers, farmers and stakeholders, offering valuable insights for prioritizing strategies and actions to achieve sustainable agriculture in arid and semi-arid regions.

Improved analytical workflow for prompt gamma activation analysis

The analysis workflow of Prompt gamma activation analysis (PGAA) at the Budapest Neutron Centre’s PGAA and NIPS-NORMA facilities, at the MLZ FRM II PGAA station, and other centers worldwide relied on the use of the Hypermet-PC gamma spectrometry software and the ProSpeRo concentration calculation Excel macro. The sustained interest of our user community amid the reduced availability of multiple large-scale neutron sources worldwide called for more efficient utilization of the operational PGAA facilities. The present paper addresses both measurement and data evaluation bottlenecks of the analysis procedure to achieve higher productivity and superior spectroscopic performance.

Design Methodology of Off-Grid PV Solar Powered Systems for Rural Areas in Ecuador

Renewable technologies are a modern, clean form of energy with a very low environmental impact. They can become a viable option for energy generation, especially in rural areas of Ecuador, where the scarce access to electricity service limits the development possibilities of these areas. Solar energy is the resource used by off grid photovoltaic generation systems, which are used exclusively in rural areas because the installation of the electrical grid is costly or technically complex. In the Matlab/Simulink environment, off grid photovoltaic systems have been designed, which are composed of an array of photovoltaic modules, charge controllers, storage systems and single-phase inverters that together will allow knowing the behavior of electric power generation through solar photovoltaic energy. In addition, a maximum power point tracking (MPPT) algorithm was developed to obtain the peak power of the photovoltaic array and a discrete integral proportional control was incorporated for the charging and discharging of the batteries. Finally, a sizing tool was designed and developed through Excel Macros and Visual Basic, which facilitated the input of the different parameters and the obtaining of the results for the implementation of the photovoltaic systems.

Comparison of false positive and false negative rates of two indices of individual reliable change: Jacobson-Truax and Hageman-Arrindell methods.

Quantification of change is crucial for correctly estimating the effect of a treatment and for distinguishing random or non-systematic changes from substantive changes. The objective of the present study was to learn about the performance of two distribution-based methods [the Jacobson-Truax Reliable Change Index (RCI) and the Hageman-Arrindell (HA) approach] that were designed for evaluating individual reliable change. A pre-post design was simulated with the purpose to evaluate the false positive and false negative rates of RCI and HA methods. In this design, a first measurement is obtained before treatment and a second measurement is obtained after treatment, in the same group of subjects. In relation to the rate of false positives, only the HA statistic provided acceptable results. Regarding the rate of false negatives, both statistics offered similar results, and both could claim to offer acceptable rates when Ferguson's stringent criteria were used to define effect sizes as opposed to when the conventional criteria advanced by Cohen were employed. Since the HA statistic appeared to be a better option than the RCI statistic, we have developed and presented an Excel macro so that the greater complexity of calculating HA would not represent an obstacle for the non-expert user.

Designing a Macro-VBA Excel-based Kit List Printing Application for the Supporting Department of PT XYZ

The recording of raw material orders in PT.XYZ must be done through the embedded ERP system in the company, Microsoft Dynamics GP. However, the system is not perfect as it is not suitable for workers who follow traditional practices. To avoid losing goods, PT XYZ has started implementing kit recording, but a shortage of workers who enter KIT data can lead to human error. To overcome this, PT XYZ can automate the printing of KIT using VBA in Microsoft Excel. VBA allows applications to work more efficiently by easily manipulating object models. Excel macros support VBA programming and enhance the flexibility of the programming language. A well-organized VBA Excel application can produce a KIT list by pulling data from the production order sheet attached to the bus chassis as it moves on the production line. Once the specifications for a bus body to be produced are obtained, the user can edit and click one button to get the KIT that is suitable for that bus. Therefore, VBA in Excel can help PT XYZ improve the recording of raw material orders and reduce human errors that can cause financial losses.

Experimental study of compressor electric current detection for a split-type air conditioner affects energy savings

The paper presents an experimental study that aims to measure the compressor electric current of a split-type air conditioner for analyzing the various abnormal condition of the R-32 refrigerant pressure, especially for detecting compressor electric current while occurring dirt in the evaporator coil and condenser coil. The method was to install sensor devices to measure the temperature and humidity of inlet air and outlet air, and the velocity of the air outlet of the evaporator unit. In condenser unit was to measure the electric current compressor and electric power input. All data from sensors send to the Arduino board and using Parallax Data Acquisition (PLX-DAQ) Excel Macro for the record. The results show physical behavior and the changing of compressor electric current according to the abnormal condition of the refrigerant system, blocking of condenser and evaporator coil.

A Stochastic Simulator of a Multi-Component Distillation Tower Built as an Excel Macro

Dynamic process simulation is widely used in teaching controller design, as it allows foreseeing the performance of different control configurations and controller tunings. Currently, most college-level controller design exercises that are based on simulation consider deterministic perturbations (i.e. steps or ramps). In real life however, processes are more likely to face fluctuating, random disturbances, so the use of stochastic simulation in controller tuning exercises would provide students with an experience closer to their future professional practice than that provided by deterministic simulation. However, public institutions attempting to use dynamic, stochastic simulators in teaching, are hindered by the need of buying licenses of simulation packages or specialized programming languages (such as Matlab), as there aren´t any dynamic, stochastic simulators available as downloadable freeware. This paper shows a dynamic, stochastic simulator with a friendly interface of a distillation tower, developed as an Excel macro. This simulator has the advantage that it can be used at no cost to educational institutions since Excel is almost universally known and used by college faculties.

Wetlands estimation survey using DotS method: The case of Paya Indah Wetlands (PIW), Malaysia

Climate change poses a detrimental impact on the environment due to increasing carbon dioxide concentration in the atmosphere. In mitigating climate change, wetlands play a significant role in optimising the function of the earth's ecosystem for carbon sequestration and water resources rehabilitation. However, the effectiveness of wetlands management depends on an ecologically and statistically adequate dataset. Unfortunately, it is difficult for developing countries to implement area frame methods based on established sampling methods for data collection and monitoring. Thus, in this study, the dot sampling (DotS) method was adopted as it is simple, efficient, reliable and does not need a sample frame or high cost. DotS method uses the readily available platform, i.e., integration between Microsoft Excel-Macro (EM) and Google Earth (GE). This method systematically distributes the sample dots in GE's target area according to the locations generated by the EM. The field survey was then conducted at the sample dots of the target area in Paya Indah Wetlands (PIW) to ratify the site location. During the first stage, 72 dot sample locations were generated systematically, distributed across the target area, and 47 dot sample locations were located within the PIW. After the preparatory stage, 10 dot sample locations were eliminated. After the fieldwork inspection and evaluation, only 28 dot sample locations were selected as study stations. Hence, this study provides comprehensive data and examples applying the established DotS method with high reliability, accuracy, and rapidity in determining the number of study stations of wetlands. Based on the advantages, this study recommends the DotS method as a reliable survey method suitable for all study locations, especially in the ecology field. Applying the Dots methods as a surveying tool enables rapid land assessment in planning and suits the assessment of ex-mining constructed wetlands. K eywords: Climate change, constructed wetland, DotS method, estimation survey wetland, excel-macro, google earth