{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["INDICE","ORGANIGRAMA","LOCALIZACION","CROQUIS","INVERSION TOTAL ","FINANCIAMIENTO","AMORTIZACION DE CREDITO","INGRESO POR VENTAS","PLANILLA DE EMPLEADOS","GASTOS INDIRECTOS","COSTOS FIJOS","COSTOS VARIABLES","DEPRECIACION ","PRESUPUESTO DE GASTOS","BALANCE GENERAL","COSTO BENEFICIO","FLUJO DE CAJA ECON FINANCI","PUNTO DE EQUILIBRIO","PRECIO DE EQUILIBRIO","ESTADO DE GANACIAS Y PERDIDAS","PRINCIPALES RATIOS","CUADROS DE RATIOS","ENCUESTA","MUESTRA","ENTREVISTA"],"not_rendered":{"charts":27,"images":2,"macros":1,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INDICE","index":0,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"LOCALIZACION",null,null,null," 1 .INVERSION TOTAL",null,null,null,"8.COSTOS VARIABLES",null,null,null,"15.PRECIO DE EQUILIBRIO"]
[]
[null,"CROQUIS",null,null,null,"2. FINANCIAMIENTO",null,null,null,"9.DEPRECIACION",null,null,null,"16. ESTADO DE GANANCIAS Y PERDIDAS"]
[]
[null,"ORGANIGRAMA",null,null,null,"3. AMORTIZACION DE CREDITO",null,null,null,"10.PRESUPUESTO DE GASTOS",null,null,null,"17.PRINCIPALES RATIOS"]
[]
[null,null,null,null,null,"4. INGRESO POR VENTAS",null,null,null,"11.BALANCE GENERAL",null,null,null,"18.CUADRO DE RATIOS"]
[]
[null,null,null,null,null,"5.PLANILLA DE EMPLEADOS",null,null,null,"12.COSTO BENEFICIO",null,null,null,"19.ENCUESTA"]
[]
[null,null,null,null,null,"6.GASTOS INDIRECTOS",null,null,null,"13.FLUJO DE CAJA ECONOMICO",null,null,null,"20. MUESTRA"]
[]
[null,null,null,null,null,"7. COSTOS FIJOS",null,null,null,"14.PUNTO DE EQUILIBRIO",null,null,null,"21.ENTREVISTA"]

{"sheet":"ORGANIGRAMA","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"LOCALIZACION","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"7.    Si usted pudiera elegir la ubicación del centro de fisioterapia y rehabilitación física, ¿Cuál de las siguientes alternativas preferiría? "]
[]
[]
[null,null,null,null,"PAMPA \nINALAMBRICA",86,{"$f":"(F18/F21)","v":0.26060606060606062}]
[null,null,null,null,"PUERTO",165,{"$f":"F19/F21","v":0.5}]
[null,null,null,null,"CIUDAD NUEVA",79,{"$f":"F20/F21","v":0.23939393939393938}]
[null,null,null,null,null,{"$f":"SUM(F18:F20)","v":330},{"$f":"SUM(G18:G20)","v":1}]

{"sheet":"CROQUIS","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"INVERSION TOTAL ","index":4,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
["ESTRUCTURA DE LA INVERSION"]
[]
["RUBRO","VALOR UNITARIO","CANT.","UNID.","COSTO TOTAL"]
[]
["I. ACTIVO FIJO"]
["A. TANGIBLES"]
["Maquinaria y/o Equipos",null,null,null,{"$f":"SUM(E8:E35)","v":42044}]
["COMPUTADORAS ",1500,3,"Unidad",{"$f":"B8*C8","v":4500}]
["Glomed - Camilla para Masajes",559,6,"Unidad",{"$f":"B9*C9","v":3354}]
["Masajeador Tens 4 Electrodos",139,6,"Unidad",{"$f":"B10*C10","v":834}]
["Ems electroestimulador",659,6,"Unidad",3954]
["Ultrasonido GB 818",399,2,"Unidad",798]
["Nevera pequeña",699,1,"Unidad",699]
["Hidrocolector",750,1,"Unidad",750]
["Tanque de Parafina",379,2,"Unidad",758]
["Bicicleta de Spinning Best Fitness SP2",949,2,"Unidad",1898]
["Elíptica E820P",899,2,"Unidad",1798]
["Trotadoras performance 400",3000,2,"Unidad",6000]
["Soporte de 6 pares de mancuerna",200,1,"Unidad",200]
["Mancuernas 2 libras",57,4,"par",228]
["Mancuernas 3 libras",79,4,"par",316]
["Mancuernas 5 libras",100,4,"par",400]
["Mancuernas 8 libras",120,4,"par",480]
["Multigimnasio crossover",2989,1,"Unidad",2989]
["Banca XRS",400,1,"Unidad",400]
["Multigimnasio profesional",1000,2,"Unidad",2000]
["Leg extension y femoral",1800,2,"Unidad",3600]
["piscina estructural",2000,1,"Unidad",2000]
["Goniómetro electrónico digital",150,1,"Unidad",150]
["Kit plataforma de fuerza",350,2,"Unidad",700]
["Balanza digital de peso, masa y tallimetro ",400,1,"Unidad",400]
["Martillos de reflejos",100,2,"Unidad",200]
["Caminador de estabilidad",250,2,"Unidad",500]
["Silla de ruedas",830,2,"Unidad",1660]
["Microlife - Tensiómetro Automático BPA100 ",239,2,"Unidad",478]
["MUEBLES Y ENSERES",null,null,null,{"$f":"SUM(E37:E44)","v":5962.46}]
["Escritorio",300,4,"Unidad",{"$f":"B37*C37","v":1200}]
["Silla Ejecutiva",150,4,"Unidad",600]
["Silla de espera en pasta ",150,3,"Unidad",450]
["Archivadores",170,4,"Unidad",680]
["Juegos Plasticos",500,1,"Unidad",500]
["instrumentos terapeuticos",{"$f":"'GASTOS INDIRECTOS'!D64","v":2092.46},1,"Unidad",2092.46]
["Muebles para PC",80,3,"Unidad",{"$f":"B43*C43","v":240}]
["Utiles de Escritorio",200,1,null,200]
["Otros",null,null,null,{"$f":"SUM(E46:E48)","v":865}]
["Extintor",120,2,"Unidad",{"$f":"B46*C46","v":240}]
["camilla de primeros auxilios ",300,2,"Unidad",{"$f":"B47*C47","v":600}]
["Botiquin",25,1,"Unidad",{"$f":"B48*C48","v":25}]
["TOTAL TANGIBLES",null,null,null,{"$f":"E33+E45+E7","v":43409}]
[]
["B. INTANGIBLES"]
["COMPROBANTES DE PAGO",100,1,"millar",{"$f":"B52*C52","v":100}]
["LIC. DE FUNCIONAMIENTO",180,1,"documento",{"$f":"B53*C53","v":180}]
["SUNAT (GRATUITO)",0,1,"documento",{"$f":"B54*C54","v":0}]
["SEPARACION DE NOMBRE COMERCIAL",18,1,"documento",18]
["ELABORACION DE ESTATUTO",300,1,"documento",300]
["NOTARIA",300,1,"documento",300]
["INSCRIPCION DE REGUSTROS PUBLICOS",300,1,"documento",300]
["DEFENSA CIVIL",200,1,"documento",200]
["TOTAL INTANGIBLES",null,null,null,{"$f":"SUM(E52:E59)","v":1398}]
["TOTAL ACTIVO FIJO",null,null,null,{"$f":"E60+E49","v":44807}]
[]
["II. CAPITAL DE TRABAJO"]
["Gastos Administrativos",null,null,null,{"$f":"'GASTOS INDIRECTOS'!E15","v":3442.666666666667}]
["Salarios",null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!I30","v":6685.39}]
[]
[]
["TOTAL CAPITAL DE TRABAJO",null,null,null,{"$f":"SUM(E64:E67)","v":10128.056666666667}]
["TOTAL COSTOS",null,null,null,{"$f":"E68+E61","v":54935.056666666671}]

{"sheet":"FINANCIAMIENTO","index":5,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,1,2,4],[2,0,3,0]]}
["FUENTES DE FINANCIAMIENTO"]
[]
["FUENTE","DESTINO"]
[null,"INVERSION FIJA","CAPITAL DE TRABAJO","TOTAL","%"]
["APORTE PROPIO",15000,0,{"$f":"SUM(B5:C5)","v":15000},{"$f":"(D5*E6)/D6","v":0.27304968648738387}]
["PRESTAMO",{"$f":"+B7-B5","v":29807},{"$f":"C7-C5","v":10128.056666666667},{"$f":"SUM(B6:C6)","v":39935.056666666671},{"$f":"(D6*E7)/D7","v":0.72695031351261619}]
["TOTAL",{"$f":"'INVERSION TOTAL '!E61","v":44807},{"$f":"'INVERSION TOTAL '!E68","v":10128.056666666667},{"$f":"SUM(B7:C7)","v":54935.056666666671},1]

{"sheet":"AMORTIZACION DE CREDITO","index":6,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,2],[24,11,25,11],[24,10,25,10],[16,12,17,12],[14,12,15,12],[14,11,17,11]]}
[]
[null,"PRESTAMO"]
[null,"MONTO",{"$f":"FINANCIAMIENTO!D6","v":39935.056666666671}]
[null,"TEA",0.12]
[null,"PLAZO",24]
[null,"SEG DESG",7.6999999999999999E-2,null,null,null,null,null,null,null,null,"TM =","((1 + TEA/100)^(1/12)) - 1"]
[null,"TEM",{"$f":"(((1+(C4))^(1/C5))-1)*100","v":0.47331949003093232}]
[null,"TEM SEG DES",{"$f":"(((1+(C6/100))^(1/C5))-1)*100","v":3.2071501866681729E-3},null,null,null,null,null,null,null,null,"TM =",{"$f":"((1+(C4/100))^(1/24))-1","v":4.9971272500837216E-5}]
[null,"TEM TOTAL",{"$f":"(SUM(C7:C8))/100","v":4.7652664021760049E-3},null,null,null,null,null,null,null,null,"TM =",{"$f":"M8*100","v":4.9971272500837216E-3}]
[null,"CUOTA",{"$f":"C3*(((C9*((1+C9)^C5)))/(((1+C9)^C5)-1))","v":1764.8817246872541}]
[]
[null,"CRONOGRAMA DE PAGOS"]
[]
[null,"MES","SALDO","AMORT.","INTERES","CUOTA"]
[null,0,{"$f":"C3","v":39935.056666666671},0,0,0,null,null,null,null,null,"R = P x   ","     i (1+i) n"]
[null,1,{"$f":"C15-D16","v":38360.476125782079},{"$f":"F16-(C15*$C$9)","v":1574.5805408845924},{"$f":"F16-D16","v":190.30118380266163},{"$f":"$C$10","v":1764.8817246872541},null,{"$f":"SUM(D16:D18)","v":4746.2872651039079}]
[null,{"$f":"B16+1","v":2},36778.392289148491,1582.08383663359,182.79788805366411,1764.8817246872541,null,null,null,null,null,null,"(1 + i) n ‑ 1"]
[null,3,35188.769401562764,1589.6228875857257,175.25883710152834,1764.8817246872541]
[null,4,33591.571537438693,1597.197864124068,167.68386056318604,1764.8817246872541]
[null,5,31986.762599995087,1604.8089374436056,160.07278724364846,1764.8817246872541,null,null,null,null,null,"R= CUOTA FIJA"]
[null,6,30374.30632043997,1612.4562795551174,152.4254451321367,1764.8817246872541,null,null,null,null,null,"P= MONTO DEL PRESTAMO"]
[null,7,28754.166257150911,1620.1400632890593,144.74166139819476,1764.8817246872541,null,null,null,null,null,"i= TASA DE INTERES"]
[null,8,27126.30579485144,1627.8604622994699,137.02126238778419,1764.8817246872541,null,null,null,null,null,"n= TIEPO"]
[null,9,25490.688143783544,1635.6176510678963,129.26407361935776,1764.8817246872541]
[null,10,23847.276338876207,1643.4118049073361,121.46991977991797,1764.8817246872541,null,null,null,null,"R =","40300.54X",{"$f":"(M9)*(1+M9)^C5","v":5.6321744351006684E-3}]
[null,11,22196.033238910008,1651.2430999662006,113.63862472105347,1764.8817246872541,null,null,null,null,null,null,{"$f":"((1+M9)^24)-1","v":0.1270824522241869}]
[null,12,20536.921525677713,1659.1117132322943,105.77001145495979,1764.8817246872541]
[null,13,18869.903703140895,1667.0178225368168,97.863902150437298,1764.8817246872541,null,null,null,null,{"$f":"K25","v":"R ="},{"$f":"L25","v":"40300.54X"},{"$f":"M25/M26","v":4.431905693136072E-2}]
[null,14,17194.942096582516,1674.9616065583803,89.92011812887381,1764.8817246872541]
[null,15,15511.998851755468,1682.9432448270475,81.938479860206598,1764.8817246872541,null,null,null,null,{"$f":"K25","v":"R ="},{"$f":"F16","v":1764.8817246872541}]
[null,16,13821.035934027077,1690.9629177283909,73.918806958863115,1764.8817246872541]
[null,17,12122.015127519509,1699.0208065075676,65.86091817968645,1764.8817246872541]
[null,18,10414.898034246093,1707.117093273416,57.76463141383806,1764.8817246872541]
[null,19,8699.6460732435207,1715.2519610025722,49.629763684681848,1764.8817246872541]
[null,20,6976.2204796999167,1723.4255935436042,41.456131143649827,1764.8817246872541]
[null,21,5244.5823040787491,1731.6381756211679,33.243549066086189,1764.8817246872541]
[null,22,3504.6924112385682,1739.8898928401809,24.991831847073172,1764.8817246872541]
[null,23,1756.5114795485504,1748.1809316900178,16.700792997236249,1764.8817246872541]
[null,24,-1.7462298274040222E-10,1756.511479548725,8.3702451385290715,1764.8817246872541]

{"sheet":"INGRESO POR VENTAS","index":7,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,2],[17,0,17,2]]}
["PROYECCION DE SERVICIOS REALIZADOS"]
[]
["SERVICIO","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Mes 13","Mes 14","Mes 15","Mes 16","Mes 17","Mes 18","Mes 19","Mes 20","Mes 21","Mes 22","Mes 23","Mes 24","TOTAL"]
["PROGRAMA DE REHABILITACION CARDIACA",{"$f":"MUESTRA!$T$37*ENTREVISTA!H31","v":25.710974478762939},20,20,20,20,20,20,20,20,20,20,20,{"$f":"(B4*15%)+B4","v":29.567620650577378},{"$f":"(C4*15%)+C4","v":23},23,23,{"$f":"(F4*15%)+F4","v":23},{"$f":"(G4*15%)+G4","v":23},23,{"$f":"(I4*15%)+I4","v":23},{"$f":"(J4*15%)+J4","v":23},23,{"$f":"(L4*15%)+L4","v":23},{"$f":"(M4*15%)+M4","v":23},34.002763748163986]
["PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIM. Y SEC.",{"$f":"MUESTRA!$T$37*ENTREVISTA!H32","v":38.566461718144403},40,40,40,40,40,40,40,40,40,40,40,{"$f":"(B5*15%)+B5","v":44.351430975866066},46,46,46,46,46,46,46,46,46,46,46,51.004145622245979]
["FISIOTERARIA EN SALUD OCUPACIONAL",{"$f":"MUESTRA!$T$37*ENTREVISTA!H33","v":64.277436196907345},50,50,50,50,50,50,50,50,50,50,50,73.919051626443448,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,85.006909370409971]
["REHABILITACION DEPORTIVA.",{"$f":"MUESTRA!$T$37*ENTREVISTA!H34","v":102.84389791505176},50,50,50,50,50,50,50,50,50,50,50,118.27048260230951,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,136.01105499265594]
["PROGRAMA DE FISIOTERAPIA",{"$f":"MUESTRA!$T$37*ENTREVISTA!H35","v":89.988410675670281},50,50,50,50,50,50,50,50,50,50,50,103.48667227702083,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,119.00967311857396]
["TRATAMIENTO DE FISIOTERAPIA INTEGRAL.",{"$f":"MUESTRA!$T$37*ENTREVISTA!H36","v":77.132923436288806},50,50,50,50,50,50,50,50,50,50,50,88.702861951732132,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,102.00829124449196]
["REHABILITACIÓN CON HIDROTERAPIA",{"$f":"MUESTRA!$T$37*ENTREVISTA!H37","v":51.421948957525878},50,50,50,50,50,50,50,50,50,50,50,59.135241301154757,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,68.005527496327971]
["REHABILITACIÓN PACIENTES QUEMADOS",{"$f":"MUESTRA!$T$37*ENTREVISTA!H38","v":38.566461718144403},20,20,20,20,20,20,20,20,20,20,20,44.351430975866066,23,23,23,23,23,23,23,23,23,23,23,51.004145622245979]
["TERAPIA PSICOMOTRIZ PARA NIÑOS",{"$f":"MUESTRA!$T$37*ENTREVISTA!H39","v":38.566461718144403},30,30,30,30,30,30,30,30,30,30,30,44.351430975866066,34.5,34.5,34.5,34.5,34.5,34.5,34.5,34.5,34.5,34.5,34.5,51.004145622245979]
[null,{"$f":"SUM(B4:B12)","v":527.07497681464019}]
[]
[]
[]
[]
["PROYECCION DE VENTAS"]
[]
["SERVICIO","P. U.","Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12","Mes 13","Mes 14","Mes 15","Mes 16","Mes 17","Mes 18","Mes 19","Mes 20","Mes 21","Mes 22","Mes 23","Mes 24","TOTAL"]
["PROGRAMA DE REHABILITACION CARDIACA",60,{"$f":"B4*B21","v":1542.6584687257764},{"$f":"C4*B21","v":1200},{"$f":"D4*B21","v":1200},{"$f":"E4*B21","v":1200},{"$f":"F4*B21","v":1200},{"$f":"G4*B21","v":1200},{"$f":"H4*B21","v":1200},{"$f":"I4*B21","v":1200},{"$f":"J4*B21","v":1200},{"$f":"K4*B21","v":1200},{"$f":"L4*B21","v":1200},{"$f":"M4*B21","v":1200},{"$f":"N4*B21","v":1774.0572390346426},{"$f":"O4*B21","v":1380},{"$f":"P4*B21","v":1380},{"$f":"Q4*B21","v":1380},{"$f":"R4*B21","v":1380},{"$f":"S4*B21","v":1380},{"$f":"T4*B21","v":1380},{"$f":"U4*B21","v":1380},{"$f":"V4*B21","v":1380},{"$f":"W4*B21","v":1380},{"$f":"X4*B21","v":1380},{"$f":"Y4*B21","v":1380},{"$f":"SUM(C21:Z21)","v":31696.715707760421}]
["PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIM. Y SEC.",60,2313.9877030886641,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2661.0858585519641,2760,2760,2760,2760,2760,2760,2760,2760,2760,2760,2760,{"$f":"SUM(C22:Z22)","v":61735.073561640631}]
["FISIOTERARIA EN SALUD OCUPACIONAL",60,3856.6461718144405,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,4435.1430975866069,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,79241.789269401052]
["REHABILITACION DEPORTIVA.",60,6170.6338749031056,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,7096.2289561385705,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,84216.862831041683]
["PROGRAMA DE FISIOTERAPIA",70,6299.1887472969192,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,7244.0670593914583,4025,4025,4025,4025,4025,4025,4025,4025,4025,4025,4025,96318.255806688379]
["TRATAMIENTO DE FISIOTERAPIA INTEGRAL.",70,5399.3046405402165,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,3500,6209.2003366212493,4025,4025,4025,4025,4025,4025,4025,4025,4025,4025,4025,94383.504977161472]
["REHABILITACIÓN CON HIDROTERAPIA",60,3085.3169374515528,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3000,3548.1144780692853,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,3450,77583.431415520841]
["REHABILITACIÓN PACIENTES QUEMADOS",60,2313.9877030886641,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,2661.0858585519641,1380,1380,1380,1380,1380,1380,1380,1380,1380,1380,1380,33355.073561640631]
["TERAPIA PSICOMOTRIZ",60,2313.9877030886641,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,1800,2661.0858585519641,2070,2070,2070,2070,2070,2070,2070,2070,2070,2070,2070,47545.073561640631]
["TOTAL VENTAS",null,{"$f":"SUM(C21:C29)","v":33295.711949998004},22600,22600,22600,22600,22600,22600,22600,22600,22600,22600,22600,38290.068742497715,25990,25990,25990,25990,25990,25990,25990,25990,25990,25990,25990,606075.78069249587]
[]
["N° PARTICIPACION X PROGRAMA SEGÚN ENTREVISTA"]
["PROGRAMA DE REHABILITACION CARDIACA",{"$f":"ENTREVISTA!H31","v":4.878048780487805E-2}]
["PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIM. Y SEC.",{"$f":"ENTREVISTA!H32","v":7.3170731707317069E-2}]
["FISIOTERARIA EN SALUD OCUPACIONAL",{"$f":"ENTREVISTA!H33","v":0.12195121951219512}]
["REHABILITACION DEPORTIVA.",{"$f":"ENTREVISTA!H34","v":0.1951219512195122}]
["PROGRAMA DE FISIOTERAPIA",{"$f":"ENTREVISTA!H35","v":0.17073170731707318}]
["TRATAMIENTO DE FISIOTERAPIA INTEGRAL.",{"$f":"ENTREVISTA!H36","v":0.14634146341463414}]
["REHABILITACIÓN CON HIDROTERAPIA",{"$f":"ENTREVISTA!H37","v":9.7560975609756101E-2}]
["REHABILITACIÓN PACIENTES QUEMADOS",{"$f":"ENTREVISTA!H38","v":7.3170731707317069E-2}]
["TERAPIA PSICOMOTRIZ",{"$f":"ENTREVISTA!H39","v":7.3170731707317069E-2}]
[null,{"$f":"ENTREVISTA!H40","v":1}]

