Sub-Totales - Rpta 0101.- Usando Sub Totales mostrar la Suma de Montos de Ventas por Vendedor y luego por Producto02.- Crear la lista nica de DistritosRpta 02.Nro. FacturaFechaVendedorDistritoProducto TipoUnidadesMonto de VentasDistrito20-11789/13/11AlvarezAnconCarnes6497,176.44Cercado20-119410/31/11AlvarezCallaoCarnes2386,883.95Surco20-12857/30/12AlvarezPueblo LibreCarnes69010,073.30MirafloresTotal Carnes24,133.6920-11627/27/11AlvarezSan IsidroEnlatados5017,523.24San Isidro20-118510/4/11AlvarezPueblo LibreEnlatados1959,165.14Ancon20-119310/28/11AlvarezMagdalenaEnlatados28212,647.76Callao20-12484/10/12AlvarezPueblo LibreEnlatados4188,809.58MagdalenaTotal Enlatados38,145.7220-11698/17/11AlvarezSurcoPescado6938,157.24San Borja20-119911/15/11AlvarezPueblo LibrePescado48911,057.77Pueblo Libre20-12191/14/12AlvarezPueblo LibrePescado1827,280.82San Juan20-12454/1/12AlvarezBarrancoPescado64010,592.35Brea20-12686/9/12AlvarezBreaPescado25312,371.60AteTotal Pescado49,459.7820-11254/7/11AlvarezSurcoSecos4516,996.14Barranco20-11547/3/11AlvarezCercadoSecos36611,570.16Jesus Maria20-12353/2/12AlvarezPueblo LibreSecos6518,638.3620-12787/9/12AlvarezBreaSecos6479,401.2520-131711/3/12AlvarezJesus MariaSecos2589,540.3020-131811/6/12AlvarezJesus MariaSecos45610,025.20Total Secos56,171.4120-11587/15/11AlvarezMirafloresVerduras40514,217.8020-11829/25/11AlvarezPueblo LibreVerduras51310,485.8320-12807/15/12AlvarezPueblo LibreVerduras4739,724.97Total Verduras34,428.60Total Alvarez202,339.2020-11496/18/11BuendaSan IsidroCarnes17213,374.5120-12201/17/12BuendaMagdalenaCarnes54511,268.1120-12241/29/12BuendaPueblo LibreCarnes20212,321.8320-12777/6/12BuendaBarrancoCarnes1627,757.7420-12827/21/12BuendaSan JuanCarnes5718,634.64Total Carnes53,356.8320-11294/19/11BuendaSurcoEnlatados44412,608.6320-11557/6/11BuendaSurcoEnlatados58111,802.7120-11839/28/11BuendaCallaoEnlatados3396,318.7420-119811/12/11BuendaSan BorjaEnlatados5699,903.3420-12615/19/12BuendaBarrancoEnlatados4369,219.8720-12716/18/12BuendaSan BorjaEnlatados69313,326.72Total Enlatados63,180.0120-13049/25/12BuendaAnconLacteos6877,850.3020-130710/4/12BuendaJesus MariaLacteos2148,540.63Total Lacteos16,390.9320-11304/22/11BuendaMirafloresPescado1966,670.5420-11577/12/11BuendaCercadoPescado59813,045.6520-119210/25/11BuendaSan BorjaPescado7146,885.4320-12605/16/12BuendaSan JuanPescado54012,067.3220-12635/25/12BuendaAtePescado40212,688.3320-12706/15/12BuendaBreaPescado35813,385.3520-12817/18/12BuendaBarrancoPescado7119,491.20Total Pescado74,233.8220-11234/1/11BuendaCercadoSecos31112,108.3120-11264/10/11BuendaSan IsidroSecos37011,639.6920-119010/19/11BuendaSan BorjaSecos3318,921.3720-12161/5/12BuendaPueblo LibreSecos27213,833.3720-12433/26/12BuendaBarrancoSecos29913,645.8820-12928/20/12BuendaSan JuanSecos23512,723.1920-131010/13/12BuendaJesus MariaSecos78914,755.25Total Secos87,627.0620-11708/20/11BuendaCercadoVerduras38511,357.7720-118710/10/11BuendaPueblo LibreVerduras3878,714.7320-119711/9/11BuendaBreaVerduras6547,958.3520-12908/14/12BuendaBreaVerduras39214,106.12Total Verduras42,136.97Total Buenda336,925.6220-11526/27/11FlorezSurcoCarnes16412,326.6820-11718/23/11FlorezCercadoCarnes30113,764.9020-12211/20/12FlorezPueblo LibreCarnes65413,084.2920-12746/27/12FlorezBreaCarnes67412,489.76Total Carnes51,665.6320-11335/1/11FlorezAnconEnlatados32011,116.4720-11597/18/11FlorezSurcoEnlatados37612,697.2420-11668/8/11FlorezSan IsidroEnlatados28712,225.8720-119611/6/11FlorezCallaoEnlatados4076,377.8620-12262/4/12FlorezMagdalenaEnlatados60313,777.5720-12413/20/12FlorezSan BorjaEnlatados38312,513.6920-12756/30/12FlorezBarrancoEnlatados32613,371.00Total Enlatados82,079.7020-131510/28/12FlorezSan IsidroLacteos3574,566.60Total Lacteos4,566.6020-11274/13/11FlorezAnconPescado6136,408.4820-11779/10/11FlorezSan IsidroPescado69210,101.1420-119511/3/11FlorezAnconPescado57613,040.9120-120612/6/11FlorezMagdalenaPescado5629,149.1820-12534/25/12FlorezPueblo LibrePescado54011,622.2420-12797/12/12FlorezAtePescado32912,357.1720-12868/2/12FlorezBreaPescado50114,268.03Total Pescado76,947.1520-11425/28/11FlorezSurcoSecos70610,551.1620-11446/3/11FlorezAnconSecos49313,697.5320-12332/25/12FlorezCallaoSecos69913,000.2520-12575/7/12FlorezAteSecos5687,715.1320-12847/27/12FlorezBreaSecos72210,393.8420-12969/1/12FlorezPueblo LibreSecos36513,410.7820-130910/10/12FlorezSan IsidroSecos95416,458.30Total Secos85,226.9920-11213/26/11FlorezSurcoVerduras2399,417.3520-11284/16/11FlorezSan IsidroVerduras51313,244.8220-121312/27/11FlorezCallaoVerduras34510,783.9420-12363/5/12FlorezBreaVerduras5367,006.2620-12383/11/12FlorezBreaVerduras5547,668.3020-12474/7/12FlorezAteVerduras6379,119.1420-12948/26/12FlorezBreaVerduras1806,816.87Total Verduras64,056.68Total Florez364,542.7520-11435/31/11MirandaSan IsidroCarnes53312,106.9220-11728/26/11MirandaSurcoCarnes18613,471.1020-12171/8/12MirandaCallaoCarnes61512,321.2220-12726/21/12MirandaPueblo LibreCarnes6439,905.09Total Carnes47,804.3320-11203/23/11MirandaCercadoEnlatados48212,077.0320-11637/30/11MirandaSurcoEnlatados55013,217.5120-121012/18/11MirandaMagdalenaEnlatados3996,971.9720-121412/30/11MirandaMagdalenaEnlatados6937,206.2920-12504/16/12MirandaSan JuanEnlatados69513,255.8620-12878/5/12MirandaAteEnlatados5539,738.9320-12979/4/12MirandaBarrancoEnlatados54613,867.6420-131210/19/12MirandaSan IsidroEnlatados3217,854.6920-131310/22/12MirandaAnconEnlatados258166,788.30Total Enlatados250,978.2220-130610/1/12MirandaSan IsidroLacteos3214,782.3020-131610/31/12MirandaJesus MariaLacteos9517,854.3020-131911/9/12MirandaCercadoLacteos45032,100.30Total Lacteos44,736.9020-11395/19/11MirandaMirafloresPescado30310,476.0720-11476/12/11MirandaMirafloresPescado5628,469.8120-12221/23/12MirandaMagdalenaPescado3659,299.2120-12292/13/12MirandaCallaoPescado36710,613.6320-12322/22/12MirandaPueblo LibrePescado4979,286.9120-12443/29/12MirandaSan JuanPescado20813,636.9020-12888/8/12MirandaPueblo LibrePescado6308,029.7820-12938/23/12MirandaBarrancoPescado51111,459.68Total Pescado81,271.9920-11405/22/11MirandaCercadoSecos40713,274.1020-11799/16/11MirandaSan IsidroSecos55711,836.2520-12373/8/12MirandaPueblo LibreSecos20810,861.3420-12585/10/12MirandaBreaSecos5817,320.3520-12837/24/12MirandaPueblo LibreSecos37213,310.6020-13009/13/12MirandaSan IsidroSecos95412,560.30Total Secos69,162.9420-11223/29/11MirandaMirafloresVerduras3517,085.5320-11355/7/11MirandaMagdalenaVerduras60411,893.3020-11607/21/11MirandaCallaoVerduras71713,376.1920-11819/22/11MirandaSan BorjaVerduras68411,146.0620-120912/15/11MirandaSan BorjaVerduras47510,109.4320-12464/4/12MirandaBreaVerduras5307,287.2220-12696/12/12MirandaJesus MariaVerduras5589,584.3820-13029/19/12MirandaCercadoVerduras8524,587.8720-13059/28/12MirandaCercadoVerduras4529,520.45Total Verduras84,590.43Total Miranda578,544.8120-11486/15/11SolsCercadoCarnes18212,177.6220-11516/24/11SolsCercadoCarnes22113,692.8920-120512/3/11SolsPueblo LibreCarnes4878,600.4420-12918/17/12SolsBarrancoCarnes46912,712.47Total Carnes47,183.4220-11385/16/11SolsSurcoEnlatados42212,754.2720-11536/30/11SolsCercadoEnlatados54312,831.4820-11688/14/11SolsCercadoEnlatados5118,990.9720-118810/13/11SolsPueblo LibreEnlatados19510,945.3820-12393/14/12SolsAteEnlatados2307,547.8620-12524/22/12SolsBreaEnlatados4638,463.0720-12645/28/12SolsPueblo LibreEnlatados60110,733.14Total Enlatados72,266.1720-11314/25/11SolsCercadoPescado6807,840.7620-11567/9/11SolsMirafloresPescado2007,182.7020-11678/11/11SolsAnconPescado50014,091.9320-118610/7/11SolsMagdalenaPescado70211,898.3720-121212/24/11SolsSan JuanPescado49810,445.3220-12494/13/12SolsBarrancoPescado4166,390.9520-12625/22/12SolsBreaPescado37914,272.7820-12676/6/12SolsPueblo LibrePescado54312,590.80Total Pescado84,713.6120-11365/10/11SolsCercadoSecos3008,944.6220-11738/29/11SolsMirafloresSecos45913,350.9020-119110/22/11SolsPueblo LibreSecos4588,501.1820-120712/9/11SolsSan BorjaSecos6119,872.7720-12898/11/12SolsAteSecos4657,361.9320-12958/29/12SolsAteSecos50412,916.0120-13019/16/12SolsJesus MariaSecos3573,698.30Total Secos64,645.7120-11506/21/11SolsAnconVerduras38911,101.1720-118410/1/11SolsSan JuanVerduras69911,540.0020-121112/21/11SolsCallaoVerduras3127,461.7120-12231/26/12SolsSan BorjaVerduras2489,937.6920-12514/19/12SolsJesus MariaVerduras5368,238.9420-12999/10/12SolsJesus MariaVerduras21911,597.0320-130810/7/12SolsCercadoVerduras25811,458.65Total Verduras71,335.19Total Sols340,144.1020-11648/2/11ZapataMirafloresCarnes2468,828.5220-120812/12/11ZapataPueblo LibreCarnes5719,782.0520-12302/16/12ZapataMagdalenaCarnes71312,623.4320-12403/17/12ZapataPueblo LibreCarnes58012,876.73Total Carnes44,110.7320-11244/4/11ZapataMirafloresEnlatados2436,546.1120-11345/4/11ZapataCercadoEnlatados31012,959.3620-11759/4/11ZapataMirafloresEnlatados27812,756.4120-11769/7/11ZapataSurcoEnlatados19510,463.1620-120311/27/11ZapataMagdalenaEnlatados62910,182.8420-120411/30/11ZapataPueblo LibreEnlatados21712,009.7220-12181/11/12ZapataAnconEnlatados5969,799.8820-12282/10/12ZapataAnconEnlatados68012,129.7320-12555/1/12ZapataAteEnlatados6509,879.2520-12565/4/12ZapataPueblo LibreEnlatados5816,653.91Total Enlatados103,380.3720-13039/22/12ZapataSan IsidroLacteos45812,360.3020-131410/25/12ZapataCercadoLacteos96325,487.30Total Lacteos37,847.6020-11375/13/11ZapataCercadoPescado5229,029.4820-11415/25/11ZapataMirafloresPescado3736,916.1420-11617/24/11ZapataAnconPescado4019,251.8220-11809/19/11ZapataSurcoPescado35711,879.2620-118910/16/11ZapataMagdalenaPescado63913,668.4520-120111/21/11ZapataSan JuanPescado5069,623.8320-12312/19/12ZapataSan BorjaPescado65212,808.3520-12342/28/12ZapataSan JuanPescado66313,990.7520-12423/23/12ZapataBreaPescado7068,455.2020-12544/28/12ZapataBreaPescado7218,926.9720-12767/3/12ZapataSan JuanPescado2958,404.53Total Pescado112,954.7820-11658/5/11ZapataCercadoSecos4647,972.9120-11749/1/11ZapataCercadoSecos3847,953.7320-120011/18/11ZapataCallaoSecos32111,051.7020-12272/7/12ZapataCallaoSecos21011,761.7320-12655/31/12ZapataBarrancoSecos30910,988.3820-12989/7/12ZapataSan JuanSecos6899,955.3720-131110/16/12ZapataCercadoSecos65412,400.30Total Secos72,084.1220-11324/28/11ZapataCallaoVerduras39113,427.2020-11456/6/11ZapataCallaoVerduras2067,861.2320-11466/9/11ZapataMagdalenaVerduras4098,975.6920-120211/24/11ZapataPueblo LibreVerduras60614,273.7320-12151/2/12ZapataSan BorjaVerduras31710,075.6320-12252/1/12ZapataSan BorjaVerduras3779,298.8920-12595/13/12ZapataBarrancoVerduras47711,324.0920-12666/3/12ZapataSan JuanVerduras54011,446.7920-12736/24/12ZapataAteVerduras34011,423.80Total Verduras98,107.05Total Zapata468,484.65Total general2,290,981.13

