Spreadsheet Application Research Articles

Techno-Economic Analysis of Near-Infrared (NIR) Systems at Feed Millsas a Low-Cost, High-Speed Alternative to Feed Ingredient Testing

Improperly balanced diets not only impact the quality of animal production but also the profits of a livestock operation. Typically, the nutrient and chemical content of feed ingredients and forages are determined using well-established wet chemistry tests. However, these tests can be expensive and time-consuming. Moreover, the increasing use of various by-products which are known to have large variations in chemical and nutrient content warrants a real-time on-site feed and forage testing system. Near infrared (NIR) spectroscopy systems are quick and effective on-site testing tools. While NIR systems are being adopted for on-farm or at feed mill ingredient and forage testing, little is known about the economic impacts of such an investment for a livestock or feed mill operator. This study developed a baseline model and an Excel based spreadsheet application for performing Return on Investment (ROI) analysis to determine the feasibility of using an on-farm or at feed mill NIR testing system. ROI was calculated based on the nutrient cost saved or spent determined from the difference of estimated nutrient content and actual calculated value. The findings from this study will promote low-cost alternatives for onfarm or at feed mill ingredient testing, positively impacting quality of animal products and minimizing costs.

Implementation of Business Intelligence for Analysis Data of Drug Sales Using Exploratory Data Analysis (EDA) and Visualization Data Using Looker Studio

This study aims to analyze pharmaceutical sales performance by leveraging big data and advanced information technology tools, providing insights for improved business strategies. Using the Exploratory Data Analysis (EDA) method, the study processes raw sales data through spreadsheet applications to identify key patterns and trends. The findings are then visualized with Looker Studio on an intelligent dashboard tailored to the needs of the marketing team. The dashboard enables quick, data-driven decision-making by displaying performance metrics and trends relevant to sales and marketing strategies. The results reveal critical insights into sales behavior, including high-performing products, regional sales variations, and temporal sales trends. The analysis equips the marketing team with actionable data to refine their strategies, prioritize product focus, and adjust marketing efforts in response to identified patterns. In conclusion, the use of EDA and data visualization provides a structured approach to big data interpretation, allowing the company to optimize business and marketing performance. The study underscores the potential of data-driven dashboards to enhance strategic planning, suggesting broader applications in various data-intensive business environments.

Use of Artificial Intelligence tools in supporting decision-making in hospital management

BackgroundThe use of Artificial Intelligence (AI) tools in hospital management holds potential for enhancing decision-making processes. This study investigates the current state of decision-making in hospital management, explores the potential benefits of AI integration, and examines hospital managers’ perceptions of AI as a decision-support tool.MethodsA descriptive and exploratory study was conducted using a qualitative approach. Data were collected through semi-structured interviews with 15 hospital managers from various departments and institutions. The interviews were transcribed, anonymized, and analyzed using thematic coding to identify key themes and patterns in the responses.ResultsHospital managers highlighted the current inefficiencies in decision-making processes, often characterized by poor communication, isolated decision-making, and limited data access. The use of traditional tools like spreadsheet applications and business intelligence systems remains prevalent, but there is a clear need for more advanced, integrated solutions. Managers expressed both optimism and skepticism about AI, acknowledging its potential to improve efficiency and decision-making while raising concerns about data privacy, ethical issues, and the loss of human empathy. The study identified key challenges, including the variability in technical skills, data fragmentation, and resistance to change. Managers emphasized the importance of robust data infrastructure and adequate training to ensure successful AI integration.ConclusionsThe study reveals a complex landscape where the potential benefits of AI in hospital management are balanced with significant challenges and concerns. Effective integration of AI requires addressing technical, ethical, and cultural issues, with a focus on maintaining human elements in decision-making. AI is seen as a powerful tool to support, not replace, human judgment in hospital management, promising improvements in efficiency, data accessibility, and analytical capacity. Preparing healthcare institutions with the necessary infrastructure and providing specialized training for managers are crucial for maximizing the benefits of AI while mitigating associated risks.

