Melola Discovery

← Melola Discovery

Open access Jurnal

Numerical Modeling of Free Fall Motion of Objects Affected by Force as a Function of Velocity Using Excel Spreadsheet

Indonesian Journal of Physics and its Applications · Vol. 1 No. 2 (2021) · pp. 64–68

ISSN
2775-9903
Published
2021-10-14
Publisher
Pendidikan Fisika FKIP Universitas Halu Oleo
Language
eng
License
creativecommons.org/licenses/by-nc/4.0

Abstract

In the case of free fall motion which is influenced by linear drag with known air friction coefficient parameters b = 0.04 kg/s, m = 0.05 kg, = 0.5s and g = 9.8m/s2, the terminal velocity of the object is 12.25 m/s. In determining the speed, the error value of the Euler method is greater at 17.5800 % while the Runge Kutta Order 4 method only reaches 0.02425 %. Similarly, in determining the distance, the highest error value obtained by the Runge Kutta Order 4 method reached 13.7655% while the error value of the Euler method reached 0.113%. In the case of free fall motion that is influenced by quadratic drag, it is known that the coefficient of air friction b = 0.001225kg/m, m = 0.51kg, = 0.5s and g = 9.8 m/s2, the terminal velocity of the object is 34.64 m/s. In determining the speed value using the numerical method, the error value of the Euler method reaches 3.616% and the Runge Kutta Order 4 method reaches 0.0008%. The results of the research show that numerical models are easier to work with using spreadsheets because they use large arithmetic calculations. The level of accuracy of the Runge Kutta Order 4 method is more accurate than the Euler method

Keywords

Collaboration network of the authors

25 authors · 47 co-authorship links

Hover or tap a name to highlight its co-authors. Double-click to open the author's page.

  • Universitas Halu Oleo
  • Jenderal Soedirman University
  • Affiliation unknown
  • Different organisations
  • Same organisation
  • Affiliation unknown
  • Thicker line = more joint articles · bigger circle = more articles
Show as table
Co-authorOrganisationJoint articles
Rosliana EsoAffiliation unknown2
Fahyuddin FahyuddinAffiliation unknown2
Luh SukariasihUniversitas Halu Oleo2
Hunaidah HunaidahAffiliation unknown1
Arif Setia WibawaAffiliation unknown1
Vivi HastutiAffiliation unknown1
Suci Kris LukmanaAffiliation unknown1
La Ode RusmanAffiliation unknown1
Mardi YunusAffiliation unknown1
Muhammad YasinUniversitas Halu Oleo1
Jahidin JahidinAffiliation unknown1
Sitti AsrianiAffiliation unknown1
Amran AmranJenderal Soedirman University1
I Nyoman SudianaAffiliation unknown1
Wa Ode SurianiAffiliation unknown1
Miftah KhairaniAffiliation unknown1
Muhammad AnasAffiliation unknown1
Lindawati LindawatiAffiliation unknown1
Halima HalimaAffiliation unknown1
Roliana EsoAffiliation unknown1
La Maronta GalibAffiliation unknown1
Yulin YulinAffiliation unknown1

Affiliations come from OpenAlex; journal OAI-PMH metadata carries none. Authors without an OpenAlex ID are matched by name, which can merge or split people.

Metadata source: OAI-PMH (metadata jurnal) https://ojs.uho.ac.id/index.php/IJPiA/oai, first harvested 30 Okt 2026, last seen 30 Okt 2026.
Original metadata (oai_dc) 
<oai_dc:dc xmlns="http://www.openarchives.org/OAI/2.0/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.openarchives.org/OAI/2.0/oai_dc/  http://www.openarchives.org/OAI/2.0/oai_dc.xsd">
	<dc:title xml:lang="en-US">Numerical Modeling of Free Fall Motion of Objects Affected by Force as a Function of Velocity Using Excel Spreadsheet</dc:title>
	<dc:creator>Buhera, Rusdiman</dc:creator>
	<dc:creator>Safiuddin, La Ode</dc:creator>
	<dc:creator>Hastuti RM, Vivi</dc:creator>
	<dc:subject xml:lang="en-US">quadratic drag; linear drag; Runge Kutta; error value; excel spreadsheet</dc:subject>
	<dc:description xml:lang="en-US">In the case of free fall motion which is influenced by linear drag with known air friction coefficient parameters b = 0.04 kg/s, m = 0.05 kg, = 0.5s and g = 9.8m/s2, the terminal velocity of the object is 12.25 m/s. In determining the speed, the error value of the Euler method is greater at 17.5800 % while the Runge Kutta Order 4 method only reaches 0.02425 %. Similarly, in determining the distance, the highest error value obtained by the Runge Kutta Order 4 method reached 13.7655% while the error value of the Euler method reached 0.113%. In the case of free fall motion that is influenced by quadratic drag, it is known that the coefficient of air friction b = 0.001225kg/m, m = 0.51kg, = 0.5s and g = 9.8 m/s2, the terminal velocity of the object is 34.64 m/s. In determining the speed value using the numerical method, the error value of the Euler method reaches 3.616% and the Runge Kutta Order 4 method reaches 0.0008%. The results of the research show that numerical models are easier to work with using spreadsheets because they use large arithmetic calculations. The level of accuracy of the Runge Kutta Order 4 method is more accurate than the Euler method</dc:description>
	<dc:publisher xml:lang="en-US">Pendidikan Fisika FKIP Universitas Halu Oleo</dc:publisher>
	<dc:contributor xml:lang="en-US"></dc:contributor>
	<dc:date>2021-10-14</dc:date>
	<dc:type>info:eu-repo/semantics/article</dc:type>
	<dc:type>info:eu-repo/semantics/publishedVersion</dc:type>
	<dc:type xml:lang="en-US">Peer-reviewed Article</dc:type>
	<dc:format>application/pdf</dc:format>
	<dc:identifier>https://ojs.uho.ac.id/index.php/IJPiA/article/view/27245</dc:identifier>
	<dc:source xml:lang="en-US">Indonesian Journal of Physics and its Applications; Vol 1, No 2 (2021): EDISI SEPTEMBER 2021; 64-68</dc:source>
	<dc:source>2775-9903</dc:source>
	<dc:language>eng</dc:language>
	<dc:relation>https://ojs.uho.ac.id/index.php/IJPiA/article/view/27245/15956</dc:relation>
	<dc:rights xml:lang="en-US">Copyright (c) 2021 Indonesian Journal of Physics and its Applications</dc:rights>
	<dc:rights xml:lang="en-US">http://creativecommons.org/licenses/by-nc/4.0</dc:rights>
</oai_dc:dc>