{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Total Project Costs","Year 1","Year 2","Year 3","Year 4","Year 5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Total Project Costs","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Funding Opportunity Announcement Number DE-FOA-0003045 "]
["Energy Improvement in Rural or Remote Areas Fixed Award Grant Program"]
[]
["Control Number:","3045-1234"]
["Prime Recipient:","ABC Corp."]
["Date of Submission:","--/--/--"]
["Proposed Period of Performance","1/1/2024 - 12/31/2028"]
[]
["Cost Category","Year 1","Year 2","Year 3","Year 4","Year 5","Total"]
["Direct Labor",{"$f":"'Year 1'!F9","v":200000},{"$f":"'Year 2'!F9","v":0},{"$f":"'Year 3'!F9","v":0},{"$f":"'Year 4'!F9","v":0},{"$f":"'Year 5'!F9","v":0},{"$f":"SUM(B10:F10)","v":200000}]
["Direct Materials/Supplies ",{"$f":"'Year 1'!F10","v":75000},{"$f":"'Year 2'!F10","v":0},{"$f":"'Year 3'!F10","v":0},{"$f":"'Year 4'!F10","v":0},{"$f":"'Year 5'!F10","v":0},{"$f":"SUM(B11:F11)","v":75000}]
["Equipment",{"$f":"'Year 1'!F11","v":0},{"$f":"'Year 2'!F11","v":0},{"$f":"'Year 3'!F11","v":0},{"$f":"'Year 4'!F11","v":0},{"$f":"'Year 5'!F11","v":0},0]
["Contracted Work",{"$f":"'Year 1'!F12","v":345000},{"$f":"'Year 2'!F12","v":0},{"$f":"'Year 3'!F12","v":0},{"$f":"'Year 4'!F12","v":0},{"$f":"'Year 5'!F12","v":0},345000]
["Other Direct Costs",{"$f":"'Year 1'!F13","v":10000},{"$f":"'Year 2'!F13","v":0},{"$f":"'Year 3'!F13","v":0},{"$f":"'Year 4'!F13","v":0},{"$f":"'Year 5'!F13","v":0},10000]
["Indirect Costs",{"$f":"'Year 1'!F14","v":5000},{"$f":"'Year 2'!F14","v":0},{"$f":"'Year 3'!F14","v":0},{"$f":"'Year 4'!F14","v":0},{"$f":"'Year 5'!F14","v":0},5000]
["Other ",{"$f":"'Year 1'!F15","v":25000},{"$f":"'Year 2'!F15","v":0},{"$f":"'Year 3'!F15","v":0},{"$f":"'Year 4'!F15","v":0},{"$f":"'Year 5'!F15","v":0},25000]
[{"$nulls":6},0]
["Total",{"$f":"SUM(B10:B16)","v":660000},{"$f":"SUM(C10:C16)","v":0},{"$f":"SUM(D10:D16)","v":0},{"$f":"SUM(E10:E16)","v":0},{"$f":"SUM(F10:F16)","v":0},{"$f":"SUM(B18:F18)","v":660000}]

{"sheet":"Year 1","index":1,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,0,79,6],[3,0,5,5],[18,0,19,6],[21,0,34,6],[36,0,49,6],[51,0,64,6]]}
["Project Year:",1]
["Proposed Project Period","1/1/2024 - 12/31/2024"]
[]
["Instructions: For each milestone, provide the cost for each cost category. Add milestones as necessary through the completion of the project."]
[]
[]
[]
["Cost Category","Milestone 1","Milestone 2","Milestone 3","Milestone 4","Total"]
["Direct Labor",75000,50000,25000,50000,{"$f":"SUM(B9:E9)","v":200000}]
["Direct Materials/Supplies",50000,25000,0,0,75000]
["Equipment",0,0,0,0,0]
["Contracted Work",25000,250000,50000,20000,345000]
["Other Direct Costs",0,0,5000,5000,10000]
["Indirect Costs",0,5000,0,0,5000]
["Other (Explain Below):",0,0,25000,0,25000]
[]
["Total",{"$f":"SUM(B9:B15)","v":150000},{"$f":"SUM(C9:C15)","v":330000},105000,75000,{"$f":"SUM(B17:E17)","v":660000}]
[]
["Instructions: For each milestone, provide a short narrative that describes the costs proposed for each cost category and a short description of how the applicant will know when milestones are met. "]
[]
[]
["Milestone 1:  EXAMPLE: This milestone covers planning and permitting for the solar panel installation project. The direct labor costs covers 8 months of fully loaded salary (pay + benefits) for the project manager for this period. The direct materials include off-the-shelf purchasing of tools and equipment required for the project that will not be provided by (or is less expensive to procure directly) the installation contractor. The contracted work here is for a planning and permitting consultant. This milestone will be met when permits are issued for the project."]
{"$rows_empty":14}
["Milestone 2:  EXAMPLE: This milestone covers installation of the solar array. The direct labor covers 6 months of fully loaded salary for the project manager for this period and the direct materials are for equipment purchased directly. The contracted work is to hire the installation contractor. This milestone will be met when installation is complete."]
{"$rows_empty":14}
["Milestone 3:  EXAMPLE: This milestone covers testing and evaluation of the solar array. The direct labor covers 3 months of the project manager's fully loaded salary. The contracted work covers testing and evaluation done by a 3rd party contractor. The other direct costs cover one trip to Washington, DC for a post-installation conference and lessons learned meetings. The other cost covers the cost for 3 months of engagement costs to ensure our community understands the benefits of the solar array. This milestone will be complete when the solar array is operational."]
{"$rows_empty":14}
["Milestone 4:  EXAMPLE: This milestone covers testing and evaluation of the solar array. The direct labor covers 3 months of the project manager's fully loaded salary. The contracted work covers testing and evaluation done by a 3rd party contractor. The other direct costs cover one trip to Washington, DC for a post-installation conference and lessons learned meetings. The other cost covers the cost for 3 months of engagement costs to ensure our community understands the benefits of the solar array. This milestone will be complete when the solar array is operational."]

