I am looking at creating a personalized online portal where clients can enter information into a google docs spreadsheet that can then be analyzed and the results graphically displayed and represented with charts and other information on a "dashboard page" (maybe using google chart tools ([url removed, login to view]) or other JS charts like [url removed, login to view]). We have already developed the spreadsheets to analyze the data and give data results, and just need to graphically display the data.
1. Personalized Customer Dashboard Webpage (using [url removed, login to view] or similar)
a) Data Entry Form (monthly sales data) which sends data into existing google docs spreadsheet
b) Charts displaying results from our analysis ([url removed, login to view] or [url removed, login to view] or similar) accessing google docs spreadsheet
I am in process of creating the main website using joomla 2.5 with mySql database.
Sample Page idea attached.
Thanks for your consideration in looking at my project.