{"text_format":"2","workbook":"xlsx","n_sheets":13,"sheets":["Instructions and Summary","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other Direct","i. Indirect","j. Cost Share","SF-424A Budget Info","SF-424A"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":114,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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 and Summary","index":0,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,0,15,3],[34,4,34,6],[0,2,1,5],[2,1,2,2],[2,3,2,5],[11,0,11,6],[3,1,3,2],[3,3,3,5],[5,0,5,6],[17,4,17,6],[19,4,19,6],[20,4,20,6],[14,0,14,6],[16,4,16,6],[18,0,18,3],[21,4,21,6],[22,4,22,6],[23,4,23,6],[24,4,24,6],[38,0,38,6],[25,1,25,3],[26,4,26,6],[27,4,27,6],[28,4,28,6],[29,4,29,6],[25,4,25,6],[36,0,36,6],[30,4,30,6],[31,4,31,6],[32,4,32,6],[33,4,33,6]]}
["IE 335 Budget Justification",null,"Instructions and Summary"]
[]
["Control Number:",null,null,"Date of Submission:"]
["Applicant:",null,null,"Form submitted by: "]
[]
["PLEASE READ ALL INSTRUCTIONS CAREFULLY\nIf you have any questions, email TribalGrants@hq.doe.gov  "]
[]
[]
[]
[]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nAll cost fields on this tab are auto-populated from the individual cost category tabs. "]
[]
[]
[]
["Section A - Budget Summary"]
["Federal","Cost Share","Total Costs","Cost Share %","Proposed Project Period Dates (Start and End)"]
[{"$f":"C18-B18","v":0},{"$f":"'j. Cost Share'!C43","v":0},{"$f":"B35","v":0},{"$f":"IF(C18>0,B18/C18,0)","v":0}]
["Section B - Budget Categories"]
["CATEGORY","Project Period"," Total Costs","% of Project","Comments (As Needed)"]
["a. Personnel",{"$f":"'a. Personnel'!E38","v":0},{"$f":"B21","v":0},{"$f":"IF(C21>0,C21/C18,0)","v":0}]
["b. Fringe Benefits",{"$f":"'b. Fringe'!D34","v":0},{"$f":"B22","v":0},{"$f":"IF(C22>0,C22/C18,0)","v":0}]
["c. Travel",{"$f":"'c. Travel'!I37","v":0},0,{"$f":"IF(C23>0,C23/C18,0)","v":0}]
["d. Equipment",{"$f":"'d. Equipment'!E37","v":0},0,{"$f":"IF(C24>0,C24/C18,0)","v":0}]
["e. Supplies",{"$f":"'e. Supplies'!E39","v":0},0,{"$f":"IF(C25>0,C25/C18,0)","v":0}]
["f. Contractual"]
["      Vendors",{"$f":"'f. Contractual'!C30","v":0},{"$f":"B27","v":0},{"$f":"IF(C27>0,C27/C18,0)","v":0}]
["      Partners",{"$f":"'f. Contractual'!C37","v":0},{"$f":"B28","v":0},{"$f":"IF(C28>0,C28/C18,0)","v":0}]
["      FFRDCs",{"$f":"'f. Contractual'!C43","v":0},{"$f":"B29","v":0},{"$f":"IF(C29>0,C29/C18,0)","v":0}]
["Total Contractual ",{"$f":"SUM(A27:B29)","v":0},0,{"$f":"IF(C30>0,C30/C18,0)","v":0}]
["g. Construction",{"$f":"'g. Construction'!C26","v":0},0,{"$f":"IF(C31>0,C31/C18,0)","v":0}]
["h. Other Direct Costs",{"$f":"'h. Other Direct'!C32","v":0},0,{"$f":"IF(C32>0,C32/C18,0)","v":0}]
["Total Direct Costs",{"$f":"B21+B22+B23+B24+B25+B30+B31+B32","v":0},0,{"$f":"IF(C33>0,C33/C18,0)","v":0}]
["i. Indirect Charges",{"$f":"'i. Indirect'!B23","v":0},0,{"$f":"IF(C34>0,C34/C18,0)","v":0}]
["TOTAL COSTS",{"$f":"B33+B34","v":0},0,{"$f":"D33+D34","v":0}]
[]
["Additional Explanation (as needed): "]
[]
["BURDEN DISCLOSURE STATEMENT\nPublic reporting burden for this collection of information is estimated to average 3 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing this burden, to Office of Information Resources Management Policy, Plans, and Oversight, AD-241-2 - GTN, Paperwork Reduction Project (1910-5162), U.S. Department of Energy 1000 Independence Avenue, S.W., Washington, DC 20585; and to the Office of Management and Budget, Paperwork Reduction Project (1910-5162), Washington, DC 20503."]

