Filter pid to Spreadsheet?

[CR500]

Is there a way to create a filter pid that dumps to a spreadsheet file? I'd like to filter based on throttle, rpm, and knock retard, then write a spreadsheet of all pids in the bbx datafile that meet that filter.

I've been running the filter and manually typing the info into a spreadsheet and its not fun!

Thanks!

Rob

[joecar]

You can export a log to a csv file...

BUT...

why are you using a spreadsheet instead of the scantool maps...?


( and the scantool allows you to create a filter based on whatever you like )

[CR500]

How is the export done?

I loaded the datafile, view it in Chats, select my filter, hit the Filter Data button, hit Save and Save As, and the only type in the list is .pld

[joecar]

File->Export



( are you trying to save the filtered file...? )

You're clicking the wrong Save/Save-As buttons (you clicked the Save buttons in the PIDs tab sub-toolbar)...

you want to click the Save As button in the main toolbar at the top of the window, it pops up a dialog asking this (with Yes No buttons):

The current data is filtered.
Do you wish to save only the currently visible data?.

[CR500]

I'm using V8 and guessing you're talking about V7.5?

[joecar]

I'm using V8 and guessing you're talking about V7.5?Yes

( V8 does not have maps yet )

[CR500]

Ah, I only use V7.5 for modifying and flashing the tune. I've been using Charts in V8. I did just try to open one of my bbx logged files in V7.5 and it didn't seem to do anything. Guess I'll have to read up on it.

[joecar]

Ah, I only use V7.5 for modifying and flashing the tune. I've been using Charts in V8. I did just try to open one of my bbx logged files in V7.5 and it didn't seem to do anything. Guess I'll have to read up on it.When you open a log using V7 scantool, check if the replot button has turned red (snowflake/star shaped, at bottom of window, next to speaker button), if it is red then click it.

[CR500]

That worked. I'm now able to display a table of knock retard values against rpm and dyncylair. I'm applying a filter to see knock in excess of 2 degrees, hiding cells with low counts, and flip between seeing the max and mean values. That gives me exactly what I needed!! Now I can tweak the tune.

Is there a way to get it to go quickly through the data file? My logs are 30 min long from session on the track.

Thanks!

[joecar]

That worked. I'm now able to display a table of knock retard values against rpm and dyncylair. I'm applying a filter to see knock in excess of 2 degrees, hiding cells with low counts, and flip between seeing the max and mean values. That gives me exactly what I needed!! Now I can tweak the tune.

Is there a way to get it to go quickly through the data file? My logs are 30 min long from session on the track.

Thanks!Long logs slow down the replot... what I do is a combination of filtering and saving to a new filename, and cropping the log.

[Blacky]

How is the export done?

I loaded the datafile, view it in Chats, select my filter, hit the Filter Data button, hit Save and Save As, and the only type in the list is .pld

In V8 you can select a range in the charts, right-click and select "Copy". That will copy the data to the clipbaord in a format suitable for pasting into Excel.

There are a few issues with the current pre-release V8 SCan Tool "Copy" option:

If any PIDs in the charts are not selected, then the data does not line up under the correct PID heading.
Full precision is not used when copying data to the clipboard.

Both of those problems are fixed in the next update.

There are many new, improved and fixed V8 Scan Tool features on the way in the next update.

Meanwhile, as Joe suggested, use the V7 Scan Tool for creating/updating maps.

Note: The V7 scan tool data re-plotting speed is slow compared to V8. It as written a long time ago when Windows was prone to crashing, so all scan tool data is read/written directly to disk. If/when a crash did occur the logged data could be recovered from the cache on disk. That makes re-plotting quite slow since every single frame is read directly from disk. If you have access to an SSD (solid state disk), you could try speeding up the disk operations by setting the "Temporary Cache" folder to a folder on the SSD. The cache folder can be changed in the Edit->Properties->[Folders] ,then click on the "Temporary Chache" item and click [Browse];

V8 caches all its data in memory and has had years of optimizations applied to it, so it is orders of magnitude faster than V7.
400,000 frames (1.5 hours of logging) is replotted in around 1 second. Compared to hundreds of seconds on V7.

Regards
Paul

[CR500]

I'll try the copy to clipboard tonight! Maps (V7) is doing what I was need. I going to do the same thing with a combination of Charts (V8) and a spreadsheet.

The speed actually isn't too bad, and I'm on a Mac running the software through a virtual machine!

[joecar]

...

The speed actually isn't too bad, and I'm on a Mac running the software through a virtual machine!I was running a MacBook Pro until the graphics chip unsoldered itself... lots of fun trying to fix it :doh: