ejercicios excel ofimatica

101
Primer Nombre : Ejemplo Primer Apellido : uno No. Cédula : 1435643578 Fecha de nacimiento : 08/09/199e Paralelo : Nombre del docente :

Upload: cosuta-coranja

Post on 13-Sep-2015

266 views

Category:

Documents


1 download

DESCRIPTION

Utilizando operaciones y referencias a celdas, Control de gastos por viáticos, Operaciones y funciones, funciones con condiciones, Funciones con varias condiciones, Funciones aleatorias y lógicas, Funciones Lógicas, funciones financieras, etc.

TRANSCRIPT

Datos EstudiantesNoFORMA DE PAGOvalor horaTipozonaMESTEXTOAOMateriasPorcentajePrimer Nombre :Ejemplo7(hasta 12 caracteres)1MENSUAL20Total deesteEneroNombre2004Matemticas 5Primer Apellido :uno3(hasta 12 caracteres)2BIMESTRAL25Promedio demedio oesteFebreroCarrera2005Estadstica 8No. Cdula :143564357833TRIMESTRAL30CuantasoesteMarzoCategora2006Lgica10Fecha de nacimiento :08/09/199eERROR:#VALUE!ERROR:#VALUE!(dd/mm/aaaa)4SEMESTRAL40Total desurAbrilNombre2007Matemticas 15Paralelo :5MENSUAL25Promedio deesteMayoCarrera2008Estadstica 15Nombre del docente :06BIMESTRAL30Cuantasmedio oesteJunioCategora2009Lgica107TRIMESTRAL20Total deoesteJulioNombre2010Matemticas 88SEMESTRAL40Promedio desurAgostoCarrera2011Estadstica 59MENSUAL30CuantasesteSeptiembreCategora2004Lgica5ERROR:#VALUE!10BIMESTRAL20Total demedio oesteOctubreNombre2005Matemticas 1011TRIMESTRAL25Promedio deoesteNoviembreCarrera2006Estadstica 812SEMESTRAL40CuantassurDiciembreCategora2007Lgica15

|

1Utilizando operaciones y referencias a celdas, resolver el siguiente problema.1) Completar la tabla de Proyeccin de Ventas de los meses de Enero a Junio considerando: a) Considerar un incremento en el Volumne de ventas de acuerdo a la tabla de variable de ventas, respecto al mes anterior b) El valor de los descuentos de ventas debe ser un incremento del valor de la tabla de variables de ventas, respecto al mes anterior c) El total de ventas es el valor del volumen de ventas * el precio de ventas que se tiene en la tabla de variable de ventas.2) Completar la tabla de Proyeccin de Compras, establecer las mismas consideraciones de la tabla de ventas.3) Completar la tabla Resmenes

ELECTRODOMESTICOS EL CHISPAZO S.A.

Tabla de Variables de VentasTabla de Variables de Compra% Incremento VentasERROR:#VALUE!% Incremento Compras1%Precio Ventas$28Precio Compras$6% Descuento VentasERROR:#VALUE!% Descuento ComprasERROR:#VALUE!

EneroFebreroMarzoAbrilMayoJunioTotalProyeccin de VentasVolumen Ventas
Fernando: Volumen_ventas_anterior+(Volumen_ventas_anterior*Inc_ventas)$ 500.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Total Ventas
Fernando: Volumen_ventas * Precio_Ventas$ 14,000.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Descuentos
Fernando: Total_Ventas * Descuento_ventasERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Neto Ventas
Fernando: Total_ventas - DescuentosERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

Proyecccin de ComprasVolumen compras
Fernando: Volumen_compra_anterior+(Volumen_compra_anterior*Inc_compra)$ 350.00$ 353.50$ 357.04$ 360.61$ 364.21$ 367.85$ 1,785.35Total Compras
Fernando: Volumen_compra * Precio_compra$ 2,100.00$ 2,121.00$ 2,142.21$ 2,163.63$ 2,185.27$ 2,207.12$ 10,712.11Descuentos
Fernando: Total_compra * Descuento_compraERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Neto Compras
Fernando: Total_compra - DescuentosERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

Resmenes
Fernando: Piensa en como puedes escibir un solo dato y autorrellenar el resto (sin tener que copiar)

Total Ventas
Fernando: Neto VentasERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Total Compras
Fernando: Neto comprasERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!Beneficios
Fernando: Ganancias - Perdidas ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

2Utilizando series, operaciones y referencias a celdas resolver el siguiente problema.a)ERROR:#VALUE!b)ERROR:#VALUE!c)Con los valores de las constantes (s, r, t), los valores de las series (X, Y), y con una nica frmula, calcule los valores de la variable Z y autocompletar hacia toda la tabla.d)El resultado de la tabla debe tener tres decimales y las series X, Y debe tener dos decimales

S =0.15R =0.25T =0.30