{"sheet":"PLANILLA DE EMPLEADOS","index":8,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,0,2,12],[17,0,17,12]]}
[]
[]
["MANO DE OBRA DIRECTA"]
[]
[null,null,null,"SNP","Aporte\nObligtorio","Comision","Comision\nMixta",null,null,"ESSALUD"]
["DESCRIPCION","CANTIDAD","SUELDO MES",0.12,0.1,1.6E-2,1.1900000000000001E-2,"TOTAL\nDESCUENTO","NETO A PAGAR",0.09,"TOTAL\nGASTO","GRATIFICACON","CANTIDAD EN\nVACACIONES","TOTAL DESCUENTO","NETO A PAGAR","TOTAL\nGASTO","GRATIFICACION"]
["MEDICO FISIATRA",1,2000,null,{"$f":"+C7*$E$6","v":200},{"$f":"+C7*$F$6","v":32},{"$f":"+C7*$G$6","v":23.8},{"$f":"SUM(D7:G7)*B7","v":255.8},{"$f":"(B7*C7)-H7","v":1744.2},{"$f":"+(C7*$J$6)*B7","v":180},{"$f":"+(C7*B7)+J7","v":2180},{"$f":"C7*B7","v":2000},1,{"$f":"SUM(D7:G7)","v":255.8},{"$f":"+C7-N7","v":1744.2},{"$f":"(C7*$J$6)+C7","v":2180},{"$f":"C7*M7","v":2000}]
["TECNOLOGOS MEDICOS ",2,1500,null,{"$f":"+C8*$E$6","v":150},{"$f":"+C8*$F$6","v":24},{"$f":"+C8*$G$6","v":17.850000000000001},{"$f":"SUM(D8:G8)*B8","v":383.7},{"$f":"(B8*C8)-H8","v":2616.3000000000002},{"$f":"+(C8*$J$6)*B8","v":270},{"$f":"+(C8*B8)+J8","v":3270},{"$f":"C8*B8","v":3000},1,{"$f":"SUM(D8:G8)","v":191.85},{"$f":"+C8-N8","v":1308.1500000000001},{"$f":"(C8*$J$6)+C8","v":1635},{"$f":"C8*M8","v":1500}]
["RECEPCIONISTA",1,900,null,{"$f":"+C9*$E$6","v":90},{"$f":"+C9*$F$6","v":14.4},{"$f":"+C9*$G$6","v":10.71},{"$f":"SUM(D9:G9)*B9","v":115.11000000000001},784.89,{"$f":"+(C9*$J$6)*B9","v":81},{"$f":"+(C9*B9)+J9","v":981},{"$f":"C9*B9","v":900},1,{"$f":"SUM(D9:G9)","v":115.11000000000001},{"$f":"+C9-N9","v":784.89},{"$f":"(C9*$J$6)+C9","v":981},{"$f":"C9*M9","v":900}]
["TECNICOS ENFERMERIA",1,900,{"$f":"+C10*$D$6","v":108},null,null,null,{"$f":"SUM(D10:G10)*B10","v":108},792,{"$f":"+(C10*$J$6)*B10","v":81},{"$f":"+(C10*B10)+J10","v":981},{"$f":"C10*B10","v":900},1,{"$f":"SUM(D10:G10)","v":108},{"$f":"+C10-N10","v":792},{"$f":"(C10*$J$6)+C10","v":981},{"$f":"C10*M10","v":900}]
["TOTAL PLANILLA",{"$f":"SUM(B7:B10)","v":5},5300,108,440,70.400000000000006,52.360000000000007,862.61,5937.39,612,7412,6800,4,670.76,4629.24,5777,5300]
["APORTES A PAGAR","%"]
["AFP",0.125]
["ESSALUD",8.5000000000000006E-2]
[]
[]
[]
["MANO DE OBRA INDIRECTA"]
[]
[]
[null,null,null,"SNP","Aporte\nObligtorio","Comision","Comision\nMixta",null,null,"ESSALUD"]
["DESCRIPCION","CANTIDAD","SUELDO MES",0.12,0.1,1.6E-2,1.1900000000000001E-2,"TOTAL\nDESCUENTO","NETO A PAGAR",0.09,"TOTAL\nGASTO","GRATIFICACON"]
["ADMINISTRADOR ",1,1500,null,{"$f":"+C23*$E$6","v":150},{"$f":"+C23*$F$6","v":24},{"$f":"+C23*$G$6","v":17.850000000000001},{"$f":"SUM(D23:G23)*B23","v":191.85},{"$f":"(B23*C23)-H23","v":1308.1500000000001},{"$f":"+(C23*$J$6)*B23","v":135},{"$f":"+(C23*B23)+J23","v":1635},{"$f":"C23*B23","v":1500},1,{"$f":"SUM(D23:G23)","v":191.85},{"$f":"+C23-N23","v":1308.1500000000001},{"$f":"(C23*$J$6)+C23","v":1635},{"$f":"C23*M23","v":1500}]
["Personal de Limpieza",1,850,{"$f":"+C24*$D$22","v":102},null,null,null,{"$f":"SUM(D24:G24)","v":102},{"$f":"+C24-H24","v":748},{"$f":"+C24*$J$22","v":76.5},{"$f":"+C24+J24","v":926.5},{"$f":"C24*B24","v":850}]
["TOTAL PLANILLA",{"$f":"SUM(B24:B24)","v":1},850,102,0,0,0,102,748,76.5,926.5,850]
["APORTES A PAGAR","%"]
["AFP",0.125]
["ESSALUD",8.5000000000000006E-2]
[]
[null,null,null,null,null,null,null,null,{"$f":"I11+I25","v":6685.39}]
[]
[null,null,null,"|"]

{"sheet":"GASTOS INDIRECTOS","index":9,"n_rows":64,"n_cols":5,"rows_kept":64,"cut":false,"hidden":false,"merged":[[47,0,47,3],[0,0,0,4],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4]]}
["GASTOS  INDIRECTOS"]
[]
["RUBRO","VALOR UNITARIO","CANT.","UNID.","COSTO TOTAL"]
[]
["Gastos Administrativos",null,null,null,{"$f":"SUM(E6:E12)","v":2642.666666666667}]
["Alquiler de local",1000,1,"Unidad",{"$f":"B6*C6","v":1000}]
["Agua",100,1,"Unidad",{"$f":"B7*C7","v":100}]
["Energia Electrica",300,1,"Unidad",{"$f":"B8*C8","v":300}]
["Celulares Y TELEFONO FIJO",50,2,"Unidad",{"$f":"B9*C9","v":100}]
["Insumos",0,null,null,0]
["Depreciacion",{"$f":"'DEPRECIACION '!H43","v":942.66666666666674},null,null,{"$f":"B11","v":942.66666666666674}]
["Mantenimiento de Local",200,1,"Unidad",{"$f":"B12*C12","v":200}]
["Gastos de venta",null,null,null,{"$f":"SUM(E14:E14)","v":800}]
["Publicidad",800,1,"Unidad",{"$f":"B14*C14","v":800}]
["TOTAL COSTOS ",null,null,null,{"$f":"E5+E13","v":3442.666666666667}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["INSTRUMENTOS TERAPEUTICOS"]
["Paquetes calientes",12,25,{"$f":"B49*C49","v":300}]
["Paquetes friopack compresas",12,7,84]
["Theratubos",10,8,80]
["Sabanas",18,6.99,125.82000000000001]
["Toallas",20,14.99,299.8]
["Almohadas",12,15,180]
["Bandas elásticas",10,9,90]
["Cojines cilíndricos",8,14.99,119.92]
["Cintas métricas",4,2,8]
["Caneca roja",2,45.82,91.64]
["Caneca verde",3,45.82,137.46]
["Caneca gris",1,45.82,45.82]
["Colchonetas",6,15,90]
["Uniformes para empleados",4,60,240]
["Dotación para empleados",4,50,200]
[null,null,null,{"$f":"SUM(D49:D63)","v":2092.46}]

{"sheet":"COSTOS FIJOS","index":10,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"COSTOS FIJOS"]
[]
[null,"RUBRO","VALOR UNITARIO","CANT.","UNID.","COSTO TOTAL"]
[]
[null,"Gastos Administrativos",null,null,null,{"$f":"SUM(F9:F10)","v":10128.056666666667}]
[null,"SALARIOS ",{"$f":"'INVERSION TOTAL '!E65","v":6685.39},1,"MES",{"$f":"C9*D9","v":6685.39}]
[null,"GASTOS ADMINISTRATIVOS ",{"$f":"'INVERSION TOTAL '!E64","v":3442.666666666667},1,"MES",{"$f":"C10*D10","v":3442.666666666667}]
[null,"Gastos de venta",null,null,null,{"$f":"F12","v":800}]
[null,{"$f":"[1]INVERSION!B36","v":"Publicidad"},{"$f":"'GASTOS INDIRECTOS'!B14","v":800},1,"MES",{"$f":"C12*D12","v":800}]
[null,"TOTAL FIJOS",null,null,null,{"$f":"F8+F11","v":10928.056666666667}]

{"sheet":"COSTOS VARIABLES","index":11,"n_rows":31,"n_cols":29,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,0,21,1]]}
[]
["COSTOS VARIABLES"]
["RUBRO","VALOR UNITARIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNID.","UNID.","PROMEDIO INSUMOS MENSUAL"]
[null,null,"ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","ENERO","FEBRERO","MARZO","ABRIL","MAYO","JUNIO","JULIO","AGOSTO","SEPTIEMBRE","OCTUBRE","NOVIEMBRE","DICIEMBRE","1°AÑO","2°AÑO",{"$f":"AVERAGE(C5:Z5)","v":120.59014000189342}]
["MATERIALES",null,{"$f":"SUM(C6:C14)","v":158.12249304439203},{"$f":"SUM(D6:D14)","v":108},108,108,108,108,108,108,108,108,108,108,181.84086700105087,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,{"$f":"SUM(C5:N5)","v":1346.1224930443921},{"$f":"SUM(O5:Z5)","v":1548.0408670010511}]
["Tarro gel conductor x galón",{"$f":"E23","v":0.3},{"$f":"$B$6*'INGRESO POR VENTAS'!B4","v":7.7132923436288809},{"$f":"$B$6*'INGRESO POR VENTAS'!C4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!D4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!E4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!F4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!G4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!H4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!I4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!J4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!K4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!L4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!M4","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!N4","v":8.8702861951732128},{"$f":"$B$6*'INGRESO POR VENTAS'!O4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!P4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!Q4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!R4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!S4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!T4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!U4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!V4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!W4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!X4","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!Y4","v":6.8999999999999995},{"$f":"SUM(C6:N6)","v":73.713292343628879},{"$f":"SUM(O6:Z6)","v":84.770286195173227}]
["Toallas Secantes 100mt x 6 und",{"$f":"E24","v":0.3},{"$f":"$B$6*'INGRESO POR VENTAS'!B5","v":11.569938515443321},{"$f":"$B$6*'INGRESO POR VENTAS'!C5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!D5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!E5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!F5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!G5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!H5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!I5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!J5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!K5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!L5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!M5","v":12},{"$f":"$B$6*'INGRESO POR VENTAS'!N5","v":13.30542929275982},{"$f":"$B$6*'INGRESO POR VENTAS'!O5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!P5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!Q5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!R5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!S5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!T5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!U5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!V5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!W5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!X5","v":13.799999999999999},{"$f":"$B$6*'INGRESO POR VENTAS'!Y5","v":13.799999999999999},{"$f":"SUM(C7:N7)","v":143.56993851544331},{"$f":"SUM(O7:Z7)","v":165.10542929275982}]
["Baja lenguas paquete x100",0.66,{"$f":"$B$6*'INGRESO POR VENTAS'!B6","v":19.283230859072201},{"$f":"$B$6*'INGRESO POR VENTAS'!C6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!D6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!E6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!F6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!G6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!H6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!I6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!J6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!K6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!L6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!M6","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!N6","v":22.175715487933033},{"$f":"$B$6*'INGRESO POR VENTAS'!O6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!P6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Q6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!R6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!S6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!T6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!U6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!V6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!W6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!X6","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Y6","v":17.25},184.28323085907221,211.92571548793302]
["Papel higiénico 170 mts x 4 und",0.484375,{"$f":"$B$6*'INGRESO POR VENTAS'!B7","v":30.853169374515524},{"$f":"$B$6*'INGRESO POR VENTAS'!C7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!D7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!E7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!F7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!G7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!H7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!I7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!J7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!K7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!L7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!M7","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!N7","v":35.481144780692851},{"$f":"$B$6*'INGRESO POR VENTAS'!O7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!P7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Q7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!R7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!S7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!T7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!U7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!V7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!W7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!X7","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Y7","v":17.25},195.85316937451552,225.23114478069286]
["Guantes caja",0.5,{"$f":"$B$6*'INGRESO POR VENTAS'!B8","v":26.996523202701084},{"$f":"$B$6*'INGRESO POR VENTAS'!C8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!D8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!E8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!F8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!G8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!H8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!I8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!J8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!K8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!L8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!M8","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!N8","v":31.046001683106248},{"$f":"$B$6*'INGRESO POR VENTAS'!O8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!P8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Q8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!R8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!S8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!T8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!U8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!V8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!W8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!X8","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Y8","v":17.25},191.9965232027011,220.79600168310625]
["Tapabocas caja x 50 und",0.44666666666666666,{"$f":"$B$6*'INGRESO POR VENTAS'!B9","v":23.139877030886641},{"$f":"$B$6*'INGRESO POR VENTAS'!C9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!D9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!E9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!F9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!G9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!H9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!I9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!J9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!K9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!L9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!M9","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!N9","v":26.61085858551964},{"$f":"$B$6*'INGRESO POR VENTAS'!O9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!P9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Q9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!R9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!S9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!T9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!U9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!V9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!W9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!X9","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Y9","v":17.25},188.13987703088662,216.36085858551962]
["Parafina",22,{"$f":"$B$6*'INGRESO POR VENTAS'!B10","v":15.426584687257762},{"$f":"$B$6*'INGRESO POR VENTAS'!C10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!D10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!E10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!F10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!G10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!H10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!I10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!J10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!K10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!L10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!M10","v":15},{"$f":"$B$6*'INGRESO POR VENTAS'!N10","v":17.740572390346426},{"$f":"$B$6*'INGRESO POR VENTAS'!O10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!P10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Q10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!R10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!S10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!T10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!U10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!V10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!W10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!X10","v":17.25},{"$f":"$B$6*'INGRESO POR VENTAS'!Y10","v":17.25},180.42658468725776,207.49057239034641]
["Jabón antibacterial",0.4,{"$f":"$B$6*'INGRESO POR VENTAS'!B11","v":11.569938515443321},{"$f":"$B$6*'INGRESO POR VENTAS'!C11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!D11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!E11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!F11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!G11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!H11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!I11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!J11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!K11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!L11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!M11","v":6},{"$f":"$B$6*'INGRESO POR VENTAS'!N11","v":13.30542929275982},{"$f":"$B$6*'INGRESO POR VENTAS'!O11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!P11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!Q11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!R11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!S11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!T11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!U11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!V11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!W11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!X11","v":6.8999999999999995},{"$f":"$B$6*'INGRESO POR VENTAS'!Y11","v":6.8999999999999995},77.569938515443312,89.205429292759831]
["Talco",0.24,{"$f":"$B$6*'INGRESO POR VENTAS'!B12","v":11.569938515443321},{"$f":"$B$6*'INGRESO POR VENTAS'!C12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!D12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!E12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!F12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!G12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!H12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!I12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!J12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!K12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!L12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!M12","v":9},{"$f":"$B$6*'INGRESO POR VENTAS'!N12","v":13.30542929275982},{"$f":"$B$6*'INGRESO POR VENTAS'!O12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!P12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!Q12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!R12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!S12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!T12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!U12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!V12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!W12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!X12","v":10.35},{"$f":"$B$6*'INGRESO POR VENTAS'!Y12","v":10.35},110.56993851544331,127.15542929275979]
[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,"TOTAL",{"$f":"SUM(AA6:AA14,AB6:AB14)","v":2894.1633600454429}]
[]
[]
[]
[]
[]
[]
["INSUMOS ",null,"VALOR ","SESIONES","VALOR UNITARIO"]
["Tarro gel conductor x galón",1,24,80,{"$f":"C23/D23","v":0.3}]
["Toallas Secantes 100mt x 6 und",1,45,150,{"$f":"C24/D24","v":0.3}]
["Baja lenguas paquete x100",1,33,50,0.66]
["Papel higiénico 170 mts x 4 und",1,38.75,80,0.484375]
["Guantes caja",1,25,50,0.5]
["Tapabocas caja x 50 und",1,13.4,30,0.44666666666666666]
["Parafina",1,22,1,22]
["Jabón antibacterial",1,8,20,0.4]
["Talco",1,12,50,0.24]

