{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Macro 4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":26,"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":"Macro 4","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,3,0,6],[0,7,0,11],[0,12,1,12]]}
[null,null,null,"PERCEPCIONES",null,null,null,"DEDUCCIONES ",null,null,null,null,"Pago semanal "]
["No.","Salario Diario","S.D.I.","Antigüedad ","Días Laborados","SALARIO SEMANAL SIN DEDUCCIONES  ","total percepciones ","imss","isr","crédito infonavit","total deducciones","total recibido "]
["HEZ0043 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":232.26723525230989},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":242.76571428571427}," P25W ",7,1699.36,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1699.36},21.24,78.12,null,{"$f":"+H3+I3+J3","v":99.36},{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K3","v":1600},1600]
["HEZ0036 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":181.4840632004811},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":189.68714285714285},"P47W",7,1327.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1327.81},16.600000000000001,11.21,null,27.810000000000002,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K4","v":1300},1300]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":215.42698594937406},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":225.16428571428574},"P9W",7,1576.15,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1576.15},19.7,56.45,null,76.150000000000006,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K5","v":1500},1500]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":199.87288830572413},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":208.90714285714284},null,7,1462.35,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1462.35},18.28,44.07,null,{"$f":"+H6+I6+J6","v":62.35},{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K6","v":1400},1400]
["HEZ0025 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":359.46503745011205},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":375.7128571428571}," P107W ",7,2629.99,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2629.99},61.42,268.57,null,329.99,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K7","v":2300},2300]
["HEZ0016",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":404.75370400743543},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":423.04857142857145}," P107W ",7,2961.34,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2961.34},76.61,334.73,null,411.34000000000003,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K8","v":2550},2550]
["HEZ0041 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":215.42698594937406},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":225.16428571428574}," P26W ",7,1576.15,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1576.15},19.7,56.45,null,76.150000000000006,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K9","v":1500},1500]
["HEZ0008 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":324.19085889235146},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":338.84428571428572}," P194W ",7,2371.91,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2371.91},49.59,222.32,null,271.90999999999997,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K10","v":2100},2100]
["HEZ0001 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":832.41484883275928},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":870.04},"P222W",7,6090.28,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":6090.28},76.13,1014.15,null,1090.28,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K11","v":5000},5000]
["HEZ0010 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":832.41484883275928},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":870.04}," P181W ",7,6090.28,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":6090.28},76.13,1014.15,null,1090.28,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K12","v":5000},5000]
["HEZ0014 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":395.52375485211309},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":413.40142857142854}," P131W ",7,2893.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2893.81},73.510000000000005,320.3,null,393.81,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K13","v":2500},2500]
["HEZ0002 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":395.52375485211309},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":413.40142857142854}," P215W ",7,2893.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2893.81},73.510000000000005,320.3,null,393.81,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K14","v":2500},2500]
["HEZ0007 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":324.19085889235146},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":338.84428571428572}," P187W ",7,2371.91,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2371.91},49.59,222.32,null,271.90999999999997,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K15","v":2100},2100]
["HEZ0024 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":551.29435241375552},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":576.21285714285716}," P96W",7,4033.49,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":4033.49},125.75,563.74,344,1033.49,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K16","v":3000},3000]
["HEZ0003 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":341.91542288557218},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":357.37}," P128W",7,2501.59,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2501.59},55.53,245.56,null,301.09000000000003,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K17","v":2200.5},2200.5]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":181.4840632004811},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":189.68714285714285},null,7,1327.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1327.81},19.7,56.45,null,76.150000000000006,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K18","v":1251.6599999999999},1300]
["HEZ0037 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":247.84046798972173},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":259.04285714285714}," P29W ",7,1813.3,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1813.3},22.67,140.63,null,163.30000000000001,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K19","v":1650},1650]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":199.87288830572413},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":208.90714285714284},null,7,1462.35,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1462.35},18.28,44.07,null,62.35,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K20","v":1400},1400]
["HEZ0021",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":350.64649281067193},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":366.49571428571426}," P99W ",7,2565.4699999999998,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2565.4699999999998},58.46,257.01,null,315.46999999999997,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K21","v":2250},2250]
["HEZ0022 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":487.80547810398559},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":509.85428571428571}," P98W ",7,3568.98,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":3568.98},104.46,464.52,null,568.98,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K22","v":3000},3000]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":181.4840632004811},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":189.68714285714285},null,7,1327.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1327.81},19.7,56.45,null,76.150000000000006,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K23","v":1251.6599999999999},1300]
["HEZ0042 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":272.92520911923896},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":285.26142857142855}," P18W ",7,1996.83,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1996.83},24.96,102.22,429.65,556.82999999999993,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K24","v":1440},1400]
["HEZ0028 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":215.42698594937406},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":225.16428571428574},"P32W",7,1576.15,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":1576.15},19.7,56.45,null,76.150000000000006,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K25","v":1500},1500]
["HEZ0015 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":450.89251544475428},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":471.27285714285711},"P28W",7,3298.91,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":3298.91},92.08,406.83,null,498.90999999999997,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K26","v":2800},2800]
["HEZ0038",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":381.43212508884153},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":398.67285714285714}," P29W ",7,2790.71,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2790.71},68.790000000000006,297.37,{"$f":"1898.2/4","v":474.55},840.71,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-H27-I27-J27","v":1950.0000000000002},1950]
["HEZ0018 ",{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":395.52375485211309},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":413.40142857142854}," P99W ",7,2893.81,{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]","v":2893.81},73.510000000000005,320.3,null,393.81,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K28","v":2500},2500]
[null,{"$f":"+Tabla1452[[#This Row],[S.D.I.]]/1.0452","v":359.46503745011205},{"$f":"+Tabla1452[[#This Row],[SALARIO SEMANAL SIN DEDUCCIONES  ]]/7","v":375.7128571428571},null,7,2629.99,2629.99,61.42,268.57,null,329.99,{"$f":"+Tabla1452[[#This Row],[total percepciones ]]-K29","v":2300},2300]
["28 trabajadores ",null,null,null,null,{"$f":"SUM(F3:F29)","v":69732.350000000006},{"$f":"SUM(G3:G29)","v":69732.350000000006},1397.02,7243.31,1248.2,9888.5299999999988,59843.820000000007,59900.5]
[null,null,null,null,null,null,null,null,"  "]