The dive log that I have in Excel is pretty comprehensive but I can't take credit for all of it. I have a friend who made it originally and I modified it slightly for my personal use--but here's what it keeps track of. Anything in red is something it auto-generated based on other information or calculations based in the spreadsheet.
Dive number
Total hours of dive time
Date
Location
Dive type (training, TA, quarry, ocean, wreck, spring, river, cavern, cave)
Viz
Temp (F)
Current
Buddy
Purpose
Max Depth (ft)
Max Depth (ata)
Nitrox Mix (%02)
MOD @ 1.4 pO2 (fsw)
EAD @ max depth (ata)
EAD @ max depth (fsw)
Start Time
End Time
Total Time (hr:min)
Actual Dive Time (min)
Planning Method
SIT prior
Start Group
RNT (min)
TNT (min)
End Group
Tank Volume (cf)
Tank Working Pressure (psi)
Start PSI
End PSI
Delta PSI
Average Depth (fsw)
SAC (cf/min/ata)
Equipment
Notes
On a "Summaries" page it is set up to keep track of the number of dives by type, the deepest dive (fsw) and the longest dive (hr:min).
It's easily adjustable so in the future if I ever get into deco--I can add that as a "dive type". The way it works is that I can have multiple dive types per dive. As an example--if I'm diving as a TA with a group of students on a wreck in the ocean, I put "Ocean, Wreck, TA" as the dive type and it counts one each for each--ocean, wreck, and TA.