Claim Missing Document
Check
Articles

Pembuatan Dan Pelatihan Sistem Pengelolaan Nilai Menggunakan Microsoft Excel Berbasis Visual Basic for Applications Totok Suwanda; Fitroh Anugrah Kusuma Yudha; Imam Crespo Padilah
Jurnal Pengabdian Pada Masyarakat Vol 8 No 4 (2023): Jurnal Pengabdian Pada Masyarakat
Publisher : Universitas Mathla'ul Anwar Banten

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30653/jppm.v8i4.541

Abstract

Tujuan pengabdian ini adalah untuk memfasilitasi pelaksanaan program pelatihan sistem manajemen nilai dalam lembaga pendidikan. Program pelatihan ini memanfaatkan Microsoft Excel, khususnya melalui pemanfaatan Visual Basic for Applications (VBA). Proses pengembangan sistem meliputi identifikasi kebutuhan mitra, perumusan desain sistem, implementasi VBA di Microsoft Excel, serta tahap pengujian dan evaluasi sistem selanjutnya. Selain itu, diadakan pula pelatihan bagi operator SDN 1 Kembangsari untuk memberikan pengarahan tentang pemanfaatan sistem tersebut. Pengabdian ini menunjukkan bahwa pemanfaatan Microsoft Excel berbasis VBA menawarkan pendekatan yang cepat untuk mengelola nilai siswa secara efektif. Sistem manajemen nilai yang diimplementasikan memfasilitasi otomatisasi tugas pemrosesan data, seperti memasukkan nilai, menghitung rata-rata, dan menghasilkan laporan nilai yang komprehensif. Berdasarkan hasil pelatihan mengalami peningkatan pemahaman terkait microsoft excel dan VBA sebesar 73,3%. Penerapan sistem pengelolaan nilai berbasis Microsoft Excel dengan memanfaatkan VBA diharapkan dapat meningkatkan efisiensi, dan kecepatan pengolahan data nilai siswa. Selain itu, kemampuan untuk menyesuaikan sistem untuk memenuhi persyaratan khusus dari masing-masing lembaga pendidikan. This service aims to facilitate the implementation of value management system training programs in educational institutions. This training program utilizes Microsoft Excel, specifically through Visual Basic for Applications (VBA). The system development process includes identifying partner needs, formulating a system design, implementing VBA in Microsoft Excel, and the next stage of system testing and evaluation. Apart from that, training was also held for SDN 1 Kembangsari operators to guide the use of the system. This service shows that utilizing VBA-based Microsoft Excel offers a fast approach to managing student grades effectively. The implemented grade management system facilitates automating data processing tasks, such as entering grades, calculating averages, and generating comprehensive grade reports. The training results show an increase in understanding regarding Microsoft Excel and VBA by 73.3%. Implementing a Microsoft Excel-based grade management system using VBA is expected to increase the efficiency and speed of processing student grade data additionally, the ability to customize the system to meet the specific requirements of each educational institution.
The effect of cutting depth, feed rate, and cutting angle on surface roughness in the lathe process of aluminum 6061. Totok Suwanda; Gilang Joy Habib Ramdhan; Nur Ardiyansyah
Jurnal Polimesin Vol 22, No 2 (2024): April
Publisher : Politeknik Negeri Lhokseumawe

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30811/jpl.v22i2.4658

Abstract

