Chargeback Class Name First Name Last Name E M by ked12544

VIEWS: 25 PAGES: 14

More Info
									                                                                                                                   Chargeback
Class Name                                     First Name Last Name   E-Mail Address                Phone          Number
Excel 2007 Functions & Formulas                Kit        Elert       kit.elert@elert.com           651-705-1224           1506
Excel 2007 Functions & Formulas                Stefanie   Nett        stefanie.nett@elert.com       651-705-1254           1402

Access 2007 Working with Table Relationships   Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
Word 2007 Tables                               Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Outlook 2007 New Features                      Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Word 2007 Styles                               Heather    Tank        heather.tank@elert.com        651-705-1243          1301

Excel 2007 Getting Started                     Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262          1402
Access 2007 Getting Started                    Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Getting Started                    Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Access 2007 Making the Most of Tables          Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Making the Most of Tables          Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Excel 2007 Creating Charts                     Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Excel 2007 Creating Charts                     Kit        Elert       kit.elert@elert.com           651-705-1224          1506

Excel 2007 Tables                              Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245          1207

Excel 2007 Tables                              Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262          1402
Word 2007 Templates                            Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
Word 2007 Templates                            Heather    Tank        heather.tank@elert.com        651-705-1243          1301
PowerPoint 2007 Animating Presentations        Stefanie   Nett        stefanie.nett@elert.com       651-705-1254          1402
Access 2007 Queries I                          Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Queries I                          Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Word 2007 Tables                               Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Word 2007 Tables                               Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Excel 2007 Creating Charts                     Heather    Tank        heather.tank@elert.com        651-705-1243          1301

Excel 2007 Tips & Shortcuts                    Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245          1207
Word 2007 Forms                                Heather    Tank        heather.tank@elert.com        651-705-1243          1301
PowerPoint 2007 Slide Shows                    Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
PowerPoint 2007 Slide Shows                    Stefanie   Nett        stefanie.nett@elert.com       651-705-1254          1402
Excel 2007 More Functions & Formulas          Kit        Elert       kit.elert@elert.com           651-705-1224   1506

Excel 2007 More Functions & Formulas          Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245   1207
Word 2007 Templates                           Danielle   Strom       danielle.strom@elert.com      651-705-1240   1301

Excel 2007 More Functions & Formulas          Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262   1402

Word 2007 Numbered, Bulleted, & Outline Lists Kit        Elert       kit.elert@elert.com           651-705-1224   1506
                 PO                Discount
Class Time       Number Price      %
 1/11/2008 10:30      555       75        1%
 1/11/2008 10:30      444       75        1%

1/21/2008 15:00      333        80       2%
 2/22/2008 8:30      555        85       2%
1/24/2008 15:00      333        75       1%
1/28/2008 13:00      333        85       2%

 2/4/2008 13:00      444        75       1%
 2/7/2008 15:00      333        80       2%
 2/7/2008 15:00      555        80       2%
2/11/2008 13:00      333        80       2%
2/11/2008 13:00      555        80       2%
2/12/2008 15:00      333        75       1%
2/12/2008 15:00      555        75       1%

2/14/2008 15:00      222        75       1%

2/14/2008 15:00      444        75       1%
 2/18/2008 8:30      333        85       2%
 2/18/2008 8:30      333        85       2%
2/18/2008 10:30      444        90       3%
2/18/2008 15:00      333        80       2%
2/18/2008 15:00      555        80       2%
 2/22/2008 8:30      333        85       2%
 2/22/2008 8:30      555        85       2%
2/12/2008 15:00      333        75       1%

2/22/2008 10:30      222        75       1%
2/25/2008 10:30      333        85       2%
2/25/2008 15:00      333        90       3%
2/25/2008 15:00      444        90       3%
2/28/2008 15:00   555   75   1%

2/28/2008 15:00   222   75   1%
 2/18/2008 8:30   333   85   2%

2/28/2008 15:00   444   75   1%

2/29/2008 13:00   555   85   2%
Region         January         February       March      Qtr 1
North           $     10,111    $ 13,400      $ 15,900   $ 39,411
South           $     22,100    $ 14,050      $ 16,550   $ 52,700
East            $     13,270    $ 12,120      $ 14,620   $ 40,010
West            $     10,800    $ 21,500      $ 24,000   $ 56,300
Total           $     56,281    $ 61,070      $ 71,070   $ 188,421




Discount Rate:                           1%


Discounted Qtr 1 Sales:        $      1,884

Total Sales:                       #VALUE!

Bonus Amount:                  $     15,074
Mileage                                           Mileage Rate: $      0.48

           Jan          Feb          Mar             Qtr 1     Reimbursement
Smith             200          400          500           1100
Johnson           250          500          400           1150
Thompson          350          200          300            850
O'Brien           300          600          200           1100
Total            1100         1700         1400           4200
January

