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

=======>1
Weekly Store Sales Report : Store # 1       Period  12  Week  49
[NAME]
Calc   Open Pur  Cls  Cls  Adj Sold Sold Price Var Price Amount  Sales    Base
Small   98   50   47   47   0  101   78 10.13  23 11.00 253.00  790.14  1043.14
Mediu  446  750  628  628   0  568  601  7.71  33- 9.25 305.25-4633.71  4328.46
Large  171  650  600  600   0  221  425 13.32 204-14.943047.76-5661.00  2613.24
Famil  219  250  276  276   0  193  207 12.73  14-16.50 231.00-2635.11  2404.11
Party   58   20   67   67   0   11   12 23.90   1-22.50  22.50- 286.80   264.30
Half    58   50   64   64   0   44   50  5.44   6- 4.50  27.00- 272.00   245.00
GOURM   65    0   47   47   0   18    7  5.28  11  5.50  60.50   36.96    97.46
Slice  458 1000  976  976   0  482  582  3.95 100- 3.95 395.00-2298.90  1903.90
Pop   2736 3120 3352 3352   0 2504 21  0.18 292  0.69 201.48  398.16   599.64
Sprin   90    0   18   18   0   72   24  0.92  48  1.50  72.00   22.08    94.08
600 M  124   24   58   58   0   90   37  1.26  53  1.75  92.75   46.62   139.37
Juice  120   36  113  113   0   43   21  1.88  22  2.00  44.00   39.48    83.48
Milk    24   12   18   18   0   18   18  0.99   0  1.60   0.00   17.82    17.82
Power   16    0   13   13   0    3    3  1.33   0  0.00   0.00    3.99     3.99
Monst   17   12   33   33   0    4-   6  3.19  10- 3.00  30.00-  19.14    10.86-
Salad  252    0  186  186   0   66   13  6.68  53  6.00 318.00   86.84   404.84
Side   238    0    0  228   0   10   10  1.00   0  3.00   0.00   10.00    10.00
6 Pie  137  400  292  292   0  245  241  4.28   4  7.50  30.00 1031.48  1061.48
20 Pi  182  100  196  196   0   86  102  7.31  16- 8.50 136.00- 745.62   609.62
Snack    1-   0    0    2-  0    1    1  6.99   0  5.99   0.00    6.99     6.99
Pasta   22    0    0    4   0   18   18  6.99   0  6.99   0.00  125.82   125.82
Foil    83-   0    0   90-  0    7    7  5.70   0  4.50   0.00   39.90    39.90
Brown   21   48    0   39   0   30   30  2.99   0  3.00   0.00   89.70    89.70
Pouti  544    0  181  181   0  363   61  3.93 302  3.00 906.00  239.73  1145.73
Reg.   185    0  125  125   0   60   89  0.13  29- 1.00  29.00-  11.57    17.43-
$1 DE    0    0    0    0 169  169    0  0.88 169  0.88 148.72    0.00   148.72
Deliv    0    0    0    0 495  495    0  3.50   0  3.50   0.00 1732.50  1732.50
Chips   24   88    0   66   0   46   46  0.02   0  0.49   0.00    0.92     0.92
Large    3-   0    0    5-  0    2    2  3.00   0  3.00   0.00    6.00     6.00
Prepa  985 1656  785  785   0 1856 1415  0.57 441  0.69 304.29  806.55  1110.84
-------  -------  --------
Totals 7203 8266 8075 [PHONE] 6318        1005   -1792.77 22095.53 20302.76
-------  -------  -------
TOTAL SALES                                           -1792.77 22095.53 20302.76
Other Sales :
Restronics                                                                 0.00
Pop Promo                                                                  0.00
----------
GROSS SALES                                                            20302.76
Debit Fee                                                            (  148.72)
Coupons                                                              (    0.00)
Free Pizza                                                           (   11.11)
Promotions/Discounts                                                 (    0.00)
----------
NET SALES                                                             20142.93
==========
[NAME]   Mon  [NAME]   Wed  Thurs  Fri   Sat   Sun      Total
Deliveries          56    58    53    85    83     93    70      498
Pick Up             10     6    14    12    17     21    22      102
Complaints           0     2     0     4     2      1     1       10
Total               66    66    68   101   102    115    93      610
=========>1     INC
11/30/15 TO 12/06/15          STORE:  1
PERIOD   12 WEEK  49        WEEKLY STATEMENT
..........COMMISSARY CHARGES                             NET-INVOICE    QST     GST/HST
s44117                      15/12/01                         2492.53              69.67
s55973                      15/12/03                         3754.14             207.45
s56752                      15/12/05                         3353.75              15.46
Total Commissary  9600.42             292.58
..........DIRECT CHARGES
360094    00728             15/12/06 BELL CANADA              232.57              30.23
Total Direct   232.57              30.23
..........GENERAL OFFICE CHARGES
FRANCHISE ROYALTIES         15/12/06 s62862                  1201.15             156.15
ADVERTISING-DELIVERY CHARGE 15/12/06 s58514                   246.00              31.98
ADVERTISING - NATIONAL      15/12/06 s62863                   198.95              25.86
ADVERTISING - DIVISIONAL    15/12/06 s62864                   994.77             129.32
ORDER PROCESSING CHARGE     15/12/06 s58835                   840.00             109.20
GST/HST ON SALES            15/12/06 s64321                  2639.26
RENO CONS SUPP              15/12/02 s56412                   242.00              31.46
AX TD   120615              15/12/06 s61559                     6.12               0.80
DB TD   120615              15/12/06 s61560                    14.48               1.88
MC TD   120615              15/12/06 s61561                    52.73               6.85
VI TD   120615              15/12/06 s61562                    93.25              12.12
INSURANCE                   15/12/06 s64931                    21.22
PROMI                       15/12/06 s65201                   416.13
PROMP                       15/12/06 s65330                    83.87
RENO CONT                   15/12/06 s65506                   400.00
FEES IT ELRN                15/12/06 s66030                     1.50
FEES IT SUPPOR              15/12/06 s66031                     8.75
RENT WEEKLY                 15/12/06 s66594                  1690.36
FEES GIVEX                  15/12/06 s66912                     2.75               0.36
FEES TD EQUIP               15/12/06 s67319                    81.23              10.56
OPD FEE PU                  15/12/06 s67723                     1.50               0.20
OPD FEE ADJ                 15/12/06 s68070                     4.20-              0.55-
CCLOAD WK49                 15/12/06 s69158                    85.00
CCREDEEM WK49               15/12/06 s69465                   237.39-
LYREDEEMWK49                15/12/06 s69821                     1.24-
POLICY OB1206               15/12/06 s70037                   100.00
INT. ON OB1206              15/12/06 s70098                    15.89
Total General Office  9194.08             516.19
Total Weekly Charges 19866.07
..........PAYMENTS & CREDITS
GST TAX CREDIT              15/12/06 s13876                   839.00-
COMPUTER ROOM CREDIT        15/12/06 s09794                    14.99-
CATER 20151206              15/12/06 s10816                    35.48-
CATER 20151206              15/12/06 s11236                     4.61-
AX TD   120615              15/12/06 s12110                   174.99-
DB TD   120615              15/12/06 s12111                  9499.68-
MC TD   120615              15/12/06 s12112                  2636.33-
VI TD   120615              15/12/06 s12113                  4782.10-
CCREDEEM 12061              15/12/06 s13498                   102.15-
NSF ON 12/01/2015           15/12/03 NSF                     1000.00
Direct Deposit              15/12/03  DEC 03                 1200.00-
Direct Deposit              15/12/04  DEC 04                  200.00-
Direct Deposit              15/12/06  DEC 07                  700.00-
Direct Deposit              15/12/06  DEC 08                  100.00-
Total Payments/Credits 19289.33-
PREVIOUS BALANCE        7847.55
TOTAL CHARGES        19866.07
TOTAL CREDITS        19289.33-
BALANCE OUTSTANDING   8424.29
ANALYSIS OF FREE PIZZAS
Opd     Tech              COMP RM     Store     Late                STORE
CREDIT                                    FREES
14.99                         14.99     11.11                         11.11
The Current Renovation Value is 33669.96-
09/29/02     0.00