Spreadsheet: 68408d1268933685-solved-change-macro-to-enter-full-amount-ecom-test-template
Sheet: Friday

 |  | FRIDAY
 |  | 12pm Totals |  |  | 1pm Totals |  |  | 2pm Totals |  |  | 3pm Totals |  |  | 4pm Totals |  |  | 5pm Totals
L'don |  | London = |  | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A
PL   £ | 1000000 | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k
LY   £ | 1000000 | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k
T'ford |  | Trafford = |  | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A
PL   £ | 1000000 | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k
LY   £ | 1000000 | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k
Exch |  | Exchange = |  | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A
PL   £ | 1000000 | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k
LY   £ | 1000000 | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k
B'ham |  | Birmingham = |  | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A
PL   £ | 1000000 | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k
LY   £ | 1000000 | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k
Ecom |  | Ecommerce = |  |  | Ecommerce = | #N/A | #N/A | Ecommerce = 0k | 0 | #N/A | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A
PL   £ | 100000 | plan = 100k |  |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k
LY   £ | 0 | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EOD % TABLE
 |  | 6pm Totals |  |  | 7pm Totals |  |  | 8pm Totals |  |  | 9pm Totals |  |  | End Of Day |  |  |  |  |  |  |  | INSERT TIME HERE
L'don |  | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | London = | #N/A | #N/A | Total - London |  |  |  |  | L'don=
 |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k-100% |  |  | PL | 1000000 | 1000 | -1 |  | PL=1000k
 |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k-100% |  |  | LY | 1000000 | 1000 | -1 |  | LY=1000k
T'ford |  | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Trafford = | #N/A | #N/A | Total - Trafford |  |  |  |  | T'ford=
 |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k-100% |  |  | PL | 1000000 | 1000 | -1 |  | PL=1000k
 |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k-100% |  |  | LY | 1000000 | 1000 | -1 |  | LY=1000k
Exch |  | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Exchange = | #N/A | #N/A | Total - Exchange |  |  |  |  | Exch=
 |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k-100% |  |  | PL | 1000000 | 1000 | -1 |  | PL=1000k
 |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k-100% |  |  | LY | 1000000 | 1000 | -1 |  | LY=1000k
B'ham |  | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Birmingham = | #N/A | #N/A | Total - Birmingham |  |  |  |  | B'ham=
 |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k |  |  | plan = 1000k-100% |  |  | PL | 1000000 | 1000 | -1 |  | PL=1000k
 |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k |  |  | last year = 1000k-100% |  |  | LY | 1000000 | 1000 | -1 |  | LY=1000k
Ecom |  | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A | Ecommerce = | #N/A | #N/A | Total - Ecommerce |  |  |  |  | E-Com=
 |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k |  |  | plan = 100k-100% |  |  | PL | 100000 | 100 | -1 |  | PL=100k
 |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | last year = n/a |  |  | LY | 0 | 0 | n/a |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week To Date % Table
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Week To Date |  |  |  |  |  |  |  | Week To Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  | London = 0k |  |  | Total - London |  | 0 |  |  | L'don=0k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | plan = 6000k-100% |  |  | PL | 1000000 | 6000 | -1 |  | PL=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | last year = 6000k-100% |  |  | LY | 1000000 | 6000 | -1 |  | LY=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Trafford = 0k |  |  | Total - Trafford |  | 0 |  |  | T'ford=0k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | plan = 6000k-100% |  |  | PL | 1000000 | 6000 | -1 |  | PL=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | last year = 6000k-100% |  |  | LY | 1000000 | 6000 | -1 |  | LY=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Exchange = 0k |  |  | Total - Exchange |  | 0 |  |  | Exch=0k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | plan = 6000k-100% |  |  | PL | 1000000 | 6000 | -1 |  | PL=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | last year = 6000k-100% |  |  | LY | 1000000 | 6000 | -1 |  | LY=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Birmingham = 0k |  |  | Total - Birmingham |  | 0 |  |  | B'ham=0k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | plan = 6000k-100% |  |  | PL | 1000000 | 6000 | -1 |  | PL=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | last year = 6000k-100% |  |  | LY | 1000000 | 6000 | -1 |  | LY=6000k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Ecommerce = 0k |  |  | Total - Ecommerce |  | 0 |  |  | E-Com=0k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | plan = 600k-100% |  |  | PL | 100000 | 600 | -1 |  | PL=600k
 |  |  |  |  |  |  |  |  |  |  |  |  |  | last year = n/a |  |  | LY | 0 | 0 | n/a |  | [NAME]