Docstoc

EXAMPLES

Document Sample
EXAMPLES Powered By Docstoc
					                                   Sales Goals



                Regional Sales Goals
                        (in thousands)

Region      Qtr 1      Qtr 2      Qtr 3          Qtr 4    Totals
Eastern    $ 15,000   $ 18,000   $ 22,000     $ 26,500   $ 81,500
Central    $ 18,000   $ 21,500   $ 26,000     $ 31,000   $ 96,500
Western    $ 22,000   $ 26,500   $ 32,000     $ 38,500   $ 119,000
  Totals   $ 55,000   $ 66,000   $ 80,000     $ 96,000   $ 297,000




                                                                     Audited by Pat Owens




                                     Page 1
                       Sales Goals




Audited by Pat Owens




                         Page 2
                                Regional Sales Goals



              $40,000           Eastern   Central   Western


              $35,000


              $30,000


              $25,000
(thousands)




              $20,000


              $15,000


              $10,000


               $5,000


                  $-
                        Qtr 1   Qtr 2               Qtr 3     Qtr 4
                                            AutoSum


Regional Sales Goals

Region       Qtr 1      Qtr 2    Qtr 3    Qtr 4    Totals
Eastern       15000      18000    22000    26500
Central       18000      21500    26000    31000
Western       22000      26500    32000    38500
    Totals


Regional Sales Prior Year

Region       Qtr 1      Qtr 2    Qtr 3    Qtr 4    Totals
Eastern        7500       9000    11000    13250
Central        9000      10750    13000    15500
Western       11000      13250    16000    19250
    Totals




                                             Page 4
Time Card Worksheet

                                                   Hourly
Employee Name   Mon Tue Wed Thu             Fri                Gross Pay
                                                   Rate
Pat Owens       8.00   8.00   8.00   8.00   8.00   $   10.00
Carol Davis     8.00   7.50   8.00   6.25   4.00   $   12.00
Kim Loo         8.00   8.00   7.00   8.00   6.00   $   10.00
Carey Martin    8.00   8.00   8.00   8.00   8.00   $   15.00
Andy Mendez     8.00   8.00   8.00   8.00   8.00   $   14.00
                                       AutoFill



                                 Using the Autofill feature

Months of   Days of the                Numbered
                           Ordinals                  Dates     Quarters   Copy
the Year      Week                     Text Fields
January     Monday        1st Period   Region 1       5/1/00     Q1       1960




                                       Page 6
                                   AutoFill



e
     Increment
                   Increase # by
    with a blank
                    increments
        cell
           1001            1960
                           1965




                                   Page 7
                                                      Currency



Converting £ to $
                                                      Exchange rate:             1.70
On a recent trip to Britain, I encountered the following
prices. Please convert the £ to $ in column C.

                  Description of Item                        Cost (in £) Cost (in $US)
                                 BigMac at MacDonalds            £1.74
               Gallon of unleaded, self-service gasoline         £4.40
              Cream tea with scones and clotted cream            £2.95
             Double cheeseburger, Hilton room service            £8.55
        Eurostar 2nd class economy round trip to Paris          £84.00
                One night at the Conrad Hilton, London         £130.00
                  Eurostar first class round trip to Paris     £195.00




                                                       Page 8
                                                     Travel



Travel Expense Report
                                      Mileage
  Date           Location    Miles                   Meals        Hotel    Total
                                     Allowance


12/11/2010   Monterey           76               $    56.10   $    65.89
12/18/2010   Salinas            45               $    23.12   $    89.90
12/25/2010   Fremont            34               $    45.18   $   125.45
  1/1/2011   Palo Alto          25               $    50.25   $    78.50

             TOTALS:



             Mileage Rate:   $0.25




                                                     Page 9
                                 Ranges




Qty Item No.          Description         Unit Price   Amount
 1     101     Executive Swivel Chair        $425.00    $425.00
 2     105     Classic Side Arm Chair        $150.00
 3     102     Low-back Side Arm Chair       $225.00
 1     110     Contemporary Bookcase         $650.00
 1     106     Double Pedestal Desk        $1,255.00



                                           Total:




                                Page 10
                               Sorting



Famous National Parks
Name              State Year Sq. Miles

Rocky Mountain    CO    1915         415
Canyonlands       UT    1964         528
Mount Ranier      WA    1899         368
Big Bend          TX    1935       1,252
Zion              UT    1909         230
Bryce Canyon      UT    1923          56
Lassen Volcanic   CA    1907         166
Grand Canyon      AZ    1908       1,904
Glacier           MT    1910       1,584
Crater Lake       OR    1902         286
Yellowstone       WY    1872       3,570
Grand Teton       WY    1929         484
Sequoia           CA    1890         629
Yosemite          CA    1890       1,190




                               Page 11
                         Domestic Retail Sales Report

