Group String data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
My table name is Meas_Numericlimit.
Sample Data is as below. ( Different temperature, testcase type,
testcase_suffix is possible).
ID STEP_RESULT Dut_ID Operator Project Temperature TestCase TestCase_suffix PARAMETER COMP_OPERATOR HIGH_LIMIT LOW_LIMIT DATA UNITS STATUS
2224 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.51312389 V Passed
2225 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50919125 V Passed
2226 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0034141 V Passed
2227 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.81994227 V Passed
2228 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81680428 V Passed
2229 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0028166 V Passed
2325 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.5152445 V Passed
2326 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50867502 V Passed
2327 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0052497 V Failed
2328 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.82458399 V Passed
2329 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81896854 V Passed
2330 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0050469 V Passed


I am using following query

SELECT MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
Sum(IIf(temperature=-30,data,0)) AS [-30C], Sum(IIf(temperature=-10,data,0))
AS [-10C], Sum(IIf(temperature=0,data,0)) AS 0C,
Sum(IIf(temperature=25,data,0)) AS 25C, Sum(IIf(temperature=55,data,0)) AS
55C, Sum(IIf(temperature=85,data,0)) AS 85C, MEAS_NUMERICLIMIT.HIGH_LIMIT,
MEAS_NUMERICLIMIT.LOW_LIMIT, MEAS_NUMERICLIMIT.UNITS, "" AS Comment
FROM MEAS_NUMERICLIMIT
WHERE (((MEAS_NUMERICLIMIT.STEP_RESULT) Between 2427 And 2544) AND
((MEAS_NUMERICLIMIT.TestCase)="Line Transient Test") AND
((MEAS_NUMERICLIMIT.TestCase_suffix)="VAUX"))
GROUP BY MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
MEAS_NUMERICLIMIT.HIGH_LIMIT, MEAS_NUMERICLIMIT.LOW_LIMIT,
MEAS_NUMERICLIMIT.UNITS, "";

Out put of this query returns data with two separate data for Status when
Parameter is "Maxpk2pk" (Pass and Failed). I want only one status. (If for
any temperature Status is Failed then output status should be Failed. Else it
should be Pass.)
Is this possible? and how?
 
something like:


SELECT operatorID, MIN(status)
FROM dataTable
GROUP BY operatorID


should do. Since 'Passed' comes after 'Failed', in the dictionary, in order
to get Passed as result of MIN(status), all status have to be Passed (or
NULL), but none can be 'Failed', else, that 'Failed' will be the result of
the MIN.



Hoping it may help,
Vanderghast, Access MVP



Vishal said:
Hi,
My table name is Meas_Numericlimit.
Sample Data is as below. ( Different temperature, testcase type,
testcase_suffix is possible).
ID STEP_RESULT Dut_ID Operator Project Temperature TestCase
TestCase_suffix PARAMETER COMP_OPERATOR HIGH_LIMIT LOW_LIMIT DATA UNITS
STATUS
2224 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.51312389 V Passed
2225 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50919125 V Passed
2226 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0034141 V Passed
2227 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.81994227 V Passed
2228 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81680428 V Passed
2229 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0028166 V Passed
2325 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.5152445 V Passed
2326 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50867502 V Passed
2327 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0052497 V Failed
2328 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.82458399 V Passed
2329 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81896854 V Passed
2330 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0050469 V Passed


I am using following query

SELECT MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
Sum(IIf(temperature=-30,data,0)) AS [-30C],
Sum(IIf(temperature=-10,data,0))
AS [-10C], Sum(IIf(temperature=0,data,0)) AS 0C,
Sum(IIf(temperature=25,data,0)) AS 25C, Sum(IIf(temperature=55,data,0)) AS
55C, Sum(IIf(temperature=85,data,0)) AS 85C, MEAS_NUMERICLIMIT.HIGH_LIMIT,
MEAS_NUMERICLIMIT.LOW_LIMIT, MEAS_NUMERICLIMIT.UNITS, "" AS Comment
FROM MEAS_NUMERICLIMIT
WHERE (((MEAS_NUMERICLIMIT.STEP_RESULT) Between 2427 And 2544) AND
((MEAS_NUMERICLIMIT.TestCase)="Line Transient Test") AND
((MEAS_NUMERICLIMIT.TestCase_suffix)="VAUX"))
GROUP BY MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
MEAS_NUMERICLIMIT.HIGH_LIMIT, MEAS_NUMERICLIMIT.LOW_LIMIT,
MEAS_NUMERICLIMIT.UNITS, "";

Out put of this query returns data with two separate data for Status when
Parameter is "Maxpk2pk" (Pass and Failed). I want only one status. (If for
any temperature Status is Failed then output status should be Failed. Else
it
should be Pass.)
Is this possible? and how?
Click to expand...
 
HI Michel,
Thanks a lot.
It worked. :-)

vishal

Michel Walsh said:
something like:


SELECT operatorID, MIN(status)
FROM dataTable
GROUP BY operatorID


should do. Since 'Passed' comes after 'Failed', in the dictionary, in order
to get Passed as result of MIN(status), all status have to be Passed (or
NULL), but none can be 'Failed', else, that 'Failed' will be the result of
the MIN.



Hoping it may help,
Vanderghast, Access MVP