Sub-Totales - Rpta 0201.- Usando Sub Totales mostrar la Suma de Montos de Ventas por Vendedor y luego por Producto02.- Crear la lista nica de DistritosRpta 02.Nro. FacturaFechaVendedorDistritoProducto TipoUnidadesMonto de VentasDistrito20-11789/13/11AlvarezAnconCarnes6497,176.44Ancon20-119410/31/11AlvarezCallaoCarnes2386,883.95Ate20-12857/30/12AlvarezPueblo LibreCarnes69010,073.30Barranco20-11627/27/11AlvarezSan IsidroEnlatados5017,523.24Brea20-118510/4/11AlvarezPueblo LibreEnlatados1959,165.14Callao20-119310/28/11AlvarezMagdalenaEnlatados28212,647.76Cercado20-12484/10/12AlvarezPueblo LibreEnlatados4188,809.58Jesus Maria20-11698/17/11AlvarezSurcoPescado6938,157.24Magdalena20-119911/15/11AlvarezPueblo LibrePescado48911,057.77Miraflores20-12191/14/12AlvarezPueblo LibrePescado1827,280.82Pueblo Libre20-12454/1/12AlvarezBarrancoPescado64010,592.35San Borja20-12686/9/12AlvarezBreaPescado25312,371.60San Isidro20-11254/7/11AlvarezSurcoSecos4516,996.14San Juan20-11547/3/11AlvarezCercadoSecos36611,570.16Surco20-12353/2/12AlvarezPueblo LibreSecos6518,638.3620-12787/9/12AlvarezBreaSecos6479,401.2520-131711/3/12AlvarezJesus MariaSecos2589,540.3020-131811/6/12AlvarezJesus MariaSecos45610,025.2020-11587/15/11AlvarezMirafloresVerduras40514,217.8020-11829/25/11AlvarezPueblo LibreVerduras51310,485.8320-12807/15/12AlvarezPueblo LibreVerduras4739,724.9720-11496/18/11BuendaSan IsidroCarnes17213,374.5120-12201/17/12BuendaMagdalenaCarnes54511,268.1120-12241/29/12BuendaPueblo LibreCarnes20212,321.8320-12777/6/12BuendaBarrancoCarnes1627,757.7420-12827/21/12BuendaSan JuanCarnes5718,634.6420-11294/19/11BuendaSurcoEnlatados44412,608.6320-11557/6/11BuendaSurcoEnlatados58111,802.7120-11839/28/11BuendaCallaoEnlatados3396,318.7420-119811/12/11BuendaSan BorjaEnlatados5699,903.3420-12615/19/12BuendaBarrancoEnlatados4369,219.8720-12716/18/12BuendaSan BorjaEnlatados69313,326.7220-13049/25/12BuendaAnconLacteos6877,850.3020-130710/4/12BuendaJesus MariaLacteos2148,540.6320-11304/22/11BuendaMirafloresPescado1966,670.5420-11577/12/11BuendaCercadoPescado59813,045.6520-119210/25/11BuendaSan BorjaPescado7146,885.4320-12605/16/12BuendaSan JuanPescado54012,067.3220-12635/25/12BuendaAtePescado40212,688.3320-12706/15/12BuendaBreaPescado35813,385.3520-12817/18/12BuendaBarrancoPescado7119,491.2020-11234/1/11BuendaCercadoSecos31112,108.3120-11264/10/11BuendaSan IsidroSecos37011,639.6920-119010/19/11BuendaSan BorjaSecos3318,921.3720-12161/5/12BuendaPueblo LibreSecos27213,833.3720-12433/26/12BuendaBarrancoSecos29913,645.8820-12928/20/12BuendaSan JuanSecos23512,723.1920-131010/13/12BuendaJesus MariaSecos78914,755.2520-11708/20/11BuendaCercadoVerduras38511,357.7720-118710/10/11BuendaPueblo LibreVerduras3878,714.7320-119711/9/11BuendaBreaVerduras6547,958.3520-12908/14/12BuendaBreaVerduras39214,106.1220-11526/27/11FlorezSurcoCarnes16412,326.6820-11718/23/11FlorezCercadoCarnes30113,764.9020-12211/20/12FlorezPueblo LibreCarnes65413,084.2920-12746/27/12FlorezBreaCarnes67412,489.7620-11335/1/11FlorezAnconEnlatados32011,116.4720-11597/18/11FlorezSurcoEnlatados37612,697.2420-11668/8/11FlorezSan IsidroEnlatados28712,225.8720-119611/6/11FlorezCallaoEnlatados4076,377.8620-12262/4/12FlorezMagdalenaEnlatados60313,777.5720-12413/20/12FlorezSan BorjaEnlatados38312,513.6920-12756/30/12FlorezBarrancoEnlatados32613,371.0020-131510/28/12FlorezSan IsidroLacteos3574,566.6020-11274/13/11FlorezAnconPescado6136,408.4820-11779/10/11FlorezSan IsidroPescado69210,101.1420-119511/3/11FlorezAnconPescado57613,040.9120-120612/6/11FlorezMagdalenaPescado5629,149.1820-12534/25/12FlorezPueblo LibrePescado54011,622.2420-12797/12/12FlorezAtePescado32912,357.1720-12868/2/12FlorezBreaPescado50114,268.0320-11425/28/11FlorezSurcoSecos70610,551.1620-11446/3/11FlorezAnconSecos49313,697.5320-12332/25/12FlorezCallaoSecos69913,000.2520-12575/7/12FlorezAteSecos5687,715.1320-12847/27/12FlorezBreaSecos72210,393.8420-12969/1/12FlorezPueblo LibreSecos36513,410.7820-130910/10/12FlorezSan IsidroSecos95416,458.3020-11213/26/11FlorezSurcoVerduras2399,417.3520-11284/16/11FlorezSan IsidroVerduras51313,244.8220-121312/27/11FlorezCallaoVerduras34510,783.9420-12363/5/12FlorezBreaVerduras5367,006.2620-12383/11/12FlorezBreaVerduras5547,668.3020-12474/7/12FlorezAteVerduras6379,119.1420-12948/26/12FlorezBreaVerduras1806,816.8720-11435/31/11MirandaSan IsidroCarnes53312,106.9220-11728/26/11MirandaSurcoCarnes18613,471.1020-12171/8/12MirandaCallaoCarnes61512,321.2220-12726/21/12MirandaPueblo LibreCarnes6439,905.0920-11203/23/11MirandaCercadoEnlatados48212,077.0320-11637/30/11MirandaSurcoEnlatados55013,217.5120-121012/18/11MirandaMagdalenaEnlatados3996,971.9720-121412/30/11MirandaMagdalenaEnlatados6937,206.2920-12504/16/12MirandaSan JuanEnlatados69513,255.8620-12878/5/12MirandaAteEnlatados5539,738.9320-12979/4/12MirandaBarrancoEnlatados54613,867.6420-131210/19/12MirandaSan IsidroEnlatados3217,854.6920-131310/22/12MirandaAnconEnlatados258166,788.3020-130610/1/12MirandaSan IsidroLacteos3214,782.3020-131610/31/12MirandaJesus MariaLacteos9517,854.3020-131911/9/12MirandaCercadoLacteos45032,100.3020-11395/19/11MirandaMirafloresPescado30310,476.0720-11476/12/11MirandaMirafloresPescado5628,469.8120-12221/23/12MirandaMagdalenaPescado3659,299.2120-12292/13/12MirandaCallaoPescado36710,613.6320-12322/22/12MirandaPueblo LibrePescado4979,286.9120-12443/29/12MirandaSan JuanPescado20813,636.9020-12888/8/12MirandaPueblo LibrePescado6308,029.7820-12938/23/12MirandaBarrancoPescado51111,459.6820-11405/22/11MirandaCercadoSecos40713,274.1020-11799/16/11MirandaSan IsidroSecos55711,836.2520-12373/8/12MirandaPueblo LibreSecos20810,861.3420-12585/10/12MirandaBreaSecos5817,320.3520-12837/24/12MirandaPueblo LibreSecos37213,310.6020-13009/13/12MirandaSan IsidroSecos95412,560.3020-11223/29/11MirandaMirafloresVerduras3517,085.5320-11355/7/11MirandaMagdalenaVerduras60411,893.3020-11607/21/11MirandaCallaoVerduras71713,376.1920-11819/22/11MirandaSan BorjaVerduras68411,146.0620-120912/15/11MirandaSan BorjaVerduras47510,109.4320-12464/4/12MirandaBreaVerduras5307,287.2220-12696/12/12MirandaJesus MariaVerduras5589,584.3820-13029/19/12MirandaCercadoVerduras8524,587.8720-13059/28/12MirandaCercadoVerduras4529,520.4520-11486/15/11SolsCercadoCarnes18212,177.6220-11516/24/11SolsCercadoCarnes22113,692.8920-120512/3/11SolsPueblo LibreCarnes4878,600.4420-12918/17/12SolsBarrancoCarnes46912,712.4720-11385/16/11SolsSurcoEnlatados42212,754.2720-11536/30/11SolsCercadoEnlatados54312,831.4820-11688/14/11SolsCercadoEnlatados5118,990.9720-118810/13/11SolsPueblo LibreEnlatados19510,945.3820-12393/14/12SolsAteEnlatados2307,547.8620-12524/22/12SolsBreaEnlatados4638,463.0720-12645/28/12SolsPueblo LibreEnlatados60110,733.1420-11314/25/11SolsCercadoPescado6807,840.7620-11567/9/11SolsMirafloresPescado2007,182.7020-11678/11/11SolsAnconPescado50014,091.9320-118610/7/11SolsMagdalenaPescado70211,898.3720-121212/24/11SolsSan JuanPescado49810,445.3220-12494/13/12SolsBarrancoPescado4166,390.9520-12625/22/12SolsBreaPescado37914,272.7820-12676/6/12SolsPueblo LibrePescado54312,590.8020-11365/10/11SolsCercadoSecos3008,944.6220-11738/29/11SolsMirafloresSecos45913,350.9020-119110/22/11SolsPueblo LibreSecos4588,501.1820-120712/9/11SolsSan BorjaSecos6119,872.7720-12898/11/12SolsAteSecos4657,361.9320-12958/29/12SolsAteSecos50412,916.0120-13019/16/12SolsJesus MariaSecos3573,698.3020-11506/21/11SolsAnconVerduras38911,101.1720-118410/1/11SolsSan JuanVerduras69911,540.0020-121112/21/11SolsCallaoVerduras3127,461.7120-12231/26/12SolsSan BorjaVerduras2489,937.6920-12514/19/12SolsJesus MariaVerduras5368,238.9420-12999/10/12SolsJesus MariaVerduras21911,597.0320-130810/7/12SolsCercadoVerduras25811,458.6520-11648/2/11ZapataMirafloresCarnes2468,828.5220-120812/12/11ZapataPueblo LibreCarnes5719,782.0520-12302/16/12ZapataMagdalenaCarnes71312,623.4320-12403/17/12ZapataPueblo LibreCarnes58012,876.7320-11244/4/11ZapataMirafloresEnlatados2436,546.1120-11345/4/11ZapataCercadoEnlatados31012,959.3620-11759/4/11ZapataMirafloresEnlatados27812,756.4120-11769/7/11ZapataSurcoEnlatados19510,463.1620-120311/27/11ZapataMagdalenaEnlatados62910,182.8420-120411/30/11ZapataPueblo LibreEnlatados21712,009.7220-12181/11/12ZapataAnconEnlatados5969,799.8820-12282/10/12ZapataAnconEnlatados68012,129.7320-12555/1/12ZapataAteEnlatados6509,879.2520-12565/4/12ZapataPueblo LibreEnlatados5816,653.9120-13039/22/12ZapataSan IsidroLacteos45812,360.3020-131410/25/12ZapataCercadoLacteos96325,487.3020-11375/13/11ZapataCercadoPescado5229,029.4820-11415/25/11ZapataMirafloresPescado3736,916.1420-11617/24/11ZapataAnconPescado4019,251.8220-11809/19/11ZapataSurcoPescado35711,879.2620-118910/16/11ZapataMagdalenaPescado63913,668.4520-120111/21/11ZapataSan JuanPescado5069,623.8320-12312/19/12ZapataSan BorjaPescado65212,808.3520-12342/28/12ZapataSan JuanPescado66313,990.7520-12423/23/12ZapataBreaPescado7068,455.2020-12544/28/12ZapataBreaPescado7218,926.9720-12767/3/12ZapataSan JuanPescado2958,404.5320-11658/5/11ZapataCercadoSecos4647,972.9120-11749/1/11ZapataCercadoSecos3847,953.7320-120011/18/11ZapataCallaoSecos32111,051.7020-12272/7/12ZapataCallaoSecos21011,761.7320-12655/31/12ZapataBarrancoSecos30910,988.3820-12989/7/12ZapataSan JuanSecos6899,955.3720-131110/16/12ZapataCercadoSecos65412,400.3020-11324/28/11ZapataCallaoVerduras39113,427.2020-11456/6/11ZapataCallaoVerduras2067,861.2320-11466/9/11ZapataMagdalenaVerduras4098,975.6920-120211/24/11ZapataPueblo LibreVerduras60614,273.7320-12151/2/12ZapataSan BorjaVerduras31710,075.6320-12252/1/12ZapataSan BorjaVerduras3779,298.8920-12595/13/12ZapataBarrancoVerduras47711,324.0920-12666/3/12ZapataSan JuanVerduras54011,446.7920-12736/24/12ZapataAteVerduras34011,423.80

