scholarly journals Development of Research & Development Dashboard For an University

2018 ◽  
Vol 7 (2.32) ◽  
pp. 60
Author(s):  
Kodukula Subrahmanyam ◽  
Tirumuru Ketha ◽  
Salichemaladevarajulu Balakrishna ◽  
Telaprolu Naga Manoj Kumar
Keyword(s):  
Data Association ◽  
Academic Research ◽  
Visual Basic ◽  
Research Development ◽  
Microsoft Excel ◽  
Web Based ◽  
Microsoft Access ◽  
The Hours ◽  
Funding Research ◽  
Internal Funding

An information dashboard is a data association gadget that ostensibly tracks, displays and demonstrates the principle key execution markers (KPI) and key information focuses to screen the soundness of a business, university, office or particular process. They are versatile to meet the specific needs of an office and company or an university. A dashboard interfaces with our documents, attachments, services and API's, yet at first look shows this information as tables and also used to monitor and track various data. As constant checking decreases the hours of breaking down an information dashboard is the most proficient approach to track numerous information. In Research and progression work is facilitated towards the innovation, introduction, and development and advancement of products and processes. In this project we are going to develop a framework for R&D of a University in this we are mainly focusing on the Academic Research, sponsored & Internal Funding Research, Consultancy, center of Excellence, Innovation Incubation & Entrepreneurship and Extramural.This R&D Dashboard is utilized for web based enlisting for patents, copyrights, licenses, copyrights, productions in meetings, sorting out gatherings, seminars and workshops. This Dashboard was developed, utilizing Windows-based Microsoft excel, VISUAL BASIC and back end is Microsoft Access Database. The VISUAL BASIC has easy to use pull down menus and toolbars for different analysis. 

SISTEM INFORMASI PENJUALAN ALAT OLAHRAGA PADA AS SPORT METRO MENGGUNAKAN BARCODE

2015 ◽  
Vol 1 (1) ◽  
pp. 1-12
Author(s):  
Gunayanti Kemalasari ◽  
Miftah Widayatina
Keyword(s):  
Visual Basic ◽  
Microsoft Access ◽  
Visual Basic 6.0

ABSTRAK Pengolahan data manual pada proses transaksi di As Sport Metro mempersulit pencarian data keluar masuk barang, perhitungan stok serta pembuatan laporan. Untuk memecahkan masalah tersebut diperlukan sebuah Sistem Informasi yang dapat membantu mengakses informasi secara lebih cepat. Tujuan penelitian ini adalah merancang sebuah sistem informasi yang dapat mempermudah transaksi penjualan, mendukung pengolahan data dan mempercepat penyajian laporan. Metode penelitian menggunakan prototype karena secara keseluruhan akan mengacu pada kepuasan pelanggan dan selama proses penelitian berjalan akan terjalin interaksi antara pengembang dan pelanggan. Dengan begitu penerapan lebih mudah karena antara pengembang dan pelanggan saling mengetahui apa yang diharapkan. Segala proses yang terjadi dalam sistem di implementasikandengan bahasa pemrograman Microsoft Visual Basic 6.0. dan menggunakan basis data Microsoft Access 2007. Kesimpulan yang dapat diambil adalah sistem informasi sanggup memenuhi kebutuhan pelanggan setelah dilakukan implementasi dan uji coba.

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

Program Aplikasi Jasa Angkutan pada PT A di Kota Cirebon

2021 ◽  
Vol 3 (1) ◽  
pp. 43-48
Author(s):  
Mar’atus Solikhah
Keyword(s):  
Visual Basic ◽  
Microsoft Access ◽  
Entity Relationship ◽  
Entity Relationship Diagram ◽  
Visual Basic 6.0

