人力资源入离职分析报表

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,

,,入离职明细▏employmentandresignation,,,,,,,,,按月份汇总▏Summarizedbymonth,,,,,,,,

,,序号,日期,员工编号,姓名,性别,部门,入/离职,备注,2022,月份,月初人数,入职,离职,月末人数,入职率,离职率,备注,

,,1,2022/1/1,DK001,xxx1,男,销售部,入职,,,1月,100,4,3,101,4%,3%,,

,,2,2022/3/10,DK002,xxx2,男,运营部,离职,,入职,2月,101,15,6,110,15%,6%,,

,,3,2022/1/19,DK003,xxx3,女,销售部,入职,,离职,3月,110,9,6,113,8%,5%,,

,,4,2022/2/2,DK004,xxx4,女,商务部,入职,,,4月,113,12,7,118,11%,6%,,

,,5,2022/2/9,DK005,xxx5,女,运营部,入职,,男,5月,118,13,3,128,11%,3%,,

,,6,2022/6/20,DK006,xxx6,女,法务部,离职,,女,6月,128,6,8,126,5%,6%,,

,,7,2022/6/11,DK007,xxx7,男,运营部,离职,,,7月,126,10,6,130,8%,5%,,

,,8,2022/5/12,DK008,xxx8,女,销售部,离职,,,8月,130,8,3,135,6%,2%,,

,,9,2022/2/16,DK009,xxx9,女,销售部,入职,,,9月,135,10,7,138,7%,5%,,

,,10,2022/2/17,DK010,xxx10,男,销售部,离职,,,10月,138,10,3,145,7%,2%,,

,,11,2022/2/25,DK011,xxx11,女,销售部,入职,,,11月,145,7,6,146,5%,4%,,

,,12,2022/2/27,DK012,xxx12,男,运营部,入职,,,12月,146,7,11,142,5%,8%,,

,,13,2022/2/28,DK013,xxx13,女,销售部,入职,,,,,,,,,,,

,,14,2022/7/30,DK014,xxx14,男,商务部,离职,,,按部门汇总▏Summarybydepartment,,,,,,,,

,,15,2022/3/15,DK015,xxx15,女,销售部,入职,,,部门,期初人数,入职,离职,期末人数,入职率,离职率,备注,7

,,16,2022/3/15,DK016,xxx16,男,财务部,入职,,,运营部,15,23,16,22,153%,107%,,

,,17,2022/3/30,DK017,xxx17,男,销售部,入职,,,行政部,5,6,4,7,120%,80%,,

,,18,2022/3/31,DK018,xxx18,男,运营部,入职,,,销售部,58,53,28,83,91%,48%,,

,,19,2022/4/9,DK019,xxx19,男,销售部,入职,,,商务部,10,17,12,15,170%,120%,,

,,20,2022/4/12,DK020,xxx20,女,运营部,入职,,,人事部,4,3,2,5,75%,50%,,

,,21,2022/4/13,DK021,xxx21,女,行政部,入职,,,财务部,5,7,5,7,140%,100%,,

,,22,2022/4/13,DK022,xxx22,女,销售部,入职,,,法务部,3,2,2,3,67%,67%,,

,,23,2022/3/29,DK023,xxx23,女,销售部,离职,,,合计,100,111,69,142,111%,69%,,

,,24,2022/4/27,DK024,xxx24,女,人事部,入职,,,,,,,,,,,

,,25,2022/6/30,DK025,xxx25,女,商务部,离职,,,,100人,111人,69人,142人,,,,

,,26,2022/4/28,DK026,xxx26,男,销售部,入职,,,,,,,,,,,

,,27,2022/4/29,DK027,xxx27,男,销售部,离职,,,,,,,,,,,

,,28,2022/5/2,DK028,xxx28,男,销售部,入职,,,,,,,,,,,

,,29,2022/5/4,DK029,xxx29,男,运营部,入职,,,,,,,,,,,

,,30,2022/7/31,DK030,xxx30,女,人事部,离职,,,,,,,,,,,

,,31,2022/5/9,DK031,xxx31,男,财务部,入职,,,,,,,,,,,

,,32,2022/5/10,DK032,xxx32,女,销售部,离职,,,,,,,,,,,

,,33,2022/2/7,DK033,xxx33,女,运营部,离职,,,,,,,,,,,

