• Welcome to Overclockers Forums! Join us to reply in threads, receive reduced ads, and to customize your site experience!

need help with OBD-II to excel

Overclockers is supported by our readers. When you click a link to make a purchase, we may earn a commission. Learn More.

Crash893

"The man in black fled across the desert,
Joined
Mar 13, 2001
i just got a obd-ii scanner and it has data logging capablitys but they are kinda of ghetto


i can output it to a .txt

it should be sensor on(1/0 i dont know why), sensor on repeat (1/0), sensor number, sensor value


here is an example

1,1,13," 34"
1,1,13," 34"
1,1,13," 34"
1,1,13," 34"
1,1,13," 34"
1,1,13," 34"
1,1,13," 35"
1,1,12," 1839"
1,1,13," 35"
1,1,12," 1840"
1,1,13," 35"
1,1,12," 1859"
1,1,13," 35"
1,1,12," 1905"
1,1,13," 36"
1,1,12," 1945"
1,1,13," 37"
1,1,12," 2002"
1,1,13," 38"
1,1,17," 25.9"
1,1,12," 2041"
1,1,13," 39"
1,1,17," 23.5"
1,1,4," 20.4"
1,1,12," 2085"
1,1,13," 39"
1,1,17," 25.1"
1,1,4," 21.6"


so how do i get it to show up in excell

under

13..........14.........15.........16.
##..........##.........#...........##.
then keep filling it out


any idea are GREATLY appreshated
 
I'm not exactly sure what you're trying to do with this:

13..........14.........15.........16.
##..........##.........#...........##.
then keep filling it out



Probably the best place to start would be to import the .txt as a CSV.

Basically find "Import" or "Get External Data." It will prompt you for a file, so select the txt file. Then it will run the Import Wizard. You want to choose delimited, then hit next, then choose "Comma" to indicate what the values are seperated by. The wizard should have all the info it needs, so just keep hitting next or finish.

If you want to change the display from top-bottom to left-right, highlight all the cells that you have just imported, copy them, then choose a cell outside and to the right of the range you just copied. Right-click on the cell you just chose, and click on "Paste Special." Put a check next to "Transpose" and then hit OK.

Let me know if you need something different.
 
basicly im tryin to seperate the info into diffrent colums

becuase its putting itn in one colum

so mph and rpm fule pressure and all the other data is all mixed to gether



to graph one agenst the other i need to seperate them into diffrent colums based on teh sensor number
 
Ah, gatcha.

The only advice I can give you is to import the data as CSV to put each value into its own cell. Then I'd delete the left two colums, and sort the two remaining long columns by the sensor number (this assumes that the order the readings are appearing is not important - if it is, you need to make a numbered sequence column going down, then you can sort by sensor number by number sequence). Then you can break up the readings by sensor number and cut/paste them into a different column. This is a bit manual, but moving cells around automatically isn't a strong point of Excel, you'd need Access to do that.
 
65,000 rows

i dont have that much time left on this planet
 
well its logging them in order

oldest on top
newest on the bottom


i think you may be on to something though

i think ill add them to excell then import it to access and then i can sort rows

ill let you know
 
btw there is a even more complicated vesion with timestamps

it logs it like this

1,257,0,#1899-12-30 13:53:11#
1,1,17," 5.1"
1,257,0,#1899-12-30 13:53:12#
1,1,4," 3.9"
1,257,0,#1899-12-30 13:53:12#
1,1,5," 135"
1,257,0,#1899-12-30 13:53:12#
1,1,12," 886"
1,257,0,#1899-12-30 13:53:13#
1,1,13," 21"
1,257,0,#1899-12-30 13:53:13#
1,1,14," 14.5"

edited for legnth ( you can get the idea from this)
 
Last edited:
Still stuck? Here's what I would do:

Import the CSV into Excel. Delete the first two columns (since they're all 1's). Put a "1" next to the first row, and autofill it down 65000 rows to make a sequential key. If you can't autofill, you can always put a "1" next to the first row (say, A1), then put the folowing formula in A2:

=a1+1

Click & drag that all the way down to the 65000th row. If it seems like it's taking a while, copy the formula in A2. Now highlight A3, press (and hold) shift, press the right arrow key, press and hold) the control key, press down, then press the left arrow key and release shift and control. You should have most of column A highlighted (if your database is one long column).

Now you have your key. Now lets sort the database by the sensor number (let's say column B), but also include our sequential key, so we're sorting it by B, then A (will keep the records in time sequence).

So now you're at the top of a huge column, with the first sensor group at the top. What you want to do now is search for the 2nd sensor (in numerical order). So, hit control+F, and type in the 2nd sensor number. This should bring you to the first instance of the 2nd sensor. Great. Now, highlight the first sequence number of the 2nd sensor (should still be in column A). Press and hold shift, press the right arrow twice (should highlight an entire row: sequence number, sensor number, value), press and hold the control button, and press the down arrow. This should bring you all the way to the bottom of the column, with everything EXCEPT our first sensor highlighted. Now CUT the selection, and go to the top of the page and PASTE the selection into a NEW column (like, E).

Repeat the last paragraph I typed till finished. If something doesn't work, let me know. I'm not in front of Excel now.

There's really no automatic way Excel can do this, and if you have 500 sensors to go through, you should really use Access.
 
yea but access doesnt graph does it?
 
Xymurgy said:
No, but you can throw it back into Excel when the columns are sorted correctly.

I tired that and it put them bakc into the order they were imported


i was thinking is there a simple way to just delete out all the other sensor data

make 4 or 5 seperate excel sheets then re integreate them
 
Back