{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Open Workbook","Actual_Invoice","Summary","Instructions"],"not_rendered":{"charts":0,"images":4,"macros":1,"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":"Open Workbook","index":0,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,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]

{"sheet":"Actual_Invoice","index":1,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,1,5,2],[48,4,48,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,0,IF(F6<50,3700,IF(F6<200,6800,8200)))","v":0}]
["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 with 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,"# of JA",null,"Documentation Attached ","# of Job Analysis"]
[null,null,null,null,0,{"$f":"IF($E34<=0,\"\",350)","v":""},null,{"$f":"IF(E34=0,0,E34*F34)","v":0}]
[null,null,null,null,0,{"$f":"IF($E35<=0,\"\",350)","v":""},null,{"$f":"IF(E35=0,0,E35*F35)","v":0}]
[null,null,null,null,0,"",null,0]
[null,null,null,null,0,null,null,0]
[null,null,null,null,0,"",null,0]
[null,null,null,null,0,"",null,0]
[]
["7 - Program Evaluation",null,null,null,null,null,"Documentation Attached "]
[null,null,null,null,null,null,null,{"$f":"E42*F42","v":0}]
[null,null,null,null,null,null,null,{"$f":"E43*F43","v":0}]
[null,null,null,null,null,null,"Total Number of Job Analyses",{"$f":"SUM(E34:E39)","v":0}]
[null,null,null,null,null,null,"Total for Job Analyses (Section 5)",{"$f":"SUM(H34:H39)","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,"Implementation Fund",null,null,{"$f":"IF($H47>$H6,0,$H47-$H6)","v":0}]

{"sheet":"Summary","index":2,"n_rows":33,"n_cols":7,"rows_kept":33,"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],[36,10,36,11],[16,6,16,7],[23,6,23,7],[21,6,21,7],[28,6,28,7],[30,6,30,7],[32,6,32,7]]}
[]
[]
[]
[]
[]
[]
["My Grant"]
[]
["Pre-approved grant amount",null,null,null,null,"$",{"$f":"Actual_Invoice!H6","v":0}]
["Refer to chart below."]
["11 to 49 employees up to $3,700"]
["50 to 199 employees up to $6,800"]
["200 or more employees up to $8,200"]
[]
["My Grant Reimbursements"]
[]
["Total cost of development",null,null,null,null,"$",{"$f":"Actual_Invoice!H47","v":0}]
[]
[]
["My Contributions"]
[]
["A.  Development cost",null,null,null,null,"$",{"$f":"Actual_Invoice!H47","v":0}]
[]
["B.  Grant reimbursement",null,null,null,null,"$",{"$f":"IF(G9-G22<0,G9,G22)","v":0}]
[]
[]
["My Implementation Fund"]
[]
["A.  Grant amount",null,null,null,null,"$",{"$f":"G9","v":0}]
[]
["B.  Grant reimbursement",null,null,null,null,"$",{"$f":"G24","v":0}]
[]
["C.  Total monies left in implementation fund (A - B)",null,null,null,null,"$",{"$f":"IF(G29-G31<0,0,G29-G31)","v":0}]

{"sheet":"Instructions","index":3,"n_rows":38,"n_cols":1,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,8,0,9],[0,10,0,11],[0,12,0,17],[1,0,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,17],[0,6,0,7],[0,0,0,5],[2,9,2,10],[2,11,2,12],[2,13,2,17],[3,0,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,17],[2,3,2,4],[2,5,2,6],[2,7,2,8],[4,9,4,10],[4,11,4,12],[4,13,4,17],[5,0,5,16],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,10],[6,11,6,12],[6,13,6,17],[4,3,4,4],[4,5,4,6],[4,7,4,8],[7,12,7,17],[8,0,8,13],[8,14,8,17],[9,0,9,15],[9,16,9,17],[7,0,7,11],[11,0,11,11],[11,12,11,17],[13,0,13,11],[14,0,14,11],[15,0,15,11],[12,12,15,17],[24,7,24,8],[24,9,24,10],[24,11,24,12],[22,0,22,17],[23,0,23,11],[23,12,23,17],[19,0,19,13],[20,0,20,13],[21,0,21,13],[17,14,21,17],[16,0,16,13],[16,14,16,17],[17,0,17,13],[18,0,18,13],[12,0,12,11],[24,23,24,24],[24,25,24,26],[24,27,24,28],[24,29,24,30],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,26],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,21,24,22],[27,0,27,21],[27,22,27,23],[27,24,27,25],[27,26,27,27],[27,28,27,29],[25,27,25,28],[25,29,25,30],[26,0,26,3],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[26,22,26,23],[26,24,26,25],[26,26,26,27],[26,28,26,29],[28,27,28,28],[28,29,28,30],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[28,13,28,14],[28,15,28,16],[28,17,28,18],[28,19,28,20],[28,21,28,22],[28,11,28,12],[36,0,36,29],[37,0,37,29],[36,30,37,30],[24,0,24,6],[35,0,35,21],[35,22,35,23],[35,24,35,25],[35,26,35,27],[35,28,35,29],[33,0,33,19],[34,0,34,19],[30,20,34,21],[30,22,34,23],[30,24,34,25],[29,27,29,28],[29,29,29,30],[30,0,30,19],[31,0,31,19],[32,0,32,19],[30,26,34,27],[30,28,34,29],[30,30,34,30],[28,23,28,24],[28,25,28,26]]}
["BWC Plan Invoice Instructions"]
["Enterable fields are unlocked."]
[]
["B6-Enter the date of the invoice."]
[]
["F6-Enter the number of employees.  H6 the total grant amount will show after the number of employees is entered."]
[]
["Complete Section 1 – Corporate Analysis through Section 6 – Job Analyses."]
["              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. "]
["              Column C: Enter the Policy Number in Cell C9.  For a grant with a single policy number enter the policy number once."]
["                                    For Corporate Programs enter the appropriate policy number corresponding to the service."]
["              Column D: For Corporate Programs only, enter the number of employees related to the policy number."]
["              Column E: Enter the total hours related to each task performed."]
["                              Section 6 E34: Enter the number of job analyses performed."]
["              Column F: Enter the hourly rate. The maximum hourly rate cannot exceed $200/hour."]
["              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."]
["                                    Total number of job analyses: auto populated from E34."]
["                                    Total amount for job analyses: auto calculated from number entered."]
["                                    Total for plan development: auto calculated from Sections 1-5 and 7-8."]
["                      Total cost of grant development: auto calculated from job analyses and plan development amounts."]
["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 Invoice."]
[]
["My Grant"]
["The amount of the Transitional Work Grant awarded based on the number of employees (H6)."]
["My Grant Reimbursements"]
["The amount of the total cost of the plan development (H47)."]
[]
["My Contribution"]
["Total plan development cost (H47)."]
["Grant reimbursement. "]
[]
["My Implementation Funds"]
["Total grant amount (H6) - Total grant reimbursement amount (H47) = Implementation funds (H49)."]