Widget Retail Sales
Store #   Jan      Feb      Mar          Apr          May      Jun      Jul

   100    13,953   20,506    20,825       22,123      16,980   17,158   20,035
   101    13,843   15,471    11,760       21,398      21,510   16,027   18,620
   102    22,850   13,884    23,657       19,162      19,922   17,459   24,968
   103    18,044   24,857    15,186       19,515      13,318   14,847   20,795
   104    10,594   13,080    17,848       20,417      18,763   19,849   15,462
   105    16,335   12,248    21,674       21,734      24,805   21,144   18,968
   106    15,101   12,126    12,318       22,368      24,939   11,687   24,401
   107    15,443   19,268    11,919       15,782      12,757   18,530   11,088
   108    21,582   17,525    24,629       12,532      20,185   23,186   17,103
   109    10,777   20,579    18,513       13,626      17,759   11,349   13,871
   110    10,158   21,212    15,389       19,001      21,279   22,486   16,751
   111    18,415   21,978    20,310       18,509      14,640   24,402   19,444
   112    14,658   13,093    18,826       24,946      24,225   19,453   14,693
   113    10,046   11,259    21,845       14,187      22,776   24,336   15,306
   114    17,194   16,643    21,045       17,386      22,108   23,355   10,367
   115    13,979   15,353    14,472       14,451      19,478   21,712   16,970
   116    23,719   19,291    14,100       23,946      15,352   12,457   24,959
   117    16,844   13,272    17,305       13,548      10,953   14,712   10,030
   118    21,392   23,423    24,484       19,883      12,273   17,588   13,598
   119    23,194   22,784    13,954       13,558      22,565   12,937   12,920
   120    11,718   14,202    16,776       20,771      14,552   13,593   24,287
   121    18,267   19,727    20,602       17,734      22,815   21,070   16,415
   122    12,003   21,469    16,246       21,400      14,043   19,034   13,198
   123    11,846   20,390    11,799       23,182      11,668   13,933   16,794
   124    17,701   13,174    17,784       15,811      12,841   14,754   17,548
   125    19,493   23,271    12,132       11,261      18,900   19,044   14,494
   126    13,883   18,289    14,563       19,012      24,697   11,379   24,697
   127    17,718   11,936    11,376       15,880      21,591   14,613   14,043
   128    16,596   23,334    11,966       20,711      11,275   13,115   23,097
   129    22,694   12,715    11,527       24,677      20,919   17,992   12,239
   130    24,956   14,001    22,190       15,559      12,996   22,139   20,703
   131    24,673   13,534    23,780       18,727      15,200   11,557   19,770
   132    20,339   15,408    24,736       15,857      21,952   20,317   10,240
   133    16,676   13,491    12,089       12,683      24,824   12,260   19,193
   134    16,429   15,074    17,952       21,926      22,009   22,029   22,861
   135    16,606   13,722    23,700       21,089      13,782   16,626   14,069
   136    18,636   13,542    12,821       16,185      17,971   13,153   22,638


                                      Page 12 of 27
                   Domestic Retail Sales Report
