{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Actual_Invoice","Summary"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":98,"n_cols":9,"rows_kept":98,"cut":false,"hidden":false,"merged":[[0,0,0,3],[46,0,46,3],[76,0,76,3]]}
["Opening the workbook"]
["When opening the BWC Invoice, please be sure to click on the 1. Options button and then 2. Enable this content and 3. press the OK button."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,3]
[]
[]
["Actual_Invoice worksheet"]
["Enterable fields are unlocked."]
[]
["Enter the date of the invoice in cell B6."]
[]
["Enter the number of employees in cell F6.  After entering the number of employees, the Total grant  amount will be shown in cell H6."]
[]
["Complete section 1 – Policies and procedures through section 6 – Job analyses."]
["                Enter the dates of completion of each task in the appropriate row of column A."]
["Enter the description of the task in the appropriate row of column B.  We have provided some for you in advance. "]
[null,"Job analyses for each job title will need to be listed in the appropriate row of column B of section 6. "]
[]
["Enter the policy number in cell C9 and the number of employees in cell D9."]
["Enter the hours to develop each section in the appropriate row of column E."]
["                Enter the hourly rate for development in the appropriate row of column F.  "]
[null,"The max allowed for the hourly rate is $200/hour and this amount cannot be exceeded."]
["Enter the name of the documentation attached for each task itemized in the appropriate row of column G."]
["Enter the number of job analyses for each job title in the appropriate row of column H in section 6."]
["Totals for each section will automatically populate as information is provided."]
[]
["As each section is completed the total dollar amounts will begin to show in column H.  The totals section at the bottom of column H will indicate the following:"]
["                Total number of job analyses listed in rows 34 – 39 of column H;"]
["Total dollar amount of job analyses listed in rows 34 – 39 of column H.  This is based off of the hourly rates for each job analysis listed in rows 34 – 39 of column F;"]
["                Total for development - The total costs of sections 1 – 5."]
["                Total cost of development - The sum of total job analyses cost plus the total for development;"]
["               75 percent BWC reimbursement - 75 percent of the allowable total cost of development;"]
["Employer contribution -  The difference between the75 percent BWC reimbursement and total cost of development;"]
["Implementation fund - Any monies left over from the total grant amount and the 75 percent BWC reimbursement."]
[]
[]
["Summary worksheet"]
["The provided summary worksheet shows pertinent information based on entries made on the Actual_Invoice worksheet."]
[]
["My grant"]
["The chart provided details the pre-approved grant amount based on the number of employees for the business.  "]
["     The amount shown represents the amount for the employer based on the number of employees listed on the Actual_Invoice worksheet."]
[]
["My grant reimbursements"]
["This section itemizes the total cost of development (total of development costs and job analyses)."]
["It also shows the amount of reimbursement by BWC of allowable costs. BWC will reimburse 75 percent of the total development costs that do not exceed the pre-approved grant amount."]
[]
["My contributions"]
["This section itemizes the amounts that lead up to the contribution amount of the employer."]
["Section A is the total development cost (total of development costs and job analyses)."]
["Section B is the amount reimbursed by BWC. This will not exceed the pre-approved grant amount."]
["Section C is the employer’s contribution toward the plan development costs. It represents the total development costs minus the amount reimbursed by BWC."]
[]
["My implementation fund"]
["This section itemizes the total amount that remains available to the employer for future development costs."]
["Section A is the pre-approved grant amount determined by the number of employees listed by the employer."]
["Section B shows the BWC reimbursement amount.  This amount will not exceed the pre-approved grant amount."]
["Section C shows any monies left from the pre-approved grant amount less the amount reimbursed by BWC."]

