Gradually inputting values

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, than do it again and again until all the values of power are calculated for each velocity, so then I can make a graph Vlocity x power.

I am using GH plugin ExcelGH but I have no idea how to make this gradual input and read of values. Do you have any ideas?

In the figure cell D3 is the velocity input cell, and D39 is the power output cell that I need to read from..

Thank you

Attachments:

2016-11-25_13-05-27.jpg, 129 KB

Replies to This Discussion

Permalink Reply by LEONARDO DE ALMEIDA on November 25, 2016 at 9:11am

Permalink Reply by martyn hogg on November 25, 2016 at 2:35pm

Can you not just put the power calculation in a function component in GH?

Or can you edit the Excel Spreadsheet so you have a column of velocities and copy and paste the formula into the cells next to these so you get a list of valuse in Excel?

Permalink Reply by LEONARDO DE ALMEIDA on November 27, 2016 at 2:15pm

I'll try to edit the spreadsheet, I think it is the easiest way. The power calculation isn't performed by just one formula, it is a set of formulas so i cannot do that actually

Permalink Reply by martyn hogg on November 27, 2016 at 3:54pm

Worth looking at using the function component in GH too... if you can create the function in Excel, you can probably do it in GH!

Permalink Reply by LEONARDO DE ALMEIDA on November 27, 2016 at 2:15pm

Thank you =D

RSS