{"sheet":"DEPRECIACION ","index":12,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[[57,16,59,16],[57,17,59,17],[57,18,59,18],[0,0,0,7],[57,11,59,11],[57,12,59,12],[57,13,59,13],[57,14,59,14],[57,15,59,15]]}
["DEPRECIACION DE MAQUINARIA MUEBLES Y ENSERES"]
[]
["CANT.","UNID.","DESCRIPCION","VALOR UNITARIO","TOTAL","TASA DE DEPRECIACION","VIDA UTIL (MESES)","DEPRECIACION MES"]
[null,null,"Maquinaria y Equipos",null,null,null,null,{"$f":"SUM(H5:H33)","v":909.25000000000011}]
[3,"Unidad","COMPUTADORAS ",1500,{"$f":"D5*A5","v":4500},0.25,48,{"$f":"E5/G5","v":93.75}]
[4,"Unidad","VIDEOCAMARAS",400,{"$f":"D6*A6","v":1600},0.25,48,{"$f":"E6/G6","v":33.333333333333336}]
[6,"Unidad","Glomed - Camilla para Masajes",559,{"$f":"D7*A7","v":3354},0.25,48,{"$f":"E7/G7","v":69.875}]
[6,"Unidad","Masajeador Tens 4 Electrodos",139,834,0.25,48,17.375]
[6,"Unidad","Ems electroestimulador",659,3954,0.25,48,82.375]
[2,"Unidad","Ultrasonido GB 818",399,798,0.25,48,16.625]
[1,"Unidad","Nevera pequeña",699,699,0.25,48,14.5625]
[1,"Unidad","Hidrocolector",750,750,0.25,48,15.625]
[2,"Unidad","Tanque de Parafina",379,758,0.25,48,15.791666666666666]
[2,"Unidad","Bicicleta de Spinning Best Fitness SP2",949,1898,0.25,48,39.541666666666664]
[2,"Unidad","Elíptica E820P",899,1798,0.25,48,37.458333333333336]
[2,"Unidad","Trotadoras performance 400",3000,6000,0.25,48,125]
[1,"Unidad","Soporte de 6 pares de mancuerna",200,200,0.25,48,4.166666666666667]
[4,"Par","Mancuernas 2 libras",57,228,0.25,48,4.75]
[4,"Par","Mancuernas 3 libras",79,316,0.25,48,6.583333333333333]
[4,"Par","Mancuernas 5 libras",100,400,0.25,48,8.3333333333333339]
[4,"Par","Mancuernas 8 libras",120,480,0.25,48,10]
[1,"Unidad","Multigimnasio crossover",2989,2989,0.25,48,62.270833333333336]
[1,"Unidad","Banca XRS",400,400,0.25,48,8.3333333333333339]
[2,"Unidad","Multigimnasio profesional",1000,2000,0.25,48,41.666666666666664]
[2,"Unidad","Leg extension y femoral",1800,3600,0.25,48,75]
[1,"Unidad","piscina estructural",2000,2000,0.25,48,41.666666666666664]
[1,"Unidad","Goniómetro electrónico digital",150,150,0.25,48,3.125]
[2,"Unidad","Kit plataforma de fuerza",350,700,0.25,48,14.583333333333334]
[1,"Unidad","Balanza digital de peso, masa y tallimetro ",400,400,0.25,48,8.3333333333333339]
[2,"Unidad","Martillos de reflejos",100,200,0.25,48,4.166666666666667]
[2,"Unidad","Caminador de estabilidad",250,500,0.25,48,10.416666666666666]
[2,"Unidad","Silla de ruedas",830,1660,0.25,48,34.583333333333336]
[2,"Unidad","Microlife - Tensiómetro Automático BPA100 ",239,478,0.25,48,9.9583333333333339]
[null,null,"Muebles y enseres",null,null,null,null,{"$f":"SUM(H35:H39)","v":26.416666666666668}]
[4,"Unidad","Escritorio",300,{"$f":"D35*A35","v":1200},0.1,120,{"$f":"E35/G35","v":10}]
[4,"Unidad","Silla Ejecutiva",150,600,0.1,120,{"$f":"E36/G36","v":5}]
[3,"Unidad","Silla de espera en pasta ",150,450,0.1,120,3.75]
[4,"Unidad","Archivadores",170,680,0.1,120,5.666666666666667]
[3,"Unidad","Muebles para PC",80,240,0.1,120,2]
[null,null,"Otros",null,null,null,null,{"$f":"SUM(H41:H42)","v":7}]
[2,"Unidad","Extintor",120,{"$f":"D41*A41","v":240},0.1,120,2]
[2,null,"camilla de primeros auxilios ",300,{"$f":"D42*A42","v":600},0.1,120,5]
[null,null,"DEPRECIACION MENSUAL",null,null,null,null,{"$f":"+H4+H34+H40","v":942.66666666666674}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Anexo Nº 13"]
[null,null,null,null,null,null,null,null,null,"EVOLUCIÓN DE LOS PORCENTAJES ANUALES DE DEPRECIACIÓN DE BIENES QUE GENERAN RENTAS GRAVADAS DE TERCERA CATEGORÍA: 1990-2014   1/"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Porcentaje Anual de Depreciación  2/"]
[null,null,null,null,null,null,null,null,null,null,"Vida",1990,1991,"1992-1993","1994-1995","1996-1998",1999,"2000 - 2009","2010 - 2014"]
[null,null,null,null,null,null,null,null,null,"Bienes","útil"]
[null,null,null,null,null,null,null,null,null,null,"(años)"]
[null,null,null,null,null,null,null,null,null," - Viviendas para alquiler                      3/  ",null,null,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,null," - Establecimiento de hospedaje     4/   ",null,null,null,null,0.1,0.1,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,null," - Titulares de inversión turística      5/",null,null,null,null,null,0.1,0.1]
[null,null,null,null,null,null,null,null,null," - Edificios y construcciones",null,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.05]
[null,null,null,null,null,null,null,null,null," - Ganado de trabajo y reproducción; redes de pesca     6/",4,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25]
[null,null,null,null,null,null,null,null,null," - Aves reproductoras  (gallinas)                                             7/",null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null," - Vehículos de transporte terrestre (excepto ferrocarriles); hornos en general",5,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,null,null,null,null,null,null,null,null," - Maquinarias y equipos utilizados por las actividades minera, petrolera y de"]
[null,null,null,null,null,null,null,null,null,"   construcción; excepto muebles, enseres y equipos de oficina 8/",5,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,null,null,null,null,null,null,null,null," - Equipos de procesamiento de datos                                  9/",4,null,null,0.2,0.2,0.2,0.25,0.25,0.25]
[null,null,null,null,null,null,null,null,null," - Maquinaria y equipo adquirido a partir del 01/01/91      10/",10,null,0.2,0.2,0.2,0.2,0.1,0.1,0.1]
[null,null,null,null,null,null,null,null,null," - Otros bienes del activo fijo",10,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]

{"sheet":"PRESUPUESTO DE GASTOS","index":13,"n_rows":31,"n_cols":25,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["PRESUPUESTO DE GASTOS"]
[]
["CONCEPTO",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["GASTOS OPERATIVOS",{"$f":"B13+B5","v":7363.8624930443921},5837.24,5837.24,5837.24,5837.24,5837.24,11137.24,5837.24,5837.24,5837.24,5837.24,11137.24,5861.080867001051,5803.44,5853.44,5853.44,5853.44,5853.44,11153.44,5853.44,5853.44,5853.44,5853.44,11153.44]
["A.- COSTOS DIRECTOS",{"$f":"B6+B9","v":4787.3624930443921},4737.24,4737.24,4737.24,4737.24,4737.24,10037.24,4737.24,4737.24,4737.24,4737.24,10037.24,4811.080867001051,4753.4399999999996,4753.4399999999996,4753.4399999999996,4753.4399999999996,4753.4399999999996,10053.44,4753.4399999999996,4753.4399999999996,4753.4399999999996,4753.4399999999996,10053.44]
["I. MATERIALES USADOS",{"$f":"B7","v":158.12249304439203},{"$f":"C7","v":108},{"$f":"D7","v":108},108,108,108,108,108,108,108,108,108,181.84086700105087,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2,124.2]
["Insumos ",{"$f":"'COSTOS VARIABLES'!C5","v":158.12249304439203},{"$f":"'COSTOS VARIABLES'!D5","v":108},{"$f":"'COSTOS VARIABLES'!E5","v":108},{"$f":"'COSTOS VARIABLES'!F5","v":108},{"$f":"'COSTOS VARIABLES'!G5","v":108},{"$f":"'COSTOS VARIABLES'!H5","v":108},{"$f":"'COSTOS VARIABLES'!I5","v":108},{"$f":"'COSTOS VARIABLES'!J5","v":108},{"$f":"'COSTOS VARIABLES'!K5","v":108},{"$f":"'COSTOS VARIABLES'!L5","v":108},{"$f":"'COSTOS VARIABLES'!M5","v":108},{"$f":"'COSTOS VARIABLES'!N5","v":108},{"$f":"'COSTOS VARIABLES'!O5","v":181.84086700105087},{"$f":"'COSTOS VARIABLES'!P5","v":124.2},{"$f":"'COSTOS VARIABLES'!Q5","v":124.2},{"$f":"'COSTOS VARIABLES'!R5","v":124.2},{"$f":"'COSTOS VARIABLES'!S5","v":124.2},{"$f":"'COSTOS VARIABLES'!T5","v":124.2},{"$f":"'COSTOS VARIABLES'!U5","v":124.2},{"$f":"'COSTOS VARIABLES'!V5","v":124.2},{"$f":"'COSTOS VARIABLES'!W5","v":124.2},{"$f":"'COSTOS VARIABLES'!X5","v":124.2},{"$f":"'COSTOS VARIABLES'!Y5","v":124.2},{"$f":"'COSTOS VARIABLES'!Z5","v":124.2}]
[]
["II. MANO DE OBRA DIRECTA",{"$f":"B10+B11","v":4629.24},{"$f":"C10+C11","v":4629.24},4629.24,4629.24,4629.24,4629.24,9929.24,4629.24,4629.24,4629.24,4629.24,9929.24,4629.24,4629.24,4629.24,4629.24,4629.24,4629.24,9929.24,4629.24,4629.24,4629.24,4629.24,9929.24]
["Sueldos ",{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24},{"$f":"'PLANILLA DE EMPLEADOS'!$O$11","v":4629.24}]
["Gratificaciones",null,null,null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!Q11","v":5300},null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!Q11","v":5300},null,null,null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!Q11","v":5300},null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!Q11","v":5300}]
[]
["B.- COSTOS INDIRECTOS",{"$f":"B14+B20","v":2576.5},{"$f":"C15+C16","v":1100},1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1050,1050,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100]
["I. INSUMOS",{"$f":"SUM(B15:B19)","v":1650},{"$f":"SUM(C15:C19)","v":1650},1750,1750,1750,1750,1750,1750,1750,1750,1750,1750,1600,1600,1750,1750,1750,1750,1750,1750,1750,1750,1750,1750]
["Alquiler",{"$f":"'GASTOS INDIRECTOS'!B6","v":1000},{"$f":"B15","v":1000},{"$f":"C15","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
["Agua",{"$f":"'GASTOS INDIRECTOS'!B7","v":100},{"$f":"B16","v":100},100,100,100,100,100,100,100,100,100,100,50,50,100,100,100,100,100,100,100,100,100,100]
["Energia Electrica",{"$f":"'GASTOS INDIRECTOS'!B8","v":300},200,300,300,300,300,300,300,300,300,300,300,200,200,300,300,300,300,300,300,300,300,300,300]
["Celulares",{"$f":"'GASTOS INDIRECTOS'!B9","v":50},150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150]
["Mantenimiento de Local",200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200,200]
["II. MANO DE OBRA INDIRECTA",{"$f":"SUM(B21:B22)","v":926.5},926.5,926.5,926.5,926.5,926.5,7726.5,926.5,926.5,926.5,926.5,7726.5,926.5,926.5,926.5,926.5,926.5,926.5,7726.5,926.5,926.5,926.5,926.5,7726.5]
["Sueldos",{"$f":"'PLANILLA DE EMPLEADOS'!K25","v":926.5},{"$f":"B21","v":926.5},{"$f":"C21","v":926.5},926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5,926.5]
["Gratificaciones",null,null,null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!L11","v":6800},null,null,null,null,{"$f":"H22","v":6800},null,null,null,null,null,null,{"$f":"M22","v":6800},null,null,null,null,{"$f":"T22","v":6800}]
[]
["GASTOS DE OPERACIÓN"]
["A.- GASTOS DE VENTAS",{"$f":"SUM(B26:B26)","v":800},800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800,800]
[{"$f":"+'[2]GASTOS INDIRECTOS'!A13","v":"Publicidad"},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800},{"$f":"+'GASTOS INDIRECTOS'!$B$14","v":800}]
[]
["B.- GASTOS ADMINISTRACION",{"$f":"B29+B30+B31","v":1869.1666666666667},{"$f":"C29+C30+C31","v":1869.1666666666667},1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,2719.166666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,2719.166666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,2719.166666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,1869.1666666666667,2719.166666666667]
["Planilla de Empleados",{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5},{"$f":"'PLANILLA DE EMPLEADOS'!$K$25","v":926.5}]
["Gratificaciones",null,null,null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!L25","v":850},null,null,null,null,{"$f":"'PLANILLA DE EMPLEADOS'!L25","v":850},null,null,null,null,null,null,{"$f":"M30","v":850},null,null,null,null,{"$f":"T30","v":850}]
["Depreciación",{"$f":"'DEPRECIACION '!H43","v":942.66666666666674},{"$f":"B31","v":942.66666666666674},{"$f":"C31","v":942.66666666666674},942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674]

{"sheet":"BALANCE GENERAL","index":14,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,10]]}
["BALANCE GENERAL"]
[]
["Estado de Situación Financiera Balance General",null,null,"1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
[1,"ACTIVO/"]
[1.1000000000000001,"Activo Corriente/"]
["1.1.1","CyB","Caja y Bancos/",{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!C17:E17)","v":46155.224282891853},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!F17:H17)","v":36986.134825938243},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!I17:K17)","v":30836.134825938243},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!L17:N17)","v":30836.134825938239},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!O17:Q17)","v":59449.962701434895},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!R17:T17)","v":47107.534825938237},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!U17:W17)","v":40957.534825938237},{"$f":"SUM('FLUJO DE CAJA ECON FINANCI'!X17:Z17)","v":40957.534825938237}]
[null,"CxCC","Cuentas por Cobrar Comerciales",{"$f":"+('INGRESO POR VENTAS'!C30+'INGRESO POR VENTAS'!D30+'INGRESO POR VENTAS'!E30)*0.05","v":3924.7855974999002},{"$f":"+('INGRESO POR VENTAS'!F30+'INGRESO POR VENTAS'!G30+'INGRESO POR VENTAS'!H30)*0.05","v":3390},{"$f":"+('INGRESO POR VENTAS'!I30+'INGRESO POR VENTAS'!J30+'INGRESO POR VENTAS'!K30)*0.05","v":3390},{"$f":"+('INGRESO POR VENTAS'!L30+'INGRESO POR VENTAS'!M30+'INGRESO POR VENTAS'!N30)*0.05","v":3390},{"$f":"+('INGRESO POR VENTAS'!O30+'INGRESO POR VENTAS'!P30+'INGRESO POR VENTAS'!Q30)*0.05","v":4513.5034371248857},{"$f":"+('INGRESO POR VENTAS'!R30+'INGRESO POR VENTAS'!S30+'INGRESO POR VENTAS'!T30)*0.05","v":3898.5},{"$f":"+('INGRESO POR VENTAS'!U30+'INGRESO POR VENTAS'!V30+'INGRESO POR VENTAS'!W30)*0.05","v":3898.5},{"$f":"+('INGRESO POR VENTAS'!X30+'INGRESO POR VENTAS'!Y30+'INGRESO POR VENTAS'!Z30)*0.05","v":3898.5}]
["1.1.2","Exit","Existencias/",{"$f":"'PRESUPUESTO DE GASTOS'!B6","v":158.12249304439203},{"$f":"D8","v":158.12249304439203},{"$f":"E8","v":158.12249304439203},158.12249304439203,{"$f":"'COSTOS VARIABLES'!O5","v":181.84086700105087},{"$f":"H8","v":181.84086700105087},{"$f":"I8","v":181.84086700105087},181.84086700105087]
[1.1000000000000001,"TOTAL ACTIVO CORRIENTE/",null,{"$f":"SUM(D6:D8)","v":50238.132373436143},40534.257318982636,34384.257318982636,34384.257318982629,64145.307005560833,51187.875692939291,45037.875692939291,45037.875692939291]
["1.2.","Activo No Corriente/"]
["1.2.1","IME","Inmueble Maquinaria y Eq",{"$f":"'INVERSION TOTAL '!E49","v":43409},{"$f":"D11","v":43409},43409,43409,43409,43409,43409,43409]
["1.2.2","AIN","Activos Intangibles (neto)/",{"$f":"'INVERSION TOTAL '!E60","v":1398},1398,1398,1398,1398,1398,1398,1398]
["1.2.3","DEPR","Depreciacion Acumulada /",{"$f":"'DEPRECIACION '!H43","v":942.66666666666674},942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674,942.66666666666674]
[1.2,"TOTAL ACTIVO NO CORRIENTE/",null,{"$f":"(SUM(D11:D12))-D13","v":43864.333333333336},43864.333333333336,43864.333333333336,43864.333333333336,43864.333333333336,43864.333333333336,43864.333333333336,43864.333333333336]
[1,"TOTAL ACTIVO/",null,{"$f":"D14+D9","v":94102.465706769479},84398.590652315965,78248.590652315965,78248.590652315965,108009.64033889417,95052.209026272627,88902.209026272627,88902.209026272627]
[2,"PASIVO Y PATRIMONIO"]
[2.1,"Pasivo Corriente/"]
["2.1.1","TribxP","Tributos por Pagar",{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!B16:D16)","v":15270.453464398728},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!E16:G16)","v":12540.179372118309},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!H16:J16)","v":10970.925900778398},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!K16:M16)","v":10991.970433213222},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!N16:P16)","v":19342.465612607142},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!Q16:S16)","v":15661.390693034286},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!T16:V16)","v":14093.355166831676},{"$f":"SUM('ESTADO DE GANACIAS Y PERDIDAS'!W16:Y16)","v":14115.635139005148}]
["2.1.2","CPPC","Cuentas por Pagar Comerciales/",0,0,0,0,0,0,0,0]
["2.1.3","CPPER","Cuentas por Pagar a Entidades Financieras/",{"$f":"'AMORTIZACION DE CREDITO'!D16+'AMORTIZACION DE CREDITO'!D17+'AMORTIZACION DE CREDITO'!D18","v":4746.2872651039079},{"$f":"'AMORTIZACION DE CREDITO'!D19+'AMORTIZACION DE CREDITO'!D20+'AMORTIZACION DE CREDITO'!D21","v":4814.4630811227908},{"$f":"'AMORTIZACION DE CREDITO'!D22+'AMORTIZACION DE CREDITO'!D23+'AMORTIZACION DE CREDITO'!D24","v":4883.618176656425},{"$f":"'AMORTIZACION DE CREDITO'!D25+'AMORTIZACION DE CREDITO'!D26+'AMORTIZACION DE CREDITO'!D27","v":4953.7666181058312},{"$f":"'AMORTIZACION DE CREDITO'!D28+'AMORTIZACION DE CREDITO'!D29+'AMORTIZACION DE CREDITO'!D30","v":5024.922673922244},{"$f":"'AMORTIZACION DE CREDITO'!D31+'AMORTIZACION DE CREDITO'!D32+'AMORTIZACION DE CREDITO'!D33","v":5097.1008175093748},{"$f":"'AMORTIZACION DE CREDITO'!D34+'AMORTIZACION DE CREDITO'!D35+'AMORTIZACION DE CREDITO'!D36","v":5170.3157301673446},{"$f":"'AMORTIZACION DE CREDITO'!D37+'AMORTIZACION DE CREDITO'!D38+'AMORTIZACION DE CREDITO'!D39","v":5244.5823040789237}]
[2.1,"TOTAL PASIVO CORRIENTE/",null,{"$f":"SUM(D18:D20)","v":20016.740729502635},17354.6424532411,15854.544077434824,15945.737051319054,24367.388286529385,20758.491510543659,19263.670896999021,19360.217443084071]
[2.2000000000000002,"Pasivo  No Corriente/"]
["2.2.1","CPPER","Cuentas por Pagar a Entidades Financieras/",{"$f":"'AMORTIZACION DE CREDITO'!C18","v":35188.769401562764},{"$f":"'AMORTIZACION DE CREDITO'!C21","v":30374.30632043997},{"$f":"'AMORTIZACION DE CREDITO'!C24","v":25490.688143783544},{"$f":"'AMORTIZACION DE CREDITO'!C27","v":20536.921525677713},{"$f":"'AMORTIZACION DE CREDITO'!C30","v":15511.998851755468},{"$f":"'AMORTIZACION DE CREDITO'!C33","v":10414.898034246093},{"$f":"'AMORTIZACION DE CREDITO'!C36","v":5244.5823040787491},{"$f":"'[2]AMORTIZACION DE CREDITO'!C39","v":-3.4333424991928041E-10}]
[2.2000000000000002,"TOTAL PASIVO NO CORRIENTE/",null,{"$f":"D23","v":35188.769401562764},30374.30632043997,25490.688143783544,20536.921525677713,15511.998851755468,10414.898034246093,5244.5823040787491,-3.4333424991928041E-10]
[2,"TOTAL PASIVO/",null,{"$f":"+D21+D24","v":55205.510131065399},47728.94877368107,41345.232221218364,36482.658576996764,39879.387138284852,31173.389544789752,24508.253201077772,19360.217443083729]
[2.2999999999999998,"PATRIMONIO NETO/"]
["2.4.1","Capi","Capital/",{"$f":"FINANCIAMIENTO!D5","v":15000},{"$f":"D27","v":15000},15000,15000,15000,15000,15000,15000]
["2.4.6","Util","Utilidad del Ejercicio",{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B17+'ESTADO DE GANACIAS Y PERDIDAS'!C17+'ESTADO DE GANACIAS Y PERDIDAS'!D17","v":35631.058083597032},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!E17+'ESTADO DE GANACIAS Y PERDIDAS'!F17+'ESTADO DE GANACIAS Y PERDIDAS'!G17","v":29260.418534942728},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!H17+'ESTADO DE GANACIAS Y PERDIDAS'!I17+'ESTADO DE GANACIAS Y PERDIDAS'!J17","v":25598.82710181627},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!K17+'ESTADO DE GANACIAS Y PERDIDAS'!L17+'ESTADO DE GANACIAS Y PERDIDAS'!M17","v":25647.931010830849},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!N17+'ESTADO DE GANACIAS Y PERDIDAS'!O17+'ESTADO DE GANACIAS Y PERDIDAS'!P17","v":45132.419762749996},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Q17+'ESTADO DE GANACIAS Y PERDIDAS'!R17+'ESTADO DE GANACIAS Y PERDIDAS'!S17","v":36543.244950413326},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!T17+'ESTADO DE GANACIAS Y PERDIDAS'!U17+'ESTADO DE GANACIAS Y PERDIDAS'!V17","v":32884.495389273914},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!W17+'ESTADO DE GANACIAS Y PERDIDAS'!X17+'ESTADO DE GANACIAS Y PERDIDAS'!Y17","v":32936.481991012013}]
["2.4.7","ORC","Utilidad de Trimestres pasados",0,{"$f":"D28+D29","v":35631.058083597032},64891.47661853976,90490.303720356023,116138.23473118688,161270.65449393686,197813.89944435019,230698.3948336241]
[2.4,"TOTAL PATRIMONIO NETO/",null,{"$f":"SUM(D27:D29)","v":50631.058083597032},79891.47661853976,105490.30372035602,131138.23473118688,176270.65449393686,212813.89944435019,245698.3948336241,278634.87682463613]
[2.5,"TOTAL PASIVO Y PATRIMONIO NETO/",null,{"$f":"D30+D25","v":105836.56821466243},127620.42539222083,146835.53594157437,167620.89330818364,216150.04163222172,243987.28898913995,270206.64803470188,297995.09426771983]

