Sedang Disiapkan

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



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.

- 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.

More detail on SuperUser Module.
The SU module will
1- search through all names (rows) to select a name
2- show all dates that the corresponding name filled out the form
3 - choose 1 or 2 of those dates
4 - create a single or comparison report based on the dates.
The report will output using previously programmed methods, so no new criteria need to be added to the reports.

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

Lihat lagi: wordpress methods, what id wordpress developer, using google spreadsheet, spreadsheet in html, software developer overview, representation graph, overview of wordpress developer, online report generation, online create graph, online create bar graph, online chart design, html form to spreadsheet, how to graph data, how to create graph, how to create a graph, graph representation of data, graph representation in c, graphical design online, graph how to, google spreadsheet html

Tentang Majikan:
( 4 ulasan ) den, United States

ID Projek: #10192130

Dianugerahkan kepada:


Hi drRobert, thanks for letting me know that you have re-opened your project. So, here's my bid. As far as I could understand you want to generate the report from each google forms answer, and also create that e-mail r Lagi

$111 USD dalam 8 hari
(1 Ulasan)

3 pekerja bebas membida secara purata $231 untuk pekerjaan ini

$255 USD dalam 3 hari
(74 Ulasan)

Hello, We can do this project for you ! We are a team of 4 graphic designers with a solid experience in Adobe Photoshop (Photo manipulation & Website slider) ,Adobe Ilustrator (Vector quality & Webside design) & IN Lagi

$160 USD dalam 3 hari
(11 Ulasan)

Hello, We have understood your project scope and we had done similar projects in the past. My name is Jacob and I work in the capacity of Business Development Manager and Solution Architect in Blue Whale Solutions. Lagi

$155 USD dalam 3 hari
(10 Ulasan)
$277 USD dalam 5 hari
(0 Ulasan)