Jan

Monday

Mon

        1-Jan

 1/1/2008

PO #            Acct #       Departments
        1000             1   Network
        1005                 Telecom
                             Multimedia
                             Public Safety
                             Training
                             Managed Services

Qtr 1

Task 100
                                                                                                                   Chargeback
Class Name                                     First Name Last Name   E-Mail Address                Phone          Number
Excel 2007 Functions & Formulas                Kit        Elert       kit.elert@elert.com           651-705-1224           1506
Excel 2007 Functions & Formulas                Stefanie   Nett        stefanie.nett@elert.com       651-705-1254           1402

Access 2007 Working with Table Relationships   Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
Word 2007 Tables                               Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Outlook 2007 New Features                      Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Word 2007 Styles                               Heather    Tank        heather.tank@elert.com        651-705-1243          1301

Excel 2007 Getting Started                     Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262          1402
Access 2007 Getting Started                    Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Getting Started                    Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Access 2007 Making the Most of Tables          Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Making the Most of Tables          Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Excel 2007 Creating Charts                     Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Excel 2007 Creating Charts                     Kit        Elert       kit.elert@elert.com           651-705-1224          1506

Excel 2007 Tables                              Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245          1207

Excel 2007 Tables                              Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262          1402
Word 2007 Templates                            Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
Word 2007 Templates                            Heather    Tank        heather.tank@elert.com        651-705-1243          1301
PowerPoint 2007 Animating Presentations        Stefanie   Nett        stefanie.nett@elert.com       651-705-1254          1402
Access 2007 Queries I                          Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Access 2007 Queries I                          Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Word 2007 Tables                               Heather    Tank        heather.tank@elert.com        651-705-1243          1301
Word 2007 Tables                               Kit        Elert       kit.elert@elert.com           651-705-1224          1506
Excel 2007 Creating Charts                     Heather    Tank        heather.tank@elert.com        651-705-1243          1301

Excel 2007 Tips & Shortcuts                    Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245          1207
Word 2007 Forms                                Heather    Tank        heather.tank@elert.com        651-705-1243          1301
PowerPoint 2007 Slide Shows                    Danielle   Strom       danielle.strom@elert.com      651-705-1240          1301
PowerPoint 2007 Slide Shows                    Stefanie   Nett        stefanie.nett@elert.com       651-705-1254          1402
Excel 2007 More Functions & Formulas          Kit        Elert       kit.elert@elert.com           651-705-1224   1506

Excel 2007 More Functions & Formulas          Patrice    Nordstrom   patrice.nordstrom@elert.com   651-705-1245   1207
Word 2007 Templates                           Danielle   Strom       danielle.strom@elert.com      651-705-1240   1301

Excel 2007 More Functions & Formulas          Steve      Gimmestad   steve.gimmestad@elert.com     651-705-1262   1402

Word 2007 Numbered, Bulleted, & Outline Lists Kit        Elert       kit.elert@elert.com           651-705-1224   1506
                 PO                Discount
Class Time       Number Price      %
 1/11/2008 10:30      555       75        1%
 1/11/2008 10:30      444       75        1%

1/21/2008 15:00      333        80       2%
 2/22/2008 8:30      555        85       2%
1/24/2008 15:00      333        75       1%
1/28/2008 13:00      333        85       2%

 2/4/2008 13:00      444        75       1%
 2/7/2008 15:00      333        80       2%
 2/7/2008 15:00      555        80       2%
2/11/2008 13:00      333        80       2%
2/11/2008 13:00      555        80       2%
2/12/2008 15:00      333        75       1%
2/12/2008 15:00      555        75       1%

2/14/2008 15:00      222        75       1%

2/14/2008 15:00      444        75       1%
 2/18/2008 8:30      333        85       2%
 2/18/2008 8:30      333        85       2%
2/18/2008 10:30      444        90       3%
2/18/2008 15:00      333        80       2%
2/18/2008 15:00      555        80       2%
 2/22/2008 8:30      333        85       2%
 2/22/2008 8:30      555        85       2%
2/12/2008 15:00      333        75       1%

2/22/2008 10:30      222        75       1%
2/25/2008 10:30      333        85       2%
2/25/2008 15:00      333        90       3%
2/25/2008 15:00      444        90       3%
2/28/2008 15:00   555   75   1%

2/28/2008 15:00   222   75   1%
 2/18/2008 8:30   333   85   2%

2/28/2008 15:00   444   75   1%

2/29/2008 13:00   555   85   2%
Entering Data
Today's Stock Quote:

75% is the same as:


Current Date:
Current Time:


                Jan    Feb   Mar
Smith
Johnson
Thompson
O'Brien
My Job              Getting From Here to There




My Dream Vacation
om Here to There

								
To top