Dr. Don's
SPREADSHEET AND FILE ARCHIVE
(If I keep them here, even I won't misplace them) - updated 05/08/06
General Interest (Excel spreadsheets): STANDARD DISCLAIMER (use at your own peril, I usually need help finding the errors).
Convert latitude and longitude to UTM<note: works for USA maps, NAD27>
Convert UTM to Latitude and Longitude <note: works for USA maps, NAD27> the old version contains errors for those doing multiple conversions!
Mike's gravitational pull of sun and moon: not yet certified as correct by Dr.D.
Viewing seismograms from OhioSeis stations with Excel in Windows. Paste data from a 1-hour OhioSeis file into the "Data" sheet.
Schlumberger sounding: forward model <note: calculates apparent resistivity as function of AB/2>
Wenner sounding: Forward model <note: calculates apparent resistivity as function of "a"-spacing>
Magnetic dipole spreadsheet Magnetic dipole explanation
Data files for Geology 2030
Data files for Geology 2500