View Single Post
 
Old 12-09-2016, 07:36 AM
MorneDJ MorneDJ is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Dec 2016
Posts: 2
MorneDJ is on a distinguished road
Default

Those are just numbers I typed but the calculation is something along the line of ...

Imagine Column A is a filled with the measurement number (e.g. 1, 2, 3, 4, 5, 6, 7 etc.), with column B containing the numbers used to calculate the equivalent number, the calculation is something like for the first 3 values:

Code:
A      B       C
1		
2	84.9	
3	57	
4	30	80.1
Code:
x = (10 * log((1/(A4 - A1)) * (10^(B2/10)+10^(C2/10)+10^(D2/10))))

X = 80.1
For 6 rows it will be:


Code:
x = (10 * log((1/(A7 - A1)) * (10^(B2/10)+10^(C2/10)+10^(D2/10)+10^(DE/10)+10^(F2/10)+10^(G2/10))))
Reply With Quote