Create graphical report from Google spreadsheet, separate methods to access report, and send reminder -- 2



1 - Report Generation


- I have an online Google survey that users fill in.

- The survey reports result to google spreadsheet.

- The results for each answer set (row) need to be parsed into a report.

This report should open in a new browser tab, possibly as a Google doc, or perhaps in HTML form that will scale to any size screen. (Developer's choice as to format - more discussion needed.)

- The report will repeat back questions and answers and a graphical representation of accumulated answers will also be created.

- The numerical answers (1-10) of each question will determine the font of question in report.

- The numerical answers will also format a bar graph, with for each group of answers. The color, shading, height, and transparency of each bar graph will be determined by the set of answers, using very simple math.


Most of the graphical report should be fairly straightforward, but a part that might require some out of the box thinking would be superimposing a semi-transparent bar on top of another bar, in the report, to create a multi-shaded bar.


- An additional Threshold control, which will allow users to filter out all answers below X (a digit 3-9) should be available on the report.

- A comparison report, using the same formulas will create a combined chart with bar graph from a previous taking by the same user.


2- Save and remind Module


- Report will have a 'save and remind' module which will allow user to save the report to their device and to receive an email reminder at future date to re-take the Quiz.

- This module will require the addition of a date field to the spreadsheet, and a auto-running scan that will scan the entered dates and send the pre-formatted email.


3- Separate method to access reports (Superuser Module)


- A superuser module is needed to choose and create, using the same formulas and methods already created, single date and comparison reports on any already saved user.


Open questions:

- Security and ID: How to identify users while keeping their data personally unidentifiable.

- What is the best format in which to present report. I will need the ability access to change non-programmed features - (pictures, descriptions etc) in the future. (Wordpress a possibility?)

Full design doc attached.

Kemahiran: Reka Bentuk Grafik, Infografik, PHP, Penulisan Laporan, Kejuruteraan Perisian

Lihat lagi: wordpress methods, what id wordpress developer, using google spreadsheet, google app engine, spreadsheet in html, save the date graphic design, representation graph, question and answer graphic, overview of wordpress developer, online report generation, online create graph, online create bar graph, online chart design, math in graphic design, math and graphic design, html form to spreadsheet, how to graph data, how to create graph, how to create a graph, graph representation of data

Tentang Majikan:
( 4 ulasan ) den, United States

ID Projek: #10504207

7 pekerja bebas membida secara purata $427 untuk pekerjaan ini


I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Lagi

$257 USD dalam 10 hari
(15 Ulasan)

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i Lagi

$257 USD dalam 10 hari
(49 Ulasan)

Hello, I have good experience dealing with Google spreadsheets, Docs, forms and Google web apps. I made a look at the document and I think many requested features can't be done, please answer me back to discuss them Lagi

$500 USD dalam 7 hari
(63 Ulasan)
$555 USD dalam 3 hari
(12 Ulasan)

I have the expertise in Excel & scripting in VBA and can do this task, quickly and accurately, as per specification attached. Ready to start work immediately.

$277 USD dalam 5 hari
(8 Ulasan)

Hello there! To start with: this is a big project, but I loved it. I have been working with Google Apps for the past year, and I can definitely see the appeal to use them as basis for your system. I do however, h Lagi

$1111 USD dalam 30 hari
(1 Ulasan)

Hi, Let me introduce about our team. We are a team of Software professionals provide services in Wordpress Magento PHP MySQL Ebay listing designing iOS App development Android App development SEO Social m Lagi

$35 USD dalam sehari
(0 Ulasan)