Map Tracing spreadsheet - looking for feedback
Nov 29, 2009, 06:47 PM
#34
Newbie
Join Date: Jan 2009
Location: Long Beach, CA
Posts: 55
Likes: 0
Received 0 Likes
on
0 Posts
Dec 3, 2009, 04:48 PM
#35
Evolving Member
Join Date: Mar 2006
Posts: 228
Likes: 0
Received 0 Likes
on
0 Posts
Here is an updated version of ouminan's Map Tracing spreadsheet which should work with Big Maps. I think I have changed everything which needs to be but should be a good start if any of you guys want to tweak it further.
Link to ouminans original post with instructions..
https://www.evolutionm.net/forums/5655899-post1.html
Link to ouminans original post with instructions..
https://www.evolutionm.net/forums/5655899-post1.html
Dec 4, 2009, 09:32 PM
#36
Evolved Member
iTrader: (12)
Join Date: Dec 2003
Location: Farmington, NM
Posts: 591
Likes: 0
Received 0 Likes
on
0 Posts
You sir, are my hero. Unfortunately, I am getting an error when i try to chart. Run Time error 438 which points to "Sheet1.Shapes.AddChart.Select". Maybe an office compatibility issue? (I'm on 2003 and I know this was written for 2007)...
Also, on some of the traces, it superimposes the AFR's in the RPM column.
I never took Visual Basic, so can someone help me out?
For what it's worth I could NEVER GET EVOSCAN to really work for viewing my logs, whereas this handy little spreadsheet gave me everything I needed. To boot, it was easy to use and rock steady every time. I think this would be a tremendous asset to the self tuners here and is definitely worth posting to the ECU wiki once the bugs for the bigmap version are ironed out.
Also, on some of the traces, it superimposes the AFR's in the RPM column.
I never took Visual Basic, so can someone help me out?
For what it's worth I could NEVER GET EVOSCAN to really work for viewing my logs, whereas this handy little spreadsheet gave me everything I needed. To boot, it was easy to use and rock steady every time. I think this would be a tremendous asset to the self tuners here and is definitely worth posting to the ECU wiki once the bugs for the bigmap version are ironed out.
Dec 5, 2009, 11:18 AM
#37
Evolving Member
iTrader: (7)
Join Date: Feb 2004
Location: Fort Walton Beach, FL
Posts: 244
Likes: 0
Received 0 Likes
on
0 Posts
Not to rain on any parades or anything, but a tool for doing this has been around for quite sometime in the Subaru world that would work just as easily on the Evos. It is called the AirBoy Dyno spreadsheet. It actually will calculate hp/trq numbers if you have the right weight/gearing/ect figures to pug into your logs. Looks nice and maybe you can take a look at his stuff and develop new things from it.
Dec 5, 2009, 06:33 PM
#39
Evolved Member
iTrader: (12)
Join Date: Dec 2003
Location: Farmington, NM
Posts: 591
Likes: 0
Received 0 Likes
on
0 Posts
Not to rain on any parades or anything, but a tool for doing this has been around for quite sometime in the Subaru world that would work just as easily on the Evos. It is called the AirBoy Dyno spreadsheet. It actually will calculate hp/trq numbers if you have the right weight/gearing/ect figures to pug into your logs. Looks nice and maybe you can take a look at his stuff and develop new things from it.
Now, back to help with Visual Basic errors.
Dec 6, 2009, 08:00 AM
#40
Evolving Member
iTrader: (7)
Join Date: Feb 2004
Location: Fort Walton Beach, FL
Posts: 244
Likes: 0
Received 0 Likes
on
0 Posts
I am the one with a reading problem? It does everything yours does AND calculates horsepower. Just check it out. I am not trying to be a dick, but there is no need to reinvent the wheel. Take what airboy has done and see what you can improve upon instead of wasting your time trying to recreate it.
Dec 6, 2009, 02:02 PM
#41
Evolved Member
iTrader: (12)
Join Date: Dec 2003
Location: Farmington, NM
Posts: 591
Likes: 0
Received 0 Likes
on
0 Posts
I did check it out.
And it does not have the resolution for big maps either. It's also too complicated. The reason I like this maptracer spreadsheet is because it follows the KISS principle. All I'm looking for is a tool to give me a quick graphical representation of my logs, and one that quickly lets me see the cells I'm in without having to look back and forth at a log.
And it does not have the resolution for big maps either. It's also too complicated. The reason I like this maptracer spreadsheet is because it follows the KISS principle. All I'm looking for is a tool to give me a quick graphical representation of my logs, and one that quickly lets me see the cells I'm in without having to look back and forth at a log.
Dec 6, 2009, 03:08 PM
#42
Evolved Member
iTrader: (12)
Join Date: Dec 2003
Location: Farmington, NM
Posts: 591
Likes: 0
Received 0 Likes
on
0 Posts
I'm pretty sure the problem has to do with office 2003 not recognizing syntax for shapes.addchart.
Does anyone know the office 2003 syntax equivalent? I've tried charts.add.select but that just crashes because the references are not in expected syntax.
Does anyone know the office 2003 syntax equivalent? I've tried charts.add.select but that just crashes because the references are not in expected syntax.
