PENENTUAN DISTRIBUSI SUHU PADA PELAT LOGAM DENGAN CARA MENYELESAIKAN PERSAMAAN DIFERENSIAL ELIPTIK MENGGUNAKAN MICROSOFT EXCEL

  • Lukman Samatowa Universitas Negeri Gorontalo
    (ID)
  • Septiana Kurniasari Universitas Negeri Gorontalo
    (ID)
  • Muhammad Yunus Universitas Negeri Gorontalo
    (ID)
  • Relita Damopolii Universitas Negeri Gorontalo
    (ID)
Keywords: Microsoft Excel, temperature distribution, PDE

Abstract

This study aims to visualize the temperature distribution on metal plates by solving elliptic differential equations using the help of the Microsoft Excel program. Many physics problems have limited analytic solutions so a numerical solution is needed. One of them is about the temperature distribution on a homogeneous metal plate in a steady-state conditionThe equation of heat flow in steady-state conditions is an elliptic partial differential equation (PDE). By solving this equation, we will have a numerical model of the plate that can be a mesh with a certain temperature point. Each point has been known to calculate the temperature value. The temperature value influenced. The Temperature value influenced borders on the plate and the presence of heat generation. The edge of the plate can be a constant temperature, a convection zone with the outside air, or an isolated edge. This model is then processed using Microsoft Excel with the iteration calculation until the temperature distribution value is obtained. The results obtained a graphical visualization of temperature distribution on the plate.

 

 

 

Downloads

Download data is not yet available.

Author Biographies

Septiana Kurniasari, Universitas Negeri Gorontalo

 

 

 

Muhammad Yunus, Universitas Negeri Gorontalo

 

 

Relita Damopolii, Universitas Negeri Gorontalo

 

 

References

A. Abu Hamid, Kalor dan Termodinamika. Yogyakarta: UNY, 2007.

F. Kreith, R. M. Manglik, and M. Bohn, Principles of Heat Transfer, 7th ed. Stanford: Cengage Learning, 2011.

I. Noor and A. Fitrian, Simulasi Sebaran Temperatur Pelat Logam Tipis Besi dan Kuningan Berbasis Matlab, Navigation Physics, vol. 2, no 1. pp. 9-13. 2020

Sumariyah, K. S. Firdaus, and D. Mulyati, “Komputasi Aliran Panas pada Sebuah Batang Logam dengan Menggunakan Algoritma Numerov dan Bahasa Pemprograman Borland Delphi 6.0,” Berk. Fis., vol. 6, no. 3, pp. 71–78, 2003.

S. Sailah, “Menentukan Distribusi Temperatur dengan Menggunakan Metode Crank Nicholson,” J. Penelit. Sains, vol. 13, no. 2(B), pp. 17–22, 2010.

Supardiyono, “Analisis Distribusi Suhu pada Pelat Dua Dimensi Menggunakan Metoda Beda Hingga,” J. Penelit. Fis. Dan Apl., vol. 1, no. 2, pp. 33–39, 2011.

Sukardiyono and Supardi, “Penggunaan Metode Relaksasi untuk Penyelesaian Persamaan Diferensial Parsial Eliptik Dimensi Dua,” in Prosiding Seminar Nasional Hasil Penelitian MIPA dan Pendidikan MIPA, Yogyakarta, 2003.

J. P. Holman, Perpindahan Kalor. Jakarta: Erlangga, 1995.

Published
2023-03-16
How to Cite
Samatowa, L., Kurniasari, S., Yunus, M., & Damopolii, R. (2023). PENENTUAN DISTRIBUSI SUHU PADA PELAT LOGAM DENGAN CARA MENYELESAIKAN PERSAMAAN DIFERENSIAL ELIPTIK MENGGUNAKAN MICROSOFT EXCEL. JPF (Jurnal Pendidikan Fisika) Universitas Islam Negeri Alauddin Makassar, 11(1), 163-176. https://doi.org/10.24252/jpf.v11i1.36382
Section
Articles
Abstract viewed = 397 times