Related Resources: excel calculators

Planks Law Spreadsheet

NOTE:

• Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
• This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
• Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Excel Calculators Spreadsheets

This workbook computes and displays the spectral blackbody emissive power for a number of source temperatures. This new version also allows the user to display the spectral blackbody emissive power for a particular temperature and evaluates the integral over a wavelength range selected by the user (replicating the tabulated blackbody radiation functions). (See the cyan-colored lines in the figure below.) Another sheet is this workbook includes tabulated data for the spectral transmissivity of two types of glass, one of them a standard glass, the other a "low-E" (low-emissivity) glass. The function for blackbody emissive power, this tabulated data and Simpson's Rule may be used to find the total transmissivity of the two glasses.

Download: Plank's Law Calculator

Planck's law describes the spectral density of electromagnetic radiation emitted by a black body in thermal equilibrium at a given temperature T, when there is no net flow of matter or energy between the body and its environment.

Credit: Professor Robert J. Ribando

Related:

• Black Body Radiation Formula and Calculator- Heat Transfer
• Heat Transfer Practical Approach
• Black Body Radiation Formula and Calculator- Heat Transfer
• Solar Cell Radiation Handbook