RomRaider Logo

RomRaider

Open Source ECU Tools
 FAQ •  Register •  Login 

RomRaider

Documentation

Community

Developers

It is currently Tue Dec 23, 2025 9:12 am

All times are UTC - 5 hours [ DST ]





Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Excel spreadscheet to rescale tables
PostPosted: Mon Mar 25, 2019 1:47 am 
Offline
Moderator

Joined: Wed Nov 22, 2006 10:23 pm
Posts: 2565
Note: This spreadsheet uses a VBA macro, so you'll need to enable to macros to use it. If the rescaled table is full of cells that say "#NAME!" (I think that's the error) it's because you don't have macros enabled.

The first page of the spreadsheet rescales on the vertical axis (e.g the RPM axis of the fueling and timing tables). The second page rescales horizontally (e.g. the Load axis of the fueling and timing tables). Rescaling in both directions in a single operation would be harder, so if you need rescaling in both directions you'll have to do it in two steps.

To use this spreadsheet:

0) Save it, and then change the extension to .xlsm.

1) Open it in Excel, and enable macros.

2) Paste tables values from EcuFlash into the "Original Table" section. This has to be done in three copy-paste operations, one each for the row headers, column headers, and the cell values.

3) Edit the values that generate the row headers (or column headers) for the rescaled table.

4) Copy the new row headers (or column headers) and table cells from the "Rescaled Table" section.

5) SANITY CHECK EVERYTHING.

This spreadsheet won't produce values for rows that are outside the range of the original table. Those cells will say "#VALUE!" so don't copy them into EcuFlash. Just copy what you can, and guesstimate the rest based on the shape of the existing data. Guess conservatively (less timing, or richer AFR) and tune from there.


Attachments:
File comment: Table rescaling utility.
Change the extension to .XLSM before using.

Rescale.txt [26.79 KiB]
Downloaded 465 times

_________________
2005 Legacy GT w/ ATP 3076, IWG, MBC, BCS, BC 272, LC, FFS, OMG
Please don't send questions via PM. Post a thread and send me a link to it instead. Thanks!
Top
 Profile  
 
 Post subject: Re: Excel spreadscheet to rescale tables
PostPosted: Mon Mar 25, 2019 1:55 pm 
Offline
Experienced

Joined: Sun Jul 13, 2014 6:12 pm
Posts: 111
Can I add this here NSFW? I have one that does all manner of map sizes or custom and is just standard excel, no VBA required.

It even adds 2 the base and advance maps if the scales are different on the Ignition Timing Special tab. It's built around the BRZ so the Custom tab will suit everyone's needs.


Attachments:
K47 - Scale Changer.xlsx [590.49 KiB]
Downloaded 431 times
Top
 Profile  
 
 Post subject: Re: Excel spreadscheet to rescale tables
PostPosted: Mon Mar 25, 2019 3:36 pm 
Offline
Moderator

Joined: Wed Nov 22, 2006 10:23 pm
Posts: 2565
Nice!

_________________
2005 Legacy GT w/ ATP 3076, IWG, MBC, BCS, BC 272, LC, FFS, OMG
Please don't send questions via PM. Post a thread and send me a link to it instead. Thanks!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style based on FI Subsilver by phpBBservice.nl