Spreadsheet: 179027d1347002846-if-a-cell-has-a-numerical-value-and-is-not-blank-then-copy-its-entire-row-to-another-sheet-example
Sheet: System Configuration

SYSTEM | [NAME] | QTY | RRP | DISCOUNT | TOTAL | MONTHLY |  |  |  |  |  |  | REVENUE | MONTHLY
MAIN EPOS SYSTEMS
1st Connect EPoS System | Retail System, Touch Screen, [NAME], [NAME], Cash Drawer and [NAME], [NAME], [NAME], Purchase [NAME], [NAME], Anti Virus, Till Rolls, [NAME], Commissioning, Installation, Training, Materials Pack, Delivery, Project Management | 1 |  | 0 |  |  |  |  |  |  |  |  | 4818 | 55
1st Connect EXTRA EPoS System | Retail System, Touch Screen, [NAME], [NAME], Cash Drawer and [NAME], [NAME], [NAME], Purchase [NAME], [NAME], Anti Virus, Till Rolls, [NAME], Commissioning, Installation, Training, Materials Pack, Delivery, Project Management, Training Plan, Additional Training | 1 |  | 2000 |  |  |  |  |  |  |  |  | 4991 | 55
Additional EPoS System : Same Site | Retail System, Touch Screen, [NAME], [NAME], Cash Drawer and [NAME], [NAME], [NAME], Purchase [NAME], [NAME], Anti Virus, Till Rolls, Commissioning, Installation, Materials Pack, Delivery, Project Management |  |  | 0 |  |  |  |  |  |  |  |  | 3182 | 11
Additional EPoS System : Additional Site | Retail System, Touch Screen, [NAME], [NAME], Cash Drawer and [NAME], [NAME], [NAME], Purchase [NAME], [NAME], Anti Virus, Till Rolls, [NAME], Commissioning, Installation, Training, Materials Pack, Delivery, Project Management |  |  | 0 |  |  |  |  |  |  |  |  | 3727 | 11
Back Office Licence Software | Full Back Office Licence, Single Installation to Single PC/Laptop | 1 |  | 0 |  |  |  |  |  |  |  |  | 395 | 11
Advanced Back Office Software | Full Back Office Licence, Single Installation to Single PC/Laptop Includes Remote Installation and Training |  |  | 0 |  |  |  |  |  |  |  |  | 544 | 11
Warehouse / Head Office First Licence |  |  |  | 0 |  |  |  |  |  |  |  |  | 690 | 26
Warehouse / Head Office Additional Licence |  |  |  | 0 |  |  |  |  |  |  |  |  | 690 | 11
Single Licence Remote Installation |  |  |  | 0 |  |  |  |  |  |  |  |  | 99 | 0
Software Only : 1st [NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  | 2565 | 55
Software Only : 1st Connect EXTRA Licence |  |  |  | 0 |  |  |  |  |  |  |  |  | 2738 | 55
Software Only : Additional Connect Till Licence : Same Shop |  |  |  | 0 |  |  |  |  |  |  |  |  | 875 | 11
Software Only : Additional Connect Till Licence : Additional Shop |  |  |  | 0 |  |  |  |  |  |  |  |  | 875 | 26
[NAME] to Connect Fulfilment Centre | [NAME] to Connect Fulfilment Centre |  |  | 0 |  |  |  |  |  |  |  |  | 199
Retail Back Office PC Pack | PC Unit, 19" Screen, Keyboard, Mouse, Anti Virus, .PDF Reader, Open Office, Commissioning |  |  | 0 |  |  |  |  |  |  |  |  | 896 | 11
Import Wizard Getting Started Service | We test sample of your import data and then train |  |  | 0 |  |  |  |  |  |  |  |  | 74 | 0
Standard Barcode Printer Pack | Printer, [NAME], Connect Barcode Printing Module |  |  | 0 |  |  |  |  |  |  |  |  | 319 | 0
[NAME] Printer Pack | Printer. [NAME], Connect Barcode Printing Module |  |  | 0 |  |  |  |  |  |  |  |  | 399 | 0
Connect Barcode Printing Module per Printer | Only used if customers wants to buy own hardware |  |  | 0 |  |  |  |  |  |  |  |  | 129 | 0
Multisite Head Office | Cloud Architecture & Reporting. Incl. access to [NAME] via browser. |  |  | 0 |  |  |  |  |  |  |  |  | 750 | 58
Account Management | Mandatory for retailers wirth 4 stores or more |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 85
TOTAL CAPITAL INVESTMENT FOR MAIN EPOS SYSTEMS
EPOS EXTRAS / ACCESSORIES
USB [NAME] | Same model as the till - laptops & PC's |  |  | 0 |  |  |  |  |  |  |  |  | 103
Bluetooth Barcode Scanner | MS-9535  Voyager(33 ft range) usb/kw |  |  | 0 |  |  |  |  |  |  |  |  | 229
Network cabling on site (Upgrade to standard installation day) | For cable runs up to 30m. For over 30m add an installation day |  |  | 0 |  |  |  |  |  |  |  |  | 60
Extra Installation Day | For additional shops, sites or cabling |  |  | 0 |  |  |  |  |  |  |  |  | 390
[NAME]) | For additional shops |  |  | 0 |  |  |  |  |  |  |  |  | 390
Train the trainer course (Upgrade) | For larger groups of staff - lower cost solution. Consists of 2 days (1 day standard training and 1 extra for train the trainer) |  |  | 0 |  |  |  |  |  |  |  |  | 390
Hand Held Wireless Stocktake (incl Connect HHT Module & Config) | Incl Connect HHT Software Module & Configuration & Wireless extender) for wireless stocktaking, goods in/out |  |  | 0 |  |  |  |  |  |  |  |  | 897
Connect SW Module per HHT Device | Only used if customers wants to buy own hardware |  |  | 0 |  |  |  |  |  |  |  |  | 470
USB Thermal Receipt Printer | [NAME] same model as till |  |  | 0 |  |  |  |  |  |  |  |  | 190
Network Kitchen Printer | [NAME] (Use with with Cafe Connect). Note cabling services above |  |  | 0 |  |  |  |  |  |  |  |  | 190
Head Office Back-up Hosting | for secure back-up of Connect database |  |  | 0 |  |  |  |  |  |  |  |  |  | 15
[NAME] | for secure back-up of Connect database |  |  | 0 |  |  |  |  |  |  |  |  |  | 15
Sage Integration (1 store retail) | Bridge Software, setup, remote training, support, updates. 1 yr contract minimum. |  |  | 0 |  |  |  |  |  |  |  |  |  | 57
Sage Integration (Standard) | As above for all retailers with more than one store. |  |  | 0 |  |  |  |  |  |  |  |  |  | 99
Cash Drawer and [NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  | 120
TOTAL CAPITAL INVESTMENT FOR EPOS EXTRAS / ACCESSORIES
WEBSITE
Level 1 Creative Website Design (Entry Level) | Designed for clients new to eCommerce with no existing eCommerce Website. Includes, Creative Design Level 1 design service, Multilevel Menus, 1hr Design Consultancy, Written Design Brief, 20hrs Design and Project Time, Google Analytics, Process and Browser Testing, SEO Migration Service |  |  | 0 |  |  |  |  |  |  |  |  | 2200
Level 1 Starter Hosting  2GB BW+2[NAME] | SSL, L1 Hosting, Zoom Image Space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 27.5
Level 1 eCommerce Engine | Shopping engine, mgnt system, support and updates. Up to 50 sales a month. |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 14
Level 2 Creative Website Design (Entry Level) |  |  |  | 0 |  |  |  |  |  |  |  |  | 4300
Level 1 Starter Hosting  2GB BW+2[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 27.5
Level 2 eCommerce Engine |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 14
Level 3 Creative Website Design (Entry Level) |  |  |  | 0 |  |  |  |  |  |  |  |  | 9000
Level 2 Hosting  2GB BW+2[NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 39.5
Level 3 eCommerce Engine |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 14
Upgrade Level 1 Starter Hosting to Level 2 Hosting |  |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 12
Level 1 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 470 | 0 | 70.5
Level 2 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 780
Level 3 mCommerce Connect |  |  |  |  |  |  |  |  |  |  |  |  | 1570
Web Link with Training |  |  |  | 0 |  |  |  |  |  |  |  |  | 1044 | 11
MySQL hosting 300MB+1GB Disk |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 4
Level 1 Starter Hosting  5GB BW+ | SSL, L1 Starter hosting, zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 39.5
Silver Hosting 2GB BW+ | SSL, Clustered Web Hosting, Zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 43
Silver Hosting 5GB BW+ | SSL, Clustered Web Hosting, Zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 53
Silver Hosting 10[NAME] BW+ | SSL, Clustered Web Hosting, Zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 63
Gold Hosting 5GB BW+ | SSL, Clustered Web Hosting + RackWatch, Zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 63
Gold Hosting 10[NAME] BW+ | SSL, Clustered Web Hosting + RackWatch, Zoom image space |  |  | 0 |  |  |  |  |  |  |  |  | 0 | 71
[NAME] By [NAME] | Includes multilevel menus (built in to Level 3) |  |  | 0 |  |  |  |  |  |  |  |  | 850
Enhanced [NAME] By [NAME] (Multiselect) | Upgrade to standard [NAME] By Nav |  |  | 0 |  |  |  |  |  |  |  |  | 240
Multilevel Menus | Now built in to all IR websites free | 1 |  | 0 |  |  |  |  |  |  |  |  | 0 | 0
SEO Migration Service | Essential for existing sites - free with Level 2 and 3 | 1 |  |  |  |  |  |  |  |  |  |  | 399
Email Additional Block of 5 | Per Month (Note 1st email is free with an IR website) |  |  | 0 |  |  |  |  |  |  |  |  |  | 5.5
Customer Focussed Pack | [NAME], Newsletter, Multi Currency |  |  | 0 |  |  |  |  |  |  |  |  | 99
[NAME] Online Pack | [NAME], [NAME], [NAME], Cards |  |  | 0 |  |  |  |  |  |  |  |  | 89
Personalise It | e.g. add name to [NAME] |  |  | 0 |  |  |  |  |  |  |  |  | 350
Wish/Gift List |  |  |  | 0 |  |  |  |  |  |  |  |  | 270
Additional Static Page |  |  |  | 0 |  |  |  |  |  |  |  |  | 47
Category Introduction Page |  |  |  | 0 |  |  |  |  |  |  |  |  | 47
Dual Payment Provider |  |  |  | 0 |  |  |  |  |  |  |  |  | 60
Logo Design (From Price) | simple text based logo with 1 revision |  |  | 0 |  |  |  |  |  |  |  |  | 240
Blog Design |  |  |  | 0 |  |  |  |  |  |  |  |  | 270
Fast Track Design Process (Level 1 & 2 only) | Speeds up the design process, customer must sign up to returning information quickly |  |  | 0 |  |  |  |  |  |  |  |  | 350
TOTAL CAPITAL INVESTMENT FOR WEBSITE
MULTI CHANNEL
eBay Connect | Set Up and EBay Connect Software, drag and drop to eBay! Includes updates and support. Up to 50 sales a month. Monthly payments will switch to £29 + 0.5% for 50 sales and over permonth |  |  | 0 |  |  |  |  |  |  |  |  | 58 | 14
Multichannel eBay Image Hosting | Includes 500MB Bandwidth 500MB Disk Space Per Month. Free when customer has FULL HOSTING with IR website. |  |  | 0 |  |  |  |  |  |  |  |  | 4
Amazon Connect | Set Up and Amazon Connect Software, drag and drop to Amazon! Includes updates and support. Up to 50 sales a month. Monthly payments will switch to £29 + 0.5% for 50 sales and over permonth |  |  | 0 |  |  |  |  |  |  |  |  | 58 | 14
Google Products | Price covers Integrated  Google Products Software, updates and support |  |  | 0 |  |  |  |  |  |  |  |  |  | 5
TOTAL CAPITAL INVESTMENT FOR MULTI CHANNEL
TOTAL |  | 1 |  |  | CAPITAL | MONTHLY
 |  | 1