Penelitian ini bertujuan untuk menyempurnakan aplikasi jasa angkutan pada PT A A dengan menggunakan Microsoft Visual Basic 6.0 dan Microsoft Access 2010. Penelitian ini menggunakan metode seperti wawancara, observasi dan studi pustaka. Penelitian membahas mengenai rancangan sistem yang terdiri atas Entity Relationship Diagram (ERD), normalisasi, struktur HIPO, flowchart program, rancangan tampilan program. Serta membahas mengenai implementasi yang terdiri atas hubungan antar tabel, struktur database, tampilan menu utama, input dan output program dan compile program atau hasil akhir program.

Design of a Total Revenue Forecasting Tool to Estimate the Economic Output of Hardwood Logs

2020 ◽  
Vol 70 (4) ◽  
pp. 439-447
Author(s):  
Juan J. González ◽  
Henry Quesada ◽  
Sailesh Adhikari ◽  
Brian Bond ◽  
Shawn Grushecky
Keyword(s):  
Probability Distributions ◽  
Visual Basic ◽  
Total Revenue ◽  
Total Income ◽  
Microsoft Excel ◽  
Economic Output ◽  
Revenue Forecasting ◽  
Simple Tool ◽  
Hardwood Lumber ◽  
Volume Output

Abstract This article introduces a total revenue forecasting tool designed for calculating the economic output of visually graded hardwood lumber. The tool integrates Monte Carlo simulation from previous studies' data, providing a pseudoestimation of total board-feet based on log grades. The lumber output from different log groups is modeled using probability distributions for each lumber grade. The estimated volume output is multiplied by the respective price for each grade, leading to an expected amount of economic output for given log-grades. The tool was implemented using Microsoft Excel 2016 and Visual Basic. This work provides hardwood lumber producers with a valuable and simple tool to determine different scenarios of total income from each log, as established by the user with a statistical perspective. This total revenue forecasting tool provides the industry with a way to reduce waste and estimate their potential revenue by maximizing the interaction between the log yield's variables and providing the economic output of log, leading to an improvement of the economy of the hardwood market.

scholarly journals Rancang Bangun Sistem Informasi Penjualan Obat Berbasis Website dengan Menggunakan Metode Waterfall

2020 ◽  
Vol 6 (1) ◽  
pp. 71-82
Author(s):  
Ahmad Fauzi ◽  
Dewi Wulandari
Keyword(s):  
Information System ◽  
Data Processing ◽  
Quality Of Data ◽  
Microsoft Excel ◽  
Web Based ◽  
Drug Sales ◽  
Uml Modeling ◽  
Computer Based ◽  
A Company

Abstract: In this era of globalization, information technology is speeding up. In managing the information required good technology because the information has a greatvalue for a company. And computer technology today with its increasingly sophisticated processing speed has enabled the development of computer-based information systems. Problems that exist in Kauman Apothecary is about the data processing that is still done manually, ranging from the admission process of incoming drugs, drugs out, often the absence of matching stock between the data with the original drug, as well as in making reports that still use microsoft excel. The design of the system is described by UML modeling, drug sales information system on web-based pharmacy kauman intranet this is the best solution, can improve the quality of data processing drugs in pharmacies kauman. And with the creation of this information system, can help simplify data processing moreleverage, while keeping data safe and minimize the data kerangkapan. The design of web-based drug sales information system is made using PHP and MySQL.Keywords: Information System, Sales, Kauman PharmacyAbstrak: Dalam era globalisasi sekarang ini, teknologi informasi melaju dengan cepatnya.Dalam mengelola informasi dibutuhkan teknologi yang baik karena informasi mempunyai nilai yang besar bagi suatu perusahaan. Dan teknologi komputer sekarang ini dengan kecepatan prosesnya yang semakin canggih telah memungkinkan pengembangan sistem informasi berbasis komputer. Masalah yang ada pada Apotek Kauman yaitu mengenai pengolahan data-datanya yang masih dilakukan secara manual, mulai dari proses penerimaan obat masuk, obat keluar, sering tidak adanya kecocokan stok antara data dengan obat aslinya, serta dalam membuat laporan yang masih menggunakan microsoft excel. Perancangan sistem digambarkan dengan pemodelan UML, sistem informasi penjualan obat pada apotek kauman berbasis web intranet ini merupakan solusi yang terbaik, dapat meningkatkan kualitas pengolahan data obat di apotek kauman. Dan dengan dibuatnya sistem informasi ini, dapat membantu mempermudah pengolahan data lebih maksimal, sekaligus menjaga data tetap aman dan meminimalisir adanya kerangkapan data. Perancangan sistem informasi penjualan obat berbasis web ini dibuat menggunakan PHP dan MySQLKata Kunci: Sistem Informasi, Penjualan, Apotek Kauman.