Variable X 76.916.826.736.646.556.466.376.286.196.16.015.925.835.745.655.565.475.385.295.25.115.024.934.844.754.664.574.484.394.34.214.124.033.943.853.763.673.583.493.43.313.223.133.042.952.862.772.682.592.52.412.322.232.142.051.961.871.781.691.61.511.421.331.241.151.060.970.880.790.70.610.520.430.340.250.160.07Variable Y0.96.5316.4356.3396.2446.1496.0545.9605.8665.7735.6805.5875.4955.4045.3135.2225.1325.0424.9534.8654.7764.6894.6024.5154.4294.3434.2584.1734.0894.0063.9233.8413.7593.6783.5973.5173.4383.3593.2813.2033.1263.0502.9752.9002.8262.7522.6792.6072.5362.4662.3962.3272.2592.1922.1252.0601.9951.9321.8691.8071.7471.6871.6291.5711.5151.4601.4071.3551.3041.2551.2071.1611.1181.0761.0361.0000.9660.9370.9120.976.6016.5056.4096.3146.2196.1246.0305.9365.8435.7505.6575.5655.4745.3835.2925.2025.1125.0234.9354.8464.7594.6724.5854.4994.4134.3284.2434.1594.0763.9933.9113.8293.7483.6673.5873.5083.4293.3513.2733.1963.1203.0452.9702.8962.8222.7492.6772.6062.5362.4662.3972.3292.2622.1952.1302.0652.0021.9391.8771.8171.7571.6991.6411.5851.5301.4771.4251.3741.3251.2771.2311.1881.1461.1061.0701.0361.0070.9821.046.6716.5756.4796.3846.2896.1946.1006.0065.9135.8205.7275.6355.5445.4535.3625.2725.1825.0935.0054.9164.8294.7424.6554.5694.4834.3984.3134.2294.1464.0633.9813.8993.8183.7373.6573.5783.4993.4213.3433.2663.1903.1153.0402.9662.8922.8192.7472.6762.6062.5362.4672.3992.3322.2652.2002.1352.0722.0091.9471.8871.8271.7691.7111.6551.6001.5471.4951.4441.3951.3471.3011.2581.2161.1761.1401.1061.0771.0521.116.7416.6456.5496.4546.3596.2646.1706.0765.9835.8905.7975.7055.6145.5235.4325.3425.2525.1635.0754.9864.8994.8124.7254.6394.5534.4684.3834.2994.2164.1334.0513.9693.8883.8073.7273.6483.5693.4913.4133.3363.2603.1853.1103.0362.9622.8892.8172.7462.6762.6062.5372.4692.4022.3352.2702.2052.1422.0792.0171.9571.8971.8391.7811.7251.6701.6171.5651.5141.4651.4171.3711.3281.2861.2461.2101.1761.1471.1221.186.8116.7156.6196.5246.4296.3346.2406.1466.0535.9605.8675.7755.6845.5935.5025.4125.3225.2335.1455.0564.9694.8824.7954.7094.6234.5384.4534.3694.2864.2034.1214.0393.9583.8773.7973.7183.6393.5613.4833.4063.3303.2553.1803.1063.0322.9592.8872.8162.7462.6762.6072.5392.4722.4052.3402.2752.2122.1492.0872.0271.9671.9091.8511.7951.7401.6871.6351.5841.5351.4871.4411.3981.3561.3161.2801.2461.2171.1921.256.8816.7856.6896.5946.4996.4046.3106.2166.1236.0305.9375.8455.7545.6635.5725.4825.3925.3035.2155.1265.0394.9524.8654.7794.6934.6084.5234.4394.3564.2734.1914.1094.0283.9473.8673.7883.7093.6313.5533.4763.4003.3253.2503.1763.1023.0292.9572.8862.8162.7462.6772.6092.5422.4752.4102.3452.2822.2192.1572.0972.0371.9791.9211.8651.8101.7571.7051.6541.6051.5571.5111.4681.4261.3861.3501.3161.2871.2621.326.9516.8556.7596.6646.5696.4746.3806.2866.1936.1006.0075.9155.8245.7335.6425.5525.4625.3735.2855.1965.1095.0224.9354.8494.7634.6784.5934.5094.4264.3434.2614.1794.0984.0173.9373.8583.7793.7013.6233.5463.4703.3953.3203.2463.1723.0993.0272.9562.8862.8162.7472.6792.6122.5452.4802.4152.3522.2892.2272.1672.1072.0491.9911.9351.8801.8271.7751.7241.6751.6271.5811.5381.4961.4561.4201.3861.3571.3321.397.0216.9256.8296.7346.6396.5446.4506.3566.2636.1706.0775.9855.8945.8035.7125.6225.5325.4435.3555.2665.1795.0925.0054.9194.8334.7484.6634.5794.4964.4134.3314.2494.1684.0874.0073.9283.8493.7713.6933.6163.5403.4653.3903.3163.2423.1693.0973.0262.9562.8862.8172.7492.6822.6152.5502.4852.4222.3592.2972.2372.1772.1192.0612.0051.9501.8971.8451.7941.7451.6971.6511.6081.5661.5261.4901.4561.4271.4021.467.0916.9956.8996.8046.7096.6146.5206.4266.3336.2406.1476.0555.9645.8735.7825.6925.6025.5135.4255.3365.2495.1625.0754.9894.9034.8184.7334.6494.5664.4834.4014.3194.2384.1574.0773.9983.9193.8413.7633.6863.6103.5353.4603.3863.3123.2393.1673.0963.0262.9562.8872.8192.7522.6852.6202.5552.4922.4292.3672.3072.2472.1892.1312.0752.0201.9671.9151.8641.8151.7671.7211.6781.6361.5961.5601.5261.4971.4721.537.1617.0656.9696.8746.7796.6846.5906.4966.4036.3106.2176.1256.0345.9435.8525.7625.6725.5835.4955.4065.3195.2325.1455.0594.9734.8884.8034.7194.6364.5534.4714.3894.3084.2274.1474.0683.9893.9113.8333.7563.6803.6053.5303.4563.3823.3093.2373.1663.0963.0262.9572.8892.8222.7552.6902.6252.5622.4992.4372.3772.3172.2592.2012.1452.0902.0371.9851.9341.8851.8371.7911.7481.7061.6661.6301.5961.5671.5421.67.2317.1357.0396.9446.8496.7546.6606.5666.4736.3806.2876.1956.1046.0135.9225.8325.7425.6535.5655.4765.3895.3025.2155.1295.0434.9584.8734.7894.7064.6234.5414.4594.3784.2974.2174.1384.0593.9813.9033.8263.7503.6753.6003.5263.4523.3793.3073.2363.1663.0963.0272.9592.8922.8252.7602.6952.6322.5692.5072.4472.3872.3292.2712.2152.1602.1072.0552.0041.9551.9071.8611.8181.7761.7361.7001.6661.6371.6121.677.3017.2057.1097.0146.9196.8246.7306.6366.5436.4506.3576.2656.1746.0835.9925.9025.8125.7235.6355.5465.4595.3725.2855.1995.1135.0284.9434.8594.7764.6934.6114.5294.4484.3674.2874.2084.1294.0513.9733.8963.8203.7453.6703.5963.5223.4493.3773.3063.2363.1663.0973.0292.9622.8952.8302.7652.7022.6392.5772.5172.4572.3992.3412.2852.2302.1772.1252.0742.0251.9771.9311.8881.8461.8061.7701.7361.7071.6821.747.3717.2757.1797.0846.9896.8946.8006.7066.6136.5206.4276.3356.2446.1536.0625.9725.8825.7935.7055.6165.5295.4425.3555.2695.1835.0985.0134.9294.8464.7634.6814.5994.5184.4374.3574.2784.1994.1214.0433.9663.8903.8153.7403.6663.5923.5193.4473.3763.3063.2363.1673.0993.0322.9652.9002.8352.7722.7092.6472.5872.5272.4692.4112.3552.3002.2472.1952.1442.0952.0472.0011.9581.9161.8761.8401.8061.7771.7521.817.4417.3457.2497.1547.0596.9646.8706.7766.6836.5906.4976.4056.3146.2236.1326.0425.9525.8635.7755.6865.5995.5125.4255.3395.2535.1685.0834.9994.9164.8334.7514.6694.5884.5074.4274.3484.2694.1914.1134.0363.9603.8853.8103.7363.6623.5893.5173.4463.3763.3063.2373.1693.1023.0352.9702.9052.8422.7792.7172.6572.5972.5392.4812.4252.3702.3172.2652.2142.1652.1172.0712.0281.9861.9461.9101.8761.8471.8221.887.5117.4157.3197.2247.1297.0346.9406.8466.7536.6606.5676.4756.3846.2936.2026.1126.0225.9335.8455.7565.6695.5825.4955.4095.3235.2385.1535.0694.9864.9034.8214.7394.6584.5774.4974.4184.3394.2614.1834.1064.0303.9553.8803.8063.7323.6593.5873.5163.4463.3763.3073.2393.1723.1053.0402.9752.9122.8492.7872.7272.6672.6092.5512.4952.4402.3872.3352.2842.2352.1872.1412.0982.0562.0161.9801.9461.9171.8921.957.5817.4857.3897.2947.1997.1047.0106.9166.8236.7306.6376.5456.4546.3636.2726.1826.0926.0035.9155.8265.7395.6525.5655.4795.3935.3085.2235.1395.0564.9734.8914.8094.7284.6474.5674.4884.4094.3314.2534.1764.1004.0253.9503.8763.8023.7293.6573.5863.5163.4463.3773.3093.2423.1753.1103.0452.9822.9192.8572.7972.7372.6792.6212.5652.5102.4572.4052.3542.3052.2572.2112.1682.1262.0862.0502.0161.9871.9622.027.6517.5557.4597.3647.2697.1747.0806.9866.8936.8006.7076.6156.5246.4336.3426.2526.1626.0735.9855.8965.8095.7225.6355.5495.4635.3785.2935.2095.1265.0434.9614.8794.7984.7174.6374.5584.4794.4014.3234.2464.1704.0954.0203.9463.8723.7993.7273.6563.5863.5163.4473.3793.3123.2453.1803.1153.0522.9892.9272.8672.8072.7492.6912.6352.5802.5272.4752.4242.3752.3272.2812.2382.1962.1562.1202.0862.0572.0322.097.7217.6257.5297.4347.3397.2447.1507.0566.9636.8706.7776.6856.5946.5036.4126.3226.2326.1436.0555.9665.8795.7925.7055.6195.5335.4485.3635.2795.1965.1135.0314.9494.8684.7874.7074.6284.5494.4714.3934.3164.2404.1654.0904.0163.9423.8693.7973.7263.6563.5863.5173.4493.3823.3153.2503.1853.1223.0592.9972.9372.8772.8192.7612.7052.6502.5972.5452.4942.4452.3972.3512.3082.2662.2262.1902.1562.1272.1022.167.7917.6957.5997.5047.4097.3147.2207.1267.0336.9406.8476.7556.6646.5736.4826.3926.3026.2136.1256.0365.9495.8625.7755.6895.6035.5185.4335.3495.2665.1835.1015.0194.9384.8574.7774.6984.6194.5414.4634.3864.3104.2354.1604.0864.0123.9393.8673.7963.7263.6563.5873.5193.4523.3853.3203.2553.1923.1293.0673.0072.9472.8892.8312.7752.7202.6672.6152.5642.5152.4672.4212.3782.3362.2962.2602.2262.1972.1722.237.8617.7657.6697.5747.4797.3847.2907.1967.1037.0106.9176.8256.7346.6436.5526.4626.3726.2836.1956.1066.0195.9325.8455.7595.6735.5885.5035.4195.3365.2535.1715.0895.0084.9274.8474.7684.6894.6114.5334.4564.3804.3054.2304.1564.0824.0093.9373.8663.7963.7263.6573.5893.5223.4553.3903.3253.2623.1993.1373.0773.0172.9592.9012.8452.7902.7372.6852.6342.5852.5372.4912.4482.4062.3662.3302.2962.2672.2422.37.9317.8357.7397.6447.5497.4547.3607.2667.1737.0806.9876.8956.8046.7136.6226.5326.4426.3536.2656.1766.0896.0025.9155.8295.7435.6585.5735.4895.4065.3235.2415.1595.0784.9974.9174.8384.7594.6814.6034.5264.4504.3754.3004.2264.1524.0794.0073.9363.8663.7963.7273.6593.5923.5253.4603.3953.3323.2693.2073.1473.0873.0292.9712.9152.8602.8072.7552.7042.6552.6072.5612.5182.4762.4362.4002.3662.3372.3122.378.0017.9057.8097.7147.6197.5247.4307.3367.2437.1507.0576.9656.8746.7836.6926.6026.5126.4236.3356.2466.1596.0725.9855.8995.8135.7285.6435.5595.4765.3935.3115.2295.1485.0674.9874.9084.8294.7514.6734.5964.5204.4454.3704.2964.2224.1494.0774.0063.9363.8663.7973.7293.6623.5953.5303.4653.4023.3393.2773.2173.1573.0993.0412.9852.9302.8772.8252.7742.7252.6772.6312.5882.5462.5062.4702.4362.4072.3822.448.0717.9757.8797.7847.6897.5947.5007.4067.3137.2207.1277.0356.9446.8536.7626.6726.5826.4936.4056.3166.2296.1426.0555.9695.8835.7985.7135.6295.5465.4635.3815.2995.2185.1375.0574.9784.8994.8214.7434.6664.5904.5154.4404.3664.2924.2194.1474.0764.0063.9363.8673.7993.7323.6653.6003.5353.4723.4093.3473.2873.2273.1693.1113.0553.0002.9472.8952.8442.7952.7472.7012.6582.6162.5762.5402.5062.4772.4522.518.1418.0457.9497.8547.7597.6647.5707.4767.3837.2907.1977.1057.0146.9236.8326.7426.6526.5636.4756.3866.2996.2126.1256.0395.9535.8685.7835.6995.6165.5335.4515.3695.2885.2075.1275.0484.9694.8914.8134.7364.6604.5854.5104.4364.3624.2894.2174.1464.0764.0063.9373.8693.8023.7353.6703.6053.5423.4793.4173.3573.2973.2393.1813.1253.0703.0172.9652.9142.8652.8172.7712.7282.6862.6462.6102.5762.5472.5222.588.2118.1158.0197.9247.8297.7347.6407.5467.4537.3607.2677.1757.0846.9936.9026.8126.7226.6336.5456.4566.3696.2826.1956.1096.0235.9385.8535.7695.6865.6035.5215.4395.3585.2775.1975.1185.0394.9614.8834.8064.7304.6554.5804.5064.4324.3594.2874.2164.1464.0764.0073.9393.8723.8053.7403.6753.6123.5493.4873.4273.3673.3093.2513.1953.1403.0873.0352.9842.9352.8872.8412.7982.7562.7162.6802.6462.6172.5922.658.2818.1858.0897.9947.8997.8047.7107.6167.5237.4307.3377.2457.1547.0636.9726.8826.7926.7036.6156.5266.4396.3526.2656.1796.0936.0085.9235.8395.7565.6735.5915.5095.4285.3475.2675.1885.1095.0314.9534.8764.8004.7254.6504.5764.5024.4294.3574.2864.2164.1464.0774.0093.9423.8753.8103.7453.6823.6193.5573.4973.4373.3793.3213.2653.2103.1573.1053.0543.0052.9572.9112.8682.8262.7862.7502.7162.6872.6622.728.3518.2558.1598.0647.9697.8747.7807.6867.5937.5007.4077.3157.2247.1337.0426.9526.8626.7736.6856.5966.5096.4226.3356.2496.1636.0785.9935.9095.8265.7435.6615.5795.4985.4175.3375.2585.1795.1015.0234.9464.8704.7954.7204.6464.5724.4994.4274.3564.2864.2164.1474.0794.0123.9453.8803.8153.7523.6893.6273.5673.5073.4493.3913.3353.2803.2273.1753.1243.0753.0272.9812.9382.8962.8562.8202.7862.7572.7322.798.4218.3258.2298.1348.0397.9447.8507.7567.6637.5707.4777.3857.2947.2037.1127.0226.9326.8436.7556.6666.5796.4926.4056.3196.2336.1486.0635.9795.8965.8135.7315.6495.5685.4875.4075.3285.2495.1715.0935.0164.9404.8654.7904.7164.6424.5694.4974.4264.3564.2864.2174.1494.0824.0153.9503.8853.8223.7593.6973.6373.5773.5193.4613.4053.3503.2973.2453.1943.1453.0973.0513.0082.9662.9262.8902.8562.8272.8022.868.4918.3958.2998.2048.1098.0147.9207.8267.7337.6407.5477.4557.3647.2737.1827.0927.0026.9136.8256.7366.6496.5626.4756.3896.3036.2186.1336.0495.9665.8835.8015.7195.6385.5575.4775.3985.3195.2415.1635.0865.0104.9354.8604.7864.7124.6394.5674.4964.4264.3564.2874.2194.1524.0854.0203.9553.8923.8293.7673.7073.6473.5893.5313.4753.4203.3673.3153.2643.2153.1673.1213.0783.0362.9962.9602.9262.8972.8722.938.5618.4658.3698.2748.1798.0847.9907.8967.8037.7107.6177.5257.4347.3437.2527.1627.0726.9836.8956.8066.7196.6326.5456.4596.3736.2886.2036.1196.0365.9535.8715.7895.7085.6275.5475.4685.3895.3115.2335.1565.0805.0054.9304.8564.7824.7094.6374.5664.4964.4264.3574.2894.2224.1554.0904.0253.9623.8993.8373.7773.7173.6593.6013.5453.4903.4373.3853.3343.2853.2373.1913.1483.1063.0663.0302.9962.9672.94238.6318.5358.4398.3448.2498.1548.0607.9667.8737.7807.6877.5957.5047.4137.3227.2327.1427.0536.9656.8766.7896.7026.6156.5296.4436.3586.2736.1896.1066.0235.9415.8595.7785.6975.6175.5385.4595.3815.3035.2265.1505.0755.0004.9264.8524.7794.7074.6364.5664.4964.4274.3594.2924.2254.1604.0954.0323.9693.9073.8473.7873.7293.6713.6153.5603.5073.4553.4043.3553.3073.2613.2183.1763.1363.1003.0663.0373.0123.078.7018.6058.5098.4148.3198.2248.1308.0367.9437.8507.7577.6657.5747.4837.3927.3027.2127.1237.0356.9466.8596.7726.6856.5996.5136.4286.3436.2596.1766.0936.0115.9295.8485.7675.6875.6085.5295.4515.3735.2965.2205.1455.0704.9964.9224.8494.7774.7064.6364.5664.4974.4294.3624.2954.2304.1654.1024.0393.9773.9173.8573.7993.7413.6853.6303.5773.5253.4743.4253.3773.3313.2883.2463.2063.1703.1363.1073.0823.148.7718.6758.5798.4848.3898.2948.2008.1068.0137.9207.8277.7357.6447.5537.4627.3727.2827.1937.1057.0166.9296.8426.7556.6696.5836.4986.4136.3296.2466.1636.0815.9995.9185.8375.7575.6785.5995.5215.4435.3665.2905.2155.1405.0664.9924.9194.8474.7764.7064.6364.5674.4994.4324.3654.3004.2354.1724.1094.0473.9873.9273.8693.8113.7553.7003.6473.5953.5443.4953.4473.4013.3583.3163.2763.2403.2063.1773.1523.218.8418.7458.6498.5548.4598.3648.2708.1768.0837.9907.8977.8057.7147.6237.5327.4427.3527.2637.1757.0866.9996.9126.8256.7396.6536.5686.4836.3996.3166.2336.1516.0695.9885.9075.8275.7485.6695.5915.5135.4365.3605.2855.2105.1365.0624.9894.9174.8464.7764.7064.6374.5694.5024.4354.3704.3054.2424.1794.1174.0573.9973.9393.8813.8253.7703.7173.6653.6143.5653.5173.4713.4283.3863.3463.3103.2763.2473.2223.288.9118.8158.7198.6248.5298.4348.3408.2468.1538.0607.9677.8757.7847.6937.6027.5127.4227.3337.2457.1567.0696.9826.8956.8096.7236.6386.5536.4696.3866.3036.2216.1396.0585.9775.8975.8185.7395.6615.5835.5065.4305.3555.2805.2065.1325.0594.9874.9164.8464.7764.7074.6394.5724.5054.4404.3754.3124.2494.1874.1274.0674.0093.9513.8953.8403.7873.7353.6843.6353.5873.5413.4983.4563.4163.3803.3463.3173.2923.358.9818.8858.7898.6948.5998.5048.4108.3168.2238.1308.0377.9457.8547.7637.6727.5827.4927.4037.3157.2267.1397.0526.9656.8796.7936.7086.6236.5396.4566.3736.2916.2096.1286.0475.9675.8885.8095.7315.6535.5765.5005.4255.3505.2765.2025.1295.0574.9864.9164.8464.7774.7094.6424.5754.5104.4454.3824.3194.2574.1974.1374.0794.0213.9653.9103.8573.8053.7543.7053.6573.6113.5683.5263.4863.4503.4163.3873.3623.429.0518.9558.8598.7648.6698.5748.4808.3868.2938.2008.1078.0157.9247.8337.7427.6527.5627.4737.3857.2967.2097.1227.0356.9496.8636.7786.6936.6096.5266.4436.3616.2796.1986.1176.0375.9585.8795.8015.7235.6465.5705.4955.4205.3465.2725.1995.1275.0564.9864.9164.8474.7794.7124.6454.5804.5154.4524.3894.3274.2674.2074.1494.0914.0353.9803.9273.8753.8243.7753.7273.6813.6383.5963.5563.5203.4863.4573.4323.499.1219.0258.9298.8348.7398.6448.5508.4568.3638.2708.1778.0857.9947.9037.8127.7227.6327.5437.4557.3667.2797.1927.1057.0196.9336.8486.7636.6796.5966.5136.4316.3496.2686.1876.1076.0285.9495.8715.7935.7165.6405.5655.4905.4165.3425.2695.1975.1265.0564.9864.9174.8494.7824.7154.6504.5854.5224.4594.3974.3374.2774.2194.1614.1054.0503.9973.9453.8943.8453.7973.7513.7083.6663.6263.5903.5563.5273.5023.569.1919.0958.9998.9048.8098.7148.6208.5268.4338.3408.2478.1558.0647.9737.8827.7927.7027.6137.5257.4367.3497.2627.1757.0897.0036.9186.8336.7496.6666.5836.5016.4196.3386.2576.1776.0986.0195.9415.8635.7865.7105.6355.5605.4865.4125.3395.2675.1965.1265.0564.9874.9194.8524.7854.7204.6554.5924.5294.4674.4074.3474.2894.2314.1754.1204.0674.0153.9643.9153.8673.8213.7783.7363.6963.6603.6263.5973.5723.639.2619.1659.0698.9748.8798.7848.6908.5968.5038.4108.3178.2258.1348.0437.9527.8627.7727.6837.5957.5067.4197.3327.2457.1597.0736.9886.9036.8196.7366.6536.5716.4896.4086.3276.2476.1686.0896.0115.9335.8565.7805.7055.6305.5565.4825.4095.3375.2665.1965.1265.0574.9894.9224.8554.7904.7254.6624.5994.5374.4774.4174.3594.3014.2454.1904.1374.0854.0343.9853.9373.8913.8483.8063.7663.7303.6963.6673.6423.79.3319.2359.1399.0448.9498.8548.7608.6668.5738.4808.3878.2958.2048.1138.0227.9327.8427.7537.6657.5767.4897.4027.3157.2297.1437.0586.9736.8896.8066.7236.6416.5596.4786.3976.3176.2386.1596.0816.0035.9265.8505.7755.7005.6265.5525.4795.4075.3365.2665.1965.1275.0594.9924.9254.8604.7954.7324.6694.6074.5474.4874.4294.3714.3154.2604.2074.1554.1044.0554.0073.9613.9183.8763.8363.8003.7663.7373.7123.779.4019.3059.2099.1149.0198.9248.8308.7368.6438.5508.4578.3658.2748.1838.0928.0027.9127.8237.7357.6467.5597.4727.3857.2997.2137.1287.0436.9596.8766.7936.7116.6296.5486.4676.3876.3086.2296.1516.0735.9965.9205.8455.7705.6965.6225.5495.4775.4065.3365.2665.1975.1295.0624.9954.9304.8654.8024.7394.6774.6174.5574.4994.4414.3854.3304.2774.2254.1744.1254.0774.0313.9883.9463.9063.8703.8363.8073.7823.849.4719.3759.2799.1849.0898.9948.9008.8068.7138.6208.5278.4358.3448.2538.1628.0727.9827.8937.8057.7167.6297.5427.4557.3697.2837.1987.1137.0296.9466.8636.7816.6996.6186.5376.4576.3786.2996.2216.1436.0665.9905.9155.8405.7665.6925.6195.5475.4765.4065.3365.2675.1995.1325.0655.0004.9354.8724.8094.7474.6874.6274.5694.5114.4554.4004.3474.2954.2444.1954.1474.1014.0584.0163.9763.9403.9063.8773.8523.919.5419.4459.3499.2549.1599.0648.9708.8768.7838.6908.5978.5058.4148.3238.2328.1428.0527.9637.8757.7867.6997.6127.5257.4397.3537.2687.1837.0997.0166.9336.8516.7696.6886.6076.5276.4486.3696.2916.2136.1366.0605.9855.9105.8365.7625.6895.6175.5465.4765.4065.3375.2695.2025.1355.0705.0054.9424.8794.8174.7574.6974.6394.5814.5254.4704.4174.3654.3144.2654.2174.1714.1284.0864.0464.0103.9763.9473.9223.989.6119.5159.4199.3249.2299.1349.0408.9468.8538.7608.6678.5758.4848.3938.3028.2128.1228.0337.9457.8567.7697.6827.5957.5097.4237.3387.2537.1697.0867.0036.9216.8396.7586.6776.5976.5186.4396.3616.2836.2066.1306.0555.9805.9065.8325.7595.6875.6165.5465.4765.4075.3395.2725.2055.1405.0755.0124.9494.8874.8274.7674.7094.6514.5954.5404.4874.4354.3844.3354.2874.2414.1984.1564.1164.0804.0464.0173.9924.059.6819.5859.4899.3949.2999.2049.1109.0168.9238.8308.7378.6458.5548.4638.3728.2828.1928.1038.0157.9267.8397.7527.6657.5797.4937.4087.3237.2397.1567.0736.9916.9096.8286.7476.6676.5886.5096.4316.3536.2766.2006.1256.0505.9765.9025.8295.7575.6865.6165.5465.4775.4095.3425.2755.2105.1455.0825.0194.9574.8974.8374.7794.7214.6654.6104.5574.5054.4544.4054.3574.3114.2684.2264.1864.1504.1164.0874.0624.129.7519.6559.5599.4649.3699.2749.1809.0868.9938.9008.8078.7158.6248.5338.4428.3528.2628.1738.0857.9967.9097.8227.7357.6497.5637.4787.3937.3097.2267.1437.0616.9796.8986.8176.7376.6586.5796.5016.4236.3466.2706.1956.1206.0465.9725.8995.8275.7565.6865.6165.5475.4795.4125.3455.2805.2155.1525.0895.0274.9674.9074.8494.7914.7354.6804.6274.5754.5244.4754.4274.3814.3384.2964.2564.2204.1864.1574.1324.199.8219.7259.6299.5349.4399.3449.2509.1569.0638.9708.8778.7858.6948.6038.5128.4228.3328.2438.1558.0667.9797.8927.8057.7197.6337.5487.4637.3797.2967.2137.1317.0496.9686.8876.8076.7286.6496.5716.4936.4166.3406.2656.1906.1166.0425.9695.8975.8265.7565.6865.6175.5495.4825.4155.3505.2855.2225.1595.0975.0374.9774.9194.8614.8054.7504.6974.6454.5944.5454.4974.4514.4084.3664.3264.2904.2564.2274.2024.269.8919.7959.6999.6049.5099.4149.3209.2269.1339.0408.9478.8558.7648.6738.5828.4928.4028.3138.2258.1368.0497.9627.8757.7897.7037.6187.5337.4497.3667.2837.2017.1197.0386.9576.8776.7986.7196.6416.5636.4866.4106.3356.2606.1866.1126.0395.9675.8965.8265.7565.6875.6195.5525.4855.4205.3555.2925.2295.1675.1075.0474.9894.9314.8754.8204.7674.7154.6644.6154.5674.5214.4784.4364.3964.3604.3264.2974.2724.339.9619.8659.7699.6749.5799.4849.3909.2969.2039.1109.0178.9258.8348.7438.6528.5628.4728.3838.2958.2068.1198.0327.9457.8597.7737.6887.6037.5197.4367.3537.2717.1897.1087.0276.9476.8686.7896.7116.6336.5566.4806.4056.3306.2566.1826.1096.0375.9665.8965.8265.7575.6895.6225.5555.4905.4255.3625.2995.2375.1775.1175.0595.0014.9454.8904.8374.7854.7344.6854.6374.5914.5484.5064.4664.4304.3964.3674.3424.410.0319.9359.8399.7449.6499.5549.4609.3669.2739.1809.0878.9958.9048.8138.7228.6328.5428.4538.3658.2768.1898.1028.0157.9297.8437.7587.6737.5897.5067.4237.3417.2597.1787.0977.0176.9386.8596.7816.7036.6266.5506.4756.4006.3266.2526.1796.1076.0365.9665.8965.8275.7595.6925.6255.5605.4955.4325.3695.3075.2475.1875.1295.0715.0154.9604.9074.8554.8044.7554.7074.6614.6184.5764.5364.5004.4664.4374.4124.4710.10110.0059.9099.8149.7199.6249.5309.4369.3439.2509.1579.0658.9748.8838.7928.7028.6128.5238.4358.3468.2598.1728.0857.9997.9137.8287.7437.6597.5767.4937.4117.3297.2487.1677.0877.0086.9296.8516.7736.6966.6206.5456.4706.3966.3226.2496.1776.1066.0365.9665.8975.8295.7625.6955.6305.5655.5025.4395.3775.3175.2575.1995.1415.0855.0304.9774.9254.8744.8254.7774.7314.6884.6464.6064.5704.5364.5074.4824.5410.17110.0759.9799.8849.7899.6949.6009.5069.4139.3209.2279.1359.0448.9538.8628.7728.6828.5938.5058.4168.3298.2428.1558.0697.9837.8987.8137.7297.6467.5637.4817.3997.3187.2377.1577.0786.9996.9216.8436.7666.6906.6156.5406.4666.3926.3196.2476.1766.1066.0365.9675.8995.8325.7655.7005.6355.5725.5095.4475.3875.3275.2695.2115.1555.1005.0474.9954.9444.8954.8474.8014.7584.7164.6764.6404.6064.5774.5524.6110.24110.14510.0499.9549.8599.7649.6709.5769.4839.3909.2979.2059.1149.0238.9328.8428.7528.6638.5758.4868.3998.3128.2258.1398.0537.9687.8837.7997.7167.6337.5517.4697.3887.3077.2277.1487.0696.9916.9136.8366.7606.6856.6106.5366.4626.3896.3176.2466.1766.1066.0375.9695.9025.8355.7705.7055.6425.5795.5175.4575.3975.3395.2815.2255.1705.1175.0655.0144.9654.9174.8714.8284.7864.7464.7104.6764.6474.6224.6810.31110.21510.11910.0249.9299.8349.7409.6469.5539.4609.3679.2759.1849.0939.0028.9128.8228.7338.6458.5568.4698.3828.2958.2098.1238.0387.9537.8697.7867.7037.6217.5397.4587.3777.2977.2187.1397.0616.9836.9066.8306.7556.6806.6066.5326.4596.3876.3166.2466.1766.1076.0395.9725.9055.8405.7755.7125.6495.5875.5275.4675.4095.3515.2955.2405.1875.1355.0845.0354.9874.9414.8984.8564.8164.7804.7464.7174.6924.7510.38110.28510.18910.0949.9999.9049.8109.7169.6239.5309.4379.3459.2549.1639.0728.9828.8928.8038.7158.6268.5398.4528.3658.2798.1938.1088.0237.9397.8567.7737.6917.6097.5287.4477.3677.2887.2097.1317.0536.9766.9006.8256.7506.6766.6026.5296.4576.3866.3166.2466.1776.1096.0425.9755.9105.8455.7825.7195.6575.5975.5375.4795.4215.3655.3105.2575.2055.1545.1055.0575.0114.9684.9264.8864.8504.8164.7874.7624.8210.45110.35510.25910.16410.0699.9749.8809.7869.6939.6009.5079.4159.3249.2339.1429.0528.9628.8738.7858.6968.6098.5228.4358.3498.2638.1788.0938.0097.9267.8437.7617.6797.5987.5177.4377.3587.2797.2017.1237.0466.9706.8956.8206.7466.6726.5996.5276.4566.3866.3166.2476.1796.1126.0455.9805.9155.8525.7895.7275.6675.6075.5495.4915.4355.3805.3275.2755.2245.1755.1275.0815.0384.9964.9564.9204.8864.8574.8324.8910.52110.42510.32910.23410.13910.0449.9509.8569.7639.6709.5779.4859.3949.3039.2129.1229.0328.9438.8558.7668.6798.5928.5058.4198.3338.2488.1638.0797.9967.9137.8317.7497.6687.5877.5077.4287.3497.2717.1937.1167.0406.9656.8906.8166.7426.6696.5976.5266.4566.3866.3176.2496.1826.1156.0505.9855.9225.8595.7975.7375.6775.6195.5615.5055.4505.3975.3455.2945.2455.1975.1515.1085.0665.0264.9904.9564.9274.9024.9610.59110.49510.39910.30410.20910.11410.0209.9269.8339.7409.6479.5559.4649.3739.2829.1929.1029.0138.9258.8368.7498.6628.5758.4898.4038.3188.2338.1498.0667.9837.9017.8197.7387.6577.5777.4987.4197.3417.2637.1867.1107.0356.9606.8866.8126.7396.6676.5966.5266.4566.3876.3196.2526.1856.1206.0555.9925.9295.8675.8075.7475.6895.6315.5755.5205.4675.4155.3645.3155.2675.2215.1785.1365.0965.0605.0264.9974.9725.0310.66110.56510.46910.37410.27910.18410.0909.9969.9039.8109.7179.6259.5349.4439.3529.2629.1729.0838.9958.9068.8198.7328.6458.5598.4738.3888.3038.2198.1368.0537.9717.8897.8087.7277.6477.5687.4897.4117.3337.2567.1807.1057.0306.9566.8826.8096.7376.6666.5966.5266.4576.3896.3226.2556.1906.1256.0625.9995.9375.8775.8175.7595.7015.6455.5905.5375.4855.4345.3855.3375.2915.2485.2065.1665.1305.0965.0675.0425.110.73110.63510.53910.44410.34910.25410.16010.0669.9739.8809.7879.6959.6049.5139.4229.3329.2429.1539.0658.9768.8898.8028.7158.6298.5438.4588.3738.2898.2068.1238.0417.9597.8787.7977.7177.6387.5597.4817.4037.3267.2507.1757.1007.0266.9526.8796.8076.7366.6666.5966.5276.4596.3926.3256.2606.1956.1326.0696.0075.9475.8875.8295.7715.7155.6605.6075.5555.5045.4555.4075.3615.3185.2765.2365.2005.1665.1375.1125.1710.80110.70510.60910.51410.41910.32410.23010.13610.0439.9509.8579.7659.6749.5839.4929.4029.3129.2239.1359.0468.9598.8728.7858.6998.6138.5288.4438.3598.2768.1938.1118.0297.9487.8677.7877.7087.6297.5517.4737.3967.3207.2457.1707.0967.0226.9496.8776.8066.7366.6666.5976.5296.4626.3956.3306.2656.2026.1396.0776.0175.9575.8995.8415.7855.7305.6775.6255.5745.5255.4775.4315.3885.3465.3065.2705.2365.2075.1825.2410.87110.77510.67910.58410.48910.39410.30010.20610.11310.0209.9279.8359.7449.6539.5629.4729.3829.2939.2059.1169.0298.9428.8558.7698.6838.5988.5138.4298.3468.2638.1818.0998.0187.9377.8577.7787.6997.6217.5437.4667.3907.3157.2407.1667.0927.0196.9476.8766.8066.7366.6676.5996.5326.4656.4006.3356.2726.2096.1476.0876.0275.9695.9115.8555.8005.7475.6955.6445.5955.5475.5015.4585.4165.3765.3405.3065.2775.2525.3110.94110.84510.74910.65410.55910.46410.37010.27610.18310.0909.9979.9059.8149.7239.6329.5429.4529.3639.2759.1869.0999.0128.9258.8398.7538.6688.5838.4998.4168.3338.2518.1698.0888.0077.9277.8487.7697.6917.6137.5367.4607.3857.3107.2367.1627.0897.0176.9466.8766.8066.7376.6696.6026.5356.4706.4056.3426.2796.2176.1576.0976.0395.9815.9255.8705.8175.7655.7145.6655.6175.5715.5285.4865.4465.4105.3765.3475.3225.3811.01110.91510.81910.72410.62910.53410.44010.34610.25310.16010.0679.9759.8849.7939.7029.6129.5229.4339.3459.2569.1699.0828.9958.9098.8238.7388.6538.5698.4868.4038.3218.2398.1588.0777.9977.9187.8397.7617.6837.6067.5307.4557.3807.3067.2327.1597.0877.0166.9466.8766.8076.7396.6726.6056.5406.4756.4126.3496.2876.2276.1676.1096.0515.9955.9405.8875.8355.7845.7355.6875.6415.5985.5565.5165.4805.4465.4175.3925.4511.08110.98510.88910.79410.69910.60410.51010.41610.32310.23010.13710.0459.9549.8639.7729.6829.5929.5039.4159.3269.2399.1529.0658.9798.8938.8088.7238.6398.5568.4738.3918.3098.2288.1478.0677.9887.9097.8317.7537.6767.6007.5257.4507.3767.3027.2297.1577.0867.0166.9466.8776.8096.7426.6756.6106.5456.4826.4196.3576.2976.2376.1796.1216.0656.0105.9575.9055.8545.8055.7575.7115.6685.6265.5865.5505.5165.4875.4625.5211.15111.05510.95910.86410.76910.67410.58010.48610.39310.30010.20710.11510.0249.9339.8429.7529.6629.5739.4859.3969.3099.2229.1359.0498.9638.8788.7938.7098.6268.5438.4618.3798.2988.2178.1378.0587.9797.9017.8237.7467.6707.5957.5207.4467.3727.2997.2277.1567.0867.0166.9476.8796.8126.7456.6806.6156.5526.4896.4276.3676.3076.2496.1916.1356.0806.0275.9755.9245.8755.8275.7815.7385.6965.6565.6205.5865.5575.5325.5911.22111.12511.02910.93410.83910.74410.65010.55610.46310.37010.27710.18510.09410.0039.9129.8229.7329.6439.5559.4669.3799.2929.2059.1199.0338.9488.8638.7798.6968.6138.5318.4498.3688.2878.2078.1288.0497.9717.8937.8167.7407.6657.5907.5167.4427.3697.2977.2267.1567.0867.0176.9496.8826.8156.7506.6856.6226.5596.4976.4376.3776.3196.2616.2056.1506.0976.0455.9945.9455.8975.8515.8085.7665.7265.6905.6565.6275.6025.6611.29111.19511.09911.00410.90910.81410.72010.62610.53310.44010.34710.25510.16410.0739.9829.8929.8029.7139.6259.5369.4499.3629.2759.1899.1039.0188.9338.8498.7668.6838.6018.5198.4388.3578.2778.1988.1198.0417.9637.8867.8107.7357.6607.5867.5127.4397.3677.2967.2267.1567.0877.0196.9526.8856.8206.7556.6926.6296.5676.5076.4476.3896.3316.2756.2206.1676.1156.0646.0155.9675.9215.8785.8365.7965.7605.7265.6975.6725.7311.36111.26511.16911.07410.97910.88410.79010.69610.60310.51010.41710.32510.23410.14310.0529.9629.8729.7839.6959.6069.5199.4329.3459.2599.1739.0889.0038.9198.8368.7538.6718.5898.5088.4278.3478.2688.1898.1118.0337.9567.8807.8057.7307.6567.5827.5097.4377.3667.2967.2267.1577.0897.0226.9556.8906.8256.7626.6996.6376.5776.5176.4596.4016.3456.2906.2376.1856.1346.0856.0375.9915.9485.9065.8665.8305.7965.7675.7425.811.43111.33511.23911.14411.04910.95410.86010.76610.67310.58010.48710.39510.30410.21310.12210.0329.9429.8539.7659.6769.5899.5029.4159.3299.2439.1589.0738.9898.9068.8238.7418.6598.5788.4978.4178.3388.2598.1818.1038.0267.9507.8757.8007.7267.6527.5797.5077.4367.3667.2967.2277.1597.0927.0256.9606.8956.8326.7696.7076.6476.5876.5296.4716.4156.3606.3076.2556.2046.1556.1076.0616.0185.9765.9365.9005.8665.8375.8125.8711.50111.40511.30911.21411.11911.02410.93010.83610.74310.65010.55710.46510.37410.28310.19210.10210.0129.9239.8359.7469.6599.5729.4859.3999.3139.2289.1439.0598.9768.8938.8118.7298.6488.5678.4878.4088.3298.2518.1738.0968.0207.9457.8707.7967.7227.6497.5777.5067.4367.3667.2977.2297.1627.0957.0306.9656.9026.8396.7776.7176.6576.5996.5416.4856.4306.3776.3256.2746.2256.1776.1316.0886.0466.0065.9705.9365.9075.8825.9411.57111.47511.37911.28411.18911.09411.00010.90610.81310.72010.62710.53510.44410.35310.26210.17210.0829.9939.9059.8169.7299.6429.5559.4699.3839.2989.2139.1299.0468.9638.8818.7998.7188.6378.5578.4788.3998.3218.2438.1668.0908.0157.9407.8667.7927.7197.6477.5767.5067.4367.3677.2997.2327.1657.1007.0356.9726.9096.8476.7876.7276.6696.6116.5556.5006.4476.3956.3446.2956.2476.2016.1586.1166.0766.0406.0065.9775.9526.0111.64111.54511.44911.35411.25911.16411.07010.97610.88310.79010.69710.60510.51410.42310.33210.24210.15210.0639.9759.8869.7999.7129.6259.5399.4539.3689.2839.1999.1169.0338.9518.8698.7888.7078.6278.5488.4698.3918.3138.2368.1608.0858.0107.9367.8627.7897.7177.6467.5767.5067.4377.3697.3027.2357.1707.1057.0426.9796.9176.8576.7976.7396.6816.6256.5706.5176.4656.4146.3656.3176.2716.2286.1866.1466.1106.0766.0476.0226.0811.71111.61511.51911.42411.32911.23411.14011.04610.95310.86010.76710.67510.58410.49310.40210.31210.22210.13310.0459.9569.8699.7829.6959.6099.5239.4389.3539.2699.1869.1039.0218.9398.8588.7778.6978.6188.5398.4618.3838.3068.2308.1558.0808.0067.9327.8597.7877.7167.6467.5767.5077.4397.3727.3057.2407.1757.1127.0496.9876.9276.8676.8096.7516.6956.6406.5876.5356.4846.4356.3876.3416.2986.2566.2166.1806.1466.1176.0926.1511.78111.68511.58911.49411.39911.30411.21011.11611.02310.93010.83710.74510.65410.56310.47210.38210.29210.20310.11510.0269.9399.8529.7659.6799.5939.5089.4239.3399.2569.1739.0919.0098.9288.8478.7678.6888.6098.5318.4538.3768.3008.2258.1508.0768.0027.9297.8577.7867.7167.6467.5777.5097.4427.3757.3107.2457.1827.1197.0576.9976.9376.8796.8216.7656.7106.6576.6056.5546.5056.4576.4116.3686.3266.2866.2506.2166.1876.1626.2211.85111.75511.65911.56411.46911.37411.28011.18611.09311.00010.90710.81510.72410.63310.54210.45210.36210.27310.18510.09610.0099.9229.8359.7499.6639.5789.4939.4099.3269.2439.1619.0798.9988.9178.8378.7588.6798.6018.5238.4468.3708.2958.2208.1468.0727.9997.9277.8567.7867.7167.6477.5797.5127.4457.3807.3157.2527.1897.1277.0677.0076.9496.8916.8356.7806.7276.6756.6246.5756.5276.4816.4386.3966.3566.3206.2866.2576.2326.2911.92111.82511.72911.63411.53911.44411.35011.25611.16311.07010.97710.88510.79410.70310.61210.52210.43210.34310.25510.16610.0799.9929.9059.8199.7339.6489.5639.4799.3969.3139.2319.1499.0688.9878.9078.8288.7498.6718.5938.5168.4408.3658.2908.2168.1428.0697.9977.9267.8567.7867.7177.6497.5827.5157.4507.3857.3227.2597.1977.1377.0777.0196.9616.9056.8506.7976.7456.6946.6456.5976.5516.5086.4666.4266.3906.3566.3276.3026.3611.99111.89511.79911.70411.60911.51411.42011.32611.23311.14011.04710.95510.86410.77310.68210.59210.50210.41310.32510.23610.14910.0629.9759.8899.8039.7189.6339.5499.4669.3839.3019.2199.1389.0578.9778.8988.8198.7418.6638.5868.5108.4358.3608.2868.2128.1398.0677.9967.9267.8567.7877.7197.6527.5857.5207.4557.3927.3297.2677.2077.1477.0897.0316.9756.9206.8676.8156.7646.7156.6676.6216.5786.5366.4966.4606.4266.3976.3726.4312.06111.96511.86911.77411.67911.58411.49011.39611.30311.21011.11711.02510.93410.84310.75210.66210.57210.48310.39510.30610.21910.13210.0459.9599.8739.7889.7039.6199.5369.4539.3719.2899.2089.1279.0478.9688.8898.8118.7338.6568.5808.5058.4308.3568.2828.2098.1378.0667.9967.9267.8577.7897.7227.6557.5907.5257.4627.3997.3377.2777.2177.1597.1017.0456.9906.9376.8856.8346.7856.7376.6916.6486.6066.5666.5306.4966.4676.4426.512.13112.03511.93911.84411.74911.65411.56011.46611.37311.28011.18711.09511.00410.91310.82210.73210.64210.55310.46510.37610.28910.20210.11510.0299.9439.8589.7739.6899.6069.5239.4419.3599.2789.1979.1179.0388.9598.8818.8038.7268.6508.5758.5008.4268.3528.2798.2078.1368.0667.9967.9277.8597.7927.7257.6607.5957.5327.4697.4077.3477.2877.2297.1717.1157.0607.0076.9556.9046.8556.8076.7616.7186.6766.6366.6006.5666.5376.5126.5712.20112.10512.00911.91411.81911.72411.63011.53611.44311.35011.25711.16511.07410.98310.89210.80210.71210.62310.53510.44610.35910.27210.18510.09910.0139.9289.8439.7599.6769.5939.5119.4299.3489.2679.1879.1089.0298.9518.8738.7968.7208.6458.5708.4968.4228.3498.2778.2068.1368.0667.9977.9297.8627.7957.7307.6657.6027.5397.4777.4177.3577.2997.2417.1857.1307.0777.0256.9746.9256.8776.8316.7886.7466.7066.6706.6366.6076.5826.6412.27112.17512.07911.98411.88911.79411.70011.60611.51311.42011.32711.23511.14411.05310.96210.87210.78210.69310.60510.51610.42910.34210.25510.16910.0839.9989.9139.8299.7469.6639.5819.4999.4189.3379.2579.1789.0999.0218.9438.8668.7908.7158.6408.5668.4928.4198.3478.2768.2068.1368.0677.9997.9327.8657.8007.7357.6727.6097.5477.4877.4277.3697.3117.2557.2007.1477.0957.0446.9956.9476.9016.8586.8166.7766.7406.7066.6776.6526.7112.34112.24512.14912.05411.95911.86411.77011.67611.58311.49011.39711.30511.21411.12311.03210.94210.85210.76310.67510.58610.49910.41210.32510.23910.15310.0689.9839.8999.8169.7339.6519.5699.4889.4079.3279.2489.1699.0919.0138.9368.8608.7858.7108.6368.5628.4898.4178.3468.2768.2068.1378.0698.0027.9357.8707.8057.7427.6797.6177.5577.4977.4397.3817.3257.2707.2177.1657.1147.0657.0176.9716.9286.8866.8466.8106.7766.7476.7226.7812.41112.31512.21912.12412.02911.93411.84011.74611.65311.56011.46711.37511.28411.19311.10211.01210.92210.83310.74510.65610.56910.48210.39510.30910.22310.13810.0539.9699.8869.8039.7219.6399.5589.4779.3979.3189.2399.1619.0839.0068.9308.8558.7808.7068.6328.5598.4878.4168.3468.2768.2078.1398.0728.0057.9407.8757.8127.7497.6877.6277.5677.5097.4517.3957.3407.2877.2357.1847.1357.0877.0416.9986.9566.9166.8806.8466.8176.7926.8512.48112.38512.28912.19412.09912.00411.91011.81611.72311.63011.53711.44511.35411.26311.17211.08210.99210.90310.81510.72610.63910.55210.46510.37910.29310.20810.12310.0399.9569.8739.7919.7099.6289.5479.4679.3889.3099.2319.1539.0769.0008.9258.8508.7768.7028.6298.5578.4868.4168.3468.2778.2098.1428.0758.0107.9457.8827.8197.7577.6977.6377.5797.5217.4657.4107.3577.3057.2547.2057.1577.1117.0687.0266.9866.9506.9166.8876.8626.9212.55112.45512.35912.26412.16912.07411.98011.88611.79311.70011.60711.51511.42411.33311.24211.15211.06210.97310.88510.79610.70910.62210.53510.44910.36310.27810.19310.10910.0269.9439.8619.7799.6989.6179.5379.4589.3799.3019.2239.1469.0708.9958.9208.8468.7728.6998.6278.5568.4868.4168.3478.2798.2128.1458.0808.0157.9527.8897.8277.7677.7077.6497.5917.5357.4807.4277.3757.3247.2757.2277.1817.1387.0967.0567.0206.9866.9576.9326.9912.62112.52512.42912.33412.23912.14412.05011.95611.86311.77011.67711.58511.49411.40311.31211.22211.13211.04310.95510.86610.77910.69210.60510.51910.43310.34810.26310.17910.09610.0139.9319.8499.7689.6879.6079.5289.4499.3719.2939.2169.1409.0658.9908.9168.8428.7698.6978.6268.5568.4868.4178.3498.2828.2158.1508.0858.0227.9597.8977.8377.7777.7197.6617.6057.5507.4977.4457.3947.3457.2977.2517.2087.1667.1267.0907.0567.0277.0027.0612.69112.59512.49912.40412.30912.21412.12012.02611.93311.84011.74711.65511.56411.47311.38211.29211.20211.11311.02510.93610.84910.76210.67510.58910.50310.41810.33310.24910.16610.08310.0019.9199.8389.7579.6779.5989.5199.4419.3639.2869.2109.1359.0608.9868.9128.8398.7678.6968.6268.5568.4878.4198.3528.2858.2208.1558.0928.0297.9677.9077.8477.7897.7317.6757.6207.5677.5157.4647.4157.3677.3217.2787.2367.1967.1607.1267.0977.0727.1312.76112.66512.56912.47412.37912.28412.19012.09612.00311.91011.81711.72511.63411.54311.45211.36211.27211.18311.09511.00610.91910.83210.74510.65910.57310.48810.40310.31910.23610.15310.0719.9899.9089.8279.7479.6689.5899.5119.4339.3569.2809.2059.1309.0568.9828.9098.8378.7668.6968.6268.5578.4898.4228.3558.2908.2258.1628.0998.0377.9777.9177.8597.8017.7457.6907.6377.5857.5347.4857.4377.3917.3487.3067.2667.2307.1967.1677.1427.212.83112.73512.63912.54412.44912.35412.26012.16612.07311.98011.88711.79511.70411.61311.52211.43211.34211.25311.16511.07610.98910.90210.81510.72910.64310.55810.47310.38910.30610.22310.14110.0599.9789.8979.8179.7389.6599.5819.5039.4269.3509.2759.2009.1269.0528.9798.9078.8368.7668.6968.6278.5598.4928.4258.3608.2958.2328.1698.1078.0477.9877.9297.8717.8157.7607.7077.6557.6047.5557.5077.4617.4187.3767.3367.3007.2667.2377.2127.2712.90112.80512.70912.61412.51912.42412.33012.23612.14312.05011.95711.86511.77411.68311.59211.50211.41211.32311.23511.14611.05910.97210.88510.79910.71310.62810.54310.45910.37610.29310.21110.12910.0489.9679.8879.8089.7299.6519.5739.4969.4209.3459.2709.1969.1229.0498.9778.9068.8368.7668.6978.6298.5628.4958.4308.3658.3028.2398.1778.1178.0577.9997.9417.8857.8307.7777.7257.6747.6257.5777.5317.4887.4467.4067.3707.3367.3077.2827.3412.97112.87512.77912.68412.58912.49412.40012.30612.21312.12012.02711.93511.84411.75311.66211.57211.48211.39311.30511.21611.12911.04210.95510.86910.78310.69810.61310.52910.44610.36310.28110.19910.11810.0379.9579.8789.7999.7219.6439.5669.4909.4159.3409.2669.1929.1199.0478.9768.9068.8368.7678.6998.6328.5658.5008.4358.3728.3098.2478.1878.1278.0698.0117.9557.9007.8477.7957.7447.6957.6477.6017.5587.5167.4767.4407.4067.3777.3527.4113.04112.94512.84912.75412.65912.56412.47012.37612.28312.19012.09712.00511.91411.82311.73211.64211.55211.46311.37511.28611.19911.11211.02510.93910.85310.76810.68310.59910.51610.43310.35110.26910.18810.10710.0279.9489.8699.7919.7139.6369.5609.4859.4109.3369.2629.1899.1179.0468.9768.9068.8378.7698.7028.6358.5708.5058.4428.3798.3178.2578.1978.1398.0818.0257.9707.9177.8657.8147.7657.7177.6717.6287.5867.5467.5107.4767.4477.4227.4813.11113.01512.91912.82412.72912.63412.54012.44612.35312.26012.16712.07511.98411.89311.80211.71211.62211.53311.44511.35611.26911.18211.09511.00910.92310.83810.75310.66910.58610.50310.42110.33910.25810.17710.09710.0189.9399.8619.7839.7069.6309.5559.4809.4069.3329.2599.1879.1169.0468.9768.9078.8398.7728.7058.6408.5758.5128.4498.3878.3278.2678.2098.1518.0958.0407.9877.9357.8847.8357.7877.7417.6987.6567.6167.5807.5467.5177.4927.5513.18113.08512.98912.89412.79912.70412.61012.51612.42312.33012.23712.14512.05411.96311.87211.78211.69211.60311.51511.42611.33911.25211.16511.07910.99310.90810.82310.73910.65610.57310.49110.40910.32810.24710.16710.08810.0099.9319.8539.7769.7009.6259.5509.4769.4029.3299.2579.1869.1169.0468.9778.9098.8428.7758.7108.6458.5828.5198.4578.3978.3378.2798.2218.1658.1108.0578.0057.9547.9057.8577.8117.7687.7267.6867.6507.6167.5877.5627.6213.25113.15513.05912.96412.86912.77412.68012.58612.49312.40012.30712.21512.12412.03311.94211.85211.76211.67311.58511.49611.40911.32211.23511.14911.06310.97810.89310.80910.72610.64310.56110.47910.39810.31710.23710.15810.07910.0019.9239.8469.7709.6959.6209.5469.4729.3999.3279.2569.1869.1169.0478.9798.9128.8458.7808.7158.6528.5898.5278.4678.4078.3498.2918.2358.1808.1278.0758.0247.9757.9277.8817.8387.7967.7567.7207.6867.6577.6327.6913.32113.22513.12913.03412.93912.84412.75012.65612.56312.47012.37712.28512.19412.10312.01211.92211.83211.74311.65511.56611.47911.39211.30511.21911.13311.04810.96310.87910.79610.71310.63110.54910.46810.38710.30710.22810.14910.0719.9939.9169.8409.7659.6909.6169.5429.4699.3979.3269.2569.1869.1179.0498.9828.9158.8508.7858.7228.6598.5978.5378.4778.4198.3618.3058.2508.1978.1458.0948.0457.9977.9517.9087.8667.8267.7907.7567.7277.7027.7613.39113.29513.19913.10413.00912.91412.82012.72612.63312.54012.44712.35512.26412.17312.08211.99211.90211.81311.72511.63611.54911.46211.37511.28911.20311.11811.03310.94910.86610.78310.70110.61910.53810.45710.37710.29810.21910.14110.0639.9869.9109.8359.7609.6869.6129.5399.4679.3969.3269.2569.1879.1199.0528.9858.9208.8558.7928.7298.6678.6078.5478.4898.4318.3758.3208.2678.2158.1648.1158.0678.0217.9787.9367.8967.8607.8267.7977.7727.8313.46113.36513.26913.17413.07912.98412.89012.79612.70312.61012.51712.42512.33412.24312.15212.06211.97211.88311.79511.70611.61911.53211.44511.35911.27311.18811.10311.01910.93610.85310.77110.68910.60810.52710.44710.36810.28910.21110.13310.0569.9809.9059.8309.7569.6829.6099.5379.4669.3969.3269.2579.1899.1229.0558.9908.9258.8628.7998.7378.6778.6178.5598.5018.4458.3908.3378.2858.2348.1858.1378.0918.0488.0067.9667.9307.8967.8677.8427.913.53113.43513.33913.24413.14913.05412.96012.86612.77312.68012.58712.49512.40412.31312.22212.13212.04211.95311.86511.77611.68911.60211.51511.42911.34311.25811.17311.08911.00610.92310.84110.75910.67810.59710.51710.43810.35910.28110.20310.12610.0509.9759.9009.8269.7529.6799.6079.5369.4669.3969.3279.2599.1929.1259.0608.9958.9328.8698.8078.7478.6878.6298.5718.5158.4608.4078.3558.3048.2558.2078.1618.1188.0768.0368.0007.9667.9377.9127.9713.60113.50513.40913.31413.21913.12413.03012.93612.84312.75012.65712.56512.47412.38312.29212.20212.11212.02311.93511.84611.75911.67211.58511.49911.41311.32811.24311.15911.07610.99310.91110.82910.74810.66710.58710.50810.42910.35110.27310.19610.12010.0459.9709.8969.8229.7499.6779.6069.5369.4669.3979.3299.2629.1959.1309.0659.0028.9398.8778.8178.7578.6998.6418.5858.5308.4778.4258.3748.3258.2778.2318.1888.1468.1068.0708.0368.0077.9828.0413.67113.57513.47913.38413.28913.19413.10013.00612.91312.82012.72712.63512.54412.45312.36212.27212.18212.09312.00511.91611.82911.74211.65511.56911.48311.39811.31311.22911.14611.06310.98110.89910.81810.73710.65710.57810.49910.42110.34310.26610.19010.11510.0409.9669.8929.8199.7479.6769.6069.5369.4679.3999.3329.2659.2009.1359.0729.0098.9478.8878.8278.7698.7118.6558.6008.5478.4958.4448.3958.3478.3018.2588.2168.1768.1408.1068.0778.0528.1113.74113.64513.54913.45413.35913.26413.17013.07612.98312.89012.79712.70512.61412.52312.43212.34212.25212.16312.07511.98611.89911.81211.72511.63911.55311.46811.38311.29911.21611.13311.05110.96910.88810.80710.72710.64810.56910.49110.41310.33610.26010.18510.11010.0369.9629.8899.8179.7469.6769.6069.5379.4699.4029.3359.2709.2059.1429.0799.0178.9578.8978.8398.7818.7258.6708.6178.5658.5148.4658.4178.3718.3288.2868.2468.2108.1768.1478.1228.1813.81113.71513.61913.52413.42913.33413.24013.14613.05312.96012.86712.77512.68412.59312.50212.41212.32212.23312.14512.05611.96911.88211.79511.70911.62311.53811.45311.36911.28611.20311.12111.03910.95810.87710.79710.71810.63910.56110.48310.40610.33010.25510.18010.10610.0329.9599.8879.8169.7469.6769.6079.5399.4729.4059.3409.2759.2129.1499.0879.0278.9678.9098.8518.7958.7408.6878.6358.5848.5358.4878.4418.3988.3568.3168.2808.2468.2178.1928.2513.88113.78513.68913.59413.49913.40413.31013.21613.12313.03012.93712.84512.75412.66312.57212.48212.39212.30312.21512.12612.03911.95211.86511.77911.69311.60811.52311.43911.35611.27311.19111.10911.02810.94710.86710.78810.70910.63110.55310.47610.40010.32510.25010.17610.10210.0299.9579.8869.8169.7469.6779.6099.5429.4759.4109.3459.2829.2199.1579.0979.0378.9798.9218.8658.8108.7578.7058.6548.6058.5578.5118.4688.4268.3868.3508.3168.2878.2628.3213.95113.85513.75913.66413.56913.47413.38013.28613.19313.10013.00712.91512.82412.73312.64212.55212.46212.37312.28512.19612.10912.02211.93511.84911.76311.67811.59311.50911.42611.34311.26111.17911.09811.01710.93710.85810.77910.70110.62310.54610.47010.39510.32010.24610.17210.09910.0279.9569.8869.8169.7479.6799.6129.5459.4809.4159.3529.2899.2279.1679.1079.0498.9918.9358.8808.8278.7758.7248.6758.6278.5818.5388.4968.4568.4208.3868.3578.3328.3914.02113.92513.82913.73413.63913.54413.45013.35613.26313.17013.07712.98512.89412.80312.71212.62212.53212.44312.35512.26612.17912.09212.00511.91911.83311.74811.66311.57911.49611.41311.33111.24911.16811.08711.00710.92810.84910.77110.69310.61610.54010.46510.39010.31610.24210.16910.09710.0269.9569.8869.8179.7499.6829.6159.5509.4859.4229.3599.2979.2379.1779.1199.0619.0058.9508.8978.8458.7948.7458.6978.6518.6088.5668.5268.4908.4568.4278.4028.4614.09113.99513.89913.80413.70913.61413.52013.42613.33313.24013.14713.05512.96412.87312.78212.69212.60212.51312.42512.33612.24912.16212.07511.98911.90311.81811.73311.64911.56611.48311.40111.31911.23811.15711.07710.99810.91910.84110.76310.68610.61010.53510.46010.38610.31210.23910.16710.09610.0269.9569.8879.8199.7529.6859.6209.5559.4929.4299.3679.3079.2479.1899.1319.0759.0208.9678.9158.8648.8158.7678.7218.6788.6368.5968.5608.5268.4978.4728.5314.16114.06513.96913.87413.77913.68413.59013.49613.40313.31013.21713.12513.03412.94312.85212.76212.67212.58312.49512.40612.31912.23212.14512.05911.97311.88811.80311.71911.63611.55311.47111.38911.30811.22711.14711.06810.98910.91110.83310.75610.68010.60510.53010.45610.38210.30910.23710.16610.09610.0269.9579.8899.8229.7559.6909.6259.5629.4999.4379.3779.3179.2599.2019.1459.0909.0378.9858.9348.8858.8378.7918.7488.7068.6668.6308.5968.5678.5428.614.23114.13514.03913.94413.84913.75413.66013.56613.47313.38013.28713.19513.10413.01312.92212.83212.74212.65312.56512.47612.38912.30212.21512.12912.04311.95811.87311.78911.70611.62311.54111.45911.37811.29711.21711.13811.05910.98110.90310.82610.75010.67510.60010.52610.45210.37910.30710.23610.16610.09610.0279.9599.8929.8259.7609.6959.6329.5699.5079.4479.3879.3299.2719.2159.1609.1079.0559.0048.9558.9078.8618.8188.7768.7368.7008.6668.6378.6128.6714.30114.20514.10914.01413.91913.82413.73013.63613.54313.45013.35713.26513.17413.08312.99212.90212.81212.72312.63512.54612.45912.37212.28512.19912.11312.02811.94311.85911.77611.69311.61111.52911.44811.36711.28711.20811.12911.05110.97310.89610.82010.74510.67010.59610.52210.44910.37710.30610.23610.16610.09710.0299.9629.8959.8309.7659.7029.6399.5779.5179.4579.3999.3419.2859.2309.1779.1259.0749.0258.9778.9318.8888.8468.8068.7708.7368.7078.6828.7414.37114.27514.17914.08413.98913.89413.80013.70613.61313.52013.42713.33513.24413.15313.06212.97212.88212.79312.70512.61612.52912.44212.35512.26912.18312.09812.01311.92911.84611.76311.68111.59911.51811.43711.35711.27811.19911.12111.04310.96610.89010.81510.74010.66610.59210.51910.44710.37610.30610.23610.16710.09910.0329.9659.9009.8359.7729.7099.6479.5879.5279.4699.4119.3559.3009.2479.1959.1449.0959.0479.0018.9588.9168.8768.8408.8068.7778.7528.8114.44114.34514.24914.15414.05913.96413.87013.77613.68313.59013.49713.40513.31413.22313.13213.04212.95212.86312.77512.68612.59912.51212.42512.33912.25312.16812.08311.99911.91611.83311.75111.66911.58811.50711.42711.34811.26911.19111.11311.03610.96010.88510.81010.73610.66210.58910.51710.44610.37610.30610.23710.16910.10210.0359.9709.9059.8429.7799.7179.6579.5979.5399.4819.4259.3709.3179.2659.2149.1659.1179.0719.0288.9868.9468.9108.8768.8478.8228.8814.51114.41514.31914.22414.12914.03413.94013.84613.75313.66013.56713.47513.38413.29313.20213.11213.02212.93312.84512.75612.66912.58212.49512.40912.32312.23812.15312.06911.98611.90311.82111.73911.65811.57711.49711.41811.33911.26111.18311.10611.03010.95510.88010.80610.73210.65910.58710.51610.44610.37610.30710.23910.17210.10510.0409.9759.9129.8499.7879.7279.6679.6099.5519.4959.4409.3879.3359.2849.2359.1879.1419.0989.0569.0168.9808.9468.9178.8928.9514.58114.48514.38914.29414.19914.10414.01013.91613.82313.73013.63713.54513.45413.36313.27213.18213.09213.00312.91512.82612.73912.65212.56512.47912.39312.30812.22312.13912.05611.97311.89111.80911.72811.64711.56711.48811.40911.33111.25311.17611.10011.02510.95010.87610.80210.72910.65710.58610.51610.44610.37710.30910.24210.17510.11010.0459.9829.9199.8579.7979.7379.6799.6219.5659.5109.4579.4059.3549.3059.2579.2119.1689.1269.0869.0509.0168.9878.962

3Control de gastos por viticosPara realizar los clculos correspondientes, puede modificar la planilla a su conveniencia, agregando o realizando clculos intermedios.ERROR:#VALUE!b) Obtener el valor de las horas totales de cada empleado.c) Calcular el Importe tomando en cuenta la cantidad de horas obtenidas y el precio por hora establecido.d) Al final de la tabla en una columna rotulada como Cdigo, se debe mostrar un cdigo identificatorio para los empleados. El mismo que se formar, con los dos primeros caracteres del Apellido, ms los dos caracteres de la Dependencia y los dos ltimos dgitos del Nmero de cobro.Valor vitico por hora =$ 25.00NombreApellidoDependenciaFecha ingresoNro cobroFecha salidaHora salidaFecha llegadaHora llegadaTotal de horasImporteCdigoJuanSellanesVentas6/15/9811017/8/06157/9/061726$650.0SeVe01MariaBaezTcnico7/6/0311027/11/06217/17/0614137$3,425.0BaT02JoseGimenezDireccion12/12/0211037/15/0607/19/066102$2,550.0GiDi03MarioGomezAdministrador2/5/0011047/9/06157/15/0619148$3,700.0GoAd04CeciliaPerezVentas2/25/0511057/14/06137/15/061526$650.0PeVe05LauraDiazTcnico8/3/0411066/26/06207/17/0614498$12,450.0DiT06JuanaPeraltaDireccion9/27/0111076/27/06157/18/0623512$12,800.0PeDi07WalterGonzalesAdministrador1/18/0611086/28/0627/17/0617471$11,775.0GoAd08MarianaRuizVentas3/26/0611097/15/0637/17/061459$1,475.0RuVe09PabloAlmironTcnico5/20/0311107/14/0697/19/0623134$3,350.0AlT10DianaLopezDireccion1/28/0311117/11/0687/13/061959$1,475.0LoDi11FernandaGarciaAdministrador3/23/0011127/9/06127/17/0617197$4,925.0GaAd12MonicaRoblesVentas7/14/0411137/8/06197/19/0615260$6,500.0RoVe13MauricioPerezVentas9/19/0411146/28/06177/15/0614405$10,125.0PeVe14MarcoGomezTcnico11/13/0111156/27/06167/15/0614430$10,750.0GoT15LeticiaGonzalesDireccion7/24/0111166/26/0647/17/0614514$12,850.0GoDi16JuanPerezAdministrador9/17/9811176/28/0687/18/0623495$12,375.0PeAd17MariaGomezVentas1/8/0311187/15/0647/17/061963$1,575.0GoVe18JoseGonzalesTcnico3/16/0311197/14/06237/17/061766$1,650.0GoT19SilviaSosaAdministrador5/9/0011207/21/06187/23/061444$1,100.0SoAd20

