Spreadsheet: 99019d1297803489-conditional-formatting-based-on-existing-formatting-book1
Sheet: Sheet1

 |  |  |  | Data
 | Div Director | Prog&Name | LBB Name&Acct | Sum of  Budgeted | Sum of Expensed | Sum of Encumbered | Sum of PreEncumbered | Sum of Unobligated | # of letters in Column D
 | [NAME] | Assumption/Fake Care Training-11300 | Consumable Supplies-L2003 | 2877 | 0 |  |  | 2877 | 24
 |  |  | Rent-Building-Budget Only-L2006 | 750 | 0 |  |  | 750 | 30 | Example of calculated column
 |  | CAPTA-Disproportionality Project-FFY09-87075 | Other Operating Exp-L2009 | 40000 | 9423.8 |  |  | 30576.2 | 23
 |  |  | Other Personnel Costs-L1002 | 160 | 9423.8 |  |  | -9263.8 | 25
 |  |  | Personnel (S & W)-L1001 | 24379 | 9423.8 |  |  | 14955.2 | 20
 |  |  | Travel In-State-L2005 | 3500 | 9423.8 |  |  | -5923.8 | 20
 |  | Chimp Protective Services Program Support-13000 | Client Services-L3001 | 2032.13 | 131749.56 |  |  | -129717.43 | 20
 |  |  | Consumable Supplies-L2003 | 21226.29 | 131749.56 |  |  | -110523.27 | 24
 |  |  | Other Operating Exp-L2009 | 66145.92383233533 | 131749.56 |  |  | -65603.63616766466 | 23
 |  |  | Other Personnel Costs-L1002 | 10271.67523007826 | 131749.56 |  |  | -121477.8847699217 | 25
 |  |  | Personnel (S & W)-L1001 | 419765.963498899 | 131749.56 |  |  | 288016.403498899 | 20
 |  |  | Professional Fees&Svc-L2001 | 94077.9 | 131749.56 |  |  | -37671.66 | 26
 |  |  | Rent  Machine & Other-L2007 | 6075.26 | 131749.56 |  |  | -125674.3 | 23
 |  |  | Rent-Building-Budget Only-L2006 | 5325.8 | 131749.56 |  |  | -126423.76 | 30
 |  |  | Travel In-State-L2005 | 9468.577232956934 | 131749.56 |  |  | -122280.9827670431 | 20
 |  |  | Travel Out-of-State-Budget Onl-L2005A | 884 | 131749.56 |  |  | -130865.56 | 35
 |  | Chimp Welfare Projects-20000 | Professional Fees&Svc-L2001 | 98414 | 0 |  |  | 98414 | 26
 |  | Direct Delivery Services Staff-Other-11000 | Consumable Supplies-L2003 | 30199.9 | 0 |  |  | 30199.9 | 24
 |  |  | Professional Fees&Svc-L2001 | 16062 | 0 |  |  | 16062 | 26
 |  |  | Rent  Machine & Other-L2007 | 122 | 0 |  |  | 122 | 23
 |  |  | Rent-Building-Budget Only-L2006 | 559.66 | 0 |  |  | 559.66 | 30
 |  | Education & Training Voucher Administration-11600 | Consumable Supplies-L2003 | 239 | 0 |  |  | 239 | 24
 |  | Fake Care Redesign Project-FFY-87088 | Professional Fees&Svc-L2001 | 54805 | 0 |  |  | 54805 | 26
 |  | Innovations-Eval of Legislative Initiatives Project-FFY 09-87077 | Professional Fees&Svc-L2001 | 20000 | 0 |  |  | 20000 | 26
 |  | Prep for Independent Living Admin (IV-E-IL)-11100 | Consumable Supplies-L2003 | 376 | 0 |  |  | 376 | 24
 | [NAME] |  |  | 927717.0797942696 | 1355190.8 |  |  | -427473.7202057306 | 617 | Need this cell to turn the same color as the line to the left of it and sum the section above
 | Minnie | Chin-Wiping Services for Wards of the State-21400 | Client Services-L3001 | 71518 | 0 |  |  | 71518 | 20
 |  | CAPTA-Educational & Developmental Disabilities-FFY09-87076 | Other Personnel Costs-L1002 | 13280 | 141265.31 |  |  | -127985.31 | 25
 |  |  | Personnel (S & W)-L1001 | 425869 | 141265.31 |  |  | 284603.69 | 20
 |  |  | Travel In-State-L2005 | 0 | 141265.31 |  |  | -141265.31 | 20
 |  | CAPTA-Mafia Group Decision Making FFY09-87072 | Other Personnel Costs-L1002 | 6960 | 83199.44 |  |  | -76239.44 | 25
 |  |  | Personnel (S & W)-L1001 | 249598 | 83199.44 |  |  | 166398.56 | 20
 |  |  | Travel In-State-L2005 | 0 | 83199.44 |  |  | -83199.44 | 20
 |  | Chimp Protective Services Program Support-13000 | Other Operating Exp-L2009 | 16536.48095808383 | 49754.31 |  |  | -33217.82904191616 | 23
 |  |  | Other Personnel Costs-L1002 | 1797.543165263695 | 49754.31 |  |  | -47956.7668347363 | 25
 |  |  | Personnel (S & W)-L1001 | 140043.2619732582 | 49754.31 |  |  | 90288.95197325817 | 20
 |  |  | Travel In-State-L2005 | 6916.746576783685 | 49754.31 |  |  | -42837.56342321631 | 20
 |  | Disproportionality Staff-11010 | Other Personnel Costs-L1002 | 800 | 17531.12 |  |  | -16731.12 | 25
 |  |  | Personnel (S & W)-L1001 | 37445.36 | 17531.12 |  |  | 19914.24 | 20
 |  |  | Travel In-State-L2005 | 0 | 17531.12 |  |  | -17531.12 | 20
 |  | Tele-Medicine Assessments-21500 | Professional Fees&Svc-L2001 | 3000815.6 | 0 |  |  | 3000815.6 | 26
 |  | Innovations-Chimps with Disabilities-FFY09-87074 | Other Personnel Costs-L1002 | 13440 | 135760.4 |  |  | -122320.4 | 25
 |  |  | Personnel (S & W)-L1001 | 407281.2 | 135760.4 |  |  | 271520.8 | 20
 |  |  | Travel In-State-L2005 | 782.2737644240709 | 135760.4 |  |  | -134978.1262355759 | 20
 |  | Non-IV-E Fake Chimp Care Day Care-22200 | Client Services-L3001 | 2097859 | 0 |  |  | 2097859 | 20
 |  | Relative Caregiver Day Care Services-22500 | Client Services-L3001 | 8948405 | 0 |  |  | 8948405 | 20
 |  | Title IV-E Fake Chimp Care Day Care-22100 | Client Services-L3001 | 6292922 | 0 |  |  | 6292922 | 20
 |  | TWC Protective Day Care  Services-22000 | Client Services-L3001 | 16940173 | 0 |  |  | 16940173 | 20
 | Minnie Total |  |  | 38672442.46643782 | 1332286.05 |  |  | 37340156.41643781 | 0
 | [NAME] | Chimp Protective Services Program Support-13000 | Other Operating Exp-L2009 | 190169.5310179641 | 432507.6 |  |  | -242338.0689820359 | 23
 |  |  | Other Personnel Costs-L1002 | 34153.3201400102 | 432507.6 |  |  | -398354.2798599898 | 25
 |  |  | Personnel (S & W)-L1001 | 1197678.739136416 | 432507.6 |  |  | 765171.139136416 | 20
 |  |  | Travel In-State-L2005 | 27478.95756553334 | 432507.6 |  |  | -405028.6424344666 | 20
 |  | Chimp Welfare Projects-20000 | Client Services-L3001 | 1318191 | 0 |  |  | 1318191 | 20
 |  | Direct Delivery Services Staff-Other-11000 | Other Operating Exp-L2009 | 145631.8858878505 | 543366.02 |  |  | -397734.1341121495 | 23
 |  |  | Other Personnel Costs-L1002 | 63303.45381526105 | 543366.02 |  |  | -480062.566184739 | 25
 |  |  | Personnel (S & W)-L1001 | 1628019.426540727 | 543366.02 |  |  | 1084653.406540727 | 20
 |  |  | Travel In-State-L2005 | 118953.1988428157 | 543366.02 |  |  | -424412.8211571843 | 20
 |  | Regional Program Admin & Support-13300 | Other Operating Exp-L2009 | 1500 | 96658.8 |  |  | -95158.8 | 23
 |  |  | Other Personnel Costs-L1002 | 10080 | 96658.8 |  |  | -86578.8 | 25
 |  |  | Personnel (S & W)-L1001 | 289976.14 | 96658.8 |  |  | 193317.34 | 20
 |  | Post-Assumption Services Administration-13400 | Other Operating Exp-L2009 | 245 | 15683 |  |  | -15438 | 23
 |  |  | Other Personnel Costs-L1002 | 960 | 15683 |  |  | -14723 | 25
 |  |  | Personnel (S & W)-L1001 | 47049 | 15683 |  |  | 31366 | 20
 |  |  | Travel In-State-L2005 | 1275 | 15683 |  |  | -14408 | 20
 |  | NY Punks Probation Comm. Fake Care Staff-27201 | Other Personnel Costs-L1002 | 1200 | 21936.36 |  |  | -20736.36 | 25
 |  |  | Personnel (S & W)-L1001 | 65809 | 21936.36 |  |  | 43872.64 | 20
 |  |  | Travel In-State-L2005 | 0 | 21936.36 |  |  | -21936.36 | 20
 |  | NY Punks Comm. Fake Care Staff-27001 | Other Personnel Costs-L1002 | 1200 | 12807.64 |  |  | -11607.64 | 25
 |  |  | Personnel (S & W)-L1001 | 38423 | 12807.64 |  |  | 25615.36 | 20
 | Daniel Total |  |  | 5181296.652946577 | 4347627.24 |  |  | 833669.4129465783 | 0
 | [NAME] | CAPTA-Best Practices Testing Centers-FFY09-87071 | Other Personnel Costs-L1002 | 1200 | 49267.52 |  |  | -48067.52 | 25
 |  |  | Personnel (S & W)-L1001 | 147802.56 | 49267.52 |  |  | 98535.04 | 20
 |  |  | Travel In-State-L2005 | 4722.707371174259 | 49267.52 |  |  | -44544.81262882574 | 20
 |  | CAPTA-Guard Collaboration-FFY 10-87083 | Professional Fees&Svc-L2001 | 12958 | 0 |  |  | 12958 | 26
 |  | CAPTA-Guard Collaboration-FFY 11-87083 | Other Operating Exp-L2009 | 30913 | 0 |  |  | 30913 | 23
 |  | CASA En. Training via Fakeing Conn.-11301 | Professional Fees&Svc-L2001 | 72362.25 | 0 |  |  | 72362.25 | 26
 |  | Certified Projects (IV-E-IL)-20600 | Client Services-L3001 | 185428 | 0 |  |  | 185428 | 20
 |  | Chimp Protective Services Program Support-13000 | Other Operating Exp-L2009 | 99218.885748503 | 209391.16 |  |  | -110172.274251497 | 23
 |  |  | Other Personnel Costs-L1002 | 20351.0133414733 | 209391.16 |  |  | -189040.1466585267 | 25
 |  |  | Personnel (S & W)-L1001 | 614252.3511920702 | 209391.16 |  |  | 404861.1911920701 | 20
 |  |  | Travel In-State-L2005 | 21416.79207595823 | 209391.16 |  |  | -187974.3679240418 | 20
 |  | FGDM-11007 | Other Operating Exp-L2009 | 1115.69 | 0 |  |  | 1115.69 | 23
 |  | Kinship Staff-11009 | Other Operating Exp-L2009 | 11349.36 | 0 |  |  | 11349.36 | 23
 |  | Regional Program Admin & Support-13300 | Travel In-State-L2005 | 22610 | 0 |  |  | 22610 | 20
 |  | Education & Training Voucher Administration-11600 | Other Operating Exp-L2009 | 227064.3 | 13296.11 |  |  | 213768.19 | 23
 |  |  | Personnel (S & W)-L1001 | 39578.88 | 13296.11 |  |  | 26282.77 | 20
 |  |  | Professional Fees&Svc-L2001 | 17456 | 13296.11 |  |  | 4159.89 | 26
 |  |  | Travel In-State-L2005 | 2576.87 | 13296.11 |  |  | -10719.24 | 20
 |  | Enhanced CVS Visitation Project-11900 | Other Operating Exp-L2009 | 270000 | 0 |  |  | 270000 | 23
 |  |  | Personnel (S & W)-L1001 | 802390 | 0 |  |  | 802390 | 20
 |  |  | Professional Fees&Svc-L2001 | 800000 | 0 |  |  | 800000 | 26
 |  |  | Travel In-State-L2005 | 850000 | 0 |  |  | 850000 | 20
 |  | Innovations-Chimps with Disabilities-FFY09-87074 | Personnel (S & W)-L1001 | 46731 | 15577 |  |  | 31154 | 20
 |  |  | Travel In-State-L2005 | 217.726235575929 | 15577 |  |  | -15359.27376442407 | 20
 |  | PAL ETV Program-20900 | Client Services-L3001 | 2534319 | 0 |  |  | 2534319 | 20
 |  | Prep for Independent Living Admin (IV-E-IL)-11100 | Other Operating Exp-L2009 | 1200 | 37540.08 |  |  | -36340.08 | 23
 |  |  | Personnel (S & W)-L1001 | 115740 | 37540.08 |  |  | 78199.92 | 20
 |  |  | Professional Fees&Svc-L2001 | 500 | 37540.08 |  |  | -37040.08 | 26
 |  |  | Travel In-State-L2005 | 3885.42 | 37540.08 |  |  | -33654.66 | 20
 |  | Unaccompanied Refugee Minor Program-80000 | Client Services-L3001 | 5884426.65 | 16467.12 |  |  | 5867959.53 | 20
 |  |  | Other Operating Exp-L2009 | 7077 | 16467.12 |  |  | -9390.12 | 23
 |  |  | Other Personnel Costs-L1002 | 1200 | 16467.12 |  |  | -15267.12 | 25
 |  |  | Personnel (S & W)-L1001 | 49401.00599999999 | 16467.12 |  |  | 32933.886 | 20
 |  |  | Professional Fees&Svc-L2001 | 75000 | 16467.12 |  |  | 58532.88 | 26
 |  |  | Rent  Machine & Other-L2007 | 3000 | 16467.12 |  |  | -13467.12 | 23
 |  |  | Travel In-State-L2005 | 21158 | 16467.12 |  |  | 4690.88 | 20
 |  |  | Utilities-Budget Only-L2004 | 1224 | 16467.12 |  |  | -15243.12 | 26
 | [NAME] |  |  | 12999846.46196475 | 1351602.92 |  |  | 11648243.54196476 | 0
 | [NAME] | Assumption/Fake Care Training-11300 | Other Operating Exp-L2009 | 10821.66 | 31819.6 |  |  | -20997.94 | 23
 |  |  | Other Personnel Costs-L1002 | 5760 | 31819.6 |  |  | -26059.6 | 25
 |  |  | Personnel (S & W)-L1001 | 95458.8 | 31819.6 |  |  | 63639.2 | 20
 |  |  | Professional Fees&Svc-L2001 | 300 | 31819.6 |  |  | -31519.6 | 26
 |  |  | Travel In-State-L2005 | 26924.04 | 31819.6 |  |  | -4895.56 | 20
 |  | Chimp Protective Services Program Support-13000 | Other Operating Exp-L2009 | 140560.0881437126 | 230198.96 |  |  | -89638.87185628741 | 23
 |  |  | Other Personnel Costs-L1002 | 16948.26412962912 | 230198.96 |  |  | -213250.6958703709 | 25
 |  |  | Personnel (S & W)-L1001 | 842816.2092012393 | 230198.96 |  |  | 612617.2492012393 | 20
 |  |  | Travel In-State-L2005 | 11843.55662565596 | 230198.96 |  |  | -218355.403374344 | 20
 |  | Direct Delivery Services Staff-Other-11000 | Other Operating Exp-L2009 | 59039.95373831776 | 226244.48 |  |  | -167204.5262616822 | 23
 |  |  | Other Personnel Costs-L1002 | 20621.5796519411 | 226244.48 |  |  | -205622.9003480589 | 25
 |  |  | Personnel (S & W)-L1001 | 661684.2536955469 | 226244.48 |  |  | 435439.7736955469 | 20
 |  |  | Travel In-State-L2005 | 14588.86817489342 | 226244.48 |  |  | -211655.6118251066 | 20
 |  | Purchased [NAME] | Client Services-L3001 | 6995506 | 0 |  |  | 6995506 | 20
 | Gail Total |  |  | 8902873.273360936 | 1984871.76 |  |  | 6918001.513360936 | 0
 | [NAME] | CAPTA-Best Practices Testing Centers-FFY09-87071 | Other Personnel Costs-L1002 | 240 | 15683 |  |  | -15443 | 25
 |  |  | Personnel (S & W)-L1001 | 47049 | 15683 |  |  | 31366 | 20
 |  |  | Travel In-State-L2005 | 2662.29262882574 | 15683 |  |  | -13020.70737117426 | 20
 |  | Chimp Protective Services Program Support-13000 | Other Operating Exp-L2009 | 173633.0500598802 | 372927.2 |  |  | -199294.1499401198 | 23
 |  |  | Other Personnel Costs-L1002 | 37748.40647053759 | 372927.2 |  |  | -335178.7935294624 | 25
 |  |  | Personnel (S & W)-L1001 | 1080659.955176768 | 372927.2 |  |  | 707732.7551767679 | 20
 |  |  | Travel In-State-L2005 | 27847.43792311189 | 372927.2 |  |  | -345079.7620768881 | 20
 |  | Direct Delivery Services Staff-Other-11000 | Other Operating Exp-L2009 | 216479.8303738318 | 909518.43 |  |  | -693038.5996261683 | 23
 |  |  | Other Personnel Costs-L1002 | 95194.96653279784 | 909518.43 |  |  | -814323.4634672021 | 25
 |  |  | Personnel (S & W)-L1001 | 2735941.597763726 | 909518.43 |  |  | 1826423.167763726 | 20
 |  |  | Travel In-State-L2005 | 174408.9429822909 | 909518.43 |  |  | -735109.4870177092 | 20
 |  | Investigative Staff Stipends-11003 | Other Operating Exp-L2009 | 270000 | 0 |  |  | 270000 | 23
 |  | Regional Screeners-11002 | Other Operating Exp-L2009 | 790.02 | 751128.68 |  |  | -750338.66 | 23
 |  |  | Other Personnel Costs-L1002 | 79520 | 751128.68 |  |  | -671608.68 | 25
 |  |  | Personnel (S & W)-L1001 | 2266408.72 | 751128.68 |  |  | 1515280.04 | 20
 |  |  | Travel In-State-L2005 | 0 | 751128.68 |  |  | -751128.68 | 20
 | [NAME] |  |  | 7208584.219911769 | 8181346.239999998 |  |  | -972762.0200882306 | 0
 | Grand Total |  |  | 73892760.15441613 | 18552925.01 |  |  | 55339835.14441615 | 0