customize report based on software

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

custom report building according to criteria written on attachment below

the software has a blog for query writing instruction .attached below and what is needed is to write a query that reflect the report i want

the look should be changed to look similar to report sample attached

on the excel report template it has sheet one which has the report schema for daily and monthly total , each page consist for one driver and violation he made

the second sheet is the monthly summary for all driver consists of totals and max an min violations committed

criteria is

1- Seat belt error to be recorded every time the engine is start working but the seat are not in place while the car speed are above 10 km/hr. and this error to be continually recorded every 1 min of driving at a speed above 10 km/hr.

2- The speed limit is 90 km/hr. ( higher speed ) and recorded as below criteria .

A- Over the speed limit for 5 second period will record 1 error then if the speed stay over the speed limit the tracker will record an error every 5 second cumulatively .

B- If the speed pass the speed limit for ( 0 – 10 ) km / hr. it will recorded an error every 5 second .

C- If the speed pass the speed limit for ( 11 – 20 ) km / hr. the device must recorded a double error for every 5 second .

D- If the speed pass the speed limit for ( 21 – 40 ) km / hr. the device must recorded 3 error every 5 second .

3- Over 130 km/hr. the device must record 4 errors every 5 second

4- Over riving record an error the RPM needle reach 4500 RPM and stay for more than 2 seconds while the car speed are zero .

5- Harsh breaking as the built in equation from the system to record an error . ( the calibration to be done by trail the average between peak break and high break )

6- Harsh acceleration as the built in equation from the system to record an error.( the calibration to be done by trail the average between peak accelerate and high accelerate )

7- The light is on to record an error if the car reach a 5 km/hr. speed and the cars lights was off to be measured upon the system internal time ( from the complete sunset ( after the clock sunset by 30 min ) till 30 min before the sun raise )

8- Excessive idling to record an error if the engine was on and the car speed was zero for 15 minutes continually time interval .

9- Harsh turning to be record an error as the device equation and after being calibrated by trail the average between the peak turning and max turning ).

these articles should be read

[login to view URL]

[login to view URL]

JavaScript MySQL Software Architecture

Project ID: #17707930

About the project

11 proposals Remote project Active 5 years ago

11 freelancers are bidding on average $489 for this job

liangjongai

Hello! We are interesting your project very well and full time devlopers. We have great skill in design and php. Our price and period is negotiable. Employee’s satisfy is my happiness ! Let's go ahead with me ! More

$500 USD in 10 days
(312 Reviews)
7.9
seefattechnologi

Hey !!! I checked your attachments and want a discussion with you. As per the description you shared i am highly interested to get started on the project as I am having 5 years experience as a JavaScript Developer. More

$300 USD in 10 days
(49 Reviews)
6.3
KGeorgy

Hello I am pleasure with your job for customize report based on software. Thanks for your job posting. I have throughout this description and think it's good fit for my skill-sets. As a senior expert on this job ,y More

$555 USD in 10 days
(47 Reviews)
5.8
amin6106

Hi there, Hope you are doing well. I can help you develop this I am assuming we will input data on the basis of which report will be generated. I will create this in such a way that it can easily expand. More

$400 USD in 14 days
(62 Reviews)
6.0
hasanjack

Hi sir I am Hasan Jack and I can help you with this job and I would like to discuss more about this project as it completely relevant to my skills. Looking forward to hear from you. Best Regards, Hasan Jack

$500 USD in 10 days
(38 Reviews)
5.8
snippetbucket

Respected. We had reviewed your requirement and able to start work. Let me know when you pfere to start work ! We had already done similar project with ERP. Looking forward to hear you back. Have a good More

$750 USD in 26 days
(39 Reviews)
5.6
mensonic

I have experienced more than 3 years.C# ,vb.net ,sql server , crytal report ,devexpress report experience 3 years

$555 USD in 10 days
(0 Reviews)
0.0
TarunSuneja

We can use USE open Source BIRT Report for your requirements. Please let me know if you need any Demo for the report.

$333 USD in 20 days
(0 Reviews)
0.0