Formato Condicional con FormulaPintar de rojo el cdigo de los empleados que ingresaron en el primer trimestre de algn ao y ganan ms de 5000 soles

Fecha IngresoCdigo EmpleadoIngresos03/01/200441346,970.0002/10/200134047,800.0014/11/200825419,870.0024/07/200693162,370.0031/07/200157499,550.0012/04/200239914,640.0005/07/200815632,340.0004/05/200421253,500.0018/09/200895007,450.0009/06/200240567,350.0025/11/200784388,870.0017/04/200522388,750.0008/10/200438579,180.0021/02/200235841,700.0021/09/200137189,530.0006/12/200997395,940.0021/05/200686178,300.0001/03/200679909,730.0011/06/200144861,450.0019/12/200737528,250.0006/06/200466207,010.0027/08/200255827,120.0008/04/200911872,640.0014/04/200583794,090.0005/06/200928275,480.0006/12/200355748,860.0024/04/200186088,520.0007/09/200938899,180.0019/12/200459396,230.0006/02/200211526,240.0003/06/200831597,730.0029/12/200762707,410.0012/02/200989251,660.0003/08/200689265,280.0021/10/200641191,780.0004/09/20022818100.0001/08/200721583,820.0029/08/200295416,890.0024/08/20041268200.0001/08/200572369,850.0029/01/20062816730.0003/09/200442693,860.0004/06/200264345,630.0023/12/200574151,810.0027/04/200429312,360.0008/03/200848459,430.0024/11/20018658550.0030/09/200861118,760.0009/07/200575814,130.0014/05/20097543720.0025/04/20012888940.0020/12/200954443,670.0014/03/200982904,550.0012/04/200272716,350.0001/01/200941722,490.0019/09/200742348,720.0001/05/200283708,590.0024/01/201058182,910.0017/06/200637798,230.0011/02/200456962,060.0017/05/200824424,420.0024/06/200553741,700.0010/11/200972176,250.0021/06/20068159170.0018/03/200613814,800.0025/12/200915385,350.0027/10/200857385,770.0024/06/200864671,730.0016/07/200331274,510.0014/06/200476773,220.0018/04/200681865,530.0017/02/200133732,320.0014/07/200321443,760.0028/05/200661446,430.0007/01/200835691,160.0027/08/200271074,180.0019/02/200789844,060.0023/08/200888501,870.0030/01/20066579310.0008/09/200676465,840.0030/03/200497933,780.0024/12/200380419,040.0018/03/200134947,450.0010/08/200120418,560.0005/09/200526566,190.0015/09/200494243,320.0018/05/200577457,440.0012/02/200249474,790.0016/11/200327303,710.0019/02/200942817,470.0023/12/200274046,270.0008/01/200451894,210.0015/09/200862872,570.0012/04/200385255,530.0026/10/20087273920.0003/07/200481652,370.0023/07/200117075,960.0029/01/200691673,980.0022/12/200949477,120.0025/05/20097516540.0015/11/200857962,630.0021/10/2006390010.0013/08/200458398,560.0025/12/200887709,450.0005/07/200788955,660.0025/11/200681526,920.0029/05/20036199960.0015/08/200981306,240.0008/05/20014747770.0010/12/200310906,720.0022/12/20031652850.0019/11/200228395,660.0012/04/200870441,710.0001/07/200719165,600.0017/05/200595357,030.0025/12/200837374,220.0019/04/200227078,810.0004/02/200529844,320.0015/08/200272185,650.0020/06/20023190500.0016/12/200281267,940.0005/11/200122853,730.0004/11/200393347,670.0019/11/200751807,980.0014/07/200642087,090.0024/05/200483391,280.0018/01/200844054,560.0009/09/200492247,860.0028/08/200936338,170.0018/08/200396147,110.0029/06/20077386120.0023/04/200677191,980.0007/02/200428486,450.0008/05/200293309,530.0028/02/200199184,010.0025/06/200493236,160.0029/01/200256928,140.0012/11/200884444,930.0012/01/200716836,210.0003/12/20058470570.0007/10/200383965,400.0011/02/200284531,100.0012/11/200698964,730.0029/05/200669036,140.0025/12/200579786,220.0027/06/200922621,700.0008/07/200777658,520.0024/09/200274572,970.0011/04/200921098,240.0003/04/200641047,320.0005/09/200159288,970.0002/05/20013276330.0011/09/200220624,630.0022/01/200538627,910.0002/04/200763401,050.0021/02/200218494,850.0008/04/200192219,960.0029/12/2006579090.0023/04/200368816,570.0009/01/200516488,440.0011/04/200717813,390.0013/11/200640708,880.0013/10/200219483,530.0013/03/200354607,350.0028/06/200457681,950.0022/10/20038201890.0027/05/200996456,230.0016/01/200240932,620.0024/02/200850399,840.0028/01/200154175,510.0031/08/200468266,220.0010/11/200893271,430.0030/05/200741904,170.0013/06/200692995,860.0019/12/200549008,010.0010/01/200793879,650.0020/10/200922306,400.0015/01/200335024,900.0017/05/200168619,030.0008/11/200890737,310.0011/04/200673471,050.0007/01/200314313,260.0025/11/200240029,510.0028/06/200724023,730.0012/10/200599997,000.0008/07/200624833,970.0031/03/200438332,750.0007/12/20033644760.0003/09/200565196,030.0020/06/200165416,350.0007/12/200312991,490.0020/10/200731096,000.0005/10/200120774,900.0020/04/200182191,510.0021/07/200245438,360.0014/08/200534598,260.0025/09/20037253570.0006/11/200874024,370.0012/07/200181412,610.0014/02/200620341,870.0012/01/200853947,120.0021/03/200555746,950.0009/01/200432876,600.0031/12/200338619,180.0017/01/200241709,420.0024/04/200861869,950.0010/07/200458293,910.0003/08/20045842490.0013/09/200969264,250.0012/08/200763181,350.0008/08/200887802,330.0016/01/200956906,660.0009/02/200155412,500.0009/09/200923822,450.0004/08/200436027,200.0023/06/200897585,520.0025/01/200123577,830.0022/07/200478446,080.0006/08/200610997,180.0017/08/200512213,920.0015/06/200144715,770.0022/11/200982015,780.0018/03/200382465,900.0002/08/200271636,150.0017/07/200431705,470.0024/03/200820949,430.0006/06/200779832,120.0012/07/200135273,010.0024/12/200182117,640.0008/01/201093318,510.0015/11/200992759,120.0012/08/200596408,190.0028/12/200252435,500.0027/04/200196395,000.0027/08/200878689,730.0018/12/200747776,990.0022/06/200996502,580.0011/02/200842058,360.0008/03/2008870080.0016/07/200321672,690.0007/04/200938715,800.0018/10/200197473,750.0027/05/200382465,440.0022/05/200667137,430.0025/02/200825798,030.0006/12/200798133,210.0023/09/200240129,370.0002/06/200294939,560.0018/09/200572922,420.0028/12/200847248,620.0012/11/200276749,300.0005/08/200481331,310.0003/05/200875138,660.0005/06/200870484,460.0013/01/200343147,460.0007/11/200568067,410.0003/04/200182339,540.0014/10/200863104,870.0007/09/200446356,310.0012/08/200133112,730.0030/01/200399465,690.0014/10/200615354,610.0019/06/200228575,310.0004/09/200853815,810.0016/03/200499092,670.0027/11/200922263,340.0024/07/200938535,360.0001/11/200849369,720.0014/06/200919901,890.0022/01/200569097,370.0014/04/200122383,310.0003/03/200623049,620.0016/11/200144081,190.0004/07/200392701,190.0014/07/200970357,010.0008/05/200947279,900.0007/09/200942394,160.0019/06/200529376,240.0004/05/200217779,640.0025/06/200732807,440.0018/12/200623485,990.0001/11/200716556,720.0008/01/200623263,640.0016/05/200483394,920.0012/05/200480023,570.0008/04/200982167,150.0003/01/200284889,870.0030/05/200339131,200.0010/10/200244325,260.0016/10/200493603,100.0004/02/200144725,230.0008/01/201096482,180.0009/12/200741131,850.0005/08/200770444,620.0022/08/200179382,430.0008/08/200324102,050.0016/01/200694906,580.0023/11/200511529,690.0016/10/200384003,750.0022/10/200832814,700.0016/03/200496357,170.0003/03/200710436,080.0027/07/200422495,840.0001/01/200720445,360.0022/03/200519162,770.0012/11/200336772,390.0019/01/200929795,280.0016/11/200252675,580.0028/03/200683689,290.0024/03/200842497,970.0015/02/200627228,430.0014/05/200624142,670.0006/08/200427827,820.0010/01/200129796,400.0019/03/20026195590.0017/11/200955946,430.0008/07/20091560770.0031/03/200332908,950.0005/12/200427178,650.0022/02/200740551,470.0023/03/200787084,870.0014/12/200769169,640.0022/02/200830631,280.0005/03/201055545,430.0007/09/200590923,360.0020/02/200682168,410.0018/09/200826698,190.0014/01/200567774,590.0017/02/201024557,770.0005/03/200186993,880.0023/11/200379367,650.0014/11/200423259,320.0011/10/20039245560.0021/08/200627727,240.0027/05/200484191,220.0020/05/200928672,080.0027/01/20109595310.0004/12/200677369,930.0003/07/200320402,560.0029/01/20095223340.0030/12/200676049,710.0030/11/200638196,720.0028/12/200436159,310.0022/05/200820899,070.0029/09/200995894,070.0024/09/200212632,420.0021/10/20036561830.0004/12/200837487,910.0014/01/200420283,600.0004/02/200710603,610.0017/10/200429027,430.0028/08/200254253,100.0010/09/200286593,500.0011/02/200767582,220.0031/01/201051085,040.0017/06/200416262,320.0013/10/200662619,420.0012/07/200981351,990.0011/06/200383411,070.0003/11/200580351,430.0026/12/200193906,330.0020/08/200319612,930.0007/10/200533156,800.0001/09/200474725,880.0023/06/200316868,150.0017/09/200846357,780.0009/01/20076421350.0018/05/200850416,860.0025/03/200750562,380.0030/03/200941876,490.0025/10/200351129,420.0001/05/200995586,290.0002/01/200425845,790.0007/07/20034912530.0027/08/200518282,650.0027/04/200273896,550.0015/05/200474528,790.0021/06/200235535,690.0016/06/200562675,640.0018/02/200515806,310.0007/06/200892079,650.0022/01/200316631,230.0006/09/200812448,790.0029/04/200676265,480.0004/07/200596298,470.0010/06/200370146,900.0001/07/200818703,760.0023/12/200815112,280.0030/06/200456511,360.0021/08/200530043,440.0030/01/200358626,310.0016/08/200634875,060.0017/06/200117259,690.0012/08/200978591,780.0023/07/200366297,000.0018/07/200123426,530.0021/12/200277975,550.0008/02/200424066,170.0029/03/200620547,230.0022/05/200435889,860.0010/12/200691987,360.0020/05/200769753,930.0003/07/200658748,270.0013/03/200262087,130.0016/06/200551594,150.0023/02/200683211,760.0007/07/200766555,040.0011/10/200545377,580.0026/07/200333236,920.0023/05/200178661,540.0030/05/200896991,500.0021/04/200259935,350.0029/01/201024348,950.0008/01/200942282,800.0010/04/200499962,570.0008/04/200536129,230.0002/12/200944729,450.0017/06/200648025,970.0030/12/200634074,100.0003/09/200345952,840.0003/03/200525065,430.0006/08/200766485,360.0006/05/200680812,760.0008/02/200629103,360.0011/10/200816372,810.0018/11/200644477,440.0019/04/200470838,070.0009/02/200461468,710.0020/08/200691213,570.0017/08/200980194,370.0018/09/200287069,910.0030/03/200813981,430.0001/08/200179523,450.0015/10/200199691,920.0029/02/200472531,390.0001/01/200262025,710.0018/02/201076985,110.0017/09/200837855,550.0019/01/20066348610.0006/06/200395584,250.0029/11/200322584,950.0009/10/200950922,890.0019/04/200830094,330.0007/01/200437782,240.0002/01/200951798,240.0026/08/200771968,970.0028/05/200791358,660.0018/03/200688501,890.0009/12/20094235250.0014/02/200538856,230.0028/08/200755028,580.0010/11/200136717,200.0022/12/200470222,870.0008/04/200593327,190.0027/08/200766424,520.0006/01/200150146,470.0021/09/200726248,940.0012/07/200660596,530.0029/10/200561666,720.0023/05/20036724260.0026/10/200748021,710.0021/06/200575692,120.0018/10/200160734,180.0010/09/200197526,350.0004/04/200526941,830.0008/11/200445739,760.0016/05/200936606,780.0005/12/200720188,340.0027/02/200235482,680.0011/12/20087501330.0007/03/200244081,850.0019/03/200399051,020.0004/08/200783193,680.0027/02/200470699,640.0014/08/200558953,860.0004/07/200788144,190.0026/09/200946585,200.0016/12/200691098,070.0006/03/200390897,140.0004/10/200422074,540.0025/06/200747037,980.0023/09/200416802,750.0001/10/200371506,700.0031/10/20072302560.0006/05/200668883,530.0030/05/200177928,950.0002/05/200283374,970.0027/09/200513088,080.0002/07/20049996820.0020/11/200116509,530.0003/05/200836542,130.0005/09/200133551,910.0010/11/200915631,010.0020/06/200832957,150.0006/12/200897991,250.0025/09/200767186,000.0001/09/200821876,250.0027/06/200710621,350.0012/08/200651447,740.0021/12/200794389,630.0021/10/200872636,140.0014/09/200891066,940.0024/01/200259442,040.0001/01/200445734,110.0017/01/200822622,970.0010/02/200960857,840.0021/07/200494807,600.0013/01/200842949,470.0029/05/200146098,100.0013/05/20032302310.0012/02/200566042,430.0006/03/200460089,810.0001/11/200168565,100.0004/01/200735694,320.0024/01/200653192,260.0019/05/20042753500.0009/01/20024606900.0029/06/200267992,130.0004/10/200991564,240.0005/06/200316189,880.0001/02/200212545,920.0024/09/200159896,200.0002/02/200692789,160.0027/05/200743065,900.0019/06/200671958,300.0016/02/200264893,670.0010/01/201055317,560.0015/09/200380306,330.0029/01/200697157,360.0030/04/200376446,090.0007/12/200419572,940.0003/05/200842106,810.0021/04/200572249,730.0015/03/20089527120.0030/01/200585262,020.0017/05/200654621,420.0028/04/20093599680.0027/07/200429293,930.0009/12/200556539,550.0001/04/200488618,300.0023/07/20072623420.0011/07/200896401,870.0020/11/200564237,720.0019/10/200555234,620.0008/09/200472567,220.0025/02/200987701,670.0025/11/200912601,200.0030/09/200537072,540.0023/07/200335651,900.0020/07/200326697,980.0017/01/200275283,700.0011/04/200911919,100.0008/01/200452264,610.0012/06/200798515,750.0006/07/200917513,590.0003/08/200721793,470.0011/03/200280058,030.0021/06/200695287,870.0021/06/200822279,930.0012/07/200485457,160.0008/07/200291938,740.0001/12/200925306,660.0009/05/200310877,090.0022/10/200434241,230.0018/06/20097449380.0003/04/200950455,790.0022/02/200825189,780.0012/09/200116722,000.0020/02/200657034,720.0001/02/200459231,450.0026/12/200828534,570.0003/11/200648027,220.0024/08/200786292,970.0024/05/200327713,260.0001/12/200519331,580.0014/03/200773947,800.0028/08/200721697,460.0023/06/200998808,320.0005/06/200987906,540.0013/05/200541194,070.0018/01/201086654,430.0004/03/200881156,820.0006/03/200465945,660.0027/01/200883254,160.0014/08/200252255,010.0018/10/20075314240.0020/09/200468412,470.0003/01/200716213,140.0003/07/200680836,390.0029/09/200739637,100.0007/08/200993716,320.0021/01/200519003,190.0010/03/200365663,840.0030/05/200220202,720.0028/07/200650598,060.0013/08/20095682680.0020/09/20019243870.0027/02/200959218,900.0002/02/200968201,720.0022/06/200698633,460.0003/01/200649738,190.0012/05/200722139,800.0003/08/200480516,500.0030/04/200845587,470.0001/04/20032407610.0014/07/200572464,570.0029/12/200724693,320.0020/03/200981515,800.0031/12/20045461880.0030/07/200869906,210.0011/01/200243304,000.0011/03/200873065,840.0023/01/201059775,640.0030/01/200630574,040.0030/06/200445049,440.0017/11/200592689,950.0021/07/200844483,690.0017/05/200572893,590.0005/10/20013659420.0016/06/200968976,460.0004/11/200787819,030.0026/12/200935228,050.0024/05/200912261,580.0021/09/200493775,790.0030/07/200292565,310.0010/11/200666341,310.0024/06/200314544,030.0002/11/200262496,330.0014/07/200137562,230.0020/03/200782551,040.0002/02/200398035,150.0027/11/200475845,130.0005/07/200521453,170.0007/05/20041442510.0025/02/200113559,380.0022/11/200472261,290.0031/01/200294142,990.0018/10/20089490310.0028/08/200813883,260.0003/02/200862285,340.0008/07/200513054,860.0027/08/200824569,440.0009/08/200756909,270.0023/04/200657014,620.0010/09/200775592,120.0022/02/200570402,950.0020/01/200323442,710.0028/08/200784371,080.0015/12/200855634,450.0006/06/200777521,560.0030/07/200884099,550.0002/10/200114628,030.0027/01/200870079,310.0016/05/200861272,140.0029/01/200837843,330.0003/07/200635272,720.0010/05/200471947,870.0005/01/200940469,720.0027/07/200647549,220.0030/10/200243214,050.0008/12/200128413,960.0003/05/20061875460.0013/11/20051936400.0025/10/200695107,320.0006/06/200885062,080.0015/09/200456187,340.0010/05/200329579,410.0005/12/200919788,870.0007/12/200826069,640.0011/10/200695271,990.0012/12/200345303,790.0026/03/20059151610.0010/01/200825718,850.0017/08/200677476,740.0018/10/200342482,360.0003/10/200587384,020.0011/10/200578129,760.0003/07/200725355,140.0012/02/200245347,980.0022/11/200878212,840.0011/03/20088512350.0019/07/200195982,440.0002/03/200749004,940.0006/04/200887126,430.0004/10/200921609,360.0017/02/201069999,820.0004/06/200360453,900.0006/02/200843308,430.0002/07/200361247,110.0023/12/200857593,900.0004/03/201051315,990.0001/12/200183445,290.0022/03/200925844,920.0028/03/200986365,180.0013/01/200282899,450.0006/01/20048856760.0001/02/200929142,720.0016/10/200256954,810.0023/12/200682683,140.0008/07/200554315,300.0016/03/200870618,670.0031/10/200475989,130.0022/10/200895389,810.0021/05/20071233820.0007/09/200156319,870.0017/05/20081386860.0004/10/20012559780.0026/06/200384598,200.0009/08/200386931,520.0022/01/200398907,540.0009/10/200483494,270.0023/05/200957908,880.0014/06/200461684,440.0008/05/200784128,910.0025/06/200333696,030.0030/07/200573704,710.0022/08/200792408,270.0027/07/200125831,180.0014/09/200734966,960.0007/01/200561198,740.0015/03/200412477,590.0003/03/201073323,910.0027/09/200639184,280.0015/10/200222129,280.0018/02/200371318,390.0009/01/200762467,100.0030/06/200472519,400.0029/01/200616575,090.0022/01/200857661,060.0025/04/200367616,270.0019/03/200833971,330.0019/02/200361499,670.0014/06/200524832,070.0014/12/200139388,620.0009/06/200894492,090.0030/05/200519165,670.0031/10/200126383,080.0025/03/200395624,300.0002/09/200131135,630.0016/06/200992752,500.0025/12/200195873,590.0019/12/200526692,660.0019/03/200869394,780.0022/03/201099949,080.0025/07/200725331,530.0006/01/201038989,130.0029/08/200762934,880.0026/04/200114064,690.0029/06/200883026,440.0018/09/200752728,970.0012/07/200979647,790.0011/12/200360288,820.0018/03/200769276,530.0026/05/200462812,210.0023/05/20055929510.0005/02/200227818,870.0017/08/20056829400.0026/06/200782947,470.0022/08/200545347,050.0011/08/200573825,560.0015/04/200151475,890.0008/02/200389537,590.0011/01/200236467,080.0024/11/200169583,470.0031/08/200370723,480.0025/01/200680159,160.0001/04/200928819,290.0018/04/200453379,800.0030/12/200360886,730.0022/01/200331962,180.0007/07/200747436,130.0026/04/200542662,330.0008/05/200478182,080.0012/03/200172162,380.0022/04/200232977,760.0031/01/201031649,770.0008/06/200936827,890.0001/06/200825098,320.0017/08/200995796,630.0028/07/200378214,880.0002/08/200750717,320.0011/07/200866986,280.0002/09/200993019,000.0030/07/200495609,300.0028/05/200679326,770.0022/02/200519962,280.0026/05/200950387,850.0024/08/200935646,310.0019/08/200736471,560.0002/02/200924581,810.0007/07/20035990830.0002/10/200492947,500.0003/01/20105529370.0017/03/200488838,600.0023/09/200315761,540.0021/09/200651591,130.0002/05/200663418,150.0007/04/200295744,290.0019/02/200169643,170.0006/06/200541878,740.0014/03/200895702,790.0031/08/200537182,990.0012/07/200433474,070.0016/11/20046157390.0021/08/200767107,080.0008/07/200647885,620.0024/02/200432529,710.0007/09/200970836,670.0003/12/200464721,780.0023/04/20056969580.0005/09/200597089,490.0019/02/200855571,770.0007/08/200859328,990.0026/11/200942628,480.0022/02/200667892,530.0016/12/20032981460.0016/09/200639604,940.0010/02/200337755,930.0018/03/20085250790.0003/12/20076180120.0022/07/200248294,460.0007/04/200457624,370.0002/08/200463462,770.0029/03/200550069,130.0002/01/20078194910.0002/06/20028172320.0018/12/200725689,360.0015/09/2007548020.0013/11/200467078,830.0001/11/200150148,020.0025/03/200136469,090.0003/02/20103986250.0025/08/200252244,780.0024/03/201059526,550.0025/06/200730624,310.0029/01/200215645,700.0026/11/20049512920.0009/02/201076417,780.0017/02/20036507560.0018/01/200736884,570.0010/03/200726872,670.0004/12/200224948,170.0023/02/200288847,850.0007/02/201027613,090.0007/03/20095023510.0025/08/200687862,710.0014/08/200676754,280.0019/01/200525863,550.0021/07/200999418,760.0017/11/200444535,070.0002/04/200860045,270.0008/07/200448369,420.0008/03/200373954,820.0006/02/201077949,210.0027/04/200587701,510.0027/08/200769095,440.0029/07/200682555,820.0011/04/200189708,500.0023/11/200985571,010.0026/10/200877182,960.0013/05/200126242,600.0004/03/200759454,030.0006/09/200442338,660.0021/10/200989343,350.0015/11/200554305,850.0027/01/200226045,390.0012/04/200727061,340.0030/01/200629902,430.0031/12/200456007,180.0031/05/200653978,550.0021/02/200979332,690.0029/07/200149628,930.0016/03/200997348,000.0019/07/200655009,140.0012/04/200899381,150.0020/08/200491858,290.0004/10/200882889,880.0027/01/200850185,900.0002/05/200264587,970.0026/08/200466809,150.0026/10/200458921,320.0021/06/200883548,170.0006/10/200533937,890.0008/12/200566622,320.0013/09/200839064,710.0002/07/200578498,210.0021/10/200670664,340.0010/01/2003288330.0027/06/200134704,810.0029/05/200816857,570.0002/03/200997253,760.0015/09/200267808,520.0028/11/20071839400.0018/09/200137709,270.0018/05/200516412,860.0007/11/20049481140.0015/02/200675551,430.0013/10/200872505,730.0029/01/20059654140.0001/04/200953769,380.0022/03/200130457,590.0006/03/20091868520.0017/04/200738744,500.0009/01/200496713,940.0001/02/200156551,190.0001/10/200917567,650.0014/08/200543955,320.0020/04/200250338,880.0029/10/200554827,660.0008/06/200197047,580.0008/04/200675912,470.0003/02/200163853,780.0013/02/200758678,010.0013/11/200927701,770.0008/04/200863567,220.0020/04/200547615,230.0029/10/200448722,480.0020/08/200295811,130.0017/09/200726967,060.0021/05/200621698,070.0024/09/200191311,310.0030/09/200446891,340.0029/08/200725224,630.0030/04/200496123,150.0008/12/20021015460.0002/02/200267587,270.0015/07/200166287,240.0011/06/200730123,800.0009/10/200361178,460.0026/01/200866514,990.0007/06/200760793,290.0018/08/20088246510.0026/03/200372196,910.0023/11/200293268,230.0012/08/200314144,570.0001/07/200353853,320.0014/04/200841862,670.0027/08/200820991,990.0008/11/200353317,440.0016/05/200361463,680.0019/01/200320507,310.0021/03/200628214,000.0018/04/200618152,300.0002/06/200517978,990.0031/08/200149684,930.0003/10/200683376,980.0024/11/20086925990.0010/04/200179753,740.0025/05/200956808,870.0024/09/200524125,400.0001/10/200154274,340.0006/08/200251219,590.0002/07/200433987,890.0025/05/200663821,900.0004/09/200111784,290.0020/11/200435186,690.0012/06/200182946,970.0017/04/200848164,530.0015/11/200658297,100.0010/05/200971848,650.0001/02/201094163,310.0005/12/200477437,630.0009/04/200867468,900.0012/10/200579411,190.0007/02/200821256,760.0013/01/200298554,530.0030/07/200648988,600.0012/08/200622532,880.0017/06/200875492,450.0005/04/200369069,480.0010/09/200445706,740.0021/08/200795997,960.0030/01/201050848,280.0022/03/200768332,220.0007/12/200528015,090.0017/05/200291136,260.0011/01/20053106880.0024/10/200216518,430.0025/04/200756244,880.0006/08/200186754,540.0029/11/200826338,650.0030/07/200478251,080.0030/10/200676513,370.0027/01/20071153990.0010/06/20077667630.0014/10/20034134930.0026/01/200170947,830.0020/03/200940915,210.0018/04/20062236900.0014/11/200417604,550.0016/04/200483683,080.0012/08/200637166,070.0007/07/200949234,630.0004/04/200465131,560.0015/03/201079728,070.0010/04/200959353,730.0019/01/200182309,490.0030/03/200622982,720.0003/04/200584651,660.0025/05/200394007,200.0011/12/200234347,920.0013/01/201031059,690.0015/12/200277297,840.0018/10/200611482,130.0018/10/20089806280.0028/09/200694168,830.0025/08/200667188,750.0031/07/200859082,570.0028/07/200865873,870.0018/01/200925145,540.0007/01/2002640470.0001/09/200812441,210.0030/06/200690963,870.0017/05/200275608,180.0029/01/200984714,500.0002/04/200189938,980.0013/03/200732562,300.0022/02/200173318,630.0014/07/200238987,000.0026/08/200929841,410.0001/08/200973176,860.0031/08/200838207,980.0021/11/200116013,690.0030/01/200449395,230.0006/08/20081567870.0016/04/200334494,780.0007/08/200479415,200.0004/04/200311592,500.0010/08/200529453,430.0008/03/200374098,430.0022/10/200572494,090.0026/01/200239667,640.0021/12/200312026,380.0024/07/200116363,990.0011/12/200379544,270.0030/01/200396553,700.0010/05/200221406,750.0009/07/200624921,880.0007/12/200495188,300.0028/01/200484987,370.0024/12/20012489330.0026/04/200625352,880.0006/06/200911182,410.0012/06/200967629,780.0021/08/200730442,370.0031/01/200524201,440.0014/03/200383829,590.0012/01/200678826,790.0004/12/200643003,890.0023/08/200593595,000.0004/07/200982627,270.0003/11/200411767,090.0021/03/200867506,330.0018/04/200938181,920.0005/08/200836629,650.0011/05/20065685450.0028/02/200739225,660.0022/06/200142866,490.0017/01/200180879,640.0002/01/200248562,930.0006/12/200214418,980.0026/08/200947536,630.0018/01/200480329,270.0028/07/200619054,090.0016/06/20026585900.0012/02/200925416,410.0002/01/201028914,630.0012/03/200463215,220.0020/01/200825828,310.0016/05/200740012,890.0002/02/20077063860.0031/03/200925071,780.0020/09/200864905,270.0010/11/200537733,690.0007/11/200579261,620.0014/12/20036497380.0017/11/200642781,280.0008/12/200336524,440.0027/07/2007453870.0006/02/200763151,390.0027/06/200870748,110.0015/12/200490732,830.0003/07/200192011,570.0010/05/200913611,100.0009/06/200677242,660.0025/09/200171203,880.0008/10/200958773,430.0020/03/201083732,460.0020/06/200924823,570.0026/07/200780171,840.0012/09/200338866,050.0005/01/20038210650.0030/07/20045546310.0014/01/200456379,420.0013/08/200135709,040.0024/03/200294218,760.0019/11/200835831,720.0018/08/200460167,120.0021/05/200275396,400.0011/07/200626183,200.0015/05/200990468,580.0017/08/200881212,990.0028/05/200277159,330.0030/12/200947548,580.0003/05/200264412,990.0018/10/200864243,860.0024/12/200155583,650.0002/04/200184511,010.0018/04/200327126,820.0028/02/200639423,170.0014/03/201033403,860.0011/04/20026641880.0001/12/200632462,530.0009/10/200656007,170.0006/10/200734669,470.0011/12/200720486,600.0025/05/200423404,640.0023/12/200961591,610.0009/02/200439864,870.0013/08/200211517,020.0004/12/200718572,650.0012/04/200633424,450.0016/01/20011696330.0024/08/200275902,630.0015/06/200666979,040.0011/02/200770573,660.0022/06/200311445,260.0026/06/200369874,150.0008/04/200389297,510.0005/12/200254186,330.0006/05/200924241,540.0026/01/201036857,450.0013/08/200510544,830.0028/02/20012932530.0012/05/200932989,330.0014/06/200945202,060.0019/02/200289633,020.0025/11/20029696280.0013/12/200714455,780.0021/10/200170178,850.0007/12/200726782,500.0028/08/200590633,880.0010/02/200582515,410.0002/03/200345132,380.0026/10/200349143,830.0021/08/200315171,720.0008/02/200157777,460.0004/08/200328862,670.0026/05/200427175,490.0005/07/200619655,100.0028/10/200122694,070.0003/06/20076534100.0013/09/200771736,450.0014/06/200948824,590.0031/12/200486603,860.0003/08/200936783,860.0008/05/200417146,610.0008/03/200489303,330.0030/11/200225939,160.0017/02/200827775,910.0006/04/200214394,630.0029/09/200870313,560.0014/01/20075431500.0028/02/200167836,250.0003/06/20025951320.0009/12/200744062,760.0010/05/200427915,870.0029/03/200294092,380.0022/04/200731028,850.0003/02/2009785550.0026/08/20071974140.0022/06/200970241,310.0021/04/200169163,620.0008/08/200560431,040.0022/08/20023507170.0027/12/200765467,890.0011/02/200573706,130.0024/10/200623428,850.0015/01/201056669,380.0007/03/200277162,400.0006/11/200982996,150.0019/06/200719042,910.0007/02/200462064,700.0016/04/20037274670.0013/02/200482259,200.0007/01/200189806,990.0028/10/200487405,330.0028/09/200653706,940.0005/12/200258201,770.0025/02/201033789,580.0001/09/200913056,470.0021/12/200911104,910.0012/03/200912943,620.0030/09/200233939,800.00

