Business Help
vernic15
valmodovar__projectdata.xlsxOctober 2014
| Sales System Number | Date of Sale | Extract Date | Sales Consultant ID | SC Last name | SC First Name | State | Office | Region | Territory | Tax Type | Total Contracts | Total Sales | Total Cancellations |
| 265801-2014111 | 10/1/14 | 11/1/14 | 35353356 | Rucco | Adriano F | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 10 | $30,291.00 | 1 |
| 265801-2014111 | 10/1/14 | 11/1/14 | 66464667 | Wiare | Carol P. | GA | ATLANTA | SOUTH | ATLANTA-NORTH GEORGIA | W2 | 4 | $39,999.00 | 0 |
| 315320-2014111 | 10/3/14 | 11/1/14 | 57575758 | Frank | Benjamin | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 11 | $92,829.00 | 1 |
| 265980-2014111 | 10/3/14 | 11/1/14 | 75265980 | Manuter | Victor | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 4 | $44,255.00 | 2 |
| 329247-2014111 | 10/5/14 | 11/1/14 | 83748200 | Travas | Francisco A | TX | EL PASO | SOUTH | SAN ANTONIO | 1099 | 0 | $0.00 | 0 |
| 399053-2014111 | 10/10/14 | 11/1/14 | 26354410 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 5 | $20,100.00 | 1 |
| 407197-2014111 | 10/11/14 | 11/1/14 | 33407197 | Heston | Kelly L | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 0 | $7,881.00 | 0 |
| 407886-2014111 | 10/12/14 | 11/1/14 | 40278386 | Nova | Jeremy S | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 1 | $10,000.00 | 0 |
| 410718-2014111 | 10/13/14 | 11/1/14 | 41107218 | Buster | Jacqueline M | MS | Tri-State | SOUTHWEST | MISSISSIPPI | 1099 | 11 | $83,641.00 | 5 |
| 265005-2014111 | 10/14/14 | 11/1/14 | 26150025 | Jones | Jennifer | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 13 | $0.00 | 13 |
| 265288-2014111 | 10/20/14 | 11/1/14 | 26354410 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 0 | $0.00 | 0 |
| 265440-2014111 | 10/20/14 | 11/1/14 | 26354410 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 7 | $44,242.00 | 0 |
| 265778-2014111 | 10/20/14 | 11/1/14 | 26356778 | Dimit | Enrique | FL | MIAMI | FL/HI | SOUTH FLORIDA | W2 | 1 | $555.00 | 0 |
| 265758-2014111 | 10/20/14 | 11/1/14 | 26457518 | Hansen | Vanessa | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 9 | $80,000.00 | 0 |
| 265068-2014111 | 10/20/14 | 11/1/14 | 26520168 | Vega | William | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 10 | $45,000.00 | 0 |
| 265609-2014111 | 10/20/14 | 11/1/14 | 26526109 | Periter | Eugene | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 25 | $54,535.00 | 0 |
| 265862-2014111 | 10/25/14 | 11/1/14 | 12658262 | Wearever | Erick | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 9 | $24,222.00 | 0 |
| 266104-2014111 | 10/25/14 | 11/1/14 | 26161204 | Uarlike | Yaniri A | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 4 | $14,344.00 | 0 |
| 265823-2014111 | 10/25/14 | 11/1/14 | 26531823 | Nayen | Alicia | IL | CHICAGO | NORTH | ILLINOIS | W2 | 1 | $6,566.00 | 0 |
| 330618-2014111 | 10/26/14 | 11/1/14 | 33011618 | Kite | David N | KY | LOUISVILLE | SOUTH | KENTUCKY | 1099 | 1 | $250.00 | 0 |
| 332509-2014111 | 10/26/14 | 11/1/14 | 33255099 | York | Alex V | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 16 | $50,000.00 | 1 |
| 333704-2014111 | 10/28/14 | 11/1/14 | 33233704 | Amisher | Aisha T | NY | BRONX | NORTH | DOWNSTATE NEW YORK | 1099 | 0 | $321.00 | 0 |
| 407148-2014111 | 10/28/14 | 11/1/14 | 43207148 | Bush | Douglas B | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 3 | $600.00 | 0 |
| 265752-2014111 | 10/30/14 | 11/1/14 | 26325752 | Regan | Andres A | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 13 | $72,990.00 | 0 |
| 265848-2014111 | 10/30/14 | 11/1/14 | 26621106 | Justin | Micah Rae | LA | NEW ORLEANS | SOUTH | LOUISIANA | W2 | 7 | $35,000.00 | 0 |
| 266106-2014111 | 10/30/14 | 11/1/14 | 26621106 | Justin | Micah Rae | LA | NEW ORLEANS | SOUTH | LOUISIANA | W2 | 10 | $87,382.00 | 1 |
| 331393-2014111 | 10/31/14 | 11/1/14 | 33135393 | Williams | Clarence P | KY | LOUISVILLE | SOUTH | KENTUCKY | 1099 | 9 | $21,222.00 | 0 |
November 2014
| Sales System Number | Date of Sale | Extract Date | Sales Consultant ID | SC Last name | SC First Name | State | Office | Region | Territory | Tax Type | Total Contracts | Total Sales | Total Cancellations |
| 265005-2014111 | 11/1/14 | 12/1/14 | 26354410 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 5 | $20,100.00 | 1 |
| 265068-2014111 | 11/2/14 | 12/1/14 | 33407197 | Heston | Kelly L | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 0 | $0.00 | 0 |
| 265288-2014111 | 11/2/14 | 12/1/14 | 40278386 | Nova | Jeremy S | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 1 | $10,000.00 | 0 |
| 265440-2014111 | 11/2/14 | 12/1/14 | 41107218 | Buster | Jacqueline M | MS | Tri-State | SOUTHWEST | MISSISSIPPI | 1099 | 4 | $4,000.00 | 0 |
| 329247-2014111 | 11/3/14 | 12/1/14 | 33011618 | Kite | David N | KY | LOUISVILLE | SOUTH | KENTUCKY | 1099 | 1 | $900.00 | 0 |
| 399053-2014111 | 11/4/14 | 12/1/14 | 33255099 | York | Alex V | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 9 | $30,000.00 | 1 |
| 265609-2014111 | 11/5/14 | 12/1/14 | 66464667 | Wiare | Carol P. | GA | ATLANTA | SOUTH | ATLANTA-NORTH GEORGIA | W2 | 1 | $550.00 | 0 |
| 265758-2014111 | 11/5/14 | 12/1/14 | 35353356 | Rucco | Adriano F | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 3 | $10,300.00 | 0 |
| 265778-2014111 | 11/5/14 | 12/1/14 | 26520168 | Vega | William | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 2 | $5,000.00 | 0 |
| 265823-2014111 | 11/5/14 | 12/1/14 | 26152889 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 14 | $1,000.00 | 13 |
| 265862-2014111 | 11/6/14 | 12/1/14 | 26356778 | Dimit | Enrique | FL | MIAMI | FL/HI | SOUTH FLORIDA | W2 | 1 | $5,000.00 | 0 |
| 266104-2014111 | 11/7/14 | 12/1/14 | 26354410 | Smith | Debbie | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 7 | $500.00 | 0 |
| 330618-2014111 | 11/8/14 | 12/1/14 | 26531823 | Nayen | Alicia | IL | CHICAGO | NORTH | ILLINOIS | W2 | 1 | $3,000.00 | 0 |
| 407197-2014111 | 11/10/14 | 12/1/14 | 33233704 | Amisher | Aisha T | NY | BRONX | NORTH | DOWNSTATE NEW YORK | 1099 | 0 | $0.00 | 0 |
| 407886-2014111 | 11/10/14 | 12/1/14 | 43207148 | Bush | Douglas B | AR | Arkansas | SOUTHWEST | ARKANSAS | 1099 | 3 | $0.00 | 0 |
| 265801-2014111 | 11/11/14 | 12/1/14 | 26526109 | Periter | Eugene | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 16 | $20,000.00 | 0 |
| 265801-2014111 | 11/12/14 | 12/1/14 | 26457518 | Hansen | Vanessa | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 2 | $1,010.00 | 0 |
| 265980-2014111 | 11/13/14 | 12/1/14 | 12658262 | Wearever | Erick | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 2 | $211.00 | 0 |
| 332509-2014111 | 11/15/14 | 12/1/14 | 75265980 | Manuter | Victor | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 4 | $20,100.00 | 1 |
| 333704-2014111 | 11/16/14 | 12/1/14 | 57575758 | Frank | Benjamin | FL | MIAMI | FL/HI | SOUTH FLORIDA | 1099 | 11 | $500.00 | 10 |
| 315320-2014111 | 11/17/14 | 12/1/14 | 26161204 | Uarlike | Yaniri A | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 4 | $10,000.00 | 0 |
| 407148-2014111 | 11/23/14 | 12/1/14 | 83748200 | Travas | Francisco A | TX | EL PASO | SOUTH | SAN ANTONIO | 1099 | 0 | $0.00 | 0 |
| 410718-2014111 | 11/27/14 | 12/1/14 | 26621106 | Justin | Micah Rae | LA | NEW ORLEANS | SOUTH | LOUISIANA | W2 | 10 | $87,382.00 | 1 |
| 265752-2014111 | 11/29/14 | 12/1/14 | 26150025 | Jones | Jennifer | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 5 | $0.00 | 5 |
| 265848-2014111 | 11/29/14 | 12/1/14 | 33135393 | Williams | Clarence P | KY | LOUISVILLE | SOUTH | KENTUCKY | 1099 | 7 | $20,000.00 | 0 |
| 266106-2014111 | 11/30/14 | 12/1/14 | 26325752 | Regan | Andres A | NY | MANHATTAN | NORTH | DOWNSTATE NEW YORK | W2 | 5 | $20,000.00 | 0 |
| 331393-2014111 | 11/30/14 | 12/1/14 | 26621106 | Justin | Micah Rae | LA | NEW ORLEANS | SOUTH | LOUISIANA | W2 | 2 | $1,000.00 | 0 |
December 2014
| Sales System Number | Date of Sale | Extract Date | Sales Consultant ID | SC Last name | SC First Name | State | Region | Total Contracts | Total Sales | Total Cancellations | Module 05 Explanation" | |
| 265005-2014111 | 12/1/14 | 1/1/15 | 26354410 | Smith | Debbie | FL | FL/HI | 0 | $0.00 | 0 | The tabs that I have taken out are: territory, taxes, and office. I feel that this is not pertenent to sales because we have a region and state, we can track what the sales consultant is doing by id given. Contracts, total sales and cancellations help to track data in real time and what it is we need to do to boost sales. | |
| 265288-2014111 | 12/1/14 | 1/1/15 | 40278386 | Nova | Jeremy S | AR | SOUTHWEST | 5 | $10,000.00 | 3 | ||
| 410718-2014111 | 12/1/14 | 1/1/15 | 26621106 | Justin | Micah Rae | LA | SOUTH | 10 | $0.00 | 10 | ||
| 265609-2014111 | 12/2/14 | 1/1/15 | 66464667 | Wiare | Carol P. | GA | SOUTH | 9 | $7,000.00 | 3 | ||
| 265440-2014111 | 12/3/14 | 1/1/15 | 41107218 | Buster | Jacqueline M | MS | SOUTHWEST | 3 | $4,000.00 | 0 | ||
| 266104-2014111 | 12/3/14 | 1/1/15 | 26354410 | Smith | Debbie | FL | FL/HI | 1 | $500.00 | 0 | ||
| 333704-2014111 | 12/4/14 | 1/1/15 | 57575758 | Frank | Benjamin | FL | FL/HI | 9 | $2,000.00 | 5 | ||
| 331393-2014111 | 12/5/14 | 1/1/15 | 26621106 | Justin | Micah Rae | LA | SOUTH | 1 | $1,000.00 | 0 | ||
| 407148-2014111 | 12/6/14 | 1/1/15 | 83748200 | Travas | Francisco A | TX | SOUTH | 0 | $0.00 | 0 | ||
| 265752-2014111 | 12/6/14 | 1/1/15 | 26150025 | Jones | Jennifer | NY | NORTH | 18 | $7,000.00 | 5 | ||
| 265823-2014111 | 12/7/14 | 1/1/15 | 26152889 | Smith | Debbie | FL | FL/HI | 14 | $1,000.00 | 13 | ||
| 407886-2014111 | 12/8/14 | 1/1/15 | 26621106 | Justin | Micah Rae | LA | SOUTH | 11 | $0.00 | 11 | ||
| 265801-2014111 | 12/9/14 | 1/1/15 | 26526109 | Periter | Eugene | NY | NORTH | 16 | $20,000.00 | 0 | ||
| 315320-2014111 | 12/9/14 | 1/1/15 | 26161204 | Uarlike | Yaniri A | NY | NORTH | 4 | $10,000.00 | 0 | ||
| 399053-2014111 | 12/10/14 | 1/1/15 | 33255099 | York | Alex V | NY | NORTH | 9 | $30,000.00 | 1 | ||
| 265778-2014111 | 12/11/14 | 1/1/15 | 26520168 | Vega | William | NY | NORTH | 0 | $5,000.00 | 0 | ||
| 265758-2014111 | 12/12/14 | 1/1/15 | 35353356 | Rucco | Adriano F | NY | NORTH | 3 | $10,300.00 | 0 | ||
| 265801-2014111 | 12/13/14 | 1/1/15 | 26457518 | Hansen | Vanessa | NY | NORTH | 18 | $7,000.00 | 10 | ||
| 332509-2014111 | 12/14/14 | 1/1/15 | 75265980 | Manuter | Victor | NY | NORTH | 16 | $20,000.00 | 0 | ||
| 265068-2014111 | 12/15/14 | 1/1/15 | 33407197 | Heston | Kelly L | AR | SOUTHWEST | 0 | $0.00 | 0 | ||
| 329247-2014111 | 12/19/14 | 1/1/15 | 33011618 | Kite | David N | KY | SOUTH | 2 | $900.00 | 0 | ||
| 266106-2014111 | 12/20/14 | 1/1/15 | 26325752 | Regan | Andres A | NY | NORTH | 16 | $20,000.00 | 0 | ||
| 265862-2014111 | 12/21/14 | 1/1/15 | 26356778 | Dimit | Enrique | FL | FL/HI | 1 | $5,000.00 | 0 | ||
| 265848-2014111 | 12/22/14 | 1/1/15 | 33135393 | Williams | Clarence P | KY | SOUTH | 7 | $20,000.00 | 0 | ||
| 407197-2014111 | 12/23/14 | 1/1/15 | 33233704 | Amisher | Aisha T | NY | NORTH | 1 | $0.00 | 0 | ||
| 330618-2014111 | 12/24/14 | 1/1/15 | 26621106 | Justin | Micah Rae | LA | SOUTH | 2 | $0.00 | 2 | ||
| 265980-2014111 | 12/30/14 | 1/1/15 | 12658262 | Wearever | Erick | NY | NORTH | 16 | $20,000.00 | 0 |
