Calculation body fat

  • Resolved dannydegroot

    (@dannydegroot)


    7 years, 1 month ago

    I am trying to calculate the body fat percentage in a form

    I’m not getting the right percentage

    The formula in Excel is:
    495/(1,0324-0,19077*(LOG(C22-C20))+0,15456*(LOG(C18)))-450

    I created in CFF:
    495/(1.0324-0.19077*(LOG(fieldname8-fieldname7))+0.15456*(LOG(fieldname6)))-450

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author codepeople

    (@codepeople)

    7 years, 1 month ago

    Hello @dannydegroot

    In Excel the “LOG(x)” operation returns the logarithm base 10 of x, but in our plugin the LOG(x) operation returns the logarithm base E of x.

    The corresponding operation in our plugin would be LOGAB (logarithm of A base B).

    So, the operation LOB(100) in Excel, should be implemented in our plugin as LOGAB(100,10)

    Best regards.

    Thread Starter dannydegroot

    (@dannydegroot)

    7 years, 1 month ago

    Tnx, but did not work for me

    I tried:
    495/(1.0324-0.19077*(LOGAB(fieldname8-fieldname7),10)+0.15456*(LOGAB(fieldname6,10)))-450

    what am I doing wrong?

    Plugin Author codepeople

    (@codepeople)

    7 years, 1 month ago

    Hello @dannydegroot

    Your equation has a syntax error, the correct would be (at least the structure):

    
495/(1.0324-0.19077*LOGAB(fieldname8-fieldname7,10)+0.15456*LOGAB(fieldname6,10))-450

    Best regards.

    Thread Starter dannydegroot

    (@dannydegroot)

    7 years, 1 month ago

    Great tnx
    It’s working !

    Plugin Author codepeople

    (@codepeople)

    7 years, 1 month ago

    Hello @dannydegroot

    It has been a pleasure.

    Best regards.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Calculation body fat’ is closed to new replies.