excel format
Recently Published Documents


TOTAL DOCUMENTS

24
(FIVE YEARS 16)

H-INDEX

0
(FIVE YEARS 0)

Author(s):  
Prof. Roshan R. Kolte

Abstract: Now a days we are living in this world where everything is automated and linked online. Internet are the things discover and it is used all over a world very beneficially.in human body face is the crucial factor for identifying each person. It can be identified by using different method like biometric for taking attendance. But in this method many more time are required to take attendance and also people are in contact with each other while marking their attendance in this pandemic situation we are introducing new technology student attendance system using face reorganization. Generally in a classroom the attendance was taken manually at ending or beginning of the class. The problem is that they required a lot of time to be taken and some manual and paper work will make a chance of mistake. To overcome from this problem we are introducing face recognition base attendance system. It is used in many application for identification of human face in a digital image or live video stream video. The proposed system make used of Haar classifier, KNN, CNN, SVM and global filters. After this recognition attendance report will be generated in excel format. The overall accuracy and complexity are calculated after testing this system it is cost efficient and need less installation time. Keywords: Face recognitions, Face detection, Haar classifier, CNN, KNN, SVM, LBPH, Automatic Attendances and image processing.


2021 ◽  
Vol 2 (4) ◽  
pp. 5593-5605
Author(s):  
Jazmín Apolo- Romero ◽  
Víctor Javier Garzón Montealegre ◽  
Jessica Quezada Campoverde ◽  
Eveligh Prado Carpio

En el presente artículo, el objetivo de esta investigación es indagar la influencia de la inteligencia de negocio para la toma de decisiones en los asociados de la empresa Bananera Fincas de El Oro. Uno de los activos más importantes de la empresa es el manejo de información, esto ha llevado a la proliferación y utilización de software y almacenes de datos. Por esta razón, la Inteligencia de negocio puede generar inteligencia de sus datos, mediante la captura, extracción, filtrado y modelado de la información. Las herramientas tecnológicas para el desarrollo de la inteligencia de negocios han evolucionado satisfactoriamente en los mercados empresariales, empresas agropecuarias a nivel global. En la investigación se aplicó un diseño no experimental y de enfoque mixto. Los cuestionarios aplicados fueron sometidos a un control de calidad, para proceder a codificar y transcribir los datos en formato Excel, donde se utilizó métodos estadísticos para verificar los resultados, mismo fueron exportados y procesados a través del programa SPSS v. 24 aplicando un análisis estadístico inferencial el cual arrojó como resultado que existe una influencia positiva fuerte con un 92.3% entre la variable inteligencia de negocio y la variable toma de decisiones. Por este motivo es oportuno implementar un Software de inteligencia de negocio en el área de producción de la empresa como instrumento para el análisis de grandes volúmenes de datos. En este sentido el estudio desarrollado en inteligencia de negocio para la toma de decisiones responde a la necesidad planteada desde el análisis de la demanda.   In this article, the objective of this research is to investigate the influence of business intelligence for decision making in the associates of the company Bananera Fincas de El Oro. One of the most important assets of the company is the management of information, this has led to the proliferation and use of software and data warehouses. For this reason, business intelligence can generate intelligence from its data, by capturing, extracting, filtering and modeling information. Technological tools for the development of business intelligence have evolved satisfactorily in business markets, agricultural companies at a global level. A non-experimental design with a mixed approach was applied in the research. The questionnaires applied were subjected to a quality control, to proceed to code and transcribe the data in Excel format, where statistical methods were used to verify the results, which were exported and processed through the SPSS v. 24 program applying an inferential statistical analysis which showed as a result that there is a strong positive influence with 92.3% between the variable Business Intelligence and the variable Decision Making. For this reason it is appropriate to implement a business intelligence software in the production area of the company as an instrument for the analysis of large volumes of data. In this sense, the study developed in business intelligence for decision making responds to the need raised from the demand analysis.


2021 ◽  
Vol 2 (4) ◽  
pp. 5579-5592
Author(s):  
Katherine González-Cruz ◽  
Jessica Quezada Campoverde ◽  
Hector Ramiro Carbajal Romero ◽  
Salomón Alejandro Barrezueta Unda ◽  
Ángel Eduardo Luna Romero

