Question: Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2; SOLVED Excel Formula

$30.00

Category:

Description

Question: Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2; SOLVED

Excel Formula

Based on the user’s selection of enclosure types, there are 4 different tables based off of temperature and watt/ft^2. In one spread sheet, it calculates the change in temperature (delta t) and we want it to point to the watts/ft^2 on the specific enclosure type that the user has selected. User is trying to get an accurate value of the watt/ft^2 based on their enclosure and temperature calculations. On sheet 5, there is a table with the formula I have used to get the data. I need a way to find an exact value on Sheet 2 B5, rather than beween “always lower” and “always higher”.

Sheet 2: User selection and calculation page

Sheet 3: Tables

Sheet 5: Formulas of tables

Please copy and paste this link:

https://docs.google.com/spreadsheets/d/11K0z1PTM_lTEUKFIKp_RBXk69cLZ3DmM_imMtB_bm-A/edit?usp=sharing


error: Content is protected !!