Datos Numéricos Fechas Horas
1995 12/31/1899 0:00
1,995 12/12/1900 [Link]
1.99 1/1/2000 22:12
1995.12 12/13/1994 10pm
30-02-1994 10AM
-2950 12-May 10:00 AM
-2950 May-95 Fecha y Hora
12% 1/1/1995 1:01
13% 12/12/1995 12:30
¿Fracción o fecha?
12-Dec
1-Mar
15-Feb
Tipo de Texto
Operador Informático
La Planilla de Cálculos Excel
Datos Compra Clientes
Código Cliente Importe Fecha Compra N° de Cuotas
CLI-001 Ventrurini, Fabio $ 39,290.00 8/2/2022 2
CLI-002 Betio, Juan $ 40,255.00 8/7/2022 3
CLI-003 Proz, Alejandro $ 18,795.00 8/8/2022 4
CLI-004 Cabrera, Camila $ 18,667.00 8/10/2022 2
CLI-005 Gomer, Laura $ 8,510.00 8/16/2022 5
CLI-006 Leiva, Mario $ 29,011.00 8/16/2022 5
CLI-007 Barco, Rodrigo $ 27,258.00 8/17/2022 5
CLI-008 Lell, Luz Maria $ 16,778.00 8/17/2022 6
CLI-009 Gimenez, Ana Laura $ 39,330.00 8/18/2022 4
CLI-010 Dalinger, Aguatina $ 10,501.00 8/29/2022 5
CLI-011 Orellana, Pedro $ 19,968.00 9/1/2022 4
CLI-012 Correa, Elizabeth $ 35,759.00 9/3/2022 6
CLI-013 Retamar , A riel $ 23,728.00 9/14/2022 5
CLI-014 Farias, Roberto $ 13,930.00 9/7/2022 6
CLI-015 Lucente, Francisco $ 10,843.00 9/12/2022 5
CLI-016 Diaz, Eduardo $ 13,009.00 9/13/2022 2
CLI-017 Rios, Juan Manuel $ 30,054.00 9/27/2022 5
CLI-018 Erbes, Lucia $ 23,886.00 9/27/2022 4
Importe Cuota IVA Totas Cuota Recargo Recargo
22591.75 2372.13375 24963.88375 15% 115%
15431.0833333333 1620.26375 17051.347083333
5403.5625 567.3740625 5970.9365625
10733.525 1127.020125 11860.545125
1957.3 205.5165 2162.8165
6672.53 700.61565 7373.14565
6269.34 658.2807 6927.6207
3215.78333333333 337.65725 3553.4405833333
11307.375 1187.274375 12494.649375
2415.23 253.59915 2668.82915
5740.8 602.784 6343.584
6853.80833333333 719.649875 7573.4582083333
5457.44 573.0312 6030.4712
2669.91666666667 280.34125 2950.2579166667
2493.89 261.85845 2755.74845
7480.175 785.418375 8265.593375
6912.42 725.8041 7638.2241
6867.225 721.058625 7588.283625
NOMINA DE EMPLEADOS
DNI APELLIDO NOMBRE EDAD SUELDO SUPERA 150%?
14,672,040 Alvarez Brisa Celina 55 $ 248,993.00 1
14,960,255 Rondan Antonella Victoria 54 $ 110,715.00 FALSE
31,193,336 Paz Luisina Dora Inés 35 $ 84,987.00 FALSE
22,176,207 Margaria Gomez Marianela Natalia 49 $ 145,086.00 TRUE
14,878,121 Rodriguez Pablo Ignacio 54 $ 115,890.00 FALSE
33,156,893 Morelli Mara Salome 37 $ 98,576.00 FALSE
34,010,189 Rubio Eidi Aldana 38 $ 113,093.00 FALSE
33,438,722 Cardozo Noemi Gricelda 37 $ 171,924.00 TRUE
30,199,664 Gauna Pablo Lautaro 42 $ 179,934.00 TRUE
28,691,604 Palaversich Bruno Ezequiel 45 $ 223,595.00 TRUE
18,948,150 Valbuena Elisa Marina 51 $ 173,804.00 TRUE
25,440,146 Crudo Verónica Noemi 47 $ 73,548.00 FALSE
15,122,365 Campero María Eperanza 56 $ 84,948.00 FALSE
31,639,872 Rossi Miguel Diego 35 $ 217,143.00 TRUE
22,972,625 Meier Ramón Brian 50 $ 114,025.00 FALSE
31,836,458 Botello Martin Ezequeil 36 $ 202,755.00 TRUE
34,837,684 Arin Ivana Yoycelin 38 $ 102,906.00 FALSE
26,908,262 Camparo María Paz 46 $ 150,050.00 TRUE
29,069,125 Flores Paula Berenice 45 $ 243,233.00 TRUE
19,834,321 Cano Martin Daniel 53 $ 108,543.00 FALSE
%SMVyM SMVyM % del sueldo
67.90% $ 79,925.00 32%
27.81% 72%
5.96% 94%
44.91% 55%
31.03% 69%
18.92% 81%
29.33% 71%
53.51% 46%
55.58% 44%
64.25% 36%
54.01% 46%
-8.67% 109%
5.91% 94%
63.19% 37%
29.91% 70%
60.58% 39%
22.33% 78%
46.73% 53%
67.14% 33%
26.37% 74%
