Melola Discovery

← Melola Discovery

Open access Journal

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

23 authors · 45 co-authorship links

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

  • Universitas Halu Oleo
  • 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
Hunaidah HunaidahUniversitas Halu Oleo1
Arif Setia WibawaAffiliation unknown1
Vivi HastutiAffiliation unknown1
Suci Kris LukmanaAffiliation unknown1
La Ode RusmanAffiliation unknown1
Fahyuddin FahyuddinAffiliation unknown1
Mardi YunusAffiliation unknown1
Jahidin JahidinAffiliation unknown1
Sitti AsrianiAffiliation unknown1
I Nyoman SudianaAffiliation unknown1
Amran AmranAffiliation unknown1
Muhammad AnasUniversitas Halu Oleo1
Lindawati LindawatiAffiliation unknown1
Asih Nofriasih KalamAffiliation unknown1
Satria BijaksanaAffiliation unknown1
Gerald TamuntuanAffiliation unknown1
Edy GaffarAffiliation unknown1
James RussellAffiliation unknown1
Estavanus HuliselanAffiliation 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 Oct 2026, last seen 8 Nov 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>