Information System for Payment of Dues and Savings at SMA Negeri 1 Cibungbulang School Based on WEB

SMA Negeri 1 Cibungbulang, in recording Student Dues and Savings, still uses a spreadsheet application, where transaction recording use spreadsheet application has identified four cases that were complained of by the school administration: first, when recording payment transaction data, there was still an error in data input; secondly, when created the recapitulation report is still less effective and efficient; third when entering the school year the school Administration needs to re-create spreadsheet pages to separate old and new data; fourth transaction data is still prone to be scattered due to manual storage. Because of this, we need a better alternative to managing student finances so that it can be more effective and efficient. This study aims to analyze, design, and build a WEB-based Information System for Student Dues and Savings at SMA Negeri 1 Cibungbulang. The results obtained can improve the performance of the school administration in managing school finances. The system development method used is the waterfall model, which consists of four steps: Requirement Analysis and Definition, System and Software Design, Implementation and Unit Testing, Integration and System Testing. The results of this study obtained an information system that can manage information consisting of student data, class data, monthly dues data, savings, and recapitulation reports with automatically generate recapitulation reports also present a user-friendly user interface design so that errors in payment input and calculating the number of months in one semester do not occur. This information system is aimed at School Treasurer Staff, School Treasurer, and the Principal.

Optimizing Accounting for Amplang MSMEs in Ketapang through the Implementation of MSME Financial Accounting Standards using Google Spreadsheet

This article explores the optimization of accounting practices for Amplang Micro, Small, and Medium Enterprises (MSMEs) in Ketapang through the implementation of MSME Financial Accounting Standards (SAK EMKM). Leveraging the capabilities of Google Spreadsheet as a versatile application, this study focuses on streamlining financial reporting processes for MSMEs. The application of Google Spreadsheet allows for the automated input of journal transactions and initial balances, ensuring the validity of financial information. The results demonstrate that the utilization of spreadsheet applications enhances the practicality and ease of financial report preparation, particularly tailored for small and medium-sized enterprises like Amplang MSMEs. This research contributes valuable insights into the efficient integration of technology in accounting practices, fostering financial management improvements for businesses at the micro, small, and medium scales.

To Abstract or Not to Abstract? A Comparative Study Evaluating the User Experience of Spreadsheet Programming with Sheet-Defined Functional Abstractions

Spreadsheets are a widespread functional programming paradigm that offer liveness and directness of interaction. However, spreadsheets are notoriously error-prone and difficult to debug. To overcome this limitation and improve the expressive power of spreadsheets, we propose an extension to the spreadsheet paradigm in the form of sheet-defined lambdas – user-defined functions that abstract computations on the sheet. This concept was developed and deployed in our web-based spreadsheet application named Lattice. We evaluate this approach through a user study which compared the user experience of programming in a spreadsheet with and without lambdas, as well as the difference in performance between learner (N = 12) and experienced (N = 12) programmers. The study measured participant task performance (task time, success rate and number of errors) and the quality of their user experience of using Lattice (video recordings of use, interviews and questionnaire responses). Our findings indicate that programming with lambdas is not only more efficient than writing formulas in a conventional way, but also provides a rewarding hedonic experience. However, we found that learners perceived the concept of functional abstractions with lambdas as difficult to comprehend; while experienced programmers noted potential utilitarian advantages that aid in managing the complexity of a spreadsheet program. The results obtained in this work contribute to a better understanding of human-spreadsheet interaction and can inform the future design of user-friendly computational systems.

Effectiveness of Information Technology Utilization