En el presente artículo, el estudio de los perfiles socioeconómicos de los agricultores en Ecuador es escasos, por esta razón, la presente investigación busca como objetivo describir el análisis socioeconómico de la Asociación Fincas de El Oro en la implementación de la certificación Globalgap de los productores bananeros durante el periodo 2015-2019. La población estuvo conformada por los 45 asociados, los cuales respondieron un cuestionario estructurado por preguntas cerradas, que conforman los indicadores sociales, económicos. En la investigación se aplicó un diseño no experimental y de enfoque mixto. Los cuestionarios aplicados fueron sometidos a un control de calidad, para proceder a codificar y transcribir los datos en formato Excel, donde se utilizó una estadística descriptiva para verificar los resultados. Los resultados alcanzados establecen en general, en el rango de edad de los agricultores masculino se evidencian una gran participación existen de 45 hasta 56 años que se dedican a la producción de banano, mientras que el género femenino se observan intervalos de 69 hasta 82 años. Los asociados de Machala y Arenillas cuentan con mayores estudios en Secundaria y Universitaria. La mayoría de los asociados contestaron que no disponen de energía eléctrica, agua potable y telefonía fija. Se evidencia que más de la mitad de los trabajadores cuentan con seguro social. Una mayor productividad entre los asociados es Machala, en comparación con Arenillas, Santa Rosa y El Guabo. Siendo productores de la ciudad de Pasaje con menores ingresos a 2000 dólares americanos y productividad por hectárea de 1285 cajas/año.   In this article, the study of the socioeconomic profiles of farmers in Ecuador is scarce, for this reason, this research aims to describe the socioeconomic analysis of the Fincas de El Oro Association in the implementation of the Globalgap certification of banana producers during the period 2015-2019. The population consisted of the 45 associates, who answered a questionnaire structured by closed questions, which made up the social, economic indicators. The research applied a non-experimental design and a mixed approach. The questionnaires applied were subjected to quality control, in order to proceed to code and transcribe the data in Excel format, where descriptive statistics were used to verify the results. The results obtained establish that in general, in the age range of the male farmers, there is a high participation from 45 to 56 years of age who are engaged in banana production, while in the female gender there are ranges from 69 to 82 years of age. The associates from Machala and Arenillas have more secondary and university education. The majority of the members answered that they do not have electricity, potable water or landline telephony. It is evident that more than half of the workers have social security. A higher productivity among the associates is Machala, compared to Arenillas, Santa Rosa and El Guabo. Producers in the city of Pasaje have a lower income of 2000 US dollars and productivity per hectare of 1285 boxes/year.


2021 ◽  
Vol 6 (1) ◽  
pp. 25-30
Author(s):  
Bayu Suryo Wiranto ◽  
Muhammad Rif’an ◽  
Massus Subekti

This research aims to create a design model of microhydro powerplant, and implement that design model to particular location, which decided location in this research is Cigeuntis Waterfall. Output of this research can be utilized by microhydro power plant practitioners as a tool, and stakeholders to valuing natural resources potential in their area. Cigeuntis Waterfall is selected because it has sufficient water in raining season, and more important, in dry season. Analysis descriptive method is used in this research with qualitative approach. Technics of Engineering is type of this research, encompassing design formulation of microhydro power plant, formula validation by comparing design of microhydro power plant based on formula with existing microhydro power plant in PLN Laboratory, and designing microhydro power plant components like intake, settling basin, penstock pipe, turbine, pulley, and generator regarding water flow and net head of Cigeuntis Waterfall. Results of this research are if microhydro power plant build at Cigeuntis Waterfall with 0.55 m3/s water flow and net head is 25 m, the size of components must be 2.97 m2 for intake, 6.6 m x 0.83 m x 2.2 m for settling basin, 48 cm for penstock diameter and 0.17 cm for its thickness, 11.81 inch for turbine diameter and 3.8 inch for its length, 2.1 inch for blade turbine space, 18 blades turbine needed, 11.81 inch for pulley diameter which connected to turbine and 5.2 inch diameter which connected to generator, and capacity of generator is 104.1 kW. This formula created in Microsoft Excel format, and after validation with existing microhydro power plant, there is not any substantial difference as the result. Therefore, the conclusion is this design model of microhydro power plant able to be implemented.   Abstrak Penelitian ini bertujuan untuk menghasilkan model perancangan PLTMH, dan mengimplementasikannya pada lokasi tertentu, yang pada penelitian ini ditetapkan lokasinya adalah Curug Cigeuntis. Model perancangan ini nantinya bisa digunakan oleh para perancang PLTMH sebagai observasi awal, dan juga digunakan oleh para pemangku kebijakan dalam melihat potensi sumber daya alam di daerahnya. Curug Cigeuntis dipilih menjadi lokasi pengujian sebagai contoh implementasi yang dari model perancangan yang dibuat karena ketersediaan air di sana boleh dikatakan tinggi akibat curah hujan yang besar. Penelitian ini menggunakan metode deskriptif analisis melalui pendekatan kualitatif. Jenis penelitian yang dipilih ialah rekayasa teknik dengan mencangkup pembuatan formulasi perancangan PLTMH, validasi formulasi perancangan PLTMH dengan acuan sistem PLTMH yang terpasang pada Laboratorium Tenaga Air Mini milik PLN, dan perancangan b agian PLTMH, yaitu saluran intake, bak penenang, pipa penstock, turbin, pulley, dan generator mempertimbangkan kondisi alam seperti debit air dan tinggi jatuh air pada Curug Cigeuntis. Hasil penelitian menunjukan bahwa Curug Cigeuntis dengan debit andalan sebesar 0.55 m3/s dan tinggi jatuh air sebesar 25 m, diperoleh ukuran intake 2.97 m2, ukuran bak penenang 6.6 m x 0.83 m x 2.2 m, ukuran diameter penstock 48 cm dan ketebalannya 0.17 cm, ukuran diameter turbin 11.81 inch dengan panjang 3.8 inch, jarak antara pisau 2.1 inch, dan jumlah pisau turbin sebanyak 18 buah. Ukuran pulley besarnya pada bagian diameter terhubung turbin adalah 11.81 inch dan diameter terhubung generator 5.2 inch. Kapasitas generator yang digunakan sebesar 104.1 kw. Formulasi perancangan yang dibuat menggunakan program Microsoft Excel, telah divalidasi dengan sistem PLTMH terpasang dan tidak didapati perbedaan yang substansial sehingga dapat disimpulkan perancangan PLTMH layak untuk diimplementasikan pada perancangan tertentu.


