I've updated the OP with the latest needs for the demo; I'll likely take a crack at some of them later.