Keywords: Advanced Excel, scientific data analysis, free Excel macros downloads, MacroBundle, Xnumbers, extended-precision Excel, least squares macros, Fourier transform macros

Robert de Levie's Page

Robert de Levie

Keywords: Advanced Excel, scientific data analysis, free Excel macros downloads, MacroBundle, Xnumbers, extended-precision Excel, least squares macros, Fourier transform macros

If you found this web site while looking for a site devoted to free Excel macros,
to Volpi's estensive add-in functions facilitating the use of Excel for matrix algebra, or to
a description of his toolset for extended numberlength in Excel far beyond its standard
"double precision", click here to go to www.bowdoin.edu/~rdelevie/excellaneous/.

If your interests are elsewhere, here are some other tidbits.

Curriculum vitae:

Robert de Levie was born and raised in Amsterdam, the Netherlands, and earned his Ph.D. in physical chemistry at the University of Amsterdam. He was a postdoctoral fellow with Paul Delahay at LSU in Baton Rouge LA for two years, and then for 34 years taught analytical chemistry and electrochemistry at Georgetown University in Washington DC. For ten of those years he was the US editor of the Journal of Electroanalytical Chemistry. Now an emeritus professor, he lives on Orr's Island, and is associated with Bowdoin College in nearby Brunswick ME.

Recent publications (1999-2012):

Books:

R. de Levie, Advanced Excel for scientific data analysis, Oxford University Press, New York (2004) 625 pages; 2nd ed. (2008) 707 pages; 3nd ed., Atlantic Academic (2012) 646 large pages.
R. de Levie, How to use Excel in analytical chemistry and in general scientific data analysis, Cambridge Univ. Press (2001) 487 pages.
R. de Levie, Aqueous acid-base equilibria and titrations, Oxford Chemistry Primer, Oxford Univ. Press (1999), 96 pages.

Journal articles:

R. de Levie, A pH centenary, Electrochim. Acta 135 (2014) 604-639.
R. de Levie, Nonisothermal analysis of solution kinetics by spreadsheet simulation, J. Chem. Educ. 89 (2012) 79-86.
R. de Levie, Collinearity in linear least squares analysis, J. Chem. Educ. 89 (2012) 68-78.
R. de Levie, Potentiometric pH measurements of acidity are approximations, some more useful than others, J. Chem. Educ. 87 (2010) 1188-1194.
W. G. Hines & R. de Levie, The early development of electronic pH meters, J. Chem. Educ. 87 (2010) 1143-1153.
R. de Levie, Spectrometric mixture analysis: an unexpected wrinkle, J. Chem. Sci. 121 (2009) 617-627, freely accessible at http://www.ias.ac.in/chemsci/Pdf-Sep2009/617.pdf. Supporting documentation downloadable from the Downloads section of my Excellaneous website.
R. de Levie, An improved numerical approximation for the first derivative, J. Chem. Sci. 121 (2009) 935-950, freely accessible at http://www.ias.ac.in/chemsci/Pdf-Sep2009/935.pdf.
R. de Levie, S. K. Rangarajan, Resonance 13 (2008) 1093-1095, freely accessible at http://www.ias.ac.in/resonance/December2008/p1093-1095.pdf.
K. L. Sebastian & R. de Levie, S. K. Rangarajan, a tribute, J. Electroanal. Chem. 624 (2008) 333-340.
R. de Levie, Linear least squares, the spreadsheet, and Filip, Am. J. Phys. 75 (2007) 619-628.
R. de Levie, How to compute labile metal-ligand equilibria, J. Chem. Educ. 84 (2007) 136-141.
R. de Levie, On isohydric solutions and buffer pH, J. Electroanal. Chem. 582 (2005) 21-27.
R. de Levie, Ionic activity effects in reaction kinetics: what happened with the parsimony principle?, J. Chem. Educ. 82 (2005) 885-888.
R. de Levie, On teaching ionic activity effects: what, when, and where?, J. Chem. Educ. 82 (2005) 878-884.
R. de Levie, On deconvolving spectra, Am. J. Phys. 72 (2004) 910-915.
R. de Levie, Estimating precision in derived quantities, Chem. Educator 9 (2004) 80-88.
R. de Levie, Tidal analysis on a spreadsheet, Am. J. Phys. 72 (2004) 644-651.
R. de Levie, Partial charge transfer and electrosorption valency, J. Electroanal. Chem. 562 (2004) 273-276.
R. de Levie, On some electrochemical oscillators at the mercury/water interface, J. Electroanal. Chem. 552 (2003) 223-229.
R. de Levie, G. Frison & A. Calatroni, Solving pH problems on a spreadsheet, Chem. Educator 8 (2003) 298-302.
R. de Levie, Two linear correlation coefficients, J. Chem. Educ. 80 (2003) 1030-1032.
R. de Levie, The Henderson approximation and the mass action law of Guldberg and Waage, Chem. Educator 7 (2002) 132-135.
R. de Levie, Spreadsheet simulation of chemical kinetics, Crit. Revs. Anal. Chem. 32 (2002) 97-107.
C. Salter & R. de Levie, Nonlinear fits of standard curves: a simple route to uncertainties in unknowns, J. Chem. Educ. 79 (2002) 268-271.
R. de Levie, The formalism of titration theory, Chem. Educator 6 (2001) 272-276.
R. de Levie, Linear graphs for understanding acid-base titration curves, Chem. Educator 6 (2001) 210-216.
R. de Levie, Stochastics, the basis of chemical dynamics, J. Chem. Educ. 77 (2000) 771-774.
R. de Levie, What's in a name?, J. Chem. Educ. 77 (2000) 610-612.
R. de Levie, Spreadsheet calculation of the propagation of experimental imprecision, J. Chem. Educ. 77 (2000) 534-535.
R. de Levie, Curve fitting with least squares, Crit. Revs. Anal. Chem. 30 (2000) 59-74.
R. de Levie, The electrolysis of water, J. Electroanal. Chem. 476 (1999) 92-93.
R. de Levie, Estimating parameter precision in non-linear least squares with Excel's Solver, J. Chem. Educ. 76 (1999) 1594-1598.
R. de Levie, A general simulator for acid-base titrations, J. Chem. Educ. 76 (1999) 987-991.
M. Hromadova & R. de Levie, A sodium-specific condensed film of a -cyclodextrin at the mercury/water interface, J. Electroanal. Chem. 465 (1999) 51-62.
R. de Levie, Redox buffer strength, J. Chem. Educ. 76 (1999) 574-577.
R. de Levie, A comment on partial overvoltages, Elektrokhimiya 35 (1999) 142-144.
R. de Levie, Gouy , Debye-Hückel, and Fick: Understanding a differential equation without solving it, J. Chem. Educ. 76 (1999) 129-132.

Letters to the editor:

R. de Levie, What do the authors and readers want?, J. Chem. Educ.86 (2009) 1031-1032.
R. de Levie, Visualizing statistical concepts, J. Chem. Educ. 85 (2008) 635.
R. de Levie, Grade inflation and scientific literacy, Chem. Engin. News, Dec. 13, 2004 pp. 3-4.
R. de Levie, Enterprise: yes; electrolysis: no, Chem. World, March 2004 p. 22.
R. de Levie, Citation ciphers, Chem. Engin. News, Sept. 8, 2003 p. 10.
R. de Levie, The Henderson-Hasselbalch equation: its history and limitations, J. Chem. Educ. 80 (2003) 146.
R. de Levie, Galvani, J. Chem. Educ. 76 (1999) 320.

Seminar presentations:

Titration vs. tradition: when not to approximate (undergraduate level)
Computers, accuracy, precision, and the number of significant digits (undergraduate level)
The pH centenary: past, present, and future (graduate level)

Recent one-semester courses taught:

Scientific data analysis
Quantitative chemical analysis
Instrumental analysis

Recent one-day intensive short courses taught:

Advanced Excel I: Linear least squares, nonlinear least squares, and the propagation of imprecision
Advanced Excel II: Writing custom functions and macros to make Excel solve your problems
Advanced Excel III: Extending Excel far beyond Microsoft: linear algebra and superprecision

How to reach me:

My e-mail address is rdelevie@bowdoin.edu

 

last updated: December 2012