Spreadsheet: 485919d1477170630-data-sorting-need-help-wiith-layout-text-to-column-doesnt-work-test-data-example
Sheet: 02 02 15 TO 02 08 15

=======>1
Weekly Store Sales Report : Store # 1       Period   2  Week   6
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales    Base
Small   52  100   73   73   0   79   74  9.71   5 11.00  55.00  718.54   773.54
Mediu  652  600  544  544  30- 678  678  8.53   0  9.25   0.00 5783.34  5783.34
Large  729  300  585  585   0  444  421 14.47  23 14.94 343.62 6091.87  6435.49
Famil  396  150  314  314  20- 212  212 14.24   0 16.50   0.00 3018.88  3018.88
Party   29   40   26   26  15-  28   26 22.33   2 22.50  45.00  580.58   625.58
Stuff   27-   0    0   68-  0   41   41  5.69   0  5.50   0.00  233.29   233.29
GOURM   35    0   35   35   0    0    6  5.49   6- 5.50  33.00-  32.94     0.06-
Slice  363 1000  210  960   0  403  391  4.04  12  3.95  47.40 1579.64  1627.04
Pop   2906 2376 2786 2786   0 2496 2487  0.14   9  0.69   6.21  348.18   354.39
Sprin  120    0   48   48   0   72   15  1.24  57  1.50  85.50   18.60   104.10
600 M  207   24  137  137   0   94   42  1.70  52  1.75  91.00   71.40   162.40
Juice   93    0   67   67   0   26   21  1.81   5  2.00  10.00   38.01    48.01
Milk    51   12   55   55   0    8   28  1.09  20- 1.60  32.00-  30.52     1.48-
Power   18   24   42   42   0    0    4  1.49   4- 0.00   0.00    5.96     5.96
Monst   14   12   22   22   0    4    5  1.91   1- 3.00   3.00-   9.55     6.55
Salad   93    0   58   58   0   35   14  5.81  21  6.00 126.00   81.34   207.34
Side   179    0    0  165   0   14   14  1.14   0  3.00   0.00   15.96    15.96
6 Pie  147  200   59  119   0  228  228  3.99   0  7.50   0.00  909.72   909.72
20 Pi  162    0   84   84   0   78   87  7.27   9- 8.50  76.50- 632.49   555.99
Half    62   50   97   97   0   15   19  4.99   4- 4.50  18.00-  94.81    76.81
Pasta   82    8    0   70   0   20   12  6.99   8  6.99  55.92   83.88   139.80
Foil    85-   0    0   96-  0   11   11  5.44   0  4.50   0.00   59.84    59.84
Chees  139   24    0  133   0   30    6  4.99  24  0.00   0.00   29.94    29.94
Apple  476   60    0  451   0   85   25  0.99  60  1.00  60.00   24.75    84.75
Brown   29   24    0   11   0   42   18  2.99  24  3.00  72.00   53.82   125.82
Pouti  209  480  564  564  55-  70   69  4.11   1  3.00   3.00  283.59   286.59
[NAME].   110  500  582  582   0   28   58  0.11  30- 1.00  30.00-   6.38    23.62-
$1 DE    0    0    0    0 200  200    0  0.88 200  0.88 176.00    0.00   176.00
Deliv    0    0    0    0 635  635    0  3.50   0  3.50   0.00 2222.50  2222.50
Chips   51-  88    0   68-  0  105   17  0.41  88  0.49  43.12    6.97    50.09
Large    2-   9    0   12-  0   19   10  3.00   9  3.00  27.00   30.00    57.00
[NAME] 1360 1884 2500 [PHONE] 1469  0.55  25- 0.69  17.25- 807.95   790.70
-------  -------  --------
Totals 8548 7965 8888 [PHONE] 6508        501     1037.02 23905.24 24942.26
-------  -------  -------
TOTAL SALES                                            1037.02 23905.24 24942.26
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
----------
GROSS SALES                                                            24942.26
Debit Fee                                                            (  176.00)
Coupons                                                              (    0.00)
Free Pizza                                                           (   23.99)
Promotions/Discounts                                                 (    0.00)
----------
NET SALES                                                             24742.27
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          73    60    79    84   124    117   103      640
Pick Up             13    11    10    13    16     22    15      100
Complaints           1     2     1     0     1      1     1        7
Total               87    73    90    97   141    140   119      747
=========> '2     INC
02/02/15 TO 02/08/15      STORE:  1
PERIOD    2 WEEK   6        WEEKLY STATEMENT
..........COMMISSARY CHARGES                             NET-INVOICE    QST     GST/HST
m64026                      15/02/03                         2825.82              59.12
m75879                      15/02/05                         3180.80             154.40
m76801                      15/02/07                         3054.51              57.35
Total Commissary  9061.13             270.87
..........DIRECT CHARGES
=79009    00066             15/02/08 ROGERS BUSINESS SOLUTI    53.65               6.97
Total Direct    53.65               6.97
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         15/02/08 m81461                  1475.01             191.75
ADVERTISING-DELIVERY CHARGE 15/02/08 m78061                   315.00              40.95
ADVERTISING - NATIONAL      15/02/08 m81462                   244.24              31.75
ADVERTISING - DIVISIONAL    15/02/08 m81463                  1221.23             158.76
ORDER PROCESSING CHARGE     15/02/08 m78379                  1073.00             139.49
GST/HST ON SALES            15/02/08 m82864                  3084.39
AX TD   020815              15/02/08 m80155                     3.68               0.48
DB TD   020815              15/02/08 m80156                    12.80               1.66
MC TD   020815              15/02/08 m80157                    39.40               5.12
VI TD   020815              15/02/08 m80158                   116.30              15.12
INSURANCE                   15/02/08 m83470                    21.22
RENO CONT                   15/02/08 m83989                   400.00
FEES IT ELRN                15/02/08 m84489                     1.50
FEES IT SUPPOR              15/02/08 m84490                     8.75
A/REC OTHER                 15/02/08 m84491                   113.85
RENT WEEKLY                 15/02/08 m85057                  1684.56
FEES GIVEX                  15/02/08 m85374                     2.75               0.36
CCREDEEM WK06               15/02/08 m85954                   143.47-
FEES TD EQUIP               15/02/08 m86696                    81.23              10.56
OPD FEE PU                  15/02/08 m87096                     3.50               0.46
OPD FEE ADJ                 15/02/08 m87447                    10.15-              1.32-
Total General Office  9748.79             595.14
Total Weekly Charges 19736.55
..........PAYMENTS & CREDITS
GST TAX CREDIT              15/02/08 m28659                   872.98-
COMPUTER ROOM CREDIT        15/02/08 m25436                    18.46-
AX TD   020815              15/02/08 m27145                   104.91-
DB TD   020815              15/02/08 m27146                  9585.63-
MC TD   020815              15/02/08 m27147                  1969.81-
VI TD   020815              15/02/08 m27148                  5963.93-
CCREDEEM 02081              15/02/08 m28061                    18.20-
CCREDEEM 02081              15/02/08 m28062                    23.15-
CCREDEEM 02081              15/02/08 m28063                    19.76-
Direct Deposit              15/02/05  FEB04                   602.63-
Direct Deposit              15/02/08  FEB10                  1159.72-
Total Payments/Credits 20339.18-
PREVIOUS BALANCE         602.63
TOTAL CHARGES        19736.55
TOTAL CREDITS        20339.18-
BALANCE OUTSTANDING      0.00
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
18.46                         18.46     23.99                         23.99
The Current Renovation Value is 17187.01
09/29/02     0.00