{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["PRICE SUMMARY","Proposal & Reseller info","Alarm Control System","Bluetooth Indoor Positioning","Panic Alerting","TETRA Telemetry - RTCU","Staff Safety CLW & MDN","MOTOTRBO Phone & Voice","MOTOTRBO GPS Mapping"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":13,"comments":9,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PRICE SUMMARY","index":0,"n_rows":232,"n_cols":17,"rows_kept":232,"cut":false,"hidden":false,"merged":[[211,1,211,7],[218,0,218,10],[227,0,227,10],[231,0,231,16],[229,0,229,16],[222,0,222,1],[223,0,223,1],[224,0,224,1],[225,0,225,1],[221,0,221,1],[220,0,220,1],[219,0,219,1]]}
[{"$f":"\"ZZZZZZ Proposal for \"&Reseller&\" Case: \"&'Proposal & Reseller info'!B7","v":"ZZZZZZ Proposal for XXXX Case: <Project>"}]
["Part No.","Product","Product Description","Qty.","Unit RRP (EUR)","Total RRP (EUR)","Annual Support & Software Update (EUR)",null,{"$f":"\"Unit RRP (\"&LocalCurrencySymbol&\")\"","v":"Unit RRP (AUD)"},{"$f":"\"Total RRP (\"&LocalCurrencySymbol&\")\"","v":"Total RRP (AUD)"},{"$f":"\"Annual Support & Software Update (\"&LocalCurrencySymbol&\")\"","v":"Annual Support & Software Update (AUD)"},null,"Discount",{"$f":"Reseller&\" Revenue (EUR)\"","v":"XXXX Revenue (EUR)"},{"$f":"Reseller&\" Cost (EUR)\"","v":"XXXX Cost (EUR)"},{"$f":"Reseller&\" Revenue (\"&LocalCurrencySymbol&\")\"","v":"XXXX Revenue (AUD)"},{"$f":"Reseller&\" Cost (\"&LocalCurrencySymbol&\")\"","v":"XXXX Cost (AUD)"}]
[{"$f":"'Alarm Control System'!A11","v":"Alarm Control System (ACS) software"},null,null,{"$f":"SUM(D4:D6)","v":0}]
[{"$f":"'Alarm Control System'!C12","v":73001},{"$f":"'Alarm Control System'!A12","v":"ACS +Plus"},{"$f":"'Alarm Control System'!B12","v":"Alarm Control System software for advanced alarm radio dispatch, including 5 user licenses and including:\n- Support for multiple Alarm Listeners\n- Full functionality incl. Scheduler, Escalation, Action Filter and Alarm Acknowledge\n- First year Support & Software Upgrade License"},{"$f":"'Alarm Control System'!H12","v":0},{"$f":"'Alarm Control System'!E12","v":0},{"$f":"'Alarm Control System'!J12","v":0},{"$f":"'Alarm Control System'!K12","v":0},null,{"$f":"'Alarm Control System'!F12","v":0},{"$f":"'Alarm Control System'!M12","v":0},{"$f":"'Alarm Control System'!N12","v":0},null,{"$f":"IF('Alarm Control System'!D12=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F4-O4","v":0},{"$f":"F4-(F4*M4)","v":0},{"$f":"J4-Q4","v":0},{"$f":"J4-(J4*M4)","v":0}]
[{"$f":"'Alarm Control System'!C13","v":73010},{"$f":"'Alarm Control System'!A13","v":"ACS Lite"},{"$f":"'Alarm Control System'!B13","v":"Alarm Control System software for simple radio alarm dispatch ONLY, including 5 user licenses and including:\n- Support for one Alarm Listener and one Dispatch Media only\n- Basic alarm dispatch functionality without Scheduler, Escalation, Action Filter and Alarm Acknowledge\n- First year Support & Software Upgrade License"},{"$f":"'Alarm Control System'!H13","v":0},{"$f":"'Alarm Control System'!E13","v":0},{"$f":"'Alarm Control System'!J13","v":0},{"$f":"'Alarm Control System'!K13","v":0},null,{"$f":"'Alarm Control System'!F13","v":0},{"$f":"'Alarm Control System'!M13","v":0},{"$f":"'Alarm Control System'!N13","v":0},null,{"$f":"IF('Alarm Control System'!D13=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F5-O5","v":0},{"$f":"F5-(F5*M5)","v":0},{"$f":"J5-Q5","v":0},{"$f":"J5-(J5*M5)","v":0}]
[{"$f":"'Alarm Control System'!C14","v":73020},{"$f":"'Alarm Control System'!A14","v":"ACS Upgrade"},{"$f":"'Alarm Control System'!B14","v":"Upgrading from ACS Lite to the full solution ACS +Plus (upgrade from part no. 73010 to 73001)"},{"$f":"'Alarm Control System'!H14","v":0},{"$f":"'Alarm Control System'!E14","v":0},{"$f":"'Alarm Control System'!J14","v":0},{"$f":"'Alarm Control System'!K14","v":0},null,{"$f":"'Alarm Control System'!F14","v":0},{"$f":"'Alarm Control System'!M14","v":0},{"$f":"'Alarm Control System'!N14","v":0},null,{"$f":"IF('Alarm Control System'!D14=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!A15","v":"ACS Alarm Dispatch Media"},null,null,{"$f":"SUM(D8:D15)","v":0}]
[{"$f":"'Alarm Control System'!C16","v":73240},{"$f":"'Alarm Control System'!A16","v":"TETRA Radio Media"},{"$f":"'Alarm Control System'!B16","v":"TETRA dispatch media for Sepura and Motorola PEI connection"},{"$f":"'Alarm Control System'!H16","v":0},{"$f":"'Alarm Control System'!E16","v":0},{"$f":"'Alarm Control System'!J16","v":0},{"$f":"'Alarm Control System'!K16","v":0},null,{"$f":"'Alarm Control System'!F16","v":0},{"$f":"'Alarm Control System'!M16","v":0},{"$f":"'Alarm Control System'!N16","v":0},null,{"$f":"IF('Alarm Control System'!D16=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F8-O8","v":0},{"$f":"F8-(F8*M8)","v":0},{"$f":"J8-Q8","v":0},{"$f":"J8-(J8*M8)","v":0}]
[{"$f":"'Alarm Control System'!C17","v":73242},{"$f":"'Alarm Control System'!A17","v":"TETRA Direct Access Media"},{"$f":"'Alarm Control System'!B17","v":"TETRA dispatch media for direct access to Motorola Dimetra Short Data Router (SDR)"},{"$f":"'Alarm Control System'!H17","v":0},{"$f":"'Alarm Control System'!E17","v":0},{"$f":"'Alarm Control System'!J17","v":0},{"$f":"'Alarm Control System'!K17","v":0},null,{"$f":"'Alarm Control System'!F17","v":0},{"$f":"'Alarm Control System'!M17","v":0},{"$f":"'Alarm Control System'!N17","v":0},null,{"$f":"IF('Alarm Control System'!D17=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C18","v":73250},{"$f":"'Alarm Control System'!A18","v":"MOTOTRBO Media"},{"$f":"'Alarm Control System'!B18","v":"Motorola MOTOTRBO dispatch media"},{"$f":"'Alarm Control System'!H18","v":0},{"$f":"'Alarm Control System'!E18","v":0},{"$f":"'Alarm Control System'!J18","v":0},{"$f":"'Alarm Control System'!K18","v":0},null,{"$f":"'Alarm Control System'!F18","v":0},{"$f":"'Alarm Control System'!M18","v":0},{"$f":"'Alarm Control System'!N18","v":0},null,{"$f":"IF('Alarm Control System'!D18=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C19","v":73270},{"$f":"'Alarm Control System'!A19","v":"DECT Media"},{"$f":"'Alarm Control System'!B19","v":"Polycom DECT Phone dispatch media "},{"$f":"'Alarm Control System'!H19","v":0},{"$f":"'Alarm Control System'!E19","v":0},{"$f":"'Alarm Control System'!J19","v":0},{"$f":"'Alarm Control System'!K19","v":0},null,{"$f":"'Alarm Control System'!F19","v":0},{"$f":"'Alarm Control System'!M19","v":0},{"$f":"'Alarm Control System'!N19","v":0},null,{"$f":"IF('Alarm Control System'!D19=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C20","v":73275},{"$f":"'Alarm Control System'!A20","v":"TEAM Media"},{"$f":"'Alarm Control System'!B20","v":"Motorola WiFi TEAM Phone media"},{"$f":"'Alarm Control System'!H20","v":0},{"$f":"'Alarm Control System'!E20","v":0},{"$f":"'Alarm Control System'!J20","v":0},{"$f":"'Alarm Control System'!K20","v":0},null,{"$f":"'Alarm Control System'!F20","v":0},{"$f":"'Alarm Control System'!M20","v":0},{"$f":"'Alarm Control System'!N20","v":0},null,{"$f":"IF('Alarm Control System'!D20=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C21","v":37002},{"$f":"'Alarm Control System'!A21","v":"POCSAG Pager Media"},{"$f":"'Alarm Control System'!B21","v":"POCSAG Pager media for CommTech Intelpage IP transmitters"},{"$f":"'Alarm Control System'!H21","v":0},{"$f":"'Alarm Control System'!E21","v":0},{"$f":"'Alarm Control System'!J21","v":0},{"$f":"'Alarm Control System'!K21","v":0},null,{"$f":"'Alarm Control System'!F21","v":0},{"$f":"'Alarm Control System'!M21","v":0},{"$f":"'Alarm Control System'!N21","v":0},null,{"$f":"IF('Alarm Control System'!D21=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C22","v":73200},{"$f":"'Alarm Control System'!A22","v":"SMS Media"},{"$f":"'Alarm Control System'!B22","v":"SMS dispatch media for GSM modems (see part no. 73210)"},{"$f":"'Alarm Control System'!H22","v":0},{"$f":"'Alarm Control System'!E22","v":0},{"$f":"'Alarm Control System'!J22","v":0},{"$f":"'Alarm Control System'!K22","v":0},null,{"$f":"'Alarm Control System'!F22","v":0},{"$f":"'Alarm Control System'!M22","v":0},{"$f":"'Alarm Control System'!N22","v":0},null,{"$f":"IF('Alarm Control System'!D22=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C23","v":73210},{"$f":"'Alarm Control System'!A23","v":"GSM Modem"},{"$f":"'Alarm Control System'!B23","v":"Hardware unit for SMS dispatch (part no. 73200):\n- Complete GSM modem package for SMS dispatch media\n- Antennea\n- Power Supply (EU two pin plug)\n- Serial cable\n- USB connector\nNote: Customer must provide SIM card"},{"$f":"'Alarm Control System'!H23","v":0},{"$f":"'Alarm Control System'!E23","v":0},{"$f":"'Alarm Control System'!J23","v":0},{"$f":"'Alarm Control System'!K23","v":0},null,{"$f":"'Alarm Control System'!F23","v":0},{"$f":"'Alarm Control System'!M23","v":0},{"$f":"'Alarm Control System'!N23","v":0},null,{"$f":"IF('Alarm Control System'!D23=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!A24","v":"Additional ACS User Licenses"},null,null,{"$f":"SUM(D17:D17)","v":0}]
[{"$f":"'Alarm Control System'!C26","v":73030},{"$f":"'Alarm Control System'!A26","v":"Additional ACS Users"},{"$f":"'Alarm Control System'!B26","v":"Additional ACS User licenses"},{"$f":"'Alarm Control System'!H26","v":0},{"$f":"'Alarm Control System'!E26","v":0},{"$f":"'Alarm Control System'!J26","v":0},{"$f":"'Alarm Control System'!K26","v":0},null,{"$f":"'Alarm Control System'!F26","v":0},{"$f":"'Alarm Control System'!M26","v":0},{"$f":"'Alarm Control System'!N26","v":0},null,{"$f":"IF('Alarm Control System'!D25=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F17-O17","v":0},{"$f":"F17-(F17*M17)","v":0},{"$f":"J17-Q17","v":0},{"$f":"J17-(J17*M17)","v":0}]
[{"$f":"'Alarm Control System'!A35","v":"ACS Alarm Listeners"},null,null,{"$f":"SUM(D19:D35)","v":0}]
[{"$f":"'Alarm Control System'!C36","v":37001},{"$f":"'Alarm Control System'!A36","v":"Wireless Text Message Listener"},{"$f":"'Alarm Control System'!B36","v":"Wireless Text Message Listener for TETRA, MOTOTRBO, DECT, TEAM and GSM *)"},{"$f":"'Alarm Control System'!H36","v":0},{"$f":"'Alarm Control System'!E36","v":0},{"$f":"'Alarm Control System'!J36","v":0},{"$f":"'Alarm Control System'!K36","v":0},null,{"$f":"'Alarm Control System'!F36","v":0},{"$f":"'Alarm Control System'!M36","v":0},{"$f":"'Alarm Control System'!N36","v":0},null,{"$f":"IF('Alarm Control System'!D36=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F19-O19","v":0},{"$f":"F19-(F19*M19)","v":0},{"$f":"J19-Q19","v":0},{"$f":"J19-(J19*M19)","v":0}]
[{"$f":"'Alarm Control System'!C37","v":73210},{"$f":"'Alarm Control System'!A37","v":"GSM Modem"},{"$f":"'Alarm Control System'!B37","v":"Hardware unit for SMS Wireless Text Messages (part no. 37001):\n- Complete GSM modem package for SMS dispatch media\n- Antennea\n- Power Supply (EU two pin plugs)\n- Serial cable\n- USB connector\nNote: Customer must provide SIM card"},{"$f":"'Alarm Control System'!H37","v":0},{"$f":"'Alarm Control System'!E37","v":0},{"$f":"'Alarm Control System'!J37","v":0},{"$f":"'Alarm Control System'!K37","v":0},null,{"$f":"'Alarm Control System'!F37","v":0},{"$f":"'Alarm Control System'!M37","v":0},{"$f":"'Alarm Control System'!N37","v":0},null,{"$f":"IF('Alarm Control System'!D37=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C38","v":37002},{"$f":"'Alarm Control System'!A38","v":"OPC Listener"},{"$f":"'Alarm Control System'!B38","v":"OPC (OLE for Process Control) for SCADA and PLC systems."},{"$f":"'Alarm Control System'!H38","v":0},{"$f":"'Alarm Control System'!E38","v":0},{"$f":"'Alarm Control System'!J38","v":0},{"$f":"'Alarm Control System'!K38","v":0},null,{"$f":"'Alarm Control System'!F38","v":0},{"$f":"'Alarm Control System'!M38","v":0},{"$f":"'Alarm Control System'!N38","v":0},null,{"$f":"IF('Alarm Control System'!D38=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C39","v":37007},{"$f":"'Alarm Control System'!A39","v":"Email Listener"},{"$f":"'Alarm Control System'!B39","v":"Email Listener with build-in SMTP server"},{"$f":"'Alarm Control System'!H39","v":0},{"$f":"'Alarm Control System'!E39","v":0},{"$f":"'Alarm Control System'!J39","v":0},{"$f":"'Alarm Control System'!K39","v":0},null,{"$f":"'Alarm Control System'!F39","v":0},{"$f":"'Alarm Control System'!M39","v":0},{"$f":"'Alarm Control System'!N39","v":0},null,{"$f":"IF('Alarm Control System'!D39=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C40","v":37008},{"$f":"'Alarm Control System'!A40","v":"Serial ASCII Listener"},{"$f":"'Alarm Control System'!B40","v":"Serial ASCII Listener for alarm printer outputs, ASCII strings, RS232 etc."},{"$f":"'Alarm Control System'!H40","v":0},{"$f":"'Alarm Control System'!E40","v":0},{"$f":"'Alarm Control System'!J40","v":0},{"$f":"'Alarm Control System'!K40","v":0},null,{"$f":"'Alarm Control System'!F40","v":0},{"$f":"'Alarm Control System'!M40","v":0},{"$f":"'Alarm Control System'!N40","v":0},null,{"$f":"IF('Alarm Control System'!D40=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C41","v":37009},{"$f":"'Alarm Control System'!A41","v":"Database Listener"},{"$f":"'Alarm Control System'!B41","v":"Database Listener for SQL database lookup"},{"$f":"'Alarm Control System'!H41","v":0},{"$f":"'Alarm Control System'!E41","v":0},{"$f":"'Alarm Control System'!J41","v":0},{"$f":"'Alarm Control System'!K41","v":0},null,{"$f":"'Alarm Control System'!F41","v":0},{"$f":"'Alarm Control System'!M41","v":0},{"$f":"'Alarm Control System'!N41","v":0},null,{"$f":"IF('Alarm Control System'!D41=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C42","v":37010},{"$f":"'Alarm Control System'!A42","v":"Panic Alarm Listener"},{"$f":"'Alarm Control System'!B42","v":"For ZZZZZZ wireless panic alerting system. See folder \"Panic Alerting Solution\" for information on hardware."},{"$f":"'Alarm Control System'!H42","v":0},{"$f":"'Alarm Control System'!E42","v":0},{"$f":"'Alarm Control System'!J42","v":0},{"$f":"'Alarm Control System'!K42","v":0},null,{"$f":"'Alarm Control System'!F42","v":0},{"$f":"'Alarm Control System'!M42","v":0},{"$f":"'Alarm Control System'!N42","v":0},null,{"$f":"IF('Alarm Control System'!D42=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C43","v":37011},{"$f":"'Alarm Control System'!A43","v":"Command Line"},{"$f":"'Alarm Control System'!B43","v":"Command Line Client (Windows and Linux) and alarm Listener"},{"$f":"'Alarm Control System'!H43","v":0},{"$f":"'Alarm Control System'!E43","v":0},{"$f":"'Alarm Control System'!J43","v":0},{"$f":"'Alarm Control System'!K43","v":0},null,{"$f":"'Alarm Control System'!F43","v":0},{"$f":"'Alarm Control System'!M43","v":0},{"$f":"'Alarm Control System'!N43","v":0},null,{"$f":"IF('Alarm Control System'!D43=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C44","v":37015},{"$f":"'Alarm Control System'!A44","v":"ESPA4.4.4"},{"$f":"'Alarm Control System'!B44","v":"ESPA4.4.4 Alarm Listener\nThe ESPA4.4.4 Listener requires an ESPA <=> IP protocol converter unit from www.elexol.nl"},{"$f":"'Alarm Control System'!H44","v":0},{"$f":"'Alarm Control System'!E44","v":0},{"$f":"'Alarm Control System'!J44","v":0},{"$f":"'Alarm Control System'!K44","v":0},null,{"$f":"'Alarm Control System'!F44","v":0},{"$f":"'Alarm Control System'!M44","v":0},{"$f":"'Alarm Control System'!N44","v":0},null,{"$f":"IF('Alarm Control System'!D44=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C45","v":37020},{"$f":"'Alarm Control System'!A45","v":"MOXA I/O"},{"$f":"'Alarm Control System'!B45","v":"MOXA I/O LAN Alarm Listener"},{"$f":"'Alarm Control System'!H45","v":0},{"$f":"'Alarm Control System'!E45","v":0},{"$f":"'Alarm Control System'!J45","v":0},{"$f":"'Alarm Control System'!K45","v":0},null,{"$f":"'Alarm Control System'!F45","v":0},{"$f":"'Alarm Control System'!M45","v":0},{"$f":"'Alarm Control System'!N45","v":0},null,{"$f":"IF('Alarm Control System'!D45=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C46","v":38210},{"$f":"'Alarm Control System'!A46","v":"MOXA E2010"},{"$f":"'Alarm Control System'!B46","v":"MOXA ioLogik E2010, incl.:\n- 12 Digital Input\n- DIN Rail mounting"},{"$f":"'Alarm Control System'!H46","v":0},{"$f":"'Alarm Control System'!E46","v":0},{"$f":"'Alarm Control System'!J46","v":0},{"$f":"'Alarm Control System'!K46","v":0},null,{"$f":"'Alarm Control System'!F46","v":0},{"$f":"'Alarm Control System'!M46","v":0},{"$f":"'Alarm Control System'!N46","v":0},null,{"$f":"IF('Alarm Control System'!D46=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C47","v":38110},{"$f":"'Alarm Control System'!A47","v":"MOXA Power Supply"},{"$f":"'Alarm Control System'!B47","v":"24 VDC MOXA Power Supply for DIN Rail mounting"},{"$f":"'Alarm Control System'!H47","v":0},{"$f":"'Alarm Control System'!E47","v":0},{"$f":"'Alarm Control System'!J47","v":0},{"$f":"'Alarm Control System'!K47","v":0},null,{"$f":"'Alarm Control System'!F47","v":0},{"$f":"'Alarm Control System'!M47","v":0},{"$f":"'Alarm Control System'!N47","v":0},null,{"$f":"IF('Alarm Control System'!D47=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C48","v":37100},{"$f":"'Alarm Control System'!A48","v":"Desktop Client"},{"$f":"'Alarm Control System'!B48","v":"Desktop PC Client User Interface for Windows PC's to raise manual alarms and tasks"},{"$f":"'Alarm Control System'!H48","v":0},{"$f":"'Alarm Control System'!E48","v":0},{"$f":"'Alarm Control System'!J48","v":0},{"$f":"'Alarm Control System'!K48","v":0},null,{"$f":"'Alarm Control System'!F48","v":0},{"$f":"'Alarm Control System'!M48","v":0},{"$f":"'Alarm Control System'!N48","v":0},null,{"$f":"IF('Alarm Control System'!D48=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C49","v":37003},{"$f":"'Alarm Control System'!A49","v":"IO Alarm Listener"},{"$f":"'Alarm Control System'!B49","v":"IO Listener for alarms via discrete signals. Need Part No. 38009."},{"$f":"'Alarm Control System'!H49","v":0},{"$f":"'Alarm Control System'!E49","v":0},{"$f":"'Alarm Control System'!J49","v":0},{"$f":"'Alarm Control System'!K49","v":0},null,{"$f":"'Alarm Control System'!F49","v":0},{"$f":"'Alarm Control System'!M49","v":0},{"$f":"'Alarm Control System'!N49","v":0},null,{"$f":"IF('Alarm Control System'!D49=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C50","v":38009},{"$f":"'Alarm Control System'!A50","v":"IO AX9 MAIN UNIT"},{"$f":"'Alarm Control System'!B50","v":"AX9 Unit, incl.\n- 5 Digital Alarm Input\n- 4 Analogue Input (0-5 V)\n- MODBUS connection to I/O Expansion units\n- IP67 enclosure\n- Build-in 230 VAC power supply"},{"$f":"'Alarm Control System'!H50","v":0},{"$f":"'Alarm Control System'!E50","v":0},{"$f":"'Alarm Control System'!J50","v":0},{"$f":"'Alarm Control System'!K50","v":0},null,{"$f":"'Alarm Control System'!F50","v":0},{"$f":"'Alarm Control System'!M50","v":0},{"$f":"'Alarm Control System'!N50","v":0},null,{"$f":"IF('Alarm Control System'!D50=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C51","v":38041},{"$f":"'Alarm Control System'!A51","v":"IO MODBUS 14 DI"},{"$f":"'Alarm Control System'!B51","v":"MODBUS I/O Expansion Unit:\n- 14 Digital Inputs (Isolated)\n- For connection to Part No. 38009"},{"$f":"'Alarm Control System'!H51","v":0},{"$f":"'Alarm Control System'!E51","v":0},{"$f":"'Alarm Control System'!J51","v":0},{"$f":"'Alarm Control System'!K51","v":0},null,{"$f":"'Alarm Control System'!F51","v":0},{"$f":"'Alarm Control System'!M51","v":0},{"$f":"'Alarm Control System'!N51","v":0},null,{"$f":"IF('Alarm Control System'!D51=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C52","v":38065},{"$f":"'Alarm Control System'!A52","v":"IO MODBUS 4 DI"},{"$f":"'Alarm Control System'!B52","v":"MODBUS I/O Expansion Unit:\n- 4 Digital Inputs\n- 5 Digital Relay Outputs (250 V/5A)\n- For connection to Part No. 38009"},{"$f":"'Alarm Control System'!H52","v":0},{"$f":"'Alarm Control System'!E52","v":0},{"$f":"'Alarm Control System'!J52","v":0},{"$f":"'Alarm Control System'!K52","v":0},null,{"$f":"'Alarm Control System'!F52","v":0},{"$f":"'Alarm Control System'!M52","v":0},{"$f":"'Alarm Control System'!N52","v":0},null,{"$f":"IF('Alarm Control System'!D52=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!A53","v":"ACS Add-on Modules"},null,null,{"$f":"SUM(D37:D40)","v":0}]
[{"$f":"'Alarm Control System'!C54","v":81000},{"$f":"'Alarm Control System'!A54","v":"ACS Relay Module"},{"$f":"'Alarm Control System'!B54","v":"Relay Output Module with 4 relays (software and hardware unit included)"},{"$f":"'Alarm Control System'!H54","v":0},{"$f":"'Alarm Control System'!E54","v":0},{"$f":"'Alarm Control System'!J54","v":0},{"$f":"'Alarm Control System'!K54","v":0},null,{"$f":"'Alarm Control System'!F54","v":0},{"$f":"'Alarm Control System'!M54","v":0},{"$f":"'Alarm Control System'!N54","v":0},null,{"$f":"IF('Alarm Control System'!D54=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F37-O37","v":0},{"$f":"F37-(F37*M37)","v":0},{"$f":"J37-Q37","v":0},{"$f":"J37-(J37*M37)","v":0}]
[{"$f":"'Alarm Control System'!C55","v":81005},{"$f":"'Alarm Control System'!A55","v":"Centralized Lone Worker Module"},{"$f":"'Alarm Control System'!B55","v":"ACS toolbox for setting up lone worker services.\nMedia supported: TETRA, MOTOTRBO, DECT, TEAM and GSM"},{"$f":"'Alarm Control System'!H55","v":0},{"$f":"'Alarm Control System'!E55","v":0},{"$f":"'Alarm Control System'!J55","v":0},{"$f":"'Alarm Control System'!K55","v":0},null,{"$f":"'Alarm Control System'!F55","v":0},{"$f":"'Alarm Control System'!M55","v":0},{"$f":"'Alarm Control System'!N55","v":0},null,{"$f":"IF('Alarm Control System'!D55=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C56","v":81010},{"$f":"'Alarm Control System'!A56","v":"Radio Network Alive Check"},{"$f":"'Alarm Control System'!B56","v":"Radio Network Alive Check Module including:\n- ACS software\n- Alive Check hardware unit\n- Support for TETRA, MOTOTRBO and GSM\n- Network failure notified by SMS or via relay output"},{"$f":"'Alarm Control System'!H56","v":0},{"$f":"'Alarm Control System'!E56","v":0},{"$f":"'Alarm Control System'!J56","v":0},{"$f":"'Alarm Control System'!K56","v":0},null,{"$f":"'Alarm Control System'!F56","v":0},{"$f":"'Alarm Control System'!M56","v":0},{"$f":"'Alarm Control System'!N56","v":0},null,{"$f":"IF('Alarm Control System'!D56=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C57","v":81015},{"$f":"'Alarm Control System'!A57","v":"Alarm Display"},{"$f":"'Alarm Control System'!B57","v":"Alarm display\n- Showing alarms on remote or control room PC screens\n- Unlimited number of Windows client use"},{"$f":"'Alarm Control System'!H57","v":0},{"$f":"'Alarm Control System'!E57","v":0},{"$f":"'Alarm Control System'!J57","v":0},{"$f":"'Alarm Control System'!K57","v":0},null,{"$f":"'Alarm Control System'!F57","v":0},{"$f":"'Alarm Control System'!M57","v":0},{"$f":"'Alarm Control System'!N57","v":0},null,{"$f":"IF('Alarm Control System'!D57=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!A58","v":"Special and Customised Deliveries"},null,null,{"$f":"SUM(D42:D46)","v":0}]
[{"$f":"'Alarm Control System'!C59","v":55009},{"$f":"'Alarm Control System'!A59","v":"Special Software 1"},{"$f":"'Alarm Control System'!B59","v":"<insert description of the special software provided>"},{"$f":"'Alarm Control System'!H59","v":0},{"$f":"'Alarm Control System'!E59","v":0},{"$f":"'Alarm Control System'!J59","v":0},{"$f":"'Alarm Control System'!K59","v":0},null,{"$f":"'Alarm Control System'!F59","v":0},{"$f":"'Alarm Control System'!M59","v":0},{"$f":"'Alarm Control System'!N59","v":0},null,{"$f":"IF('Alarm Control System'!D59=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F42-O42","v":0},{"$f":"F42-(F42*M42)","v":0},{"$f":"J42-Q42","v":0},{"$f":"J42-(J42*M42)","v":0}]
[{"$f":"'Alarm Control System'!C60","v":55009},{"$f":"'Alarm Control System'!A60","v":"Special Software 2"},{"$f":"'Alarm Control System'!B60","v":"<insert description of the special software provided>"},{"$f":"'Alarm Control System'!H60","v":0},{"$f":"'Alarm Control System'!E60","v":0},{"$f":"'Alarm Control System'!J60","v":0},{"$f":"'Alarm Control System'!K60","v":0},null,{"$f":"'Alarm Control System'!F60","v":0},{"$f":"'Alarm Control System'!M60","v":0},{"$f":"'Alarm Control System'!N60","v":0},null,{"$f":"IF('Alarm Control System'!D60=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C61","v":82004},{"$f":"'Alarm Control System'!A61","v":"Special Hardware 1"},{"$f":"'Alarm Control System'!B61","v":"<insert description of the special hardware provided>"},{"$f":"'Alarm Control System'!H61","v":0},{"$f":"'Alarm Control System'!E61","v":0},{"$f":"'Alarm Control System'!J61","v":0},{"$f":"'Alarm Control System'!K61","v":0},null,{"$f":"'Alarm Control System'!F61","v":0},{"$f":"'Alarm Control System'!M61","v":0},{"$f":"'Alarm Control System'!N61","v":0},null,{"$f":"IF('Alarm Control System'!D61=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!C62","v":82004},{"$f":"'Alarm Control System'!A62","v":"Special Hardware 2"},{"$f":"'Alarm Control System'!B62","v":"<insert description of the special hardware provided>"},{"$f":"'Alarm Control System'!H62","v":0},{"$f":"'Alarm Control System'!E62","v":0},{"$f":"'Alarm Control System'!J62","v":0},{"$f":"'Alarm Control System'!K62","v":0},null,{"$f":"'Alarm Control System'!F62","v":0},{"$f":"'Alarm Control System'!M62","v":0},{"$f":"'Alarm Control System'!N62","v":0},null,{"$f":"IF('Alarm Control System'!D62=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Alarm Control System'!A63","v":"Demo Kits"},null,null,{"$f":"SUM(D47:D48)","v":0}]
[{"$f":"'Alarm Control System'!C64","v":10002},{"$f":"'Alarm Control System'!A64","v":"TETRA ACS+IPS Demo Kit"},{"$f":"'Alarm Control System'!B64","v":"TETRA Demo Kit including:\n- 2 pcs. Bluetooth Positioning Beacons including power supplies\n- Alarm Control System software with TETRA radio PEI interface\n- Indoor Positioning software\n- 1 pcs. TETRA Telemetry Unit / RTCU\n- Alarm simulator software tool"},{"$f":"'Alarm Control System'!H64","v":0},{"$f":"'Alarm Control System'!E64","v":0},{"$f":"'Alarm Control System'!J64","v":0},{"$f":"'Alarm Control System'!K64","v":0},null,{"$f":"'Alarm Control System'!F64","v":0},{"$f":"'Alarm Control System'!M64","v":0},{"$f":"'Alarm Control System'!N64","v":0},null,{"$f":"IF('Alarm Control System'!D64=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F47-O47","v":0},{"$f":"F47-(F47*M47)","v":0},{"$f":"J47-Q47","v":0},{"$f":"J47-(J47*M47)","v":0}]
[{"$f":"'Alarm Control System'!C65","v":10003},{"$f":"'Alarm Control System'!A65","v":"ACS+IPS Demo Kit"},{"$f":"'Alarm Control System'!B65","v":"Demo Kit including:\n- 2 pcs. Bluetooth Positioning Beacons including power supplies\n- Alarm Control System software with free selection of Media: MOTOTRBO, DECT, POCSAG, GSM or TEAM\n- Indoor Positioning software\n- Alarm simulator software tool"},{"$f":"'Alarm Control System'!H65","v":0},{"$f":"'Alarm Control System'!E65","v":0},{"$f":"'Alarm Control System'!J65","v":0},{"$f":"'Alarm Control System'!K65","v":0},null,{"$f":"'Alarm Control System'!F65","v":0},{"$f":"'Alarm Control System'!M65","v":0},{"$f":"'Alarm Control System'!N65","v":0},null,{"$f":"IF('Alarm Control System'!D65=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!A11","v":"Indoor Positioning System (IPS)"},null,null,{"$f":"SUM(D50:D54)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C12","v":90005},{"$f":"'Bluetooth Indoor Positioning'!A12","v":"IPS (5 Beacons)"},{"$f":"'Bluetooth Indoor Positioning'!B12","v":"License for the Indoor Positioning System, incl.:\n- Connection of up to 5 Bluetooth Position Beacons\n- 1st years Support & Software Updates"},{"$f":"'Bluetooth Indoor Positioning'!H12","v":0},{"$f":"'Bluetooth Indoor Positioning'!E12","v":0},{"$f":"'Bluetooth Indoor Positioning'!J12","v":0},{"$f":"'Bluetooth Indoor Positioning'!K12","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F12","v":0},{"$f":"'Bluetooth Indoor Positioning'!M12","v":0},{"$f":"'Bluetooth Indoor Positioning'!N12","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D12=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F50-O50","v":0},{"$f":"F50-(F50*M50)","v":0},{"$f":"J50-Q50","v":0},{"$f":"J50-(J50*M50)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C13","v":90025},{"$f":"'Bluetooth Indoor Positioning'!A13","v":"IPS (25 Beacons)"},{"$f":"'Bluetooth Indoor Positioning'!B13","v":"License for the Indoor Positioning System, incl.:\n- Connection of up to 25 Bluetooth Position Beacons\n- 1st years Support & Software Updates"},{"$f":"'Bluetooth Indoor Positioning'!H13","v":0},{"$f":"'Bluetooth Indoor Positioning'!E13","v":0},{"$f":"'Bluetooth Indoor Positioning'!J13","v":0},{"$f":"'Bluetooth Indoor Positioning'!K13","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F13","v":0},{"$f":"'Bluetooth Indoor Positioning'!M13","v":0},{"$f":"'Bluetooth Indoor Positioning'!N13","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D13=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C14","v":90099},{"$f":"'Bluetooth Indoor Positioning'!A14","v":"IPS (Unlimited Beacons)"},{"$f":"'Bluetooth Indoor Positioning'!B14","v":"License for the Indoor Positioning System, incl.:\n- Connection of unlimited number of Bluetooth Position Beacons\n- 1st years Support & Software Updates"},{"$f":"'Bluetooth Indoor Positioning'!H14","v":0},{"$f":"'Bluetooth Indoor Positioning'!E14","v":0},{"$f":"'Bluetooth Indoor Positioning'!J14","v":0},{"$f":"'Bluetooth Indoor Positioning'!K14","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F14","v":0},{"$f":"'Bluetooth Indoor Positioning'!M14","v":0},{"$f":"'Bluetooth Indoor Positioning'!N14","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D14=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C15","v":90012},{"$f":"'Bluetooth Indoor Positioning'!A15","v":"IPS Upgrade (5-25 Beacons)"},{"$f":"'Bluetooth Indoor Positioning'!B15","v":"Upgrading IPS from 5 to 25 Bluetooth Beacon license (upgrade from item no. 90005 to 90025)"},{"$f":"'Bluetooth Indoor Positioning'!H15","v":0},{"$f":"'Bluetooth Indoor Positioning'!E15","v":0},{"$f":"'Bluetooth Indoor Positioning'!J15","v":0},{"$f":"'Bluetooth Indoor Positioning'!K15","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F15","v":0},{"$f":"'Bluetooth Indoor Positioning'!M15","v":0},{"$f":"'Bluetooth Indoor Positioning'!N15","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D15=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C16","v":90050},{"$f":"'Bluetooth Indoor Positioning'!A16","v":"IPS Upgrade (25-Unlimited Beacons)"},{"$f":"'Bluetooth Indoor Positioning'!B16","v":"Upgrading IPS from 25 to unlimited Bluetooth Beacon license (upgrade from item no. 90025 to 90999)"},{"$f":"'Bluetooth Indoor Positioning'!H16","v":0},{"$f":"'Bluetooth Indoor Positioning'!E16","v":0},{"$f":"'Bluetooth Indoor Positioning'!J16","v":0},{"$f":"'Bluetooth Indoor Positioning'!K16","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F16","v":0},{"$f":"'Bluetooth Indoor Positioning'!M16","v":0},{"$f":"'Bluetooth Indoor Positioning'!N16","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D16=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!A17","v":"Bluetooth Position Beacons"},null,null,{"$f":"SUM(D56:D61)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C18","v":91000},{"$f":"'Bluetooth Indoor Positioning'!A18","v":"BPBi-01"},{"$f":"'Bluetooth Indoor Positioning'!B18","v":"1-5 pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon."},{"$f":"'Bluetooth Indoor Positioning'!H18","v":0},{"$f":"'Bluetooth Indoor Positioning'!E18","v":0},{"$f":"'Bluetooth Indoor Positioning'!J18","v":0},{"$f":"'Bluetooth Indoor Positioning'!K18","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F18","v":0},{"$f":"'Bluetooth Indoor Positioning'!M18","v":0},{"$f":"'Bluetooth Indoor Positioning'!N18","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D18=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F56-O56","v":0},{"$f":"F56-(F56*M56)","v":0},{"$f":"J56-Q56","v":0},{"$f":"J56-(J56*M56)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C19","v":91010},{"$f":"'Bluetooth Indoor Positioning'!A19","v":"BPBi-01"},{"$f":"'Bluetooth Indoor Positioning'!B19","v":"6-25 pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon ordered in one lot."},{"$f":"'Bluetooth Indoor Positioning'!H19","v":0},{"$f":"'Bluetooth Indoor Positioning'!E19","v":0},{"$f":"'Bluetooth Indoor Positioning'!J19","v":0},{"$f":"'Bluetooth Indoor Positioning'!K19","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F19","v":0},{"$f":"'Bluetooth Indoor Positioning'!M19","v":0},{"$f":"'Bluetooth Indoor Positioning'!N19","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D19=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C20","v":91020},{"$f":"'Bluetooth Indoor Positioning'!A20","v":"BPBi-01"},{"$f":"'Bluetooth Indoor Positioning'!B20","v":"25+ pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon ordered in one lot."},{"$f":"'Bluetooth Indoor Positioning'!H20","v":0},{"$f":"'Bluetooth Indoor Positioning'!E20","v":0},{"$f":"'Bluetooth Indoor Positioning'!J20","v":0},{"$f":"'Bluetooth Indoor Positioning'!K20","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F20","v":0},{"$f":"'Bluetooth Indoor Positioning'!M20","v":0},{"$f":"'Bluetooth Indoor Positioning'!N20","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D20=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C21","v":91100},{"$f":"'Bluetooth Indoor Positioning'!A21","v":"BPBx-01"},{"$f":"'Bluetooth Indoor Positioning'!B21","v":"1-5 pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon."},{"$f":"'Bluetooth Indoor Positioning'!H21","v":0},{"$f":"'Bluetooth Indoor Positioning'!E21","v":0},{"$f":"'Bluetooth Indoor Positioning'!J21","v":0},{"$f":"'Bluetooth Indoor Positioning'!K21","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F21","v":0},{"$f":"'Bluetooth Indoor Positioning'!M21","v":0},{"$f":"'Bluetooth Indoor Positioning'!N21","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D21=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C22","v":91110},{"$f":"'Bluetooth Indoor Positioning'!A22","v":"BPBx-01"},{"$f":"'Bluetooth Indoor Positioning'!B22","v":"6-25 pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon ordered in one lot."},{"$f":"'Bluetooth Indoor Positioning'!H22","v":0},{"$f":"'Bluetooth Indoor Positioning'!E22","v":0},{"$f":"'Bluetooth Indoor Positioning'!J22","v":0},{"$f":"'Bluetooth Indoor Positioning'!K22","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F22","v":0},{"$f":"'Bluetooth Indoor Positioning'!M22","v":0},{"$f":"'Bluetooth Indoor Positioning'!N22","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D22=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C23","v":91120},{"$f":"'Bluetooth Indoor Positioning'!A23","v":"BPBx-01"},{"$f":"'Bluetooth Indoor Positioning'!B23","v":"25+ pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon ordered in one lot."},{"$f":"'Bluetooth Indoor Positioning'!H23","v":0},{"$f":"'Bluetooth Indoor Positioning'!E23","v":0},{"$f":"'Bluetooth Indoor Positioning'!J23","v":0},{"$f":"'Bluetooth Indoor Positioning'!K23","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F23","v":0},{"$f":"'Bluetooth Indoor Positioning'!M23","v":0},{"$f":"'Bluetooth Indoor Positioning'!N23","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D23=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!A24","v":"Power Supplies for Bluetooth Position Beacons"},null,null,{"$f":"SUM(D63:D65)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C25","v":92005},{"$f":"'Bluetooth Indoor Positioning'!A25","v":"BPB Power Supply EU"},{"$f":"'Bluetooth Indoor Positioning'!B25","v":"5VDC wall plug 110-240 VAC power supply (EU two pin plugs) for all Bluetooth Beacons types."},{"$f":"'Bluetooth Indoor Positioning'!H25","v":0},{"$f":"'Bluetooth Indoor Positioning'!E25","v":0},{"$f":"'Bluetooth Indoor Positioning'!J25","v":0},{"$f":"'Bluetooth Indoor Positioning'!K25","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F25","v":0},{"$f":"'Bluetooth Indoor Positioning'!M25","v":0},{"$f":"'Bluetooth Indoor Positioning'!N25","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D25=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F63-O63","v":0},{"$f":"F63-(F63*M63)","v":0},{"$f":"J63-Q63","v":0},{"$f":"J63-(J63*M63)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C26","v":92006},{"$f":"'Bluetooth Indoor Positioning'!A26","v":"BPB Power Supply UK"},{"$f":"'Bluetooth Indoor Positioning'!B26","v":"5VDC wall plug 110-240 VAC power supply (UK three pin plugs) for all Bluetooth Beacons types."},{"$f":"'Bluetooth Indoor Positioning'!H26","v":0},{"$f":"'Bluetooth Indoor Positioning'!E26","v":0},{"$f":"'Bluetooth Indoor Positioning'!J26","v":0},{"$f":"'Bluetooth Indoor Positioning'!K26","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F26","v":0},{"$f":"'Bluetooth Indoor Positioning'!M26","v":0},{"$f":"'Bluetooth Indoor Positioning'!N26","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D26=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C27","v":92007},{"$f":"'Bluetooth Indoor Positioning'!A27","v":"BPB Power Supply US"},{"$f":"'Bluetooth Indoor Positioning'!B27","v":"5VDC wall plug 110-240 VAC power supply (US two pin plugs) for all Bluetooth Beacons types."},{"$f":"'Bluetooth Indoor Positioning'!H27","v":0},{"$f":"'Bluetooth Indoor Positioning'!E27","v":0},{"$f":"'Bluetooth Indoor Positioning'!J27","v":0},{"$f":"'Bluetooth Indoor Positioning'!K27","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F27","v":0},{"$f":"'Bluetooth Indoor Positioning'!M27","v":0},{"$f":"'Bluetooth Indoor Positioning'!N27","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D27=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!A28","v":"Bluetooth Tracking Devices and Accessories"},null,null,{"$f":"SUM(D67:D69)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C29","v":93001},{"$f":"'Bluetooth Indoor Positioning'!A29","v":"BSA-93001"},{"$f":"'Bluetooth Indoor Positioning'!B29","v":"Bluetooth Side Adapter for Motorola MOTOTRBO and Motorola MTP850S radios"},{"$f":"'Bluetooth Indoor Positioning'!H29","v":0},{"$f":"'Bluetooth Indoor Positioning'!E29","v":0},{"$f":"'Bluetooth Indoor Positioning'!J29","v":0},{"$f":"'Bluetooth Indoor Positioning'!K29","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F29","v":0},{"$f":"'Bluetooth Indoor Positioning'!M29","v":0},{"$f":"'Bluetooth Indoor Positioning'!N29","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D29=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F67-O67","v":0},{"$f":"F67-(F67*M67)","v":0},{"$f":"J67-Q67","v":0},{"$f":"J67-(J67*M67)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C30","v":93001},{"$f":"'Bluetooth Indoor Positioning'!A30","v":"BSA-93003"},{"$f":"'Bluetooth Indoor Positioning'!B30","v":"Bluetooth Side Adapter for Kenwood NexEdge. 2-pin connector."},{"$f":"'Bluetooth Indoor Positioning'!H30","v":0},{"$f":"'Bluetooth Indoor Positioning'!E30","v":0},{"$f":"'Bluetooth Indoor Positioning'!J30","v":0},{"$f":"'Bluetooth Indoor Positioning'!K30","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F30","v":0},{"$f":"'Bluetooth Indoor Positioning'!M30","v":0},{"$f":"'Bluetooth Indoor Positioning'!N30","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D30=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F68-O68","v":0},{"$f":"F68-(F68*M68)","v":0},{"$f":"J68-Q68","v":0},{"$f":"J68-(J68*M68)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C31","v":93011},{"$f":"'Bluetooth Indoor Positioning'!A31","v":"BT-PTT"},{"$f":"'Bluetooth Indoor Positioning'!B31","v":"Bluetooth PTT button for paring with BSA-93001"},{"$f":"'Bluetooth Indoor Positioning'!H31","v":0},{"$f":"'Bluetooth Indoor Positioning'!E31","v":0},{"$f":"'Bluetooth Indoor Positioning'!J31","v":0},{"$f":"'Bluetooth Indoor Positioning'!K31","v":0},null,{"$f":"'Bluetooth Indoor Positioning'!F31","v":0},{"$f":"'Bluetooth Indoor Positioning'!M31","v":0},{"$f":"'Bluetooth Indoor Positioning'!N31","v":0},null,{"$f":"IF('Bluetooth Indoor Positioning'!D31=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Panic Alerting'!A11","v":"Panic Alerting System"},null,null,{"$f":"SUM(D71:D74)","v":0}]
[{"$f":"'Panic Alerting'!C12","v":42201},{"$f":"'Panic Alerting'!A12","v":"Central Receiver"},{"$f":"'Panic Alerting'!B12","v":"- LAN Interface\n- Backup Battery\n- Capacity for 50 Panic Buttons\n- 230 VAC build-in power supply"},{"$f":"'Panic Alerting'!H12","v":0},{"$f":"'Panic Alerting'!E12","v":0},{"$f":"'Panic Alerting'!J12","v":0},{"$f":"'Panic Alerting'!K12","v":0},null,{"$f":"'Panic Alerting'!F12","v":0},{"$f":"'Panic Alerting'!M12","v":0},{"$f":"'Panic Alerting'!N12","v":0},null,{"$f":"IF('Panic Alerting'!D12=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F71-O71","v":0},{"$f":"F71-(F71*M71)","v":0},{"$f":"J71-Q71","v":0},{"$f":"J71-(J71*M71)","v":0}]
[{"$f":"'Panic Alerting'!C13","v":42114},{"$f":"'Panic Alerting'!A13","v":"Panic Alarm Button"},{"$f":"'Panic Alerting'!B13","v":"Desk mounted or arm wrest carried."},{"$f":"'Panic Alerting'!H13","v":0},{"$f":"'Panic Alerting'!E13","v":0},{"$f":"'Panic Alerting'!J13","v":0},{"$f":"'Panic Alerting'!K13","v":0},null,{"$f":"'Panic Alerting'!F13","v":0},{"$f":"'Panic Alerting'!M13","v":0},{"$f":"'Panic Alerting'!N13","v":0},null,{"$f":"IF('Panic Alerting'!D13=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Panic Alerting'!C14","v":42115},{"$f":"'Panic Alerting'!A14","v":"Panic Alarm Button"},{"$f":"'Panic Alerting'!B14","v":"Wall mounted."},{"$f":"'Panic Alerting'!H14","v":0},{"$f":"'Panic Alerting'!E14","v":0},{"$f":"'Panic Alerting'!J14","v":0},{"$f":"'Panic Alerting'!K14","v":0},null,{"$f":"'Panic Alerting'!F14","v":0},{"$f":"'Panic Alerting'!M14","v":0},{"$f":"'Panic Alerting'!N14","v":0},null,{"$f":"IF('Panic Alerting'!D14=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'Panic Alerting'!C15","v":42350},{"$f":"'Panic Alerting'!A15","v":"PC-350 Unit Box "},{"$f":"'Panic Alerting'!B15","v":"Interface to Alarm Control System. Including Panic Alarm Listener for Alarm Control System, Part No. 37010."},{"$f":"'Panic Alerting'!H15","v":0},{"$f":"'Panic Alerting'!E15","v":0},{"$f":"'Panic Alerting'!J15","v":0},{"$f":"'Panic Alerting'!K15","v":0},null,{"$f":"'Panic Alerting'!F15","v":0},{"$f":"'Panic Alerting'!M15","v":0},{"$f":"'Panic Alerting'!N15","v":0},null,{"$f":"IF('Panic Alerting'!D15=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Panic Alerting'!A16","v":"Panic Alerting Demo Kit & Accessories"},null,null,{"$f":"SUM(D76:D77)","v":0}]
[{"$f":"'Panic Alerting'!C17","v":44000},{"$f":"'Panic Alerting'!A17","v":"Panic Alerting Demo Kit"},{"$f":"'Panic Alerting'!B17","v":"Including:\n- 1 pc. Central Receiver\n- 2 pc. Panic Alerting Buttons incl. Part No. 42114 and 42115\n- 1 pc. PC-350 Unit Box\n- Demo License for Alarm Control System software including Panic Alarm Listener"},{"$f":"'Panic Alerting'!H17","v":0},{"$f":"'Panic Alerting'!E17","v":0},{"$f":"'Panic Alerting'!J17","v":0},{"$f":"'Panic Alerting'!K17","v":0},null,{"$f":"'Panic Alerting'!F17","v":0},{"$f":"'Panic Alerting'!M17","v":0},{"$f":"'Panic Alerting'!N17","v":0},null,{"$f":"IF('Panic Alerting'!D17=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F76-O76","v":0},{"$f":"F76-(F76*M76)","v":0},{"$f":"J76-Q76","v":0},{"$f":"J76-(J76*M76)","v":0}]
[{"$f":"'Panic Alerting'!C18","v":42139},{"$f":"'Panic Alerting'!A18","v":"USB Interface"},{"$f":"'Panic Alerting'!B18","v":"For registration of panic buttons in Central Receivers using a PC"},{"$f":"'Panic Alerting'!H18","v":0},{"$f":"'Panic Alerting'!E18","v":0},{"$f":"'Panic Alerting'!J18","v":0},{"$f":"'Panic Alerting'!K18","v":0},null,{"$f":"'Panic Alerting'!F18","v":0},{"$f":"'Panic Alerting'!M18","v":0},{"$f":"'Panic Alerting'!N18","v":0},null,{"$f":"IF('Panic Alerting'!D18=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!A11","v":"Remote Telemetry & Control Unit (RTCU)"},null,null,{"$f":"SUM(D79:D82)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C12","v":82009},{"$f":"'TETRA Telemetry - RTCU'!A12","v":"RTCU AX9"},{"$f":"'TETRA Telemetry - RTCU'!B12","v":"1-2 pcs. RTCU Units AX9 (price for each unit)\n- TETRA PEI interface for Sepura and Motorola radios\n- 5 Digital Alarm Input\n- 4 Relay Output\n- 4 Analog Input\n- Fail-over to build-in GSM/SMS communication\n- MODBUS connection for I/O Expansion Units, Part No. 38041 and 38065\n- IP67 enclosure\n- Build-in 230 VAC power supply"},{"$f":"'TETRA Telemetry - RTCU'!H12","v":0},{"$f":"'TETRA Telemetry - RTCU'!E12","v":0},{"$f":"'TETRA Telemetry - RTCU'!J12","v":0},{"$f":"'TETRA Telemetry - RTCU'!K12","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F12","v":0},{"$f":"'TETRA Telemetry - RTCU'!M12","v":0},{"$f":"'TETRA Telemetry - RTCU'!N12","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D12=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F79-O79","v":0},{"$f":"F79-(F79*M79)","v":0},{"$f":"J79-Q79","v":0},{"$f":"J79-(J79*M79)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C13","v":82010},{"$f":"'TETRA Telemetry - RTCU'!A13","v":"RTCU AX9"},{"$f":"'TETRA Telemetry - RTCU'!B13","v":"3-10 pcs. RTCU Units AX9 (price for each unit when ordering in one lot)\n- Specification as above"},{"$f":"'TETRA Telemetry - RTCU'!H13","v":0},{"$f":"'TETRA Telemetry - RTCU'!E13","v":0},{"$f":"'TETRA Telemetry - RTCU'!J13","v":0},{"$f":"'TETRA Telemetry - RTCU'!K13","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F13","v":0},{"$f":"'TETRA Telemetry - RTCU'!M13","v":0},{"$f":"'TETRA Telemetry - RTCU'!N13","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D13=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C14","v":82019},{"$f":"'TETRA Telemetry - RTCU'!A14","v":"RTCU Fire Station"},{"$f":"'TETRA Telemetry - RTCU'!B14","v":"RTCU Unit especially developed for Fire Stations. Including:\n- Support for Motorola TETRA Call-out messages\n- Relay connection to PA system"},{"$f":"'TETRA Telemetry - RTCU'!H14","v":0},{"$f":"'TETRA Telemetry - RTCU'!E14","v":0},{"$f":"'TETRA Telemetry - RTCU'!J14","v":0},{"$f":"'TETRA Telemetry - RTCU'!K14","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F14","v":0},{"$f":"'TETRA Telemetry - RTCU'!M14","v":0},{"$f":"'TETRA Telemetry - RTCU'!N14","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D14=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C15","v":82025},{"$f":"'TETRA Telemetry - RTCU'!A15","v":"RTCU VGA+Audio"},{"$f":"'TETRA Telemetry - RTCU'!B15","v":"Unit for showing fire station incidents on VGS monitors as well as incident message audio synthesis. Must be connection to one RTCU Fire Station unit (part no. 82019)."},{"$f":"'TETRA Telemetry - RTCU'!H15","v":0},{"$f":"'TETRA Telemetry - RTCU'!E15","v":0},{"$f":"'TETRA Telemetry - RTCU'!J15","v":0},{"$f":"'TETRA Telemetry - RTCU'!K15","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F15","v":0},{"$f":"'TETRA Telemetry - RTCU'!M15","v":0},{"$f":"'TETRA Telemetry - RTCU'!N15","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D15=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!A16","v":"RTCU I/O Expansion Units"},null,null,{"$f":"SUM(D84:D85)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C17","v":38041},{"$f":"'TETRA Telemetry - RTCU'!A17","v":"RTCU Expansion 14xDI"},{"$f":"'TETRA Telemetry - RTCU'!B17","v":"MODBUS I/O Expansion Unit:\n- 14 Digital Inputs (Isolated)\n- 12-24 VDC external supply needed\n- For connection to Part No. 82009"},{"$f":"'TETRA Telemetry - RTCU'!H17","v":0},{"$f":"'TETRA Telemetry - RTCU'!E17","v":0},{"$f":"'TETRA Telemetry - RTCU'!J17","v":0},{"$f":"'TETRA Telemetry - RTCU'!K17","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F17","v":0},{"$f":"'TETRA Telemetry - RTCU'!M17","v":0},{"$f":"'TETRA Telemetry - RTCU'!N17","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D17=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F84-O84","v":0},{"$f":"F84-(F84*M84)","v":0},{"$f":"J84-Q84","v":0},{"$f":"J84-(J84*M84)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C18","v":38065},{"$f":"'TETRA Telemetry - RTCU'!A18","v":"RTCU Expansion 4xDI"},{"$f":"'TETRA Telemetry - RTCU'!B18","v":"MODBUS I/O Expansion Unit:\n- 4 Digital Inputs\n- 5 Digital Relay Outputs (250 V/5A)\n- 12-24 VDC external supply needed\n- For connection to Part No. 82009"},{"$f":"'TETRA Telemetry - RTCU'!H18","v":0},{"$f":"'TETRA Telemetry - RTCU'!E18","v":0},{"$f":"'TETRA Telemetry - RTCU'!J18","v":0},{"$f":"'TETRA Telemetry - RTCU'!K18","v":0},null,{"$f":"'TETRA Telemetry - RTCU'!F18","v":0},{"$f":"'TETRA Telemetry - RTCU'!M18","v":0},{"$f":"'TETRA Telemetry - RTCU'!N18","v":0},null,{"$f":"IF('TETRA Telemetry - RTCU'!D18=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!A11","v":"MOTOTRBO Phone Interconnect (RBX)"},null,null,{"$f":"SUM(D87:D90)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C12","v":"T-02000"},{"$f":"'MOTOTRBO Phone & Voice'!A12","v":"RPX +Plus"},{"$f":"'MOTOTRBO Phone & Voice'!B12","v":"RBX +Plus Core Platform (without PC), including:\n- RBX Core Software\n- 1 Voice Path\n- 1 TalkGroup\n- First years Support & Software Updates"},{"$f":"'MOTOTRBO Phone & Voice'!H12","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E12","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J12","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K12","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F12","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M12","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N12","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D12=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F87-O87","v":0},{"$f":"F87-(F87*M87)","v":0},{"$f":"J87-Q87","v":0},{"$f":"J87-(J87*M87)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C13","v":"T-02001"},{"$f":"'MOTOTRBO Phone & Voice'!A13","v":"RBX +Plus Subscriber License"},{"$f":"'MOTOTRBO Phone & Voice'!B13","v":"RBX +Plus Subscriber License (i.e. radio Users)\nEnables PBX functionality on MOTOTRBO radios. Motorola Generic Option Board / GOB (Motorola part no. PMLN5496AS) must be installed in the radio."},{"$f":"'MOTOTRBO Phone & Voice'!H13","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E13","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J13","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K13","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F13","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M13","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N13","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D13=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C14","v":"T-03001"},{"$f":"'MOTOTRBO Phone & Voice'!A14","v":"Talkgroup License"},{"$f":"'MOTOTRBO Phone & Voice'!B14","v":"Allows phone users to call a radio group."},{"$f":"'MOTOTRBO Phone & Voice'!H14","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E14","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J14","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K14","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F14","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M14","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N14","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D14=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C15","v":"T-04001"},{"$f":"'MOTOTRBO Phone & Voice'!A15","v":"Voicepath License"},{"$f":"'MOTOTRBO Phone & Voice'!B15","v":"Enables additional concurrent radio-phone call.\nAn additional audio card (part no. 70002) for the PC running the RBX must be purchased."},{"$f":"'MOTOTRBO Phone & Voice'!H15","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E15","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J15","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K15","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F15","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M15","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N15","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D15=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!A16","v":"RBX Phone Interconnect System Premium Upgrades"},null,null,{"$f":"SUM(D92:D96)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C17","v":"T-06100"},{"$f":"'MOTOTRBO Phone & Voice'!A17","v":"Premium Upgrade Pack"},{"$f":"'MOTOTRBO Phone & Voice'!B17","v":"Includes: \n- Call Recording (part no. T-06101)\n- User Provisioning (part no. T-06103)\n- Password Protection (part no. T-06104)"},{"$f":"'MOTOTRBO Phone & Voice'!H17","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E17","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J17","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K17","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F17","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M17","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N17","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D17=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F92-O92","v":0},{"$f":"F92-(F92*M92)","v":0},{"$f":"J92-Q92","v":0},{"$f":"J92-(J92*M92)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C18","v":"T-06101"},{"$f":"'MOTOTRBO Phone & Voice'!A18","v":"Call Recording"},{"$f":"'MOTOTRBO Phone & Voice'!B18","v":"Records all radio transmitions in a radio channel."},{"$f":"'MOTOTRBO Phone & Voice'!H18","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E18","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J18","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K18","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F18","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M18","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N18","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D18=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C19","v":"T-06103"},{"$f":"'MOTOTRBO Phone & Voice'!A19","v":"User Provisioning"},{"$f":"'MOTOTRBO Phone & Voice'!B19","v":"Manages the RBX contact list of every subscriber."},{"$f":"'MOTOTRBO Phone & Voice'!H19","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E19","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J19","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K19","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F19","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M19","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N19","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D19=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C20","v":"T-06104"},{"$f":"'MOTOTRBO Phone & Voice'!A20","v":"Password Protection"},{"$f":"'MOTOTRBO Phone & Voice'!B20","v":"Requires passwords for users to place phone calls."},{"$f":"'MOTOTRBO Phone & Voice'!H20","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E20","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J20","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K20","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F20","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M20","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N20","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D20=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C21","v":"T-06300"},{"$f":"'MOTOTRBO Phone & Voice'!A21","v":"IP Site Connect Roaming"},{"$f":"'MOTOTRBO Phone & Voice'!B21","v":"Allows users to roam from site to site and maintain telephone interconnect functionality. A minimum of 2 hours of Professional Services per repeater are required to design, configure and provision the system."},{"$f":"'MOTOTRBO Phone & Voice'!H21","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E21","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J21","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K21","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F21","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M21","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N21","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D21=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!A22","v":"MOTOTRBO Voice Logging Solution (R2R)"},null,null,{"$f":"SUM(D98:D99)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C23","v":"T-03003"},{"$f":"'MOTOTRBO Phone & Voice'!A23","v":"R2R Recording Core Platform"},{"$f":"'MOTOTRBO Phone & Voice'!B23","v":"Includes:\n- R2R Recording Core Software\n- 1 pcs. R2R Recording Voice Path License"},{"$f":"'MOTOTRBO Phone & Voice'!H23","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E23","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J23","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K23","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F23","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M23","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N23","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D23=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F98-O98","v":0},{"$f":"F98-(F98*M98)","v":0},{"$f":"J98-Q98","v":0},{"$f":"J98-(J98*M98)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C24","v":"T-03002"},{"$f":"'MOTOTRBO Phone & Voice'!A24","v":"R2R Recording Voice Path License"},{"$f":"'MOTOTRBO Phone & Voice'!B24","v":"Additional Voice Path licenses for voice recording one radio channel.\nAn additional audio card (part no. 70002) for the PC running the R2R must be purchased."},{"$f":"'MOTOTRBO Phone & Voice'!H24","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E24","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J24","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K24","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F24","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M24","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N24","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D24=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!A25","v":"RBX and R2R Hardware"},null,null,{"$f":"SUM(D101:D105)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C26","v":70000},{"$f":"'MOTOTRBO Phone & Voice'!A26","v":"PC Pack for RBX and R2R"},{"$f":"'MOTOTRBO Phone & Voice'!B26","v":"PC Pack including:\n- Desktop PC (Dell or HP) with UK keyboard and mouse\n- Windows 7 operating system\n- Preinstalld RBX/R2R software\n- PCI Audio card for one Voice Path (part no. 70002)\n- RBX/R2R MotoTrbo audio cable connector (part no. 70005)"},{"$f":"'MOTOTRBO Phone & Voice'!H26","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E26","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J26","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K26","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F26","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M26","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N26","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D26=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F101-O101","v":0},{"$f":"F101-(F101*M101)","v":0},{"$f":"J101-Q101","v":0},{"$f":"J101-(J101*M101)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C27","v":70002},{"$f":"'MOTOTRBO Phone & Voice'!A27","v":"Additional Audio Card"},{"$f":"'MOTOTRBO Phone & Voice'!B27","v":"PCI Audio card for one additional Voice Path for RBX or R2R"},{"$f":"'MOTOTRBO Phone & Voice'!H27","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E27","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J27","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K27","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F27","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M27","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N27","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D27=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C28","v":70003},{"$f":"'MOTOTRBO Phone & Voice'!A28","v":"Analog to SIP Telephony Gateway"},{"$f":"'MOTOTRBO Phone & Voice'!B28","v":"Connects RBX to analog phone systems."},{"$f":"'MOTOTRBO Phone & Voice'!H28","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E28","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J28","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K28","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F28","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M28","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N28","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D28=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C29","v":70004},{"$f":"'MOTOTRBO Phone & Voice'!A29","v":"GSM Gateway"},{"$f":"'MOTOTRBO Phone & Voice'!B29","v":"Connects RBX through cellphone networks."},{"$f":"'MOTOTRBO Phone & Voice'!H29","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E29","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J29","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K29","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F29","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M29","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N29","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D29=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C30","v":70005},{"$f":"'MOTOTRBO Phone & Voice'!A30","v":"Audio Cable Connector"},{"$f":"'MOTOTRBO Phone & Voice'!B30","v":"RBX/R2R MotoTrbo audio cable connector"},{"$f":"'MOTOTRBO Phone & Voice'!H30","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E30","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J30","v":0},{"$f":"'MOTOTRBO Phone & Voice'!K30","v":0},null,{"$f":"'MOTOTRBO Phone & Voice'!F30","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M30","v":0},{"$f":"'MOTOTRBO Phone & Voice'!N30","v":0},null,{"$f":"IF('MOTOTRBO Phone & Voice'!D30=\"HW\",HWdiscount,Discount)","v":0.1},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!A11","v":"GPS Mapping Solution"},null,null,{"$f":"SUM(D107:D110)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C12","v":"N-4143C1"},{"$f":"'MOTOTRBO GPS Mapping'!A12","v":"neoNytro Standalone"},{"$f":"'MOTOTRBO GPS Mapping'!B12","v":"neoNytro Standalone, including:\n- License for one workstation\n- Connection of one MOTOTRBO radio\n- First years Support & Software Upgrade"},{"$f":"'MOTOTRBO GPS Mapping'!H12","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E12","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J12","v":0},{"$f":"'MOTOTRBO GPS Mapping'!K12","v":0},null,{"$f":"'MOTOTRBO GPS Mapping'!F12","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M12","v":0},{"$f":"'MOTOTRBO GPS Mapping'!N12","v":0},null,{"$f":"IF('MOTOTRBO GPS Mapping'!D12=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F107-O107","v":0},{"$f":"F107-(F107*M107)","v":0},{"$f":"J107-Q107","v":0},{"$f":"J107-(J107*M107)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C13","v":"N-4144E2"},{"$f":"'MOTOTRBO GPS Mapping'!A13","v":"neoConneX"},{"$f":"'MOTOTRBO GPS Mapping'!B13","v":"neoConneX, including:\n- Client/Server solution\n- For MotoTrbo Connect Plus\n- License for 25 radios\n- First years Support & Software Upgrade"},{"$f":"'MOTOTRBO GPS Mapping'!H13","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E13","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J13","v":0},{"$f":"'MOTOTRBO GPS Mapping'!K13","v":0},null,{"$f":"'MOTOTRBO GPS Mapping'!F13","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M13","v":0},{"$f":"'MOTOTRBO GPS Mapping'!N13","v":0},null,{"$f":"IF('MOTOTRBO GPS Mapping'!D13=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C14","v":"N-4145W1"},{"$f":"'MOTOTRBO GPS Mapping'!A14","v":"Additional Users"},{"$f":"'MOTOTRBO GPS Mapping'!B14","v":"Additional neoConneX radio users (in sets of 5)"},{"$f":"'MOTOTRBO GPS Mapping'!H14","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E14","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J14","v":0},{"$f":"'MOTOTRBO GPS Mapping'!K14","v":0},null,{"$f":"'MOTOTRBO GPS Mapping'!F14","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M14","v":0},{"$f":"'MOTOTRBO GPS Mapping'!N14","v":0},null,{"$f":"IF('MOTOTRBO GPS Mapping'!D14=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C15","v":"N-4145W1"},{"$f":"'MOTOTRBO GPS Mapping'!A15","v":"neoConneX WEB map"},{"$f":"'MOTOTRBO GPS Mapping'!B15","v":"neoConneX WEB map solution. Add-on to neoConneX"},{"$f":"'MOTOTRBO GPS Mapping'!H15","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E15","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J15","v":0},{"$f":"'MOTOTRBO GPS Mapping'!K15","v":0},null,{"$f":"'MOTOTRBO GPS Mapping'!F15","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M15","v":0},{"$f":"'MOTOTRBO GPS Mapping'!N15","v":0},null,{"$f":"IF('MOTOTRBO GPS Mapping'!D15=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!A11","v":"Centralized Lone Worker Software Package"},null,null,{"$f":"SUM(D112:D114)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C12","v":73501},{"$f":"'Staff Safety CLW & MDN'!A12","v":"Centralized Lone Worker Package"},{"$f":"'Staff Safety CLW & MDN'!B12","v":"Centralized Lone Worker Package (CLW), including:\n- 15 Users\n- Alarm Control System Lite software for CLW monitoring and automatic alarm dispatch on freely selected media (MOTOTRBO, TETRA, DECT, TEAM WiFi Phone or GSM)\n- First year Support & Software Upgrade License"},{"$f":"'Staff Safety CLW & MDN'!H12","v":0},{"$f":"'Staff Safety CLW & MDN'!E12","v":0},{"$f":"'Staff Safety CLW & MDN'!J12","v":0},{"$f":"'Staff Safety CLW & MDN'!K12","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F12","v":0},{"$f":"'Staff Safety CLW & MDN'!M12","v":0},{"$f":"'Staff Safety CLW & MDN'!N12","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D12=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F112-O112","v":0},{"$f":"F112-(F112*M112)","v":0},{"$f":"J112-Q112","v":0},{"$f":"J112-(J112*M112)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C13","v":73510},{"$f":"'Staff Safety CLW & MDN'!A13","v":"Additional CLW Users"},{"$f":"'Staff Safety CLW & MDN'!B13","v":"Number of CLW Users for purchase"},{"$f":"'Staff Safety CLW & MDN'!H13","v":0},{"$f":"'Staff Safety CLW & MDN'!E13","v":0},{"$f":"'Staff Safety CLW & MDN'!J13","v":0},{"$f":"'Staff Safety CLW & MDN'!K13","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F13","v":0},{"$f":"'Staff Safety CLW & MDN'!M13","v":0},{"$f":"'Staff Safety CLW & MDN'!N13","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D13=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C14","v":73515},{"$f":"'Staff Safety CLW & MDN'!A14","v":"CLW to ACS +Plus Upgrade"},{"$f":"'Staff Safety CLW & MDN'!B14","v":"Upgrading from the MDN alarm dispatch to the full solution (upgrade from order no 73501 to 73001)"},{"$f":"'Staff Safety CLW & MDN'!H14","v":0},{"$f":"'Staff Safety CLW & MDN'!E14","v":0},{"$f":"'Staff Safety CLW & MDN'!J14","v":0},{"$f":"'Staff Safety CLW & MDN'!K14","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F14","v":0},{"$f":"'Staff Safety CLW & MDN'!M14","v":0},{"$f":"'Staff Safety CLW & MDN'!N14","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D14=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!A15","v":"MOTOTRBO Man Down Notifier Package (MDN)"},null,null,{"$f":"SUM(D116:D118)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C16","v":73401},{"$f":"'Staff Safety CLW & MDN'!A16","v":"Man Down Notifier"},{"$f":"'Staff Safety CLW & MDN'!B16","v":"Man Down Notifier Package (MDN), including:\n- Alarm Control System software for MDN monitoring and automatic alarm dispatch on MOTOTRBO radios\n- MOTOTRBO radio support only\n- First year Support & Software Upgrade License"},{"$f":"'Staff Safety CLW & MDN'!H16","v":0},{"$f":"'Staff Safety CLW & MDN'!E16","v":0},{"$f":"'Staff Safety CLW & MDN'!J16","v":0},{"$f":"'Staff Safety CLW & MDN'!K16","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F16","v":0},{"$f":"'Staff Safety CLW & MDN'!M16","v":0},{"$f":"'Staff Safety CLW & MDN'!N16","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D16=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F116-O116","v":0},{"$f":"F116-(F116*M116)","v":0},{"$f":"J116-Q116","v":0},{"$f":"J116-(J116*M116)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C17","v":73420},{"$f":"'Staff Safety CLW & MDN'!A17","v":"Additional MDN Users"},{"$f":"'Staff Safety CLW & MDN'!B17","v":"Number of MDN Users for purchase"},{"$f":"'Staff Safety CLW & MDN'!H17","v":0},{"$f":"'Staff Safety CLW & MDN'!E17","v":0},{"$f":"'Staff Safety CLW & MDN'!J17","v":0},{"$f":"'Staff Safety CLW & MDN'!K17","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F17","v":0},{"$f":"'Staff Safety CLW & MDN'!M17","v":0},{"$f":"'Staff Safety CLW & MDN'!N17","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D17=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C18","v":73021},{"$f":"'Staff Safety CLW & MDN'!A18","v":"MDN to ACS +Plus Upgrade"},{"$f":"'Staff Safety CLW & MDN'!B18","v":"Upgrading from the MDN alarm dispatch to the full solution (upgrade from order no. 73410 to 73001)"},{"$f":"'Staff Safety CLW & MDN'!H18","v":0},{"$f":"'Staff Safety CLW & MDN'!E18","v":0},{"$f":"'Staff Safety CLW & MDN'!J18","v":0},{"$f":"'Staff Safety CLW & MDN'!K18","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F18","v":0},{"$f":"'Staff Safety CLW & MDN'!M18","v":0},{"$f":"'Staff Safety CLW & MDN'!N18","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D18=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!A19","v":"CLW and MDN PC Hardware Pack"},null,null,{"$f":"SUM(D120:D120)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C20","v":70001},{"$f":"'Staff Safety CLW & MDN'!A20","v":"PC Pack for CLW or MDN"},{"$f":"'Staff Safety CLW & MDN'!B20","v":"PC Pack including:\n- Desktop PC (Dell or HP) with UK keyboard and mouse\n- Windows 7 operating system\n- Preinstalld CLW/MDN software"},{"$f":"'Staff Safety CLW & MDN'!H20","v":0},{"$f":"'Staff Safety CLW & MDN'!E20","v":0},{"$f":"'Staff Safety CLW & MDN'!J20","v":0},{"$f":"'Staff Safety CLW & MDN'!K20","v":0},null,{"$f":"'Staff Safety CLW & MDN'!F20","v":0},{"$f":"'Staff Safety CLW & MDN'!M20","v":0},{"$f":"'Staff Safety CLW & MDN'!N20","v":0},null,{"$f":"IF('Staff Safety CLW & MDN'!D20=\"HW\",HWdiscount,Discount)","v":0.1},{"$f":"F120-O120","v":0},{"$f":"F120-(F120*M120)","v":0},{"$f":"J120-Q120","v":0},{"$f":"J120-(J120*M120)","v":0}]
["Products Total",null,null,{"$f":"SUM(D3:D120)","v":0},null,{"$f":"SUM(F3:F118)","v":0},{"$f":"SUM(G3:G118)","v":0},null,null,{"$f":"SUM(J3:J118)","v":0},{"$f":"SUM(K3:K118)","v":0},null,null,{"$f":"SUM(N3:N118)","v":0},{"$f":"SUM(O3:O118)","v":0},{"$f":"SUM(P3:P118)","v":0},{"$f":"SUM(Q3:Q118)","v":0}]
[null,null,null,{"$f":"D121","v":0}]
["Professional Services",null,{"$f":"D160","v":0},{"$f":"D2","v":"Qty."},{"$f":"E2","v":"Unit RRP (EUR)"},"Total RRP (EUR)",null,null,{"$f":"I2","v":"Unit RRP (AUD)"},"Total RRP (AUD)",null,null,{"$f":"M2","v":"Discount"},null,"XXXX Cost (EUR)",null,"XXXX Cost (AUD)"]
["Alarm Control System (ACS)",null,null,{"$f":"SUM(D125:D128)","v":0}]
[{"$f":"'Alarm Control System'!C67","v":55000},{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},{"$f":"'Alarm Control System'!H67","v":0},{"$f":"'Alarm Control System'!E67","v":0},{"$f":"'Alarm Control System'!J67","v":0},null,null,{"$f":"'Alarm Control System'!F67","v":0},{"$f":"'Alarm Control System'!M67","v":0},null,null,{"$f":"IF('Alarm Control System'!D67=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F125-O125","v":0},{"$f":"F125-(F125*M125)","v":0},{"$f":"J125-Q125","v":0},{"$f":"J125-(J125*M125)","v":0}]
[{"$f":"'Alarm Control System'!C68","v":55001},{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},{"$f":"'Alarm Control System'!H68","v":0},{"$f":"'Alarm Control System'!E68","v":0},{"$f":"'Alarm Control System'!J68","v":0},null,null,{"$f":"'Alarm Control System'!F68","v":0},{"$f":"'Alarm Control System'!M68","v":0},null,null,{"$f":"IF('Alarm Control System'!D68=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C69","v":55002},{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},{"$f":"'Alarm Control System'!H69","v":0},{"$f":"'Alarm Control System'!E69","v":0},{"$f":"'Alarm Control System'!J69","v":0},null,null,{"$f":"'Alarm Control System'!F69","v":0},{"$f":"'Alarm Control System'!M69","v":0},null,null,{"$f":"IF('Alarm Control System'!D69=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C70","v":55005},{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'Alarm Control System'!H70","v":0},{"$f":"'Alarm Control System'!E70","v":0},{"$f":"'Alarm Control System'!J70","v":0},null,null,{"$f":"'Alarm Control System'!F70","v":0},{"$f":"'Alarm Control System'!M70","v":0},null,null,{"$f":"IF('Alarm Control System'!D70=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["Bluetooth Indoor Positioning System (IPS)",null,null,{"$f":"SUM(D130:D134)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C33","v":55000},{"$f":"'Bluetooth Indoor Positioning'!A33","v":"On-site Support"},{"$f":"'Bluetooth Indoor Positioning'!B33","v":"On-site support or training - 1/2 day"},{"$f":"'Bluetooth Indoor Positioning'!H33","v":0},{"$f":"'Bluetooth Indoor Positioning'!E33","v":0},{"$f":"'Bluetooth Indoor Positioning'!J33","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F33","v":0},{"$f":"'Bluetooth Indoor Positioning'!M33","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D33=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F130-O130","v":0},{"$f":"F130-(F130*M130)","v":0},{"$f":"J130-Q130","v":0},{"$f":"J130-(J130*M130)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C34","v":55001},{"$f":"'Bluetooth Indoor Positioning'!A34","v":"On-site Support"},{"$f":"'Bluetooth Indoor Positioning'!B34","v":"On-site support or training - full day"},{"$f":"'Bluetooth Indoor Positioning'!H34","v":0},{"$f":"'Bluetooth Indoor Positioning'!E34","v":0},{"$f":"'Bluetooth Indoor Positioning'!J34","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F34","v":0},{"$f":"'Bluetooth Indoor Positioning'!M34","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D34=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C35","v":55002},{"$f":"'Bluetooth Indoor Positioning'!A35","v":"On-site Support"},{"$f":"'Bluetooth Indoor Positioning'!B35","v":"On-site support or training - per hour"},{"$f":"'Bluetooth Indoor Positioning'!H35","v":0},{"$f":"'Bluetooth Indoor Positioning'!E35","v":0},{"$f":"'Bluetooth Indoor Positioning'!J35","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F35","v":0},{"$f":"'Bluetooth Indoor Positioning'!M35","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D35=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C36","v":55005},{"$f":"'Bluetooth Indoor Positioning'!A36","v":"Remote Support"},{"$f":"'Bluetooth Indoor Positioning'!B36","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'Bluetooth Indoor Positioning'!H36","v":0},{"$f":"'Bluetooth Indoor Positioning'!E36","v":0},{"$f":"'Bluetooth Indoor Positioning'!J36","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F36","v":0},{"$f":"'Bluetooth Indoor Positioning'!M36","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D36=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C37","v":55010},{"$f":"'Bluetooth Indoor Positioning'!A37","v":"IPS Site Survey"},{"$f":"'Bluetooth Indoor Positioning'!B37","v":"ZZZZZZ specialist conducting site survey to determin the positions and amount of Bluetooth Position Beacons needed. Price based on a per day rate."},{"$f":"'Bluetooth Indoor Positioning'!H37","v":0},{"$f":"'Bluetooth Indoor Positioning'!E37","v":0},{"$f":"'Bluetooth Indoor Positioning'!J37","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F37","v":0},{"$f":"'Bluetooth Indoor Positioning'!M37","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D37=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["Panic Alerting",null,null,{"$f":"SUM(D136:D139)","v":0}]
[{"$f":"'Panic Alerting'!C20","v":55000},{"$f":"'Panic Alerting'!A20","v":"On-site Support"},{"$f":"'Panic Alerting'!B20","v":"On-site support or training - 1/2 day"},{"$f":"'Panic Alerting'!H20","v":0},{"$f":"'Panic Alerting'!E20","v":0},{"$f":"'Panic Alerting'!J20","v":0},null,null,{"$f":"'Panic Alerting'!F20","v":0},{"$f":"'Panic Alerting'!M20","v":0},null,null,{"$f":"IF('Panic Alerting'!D20=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F136-O136","v":0},{"$f":"F136-(F136*M136)","v":0},{"$f":"J136-Q136","v":0},{"$f":"J136-(J136*M136)","v":0}]
[{"$f":"'Panic Alerting'!C21","v":55001},{"$f":"'Panic Alerting'!A21","v":"On-site Support"},{"$f":"'Panic Alerting'!B21","v":"On-site support or training - full day"},{"$f":"'Panic Alerting'!H21","v":0},{"$f":"'Panic Alerting'!E21","v":0},{"$f":"'Panic Alerting'!J21","v":0},null,null,{"$f":"'Panic Alerting'!F21","v":0},{"$f":"'Panic Alerting'!M21","v":0},null,null,{"$f":"IF('Panic Alerting'!D21=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Panic Alerting'!C22","v":55002},{"$f":"'Panic Alerting'!A22","v":"On-site Support"},{"$f":"'Panic Alerting'!B22","v":"On-site support or training - per hour"},{"$f":"'Panic Alerting'!H22","v":0},{"$f":"'Panic Alerting'!E22","v":0},{"$f":"'Panic Alerting'!J22","v":0},null,null,{"$f":"'Panic Alerting'!F22","v":0},{"$f":"'Panic Alerting'!M22","v":0},null,null,{"$f":"IF('Panic Alerting'!D22=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Panic Alerting'!C23","v":55005},{"$f":"'Panic Alerting'!A23","v":"Remote Support"},{"$f":"'Panic Alerting'!B23","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'Panic Alerting'!H23","v":0},{"$f":"'Panic Alerting'!E23","v":0},{"$f":"'Panic Alerting'!J23","v":0},null,null,{"$f":"'Panic Alerting'!F23","v":0},{"$f":"'Panic Alerting'!M23","v":0},null,null,{"$f":"IF('Panic Alerting'!D23=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["TETRA Telemetry & RTCU",null,null,{"$f":"SUM(D141:D144)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C20","v":55000},{"$f":"'TETRA Telemetry - RTCU'!A20","v":"On-site Support"},{"$f":"'TETRA Telemetry - RTCU'!B20","v":"On-site support or training - 1/2 day"},{"$f":"'TETRA Telemetry - RTCU'!H20","v":0},{"$f":"'TETRA Telemetry - RTCU'!E20","v":0},{"$f":"'TETRA Telemetry - RTCU'!J20","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F20","v":0},{"$f":"'TETRA Telemetry - RTCU'!M20","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D20=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F141-O141","v":0},{"$f":"F141-(F141*M141)","v":0},{"$f":"J141-Q141","v":0},{"$f":"J141-(J141*M141)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C21","v":55001},{"$f":"'TETRA Telemetry - RTCU'!A21","v":"On-site Support"},{"$f":"'TETRA Telemetry - RTCU'!B21","v":"On-site support or training - full day"},{"$f":"'TETRA Telemetry - RTCU'!H21","v":0},{"$f":"'TETRA Telemetry - RTCU'!E21","v":0},{"$f":"'TETRA Telemetry - RTCU'!J21","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F21","v":0},{"$f":"'TETRA Telemetry - RTCU'!M21","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D21=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C22","v":55002},{"$f":"'TETRA Telemetry - RTCU'!A22","v":"On-site Support"},{"$f":"'TETRA Telemetry - RTCU'!B22","v":"On-site support or training - per hour"},{"$f":"'TETRA Telemetry - RTCU'!H22","v":0},{"$f":"'TETRA Telemetry - RTCU'!E22","v":0},{"$f":"'TETRA Telemetry - RTCU'!J22","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F22","v":0},{"$f":"'TETRA Telemetry - RTCU'!M22","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D22=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C23","v":55005},{"$f":"'TETRA Telemetry - RTCU'!A23","v":"Remote Support"},{"$f":"'TETRA Telemetry - RTCU'!B23","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'TETRA Telemetry - RTCU'!H23","v":0},{"$f":"'TETRA Telemetry - RTCU'!E23","v":0},{"$f":"'TETRA Telemetry - RTCU'!J23","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F23","v":0},{"$f":"'TETRA Telemetry - RTCU'!M23","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D23=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["MOTOTRBO Phone Interconnect (RBX) & Voice Logging (R2R)",null,null,{"$f":"SUM(D146:D149)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C32","v":55000},{"$f":"'MOTOTRBO Phone & Voice'!A32","v":"On-site Support"},{"$f":"'MOTOTRBO Phone & Voice'!B32","v":"On-site support or training - 1/2 day"},{"$f":"'MOTOTRBO Phone & Voice'!H32","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E32","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J32","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F32","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M32","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D32=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F146-O146","v":0},{"$f":"F146-(F146*M146)","v":0},{"$f":"J146-Q146","v":0},{"$f":"J146-(J146*M146)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C33","v":55001},{"$f":"'MOTOTRBO Phone & Voice'!A33","v":"On-site Support"},{"$f":"'MOTOTRBO Phone & Voice'!B33","v":"On-site support or training - full day"},{"$f":"'MOTOTRBO Phone & Voice'!H33","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E33","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J33","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F33","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M33","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D33=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C34","v":55002},{"$f":"'MOTOTRBO Phone & Voice'!A34","v":"On-site Support"},{"$f":"'MOTOTRBO Phone & Voice'!B34","v":"On-site support or training - per hour"},{"$f":"'MOTOTRBO Phone & Voice'!H34","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E34","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J34","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F34","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M34","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D34=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C35","v":55005},{"$f":"'MOTOTRBO Phone & Voice'!A35","v":"Remote Support"},{"$f":"'MOTOTRBO Phone & Voice'!B35","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'MOTOTRBO Phone & Voice'!H35","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E35","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J35","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F35","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M35","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D35=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["GPS Mapping",null,null,{"$f":"SUM(D151:D154)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C17","v":55000},{"$f":"'MOTOTRBO GPS Mapping'!A17","v":"On-site Support"},{"$f":"'MOTOTRBO GPS Mapping'!B17","v":"On-site support or training - 1/2 day"},{"$f":"'MOTOTRBO GPS Mapping'!H17","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E17","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J17","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F17","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M17","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D17=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F151-O151","v":0},{"$f":"F151-(F151*M151)","v":0},{"$f":"J151-Q151","v":0},{"$f":"J151-(J151*M151)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C18","v":55001},{"$f":"'MOTOTRBO GPS Mapping'!A18","v":"On-site Support"},{"$f":"'MOTOTRBO GPS Mapping'!B18","v":"On-site support or training - full day"},{"$f":"'MOTOTRBO GPS Mapping'!H18","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E18","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J18","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F18","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M18","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D18=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C19","v":55002},{"$f":"'MOTOTRBO GPS Mapping'!A19","v":"On-site Support"},{"$f":"'MOTOTRBO GPS Mapping'!B19","v":"On-site support or training - per hour"},{"$f":"'MOTOTRBO GPS Mapping'!H19","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E19","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J19","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F19","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M19","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D19=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C20","v":55005},{"$f":"'MOTOTRBO GPS Mapping'!A20","v":"Remote Support"},{"$f":"'MOTOTRBO GPS Mapping'!B20","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'MOTOTRBO GPS Mapping'!H20","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E20","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J20","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F20","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M20","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D20=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["Man Down Notifier & Centralized Lone Worker",null,null,{"$f":"SUM(D156:D159)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C22","v":55000},{"$f":"'Staff Safety CLW & MDN'!A22","v":"On-site Support"},{"$f":"'Staff Safety CLW & MDN'!B22","v":"On-site support or training - 1/2 day"},{"$f":"'Staff Safety CLW & MDN'!H22","v":0},{"$f":"'Staff Safety CLW & MDN'!E22","v":0},{"$f":"'Staff Safety CLW & MDN'!J22","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F22","v":0},{"$f":"'Staff Safety CLW & MDN'!M22","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D22=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F156-O156","v":0},{"$f":"F156-(F156*M156)","v":0},{"$f":"J156-Q156","v":0},{"$f":"J156-(J156*M156)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C23","v":55001},{"$f":"'Staff Safety CLW & MDN'!A23","v":"On-site Support"},{"$f":"'Staff Safety CLW & MDN'!B23","v":"On-site support or training - full day"},{"$f":"'Staff Safety CLW & MDN'!H23","v":0},{"$f":"'Staff Safety CLW & MDN'!E23","v":0},{"$f":"'Staff Safety CLW & MDN'!J23","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F23","v":0},{"$f":"'Staff Safety CLW & MDN'!M23","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D23=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C24","v":55002},{"$f":"'Staff Safety CLW & MDN'!A24","v":"On-site Support"},{"$f":"'Staff Safety CLW & MDN'!B24","v":"On-site support or training - per hour"},{"$f":"'Staff Safety CLW & MDN'!H24","v":0},{"$f":"'Staff Safety CLW & MDN'!E24","v":0},{"$f":"'Staff Safety CLW & MDN'!J24","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F24","v":0},{"$f":"'Staff Safety CLW & MDN'!M24","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D24=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C25","v":55005},{"$f":"'Staff Safety CLW & MDN'!A25","v":"Remote Support"},{"$f":"'Staff Safety CLW & MDN'!B25","v":"Remote support from ZZZZZZ support center - 1/2 day"},{"$f":"'Staff Safety CLW & MDN'!H25","v":0},{"$f":"'Staff Safety CLW & MDN'!E25","v":0},{"$f":"'Staff Safety CLW & MDN'!J25","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F25","v":0},{"$f":"'Staff Safety CLW & MDN'!M25","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D25=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["Professional Services Total",null,null,{"$f":"SUM(D124:D159)","v":0},null,{"$f":"SUM(F124:F159)","v":0},null,null,null,{"$f":"SUM(J124:J159)","v":0},null,null,null,{"$f":"SUM(N124:N159)","v":0},{"$f":"SUM(O124:O159)","v":0},{"$f":"SUM(P124:P159)","v":0},0]
[null,null,null,{"$f":"D160","v":0}]
["Micellaneous",null,{"$f":"D198","v":0},{"$f":"D2","v":"Qty."},{"$f":"E2","v":"Unit RRP (EUR)"},"Total RRP (EUR)",null,null,{"$f":"I2","v":"Unit RRP (AUD)"},"Total RRP (AUD)",null,null,{"$f":"M2","v":"Discount"},null,"XXXX Cost (EUR)",null,"XXXX Cost (AUD)"]
[{"$f":"A124","v":"Alarm Control System (ACS)"},null,null,{"$f":"SUM(D164:D167)","v":0}]
[{"$f":"'Alarm Control System'!C72","v":55010},{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},{"$f":"'Alarm Control System'!H72","v":0},{"$f":"'Alarm Control System'!E72","v":0},{"$f":"'Alarm Control System'!J72","v":0},null,null,{"$f":"'Alarm Control System'!F72","v":0},{"$f":"'Alarm Control System'!M72","v":0},null,null,{"$f":"IF('Alarm Control System'!D72=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F164-O164","v":0},{"$f":"F164-(F164*M164)","v":0},{"$f":"J164-Q164","v":0},{"$f":"J164-(J164*M164)","v":0}]
[{"$f":"'Alarm Control System'!C73","v":55015},{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},{"$f":"'Alarm Control System'!H73","v":0},{"$f":"'Alarm Control System'!E73","v":0},{"$f":"'Alarm Control System'!J73","v":0},null,null,{"$f":"'Alarm Control System'!F73","v":0},{"$f":"'Alarm Control System'!M73","v":0},null,null,{"$f":"IF('Alarm Control System'!D73=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C74","v":55020},{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},{"$f":"'Alarm Control System'!H74","v":0},{"$f":"'Alarm Control System'!E74","v":0},{"$f":"'Alarm Control System'!J74","v":0},null,null,{"$f":"'Alarm Control System'!F74","v":0},{"$f":"'Alarm Control System'!M74","v":0},null,null,{"$f":"IF('Alarm Control System'!D74=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Alarm Control System'!C75","v":55025},{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'Alarm Control System'!H75","v":0},{"$f":"'Alarm Control System'!E75","v":0},{"$f":"'Alarm Control System'!J75","v":0},null,null,{"$f":"'Alarm Control System'!F75","v":0},{"$f":"'Alarm Control System'!M75","v":0},null,null,{"$f":"IF('Alarm Control System'!D75=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A129","v":"Bluetooth Indoor Positioning System (IPS)"},null,null,{"$f":"SUM(D169:D172)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C39","v":55010},{"$f":"'Bluetooth Indoor Positioning'!A39","v":"Car transport"},{"$f":"'Bluetooth Indoor Positioning'!B39","v":"Rate per km./mile to be driven by car"},{"$f":"'Bluetooth Indoor Positioning'!H39","v":0},{"$f":"'Bluetooth Indoor Positioning'!E39","v":0},{"$f":"'Bluetooth Indoor Positioning'!J39","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F39","v":0},{"$f":"'Bluetooth Indoor Positioning'!M39","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D39=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F169-O169","v":0},{"$f":"F169-(F169*M169)","v":0},{"$f":"J169-Q169","v":0},{"$f":"J169-(J169*M169)","v":0}]
[{"$f":"'Bluetooth Indoor Positioning'!C40","v":55015},{"$f":"'Bluetooth Indoor Positioning'!A40","v":"Transport"},{"$f":"'Bluetooth Indoor Positioning'!B40","v":"Price for air, train and ferry transport costs"},{"$f":"'Bluetooth Indoor Positioning'!H40","v":0},{"$f":"'Bluetooth Indoor Positioning'!E40","v":0},{"$f":"'Bluetooth Indoor Positioning'!J40","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F40","v":0},{"$f":"'Bluetooth Indoor Positioning'!M40","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D40=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C41","v":55020},{"$f":"'Bluetooth Indoor Positioning'!A41","v":"Accomodation"},{"$f":"'Bluetooth Indoor Positioning'!B41","v":"Price for economy class hotel costs"},{"$f":"'Bluetooth Indoor Positioning'!H41","v":0},{"$f":"'Bluetooth Indoor Positioning'!E41","v":0},{"$f":"'Bluetooth Indoor Positioning'!J41","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F41","v":0},{"$f":"'Bluetooth Indoor Positioning'!M41","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D41=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Bluetooth Indoor Positioning'!C42","v":55025},{"$f":"'Bluetooth Indoor Positioning'!A42","v":"Travel expenses"},{"$f":"'Bluetooth Indoor Positioning'!B42","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'Bluetooth Indoor Positioning'!H42","v":0},{"$f":"'Bluetooth Indoor Positioning'!E42","v":0},{"$f":"'Bluetooth Indoor Positioning'!J42","v":0},null,null,{"$f":"'Bluetooth Indoor Positioning'!F42","v":0},{"$f":"'Bluetooth Indoor Positioning'!M42","v":0},null,null,{"$f":"IF('Bluetooth Indoor Positioning'!D42=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A135","v":"Panic Alerting"},null,null,{"$f":"SUM(D174:D177)","v":0}]
[{"$f":"'Panic Alerting'!C25","v":55010},{"$f":"'Panic Alerting'!A25","v":"Car transport"},{"$f":"'Panic Alerting'!B25","v":"Rate per km./mile to be driven by car"},{"$f":"'Panic Alerting'!H25","v":0},{"$f":"'Panic Alerting'!E25","v":0},{"$f":"'Panic Alerting'!J25","v":0},null,null,{"$f":"'Panic Alerting'!F25","v":0},{"$f":"'Panic Alerting'!M25","v":0},null,null,{"$f":"IF('Panic Alerting'!D25=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F174-O174","v":0},{"$f":"F174-(F174*M174)","v":0},{"$f":"J174-Q174","v":0},{"$f":"J174-(J174*M174)","v":0}]
[{"$f":"'Panic Alerting'!C26","v":55015},{"$f":"'Panic Alerting'!A26","v":"Transport"},{"$f":"'Panic Alerting'!B26","v":"Price for air, train and ferry transport costs"},{"$f":"'Panic Alerting'!H26","v":0},{"$f":"'Panic Alerting'!E26","v":0},{"$f":"'Panic Alerting'!J26","v":0},null,null,{"$f":"'Panic Alerting'!F26","v":0},{"$f":"'Panic Alerting'!M26","v":0},null,null,{"$f":"IF('Panic Alerting'!D26=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Panic Alerting'!C27","v":55020},{"$f":"'Panic Alerting'!A27","v":"Accomodation"},{"$f":"'Panic Alerting'!B27","v":"Price for economy class hotel costs"},{"$f":"'Panic Alerting'!H27","v":0},{"$f":"'Panic Alerting'!E27","v":0},{"$f":"'Panic Alerting'!J27","v":0},null,null,{"$f":"'Panic Alerting'!F27","v":0},{"$f":"'Panic Alerting'!M27","v":0},null,null,{"$f":"IF('Panic Alerting'!D27=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Panic Alerting'!C28","v":55025},{"$f":"'Panic Alerting'!A28","v":"Travel expenses"},{"$f":"'Panic Alerting'!B28","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'Panic Alerting'!H28","v":0},{"$f":"'Panic Alerting'!E28","v":0},{"$f":"'Panic Alerting'!J28","v":0},null,null,{"$f":"'Panic Alerting'!F28","v":0},{"$f":"'Panic Alerting'!M28","v":0},null,null,{"$f":"IF('Panic Alerting'!D28=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A140","v":"TETRA Telemetry & RTCU"},null,null,{"$f":"SUM(D179:D182)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C25","v":55010},{"$f":"'TETRA Telemetry - RTCU'!A25","v":"Car transport"},{"$f":"'TETRA Telemetry - RTCU'!B25","v":"Rate per km./mile to be driven by car"},{"$f":"'TETRA Telemetry - RTCU'!H25","v":0},{"$f":"'TETRA Telemetry - RTCU'!E25","v":0},{"$f":"'TETRA Telemetry - RTCU'!J25","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F25","v":0},{"$f":"'TETRA Telemetry - RTCU'!M25","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D25=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F179-O179","v":0},{"$f":"F179-(F179*M179)","v":0},{"$f":"J179-Q179","v":0},{"$f":"J179-(J179*M179)","v":0}]
[{"$f":"'TETRA Telemetry - RTCU'!C26","v":55015},{"$f":"'TETRA Telemetry - RTCU'!A26","v":"Transport"},{"$f":"'TETRA Telemetry - RTCU'!B26","v":"Price for air, train and ferry transport costs"},{"$f":"'TETRA Telemetry - RTCU'!H26","v":0},{"$f":"'TETRA Telemetry - RTCU'!E26","v":0},{"$f":"'TETRA Telemetry - RTCU'!J26","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F26","v":0},{"$f":"'TETRA Telemetry - RTCU'!M26","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D26=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C27","v":55020},{"$f":"'TETRA Telemetry - RTCU'!A27","v":"Accomodation"},{"$f":"'TETRA Telemetry - RTCU'!B27","v":"Price for economy class hotel costs"},{"$f":"'TETRA Telemetry - RTCU'!H27","v":0},{"$f":"'TETRA Telemetry - RTCU'!E27","v":0},{"$f":"'TETRA Telemetry - RTCU'!J27","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F27","v":0},{"$f":"'TETRA Telemetry - RTCU'!M27","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D27=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'TETRA Telemetry - RTCU'!C28","v":55025},{"$f":"'TETRA Telemetry - RTCU'!A28","v":"Travel expenses"},{"$f":"'TETRA Telemetry - RTCU'!B28","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'TETRA Telemetry - RTCU'!H28","v":0},{"$f":"'TETRA Telemetry - RTCU'!E28","v":0},{"$f":"'TETRA Telemetry - RTCU'!J28","v":0},null,null,{"$f":"'TETRA Telemetry - RTCU'!F28","v":0},{"$f":"'TETRA Telemetry - RTCU'!M28","v":0},null,null,{"$f":"IF('TETRA Telemetry - RTCU'!D28=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A145","v":"MOTOTRBO Phone Interconnect (RBX) & Voice Logging (R2R)"},null,null,{"$f":"SUM(D184:D187)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C37","v":55010},{"$f":"'MOTOTRBO Phone & Voice'!A37","v":"Car transport"},{"$f":"'MOTOTRBO Phone & Voice'!B37","v":"Rate per km./mile to be driven by car"},{"$f":"'MOTOTRBO Phone & Voice'!H37","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E37","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J37","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F37","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M37","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D37=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F184-O184","v":0},{"$f":"F184-(F184*M184)","v":0},{"$f":"J184-Q184","v":0},{"$f":"J184-(J184*M184)","v":0}]
[{"$f":"'MOTOTRBO Phone & Voice'!C38","v":55015},{"$f":"'MOTOTRBO Phone & Voice'!A38","v":"Transport"},{"$f":"'MOTOTRBO Phone & Voice'!B38","v":"Price for air, train and ferry transport costs"},{"$f":"'MOTOTRBO Phone & Voice'!H38","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E38","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J38","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F38","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M38","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D38=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C39","v":55020},{"$f":"'MOTOTRBO Phone & Voice'!A39","v":"Accomodation"},{"$f":"'MOTOTRBO Phone & Voice'!B39","v":"Price for economy class hotel costs"},{"$f":"'MOTOTRBO Phone & Voice'!H39","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E39","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J39","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F39","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M39","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D39=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO Phone & Voice'!C40","v":55025},{"$f":"'MOTOTRBO Phone & Voice'!A40","v":"Travel expenses"},{"$f":"'MOTOTRBO Phone & Voice'!B40","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'MOTOTRBO Phone & Voice'!H40","v":0},{"$f":"'MOTOTRBO Phone & Voice'!E40","v":0},{"$f":"'MOTOTRBO Phone & Voice'!J40","v":0},null,null,{"$f":"'MOTOTRBO Phone & Voice'!F40","v":0},{"$f":"'MOTOTRBO Phone & Voice'!M40","v":0},null,null,{"$f":"IF('MOTOTRBO Phone & Voice'!D40=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A150","v":"GPS Mapping"},null,null,{"$f":"SUM(D189:D192)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C22","v":55010},{"$f":"'MOTOTRBO GPS Mapping'!A22","v":"Car transport"},{"$f":"'MOTOTRBO GPS Mapping'!B22","v":"Rate per km./mile to be driven by car"},{"$f":"'MOTOTRBO GPS Mapping'!H22","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E22","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J22","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F22","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M22","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D22=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F189-O189","v":0},{"$f":"F189-(F189*M189)","v":0},{"$f":"J189-Q189","v":0},{"$f":"J189-(J189*M189)","v":0}]
[{"$f":"'MOTOTRBO GPS Mapping'!C23","v":55015},{"$f":"'MOTOTRBO GPS Mapping'!A23","v":"Transport"},{"$f":"'MOTOTRBO GPS Mapping'!B23","v":"Price for air, train and ferry transport costs"},{"$f":"'MOTOTRBO GPS Mapping'!H23","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E23","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J23","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F23","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M23","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D23=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C24","v":55020},{"$f":"'MOTOTRBO GPS Mapping'!A24","v":"Accomodation"},{"$f":"'MOTOTRBO GPS Mapping'!B24","v":"Price for economy class hotel costs"},{"$f":"'MOTOTRBO GPS Mapping'!H24","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E24","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J24","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F24","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M24","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D24=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'MOTOTRBO GPS Mapping'!C25","v":55025},{"$f":"'MOTOTRBO GPS Mapping'!A25","v":"Travel expenses"},{"$f":"'MOTOTRBO GPS Mapping'!B25","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'MOTOTRBO GPS Mapping'!H25","v":0},{"$f":"'MOTOTRBO GPS Mapping'!E25","v":0},{"$f":"'MOTOTRBO GPS Mapping'!J25","v":0},null,null,{"$f":"'MOTOTRBO GPS Mapping'!F25","v":0},{"$f":"'MOTOTRBO GPS Mapping'!M25","v":0},null,null,{"$f":"IF('MOTOTRBO GPS Mapping'!D25=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"A155","v":"Man Down Notifier & Centralized Lone Worker"},null,null,{"$f":"SUM(D194:D197)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C27","v":55010},{"$f":"'Staff Safety CLW & MDN'!A27","v":"Car transport"},{"$f":"'Staff Safety CLW & MDN'!B27","v":"Rate per km./mile to be driven by car"},{"$f":"'Staff Safety CLW & MDN'!H27","v":0},{"$f":"'Staff Safety CLW & MDN'!E27","v":0},{"$f":"'Staff Safety CLW & MDN'!J27","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F27","v":0},{"$f":"'Staff Safety CLW & MDN'!M27","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D27=\"HW\",HWdiscount,Discount)","v":0.2},{"$f":"F194-O194","v":0},{"$f":"F194-(F194*M194)","v":0},{"$f":"J194-Q194","v":0},{"$f":"J194-(J194*M194)","v":0}]
[{"$f":"'Staff Safety CLW & MDN'!C28","v":55015},{"$f":"'Staff Safety CLW & MDN'!A28","v":"Transport"},{"$f":"'Staff Safety CLW & MDN'!B28","v":"Price for air, train and ferry transport costs"},{"$f":"'Staff Safety CLW & MDN'!H28","v":0},{"$f":"'Staff Safety CLW & MDN'!E28","v":0},{"$f":"'Staff Safety CLW & MDN'!J28","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F28","v":0},{"$f":"'Staff Safety CLW & MDN'!M28","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D28=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C29","v":55020},{"$f":"'Staff Safety CLW & MDN'!A29","v":"Accomodation"},{"$f":"'Staff Safety CLW & MDN'!B29","v":"Price for economy class hotel costs"},{"$f":"'Staff Safety CLW & MDN'!H29","v":0},{"$f":"'Staff Safety CLW & MDN'!E29","v":0},{"$f":"'Staff Safety CLW & MDN'!J29","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F29","v":0},{"$f":"'Staff Safety CLW & MDN'!M29","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D29=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
[{"$f":"'Staff Safety CLW & MDN'!C30","v":55025},{"$f":"'Staff Safety CLW & MDN'!A30","v":"Travel expenses"},{"$f":"'Staff Safety CLW & MDN'!B30","v":"Daily rate for travel expenses like meals, parking etc."},{"$f":"'Staff Safety CLW & MDN'!H30","v":0},{"$f":"'Staff Safety CLW & MDN'!E30","v":0},{"$f":"'Staff Safety CLW & MDN'!J30","v":0},null,null,{"$f":"'Staff Safety CLW & MDN'!F30","v":0},{"$f":"'Staff Safety CLW & MDN'!M30","v":0},null,null,{"$f":"IF('Staff Safety CLW & MDN'!D30=\"HW\",HWdiscount,Discount)","v":0.2},0,0,0,0]
["Miscellaneous Total",null,null,{"$f":"SUM(D163:D197)","v":0},null,{"$f":"SUM(F163:F197)","v":0},null,null,null,{"$f":"SUM(J163:J197)","v":0},null,null,null,{"$f":"SUM(N163:N197)","v":0},{"$f":"SUM(O163:O197)","v":0},{"$f":"SUM(P163:P197)","v":0},{"$f":"SUM(Q163:Q197)","v":0}]
[null,null,null,{"$f":"D198","v":0}]
["Solution Total",null,null,null,null,{"$f":"F2","v":"Total RRP (EUR)"},null,null,null,{"$f":"J2","v":"Total RRP (AUD)"},null,null,null,{"$f":"N2","v":"XXXX Revenue (EUR)"},{"$f":"O2","v":"XXXX Cost (EUR)"},{"$f":"P2","v":"XXXX Revenue (AUD)"},{"$f":"Q2","v":"XXXX Cost (AUD)"}]
["Product",null,null,null,null,{"$f":"F121","v":0},null,null,null,{"$f":"J121","v":0},null,null,null,null,{"$f":"O121","v":0},null,{"$f":"Q121","v":0}]
["Professional Services",null,null,null,null,{"$f":"F160","v":0},null,null,null,{"$f":"J160","v":0},null,null,null,null,{"$f":"O160","v":0},null,{"$f":"Q160","v":0}]
["Miscellaneous",null,null,null,null,{"$f":"F198","v":0},null,null,null,{"$f":"J198","v":0},null,null,null,null,{"$f":"O198","v":0},null,{"$f":"Q198","v":0}]
["- Special Discount",null,null,0,null,{"$f":"-$D204*SUM(F201:F203)","v":0},null,null,null,{"$f":"-$D204*SUM(J201:J203)","v":0},null,null,null,null,{"$f":"-$D204*SUM(O201:O203)","v":0},null,{"$f":"-$D204*SUM(Q201:Q203)","v":0}]
[]
["Freight",null,"<from - to>",0,null,{"$f":"D206","v":0},null,null,null,{"$f":"F206*LocalCurrencyRate","v":0},null,null,null,null,{"$f":"F206","v":0},null,{"$f":"J206","v":0}]
[]
["Solution Total",null,null,null,null,{"$f":"SUM(F201:F206)","v":0},null,null,null,{"$f":"SUM(J201:J206)","v":0},null,null,null,{"$f":"F208-O208","v":0},{"$f":"SUM(O201:O206)","v":0},{"$f":"J208-Q208","v":0},{"$f":"SUM(Q201:Q206)","v":0}]
[null,"Additional Discount",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!*-#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!*-#REF!","v":{"$error":"#REF!"}}]
[null,"Discounted Solution Total",null,null,null,{"$f":"#REF!+F209","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!+J209","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["Annual Support & Software Updates (from year 2)",null,null,null,null,{"$f":"G121","v":0},null,null,null,{"$f":"K121","v":0},null,null,null,{"$f":"F216-O216","v":0},{"$f":"F216*(1-Discount)","v":0},{"$f":"J216-Q216","v":0},{"$f":"J216*(1-Discount)","v":0}]
[]
["Commercial conditions"]
["Annual Support & Software Update: ZZZZZZ delivers software that, from time to time, is used in critical emergency situations. To ensure that its' customers have the best software available, ZZZZZZ requires that each customer agrees to a mandatory annual support and subscription service. This support and subscription service is essential in reducing risks of critical failure and includes error management, remote telephone and e-mail support, software upgrades and bug fixes. The support and subscription service is priced at 18% of the total value of purchased software. ZZZZZZ distributors must take responsibility to ensure that customers are fully aware of this support and subscription service. ZZZZZZ will notify its' distributor of service and support charges and will provide regular updates about new product updates and feature releases."]
["Proposal expire:",null,{"$f":"TODAY()+90","v":"2012-09-20"}]
["Delivery time:",null,"To be agreed."]
["Prices:",null,"Exclusive of any local tax or VAT."]
["Delivery:",null,"EXW Copenhagen, Denmark or EXW Cambridge, United Kingdom according to Inco terms 2000."]
["Link to General Agreement:",null,"www.ZZZZZZ.com/downloads"]
["Software and License Key's delivery:",null,{"$f":"\"Delivered via email and download links to an email address specified by \"&Reseller","v":"Delivered via email and download links to an email address specified by XXXX"}]
["Link to Software License Agreement:",null,{"$f":"C224","v":"www.ZZZZZZ.com/downloads"}]
["Disclaimer"]
["ZZZZZZ software is intended as a supplement to emergency, fire and mission critical systems and not for use in fail-safe performance in which the failure of the software could lead directly to death, personal injury or severe physical or environmental damage."]
["Deliveries of ZZZZZZ"]
["* Software via download link and License Key(s) as specified above\n* Hardware as specified above\n* "]
[{"$f":"\"Deliveries of \"&Reseller","v":"Deliveries of XXXX"}]
["* Installation services and on-site work\n* Radios, antenna, power supply and other radio accessory\n* "]

{"sheet":"Proposal & Reseller info","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,0,15,1],[0,0,0,1],[1,0,1,1],[16,0,16,1]]}
["ZZZZZZ Distributor Price Calculation Tool"]
["Valid from March 1st, 2012"]
[]
["Reseller information"]
["Reseller organisation name:","XXXX"]
["End-customer name:","<Customer>"]
["Project name:","<Project>"]
["Reseller discount software (%)",0.2]
["Reseller discount hardware (%)",0.1]
[]
["Currency converter"]
["Local currency symbol, i.e. USD, GBP, CAD, AUD","AUD"]
[{"$f":"\"EUR / \"&B12&\" Currency rate:\"","v":"EUR / AUD Currency rate:"},0.5]
[]
["Important information:"]
["- This price calculation tool is for sole use by ZZZZZZ distributors and resellers. All prices are exclusive VAT and all deliveries according to EXW Copenhagen Inco terms 2000.\n- All prices are based on the Euro (EUR) currency and will be invoiced in EUR unless otherwise agreed with ZZZZZZ. The local currency converter is for information only.\n- ZZZZZZ A/S reserves the right to change prices and specifications within a 30 days notice.\n- Unless otherwise agreed ZZZZZZ does not deliver any radio, radio accessory, radio data cables or radio programming as part of the services offered."]
[]
[]
["Annual Support & Software Update percentage:",0.18]

{"sheet":"Alarm Control System","index":2,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["Alarm Control System"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J23)+J26+SUM(J36:J75)","v":0},{"$f":"SUM(K12:K23)+K26+SUM(K36:K75)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L23)+L26+SUM(L36:L75)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[]
[]
["Alarm Control System (ACS) software"]
["ACS +Plus","Alarm Control System software for advanced alarm radio dispatch, including 5 user licenses and including:\n- Support for multiple Alarm Listeners\n- Full functionality incl. Scheduler, Escalation, Action Filter and Alarm Acknowledge\n- First year Support & Software Upgrade License",73001,"SW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["ACS Lite","Alarm Control System software for simple radio alarm dispatch ONLY, including 5 user licenses and including:\n- Support for one Alarm Listener and one Dispatch Media only\n- Basic alarm dispatch functionality without Scheduler, Escalation, Action Filter and Alarm Acknowledge\n- First year Support & Software Upgrade License",73010,"SW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["ACS Upgrade","Upgrading from ACS Lite to the full solution ACS +Plus (upgrade from part no. 73010 to 73001)",73020,"SW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["ACS Alarm Dispatch Media"]
["TETRA Radio Media","TETRA dispatch media for Sepura and Motorola PEI connection",73240,"SW",0,{"$f":"E16*LocalCurrencyRate","v":0},null,0,null,{"$f":"H16*E16","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(J16*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D16=\"HW\",J16*HWdiscount,J16*Discount)","v":0},{"$f":"E16*H16*LocalCurrencyRate","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(M16*AnnualSupportPercentage),0),0)","v":0}]
["TETRA Direct Access Media","TETRA dispatch media for direct access to Motorola Dimetra Short Data Router (SDR)",73242,"SW",0,0,null,0,null,0,0,0,0,0]
["MOTOTRBO Media","Motorola MOTOTRBO dispatch media",73250,"SW",0,0,null,0,null,0,0,0,0,0]
["DECT Media","Polycom DECT Phone dispatch media ",73270,"SW",0,0,null,0,null,0,0,0,0,0]
["TEAM Media","Motorola WiFi TEAM Phone media",73275,"SW",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
["POCSAG Pager Media","POCSAG Pager media for CommTech Intelpage IP transmitters",37002,"SW",0,{"$f":"E21*LocalCurrencyRate","v":0},null,0,null,{"$f":"H21*E21","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(J21*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D21=\"HW\",J21*HWdiscount,J21*Discount)","v":0},{"$f":"E21*H21*LocalCurrencyRate","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(M21*AnnualSupportPercentage),0),0)","v":0}]
["SMS Media","SMS dispatch media for GSM modems (see part no. 73210)",73200,"SW",0,0,null,0,null,0,0,0,0,0]
["GSM Modem","Hardware unit for SMS dispatch (part no. 73200):\n- Complete GSM modem package for SMS dispatch media\n- Antennea\n- Power Supply (EU two pin plug)\n- Serial cable\n- USB connector\nNote: Customer must provide SIM card",73210,"HW",0,0,null,0,null,0,0,0,0,0]
["Additional ACS User Licenses"]
[null,"Existing number of User licenses (type in)",null,null,null,null,null,5]
["Additional ACS Users","Additional ACS User licenses",73030,"SW",0,{"$f":"E26*LocalCurrencyRate","v":0},null,0,null,{"$f":"H26*E26","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(J26*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D26=\"HW\",J26*HWdiscount,J26*Discount)","v":0},{"$f":"E26*H26*LocalCurrencyRate","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(M26*AnnualSupportPercentage),0),0)","v":0},null,{"$f":"IF(E29=0.5,\"Discount on POCSAG Paging User Licenses apply when this is the only media\",\"\")","v":""}]
[null,"= Total number of licensed Users",null,null,null,null,null,{"$f":"H25+H26","v":5}]
[null,null,null,null,"Pocsag discount:"]
[null,"Price/discount scheme for additional Users","From:","To:",{"$f":"IF((H16+H17+H18+H19+H20+H22)>=1,1,IF(H21=1,0.5,1))","v":1},null,null,null,null,"TotallUsers:","Exsting Users:",null,"Additional Users:"]
[null,{"$f":"\"Price/User for the quantity of Users between \"&C30&\" and \"&D30&\" - incl. in the ACS package\"","v":"Price/User for the quantity of Users between 0 and 5 - incl. in the ACS package"},0,5,{"$f":"0*PagerUserDiscount","v":0},{"$f":"E30*LocalCurrencyRate","v":0},null,null,null,{"$f":"IF(TotalUsers>D30,(D30-C30),(TotalUsers-C30))","v":5},{"$f":"IF(ExistingUsers>D30,(D30-C30),(ExistingUsers-C30))","v":5},null,{"$f":"J30-K30","v":0}]
[null,{"$f":"\"Price/User for the quantity of Users between \"&C31&\" and \"&D31&\"\"","v":"Price/User for the quantity of Users between 6 and 10"},{"$f":"D30+1","v":6},10,{"$f":"260*PagerUserDiscount","v":260},{"$f":"E31*LocalCurrencyRate","v":130},null,null,null,{"$f":"IF(TotalUsers>D31,(D31-D30),IF((TotalUsers-D30)<0,0,(TotalUsers-D30)))","v":0},{"$f":"IF(ExistingUsers>D31,(D31-D30),IF((ExistingUsers-D30)<0,0,(ExistingUsers-D30)))","v":0},null,{"$f":"J31-K31","v":0}]
[null,{"$f":"\"Price/User for the quantity of Users between \"&C32&\" and \"&D32&\"\"","v":"Price/User for the quantity of Users between 11 and 20"},{"$f":"D31+1","v":11},20,{"$f":"195*PagerUserDiscount","v":195},{"$f":"E32*LocalCurrencyRate","v":97.5},null,null,null,{"$f":"IF(TotalUsers>D32,(D32-D31),IF((TotalUsers-D31)<0,0,(TotalUsers-D31)))","v":0},{"$f":"IF(ExistingUsers>D32,(D32-D31),IF((ExistingUsers-D31)<0,0,(ExistingUsers-D31)))","v":0},null,{"$f":"J32-K32","v":0}]
[null,{"$f":"\"Price/User for the quantity of Users between \"&C33&\" and \"&D33&\"\"","v":"Price/User for the quantity of Users between 21 and 30"},{"$f":"D32+1","v":21},30,{"$f":"130*PagerUserDiscount","v":130},{"$f":"E33*LocalCurrencyRate","v":65},null,null,null,{"$f":"IF(TotalUsers>D33,(D33-D32),IF((TotalUsers-D32)<0,0,(TotalUsers-D32)))","v":0},{"$f":"IF(ExistingUsers>D33,(D33-D32),IF((ExistingUsers-D32)<0,0,(ExistingUsers-D32)))","v":0},null,{"$f":"J33-K33","v":0}]
[null,{"$f":"\"Price/User for the quantity of more than \"&C34&\" Users\"","v":"Price/User for the quantity of more than 31 Users"},{"$f":"D33+1","v":31},9999,{"$f":"65*PagerUserDiscount","v":65},{"$f":"E34*LocalCurrencyRate","v":32.5},null,null,null,{"$f":"IF(TotalUsers>D34,(D34-D33),IF((TotalUsers-D33)<0,0,(TotalUsers-D33)))","v":0},{"$f":"IF(ExistingUsers>D34,(D34-D33),IF((ExistingUsers-D33)<0,0,(ExistingUsers-D33)))","v":0},null,{"$f":"J34-K34","v":0}]
["ACS Alarm Listeners"]
["Wireless Text Message Listener","Wireless Text Message Listener for TETRA, MOTOTRBO, DECT, TEAM and GSM *)",37001,"SW",0,{"$f":"E36*LocalCurrencyRate","v":0},null,0,null,{"$f":"H36*E36","v":0},{"$f":"IF($D36=\"SW\",IF($H36>0,(J36*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D36=\"HW\",J36*HWdiscount,J36*Discount)","v":0},{"$f":"E36*H36*LocalCurrencyRate","v":0},{"$f":"IF($D36=\"SW\",IF($H36>0,(M36*AnnualSupportPercentage),0),0)","v":0}]
["GSM Modem","Hardware unit for SMS Wireless Text Messages (part no. 37001):\n- Complete GSM modem package for SMS dispatch media\n- Antennea\n- Power Supply (EU two pin plugs)\n- Serial cable\n- USB connector\nNote: Customer must provide SIM card",73210,"HW",0,0,null,0,null,0,0,0,0,0]
["OPC Listener","OPC (OLE for Process Control) for SCADA and PLC systems.",37002,"SW",0,0,null,0,null,0,0,0,0,0]
["Email Listener","Email Listener with build-in SMTP server",37007,"SW",0,0,null,0,null,0,0,0,0,0]
["Serial ASCII Listener","Serial ASCII Listener for alarm printer outputs, ASCII strings, RS232 etc.",37008,"SW",0,{"$f":"E40*LocalCurrencyRate","v":0},null,0,null,{"$f":"H40*E40","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(J40*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D40=\"HW\",J40*HWdiscount,J40*Discount)","v":0},{"$f":"E40*H40*LocalCurrencyRate","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(M40*AnnualSupportPercentage),0),0)","v":0}]
["Database Listener","Database Listener for SQL database lookup",37009,"SW",0,0,null,0,null,0,0,0,0,0]
["Panic Alarm Listener","For ZZZZZZ wireless panic alerting system. See folder \"Panic Alerting Solution\" for information on hardware.",37010,"SW",0,0,null,0,null,0,0,0,0,0]
["Command Line","Command Line Client (Windows and Linux) and alarm Listener",37011,"SW",0,0,null,0,null,0,0,0,0,0]
["ESPA4.4.4","ESPA4.4.4 Alarm Listener\nThe ESPA4.4.4 Listener requires an ESPA <=> IP protocol converter unit from www.elexol.nl",37015,"SW",0,0,null,0,null,0,0,0,0,0]
["MOXA I/O","MOXA I/O LAN Alarm Listener",37020,"SW",0,0,null,0,null,0,0,0,0,0]
["MOXA E2010","MOXA ioLogik E2010, incl.:\n- 12 Digital Input\n- DIN Rail mounting",38210,"HW",0,0,null,0,null,0,0,0,0,0]
["MOXA Power Supply","24 VDC MOXA Power Supply for DIN Rail mounting",38110,"HW",0,0,null,0,null,0,0,0,0,0]
["Desktop Client","Desktop PC Client User Interface for Windows PC's to raise manual alarms and tasks",37100,"SW",0,0,null,0,null,0,0,0,0,0]
["IO Alarm Listener","IO Listener for alarms via discrete signals. Need Part No. 38009.",37003,"SW",0,0,null,0,null,0,0,0,0,0]
["IO AX9 MAIN UNIT","AX9 Unit, incl.\n- 5 Digital Alarm Input\n- 4 Analogue Input (0-5 V)\n- MODBUS connection to I/O Expansion units\n- IP67 enclosure\n- Build-in 230 VAC power supply",38009,"HW",0,0,null,0,null,0,0,0,0,0]
["IO MODBUS 14 DI","MODBUS I/O Expansion Unit:\n- 14 Digital Inputs (Isolated)\n- For connection to Part No. 38009",38041,"HW",0,0,null,0,null,0,0,0,0,0]
["IO MODBUS 4 DI","MODBUS I/O Expansion Unit:\n- 4 Digital Inputs\n- 5 Digital Relay Outputs (250 V/5A)\n- For connection to Part No. 38009",38065,"HW",0,0,null,0,null,0,0,0,0,0]
["ACS Add-on Modules"]
["ACS Relay Module","Relay Output Module with 4 relays (software and hardware unit included)",81000,"SW",0,{"$f":"E54*LocalCurrencyRate","v":0},null,0,null,{"$f":"H54*E54","v":0},{"$f":"IF($D54=\"SW\",IF($H54>0,(J54*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D54=\"HW\",J54*HWdiscount,J54*Discount)","v":0},{"$f":"E54*H54*LocalCurrencyRate","v":0},{"$f":"IF($D54=\"SW\",IF($H54>0,(M54*AnnualSupportPercentage),0),0)","v":0}]
["Centralized Lone Worker Module","ACS toolbox for setting up lone worker services.\nMedia supported: TETRA, MOTOTRBO, DECT, TEAM and GSM",81005,"SW",0,{"$f":"E55*LocalCurrencyRate","v":0},null,0,null,{"$f":"H55*E55","v":0},{"$f":"IF($D55=\"SW\",IF($H55>0,(J55*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D55=\"HW\",J55*HWdiscount,J55*Discount)","v":0},{"$f":"E55*H55*LocalCurrencyRate","v":0},{"$f":"IF($D55=\"SW\",IF($H55>0,(M55*AnnualSupportPercentage),0),0)","v":0},null,"If CLW functionality only and no ACS alarm handling is needed, select the CLW package, part no. 73501, found in folder \"Staff Safety MDN & CLW\"."]
["Radio Network Alive Check","Radio Network Alive Check Module including:\n- ACS software\n- Alive Check hardware unit\n- Support for TETRA, MOTOTRBO and GSM\n- Network failure notified by SMS or via relay output",81010,"SW",0,{"$f":"E56*LocalCurrencyRate","v":0},null,0,null,{"$f":"H56*E56","v":0},{"$f":"IF($D56=\"SW\",IF($H56>0,(J56*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D56=\"HW\",J56*HWdiscount,J56*Discount)","v":0},{"$f":"E56*H56*LocalCurrencyRate","v":0},{"$f":"IF($D56=\"SW\",IF($H56>0,(M56*AnnualSupportPercentage),0),0)","v":0}]
["Alarm Display","Alarm display\n- Showing alarms on remote or control room PC screens\n- Unlimited number of Windows client use",81015,"SW",0,{"$f":"E57*LocalCurrencyRate","v":0},null,0,null,{"$f":"H57*E57","v":0},{"$f":"IF($D57=\"SW\",IF($H57>0,(J57*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D57=\"HW\",J57*HWdiscount,J57*Discount)","v":0},{"$f":"E57*H57*LocalCurrencyRate","v":0},{"$f":"IF($D57=\"SW\",IF($H57>0,(M57*AnnualSupportPercentage),0),0)","v":0}]
["Special and Customised Deliveries"]
["Special Software 1","<insert description of the special software provided>",55009,"SW",null,{"$f":"E59*LocalCurrencyRate","v":0},null,0,null,{"$f":"H59*E59","v":0},{"$f":"IF($D59=\"SW\",IF($H59>0,(J59*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D59=\"HW\",J59*HWdiscount,J59*Discount)","v":0},{"$f":"E59*H59*LocalCurrencyRate","v":0},{"$f":"IF($D59=\"SW\",IF($H59>0,(M59*AnnualSupportPercentage),0),0)","v":0},null,"Special software deployment provided by ZZZZZZ"]
["Special Software 2","<insert description of the special software provided>",55009,"SW",null,{"$f":"E60*LocalCurrencyRate","v":0},null,0,null,{"$f":"H60*E60","v":0},{"$f":"IF($D60=\"SW\",IF($H60>0,(J60*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D60=\"HW\",J60*HWdiscount,J60*Discount)","v":0},{"$f":"E60*H60*LocalCurrencyRate","v":0},{"$f":"IF($D60=\"SW\",IF($H60>0,(M60*AnnualSupportPercentage),0),0)","v":0},null,"Special software deployment provided by ZZZZZZ"]
["Special Hardware 1","<insert description of the special hardware provided>",82004,"HW",null,{"$f":"E61*LocalCurrencyRate","v":0},null,0,null,{"$f":"H61*E61","v":0},{"$f":"IF($D61=\"SW\",IF($H61>0,(J61*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D61=\"HW\",J61*HWdiscount,J61*Discount)","v":0},{"$f":"E61*H61*LocalCurrencyRate","v":0},{"$f":"IF($D61=\"SW\",IF($H61>0,(M61*AnnualSupportPercentage),0),0)","v":0},null,"Special hardware provided by ZZZZZZ"]
["Special Hardware 2","<insert description of the special hardware provided>",82004,"HW",null,{"$f":"E62*LocalCurrencyRate","v":0},null,0,null,{"$f":"H62*E62","v":0},{"$f":"IF($D62=\"SW\",IF($H62>0,(J62*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D62=\"HW\",J62*HWdiscount,J62*Discount)","v":0},{"$f":"E62*H62*LocalCurrencyRate","v":0},{"$f":"IF($D62=\"SW\",IF($H62>0,(M62*AnnualSupportPercentage),0),0)","v":0},null,"Special hardware provided by ZZZZZZ"]
["Demo Kits"]
["TETRA ACS+IPS Demo Kit","TETRA Demo Kit including:\n- 2 pcs. Bluetooth Positioning Beacons including power supplies\n- Alarm Control System software with TETRA radio PEI interface\n- Indoor Positioning software\n- 1 pcs. TETRA Telemetry Unit / RTCU\n- Alarm simulator software tool",10002,"-",0,{"$f":"E64*LocalCurrencyRate","v":0},null,0,null,{"$f":"H64*E64","v":0},{"$f":"IF($D64=\"SW\",IF($H64>0,(J64*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D64=\"HW\",J64*HWdiscount,J64*Discount)","v":0},{"$f":"E64*H64*LocalCurrencyRate","v":0},{"$f":"IF($D64=\"SW\",IF($H64>0,(M64*AnnualSupportPercentage),0),0)","v":0},null,"Demo kit for sales demonstrations"]
["ACS+IPS Demo Kit","Demo Kit including:\n- 2 pcs. Bluetooth Positioning Beacons including power supplies\n- Alarm Control System software with free selection of Media: MOTOTRBO, DECT, POCSAG, GSM or TEAM\n- Indoor Positioning software\n- Alarm simulator software tool",10003,"-",0,{"$f":"E65*LocalCurrencyRate","v":0},null,0,null,{"$f":"H65*E65","v":0},{"$f":"IF($D65=\"SW\",IF($H65>0,(J65*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D65=\"HW\",J65*HWdiscount,J65*Discount)","v":0},{"$f":"E65*H65*LocalCurrencyRate","v":0},{"$f":"IF($D65=\"SW\",IF($H65>0,(M65*AnnualSupportPercentage),0),0)","v":0},null,"Demo kit for sales demonstrations"]
["Professional Services"]
["On-site Support","On-site support or training - 1/2 day",55000,"-",0,{"$f":"E67*LocalCurrencyRate","v":0},null,0,null,{"$f":"H67*E67","v":0},{"$f":"IF($D67=\"SW\",IF($H67>0,(J67*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D67=\"HW\",J67*HWdiscount,J67*Discount)","v":0},{"$f":"E67*H67*LocalCurrencyRate","v":0},{"$f":"IF($D67=\"SW\",IF($H67>0,(M67*AnnualSupportPercentage),0),0)","v":0}]
["On-site Support","On-site support or training - full day",55001,"-",0,{"$f":"E68*LocalCurrencyRate","v":0},null,0,null,{"$f":"H68*E68","v":0},{"$f":"IF($D68=\"SW\",IF($H68>0,(J68*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D68=\"HW\",J68*HWdiscount,J68*Discount)","v":0},{"$f":"E68*H68*LocalCurrencyRate","v":0},{"$f":"IF($D68=\"SW\",IF($H68>0,(M68*AnnualSupportPercentage),0),0)","v":0}]
["On-site Support","On-site support or training - per hour",55002,"-",0,{"$f":"E69*LocalCurrencyRate","v":0},null,0,null,{"$f":"H69*E69","v":0},{"$f":"IF($D69=\"SW\",IF($H69>0,(J69*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D69=\"HW\",J69*HWdiscount,J69*Discount)","v":0},{"$f":"E69*H69*LocalCurrencyRate","v":0},{"$f":"IF($D69=\"SW\",IF($H69>0,(M69*AnnualSupportPercentage),0),0)","v":0}]
["Remote Support","Remote support from ZZZZZZ support center - 1/2 day",55005,"-",0,{"$f":"E70*LocalCurrencyRate","v":0},null,0,null,{"$f":"H70*E70","v":0},{"$f":"IF($D70=\"SW\",IF($H70>0,(J70*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D70=\"HW\",J70*HWdiscount,J70*Discount)","v":0},{"$f":"E70*H70*LocalCurrencyRate","v":0},{"$f":"IF($D70=\"SW\",IF($H70>0,(M70*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
["Car transport","Rate per km./mile to be driven by car",55010,"-",null,{"$f":"E72*LocalCurrencyRate","v":0},null,0,null,{"$f":"H72*E72","v":0},{"$f":"IF($D72=\"SW\",IF($H72>0,(J72*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D72=\"HW\",J72*HWdiscount,J72*Discount)","v":0},{"$f":"E72*H72*LocalCurrencyRate","v":0},{"$f":"IF($D72=\"SW\",IF($H72>0,(M72*AnnualSupportPercentage),0),0)","v":0}]
["Transport","Price for air, train and ferry transport costs",55015,"-",null,{"$f":"E73*LocalCurrencyRate","v":0},null,0,null,{"$f":"H73*E73","v":0},{"$f":"IF($D73=\"SW\",IF($H73>0,(J73*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D73=\"HW\",J73*HWdiscount,J73*Discount)","v":0},{"$f":"E73*H73*LocalCurrencyRate","v":0},{"$f":"IF($D73=\"SW\",IF($H73>0,(M73*AnnualSupportPercentage),0),0)","v":0}]
["Accomodation","Price for economy class hotel costs",55020,"-",null,{"$f":"E74*LocalCurrencyRate","v":0},null,0,null,{"$f":"H74*E74","v":0},{"$f":"IF($D74=\"SW\",IF($H74>0,(J74*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D74=\"HW\",J74*HWdiscount,J74*Discount)","v":0},{"$f":"E74*H74*LocalCurrencyRate","v":0},{"$f":"IF($D74=\"SW\",IF($H74>0,(M74*AnnualSupportPercentage),0),0)","v":0}]
["Travel expenses","Daily rate for travel expenses like meals, parking etc.",55025,"-",null,{"$f":"E75*LocalCurrencyRate","v":0},null,0,null,{"$f":"H75*E75","v":0},{"$f":"IF($D75=\"SW\",IF($H75>0,(J75*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D75=\"HW\",J75*HWdiscount,J75*Discount)","v":0},{"$f":"E75*H75*LocalCurrencyRate","v":0},{"$f":"IF($D75=\"SW\",IF($H75>0,(M75*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"Bluetooth Indoor Positioning","index":3,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["Bluetooth Indoor Positioning System (IPS)"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J42)","v":0},{"$f":"SUM(K12:K42)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L42)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[null,null,null,null,null,null,null,0]
[]
["Indoor Positioning System (IPS)"]
["IPS (5 Beacons)","License for the Indoor Positioning System, incl.:\n- Connection of up to 5 Bluetooth Position Beacons\n- 1st years Support & Software Updates",90005,"SW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0},null,"For both indoor positioning and alarm handling please also select the appropiate Alarm Control System configuration"]
["IPS (25 Beacons)","License for the Indoor Positioning System, incl.:\n- Connection of up to 25 Bluetooth Position Beacons\n- 1st years Support & Software Updates",90025,"SW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0},null,"For both indoor positioning and alarm handling please also select the appropiate Alarm Control System configuration"]
["IPS (Unlimited Beacons)","License for the Indoor Positioning System, incl.:\n- Connection of unlimited number of Bluetooth Position Beacons\n- 1st years Support & Software Updates",90099,"SW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0},null,"For both indoor positioning and alarm handling please also select the appropiate Alarm Control System configuration"]
["IPS Upgrade (5-25 Beacons)","Upgrading IPS from 5 to 25 Bluetooth Beacon license (upgrade from item no. 90005 to 90025)",90012,"SW",0,{"$f":"E15*LocalCurrencyRate","v":0},null,0,null,{"$f":"H15*E15","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(J15*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D15=\"HW\",J15*HWdiscount,J15*Discount)","v":0},{"$f":"E15*H15*LocalCurrencyRate","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(M15*AnnualSupportPercentage),0),0)","v":0}]
["IPS Upgrade (25-Unlimited Beacons)","Upgrading IPS from 25 to unlimited Bluetooth Beacon license (upgrade from item no. 90025 to 90999)",90050,"SW",0,{"$f":"E16*LocalCurrencyRate","v":0},null,0,null,{"$f":"H16*E16","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(J16*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D16=\"HW\",J16*HWdiscount,J16*Discount)","v":0},{"$f":"E16*H16*LocalCurrencyRate","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(M16*AnnualSupportPercentage),0),0)","v":0}]
["Bluetooth Position Beacons"]
["BPBi-01","1-5 pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon.",91000,"HW",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
["BPBi-01","6-25 pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon ordered in one lot.",91010,"HW",0,0,null,0,null,0,0,0,0,0]
["BPBi-01","25+ pcs. Bluetooth Position Beacon BPBi-01 with internal Bluetooth antennea and PoE RJ45 LAN connector. Price for each Beacon ordered in one lot.",91020,"HW",0,0,null,0,null,0,0,0,0,0]
["BPBx-01","1-5 pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon.",91100,"HW",0,0,null,0,null,0,0,0,0,0]
["BPBx-01","6-25 pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon ordered in one lot.",91110,"HW",0,0,null,0,null,0,0,0,0,0]
["BPBx-01","25+ pcs. Bluetooth Position Beacon BPBx-01 with external Bluetooth antennea connector and PoE RJ45 LAN connector. Delivered with small stub antennea. Price for each Beacon ordered in one lot.",91120,"HW",0,0,null,0,null,0,0,0,0,0]
["Power Supplies for Bluetooth Position Beacons"]
["BPB Power Supply EU","5VDC wall plug 110-240 VAC power supply (EU two pin plugs) for all Bluetooth Beacons types.",92005,"HW",0,{"$f":"E25*LocalCurrencyRate","v":0},null,0,null,{"$f":"H25*E25","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(J25*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D25=\"HW\",J25*HWdiscount,J25*Discount)","v":0},{"$f":"E25*H25*LocalCurrencyRate","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(M25*AnnualSupportPercentage),0),0)","v":0}]
["BPB Power Supply UK","5VDC wall plug 110-240 VAC power supply (UK three pin plugs) for all Bluetooth Beacons types.",92006,"HW",0,{"$f":"E26*LocalCurrencyRate","v":0},null,0,null,{"$f":"H26*E26","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(J26*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D26=\"HW\",J26*HWdiscount,J26*Discount)","v":0},{"$f":"E26*H26*LocalCurrencyRate","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(M26*AnnualSupportPercentage),0),0)","v":0}]
["BPB Power Supply US","5VDC wall plug 110-240 VAC power supply (US two pin plugs) for all Bluetooth Beacons types.",92007,"HW",0,{"$f":"E27*LocalCurrencyRate","v":0},null,0,null,{"$f":"H27*E27","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(J27*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D27=\"HW\",J27*HWdiscount,J27*Discount)","v":0},{"$f":"E27*H27*LocalCurrencyRate","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(M27*AnnualSupportPercentage),0),0)","v":0}]
["Bluetooth Tracking Devices and Accessories"]
["BSA-93001","Bluetooth Side Adapter for Motorola MOTOTRBO and Motorola MTP850S radios",93001,"HW",0,{"$f":"E29*LocalCurrencyRate","v":0},null,0,null,{"$f":"H29*E29","v":0},{"$f":"IF($D29=\"SW\",IF($H29>0,(J29*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D29=\"HW\",J29*HWdiscount,J29*Discount)","v":0},{"$f":"E29*H29*LocalCurrencyRate","v":0},{"$f":"IF($D29=\"SW\",IF($H29>0,(M29*AnnualSupportPercentage),0),0)","v":0}]
["BSA-93003","Bluetooth Side Adapter for Kenwood NexEdge. 2-pin connector.",93001,"HW",0,{"$f":"E30*LocalCurrencyRate","v":0},null,0,null,{"$f":"H30*E30","v":0},{"$f":"IF($D30=\"SW\",IF($H30>0,(J30*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D30=\"HW\",J30*HWdiscount,J30*Discount)","v":0},{"$f":"E30*H30*LocalCurrencyRate","v":0}]
["BT-PTT","Bluetooth PTT button for paring with BSA-93001",93011,"HW",0,{"$f":"E31*LocalCurrencyRate","v":0},null,0,null,{"$f":"H31*E31","v":0},{"$f":"IF($D31=\"SW\",IF($H31>0,(J31*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D31=\"HW\",J31*HWdiscount,J31*Discount)","v":0},{"$f":"E31*H31*LocalCurrencyRate","v":0},{"$f":"IF($D31=\"SW\",IF($H31>0,(M31*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E33*LocalCurrencyRate","v":0},null,0,null,{"$f":"H33*E33","v":0},{"$f":"IF($D33=\"SW\",IF($H33>0,(J33*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D33=\"HW\",J33*HWdiscount,J33*Discount)","v":0},{"$f":"E33*H33*LocalCurrencyRate","v":0},{"$f":"IF($D33=\"SW\",IF($H33>0,(M33*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E34*LocalCurrencyRate","v":0},null,0,null,{"$f":"H34*E34","v":0},{"$f":"IF($D34=\"SW\",IF($H34>0,(J34*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D34=\"HW\",J34*HWdiscount,J34*Discount)","v":0},{"$f":"E34*H34*LocalCurrencyRate","v":0},{"$f":"IF($D34=\"SW\",IF($H34>0,(M34*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E35*LocalCurrencyRate","v":0},null,0,null,{"$f":"H35*E35","v":0},{"$f":"IF($D35=\"SW\",IF($H35>0,(J35*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D35=\"HW\",J35*HWdiscount,J35*Discount)","v":0},{"$f":"E35*H35*LocalCurrencyRate","v":0},{"$f":"IF($D35=\"SW\",IF($H35>0,(M35*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E36*LocalCurrencyRate","v":0},null,0,null,{"$f":"H36*E36","v":0},{"$f":"IF($D36=\"SW\",IF($H36>0,(J36*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D36=\"HW\",J36*HWdiscount,J36*Discount)","v":0},{"$f":"E36*H36*LocalCurrencyRate","v":0},{"$f":"IF($D36=\"SW\",IF($H36>0,(M36*AnnualSupportPercentage),0),0)","v":0}]
["IPS Site Survey","ZZZZZZ specialist conducting site survey to determin the positions and amount of Bluetooth Position Beacons needed. Price based on a per day rate.",55010,"-",0,{"$f":"E37*LocalCurrencyRate","v":0},null,0,null,{"$f":"H37*E37","v":0},{"$f":"IF($D37=\"SW\",IF($H37>0,(J37*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D37=\"HW\",J37*HWdiscount,J37*Discount)","v":0},{"$f":"E37*H37*LocalCurrencyRate","v":0},{"$f":"IF($D37=\"SW\",IF($H37>0,(M37*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E39*LocalCurrencyRate","v":0},null,0,null,{"$f":"H39*E39","v":0},{"$f":"IF($D39=\"SW\",IF($H39>0,(J39*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D39=\"HW\",J39*HWdiscount,J39*Discount)","v":0},{"$f":"E39*H39*LocalCurrencyRate","v":0},{"$f":"IF($D39=\"SW\",IF($H39>0,(M39*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E40*LocalCurrencyRate","v":0},null,0,null,{"$f":"H40*E40","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(J40*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D40=\"HW\",J40*HWdiscount,J40*Discount)","v":0},{"$f":"E40*H40*LocalCurrencyRate","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(M40*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E41*LocalCurrencyRate","v":0},null,0,null,{"$f":"H41*E41","v":0},{"$f":"IF($D41=\"SW\",IF($H41>0,(J41*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D41=\"HW\",J41*HWdiscount,J41*Discount)","v":0},{"$f":"E41*H41*LocalCurrencyRate","v":0},{"$f":"IF($D41=\"SW\",IF($H41>0,(M41*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E42*LocalCurrencyRate","v":0},null,0,null,{"$f":"H42*E42","v":0},{"$f":"IF($D42=\"SW\",IF($H42>0,(J42*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D42=\"HW\",J42*HWdiscount,J42*Discount)","v":0},{"$f":"E42*H42*LocalCurrencyRate","v":0},{"$f":"IF($D42=\"SW\",IF($H42>0,(M42*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"Panic Alerting","index":4,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["Panic Alerting Solution"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J28)","v":0},{"$f":"SUM(K12:K28)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L28)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[]
[]
["Panic Alerting System"]
["Central Receiver","- LAN Interface\n- Backup Battery\n- Capacity for 50 Panic Buttons\n- 230 VAC build-in power supply",42201,"HW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["Panic Alarm Button","Desk mounted or arm wrest carried.",42114,"HW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["Panic Alarm Button","Wall mounted.",42115,"HW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["PC-350 Unit Box ","Interface to Alarm Control System. Including Panic Alarm Listener for Alarm Control System, Part No. 37010.",42350,"SW",0,{"$f":"E15*LocalCurrencyRate","v":0},null,0,null,{"$f":"H15*E15","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(J15*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D15=\"HW\",J15*HWdiscount,J15*Discount)","v":0},{"$f":"E15*H15*LocalCurrencyRate","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(M15*AnnualSupportPercentage),0),0)","v":0},null,"Alarm Control System software package, part no. 73001 or 73010 needed for dispatch of the alarms. Also choose the dispatch media for Alarm Control System."]
["Panic Alerting Demo Kit & Accessories"]
["Panic Alerting Demo Kit","Including:\n- 1 pc. Central Receiver\n- 2 pc. Panic Alerting Buttons incl. Part No. 42114 and 42115\n- 1 pc. PC-350 Unit Box\n- Demo License for Alarm Control System software including Panic Alarm Listener",44000,"HW",0,{"$f":"E17*LocalCurrencyRate","v":0},null,0,null,{"$f":"H17*E17","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(J17*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D17=\"HW\",J17*HWdiscount,J17*Discount)","v":0},{"$f":"E17*H17*LocalCurrencyRate","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(M17*AnnualSupportPercentage),0),0)","v":0}]
["USB Interface","For registration of panic buttons in Central Receivers using a PC",42139,"HW",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E21*LocalCurrencyRate","v":0},null,0,null,{"$f":"H21*E21","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(J21*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D21=\"HW\",J21*HWdiscount,J21*Discount)","v":0},{"$f":"E21*H21*LocalCurrencyRate","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(M21*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E22*LocalCurrencyRate","v":0},null,0,null,{"$f":"H22*E22","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(J22*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D22=\"HW\",J22*HWdiscount,J22*Discount)","v":0},{"$f":"E22*H22*LocalCurrencyRate","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(M22*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E23*LocalCurrencyRate","v":0},null,0,null,{"$f":"H23*E23","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(J23*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D23=\"HW\",J23*HWdiscount,J23*Discount)","v":0},{"$f":"E23*H23*LocalCurrencyRate","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(M23*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E25*LocalCurrencyRate","v":0},null,0,null,{"$f":"H25*E25","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(J25*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D25=\"HW\",J25*HWdiscount,J25*Discount)","v":0},{"$f":"E25*H25*LocalCurrencyRate","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(M25*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E26*LocalCurrencyRate","v":0},null,0,null,{"$f":"H26*E26","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(J26*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D26=\"HW\",J26*HWdiscount,J26*Discount)","v":0},{"$f":"E26*H26*LocalCurrencyRate","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(M26*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E27*LocalCurrencyRate","v":0},null,0,null,{"$f":"H27*E27","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(J27*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D27=\"HW\",J27*HWdiscount,J27*Discount)","v":0},{"$f":"E27*H27*LocalCurrencyRate","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(M27*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E28*LocalCurrencyRate","v":0},null,0,null,{"$f":"H28*E28","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(J28*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D28=\"HW\",J28*HWdiscount,J28*Discount)","v":0},{"$f":"E28*H28*LocalCurrencyRate","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(M28*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"TETRA Telemetry - RTCU","index":5,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["Remote Telemetry & Control Unit (RTCU) - TETRA Telemetry"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J28)","v":0},{"$f":"SUM(K12:K28)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L88)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[]
[]
["Remote Telemetry & Control Unit (RTCU)"]
["RTCU AX9","1-2 pcs. RTCU Units AX9 (price for each unit)\n- TETRA PEI interface for Sepura and Motorola radios\n- 5 Digital Alarm Input\n- 4 Relay Output\n- 4 Analog Input\n- Fail-over to build-in GSM/SMS communication\n- MODBUS connection for I/O Expansion Units, Part No. 38041 and 38065\n- IP67 enclosure\n- Build-in 230 VAC power supply",82009,"HW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["RTCU AX9","3-10 pcs. RTCU Units AX9 (price for each unit when ordering in one lot)\n- Specification as above",82010,"HW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["RTCU Fire Station","RTCU Unit especially developed for Fire Stations. Including:\n- Support for Motorola TETRA Call-out messages\n- Relay connection to PA system",82019,"HW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["RTCU VGA+Audio","Unit for showing fire station incidents on VGS monitors as well as incident message audio synthesis. Must be connection to one RTCU Fire Station unit (part no. 82019).",82025,"HW",0,{"$f":"E15*LocalCurrencyRate","v":0},null,0,null,{"$f":"H15*E15","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(J15*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D15=\"HW\",J15*HWdiscount,J15*Discount)","v":0},{"$f":"E15*H15*LocalCurrencyRate","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(M15*AnnualSupportPercentage),0),0)","v":0}]
["RTCU I/O Expansion Units"]
["RTCU Expansion 14xDI","MODBUS I/O Expansion Unit:\n- 14 Digital Inputs (Isolated)\n- 12-24 VDC external supply needed\n- For connection to Part No. 82009",38041,"HW",0,{"$f":"E17*LocalCurrencyRate","v":0},null,0,null,{"$f":"H17*E17","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(J17*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D17=\"HW\",J17*HWdiscount,J17*Discount)","v":0},{"$f":"E17*H17*LocalCurrencyRate","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(M17*AnnualSupportPercentage),0),0)","v":0}]
["RTCU Expansion 4xDI","MODBUS I/O Expansion Unit:\n- 4 Digital Inputs\n- 5 Digital Relay Outputs (250 V/5A)\n- 12-24 VDC external supply needed\n- For connection to Part No. 82009",38065,"HW",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E21*LocalCurrencyRate","v":0},null,0,null,{"$f":"H21*E21","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(J21*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D21=\"HW\",J21*HWdiscount,J21*Discount)","v":0},{"$f":"E21*H21*LocalCurrencyRate","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(M21*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E22*LocalCurrencyRate","v":0},null,0,null,{"$f":"H22*E22","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(J22*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D22=\"HW\",J22*HWdiscount,J22*Discount)","v":0},{"$f":"E22*H22*LocalCurrencyRate","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(M22*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E23*LocalCurrencyRate","v":0},null,0,null,{"$f":"H23*E23","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(J23*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D23=\"HW\",J23*HWdiscount,J23*Discount)","v":0},{"$f":"E23*H23*LocalCurrencyRate","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(M23*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E25*LocalCurrencyRate","v":0},null,0,null,{"$f":"H25*E25","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(J25*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D25=\"HW\",J25*HWdiscount,J25*Discount)","v":0},{"$f":"E25*H25*LocalCurrencyRate","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(M25*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E26*LocalCurrencyRate","v":0},null,0,null,{"$f":"H26*E26","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(J26*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D26=\"HW\",J26*HWdiscount,J26*Discount)","v":0},{"$f":"E26*H26*LocalCurrencyRate","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(M26*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E27*LocalCurrencyRate","v":0},null,0,null,{"$f":"H27*E27","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(J27*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D27=\"HW\",J27*HWdiscount,J27*Discount)","v":0},{"$f":"E27*H27*LocalCurrencyRate","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(M27*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E28*LocalCurrencyRate","v":0},null,0,null,{"$f":"H28*E28","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(J28*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D28=\"HW\",J28*HWdiscount,J28*Discount)","v":0},{"$f":"E28*H28*LocalCurrencyRate","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(M28*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"Staff Safety CLW & MDN","index":6,"n_rows":30,"n_cols":16,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["Staff Safety Solutions - Man Down Notifier (MDN) & Centralized Lone Worker (CLW)"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J30)","v":0},{"$f":"SUM(K12:K30)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L30)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[]
[]
["Centralized Lone Worker Software Package"]
["Centralized Lone Worker Package","Centralized Lone Worker Package (CLW), including:\n- 15 Users\n- Alarm Control System Lite software for CLW monitoring and automatic alarm dispatch on freely selected media (MOTOTRBO, TETRA, DECT, TEAM WiFi Phone or GSM)\n- First year Support & Software Upgrade License",73501,"SW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["Additional CLW Users","Number of CLW Users for purchase",73510,"SW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["CLW to ACS +Plus Upgrade","Upgrading from the MDN alarm dispatch to the full solution (upgrade from order no 73501 to 73001)",73515,"SW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["MOTOTRBO Man Down Notifier Package (MDN)"]
["Man Down Notifier","Man Down Notifier Package (MDN), including:\n- Alarm Control System software for MDN monitoring and automatic alarm dispatch on MOTOTRBO radios\n- MOTOTRBO radio support only\n- First year Support & Software Upgrade License",73401,"SW",0,{"$f":"E16*LocalCurrencyRate","v":0},null,0,null,{"$f":"H16*E16","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(J16*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D16=\"HW\",J16*HWdiscount,J16*Discount)","v":0},{"$f":"E16*H16*LocalCurrencyRate","v":0},{"$f":"IF($D16=\"SW\",IF($H16>0,(M16*AnnualSupportPercentage),0),0)","v":0},null,"Enables Man Down functionality on MOTOTRBO radios. Motorola Generic Option Board / GOB (Motorola part no. PMLN5496AS) must be installed in the radio."]
["Additional MDN Users","Number of MDN Users for purchase",73420,"SW",0,{"$f":"E17*LocalCurrencyRate","v":0},null,0,null,{"$f":"H17*E17","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(J17*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D17=\"HW\",J17*HWdiscount,J17*Discount)","v":0},{"$f":"E17*H17*LocalCurrencyRate","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(M17*AnnualSupportPercentage),0),0)","v":0}]
["MDN to ACS +Plus Upgrade","Upgrading from the MDN alarm dispatch to the full solution (upgrade from order no. 73410 to 73001)",73021,"SW",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
["CLW and MDN PC Hardware Pack"]
["PC Pack for CLW or MDN","PC Pack including:\n- Desktop PC (Dell or HP) with UK keyboard and mouse\n- Windows 7 operating system\n- Preinstalld CLW/MDN software",70001,"HW",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E22*LocalCurrencyRate","v":0},null,0,null,{"$f":"H22*E22","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(J22*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D22=\"HW\",J22*HWdiscount,J22*Discount)","v":0},{"$f":"E22*H22*LocalCurrencyRate","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(M22*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E23*LocalCurrencyRate","v":0},null,0,null,{"$f":"H23*E23","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(J23*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D23=\"HW\",J23*HWdiscount,J23*Discount)","v":0},{"$f":"E23*H23*LocalCurrencyRate","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(M23*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E24*LocalCurrencyRate","v":0},null,0,null,{"$f":"H24*E24","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(J24*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D24=\"HW\",J24*HWdiscount,J24*Discount)","v":0},{"$f":"E24*H24*LocalCurrencyRate","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(M24*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E25*LocalCurrencyRate","v":0},null,0,null,{"$f":"H25*E25","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(J25*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D25=\"HW\",J25*HWdiscount,J25*Discount)","v":0},{"$f":"E25*H25*LocalCurrencyRate","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(M25*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E27*LocalCurrencyRate","v":0},null,0,null,{"$f":"H27*E27","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(J27*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D27=\"HW\",J27*HWdiscount,J27*Discount)","v":0},{"$f":"E27*H27*LocalCurrencyRate","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(M27*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E28*LocalCurrencyRate","v":0},null,0,null,{"$f":"H28*E28","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(J28*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D28=\"HW\",J28*HWdiscount,J28*Discount)","v":0},{"$f":"E28*H28*LocalCurrencyRate","v":0},{"$f":"IF($D28=\"SW\",IF($H28>0,(M28*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E29*LocalCurrencyRate","v":0},null,0,null,{"$f":"H29*E29","v":0},{"$f":"IF($D29=\"SW\",IF($H29>0,(J29*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D29=\"HW\",J29*HWdiscount,J29*Discount)","v":0},{"$f":"E29*H29*LocalCurrencyRate","v":0},{"$f":"IF($D29=\"SW\",IF($H29>0,(M29*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E30*LocalCurrencyRate","v":0},null,0,null,{"$f":"H30*E30","v":0},{"$f":"IF($D30=\"SW\",IF($H30>0,(J30*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D30=\"HW\",J30*HWdiscount,J30*Discount)","v":0},{"$f":"E30*H30*LocalCurrencyRate","v":0},{"$f":"IF($D30=\"SW\",IF($H30>0,(M30*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"MOTOTRBO Phone & Voice","index":7,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["MOTOTRBO Phone Interconnect (RBX) and Voice Logging (R2R)"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J40)","v":0},{"$f":"SUM(K12:K40)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L40)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[null,null,null,null,null,null,null,0]
[]
["MOTOTRBO Phone Interconnect (RBX)"]
["RPX +Plus","RBX +Plus Core Platform (without PC), including:\n- RBX Core Software\n- 1 Voice Path\n- 1 TalkGroup\n- First years Support & Software Updates","T-02000","SW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["RBX +Plus Subscriber License","RBX +Plus Subscriber License (i.e. radio Users)\nEnables PBX functionality on MOTOTRBO radios. Motorola Generic Option Board / GOB (Motorola part no. PMLN5496AS) must be installed in the radio.","T-02001","SW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["Talkgroup License","Allows phone users to call a radio group.","T-03001","SW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["Voicepath License","Enables additional concurrent radio-phone call.\nAn additional audio card (part no. 70002) for the PC running the RBX must be purchased.","T-04001","SW",0,{"$f":"E15*LocalCurrencyRate","v":0},null,0,null,{"$f":"H15*E15","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(J15*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D15=\"HW\",J15*HWdiscount,J15*Discount)","v":0},{"$f":"E15*H15*LocalCurrencyRate","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(M15*AnnualSupportPercentage),0),0)","v":0}]
["RBX Phone Interconnect System Premium Upgrades"]
["Premium Upgrade Pack","Includes: \n- Call Recording (part no. T-06101)\n- User Provisioning (part no. T-06103)\n- Password Protection (part no. T-06104)","T-06100","SW",0,{"$f":"E17*LocalCurrencyRate","v":0},null,0,null,{"$f":"H17*E17","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(J17*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D17=\"HW\",J17*HWdiscount,J17*Discount)","v":0},{"$f":"E17*H17*LocalCurrencyRate","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(M17*AnnualSupportPercentage),0),0)","v":0}]
["Call Recording","Records all radio transmitions in a radio channel.","T-06101","SW",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
["User Provisioning","Manages the RBX contact list of every subscriber.","T-06103","SW",0,{"$f":"E19*LocalCurrencyRate","v":0},null,0,null,{"$f":"H19*E19","v":0},{"$f":"IF($D19=\"SW\",IF($H19>0,(J19*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D19=\"HW\",J19*HWdiscount,J19*Discount)","v":0},{"$f":"E19*H19*LocalCurrencyRate","v":0},{"$f":"IF($D19=\"SW\",IF($H19>0,(M19*AnnualSupportPercentage),0),0)","v":0}]
["Password Protection","Requires passwords for users to place phone calls.","T-06104","SW",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
["IP Site Connect Roaming","Allows users to roam from site to site and maintain telephone interconnect functionality. A minimum of 2 hours of Professional Services per repeater are required to design, configure and provision the system.","T-06300","SW",0,{"$f":"E21*LocalCurrencyRate","v":0},null,0,null,{"$f":"H21*E21","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(J21*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D21=\"HW\",J21*HWdiscount,J21*Discount)","v":0},{"$f":"E21*H21*LocalCurrencyRate","v":0},{"$f":"IF($D21=\"SW\",IF($H21>0,(M21*AnnualSupportPercentage),0),0)","v":0}]
["MOTOTRBO Voice Logging Solution (R2R)"]
["R2R Recording Core Platform","Includes:\n- R2R Recording Core Software\n- 1 pcs. R2R Recording Voice Path License","T-03003","SW",0,{"$f":"E23*LocalCurrencyRate","v":0},null,0,null,{"$f":"H23*E23","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(J23*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D23=\"HW\",J23*HWdiscount,J23*Discount)","v":0},{"$f":"E23*H23*LocalCurrencyRate","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(M23*AnnualSupportPercentage),0),0)","v":0}]
["R2R Recording Voice Path License","Additional Voice Path licenses for voice recording one radio channel.\nAn additional audio card (part no. 70002) for the PC running the R2R must be purchased.","T-03002","SW",0,{"$f":"E24*LocalCurrencyRate","v":0},null,0,null,{"$f":"H24*E24","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(J24*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D24=\"HW\",J24*HWdiscount,J24*Discount)","v":0},{"$f":"E24*H24*LocalCurrencyRate","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(M24*AnnualSupportPercentage),0),0)","v":0}]
["RBX and R2R Hardware"]
["PC Pack for RBX and R2R","PC Pack including:\n- Desktop PC (Dell or HP) with UK keyboard and mouse\n- Windows 7 operating system\n- Preinstalld RBX/R2R software\n- PCI Audio card for one Voice Path (part no. 70002)\n- RBX/R2R MotoTrbo audio cable connector (part no. 70005)",70000,"HW",0,{"$f":"E26*LocalCurrencyRate","v":0},null,0,null,{"$f":"H26*E26","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(J26*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D26=\"HW\",J26*HWdiscount,J26*Discount)","v":0},{"$f":"E26*H26*LocalCurrencyRate","v":0},{"$f":"IF($D26=\"SW\",IF($H26>0,(M26*AnnualSupportPercentage),0),0)","v":0}]
["Additional Audio Card","PCI Audio card for one additional Voice Path for RBX or R2R",70002,"HW",0,{"$f":"E27*LocalCurrencyRate","v":0},null,0,null,{"$f":"H27*E27","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(J27*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D27=\"HW\",J27*HWdiscount,J27*Discount)","v":0},{"$f":"E27*H27*LocalCurrencyRate","v":0},{"$f":"IF($D27=\"SW\",IF($H27>0,(M27*AnnualSupportPercentage),0),0)","v":0}]
["Analog to SIP Telephony Gateway","Connects RBX to analog phone systems.",70003,"HW",0,0,null,0,null,0,{"$f":"IF($D28=\"SW\",IF($H28>0,(J28*AnnualSupportPercentage),0),0)","v":0},0,0,{"$f":"IF($D28=\"SW\",IF($H28>0,(M28*AnnualSupportPercentage),0),0)","v":0}]
["GSM Gateway","Connects RBX through cellphone networks.",70004,"HW",0,0,null,0,null,0,{"$f":"IF($D29=\"SW\",IF($H29>0,(J29*AnnualSupportPercentage),0),0)","v":0},0,0,{"$f":"IF($D29=\"SW\",IF($H29>0,(M29*AnnualSupportPercentage),0),0)","v":0}]
["Audio Cable Connector","RBX/R2R MotoTrbo audio cable connector",70005,"HW",0,0,null,0,null,0,{"$f":"IF($D30=\"SW\",IF($H30>0,(J30*AnnualSupportPercentage),0),0)","v":0},0,0,{"$f":"IF($D30=\"SW\",IF($H30>0,(M30*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E32*LocalCurrencyRate","v":0},null,0,null,{"$f":"H32*E32","v":0},{"$f":"IF($D32=\"SW\",IF($H32>0,(J32*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D32=\"HW\",J32*HWdiscount,J32*Discount)","v":0},{"$f":"E32*H32*LocalCurrencyRate","v":0},{"$f":"IF($D32=\"SW\",IF($H32>0,(M32*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E33*LocalCurrencyRate","v":0},null,0,null,{"$f":"H33*E33","v":0},{"$f":"IF($D33=\"SW\",IF($H33>0,(J33*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D33=\"HW\",J33*HWdiscount,J33*Discount)","v":0},{"$f":"E33*H33*LocalCurrencyRate","v":0},{"$f":"IF($D33=\"SW\",IF($H33>0,(M33*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E34*LocalCurrencyRate","v":0},null,0,null,{"$f":"H34*E34","v":0},{"$f":"IF($D34=\"SW\",IF($H34>0,(J34*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D34=\"HW\",J34*HWdiscount,J34*Discount)","v":0},{"$f":"E34*H34*LocalCurrencyRate","v":0},{"$f":"IF($D34=\"SW\",IF($H34>0,(M34*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E35*LocalCurrencyRate","v":0},null,0,null,{"$f":"H35*E35","v":0},{"$f":"IF($D35=\"SW\",IF($H35>0,(J35*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D35=\"HW\",J35*HWdiscount,J35*Discount)","v":0},{"$f":"E35*H35*LocalCurrencyRate","v":0},{"$f":"IF($D35=\"SW\",IF($H35>0,(M35*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E37*LocalCurrencyRate","v":0},null,0,null,{"$f":"H37*E37","v":0},{"$f":"IF($D37=\"SW\",IF($H37>0,(J37*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D37=\"HW\",J37*HWdiscount,J37*Discount)","v":0},{"$f":"E37*H37*LocalCurrencyRate","v":0},{"$f":"IF($D37=\"SW\",IF($H37>0,(M37*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E38*LocalCurrencyRate","v":0},null,0,null,{"$f":"H38*E38","v":0},{"$f":"IF($D38=\"SW\",IF($H38>0,(J38*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D38=\"HW\",J38*HWdiscount,J38*Discount)","v":0},{"$f":"E38*H38*LocalCurrencyRate","v":0},{"$f":"IF($D38=\"SW\",IF($H38>0,(M38*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E39*LocalCurrencyRate","v":0},null,0,null,{"$f":"H39*E39","v":0},{"$f":"IF($D39=\"SW\",IF($H39>0,(J39*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D39=\"HW\",J39*HWdiscount,J39*Discount)","v":0},{"$f":"E39*H39*LocalCurrencyRate","v":0},{"$f":"IF($D39=\"SW\",IF($H39>0,(M39*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E40*LocalCurrencyRate","v":0},null,0,null,{"$f":"H40*E40","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(J40*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D40=\"HW\",J40*HWdiscount,J40*Discount)","v":0},{"$f":"E40*H40*LocalCurrencyRate","v":0},{"$f":"IF($D40=\"SW\",IF($H40>0,(M40*AnnualSupportPercentage),0),0)","v":0}]

{"sheet":"MOTOTRBO GPS Mapping","index":8,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["MOTOTRBO GPS Mapping"]
["Product","Product Description","Part No.","SW/HW","RRP - Recommended Retail Prices/Unit",null,null,"Qty.",null,"Total Price","Total Price annual support & Software Update",null,{"$f":"J2","v":"Total Price"},{"$f":"K2","v":"Total Price annual support & Software Update"},null,"Comments"]
[null,null,null,null,"(EUR)",{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},null,null,null,{"$f":"E3","v":"(EUR)"},{"$f":"E3","v":"(EUR)"},null,{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"},{"$f":"\"(\"&LocalCurrencySymbol&\")\"","v":"(AUD)"}]
[]
["Price Summary"]
[{"$f":"\"Recommended Retail Price (RRP), i.e. sales price for the \"&Customer","v":"Recommended Retail Price (RRP), i.e. sales price for the <Customer>"},null,null,null,null,null,null,null,null,{"$f":"SUM(J12:J25)","v":0},{"$f":"SUM(K12:K25)","v":0},null,{"$f":"J6*LocalCurrencyRate","v":0},0]
[{"$f":"Reseller&\" discount, i.e. margin\"","v":"XXXX discount, i.e. margin"},null,null,null,null,null,null,null,null,{"$f":"SUM(L12:L25)","v":0},{"$f":"K6*Discount","v":0},null,0,0]
[{"$f":"Reseller&\" cost when purchasing from ZZZZZZ\"","v":"XXXX cost when purchasing from ZZZZZZ"},null,null,null,null,null,null,null,null,{"$f":"J6-J7","v":0},{"$f":"K6-K7","v":0},null,0,0]
[]
[]
["GPS Mapping Solution"]
["neoNytro Standalone","neoNytro Standalone, including:\n- License for one workstation\n- Connection of one MOTOTRBO radio\n- First years Support & Software Upgrade","N-4143C1","SW",0,{"$f":"E12*LocalCurrencyRate","v":0},null,0,null,{"$f":"H12*E12","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(J12*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D12=\"HW\",J12*HWdiscount,J12*Discount)","v":0},{"$f":"E12*H12*LocalCurrencyRate","v":0},{"$f":"IF($D12=\"SW\",IF($H12>0,(M12*AnnualSupportPercentage),0),0)","v":0}]
["neoConneX","neoConneX, including:\n- Client/Server solution\n- For MotoTrbo Connect Plus\n- License for 25 radios\n- First years Support & Software Upgrade","N-4144E2","SW",0,{"$f":"E13*LocalCurrencyRate","v":0},null,0,null,{"$f":"H13*E13","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(J13*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D13=\"HW\",J13*HWdiscount,J13*Discount)","v":0},{"$f":"E13*H13*LocalCurrencyRate","v":0},{"$f":"IF($D13=\"SW\",IF($H13>0,(M13*AnnualSupportPercentage),0),0)","v":0}]
["Additional Users","Additional neoConneX radio users (in sets of 5)","N-4145W1","SW",0,{"$f":"E14*LocalCurrencyRate","v":0},null,0,null,{"$f":"H14*E14","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(J14*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D14=\"HW\",J14*HWdiscount,J14*Discount)","v":0},{"$f":"E14*H14*LocalCurrencyRate","v":0},{"$f":"IF($D14=\"SW\",IF($H14>0,(M14*AnnualSupportPercentage),0),0)","v":0}]
["neoConneX WEB map","neoConneX WEB map solution. Add-on to neoConneX","N-4145W1","SW",0,{"$f":"E15*LocalCurrencyRate","v":0},null,0,null,{"$f":"H15*E15","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(J15*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D15=\"HW\",J15*HWdiscount,J15*Discount)","v":0},{"$f":"E15*H15*LocalCurrencyRate","v":0},{"$f":"IF($D15=\"SW\",IF($H15>0,(M15*AnnualSupportPercentage),0),0)","v":0}]
["Professional Services"]
[{"$f":"'Alarm Control System'!A67","v":"On-site Support"},{"$f":"'Alarm Control System'!B67","v":"On-site support or training - 1/2 day"},55000,"-",0,{"$f":"E17*LocalCurrencyRate","v":0},null,0,null,{"$f":"H17*E17","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(J17*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D17=\"HW\",J17*HWdiscount,J17*Discount)","v":0},{"$f":"E17*H17*LocalCurrencyRate","v":0},{"$f":"IF($D17=\"SW\",IF($H17>0,(M17*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A68","v":"On-site Support"},{"$f":"'Alarm Control System'!B68","v":"On-site support or training - full day"},55001,"-",0,{"$f":"E18*LocalCurrencyRate","v":0},null,0,null,{"$f":"H18*E18","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(J18*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D18=\"HW\",J18*HWdiscount,J18*Discount)","v":0},{"$f":"E18*H18*LocalCurrencyRate","v":0},{"$f":"IF($D18=\"SW\",IF($H18>0,(M18*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A69","v":"On-site Support"},{"$f":"'Alarm Control System'!B69","v":"On-site support or training - per hour"},55002,"-",0,{"$f":"E19*LocalCurrencyRate","v":0},null,0,null,{"$f":"H19*E19","v":0},{"$f":"IF($D19=\"SW\",IF($H19>0,(J19*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D19=\"HW\",J19*HWdiscount,J19*Discount)","v":0},{"$f":"E19*H19*LocalCurrencyRate","v":0},{"$f":"IF($D19=\"SW\",IF($H19>0,(M19*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A70","v":"Remote Support"},{"$f":"'Alarm Control System'!B70","v":"Remote support from ZZZZZZ support center - 1/2 day"},55005,"-",0,{"$f":"E20*LocalCurrencyRate","v":0},null,0,null,{"$f":"H20*E20","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(J20*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D20=\"HW\",J20*HWdiscount,J20*Discount)","v":0},{"$f":"E20*H20*LocalCurrencyRate","v":0},{"$f":"IF($D20=\"SW\",IF($H20>0,(M20*AnnualSupportPercentage),0),0)","v":0}]
["Micellaneous"]
[{"$f":"'Alarm Control System'!A72","v":"Car transport"},{"$f":"'Alarm Control System'!B72","v":"Rate per km./mile to be driven by car"},55010,"-",null,{"$f":"E22*LocalCurrencyRate","v":0},null,0,null,{"$f":"H22*E22","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(J22*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D22=\"HW\",J22*HWdiscount,J22*Discount)","v":0},{"$f":"E22*H22*LocalCurrencyRate","v":0},{"$f":"IF($D22=\"SW\",IF($H22>0,(M22*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A73","v":"Transport"},{"$f":"'Alarm Control System'!B73","v":"Price for air, train and ferry transport costs"},55015,"-",null,{"$f":"E23*LocalCurrencyRate","v":0},null,0,null,{"$f":"H23*E23","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(J23*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D23=\"HW\",J23*HWdiscount,J23*Discount)","v":0},{"$f":"E23*H23*LocalCurrencyRate","v":0},{"$f":"IF($D23=\"SW\",IF($H23>0,(M23*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A74","v":"Accomodation"},{"$f":"'Alarm Control System'!B74","v":"Price for economy class hotel costs"},55020,"-",null,{"$f":"E24*LocalCurrencyRate","v":0},null,0,null,{"$f":"H24*E24","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(J24*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D24=\"HW\",J24*HWdiscount,J24*Discount)","v":0},{"$f":"E24*H24*LocalCurrencyRate","v":0},{"$f":"IF($D24=\"SW\",IF($H24>0,(M24*AnnualSupportPercentage),0),0)","v":0}]
[{"$f":"'Alarm Control System'!A75","v":"Travel expenses"},{"$f":"'Alarm Control System'!B75","v":"Daily rate for travel expenses like meals, parking etc."},55025,"-",null,{"$f":"E25*LocalCurrencyRate","v":0},null,0,null,{"$f":"H25*E25","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(J25*AnnualSupportPercentage),0),0)","v":0},{"$f":"IF(D25=\"HW\",J25*HWdiscount,J25*Discount)","v":0},{"$f":"E25*H25*LocalCurrencyRate","v":0},{"$f":"IF($D25=\"SW\",IF($H25>0,(M25*AnnualSupportPercentage),0),0)","v":0}]