Penerapan visual basic for application spreadsheet excel untuk simulasi konsep motor listrik tiga fasa dan aplikasinya sebagai media pembelajaran

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.