Passive RIAA Equalization Calculation

[jbanneck]

Hi All,

This is want happens when I have a day off. I create an Excel spreadsheet to calculate passive RIAA equalization. I just finished putting together a PassLabs Pearl Phono pre-amp (sounds great!). But just for fun and a learning project I decided to check Wayne's work. I downloaded Stanley P. Lipshitz's AES article "On RIAA Equalization Networks" (what did we do before the WWW?)(Thank you so much Mr. Lipshitz!).

Choosing figure 7b and table 1c I created an Excel spreadsheet. Be aware, I am no Excel Wizard, nor have I taken a math class for 40 years. So I did the best I could. The spreadsheet is not elegant but it seems to work correctly.

To use it simply change the values for the Cs and Rs in yellow. The results should appear in the blue cells.

If you see any issues with the spreadsheet please let me know. Also, if you would like to add the circuit in figure 7a/table 1b, or any other circuit, feel free. I am sure other DIY Audio folks will appreciate it.

BTW, Wayne values as calculated are very close to the standard. Measured values for T5 and T0 (as calculated, but not to standard) are spot on given the standard component values he used. T4 is about 100Hz off but this may be due to component tolerances.

Thanks,
Jim