,,34,2022/5/11,DK034,xxx34,女,销售部,入职,,,,,,,,,,,

,,35,2022/8/31,DK035,xxx35,男,商务部,离职,,,,,,,,,,,

,,36,2022/8/30,DK036,xxx36,女,商务部,离职,,,,,,,,,,,

,,37,2022/5/23,DK037,xxx37,女,销售部,入职,,,,,,,,,,,

,,38,2022/7/18,DK038,xxx38,男,运营部,离职,,,,,,,,,,,

,,39,2022/5/27,DK039,xxx39,男,销售部,入职,,,,,,,,,,,

,,40,2022/6/21,DK040,xxx40,男,销售部,离职,,,,,,,,,,,

,,41,2022/5/31,DK041,xxx41,男,销售部,入职,,,,,,,,,,,

,,42,2022/5/31,DK042,xxx42,男,运营部,入职,,,,,,,,,,,

,,43,2022/2/6,DK043,xxx43,男,销售部,入职,,,,,,,,,,,

,,44,2022/9/26,DK044,xxx44,男,商务部,离职,,,,,,,,,,,

,,45,2022/6/22,DK045,xxx45,男,销售部,入职,,,,,,,,,,,

,,46,2022/6/26,DK046,xxx46,男,销售部,入职,,,,,,,,,,,

,,47,2022/6/28,DK047,xxx47,男,销售部,离职,,,,,,,,,,,

,,48,2022/12/14,DK048,xxx48,女,销售部,离职,,,,,,,,,,,

,,49,2022/7/11,DK049,xxx49,男,销售部,入职,,,,,,,,,,,

,,50,2022/7/13,DK050,xxx50,男,销售部,离职,,,,,,,,,,,

,,51,2022/7/19,DK051,xxx51,男,销售部,入职,,,,,,,,,,,

,,52,2022/10/3,DK052,xxx52,女,运营部,离职,,,,,,,,,,,

,,53,2022/9/5,DK053,xxx53,女,销售部,入职,,,,,,,,,,,

,,54,2022/9/15,DK054,xxx54,男,销售部,离职,,,,,,,,,,,

,,55,2022/8/9,DK055,xxx55,女,运营部,入职,,,,,,,,,,,

,,56,2022/8/15,DK056,xxx56,男,商务部,入职,,,,,,,,,,,

,,57,2022/11/14,DK057,xxx57,男,法务部,离职,,,,,,,,,,,

,,58,2022/9/8,DK058,xxx58,男,销售部,入职,,,,,,,,,,,

,,59,2022/9/11,DK059,xxx59,男,销售部,入职,,,,,,,,,,,

,,60,2022/9/15,DK060,xxx60,女,运营部,入职,,,,,,,,,,,

,,61,2022/9/17,DK061,xxx61,男,销售部,离职,,,,,,,,,,,

,,62,2022/9/22,DK062,xxx62,女,销售部,入职,,,,,,,,,,,

,,63,2022/11/1,DK063,xxx63,女,商务部,离职,,,,,,,,,,,

,,64,2022/1/5,DK064,xxx64,男,运营部,离职,,,,,,,,,,,

,,65,2022/3/17,DK065,xxx65,男,销售部,离职,,,,,,,,,,,

,,66,2022/9/28,DK066,xxx66,男,法务部,入职,,,,,,,,,,,

,,67,2022/10/5,DK067,xxx67,男,运营部,入职,,,,,,,,,,,

,,68,2022/10/7,DK068,xxx68,女,销售部,入职,,,,,,,,,,,

,,69,2022/10/9,DK069,xxx69,女,销售部,入职,,,,,,,,,,,

,,70,2022/2/2,DK070,xxx70,男,运营部,离职,,,,,,,,,,,

,,71,2022/4/2,DK071,xxx71,男,行政部,离职,,,,,,,,,,,

,,72,2022/10/20,DK072,xxx72,女,销售部,入职,,,,,,,,,,,

,,73,2022/10/30,DK073,xxx73,男,商务部,入职,,,,,,,,,,,

,,74,2022/1/28,DK074,xxx74,女,商务部,离职,,,,,,,,,,,

,,75,2022/11/7,DK075,xxx75,女,商务部,入职,,,,,,,,,,,

,,76,2022/11/8,DK076,xxx76,女,运营部,入职,,,,,,,,,,,

