A Research on the Usage of Least Squares Land Grading Design Method in Microsoft Excel

Mustafa ALKAN; Tekin ÖZTEKİN

doi:https://doi.org/10.13002/jafag4461

Article Details

A Research on the Usage of Least Squares Land Grading Design Method in Microsoft Excel

Authors:

Mustafa ALKAN | Tekin ÖZTEKİN

Publisher:

Tokat Gaziosmanpasa University

Journal:

Journal of Agricultural Faculty of Gaziosmanpaşa University (JAFAG) 2019 Vol.36 Issue 1, pp.1-9

Document Type:

Article

Publication Date:

4/2019

Document Language:

English

Document ID (Org No.):

2000449101

Frequency:

Tri-annual

eISSN:

2147-8848

pISSN:

1300-2910

DOI:

https://doi.org/10.13002/jafag4461

Abstract:

 

The possibilities of automatic land grading design for the regular shaped (rectangular) fields using the Microsoft Excel 2010 with the least squares technique, have been investigated in this research. When the original level rod and area weighting factor at each grid point of field are entered, the program automatically performs the land grading design for the field in a very short time in contrast to the long calculations required for the conventional method. The cut or fill depths at each grid point, the grading type, the cut-fill volume distribution plan, and three-dimensional perspective views of the field before and after grading were given as the results of the design. The Microsoft Excel program developed with this study can be used for the fields formed with 10 rows by 10 columns with variable grid sizes. The developed program was applied to two different textbook examples, the same results were obtained.

Article Details

A Research on the Usage of Least Squares Land Grading Design Method in Microsoft Excel

Authors: Mustafa ALKAN | Tekin ÖZTEKİN

Publisher: Tokat Gaziosmanpasa University

Journal: Journal of Agricultural Faculty of Gaziosmanpaşa University (JAFAG) 2019 Vol.36 Issue 1, pp.1-9

Document Type: Article

Publication Date: 4/2019

Document Language: English

Document ID (Org No.): 2000449101

Frequency: Tri-annual

eISSN: 2147-8848

pISSN: 1300-2910

DOI: https://doi.org/10.13002/jafag4461

Issues

Authors:

Mustafa ALKAN | Tekin ÖZTEKİN

Publisher:

Tokat Gaziosmanpasa University

Journal:

Journal of Agricultural Faculty of Gaziosmanpaşa University (JAFAG) 2019 Vol.36 Issue 1, pp.1-9

Document Type:

Article

Publication Date:

4/2019

Document Language:

English

Document ID (Org No.):

2000449101

Frequency:

Tri-annual

eISSN:

2147-8848

pISSN:

1300-2910

DOI:

https://doi.org/10.13002/jafag4461