Notices
Series I Engine Tuning Forum EMS (Flash Tuning, Interceptor, Piggy Back, Stand Alone)

D.I.Y. Datalog / Graph your AP with EFI Dude/Scanalyser

Thread Tools
 
Rate Thread
 
Old Oct 6, 2008 | 10:35 AM
  #26  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
Originally Posted by Daemos
Writing a macro? pm me an email address and I'll send you a EFIdude and Scanalyser csv output files.
Just copy the first 10 or so rows and paste them here... I should be able to decifer whats going on then
Reply
Old Oct 6, 2008 | 10:47 AM
  #27  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
Here is my first contribution. This spreadsheet will sort your data into a table so you can more easily get a picture of whats going on at more places then at WOT. I SUGGEST NOT GIVING THE INFO TO JEFF IN THIS FORMAT AS ITS NOT THE FORMAT HE'S ASKING FOR!!!

Simply drive around trying to hit as many rpm and load combinations as you can for as long as you want while logging the data you want to map out. Copy that data and paste into the "Input" tab in their respected column. Go back to the "Start" tab, verify the x,y and output options selected are what you want to use and hit the "Run Report" button.

...it may take a minute or two to run depending how much you logged and how fast your computer runs...
Attached Files
File Type: zip
tableviewer.zip (58.0 KB, 86 views)

Last edited by r0tor; Oct 6, 2008 at 10:50 AM.
Reply
Old Oct 6, 2008 | 11:02 AM
  #28  
Daemos's Avatar
Thread Starter
Registered User
 
Joined: Jul 2007
Posts: 686
Likes: 0
From: Canada ---> Australia
Originally Posted by r0tor
Just copy the first 10 or so rows and paste them here... I should be able to decifer whats going on then
Check attachments on first post, load goes to a max of 78% on the EFIdude
Reply
Old Oct 6, 2008 | 11:14 AM
  #29  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
Originally Posted by Daemos
Check attachments on first post, load goes to a max of 78% on the EFIdude
The TPS is going to 78% with is the programmed limit for one reason or another for throttle position. Your load is going to 175% which makes no sense to me given the maf flow its reporting as for a NA car it should max out around 100 .

i'm severly confused now
Reply
Old Oct 6, 2008 | 02:53 PM
  #30  
Hymee's Avatar
Race Steward
iTrader: (1)
 
Joined: Aug 2003
Posts: 5,430
Likes: 2
From: Brisbane, Australia
I'm not sure why some of you get the problems with downloading the file, and I'm unaware of any email problems at the moment. If you have been emailing me and I haven't responded, I'm sorry - please try to PM me and see where that takes us.

I'm working on a USB version of sCANalyser Live. Plus of course the supercharger and sCANalyser Pro Tuner...

Cheers,
Hymee.
Reply
Old Oct 6, 2008 | 03:05 PM
  #31  
Jedi54's Avatar
Administrator
iTrader: (7)
 
Joined: Mar 2004
Posts: 22,600
Likes: 3,455
From: The Dark Side
^^^ Hymee, I'm sure there will be threads about those down the road but since you brought it up: will those of us who have the scanalyser already have an easy (and inexpensive) way to upgrade software / hardware?

you can PM me if you like so we don't completely side track this thread. Thanks amigo.
Reply
Old Oct 7, 2008 | 01:17 AM
  #32  
Daemos's Avatar
Thread Starter
Registered User
 
Joined: Jul 2007
Posts: 686
Likes: 0
From: Canada ---> Australia
Originally Posted by r0tor
The TPS is going to 78% with is the programmed limit for one reason or another for throttle position. Your load is going to 175% which makes no sense to me given the maf flow its reporting as for a NA car it should max out around 100 .

i'm severly confused now
https://www.rx8club.com/series-i-trouble-shooting-95/tps-maxes-out-%7E78%25-155936/

I think the cobb/scannalyzer scales it...but other people have the same problem.
Reply
Old Oct 7, 2008 | 07:58 AM
  #33  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
any one know how to use excell 2007 the above directions are not working at all. I thought i had it figured out but it looks like no. I'm having trouble making graphs where the data is legiable enough to make precise tunes. i.e. when i make a graph for AFR/RPM if the rpms go by 1000 then my afr goes by 5's leaving too much guess work as to where my afr is actually at and if I add data labels it's way too close and looks like a bunch of black jumbled numbers. Also if I open up a second excell program and try to copy the numbers info it paste it as numbers insted of graphing it like I have selected. So the only way I can get it to graph is by using the same excell page which will change my logged data I have saved thus removing all my information. Also i don't get how to use the tableviewer.
Reply
Old Oct 7, 2008 | 09:56 AM
  #34  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
for the table viewer I get stuff like this. Is it supposed to look like this?
Attached Thumbnails D.I.Y. Datalog / Graph your AP with EFI Dude/Scanalyser-clipboard01.jpg  
Reply
Old Oct 7, 2008 | 09:59 AM
  #35  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
the "N/A" means you didn't have any data to fill those cells... whats your max LOAD in your logged file?