Information technology allows offices to manage information and communication more effectively and efficiently. By using information technology, offices can optimize the data management process. This study aims to determine the effectiveness of the use of information technology in employees of PT. Midi Utama Indonesia Tbk Makassar, and to find out the supporting and inhibiting factors for the effectiveness of the use of information technology in employees of PT. Midi Utama Indonesia TBk Makassar. This research uses a qualitative method, therefore in order to achieve a research objective, data collection techniques are used, namely observation, interviews, and documentation. The informants of this research were 5 employees of PT. Midi Utama Indonesia Tbk Makassar. The results of this study show that the effectiveness of the use of information technology in employees of PT. Midi Utama Indonesia Tbk Makassar can be seen from the indicators that hardware, software and brainware are "effective". It can be seen from the aspect that the hardware that uses a computer is adequate with good quality so that it is very helpful for employees in supporting office activities. From the aspect of software used to process data, including processing, compiling, and storing data, it is quite flexible in supporting the work in the office, one of the applications used is a spreadsheet data processing application that produces relevant, accurate and timely information. From the human aspect (brainware) of human resources in the office of PT. Midi Utama Indonesia Tbk Makassar stated that the technology component is very important in carrying out the development of the use of information technology and all the devices that have been provided. The supporting factors of information technology are information systems that utilize information technology to facilitate the management of various forms of facilities and infrastructure as well as information technology that makes it easier for employees to carry out their individual needs, while the factors that hinder the use of information technology are several problems that are often faced including high dependence on information technology, incompatibility with business processes, regulatory readiness, procedures, and limitations of human resources, information technology is often not supported by an effective management system and work process, as well as limited human resources.

MetaAnalysisOnline.com: A new easy-to-use bioinformatic tool for the meta-analysis of clinical trials.

e23012 Background: A meta-analysis is a formal, quantitative study design in epidemiology and clinical medicine that systematically assesses and consolidates previous research findings to derive comprehensive conclusions on a specific topic. Here, we aimed to establish a new tool for the visualization options useful for conducting a meta-analysis specifically designed for oncology trials. Methods: A meta-analysis can be based on binary data, continuous data, or time-to-event data. The most crucial statistical models, including the random effect model and the fixed effect model, are outlined alongside their respective statistical methods. Furthermore, we implemented graphical representations such as the forest plot, funnel plots, and Z-scope plots. While the forest plot effectively illustrates heterogeneity and pooled results, a funnel plot can reveal potential publication bias, and a Z-score plot shows the robustness of the used sample number. Results: The models and visualization options outlined have been integrated into a new, online web portal which can be accessed without the need for registration. The web application operates on an Ubuntu server running Apache and enables users to conduct meta-analyses using results typically used in oncology trials including binary (total and event numbers), continuous (mean and standard deviation data), and time-to-event data (hazard rate and CI data). Study results from common spreadsheet applications like Excel can be directly input into the system. The online platform utilizes the meta and metafor packages in the R programming environment (R version 4.2.2) for calculations and plots. The Shiny user interface is powered by shinyjs, shinydashboard, and rhandsontable R packages. The portal generates a forest plot to summarize meta-analysis results, a funnel plot for visual detection of potential bias, and a Z-score plot showing the sufficiency of the cumulative sample number. The analysis results of the tool were validated using IBM SPSS v28. The new bioinformatic tool is available at www.metaanalysisonline.com and requires no programming knowledge or command line use. Conclusions: Our platform aims to provide a user-friendly meta-analysis tool for epidemiological studies and oncology clinical trials, offering a swift and reproducible way to integrate the results from multiple studies.

Rancang Bangun Sistem Monitoring Cuaca Berbasis Google Spreadsheet Untuk Nelayan Di Wilayah Pesisir Pantai

Coastal areas are vital areas for fishing activities, and the weather in this area plays a very important role in the safety and efficiency of fishermen's operations. Fishermen on the coast often face the challenges of weather that is changeable and can be very extreme, including strong winds that can cause high waves and unsafe sea conditions. Therefore, the development of a Google spreadsheet-based weather monitoring system for fishermen in coastal areas is very relevant and strategic to support safer and more productive fishing activities. This research aims to make it easier for fishermen to monitor the weather in coastal areas in real time. Testing is carried out by running the system for observation for a predetermined time duration. This research uses an anemometer, DHT11 and raindrop sensors connected to a NodeMCU ESP32 microcontroller to send data to a Google spreadsheet, with readings of wind speed, temperature, air humidity and rain values. This research was carried out at the Nusantara Prigi fishing port, Trenggalek, challenging the work of anemometer sensors, DHT11 and raindrop sensors. Testing of tools and data obtained by comparing data on wind speed, temperature and air humidity using a digital anemometer and digital thermometer hygrometer humidity. The results of this research are that a Google spreadsheet-based weather monitoring design for fishermen in coastal areas can monitor wind speed, air humidity, temperature and detect rain online using a spreadsheet application and functions well with an average error accuracy of 3%.