scholarly journals INVESTIGATION AND ANALYSIS OF POWER QUALITY OF SINGLE PHASE, LOW VOLTAGE CONSUMERS IN ADO –EKITI METROPOLIS

2018 ◽  
Vol 6 (5) ◽  
pp. 177-189
Author(s):  
P.K. Olulope
Keyword(s):  
Power Quality ◽  
Low Voltage ◽  
Microsoft Excel ◽  
The Hours ◽  
Nominal Voltage ◽  
Distribution Company ◽  
Voltage Deviation ◽  
Electric Equipment ◽  
Power Harmonics

This paper examines the power quality of Ado-Ekiti metropolis in Ekiti State, Nigeria. The metrics of power quality includes: disturbances such as interruptions, voltage sags, spikes and momentary losses, power harmonics, and voltage unbalances with intrinsic effects on the efficiency and performances on the electric equipment. The necessity for this paper is the fluctuations of voltage supplied to the consumers by the distribution company in Ekiti State. These have significant effects on the power delivered to consumers ‘appliances, quality of their lives and the development of the society at large. The quality of voltage of each consumer in the selected areas were measured with the aid of digital multimeter which was compared with the standard nominal voltage of 240V, voltage deviations were evaluated through the use of standard mathematical equation and linear regression model was employed on the calculated voltage deviation with day and time used as inputs and the voltage deviation as the output. The implementation of the modelling was achieved through the use of Microsoft Excel data tool. The power quality for areas1, 2, 3 for the hours under consideration were poor with respect to R2 range of above 0.5 but better than that area 4 with R2 value of less than 0.5.The results were compared and recommendations were made with the view of improving the power quality in the metropolis.

scholarly journals OPTIMALISASI JUMLAH KENDARAAN DAN RUTE DISTRIBUSI LOGISTIK PEMILIHAN DI KABUPATEN KEDIRI PADA MASA PANDEMI

2021 ◽  
Vol 3 (1) ◽  
pp. 1-25
Author(s):  
Eka Wisnu Wardhana ◽  
Oki Anita Candra Dewi
Keyword(s):  
Vehicle Routing ◽  
Vehicle Routing Problem ◽  
Nearest Neighbor ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Google Maps ◽  
Routing Problem ◽  
Visual Basic Application

