Sure. It is possible to load a *.yml configuration file in Excel sheet, modify the sections of interest and rewrite it to replace the original respecting its structure and hierarchies.Is it possible to handle yaml in Excel?
It is a versatile and powerful tool, even without resorting to VBA code.
I apologize for my less than optimal English, the excellent Google translator helps me but cannot work miracles, especially if the ideas are not clear.
Turning "Conv" into "FIR" is not essential and is equivocal,
would only serve to clearly distinguish the category of FIR filters that make use of a * .txt file consisting of a simple succession of values (taps?), from the category of IIR filters (Biquad, BiquadGroup and DiffEq) in which a description is mandatory structured.
And inaugurate a new type: "type: IIR" is wrong.
Forget all this.
I believed that if it was possible to write the configuration file "config.yml" as follows:
Code:
---
devices:
samplerate: 44100
chunksize: 1024
capture:
type: Alsa
channels: 2
device: "hw:Loopback,0,0"
format: S16LE
playback:
type: Alsa
channels: 4
device: "hw:Generic_1"
format: S32LE
filters:
lowpass:
type: Biquad
parameters:
type: File
values: lowpass.txt
highpass:
type: Biquad
parameters:
type: File
values: highpass.txt
peak1:
type: Biquad
parameters:
type: File
values: peak1.txt
mixers:
mono:
channels:
in: 2
out: 4
mapping:
- dest: 0
sources:
- channel: 0
gain: -6
inverted: false
- dest: 1
sources:
- channel: 1
gain: -6
inverted: false
- dest: 2
sources:
- channel: 0
gain: -6
inverted: false
- dest: 3
sources:
- channel: 1
gain: -6
inverted: false
pipeline:
- type: Mixer
name: mono
- type: Filter
channel: 0
names:
- lowpass
- peak1
- type: Filter
channel: 1
names:
- lowpass
- peak1
- type: Filter
channel: 2
names:
- highpass
- type: Filter
channel: 3
names:
- highpass
Code:
filters:
lowpass:
type: Biquad
parameters:
type: Lowpass
freq: 1000
q: 1.0
Code:
filters:
highpass:
type: Biquad
parameters:
type: Highpass
freq: 1000
q: 1.0
Code:
filters:
peak1:
type: Biquad
parameters:
type: Highshelf
freq: 1000
slope: 15
gain: -6
However I could not have changed the "gain: -6" because it's in the "mixers" section.
Finally it would be impossible to add (and remove) filters, but only to modify the existing ones.
Much better to read, edit and rewrite the entire *.yml file.
Of course, in Excel the biquad coefficients are generated to obtain the numerical and graphic representation.
And then
No modification is needed...to get a graphic response of each set of filters and the resulting sum of all.
..to import and superimpose reference curves and frequency responses.
And to have conversion factors for the shelf filters to transform the slope in Q and Q into different Q.
I'd better do it and then submit it to you.
I'm sorry for the confusion.