Spreadsheet: 114813d1310518789-sum-and-vlookup-vlookup_gpi
Sheet: RM-YTD

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68th | 69th | 70th | 71st | 72nd | 73rd |  |  |  |  |  |  | 80th | 81st | 82nd | 83th | 84th | 85th
manager_id |  |  |  | ntb_prem_total | ntb_adv_total | ntb_ret_total | chk_prem_total | chk_adv_total | chk_ret_total | ins_prem_total | ins_adv_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | [NAME] | adv_new_mtg_life_opp | ret_new_mtg_life_opp | prem_new_mtg_dis_opp | adv_new_mtg_dis_opp | ret_new_mtg_dis_opp | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total | prem_new_ins_life_opp | adv_new_ins_life_opp | ret_new_lns_life_opp | prem_new_ins_dis_opp | adv_new_ins_ids_opp | ret_new_ins_dis_opp | prem_new_loc_life_opp | adv_new_loc_life_opp | ret_new_loc_life_opp | [NAME] | adv_new_loc_dis_op | ret_new_loc_dis_opp | ins_ret_total | ins_ret_total | ins_ret_total | ins_ret_total
8602 |  |  |  | 0 | 3 | 8 | 8 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
81ci |  |  |  | 8 | 2 | 76 | 32 | 34 | 34 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
9900 |  |  |  | 9 | 3 | 2 | 3 | 5 | 5 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 60 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
9211 |  |  |  | 0 | 4 | 3 | 4 | 7 | 7 | 3 | 323 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 80 | 90 | 100 | 110 | 10 | 43 | 43 | 43 | 43 | 43 | 43 | 13 | 43 | 43 | 11 | 43 | 43 | 11 | 12 | 13 | 14 | 15 | 16 | 43 | 43 | 43 | 43
jona |  |  |  | 1 | 5 | 6 | 56 | 5 | 5 | 6 | 4 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 50 | 60 | 43 | 43 | 51 | 43 | 43 | 43 | 43 | 43 | 43 | 90 | 43 | 43 | 89 | 43 | 43 | 22 | 23 | 25 | 25 | 24 | 23 | 21 | 43 | 43 | 43
87rd |  |  |  | 2 | 6 | 7 | 2 | 5 | 6 | 6 | 3 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 99 | 50 | 50 | 23 | 23 | 51 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23
jonaQ |  |  |  | 4 | 7 | 7 | 34 | 6 | 6 | 6 | 3 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 50 | 60 | 43 | 66 | 51 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
9231 |  |  |  | 5 | 7 | 8 | 5 | 7 | 6 | 7 | 32 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 99 | 50 | 60 | 42 | 42 | 51 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42
90di |  |  |  | 2 | 8 | 1 | 7 | 8 | 7 | 2 | 43 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 99 | 50 | 60 | 33 | 33 | 51 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33
mbek |  |  |  | 3 | 9 | 1 | 5 | 7 | 2 | 2 | 2 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 50 | 60 | 43 | 43 | 51 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
jc32 |  |  |  | 4 | 7 | 7 | 34 | 6 | 6 | 6 | 3 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 50 | 60 | 43 | 43 | 51 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
jc99 |  |  |  | 4 | 7 | 7 | 34 | 6 | 6 | 6 | 3 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 99 | 50 | 60 | 43 | 43 | 51 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
jc32 |  |  |  | 5 | 7 | 8 | 5 | 7 | 6 | 7 | 32 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 99 | 50 | 60 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42 | 42