Hi everyone!
I'm working on a file to be used as database for environmental tests.
I've reached a point where I'm facing quite a challenge.. I think I'd be able to solve it but not without spending many hours of trials/errors. Besides, what I'd come up with would probably be unefficient and heavy.
Please see attached file
So I have 3 worksheets:
#1 is a table where data is entered right away. It's the "every day" part of the file
#2 is a worksheet that'll populate a table in worksheet #3.
#3 is a dabatase that contains data from #2, limits (upper boundaries for results), and what I want to set up.
What's missing here is everything in M19:N36
You can see I have 2 columns: 1 alert and 1 action
I also have 18 rows that roughly correspond to a combination of tests & rooms from the databases in #1 and #3
I'll need to perform the following mathematical operation:
EXP(
LN(AVG[data]) - 0,5*LN(STDEV[data]²/AVG[data]²+1) + 2*SQRT(LN(STDEV[data]²/AVG[data]²+1)
I'm working on a file to be used as database for environmental tests.
I've reached a point where I'm facing quite a challenge.. I think I'd be able to solve it but not without spending many hours of trials/errors. Besides, what I'd come up with would probably be unefficient and heavy.
Please see attached file
So I have 3 worksheets:
#1 is a table where data is entered right away. It's the "every day" part of the file
#2 is a worksheet that'll populate a table in worksheet #3.
#3 is a dabatase that contains data from #2, limits (upper boundaries for results), and what I want to set up.
What's missing here is everything in M19:N36
You can see I have 2 columns: 1 alert and 1 action
I also have 18 rows that roughly correspond to a combination of tests & rooms from the databases in #1 and #3
I'll need to perform the following mathematical operation:
EXP(
LN(AVG[data]) - 0,5*LN(STDEV[data]²/AVG[data]²+1) + 2*SQRT(LN(STDEV[data]²/AVG[data]²+1)