Spreadsheet: 86012d1285970238-formulas-for-shifting-targets-jomili-bvj-
Sheet: WorkTab 

-
-
-Sum of _FTE |  | Sum of _FTE |  | These are history months
PROGRAM_CODE-Posn Function | [NAME] Change | Posn Function | PROGRAM_CODE | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | Grand Total | Base Projected July | Base Projected August | Authorized FTEs | Adjusted  July | Adjusted  August | Authorized Projections Exceeding Allocations | First Altered  July | First Altered  August | Justification for Change | Final Adjusted July | Final Adjusted August | Authorized Projections Exceeding Allocations | HistoryRange
11000-2010 CPS Realignmnt Floater | 0 | 2010 CPS Realignmnt Floater | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 12 | 6 | 6 |  | No formulas |  |  | #N/A | 6 | #N/A | E5:G5
11008-2010 CPS Realignmnt Floater | 0 | 2010 CPS Realignmnt Floater | 11008 | 3 | 3 | 3 | 9 | 9 | 9 | 54 | 9 | 9 |  | 1 |  | [NAME] | 10 | 9 |  | E6:G6
11000-CPS Accountant/Bookkeeper | 0 | CPS Accountant/Bookkeeper | 11000 | 4 | 4 | 4 | 12 | 12 | 12 | 5 | 4 | 4 |  | 3 |  | [NAME] | 7 | 4 | Exceeds | E7:G7
11000-CPS Cent Plcmt [NAME] | 0 | CPS Cent Plcmt [NAME] | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 1 | 2 | 2 | Exceeds | 10 |  | [NAME] | 12 | 2 | Exceeds | E8:G8
11000-CPS Cent Plcmt Casewrkr | 0 | CPS Cent Plcmt Casewrkr | 11000 | 6 | 6 | 6 | 18 | 18 | 18 | 11 | 6 | 6 |  |  |  |  |  |  |  | E9:G9
11000-CPS Cent Plcmt Super | 0 | CPS Cent Plcmt Super | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E10:G10
11000-CPS Comm Initiative Splist | 0 | CPS Comm Initiative Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E11:G11
11000-CPS Crt Relations Splist | 0 | CPS Crt Relations Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E12:G12
11000-CPS Cswrkr V Legal Suppt | 0 | CPS Cswrkr V Legal Suppt | 11000 | 5 | 5 | 5 | 15 | 15 | 15 | 5 | 5 | 5 |  |  |  |  |  |  |  | [NAME]:G13
14000-CPS Cswrkr V Legal Suppt | -0.5 | CPS Cswrkr V Legal Suppt | 14000 | 2 | 2 | 1 | 5 | 4.5 | 4 | 2 | 1 | 1 |  |  |  |  |  |  |  | E14:G14
11005-CPS CVS Cswrkr | 5.364999999999981 | CPS CVS Cswrkr | 11005 | 357.1 | 369.47 | 367.83 | 1094.4 | 1099.765 | 1105.13 | 378 | 367.83 | 367.83 |  |  |  |  |  |  |  | E15:[NAME]
11005-CPS CVS Supv | 0.620000000000001 | CPS CVS Supv | 11005 | 58.76 | 60.47 | 60 | 179.23 | 179.85 | 180.47 | 63 | 60 | 60 |  |  |  |  |  |  |  | E16:G16
11005-CPS CVS Unit [NAME] | 1.5 | CPS CVS Unit [NAME] | 11005 | 59 | 62 | 62 | 183 | 184.5 | 186 | 63 | 62 | 62 |  |  |  |  |  |  |  | E17:G17
11005-CPS CVS Unit HST | 2 | CPS CVS Unit HST | 11005 | 59 | 63 | 63 | 185 | 187 | 189 | 63 | 63 | 63 |  |  |  |  |  |  |  | E18:G18
11000-CPS DayCare Coord | 0.5 | CPS [NAME] | 11000 | 1 | 1 | 2 | 4 | 4.5 | 5 | 2 | 2 | 2 |  |  |  |  |  |  |  | E19:G19
13300-CPS Deputy [NAME] | 0 | CPS Deputy [NAME] | 13300 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E20:G20
11000-CPS Deputy [NAME] Admin Supp | 0 | CPS Deputy [NAME] Admin Supp | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E21:G21
11000-CPS Disability Splist | 0 | CPS Disability Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E22:G22
11000-CPS Education Splist | 0 | CPS Education Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E23:G23
11012-CPS FAD Cswrkr | 0.07000000000000028 | CPS FAD Cswrkr | 11012 | 36 | 36 | 36.14 | 108.14 | 108.21 | 108.28 | 43 | 36.14 | 36.14 |  |  |  |  |  |  |  | E24:[NAME]
11012-CPS FAD Recruiter | 0 | CPS FAD Recruiter | 11012 | 2 | 2 | 2 | 6 | 6 | 6 | 3 | 2 | 2 |  |  |  |  |  |  |  | E25:G25
11012-CPS FAD Supv | 0.04999999999999982 | CPS FAD Supv | 11012 | 6 | 6 | 6.1 | 18.1 | 18.15 | 18.2 | 7 | 6.1 | 6.1 |  |  |  |  |  |  |  | E26:G26
11012-CPS FAD Unit [NAME] | -0.74 | CPS FAD Unit [NAME] | 11012 | 6.48 | 5 | 5 | 16.48 | 15.74 | 15 | 6 | 5 | 5 |  |  |  |  |  |  |  | E27:G27
19000-CPS FBSS Casewrkr, SFI | 0.31 | CPS FBSS Casewrkr, SFI | 19000 | 11.38 | 11.93 | 12 | 35.31 | 35.62 | 35.93000000000001 | 12 | 12 | 12 |  |  |  |  |  |  |  | E28:G28
11006-CPS FBSS Cswrkr | 1.43 | CPS FBSS Cswrkr | 11006 | 109.38 | 113.83 | 112.24 | 335.45 | 336.88 | 338.31 | 114 | 112.24 | 112.24 |  |  |  |  |  |  |  | E29:G29
14000-CPS FBSS Cswrkr | 0 | CPS FBSS Cswrkr | 14000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E30:G30
25000-CPS FBSS Cswrkr | 0.2399999999999984 | CPS FBSS Cswrkr | 25000 | 42.52 | 43 | 43 | 128.52 | 128.76 | 129 | 43 | 43 | 43 |  |  |  |  |  |  |  | E31:G31
11006-CPS FBSS Supv | 0.535 | CPS FBSS Supv | 11006 | 20.38 | 21 | 21.45 | 62.83 | 63.36499999999999 | 63.89999999999999 | 22 | 21.45 | 21.45 |  |  |  |  |  |  |  | E32:G32
25000-CPS FBSS Supv | -0.535 | CPS FBSS Supv | 25000 | 6 | 6 | 4.93 | 16.93 | 16.395 | 15.86 | 6 | 4.93 | 4.93 |  |  |  |  |  |  |  | E33:G33
11006-CPS FBSS Unit [NAME] | 1 | CPS FBSS Unit [NAME] | 11006 | 19 | 21 | 21 | 61 | 62 | 63 | 22 | 21 | 21 |  |  |  |  |  |  |  | E34:G34
25000-CPS FBSS Unit [NAME] | 0 | CPS FBSS Unit [NAME] | 25000 | 5 | 6 | 5 | 16 | 16 | 16 | 6 | 5 | 5 |  |  |  |  |  |  |  | E35:G35
11006-CPS FBSS Unit HST | 0 | CPS FBSS Unit HST | 11006 | 22 | 22 | 22 | 66 | 66 | 66 | 22 | 22 | 22 |  |  |  |  |  |  |  | E36:G36
25000-CPS FBSS Unit HST | 0 | CPS FBSS Unit HST | 25000 | 6 | 6 | 6 | 18 | 18 | 18 | 6 | 6 | 6 |  |  |  |  |  |  |  | E37:G37
11007-CPS FGC | 1.155 | CPS FGC | 11007 | 24 | 24 | 26.31 | 74.31 | 75.465 | 76.62 | 35 | 26.31 | 26.31 |  |  |  |  |  |  |  | E38:G38
11007-CPS FGDM Splist | -0.395 | CPS FGDM Splist | 11007 | 4 | 4 | 3.21 | 11.21 | 10.815 | 10.42 | 4 | 3.21 | 3.21 |  |  |  |  |  |  |  | E39:G39
11500-CPS Foster Care Eligibility | 0 | CPS Foster Care Eligibility | 11500 | 18 | 18 | 18 | 54 | 54 | 54 | 19 | 18 | 18 |  |  |  |  |  |  |  | E40:G40
11000-CPS I See You Admin Suppt | 0 | CPS I See You Admin Suppt | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E41:G41
11000-CPS I See You Cswrkr | 0.5 | CPS I See You Cswrkr | 11000 | 14 | 14.53 | 15 | 43.53 | 44.03 | 44.53 | 16 | 15 | 15 |  |  |  |  |  |  |  | E42:G42
11000-CPS I See You Supv | 0 | CPS I See You Supv | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E43:[NAME]
11000-CPS Intense Adopt Supp Splist | 0 | CPS Intense Adopt Supp Splist | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E44:G44
11008-CPS INV Cswrkr | 4.860000000000014 | CPS INV Cswrkr | 11008 | 317.76 | 327.47 | 327.48 | 972.71 | 977.57 | 982.4300000000001 | 336 | 327.48 | 327.48 |  |  |  |  |  |  |  | E45:G45
11000-CPS INV Peer Trainer | 0 | CPS INV [NAME] | 11000 | 10 | 10 | 10 | 30 | 30 | 30 | 12 | 10 | 10 |  |  |  |  |  |  |  | E46:G46
11000-CPS INV Risk Mgr | 0 | CPS INV Risk Mgr | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E47:G47
11008-CPS INV Supv | -0.2100000000000009 | CPS INV Supv | 11008 | 54.21 | 53.93 | 53.79 | 161.93 | 161.72 | 161.51 | 56 | 53.79 | 53.79 |  |  |  |  |  |  |  | E48:G48
11008-CPS INV Unit [NAME] | 0.5 | CPS INV Unit [NAME] | 11008 | 53 | 54.3 | 54 | 161.3 | 161.8 | 162.3 | 56 | 54 | 54 |  |  |  |  |  |  |  | E49:G49
11008-CPS INV Unit HST | 0.74 | CPS INV Unit HST | 11008 | 26.52 | 28 | 28 | 82.52 | 83.25999999999999 | 83.99999999999999 | 28 | 28 | 28 |  |  |  |  |  |  |  | E50:G50
11009-CPS KIN Cswrkr | -1.5 | CPS KIN Cswrkr | 11009 | 33 | 31.47 | 30 | 94.47 | 92.97 | 91.47 | 35 | 30 | 30 |  |  |  |  |  |  |  | E51:G51
11009-CPS KIN Supv | 0 | [NAME] | 11009 | 4 | 4 | 4 | 12 | 12 | 12 | 4 | 4 | 4 |  |  |  |  |  |  |  | [NAME]:G52
11009-CPS KIN Unit [NAME] | 0.5 | CPS KIN Unit [NAME] | 11009 | 3 | 2 | 4 | 9 | 9.5 | 10 | 4 | 4 | 4 |  |  |  |  |  |  |  | E53:G53
11000-CPS Law Enforcement Lia | 0 | CPS Law Enforcement Lia | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E54:G54
11000-CPS Legal Secretary | 0 | CPS Legal Secretary | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E55:G55
11000-CPS Legal Supv | 0 | CPS Legal Supv | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | [NAME]:G56
11000-CPS Nurse | 0 | CPS Nurse | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E57:G57
11000-CPS OJT Supv | 0.275 | CPS OJT Supv | 11000 | 5 | 5 | 5.55 | 15.55 | 15.825 | 16.1 | 6 | 5.55 | 5.55 |  |  |  |  |  |  |  | E58:G58
11000-CPS PA Admin Suppt | 0 | CPS PA Admin Suppt | 11000 | 6 | 6 | 6 | 18 | 18 | 18 | 5 | 6 | 6 | Exceeds |  |  |  |  |  |  | E59:G59
13300-CPS PA, CVS | 0 | CPS PA, CVS | 13300 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E60:G60
13300-CPS PA, FBSS | 0 | CPS PA, FBSS | 13300 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E61:G61
13300-CPS PA, Inv | 0 | CPS PA, Inv | 13300 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E62:G62
11000-CPS PAL Admin Suppt | 0 | CPS PAL Admin Suppt | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | E63:G63
11100-CPS PAL Cswrkr | 0 | CPS PAL Cswrkr | 11100 | 9 | 9 | 9 | 27 | 27 | 27 | 12 | 9 | 9 |  |  |  |  |  |  |  | E64:G64
11100-CPS PAL Supv | 0 | CPS PAL Supv | 11100 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E65:G65
11005-CPS PD [NAME], CVS | 2.5 | CPS PD [NAME], CVS | 11005 |  | 5 | 5 | 10 | 12.5 | 15 | 0 | 5 | 5 | Exceeds |  |  |  |  |  |  | [NAME]:G66
11000-CPS PD [NAME], FAD | 0 | CPS PD [NAME], FAD | 11000 |  | 1 |  | 1 | 1 | 1 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | E67:G67
11012-CPS PD [NAME], FAD | 0.5 | CPS PD [NAME], FAD | 11012 |  |  | 1 | 1 | 1.5 | 2 | 0 | 1 | 1 | Exceeds |  |  |  |  |  |  | E68:G68
11006-CPS PD [NAME], FBSS | 0.5 | CPS PD [NAME], FBSS | 11006 |  | 1 | 1 | 2 | 2.5 | 3 | 0 | 1 | 1 | Exceeds |  |  |  |  |  |  | E69:G69
11008-CPS PD [NAME], INV | 2.5 | CPS PD [NAME], INV | 11008 |  | 5 | 5 | 10 | 12.5 | 15 | 0 | 5 | 5 | Exceeds |  |  |  |  |  |  | E70:[NAME]
11009-CPS PD [NAME], KIN | 0 | CPS PD [NAME], KIN | 11009 | 1 | 1 | 1 | 3 | 3 | 3 | 0 | 1 | 1 | Exceeds |  |  |  |  |  |  | E71:G71
11005-CPS PD, CVS | 0 | CPS PD, CVS | 11005 | 10 | 10 | 10 | 30 | 30 | 30 | 11 | 10 | 10 |  |  |  |  |  |  |  | E72:G72
11012-CPS PD, FAD | 0 | CPS PD, FAD | 11012 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E73:G73
11006-CPS PD, FBSS | 0 | CPS PD, FBSS | 11006 | 5 | 5 | 5 | 15 | 15 | 15 | 5 | 5 | 5 |  |  |  |  |  |  |  | E74:G74
11008-CPS PD, Inv | 0 | CPS PD, Inv | 11008 | 11 | 11 | 11 | 33 | 33 | 33 | 11 | 11 | 11 |  |  |  |  |  |  |  | E75:G75
11009-CPS PD, KIN | 0 | CPS PD, KIN | 11009 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E76:G76
11008-CPS PD, [NAME] | 0.57 | CPS PD, [NAME] | 11008 | 1.86 | 3 | 3 | 7.86 | 8.43 | 9 | 3 | 3 | 3 |  |  |  |  |  |  |  | E77:G77
11000-CPS Rainbow Room Coord | 0 | [NAME] | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E78:G78
13300-CPS Reg Dir | 0 | CPS Reg Dir | 13300 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E79:G79
13300-CPS Reg Dir Admin Supp | 0 | CPS Reg Dir Admin Supp | 13300 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E80:G80
11000-CPS Reg Dir Asst | 0 | CPS Reg Dir Asst | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E81:G81
11000-CPS Resource/Ext Rel Splist | 0 | CPS Resource/Ext Rel Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E82:G82
13300-CPS ROSA | 0 | CPS ROSA | 13300 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E83:G83
11000-CPS ROSA [NAME] | 0 | CPS ROSA [NAME] | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E84:G84
11000-CPS SPA Admin Suppt | 0 | CPS SPA Admin Suppt | 11000 | 3 | 3 | 3 | 9 | 9 | 9 | 3 | 3 | 3 |  |  |  |  |  |  |  | [NAME]:G85
11000-CPS Spl Immigrant [NAME] | 0 | CPS Spl Immigrant Juvenile Spc | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E86:G86
11008-CPS Spl INV | 0.535 | CPS Spl INV | 11008 | 19.14 | 20.7 | 20.21 | 60.05 | 60.585 | 61.12 | 44 | 20.21 | 20.21 |  |  |  |  |  |  |  | E87:G87
11000-CPS SSI Coor Supp Secur Elig | 0 | CPS SSI Coor Supp Secur Elig | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E88:G88
11000-CPS Substance Abuse Splist | 0 | CPS Substance Abuse Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E89:G89
13300-CPS Svc PA | 0 | [NAME] | 13300 | 3 | 3 | 3 | 9 | 9 | 9 | 3 | 3 | 3 |  |  |  |  |  |  |  | E90:G90
11000-CPS Switchboard Operator | 0 | CPS Switchboard Operator | 11000 | 2 | 2 | 2 | 6 | 6 | 6 | 2 | 2 | 2 |  |  |  |  |  |  |  | E91:G91
11000-CPS Youth Splist | 0 | CPS Youth Splist | 11000 | 1 | 1 | 1 | 3 | 3 | 3 | 1 | 1 | 1 |  |  |  |  |  |  |  | E92:G92
#N/A | -3.515 | #N/A | 11008 | 8.03 | 4.07 | 1 | 13.1 | 9.584999999999999 | 6.069999999999999 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | E93:G93
-Grand Total | 21.86 | Grand Total |  | 1538.52 | 1588.17 | 1582.24 | 4708.93 | 4730.79 | 4752.65 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  | E94:G94