Sayahdin Alfat, Arsyad Hamid Saifudin, M. Hunaidah
{"title":"Penerapan visual basic for application spreadsheet excel untuk simulasi konsep motor listrik tiga fasa dan aplikasinya sebagai media pembelajaran","authors":"Sayahdin Alfat, Arsyad Hamid Saifudin, M. Hunaidah","doi":"10.12928/jrkpf.v7i2.17972","DOIUrl":null,"url":null,"abstract":"This research is a study that aims to: (1) simulate a three-phase electric motor using an Excel spreadsheet; (2) knowing the Excel Spreadsheet application on learning media. This study uses the VBA Excel 2013 Spreadsheet found on a laptop. All stages of research are carried out entirely in the Physics Education Computer Laboratory. The result data, several things are important notes: (1) simulations that have been made using the Visual Basic for Application Excel Spreadsheet can adjust to the real situation that occurs in the simulation of a three-phase electric motor by changing the parameter data and assumed functions according to the circumstances actually, as well as Excel VBA Macros are very useful for giving command buttons to cells whose data we want to change, so that it can give a visual impression to the graph that has been created; (2) based on the simulation test results it can be said that the manufacture of a three-phase electric motor simulation as a learning medium using the spreadsheets and macro VBA features in Ms. Excel can be used to simulate a case related to a three-phase electric motor that is given a current, a magnetic field will arise that can rotate the rotor and can analyze changes in the position of each phase in a three-phase electric motor.","PeriodicalId":17730,"journal":{"name":"Jurnal Riset dan Kajian Pendidikan Fisika","volume":"7 1","pages":"50"},"PeriodicalIF":0.0000,"publicationDate":"2020-10-30","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"3","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Jurnal Riset dan Kajian Pendidikan Fisika","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.12928/jrkpf.v7i2.17972","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 3
摘要
本研究旨在:(1)使用Excel电子表格模拟三相电动机;(2)了解Excel电子表格在学习媒体上的应用。本研究使用笔记本电脑上的VBA Excel 2013电子表格。所有阶段的研究完全在物理教育计算机实验室进行。对于结果数据,有几点需要注意:(1)使用Visual Basic for Application进行的仿真,Excel电子表格可以根据实际情况改变参数数据和假设函数,从而适应三相电动机仿真中的实际情况,Excel VBA宏对于给需要改变数据的单元格添加命令按钮非常有用,从而使所创建的图形具有视觉效果;(2)根据仿真试验结果可以说,利用Ms. Excel中的电子表格和宏VBA功能制作三相电动机仿真作为学习媒介,可以模拟一个三相电动机的相关情况,给定一个电流,将产生一个磁场,该磁场可以旋转转子,并可以分析三相电动机中各相位置的变化。
Penerapan visual basic for application spreadsheet excel untuk simulasi konsep motor listrik tiga fasa dan aplikasinya sebagai media pembelajaran
This research is a study that aims to: (1) simulate a three-phase electric motor using an Excel spreadsheet; (2) knowing the Excel Spreadsheet application on learning media. This study uses the VBA Excel 2013 Spreadsheet found on a laptop. All stages of research are carried out entirely in the Physics Education Computer Laboratory. The result data, several things are important notes: (1) simulations that have been made using the Visual Basic for Application Excel Spreadsheet can adjust to the real situation that occurs in the simulation of a three-phase electric motor by changing the parameter data and assumed functions according to the circumstances actually, as well as Excel VBA Macros are very useful for giving command buttons to cells whose data we want to change, so that it can give a visual impression to the graph that has been created; (2) based on the simulation test results it can be said that the manufacture of a three-phase electric motor simulation as a learning medium using the spreadsheets and macro VBA features in Ms. Excel can be used to simulate a case related to a three-phase electric motor that is given a current, a magnetic field will arise that can rotate the rotor and can analyze changes in the position of each phase in a three-phase electric motor.