{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions and Summary","a. Personnel","b. Fringe","c. Travel","d. Equipment","e. Supplies","f. Contractual","g. Construction","h. Other","i. Indirect","j. Cost Share","SF-424A"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"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":"Instructions and Summary","index":0,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[27,0,27,2],[28,0,30,6],[3,1,3,2],[3,3,3,5],[6,0,6,6],[7,0,7,6],[0,0,0,4],[1,0,1,6],[2,1,2,2],[2,3,2,5],[9,0,9,6]]}
["Budget Justification"]
["Instructions and Summary"]
["Agency Name:",null,null,"Form submitted by/phone #:"]
["Program Activity Name:",null,null,"Date of Submission:"]
[]
[]
["Please read the instructions on each page (worksheet) before starting.  \nIf you have any questions, please ask Carol Stringer (carol.stringer@ky.gov).  It will save you time!  "]
["On this form, provide detailed support for the estimated project costs identified for each Category line item within each worksheet (budget items under different tabs).\n\n●   The total budget presented on this form must include both Grant, and Non-Grant (cost share/match funding) portions, thereby reflecting TOTAL PROJECT COSTS proposed.\n\n●  For costs in each Object Class Category below, complete the corresponding worksheet on this form (tab at the bottom of the page).  \n\n●  All costs incurred by the preparer's sub-recipients, vendors, contractors and consultants, should be entered only in section f. Contractual.  All other sections are for the costs of the preparer only."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\n(Note: The values in this summary table are from entries made in each budget category sheet.)"]
["CATEGORY","Budget Period 1 Costs","Budget Period 2 Costs","Budget Period 3 Costs"," Total Costs","Project Costs %","Comments\n(Add comments as needed)"]
["a. Personnel",{"$f":"'a. Personnel'!F23","v":0},{"$f":"'a. Personnel'!J23","v":0},{"$f":"'a. Personnel'!N23","v":0},{"$f":"SUM(B12:D12)","v":0},{"$f":"E12/$E$26","v":{"$error":"#DIV/0!"}}]
["b. Fringe Benefits",{"$f":"'b. Fringe'!D6","v":0},{"$f":"'b. Fringe'!E6","v":0},{"$f":"'b. Fringe'!F6","v":0},{"$f":"SUM(B13:D13)","v":0},{"$f":"E13/$E$26","v":{"$error":"#DIV/0!"}}]
["c. Travel",{"$f":"'c. Travel'!F14","v":0},{"$f":"'c. Travel'!F27","v":0},{"$f":"'c. Travel'!F38","v":0},0,{"$f":"E14/$E$26","v":{"$error":"#DIV/0!"}}]
["d. Equipment",{"$f":"'d. Equipment'!D13","v":0},{"$f":"'d. Equipment'!D20","v":0},{"$f":"'d. Equipment'!D29","v":0},0,{"$f":"E15/$E$26","v":{"$error":"#DIV/0!"}}]
["e. Supplies",{"$f":"'e. Supplies'!D15","v":0},{"$f":"'e. Supplies'!D25","v":0},{"$f":"'e. Supplies'!D34","v":0},0,{"$f":"E16/$E$26","v":{"$error":"#DIV/0!"}}]
["f. Contractual"]
["Sub-recipient",{"$f":"'f. Contractual'!C14","v":0},{"$f":"'f. Contractual'!D14","v":0},{"$f":"'f. Contractual'!E14","v":0},{"$f":"SUM(B18:D18)","v":0},{"$f":"E18/$E$26","v":{"$error":"#DIV/0!"}}]
["Vendor",{"$f":"'f. Contractual'!C21","v":0},{"$f":"'f. Contractual'!D21","v":0},{"$f":"'f. Contractual'!E21","v":0},0,{"$error":"#DIV/0!"}]
["Total Contractual ",{"$f":"SUM(B18:B19)","v":0},{"$f":"SUM(C18:C19)","v":0},{"$f":"SUM(D18:D19)","v":0},0,{"$error":"#DIV/0!"}]
["g. Construction",{"$f":"'g. Construction'!B14","v":0},{"$f":"'g. Construction'!B19","v":0},{"$f":"'g. Construction'!B24","v":0},0,{"$error":"#DIV/0!"}]
["h. Other Direct Costs",{"$f":"'h. Other'!B12","v":0},{"$f":"'h. Other'!B24","v":0},{"$f":"'h. Other'!B36","v":0},{"$f":"SUM(B22:D22)","v":0},{"$error":"#DIV/0!"}]
["i. Indirect Charges",{"$f":"'i. Indirect'!D5","v":0},{"$f":"'i. Indirect'!E5","v":0},{"$f":"'i. Indirect'!F5","v":0},{"$f":"SUM(B23:D23)","v":0},{"$error":"#DIV/0!"}]
["Project Costs",{"$f":"SUM(B12:B23)-B20","v":0},{"$f":"SUM(C12:C23)-C20","v":0},{"$f":"SUM(D12:D23)-D20","v":0},{"$f":"SUM(E12:E23)-E20","v":0},{"$error":"#DIV/0!"}]
["j. Cost Share/Match Funding",{"$f":"'j. Cost Share'!D13","v":0},{"$f":"'j. Cost Share'!E13","v":0},{"$f":"'j. Cost Share'!F13","v":0},{"$f":"SUM(B25:D25)","v":0},{"$error":"#DIV/0!"}]
["Total Project Costs",{"$f":"B24+B25","v":0},{"$f":"C24+C25","v":0},{"$f":"D24+D25","v":0},{"$f":"E24+E25","v":0},{"$error":"#DIV/0!"}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"a. Personnel","index":1,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[25,0,27,15],[5,14,6,14],[5,15,6,15],[8,0,8,1],[9,0,9,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[5,0,6,1],[14,0,14,1],[0,11,0,12],[0,0,0,7],[1,0,1,12],[5,2,5,5],[5,6,5,9],[5,10,5,13],[7,0,7,1],[10,0,10,1],[2,0,3,15],[11,0,11,1],[12,0,12,1],[16,0,16,1],[13,0,13,1],[24,0,24,5],[20,0,20,1],[21,0,21,1],[22,0,22,1]]}
["Budget Justification"]
["a. Personnel"]
["PLEASE READ!!!\n\nList costs solely for employees of the entity completing this form (award recipient or sub-recipient).  All other personnel costs (of subrecipients or other contractual efforts of the entity preparing this) must be included under f., Contractual.  This includes all consultants.\n\nIdentify positions to be supported.  Key personnel should be identified by title.  All other personnel should be identified either by title or a group category.  State the amounts of time (e.g., hours or % of time) to be expended, the composite base pay rate, total direct personnel compensation and identify the rate basis (e.g., actual salary, labor distribution report, technical estimate, state civil service rates, etc.).\n\nAdd rows as needed.  Formulas/calculations will need to be entered by the preparer of this form.  Please enter formulas as shown in the example."]
[]
[]
["Position Title",null,"Budget Period 1",null,null,null,"Budget Period 2",null,null,null,"Budget Period 3",null,null,null,"Project Total Dollars","Rate Basis"]
[null,null,"% of Time","Salary\n($/Yr)","% of\nYear","Total Budget Period 1","% of Time","Salary\n($/Yr)","% of Year","Total Budget Period 2","% of Time","Salary\n($/Yr)","% of Year","Total Budget Period 3"]
["EXAMPLE ONLY!!!  Sr. Engineer                           ",null,0.55000000000000004,76500,0.5,{"$f":"C8*D8*E8","v":21037.5},0.4,76500,0.5,{"$f":"G8*H8*I8","v":15300},0.6,76500,0.75,{"$f":"K8*L8*M8","v":34425},{"$f":"F8+J8+N8","v":70762.5},"Actual Salary"]
["EXAMPLE ONLY!!!  Electrical engineers",null,0.35,55500,0.4,{"$f":"C9*D9*E9","v":7770},0.4,55500,0.4,{"$f":"G9*H9*I9","v":8880},0.3,55500,0.25,{"$f":"K9*L9*M9","v":4162.5},20812.5,"Actual Salary"]
["EXAMPLE ONLY!!!  Technician         ",null,0.4,100000,1,{"$f":"C10*D10*E10","v":40000},0.4,100000,1,{"$f":"G10*H10*I10","v":40000},0.9,100000,0.5,{"$f":"K10*L10*M10","v":45000},125000,"Actual Salary"]
[null,null,null,null,null,{"$f":"C11*D11*E11","v":0},null,null,null,{"$f":"G11*H11*I11","v":0},null,null,null,{"$f":"K11*L11*M11","v":0},0]
[null,null,null,null,null,{"$f":"C12*D12*E12","v":0},null,null,null,{"$f":"G12*H12*I12","v":0},null,null,null,{"$f":"K12*L12*M12","v":0},0]
[null,null,null,null,null,0,null,null,null,{"$f":"G13*H13*I13","v":0},null,null,null,{"$f":"K13*L13*M13","v":0},0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
[null,null,null,null,null,0,null,null,null,0,null,null,null,0,0]
["Total Personnel Costs",null,null,null,null,{"$f":"SUM(F11:F22)","v":0},null,null,null,{"$f":"SUM(J11:J22)","v":0},null,null,null,{"$f":"SUM(N11:N22)","v":0},{"$f":"N23+J23+F23","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"b. Fringe","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[17,0,19,8],[7,0,7,8],[10,1,10,8],[13,1,13,8],[1,0,1,8],[3,0,3,2],[4,0,4,2],[5,0,5,2],[12,1,12,8],[3,6,3,7],[4,6,4,7],[5,6,5,7],[9,1,9,8],[0,0,0,4],[16,0,16,6]]}
["Budget Justification"]
["b. Fringe Benefits"]
[]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Total"]
["Rate applied:",null,null,0,0,0]
["Total fringe requested:",null,null,{"$f":"D5*'a. Personnel'!F23","v":0},{"$f":"E5*'a. Personnel'!J23","v":0},{"$f":"F5*'a. Personnel'!N23","v":0},{"$f":"SUM(D6:F6)","v":0}]
[]
["A federally approved fringe benefit rate agreement, or a proposed rate supported and agreed upon by the Ky Department for Energy Development and Independence for estimating purposes is required if reimbursement for fringe benefits is requested.  Please check (X) one of the options below and provide the requested information. "]
[]
[null,"A fringe benefit rate has been negotiated with, or approved by, a federal government agency."]
[]
[]
["","There is not a current, federally approved rate agreement negotiated and available.  "]
[null,"(When this option is checked, the entity preparing this form shall submit a rate proposal in the additional explanation/commets section below."]
[]
[]
["Additional explanation/comments (as necessary)"]

{"sheet":"c. Travel","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[41,0,47,6],[2,0,2,6],[0,5,0,6],[1,0,1,6],[0,0,0,2],[5,0,5,6],[14,0,14,6],[27,0,27,6]]}
["Budget Justification"]
["c. Travel"]
["PLEASE READ!!!\n\nProvide travel detail as requested below.  Purpose of travel are items such as professional conference, project management meeting, etc.  The Basis for Estimating Costs are items such as past trips, current quotations, Federal/State Travel Regulations, etc.   \n\nAll listed travel must be necessary for performance of the Scope of Work.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
["Purpose of travel","No. of Travelers","Destination ","No. of Days","Cost per Traveler","Cost per Trip","Basis for Estimating Costs"]
["Budget Period 1"]
["EXAMPLE ONLY!!!   Visit to PV cell mfr. to set up vendor agreement",2,"Washington, DC",2,650,{"$f":"E7*B7","v":1300},"Internet prices"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Budget Period 1 Total",null,null,null,null,{"$f":"SUM(F8:F13)","v":0}]
["Budget Period 2"]
[null,null,null,null,null,{"$f":"E16*B16","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Budget Period 2 Total",null,null,null,null,{"$f":"SUM(F16:F26)","v":0}]
["Budget Period 3"]
[null,null,null,null,null,{"$f":"E29*B29","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["Budget Period 3 Total",null,null,null,null,{"$f":"SUM(F29:F37)","v":0}]
["PROJECT TOTAL",null,null,null,null,{"$f":"F14+F27+F38","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"d. Equipment","index":4,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,0,34,5],[0,0,0,3],[1,0,1,5],[13,0,13,5],[20,0,20,5],[2,0,2,5],[5,0,5,5],[31,0,31,3]]}
["Budget Justification"]
["d. Equipment"]
["PLEASE READ!!!\n\nEquipment is defined as an item with an acquisition cost greater than $5,000 and a useful life expectancy of more than one year.\n\nList all proposed equipment below, providing a basis of cost such as vendor quotes, catalog prices, prior invoices, etc., and briefly justifying its need as it applies to the project.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
["Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!   Thermal shock chamber",2,20000,{"$f":"B7*C7","v":40000},"Vendor Quote","Reliability testing of PV modules- Task 4.3"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 1 Total",null,null,{"$f":"SUM(D8:D12)","v":0}]
["Budget Period 2"]
[null,null,null,{"$f":"B15*C15","v":0}]
[null,null,null,{"$f":"B16*C16","v":0}]
[null,null,null,{"$f":"B17*C17","v":0}]
[null,null,null,{"$f":"B18*C18","v":0}]
[null,null,null,{"$f":"B19*C19","v":0}]
["Budget Period 2 Total",null,null,{"$f":"SUM(D15:D19)","v":0}]
["Budget Period 3"]
[null,null,null,{"$f":"B22*C22","v":0}]
[null,null,null,{"$f":"B23*C23","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Budget Period 3 Total",null,null,{"$f":"SUM(D22:D28)","v":0}]
["PROJECT TOTAL",null,null,{"$f":"D13+D20+D29","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"e. Supplies","index":5,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[37,0,39,5],[0,0,0,3],[1,0,1,5],[25,0,25,5],[2,0,2,5],[5,0,5,5],[15,0,15,5],[36,0,36,2]]}
["Budget Justification"]
["e. Supplies"]
["PLEASE READ!!!\n\nSupplies are generally defined as an item with an acquisition cost of $5,000 or less and a useful life expectancy of less than one year.  Supplies are generally consumed during the project performance.\n\nList all proposed supplies below, providing a basis of cost such as vendor quotes, catalog prices, prior invoices, etc., and briefly justifying the need for the supplies as they apply to the Scope of Work.  Note that Supply items must be direct costs to the project at this budget category, and not duplicative of supply costs included in the indirect pool that is the basis of the indirect rate applied for this project.  Office supplies such as paper, pencils, staplers, etc. are normally charged to the indirect pool.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. \n"]
[]
["General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!  Wireless DAS components",10,360,3600,"Catalog price","For Alpha prototype - Task 2.4"]
[null,null,null,{"$f":"B8*C8","v":0}]
[null,null,null,{"$f":"B9*C9","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B12*C12","v":0}]
[null,null,null,0]
[null,null,null,0]
["Budget Period 1 Total",null,null,{"$f":"SUM(D8:D14)","v":0}]
["Budget Period 2"]
[null,null,null,{"$f":"B17*C17","v":0}]
[null,null,null,{"$f":"B18*C18","v":0}]
[null,null,null,{"$f":"B19*C19","v":0}]
[null,null,null,0]
[null,null,null,{"$f":"B21*C21","v":0}]
[null,null,null,{"$f":"B22*C22","v":0}]
[null,null,null,0]
[null,null,null,0]
["Budget Period 2 Total",null,null,{"$f":"SUM(D17:D24)","v":0}]
["Budget Period 3"]
[null,null,null,{"$f":"B27*C27","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]
["Budget Period 3 Total",null,null,{"$f":"SUM(D27:D33)","v":0}]
["PROJECT TOTAL",null,null,{"$f":"D34+D25+D15","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"f. Contractual","index":6,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[26,0,28,5],[0,0,0,1],[2,0,2,5],[1,0,1,5],[25,0,25,1],[3,0,3,5],[0,3,0,5]]}
["Budget Justification"]
["f. Contractual"]
["PLEASE READ!!!\n\nThe entity completing this form must provide all costs related to sub-recipients, vendors, contractors and consultants in the applicable boxes below.  \n\nSub-recipients (partners, sub-awardees): \nThe support to justify the budgets of sub-recipients may be in any format, and at a minimum should provide what task(s) are being performed, the purpose/need for the effort, and a basis of the estimated costs that is considered sufficient for the Department for Energy Development and Independence evaluation.\n"]
["Vendors (includes contractors and consultants):\nList all vendors, contractors and consultants supplying commercial supplies or services used to support the project.  The support to justify vendor  costs (in any amount) should provide the purpose for the products or services and a basis of the estimated costs that is considered sufficient for the Department for Energy Development and Independence evaluation.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer. "]
[]
[]
["Sub-Recipient\nName/Organization","Purpose/Tasks","Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
["EXAMPLE ONLY!!!  Big State University (BSU)","Setup and manage Energy Efficiency program for BSU.",48000,32000,16000,{"$f":"SUM(C8:E8)","v":96000}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Sub-total",{"$f":"SUM(C9:C13)","v":0},{"$f":"SUM(D9:D13)","v":0},{"$f":"SUM(E9:E12)","v":0},{"$f":"SUM(F9:F13)","v":0}]
[]
["Vendor \nName/Organization","Product or Service, Purpose/Need and Basis of Cost\n(Provide additional support at bottom of page as needed)","Budget Period 1\nCosts","Budget Period 2\nCosts","Budget Period 3\nCosts","Project Total"]
["EXAMPLE ONLY!!!  ABC Corp.","Contract with consultant for delivery of 5 one-day workshops for Energy Efficiency annually.",7500,7500,7500,{"$f":"SUM(C17:E17)","v":22500}]
[null,null,null,null,null,{"$f":"SUM(C18:E18)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C19:E19)","v":0}]
[null,null,null,null,null,{"$f":"SUM(C20:E20)","v":0}]
[null,null,{"$f":"SUM(C18:C20)","v":0},{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},{"$f":"SUM(F18:F20)","v":0}]
[]
[]
["Total Contractual",null,{"$f":"C21+C14","v":0},{"$f":"D21+D14","v":0},{"$f":"E21+E14","v":0},{"$f":"F21+F14","v":0}]
[]
["AdditionalExplanations/Comments (as necessary)"]

{"sheet":"g. Construction","index":7,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,0,14,3],[19,0,19,3],[27,0,29,3],[1,0,1,3],[5,0,5,3],[4,0,4,3],[2,0,2,3],[8,0,8,3]]}
["Budget Justification"]
["g. Construction"]
["PLEASE READ!!!\n\nConstruction, for the purpose of budgeting, is defined as all types of work done on a particular building, including erecting, altering, or remodeling.  Construction conducted by the award recipient is entered on this page.  Any construction work that is performed by a vendor or subrecipient to the award recipient should be entered under f. Contractual.\n\nList all proposed construction below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the Scope of Work.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["Overall description of construction actiivities:"]
["Example Only!!! - Build wind turbine platform "]
[]
["General Description","Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["Three days of excavation for platform site\nEXAMPLE ONLY!!!",28000,"Engineering estimate","Site must be prepared for construction of platform."]
[]
[]
[]
["Budget Period 1 Total",{"$f":"SUM(B11:B13)","v":0}]
["Budget Period 2"]
[]
[]
[]
["Budget Period 2 Total",{"$f":"SUM(B16:B18)","v":0}]
["Budget Period 3"]
[]
[]
[]
["Budget Period 3 Total",{"$f":"SUM(B21:B23)","v":0}]
["PROJECT TOTAL",{"$f":"B14+B19+B24","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"h. Other","index":8,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1],[39,0,41,3],[1,0,1,3],[24,0,24,3],[2,0,2,3],[5,0,5,3],[12,0,12,3],[38,0,38,2]]}
["Budget Justification"]
["h. Other Direct Costs"]
["PLEASE READ!!!\n\nOther direct costs are direct cost items required for the project which do not fit clearly into other categories, and are not included in the indirect pool for which the indirect rate is being applied to this project.  Examples are meeting costs, postage, couriers or express mail, telephone/fax costs, printing costs, etc.\n\nBasis of cost are items such as vendor quotes, prior purchases of similar or like items, published price list, etc.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["General description"," Cost             ","Basis of Cost","Justification of need"]
["Budget Period 1"]
["EXAMPLE ONLY!!!  Grad student tuition",16000,"Established UCD costs","Support of graduate students working on project "]
[]
[]
[]
[]
["Budget Period 1 Total",{"$f":"SUM(B8:B11)","v":0}]
["Budget Period 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Budget Period 2 Total",{"$f":"SUM(B14:B23)","v":0}]
["Budget Period 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Budget Period 3 Total",{"$f":"SUM(B26:B35)","v":0}]
["PROJECT TOTAL",{"$f":"B36+B24+B12","v":0}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"i. Indirect","index":9,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,7,0,8],[16,0,16,6],[17,0,19,8],[6,0,6,8],[9,1,9,8],[11,1,11,8],[10,1,10,8],[12,1,12,8],[4,0,4,2],[2,6,2,7],[3,6,3,7],[4,6,4,7],[1,0,1,8],[2,0,2,2],[3,0,3,2]]}
["Budget Justification"]
["i. Indirect Costs"]
[null,null,null,"Budget Period 1","Budget Period 2","Budget Period 3","Total"]
["Rate applied:",null,null,0,0,0]
["Total indirect costs requested:",null,null,null,null,null,{"$f":"SUM(D5:F5)","v":0}]
[]
["A federally approved indirect rate agreement, or rate proposed supported and agreed upon by the Ky Department for Energy Development and Independence for estimating purposes is required if reimbursement of indirect costs is requested.  Please check (X) one of the options below and provide the requested information if it has not already been provided as requested, or has changed.      The Ky Department for Energy Development and Indpendence may require the use of a rate lower than a federally approved rate."]
[]
[]
[null,"There is a federally approved indirect rate agreement.  A copy will be retained in the award recipient's files and will be provided electronically to the Ky Department for Energy Development and Independence upon request.  "]
[null,"(When this option is selected, a presentation of the budget that demonstrates the application of the approved rate, to arrive at the proposed indirect charges proposed should also be provided.)"]
[null,"There is no current, federally-approved indirect rate agreement. "]
[null,"(When this option is checked, an indirect cost rate agreement may be negotiated with the Ky Department for Energy Development and Independence.)"]
[]
[]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"j. Cost Share","index":10,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[[0,0,0,3],[1,0,1,6],[17,0,19,6],[3,0,3,6],[2,0,2,6],[16,0,16,2],[13,4,13,5],[14,3,14,5],[14,0,14,1],[0,4,0,6]]}
["Budget Justification"]
["j. Cost Share/Match Funding"]
["PLEASE READ!!!\n\nA detailed presentation of the cash or cash value of all cost share/match funding proposed for the project must be provided in the table below.  Identify the source & amount of each item of cost share/match funding proposed by the award recipient and each sub-recipient or vendor.  Letters of committment must be submitted for all third party cost share/match funding (other than award recipient).\n\nNote that “cost-share/match funding\" is not limited to cash investment.  Other items that may be assigned value in a budget as incurred as part of the project budget and necessary to performance of the project, may be considered as cost share/match funding, such as: contribution of services or property; donated, purchased or existing equipment; buildings or land; donated, purchased or existing supplies; and/or unrecovered personnel, fringe benefits and indirect costs, etc. For each cost share/match funding contribution identified as other than cash, identify the item and describe how the value of the cost share/match funding contribution was calculated. \n"]
["Funds from other Federal sources MAY NOT be counted as cost share/match funding.  Non-Federal sources include private, state or local Government, or any source not originally derived from Federal funds.  Documentation of cost sharing/match funding commitments must be provided, if not already provided with the original application and they have not changed since its submission.\n\nFee or profit will not be paid to the award recipients or subrecipients of awards.  Additionally, foregone fee or profit by the applicant shall not be considered cost sharing/match funding under any resulting award.  If applicable, reimbursement of actual costs will only include those costs that are allowable and allocable to the project as determined in accordance with the applicable cost principles prescribed in 10 CFR 600.127, 10 CFR 600.222 or 10 CFR 600.317.  Also see 10 CFR 600.318 relative to profit or fee.\n\nAdd rows as needed.  If rows are added, formulas/calculations may need to be adjusted by the preparer."]
[]
["Organization/Source                 ","Type \n(cash or other) ","Cost Share/Match Funding Item ","Budget Period 1\nCost Share/                 Match Funding","Budget Period 2\nCost Share/                 Match Funding","Budget Period 3\nCost Share/                 Match Funding","Total Project Cost Share/ Match Funding"]
["ABC Company\nEXAMPLE ONLY!!!","Cash","Project partner ABC Company will provide 40 PV modules for product development at 50% off the of the retail price of $680",13600,null,null,{"$f":"SUM(D7:F7)","v":13600}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,"Totals",{"$f":"SUM(D8:D12)","v":0},{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G8:G12)","v":0}]
[]
["Total Project Cost:  ",null,{"$f":"'Instructions and Summary'!E26","v":0},"Cost Share/Match Funding Percent of Award:",null,null,{"$f":"G13/C15","v":{"$error":"#DIV/0!"}}]
[]
["Additional Explanations/Comments (as necessary)"]

{"sheet":"SF-424A","index":11,"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'!D13","v":0},{"$f":"SUM(D8:G8)","v":0}]
["2.","Budget period 2",null,null,null,{"$f":"E26-G9","v":0},{"$f":"'j. Cost Share'!E13","v":0},{"$f":"SUM(D9:G9)","v":0}]
["3.","Budget period 3",null,null,null,{"$f":"F26-'j. Cost Share'!F13","v":0},{"$f":"'j. Cost Share'!F13","v":0},{"$f":"SUM(D10:G10)","v":0}]
["4.",null,null,null,null,null,null,{"$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":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,"Budget period 1","Budget period 2","Budget period 3","(4)"]
[null,"a.  Personnel",null,{"$f":"'Instructions and Summary'!B12","v":0},{"$f":"'Instructions and Summary'!C12","v":0},{"$f":"'Instructions and Summary'!D12","v":0},null,{"$f":"SUM(D16:G16)","v":0}]
[null,"b.  Fringe Benefits",null,{"$f":"'Instructions and Summary'!B13","v":0},{"$f":"'Instructions and Summary'!C13","v":0},{"$f":"'Instructions and Summary'!D13","v":0},null,0]
[null,"c.  Travel",null,{"$f":"'Instructions and Summary'!B14","v":0},{"$f":"'Instructions and Summary'!C14","v":0},{"$f":"'Instructions and Summary'!D14","v":0},null,0]
[null,"d.  Equipment",null,{"$f":"'Instructions and Summary'!B15","v":0},{"$f":"'Instructions and Summary'!C15","v":0},{"$f":"'Instructions and Summary'!D15","v":0},null,0]
[null,"e.  Supplies",null,{"$f":"'Instructions and Summary'!B16","v":0},{"$f":"'Instructions and Summary'!C16","v":0},{"$f":"'Instructions and Summary'!D16","v":0},null,0]
[null,"f.  Contractual",null,{"$f":"'Instructions and Summary'!B20","v":0},{"$f":"'Instructions and Summary'!C20","v":0},{"$f":"'Instructions and Summary'!D20","v":0},null,0]
[null,"g.  Construction",null,{"$f":"'Instructions and Summary'!B21","v":0},{"$f":"'Instructions and Summary'!C21","v":0},{"$f":"'Instructions and Summary'!D21","v":0},null,0]
[null,"h.  Other",null,{"$f":"'Instructions and Summary'!B22","v":0},{"$f":"'Instructions and Summary'!C22","v":0},{"$f":"'Instructions and Summary'!D22","v":0},null,0]
[null,"i.  Total Direct Charges (sum of 6a-6h)",null,{"$f":"SUM(D16:D23)","v":0},{"$f":"SUM(E16:E23)","v":0},{"$f":"SUM(F16:F23)","v":0},{"$f":"SUM(G16:G23)","v":0},0]
[null,"j.  Indirect Charges",null,{"$f":"'Instructions and Summary'!B23","v":0},{"$f":"'Instructions and Summary'!C23","v":0},{"$f":"'Instructions and Summary'!D23","v":0},null,0]
[null,"k.  Totals (sum of 6i-6j)",null,{"$f":"SUM(D24:D25)","v":0},{"$f":"SUM(E24:E25)","v":0},{"$f":"SUM(F24:F25)","v":0},{"$f":"SUM(G24:G25)","v":0},{"$f":"SUM(H24:H25)","v":0}]
[]
["7.","Program Income",null,null,null,null,null,{"$f":"SUM(D28:G28)","v":0}]
[]
[null,null,null,null,null,null,null,"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,null,null,null,null,"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",null,null,null,null,null,{"$f":"SUM(E36:G36)","v":0}]
["9.","Budget period 2",null,null,null,null,null,{"$f":"SUM(E37:G37)","v":0}]
["10.","Budget period 3",null,null,null,null,null,{"$f":"SUM(E38:G38)","v":0}]
["11.",null,null,null,null,null,null,{"$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)"]
[null,null,null,null,"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"]
[]
[]
[]
[null,null,null,null,null,null,null,"SF-424A (Rev. 4-92) "]
["Previous Edition Usable",null,"              ",null,null,null,null,"Prescribed by OMB Circular A-102"]
[null,null,"Authorized for Local Reproduction"]