Required software development freelancer for Software developer required for real time project job
Posted at - Dec 5, 2022
Toogit Instant Connect Enabled
I have a consultant company of technology. I design several software to be build. At first I want to meet a company who can develop simple a easy tasks, then I will increase the demand of software and complexity. I have the specification in Spanish. It is a software with 6 tables of data, this data have to be storage and have to be display in graphics and tables able to export to excel. Let me know if you are able to work in this kind of jobs.
I have electricity data from 54 machines every 10 minutes and production data of 6 process. This data can be deposit in any kind of file, i.e. csv. I need a software in web that can storage 6 tables, 4 will be complete in a web form, the other 2 is the electricity and production data. Once the software is able to storage the data of this 6 tables, It is need to see the data in the web in tables and in graphics. This is the requirement and if it possible for you to develop, please contact me to send more details. As you may see this is a very small software. Once it is done, I need to add many others features to it.
Specifications for the software are the following:
Pages of the software
Energy page by energy
Graphic3.a
Able to filter by energy
A Table of the data, choose a year and show month of the year in columns to the right energies rows down with the total of the year.
Energy page by area
Graphic3.b
Able to filter by area
A Table of the data, choose a year and show month of the year in columns to the right areas rows down with the total of the year.
Energy page by machines
Graphic3.c (Detail bellow)
Able to filter by machine
A Table of the data, choose a year and show month of the year in columns to the right machines rows down with the total of the year.
Tables
Energy Table - CRUD (create, read, update, delete) on the web.
Energy code
Energy name
Unit
Kwh equivalence
Production variable code
Name Production variable
Production table - CRUD (create, read, update, delete) on the web.
Production code
Name
Unit
Flag (1-0), 1 means: It is the variable to use for total plant energy
Areas table - CRUD (create, read, update, delete) on the web.
Area code
Name of the area
Production variable code of the area
Machine table - CRUD (create, read, update, delete) on the web.
Machine code
Name of the machine
Area code
Power in Kw
Energy code
Production code
Machine energy consumption table - fill with data directly from other tables
Date and hour
Machine code
Energy code
Unit
Quantity
Production table - fill with data directly from other tables
Date and hour
Production code
Unit
Quantity
Graphics double Y axes, time in X
Energy consumption of the company
Y axis left energy consumption, with selector of one or every energies.
Y axis right production, choose the production with flag =1
X axis with a selector of date range, could be 6 hours to one year range.
Energy consumption by area
Select the area
Y axis left energy consumption of the area, with selector of one or every energies.
Y axis right production corresponding to the area, set in the machine table.
X axis with a selector of date range, could be 6 hours to one year range.
Energy consumption by machine
Select the machine
Y axis left energy consumption of the machine, with selector of one or every energies.
Y axis right production corresponding to the machine, set in the machine table.
X axis with a selector of date range, could be 6 hours to one year range.
Exportable tables to Excel
Energy consumption in a range of dates
Multiple selector:
Machine
Energy
Area
Date and hour (every 10 minutes)
Machine code
Machine name
Area code
Area name
Energy code
Energy name
Quantity
Unit
TO TEST AN EXAMPLE I will provide one table of energy data and other with production data. In the graphic it has to see: In one Y axis the energy consumption which is the summary of all energies of all machines for each date. In the other Y axis the production which is one of the production, so you have to set the graphic selecting one of the production codes available. In the X axis is the time. For this graphic it is need:
Filter the energy by type of energy
filter the energy by areas
filter the energy by machines
available to select which production data will be show in the graphics as second axis to be compare with different scale and view in the same graphic with the different selections of energy.
available to select the range of time dragging the mouse over the bottom of the graphic where it is the scale.
About the recuiterMember since Mar 14, 2020 See Marry from Shizuoka, Japan