This spreadsheet calculates the PCB transmission line insertion loss versus frequency and temperature curves from the datasheet values of the dielectric constant and loss tangent, in addition to copper foil roughness parameters.
User Guide
1- Input the stripline dimensions, PCB process constants, and temperature coefficients.
2- Input the dielectric constant (DK) in-plane values versus frequency (GHz) for different thicknesses/resin contents. In-plane values are those that were characterized by SPC or Cylindrical resonator. When Dk is measured by an in-plane method (SPC or Cylindrical Resonator), effective Dk is linear to resin content for a given glass style. Then enter DF value as well, the DF value should be almost independent from the dielectric thickness.
3- The tool will calculate the DK of the resin and the glass separately, then it will use them to calculate the in-plane effective dielectric constant and the out-of-plane value for the chosen dielectric thickness. These are the values that should be fed into field simulators. Calculation steps are detailed in the linked article Signal Integrity Analysis Methodology for Printed Circuit Boards.
4- The tool also calculates the stripline loss components (Dielectric loss, smooth metal, and loss due to roughness). Calculation equations are shown in the comments of each relevant cell.
5- Input up to 4 values of temperature to calculate the stripline loss vs temperature. The tool takes into consideration the effect of temperature on DK, DF, and Copper conductivity.
