{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Open Workbook","IF_Invoice","Summary","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Open Workbook","index":0,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Opening the Workbook"]
["When opening the BWC Invoice, please be sure to click on the (*) Enable Content button to ensure that the Macros have been enabled in this document prior to filling out the invoice. "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"(*)"]

{"sheet":"IF_Invoice","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,2,6,3],[4,4,4,5],[31,4,31,6],[32,4,32,6],[1,0,1,1],[2,0,2,1],[3,1,3,2],[29,4,29,6],[30,4,30,6],[19,2,19,3],[17,2,17,3],[14,2,14,3],[5,4,5,5]]}
[]
[]
[]
[]
[null,null,"Employer Name:"]
["Date:",null,"Policy Number:",null,null,null,"Total Implementation Amount:"]
["Dates of Completion","Description of Task",null,null,"Hours/Task","Hourly Rate","Total Hours and Total Billed Amount"]
["1 - Education and Training ",null,null,null,null,null,"Documentation Attached "]
[null,null,null,null,null,null,null,{"$f":"E9*F9","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H9:H14)","v":0}]
["2 - Claim Assistance",null,null,null,null,null,"Documentation Attached "]
[null,null,null,null,null,null,null,{"$f":"E17*F17","v":0}]
[null,null,null,null,null,null,"Documentation Attached "]
["3 - Program Improvement",null,null,null,null,null,null,{"$f":"E19*F19","v":0}]
[null,null,null,null,null,null,null,{"$f":"H17+H19","v":0}]
["4 - Job Analyses ","List of Job Titles",null,null,null,null,"Documentation Attached "]
[" ",null,null,null,null,null,null,{"$f":"IF($E22=0,0,$E22*$F22)","v":0},{"$f":"F22*H22","v":0}]
[" ",null,null,null,null,{"$f":"IF($E23=0,\"\",350)","v":""},null,0,{"$f":"F23*H23","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"",null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,"",null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,"",null,0,{"$error":"#VALUE!"}]
[null,null,null,null,null,"",null,{"$f":"IF($E27=0,0,$E27*$F27)","v":0},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,"Total Number of Job Analyses",{"$f":"SUM(E22:E27)","v":0}]
[null,null,null,null,null,null,"Total for Job Analyses (Section 4)",{"$f":"SUM(H22:H27)","v":0}]
[null,null,null,null,"Total for Development (Sections 1 - 3, 5 - 7)",null,null,{"$f":"H15+H20","v":0}]
[null,null,null,null,"Total Cost of Development",null,null,{"$f":"SUM(H29:H30)","v":0}]
[null,null,null,null,"BWC Reimbursement",null,null,{"$f":"IF(H6>0,IF(H31<=H6,H31,H6),0)","v":0}]
[null,null,null,null,"Implementation Fund",null,null,{"$f":"IF(H6-H32>0,H6-H32,0)","v":0}]

{"sheet":"Summary","index":2,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[8,6,8,7],[8,0,8,3],[26,10,26,11],[13,6,13,7],[18,6,18,7],[20,6,20,7],[22,6,22,7]]}
[]
[]
[]
[]
[]
[]
["My Implementation Fund"]
[]
["Implementation Fund Available",null,null,null,null,"$",{"$f":"IF_Invoice!H6","v":0}]
[]
[]
["My Implementation Services"]
[]
["Total cost of services",null,null,null,null,"$",{"$f":"IF_Invoice!H31","v":0}]
[]
[]
["My Remaining Implementation Fund"]
[]
["A.  Implementation amount available",null,null,null,null,"$",{"$f":"G9","v":0}]
[]
["B.  Cost of implementation services",null,null,null,null,"$",{"$f":"IF_Invoice!$H32","v":0}]
[]
["C.  Total remaining implementation amount (A - B)",null,null,null,null,"$",{"$f":"G19-G21","v":0}]

{"sheet":"Instructions","index":3,"n_rows":46,"n_cols":1,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Implementation Fund Invoice"]
["Enterable fields are unlocked."]
[]
["D5: Enter the employer name. "]
[]
["B6: Enter the date of the invoice. "]
[]
["D6: Enter the policy number. "]
[]
["H6: Enter the remaining implementation amount."]
[]
["Complete Section 1 – Education and Training through Section 7 – Personal Protective Equipment."]
[]
["       Column A: Enter the dates of completion of each task in the appropriate row."]
[]
["       Column B: Enter the description of the task in the appropriate row. Sample descriptions are provided."]
["                         B22: Enter the titles of the job analyses performed."]
["                         B35:Enter PPE not included in the sample list."]
[]
["       Column C: C35-Enter quantity of the Personal Protective Equipment if purchased."]
[]
["       Column E: Enter the total hours related to each task performed. May enter portions of time."]
["                              "]
["       Column F: Enter the hourly rate. The maximum hourly rate cannot exceed $200/hour. "]
["                         F35 Enter total cost of PPE."]
[]
["       Column G: Enter the title of the documents attached for each section."]
["        "]
["       Column H: Totals for each section will automatically calculate as information is entered."]
["                         H42: Total number of job analyses auto populates from E22."]
["                              H43: Total amount for job analyses auto calculates from the number entered."]
[]
["Implementation Fund: Unused grant monies may be used to purchase services to enhance the program and must be used within 5 years. "]
[]
[]
["Summary Worksheet Instructions"]
["The Summary Worksheet shows totals based on entries made in the BWC IF Invoice."]
[]
["My Implementation Fund"]
["The amount of implementation funds available (H6)."]
[]
["My Implementation Services"]
["The amount of the total cost of services (H45)."]
[]
["My Remaining Implementation Fund "]
["Total  implementation amount available (H47) – Cost of implementation Services (H45  ) = Total Remaining IF."]