Application of MS Excel to Estimate Power Needs of Tillage Tools

Document Type : Short Paper- en

Author

• I. Ahmadi

Department of Plant Production and Genetics Engineering, Isfahan (Khorasgan) Branch, Islamic Azad University, Isfahan, Irany

https://doi.org/10.22067/jam.v11i1.78519

Abstract

This study deals with the application of the Microsoft Excel for the estimation of the power requirements of some tillage implements. The mathematical formulas embedded in the spreadsheet file have been developed in the previously published papers; however, those formulas were augmented herein in order to contain some agricultural mechanization issues. Another feature of this article is the ability of the spreadsheet to generate trend curves automatically. The comparison of the power expenditure aspects of different tillage implements as well as the inspection of the effect of an arbitrary selected input parameter on the spreadsheet outputs were effectively performed. Numerically, the specific work of the rotary tiller was estimated two times to five times higher than the specific work of drawing implements. Furthermore, as an example of trend curves derived in this article, the increase in disc angle in the range of 25° to 70° reduced the draft and power needs of the disc plow by 66% and 54%, respectively. However, it increased the disc plow specific draft and power by 34% and21%, respectively.

Keywords

• Draft force
• Excel software
• Mechanical power
• Tillage implements

20.1001.1.22286829.1400.11.1.10.3

Open Access

©2020 The author(s). This article is licensed under Creative Commons Attribution 4.0 International License (CC BY 4.0), which permits use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source.

References

1. Ahmadi, I. 2016a. Development and assessment of a draft force calculator for disk plow using the laws of classical mechanics. Soil and Tillage Research 163: 32-40.

2. Ahmadi, I. 2016b. Development and evaluation of a draft force calculator for moldboard plow using the laws of classical mechanics. Soil and Tillage Research 161: 129-134.

3. Ahmadi, I. 2017a. A torque calculator for rotary tiller using the laws of classical mechanics. Soil and Tillage Research 165: 137-143.

4. Ahmadi, I. 2017b. Development of the chisel plow draft force and power calculator based on some mechanical laws. Iranian Journal of Biosystems Engineering 47 (4): 625-632. (In Farsi).

5. Ahmadi, I. 2017c. Effect of soil, machine, and working state parameters on the required draft force of a subsoiler using a theoretical draft-calculating model. Soil Research 55: 389-400.

6. Ahmadi, I. 2018. A draught force estimator for disc harrow using the laws of classical soil mechanics. Biosystems Engineering 171: 52-62.

7. Ahmadi, I., and M. Beigi. 2018. An estimator for torque and draft force requirements of a new up-cut rotary tiller. Journal of Agricultural Machinery. https://doi.org/10.22067/jam.v10i1. 71744. (In Farsi).

8. Anpat, R. M., and H. Raheman. 2017. Investigations on power requirement of active-passive combination tillage implement. Engineering in Agriculture, Environment and Food 10: 4-13.

9. ASAE Standards. 2000. D497.4, Agricultural machinery management data. ASAE, St. Joseph, MI.

10. Bentaher, H., E. Hamza, G. Kantchev, A. Maalej, and W. Arnold. 2008. Three-point hitch-mechanism instrumentation for tillage power optimization. Biosystems Engineering 100: 24-30.

11. Godwin, R. J., and M. J. O’Dogherty. 2007. Integrated soil tillage force prediction models. Journal of Terramechanics 44: 3-14.

12. Grisso, R. D., J. V. Perumpral, and F. M. Zoz. 2007. Spreadsheet for Matching Tractors and Drawn Implements. Applied Engineering in Agriculture 23 (3): 259-265.

13. Jones, D., and R. D. Grisso. 1992. Golden section search as an optimization tool for spreadsheets. Computers and Electronics in Agriculture 7 (4): 323-335.

14. Karmakar, S., and R. L. Kushwaha. 2006. Dynamic modeling of soil–tool interaction: an overview from a fluid flow perspective. Journal of Terramechanics 43: 411-425.

15. Niazkar, M., and S. H. Afzali. 2015. Application of Excel spreadsheet in engineering education. First International and Fourth National Conference on Engineering Education, Shiraz University, 10-12 November 2015.

16. Okayasu, T., K. Morishita, H. Terao, M. Mitsuoka, E. Inoue, and K. O. Fukami. 2012. Modeling and prediction of soil cutting behavior by a plow. In: CIGR-Ag Eng, Int. Conf. Agricult. Eng., “Agriculture and Engineering for a Healthier Life”, pp. 23, Valencia, July 8-12. ISBN-10: 84-615-9928-4.

17. Oke, S. A. 2004. Spreadsheets applications in engineering education – A review. International Journal of Engineering Education 20 (6): 893-901.

18. Shmulevich, I. 2010. State of the art modeling of soil–tillage interaction using discrete element method. Soil and Tillage Research 111: 41-53.

19. Srivastava, A. K., C. E. Goering, R. P. Rohrbach, and D. R. Buckmaster. 2006. Engineering Principles of Agricultural Machines, second ed. ASAE Publication, USA.

20. Zoz, F. M., and R. D. Grisso. 2003. Traction and tractor performance. ASAE Distinguished Lecture Series #27. St. Joseph, MI: ASAE.