ACOS, POWER and PI math functions

  • Resolved martin136

    (@martin136)


    4 years, 9 months ago

    Hello,
    your plugin is awesome!
    I’m rebuilding an Excel function but I’m struggling.
    Can you help me fixing it?

    360*(1-(ACOS((POWER(fieldname16/2+fieldname15-(fieldname11-fieldname17))+POWER(fieldname16/2)-POWER(fieldname15))/(2*(fieldname16/2+fieldname15-(fieldname11-fieldname17))*(fieldname16/2)))/PI())))

    • This topic was modified 4 years, 9 months ago by martin136.
    • This topic was modified 4 years, 9 months ago by martin136.
    • This topic was modified 4 years, 9 months ago by martin136.
Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello,

    There are some issues in your equation:

    – First, the number of parenthesis is incorrect, there are more parenthesis form closing “)” than open parenthesis “(”

    – Second, PI is a constant and not a function, it does not require parenthesis.

    – Third, the correct operation is POW and not POWER, furthermore, requires two parameters, the base and exponent.

    I’m sorry, but with the current equation’s structure, I don’t know which are the parameters you want to use in each case.

    More information in the following link:

    https://cff.dwbooster.com/documentation#mathematical-module

    Best regards.

    Thread Starter martin136

    (@martin136)

    Can you manage that for me if I go with Platinum?

    Here is the working Excel source function:
    =360*(1-(ACOS((POWER(B2/2+B3-(B13-B11);2)+POWER(B2/2;2)-POWER(B3;2))/(2*(B2/2+B3-(B13-B11))*(B2/2)))/PI()))

    I can send you the Excel file of course.

    • This reply was modified 4 years, 9 months ago by martin136.
    • This reply was modified 4 years, 9 months ago by martin136.
    Plugin Author codepeople

    (@codepeople)

    Hello @martin136

    The correct structure of the equation would be:

    
360*(1-(ACOS((POW(B2/2+B3-(B13-B11),2)+POW(B2/2,2)-POW(B3,2))/(2*(B2/2+B3-(B13-B11))*(B2/2)))/PI))

    Now you simply should to replace the name of cells: B2, B3, B11, B13 with the correspond fields’ names on your form.

    Best regards.

    Thread Starter martin136

    (@martin136)

    Thank you very much.
    This is my very positive approach to “forms”.
    I had a view on ninja and gravity and fluent and these prominent form builders.
    Your free version absolutely convinced me!

    Plugin Author codepeople

    (@codepeople)

    Thank you very much.

    Thread Starter martin136

    (@martin136)

    awesome!
    it works!

    Thread Starter martin136

    (@martin136)

    Have gone for Platinum just right now.
    You make it great!

    HAve created a question. Need an invoice if possible

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘ACOS, POWER and PI math functions’ is closed to new replies.