{"sheet":"COSTO BENEFICIO","index":15,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["EVALUACION COSTO - BENEFICIO"]
[]
["MESES","INGRESOS","COSTOS",{"$f":"6/100","v":0.06},"INGRESOS ACTUALIZADOS","COSTOS ACTUALIZADOS"]
[0,null,{"$f":"'FLUJO DE CAJA ECON FINANCI'!B6","v":54935.056666666671},{"$f":"1/(1+$D$3)^A4","v":1},{"$f":"B4*D4","v":0},{"$f":"C4*D4","v":54935.056666666671}]
[1,{"$f":"'FLUJO DE CAJA ECON FINANCI'!C4","v":33295.711949998004},{"$f":"'FLUJO DE CAJA ECON FINANCI'!C6","v":10033.029159711059},0.94339622641509424,31411.049009432074,9465.1218487840179]
[2,{"$f":"'FLUJO DE CAJA ECON FINANCI'!D4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!D6","v":8506.4066666666658},0.88999644001423983,20113.91954432182,7570.6716506467292]
[3,{"$f":"'FLUJO DE CAJA ECON FINANCI'!E4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!E6","v":8506.4066666666658},0.8396192830323016,18975.395796530018,7142.1430666478564]
[4,{"$f":"'FLUJO DE CAJA ECON FINANCI'!F4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!F6","v":8506.4066666666658},0.79209366323802044,17901.316789179262,6737.8708175923184]
[5,{"$f":"'FLUJO DE CAJA ECON FINANCI'!G4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!G6","v":8506.4066666666658},0.74725817286605689,16888.034706772887,6356.481903388978]
[6,{"$f":"'FLUJO DE CAJA ECON FINANCI'!H4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!H6","v":8506.4066666666658},0.70496054043967626,15932.108213936684,5996.6810409329983]
[7,{"$f":"'FLUJO DE CAJA ECON FINANCI'!I4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!I6","v":14656.406666666666},0.66505711362233599,15030.290767864793,9747.3475138084959]
[8,{"$f":"'FLUJO DE CAJA ECON FINANCI'!J4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!J6","v":8506.4066666666658},0.62741237134182648,14179.519592325278,5337.0247783312543]
[9,{"$f":"'FLUJO DE CAJA ECON FINANCI'!K4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!K6","v":8506.4066666666658},0.59189846353002495,13376.905275778565,5034.9290361615604]
[10,{"$f":"'FLUJO DE CAJA ECON FINANCI'!L4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!L6","v":8506.4066666666658},0.55839477691511785,12619.721958281663,4749.9330529826038]
[11,{"$f":"'FLUJO DE CAJA ECON FINANCI'!M4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!M6","v":8506.4066666666658},0.52678752539162055,11905.398073850625,4481.0689179081164]
[12,{"$f":"'FLUJO DE CAJA ECON FINANCI'!N4","v":22600},{"$f":"'FLUJO DE CAJA ECON FINANCI'!N6","v":14656.406666666666},0.4969693635770005,11231.507616840212,7283.7850934590406]
[13,{"$f":"'FLUJO DE CAJA ECON FINANCI'!O4","v":38290.068742497715},{"$f":"'FLUJO DE CAJA ECON FINANCI'!O6","v":8530.247533667718},0.46883902224245327,17951.878390828952,3999.3129131708715]
[14,{"$f":"'FLUJO DE CAJA ECON FINANCI'!P4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!P6","v":8472.6066666666666},0.44230096437967292,11495.402064227699,3747.4420994763127]
[15,{"$f":"'FLUJO DE CAJA ECON FINANCI'!Q4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!Q6","v":8522.6066666666666},0.41726506073554037,10844.718928516695,3556.1859883917878]
[16,{"$f":"'FLUJO DE CAJA ECON FINANCI'!R4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!R6","v":8522.6066666666666},0.39364628371277405,10230.866913694997,3354.8924418790461]
[17,{"$f":"'FLUJO DE CAJA ECON FINANCI'!S4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!S6","v":8522.6066666666666},0.37136441859695657,9651.7612393349009,3164.9928696972129]
[18,{"$f":"'FLUJO DE CAJA ECON FINANCI'!T4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!T6","v":8522.6066666666666},0.35034379112920433,9105.4351314480209,2985.842329903031]
[19,{"$f":"'FLUJO DE CAJA ECON FINANCI'!U4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!U6","v":14672.606666666667},0.3305130104992493,8590.0331428754889,4849.4874012713553]
[20,{"$f":"'FLUJO DE CAJA ECON FINANCI'!V4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!V6","v":8522.6066666666666},0.31180472688608429,8103.8048517693305,2657.389044057521]
[21,{"$f":"'FLUJO DE CAJA ECON FINANCI'!W4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!W6","v":8522.6066666666666},0.29415540272272095,7645.0989167635171,2506.9707962806797]
[22,{"$f":"'FLUJO DE CAJA ECON FINANCI'!X4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!X6","v":8522.6066666666666},0.27750509690822728,7212.3574686448273,2365.0667889440369]
[23,{"$f":"'FLUJO DE CAJA ECON FINANCI'!Y4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!Y6","v":8522.6066666666666},0.26179726123417668,6804.1108194762519,2231.1950839094688]
[24,{"$f":"'FLUJO DE CAJA ECON FINANCI'!Z4","v":25990},{"$f":"'FLUJO DE CAJA ECON FINANCI'!Z6","v":14672.606666666667},0.24697854833412897,6418.9724712040115,3623.8190948109964]
[null,null,null,null,{"$f":"SUM(E4:E28)","v":313619.60768389865},{"$f":"SUM(F4:F28)","v":173880.71223910296}]
[null,null,null,null,"B/C",{"$f":"E29/F29","v":1.803648050697199},"Es la division de las actualizaciones de los ingresos y costos del proyecto "]
[null,null,null,null,null,null,"si el resultado es mayor a 1 el proyecto es viable."]

{"sheet":"FLUJO DE CAJA ECON FINANCI","index":16,"n_rows":23,"n_cols":26,"rows_kept":23,"cut":false,"hidden":false,"merged":[[31,3,32,5],[0,0,1,1]]}
["FLUJO ECONÓMICO ‑ FINANCIERO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COK",0.06]
["CONCEPTO",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["INGRESOS",null,{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B4","v":33295.711949998004},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!C4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!D4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!E4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!F4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!G4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!H4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!I4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!J4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!K4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!L4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!M4","v":22600},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!N4","v":38290.068742497715},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!O4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!P4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Q4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!R4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!S4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!T4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!U4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!V4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!W4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!X4","v":25990},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Y4","v":25990}]
[]
["COSTOS",{"$f":"B7+B8+B9+B10","v":54935.056666666671},{"$f":"SUM(C8:C10)","v":10033.029159711059},8506.4066666666658,8506.4066666666658,8506.4066666666658,8506.4066666666658,8506.4066666666658,14656.406666666666,8506.4066666666658,8506.4066666666658,8506.4066666666658,8506.4066666666658,14656.406666666666,8530.247533667718,8472.6066666666666,8522.6066666666666,8522.6066666666666,8522.6066666666666,8522.6066666666666,14672.606666666667,8522.6066666666666,8522.6066666666666,8522.6066666666666,8522.6066666666666,14672.606666666667]
["Inversión",{"$f":"'INVERSION TOTAL '!E69","v":54935.056666666671}]
["Costos de Producción (1)",null,{"$f":"'PRESUPUESTO DE GASTOS'!B4","v":7363.8624930443921},{"$f":"'PRESUPUESTO DE GASTOS'!C4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!D4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!E4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!F4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!G4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!H4","v":11137.24},{"$f":"'PRESUPUESTO DE GASTOS'!I4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!J4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!K4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!L4","v":5837.24},{"$f":"'PRESUPUESTO DE GASTOS'!M4","v":11137.24},{"$f":"'PRESUPUESTO DE GASTOS'!N4","v":5861.080867001051},{"$f":"'PRESUPUESTO DE GASTOS'!O4","v":5803.44},{"$f":"'PRESUPUESTO DE GASTOS'!P4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!Q4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!R4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!S4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!T4","v":11153.44},{"$f":"'PRESUPUESTO DE GASTOS'!U4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!V4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!W4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!X4","v":5853.44},{"$f":"'PRESUPUESTO DE GASTOS'!Y4","v":11153.44}]
["Gastos de Ventas",null,{"$f":"'PRESUPUESTO DE GASTOS'!B25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!C25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!D25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!E25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!F25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!G25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!H25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!I25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!J25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!K25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!L25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!M25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!N25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!O25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!P25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!Q25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!R25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!S25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!T25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!U25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!V25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!W25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!X25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!Y25","v":800}]
["Gastos Administrativos (2)",null,{"$f":"'PRESUPUESTO DE GASTOS'!B28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!C28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!D28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!E28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!F28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!G28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!H28","v":2719.166666666667},{"$f":"'PRESUPUESTO DE GASTOS'!I28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!J28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!K28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!L28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!M28","v":2719.166666666667},{"$f":"'PRESUPUESTO DE GASTOS'!N28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!O28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!P28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!Q28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!R28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!S28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!T28","v":2719.166666666667},{"$f":"'PRESUPUESTO DE GASTOS'!U28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!V28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!W28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!X28","v":1869.1666666666667},{"$f":"'PRESUPUESTO DE GASTOS'!Y28","v":2719.166666666667}]
[]
["FLUJO ECONÓMICO",{"$f":"B4-B6","v":-54935.056666666671},23262.682790286945,14093.593333333334,14093.593333333334,14093.593333333334,14093.593333333334,14093.593333333334,7943.5933333333342,14093.593333333334,14093.593333333334,14093.593333333334,14093.593333333334,7943.5933333333342,29759.821208829999,17517.393333333333,17467.393333333333,17467.393333333333,17467.393333333333,17467.393333333333,11317.393333333333,17467.393333333333,17467.393333333333,17467.393333333333,17467.393333333333,11317.393333333333]
["Préstamo",{"$f":"'AMORTIZACION DE CREDITO'!C3","v":39935.056666666671}]
["Amortización",null,{"$f":"'AMORTIZACION DE CREDITO'!D16","v":1574.5805408845924},{"$f":"'AMORTIZACION DE CREDITO'!D17","v":1582.08383663359},{"$f":"'AMORTIZACION DE CREDITO'!D18","v":1589.6228875857257},{"$f":"'AMORTIZACION DE CREDITO'!D19","v":1597.197864124068},{"$f":"'AMORTIZACION DE CREDITO'!D20","v":1604.8089374436056},{"$f":"'AMORTIZACION DE CREDITO'!D21","v":1612.4562795551174},{"$f":"'AMORTIZACION DE CREDITO'!D22","v":1620.1400632890593},{"$f":"'AMORTIZACION DE CREDITO'!D23","v":1627.8604622994699},{"$f":"'AMORTIZACION DE CREDITO'!D24","v":1635.6176510678963},{"$f":"'AMORTIZACION DE CREDITO'!D25","v":1643.4118049073361},{"$f":"'AMORTIZACION DE CREDITO'!D26","v":1651.2430999662006},{"$f":"'AMORTIZACION DE CREDITO'!D27","v":1659.1117132322943},{"$f":"'AMORTIZACION DE CREDITO'!D28","v":1667.0178225368168},{"$f":"'AMORTIZACION DE CREDITO'!D29","v":1674.9616065583803},{"$f":"'AMORTIZACION DE CREDITO'!D30","v":1682.9432448270475},{"$f":"'AMORTIZACION DE CREDITO'!D31","v":1690.9629177283909},{"$f":"'AMORTIZACION DE CREDITO'!D32","v":1699.0208065075676},{"$f":"'AMORTIZACION DE CREDITO'!D33","v":1707.117093273416},{"$f":"'AMORTIZACION DE CREDITO'!D34","v":1715.2519610025722},{"$f":"'AMORTIZACION DE CREDITO'!D35","v":1723.4255935436042},{"$f":"'AMORTIZACION DE CREDITO'!D36","v":1731.6381756211679},{"$f":"'AMORTIZACION DE CREDITO'!D37","v":1739.8898928401809},{"$f":"'AMORTIZACION DE CREDITO'!D38","v":1748.1809316900178},{"$f":"'AMORTIZACION DE CREDITO'!D39","v":1756.511479548725}]
["Intereses",null,{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!B13","v":190.30118380266163},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!C13","v":182.79788805366411},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!D13","v":175.25883710152834},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!E13","v":167.68386056318604},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!F13","v":160.07278724364846},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!G13","v":152.4254451321367},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!H13","v":144.74166139819476},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!I13","v":137.02126238778419},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!J13","v":129.26407361935776},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!K13","v":121.46991977991797},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!L13","v":113.63862472105347},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!M13","v":105.77001145495979},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!N13","v":97.863902150437298},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!O13","v":89.92011812887381},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!P13","v":81.938479860206598},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!Q13","v":73.918806958863115},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!R13","v":65.86091817968645},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!S13","v":57.76463141383806},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!T13","v":49.629763684681848},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!U13","v":41.456131143649827},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!V13","v":33.243549066086189},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!W13","v":24.991831847073172},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!X13","v":16.700792997236249},{"$f":"+'ESTADO DE GANACIAS Y PERDIDAS'!Y13","v":8.3702451385290715}]
[]
["FLUJO FINANCIERO",{"$f":"B12+B13","v":-15000},{"$f":"C12-C14-C15","v":21497.801065599691},12328.711608646079,12328.711608646081,12328.711608646081,12328.711608646079,12328.711608646081,6178.7116086460801,12328.711608646081,12328.711608646081,12328.711608646079,12328.711608646079,6178.7116086460801,27994.939484142742,15752.51160864608,15702.51160864608,15702.511608646078,15702.51160864608,15702.511608646078,9552.5116086460803,15702.511608646078,15702.511608646078,15702.511608646078,15702.511608646078,9552.5116086460803]
["Aporte propio",{"$f":"FINANCIAMIENTO!D5","v":15000}]
["Saldo acumulado",0,{"$f":"C17","v":21497.801065599691},{"$f":"C19+D17","v":33826.512674245772},46155.224282891853,58483.935891537934,70812.647500184015,83141.359108830104,89320.070717476177,101648.78232612225,113977.49393476834,126306.20554341441,138634.91715206049,144813.62876070658,172808.56824484933,188561.07985349541,204263.59146214148,219966.10307078756,235668.61467943364,251371.12628807971,260923.63789672579,276626.14950537187,292328.66111401794,308031.17272266402,323733.6843313101,333286.19593995617]
["TIRF",{"$f":"IRR(B17:Z17)","v":1.146141947174764}]
["VANF",{"$f":"NPV(Z2,B17:Z17)","v":148607.59950228262}]
["TIR ",{"$f":"IRR(B12:Z12)","v":0.29145307423209066}]
["VAN ",{"$f":"NPV(Z2,B12:Z12)","v":131829.14664603362}]

