I have written quite a few Microsoft Excel spreadsheets and one or two DOS Batch files for doing different things. Some I use for work (civil engineering), and some are purely for fun.
I have made some of them available here for you to download and use freely. I have password protected a few of them so that you won't be able to make changes to the way they work - BUT if you send me an email telling me what you think of the spreadsheet then I will happily tell you the password.
| Normal | Zipped | Comment | |
|---|---|---|---|
| carperf.xls (241 kB) |
carperf.zip (67 kB) |
A comprehensive Excel spreadsheet that will calculate the acceleration and top speed of a car given a few basic facts about the car | |
| coordcon.xls (49 kB) |
coordcon.zip (34 kB) |
An Excel spreadsheet that will convert grid references in Longitude and Latitude to OS Grid References | |
| corners.xls (1,069 kB) |
corners.zip (308 kB) |
An Excel spreadsheet that when supplied with a OS Landranger Map Grid Reference will tell you which Landranger map it appears on and the nearest postcode | |
| twisty.xls (99 kB) |
twisty.zip (29 kB) |
A fun and wacky Excel spreadsheet that rotates wire mesh 3D model shapes around in 3 dimesnsions | |
| SectionProps.xls (39 kB) |
SectionProps.zip (10 kB) |
A program that Civil Engineers might find useful - it calculates section properties for steel plate girders. | |
| photoviewer.bat (2 kB) |
A DOS batch file that will create a webpage for previewing all the .jpg and .gif files in a given directory. This batch file is very useful if you are running Windows 95 or Windows 98 and don't have any suitable graphics packages for previewing images. | ||
| steering.xls (41 kB) |
A spreadsheet that calculates and illustrates accurate steering geometry for various wheelbases and track widths. | ||
| compression.xls (14 kB) |
A simple spreadsheet that calculates compression test pressures and temperatures for engines. | ||
| brinchhansen.xls (150 kB) |
A detailed spreadsheet that performs calculations using the Brinch Hansen method for laterally loaded piles in soil. | ||
| EarlyThermalCracking.xls (27 kB) |
A comprehensive spreadsheet that calculates the minimum reinforcement required in mass concrete (usually foundations) to resist early thermal cracking due to differential shrinkage. |