I see a promising start here, but I am puzzled by why all this instead of just maintaining different sheets and use lookup functions myself.
From reading your friend's blog it seems that you're going after flexibility and automation. I don't see much automation in the example given...