{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Payroll Calculation Template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["EMPLOYEE NAME",null,"Mike Hemmeter"]
["2020-2021"]
[null,null,"TOTAL  SALARY"]
["ANNUAL SALARY",null,64730]
["MONTHLY SALARY",null,{"$f":"C4/12","v":5394.166666666667}]
[]
["PAID FROM:                              ACCOUNT","PERCENTAGE"]
[]
["02-1304",0.67,{"$f":"C5*B9","v":3614.0916666666672}]
["02-3615",7.0000000000000007E-2,{"$f":"C5*B10","v":377.5916666666667}]
["02-1319",7.0000000000000007E-2,{"$f":"C5*B11","v":377.5916666666667}]
["01-1319",0.19,{"$f":"C5*B12","v":1024.8916666666667}]
[" "," "," "]
[null," "]
[]
[]
["DOUBLE CHECK ON FIGURES",null,{"$f":"SUM(C9:C16)","v":5394.166666666667}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HC1945"]

{"sheet":"Payroll Calculation Template","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[[16,3,16,5],[28,3,28,5],[1,2,1,5],[2,2,2,5],[3,2,3,5]]}
[]
[null,null,{"$f":"NOW()","v":"2021-03-01T09:56:49.160"}]
[null,null,"Howard College"]
[null,null,"Payroll Calculations Template"]
[]
[null,null,"Employee Name:","Howie Hawk"]
[null,null,"Effective Date:","2021-03-01"]
[]
[null,null,"Annual Salary:",25000]
[null,null,"Monthly Salary:",{"$f":"D9/12","v":2083.3333333333335}]
[]
[null,null,"Site:","Howard College","SWCD","Totals"]
[null,null,"Site Percentages:",0.6,0.4,{"$f":"SUM(D13:E13)","v":1}]
[null,null,"Site Annual Amount:",{"$f":"D9*D13","v":15000},{"$f":"D9*E13","v":10000},{"$f":"SUM(D14:E14)","v":25000}]
[null,null,"Site Monthly Amount:",{"$f":"D10*D13","v":1250},{"$f":"D10*E13","v":833.33333333333348},{"$f":"SUM(D15:E15)","v":2083.3333333333335}]
[]
[null,null,"Howard College","Howard College"]
[null,null,"Account Number","Percentage","Annual Salary","Monthly Salary"]
[null,null,"1-10-65-01-9999-56010",0.5,{"$f":"$D$14*D19","v":7500},{"$f":"$D$15*D19","v":625}]
[null,null,"1-10-65-01-9999-56020",0.5,{"$f":"$D$14*D20","v":7500},{"$f":"$D$15*D20","v":625}]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,"Totals:",{"$f":"SUM(D19:D25)","v":1},{"$f":"SUM(E19:E25)","v":15000},{"$f":"SUM(F19:F25)","v":1250}]
[null,null,"Error Checking:",{"$f":"IF(AND(D13=0,D26=0),\"All Good!\",IF(AND(D13>0,D14=E26),\"All Good!\",\"Error%%\"))","v":"All Good!"},{"$f":"IF(E26<>D14,\"Amount Error!\",\"All Good!\")","v":"All Good!"},{"$f":"IF(F26<>D15,\"Amount Error!\",\"All Good!\")","v":"All Good!"}]
[]
[null,null,"SWCD","SWCD"]
[null,null,"Account Number","Percentage","Annual Salary","Monthly Salary"]
[null,null,"4-15-65-04-9999-56010",1,{"$f":"$E$14*D31","v":10000},{"$f":"$E$15*D31","v":833.33333333333348}]
[null,null,null,0,{"$f":"$E$14*D32","v":0},{"$f":"$E$15*D32","v":0}]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,"Totals:",{"$f":"SUM(D31:D37)","v":1},{"$f":"SUM(E31:E37)","v":10000},{"$f":"SUM(F31:F37)","v":833.33333333333348}]
[null,null,"Error Checking:",{"$f":"IF(AND(E13=0,E14=0),\"All Good!\",IF(AND(E13>0,E14=E38),\"All Good!\",\"Error%%\"))","v":"All Good!"},{"$f":"IF(E38<>E14,\"Amount Error!\",\"All Good!\")","v":"All Good!"},{"$f":"IF(F38<>E15,\"Amount Error!\",\"All Good!\")","v":"All Good!"}]
[]
[null,null,"Totals:","Percentage","Annual Salary","Monthly Salary"]
[null,null,"Totals:",{"$f":"IF(OR(D26=0,D38=0),SUM(D26,D38),SUM(D26,D38)/2)","v":1},{"$f":"SUM(E26,E38)","v":25000},{"$f":"SUM(F26,F38)","v":2083.3333333333335}]
[null,null,"Error Checking:",{"$f":"IF(F13=0,\"All Good!\",IF(D42<>1,\"% <> Error!\",\"All Good!\"))","v":"All Good!"},{"$f":"IF(E42<>D9,\"Amount Error!\",\"All Good!\")","v":"All Good!"},{"$f":"IF(F42<>D10,\"Amount Error!\",\"All Good!\")","v":"All Good!"}]