{"sheet":"Year 2","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,0,79,6],[3,0,5,5],[18,0,19,6],[21,0,34,6],[36,0,49,6],[51,0,64,6]]}
["Project Year:",2]
["Proposed Project Period","TBD"]
[]
["Instructions: For each milestone, provide the cost for each cost category. Add milestones as necessary through the completion of the project."]
[]
[]
[]
["Cost Category","Milestone 1","Milestone 2","Milestone 3","Milestone 4","Total"]
["Direct Labor",0,0,0,0,{"$f":"SUM(B9:E9)","v":0}]
["Direct Materials/Supplies",0,0,0,0,0]
["Equipment",0,0,0,0,0]
["Contracted Work",0,0,0,0,0]
["Other Direct Costs",0,0,0,0,0]
["Indirect Costs",0,0,0,0,0]
["Other (Explain Below):",0,0,0,0,0]
[]
["Total",{"$f":"SUM(B9:B15)","v":0},{"$f":"SUM(C9:C15)","v":0},0,0,{"$f":"SUM(B17:E17)","v":0}]
[]
["Instructions: For each milestone, provide a short narrative that describes the costs proposed for each cost category and a short description of how the applicant will know when milestones are met. "]
[]
[]
["Milestone 1:  "]
{"$rows_empty":14}
["Milestone 2: "]
{"$rows_empty":14}
["Milestone 3:  "]
{"$rows_empty":14}
["Milestone 4:  "]

{"sheet":"Year 3","index":3,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,0,79,6],[3,0,5,5],[18,0,19,6],[21,0,34,6],[36,0,49,6],[51,0,64,6]]}
["Project Year:",3]
["Proposed Project Period","TBD"]
[]
["Instructions: For each milestone, provide the cost for each cost category. Add milestones as necessary through the completion of the project."]
[]
[]
[]
["Cost Category","Milestone 1","Milestone 2","Milestone 3","Milestone 4","Total"]
["Direct Labor",0,0,0,0,{"$f":"SUM(B9:E9)","v":0}]
["Direct Materials/Supplies",0,0,0,0,0]
["Equipment",0,0,0,0,0]
["Contracted Work",0,0,0,0,0]
["Other Direct Costs",0,0,0,0,0]
["Indirect Costs",0,0,0,0,0]
["Other (Explain Below):",0,0,0,0,0]
[]
["Total",{"$f":"SUM(B9:B15)","v":0},{"$f":"SUM(C9:C15)","v":0},0,0,{"$f":"SUM(B17:E17)","v":0}]
[]
["Instructions: For each milestone, provide a short narrative that describes the costs proposed for each cost category and a short description of how the applicant will know when milestones are met. "]
[]
[]
["Milestone 1:  "]
{"$rows_empty":14}
["Milestone 2: "]
{"$rows_empty":14}
["Milestone 3:  "]
{"$rows_empty":14}
["Milestone 4:  "]