Vishal said:
Hi,
My table name is Meas_Numericlimit.
Sample Data is as below. ( Different temperature, testcase type,
testcase_suffix is possible).
ID STEP_RESULT Dut_ID Operator Project Temperature TestCase
TestCase_suffix PARAMETER COMP_OPERATOR HIGH_LIMIT LOW_LIMIT DATA UNITS
STATUS
2224 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.51312389 V Passed
2225 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50919125 V Passed
2226 2431 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0034141 V Passed
2227 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.81994227 V Passed
2228 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81680428 V Passed
2229 2434 AVilma Slot3 Vishal CeBBo2 85 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0028166 V Passed
2325 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MaxVoltage >=<= 2.6 2.4 2.5152445 V Passed
2326 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX MinVoltage >=<= 2.6 2.4 2.50867502 V Passed
2327 2528 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VAUX Maxpk2pk <= 0.03 0.0052497 V Failed
2328 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MaxVoltage >=<= 1.92 1.72 1.82458399 V Passed
2329 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO MinVoltage >=<= 1.92 1.72 1.81896854 V Passed
2330 2531 AVilma Slot3 Vishal CeBBo2 0 Line Transient
Test VIO Maxpk2pk <= 0.03 0.0050469 V Passed


I am using following query

SELECT MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
Sum(IIf(temperature=-30,data,0)) AS [-30C],
Sum(IIf(temperature=-10,data,0))
AS [-10C], Sum(IIf(temperature=0,data,0)) AS 0C,
Sum(IIf(temperature=25,data,0)) AS 25C, Sum(IIf(temperature=55,data,0)) AS
55C, Sum(IIf(temperature=85,data,0)) AS 85C, MEAS_NUMERICLIMIT.HIGH_LIMIT,
MEAS_NUMERICLIMIT.LOW_LIMIT, MEAS_NUMERICLIMIT.UNITS, "" AS Comment
FROM MEAS_NUMERICLIMIT
WHERE (((MEAS_NUMERICLIMIT.STEP_RESULT) Between 2427 And 2544) AND
((MEAS_NUMERICLIMIT.TestCase)="Line Transient Test") AND
((MEAS_NUMERICLIMIT.TestCase_suffix)="VAUX"))
GROUP BY MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.STATUS,
MEAS_NUMERICLIMIT.HIGH_LIMIT, MEAS_NUMERICLIMIT.LOW_LIMIT,
MEAS_NUMERICLIMIT.UNITS, "";

Out put of this query returns data with two separate data for Status when
Parameter is "Maxpk2pk" (Pass and Failed). I want only one status. (If for
any temperature Status is Failed then output status should be Failed. Else
it
should be Pass.)
Is this possible? and how?
Click to expand...
Click to expand...
 
Hi,
My table structure got changed a little bit (Kept sample data at the end of
this post). Due to this I have to change my query as well. My current query
is :
SELECT MEAS_NUMERICLIMIT.PARAMETER, First(CStr(MEAS_NUMERICLIMIT.STATUS)) AS
Status, Sum(IIf(MEAS_NUMERICLIMIT.STEP_RESULT=2522,MEAS_NUMERICLIMIT.data,0))
AS [-25C],
Sum(IIf(MEAS_NUMERICLIMIT.STEP_RESULT=2500,MEAS_NUMERICLIMIT.data,0)) AS
[-10C], Sum(IIf(MEAS_NUMERICLIMIT.STEP_RESULT=2474,MEAS_NUMERICLIMIT.data,0))
AS [0C],
Sum(IIf(MEAS_NUMERICLIMIT.STEP_RESULT=2448,MEAS_NUMERICLIMIT.data,0)) AS
[55C], Sum(IIf(MEAS_NUMERICLIMIT.STEP_RESULT=2422,MEAS_NUMERICLIMIT.data,0))
AS [75C]
, MEAS_NUMERICLIMIT.LOW_LIMIT, MEAS_NUMERICLIMIT.HIGH_LIMIT,
MEAS_NUMERICLIMIT.UNITS, "" AS Comment
FROM MEAS_NUMERICLIMIT
WHERE ((MEAS_NUMERICLIMIT.STEP_RESULT in (2522,2500,2474,2448,2422)))
GROUP BY MEAS_NUMERICLIMIT.PARAMETER, MEAS_NUMERICLIMIT.LOW_LIMIT,
MEAS_NUMERICLIMIT.HIGH_LIMIT, MEAS_NUMERICLIMIT.UNITS, ""
ORDER BY Sum(MEAS_NUMERICLIMIT.ID);

