{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["INICIO","PLANILLA","DO_1"],"not_rendered":{"images":1,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"INICIO","index":0,"n_rows":14,"n_cols":3,"rows_kept":14}
[null,"Programación en Excel VBA • Nivel I"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[null,"Instrucción If then"]
[]
[null,null,"If condición then"]
[null,null,"[instrucción]"]
[null,null,"ElseIf condición elseif then"]
[null,null,"[instrucción elseif]"]
[null,null,"Else"]
[null,null,"[instrucción else]"]
[null,null,"End If"]
[]
[null,null,"If condición then instrucción else instrucción else"]

{"sheet":"PLANILLA","index":1,"n_rows":22,"n_cols":8,"rows_kept":22}
[null,"Instrucción If | Else | End If • Programación en Excel VBA"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[]
[null,{"$f":"lista01.01","v":"Cargo"},"Contrato","Sueldo","Bono 1","Bono 2","Bono 3","Bono 4"]
[null,"Gerente","Planilla",{"v":5000,"d":"5,000"},250,500,0,250]
[null,"Secretaria","Planilla",{"v":1500,"d":"1,500"},75,0,225,75]
[null,"Contador","Honorarios",{"v":3000,"d":"3,000"},90,240,0,150]
[null,"Obrero","Planilla",{"v":1200,"d":"1,200"},60,0,0,240]
[null,"Tecnico","Honorarios",{"v":1500,"d":"1,500"},45,0,0,75]
[null,"Tecnico","Planilla",{"v":1800,"d":"1,800"},90,0,0,90]
[null,"Secretaria","Honorarios",{"v":1200,"d":"1,200"},36,0,0,240]
[null,"Secretaria","Planilla",{"v":1000,"d":"1,000"},50,0,150,200]
[null,"Secretaria","Planilla",{"v":1800,"d":"1,800"},90,0,0,90]
[null,"Tecnico","Planilla",{"v":1600,"d":"1,600"},80,0,0,80]
[]
[]
[null,"Cargo","Contrato","Sueldo","Bono 1","Bono 2","Bono 3","Bono 4"]
[null,"Gerente","Planilla",5000,250,500,0,250]
[]
[null,1]

{"sheet":"DO_1","index":2,"n_rows":20,"n_cols":11,"rows_kept":20,"hidden":true}
[]
[]
[]
[]
[]
[null,"Cargo","Contrato","Sueldo","Bono 1","Bono 2","Bono 3","Bono 4",null,"►","Bono1"]
[null,"Gerente","Planilla",{"v":5000,"d":"5,000"},{"$f":"IF(C7=\"Planilla\",D7*5%,D7*3%)","v":250},{"$f":"IF(B7=\"Gerente\",D7*10%,IF(B7=\"Contador\",D7*8%,0))","v":500},{"$f":"IF(B7=\"Secretaria\",IF(C7=\"Planilla\",IF(D7<=1500,D7*15%,0),0),0)","v":0},{"$f":"IF(D7<=1200,D7*20%,D7*5%)","v":250},null,null,"Si el trabajador se encuentra en planilla aplique un bono de 5%"]
[null,"Secretaria","Planilla",{"v":1500,"d":"1,500"},{"$f":"IF(C8=\"Planilla\",D8*5%,D8*3%)","v":75},0,{"$f":"IF(B8=\"Secretaria\",IF(C8=\"Planilla\",IF(D8<=1500,D8*15%,0),0),0)","v":225},75,null,null,"de lo contrario aplique un bono del 3%."]
[null,"Contador","Honorarios",{"v":3000,"d":"3,000"},90,240,0,150]
[null,"Obrero","Planilla",{"v":1200,"d":"1,200"},60,0,0,240,null,"►","Bono2"]
[null,"Tecnico","Honorarios",{"v":1500,"d":"1,500"},45,0,0,75,null,null,"Si el cargo es Gerente aplique un bono de 10%, si el trabajador"]
[null,"Tecnico","Planilla",{"v":1800,"d":"1,800"},90,0,0,90,null,null,"es Contador aplique un bono de 8%, de lo contrario CERO."]
[null,"Secretaria","Honorarios",{"v":1200,"d":"1,200"},36,0,0,240]
[null,"Secretaria","Planilla",{"v":1000,"d":"1,000"},50,0,150,200,null,"►","Bono3"]
[null,"Secretaria","Planilla",{"v":1800,"d":"1,800"},90,0,0,90,null,null,"Si el cargo es Secretaria, se encuentra en planilla y su sueldo es"]
[null,"Tecnico","Planilla",{"v":1600,"d":"1,600"},80,0,0,80,null,null,"menor o igual que 1500, aplique un bono de 15% sino CERO."]
[]
[{"$nulls":9},"►","Bono4"]
[{"$nulls":10},"Si el sueldo es menor o igual que 1200, aplique un bono de 20%"]
[{"$nulls":10},"sino aplique un bono del 5%."]