{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Current CN Bud Info","Req Chng Overall CN Bud","Req Chng Disb Fnds Realignment","Req Chng Auth Expend Spread","Final Bud Form Part II","Final Bud Form Part I","LOCCS Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Current CN Bud Info","index":1,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,3,4,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[0,1,0,6]]}
[null,"Current CN Budget Information  "]
[null,"Grant Number",null,"Date of Submission of this Budget Request"]
[null,"Grantee",null,"This Request is for Budget Revision Number"]
[null,"Devel. Name",null,"Date of Most Recent Prior HUD Approved Budget Revision"]
[null,"Prepared by:",null,"HUD Grant Manager:"]
[null,"Line No.","Summary by Budget Line Item","Budget Line Item","Current Overall\nCN Budget \nfor All Project Phases","Current Disbursed\nAmount shown in LOCCS","Current Authorized (Spread)\nAmount in LOCCS"]
[null,1,"Supportive Services",1405,0,0,0]
[null,2,"Management Improvements",1408,0,0,0]
[null,3,"Evaluation",1409,0,0,0]
[null,4,"Administration",1410,0,0,0]
[null,5,"Fees and Costs",1430,0,0,0]
[null,6,"Site Acquisition",1440,0,0,0]
[null,7,"Site Improvement",1450,0,0,0]
[null,8,"Dwelling Structures",1460,0,0,0]
[null,9,"Dwelling Equipment-Nonexpendable",1465,0,0,0]
[null,10,"Nondwelling Structures",1470,0,0,0]
[null,11,"Nondwelling Equipment",1475,0,0,0]
[null,12,"Critical Community Improvements",1480,0,0,0]
[null,13,"Demolition",1485,0,0,0]
[null,14,"Relocation Costs",1495,0,0,0]
[null,15,"Relocation -  Non-residents",1496,0,0,0]
[null,16,"Total Funds Authorization ( Sum Of Lines 1-15)",null,null,null,{"$f":"SUM(G7:G21)","v":0}]
[null,17,"Funds held in Reserve","U2000",null,null,{"$f":"E24-G22","v":0}]
[null,18,"Amount of CN Grant ( Sum Of Lines 1-17)",null,{"$f":"SUM(E7:E21)","v":0},null,{"$f":"SUM(G22:G23)","v":0}]

{"sheet":"Req Chng Overall CN Bud","index":2,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[13,1,13,2],[1,1,1,5],[2,1,2,5],[0,1,0,5],[13,9,13,10],[0,9,0,12],[1,9,1,12],[2,9,2,12],[3,9,3,12],[4,9,4,12]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Requested Change in Overall Budget"]
[null,null,null,null,null,null,null,null,null," (table for HUD approval letter)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Re: Overall HOPE VI Budget Revision"]
[null,null,null,null,null,null,null,null,null,"HOPE VI Grant Num:",null,{"$f":"'Current CN Bud Info'!N2","v":0}]
[]
[]
[null,null,"Budget Line Item","Current Overall\nCN Budget","Amount Moved Between Budget Line Items","Revised Overall\nCN Budget",null,null,null,{"$f":"C17","v":"Budget Line Item"},{"$f":"D17","v":"Current Overall\nCN Budget"},{"$f":"E17","v":"Amount Moved Between Budget Line Items"},{"$f":"F17","v":"Revised Overall\nCN Budget"}]
[null,1,1405,{"$f":"'Current CN Bud Info'!E7","v":0},null,{"$f":"D18+E18","v":0},null,null,null,{"$f":"C18","v":1405},{"$f":"D18","v":0},{"$f":"E18","v":0},{"$f":"F18","v":0}]
[null,2,1408,{"$f":"'Current CN Bud Info'!E8","v":0},null,{"$f":"D19+E19","v":0},null,null,null,1408,0,0,0]
[null,3,1409,{"$f":"'Current CN Bud Info'!E9","v":0},null,{"$f":"D20+E20","v":0},null,null,null,1409,0,0,0]
[null,4,1410,{"$f":"'Current CN Bud Info'!E10","v":0},null,{"$f":"D21+E21","v":0},null,null,null,1410,0,0,0]
[null,5,1430,{"$f":"'Current CN Bud Info'!E11","v":0},null,0,null,null,null,1430,0,0,0]
[null,6,1440,{"$f":"'Current CN Bud Info'!E12","v":0},null,0,null,null,null,1440,0,0,0]
[null,7,1450,{"$f":"'Current CN Bud Info'!E13","v":0},null,0,null,null,null,1450,0,0,0]
[null,8,1460,{"$f":"'Current CN Bud Info'!E14","v":0},null,0,null,null,null,1460,0,0,0]
[null,9,1465,{"$f":"'Current CN Bud Info'!E15","v":0},null,0,null,null,null,1465,0,0,0]
[null,10,1470,{"$f":"'Current CN Bud Info'!E16","v":0},null,0,null,null,null,1470,0,0,0]
[null,11,1475,{"$f":"'Current CN Bud Info'!E17","v":0},null,0,null,null,null,1475,0,0,0]
[null,12,1480,{"$f":"'Current CN Bud Info'!E18","v":0},null,{"$f":"D29+E29","v":0},null,null,null,{"$f":"C29","v":1480},0,0,0]
[null,13,1485,{"$f":"'Current CN Bud Info'!E19","v":0},null,{"$f":"D30+E30","v":0},null,null,null,1485,0,0,0]
[null,14,1495,{"$f":"'Current CN Bud Info'!E20","v":0},null,{"$f":"D31+E31","v":0},null,null,null,1495,0,0,0]
[null,15,1496,{"$f":"'Current CN Bud Info'!E21","v":0},0,{"$f":"D32+E32","v":0},null,null,null,1496,0,0,0]
[null,null,"Amount of CN Grant",{"$f":"SUM(D18:D32)","v":0},{"$f":"SUM(E18:E32)","v":0},{"$f":"SUM(F18:F32)","v":0},"Total changes must equal zero.",null,null,"Amount of CN Grant",0,0,0]

{"sheet":"Req Chng Disb Fnds Realignment","index":3,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[13,13,13,14],[0,1,0,4],[1,1,1,4],[2,1,2,4],[13,1,13,2],[0,13,0,16],[1,13,1,16],[2,13,2,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LOCCS REALIGNMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Request to Realign Distributions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-10-25"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Memorandum For:  OPHI LOCCS Administrator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"From: ",{"$f":"'Current CN Bud Info'!$G$5","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Re: Realignment of Distributions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"       CN Grant Number:",null,{"$f":"'Current CN Bud Info'!C2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget Revision Num:",{"$f":"'Current CN Bud Info'!G3","v":0}]
[]
[]
[]
[null,"BLI","Current LOCCS\nExpenditures","Increase / Decrease","Revised LOCCS\nExpenditures","Is a Spread Increase Needed?",null,null,null,null,null,null,null,"BLI","Current LOCCS\nExpenditures","Increase/Decrease","Revised LOCCS\nExpenditures"]
[null,1405,{"$f":"'Current CN Bud Info'!F7","v":0},null,{"$f":"D20+C20","v":0},{"$f":"IF(D20=\"\",\"\",IF(E20<0,\"Must be At Leaset Zero Dollars\",IF(E20>'Current CN Bud Info'!G7,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,{"$f":"B20","v":1405},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0}]
[null,1408,{"$f":"'Current CN Bud Info'!F8","v":0},null,{"$f":"D21+C21","v":0},{"$f":"IF(D21=\"\",\"\",IF(E21<0,\"Must be At Leaset Zero Dollars\",IF(E21>'Current CN Bud Info'!G8,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,{"$f":"B21","v":1408},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0}]
[null,1409,{"$f":"'Current CN Bud Info'!F9","v":0},null,{"$f":"D22+C22","v":0},{"$f":"IF(D22=\"\",\"\",IF(E22<0,\"Must be At Leaset Zero Dollars\",IF(E22>'Current CN Bud Info'!G9,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,{"$f":"B22","v":1409},{"$f":"C22","v":0},{"$f":"D22","v":0},{"$f":"E22","v":0}]
[null,1410,{"$f":"'Current CN Bud Info'!F10","v":0},null,{"$f":"D23+C23","v":0},{"$f":"IF(D23=\"\",\"\",IF(E23<0,\"Must be At Leaset Zero Dollars\",IF(E23>'Current CN Bud Info'!G10,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1410,0,0,0]
[null,1430,{"$f":"'Current CN Bud Info'!F11","v":0},null,0,{"$f":"IF(D24=\"\",\"\",IF(E24<0,\"Must be At Leaset Zero Dollars\",IF(E24>'Current CN Bud Info'!G11,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1430,0,0,0]
[null,1440,{"$f":"'Current CN Bud Info'!F12","v":0},null,0,{"$f":"IF(D25=\"\",\"\",IF(E25<0,\"Must be At Leaset Zero Dollars\",IF(E25>'Current CN Bud Info'!G12,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1440,0,0,0]
[null,1450,{"$f":"'Current CN Bud Info'!F13","v":0},null,0,{"$f":"IF(D26=\"\",\"\",IF(E26<0,\"Must be At Leaset Zero Dollars\",IF(E26>'Current CN Bud Info'!G13,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1450,0,0,0]
[null,1460,{"$f":"'Current CN Bud Info'!F14","v":0},null,0,{"$f":"IF(D27=\"\",\"\",IF(E27<0,\"Must be At Leaset Zero Dollars\",IF(E27>'Current CN Bud Info'!G14,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1460,0,0,0]
[null,1465,{"$f":"'Current CN Bud Info'!F15","v":0},null,0,{"$f":"IF(D28=\"\",\"\",IF(E28<0,\"Must be At Leaset Zero Dollars\",IF(E28>'Current CN Bud Info'!G15,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1465,0,0,0]
[null,1470,{"$f":"'Current CN Bud Info'!F16","v":0},null,0,{"$f":"IF(D29=\"\",\"\",IF(E29<0,\"Must be At Leaset Zero Dollars\",IF(E29>'Current CN Bud Info'!G16,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1470,0,0,0]
[null,1475,{"$f":"'Current CN Bud Info'!F17","v":0},null,0,{"$f":"IF(D30=\"\",\"\",IF(E30<0,\"Must be At Leaset Zero Dollars\",IF(E30>'Current CN Bud Info'!G17,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1475,0,0,0]
[null,1480,{"$f":"'Current CN Bud Info'!F18","v":0},null,{"$f":"D31+C31","v":0},{"$f":"IF(D31=\"\",\"\",IF(E31<0,\"Must be At Leaset Zero Dollars\",IF(E31>'Current CN Bud Info'!G18,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,{"$f":"B31","v":1480},{"$f":"C31","v":0},{"$f":"D31","v":0},{"$f":"E31","v":0}]
[null,1485,{"$f":"'Current CN Bud Info'!F19","v":0},null,0,{"$f":"IF(D32=\"\",\"\",IF(E32<0,\"Must be At Leaset Zero Dollars\",IF(E32>'Current CN Bud Info'!G19,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1485,0,0,0]
[null,1495,{"$f":"'Current CN Bud Info'!F20","v":0},null,{"$f":"D33+C33","v":0},{"$f":"IF(D33=\"\",\"\",IF(E33<0,\"Must be At Leaset Zero Dollars\",IF(E33>'Current CN Bud Info'!G20,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,{"$f":"B33","v":1495},{"$f":"C33","v":0},{"$f":"D33","v":0},{"$f":"E33","v":0}]
[null,1496,{"$f":"'Current CN Bud Info'!F21","v":0},null,0,{"$f":"IF(D34=\"\",\"\",IF(E34<0,\"Must be At Leaset Zero Dollars\",IF(E34>'Current CN Bud Info'!G21,\"Spread Increase IS Needed!\",\"NOT Needed.\")))","v":""},null,null,null,null,null,null,null,1496,0,0,0]
[null,"BLI Totals",{"$f":"SUM(C20:C34)","v":0},{"$f":"SUM(D20:D34)","v":0},{"$f":"SUM(E20:E34)","v":0},{"$f":"IF(D35=0,\"\",IF(D35=0,\"OK\",\"Net Change in Expenditures Must Be Zero\"))","v":""},null,null,null,null,null,null,null,"BLI Totals",0,0,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"HUD Approval:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Choice Neighborhoods Director",null,"date"]

{"sheet":"Req Chng Auth Expend Spread","index":4,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BLI","Requested\nOverall CN Budget","Current Spread","Increase / Decrease\nin Spread","Revised Spread","Does your spread cover your disbursements?\nIs it within your budget?",null,null,null,"BLI","Approved\nOverall CN Budget","Current Spread","Increase/Decrease\nin Spread","Revised Spread"]
[null,1405,{"$f":"'Req Chng Overall CN Bud'!F18","v":0},{"$f":"'Current CN Bud Info'!G7","v":0},0,{"$f":"D18+E18","v":0},{"$f":"IF(F18<'Req Chng Disb Fnds Realignment'!E20,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F18>C18,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,{"$f":"B18","v":1405},{"$f":"C18","v":0},{"$f":"D18","v":0},{"$f":"E18","v":0},{"$f":"F18","v":0}]
[null,1408,{"$f":"'Req Chng Overall CN Bud'!F19","v":0},{"$f":"'Current CN Bud Info'!G8","v":0},0,{"$f":"D19+E19","v":0},{"$f":"IF(F19<'Req Chng Disb Fnds Realignment'!E21,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F19>C19,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,{"$f":"B19","v":1408},{"$f":"C19","v":0},{"$f":"D19","v":0},{"$f":"E19","v":0},{"$f":"F19","v":0}]
[null,1409,{"$f":"'Req Chng Overall CN Bud'!F20","v":0},{"$f":"'Current CN Bud Info'!G9","v":0},0,{"$f":"D20+E20","v":0},{"$f":"IF(F20<'Req Chng Disb Fnds Realignment'!E22,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F20>C20,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,{"$f":"B20","v":1409},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0},{"$f":"F20","v":0}]
[null,1410,{"$f":"'Req Chng Overall CN Bud'!F21","v":0},{"$f":"'Current CN Bud Info'!G10","v":0},0,{"$f":"D21+E21","v":0},{"$f":"IF(F21<'Req Chng Disb Fnds Realignment'!E23,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F21>C21,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,{"$f":"B21","v":1410},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":0},{"$f":"F21","v":0}]
[null,1430,{"$f":"'Req Chng Overall CN Bud'!F22","v":0},{"$f":"'Current CN Bud Info'!G11","v":0},0,0,{"$f":"IF(F22<'Req Chng Disb Fnds Realignment'!E24,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F22>C22,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1430,0,0,0,0]
[null,1440,{"$f":"'Req Chng Overall CN Bud'!F23","v":0},{"$f":"'Current CN Bud Info'!G12","v":0},0,0,{"$f":"IF(F23<'Req Chng Disb Fnds Realignment'!E25,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F23>C23,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1440,0,0,0,0]
[null,1450,{"$f":"'Req Chng Overall CN Bud'!F24","v":0},{"$f":"'Current CN Bud Info'!G13","v":0},0,0,{"$f":"IF(F24<'Req Chng Disb Fnds Realignment'!E26,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F24>C24,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1450,0,0,0,0]
[null,1460,{"$f":"'Req Chng Overall CN Bud'!F25","v":0},{"$f":"'Current CN Bud Info'!G14","v":0},0,0,{"$f":"IF(F25<'Req Chng Disb Fnds Realignment'!E27,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F25>C25,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1460,0,0,0,0]
[null,1465,{"$f":"'Req Chng Overall CN Bud'!F26","v":0},{"$f":"'Current CN Bud Info'!G15","v":0},0,0,{"$f":"IF(F26<'Req Chng Disb Fnds Realignment'!E28,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F26>C26,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1465,0,0,0,0]
[null,1470,{"$f":"'Req Chng Overall CN Bud'!F27","v":0},{"$f":"'Current CN Bud Info'!G16","v":0},0,0,{"$f":"IF(F27<'Req Chng Disb Fnds Realignment'!E29,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F27>C27,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1470,0,0,0,0]
[null,1475,{"$f":"'Req Chng Overall CN Bud'!F28","v":0},{"$f":"'Current CN Bud Info'!G17","v":0},0,0,{"$f":"IF(F28<'Req Chng Disb Fnds Realignment'!E30,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F28>C28,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1475,0,0,0,0]
[null,1480,{"$f":"'Req Chng Overall CN Bud'!F29","v":0},{"$f":"'Current CN Bud Info'!G18","v":0},0,{"$f":"D29+E29","v":0},{"$f":"IF(F29<'Req Chng Disb Fnds Realignment'!E31,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F29>C29,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1480,0,0,0,0]
[null,1485,{"$f":"'Req Chng Overall CN Bud'!F30","v":0},{"$f":"'Current CN Bud Info'!G19","v":0},0,0,{"$f":"IF(F30<'Req Chng Disb Fnds Realignment'!E32,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F30>C30,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1485,0,0,0,0]
[null,1495,{"$f":"'Req Chng Overall CN Bud'!F31","v":0},{"$f":"'Current CN Bud Info'!G20","v":0},0,{"$f":"D31+E31","v":0},{"$f":"IF(F31<'Req Chng Disb Fnds Realignment'!E33,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F31>C31,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1495,0,0,0,0]
[null,1496,{"$f":"'Req Chng Overall CN Bud'!F32","v":0},{"$f":"'Current CN Bud Info'!G21","v":0},0,0,{"$f":"IF(F32<'Req Chng Disb Fnds Realignment'!E34,\"Your Spread does not cover your Disbursements! Spread Increase Needed!\",(IF(F32>C32,\"  Your BLI Budget Does NOT Cover Your Spread! Budget Update Needed.\",\"\")))","v":""},null,null,null,1496,0,0,0,0]
[null,"BLI Totals",{"$f":"SUM(C18:C32)","v":0},{"$f":"SUM(D18:D32)","v":0},{"$f":"SUM(E18:E32)","v":0},{"$f":"SUM(F18:F32)","v":0},null,null,null,null,"BLI Totals",0,0,0,0]
[null,"U2000",null,{"$f":"$C33-D33","v":0},{"$f":"-E33","v":0},{"$f":"D34+E34","v":0},null,null,null,null,"U2000",0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]
[]
[]
[]
[null," "]
[]
[null," "]

{"sheet":"Final Bud Form Part II","index":5,"n_rows":276,"n_cols":20,"rows_kept":276,"cut":false,"hidden":false,"merged":[[268,0,269,0],[206,0,207,0],[224,0,225,0],[238,0,239,0],[253,0,254,0],[191,0,192,0],[176,0,177,0],[19,0,20,0],[34,0,35,0],[49,0,50,0],[69,0,70,0],[116,0,117,0],[131,0,132,0],[146,0,147,0],[161,0,162,0],[1,6,1,7],[2,6,2,7],[1,4,1,5],[2,4,2,5],[7,1,7,4],[1,1,1,3],[2,1,2,3],[24,1,24,4],[39,1,39,4],[181,1,181,4],[54,1,54,4],[258,1,258,4],[196,1,196,4],[211,1,211,4],[229,1,229,4],[243,1,243,4]]}
[]
[null,{"$f":"CONCATENATE(\"GRANTEE:  \",'Current CN Bud Info'!C3)","v":"GRANTEE:  "},null,null,"Budget Revision Number",null,"Grant Number"]
[null,{"$f":"CONCATENATE(\"Development Name:  \",'Current CN Bud Info'!C4)","v":"Development Name:  "},null,null,{"$f":"'Current CN Bud Info'!G3","v":0},null,{"$f":"'Current CN Bud Info'!$C$2","v":0}]
[]
["Budget Line Item Number","Description of Proposed/Approved Action\nUse of Additional Authorized Funds","Current Overall CN Budget","Requested Change in Overall CN Budget","Requested Change in Disbursed Funds (Realignment)","Current Authorized Amount \n(Current Spread)","Requested Change in Amount Authorized for Expenditure (Change in Spread)","Total Funds to be Authorized for Expenditure\n(New Spread)"]
[1,2,3,4,5,6,7,8]
[]
[1405,"SUPPORTIVE SERVICES",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G9+F9","v":0},null,null,null,null,null,null,null,{"$f":"C9+D9","v":0},{"$f":"P9-H9","v":0}]
[null,null,null,null,null,null,null,{"$f":"G10+F10","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G11+F11","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D9:D19)","v":0},{"$f":"SUM(E9:E19)","v":0},null,{"$f":"SUM(G9:G19)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G20=0,\"0\",G20)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C9:C19)=D22,D22,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E7","v":0},{"$f":"'Current CN Bud Info'!F7","v":0},{"$f":"IF(SUM(F9:F19)<>G22,\"Amounts?\",G22)","v":0},{"$f":"'Current CN Bud Info'!G7","v":0},{"$f":"F22","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D20+D22='Req Chng Overall CN Bud'!F18,D20+D22,\"Check Numbers\")","v":0},{"$f":"IF(E20+E22='Req Chng Disb Fnds Realignment'!E20,E20+E22,\"Check Numbers\")","v":0},null,{"$f":"IF(G20+G22='Req Chng Auth Expend Spread'!F18,G20+G22,\"Check Amounts\")","v":0},{"$f":"H21+H22","v":0}]
[]
[1408,"MANAGEMENT IMPROVEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G26+F26","v":0},null,null,null,null,null,null,null,{"$f":"C26+D26","v":0},{"$f":"P26-H26","v":0}]
[null,null,null,null,null,null,null,{"$f":"G27+F27","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:E34)","v":0},null,{"$f":"SUM(G26:G34)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G35=0,\"0\",G35)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C26:C34)=D37,D37,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E8","v":0},{"$f":"'Current CN Bud Info'!F8","v":0},{"$f":"IF(SUM(F26:F34)<>G37,\"Amounts?\",G37)","v":0},{"$f":"'Current CN Bud Info'!G8","v":0},{"$f":"F37","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D35+D37='Req Chng Overall CN Bud'!F19,D35+D37,\"Check Numbers\")","v":0},{"$f":"IF(E35+E37='Req Chng Disb Fnds Realignment'!E21,E35+E37,\"Check Numbers\")","v":0},null,{"$f":"IF(G35+G37='Req Chng Auth Expend Spread'!F19,G35+G37,\"Check Amounts\")","v":0},{"$f":"H36+H37","v":0}]
[]
[1409,"EVALUATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G41+F41","v":0},null,null,null,null,null,null,null,{"$f":"C41+D41","v":0},{"$f":"P41-H41","v":0}]
[null,null,null,null,null,null,null,{"$f":"G42+F42","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D41:D49)","v":0},{"$f":"SUM(E41:E49)","v":0},null,{"$f":"SUM(G41:G49)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G50=0,\"0\",G50)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C41:C49)=D52,D52,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E9","v":0},{"$f":"'Current CN Bud Info'!F9","v":0},{"$f":"IF(SUM(F41:F49)<>G52,\"Amounts?\",G52)","v":0},{"$f":"'Current CN Bud Info'!G9","v":0},{"$f":"F52","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D50+D52='Req Chng Overall CN Bud'!F20,D50+D52,\"Check Numbers\")","v":0},{"$f":"IF(E50+E52='Req Chng Disb Fnds Realignment'!E22,E50+E52,\"Check Numbers\")","v":0},null,{"$f":"IF(G50+G52='Req Chng Auth Expend Spread'!F20,G50+G52,\"Check Amounts\")","v":0},{"$f":"H51+H52","v":0}]
[]
[1410,"ADMINISTRATION",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G56+F56","v":0},null,null,null,null,null,null,null,{"$f":"C56+D56","v":0},{"$f":"P56-H56","v":0}]
[null,null,null,null,null,null,null,{"$f":"G57+F57","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G58+F58","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null," ",null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D56:D69)","v":0},{"$f":"SUM(E56:E69)","v":0},null,{"$f":"SUM(G56:G69)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G70=0,\"0\",G70)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C56:C69)=D72,D72,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E10","v":0},{"$f":"'Current CN Bud Info'!F10","v":0},{"$f":"IF(SUM(F56:F69)<>G72,\"Amounts?\",G72)","v":0},{"$f":"'Current CN Bud Info'!G10","v":0},{"$f":"F72","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D70+D72='Req Chng Overall CN Bud'!F21,D70+D72,\"Check Numbers\")","v":0},{"$f":"IF(E70+E72='Req Chng Disb Fnds Realignment'!E23,E70+E72,\"Check Numbers\")","v":0},null,{"$f":"IF(G70+G72='Req Chng Auth Expend Spread'!F21,G70+G72,\"Check Amounts\")","v":0},{"$f":"H71+H72","v":0}]
[]
[1430,"FEES and COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G76+F76","v":0},null,null,null,null,null,null,null,{"$f":"C76+D76","v":0},{"$f":"P76-H76","v":0}]
[null,null,null,null,null,null,null,{"$f":"G77+F77","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G79+F79","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G87+F87","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G94+F94","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G102+F102","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G110+F110","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G111+F111","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G112+F112","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D76:D116)","v":0},{"$f":"SUM(E76:E116)","v":0},null,{"$f":"SUM(G76:G116)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G117=0,\"0\",G117)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C76:C116)=D119,D119,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E11","v":0},{"$f":"'Current CN Bud Info'!F11","v":0},{"$f":"IF(SUM(F76:F116)<>G119,\"Amounts?\",G119)","v":0},{"$f":"'Current CN Bud Info'!G11","v":0},{"$f":"F119","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D117+D119='Req Chng Overall CN Bud'!F22,D117+D119,\"Check Numbers\")","v":0},{"$f":"IF(E117+E119='Req Chng Disb Fnds Realignment'!E24,E117+E119,\"Check Numbers\")","v":0},null,{"$f":"IF(G117+G119='Req Chng Auth Expend Spread'!F22,G117+G119,\"Check Numbers\")","v":0},{"$f":"H118+H119","v":0}]
[]
[1440,"SITE ACQUISITION",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G123+F123","v":0},null,null,null,null,null,null,null,{"$f":"C123+D123","v":0},{"$f":"P123-H123","v":0}]
[null,null,null,null,null,null,null,{"$f":"G124+F124","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D123:D131)","v":0},{"$f":"SUM(E123:E131)","v":0},null,{"$f":"SUM(G123:G131)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G132=0,\"0\",G132)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C123:C131)=D134,D134,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E12","v":0},{"$f":"'Current CN Bud Info'!F12","v":0},{"$f":"IF(SUM(F123:F131)<>G134,\"Amounts?\",G134)","v":0},{"$f":"'Current CN Bud Info'!G12","v":0},{"$f":"F134","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D132+D134='Req Chng Overall CN Bud'!F23,D132+D134,\"Check Numbers\")","v":0},{"$f":"IF(E132+E134='Req Chng Disb Fnds Realignment'!E25,E132+E134,\"Check Numbers\")","v":0},null,{"$f":"IF(G132+G134='Req Chng Auth Expend Spread'!F23,G132+G134,\"Check Numbers\")","v":0},{"$f":"H133+H134","v":0}]
[]
[1450,"SITE IMPROVEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G138+F138","v":0},null,null,null,null,null,null,null,{"$f":"C138+D138","v":0},{"$f":"P138-H138","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G145+F145","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D138:D146)","v":0},{"$f":"SUM(E138:E146)","v":0},null,{"$f":"SUM(G138:G146)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G147=0,\"0\",G147)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C138:C146)=D149,D149,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E13","v":0},{"$f":"'Current CN Bud Info'!F13","v":0},{"$f":"IF(SUM(F138:F146)<>G149,\"Amounts?\",G149)","v":0},{"$f":"'Current CN Bud Info'!G13","v":0},{"$f":"F149","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D147+D149='Req Chng Overall CN Bud'!F24,D147+D149,\"Check Numbers\")","v":0},{"$f":"IF(E147+E149='Req Chng Disb Fnds Realignment'!E26,E147+E149,\"Check Numbers\")","v":0},null,{"$f":"IF(G147+G149='Req Chng Auth Expend Spread'!F24,G147+G149,\"Check Numbers\")","v":0},{"$f":"H148+H149","v":0}]
[]
[1460,"DWELLING STRUCTURES"]
[null,null,null,null,null,null,null,{"$f":"G153+F153","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"C153+D153","v":0},{"$f":"S153-H153","v":0}]
[null,null,null,null,null,null,null,{"$f":"G154+F154","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"C154+D154","v":0},{"$f":"S154-H154","v":0}]
[null,null,null,null,null,null,null,{"$f":"G155+F155","v":0},null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D153:D161)","v":0},{"$f":"SUM(E153:E161)","v":0},null,{"$f":"SUM(G153:G161)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G162=0,\"0\",G162)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C153:C161)=D164,D164,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E14","v":0},{"$f":"'Current CN Bud Info'!F14","v":0},{"$f":"IF(SUM(F153:F161)<>G164,\"Amounts?\",G164)","v":0},{"$f":"'Current CN Bud Info'!G14","v":0},{"$f":"F164","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D162+D164='Req Chng Overall CN Bud'!F25,D162+D164,\"Check Numbers\")","v":0},{"$f":"IF(E162+E164='Req Chng Disb Fnds Realignment'!E27,E162+E164,\"Check Numbers\")","v":0},null,{"$f":"IF(G162+G164='Req Chng Auth Expend Spread'!F25,G162+G164,\"Check Numbers\")","v":0},{"$f":"H163+H164","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[1465,"DWELLING EQUIPMENT-NONEXPENDABLE",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C167+D167","v":0},{"$f":"P167-H167","v":0}]
[null,null,null,null,null,null,null,{"$f":"G168+F168","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G169+F169","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G170+F170","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D168:D176)","v":0},{"$f":"SUM(E168:E176)","v":0},null,{"$f":"SUM(G168:G176)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G177=0,\"0\",G177)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C168:C176)=D179,D179,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E15","v":0},{"$f":"'Current CN Bud Info'!F15","v":0},{"$f":"IF(SUM(F168:F176)<>G179,\"Amounts?\",G179)","v":0},{"$f":"'Current CN Bud Info'!G15","v":0},{"$f":"F179","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D177+D179='Req Chng Overall CN Bud'!F26,D177+D179,\"Check Numbers\")","v":0},{"$f":"IF(E177+E179='Req Chng Disb Fnds Realignment'!E28,E177+E179,\"Check Numbers\")","v":0},null,{"$f":"IF(G177+G179='Req Chng Auth Expend Spread'!F26,G177+G179,\"Check Numbers\")","v":0},{"$f":"H178+H179","v":0}]
[]
[1470,"NONDWELLING STRUCTURES",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G183+F183","v":0},null,null,null,null,null,null,null,{"$f":"C183+D183","v":0},{"$f":"P183-H183","v":0}]
[null,null,null,null,null,null,null,{"$f":"G184+F184","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D183:D191)","v":0},{"$f":"SUM(E183:E191)","v":0},null,{"$f":"SUM(G183:G191)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G192=0,\"0\",G192)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C183:C191)=D194,D194,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E16","v":0},{"$f":"'Current CN Bud Info'!F16","v":0},{"$f":"IF(SUM(F183:F191)<>G194,\"Amounts?\",G194)","v":0},{"$f":"'Current CN Bud Info'!G16","v":0},{"$f":"F194","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D192+D194='Req Chng Overall CN Bud'!F27,D192+D194,\"Check Numbers\")","v":0},{"$f":"IF(E192+E194='Req Chng Disb Fnds Realignment'!E29,E192+E194,\"Check Numbers\")","v":0},null,{"$f":"IF(G192+G194='Req Chng Auth Expend Spread'!F27,G192+G194,\"Check Amounts\")","v":0},{"$f":"H193+H194","v":0}]
[]
[1475,"NONDWELLING EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G198+F198","v":0},null,null,null,null,null,null,null,{"$f":"C198+D198","v":0},{"$f":"P198-H198","v":0}]
[null,null,null,null,null,null,null,{"$f":"G199+F199","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D198:D206)","v":0},{"$f":"SUM(E198:E206)","v":0},null,{"$f":"SUM(G198:G206)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G207=0,\"0\",G207)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C198:C206)=D209,D209,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E17","v":0},{"$f":"'Current CN Bud Info'!F17","v":0},{"$f":"IF(SUM(F198:F206)<>G209,\"Amounts?\",G209)","v":0},{"$f":"'Current CN Bud Info'!G17","v":0},{"$f":"F209","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D207+D209='Req Chng Overall CN Bud'!F28,D207+D209,\"Check Numbers\")","v":0},{"$f":"IF(E207+E209='Req Chng Disb Fnds Realignment'!E30,E207+E209,\"Check Numbers\")","v":0},null,{"$f":"IF(G207+G209='Req Chng Auth Expend Spread'!F28,G207+G209,\"Check Amounts\")","v":0},{"$f":"H208+H209","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[1480,"CRITICAL COMMUNITY IMPROVEMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C212+D212","v":0},{"$f":"P212-H212","v":0}]
[null,null,null,null,null,null,null,{"$f":"G213+F213","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"G214+F214","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D213:D224)","v":0},{"$f":"SUM(E213:E224)","v":0},null,{"$f":"SUM(G213:G224)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G225=0,\"0\",G225)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C213:C224)=D227,D227,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E18","v":0},{"$f":"'Current CN Bud Info'!F18","v":0},{"$f":"IF(SUM(F213:F224)<>G227,\"Amounts?\",G227)","v":0},{"$f":"'Current CN Bud Info'!G18","v":0},{"$f":"F227","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D225+D227='Req Chng Overall CN Bud'!F29,D225+D227,\"Check Numbers\")","v":0},{"$f":"IF(E225+E227='Req Chng Disb Fnds Realignment'!E31,E225+E227,\"Check Numbers\")","v":0},null,{"$f":"IF(G225+G227='Req Chng Auth Expend Spread'!F29,G225+G227,\"Check Amounts\")","v":0},{"$f":"H226+H227","v":0}]
[]
[1485,"DEMOLITION",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G231+F231","v":0},null,null,null,null,null,null,null,{"$f":"C231+D231","v":0},{"$f":"P231-H231","v":0}]
[null,null,null,null,null,null,null,{"$f":"G232+F232","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D231:D238)","v":0},{"$f":"SUM(E231:E238)","v":0},null,{"$f":"SUM(G231:G238)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G239=0,\"0\",G239)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C231:C238)=D241,D241,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E19","v":0},{"$f":"'Current CN Bud Info'!F19","v":0},{"$f":"IF(SUM(F231:F238)<>G241,\"Amounts?\",G241)","v":0},{"$f":"'Current CN Bud Info'!G19","v":0},{"$f":"F241","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D239+D241='Req Chng Overall CN Bud'!F30,D239+D241,\"Check Numbers\")","v":0},{"$f":"IF(E239+E241='Req Chng Disb Fnds Realignment'!E32,E239+E241,\"Check Numbers\")","v":0},null,{"$f":"IF(G239+G241='Req Chng Auth Expend Spread'!F30,G239+G241,\"Check Amounts\")","v":0},{"$f":"H240+H241","v":0}]
[]
[1495,"RELOCATION COSTS - RESIDENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G245+F245","v":0},null,null,null,null,null,null,null,{"$f":"C245+D245","v":0},{"$f":"P245-H245","v":0}]
[null,null,null,null,null,null,null,{"$f":"G246+F246","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D245:D253)","v":0},{"$f":"SUM(E245:E253)","v":0},null,{"$f":"SUM(G245:G253)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G254=0,\"0\",G254)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C245:C253)=D256,D256,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E20","v":0},{"$f":"'Current CN Bud Info'!F20","v":0},{"$f":"IF(SUM(F245:F253)<>G256,\"Amounts?\",G256)","v":0},{"$f":"'Current CN Bud Info'!G20","v":0},{"$f":"F256","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D254+D256='Req Chng Overall CN Bud'!F31,D254+D256,\"Check Numbers\")","v":0},{"$f":"IF(E254+E256='Req Chng Disb Fnds Realignment'!E33,E254+E256,\"Check Numbers\")","v":0},null,{"$f":"IF(G254+G256='Req Chng Auth Expend Spread'!F31,G254+G256,\"Check Amounts\")","v":0},{"$f":"H255+H256","v":0}]
[]
[1496,"RELOCATION - NON RESIDENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"new total budget","diff betw new total budget and total spread"]
[null,null,null,null,null,null,null,{"$f":"G260+F260","v":0},null,null,null,null,null,null,null,{"$f":"C260+D260","v":0},{"$f":"P260-H260","v":0}]
[null,null,null,null,null,null,null,{"$f":"G261+F261","v":0},null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,0]
[null,"Total Changes",null,{"$f":"SUM(D260:D268)","v":0},{"$f":"SUM(E260:E268)","v":0},null,{"$f":"SUM(G260:G268)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(G269=0,\"0\",G269)","v":"0"}]
[null,"  Previous Approved Budget Totals ",{"$f":"IF(SUM(C260:C268)=D271,D271,\"Amount?\")","v":0},{"$f":"'Current CN Bud Info'!E21","v":0},{"$f":"'Current CN Bud Info'!F21","v":0},{"$f":"IF(SUM(F260:F268)<>G271,\"Amounts?\",G271)","v":0},{"$f":"'Current CN Bud Info'!G21","v":0},{"$f":"F271","v":0}]
[null,"NEW TOTALS FOR HUD APPROVAL",null,{"$f":"IF(D269+D271='Req Chng Overall CN Bud'!F32,D269+D271,\"Check Numbers\")","v":0},{"$f":"IF(E269+E271='Req Chng Disb Fnds Realignment'!E34,E269+E271,\"Check Numbers\")","v":0},null,{"$f":"IF(G269+G271='Req Chng Auth Expend Spread'!F32,G269+G271,\"Check Amounts\")","v":0},{"$f":"H270+H271","v":0}]
[]
[null,"Total Changes",null,{"$f":"SUM(D269+D254+D239+D225+D207+D192+D177+D162+D147+D132+D117+D70+D50+D35+D20)","v":0},{"$f":"IF(SUM(E269,E254,E239,E225,E207,E192,E177,E162,E147,E132,E117,E70,E50,E35,E20)=0,0,\"Check Amounts\")","v":0},null,{"$f":"SUM(G269,G254,G239,G225,G207,G192,G177,G162,G147,G132,G117,G70,G50,G35,G20)","v":0},{"$f":"SUM(H270,H255,H240,H226,H208,H193,H178,H163,H148,H133,H118,H71,H51,H36,H21)","v":0}]
[null,"  Previous Approved Budget Totals ",null,{"$f":"SUM(D271,D256,D241,D227,D209,D194,D179,D164,D149,D134,D119,D72,D52,D37,D22)","v":0},{"$f":"SUM(E271,E256,E241,E227,E209,E194,E179,E164,E149,E134,E119,E72,E52,E37,E22)","v":0},{"$f":"SUM(F271,F256,F241,F227,F209,F194,F179,F164,F149,F134,F119,F72,F52,F37,F22)","v":0},{"$f":"SUM(G271,G256,G241,G227,G209,G194,G179,G164,G149,G134,G119,G72,G52,G37,G22)","v":0},{"$f":"SUM(H271,H256,H241,H227,H209,H194,H179,H164,H149,H134,H119,H72,H52,H37,H22)","v":0}]
[null,"NEW BLI TOTAL ",null,{"$f":"D275+D274","v":0},{"$f":"E275+E274","v":0},null,{"$f":"G275+G274","v":0},{"$f":"H275+H274","v":0}]

{"sheet":"Final Bud Form Part I","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,3,0,4],[1,3,1,4],[14,0,14,1],[15,0,15,1]]}
["Choice Neighborhoods Budget",null,null,"U. S. Department of Housing\nand Urban Development"]
["Implementation Grants",null,null,"Office of Public and Indian Housing",null,null,"OMB Approval No.  2577-0269"]
["Part I: Summary",null,null,null,null,null," (exp. 3/31/2025)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Grantee Name:",null,{"$f":"'Current CN Bud Info'!C3","v":0},null,"CN Grant Number:",{"$f":"'Current CN Bud Info'!C2","v":0}]
["Devel. Name:",null,{"$f":"'Current CN Bud Info'!C4","v":0},null,"Budget Revision Number:",{"$f":"'Current CN Bud Info'!G3","v":0}]
[]
[]
["Line No.",null,"Summary by Budget Line Item","Revised Overall \nCN Budget \nfor All Project Phases","Previous Amount of Funds \nAuthorized for Expenditure","\nChanges Requested \nin this Revision","HUD-Approved Total Amount of Funds Authorized for Expenditure"]
[1,1405,"Supportive Service",{"$f":"'Req Chng Overall CN Bud'!F18","v":0},{"$f":"'Current CN Bud Info'!G7","v":0},{"$f":"'Req Chng Auth Expend Spread'!E18","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F18","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F18","v":0}]
[2,1408,"Management Improvements",{"$f":"'Req Chng Overall CN Bud'!F19","v":0},{"$f":"'Current CN Bud Info'!G8","v":0},{"$f":"'Req Chng Auth Expend Spread'!E19","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F19","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F19","v":0}]
[3,1409,"Evaluation",{"$f":"'Req Chng Overall CN Bud'!F20","v":0},{"$f":"'Current CN Bud Info'!G9","v":0},{"$f":"'Req Chng Auth Expend Spread'!E20","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F20","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F20","v":0}]
[4,1410,"Administration",{"$f":"'Req Chng Overall CN Bud'!F21","v":0},{"$f":"'Current CN Bud Info'!G10","v":0},{"$f":"'Req Chng Auth Expend Spread'!E21","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F21","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F21","v":0}]
[5,1430,"Fees and Costs",{"$f":"'Req Chng Overall CN Bud'!F22","v":0},{"$f":"'Current CN Bud Info'!G11","v":0},{"$f":"'Req Chng Auth Expend Spread'!E22","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F22","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F22","v":0}]
[6,1440,"Site Acquisition",{"$f":"'Req Chng Overall CN Bud'!F23","v":0},{"$f":"'Current CN Bud Info'!G12","v":0},{"$f":"'Req Chng Auth Expend Spread'!E23","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F23","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F23","v":0}]
[7,1450,"Site Improvement",{"$f":"'Req Chng Overall CN Bud'!F24","v":0},{"$f":"'Current CN Bud Info'!G13","v":0},{"$f":"'Req Chng Auth Expend Spread'!E24","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F24","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F24","v":0}]
[8,1460,"Dwelling Structures",{"$f":"'Req Chng Overall CN Bud'!F25","v":0},{"$f":"'Current CN Bud Info'!G14","v":0},{"$f":"'Req Chng Auth Expend Spread'!E25","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F25","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F25","v":0}]
[9,1465,"Dwelling Equipment-Nonexpendable",{"$f":"'Req Chng Overall CN Bud'!F26","v":0},{"$f":"'Current CN Bud Info'!G15","v":0},{"$f":"'Req Chng Auth Expend Spread'!E26","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F26","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F26","v":0}]
[10,1470,"Nondwelling Structures",{"$f":"'Req Chng Overall CN Bud'!F27","v":0},{"$f":"'Current CN Bud Info'!G16","v":0},{"$f":"'Req Chng Auth Expend Spread'!E27","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F27","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F27","v":0}]
[11,1475,"Nondwelling Equipment",{"$f":"'Req Chng Overall CN Bud'!F28","v":0},{"$f":"'Current CN Bud Info'!G17","v":0},{"$f":"'Req Chng Auth Expend Spread'!E28","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F28","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F28","v":0}]
[12,1480,"Critical Community Improvements",{"$f":"'Req Chng Overall CN Bud'!F29","v":0},{"$f":"'Current CN Bud Info'!G18","v":0},{"$f":"'Req Chng Auth Expend Spread'!E29","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F29","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F29","v":0}]
[13,1485,"Demolition",{"$f":"'Req Chng Overall CN Bud'!F30","v":0},{"$f":"'Current CN Bud Info'!G19","v":0},{"$f":"'Req Chng Auth Expend Spread'!E30","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F30","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F30","v":0}]
[14,1495,"Relocation Costs",{"$f":"'Req Chng Overall CN Bud'!F31","v":0},{"$f":"'Current CN Bud Info'!G20","v":0},{"$f":"'Req Chng Auth Expend Spread'!E31","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F31","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F31","v":0}]
[15,1496,"Relocation - Non Residents",{"$f":"'Req Chng Overall CN Bud'!F32","v":0},{"$f":"'Current CN Bud Info'!G21","v":0},{"$f":"'Req Chng Auth Expend Spread'!E32","v":0},{"$f":"'Req Chng Auth Expend Spread'!$F32","v":0},null,{"$f":"'Req Chng Auth Expend Spread'!$F32","v":0}]
[16,"Total Funds Authorization ( Sum Of Lines 1-11)",null,null,{"$f":"SUM(E20:E34)","v":0},{"$f":"IF(SUM(F20:F34)='Req Chng Auth Expend Spread'!E33,SUM(F20:F34),\"Check Amounts\")","v":0},{"$f":"SUM($I20:$I34)","v":0},null,{"$f":"SUM($I20:$I34)","v":0}]
[17,"U2000","Funds held in Reserve",null,{"$f":"D37-E35","v":0},null,{"$f":"$I37-$I35","v":0},null,{"$f":"$I37-$I35","v":0}]
[18,"Amount of CN Grant ( Sum Of Lines 1-13)",null,{"$f":"IF(SUM(D20:D34)='Current CN Bud Info'!E24,SUM(D20:D34),\"Check Amounts\")","v":0},{"$f":"SUM(E35:E36)","v":0},null,{"$f":"$E37","v":0},null,{"$f":"$E37","v":0}]
[null,null,null,null,"HUD Certification: In approving this budget and providing assistance to a specific housing development(s),"]
[null,null,null,null,"I hereby certify that the assistance will not be more than is necessary to make the assisted activity feasible"]
[null,null,null,null,"after taking into account assistance from other government sources (24 CFR 12.50)."]
["Signature of Executive Officer",null,null,null,"Signature of Authorized HUD Official"]
[]
["X",null,"                                                            Date",null,"X",null,"               Date"]
[]
["Previous editions are obsolete",null,null,"Page 1 of 1",null,null,"HUD 53236 (3/2011)"]

{"sheet":"LOCCS Form","index":7,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,1,10,3],[10,5,10,7],[10,9,10,11],[3,1,3,3],[5,3,5,5],[5,0,5,2],[6,0,6,2]]}
["Memorandum For:  OPHI LOCCS Administrator"]
[]
[]
["From: ",{"$f":"'Current CN Bud Info'!G5","v":0}]
[]
["Re: Choice Neighborhoods Grant No:",null,null,{"$f":"'Current CN Bud Info'!C2","v":0}]
["Budget Revision Num:",null,null,{"$f":"'Current CN Bud Info'!G3","v":0}]
[]
["Please make the following changes in LOCCS for the subject grant."]
[]
[null,"OVERALL CN BUDGET",null,null,null,"REALIGNMENT OF EXPENDITURES",null,null,null,"CHANGE IN SPREAD"]
["BLI",{"$f":"'Current CN Bud Info'!E6","v":"Current Overall\nCN Budget \nfor All Project Phases"},"Increase/ Decrease",{"$f":"'Req Chng Overall CN Bud'!F17","v":"Revised Overall\nCN Budget"},"BLI",{"$f":"'Req Chng Disb Fnds Realignment'!C19","v":"Current LOCCS\nExpenditures"},{"$f":"'Req Chng Disb Fnds Realignment'!D19","v":"Increase / Decrease"},{"$f":"'Req Chng Disb Fnds Realignment'!E19","v":"Revised LOCCS\nExpenditures"},"BLI",{"$f":"'Req Chng Auth Expend Spread'!D17","v":"Current Spread"},{"$f":"'Req Chng Auth Expend Spread'!E17","v":"Increase / Decrease\nin Spread"},{"$f":"'Req Chng Auth Expend Spread'!F17","v":"Revised Spread"}]
[1405,{"$f":"'Current CN Bud Info'!E7","v":0},{"$f":"'Req Chng Overall CN Bud'!E18","v":0},{"$f":"'Req Chng Overall CN Bud'!F18","v":0},1405,{"$f":"'Req Chng Disb Fnds Realignment'!C20","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D20","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E20","v":0},1405,{"$f":"'Req Chng Auth Expend Spread'!D18","v":0},{"$f":"'Req Chng Auth Expend Spread'!E18","v":0},{"$f":"'Req Chng Auth Expend Spread'!F18","v":0}]
[1408,{"$f":"'Current CN Bud Info'!E8","v":0},{"$f":"'Req Chng Overall CN Bud'!E19","v":0},{"$f":"'Req Chng Overall CN Bud'!F19","v":0},1408,{"$f":"'Req Chng Disb Fnds Realignment'!C21","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D21","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E21","v":0},1408,{"$f":"'Req Chng Auth Expend Spread'!D19","v":0},{"$f":"'Req Chng Auth Expend Spread'!E19","v":0},{"$f":"'Req Chng Auth Expend Spread'!F19","v":0}]
[1409,{"$f":"'Current CN Bud Info'!E9","v":0},{"$f":"'Req Chng Overall CN Bud'!E20","v":0},{"$f":"'Req Chng Overall CN Bud'!F20","v":0},1409,{"$f":"'Req Chng Disb Fnds Realignment'!C22","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D22","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E22","v":0},1409,{"$f":"'Req Chng Auth Expend Spread'!D20","v":0},{"$f":"'Req Chng Auth Expend Spread'!E20","v":0},{"$f":"'Req Chng Auth Expend Spread'!F20","v":0}]
[1410,{"$f":"'Current CN Bud Info'!E10","v":0},{"$f":"'Req Chng Overall CN Bud'!E21","v":0},{"$f":"'Req Chng Overall CN Bud'!F21","v":0},1410,{"$f":"'Req Chng Disb Fnds Realignment'!C23","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D23","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E23","v":0},1410,{"$f":"'Req Chng Auth Expend Spread'!D21","v":0},{"$f":"'Req Chng Auth Expend Spread'!E21","v":0},{"$f":"'Req Chng Auth Expend Spread'!F21","v":0}]
[1430,{"$f":"'Current CN Bud Info'!E11","v":0},{"$f":"'Req Chng Overall CN Bud'!E22","v":0},{"$f":"'Req Chng Overall CN Bud'!F22","v":0},1430,{"$f":"'Req Chng Disb Fnds Realignment'!C24","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D24","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E24","v":0},1430,{"$f":"'Req Chng Auth Expend Spread'!D22","v":0},{"$f":"'Req Chng Auth Expend Spread'!E22","v":0},{"$f":"'Req Chng Auth Expend Spread'!F22","v":0}]
[1440,{"$f":"'Current CN Bud Info'!E12","v":0},{"$f":"'Req Chng Overall CN Bud'!E23","v":0},{"$f":"'Req Chng Overall CN Bud'!F23","v":0},1440,{"$f":"'Req Chng Disb Fnds Realignment'!C25","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D25","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E25","v":0},1440,{"$f":"'Req Chng Auth Expend Spread'!D23","v":0},{"$f":"'Req Chng Auth Expend Spread'!E23","v":0},{"$f":"'Req Chng Auth Expend Spread'!F23","v":0}]
[1450,{"$f":"'Current CN Bud Info'!E13","v":0},{"$f":"'Req Chng Overall CN Bud'!E24","v":0},{"$f":"'Req Chng Overall CN Bud'!F24","v":0},1450,{"$f":"'Req Chng Disb Fnds Realignment'!C26","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D26","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E26","v":0},1450,{"$f":"'Req Chng Auth Expend Spread'!D24","v":0},{"$f":"'Req Chng Auth Expend Spread'!E24","v":0},{"$f":"'Req Chng Auth Expend Spread'!F24","v":0}]
[1460,{"$f":"'Current CN Bud Info'!E14","v":0},{"$f":"'Req Chng Overall CN Bud'!E25","v":0},{"$f":"'Req Chng Overall CN Bud'!F25","v":0},1460,{"$f":"'Req Chng Disb Fnds Realignment'!C27","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D27","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E27","v":0},1460,{"$f":"'Req Chng Auth Expend Spread'!D25","v":0},{"$f":"'Req Chng Auth Expend Spread'!E25","v":0},{"$f":"'Req Chng Auth Expend Spread'!F25","v":0}]
[1465,{"$f":"'Current CN Bud Info'!E15","v":0},{"$f":"'Req Chng Overall CN Bud'!E26","v":0},{"$f":"'Req Chng Overall CN Bud'!F26","v":0},1465,{"$f":"'Req Chng Disb Fnds Realignment'!C28","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D28","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E28","v":0},1465,{"$f":"'Req Chng Auth Expend Spread'!D26","v":0},{"$f":"'Req Chng Auth Expend Spread'!E26","v":0},{"$f":"'Req Chng Auth Expend Spread'!F26","v":0}]
[1470,{"$f":"'Current CN Bud Info'!E16","v":0},{"$f":"'Req Chng Overall CN Bud'!E27","v":0},{"$f":"'Req Chng Overall CN Bud'!F27","v":0},1470,{"$f":"'Req Chng Disb Fnds Realignment'!C29","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D29","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E29","v":0},1470,{"$f":"'Req Chng Auth Expend Spread'!D27","v":0},{"$f":"'Req Chng Auth Expend Spread'!E27","v":0},{"$f":"'Req Chng Auth Expend Spread'!F27","v":0}]
[1475,{"$f":"'Current CN Bud Info'!E17","v":0},{"$f":"'Req Chng Overall CN Bud'!E28","v":0},{"$f":"'Req Chng Overall CN Bud'!F28","v":0},1475,{"$f":"'Req Chng Disb Fnds Realignment'!C30","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D30","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E30","v":0},1475,{"$f":"'Req Chng Auth Expend Spread'!D28","v":0},{"$f":"'Req Chng Auth Expend Spread'!E28","v":0},{"$f":"'Req Chng Auth Expend Spread'!F28","v":0}]
[1480,{"$f":"'Current CN Bud Info'!E18","v":0},{"$f":"'Req Chng Overall CN Bud'!E29","v":0},{"$f":"'Req Chng Overall CN Bud'!F29","v":0},1480,{"$f":"'Req Chng Disb Fnds Realignment'!C31","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D31","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E31","v":0},1480,{"$f":"'Req Chng Auth Expend Spread'!D29","v":0},{"$f":"'Req Chng Auth Expend Spread'!E29","v":0},{"$f":"'Req Chng Auth Expend Spread'!F29","v":0}]
[1485,{"$f":"'Current CN Bud Info'!E19","v":0},{"$f":"'Req Chng Overall CN Bud'!E30","v":0},{"$f":"'Req Chng Overall CN Bud'!F30","v":0},1485,{"$f":"'Req Chng Disb Fnds Realignment'!C32","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D32","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E32","v":0},1485,{"$f":"'Req Chng Auth Expend Spread'!D30","v":0},{"$f":"'Req Chng Auth Expend Spread'!E30","v":0},{"$f":"'Req Chng Auth Expend Spread'!F30","v":0}]
[1495,{"$f":"'Current CN Bud Info'!E20","v":0},{"$f":"'Req Chng Overall CN Bud'!E31","v":0},{"$f":"'Req Chng Overall CN Bud'!F31","v":0},1495,{"$f":"'Req Chng Disb Fnds Realignment'!C33","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D33","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E33","v":0},1495,{"$f":"'Req Chng Auth Expend Spread'!D31","v":0},{"$f":"'Req Chng Auth Expend Spread'!E31","v":0},{"$f":"'Req Chng Auth Expend Spread'!F31","v":0}]
[1496,{"$f":"'Current CN Bud Info'!E21","v":0},{"$f":"'Req Chng Overall CN Bud'!E32","v":0},{"$f":"'Req Chng Overall CN Bud'!F32","v":0},1496,{"$f":"'Req Chng Disb Fnds Realignment'!C34","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D34","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E34","v":0},1496,{"$f":"'Req Chng Auth Expend Spread'!D32","v":0},{"$f":"'Req Chng Auth Expend Spread'!E32","v":0},{"$f":"'Req Chng Auth Expend Spread'!F32","v":0}]
["BLI Totals",{"$f":"SUM(B13:B27)","v":0},{"$f":"SUM(C13:C27)","v":0},{"$f":"SUM(D13:D27)","v":0},"BLI Totals",{"$f":"'Req Chng Disb Fnds Realignment'!C35","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!D35","v":0},{"$f":"'Req Chng Disb Fnds Realignment'!E35","v":0},"BLI Totals",{"$f":"'Req Chng Auth Expend Spread'!D33","v":0},{"$f":"'Req Chng Auth Expend Spread'!E33","v":0},{"$f":"'Req Chng Auth Expend Spread'!F33","v":0}]
["U2000",null,null,null,"U2000",null,null,null,"U2000",{"$f":"'Req Chng Auth Expend Spread'!D34","v":0},{"$f":"'Req Chng Auth Expend Spread'!E34","v":0},{"$f":"'Req Chng Auth Expend Spread'!F34","v":0}]
[]
[]
[]
[null,"Choice Neighborhoods Director"]