topic Re: Trying to avoid Transposition in Discussions

Trying to avoid Transposition

SpannerHead — Thu, 09 Apr 2026 18:09:03 GMT

I have a script that works but applies transposition for that to happen. Wondering if there's a less clunky way to achieve the goal? I have 3 columns, one contains a quadratic coefficient(a), the second contains a linear coefficient(b), and the third contains a constant(c). When multiplied by an input variable x, I get an arc. Is there a way to form that arc without transposing the data to do so? Presently, I create columns with incremental changes in x in a transposed table but the data is very digital and there may be a better approach.

ax² + bx + c = 0

Re: Trying to avoid Transposition

txnelson — Fri, 10 Apr 2026 03:39:08 GMT

Take a look at the Y Function

Re: Trying to avoid Transposition

SpannerHead — Fri, 10 Apr 2026 13:52:15 GMT

Jim

Thanks for this, don't seem to be able to find a decipherable example of that. I did suspect there was a better way to do this. Incidentally, the upper limit of X is stored in a column also.

Re: Trying to avoid Transposition

jthi — Fri, 10 Apr 2026 14:01:44 GMT

Pull values from your table to the example found from Scripting Index. Evaluate the values to the the Y Function for example with Eval(EvalExpr())

Names Default To Here(1);
New Window("Example",
	Graph Box(
		Pen Color("red");
		Y Function(20 + 40 * Sin(a / 30), a);
	)
);

Optionally you can create formula column and use Profiler

Re: Trying to avoid Transposition

SpannerHead — Wed, 15 Apr 2026 20:54:11 GMT

Tried this but I need to raise x to the power 2 and that seems to be where it fails.

Names Default To Here(1);

dt = Current Data Table();

nw = New Window("window", vlb = V List Box());
For Each Row(dt,
	Eval(EvalExpr(
		vlb << Append(Graph Box(Y Function(Expr(dt[Row(), "HL_HR1_R"]) + Expr(dt[Row(), "HL_HR2_R"]) * x + Expr(dt[Row(), "HL_HR3_R"]) * Power (x, 2) ,x)));
	))
);

Re: Trying to avoid Transposition

mmarchandFSLR — Wed, 15 Apr 2026 21:28:51 GMT

How does it fail? Any error message? Your code works when I run it on a dummy table with four rows. I just might want to adjust the axes some.

Re: Trying to avoid Transposition

SpannerHead — Wed, 15 Apr 2026 21:36:17 GMT

Error was self inflicted, you're right, it does plot. I have 2 remaining challenges.

1 I would like all the plots on a single graph.

2 I would like to limit x for each plot to a value stored in another data column. Generally, that value is >100.

Re: Trying to avoid Transposition

mmarchandFSLR — Wed, 15 Apr 2026 21:41:21 GMT

Something like this should work. I added a column called "X Limit" and put a couple numbers in there.

Names Default To Here( 1 );

dt = Current Data Table();

nw = New Window( "window", gb = Graph Box( X Scale( 0, 120 ), Y Scale( 0, 35000 ) ) );
For Each Row(
	dt,
	Eval(
		Eval Expr(
			gb[FrameBox( 1 )] << Add Graphics Script(
				Y Function(
					Expr( dt[Row(), "HL_HR1_R"] ) + Expr( dt[Row(), "HL_HR2_R"] ) * x + Expr( dt[Row(), "HL_HR3_R"] ) * Power( x, 2 ),
					x,
					Max( Expr( dt[Row(), "X Limit"] ) )
				)
			)
		)
	)
);

Re: Trying to avoid Transposition

SpannerHead — Thu, 16 Apr 2026 14:51:40 GMT

This approach works, however, it is much slower than the transposition method I was originally using. I can have a lot of data to process unfortunately.