{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","FY 21-22","FY 22-23","Solicitation 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["CLIMATE SMART AGRICULTURE TECHNICAL ASSISTANCE GRANTS\nWork Plan and Budget Template Instructions"]
[]
["Use the Work Plan columns in to list the technical assistance activities that will be performed to achieve the objectives. The program objectives have been pre-filled to align with the objectives of the Climate Smart Agriculture Technical Assistance Grant Program and AB 2377. Project objectives must include Provide Outreach to Potential Applicants (Objective 1), Provide One-on-One Application Assistance (Objective 2), Provide One-on-One Implementation Assistance (Objective 4), and Adminstrative Tasks-Reporting and Invoicing (Objective 8). The additional Objectives (3, 5, 6, 7, 9) may be included in the project and are intended to provide flexibility to a technical assistance awardee if the demand for implementation assistance is low. If funding for an Objective is not being requested, indicate \"N/A\" or \"Not Applicable\" in the Activities column.\n\n  • Objective: All technical assistance funding awardees must participate in Objective 1, 2, 4, and 8, but other Objectives have been provided as allowable to be funded through the CSA TA program associated with any funding allocated in 2021.\n  • Activities: Describe the tasks necessary to accomplish each of the identified project objective(s). You may insert additional rows to include as many Activities as necessary to complete the project.\n  • Performed by: Identify the individuals who will do the work for each activity by title. All individuals for whom funding is requested must be identified.\n  • Timeline: Some estimated dates have been pre-filled for the CSA incentive program application timeframes. Applicants may adjust dates for other objectives. The grant term is expected to be February 1, 2022 to January 31, 2026. Activities cannot be reimbursed outside of the grant term."]
["Use the Budget columns to identify project costs (Personnel, Contractor/Consultant, Supplies, Travel, Other) that will support the specific Objective and Activity listed. All budgeted items should demonstrate they are reasonable and adequate for the proposed project. You may add additional rows for an Activity to include associated budget items if there are more than one per budget category. The Total Requested Grant Funds cannot exceed $60,000 per funding appropriation (2021-22, 2022-23), including indirect costs.\nMatching funds are not required by the Climate Smart Agriculture Technical Assistance Grants, but are encouraged. If providing, details must be included as indicated in the Types of Funds columns.\n\nThe \"Cost Summary\" table is a formula driven summary of all the costs associated with your project - do not input data in to the Cost Summary table."]

{"sheet":"FY 21-22","index":1,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,0,0,25],[12,0,12,3],[12,4,12,25],[13,3,14,3],[3,1,3,2],[4,1,4,2],[2,1,2,2],[6,1,6,2],[7,1,7,2],[13,21,13,24],[8,1,8,2],[63,0,68,0],[33,0,38,0],[39,0,44,0],[45,0,50,0],[13,12,13,14],[15,0,20,0],[9,1,9,2],[13,4,13,6],[13,8,13,10],[57,0,62,0],[51,0,56,0],[13,1,14,2],[21,0,26,0],[27,0,32,0],[13,0,14,0]]}
["CLIMATE SMART AGRICULTURE TECHNICAL ASSISTANCE GRANTS\n\nDirections: In the table below, list the work plan activities that will support each applicable objective and an estimate of when they will occur. For each activity, enter the associated budget information.\n   • Personnel or Contractor/Consultant: list the employees whose time and effort can be specifically identified and easily and accurately traced to the project activity; for each, include their title (e.g. accountant, Spanish translator), hours to be worked on the project and hourly rate, what type of funds are being used to pay for the individual.\n   • Supplies: list materials, supplies, and fabricated parts costing less than $5,000 per unit to be purchased; for each, include a description of the item and how it is necessary for the completion of the activity (all supplies and materials must be tied to specific project activities), cost per unit, number of units to be purchased, what type of funds are being used to pay for the items.\n   • Travel or Other: include a description of travel related expense or any expenses not covered in other budget categories and why it is necessary for the completion of the specific project activity, and what type of funds are being used to pay for the items.\n\nAll technical assistance funding awardees must participate in Objective 1 (Outreach), Objective 2 (Application Assistance), Objective 4 (Implementation Assistance), and Objective 8 (Reporting and Invoicing). The additional Objectives may be included in the project. If funding for an Objective is not being requested, indicate \"N/A\" or \"Not Applicable\" in the Activities column. \nYou may add additional rows for an Activity to include associated budget items if there are more than one per budget category. To do so, double-click an Activity Number cell (e.g. 1.1) and an additional row will appear below."]
[]
["Applicant ID:"]
["Organization Name:"]
["CSA Program Name (AMMP):"]
["COST SUMMARY"]
["Subtotal of Direct Costs:",{"$f":"U14","v":0}]
["Indirect Costs*:",{"$f":"B7*0.3","v":0}]
["Total Requested Grant Funds",{"$f":"B7+B8","v":0}]
["Total Matching Funds:",{"$f":"Z14","v":0}]
["*University of California and California State University may claim their established indirect cost rate with CDFA. \nAll other eligible organizations for Climate Smart Agriculture technical assistance may claim an indirect cost rate not to exceed 20 percent of total direct costs."]
[]
["WORK PLAN",null,null,null,"BUDGET (Direct Costs)"]
["Objective \n(Required)","Activities \n(Provide a numbered list describing each activity that will support the objective)",null,"Estimated Timeline (Month, Year - Month, Year)","Personnel",null,null,{"$f":"SUM(H16:H75)","v":0},"Contractor/Consultant",null,null,{"$f":"SUM(L16:L75)","v":0},"Supplies",null,null,{"$f":"SUM(P16:P75)","v":0},"Travel",{"$f":"SUM(R16:R75)","v":0},"Other",{"$f":"SUM(T16:T75)","v":0},{"$f":"SUM(U16:U75)","v":0},"Type of Funds",null,null,null,{"$f":"SUM(Z16:Z75)","v":0}]
[null,null,null,null,"Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Item Description","Cost per Unit","Number of Units","Total","Item Description","Total","Item Description","Total","Requested Grant Funds","Matching (Cash)","In-Kind","Other State or Federal","Other","Total Matching"]
["1. Provide outreach to potential applicants (Timeframe should be between February - April 2022)",1.1000000000000001,null,null,null,null,null,{"$f":"F16*G16","v":0},null,null,null,{"$f":"J16*K16","v":0},null,null,null,{"$f":"N16*O16","v":0},null,null,null,null,{"$f":"SUM(H16,L16,P16,R16,T16)-Z16","v":0},null,null,null,null,{"$f":"SUM(V16:Y16)","v":0}]
[null,1.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["2. Provide one-on-one application assistance (Time frame should be between February - April 2022)",2.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2000000000000002,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2999999999999998,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["3. Assist awardees with Grant Agreement establishment (Time frame estimated as May 2022-July 2022)",3.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["4. Provide one-on-one implementation assistance (Timeframe estimated as July 2022-February 2025)",4.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.4000000000000004,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["5. Provide Climate Smart Agriculture (AMMP) relevant training to agricultural operation staff (anytime during TA agreement)",5.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["6. Prepare case studies noting outcomes and benefits of AMMP grants (anytime during TA agreement)",6.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.3,null,null,null,null,null,{"$f":"F48*G48","v":0},null,null,null,{"$f":"J48*K48","v":0},null,null,null,{"$f":"N48*O48","v":0},null,null,null,null,{"$f":"SUM(H48,L48,P48,R48,T48)-Z48","v":0},null,null,null,null,{"$f":"SUM(V48:Y48)","v":0}]
[null,6.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["7. Consult with unawarded farmers and ranchers to improve the competitiveness of the applications (anytime during TA agreement)",7.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["8. TA Agreement Administrative Tasks including Reporting and Invoicing (Time frame should be between February 2022 - January 2026).\n Do not duplicate expenditures on \"FY 22-23\" tab",8.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["9. Other Objectives within the scope of the CSA Program (anytime during grant agreement)",8.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]

{"sheet":"FY 22-23","index":2,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":false,"merged":[[7,1,7,2],[0,0,0,25],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,1,6,2],[8,1,8,2],[9,1,9,2],[12,0,12,3],[12,4,12,25],[13,0,14,0],[13,1,14,2],[13,3,14,3],[13,4,13,6],[13,8,13,10],[13,12,13,14],[45,0,50,0],[51,0,56,0],[57,0,62,0],[63,0,68,0],[13,21,13,24],[15,0,20,0],[21,0,26,0],[27,0,32,0],[33,0,38,0],[39,0,44,0]]}
["CLIMATE SMART AGRICULTURE TECHNICAL ASSISTANCE GRANTS\n\nDirections: In the table below, list the work plan activities that will support each applicable objective and an estimate of when they will occur. For each activity, enter the associated budget information.\n   • Personnel or Contractor/Consultant: list the employees whose time and effort can be specifically identified and easily and accurately traced to the project activity; for each, include their title (e.g. accountant, Spanish translator), hours to be worked on the project and hourly rate, what type of funds are being used to pay for the individual.\n   • Supplies: list materials, supplies, and fabricated parts costing less than $5,000 per unit to be purchased; for each, include a description of the item and how it is necessary for the completion of the activity (all supplies and materials must be tied to specific project activities), cost per unit, number of units to be purchased, what type of funds are being used to pay for the items.\n   • Travel or Other: include a description of travel related expense or any expenses not covered in other budget categories and why it is necessary for the completion of the specific project activity, and what type of funds are being used to pay for the items.\n\nAll technical assistance funding awardees must participate in Objective 1 (Outreach), Objective 2 (Application Assistance), Objective 4 (Implementation Assistance), and Objective 8 (Reporting and Invoicing). The additional Objectives may be included in the project. If funding for an Objective is not being requested, indicate \"N/A\" or \"Not Applicable\" in the Activities column. \nYou may add additional rows for an Activity to include associated budget items if there are more than one per budget category. To do so, double-click an Activity Number cell (e.g. 1.1) and an additional row will appear below."]
[]
["Applicant ID:"]
["Organization Name:"]
["CSA Program Name (AMMP):"]
["COST SUMMARY"]
["Subtotal of Direct Costs:",{"$f":"U14","v":0}]
["Indirect Costs*:",{"$f":"B7*0.3","v":0}]
["Total Requested Grant Funds",{"$f":"B7+B8","v":0}]
["Total Matching Funds:",{"$f":"Z14","v":0}]
["*University of California and California State University may claim their established indirect cost rate with CDFA. \nAll other eligible organizations for Climate Smart Agriculture technical assistance may claim an indirect cost rate not to exceed 20 percent of total direct costs."]
[]
["WORK PLAN",null,null,null,"BUDGET (Direct Costs)"]
["Objective \n(Required)","Activities \n(Provide a numbered list describing each activity that will support the objective)",null,"Estimated Timeline (Month, Year - Month, Year)","Personnel",null,null,{"$f":"SUM(H16:H75)","v":0},"Contractor/Consultant",null,null,{"$f":"SUM(L16:L75)","v":0},"Supplies",null,null,{"$f":"SUM(P16:P75)","v":0},"Travel",{"$f":"SUM(R16:R75)","v":0},"Other",{"$f":"SUM(T16:T75)","v":0},{"$f":"SUM(U16:U75)","v":0},"Type of Funds",null,null,null,{"$f":"SUM(Z16:Z75)","v":0}]
[null,null,null,null,"Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Item Description","Cost per Unit","Number of Units","Total","Item Description","Total","Item Description","Total","Requested Grant Funds","Matching (Cash)","In-Kind","Other State or Federal","Other","Total Matching"]
["1. Provide outreach to potential applicants  (Timeframe should be between February 2022 - August 2022)",1.1000000000000001,null,null,null,null,null,{"$f":"F16*G16","v":0},null,null,null,{"$f":"J16*K16","v":0},null,null,null,{"$f":"N16*O16","v":0},null,null,null,null,{"$f":"SUM(H16,L16,P16,R16,T16)-Z16","v":0},null,null,null,null,{"$f":"SUM(V16:Y16)","v":0}]
[null,1.2,null,null,null,null,null,{"$f":"F17*G17","v":0},null,null,null,{"$f":"J17*K17","v":0},null,null,null,{"$f":"N17*O17","v":0},null,null,null,null,{"$f":"SUM(H17,L17,P17,R17,T17)-Z17","v":0},null,null,null,null,{"$f":"SUM(V17:Y17)","v":0}]
[null,1.3,null,null,null,null,null,{"$f":"F18*G18","v":0},null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.5,null,null,null,null,null,{"$f":"F20*G20","v":0},null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["2. Provide one-on-one application assistance (Time frame should be between August 2022 - October 2022)",2.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2000000000000002,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2999999999999998,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["3. Assist awardees with Grant Agreement establishment (estimated for October 2022-December 2022)",3.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["4. Provide one-on-one implementation assistance (estimated for January 2023 - January 2026)",4.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.4000000000000004,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["5. Provide Climate Smart Agriculture (AMMP) relevant training to agricultural operation staff (anytime during grant agreement term)",5.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["6. Prepare case studies noting outcomes and benefits of AMMP grants (anytime during grant agreement term)",6.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["7. Consult with unawarded farmers and ranchers to improve the competitiveness of the applications (anytime during grant agreement term)",7.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["TA Agreement Administrative Tasks including Reporting and Invoicing (Time frame should be between February 2022 - January 2026). \nDo not duplicate expenditures on \"FY 21-22\" tab",8.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["9. Other Objectives within the scope of the CSA Program (anytime during grant agreement)",9.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H69,L69,P69,R69,T69)-Z69","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H70,L70,P70,R70,T70)-Z70","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H71,L71,P71,R71,T71)-Z71","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]

{"sheet":"Solicitation 2","index":3,"n_rows":75,"n_cols":26,"rows_kept":75,"cut":false,"hidden":true,"merged":[[45,0,50,0],[51,0,56,0],[57,0,62,0],[63,0,68,0],[13,21,13,24],[15,0,20,0],[21,0,26,0],[27,0,32,0],[33,0,38,0],[39,0,44,0],[8,1,8,2],[9,1,9,2],[12,0,12,3],[12,4,12,25],[13,0,14,0],[13,1,14,2],[13,3,14,3],[13,4,13,6],[13,8,13,10],[13,12,13,14],[7,1,7,2],[0,0,0,25],[2,1,2,2],[3,1,3,2],[4,1,4,2],[6,1,6,2]]}
["CLIMATE SMART AGRICULTURE TECHNICAL ASSISTANCE GRANTS\n\nDirections: In the table below, list the work plan activities that will support each applicable objective and an estimate of when they will occur. For each activity, enter the associated budget information.\n   • Personnel or Contractor/Consultant: list the employees whose time and effort can be specifically identified and easily and accurately traced to the project activity; for each, include their title (e.g. accountant, Spanish translator), hours to be worked on the project and hourly rate, what type of funds are being used to pay for the individual.\n   • Supplies: list materials, supplies, and fabricated parts costing less than $5,000 per unit to be purchased; for each, include a description of the item and how it is necessary for the completion of the activity (all supplies and materials must be tied to specific project activities), cost per unit, number of units to be purchased, what type of funds are being used to pay for the items.\n   • Travel or Other: include a description of travel related expense or any expenses not covered in other budget categories and why it is necessary for the completion of the specific project activity, and what type of funds are being used to pay for the items.\n\nAll technical assistance funding awardees must participate in Objective 1 (Outreach), Objective 2 (Application Assistance), Objective 4 (Implementation Assistance), and Objective 8 (Reporting and Invoicing). The additional Objectives may be included in the project. If funding for an Objective is not being requested, indicate \"N/A\" or \"Not Applicable\" in the Activities column. \nYou may add additional rows for an Activity to include associated budget items if there are more than one per budget category. To do so, double-click an Activity Number cell (e.g. 1.1) and an additional row will appear below."]
[]
["Applicant ID:"]
["Organization Name:"]
["CSA Program Name (HSP or SWEEP):"]
["COST SUMMARY"]
["Subtotal of Direct Costs:",{"$f":"U14","v":0}]
["Indirect Costs*:",{"$f":"B7*0.25","v":0}]
["Total Requested Grant Funds",{"$f":"B7+B8","v":0}]
["Total Matching Funds:",{"$f":"Z14","v":0}]
["*University of California and California State University may claim their established indirect cost rate with CDFA. \nAll other eligible organizations for Climate Smart Agriculture technical assistance may claim an indirect cost rate not to exceed 20 percent of total direct costs."]
[]
["WORK PLAN",null,null,null,"BUDGET (Direct Costs)"]
["Objective \n(Required)","Activities \n(Provide a numbered list describing each activity that will support the objective)",null,"Estimated Timeline (Month, Year - Month, Year)","Personnel",null,null,{"$f":"SUM(H16:H75)","v":0},"Contractor/Consultant",null,null,{"$f":"SUM(L16:L75)","v":0},"Supplies",null,null,{"$f":"SUM(P16:P75)","v":0},"Travel",{"$f":"SUM(R16:R75)","v":0},"Other",{"$f":"SUM(T16:T75)","v":0},{"$f":"SUM(U16:U75)","v":0},"Type of Funds",null,null,null,{"$f":"SUM(Z16:Z75)","v":0}]
[null,null,null,null,"Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Performed By (Title)","Work Hours","Hourly Rate ($)","Total","Item Description","Cost per Unit","Number of Units","Total","Item Description","Total","Item Description","Total","Requested Grant Funds","Matching (Cash)","In-Kind","Other State or Federal","Other","Total Matching"]
["1. Provide outreach to potential applicants",1.1000000000000001,null,null,null,null,null,{"$f":"F16*G16","v":0},null,null,null,{"$f":"J16*K16","v":0},null,null,null,{"$f":"N16*O16","v":0},null,null,null,null,{"$f":"SUM(H16,L16,P16,R16,T16)-Z16","v":0},null,null,null,null,{"$f":"SUM(V16:Y16)","v":0}]
[null,1.2,null,null,null,null,null,{"$f":"F17*G17","v":0},null,null,null,{"$f":"J17*K17","v":0},null,null,null,{"$f":"N17*O17","v":0},null,null,null,null,{"$f":"SUM(H17,L17,P17,R17,T17)-Z17","v":0},null,null,null,null,{"$f":"SUM(V17:Y17)","v":0}]
[null,1.3,null,null,null,null,null,{"$f":"F18*G18","v":0},null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.5,null,null,null,null,null,{"$f":"F20*G20","v":0},null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,1.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["2. Provide one-on-one application assistance (Time frame should be between December 2021 - February 2022)",2.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2000000000000002,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.2999999999999998,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,2.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["3. Assist awardees with Grant Agreement establishment",3.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,3.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["4. Provide one-on-one implementation assistance",4.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.4000000000000004,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,4.5999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["5. Provide Climate Smart Agriculture (HSP or SWEEP) relevant training to agricultural operation staff",5.0999999999999996,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,5.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["6. Prepare case studies noting outcomes and benefits of CSA grants",6.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,6.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["7. Consult with unawarded farmers and ranchers to improve the competitiveness of the applications",7.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.2,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.3,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,7.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["8. Reporting and Invoicing (Time frame should be between June 1, 2021 - May 31, 2024)",8.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,8.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
["9. Other Objectives within the scope of the CSA Program",9.1,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.1999999999999993,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.3000000000000007,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.4,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.5,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,9.6,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H69,L69,P69,R69,T69)-Z69","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H70,L70,P70,R70,T70)-Z70","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,{"$f":"SUM(H71,L71,P71,R71,T71)-Z71","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,0,null,null,null,null,0]