{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["龙坪过程跟进 (2)","龙坪过程跟进","龙坪招聘进度表","Sheet1","Sheet2"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"龙坪过程跟进 (2)","index":0,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[4,0,5,0],[6,0,7,0],[8,0,9,0],[4,1,5,1],[4,2,5,2]]}
["区域/事业部","项目名称","城市","面积（平米）","业态","开始筹备时间","接楼时间","最新开业时间","目标筹备期（月）","最新筹备期（月）","已筹备时长（月）","编制数","筹备期人工预算（万）","投资预测人工成本（万）","原计划开业时间","是否新进驻城市"]
["华南一区","深圳龙坪商场","深圳",30000,"购百","2020-12-01","2021-05-14","2021-12-17",{"$f":"IF(E2=\"超市\",4,IF(D2<50000,8,IF(D2>=80000,12,10)))","v":8},12,{"$f":"COUNT(D8:P8)","v":8},{"$f":"龙坪招聘进度表!E7","v":69},{"$f":"SUM(D7:P7,0)","v":357.132362813359},370,"2021-10-01","否"]
[]
[]
["项目","预算/实际","累计值","接楼前\n5个月","接楼前\n4个月","接楼前\n3个月","接楼前\n2个月","接楼前\n1个月","开业前7个月","开业前6个月","开业前5个月","开业前4个月","开业前3个月","开业前2个月","开业前1个月","开业当月"]
[null,null,null,"2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
["人工","预算",{"$f":"SUM(D7:K7)","v":107.248147271693},0,3.82604129172399,3.46676529172399,9.32339938936608,12.2010838072661,23.5726771565198,27.7824018767595,27.0757784583333,31.6570584583333,41.8565844583333,50.4921684583333,60.1034520833333,65.7749520833333]
[null,"实际",{"$f":"SUM(D8:P8)","v":117.52},0,8,12.4,8.56,11.36,21.2,26,30]
["人数","预算",{"$f":"K9","v":35},{"$f":"龙坪招聘进度表!F7","v":0},{"$f":"龙坪招聘进度表!H7","v":1},{"$f":"龙坪招聘进度表!J7","v":1},{"$f":"龙坪招聘进度表!L7","v":6},{"$f":"龙坪招聘进度表!N7","v":11},{"$f":"龙坪招聘进度表!P7","v":22},{"$f":"龙坪招聘进度表!R7","v":28},{"$f":"龙坪招聘进度表!T7","v":35},{"$f":"龙坪招聘进度表!V7","v":37},{"$f":"龙坪招聘进度表!X7","v":41},{"$f":"龙坪招聘进度表!Z7","v":53},{"$f":"龙坪招聘进度表!AB7","v":69},{"$f":"龙坪招聘进度表!AD7","v":69}]
[null,"实际",{"$f":"K10","v":34},{"$f":"龙坪招聘进度表!G7","v":2},{"$f":"龙坪招聘进度表!I7","v":3},{"$f":"龙坪招聘进度表!K7","v":3},{"$f":"龙坪招聘进度表!M7","v":6},{"$f":"龙坪招聘进度表!O7","v":14},{"$f":"龙坪招聘进度表!Q7","v":20},{"$f":"龙坪招聘进度表!S7","v":24},{"$f":"龙坪招聘进度表!U7","v":34},{"$f":"龙坪招聘进度表!W7","v":0},{"$f":"龙坪招聘进度表!Y7","v":0},{"$f":"龙坪招聘进度表!AA7","v":0},{"$f":"龙坪招聘进度表!AC7","v":0},{"$f":"龙坪招聘进度表!AE7","v":0}]
[]
[]
[]
[]
[]
[]
["区域/事业部","项目名称","年","月","人工预算","人工实际","预算-实际","筹备期人工累计","预算人数","实际人数","目标筹备期（月）","已筹备月数","预计开业时间","面积","投资预测人工成本（万）"]
["超市事业部深圳区","龙华购物中心超市",2022,1,20.6552311719489,null,null,null,30,null,4,null,"2022-05-01",{"$f":"N17","v":"面积"}]
["超市事业部深圳区","龙华购物中心超市",2022,2,25.1922763247018,null,null,null,37,null,4,null,"2022-05-01","面积"]
["超市事业部深圳区","龙华购物中心超市",2022,3,32.4654870794665,null,null,null,48,null,4,null,"2022-05-01","面积"]
["超市事业部深圳区","龙华购物中心超市",2022,4,46.52570704117,null,null,null,61,null,4,null,"2022-05-01","面积"]
["超市事业部深圳区","龙华购物中心超市",2022,5,42.13570704117,null,null,null,61,null,4,null,"2022-05-01","面积"]

{"sheet":"龙坪过程跟进","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,2,3,5],[4,2,4,5],[5,2,5,5],[6,2,6,5],[7,2,7,5],[8,2,8,5],[3,0,4,0],[5,0,6,0],[7,0,8,0],[10,0,11,0],[12,0,13,0],[14,0,15,0],[10,1,11,1],[10,2,11,2]]}
["区域/事业部","项目名称","城市","面积（平米）","业态","开始筹备时间","接楼时间","最新开业时间","目标筹备期（月）","最新筹备期（月）","已筹备时长（月）","编制数","筹备期人工预算（万）","投资预测人工成本（万）","原计划开业时间","是否新进驻城市"]
["华南一区","深圳龙坪商场","深圳",30000,"购百","2020-12-01","2021-05-14","2021-12-17",{"$f":"IF(E2=\"超市\",4,IF(D2<50000,8,IF(D2>=80000,12,10)))","v":8},12,{"$f":"COUNT(D14:P14)","v":8},{"$f":"龙坪招聘进度表!E7","v":69},{"$f":"SUM(D13:P13,0)","v":357.132362813359},370,44470,"否"]
[]
["筹备进度","已筹备时长 VS 目标筹备期",{"$f":"K2/I2","v":1}]
[null,"已筹备时长 VS 最新筹备期",{"$f":"K2/J2","v":0.666666666666667}]
["员工到岗进度","累计到岗 VS 编制数",{"$f":"C16/L2","v":0.492753623188406}]
[null,"当月到岗 VS当月目标到岗",{"$f":"C16/C15","v":0.971428571428571}]
["人工成本使用","累计人工 VS 筹备期人工预算",{"$f":"C14/M2","v":0.329065669305968}]
[null,"累计人工 VS 累计人工预算",{"$f":"C14/C13","v":1.09577650513892}]
[]
["项目","预算/实际","累计值","接楼前\n5个月","接楼前\n4个月","接楼前\n3个月","接楼前\n2个月","接楼前\n1个月","开业前7个月","开业前6个月","开业前5个月","开业前4个月","开业前3个月","开业前2个月","开业前1个月","开业当月"]
[null,null,null,"2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01","2021-10-01","2021-11-01","2021-12-01"]
["人工","预算",{"$f":"SUM(D13:K13)","v":107.248147271693},0,3.82604129172399,3.46676529172399,9.32339938936608,12.2010838072661,23.5726771565198,27.7824018767595,27.0757784583333,31.6570584583333,41.8565844583333,50.4921684583333,60.1034520833333,65.7749520833333]
[null,"实际",{"$f":"SUM(D14:P14)","v":117.52},0,8,12.4,8.56,11.36,21.2,26,30]
["人数","预算",{"$f":"K15","v":35},{"$f":"龙坪招聘进度表!F7","v":0},{"$f":"龙坪招聘进度表!H7","v":1},{"$f":"龙坪招聘进度表!J7","v":1},{"$f":"龙坪招聘进度表!L7","v":6},{"$f":"龙坪招聘进度表!N7","v":11},{"$f":"龙坪招聘进度表!P7","v":22},{"$f":"龙坪招聘进度表!R7","v":28},{"$f":"龙坪招聘进度表!T7","v":35},{"$f":"龙坪招聘进度表!V7","v":37},{"$f":"龙坪招聘进度表!X7","v":41},{"$f":"龙坪招聘进度表!Z7","v":53},{"$f":"龙坪招聘进度表!AB7","v":69},{"$f":"龙坪招聘进度表!AD7","v":69}]
[null,"实际",{"$f":"K16","v":34},{"$f":"龙坪招聘进度表!G7","v":2},{"$f":"龙坪招聘进度表!I7","v":3},{"$f":"龙坪招聘进度表!K7","v":3},{"$f":"龙坪招聘进度表!M7","v":6},{"$f":"龙坪招聘进度表!O7","v":14},{"$f":"龙坪招聘进度表!Q7","v":20},{"$f":"龙坪招聘进度表!S7","v":24},{"$f":"龙坪招聘进度表!U7","v":34},{"$f":"龙坪招聘进度表!W7","v":0},{"$f":"龙坪招聘进度表!Y7","v":0},{"$f":"龙坪招聘进度表!AA7","v":0},{"$f":"龙坪招聘进度表!AC7","v":0},{"$f":"龙坪招聘进度表!AE7","v":0}]

{"sheet":"龙坪招聘进度表","index":2,"n_rows":28,"n_cols":34,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,30],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,21,1,22],[1,23,1,24],[1,25,1,26],[1,27,1,28],[1,29,1,30],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,19,2,20],[2,21,2,22],[2,23,2,24],[2,25,2,26],[2,27,2,28],[2,29,2,30],[1,0,3,0],[7,0,25,0],[1,1,3,1],[7,1,8,1],[9,1,12,1],[13,1,17,1],[18,1,20,1],[21,1,25,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,31,2,33],[26,0,27,1]]}
["龙坪商场招聘进度跟进表（预计开业时间  2021年12月17） ——0813更新"]
["部门","线条","职位名称","职级","定编\n人数","开业前12个月",null,"开业前11个月",null,"开业前10个月",null,"开业前9个月",null,"开业前8个月",null,"开业前7个月",null,"开业前6个月",null,"开业前5个月",null,"开业前4个月",null,"开业前3个月",null,"开业前2个月",null,"开业前1个月",null,"开业当月",null,"人员招聘渠道计划"]
[{"$nulls":5},"2020-12-01",null,"2021-01-01",null,"2021-02-01",null,"2021-03-01",null,"2021-04-01",null,"2021-05-01",null,"2021-06-01",null,"2021-07-01",null,"2021-08-01",null,"2021-09-01",null,"2021-10-01",null,"2021-11-01",null,"2021-12-01"]
[{"$nulls":5},"计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","计划","实际","内调\n（含提升）","外招","管培生"]
[null,null,null,"管理岗",{"$f":"E8+E9+E10+E11+E12+E14+E15+E16+E17+E19+E20+E22+E23+E24","v":24},0,2,1,3,1,3,3,4,5,8,12,9,16,11,17,17,19,0,20,0,23,0,24,0,24,0,18,5,1]
[null,null,null,"一线技工岗",{"$f":"E13+E18+E21+E25+E26","v":45},0,0,0,0,0,0,3,2,6,6,10,11,12,13,18,17,18,0,21,0,30,0,45,0,45,0,9,36,0]
[null,null,null,"合计",{"$f":"E5+E6","v":69},0,2,1,3,1,3,6,6,11,14,22,20,28,24,35,34,37,0,41,0,53,0,69,0,69,0,27,41,1]
["华南一区龙坪项目","门店","总经理","经理级",1,null,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"助理总经理","经理级",1,null,1,null,1,null,1,1,1,1,1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,"营销线","高级营销经理","高级",1,null,null,0,1,0,1,0,1,0,1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"营销策划经理","专业岗",3,{"$nulls":10},1,0,2,0,2,1,2,null,2,null,3,null,3,null,3,null,null,2,1]
[null,null,"设计师","专业岗",1,{"$nulls":12},1,0,1,0,0,null,1,null,1,null,1,null,1,null,null,1]
[null,null,"促销文员","一线",1,{"$nulls":14},1,1,1,null,1,null,1,null,1,null,1,null,null,1]
[null,"客服线","高级客服经理","高级",1,{"$nulls":10},1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"内勤","3-5级",1,{"$nulls":8},1,1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"客服经理","3-5级",2,{"$nulls":12},1,0,1,2,2,null,2,null,2,null,2,null,2,null,2]
[null,null,"大客户经理","3-5级",1,{"$nulls":14},0,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"客服专员","一线",13,{"$nulls":14},0,0,0,null,1,null,6,null,13,null,13,null,1,12]
[null,"经营线","高级品类经理","高级",2,{"$nulls":10},2,null,2,1,2,2,2,null,2,null,2,null,2,null,2,null,2]
[null,null,"品类经理","3-5级",6,{"$nulls":12},1,1,2,2,3,null,3,null,5,null,6,null,6,null,4,2]
[null,null,"文员","一线",2,{"$nulls":14},1,0,1,null,1,null,1,null,2,null,2,null,null,2]
[null,"防损分部","分部经理","高级",1,{"$nulls":6},1,1,1,1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"电工班长","3-5级",1,{"$nulls":9},1,1,1,1,1,1,1,1,null,1,null,1,null,1,null,1,null,1]
[null,null,"防损主管","3-5级",2,{"$nulls":8},1,2,2,2,2,2,2,2,2,null,2,null,2,null,2,null,2,null,2]
[null,null,"电工","3-5级",7,{"$nulls":8},1,2,3,3,3,4,5,5,5,null,5,null,6,null,7,null,7,null,4,3]
[null,null,"防损员","防损员",22,{"$nulls":6},3,2,5,4,7,8,9,9,11,11,11,null,13,null,16,null,22,null,22,null,4,18]
["华南一区财务部",null,"业务财务经理","专业岗",1,{"$nulls":16},0,null,0,null,1,null,1,null,1,null,null,1]
[null,null,"会计助理","3-5级",1,{"$nulls":16},0,null,0,null,0,null,1,null,1,null,1]

{"sheet":"Sheet1","index":3,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":11}
[{"$nulls":6},8,7,6,5,4,3,2,1]
[{"$nulls":5},"预算",5,14,19,39,60,93,110,120]
[{"$nulls":5},"计划",3,10,25,35,55,88,105,115]
[{"$nulls":5},"实际",2,10,16,30,70,80,100,110]
{"$rows_empty":19}
[{"$nulls":6},8,7,6,5,4,3,2,1]
[{"$nulls":5},"预算",{"$f":"G13*2","v":10},28,35,48,65,72.7788019497505,78,85]
[{"$nulls":5},"实际",8,25,30,45,69,70,75,82]

{"sheet":"Sheet2","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}