Last edited by r0tor; Oct 7, 2008 at 10:01 AM.
Reply
Old Oct 7, 2008 | 10:02 AM
  #36  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
Originally Posted by Daemos
https://www.rx8club.com/showthread.php?t=155936

I think the cobb/scannalyzer scales it...but other people have the same problem.
the TPS seems OK... its the LOAD i'm befuddled about as you can't possibly reach 145% in a NA car. I don't know what the hell its logging, but its sure not the LOAD the ecu s looking at
Reply
Old Oct 7, 2008 | 10:11 AM
  #37  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
humm basically I just copied the entire cvs. file so all the data is there just not going in for some reason. the file is like 1500 lines long. maybe it's due to the load thing being weird my max load is 190.5882
Reply
Old Oct 7, 2008 | 10:32 AM
  #38  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
completely befuddled with these Loads being reported... Are these all being reported from the EFIDude logger????



anyway, you can change the numbers in the blue column on the "start" page to something that works for you. So instead of the load column going from 0-106, it probably needs to go from 0-200 for you.
Reply
Old Oct 8, 2008 | 08:48 PM
  #39  
mysql's Avatar
Doppelgänger
 
Joined: Feb 2008
Posts: 3,192
Likes: 1
From: Florida
just do file -> export -> animated gif

Reply
Old Oct 13, 2008 | 07:59 PM
  #40  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
OK... I'm sharing a spreadsheet I just created to tune my AP myself. The spreadsheet will upload your AccessTuner Race csv file, will analyze the data to find the first 2nd gear and 3rd gear WOT pull, graph them, then allow you to export them to a new file for easy storage.


Step 1: Log at least: Load, Vehicle speed (VSS), RPM, Equivalence Ratio, and MAF. You can log more things, but not less...

Step 2: Safely do a WOT 2nd gear and 3rd gear run while logging. Your ecu has a 1-2 gear map and a 3-4 gear map. You'll want to see both obviously.

Step 3: Open the spreadsheet. Press the Import Data button. Find your csv file in your ATR directory. Open it... the spreadsheet will copy your csv file data into itself.

Step 4: Press the Analyze data button. The spreadsheet will look at the data, determine what gears you were in, finds the first 2nd and 3rd gear WOT pulls (looks for at least 10 log points above 89% throttle in the gear its looking for), and copies the pulls to another sheet linked to the graph called "graph data"

Step 5: Look at your results. If it missed the data or gathered the wrong data - copy the right data into the "graph data" sheet.

Step 6: Press the Export Data button. This will copy the graph and graph data to a new spreadsheet which you can save. Do not save over the original spreadsheet.... use it as a template!
Attached Files
File Type: zip
DatacollectorATR.zip (29.6 KB, 75 views)
Reply
Old Oct 13, 2008 | 08:02 PM
  #41  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
the result looks like...

Reply
Old Oct 14, 2008 | 06:35 AM
  #42  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
so do these runs needs to be made in sequence or just wot 2nd / then wot 3rd or wot 2nd stop logging then start new log wot 3rd
Reply
Old Oct 14, 2008 | 09:21 AM
  #43  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
can be in any order and in any fashion you want...
Reply
Old Oct 15, 2008 | 10:50 AM
  #44  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
ok I'm done trying to figure out how to make this graph and I'm running out of time to get it to jeff. Any way I can send some one my csv dudeloger file and make a graph for me.
Reply
Old Oct 15, 2008 | 10:59 AM
  #45  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
that would be because according to lola, your beloved dudelogger is reporting 2x the load or something crazy like that.

...and my specific spreadsheet only works with the ATR software...
Reply
Old Oct 16, 2008 | 11:09 AM
  #46  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
Any idea why my load is on the bottom? using excell 2007
Attached Thumbnails D.I.Y. Datalog / Graph your AP with EFI Dude/Scanalyser-clipboard01.jpg  
Reply
Old Oct 16, 2008 | 12:30 PM
  #47  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
multiply that column by 100... i'll have to check why it missed that step of the program


Did the rest of it work ok?
Reply
Old Oct 16, 2008 | 12:34 PM
  #48  
Mr.&Mrs.Magic's Avatar
Registered User
iTrader: (3)
 
Joined: Jan 2008
Posts: 579
Likes: 1
yep!
Reply
Old Oct 16, 2008 | 05:23 PM
  #49  
r0tor's Avatar
Registered
iTrader: (1)
 
Joined: May 2003
Posts: 3,754
Likes: 1
From: PA
i looked over the code and tried it with all the logs i made and I can't replicate it not taking care of the load scale... blasted computers...
Reply
Old Oct 16, 2008 | 05:26 PM
  #50  
Kane's Avatar
Senior Member
iTrader: (1)
 
Joined: Jan 2007
Posts: 6,364
Likes: 44
From: PCB
Part of Windows setting I bet; you can customize how it stores and load percentages, decimals etc..

You can set an IIF("Percentage">1, LeaveAlone, Percentage * 100)

Something like that.
Reply


You have already rated this thread Rating: Thread Rating: 0 votes,  average.


All times are GMT -5. The time now is 12:46 AM.