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

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

notto 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 solveyourproblems

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*