Skip to main content
4-Participant
April 29, 2025
Solved

Solve Block Query

  • April 29, 2025
  • 1 reply
  • 955 views

I am trying to create a solve block to calculate the value of alpha as per the below equations:

StuartF_0-1745911589988.png


I have never used solved blocks before so hitting a bit of a stumbling point. I have found through manual iteration my required value of alpha as below:

StuartF_1-1745911950897.png


I am trying to put this together into a solve block, but not sure where I am going wrong:

 

StuartF_4-1745912118294.png

 

I've attached the sheet pictured above also.

Any help much appreciated, thank you. This will probably be a very simple solve and it is just my lack of understanding of the program hindering me!

Best answer by terryhendicott

Hi Stuart,

No worries.  Version 9 included.

Cheers

Terry

1 reply

21-Topaz II
April 29, 2025

Hi,

You have five equations and you need to solve for 5 variables to solve the five equations.

Cheers

Terry

21-Topaz II
April 29, 2025

Sorry forgot to include the sheet

StuartF4-ParticipantAuthor
4-Participant
April 29, 2025

Hi Terry,

 

Thanks for your reply, unfortunately I can't open as we're still on Prime 9, apologies I should have mentioned.