| 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 |