cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Translate the entire conversation x

Solve Block Query

StuartF
4-Participant

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!

ACCEPTED SOLUTION

Accepted Solutions

Hi Stuart,

No worries.  Version 9 included.

Cheers

Terry

View solution in original post

5 REPLIES 5

Hi,

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

Cheers

Terry

Sorry forgot to include the sheet

Hi Terry,

 

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

Hi Stuart,

No worries.  Version 9 included.

Cheers

Terry

That's great thanks, I managed to get it set up as per below:

StuartF_0-1745919073759.png

Greatly appreciate the help!

 

Announcements

Top Tags