Planilla Para Comerciales.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Planilla Para Comerciales.xlsx as PDF for free.
More details
- Words: 594
- Pages: 6
Calculo de comisiones y seguimiento de ot a comerciales Año 2019 Mes Enero-Febrero Ventas mensuales Analisis por comercial Fecha Vendedor Ventas Comercial Vta Max Vta Min Vta Total 12/1/2019 Juan 4,386 Juan 12/2/2019 Juan 5,214 Carlo 12/3/2019 Juan 3,223 Sonia 12/4/2019 Juan 2,679 12/2/2019 Carlos 3,970 12/3/2019 Juan 3,350 Numero OT Comercial Ciudad 12/4/2019 Sonia 3,882 141456 Juan Guzman Cali 12/5/2019 Sonia 4,819 141457 Juan Guzman Cali 12/6/2019 Juan 2,453 141458 Juan Guzman Cali 12/3/2017 Sonia 2,966 141459 Juan Guzman Cali 12/3/2017 Juan 3,617 141460 Juan Guzman Cali 12/3/2017 Carlos 2,383 141461 Juan Guzman Cali 12/4/2017 Carlos 4,030 12/4/2017 Sonia 3,705 12/4/2017 Sonia 3,986 12/4/2017 Juan 3,937 12/4/2017 Sonia 3,572 12/5/2017 Carlos 2,461 12/5/2017 Sonia 4,036 12/5/2017 Carlos 4,635 12/5/2017 Juan 4,965 12/5/2017 Carlos 3,862 12/6/2017 Carlos 5,403 12/6/2017 Sonia 5,302 12/6/2017 Sonia 5,568 12/6/2017 Juan 5,552 12/6/2017 Sonia 5,310 12/7/2017 Juan 4,430 12/7/2017 Juan 3,791 12/7/2017 Carlos 4,373 12/7/2017 Carlos 3,633 12/7/2017 Sonia 3,857 12/7/2017 Carlos 1,831 12/8/2017 Carlos 4,228 12/8/2017 Juan 3,612 12/8/2017 Carlos 2,876 12/8/2017 Carlos 3,731 12/8/2017 Carlos 1,999 12/8/2017 Sonia 3,326 12/8/2017 Juan 1,822
12/9/2017 12/9/2017 12/9/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/12/2017 12/12/2017 12/12/2017 12/13/2017 12/13/2017 12/13/2017 12/13/2017 12/13/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/15/2017 12/15/2017 12/15/2017 12/15/2017 12/15/2017 12/16/2017 12/16/2017 12/17/2017 12/17/2017 12/17/2017
Juan Sonia Juan Sonia Sonia Sonia Carlos Sonia Juan Carlos Juan Sonia Sonia Juan Sonia Carlos Sonia Sonia Sonia Sonia Carlos Carlos Sonia Sonia Carlos Juan Juan Carlos Carlos Juan Sonia Sonia Sonia Juan Juan Carlos Sonia Juan Juan Sonia Carlos Sonia Carlos Sonia Carlos
3,842 2,860 5,317 4,618 3,705 5,542 2,385 2,806 4,017 1,860 4,637 2,738 2,632 2,357 3,984 2,292 3,407 4,953 5,167 2,770 3,378 2,949 4,338 4,105 2,411 3,389 2,725 4,285 2,874 2,621 4,255 4,720 3,085 4,600 4,917 4,106 4,147 2,957 4,439 4,606 3,810 5,579 1,949 4,138 5,415
12/17/2017 12/17/2017 12/17/2017 12/17/2017 12/18/2017 12/18/2017 12/18/2017 12/18/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/20/2017 12/20/2017 12/20/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/22/2017 12/23/2017 12/23/2017 12/23/2017 12/23/2017 12/23/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/26/2017
Carlos Carlos Sonia Juan Juan Sonia Carlos Carlos Juan Juan Sonia Carlos Juan Carlos Carlos Sonia Sonia Carlos Carlos Sonia Carlos Sonia Juan Juan Sonia Juan Carlos Juan Sonia Carlos Sonia Juan Sonia Sonia Carlos Carlos Sonia Carlos Juan Carlos Carlos Carlos Sonia Juan Sonia
4,236 5,010 4,115 4,840 4,571 3,307 2,638 4,111 5,491 5,179 5,058 5,259 4,310 5,367 3,203 2,898 4,953 5,363 5,138 4,017 5,408 3,152 4,618 4,836 3,207 4,729 2,964 4,133 2,524 2,308 4,648 2,206 1,894 3,018 4,853 3,061 4,820 4,187 1,863 5,108 5,485 4,299 2,291 4,189 2,854
12/26/2017 12/26/2017 12/26/2017 12/26/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/28/2017 12/28/2017 12/28/2017 12/28/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/30/2017 12/30/2017 12/30/2017 12/30/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017
Sonia Carlos Sonia Sonia Carlos Sonia Juan Sonia Juan Sonia Juan Juan Juan Carlos Carlos Sonia Juan Juan Sonia Carlos Juan Carlos Carlos Juan Carlos Sonia Sonia Juan Juan Juan Carlos Sonia Carlos
3,775 1,909 5,064 3,732 5,332 3,259 4,196 5,291 1,823 2,671 2,202 5,264 4,269 1,984 4,907 3,587 2,263 4,210 4,769 4,459 2,141 4,069 3,721 3,361 1,861 4,291 4,584 3,565 5,318 4,139 4,691 3,969 5,587
Vendedor Juan Carlos Sonia
Ciudad Cali Cali Cali Cali Cali Cali
Vta. Máxima Vta. Mínima Total Ventas #NAME? #NAME? ### #NAME? #NAME? ### #NAME? #NAME? ###
Fecha Inicio 3/17/2019 3/18/2019 3/19/2019 2/11/2019 3/7/2019 3/9/2019
Fecha Entrega
Tiempo en cliente
12/30/1899 2/22/1900 1/29/1900 1/27/1900
Motivo escalado:
2/22/1900
12/9/2017 12/9/2017 12/9/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/10/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/11/2017 12/12/2017 12/12/2017 12/12/2017 12/13/2017 12/13/2017 12/13/2017 12/13/2017 12/13/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/14/2017 12/15/2017 12/15/2017 12/15/2017 12/15/2017 12/15/2017 12/16/2017 12/16/2017 12/17/2017 12/17/2017 12/17/2017
Juan Sonia Juan Sonia Sonia Sonia Carlos Sonia Juan Carlos Juan Sonia Sonia Juan Sonia Carlos Sonia Sonia Sonia Sonia Carlos Carlos Sonia Sonia Carlos Juan Juan Carlos Carlos Juan Sonia Sonia Sonia Juan Juan Carlos Sonia Juan Juan Sonia Carlos Sonia Carlos Sonia Carlos
3,842 2,860 5,317 4,618 3,705 5,542 2,385 2,806 4,017 1,860 4,637 2,738 2,632 2,357 3,984 2,292 3,407 4,953 5,167 2,770 3,378 2,949 4,338 4,105 2,411 3,389 2,725 4,285 2,874 2,621 4,255 4,720 3,085 4,600 4,917 4,106 4,147 2,957 4,439 4,606 3,810 5,579 1,949 4,138 5,415
12/17/2017 12/17/2017 12/17/2017 12/17/2017 12/18/2017 12/18/2017 12/18/2017 12/18/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/19/2017 12/20/2017 12/20/2017 12/20/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/21/2017 12/22/2017 12/23/2017 12/23/2017 12/23/2017 12/23/2017 12/23/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/24/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/25/2017 12/26/2017
Carlos Carlos Sonia Juan Juan Sonia Carlos Carlos Juan Juan Sonia Carlos Juan Carlos Carlos Sonia Sonia Carlos Carlos Sonia Carlos Sonia Juan Juan Sonia Juan Carlos Juan Sonia Carlos Sonia Juan Sonia Sonia Carlos Carlos Sonia Carlos Juan Carlos Carlos Carlos Sonia Juan Sonia
4,236 5,010 4,115 4,840 4,571 3,307 2,638 4,111 5,491 5,179 5,058 5,259 4,310 5,367 3,203 2,898 4,953 5,363 5,138 4,017 5,408 3,152 4,618 4,836 3,207 4,729 2,964 4,133 2,524 2,308 4,648 2,206 1,894 3,018 4,853 3,061 4,820 4,187 1,863 5,108 5,485 4,299 2,291 4,189 2,854
12/26/2017 12/26/2017 12/26/2017 12/26/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/27/2017 12/28/2017 12/28/2017 12/28/2017 12/28/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/29/2017 12/30/2017 12/30/2017 12/30/2017 12/30/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017 12/31/2017
Sonia Carlos Sonia Sonia Carlos Sonia Juan Sonia Juan Sonia Juan Juan Juan Carlos Carlos Sonia Juan Juan Sonia Carlos Juan Carlos Carlos Juan Carlos Sonia Sonia Juan Juan Juan Carlos Sonia Carlos
3,775 1,909 5,064 3,732 5,332 3,259 4,196 5,291 1,823 2,671 2,202 5,264 4,269 1,984 4,907 3,587 2,263 4,210 4,769 4,459 2,141 4,069 3,721 3,361 1,861 4,291 4,584 3,565 5,318 4,139 4,691 3,969 5,587
Vendedor Juan Carlos Sonia
Ciudad Cali Cali Cali Cali Cali Cali
Vta. Máxima Vta. Mínima Total Ventas #NAME? #NAME? ### #NAME? #NAME? ### #NAME? #NAME? ###
Fecha Inicio 3/17/2019 3/18/2019 3/19/2019 2/11/2019 3/7/2019 3/9/2019
Fecha Entrega
Tiempo en cliente
12/30/1899 2/22/1900 1/29/1900 1/27/1900
Motivo escalado:
2/22/1900
Related Documents
Planilla Para Los Caraquistas.
June 2020 3
Planilla Para Comerciales.xlsx
October 2019 9
Planilla Medica Para Bajar
December 2019 29
Planilla
April 2020 30
Planilla Diges.docx
December 2019 8