A few weeks ago there was a search fo' hot water demand modeling.
Try this Excel Spreadsheet -- it needs the newer Excel 2010 and up
Building Technologies Office: Building America Analysis Spreadsheets
http://www1.eere.energy.gov/buildings/residential/ba_analysis_spreadsheets.html#schedule
bye
John R Ross III PE