{"sheet":"Actual_Invoice","index":1,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[5,1,5,2],[48,4,48,6],[49,4,49,6],[50,4,50,6],[5,3,5,4],[45,4,45,6],[46,4,46,6]]}
[]
[]
[]
[]
[]
["Date:",null,null,"Number of employees:",null,null,"Total grant amount:",{"$f":"IF(F6<11,\"Not Eligible\",IF(F6<50,2900,IF(F6<200,5200,6300)))","v":"Not Eligible"}]
["Dates of completion","Description of task","Policy number","Number of employees","Hours/task","Hourly Rate","Total hours and total billed amount"]
["1 - Corporate Analysis",null,null,null,null,null,"Documentation attached"]
[null,"Corporate Analysis",null,null,null,null,null,{"$f":"E9*F9","v":0}]
[null,null,null,null,null,null,null,{"$f":"H9","v":0}]
["2 - Management-Union Buy in ",null,null,null,null,null,"Documentation attached "]
[null,"Formation of TW Safety Committee",null,null,null,null,null,{"$f":"E12*F12","v":0}]
[null,"Meeting w/management - union",null,null,null,null,null,{"$f":"E13*F13","v":0}]
[null,null,null,null,null,null,null,{"$f":"H12+H13","v":0}]
["3 - Policies and procedures ",null,null,"(per policy)",null,null,"Documentation attached "]
[null,"Development of policies and procedures",null,null,null,null,null,{"$f":"E16*F16","v":0}]
[null,null,null,null,null,null,null,{"$f":"E17*F17","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H15:H17)","v":0}]
["4 - Community resource ",null,null,null,null,null,"Documentation attached "]
[null,"Contact/Meet with local provider(s)",null,null,null,null,null,{"$f":"E20*F20","v":0}]
[null,"Research local providers on internet",null,null,null,null,null,0]
[null,"Develop provider list for employer",null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H19:H23)","v":0}]
["5 - Education and training ",null,null,null,null,null,"Documentation attached "]
[null,"Program education for coordinator ",null,null,null,null,null,{"$f":"E26*F26","v":0}]
[null,"Training at field office/location",null,null,null,null,null,0]
[null,"Training at work site for employees",null,null,null,null,null,0]
[null,"Training at work site for managers/supervisors",null,null,null,null,null,0]
[null,"Program education for specific work site",null,null,null,null,null,0]
[null,"Corporate training/meeting",null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H25:H31)","v":0}]
["6 - Job analyses ","List of job titles",null,null,null,null,"Documentation attached "]
[null,null,null,null,null,null,null,0,{"$f":"F34*H34","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(I34:I39)","v":0}]
["7 - Claim Assistance",null,null,null,null,null,"Documentation attached "]
[null,"Assistance with first claim in TW plan",null,null,null,null,null,{"$f":"E42*F42","v":0}]
["8 - Program Improvement","Evaluation & improvement to TW plan",null,null,null,null,null,{"$f":"E43*F43","v":0}]
[null,null,null,null,null,null,"Total number of job analyses",{"$f":"SUM(H34:H39)","v":0}]
[null,null,null,null,null,null,"Total for job analyses (Section 5)",{"$f":"SUM(I34:I39)","v":0}]
[null,null,null,null,"Total for development (Sections 1 - 5, 7 - 8)",null,null,{"$f":"H9+H14+H18+H24+H32+H42+H43","v":0}]
[null,null,null,null,"Total cost of development",null,null,{"$f":"SUM(H45:H46)","v":0}]
[null,null,null,null,null,null,"Employer Contribution",{"$f":"H47*0.25","v":0}]
[null,null,null,null,"75% BWC reimbursement",null,null,{"$f":"IF(F6>10,IF(H47<=H6/0.75,H47*0.75,H6),\"Not Eligible\")","v":"Not Eligible"}]
[null,null,null,null,"Employer contribution",null,null,{"$f":"IF(F6>10,IF(H47<=H6/0.75,H47*0.25,H47-H49),\"Not Eligible\")","v":"Not Eligible"}]
[null,null,null,null,"Implementation fund",null,null,{"$f":"IF(F6>10,H6-H49,\"Not Eligible\")","v":"Not Eligible"}]

{"sheet":"Summary","index":2,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,6,8,7],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[12,0,12,3],[40,10,40,11],[16,6,16,7],[27,6,27,7],[25,6,25,7],[23,6,23,7],[32,6,32,7],[34,6,34,7],[18,6,18,7],[36,6,36,7]]}
[]
[]
[]
[]
[]
[]
["My grant"]
[]
["Pre-approved grant amount",null,null,null,null,"$",{"$f":"Actual_Invoice!H6","v":"Not Eligible"}]
["Refer to chart below."]
["11 to 49 employees up to $2,900"]
["50 to 199 employees up to $5,200"]
["200 or more employees up to $6,300"]
[]
["My grant reimbursements"]
[]
["Total cost of development",null,null,null,null,"$",{"$f":"Actual_Invoice!H47","v":0}]
[]
["75% BWC reimbursement",null,null,null,null,"$",{"$f":"Actual_Invoice!H49","v":"Not Eligible"}]
[]
[]
["My contributions"]
[]
["A.  Development cost",null,null,null,null,"$",{"$f":"Actual_Invoice!H47","v":0}]
[]
["B.  Grant reimbursement",null,null,null,null,"$",{"$f":"IF(G24>G9/0.75,G9,IF(G24*0.25>G17,G17,G24*0.75))","v":{"$error":"#VALUE!"}}]
[]
["C.  My contribution to my plan development (A - B)",null,null,null,null,"$",{"$f":"G24-G26","v":{"$error":"#VALUE!"}}]
[]
[]
["My implementation fund"]
[]
["A.  Grant amount",null,null,null,null,"$",{"$f":"G9","v":"Not Eligible"}]
[]
["B.  Grant reimbursement",null,null,null,null,"$",{"$f":"G19","v":"Not Eligible"}]
[]
["C.  Total monies left in implementation fund (A - B)",null,null,null,null,"$",{"$f":"G33-G35","v":{"$error":"#VALUE!"}}]