137   16,153   18,099   23,623       23,009      15,714   10,735   11,910
138   11,100   19,455   18,284       11,078      10,837   11,036   12,833
139   18,632   23,365   24,796       24,276      15,858   16,965   15,491
140   17,623   15,297   10,872       12,656      14,942   21,079   13,972
141   24,928   11,122   19,012       19,477      14,327   12,121   19,207
142   24,706   24,186   15,584       14,469      13,802   15,307   18,800
143   19,681   16,328   13,005       23,127      21,640   24,949   21,258
144   13,790   24,472   19,117       19,808      24,472   21,252   24,747
145   22,349   13,827   20,946       12,183      18,228   11,421   16,874
146   18,481   12,100   14,085       17,451      16,486   11,682   17,929
147   16,722   19,448   23,433       14,665      18,887   18,288   18,355
148   12,543   13,210   11,077       16,363      11,055   12,745   12,936
149   20,870   11,486   11,655       11,241      17,532   24,081   13,960
150   17,661   11,003   10,292       11,732      23,291   13,815   14,384
151   21,830   24,848   19,968       15,992      18,129   18,664   18,827
152   21,373   14,357   12,275       10,303      16,321   22,177   21,890
153   18,209   23,285   17,403       17,058      11,128   21,506   22,217
154   13,118   24,446   18,674       16,103      11,989   15,908   18,202
155   24,862   23,204   24,758       11,127      11,732   16,751   11,588
156   14,564   21,023   13,001       15,551      23,774   15,703   16,021
157   22,361   19,729   11,111       19,226      22,924   10,095   19,684
158   22,707   19,416   14,531       19,622      14,811   13,241   23,574
159   19,714   24,565   19,748       17,457      22,820   20,745   11,611
160   13,275   14,268   19,423       21,953      23,752   23,263   11,230
161   19,318   12,138   14,079       22,939      18,444   22,307   14,788
162   12,127   23,506   12,650       16,161      10,522   22,624   16,877
163   13,231   23,263   11,606       16,896      14,654   13,935   20,503
164   16,678   20,850   10,297       19,816      23,244   21,678   14,504
165   13,191   21,322   10,623       24,053      15,055   23,607   14,679
166   24,620   12,984   23,227       16,340      13,289   20,148   16,166
167   11,585   10,231   14,152       23,746      15,547   12,467   12,319
168   21,220   15,916   20,999       20,821      24,538   17,162   15,140
169   12,368   18,630   20,692       22,554      19,152   13,580   15,852
170   12,551   12,961   20,743       21,184      23,987   11,791   22,500
171   19,687   22,383   22,229       23,930      22,123   17,459   24,533
172   19,944   22,548   18,160       18,734      24,210   13,401   20,983
173   14,402   14,494   18,763       20,986      22,533   11,847   19,985
174   10,421   10,693   20,866       19,310      18,145   22,482   22,981
175   16,244   15,262   15,527       19,240      12,645   13,067   11,152
176   21,250   13,411   21,390       20,288      10,459   23,613   11,288
177   10,302   21,798   19,581       13,554      23,674   10,996   14,849
178   16,378   24,958   24,287       19,265      18,791   14,265   22,676


                                 Page 13 of 27
                   Domestic Retail Sales Report
179   15,254   14,223   11,555       16,300      12,664   11,689   22,413
180   22,502   20,120   23,676       12,298      23,287   16,287   15,870
181   23,867   13,648   24,511       12,451      22,873   14,522   20,988
182   11,054   15,171   18,142       15,188      22,513   24,824   13,652
183   15,584   10,719   12,752       24,727      12,832   14,114   19,796
184   11,070   11,489   16,000       21,582      19,787   21,971   13,106
185   21,592   21,642   20,538       20,804      22,686   12,036   12,203
186   11,821   17,701   11,329       15,243      13,110   20,203   19,073
187   12,398   18,520   21,227       19,661      17,999   16,500   13,417
188   20,069   21,602   16,657       20,142      14,456   20,139   15,226
189   23,701   21,227   20,692       23,726      12,030   14,333   15,185
190   18,117   19,499   21,279       10,479      18,292   11,754   16,845
191   13,942   16,720   21,485       20,685      21,320   22,260   11,034
192   22,273   19,791   23,071       18,235      11,744   21,767   13,579
193   20,305   15,872   21,261       10,462      18,512   24,630   21,157
194   23,505   17,910   24,134       17,002      24,360   23,878   17,652
195   17,227   24,469   20,488       11,933      20,739   14,091   22,292
196   18,824   15,101   12,102       12,963      10,765   10,165   18,114
197   20,436   10,646   23,277       11,869      21,255   17,527   13,546
198   24,263   15,641   22,462       22,118      10,451   20,785   21,524
199   17,619   14,772   19,060       15,608      21,079   24,794   16,058
200   12,845   13,610   21,097       10,596      21,017   20,154   17,332
201   11,883   12,784   10,518       12,056      17,377   13,532   21,635
202   17,207   12,848   20,160       16,868      19,733   24,275   20,723
203   11,682   17,972   17,498       19,498      19,904   20,595   11,426
204   10,649   23,686   10,368       11,583      21,989   12,008   20,521
205   13,306   18,410   19,172       12,688      11,244   17,516   11,216
206   16,094   11,055   24,127       14,934      18,658   11,475   22,660
207   18,685   23,433   12,528       16,471      22,350   22,840   22,038
208   16,178   12,091   24,259       12,191      24,896   22,104   23,776
209   11,153   24,175   21,688       23,697      15,418   17,998   23,956
210   13,716   15,497   13,908       10,458      10,476   22,620   13,534
211   22,111   21,717   17,954       22,023      10,408   12,465   13,372
212   14,167   15,037   12,198       17,475      16,521   17,298   20,152
213   18,952   16,262   15,623       19,412      22,432   18,830   16,182
214   11,427   15,996   23,140       15,491      18,921   12,380   13,788
215   24,195   15,264   21,848       13,407      21,959   12,229   18,920
216   18,474   19,336   22,144       11,881      21,177   12,787   23,205
217   11,485   21,297   22,781       12,523      11,191   21,410   20,917
218   15,181   19,418   19,744       22,537      22,729   18,084   11,380
219   13,957   12,525   17,681       11,654      11,160   21,276   13,015
220   19,791   18,414   13,261       14,546      16,215   14,338   16,258


                                 Page 14 of 27
                          Domestic Retail Sales Report
   221     12,987    12,770    23,782       20,151      11,557   20,912   20,547
   222     10,164    22,672    21,848       18,555      20,725   14,535   11,603
   223     11,697    12,827    12,988       22,022      20,661   16,252   23,396
   224     19,628    10,801    22,867       18,897      14,341   19,745   22,957
   225     23,100    13,217    13,781       24,761      21,915   19,734   16,250
   226     22,775    18,351    12,524       17,195      10,018   11,230   22,450
   227     16,592    17,404    20,747       19,241      18,517   17,312   21,827
   228     20,992    13,088    12,359       16,347      17,645   24,079   15,394
   229     15,234    21,504    12,818       17,187      19,010   15,650   12,072
   230     11,703    15,954    18,966       22,379      22,425   11,312   23,513
   231     17,548    12,524    22,023       22,308      23,486   10,345   13,910
   232     14,531    10,718    15,706       10,365      11,421   15,775   19,157
   233     15,681    18,676    21,724       16,958      24,864   23,300   24,951
   234     24,906    17,714    24,896       23,223      21,502   12,743   22,293
   235     13,241    10,312    14,116       14,515      14,321   13,897   16,404
   236     14,111    23,485    13,438       12,625      23,993   23,673   19,583
   237     12,672    20,494    20,845       21,582      12,658   19,436   13,269
   238     19,782    23,624    11,826       21,381      17,563   23,118   24,825
   239     15,730    19,107    19,951       13,617      20,303   10,738   18,949
   240     17,655    14,691    22,376       11,801      13,843   18,989   18,937
   241     22,747    10,265    16,386       19,486      11,819   17,207   19,435
   242     18,488    22,144    18,427       22,658      20,176   19,847   15,232
   243     22,888    12,232    22,401       17,052      19,467   20,291   15,944
   244     19,253    13,714    10,356       15,657      24,902   12,176   21,376
   245     23,833    15,151    20,297       20,252      17,295   16,210   24,820
   246     14,725    10,294    18,686       11,409      18,832   24,995   19,247
   247     12,562    17,491    17,961       22,855      19,036   14,338   16,656
   248     15,281    18,932    12,518       19,640      11,948   20,827   14,284
   249     24,931    10,364    20,544       24,204      14,979   11,306   16,274
   250     15,215    21,309    21,313       10,319      10,018   21,917   22,642


