Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

信号初始值的计算 #3

Open
QinqiangCN opened this issue May 8, 2020 · 0 comments
Open

信号初始值的计算 #3

QinqiangCN opened this issue May 8, 2020 · 0 comments

Comments

@QinqiangCN
Copy link

  1. 第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初始值计算出现问题。

  2. 信号的初始值存储时为原始值,根据 [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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant