Spreadsheet: 485919d1477170630-data-sorting-need-help-wiith-layout-text-to-column-doesnt-work-test-data-example
Sheet: 01 24 11 TO 01 30 11     

=======>1
Weekly Store Sales Report : Store # 1       Period   1  Week   4
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales   Base
Small   103    0   57   57   0   46   44  9.92   2 11.00  22.00  436.48  458.48
Medium  861  500  706  706  57- 598  598  7.71   0  8.25   0.00 4610.58 4610.58
Large   741  200  549  549  10- 382  382 14.06   0 14.94   0.00 5370.92 5370.92
Family  179  150  127  127   9  211  211 14.29   0 15.50   0.00 3015.19 3015.19
Party    37    0   39   39  13   11   11 19.36   0 22.50   0.00  1.96  1.96
Stuffe   69    0    0   31   0   38   38  3.59   0  4.70   0.00  136.42  136.42
Slice  1055  500  100 1039   0  516  515  3.60   1  3.95   3.95 1854.00 1857.95
Pop    2480 1488 2492 2492   0 1476 1438  0.35  38  0.69  26.22  503.30  529.52
Spring   22   48    0   56   0   14   14  1.36   0  1.50   0.00   19.04   19.04
600 ML  126   72   72   72  76-  50   50  1.69   0  1.75   0.00   84.50   84.50
Juice    36   60   80   80  22   38   38  1.81   0  2.00   0.00   68.78   68.78
Milk 5   24   36   22   22   0   38   37  1.46   1  1.60   1.60   54.02   55.62
Powera   47   24   56   56   0   15   12  1.66   3  0.00   0.00   19.92   19.92
Monste   11    0    4    4   0    7    2  1.60   5  3.00  15.00    3.20   18.20
Salad   470    0  375  375  82-  13   13  5.37   0  6.00   0.00   69.81   69.81
Side S  120    0    0  116   0    4    4  3.49   0  3.00   0.00   13.96   13.96
6 Piec   14  250   14   14  13  263  263  4.11   0  7.50   0.00 1080.93 1080.93
20 Pie  114   50   84   84   9   89   89  7.15   0  8.50   0.00  636.35  636.35
SNACK   335    0    0  318   0   17   17  5.25   0  5.45   0.00   89.25   89.25
Half M   80    0    0    1   0   79   79  3.39   0  3.25   0.00  267.81  267.81
Square   28-   0    0   37-  0    9    9  1.69   0  2.10   0.00   15.21   15.21
Apple    82    0    0   69   0   13   13  0.76   0  1.00   0.00    9.88    9.88
Browni   39    0    0   28   0   11   11  2.99   0  3.00   0.00   32.89   32.89
POPPER  289    0    0  282   0    7    7  2.92   0  2.70   0.00   20.44   20.44
Poutin  211    0  168  168   0   43   26  3.23  17  3.50  59.50   83.98  143.48
Reg. F  760    0    0  712   0   48   48  0.47   0  1.00   0.00   22.56   22.56
Delive    0    0    0    0 564  564    0  3.50   0  3.25   0.00 1833.00 1833.00
Chips    50  120  250  250   0   80-  20  0.15 100- 0.49  49.00-   3.00   46.00-
Prepak 2070 1656  935 2400   0 1326 1315  0.52  11  0.69   7.59  683.80  691.39
------ ------- --------
Totals [PHONE] [PHONE] 5304        22-      86.86 152.18 21339.04
------ ------- --------
TOTAL SALES                                             86.86 152.18 21339.04
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
---------
GROSS SALES                                                            21339.04
Ret/Damaged                                                           (   0.00)
[NAME](   0.00)
Free Pizza                                                            (  64.12)
Promotions/Discounts                                                  (  20.79)
---------
NET SALES                                                              154.13
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          59    69    51    75   111     91    75      531
Pick Up              6     6    10    20    22     25    16      105
Complaints           1     1     2     1     1      1     1        8
Total               66    76    62    96   134    117    92      644
=========>1    INC
01/24/11 TO 01/30/11          STORE:  1
PERIOD    1 WEEK   4        WEEKLY STATEMENT                   a
..........COMMISSARY CHARGES                             NET-INVOICE    GST/HST
M86105                      11/01/25                         2650.24      23.15
M96450                      11/01/27                         3267.99     121.65
[NAME]11/01/28                           25.10
M97250                      11/01/29                         3066.85      40.05
Total Commissary  9010.18     184.85
..........DIRECT CHARGES
=00070    00055             11/01/30 G & K SERVICES CANADA     45.48
=99738    00052             11/01/30 GOODWIN & ASSOCIATES,     29.00
Total Direct    74.48
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         11/01/30 N02095                  1283.70     166.88
ADVERTISING-DELIVERY CHARGE 11/01/30 M98123                   262.00      34.06
ADVERTISING - NATIONAL      11/01/30 N02096                   1.54      27.63
ADVERTISING - DIVISIONAL    11/01/30 N02097                  1062.70     138.15
ORDER PROCESSING CHARGE     11/01/30 M98491                   954.00     124.02
VISA FEE                    11/01/30 M98976                     0.56       0.07
GST/HST ON SALES            11/01/30 N06371                  2726.25
RENO CONS SUPP              11/01/26 M96817                  1445.27     187.89
CCLOAD  013011              11/01/30 M00907                    12.00
CCREDEEM013011              11/01/30 M00908                   128.19-
OPD CR#207                  11/01/30 M01178                     4.25
OPD FEE PU                  11/01/30 M01475                     2.50       0.33
OPD FEE ADJ                 11/01/30 M01807                     7.50-      0.98-
AMEX BNA020111              11/01/30 N00788                    10.99       1.43
DEBIT   020111              11/01/30 N00789                    21.07       2.74
MASTER B020111              11/01/30 N00790                    28.67       3.73
VISA BNA020111              11/01/30 N00791                    73.10       9.50
INSURANCE                   11/01/30 N03248                    26.00       3.38
FEES IT ELRN                11/01/30 N04293                     1.50
FEES IT SUPPOR              11/01/30 N04294                     6.50
RENT WEEKLY                 11/01/30 N04765                  1751.58
FEES BNA A W04              11/01/30 N05046                    25.20       3.28
FEES BNA L W04              11/01/30 N05422                    82.93      10.78
Total General Office  9857.62     712.89
Total Weekly Charges 19840.02
..........PAYMENTS & CREDITS
VISA CREDIT                 11/01/30 M04666                    25.41-
GST TAX CREDIT              11/01/30 N07246                   897.74-
COMPUTER ROOM CREDIT        11/01/30 M04297                    36.56-
AMEX BNA020111              11/01/30 N06170                   313.89-
DEBIT   020111              11/01/30 N06171                  7453.45-
MASTER B020111              11/01/30 N06172                  1246.28-
VISA BNA020111              11/01/30 N06173                  3177.96-
RENO M96817                 11/01/30 N07077                  1445.27-
Direct Deposit              11/01/30  JAN 31                 1200.00-
Direct Deposit              11/01/30  FEB 01                 4000.00-
Total Payments/Credits 19796.56-
PREVIOUS BALANCE           0.00
TOTAL CHARGES        19840.02
TOTAL CREDITS        19796.56-
BALANCE OUTSTANDING     43.46
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
36.56                         36.56     64.12                         64.12
The Current Renovation Value is 29132.55
09/29/02     0.00