{"sheet":"a. Personnel","index":1,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,5,37,6],[39,0,39,7],[38,0,38,3],[15,5,15,6],[16,5,16,6],[17,5,17,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[24,5,24,6],[37,0,37,1],[25,5,25,6],[26,5,26,6],[34,5,34,6],[33,5,33,6],[32,5,32,6],[0,11,0,13],[0,0,0,1],[1,0,1,7],[13,1,14,1],[13,0,14,0],[13,4,14,4],[13,2,14,2],[13,3,14,3],[13,5,14,6],[13,7,14,7],[29,5,29,6],[31,5,31,6],[35,5,35,6],[36,5,36,6],[2,0,11,7],[27,5,27,6],[28,5,28,6],[30,5,30,6],[22,5,22,6],[23,5,23,6],[21,5,21,6]]}
["IE 335 Budget Justification"]
["a. Personnel"]
{"$rows_empty":11}
["Workplan Task #","Position Title","Time \n(Hrs)","Pay Rate\n($/Hr)","Cost","Basis of Cost Estimate",null,"Justification of Need"]
[]
["1.0","Program Manager (EXAMPLE)",2000,65,{"$f":"C16*D16","v":130000},"Actual Salary",null,"For project management and reporting"]
[2.2999999999999998,"Environmental Specialist (EXAMPLE)",1000,40,{"$f":"C17*D17","v":40000},"Labor Distribution Report",null,"To complete environmental analysis"]
[{"$nulls":4},{"$f":"C18*D18","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL PERSONNEL COSTS",null,{"$f":"SUM(C18:C37)","v":0},null,{"$f":"SUM(E18:E37)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"b. Fringe","index":2,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,3],[35,0,35,3],[32,4,32,10],[33,4,33,10],[1,0,1,3],[29,4,29,10],[30,4,30,10],[31,4,31,10],[10,4,10,10],[12,4,12,10],[13,4,13,10],[14,4,14,10],[15,4,15,10]]}
["IE 335 Budget Justification"]
["b. Fringe Benefits"]
{"$rows_empty":8}
["Labor Type","Personnel Costs","Rate","Fringe Costs"]
["Program Manager (EXAMPLE)",130000,0.18,{"$f":"B12*C12","v":23400}]
["Environmental Director (EXAMPLE)",40000,0.15,{"$f":"B13*C13","v":6000}]
[null,null,null,{"$f":"B14*C14","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["TOTAL FRINGE BENEFIT COSTS",{"$f":"SUM(B14:B33)","v":0},null,{"$f":"SUM(D14:D33)","v":0}]
[]
["Additional Explanation (as needed):  "]

{"sheet":"c. Travel","index":3,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,0,1,9],[0,0,0,1],[38,0,38,9],[36,0,36,3]]}
["IE 335 Budget Justification"]
["c. Travel"]
{"$rows_empty":7}
["Workplan Task #","Purpose of Travel","Depart From","Destination","# Trips","# Days Per Trip","# People Per Trip","Cost Per Trip Per Person","Cost","Basis of Cost Estimate"]
["1.0","Yearly Visit to Denver for DOE Tribal Energy Program Review as required for reporting (EXAMPLE)","San Diego","Denver",2,5,2,1725,{"$f":"E11*G11*H11","v":6900},"Based on published air fare prices and government per diem rates. Costs are calculated at $1,725 per trip based on 2017 GSA rates. Lodging ($180/day *2 people *2 days) + Flight ($555) + M&IE ($69/Day *5 days) + Vehicle ($75) = $1,725"]
["6.0","Sr. Engineer to visit St. Paul for verification tasks (EXAMPLE)","Anchorage","St. Paul",1,1,1,1350,{"$f":"E12*G12*H12","v":1350},"Cost based on actual past travel costs and current government per diem rates. Costs are calculated at $1,350 per trip based on 2017 GSA rates. PenAir Anchorage to St. Paul Island round trip =  $1200, no vehicle, per diem at $88/day. 1 trip for 1 traveler *(Flight ($1,200) + M&IE ($88/day *2 days) = $1,350.  Note: No lodging or vehicle costs are budgeted for this trip as those items will be provided free of charge on the island."]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
[{"$nulls":8},0]
["TOTAL TRAVEL COSTS",null,null,null,{"$f":"SUM(E13:E36)","v":0},null,null,null,{"$f":"SUM(I13:I36)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"d. Equipment","index":4,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,1],[38,0,38,6],[36,0,36,3],[36,5,36,6]]}
["IE 335 Budget Justification"]
["d. Equipment"]
{"$rows_empty":8}
["Workplan Task #","Equipment Item","Qty","Unit Cost         ","Cost             ","Basis of Cost Estimate","Justification of Need"]
["2.3, 3.4","Batteries for solar storage (EXAMPLE)",1,15000,15000,"Vendor Quotes - Attached","30 kW of backup battery storage required for proposed system operations"]
[{"$nulls":4},{"$f":"C13*D13","v":0}]
[{"$nulls":4},{"$f":"C14*D14","v":0}]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL EQUIPMENT COSTS",null,null,null,{"$f":"SUM(E13:E36)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"e. Supplies","index":5,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,6],[40,0,40,6],[38,0,38,3],[38,5,38,6]]}
["IE 335 Budget Justification"]
["e. Supplies"]
{"$rows_empty":9}
["Workplan Task #","General Category of Supplies","Qty","Unit Cost         ","Cost             ","Basis of Cost Estimate","Justification of Need"]
["2.0","Laptop (EXAMPLE)",1,2000,{"$f":"C13*D13","v":2000},"Online published price","Laptop for Program Manager"]
["4.0,6.1","Gravel (EXAMPLE)",2000,1.5,{"$f":"C14*D14","v":3000},"Quote from ABC Gravel (quote attached)","Gravel for solar array foundation"]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
[{"$nulls":4},0]
["TOTAL SUPPLIES COSTS",null,null,null,{"$f":"SUM(E15:E38)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"f. Contractual","index":6,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,0,0,1],[46,0,46,4],[44,0,44,1],[29,0,29,1],[36,0,36,1],[42,0,42,1],[1,0,2,4]]}
["IE 335 Budget Justification"]
["f. Contractual"]
{"$rows_empty":12}
["Workplan Task #","Vendor Name/Organization ","Cost","Basis of Cost Estimate","Justification of Need"]
["6.0","ABC Environmental Corp. (EXAMPLE)",40000,"Vendor quote (attached)","Vendor for engineering and environmental permitting activities"]
["2.2, 3.1","123 Solar Corp.(EXAMPLE)",180000,"Vendor quote (attached)","Vendor for solar PV balance of system installation, minus battery storage"]
{"$rows_empty":12}
["Subtotal:",null,{"$f":"SUM(C18:C29)","v":0}]
[]
["Workplan Task #","Subrecipient Name/Organization","Cost","Basis of Cost Estimate","Justification of Need"]
["2.0, 4.1","XYZ Corp. (EXAMPLE)",220000,"Cost estimate based on personnel hours ($100/hour x 2,200 hours)","Partner or Subawardee to develop optimal lens for Gen 2 product. "]
[]
[]
[]
["Subtotal:",null,{"$f":"SUM(C34:C36)","v":0}]
[]
["Workplan Task #","FFRDC Name/Organization","Cost","Basis of Cost Estimate","Justification of Need"]
["2.0, 4.1","XYZ DOE Laboratory (EXAMPLE)",40000,"Cost based on estimate ($100/hour x 400 hours)","To provide turbine blade testing. "]
[]
[]
["Subtotal:",null,{"$f":"SUM(C41:C42)","v":0}]
[]
["TOTAL CONTRACTUAL COSTS",null,{"$f":"C30+C37+C43","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"g. Construction","index":7,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,4],[0,0,0,1],[1,0,1,4],[25,0,25,1]]}
["IE 335 Budget Justification"]
["g. Construction"]
[]
[]
[]
[]
["Workplan Task #","General Description","Cost             ","Basis of Cost Estimate","Justification of Need"]
{"$rows_empty":18}
["TOTAL CONSTRUCTION COSTS",null,{"$f":"SUM(C8:C25)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"h. Other Direct","index":8,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,4],[33,0,33,4],[31,0,31,1]]}
["IE 335 Budget Justification"]
["h. Other Direct"]
{"$rows_empty":9}
["Workplan Task #","General Description"," Cost             ","Basis of Cost Estimate","Justification of Need"]
["5.0","Equipment Rental (EXAMPLE)",3000,"Vendor quote","Equipment for blowing insulation for weatherization of the Community Center"]
{"$rows_empty":18}
["TOTAL OTHER COSTS",null,{"$f":"SUM(C14:C31)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"i. Indirect","index":9,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,5],[10,0,10,5],[9,0,9,5],[12,0,12,5],[13,2,13,5],[24,0,24,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[22,3,22,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[17,2,17,5]]}
["IE 335 Budget Justification"]
["i. Indirect"]
{"$rows_empty":7}
["Indirect Rate Agreement or Proposal\nSelect one of the four options below "]
[]
[]
["Indirect Cost Calculation\n\n"]
["Provide ONLY Applicable Rates:","Total %"]
["Overhead Rate",0]
["Facilities capital cost of money (FCCM) Rate, if applicable",0]
["OTHER Indirect Rate",0]
["Indirect Costs (As Applicable):","Total $","Explanation of Indirect Costs \n(i.e., Rate applied to: \"Personnel only\"; \"Personnel and Fringe\"; \"Direct Project Costs excluding passthrough\")"]
["Overhead Costs"]
["G&A Costs"]
["Facilities capital cost of money (FCCM)  Costs, if applicable"]
[" OTHER Indirect Costs"]
["TOTAL INDIRECT COSTS",{"$f":"SUM(B19:B22)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"j. Cost Share","index":10,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,0,46,5],[1,0,1,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[39,3,39,5],[40,3,40,5],[41,3,41,5],[22,3,22,5],[43,4,43,5],[44,0,44,1],[44,3,44,4],[23,3,23,5],[36,3,36,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[34,3,34,5],[35,3,35,5],[42,0,42,1],[0,4,0,5],[27,3,27,5],[28,3,28,5],[29,3,29,5],[30,3,30,5],[0,0,0,2],[37,3,37,5],[38,3,38,5],[42,3,42,5]]}
["IE 335 Budget Justification"]
["j. Cost Share"]
{"$rows_empty":15}
["Organization                 ","Type (Cash or In-kind) ","Cost","Description and Basis of Cost Estimate"]
["Applicant (EXAMPLE)","Cash",5000,"Contributed personnel costs ($100/hour x $50/hour)"]
["Applicant (EXAMPLE)","Cash",1000,"Contributed fringe benefit costs (20% X $5,000)"]
["Partner ABC (EXAMPLE)","Cash",120000,"Contributed personnel costs (1,200 hours x $100/hour)"]
["Vendor XYZ (EXAMPLE)","In-kind",7500,"Donated dump truck for waste removal (50 hours x $150/hour)"]
{"$rows_empty":20}
["TOTAL COST SHARE",null,{"$f":"SUM(C23:C42)","v":0}]
[]
["Total Project Cost:  ",null,{"$f":"'Instructions and Summary'!C35","v":0},"Cost Share Percent of Award:",null,{"$f":"IF(C35>0, C43/C45, 0)","v":0}]
[]
["Additional Explanation (as needed): "]

{"sheet":"SF-424A Budget Info","index":11,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,0,31,7],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,0,26,7],[27,1,27,2],[30,0,30,1],[30,2,30,5],[30,6,30,7],[22,1,22,2],[13,0,14,0],[13,1,14,2],[13,3,13,6],[13,7,14,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[12,0,12,1],[12,2,12,7],[0,0,0,1],[0,2,0,3],[0,5,0,6],[1,0,1,7],[2,0,2,7],[3,0,3,1],[3,2,3,7],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,4,7]]}
["Applicant Name:",null,{"$f":"IF('Instructions and Summary'!B4>\"\", 'Instructions and Summary'!B4, \"\")","v":""},null,"Control Number:",{"$f":"IF('Instructions and Summary'!B3>\"\", 'Instructions and Summary'!B3, \"\")","v":""}]
["Budget Information - Non Construction Programs"]
["OMB Approval No. 0348-0044"]
["Section A - Budget Summary"]
[null,"Grant Program Function or Activity","Catalog of Federal Domestic Assistance Number","Estimated Unobligated Funds",null,"New or Revised Budget"]
[null,null,null,"Federal","Non-Federal ","Federal","Non-Federal","Total"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)"]
["1.","Project Period Totals",null,null,null,{"$f":"'Instructions and Summary'!B35-G8","v":0},{"$f":"'j. Cost Share'!C43","v":0},{"$f":"SUM(D8:G8)","v":0}]
["2.","n/a"]
["3.","n/a"]
["4.","n/a"]
["5.","Totals",null,null,null,{"$f":"SUM(F8:F11)","v":0},{"$f":"SUM(G8:G11)","v":0},{"$f":"SUM(H8:H11)","v":0}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total (5)"]
[null,null,null,"Project Period"]
["a.","Personnel",null,{"$f":"'a. Personnel'!E38","v":0},null,null,null,{"$f":"D16","v":0}]
["b.","Fringe Benefits",null,{"$f":"'b. Fringe'!D34","v":0},null,null,null,{"$f":"D17","v":0}]
["c.","Travel",null,{"$f":"'c. Travel'!I37","v":0},null,null,null,0]
["d.","Equipment",null,{"$f":"'d. Equipment'!E37","v":0},null,null,null,0]
["e.","Supplies",null,{"$f":"'e. Supplies'!E39","v":0},null,null,null,0]
["f.","Contractual",null,{"$f":"'f. Contractual'!C45","v":0},null,null,null,0]
["g.","Construction",null,{"$f":"'g. Construction'!C26","v":0},null,null,null,0]
["h.","Other",null,{"$f":"'h. Other Direct'!C32","v":0},null,null,null,0]
["i.","Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":0},null,null,null,{"$f":"D24","v":0}]
["j.","Indirect Charges",null,{"$f":"'i. Indirect'!B23","v":0},null,null,null,{"$f":"D25","v":0}]
["k.","TOTALS (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":0},null,null,null,{"$f":"SUM(H24:H25)","v":0}]
[]
["7.","Program Income",{"$nulls":5},{"$f":"D28","v":0}]
[]
[{"$nulls":7},"SF-424A (Rev. 4-92) "]
[{"$nulls":6},"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]

{"sheet":"SF-424A","index":12,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":true,"merged":[[62,2,62,6],[64,0,101,7],[103,0,144,7],[0,2,0,3],[0,5,0,6],[58,0,58,7],[59,0,59,7],[60,2,60,6],[61,0,61,1],[55,0,55,3],[55,4,55,7],[56,2,56,7],[57,0,57,7],[53,0,53,2],[53,3,53,7],[54,2,54,3],[54,5,54,7],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[45,4,45,7],[46,0,47,3],[46,4,46,7],[48,1,48,3],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,0,45,3],[39,1,39,3],[40,0,40,2],[40,3,40,7],[41,0,41,2],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[31,0,31,7],[33,0,33,2],[33,3,33,7],[34,1,34,3],[27,1,27,2],[30,0,30,1],[30,2,30,5],[30,6,30,7],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,0,26,7],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[12,0,12,1],[12,2,12,7],[13,0,14,0],[13,1,14,2],[13,3,13,6],[13,7,14,7],[4,3,4,4],[0,0,0,1],[1,0,1,7],[2,0,2,7],[3,0,3,1],[3,2,3,7],[4,5,4,7],[4,0,5,0],[4,1,5,1],[4,2,5,2]]}
["Applicant Name:",null,null,null,"Award Number:"]
["Budget Information - Non Construction Programs"]
["OMB Approval No. 0348-0044"]
["Section A - Budget Summary"]
[null,"Grant Program Function or Activity","Catalog of Federal Domestic Assistance Number","Estimated Unobligated Funds",null,"New or Revised Budget"]
[null,null,null,"Federal ","Non-Federal ","Federal","Non-Federal","Total"]
[null,"(a)","(b)","(c )","(d)","(e)","(f)","(g)"]
["1.","Budget period 1",null,null,null,{"$f":"D26-G8","v":0},{"$f":"'j. Cost Share'!F43","v":0},{"$f":"SUM(D8:G8)","v":0}]
["2.","Budget period 2",null,null,null,{"$f":"E26-G9","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D9:G9)","v":{"$error":"#REF!"}}]
["3.","Budget period 3",null,null,null,{"$f":"F26-'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"'j. Cost Share'!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(D10:G10)","v":{"$error":"#REF!"}}]
["4.",{"$nulls":6},{"$f":"SUM(D11:G11)","v":0}]
["5.","Totals",null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":{"$error":"#REF!"}},{"$f":"SUM(G8:G11)","v":{"$error":"#REF!"}},{"$f":"SUM(H8:H11)","v":{"$error":"#REF!"}}]
["Section B - Budget Categories"]
["6.","Object Class Categories",null,"Grant Program, Function or Activity",null,null,null,"Total (5)"]
[null,null,null,"Budget period 1","Budget period 2","Budget period 3","(4)"]
[null,"a.  Personnel",null,{"$f":"'Instructions and Summary'!B21","v":0},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(D16:G16)","v":{"$error":"#REF!"}}]
[null,"b.  Fringe Benefits",null,{"$f":"'Instructions and Summary'!B22","v":0},{"$f":"'Instructions and Summary'!A22","v":"b. Fringe Benefits"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"c.  Travel",null,{"$f":"'Instructions and Summary'!B23","v":0},{"$f":"'Instructions and Summary'!A23","v":"c. Travel"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"d.  Equipment",null,{"$f":"'Instructions and Summary'!B24","v":0},{"$f":"'Instructions and Summary'!A24","v":"d. Equipment"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"e.  Supplies",null,{"$f":"'Instructions and Summary'!B25","v":0},{"$f":"'Instructions and Summary'!A25","v":"e. Supplies"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"f.  Contractual",null,{"$f":"'Instructions and Summary'!B30","v":0},{"$f":"'Instructions and Summary'!A30","v":"Total Contractual "},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"g.  Construction",null,{"$f":"'Instructions and Summary'!B31","v":0},{"$f":"'Instructions and Summary'!A31","v":"g. Construction"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"h.  Other",null,{"$f":"'Instructions and Summary'!B32","v":0},{"$f":"'Instructions and Summary'!A32","v":"h. Other Direct Costs"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":{"$error":"#REF!"}},{"$f":"SUM(F16:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G16:G23)","v":0},{"$error":"#REF!"}]
[null,"j.  Indirect Charges",null,{"$f":"'Instructions and Summary'!B34","v":0},{"$f":"'Instructions and Summary'!A34","v":"i. Indirect Charges"},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E25)","v":{"$error":"#REF!"}},{"$f":"SUM(F24:F25)","v":{"$error":"#REF!"}},{"$f":"SUM(G24:G25)","v":0},{"$f":"SUM(H24:H25)","v":{"$error":"#REF!"}}]
[]
["7.","Program Income",{"$nulls":5},{"$f":"SUM(D28:G28)","v":0}]
[]
[{"$nulls":7},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",{"$nulls":5},"Prescribed by OMB Circular A-102"]
["Authorized for Local Reproduction"]
[]
["Section C - Non-Federal Resources"]
[null,"(a) Grant Program",null,null,"(b) Applicant","(c ) State","(d) Other Sources","(e) Totals"]
["8.","Budget period 1",{"$nulls":5},{"$f":"SUM(E36:G36)","v":0}]
["9.","Budget period 2",{"$nulls":5},{"$f":"SUM(E37:G37)","v":0}]
["10.","Budget period 3",{"$nulls":5},{"$f":"SUM(E38:G38)","v":0}]
["11.",{"$nulls":6},{"$f":"SUM(E39:G39)","v":0}]
["12.","Total (sum of lines 8 - 11)",null,null,{"$f":"SUM(E36:E39)","v":0},{"$f":"SUM(F36:F39)","v":0},{"$f":"SUM(G36:G39)","v":0},{"$f":"SUM(H36:H39)","v":0}]
["Section D - Forecasted Cash Needs"]
[null,null,null,"Total for 1st Year","1st Quarter","2nd Quarter","3rd Quarter","4th quarter"]
["13.","Federal",null,{"$f":"SUM(E43:H43)","v":0}]
["14.","Non-Federal",null,{"$f":"SUM(E44:H44)","v":0}]
["15.","Total (sum of lines 13 and 14)",null,{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"SUM(G43:G44)","v":0},{"$f":"SUM(H43:H44)","v":0}]
["Section E - Budget Estimates of Federal Funds Needed for Balance of the Project"]
["(a) Grant Program",null,null,null,"Future Funding Periods (Years)"]
[{"$nulls":4},"Budget period 1","Budget period 2","Budget period 3"]
["16."]
["17."]
["18."]
["19."]
["20.","Total (sum of lines 16-19)",null,null,{"$f":"SUM(E49:E52)","v":0},{"$f":"SUM(F49:F52)","v":0},{"$f":"SUM(G49:G52)","v":0},{"$f":"SUM(H49:H52)","v":0}]
["Section F - Other Budget Information"]
["21. Direct Charges",null,null,null,"22. Indirect Charges"]
[]
["23.  Remarks"]
[]
[]
[]
[{"$nulls":7},"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,"              ",{"$nulls":4},"Prescribed by OMB Circular A-102"]
[null,null,"Authorized for Local Reproduction"]