{"sheet":"Year 4","index":4,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,0,79,6],[3,0,5,5],[18,0,19,6],[21,0,34,6],[36,0,49,6],[51,0,64,6]]}
["Project Year:",4]
["Proposed Project Period","TBD"]
[]
["Instructions: For each milestone, provide the cost for each cost category. Add milestones as necessary through the completion of the project."]
[]
[]
[]
["Cost Category","Milestone 1","Milestone 2","Milestone 3","Milestone 4","Total"]
["Direct Labor",0,0,0,0,{"$f":"SUM(B9:E9)","v":0}]
["Direct Materials/Supplies",0,0,0,0,0]
["Equipment",0,0,0,0,0]
["Contracted Work",0,0,0,0,0]
["Other Direct Costs",0,0,0,0,0]
["Indirect Costs",0,0,0,0,0]
["Other (Explain Below):",0,0,0,0,0]
[]
["Total",{"$f":"SUM(B9:B15)","v":0},{"$f":"SUM(C9:C15)","v":0},0,0,{"$f":"SUM(B17:E17)","v":0}]
[]
["Instructions: For each milestone, provide a short narrative that describes the costs proposed for each cost category and a short description of how the applicant will know when milestones are met. "]
[]
[]
["Milestone 1:  "]
{"$rows_empty":14}
["Milestone 2: "]
{"$rows_empty":14}
["Milestone 3:  "]
{"$rows_empty":14}
["Milestone 4:  "]

{"sheet":"Year 5","index":5,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[66,0,79,6],[3,0,5,5],[18,0,19,6],[21,0,34,6],[36,0,49,6],[51,0,64,6]]}
["Project Year:",5]
["Proposed Project Period","TBD"]
[]
["Instructions: For each milestone, provide the cost for each cost category. Add milestones as necessary through the completion of the project."]
[]
[]
[]
["Cost Category","Milestone 1","Milestone 2","Milestone 3","Milestone 4","Total"]
["Direct Labor",0,0,0,0,{"$f":"SUM(B9:E9)","v":0}]
["Direct Materials/Supplies",0,0,0,0,0]
["Equipment",0,0,0,0,0]
["Contracted Work",0,0,0,0,0]
["Other Direct Costs",0,0,0,0,0]
["Indirect Costs",0,0,0,0,0]
["Other (Explain Below):",0,0,0,0,0]
[]
["Total",{"$f":"SUM(B9:B15)","v":0},{"$f":"SUM(C9:C15)","v":0},0,0,{"$f":"SUM(B17:E17)","v":0}]
[]
["Instructions: For each milestone, provide a short narrative that describes the costs proposed for each cost category and a short description of how the applicant will know when milestones are met. "]
[]
[]
["Milestone 1:  "]
{"$rows_empty":14}
["Milestone 2: "]
{"$rows_empty":14}
["Milestone 3:  "]
{"$rows_empty":14}
["Milestone 4:  "]