In the turning process, the machining parameters have a significant impact on the product quality. Consumers frequently request that certain industries adhere to product quality standards, especially regarding surface texture. Numerous product failures have resulted in dissatisfaction among the company's clientele because many lathe operators are fixated solely on product size drawings and are unaware of factors that can impact the surface roughness value. This investigation was conducted to ascertain how machining parameters affect surface irregularity. Variations in feed rates of 47.5 mm/min and 345.6 mm/min, cutting angles of 60° and 80°, and depths of cut of 1 mm and 3 mm were utilized to conduct the investigation on aluminum alloy 6061 specimens. The results of turning were evaluated for surface roughness using a surface roughness analyzer and a macro test to determine the structure of the surface roughness. Using the Minitab 2019 application, the obtained data was then analyzed to determine the influence of each trimming parameter working individually or simultaneously. Using the method of geometric factorial analysis, integrate the research parameters. The results indicated that the surface roughness increased as the feed rate increased; the lowest surface roughness was achieved with a depth of cut of 1 mm, a feeding rate of 47.5 mm/min, and a cut angle of 80°. In this study, the surface roughness value decreased as the cutting angle increased at lower levels of feeding rate, while the surface roughness value increased at higher levels of feeding rate.
Effect of friction time on the mechanical properties of AA 6061-T6 continuous drive friction welded joints Totok Suwanda; Eko Syaifudin; Aris Widyo Nugroho; Nur Ardiyansyah
Journal of Welding Technology Vol 6, No 1 (2024): June
Publisher : Politeknik Negeri Lhokseumawe

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30811/jowt.v6i1.4864

Abstract

Continuous drive friction welding (CDFW) is a solid-state method used to join solid cylindrical metals. This process involves several key parameters that influence the strength of the connection, including friction time, friction pressure, and machine speed. The aim of this research was to determine the effect of different friction times on the mechanical properties of Aluminium 6061 CDFW joints. Friction time variations of 2, 3, 4, 5, 6, 7, 8, 9, and 10 seconds were used in the welding process, while other parameters remained constant: friction pressure at 30 MPa, upset pressure at 70 MPa, upset time at 2 seconds, and engine speed at 1000 rpm. Microstructure observations, Vickers microhardness testing, and tensile testing were conducted to assess the impact of friction time on the joint results. Analysis of the microstructure revealed changes, such as recrystallization, in the joint area. It was observed that the grain size in the joint area was smaller compared to that of the heat-affected zone (HAZ) and the parent metal. Hardness testing showed a decrease in hardness value with increasing distance from the joint. In the tensile test, the highest tensile strength of 215.76 MPa was achieved with a friction time of 6 seconds, while the lowest tensile strength of 78.60 MPa was obtained with a friction time of 2 seconds
PENGARUH VARIASI KECEPATAN PUTAR DAN DIAMETER PIN TOOLS TERHADAP KUAT GESER DAN STRUKTUR MAKRO SAMBUNGAN FRICTION STIR WELDING DISSIMILAR HIGH DENSITY POLYETHYLENE-POLYPROPYLENE Suwanda, Totok; Ardiyansyah, Nur
Jurnal Rekayasa Mesin Vol. 14 No. 3 (2023)
Publisher : Jurusan Teknik Mesin, Fakultas Teknik, Universitas Brawijaya

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.21776/jrm.v14i3.1376

Abstract

The purpose of this study is to find out the effect of pin tool turn speed and pin tool diameter on strong shear and macro structure on the friction stir welding dissimilar high-density polyethylene and polypropylene sheets. Variations in welding process parameters used in this study were: rotary speed of 980, 1560, 2360 rpm, and pin tool diameter of 4 and 5 mm. The shape of the cylinder pin, the feeding speed of 11 mm/min, and the plunge depth of 7.8 mm were maintained constant. The results showed that the highest shear strength value was obtained on the connection with a rotary speed of 1560 rpm and a pin tool diameter of 5 mm 4.8 N / mm2 or 23.71% of the tensile strength of raw material high density polyethylene. Observations of macro structures show that the pin tool diameter 5 mm has only slight defects in the stir zone.
Pemberdayaan Kelompok Wanita Tani dengan Produktivitas dan Peluang Usaha melalui Pelatihan Abon Lele di Kabupaten Sleman Prasetyo, Satria Iman; Nugroho, Aris Widyo
Amalee: Indonesian Journal of Community Research and Engagement Vol 3 No 2 (2022): Amalee: Indonesian Journal of Community Research and Engagement
Publisher : LP2M INSURI Ponorogo

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37680/amalee.v3i2.1322

Abstract

