Download

Sorption Isotherm Spreadsheet

---

Welcome to the software download area! Please contact us if you have problems or questions.

Download Available

---

Spreadsheet from the paper entitled: On the Use of Linearized Langmuir Equations by C.H. Bolster and G.M. Hornberger, Soil Science Society of America Journal, 2007, 71(6): 1796-1806.

Spreadsheet has been modified to correct the following errors:

(11/01/12)

In earlier versions the initial guess for the n parameter in the Freundlich model did not update when data were added to spreadsheet. This has now been corrected in the new vesrion (1.6)

(3/17/10)

1. In the original spreadsheet the L-F model (Eq. [2]) did not have the K value raised to the n power. The attached spreadsheet has corrected this.
2. There was a typo in the units with the Langmuir K parameter in the spreadsheet. The units should have read L/mg rather than L/kg when C is in mg/L. To avoid confusion, in the updated version the units have been removed since they are dependent on the units used for C and S.
3. I have recently shown that the traditional method of weighting data by the inverse of the variance in the dependent variable can lead to poorer parameter estimates and uncertainties than with unweighted least squares regression when applied to sorption data (C.H. Bolster and J. Tellinghuisen. 2010. On the Significance of Properly Weighting Sorption Data for Least-Squares Analysis. Soil Science Society of America 74:670-679). Therefore, the weighting option has been removed from the spreadsheet (3/2010). If weighting of data is needed, please contact me at carl.bolster@ars.usda.gov for a modified version of the spreadsheet.
4. w_iin the denominator in Eq. [5] of Bolster and Hornberger (2007 SSSAJ) should be outside of the parenthesis. (This only applies to weighted data and therefore is not applicable to current spreadsheet)

 

---

Download Form

Please complete the form below to track the use of the service we are providing and to help improve our product.
OMB 0518 - 0032 (01/2025)

First Name
Last Name
Middle
Email*
Affiliation
City
State	Select... Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas U.S. Territories Utah Vermont Virginia Washington Washington D.C. West Virginia Wisconsin Wyoming
Country	Select... United States Afganistan Albania Algeria Andorra Angola Anitgua and Barbuda Argentina Armenia Australia Azerbaijan Bahamas Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bhutan Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Central African Republic Chad Chile China Colombia Comoros Congo (Brazzaville) Congo, Democratic Republic of the Costa Rica Croatia Cuba Cyprus Czech Republic Cote d'Ivoire Denmark Djibouti Dominica Dominican Republic East Timor Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia Fiji Finland France Gabon Gambia, The Georgia Germany Ghana Greece Grenada Guatemala Guinea Guinea-Bissau Guyana Haiti Honduras Hungary Iceland India Indonesia Iran Iraq Ireland Israel Italy Jamaica Japan Jordan Kazakhstan Kenya Kiribati Kuwait Kyrgyzstan Laos Latvia Lebanon Lesotho Liberia Libya Liechtenstein Lithuania Luxembourg Macedonia Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Maritania Mauritius Mexico Micronesia, Federated States of Moldova Monaco Mongolia Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands New Zealand Nicaragua Niger Nigeria North Korea Norway Oman Pakistan Palau Panama Papua New Guinea Paraguay Peru Philippines Poland Portugal Qatar Romania Russia Rwanda St. Kitts and St. Nevis St. Lucia St. Vincent and The Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia and Montenegro Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Korea Spain Sri Lanka Sudan Suriname Swaziland Sweden Switzerland Syria Taiwan Tajikistan Tanzania Thailand Togo Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Tuvalu Uganda Ukraine United Arab Emirates United Kingdom Uruguay Uzbekistan Vanuatu Vatican City Venezuela Vietnam Western Sahara Yemen Zambia Zimbabwe
Reference	Select... Publication or Other Source No Prior Knowledge Colleague or Friend Upgrading from an Older Version
Purpose	Select... Field Research Farming Software Development Teaching
Comments

Take me to the download...

According to the Paperwork Reduction Act of 1995, an agency cannot conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a valid OMB control number. The valid OMB control number for this information collection is 0518-0032. The time required to complete this information is estimated to vary from one to five minutes with an average of three minutes per response, including time for reviewing instructions, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Department of Agriculture, Clearance Officer, OIRM, Room 404-W, Washington, DC 20250, and to the Office of Information and Regulatory Affairs, Office of Management and Budget.