28648_zh-TW

liliconcom

檢測參數中的跳轉並報告其位置

親愛的JMP社區，

我正在努力尋找一種方法來檢測一個代表一種產品破損的點的X坐標。 

我確信可以通過腳本來完成它，但我對JMP的經驗很少。

 

歡迎任何幫助!!

 

最好的祝福，

/ JM

 

 

Re：檢測參數中的跳轉並報告其位置在大多數情況下，JMP列名稱不區分大小寫，因此將其引用為“v”或“V”對代碼的執行沒有影響。Re：檢測參數中的跳轉並報告其位置非常感謝！它有很大幫助。由於我們展示了在JMP中編寫腳本的方法，因此我輸入代碼並發現存在一些錯誤。我更換了“設置每個值（e-06）”來設置每個值（-6）“-log10 I-並且它完美地工作。另外，我可以問你為什麼在JMP中：dtsumm：v [dtsummRow]沒有產生任何錯誤。我會把dtsumm：V [dtsummRow]，因為列的名稱是大寫的。再一次，你的幫助很多！/ JMRe：檢測參數中的跳轉並報告其位置

這是一個腳本，它將進行計算以確定交叉電壓

Names Default To Here( 1 );
dt = Current Data Table();

// Create a summary table to hold the new information
dtsumm = dt << Summary( Group( :batch, :Samples ID ), Freq( "None" ), Weight( "None" ) );

// Add a new column to hold the calculated value for the Voltage value when the data crosses
// crosses the target value
dtsumm << New Column( "V" );
// Create a new column that has the target value
dtsumm << New Column( "Log10 I", set each value( e-06 ) );

// Set the active data table back to the original data table
Current Data Table( dt );

// Loop across the active data table and calculate the voltage when the Y variable crosses the 
// target value
For Each Row(
 currow = Row();
 curbatch = dt:batch[Row()];
 cursampleID = :Samples ID[Row()];
 
 // Get the row in the output table that matches the Batch value and Samples ID
 // value for the row in the main table the looping is working on
 dtsummRow = (dtsumm << get rows where( dtsumm:batch == curbatch & dtsumm:Samples ID == cursampleID ))[1];
 
 // Don't process the data if the crossing point has been previously found
 If( Is Missing( dtsumm:v[dtsummRow] ),
  // Find all of the matching rows above the current looping row
  Highrows = dt << get rows where( dt:batch == curbatch & dt:Samples ID == cursampleID & Row() > currow );
  // If the target value lies between the current rows Y value and the next matching rows Y value then
  // determine the crossing voltage value by doing an interprelation of the voltage values of the current row
  // and the next matching rows value.
  If( dt:Name( "Log10 I [A]" )[Row()] <= dtsumm:Log10 I[dtsummRow] & dt:Name( "Log10 I [A]" )[Min( Highrows )] > dtsumm:Log10 I[dtsummRow],
   dtsumm:V[dtsummRow] = dt:V[Row()] + (dt:V[Min( Highrows )] - dt:V[Row()]) * (dtsumm:Log10 I[dtsummRow] - dt:Name( "Log10 I [A]" )[Row()])
    / (dt:Name( "Log10 I [A]" )[Min( Highrows )] - dt:Name( "Log10 I [A]" )[Row()])
  );
 );
);