4Tema: Operaciones y funcionesSe desea conocer lo siguiente:a) Cantidad de abstenciones y votos a favor de ambos candidatosAbst.Cand.1Cand.2201218PersonaRespuestaCandidatob) Porcentaje de votos a favor del candidato 11SI140.0%2SI13NO24SI25SI16NO1c) Porcentaje de votos a favor del candidato 27NO260.00%8NO19SI2d) Realiza dos grficas para mostrar los resultados recin calculados.10SI211NO212NO213NO114NO215NO216SI117SI218NO219NO220NO221NO122SI223SI124NO125NO226NO127NO128NO229NO230NO2

Objetivos: Simular una encuesta de votacin aplicada a 30 personas sobre 2 candidatos.Indicaciones: Las elecciones presidenciales estn prximas a realizarse en cierto pas. Como es la segunda ronda, solamente hay dos candidatos (1 y 2).Se ha realizado una encuesta y los datos obtenidos por ella deben ser mostrados en la tabla. Para ello complete las columnas de la tabla, considerando que: Persona es el nmero de personas encuestadas, Respuesta es igual a Si, en caso que la persona si piensa votar y No si piensa abstenerse. En caso de que la persona piense votar, Candidato indica por qu candidato piensa votar (1 2).Adems, calcule los datos que se piden en los incisos.Porcentajes con respecto al total de personas que votaronTotal de encuestados 30Generar una serie lineal