Totals   2,590,341 2,584,158 2,694,512 2,660,390 2,701,856 2,617,610 2,662,844




                                        Page 15 of 27
                    Domestic Retail Sales Report



Aug      Sep      Oct      Nov          Dec       TOTALS

16,324   18,990   14,578   20,926        21,318    223,815
12,854   20,475   20,077   13,187        19,956    205,280
18,708   20,598   13,899   21,629        22,966    239,803
10,095   13,975   21,320   17,610        21,850    211,514
11,894   12,947   24,055   14,217        11,598    190,827
22,608   12,531   14,919   22,696        17,727    227,495
12,943   11,601   15,053   13,886        16,569    193,098
20,844   14,243   15,143   20,776        16,147    192,047
17,487   13,170   19,099   22,250        21,163    230,019
21,294   17,655   17,037   17,521        12,897    192,986
17,625   16,719   12,251   22,979        11,997    207,958
14,375   21,237   20,939   15,343        14,576    224,279
19,720   14,996   11,918   11,227        22,362    210,230
11,963   14,615   19,041   22,389        15,645    203,520
20,502   11,251   18,082   10,290        15,332    203,670
19,248   16,389   12,404   13,307        20,711    198,590
12,151   15,854   10,796   15,396        22,596    210,733
10,795   18,586   16,866   17,962        16,319    177,309
24,105   15,502   19,975   12,291        16,314    220,947
11,231   10,440   15,239   12,789        12,091    183,821
18,203   13,100   12,378   11,673        21,584    192,958
19,144   13,468   18,416   17,029        12,086    216,894
22,027   16,934   12,805   22,927        10,024    202,233
18,802   11,223   13,991   13,876        10,578    178,206
14,880   19,056   12,586   13,323        21,057    190,639
17,272   17,248   22,067   18,344        19,260    212,911
20,089   18,472   24,694   24,424        23,612    237,937
16,881   18,038   20,972   22,897        16,316    202,388
24,848   15,679   13,604   19,902        19,286    213,540
12,330   18,835   19,278   11,350        10,476    195,162
10,938   14,657   24,799   15,081        10,701    208,849
12,255   21,833   24,054   10,095        11,299    206,910
12,357   13,031   23,060   10,683        11,121    199,232
10,474   20,606   13,614   13,022        19,300    188,365
10,788   16,514   16,416   10,335        21,695    214,164
24,931   13,493   13,699   24,075        18,818    214,743
23,868   14,541   17,131   13,416        23,285    207,324


                                 Page 16 of 27
                    Domestic Retail Sales Report