Abstract: This empowerment program aims to increase productivity and open business opportunities for the Women Farmers Group (KWT) through training in processing catfish floss in Padukuhan Soromintan. KWT problems, such as the lack of processed agricultural products and difficulties in marketing their harvests, have caused the low productivity of the KWT Mugi Lancar to be the reason for the intense business productivity. Based on this, this empowerment conceptualizes the program as a follow-up to solving the problems faced by KWT Mugi Lancar through training in processing catfish floss. The implementation method has five stages: problem identification, conceptualization, success indicators, validation, and application. The results of the implementation of community empowerment show that the catfish floss processing training is divided into two types of exercise, namely theory and practice, which includes training on catfish floss processing, packaging, and legality submissions to marketing. The result shows a level of understanding of the catfish-shredded training participants. This is expected to increase the motivation of KWT Mugi Lancar to carry out business productivity through processing catfish floss. Abstrak: Pengabdian masyarakat ini bertujuan untuk meningkatkan produktivitas dan membuka peluang usaha Kelompok Wanita Tani (KWT) melalui pelatihan pengolahan abon lele di Padukuhan Soromintan. Minimnya olahan hasil pertanian dan kesulitan dalam memasarkan hasil panen menyebabkan rendahnya produktivitas usaha KWT Mugi Lancar. Berdasarkan hal tersebut pemberdayaan ini mengkonseptualisasikan program sebagai tindak lanjut untuk menyelesaikan permasalahan yang dihadapi oleh KWT Mugi Lancar melalui pelatihan pengolahan abon lele. Metode pelaksanaan dilakukan melalui lima tahapan di antaranya identifikasi masalah, konseptualisasi, indikator keberhasilan, validasi, dan aplikasi. Hasil akhir menunjukkan peningkatan motivasi KWT Mugi Lancar dalam produktivitas usaha melalui pengolahan abon lele.
Optimized Pond Structure for Catfish Farming as a Permanent Revenue Source of Ahmad Dahlan Muhammadiyah Reformatory Sudarisman, S.; Suwanda, Totok
Jurnal Pengabdian Masyarakat Progresif Humanis Brainstorming Vol 6, No 4 (2023): Jurnal Abdimas PHB : Jurnal Pengabdian Masyarakat Progresif Humanis Brainstormin
Publisher : Politeknik Harapan Bersama

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.30591/japhb.v6i4.5317

Abstract

This community service activity was conducted in accordance with the problems faced by the reformatory, i.e. lack of revenue source to fund its regular activities, and aims to providing catfish farming ponds which can be used for life skill training medium for reformatory students and a permanent source of income for the reformatory. Having had this ponds the reformatory has an additional permanent revenue source, in addition, the ponds was constructed by optimizing the potential mechanical properties of the material being used. The methods used include object observation, interviews with reformatory management, technical guidance, and catfish farming practices. The result of this activity is the availability of three tarpaulin catfish ponds measuring 3 ´ 2 m2 each which can be used by the reformatory students as a medium for life skills training. The time for putting baby fish into the three ponds was scheduled in different times so that the harvest time would also be different such that market oversupply can be avoided. During the farming period, the reformatory students were very enthusiastic in feeding and monitoring the condition of the pond water and the growth of the catfish, so that catfish farming could run as expected. The first harvest was partly consumed and the other was sold to the local market.
UPAYA MENINGKATKAN PENGUNJUNG WEBSITE KELOMPOK PEMUDA RW 049 POGUNG KIDUL DENGAN CROSS-PLATFORM Krisdiyanto, Krisdiyanto; Nugroho, Aris Widyo; Azhar, Chusnul; Adi, Rahmad Kuncoro; Nugroho, Ahmad Restian Adi
ADIMAS Jurnal Pengabdian Kepada Masyarakat Vol 6, No 1 (2022): Maret
Publisher : Universitas Muhammadiyah Ponorogo

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.24269/adi.v6i1.4004

Abstract

