Data set for the article: Analytical model of duckfoots draft force prediction based on soil parameters and technical tools, and its validation in laboratory conditions

It was hypothesized that the developed mathematical model, which takes into account dynamic soil interactions and nonlinear soil-tool interactions, would allow for more accurate prediction of forces in a 2D system under various soil conditions than existing models. The dataset represents the results of soil bin tests, which were used to validate the model. The dataset includes results of force components acting on duckfoot tools with widths of 105, 133, and 202 mm, combined with S and Vibro Crop (VCO) spring tines with stiffnesses of 5.3 and 8.3 kN m–1, respectively. Experiments were conducted in a soil bin filled with loamy sand with moisture contents of 10% and 14% and a compaction of 486 kPa, with duckfoot depths of 30, 50, and 70 mm, and operating speeds of 0.84, 1.67, and 2.31 m s–1. Predictive draught forces were calculated taking into account the determined optimal values of the internal soil friction angles, external soil-tool friction angles, and tool settings using the Solver module in MS Excel. Individual Excel columns are labeled consistently with the list in the article, making the spreadsheet easier to follow. Both Excel files are linked. File organization: There are two coherent files: Models.xlsx, Models-figures.xlsx, and one auxiliary file: SingleTineForces-R2_DL.xls. The Models.xlsx and Models-figures.xlsx files are interconnected, and in this case, the Models.xlsx file appears first in the data analysis.本研究假设，所开发的考虑土壤动态相互作用与非线性土壤-机具相互作用的数学模型，相较于现有模型，可在多种土壤条件下更精准地预测二维系统中的受力情况。本数据集收录了用于验证该模型的土槽试验结果，涵盖幅宽分别为105 mm、133 mm与202 mm的鸭脚式机具（duckfoot tools），搭配刚度分别为5.3 kN·m⁻¹与8.3 kN·m⁻¹的S型与Vibro Crop (VCO)弹性齿的受力分量结果。试验在装填壤质砂土的土槽中开展，土壤含水率分别为10%与14%，密实度为486 kPa；鸭脚式机具的入土深度设置为30 mm、50 mm与70 mm，作业速度设置为0.84 m·s⁻¹、1.67 m·s⁻¹与2.31 m·s⁻¹。借助Microsoft Excel中的Solver求解器模块，结合确定的土壤内摩擦角、土壤-机具外摩擦角最优值以及机具配置参数，计算得到预测牵引阻力。Excel表格的各列均与论文中的列表保持一致标注，便于使用者梳理数据逻辑，且两份Excel文件相互关联。文件组织：包含两个关联紧密的文件：Models.xlsx、Models-figures.xlsx，以及一个辅助文件SingleTineForces-R2_DL.xls。其中Models.xlsx与Models-figures.xlsx存在数据联动关系，数据分析流程中优先采用Models.xlsx文件。