Search found 9 matches

by gitman
Sun Sep 21, 2014 11:31 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

sorry no, i have not had time to work on this. family and work. i'll post an update when i can. i appreciate the direction.

thanks,
by gitman
Tue Sep 16, 2014 11:24 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

We're speaking specifically about the row axis conversion. Not the column, not the main table. My suggestion is based on the information you provided in the initial posts. ok. its just that i'm not understanding how to enter a table-wide equation that affects only the row axis, and then how to ente...
by gitman
Tue Sep 16, 2014 9:30 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

apologies, but i'm not understanding how to do that based on the requirements: the main cells have a conversion factor of X*0.75. the column axis has a conversion factor of X*40. the Row axis is what i'm trying to get working like the "Eprom, subtract" option in WinOLS, while still keeping...
by gitman
Tue Sep 16, 2014 9:03 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

the length of it is attributed to the fact that i'm using 4 IF()'s and modifying the equation based on the cell index number. it shouldn't be any more work for the application than specifying an equation for each cell in the axis, just instead of the application conditionally applying an equation ba...
by gitman
Tue Sep 16, 2014 8:43 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

Even with the per-cell equation on the last cell? i haven't attempted to go that route yet, still trying to see if i can accomplish everything with a single equation appears the conversion editor window only supports up to 255 characters. i'm trying to use nested if statements to arrive at the prop...
by gitman
Tue Sep 16, 2014 6:57 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

i think i may have stumbled on to at least a reason for seeing what i'm seeing. so if i put in CELL(INDEX();TRUE) , i am able to see the precalc value for the cell. i can then change that to CELL(INDEX()+1;TRUE) and it basically moves everything up 1 row. once i change the "precalc" param ...
by gitman
Tue Sep 16, 2014 6:41 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

I'll have to add error messaging. The equations fail to be saved because they're invalid. so when it says its valid, that's probably based more on the use of operators, etc., and not functions. am i correct in thinking that? The first one fails because you should be using semicolons for parameter d...
by gitman
Mon Sep 15, 2014 6:27 pm
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

good point about the last cell. TBH i'm not totally sure where it's supposed to get its data for the last cell, but i know what its supposed to be by looking at WinOLS, so i came to 192. based on that, i came up with an IF() statement to handle the case of the last cell: IF(INDEX()+1==INDEXES();192-...
by gitman
Sun Sep 14, 2014 8:32 am
Forum: TunerPro Discussion
Topic: something wrong with my axis conversion?
Replies: 20
Views: 45432

something wrong with my axis conversion?

i am trying to duplicate the "Eprom, subtract" function in WinOLS for an axis definition. if i try to enter the following equation into the Conversion Editor for the Row axis... CELL(INDEX() + 1, FALSE)-(THIS() * 0.75) ...the Conversion Editor says that the format looks valid, and then i h...