1 candidato 12 candidato 2Forma aleatoriaNO, no votaSI, si piensa votarForma Aleatoria

5Tema: FuncionesLa tabla de parte inferior es el registro de ventas realizadas por varias vendedoras entre los aos 2004 y 2011 en varias regiones del un pas.Escriba las correspondientes funciones para calcular lo siguiente:a)ERROR:#VALUE!30b)ERROR:#VALUE!50c)Cuntas veces Martha en el ao 2010 vendi ms unidades del promedio.4d)d) Cuantas ventas ($) de delineador de ojos del ao 2011.$ 12,463.54e)Cul es el valor vendido ms alto?2877.61f)Cul es el valor vendido ms bajo?2.87Nmero transaccinNombreFechaProductoUnidades VendidasValorReginAo962Angel1/19/06mascara5000$2,241.34sur20061088Cecilia4/25/06mascara500$1,519.62medio oeste20061838Angel9/11/09crema base520$1,581.76este20091793Cristina12/10/10brillo de labios660$2,001.25oeste20101555Carmen2/2/06brillo de labios480$1,459.09sur20061224Sofa12/4/08delineador de ojos80$221.47este200852Andrea3/25/05delineador de ojos830$2,503.33medio oeste20051378Andrea2/14/07delineador de ojos90$293.69sur20071531Martha2/11/06lpiz labial800$2,421.60sur2006643Andrea8/18/06lpiz labial100$318.42sur2006807Helena1/20/11delineador de ojos670$2,035.43este2011399Angel4/20/08delineador de ojos300$922.93medio oeste2008591Cecilia5/3/05lpiz labial100$284.64oeste2005220Angel5/6/10mascara270$831.95oeste20101817Cecilia6/27/07crema base620$1,875.12oeste20071655Angel1/15/11brillo de labios250$775.54oeste20111332Angel7/11/07brillo de labios130$419.24medio oeste2007603Angel12/23/06mascara240$742.83sur2006707Cristina5/9/11crema base780$2,353.77medio oeste2011381Cristina12/25/10mascara200$621.83oeste2010448Carmen4/30/09mascara40$141.70este2009888Cristina11/11/07mascara870$2,627.59medio oeste20071558Cristina3/11/08mascara440$1,341.89oeste2008722Camila1/12/10delineador de ojos750$2,269.87este2010317Camila10/27/07delineador de ojos1$16.05este2007991Camila1/31/09delineador de ojos10$10.16medio oeste200977Camila2/17/06mascara270$832.91este20061054Sofa11/16/04delineador de ojos20$83.44sur2004593Camila7/29/05crema base940$2,846.13este2005712Andrea3/4/10crema base380$1,162.02medio oeste2010527Andrea9/29/05crema base620$1,872.34sur2005260Helena9/26/06delineador de ojos250$773.30medio oeste2006101Miriam12/20/04crema base670$2,024.50oeste20041898Miriam6/16/11lpiz labial720$2,178.36oeste20111610Miriam7/29/09mascara110$351.87medio oeste20091552Cecilia8/18/05delineador de ojos720$2,183.28sur2005564Angel2/5/05crema base730$2,209.65medio oeste20051818Angel4/30/08crema base40$141.86oeste2008461Cecilia12/10/10mascara480$1,456.50oeste2010526Angel11/15/06brillo de labios730$2,212.92este20061393Angel2/5/06mascara560$1,697.58sur2006330Carmen5/17/11delineador de ojos900$2,713.33medio oeste2011442Cristina6/29/11crema base190$596.22este20111501Cristina12/31/07brillo de labios50$171.91oeste20071692Cristina3/19/09brillo de labios390$1,186.35medio oeste2009947Carmen10/9/05lpiz labial10$2.87medio oeste20051297Sofa12/11/10delineador de ojos260$800.49sur2010833Camila3/25/08delineador de ojos310$953.27medio oeste2008899Camila2/27/05delineador de ojos190$591.23medio oeste20051601Andrea6/9/05brillo de labios320$984.05sur20051467Andrea9/23/05mascara460$1,405.77este2005924Angel12/31/08mascara790$2,394.49oeste2008451Angel1/19/07delineador de ojos130$405.08sur20071542Cecilia1/22/07crema base710$2,153.50sur20071247Cecilia9/7/10crema base480$1,464.35medio oeste20101620Carmen9/9/07delineador de ojos60$193.15este20071046Carmen5/17/10brillo de labios280$859.14medio oeste20101119Carmen1/5/10mascara80$217.70oeste20101260Cristina9/5/09crema base60$162.37oeste2009207Cristina2/12/11mascara600$1,819.39este2011197Cristina12/17/04mascara50$128.98este20041390Cristina1/27/11mascara70$194.38este20111639Camila1/25/10delineador de ojos530$1,613.92medio oeste2010860Camila12/9/09brillo de labios340$1,041.69sur200941Camila8/31/09delineador de ojos250$765.62sur2009870Sofa6/20/08crema base290$886.97sur2008256Martha4/27/05delineador de ojos10$48.82sur2005377Martha12/12/10brillo de labios70$229.39oeste20101192Martha5/1/10lpiz labial400$1,225.52este2010676Andrea1/2/04lpiz labial80$256.39este2004191Andrea8/24/07mascara630$1,910.30medio oeste2007942Helena4/4/06delineador de ojos320$976.50este2006225Miriam10/3/05lpiz labial240$742.44oeste20051351Angel5/23/10crema base180$559.32sur2010169Angel3/28/08brillo de labios630$1,911.14este20081418Cecilia5/25/06mascara620$1,878.01oeste20061741Angel6/10/05mascara430$1,303.00oeste2005443Angel8/20/09mascara2$23.71oeste20091120Angel5/12/10delineador de ojos60$198.44sur20101349Cecilia11/8/08mascara560$1,702.63este20081032Cecilia9/3/10mascara50$130.91oeste201085Cristina6/23/09crema base800$2,412.62sur2009990Cristina5/15/05delineador de ojos380$1,159.62sur2005865Cristina10/15/04crema base100$277.25medio oeste20041693Carmen9/21/05lpiz labial450$1,377.10medio oeste2005406Carmen1/3/04mascara910$2,748.11sur20041266Sofa4/26/04delineador de ojos640$1,933.68sur2004589Camila5/28/07crema base340$1,036.79sur20071001Sofa2/21/11crema base200$615.98medio oeste2011161Camila2/4/05brillo de labios460$1,399.30medio oeste20051352Sofa2/26/07brillo de labios400$1,211.03sur2007808Camila8/15/05brillo de labios150$471.98medio oeste20051353Martha8/25/09mascara750$2,270.66sur2009729Martha4/11/04crema base620$1,887.00sur2004515Martha9/26/05lpiz labial670$2,026.22este2005839Helena4/1/08brillo de labios90$249.22este2008661Helena9/25/05mascara510$1,550.20sur2005436Angel3/25/08delineador de ojos220$675.10este2008294Angel9/11/09delineador de ojos10$9.08medio oeste20091149Cecilia12/22/10crema base930$2,807.21medio oeste2010311Cecilia9/26/07brillo de labios430$1,309.72este20071654Cecilia12/11/07lpiz labial920$2,772.69sur2007772Cecilia10/22/06mascara120$378.87oeste2006777Carmen9/4/08crema base50$125.48medio oeste2008172Cristina4/6/08crema base550$1,675.54sur2008462Camila12/7/07brillo de labios630$1,911.88este20071875Sofa8/10/10lpiz labial540$1,638.66medio oeste20101758Sofa12/28/09delineador de ojos220$687.79oeste20091561Sofa8/14/04brillo de labios80$214.82sur20041549Martha4/4/11delineador de ojos420$1,287.28oeste20111676Martha2/20/07crema base410$1,248.05este2007369Andrea11/2/06crema base200$616.79este2006939Andrea4/8/10brillo de labios140$441.94oeste2010510Helena4/9/11delineador de ojos40$140.12este20111392Miriam9/29/06delineador de ojos10$45.05sur20061259Miriam3/1/07mascara210$647.02sur2007758Angel11/12/05delineador de ojos210$653.79sur2005706Cecilia4/21/10brillo de labios320$986.19este20101187Angel8/30/08brillo de labios2$14.88oeste20081686Cecilia2/22/07lpiz labial260$797.98sur20071683Cecilia2/5/09crema base350$1,066.51sur20091059Cecilia3/24/10brillo de labios300$926.12sur20101814Cecilia12/11/07lpiz labial310$947.30medio oeste20071532Carmen2/23/05lpiz labial660$1,997.04oeste20051107Carmen4/14/09lpiz labial90$249.02medio oeste20091650Carmen2/14/06mascara820$2,476.57este20061275Cristina2/15/08mascara570$1,734.78sur20081061Camila3/21/07delineador de ojos550$1,673.25este20071546Sofa4/10/05brillo de labios330$1,002.29oeste20051370Sofa10/22/10brillo de labios270$836.68oeste2010419Camila8/15/10mascara10$23.47medio oeste20101608Camila2/16/11crema base810$2,447.10este2011868Camila8/3/07crema base270$830.17medio oeste20071802Camila2/23/06brillo de labios820$2,470.19medio oeste2006407Camila10/6/07brillo de labios780$2,359.86oeste20072Andrea9/17/06crema base500$1,520.07medio oeste2006482Andrea6/9/06brillo de labios40$141.05oeste2006174Andrea4/18/06lpiz labial910$2,752.45sur2006929Miriam10/28/07crema base580$1,752.23oeste20071809Miriam2/29/08lpiz labial50$174.70sur2008647Angel9/4/10delineador de ojos200$619.26oeste2010388Angel11/30/08brillo de labios370$1,129.29medio oeste20081006Cecilia2/20/10lpiz labial700$2,115.22oeste2010167Angel4/17/04brillo de labios210$643.27oeste20041043Cristina5/25/05crema base230$711.00oeste2005376Cristina11/18/05brillo de labios70$225.46oeste2005132Cristina10/19/09lpiz labial280$856.01medio oeste20091554Cristina7/25/05crema base310$946.63sur2005900Cristina8/18/09brillo de labios800$2,417.47medio oeste2009770Carmen12/25/06lpiz labial250$768.08este20061424Sofa6/26/05delineador de ojos820$2,481.69sur20057Sofa3/18/09delineador de ojos80$258.01medio oeste2009700Camila6/28/06brillo de labios380$1,157.65este20061186Sofa7/22/08lpiz labial260$803.74sur2008524Sofa11/1/10delineador de ojos100$318.18oeste2010811Sofa10/13/06crema base760$2,295.58este20061790Sofa4/1/08brillo de labios900$2,718.71este2008107Camila7/23/09brillo de labios90$292.78medio oeste2009843Martha6/19/05crema base250$771.08este20051412Martha6/1/11brillo de labios660$2,001.22medio oeste20111882Andrea3/14/04crema base720$2,179.00medio oeste2004596Martha12/8/04brillo de labios370$1,128.52medio oeste2004231Miriam1/11/05brillo de labios640$1,938.39oeste2005255Angel2/2/06crema base150$467.62oeste20061487Cecilia1/1/10mascara480$1,461.67sur20101095Cecilia6/6/08delineador de ojos660$1,999.25oeste200843Cecilia1/21/08crema base860$2,598.60oeste20081335Angel7/29/06crema base170$531.23este20061Angel8/13/09brillo de labios450$1,372.05sur2009393Angel1/4/08brillo de labios370$1,125.35este2008518Angel6/6/05mascara40$136.42sur20051446Carmen9/24/10delineador de ojos230$707.08este2010645Carmen4/13/10delineador de ojos50$168.54sur2010766Carmen4/24/04brillo de labios50$169.14oeste20041648Carmen3/16/07delineador de ojos130$409.90medio oeste20071611Carmen9/29/07delineador de ojos120$381.83oeste20071237Carmen2/27/08delineador de ojos60$202.45oeste2008539Cristina5/26/08lpiz labial70$229.60este2008623Carmen9/25/05mascara80$222.32oeste20051391Sofa10/26/07brillo de labios120$382.38sur2007545Andrea2/23/09delineador de ojos340$1,031.82medio oeste2009824Martha6/9/11crema base760$2,304.19este2011209Martha11/30/05delineador de ojos70$229.98medio oeste2005744Andrea9/17/04brillo de labios460$1,396.16oeste2004993Helena5/12/07brillo de labios300$917.17oeste2007934Helena3/12/08lpiz labial570$1,730.68este20081473Miriam10/11/10lpiz labial330$1,017.00este2010561Miriam9/8/07mascara550$1,669.90oeste200774Cecilia2/19/05mascara480$1,458.36oeste2005741Angel8/10/05delineador de ojos630$1,912.47oeste20051125Angel1/14/11brillo de labios750$2,270.38medio oeste2011688Cecilia9/5/07lpiz labial560$1,699.57medio oeste2007549Carmen9/12/07delineador de ojos870$2,631.63medio oeste20071007Cristina7/3/07crema base170$520.07este2007229Cristina3/3/09brillo de labios130$410.10oeste20091657Cristina7/31/06lpiz labial750$2,268.64oeste2006792Cristina11/18/09crema base360$1,100.92este2009856Carmen9/12/08crema base110$353.00este20081842Cristina6/15/09brillo de labios800$2,418.34medio oeste200958Camila9/23/04crema base340$1,040.94este20041115Camila3/24/09crema base110$352.78oeste2009847Sofa8/9/07brillo de labios280$860.45medio oeste200756Camila5/6/08brillo de labios80$269.09sur2008760Camila2/19/06lpiz labial50$170.05sur20061623Camila8/30/04delineador de ojos350$1,067.05oeste20041079Camila6/25/04crema base210$645.68sur2004621Camila5/3/07crema base40$103.92medio oeste20071674Camila4/13/07brillo de labios600$1,825.30este200716Sofa1/19/05mascara450$1,373.90este2005818Andrea7/17/10delineador de ojos860$2,594.85medio oeste2010794Martha9/4/07brillo de labios390$1,192.03este200798Martha9/9/07brillo de labios920$2,775.40este20071225Andrea9/15/10lpiz labial930$2,807.37oeste201027Andrea3/13/11lpiz labial380$1,159.85medio oeste20111522Miriam3/22/11delineador de ojos510$1,555.60oeste201193Miriam11/11/06crema base620$1,880.65oeste2006493Cecilia1/30/04delineador de ojos10$4.50medio oeste20041851Cecilia12/1/06brillo de labios370$1,132.74medio oeste20061310Angel3/14/09crema base720$2,181.58sur2009635Angel5/17/04mascara60$204.55medio oeste2004414Carmen5/15/11crema base370$1,124.34medio oeste20111853Carmen6/20/07brillo de labios870$2,628.13este20071300Carmen2/5/11crema base880$2,663.69medio oeste2011709Cristina6/25/11brillo de labios360$1,097.99medio oeste2011460Carmen3/10/10mascara740$2,241.82este2010472Camila5/26/07brillo de labios250$773.16sur20071282Sofa4/21/09mascara110$344.57medio oeste2009175Sofa7/18/07delineador de ojos800$2,424.49sur20071747Martha6/27/11crema base340$1,038.98oeste20111262Martha4/24/09crema base140$442.37oeste2009886Miriam2/10/06delineador de ojos860$2,602.94medio oeste2006126Helena7/4/04delineador de ojos540$1,637.46oeste20041063Helena12/22/04brillo de labios280$854.61este20041400Helena4/28/10brillo de labios90$286.84sur20101748Angel2/25/05delineador de ojos850$2,564.46este20051653Angel4/24/10delineador de ojos560$1,702.49este2010182Cecilia9/17/09brillo de labios780$2,361.42medio oeste20091198Angel6/4/09crema base940$2,842.83medio oeste2009512Angel4/17/11crema base760$2,301.80sur20111058Angel5/5/06mascara370$1,129.71medio oeste20061788Carmen2/17/11brillo de labios300$913.70medio oeste2011474Cristina1/25/09brillo de labios30$105.71sur20091633Carmen10/18/04mascara50$171.11este2004303Carmen9/12/10crema base700$2,114.33medio oeste2010251Cristina6/4/07mascara710$2,154.93oeste20071844Sofa4/19/10crema base460$1,403.94sur2010502Sofa4/18/08mascara610$1,853.82sur20081096Camila6/17/04delineador de ojos890$2,692.35este20041780Sofa6/20/09crema base160$503.23sur20091244Sofa12/9/04brillo de labios470$1,428.29este2004958Sofa11/18/08mascara540$1,640.82medio oeste20081520Andrea6/20/04crema base550$1,667.78este2004765Andrea8/4/05brillo de labios60$157.43oeste2005188Andrea5/13/09mascara790$2,393.44oeste20091306Helena12/6/04delineador de ojos530$1,607.96oeste2004405Miriam7/12/09crema base440$1,339.20medio oeste2009452Miriam12/27/10brillo de labios480$1,458.47este20101677Cecilia1/27/08brillo de labios10$7.29sur2008520Cecilia11/17/10crema base100$321.95oeste2010395Angel7/21/06lpiz labial560$1,692.75medio oeste20061437Cristina11/21/08delineador de ojos100$279.63sur2008279Cristina10/14/05crema base630$1,910.86este20051399Carmen5/31/11brillo de labios130$409.47sur2011756Carmen10/13/05brillo de labios110$353.56oeste2005308Carmen1/30/08brillo de labios70$233.87este20081246Carmen7/29/08mascara900$2,723.40medio oeste20081660Cristina1/16/04crema base730$2,211.68oeste20041872Cristina1/20/05crema base20$79.94sur20051894Cristina10/8/07brillo de labios600$1,818.70este20071398Andrea12/13/09delineador de ojos640$1,939.91oeste2009320Martha7/19/04delineador de ojos940$2,838.82este2004989Martha2/18/09delineador de ojos60$172.89este20091159Andrea8/6/06crema base710$2,147.03medio oeste2006158Andrea8/22/10crema base30$70.83medio oeste20101850Andrea4/7/10mascara520$1,578.83sur20101753Martha12/1/05mascara330$1,014.19oeste2005390Andrea12/29/07mascara180$559.32medio oeste20071723Helena8/16/06crema base70$191.60sur2006562Cecilia3/26/07delineador de ojos10$7.93sur2007814Cecilia4/8/06crema base110$355.22sur2006344Cecilia11/28/09mascara940$2,836.20medio oeste20091878Cecilia10/21/06brillo de labios600$1,822.81sur2006701Cecilia12/3/06brillo de labios130$404.74este20061857Cristina7/11/05crema base610$1,847.61medio oeste2005385Cristina6/26/09crema base490$1,489.27oeste2009994Carmen9/3/05crema base620$1,874.32sur2005180Carmen10/21/04lpiz labial600$1,820.22este2004740Sofa1/9/07delineador de ojos810$2,448.54oeste2007397Sofa8/6/08brillo de labios620$1,877.20sur20081207Sofa10/2/06brillo de labios70$227.49oeste2006360Sofa4/30/08mascara700$2,116.86sur2008283Camila6/10/10lpiz labial750$2,274.56oeste20101617Andrea2/24/06delineador de ojos830$2,506.22medio oeste2006795Andrea1/15/06delineador de ojos720$2,180.77sur20061703Martha4/26/09lpiz labial730$2,212.40sur2009536Martha8/23/10crema base290$892.95sur201092Martha8/30/10mascara330$1,003.28medio oeste2010298Helena4/19/11lpiz labial560$1,691.95sur20111579Angel9/2/09delineador de ojos870$2,628.46este2009449Cecilia1/24/11delineador de ojos810$2,449.75este20111294Angel5/15/10delineador de ojos190$596.43oeste2010232Cecilia1/12/08brillo de labios630$1,909.07medio oeste2008433Angel4/2/04delineador de ojos470$1,426.73sur2004812Carmen7/5/05delineador de ojos90$249.33sur200544Cristina2/2/11brillo de labios550$1,671.18medio oeste2011949Sofa9/5/04crema base130$418.30oeste20041204Sofa6/17/09mascara940$2,844.50oeste2009997Camila11/20/09brillo de labios880$2,652.92oeste2009325Martha3/30/04delineador de ojos830$2,516.32medio oeste2004491Andrea12/28/07crema base640$1,935.49sur20071696Martha11/22/06brillo de labios480$1,454.79oeste20061679Andrea3/21/09mascara120$380.34este20091616Andrea8/2/08delineador de ojos790$2,398.90medio oeste2008848Andrea11/23/06delineador de ojos180$558.59oeste20061348Martha7/28/09brillo de labios770$2,328.50medio oeste2009226Martha11/21/06brillo de labios10$9.18sur20061150Helena3/8/10crema base690$2,091.54sur2010270Helena12/22/05crema base470$1,428.46sur2005334Helena5/29/05crema base400$1,221.71sur2005622Angel2/10/06delineador de ojos80$259.00oeste20061538Angel10/26/05delineador de ojos10$57.26medio oeste20051196Angel2/26/08lpiz labial150$465.29este200863Cristina9/23/09delineador de ojos950$2,877.61medio oeste2009477Cristina12/22/07delineador de ojos2$20.01sur200733Carmen3/3/09mascara410$1,252.70oeste20091364Cristina11/28/04mascara310$949.15medio oeste2004951Carmen7/26/10crema base150$477.49oeste2010703Carmen11/14/07lpiz labial460$1,394.07medio oeste20071317Cristina9/20/10lpiz labial390$1,189.45sur20101447Carmen11/4/10mascara430$1,311.60oeste20101729Camila8/11/04delineador de ojos680$2,063.44este20041433Sofa1/5/09mascara920$2,786.52este2009600Camila8/18/06delineador de ojos640$1,941.82oeste20061190Sofa9/5/09brillo de labios610$1,844.75sur20091603Camila11/19/09brillo de labios250$770.47oeste2009333Andrea5/11/05brillo de labios680$2,063.79oeste2005454Martha4/13/08brillo de labios320$983.67este20081131Andrea5/30/06mascara790$2,383.15sur2006609Andrea8/6/09mascara770$2,326.68medio oeste20095Helena11/13/10brillo de labios430$1,306.03medio oeste201072Helena4/21/07lpiz labial540$1,638.66sur20071361Angel1/13/08crema base750$2,273.29sur2008314Cristina12/8/04crema base10$14.75medio oeste200457Cristina3/23/08mascara490$1,487.78medio oeste20081518Carmen11/19/04delineador de ojos90$284.59medio oeste20041607Camila7/9/07delineador de ojos150$472.53este2007505Camila10/18/04delineador de ojos60$165.98este20041040Sofa5/20/09delineador de ojos70$184.35oeste2009896Camila12/21/10brillo de labios510$1,547.18sur2010140Martha5/22/10delineador de ojos800$2,424.96este2010415Andrea8/9/09delineador de ojos260$799.14sur2009617Martha5/24/05delineador de ojos60$202.42medio oeste20051076Andrea2/13/08brillo de labios360$1,099.60este20081366Martha9/26/08mascara800$2,420.63sur2008300Helena2/14/06delineador de ojos30$111.63sur20061089Miriam5/14/11brillo de labios920$2,776.47sur20111389Helena11/9/09lpiz labial330$1,010.89sur20091368Miriam9/20/05lpiz labial290$891.73oeste2005133Angel2/25/10mascara110$344.17este20101687Cristina10/19/10crema base830$2,509.87sur2010245Carmen2/10/07mascara50$171.99este20071480Cristina3/20/09delineador de ojos290$895.89oeste2009243Carmen12/17/07lpiz labial30$73.95sur20071728Carmen9/30/04mascara70$193.54sur2004736Camila10/1/10mascara210$643.22sur20101005Sofa10/19/09mascara710$2,150.23oeste2009432Andrea4/17/10delineador de ojos430$1,312.03oeste2010328Andrea2/1/11crema base680$2,057.56sur2011659Miriam7/22/09delineador de ojos250$763.79este20091614Helena11/25/10crema base90$291.09este20101147Miriam6/8/10lpiz labial80$260.88este2010938Angel6/5/04brillo de labios560$1,698.40este2004222Angel3/7/06mascara670$2,033.53oeste2006563Cecilia1/1/04mascara620$1,876.34oeste2004488Cecilia8/20/08delineador de ojos370$1,129.97sur20081883Cecilia11/24/07brillo de labios60$157.36este20071504Angel11/25/09mascara930$2,808.62sur2009696Angel11/21/09mascara470$1,426.26sur2009731Cecilia11/9/04mascara30$72.26oeste20041535Carmen4/5/06brillo de labios450$1,369.23sur2006791Cristina5/16/11lpiz labial80$254.54oeste2011177Carmen12/17/08mascara540$1,643.05oeste2008897Cristina1/26/10crema base910$2,747.72sur20101773Carmen12/12/10crema base100$274.49medio oeste2010892Carmen7/2/05lpiz labial110$347.82sur20051845Sofa9/29/10crema base290$895.78sur2010597Sofa1/3/10delineador de ojos780$2,353.71sur20101756Sofa3/31/08crema base130$404.40sur20081070Andrea11/13/07brillo de labios670$2,030.21sur20071215Angel11/9/07crema base300$917.39sur20071211Cecilia8/11/07mascara330$1,009.08medio oeste20071385Cecilia3/21/05brillo de labios470$1,438.58oeste2005704Carmen1/8/11delineador de ojos110$351.05este20111893Carmen7/8/08crema base200$619.24medio oeste2008889Carmen3/16/07delineador de ojos860$2,600.09sur20071516Cristina5/5/07mascara580$1,761.98sur20071808Camila10/20/06brillo de labios10$4.42sur2006776Sofa3/16/08lpiz labial100$318.53sur2008638Andrea4/19/04mascara940$2,838.75este2004312Miriam10/9/08delineador de ojos670$2,033.03sur20081455Miriam3/8/04delineador de ojos70$189.17este2004379Helena8/16/06crema base60$195.61oeste20061806Cecilia6/23/05mascara430$1,313.31este20051255Angel9/28/07mascara180$556.84este2007292Cecilia10/3/07mascara160$499.56sur20071036Cecilia11/12/04crema base690$2,091.46sur2004733Cecilia11/22/07lpiz labial920$2,776.77medio oeste2007331Cristina8/26/05delineador de ojos100$317.40oeste20051049Cristina8/19/06brillo de labios790$2,386.36este2006607Cristina12/23/08mascara70$234.34sur2008339Cristina10/5/05mascara10$9.27oeste2005102Sofa2/13/07crema base160$494.50sur200762Camila3/20/07crema base230$713.13sur20071860Camila5/6/08brillo de labios90$247.60este2008233Sofa4/14/05mascara570$1,735.90medio oeste2005538Martha7/26/07delineador de ojos500$1,518.65este2007326Andrea8/29/04lpiz labial890$2,686.72medio oeste2004154Andrea12/16/09lpiz labial160$499.44sur20091094Cecilia3/14/04brillo de labios840$2,542.13sur20041315Cecilia3/19/04brillo de labios120$378.19medio oeste2004675Cecilia6/26/04brillo de labios100$324.46medio oeste20041743Cecilia8/10/07mascara400$1,217.08este2007845Cristina10/7/10delineador de ojos370$1,132.13este2010946Carmen3/21/07delineador de ojos70$198.22sur20071182Cristina6/3/08brillo de labios880$2,657.48este20081311Cristina10/22/04brillo de labios630$1,910.80sur20041859Cristina6/18/06lpiz labial60$165.89sur20061517Sofa8/5/06delineador de ojos650$1,966.39sur2006284Sofa12/9/10brillo de labios790$2,398.95oeste2010566Camila1/3/10mascara2$15.99oeste2010857Martha12/13/10brillo de labios740$2,239.75este20101377Martha1/11/06mascara790$2,392.58sur2006530Martha6/23/09mascara570$1,723.62oeste20091175Andrea3/12/04delineador de ojos730$2,213.67este2004184Martha12/1/10delineador de ojos130$408.08medio oeste2010710Andrea9/7/06mascara790$2,387.53oeste20061091Helena5/14/07crema base610$1,844.54sur20071018Helena9/9/06crema base550$1,668.20este2006723Miriam11/4/04brillo de labios300$920.31medio oeste2004650Angel2/11/07mascara400$1,223.42medio oeste20071456Cecilia9/6/04mascara210$649.13oeste20041490Cristina10/3/05crema base790$2,391.50oeste20051279Carmen10/9/08mascara280$864.58medio oeste2008557Camila11/2/09crema base440$1,335.09medio oeste20091045Camila4/8/08mascara460$1,398.22medio oeste20081170Camila2/13/11delineador de ojos20$79.32este20111019Andrea4/29/07lpiz labial710$2,153.53medio oeste20071212Martha9/6/07delineador de ojos220$684.43este2007841Andrea1/31/08crema base30$74.50medio oeste2008152Helena3/28/06lpiz labial60$203.22medio oeste2006543Helena10/13/07mascara580$1,766.10este20071684Cecilia7/17/04mascara940$2,837.95medio oeste20041827Angel7/27/05mascara190$591.01sur2005223Cecilia6/15/05crema base940$2,837.41oeste2005670Angel1/4/04brillo de labios320$980.07medio oeste2004681Angel8/15/05lpiz labial880$2,656.42oeste20051877Cristina9/26/06delineador de ojos660$1,993.62este2006719Cristina3/28/05crema base710$2,149.28sur2005930Cristina4/3/11mascara480$1,459.38sur2011996Carmen2/2/06delineador de ojos40$136.54oeste20061209Carmen4/11/07brillo de labios320$986.69oeste20071876Carmen8/15/05brillo de labios190$597.15oeste2005105Camila3/30/10lpiz labial510$1,552.98medio oeste2010517Sofa3/2/04mascara380$1,166.86sur2004430Sofa9/5/06crema base60$203.88sur2006975Sofa8/17/07mascara130$411.39este20071847Camila5/25/04mascara20$73.17sur20041340Andrea4/6/06brillo de labios240$747.31oeste2006698Martha1/14/07delineador de ojos460$1,395.28oeste20071768Miriam11/7/04crema base100$277.87este20041216Miriam10/30/07brillo de labios10$11.45oeste2007253Cecilia5/29/09crema base840$2,532.86este20091586Angel9/12/09brillo de labios660$1,997.03medio oeste20091084Angel3/24/05brillo de labios40$97.95oeste20051852Cecilia11/11/10lpiz labial360$1,105.19sur201022Cecilia1/19/07delineador de ojos280$865.13medio oeste2007574Cecilia11/21/04crema base390$1,183.66medio oeste2004878Angel2/16/04brillo de labios680$2,061.61oeste2004944Angel2/26/05brillo de labios20$37.23oeste20051668Carmen6/16/11delineador de ojos610$1,851.65sur20111038Cristina6/4/07delineador de ojos30$104.87medio oeste2007217Cristina5/7/04crema base670$2,033.59medio oeste20041276Carmen3/7/10crema base80$218.27sur20101371Carmen5/29/10brillo de labios360$1,098.09oeste2010145Cristina4/14/05mascara890$2,694.05este20051057Carmen8/3/09crema base630$1,902.09este2009608Carmen4/23/11crema base580$1,760.03este2011237Camila10/29/06delineador de ojos40$99.94este20061443Sofa1/26/07brillo de labios690$2,087.66oeste20071168Camila7/12/05lpiz labial830$2,514.04medio oeste20051163Sofa6/1/10mascara460$1,404.79sur2010533Andrea4/20/10brillo de labios320$978.89medio oeste20101026Andrea11/18/06lpiz labial690$2,086.16oeste2006624Martha2/11/10mascara720$2,186.88medio oeste20101238Martha2/26/11lpiz labial920$2,776.30este20111003Helena10/29/10delineador de ojos940$2,839.87sur201047Miriam9/26/05delineador de ojos140$439.32oeste2005909Cecilia9/7/04delineador de ojos10$27.44medio oeste20041638Cecilia11/16/07mascara150$469.88este2007470Angel2/19/04crema base290$887.14este20041157Angel7/8/04lpiz labial10$11.16oeste20041267Cristina2/10/04delineador de ojos470$1,431.43medio oeste2004111Cristina8/15/04mascara810$2,444.61oeste2004428Carmen5/7/07delineador de ojos410$1,251.89oeste20071104Carmen9/5/08brillo de labios810$2,453.69sur20081002Cristina1/25/10brillo de labios100$283.26sur2010224Sofa6/25/09delineador de ojos520$1,582.97oeste2009525Camila5/23/04crema base620$1,883.81oeste20041637Sofa7/28/05brillo de labios550$1,669.34sur20051798Camila4/15/05lpiz labial790$2,392.51medio oeste2005620Sofa12/20/08mascara30$109.08medio oeste20081416Sofa7/19/09mascara210$652.17sur20091365Martha9/29/08delineador de ojos360$1,098.68medio oeste20081271Andrea4/18/06crema base790$2,394.36oeste20061635Andrea12/23/07brillo de labios780$2,356.11oeste20071274Andrea11/19/04lpiz labial910$2,753.68medio oeste2004693Andrea7/20/07crema base390$1,188.21sur20071740Andrea6/15/07mascara290$892.62sur2007810Martha7/7/11mascara130$409.00oeste2011800Helena3/6/04delineador de ojos470$1,424.88sur20041121Miriam4/6/09crema base300$917.48oeste20091113Helena1/29/05brillo de labios820$2,482.09sur20051358Angel12/1/07mascara740$2,250.19sur20071417Cecilia1/24/10brillo de labios80$258.25este2010409Angel9/9/10mascara740$2,240.43este20101697Cecilia1/11/04mascara30$70.56medio oeste2004153Carmen3/27/10lpiz labial630$1,916.80oeste20101257Cristina7/1/07delineador de ojos460$1,399.40medio oeste20071624Sofa1/21/04delineador de ojos610$1,853.82medio oeste20041680Camila12/7/10delineador de ojos210$659.12sur20101410Sofa1/18/04mascara2$18.31medio oeste2004850Sofa7/31/08crema base790$2,388.27oeste20081551Camila7/11/04brillo de labios260$800.32este2004321Andrea4/9/06brillo de labios90$288.31oeste20061706Andrea12/26/04delineador de ojos700$2,118.09sur2004318Andrea5/9/07delineador de ojos200$619.95este20071304Martha11/22/06crema base210$656.04oeste20061405Martha1/19/07brillo de labios40$143.58oeste2007816Martha11/13/10lpiz labial930$2,802.65sur20101582Martha12/1/08mascara110$351.16este2008950Angel7/11/04brillo de labios700$2,124.55sur20041514Angel6/2/08mascara220$677.45sur2008558Angel2/20/07delineador de ojos470$1,432.12medio oeste2007866Cristina3/9/08lpiz labial420$1,284.29medio oeste2008588Sofa6/29/08crema base60$200.18sur20081559Camila5/22/06brillo de labios400$1,220.53sur20061730Sofa9/22/04delineador de ojos860$2,602.90medio oeste20041189Sofa4/13/06delineador de ojos750$2,276.20medio oeste2006137Camila3/16/06crema base400$1,219.47oeste20061700Andrea5/10/10brillo de labios450$1,363.12sur201019Andrea1/3/04delineador de ojos780$2,361.47sur200460Andrea11/28/04mascara890$2,690.91este20041278Miriam8/2/10delineador de ojos920$2,780.45sur20101702Miriam8/25/06crema base520$1,580.46medio oeste2006873Cecilia2/29/04delineador de ojos410$1,248.18este2004319Cecilia12/20/07crema base700$2,125.03sur20071472Angel4/17/10delineador de ojos150$470.87oeste20101314Angel7/15/05brillo de labios880$2,655.67este200583Cristina1/26/08crema base820$2,480.99oeste2008851Cristina3/11/10crema base310$949.73medio oeste2010927Carmen5/8/04brillo de labios90$288.27sur20041736Carmen6/5/11brillo de labios30$108.90sur2011268Sofa6/28/04delineador de ojos10$47.72este20041807Sofa4/9/08brillo de labios780$2,364.40medio oeste2008726Camila7/26/04lpiz labial300$918.01oeste2004842Camila1/26/07mascara90$288.31oeste20071754Sofa6/25/06mascara100$278.65medio oeste20061173Sofa8/13/09delineador de ojos300$923.32este2009682Camila6/20/09crema base940$2,843.29medio oeste20091533Camila12/1/08crema base340$1,044.49oeste2008640Camila1/26/09brillo de labios80$214.42sur2009234Camila5/7/04mascara590$1,789.27este2004578Andrea6/17/07brillo de labios70$231.93este2007565Martha3/1/06lpiz labial120$384.39oeste20061344Martha5/31/05mascara560$1,705.09sur20051339Martha7/14/07lpiz labial130$405.59oeste2007485Miriam8/24/05crema base210$652.81oeste2005911Helena1/7/10crema base140$442.46sur20101761Miriam12/22/07brillo de labios770$2,327.83sur20071320Miriam9/20/10mascara250$766.51este201012Angel11/14/05brillo de labios230$710.34oeste20051326Angel11/3/05mascara890$2,697.45este200549Cecilia9/11/04crema base630$1,906.95oeste20041056Angel11/2/08brillo de labios570$1,731.00este2008309Carmen4/22/08delineador de ojos630$1,914.49medio oeste20081873Cristina2/6/08crema base830$2,508.75sur20081744Carmen6/3/06mascara780$2,358.87sur2006112Carmen6/6/11mascara380$1,158.65sur20111141Cristina3/29/05mascara80$219.82oeste2005