Buscar ObjetivoTenemos la siguiente Boleta de Pago, se pide calcular el Bsico para cada empleado sabiendo el Sueldo Neto que desean ganar, segn las condiciones dadas en la tablaCdigo EmpleadoC-1004Si gana al ao (15 sueldos brutos) CdigoEmpleadoCargoDNIAFPBon. FamiliarNetoBsicoNombreRosamenos de 27 UIT = 93,150C-1001LuisAsesor12345678HorizonteSi4,000.005,960.60CargoEjectiva MKTC-1002CarlosJefe Area98765432PrimaNo5,000.008,620.70DNI10004000C-1003DoraContadora13572468HorizonteNo3,000.004,545.50Se aplica el 15 del sueldo BrutoC-1004RosaEjectiva MKT10004000PrimaSi3,500.005,368.75IngresosSi es igual o ms se aplica el 21%BsicoBonificacin Familiar100.00Total Ingresos (Bruto)100.00Descuentos AFPHorizonte10%DescuentosPrima12%AFP12.00Essalud (9%)9.005ta15.00Sugerencia:Total Descuentos36.00Calcular el sueldo de una persona X que gane 1000 de Bsico, apliquen las frmulas correspondientes para hallar el sueldo NetoSueldo Neto64.00Luego con Buscar Objetivo, calculen los BsicosCdigoEmpleadoCargoDNIAFPBon. FamiliarNetoBsicoXXXNNAAA2222222HorizonteSi1000Ejemplo SugerenciaCdigo EmpleadoXXXNombreNNCargoAAADNI2222222IngresosBsico1,000.00Bonificacin Familiar100.00Total Ingresos (Bruto)1,100.00

DescuentosEs 15% porque multiplicando su Ingreso Bruto por 15 no supera los 93150AFP110.00Essalud (9%)99.005ta165.00Total Descuentos374.00

Sueldo Neto726.00