Idea #24153
Device Scaling Transforms Audit
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
03/09/2020
Due date:
% Done:
0%
Estimated time:
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 10 months ago
- Description updated (diff)