Upload
alf-mac
View
239
Download
0
Embed Size (px)
Citation preview
8/18/2019 Ejercicio 3 - Tabla Dinámica
1/62
País Sum - Valor del pedidoEE.UU. € 894,996.49RU € 333,330.91Total Result € 1,228,327.40
8/18/2019 Ejercicio 3 - Tabla Dinámica
2/62
Vendedor oun! - Valor del pedido"u#$anan 4%alla$an 99&a'olio 11(&ods)or!$ 41*uller 9%+in 6(e'erlin 1%Pea#o#/ 11Suama 6Total Result 799
88.8
8/18/2019 Ejercicio 3 - Tabla Dinámica
3/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
4/62
*e#$a del pedido Sum - Valor del pedido(10%009 € 1,863.40(11%009 € 3,9(.90(1%%009 € 1,%.60(1%009 € 3,144.6(16%009 € 1,884.80(1(%009 € 1(.80(%%%009 € 1,119.90(%3%009 € %,1(1.0(%%009 € 684.80(%9%009 € 1,04.6(30%009 € 448.00(31%009 € %,%%0.368%%009 € %,4((.%086%009 € 4,99%.6089%009 € 934.0481%%009 € 3,%13.%8813%009 € 1,%00.80814%009 € 4%0.00816%009 € %,3(8.408%1%009 € %41.908%3%009 € %,110.4%8%6%009 € 1,(43.368%(%009 € 1,1(0.3(8%8%009 € 1,%98.40830%009 € 3,064.009%%009 € 1,%96.00
93%009 € %,%49.1094%009 € 49(.%9%009 € 1,88(.60910%009 € 1,41.60911%009 € 4,44.3091%%009 € 613.%0913%009 € 349.091(%009 € 1,(09.40918%009 € 1,(%.809%3%009 € 498.09%4%009 € 88.80
9%%009 € 4%4.009%6%009 € %68.809%(%009 € 336.00103%009 € %,131.60104%009 € %,1(.10108%009 € %,83.00109%009 € 6,40.101010%009 € ,63.(11011%009 € 1,33.%0
8/18/2019 Ejercicio 3 - Tabla Dinámica
5/62
1014%009 € 4,43.40101(%009 € 1,168.001018%009 € 16.0010%1%009 € 1,8(.3810%3%009 € 6,4%.4310%4%009 € %,036.1610%%009 € 1,16%.3%
10%8%009 € 1,(93.8010%9%009 € 3,401.0114%009 € ,194.6411%009 € %,648.60116%009 € 1,84.00118%009 € 4,869.481111%009 € %,9%4.80111%009 € 0.%01118%009 € 136.3011%0%009 € 6,44(.%11%%009 € 8,93.%8
11%6%009 € 3,4(1.6811%(%009 € 1,3.8011%8%009 € 1,49.601%%%009 € 11,48.061%3%009 € %,688.301%4%009 € 1,39(.%01%9%009 € 1%,398.301%11%009 € 1,366.401%13%009 € %,%3(.881%16%009 € %,900.001%18%009 € 899.00
1%19%009 € 103.%01%%0%009 € 4,09.601%%3%009 € 691.%01%%4%009 € 1,90.(61%%%009 € 166.001%%6%009 € %,090.881%%(%009 € 1,11(.601%30%009 € 136.001%31%009 € 86.4011%010 € 1,440.001%%010 € 1,060.(%
13%010 € ,1%1.8(16%010 € 1,903.8018%010 € 3,36.819%010 € 3,360.61110%010 € 6,8%.10113%010 € 1,830.(8114%010 € 1,941.6011%010 € 1,136.80116%010 € 6,00.0%
8/18/2019 Ejercicio 3 - Tabla Dinámica
6/62
11(%010 € %%4.831%1%010 € 966.801%%%010 € 400.001%4%010 € 1,91(.%01%(%010 € 1%,816.6(1%8%010 € 11,188.40130%010 € 3,%91.60
131%010 € 49.80%3%010 € 4,899.%0%4%010 € 19%.00%6%010 € 338.%0%(%010 € 4,40.%%%10%010 € 1,0(8.00%11%010 € 1,994.%%1%%010 € 393.00%13%010 € 3%1.1%%14%010 € 1,331.44%18%010 € 1,(9%.00
%19%010 € %46.%4%%0%010 € 1(4.90%%1%010 € 1,031.(0%%4%010 € 1,463.40%%%010 € 331.%0%%6%010 € %,4%6.%0%%(%010 € 1,838.%0%%8%010 € (,140.9333%010 € ,09.1034%010 € 4,(4%.%03%010 € 1,38.(0
36%010 € (13.303(%010 € 914.40311%010 € 660.3%31%%010 € 4,6(.%6313%010 € %16.00314%010 € 8,69.(318%010 € 1,484.00319%010 € 1,036.803%1%010 € 11,9(.103%4%010 € 936.483%%010 € %,030.00
3%6%010 € 4(1.%03%8%010 € 889.(0331%010 € 1,84.0041%010 € 386.%04%%010 € %,(84.0043%010 € 3,163.%044%010 € 1,0.184(%010 € 1,(0.6048%010 € %9.0
8/18/2019 Ejercicio 3 - Tabla Dinámica
7/62
49%010 € 1,31.%0410%010 € (.40411%010 € 1,(04.%0416%010 € 3,609.041(%010 € %3.%6418%010 € 1,388.04%1%010 € %,69(.90
4%%%010 € (49.064%4%010 € %.304%%010 € 668.804%8%010 € 6,649.44%9%010 € 1,30.101%010 € 4,89.%%%010 € 641.30%010 € 4,10.06%010 € %,318.%4(%010 € 4,69.69%010 € 1,338.%0
1%%010 € 4,9(6.313%010 € %40.0014%010 € 46.(01%010 € 1,11.4016%010 € 8,(63.%19%010 € 1,933.80%1%010 € 1,940.8%%%010 € %,%%%.%0%3%010 € 1%,99.(0%6%010 € 469.11%(%010 € %,81%.00
%9%010 € 1,946.%30%010 € 6,41.(86%%010 € %,03%.9063%010 € 1,46.3064%010 € %,944.406%010 € %,609.0%66%010 € ,18.1069%010 € 3,916.9%610%010 € %,14%.9061%%010 € 488.(0613%010 € 11,4(.31
616%010 € 1,%34.061(%010 € %,19.00618%010 € %,400.90619%010 € %,46.%6%0%010 € %,08%.006%4%010 € 96.006%%010 € 1,01.086%6%010 € %10.00630%010 € 4,319.1
8/18/2019 Ejercicio 3 - Tabla Dinámica
8/62
(1%010 € 1,013.(4(%%010 € 310.00(4%010 € 3,699.9(9%010 € 986.18(10%010 € 3,%6%.0(11%010 € 890.00(14%010 € 6,%%8.00
(16%010 € 1,894.46(18%010 € 3,106.8(%1%010 € 9(%.80(%%%010 € %,333.((%%010 € 6,9%.40(%9%010 € 4,340.4(30%010 € 4%4.00(31%010 € 1,130.4081%010 € 9,064.%084%010 € 1,40%.08%010 € 4,806.99
86%010 € 419.%8(%010 € 1,%60.0088%010 € 4,180.0811%010 € 1,318.081%%010 € %,1(.83813%010 € 1,994.40814%010 € 3(.%81%010 € .80818%010 € ,10.9819%010 € %,88.848%0%010 € 4,(%8.6
8%1%010 € (,49(.4(8%6%010 € ,44.448%(%010 € 00.008%8%010 € (08.(8%9%010 € 1,434.0091%010 € 4,091.89%%010 € %,349.093%010 € 3,861.%09%010 € 696.0098%010 € 4,(83.4499%010 € 3(%.3(
910%010 € 1,831.%3911%010 € 1,14.0391%010 € 4,934.%091(%010 € 1,%9.00918%010 € %,4%6.(919%010 € 4,3%0.699%%%010 € ,%36.949%3%010 € %,048.%(9%4%010 € 9%0.10
8/18/2019 Ejercicio 3 - Tabla Dinámica
9/62
9%6%010 € ,890.499%9%010 € 34.8930%010 € 3,(60.40101%010 € 438.0103%010 € 3,94.0010(%010 € 3,633.10108%010 € 1,404.4
109%010 € 4,8%.001010%010 € %,0(1.%01013%010 € 99%.001014%010 € %,443.43101%010 € 4,6.01016%010 € 6,894.90101(%010 € 3,436.410%0%010 € %,4.0010%1%010 € %,%%3.0010%%%010 € 10,164.8010%3%010 € 1,(34.0
10%4%010 € %,8%(.9010%(%010 € %,911.(10%9%010 € 10,481.41030%010 € 4,960.901031%010 € %,1(.3114%010 € 1,(0.0011%010 € %,00.911(%010 € 9.01110%010 € 1,49.001111%010 € 1,%96.(111%%010 € 1,498.3
1114%010 € 4,%%4.(111(%010 € %40.001118%010 € 3,916.111%0%010 € 3,4%4.0011%1%010 € 4,164.3011%4%010 € %,3%6.611%%010 € 1,884.411%6%010 € 1,91%.811%(%010 € 4,6(3.0011%8%010 € 4,396.01%%%010 € 1,990.00
1%3%010 € 1,631.481%4%010 € 1,644.601%%010 € %,%(9.01%8%010 € 3,409.001%9%010 € 8,16%.601%10%010 € %,91(.001%1%%010 € %,8(3.0%1%1%010 € 4,8(.001%16%010 € %,030.40
8/18/2019 Ejercicio 3 - Tabla Dinámica
10/62
1%1(%010 € %36.%1%18%010 € 6,63.%(1%19%010 € (,101.601%%%%010 € 1,00.01%%3%010 € 1,31.081%%4%010 € 484.001%%%010 € (%0.00
1%%6%010 € 3,(3.%61%31%010 € (,113.(011%011 € 1,8%9.(61%%011 € 3,%(.(1%011 € 4,3%8.6316%011 € 1,193.011(%011 € %,60.4018%011 € 1,043.1019%011 € 4,(88.4011%%011 € %,%.80113%011 € 14,918.84
114%011 € 6,3.(11%011 € 6(8.00116%011 € (14.90119%011 € %,639.3%1%0%011 € %,18.001%1%011 € (,(49.301%%%011 € 8%(.1%3%011 € 9,4(0.%11%6%011 € 894.001%9%011 € 6,48(.0130%011 € 8,66%.(%
%%%011 € 4,%6%.69%3%011 € 1,%(4.00%4%011 € 1%,1%.34%%011 € %,966.0%6%011 € 3,6%1.%%%9%011 € 4,30(.%6%10%011 € (,(1.1%11%011 € 408.40%1%%011 € %0,1.00%13%011 € 1,38.0(%16%011 € %81.%0
%1(%011 € 3,964.%18%011 € 3,(19.10%19%011 € 4,414.06%%0%011 € 9,183.8%%3%011 € %0,%8.00%%%011 € 10,83.%4%%6%011 € 1,06.90%%(%011 € %,(83.%3%%011 € 4,%04.0
8/18/2019 Ejercicio 3 - Tabla Dinámica
11/62
33%011 € %,000.4834%011 € 3,310.%3%011 € 1,600.036%011 € 1,03.1039%011 € 3,01%.(0310%011 € 6(0.00311%011 € %,3%(.(9
31%%011 € 1,6(4.(313%011 € 3,31.8316%011 € 3,8(%.4(31(%011 € 4,4%%.00318%011 € 10,4(4.0319%011 € ,%(9.93%0%011 € 6,4%%.683%3%011 € 4,18.(3%4%011 € 4,31%.333%%011 € 4,441.%3%6%011 € 309.30
3%(%011 € 3,%.(330%011 € %,0(.90331%011 € 4,813.041%011 € 1,408.004%%011 € %1,830.4443%011 € 3,%30.346%011 € 4,688.904(%011 € (,043.948%011 € ,339.149%011 € 940.0410%011 € 14,0%4.69
413%011 € ,943.90414%011 € 3,6(%.(41%011 € (%.8(416%011 € 4,018.041(%011 € 3,(9.304%0%011 € 10,1%.%64%1%011 € 9,1(1.%44%%%011 € 3,8%.004%3%011 € 13,438.494%4%011 € (,6%(.804%(%011 € 14,01.%
4%8%011 € %,803.004%9%011 € 3,%6.00430%011 € 1,%(.601%011 € 6,93%.%%Total Result € 1,228,327.40
8/18/2019 Ejercicio 3 - Tabla Dinámica
12/62
País Vendedor Fecha del ed!do "dPed!do
RU "u#$anan € 440.00 (16%009 10%48
RU Suama € 1,863.40 (10%009 10%49
EE.UU. Pea#o#/ € 1,%.60 (1%%009 10%0
EE.UU. e'erlin € 64.06 (1%009 10%1
EE.UU. Pea#o#/ € 3,9(.90 (11%009 10%%EE.UU. e'erlin € 1,444.80 (16%009 10%3
RU "u#$anan € 6.6% (%3%009 10%4
RU &ods)or!$ € %,490.0 (1%009 10%
EE.UU. e'erlin € 1(.80 (1(%009 10%6
EE.UU. Pea#o#/ € 1,119.90 (%%%009 10%(
EE.UU. &a'olio € 1,614.88 (%3%009 10%8
EE.UU. Pea#o#/ € 100.80 (%%009 10%9
EE.UU. Pea#o#/ € 1,04.6 (%9%009 10%60
EE.UU. Pea#o#/ € 448.00 (30%009 10%61
EE.UU. alla$an € 84.00 (%%009 10%6%
RU &ods)or!$ € 1,8(3.80 (31%009 10%63RU Suama € 69.6% 8%3%009 10%64
EE.UU. *uller € 1,1(6.00 81%%009 10%6
EE.UU. e'erlin € 346.6 (31%009 10%66
EE.UU. Pea#o#/ € 3,36.60 86%009 10%6(
EE.UU. alla$an € 1,101.%0 8%%009 10%68
RU "u#$anan € 64%.%0 89%009 10%69
EE.UU. &a'olio € 1,3(6.00 8%%009 10%(0
RU Suama € 48.00 830%009 10%(1
RU Suama € 1,46.00 86%009 10%(%
EE.UU. e'erlin € %,03(.%8 81%%009 10%(3
RU Suama € 38.60 816%009 10%(4EE.UU. &a'olio € %91.84 89%009 10%(
EE.UU. alla$an € 4%0.00 814%009 10%(6
EE.UU. *uller € 1,%00.80 813%009 10%((
EE.UU. alla$an € 1,488.80 816%009 10%(8
EE.UU. alla$an € 31.00 816%009 10%(9
EE.UU. *uller € 613.%0 91%%009 10%80
EE.UU. Pea#o#/ € 86.0 8%1%009 10%81
EE.UU. Pea#o#/ € 1.40 8%1%009 10%8%
EE.UU. e'erlin € 1,414.80 8%3%009 10%83
EE.UU. Pea#o#/ € 1,1(0.3( 8%(%009 10%84
EE.UU. &a'olio € 1,(43.36 8%6%009 10%8
EE.UU. alla$an € 3,016.00 830%009 10%86
EE.UU. alla$an € 819.00 8%8%009 10%8(
EE.UU. Pea#o#/ € 80.10 93%009 10%88
RU +in € 4(9.40 8%8%009 10%89
EE.UU. alla$an € %,169.00 93%009 10%90
RU Suama € 49(.% 94%009 10%91
EE.UU. &a'olio € 1,%96.00 9%%009 10%9%
Valor del ed!do
8/18/2019 Ejercicio 3 - Tabla Dinámica
13/62
EE.UU. &a'olio € 848.(0 911%009 10%93
EE.UU. Pea#o#/ € 1,88(.60 9%009 10%94
EE.UU. *uller € 1%1.60 910%009 10%9
RU Suama € 1,00.60 911%009 10%96
RU "u#$anan € 1,4%0.00 910%009 10%9(
RU Suama € %,64.00 911%009 10%98
EE.UU. Pea#o#/ € 349.0 913%009 10%99
EE.UU. *uller € 608.00 918%009 10300
EE.UU. alla$an € (.00 91(%009 10301
EE.UU. Pea#o#/ € %,(08.80 109%009 1030%
RU +in € 1,11(.80 918%009 10303
EE.UU. &a'olio € 94.40 91(%009 10304
EE.UU. alla$an € 3,(41.30 109%009 1030
EE.UU. &a'olio € 498.0 9%3%009 10306
EE.UU. *uller € 4%4.00 9%%009 1030(
RU +in € 88.80 9%4%009 10308
EE.UU. e'erlin € 1,(6%.00 10%3%009 10309
EE.UU. alla$an € 336.00 9%(%009 10310EE.UU. &a'olio € %68.80 9%6%009 10311
EE.UU. *uller € 1,614.80 103%009 1031%
EE.UU. *uller € 18%.40 104%009 10313
EE.UU. &a'olio € %,094.30 104%009 10314
EE.UU. Pea#o#/ € 16.80 103%009 1031
EE.UU. &a'olio € %,83.00 108%009 10316
RU Suama € %88.00 1010%009 1031(
EE.UU. alla$an € %40.40 104%009 10318
RU +in € 1,191.%0 1011%009 10319
RU "u#$anan € 16.00 1018%009 103%0
EE.UU. e'erlin € 144.00 1011%009 103%1RU +in € 11%.00 10%3%009 103%%
EE.UU. Pea#o#/ € 164.40 1014%009 103%3
RU &ods)or!$ € ,%(.(1 1010%009 103%4
EE.UU. &a'olio € 1,49(.00 1014%009 103%
EE.UU. Pea#o#/ € 98%.00 1014%009 103%6
EE.UU. *uller € 1,810.00 1014%009 103%(
EE.UU. Pea#o#/ € 1,168.00 101(%009 103%8
EE.UU. Pea#o#/ € 4,(8.43 10%3%009 103%9
EE.UU. e'erlin € 1,649.00 10%8%009 10330
RU &ods)or!$ € 88.0 10%1%009 10331
EE.UU. e'erlin € 1,(86.88 10%1%009 1033%RU "u#$anan € 8((.%0 10%%009 10333
EE.UU. alla$an € 144.80 10%8%009 10334
RU +in € %,036.16 10%4%009 1033
RU +in € %8.1% 10%%009 10336
EE.UU. Pea#o#/ € %,46(.00 10%9%009 1033(
EE.UU. Pea#o#/ € 934.0 10%9%009 10338
EE.UU. *uller € 3,34.00 114%009 10339
EE.UU. &a'olio € %,436.18 118%009 10340
8/18/2019 Ejercicio 3 - Tabla Dinámica
14/62
RU +in € 3%.60 11%009 10341
EE.UU. Pea#o#/ € 1,840.64 114%009 1034%
EE.UU. Pea#o#/ € 1,84.00 116%009 10343
EE.UU. Pea#o#/ € %,%96.00 11%009 10344
EE.UU. *uller € %,9%4.80 1111%009 1034
EE.UU. e'erlin € 1,618.88 118%009 10346
EE.UU. Pea#o#/ € 814.4% 118%009 1034(
EE.UU. Pea#o#/ € 363.60 111%009 10348
RU +in € 141.60 111%009 10349
RU Suama € 64%.06 1%3%009 1030
EE.UU. &a'olio € ,398.(% 11%0%009 1031
EE.UU. e'erlin € 136.30 1118%009 103%
RU +in € 8,93.%8 11%%009 1033
EE.UU. alla$an € 68.80 11%0%009 1034
RU Suama € 480.00 11%0%009 103
RU Suama € 1,106.40 11%(%009 1036
EE.UU. &a'olio € 1,16(.68 1%%%009 103(
RU "u#$anan € 4%9.40 11%(%009 1038RU "u#$anan € 3,4(1.68 11%6%009 1039
EE.UU. Pea#o#/ € (,390.%0 1%%%009 10360
EE.UU. &a'olio € %,046.%4 1%3%009 10361
EE.UU. e'erlin € 1,49.60 11%8%009 1036%
EE.UU. Pea#o#/ € 44(.%0 1%4%009 10363
EE.UU. &a'olio € 90.00 1%4%009 10364
EE.UU. e'erlin € 403.%0 1%%%009 1036
EE.UU. alla$an € 136.00 1%30%009 10366
RU +in € 834.%0 1%%%009 1036(
EE.UU. *uller € 1,689.(8 1%%%009 10368
EE.UU. alla$an € %,390.40 1%9%009 10369RU Suama € 1,11(.60 1%%(%009 103(0
EE.UU. &a'olio € (%.96 1%%4%009 103(1
RU "u#$anan € 9,%10.90 1%9%009 103(%
EE.UU. Pea#o#/ € 1,366.40 1%11%009 103(3
EE.UU. &a'olio € 49.00 1%9%009 103(4
EE.UU. e'erlin € 338.00 1%9%009 103(
EE.UU. &a'olio € 399.00 1%13%009 103(6
EE.UU. &a'olio € 863.60 1%13%009 103((
RU "u#$anan € 103.%0 1%19%009 103(8
EE.UU. *uller € 863.%8 1%13%009 103(9
EE.UU. alla$an € 1,313.8% 116%010 10380EE.UU. e'erlin € 11%.00 1%13%009 10381
EE.UU. Pea#o#/ € %,900.00 1%16%009 1038%
EE.UU. alla$an € 899.00 1%18%009 10383
EE.UU. e'erlin € %,%%%.40 1%%0%009 10384
EE.UU. &a'olio € 691.%0 1%%3%009 1038
RU &ods)or!$ € 166.00 1%%%009 10386
EE.UU. &a'olio € 1,08.40 1%%0%009 1038(
EE.UU. *uller € 1,%%8.80 1%%0%009 10388
8/18/2019 Ejercicio 3 - Tabla Dinámica
15/62
EE.UU. Pea#o#/ € 1,83%.80 1%%4%009 10389
RU Suama € %,090.88 1%%6%009 10390
EE.UU. e'erlin € 86.40 1%31%009 10391
EE.UU. *uller € 1,440.00 11%010 1039%
EE.UU. &a'olio € %,6.9 13%010 10393
EE.UU. &a'olio € 44%.00 13%010 10394
RU Suama € %,1%%.9% 13%010 1039
EE.UU. &a'olio € 1,903.80 16%010 10396
RU "u#$anan € (16.(% 1%%010 1039(
EE.UU. *uller € %,0.60 19%010 10398
EE.UU. alla$an € 1,(6.60 18%010 10399
EE.UU. &a'olio € 3,063.00 116%010 10400
EE.UU. &a'olio € 3,868.60 110%010 10401
EE.UU. alla$an € %,(13.0 110%010 1040%
EE.UU. Pea#o#/ € 8.01 19%010 10403
EE.UU. *uller € 1,91.% 18%010 10404
EE.UU. &a'olio € 400.00 1%%%010 1040
RU +in € 1,830.(8 113%010 10406EE.UU. *uller € 1,194.00 130%010 1040(
EE.UU. alla$an € 1,6%%.40 114%010 10408
EE.UU. e'erlin € 319.%0 114%010 10409
EE.UU. e'erlin € 80%.00 11%010 10410
RU &ods)or!$ € 966.80 1%1%010 10411
EE.UU. alla$an € 334.80 11%010 1041%
EE.UU. e'erlin € %,1%3.%0 116%010 10413
EE.UU. *uller € %%4.83 11(%010 10414
EE.UU. e'erlin € 10%.40 1%4%010 1041
EE.UU. alla$an € (%0.00 1%(%010 10416
EE.UU. Pea#o#/ € 11,188.40 1%8%010 1041(EE.UU. Pea#o#/ € 1,814.80 1%4%010 10418
EE.UU. Pea#o#/ € %,09(.60 130%010 10419
EE.UU. e'erlin € 1,(0(.84 1%(%010 104%0
EE.UU. alla$an € 1,194.%( 1%(%010 104%1
EE.UU. *uller € 49.80 131%010 104%%
RU Suama € 1,0%0.00 %%4%010 104%3
RU +in € 9,194.6 1%(%010 104%4
RU Suama € 360.00 %14%010 104%
EE.UU. Pea#o#/ € 338.%0 %6%010 104%6
EE.UU. Pea#o#/ € 61.00 33%010 104%(
RU +in € 19%.00 %4%010 104%8EE.UU. e'erlin € 1,441.3( %(%010 104%9
EE.UU. Pea#o#/ € 4,899.%0 %3%010 10430
EE.UU. Pea#o#/ € 1,89%.% %(%010 10431
EE.UU. e'erlin € 48.00 %(%010 1043%
EE.UU. e'erlin € 81.%0 34%010 10433
EE.UU. e'erlin € 3%1.1% %13%010 10434
EE.UU. alla$an € 631.60 %(%010 1043
EE.UU. e'erlin € 1,994.% %11%010 10436
8/18/2019 Ejercicio 3 - Tabla Dinámica
16/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
17/62
EE.UU. Pea#o#/ € 1,84.00 331%010 1048
EE.UU. &a'olio € 1,%(%.00 4%%010 10486
EE.UU. *uller € 889.(0 3%8%010 1048(
EE.UU. alla$an € 1,1%.00 4%%010 10488
RU Suama € 439.%0 49%010 10489
RU +in € 3,163.%0 43%010 10490
EE.UU. alla$an € %9.0 48%010 10491
EE.UU. e'erlin € 81.%0 411%010 1049%
EE.UU. Pea#o#/ € 608.40 410%010 10493
EE.UU. Pea#o#/ € 91%.00 49%010 10494
EE.UU. e'erlin € %(8.00 411%010 1049
RU +in € 190.00 4(%010 10496
RU +in € 1,380.60 4(%010 1049(
EE.UU. alla$an € (.00 411%010 10498
EE.UU. Pea#o#/ € 1,41%.00 416%010 10499
RU Suama € %3.%6 41(%010 1000
RU &ods)or!$ € 149.00 416%010 1001
EE.UU. *uller € 816.30 4%9%010 100%RU Suama € %,048.0 416%010 1003
EE.UU. Pea#o#/ € 1,388.0 418%010 1004
EE.UU. e'erlin € 14(.90 4%1%010 100
RU &ods)or!$ € 41.80 %%010 1006
RU +in € (49.06 4%%%010 100(
EE.UU. &a'olio € %40.00 13%010 1008
EE.UU. Pea#o#/ € 136.80 4%9%010 1009
RU Suama € 4,(0(.4 4%8%010 1010
EE.UU. Pea#o#/ € %,0.00 4%1%010 1011
RU +in € %.30 4%4%010 101%
RU +in € 1,94%.00 4%8%010 1013EE.UU. e'erlin € 8,6%3.4 16%010 1014
EE.UU. *uller € 9,9%1.30 %3%010 101
EE.UU. *uller € %,381.0 1%010 1016
EE.UU. e'erlin € 3%.00 4%9%010 101(
EE.UU. Pea#o#/ € 4,10.0 %010 1018
RU Suama € %,314.%0 1%010 1019
RU +in € %00.00 1%010 10%0
EE.UU. alla$an € %%.0 %%010 10%1
EE.UU. Pea#o#/ € %,318.%4 6%010 10%%
RU +in € %,444.31 30%010 10%3
EE.UU. &a'olio € 3,19%.6 (%010 10%4EE.UU. &a'olio € 818.40 %3%010 10%
EE.UU. Pea#o#/ € 1,11.40 1%010 10%6
RU +in € 1,03.00 (%010 10%(
RU Suama € 39%.%0 9%010 10%8
RU "u#$anan € 946.00 9%010 10%9
EE.UU. e'erlin € 4,180.00 1%%010 1030
RU +in € 110.00 19%010 1031
RU +in € (96.3 1%%010 103%
8/18/2019 Ejercicio 3 - Tabla Dinámica
18/62
EE.UU. alla$an € %,%%%.%0 %%%010 1033
EE.UU. alla$an € 46.(0 14%010 1034
EE.UU. Pea#o#/ € 1,940.8 %1%010 103
EE.UU. e'erlin € 1,64.00 66%010 1036
EE.UU. &a'olio € 1,8%3.80 19%010 103(
RU &ods)or!$ € 139.80 16%010 1038
RU Suama € 3.0 %3%010 1039
EE.UU. e'erlin € 10,191.(0 613%010 1040
EE.UU. *uller € 1,946.% %9%010 1041
EE.UU. &a'olio € 469.11 %6%010 104%
EE.UU. alla$an € 1,04.0 %3%010 1043
EE.UU. Pea#o#/ € 41(.%0 30%010 1044
EE.UU. alla$an € %10.00 6%6%010 104
EE.UU. &a'olio € %,81%.00 %(%010 1046
EE.UU. e'erlin € 1,(9%.80 6%%010 104(
EE.UU. e'erlin € %40.10 6%%010 1048
RU "u#$anan € 3,4.%( 30%010 1049
RU +in € 683.30 66%010 100EE.UU. Pea#o#/ € 1,6((.30 66%010 101
EE.UU. *uller € 880.0 6%010 10%
EE.UU. *uller € 1,46.30 63%010 103
EE.UU. Pea#o#/ € 1,(%8.% 6%010 104
RU Suama € %,944.40 64%010 10
EE.UU. *uller € 83.%0 613%010 106
RU &ods)or!$ € 1,1%.0 66%010 10(
EE.UU. &a'olio € %,14%.90 610%010 108
RU Suama € %0.41 613%010 109
EE.UU. alla$an € 1,0(%.4% 69%010 1060
EE.UU. *uller € %,844.0 69%010 1061EE.UU. &a'olio € 488.(0 61%%010 106%
EE.UU. *uller € 96.00 6%4%010 1063
EE.UU. Pea#o#/ € 1,%34.0 616%010 1064
EE.UU. alla$an € 639.90 618%010 106
RU &ods)or!$ € 1,(61.00 618%010 1066
EE.UU. &a'olio € %,19.00 61(%010 106(
EE.UU. e'erlin € 1.00 (9%010 1068
RU "u#$anan € 890.00 (11%010 1069
EE.UU. e'erlin € %,46.% 619%010 10(0
EE.UU. alla$an € 0.9 (4%010 10(1
EE.UU. e'erlin € 1,01.08 6%%010 10(%RU +in € %,08%.00 6%0%010 10(3
EE.UU. Pea#o#/ € (64.30 630%010 10(4
RU "u#$anan € %,14(.40 630%010 10(
EE.UU. e'erlin € 838.4 630%010 10(6
RU &ods)or!$ € 69.00 630%010 10((
EE.UU. Pea#o#/ € 4((.00 (%%010 10(8
EE.UU. &a'olio € 31(.( (4%010 10(9
EE.UU. Pea#o#/ € 1,013.(4 (1%010 1080
8/18/2019 Ejercicio 3 - Tabla Dinámica
19/62
EE.UU. e'erlin € 310.00 (%%010 1081
EE.UU. e'erlin € 330.00 (14%010 108%
EE.UU. *uller € %,%3(.0 (4%010 1083
EE.UU. Pea#o#/ € 93.( (4%010 1084
RU +in € 14%.0 (10%010 108
RU &ods)or!$ € %3.80 (9%010 1086
EE.UU. &a'olio € 80(.38 (9%010 108(
EE.UU. *uller € 3,1%0.00 (10%010 1088
EE.UU. alla$an € (%.00 (14%010 1089
EE.UU. Pea#o#/ € 1,101.00 (14%010 1090
EE.UU. &a'olio € 81%.0 (16%010 1091
EE.UU. e'erlin € 16.46 (16%010 109%
RU +in € 1,994.40 813%010 1093
EE.UU. e'erlin € 6.0 (16%010 1094
EE.UU. *uller € 4,(%.00 (14%010 109
EE.UU. alla$an € 1,180.88 81%%010 1096
RU +in € (18.08 (18%010 109(
EE.UU. &a'olio € %,388.0 (18%010 1098RU Suama € 493.00 (%1%010 1099
EE.UU. Pea#o#/ € 4(9.80 (%1%010 10600
RU +in € %,%8.00 (%%%010 10601
EE.UU. alla$an € 48.( (%%%010 1060%
EE.UU. alla$an € 1,483.00 88%010 10603
EE.UU. &a'olio € %30.8 (%9%010 10604
EE.UU. &a'olio € 4,109.69 (%9%010 1060
EE.UU. Pea#o#/ € 1,130.40 (31%010 10606
RU "u#$anan € 6,4(.40 (%%010 1060(
EE.UU. Pea#o#/ € 1,064.00 81%010 10608
RU +in € 4%4.00 (30%010 10609EE.UU. alla$an € %99.% 86%010 10610
RU Suama € 808.00 81%010 10611
EE.UU. &a'olio € 6,3(.00 81%010 1061%
EE.UU. Pea#o#/ € 33.%0 81%010 10613
EE.UU. alla$an € 464.00 81%010 10614
EE.UU. *uller € 1%0.00 86%010 1061
EE.UU. &a'olio € 4,806.99 8%010 10616
EE.UU. Pea#o#/ € 1,40%.0 84%010 1061(
EE.UU. &a'olio € %,69(.0 88%010 10618
EE.UU. e'erlin € 1,%60.00 8(%010 10619
EE.UU. *uller € (.0 814%010 106%0EE.UU. Pea#o#/ € (8.0 811%010 106%1
EE.UU. Pea#o#/ € 60.00 811%010 106%%
EE.UU. alla$an € 1,336.9 81%%010 106%3
EE.UU. Pea#o#/ € 1,393.%4 819%010 106%4
EE.UU. e'erlin € 4(9.( 814%010 106%
EE.UU. &a'olio € 1,03.60 8%0%010 106%6
EE.UU. alla$an € 1,18.( 8%1%010 106%(
EE.UU. Pea#o#/ € 40.00 8%0%010 106%8
8/18/2019 Ejercicio 3 - Tabla Dinámica
20/62
EE.UU. Pea#o#/ € %,((.0 8%0%010 106%9
EE.UU. &a'olio € 903.60 819%010 10630
EE.UU. alla$an € .80 81%010 10631
EE.UU. alla$an € 89.00 819%010 1063%
RU +in € ,10.9 818%010 10633
EE.UU. Pea#o#/ € 4,98.0 8%1%010 10634
EE.UU. alla$an € 1,3%6.%% 8%1%010 1063
EE.UU. Pea#o#/ € 6%9.0 8%6%010 10636
RU Suama € %,(61.94 8%6%010 1063(
EE.UU. e'erlin € %,(%0.0 91%010 10638
RU +in € 00.00 8%(%010 10639
EE.UU. Pea#o#/ € (08.( 8%8%010 10640
EE.UU. Pea#o#/ € %,04.00 8%6%010 10641
RU +in € 696.00 9%010 1064%
RU Suama € 814.0 9%%010 10643
EE.UU. e'erlin € 1,3(1.80 91%010 10644
EE.UU. Pea#o#/ € 1,3.00 9%%010 1064
RU &ods)or!$ € 1,446.00 93%010 10646EE.UU. Pea#o#/ € 636.00 93%010 1064(
RU "u#$anan € 3(%.3( 99%010 10648
RU "u#$anan € 1,434.00 8%9%010 10649
RU "u#$anan € 1,((9.%0 93%010 1060
EE.UU. alla$an € 39(.80 911%010 1061
EE.UU. Pea#o#/ € 318.84 98%010 106%
EE.UU. &a'olio € 1,083.1 919%010 1063
RU "u#$anan € 601.83 911%010 1064
EE.UU. &a'olio € 14.40 911%010 106
RU Suama € 604.%1 910%010 1066
EE.UU. *uller € 4,3(1.60 91%010 106(EE.UU. Pea#o#/ € 4,464.60 98%010 1068
RU +in € 1,%%(.0% 910%010 1069
EE.UU. alla$an € 1,(01.00 101%010 10660
RU +in € 6%.60 91%010 10661
EE.UU. e'erlin € 1%.00 918%010 1066%
EE.UU. *uller € 1,930.40 103%010 10663
EE.UU. &a'olio € 1,%88.39 919%010 10664
EE.UU. &a'olio € 1,%9.00 91(%010 1066
RU +in € 4,666.94 9%%%010 10666
RU +in € 1,36.80 919%010 1066(
EE.UU. &a'olio € 6%.%( 9%3%010 10668EE.UU. *uller € (0.00 9%%%010 10669
EE.UU. Pea#o#/ € %,301.( 918%010 106(0
EE.UU. &a'olio € 9%0.10 9%4%010 106(1
RU &ods)or!$ € 3,81.% 9%6%010 106(%
EE.UU. *uller € 41%.3 919%010 106(3
EE.UU. Pea#o#/ € 4.00 930%010 106(4
RU "u#$anan € 1,4%3.00 9%3%010 106(
EE.UU. *uller € 34.8 9%9%010 106(6
8/18/2019 Ejercicio 3 - Tabla Dinámica
21/62
EE.UU. &a'olio € 813.36 9%6%010 106((
RU +in € ,%6.0 1016%010 106(8
EE.UU. alla$an € 660.00 930%010 106(9
EE.UU. &a'olio € 1,%61.88 9%6%010 10680
EE.UU. e'erlin € 1,%8(.40 930%010 10681
EE.UU. e'erlin € 3(.0 101%010 1068%
EE.UU. *uller € 63.00 101%010 10683
EE.UU. e'erlin € 1,(68.00 930%010 10684
EE.UU. Pea#o#/ € 801.10 103%010 1068
EE.UU. *uller € 1,404.4 108%010 10686
RU &ods)or!$ € 4,960.90 1030%010 1068(
EE.UU. Pea#o#/ € 3,160.60 10(%010 10688
EE.UU. &a'olio € 4(%.0 10(%010 10689
EE.UU. &a'olio € 86%.0 103%010 10690
EE.UU. *uller € 10,164.80 10%%%010 10691
EE.UU. Pea#o#/ € 8(8.00 1013%010 1069%
EE.UU. e'erlin € %,0(1.%0 1010%010 10693
EE.UU. alla$an € 4,8%.00 109%010 10694RU +in € 64%.00 1014%010 1069
EE.UU. alla$an € 996.00 1014%010 10696
EE.UU. e'erlin € 80.43 1014%010 1069(
EE.UU. Pea#o#/ € 3,436.4 101(%010 10698
EE.UU. e'erlin € 114.00 1013%010 10699
EE.UU. e'erlin € 1,638.40 1016%010 10(00
RU Suama € %,864.0 101%010 10(01
EE.UU. Pea#o#/ € 330.00 10%1%010 10(0%
RU Suama € %,4.00 10%0%010 10(03
RU Suama € 9.0 11(%010 10(04
RU &ods)or!$ € 3(8.00 1118%010 10(0EE.UU. alla$an € 1,893.00 10%1%010 10(06
EE.UU. Pea#o#/ € 1,641.00 10%3%010 10(0(
RU Suama € 180.40 11%010 10(08
EE.UU. &a'olio € 3,4%4.00 11%0%010 10(09
EE.UU. &a'olio € 93.0 10%3%010 10(10
RU "u#$anan € 4,41.(0 10%9%010 10(11
EE.UU. e'erlin € 1,%33.48 1031%010 10(1%
EE.UU. &a'olio € %,8%(.90 10%4%010 10(13
RU "u#$anan € %,%0.( 10%(%010 10(14
EE.UU. e'erlin € 1,%96.00 10%9%010 10(1
EE.UU. Pea#o#/ € (06.00 10%(%010 10(16EE.UU. &a'olio € 1,%(0.( 10%9%010 10(1(
EE.UU. &a'olio € 3,463.00 10%9%010 10(18
EE.UU. alla$an € 844.% 11%010 10(19
EE.UU. alla$an € 0.00 11%010 10(%0
RU "u#$anan € 9%3.8( 1031%010 10(%1
EE.UU. alla$an € 1,(0.00 114%010 10(%%
EE.UU. e'erlin € 468.4 11%%010 10(%3
EE.UU. alla$an € 638.0 11%010 10(%4
8/18/2019 Ejercicio 3 - Tabla Dinámica
22/62
EE.UU. Pea#o#/ € %8(.80 11%010 10(%
EE.UU. Pea#o#/ € 6.00 1%%010 10(%6
EE.UU. *uller € 1,6%4.0 1%%010 10(%(
EE.UU. Pea#o#/ € 1,%96.( 1111%010 10(%8
EE.UU. alla$an € 1,80.00 1114%010 10(%9
RU "u#$anan € 484.% 1114%010 10(30
RU +in € 1,890.0 1114%010 10(31
EE.UU. e'erlin € 360.00 11(%010 10(3%
EE.UU. &a'olio € 1,49.00 1110%010 10(33
EE.UU. *uller € 1,498.3 111%%010 10(34
RU Suama € 36.40 11%1%010 10(3
RU &ods)or!$ € 99(.00 11%1%010 10(36
EE.UU. *uller € 139.80 1118%010 10(3(
EE.UU. *uller € %.3 1118%010 10(38
EE.UU. e'erlin € %40.00 111(%010 10(39
EE.UU. Pea#o#/ € 1,416.00 11%%010 10(40
EE.UU. Pea#o#/ € %%8.00 1118%010 10(41
EE.UU. e'erlin € 3,118.00 1118%010 10(4%EE.UU. &a'olio € 319.%0 11%1%010 10(43
RU Suama € (36.00 11%4%010 10(44
RU &ods)or!$ € 4,%9.80 11%(%010 10(4
EE.UU. &a'olio € %,311.(0 11%1%010 10(46
RU Suama € 1,91%.8 11%6%010 10(4(
EE.UU. e'erlin € %,196.00 11%8%010 10(48
EE.UU. Pea#o#/ € 1,080.00 1%19%010 10(49
RU &ods)or!$ € 1,90.6 11%4%010 10(0
EE.UU. e'erlin € 1,631.48 1%3%010 10(1
EE.UU. *uller € %%.00 11%8%010 10(%
EE.UU. e'erlin € 88.00 11%(%010 10(3RU Suama € .%0 11%(%010 10(4
EE.UU. Pea#o#/ € 1,948.0 11%8%010 10(
EE.UU. alla$an € 1,990.00 1%%%010 10(6
RU Suama € 3,08%.00 1%1%010 10((
EE.UU. e'erlin € 1,644.60 1%4%010 10(8
EE.UU. e'erlin € 3%0.00 1%1%%010 10(9
EE.UU. Pea#o#/ € %,91(.00 1%10%010 10(60
RU "u#$anan € 0(.00 1%8%010 10(61
EE.UU. e'erlin € 4,33(.00 1%9%010 10(6%
EE.UU. e'erlin € 616.00 1%8%010 10(63
RU Suama € %,%86.00 1%8%010 10(64EE.UU. e'erlin € 1,1.60 1%9%010 10(6
EE.UU. Pea#o#/ € %,310.00 1%9%010 10(66
EE.UU. Pea#o#/ € %8.00 1%1%010 10(6(
EE.UU. e'erlin € 1,4((.00 1%1%010 10(68
EE.UU. e'erlin € 1,684.%( 1%1%%010 10(69
EE.UU. alla$an € %36.% 1%1(%010 10((0
RU &ods)or!$ € 344.00 1%%010 10((1
EE.UU. e'erlin € 3,603.%% 1%19%010 10((%
8/18/2019 Ejercicio 3 - Tabla Dinámica
23/62
EE.UU. &a'olio € %,030.40 1%16%010 10((3
EE.UU. Pea#o#/ € 868.( 1%1%%010 10((4
RU +in € %%8.00 1%%6%010 10((
EE.UU. &a'olio € 6,63.%( 1%18%010 10((6
RU +in € %%4.00 1%1%011 10(((
EE.UU. e'erlin € 96.0 1%%4%010 10((8
EE.UU. e'erlin € 1,33.00 114%011 10((9
EE.UU. *uller € (%0.00 1%%%010 10(80
EE.UU. *uller € 9(.88 1%19%010 10(81
RU &ods)or!$ € 1%.0 1%%%%010 10(8%
EE.UU. Pea#o#/ € 1,44%.0 1%19%010 10(83
EE.UU. Pea#o#/ € 1,488.00 1%%%%010 10(84
EE.UU. &a'olio € 38(.0 1%%4%010 10(8
EE.UU. alla$an € 1,31.08 1%%3%010 10(86
EE.UU. *uller € %,6%%.(6 1%%6%010 10(8(
EE.UU. &a'olio € (31.0 119%011 10(88
EE.UU. &a'olio € 3,68(.00 1%31%010 10(89
RU Suama € (%%.0 1%%6%010 10(90RU Suama € 1,8%9.(6 11%011 10(91
EE.UU. &a'olio € 399.8 1%31%010 10(9%
EE.UU. e'erlin € 191.10 18%011 10(93
RU Suama € 314.(6 1%%011 10(94
EE.UU. alla$an € %,18.00 1%0%011 10(9
EE.UU. e'erlin € %,341.36 114%011 10(96
RU +in € 4%0.00 1%011 10(9(
EE.UU. *uller € 446.60 1%011 10(98
RU &ods)or!$ € 1,3.0 1%011 10(99
EE.UU. &a'olio € 1,468.93 1%011 10800
EE.UU. Pea#o#/ € 3,0%6.8 1%31%010 10801EE.UU. Pea#o#/ € %,94%.81 1%%011 1080%
EE.UU. Pea#o#/ € 1,193.01 16%011 10803
RU Suama € %,%(8.40 1(%011 10804
EE.UU. *uller € %,((.00 19%011 1080
EE.UU. e'erlin € 439.60 1%011 10806
EE.UU. Pea#o#/ € 18.40 130%011 1080(
EE.UU. *uller € 1,411.00 19%011 10808
RU +in € 140.00 1(%011 10809
EE.UU. *uller € 18(.00 1(%011 10810
EE.UU. alla$an € 8%.00 18%011 10811
RU "u#$anan € 1,69%.80 11%%011 1081%EE.UU. &a'olio € 60%.40 19%011 10813
EE.UU. e'erlin € 1,(88.4 114%011 10814
EE.UU. *uller € 40.00 114%011 1081
EE.UU. Pea#o#/ € 8,446.4 %4%011 10816
EE.UU. e'erlin € 10,9%.84 113%011 1081(
RU +in € 833.00 11%%011 10818
EE.UU. *uller € 4((.00 116%011 10819
EE.UU. e'erlin € 1,140.00 113%011 108%0
8/18/2019 Ejercicio 3 - Tabla Dinámica
24/62
EE.UU. &a'olio € 6(8.00 11%011 108%1
RU Suama € %3(.90 116%011 108%%
RU "u#$anan € %,8%6.00 113%011 108%3
EE.UU. alla$an € %0.80 130%011 108%4
EE.UU. &a'olio € 1,030.(6 114%011 108%
RU Suama € (30.00 %6%011 108%6
EE.UU. &a'olio € 843.00 %6%011 108%(
RU &ods)or!$ € 93%.00 %4%011 108%8
RU &ods)or!$ € 1,(64.00 1%3%011 108%9
EE.UU. Pea#o#/ € 1,9(4.00 1%1%011 10830
EE.UU. e'erlin € %,684.40 1%3%011 10831
EE.UU. *uller € 4(.11 119%011 1083%
RU Suama € 906.93 1%3%011 10833
EE.UU. &a'olio € 1,43%.(1 119%011 10834
EE.UU. &a'olio € 84.80 1%1%011 1083
RU +in € 4,(0.0 1%1%011 10836
RU &ods)or!$ € 1,064.0 1%3%011 1083(
EE.UU. e'erlin € 1,938.38 1%3%011 10838EE.UU. e'erlin € 8%(. 1%%%011 10839
EE.UU. Pea#o#/ € %11.%0 %16%011 10840
RU "u#$anan € 4,81.00 1%9%011 10841
EE.UU. &a'olio € 9(.00 1%9%011 1084%
EE.UU. Pea#o#/ € 19.00 1%6%011 10843
EE.UU. alla$an € (3.00 1%6%011 10844
EE.UU. alla$an € 3,81%.(0 130%011 1084
EE.UU. *uller € 1,11%.00 1%3%011 10846
EE.UU. Pea#o#/ € 4,931.9% %10%011 1084(
RU +in € 931.0 1%9%011 10848
RU &ods)or!$ € 96(.8% 130%011 10849EE.UU. &a'olio € 6%9.00 130%011 1080
RU "u#$anan € %,603.00 %%%011 1081
EE.UU. alla$an € %,984.00 130%011 108%
RU &ods)or!$ € 6%.00 %3%011 1083
EE.UU. e'erlin € %,966.0 %%011 1084
EE.UU. e'erlin € %,%%(.89 %4%011 108
EE.UU. e'erlin € 660.00 %10%011 1086
EE.UU. alla$an € %,048.%% %6%011 108(
EE.UU. *uller € 649.00 %3%011 1088
EE.UU. &a'olio € 1,0(8.69 %%%011 1089
EE.UU. e'erlin € 19.00 %4%011 10860EE.UU. Pea#o#/ € 3,%3.40 %1(%011 10861
EE.UU. alla$an € 81.00 %%%011 1086%
EE.UU. Pea#o#/ € 441.1 %1(%011 10863
EE.UU. Pea#o#/ € %8%.00 %9%011 10864
EE.UU. *uller € 16,38(.0 %1%%011 1086
RU "u#$anan € 1,096.%0 %1%%011 10866
RU Suama € 98.40 %11%011 1086(
RU +in € 1,9%0.60 %%3%011 10868
8/18/2019 Ejercicio 3 - Tabla Dinámica
25/62
RU "u#$anan € 1,630.00 %9%011 10869
RU "u#$anan € 160.00 %13%011 108(0
RU &ods)or!$ € 1,9(9.%3 %10%011 108(1
RU "u#$anan € %,08.46 %9%011 108(%
EE.UU. Pea#o#/ € 336.80 %9%011 108(3
RU "u#$anan € 310.00 %11%011 108(4
EE.UU. Pea#o#/ € (09. 33%011 108(
RU +in € 91(.00 %1%%011 108(6
EE.UU. &a'olio € 1,9.13 %19%011 108((
EE.UU. Pea#o#/ € 1,39.00 %1%%011 108(8
EE.UU. e'erlin € 611.30 %1%%011 108(9
RU +in € 1,00.00 %18%011 10880
EE.UU. Pea#o#/ € 10.00 %18%011 10881
EE.UU. Pea#o#/ € 89%.64 %%0%011 1088%
EE.UU. alla$an € 36.00 %%0%011 10883
EE.UU. Pea#o#/ € 1,3(8.0( %13%011 10884
RU Suama € 1,%09.00 %18%011 1088
EE.UU. &a'olio € 3,1%(.0 3%%011 10886EE.UU. alla$an € (0.00 %16%011 1088(
EE.UU. &a'olio € 60.00 %%3%011 10888
RU &ods)or!$ € 11,380.00 %%3%011 10889
RU +in € 860.10 %18%011 10890
RU +in € 368.93 %19%011 10891
EE.UU. Pea#o#/ € %,090.00 %19%011 1089%
RU &ods)or!$ € ,0%.11 %%0%011 10893
EE.UU. &a'olio € %,(3.10 %%0%011 10894
EE.UU. e'erlin € 6,3(9.40 %%3%011 1089
RU +in € (0.0 %%(%011 10896
EE.UU. e'erlin € 10,83.%4 %%%011 1089(EE.UU. Pea#o#/ € 30.00 36%011 10898
RU "u#$anan € 1%%.40 %%6%011 10899
EE.UU. &a'olio € 33.( 34%011 10900
EE.UU. Pea#o#/ € 934.0 %%6%011 10901
EE.UU. &a'olio € 863.43 33%011 1090%
EE.UU. e'erlin € 93%.0 34%011 10903
EE.UU. e'erlin € 1,9%4.% %%(%011 10904
RU &ods)or!$ € 34%.00 36%011 1090
EE.UU. Pea#o#/ € 4%(.0 33%011 10906
RU Suama € 108.0 %%(%011 1090(
EE.UU. Pea#o#/ € 663.10 36%011 10908EE.UU. &a'olio € 6(0.00 310%011 10909
EE.UU. &a'olio € 4%.90 34%011 10910
EE.UU. e'erlin € 88.00 3%011 10911
EE.UU. *uller € 6,%00. 318%011 1091%
EE.UU. Pea#o#/ € (68.( 34%011 10913
RU Suama € 3(.0 3%%011 10914
EE.UU. *uller € 39.0 3%%011 1091
EE.UU. &a'olio € 686.(0 39%011 10916
8/18/2019 Ejercicio 3 - Tabla Dinámica
26/62
EE.UU. Pea#o#/ € 36.89 311%011 1091(
EE.UU. e'erlin € 1,44(.0 311%011 10918
EE.UU. *uller € 1,1%%.80 34%011 10919
EE.UU. Pea#o#/ € 390.00 39%011 109%0
EE.UU. &a'olio € 1,936.00 39%011 109%1
RU "u#$anan € (4%.0 3%011 109%%
RU +in € (48.80 313%011 109%3
EE.UU. e'erlin € 1,83.(0 48%011 109%4
EE.UU. e'erlin € 4(.1 313%011 109%
EE.UU. Pea#o#/ € 14.40 311%011 109%6
EE.UU. Pea#o#/ € 800.00 48%011 109%(
EE.UU. &a'olio € 13(.0 318%011 109%8
RU Suama € 1,1(4.( 31%%011 109%9
EE.UU. Pea#o#/ € %,%.0 318%011 10930
EE.UU. Pea#o#/ € (99.%0 319%011 10931
EE.UU. alla$an € 1,(88.63 3%4%011 1093%
RU Suama € 9%0.60 316%011 10933
EE.UU. e'erlin € 00.00 31%%011 10934EE.UU. Pea#o#/ € 619.0 318%011 1093
EE.UU. e'erlin € 46.00 318%011 10936
RU +in € 644.80 313%011 1093(
EE.UU. e'erlin € %,(31.8( 316%011 10938
EE.UU. *uller € 63(.0 313%011 10939
EE.UU. alla$an € 360.00 3%3%011 10940
RU +in € 4,011.( 3%0%011 10941
RU &ods)or!$ € 60.00 318%011 1094%
EE.UU. Pea#o#/ € (11.00 319%011 10943
RU Suama € 1,0%.33 313%011 10944
EE.UU. Pea#o#/ € %4.00 318%011 1094EE.UU. &a'olio € 1,40(.0 319%011 10946
EE.UU. e'erlin € %%0.00 316%011 1094(
EE.UU. e'erlin € %,36%.% 319%011 10948
EE.UU. *uller € 4,4%%.00 31(%011 10949
EE.UU. &a'olio € 110.00 3%3%011 1090
RU &ods)or!$ € 48.(4 4(%011 1091
EE.UU. &a'olio € 4(1.%0 3%4%011 109%
RU &ods)or!$ € 4,441.% 3%%011 1093
RU "u#$anan € 1,69.3 3%0%011 1094
EE.UU. alla$an € (4.40 3%0%011 109
RU Suama € 6((.00 3%0%011 1096EE.UU. alla$an € 1,(6%.(0 3%(%011 109(
RU +in € (81.00 3%(%011 1098
RU Suama € 131.( 3%3%011 1099
EE.UU. e'erlin € %6.3 48%011 10960
EE.UU. alla$an € 1,119.90 330%011 10961
EE.UU. alla$an € 3,84.00 3%3%011 1096%
RU &ods)or!$ € (.80 3%6%011 10963
EE.UU. e'erlin € %,0%.0 3%4%011 10964
8/18/2019 Ejercicio 3 - Tabla Dinámica
27/62
RU Suama € 848.00 330%011 1096
EE.UU. Pea#o#/ € 1,098.46 48%011 10966
EE.UU. *uller € 910.40 4%%011 1096(
EE.UU. &a'olio € 1,408.00 41%011 10968
EE.UU. &a'olio € 108.00 330%011 10969
RU &ods)or!$ € %%4.00 4%4%011 109(0
EE.UU. *uller € 1,(33.06 4%%011 109(1
EE.UU. Pea#o#/ € %1.0 3%6%011 109(%
RU Suama € %91. 3%(%011 109(3
EE.UU. e'erlin € 439.00 43%011 109(4
EE.UU. &a'olio € (1(.0 3%(%011 109(
EE.UU. &a'olio € 91%.00 43%011 109(6
EE.UU. alla$an € %,%33.00 410%011 109((
RU &ods)or!$ € 1,303.19 4%3%011 109(8
EE.UU. alla$an € 4,813.0 331%011 109(9
EE.UU. Pea#o#/ € %48.00 41(%011 10980
EE.UU. &a'olio € 1,810.00 4%%011 10981
EE.UU. *uller € 1,014.00 48%011 1098%EE.UU. *uller € (%0.90 46%011 10983
EE.UU. &a'olio € 1,809.( 43%011 10984
EE.UU. *uller € %,0%3.38 4%%011 1098
EE.UU. alla$an € %,%%0.00 4%1%011 10986
EE.UU. alla$an € %,((%.00 46%011 1098(
EE.UU. e'erlin € 3,(4.80 410%011 10988
EE.UU. *uller € 1,33.60 4%%011 10989
EE.UU. *uller € 4,%88.8 4(%011 10990
EE.UU. &a'olio € %,%96.00 4(%011 10991
EE.UU. &a'olio € 69.60 43%011 1099%
RU +in € 4,89.44 410%011 10993EE.UU. *uller € 940.0 49%011 10994
EE.UU. &a'olio € 1,196.00 46%011 1099
EE.UU. Pea#o#/ € 60.00 410%011 10996
EE.UU. alla$an € 1,88.00 413%011 1099(
EE.UU. alla$an € 686.00 41(%011 10998
RU Suama € 1,19(.9 410%011 10999
EE.UU. *uller € 903.( 414%011 11000
EE.UU. *uller € %,(69.00 414%011 11001
EE.UU. Pea#o#/ € 1,811.10 416%011 1100%
EE.UU. e'erlin € 3%6.00 48%011 11003
EE.UU. e'erlin € %9.38 4%0%011 11004EE.UU. *uller € 86.00 410%011 1100
EE.UU. e'erlin € 3%9.69 41%011 11006
EE.UU. alla$an € %,633.90 413%011 1100(
EE.UU. *uller € 616.0 410%011 11009
EE.UU. *uller € 64.00 4%1%011 11010
EE.UU. e'erlin € 933.0 413%011 11011
EE.UU. &a'olio € %,8%.30 41(%011 1101%
EE.UU. *uller € 361.00 410%011 11013
8/18/2019 Ejercicio 3 - Tabla Dinámica
28/62
EE.UU. *uller € %43.18 41%011 11014
EE.UU. *uller € 6%%.3 4%0%011 1101
RU &ods)or!$ € 491.0 413%011 11016
RU &ods)or!$ € 6,(0.00 4%0%011 1101(
EE.UU. Pea#o#/ € 1,(.00 416%011 11018
EE.UU. *uller € 63%.40 416%011 110%0
EE.UU. e'erlin € 6,306.%4 4%1%011 110%1
EE.UU. &a'olio € 1,00.00 4%4%011 110%3
EE.UU. Pea#o#/ € 1,966.81 4%0%011 110%4
RU Suama € %(0.00 4%4%011 110%
EE.UU. Pea#o#/ € 1,030.00 4%8%011 110%6
EE.UU. &a'olio € 8((.(% 4%0%011 110%(
EE.UU. *uller € %,160.00 4%%%011 110%8
EE.UU. Pea#o#/ € 1,%86.80 4%(%011 110%9
RU +in € 1%,61.0 4%(%011 11030
RU Suama € %,393.0 4%4%011 11031
EE.UU. *uller € 8,90%.0 4%3%011 1103%
RU +in € 3,%3%.80 4%3%011 11033EE.UU. alla$an € 39.40 4%(%011 11034
EE.UU. *uller € 1,(4.0 4%4%011 1103
EE.UU. alla$an € 1,69%.00 4%%%011 11036
RU +in € 60.00 4%(%011 1103(
EE.UU. &a'olio € (3%.60 430%011 11038
EE.UU. e'erlin € 1,((3.00 4%8%011 11041
EE.UU. *uller € 40.( 1%011 1104%
RU "u#$anan € %10.00 4%9%011 11043
EE.UU. Pea#o#/ € 91.60 1%011 11044
EE.UU. alla$an € 1,48.80 4%4%011 11046
RU +in € 81(.8( 1%011 1104(RU +in € %.00 430%011 11048
EE.UU. e'erlin € 1,33%.00 1%011 110%
EE.UU. *uller € 3,0.00 4%9%011 1103
EE.UU. alla$an € 3,(40.00 1%011 1106
EE.UU. e'erlin € 4.00 1%011 110(
8/18/2019 Ejercicio 3 - Tabla Dinámica
29/62
ons!ruir a par!ir de los siuien!es da!os, las !a:las din;mi#as n?
Tala d!n$%!ca 1& an!idad de Ven!as por País @o!al de Ven!as.
Tala d!n$%!ca 2& 7ndi#ar el nAmero de 'en!as realiBadas por #ada'endedor el promedio !o!al.
Tala d!n$%!ca 3& 7ndi#ar las 'en!as maores menores por #ada país 'endedor.
Tala d!n$%!ca 4& 7ndi#ar !odas las 'en!as mensuales del %009 %010
8/18/2019 Ejercicio 3 - Tabla Dinámica
30/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
31/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
32/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
33/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
34/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
35/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
36/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
37/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
38/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
39/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
40/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
41/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
42/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
43/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
44/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
45/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
46/62
.
8/18/2019 Ejercicio 3 - Tabla Dinámica
47/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
48/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
49/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
50/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
51/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
52/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
53/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
54/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
55/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
56/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
57/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
58/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
59/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
60/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
61/62
8/18/2019 Ejercicio 3 - Tabla Dinámica
62/62