OK, this might be a challenge.
I'm trying to create a visual of the overlapping frequency range of instruments that dynamically changes the overall length based on the MIN / MAX frequency (number) and the overall width of each based on the percentage of the entire frequency spectrum (percentage on the sum of the total)
My goal is to build a tool that allows people to select the instruments being used in their mix, and then calculate the most probable shelf EQ (not HiPass/LowPass) for the upper and lower bounds to avoid frequency masking in their mix. The cool thing is that for the songwriters who know the upper and lower notes used on each instrument, they will be able to over-ride the default upper and lower note boundaries of the instruments, to then calculate the actual upper and lower frequency boundaries for surgical precision. They would then be able to EQ to taste in their mix as anyone else would.
And yes, I was bored today hence the project
Any help or pointers would be hugely appreciated. I'm also open to VBA solutions if needed. In addition, since this is likely going to be a difficult challenge, I am willing to pay the winning solution $50 for their time via PayPal or Venmo, whichever is easiest.
Thanks so much in advance!
I'm trying to create a visual of the overlapping frequency range of instruments that dynamically changes the overall length based on the MIN / MAX frequency (number) and the overall width of each based on the percentage of the entire frequency spectrum (percentage on the sum of the total)
| Helper Cell for Instrument | Helper Cell Lowest Freq | Helper Cell Highest Freq | Total Bandwidth | Middle Fundamental | Minimum Frequency | Maximum Frequency | Percentage of total | Percentage of Sum | |
| Double Bass | 41.20 Hz | 246.94 Hz | 205.74 Hz | 144.07 | 41.20 Hz | 3520.00 Hz | 5.91% | 2.82% | |
| Timpani, 25" | 116.54 Hz | 174.61 Hz | 58.07 Hz | 145.58 | 1.67% | 0.79% | |||
| Violin | 196.00 Hz | 3520.00 Hz | 3324.00 Hz | 1858.00 | 95.55% | 45.49% | |||
| Female Vocal | 246.94 Hz | 1046.50 Hz | 799.56 Hz | 646.72 | 22.98% | 10.94% | |||
| Electric | 82.41 Hz | 1396.91 Hz | 1314.50 Hz | 739.66 | 37.79% | 17.99% | |||
| Trumpet | 185.00 Hz | 1174.66 Hz | 989.66 Hz | 679.83 | 28.45% | 13.54% | |||
| Trombone, Tenor | 82.41 Hz | 698.46 Hz | 616.05 Hz | 390.44 | 17.71% | 8.43% |
My goal is to build a tool that allows people to select the instruments being used in their mix, and then calculate the most probable shelf EQ (not HiPass/LowPass) for the upper and lower bounds to avoid frequency masking in their mix. The cool thing is that for the songwriters who know the upper and lower notes used on each instrument, they will be able to over-ride the default upper and lower note boundaries of the instruments, to then calculate the actual upper and lower frequency boundaries for surgical precision. They would then be able to EQ to taste in their mix as anyone else would.
And yes, I was bored today hence the project
Any help or pointers would be hugely appreciated. I'm also open to VBA solutions if needed. In addition, since this is likely going to be a difficult challenge, I am willing to pay the winning solution $50 for their time via PayPal or Venmo, whichever is easiest.
Thanks so much in advance!
