Prototype Customer Profile Tool in Google Sites

I need a prototype Google Sites dashboard designed to summarize social media activity of our customers. For this prototype, all the customer data (25-50 test customers) will reside in a Google Docs spreadsheet with one row/customer. This dashboard will have a three column format with the following sections in each column: Column 1, Section 1: Profile - customer picture, name, email address, telephone, username and a list of interests (e.g. skiiing, tennis, asian cooking, etc.) Column 1, Section 2: Scores - A five-bar chart showing ratings for the customer along five different dimensions. Column 1, Section 3: Notes - A few sentences of text, likely "below the fold" on the page. Column 2, Section 1: Recent Posts - A list of the customer's most recent five postings on Facebook, Twitter and their personal blog (five total, selecting from the sites in date order), showing the first couple of lines for each post with a hyperlink to the full posting. After the list, include a "more..." link that (for now) does nothing. The Facebook and Twitter accounts and the blog rss feed address will be provided. You'll need to fetch and consolidate the data for this section. Column 2, Section 2: Topics - A tag cloud of the words used in those recent postings (Wordle or similar). Column 3, Section 1: Campaigns - A list of five sample hyperlinks, labeled "Campaign 1" through "Campaign 5" followed by a "more..." link that (for now) does nothing. Column 3, Section 2: Interactions - A list of five sample hyperlinks, labeled "Interaction 1" through "Interaction 5" followed by a "more..." link that (for now) does nothing. A drop-down selection listing the names of all the people in the database needs to appear at the top of the page to select which profile is viewed. Obviously, in the long term, we'll want to have a more sophisticated search function ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement). 2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 3) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Worker in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. ## Platform Social Networking, HTML, Facebook & Twitter APIs, Google Sites, RSS Feeds