{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["各事业部奖金包测算过程（关联公式）","事业部合伙奖金及项目经营奖金台账","分配表","台账"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":22,"defined_names":2385,"comments":1,"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":"各事业部奖金包测算过程（关联公式）","index":0,"n_rows":21,"n_cols":36,"rows_kept":21,"cut":false,"hidden":true,"merged":[[3,31,4,31],[3,32,4,32],[3,33,4,33],[3,34,4,34],[3,35,4,35],[3,26,4,26],[3,27,4,27],[3,28,4,28],[3,29,4,29],[3,30,4,30],[5,12,10,12],[5,13,10,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[5,1,20,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[3,5,4,5],[2,5,2,15],[5,6,10,6],[3,7,4,7],[5,7,10,7],[3,8,4,8],[5,8,10,8],[5,9,10,9],[3,10,4,10],[3,11,4,11],[5,11,10,11],[3,12,4,12],[2,16,2,23],[2,24,2,29],[2,30,2,35],[2,1,4,1],[3,6,4,6],[3,9,4,9],[3,13,4,13],[3,18,4,18],[3,19,4,19],[3,20,4,20],[3,21,4,21],[3,22,4,22],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,17,4,17]]}
[]
[null,null,"2023年度上半年奖金"]
[null,"事业部","项目","上半年奖金合计（100%口径）","上半年奖金合计（实发口径）","直管项目",{"$nulls":10},"委托项目",{"$nulls":7},"共管项目",{"$nulls":5},"战略型项目"]
[{"$nulls":5},"2023年1-6月收入","2023年预计毛利率","2023年上半年奖金基数","奖金提取比例","上半年清缴率","上半年欠款","上半年清缴考核系数","2023年上半年奖金（100%口径）","2023年上半年奖金（60%口径）","单项目毛利贡献占比（全年）","单项目奖金包（60%口径）","上半年奖金基准","成立时间","年中","时间系数","上半年清缴率","上半年清缴考核系数","上半年管理费支出","委托项目奖金额（100%口径）","上半年奖金基准","奖金提取比例","共管项目超额收益提取奖金①","共管项目基础奖金②","共管项目奖金额①+②（100%口径）","共管项目奖金额①+②（60%口径）","上半年代建费收入（奖金基准）","奖金提取比例","上半年清缴率","上半年清缴考核系数","战略型项目奖金额（100%口径）","战略型项目奖金额（60%口径）"]
[]
[null,"商办事业部","商办事业部平台"]
[null,null,"深信服项目",{"$nulls":12},{"$f":"O7/($O$12-$O$9)*$N$6*93%","v":{"$error":"#DIV/0!"}}]
[null,null,"广州新华项目",{"$nulls":12},{"$error":"#DIV/0!"}]
[null,null,"深圳新华项目",{"$nulls":12},{"$f":"N6*7%","v":0}]
[null,null,"虎牙项目",{"$nulls":12},{"$error":"#DIV/0!"}]
[null,null,"中山傲雷项目部",{"$nulls":12},{"$error":"#DIV/0!"}]
[null,null,"直管项目奖金合计",{"$f":"M12","v":0},{"$f":"N12","v":0},{"$nulls":7},{"$f":"SUM(M6:M11)","v":0},{"$f":"SUM(N6:N11)","v":0},{"$f":"SUM(O7:O11)","v":0},{"$f":"SUM(P7:P11)","v":{"$error":"#DIV/0!"}}]
[null,null,"C塔项目",{"$nulls":29},1,1,{"$f":"AE13*AF13*AH13","v":0},{"$f":"AI13*60%","v":0}]
[null,null,"战略型项目奖金合计",{"$f":"AI14","v":0},{"$f":"AJ14","v":0},{"$nulls":25},{"$f":"SUM(AE10:AE12)","v":0},null,null,null,{"$f":"AI13","v":0},{"$f":"AJ13","v":0}]
[null,null,"长沙大家健投项目部",{"$nulls":14},"2023-04-17","2023-6-30",{"$f":"(S15-R15)/(365/2)","v":0.40547945205479452},1,1.1000000000000001,0,{"$f":"Q15*T15*V15-W15","v":0}]
[null,null,"委托项目管理费支出"]
[null,null,"委托项目奖金合计",{"$f":"X17","v":0},{"$f":"D17","v":0},{"$nulls":18},{"$f":"X15","v":0}]
[null,null,"广州诗悦项目部",{"$nulls":21},{"$f":"10*12*20.27%-(19.27+0.65)","v":4.4039999999999999},0.1,{"$f":"Y18*Z18","v":0.44040000000000001},{"$f":"IF(1.5*#REF!-0.65<0,0,1.5*#REF!-0.65)","v":{"$error":"#REF!"}},{"$f":"AA18+AB18","v":{"$error":"#REF!"}},{"$f":"AC18*0.6","v":{"$error":"#REF!"}}]
[null,null,"共管项目合计",{"$f":"AC19","v":{"$error":"#REF!"}},{"$f":"AD19","v":{"$error":"#REF!"}},{"$nulls":23},{"$f":"AC18","v":{"$error":"#REF!"}},{"$f":"AD18","v":{"$error":"#REF!"}}]
[null,null,"本次暂扣金额",null,{"$f":"-(E12*40%+E14*40%)","v":0}]
[null,null,"商办事业部合计",{"$f":"D12+D14+D17+D19+D20","v":{"$error":"#REF!"}},{"$f":"E12+E14+E17+E19+E20","v":{"$error":"#REF!"}}]

{"sheet":"事业部合伙奖金及项目经营奖金台账","index":1,"n_rows":27,"n_cols":48,"rows_kept":27,"cut":false,"hidden":false,"merged":[[25,17,25,21],[2,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[18,21,19,21],[25,1,25,2],[25,3,25,4],[25,5,25,6],[25,7,25,11],[25,12,25,16],[3,39,3,40],[3,41,3,42],[3,43,3,44],[3,45,3,47],[24,1,24,6],[24,7,24,21],[18,22,19,22],[18,31,19,31],[18,32,19,32],[18,33,19,33],[18,35,19,35],[18,36,19,36],[18,45,19,45],[18,46,19,46],[18,47,19,47],[2,34,2,47],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,22],[3,23,3,24],[3,25,3,26],[3,27,3,28],[3,29,3,30],[3,31,3,33],[3,34,3,36],[3,37,3,38],[0,1,0,33],[2,2,2,5],[2,6,2,13],[2,14,2,19],[2,20,2,33]]}
[null,"事业部合伙奖金及项目经营奖金台账"]
[null,"（一）各事业部/项目奖金台账"]
[null,"事业部/项目","全周期预计奖金包",null,null,null,"累计已审批及已发放金额",{"$nulls":7},"过程特殊情况记录",{"$nulls":5},"x年x月",{"$nulls":13},"x年x月"]
[null,null,"全周期预计毛利润","奖金提取比例","全周期预计奖金包","全周期预计开发周期（月，可研版）","累计审批金额100%口径（万）",null,"累计实发金额（万）",null,"累计留存金额（万）",null,"累计调整金额（万）",null,"调整金额（万）",null,"待扣款金额（万）",null,"待补发金额（万）",null,"各事业部/项目奖金合计",null,null,"直管项目",null,"委托项目",null,"共管项目",null,"战略型项目",null,"奖金调整",null,null,"各事业部/项目奖金合计",null,null,"直管项目",null,"委托项目",null,"共管项目",null,"战略型项目",null,"奖金调整"]
[{"$nulls":6},"金额","说明","金额","说明","金额","说明","金额","说明","金额","说明","金额","说明","金额","说明","奖金周期","100%口径（万）","实发口径（万）","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","奖金调整说明","奖金周期","100%口径（万）","实发口径（万）","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","100%口径","实发口径","奖金调整说明"]
[null,"华东事业一部"]
[null,"华南公建事业部"]
[null,"商办事业部"]
[null,"东南事业一部"]
[null,"西部事业一部"]
[null,"事业部合计",{"$nulls":19},{"$f":"X11+Z11+AB11+AD11+AF11","v":0},{"$f":"Y11+AA11+AC11+AE11+AG11","v":0},{"$f":"SUM(X6:X10)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"AL11+AN11+AP11+AR11+AT11","v":0},{"$f":"AM11+AO11+AQ11+AS11+AU11","v":0},{"$f":"SUM(AL6:AL10)","v":0},0,0,0,0,0,0,0,0,0]
[null,"平潭项目"]
[null,"佛山顺控项目"]
[null,"大亚湾永泰项目"]
[null,"北海项目"]
[null,"太原敦化南路项目"]
[null,"太原东社项目"]
[null,"光明项目"]
[null,"石家庄南席村项目"]
[null,"廊坊项目"]
[null,"直管项目合计",{"$nulls":19},{"$f":"X21+Z21+AB21+AD21+AF21","v":0},{"$f":"Y21+AA21+AC21+AE21+AG21","v":0},{"$f":"SUM(X12:X20)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"AL21+AN21+AP21+AR21+AT21","v":0},{"$f":"AM21+AO21+AQ21+AS21+AU21","v":0},{"$f":"SUM(AL12:AL20)","v":0},0,0,0,0,0,0,0,0,0]
[null,"整体合计",{"$nulls":19},{"$f":"X22+Z22+AB22+AD22+AF22","v":0},{"$f":"Y22+AA22+AC22+AE22+AG22","v":0},{"$f":"X11+X21","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"AL22+AN22+AP22+AR22+AT22","v":0},{"$f":"AM22+AO22+AQ22+AS22+AU22","v":0},{"$f":"AL11+AL21","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"（二）公司整体项目经营奖调节奖金池"]
[null,"累计已审批及已发放金额",{"$nulls":5},"各期奖金提取发放明细",{"$nulls":27},"本次使用额度","剩余额度"]
[null,"累计审批金额100%口径（万）",null,"累计实发金额（万）",null,"累计留存金额（万）",null,"x年x月",{"$nulls":4},"x年x月",{"$nulls":4},"x年x月"]
[null,"金额","说明","金额","说明","金额","说明","奖金周期","使用前额度","本次使用额度","本次使用说明","剩余额度","奖金周期","使用前额度","本次使用额度","本次使用说明","剩余额度","奖金周期","使用前额度","本次使用额度","本次使用说明","剩余额度"]

{"sheet":"分配表","index":2,"n_rows":53,"n_cols":38,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,20,9,20],[11,20,23,20],[25,20,32,20],[34,20,39,20],[41,20,46,20],[6,19,9,19],[10,19,23,19],[24,19,32,19],[33,19,39,19],[40,19,46,19],[6,10,9,10],[10,10,46,10],[10,11,23,11],[24,11,32,11],[33,11,39,11],[40,11,46,11],[6,4,9,4],[10,4,23,4],[24,4,32,4],[33,4,39,4],[40,4,46,4],[6,1,9,1],[10,1,46,1],[47,1,51,1],[52,1,56,1],[10,2,23,2],[24,2,32,2],[33,2,39,2],[40,2,46,2],[0,10,0,35],[1,10,1,35],[3,10,3,35],[4,10,4,18],[4,19,4,35]]}
[{"$nulls":10},"XX年上半年（年度）奖金分配-XX事业部部",{"$nulls":26},"返回汇总表2"]
[{"$nulls":10},"一、2023年上半年奖金额度"]
[{"$nulls":10},"奖金周期",null,"上半年总奖金额（100%口径）",null,"上半年实发奖金额（①+②+③+④+⑤）",null,"①直管项目奖金",null,"②委托项目奖金",null,"③共管项目奖金",null,"④战略型项目奖金",null,"⑤奖金调整",null,"奖金调整说明",null,"事业部平台初始分配比例",null,"∑项目初始分配比例",null,"直管项目负责人初始分配比例"]
["2023年上半年奖金分配建议名单",{"$nulls":9},"二、奖金分配测算"]
[null,"事业部","项目名称","参与奖金分配名单","2023年1-6月代建费收入","奖金期限起算日期","奖金期限截止日期","职能系数","精力投入系数",null,"个人奖金额度",{"$nulls":8},"测算过程"]
[null,"事业部","项目名称","参与奖金分配名单","2023年1-6月代建费收入","奖金期限起算日期","奖金期限截止日期","职能系数","精力投入系数",null,"事业部","项目名称","姓名","员工ID","职位","初测金额（实发）","征求意见金额\n（实发）","调整说明","总经理审批金额（实发）","奖金分包","个人初始比例","奖金期限起算日期","奖金期限截止日期","出勤率","职能系数","精力投入系数","职等","职级系数","2023Q1绩效等级","2023Q2绩效等级","2023Q1绩效系数","2023Q2绩效系数","个人考核系数","职能系数*精力投入系数*出勤率*职级系数*个人考核系数","个人奖金占比","本期个人奖金额","项目负责人","备注"]
[null,"事业部平台",null,"钦小平","6月30日：37,713,508.77\n9月30日：53,120,891.77","2023-01-01","2023-06-30","事业部整体包的25%",1,null,"事业部平台",{"$nulls":4},{"$f":"AJ7","v":{"$error":"#NAME?"}},null,null,null,{"$f":"P3*T11AD3","v":{"$error":"#NAME?"}},{"$f":"25%/AD3","v":{"$error":"#DIV/0!"}},{"$f":"F7","v":"2023-01-01"},{"$f":"G7","v":"2023-06-30"},{"$f":"(W7-V7)/180","v":1},1,{"$f":"IF(I7=\"\",1,I7)","v":1},{"$f":"VLOOKUP(M7,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA7,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N7,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N7,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N7,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N7,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AE7:AF7)","v":{"$error":"#N/A"}},null,1,{"$f":"T7*U7*AI7","v":{"$error":"#NAME?"}}]
[null,null,"设计管理部","周瑾茹",null,"2023-01-01","2023-06-30","事业部整体包的1%",1,null,null,"设计管理部",null,null,null,{"$error":"#NAME?"},{"$nulls":4},{"$f":"1-U7","v":{"$error":"#DIV/0!"}},"2023-01-01","2023-06-30",1,{"$f":"1%/AD3","v":{"$error":"#DIV/0!"}},1,{"$f":"VLOOKUP(M8,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA8,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N8,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N8,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N8,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N8,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"Y8*X8*Z8*AB8*AG8","v":{"$error":"#DIV/0!"}},{"$f":"AH8/SUM($AH$8:$AH$10)","v":{"$error":"#DIV/0!"}},{"$f":"$T$7*$U$8*AI8","v":{"$error":"#NAME?"}}]
[null,null,"成本管理部","刘忠伟",null,"2023-01-01","2023-06-30","事业部整体包的1.5%",1,null,null,"成本管理部",null,null,null,{"$error":"#NAME?"},{"$nulls":5},"2023-01-01","2023-06-30",1,{"$f":"1.5%/AD3","v":{"$error":"#DIV/0!"}},1,{"$f":"VLOOKUP(M9,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA9,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N9,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N9,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N9,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N9,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$f":"AL28=AH9/SUM($AH$8:$AH$10)","v":{"$error":"#DIV/0!"}},{"$error":"#NAME?"}]
[null,null,"财务管理部","王煜姣",null,"2023-01-01","2023-06-30","事业部整体包的1.5%",1,null,null,"财务管理部",null,null,null,{"$error":"#NAME?"},{"$nulls":5},"2023-01-01","2023-06-30",1,{"$f":"1.5%/AD3","v":{"$error":"#DIV/0!"}},1,{"$f":"VLOOKUP(M10,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA10,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N10,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N10,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N10,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N10,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#NAME?"}]
[null,"直管项目","西咸泾河新城项目","程琳","6月30日：10578458.77\n9月30日：11,578,458.77","2023-01-01","2023-06-30",null,null,null,"直管项目","西咸泾河新城项目",null,null,null,{"$f":"AJ11","v":0},null,null,null,{"$f":"'[22]各事业部奖金包测算过程（关联公式）'!P79*AF3","v":0},{"$f":"AH3","v":0},{"$f":"F11","v":"2023-01-01"},{"$f":"G11","v":"2023-06-30"},{"$f":"(W11-V11)/180","v":1},{"$f":"IF(H11=\"\",1,H11)","v":1},{"$f":"IF(I11=\"\",1,I11)","v":1},{"$f":"VLOOKUP(M11,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA11,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N11,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N11,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N11,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N11,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AE11:AF11)","v":{"$error":"#N/A"}},{"$f":"Y11*X11*Z11*AB11*AG11","v":{"$error":"#N/A"}},1,{"$f":"T11*U11*AI11","v":0}]
[null,null,null,"夏扬",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":4},{"$f":"1-U11","v":1},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M12,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA12,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N12,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N12,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N12,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N12,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AH12/SUM($AH$12:$AH$24)","v":{"$error":"#N/A"}},{"$f":"$T$11*$U$12*AI12","v":{"$error":"#N/A"}}]
[null,null,null,"王华",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M13,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA13,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N13,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N13,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N13,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N13,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"冯振新",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M14,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA14,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N14,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N14,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N14,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N14,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"陈江涛",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M15,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA15,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N15,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N15,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N15,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N15,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"马艳红",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M16,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA16,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N16,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N16,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N16,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N16,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"吴婷",null,"2023-01-01","2023-06-30",0.19,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.19,1,{"$f":"VLOOKUP(M17,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA17,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N17,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N17,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N17,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N17,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"刘浩杰",null,"2023-01-01","2023-06-30",0.19,0.8,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.19,0.8,{"$f":"VLOOKUP(M18,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA18,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N18,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N18,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N18,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N18,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"刘忠伟",null,"2023-01-01","2023-06-30",0.08,0.3,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.08,0.3,{"$f":"VLOOKUP(M19,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA19,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N19,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N19,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N19,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N19,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"王煜娇",null,"2023-01-01","2023-06-30",0.2,0.5,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.2,0.5,{"$f":"VLOOKUP(M20,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA20,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N20,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N20,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N20,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N20,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"魏云",null,"2023-05-10","2023-06-30",0.2,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-10","2023-06-30",0.28333333333333333,0.2,1,{"$f":"VLOOKUP(M21,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA21,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N21,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N21,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N21,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N21,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"吕品",null,"2023-06-02","2023-06-30",0.2,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-06-02","2023-06-30",0.15555555555555556,0.2,1,{"$f":"VLOOKUP(M22,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA22,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N22,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N22,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N22,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N22,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"周瑾茹",null,"2023-01-01","2023-06-30",0.08,0.2,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.08,0.2,{"$f":"VLOOKUP(M23,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA23,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N23,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N23,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N23,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N23,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"徐洋森",null,"2023-01-01","2023-06-30",0.08,0.5,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.08,0.5,{"$f":"VLOOKUP(M24,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA24,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N24,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N24,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N24,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N24,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"国港项目（一二期）","李波浪","国港玖峯悦项目：6月30日：21,135,050.00\n9月30日：29,199,002.23\n\n国港玖峯禧项目：\n6月30日：2,000,000.00\n9月30日：3,500,000.00","2023-01-01","2023-06-30",null,1,null,null,"国港项目（一二期）",null,null,null,0,null,null,null,{"$f":"'[22]各事业部奖金包测算过程（关联公式）'!P80*AF3","v":0},{"$f":"AH3","v":0},"2023-01-01","2023-06-30",1,1,1,{"$f":"VLOOKUP(M25,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA25,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N25,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N25,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N25,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N25,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},1,{"$f":"T25*U25*AI25","v":0}]
[null,null,null,"田勇",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":4},{"$f":"1-U25","v":1},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M26,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA26,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N26,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N26,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N26,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N26,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AH26/SUM($AH$26:$AH$33)","v":{"$error":"#N/A"}},{"$f":"$T$25*$U$26*AI26","v":{"$error":"#N/A"}}]
[null,null,null,"王岩",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M27,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA27,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N27,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N27,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N27,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N27,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"杨帆",null,"2023-01-01","2023-06-30",{"$f":"55%/2","v":0.27500000000000002},1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.27500000000000002,1,{"$f":"VLOOKUP(M28,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA28,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N28,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N28,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N28,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N28,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"孙鹏",null,"2023-06-05","2023-06-30",{"$f":"55%/2","v":0.27500000000000002},1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-06-05","2023-06-30",0.1388888888888889,0.27500000000000002,1,{"$f":"VLOOKUP(M29,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA29,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N29,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N29,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N29,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N29,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"王静静",null,"2023-01-01","2023-06-30",0.45,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.45,1,{"$f":"VLOOKUP(M30,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA30,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N30,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N30,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N30,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N30,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"吕品",null,"2023-01-01","2023-06-02",0.25,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-02",0.84444444444444444,0.25,1,{"$f":"VLOOKUP(M31,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA31,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N31,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N31,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N31,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N31,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"朱佳樱",null,"2023-05-29","2023-06-30",0.25,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-29","2023-06-30",0.17777777777777778,0.25,1,{"$f":"VLOOKUP(M32,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA32,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N32,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N32,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N32,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N32,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"徐彦",null,"2023-01-01","2023-06-30",0.3,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.3,1,{"$f":"VLOOKUP(M33,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA33,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N33,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N33,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N33,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N33,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"陕铁物流西咸综合调度中心项目","梅金蕾","6月30日：0.00\n9月30日：1,818,474.30\n备注：上半年无代建费收取节点，年中奖金从其他项目预借，年底归还，预借比例为事业部整体毛利率的6%（项目全年目标值506万/事业部全年目标值6391.5万*75%）","2023-01-01","2023-06-30",{"$nulls":4},"陕铁物流西咸综合调度中心项目",null,null,null,{"$f":"AJ34","v":0},null,null,null,{"$f":"'[22]各事业部奖金包测算过程（关联公式）'!P81*AF3","v":0},{"$f":"AH3","v":0},{"$f":"F34","v":"2023-01-01"},{"$f":"G34","v":"2023-06-30"},{"$f":"(W34-V34)/180","v":1},{"$f":"IF(H34=\"\",1,H34)","v":1},{"$f":"IF(I34=\"\",1,I34)","v":1},{"$f":"VLOOKUP(M34,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA34,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N34,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N34,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N34,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N34,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"AVERAGE(AE34:AF34)","v":{"$error":"#N/A"}},{"$f":"Y34*X34*Z34*AB34*AG34","v":{"$error":"#N/A"}},1,{"$f":"T34*U34*AI34","v":0}]
[null,null,null,"曹小飞",null,"2023-01-01","2023-06-30",0.35,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":4},{"$f":"1-U34","v":1},"2023-01-01","2023-06-30",1,0.35,1,{"$f":"VLOOKUP(M35,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA35,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N35,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N35,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N35,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N35,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AH35/SUM($AH$35:$AH$40)","v":{"$error":"#N/A"}},{"$f":"$T$34*$U$35*AI35","v":{"$error":"#N/A"}}]
[null,null,null,"王振栋",null,"2023-05-10","2023-06-30",0.35,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-10","2023-06-30",0.28333333333333333,0.35,1,{"$f":"VLOOKUP(M36,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA36,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N36,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N36,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N36,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N36,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"徐洋森",null,"2023-01-01","2023-06-30",0.15,0.7,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.15,0.7,{"$f":"VLOOKUP(M37,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA37,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N37,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N37,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N37,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N37,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"刘浩杰",null,"2023-01-01","2023-06-30",0.25,0.6,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.25,0.6,{"$f":"VLOOKUP(M38,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA38,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N38,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N38,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N38,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N38,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"姚艳婷",null,"2023-01-01","2023-06-30",0.1,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.1,1,{"$f":"VLOOKUP(M39,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA39,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N39,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N39,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N39,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N39,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"成起",null,"2023-01-01","2023-06-30",0.25,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-01-01","2023-06-30",1,0.25,1,{"$f":"VLOOKUP(M40,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA40,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N40,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N40,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N40,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N40,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"西安高新六路项目","万清","6月30日：2,000,000.00\n9月30日：3,024,956.47","2023-04-01","2023-06-30",null,1,null,null,"西安高新六路项目",null,null,null,0,null,null,null,{"$f":"'[22]各事业部奖金包测算过程（关联公式）'!P82*AF3","v":0},{"$f":"AH3","v":0},"2023-04-01","2023-06-30",0.5,1,1,{"$f":"VLOOKUP(M41,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA41,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N41,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N41,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N41,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N41,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},1,{"$f":"T41*U41*AI41","v":0}]
[null,null,null,"李辽峰",null,"2023-05-27","2023-06-30",0.2,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":4},{"$f":"1-U41","v":1},"2023-05-27","2023-06-30",0.18888888888888888,0.2,1,{"$f":"VLOOKUP(M42,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA42,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N42,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N42,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N42,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N42,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"AH42/SUM($AH$42:$AH$47)","v":{"$error":"#N/A"}},{"$f":"$T$41*$U$42*AI42","v":{"$error":"#N/A"}}]
[null,null,null,"周瑾茹",null,"2023-05-04","2023-06-30",0.4,0.7,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-04","2023-06-30",0.31666666666666665,0.4,0.7,{"$f":"VLOOKUP(M43,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA43,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N43,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N43,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N43,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N43,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"沈龙梅",null,"2023-06-05","2023-06-30",0.4,1,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-06-05","2023-06-30",0.1388888888888889,0.4,1,{"$f":"VLOOKUP(M44,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA44,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N44,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N44,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N44,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N44,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"王煜姣",null,"2023-05-04","2023-06-30",0.1,0.4,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-04","2023-06-30",0.31666666666666665,0.1,0.4,{"$f":"VLOOKUP(M45,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA45,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N45,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N45,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N45,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N45,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"刘忠伟",null,"2023-05-04","2023-06-30",0.3,0.8,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-05-04","2023-06-30",0.31666666666666665,0.3,0.8,{"$f":"VLOOKUP(M46,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA46,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N46,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N46,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N46,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N46,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,"高鹏飞",null,"2023-04-17","2023-06-02",0.4,0.8,{"$nulls":6},{"$error":"#N/A"},{"$nulls":5},"2023-04-17","2023-06-02",0.25555555555555554,0.4,0.8,{"$f":"VLOOKUP(M47,[22]花名册!A:D,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(AA47,[22]Q1Q2绩效及职级系数!J:K,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N47,[22]Q1Q2绩效及职级系数!B:H,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N47,[22]Q1Q2绩效及职级系数!B:H,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N47,[22]Q1Q2绩效及职级系数!B:H,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(N47,[22]Q1Q2绩效及职级系数!B:H,6,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"委托项目","定西项目",null,"6月30日：2,000,000.00\n9月30日：4,000,000.00",{"$nulls":5},"合计",{"$nulls":4},{"$f":"SUM(P7:P47)","v":{"$error":"#NAME?"}},{"$f":"SUM(Q7:Q47)","v":0},null,{"$f":"SUM(S7:S47)","v":0},{"$f":"SUM(T7:T47)","v":{"$error":"#NAME?"}},{"$nulls":15},{"$f":"SUM(AJ7:AJ47)","v":{"$error":"#NAME?"}}]
[]
[]
[]
[]
[null,"共管项目"]

{"sheet":"台账","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}