Pedukuhan Pogung Kidul RW 094 terletak di daerah Sinduadi Mlati Sleman. Pedukuhan tersebut berdampingan dengan sebuah kampus. Penduduk di daerah tersebut menjual produk kepada mahasiswa yang tinggal sementara di daerah tersebut dengan website yang dikelola oleh kelompok pemuda daerah tersebut. Masalah yang terjadi pada mitra yaitu website tersebut dirasa kurang maksimal karena jumlah pengunjung dan tampilan masih relatif sedikit. Untuk menambah jumlah pengunjung dan tampilan pada website tersebut pihak pengabdi memberikan solusi dengan metode cross-platform yaitu membuat aplikasi smartphone yang bisa digunakan untuk membantu masyarakat mengakses website yang dikelola kelompok pemuda tersebut. Hasil dari kegiatan pembuatan aplikasi smartphone tersebut yaitu dengan adanya peningkatan jumlah pengunjung dan tampilan website. Peningkatan jumlah pengunjung dan tampilan website tersebut relatif besar yaitu 455,5% dan 376,3%. Hal tersebut terjadi setelah ada ceremony peluncuran aplikasi smartphone yang bisa digunakan untuk mengakses website tersebut.
The Effect of Rotational Tool Speed on Dissimilar Joint Aluminum-Copper Plate Friction Stir Welded Joint Nugroho, Aris Widyo; Rahman, Khukuh Aulia; Rahman, Muhammad Budi Nur
Semesta Teknika Vol 26, No 2 (2023): NOVEMBER
Publisher : Universitas Muhammadiyah Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.18196/st.v26i2.20477

Abstract

The study investigates the impact of rotational tool speed on the mechanical properties and microstructure of aluminum-cooper friction stir-welded joints. It found that higher rotational speed leads to increased grain size, possibly due to increased heat production. Higher hardness values in the stir zone result from uniform dispersion of smaller copper particles. The study found that 540 rpm yields the maximum hardness value in the stir zone, measuring 67 VHN. However, higher speed results in defects like voids, cracks, and intermetallic compounds (IMCs), which are linked to the formation of IMCs at elevated temperatures. The optimal welding conditions at 550 rpm balance grain refinement, hardness enhancement, and defect mitigation, contributing to the understanding of welding process parameters.
Effect of Friction Pressure on the Mechanical Properties of CDFW Dissimilar Aluminium 6061-T6 and Stainless steel 304 Welding Joints Suwanda, Totok; Yulianto, Tri; Nugroho, Aris Widyo; Ardiyansyah, Nur
Semesta Teknika Vol 27, No 1 (2024): MEI
Publisher : Universitas Muhammadiyah Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.18196/st.v27i1.18534

Abstract

Welding technology has significantly developed in the industrial sector along with advances in manufacturing technology. The demand for joining methods combining dissimilar metals is increasing in the industrial sector. However, joining dissimilar metals is challenging because of differences in physical and mechanical properties. Continuous drive friction welding is a solid-state joining method widely used to join dissimilar metals. The research aimed to determine the effect of variations in friction pressure on the mechanical properties of continuous drive friction welding joints with dissimilar materials, Aluminum 6061 T6 and Stainless Steel 304. The process parameters used in this welding were the friction pressures used were 30 MPa, 35 MPa, and 45 MPa. The friction time is 2 seconds, the rotation speed is 1000 rpm, and the upset pressure is 50 MPa. Then, welded joints were evaluated for Vickers microhardness and microstructure observations. Based on the research results, it shows that the temperature distribution and microstructure results show that there is a change in the hardness value of the aluminum material. In contrast, the 304 stainless steel material experiences an insignificant change in the hardness value.
Effect of Friction Pressure on the Mechanical Properties of CDFW Dissimilar Aluminium 6061-T6 and Stainless steel 304 Welding Joints Suwanda, Totok; Yulianto, Tri; Nugroho, Aris Widyo; Ardiyansyah, Nur
Semesta Teknika Vol 27, No 1 (2024): MEI
Publisher : Universitas Muhammadiyah Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.18196/st.v27i1.18534

