实例：用Excel快速编排复杂值班表

益田假日广场五一节假日值班安排表

值班领导白班教师夜班教师日期星期郭靖hfvv zh2011-8-16二黄蓉bdb bcbbb2011-8-17三黄药师aihbai zcv2011-8-18四洪七公dnbbdfu bhchs2011-8-19五孤独求败dmiih bdhb2011-8-20六欧阳锋bdhdfb dbhsh2011-8-21日周伯通bsbushj zhvhc2011-8-22一段王爷sbbfddh v zgav2011-8-23二郭靖hfvv zh2011-8-24三黄蓉bdb bcbbb2011-8-25四黄药师aihbai zcv2011-8-26五洪七公dnbbdfu bhchs2011-8-27六孤独求败dmiih bdhb2011-8-28日欧阳锋bdhdfb dbhsh2011-8-29一周伯通bsbushj zhvhc2011-8-30二段王爷sbbfddh v zgav2011-8-31三郭靖hfvv hhzhf2011-9-1四黄蓉bdb zhvvc2011-9-2五黄药师aihbai hscv2011-9-3六洪七公dnbbdfu hdyy2011-9-4日孤独求败dmiih ayvav2011-9-5一欧阳锋bdhdfb hbbv2011-9-6二周伯通bsbushj hayvvc2011-9-7三段王爷sbbfddh ahbvv2011-9-8四郭靖hfvv zh2011-8-16二黄蓉bdb bcbbb2011-8-17三黄药师aihbai zcv2011-8-18四洪七公dnbbdfu bhchs2011-8-19五孤独求败dmiih bdhb2011-8-20六欧阳锋bdhdfb dbhsh2011-8-21日周伯通bsbushj zhvhc2011-8-22一段王爷sbbfddh v zgav2011-8-23二郭靖hfvv zh2011-8-24三黄蓉bdb bcbbb2011-8-25四黄药师aihbai zcv2011-8-26五洪七公dnbbdfu bhchs2011-8-27六孤独求败dmiih bdhb2011-8-28日欧阳锋bdhdfb dbhsh2011-8-29一周伯通bsbushj zhvhc2011-8-30二段王爷sbbfddh v zgav2011-8-31三郭靖hfvv hhzhf2011-9-1四黄蓉bdb zhvvc2011-9-2五黄药师aihbai hscv2011-9-3六

洪七公dnbbdfu hdyy2011-9-4日孤独求败dmiih ayvav2011-9-5一欧阳锋bdhdfb hbbv2011-9-6二周伯通bsbushj hayvvc2011-9-7三段王爷sbbfddh ahbvv2011-9-8四