Electronics > Beginners
Derating Formula Confusion
(1/3) > >>
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
Message Index
Next page
There was an error while thanking
Thanking...

Go to full version
Powered by SMFPacks Advanced Attachments Uploader Mod