,,77,2022/11/14,DK077,xxx77,女,运营部,入职,,,,,,,,,,,

,,78,2022/11/26,DK078,xxx78,男,商务部,入职,,,,,,,,,,,

,,79,2022/11/27,DK079,xxx79,男,商务部,入职,,,,,,,,,,,

,,80,2022/1/21,DK080,xxx80,男,行政部,离职,,,,,,,,,,,

,,81,2022/12/3,DK081,xxx81,男,销售部,离职,,,,,,,,,,,

,,82,2022/12/3,DK082,xxx82,男,销售部,入职,,,,,,,,,,,

,,83,2022/12/21,DK083,xxx83,男,行政部,入职,,,,,,,,,,,

,,84,2022/12/25,DK084,xxx84,女,销售部,离职,,,,,,,,,,,

,,85,2022/12/30,DK085,xxx85,男,运营部,入职,,,,,,,,,,,

,,86,2022/1/2,DK086,xxx86,男,运营部,入职,,,,,,,,,,,

,,87,2022/1/3,DK087,xxx87,男,销售部,入职,,,,,,,,,,,

,,88,2022/3/3,DK088,xxx88,男,财务部,离职,,,,,,,,,,,

,,89,2022/5/10,DK089,xxx89,男,销售部,入职,,,,,,,,,,,

,,90,2022/6/25,DK090,xxx90,男,销售部,离职,,,,,,,,,,,

,,91,2022/6/5,DK091,xxx91,男,运营部,离职,,,,,,,,,,,

,,92,2022/2/4,DK092,xxx92,女,行政部,入职,,,,,,,,,,,

,,93,2022/2/9,DK093,xxx93,男,销售部,入职,,,,,,,,,,,

,,94,2022/2/12,DK094,xxx94,男,销售部,离职,,,,,,,,,,,

,,95,2022/2/13,DK095,xxx95,男,商务部,入职,,,,,,,,,,,

,,96,2022/4/12,DK096,xxx96,女,销售部,离职,,,,,,,,,,,

,,97,2022/2/17,DK097,xxx97,男,销售部,入职,,,,,,,,,,,

,,98,2022/2/17,DK098,xxx98,男,运营部,入职,,,,,,,,,,,

,,99,2022/4/24,DK099,xxx99,男,财务部,离职,,,,,,,,,,,

,,100,2022/8/9,DK100,xxx100,女,运营部,离职,,,,,,,,,,,

,,101,2022/2/21,DK101,xxx101,女,销售部,入职,,,,,,,,,,,

,,102,2022/12/11,DK102,xxx102,女,人事部,离职,,,,,,,,,,,

,,103,2022/2/25,DK103,xxx103,男,运营部,入职,,,,,,,,,,,

,,104,2022/4/1,DK104,xxx104,女,销售部,离职,,,,,,,,,,,

,,105,2022/2/28,DK105,xxx105,男,商务部,入职,,,,,,,,,,,

,,106,2022/3/5,DK106,xxx106,男,销售部,入职,,,,,,,,,,,

,,107,2022/3/7,DK107,xxx107,女,销售部,入职,,,,,,,,,,,

,,108,2022/3/10,DK108,xxx108,女,财务部,入职,,,,,,,,,,,

,,109,2022/7/27,DK109,xxx109,男,行政部,离职,,,,,,,,,,,

,,110,2022/3/14,DK110,xxx110,男,商务部,入职,,,,,,,,,,,

,,111,2022/9/8,DK111,xxx111,男,财务部,离职,,,,,,,,,,,

,,112,2022/3/25,DK112,xxx112,女,销售部,入职,,,,,,,,,,,

,,113,2022/5/13,DK113,xxx113,男,运营部,离职,,,,,,,,,,,

,,114,2022/4/1,DK114,xxx114,男,行政部,入职,,,,,,,,,,,

,,115,2022/4/5,DK115,xxx115,男,销售部,离职,,,,,,,,,,,

,,116,2022/4/14,DK116,xxx116,男,人事部,入职,,,,,,,,,,,

,,117,2022/4/18,DK117,xxx117,女,行政部,入职,,,,,,,,,,,

,,118,2022/4/26,DK118,xxx118,女,销售部,入职,,,,,,,,,,,

,,119,2022/4/29,DK119,xxx119,男,销售部,入职,,,,,,,,,,,