Due to this I get the status but it shows that of the First Step_result. It
is not sorting the Status as such.
Please advise.
Thanks.
Vishal
Sample data.
ID STEP_RESULT PARAMETER COMP_OPERATOR HIGH_LIMIT LOW_LIMIT UNITS DATA STATUS
17079 2422 CMD_In_NOverShoot_MIN < 10 % 7.7465 Passed
17080 2422 CMD_In_NOverShoot_mean < 10 % 7.9225 Passed
17081 2422 CMD_In_NOverShoot_MAX < 10 % 8.4507 Passed
17082 2422 CMD_In_fall_time_MIN < 10 ns 4.5486 Passed
17083 2422 CMD_In_fall_time_mean < 10 ns 4.9456 Passed
17084 2422 CMD_In_fall_time_MAX < 10 ns 5.6343 Passed
17085 2422 CMD_In_POverShoot_MIN < 10 % 7.7465 Passed
17086 2422 CMD_In_POverShoot_mean < 10 % 7.9225 Passed
17087 2422 CMD_In_POverShoot_MAX < 10 % 8.4507 Passed
17088 2422 CMD_In_rise_time_MIN < 10 ns 1.552 Passed
17089 2422 CMD_In_rise_time_mean < 10 ns 1.6603 Passed
17090 2422 CMD_In_rise_time_MAX < 10 ns 1.7143 Passed
17091 2422 CMD_In_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17092 2422 CMD_In_voltage_level_LOW_mean < 0.5985 V -0.015 Passed
17093 2422 CMD_In_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17094 2422 CMD_In_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17095 2422 CMD_In_voltage_level_HIGH_mean > 1.2285 V 2.825 Passed
17096 2422 CMD_In_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17097 2422 CMD_In_voltage_level_MAX_min LOG V 3.04 Passed
17098 2422 CMD_In_voltage_level_MAX_mean LOG V 3.05 Passed
17099 2422 CMD_In_voltage_level_MAX_max LOG V 3.08 Passed
17100 2422 CMD_In_voltage_level_MIN_min LOG V -0.24 Passed
17101 2422 CMD_In_voltage_level_MIN_mean LOG V -0.24 Passed
17102 2422 CMD_In_voltage_level_MIN_max LOG V -0.24 Passed
17376 2448 CMD_In_NOverShoot_MIN < 10 % 6.338 Passed
17377 2448 CMD_In_NOverShoot_mean < 10 % 7.2183 Passed
17378 2448 CMD_In_NOverShoot_MAX < 10 % 8.4507 Passed
17379 2448 CMD_In_fall_time_MIN < 10 ns 4.456 Passed
17380 2448 CMD_In_fall_time_mean < 10 ns 4.5817 Passed
17381 2448 CMD_In_fall_time_MAX < 10 ns 4.865 Passed
17382 2448 CMD_In_POverShoot_MIN < 10 % 7.7465 Passed
17383 2448 CMD_In_POverShoot_mean < 10 % 8.6268 Passed
17384 2448 CMD_In_POverShoot_MAX < 10 % 9.1549 Passed
17385 2448 CMD_In_rise_time_MIN < 10 ns 1.5022 Passed
17386 2448 CMD_In_rise_time_mean < 10 ns 1.5376 Passed
17387 2448 CMD_In_rise_time_MAX < 10 ns 1.58 Passed
17388 2448 CMD_In_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17389 2448 CMD_In_voltage_level_LOW_mean < 0.5985 V -0.015 Passed
17390 2448 CMD_In_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17391 2448 CMD_In_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17392 2448 CMD_In_voltage_level_HIGH_mean > 1.2285 V 2.825 Passed
17393 2448 CMD_In_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17394 2448 CMD_In_voltage_level_MAX_min LOG V 3.04 Passed
17395 2448 CMD_In_voltage_level_MAX_mean LOG V 3.07 Passed
17396 2448 CMD_In_voltage_level_MAX_max LOG V 3.08 Passed
17397 2448 CMD_In_voltage_level_MIN_min LOG V -0.24 Passed
17398 2448 CMD_In_voltage_level_MIN_mean LOG V -0.22 Passed
17399 2448 CMD_In_voltage_level_MIN_max LOG V -0.2 Passed
17673 2474 CMD_In_NOverShoot_MIN < 10 % 7.0423 Passed
17674 2474 CMD_In_NOverShoot_mean < 10 % 7.7465 Passed
17675 2474 CMD_In_NOverShoot_MAX < 10 % 8.4507 Passed
17676 2474 CMD_In_fall_time_MIN < 10 ns 3.8793 Passed
17677 2474 CMD_In_fall_time_mean < 10 ns 3.9858 Passed
17678 2474 CMD_In_fall_time_MAX < 10 ns 4.0675 Passed
17679 2474 CMD_In_POverShoot_MIN < 10 % 9.8592 Passed
17680 2474 CMD_In_POverShoot_mean < 10 % 11.9718 Failed
17681 2474 CMD_In_POverShoot_MAX < 10 % 14.0845 Failed
17682 2474 CMD_In_rise_time_MIN < 10 ns 1.2027 Passed
17683 2474 CMD_In_rise_time_mean < 10 ns 1.2399 Passed
17684 2474 CMD_In_rise_time_MAX < 10 ns 1.3375 Passed
17685 2474 CMD_In_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17686 2474 CMD_In_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17687 2474 CMD_In_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17688 2474 CMD_In_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17689 2474 CMD_In_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17690 2474 CMD_In_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17691 2474 CMD_In_voltage_level_MAX_min LOG V 3.12 Passed
17692 2474 CMD_In_voltage_level_MAX_mean LOG V 3.17 Passed
17693 2474 CMD_In_voltage_level_MAX_max LOG V 3.24 Passed
17694 2474 CMD_In_voltage_level_MIN_min LOG V -0.24 Passed
17695 2474 CMD_In_voltage_level_MIN_mean LOG V -0.23 Passed
17696 2474 CMD_In_voltage_level_MIN_max LOG V -0.2 Passed
17697 2475 DAT_NOverShoot_MIN < 10 % 6.338 Passed
17698 2475 DAT_NOverShoot_mean < 10 % 7.3944 Passed
17699 2475 DAT_NOverShoot_MAX < 10 % 8.4507 Passed
17700 2475 DAT_fall_time_MIN < 10 ns 3.7067 Passed
17701 2475 DAT_fall_time_mean < 10 ns 5.1413 Passed
17702 2475 DAT_fall_time_MAX < 10 ns 5.8133 Passed
17703 2475 DAT_POverShoot_MIN < 10 % 11.2676 Failed
17704 2475 DAT_POverShoot_mean < 10 % 12.3239 Failed
17705 2475 DAT_POverShoot_MAX < 10 % 13.3803 Failed
17706 2475 DAT_rise_time_MIN < 10 ns 6.1867 Passed
17707 2475 DAT_rise_time_mean < 10 ns 6.2166 Passed
17708 2475 DAT_rise_time_MAX < 10 ns 6.296 Passed
17709 2475 DAT_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17710 2475 DAT_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17711 2475 DAT_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17712 2475 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17713 2475 DAT_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17714 2475 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17715 2475 DAT_voltage_level_MAX_min LOG V 3.16 Passed
17716 2475 DAT_voltage_level_MAX_mean LOG V 3.18 Passed
17717 2475 DAT_voltage_level_MAX_max LOG V 3.2 Passed
17718 2475 DAT_voltage_level_MIN_min LOG V -0.24 Passed
17719 2475 DAT_voltage_level_MIN_mean LOG V -0.22 Passed
17720 2475 DAT_voltage_level_MIN_max LOG V -0.2 Passed
17721 2476 DAT_NOverShoot_MIN < 10 % 7.7465 Passed
17722 2476 DAT_NOverShoot_mean < 10 % 8.8028 Passed
17723 2476 DAT_NOverShoot_MAX < 10 % 9.8592 Passed
17724 2476 DAT_fall_time_MIN < 10 ns 4.8333 Passed
17725 2476 DAT_fall_time_mean < 10 ns 4.9035 Passed
17726 2476 DAT_fall_time_MAX < 10 ns 5.016 Passed
17727 2476 DAT_POverShoot_MIN < 10 % 5.6338 Passed
17728 2476 DAT_POverShoot_mean < 10 % 7.3944 Passed
17729 2476 DAT_POverShoot_MAX < 10 % 9.1549 Passed
17730 2476 DAT_rise_time_MIN < 10 ns 5.194 Passed
17731 2476 DAT_rise_time_mean < 10 ns 5.363 Passed
17732 2476 DAT_rise_time_MAX < 10 ns 5.552 Passed
17733 2476 DAT_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17734 2476 DAT_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17735 2476 DAT_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17736 2476 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17737 2476 DAT_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17738 2476 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17739 2476 DAT_voltage_level_MAX_min LOG V 3 Passed
17740 2476 DAT_voltage_level_MAX_mean LOG V 3.04 Passed
17741 2476 DAT_voltage_level_MAX_max LOG V 3.08 Passed
17742 2476 DAT_voltage_level_MIN_min LOG V -0.28 Passed
17743 2476 DAT_voltage_level_MIN_mean LOG V -0.26 Passed
17744 2476 DAT_voltage_level_MIN_max LOG V -0.24 Passed
17745 2477 DAT_NOverShoot_MIN < 10 % 7.8571 Passed
17746 2477 DAT_NOverShoot_mean < 10 % 8.486 Passed
17747 2477 DAT_NOverShoot_MAX < 10 % 8.6957 Passed
17748 2477 DAT_fall_time_MIN < 10 ns 5.4625 Passed
17749 2477 DAT_fall_time_mean < 10 ns 5.7166 Passed
17750 2477 DAT_fall_time_MAX < 10 ns 6.1467 Passed
17751 2477 DAT_POverShoot_MIN < 10 % 11.5942 Failed
17752 2477 DAT_POverShoot_mean < 10 % 12.456 Failed
17753 2477 DAT_POverShoot_MAX < 10 % 14.4928 Failed
17754 2477 DAT_rise_time_MIN < 10 ns 6.54 Passed
17755 2477 DAT_rise_time_mean < 10 ns 6.8265 Passed
17756 2477 DAT_rise_time_MAX < 10 ns 7.19 Passed
17757 2477 DAT_voltage_level_LOW_MIN < 0.5985 V 0.02 Passed
17758 2477 DAT_voltage_level_LOW_mean < 0.5985 V 0.065 Passed
17759 2477 DAT_voltage_level_LOW_MAX < 0.5985 V 0.08 Passed
17760 2477 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17761 2477 DAT_voltage_level_HIGH_mean > 1.2285 V 2.835 Passed
17762 2477 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17763 2477 DAT_voltage_level_MAX_min LOG V 3.16 Passed
17764 2477 DAT_voltage_level_MAX_mean LOG V 3.18 Passed
17765 2477 DAT_voltage_level_MAX_max LOG V 3.24 Passed
17766 2477 DAT_voltage_level_MIN_min LOG V -0.2 Passed
17767 2477 DAT_voltage_level_MIN_mean LOG V -0.17 Passed
17768 2477 DAT_voltage_level_MIN_max LOG V -0.16 Passed
17769 2478 DAT_NOverShoot_MIN < 10 % 7.971 Passed
17770 2478 DAT_NOverShoot_mean < 10 % 9.058 Passed
17771 2478 DAT_NOverShoot_MAX < 10 % 10.8696 Failed
17772 2478 DAT_fall_time_MIN < 10 ns 4.5167 Passed
17773 2478 DAT_fall_time_mean < 10 ns 4.5881 Passed
17774 2478 DAT_fall_time_MAX < 10 ns 4.6311 Passed
17775 2478 DAT_POverShoot_MIN < 10 % 8.6957 Passed
17776 2478 DAT_POverShoot_mean < 10 % 9.7826 Passed
17777 2478 DAT_POverShoot_MAX < 10 % 10.8696 Failed
17778 2478 DAT_rise_time_MIN < 10 ns 5.4 Passed
17779 2478 DAT_rise_time_mean < 10 ns 5.7645 Passed
17780 2478 DAT_rise_time_MAX < 10 ns 6.4756 Passed
17781 2478 DAT_voltage_level_LOW_MIN < 0.5985 V 0.06 Passed
17782 2478 DAT_voltage_level_LOW_mean < 0.5985 V 0.07 Passed
17783 2478 DAT_voltage_level_LOW_MAX < 0.5985 V 0.08 Passed
17784 2478 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17785 2478 DAT_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17786 2478 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17787 2478 DAT_voltage_level_MAX_min LOG V 3.08 Passed
17788 2478 DAT_voltage_level_MAX_mean LOG V 3.1 Passed
17789 2478 DAT_voltage_level_MAX_max LOG V 3.12 Passed
17790 2478 DAT_voltage_level_MIN_min LOG V -0.24 Passed
17791 2478 DAT_voltage_level_MIN_mean LOG V -0.18 Passed
17792 2478 DAT_voltage_level_MIN_max LOG V -0.16 Passed
17793 2479 DAT_NOverShoot_MIN < 10 % 7.1429 Passed
17794 2479 DAT_NOverShoot_mean < 10 % 9.2133 Passed
17795 2479 DAT_NOverShoot_MAX < 10 % 11.5942 Failed
17796 2479 DAT_fall_time_MIN < 10 ns 4.7429 Passed
17797 2479 DAT_fall_time_mean < 10 ns 5.7795 Passed
17798 2479 DAT_fall_time_MAX < 10 ns 6.1417 Passed
17799 2479 DAT_POverShoot_MIN < 10 % 11.4286 Failed
17800 2479 DAT_POverShoot_mean < 10 % 12.4586 Failed
17801 2479 DAT_POverShoot_MAX < 10 % 13.7681 Failed
17802 2479 DAT_rise_time_MIN < 10 ns 6.2829 Passed
17803 2479 DAT_rise_time_mean < 10 ns 6.5105 Passed
17804 2479 DAT_rise_time_MAX < 10 ns 6.7943 Passed
17805 2479 DAT_voltage_level_LOW_MIN < 0.5985 V 0.04 Passed
17806 2479 DAT_voltage_level_LOW_mean < 0.5985 V 0.065 Passed
17807 2479 DAT_voltage_level_LOW_MAX < 0.5985 V 0.08 Passed
17808 2479 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17809 2479 DAT_voltage_level_HIGH_mean > 1.2285 V 2.835 Passed
17810 2479 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17811 2479 DAT_voltage_level_MAX_min LOG V 3.16 Passed
17812 2479 DAT_voltage_level_MAX_mean LOG V 3.18 Passed
17813 2479 DAT_voltage_level_MAX_max LOG V 3.2 Passed
17814 2479 DAT_voltage_level_MIN_min LOG V -0.24 Passed
17815 2479 DAT_voltage_level_MIN_mean LOG V -0.19 Passed
17816 2479 DAT_voltage_level_MIN_max LOG V -0.16 Passed
17817 2480 DAT_NOverShoot_MIN < 10 % 9.2857 Passed
17818 2480 DAT_NOverShoot_mean < 10 % 10.0776 Failed
17819 2480 DAT_NOverShoot_MAX < 10 % 11.5942 Failed
17820 2480 DAT_fall_time_MIN < 10 ns 3.9067 Passed
17821 2480 DAT_fall_time_mean < 10 ns 4.4277 Passed
17822 2480 DAT_fall_time_MAX < 10 ns 5.2333 Passed
17823 2480 DAT_POverShoot_MIN < 10 % 10.1449 Failed
17824 2480 DAT_POverShoot_mean < 10 % 10.7919 Failed
17825 2480 DAT_POverShoot_MAX < 10 % 11.5942 Failed
17826 2480 DAT_rise_time_MIN < 10 ns 5.2018 Passed
17827 2480 DAT_rise_time_mean < 10 ns 5.5124 Passed
17828 2480 DAT_rise_time_MAX < 10 ns 5.7048 Passed
17829 2480 DAT_voltage_level_LOW_MIN < 0.5985 V 0.02 Passed
17830 2480 DAT_voltage_level_LOW_mean < 0.5985 V 0.05 Passed
17831 2480 DAT_voltage_level_LOW_MAX < 0.5985 V 0.08 Passed
17832 2480 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17833 2480 DAT_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17834 2480 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17835 2480 DAT_voltage_level_MAX_min LOG V 3.12 Passed
17836 2480 DAT_voltage_level_MAX_mean LOG V 3.13 Passed
17837 2480 DAT_voltage_level_MAX_max LOG V 3.16 Passed
17838 2480 DAT_voltage_level_MIN_min LOG V -0.24 Passed
17839 2480 DAT_voltage_level_MIN_mean LOG V -0.23 Passed
17840 2480 DAT_voltage_level_MIN_max LOG V -0.2 Passed
17841 2481 DAT_NOverShoot_MIN < 10 % 7.6923 Passed
17842 2481 DAT_NOverShoot_mean < 10 % 8.6538 Passed
17843 2481 DAT_NOverShoot_MAX < 10 % 10.7692 Failed
17844 2481 DAT_fall_time_MIN < 10 ns 3.4625 Passed
17845 2481 DAT_fall_time_mean < 10 ns 3.5369 Passed
17846 2481 DAT_fall_time_MAX < 10 ns 3.68 Passed
17847 2481 DAT_POverShoot_MIN < 10 % 13.8462 Failed
17848 2481 DAT_POverShoot_mean < 10 % 14.0385 Failed
17849 2481 DAT_POverShoot_MAX < 10 % 14.6154 Failed
17850 2481 DAT_rise_time_MIN < 10 ns 3.625 Passed
17851 2481 DAT_rise_time_mean < 10 ns 3.7557 Passed
17852 2481 DAT_rise_time_MAX < 10 ns 4.0167 Passed
17853 2481 DAT_voltage_level_LOW_MIN < 0.5985 V -0.06 Passed
17854 2481 DAT_voltage_level_LOW_mean < 0.5985 V -0.045 Passed
17855 2481 DAT_voltage_level_LOW_MAX < 0.5985 V -0.04 Passed
17856 2481 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.54 Passed
17857 2481 DAT_voltage_level_HIGH_mean > 1.2285 V 2.555 Passed
17858 2481 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.56 Passed
17859 2481 DAT_voltage_level_MAX_min LOG V 2.92 Passed
17860 2481 DAT_voltage_level_MAX_mean LOG V 2.92 Passed
17861 2481 DAT_voltage_level_MAX_max LOG V 2.92 Passed
17862 2481 DAT_voltage_level_MIN_min LOG V -0.32 Passed
17863 2481 DAT_voltage_level_MIN_mean LOG V -0.27 Passed
17864 2481 DAT_voltage_level_MIN_max LOG V -0.24 Passed
17865 2482 DAT_NOverShoot_MIN < 10 % 7.1429 Passed
17866 2482 DAT_NOverShoot_mean < 10 % 7.8571 Passed
17867 2482 DAT_NOverShoot_MAX < 10 % 8.5714 Passed
17868 2482 DAT_fall_time_MIN < 10 ns 4.12 Passed
17869 2482 DAT_fall_time_mean < 10 ns 4.1992 Passed
17870 2482 DAT_fall_time_MAX < 10 ns 4.31 Passed
17871 2482 DAT_POverShoot_MIN < 10 % 7.1429 Passed
17872 2482 DAT_POverShoot_mean < 10 % 8.5714 Passed
17873 2482 DAT_POverShoot_MAX < 10 % 9.2857 Passed
17874 2482 DAT_rise_time_MIN < 10 ns 5.1 Passed
17875 2482 DAT_rise_time_mean < 10 ns 5.1725 Passed
17876 2482 DAT_rise_time_MAX < 10 ns 5.2667 Passed
17877 2482 DAT_voltage_level_LOW_MIN < 0.5985 V -0.06 Passed
17878 2482 DAT_voltage_level_LOW_mean < 0.5985 V -0.05 Passed
17879 2482 DAT_voltage_level_LOW_MAX < 0.5985 V -0.04 Passed
17880 2482 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.74 Passed
17881 2482 DAT_voltage_level_HIGH_mean > 1.2285 V 2.75 Passed
17882 2482 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.76 Passed
17883 2482 DAT_voltage_level_MAX_min LOG V 2.96 Passed
17884 2482 DAT_voltage_level_MAX_mean LOG V 2.99 Passed
17885 2482 DAT_voltage_level_MAX_max LOG V 3 Passed
17886 2482 DAT_voltage_level_MIN_min LOG V -0.28 Passed
17887 2482 DAT_voltage_level_MIN_mean LOG V -0.27 Passed
17888 2482 DAT_voltage_level_MIN_max LOG V -0.24 Passed
17889 2486 tWH > 0.005 us 2.498 Passed
17890 2486 tWL > 0.0065 us 2.512 Passed
17891 2486 CMDtOSUod > 0.005 us 2.5 Passed
17892 2486 CMDtOHod > 0.005 us 2.51 Passed
17893 2488 tWH > 0.0065 us 2.5 Passed
17894 2488 tWL > 0.0065 us 2.51 Passed
17895 2488 CMDtISUod > 0.005 us 1.932 Passed
17896 2488 CMDtIHod > 0.005 us 2.516 Passed
17897 2490 tWH > 6.5 ns 31.125 Passed
17898 2490 tWL > 6.5 ns 31.375 Passed
17899 2490 CMDtOH > 5 ns 31.125 Passed
17900 2490 CMDtOSU > 5 ns 31.5 Passed
17901 2492 tWH > 6.5 ns 31.375 Passed
17902 2492 tWL > 6.5 ns 31.125 Passed
17903 2492 CMDtIH > 5 ns 38.625 Passed
17904 2492 CMDtISU > 5 ns 23.75 Passed
17905 2494 tWH > 6.5 ns 10.625 Passed
17906 2494 tWL > 6.5 ns 10.375 Passed
17907 2494 DatatOH > 5 ns 9.875 Passed
17908 2494 DatatOSU > 5 ns 10.25 Passed
17909 2496 tWH > 6.5 ns 31.25 Passed
17910 2496 tWL > 6.5 ns 31.125 Passed
17911 2496 DatatIH > 5 ns 38.5 Passed
17912 2496 DatatISU > 5 ns 22.25 Passed
17913 2497 MMC_CLK_NOverShoot_MIN < 10 % 5.7971 Passed
17914 2497 MMC_CLK_NOverShoot_mean < 10 % 6.1594 Passed
17915 2497 MMC_CLK_NOverShoot_MAX < 10 % 6.5217 Passed
17916 2497 MMC_CLK_fall_time_MIN < 10 ns 4.56 Passed
17917 2497 MMC_CLK_fall_time_mean < 10 ns 5.1998 Passed
17918 2497 MMC_CLK_fall_time_MAX < 10 ns 6.0993 Passed
17919 2497 MMC_CLK_POverShoot_MIN < 10 % 5.7971 Passed
17920 2497 MMC_CLK_POverShoot_mean < 10 % 6.1594 Passed
17921 2497 MMC_CLK_POverShoot_MAX < 10 % 6.5217 Passed
17922 2497 MMC_CLK_rise_time_MIN < 10 ns 5.2044 Passed
17923 2497 MMC_CLK_rise_time_mean < 10 ns 6.0385 Passed
17924 2497 MMC_CLK_rise_time_MAX < 10 ns 7.1067 Passed
17925 2497 MMC_CLK_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17926 2497 MMC_CLK_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17927 2497 MMC_CLK_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17928 2497 MMC_CLK_voltage_level_HIGH_MIN > 1.2285 V 2.74 Passed
17929 2497 MMC_CLK_voltage_level_HIGH_mean > 1.2285 V 2.75 Passed
17930 2497 MMC_CLK_voltage_level_HIGH_MAX > 1.2285 V 2.76 Passed
17931 2497 MMC_CLK_voltage_level_MAX_min LOG V 2.92 Passed
17932 2497 MMC_CLK_voltage_level_MAX_mean LOG V 2.92 Passed
17933 2497 MMC_CLK_voltage_level_MAX_max LOG V 2.92 Passed
17934 2497 MMC_CLK_voltage_level_MIN_min LOG V -0.2 Passed
17935 2497 MMC_CLK_voltage_level_MIN_mean LOG V -0.18 Passed
17936 2497 MMC_CLK_voltage_level_MIN_max LOG V -0.16 Passed
17937 2498 MMC_CLK_Frequency_MIN LOG Hz 15812800 Passed
17938 2498 MMC_CLK_Frequency_mean LOG Hz 15943600 Passed
17939 2498 MMC_CLK_Frequency_MAX LOG Hz 16012800 Passed
17940 2498 MMC_CLK_Period_MIN LOG s 0.00000006245 Passed
17941 2498 MMC_CLK_Period_mean LOG s 0.0000000627225 Passed
17942 2498 MMC_CLK_Period_MAX LOG s 0.00000006324 Passed
17943 2498 MMC_CLK_PDuty_MIN >< 60 40 % 50.5455 Passed
17944 2498 MMC_CLK_PDuty_mean >< 60 40 % 51.0845 Passed
17945 2498 MMC_CLK_PDuty_MAX >< 60 40 % 51.6746 Passed
17946 2499 CMD_Out_NOverShoot_MIN < 10 % 6.338 Passed
17947 2499 CMD_Out_NOverShoot_mean < 10 % 7.3944 Passed
17948 2499 CMD_Out_NOverShoot_MAX < 10 % 8.4507 Passed
17949 2499 CMD_Out_fall_time_MIN < 10 ns 3.4224 Passed
17950 2499 CMD_Out_fall_time_mean < 10 ns 4.0354 Passed
17951 2499 CMD_Out_fall_time_MAX < 10 ns 5.316 Passed
17952 2499 CMD_Out_POverShoot_MIN < 10 % 7.0423 Passed
17953 2499 CMD_Out_POverShoot_mean < 10 % 8.0986 Passed
17954 2499 CMD_Out_POverShoot_MAX < 10 % 9.1549 Passed
17955 2499 CMD_Out_rise_time_MIN < 10 ns 4.1675 Passed
17956 2499 CMD_Out_rise_time_mean < 10 ns 5.0969 Passed
17957 2499 CMD_Out_rise_time_MAX < 10 ns 5.58 Passed
17958 2499 CMD_Out_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17959 2499 CMD_Out_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17960 2499 CMD_Out_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17961 2499 CMD_Out_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17962 2499 CMD_Out_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17963 2499 CMD_Out_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17964 2499 CMD_Out_voltage_level_MAX_min LOG V 3.04 Passed
17965 2499 CMD_Out_voltage_level_MAX_mean LOG V 3.06 Passed
17966 2499 CMD_Out_voltage_level_MAX_max LOG V 3.08 Passed
17967 2499 CMD_Out_voltage_level_MIN_min LOG V -0.24 Passed
17968 2499 CMD_Out_voltage_level_MIN_mean LOG V -0.22 Passed
17969 2499 CMD_Out_voltage_level_MIN_max LOG V -0.2 Passed
17970 2500 CMD_In_NOverShoot_MIN < 10 % 6.338 Passed
17971 2500 CMD_In_NOverShoot_mean < 10 % 7.7465 Passed
17972 2500 CMD_In_NOverShoot_MAX < 10 % 8.4507 Passed
17973 2500 CMD_In_fall_time_MIN < 10 ns 4.0125 Passed
17974 2500 CMD_In_fall_time_mean < 10 ns 4.0771 Passed
17975 2500 CMD_In_fall_time_MAX < 10 ns 4.1733 Passed
17976 2500 CMD_In_POverShoot_MIN < 10 % 11.9718 Failed
17977 2500 CMD_In_POverShoot_mean < 10 % 13.3803 Failed
17978 2500 CMD_In_POverShoot_MAX < 10 % 14.0845 Failed
17979 2500 CMD_In_rise_time_MIN < 10 ns 1.2674 Passed
17980 2500 CMD_In_rise_time_mean < 10 ns 1.2874 Passed
17981 2500 CMD_In_rise_time_MAX < 10 ns 1.3314 Passed
17982 2500 CMD_In_voltage_level_LOW_MIN < 0.5985 V -0.02 Passed
17983 2500 CMD_In_voltage_level_LOW_mean < 0.5985 V -0.01 Passed
17984 2500 CMD_In_voltage_level_LOW_MAX < 0.5985 V 0 Passed
17985 2500 CMD_In_voltage_level_HIGH_MIN > 1.2285 V 2.82 Passed
17986 2500 CMD_In_voltage_level_HIGH_mean > 1.2285 V 2.83 Passed
17987 2500 CMD_In_voltage_level_HIGH_MAX > 1.2285 V 2.84 Passed
17988 2500 CMD_In_voltage_level_MAX_min LOG V 3.16 Passed
17989 2500 CMD_In_voltage_level_MAX_mean LOG V 3.21 Passed
17990 2500 CMD_In_voltage_level_MAX_max LOG V 3.24 Passed
17991 2500 CMD_In_voltage_level_MIN_min LOG V -0.24 Passed
17992 2500 CMD_In_voltage_level_MIN_mean LOG V -0.23 Passed
17993 2500 CMD_In_voltage_level_MIN_max LOG V -0.2 Passed
18163 2508 DAT_NOverShoot_mean < 10 % 9.2857 Passed
18164 2508 DAT_NOverShoot_MAX < 10 % 11.4286 Failed
18165 2508 DAT_fall_time_MIN < 10 ns 3.9333 Passed
18166 2508 DAT_fall_time_mean < 10 ns 4.0907 Passed
18167 2508 DAT_fall_time_MAX < 10 ns 4.1829 Passed
18168 2508 DAT_POverShoot_MIN < 10 % 7.1429 Passed
18169 2508 DAT_POverShoot_mean < 10 % 7.8571 Passed
18170 2508 DAT_POverShoot_MAX < 10 % 10 Failed
18171 2508 DAT_rise_time_MIN < 10 ns 5.04 Passed
18172 2508 DAT_rise_time_mean < 10 ns 5.1374 Passed
18173 2508 DAT_rise_time_MAX < 10 ns 5.2429 Passed
18174 2508 DAT_voltage_level_LOW_MIN < 0.5985 V -0.04 Passed
18175 2508 DAT_voltage_level_LOW_mean < 0.5985 V -0.04 Passed
18176 2508 DAT_voltage_level_LOW_MAX < 0.5985 V -0.04 Passed
18177 2508 DAT_voltage_level_HIGH_MIN > 1.2285 V 2.76 Passed
18178 2508 DAT_voltage_level_HIGH_mean > 1.2285 V 2.76 Passed
18179 2508 DAT_voltage_level_HIGH_MAX > 1.2285 V 2.76 Passed
18180 2508 DAT_voltage_level_MAX_min LOG V 2.96 Passed
18181 2508 DAT_voltage_level_MAX_mean LOG V 2.98 Passed
18182 2508 DAT_voltage_level_MAX_max LOG V 3.04 Passed
18183 2508 DAT_voltage_level_MIN_min LOG V -0.36 Passed
18184 2508 DAT_voltage_level_MIN_mean LOG V -0.3 Passed
18185 2508 DAT_voltage_level_MIN_max LOG V -0.28 Passed
18206 2522 tWH > 6.5 ns 31.25 Passed
18207 2522 tWL > 6.5 ns 31.125 Passed
18208 2522 DatatIH > 5 ns 38 Passed
18209 2522 DatatISU > 5 ns 22.625 Passed
 
Back
Top