Ask Your Question
0

Multiple Operations populates entire table with one value

asked 2017-01-31 03:31:02 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I created a simulation that's a function of two variables, X and Y. I want to use Multiple Operations to display the output as a function of predetermined combinations of X and Y, but it populates the entire table with the value of the first combination only. In other words, I want the output from [X(1), Y(1)], [X(1), Y(2)], [X(1), Y(3)]...[X(2), Y(1)], [X(2), Y(2)], [X(2), Y(3)]...[X(N), Y(N)], but Multiple Operations populates the entire data table with the output of [X(1), Y(1)]. Any idea what's going on?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-01-31 13:33:35 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Thanks, Ratslinger. I can get Multiple Operations to work with a relatively simple formula, but my simulation is about 130 columns wide by 800 rows deep, which I think overwhelms it. I'm trying to pare it back, but there isn't a lot of fat. I may end up writing a macro to populate the table.

edit flag offensive delete link more
0

answered 2017-01-31 06:24:01 +0100

Ratslinger gravatar image

Using the sample in the help file where B5 formula is =B4*(B1-B2)-B3 the following works:

image description

edit flag offensive delete link more

Comments

Note; Actual selection area to start was D1 through H11 and not the displayed D1 through D11.

Ratslinger gravatar imageRatslinger ( 2017-01-31 06:31:42 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-01-31 03:31:02 +0100

Seen: 47 times

Last updated: Jan 31 '17