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

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

Overview:

---------------

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.

Графічний дизайн Інфографіка PHP Написання звітів Архітектура ПЗ

ID Проекту: #10504207

Про проект

7 заявок(-ки) Дистанційний проект Остання активність 7 роки(ів) тому

7 фрілансерів(-и) готові виконати цю роботу у середньому за $427

Shopify

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 Більше

$257 USD за 10 дні(-в)
(15 відгуків(и))
6.7
prashushinde9

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 Більше

$257 USD за 10 дні(-в)
(49 відгуків(и))
6.8
mdkass

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 Більше

$500 USD за 7 дні(-в)
(63 відгуків(и))
5.6
surekash7096

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 за 5 дні(-в)
(8 відгуків(и))
2.9
Denisakov

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 Більше

$1111 USD за 30 дні(-в)
(1 відгук)
1.5
NewWayToCode

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 Більше

$35 USD за 1 день
(0 відгуків(и))
0.0