6Tema: funciones con condicionesPLANTEAMIENTO DEL PROBLEMA: Se han llevado a cabo los exmenes de admisin para cierta universidad. El examen const de 3 partes: Matemticas, Estadstica y Lgica. Mediante Excel se han registrado las notas de los aspirantes.INSTRUCCIONES:Con base en los datos de la siguiente tabla, contestar las siguientes preguntas:AspiranteMatemticasEstadsticaLgicaPreguntas:1325NPNPAC1326ACACNA1)Cuntos aspirantes se inscribieron al examen?1327NPNANP361328NAACNA1329NPNPNP2)ERROR:#VALUE!1330ACNPAC91331NPACNP1332NPACNP3)Qu porcentaje de alumnos no se presentaron (NP) al examen de1333ACACNAERROR:#VALUE!1334ACACNA14361335ACNAAC38.9%1336NPACNP1337ACNPNP1338NPNPNP1339NPNAAC1340NPNPAC1341NPNPNA1342NPACAC1343NPNPNP1344NAACNP1345NPNANA1346NPNPNP1347ACNANP1348ACNANA1349NAACNA1350NPACAC1351NANPAC1352NPNPNA1353ACACNP1354NPACNA1355NPNANA1356NPACAC1357NPNANP1358NANPNP1359NANPNA1360NANAAC

