PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data
Конференцијски прилог (Објављена верзија)
Метаподаци
Приказ свих података о документуАпстракт
Soil investigations in pedology are often made of four different stages: a) preliminary stage, b) on-field soil research, c) laboratory (analytical) research and d) data elaboration. Depending on the aim of soil investigations each of these stages can last for a different amount of time. On-field soil research is the central part of soil surveys. It consists of soil profile excavation, description of soil profiles and collection of soil samples. Experienced soil scientists can vast a lot of time in description of soil ectomorphological and endomorphological properties, whereas un-experienced soil scientists move often fastly over this stage to soil sampling. The description of soil profile is of the essential importance in soil surveys and a huge number of soil information can be collected while describing soil profiles. Soil description is often done manually by filling soil forms, but it is somewhere digitized. It is also a time–consuming job how to prepare those data for the further... elaborations, often how to make them digitized. Another important issue in front of the researcher is how to present a large number of soil characteristics and to elaborated data in fast and efficient manner. Therefore, this necessity of being most efficient in soil data elaboration has forced us to prepare a simple Еxcel based tool to fastly retype and elaborate soil profile data. Pedo–Excel is based on FAO Guideline for soil description. General information, soil formation factors, and soil description headings with the different number of soil characteristics are offered to the users in drop down menues, which are specific for each soil characteristics. The user simply inserts collected data by choosing them from the menues. By this manner, the users can fill the columns for all soil horizons/layers and re-type the data for whole soil profile(s). Soil characteristics are provided with their full names and used abbreviations. Data elaboration in Pedo–Excel starts with the simple choice which of the soil characteristics should be presented in our work, by simple choosing of ’’1’’ (yes) or ’’0’’ (no) into the column next to the characteristic. The result of this choice is an Excel table with chosen soil characteristics. Each soil sheet presents one soil profile with up to ten soil horizons/layers. Almost all soil characteristics presented in FAO Guideline are part of the Pedo–Excel. Pedo–Excel is a simple, user friendly, and time efficient tool for elaboration of huge series of soil profile data collected during soil surveys.
Кључне речи:
soil description / pedology / soil morphology / MS Excel tool / data elaborationИзвор:
3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings, 2021, 14-Издавач:
- Serbian Society of Soil Science
Институција/група
Poljoprivredni fakultetTY - CONF AU - Knežević, Mirko AU - Topalović, Ana AU - Životić, Ljubomir PY - 2021 UR - http://aspace.agrif.bg.ac.rs/handle/123456789/6734 AB - Soil investigations in pedology are often made of four different stages: a) preliminary stage, b) on-field soil research, c) laboratory (analytical) research and d) data elaboration. Depending on the aim of soil investigations each of these stages can last for a different amount of time. On-field soil research is the central part of soil surveys. It consists of soil profile excavation, description of soil profiles and collection of soil samples. Experienced soil scientists can vast a lot of time in description of soil ectomorphological and endomorphological properties, whereas un-experienced soil scientists move often fastly over this stage to soil sampling. The description of soil profile is of the essential importance in soil surveys and a huge number of soil information can be collected while describing soil profiles. Soil description is often done manually by filling soil forms, but it is somewhere digitized. It is also a time–consuming job how to prepare those data for the further elaborations, often how to make them digitized. Another important issue in front of the researcher is how to present a large number of soil characteristics and to elaborated data in fast and efficient manner. Therefore, this necessity of being most efficient in soil data elaboration has forced us to prepare a simple Еxcel based tool to fastly retype and elaborate soil profile data. Pedo–Excel is based on FAO Guideline for soil description. General information, soil formation factors, and soil description headings with the different number of soil characteristics are offered to the users in drop down menues, which are specific for each soil characteristics. The user simply inserts collected data by choosing them from the menues. By this manner, the users can fill the columns for all soil horizons/layers and re-type the data for whole soil profile(s). Soil characteristics are provided with their full names and used abbreviations. Data elaboration in Pedo–Excel starts with the simple choice which of the soil characteristics should be presented in our work, by simple choosing of ’’1’’ (yes) or ’’0’’ (no) into the column next to the characteristic. The result of this choice is an Excel table with chosen soil characteristics. Each soil sheet presents one soil profile with up to ten soil horizons/layers. Almost all soil characteristics presented in FAO Guideline are part of the Pedo–Excel. Pedo–Excel is a simple, user friendly, and time efficient tool for elaboration of huge series of soil profile data collected during soil surveys. PB - Serbian Society of Soil Science C3 - 3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings T1 - PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data SP - 14 UR - https://hdl.handle.net/21.15107/rcub_agrospace_6734 ER -
@conference{ author = "Knežević, Mirko and Topalović, Ana and Životić, Ljubomir", year = "2021", abstract = "Soil investigations in pedology are often made of four different stages: a) preliminary stage, b) on-field soil research, c) laboratory (analytical) research and d) data elaboration. Depending on the aim of soil investigations each of these stages can last for a different amount of time. On-field soil research is the central part of soil surveys. It consists of soil profile excavation, description of soil profiles and collection of soil samples. Experienced soil scientists can vast a lot of time in description of soil ectomorphological and endomorphological properties, whereas un-experienced soil scientists move often fastly over this stage to soil sampling. The description of soil profile is of the essential importance in soil surveys and a huge number of soil information can be collected while describing soil profiles. Soil description is often done manually by filling soil forms, but it is somewhere digitized. It is also a time–consuming job how to prepare those data for the further elaborations, often how to make them digitized. Another important issue in front of the researcher is how to present a large number of soil characteristics and to elaborated data in fast and efficient manner. Therefore, this necessity of being most efficient in soil data elaboration has forced us to prepare a simple Еxcel based tool to fastly retype and elaborate soil profile data. Pedo–Excel is based on FAO Guideline for soil description. General information, soil formation factors, and soil description headings with the different number of soil characteristics are offered to the users in drop down menues, which are specific for each soil characteristics. The user simply inserts collected data by choosing them from the menues. By this manner, the users can fill the columns for all soil horizons/layers and re-type the data for whole soil profile(s). Soil characteristics are provided with their full names and used abbreviations. Data elaboration in Pedo–Excel starts with the simple choice which of the soil characteristics should be presented in our work, by simple choosing of ’’1’’ (yes) or ’’0’’ (no) into the column next to the characteristic. The result of this choice is an Excel table with chosen soil characteristics. Each soil sheet presents one soil profile with up to ten soil horizons/layers. Almost all soil characteristics presented in FAO Guideline are part of the Pedo–Excel. Pedo–Excel is a simple, user friendly, and time efficient tool for elaboration of huge series of soil profile data collected during soil surveys.", publisher = "Serbian Society of Soil Science", journal = "3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings", title = "PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data", pages = "14", url = "https://hdl.handle.net/21.15107/rcub_agrospace_6734" }
Knežević, M., Topalović, A.,& Životić, L.. (2021). PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data. in 3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings Serbian Society of Soil Science., 14. https://hdl.handle.net/21.15107/rcub_agrospace_6734
Knežević M, Topalović A, Životić L. PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data. in 3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings. 2021;:14. https://hdl.handle.net/21.15107/rcub_agrospace_6734 .
Knežević, Mirko, Topalović, Ana, Životić, Ljubomir, "PEDO–EXCEL: A Simple Excel Tool/Database to Prepare and Elaborate Soil Profile Data" in 3rd International and 15th National Congress of Serbian Society of Soil Science: Soils for Future under Global Challenges, Sokobanja, Serbia, 21-24 September 2021, Book of Proceedings (2021):14, https://hdl.handle.net/21.15107/rcub_agrospace_6734 .