Game changer: Cloud‐based classroom interactions powered by Google Sheets

AbstractThe COVID‐19 pandemic forced instruction into remote formats, rendering active learning efforts in business classrooms infeasible. In response, we adopt a novel model for interactive classroom activities by hosting classroom games on Google Sheets, the free and widely used cloud‐based spreadsheet application. First developed for a synchronous Zoom class during the COVID‐19 pandemic, this approach was integrated into face‐to‐face courses in two countries. Due to its instructional flexibility, minimal need for resources, and tendency for student acceptance, using Google Sheets for classroom interaction has far‐reaching educational applications beyond the pandemic era. To illustrate this approach, we introduce three operations and supply chain management activities created on Google Sheets: the Virtual Assembly Line (VAL) activity, the Just‐in‐time Game, and the Dice Game. An in‐depth examination of implementing these activities in the classroom offers practical insights into the benefits of utilizing cloud‐based classroom games in teaching. Furthermore, a comparison of test results between students who played the game and a control group showed significantly improved learning outcomes. We also discuss how this approach could foster active learning adoption in environments traditionally less conducive to such practices, such as remote instruction and large enrollment classes.

THE IMPACT OF EDUCATIONAL STAKEHOLDERS' ATTITUDES ON STUDENTS' ACADEMIC AND CAREER INTERESTS IN CERAMICS WITHIN THE KUMASI METROPOLIS, GHANA

Educational programmes whether vocational or not have the potential to shape students to be able to give back to their societies. Unfortunately, some attitudes of players of education can affect students so much to dampen their self-efficacy and interest in Ceramics education. This study investigated some educational stakeholders' and their attitudes that can possibly have negative impact on students' academic and career interest in Ceramics within the Kumasi Metropolis, Ghana. Three schools offering Ceramics in the metropolis were purposively selected. They consisted of one mixed-gender, one boys-only, and one girls-only schools. The study was exploratory research and adopted the QUAN+Qual mixed-methods triangulation to conduct the investigation. Data was concurrently gathered using questionnaire, interviews and observation. 273 participants, including students, teachers, schools’ heads and parents were sampled from the three selected schools. Four Likert scale questionnaire and “Yes or ‘No’ data type was employed where SPSS v24, excel spreadsheet applications as well as frequencies and percentages (descriptive statistical techniques) helped to simplify and interpret the data. The study's findings revealed that educational stakeholders such as parents, students and their peers, teachers and schools’ managers put up behaviours that discourage students’ interest in Ceramics. The study found that low employment opportunities in Ceramics is the primary reason why parents, students, and teachers discourage students’ academic and career interest in Ceramics. The study also conducted a chi-square to establish whether the age, programme and level in school had any correlation with their believe that there is a low employment opportunity in Ceramics. The results found that the level of students alone to have significant correlation with p>0.000.

Smart Soil Moisture Control Based on IoT ESP-32 for Horticulture Cultivation in Coastal Area

Optimal and effective use of water in coastal areas is an essential aspect of plant growth in horticulture and the maintenance of water availability. It is necessary to monitor soil moisture continuously as the basis for watering time. However, it is hard for farmers to be in the field frequently to monitor the land humidity, even using an instrument to measure it at the site. It is needed a monitoring technique that can control the land humidity remotely. This paper presents a design of wireless soil moisture measurement based on the Internet of Things. We applied capacitive soil moisture sensors coupled with an ESP32 WIFI with a built-in 12-bit ADC function for reading analog sensor output and establishing a wireless connection to the internet network. The ESP32 was programmed using Arduino software. We made a web-based user interface and Google spreadsheet application using the Nodered which is a programmable IoT platform to show soil moisture and control the irrigation sprayers through the pump.

