Routine in order to obtain angles

**João Cunha** · 08-29-2019, 12:46 PM

Hello,
I need somebodies help please.
I want a routine that increments 0.05 degrees, each time, starting on 0.05, with a maximum value of 2PI , until we reach the closest value to Q2, wich is a variable that we already know its value.
After reaching this value, I need the routine to give me the required value.
The attached file is an arcaic manner of calculating the q(angle), the Q2 in highlighted in blue, the closest value is in green and the required value is in yellow.
With this value I will be able to calculate the velocity of the flow rate of liquids.
Thank you

**Rick Rothstein** · 08-29-2019, 01:17 PM

This formula will take the value from cell K2 and directly return the 1.85 that you want...

=INDEX(D:D,MATCH(VLOOKUP(K2,H3:H129,1),H:H,0)+1,1)

**MrShorty** · 08-30-2019, 11:50 AM

As noted in your newer thread, this looks like a root finding problem. One way to get roots in Excel is to use the built in Solver/Goal seek utilities https://support.office.com/en-us/art...B-F63E45925040 Here's how I might solve this using Solver in the example sheet in post #1:

1) Columns D:I provide the calculation for Q (column H) from theta (column D). I would first make a copy of the bottom row and paste that in a few rows down. Select D129:I129 -> Copy -> Select D133 -> Paste
2) Call Solver and tell it to:
2a) Set target cell: H133
2b) to a value of 210
2c) by changing: D133
3) Solve

Excel comes back with a message that it could not find a solution, because the initial guess of 2PI was a very poor choice for the initial guess. Enter a better guess (1.5) into D133 and execute Solver again, and it quickly converges on the solution.

**João Cunha** · 08-30-2019, 11:56 AM

Thank you Rick Rothstein but I'm looking for a (vba) routine that is capable of finding THETA using Q, I don't want to search the value in an excel's table.

**João Cunha** · 08-30-2019, 11:59 AM

Thank you Mrshorty

Routine in order to obtain angles

LinkBack

Thread Tools

Rate This Thread

Display

Routine in order to obtain angles

Re: Routine in order to obtain angles

Re: Routine in order to obtain angles

Re: Routine in order to obtain angles

Re: Routine in order to obtain angles

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel 2016 Sort routine issue - recording macro has sheet name in sort routine

[SOLVED] naming a routine and calling it in another routine - not a loop

[SOLVED] Order Form to Summarise Order on another sheet with a Submit Order Button

Pass a variable from one sub-routine to another sub-routine

obtain chronological order without sorting

Using angles?

Angles

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions