Seth wrote: ↑Fri Aug 27, 2021 9:28 pm
By show of hands
, how many of you guys actually have an Excel spreadsheet with audio formulas too?
37602
Tom Smit wrote: ↑Fri Aug 27, 2021 9:51 pmHandsdown.
Grant Bunter wrote: ↑Sat Aug 28, 2021 1:20 am
No Seth,
It's all in my head...
Well Brent, after more than 150 thread "views"... I guess it's just me and you.
The other day I was just jotting some equation notes in mine, then figured I'd go ahead and make quick, simple, working "calculators" to go along with the notes... That was a bit of a mistake; I led myself right down a rabbit hole and the next thing I know I'm creating a multifaceted calculator with dropdown menu's, auto-populating conditional values, along with color changing boxes and warning text when values are out of range.
Here's one of the longer cell formulas. LOL It auto populates one cell (Sensitivity) based on the values of two other cells (Cab and Driver)
=IF(AND(O52="T24",P52="S2010"),91,IF(AND(O52="T24",P52="BP102"),88,IF(AND(O52="T24",P52="KappaPro10LF"),88,IF(AND(O52="T24",P52="KL3010LF"),91,IF(AND(O52="T30",P52="S2010"),91.5,IF(AND(O52="T30",P52="BP102"),90,IF(AND(O52="T30",P52="KappaPro10LF"),90,IF(AND(O52="T30",P52="KL3010LF"),90,IF(AND(O52="T30",P52="S2012"),90,IF(AND(O52="T30",P52="Delta12LFA"),93,IF(AND(O52="T30",P52="3012LF"),93,IF(AND(O52="T30",P52="LAB12"),95.75,IF(AND(O52="T30",P52="12NLW9300"),92,IF(AND(O52="T45",P52="S2010"),91.5,IF(AND(O52="T45",P52="BP102"),90,IF(AND(O52="T45",P52="KappaPro10LF"),93,IF(AND(O52="T45",P52="KL3010LF"),90,IF(AND(O52="T45",P52="S2012"),90,IF(AND(O52="T45",P52="Delta12LFA"),93,IF(AND(O52="T45",P52="3012LF"),93,IF(AND(O52="T45",P52="LAB12"),95.75,IF(AND(O52="T45",P52="12NLW9300"),92,IF(AND(O52="T39",P52="12NLW9300"),101.5,IF(AND(O52="T39",P52="LAB12"),96.75,IF(AND(O52="T39",P52="3012LF"),101,IF(AND(O52="T39",P52="Delta12LFA"),95,IF(AND(O52="T39",P52="S2012"),98,IF(AND(O52="T39",P52="KL3010LF"),95,IF(AND(O52="T39",P52="KappaPro10LF"),95,IF(AND(O52="T39",P52="BP102"),95,IF(AND(O52="T39",P52="S2010"),97.5,IF(AND(O52="T60",P52="LAB15"),93.75,IF(AND(O52="T60",P52="LAB12x2"),92.75,IF(AND(O52="T60",P52="LAB12"),91.75,IF(AND(O52="T48",P52="15NLW9300"),103,IF(AND(O52="T48",P52="LAB15"),100.75,IF(AND(O52="T48",P52="3015LF"),102,IF(AND(O52="T48",P52="KappaPro15LF"),101,IF(AND(O52="T48",P52="Kappa15LF"),101,IF(AND(O52="T48",P52="12NLW9300"),99,IF(AND(O52="T48",P52="LAB12"),96.75,IF(AND(O52="T48",P52="3012LF"),98,IF(AND(O52="T48",P52="Delta12LFA"),98,IF(AND(O52="T48",P52="S2012"),98,IF(AND(O52="SRX728S",P52="2x18"),96,"Driver")))))))))))))))))))))))))))))))))))))))))))))
I've got to imagine Mr. Chris Allen has an audio spreadsheet or two too.