Abstract

Welding technology has significantly developed in the industrial sector along with advances in manufacturing technology. The demand for joining methods combining dissimilar metals is increasing in the industrial sector. However, joining dissimilar metals is challenging because of differences in physical and mechanical properties. Continuous drive friction welding is a solid-state joining method widely used to join dissimilar metals. The research aimed to determine the effect of variations in friction pressure on the mechanical properties of continuous drive friction welding joints with dissimilar materials, Aluminum 6061 T6 and Stainless Steel 304. The process parameters used in this welding were the friction pressures used were 30 MPa, 35 MPa, and 45 MPa. The friction time is 2 seconds, the rotation speed is 1000 rpm, and the upset pressure is 50 MPa. Then, welded joints were evaluated for Vickers microhardness and microstructure observations. Based on the research results, it shows that the temperature distribution and microstructure results show that there is a change in the hardness value of the aluminum material. In contrast, the 304 stainless steel material experiences an insignificant change in the hardness value.
Co-Authors Adi Nugroho Adi Purnama Adi, Rahmad Kuncoro Aditya Kurniawan Aditya Kurniawan Ady Ryan Romadhan Agung Astuti Ahmad Janan Febrianto Ahmad Muslim Ardiyansyah, Nur Arifin Arifin Aris Widyo Nugroho Asmara, Muhammad Rafi Astuti, Agung Azhar, Chusnul Azizah, Aulia Fitri Nur Azmi, Azhim Asyratul Bambang Riyanta, Bambang Bayu Satriya Wardhana Budiantoro, Cahyo Budiyantoro, Cahyo Cahyani, Isma Afdwi Deny Fajrur Ramdani, Deny Fajrur Diharjo, Kuncoro Dwi Saputra, Muhammad Rifai Dwi Saputra, Muhammad Rifai Eko Syaifudin Febriansyah, Albyan Windra Fitroh Anugrah Kusuma Yudha Gilang Joy Habib Ramdhan Hadi Prayitno, Hadi Hakim, Moh. Hari Widada, Hari Ikhsan, Subkhan Nur Imam Crespo Padilah Imbaraga, M. Rafiudin Iswanto Iswanto Jannah, Meyriska Julianto, Achmad Zamhari krisdiyanto, krisdiyanto Krisdiyanto, Krisdiyanto Kuncoro Diharjo Kuncoro Diharjo Kusnindyasita, Anisa Muh Budi Nur Rahman, Muh Budi Nur Muhajir Muhajir, Muhajir Muhammad Budi Nur Rahman Muhammad Budi Nur Rahman, Muhammad Budi Muhammad, Bagja Restu Muhammad, Bagja Restu Muhtadi Muhtadi Mujiyana Mujiyana Mulyanti, Amelia Nur'afni Muniib, Abdin Nugroho, Ahmad Restian Adi Nur Aji Wijayanto Nur Ardiyansyah Nyeleker, Kerkulah P Pradana, Benanta Ogi Prasetyo, Satria Iman Puspitasari, Alfina Dwi Rahman, Khukuh Aulia Rahman, Muh Budi Nur Rahman, Muhammad Budi Nur Rahman, Muhammad Budi Nur Rahman, Reza Taufikur Ramdani, Deny Fajrur Reza Taufikur Rahman Rifki Febriansah Riza, Eduar Iqbal Romadhan, Ady Ryan Romi Wilza S. Sudarisman Sabtanti Harimurti, Sabtanti Santosa, Tito Hadji Agung Septian Aldo Serena Serena, Septian Aldo Sigit Hidayat Nuri Sigit Hidayat Nuri, Sigit Hidayat Sosiati, Harini Subkhan Nur Ikhsan Suminto, Joko Sunardi, Sunardi Syahputra, Koko Nusyi TH Adi Nugroho Tri Yulianto Trisnani, Wenny Nur Wahyudi, Wahyudi Wilza, Romi