{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Staffing Costs Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Staffing Costs Template","index":0,"n_rows":162,"n_cols":15,"rows_kept":162,"cut":false,"hidden":false,"merged":[[114,8,114,9],[92,0,93,0],[92,1,93,2],[92,3,93,3],[92,8,93,9],[102,0,103,0],[104,0,105,0],[84,4,85,4],[82,0,83,0],[82,1,83,2],[82,3,83,3],[112,8,113,9],[108,6,109,6],[110,6,111,6],[112,6,113,6],[110,7,111,7],[112,7,113,7],[94,1,95,2],[96,1,97,2],[90,0,91,0],[90,1,91,2],[90,3,91,3],[90,8,91,9],[88,6,89,6],[86,11,87,11],[88,11,89,11],[90,11,91,11],[92,11,93,11],[92,5,93,5],[94,0,95,0],[96,0,97,0],[98,0,99,0],[100,0,101,0],[86,4,87,4],[88,4,89,4],[90,4,91,4],[92,4,93,4],[92,6,93,6],[86,7,87,7],[92,10,93,10],[94,10,95,10],[96,10,97,10],[98,10,99,10],[100,10,101,10],[96,11,97,11],[98,11,99,11],[100,11,101,11],[94,11,95,11],[74,11,75,11],[76,11,77,11],[78,11,79,11],[80,11,81,11],[82,11,83,11],[84,11,85,11],[68,6,73,6],[74,6,75,6],[76,6,77,6],[68,8,73,9],[68,11,73,11],[82,8,83,9],[80,6,81,6],[82,6,83,6],[80,7,81,7],[82,7,83,7],[40,0,40,12],[44,2,44,12],[41,2,43,12],[60,12,61,14],[60,10,61,11],[60,6,61,9],[63,5,65,12],[66,5,66,12],[63,13,64,13],[65,13,66,13],[90,6,91,6],[88,7,89,7],[90,7,91,7],[84,0,85,0],[84,1,85,2],[84,3,85,3],[84,8,85,9],[86,0,87,0],[86,1,87,2],[86,3,87,3],[86,8,87,9],[84,6,85,6],[86,6,87,6],[84,7,85,7],[84,5,85,5],[86,5,87,5],[88,5,89,5],[90,5,91,5],[68,5,73,5],[88,0,89,0],[88,1,89,2],[88,3,89,3],[88,8,89,9],[82,5,83,5],[80,4,81,4],[82,4,83,4],[76,5,77,5],[68,0,73,0],[68,7,73,7],[74,0,75,0],[74,1,75,2],[74,3,75,3],[74,8,75,9],[74,7,75,7],[80,0,81,0],[68,1,73,2],[68,3,73,3],[68,4,73,4],[80,1,81,2],[80,3,81,3],[80,8,81,9],[74,4,75,4],[74,5,75,5],[78,5,79,5],[80,5,81,5],[76,0,77,0],[76,1,77,2],[76,3,77,3],[76,8,77,9],[78,0,79,0],[78,1,79,2],[78,3,79,3],[78,8,79,9],[78,6,79,6],[76,7,77,7],[78,7,79,7],[76,4,77,4],[78,4,79,4],[112,12,113,12],[63,14,64,14],[65,14,66,14],[106,0,107,0],[108,0,109,0],[110,0,111,0],[112,0,113,0],[68,12,73,12],[74,12,75,12],[68,10,73,10],[74,10,75,10],[76,10,77,10],[78,10,79,10],[80,10,81,10],[82,10,83,10],[84,10,85,10],[86,10,87,10],[88,10,89,10],[90,10,91,10],[94,8,95,9],[96,8,97,9],[98,8,99,9],[100,8,101,9],[102,8,103,9],[94,12,95,12],[96,12,97,12],[98,12,99,12],[100,12,101,12],[102,12,103,12],[104,12,105,12],[106,12,107,12],[108,12,109,12],[110,12,111,12],[76,12,77,12],[78,12,79,12],[80,12,81,12],[82,12,83,12],[84,12,85,12],[86,12,87,12],[88,12,89,12],[90,12,91,12],[92,12,93,12],[102,10,103,10],[104,10,105,10],[106,10,107,10],[108,10,109,10],[110,10,111,10],[112,10,113,10],[104,8,105,9],[106,8,107,9],[108,8,109,9],[102,11,103,11],[104,11,105,11],[106,11,107,11],[108,11,109,11],[110,11,111,11],[110,8,111,9],[112,11,113,11],[94,5,95,5],[96,5,97,5],[98,5,99,5],[100,5,101,5],[102,5,103,5],[104,5,105,5],[106,5,107,5],[108,5,109,5],[110,5,111,5],[112,5,113,5],[94,6,95,6],[96,6,97,6],[98,6,99,6],[100,6,101,6],[102,6,103,6],[104,6,105,6],[106,6,107,6],[94,3,95,3],[96,3,97,3],[98,3,99,3],[100,3,101,3],[102,3,103,3],[104,3,105,3],[106,3,107,3],[108,3,109,3],[110,3,111,3],[96,4,97,4],[98,4,99,4],[100,4,101,4],[102,4,103,4],[104,4,105,4],[106,4,107,4],[108,4,109,4],[110,4,111,4],[112,1,113,2],[112,3,113,3],[98,1,99,2],[100,1,101,2],[102,1,103,2],[104,1,105,2],[106,1,107,2],[108,1,109,2],[110,1,111,2],[0,0,0,12],[57,2,58,6],[60,2,61,4],[60,5,61,5],[66,1,66,4],[19,1,19,12],[20,1,20,12],[21,1,21,12],[63,0,65,0],[63,1,65,4],[5,1,17,12],[18,1,18,12],[22,1,24,12],[25,1,31,12],[33,1,38,12],[1,1,4,12],[39,0,39,9],[32,0,32,12],[5,0,17,0],[18,0,31,0],[1,0,4,0],[33,0,38,0],[60,0,61,1],[57,0,58,1],[143,5,144,7],[115,0,115,12],[114,11,114,14],[68,13,73,14],[74,13,75,14],[76,13,77,14],[78,13,79,14],[80,13,81,14],[82,13,83,14],[84,13,85,14],[86,13,87,14],[88,13,89,14],[90,13,91,14],[92,7,93,7],[94,7,95,7],[96,7,97,7],[98,7,99,7],[100,7,101,7],[102,7,103,7],[104,7,105,7],[106,7,107,7],[108,7,109,7],[112,4,113,4],[94,4,95,4],[96,13,97,14],[98,13,99,14],[100,13,101,14],[102,13,103,14],[104,13,105,14],[106,13,107,14],[108,13,109,14],[149,0,150,2],[151,0,152,2],[123,0,124,2],[125,0,126,2],[127,0,128,2],[129,0,130,2],[131,0,132,2],[133,0,134,2],[135,0,136,2],[137,0,138,2],[139,0,140,2],[141,0,142,2],[143,0,144,2],[145,0,146,2],[147,0,148,2],[122,0,122,2],[145,3,146,4],[122,3,122,4],[123,3,124,4],[125,3,126,4],[127,3,128,4],[129,3,130,4],[131,3,132,4],[133,3,134,4],[135,3,136,4],[137,3,138,4],[155,8,156,11],[157,8,158,11],[159,8,160,11],[161,8,162,11],[123,5,124,7],[155,0,156,2],[157,0,158,2],[159,0,160,2],[161,0,162,2],[147,3,148,4],[149,3,150,4],[151,3,152,4],[153,3,154,4],[155,3,156,4],[157,3,158,4],[159,3,160,4],[161,3,162,4],[153,0,154,2],[145,5,146,7],[139,3,140,4],[141,3,142,4],[143,3,144,4],[139,5,140,7],[141,5,142,7],[123,8,124,11],[139,8,140,11],[141,8,142,11],[143,8,144,11],[145,8,146,11],[147,8,148,11],[149,8,150,11],[151,8,152,11],[153,8,154,11],[147,5,148,7],[149,5,150,7],[151,5,152,7],[153,5,154,7],[155,5,156,7],[157,5,158,7],[159,5,160,7],[161,5,162,7],[122,8,122,11],[122,5,122,7],[125,8,126,11],[127,8,128,11],[129,8,130,11],[131,8,132,11],[133,8,134,11],[135,8,136,11],[137,8,138,11],[125,5,126,7],[127,5,128,7],[129,5,130,7],[131,5,132,7],[133,5,134,7],[135,5,136,7],[137,5,138,7],[120,0,121,11],[116,0,119,14],[56,0,56,14],[54,0,55,9],[52,0,53,1],[47,0,49,1],[50,0,51,1],[41,0,43,1],[44,0,44,1],[45,0,46,1],[110,13,111,14],[112,13,113,14],[67,0,67,14],[62,0,62,14],[59,0,59,14],[115,13,115,14],[92,13,93,14],[94,13,95,14],[57,7,58,7],[57,8,58,14],[52,2,53,12],[50,2,51,12],[47,2,49,12],[45,2,46,12]]}
["YEAR TWO - Establishment Project - Employment Services Staffing Costs (Supporting Documentation/Invoice)"]
["Required","Submit monthly staffing information, including employment services staff that were hired prior to the establishment project implementation and associated staffing costs, as well as staff hired with establishment project funds and associated staffing costs. These staffing reports will be used by BRS to verify that only allowable staff and percentages of costs are billed. "]
[]
[]
[]
["Allowable\nExpenses","Staffing costs for new or enhanced employment service responsibilities CAN ONLY be charged to the establishment project for the following:\n\n     - 1) Direct service staff providing employment services to VR applicants or those eligible to receive VR services, and/or \n              Example:  If a newly hired employment consultant builds a caseload of 15 VR consumers who are in various phases of the discovery or VR employment services process, and the EC has an \n              additional 5 consumers s/he is supporting in extended services through BDDS funding who are NOT currently VR consumers, only the EC’s time spent providing services to those 15 VR consumers \n              can be charged to the establishment project. \n\n     - 2) Staff providing coaching, mentoring, one-on-one guidance or counseling, or training to direct service staff identified above in #1.   \n             For the above example, only the time spent by the staff member providing coaching, mentoring, one-on-one guidance or counseling, or training to the employment consultant regarding the 15 \n             consumers may be charged to the project.             \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Unallowable Expenses","Staffing costs may NOT be charged to the establishment project for the following:"]
[null,"     - 1) Time spent providing employment services to individuals who are NOT current VR applicants or eligible individuals."]
[null,"     - 2) Time spent supervising any staff who are not providing services to VR applicants or eligible individuals."]
[null,"     - 3) Time spent on existing employment services responsibilities and not a result of new/enhanced responsibilities through the project.  "]
[null,"Staffing position prior to the Establishment Project:  If an existing position becomes vacant, the Contractor may NOT charge the staffing costs of a new hire or internal transfer to the Establishment Project, as this does not result in a new or enhanced cost for the Contractor.  However, if the allowable staff member’s role is enhanced through the project, then the percentage of time of the new/enhanced responsibilities may be charged to the project.    "]
[]
[]
[null,"\nAdditional unallowable expenses include the following (see scope of work for a full breakout):\n\n - Recruiting expenses, as a result of hiring must not be charged to Establishment Projects funds.\n - Travel, equipment, supplies, cell phones, utilities, leasing, and other administrative costs (including administrative or support staff, and supervisory or other executive level staff who directly oversee \n   employment service staff but are not new or enhanced roles, and do not provide coaching, mentoring, one-on-one guidance or counseling, or training) must not be charged to Establishment Projects \n   funds.  \n - Membership fees and subscriptions are unallowable costs and may not be charged to the project. \n"]
[]
[]
[]
[]
[]
[]
[]
["Due Date","The monthly 'claim reimbursement form' and 'staffing costs template' must be submitted by the 10th of the following month (i.e. April expenses and training costs breakouts must be submitted by May 10th) to establishmentproject@fssa.in.gov. The total amount listed on this template MUST match the total staffing line item on the claim reimbursement form.  A mismatch will result in the claim being rejected or reduced. "]
[]
[]
[]
[]
[]
[]
["INSTRUCTIONS FOR COMPLETING PAGES 2-3 OF STAFFING COSTS"]
["Position Number",null,"FOR TRACKING PURPOSES, all direct employment services staff funded through the Establishment Project, regardless of the percentage charged, will be assigned a standard position number to be used on all monthly/quarterly reports.  The assigned position number and title must match with all other monthly/quarterly reports.  If the specific position has turnover, the position number and position title will stay the same but the employee name will change.  "]
[]
[]
["Position Title",null,"Select the title that matches or is most closely aligned to your organization. "]
["75% Staffing Costs",null,"Staffing Costs must be reported at the full percentage breakout of the new/enhanced responsibilities; however, in year two of the project, only 75% of the staffing costs are reimbursable.  Of the 75% staffing costs, the Contractor will be invoiced for 21.3% to be deposited into a designated state VR account. "]
[]
["Applicable Only \nfor VR Clients",null,"As new/enhanced staffing costs may only be charged to the project for employment services delivered to VR applicants or individuals who have been determined eligible to receive VR services, this drop-down selection should reflect 'yes.'  A drop-down of 'no' or blank will result in a reduction or rejection of the claim.  Any work time charged for unallowable activities (i.e. pre-ets or services for NON-VR clients or those ineligible to receive VR services should not be charged to the staffing costs."]
[]
[]
["Staffing Changes \nfrom Prior Month",null,"Please note any changes in staffing from the previous month (i.e. David left XYZ in the month of January and was replaced by Sally mid-February)"]
[]
["Existing Direct ES Staff",null,"The name and position title must be listed for all existing direct employment services staff who are NOT charging time to the establishment project.  This will assist BRS with identifying that only allowable staffing costs are charged to the project."]
[]
[]
[]
["Year 2 Establishment Project - Employment Services Staffing Costs Worksheet (Supporting Documentation/Invoice)                                  "]
["CRP Name ",null,null,null,null,null,null,"CRP Address"]
[]
[]
["Contact Name",null,null,null,null,"Position Title",null,null,null,null,"Contact Email"]
[]
[]
["I,",null,null,null,null,"certify the staffing costs being charged to the project meet the allowable expenses definition identified above \nand that the deposited funds are from a non-federal source and not being used to match any other federal grant.",null,null,null,null,null,null,null,"Month","Year"]
[]
[]
[null,"(insert name and title)"]
[]
["Position Number","List Employee Name ",null,"Select Position Title from drop down (for tracking purposes, this should never change from the assigned position number)","List Project \nYear of Hire","Report ALL total hours worked for the month (project-related or other)","Of the total monthly hours worked, report only the hours spent on allowable establishment project activities (see above)","Hours spent on  Unallowable Activities (i.e. Pre-ETS, services to NON-VR applicants or eligible individuals)","Total monthly staffing costs reflecting Allowable Hours \n(salary & fringe)",null,"75% of \nStaffing \nCosts","Applicable only \nfor VR clients?","Does this position provide coaching, mentoring, one-on-one guidance or counseling, or training to direct employment services staff?","Provide a brief description if there were any changes to \nthe staffing position from the previous month"]
[]
[]
[]
[]
[]
["001",null,null,null,null,0,0,{"$f":"F75-G75","v":0},0,null,{"$f":"I75*0.75","v":0}]
[]
["002",null,null,null,null,0,0,{"$f":"F77-G77","v":0},0,null,{"$f":"I77*0.75","v":0}]
[]
["003",null,null,null,null,0,0,{"$f":"F79-G79","v":0},0,null,{"$f":"I79*0.75","v":0}]
[]
["004",null,null,null,null,0,0,{"$f":"F81-G81","v":0},0,null,{"$f":"I81*0.75","v":0}]
[]
["005",null,null,null,null,0,0,{"$f":"F83-G83","v":0},0,null,{"$f":"I83*0.75","v":0}]
[]
["006",null,null,null,null,0,0,{"$f":"F85-G85","v":0},0,null,{"$f":"I85*0.75","v":0}]
[]
["007",null,null,null,null,0,0,{"$f":"F87-G87","v":0},0,null,{"$f":"I87*0.75","v":0}]
[]
["008",null,null,null,null,0,0,{"$f":"F89-G89","v":0},0,null,{"$f":"I89*0.75","v":0}]
[]
["009",null,null,null,null,0,0,{"$f":"F91-G91","v":0},0,null,{"$f":"I91*0.75","v":0}]
[]
["010",null,null,null,null,0,0,{"$f":"F93-G93","v":0},0,null,{"$f":"I93*0.75","v":0}]
[]
["011",null,null,null,null,0,0,{"$f":"F95-G95","v":0},0,null,{"$f":"I95*0.75","v":0}]
[]
["012",null,null,null,null,0,0,{"$f":"F97-G97","v":0},0,null,{"$f":"I97*0.75","v":0}]
[]
["013",null,null,null,null,0,0,{"$f":"F99-G99","v":0},0,null,{"$f":"I99*0.75","v":0}]
[]
["014",null,null,null,null,0,0,{"$f":"F101-G101","v":0},0,null,{"$f":"I101*0.75","v":0}]
[]
["015",null,null,null,null,0,0,{"$f":"F103-G103","v":0},0,null,{"$f":"I103*0.75","v":0}]
[]
["016",null,null,null,null,0,0,{"$f":"F105-G105","v":0},0,null,{"$f":"I105*0.75","v":0}]
[]
["017",null,null,null,null,0,0,{"$f":"F107-G107","v":0},0,null,{"$f":"I107*0.75","v":0}]
[]
["018",null,null,null,null,0,0,{"$f":"F109-G109","v":0},0,null,{"$f":"I109*0.75","v":0}]
[]
["019",null,null,null,null,0,0,{"$f":"F111-G111","v":0},0,null,{"$f":"I111*0.75","v":0}]
[]
["020",null,null,null,null,0,0,{"$f":"F113-G113","v":0},0,null,{"$f":"I113*0.75","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I75:J114)","v":0},null,{"$f":"SUM(K75:K114)","v":0}]
["                                                                      75% TOTAL STAFFING COST BEING CLAIMED                                                                                                                                                                                                                                                                                                               ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K115","v":0}]
[]
[]
[]
[]
["LIST ALL EXISTING ES STAFF HIRED PRIOR TO THE ESTABLISHMENT PROJECT AND NOT CHARGING STAFFING COSTS"]
[]
["Position Number",null,null,"List Employee Name",null,"Position Title",null,null,"Year of Hire"]
["NonEstab01",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab02",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab03",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab04",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab05",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab06",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab07",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab08",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab09",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab10",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab11",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab12",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab13",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab14",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab15",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab16",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab17",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab18",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab19",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]
[]
["NonEstab20",null,null,null,null,null,null,null,"Prior to Establishment Project; not charging any staffing costs to the project"]