Spreadsheet: 815925d1675268278-vlookup-two-criteria-sample
Sheet: Sheet 2

Dept | Bargaining | Classification | Title | Step | Step | Step | Step | Step | Step | Step |  | Dept | Bargaining | Classification | Title | Step | Step | Step | Step | Step | Step | Step
ALL | Management | 20080 | Management Analyst I | 7060 | 7369 | 7695 | 8038 | 8398 |  |  |  | ALL | Management | 20080 | Management Analyst I | 7060 | 7369 | 7695 | 8038 | 8398
ALL | Management | 20090 | Management Analyst II | 8633 | 9023 | 9432 | 9860 | 10310 |  |  |  | ALL | Management | 20090 | Management Analyst II | 8633 | 9023 | 9432 | 9860 | 10310
ALL | Management | 20100 | Management Analyst III | 10499 | 10983 | 11488 | 12020 | 12578 |  |  |  | ALL | Management | 20100 | Management Analyst III | 10499 | 10983 | 11488 | 12020 | 12578
ALL | SEIU 1021 | 50520 | Administrative Assistant I | 4398 | 4601 | 4812 | 5037 | 5268 |  |  |  | ALL | SEIU 1021 | 50520 | Administrative Assistant I | 4398 | 4601 | 4812 | 5037 | 5268
ALL | SEIU 1021 | 50525 | Administrative Assistant II | 4812 | 5037 | 5268 | 5514 | 5769 |  |  |  | ALL | SEIU 1021 | 50525 | Administrative Assistant II | 4812 | 5037 | 5268 | 5514 | 5769
ALL | SEIU 1021 | 50530 | Administrative Assistant III | 5268 | 5514 | 5769 | 6039 | 6323 |  |  |  | ALL | SEIU 1021 | 50530 | Administrative Assistant III | 5268 | 5514 | 5769 | 6039 | 6323
ALL | SEIU 1021 | 50500 | Office Specialist I | 3459 | 3618 | 3778 | 3947 | 4126 |  |  |  | ALL | SEIU 1021 | 50500 | Office Specialist I | 3459 | 3618 | 3778 | 3947 | 4126
ALL | SEIU 1021 | 50505 | Office Specialist II | 3778 | 3947 | 4126 | 4314 | 4508 |  |  |  | ALL | SEIU 1021 | 50505 | Office Specialist II | 3778 | 3947 | 4126 | 4314 | 4508
ALL | SEIU 1021 | 50510 | Office Specialist III | 4025 | 4209 | 4398 | 4601 | 4812 |  |  |  | ALL | SEIU 1021 | 50510 | Office Specialist III | 4025 | 4209 | 4398 | 4601 | 4812
ALL | SEIU 1021 | 50380 | Special Projects Coordinator | 4606 | 4823 | 5047 | 5284 | 5535 |  |  |  | ALL | SEIU 1021 | 50380 | Special Projects Coordinator | 4606 | 4823 | 5047 | 5284 | 5535
ALL | SEIU 1021 PT | 50500 | Office Specialist I (PT) | 19.97 | 20.88 | 21.79 | 22.76 | 23.8 |  |  |  | ALL | SEIU 1021 PT | 50500 | Office Specialist I (PT) | 19.97 | 20.88 | 21.79 | 22.76 | 23.8
ALL | SEIU 1021 PT | 50505 | Office Specialist II (PT) | 21.8 | 22.77 | 23.8 | 24.89 | 26.01 |  |  |  | ALL | SEIU 1021 PT | 50505 | Office Specialist II (PT) | 21.8 | 22.77 | 23.8 | 24.89 | 26.01
ALL | SEIU 1021 PT | 50510 | Office Specialist III (PT) | 23.21 | 24.25 | 25.35 | 26.51 | 27.7 |  |  |  | ALL | SEIU 1021 PT | 50510 | Office Specialist III (PT) | 23.21 | 24.25 | 25.35 | 26.51 | 27.7
ALL | Unrep. Gen. [NAME] | 60600 | Intern | 11 |  |  |  | 54.64 |  |  |  | ALL | Unrep. Gen. [NAME] | 60600 | Intern | 11 |  |  |  | 54.64
ALL | Unrep. Gen. [NAME] | 60570 | Project Specialist | 11 |  |  |  | 54.64 |  |  |  | ALL | Unrep. Gen. [NAME] | 60570 | Project Specialist | 11 |  |  |  | 54.64
ASD | Management | 20360 | Budget Manager/Purchasing Agent | 10499 | 10983 | 11488 | 12020 | 12578 |  |  |  | CM | City Council | 10020 | Council Member | 1625
ASD | Management | 20310 | IT Manager | 12561 | 13145 | 13759 | 14405 | 15083 |  |  |  | CM | City Council | 10010 | Mayor | 2437
ASD | Professionals | 30060 | Accountant | 6362 | 6680 | 7007 | 7365 | 7730 |  |  |  | CM | City Manager | 20010 | City Manager | 21728
ASD | Professionals | 30065 | Payroll Technician | 6207 | 6517 | 6836 | 7185 | 7541 |  |  |  | CM | Dept. Heads | 20470 | CRS Director | 14604 |  |  |  | 17511
ASD | Professionals | 30020 | Senior Accountant | 7258 | 7628 | 8008 | 8405 | 8820 |  |  |  | CM | Dept. Heads | 20020 | Deputy City Manager | 14993 |  |  |  | 17983
ASD | Professionals | 30210 | Senior Planner | 8018 | 8439 | 8885 | 9351 | 9843 |  |  |  | CM | Dept. Heads | 20515 | ECD Director | 14604 |  |  |  | 17511
ASD | Professionals | 30260 | Senior Systems Analyst | 9232 | 9714 | 10198 | 10679 | 11161 |  |  |  | CM | Dept. Heads | 20275 | Finance Director | 14621 |  |  |  | 17529
ASD | SEIU 1021 | 50080 | Finance Specialist I | 4095 | 4277 | 4484 | 4694 | 4913 |  |  |  | CM | Dept. Heads | 20280 | Human Resources Director | 14621 |  |  |  | 17529
ASD | SEIU 1021 | 50090 | Finance Specialist II | 4484 | 4694 | 4913 | 5149 | 5393 |  |  |  | CM | Management | 20030 | City Clerk | 10427 | 10905 | 11407 | 11935 | 12487
ASD | SEIU 1021 | 50100 | Finance Specialist III | 4913 | 5149 | 5393 | 5649 | 5921 |  |  |  | CM | Management | 20650 | Communications & Marketing Mgr. | 10055 | 10551 | 11048 | 11538 | 12035
CM | City Council | 10020 | Council Member | 1625 |  |  |  |  |  |  |  | CM | Management | 20145 | Human Resources Analyst I | 7060 | 7369 | 7695 | 8038 | 8398
CM | City Council | 10010 | Mayor | 2437 |  |  |  |  |  |  |  | CM | Management | 20155 | Human Resources Analyst II | 8633 | 9023 | 9432 | 9860 | 10310
CM | City Manager | 20010 | City Manager | 21728 |  |  |  |  |  |  |  | CM | Management | 20065 | Management Assistant to the City Manager | 8633 | 9023 | 9433 | 9860 | 10311
CM | Dept. Heads | 20470 | CRS Director | 14604 |  |  |  | 17511 |  |  |  | CM | Management | 20700 | Recycling & Solid Waste Prog Mgr | 9782 | 10230 | 10700 | 11194 | 11712
CM | Dept. Heads | 20020 | Deputy City Manager | 14993 |  |  |  | 17983 |  |  |  | CM | Management | 20170 | Supervising Personnel Analyst | 8487 | 8877 | 9285 | 9712 | 10159
CM | Dept. Heads | 20515 | ECD Director | 14604 |  |  |  | 17511 |  |  |  | CM | Management | 20190 | Web Manager | 8448 | 8870 | 9314 | 9779 | 10268
CM | Dept. Heads | 20275 | Finance Director | 14621 |  |  |  | 17529 |  |  |  | CM | Professionals | 30700 | Deputy City Clerk | 5654 | 5938 | 6234 | 6547 | 6875
CM | Dept. Heads | 20280 | Human Resources Director | 14621 |  |  |  | 17529 |  |  |  | CM | SEIU 1021 | 50565 | Digital Marketing Specialist | 4398 | 4601 | 4812 | 5037 | 5268
CM | Management | 20030 | City Clerk | 10427 | 10905 | 11407 | 11935 | 12487 |  |  |  | CM | SEIU 1021 | 50600 | Recycling Programs Coordinator | 5047 | 5293 | 5554 | 5830 | 6115
CM | Management | 20650 | Communications & Marketing Mgr. | 10055 | 10551 | 11048 | 11538 | 12035
CM | Management | 20145 | Human Resources Analyst I | 7060 | 7369 | 7695 | 8038 | 8398
CM | Management | 20155 | Human Resources Analyst II | 8633 | 9023 | 9432 | 9860 | 10310
CM | Management | 20065 | Management Assistant to the City Manager | 8633 | 9023 | 9433 | 9860 | 10311
CM | Management | 20700 | Recycling & Solid Waste Prog Mgr | 9782 | 10230 | 10700 | 11194 | 11712
CM | Management | 20170 | Supervising Personnel Analyst | 8487 | 8877 | 9285 | 9712 | 10159
CM | Management | 20190 | Web Manager | 8448 | 8870 | 9314 | 9779 | 10268
CM | Professionals | 30700 | Deputy City Clerk | 5654 | 5938 | 6234 | 6547 | 6875
CM | SEIU 1021 | 50565 | Digital Marketing Specialist | 4398 | 4601 | 4812 | 5037 | 5268
CM | SEIU 1021 | 50600 | Recycling Programs Coordinator | 5047 | 5293 | 5554 | 5830 | 6115
CRS | Management | 20505 | Clinical Supervisor | 7358 | 7683 | 8025 | 8384 | 8761
CRS | Management | 20450 | CRS Manager | 10590 | 11076 | 11588 | 12125 | 12689
CRS | Management | 20500 | Intervention Counselor I | 6366 | 6643 | 6931 | 7236 | 7554
CRS | Management | 20508 | Youth & Family Services Mgr | 8953 | 9359 | 9786 | 10234 | 10704
CRS | Professionals | 30090 | Case Manager | 4840 | 5082 | 5335 | 5603 | 5882
CRS | Professionals | 30080 | Intervention Counselor | 5651 | 5934 | 6231 | 6543 | 6870
CRS | Professionals | 30100 | Recreation Supervisor | 5966 | 6264 | 6577 | 6905 | 7250
CRS | Professionals | 30400 | Senior Recreation Supervisor | 7527 | 7894 | 8278 | 8684 | 9106
CRS | SEIU 1021 | 50537 | Lead Outreach Worker | 4721 | 4958 | 5206 | 5466 | 5739
CRS | SEIU 1021 | 50361 | Leisure Services [NAME] | 4344 | 4561 | 4789 | 5028 | 5280
CRS | SEIU 1021 | 50560 | Preschool Site Supervisor II | 3462 | 3635 | 3817 | 4008 | 4208
CRS | SEIU 1021 | 50110 | Recreation Administrative Technician | 5410 | 5680 | 5964 | 6263 | 6576
CRS | SEIU 1021 | 50160 | Recreation Program Coordinator | 4924 | 5164 | 5418 | 5688 | 5966
CRS | SEIU 1021 | 50538 | Street Outreach Worker | 3535 | 3712 | 3899 | 4094 | 4298
CRS | SEIU 1021 | 50536 | Youth Employment Coordinator | 4721 | 4958 | 5206 | 5466 | 5739
CRS | SEIU 1021 PT | 50533 | CRS Program Manager | 16.75 | 17.57 | 18.46 | 19.36 | 20.33
CRS | SEIU 1021 PT | 50373 | Facilities Maint Attendant (PT) | 21.2 | 22.25 | 23.37 | 24.54 | 25.77
CRS | SEIU 1021 PT | 50561 | Preschool Site Supv. I | 16.19 | 16.99 | 17.84 | 18.73 | 19.67
CRS | SEIU 1021 PT | 50532 | Program Coordinator (PT) | 21.4 | 22.48 | 23.6 | 24.79 | 26.03
CRS | SEIU 1021 PT | 50538 | PT Street Outreach Worker | 20.4 | 21.42 | 22.49 | 23.62 | 24.79
CRS | SEIU 1021 PT | 50531 | Senior Recreation Leader | 13.75 | 14.46 | 15.18 | 15.94 | 16.75
CRS | Unrep. Gen. [NAME] | 60069 | CRS Program Manager | 17.06 | 17.91 | 18.8 | 19.74 | 20.72
CRS | Unrep. Gen. [NAME] | 60100 | Preschool Aide | 11 | 11 | 11.42 | 11.99 | 12.59
CRS | Unrep. Gen. [NAME] | 60090 | Preschool Teacher | 12.59 | 13.22 | 13.88 | 14.57 | 15.29
CRS | Unrep. Gen. [NAME] | 60072 | Program Coordinator (PT) | 20.72 | 21.75 | 22.83 | 23.97 | 25.16
CRS | Unrep. Gen. [NAME] | 60232 | Recreation Aide | 11 | 11.5 | 12
CRS | Unrep. Gen. [NAME] | 60233 | Recreation Leader | 12 | 12.14 | 12.74 | 13.37 | 14.05
CRS | Unrep. Gen. [NAME] | 60234 | Senior Recreation Leader | 14.05 | 14.75 | 15.48 | 16.25 | 17.06
ECD | Management | 20630 | Economic Development Manager | 10055 | 10551 | 11048 | 11538 | 12035
ECD | Management | 20600 | Environmental Program Manager | 10859 | 11360 | 11885 | 12437 | 13016
ECD | Management | 20540 | HCD Coordinator | 10769 | 11266 | 11786 | 12333 | 12905
ECD | Management | 20510 | Neigh. Pres. Coord. | 10054 | 10551 | 11048 | 11538 | 12035
ECD | Management | 20560 | Planning Manager | 11504 | 12033 | 12592 | 13175 | 13790
ECD | Management | 20620 | Redevelopment Manager | 10859 | 11360 | 11885 | 12437 | 13016
ECD | Professionals | 30250 | Assistant Planner | 5873 | 6166 | 6472 | 6797 | 7137
ECD | Professionals | 30230 | Associate Planner | 7033 | 7382 | 7750 | 8139 | 8543
ECD | Professionals | 30040 | Environmental Programs Inspector | 8223 | 8656 | 9111 | 9588 | 10095
ECD | Professionals | 30600 | Fire Prevention Specialist | 7487 | 7861 | 8254 | 8666 | 9099
ECD | Professionals | 30050 | Haz. Materials Inspect. | 6783 | 7113 | 7471 | 7844 | 8233
ECD | Professionals | 30055 | Sr. Building/Code Compliance Inspect | 8223 | 8656 | 9111 | 9588 | 10095
ECD | Professionals | 30261 | Sr. Haz. Materials Inspect. | 7487 | 7861 | 8254 | 8666 | 9099
ECD | SEIU 1021 | 50290 | Bldg./Code Comp. Insp. | 6347 | 6641 | 6945 | 7264 | 7596
ECD | SEIU 1021 | 50201 | Bldg./Code Comp. Insp. - Trainee | 5597 | 5858 | 6126 | 6407 | 6701
ECD | SEIU 1021 | 50250 | Building Permit [NAME] | 4151 | 4346 | 4548 | 4762 | 4987
ECD | SEIU 1021 | 50255 | Building Permit Technician | 5060 | 5314 | 5570 | 5827 | 6081
ECD | SEIU 1021 | 50256 | Community Development Technician | 4937 | 5184 | 5434 | 5685 | 5933
ECD | SEIU 1021 | 50200 | Neighborhood Pres Specialist | 5846 | 6116 | 6395 | 6688 | 6995
ECD | Management | 20370 | Revenue Collections Manager | 10499 | 10983 | 11488 | 12020 | 12578
ECD | Management | 20350 | [NAME] | 9800 | 10247 | 10717 | 11211 | 11728
PD | Dept. Heads | 40010 | Police Chief | 16078 |  |  |  | 19306
PD | Police [NAME]. | 40015 | Deputy Police Chief | 14832 | 15527 | 16259 | 17023 | 17830
PD | Police [NAME]. | 40020 | Police Captain | 14140 | 14806 | 15506 | 16239 | 17011
PD | Police [NAME]. | 40045 | Police Commander | 12582 | 13195 | 13840 | 14522 | 15238
PD | Police [NAME]. | 40040 | Police Lieutenant | 11988 | 12574 | 13191 | 13844 | 14530
PD | UCPOA | 40220 | Community Relations Officer | 5852 | 6144 | 6451 | 6775 | 7115
PD | UCPOA | 40095 | Community Resources Coord | 5078 | 5332 | 5599 | 5878 | 6172
PD | UCPOA | 40090 | Community Service Aide | 5010 | 5233 | 5467 | 5715 | 5975
PD | UCPOA | 40240 | Confidential Operations Assistant | 5829 | 6121 | 6427 | 6748 | 7085
PD | UCPOA | 40080 | Crime Analyst | 7115 | 7470 | 7844 | 8236 | 8648
PD | UCPOA | 40070 | Dispatch Clerk | 5539 | 5691 | 5948 | 6219 | 6502
PD | UCPOA | 40170 | Dispatch [NAME] | 4796
PD | UCPOA | 40130 | Police Corporal | 9254
PD | UCPOA | 40230 | Police Dept. Office Coord. | 5042 | 5295 | 5560 | 5837 | 6130
PD | UCPOA | 40140 | Police Office Assistant | 4596 | 4825 | 5067 | 5320 | 5587
PD | UCPOA | 40050 | Police_Officer | 6722 | 7032 | 7350 | 7663 | 8049 | 8452 | 8874
PD | UCPOA | 40150 | Police Officer Recruit I | 5386
PD | UCPOA | 40160 | Police Officer Recruit II | 6008
PD | UCPOA | 40060 | Police Records Supervisor | 5852 | 6144 | 6451 | 6775 | 7115
PD | UCPOA | 40030 | Police_Sergeant | 8341 | 8704 | 9085 | 9493 | 9915 | 10410 | 10931
PD | UCPOA | 40120 | Prisoner Transportation Officer | 5010 | 5233 | 5467 | 5715 | 5975
PD | UCPOA | 40100 | Property [NAME] | 5010 | 5233 | 5467 | 5715 | 5975
PD | UCPOA | 40065 | Property Supervisor | 5852 | 6144 | 6451 | 6775 | 7115
PD | UCPOA | 40110 | Public Services Officer I | 5078 | 5332 | 5599 | 5878 | 6172
PD | UCPOA | 40180 | Public Services Officer II | 5346 | 5613 | 5894 | 6187 | 6497
PD | UCPOA PT | 40070 | [NAME] (PT) | 31.96 | 32.83 | 34.31 | 35.88 | 37.51
PD | UCPOA PT | 40181 | Public Services Officer I (PT) | 29.3 | 30.76 | 32.3 | 33.91 | 35.61
PD | UCPOA PT | 40182 | Public Services Officer II (PT) | 30.84 | 32.38 | 34 | 35.69 | 37.48
PD | UCPOA PT | 40120 | Transportation Officer (PT) | 28.9 | 30.19 | 31.54 | 32.97 | 34.47
PD | Unrep. Police PT | 60140 | Per Diem Police Dispatcher | 36 |  |  |  | 50
PD | Unrep. Police PT | 60120 | Police Cadet | 13.8 | 14.37 | 15.01
PD | Unrep. Police PT | 60150 | Police Officer Trainee | 31.08
PD | Unrep. Police PT | 60130 | Police Reserve | 10.73
PW | Dept. Heads | 20710 | Public Works Director | 14896 |  |  |  | 17865
PW | Management | 20580 | Chief Building Official | 12561 | 13145 | 13759 | 14405 | 15083
PW | Management | 20810 | City Engineer | 12543 | 13128 | 13741 | 14385 | 15061
PW | Management | 20860 | Principal Civil Engineer | 11248 | 11769 | 12315 | 12890 | 13490
PW | Management | 20730 | Public Works Superintendent | 10950 | 11454 | 11985 | 12540 | 13126
PW | Management | 20920 | PW Grounds Supervisor | 9422 | 9851 | 10300 | 10774 | 11269
PW | Management | 20910 | PW Streets Supervisor | 9422 | 9851 | 10300 | 10774 | 11269
PW | Management | 20912 | Transit Manager | 10590 | 11076 | 11588 | 12125 | 12689
PW | Professionals | 30150 | Engineer I (Civil) | 5908 | 6200 | 6512 | 6839 | 7180
PW | Professionals | 30130 | Engineer II (Civil) | 6738 | 7075 | 7420 | 7798 | 8185
PW | Professionals | 30120 | Engineer III (Civil) | 7599 | 7979 | 8372 | 8791 | 9231
PW | Professionals | 30030 | Environmental Analyst I | 5654 | 5938 | 6234 | 6547 | 6875
PW | Professionals | 30031 | Environmental Analyst II | 6383 | 6719 | 7073 | 7445 | 7837
PW | Professionals | 30500 | Transit Planner | 7203 | 7562 | 7939 | 8337 | 8752
PW | SEIU 1021 | 50323 | [NAME]. Heavy Eqpt. [NAME]. | 5730 | 5990 | 6266 | 6544 | 6849
PW | SEIU 1021 | 50330 | Maint I - Streets | 4471 | 4682 | 4901 | 5130 | 5374
PW | SEIU 1021 | 50320 | Maint II - Streets | 4950 | 5183 | 5424 | 5680 | 5949
PW | SEIU 1021 | 50325 | Maint Trainee-Parks & Grounds | 3832 | 4009 | 4197 | 4391 | 4596
PW | SEIU 1021 | 50350 | Maint Trainee-Streets | 3832 | 4009 | 4197 | 4391 | 4596
PW | SEIU 1021 | 50291 | Public Works Inspector | 6249 | 6601 | 6920 | 7254 | 7605
PW | SEIU 1021 | 50370 | Public Works Maintenance II | 4950 | 5183 | 5424 | 5680 | 5949
PW | SEIU 1021 | 50292 | Senior Public Works Inspector | 6552 | 6875 | 7204 | 7552 | 7913
PW | SEIU 1021 | 50341 | Street Sweeper Operator | 4769 | 4985 | 5209 | 5449 | 5694
PW | SEIU 1021 | 50321 | Veh. Heavy Eqpt. [NAME]. | 5116 | 5348 | 5592 | 5846 | 6116
PW | SEIU 1021 | 50324 | Veh. Heavy Eqpt. [NAME]. - Trainee | 4179 | 4398 | 4630 | 4874 | 5132
PW | SEIU 1021 | 50326 | Vehicle Equipment Technician | 4252 | 4463 | 4688 | 4922 | 5167
PW, CRS | SEIU 1021 | 50371 | Facilities Maint Attendant | 3674 | 3857 | 4051 | 4254 | 4467
PW, CRS | SEIU 1021 | 50351 | Facility Maint - Worker | 4889 | 5109 | 5339 | 5585 | 5837
PW, CRS | SEIU 1021 | 50332 | Lead Facilities Maintenance Worker | 5730 | 5990 | 6266 | 6544 | 6849
PW, CRS | SEIU 1021 | 50360 | Maint I - Parks & Grounds | 4471 | 4682 | 4901 | 5130 | 5374
PW, CRS | SEIU 1021 | 50342 | Maint II - Parks & Grounds | 4950 | 5183 | 5424 | 5680 | 5949