{"sheet":"PUNTO DE EQUILIBRIO","index":17,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Linea de Comercializacion","SERVICIOS AL MES (pacientes)","% Participacion","Precio Venta ","Costo variable unitario","Margen","Margen Ponderado",null,"PUNTO DE EQUILIBRIO en Unidades",null,"PUNTO DE EQUILIBRIO en soles"]
["PROGRAMA DE REHABILITACION CARDIACA",{"$f":"'INGRESO POR VENTAS'!B4","v":25.710974478762939},{"$f":"+B5/$B$14","v":4.878048780487805E-2},60,{"$f":"C26","v":3.3310416666666667},{"$f":"D5-E5","v":56.668958333333336},{"$f":"C5*F5","v":2.7643394308943092},null,{"$f":"($B$18/$G$14)*C5","v":9.4113356213969421},null,{"$f":"I5*D5","v":564.68013728381652}]
["PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIMARIA Y SECUNDARIA.",{"$f":"'INGRESO POR VENTAS'!B5","v":38.566461718144403},7.3170731707317069E-2,60,{"$f":"D26","v":2.8466666666666667},{"$f":"D6-E6","v":57.153333333333336},{"$f":"C6*F6","v":4.1819512195121948},null,14.117003432095412,null,{"$f":"I6*D6","v":847.02020592572478}]
["FISIOTERARIA EN SALUD OCUPACIONAL",{"$f":"'INGRESO POR VENTAS'!B6","v":64.277436196907345},0.12195121951219513,60,{"$f":"E26","v":2.8466666666666667},57.153333333333336,6.9699186991869926,null,23.528339053492356,null,1411.7003432095414]
["REHABILITACION DEPORTIVA.",{"$f":"'INGRESO POR VENTAS'!B7","v":102.84389791505176},0.1951219512195122,60,{"$f":"F26","v":2.8466666666666667},57.153333333333336,11.151869918699187,null,37.645342485587769,null,2258.7205491352661]
["PROGRAMA DE FISIOTERAPIA",{"$f":"'INGRESO POR VENTAS'!B8","v":89.988410675670281},0.17073170731707318,60,{"$f":"G26","v":2.8466666666666667},57.153333333333336,9.7578861788617903,null,32.939674674889297,null,1976.3804804933577]
["TRATAMIENTO DE FISIOTERAPIA INTEGRAL.",{"$f":"'INGRESO POR VENTAS'!B9","v":77.132923436288806},0.14634146341463414,80,{"$f":"H26","v":24.846666666666664},55.153333333333336,8.0712195121951211,null,28.234006864190825,null,2258.7205491352661]
["REHABILITACIÓN CON HIDROTERAPIA",{"$f":"'INGRESO POR VENTAS'!B10","v":51.421948957525878},9.7560975609756101E-2,80,{"$f":"I26","v":24.846666666666664},55.153333333333336,5.3808130081300813,null,18.822671242793884,null,1505.8136994235108]
["REHABILITACIÓN PACIENTES QUEMADOS",{"$f":"'INGRESO POR VENTAS'!B11","v":38.566461718144403},7.3170731707317069E-2,60,{"$f":"J26","v":2.8466666666666667},57.153333333333336,4.1819512195121948,null,14.117003432095412,null,847.02020592572478]
["TERAPIA PSICOMOTRIZ EN NIÑOS",{"$f":"'INGRESO POR VENTAS'!B12","v":38.566461718144403},7.3170731707317069E-2,60,{"$f":"K26","v":2.8466666666666667},57.153333333333336,4.1819512195121948,null,14.117003432095412,null,847.02020592572478]
[null,{"$f":"SUM(B5:B13)","v":527.07497681464019},1,null,null,null,{"$f":"SUM(G5:G13)","v":56.641900406504064},null,{"$f":"SUM(I5:I13)","v":192.93238023863728},null,{"$f":"SUM(K5:K13)","v":12517.076376457931}]
[]
[]
["Nuevos Soles","MES"]
["COSTOS FIJOS TOTALES",{"$f":"'COSTOS FIJOS'!F13","v":10928.056666666667}]
["MARGEN PONDERADO",{"$f":"G14","v":56.641900406504064}]
[]
[]
["PUNTO DE EQUILIBRIO",{"$f":"B18/G14","v":192.93238023863731}]
[]
[]
[null,null,"PROGRAMA DE REHABILITACION CARDIACA","PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIMARIA Y SECUNDARIA.","FISIOTERARIA EN SALUD OCUPACIONAL","REHABILITACION DEPORTIVA.","PROGRAMA DE FISIOTERAPIA","TRATAMIENTO DE FISIOTERAPIA INTEGRAL.","REHABILITACIÓN CON HIDROTERAPIA","REHABILITACIÓN PACIENTES QUEMADOS","Terapia psicomotriz para niños"]
["costo variable unitario",null,{"$f":"SUM(C27:C35)","v":3.3310416666666667},2.8466666666666667,2.8466666666666667,2.8466666666666667,2.8466666666666667,24.846666666666664,24.846666666666664,2.8466666666666667,2.8466666666666667]
["Tarro gel conductor x galón",null,{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$23","v":0.3}]
["Toallas Secantes 100mt x 6 und",null,{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3},{"$f":"'COSTOS VARIABLES'!$E$24","v":0.3}]
["Baja lenguas paquete x100",null,{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66},{"$f":"'COSTOS VARIABLES'!$E$25","v":0.66}]
["Papel higiénico 170 mts x 4 und",null,{"$f":"'COSTOS VARIABLES'!E26","v":0.484375},{"$f":"'COSTOS VARIABLES'!F26","v":0},{"$f":"'COSTOS VARIABLES'!G26","v":0},{"$f":"'COSTOS VARIABLES'!H26","v":0},{"$f":"'COSTOS VARIABLES'!I26","v":0},{"$f":"'COSTOS VARIABLES'!J26","v":0},{"$f":"'COSTOS VARIABLES'!K26","v":0},{"$f":"'COSTOS VARIABLES'!L26","v":0},{"$f":"'COSTOS VARIABLES'!M26","v":0}]
["Guantes caja",null,{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5},{"$f":"'COSTOS VARIABLES'!$E$27","v":0.5}]
["Tapabocas caja x 50 und",null,{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666},{"$f":"'COSTOS VARIABLES'!$E$28","v":0.44666666666666666}]
["Parafina",null,0,0,0,0,0,{"$f":"'COSTOS VARIABLES'!$E$29","v":22},{"$f":"'COSTOS VARIABLES'!$E$29","v":22},0,0]
["Jabón antibacterial",null,{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4},{"$f":"'COSTOS VARIABLES'!$E$30","v":0.4}]
["Talco",null,{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24},{"$f":"'COSTOS VARIABLES'!$E$31","v":0.24}]

{"sheet":"PRECIO DE EQUILIBRIO","index":18,"n_rows":251,"n_cols":9,"rows_kept":251,"cut":false,"hidden":false,"merged":[[139,2,139,11],[166,2,166,11],[193,2,193,11],[225,2,225,11],[1,2,1,11],[27,2,27,11],[54,2,54,11],[83,2,83,11],[111,2,111,11]]}
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A5","v":"PROGRAMA DE REHABILITACION CARDIACA"}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G5/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":533.33058618995915}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D5","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E5","v":3.3310416666666667}]
[null,null,"P.E.:",{"$f":"D4/(D5-D6)","v":9.4113356213969421}]
[null,null,"Utilidades:",{"$f":"D5*D7 - (D6*D7) - D4","v":0}]
[null,null,"INGRESOS",{"$f":"D7*D5","v":564.68013728381652}]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$4","v":533.33058618995915},{"$f":"C12*$D$6","v":0},{"$f":"D12+E12","v":533.33058618995915},null,{"$f":"C12*$D$31","v":0},{"$f":"H12-F12","v":-533.33058618995915}]
[null,null,{"$f":"$C$22/10+C12","v":0.94113356213969424},{"$f":"$D$4","v":533.33058618995915},{"$f":"C13*$D$6","v":3.1349551093857442},{"$f":"D13+E13","v":536.46554129934486},{"$f":"F13/C13","v":570.020625},{"$f":"C13*$D$5","v":56.468013728381656},{"$f":"H13-F13","v":-479.9975275709632}]
[null,null,{"$f":"$C$22/10+C13","v":1.8822671242793885},533.33058618995915,6.2699102187714884,{"$f":"D14+E14","v":539.60049640873069},{"$f":"F14/C14","v":286.6758333333334},{"$f":"C14*$D$5","v":112.93602745676331},-426.66446895196736]
[null,null,2.8234006864190828,533.33058618995915,9.4048653281572321,542.73545151811641,{"$f":"F15/C15","v":192.22756944444447},169.40404118514496,-373.33141033297147]
[null,null,3.7645342485587769,533.33058618995915,12.539820437542977,{"$f":"D16+E16","v":545.87040662750212},145.00343750000002,225.87205491352663,-319.99835171397547]
[null,null,4.7056678106984711,533.33058618995915,15.67477554692872,549.00536173688783,116.66895833333334,282.34006864190826,-266.66529309497957]
[null,null,5.6468013728381656,533.33058618995915,18.809730656314464,552.14031684627366,97.779305555555567,338.80808237028992,-213.33223447598374]
[null,null,6.5879349349778602,533.33058618995915,21.944685765700211,555.27527195565938,{"$f":"F19/C19","v":84.286696428571432},395.27609609867159,-159.99917585698779]
[null,null,7.5290684971175548,533.33058618995915,25.079640875085953,{"$f":"D20+E20","v":558.41022706504509},74.167239583333327,451.74410982705331,-106.66611723799178]
[null,null,8.4702020592572485,533.33058618995915,28.214595984471696,{"$f":"D21+E21","v":561.54518217443081},66.296550925925928,508.21212355543491,{"$f":"H21-F21","v":-53.333058618995892}]
[null,null,{"$f":"D7","v":9.4113356213969421},533.33058618995915,31.349551093857439,{"$f":"D22+E22","v":564.68013728381663},{"$f":"F22/C22","v":60.000000000000014},564.68013728381652,{"$f":"H22-F22","v":0}]
[null,null,{"$f":"C22/10+C22","v":10.352469183536636},533.33058618995915,34.484506203243178,{"$f":"D23+E23","v":567.81509239320235},{"$f":"F23/C23","v":54.848276515151525},621.14815101219813,{"$f":"H23-F23","v":53.333058618995778}]
[null,null,{"$f":"C23/10+C23","v":11.3877161018903},533.33058618995915,37.932956823567501,{"$f":"D24+E24","v":571.2635430135266},50.164891528925622,683.26296611341797,{"$f":"H24-F24","v":111.99942309989137}]
[null,null,12.52648771207933,533.33058618995915,41.726252505924251,{"$f":"D25+E25","v":575.05683869588336},45.907268814174806,751.58926272475981,{"$f":"H25-F25","v":176.53242402887645}]
[null,null,13.779136483287264,533.33058618995915,45.898877756516683,{"$f":"D26+E26","v":579.22946394647579},42.036702709855881,826.74818899723584,{"$f":"H26-F26","v":247.51872505076005}]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A6","v":"PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIMARIA Y SECUNDARIA."}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G6/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":806.83380282235976}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D6","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E6","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D30/(D31-D32)","v":14.117003432095411}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D33*D31","v":847.02020592572467}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$30","v":806.83380282235976},{"$f":"C39*$D$32","v":0},{"$f":"D39+E39","v":806.83380282235976},null,{"$f":"C39*$D$31","v":0},{"$f":"H39-F39","v":-806.83380282235976}]
[null,null,{"$f":"$D$33/10+C39","v":1.411700343209541},{"$f":"$D$30","v":806.83380282235976},4.0186403103364929,{"$f":"D40+E40","v":810.85244313269629},{"$f":"F40/C40","v":574.38000000000011},84.702020592572453,{"$f":"H40-F40","v":-726.15042254012383}]
[null,null,2.8234006864190819,{"$f":"$D$30","v":806.83380282235976},8.0372806206729859,814.87108344303272,{"$f":"F41/C41","v":288.61333333333334},169.40404118514491,-645.46704225788778]
[null,null,4.2351010296286233,806.83380282235976,12.055920931009481,818.88972375336925,193.35777777777778,254.1060617777174,-564.78366197565185]
[null,null,5.6468013728381639,806.83380282235976,16.074561241345972,822.90836406370568,145.73000000000002,338.80808237028981,-484.10028169341587]
[null,null,7.0585017160477044,806.83380282235976,20.093201551682466,826.92700437404221,117.15333333333335,423.51010296286228,-403.41690141117994]
[null,null,8.4702020592572449,806.83380282235976,24.111841862018956,830.94564468437875,98.102222222222252,508.21212355543469,-322.73352112894406]
[null,null,9.8819024024667854,806.83380282235976,28.13048217235545,834.96428499471517,84.494285714285738,592.91414414800715,-242.05014084670802]
[null,null,11.293602745676326,806.83380282235976,32.149122482691944,838.98292530505171,74.288333333333355,677.61616474057951,-161.3667605644722]
[null,null,12.705303088885866,806.83380282235976,36.16776279302843,{"$f":"D48+E48","v":843.00156561538824},66.350370370370399,762.31818533315197,{"$f":"H48-F48","v":-80.683380282236271}]
[null,null,{"$f":"D33","v":14.117003432095411},806.83380282235976,40.186403103364938,{"$f":"D49+E49","v":847.02020592572467},{"$f":"F49/C49","v":60},847.02020592572467,{"$f":"H49-F49","v":0}]
[null,null,{"$f":"$C$49/10+C49","v":15.528703775304951},806.83380282235976,44.205043413701425,{"$f":"D50+E50","v":851.0388462360612},54.804242424242432,931.72222651829702,{"$f":"H50-F50","v":80.683380282235817}]
[null,null,{"$f":"$C$49/10+C50","v":16.940404118514493},806.83380282235976,48.223683724037926,{"$f":"D51+E51","v":855.05748654639774},50.474444444444451,1016.4242471108696,{"$f":"H51-F51","v":161.36676056447186}]
[null,null,{"$f":"$C$49/10+C51","v":18.352104461724036},806.83380282235976,52.24232403437442,{"$f":"D52+E52","v":859.07612685673416},46.810769230769232,1101.1262677034422,{"$f":"H52-F52","v":242.05014084670802}]
[null,null,{"$f":"$C$49/10+C52","v":19.763804804933578},806.83380282235976,56.260964344710921,863.0947671670707,43.670476190476187,1185.8282882960148,322.73352112894406]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A7","v":"FISIOTERARIA EN SALUD OCUPACIONAL"}]
[]
[]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G7/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":1344.7230047039332}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D7","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E7","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D59/(D60-D61)","v":23.528339053492356}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D62*D60","v":1411.7003432095414}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$59","v":1344.7230047039332},{"$f":"C68*$D$61","v":0},{"$f":"D68+E68","v":1344.7230047039332},null,{"$f":"C68*$D$60","v":0},{"$f":"H68-F68","v":-1344.7230047039332}]
[null,null,{"$f":"$D$62/10+C68","v":2.3528339053492355},{"$f":"$D$59","v":1344.7230047039332},{"$f":"C69*$D$61","v":6.6977338505608239},{"$f":"D69+E69","v":1351.4207385544939},{"$f":"F69/C69","v":574.38},{"$f":"C69*$D$60","v":141.17003432095413},{"$f":"H69-F69","v":-1210.2507042335399}]
[null,null,{"$f":"$D$62/10+C69","v":4.7056678106984711},1344.7230047039332,13.395467701121648,1358.1184724050547,{"$f":"F70/C70","v":288.61333333333334},{"$f":"C70*$D$60","v":282.34006864190826},-1075.7784037631463]
[null,null,7.0585017160477062,1344.7230047039332,20.093201551682469,1364.8162062556157,{"$f":"F71/C71","v":193.35777777777781},423.51010296286239,-941.30610329275328]
[null,null,9.4113356213969421,1344.7230047039332,{"$f":"C72*$D$61","v":26.790935402243296},1371.5139401061765,145.73000000000002,564.68013728381652,-806.83380282235998]
[null,null,11.764169526746178,1344.7230047039332,33.488669252804122,1378.2116739567373,117.15333333333334,705.85017160477071,-672.36150235196658]
[null,null,14.117003432095414,1344.7230047039332,40.186403103364945,1384.9094078072981,98.102222222222224,847.02020592572489,-537.88920188157317]
[null,null,16.469837337444648,1344.7230047039332,46.884136953925768,1391.6071416578588,84.494285714285724,988.19024024667885,-403.41690141117999]
[null,null,18.822671242793884,1344.7230047039332,53.581870804486591,1398.3048755084199,74.288333333333341,1129.360274567633,-268.94460094078681]
[null,null,21.17550514814312,1344.7230047039332,60.279604655047414,1405.0026093589806,{"$f":"F77/C77","v":66.350370370370371},1270.5303088885871,{"$f":"H77-F77","v":-134.47230047039352}]
[null,null,{"$f":"$D$62/10+C77","v":23.528339053492356},1344.7230047039332,66.977338505608245,1411.7003432095414,{"$f":"F78/C78","v":60},1411.7003432095414,{"$f":"H78-F78","v":0}]
[null,null,{"$f":"$C$78/10+C78","v":25.881172958841592},1344.7230047039332,73.675072356169068,1418.3980770601022,{"$f":"F79/C79","v":54.804242424242425},1552.8703775304955,{"$f":"H79-F79","v":134.47230047039329}]
[null,null,{"$f":"$C$78/10+C79","v":28.234006864190828},1344.7230047039332,80.372806206729891,1425.095810910663,50.474444444444444,1694.0404118514498,{"$f":"H80-F80","v":268.94460094078681}]
[null,null,30.586840769540064,1344.7230047039332,87.070540057290714,1431.793544761224,46.810769230769232,1835.2104461724039,{"$f":"H81-F81","v":403.41690141117988}]
[null,null,32.939674674889297,1344.7230047039332,93.768273907851537,1438.4912786117848,43.670476190476194,1976.3804804933577,{"$f":"H82-F82","v":537.88920188157294}]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A8","v":"REHABILITACION DEPORTIVA."}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G8/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":2151.5568075262931}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D8","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E8","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D86/(D87-D88)","v":37.645342485587769}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D89*D87","v":2258.7205491352661}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$86","v":2151.5568075262931},{"$f":"C95*$D$61","v":0},{"$f":"D95+E95","v":2151.5568075262931},null,{"$f":"C95*$D$87","v":0},{"$f":"H95-F95","v":-2151.5568075262931}]
[null,null,{"$f":"$D$89/10+C95","v":3.7645342485587769},{"$f":"$D$86","v":2151.5568075262931},{"$f":"C96*$D$88","v":10.716374160897319},{"$f":"D96+E96","v":2162.2731816871906},{"$f":"F96/C96","v":574.38000000000011},225.87205491352663,{"$f":"H96-F96","v":-1936.4011267736639}]
[null,null,{"$f":"$D$89/10+C96","v":7.5290684971175539},2151.5568075262931,{"$f":"C97*$D$88","v":21.432748321794637},{"$f":"D97+E97","v":2172.989555848088},{"$f":"F97/C97","v":288.6133333333334},451.74410982705325,-1721.2454460210347]
[null,null,{"$f":"$D$89/10+C97","v":11.293602745676331},2151.5568075262931,{"$f":"C98*$D$88","v":32.149122482691958},2183.705930008985,{"$f":"F98/C98","v":193.35777777777778},677.61616474057985,-1506.0897652684052]
[null,null,15.058136994235108,2151.5568075262931,42.865496643589275,2194.4223041698824,{"$f":"F99/C99","v":145.73000000000002},903.4882196541065,-1290.9340845157758]
[null,null,{"$f":"$D$89/10+C99","v":18.822671242793884},2151.5568075262931,{"$f":"C100*$D$88","v":53.581870804486591},2205.1386783307798,117.15333333333335,1129.360274567633,-1075.7784037631468]
[null,null,22.587205491352663,2151.5568075262931,64.298244965383915,2215.8550524916773,98.102222222222238,1355.2323294811597,-860.62272301051757]
[null,null,26.351739739911441,2151.5568075262931,75.014619126281232,2226.5714266525742,84.494285714285709,{"$f":"C102*$D$87","v":1581.1043843946863},-645.4670422578879]
[null,null,30.116273988470219,2151.5568075262931,85.730993287178563,2237.2878008134717,74.288333333333327,{"$f":"C103*$D$87","v":1806.9764393082132},-430.31136150525845]
[null,null,{"$f":"$D$89/10+C103","v":33.880808237028994},2151.5568075262931,96.447367448075866,2248.0041749743691,{"$f":"F104/C104","v":66.350370370370371},2032.8484942217397,{"$f":"H104-F104","v":-215.15568075262945}]
[null,null,{"$f":"$D$89/10+C104","v":37.645342485587769},2151.5568075262931,107.16374160897318,2258.7205491352665,{"$f":"F105/C105","v":60.000000000000014},2258.7205491352661,{"$f":"H105-F105","v":0}]
[null,null,41.409876734146543,2151.5568075262931,117.8801157698705,2269.4369232961635,{"$f":"F106/C106","v":54.804242424242432},2484.5926040487925,{"$f":"H106-F106","v":215.155680752629}]
[null,null,45.174410982705318,2151.5568075262931,128.5964899307678,2280.1532974570609,50.474444444444451,2710.4646589623189,{"$f":"H107-F107","v":430.31136150525799}]
[null,null,48.938945231264093,2151.5568075262931,139.31286409166512,2290.8696716179584,46.810769230769246,2936.3367138758454,{"$f":"H108-F108","v":645.46704225788699}]
[null,null,52.703479479822867,2151.5568075262931,150.02923825256244,2301.5860457788558,43.670476190476208,3162.2087687893722,{"$f":"H109-F109","v":860.62272301051644}]
[]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A9","v":"PROGRAMA DE FISIOTERAPIA"}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G9/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":1882.6122065855066}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D9","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E9","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D114/(D115-D116)","v":32.939674674889304}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D117*D115","v":1976.3804804933582}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$114","v":1882.6122065855066},{"$f":"C123*$D$115","v":0},{"$f":"D123+E123","v":1882.6122065855066},null,{"$f":"C123*$D$115","v":0},{"$f":"H123-F123","v":-1882.6122065855066}]
[null,null,{"$f":"$D$117/10+C123","v":3.2939674674889305},{"$f":"$D$114","v":1882.6122065855066},{"$f":"C124*$D$116","v":9.3768273907851558},{"$f":"D124+E124","v":1891.9890339762917},{"$f":"F124/C124","v":574.37999999999988},{"$f":"C124*$D$115","v":197.63804804933582},{"$f":"H124-F124","v":-1694.3509859269559}]
[null,null,{"$f":"$D$117/10+C124","v":6.5879349349778611},1882.6122065855066,{"$f":"C125*$D$116","v":18.753654781570312},{"$f":"D125+E125","v":1901.3658613670768},{"$f":"F125/C125","v":288.61333333333329},{"$f":"C125*$D$115","v":395.27609609867164},{"$f":"H125-F125","v":-1506.0897652684052}]
[null,null,{"$f":"$D$117/10+C125","v":9.8819024024667925},1882.6122065855066,28.130482172355471,1910.742688757862,{"$f":"F126/C126","v":193.35777777777773},{"$f":"C126*$D$115","v":592.91414414800761},-1317.8285446098544]
[null,null,13.175869869955722,1882.6122065855066,37.507309563140623,1920.1195161486471,{"$f":"F127/C127","v":145.72999999999999},790.55219219734329,-1129.5673239513039]
[null,null,16.469837337444652,1882.6122065855066,46.884136953925776,1929.4963435394322,117.15333333333332,{"$f":"C128*$D$115","v":988.19024024667908},-941.30610329275316]
[null,null,19.763804804933581,1882.6122065855066,56.260964344710928,1938.8731709302174,98.10222222222221,1185.828288296015,-753.04488263420239]
[null,null,23.057772272422511,1882.6122065855066,65.63779173549608,1948.2499983210027,84.494285714285724,1383.4663363453506,-564.78366197565219]
[null,null,26.351739739911441,1882.6122065855066,75.014619126281232,1957.6268257117879,74.288333333333341,1581.1043843946863,-376.52244131710154]
[null,null,{"$f":"$D$117/10+C131","v":29.64570720740037},1882.6122065855066,84.391446517066385,1967.003653102573,{"$f":"F132/C132","v":66.350370370370371},1778.7424324440221,{"$f":"H132-F132","v":-188.26122065855088}]
[null,null,32.939674674889304,1882.6122065855066,93.768273907851551,1976.3804804933582,{"$f":"F133/C133","v":60},1976.3804804933582,{"$f":"H133-F133","v":0}]
[null,null,36.233642142378237,1882.6122065855066,103.14510129863672,1985.7573078841433,{"$f":"F134/C134","v":54.804242424242418},2174.0185285426942,{"$f":"H134-F134","v":188.26122065855088}]
[null,null,39.52760960986717,1882.6122065855066,112.52192868942188,1995.1341352749284,50.474444444444437,2371.6565765920304,{"$f":"H135-F135","v":376.52244131710199}]
[null,null,42.821577077356103,1882.6122065855066,121.89875608020704,2004.5109626657136,46.810769230769218,2569.2946246413662,{"$f":"H136-F136","v":564.78366197565265}]
[null,null,46.115544544845037,1882.6122065855066,131.27558347099222,2013.8877900564987,43.67047619047618,2766.932672690702,{"$f":"H137-F137","v":753.0448826342033}]
[]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A10","v":"TRATAMIENTO DE FISIOTERAPIA INTEGRAL."}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G10/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":1557.199591916338}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D10","v":80}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E10","v":24.846666666666664}]
[null,null,"P.E.:",{"$f":"D142/(D143-D144)","v":28.234006864190825}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D145*D143","v":2258.7205491352661}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$142","v":1557.199591916338},{"$f":"C151*$D$144","v":0},{"$f":"D151+E151","v":1557.199591916338},null,{"$f":"C151*$D$143","v":0},{"$f":"H151-F151","v":-1557.199591916338}]
[null,null,{"$f":"$D$145/10+C151","v":2.8234006864190824},{"$f":"$D$142","v":1557.199591916338},{"$f":"C152*$D$144","v":70.152095721892792},{"$f":"D152+E152","v":1627.3516876382307},{"$f":"F152/C152","v":576.38},{"$f":"C152*$D$143","v":225.8720549135266},{"$f":"H152-F152","v":-1401.4796327247041}]
[null,null,{"$f":"$D$145/10+C152","v":5.6468013728381647},1557.199591916338,140.30419144378558,{"$f":"D153+E153","v":1697.5037833601236},{"$f":"F153/C153","v":300.61333333333334},451.74410982705319,{"$f":"H153-F153","v":-1245.7596735330703}]
[null,null,8.4702020592572467,1557.199591916338,210.45628716567836,1767.6558790820163,{"$f":"F154/C154","v":208.69111111111113},677.61616474057973,{"$f":"H154-F154","v":-1090.0397143414366}]
[null,null,11.293602745676329,1557.199591916338,280.60838288757117,1837.8079748039092,{"$f":"F155/C155","v":162.73000000000002},903.48821965410639,-934.31975514980286]
[null,null,14.117003432095412,1557.199591916338,350.76047860946397,1907.9600705258019,135.15333333333334,1129.360274567633,-778.5997959581689]
[null,null,16.940404118514493,1557.199591916338,420.91257433135672,1978.1121662476949,116.76888888888891,1355.2323294811595,-622.87983676653539]
[null,null,19.763804804933574,1557.199591916338,491.06467005324947,2048.2642619695876,103.63714285714288,1581.1043843946859,-467.15987757490166]
[null,null,22.587205491352655,1557.199591916338,561.21676577514222,2118.4163576914802,93.788333333333341,1806.9764393082123,-311.43991838326792]
[null,null,25.410606177771736,1557.199591916338,631.36886149703503,2188.5684534133729,{"$f":"F160/C160","v":86.128148148148156},2032.848494221739,{"$f":"H160-F160","v":-155.71995919163396}]
[null,null,28.234006864190818,1557.199591916338,701.52095721892772,2258.7205491352656,{"$f":"F161/C161","v":80.000000000000014},2258.7205491352652,{"$f":"H161-F161","v":0}]
[null,null,31.057407550609899,1557.199591916338,771.67305294082053,2328.8726448571588,{"$f":"F162/C162","v":74.986060606060633},2484.5926040487921,{"$f":"H162-F162","v":155.71995919163328}]
[null,null,33.88080823702898,1557.199591916338,841.82514866271333,2399.0247405790515,70.807777777777801,2710.4646589623185,{"$f":"H163-F163","v":311.43991838326701}]
[null,null,36.704208923448064,1557.199591916338,911.97724438460614,2469.1768363009442,67.272307692307706,2936.3367138758449,{"$f":"H164-F164","v":467.15987757490075}]
[null,null,39.527609609867149,1557.199591916338,982.12934010649894,2539.3289320228369,64.241904761904763,3162.2087687893718,{"$f":"H165-F165","v":622.87983676653494}]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A11","v":"REHABILITACIÓN CON HIDROTERAPIA"}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G11/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":1038.1330612775587}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D12","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E12","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D169/(D170-D171)","v":18.163998505964514}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D172*D170","v":1089.8399103578708}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$169","v":1038.1330612775587},{"$f":"C178*$D$171","v":0},{"$f":"D178+E178","v":1038.1330612775587},null,{"$f":"C178*$D$170","v":0},{"$f":"H178-F178","v":-1038.1330612775587}]
[null,null,{"$f":"$D$172/10+C178","v":1.8163998505964514},{"$f":"$D$169","v":1038.1330612775587},{"$f":"C179*$D$171","v":5.1706849080312312},{"$f":"D179+E179","v":1043.3037461855899},{"$f":"F179/C179","v":574.38000000000011},{"$f":"C179*$D$170","v":108.98399103578708},{"$f":"H179-F179","v":-934.31975514980286}]
[null,null,{"$f":"$D$172/10+C179","v":3.6327997011929027},1038.1330612775587,10.341369816062462,{"$f":"D180+E180","v":1048.4744310936212},{"$f":"F180/C180","v":288.6133333333334},217.96798207157417,{"$f":"H180-F180","v":-830.50644902204704}]
[null,null,5.4491995517893539,1038.1330612775587,15.512054724093694,1053.6451160016525,{"$f":"F181/C181","v":193.35777777777784},326.95197310736125,{"$f":"H181-F181","v":-726.69314289429121}]
[null,null,7.2655994023858055,1038.1330612775587,20.682739632124925,1058.8158009096835,{"$f":"F182/C182","v":145.73000000000002},435.93596414314834,-622.87983676653516]
[null,null,9.0819992529822571,1038.1330612775587,25.853424540156158,1063.9864858177148,117.15333333333334,544.91995517893542,-519.06653063877934]
[null,null,10.898399103578708,1038.1330612775587,31.024109448187389,1069.157170725746,98.102222222222238,653.90394621472251,-415.25322451102352]
[null,null,12.714798954175158,1038.1330612775587,36.194794356218615,1074.3278556337773,84.494285714285738,762.88793725050948,-311.43991838326781]
[null,null,14.531198804771609,1038.1330612775587,41.365479264249849,1079.4985405418086,74.288333333333355,871.87192828629657,-207.62661225551199]
[null,null,16.34759865536806,1038.1330612775587,46.536164172281076,1084.6692254498398,{"$f":"F187/C187","v":66.350370370370399},980.85591932208354,{"$f":"H187-F187","v":-103.81330612775628}]
[null,null,18.163998505964511,1038.1330612775587,51.70684908031231,1089.8399103578711,{"$f":"F188/C188","v":60.000000000000021},1089.8399103578706,{"$f":"H188-F188","v":0}]
[null,null,19.980398356560961,1038.1330612775587,56.877533988343536,1095.0105952659021,{"$f":"F189/C189","v":54.804242424242439},1198.8239013936577,{"$f":"H189-F189","v":103.8133061277556}]
[null,null,21.796798207157412,1038.1330612775587,62.048218896374763,1100.1812801739334,50.474444444444458,1307.8078924294448,{"$f":"H190-F190","v":207.62661225551142}]
[null,null,23.613198057753863,1038.1330612775587,67.218903804405997,1105.3519650819646,46.810769230769246,1416.7918834652319,{"$f":"H191-F191","v":311.43991838326724}]
[null,null,25.429597908350313,1038.1330612775587,72.389588712437231,1110.5226499899959,43.670476190476208,1525.7758745010187,{"$f":"H192-F192","v":415.25322451102284}]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A12","v":"REHABILITACIÓN PACIENTES QUEMADOS"}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G12/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":806.83380282235976}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D12","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E12","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D196/(D197-D198)","v":14.117003432095411}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D199*D197","v":847.02020592572467}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$196","v":806.83380282235976},{"$f":"C205*$D$198","v":0},{"$f":"D205+E205","v":806.83380282235976},null,{"$f":"C205*$D$197","v":0},{"$f":"H205-F205","v":-806.83380282235976}]
[null,null,{"$f":"$D$199/10+C205","v":1.411700343209541},{"$f":"$D$196","v":806.83380282235976},{"$f":"C206*$D$198","v":4.0186403103364929},{"$f":"D206+E206","v":810.85244313269629},{"$f":"F206/C206","v":574.38000000000011},{"$f":"C206*$D$197","v":84.702020592572453},{"$f":"H206-F206","v":-726.15042254012383}]
[null,null,{"$f":"$D$199/10+C206","v":2.8234006864190819},806.83380282235976,8.0372806206729859,{"$f":"D207+E207","v":814.87108344303272},{"$f":"F207/C207","v":288.61333333333334},169.40404118514491,{"$f":"H207-F207","v":-645.46704225788778}]
[null,null,4.2351010296286233,806.83380282235976,12.055920931009481,818.88972375336925,{"$f":"F208/C208","v":193.35777777777778},254.1060617777174,{"$f":"H208-F208","v":-564.78366197565185}]
[null,null,5.6468013728381639,806.83380282235976,16.074561241345972,822.90836406370568,{"$f":"F209/C209","v":145.73000000000002},338.80808237028981,-484.10028169341587]
[null,null,7.0585017160477044,806.83380282235976,20.093201551682466,826.92700437404221,117.15333333333335,423.51010296286228,-403.41690141117994]
[null,null,8.4702020592572449,806.83380282235976,24.111841862018956,830.94564468437875,98.102222222222252,508.21212355543469,-322.73352112894406]
[null,null,9.8819024024667854,806.83380282235976,28.13048217235545,834.96428499471517,84.494285714285738,592.91414414800715,-242.05014084670802]
[null,null,11.293602745676326,806.83380282235976,32.149122482691944,838.98292530505171,74.288333333333355,677.61616474057951,-161.3667605644722]
[null,null,12.705303088885866,806.83380282235976,36.16776279302843,843.00156561538824,{"$f":"F214/C214","v":66.350370370370399},762.31818533315197,{"$f":"H214-F214","v":-80.683380282236271}]
[null,null,14.117003432095407,806.83380282235976,40.186403103364924,847.02020592572467,{"$f":"F215/C215","v":60.000000000000014},847.02020592572444,{"$f":"H215-F215","v":0}]
[null,null,15.528703775304947,806.83380282235976,44.205043413701418,851.0388462360612,{"$f":"F216/C216","v":54.804242424242446},931.72222651829679,{"$f":"H216-F216","v":80.683380282235589}]
[null,null,16.94040411851449,806.83380282235976,48.223683724037912,855.05748654639763,50.474444444444451,1016.4242471108694,{"$f":"H217-F217","v":161.36676056447175}]
[null,null,18.352104461724032,806.83380282235976,52.242324034374413,859.07612685673416,46.810769230769239,1101.126267703442,{"$f":"H218-F218","v":242.05014084670779}]
[null,null,19.763804804933574,806.83380282235976,56.260964344710906,863.0947671670707,43.670476190476194,1185.8282882960145,{"$f":"H219-F219","v":322.73352112894383}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"'PUNTO DE EQUILIBRIO'!A13","v":"TERAPIA PSICOMOTRIZ EN NIÑOS"}]
[]
[null,null,"Costos fijos:",{"$f":"+('PUNTO DE EQUILIBRIO'!G13/'PUNTO DE EQUILIBRIO'!G14)*'PUNTO DE EQUILIBRIO'!B18","v":806.83380282235976}]
[null,null,"Precio:",{"$f":"'PUNTO DE EQUILIBRIO'!D13","v":60}]
[null,null,"Costos variables:",{"$f":"'PUNTO DE EQUILIBRIO'!E13","v":2.8466666666666667}]
[null,null,"P.E.:",{"$f":"D228/(D229-D230)","v":14.117003432095411}]
[null,null,"Utilidades:",0]
[null,null,"INGRESOS",{"$f":"D231*D229","v":847.02020592572467}]
[]
[]
[null,null,"UNIDADES","COSTES FIJOS","COSTES VARIABLES","COSTES TOTALES","COSTES MEDIOS","INGRESOS","BENEFICIOS"]
[null,null,0,{"$f":"$D$196","v":806.83380282235976},{"$f":"C237*$D$198","v":0},{"$f":"D237+E237","v":806.83380282235976},null,{"$f":"C237*$D$197","v":0},{"$f":"H237-F237","v":-806.83380282235976}]
[null,null,{"$f":"$D$199/10+C237","v":1.411700343209541},{"$f":"$D$196","v":806.83380282235976},{"$f":"C238*$D$198","v":4.0186403103364929},{"$f":"D238+E238","v":810.85244313269629},{"$f":"F238/C238","v":574.38000000000011},{"$f":"C238*$D$197","v":84.702020592572453},{"$f":"H238-F238","v":-726.15042254012383}]
[null,null,{"$f":"$D$199/10+C238","v":2.8234006864190819},806.83380282235976,8.0372806206729859,{"$f":"D239+E239","v":814.87108344303272},{"$f":"F239/C239","v":288.61333333333334},169.40404118514491,{"$f":"H239-F239","v":-645.46704225788778}]
[null,null,4.2351010296286233,806.83380282235976,12.055920931009481,818.88972375336925,{"$f":"F240/C240","v":193.35777777777778},254.1060617777174,{"$f":"H240-F240","v":-564.78366197565185}]
[null,null,5.6468013728381639,806.83380282235976,16.074561241345972,822.90836406370568,{"$f":"F241/C241","v":145.73000000000002},338.80808237028981,-484.10028169341587]
[null,null,7.0585017160477044,806.83380282235976,20.093201551682466,826.92700437404221,117.15333333333335,423.51010296286228,-403.41690141117994]
[null,null,8.4702020592572449,806.83380282235976,24.111841862018956,830.94564468437875,98.102222222222252,508.21212355543469,-322.73352112894406]
[null,null,9.8819024024667854,806.83380282235976,28.13048217235545,834.96428499471517,84.494285714285738,592.91414414800715,-242.05014084670802]
[null,null,11.293602745676326,806.83380282235976,32.149122482691944,838.98292530505171,74.288333333333355,677.61616474057951,-161.3667605644722]
[null,null,12.705303088885866,806.83380282235976,36.16776279302843,843.00156561538824,{"$f":"F246/C246","v":66.350370370370399},762.31818533315197,{"$f":"H246-F246","v":-80.683380282236271}]
[null,null,14.117003432095407,806.83380282235976,40.186403103364924,847.02020592572467,{"$f":"F247/C247","v":60.000000000000014},847.02020592572444,{"$f":"H247-F247","v":0}]
[null,null,15.528703775304947,806.83380282235976,44.205043413701418,851.0388462360612,{"$f":"F248/C248","v":54.804242424242446},931.72222651829679,{"$f":"H248-F248","v":80.683380282235589}]
[null,null,16.94040411851449,806.83380282235976,48.223683724037912,855.05748654639763,50.474444444444451,1016.4242471108694,{"$f":"H249-F249","v":161.36676056447175}]
[null,null,18.352104461724032,806.83380282235976,52.242324034374413,859.07612685673416,46.810769230769239,1101.126267703442,{"$f":"H250-F250","v":242.05014084670779}]
[null,null,19.763804804933574,806.83380282235976,56.260964344710906,863.0947671670707,43.670476190476194,1185.8282882960145,{"$f":"H251-F251","v":322.73352112894383}]