19,896   13,940   19,315   14,316      14,551   201,397
24,207   23,760   15,311   20,552      10,524   189,115
13,230   10,024   19,589   21,049      20,250   223,666
19,359   24,981   10,091   10,580      24,532   196,125
13,347   16,280   13,014   17,575      10,876   191,427
12,149   23,765   24,137   16,947      22,558   226,554
12,057   24,505   13,208   20,101      20,189   230,190
15,294   15,959   18,255   10,325      11,731   219,367
21,604   22,085   17,680   17,917      10,778   206,036
23,180   19,261   18,923   19,602      22,100   211,427
20,685   10,789   23,797   17,426      12,450   215,092
18,254   15,986   14,601   23,051      12,759   174,728
20,286   20,659   11,132   14,120      17,387   194,557
21,132   20,775   24,466   17,929      19,617   206,247
21,310   13,254   18,553   12,450      11,052   215,027
11,611   14,049   14,052   14,439      15,539   188,538
15,028   15,602   21,575   20,556      15,028   218,748
15,320   12,351   15,767   21,162      17,612   200,806
23,938   22,703   12,129   13,303      17,226   213,475
17,638   10,277   22,327   12,811      21,890   204,738
23,755   24,513   17,784   24,220      22,676   238,238
15,958   12,772   15,893   15,274      13,318   201,274
22,782   24,233   11,805   10,681      14,991   221,311
22,364   19,447   21,931   21,879      19,502   232,447
12,873   18,799   16,035   13,174      16,173   201,230
19,429   24,439   21,052   13,821      12,442   205,813
22,628   16,612   17,883   18,544      12,288   202,207
11,200   22,266   13,370   19,533      19,202   212,802
24,479   16,232   18,151   11,659      18,379   211,597
15,274   13,672   18,439   14,351      11,080   199,756
22,504   24,604   19,955   11,185      10,958   189,421
16,850   12,183   20,160   16,132      22,220   223,509
18,298   10,977   20,880   23,335      10,043   206,530
16,755   20,407   12,952   22,898      20,258   219,156
19,284   10,315   20,374   12,096      14,882   229,467
11,383   15,800   22,908   20,060      19,948   228,250
16,270   15,061   17,376   18,128      10,719   200,736
16,721   23,767   21,113   17,045      19,673   223,391
14,849   10,982   10,451   20,475      19,605   179,674
16,679   14,789   20,936   16,108      18,974   209,363
21,192   22,455   12,031   22,959      18,980   212,546
21,850   18,670   19,802   20,716      18,188   240,026


                               Page 17 of 27
                    Domestic Retail Sales Report
