Beer-Lambert Law Spreadsheet Simulations

Introduction

The Beer-Lambert (Beer's) law and the definitions of transmittance are usually memorized. The attenuation of light as it passes through an absorbing substance is Demonstrating why absorbance is a log function is straightforward and can be connected to radioactive decay and kinetics.

For more details and a related derivation, see the reference document on the Beer-Lambert law.


Beer Lambert Simulation

The spreadsheet displays the following:

beers law screen

The path length of the two curves must be the same since they are plotted on the same chart.

The spreadsheet also has a data entry for Po, which is listed as the number of photons. This could equally well be light power in watts or light intensity. This parameter is included for added flexibility. The Po value does not affect the resulting values of T, %T, or A.


Self-study Exercises

epsilonredepsilonbluecredcblue
14000 M-1cm-12000 M-1cm-11e-4 M1e-4 M
26000 M-1cm-12000 M-1cm-11e-4 M1e-4 M
36000 M-1cm-16000 M-1cm-14e-4 M1e-4 M
46000 M-1cm-16000 M-1cm-16e-4 M1e-4 M

Determine the maximum absorbance that can be measured for the following experimental parameters:

Determine the minimum absorbance that can be measured for the following experimental parameters:


 Top of Page   
 Copyright © 2000 by Brian M. Tissue, all rights reserved.