35c76c86-8112-4d46-8c43-eecad5481f9a 21 Ian HOOTON 4 5 decimal
&[DATE] &[TIME] - &[FILENAME]
&[PAGENUM] / &[COUNT]

Centre Frequency Bands

f 31.5 63 125 250 500 1000 2000 4000 8000 1 9 mat :

can these 3 data sets be combined into one matrix, and then the subsequent calculations and table produced ?

Given Sound Powel Level dB Forward @ 31.5 Hz to 8kHz

L.wf 101.5 105.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 1 9 mat :

Given Sound Powel Level dB Rearward @ 31.5 Hz to 8kHz

L.wr 90 90 93 100 100 100 95 90 102 1 9 mat :

Example data set for ease of entry

data OBCF Hz 31.5 63 125 250 500 1000 2000 4000 8000 Lw Forward dB 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 Lw Rear dB 90 90 93 100 100 100 95 90 102 3 10 mat :

'A' Weighting value in dB @ 31.5 Hz to 8kHz

A.wt 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - 1 9 mat : 31.5 63 125 250 500 1000 2000 4000 8000 101.5 105.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 90 90 93 100 100 100 95 90 102 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - 4 9 mat

Extract the numeric data via submatrix You need A.wt from the string matrix a damned freak to extract

data data 2 3 range 2 10 range el : 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 90 90 93 100 100 100 95 90 102 2 9 mat 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 1 9 mat 90 90 93 100 100 100 95 90 102 1 9 mat 2 1 sys

Combinred Sound Power level @ 125 Hz to 8kHz

L.w 10 10 L.wf 10 / ^ 10 L.wr 10 / ^ + log10 * vectorize : 101.8 101.8 113.5 115.6 111.8 110.9 108.7 113.5 109.4 1 9 mat

Total Forward sound Power Level dB(A)

L.wfT 10 10 L.wf A.wt + ( j el 10 / ^ j 1 L.wf cols sum log10 * : # 109.6675 62.1 75.3 97.4 106.9 108.3 110.5 109.7 114.5 107.4 1 9 mat

Total Rear sound Power Level dB(A)

L.wrT 10 10 L.wr A.wt + ( j el 10 / ^ j 1 L.wr cols sum log10 * : # 99.1222 50.6 63.8 76.9 91.4 96.8 100 96.2 91 100.9 1 9 mat 85.2889

Total Combinred Sound Power level dB(A)

L.wT 10 10 L.w A.wt + ( j el 10 / ^ j 1 L.w cols sum log10 * : # 62.3971 75.5971 97.4385 107.0207 108.5971 110.8708 1 6 mat 99.4009

Left stub of table

LS Frequency Lw dB Forward Lw dB Rearward Lw dB Combined 4 1 mat :

Table

A f L.wf L.wr L.w 4 1 mat :

Right stub of table

RS Total L.wfT dB(A) L.wrT dB(A) L.wT dB(A) 4 2 mat : RS A LS L.wT L.wrT L.wfT L.w A.wt L.wr L.wf f lastError A LS lastError A
#
#
#
Frequency
Lw dB Forward
Lw dB Rearward
Lw dB Combined
Total
mat((7.41054395722504·10^15)/119332430873189,(1.24812779573393·10^16)/165754023337839,(3.92284598713962·10^15)/40275626151331,(2.08199484864076·10^16)/194760977421961,454359407519700/4195377724097,(1.07605440025633·10^17)/973804887109805,(1.85785036723383·10^15)/16935737167127,(6.7962306788006·10^15)/59355726452407,(2.78897719668248·10^16)/259681303229281,1,9) dB(A)
mat((9.85490545755124·10^15)/194760977421961,(1.07066039518955·10^16)/167815108963879,(7.48855958187435·10^16)/973804887109805,(1.78011533363672·10^16)/194760977421961,(1.50822900915566·10^16)/155808781937569,(5.87747175411145·10^16)/587747175411145,(7.49440241119705·10^16)/779043909687845,(1.77232489453984·10^16)/194760977421961,(7.86055304875031·10^16)/779043909687841,1,9) dB(A)
mat((4.86100508502176·10^16)/779043909687841,(7.36167880726215·10^16)/973804887109805,(1.08441281876962·10^16)/111291987098263,(2.084345763458·10^16)/194760977421961,(2.11504698694492·10^16)/194760977421961,680440379659812/6137238270679,(1.3830874608646·10^15)/12586133172291,(7.43463390431885·10^16)/649203258073205,(2.10882045430456·10^16)/194760977421961,1,9) dB(A)
#
A

Example data set for ease of entry

data OBCF Hz 31.5 63 125 250 500 1000 2000 4000 8000 Lw Forward dB 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 Lw Rear dB 90 90 93 100 100 100 95 90 102 3 10 mat : AWt 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - 1 10 mat OBCF Hz 31.5 63 125 250 500 1000 2000 4000 8000 AWt 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - Lw Forward dB 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 Lw Rear dB 90 90 93 100 100 100 95 90 102 4 10 mat 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - 1 9 mat 101.5 101.5 113.5 115.5 111.5 110.5 108.5 113.5 108.5 1 9 mat 90 90 93 100 100 100 95 90 102 1 9 mat 3 1 sys 39.4 - 26.2 - 16.1 - 8.6 - 3.2 - 0 1.2 1 1.1 - 1 9 mat

Combinred Sound Power level @ 125 Hz to 8kHz

L.w 10 10 L.wf 10 / ^ 10 L.wr 10 / ^ + log10 * vectorize : 101.8 101.8 113.5 115.6 111.8 110.9 108.7 113.5 109.4 1 9 mat 109.6675 62.1 75.3 97.4 106.9 108.3 110.5 109.7 114.5 107.4 1 9 mat 99.1222 50.6 63.8 76.9 91.4 96.8 100 96.2 91 100.9 1 9 mat 85.2889 62.3971 75.5971 97.4385 107.0207 108.5971 110.8708 1 6 mat 99.4009