Sequential Calculations, Is it possible?

[mariclaydson]

Hello guys, I need some help.
I am performing a resistance calculation of a boat, so I can calculate the power of the engine he is going to need. My problem is that I need to calculate the power of the engine for a range of velocities, so, I am using a excel spreadsheet to perform these power calculations and I need to input one value at a time and read out the power for that specific velocity, than do it again and again until all the values of power are calculated for each velocity, so then I can make a graph Velocity x power.
The spreadsheet must be automated, I am getting the values of velocity from another software and my goal is to show the user this graph I just told you, but for me would be really Easy if I could figure out a macro that does that, input one velocity, than calculate a power, saves the value (or builds an array), than inputs another velocity, calculates another power and saves this other value, and so on.

I have no idea how to make this gradual input and read of values. Do you have any ideas?

I thank you for any help since now!

2016-11-29_22-52-32.jpg

[shg]

Welcome to the board.

Have you tried a data table? If you need help with that, please post a workbook, not a picture, and make sure it is well explained.

[MrShorty]

As shg noted, it is difficult to make suggestions based on a picture.

I know that, when I want to make several copies of a calculation and be able to change one or a few inputs for each copy of the calculation, I try to arrange the calculation so that it occurs in a single row. With the right combination of relative and absolute references, it is easy to copy the calculations down to make as many copies as are needed. Then change the inputs as desired for each copy. Arranged like this, it is also easy to make the chart, because Excel's chart will be looking for data arranged in rows.

As a quick example, I posted this example of a simple Monte Carlo simulation http://www.excelforum.com/tips-and-t...l-problem.html . The thing for you to note is how each row is a complete sequence of calculations, where there are two (random) inputs (column A and B of each row), and the results in columns G and J.

[mariclaydson]

Thanks guys! I will arrange the spreadsheet and post it here ASAP! =D

[mariclaydson]

I don't know why but I could not attach a file here, it is just no going.
here is the google drive link for the sheet
https://drive.google.com/open?id=0B7...zVlT2NOWGRpZEU

Thanks again guys.

[shg]

Velocity	1097.57	D43: =D39
50	#N/A	D44:D50: {=TABLE(,D12)}
55	674.75
60	826.04
65	1000.79
70	1200.95
75	1428.50
80	1685.37

The formula in D43 references the power output in merged cells D39:E39 (the first thing I would do is get rid of all the merged cells). That's the data table's prototype for the results that appear below.

C44:C50 is a list of speeds entered by you.

To create the data table, select C43:D50, Data > What-If Analysis, Data Table, Column input cell: D12, then press OK. That's what makes that formula appear.

Your model doesn't work for speeds < 55.

[mariclaydson]

Could you send me this example in a sheet?

Thanks bro

[mariclaydson]

Nerver Mind I got it! Thanks Bro!

[mariclaydson]

When I select the input Cell as D12 it gives no the powers, but repeats the velocities
2016-11-24_17-26-06.jpg

[mariclaydson]

Made it! I was inserting D12 in the row input cell! haha

[shg]

You're welcome.