Notices
ECU Flash

Pasting Data from Excel to Ecuflash

Thread Tools
 
Search this Thread
 
Old Mar 31, 2007 | 11:38 PM
  #1  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
Pasting Data from Excel to Ecuflash

GAAAH

I have built a spreadsheet for comparing and adjusting timing and / or fuel maps using MS Excel. I have two purchased tunes and have been adjusting and comparing all of the maps using charts.

I now have a good looking ignition map that I need to get back into Ecuflash.

Now here comes the bad part. I can copy data from Ecuflash and paste it into Excel but I can't get it to go the other way.
I want to paste the edited data back into Ecuflash and can't get it to work

I've tried selecting the cells in Ecuflash and then pasting from the menu and the keyboard and the edited data is not getting copied.

I'm sure this is a case of operator error here.

Any help would be much appreciated,
Bob
Reply
Old Apr 1, 2007 | 07:04 AM
  #2  
mrfred's Avatar
EvoM Guru
iTrader: (50)
 
Joined: Mar 2006
Posts: 9,675
Likes: 132
From: Tri-Cities, WA // Portland, OR
I haven't been able to paste from Excel to ECUFlash either.
Reply
Old Apr 1, 2007 | 10:11 AM
  #3  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
That stinks

I have a spreadheet that works really well for comparing fuel and timing maps, made some adjustments to my current tune and then had no luck pasting it back into Ecuflash.

Thanks for the reply, I thought maybe there was something I was doing wrong.
Reply
Old Apr 1, 2007 | 10:26 AM
  #4  
codgi's Avatar
Evolved Member
20 Year Member
Photogenic
Liked
Loved
Community Favorite
iTrader: (22)
 
Joined: Aug 2004
Posts: 2,493
Likes: 41
From: Seattle, WA
From my testing it appears that if you select a block of cells in EcuFlash and try to paste data into it it will only paste data into the first cell highlighted.

I.e it doesn't seem to allow selecting multiple cells and pasting data into all of them (even if its only one value).

Might have to make a request to Colby and see if he will add the above into the next version.
Reply
Old Apr 1, 2007 | 10:32 AM
  #5  
andenbre's Avatar
Evolved Member
iTrader: (4)
 
Joined: Apr 2002
Posts: 906
Likes: 0
From: chicago area
I have been able to past multiple cells but that was a while ago let me see if I can figure it out again
edit: ok I can paste entire maps from one rom to another(the data values ) you just have to make sure that the entire area that you are pasting to is selected,. but I have had no success with pasting from excel yet.

Last edited by andenbre; Apr 1, 2007 at 10:42 AM.
Reply
Old Apr 1, 2007 | 10:58 AM
  #6  
MalibuJack's Avatar
EvoM Guru
20 Year Member
iTrader: (5)
 
Joined: Feb 2003
Posts: 10,572
Likes: 14
From: Royse City, TX
Just a quick suggestion for copying/pasting from Excel to ECUFlash,

Copy Excel, paste to Notepad, copy from notepad, paste to ECUFlash.. This seems to work. It has something to do with how the excel data is formatted..
Reply
Old Apr 1, 2007 | 05:27 PM
  #7  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
MJ,

I tried doing exactly that before posting but it's not working on my pc. I tried just "pasting" into ecuflash with no cells selected, one selected and all of them and no data is getting transferred?

I looked on some other forums and somebody said he could copy from Excell then paste into AEM EMS and from there he could paste back to ecuflash . . . Whew!
Reply
Old Apr 1, 2007 | 06:06 PM
  #8  
andenbre's Avatar
Evolved Member
iTrader: (4)
 
Joined: Apr 2002
Posts: 906
Likes: 0
From: chicago area
Originally Posted by MalibuJack
Just a quick suggestion for copying/pasting from Excel to ECUFlash,

