I have a consultant company of technology. I design several software to be build. At first I want to meet a company who can develope simple a easy tasks, then I will encrease 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 deposite 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 develope, 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.
Especifications for the software software are the following
1. Pages of the software
a. Energy page by energy
i. Graphic3.a
ii. Able to filter by energy
iii. 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.
b. Energy page by area
i. Graphic3.b
ii. Able to filter by area
iii. 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.
c. Energy page by machines
i. Graphic3.c (Detail bellow)
ii. Able to filter by machine
iii. 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.
2. Tables
a. Energy Table - CRUD (creat, read, update, delete) on the web.
i. Energy code
ii. Energy name
iii. Unit
iv. Kwh equivalence
v. Production variable code
vi. Name Production variable
b. Production table - CRUD (creat, read, update, delete) on the web.
i. Production code
ii. Name
iii. Unit
iv. Flag (1-0), 1 means: It is the variable to use for total plant energy
c. Areas table - CRUD (creat, read, update, delete) on the web.
i. Area code
ii. Name of the area
iii. Production variable code of the area
d. Machine table - CRUD (creat, read, update, delete) on the web.
i. Machine code
ii. Name of the machine
iii. Area code
iv. Power in Kw
v. Energy code
vi. Productio code
e. Machine energy consumption table - fill with data directly from other tables
i. Date and hour
ii. Machine code
iii. Energy code
iv. Unit
v. Quantity
f. Production table - fill with data directly from other tables
i. Date and hour
ii. Production code
iii. Unit
iv. Quantity
3. Graphics double Y axes, time in X
a. Energy compsumption of the company
i. Y axis left energy consumptiom, with selector of one or every energies.
ii. Y axis right production, choose the production with flag =1
iii. X axis with a selector of date range, could be 6 hours to one year range.
b. Energy consumption by area
i. Select the area
ii. Y axis left energy consumptiom of the area, with selector of one or every energies.
iii. Y axis right production corresponding to the area, set in the machine table.
iv. X axis with a selector of date range, could be 6 hours to one year range.
c. Energy consumption by machine
i. Select the machine
ii. Y axis left energy consumptiom of the machine, with selector of one or every energies.
iii. Y axis right production corresponding to the machine, set in the machine table.
iv. X axis with a selector of date range, could be 6 hours to one year range.
4. Exportables tables to Excel
a. Energy consumption in a range of dates
i. Multiple selector:
1. Machine
2. Energy
3. Area
ii. Date and hour (every 10 minutes)
iii. Machine code
iv. Machine name
v. Area code
vi. Area name
vii. Energy code
viii. Energy name
ix. Quantity
x. 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 wich 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 vew 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 Himanshu Shekha
from Nunavut, Canada