Electronics > Beginners
Derating Formula Confusion
bostonman:
I'm looking at an RF chip and it can handle +25dBm at +25 degrees C and it's derated linearly to +20dBm at +100 degrees C.
I'm trying to create a formula in Excel so it will show the dBm at all temperatures between 25 and 100, but for some reason confusing myself on creating the formula.
Anyone have input?
IanB:
Use the linear interpolation formula:
(20 - 25) / (100 - 25) = (P - 25) / (T - 25)
T is the given temperature in °C and P is the unknown power in dBm. For example, if T were 75°C the power rating would be 21.7 dBm.
bostonman:
This helps balance the equation.... and actually this is what I had before, but how should I create a formula to use in Excel?
rstofer:
Create a column of temperatures, create another column of derated values using the formula above. Then plot the columns.
https://www.ablebits.com/office-addins-blog/2018/08/29/make-line-graph-excel/#create-line-graph-excel
bostonman:
I just need a single cell to show a value when it references a temperature typed into another cell.
Navigation
[0] Message Index
[#] Next page
Go to full version