Can I see some examples of teapot in action?

Sure, the standard distribution comes with an examples folder containing several spreadsheet files illustrating some of TEAPOT's features. Each sheet is accompanied by a README file with a brief explanation of what is going on in the file.