How to Process Data by referencing a Function

**StoffStoff** · 01-11-2015, 07:02 PM

Hello Everyone,

I want to process 3 variables to give me 1 output. These 3 variables will be processed several times to generate that particular output. The problem is similar to this example:

functiontestpic.jpg

Input data x, y , z gets processed by Process 1 and 2 to generate output F. How could I process the x,y,z data without having to reenter each x,y,z data set to calculate F ?

This is just an example , the actual problem has over 8000 data sets and about 12 elaborate processes and I just dont have the time to enter so many data points. What would be the quickest and most efficient of processing the data without rearranging the actual process setup?

I have attached the excel file to the thread. Any help would be appreciated.

**pjwhitfield** · 01-12-2015, 10:25 AM

Im sorry but what exactly is the calculation?

You seem to take 3 numbers in, get an answer of 2 (which is the sum of the 3 numbers in your example), add 1 to that? and then possibly double it? but without knowing for definite then its impossible to say.

Im assuming it cant be that easy though, as to do that you'd simply need a formula of:

=((G3+H3+I3)+1)*2

EDIT: Apologies, I missed the fact you said that there were a number of different calculations, Id imagine therefore that you'd need to create a VBA function which contains a series of IFs or CASE to determine which calc to run.

**StoffStoff** · 01-12-2015, 11:17 AM

I attached the actual file in question. Gh (D67 -> B15 ), Temp (E67-> B17) , Ambient Pressure (F67-> B16) are the inputs and Electric Power (B59-> G67) is the output. The electric Power Output has to be calculated for each of the 8760 (hourly) data sets. The processes are all listed. As you can see , the process is rather involved and the Electric Power is calculated through a goal seek routine. Any further assistance would be greatly appreciated. Thanks again !