예제 #1
0
t.add_sheet_name(u'核心员工流失率')
t.write_sheet_companySequence(companySequence)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_level_6_drain,dict_sequence_name=u'6级流失人数',col_of_value=COL['B'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_level_6_on_job,dict_sequence_name=u'6级在职人数',col_of_value=COL['C'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_M_drain,dict_sequence_name=u'M级流失人数',col_of_value=COL['D'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_M_on_job,dict_sequence_name=u'M级在职人数',col_of_value=COL['E'],base_excel_writer=t)

t.add_sheet_name(u'各事业部人员类别对比')
t.write_sheet_companySequence(companySequence)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_regular_brain_drain,dict_sequence_name=u'正式员工流失人数',col_of_value=COL['B'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_regular_on_job,dict_sequence_name=u'正式员工人数',col_of_value=COL['C'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_probation_brain_drain,dict_sequence_name=u'试用员工流失人数',col_of_value=COL['D'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_probation_on_job,dict_sequence_name=u'试用员工人数',col_of_value=COL['E'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_internship_brain_drain,dict_sequence_name=u'实习员工流失人数',col_of_value=COL['F'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_internship_on_job,dict_sequence_name=u'实习员工人数',col_of_value=COL['G'],base_excel_writer=t)

t.add_sheet_name(u'各年限人员流失对比')
t.write_sheet_companySequence(companySequence)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_one_month,dict_sequence_name=u'T<1M流失人数',col_of_value=COL['B'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_three_month,dict_sequence_name=u'T<3M流失人数',col_of_value=COL['C'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_six_month,dict_sequence_name=u'T<6M流失人数',col_of_value=COL['D'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_one_year,dict_sequence_name=u'T<1Y流失人数',col_of_value=COL['E'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_two_year,dict_sequence_name=u'T<2Y流失人数',col_of_value=COL['F'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_three_year,dict_sequence_name=u'T<3Y流失人数',col_of_value=COL['G'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_four_year,dict_sequence_name=u'T<4Y流失人数',col_of_value=COL['H'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_less_than_five_year,dict_sequence_name=u'T<5Y流失人数',col_of_value=COL['I'],base_excel_writer=t)
write_value(companySequence=companySequence,dict_sequence=dict_sequence_comprehensive_attrition,dict_sequence_name=u'综合流失人数',col_of_value=COL['J'],base_excel_writer=t)

t.save_file(u'201603离职分析.xls')
예제 #2
0
#!/usr/bin/env python
# encoding: utf-8

from DismissionData import DismissionRateSummary
from Base import BaseExcelWriter
from DismissionData import write_value

c = DismissionRateSummary('201603区域离职数据.xlsx')
#序列
companySequence = c.unduplicate_sequence()

#需要写入的数据，格式--序列:[0,0,0,0,0]
#五位数字分别为：新员工离职人数，老员工离职人数，主动离职人数，淘汰人数，辞退人数
dict_sequence = c.calc_each_sheet()

t = BaseExcelWriter()
t.add_sheet_name(u'离职率汇总情况')
t.write_sheet_companySequence(companySequence,need_encode=False)
write_value(companySequence,dict_sequence,t,B=u'新员工离职人数',C=u'老员工离职人数',D=u'主动离职人数',E=u'淘汰人数',F=u'辞退人数')

t.save_file('test_dismission_data.xls')