,,120,2022/4/30,DK120,xxx120,男,销售部,入职,,,,,,,,,,,

,,121,2022/9/23,DK121,xxx121,男,运营部,离职,,,,,,,,,,,

,,122,2022/9/22,DK122,xxx122,男,运营部,离职,,,,,,,,,,,

,,123,2022/7/24,DK123,xxx123,女,运营部,离职,,,,,,,,,,,

,,124,2022/10/19,DK124,xxx124,男,销售部,离职,,,,,,,,,,,

,,125,2022/5/15,DK125,xxx125,女,销售部,入职,,,,,,,,,,,

,,126,2022/11/12,DK126,xxx126,男,销售部,入职,,,,,,,,,,,

,,127,2022/5/22,DK127,xxx127,男,法务部,入职,,,,,,,,,,,

,,128,2022/5/24,DK128,xxx128,男,财务部,入职,,,,,,,,,,,

,,129,2022/5/27,DK129,xxx129,男,销售部,入职,,,,,,,,,,,

,,130,2022/11/8,DK130,xxx130,女,财务部,离职,,,,,,,,,,,

,,131,2022/6/2,DK131,xxx131,男,销售部,入职,,,,,,,,,,,

,,132,2022/6/5,DK132,xxx132,女,商务部,入职,,,,,,,,,,,

,,133,2022/12/10,DK133,xxx133,男,运营部,离职,,,,,,,,,,,

,,134,2022/6/9,DK134,xxx134,男,商务部,入职,,,,,,,,,,,

,,135,2022/6/13,DK135,xxx135,女,销售部,离职,,,,,,,,,,,

,,136,2022/6/19,DK136,xxx136,男,财务部,入职,,,,,,,,,,,

,,137,2022/7/4,DK137,xxx137,男,销售部,入职,,,,,,,,,,,

,,138,2022/7/7,DK138,xxx138,男,销售部,入职,,,,,,,,,,,

,,139,2022/7/9,DK139,xxx139,男,销售部,入职,,,,,,,,,,,

,,140,2022/7/10,DK140,xxx140,男,运营部,入职,,,,,,,,,,,

,,141,2022/9/12,DK141,xxx141,男,商务部,离职,,,,,,,,,,,

,,142,2022/7/13,DK142,xxx142,男,行政部,入职,,,,,,,,,,,

,,143,2022/12/16,DK143,xxx143,男,行政部,离职,,,,,,,,,,,

,,144,2022/7/21,DK144,xxx144,女,销售部,入职,,,,,,,,,,,

,,145,2022/7/28,DK145,xxx145,男,商务部,入职,,,,,,,,,,,

,,146,2022/7/31,DK146,xxx146,女,商务部,入职,,,,,,,,,,,

,,147,2022/8/1,DK147,xxx147,男,销售部,入职,,,,,,,,,,,

,,148,2022/8/1,DK148,xxx148,女,销售部,入职,,,,,,,,,,,

,,149,2022/8/13,DK149,xxx149,女,运营部,入职,,,,,,,,,,,

,,150,2022/11/23,DK150,xxx150,女,运营部,离职,,,,,,,,,,,

,,151,2022/8/15,DK151,xxx151,女,运营部,入职,,,,,,,,,,,

,,152,2022/10/29,DK152,xxx152,女,财务部,离职,,,,,,,,,,,

,,153,2022/8/28,DK153,xxx153,女,商务部,入职,,,,,,,,,,,

,,154,2022/8/31,DK154,xxx154,男,销售部,入职,,,,,,,,,,,

,,155,2022/9/2,DK155,xxx155,男,运营部,入职,,,,,,,,,,,

,,156,2022/9/13,DK156,xxx156,女,销售部,入职,,,,,,,,,,,

,,157,2022/9/14,DK157,xxx157,女,人事部,入职,,,,,,,,,,,

,,158,2022/9/27,DK158,xxx158,男,商务部,入职,,,,,,,,,,,

,,159,2022/11/13,DK159,xxx159,男,销售部,离职,,,,,,,,,,,

,,160,2022/10/5,DK160,xxx160,女,运营部,入职,,,,,,,,,,,

,,161,2022/12/30,DK161,xxx161,男,商务部,离职,,,,,,,,,,,

,,162,2022/10/17,DK162,xxx162,男,运营部,入