Copy Excel, paste to Notepad, copy from notepad, paste to ECUFlash.. This seems to work. It has something to do with how the excel data is formatted..
i remember that working befor also but couldnt get it to work now
edit:got it to work again.... when you copy from notepad be careful not to also select the very bottom row from notepad that only has the cursor like the enter key was hit at the end of the last # entry if ya know what I mean

Last edited by andenbre; Apr 1, 2007 at 06:16 PM.
Reply
Old Apr 1, 2007 | 09:15 PM
  #9  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
Originally Posted by andenbre
i remember that working befor also but couldnt get it to work now
edit:got it to work again.... when you copy from notepad be careful not to also select the very bottom row from notepad that only has the cursor like the enter key was hit at the end of the last # entry if ya know what I mean
Thanks! I'll give it a try. I've been making adjustments to my maps, then pasting the data into my Excel deal.

I hope this works!
Reply
Old Apr 1, 2007 | 09:34 PM
  #10  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
I found that if remove all the gridlines in the Excel sheet, then copy to Notepad, then take it from Notepad to Ecuflash that it works correctly.

I can also see that when you select all the data sometimes you will see (as andenbre pointed out) that sometimes the selection will go one character past the end of the data.

Anyway I am glad that this works. I find it easier to work with a graph of the two maps so you can visualize the difference in values.

Below is a pic of the 3500 RPM timing values.



Thanks for all the help
Reply
Old Apr 2, 2007 | 12:19 PM
  #11  
oldevodude's Avatar
Evolved Member
iTrader: (3)
 
Joined: Feb 2007
Posts: 579
Likes: 0
Originally Posted by 96_LXR
I found that if remove all the gridlines in the Excel sheet, then copy to Notepad, then take it from Notepad to Ecuflash that it works correctly.

I can also see that when you select all the data sometimes you will see (as andenbre pointed out) that sometimes the selection will go one character past the end of the data.

Anyway I am glad that this works. I find it easier to work with a graph of the two maps so you can visualize the difference in values.

Below is a pic of the 3500 RPM timing values.



Thanks for all the help
You wouldn't want to share your excel spreadsheet would you?

This could help a noob like me more easily see mapping differences and changes as well
Reply
Old Apr 2, 2007 | 02:44 PM
  #12  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
I can send you the spreadsheet. It is really helpful for me to be able to look at each RPM and Load range and see where it is at comperd to the current tune.

Kind of a bonus is it will work with the fuel maps as well. You have to paste the data in the 500 cell instead of zero (there's no zero range for the fuel, DER).

Anyway it is kinda cool to be able to see the differences between the two.

I have been taking some timing out of my car in the 80 to 100 load range and have been getting some good results, smooth power, low knock counts, ect.
Reply
Old Apr 3, 2007 | 04:06 PM
  #13  
oldevodude's Avatar
Evolved Member
iTrader: (3)
 
Joined: Feb 2007
Posts: 579
Likes: 0
Originally Posted by 96_LXR
I can send you the spreadsheet. It is really helpful for me to be able to look at each RPM and Load range and see where it is at comperd to the current tune.

Kind of a bonus is it will work with the fuel maps as well. You have to paste the data in the 500 cell instead of zero (there's no zero range for the fuel, DER).

Anyway it is kinda cool to be able to see the differences between the two.

I have been taking some timing out of my car in the 80 to 100 load range and have been getting some good results, smooth power, low knock counts, ect.
Thanks can you pelase send it to duderous@sbcglobal.net

Thanks Again
Reply
Old Apr 3, 2007 | 08:54 PM
  #14  
96_LXR's Avatar
Thread Starter
Evolving Member
iTrader: (3)
 
Joined: Jun 2004
Posts: 203
Likes: 0
From: Pacific Northwest
Should be on it's way, good luck
Reply
Old Apr 4, 2007 | 09:38 PM
  #15  
oldevodude's Avatar
Evolved Member
iTrader: (3)
 
Joined: Feb 2007
Posts: 579
Likes: 0
Thanks
Again
Reply



All times are GMT -7. The time now is 09:36 AM.