Skip to content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

Sorption Isotherm Spreadsheet

Metadata Updated: November 10, 2020

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)

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. 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. 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 for a modified version of the spreadsheet. wiin the denominator in Eq. [5] of Bolster and Hornberger (2007 SSSAJ) should be outside of the parenthesis. (This only applies to weighted dat

a and therefore is not applicable to current spreadsheet) This research was originally part of the former USDA-ARS National Program 206: Manure and By-product Utilization.

Access & Use Information

Public: This dataset is intended for public access and use. License: Creative Commons CCZero

Downloads & Resources


Metadata Created Date November 10, 2020
Metadata Updated Date November 10, 2020

Metadata Source

Harvested from USDA JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date November 10, 2020
Metadata Updated Date November 10, 2020
Publisher Agricultural Research Service
Identifier 7ab5ee83-29d0-4f80-9216-43da69adb5af
Data Last Modified 2019-08-05
Public Access Level public
Bureau Code 005:18
Metadata Context
Schema Version
Catalog Describedby
Harvest Object Id 34b3e57e-0032-4033-a4d6-6833dc46040b
Harvest Source Id d3fafa34-0cb9-48f1-ab1d-5b5fdc783806
Harvest Source Title USDA JSON
Program Code 005:040
Source Datajson Identifier True
Source Hash a220b3552149520f0626f0117e45b0f2d2639c99
Source Schema Version 1.1

Didn't find what you're looking for? Suggest a dataset here.

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?