hexagon logo
Register Sign in
  • Replies 1 reply
  • Subscribers 221 subscribers
  • Views 87 views
  • Users 0 members are here
Options
Related

alguien del foro sabe cual es la formula para calcular el t value

Juan De Dios Velazquez
Buenos dia a todos , alguien tiene un excel o la formula para calcular la t value (la resultante) como todos la conocemos
Parents
  • PC-DMIS :
    ASSIGN/T_VAL=DOT(PT1.XYZ-PT1.TXYZ,PT1.TIJK)
    or
    ASSIGN/T_VAL=DOT(SCN1.HIT[1..SCN1.NUMHITS].XYZ-SCN1.HIT[1..SCN1.NUMHITS].TXYZ,SCN1.HIT[1..SCN1.NUMHITS].TIJK)

    In excel :
    type this formula in a vba script, then look in P5 to get the right translation
    in D5:F5, measured coordinates XYZ
    in H5:J5, theo coordinates TXYZ
    in L5:N5 : theo TIJK

    Sub T_VAL()
    Range("P5").Select
    ActiveCell.Formula = _
    "=SUMPRODUCT(D5:F5-H5:J5,L5:N5)"
    End Sub​
Reply
  • PC-DMIS :
    ASSIGN/T_VAL=DOT(PT1.XYZ-PT1.TXYZ,PT1.TIJK)
    or
    ASSIGN/T_VAL=DOT(SCN1.HIT[1..SCN1.NUMHITS].XYZ-SCN1.HIT[1..SCN1.NUMHITS].TXYZ,SCN1.HIT[1..SCN1.NUMHITS].TIJK)

    In excel :
    type this formula in a vba script, then look in P5 to get the right translation
    in D5:F5, measured coordinates XYZ
    in H5:J5, theo coordinates TXYZ
    in L5:N5 : theo TIJK

    Sub T_VAL()
    Range("P5").Select
    ActiveCell.Formula = _
    "=SUMPRODUCT(D5:F5-H5:J5,L5:N5)"
    End Sub​
Children
No Data
© 2024 Hexagon AB and/or its subsidiaries. Privacy Policy | Cloud Services Agreement