2021 ◽  
Vol 6 (1) ◽  
pp. 42
Author(s):  
Urip Pratama ◽  
Nurmaini Nurmaini ◽  
Roymond Halomoan Simamora

Latar Belakang: Diagram Pareto merupakan salah satu alat ukur mutu untuk menganalisis pengelolaan bahan habis pakai sehingga menjadi hal penting bagi rumah sakit. Hal ini dipengaruhi juga dengan pengetahuan dan minat perawat yang rendah, bukan hanya karena fasilitas yang tidak memadai tetapi karena pengaruh minimnya informasi tentang pentingnya pengelolaan bahan habis pakai tersebut.Tujuan: Mengetahui pengaruh sosialisasi diagram Pareto terhadap pengetahuan dan minat perawat dalam pengelolaan bahan habis pakai.Metode: Metode eksperimen semu dengan pre-posttest dengan kelompok kontrol. Sampel penelitian 100 perawat pelaksana di Rumah Sakit Daerah Provinsi Aceh, yang dibagi menjadi kelompok intervensi (n=50) dan kelompok kontrol (n=50), dengan menggunakan teknik consecutive sampling. Pengetahuan perawat diukur menggunakan lembar observasi dan kuesioner penggunaan diagram Pareto, Microsoft Excel Format 2 Axis dan klasifikasi bahan habis pakai, sedangkan minat perawat diukur dengan menggunakan lembar observasi, kemudian data diuji dengan Correlation Pearson Test.Hasil: Setelah intervensi, peningkatan pengetahuan perawat dari kategori sedang (n=12, 24.0%) menjadi tinggi (n=25, 50.0%) dan peningkatan minat perawat dari kategori sedang (n=13, 26.0%) menjadi tinggi (n=27, 54.0%). Kesimpulan: Sosialisasi diagram Pareto berpengaruh meningkatkan pengetahuan p-value=0.027  (p<0.05) dan minat perawat p-value=0.030 (p<0.05) dalam pengelolaan bahan habis pakai di rumah sakit. 


2021 ◽  
Vol 13 (1) ◽  
pp. 8-12
Author(s):  
Muammar Kadafi ◽  
Rachmad Almi Putra

It has been successfully designed an Electronic Nose (e-Nose) instrumentation system consisting of 6 MQ gas sensors, namely, MQ2, MQ4, MQ5, MQ7, MQ9, MQ135. The E-nose system is used to identify halal-haram food. This E-Nose system uses an Arduino Nano microcontroller. The Graphic User Interface (GUI) system is built with Visual Studio 2008. Then, the data responses will be evaluated by using 2 patterns recognition methods called Principle Component Analysis (PCA). The classification results can be explained by the value of the score plot on the PCA of the data. PC1 accounts for 19% of the variance, and PC2 accounts for 5% of the variance, data obtained is stored and displayed on personal computers in Excel format. Each sample was tested for up to ten repetitions. The data obtained from the six sensors in the e-nose was processed using Minitab 18 and it was necessary to obtain classification data on lard, pig oil, and sample B, which were fried crackers using pork oil.


2020 ◽  
Vol 2 (2) ◽  
pp. 135-140
Author(s):  
Hertanto Dwi Kussetiawan ◽  
Ahmad Al Kaafi ◽  
Rusma Insan Nurachim ◽  
Sandra Dewi Saraswati

The Senayan City Employee Cooperative is a cooperative that operates in the field of savings and loans and at the same time manages a shop business unit, buying and selling transactions are only recorded in Microsoft Excel format, when sales transactions are not immediately recorded so mistakes often occur. For this reason, we designed a sales and purchase information system design at the Senayan City Employee Cooperative using desktop-based java NetBeans, with the aim of creating a computerized system so that it could be used by the cooperative management. The software development methodology used in this research includes software requirements analysis, design, code generation, testing, and support. The results obtained from this research are the need for a cash sales accounting information system, cash receipts and sales reports that can assist cooperative managers in making decisions


2020 ◽  
Vol 1 (3) ◽  
pp. 43-53
Author(s):  
Shiva Kumar Jha ◽  
Mita Tarafder ◽  
Deepak Dhibar ◽  
Bhanu Pokharel ◽  
Jiban Shrestha ◽  
...  

A prototype soil moisture based an automated irrigation system were developed at National Maize Research Program in 2018 to study the water requirement of drought tolerant crop genotype. The irrigation system has been controlled by Arduino UNO as a micro controller. The instant soil moisture data were collected either in Excel format or graphical format using internet of things through the programming of Global System for Mobile Communication: Subscriber Identity Module (GSM:SIM card) of Nepal Telecom. The developed automated irrigation system has found maintained the predetermined threshold soil moisture. This automated irrigation system has been developed to make applicable for drip irrigation system which has operated at low water pressure maintained by 1.5² professional-grade solenoid valve. The introduction of this automated irrigation system has developed the base for Nepalese agricultural scientist in designing and promoting irrigation technology to make Nepalese agricultural more sustainable, mechanized and productive.


2020 ◽  
Vol 7 (2) ◽  
pp. 200
Author(s):  
Puji Santoso ◽  
Rudy Setiawan

One of the tasks in the field of marketing finance is to analyze customer data to find out which customers have the potential to do credit again. The method used to analyze customer data is by classifying all customers who have completed their credit installments into marketing targets, so this method causes high operational marketing costs. Therefore this research was conducted to help solve the above problems by designing a data mining application that serves to predict the criteria of credit customers with the potential to lend (credit) to Mega Auto Finance. The Mega Auto finance Fund Section located in Kotim Regency is a place chosen by researchers as a case study, assuming the Mega Auto finance Fund Section has experienced the same problems as described above. Data mining techniques that are applied to the application built is a classification while the classification method used is the Decision Tree (decision tree). While the algorithm used as a decision tree forming algorithm is the C4.5 Algorithm. The data processed in this study is the installment data of Mega Auto finance loan customers in July 2018 in Microsoft Excel format. The results of this study are an application that can facilitate the Mega Auto finance Funds Section in obtaining credit marketing targets in the future


2020 ◽  
Vol 45 (2) ◽  
pp. 159-167
Author(s):  
Himadri Barman

This article looks at the implementation of a web-based support system for measuring the fielding performance in cricket using open source technologies. Front-end has been developed using HTML, CSS and JavaScript. The back-end uses MySQL as the database for storing fielding related data. PHP is used to interact with the MySQL database. The web-based support system which is named Field-o-meter can be used to record fielding data, display fielding data, compute fielding performance measure and generate reports. The system has facilities for different categories of users, viz., administrators, data entry operators and viewers. Users need to login to access the system. Data can be added, deleted, displayed and also edited with certain restrictions. Analysis reports may be viewed online. Fielding data can be downloaded in xls (MS Excel) format. Being an online system hosted on a web server, it can be accessed from anywhere with an Internet connection. The web-based support system is easy to use with a simply designed interface. The system’s interface gets adjusted to mobile devices and as such can be used with a mobile browser. The system has been tested successfully for all the leading web browsers—Google Chrome, Firefox, Microsoft Edge, Opera and Safari.


Sign in / Sign up

Export Citation Format

Share Document