Spreadsheet: 85994d1285961757-formulas-for-shifting-targets-example
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
11000-2010 CPS Realignmnt Floater | 0 | 2010 CPS Realignmnt Floater | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | #N/A | #N/A | #N/A | #N/A | No formulas |  |  | #N/A | #N/A | #N/A
11008-2010 CPS Realignmnt Floater | 0 | 2010 CPS Realignmnt Floater | 11008 | 3 | 3 | 3 | 9 | 3 | 3 | #N/A | #N/A | #N/A | #N/A | 1 |  | [NAME] | #N/A | #N/A | #N/A
11000-CPS Accountant/Bookkeeper | 0 | CPS Accountant/Bookkeeper | 11000 | 4 | 4 | 4 | 12 | 4 | 4 | 5 | 4 | 4 |  | 3 |  | [NAME] | 7 | 4 | Exceeds
11000-CPS Cent Plcmt [NAME] | 0 | CPS Cent Plcmt [NAME] | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 1 | 2 | 2 | Exceeds | 10 |  | [NAME] | 12 | 2 | Exceeds
11000-CPS Cent Plcmt Casewrkr | 0 | CPS Cent Plcmt Casewrkr | 11000 | 6 | 6 | 6 | 18 | 6 | 6 | 11 | 6 | 6
11000-CPS Cent Plcmt Super | 0 | CPS Cent Plcmt Super | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Comm Initiative Splist | 0 | CPS Comm Initiative Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Crt Relations Splist | 0 | CPS Crt Relations Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Cswrkr V Legal Suppt | 0 | CPS Cswrkr V Legal Suppt | 11000 | 5 | 5 | 5 | 15 | 5 | 5 | 5 | 5 | 5
14000-CPS Cswrkr V Legal Suppt | -0.5 | CPS Cswrkr V Legal Suppt | 14000 | 2 | 2 | 1 | 5 | 1 | 1 | 2 | 1 | 1
11005-CPS CVS Cswrkr | 5.364999999999981 | CPS CVS Cswrkr | 11005 | 357.1 | 369.47 | 367.83 | 1094.4 | 367.83 | 367.83 | 378 | 367.83 | 367.83
11005-CPS CVS Supv | 0.620000000000001 | CPS CVS Supv | 11005 | 58.76 | 60.47 | 60 | 179.23 | 60 | 60 | 63 | 60 | 60
11005-CPS CVS Unit [NAME] | 1.5 | CPS CVS Unit [NAME] | 11005 | 59 | 62 | 62 | 183 | 62 | 62 | 63 | 62 | 62
11005-CPS CVS Unit HST | 2 | CPS CVS Unit HST | 11005 | 59 | 63 | 63 | 185 | 63 | 63 | 63 | 63 | 63
11000-CPS DayCare Coord | 0.5 | CPS [NAME] | 11000 | 1 | 1 | 2 | 4 | 2 | 2 | 2 | 2 | 2
13300-CPS Deputy [NAME] | 0 | CPS Deputy [NAME] | 13300 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Deputy [NAME] Admin Supp | 0 | CPS Deputy [NAME] Admin Supp | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Disability Splist | 0 | CPS Disability Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Education Splist | 0 | CPS Education Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11012-CPS FAD Cswrkr | 0.07000000000000028 | CPS FAD Cswrkr | 11012 | 36 | 36 | 36.14 | 108.14 | 36.14 | 36.14 | 43 | 36.14 | 36.14
11012-CPS FAD Recruiter | 0 | CPS FAD Recruiter | 11012 | 2 | 2 | 2 | 6 | 2 | 2 | 3 | 2 | 2
11012-CPS FAD Supv | 0.04999999999999982 | CPS FAD Supv | 11012 | 6 | 6 | 6.1 | 18.1 | 6.1 | 6.1 | 7 | 6.1 | 6.1
11012-CPS FAD Unit [NAME] | -0.74 | CPS FAD Unit [NAME] | 11012 | 6.48 | 5 | 5 | 16.48 | 5 | 5 | 6 | 5 | 5
19000-CPS FBSS Casewrkr, SFI | 0.31 | CPS FBSS Casewrkr, SFI | 19000 | 11.38 | 11.93 | 12 | 35.31 | 12 | 12 | 12 | 12 | 12
11006-CPS FBSS Cswrkr | 1.43 | CPS FBSS Cswrkr | 11006 | 109.38 | 113.83 | 112.24 | 335.45 | 112.24 | 112.24 | 114 | 112.24 | 112.24
14000-CPS FBSS Cswrkr | 0 | CPS FBSS Cswrkr | 14000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
25000-CPS FBSS Cswrkr | 0.2399999999999984 | CPS FBSS Cswrkr | 25000 | 42.52 | 43 | 43 | 128.52 | 43 | 43 | 43 | 43 | 43
11006-CPS FBSS Supv | 0.535 | CPS FBSS Supv | 11006 | 20.38 | 21 | 21.45 | 62.83 | 21.45 | 21.45 | 22 | 21.45 | 21.45
25000-CPS FBSS Supv | -0.535 | CPS FBSS Supv | 25000 | 6 | 6 | 4.93 | 16.93 | 4.93 | 4.93 | 6 | 4.93 | 4.93
11006-CPS FBSS Unit [NAME] | 1 | CPS FBSS Unit [NAME] | 11006 | 19 | 21 | 21 | 61 | 21 | 21 | 22 | 21 | 21
25000-CPS FBSS Unit [NAME] | 0 | CPS FBSS Unit [NAME] | 25000 | 5 | 6 | 5 | 16 | 5 | 5 | 6 | 5 | 5
11006-CPS FBSS Unit HST | 0 | CPS FBSS Unit HST | 11006 | 22 | 22 | 22 | 66 | 22 | 22 | 22 | 22 | 22
25000-CPS FBSS Unit HST | 0 | CPS FBSS Unit HST | 25000 | 6 | 6 | 6 | 18 | 6 | 6 | 6 | 6 | 6
11007-CPS FGC | 1.155 | CPS FGC | 11007 | 24 | 24 | 26.31 | 74.31 | 26.31 | 26.31 | 35 | 26.31 | 26.31
11007-CPS FGDM Splist | -0.395 | CPS FGDM Splist | 11007 | 4 | 4 | 3.21 | 11.21 | 3.21 | 3.21 | 4 | 3.21 | 3.21
11500-CPS Foster Care Eligibility | 0 | CPS Foster Care Eligibility | 11500 | 18 | 18 | 18 | 54 | 18 | 18 | 19 | 18 | 18
11000-CPS I See You Admin Suppt | 0 | CPS I See You Admin Suppt | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS I See You Cswrkr | 0.5 | CPS I See You Cswrkr | 11000 | 14 | 14.53 | 15 | 43.53 | 15 | 15 | 16 | 15 | 15
11000-CPS I See You Supv | 0 | CPS I See You Supv | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS Intense Adopt Supp Splist | 0 | CPS Intense Adopt Supp Splist | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11008-CPS INV Cswrkr | 4.860000000000014 | CPS INV Cswrkr | 11008 | 317.76 | 327.47 | 327.48 | 972.71 | 327.48 | 327.48 | 336 | 327.48 | 327.48
11000-CPS INV Peer Trainer | 0 | CPS INV [NAME] | 11000 | 10 | 10 | 10 | 30 | 10 | 10 | 12 | 10 | 10
11000-CPS INV Risk Mgr | 0 | CPS INV Risk Mgr | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11008-CPS INV Supv | -0.2100000000000009 | CPS INV Supv | 11008 | 54.21 | 53.93 | 53.79 | 161.93 | 53.79 | 53.79 | 56 | 53.79 | 53.79
11008-CPS INV Unit [NAME] | 0.5 | CPS INV Unit [NAME] | 11008 | 53 | 54.3 | 54 | 161.3 | 54 | 54 | 56 | 54 | 54
11008-CPS INV Unit HST | 0.74 | CPS INV Unit HST | 11008 | 26.52 | 28 | 28 | 82.52 | 28 | 28 | 28 | 28 | 28
11009-CPS KIN Cswrkr | -1.5 | CPS KIN Cswrkr | 11009 | 33 | 31.47 | 30 | 94.47 | 30 | 30 | 35 | 30 | 30
11009-CPS KIN Supv | 0 | [NAME] | 11009 | 4 | 4 | 4 | 12 | 4 | 4 | 4 | 4 | 4
11009-CPS KIN Unit [NAME] | 0.5 | CPS KIN Unit [NAME] | 11009 | 3 | 2 | 4 | 9 | 4 | 4 | 4 | 4 | 4
11000-CPS Law Enforcement Lia | 0 | CPS Law Enforcement Lia | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Legal Secretary | 0 | CPS Legal Secretary | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Legal Supv | 0 | CPS Legal Supv | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Nurse | 0 | CPS Nurse | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS OJT Supv | 0.275 | CPS OJT Supv | 11000 | 5 | 5 | 5.55 | 15.55 | 5.55 | 5.55 | 6 | 5.55 | 5.55
11000-CPS PA Admin Suppt | 0 | CPS PA Admin Suppt | 11000 | 6 | 6 | 6 | 18 | 6 | 6 | 5 | 6 | 6 | Exceeds
13300-CPS PA, CVS | 0 | CPS PA, CVS | 13300 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
13300-CPS PA, FBSS | 0 | CPS PA, FBSS | 13300 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
13300-CPS PA, Inv | 0 | CPS PA, Inv | 13300 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS PAL Admin Suppt | 0 | CPS PAL Admin Suppt | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | #N/A | #N/A | #N/A | #N/A
11100-CPS PAL Cswrkr | 0 | CPS PAL Cswrkr | 11100 | 9 | 9 | 9 | 27 | 9 | 9 | 12 | 9 | 9
11100-CPS PAL Supv | 0 | CPS PAL Supv | 11100 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11005-CPS PD [NAME], CVS | 2.5 | CPS PD [NAME], CVS | 11005 |  | 5 | 5 | 10 | 5 | 5 | 0 | 5 | 5 | Exceeds
11000-CPS PD [NAME], FAD | 0 | CPS PD [NAME], FAD | 11000 |  | 1 |  | 1 | 0 | 0 | #N/A | #N/A | #N/A | #N/A
11012-CPS PD [NAME], FAD | 0.5 | CPS PD [NAME], FAD | 11012 |  |  | 1 | 1 | 1 | 1 | 0 | 1 | 1 | Exceeds
11006-CPS PD [NAME], FBSS | 0.5 | CPS PD [NAME], FBSS | 11006 |  | 1 | 1 | 2 | 1 | 1 | 0 | 1 | 1 | Exceeds
11008-CPS PD [NAME], INV | 2.5 | CPS PD [NAME], INV | 11008 |  | 5 | 5 | 10 | 5 | 5 | 0 | 5 | 5 | Exceeds
11009-CPS PD [NAME], KIN | 0 | CPS PD [NAME], KIN | 11009 | 1 | 1 | 1 | 3 | 1 | 1 | 0 | 1 | 1 | Exceeds
11005-CPS PD, CVS | 0 | CPS PD, CVS | 11005 | 10 | 10 | 10 | 30 | 10 | 10 | 11 | 10 | 10
11012-CPS PD, FAD | 0 | CPS PD, FAD | 11012 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11006-CPS PD, FBSS | 0 | CPS PD, FBSS | 11006 | 5 | 5 | 5 | 15 | 5 | 5 | 5 | 5 | 5
11008-CPS PD, Inv | 0 | CPS PD, Inv | 11008 | 11 | 11 | 11 | 33 | 11 | 11 | 11 | 11 | 11
11009-CPS PD, KIN | 0 | CPS PD, KIN | 11009 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11008-CPS PD, [NAME] | 0.57 | CPS PD, [NAME] | 11008 | 1.86 | 3 | 3 | 7.86 | 3 | 3 | 3 | 3 | 3
11000-CPS Rainbow Room Coord | 0 | [NAME] | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
13300-CPS Reg Dir | 0 | CPS Reg Dir | 13300 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
13300-CPS Reg Dir Admin Supp | 0 | CPS Reg Dir Admin Supp | 13300 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS Reg Dir Asst | 0 | CPS Reg Dir Asst | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS Resource/Ext Rel Splist | 0 | CPS Resource/Ext Rel Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
13300-CPS ROSA | 0 | CPS ROSA | 13300 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS ROSA [NAME] | 0 | CPS ROSA [NAME] | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11000-CPS SPA Admin Suppt | 0 | CPS SPA Admin Suppt | 11000 | 3 | 3 | 3 | 9 | 3 | 3 | 3 | 3 | 3
11000-CPS Spl Immigrant [NAME] | 0 | CPS Spl Immigrant Juvenile Spc | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
11008-CPS Spl INV | 0.535 | CPS Spl INV | 11008 | 19.14 | 20.7 | 20.21 | 60.05 | 20.21 | 20.21 | 44 | 20.21 | 20.21
11000-CPS SSI Coor Supp Secur Elig | 0 | CPS SSI Coor Supp Secur Elig | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS Substance Abuse Splist | 0 | CPS Substance Abuse Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
13300-CPS Svc PA | 0 | [NAME] | 13300 | 3 | 3 | 3 | 9 | 3 | 3 | 3 | 3 | 3
11000-CPS Switchboard Operator | 0 | CPS Switchboard Operator | 11000 | 2 | 2 | 2 | 6 | 2 | 2 | 2 | 2 | 2
11000-CPS Youth Splist | 0 | CPS Youth Splist | 11000 | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1
#N/A | -3.515 | #N/A | 11008 | 8.03 | 4.07 | 1 | 13.1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
-Grand Total | 21.86 | Grand Total |  | 1538.52 | 1588.17 | 1582.24 | 4708.93 | 1582.24 | 1582.24 | #N/A | #N/A | #N/A | #N/A