19,259   13,284   11,547   21,710      24,578   194,653
15,320   12,571   16,005   22,354      20,361   220,829
20,401   22,172   20,587   22,381      19,402   237,984
12,250   15,890   20,296   12,712      12,117   193,992
21,827   24,792   22,741   23,524      22,202   225,791
18,262   17,537   12,647   16,312      21,418   201,366
16,968   16,187   22,977   16,456      23,586   227,858
22,176   13,711   10,129   17,257      18,620   190,560
11,865   13,391   12,192   11,486      15,719   184,562
18,733   11,957   20,379   20,610      19,658   219,815
23,346   11,421   21,471   22,134      17,978   227,433
23,049   11,113   21,359   15,651      14,933   202,560
15,567   16,004   17,092   18,367      17,479   212,146
12,824   24,322   12,554   15,058      23,702   219,112
22,698   14,355   14,190   17,903      21,656   223,193
13,040   15,240   21,056   21,292      13,924   233,186
12,782   23,246   11,892   24,431      20,026   223,812
22,681   18,859   14,691   19,604      13,321   187,385
12,580   20,920   19,024   17,624      22,916   211,817
16,019   12,231   11,484   21,028      15,890   214,095
19,946   14,514   22,099   23,478      18,263   227,489
22,146   22,439   13,980   23,496      17,348   216,262
20,682   13,231   18,197   15,469      23,499   191,064
24,589   12,480   24,395   24,321      20,702   238,504
12,719   14,405   18,239   20,723      21,643   206,507
19,378   18,921   12,123   14,603      23,431   199,465
17,277   20,375   15,916   18,239      23,125   198,689
14,238   21,246   14,953   23,661      20,544   213,850
22,209   23,068   17,297   21,432      24,987   247,544
17,680   14,809   19,131   18,194      24,644   230,159
20,655   19,855   17,825   17,468      22,839   236,937
23,418   17,085   23,390   23,870      16,101   204,283
22,389   20,076   16,031   13,008      17,742   209,507
12,958   22,026   12,807   12,024      18,351   191,226
10,065   19,364   15,655   24,872      17,603   215,466
13,081   12,899   16,897   11,474      13,401   179,109
18,490   21,576   18,439   22,304      10,077   218,923
10,431   18,911   20,899   14,758      13,594   207,813
10,832   20,672   17,868   15,364      13,559   200,115
19,332   10,168   13,897   21,900      17,391   211,980
10,342   11,552   12,517   22,987      13,411   172,296
13,572   21,233   23,036   13,485      24,760   209,128


                               Page 18 of 27
                        Domestic Retail Sales Report
  20,090    17,148    16,510    14,147      12,746   203,568
  24,454    10,228    22,261    22,870      22,206   222,345
  13,000    11,976    21,053    12,740      24,171   203,007
  16,100    22,260    24,267    12,715      10,811   215,613
  13,103    18,595    20,096    14,876      18,604   218,257
  23,777    15,659    17,764    14,981      16,004   202,955
  16,533    16,623    16,623    19,232      18,711   219,589
  19,894    16,406    20,691    23,369      14,805   215,298
  20,842    17,730    19,388    23,490      15,397   210,550
  21,567    20,742    19,876    15,965      10,217   214,850
  14,926    18,318    13,308    15,002      23,552   207,482
  23,703    11,973    12,695    23,675      17,999   187,951
  23,558    22,429    10,019    23,107      22,773   248,272
  21,916    24,830    11,428    13,933      12,271   231,889
  23,256    14,344    19,246    22,069      15,167   191,122
  20,612    16,361    23,782    22,827      17,049   231,776
  18,901    22,018    20,350    21,041      14,367   217,870
  23,438    13,311    21,543    19,857      10,643   231,148
  17,016    21,981    19,251    24,744      14,466   216,092
  20,709    22,326    15,506    10,488      21,920   209,482
  18,525    20,350    23,736    17,041      23,113   220,350
  17,991    16,895    19,833    10,050      20,387   222,370
  11,087    21,182    16,107    21,054      18,007   217,956
  13,236    23,722    21,443    14,233      24,097   214,409
  11,482    14,087    10,785    12,606      13,492   200,553
  20,359    16,211    21,292    17,948      14,741   208,985
  10,295    14,145    12,045    10,384      21,035   189,049
  11,751    23,779    19,623    23,435      19,458   211,725
  12,582    22,570    23,315    10,435      22,578   214,332
  18,873    23,226    23,592    19,002      15,146   222,823


2,651,405 2,604,040 2,652,789 2,653,945 2,646,220 31,746,535




                                    Page 19 of 27
                                           Setup



