集中全日供应热水耗热量自动计算表

用水水的热水冷水热水单位比热温度温度密度(L/人.d)(J/kg.℃)(℃)(℃)(kg/L)mqrCtrtlρr顾客床1601604187.060.05.00.98员工人16504187.060.05.00.98中餐顾客人次1740204187.060.05.00.98酒吧顾客人次26484187.060.05.00.98员工人200504187.060.05.00.98顾客人次200504187.060.05.00.98员工人50504187.060.05.00.98顾客人次21034187.060.05.00.98员工人10504187.060.05.00.98本表格已经设计好所有函数公式，只需在表格中填入相关的数据即可自动进行计算集中全日供应热水耗热量计算表用水项目单位数热水定额塔楼小计1裙楼餐饮小计2裙楼会所小计3注：热交换器选用导流型容积式热交换器。裙楼会议室小计4合计=小计1+小计2+小计3+小计4未预见=合计*15%总计=合计+未预见附表1-6小时变化设计小时设计小时热交换器热交换器有效贮热设计小时耗热量容积式热交换器设计系数耗热量热水量贮热时间贮热容积容积系数持续时间小时供热量(kW)(m3/h)(min)(m3)(h)(kw)KhQh=Kh*m*qr*C(tr-tl)ρr/86400/1000qrh=Qh/(1.163*(tr-tl)*ρr)TVVr=TV*qrhηTQg=Qh-1.163*η*Vr*1000*(tr-tl)*ρr/T6.76453.527.2145.05.410.753.00368.492.505.240.0845.00.060.753.004.26458.767.295.47372.741.5136.802.1845.01.630.753.00111.151.58.300.1345.00.100.753.006.751.539.310.6345.00.470.753.0031.94184.412.932.20149.831.539.310.6345.00.470.753.0031.941.59.830.1645.00.120.753.007.9849.140.780.5939.921.52.480.0445.00.030.753.002.011.51.970.0345.00.020.753.001.604.440.070.053.61696.7511.088.31566.11104.511.661.2584.92801.2712.749.56651.03集中全日供应热水耗热量计算表注：热交换器选用导流型容积式热交换器。合计=小计1+小计2+小计3+小计4未预见=合计*15%总计=合计+未预见