Line profile calculation in excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Line profile calculation in excel

    Attached. Please review for accuracy, thanks.
    Last edited by gdntnovice; 04-26-2020, 12:08 AM.

  • #2
    Usually, the theo is the reference, so you calculate actual - theo.
    Sumproduct is the dot product of excel, so you should have 2 vectors.
    I prfer working in columns (ABC xwith theo DEF with actual, GHI with IJK
    If you want to calculate the length of the deviation (actual-theo), the formula should be SQR(SUMPRODUCT(D1:F1- A1:C1;D1:F1- A1:C1))
    This for a best fit "alone"
    For a best fit vector, it becomes SUMPRODUCT(D1:F1- A1:C1;G1:I1)
    Last edited by JEFMAN; 04-22-2020, 06:28 AM.

    Comment

    Related Topics

    Collapse

    Working...
    X