Quote of the Day
Almost every successful person begins with two beliefs: The future can be better than the present. And I have the power to make it so.
— David Brooks. This quote really speaks to me. The bedrock of success is the belief that you can make things better. At the core of this belief is a strong feeling of hope.
While answering a recent question about the tonnage sank by the top US submarine skippers during WW2, I realized that I had not made available my conversion to Excel of the Joint Army–Navy Assessment Committee (JANAC) data for vessels sunk by US submarines. The JANAC records are considered the official records because they were cross-checked with information from Japanese records.
The spreadsheet itself is from a course I taught last year on using Get and Transform (also known as Power Query). The raw data is from the Hyperwar web site – I often use the old WW2 records as an example of horribly formatted data that can be converted to a useful computer format using Python or Excel. The Hyperwar data appears to be from human-generated JANAC reports that were OCRed and converted to HTML. The Hyperwar site is a great resource, but the data does contain numerous conversion issues (e.g. commas turned into periods, extra Øs added to numbers). I cleaned up the obvious problems and cross-checked my results with data from the now-defunct Valor at Sea web site. The agreement was excellent.
This post makes this data available to those who are interested. With the Valor at Sea website offline, I could not find data summaries available anywhere else. Having it in spreadsheet form provides you the ability to generate custom reports. The data includes the specific ships sunk by each submarine. It does not include data for ships sunk because of the action of multiple submarines.
The Excel workbook is available here. There are no macros, but there are hyperlinks to various data sources.