Project

General

Profile

Idea #24153

Device Scaling Transforms Audit

Added by Beau Harrison 5 months ago. Updated 5 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
03/09/2020
Due date:
% Done:

0%

Estimated time:
Duration:

Description

In the interest of understanding the scope of Controls features, I dumped the count of transforms being used.

Some of these transforms are complex and impossible to unscale. It would be nice to consolidate these where appropriate and retire the most complex ones that aren't needed.

Primary transform count:

SELECT ds.primary_index, td.transform_id, td.text, COUNT(*) instance_count
FROM pdb_transform_descr td
JOIN device_scaling ds
ON td.transform_id = ds.primary_index
WHERE td.prim_comm_transform = 'prim'
GROUP BY ds.primary_index, td.transform_id, td.text
ORDER BY ds.primary_index;
 primary_index transform_id text                                                         instance_count
 ------------- ------------ ------------------------------------------------------------ --------------
          NULL           48 X = (IEEE FP -> DEC FP) / 0.036                                           1
          NULL            6 X = FLOAT(input) / 13107.2                                                1
             0            0 X = FLOAT(input) / 3200.0                                             22779
             2            2 X = FLOAT(input) / 3276.8                                             49209
             4            4 X = FLOAT(input) / 6553.6                                               154
             8            8 X = FLOAT(input) + 32768.0                                              153
            10           10 X = FLOAT(input) -->  all DEC                                         59224
            12           12 X = FLOAT(input) / 320.0                                                239
            14           14 X = CAMAC 2323 data handler                                               5
            16           16 X = IEEE-DEC floating format (standard)                               45408
            18           18 X = FLOAT(input) * .001040625                                             3
            20           20 X = 8/16-bit unsigned data handler                                    13375
            22           22 X = input                                                              8394
            24           24 X = IEEE-DEC floating format (byte-swapped for 68000)                 61442
            26           26 X = FLOAT(ABS(input/256))/82.1865-0.310269935                           363
            28           28 X = FLOAT(input) -->  68000 I*4                                       13936
            30           30 X = FLOAT(lo byte of input)                                              13
            32           32 X = FLOAT(hi byte of input)                                             134
            34           34 X = FLOAT(ABS(lo byte of input))                                        541
            36           36 X = FLOAT(ABS(hi byte of input))                                         57
            38           38 X = FLOAT(ABS(input/65536.0))/82.1865-0.310269935                       120
            40           40 X = FLOAT(input) / 256.0                                               1822
            42           42 X = 16-bit unipolar 10V DAC handler                                    7869
            44           44 X = 7-digit BCD input handler                                             8
            46           46 X = FLOAT(input) (unsigned 32 bit)                                     4793

Common transform count:

SELECT ds.common_index, td.transform_id, td.text, COUNT(*) instance_count
FROM pdb_transform_descr td
JOIN device_scaling ds
ON td.transform_id = ds.common_index
WHERE td.prim_comm_transform = 'comm'
GROUP BY ds.common_index, td.transform_id, td.text
ORDER BY ds.common_index;
 common_index transform_id text                                                         instance_count
 ------------ ------------ ------------------------------------------------------------ --------------
            0            0 X' = X                                                               150024
            2            2 X' = (C1*X/C2)+C3                                                     52360
            4            4 X' = (X-C1)/C2                                                        20839
            6            6 X' = C1*X/C2                                                          58055
            8            8 X' = C4+(C1*X)/(C3+C2*X)                                                193
           10           10 X' = C3+(C2/(C1*X))                                                      24
           12           12 X' = C5+(C4*X)+(C3*X^2)+(C2*X^3)+(C1*X^4)                               789
           14           14 X' = EXP(C5+(C4*X)+(C3*X^2)+(C2*X^3)+(C1*X^4))-C6                       289
           16           16 X' = C2*EXP(-X/C1)+C4*EXP(-X/C3)                                         30
           18           18 X' = C3*EXP(C2*(X+C1))+C6*EXP(C5*(X+C4))                               1244
           20           20 X' = LOG10(X)/(C1*LOG10(X)+C2)^2+C3                                     629
           22           22 X' = C2*(10.0^(X/C1))                                                   574
           24           24 X' = C2*(C3*X+C4) on X<C1 or C2*EXP(C5*X+C6) on X>C1                     53
           26           26 X' = C6+(C5*X)+(C4*X^2)+(C3*X^3)+(C2*X^4)+(C1*X^5)                      805
           28           28 X' = C3/(C2+C1*X)+C4                                                    171
           30           30 X' = C5+(C4*X)+(C3*X^2)+(C2*X^3) -or- X'=C6 on X<C1                      17
           32           32 X' = C2*LOGe(C1*X+C4)+C3                                                 37
           34           34 X' = (C2+C1*X)/(C4+C3*X)                                                  9
           36           36 X' = C2*SQRT(X+C1)+C3                                                    50

History

#1 Updated by Beau Harrison 5 months ago

  • Description updated (diff)


Also available in: Atom PDF