Development of Practicum Assessment Rubric Assisted by Google Spreadsheet in Basics Electronics Material

The implementation of practicum assessment rubrics in the Physics Education Laboratory of UIN Alauddin Makassar has fallen short of its full potential. Thus, it is critical to develop a standardized rubric. The practicum assessment rubric is utilized to assess the proficiency of students during their practicum. This research aims to (1) describe the procedure for developing a practicum implementation assessment rubric for Basic Electronics courses with the assistance of the Google Spreadsheet application; and (2) describe the quality of the practicum implementation assessment rubric based on validity and practicality for Basic Electronics courses with the assistance of the Google Spreadsheet application. The utilized development model is Tessmer's formative research model, which comprises two stages: preliminary and formative evaluation. The formative evaluation stage incorporates self-evaluation, prototyping (including expert reviews, one-on-one, and small group), and a field test. This research was conducted at the Physics Education Laboratory of UIN Alauddin Makassar. The research subject comprised two individuals: the main subject and the trial test subject. The main subject comprised two individuals who subsequently formed the product validator team. The trial test subject comprised seven individuals who were employed as assistants for the Electronics practicum in 2022/23. The research results indicated that the validity of the developed product is deemed valid with the validity value of 1. Based on the practicality analysis results, which indicated that 29% of users provided practical responses and 71% provided very practical responses regarding the developed products, it can be inferred that the developed assessment rubric satisfied the practicality criteria. The results of this study suggest that the developed assessment rubric facilitates the assessment administered by the practicum assistants. Additionally, the developed assessment rubric is applicable to all practicum titles pertaining to Basic Electronics.

Assessment of Computer Literacy of the College Faculty of Nueva Ecija University of Science and Technology Gabaldon Campus

This study aimed to assess the computer literacy levels of the college faculty of Nueva Ecija University of Science and Technology – Gabaldon Campus. A total of 36 instructors from multiple non-computing departments participated in the study. The researcher assessed the levels in terms of computer skills, software use, and routine computer use. The study utilized the descriptive method of research using survey questionnaires that has six parts: general operations of computers, communication and internet, word processing, spreadsheet, graphics, and general technology application. After collecting the data needed, the data were tabulated, analyzed, and interpreted. The findings showed that the college faculty of the Nueva Ecija University of Science and Technology- Gabaldon Campus have limited skills in regards to general computer applications, communication, and the internet but are very proficient with word processing and spreadsheet. Moreover, the study found evidence that there should be a professional development training programs for instructors to incorporate computer technology as a classroom tool and means of managing instruction.

A Prototype Development of a Mobile Schedule Viewer Integrating QR Code Technology and Decorator Design Pattern for Effective Dissemination of Class Schedules

Class schedules undergo continuous changes with each new release, making manual scheduling a complex task. To address this issue, this study proposes integrating a mobile application that enables students to promptly access their accurate class schedules. A prototype mobile schedule viewer was developed to identify and resolve conflicts arising from conflicting schedules. The study confirmed the functionality and stability of the spreadsheet application, as the mobile schedule viewer successfully employed the decorator design pattern and integrated QR code generator plugins. These plugins facilitated the extraction of existing schedule files from the University Integrated Information System (UIIS). The overall findings indicate that the applications are 95 percent complete in terms of degree of completeness (DOC) and boast a record level of accuracy (RLA) of 95 percent.

Pelatihan Praktis Menggunakan Aplikasi Spreadsheet untuk Pembuatan dan Pengelolaan Nilai Raport

Training on optimizing number processing applications for creating and inputting report cards at Bina Madina Denpasar Vocational School is an initiative aimed at improving teachers' skills in effectively utilizing spreadsheet applications. This training began with socialization activities which included presenting the training objectives, opening a space for dialogue to evaluate participants' expectations, and conveying the training schedule and materials. The training process includes presentation sessions, demonstrations and practical exercises, focusing on optimizing the use of number processing applications to compile and manage report cards efficiently. Evaluation is carried out to measure participants' understanding, involving written exams, reflection sessions, and satisfaction questionnaires. Monitoring is carried out post-training to monitor the application of participants' skills in daily activities, with analysis of report card results, online monitoring sessions, and ongoing evaluation. This training aims to create a modern and efficient learning environment, ensure that teachers can provide report cards accurately and effectively, and stimulate innovation in managing grades in the educational environment.

