Spreadsheet: 485919d1477170630-data-sorting-need-help-wiith-layout-text-to-column-doesnt-work-test-data-example
Sheet: 03 04 13 TO 03 10 13     

=======>1
Weekly Store Sales Report : Store # 1       Period   3  Week  10
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales   Base
Small    35  100   55   55  10-  70   68 10.83   2 11.00  22.00  736.44  758.44
Medium  568  500  397  397  15- 656  657  8.06   1- 9.25   9.25-5295.42 5286.17
Large   595  500  522  596   0  499  499 13.69   0 14.94   0.00 6831.31 6831.31
Family  404   50  256  256  10- 188  187 14.98   1 16.50  16.50 2801.26 2817.76
Party    18   20   35   35   0    3    3 21.32   0 22.50   0.00   63.96   63.96
[NAME]   0    0  471-  0   31   31  5.62   0  5.50   0.00  174.22  174.22
GOURME   89    0    0   69   0   20   20  5.44   0  5.50   0.00  108.80  108.80
Slice   831    0  434  434   0  397  363  3.90  34  3.95 134.30 1415.70 1550.00
Pop    2925 2256 2401 [PHONE] 2530  0.11   0  0.69   0.00  278.30  278.30
Spring   65   24   68   68   0   21   23  1.18   2- 1.50   3.00-  27.14   24.14
600 ML  117   24  129  129   0   12   34  1.31  22- 1.75  38.50-  44.54    6.04
Juice    83   72  111  111   0   44   40  1.15   4  2.00   8.00   46.00   54.00
Milk 5   16   12    3    3   0   25   23  0.76   2  1.60   3.20   17.48   20.68
Powera   12    0    3    3   0    9    6  1.66   3  0.00   0.00    9.96    9.96
Monste    4   24   23   23   0    5    5  0.64   0  3.00   0.00    3.20    3.20
Salad   102    0   85   85   0   17   13  5.80   4  6.00  24.00   75.40   99.40
Salad     0    0    0    2-  0    2    2 19.99   0  0.00   0.00   39.98   39.98
Side S  326    0    0  314   0   12   12  1.70   0  3.00   0.00   20.40   20.40
6 Piec   77  200  152  152  45  170  174  2.86   4- 7.50  30.00- 497.64  467.64
20 Pie  244   50  151  151  70-  73   62  7.55  11  8.50  93.50  468.10  561.60
Snack    22-   0    0   25-  0    3    3  5.66   0  5.99   0.00   16.98   16.98
Half M   69   50   49   90   0   29   29  4.39   0  4.50   0.00  127.31  127.31
Pasta    29   16    0   37   0    8    8  6.99   0  0.00   0.00   55.92   55.92
Foil W  365    0    0  357   0    8    8  5.40   0  4.50   0.00   43.20   43.20
Cheese    1   12    1    1   0   12    8  3.99   4  0.00   0.00   31.92   31.92
Apple   274    0    0  258   0   16   16  0.99   0  1.00   0.00   15.84   15.84
Browni   69   24    0   88   0    5    5  2.99   0  3.00   0.00   14.95   14.95
Poutin  292    0    0  241   0   51   51  3.91   0  3.00   0.00  199.41  199.41
Reg. F  460    0  445  445   0   15   22  0.61   7- 1.00   7.00-  13.42    6.42
Delive    0    0    0    0 554  554    0  3.50   0  3.25   0.00 1800.50 1800.50
Chips    87   48    0  124   0   11   11  0.45   0  0.49   0.00    4.95    4.95
Large    11-   0    0   13-  0    2    2  3.00   0  0.00   0.00    6.00    6.00
Prepak 5610 1608 5100 [PHONE] 1340  0.36  78  0.69  53.82  482.40  536.22
------ ------- --------
Totals 132945590 [PHONE]-6916 6255       107      267.57 21768.05 22035.62
------ ------- --------
TOTAL SALES                                            267.57 21768.05 22035.62
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
---------
GROSS SALES                                                            22035.62
Ret/Damaged                                                           (   0.00)
[NAME](   0.00)
Free Pizza                                                            (  15.68)
Promotions/Discounts                                                  (  26.29)
---------
NET SALES                                                              21993.65
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          57    64    63    75   111     86    64      520
Pick Up              7    10    16     9    26     22     9       99
Complaints           1     1     0     2     0      0     1        5
Total               65    75    79    86   137    108    74      624
=========>1     INC
03/04/13 TO 03/10/13          STORE:  1
PERIOD    3 WEEK  10        WEEKLY STATEMENT                   a
..........COMMISSARY CHARGES                             NET-INVOICE    GST/HST
a12472                      13/03/05                         2777.45      67.77
a23330                      13/03/07                         3303.45     160.55
a24032                      13/03/09                         3497.74      18.82
Total Commissary  9578.64     247.14
..........DIRECT CHARGES
125973    00136             13/03/10 OTTAWA HYDRO            2658.93     345.66
126232    00139             13/03/10 ABELL PEST CONTROL INC    30.89       4.02
127059    00145             13/03/10 MINDSHARE TECHNOLOGIES    36.00       4.68
127493    00147             13/03/10 ROGERS BUSINESS SOLUTI    53.65       6.97
Total Direct  2779.47     361.33
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         13/03/10 a28580                  1327.92     172.63
ADVERTISING-DELIVERY CHARGE 13/03/10 a25230                   274.00      35.62
ADVERTISING - NATIONAL      13/03/10 a28581                   219.93      28.59
ADVERTISING - DIVISIONAL    13/03/10 a28582                  1099.68     142.96
ORDER PROCESSING CHARGE     13/03/10 a25526                   897.55     116.68
GST/HST ON SALES            13/03/10 a34335                  2804.57
INSURANCE                   13/03/10 a29755                    21.22       2.76
RENO CONT                   13/03/10 a30341                   400.00
FEES IT ELRN                13/03/10 a30788                     1.50
FEES IT SUPPRT              13/03/10 a30789                     8.75
RENT WEEKLY                 13/03/10 a31318                  1701.46
FEES BNA A W10              13/03/10 a31608                    14.95       1.94
FEES BNA L W10              13/03/10 a31986                    46.62       6.06
OPD FEE PU                  13/03/10 a32565                     2.00       0.26
OPD FEE ADJ                 13/03/10 a32901                     5.80-      0.75-
CCLOAD WK10                 13/03/10 a33144                    20.00
CCREDEEM WK10               13/03/10 a33420                   123.57-
OPD CR#278                  13/03/10 a33689                     7.76
OPD DR#208                  13/03/10 a33829                    25.05-
AMEX BNA031013              13/03/10 a35470                     7.80       1.01
DEBIT   031013              13/03/10 a35471                    22.09       2.87
MASTER B031013              13/03/10 a35472                    42.47       5.52
VISA BNA031013              13/03/10 a35473                    92.43      12.02
Total General Office  8858.28     528.17
Total Weekly Charges 22353.03
..........PAYMENTS & CREDITS
GST TAX CREDIT              13/03/10 a73707                  1136.64-
COMPUTER ROOM CREDIT        13/03/10 a70409                    99.67-
CATER 20130310              13/03/10 a71224                   552.84-
CATER 20130310              13/03/10 a71594                    70.59-
AMEX BNA031013              13/03/10 a72866                   222.98-
DEBIT   031013              13/03/10 a72867                  8065.64-
MASTER B031013              13/03/10 a72868                  1846.55-
VISA BNA031013              13/03/10 a72869                  4018.83-
Direct Deposit              13/03/10  MAR11                  1600.00-
Direct Deposit              13/03/10  MAR12                  4739.29-
Total Payments/Credits 22353.03-
PREVIOUS BALANCE           0.00
TOTAL CHARGES        22353.03
TOTAL CREDITS        22353.03-
BALANCE OUTSTANDING      0.00
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
99.67                         99.67     15.68                         15.68
The Current Renovation Value is  2242.83
09/29/02     0.00