7Tema: Funciones con varias condicionesPara los datos de la tabla VENTAS, calcular el Total de las Comisiones por Forma de Pago, Agente y Provincia.Nota: en una celda de la tabla escriba una nica funcin y luego copie hacia las dems celdas de la tabla(La informacin se encuentra en la tabla RESUMEN)

Forma de PagoCrdito

VENTAS Provincia AgenteChimborazoCotopaxiEsmeraldasGuayasImbaburaManabNapoPichinchaTungurahuaAndrea Fiallos0000021.4925.23500Camila Silva000000000Fabin Mosquera0067.45000031.430Juan Argoti092.877.45023.730000Sofa Indarte000089.55117.72000Silvia Burbano000000000Miguel Paucar34.1950011.23500000Silvia Alvarado000084.2018.23500

RESUMENZonaProvinciaAgenteFecha de ingresoVentasForma de pagoComisionesCentralPichinchaJuan Argoti18-Nov-2000$319.0Efectivo$86.5NorteGuayasMiguel Paucar1-Sep-2004$521.0Crdito$11.2NorteManabAndrea Fiallos15-Dec-2006$1,856.0Cheque$34.2CentralChimborazoFabin Mosquera4-Sep-2002$977.0Efectivo$28.4CentralCotopaxiCamila Silva18-Feb-2000$844.0Efectivo$30.6NorteImbaburaSofa Indarte14-Sep-2002$873.0Crdito$89.6CentralTungurahuaCarlos Sols11-Nov-2009$1,791.0Cheque$52.0NorteEsmeraldasJuan Burbano15-Aug-2000$1,040.0Crdito$11.2NorteNapoSilvia Alvarado27-Nov-2004$1,730.0Crdito$18.2CentralCotopaxiJuan Argoti11-Aug-2010$321.0Crdito$92.8CentralChimborazoMiguel Paucar13-Feb-2004$977.0Crdito$34.2CentralPichinchaAndrea Fiallos13-Jun-2003$812.0Efectivo$29.5CentralPichinchaFabin Mosquera28-Jul-2004$898.0Crdito$31.4NorteGuayasCamila Silva5-Mar-2005$2,272.0Cheque$113.6NorteManabSofa Indarte19-Jul-2005$1,758.0Crdito$87.9NorteImbaburaCarlos Sols6-Oct-2003$1,259.0Efectivo$63.0CentralTungurahuaJuan Burbano26-Jan-2001$1,218.0Crdito$60.9NorteEsmeraldasSilvia Alvarado17-Nov-2001$1,374.0Efectivo$68.7NorteEsmeraldasJuan Argoti31-Aug-2003$1,549.0Crdito$77.5CentralTungurahuaMiguel Paucar12-Dec-2003$1,922.0Cheque$96.1NorteManabAndrea Fiallos24-Mar-2010$614.0Crdito$21.5CentralPichinchaFabin Mosquera18-Jun-2010$258.0Efectivo$9.0NorteGuayasCamila Silva28-Aug-2002$1,472.0Efectivo$73.6NorteManabSofa Indarte17-Jul-2000$2,486.0Efectivo$124.3CentralChimborazoCarlos Sols6-Sep-2006$2,008.0Efectivo$100.4CentralCotopaxiJuan Burbano27-Apr-2003$1,009.0Cheque$50.5NorteImbaburaSilvia Alvarado25-Dec-2002$1,684.0Crdito$84.2CentralTungurahuaJuan Argoti18-Mar-2000$1,994.0Cheque$99.7NorteEsmeraldasMiguel Paucar12-Nov-2003$337.0Efectivo$11.8NorteNapoAndrea Fiallos18-Feb-2007$721.0Crdito$25.2CentralCotopaxiFabin Mosquera6-Apr-2007$1,690.0Efectivo$84.5CentralChimborazoCamila Silva10-Jan-2005$1,106.0Efectivo$55.3CentralPichinchaSofa Indarte12-Apr-2006$988.0Efectivo$34.6CentralPichinchaCarlos Sols9-Aug-2006$2,083.0Crdito$104.2NorteGuayasJuan Burbano9-Nov-2000$1,350.0Efectivo$67.5NorteManabSilvia Alvarado23-Sep-2006$1,128.0Efectivo$56.4NorteImbaburaJuan Argoti11-Apr-2005$678.0Crdito$23.7CentralTungurahuaMiguel Paucar11-Sep-2001$1,997.0Cheque$99.9NorteEsmeraldasAndrea Fiallos4-Feb-2006$1,669.0Efectivo$83.5NorteEsmeraldasFabin Mosquera3-Oct-2000$1,349.0Crdito$67.5CentralTungurahuaCamila Silva6-Apr-2010$2,298.0Cheque$114.9NorteManabSofa Indarte10-Jun-2001$852.0Crdito$29.8

8Tema: Funciones aleatorias y lgicas1)En la tabla inferior se trata de conocer si el aspirante es o no apto para seguir una carrera.a) En las celdas de las columnas Prueba N 1 a la N 4 que corresponden a los nombres de los aspirantes, generar al azar (utilizar funciones aleatorias) las palabras Si y Nob) En las celdas de la columna Estatura generar al azar (utilizar funciones aleatorias) valores entre 1,70 y 1,95.c) En las celdas de la columna resultado aparece Apto si el aspirante aprueba al menos tres pruebas y la estatura es mayor o igual a 1,75. caso contrario aparece No apto.

PRUEBAS DE ASPIRANTESAspirantePrueba N 1Prueba N 2Prueba N 3Prueba N 4EstaturaResultado 1JuanNONOSISI1.87No AptoMarthaNONONONO1.86No AptoLuisNONONONO1.89No AptoCamilaNONOSINO1.72No AptoSofaSINONOSI1.92No AptoSusanaNONONOSI1.71No AptoCarmenNONONOSI1.83No Ap