Experimental Data Worksheet Input Cells From Experimental Data Calculations...

Question

Experimental Data Worksheet
    Input Cells From Experimental Data            Calculations (Outputs)
    Temperature In [oC]    Temperature Out [oC]    Flowrate [gpm]    Tm [oC]    Density [kg/m3]    Viscosity [m2/s]     Prandtl# [--]     Thermal Cond. [W/m-K]    Reynolds# [--]    Nusselt# [--]
    45    70    20    57.5    984    4.922E-07    3.11    0.65    642565    1604.9
    Tube Inner Diameter [in.]    Total Cooling Length [in.]    Input Heat To Compare [kW]    Heat Transfer Coefficient [W/m2-K]    Predicted Surface Temperature [oC]    Measured Heat Transfer Removed [kW]    Difference Input and Calorimetry [W]        Tu
ulent
    0.2    120    3500    205594    83.0    129.88     XXXXXXXXXX
Property Data
    tempertaure [K]    tempertaure [oC]    Specific Heat [J/kg-K]    density [kg/m3]    dynamic viscosity [ N-s/m2]    kinematic viscosity [m2/s]    Pr    conductivity [W/m-K]    Values At Calculated Mixed Mean Temperature
    273.15    0    4217    1000    1.750E-03    1.750E-06    12.99    0.569    temp    57.5    oC
    275.00    1.85    4211    1000    1.652E-03    1.652E-06    12.22    0.574    cp    4184    J/kg-K
    280.00    6.85    4198    1000    1.422E-03    1.422E-06    10.26    0.582    dens    984.001    kg/m3
    285.00    11.85    4189    1000    1.225E-03    1.225E-06    8.81    0.590    nu     XXXXXXXXXX    m2/s
    290.00    16.85    4184     XXXXXXXXXX    1.080E-03    1.081E-06    7.56    0.598    pr    3.11    none
    295.00    21.85    4181     XXXXXXXXXX    9.590E-04    9.609E-07    6.62    0.606    k    0.65078    W/m-K
    300.00    26.85    4179     XXXXXXXXXX    8.550E-04    8.576E-07    5.83    0.613
    305.00    31.85    4178     XXXXXXXXXX    7.690E-04    7.728E-07    5.20    0.620
    310.00    36.85    4178     XXXXXXXXXX    6.950E-04    6.999E-07    4.62    0.628
    315.00    41.85    4179     XXXXXXXXXX    6.310E-04    6.367E-07    4.16    0.634
    320.00    46.85    4180     XXXXXXXXXX    5.770E-04    5.833E-07    3.77    0.640
    325.00    51.85    4182     XXXXXXXXXX    5.280E-04    5.349E-07    3.42    0.645
    330.00    56.85    4184     XXXXXXXXXX    4.890E-04    4.968E-07    3.15    0.650
    335.00    61.85    4186     XXXXXXXXXX    4.530E-04    4.612E-07    2.88    0.656
    340.00    66.85    4188     XXXXXXXXXX    4.200E-04    4.288E-07    2.66    0.660
    345.00    71.85    4191     XXXXXXXXXX    3.890E-04    3.983E-07    2.45    0.668
    350.00    76.85    4195     XXXXXXXXXX    3.650E-04    3.749E-07    2.29    0.668
    355.00    81.85    4199     XXXXXXXXXX    3.430E-04    3.533E-07    2.14    0.671
    360.00    86.85    4203     XXXXXXXXXX    3.240E-04    3.350E-07    2.02    0.674
    365.00    91.85    4209     XXXXXXXXXX    3.060E-04    3.176E-07    1.91    0.677
    370.00    96.85    4214     XXXXXXXXXX    2.890E-04    3.008E-07    1.80    0.679
    373.15    100    4217     XXXXXXXXXX    2.790E-04    2.913E-07    1.76    0.680

water-cooling-application-ldqlfcpt.xlsx

Arun Shankar · Accepted Answer

import math
PI = math.pi
temp_in = float(input("Temperature in (deg. C): "))
temp_out = float(input("Temperature out (deg. C): "))
flow_rate = float(input("Flow rate: "))
tube_inner_dia = float(input("Tube inner diameter: "))
total_cooling_length = float(input("Total cooling length: "))
input_heat_compare = float(input("Input Heat To Compare: "))
# Compute density, viscosity, pr, k , cp 
# from the excel sheet 
def extrapolate(yvalues, index, xvalues, tm):
  y1 = yvalues[index]
  y2 = yvalues[index + 1]
  m = (y2 - y1) / (temp_values[index + 1] - temp_values[index])
  y = y1 + (m * (tm - temp_values[index]))
  return y
temp_values = [0.00, 1.85, 6.85, 11.85, 16.85, 21.85, 26.85, 31.85, 36.85, 41.85, 46.85, 51.85, 56.85, 61.85, 66.85, 71.85, 76.85, 81.85, 86.85, 91.85, 96.85, 100.00] 
specific_heat = [4217, 4211, 4198, 4189, 4184, 4181, 4179, 4178, 4178, 4179, 4180, 4182, 4184, 4186, 4188, 4191, 4195, 4199, 4203,

Experimental Data Worksheet Input Cells From Experimental Data Calculations (Outputs) Temperature In [oC] Temperature Out [oC] Flowrate [gpm] Tm [oC] Density [kg/m3] Viscosity [m2/s] Prandtl# [--]...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment