Spreadsheet: 485919d1477170630-data-sorting-need-help-wiith-layout-text-to-column-doesnt-work-test-data-example
Sheet: 03 14 16 TO 03 20 16 

=======>1
Weekly Store Sales Report : Store # 1       Period   3  Week  11
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales    Base
Small   75  100  119  119   0   56   60 11.21   4-11.30  45.20- 672.60   627.40
Mediu  100- 900  123  123   0  677  770  7.36  93- 9.50 883.50-5667.20  4783.70
Large  206  600  367  367   0  439  466 13.65  27-16.00 432.00-6360.90  5928.90
Famil  242  350  352  352   0  240  248 13.87   8-17.65 141.20-3439.76  3298.56
Party   34   20   34   34   0   20   19 24.70   1 22.55  22.55  469.30   491.85
Half    39  100  109  109   0   30   30  6.03   0  5.99   0.00  180.90   180.90
GOURM   13   50   55   55   0    8    8  5.69   0  5.99   0.00   45.52    45.52
Slice  480  500 1005 1005   0   25- 417  3.84 442- 3.951745.90-1601.28   144.62-
Pop   2490 2448 2556 2556   0 2382 2250  0.19 132  0.69  91.08  427.50   518.58
Sprin   69   24   88   88   0    5   32  1.37  27- 1.50  40.50-  43.84     3.34
600 M  123   48   97   97   0   74   46  1.87  28  1.75  49.00   86.02   135.02
Juice   90   12   75   75   0   27   35  2.02   8- 2.00  16.00-  70.70    54.70
Milk    23   24   21   21   0   26   19  1.70   7  1.60  11.20   32.30    43.50
Power   11    0   29   29   0   18-   6  1.99  24- 0.00   0.00   11.94    11.94
Monst    6    0    2    2   0    4    1  3.19   3  3.00   9.00    3.19    12.19
Salad  106    0  112  112   0    6-  11  7.24  17- 6.50 110.50-  79.64    30.86-
Side   144    0    0  123   0   21   21  0.90   0  3.50   0.00   18.90    18.90
6 Pie  149  350  215  215   0  284  229  4.73  55  7.50 412.50 1083.17  1495.67
20 Pi  152  150  251  251   0   51   77  6.17  26- 8.50 221.00- 475.09   254.09
Snack    9-   0    0   13-  0    4    4  6.49   0  5.99   0.00   25.96    25.96
Pasta   16   12    0   15   0   13   13  7.99   0  6.99   0.00  103.87   103.87
Foil   194-   0    0  201-  0    7    7  5.99   0  4.50   0.00   41.93    41.93
Brown   45   24    0   21   0   48   48  2.99   0  3.00   0.00  143.52   143.52
Pouti  386    0  256  256   0  130   68  4.20  62  4.00 248.00  285.60   533.60
Reg.   109  500  610  610   0    1-  20  0.39  21- 1.00  21.00-   7.80    13.20-
$1 DE    0    0    0    0 174  174    0  0.88 174  0.88 153.12    0.00   153.12
Deliv    0    0    0    0 516  516    0  3.50   0  3.50   0.00 1806.00  1806.00
Chips  231    0    0  160   0   71   71  0.34   0  0.49   0.00   24.14    24.14
Large   27    0    0   22   0    5    5  3.00   0  3.00   0.00   15.00    15.00
Prepa  599 1632  498  498   0 1733 1435  0.61 298  0.69 205.62  875.35  1080.97
-------  -------  --------
Totals 5562 7844 6974 [PHONE] 6416         63    -2454.73 24098.92 21644.19
-------  -------  -------
TOTAL SALES                                           -2454.73 24098.92 21644.19
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
----------
GROSS SALES                                                            21644.19
Debit Fee                                                            (  153.12)
Coupons                                                              (    0.00)
Free Pizza                                                           (    0.00)
Promotions/Discounts                                                 (   78.62)
----------
NET SALES                                                             21412.45
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          65    51    57    92    95     80    78      518
Pick Up              8    14    12    14    14     17    12       91
Complaints           2     1     1     2     0      0     0        6
Total               75    66    69   108   109     97    90      615
=========>212     INC
03/14/16 TO 03/20/16         STORE:  1
PERIOD    3 WEEK  11        WEEKLY STATEMENT                 a
..........COMMISSARY CHARGES                             NET-INVOICE    QST     GST/HST
u43792                      16/03/15                         3096.23              70.94
u55357                      16/03/17                         4118.63             180.74
u56108                      16/03/19                         3248.88              25.01
Total Commissary 10463.74             276.69
..........DIRECT CHARGES
558791    00131             16/03/20 BELL CANADA              151.45              19.69
559231    00138             16/03/20 NORAXX INSPECTIONS       174.00              22.62
559851    00140             16/03/20 ABELL PEST CONTROL INC    30.89               4.02
560153    00142             16/03/20 SANIMAX LTD.              15.00-              1.95-
Total Direct   341.34              44.38
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         16/03/20 u62267                  1277.00             166.01
ADVERTISING-DELIVERY CHARGE 16/03/20 u58003                   257.00              33.41
ADVERTISING - NATIONAL      16/03/20 u62268                   211.54              27.50
ADVERTISING - DIVISIONAL    16/03/20 u62269                  1057.72             137.50
ORDER PROCESSING CHARGE     16/03/20 u58325                   852.60             110.84
GST/HST ON SALES            16/03/20 u63689                  3093.92
AX TD   032016              16/03/20 u61080                     4.74               0.62
DB TD   032016              16/03/20 u61081                    14.00               1.82
MC TD   032016              16/03/20 u61082                    56.93               7.40
VI TD   032016              16/03/20 u61083                   100.11              13.01
INSURANCE                   16/03/20 u64302                    24.47
PROMI                       16/03/20 u64571                    10.14
PROMI                       16/03/20 u64572                   203.77
PROMI                       16/03/20 u64573                   201.54
PROMP                       16/03/20 u64692                    84.86
RENO CONT                   16/03/20 u64865                   400.00
FEES IT ELRN                16/03/20 u65399                     1.50
FEES IT SUPPOR              16/03/20 u65400                     8.75
RENT WEEKLY                 16/03/20 u65957                  1690.36
FEES GIVEX                  16/03/20 u66272                     2.75               0.36
FEES TD EQUIP               16/03/20 u66679                    81.23              10.56
OPD FEE PU                  16/03/20 u67109                     2.50               0.33
OPD FEE ADJ                 16/03/20 u67449                     7.00-              0.91-
OPD CR#222                  16/03/20 u67688                    15.24
OPD CR#222                  16/03/20 u67689                    10.00
CCREDEEM WK11               16/03/20 u68562                   221.04-
LYREDEEMWK11                16/03/20 u68925                     8.21-
Total General Office  9426.42             508.45
Total Weekly Charges 21061.02
..........PAYMENTS & CREDITS
GST TAX CREDIT              16/03/20 u75502                   829.52-
COMPUTER ROOM CREDIT        16/03/20 u72367                    12.45-
AX TD   032016              16/03/20 u73695                   135.43-
DB TD   032016              16/03/20 u73696                  9883.95-
MC TD   032016              16/03/20 u73697                  2846.37-
VI TD   032016              16/03/20 u73698                  5133.87-
HST ON CANCELL              16/03/20 u74714                     1.96-
CCREDEEM 03201              16/03/20 u74952                   101.14-
Direct Deposit              16/03/16  MAR 16                 2267.15-
Direct Deposit              16/03/20  MAR 22                  300.00-
Total Payments/Credits 21511.84-
PREVIOUS BALANCE        2267.15
TOTAL CHARGES        21061.02
TOTAL CREDITS        21511.84-
BALANCE OUTSTANDING   1816.33
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
12.45                         12.45      0.00                          0.00
The Current Renovation Value is 45833.67
09/29/02     0.00