Artikel ini membahas tentang permasalahan distribusi logistik pemilihan kepala daerah (Pemilihan) yang berkaitan dengan penentuan jumlah kendaraan yang tepat dan pemilihan rute terdekat dengan mempertimbangkan jarak yang dapat dilalui oleh kendaraan roda 4 atau lebih. Penentuan jumlah kendaraan dan rute yang tepat ini sangat penting bagi Komisi Pemilihan Umum (KPU) karena aspek logistik dan distribusi sangat berpengaruh dalam memastikan suara masyarakat tersampaikan dengan baik. Selain itu aspek ini memiliki keterkaitan satu dengan lainnya baik bersifat strategis maupun teknis. Selama pandemi, distribusi logistik Pemilihan tidak hanya berkaitan dengan kebutuhan alat pemungutan suara namun juga alat pelindung diri (APD) selama pelaksanaan pemungutan. Oleh karena itu kegiatan logistik menjadi lebih banyak dengan tetap mempertimbangkan protokol kesehatan sehingga diperlukan sebuah aplikasi yang dapat menentukan jumlah kendaraan dan rute yang tepat sebagai dasar untuk mempercepat pengambilan keputusan. Penelitian ini fokus pada penentuan jumlah kendaraan dan rute distribusi logistik yang optimal pada Pemilihan tahun 2020 di masa pandemic COVID-19 di KPU Kabupaten Kediri menggunakan pendekatan vehicle routing problem dengan memperhatikan jarak dari google maps serta menggunakan algoritma nearest neighbor dalam menentukan jarak terdekat antar titik. Aplikasi yang dikembangkan adalah penentuan rute menggunakan Visual Basic Application (VBA) pada Microsoft Excel. Penelitian ini menghasilkan jumlah kendaraan sebanyak 12 kendaraan untuk pengiriman logistik Pemilihan maupun APD dengan batas maksimal total perjalanan setiap truk sepanjang 100 km. Selain itu terdapat 6 kecamatan yang dikunjungi dua kali karena total kebutuhan melebihi kapasitas kendaraan.

scholarly journals The Ethics of Outsourcing Online Survey Research

2012 ◽  
pp. 160-175
Author(s):  
Peter J. Allen ◽  
Lynne D. Roberts
Keyword(s):  
Survey Research ◽  
Online Survey ◽  
Ethical Issues ◽  
Service Providers ◽  
Academic Research ◽  
Limited Attention ◽  
Web Surveys ◽  
Web Based ◽  
Research Software ◽  
Research Students

The increasing level of Internet penetration over the last decade has made web surveying a viable option for data collection in academic research. Software tools and services have been developed to facilitate the development and deployment of web surveys. Many academics and research students are outsourcing the design and/or hosting of their web surveys to external service providers, yet ethical issues associated with this use have received limited attention in academic literature. In this article, the authors focus on specific ethical concerns associated with the outsourcing of web surveys with particular reference to external commercial web survey service providers. These include threats to confidentiality and anonymity, the potential for loss of control over decisions about research data, and the reduced credibility of research. Suggested guidelines for academic institutions and researchers in relation to outsourcing aspects of web-based survey research are provided.

scholarly journals Constructing Student’s Mathematical Understanding Skills and Self Confidence: Math Game with Visual Basic Application for Microsoft Excel in Learning Phytagoras at Junior High School

2018 ◽  
Vol 7 (3.2) ◽  
pp. 732 ◽  
Author(s):  
Martin Bernard ◽  
Eva Dwi Minarti ◽  
Masta Hutajulu
Keyword(s):  
High School ◽  
High School Students ◽  
Junior High School ◽  
Junior High ◽  
Visual Basic ◽  
Process Data ◽  
School Students ◽  
Microsoft Excel ◽  
Mathematical Concepts ◽  
Visual Basic Application

Learning media in Mathematics by using Microsoft Excel software that assisted Visual Basic application is a tool that can be applied for a more interactive visualization so that students better understand about mathematical concepts. Microsoft Excel is a software that serves to process data in the form of numbers that are always associated with mathematical commands. In addition, the functions of commands in Microsoft Excel can be applied in various fields such as Statistics, Economics and Finance, Mathematical Logic, and Engineering. If using mathematical concepts with data processing. But it is not just a number, it can also be used to process objects on shapes or drawings on images. This, of course, requires a function other than the mathematical functions of Visual Basic Applications, which can make math tools more interesting. The advantages of Microsoft Excel with Visual Basic for Application (VBA) are (1) the images are more interactive with different sizes and can make more; (2) more economical; (3)saving time; (4)the software is easy to find, and (5)improving students 'understanding of mathematical concepts and foster students' sense of trust, especially in junior high school students.  

Sign in / Sign up

Export Citation Format

Share Document