The previous post had a link to Cyrille Rossant which is worth a closer look. The blog has many detailed posts on scientific applications of Python, as well as links to Galry: a high performance interactive visualization package in Python and his IPython mini-book.
Spreadsheets 4 Simulation is a new blog focussing on engineering applications of Excel and Google Sheets, which has some impressive looking applications and animations, including: