Data Extraction, Analysis and Formatting for Reports

The Templex read statement is used to access a vector of data from a results file. The read statement automatically recognizes all result file types supported by import templates or external readers registered with your MotionView or HyperGraph installation. Import templates and external readers describe the file format, allowing Templex direct access to specific results vectors.

0.0000000000e+00
1.0000000000e+00
2.0000000000e+00
3.0000000000e+00
4.0000000000e+00
5.0000000000e+00
6.0000000000e+00
7.0000000000e+00
8.0000000000e+00
9.0000000000e+00
1.0000000000e+01

0.0000000000e+00
-2.0452000000e-01
-2.0996000000e+02
1.3688000000e+02
-2.0412000000e+03
-4.5116000000e+03
-7.5309000000e+03
-9.4560000000e+03
-7.0598000000e+03
-4.3536000000e+03
-5.6833000000e+01

{x = read("curve.dat", 0, 0, 0) 'Read column 0 into }
{y = read("curve.dat", 0, 0, 1) 'Read column 1 into y vector}
{ny = -y}
{ymax = max(ny)}
The maximum negative value of {-ymax} occurs at x = {x[indexofmax(ny)]}

Any text outside the braces is treated as plain text. Plain text is copied to the output stream exactly as it appears in the template. Templex statements, expressions and variables are located within braces, {}. If the Templex statement generates output, the resulting value is sent to the output stream.

The maximum negative value of -9456 occurs at x = 7

{x = read("curve.dat", 0, 0, 0) 'Read column 0 into x vector}
{y = read("curve.dat", 0, 0, 1) 'Read column 1 into y vector}
{result = polyfit(x,y,6)}
{open "curvefit.out"}
    "X"          "Y"      Polyfit "Y"
-----------  -----------  -----------
{table(x, y, result, "%12.6f %12.6f %12.6f", 0, numpts(x)-1)}
{close}

Polynomial coefficients:
+4.61436e+01 * X^0
-1.23808e+03 * X^1
+1.30333e+03 * X^2
-3.38257e+02 * X^3
-3.88651e+00 * X^4
+6.09099e+00 * X^5
-3.50098e-01 * X^6
Mean deviation: 3.33713e+02
Correlation coefficient: 9.91274e-01

0.000000
1.000000
2.000000
3.000000
4.000000
5.000000
6.000000
7.000000
8.000000
9.000000
10.000000

0.000000
-0.204520
-209.960000
136.880000
-2041.200000
-4511.600000
-7530.900000
-9456.000000
-7059.800000
-4353.600000
-56.833000

46.143579
-225.009132
187.561497
-161.006006
-1893.164101
-4708.213938
-7533.633874
-8928.478798
-7738.850272
-4005.437480
-123.128993

In the next example, the template reads in a file containing wheel center displacements and spindle alignment point displacements which result from stroking a suspension from jounce to rebound. This information is used to calculate camber and toe for each output position. The result is formatted and sent to the standard output stream.

{increment = read("sdf.dat", 0, 0, 0)}
{wcx   = read("sdf.dat", 0, 0, 1)}
{wcy   = read("sdf.dat", 0, 0, 2)}
{wcz   = read("sdf.dat", 0, 0, 3)}
{spax  = read("sdf.dat", 0, 0, 4)}
{spay  = read("sdf.dat", 0, 0, 5)}
{spaz  = read("sdf.dat", 0, 0, 6)}
{n = numpts(increment)}
{camber = array(n)}
{toe    = array(n)}
Inc     wcx           wcy           wcz
--- ------------  ------------  ------------
{table(increment, wcx, wcy, wcz,"%2d  %12.6f  %12.6f  %12.6f", 0, n-1)}
Inc     spax          spay          spaz
--- ------------  ------------  ------------
{table(increment, spax, spay, spaz, "%2d  %12.6f  %12.6f  %12.6f", 0, n-1)}
{for(i=0; i<=10; i++)}
  {temp1 = spaz[i] - wcz[i]}
  {temp2 = sqrt((wcy[i]-spay[i])^2+(wcz[i]-spaz[i])^2)}
  {temp3 = wcx[i] - spax[i]}
  {temp4 = sqrt((wcx[i]-spax[i])^2+(wcy[i]-spay[i])^2)}
  {camber[i] = rtod(asin(temp1/temp2))}
  {toe[i]    = rtod(asin(temp3/temp4))}
{endloop}
Inc    camber         toe  
--- ------------  ------------
{table(increment, camber, toe, "%2d  %12.6f  %12.6f", 0, n-1)}