{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form 1","Form 2","Form 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"Form 1","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,0,20,3],[20,4,20,5],[30,0,30,3],[24,0,24,3],[27,0,27,3],[23,0,23,6],[26,0,26,8],[27,4,27,6],[27,7,27,8],[28,4,28,6],[28,7,28,8],[25,7,25,8],[24,7,24,8],[30,4,30,6],[25,0,25,3],[25,4,25,6],[0,0,0,8],[2,2,2,5],[3,2,3,5],[7,7,7,8],[6,7,6,8],[5,7,5,8],[5,2,5,5],[6,2,6,5],[2,9,2,10],[3,7,3,8],[2,7,2,8],[4,2,4,5],[8,7,8,8],[11,4,11,5],[10,0,10,16383],[9,0,9,3],[16,0,16,3],[19,1,19,3],[11,0,11,3],[12,4,12,5],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[17,0,17,3],[19,4,19,5],[16,4,16,5],[18,0,18,3],[31,4,31,6],[31,7,31,8],[23,7,23,8],[24,4,24,6],[13,4,13,5],[21,6,21,8],[17,4,17,5],[18,4,18,5],[14,4,14,5],[15,4,15,5],[30,7,30,8]]}
["Budget Summary"]
["FORM 1"]
["A. Delegate Agency:",null,null,null,null,null,"F. Supplier / Site #"]
["B. Program Name:",null,"NBDC & SA",null,null,null,"G. PO #:"," "]
["C. Department:",null,"Business Affairs & Consumer Protect",null,null,null,"H. Release #:",1]
["D. Contract Term:",null,"1/1/2014 to 12/31/2014",null,null,null,"I.. Funding Strip:","FY014-0100-0702005-0135-220135"]
["E. 2014 Allocation:",null,null,null,null,null,"J. CFDA #:","NA"]
[null,null,null,null,null,null,"Agency Phone Number"]
[null,null,null,null,null,null,"E-mail address"]
["K. Program Budget Summary for Year: ",null,null,null,2014]
["Note: The entire budget for this program must be shown."]
["(1) Item of Expenditure",null,null,null,"(2) Account #",null,"(3) Corporate Share","(4) Other Share","(5) Total Cost"]
["Personnel",null,null,null,"0005",null,{"$f":"'Form 2'!I23","v":0},{"$f":"'Form 2'!J23","v":0},{"$f":"'Form 2'!K23","v":0}]
["Fringe Benefits",null,null,null,"0044",null,{"$f":"'Form 2'!I33","v":0},{"$f":"'Form 2'!J33","v":0},{"$f":"'Form 2'!K33","v":0}]
["Operating/Technical",null,null,null,"0100",null,{"$f":"'Form 3'!F9","v":0},{"$f":"'Form 3'!G9","v":0},{"$f":"'Form 3'!H9","v":0}]
["Professional and Technical Services",null,null,null,"0140",null,{"$f":"'Form 3'!F10","v":0},{"$f":"'Form 3'!G10","v":0},{"$f":"'Form 3'!H10","v":0}]
["Travel",null,null,null,"0200",null,{"$f":"'Form 3'!F11","v":0},{"$f":"'Form 3'!G11","v":0},{"$f":"'Form 3'!H11","v":0}]
["Materials and Supplies",null,null,null,"0300",null,{"$f":"'Form 3'!F12","v":0},{"$f":"'Form 3'!G12","v":0},{"$f":"'Form 3'!H12","v":0}]
["Equipment",null,null,null,"0400",null,{"$f":"'Form 3'!F13","v":0},{"$f":"'Form 3'!G13","v":0},{"$f":"'Form 3'!H13","v":0}]
[{"$f":"'Form 3'!A14:D14","v":"   Other:"},{"$f":"'Form 3'!B14","v":0},null,null,{"$f":"'Form 3'!E14","v":"0999"},null,{"$f":"'Form 3'!F14","v":0},{"$f":"'Form 3'!G14","v":0},{"$f":"'Form 3'!H14","v":0}]
["TOTALS",null,null,null,null,null,{"$f":"SUM(G13:G20)","v":0},{"$f":"SUM(H13:H20)","v":0},{"$f":"SUM(I13:I20)","v":0}]
[null,null,null,null,null,null,"***ALL COLUMNS / ROWS MUST BALANCE***"]
["L. Percentage of total project costs paid by Other Share:",null,null,null,null,null,{"$f":"H21/I21","v":{"$error":"#DIV/0!"}}]
["M. Delegate Authorization",null,null,null,null,null,null,"N. City Authorization"]
[]
["Signature of Delegate Official / Date",null,null,null,"Signature of Delegate Official / Date",null,null,"Signature of Department / Date"]
["SIGNATURE MUST BE IN BLUE INK"]
[]
["Name(Type or Print)",null,null,null,"Name(Type or Print)",null,null,"Name(Type or Print)"]
[]
[]
["Title (Type or Print)",null,null,null,"Title (Type or Print)",null,null,"Title (Type or Print)"]

{"sheet":"Form 2","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,2,30,7],[31,2,31,7],[25,0,25,7],[6,0,6,3],[18,0,18,3],[19,0,19,3],[20,0,20,3],[22,0,22,3],[23,5,23,10],[21,0,21,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[17,0,17,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[12,0,12,3],[0,0,0,11],[3,2,3,7],[7,0,7,3],[8,0,8,3],[3,10,3,11],[1,0,1,11],[4,2,4,7]]}
[]
["Personnel Budget - CORPORATE"]
["FORM 2"]
["A. Delegate Agency:",null,{"$f":"'Form 1'!C3:F3","v":0},null,null,null,null,null,"C. Program Name:",null,{"$f":"'Form 1'!C4","v":"NBDC & SA"}]
["B. Department:",null,{"$f":"'Form 1'!C5:F5","v":"Business Affairs & Consumer Protect"},null,null,null,null,null,"D. Federal Employer Identification #: "]
["E. Personnel Budget Allocation for: ",null,null,null,{"$f":"'Form 1'!E10","v":2014}]
["(1)  Position Title",null,null,null,"(2)\nNo.","(3) Rate ($)","(4)\nNumber of Pay Periods","(5) % Time spent on Project","(6) CORP Share","(7) Other Share","(8) Total Cost","(9) Job Responsibilities"]
[null,null,null,null,null,null,null,null,null,{"$f":"K8-I8","v":0},{"$f":"H8*F8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"K9-I9","v":0},0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"K19-I19","v":0},{"$f":"H19*F19","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"K20-I20","v":0},{"$f":"H20*F20","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"K21-I21","v":0},{"$f":"H21*F21","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"K22-I22","v":0},{"$f":"H22*F22","v":0}]
["(10) TOTALS",null,null,null,{"$f":"SUM(E8:E22)","v":0},0,null,{"$f":"SUM(H8:H22)","v":0},0,0,0,"Totals must match Form 1 Acct #0005"]
[null,null,null,null,null,"***ALL COLUMNS / ROWS MUST BALANCE***"]
["F. Fringe Benefits and Total Personnel Cost"]
["Item",null,null,null,null,null,null,null,"CORP Share","Other Share","Total Cost","Calculations"]
["11a. Social Security",null,null,null,null,null,null,null,null,{"$f":"K27-I27","v":0},{"$f":"0.062*K23","v":0},"= .0620 x Line10"]
["11b. Medicare",null,null,null,null,null,null,null,null,{"$f":"K28-I28","v":0},{"$f":"K23*0.0145","v":0},"= .0145 x Line 10"]
["12. State Unemployment Insurance",null,null,null,null,null,null,null,{"$f":"K29-J29","v":0}]
["13. State Workers Compensation",null,null,null,null,null,null,null,{"$f":"K30-J30","v":0}]
["14 Other (Please list)",null,null,null,null,null,null,null,{"$f":"K31-J31","v":0}]
["15. Other (Please list)",null,null,null,null,null,null,null,{"$f":"K32-J32","v":0}]
["16. Total Fringe Benefits (Lines11-15)",null,null,null,null,null,null,null,{"$f":"SUM(I27:I32)","v":0},{"$f":"SUM(J27:J32)","v":0},{"$f":"SUM(I33:J33)","v":0},"Totals must match Form 1 Acct #0044"]
["17. Total Personnel Costs (Line 10 plus Line 16)",null,null,null,null,null,null,null,{"$f":"SUM(I23+I33)","v":0},{"$f":"SUM(J23+J33)","v":0},{"$f":"SUM(K23+K33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K23+K33","v":0}]

{"sheet":"Form 3","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,14,3],[14,8,14,10],[12,0,12,3],[12,8,12,10],[13,1,13,3],[13,8,13,10],[11,0,11,3],[7,8,7,10],[8,8,8,10],[11,8,11,10],[9,8,9,10],[7,0,7,3],[8,0,8,3],[9,0,9,3],[0,0,0,10],[10,0,10,3],[10,8,10,10],[6,5,6,7],[6,0,6,3],[4,8,4,10],[1,0,1,10],[3,2,3,5],[4,2,4,5],[3,8,3,10]]}
[]
["Non-Personnel Budget - CORPORATE"]
["FORM 3"]
["A. Delegate Agency:",null,{"$f":"'Form 1'!C3:F3","v":0},null,null,null,"C. Program Name:",null,{"$f":"'Form 1'!C4","v":"NBDC & SA"}]
["B. Department:",null,{"$f":"'Form 1'!C5:F5","v":"Business Affairs & Consumer Protect"},null,null,null,"D. Federal Employer Identification #: ",null,{"$f":"'Form 2'!L5","v":0}]
[]
["E. Non-Personnel Budget Allocation for: ",null,null,null,{"$f":"'Form 1'!E10","v":2014},"***ALL COLUMNS  /  ROWS MUST BALANCE***"]
["(1) Item of Expenditure",null,null,null,"(2) \nAcct#","(3) \nCORP Share","(4) \nOther Share","(5) \nTotal Cost","(6) Description and Justification for CORP Share and Total Cost"]
["Operating/Technical",null,null,null,"0100",null,{"$f":"H9-F9","v":0}]
["Professional and Technical Services",null,null,null,"0140",null,0]
["  Travel",null,null,null,"0200",null,0]
["Materials and Supplies",null,null,null,"0300",null,0]
["Equipment",null,null,null,"0400",null,0]
["   Other:",null,null,null,"0999",null,0]
["(7) TOTALS",null,null,null,null,{"$f":"SUM(F9:F14)","v":0},{"$f":"SUM(G9:G14)","v":0},{"$f":"SUM(H9:H14)","v":0},"Totals must match Form 1 Non-Personnel accounts"]