Skip to main content
4-Participant
Apr 29, 2025 7:36 AM UTC
Solved

Solve Block Query

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!

terryhendicott
21-Topaz II
Apr 29, 2025 9:07 AM UTC

Hi Stuart,

No worries.  Version 9 included.

Cheers

Terry

5 replies

terryhendicott
21-Topaz II
Apr 29, 2025 8:15 AM UTC

Hi,

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

Cheers

Terry

Translate
terryhendicott
21-Topaz II
Apr 29, 2025 8:16 AM UTC

Sorry forgot to include the sheet

Translate
StuartF4-ParticipantAuthor
4-Participant
Apr 29, 2025 9:02 AM UTC

Hi Terry,

 

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

Translate