Solar energy dashboard, php graphs

Status: Closed
Prize: $240
Entries Received: 5
Winner: VictorDuran

Winner

Contest Brief

We have a solar thermal field to monitor and intend to build a number of ”widgets” to display different features. The entry should be an examples of such dashboard. A dataset from the MySQL database and and example PDF has been attached.

The “widgets” should display the data as a bar chart, a line chart and as text/number.

The system will in the end display a number of different boxes with different information. This competition is to get a first idea of the look and feel of the components.

The “widget” should have an upper frame with the name of the widget and a mark to collapse it into a single line. The “widget” should be possible to invoke on a website with a php function. No need to have any interface to arrange them or configure them, the set will be configured directly in php-code.

I think the demo should have one part of the php-program with the main ccs-file and a design for the full screen (e.g. the gray background with a black thin frame) and then one or several functions that is called to put the three different widget on that screen.

Graphic layouts that we have found appealing is ”The Panic Status Board” and ”Geckoboard”. The trick seems to have shadings on the right places... Please make a google image search and look at those designs!

Attached files:
graphical idea in the attached pdf-file that we have created as an example dashboard
example data attached as Mysql query export file dashboard.sql

PDF file
The five pages illustrate first the empty dashboard, then when the bar chart is enabled, then also the line chart and text boxes are enabled. Then with all three boxes activated and finally when the “widgets” has been collapsed by clicking on the symbol to the right to the name of the box.

SQL-file (saved with the extention .txt to allow Freelacer to accept it, change the extention to .sql after daownloading it)
Use the text file dashboard.sql.zip to create a database and use the example data in the database in the contest:
Bar chart: display the five different temperatures in the table log from channel_id = 1
Line chart: display the five different temperatures in the table log from channel_id = 2
Text box: display the last 2 entries in the table status and the last temperature measured from table log, channel_id = 2

Good luck!

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“VictorDuran was one of three more or less equal contestants (out of 18) who solved the task, but his technical solution was the best, scalable and easy to implement.”

bystrom, Sweden.

Public Clarification Board

Contest Holder
- 11 years ago
Thank you all contestants! Sorry for some slow feedback. I'm impressed by the effort all have shown in this contest and the top three have all solved the task entirely according to the instructions (installing the sql database, implementing all requested features and diagrams) in a very good way. I have selected a Venezuelan winner, but special thanks to CBabbage and Wade Gilchrist for good communication. I think that a personal touch to the presentations and the communication is a big plus. Good luck everybody in your continuous work!
- 11 years ago
1. SmartChoice Solutions
  - 11 years ago
  bystrom, thank you very much for your rating on my entries. I really enjoyed participating in this contest, it was a fun project. Best wishes.
  - 11 years ago
Contest Holder
- 11 years ago
Sorry contestants for some slow feedback! I'll get back with the final result after the weekend!
- 11 years ago
1. SmartChoice Solutions
  - 11 years ago
  thank you
  - 11 years ago
simplicitysoft
- 12 years ago
@bystrom: can you please check #11 and give me feedback?
Thanks
- 12 years ago
Contest Holder
- 12 years ago
It will stay up at least 24 hours more. However, I have a great respect for peoples time and effort, and it feels bad to have many good entries and only being able to work together with one. This competition tool is a powerful way to choose freelancer, but I feel it can easily be misused.
- 12 years ago
SmartChoice Solutions
- 12 years ago
bystrom can you give me a bit of time to submit my solution ?
- 12 years ago
yogeshsharma89
- 12 years ago
Would you please wait for some hours ? I'll make some good changes in the design and will show you. Hope you like that.
- 12 years ago
Contest Holder
- 12 years ago
#7 has done everything right, only missing the final graphic touch. I like the look of e.g. Panic Status Board or Geckoboard
- 12 years ago
Contest Holder
- 12 years ago
Yes, temperature in Celsius
- 12 years ago
SmartChoice Solutions
- 12 years ago
any chance you can upload a rough mockup of your data would look on the graph, just a hand sketch would do
- 12 years ago
1. Contest Holder
  - 12 years ago
  There are two file enclosed in the contest, a pdf and the data as an sql (but named as txt). What is it that you don't find in those files?
  - 12 years ago
2. SmartChoice Solutions
  - 12 years ago
  bystrom i am not sure what you want for the axis of the bar and line graph, is it Y temp vs X time in min ? that was what i was trying to figure out
  - 12 years ago
yogeshsharma89
- 12 years ago
thanks for rating. Any feedback over entry #3 ?
- 12 years ago
yogeshsharma89
- 12 years ago
Please check entry #3 and open the working link for the early demo. Please let me know your feedback so we can go ahead with this. Thanks.
- 12 years ago