{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["BOARDESK","GASTOS","COSTOS","PUNTO DE EQUILIBRIO","DATOS","NOMINA"," COSTOS ABC MO","ESTADO DE COSTOS ","ESTADO DE RESULTADOS","CARGOS Y FUNCIONES","FLORELIA ","MIRALBA RIVERA","MARIA ","LINA MARIA ","ANGEL ESTIVEN"],"not_rendered":{"charts":9,"images":17,"macros":1,"external_links":11,"defined_names":0,"comments":5,"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":"BOARDESK","index":0,"n_rows":54,"n_cols":23,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,17,47,19],[47,14,47,15],[20,15,20,16],[21,15,22,16],[6,15,6,16],[10,15,11,16],[12,15,13,16],[7,10,7,11],[47,2,47,3],[47,5,47,6],[47,8,47,9],[47,11,47,12],[48,17,48,18],[3,15,3,16],[9,15,9,16],[4,15,5,16],[6,5,6,6],[7,5,7,6],[6,7,6,8],[7,7,7,8],[3,5,3,10],[4,10,4,11],[4,5,4,6],[4,7,4,8],[5,7,5,8],[5,5,5,6],[5,10,5,11],[6,10,6,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATOS"]
[null,null,null,null,null,"PUNTO DE EQUILIBRIO GENERAL",null,null,null,null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!H10","v":367.22693834320052},null,null,null,"HUESPEDES ESPERADOS",null,null,null,null,null,null,{"$f":"+P5/P5","v":1}]
[null,null,null,null,null,"# HUESPED",null,"INVERSION (CT+GT)",null,"INGRESOS OP.","UTILIDAD",null,null,null,null,800,null,null,null,null,null,null,{"$f":"+P22/P5","v":0.375}]
[null,null,null,null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!E12","v":0},null,{"$f":"+'PUNTO DE EQUILIBRIO'!F12","v":45581752.370117329},null,{"$f":"+'PUNTO DE EQUILIBRIO'!G12","v":0},{"$f":"+'PUNTO DE EQUILIBRIO'!H12","v":-45581752.370117329},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+W4-W5","v":0.625}]
[null,null,null,null,"Q",{"$f":"+'PUNTO DE EQUILIBRIO'!E17","v":367.22693834320052},null,{"$f":"+'PUNTO DE EQUILIBRIO'!F17","v":49208409.737988867},null,{"$f":"+'PUNTO DE EQUILIBRIO'!G17","v":49208409.737988867},{"$f":"+'PUNTO DE EQUILIBRIO'!H17","v":0},null,"Q",null,null,"ESPERADOS",null,null,null,null,null,null,"VELOCIMETRO"]
[null,null,null,null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!E22","v":800},null,{"$f":"+'PUNTO DE EQUILIBRIO'!F22","v":53482387.076784},null,{"$f":"+'PUNTO DE EQUILIBRIO'!G22","v":97400000},{"$f":"+'PUNTO DE EQUILIBRIO'!H22","v":43917612.923216},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W5","v":0.375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GASTOS",null,null,null,null,null,null,null,null,0.03]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UTILIDAD ESPERADA",null,null,null,null,null,null,{"$f":"1.55-SUM(W8:W9)","v":1.145}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!C21","v":0.45089951666546202}]
[null,null,null,"DATOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!H22","v":43917612.923216}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTADO DE RESULTADOS"]
[]
[]
[]
[null,null,null,"COSTOS",null,null,null,null,null,null,null,null,null,null,null,"CLIENTES REALES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ESTADO COSTOS"]
[null,null,null,"ABC"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Q-ESTANDAR",null,null,"Q-JUNIOR/SUITE",null,null,"Q-TWIN",null,null,"Q-TRIPLE",null,null,"Q-SENCILLA",null,null,"Q-GENERAL"]
[null,null,{"$f":"+'PUNTO DE EQUILIBRIO'!$E$46","v":211.15548954734027},150,null,{"$f":"+'PUNTO DE EQUILIBRIO'!$F$46","v":64.264714210060092},31,null,{"$f":"+'PUNTO DE EQUILIBRIO'!$G$46","v":55.084040751480075},10,null,{"$f":"+'PUNTO DE EQUILIBRIO'!$H$46","v":27.542020375740037},15,null,{"$f":"+'PUNTO DE EQUILIBRIO'!$I$46","v":9.1806734585800136},2,null,{"$f":"+C49+F49+I49+L49+O49","v":367.22693834320052},null,{"$f":"+D49+G49+J49+M49+P49","v":208}]
[]
[]
[]
[null,null,1,{"$f":"+D49/C49","v":0.71037698485395318},null,null,{"$f":"+G49/F49","v":0.48237980019130333},null,null,{"$f":"+J49/I49","v":0.18154078501823245},null,null,{"$f":"+M49/L49","v":0.54462235505469736},null,null,{"$f":"+P49/O49","v":0.21784894202187893},null,null,null,{"$f":"+T49/R49","v":0.56640724925688524}]
[null,null,null,{"$f":"+C53-D53","v":0.28962301514604682},null,null,{"$f":"+C53-G53","v":0.51762019980869667},null,null,{"$f":"+C53-J53","v":0.81845921498176755},null,null,{"$f":"+C53-M53","v":0.45537764494530264},null,null,{"$f":"+C53-P53","v":0.78215105797812101},null,null,null,{"$f":"+C53-T53","v":0.43359275074311476}]

{"sheet":"GASTOS","index":1,"n_rows":42,"n_cols":21,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,20,3,20],[19,5,21,5],[1,6,1,9],[1,14,1,17],[16,14,16,15],[16,16,16,17],[1,12,2,13],[1,4,2,5],[1,1,2,2],[17,12,17,13],[25,12,25,13],[3,4,3,5],[17,4,17,5],[25,4,25,5],[3,12,3,13],[17,1,17,2],[25,1,25,2],[3,1,3,2]]}
[]
[null,"5 - GASTOS OPERACIONALES",null,null,"5 - GASTOS FIJOS MES",null,"HUESPED",null,null,null,{"$f":"+BOARDESK!P5","v":800},null,"5 - GASTOS VARIABLES * CLIENTE",null,"CLIENTES PROMEDIO",null,null,null,{"$f":"+K2","v":800},null,"GV. Unit"]
[null,null,null,null,null,null,"ESTÁNDAR","SUITE","TWIN","TRIPLE","SENCILLA",null,null,null,"ESTÁNDAR","SUITE","TWIN","TRIPLE","SENCILLA",null,{"$f":"+S2","v":800}]
[null,"51 -GASTOS DE ADMINISTRACIÓN",null,null,"51 -GASTOS DE ADMINISTRACIÓN FIJOS MES",null,{"$f":"+'PUNTO DE EQUILIBRIO'!E29","v":459.99999999999994},{"$f":"+'PUNTO DE EQUILIBRIO'!F29","v":140},{"$f":"+'PUNTO DE EQUILIBRIO'!G29","v":120},{"$f":"+'PUNTO DE EQUILIBRIO'!H29","v":60},{"$f":"+'PUNTO DE EQUILIBRIO'!I29","v":20},null,"51 -GASTOS DE ADMINISTRACIÓN",null,{"$f":"+G4","v":459.99999999999994},{"$f":"+H4","v":140},{"$f":"+I4","v":120},{"$f":"+J4","v":60},{"$f":"+K4","v":20}]
[null,"DETALLE","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"VALOR"]
[null,"Servicio de energía",{"$f":"DATOS!D7*40%","v":462380},null,"Servicio de energía",{"$f":"+C6*60%","v":277428},{"$f":"+(F6/$K$2)*$G$4","v":159521.1},{"$f":"+(F6/$K$2)*$H$4","v":48549.9},{"$f":"+(F6/$K$2)*$I$4","v":41614.200000000004},{"$f":"+(F6/$K$2)*$J$4","v":20807.100000000002},{"$f":"+(F6/$K$2)*$K$4","v":6935.7000000000007},null,"Servicio de energía",{"$f":"+C6*40%","v":184952},{"$f":"+(N6/$S$2)*$O$4","v":106347.39999999998},{"$f":"+(N6/$S$2)*$P$4","v":32366.6},{"$f":"+(N6/$S$2)*$Q$4","v":27742.799999999999},{"$f":"+(N6/$S$2)*$R$4","v":13871.4},{"$f":"+(N6/$K$2)*$K$4","v":4623.8},null,{"$f":"+N6/$U$3","v":231.19}]
[null,"Servicio de acueducto",{"$f":"DATOS!D26*40%","v":306390.33333333337},null,"Servicio de acueducto",{"$f":"+C7*60%","v":183834.2},{"$f":"+(F7/$K$2)*$G$4","v":105704.66499999999},{"$f":"+(F7/$K$2)*$H$4","v":32170.985000000001},{"$f":"+(F7/$K$2)*$I$4","v":27575.13},{"$f":"+(F7/$K$2)*$J$4","v":13787.565000000001},{"$f":"+(F7/$K$2)*$K$4","v":4595.8550000000005},null,"Servicio de acueducto",{"$f":"+C7*40%","v":122556.13333333336},{"$f":"+(N7/$S$2)*$O$4","v":70469.776666666672},{"$f":"+(N7/$S$2)*$P$4","v":21447.323333333337},{"$f":"+(N7/$S$2)*$Q$4","v":18383.420000000002},{"$f":"+(N7/$S$2)*$R$4","v":9191.7100000000009},{"$f":"+(N7/$K$2)*$K$4","v":3063.9033333333336},null,{"$f":"+N7/$U$3","v":153.19516666666669}]
[null,"Servicio de gas",{"$f":"DATOS!D45*40%","v":483352.93333333335},null,"Servicio de gas",{"$f":"+C8*60%","v":290011.76},166756.76199999999,50752.057999999997,43501.764000000003,21750.882000000001,7250.2939999999999,null,"Servicio de gas",193341.17333333334,111171.17466666666,33834.705333333332,29001.175999999999,14500.588,{"$f":"+(N8/$K$2)*$K$4","v":4833.5293333333339},null,{"$f":"+N8/$U$3","v":241.67646666666667}]
[null,"Gastos Nómina",{"$f":"+NOMINA!D19+NOMINA!D20+NOMINA!D21+NOMINA!D22","v":7987889.2050586659},null,"Gastos Nómina",{"$f":"+C9","v":7987889.2050586659},4593036.2929087318,1397880.6108852664,1198183.3807587998,599091.69037939992,199697.23012646663]
[null,"Arrendamiento",22000000,null,"Arrendamiento",{"$f":"+C10","v":22000000},12649999.999999998,3850000,3300000,1650000,550000]
[null,"Salario contador",1000000,null,"Salario contador",{"$f":"+C11","v":1000000},574999.99999999988,175000,150000,75000,25000]
[null,"Salario Auxiliar Contable",1000000,null,"Salario Auxiliar Contable",1000000,574999.99999999988,175000,150000,75000,25000]
[null,"Salario Auxiliar Administrativo",1000000,null,"Salario Auxiliar Administrativo",1000000,574999.99999999988,175000,150000,75000,25000]
[null,"Salario Administrador",1000000,null,"Salario Administrador",1000000,574999.99999999988,175000,150000,75000,25000]
[null,"Seguridad Social",1717000,null,"Seguridad Social",1717000,987274.99999999988,300475,257550,128775,42925]
[null,"51 - TOTAL GASTOS DE ADMINISTRACIÓN",{"$f":"SUM(C6:C15)","v":36957012.47172533},null,"51 - TOTAL GASTOS DE ADMINISTRACIÓN FIJOS",{"$f":"SUM(F6:F15)","v":36456163.165058665},{"$f":"SUM(G6:G15)","v":20962293.819908731},{"$f":"SUM(H6:H15)","v":6379828.5538852662},{"$f":"SUM(I6:I15)","v":5468424.4747588001},{"$f":"SUM(J6:J15)","v":2734212.2373794001},911404.07912646665,null,"51 - TOTAL GASTOS DE ADMINISTRACIÓN VAR",{"$f":"SUM(N6:N15)","v":500849.3066666667},287988.3513333333,87648.628666666671,75127.396000000008,37563.698000000004,12521.232666666667,null,{"$f":"SUM(U6:U15)","v":626.06163333333336}]
[]
[null,"52 - GASTOS DE VENTAS",null,null,"52 - GASTOS DE VENTAS FIJOS MES",null,{"$f":"+G4","v":459.99999999999994},{"$f":"+H4","v":140},{"$f":"+I4","v":120},{"$f":"+J4","v":60},{"$f":"+K4","v":20},null,"52 - GASTOS DE VENTAS VARIABLES",null,{"$f":"+O4","v":459.99999999999994},{"$f":"+P4","v":140},{"$f":"+Q4","v":120},{"$f":"+R4","v":60},{"$f":"+S4","v":20},null,{"$f":"+S2","v":800}]
[null,"DETALLE","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"VALOR"]
[null,"PAXENGER",119000,null,null,null,null,null,null,null,null,null,"PAXENGER",119000,{"$f":"+(N20/$K$2)*$G$4","v":68424.999999999985},{"$f":"+(N20/$K$2)*$H$4","v":20825},{"$f":"+(N20/$K$2)*$I$4","v":17850},{"$f":"+(N20/$S$2)*$R$4","v":8925},{"$f":"+(N20/$K$2)*$K$4","v":2975},null,{"$f":"+N20/$U$18","v":148.75}]
[null,"BOOKING",636000,null,null,null,null,null,null,null,null,null,"BOOKING",636000,365699.99999999994,{"$f":"+(N21/$K$2)*$H$4","v":111300},95400,47700,15900,null,{"$f":"+N21/$U$18","v":795}]
[null,"DOMINIO PAGINA WEB",96000,null,null,null,null,null,null,null,null,null,"DOMINIO PAGINA WEB",96000,55199.999999999993,16800,14400,7200,2400,null,120]
[null,"SIIGO",1110000,null,"SIIGO",1110000,{"$f":"+(F23/$K$2)*$G$4","v":638249.99999999988},{"$f":"+(F23/$K$2)*$H$4","v":194250},{"$f":"+(F23/$K$2)*$I$4","v":166500},{"$f":"+(F23/$K$2)*$J$4","v":83250},{"$f":"+(F23/$K$2)*$K$4","v":27750}]
[null,"52 - TOTAL GASTO DE VENTAS",{"$f":"SUM(C20:C23)","v":1961000},null,"52 - TOTAL GASTO DE VENTAS FIJOS MES",{"$f":"SUM(F20:F23)","v":1110000},{"$f":"SUM(G20:G23)","v":638249.99999999988},194250,166500,83250,27750,null,"52 - TOTAL GASTO DE VENTAS VARIBALES",{"$f":"SUM(N20:N23)","v":851000},{"$f":"SUM(O20:O23)","v":489324.99999999994},{"$f":"SUM(P20:P23)","v":148925},{"$f":"SUM(Q20:Q23)","v":127650},{"$f":"SUM(R20:R23)","v":63825},{"$f":"SUM(S20:S23)","v":21275},null,{"$f":"SUM(U20:U23)","v":1063.75}]
[]
[null,"53 - OTROS GASTOS",null,null,"53 - OTROS GASTOS FIJOS",null,171.66666666666666,75.5,57.666666666666664,23.916666666666668,36.25,null,"53 - OTROS GASTOS",null,171.66666666666666,75.5,57.666666666666664,23.916666666666668,36.25,null,{"$f":"+S2","v":800}]
[null,"DETALLE","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"DETALLE","VALOR","VALOR","VALOR","VALOR","VALOR","VALOR",null,"VALOR"]
[null,"PAPELERÍA",{"$f":"'[1]GASTOS CAJA MENOR'!$D$102","v":245800},null,null,null,null,null,null,null,null,null,"PAPELERÍA",{"$f":"'[1]GASTOS CAJA MENOR'!$D$102","v":245800},{"$f":"+(N28/$K$2)*$G$4","v":141334.99999999997},{"$f":"+(N28/$K$2)*$H$4","v":43015},{"$f":"+(N28/$K$2)*$I$4","v":36870},{"$f":"+(N28/$S$2)*$R$4","v":18435},{"$f":"+(N28/$K$2)*$K$4","v":6145},null,{"$f":"+N28/$U$26","v":307.25}]
[null,"TARJETA ÉXITO",450000,null,null,null,null,null,null,null,null,null,"TARJETA ÉXITO",450000,258749.99999999997,{"$f":"+(N29/$K$2)*$H$4","v":78750},{"$f":"+(N29/$K$2)*$I$4","v":67500},33750,{"$f":"+(N29/$K$2)*$K$4","v":11250},null,{"$f":"+N29/$U$26","v":562.5}]
[null,"MANTENIMIENTO",1210000,null,null,null,null,null,null,null,null,null,"MANTENIMIENTO",1210000,695749.99999999988,211750,181500,90750,30250,null,1512.5]
[null,"DOTACIÓN",{"$f":"'[1]GASTOS CAJA MENOR'!$D$178","v":116900},null,null,null,null,null,null,null,null,null,"DOTACIÓN",{"$f":"'[1]GASTOS CAJA MENOR'!$D$178","v":116900},67217.499999999985,20457.5,17535,8767.5,2922.5,null,146.125]
[null,"53 - TOTAL OTROS GASTOS",{"$f":"SUM(C28:C31)","v":2022700},null,"53 - TOTAL OTROS GASTOS",{"$f":"SUM(F28:F31)","v":0},{"$f":"SUM(G28:G31)","v":0},0,0,0,0,null,"53 - TOTAL OTROS GASTOS",{"$f":"SUM(N28:N31)","v":2022700},{"$f":"SUM(O28:O31)","v":1163052.4999999998},{"$f":"SUM(P28:P31)","v":353972.5},{"$f":"SUM(Q28:Q31)","v":303405},{"$f":"SUM(R28:R31)","v":151702.5},{"$f":"SUM(S28:S31)","v":50567.5},null,{"$f":"SUM(U28:U31)","v":2528.375}]
[]
[null,"5 - TOTAL GASTOS 51+52+53",{"$f":"+C16+C24+C32","v":40940712.47172533},null,"5 - TOTAL GASTOS FIJOS MENSUALES",{"$f":"F16+F24+F32","v":37566163.165058665},{"$f":"G16+G24+G32","v":21600543.819908731},6574078.5538852662,5634924.4747588001,2817462.2373794001,939154.07912646665,null,"5 - TOTAL GASTOS VARIABLES",{"$f":"N16+N24+N32","v":3374549.3066666666},{"$f":"O16+O24+O32","v":1940365.8513333329},590546.12866666669,506182.39600000001,253091.198,84363.732666666663,null,{"$f":"U16+U24+U32","v":4218.1866333333328}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GV. Unit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N34/S2","v":4218.1866333333337}]
[]
[]
[]
[]
[null,"BOARDESK",null,null,"BOARDESK"]

{"sheet":"COSTOS","index":2,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,10,4,10],[55,10,56,10],[58,8,59,8],[58,10,59,10],[57,5,57,6],[58,5,59,6],[31,1,31,4],[38,2,38,4],[55,8,56,8],[54,5,54,6],[54,1,54,4],[34,1,34,6],[47,2,47,4],[48,2,48,4],[49,2,49,4],[50,2,50,4],[51,2,51,4],[41,1,41,4],[39,2,39,4],[36,1,36,6],[37,2,37,4],[26,2,26,3],[30,1,30,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[3,8,5,8],[5,1,5,6],[23,1,23,3],[42,1,42,4],[52,1,52,4],[46,2,46,4],[44,1,44,6],[45,1,45,6],[14,1,14,3],[15,1,15,6],[3,1,3,6],[4,1,4,6],[24,1,24,6],[35,1,35,6],[40,2,40,4],[25,1,25,6]]}
[]
[null,"7 - COSTOS DE PRODUCCIÓN",null,null,null,null,null,null,null,null,{"$f":"+BOARDESK!P5","v":800}]
[]
[null,"71 - MATERIA PRIMA ",null,null,null,null,null,null,"CF",null,"CV"]
[null,"710501 - MATERIA PRIMA DIRECTA CAMARERÍA"]
[null,"ELEMENTOS DE ASEO",null,null,null,null,null,null,null,null,"HUESPED"]
[null,"CANTIDAD","ARTÍCULO","UNIDAD DE MEDIDA","VALOR","ANUAL","MENSUAL",null,"MENSUAL"]
[null,6,"ESCOBAS","UNIDAD",6500,{"$f":"E8*B8","v":39000},{"$f":"+F8/12","v":3250},null,{"$f":"+G8","v":3250}]
[null,10,"TRAPEROS","UNIDAD",12300,{"$f":"E9*B9","v":123000},{"$f":"+F9/12","v":10250},null,{"$f":"+G9","v":10250}]
[null,2,"RECOGEDORES","UNIDAD",4800,{"$f":"E10*B10","v":9600},800,null,800]
[null,24,"AMBIENTADOR ","UNIDAD",6700,{"$f":"E11*B11","v":160800},13400,null,13400]
[null,2,"JABÓN TOCADOR CAJA *121","UNIDAD",133000,{"$f":"B12*E12","v":266000},22166.666666666668,null,null,null,{"$f":"+G12","v":22166.666666666668}]
[null,4,"DETERGENTE BOLSA *1000 GR","UNIDAD",17200,{"$f":"B13*E13","v":68800},5733.333333333333,null,null,null,{"$f":"+G13","v":5733.333333333333}]
[null,15,"PAPEL HIGIENICO PACA *12 UNIDADES","UNIDAD",19990,{"$f":"B14*E14","v":299850},24987.5,null,null,null,24987.5]
[null,"7105 - MATERIA PRIMA DIRECTA CAMARERÍA",null,null,{"$f":"SUM(E8:E14)","v":200490},{"$f":"SUM(F8:F14)","v":967050},{"$f":"SUM(G8:G14)","v":80587.5},null,{"$f":"SUM(I8:I14)","v":27700},null,{"$f":"SUM(K12:K14)","v":52887.5}]
[null,"710502 - INSUMOS DESAYUNOS"]
[null,"CANTIDAD","ARTÍCULO","UNIDAD DE MEDIDA","DATO","VALOR MES","DIARIO",null,"MENSUAL",null,"HUESPED"]
[null,47,"HUEVOS","Panal * 30",16800,{"$f":"+G18*12","v":315840},{"$f":"+(E18/30)*B18","v":26320},null,null,null,{"$f":"+F18","v":315840}]
[null,9,"CAFÉ","Libra",13200,{"$f":"B19*E19","v":118800},{"$f":"+(E19/30)*B19","v":3960},null,null,null,{"$f":"+F19","v":118800}]
[null,9,"CHOCOLATE","Libra",13380,120420,4014,null,null,null,120420]
[null,44,"AREPAS","Paquete * 10 ",3950,173800,5793.333333333333,null,null,null,173800]
[null,218,"PAN UNIDAD","UNIDAD",400,87200,2906.666666666667,null,null,null,87200]
[null,12,"LECHE","Paca * 6 ",23990,287880,9596,null,null,null,287880]
[null,"TOTAL INSUMOS DESAYUNO",null,null,{"$f":"SUM(E18:E23)","v":71720},{"$f":"SUM(F18:F23)","v":1103940},{"$f":"SUM(G18:G23)","v":52590},null,{"$f":"SUM(I18:I23)","v":0},null,{"$f":"SUM(K18:K23)","v":1103940}]
[null,"7110 - MATERIA PRIMA INDIRECTA CAMARERÍA"]
[null,"ELEMENTOS DE ASEO"]
[null,"CANTIDAD","ARTÍCULO",null,"UNIDAD DE MEDIDA","MENSUAL","DIARIO",null,"MENSUAL",null,"HUESPED"]
[null,1,"OTROS ELEMENTOS CAMARERÍA",null,"N/A",535054,{"$f":"+F28/30","v":17835.133333333335},null,null,null,{"$f":"+F28","v":535054}]
[null,1,"OTROS  INSUMOS DESAYUNOS",null,"N/A",691919,{"$f":"+F29/30","v":23063.966666666667},null,null,null,{"$f":"+F29","v":691919}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,"7110 - MATERIA PRIMA INDIRECTA CAMARERÍA",null,null,null,{"$f":"SUM(F28:F30)","v":1226973},{"$f":"SUM(G28:G30)","v":40899.100000000006},null,{"$f":"SUM(I28:I30)","v":0},null,{"$f":"SUM(K28:K30)","v":1226973}]
[null,"71 - TOTAL COSTOS MATERIA PRIMA (7105 + 7110) ",null,null,null,{"$f":"+G15+F24+F31","v":2411500.5},{"$f":"+G15+G24+G31","v":174076.6},null,{"$f":"+I15+I24+I31","v":27700},null,{"$f":"+K15+K24+K31","v":2383800.5}]
[null,null,null,null,null,"MENSUAL"]
[]
[null,"72. MANO DE OBRA"]
[null,"720501 - MANO DE OBRA DIRECTA"]
[null,"CAMAS"]
[null,"CANTIDAD","DESCRIPCIÓN",null,null,"MENSUAL","DIARIO",null,"MENSUAL",null,"HUESPED"]
[null,2,"CAMARERIA",null,null,{"$f":"+NOMINA!D19+NOMINA!D22","v":3993944.602529333},{"$f":"+F39/30","v":133131.48675097775},null,{"$f":"+F39","v":3993944.602529333}]
[null,2,"RECEPCIÓN",null,null,{"$f":"+NOMINA!D20+NOMINA!D21","v":3993944.602529333},{"$f":"+F40/30","v":133131.48675097775},null,{"$f":"+F40","v":3993944.602529333}]
[null,null,null,null,null,null,0,null,{"$f":"+G41/$K$2","v":0}]
[null,"720501- TOTAL MANO DE OBRA DIRECTA",null,null,null,{"$f":"SUM(F39:F40)","v":7987889.2050586659},{"$f":"SUM(G39:G40)","v":266262.97350195551},null,{"$f":"SUM(I39:I41)","v":7987889.2050586659},null,{"$f":"SUM(K39:K41)","v":0}]
[null,"72 - TOTAL COSTOS MANO DE OBRA (7205 + 7210) ",null,null,null,{"$f":"+F42","v":7987889.2050586659},{"$f":"+G42","v":266262.97350195551},null,{"$f":"+I42","v":7987889.2050586659},null,{"$f":"+K42","v":0}]
[]
[null,"3. COSTOS INDIRECTOS DE FABRICACIÓN"]
[null,"CLIENTES"]
[null,"CANTIDAD","SERVICIO",null,null,"MENSUAL","DIARIO",null,"MENSUAL",null,"HUESPED"]
[null,null,"ACUEDUCTO",null,null,{"$f":"DATOS!D26*60%","v":459585.5},{"$f":"+F48/30","v":15319.516666666666},null,null,null,{"$f":"+F48","v":459585.5}]
[null,null,"ENERGIA",null,null,{"$f":"DATOS!D7*60%","v":693570},{"$f":"+F49/30","v":23119},null,null,null,{"$f":"+F49","v":693570}]
[null,null,"GAS",null,null,{"$f":"DATOS!D45*60%","v":725029.39999999991},24167.646666666664,null,null,null,725029.39999999991]
[null,null,"CELULAR",null,null,32000,1066.6666666666667,null,null,null,32000]
[null,null,"DOCLECLICK",null,null,232100,7736.666666666667,null,null,null,232100]
[null,"TOTAL CIF",null,null,null,{"$f":"SUM(F48:F52)","v":2142284.9},{"$f":"SUM(G48:G52)","v":71409.496666666659},null,{"$f":"SUM(I48:I52)","v":0},null,{"$f":"SUM(K48:K52)","v":2142284.9}]
[]
[null,"7 - COSTOS DE PRODUCCIÓN MES (71+72+73)",null,null,null,{"$f":"+F53+F43+F32","v":12541674.605058666},null,null,{"$f":"+I32+I43+I53","v":8015589.2050586659},null,{"$f":"+K32+K43+K53","v":4526085.4000000004}]
[null,null,null,null,null,null,null,null,"CFT",null,"CVT"]
[]
[null,null,null,null,null,{"$f":"+F55/K2","v":15677.093256323333},null,null,{"$f":"+I55/K2","v":10019.486506323332},null,{"$f":"+K55/K2","v":5657.6067500000008}]
[null,null,null,null,null,"C Unitario",null,null,"CF Unitario",null,"CV Unitario"]

{"sheet":"PUNTO DE EQUILIBRIO","index":3,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[9,4,9,6],[45,2,45,3],[29,9,30,9],[31,9,33,9],[31,2,31,3],[32,2,32,3],[33,2,33,3],[29,2,29,3],[30,2,30,3],[39,2,39,3],[39,9,41,9],[40,2,40,3],[41,2,41,3],[35,2,35,3],[35,9,37,9],[36,2,36,3],[28,2,28,3],[43,2,43,3],[44,2,44,3],[3,1,3,2],[37,2,37,3]]}
[]
[null,"PUNTO DE EQUILIBRIO ESPECÍFICO PROMEDIO"]
[]
[null,"PUNTO DE EQUILIBRIO "]
[]
[]
[]
[]
[null,null,null,null,{"$f":"+E22-E17","v":432.77306165679948},{"$f":"+E9/5","v":86.554612331359891}]
[null,"COSTOS FIJOS TOTALES",{"$f":"+COSTOS!I55","v":8015589.2050586659},null,{"$f":"+B2","v":"PUNTO DE EQUILIBRIO ESPECÍFICO PROMEDIO"},null,null,{"$f":"+C12/(C19-C16)","v":367.22693834320052}]
[null,"GASTOS FIJOS TOTALES",{"$f":"+GASTOS!F34","v":37566163.165058665},null,"# HUESPED","INVERSION (CT+GT)","INGRESOS OPERACIONALES","UTILIDAD"]
[null,"CF + GF",{"$f":"+C11+C10","v":45581752.370117329},null,0,{"$f":"+(E12*$C$16)+$C$12","v":45581752.370117329},{"$f":"+E12*$C$19","v":0},{"$f":"+G12-F12","v":-45581752.370117329}]
[null,null,null,null,{"$f":"+E17/5","v":73.445387668640109},{"$f":"+(E13*$C$16)+$C$12","v":46307083.84369164},{"$f":"+E13*$C$19","v":9841681.9475977737},{"$f":"+G13-F13","v":-36465401.896093868}]
[null,"COSTO Variable Unitario",{"$f":"+COSTOS!K58","v":5657.6067500000008},null,{"$f":"+E13*2","v":146.89077533728022},47032415.317265943,19683363.895195547,-27349051.422070395]
[null,"GASTO Varibale Unitario",{"$f":"+GASTOS!U34","v":4218.1866333333328},null,{"$f":"+E13*3","v":220.33616300592033},47757746.790840253,29525045.842793323,-18232700.94804693]
[null,"Cvu + Gvu",{"$f":"+C38","v":9875.7933833333336},null,{"$f":"+E13*4","v":293.78155067456044},48483078.264414556,39366727.790391095,-9116350.4740234613]
[null,null,null,null,{"$f":"+H10","v":367.22693834320052},49208409.737988867,49208409.737988867,0]
[null,"HUESPEDES ESPERADOS",{"$f":"BOARDESK!P5","v":800},null,{"$f":"+E17+F9","v":453.78155067456044},50063205.205747895,60806727.790391095,10743522.5846432]
[null,"PRECIO DE VENTA PROMEDIO",{"$f":"+C31","v":134000},null,{"$f":"+E18+F9","v":540.3361630059203},50918000.673506916,72405045.842793316,21487045.1692864]
[null,"INGRESOS OPERACIONALES (HUESPEDES)",{"$f":"+G22","v":97400000},null,{"$f":"+E19+F9","v":626.89077533728016},51772796.141265944,84003363.895195544,32230567.7539296]
[null,"MARGEN DE UTILIDAD",{"$f":"+H22/G22","v":0.45089951666546202},null,{"$f":"+E20+F9","v":713.44538766864002},52627591.609024972,95601681.947597757,42974090.338572785]
[null,"UTILIDAD ESPERADA",{"$f":"+C20*C21","v":43917612.923216},null,{"$f":"+C18","v":800},53482387.076784,{"$f":"+'ESTADO DE RESULTADOS'!F10","v":97400000},43917612.923216]
[]
[]
[]
[null,null,null,null,"ESTÁNDAR","SUITE","TWIN","TRIPLE","SENCILLA","T. HAB"]
[null,null,null,null,{"$f":"+DATOS!I5","v":23},{"$f":"+DATOS!I6","v":7},{"$f":"+DATOS!I7","v":6},{"$f":"+DATOS!I8","v":3},{"$f":"+DATOS!I9","v":1},{"$f":"SUM(E27:I27)","v":40}]
[null,null,null,null,{"$f":"+E27/J27","v":0.57499999999999996},{"$f":"+F27/J27","v":0.17499999999999999},{"$f":"+G27/J27","v":0.15},{"$f":"+H27/J27","v":7.4999999999999997E-2},{"$f":"+I27/J27","v":2.5000000000000001E-2},{"$f":"SUM(E28:I28)","v":1}]
[null,null,"HUESPED ESPERADOS",null,{"$f":"+$C$18*E28","v":459.99999999999994},{"$f":"+$C$18*F28","v":140},{"$f":"+$C$18*G28","v":120},{"$f":"+$C$18*H28","v":60},{"$f":"+$C$18*I28","v":20},{"$f":"SUM(E29:I29)","v":800},"←Proyección de Huesped por Habitación"]
[null,null,"Tarifa Promedio",null,"$ ESTÁNDAR","$ SUITE","$ TWIN","$ TRIPLE","$ SENCILLA","HUESPED ESPERADOS"]
[null,null,{"$f":"(SUM(E31:I31))/5","v":134000},null,{"$f":"+DATOS!J5","v":100000},{"$f":"+DATOS!J6","v":130000},{"$f":"+DATOS!J7","v":180000},{"$f":"+DATOS!J8","v":160000},{"$f":"+DATOS!J9","v":100000}]
[null,"COSTOS FIJOS TOTALES",{"$f":"+COSTOS!I55","v":8015589.2050586659},null,{"$f":"+$C$32*E28","v":4608963.7929087328},{"$f":"+$C$32*F28","v":1402728.1108852664},{"$f":"+$C$32*G28","v":1202338.3807587998},{"$f":"+$C$32*H28","v":601169.19037939992},{"$f":"+$C$32*I28","v":200389.73012646666},{"$f":"+J29","v":800}]
[null,"GASTOS FIJOS TOTALES",{"$f":"+GASTOS!F34","v":37566163.165058665},null,{"$f":"+GASTOS!G34","v":21600543.819908731},{"$f":"+GASTOS!H34","v":6574078.5538852662},{"$f":"+GASTOS!I34","v":5634924.4747588001},{"$f":"+GASTOS!J34","v":2817462.2373794001},{"$f":"+GASTOS!K34","v":939154.07912646665}]
[null,"CF + GF",{"$f":"+C32+C33","v":45581752.370117329},null,{"$f":"+E32+E33","v":26209507.612817463},{"$f":"+F32+F33","v":7976806.6647705324},6837262.8555175997,3418631.4277587999,1139543.8092529334]
[]
[null,"COSTO Varibale Unitario",{"$f":"+COSTOS!K58","v":5657.6067500000008},null,{"$f":"+$C$36*E28","v":3253.1238812500001},{"$f":"+$C$36*F28","v":990.0811812500001},{"$f":"+$C$36*G28","v":848.6410125000001},{"$f":"+$C$36*H28","v":424.32050625000005},{"$f":"+$C$36*I28","v":141.44016875000003},"UN SOLO HUESPED"]
[null,"GASTOS Variable Unitario",{"$f":"+GASTOS!U34","v":4218.1866333333328},null,{"$f":"+$C$37*E28","v":2425.457314166666},{"$f":"+$C$37*F28","v":738.18266083333322},{"$f":"+$C$37*G28","v":632.72799499999985},{"$f":"+$C$37*H28","v":316.36399749999993},{"$f":"+$C$37*I28","v":105.45466583333332}]
[null,"CVu + Gvu",{"$f":"+C36+C37","v":9875.7933833333336},null,{"$f":"+E36+E37","v":5678.5811954166657},{"$f":"+F36+F37","v":1728.2638420833332},{"$f":"+G36+G37","v":1481.3690075},{"$f":"+H36+H37","v":740.68450374999998},{"$f":"+I36+I37","v":246.89483458333336}]
[]
[null,"COSTO VARIABLES TOTALES",{"$f":"+C36*$J$40","v":4526085.4000000004},null,{"$f":"+E36*$J$40","v":2602499.105},{"$f":"+F36*$J$40","v":792064.94500000007},678912.81,339456.40500000003,113152.13500000002,{"$f":"+J32","v":800}]
[null,"GASTOS VARIABLES TOTALES",{"$f":"+C37*J40","v":3374549.3066666662},null,{"$f":"+E37*$J$40","v":1940365.8513333327},{"$f":"+F37*$J$40","v":590546.12866666657},506182.39599999989,253091.19799999995,84363.732666666663]
[null,"CVT + CFT",{"$f":"+C40+C41","v":7900634.706666667},null,{"$f":"+E40+E41","v":4542864.9563333327},{"$f":"+F40+F41","v":1382611.0736666666},{"$f":"+G40+G41","v":1185095.206},{"$f":"+H40+H41","v":592547.603},{"$f":"+I40+I41","v":197515.86766666669}]
[]
[null,null,"Q PROMEDIO",null,"$ ESTÁNDAR","$ SUITE","$ TWIN","$ TRIPLE","$ SENCILLA","Q GENERAL"]
[null,"HUESPEDES ESPERADOS",{"$f":"+J40","v":800},null,{"$f":"+E29","v":459.99999999999994},{"$f":"+F29","v":140},120,60,20,{"$f":"SUM(E45:I45)","v":800}]
[null,"PUNTO DE EQUILIBRIO",{"$f":"+C34/(C31-C38)","v":367.22693834320052},null,{"$f":"+C46*E28","v":211.15548954734027},{"$f":"+C46*F28","v":64.264714210060092},{"$f":"+C46*G28","v":55.084040751480075},{"$f":"+C46*H28","v":27.542020375740037},{"$f":"+C46*I28","v":9.1806734585800136},{"$f":"SUM(E46:I46)","v":367.22693834320052}]

{"sheet":"DATOS","index":4,"n_rows":76,"n_cols":39,"rows_kept":76,"cut":false,"hidden":false,"merged":[[17,21,17,22],[8,6,8,7],[9,6,9,7],[9,8,9,9],[1,21,1,23],[2,21,3,21],[2,22,3,22],[2,23,3,23],[4,23,16,23],[1,6,1,9],[1,16,1,19],[2,6,2,9],[2,16,3,16],[1,11,1,14],[2,13,3,13],[2,14,3,14],[7,6,7,7],[8,11,8,12],[9,11,9,12],[10,11,10,12],[17,16,17,18],[4,19,16,19],[2,17,3,18],[2,19,3,19],[21,1,21,2],[22,1,22,2],[23,3,24,4],[25,3,26,4],[39,1,39,2],[40,1,40,2],[20,1,20,2],[58,1,58,2],[59,1,59,2],[41,1,41,2],[42,3,43,4],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,3,5,4],[6,3,7,4],[5,6,5,7],[6,11,6,12],[6,6,6,7],[7,11,7,12],[2,11,3,12],[3,6,3,7],[4,38,16,38],[15,26,15,27],[8,17,8,18],[10,17,10,18],[11,17,11,18],[44,3,45,4],[4,11,4,12],[4,6,4,7],[12,17,12,18],[13,17,13,18],[14,17,14,18],[16,11,16,12],[18,11,19,12],[18,13,19,13],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[15,17,15,18],[4,14,16,14],[17,11,17,13],[5,11,5,12],[9,17,9,18],[11,11,11,12],[1,35,1,38],[4,36,4,37],[5,36,5,37],[2,38,3,38],[14,26,14,27],[1,30,1,33],[4,31,4,32],[5,31,5,32],[6,31,6,32],[7,31,7,32],[8,31,8,32],[9,31,9,32],[10,31,10,32],[11,31,11,32],[12,31,12,32],[13,31,13,32],[14,31,14,32],[1,25,1,28],[4,26,4,27],[5,26,5,27],[6,26,6,27],[7,26,7,27],[2,25,3,25],[2,26,3,27],[2,28,3,28],[2,35,3,35],[2,36,3,37],[6,36,6,37],[7,36,7,37],[4,17,4,18],[5,17,5,18],[6,17,6,18],[7,17,7,18],[2,30,3,30],[2,31,3,32],[2,33,3,33],[15,31,15,32],[11,36,11,37],[12,36,12,37],[13,36,13,37],[14,36,14,37],[17,25,17,27],[17,30,17,32],[17,35,17,37],[15,36,15,37],[4,28,16,28],[4,33,16,33],[8,36,8,37],[9,36,9,37],[10,36,10,37],[8,26,8,27],[9,26,9,27],[10,26,10,27],[11,26,11,27],[12,26,12,27],[13,26,13,27]]}
[]
[null,"HOTEL SAN JERÓNIMO",null,null,null,null,"HOTEL SAN JERONIMO",null,null,null,null,"HUESPEDES POR MES",null,null,null,null,"HABITACIÓN ESTANDAR",null,null,null,null,"HABITACIÓN SUPERIOR/JUNIOR SUITE",null,null,null,"HABITACIÓN TWIN",null,null,null,null,"HABITACIÓN TRIPLE",null,null,null,null,"HABITACIÓN SENCILLA"]
[null,"SERVICIO DE ENERGIA",null,null,null,null,"TARIFAS A 2022",null,null,null,null,"MES",null,"CANTIDAD","PROMEDIO MENSUAL",null,"MES","N° VECES VENDIDA",null,"PROMEDIO MENSUAL",null,"MES","N° VECES VENDIDA","PROMEDIO MENSUAL",null,"MES","N° VECES VENDIDA",null,"PROMEDIO MENSUAL",null,"MES","N° VECES VENDIDA",null,"PROMEDIO MENSUAL",null,"MES","N° VECES VENDIDA",null,"PROMEDIO MENSUAL"]
[null,2022,null,null,null,null,"TIPO DE HABITACIÓN",null,"N° HABITACIÓN","TARIFA"]
[null,"MES ","VALOR","PROMEDIO PONDERADO ENERGIA",null,null,"ESTANDAR",null,23,100000,null,"ENERO",null,499,{"$f":"N17/12","v":544.83333333333337},null,"ENERO",109,null,{"$f":"R17/12","v":171.66666666666666},null,"ENERO",76,{"$f":"W17/12","v":75.5},null,"ENERO",54,null,{"$f":"AA17/12","v":57.666666666666664},null,"ENERO",22,null,{"$f":"AF17/12","v":23.916666666666668},null,"ENERO",33,null,{"$f":"AK17/12","v":36.25}]
[null,"ENERO",{"$f":"'[2]GASTOS CAJA MENOR'!$L$8","v":1047000},null,null,null,"SUPERIOR/JUNIOR SUITE",null,7,130000,null,"FEBRERO",null,376,null,null,"FEBRERO",115,null,null,null,"FEBRERO",69,null,null,"FEBRERO",21,null,null,null,"FEBRERO",19,null,null,null,"FEBRERO",24]
[null,"FEBRERO",{"$f":"'[3]GASTOS CAJA MENOR'!$L$18","v":1180000},{"$f":"C18/12","v":1155950},null,null,"TWIN",null,6,180000,null,"MARZO",null,401,null,null,"MARZO",149,null,null,null,"MARZO",51,null,null,"MARZO",37,null,null,null,"MARZO",33,null,null,null,"MARZO",22]
[null,"MARZO",{"$f":"'[4]GASTOS CAJA MENOR'!$L$19","v":1091600},null,null,null,"TRIPLE",null,3,160000,null,"ABRIL",null,734,null,null,"ABRIL",194,null,null,null,"ABRIL",102,null,null,"ABRIL",49,null,null,null,"ABRIL",31,null,null,null,"ABRIL",11]
[null,"ABRIL",{"$f":"'[5]GASTOS CAJA MENOR'!$L$16","v":1048400},null,null,null,"SENCILLA",null,1,100000,null,"MAYO",null,677,null,null,"MAYO",166,null,null,null,"MAYO",81,null,null,"MAYO",27,null,null,null,"MAYO",26,null,null,null,"MAYO",47]
[null,"MAYO",{"$f":"'[6]GASTOS CAJA MENOR'!$L$13","v":1179300},null,null,null,"TOTAL HABITACIONES",null,{"$f":"SUM(I5:I9)","v":40},null,null,"JUNIO",null,478,null,null,"JUNIO",201,null,null,null,"JUNIO",78,null,null,"JUNIO",66,null,null,null,"JUNIO",27,null,null,null,"JUNIO",26]
[null,"JUNIO",{"$f":"'[7]GASTOS CAJA MENOR'!$L$15","v":1208700},null,null,null,null,null,null,null,null,"JULIO",null,589,null,null,"JULIO",177,null,null,null,"JULIO",74,null,null,"JULIO",91,null,null,null,"JULIO",20,null,null,null,"JULIO",56]
[null,"JULIO",1026600,null,null,null,null,null,null,null,null,"AGOSTO",null,698,null,null,"AGOSTO",198,null,null,null,"AGOSTO",70,null,null,"AGOSTO",70,null,null,null,"AGOSTO",19,null,null,null,"AGOSTO",54]
[null,"AGOSTO",1169900,null,null,null,null,null,null,null,null,"SEPTIEMBRE",null,445,null,null,"SEPTIEMBRE",231,null,null,null,"SEPTIEMBRE",78,null,null,"SEPTIEMBRE",55,null,null,null,"SEPTIEMBRE",11,null,null,null,"SEPTIEMBRE",29]
[null,"SEPTIEMBRE",{"$f":"'[8]GASTOS CAJA MENOR'!$L$21","v":1200700},null,null,null,null,null,null,null,null,"OCTUBRE",null,506,null,null,"OCTUBRE",143,null,null,null,"OCTUBRE",66,null,null,"OCTUBRE",61,null,null,null,"OCTUBRE",18,null,null,null,"OCTUBRE",44]
[null,"OCTUBRE",{"$f":"'[9]GASTOS CAJA MENOR'!$L$15","v":1286500},null,null,null,null,null,null,null,null,"NOVIEMBRE",null,621,null,null,"NOVIEMBRE",183,null,null,null,"NOVIEMBRE",73,null,null,"NOVIEMBRE",73,null,null,null,"NOVIEMBRE",17,null,null,null,"NOVIEMBRE",21]
[null,"NOVIEMBRE",{"$f":"'[10]GASTOS CAJA MENOR'!$L$18","v":1270000},null,null,null,null,null,null,null,null,"DICIEMBRE",null,514,null,null,"DICIEMBRE",194,null,null,null,"DICIEMBRE",88,null,null,"DICIEMBRE",88,null,null,null,"DICIEMBRE",44,null,null,null,"DICIEMBRE",68]
[null,"DICIEMBRE",{"$f":"'[11]GASTOS CAJA MENOR'!$L$14","v":1162700},null,"BOARDESK",null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(N5:N16)","v":6538},null,null,"TOTAL",{"$f":"SUM(R5:S16)","v":2060},null,null,null,"TOTAL",{"$f":"SUM(W5:W16)","v":906},null,null,"TOTAL",{"$f":"SUM(AA5:AB16)","v":692},null,null,null,"TOTAL",{"$f":"SUM(AF5:AG16)","v":287},null,null,null,"TOTAL",{"$f":"SUM(AK5:AL16)","v":435}]
[null,"TOTAL",{"$f":"SUM(C6:C17)","v":13871400},null,null,null,null,null,null,null,null,"PROMEDIO DIARIO",null,null,{"$f":"+O5/30","v":18.161111111111111},null,"PROMEDIO DIARIO",null,null,{"$f":"T5/30","v":5.7222222222222223},null,"PROMEDIO DIARIO",null,{"$f":"X5/30","v":2.5166666666666666},null,"PROMEDIO DIARIO",null,null,{"$f":"AC5/30","v":1.9222222222222221},null,"PROMEDIO DIARIO",null,null,{"$f":"AH5/30","v":0.79722222222222228},null,"PROMEDIO DIARIO",null,null,{"$f":"AM5/30","v":1.2083333333333333}]
[]
[]
[null,"HOTEL SAN JERÓNIMO"]
[null,"SERVICIO DE ACUEDUCTO"]
[null,2022]
[null,"MES ","VALOR","PROMEDIO PONDERADO ACUEDUCTO"]
[null,"ENERO",{"$f":"'[2]GASTOS CAJA MENOR'!$L$20","v":710210}]
[null,"FEBRERO",{"$f":"'[3]GASTOS CAJA MENOR'!$L$21","v":746000},{"$f":"C37/12","v":765975.83333333337}]
[null,"MARZO",{"$f":"'[4]GASTOS CAJA MENOR'!$L$30","v":645360}]
[null,"ABRIL",{"$f":"'[5]GASTOS CAJA MENOR'!$L$25","v":639460}]
[null,"MAYO",{"$f":"'[6]GASTOS CAJA MENOR'!$L$25","v":752900}]
[null,"JUNIO",{"$f":"'[7]GASTOS CAJA MENOR'!$L$24","v":399200}]
[null,"JULIO",1014550]
[null,"AGOSTO",888670]
[null,"SEPTIEMBRE",{"$f":"'[8]GASTOS CAJA MENOR'!$L$33","v":999800}]
[null,"OCTUBRE",{"$f":"'[9]GASTOS CAJA MENOR'!$L$26","v":784280}]
[null,"NOVIEMBRE",{"$f":"'[10]GASTOS CAJA MENOR'!$L$28","v":777280}]
[null,"DICIEMBRE",{"$f":"'[11]GASTOS CAJA MENOR'!$L$27","v":834000}]
[null,"TOTAL",{"$f":"SUM(C25:C36)","v":9191710}]
[]
[]
[null,"HOTEL SAN JERÓNIMO"]
[null,"SERVICIO DE GAS"]
[null,2022]
[null,"MES ","VALOR","PROMEDIO PONDERADO GAS"]
[null,"ENERO",{"$f":"'[2]GASTOS CAJA MENOR'!$L$15+'[2]GASTOS CAJA MENOR'!$L$19+'[2]GASTOS CAJA MENOR'!$L$30+'[2]GASTOS CAJA MENOR'!$L$36","v":1200000}]
[null,"FEBRERO",{"$f":"'[3]GASTOS CAJA MENOR'!$L$8+'[3]GASTOS CAJA MENOR'!$L$14+'[3]GASTOS CAJA MENOR'!$L$20+'[3]GASTOS CAJA MENOR'!$L$27","v":802000},{"$f":"C56/12","v":1208382.3333333333}]
[null,"MARZO",{"$f":"'[4]GASTOS CAJA MENOR'!$L$8+'[4]GASTOS CAJA MENOR'!$L$21+'[4]GASTOS CAJA MENOR'!$L$33+'[4]GASTOS CAJA MENOR'!$L$34+'[4]GASTOS CAJA MENOR'!$L$37","v":1600000}]
[null,"ABRIL",{"$f":"'[5]GASTOS CAJA MENOR'!$L$17+'[5]GASTOS CAJA MENOR'!$L$28+'[5]GASTOS CAJA MENOR'!$L$38+'[5]GASTOS CAJA MENOR'!$L$42","v":1000000}]
[null,"MAYO",{"$f":"'[6]GASTOS CAJA MENOR'!$L$10+'[6]GASTOS CAJA MENOR'!$L$19+'[6]GASTOS CAJA MENOR'!$L$30+'[6]GASTOS CAJA MENOR'!$L$31","v":1100000}]
[null,"JUNIO",{"$f":"'[7]GASTOS CAJA MENOR'!$L$8+'[7]GASTOS CAJA MENOR'!$L$16+'[7]GASTOS CAJA MENOR'!$L$28+'[7]GASTOS CAJA MENOR'!$L$33","v":1000550}]
[null,"JULIO",{"$f":"400000+399000+400000","v":1199000}]
[null,"AGOSTO",{"$f":"400000+299600+300000","v":999600}]
[null,"SEPTIEMBRE",{"$f":"'[8]GASTOS CAJA MENOR'!$L$12+'[8]GASTOS CAJA MENOR'!$L$20+'[8]GASTOS CAJA MENOR'!$L$25+'[8]GASTOS CAJA MENOR'!$L$34+'[8]GASTOS CAJA MENOR'!$L$43","v":1800000}]
[null,"OCTUBRE",{"$f":"'[9]GASTOS CAJA MENOR'!$L$27+'[9]GASTOS CAJA MENOR'!$L$28+'[9]GASTOS CAJA MENOR'!$L$29+'[9]GASTOS CAJA MENOR'!$L$33","v":999113}]
[null,"NOVIEMBRE",{"$f":"'[10]GASTOS CAJA MENOR'!$L$9+'[10]GASTOS CAJA MENOR'!$L$17+'[10]GASTOS CAJA MENOR'!$L$27+'[10]GASTOS CAJA MENOR'!$L$29","v":1200000}]
[null,"DICIEMBRE",{"$f":"'[11]GASTOS CAJA MENOR'!$L$10+'[11]GASTOS CAJA MENOR'!$L$15+'[11]GASTOS CAJA MENOR'!$L$26+'[11]GASTOS CAJA MENOR'!$L$32+'[11]GASTOS CAJA MENOR'!$L$35","v":1600325}]
[null,"TOTAL",{"$f":"SUM(C44:C55)","v":14500588}]
[]
[]
[null,"EVENTOS"]
[]
[null,"FECHA","VALOR"]
[null,"2022-02-05",1200000]
[null,"2022-02-22",250000]
[null,"2022-03-04",100000]
[null,"2022-03-08",200000]
[null,"2022-04-19",350000]
[null,"2022-04-25",250000]
[null,"2022-04-30",1200000]
[null,"2022-06-08",370000]
[null,"2022-06-11",1200000]
[null,"2022-07-09",350000]
[null,"2022-09-28",250000]
[null,"2022-11-06",1000000]
[null,"2022-12-17",250000]
[null,"2022-12-30",250000]
[null,"TOTAL",{"$f":"SUM(C62:C75)","v":7220000}]

{"sheet":"NOMINA","index":5,"n_rows":58,"n_cols":35,"rows_kept":58,"cut":false,"hidden":false,"merged":[[3,2,3,6],[16,15,16,18],[16,21,16,23],[16,26,16,29],[52,1,52,5],[9,0,9,1]]}
[]
[null,null,"MES",null,"ENERO","AÑO",2023]
[]
[null,null,"DATOS"]
[null,null,"SUELDO MINIMO  2023",null,1160000,"SALUD ADO",0.04]
[null,null,"AUXILIO DE TRANSPORTE",null,140606,"SALUD ADOR",0.08]
[null,null,"SUBSIDIO ALIMENTACION",null,0,"PENSION ADO.",3.7499999999999999E-2]
[null,null,"AUX.FAMILIAR",null,0,"PENSION ADOR.",0.1125]
[null,null,"RECARGO NOCTURNO",null,0,"C.C.,SENA,ICBF",0.09]
["BOARDESK",null,"HORAS EXTRA DIURNA",null,1.25,"PRIMA",8.3299999999999999E-2]
[null,null,"HORAS EXTRA NOCTURNA",null,1.75,"CESANTIAS",8.3299999999999999E-2]
[null,null,"DOMINICALES",null,1.75,"INT CESANTIAS",0.01]
[null,null,null,null,null,"VACACIONES",4.1700000000000001E-2]
[null,null,null,null,null,"ARL",5.1999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,"M",null,null,null,null,"R"]
[null,null,null,null,null,"FONDO SOLIDAR",0.01,null,null,null,null,null,"F","G",null,"I","J","K","K`","L","(H-L)","N","O","P","Q","(H+Q)","S",null,"U","V","W"]
[null,null,null,"TOTAL ",null,null,null,null,null,null,null,null,"DESCUENTOS","INCAPACIDADES","H","(A*4%)","(A*3,75%)","(A*1%)","(A*1%)","(I+J+K)","VALOR A","(A*8%)","(A*11,25%)",0.09,"(N+O+P)","SUB TOTAL","((A-F-G)/12","T","(X/2)","(X/2)","(S+T+U+V)","X","Y","Z","TOTAL "]
[null,null,null,"NOMINA",null,"A",null,null,"B","C","D","E","HORAS NO","SUPERIORES","(A+B+C+D+E-F-G)","DEDUCCIONES EMPLEADO",null,null,null,"TOTAL","CANCELAR A","EMPLEADOR",null,null,"PAGOS","NOMINA ","PRIMAS Y BONIFICACIONES",null,null,null,"TOTAL","X","(X*1%)","(H*4,17%)","NOMINA"]
["No.","C.C./CÓDIGO","EMPLEADO","MENSUAL","CARGO","SALARIO","DIARIO ","HORA","SUB.FAMILIAR","AUX.TRANSPOR","SUBS.ALIMENT","H.EXTRAS","TRABAJADAS","A TRES DIAS","TTAL.DEV.MES","SALUD","PENSION","ARP","FONDO SOLIDAR","DEDUCCIONES","EMPLEADOS","SALUD","PENSION","PARAFISCALES","EMPLEADOR","MENSUAL","PRIMA SERV.","BONIF.SERV.","PRIMA JUNIO","PRIMA NAVIDAD","PRIMAS Y BON.","CESANTIAS","INT.CESANTIAS","VACACIONES","MENSUAL"]
["1",111,"PEPITO PÉREZ",{"$f":"+AI19","v":1996972.3012646665},"JEFE CAMARERIA ",1160000,{"$f":"+F19/30","v":38666.666666666664},{"$f":"+G19/8","v":4833.333333333333},{"$f":"+E8","v":0},140606,0,0,0,0,{"$f":"+F19+I19+J19+K19+L19-M19-N19","v":1300606},{"$f":"+F19*G5","v":46400},{"$f":"+F19*G7","v":43500},{"$f":"+F19*G14","v":6032},0,{"$f":"SUM(P19:S19)","v":95932},{"$f":"+O19-T19","v":1204674},{"$f":"+F19*G6","v":92800},{"$f":"+F19*G8","v":130500},{"$f":"+F19*9%","v":104400},{"$f":"SUM(V19:X19)","v":327700},{"$f":"+O19+Y19","v":1628306},{"$f":"+(F19-M19)/12","v":96666.666666666672},0,{"$f":"+AF19/2","v":54170.2399},{"$f":"+AF19/2","v":54170.2399},{"$f":"SUM(AA19:AD19)","v":205007.14646666666},{"$f":"+O19*G11","v":108340.4798},{"$f":"+AF19*1%","v":1083.404798},{"$f":"+O19*G13","v":54235.270199999999},{"$f":"+Z19+AE19+AF19+AG19+AH19","v":1996972.3012646665}]
["2",222,"ANASTASÍA MORALES",{"$f":"+AI20","v":1996972.3012646665},"RECEPCIONISTA ",1160000,{"$f":"+F20/30","v":38666.666666666664},{"$f":"+G20/8","v":4833.333333333333},{"$f":"+E8","v":0},140606,0,0,0,0,{"$f":"+F20+I20+J20+K20+L20-M20-N20","v":1300606},{"$f":"+F20*G5","v":46400},{"$f":"+F20*G7","v":43500},{"$f":"+F20*G14","v":6032},0,{"$f":"SUM(P20:S20)","v":95932},{"$f":"+O20-T20","v":1204674},{"$f":"+F20*G6","v":92800},{"$f":"+F20*G8","v":130500},104400,{"$f":"SUM(V20:X20)","v":327700},{"$f":"+O20+Y20","v":1628306},{"$f":"+(F20-M20)/12","v":96666.666666666672},0,{"$f":"+AF20/2","v":54170.2399},{"$f":"+AF20/2","v":54170.2399},{"$f":"SUM(AA20:AD20)","v":205007.14646666666},{"$f":"+O20*G11","v":108340.4798},{"$f":"+AF20*1%","v":1083.404798},{"$f":"+O20*G13","v":54235.270199999999},{"$f":"+Z20+AE20+AF20+AG20+AH20","v":1996972.3012646665}]
["3",333,"GODOLFO ÑAÑEZ",1996972.3012646665,"RECEPCIONISTA ",1160000,38666.666666666664,4833.333333333333,{"$f":"+E8","v":0},140606,0,0,0,0,1300606,{"$f":"+F21*G5","v":46400},{"$f":"+F21*G7","v":43500},{"$f":"+F21*G14","v":6032},0,95932,1204674,{"$f":"+F21*G6","v":92800},{"$f":"+F21*G8","v":130500},104400,327700,1628306,96666.666666666672,0,54170.2399,54170.2399,205007.14646666666,{"$f":"+O21*G11","v":108340.4798},1083.404798,{"$f":"+O21*G13","v":54235.270199999999},1996972.3012646665]
["4",444,"LULU PATAQUIBA",1996972.3012646665,"AUX CAMARERIA",1160000,38666.666666666664,4833.333333333333,{"$f":"+E8","v":0},140606,0,0,0,0,1300606,{"$f":"+F22*G5","v":46400},{"$f":"+F22*G7","v":43500},{"$f":"+F22*G14","v":6032},0,95932,1204674,{"$f":"+F22*G6","v":92800},{"$f":"+F22*G8","v":130500},104400,327700,1628306,96666.666666666672,0,54170.2399,54170.2399,205007.14646666666,{"$f":"+O22*G11","v":108340.4798},1083.404798,{"$f":"+O22*G13","v":54235.270199999999},1996972.3012646665]
["5",555,"EUSTAQUIO GALLEGO",1996972.3012646665,"AUX ADMINISTRATIVO",1160000,38666.666666666664,4833.333333333333,{"$f":"+E8","v":0},140606,0,0,0,0,1300606,{"$f":"+F23*G5","v":46400},{"$f":"+F23*G7","v":43500},{"$f":"+F23*G14","v":6032},0,{"$f":"SUM(P23:S23)","v":95932},1204674,{"$f":"+F23*G6","v":92800},{"$f":"+F23*G8","v":130500},104400,327700,1628306,96666.666666666672,0,54170.2399,54170.2399,205007.14646666666,{"$f":"+O23*G11","v":108340.4798},1083.404798,{"$f":"+O23*G13","v":54235.270199999999},1996972.3012646665]
["6",666,"MANUELITA BELLO",1996972.3012646665,"AUX CONTABLE",1160000,38666.666666666664,4833.333333333333,{"$f":"+E8","v":0},140606,0,{"$f":"+L23*2","v":0},0,0,{"$f":"+F24+I24+J24+K24+L24-M24-N24","v":1300606},{"$f":"+F24*G5","v":46400},{"$f":"+F24*G7","v":43500},{"$f":"+F24*G14","v":6032},0,95932,1204674,{"$f":"+F24*G6","v":92800},{"$f":"+F24*G8","v":130500},104400,327700,1628306,96666.666666666672,0,54170.2399,54170.2399,205007.14646666666,{"$f":"+O24*G11","v":108340.4798},1083.404798,{"$f":"+O24*G13","v":54235.270199999999},1996972.3012646665]
[null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,{"$f":"+F25*G5","v":0},{"$f":"+F25*G7","v":0},{"$f":"+F25*G14","v":0},0,0,0,{"$f":"+F25*G6","v":0},{"$f":"+F25*G8","v":0},0,0,0,0,0,0,0,0,{"$f":"+O25*G11","v":0},0,{"$f":"+O25*G13","v":0},0]
[null,null,null,0,null,0,0,0,0,0,0,0,0,0,0,{"$f":"+F26*G5","v":0},{"$f":"+F26*G7","v":0},{"$f":"+F26*G14","v":0},0,0,0,{"$f":"+F26*G6","v":0},{"$f":"+F26*G8","v":0},0,0,0,0,0,0,0,0,{"$f":"+O26*G11","v":0},0,{"$f":"+O26*G13","v":0},0]
[null,null,null,{"$f":"SUM(D19:D26)","v":11981833.807587998},"TOTAL",{"$f":"SUM(F19:F26)","v":6960000},{"$f":"SUM(G19:G26)","v":231999.99999999997},28999.999999999996,0,843636,0,0,0,0,7803636,278400,261000,36192,0,575592,7228044,556800,783000,626400,1966200,9769836,580000,0,325021.43939999997,325021.43939999997,1230042.8787999998,650042.87879999995,6500.4287879999993,325411.62120000005,{"$f":"SUM(AI19:AI26)","v":11981833.807587998}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AI27-AI24-AI23","v":7987889.2050586659}]
[null,null,null,{"$f":"+D19+D20+D21+D22","v":7987889.2050586659}]
[]
[]
[]
[null,null,"ENTIDAD",null,"TOTAL"]
[null,null,null,null,"A PAGAR"]
[null,null,"SALUD",null,{"$f":"+P27+V27","v":835200}]
[null,null,"COFENALCO",null,{"$f":"+P19+P20+P21+V19+V20+V21","v":417600}]
[null,null,"SALUDCOOP",null,{"$f":"+P22+P23+P24+V22+V23+V24","v":417600}]
[null,null,"COOMEVA",null,0]
[null,null,"PENSION",null,{"$f":"+Q27+W27","v":1044000}]
[null,null,"SEGURO SOCIAL",null,{"$f":"+E40","v":1044000}]
[null,null,"PARAFISCALES",null,{"$f":"+X27","v":626400}]
[null,null,"COMFACAUCA (4%)",null,{"$f":"+(E42*4)/9","v":278400}]
[null,null,"ICBF (3%)",null,{"$f":"+(E42*3)/9","v":208800}]
[null,null,"SENA (2%)",null,{"$f":"+(E42*2)/9","v":139200}]
[null,null,"FONDO DE SOLIDARIDAD",null,{"$f":"+S27","v":0}]
[null,null,"FDS",null,{"$f":"+E46","v":0}]
[null,null,"ARP",null,{"$f":"+R27","v":36192}]
[null,null,"ASEGURADORA DE RIESGOS P",null,{"$f":"+R27","v":36192}]
[null,null,"TOTAL A PAGAR",null,{"$f":"+E36+E40+E42+E46+E48","v":2541792}]
[]
[]
[null,"DEPOSITO Y RESERVA PARA EL PAGO DE PRESTACIONES SOCIALES Y LIQUIDACIONES",null,null,null,null,{"$f":"+AE27+AF27+AG27+AH27","v":2211997.8075879999},"< PASIVO"]
[]
[]
[]
[]
[null,"NOTA: BLANCO Y AZUL SE DEBE ALIMENTAR - LOS DEMAS COLORES TIENEN FORMULA - NO SE PUEDE ADULTERAR"]

{"sheet":" COSTOS ABC MO","index":6,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,6],[0,1,0,6],[1,1,1,6],[13,1,13,3],[15,2,15,5],[16,5,20,5],[4,4,5,4],[34,7,34,8],[24,7,24,8],[13,7,13,8],[36,2,36,5],[37,5,39,5],[24,1,24,3],[26,2,26,5],[27,5,29,5],[34,1,34,3],[13,12,15,12],[14,9,15,9],[14,10,15,10],[14,11,15,11],[13,9,13,11]]}
[]
[null,"HOTEL SAN JERÓNIMO POPAYÁN"]
[null,"HOJA DE COSTOS ABC MANO DE OBRA"]
[]
[null,"23+7+6+3+1=40","SERVICIOS","SERVICIOS MES","INDICADOR FINANCIERO"]
[null,"HABITACIONES ","DIA ","MES*30 DIAS"]
[null,"23 Habitación standar",23,{"$f":"C7*30","v":690},{"$f":"+D7/D12","v":0.57499999999999996}]
[null,"7 Habitación Superior/junior suite",7,{"$f":"C8*30","v":210},{"$f":"D8/D12","v":0.17499999999999999}]
[null,"6 Habitación Twin",6,{"$f":"C9*30","v":180},{"$f":"D9/D12","v":0.15}]
[null,"3 Habitación Triple",3,90,{"$f":"D10/D12","v":7.4999999999999997E-2}]
[null,"1 Habitación Sencilla",1,30,{"$f":"D11/D12","v":2.5000000000000001E-2},"BOARDESK"]
[null,"40 Habitaciones",{"$f":"SUM(C7:C11)","v":40},{"$f":"SUM(D7:D11)","v":1200},{"$f":"SUM(E7:E11)","v":1}]
[]
[null,null,null,null,null,null,null,"Distribuir salario CAMARERAS",null,"Distribuir salario RECEPCIONISTAS",null,null,"TOTAL MANO DE OBRA/HABITACIONES"]
[null,"Salario para (02) camareras:","SMLV","($1996972*2)",null,null,{"$f":"+NOMINA!D19+NOMINA!D22","v":3993944.602529333},"*Habitacion ","*Indicador%","LLAMADAS RECIBIDAS","RESERVAS REALIZADAS","CLIENTES ATENDIDOS"]
[null,"Habitaciones en servicio","Numero de Servicios por mes distribidos asi:",null,null,null,"%"]
[null,"23 Habitación standar",23,{"$f":"C17*30","v":690},{"$f":"+D17/D22","v":0.57499999999999996},{"$f":"+G15","v":3993944.602529333},{"$f":"+E7","v":0.57499999999999996},null,{"$f":"+F17*G17","v":2296518.1464543664},{"$f":"+K28","v":238444.4538823482},{"$f":"+K29","v":83455.558858821882},{"$f":"K30","v":476888.9077646964},{"$f":"SUM(I17:L17)","v":3095307.0669602333},{"$f":"+I17/D7","v":3328.2871687744441}]
[null,"7 Habitación Superior/junior suite",7,{"$f":"C18*30","v":210},{"$f":"D18/D22","v":0.17499999999999999},null,{"$f":"+E8","v":0.17499999999999999},null,{"$f":"F17*G18","v":698940.30544263322},{"$f":"+K28","v":238444.4538823482},{"$f":"K29","v":83455.558858821882},{"$f":"K30","v":476888.9077646964},{"$f":"SUM(I18:L18)","v":1497729.2259484995},{"$f":"I18/D18","v":3328.2871687744441}]
[null,"6 Habitación Twin",6,{"$f":"C19*30","v":180},{"$f":"D19/D22","v":0.15},null,0.15,null,{"$f":"F17*G19","v":599091.69037939992},{"$f":"+K28","v":238444.4538823482},{"$f":"K29","v":83455.558858821882},{"$f":"K30","v":476888.9077646964},{"$f":"SUM(I19:L19)","v":1397880.6108852662},{"$f":"I19/D19","v":3328.2871687744441}]
[null,"3 Habitación Triple",3,90,{"$f":"D20/D22","v":7.4999999999999997E-2},null,7.4999999999999997E-2,null,{"$f":"F17*G20","v":299545.84518969996},{"$f":"+K28","v":238444.4538823482},{"$f":"K29","v":83455.558858821882},{"$f":"K30","v":476888.9077646964},{"$f":"SUM(I20:L20)","v":1098334.7656955663},{"$f":"I20/D20","v":3328.2871687744441}]
[null,"1 Habitación Sencilla",1,30,{"$f":"D21/D22","v":2.5000000000000001E-2},null,2.5000000000000001E-2,null,{"$f":"F17*G21","v":99848.61506323333},{"$f":"+K28","v":238444.4538823482},{"$f":"K29","v":83455.558858821882},{"$f":"K30","v":476888.9077646964},{"$f":"SUM(I21:L21)","v":898637.53556909983},{"$f":"I21/D21","v":3328.2871687744441}]
[null,"40 Habitaciones",{"$f":"SUM(C17:C21)","v":40},{"$f":"SUM(D17:D21)","v":1200},{"$f":"SUM(E17:E21)","v":1},null,{"$f":"SUM(G17:G21)","v":1},null,{"$f":"SUM(I17:I21)","v":3993944.6025293325},1192222.2694117411,417277.79429410939,2384444.5388234821,7987889.205058665,16641.435843872219]
[]
[]
[null,null,null,null,null,null,null,"Distribuir salario RECEPCIONISTAS"]
[null,"Salario para (02) recepcionistas","SMLV","($1996972*2)",null,null,{"$f":"1996972*2","v":3993944},null,"*Indicador%"]
[null,"Servicio","Numero de Servicios por mes distribidos asi:",null,null,null,"%"]
[null,"Llamadas recibidas",20,{"$f":"C28*30","v":600},{"$f":"+D28/D31","v":0.29850746268656714},{"$f":"+NOMINA!D20+NOMINA!D21","v":3993944.602529333},{"$f":"E28","v":0.29850746268656714},null,{"$f":"+F28*G28","v":1192222.2694117411},{"$f":"+I28/D18","v":5677.2489019606719},{"$f":"+I28/5","v":238444.4538823482}]
[null,"Reservas realizadas",7,{"$f":"C29*30","v":210},{"$f":"D29/D31","v":0.1044776119402985},null,{"$f":"E29","v":0.1044776119402985},null,{"$f":"F28*G29","v":417277.79429410939},{"$f":"I29/D29","v":1987.0371156862352},{"$f":"+I29/5","v":83455.558858821882}]
[null,"Clientes Atendidos",40,{"$f":"C30*30","v":1200},{"$f":"D30/D31","v":0.59701492537313428},null,0.59701492537313428,null,{"$f":"F28*G30","v":2384444.5388234821},{"$f":"I30/D30","v":1987.037115686235},{"$f":"I30/5","v":476888.9077646964}]
[null,null,{"$f":"SUM(C28:C30)","v":67},{"$f":"SUM(D28:D30)","v":2010},{"$f":"SUM(E28:E30)","v":0.99999999999999989},null,{"$f":"SUM(G28:G30)","v":0.99999999999999989},null,{"$f":"SUM(I28:I30)","v":3993944.6025293325},{"$f":"SUM(J28:J30)","v":9651.3231333331423},{"$f":"SUM(K28:K30)","v":798788.92050586641}]
[]
[]
[]
[null,null,null,null,null,null,null,"Distribuir salario AUXILIAR ADMINISTRATIVO"]
[null,"Salario para (01) Aux administrativo","SMLV","($1996972*1)",null,null,{"$f":"1996972*1","v":1996972},null,"*Indicador%"]
[null,null,"Numero de Servicios por mes distribidos asi:",null,null,null,"%"]
[null,"Cotizaciones ",4,{"$f":"C38*30","v":120},{"$f":"+D38/D41","v":0.5},{"$f":"+NOMINA!D23","v":1996972.3012646665},{"$f":"E38","v":0.5},null,{"$f":"+F38*G38","v":998486.15063233324},{"$f":"+I38/D29","v":4754.6959553920633},{"$f":"I38/5","v":199697.23012646666}]
[null,"Compras",3,{"$f":"C39*30","v":90},{"$f":"D39/D41","v":0.375},null,{"$f":"E39","v":0.375},null,{"$f":"F38*G39","v":748864.61297424999},{"$f":"I39/D39","v":8320.7179219361115},{"$f":"I39/5","v":149772.92259485001}]
[null,"Pagos",1,{"$f":"C40*30","v":30},{"$f":"D40/D41","v":0.125},null,0.125,null,{"$f":"F38*G40","v":249621.53765808331},{"$f":"I40/D40","v":8320.7179219361096},49924.307531616665]
[null,null,{"$f":"SUM(C38:C40)","v":8},{"$f":"SUM(D38:D40)","v":240},{"$f":"SUM(E38:E40)","v":1},null,{"$f":"SUM(G38:G40)","v":1},null,{"$f":"SUM(I38:I40)","v":1996972.3012646665},{"$f":"SUM(J38:J40)","v":21396.131799264283},{"$f":"SUM(K38:K40)","v":399394.46025293332}]
[]
[]
[null,null,null,null,null,{"$f":"+F17+F28+F38","v":9984861.506323332}]

{"sheet":"ESTADO DE COSTOS ","index":7,"n_rows":33,"n_cols":16,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,8,3,9],[4,8,4,9],[3,10,3,11],[4,10,4,11],[3,12,3,13],[4,12,4,13],[32,2,32,3],[31,2,31,3],[2,12,2,13],[2,6,2,7],[25,1,25,2],[2,4,2,5],[2,8,2,9],[2,10,2,11],[2,2,3,3],[4,2,4,3],[3,4,3,5],[4,4,4,5],[3,6,3,7],[4,6,4,7]]}
[]
[]
[null,null,"ESTADO DE COSTOS PRESTACION DE SERVICIO",null,"ESTANDAR",null,"JUNIOR SUITE",null,"TWIN",null,"TRIPLE",null,"SENCILLA",null,{"$f":"+BOARDESK!P5","v":800},"←Huesped esperados"]
[null,null,null,null,23,null,7,null,6,null,3,null,1]
[null,null,"MENSUAL",null,0.57499999999999996,null,0.17499999999999999,null,0.15,null,7.4999999999999997E-2,null,2.5000000000000001E-2]
[]
[]
[null,"CUENTA","PARCIAL","TOTAL","PARCIAL","TOTAL","PARCIAL","TOTAL","PARCIAL","TOTAL","PARCIAL","TOTAL","PARCIAL","TOTAL"]
[]
[null,"Materia Prima Directa Usada o Requerida",{"$f":"+COSTOS!F32","v":2411500.5},null,{"$f":"+C10*$E$5","v":1386612.7874999999},null,{"$f":"+C10*$G$5","v":422012.58749999997},null,{"$f":"+C10*$I$5","v":361725.07500000001},null,{"$f":"+C10*$K$5","v":180862.53750000001},null,{"$f":"+C10*$M$5","v":60287.512500000004}]
[null,"71- COSTO DE MATERIA PRIMA",null,{"$f":"+C10","v":2411500.5},null,{"$f":"SUM(E10:E10)","v":1386612.7874999999},null,{"$f":"+G10","v":422012.58749999997},null,{"$f":"+I10","v":361725.07500000001},null,{"$f":"+K10","v":180862.53750000001},null,{"$f":"+M10","v":60287.512500000004}]
[]
[null,"Mano de Obra Directa ",{"$f":"+COSTOS!F43","v":7987889.2050586659},null,{"$f":"+C13*$E$5","v":4593036.2929087328},null,{"$f":"+C13*$G$5","v":1397880.6108852664},null,{"$f":"+C13*$I$5","v":1198183.3807587998},null,{"$f":"+C13*$K$5","v":599091.69037939992},null,{"$f":"+C13*$M$5","v":199697.23012646666}]
[null,"(+) Mano de Obra Indirecta",0,null,0,null,0,null,0,null,0,null,0]
[null,"72- COSTO DE MANO DE OBRA",null,{"$f":"+C13+C14","v":7987889.2050586659},null,{"$f":"+E13+E14","v":4593036.2929087328},null,{"$f":"G13+G14","v":1397880.6108852664},null,{"$f":"I13+I14","v":1198183.3807587998},null,{"$f":"K13+K14","v":599091.69037939992},null,{"$f":"M13+M14","v":199697.23012646666}]
[]
[null,"Costos Indirectos de Fabricación",{"$f":"+COSTOS!F53","v":2142284.9},null,{"$f":"+C17*$E$5","v":1231813.8174999999},null,{"$f":"+C17*$G$5","v":374899.85749999998},null,{"$f":"+C17*$I$5","v":321342.73499999999},null,{"$f":"+C17*$K$5","v":160671.36749999999},null,{"$f":"+C17*$M$5","v":53557.122499999998}]
[null,"73- COSTOS INDIRECTOS DE FABRICACIÓN",null,{"$f":"+C17","v":2142284.9},null,{"$f":"+E17","v":1231813.8174999999},null,{"$f":"+G17","v":374899.85749999998},null,{"$f":"+I17","v":321342.73499999999},null,{"$f":"+K17","v":160671.36749999999},null,{"$f":"+M17","v":53557.122499999998}]
[null,null,null,null,null,null,null,null,null,0]
[null,"COSTOS DE PRODUCCIÓN (71+72+73)",null,{"$f":"+D11+D15+D18","v":12541674.605058666},null,{"$f":"+F11+F15+F18","v":7211462.8979087323},null,{"$f":"+H11+H15+H18","v":2194793.0558852665},null,{"$f":"+J11+J15+J18","v":1881251.1907587997},null,{"$f":"+L11+L15+L18","v":940625.59537939983},null,{"$f":"+N11+N15+N18","v":313541.86512646667}]
[null,"(+) Inventario In. Productos en Proceso",{"$f":"D21","v":0},null,{"$f":"F21","v":0},0,{"$f":"H21","v":0},0,{"$f":"J21","v":0},0,{"$f":"L21","v":0},0,{"$f":"N21","v":0},0]
[null,"(-) Inventario Fin Productos en Proceso",{"$f":"D22","v":0},null,{"$f":"F22","v":0},0,{"$f":"H22","v":0},0,{"$f":"J22","v":0},0,{"$f":"L22","v":0},0,{"$f":"N22","v":0},0]
[null,"COSTOS POR PROCESOS",null,{"$f":"+D20+C21-C22","v":12541674.605058666},null,{"$f":"F20+F21-F22","v":7211462.8979087323},null,{"$f":"H20+H21-H22","v":2194793.0558852665},null,{"$f":"+J20+I21-I22","v":1881251.1907587997},null,{"$f":"+L20+K21-K22","v":940625.59537939983},null,{"$f":"+N20+M21-M22","v":313541.86512646667}]
[null,"(+) Inventario Inicial ProductosTerminado",{"$f":"D24","v":0},null,{"$f":"F24","v":0},0,{"$f":"H24","v":0},0,{"$f":"J24","v":0},0,{"$f":"L24","v":0},0,{"$f":"N24","v":0},0]
[null,"(-) Inventario Final Productos Terminado",{"$f":"D25","v":0},null,{"$f":"F25","v":0},0,{"$f":"H25","v":0},0,{"$f":"J25","v":0},0,{"$f":"L25","v":0},0,{"$f":"N25","v":0},0]
[null,"COSTO DE VENTA",null,{"$f":"D23+D24-D25","v":12541674.605058666},null,{"$f":"F23+F24-F25","v":7211462.8979087323},null,{"$f":"H23+H24-H25","v":2194793.0558852665},null,{"$f":"J23+J24-J25","v":1881251.1907587997},null,{"$f":"L23+L24-L25","v":940625.59537939983},null,{"$f":"N23+N24-N25","v":313541.86512646667}]
[null,null,null,null,null,{"$f":"+F26/30","v":240382.09659695774}]
[null,null,null,null,null,{"$f":"+F27/23","v":10451.395504215554}]
[]
[]
[]
[]
[null,"REPRESENTANTE LEGAL","CONTADORA"]

{"sheet":"ESTADO DE RESULTADOS","index":8,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,1,19,2],[3,3,4,5],[5,3,5,5],[9,1,9,2],[12,1,12,2],[17,1,17,2],[25,7,25,11],[28,9,28,10],[21,1,21,2],[23,1,23,2],[29,4,29,5]]}
[]
[]
[null,null,null,null,null,null,null,"ESTÁNDAR","SUITE","TWIN","TRIPLE","SENCILLA"]
[null,null,null,"ESTADO DE RESULTADOS PRESTACION DE SERVICIO",null,null,null,0.57499999999999996,0.17499999999999999,0.15,7.4999999999999997E-2,2.5000000000000001E-2]
[null,null,null,null,null,null,null,{"$f":"+M5*H4","v":459.99999999999994},{"$f":"+M5*I4","v":140},{"$f":"+M5*J4","v":120},{"$f":"+M5*K4","v":60},{"$f":"+M5*L4","v":20},{"$f":"+BOARDESK!P5","v":800},"←Huesped esperados"]
[null,null,null,"MENSUAL",null,null,null,100000,130000,180000,160000,100000,"←Tarifa",null,{"$f":"SUM(H6:N6)","v":670000},{"$f":"+H6/O6","v":0.14925373134328357}]
[null,null,null,null,null,null,null,23,7,6,3,1,"# Habitaciones"]
[null,null,null,null,null,null,"ANÁLISIS","TOTAL","TOTAL","TOTAL","TOTAL","TOTAL"]
[null,null,null,null,null,null,"FINANCIERO"]
[null,"INGRESOS OPERACIONALES",null,null,null,{"$f":"SUM(H10:L10)","v":97400000},{"$f":"+F10/F10","v":1},{"$f":"+H5*H6","v":45999999.999999993},{"$f":"+I6*I5","v":18200000},{"$f":"+J6*J5","v":21600000},{"$f":"+K6*K5","v":9600000},{"$f":"+L6*L5","v":2000000}]
["(-)","COSTO DE VENTAS",null,null,null,{"$f":"+'ESTADO DE COSTOS '!D26","v":12541674.605058666},{"$f":"+F11/F10","v":0.12876462633530458},{"$f":"+'ESTADO DE COSTOS '!F26","v":7211462.8979087323},{"$f":"+'ESTADO DE COSTOS '!H26","v":2194793.0558852665},{"$f":"+'ESTADO DE COSTOS '!J26","v":1881251.1907587997},{"$f":"+'ESTADO DE COSTOS '!L26","v":940625.59537939983},{"$f":"+'ESTADO DE COSTOS '!N26","v":313541.86512646667}]
[]
["(=)","UTILIDAD BRUTA",null,null,null,{"$f":"+F10-F11","v":84858325.39494133},{"$f":"+F13/F10","v":0.87123537366469539},{"$f":"H10-H11","v":38788537.10209126},{"$f":"I10-I11","v":16005206.944114733},{"$f":"J10-J11","v":19718748.809241202},{"$f":"K10-K11","v":8659374.4046206009},{"$f":"L10-L11","v":1686458.1348735334}]
[]
["(-)","Gastos Administrativos",null,null,null,{"$f":"+GASTOS!C16","v":36957012.47172533},{"$f":"+F15/F10","v":0.3794354463216153},{"$f":"+GASTOS!G16+GASTOS!O16","v":21250282.171242066},{"$f":"+GASTOS!H16+GASTOS!P16","v":6467477.1825519325},{"$f":"+GASTOS!I16+GASTOS!Q16","v":5543551.8707587998},{"$f":"+GASTOS!J16+GASTOS!R16","v":2771775.9353793999},{"$f":"+GASTOS!K16+GASTOS!S16","v":923925.31179313327}]
["(-)","Gastos de Venta",null,null,null,{"$f":"+GASTOS!C24","v":1961000},{"$f":"+F16/F10","v":2.0133470225872689E-2},{"$f":"+GASTOS!G24+GASTOS!O24","v":1127574.9999999998},{"$f":"+GASTOS!H24+GASTOS!P24","v":343175},{"$f":"+GASTOS!I24+GASTOS!Q24","v":294150},{"$f":"+GASTOS!J24+GASTOS!R24","v":147075},{"$f":"+GASTOS!K24+GASTOS!S24","v":49025}]
["(-)","Otros Gastos",null,null,null,{"$f":"+GASTOS!C32","v":2022700},{"$f":"+F17/F10","v":2.0766940451745378E-2},{"$f":"+GASTOS!O32","v":1163052.4999999998},{"$f":"+GASTOS!H32+GASTOS!P32","v":353972.5},{"$f":"+GASTOS!I32+GASTOS!Q32","v":303405},{"$f":"+GASTOS!J32+GASTOS!R32","v":151702.5},{"$f":"+GASTOS!K32+GASTOS!S32","v":50567.5}]
["(=)","UTILIDAD OPERATIVA",null,null,null,{"$f":"F13-F15-F16-F17","v":43917612.923216},{"$f":"+F18/F10","v":0.45089951666546202},{"$f":"H13-H15-H16-H17","v":15247627.430849195},{"$f":"I13-I15-I16-I17","v":8840582.2615628019},{"$f":"J13-J15-J16-J17","v":13577641.938482402},{"$f":"K13-K15-K16-K17","v":5588820.9692412009},{"$f":"L13-L15-L16-L17","v":662940.32308040012}]
["(+)","Otros Ingresos","(eventos)",null,null,{"$f":"DATOS!C76","v":7220000},{"$f":"+F19/F10","v":7.4127310061601642E-2},{"$f":"+F19*H4","v":4151499.9999999995},{"$f":"+F19*I4","v":1263500},{"$f":"+F19*J4","v":1083000},{"$f":"+F19*K4","v":541500},{"$f":"+F19*L4","v":180500}]
["(=)"," UTILIDAD ANTES DE IMPUESTOS",null,null,null,{"$f":"+F18+F19","v":51137612.923216},{"$f":"+F20/F10","v":0.52502682672706369},{"$f":"+H18+H19","v":19399127.430849195},{"$f":"+I18+I19","v":10104082.261562802},{"$f":"+J18+J19","v":14660641.938482402},{"$f":"+K18+K19","v":6130320.9692412009},{"$f":"+L18+L19","v":843440.32308040012}]
["(-)","Impuestos 35%",null,null,null,{"$f":"F20*35%","v":17898164.5231256},{"$f":"+F21/F10","v":0.18375938935447228},{"$f":"H20*35%","v":6789694.6007972173},{"$f":"I20*35%","v":3536428.7915469804},{"$f":"J20*35%","v":5131224.6784688402},{"$f":"K20*35%","v":2145612.3392344201},{"$f":"L20*35%","v":295204.11307814001}]
["(=)","UTILIDAD NETA",null,null,null,{"$f":"F20-F21","v":33239448.4000904},{"$f":"+F22/F10","v":0.34126743737259135},{"$f":"H20-H21","v":12609432.830051977},{"$f":"I20-I21","v":6567653.470015822},{"$f":"J20-J21","v":9529417.2600135617},{"$f":"K20-K21","v":3984708.6300067808},{"$f":"L20-L21","v":548236.21000226005}]
["(-)","Reserva legal 10%",null,null,null,{"$f":"F22*10%","v":3323944.8400090402},{"$f":"+F23/F10","v":3.4126743737259137E-2},{"$f":"H22*10%","v":1260943.2830051978},{"$f":"I22*10%","v":656765.34700158227},{"$f":"J22*10%","v":952941.72600135626},{"$f":"K22*10%","v":398470.86300067813},{"$f":"L22*10%","v":54823.621000226005}]
["(=)","UTILIDAD DEL EJERCICIO",null,null,null,{"$f":"F22-F23","v":29915503.560081359},{"$f":"+F24/F10","v":0.30714069363533225},{"$f":"H22-H23","v":11348489.547046779},{"$f":"I22-I23","v":5910888.1230142396},{"$f":"J22-J23","v":8576475.5340122059},{"$f":"K22-K23","v":3586237.7670061029},{"$f":"L22-L23","v":493412.58900203404}]
[]
[null,null,null,null,null,null,null,"RENTABILIDAD"]
[null,null,null,null,null,null,null,"ESTÁNDAR","SUITE","TWIN","TRIPLE","SENCILLA"]
[null,null,null,null,null,null,null,{"$f":"+H24/H10","v":0.24670629450101697},{"$f":"+I24/I10","v":0.32477407269309011},0.39705905250056511,0.37356643406313572,0.24670629450101703]
[null,null,null,null,null,null,null,"Normal",{"$f":"+'PUNTO DE EQUILIBRIO'!C21","v":0.45089951666546202},"Otros Ingresos",null,{"$f":"+F20/F10","v":0.52502682672706369}]
[null,"Representante Legal",null,null,"Contadora Pública",null,null,{"$f":"+H28/23","v":1.0726360630478998E-2},{"$f":"+I28/I7","v":4.6396296099012871E-2}]
[null,null,null,null,null,null,null,null,{"$f":"+I30/30","v":1.5465432033004291E-3}]

