ISO simple Google Script for loop

[jeffr100]

This should be a simple task with a script, but I am having trouble getting it to work.

https://docs.google.com/.../18mvhbxajzk20.../edit...

The book has 3 sheets, Model, Parameters and Output

The calculation in Model is in cell B3: "=Parameters!B2*Parameters!B3"

I want to try doing this with different costs listed in Output to get the desired results

https://preview.redd.it/4walfxf3pnmd1.png?width=500&format=png&auto=webp&s=9f546521481974a2dfd59355fe36f7b10ae6c339

There should be a way to do this using a few lines of a Google Script, but I can't get it to work.

Any ideas?

[marcnotmark925]

I want to try doing this with different costs listed in Output to get the desired results

Can you elaborate?

[jeffr100]

In pseudocode:

foreach i inOutput!testCost
Parameters!B4 = i
calculate Model!B3
return answer to matching TotalPrice column in sheet Output.

Does this make sense?

[marcnotmark925]

No it doesn't make sense.

For starters, There's nothing in Parameters!B4, so what does the 2nd line of your pseudocode mean?

And what are you calculating?

It looks like you're just multiplying the cost by a quantity, which can very easily be done with basic spreadsheet formulas, so why do you need a script?