文档说明：1、本文档为ExcelHome在线培训中心培训课程专用课件，版权归ExcelHome所有；2、本文档仅作为学员学习课程之用途，不得用于转让、出售、商业培训等任何营利性质的用途；也不得发布到互联网上(包括但不限于网站、论坛、微博、博客、网盘）提供收费下载；3、本文档中的单位名称或相关数据均为虚拟的信息，如有雷同，实属巧合；4、门户：http://www.excelhome.net技术论坛：http://club.excelhome.net培训中心：http://t.excelhome.net5、ExcelHome在线培训课程报名咨询QQ：4000049448财会玩转Excel——第7期培训中心课程官方微信:iexcelhome—第7期方微信:iexcelhome查表时间99/614940409604099/109360209303000/19776169512100/38490149651400/692104149801500/1098120169901001/1891301010102001/4921491910261601/787150110462001/984158810611501/128216810107211实际天数厕所水表表底水消耗量厨房水表表底水消耗量单价金额电表表底单价金额80180.004204200.438183.96263.9650150.007933730.438163.37213.3730130.0010112180.43895.48125.4828128.0012202090.5104.50132.5029129.0015092890.5144.50173.5026126.0019904810.5240.50266.5030130.0022462560.5128.00158.0035135.0025563100.5155.00190.002112128773210.5160.50181.50231.329.932203430.5171.50201.40211.327.335122920.5146.00173.30水消耗合计电消耗量水电费总计金额1.772.820.54#N/A2.294.010.54#N/A1.292.250.31125.481.582.490.33#N/A1.893.140.32#N/A2.724.910.27266.501.782.880.34#N/A2.073.370.38#N/A2.093.690.24#N/A2.404.080.36#N/A2.113.560.33#N/A日均费用日均电量日均水量最大最小99/699/899/1099/1200/200/400/600/800/1000/1201/201/401/6100.00120.00140.00160.00180.00200.00220.00240.00260.00280.00300.00263.96213.37125.48132.50173.50266.50158.00190.00181水、电费消耗趋势图01/201/401/601/801/1001/128.00190.00181.50201.40173.3099/699/799/899/999/1099/1199/1200/100/200/300/400/500/600/700/800/900/1000/1100/1201/101/201/301/401/501/601/700.001.002.003.004.005.006.002.824.012.252.493.144.912.883.373.690.540.540.310.330.320.270.340.380.24日均电量日均水量水、电量消耗日均对比图01/201/301/401/501/601/701/801/901/1001/1101/12883.373.694.083.56340.380.240.360.33日均电量日均水量