{"sheet":"CARGOS Y FUNCIONES","index":9,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,1,0,8],[55,1,55,8],[65,1,65,8],[57,1,57,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[33,1,33,8],[34,1,34,8],[38,1,38,8],[1,1,1,8],[3,1,3,8],[11,1,11,8],[12,1,12,8],[20,1,20,8],[4,1,4,8],[6,1,6,8],[7,1,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[5,1,5,8],[13,1,13,8],[16,1,16,8],[25,1,25,8],[36,1,36,8],[28,1,28,8],[35,1,35,8],[31,1,31,8],[32,1,32,8],[2,1,2,8],[19,1,19,8],[17,1,17,8],[18,1,18,8],[21,1,21,8],[14,1,14,8],[15,1,15,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[29,1,29,8],[30,1,30,8],[26,1,26,8],[27,1,27,8],[66,1,66,8],[37,1,37,8],[39,1,39,8],[40,1,40,8],[46,1,46,8],[59,1,59,8],[58,1,58,8],[45,1,45,8],[42,1,42,8],[41,1,41,8],[56,1,56,8],[43,1,43,8],[44,1,44,8],[47,1,47,8],[48,1,48,8],[49,1,49,8]]}
[]
[]
[null,"CARGOS Y FUNCIONES HOTEL SAN JERÓNIMO POPAYÁN"]
[]
[null,"RECEPCIONISTA "]
[null,"·         Diligenciar registro hotelero con la información y datos personales del huésped a quien se presta el servicio de hospedaje."]
[null,"·         Realizar Check-in y Check- out de los huéspedes."]
[null,"·         Registrar reservas que se realizan a través de las redes sociales o llamadas telefónicas."]
[null,"·         Realizar acomodación de habitaciones en relación a la ocupación y grupos que requieran hospedaje."]
[null,"·         Facturar servicios prestados tanto de hospedaje, como eventos y mini bar."]
[null,"·         Manejo de SOFTWARE hotelero para control de habitaciones libres, en limpieza y reservadas."]
[]
[]
[null,"BOTONES"]
[null,"·         Apoyar el área de recepción en relación a registro de huéspedes que ingresan."]
[null,"·         Ayudar con el equipaje de los huéspedes."]
[null,"·         Guiar al huésped en las instalaciones del hotel e instalarlo en la habitación que le haya sido asignada."]
[]
[]
[null,"CAMARERA"]
[null,"·         Realizar limpieza en todas las áreas de las habitaciones después de ser entregadas por los huéspedes."]
[null,"·         Hacer cambio de sábanas, fundas, cobijas y edredones de las camas de cada habitación."]
[null,"·         Llevar control de consumo de productos de mini bar en las habitaciones que cuentan con tal servicio."]
[null,"·         Limpieza de zonas comunes del hotel."]
[null,"·         Brindar servicio de lavandería y planchado a los huéspedes que lo requieran."]
[]
[]
[null,"JEFE DE CAMAMARERIA"]
[]
[null,"MESERO"]
[null,"·         Apoyar en el área de cocina al momento de ofrecer el servicio de desayuno como cortesía por parte del hotel para los huéspedes."]
[null,"·         Atender las mesas una vez los huéspedes suban para tomar el servicio de desayuno."]
[null,"·         Realizar montaje de comedor para atender a los huéspedes una vez decidan tomar el desayuno."]
[null,"·         Organizar el salón de eventos cuando se requiera."]
[null,"·         Velar por el cuidado, orden y limpieza de la zona del comedor que es su área de trabajo."]
[]
[null,"AUX ADMINISTRATIVO"]
[]
[null,"ADMINISTRADOR"]
[]
[]
[null,"CONTADOR PUBLICO"]
[null,"·        Liquidacion de impuestos"]
[null,"·       Liquidaciones de primas, contratos"]
[null,"·       Elaboracion de estados de resultados"]
[]
[]
[null,"AUXILIAR CONTABLE"]
[null,"·         Realizar informe diario del efectivo que ingresa del día anterior."]
[null,"·         Diligenciar formatos para entrega de informe diario, semanal y mensual."]
[null,"·         Archivar documentación."]
[null,"·         Ingresar al programa contable toda la información que se requiera para fines contables, tales como registro de todo tipo de gastos y costos en que se incurre."]
[null,"·         Realizar conciliaciones bancarias para realizar revisión de cuentas pendientes de pago."]
[null,"·         Realizar informe mensual tanto de ingresos, como gastos para reunión mensual."]
[null,"·         Recepcionar correos electrónicos que contengan información contable: facturas electrónicas de compras realizadas, impuestos a liquidar y realizar su respectivo pago."]
[null,"·         Generar planilla de salud de los colaboradores y realizar su respectivo pago."]
[null,"·         Liquidar nómina de manera quincenal para realizar su respectico pago."]
[null,"·         Contabilizar turnos y horas extras de personal auxiliar para realizar su respectivo pago."]
[]
[]
[null,"MESERO"]
[null,"·         Apoyar en el área de cocina al momento de ofrecer el servicio de desayuno como cortesía por parte del hotel para los huéspedes."]
[null,"·         Atender las mesas una vez los huéspedes suban para tomar el servicio de desayuno."]
[null,"·         Realizar montaje de comedor para atender a los huéspedes una vez decidan tomar el desayuno."]
[null,"·         Organizar el salón de eventos cuando se requiera."]
[null,"·         Velar por el cuidado, orden y limpieza de la zona del comedor que es su área de trabajo."]

{"sheet":"FLORELIA ","index":10,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[13,0,13,3],[15,0,15,5]]}
["EMPLEADO"]
["SALARIO BÁSICO",null,737717]
["AUX. TRANSPORTE",null,83140]
["HORA BÁSICA",null,{"$f":"+C2/240","v":3073.8208333333332}]
[]
["CLASE","FACTOR","VR. HORA","Total Horas","Vr. Horas"]
["HEOD",1.25,{"$f":"+$C$4*B7","v":3842.2760416666665},{"$f":"SUMIF($B$46:$B$85,$A7,$E$46:$E$85)","v":0},{"$f":"+IF(G7<0,G7*-1,G7)","v":0},null,{"$f":"SUMIF($B$46:$B$85,$A7,$F$46:$F$85)","v":0}]
["HEON",1.75,{"$f":"+$C$4*B8","v":5379.1864583333336},{"$f":"SUMIF($B$19:$B$85,$A8,$E$19:$E$85)","v":0},{"$f":"+IF(G8<0,G8*-1,G8)","v":0},null,{"$f":"SUMIF($B$19:$B$85,$A8,$F$19:$F$85)","v":0}]
["HEFD",2,6147.6416666666664,{"$f":"SUMIF($B$19:$B$85,$A9,$E$19:$E$85)","v":0},0,null,{"$f":"SUMIF($B$19:$B$85,$A9,$F$19:$F$85)","v":0}]
["HEFN",2.5,7684.552083333333,{"$f":"SUMIF($B$19:$B$85,$A10,$E$19:$E$85)","v":0},0,null,{"$f":"SUMIF($B$19:$B$85,$A10,$F$19:$F$85)","v":0}]
["RON",0.35,1075.8372916666665,{"$f":"SUMIF($B$19:$B$85,$A11,$E$19:$E$85)","v":0},0,null,{"$f":"SUMIF($B$19:$B$84,$A11,$F$19:$F$84)","v":0}]
["RFD",0.75,2305.3656249999999,{"$f":"SUMIF($B$19:$B$84,$A12,$E$19:$E$84)","v":0},0,null,{"$f":"SUMIF($B$19:$B$84,$A12,$F$19:$F$84)","v":0}]
["RFN",1.1000000000000001,3381.2029166666666,{"$f":"SUMIF($B$19:$B$84,$A13,$E$19:$E$84)","v":0},0,null,{"$f":"SUMIF($B$20:$B$84,$A13,$F$20:$F$84)","v":0}]
["Total ",null,null,null,{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0}]
[]
["Periodo del 1 al 15 Octubre de 2016"]
["Fecha","TIPO HE","ENTRA","SALE","TOTAL","DEVENGADO"]
["Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
["2017-04-01",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B19=$A$7,SUM(E19*$C$4*$B$7),(IF(B19=$A$8,SUM(E19*$C$4*$B$8),IF(B19=$A$9,SUM(E19*$C$4*$B$9),IF(B19=$A$10,SUM(E19*$C$4*$B$10),IF(B19=$A$11,SUM(E19*$C$4*$B$11),IF(B19=$A$12,SUM(E19*$C$4*$B$12),IF(B19=$A$13,SUM(E19*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0},null,"DESCANSO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0},null,"DOMINGO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0},null,"FESTIVO"]
["2017-04-03",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B22=$A$7,SUM(E22*$C$4*$B$7),(IF(B22=$A$8,SUM(E22*$C$4*$B$8),IF(B22=$A$9,SUM(E22*$C$4*$B$9),IF(B22=$A$10,SUM(E22*$C$4*$B$10),IF(B22=$A$11,SUM(E22*$C$4*$B$11),IF(B22=$A$12,SUM(E22*$C$4*$B$12),IF(B22=$A$13,SUM(E22*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-04",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-05",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B24=$A$7,SUM(E24*$C$4*$B$7),(IF(B24=$A$8,SUM(E24*$C$4*$B$8),IF(B24=$A$9,SUM(E24*$C$4*$B$9),IF(B24=$A$10,SUM(E24*$C$4*$B$10),IF(B24=$A$11,SUM(E24*$C$4*$B$11),IF(B24=$A$12,SUM(E24*$C$4*$B$12),IF(B24=$A$13,SUM(E24*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-06",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-07",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-08",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B28=$A$7,SUM(E28*$C$4*$B$7),(IF(B28=$A$8,SUM(E28*$C$4*$B$8),IF(B28=$A$9,SUM(E28*$C$4*$B$9),IF(B28=$A$10,SUM(E28*$C$4*$B$10),IF(B28=$A$11,SUM(E28*$C$4*$B$11),IF(B28=$A$12,SUM(E28*$C$4*$B$12),IF(B28=$A$13,SUM(E28*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-10",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B30=$A$7,SUM(E30*$C$4*$B$7),(IF(B30=$A$8,SUM(E30*$C$4*$B$8),IF(B30=$A$9,SUM(E30*$C$4*$B$9),IF(B30=$A$10,SUM(E30*$C$4*$B$10),IF(B30=$A$11,SUM(E30*$C$4*$B$11),IF(B30=$A$12,SUM(E30*$C$4*$B$12),IF(B30=$A$13,SUM(E30*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-11",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B31=$A$7,SUM(E31*$C$4*$B$7),(IF(B31=$A$8,SUM(E31*$C$4*$B$8),IF(B31=$A$9,SUM(E31*$C$4*$B$9),IF(B31=$A$10,SUM(E31*$C$4*$B$10),IF(B31=$A$11,SUM(E31*$C$4*$B$11),IF(B31=$A$12,SUM(E31*$C$4*$B$12),IF(B31=$A$13,SUM(E31*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-12",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B32=$A$7,SUM(E32*$C$4*$B$7),(IF(B32=$A$8,SUM(E32*$C$4*$B$8),IF(B32=$A$9,SUM(E32*$C$4*$B$9),IF(B32=$A$10,SUM(E32*$C$4*$B$10),IF(B32=$A$11,SUM(E32*$C$4*$B$11),IF(B32=$A$12,SUM(E32*$C$4*$B$12),IF(B32=$A$13,SUM(E32*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B36=$A$7,SUM(E36*$C$4*$B$7),(IF(B36=$A$8,SUM(E36*$C$4*$B$8),IF(B36=$A$9,SUM(E36*$C$4*$B$9),IF(B36=$A$10,SUM(E36*$C$4*$B$10),IF(B36=$A$11,SUM(E36*$C$4*$B$11),IF(B36=$A$12,SUM(E36*$C$4*$B$12),IF(B36=$A$13,SUM(E36*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
["2017-04-15",null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B38=$A$7,SUM(E38*$C$4*$B$7),(IF(B38=$A$8,SUM(E38*$C$4*$B$8),IF(B38=$A$9,SUM(E38*$C$4*$B$9),IF(B38=$A$10,SUM(E38*$C$4*$B$10),IF(B38=$A$11,SUM(E38*$C$4*$B$11),IF(B38=$A$12,SUM(E38*$C$4*$B$12),IF(B38=$A$13,SUM(E38*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B46=$A$7,SUM(E46*$C$4*$B$7),(IF(B46=$A$8,SUM(E46*$C$4*$B$8),IF(B46=$A$9,SUM(E46*$C$4*$B$9),IF(B46=$A$10,SUM(E46*$C$4*$B$10),IF(B46=$A$11,SUM(E46*$C$4*$B$11),IF(B46=$A$12,SUM(E46*$C$4*$B$12),IF(B46=$A$13,SUM(E46*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B47=$A$7,SUM(E47*$C$4*$B$7),(IF(B47=$A$8,SUM(E47*$C$4*$B$8),IF(B47=$A$9,SUM(E47*$C$4*$B$9),IF(B47=$A$10,SUM(E47*$C$4*$B$10),IF(B47=$A$11,SUM(E47*$C$4*$B$11),IF(B47=$A$12,SUM(E47*$C$4*$B$12),IF(B47=$A$13,SUM(E47*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B55=$A$7,SUM(E55*$C$4*$B$7),(IF(B55=$A$8,SUM(E55*$C$4*$B$8),IF(B55=$A$9,SUM(E55*$C$4*$B$9),IF(B55=$A$10,SUM(E55*$C$4*$B$10),IF(B55=$A$11,SUM(E55*$C$4*$B$11),IF(B55=$A$12,SUM(E55*$C$4*$B$12),IF(B55=$A$13,SUM(E55*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B56=$A$7,SUM(E56*$C$4*$B$7),(IF(B56=$A$8,SUM(E56*$C$4*$B$8),IF(B56=$A$9,SUM(E56*$C$4*$B$9),IF(B56=$A$10,SUM(E56*$C$4*$B$10),IF(B56=$A$11,SUM(E56*$C$4*$B$11),IF(B56=$A$12,SUM(E56*$C$4*$B$12),IF(B56=$A$13,SUM(E56*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B57=$A$7,SUM(E57*$C$4*$B$7),(IF(B57=$A$8,SUM(E57*$C$4*$B$8),IF(B57=$A$9,SUM(E57*$C$4*$B$9),IF(B57=$A$10,SUM(E57*$C$4*$B$10),IF(B57=$A$11,SUM(E57*$C$4*$B$11),IF(B57=$A$12,SUM(E57*$C$4*$B$12),IF(B57=$A$13,SUM(E57*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},{"$f":"IF(B58=$A$7,SUM(E58*$C$4*$B$7),(IF(B58=$A$8,SUM(E58*$C$4*$B$8),IF(B58=$A$9,SUM(E58*$C$4*$B$9),IF(B58=$A$10,SUM(E58*$C$4*$B$10),IF(B58=$A$11,SUM(E58*$C$4*$B$11),IF(B58=$A$12,SUM(E58*$C$4*$B$12),IF(B58=$A$13,SUM(E58*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11122[[#This Row],[Columna7]]<0,Tabla11122[[#This Row],[Columna7]]*-1,Tabla11122[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11122[[#This Row],[Columna4]]-Tabla11122[[#This Row],[Columna3]])*24","v":0}]

{"sheet":"MIRALBA RIVERA","index":11,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[13,0,13,3],[15,0,15,5]]}
["EMPLEADO"]
["SALARIO BÁSICO",null,368858]
["AUX. TRANSPORTE",null,83140]
["HORA BÁSICA",null,{"$f":"+C2/240","v":1536.9083333333333}]
[]
["CLASE","FACTOR","VR. HORA","Total Horas","Vr. Horas"]
["HEOD",1.25,{"$f":"+$C$4*B7","v":1921.1354166666665},{"$f":"SUMIF($B$41:$B$80,$A7,$E$41:$E$80)","v":0},{"$f":"+IF(G7<0,G7*-1,G7)","v":0},null,{"$f":"SUMIF($B$41:$B$80,$A7,$F$41:$F$80)","v":0}]
["HEON",1.75,{"$f":"+$C$4*B8","v":2689.5895833333334},{"$f":"SUMIF($B$19:$B$80,$A8,$E$19:$E$80)","v":0},{"$f":"+IF(G8<0,G8*-1,G8)","v":0},null,{"$f":"SUMIF($B$19:$B$80,$A8,$F$19:$F$80)","v":0}]
["HEFD",2,3073.8166666666666,{"$f":"SUMIF($B$19:$B$80,$A9,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$80,$A9,$F$19:$F$80)","v":0}]
["HEFN",2.5,3842.270833333333,{"$f":"SUMIF($B$19:$B$80,$A10,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$80,$A10,$F$19:$F$80)","v":0}]
["RON",0.35,537.91791666666666,{"$f":"SUMIF($B$19:$B$80,$A11,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$79,$A11,$F$19:$F$79)","v":0}]
["RFD",0.75,1152.6812500000001,{"$f":"SUMIF($B$19:$B$79,$A12,$E$19:$E$79)","v":0},0,null,{"$f":"SUMIF($B$19:$B$79,$A12,$F$19:$F$79)","v":0}]
["RFN",1.1000000000000001,1690.5991666666669,{"$f":"SUMIF($B$19:$B$79,$A13,$E$19:$E$79)","v":0},0,null,{"$f":"SUMIF($B$20:$B$79,$A13,$F$20:$F$79)","v":0}]
["Total ",null,null,null,{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0}]
[]
["Periodo del 1 al 15 Octubre de 2016"]
["Fecha","TIPO HE","ENTRA","SALE","TOTAL","DEVENGADO"]
["Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
["2017-04-01",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B19=$A$7,SUM(E19*$C$4*$B$7),(IF(B19=$A$8,SUM(E19*$C$4*$B$8),IF(B19=$A$9,SUM(E19*$C$4*$B$9),IF(B19=$A$10,SUM(E19*$C$4*$B$10),IF(B19=$A$11,SUM(E19*$C$4*$B$11),IF(B19=$A$12,SUM(E19*$C$4*$B$12),IF(B19=$A$13,SUM(E19*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0},null,"DESCANSO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0},null,"DOMINGO"]
["2017-04-03",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0},null,"FESTIVO"]
["2017-04-04",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B22=$A$7,SUM(E22*$C$4*$B$7),(IF(B22=$A$8,SUM(E22*$C$4*$B$8),IF(B22=$A$9,SUM(E22*$C$4*$B$9),IF(B22=$A$10,SUM(E22*$C$4*$B$10),IF(B22=$A$11,SUM(E22*$C$4*$B$11),IF(B22=$A$12,SUM(E22*$C$4*$B$12),IF(B22=$A$13,SUM(E22*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0},null,"INCAPACIDAD"]
["2017-04-05",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-06",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B24=$A$7,SUM(E24*$C$4*$B$7),(IF(B24=$A$8,SUM(E24*$C$4*$B$8),IF(B24=$A$9,SUM(E24*$C$4*$B$9),IF(B24=$A$10,SUM(E24*$C$4*$B$10),IF(B24=$A$11,SUM(E24*$C$4*$B$11),IF(B24=$A$12,SUM(E24*$C$4*$B$12),IF(B24=$A$13,SUM(E24*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-07",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-08",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-10",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-11",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-12",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B31=$A$7,SUM(E31*$C$4*$B$7),(IF(B31=$A$8,SUM(E31*$C$4*$B$8),IF(B31=$A$9,SUM(E31*$C$4*$B$9),IF(B31=$A$10,SUM(E31*$C$4*$B$10),IF(B31=$A$11,SUM(E31*$C$4*$B$11),IF(B31=$A$12,SUM(E31*$C$4*$B$12),IF(B31=$A$13,SUM(E31*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B32=$A$7,SUM(E32*$C$4*$B$7),(IF(B32=$A$8,SUM(E32*$C$4*$B$8),IF(B32=$A$9,SUM(E32*$C$4*$B$9),IF(B32=$A$10,SUM(E32*$C$4*$B$10),IF(B32=$A$11,SUM(E32*$C$4*$B$11),IF(B32=$A$12,SUM(E32*$C$4*$B$12),IF(B32=$A$13,SUM(E32*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
["2017-04-15",null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B41=$A$7,SUM(E41*$C$4*$B$7),(IF(B41=$A$8,SUM(E41*$C$4*$B$8),IF(B41=$A$9,SUM(E41*$C$4*$B$9),IF(B41=$A$10,SUM(E41*$C$4*$B$10),IF(B41=$A$11,SUM(E41*$C$4*$B$11),IF(B41=$A$12,SUM(E41*$C$4*$B$12),IF(B41=$A$13,SUM(E41*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B42=$A$7,SUM(E42*$C$4*$B$7),(IF(B42=$A$8,SUM(E42*$C$4*$B$8),IF(B42=$A$9,SUM(E42*$C$4*$B$9),IF(B42=$A$10,SUM(E42*$C$4*$B$10),IF(B42=$A$11,SUM(E42*$C$4*$B$11),IF(B42=$A$12,SUM(E42*$C$4*$B$12),IF(B42=$A$13,SUM(E42*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B50=$A$7,SUM(E50*$C$4*$B$7),(IF(B50=$A$8,SUM(E50*$C$4*$B$8),IF(B50=$A$9,SUM(E50*$C$4*$B$9),IF(B50=$A$10,SUM(E50*$C$4*$B$10),IF(B50=$A$11,SUM(E50*$C$4*$B$11),IF(B50=$A$12,SUM(E50*$C$4*$B$12),IF(B50=$A$13,SUM(E50*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B51=$A$7,SUM(E51*$C$4*$B$7),(IF(B51=$A$8,SUM(E51*$C$4*$B$8),IF(B51=$A$9,SUM(E51*$C$4*$B$9),IF(B51=$A$10,SUM(E51*$C$4*$B$10),IF(B51=$A$11,SUM(E51*$C$4*$B$11),IF(B51=$A$12,SUM(E51*$C$4*$B$12),IF(B51=$A$13,SUM(E51*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B52=$A$7,SUM(E52*$C$4*$B$7),(IF(B52=$A$8,SUM(E52*$C$4*$B$8),IF(B52=$A$9,SUM(E52*$C$4*$B$9),IF(B52=$A$10,SUM(E52*$C$4*$B$10),IF(B52=$A$11,SUM(E52*$C$4*$B$11),IF(B52=$A$12,SUM(E52*$C$4*$B$12),IF(B52=$A$13,SUM(E52*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},{"$f":"IF(B53=$A$7,SUM(E53*$C$4*$B$7),(IF(B53=$A$8,SUM(E53*$C$4*$B$8),IF(B53=$A$9,SUM(E53*$C$4*$B$9),IF(B53=$A$10,SUM(E53*$C$4*$B$10),IF(B53=$A$11,SUM(E53*$C$4*$B$11),IF(B53=$A$12,SUM(E53*$C$4*$B$12),IF(B53=$A$13,SUM(E53*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131420[[#This Row],[Columna7]]<0,Tabla11112131420[[#This Row],[Columna7]]*-1,Tabla11112131420[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131420[[#This Row],[Columna4]]-Tabla11112131420[[#This Row],[Columna3]])*24","v":0}]

{"sheet":"MARIA ","index":12,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[13,0,13,3],[15,0,15,5]]}
["EMPLEADO"]
["SALARIO BÁSICO",null,368858]
["AUX. TRANSPORTE",null,83140]
["HORA BÁSICA",null,{"$f":"+C2/240","v":1536.9083333333333}]
[]
["CLASE","FACTOR","VR. HORA","Total Horas","Vr. Horas"]
["HEOD",1.25,{"$f":"+$C$4*B7","v":1921.1354166666665},{"$f":"SUMIF($B$41:$B$80,$A7,$E$41:$E$80)","v":0},{"$f":"+IF(G7<0,G7*-1,G7)","v":0},null,{"$f":"SUMIF($B$41:$B$80,$A7,$F$41:$F$80)","v":0}]
["HEON",1.75,{"$f":"+$C$4*B8","v":2689.5895833333334},{"$f":"SUMIF($B$19:$B$80,$A8,$E$19:$E$80)","v":0},{"$f":"+IF(G8<0,G8*-1,G8)","v":0},null,{"$f":"SUMIF($B$19:$B$80,$A8,$F$19:$F$80)","v":0}]
["HEFD",2,3073.8166666666666,{"$f":"SUMIF($B$19:$B$80,$A9,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$80,$A9,$F$19:$F$80)","v":0}]
["HEFN",2.5,3842.270833333333,{"$f":"SUMIF($B$19:$B$80,$A10,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$80,$A10,$F$19:$F$80)","v":0}]
["RON",0.35,537.91791666666666,{"$f":"SUMIF($B$19:$B$80,$A11,$E$19:$E$80)","v":0},0,null,{"$f":"SUMIF($B$19:$B$79,$A11,$F$19:$F$79)","v":0}]
["RFD",0.75,1152.6812500000001,{"$f":"SUMIF($B$19:$B$79,$A12,$E$19:$E$79)","v":0},0,null,{"$f":"SUMIF($B$19:$B$79,$A12,$F$19:$F$79)","v":0}]
["RFN",1.1000000000000001,1690.5991666666669,{"$f":"SUMIF($B$19:$B$79,$A13,$E$19:$E$79)","v":0},0,null,{"$f":"SUMIF($B$20:$B$79,$A13,$F$20:$F$79)","v":0}]
["Total ",null,null,null,{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0}]
[]
["Periodo del 1 al 15 Octubre de 2016"]
["Fecha","TIPO HE","ENTRA","SALE","TOTAL","DEVENGADO"]
["Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
["2017-04-01",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B19=$A$7,SUM(E19*$C$4*$B$7),(IF(B19=$A$8,SUM(E19*$C$4*$B$8),IF(B19=$A$9,SUM(E19*$C$4*$B$9),IF(B19=$A$10,SUM(E19*$C$4*$B$10),IF(B19=$A$11,SUM(E19*$C$4*$B$11),IF(B19=$A$12,SUM(E19*$C$4*$B$12),IF(B19=$A$13,SUM(E19*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0},null,"DESCANSO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0},null,"DOMINGO"]
["2017-04-03",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0},null,"FESTIVO"]
["2017-04-04",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B22=$A$7,SUM(E22*$C$4*$B$7),(IF(B22=$A$8,SUM(E22*$C$4*$B$8),IF(B22=$A$9,SUM(E22*$C$4*$B$9),IF(B22=$A$10,SUM(E22*$C$4*$B$10),IF(B22=$A$11,SUM(E22*$C$4*$B$11),IF(B22=$A$12,SUM(E22*$C$4*$B$12),IF(B22=$A$13,SUM(E22*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-05",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-06",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B24=$A$7,SUM(E24*$C$4*$B$7),(IF(B24=$A$8,SUM(E24*$C$4*$B$8),IF(B24=$A$9,SUM(E24*$C$4*$B$9),IF(B24=$A$10,SUM(E24*$C$4*$B$10),IF(B24=$A$11,SUM(E24*$C$4*$B$11),IF(B24=$A$12,SUM(E24*$C$4*$B$12),IF(B24=$A$13,SUM(E24*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-07",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-08",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-10",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-11",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-12",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B31=$A$7,SUM(E31*$C$4*$B$7),(IF(B31=$A$8,SUM(E31*$C$4*$B$8),IF(B31=$A$9,SUM(E31*$C$4*$B$9),IF(B31=$A$10,SUM(E31*$C$4*$B$10),IF(B31=$A$11,SUM(E31*$C$4*$B$11),IF(B31=$A$12,SUM(E31*$C$4*$B$12),IF(B31=$A$13,SUM(E31*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B32=$A$7,SUM(E32*$C$4*$B$7),(IF(B32=$A$8,SUM(E32*$C$4*$B$8),IF(B32=$A$9,SUM(E32*$C$4*$B$9),IF(B32=$A$10,SUM(E32*$C$4*$B$10),IF(B32=$A$11,SUM(E32*$C$4*$B$11),IF(B32=$A$12,SUM(E32*$C$4*$B$12),IF(B32=$A$13,SUM(E32*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
["2017-04-15",null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B41=$A$7,SUM(E41*$C$4*$B$7),(IF(B41=$A$8,SUM(E41*$C$4*$B$8),IF(B41=$A$9,SUM(E41*$C$4*$B$9),IF(B41=$A$10,SUM(E41*$C$4*$B$10),IF(B41=$A$11,SUM(E41*$C$4*$B$11),IF(B41=$A$12,SUM(E41*$C$4*$B$12),IF(B41=$A$13,SUM(E41*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B42=$A$7,SUM(E42*$C$4*$B$7),(IF(B42=$A$8,SUM(E42*$C$4*$B$8),IF(B42=$A$9,SUM(E42*$C$4*$B$9),IF(B42=$A$10,SUM(E42*$C$4*$B$10),IF(B42=$A$11,SUM(E42*$C$4*$B$11),IF(B42=$A$12,SUM(E42*$C$4*$B$12),IF(B42=$A$13,SUM(E42*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B50=$A$7,SUM(E50*$C$4*$B$7),(IF(B50=$A$8,SUM(E50*$C$4*$B$8),IF(B50=$A$9,SUM(E50*$C$4*$B$9),IF(B50=$A$10,SUM(E50*$C$4*$B$10),IF(B50=$A$11,SUM(E50*$C$4*$B$11),IF(B50=$A$12,SUM(E50*$C$4*$B$12),IF(B50=$A$13,SUM(E50*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B51=$A$7,SUM(E51*$C$4*$B$7),(IF(B51=$A$8,SUM(E51*$C$4*$B$8),IF(B51=$A$9,SUM(E51*$C$4*$B$9),IF(B51=$A$10,SUM(E51*$C$4*$B$10),IF(B51=$A$11,SUM(E51*$C$4*$B$11),IF(B51=$A$12,SUM(E51*$C$4*$B$12),IF(B51=$A$13,SUM(E51*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B52=$A$7,SUM(E52*$C$4*$B$7),(IF(B52=$A$8,SUM(E52*$C$4*$B$8),IF(B52=$A$9,SUM(E52*$C$4*$B$9),IF(B52=$A$10,SUM(E52*$C$4*$B$10),IF(B52=$A$11,SUM(E52*$C$4*$B$11),IF(B52=$A$12,SUM(E52*$C$4*$B$12),IF(B52=$A$13,SUM(E52*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},{"$f":"IF(B53=$A$7,SUM(E53*$C$4*$B$7),(IF(B53=$A$8,SUM(E53*$C$4*$B$8),IF(B53=$A$9,SUM(E53*$C$4*$B$9),IF(B53=$A$10,SUM(E53*$C$4*$B$10),IF(B53=$A$11,SUM(E53*$C$4*$B$11),IF(B53=$A$12,SUM(E53*$C$4*$B$12),IF(B53=$A$13,SUM(E53*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314202[[#This Row],[Columna7]]<0,Tabla111121314202[[#This Row],[Columna7]]*-1,Tabla111121314202[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314202[[#This Row],[Columna4]]-Tabla111121314202[[#This Row],[Columna3]])*24","v":0}]

{"sheet":"LINA MARIA ","index":13,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[13,0,13,3],[15,0,15,5]]}
["EMPLEADO"]
["SALARIO BÁSICO",null,737717]
["AUX. TRANSPORTE",null,83140]
["HORA BÁSICA",null,{"$f":"+C2/240","v":3073.8208333333332}]
[]
["CLASE","FACTOR","VR. HORA","Total Horas","Vr. Horas"]
["HEOD",1.25,{"$f":"+$C$4*B7","v":3842.2760416666665},{"$f":"SUMIF($B$62:$B$101,$A7,$E$62:$E$101)","v":0},{"$f":"+IF(G7<0,G7*-1,G7)","v":0},null,{"$f":"SUMIF($B$62:$B$101,$A7,$F$62:$F$101)","v":0}]
["HEON",1.75,{"$f":"+$C$4*B8","v":5379.1864583333336},{"$f":"SUMIF($B$19:$B$101,$A8,$E$19:$E$101)","v":0},{"$f":"+IF(G8<0,G8*-1,G8)","v":0},null,{"$f":"SUMIF($B$19:$B$101,$A8,$F$19:$F$101)","v":0}]
["HEFD",2,6147.6416666666664,{"$f":"SUMIF($B$19:$B$101,$A9,$E$19:$E$101)","v":0},0,null,{"$f":"SUMIF($B$19:$B$101,$A9,$F$19:$F$101)","v":0}]
["HEFN",2.5,7684.552083333333,{"$f":"SUMIF($B$19:$B$101,$A10,$E$19:$E$101)","v":0},0,null,{"$f":"SUMIF($B$19:$B$101,$A10,$F$19:$F$101)","v":0}]
["RON",0.35,1075.8372916666665,{"$f":"SUMIF($B$19:$B$101,$A11,$E$19:$E$101)","v":0},0,null,{"$f":"SUMIF($B$19:$B$100,$A11,$F$19:$F$100)","v":0}]
["RFD",0.75,2305.3656249999999,{"$f":"SUMIF($B$19:$B$100,$A12,$E$19:$E$100)","v":0},0,null,{"$f":"SUMIF($B$19:$B$100,$A12,$F$19:$F$100)","v":0}]
["RFN",1.1000000000000001,3381.2029166666666,{"$f":"SUMIF($B$19:$B$100,$A13,$E$19:$E$100)","v":0},0,null,{"$f":"SUMIF($B$19:$B$100,$A13,$F$19:$F$100)","v":0}]
["Total ",null,null,null,{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0}]
[]
["Periodo del 1 al 15 Octubre de 2016"]
["Fecha","TIPO HE","ENTRA","SALE","TOTAL","DEVENGADO"]
["Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
["2017-04-01",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B19=$A$7,SUM(E19*$C$4*$B$7),(IF(B19=$A$8,SUM(E19*$C$4*$B$8),IF(B19=$A$9,SUM(E19*$C$4*$B$9),IF(B19=$A$10,SUM(E19*$C$4*$B$10),IF(B19=$A$11,SUM(E19*$C$4*$B$11),IF(B19=$A$12,SUM(E19*$C$4*$B$12),IF(B19=$A$13,SUM(E19*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0},null,"DESCANSO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B20=$A$7,SUM(E20*$C$4*$B$7),(IF(B20=$A$8,SUM(E20*$C$4*$B$8),IF(B20=$A$9,SUM(E20*$C$4*$B$9),IF(B20=$A$10,SUM(E20*$C$4*$B$10),IF(B20=$A$11,SUM(E20*$C$4*$B$11),IF(B20=$A$12,SUM(E20*$C$4*$B$12),IF(B20=$A$13,SUM(E20*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0},null,"DOMINGO"]
["2017-04-03",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B21=$A$7,SUM(E21*$C$4*$B$7),(IF(B21=$A$8,SUM(E21*$C$4*$B$8),IF(B21=$A$9,SUM(E21*$C$4*$B$9),IF(B21=$A$10,SUM(E21*$C$4*$B$10),IF(B21=$A$11,SUM(E21*$C$4*$B$11),IF(B21=$A$12,SUM(E21*$C$4*$B$12),IF(B21=$A$13,SUM(E21*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0},null,"NCAPACIDAD"]
["2017-04-04",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-05",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-06",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B24=$A$7,SUM(E24*$C$4*$B$7),(IF(B24=$A$8,SUM(E24*$C$4*$B$8),IF(B24=$A$9,SUM(E24*$C$4*$B$9),IF(B24=$A$10,SUM(E24*$C$4*$B$10),IF(B24=$A$11,SUM(E24*$C$4*$B$11),IF(B24=$A$12,SUM(E24*$C$4*$B$12),IF(B24=$A$13,SUM(E24*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-07",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-08",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-10",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-11",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B29=$A$7,SUM(E29*$C$4*$B$7),(IF(B29=$A$8,SUM(E29*$C$4*$B$8),IF(B29=$A$9,SUM(E29*$C$4*$B$9),IF(B29=$A$10,SUM(E29*$C$4*$B$10),IF(B29=$A$11,SUM(E29*$C$4*$B$11),IF(B29=$A$12,SUM(E29*$C$4*$B$12),IF(B29=$A$13,SUM(E29*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-12",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B31=$A$7,SUM(E31*$C$4*$B$7),(IF(B31=$A$8,SUM(E31*$C$4*$B$8),IF(B31=$A$9,SUM(E31*$C$4*$B$9),IF(B31=$A$10,SUM(E31*$C$4*$B$10),IF(B31=$A$11,SUM(E31*$C$4*$B$11),IF(B31=$A$12,SUM(E31*$C$4*$B$12),IF(B31=$A$13,SUM(E31*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B32=$A$7,SUM(E32*$C$4*$B$7),(IF(B32=$A$8,SUM(E32*$C$4*$B$8),IF(B32=$A$9,SUM(E32*$C$4*$B$9),IF(B32=$A$10,SUM(E32*$C$4*$B$10),IF(B32=$A$11,SUM(E32*$C$4*$B$11),IF(B32=$A$12,SUM(E32*$C$4*$B$12),IF(B32=$A$13,SUM(E32*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
["2017-04-15",null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B38=$A$7,SUM(E38*$C$4*$B$7),(IF(B38=$A$8,SUM(E38*$C$4*$B$8),IF(B38=$A$9,SUM(E38*$C$4*$B$9),IF(B38=$A$10,SUM(E38*$C$4*$B$10),IF(B38=$A$11,SUM(E38*$C$4*$B$11),IF(B38=$A$12,SUM(E38*$C$4*$B$12),IF(B38=$A$13,SUM(E38*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B39=$A$7,SUM(E39*$C$4*$B$7),(IF(B39=$A$8,SUM(E39*$C$4*$B$8),IF(B39=$A$9,SUM(E39*$C$4*$B$9),IF(B39=$A$10,SUM(E39*$C$4*$B$10),IF(B39=$A$11,SUM(E39*$C$4*$B$11),IF(B39=$A$12,SUM(E39*$C$4*$B$12),IF(B39=$A$13,SUM(E39*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B40=$A$7,SUM(E40*$C$4*$B$7),(IF(B40=$A$8,SUM(E40*$C$4*$B$8),IF(B40=$A$9,SUM(E40*$C$4*$B$9),IF(B40=$A$10,SUM(E40*$C$4*$B$10),IF(B40=$A$11,SUM(E40*$C$4*$B$11),IF(B40=$A$12,SUM(E40*$C$4*$B$12),IF(B40=$A$13,SUM(E40*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B41=$A$7,SUM(E41*$C$4*$B$7),(IF(B41=$A$8,SUM(E41*$C$4*$B$8),IF(B41=$A$9,SUM(E41*$C$4*$B$9),IF(B41=$A$10,SUM(E41*$C$4*$B$10),IF(B41=$A$11,SUM(E41*$C$4*$B$11),IF(B41=$A$12,SUM(E41*$C$4*$B$12),IF(B41=$A$13,SUM(E41*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B43=$A$7,SUM(E43*$C$4*$B$7),(IF(B43=$A$8,SUM(E43*$C$4*$B$8),IF(B43=$A$9,SUM(E43*$C$4*$B$9),IF(B43=$A$10,SUM(E43*$C$4*$B$10),IF(B43=$A$11,SUM(E43*$C$4*$B$11),IF(B43=$A$12,SUM(E43*$C$4*$B$12),IF(B43=$A$13,SUM(E43*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B44=$A$7,SUM(E44*$C$4*$B$7),(IF(B44=$A$8,SUM(E44*$C$4*$B$8),IF(B44=$A$9,SUM(E44*$C$4*$B$9),IF(B44=$A$10,SUM(E44*$C$4*$B$10),IF(B44=$A$11,SUM(E44*$C$4*$B$11),IF(B44=$A$12,SUM(E44*$C$4*$B$12),IF(B44=$A$13,SUM(E44*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B47=$A$7,SUM(E47*$C$4*$B$7),(IF(B47=$A$8,SUM(E47*$C$4*$B$8),IF(B47=$A$9,SUM(E47*$C$4*$B$9),IF(B47=$A$10,SUM(E47*$C$4*$B$10),IF(B47=$A$11,SUM(E47*$C$4*$B$11),IF(B47=$A$12,SUM(E47*$C$4*$B$12),IF(B47=$A$13,SUM(E47*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B49=$A$7,SUM(E49*$C$4*$B$7),(IF(B49=$A$8,SUM(E49*$C$4*$B$8),IF(B49=$A$9,SUM(E49*$C$4*$B$9),IF(B49=$A$10,SUM(E49*$C$4*$B$10),IF(B49=$A$11,SUM(E49*$C$4*$B$11),IF(B49=$A$12,SUM(E49*$C$4*$B$12),IF(B49=$A$13,SUM(E49*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B51=$A$7,SUM(E51*$C$4*$B$7),(IF(B51=$A$8,SUM(E51*$C$4*$B$8),IF(B51=$A$9,SUM(E51*$C$4*$B$9),IF(B51=$A$10,SUM(E51*$C$4*$B$10),IF(B51=$A$11,SUM(E51*$C$4*$B$11),IF(B51=$A$12,SUM(E51*$C$4*$B$12),IF(B51=$A$13,SUM(E51*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B62=$A$7,SUM(E62*$C$4*$B$7),(IF(B62=$A$8,SUM(E62*$C$4*$B$8),IF(B62=$A$9,SUM(E62*$C$4*$B$9),IF(B62=$A$10,SUM(E62*$C$4*$B$10),IF(B62=$A$11,SUM(E62*$C$4*$B$11),IF(B62=$A$12,SUM(E62*$C$4*$B$12),IF(B62=$A$13,SUM(E62*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B63=$A$7,SUM(E63*$C$4*$B$7),(IF(B63=$A$8,SUM(E63*$C$4*$B$8),IF(B63=$A$9,SUM(E63*$C$4*$B$9),IF(B63=$A$10,SUM(E63*$C$4*$B$10),IF(B63=$A$11,SUM(E63*$C$4*$B$11),IF(B63=$A$12,SUM(E63*$C$4*$B$12),IF(B63=$A$13,SUM(E63*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B71=$A$7,SUM(E71*$C$4*$B$7),(IF(B71=$A$8,SUM(E71*$C$4*$B$8),IF(B71=$A$9,SUM(E71*$C$4*$B$9),IF(B71=$A$10,SUM(E71*$C$4*$B$10),IF(B71=$A$11,SUM(E71*$C$4*$B$11),IF(B71=$A$12,SUM(E71*$C$4*$B$12),IF(B71=$A$13,SUM(E71*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B72=$A$7,SUM(E72*$C$4*$B$7),(IF(B72=$A$8,SUM(E72*$C$4*$B$8),IF(B72=$A$9,SUM(E72*$C$4*$B$9),IF(B72=$A$10,SUM(E72*$C$4*$B$10),IF(B72=$A$11,SUM(E72*$C$4*$B$11),IF(B72=$A$12,SUM(E72*$C$4*$B$12),IF(B72=$A$13,SUM(E72*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B73=$A$7,SUM(E73*$C$4*$B$7),(IF(B73=$A$8,SUM(E73*$C$4*$B$8),IF(B73=$A$9,SUM(E73*$C$4*$B$9),IF(B73=$A$10,SUM(E73*$C$4*$B$10),IF(B73=$A$11,SUM(E73*$C$4*$B$11),IF(B73=$A$12,SUM(E73*$C$4*$B$12),IF(B73=$A$13,SUM(E73*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},{"$f":"IF(B74=$A$7,SUM(E74*$C$4*$B$7),(IF(B74=$A$8,SUM(E74*$C$4*$B$8),IF(B74=$A$9,SUM(E74*$C$4*$B$9),IF(B74=$A$10,SUM(E74*$C$4*$B$10),IF(B74=$A$11,SUM(E74*$C$4*$B$11),IF(B74=$A$12,SUM(E74*$C$4*$B$12),IF(B74=$A$13,SUM(E74*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla111121314151617[[#This Row],[Columna7]]<0,Tabla111121314151617[[#This Row],[Columna7]]*-1,Tabla111121314151617[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla111121314151617[[#This Row],[Columna4]]-Tabla111121314151617[[#This Row],[Columna3]])*24","v":0}]

{"sheet":"ANGEL ESTIVEN","index":14,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":true,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[13,0,13,3],[15,0,15,5]]}
["EMPLEADO"]
["SALARIO BÁSICO",null,368858]
["AUX. TRANSPORTE",null,83140]
["HORA BÁSICA",null,{"$f":"+C2/240","v":1536.9083333333333}]
[]
["CLASE","FACTOR","VR. HORA","Total Horas","Vr. Horas"]
["HEOD",1.25,{"$f":"+$C$4*B7","v":1921.1354166666665},{"$f":"SUMIF($B$61:$B$100,$A7,$E$61:$E$100)","v":0},{"$f":"+IF(G7<0,G7*-1,G7)","v":0},null,{"$f":"SUMIF($B$61:$B$100,$A7,$F$61:$F$100)","v":0}]
["HEON",1.75,{"$f":"+$C$4*B8","v":2689.5895833333334},{"$f":"SUMIF($B$19:$B$100,$A8,$E$19:$E$100)","v":0},{"$f":"+IF(G8<0,G8*-1,G8)","v":0},null,{"$f":"SUMIF($B$19:$B$100,$A8,$F$19:$F$100)","v":0}]
["HEFD",2,3073.8166666666666,{"$f":"SUMIF($B$19:$B$100,$A9,$E$19:$E$100)","v":0},0,null,{"$f":"SUMIF($B$19:$B$100,$A9,$F$19:$F$100)","v":0}]
["HEFN",2.5,3842.270833333333,{"$f":"SUMIF($B$19:$B$100,$A10,$E$19:$E$100)","v":0},0,null,{"$f":"SUMIF($B$19:$B$100,$A10,$F$19:$F$100)","v":0}]
["RON",0.35,537.91791666666666,{"$f":"SUMIF($B$19:$B$100,$A11,$E$19:$E$100)","v":0},0,null,{"$f":"SUMIF($B$19:$B$99,$A11,$F$19:$F$99)","v":0}]
["RFD",0.75,1152.6812500000001,{"$f":"SUMIF($B$19:$B$99,$A12,$E$19:$E$99)","v":0},0,null,{"$f":"SUMIF($B$19:$B$99,$A12,$F$19:$F$99)","v":0}]
["RFN",1.1000000000000001,1690.5991666666669,{"$f":"SUMIF($B$19:$B$99,$A13,$E$19:$E$99)","v":0},0,null,{"$f":"SUMIF($B$19:$B$99,$A13,$F$19:$F$99)","v":0}]
["Total ",null,null,null,{"$f":"SUM(E7:E13)","v":0},null,{"$f":"SUM(G7:G13)","v":0}]
[]
["Periodo del 1 al 15 Octubre de 2016"]
["Fecha","TIPO HE","ENTRA","SALE","TOTAL","DEVENGADO"]
["Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
["2017-04-01",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B19=$A$7,SUM(E19*$C$4*$B$7),(IF(B19=$A$8,SUM(E19*$C$4*$B$8),IF(B19=$A$9,SUM(E19*$C$4*$B$9),IF(B19=$A$10,SUM(E19*$C$4*$B$10),IF(B19=$A$11,SUM(E19*$C$4*$B$11),IF(B19=$A$12,SUM(E19*$C$4*$B$12),IF(B19=$A$13,SUM(E19*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0},null,"DESCANSO"]
["2017-04-02",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B20=$A$7,SUM(E20*$C$4*$B$7),(IF(B20=$A$8,SUM(E20*$C$4*$B$8),IF(B20=$A$9,SUM(E20*$C$4*$B$9),IF(B20=$A$10,SUM(E20*$C$4*$B$10),IF(B20=$A$11,SUM(E20*$C$4*$B$11),IF(B20=$A$12,SUM(E20*$C$4*$B$12),IF(B20=$A$13,SUM(E20*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0},null,"DOMINGO"]
["2017-04-03",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B21=$A$7,SUM(E21*$C$4*$B$7),(IF(B21=$A$8,SUM(E21*$C$4*$B$8),IF(B21=$A$9,SUM(E21*$C$4*$B$9),IF(B21=$A$10,SUM(E21*$C$4*$B$10),IF(B21=$A$11,SUM(E21*$C$4*$B$11),IF(B21=$A$12,SUM(E21*$C$4*$B$12),IF(B21=$A$13,SUM(E21*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0},null,"FESTIVO"]
["2017-04-04",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-05",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-06",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B24=$A$7,SUM(E24*$C$4*$B$7),(IF(B24=$A$8,SUM(E24*$C$4*$B$8),IF(B24=$A$9,SUM(E24*$C$4*$B$9),IF(B24=$A$10,SUM(E24*$C$4*$B$10),IF(B24=$A$11,SUM(E24*$C$4*$B$11),IF(B24=$A$12,SUM(E24*$C$4*$B$12),IF(B24=$A$13,SUM(E24*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-07",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-08",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-09",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-10",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B28=$A$7,SUM(E28*$C$4*$B$7),(IF(B28=$A$8,SUM(E28*$C$4*$B$8),IF(B28=$A$9,SUM(E28*$C$4*$B$9),IF(B28=$A$10,SUM(E28*$C$4*$B$10),IF(B28=$A$11,SUM(E28*$C$4*$B$11),IF(B28=$A$12,SUM(E28*$C$4*$B$12),IF(B28=$A$13,SUM(E28*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-11",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-12",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B30=$A$7,SUM(E30*$C$4*$B$7),(IF(B30=$A$8,SUM(E30*$C$4*$B$8),IF(B30=$A$9,SUM(E30*$C$4*$B$9),IF(B30=$A$10,SUM(E30*$C$4*$B$10),IF(B30=$A$11,SUM(E30*$C$4*$B$11),IF(B30=$A$12,SUM(E30*$C$4*$B$12),IF(B30=$A$13,SUM(E30*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-13",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B31=$A$7,SUM(E31*$C$4*$B$7),(IF(B31=$A$8,SUM(E31*$C$4*$B$8),IF(B31=$A$9,SUM(E31*$C$4*$B$9),IF(B31=$A$10,SUM(E31*$C$4*$B$10),IF(B31=$A$11,SUM(E31*$C$4*$B$11),IF(B31=$A$12,SUM(E31*$C$4*$B$12),IF(B31=$A$13,SUM(E31*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-14",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
["2017-04-15",null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B37=$A$7,SUM(E37*$C$4*$B$7),(IF(B37=$A$8,SUM(E37*$C$4*$B$8),IF(B37=$A$9,SUM(E37*$C$4*$B$9),IF(B37=$A$10,SUM(E37*$C$4*$B$10),IF(B37=$A$11,SUM(E37*$C$4*$B$11),IF(B37=$A$12,SUM(E37*$C$4*$B$12),IF(B37=$A$13,SUM(E37*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B38=$A$7,SUM(E38*$C$4*$B$7),(IF(B38=$A$8,SUM(E38*$C$4*$B$8),IF(B38=$A$9,SUM(E38*$C$4*$B$9),IF(B38=$A$10,SUM(E38*$C$4*$B$10),IF(B38=$A$11,SUM(E38*$C$4*$B$11),IF(B38=$A$12,SUM(E38*$C$4*$B$12),IF(B38=$A$13,SUM(E38*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B39=$A$7,SUM(E39*$C$4*$B$7),(IF(B39=$A$8,SUM(E39*$C$4*$B$8),IF(B39=$A$9,SUM(E39*$C$4*$B$9),IF(B39=$A$10,SUM(E39*$C$4*$B$10),IF(B39=$A$11,SUM(E39*$C$4*$B$11),IF(B39=$A$12,SUM(E39*$C$4*$B$12),IF(B39=$A$13,SUM(E39*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B40=$A$7,SUM(E40*$C$4*$B$7),(IF(B40=$A$8,SUM(E40*$C$4*$B$8),IF(B40=$A$9,SUM(E40*$C$4*$B$9),IF(B40=$A$10,SUM(E40*$C$4*$B$10),IF(B40=$A$11,SUM(E40*$C$4*$B$11),IF(B40=$A$12,SUM(E40*$C$4*$B$12),IF(B40=$A$13,SUM(E40*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B42=$A$7,SUM(E42*$C$4*$B$7),(IF(B42=$A$8,SUM(E42*$C$4*$B$8),IF(B42=$A$9,SUM(E42*$C$4*$B$9),IF(B42=$A$10,SUM(E42*$C$4*$B$10),IF(B42=$A$11,SUM(E42*$C$4*$B$11),IF(B42=$A$12,SUM(E42*$C$4*$B$12),IF(B42=$A$13,SUM(E42*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B43=$A$7,SUM(E43*$C$4*$B$7),(IF(B43=$A$8,SUM(E43*$C$4*$B$8),IF(B43=$A$9,SUM(E43*$C$4*$B$9),IF(B43=$A$10,SUM(E43*$C$4*$B$10),IF(B43=$A$11,SUM(E43*$C$4*$B$11),IF(B43=$A$12,SUM(E43*$C$4*$B$12),IF(B43=$A$13,SUM(E43*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B46=$A$7,SUM(E46*$C$4*$B$7),(IF(B46=$A$8,SUM(E46*$C$4*$B$8),IF(B46=$A$9,SUM(E46*$C$4*$B$9),IF(B46=$A$10,SUM(E46*$C$4*$B$10),IF(B46=$A$11,SUM(E46*$C$4*$B$11),IF(B46=$A$12,SUM(E46*$C$4*$B$12),IF(B46=$A$13,SUM(E46*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B48=$A$7,SUM(E48*$C$4*$B$7),(IF(B48=$A$8,SUM(E48*$C$4*$B$8),IF(B48=$A$9,SUM(E48*$C$4*$B$9),IF(B48=$A$10,SUM(E48*$C$4*$B$10),IF(B48=$A$11,SUM(E48*$C$4*$B$11),IF(B48=$A$12,SUM(E48*$C$4*$B$12),IF(B48=$A$13,SUM(E48*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B50=$A$7,SUM(E50*$C$4*$B$7),(IF(B50=$A$8,SUM(E50*$C$4*$B$8),IF(B50=$A$9,SUM(E50*$C$4*$B$9),IF(B50=$A$10,SUM(E50*$C$4*$B$10),IF(B50=$A$11,SUM(E50*$C$4*$B$11),IF(B50=$A$12,SUM(E50*$C$4*$B$12),IF(B50=$A$13,SUM(E50*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B61=$A$7,SUM(E61*$C$4*$B$7),(IF(B61=$A$8,SUM(E61*$C$4*$B$8),IF(B61=$A$9,SUM(E61*$C$4*$B$9),IF(B61=$A$10,SUM(E61*$C$4*$B$10),IF(B61=$A$11,SUM(E61*$C$4*$B$11),IF(B61=$A$12,SUM(E61*$C$4*$B$12),IF(B61=$A$13,SUM(E61*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B70=$A$7,SUM(E70*$C$4*$B$7),(IF(B70=$A$8,SUM(E70*$C$4*$B$8),IF(B70=$A$9,SUM(E70*$C$4*$B$9),IF(B70=$A$10,SUM(E70*$C$4*$B$10),IF(B70=$A$11,SUM(E70*$C$4*$B$11),IF(B70=$A$12,SUM(E70*$C$4*$B$12),IF(B70=$A$13,SUM(E70*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B71=$A$7,SUM(E71*$C$4*$B$7),(IF(B71=$A$8,SUM(E71*$C$4*$B$8),IF(B71=$A$9,SUM(E71*$C$4*$B$9),IF(B71=$A$10,SUM(E71*$C$4*$B$10),IF(B71=$A$11,SUM(E71*$C$4*$B$11),IF(B71=$A$12,SUM(E71*$C$4*$B$12),IF(B71=$A$13,SUM(E71*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B72=$A$7,SUM(E72*$C$4*$B$7),(IF(B72=$A$8,SUM(E72*$C$4*$B$8),IF(B72=$A$9,SUM(E72*$C$4*$B$9),IF(B72=$A$10,SUM(E72*$C$4*$B$10),IF(B72=$A$11,SUM(E72*$C$4*$B$11),IF(B72=$A$12,SUM(E72*$C$4*$B$12),IF(B72=$A$13,SUM(E72*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},{"$f":"IF(B73=$A$7,SUM(E73*$C$4*$B$7),(IF(B73=$A$8,SUM(E73*$C$4*$B$8),IF(B73=$A$9,SUM(E73*$C$4*$B$9),IF(B73=$A$10,SUM(E73*$C$4*$B$10),IF(B73=$A$11,SUM(E73*$C$4*$B$11),IF(B73=$A$12,SUM(E73*$C$4*$B$12),IF(B73=$A$13,SUM(E73*$C$4*$B$13)))))))))","v":false},{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]
[null,null,null,null,{"$f":"+IF(Tabla11112131415161725[[#This Row],[Columna7]]<0,Tabla11112131415161725[[#This Row],[Columna7]]*-1,Tabla11112131415161725[[#This Row],[Columna7]])","v":0},false,{"$f":"+(Tabla11112131415161725[[#This Row],[Columna4]]-Tabla11112131415161725[[#This Row],[Columna3]])*24","v":0}]