Widget Retail Sales
Store #   Jan      Feb      Mar      Apr       May      Jun      Jul      Aug      Sep

   100    13,953   20,506   20,825   22,123    16,980   17,158   20,035   16,324   18,990
   101    13,843   15,471   11,760   21,398    21,510   16,027   18,620   12,854   20,475
   102    22,850   13,884   23,657   19,162    19,922   17,459   24,968   18,708   20,598
   103    18,044   24,857   15,186   19,515    13,318   14,847   20,795   10,095   13,975
   104    10,594   13,080   17,848   20,417    18,763   19,849   15,462   11,894   12,947
   105    16,335   12,248   21,674   21,734    24,805   21,144   18,968   22,608   12,531
   106    15,101   12,126   12,318   22,368    24,939   11,687   24,401   12,943   11,601
   107    15,443   19,268   11,919   15,782    12,757   18,530   11,088   20,844   14,243
   108    21,582   17,525   24,629   12,532    20,185   23,186   17,103   17,487   13,170
   109    10,777   20,579   18,513   13,626    17,759   11,349   13,871   21,294   17,655
   110    10,158   21,212   15,389   19,001    21,279   22,486   16,751   17,625   16,719
   111    18,415   21,978   20,310   18,509    14,640   24,402   19,444   14,375   21,237
   112    14,658   13,093   18,826   24,946    24,225   19,453   14,693   19,720   14,996
   113    10,046   11,259   21,845   14,187    22,776   24,336   15,306   11,963   14,615
   114    17,194   16,643   21,045   17,386    22,108   23,355   10,367   20,502   11,251
   115    13,979   15,353   14,472   14,451    19,478   21,712   16,970   19,248   16,389
   116    23,719   19,291   14,100   23,946    15,352   12,457   24,959   12,151   15,854
   117    16,844   13,272   17,305   13,548    10,953   14,712   10,030   10,795   18,586
   118    21,392   23,423   24,484   19,883    12,273   17,588   13,598   24,105   15,502
   119    23,194   22,784   13,954   13,558    22,565   12,937   12,920   11,231   10,440
   120    11,718   14,202   16,776   20,771    14,552   13,593   24,287   18,203   13,100
   121    18,267   19,727   20,602   17,734    22,815   21,070   16,415   19,144   13,468
   122    12,003   21,469   16,246   21,400    14,043   19,034   13,198   22,027   16,934
   123    11,846   20,390   11,799   23,182    11,668   13,933   16,794   18,802   11,223
   124    17,701   13,174   17,784   15,811    12,841   14,754   17,548   14,880   19,056
   125    19,493   23,271   12,132   11,261    18,900   19,044   14,494   17,272   17,248
   126    13,883   18,289   14,563   19,012    24,697   11,379   24,697   20,089   18,472
   127    17,718   11,936   11,376   15,880    21,591   14,613   14,043   16,881   18,038
   128    16,596   23,334   11,966   20,711    11,275   13,115   23,097   24,848   15,679
   129    22,694   12,715   11,527   24,677    20,919   17,992   12,239   12,330   18,835
   130    24,956   14,001   22,190   15,559    12,996   22,139   20,703   10,938   14,657
   131    24,673   13,534   23,780   18,727    15,200   11,557   19,770   12,255   21,833
   132    20,339   15,408   24,736   15,857    21,952   20,317   10,240   12,357   13,031
   133    16,676   13,491   12,089   12,683    24,824   12,260   19,193   10,474   20,606
   134    16,429   15,074   17,952   21,926    22,009   22,029   22,861   10,788   16,514
   135    16,606   13,722   23,700   21,089    13,782   16,626   14,069   24,931   13,493
   136    18,636   13,542   12,821   16,185    17,971   13,153   22,638   23,868   14,541


                                              20
                                          Setup


   137    16,153   18,099   23,623   23,009    15,714   10,735   11,910   19,896   13,940
   138    11,100   19,455   18,284   11,078    10,837   11,036   12,833   24,207   23,760
   139    18,632   23,365   24,796   24,276    15,858   16,965   15,491   13,230   10,024
   140    17,623   15,297   10,872   12,656    14,942   21,079   13,972   19,359   24,981
   141    24,928   11,122   19,012   19,477    14,327   12,121   19,207   13,347   16,280
   142    24,706   24,186   15,584   14,469    13,802   15,307   18,800   12,149   23,765
   143    19,681   16,328   13,005   23,127    21,640   24,949   21,258   12,057   24,505
   144    13,790   24,472   19,117   19,808    24,472   21,252   24,747   15,294   15,959
   145    22,349   13,827   20,946   12,183    18,228   11,421   16,874   21,604   22,085
   146    18,481   12,100   14,085   17,451    16,486   11,682   17,929   23,180   19,261
   147    16,722   19,448   23,433   14,665    18,887   18,288   18,355   20,685   10,789
   148    12,543   13,210   11,077   16,363    11,055   12,745   12,936   18,254   15,986
   149    20,870   11,486   11,655   11,241    17,532   24,081   13,960   20,286   20,659
   150    17,661   11,003   10,292   11,732    23,291   13,815   14,384   21,132   20,775


Totals   883,593 858,529 877,883 912,074 915,695 866,754 879,291 871,532 851,272




                                              21
                                      Setup




Oct      Nov      Dec      TOTALS

14,578   20,926   21,318    223,815
20,077   13,187   19,956    205,280
13,899   21,629   22,966    239,803
21,320   17,610   21,850    211,514
24,055   14,217   11,598    190,827
14,919   22,696   17,727    227,495
15,053   13,886   16,569    193,098
15,143   20,776   16,147    192,047
19,099   22,250   21,163    230,019
17,037   17,521   12,897    192,986
12,251   22,979   11,997    207,958
20,939   15,343   14,576    224,279
11,918   11,227   22,362    210,230
19,041   22,389   15,645    203,520
18,082   10,290   15,332    203,670
12,404   13,307   20,711    198,590
10,796   15,396   22,596    210,733
16,866   17,962   16,319    177,309
19,975   12,291   16,314    220,947
15,239   12,789   12,091    183,821
12,378   11,673   21,584    192,958
18,416   17,029   12,086    216,894
12,805   22,927   10,024    202,233
13,991   13,876   10,578    178,206
12,586   13,323   21,057    190,639
22,067   18,344   19,260    212,911
24,694   24,424   23,612    237,937
20,972   22,897   16,316    202,388
13,604   19,902   19,286    213,540
19,278   11,350   10,476    195,162
24,799   15,081   10,701    208,849
24,054   10,095   11,299    206,910
23,060   10,683   11,121    199,232
13,614   13,022   19,300    188,365
16,416   10,335   21,695    214,164
13,699   24,075   18,818    214,743
17,131   13,416   23,285    207,324


                                       22
                                      Setup


 19,315   14,316   14,551   201,397
 15,311   20,552   10,524   189,115
 19,589   21,049   20,250   223,666
 10,091   10,580   24,532   196,125
 13,014   17,575   10,876   191,427
 24,137   16,947   22,558   226,554
 13,208   20,101   20,189   230,190
 18,255   10,325   11,731   219,367
 17,680   17,917   10,778   206,036
 18,923   19,602   22,100   211,427
 23,797   17,426   12,450   215,092
 14,601   23,051   12,759   174,728
 11,132   14,120   17,387   194,557
 24,466   17,929   19,617   206,247


