Hello protomor
Thank you very much for your link.
I tested it, but it throw this error: "Input string was not in a correct format" As you commented, it can be because the csv file does not contain GPS data.
Here is the csv I load:
http://mysharegadget.com/754814913
Thank you in advance.
Jesas
Understanding logged data
Re: Understanding logged data
https://drive.google.com/file/d/0ByBda7 ... sp=sharing
Let's give this one a shot. I don't get why your csv starts with a "#". that was really weird. Your PIDs also come in 2 digit form. I was always expecting 3. Anyway. This should get it working for the most part. It does bomb on torque export and kml export (obviously) because both rely on GPS data. It doesn't look as sexy when you don't have the GPS data. I have added a few new features for it.
Also, why don't your PIDs log with their pid names? I don't think I added in code for that but my logs say things like "RPM" and "CLT" instead of "10C"
Let's give this one a shot. I don't get why your csv starts with a "#". that was really weird. Your PIDs also come in 2 digit form. I was always expecting 3. Anyway. This should get it working for the most part. It does bomb on torque export and kml export (obviously) because both rely on GPS data. It doesn't look as sexy when you don't have the GPS data. I have added a few new features for it.
Also, why don't your PIDs log with their pid names? I don't think I added in code for that but my logs say things like "RPM" and "CLT" instead of "10C"
Re: Understanding logged data
I've created an Excel file with some VBA that will import raw Freematics data, make a trip log, and export .csv files in a more readable format. It has only been tested on my car's data. It will ignore files that don't have date/time information but I could probably rewrite to look at another value (such as RPM).
Feel free to try it out and let me know if it works for you.
Blog Post:
https://nicolascoffey.wordpress.com/201 ... rter-v1-0/
Download:
https://app.box.com/s/s63qunax815lgjb866lrplq8lydyuvkv
Feel free to try it out and let me know if it works for you.
Blog Post:
https://nicolascoffey.wordpress.com/201 ... rter-v1-0/
Download:
https://app.box.com/s/s63qunax815lgjb866lrplq8lydyuvkv
Re: Understanding logged data
It doesn't seem to work with my csv files. But I also log lots of stuff and sometimes don't have GPS data. I have an error somewhere in the first quarter of the file "With Worksheets(wbName).Range("B:B")"
Does this spit out graphs and stuff?
Does this spit out graphs and stuff?
Re: Understanding logged data
Anyone get a chance to try out my stuff? Latest version here: https://drive.google.com/file/d/0ByBda7 ... sp=sharing
Re: Understanding logged data
protomor wrote:
> It doesn't seem to work with my csv files. But I also log lots of stuff and
> sometimes don't have GPS data. I have an error somewhere in the first
> quarter of the file "With
> Worksheets(wbName).Range("B:B")"
>
> Does this spit out graphs and stuff?
Lack of GPS data will cause it to break (due to lack of day/time info). Do you have a sample of your data? I could probably tweak the code to accept files without GPS data.
It does not spit out graphs, but it does export a .csv file that would make it very easy to create graphs (data is formatted in a table).
> It doesn't seem to work with my csv files. But I also log lots of stuff and
> sometimes don't have GPS data. I have an error somewhere in the first
> quarter of the file "With
> Worksheets(wbName).Range("B:B")"
>
> Does this spit out graphs and stuff?
Lack of GPS data will cause it to break (due to lack of day/time info). Do you have a sample of your data? I could probably tweak the code to accept files without GPS data.
It does not spit out graphs, but it does export a .csv file that would make it very easy to create graphs (data is formatted in a table).