I know it's not FOSS or Python, but Google docs has exactly this feature built in to its spreadsheet application.
If it's worth saying, but not worth its own post (even in Discussion), then it goes here.