879,775 852,614 860,938 10,516,324




                                       23
                                        Names



FirstName   LastName     Address         City      State    Zip

Karen       Davis      831 Main      Fremont       CA      94555
Aaron       Olson      410 Aspen     Portland      OR      97007
Bonnie      Boldon     111 Ash       Sparta        WI      54656
Chris       Davis      831 Main      Fremont       CA      94555
Don         Wilson     645 Spruce    Sparta        IL      62286
Lynn        Marshall   415 Spring    Portland      OR      97011
Patrick     Hanson     319 Clark     Chicago       IL      60657
Arlene      Johnson    806 Ridge     Evanston      IL      60202
Amber       Olson      410 Aspen     Portland      OR      97007
Ronald      Link       201 Court     Sparta        GA      31087
Robert      Davis      705 Lark      Fremont       CA      94555
Lois        Martin     910 Oak       San Leandro   CA      94577
Mark        Larson     602 Maple     San Diego     CA      92111
Donna       Johnson    806 Ridge     Evanston      IL      60202
Robert      Davis      910 Elm       Sparta        NC      28675
Christa     Davis      831 Main      Fremont       CA      94555
Leslie      Owens      202 Adams     Ventura       CA      93003
Linda       Jones      551 Cedar     Sparta        NJ      07871
Winston     Larson     602 Maple     San Diego     CA      92131
Karen       Thomas     1701 Main     Hayward       CA      94545
Steven      Zoppi      551 Central   Evanston      IL      60201
Robert E.   Davis      770 Spruce    Sparta        MI      49345
Pat         Owens      202 Adams     Ventura       CA      93003
Roger       Jones      465 Elder     East Sparta   OH      44626
Gary        Davis      831 Main      Fremont       CA      94555
Dennis      Olson      410 Aspen     Portland      OR      97007
Christy     Boldon     111 Ash       Sparta        WI      54656
Paul        Davis      831 Main      Fremont       CA      94555
Ken         Wilson     645 Spruce    Sparta        IL      62286
Paula       Marshall   415 Spring    Portland      OR      97011
Margaret    Hanson     319 Clark     Chicago       IL      60657
Lana        Johnson    806 Ridge     Evanston      IL      60202
Karley      Olson      410 Aspen     Portland      OR      97007
Hollis      Link       201 Court     Sparta        GA      31087




                                       Page 24
                            7acaba59-8e45-4a9c-9e57-f6d608b198d5.xlsx




Student Test Scores
                   Test 1      Test 2   Test 3    Test 4   Test 5   High   Low   Avg.


       Student 1   92%         94%      95%        88%      90%
       Student 2   88%         90%      92%        94%      96%
       Student 3   95%         92%      90%        95%      94%
       Student 4   82%         86%      84%        88%      85%
       Student 5   75%         78%      80%        82%      80%
       Student 6   98%        100%      96%        95%     100%

     High Scores
     Low Scores
  Average Scores




                                                 Page 25
Student      Score   Grade
Student 1     92
Student 2     88
Student 3     98
Student 4     79
Student 5     74
Student 6     85
Student 7     60
Student 8     82
Student 9     58
Student 10    75


              Grade Table
              0        F
              60       D-
              65       D
              70       C-
              75       C
              80       B-
              85       B
              90       A-
              95       A
                                             Checking



Checking Account Transaction Register

  Date     Chk No. Transaction Description    Debit (-)   Credit (+)   Balance

                           Opening Balance                             $1,250.00
########    101    Macys                         $85.00    $135.00
########    102    Nordstrom                    $115.00
########    103    PG&E                         $145.12
########    104    GMAC                         $295.50
########    105    Nationwide Mortgage        $1,255.00
########           Deposit
            106




    Create a formula in G5 that will display your current balance after each
 transaction. Your formula should pick up the previous balance, subtract any
              checks written (debits), and then add any deposits.




                                             Page 27

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:22
posted:1/2/2011
language:English
pages:27