Hi - This is a project that we are doing to calculate the fuel consumption. The device captures the fuel level from the vehicle and is reported as shown in the below excel attached. The issue is due to the fluctuation in the data that we get. However, if one looks at the trend line, it shows the pattern and gives the right picture as shown.
The requirement is noted in "Notes" tab of the spreadsheet. Only those who have worked with statistical functions may come forward as I am looking to have this as early as possible.
Anyone with thorough expertise in any of PHP, Perl, Java and Python and who have dealt with statistical functions may attempt.
Thank you.
Hello,
I'm interested by your project bt is it possible to have the spreadsheet that you mentioned, since it does not appear on the project description ?
Best regards,
Laurent.
I wrote Perl for Walmart Stores, Inc. for 13 years and have a vast amount of expertise churning through data like such as yours.
I already have the script written and can deliver it to you once we complete our transaction. I do have questions around your data.
It looks as though it fluctuates quite a bit and I'm wondering if this is due to the vehicle traveling up and down hills. Would this be correct?
I've set up my script to report instances where fuel level has increased or decreased by 5 liters and it produces the results below. Please contact me so that we may discuss more appropriate/more elablorate parameters. I look forward to working with you. Kind regards,
ADDITIONAL FUEL: 31.39 L
TIME: 30-10-2013 06:56
STOLEN FUEL: -7.52 L
TIME: 30-10-2013 08:09
STOLEN FUEL: -5.46 L
TIME: 30-10-2013 09:00
STOLEN FUEL: -9.62 L
TIME: 30-10-2013 09:16
ADDITIONAL FUEL: 6.16 L
TIME: 30-10-2013 09:19
STOLEN FUEL: -5.38 L
TIME: 30-10-2013 11:03
ADDITIONAL FUEL: 12.33 L
TIME: 30-10-2013 17:54