{"sheet":"ESTADO DE GANACIAS Y PERDIDAS","index":19,"n_rows":38,"n_cols":25,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["ESTADO DE PÉRDIDAS Y GANANCIAS"]
[]
["CONCEPTO",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["A. INGRESOS",{"$f":"'INGRESO POR VENTAS'!C30","v":33295.711949998004},{"$f":"'INGRESO POR VENTAS'!D30","v":22600},{"$f":"'INGRESO POR VENTAS'!E30","v":22600},{"$f":"'INGRESO POR VENTAS'!F30","v":22600},{"$f":"'INGRESO POR VENTAS'!G30","v":22600},{"$f":"'INGRESO POR VENTAS'!H30","v":22600},{"$f":"'INGRESO POR VENTAS'!I30","v":22600},{"$f":"'INGRESO POR VENTAS'!J30","v":22600},{"$f":"'INGRESO POR VENTAS'!K30","v":22600},{"$f":"'INGRESO POR VENTAS'!L30","v":22600},{"$f":"'INGRESO POR VENTAS'!M30","v":22600},{"$f":"'INGRESO POR VENTAS'!N30","v":22600},{"$f":"'INGRESO POR VENTAS'!O30","v":38290.068742497715},{"$f":"'INGRESO POR VENTAS'!P30","v":25990},{"$f":"'INGRESO POR VENTAS'!Q30","v":25990},{"$f":"'INGRESO POR VENTAS'!R30","v":25990},{"$f":"'INGRESO POR VENTAS'!S30","v":25990},{"$f":"'INGRESO POR VENTAS'!T30","v":25990},{"$f":"'INGRESO POR VENTAS'!U30","v":25990},{"$f":"'INGRESO POR VENTAS'!V30","v":25990},{"$f":"'INGRESO POR VENTAS'!W30","v":25990},{"$f":"'INGRESO POR VENTAS'!X30","v":25990},{"$f":"'INGRESO POR VENTAS'!Y30","v":25990},{"$f":"'INGRESO POR VENTAS'!Z30","v":25990}]
["B. COSTOS",{"$f":"B6+B7+B8","v":7363.8624930443921},5837.24,5837.24,5837.24,5837.24,5837.24,11137.24,5837.24,5837.24,5837.24,5837.24,11137.24,5861.080867001051,5803.44,5853.44,5853.44,5853.44,5853.44,11153.44,5853.44,5853.44,5853.44,5853.44,11153.44]
["Mano de obra directa",{"$f":"'PRESUPUESTO DE GASTOS'!B9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!C9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!D9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!E9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!F9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!G9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!H9","v":9929.24},{"$f":"'PRESUPUESTO DE GASTOS'!I9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!J9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!K9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!L9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!M9","v":9929.24},{"$f":"'PRESUPUESTO DE GASTOS'!N9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!O9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!P9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!Q9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!R9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!S9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!T9","v":9929.24},{"$f":"'PRESUPUESTO DE GASTOS'!U9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!V9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!W9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!X9","v":4629.24},{"$f":"'PRESUPUESTO DE GASTOS'!Y9","v":9929.24}]
["Reposicion de implementos",{"$f":"'PRESUPUESTO DE GASTOS'!B7","v":158.12249304439203},{"$f":"'PRESUPUESTO DE GASTOS'!C7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!D7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!E7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!F7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!G7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!H7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!I7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!J7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!K7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!L7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!M7","v":108},{"$f":"'PRESUPUESTO DE GASTOS'!N7","v":181.84086700105087},{"$f":"'PRESUPUESTO DE GASTOS'!O7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!P7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!Q7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!R7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!S7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!T7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!U7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!V7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!W7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!X7","v":124.2},{"$f":"'PRESUPUESTO DE GASTOS'!Y7","v":124.2}]
["Costos Indirectos",{"$f":"'PRESUPUESTO DE GASTOS'!B13","v":2576.5},{"$f":"'PRESUPUESTO DE GASTOS'!C13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!D13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!E13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!F13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!G13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!H13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!I13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!J13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!K13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!L13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!M13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!N13","v":1050},{"$f":"'PRESUPUESTO DE GASTOS'!O13","v":1050},{"$f":"'PRESUPUESTO DE GASTOS'!P13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!Q13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!R13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!S13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!T13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!U13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!V13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!W13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!X13","v":1100},{"$f":"'PRESUPUESTO DE GASTOS'!Y13","v":1100}]
["C. UTILIDAD BRUTA",{"$f":"+B4-B5","v":25931.849456953612},{"$f":"+C4-C5","v":16762.760000000002},16762.760000000002,16762.760000000002,16762.760000000002,16762.760000000002,11462.76,16762.760000000002,16762.760000000002,16762.760000000002,16762.760000000002,11462.76,32428.987875496663,20186.560000000001,20136.560000000001,20136.560000000001,20136.560000000001,20136.560000000001,14836.56,20136.560000000001,20136.560000000001,20136.560000000001,20136.560000000001,14836.56]
["Administración",{"$f":"'PRESUPUESTO DE GASTOS'!B29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!C29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!D29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!E29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!F29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!G29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!H29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!I29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!J29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!K29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!L29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!M29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!N29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!O29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!P29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!Q29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!R29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!S29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!T29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!U29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!V29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!W29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!X29","v":926.5},{"$f":"'PRESUPUESTO DE GASTOS'!Y29","v":926.5}]
["Ventas",{"$f":"'PRESUPUESTO DE GASTOS'!B25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!C25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!D25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!E25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!F25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!G25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!H25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!I25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!J25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!K25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!L25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!M25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!N25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!O25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!P25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!Q25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!R25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!S25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!T25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!U25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!V25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!W25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!X25","v":800},{"$f":"'PRESUPUESTO DE GASTOS'!Y25","v":800}]
["D. UTILIDAD DE OPERACIÓN",{"$f":"+B9-B10-B11","v":24205.349456953612},{"$f":"+C9-C10-C11","v":15036.260000000002},15036.260000000002,15036.260000000002,15036.260000000002,15036.260000000002,9736.26,15036.260000000002,15036.260000000002,15036.260000000002,15036.260000000002,9736.26,30702.487875496663,18460.060000000001,18410.060000000001,18410.060000000001,18410.060000000001,18410.060000000001,13110.06,18410.060000000001,18410.060000000001,18410.060000000001,18410.060000000001,13110.06]
["Gastos Financieros",{"$f":"'AMORTIZACION DE CREDITO'!E16","v":190.30118380266163},{"$f":"'AMORTIZACION DE CREDITO'!E17","v":182.79788805366411},{"$f":"'AMORTIZACION DE CREDITO'!E18","v":175.25883710152834},{"$f":"'AMORTIZACION DE CREDITO'!E19","v":167.68386056318604},{"$f":"'AMORTIZACION DE CREDITO'!E20","v":160.07278724364846},{"$f":"'AMORTIZACION DE CREDITO'!E21","v":152.4254451321367},{"$f":"'AMORTIZACION DE CREDITO'!E22","v":144.74166139819476},{"$f":"'AMORTIZACION DE CREDITO'!E23","v":137.02126238778419},{"$f":"'AMORTIZACION DE CREDITO'!E24","v":129.26407361935776},{"$f":"'AMORTIZACION DE CREDITO'!E25","v":121.46991977991797},{"$f":"'AMORTIZACION DE CREDITO'!E26","v":113.63862472105347},{"$f":"'AMORTIZACION DE CREDITO'!E27","v":105.77001145495979},{"$f":"'AMORTIZACION DE CREDITO'!E28","v":97.863902150437298},{"$f":"'AMORTIZACION DE CREDITO'!E29","v":89.92011812887381},{"$f":"'AMORTIZACION DE CREDITO'!E30","v":81.938479860206598},{"$f":"'AMORTIZACION DE CREDITO'!E31","v":73.918806958863115},{"$f":"'AMORTIZACION DE CREDITO'!E32","v":65.86091817968645},{"$f":"'AMORTIZACION DE CREDITO'!E33","v":57.76463141383806},{"$f":"'AMORTIZACION DE CREDITO'!E34","v":49.629763684681848},{"$f":"'AMORTIZACION DE CREDITO'!E35","v":41.456131143649827},{"$f":"'AMORTIZACION DE CREDITO'!E36","v":33.243549066086189},{"$f":"'AMORTIZACION DE CREDITO'!E37","v":24.991831847073172},{"$f":"'AMORTIZACION DE CREDITO'!E38","v":16.700792997236249},{"$f":"'AMORTIZACION DE CREDITO'!E39","v":8.3702451385290715}]
["Depreciación equipo",{"$f":"'PRESUPUESTO DE GASTOS'!B31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!C31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!D31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!E31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!F31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!G31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!H31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!I31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!J31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!K31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!L31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!M31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!N31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!O31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!P31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!Q31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!R31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!S31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!T31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!U31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!V31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!W31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!X31","v":942.66666666666674},{"$f":"'PRESUPUESTO DE GASTOS'!Y31","v":942.66666666666674}]
["E. UTILIDAD ANTES DE IMPUESTOS",{"$f":"+B12-B13-B14","v":23072.381606484283},13910.795445279671,13918.334496231808,13925.90947277015,13933.520546089687,13941.1678882012,8648.8516719351392,13956.572070945551,13964.329259713979,13972.123413553418,13979.954708612282,8687.8233218783735,29661.957306679556,17427.47321520446,17385.454853473126,17393.47452637447,17401.532415153648,17409.628701919497,12117.763569648652,17425.937202189685,17434.149784267247,17442.40150148626,17450.692540336098,12159.023088194805]
["Impuesto a la Renta",{"$f":"IF(B15>1,B15*0.3,0)","v":6921.7144819452851},4173.238633583901,4175.500348869542,4177.7728418310453,4180.0561638269055,4182.3503664603595,2594.6555015805416,4186.9716212836647,4189.2987779141931,4191.6370240660253,4193.9864125836848,2606.3469965635118,8898.5871920038662,5228.2419645613381,5215.6364560419379,5218.0423579123408,5220.4597245460945,5222.8886105758493,3635.3290708945956,5227.7811606569057,5230.2449352801741,5232.7204504458778,5235.2077621008293,3647.7069264584411]
["UTILIDAD NETA",{"$f":"B15-B16","v":16150.667124538999},9737.5568116957693,9742.8341473622659,9748.1366309391051,9753.4643822627804,9758.8175217408407,6054.1961703545976,9769.6004496618862,9775.0304817997858,9780.4863894873924,9785.9682960285973,6081.4763253148612,20763.37011467569,12199.231250643123,12169.818397431187,12175.432168462128,12181.072690607554,12186.740091343647,8482.4344987540571,12198.15604153278,12203.904848987073,12209.681051040381,12215.48477823527,8511.3161617363639]
[]
["RENTABILIDAD DE VENTAS ((UTILIDAD NETA/INGRESOS)*100)",{"$f":"B17/B4*100","v":48.506748102558497},43.086534565025531,43.109885607797636,43.133347924509316,43.156922045410532,43.180608503278059,26.788478629887603,43.228320573725156,43.252347264600822,43.276488449059258,43.300744672692907,26.909187280154249,54.226515638585568,46.938173338372927,46.825003452986486,46.846603187618804,46.868305850740875,46.890111932834351,32.637300880161817,46.934036327559753,46.956155632886002,46.978380342594775,47.000710958966025,32.748426940116829]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6548.33,9074.69,11573.45,10052.23,8507.76,10897.5,13280.56,11682.79]

{"sheet":"PRINCIPALES RATIOS","index":20,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["RATIOS FINANCIEROS"]
[]
["CUENTAS DE LOS ESTADOS FINANCIEROS DE DAY SPA"]
["ABREV","PRINCIPALES CTAS","1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
["AC","Activo Corriente",{"$f":"'BALANCE GENERAL'!D9","v":50238.132373436143},{"$f":"'BALANCE GENERAL'!E9","v":40534.257318982636},{"$f":"'BALANCE GENERAL'!F9","v":34384.257318982636},{"$f":"'BALANCE GENERAL'!G9","v":34384.257318982629},{"$f":"'BALANCE GENERAL'!H9","v":64145.307005560833},{"$f":"'BALANCE GENERAL'!I9","v":51187.875692939291},{"$f":"'BALANCE GENERAL'!J9","v":45037.875692939291},{"$f":"'BALANCE GENERAL'!K9","v":45037.875692939291}]
["PC","Pasivo Corriente",{"$f":"'BALANCE GENERAL'!D21","v":20016.740729502635},{"$f":"'BALANCE GENERAL'!E21","v":17354.6424532411},{"$f":"'BALANCE GENERAL'!F21","v":15854.544077434824},{"$f":"'BALANCE GENERAL'!G21","v":15945.737051319054},{"$f":"'BALANCE GENERAL'!H21","v":24367.388286529385},{"$f":"'BALANCE GENERAL'!I21","v":20758.491510543659},{"$f":"'BALANCE GENERAL'!J21","v":19263.670896999021},{"$f":"'BALANCE GENERAL'!K21","v":19360.217443084071}]
["Exit","Existencias",{"$f":"'BALANCE GENERAL'!D8","v":158.12249304439203},{"$f":"'BALANCE GENERAL'!E8","v":158.12249304439203},{"$f":"'BALANCE GENERAL'!F8","v":158.12249304439203},{"$f":"'BALANCE GENERAL'!G8","v":158.12249304439203},{"$f":"'BALANCE GENERAL'!H8","v":181.84086700105087},{"$f":"'BALANCE GENERAL'!I8","v":181.84086700105087},{"$f":"'BALANCE GENERAL'!J8","v":181.84086700105087},{"$f":"'BALANCE GENERAL'!K8","v":181.84086700105087}]
["CyB","Caja y Bancos",{"$f":"'BALANCE GENERAL'!D6","v":46155.224282891853},{"$f":"'BALANCE GENERAL'!E6","v":36986.134825938243},{"$f":"'BALANCE GENERAL'!F6","v":30836.134825938243},{"$f":"'BALANCE GENERAL'!G6","v":30836.134825938239},{"$f":"'BALANCE GENERAL'!H6","v":59449.962701434895},{"$f":"'BALANCE GENERAL'!I6","v":47107.534825938237},{"$f":"'BALANCE GENERAL'!J6","v":40957.534825938237},{"$f":"'BALANCE GENERAL'!K6","v":40957.534825938237}]
["Patri","Patrimonio",{"$f":"'BALANCE GENERAL'!D30","v":50631.058083597032},{"$f":"'BALANCE GENERAL'!E30","v":79891.47661853976},{"$f":"'BALANCE GENERAL'!F30","v":105490.30372035602},{"$f":"'BALANCE GENERAL'!G30","v":131138.23473118688},{"$f":"'BALANCE GENERAL'!H30","v":176270.65449393686},{"$f":"'BALANCE GENERAL'!I30","v":212813.89944435019},{"$f":"'BALANCE GENERAL'!J30","v":245698.3948336241},{"$f":"'BALANCE GENERAL'!K30","v":278634.87682463613}]
["PNC","Pasivo No Corriente",0,0,0,0,0,0,0,0]
["UN","Utilidad Neta",{"$f":"'BALANCE GENERAL'!D28","v":35631.058083597032},{"$f":"'BALANCE GENERAL'!E28","v":29260.418534942728},{"$f":"'BALANCE GENERAL'!F28","v":25598.82710181627},{"$f":"'BALANCE GENERAL'!G28","v":25647.931010830849},{"$f":"'BALANCE GENERAL'!H28","v":45132.419762749996},{"$f":"'BALANCE GENERAL'!I28","v":36543.244950413326},{"$f":"'BALANCE GENERAL'!J28","v":32884.495389273914},{"$f":"'BALANCE GENERAL'!K28","v":32936.481991012013}]
["TA","Total Activo",{"$f":"'BALANCE GENERAL'!D15","v":94102.465706769479},{"$f":"'BALANCE GENERAL'!E15","v":84398.590652315965},{"$f":"'BALANCE GENERAL'!F15","v":78248.590652315965},{"$f":"'BALANCE GENERAL'!G15","v":78248.590652315965},{"$f":"'BALANCE GENERAL'!H15","v":108009.64033889417},{"$f":"'BALANCE GENERAL'!I15","v":95052.209026272627},{"$f":"'BALANCE GENERAL'!J15","v":88902.209026272627},{"$f":"'BALANCE GENERAL'!K15","v":88902.209026272627}]
["IME","Inmueble Maquinaria y Eq",{"$f":"'BALANCE GENERAL'!D11","v":43409},{"$f":"'BALANCE GENERAL'!E11","v":43409},{"$f":"'BALANCE GENERAL'!F11","v":43409},{"$f":"'BALANCE GENERAL'!G11","v":43409},{"$f":"'BALANCE GENERAL'!H11","v":43409},{"$f":"'BALANCE GENERAL'!I11","v":43409},{"$f":"'BALANCE GENERAL'!J11","v":43409},{"$f":"'BALANCE GENERAL'!K11","v":43409}]
["TP","Total Pasivo",{"$f":"'BALANCE GENERAL'!D25","v":55205.510131065399},{"$f":"'BALANCE GENERAL'!E25","v":47728.94877368107},{"$f":"'BALANCE GENERAL'!F25","v":41345.232221218364},{"$f":"'BALANCE GENERAL'!G25","v":36482.658576996764},{"$f":"'BALANCE GENERAL'!H25","v":39879.387138284852},{"$f":"'BALANCE GENERAL'!I25","v":31173.389544789752},{"$f":"'BALANCE GENERAL'!J25","v":24508.253201077772},{"$f":"'BALANCE GENERAL'!K25","v":19360.217443083729}]
["UB","Utilidad Bruta",{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B15+'ESTADO DE GANACIAS Y PERDIDAS'!C15+'ESTADO DE GANACIAS Y PERDIDAS'!D15","v":50901.51154799576},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!E15+'ESTADO DE GANACIAS Y PERDIDAS'!F15+'ESTADO DE GANACIAS Y PERDIDAS'!G15","v":41800.597907061034},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!H15+'ESTADO DE GANACIAS Y PERDIDAS'!I15+'ESTADO DE GANACIAS Y PERDIDAS'!J15","v":36569.753002594669},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!K15+'ESTADO DE GANACIAS Y PERDIDAS'!L15+'ESTADO DE GANACIAS Y PERDIDAS'!M15","v":36639.901444044073},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!N15+'ESTADO DE GANACIAS Y PERDIDAS'!O15+'ESTADO DE GANACIAS Y PERDIDAS'!P15","v":64474.885375357146},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Q15+'ESTADO DE GANACIAS Y PERDIDAS'!R15+'ESTADO DE GANACIAS Y PERDIDAS'!S15","v":52204.635643447618},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!T15+'ESTADO DE GANACIAS Y PERDIDAS'!U15+'ESTADO DE GANACIAS Y PERDIDAS'!V15","v":46977.850556105586},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!W15+'ESTADO DE GANACIAS Y PERDIDAS'!X15+'ESTADO DE GANACIAS Y PERDIDAS'!Y15","v":47052.11713001717}]
["VN","Ventas Netas",{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B4+'ESTADO DE GANACIAS Y PERDIDAS'!C4+'ESTADO DE GANACIAS Y PERDIDAS'!D4","v":78495.711949998004},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!E4+'ESTADO DE GANACIAS Y PERDIDAS'!F4+'ESTADO DE GANACIAS Y PERDIDAS'!G4","v":67800},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!H4+'ESTADO DE GANACIAS Y PERDIDAS'!I4+'ESTADO DE GANACIAS Y PERDIDAS'!J4","v":67800},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!K4+'ESTADO DE GANACIAS Y PERDIDAS'!L4+'ESTADO DE GANACIAS Y PERDIDAS'!M4","v":67800},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!N4+'ESTADO DE GANACIAS Y PERDIDAS'!O4+'ESTADO DE GANACIAS Y PERDIDAS'!P4","v":90270.068742497708},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Q4+'ESTADO DE GANACIAS Y PERDIDAS'!R4+'ESTADO DE GANACIAS Y PERDIDAS'!S4","v":77970},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!T4+'ESTADO DE GANACIAS Y PERDIDAS'!U4+'ESTADO DE GANACIAS Y PERDIDAS'!V4","v":77970},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!W4+'ESTADO DE GANACIAS Y PERDIDAS'!X4+'ESTADO DE GANACIAS Y PERDIDAS'!Y4","v":77970}]
["CPCC","Cuentas por Cobrar Comerciales",0,0,0,0,0,0,0,0]
["CV","Costo de Ventas",{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B5+'ESTADO DE GANACIAS Y PERDIDAS'!C5+'ESTADO DE GANACIAS Y PERDIDAS'!D5","v":19038.342493044394},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!E5+'ESTADO DE GANACIAS Y PERDIDAS'!F5+'ESTADO DE GANACIAS Y PERDIDAS'!G5","v":17511.72},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!H5+'ESTADO DE GANACIAS Y PERDIDAS'!I5+'ESTADO DE GANACIAS Y PERDIDAS'!J5","v":22811.72},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!K5+'ESTADO DE GANACIAS Y PERDIDAS'!L5+'ESTADO DE GANACIAS Y PERDIDAS'!M5","v":22811.72},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!N5+'ESTADO DE GANACIAS Y PERDIDAS'!O5+'ESTADO DE GANACIAS Y PERDIDAS'!P5","v":17517.960867001049},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!Q5+'ESTADO DE GANACIAS Y PERDIDAS'!R5+'ESTADO DE GANACIAS Y PERDIDAS'!S5","v":17560.32},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!T5+'ESTADO DE GANACIAS Y PERDIDAS'!U5+'ESTADO DE GANACIAS Y PERDIDAS'!V5","v":22860.32},{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!W5+'ESTADO DE GANACIAS Y PERDIDAS'!X5+'ESTADO DE GANACIAS Y PERDIDAS'!Y5","v":22860.32}]
["AF","Activo fijo",{"$f":"'BALANCE GENERAL'!D11","v":43409},{"$f":"'BALANCE GENERAL'!E11","v":43409},{"$f":"'BALANCE GENERAL'!F11","v":43409},{"$f":"'BALANCE GENERAL'!G11","v":43409},{"$f":"'BALANCE GENERAL'!H11","v":43409},{"$f":"'BALANCE GENERAL'!I11","v":43409},{"$f":"'BALANCE GENERAL'!J11","v":43409},{"$f":"'BALANCE GENERAL'!K11","v":43409}]
["UAI","Utilidad antes de los impuestos",{"$f":"C11","v":35631.058083597032},{"$f":"D11","v":29260.418534942728},25598.82710181627,25647.931010830849,45132.419762749996,36543.244950413326,32884.495389273914,32936.481991012013]
["GF","Gastos financieros",{"$f":"'FLUJO DE CAJA ECON FINANCI'!C15+'FLUJO DE CAJA ECON FINANCI'!D15+'FLUJO DE CAJA ECON FINANCI'!E15","v":548.35790895785408},{"$f":"'FLUJO DE CAJA ECON FINANCI'!F15+'FLUJO DE CAJA ECON FINANCI'!G15+'FLUJO DE CAJA ECON FINANCI'!H15","v":480.18209293897121},{"$f":"'FLUJO DE CAJA ECON FINANCI'!I15+'FLUJO DE CAJA ECON FINANCI'!J15+'FLUJO DE CAJA ECON FINANCI'!K15","v":411.02699740533672},{"$f":"'FLUJO DE CAJA ECON FINANCI'!L15","v":121.46991977991797},0,0,0,0]
["GO","Gastos operacionales",{"$f":"'ESTADO DE GANACIAS Y PERDIDAS'!B10+'ESTADO DE GANACIAS Y PERDIDAS'!B11+'ESTADO DE GANACIAS Y PERDIDAS'!C10+'ESTADO DE GANACIAS Y PERDIDAS'!C11+'ESTADO DE GANACIAS Y PERDIDAS'!D10+'ESTADO DE GANACIAS Y PERDIDAS'!D11","v":5179.5},{"$f":"C22","v":5179.5},{"$f":"D22","v":5179.5},{"$f":"E22","v":5179.5},{"$f":"C22","v":5179.5},{"$f":"D22","v":5179.5},{"$f":"E22","v":5179.5},{"$f":"F22","v":5179.5}]
["CS","Capital social",{"$f":"'BALANCE GENERAL'!D27","v":15000},{"$f":"'BALANCE GENERAL'!E27","v":15000},{"$f":"'BALANCE GENERAL'!F27","v":15000},{"$f":"'BALANCE GENERAL'!G27","v":15000},{"$f":"'BALANCE GENERAL'!H27","v":15000},{"$f":"'BALANCE GENERAL'!I27","v":15000},{"$f":"'BALANCE GENERAL'!J27","v":15000},{"$f":"'BALANCE GENERAL'!K27","v":15000}]
[]
[]
[null,"1. RATIOS DE LIQUIDEZ","1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
[null,"Liquidez General (AC/PC)",{"$f":"C5/C6","v":2.509805819655258},{"$f":"D5/D6","v":2.3356434699357682},2.1687320146859634,2.1563291309973227,2.6324243801302747,2.4658764663578725,2.3379695351811418,2.3263104262823187]
["UNIDADES MONETARIAS","Prueba Acida ( (AC-EXIS)/PC)",{"$f":"(C5-C7)/C6","v":2.5019063071831131},{"$f":"(D5-D7)/D6","v":2.3265322195328615},2.1587586914373031,2.1464128447488102,2.6249619116513867,2.4571166358610999,2.3285299601399494,2.3169179250082172]
[null,"Prueba Defensiva (CB/PC)",{"$f":"C8/C6","v":2.3058311493670773},{"$f":"D8/D6","v":2.1311954380846854},1.944939865525755,1.9338168393656929,2.4397346979651333,2.2693139721646616,2.1261542021214024,2.1155513850165582]
[null,"Capital de Trabajo (AC-PC)",{"$f":"C5-C6","v":30221.391643933508},{"$f":"D5-D6","v":23179.614865741536},18529.713241547812,18438.520267663574,39777.918719031448,30429.384182395632,25774.20479594027,25677.65824985522]
[]
[null,"2. RATIOS DE GESTION O ACTIVIDAD","1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
[null,"Rotacion de Inmueble Maquinaria y Equipo",{"$f":"C16/C13","v":1.8082819680250179},{"$f":"D16/D13","v":1.561888087723744},1.561888087723744,1.561888087723744,2.0795242632287709,1.7961713008823055,{"$f":"I16/I13","v":1.7961713008823055},1.7961713008823055]
["VECES","Rotacion de existencias",{"$f":"C18/C7","v":120.40249382925857},110.74781116108308,144.26612913063377,144.26612913063377,96.336764974288272,96.569711141437296,125.7160745932205,125.7160745932205]
[null,"Rotacion de caja y bancos",{"$f":"C8/C16*360","v":211.67883351928106},196.38655659790217,163.731689341265,163.731689341265,237.08840450279672,217.50304652222349,{"$f":"I8/I16*360","v":189.10750977732158},{"$f":"J8/J16*360","v":189.10750977732158}]
[null,"Rotacion de activos totales",{"$f":"C16/C12","v":0.8341514896601826},{"$f":"D16/D12","v":0.80333094991248544},0.8664692799549264,0.8664692799549264,0.83575936795330241,0.82028603857537841,0.87703107553782034,0.87703107553782034]
[null,"Rotacion de activo fijo",{"$f":"C16/C13","v":1.8082819680250179},{"$f":"D16/D13","v":1.561888087723744},1.561888087723744,1.561888087723744,2.0795242632287709,1.7961713008823055,1.7961713008823055,1.7961713008823055]
[]
[null,"3. RATIOS DE SOLVENCIA O APALANCAMIENTO","1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
[null,"Estructura de capital(Pasivo total/Patrimonio)",{"$f":"C14/C9","v":1.0903487349585996},{"$f":"D14/D9","v":0.59742228825703048},0.39193395755898414,0.27820001277110812,0.22623951362055317,0.14648192447101627,9.9749341942887579E-2,6.9482390947305669E-2]
["PORCENTAJE","Endeudamiento total",{"$f":"C14/C12","v":0.58665317339388334},{"$f":"D14/D12","v":0.56551831499536243},0.52838309133168582,0.46624045587097063,0.36922062709549014,0.32796070563887014,0.27567653795683555,0.21776981309162233]
[]
[null,"4. RATIOS DE RENTABILIDAD","1ER TRIMESTRE","2DO TRIMESTRE","3ER TRIMESTRE","4TO TRIMESTRE","5TO TRIMESTRE","6TO TRIMESTRE","7MO TRIMESTRE","8VO TRIMESTRE"]
["PORCENTAJE","Rentabilidad sobre la inversion",{"$f":"C11/C12","v":0.37864106764881328},{"$f":"D11/D12","v":0.34669321263292679},0.32714745260474043,0.3277749899010064,0.41785547679948948,0.38445445218756247,0.36989514377033977,{"$f":"J11/J12","v":0.37047990541245757},null,{"$f":"J44*100","v":37.04799054124576}]
[null,"Rentabilidad sobre el patrimonio",{"$f":"C11/C9","v":0.703739156009075},{"$f":"D11/D9","v":0.3662520680979941},0.24266521375913502,0.19557935230259232,0.25604046171112621,0.17171455927374335,0.13384090446151189,0.11820660201034769]
[null,"Rentabilidad sobre ventas",{"$f":"C11/C16","v":0.45392362459613234},0.43156959491065972,0.37756382156071194,0.37828806800635473,0.49997103570945184,0.46868340323731339,0.42175830946869197,0.42242506080559206]
[null,"Margen comercial",{"$f":"(C16-C18)/C16","v":0.75746009533397352},0.74171504424778756,0.66354395280235989,0.66354395280235989,0.80593832362117312,0.77478106964217008,{"$f":"(I16-I18)/I16","v":0.70680620751571122},{"$f":"(J16-J18)/J16","v":0.70680620751571122}]

{"sheet":"CUADROS DE RATIOS","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ENCUESTA","index":22,"n_rows":238,"n_cols":15,"rows_kept":238,"cut":false,"hidden":false,"merged":[]}
["1.    ¿Usted tuvo alguna dolencia muscular o alguna discapacidad temporal?",null,null,null,null,null,null,null,null,null,"13.¿Al momento de elegir un centro de fisioterapia y rehabilitación física, que aspectos tendría en cuenta?"]
[]
[null,"SI",226,{"$f":"(C3/C5)","v":0.68484848484848482},null,null,null,null,null,null,null,null,"SEGURIIDAD",39,{"$f":"N3/N9","v":0.11818181818181818}]
[null,"NO",{"$f":"330-C3","v":104},{"$f":"C4/C5","v":0.31515151515151513},null,null,null,null,null,null,null,null,"CONFIABILIDAD",20,{"$f":"N4/N9","v":6.0606060606060608E-2}]
[null,null,{"$f":"SUM(C3:C4)","v":330},{"$f":"SUM(D3:D4)","v":1},null,null,null,null,null,null,null,null,"UBICACIÓN ",56,{"$f":"N5/N9","v":0.16969696969696971}]
[null,null,null,null,null,null,null,null,null,null,null,null,"BUEN TRATO",84,{"$f":"N6/N9","v":0.25454545454545452}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PERSONAL",95,{"$f":"N7/N9","v":0.2878787878787879}]
[null,null,null,null,null,null,null,null,null,null,null,null,"INSTALACIONES",36,{"$f":"N8/N9","v":0.10909090909090909}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:N8)","v":330},{"$f":"SUM(O3:O8)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2.    ¿Tiene usted parientes  que tengan alguna discapacidad o con alguna molestia muscular?"]
[]
[null,"SI",123,{"$f":"(C22/C24)","v":0.37272727272727274}]
[null,"NO",{"$f":"330-C22","v":207},{"$f":"C23/C24","v":0.62727272727272732},null,null,null,null,null,null,"14. ¿En qué horario le gustaría que se prestara el servicio?"]
[null,null,{"$f":"SUM(C22:C23)","v":330},{"$f":"SUM(D22:D23)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"7:00 am – 5:00 pm",56,{"$f":"M25/M29","v":0.16969696969696971}]
[null,null,null,null,null,null,null,null,null,null,null,"8:00 am – 7:00 pm",173,{"$f":"M26/M29","v":0.52424242424242429}]
[null,null,null,null,null,null,null,null,null,null,null,"7:00 am – 12:00 m",49,{"$f":"M27/M29","v":0.1484848484848485}]
[null,null,null,null,null,null,null,null,null,null,null,"9:00 am – 8:00  pm",52,{"$f":"M28/M29","v":0.15757575757575756}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:M28)","v":330},{"$f":"SUM(N25:N28)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3.     ¿Actualmente están siendo tratados en un centro especializado o fueron tratados? "]
[]
[]
[]
[null,"SI",104,{"$f":"(C43/C45)","v":0.31515151515151513}]
[null,"NO",{"$f":"330-C43","v":226},{"$f":"C44/C45","v":0.68484848484848482}]
[null,null,{"$f":"SUM(C43:C44)","v":330},{"$f":"SUM(D43:D44)","v":1}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"15. ¿Cuánto está dispuesto a pagar por el servicio? "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Entre s/.30.00 \ny S/. 60.00",91,{"$f":"L53/L57","v":0.27575757575757576}]
[null,null,null,null,null,null,null,null,null,null,"Entre S/. 60.00 \ny S/.90.00",178,{"$f":"L54/L57","v":0.53939393939393943}]
[null,null,null,null,null,null,null,null,null,null,"Entre S/. 90.00\ny S/. 100.00",56,{"$f":"L55/L57","v":0.16969696969696971}]
[null,null,null,null,null,null,null,null,null,null,"Entre S/.100.00 \ny S/. 130.00",5,{"$f":"L56/L57","v":1.5151515151515152E-2}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L53:L56)","v":330},{"$f":"SUM(M53:M56)","v":1}]
[]
[]
[]
[]
[]
["4.    ¿Le gustaría o le hubiera gustado hacer ver o tratar en un centro especializado en fisioterapia o rehabilitación física?"]
[]
[null,"SI",271,{"$f":"(C65/C67)","v":0.82121212121212117}]
[null,"NO",{"$f":"330-C65","v":59},{"$f":"C66/C67","v":0.1787878787878788}]
[null,null,{"$f":"SUM(C65:C66)","v":330},{"$f":"SUM(D65:D66)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5. ¿Le gustaría que en la ciudad de ilo se cree un centro de fisioterapia y rehabilitación física nuevo e innovador donde cuando usted trabaje pueda dejar a sus hijos con cuidados especiales?"]
[]
["SI",258,{"$f":"(B85/B87)","v":0.78181818181818186}]
["NO",{"$f":"330-B85","v":72},{"$f":"B86/B87","v":0.21818181818181817}]
[null,{"$f":"SUM(B85:B86)","v":330},{"$f":"SUM(C85:C86)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"16.¿De los siguientes servicios le gustaría que especialistas vengan continuamente en campañas hechas por el centro de rehabilitación? "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"SI",254,{"$f":"M92/M94","v":0.84666666666666668}]
[null,null,null,null,null,null,null,null,null,null,null,"NO",{"$f":"300-M92","v":46},{"$f":"M93/M94","v":0.15333333333333332}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M92:M93)","v":300},{"$f":"SUM(N92:N93)","v":1}]
[]
[]
[]
[]
[]
[]
[]
["6.    ¿utilizaria  estos servicios? "]
[]
[null,"SI",286,{"$f":"(C104/C106)","v":0.8666666666666667}]
[null,"NO",{"$f":"330-C104","v":44},{"$f":"C105/C106","v":0.13333333333333333}]
[null,null,{"$f":"SUM(C104:C105)","v":330},{"$f":"SUM(D104:D105)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7.    Si usted pudiera elegir la ubicación del centro de fisioterapia y rehabilitación física, ¿Cuál de las siguientes alternativas preferiría? "]
[]
[]
[null,"PAMPA \nINALAMBRICA",86,{"$f":"(C124/C127)","v":0.26060606060606062}]
[null,"PUERTO",165,{"$f":"C125/C127","v":0.5}]
[null,"CIUDAD NUEVA",79,{"$f":"C126/C127","v":0.23939393939393938}]
[null,null,{"$f":"SUM(C124:C126)","v":330},{"$f":"SUM(D124:D126)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8. ¿Sabe usted o conoce de  un Centro de rehabilitacion fisica privada en la ciudad de Ilo ?"]
[]
[]
[null,"SI",138,{"$f":"(C151/C153)","v":0.41818181818181815}]
[null,"NO",{"$f":"330-C151","v":192},{"$f":"C152/C153","v":0.58181818181818179}]
[null,null,{"$f":"SUM(C151:C152)","v":330}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9.  ¿Se siente satisfecho con los servicios brindados en Essalud, SIS o el servicio de una institución privada  en sus servicios de fisioterapia o rehabilitación física? "]
[]
[null,"SI",93,{"$f":"C171/$C$173","v":0.2818181818181818}]
[null,"NO",{"$f":"330-C171","v":237},{"$f":"C172/$C$173","v":0.71818181818181814}]
[null,null,{"$f":"SUM(C171:C172)","v":330},{"$f":"SUM(D171:D172)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10. ¿Entre cuánto tiempo fue tratado su discapacidad o molestias musculares?"]
[]
[]
[null," 1 mes  – 2 meses ",129,{"$f":"C193/$C$196","v":0.39090909090909093}]
[null," 2 meses – a mas.",43,{"$f":"C194/$C$196","v":0.13030303030303031}]
[null,"NO FUE TRATADO",158,{"$f":"C195/$C$196","v":0.47878787878787876}]
[null,null,{"$f":"SUM(C193:C195)","v":330},{"$f":"SUM(D193:D195)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["11.¿Cuenta con alguien que cuide de sus hijos o algun familiar  que tienen alguna discapacidad mientras usted trabaja? "]
[]
[null,"NO LO TIENE",261,{"$f":"(C213/C215)","v":0.79090909090909089}]
[null,"NO",{"$f":"330-C213","v":69},{"$f":"C214/C215","v":0.20909090909090908}]
[null,null,{"$f":"SUM(C213:C214)","v":330},{"$f":"SUM(D213:D214)","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["12.    ¿Conoce el tratamiento que les dan cuando tiene alguna dolencia muscular o alguna discapacidad? "]
[]
[]
[null,"SI",217,{"$f":"(C236/C238)","v":0.65757575757575759}]
[null,"NO",{"$f":"330-C236","v":113},{"$f":"C237/C238","v":0.34242424242424241}]
[null,null,{"$f":"SUM(C236:C237)","v":330},{"$f":"SUM(D236:D237)","v":1}]

{"sheet":"MUESTRA","index":23,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":false,"merged":[[49,15,49,18],[50,15,50,18],[44,15,44,18],[45,15,45,18],[46,15,46,18],[47,15,47,18],[48,15,48,18],[20,0,20,1],[43,8,43,12],[11,4,12,4],[42,15,42,18],[43,15,43,18],[33,21,33,22],[34,21,34,22],[29,15,29,16],[30,15,30,16],[33,15,33,16],[34,15,34,16],[34,19,34,20]]}
[]
[]
[]
[null,null,null,null,null,null,"CLASE",null,"%",null,"PEA (DE ILO PROVINCIA)",null,{"$f":"J17","v":25192.944}]
[null,null,null,null,null,null,"A","RICOS",2.7,null,"CLASE A Y B   %",{"$f":"I5+I6","v":53.300000000000004},{"$f":"(M4*L5)/100","v":13427.839152000002}]
[null,null,null,null,null,null,"B","CLASE MEDIA",50.6,null,"N° MIEMBROS (PEA) X FAMILIA",2,{"$f":"M5/L6","v":6713.9195760000011},"N"]
[null,null,null,null,null,null,"C","VULNERABLES",33.6]
[null,null,null,null,null,null,"D","POBRES",13.1]
[]
[null,"N=",{"$f":"B36","v":49986}]
[null,"p=",{"$f":"B36/L48","v":0.68301814604285094},null,null,null,null,null," PEA POR EDADES","%","demanda potencia","Q = n x q",{"$f":"M6*R37","v":18784.827187014551}]
[null,"q=",{"$f":"1-C11","v":0.31698185395714906},null,"n = ",{"$f":"((C14^2)*(C11*C12*C10))","v":41574.513002717271},null,null,"20-35",0.22800000000000001,null,"AL MES ",{"$f":"M11/4","v":4696.2067967536377}]
[null,"E=",0.05,null,null,{"$f":"((C13^2)*(C10-1)+(C14^2)*(C11*C12))","v":125.79422314253428},null,null,"36-45",0.108]
[null,"Z=",1.96,null,null,null,null,null,"46-70",0.16800000000000001]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J14)","v":0.504}]
[null,null,null,null,"n=",{"$f":"F12/F13","v":330.49620216351457},"encuestas"]
[null,null,null,null,null,null,null,null,"PEA",{"$f":"C10*J15","v":25192.944}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CONSUMO PER CAPITA"]
["MERCADO OBJETIVO"]
["EDAD","POBLACION-2016",null,null,null,null,null,null,null,null,null,"%","N° ENCUEST","PROMEDIO"]
[18,1049,null,null,null,null,null,null,null,null,"molestias mosculares o familiares con alguna discapacidad",{"$f":"6800%/100","v":0.68},{"$f":"$F$16*L23","v":224.73741747118993},{"$f":"$J$17*L23","v":17131.20192}]
[19,1051,null,null,null,null,null,null,null,null,"NUNCA TUVO MOLESTIAS",{"$f":"3200%/100","v":0.32},{"$f":"$F$16*L24","v":105.75878469232467},{"$f":"$J$17*L24","v":8061.74208}]
["20-24",5350,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L23:L24)","v":1},330.49620216351457]
["25-29",5773]
["30-34",5972]
["35-39",6211,null,null,null,null,null,null,null,null,"tratados",{"$f":"3200%/100","v":0.32},{"$f":"$F$16*L28","v":105.75878469232467},{"$f":"$N$23*L28","v":5481.9846144000003}]
["40-44",5766,null,null,null,null,null,null,null,null,"no tratados ",{"$f":"6800%/100","v":0.68},{"$f":"$F$16*L29","v":224.73741747118993},{"$f":"$N$23*L29","v":11649.217305600001}]
["45-49",5260,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L28:L29)","v":1},{"$f":"SUM(M28:M29)","v":330.49620216351457},null,null,"NO TRATADOS",null,{"$f":"N29","v":11649.217305600001}]
["50-54",4362,null,null,null,null,null,null,null,null,null,null,null,null,null,"POBLACION INSATISFECHA",null,{"$f":"N34*L35","v":1105.1680982630401}]
["55-59",3442,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R30:R31)","v":12754.385403863042}]
["60-64",2548]
["65-69",1922,null,null,null,null,null,null,null,null,"poblacion satisfecha",{"$f":"2800%/100","v":0.28000000000000003},{"$f":"$F$16*L34","v":92.538936605784087},{"$f":"$N$28*L34","v":1534.9556920320001},null,"UTILIZARIA NUESTROS SERVICIOS ",null,{"$f":"R32*L39","v":11096.315301360846},null,"ESENARIO NORMAL",null,"MARGEN DE ERROR"]
["70-74",1280,null,null,null,null,null,null,null,null,"poblacion insatisfecha",{"$f":"7200%/100","v":0.72},{"$f":"$F$16*L35","v":237.95726555773047},{"$f":"$N$28*L35","v":3947.0289223680002},null,"AL MES",null,{"$f":"R34/12","v":924.69294178007056},null,{"$f":"R35*60%","v":554.81576506804231},null,{"$f":"T35*0.05","v":27.740788253402116}]
["TOTAL",{"$f":"SUM(B23:B35)","v":49986},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L34:L35)","v":1},{"$f":"$F$16*L36","v":330.49620216351457}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q= CONX MES /N ENCU",null,{"$f":"R35/M36","v":2.7978927918892524},"Q",{"$f":"T35-V35","v":527.07497681464019}]
[]
[null,null,null,null,null,null,null,null,null,null,"utilizaria nuestros servicios",{"$f":"8700%/100","v":0.87},{"$f":"$F$16*L39","v":287.53169588225768}]
[null,null,null,null,null,null,null,null,null,null,"no utilizaria nuestros servicos ",{"$f":"1300%/100","v":0.13},{"$f":"$F$16*L40","v":42.964506281256895}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L39:L40)","v":1},{"$f":"SUM(M39:M40)","v":330.49620216351457}]
[]
["EDAD","PORCENTAJE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"PROGRAMA DE REHABILITACION CARDIACA"]
[18,{"$f":"(B23/$L$47)*100%","v":3.5778846481803607E-2},null,null,null,null,null,null,"POBLACION TOTAL PROYECTADA DE ILO",null,null,null,null,null,null,"PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIM. Y SEC."]
[19,3.5847061632388551E-2,null,null,null,null,null,null,"PROYECCION ANUAL ",2014,2015,2016,2017,null,null,"FISIOTERARIA EN SALUD OCUPACIONAL"]
["20-24",0.18247552781472764,null,null,null,null,null,null,"M.NIETO",81691,83039,84409,85802,null,null,"REHABILITACION DEPORTIVA."]
["25-29",0.19690303216344351,null,null,null,null,null,null,"S.CERRO",28275,28792,29319,29856,null,null,"PROGRAMA DE FISIOTERAPIA"]
["30-34",0.20369043964664552,null,null,null,null,null,null,"ILO",70981,72075,73184,74312,null,null,"TRATAMIENTO DE FISIOTERAPIA INTEGRAL."]
["35-39",0.21184215014154645,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(J46:J48)","v":180947},{"$f":"SUM(K46:K48)","v":183906},{"$f":"SUM(L46:L48)","v":186912},{"$f":"SUM(M46:M48)","v":189970},null,null,"REHABILITACIÓN CON HIDROTERAPIA"]
["40-44",0.1966642791363962,null,null,null,null,null,null,null,null,null,null,null,null,null,"REHABILITACIÓN PACIENTES QUEMADOS"]
["45-49",0.17940584603840512,null,null,null,null,null,null,null,null,null,null,null,null,null,"TERAPIA PSICOMOTRIZ PARA NIÑOS"]
["50-54",0.14877724342576487]
["55-59",0.1173982741566902]
["60-64",8.6906101845219824E-2]
["65-69",6.5554759712132066E-2]
["70-74",4.3657696374364743E-2]

{"sheet":"ENTREVISTA","index":24,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[[26,1,26,4],[27,1,27,4],[28,1,28,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4]]}
[]
[]
["¿Cuántos pacientes con lesiones atiende aproximadamente al día?"]
[]
[null,"0-10 ",1,{"$f":"C5/$C$8","v":0.1}]
[null,"10  A 20",3,{"$f":"C6/$C$8","v":0.3}]
[null,"20 A 30",6,0.6]
[null,null,{"$f":"SUM(C5:C7)","v":10},{"$f":"SUM(D5:D7)","v":1}]
[" "]
["¿Cuáles son las 5 patologías y/o traumas  más comunes que atiende en consulta?"]
["Siendo 1 la de mayor frecuencia y 3 la de menor.",null,null,null,null,null,null,null,null,null,"Muestra total","%","%","%"]
[1,"Lesión Deportiva   ",null,null,"alta",7,"media",3,"baja",0,{"$f":"SUM(F12,H12,J12)","v":10},{"$f":"F12/K12","v":0.7},{"$f":"H12/K12","v":0.3},{"$f":"J12/K12","v":0},{"$f":"SUM(L12:N12)","v":1}]
[2,"Lesión Laboral      ",null,null,"alta",5,"media",4,"baja",1,{"$f":"SUM(F13,H13,J13)","v":10},{"$f":"F13/K13","v":0.5},{"$f":"H13/K13","v":0.4},{"$f":"J13/K13","v":0.1},{"$f":"SUM(L13:N13)","v":1}]
[3,"Postquirúrgico       ",null,null,"alta",4,"media",4,"baja",2,10,0.4,0.4,0.2,1]
[4,"Dolor repentino  ",null,null,"alta",8,"media",2,"baja",0,10,0.8,0.2,0,1]
[5,"Dolor cardiovascular ",null,null,"alta",3,"media",2,"baja",5,10,0.3,0.2,0.5,1]
[]
["¿de los  servicio propuestos  cuales cree que tendria mas acogida según su experiencia "]
["“FISIOKINE ofreciera? Siendo 1 la de mayor frecuencia y 3 la de menor."]
[]
[null,"PROGRAMA DE REHABILITACION CARDIACA",null,null,null,null,"alta",2,"media",4,"baja",4,{"$f":"SUM(H21,J21,L21)","v":10}]
[null,"PROGRAMA DE PREVENCION CARDIOVASCULAR: PRIM. Y SEC.",null,null,null,null,"alta",3,"media",5,"baja",2,{"$f":"SUM(H22,J22,L22)","v":10}]
[null,"FISIOTERARIA EN SALUD OCUPACIONAL",null,null,null,null,"alta",5,"media",5,"baja",0,10]
[null,"REHABILITACION DEPORTIVA.",null,null,null,null,"alta",8,"media",2,"baja",0,10]
[null,"PROGRAMA DE FISIOTERAPIA",null,null,null,null,"alta",7,"media",2,"baja",1,10]
[null,"TRATAMIENTO DE FISIOTERAPIA INTEGRAL.",null,null,null,null,"alta",6,"media",3,"baja",1,10]
[null,"REHABILITACIÓN CON HIDROTERAPIA",null,null,null,null,"alta",4,"media",5,"baja",1,10]
[null,"REHABILITACIÓN PACIENTES QUEMADOS",null,null,null,null,"alta",3,"media",4,"baja",3,10]
[null,"TERAPIA PSICOMOTRIZ PARA NIÑOS",null,null,null,null,"alta",3,"media",5,"baja",2,10]
[null,null,null,null,null,null,null,{"$f":"SUM(H21:H29)","v":41},null,{"$f":"SUM(J21:J29)","v":35},null,{"$f":"SUM(L21:L29)","v":14}]
[null,null,null,null,null,null,"participacion",{"$f":"((H21/$H$30)*100)/100","v":4.878048780487805E-2}]
[null,null,null,null,null,null,"esperada",{"$f":"((H22/$H$30)*100)/100","v":7.3170731707317069E-2}]
[null,null,null,null,null,null,null,0.12195121951219512]
[null,null,null,null,null,null,null,0.1951219512195122]
[null,null,null,null,null,null,null,0.17073170731707318]
[null,null,null,null,null,null,null,0.14634146341463414]
[null,null,null,null,null,null,null,9.7560975609756101E-2]
[null,null,null,null,null,null,null,7.3170731707317069E-2]
[null,null,null,null,null,null,null,7.3170731707317069E-2]
[null,null,null,null,null,null,null,1]