You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
第120行 If Len(ActiveSheet.Cells(i, 10)) > 0 And Len(ActiveSheet.Cells(i, 1)) > 0 And ActiveSheet.Cells(i, 11) <> 0 Then
仅每条Message的第一条Signal的Len(ActiveSheet.Cells(i, 1))会返回大于0,后续几条Signal返回均为0,导致后续Signal初始值计算出现问题。
第120行
If Len(ActiveSheet.Cells(i, 10)) > 0 And Len(ActiveSheet.Cells(i, 1)) > 0 And ActiveSheet.Cells(i, 11) <> 0 Then
仅每条Message的第一条Signal的
Len(ActiveSheet.Cells(i, 1))
会返回大于0,后续几条Signal返回均为0,导致后续Signal初始值计算出现问题。信号的初始值存储时为原始值,根据 [Physical value] = ([raw value] * [factor]) + [offset]
转变为 [raw value] = ([Physical value] - [offset]) / [factor]
第121行:
initial_value = (ActiveSheet.Cells(i, 10) + ActiveSheet.Cells(i, 12)) / ActiveSheet.Cells(i, 11)
是否应改为:
initial_value = (ActiveSheet.Cells(i, 10) - ActiveSheet.Cells(i, 12)) / ActiveSheet.Cells(i, 11)
The text was updated successfully, but these errors were encountered: