生产线CIP基础报表-CIPCOP基础报表(XLS)(1)

生产线名称:PET-1注入机转速:22000瓶(罐)/小时当月总产量1402687.57标准箱当月非果汁产品产量1402687.57标准箱当月果汁产品产量标准箱CIPCOP总费用4854.99非果汁CIP总费用4854.99果汁CIPCOP总费用0.00平均每千箱CIPCOP成本3.46元/千箱平均每千箱CIP成本3.46元/千箱平均每千箱CIPCOP成本#DIV/0!元/千箱生产线名称：分别插入CAN、PET(有几条线要几张表)、RB报表上报时间：每月5日前单位：时间用小时，水量用吨，电量用度,费用用人民币元；本报表中的单纯CIP时间是指单纯运行水冲、三步、五步、冷清洗消毒、五步热清洗消毒的时间，不含上下注入机清洗杯时间、设备转换和CIP后参数调试、注入出瓶到正常运作的时间。单纯CIP每次平均时间水冲洗0.180.29项目单位单位数据种类费用种类费用三步热水消毒#DIV/0!0.57水费元/吨3.00水冲洗27.44水冲洗79.30三步碱清洗0.450.10五步清洗消毒及热清洗消毒热水费元/吨13.32三步热水消毒#DIV/0!三步热水消毒#DIV/0!五步清洗消毒0.830.21清洗一次碱费用元/次58.34三步碱清洗111.18三步碱清洗348.52五步热清洗消毒#DIV/0!0.00人工费元/人/小时6.48五步清洗消毒173.84五步清洗消毒287.85冷清洗消毒0.49混比注入设备冲洗水每小时用量吨/小时21.00五步热清洗消毒#DIV/0!五步清洗消毒#DIV/0!整个CIP每次平均时间水冲洗0.76混比注入设备CIP每次热水用量吨/次1.50冷清洗消毒62.99冷清洗消毒209.04三步热水消毒#DIV/0!ECA冷清洗消毒一次药品费用元/次7.58COP#DIV/0!三步碱清洗3.10五步清洗消毒中使用化学法消毒一次费用元/次0.00五步清洗消毒2.11混比注入设备每小时用电量度/小时54.56五步热清洗消毒#DIV/0!电费元/度0.57冷清洗消毒2.12五步热一次热碱配置用热水费用元/吨0.00五步热一次配好的热碱量吨/次0.03COP一次药品费用元/次1.76COP一次热水费用元/吨0.00COP一次热水用量吨/次0.00COP每次用电量度/小时0.00日期12345678910111213141516171819202122232425262728293031Total1100010000100010101100011000000000800021000010000000000000000000004010020140水冲洗几次时间0.180.18单纯水冲洗平均时间#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.18#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.18每月次数设备转换几次总用时00CIP结束到第一瓶产品出来几次总用时0.580.581第一瓶产品出来到注入进入正常转速几次总用时0.080.081整个水冲洗平均时间#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.76#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.76第一步及最后一步冷水冲几次总用时0热水冲几次总用时0单纯三步热水平均用时#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!设备转换几次总用时00CIP结束到第一瓶产品出来几次总用时00第一瓶产品出来到注入进入正常转速几次总用时00上下清洗杯时间00其它辅助用时00整个三步热水平均用时#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!第一步及最后一步冷水冲几次总用时000.200000.20000.200.200.20.20000.20.20000000001.6碱液冲几次总用时000.2500000.250000.2500.2500.250.250000.250.250000000002单纯三步碱洗平均用时#DIV/0!#DIV/0!0.45#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.45#DIV/0!#DIV/0!#DIV/0!0.45#DIV/0!0.45#DIV/0!0.450.45#DIV/0!#DIV/0!#DIV/0!0.450.45#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.45设备转换几次总用时000.16666666700000.1666666670000.500.166666667000.16666700000.50000000001.6666676CIP结束到第一瓶产品出来几次总用时000.500000.50000.58333333300.416666667000.4166670000.50.50000000003.4166677第一瓶产品出来到注入进入正常转速几次总用时000.08333333300000.0833333330000.08333333300.083333333000.0833330000.0833330.0833330000000000.5833337上下清洗杯时间000.200000.20000.200.16666666700.0833330.1666670000.20.20000000001.4166678其它辅助用时001.16666666700000.9833333330004.302.58333333300.0666670.5333330000.4166674.68333300000000014.733338整个三步碱洗平均用时#DIV/0!#DIV/0!2.48#DIV/0!#DIV/0!#DIV/0!#DIV/0!2.30#DIV/0!#DIV/0!#DIV/0!6.03#DIV/0!3.78#DIV/0!0.601.73#DIV/0!#DIV/0!#DIV/0!1.576.33#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!3.10第一步、第三步、最后一步冷水冲几次总用时0000.66666670.33333333300000.3333330000000000000000000001.333333碱液冲几次总用时0000.50.2500000.250000000000000000000001热水或消毒剂冲几次总用时0000.50.2500000.250000000000000000000001单纯五步清洗消毒平均用时#DIV/0!#DIV/0!#DIV/0!0.83333330.833333333#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.833333#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!0.833333设备转换几次总用时00000.333333333000000000000000000000000000.3333331CIP结束到第一瓶产品出来几次总用时00010.500000.4166670000000000000000000001.9166673第一瓶产品出来到注入进入正常转速几次总用时0000.16666670.08333333300000.0833330000000000000000000000.3333333上下清洗杯时间0000.36666670.18333333300000.150000000000000000000000.73其它辅助用时0000.78333330.56666666700000.80000000000000000000002.153整个五步清洗消毒平均用时#DIV/0!#DIV/0!#DIV/0!1.912.42#DIV/0!#DIV/0!#DIV/0!#DIV/0!2.20#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!2.11第一步、第三步、最后一步冷水冲几次总用时0热碱液冲几次总用时0热水冲几次总用时0单纯五步清洗消毒平均用时#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!设备转换几次总用时00CIP结束到第一瓶产品出来几次总用时00第一瓶产品出来到注入进入正常转速几次总用时00上下清洗杯时间00其它辅助用时00整个五步清洗消毒平均用时#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!冷水冲几次总用时0.116667000.4500.1833330.75几种成份几次总用时0.183333000.83333300.1833331.2单纯冷清洗消毒平均用时#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/