Is this an e-School? e-Learning Using Information Communication Technologies in South Africa

The study reported on in this paper reviewed the readiness of a specific high school in the township of Soweto to the south of Johannesburg, South Africa, to deliver the curriculum by using Information and Communication Technologies (ICTs), as well as to find the barriers and limitations thereto. For the empirical research, a quantitative mode of inquiry was adopted. A sample of learners and teachers was selected to answer the research questions, using two different questionnaires. The principal responded to a questionnaire on the ICT infrastructure available to establish what the school had in this regard, as well as the skills available to implement pedagogy using ICTs. Data analysis was carried out using a common spreadsheet application and multiple criteria, and the findings are discussed to provide value to, and should be of use to, the stakeholders involved for development purposes. The work discussed in this study covered curriculum topics, as well as lesson planning and reporting. In other words, it covered the process of teaching and learning up to reporting for teachers. A summary of the findings of the research conducted at the high school showed that the school does not have a stable internet connection and more technical support is needed from the government to strengthen the ICT infrastructure to enable the school to fully implement the curriculum using ICTs, compared to using traditional or hybrid methods. These strengthening recommendations include a stable internet connection, ICT staff, to support both e-teachers and e-learners with ICT problems, as well as software to deliver the curriculum. The findings also showed that learners are more comfortable with mobile devices and a little uncomfortable using computers for learning, which means that some aspects of e-learning requirements are not met, and it is very difficult to achieve some of the curriculum goals using mobile devices.

Technique for preparation of large data for machine learning algorithms to generate intrusion detection system

Machine Learning has become the norm for creating models that predict and detect security breaches in computer systems. Modelling of machine learning systems requires a huge amount of data for training and testing the machine learning algorithm. The present research is concerned with preparing the data prior to feeding it to machine learning algorithms. The necessity for such preparation occurs due to the physical limitations of spreadsheet applications (with regard to the number of records they can handle). This research describes a simple shell scripting approach to combine, extract, and weed out unwanted records and finally prepare the data for feeding to machine learning algorithms.

Training in academic information system usage at Ash Shidiq Integrated Islamic Junior High School

Ash-Shidiq Foundation recently established the Integrated Islamic Middle School (SMP IT). Currently, the school manages academic data manually, either on paper or through spreadsheet applications. Recognizing an opportunity, the Telkom University Software Engineering Expertise Group decided to provide community service by implementing a web-based academic information system for the school. This system is hosted on a server accessible via the Internet, enabling staff, teachers, and students to access it. It aims to simplify academic data reporting for school managers. The entire community service project, from initial observation to system installation, training, video documentation, and final report preparation, spanned approximately six months. Training sessions were conducted in a classroom setting for school principals, staff, and teachers. Feedback from this community service activity showed that 25% strongly agreed, 37.5% agreed, and 37.5% were neutral regarding the suitability of the training material to partners' needs. Regarding the presentation of material, 75% strongly agreed, 25% agreed, and 50% were neutral, with 37.5% in agreement and 12.5% in disagreement about the usefulness of the technology offered.

Design of a Web-Based Petty Cash Accounting Information System at Otoritas Jasa Keuangan (OJK) Regional Office 2 of West Java

The rapid development of technology makes it easy for a company to get information. One is at Otoritas Jasa Keuangan (OJK) Regional Office 2 of West Java. One of the problems found is in the process of processing accounting data which is still done manually using the Spreadsheet application, so a Web-Based Accounting Information System is designed, with the software development method used namely a waterfall with the Unified Modeling Language (UML) modeling system tools. While the PHP programming language and MySQL database. This research produces an information system integrated into recording cash and preparing company cash reports. This accounting information system's design allows petty cash records to be managed effectively and efficiently.