{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Salary Calculator"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":34,"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":"Salary Calculator","index":0,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[5,5,6,11],[7,5,11,11],[26,6,26,10],[25,6,25,10],[24,6,24,10],[23,6,23,10],[21,6,22,10]]}
[]
[]
[null,"Money available:",100000,null,null,"Hourly Rate"]
[null,"IRCC Complaince Fee Required?","No",null,0,{"$f":"C22/(2080/12*C9)","v":40.679062768701627}]
[]
[null,"Conference or Travel Expenses",0,null,null,"Instructions"]
[]
[null,null,null,null,null,"If prompted, Macros must be enabled. This workbook must not be in \"Read-Only\" mode\n\nPlease complete the cells in Blue then click \"Update Scenario\"."]
[null,"Appointment Length (Months):",12]
[null,"Full Time Percentage:",1]
[null,"Expected Hours per Pay Period",{"$f":"80*C10","v":80}]
[]
[null,"Vacation Time or Pay?","Pay"]
[]
[null,"Eligible for Benefits",{"$f":"IF(AND(C10>=1,C9>=8),\"Yes\",IF(AND(C10>=0.5,C9>=12),\"Yes\",\"No\"))","v":"Yes"}]
[null,"Eligible for Pension",{"$f":"IF(C9>=24,\"Yes\",\"No\")","v":"No"}]
[]
[null,"Benefits: Single or Family","Family"]
[null,"Health And Dental Benefit Cost",{"$f":"IF(C15=\"Yes\",IF(C18=\"Single\",90,216)*C9,0)","v":2592}]
[]
[]
[null,"Total Pay",84612.450558899378,null,null,null,"Based on your entries, the salary dollars available for the full appointment would be:"]
[null,"Pension Cost",{"$f":"IF(C16=\"Yes\",C22*0.062,0)","v":0}]
[null,"Life",{"$f":"IF(C15=\"Yes\",C22*0.003,0)","v":253.83735167669815},null,null,null,{"$f":"C22","v":84612.450558899378}]
[null,"ADD",{"$f":"IF(C15=\"Yes\",C9*0.31,0)","v":3.7199999999999998},null,null,null,"The annualized (12 month) salary for this position is:"]
[null,"Vacation Pay",{"$f":"IF(C13=\"Pay\",C22*0.06,0)","v":5076.7470335339622},null,null,null,{"$f":"C22/C9*12","v":84612.450558899378}]
[null,"Statutory Benefits (CPP/EI/PR Tax)",{"$f":"C22*0.1","v":8461.2450558899382}]
[]
[null,"IRCC Fee",{"$f":"IF(C4=\"Yes\",230,0)","v":0}]
[null,"Sum of expenses",{"$f":"C19+C6+SUM(C22:C27)","v":100999.99999999999}]
[]
[null,"Remaining",{"$f":"C3-C30","v":-999.99999999998545}]