Araştırma Makalesi
BibTex RIS Kaynak Göster

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

Yıl 2019, Cilt: 36 Sayı: 1, 1 - 9, 30.04.2019
https://doi.org/10.13002/jafag4461

Öz

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.

Kaynakça

  • Carlson Agster by Carlson Software Inc. (2018). www. carlsonsw. com/ solutions/ agriculture/agstar/ .
  • Chugg, G. E. 1947. Calculations for Land Gradation. Agricultural Engineering 28(10): 461-463.
  • Çınar, H. 1982. Arazi Tesviyesi. Köy İşleri ve Kooperatifler Bakanlığı Topraksu Genel Müdürlüğü Yayınları. Ankara.
  • Ditch Assist by Botterill Sales (2018). https://ditchassist.com .
  • Ezigrade by Foresoft Pty. Ltd. (2018). www.foresoft.com/cds_ezigrade.php .
  • Gebre-Selassie, N.A., and L.S. Willardson. 1991. Application of least-squares land leveling. Journal of Irrigation and Drainage Engineering 117(6): 962-966.
  • Givan, G. E. (1940). Land grading calculations. Agric. Eng., 21(1), 11-12.
  • Güngör, Y. ve O. Yıldırım. 1989. Tarla Sulama Sistemleri Kitabı. Ankara Üniversitesi Ziraat Fakültesi. 350 s.
  • Korukçu, A. 1981. Tarımsal Arazilerin Sulamaya Hazırlanmasında Doğrusal Programlama Tekniğinden Yararlanma Olanakları. Yöneylem Araştırması VII. Ulusal Kongresi. 2-4 Eylül 1981. İstanbul. 17 s.
  • MultiPlane Land-Farming Design Software by Lasemen Inc. (2018). www.lasermonca.com/catalog/agriculture/mapping-and-gis-software/ .
  • OptiSurface by Davco Farming (2018). www.optisurface.com .
  • Reddy, S. L. 1996. Optimal land grading based on genetic algorithms. Journal of Irrigation and Drainage Engineering. 122(4): 183-188 .
  • SCS (U.S. Soil Conservation Service). 1961. Land Leveling, In: Irrigation, National Engineering Handbook, Sect. 15, Chap. 12, Washington, DC.
  • Walker, W.R., and Skogerboe, G.V. 1987. Surface Irrigation: Theory and Practice. Prentice Hall, Englewood Cliffs, New Jersey, 386 p.
  • Yıldırım, O. 2013. Sulama Sistemlerinin Tasarımı. Ankara Üniversitesi Ziraat Fakültesi, Yayın No: 1594, Ders Kitabı: 546 (4. Baskı), 367 s.
Yıl 2019, Cilt: 36 Sayı: 1, 1 - 9, 30.04.2019
https://doi.org/10.13002/jafag4461

Öz

Kaynakça

  • Carlson Agster by Carlson Software Inc. (2018). www. carlsonsw. com/ solutions/ agriculture/agstar/ .
  • Chugg, G. E. 1947. Calculations for Land Gradation. Agricultural Engineering 28(10): 461-463.
  • Çınar, H. 1982. Arazi Tesviyesi. Köy İşleri ve Kooperatifler Bakanlığı Topraksu Genel Müdürlüğü Yayınları. Ankara.
  • Ditch Assist by Botterill Sales (2018). https://ditchassist.com .
  • Ezigrade by Foresoft Pty. Ltd. (2018). www.foresoft.com/cds_ezigrade.php .
  • Gebre-Selassie, N.A., and L.S. Willardson. 1991. Application of least-squares land leveling. Journal of Irrigation and Drainage Engineering 117(6): 962-966.
  • Givan, G. E. (1940). Land grading calculations. Agric. Eng., 21(1), 11-12.
  • Güngör, Y. ve O. Yıldırım. 1989. Tarla Sulama Sistemleri Kitabı. Ankara Üniversitesi Ziraat Fakültesi. 350 s.
  • Korukçu, A. 1981. Tarımsal Arazilerin Sulamaya Hazırlanmasında Doğrusal Programlama Tekniğinden Yararlanma Olanakları. Yöneylem Araştırması VII. Ulusal Kongresi. 2-4 Eylül 1981. İstanbul. 17 s.
  • MultiPlane Land-Farming Design Software by Lasemen Inc. (2018). www.lasermonca.com/catalog/agriculture/mapping-and-gis-software/ .
  • OptiSurface by Davco Farming (2018). www.optisurface.com .
  • Reddy, S. L. 1996. Optimal land grading based on genetic algorithms. Journal of Irrigation and Drainage Engineering. 122(4): 183-188 .
  • SCS (U.S. Soil Conservation Service). 1961. Land Leveling, In: Irrigation, National Engineering Handbook, Sect. 15, Chap. 12, Washington, DC.
  • Walker, W.R., and Skogerboe, G.V. 1987. Surface Irrigation: Theory and Practice. Prentice Hall, Englewood Cliffs, New Jersey, 386 p.
  • Yıldırım, O. 2013. Sulama Sistemlerinin Tasarımı. Ankara Üniversitesi Ziraat Fakültesi, Yayın No: 1594, Ders Kitabı: 546 (4. Baskı), 367 s.
Toplam 15 adet kaynakça vardır.

Ayrıntılar

Birincil Dil İngilizce
Bölüm Araştırma Makaleleri
Yazarlar

Mustafa Alkan Bu kişi benim

Tekin Öztekin Bu kişi benim

Yayımlanma Tarihi 30 Nisan 2019
Yayımlandığı Sayı Yıl 2019 Cilt: 36 Sayı: 1

Kaynak Göster

APA Alkan, M., & Öztekin, T. (2019). A Research on the Usage of Least Squares Land Grading Design Method in Microsoft Excel. Journal of Agricultural Faculty of Gaziosmanpaşa University (JAFAG), 36(1), 1-9. https://doi.org/10.13002/jafag4461