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

=======>1
Weekly Store Sales Report : Store # 1       Period   1  Week   3
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales    Base
Small   71   50   59   59   0   62   57 10.01   5 11.00  55.00  570.57   625.57
Mediu  200  900  325  325   0  775  707  7.09  68  9.25 629.00 5012.63  5641.63
Large  420  450  435  435   0  435  404 13.70  31 14.94 463.14 5534.80  5997.94
[NAME]   0  210  191 13.29  19 16.50 313.50 2538.39  2851.89
Party   34   20   32   32   0   22   24 24.01   2-22.50  45.00- 576.24   531.24
Half    74   50   86   86   0   38   45  6.44   7- 4.50  31.50- 289.80   258.30
GOURM   73    0   41   41   0   32    3  6.32  29  5.50 159.50   18.96   178.46
Slice  449  500  770  770   0  179  413  3.93 234- 3.95 924.30-1623.09   698.79
Pop   2979 1488 2077 2077   0 2390 1994  0.21 396  0.69 273.24  418.74   691.98
Sprin   34    0   50   50   0   16-  30  1.58  46- 1.50  69.00-  47.40    21.60-
600 M  155    0   61   61   0   94   44  1.55  50  1.75  87.50   68.20   155.70
Juice   84   72  102  102   0   54   37  2.02  17  2.00  34.00   74.74   108.74
Milk    28    0   11   11   0   17   15  1.67   2  1.60   3.20   25.05    28.25
Power   10   24   24   24   0   10    1  1.99   9  0.00   0.00    1.99     1.99
Monst    4   12   10   10   0    6    5  3.19   1  3.00   3.00   15.95    18.95
Salad   60    0   55   55   0    5    7  7.53   2- 6.00  12.00-  52.71    40.71
Side   304    0    0  290   0   14   14  1.39   0  3.00   0.00   19.46    19.46
6 Pie  100  250   75   75   0  275  234  4.79  41  7.50 307.50 1120.86  1428.36
20 Pi  205   50  200  200   0   55   86  8.65  31- 8.50 263.50- 743.90   480.40
Snack   10    0    0    8   0    2    2  5.99   0  5.99   0.00   11.98    11.98
Squar    1-   0    0    0   0    1-   0  1.99   1- 1.69   1.69-   0.00     1.69-
Pasta    2   12    0    3   0   11   11  7.99   0  6.99   0.00   87.89    87.89
Foil   130-   0    0  135-  0    5    5  5.19   0  4.50   0.00   25.95    25.95
Brown   22   24    0   14   0   32   32  2.99   0  3.00   0.00   95.68    95.68
Pouti  906    0  699  699   0  207   68  4.18 139  3.00 417.00  284.24   701.24
Reg.   350    0  339  339   0   11   31  0.25  20- 1.00  20.00-   7.75    12.25-
$1 DE    0    0    0    0 190  190    0  0.88 190  0.88 167.20    0.00   167.20
Deliv    0    0    0    0 507  507    0  3.50   0  3.50   0.00 1774.50  1774.50
Chips   39  136    0  144   0   31   31  0.06   0  0.49   0.00    1.86     1.86
Large    1    0    0    2-  0    3    3  3.00   0  3.00   0.00    9.00     9.00
Prepa  641 1656 1131 1131   0 1166 1359  0.60 193- 0.69 133.17- 815.40   682.23
-------  -------  --------
Totals 7567 5844 6965 [PHONE] 5853        461     1412.62 21867.73 23280.35
-------  -------  -------
TOTAL SALES                                            1412.62 21867.73 23280.35
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
----------
GROSS SALES                                                            23280.35
Debit Fee                                                            (  167.20)
Coupons                                                              (    0.00)
Free Pizza                                                           (    0.00)
Promotions/Discounts                                                 (   11.35)
----------
NET SALES                                                             23101.80
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          49    59    51    71   111     91    77      509
Pick Up              5    10    13    15    16      7     9       75
Complaints           0     1     2     1     2      0     2        8
Total               54    70    64    87   129     98    88      592
=========>1     INC
01/18/16 TO 01/24/16         STORE:  1
PERIOD    1 WEEK   3        WEEKLY STATEMENT                   a
..........COMMISSARY CHARGES                             NET-INVOICE    QST     GST/HST
t35217                      16/01/19                         2943.54              73.49
t47010                      16/01/21                         2448.23             134.32
t47704                      16/01/23                         3459.49              25.61
t42978                      16/01/24                          220.80-
t60277                      16/01/24                           36.80
Total Commissary  8667.26             233.42
..........DIRECT CHARGES
449730    00025             16/01/24 ABELL PEST CONTROL INC    30.89               4.02
450221    00028             16/01/24 STEWARDSHIP ONTARIO      342.72              44.55
451146    00039             16/01/24 SANIMAX LTD.              11.40-              1.48-
Total Direct   362.21              47.09
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         16/01/24 t53239                  1378.50             179.21
ADVERTISING-DELIVERY CHARGE 16/01/24 t48912                   252.50              32.83
ADVERTISING - NATIONAL      16/01/24 t53240                   228.48              29.70
ADVERTISING - DIVISIONAL    16/01/24 t53241                  1142.41             148.51
ORDER PROCESSING CHARGE     16/01/24 t49234                   817.60             106.29
GST/HST ON SALES            16/01/24 t54667                  2804.63
AX TD   012416              16/01/24 t51946                     2.08               0.27
DB TD   012416              16/01/24 t51947                    13.53               1.76
MC TD   012416              16/01/24 t51948                    43.63               5.67
VI TD   012416              16/01/24 t51949                    78.72              10.23
INSURANCE                   16/01/24 t55279                    24.47
PROMI                       16/01/24 t55548                   415.33
PROMP                       16/01/24 t55674                    84.67
RENO CONT                   16/01/24 t55857                   400.00
FEES IT ELRN                16/01/24 t56391                     1.50
FEES IT SUPPOR              16/01/24 t56392                     8.75
RENT WEEKLY                 16/01/24 t56954                  1690.36
FEES GIVEX                  16/01/24 t57271                     2.75               0.36
FEES TD EQUIP               16/01/24 t57678                    81.23              10.56
OPD FEE PU                  16/01/24 t58081                     3.00               0.39
OPD FEE ADJ                 16/01/24 t58427                     8.40-              1.09-
OPD CR#208                  16/01/24 t58672                    19.61
OPD CR#208                  16/01/24 t58673                     0.15
OPD DR#222                  16/01/24 t58828                    14.68-
POLICY OB0124               16/01/24 t59159                   100.00
INT. ON OB0124              16/01/24 t59207                    23.95
CCREDEEM WK03               16/01/24 t59572                   281.83-
LYREDEEMWK03                16/01/24 t59928                    14.07-
CCADJ WK03                  16/01/24 t60113                    15.58
RENO CHEQUE                 16/01/24 t60147                 43222.50
Total General Office 52536.95             524.69
Total Weekly Charges 62371.62
..........PAYMENTS & CREDITS
GST TAX CREDIT              16/01/24 t43244                   805.20-
COMPUTER ROOM CREDIT        16/01/24 t39208                    29.29-
AX TD   012416              16/01/24 t40464                    59.39-
DB TD   012416              16/01/24 t40465                  9888.19-
MC TD   012416              16/01/24 t40466                  2181.67-
VI TD   012416              16/01/24 t40467                  4037.01-
CCREDEEM 01241              16/01/24 t42257                    58.51-
RENO CHEQUE                 16/01/24 t42671                 43222.50-
Direct Deposit              16/01/21  JAN 21                  800.00-
Direct Deposit              16/01/22  JAN 22                  600.00-
Direct Deposit              16/01/24  JAN 25                  600.00-
Total Payments/Credits 62281.76-
PREVIOUS BALANCE       12465.78
TOTAL CHARGES        62371.62
TOTAL CREDITS        62281.76-
BALANCE OUTSTANDING  12555.64
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
29.29                         29.29      0.00                          0.00
The Current Renovation Value is 11541.79
09/29/02     0.00