{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Quote","Setup","Items","Notes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":74,"comments":0,"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":"Quote","index":0,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[[45,1,45,4],[51,5,52,5],[51,4,52,4],[51,1,52,1],[51,2,52,3],[50,2,50,3],[47,1,47,4],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[74,1,74,2],[56,1,56,5],[58,1,58,5],[60,1,60,5],[62,1,62,5],[59,1,59,5],[61,1,61,5],[63,1,63,5],[72,1,72,5],[73,1,73,5],[64,1,64,5],[65,1,65,5],[66,1,66,5],[68,1,68,5],[69,1,69,5],[70,1,70,5],[71,1,71,5],[9,4,9,5],[53,1,53,5],[6,4,6,5],[7,4,7,5],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,1,10,5],[8,4,8,5],[67,1,67,5],[54,1,54,5],[55,1,55,5],[57,1,57,5],[49,1,49,5]]}
[]
[null," "]
[null,{"$f":"COMPANY&\"   ABN - \"&ABN","v":"Automatic Solutions Australia   ABN - 56 118 383 574"}]
[null,{"$f":"TAS&\"   \"&ADDRESS","v":"Automatic Gate Solutions   146 Bannister Road Canning Vale WA 6155"}]
[null,{"$f":"SALESPERSON&\"   \"&TELEPHONE&\"   Email- \"&EMAIL","v":"Paul Bindon   61 8 94563901   Email- sales@automaticsolutions.com.au"}]
[null," "]
[null,"CLIENT -",null,null,"DATE"]
[null,"SITE -",null,null,{"$f":"TODAY()","v":"2024-06-28"}]
[null,"PHONE -",null,null,"QUOTE NUMBER"]
[null,"EMAIL -"]
[null," "]
[null,"QTY","ITEM","DESCRIPTION","RETAIL","DISCOUNTED"]
[null,null,null,{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,[0]!ITEMS,3,FALSE))","v":""},{"$f":"IF(ISBLANK(C13),\"\",((B13*E13)*0.68181))","v":""},null,null," "]
[null,null,null,{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,[0]!ITEMS,3,FALSE))","v":""},{"$f":"IF(ISBLANK(C14),\"\",((B14*E14)*0.68181))","v":""}]
[null,null,null,{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(C28,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(C28,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(C29,[0]!ITEMS,2,FALSE))","v":""},null,""]
[null,null,null,{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(C30,[0]!ITEMS,2,FALSE))","v":""},null,""]
[null,null,null,{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(C31,[0]!ITEMS,2,FALSE))","v":""},null,""]
[null,null,null,{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(C32,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(C32,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(C33,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(C33,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,[0]!ITEMS,2,FALSE))","v":""},{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,[0]!ITEMS,3,FALSE))","v":""},""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(ISBLANK(C45),\"\",B45*E45)","v":""}]
[null,"PRODUCT TOTAL EXCLUDING GST -",null,null,null,{"$f":"SUM(F13:F45)","v":0}]
[]
[null,"INSTALL ESTIMATE EXCLUDING GST (Subject to site confirmation) -",null,null,null,0]
[]
[null,"Acceptance of proposal - By signing below customer agrees that they have checked all items and services included in the proposal and further agree that they understand all items and services. The customer acknowledges the attached \"Specifications and conditions on which this proposal is based\" and declares that it is in accordance with my specification, mode of operation, control and safety requirements, that the finish and treatment match my environmental concerns, that the warranty terms are suitable to my requirements, that the delivery proposal is acceptable, that the site specific clauses have been noted and that the terms of payment are acceptable."]
[null,"NAME -"]
[null,"SIGN -",null,null,"DATE -"]
[]
[null,"www.automaticgatesolutions.com.au"]
[]
[null,"Customers specification - "]
[]
[null,"Method of operation and control - "]
[]
[null,"Safety accessories included - "]
[]
[null,"Finishes and treatments included - "]
[]
[null,"Proposed delivey schedule - "]
[]
[null,"Warranty and service area - Where product is installed by Automatic Gate Solutions we provide warranty and service during office hours within our service area. Should an installation fall outside of the service area any future service and/or warranty work will be charged travel fees at the then current \"TRAVEL\" fees and charges. Work performed whilst on-site will be charged as applicable at normal rates and any on-sitework deemed warranty will be no charge. Service area is defined as a 35 kilometre radius of our home base."]
[null,"Warranty period - Automatic Gate Solutions can tailor both warranty period and maintenance programs to suit customers requirements. Customers requirements in this regard are noted below and the total price has been adjusted to reflect the required warranty period. "]
[null,"Product warranty period is 24 months from date of handover."]
[null,"Delivery and installation terms - Automatic Gate Solutions agrees to make every reasonable effort to perform to the proposed delivery schedule given that customer accepts the proposal within seven days. Customer understands that after this time delivery schedules can vary based on workload levels and that further enquiry is required to determine the current appropriate delivery schedule."]
[null,"Delays beyond control - Automatic Gate Solutions understands that delays can occur from both a customers point of view and a supply point of view. Acts of god as well as man made acts can cause delay/s beyond control. Automatic Gate Solutions and customer agree to work in harmony to minimise and if possible avoid delay beyond control. Any variation agreed will focus on restoring the proposed delivery schedule. Automatic Gate Solutions and customer agree that any delay beyond control causing departure from the proposed delivery schedule will not constitute reason for cancellation of the proposal or order."]
[null,"Site excavation and discovery of services - Customer understands any and all site excavation required to complete the installation and warrants that they have taken all necessary and reasonable steps to determine that required excavation will not impact on existing services. Customer further agrees that no other enquiry is required by Automatic Gate Solutions in relation to the position of existing services. Customer agrees that any discovery of services requiring relocation will be at customers cost"]
[null,"Existing site conditions - Customer confirms that Automatic Gate Solutions and customer has to the extent possible determined the suitability of the exisiting site and site improvements to accept the installation and its attachments and is satisfied that no further effort in this regard is necessary. Customer agrees that discovery to the contrary requiring further works will be at customers cost. Customer is responsible for compliance with property boundaries. "]
[null,"Third party reliance - Where customer is facilitating either a service or product on which the installation or the performance of any product relies failure of this third party service or product does not constitute a failure of Automatic Gate Solutions or its products. Customer agrees that third party service or product performance and/or changes are outside the control of Automatic Gate Solutions and holds Automatic Gate Solutions harmless from any action, claims, liability or loss in respect of the performance of the services or products."]
[null,"Terms of payment - Payment terms are fifty deposit with order (50%) and the remainder payable at or before handover and commissioning. Payments to the installer may be made by cheque, cash or credit card. All works performed out of service area must be paid in full before any works can be scheduled. Payments by electronic funds transfer (EFT) must be made prior to handover and commissioning.\nCredit Cards Accepted - VISA and MASTERCARD"]
[null,"Bank detail for electronic payment - BSB:",null,{"$f":"BSB&\"   Account number: \"&ACCOUNT","v":"633-000   Account number: 128172079"},"Date - ",{"$f":"TODAY()","v":"2024-06-28"}]

{"sheet":"Setup","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Company Name - ","Automatic Solutions Australia"]
["Company ABN - ","56 118 383 574"]
["Trading As - ","Automatic Gate Solutions"]
["Address -","146 Bannister Road Canning Vale WA 6155"]
["Sales Person - ","Paul Bindon"]
["Telephone - ","61 8 94563901"]
["Email - ","sales@automaticsolutions.com.au"]
["Bank BSB - ","633-000"]
["Bank Account No -",128172079]

{"sheet":"Items","index":2,"n_rows":790,"n_cols":9,"rows_kept":790,"cut":false,"hidden":true,"merged":[]}
["Item Name","Description","Selling Price","Search","Frequency","Final List"]
["MB24KIT","MB24KIT - Articulated arm double gate kit (24 volts - 2.5 metres)",3077,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A2),0)","v":1},{"$f":"IF(D2=0,\"\",COUNTIF($D$2:D2,\">0\"))","v":1},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D1),E:E,0)),\"\")","v":"MB24KIT"},null,null," "]
["MB24","MB24 - Articulated arm operator (24 volts - 2.5 metres)",1150,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A3),0)","v":1},{"$f":"IF(D3=0,\"\",COUNTIF($D$2:D3,\">0\"))","v":2},"MB24"]
["PRPLKIT","PRPLKIT - Longitudinal mounting plate for PR arm operator",130,1,{"$f":"IF(D4=0,\"\",COUNTIF($D$2:D4,\">0\"))","v":3},"PRPLKIT",null,null," "]
["PR24","PR24 - Articulated arm operator (24 volts - 3.0 metres)",1353,1,{"$f":"IF(D5=0,\"\",COUNTIF($D$2:D5,\">0\"))","v":4},"PR24",null,null," "]
["PR24KIT","PR24KIT - Articulated arm double gate kit (24 volts - 3.0 metres)",3481,1,{"$f":"IF(D6=0,\"\",COUNTIF($D$2:D6,\">0\"))","v":5},"PR24KIT"]
["BEAUTYKIT","BEAUTYKIT - Double gate kit (24 volts - 2.0 metres)",1618,1,{"$f":"IF(D7=0,\"\",COUNTIF($D$2:D7,\">0\"))","v":6},"BEAUTYKIT"]
["PRBSKITRH","PRBSKITRH - Right slide arm kit for PR articulated arm operator",340,1,{"$f":"IF(D8=0,\"\",COUNTIF($D$2:D8,\">0\"))","v":7},"PRBSKITRH"]
["ARM270240","ARM270240 - 240V Swing gate operator for gates to 5 metres",591,1,{"$f":"IF(D9=0,\"\",COUNTIF($D$2:D9,\">0\"))","v":8},"ARM270240"]
["ARM290BI","ARM290BI - 12V Swing gate operator for gates to 6 metres",1537,1,{"$f":"IF(D10=0,\"\",COUNTIF($D$2:D10,\">0\"))","v":9},"ARM290BI"]
["HD5024EAC","HD5024EAC - 24 volt hydraulic operator (24 volts - 5.0 metres)",2288,1,{"$f":"IF(D11=0,\"\",COUNTIF($D$2:D11,\">0\"))","v":10},"HD5024EAC"]
["HD80","HD80 - 240 Volt hydraulic swing gate drive unit ",4145,1,{"$f":"IF(D12=0,\"\",COUNTIF($D$2:D12,\">0\"))","v":11},"HD80"]
["PRBSKITLH","PRBSKITLH - Left slide arm kit for PR articulated arm operator",340,1,{"$f":"IF(D13=0,\"\",COUNTIF($D$2:D13,\">0\"))","v":12},"PRBSKITLH"]
["650ARMKITSTF","650ARMKITSTF - Set of bolt together post brackets for ARM",56,1,{"$f":"IF(D14=0,\"\",COUNTIF($D$2:D14,\">0\"))","v":13},"650ARMKITSTF"]
["ARM25012","ARM25012 - 12V Swing gate operator for gates to 4 metres",770,1,{"$f":"IF(D15=0,\"\",COUNTIF($D$2:D15,\">0\"))","v":14},"ARM25012"]
["BOB3024DK","BOB3024DK - 24 volt swing gate operator (24 volts - 3.0 metres)",942,1,{"$f":"IF(D16=0,\"\",COUNTIF($D$2:D16,\">0\"))","v":15},"BOB3024DK"]
["BOB5024ANZ","BOB5024ANZ - 24 volt single gate operator (24 volts - 5.0 metres)",942,1,{"$f":"IF(D17=0,\"\",COUNTIF($D$2:D17,\">0\"))","v":16},"BOB5024ANZ"]
["R18BOX","R18BOX - Foundation box for R18FAST with s/steel cover. ",402,1,{"$f":"IF(D18=0,\"\",COUNTIF($D$2:D18,\">0\"))","v":17},"R18BOX"]
["R18FAST","R18FAST - 12 volt underground swing gate (12 volts - 1.2 metres)",909,1,{"$f":"IF(D19=0,\"\",COUNTIF($D$2:D19,\">0\"))","v":18},"R18FAST"]
["ALPHALH5500","ALPHALH5500 - 24 volt swing gate drive unit (24 volts - 5.5 metres)",1287,1,{"$f":"IF(D20=0,\"\",COUNTIF($D$2:D20,\">0\"))","v":19},"ALPHALH5500"]
["ALPHARH5500","ALPHARH5500 - 24 volt swing gate drive unit (24 volts - 5.5 metres)",1287,1,{"$f":"IF(D21=0,\"\",COUNTIF($D$2:D21,\">0\"))","v":20},"ALPHARH5500"]
["PRSNKIT","PRSNKIT - Rising arm kit for PR articulated arm operator",289,1,{"$f":"IF(D22=0,\"\",COUNTIF($D$2:D22,\">0\"))","v":21},"PRSNKIT"]
["TOM3024E","TOM3024E - 24 volt swing gate operator (24 volts - 3.0 metres)",961,1,{"$f":"IF(D23=0,\"\",COUNTIF($D$2:D23,\">0\"))","v":22},"TOM3024E"]
["TOM5024E","TOM5024E - 24 volt single gate operator (24 volts - 5.0 metres)",1113,1,{"$f":"IF(D24=0,\"\",COUNTIF($D$2:D24,\">0\"))","v":23},"TOM5024E"]
["R50","R50 - Jockey wheel swing gate drive unit. (240 volts - 11.0 metres)",7710,1,{"$f":"IF(D25=0,\"\",COUNTIF($D$2:D25,\">0\"))","v":24},"R50"]
["R60","R60 - Jockey wheel type swing gate drive unit.",21288,1,{"$f":"IF(D26=0,\"\",COUNTIF($D$2:D26,\">0\"))","v":25},"R60"]
["OUTSWING","OUTSWING - Outswing linear motor bracket",76,1,{"$f":"IF(D27=0,\"\",COUNTIF($D$2:D27,\">0\"))","v":26},"OUTSWING"]
["ASAEXTPOSTBRAC","ASAEXTPOSTBRAC - Long post bracket for ASA motors",38,1,{"$f":"IF(D28=0,\"\",COUNTIF($D$2:D28,\">0\"))","v":27},"ASAEXTPOSTBRAC"]
["ASA30012VRH","ASA30012VRH - swing gate motor - right hand (12 volts - 3.0 metres)",584,1,{"$f":"IF(D29=0,\"\",COUNTIF($D$2:D29,\">0\"))","v":28},"ASA30012VRH"]
["ASA30012VLH","ASA30012VLH - swing gate motor - left hand (12 volts - 3.0 metres)",584,1,{"$f":"IF(D30=0,\"\",COUNTIF($D$2:D30,\">0\"))","v":29},"ASA30012VLH"]
["ASA60012VRH","ASA60012VRH - swing gate motor - right hand (12 volts - 5.0 metres)",607,1,{"$f":"IF(D31=0,\"\",COUNTIF($D$2:D31,\">0\"))","v":30},"ASA60012VRH"]
["ASA60012VLH","ASA60012VLH - swing gate motor - left hand (12 volts - 5.0 metres)",607,1,{"$f":"IF(D32=0,\"\",COUNTIF($D$2:D32,\">0\"))","v":31},"ASA60012VLH"]
["JOINTMASTER","JOINTMASTER - Articulated arm master side. (240 volts - 4.0 metres)",2979,1,{"$f":"IF(D33=0,\"\",COUNTIF($D$2:D33,\">0\"))","v":32},"JOINTMASTER"]
["JOINTSLAVE","JOINTSLAVE - Articulated arm slave side. (240 volts - 4.0 metres)",2556,1,{"$f":"IF(D34=0,\"\",COUNTIF($D$2:D34,\">0\"))","v":33},"JOINTSLAVE"]
["DUIT24NVE","DUIT24NVE - 24 volt underground motor (24 volts - 3.5 metres)",1113,1,{"$f":"IF(D35=0,\"\",COUNTIF($D$2:D35,\">0\"))","v":34},"DUIT24NVE"]
["DUITFOUNDATION","DUITFOUNDATION - Foundation box for DUIT24NVE",390,1,{"$f":"IF(D36=0,\"\",COUNTIF($D$2:D36,\">0\"))","v":35},"DUITFOUNDATION"]
["DUIT90RELEASE","DUIT90RELEASE - 90 degree opening kit for DUIT24NVE",246,1,{"$f":"IF(D37=0,\"\",COUNTIF($D$2:D37,\">0\"))","v":36},"DUIT90RELEASE"]
["DUIT180RELEASE","DUIT180RELEASE - 180 degree opening kit for DUIT24NVE",460,1,{"$f":"IF(D38=0,\"\",COUNTIF($D$2:D38,\">0\"))","v":37},"DUIT180RELEASE"]
["TONEKIT5E","TONEKIT5E - Sliding gate kit with two remotes (240 volt - 500kg)",1007,1,{"$f":"IF(D39=0,\"\",COUNTIF($D$2:D39,\">0\"))","v":38},"TONEKIT5E"]
["SLIDEDAMPER","SLIDEDAMPER - Hydraulic damper for slide gates to 30 NM",1680,1,{"$f":"IF(D40=0,\"\",COUNTIF($D$2:D40,\">0\"))","v":39},"SLIDEDAMPER"]
["TONEKIT6B","TONEKIT6B - Kit with two remotes and photocells. (12 volt - 600kg)",1311,1,{"$f":"IF(D41=0,\"\",COUNTIF($D$2:D41,\">0\"))","v":40},"TONEKIT6B"]
["MASTER18QR","MASTER18QR - Sliding motor with logic control, (12 volt - 1800kg)",1643,1,{"$f":"IF(D42=0,\"\",COUNTIF($D$2:D42,\">0\"))","v":41},"MASTER18QR"]
["TONEKIT8E","TONEKIT8E - Kit with two remotes and photocell. (240 volt - 800kg)",1162,1,{"$f":"IF(D43=0,\"\",COUNTIF($D$2:D43,\">0\"))","v":42},"TONEKIT8E"]
["TONEKITXLE","TONEKITXLE - Kit with two remotes and photocell. (240 volt - 1200kg)",1230,1,{"$f":"IF(D44=0,\"\",COUNTIF($D$2:D44,\">0\"))","v":43},"TONEKITXLE"]
["TAUKB4","TAUKB4 - Battery charge module",128,1,{"$f":"IF(D45=0,\"\",COUNTIF($D$2:D45,\">0\"))","v":44},"TAUKB4"]
["TAUBATTKIT","TAUBATTKIT - Battery charge module + battery",158,1,{"$f":"IF(D46=0,\"\",COUNTIF($D$2:D46,\">0\"))","v":45},"TAUBATTKIT"]
["DIAMONDBATT","DIAMONDBATT - Battery backup cable for TAU Diamond boards",7.3000000000000007,1,{"$f":"IF(D47=0,\"\",COUNTIF($D$2:D47,\">0\"))","v":46},"DIAMONDBATT"]
["BULL424SW","BULL424SW - Sliding gate motor with logic control. (24 volt - 450kg)",1024,1,{"$f":"IF(D48=0,\"\",COUNTIF($D$2:D48,\">0\"))","v":47},"BULL424SW"]
["BULLSWBATTMOD","BULLSWBATTMOD - Backup module for  BULL424SW",129,1,{"$f":"IF(D49=0,\"\",COUNTIF($D$2:D49,\">0\"))","v":48},"BULLSWBATTMOD"]
["CBY24VBATTBUP","CBY24VBATTBUP - Backup kit BULL424, BULL624 and BEAUTY",284,1,{"$f":"IF(D50=0,\"\",COUNTIF($D$2:D50,\">0\"))","v":49},"CBY24VBATTBUP"]
["TONEKIT10B","TONEKIT10B - Kit with two remotes and photocells. (12 volt - 1000kg)",1446,1,{"$f":"IF(D51=0,\"\",COUNTIF($D$2:D51,\">0\"))","v":50},"TONEKIT10B"]
["BULL624TURBO","BULL624TURBO - Sliding motor with logic control. (24 volt - 600kg) ",1724,1,{"$f":"IF(D52=0,\"\",COUNTIF($D$2:D52,\">0\"))","v":51},"BULL624TURBO"]
["SYNCMODULE","SYNCMODULE - Module to sync two automations.",157,1,{"$f":"IF(D53=0,\"\",COUNTIF($D$2:D53,\">0\"))","v":52},"SYNCMODULE"]
["BIG18","BIG18 - Sliding gate motor with logic control. (240 volt - 2500kg) ",2194,1,{"$f":"IF(D54=0,\"\",COUNTIF($D$2:D54,\">0\"))","v":53},"BIG18"]
["INVERTER","INVERTER - Single phase to 3 phase inverter",478,1,{"$f":"IF(D55=0,\"\",COUNTIF($D$2:D55,\">0\"))","v":54},"INVERTER"]
["RACK1020","RACK1020 - Steel reinforced sliding gate rack - 1020mm",24,1,{"$f":"IF(D56=0,\"\",COUNTIF($D$2:D56,\">0\"))","v":55},"RACK1020"]
["RACK1000","RACK1000 - Steel reinforced sliding gate rack - 1000mm",24,1,{"$f":"IF(D57=0,\"\",COUNTIF($D$2:D57,\">0\"))","v":56},"RACK1000"]
["RACKSTEEL","RACKSTEEL  - 1 metre galv steel sliding gate rack with fix angle",41,1,{"$f":"IF(D58=0,\"\",COUNTIF($D$2:D58,\">0\"))","v":57},"RACKSTEEL"]
["LEPUSFAST","LEPUSFAST - Ind slider to 27 mtrs per minute. (240 volt - 2500kg)",4320,1,{"$f":"IF(D59=0,\"\",COUNTIF($D$2:D59,\">0\"))","v":58},"LEPUSFAST"]
["BISON25","BISON25 - Industrial slider with inverter. (240 volt - 2500kg)",4676,1,{"$f":"IF(D60=0,\"\",COUNTIF($D$2:D60,\">0\"))","v":59},"BISON25"]
["BIG40QI","BIG40QI - Sliding gate motor with logic control. (240 volt - 4000kg) ",6174,1,{"$f":"IF(D61=0,\"\",COUNTIF($D$2:D61,\">0\"))","v":60},"BIG40QI"]
["BULL1524","BULL1524 - Sliding gate motor with logic control. (24 volt - 1500kg)",2144,1,{"$f":"IF(D62=0,\"\",COUNTIF($D$2:D62,\">0\"))","v":61},"BULL1524"]
["BULL1524BATT","BULL1524BATT - Battery backup kit for BULL1524",56,1,{"$f":"IF(D63=0,\"\",COUNTIF($D$2:D63,\">0\"))","v":62},"BULL1524BATT"]
["CHAIN5M","CHAIN5M - Chain five metre: require width plus one metre",170,1,{"$f":"IF(D64=0,\"\",COUNTIF($D$2:D64,\">0\"))","v":63},"CHAIN5M"]
["ASA612","ASA612  - Sliding gate motor with logic control. (12 volt - 600kg)",872,1,{"$f":"IF(D65=0,\"\",COUNTIF($D$2:D65,\">0\"))","v":64},"ASA612"]
["CHAINENDS","CHAINENDS - Pair of end clamps for chain drive",201,1,{"$f":"IF(D66=0,\"\",COUNTIF($D$2:D66,\">0\"))","v":65},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D65),E:E,0)),\"\")","v":"CHAINENDS"}]
["MASTER20QRA","MASTER20QRA - Sliding motor with logic control. (240 volt - 2000kg) ",1353,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A67),0)","v":1},{"$f":"IF(D67=0,\"\",COUNTIF($D$2:D67,\">0\"))","v":66},"MASTER20QRA"]
["MASTER20CHAIN","MASTER20CHAIN - Sliding gate motor with chain drive",1638,1,{"$f":"IF(D68=0,\"\",COUNTIF($D$2:D68,\">0\"))","v":67},"MASTER20CHAIN"]
["REMGR","REMGR  - Four channel 433 mhz keyring style transmitter",50,1,{"$f":"IF(D69=0,\"\",COUNTIF($D$2:D69,\">0\"))","v":68},"REMGR"]
["REMKEY","REMKEY - Four channel Key Automation transmitter.",109,1,{"$f":"IF(D70=0,\"\",COUNTIF($D$2:D70,\">0\"))","v":69},"REMKEY"]
["REMBENINCA","REMBENINCA- Four channel Beninca transmitter.",69,1,{"$f":"IF(D71=0,\"\",COUNTIF($D$2:D71,\">0\"))","v":70},"REMBENINCA"]
["RECBENINCASA","RECBENINCASA- Two channel Beninca receiver.",128,1,{"$f":"IF(D72=0,\"\",COUNTIF($D$2:D72,\">0\"))","v":71},"RECBENINCASA"]
["REMMICRO","REMMICRO- Four channel transmitter.",60,1,{"$f":"IF(D73=0,\"\",COUNTIF($D$2:D73,\">0\"))","v":72},"REMMICRO"]
["REMBEAUTY","REMBEAUTY- Two channel transmitter.",72,1,{"$f":"IF(D74=0,\"\",COUNTIF($D$2:D74,\">0\"))","v":73},"REMBEAUTY"]
["GATEBOX","GATEBOX - WiFi remote control module with phone app.",165,1,{"$f":"IF(D75=0,\"\",COUNTIF($D$2:D75,\">0\"))","v":74},"GATEBOX"]
["GSMREMOTE","GSMREMOTE - GSM remote control for control by phone.",397,1,{"$f":"IF(D76=0,\"\",COUNTIF($D$2:D76,\">0\"))","v":75},"GSMREMOTE"]
["SHERLOTX4","SHERLOTX4  - 4channel long range transmitter - Keyring style.",91,1,{"$f":"IF(D77=0,\"\",COUNTIF($D$2:D77,\">0\"))","v":76},"SHERLOTX4"]
["SHERLOWMTX","SHERLOWMTX - Single channel outdoor long range pushbutton ",173,1,{"$f":"IF(D78=0,\"\",COUNTIF($D$2:D78,\">0\"))","v":77},"SHERLOWMTX"]
["SHERLOCOMRX","SHERLOCOMRX - Complex receiver 2000 user",473,1,{"$f":"IF(D79=0,\"\",COUNTIF($D$2:D79,\">0\"))","v":78},"SHERLOCOMRX"]
["SHERLOTX1","SHERLOTX1  - Single channel long range transmitter - Keyring style.",73,1,{"$f":"IF(D80=0,\"\",COUNTIF($D$2:D80,\">0\"))","v":79},"SHERLOTX1"]
["LOGICBENINCA24","LOGICBENINCA24 - 24 volt logic control in outdoor enclosure.",840,1,{"$f":"IF(D81=0,\"\",COUNTIF($D$2:D81,\">0\"))","v":80},"LOGICBENINCA24"]
["SHERLORX1500","SHERLORX1500  - Long range receiver with antenna",248,1,{"$f":"IF(D82=0,\"\",COUNTIF($D$2:D82,\">0\"))","v":81},"SHERLORX1500"]
["HYBRA24","HYBRA24 - 24 volt hydraulic logic control in outdoor enclosure.",941,1,{"$f":"IF(D83=0,\"\",COUNTIF($D$2:D83,\">0\"))","v":82},"HYBRA24"]
["RECASASA","RECASASA  - Two channel outdoor receiver with receiver",137,1,{"$f":"IF(D84=0,\"\",COUNTIF($D$2:D84,\">0\"))","v":83},"RECASASA"]
["RECRIBSA","RECRIBSA - Two channel RIB 433 mhz receiver - hardwire",199,1,{"$f":"IF(D85=0,\"\",COUNTIF($D$2:D85,\">0\"))","v":84},"RECRIBSA"]
["ANTENNA","ANTENNA - 433mhz outdoor antenna with fixing bracket.",66,1,{"$f":"IF(D86=0,\"\",COUNTIF($D$2:D86,\">0\"))","v":85},"ANTENNA"]
["REMRIB","REMRIB  - RIB four channel keyring style transmitter.",85,1,{"$f":"IF(D87=0,\"\",COUNTIF($D$2:D87,\">0\"))","v":86},"REMRIB"]
["LOGICCB6","LOGICCB6  - 240 volt logic controller in outdoor enclosure.",956,1,{"$f":"IF(D88=0,\"\",COUNTIF($D$2:D88,\">0\"))","v":87},"LOGICCB6"]
["LOGICID200","LOGICID200  - 12/24 volt logic controller in enclosure.",447,1,{"$f":"IF(D89=0,\"\",COUNTIF($D$2:D89,\">0\"))","v":88},"LOGICID200"]
["PCBID120","PCBID120  - 240 volt sliding gate logic controller with receiver.",216,1,{"$f":"IF(D90=0,\"\",COUNTIF($D$2:D90,\">0\"))","v":89},"PCBID120"]
["LOGICCA310","LOGICCA310  - 240 volt swing gate logic controller in enclosure.",325,1,{"$f":"IF(D91=0,\"\",COUNTIF($D$2:D91,\">0\"))","v":90},"LOGICCA310"]
["LOGICTAUD770M","LOGICTAUD770M - 240 volt logic control in outdoor enclosure.",399,1,{"$f":"IF(D92=0,\"\",COUNTIF($D$2:D92,\">0\"))","v":91},"LOGICTAUD770M"]
["LOGICEGATE1224","LOGICEGATE1224  - 12/24 ACDC logic controller - PCB",576,1,{"$f":"IF(D93=0,\"\",COUNTIF($D$2:D93,\">0\"))","v":92},"LOGICEGATE1224"]
["RELOCATEBOX","RELOCATEBOX - Terminal box, plug lead and 3 cable glands.",51,1,{"$f":"IF(D94=0,\"\",COUNTIF($D$2:D94,\">0\"))","v":93},"RELOCATEBOX"]
["REMASA","REMASA  - Four channel 433 mhz keyring style transmitter.",73,1,{"$f":"IF(D95=0,\"\",COUNTIF($D$2:D95,\">0\"))","v":94},"REMASA"]
["REMELSEMA","REMELSEMA - Elsema four channel remote control.",78,1,{"$f":"IF(D96=0,\"\",COUNTIF($D$2:D96,\">0\"))","v":95},"REMELSEMA"]
["TAUMEMORY254","TAUMEMORY254 - 254 channel memory chip for RECTAUKIT.",54,1,{"$f":"IF(D97=0,\"\",COUNTIF($D$2:D97,\">0\"))","v":96},"TAUMEMORY254"]
["REMTAU","REMTAU - TAU 433 mhz keyring transmitter.",66,1,{"$f":"IF(D98=0,\"\",COUNTIF($D$2:D98,\">0\"))","v":97},"REMTAU"]
["REMSEA","REMSEA - SEA 4 channel keyring transmitter - 433 mhz. ",71,1,{"$f":"IF(D99=0,\"\",COUNTIF($D$2:D99,\">0\"))","v":98},"REMSEA"]
["RECTAUKIT","RECTAUKIT - Receiver and two remote kit.",253,1,{"$f":"IF(D100=0,\"\",COUNTIF($D$2:D100,\">0\"))","v":99},"RECTAUKIT"]
["ER14250","ER14250 3.6 volt battery for Beninca keypads",15,1,{"$f":"IF(D101=0,\"\",COUNTIF($D$2:D101,\">0\"))","v":100},"ER14250"]
["CR2016","CR2016 - 3V Lithium Coin Battery",3,1,{"$f":"IF(D102=0,\"\",COUNTIF($D$2:D102,\">0\"))","v":101},"CR2016"]
["27A","27A Battery for ASA remotes.",3,1,{"$f":"IF(D103=0,\"\",COUNTIF($D$2:D103,\">0\"))","v":102},"27A"]
["23A","23A Battery",3,1,{"$f":"IF(D104=0,\"\",COUNTIF($D$2:D104,\">0\"))","v":103},"23A"]
["LOGICTAUD749MA","LOGICTAUD749MA - 12 volt logic control in outdoor enclosure.",725,1,{"$f":"IF(D105=0,\"\",COUNTIF($D$2:D105,\">0\"))","v":104},"LOGICTAUD749MA"]
["LOCKELEC","LOCKELEC  - Viro galvanised electric swing gate lock ",312,1,{"$f":"IF(D106=0,\"\",COUNTIF($D$2:D106,\">0\"))","v":105},"LOCKELEC"]
["LOCKSTRIKE","LOCKSTRIKE - Strike plate suitable for bottom fit locks",29,1,{"$f":"IF(D107=0,\"\",COUNTIF($D$2:D107,\">0\"))","v":106},"LOCKSTRIKE"]
["LOCKLM149","LOCKLM149 - Electric gate lock",167,1,{"$f":"IF(D108=0,\"\",COUNTIF($D$2:D108,\">0\"))","v":107},"LOCKLM149"]
["BEAMTAU","BEAMTAU - Hardwire safety beam set",115,1,{"$f":"IF(D109=0,\"\",COUNTIF($D$2:D109,\">0\"))","v":108},"BEAMTAU"]
["BEAMBATTRIB","BEAMBATTRIB - Hardwire transmitter and battery receiver",333,1,{"$f":"IF(D110=0,\"\",COUNTIF($D$2:D110,\">0\"))","v":109},"BEAMBATTRIB"]
["BATT3.6VAA","BATT3.6VAA - 3.6volt lithium AA battery",18,1,{"$f":"IF(D111=0,\"\",COUNTIF($D$2:D111,\">0\"))","v":110},"BATT3.6VAA"]
["BEAMLM101","BEAMLM101 - Hardwire transmitter and battery receiver",94,1,{"$f":"IF(D112=0,\"\",COUNTIF($D$2:D112,\">0\"))","v":111},"BEAMLM101"]
["BEAMLM104B","BEAMLM104B - reflective safety beam with hood",129,1,{"$f":"IF(D113=0,\"\",COUNTIF($D$2:D113,\">0\"))","v":112},"BEAMLM104B"]
["ELSLOCK","ELSLOCK - Cisa electric gate lock",274,1,{"$f":"IF(D114=0,\"\",COUNTIF($D$2:D114,\">0\"))","v":113},"ELSLOCK"]
["BATT1.5VAAA","BATT1.5VAAA - 1.5volt AAA battery",2,1,{"$f":"IF(D115=0,\"\",COUNTIF($D$2:D115,\">0\"))","v":114},"BATT1.5VAAA"]
["LOOPDETECTOR","LOOPDETECTOR - Single channel loop detector ",312,1,{"$f":"IF(D116=0,\"\",COUNTIF($D$2:D116,\">0\"))","v":115},"LOOPDETECTOR"]
["FLASHER240","FLASHER240 - 240Volt outdoor flashing light",94,1,{"$f":"IF(D117=0,\"\",COUNTIF($D$2:D117,\">0\"))","v":116},"FLASHER240"]
["FLASHER1224","FLASHER1224- 12-24 Volt outdoor flashing light",73,1,{"$f":"IF(D118=0,\"\",COUNTIF($D$2:D118,\">0\"))","v":117},"FLASHER1224"]
["EXITWAND","EXITWAND - Vehicle motion detector - side bury.",396,1,{"$f":"IF(D119=0,\"\",COUNTIF($D$2:D119,\">0\"))","v":118},"EXITWAND"]
["BATT1.5VAA","BATT1.5VAA - AA Ultra alkaline batteries",2,1,{"$f":"IF(D120=0,\"\",COUNTIF($D$2:D120,\">0\"))","v":119},"BATT1.5VAA"]
["ELOOPEXITKIT","ELOOPEXITKIT - Standard ELOOP and transceiver. Exit mode.",694,1,{"$f":"IF(D121=0,\"\",COUNTIF($D$2:D121,\">0\"))","v":120},"ELOOPEXITKIT"]
["ELOOPEXIT","ELOOPEXIT - Standard ELOOP in exit mode",576,1,{"$f":"IF(D122=0,\"\",COUNTIF($D$2:D122,\">0\"))","v":121},"ELOOPEXIT"]
["ELOOPPRESKIT","ELOOPPRESKIT - Standard ELOOP and transceiver. Presence mode.",783,1,{"$f":"IF(D123=0,\"\",COUNTIF($D$2:D123,\">0\"))","v":122},"ELOOPPRESKIT"]
["ELOOPPRES","ELOOPPRES - Standard ELOOP in presence mode.",635,1,{"$f":"IF(D124=0,\"\",COUNTIF($D$2:D124,\">0\"))","v":123},"ELOOPPRES"]
["ETRANS50","ETRANS50 - ELOOP transceiver 50.",148,1,{"$f":"IF(D125=0,\"\",COUNTIF($D$2:D125,\">0\"))","v":124},"ETRANS50"]
["EDIAGNOSTIC","EDIAGNOSTIC - ELOOP diagnostic tool",517,1,{"$f":"IF(D126=0,\"\",COUNTIF($D$2:D126,\">0\"))","v":125},"EDIAGNOSTIC"]
["ELOOPEXITKIT-IG","ELOOPEXITKIT-IG - In gound ELOOP and transceiver. Exit mode.",724,1,{"$f":"IF(D127=0,\"\",COUNTIF($D$2:D127,\">0\"))","v":126},"ELOOPEXITKIT-IG"]
["ELOOPEXIT-IG","ELOOPEXIT-IG - In gound ELOOP in exit mode",576,1,{"$f":"IF(D128=0,\"\",COUNTIF($D$2:D128,\">0\"))","v":127},"ELOOPEXIT-IG"]
["ELOOPPRESKIT-IG","ELOOPPRESKIT-IG - In gound ELOOP and transceiver. Presence",783,1,{"$f":"IF(D129=0,\"\",COUNTIF($D$2:D129,\">0\"))","v":128},"ELOOPPRESKIT-IG"]
["ELOOPPRES-IG","ELOOPPRES-IG - In gound ELOOP in presence mode.",635,1,{"$f":"IF(D130=0,\"\",COUNTIF($D$2:D130,\">0\"))","v":129},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D129),E:E,0)),\"\")","v":"ELOOPPRES-IG"}]
["LION","LION - Pedestrian gate closer (1.1 metre - 75kg)",842,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A131),0)","v":1},{"$f":"IF(D131=0,\"\",COUNTIF($D$2:D131,\">0\"))","v":130},"LION"]
["SAMSON","SAMSON - Pedestrian gate closer (2.0 metre - 150kg)",994,1,{"$f":"IF(D132=0,\"\",COUNTIF($D$2:D132,\">0\"))","v":131},"SAMSON"]
["VERTICLOSE","VERTICLOSE - Pedestrian gate closer (1.5 metre - 150kg)",1131,1,{"$f":"IF(D133=0,\"\",COUNTIF($D$2:D133,\">0\"))","v":132},"VERTICLOSE"]
["DVKHD","DVKHD - Gate wiring loop cable protection.",67,1,{"$f":"IF(D134=0,\"\",COUNTIF($D$2:D134,\">0\"))","v":133},"DVKHD"]
["GATESWITCH","GATESWITCH - Position detection kit for gates",102,1,{"$f":"IF(D135=0,\"\",COUNTIF($D$2:D135,\">0\"))","v":134},"GATESWITCH"]
["ELECTRADROP","ELECTRADROP - Electric drop bolt lock.",1443,1,{"$f":"IF(D136=0,\"\",COUNTIF($D$2:D136,\">0\"))","v":135},"ELECTRADROP"]
["OGS","OGS - Drop bolt sleeve with stop.",107,1,{"$f":"IF(D137=0,\"\",COUNTIF($D$2:D137,\">0\"))","v":136},"OGS"]
["EGS","EGS - Drop bolt sleeve - no stop.",32,1,{"$f":"IF(D138=0,\"\",COUNTIF($D$2:D138,\">0\"))","v":137},"EGS"]
["SABO","SABO - Adjustable double gate stop for drop bolts.",98,1,{"$f":"IF(D139=0,\"\",COUNTIF($D$2:D139,\">0\"))","v":138},"SABO"]
["FORTYLOCKSET","FORTYLOCKSET - Complete FORTYLOCK Locinox insert set.",354,1,{"$f":"IF(D140=0,\"\",COUNTIF($D$2:D140,\">0\"))","v":139},"FORTYLOCKSET"]
["SFKM","SFKM - Keep for FORTYLOCK",51,1,{"$f":"IF(D141=0,\"\",COUNTIF($D$2:D141,\">0\"))","v":140},"SFKM"]
["3020HYBA2","3020HYBA2 - Cover pair for FORTYLOCK ",64,1,{"$f":"IF(D142=0,\"\",COUNTIF($D$2:D142,\">0\"))","v":141},"3020HYBA2"]
["3006IH","3006IH - Handle pair for FORTYLOCK",78,1,{"$f":"IF(D143=0,\"\",COUNTIF($D$2:D143,\">0\"))","v":142},"3006IH"]
["FORTYLOCK","FORTYLOCK - Insert swing gate lock",111,1,{"$f":"IF(D144=0,\"\",COUNTIF($D$2:D144,\">0\"))","v":143},"FORTYLOCK"]
["INTRALEC","INTRALEC - Electric strike for FORTYLOCK",508,1,{"$f":"IF(D145=0,\"\",COUNTIF($D$2:D145,\">0\"))","v":144},"INTRALEC"]
["HCOMPACTSET","HCOMPACTSET - Sliding gate lock set with keeper and cylinder",241,1,{"$f":"IF(D146=0,\"\",COUNTIF($D$2:D146,\">0\"))","v":145},"HCOMPACTSET"]
["HCOMPACT","HCOMPACT - Sliding gate lock (Requires cylinder and keeper)",140,1,{"$f":"IF(D147=0,\"\",COUNTIF($D$2:D147,\">0\"))","v":146},"HCOMPACT"]
["SHKC","SHKC - Keep for HCOMPACT",49,1,{"$f":"IF(D148=0,\"\",COUNTIF($D$2:D148,\">0\"))","v":147},"SHKC"]
["LOCINOXKA","LOCINOXKA - Keyed alike cylinders for LOCINOX locks",53,1,{"$f":"IF(D149=0,\"\",COUNTIF($D$2:D149,\">0\"))","v":148},"LOCINOXKA"]
["LOCINOXKD","LOCINOXKD - Keyed different cylinders for LOCINOX locks",53,1,{"$f":"IF(D150=0,\"\",COUNTIF($D$2:D150,\">0\"))","v":149},"LOCINOXKD"]
["SOLAR12V25W","SOLAR12V25W - 12 volt 25 watt solar panel with alum frame.",108,1,{"$f":"IF(D151=0,\"\",COUNTIF($D$2:D151,\">0\"))","v":150},"SOLAR12V25W"]
["ALLBROX4","ALLBROX4 - Hinged door enclosure with device plate. ",261,1,{"$f":"IF(D152=0,\"\",COUNTIF($D$2:D152,\">0\"))","v":151},"ALLBROX4"]
["BATT12V7AH","BATT12V7AH - 12 volt, 7 ah battery. ",54,1,{"$f":"IF(D153=0,\"\",COUNTIF($D$2:D153,\">0\"))","v":152},"BATT12V7AH"]
["BATT12V2.2AH","BATT12V2.2AH - 12 volt, 2.2 ah battery. ",40,1,{"$f":"IF(D154=0,\"\",COUNTIF($D$2:D154,\">0\"))","v":153},"BATT12V2.2AH"]
["BATT12V26AH","BATT12V26AH -  12 volt, 26ah battery.",213,1,{"$f":"IF(D155=0,\"\",COUNTIF($D$2:D155,\">0\"))","v":154},"BATT12V26AH"]
["FEDERAL4","FEDERAL4 - Large galvanised outdoor enclosure.",221,1,{"$f":"IF(D156=0,\"\",COUNTIF($D$2:D156,\">0\"))","v":155},"FEDERAL4"]
["FEDERAL5","FEDERAL5 - Small galvanised outdoor enclosure.",215,1,{"$f":"IF(D157=0,\"\",COUNTIF($D$2:D157,\">0\"))","v":156},"FEDERAL5"]
["BATT12V100AH","BATT12V100AH - 12 volt 100ah battery.",759,1,{"$f":"IF(D158=0,\"\",COUNTIF($D$2:D158,\">0\"))","v":157},"BATT12V100AH"]
["REGULATOR10A","REGULATOR10A - 10 amp solar regulator with LED status output.",63,1,{"$f":"IF(D159=0,\"\",COUNTIF($D$2:D159,\">0\"))","v":158},"REGULATOR10A"]
["SOLAR12V60W","SOLAR12V60W - 12 volt 60 watt solar panel with alum frame.",239,1,{"$f":"IF(D160=0,\"\",COUNTIF($D$2:D160,\">0\"))","v":159},"SOLAR12V60W"]
["E3300","E3300 - Farm gate operator with hardware. (12 volt - 5.0 metres)",617,1,{"$f":"IF(D161=0,\"\",COUNTIF($D$2:D161,\">0\"))","v":160},"E3300"]
["REGULATOR20A","REGULATOR20A - 20 amp solar regulator with LED status output.",92,1,{"$f":"IF(D162=0,\"\",COUNTIF($D$2:D162,\">0\"))","v":161},"REGULATOR20A"]
["TERMINALMINI","TERMINALMINI - 120x80x90 Allbro terminal box.",28,1,{"$f":"IF(D163=0,\"\",COUNTIF($D$2:D163,\">0\"))","v":162},"TERMINALMINI"]
["TERMINALSMALL","TERMINALSMALL - 250x255x165 Allbro terminal box.",135,1,{"$f":"IF(D164=0,\"\",COUNTIF($D$2:D164,\">0\"))","v":163},"TERMINALSMALL"]
["TERMINALLARGE","TERMINALLARGE - 250x400x165 Allbro terminal box.",165,1,{"$f":"IF(D165=0,\"\",COUNTIF($D$2:D165,\">0\"))","v":164},"TERMINALLARGE"]
["FARMSOLAR","FARMSOLAR - Solar farm gate kit. (12 volt - 5.0 metres)",1515,1,{"$f":"IF(D166=0,\"\",COUNTIF($D$2:D166,\">0\"))","v":165},"FARMSOLAR"]
["FARMSOLARULT","FARMSOLARULT - Solar farm gate kit ultimate. (12 volt - 5.0 metres)",1717,1,{"$f":"IF(D167=0,\"\",COUNTIF($D$2:D167,\">0\"))","v":166},"FARMSOLARULT"]
["BATT12V70AH","BATT12V70AH - 12 volt 70ah  battery.",596,1,{"$f":"IF(D168=0,\"\",COUNTIF($D$2:D168,\">0\"))","v":167},"BATT12V70AH"]
["BATT12V1.3AH","BATT12V1.3AH - 12 volt 1.3ah battery.",28,1,{"$f":"IF(D169=0,\"\",COUNTIF($D$2:D169,\">0\"))","v":168},"BATT12V1.3AH"]
["SOLAR12.25.26KIT","SOLAR12.25.26KIT - 25W solar panel + 26AH battery + regulator",344,1,{"$f":"IF(D170=0,\"\",COUNTIF($D$2:D170,\">0\"))","v":169},"SOLAR12.25.26KIT"]
["SOLAR12.25.70KIT","SOLAR12.25.70KIT - 25W solar panel +70AH battery + regulator",662,1,{"$f":"IF(D171=0,\"\",COUNTIF($D$2:D171,\">0\"))","v":170},"SOLAR12.25.70KIT"]
["SOLAR12.60.70KIT","SOLAR12.60.70KIT - 60W solar panel +70AH battery + regulator",771,1,{"$f":"IF(D172=0,\"\",COUNTIF($D$2:D172,\">0\"))","v":171},"SOLAR12.60.70KIT"]
["SOLAR12.60.100KIT","SOLAR12.60.100KIT - 60W solar panel +100AH battery + regulator",906,1,{"$f":"IF(D173=0,\"\",COUNTIF($D$2:D173,\">0\"))","v":172},"SOLAR12.60.100KIT"]
["SOLAR24.25.26KIT","SOLAR24.25.26KIT - 2x25W solar panel + 2x26AH battery + regulator",609,1,{"$f":"IF(D174=0,\"\",COUNTIF($D$2:D174,\">0\"))","v":173},"SOLAR24.25.26KIT"]
["SOLAR24.25.70KIT","SOLAR24.25.70KIT - 2x25W solar panel + 2x70AH battery + regulator",1245,1,{"$f":"IF(D175=0,\"\",COUNTIF($D$2:D175,\">0\"))","v":174},"SOLAR24.25.70KIT"]
["SOLAR24.60.70KIT","SOLAR24.60.70KIT - 2x60W solar panel + 2x70AH battery + regulator",1463,1,{"$f":"IF(D176=0,\"\",COUNTIF($D$2:D176,\">0\"))","v":175},"SOLAR24.60.70KIT"]
["SOLAR24.60.100KIT","SOLAR24.60.100KIT - 2x60W solar panel + 2x100AH battery + regulator",1734,1,{"$f":"IF(D177=0,\"\",COUNTIF($D$2:D177,\">0\"))","v":176},"SOLAR24.60.100KIT"]
["SPSTD","SPSTD - 75x75 solar post with base plate and swivel head",280,1,{"$f":"IF(D178=0,\"\",COUNTIF($D$2:D178,\">0\"))","v":177},"SPSTD"]
["SPH25W","SPH25W - Solar head for 25W panel with swivel plate",130,1,{"$f":"IF(D179=0,\"\",COUNTIF($D$2:D179,\">0\"))","v":178},"SPH25W"]
["SPH60W","SPH60W - Solar head for 60W panel with swivel plate",135,1,{"$f":"IF(D180=0,\"\",COUNTIF($D$2:D180,\">0\"))","v":179},"SPH60W"]
["SPH25WD","SPH25WD - Solar head for two 25W panels with swivel plate",141,1,{"$f":"IF(D181=0,\"\",COUNTIF($D$2:D181,\">0\"))","v":180},"SPH25WD"]
["SPH60WD","SPH60WD - Solar head for two 60W panels with swivel plate",151,1,{"$f":"IF(D182=0,\"\",COUNTIF($D$2:D182,\">0\"))","v":181},"SPH60WD"]
["FREESTANDENC","FREESTANDENC - 600x400x1620 free standing lockable enclosure",2555,1,{"$f":"IF(D183=0,\"\",COUNTIF($D$2:D183,\">0\"))","v":182},"FREESTANDENC"]
["BIGHINGE","BIGHINGE - Weld on hinge with ball bearing (400 kg)",36.800000000000004,1,{"$f":"IF(D184=0,\"\",COUNTIF($D$2:D184,\">0\"))","v":183},"BIGHINGE"]
["REC50OPEN","REC50OPEN - Sliding gate receiver for 50mm thick gates",20.400000000000002,1,{"$f":"IF(D185=0,\"\",COUNTIF($D$2:D185,\">0\"))","v":184},"REC50OPEN"]
["ADJHINGE","ADJHINGE - Adjustable width hinge (150 kg)",19.600000000000001,1,{"$f":"IF(D186=0,\"\",COUNTIF($D$2:D186,\">0\"))","v":185},"ADJHINGE"]
["ATHINGE","ATHINGE - Adjustable self closing nylon hinge",41.7,1,{"$f":"IF(D187=0,\"\",COUNTIF($D$2:D187,\">0\"))","v":186},"ATHINGE"]
["TOPBEAR50MM","TOPBEAR50MM - Top adjust bearing hinge with fixing plate",78.900000000000006,1,{"$f":"IF(D188=0,\"\",COUNTIF($D$2:D188,\">0\"))","v":187},"TOPBEAR50MM"]
["BOTBEAR50MM","BOTBEAR50MM - Bott adjust bearing hinge with fixing plate",72,1,{"$f":"IF(D189=0,\"\",COUNTIF($D$2:D189,\">0\"))","v":188},"BOTBEAR50MM"]
["180HINGE","180HINGE  - Adjustable hinge swing capacity to 180 degrees.",44.7,1,{"$f":"IF(D190=0,\"\",COUNTIF($D$2:D190,\">0\"))","v":189},"180HINGE"]
["TRACKBOLT3M","TRACKBOLT3M - Galvanised steel bolt down track - 3 metre",51,1,{"$f":"IF(D191=0,\"\",COUNTIF($D$2:D191,\">0\"))","v":190},"TRACKBOLT3M"]
["TRACKCONC3M","TRACKCONC3M - Galvanised concrete in track - 3 metre length",135.9,1,{"$f":"IF(D192=0,\"\",COUNTIF($D$2:D192,\">0\"))","v":191},"TRACKCONC3M"]
["WHEELRND90CH","WHEELRND90CH - Wheel in housing 90mm for half round track",25.200000000000003,1,{"$f":"IF(D193=0,\"\",COUNTIF($D$2:D193,\">0\"))","v":192},"WHEELRND90CH"]
["WHEELV90IT","WHEELV90IT  - 90mm V groove wheel in housing ",42.400000000000006,1,{"$f":"IF(D194=0,\"\",COUNTIF($D$2:D194,\">0\"))","v":193},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D193),E:E,0)),\"\")","v":"WHEELV90IT"}]
["WHEELRND120IT","WHEELRND120IT  - 120mm round track wheel in housing",81.7,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A195),0)","v":1},{"$f":"IF(D195=0,\"\",COUNTIF($D$2:D195,\">0\"))","v":194},"WHEELRND120IT"]
["WHEELV120IT","WHEELV120IT  - 120mm V groove wheel in housing",74.2,1,{"$f":"IF(D196=0,\"\",COUNTIF($D$2:D196,\">0\"))","v":195},"WHEELV120IT"]
["RECGATE50","RECGATE50 - Sliding gate receiver for 50mm thick gates",22,1,{"$f":"IF(D197=0,\"\",COUNTIF($D$2:D197,\">0\"))","v":196},"RECGATE50"]
["STOPBOLT","STOPBOLT  - Bolt down gate stop ",22,1,{"$f":"IF(D198=0,\"\",COUNTIF($D$2:D198,\">0\"))","v":197},"STOPBOLT"]
["STOPWELD","STOPWELD  - Weld on gate stop",7.1000000000000005,1,{"$f":"IF(D199=0,\"\",COUNTIF($D$2:D199,\">0\"))","v":198},"STOPWELD"]
["STOPCENTRE","STOPCENTRE - Double gate centre stop",51.300000000000004,1,{"$f":"IF(D200=0,\"\",COUNTIF($D$2:D200,\">0\"))","v":199},"STOPCENTRE"]
["STOPCENTREPCK","STOPCENTREPCK - Double gate centre stop packer",23.5,1,{"$f":"IF(D201=0,\"\",COUNTIF($D$2:D201,\">0\"))","v":200},"STOPCENTREPCK"]
["ROLLER60","ROLLER60 - 40mm x 60mm nylon roller with bolt",8.7000000000000011,1,{"$f":"IF(D202=0,\"\",COUNTIF($D$2:D202,\">0\"))","v":201},"ROLLER60"]
["ROLLER250","ROLLER250 - 40mm x 250mm nylon roller with bolt",45.7,1,{"$f":"IF(D203=0,\"\",COUNTIF($D$2:D203,\">0\"))","v":202},"ROLLER250"]
["300ROLLINBR","300ROLLINBR - 40mm x 300mm roller in bracket",110.4,1,{"$f":"IF(D204=0,\"\",COUNTIF($D$2:D204,\">0\"))","v":203},"300ROLLINBR"]
["2ROLL4060","2ROLL4060 - Roller bracket with two rollers 40x60",29.8,1,{"$f":"IF(D205=0,\"\",COUNTIF($D$2:D205,\">0\"))","v":204},"2ROLL4060"]
["4ROLLBRACK","4ROLLBRACK - Galv bracket with four rollers",53.300000000000004,1,{"$f":"IF(D206=0,\"\",COUNTIF($D$2:D206,\">0\"))","v":205},"4ROLLBRACK"]
["1ROLLERBRACKET","1ROLLERBRACKET  - Single Roller in adjustable bracket",45.6,1,{"$f":"IF(D207=0,\"\",COUNTIF($D$2:D207,\">0\"))","v":206},"1ROLLERBRACKET"]
["ROLLER100","ROLLER100 - 40mm x 100mm nylon roller with bolt",21.6,1,{"$f":"IF(D208=0,\"\",COUNTIF($D$2:D208,\">0\"))","v":207},"ROLLER100"]
["ROLLER150","ROLLER150 - 40mm x 150mm nylon roller with bolt",29.8,1,{"$f":"IF(D209=0,\"\",COUNTIF($D$2:D209,\">0\"))","v":208},"ROLLER150"]
["MEDHINGE","MEDHINGE - Weld on hinge with ball bearing (300 kg)",20.8,1,{"$f":"IF(D210=0,\"\",COUNTIF($D$2:D210,\">0\"))","v":209},"MEDHINGE"]
["STALHINGE","STALHINGE - Steel post to aluminium gate bearing hinge",65,1,{"$f":"IF(D211=0,\"\",COUNTIF($D$2:D211,\">0\"))","v":210},"STALHINGE"]
["INCLINEBLOCK","INCLINEBLOCK - Sliding Gate Nylon Block",29.400000000000002,1,{"$f":"IF(D212=0,\"\",COUNTIF($D$2:D212,\">0\"))","v":211},"INCLINEBLOCK"]
["ROLLER30","ROLLER30  - Nylon gate roller - 30mm x 40mm",4.7,1,{"$f":"IF(D213=0,\"\",COUNTIF($D$2:D213,\">0\"))","v":212},"ROLLER30"]
["BEARHINGEST","BEARHINGEST - Bearing hinge for 50x50x1.6 steel tube",84.600000000000009,1,{"$f":"IF(D214=0,\"\",COUNTIF($D$2:D214,\">0\"))","v":213},"BEARHINGEST"]
["BEARHINGEAL","BEARHINGEAL - Bearing hinge  for 50x50x2.5-3.0 alum tube",90.100000000000009,1,{"$f":"IF(D215=0,\"\",COUNTIF($D$2:D215,\">0\"))","v":214},"BEARHINGEAL"]
["TRACKBOLT1M","TRACKBOLT1M - Galvanised steel bolt down track - 1 metre",8.5,1,{"$f":"IF(D216=0,\"\",COUNTIF($D$2:D216,\">0\"))","v":215},"TRACKBOLT1M"]
["TOPBEAR70MM","TOPBEAR70MM - Top adjust bearing hinge with fixing plate",103.30000000000001,1,{"$f":"IF(D217=0,\"\",COUNTIF($D$2:D217,\">0\"))","v":216},"TOPBEAR70MM"]
["BOTBEAR70MM","BOTBEAR70MM - Bott adjust bearing hinge with fixing plate",96,1,{"$f":"IF(D218=0,\"\",COUNTIF($D$2:D218,\">0\"))","v":217},"BOTBEAR70MM"]
["SPRINGSTOP","SPRINGSTOP - Bolt down stop with spring",112,1,{"$f":"IF(D219=0,\"\",COUNTIF($D$2:D219,\">0\"))","v":218},"SPRINGSTOP"]
["CANRECLGT","CANRECLGT - Sliding gate receiver to suit 75mm thick gates",25.5,1,{"$f":"IF(D220=0,\"\",COUNTIF($D$2:D220,\">0\"))","v":219},"CANRECLGT"]
["WHEELRND120CH","WHEELRND120CH  - Wheel 120mm for round track in housing",48.800000000000004,1,{"$f":"IF(D221=0,\"\",COUNTIF($D$2:D221,\">0\"))","v":220},"WHEELRND120CH"]
["RECBRACKET","RECBRACKET - Adjustable bracket for mounting gate receivers",31.400000000000002,1,{"$f":"IF(D222=0,\"\",COUNTIF($D$2:D222,\">0\"))","v":221},"RECBRACKET"]
["RISINGHINGESLH","RISINGHINGESLH  - Top and bottom pair of rising hinges - Left",485.5,1,{"$f":"IF(D223=0,\"\",COUNTIF($D$2:D223,\">0\"))","v":222},"RISINGHINGESLH"]
["RISINGHINGESRH","RISINGHINGESRH  - Top and bottom pair of rising hinges - Right",485.5,1,{"$f":"IF(D224=0,\"\",COUNTIF($D$2:D224,\">0\"))","v":223},"RISINGHINGESRH"]
["STSTHINGE","STSTHINGE - Steel post to steel gate bearing hinge",48.1,1,{"$f":"IF(D225=0,\"\",COUNTIF($D$2:D225,\">0\"))","v":224},"STSTHINGE"]
["PAIRBEAR70MM","PAIRBEAR70MM - Top and bottom bearing hinge with fix plate",90.800000000000011,1,{"$f":"IF(D226=0,\"\",COUNTIF($D$2:D226,\">0\"))","v":225},"PAIRBEAR70MM"]
["BIFOLDHINGE","BIFOLDHINGE - BIFOLD centre pivot hinge - each",155,1,{"$f":"IF(D227=0,\"\",COUNTIF($D$2:D227,\">0\"))","v":226},"BIFOLDHINGE"]
["WHEELRND90IT","WHEELRND90IT - Wheel 90mm for round track in housing",45.800000000000004,1,{"$f":"IF(D228=0,\"\",COUNTIF($D$2:D228,\">0\"))","v":227},"WHEELRND90IT"]
["2ROLL40100","2ROLL40100 - Roller bracket with two rollers 40x100",58,1,{"$f":"IF(D229=0,\"\",COUNTIF($D$2:D229,\">0\"))","v":228},"2ROLL40100"]
["RUBBERSTOP","RUBBERSTOP - Double gate centre stop",28.900000000000002,1,{"$f":"IF(D230=0,\"\",COUNTIF($D$2:D230,\">0\"))","v":229},"RUBBERSTOP"]
["RECADJUSTABLE","RECADJUSTABLE - Adjustable receiver with bracket and rollers",116.30000000000001,1,{"$f":"IF(D231=0,\"\",COUNTIF($D$2:D231,\">0\"))","v":230},"RECADJUSTABLE"]
["BIFOLDLARGE","BIFOLDLARGE - Bifold swing gates to 5000mm wide.",677,1,{"$f":"IF(D232=0,\"\",COUNTIF($D$2:D232,\">0\"))","v":231},"BIFOLDLARGE"]
["INCLINECHAN","INCLINECHAN - Sliding nylon block aluminium channel 300mm",11.100000000000001,1,{"$f":"IF(D233=0,\"\",COUNTIF($D$2:D233,\">0\"))","v":232},"INCLINECHAN"]
["BIFOLDSMALL","BIFOLDSMALL - Bifold swing gates to 2000mm wide.",452,1,{"$f":"IF(D234=0,\"\",COUNTIF($D$2:D234,\">0\"))","v":233},"BIFOLDSMALL"]
["BIFOLDTUBE","BIFOLDTUBE - 34OD-25NB Connector - BIFOLD Small & Heavy - 6500.",255,1,{"$f":"IF(D235=0,\"\",COUNTIF($D$2:D235,\">0\"))","v":234},"BIFOLDTUBE"]
["WHEELDOUBLE","WHEELDOUBLE - Industrial double wheel to 900kg",401.1,1,{"$f":"IF(D236=0,\"\",COUNTIF($D$2:D236,\">0\"))","v":235},"WHEELDOUBLE"]
["MULTITELESCOPIC","MULTITELESCOPIC - Telescopic kit for gates to 4 metres",2324.2000000000003,1,{"$f":"IF(D237=0,\"\",COUNTIF($D$2:D237,\">0\"))","v":236},"MULTITELESCOPIC"]
["TELEKITHVY","TELEKITHVY - Telescopic kit for openings to 8 metres",1144.9000000000001,1,{"$f":"IF(D238=0,\"\",COUNTIF($D$2:D238,\">0\"))","v":237},"TELEKITHVY"]
["TELEKITLGT","TELEKITLGT - Telecopic kit for openings to 10 metres",269,1,{"$f":"IF(D239=0,\"\",COUNTIF($D$2:D239,\">0\"))","v":238},"TELEKITLGT"]
["CABLEWHEEL","CABLEWHEEL - Cable wheel for TELE kits",19.600000000000001,1,{"$f":"IF(D240=0,\"\",COUNTIF($D$2:D240,\">0\"))","v":239},"CABLEWHEEL"]
["RADIUSKITLEAD050","RADIUSKITLEAD050 - Radius gate lead kit with 0.5 radius",1518,1,{"$f":"IF(D241=0,\"\",COUNTIF($D$2:D241,\">0\"))","v":240},"RADIUSKITLEAD050"]
["RADIUSKITLEAD100","RADIUSKITLEAD100 - Radius gate lead kit with 1.0 radius",1689.4,1,{"$f":"IF(D242=0,\"\",COUNTIF($D$2:D242,\">0\"))","v":241},"RADIUSKITLEAD100"]
["RADIUSKITFOLLOW","RADIUSKITFOLLOW - Radius gate following gate kit",662.40000000000009,1,{"$f":"IF(D243=0,\"\",COUNTIF($D$2:D243,\">0\"))","v":242},"RADIUSKITFOLLOW"]
["RADIUS16TRACK","RADIUS16TRACK - Bolt down 3m track for radius kit",123.2,1,{"$f":"IF(D244=0,\"\",COUNTIF($D$2:D244,\">0\"))","v":243},"RADIUS16TRACK"]
["WHEELRADIUS","WHEELRADIUS - Radius gate rotating wheel ",36.4,1,{"$f":"IF(D245=0,\"\",COUNTIF($D$2:D245,\">0\"))","v":244},"WHEELRADIUS"]
["INSERTHINGETOP","INSERTHINGETOP - Italian insert hinge 50x50 Top",124.5,1,{"$f":"IF(D246=0,\"\",COUNTIF($D$2:D246,\">0\"))","v":245},"INSERTHINGETOP"]
["INSERTHINGEBOT","INSERTHINGEBOT - Italian insert hinge 50x50 Bottom",143.20000000000002,1,{"$f":"IF(D247=0,\"\",COUNTIF($D$2:D247,\">0\"))","v":246},"INSERTHINGEBOT"]
["CANTROLLGT","CANTROLLGT - Cantilever sliding gate trolley - Light",166.9,1,{"$f":"IF(D248=0,\"\",COUNTIF($D$2:D248,\">0\"))","v":247},"CANTROLLGT"]
["CANTRACLGT","CANTRACLGT - Cantilever sliding gate track - Light ",248.10000000000002,1,{"$f":"IF(D249=0,\"\",COUNTIF($D$2:D249,\">0\"))","v":248},"CANTRACLGT"]
["CANENDLGT","CANENDLGT - Cantilever sliding gate end roller - Light ",40,1,{"$f":"IF(D250=0,\"\",COUNTIF($D$2:D250,\">0\"))","v":249},"CANENDLGT"]
["CANTROLMED","CANTROLMED - Cantilever sliding gate trolley - Medium",330.40000000000003,1,{"$f":"IF(D251=0,\"\",COUNTIF($D$2:D251,\">0\"))","v":250},"CANTROLMED"]
["CANTRACMED","CANTRACMED - Cantilever sliding gate track - Medium",381.20000000000005,1,{"$f":"IF(D252=0,\"\",COUNTIF($D$2:D252,\">0\"))","v":251},"CANTRACMED"]
["CANENDMED","CANENDMED - Cantilever sliding gate end roller - Medium",77.2,1,{"$f":"IF(D253=0,\"\",COUNTIF($D$2:D253,\">0\"))","v":252},"CANENDMED"]
["CANRECMED","CANRECMED - Cantilever sliding gate receiver - Medium ",49.1,1,{"$f":"IF(D254=0,\"\",COUNTIF($D$2:D254,\">0\"))","v":253},"CANRECMED"]
["CANTROLXLGE","CANTROLXLGE - Cantilever sliding gate trolley - Extra Large",1076,1,{"$f":"IF(D255=0,\"\",COUNTIF($D$2:D255,\">0\"))","v":254},"CANTROLXLGE"]
["CANTRACXLGE","CANTRACXLGE - Cantilever sliding gate track - Extra Large",1789.3000000000002,1,{"$f":"IF(D256=0,\"\",COUNTIF($D$2:D256,\">0\"))","v":255},"CANTRACXLGE"]
["CANENDXLGE","CANENDXLGE - Cantilever sliding gate end roller - Extra Large",176.20000000000002,1,{"$f":"IF(D257=0,\"\",COUNTIF($D$2:D257,\">0\"))","v":256},"CANENDXLGE"]
["CANRECXLGE","CANRECXLGE - Cantilever sliding gate receiver - Extra Large",91.2,1,{"$f":"IF(D258=0,\"\",COUNTIF($D$2:D258,\">0\"))","v":257},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D257),E:E,0)),\"\")","v":"CANRECXLGE"}]
["CANVTROLLEY","CANVTROLLEY - Cantilever trolley for V rail system",180.5,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A259),0)","v":1},{"$f":"IF(D259=0,\"\",COUNTIF($D$2:D259,\">0\"))","v":258},"CANVTROLLEY"]
["CANVTRACK","CANVTRACK - Cantilever V track - 3 metre",99.5,1,{"$f":"IF(D260=0,\"\",COUNTIF($D$2:D260,\">0\"))","v":259},"CANVTRACK"]
["GUARDIAN12","GUARDIAN12 - Cantilever rail kit for openings to 12 metres",2918.7000000000003,1,{"$f":"IF(D261=0,\"\",COUNTIF($D$2:D261,\">0\"))","v":260},"GUARDIAN12"]
["CANTROLLGE","CANTROLLGE - Cantilever gate trolley - Large",471.8,1,{"$f":"IF(D262=0,\"\",COUNTIF($D$2:D262,\">0\"))","v":261},"CANTROLLGE"]
["CANTRACLGE","CANTRACLGE - Cantilever gate track - Large",639,1,{"$f":"IF(D263=0,\"\",COUNTIF($D$2:D263,\">0\"))","v":262},"CANTRACLGE"]
["CANENDLGE","CANENDLGE - Cantilever gate end roller - Large",87.100000000000009,1,{"$f":"IF(D264=0,\"\",COUNTIF($D$2:D264,\">0\"))","v":263},"CANENDLGE"]
["CANRECLGE","CANRECLGE - Cantilever gate receiver - Large",57.300000000000004,1,{"$f":"IF(D265=0,\"\",COUNTIF($D$2:D265,\">0\"))","v":264},"CANRECLGE"]
["CFFLAT12","CFFLAT12 - Cantilever foundation un assembled - mild steel",1654,1,{"$f":"IF(D266=0,\"\",COUNTIF($D$2:D266,\">0\"))","v":265},"CFFLAT12"]
["CFASS12","CFASS12 - Cantilever foundation assembled - mild steel",1832,1,{"$f":"IF(D267=0,\"\",COUNTIF($D$2:D267,\">0\"))","v":266},"CFASS12"]
["CFHDG12","CFHDG12 - Cantilever foundation assembled and galvanised",2924,1,{"$f":"IF(D268=0,\"\",COUNTIF($D$2:D268,\">0\"))","v":267},"CFHDG12"]
["CFFLAT15","CFFLAT15 - Cantilever foundation un assembled - mild steel",2150,1,{"$f":"IF(D269=0,\"\",COUNTIF($D$2:D269,\">0\"))","v":268},"CFFLAT15"]
["CFASS15","CFASS15 - Cantilever foundation assembled - mild steel",2352,1,{"$f":"IF(D270=0,\"\",COUNTIF($D$2:D270,\">0\"))","v":269},"CFASS15"]
["CFHDG15","CFHDG15 - Cantilever foundation assembled and galvanised",4058,1,{"$f":"IF(D271=0,\"\",COUNTIF($D$2:D271,\">0\"))","v":270},"CFHDG15"]
["CAP100100","CAP100100 - 100mm x 100mm post cap",3.3000000000000003,1,{"$f":"IF(D272=0,\"\",COUNTIF($D$2:D272,\">0\"))","v":271},"CAP100100"]
["CAP5050","CAP5050 - 50mm x 50mm post cap",0.30000000000000004,1,{"$f":"IF(D273=0,\"\",COUNTIF($D$2:D273,\">0\"))","v":272},"CAP5050"]
["POSTPLATE75","POSTPLATE75 - Galvanised post plate to suit 75x75 post",37.300000000000004,1,{"$f":"IF(D274=0,\"\",COUNTIF($D$2:D274,\">0\"))","v":273},"POSTPLATE75"]
["POSTPLATE100","POSTPLATE100 - Galvanised post plate to suit 100x100 post",44.5,1,{"$f":"IF(D275=0,\"\",COUNTIF($D$2:D275,\">0\"))","v":274},"POSTPLATE100"]
["POSTPLATE150","POSTPLATE150 - Galvanised post plate to suit 150x150 post",93,1,{"$f":"IF(D276=0,\"\",COUNTIF($D$2:D276,\">0\"))","v":275},"POSTPLATE150"]
["CAP7575","CAP7575 - 75mm x 75mm post cap",1.6,1,{"$f":"IF(D277=0,\"\",COUNTIF($D$2:D277,\">0\"))","v":276},"CAP7575"]
["JBOLT","JBOLT - J bolt with two nuts for post plates and bases.",19.400000000000002,1,{"$f":"IF(D278=0,\"\",COUNTIF($D$2:D278,\">0\"))","v":277},"JBOLT"]
["CAP6565","CAP6565 - 65mm x 65mm post cap",1.8,1,{"$f":"IF(D279=0,\"\",COUNTIF($D$2:D279,\">0\"))","v":278},"CAP6565"]
["CAP150100","CAP150100 - 150mm x 100mm post cap",6.6000000000000005,1,{"$f":"IF(D280=0,\"\",COUNTIF($D$2:D280,\">0\"))","v":279},"CAP150100"]
["HDATHINGE","HDATHINGE - Heavy duty adjust tension hinge - Pair",143.5,1,{"$f":"IF(D281=0,\"\",COUNTIF($D$2:D281,\">0\"))","v":280},"HDATHINGE"]
["FTHINGE","FTHINGE - Fixed tension self closing hinges - Pair",24.5,1,{"$f":"IF(D282=0,\"\",COUNTIF($D$2:D282,\">0\"))","v":281},"FTHINGE"]
["DLATCH","DLATCH - Galvanised steel swing gate \"D\" latch",16,1,{"$f":"IF(D283=0,\"\",COUNTIF($D$2:D283,\">0\"))","v":282},"DLATCH"]
["DROPBOLT","DROPBOLT - Galvanised steel drop bolt",19.8,1,{"$f":"IF(D284=0,\"\",COUNTIF($D$2:D284,\">0\"))","v":283},"DROPBOLT"]
["LOCKDLATCH","LOCKDLATCH - Double sided lockable D Latch",109.9,1,{"$f":"IF(D285=0,\"\",COUNTIF($D$2:D285,\">0\"))","v":284},"LOCKDLATCH"]
["CAP12575","CAP12575 - 125mm x 75mm post cap",24.3,1,{"$f":"IF(D286=0,\"\",COUNTIF($D$2:D286,\">0\"))","v":285},"CAP12575"]
["ADJUSTSHIM","ADJUSTSHIM - Adjustable shim  15-25mm.",12.700000000000001,1,{"$f":"IF(D287=0,\"\",COUNTIF($D$2:D287,\">0\"))","v":286},"ADJUSTSHIM"]
["CAP10050","CAP10050 - 100mm x 50mm post cap",1.7000000000000002,1,{"$f":"IF(D288=0,\"\",COUNTIF($D$2:D288,\">0\"))","v":287},"CAP10050"]
["POSTPLATE50","POSTPLATE50 - Galvanised post plate to suit 50X50 post",22,1,{"$f":"IF(D289=0,\"\",COUNTIF($D$2:D289,\">0\"))","v":288},"POSTPLATE50"]
["CAPALLY76X25","CAPALLY76X25 - Aluminium knock in cap to suit 76.2x25.4x2.4 SE",7.8000000000000007,1,{"$f":"IF(D290=0,\"\",COUNTIF($D$2:D290,\">0\"))","v":289},"CAPALLY76X25"]
["CAPALLY50X50","CAPALLY50X50 - Aluminium knock in cap to suit 50x50x2.5 SE",7.4,1,{"$f":"IF(D291=0,\"\",COUNTIF($D$2:D291,\">0\"))","v":290},"CAPALLY50X50"]
["CAPALLY100X50","CAPALLY100X50 - Aluminium knock in cap to suit 100x50x3 SE",11.600000000000001,1,{"$f":"IF(D292=0,\"\",COUNTIF($D$2:D292,\">0\"))","v":291},"CAPALLY100X50"]
["CAPALLY50X25","CAPALLY50X25 - Aluminium knock in cap to suit 50x25x2.5 SE",6,1,{"$f":"IF(D293=0,\"\",COUNTIF($D$2:D293,\">0\"))","v":292},"CAPALLY50X25"]
["AESPARTS ","AESPARTS ",0,1,{"$f":"IF(D294=0,\"\",COUNTIF($D$2:D294,\">0\"))","v":293},"AESPARTS "]
["AES-STDCP+KPAD","AES-STDCP+KPAD - Standard call point with keypad.",983,1,{"$f":"IF(D295=0,\"\",COUNTIF($D$2:D295,\">0\"))","v":294},"AES-STDCP+KPAD"]
["AES-STDCP","AES-STDCP - Standard call point ",473,1,{"$f":"IF(D296=0,\"\",COUNTIF($D$2:D296,\">0\"))","v":295},"AES-STDCP"]
["MULTIPLEX","MULTIPLEX - For use with dual call points",473,1,{"$f":"IF(D297=0,\"\",COUNTIF($D$2:D297,\">0\"))","v":296},"MULTIPLEX"]
["AES-PEDCP+KPAD","AES-PEDCP+KPAD - Pedestal call point with keypad.",1161,1,{"$f":"IF(D298=0,\"\",COUNTIF($D$2:D298,\">0\"))","v":297},"AES-PEDCP+KPAD"]
["AES-PEDCP","AES-PEDCP - Pedestal call point ",643,1,{"$f":"IF(D299=0,\"\",COUNTIF($D$2:D299,\">0\"))","v":298},"AES-PEDCP"]
["603PED","603PED - Wireless intercom with pedestal gate station and handset",1504,1,{"$f":"IF(D300=0,\"\",COUNTIF($D$2:D300,\">0\"))","v":299},"603PED"]
["603STD","603STD - Wireless intercom with gate station and handset",1279,1,{"$f":"IF(D301=0,\"\",COUNTIF($D$2:D301,\">0\"))","v":300},"603STD"]
["603STD+KPAD","603STD+KPAD - Wireless intercom with gate station and keypad",1811,1,{"$f":"IF(D302=0,\"\",COUNTIF($D$2:D302,\">0\"))","v":301},"603STD+KPAD"]
["603EH","603EH - Extra handset for 603 series wireless intercoms",263,1,{"$f":"IF(D303=0,\"\",COUNTIF($D$2:D303,\">0\"))","v":302},"603EH"]
["GSMINT+KEYPAD","GSMINT+KEYPAD - GSM Entry phone with keypad in gate station",1874,1,{"$f":"IF(D304=0,\"\",COUNTIF($D$2:D304,\">0\"))","v":303},"GSMINT+KEYPAD"]
["MULTICOMMLITE","MULTICOMMLITE - Multi unit GSM entry phone ",2978,1,{"$f":"IF(D305=0,\"\",COUNTIF($D$2:D305,\">0\"))","v":304},"MULTICOMMLITE"]
["GSMINTPED","GSMINTPED - GSM pedestal entry phone",2190,1,{"$f":"IF(D306=0,\"\",COUNTIF($D$2:D306,\">0\"))","v":305},"GSMINTPED"]
["GSMINTPED+KPAD","GSMINTPED+KPAD - Pedestal entry phone with keypad",2635,1,{"$f":"IF(D307=0,\"\",COUNTIF($D$2:D307,\">0\"))","v":306},"GSMINTPED+KPAD"]
["MULTICLASSIC","MULTICLASSIC - Multi unit GSM entry phone ",3362,1,{"$f":"IF(D308=0,\"\",COUNTIF($D$2:D308,\">0\"))","v":307},"MULTICLASSIC"]
["603PED+KPAD","603PED+KPAD - Wireless intercom - pedestal gate station + keypad",2032,1,{"$f":"IF(D309=0,\"\",COUNTIF($D$2:D309,\">0\"))","v":308},"603PED+KPAD"]
["302STD+KPAD","302STD+KPAD - Hard wire audio kit with keypad",991,1,{"$f":"IF(D310=0,\"\",COUNTIF($D$2:D310,\">0\"))","v":309},"302STD+KPAD"]
["302EHSLIM","302EHSLIM - Extra 302 hard wire handset - slim model",211,1,{"$f":"IF(D311=0,\"\",COUNTIF($D$2:D311,\">0\"))","v":310},"302EHSLIM"]
["302STD","302STD - Hard wire audio kit",643,1,{"$f":"IF(D312=0,\"\",COUNTIF($D$2:D312,\">0\"))","v":311},"302STD"]
["302EH","302EH - Extra 302 hard wire handset",211,1,{"$f":"IF(D313=0,\"\",COUNTIF($D$2:D313,\">0\"))","v":312},"302EH"]
["302PED+KPAD","302PED+KPAD - Hard wire audio kit - pedestal with keypad ",1231,1,{"$f":"IF(D314=0,\"\",COUNTIF($D$2:D314,\">0\"))","v":313},"302PED+KPAD"]
["302PED","302PED - Hard wire audio kit - pedestal",750,1,{"$f":"IF(D315=0,\"\",COUNTIF($D$2:D315,\">0\"))","v":314},"302PED"]
["AESPRIMEKEYPAD","AESPRIMEKEYPAD - Replacement keypad for AES intercoms",492,1,{"$f":"IF(D316=0,\"\",COUNTIF($D$2:D316,\">0\"))","v":315},"AESPRIMEKEYPAD"]
["AESASSMKEYPAD","AESASSMKEYPAD - Replacement keypad for older AES intercoms",492,1,{"$f":"IF(D317=0,\"\",COUNTIF($D$2:D317,\">0\"))","v":316},"AESASSMKEYPAD"]
["IGATEPRIME","IGATEPRIME - GSM Remote with access control",1076,1,{"$f":"IF(D318=0,\"\",COUNTIF($D$2:D318,\">0\"))","v":317},"IGATEPRIME"]
["AESGSMMODULE","AESGSMMODULE - Replacement GSM Module",899,1,{"$f":"IF(D319=0,\"\",COUNTIF($D$2:D319,\">0\"))","v":318},"AESGSMMODULE"]
["GSMINTERCOM","GSMINTERCOM - GSM entry phone system.",546,1,{"$f":"IF(D320=0,\"\",COUNTIF($D$2:D320,\">0\"))","v":319},"GSMINTERCOM"]
["IGATEPLUS","IGATEPLUS - GSM Remote with 1200 users",754,1,{"$f":"IF(D321=0,\"\",COUNTIF($D$2:D321,\">0\"))","v":320},"IGATEPLUS"]
["PRAETORIAN4G","PRAETORIAN4G - 4G video intercom kit",3654,1,{"$f":"IF(D322=0,\"\",COUNTIF($D$2:D322,\">0\"))","v":321},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D321),E:E,0)),\"\")","v":"PRAETORIAN4G"}]
["PRAETORIAN4GK","PRAETORIAN4GK - 4G video intercom kit with keypad",4168,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A323),0)","v":1},{"$f":"IF(D323=0,\"\",COUNTIF($D$2:D323,\">0\"))","v":322},"PRAETORIAN4GK"]
["PRAETORIANWIFI","PRAETORIANWIFI - WIFI video intercom kit",2661,1,{"$f":"IF(D324=0,\"\",COUNTIF($D$2:D324,\">0\"))","v":323},"PRAETORIANWIFI"]
["PRAETORIANWIFIK","PRAETORIANWIFIK -WIFI video intercom kit with keypad",3170,1,{"$f":"IF(D325=0,\"\",COUNTIF($D$2:D325,\">0\"))","v":324},"PRAETORIANWIFIK"]
["KEYSWITCH","KEYSWITCH - Key operated switch",108,1,{"$f":"IF(D326=0,\"\",COUNTIF($D$2:D326,\">0\"))","v":325},"KEYSWITCH"]
["PUSHBUTTON","PUSHBUTTON - Pushbutton in outdoor weather enclosure ",55,1,{"$f":"IF(D327=0,\"\",COUNTIF($D$2:D327,\">0\"))","v":326},"PUSHBUTTON"]
["SHERLOKEYPAD","SHERLOKEYPAD - Wireless keypad for Sherlo receivers",423,1,{"$f":"IF(D328=0,\"\",COUNTIF($D$2:D328,\">0\"))","v":327},"SHERLOKEYPAD"]
["AESSAKEYPAD","AESSAKEYPAD - AES  Hardwire stand alone outdoor keypad",691,1,{"$f":"IF(D329=0,\"\",COUNTIF($D$2:D329,\">0\"))","v":328},"AESSAKEYPAD"]
["TAUKEYPAD","TAUKEYPAD - TAU  Wireless outdoor keypad",268,1,{"$f":"IF(D330=0,\"\",COUNTIF($D$2:D330,\">0\"))","v":329},"TAUKEYPAD"]
["KEYONOFF","KEYONOFF - On / Off changeover key switch",16,1,{"$f":"IF(D331=0,\"\",COUNTIF($D$2:D331,\">0\"))","v":330},"KEYONOFF"]
["KEYPADP6","KEYPADP6 - ASA wireless keypad",146,1,{"$f":"IF(D332=0,\"\",COUNTIF($D$2:D332,\">0\"))","v":331},"KEYPADP6"]
["KEYPADHWIRE","KEYPADHWIRE - Stainless steel outdoor keypad - hard wire",151,1,{"$f":"IF(D333=0,\"\",COUNTIF($D$2:D333,\">0\"))","v":332},"KEYPADHWIRE"]
["CR2032","CR2032 - Battery for KEYPADP6",3,1,{"$f":"IF(D334=0,\"\",COUNTIF($D$2:D334,\">0\"))","v":333},"CR2032"]
["KEYPADWLESS","KEYPADWLESS - Outdoor keypad and receiver",201,1,{"$f":"IF(D335=0,\"\",COUNTIF($D$2:D335,\">0\"))","v":334},"KEYPADWLESS"]
["BENINCAKEYPAD","BENINCAKEYPAD - BENINCA  Wireless outdoor keypad",415,1,{"$f":"IF(D336=0,\"\",COUNTIF($D$2:D336,\">0\"))","v":335},"BENINCAKEYPAD"]
["BOLLSTDSGL","BOLLSTDSGL - Access bollard standard single height",680,1,{"$f":"IF(D337=0,\"\",COUNTIF($D$2:D337,\">0\"))","v":336},"BOLLSTDSGL"]
["BOLLSTDDBL","BOLLSTDDBL - Access bollard standard double height",973,1,{"$f":"IF(D338=0,\"\",COUNTIF($D$2:D338,\">0\"))","v":337},"BOLLSTDDBL"]
["BOLLPEDSGL","BOLLPEDSGL - Access bollard pedestal single height",714,1,{"$f":"IF(D339=0,\"\",COUNTIF($D$2:D339,\">0\"))","v":338},"BOLLPEDSGL"]
["BOLLPEDDBL","BOLLPEDDBL - Access bollard pedestal double height",1040,1,{"$f":"IF(D340=0,\"\",COUNTIF($D$2:D340,\">0\"))","v":339},"BOLLPEDDBL"]
["SHERLOSHIELD","SHERLOSHIELD - Sherlo keypad weather shield",103,1,{"$f":"IF(D341=0,\"\",COUNTIF($D$2:D341,\">0\"))","v":340},"SHERLOSHIELD"]
["PUSHBUTTKEY","PUSHBUTTKEY - Pushbutton with key switch in weather enclosure ",62,1,{"$f":"IF(D342=0,\"\",COUNTIF($D$2:D342,\">0\"))","v":341},"PUSHBUTTKEY"]
["NET2ODOORREAD","NET2ODOORREAD - Tough outdoor proximity reader for NET2",971,1,{"$f":"IF(D343=0,\"\",COUNTIF($D$2:D343,\">0\"))","v":342},"NET2ODOORREAD"]
["NET2PROXCARD","NET2PROXCARD - Proximity card for NET2 system",30,1,{"$f":"IF(D344=0,\"\",COUNTIF($D$2:D344,\">0\"))","v":343},"NET2PROXCARD"]
["NET2PROXTAG","NET2PROXTAG - Proximity tag for NET2 system",30,1,{"$f":"IF(D345=0,\"\",COUNTIF($D$2:D345,\">0\"))","v":344},"NET2PROXTAG"]
["NET2LONGREAD","NET2LONGREAD - Long range proximity reader for NET system",1609,1,{"$f":"IF(D346=0,\"\",COUNTIF($D$2:D346,\">0\"))","v":345},"NET2LONGREAD"]
["NET2LONGKEYFOB","NET2LONGKEYFOB - Keyfob for use with NET2 long range reader",293,1,{"$f":"IF(D347=0,\"\",COUNTIF($D$2:D347,\">0\"))","v":346},"NET2LONGKEYFOB"]
["NET2SOFTWARE","NET2SOFTWARE - PC based software to control NET2 system",0,1,{"$f":"IF(D348=0,\"\",COUNTIF($D$2:D348,\">0\"))","v":347},"NET2SOFTWARE"]
["NET2DESKREAD","NET2DESKREAD - Card and tag programmer for PC desk",389,1,{"$f":"IF(D349=0,\"\",COUNTIF($D$2:D349,\">0\"))","v":348},"NET2DESKREAD"]
["NET2PLUS","NET2PLUS - Hardwire access control unit for single station",1539,1,{"$f":"IF(D350=0,\"\",COUNTIF($D$2:D350,\">0\"))","v":349},"NET2PLUS"]
["NET2REMOTE","NET2REMOTE - Remote control for NET2 systems",63,1,{"$f":"IF(D351=0,\"\",COUNTIF($D$2:D351,\">0\"))","v":350},"NET2REMOTE"]
["NET2EXITBUTTON","NET2EXITBUTTON - Outdoor request to exit button - waterproof",658,1,{"$f":"IF(D352=0,\"\",COUNTIF($D$2:D352,\">0\"))","v":351},"NET2EXITBUTTON"]
["NET2MARINEREAD","NET2MARINEREAD - Waterproof reader for marine enviroments",1299,1,{"$f":"IF(D353=0,\"\",COUNTIF($D$2:D353,\">0\"))","v":352},"NET2MARINEREAD"]
["NET2KEYPAD","NET2KEYPAD - Stainless steel outdoor keypad",516,1,{"$f":"IF(D354=0,\"\",COUNTIF($D$2:D354,\">0\"))","v":353},"NET2KEYPAD"]
["WEIGRECEIVER","WEIGRECEIVER - Receiver with weigand logging",127,1,{"$f":"IF(D355=0,\"\",COUNTIF($D$2:D355,\">0\"))","v":354},"WEIGRECEIVER"]
["PROXREADER","PROXREADER - Stand alone access control kit with reader built in",101,1,{"$f":"IF(D356=0,\"\",COUNTIF($D$2:D356,\">0\"))","v":355},"PROXREADER"]
["PROXTAG","PROXTAG - Keyring style proximity tag ",5,1,{"$f":"IF(D357=0,\"\",COUNTIF($D$2:D357,\">0\"))","v":356},"PROXTAG"]
["PROXCARD","PROXCARD - Flat durable proximity cards",5,1,{"$f":"IF(D358=0,\"\",COUNTIF($D$2:D358,\">0\"))","v":357},"PROXCARD"]
["1500SPEAR","1500SPEAR - 1500x1750 Spear pair gate ",2128,1,{"$f":"IF(D359=0,\"\",COUNTIF($D$2:D359,\">0\"))","v":358},"1500SPEAR"]
["1500RING","1500RING - 1500x1750 Ring pair gate",2149,1,{"$f":"IF(D360=0,\"\",COUNTIF($D$2:D360,\">0\"))","v":359},"1500RING"]
["1500THRU","1500THRU - 1500x1750 Thru pair gate",1859,1,{"$f":"IF(D361=0,\"\",COUNTIF($D$2:D361,\">0\"))","v":360},"1500THRU"]
["3500THRU","3500THRU - Thru gate 3500x1750",1703,1,{"$f":"IF(D362=0,\"\",COUNTIF($D$2:D362,\">0\"))","v":361},"3500THRU"]
["PALISADE2100","PALISADE2100 - Panel including rails and one post.",2630,1,{"$f":"IF(D363=0,\"\",COUNTIF($D$2:D363,\">0\"))","v":362},"PALISADE2100"]
["PALISADEPOST","PALISADEPOST - Palisade post x 2600",142,1,{"$f":"IF(D364=0,\"\",COUNTIF($D$2:D364,\">0\"))","v":363},"PALISADEPOST"]
["SLAT38X16MILL","SLAT38X16MILL - Aluminium slat 38x16 Mill - Metre",9.5,1,{"$f":"IF(D365=0,\"\",COUNTIF($D$2:D365,\">0\"))","v":364},"SLAT38X16MILL"]
["SLAT38X16WOOD","SLAT38X16WOOD- Aluminium slat 38x16 Woodgrain - Metre",14.700000000000001,1,{"$f":"IF(D366=0,\"\",COUNTIF($D$2:D366,\">0\"))","v":365},"SLAT38X16WOOD"]
["SLAT65X16MILL","SLAT65X16MILL - Aluminium slat 65x16 Mill - Metre",14.200000000000001,1,{"$f":"IF(D367=0,\"\",COUNTIF($D$2:D367,\">0\"))","v":366},"SLAT65X16MILL"]
["SLAT65X16WOOD","SLAT65X16WOOD- Aluminium slat 65x16 Woodgrain - Metre",22.700000000000003,1,{"$f":"IF(D368=0,\"\",COUNTIF($D$2:D368,\">0\"))","v":367},"SLAT65X16WOOD"]
["SLAT65X16PCOAT","SLAT65X16PCOAT- Aluminium slat 65x16 Powdercoat - Metre",16.8,1,{"$f":"IF(D369=0,\"\",COUNTIF($D$2:D369,\">0\"))","v":368},"SLAT65X16PCOAT"]
["SLAT38X16PCOAT","SLAT38X16PCOAT- Aluminium slat 38x16 Powderocat - Metre",10.9,1,{"$f":"IF(D370=0,\"\",COUNTIF($D$2:D370,\">0\"))","v":369},"SLAT38X16PCOAT"]
["SLATCHANMILL","SLATCHANMILL - Slat channel concealed fix Mill - Metre",10.9,1,{"$f":"IF(D371=0,\"\",COUNTIF($D$2:D371,\">0\"))","v":370},"SLATCHANMILL"]
["SLATCHANWOOD","SLATCHANWOOD- Slat channel concealed fix Woodgrain - Mtr",16.3,1,{"$f":"IF(D372=0,\"\",COUNTIF($D$2:D372,\">0\"))","v":371},"SLATCHANWOOD"]
["SLATCHANPCOAT","SLATCHANPCOAT- Slat channel concealed fix Powdercoat - Mtr",12.4,1,{"$f":"IF(D373=0,\"\",COUNTIF($D$2:D373,\">0\"))","v":372},"SLATCHANPCOAT"]
["COVERMILL","COVERMILL - Slat fixing cover Mill - Mtr",6.9,1,{"$f":"IF(D374=0,\"\",COUNTIF($D$2:D374,\">0\"))","v":373},"COVERMILL"]
["COVERWOOD","COVERWOOD- Slat fixing cover Woodgrain - Mtr",10.3,1,{"$f":"IF(D375=0,\"\",COUNTIF($D$2:D375,\">0\"))","v":374},"COVERWOOD"]
["COVERPCOAT","COVERPCOAT- Slat fixing cover Powdercoat - Mtr",7.8000000000000007,1,{"$f":"IF(D376=0,\"\",COUNTIF($D$2:D376,\">0\"))","v":375},"COVERPCOAT"]
["STDFRAMEMILL","STDFRAMEMILL - Post single channel Mill - Mtr",41.2,1,{"$f":"IF(D377=0,\"\",COUNTIF($D$2:D377,\">0\"))","v":376},"STDFRAMEMILL"]
["STDFRAMEWOOD","STDFRAMEWOOD- Post single channel Woodgrain - Mtr",61.800000000000004,1,{"$f":"IF(D378=0,\"\",COUNTIF($D$2:D378,\">0\"))","v":377},"STDFRAMEWOOD"]
["STDFRAMEPCOAT","STDFRAMEPCOAT- Post single channel Powdercoat - Mtr",46.900000000000006,1,{"$f":"IF(D379=0,\"\",COUNTIF($D$2:D379,\">0\"))","v":378},"STDFRAMEPCOAT"]
["CNRPOSTMILL","CNRPOSTMILL - Corner two channel Mill - Mtr",48.800000000000004,1,{"$f":"IF(D380=0,\"\",COUNTIF($D$2:D380,\">0\"))","v":379},"CNRPOSTMILL"]
["CNRPOSTWOOD","CNRPOSTWOOD- Corner two channel Woodgrain - Mtr",73.3,1,{"$f":"IF(D381=0,\"\",COUNTIF($D$2:D381,\">0\"))","v":380},"CNRPOSTWOOD"]
["CNRPOSTPCOAT","CNRPOSTPCOAT- Corner two channel Powdercoat - Mtr",55.6,1,{"$f":"IF(D382=0,\"\",COUNTIF($D$2:D382,\">0\"))","v":381},"CNRPOSTPCOAT"]
["CTRPOSTMILL","CTRPOSTMILL - Centre two channel Mill - Mtr",48.800000000000004,1,{"$f":"IF(D383=0,\"\",COUNTIF($D$2:D383,\">0\"))","v":382},"CTRPOSTMILL"]
["CTRPOSTWOOD","CTRPOSTWOOD- Centre two channel Woodgrain - Mtr",73.3,1,{"$f":"IF(D384=0,\"\",COUNTIF($D$2:D384,\">0\"))","v":383},"CTRPOSTWOOD"]
["CTRPOSTPCOAT","CTRPOSTPCOAT- Centre two channel Powdercoat - Mtr",55.6,1,{"$f":"IF(D385=0,\"\",COUNTIF($D$2:D385,\">0\"))","v":384},"CTRPOSTPCOAT"]
["SLATBRACEBLK","SLATBRACEBLK - Slat brace in black - Mtr",4.5,1,{"$f":"IF(D386=0,\"\",COUNTIF($D$2:D386,\">0\"))","v":385},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D385),E:E,0)),\"\")","v":"SLATBRACEBLK"}]
["POSTCAP","POSTCAP - End cap for post and corner post",2.7,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A387),0)","v":1},{"$f":"IF(D387=0,\"\",COUNTIF($D$2:D387,\">0\"))","v":386},"POSTCAP"]
["SLATCHANCAP","SLATCHANCAP - End cap for slat channel and cover",1.8,1,{"$f":"IF(D388=0,\"\",COUNTIF($D$2:D388,\">0\"))","v":387},"SLATCHANCAP"]
["STDCORNER","STDCORNER - Corner stake for standard frame.",5.7,1,{"$f":"IF(D389=0,\"\",COUNTIF($D$2:D389,\">0\"))","v":388},"STDCORNER"]
["STDINTBRACKET","STDINTBRACKET - Internal sleeve backet for standard frame.",19,1,{"$f":"IF(D390=0,\"\",COUNTIF($D$2:D390,\">0\"))","v":389},"STDINTBRACKET"]
["EASYPEDPAK","EASYPEDPAK - Pair of self closing hinges and lockable latch",125.7,1,{"$f":"IF(D391=0,\"\",COUNTIF($D$2:D391,\">0\"))","v":390},"EASYPEDPAK"]
["60X40ALLYRHS","60X40ALLYRHS - 60x40x3 Aluminium RHS per metre",30.3,1,{"$f":"IF(D392=0,\"\",COUNTIF($D$2:D392,\">0\"))","v":391},"60X40ALLYRHS"]
["EASYRUBBER","EASYRUBBER - 25x13 rubber strip per metre",11.100000000000001,1,{"$f":"IF(D393=0,\"\",COUNTIF($D$2:D393,\">0\"))","v":392},"EASYRUBBER"]
["EASYFRAMEMILL","EASYFRAMEMILL - Easy Gate frame in mill finish - Mtr",52.6,1,{"$f":"IF(D394=0,\"\",COUNTIF($D$2:D394,\">0\"))","v":393},"EASYFRAMEMILL"]
["EASYFRAMEWOOD","EASYFRAMEWOOD - Easy Gate frame in woodgrain - Mtr",87.9,1,{"$f":"IF(D395=0,\"\",COUNTIF($D$2:D395,\">0\"))","v":394},"EASYFRAMEWOOD"]
["EASYFRAMEPCOAT","EASYFRAMEPCOAT - Easy Gate frame in powder coat - Mtr",61.300000000000004,1,{"$f":"IF(D396=0,\"\",COUNTIF($D$2:D396,\">0\"))","v":395},"EASYFRAMEPCOAT"]
["EASYCORNER","EASYCORNER - Easy Gate frame corner brace",30.200000000000003,1,{"$f":"IF(D397=0,\"\",COUNTIF($D$2:D397,\">0\"))","v":396},"EASYCORNER"]
["MULLIONMILL","MULLIONMILL - Mullion frame in mill finish - Mtr",30.900000000000002,1,{"$f":"IF(D398=0,\"\",COUNTIF($D$2:D398,\">0\"))","v":397},"MULLIONMILL"]
["MULLIONWOOD","MULLIONWOOD - Mullion frame in woodgrain - Mtr",51.6,1,{"$f":"IF(D399=0,\"\",COUNTIF($D$2:D399,\">0\"))","v":398},"MULLIONWOOD"]
["MULLIONPCOAT","MULLIONPCOAT - Mullion frame in powder coat - Mtr",36,1,{"$f":"IF(D400=0,\"\",COUNTIF($D$2:D400,\">0\"))","v":399},"MULLIONPCOAT"]
["DRIVEWAYFRAME","DRIVEWAYFRAME - Driveway frame in mill finish - Mtr",63.400000000000006,1,{"$f":"IF(D401=0,\"\",COUNTIF($D$2:D401,\">0\"))","v":400},"DRIVEWAYFRAME"]
["POST502650","POST502650 - 50x50xx2650 powder coated post",100,1,{"$f":"IF(D402=0,\"\",COUNTIF($D$2:D402,\">0\"))","v":401},"POST502650"]
["POST652650","POST652650 - 65x65x2650 powder coated post",132,1,{"$f":"IF(D403=0,\"\",COUNTIF($D$2:D403,\">0\"))","v":402},"POST652650"]
["POST1002650","POST1002650 - 100x100x2650 powder coated post",206,1,{"$f":"IF(D404=0,\"\",COUNTIF($D$2:D404,\">0\"))","v":403},"POST1002650"]
["ALLYSHT120024003","ALLYSHT120024003 - 3mm ally sheet. 1200x2400",387,1,{"$f":"IF(D405=0,\"\",COUNTIF($D$2:D405,\">0\"))","v":404},"ALLYSHT120024003"]
["ALLYSHT150030003","ALLYSHT150030003 - 3mm ally sheet. 1500x3000",616.30000000000007,1,{"$f":"IF(D406=0,\"\",COUNTIF($D$2:D406,\">0\"))","v":405},"ALLYSHT150030003"]
["ALLYSHT150030005","ALLYSHT150030005 - 5mm ally sheet. 1500x3000",1039.9000000000001,1,{"$f":"IF(D407=0,\"\",COUNTIF($D$2:D407,\">0\"))","v":406},"ALLYSHT150030005"]
["K00102-F03","K00102-F03 50X50 (25Sq -Single Side Punched) x 6500",204,1,{"$f":"IF(D408=0,\"\",COUNTIF($D$2:D408,\">0\"))","v":407},"K00102-F03"]
["K00102-F04","K00102-F04 50X50 (25Sq -Double Side Punched) x 6500",204,1,{"$f":"IF(D409=0,\"\",COUNTIF($D$2:D409,\">0\"))","v":408},"K00102-F04"]
["K00102-F05","K00102-F05 50X50 (19Rnd - Single Side Punched) x 6500",204,1,{"$f":"IF(D410=0,\"\",COUNTIF($D$2:D410,\">0\"))","v":409},"K00102-F05"]
["K00102-F06","K00102-F06 50X50 (19Rnd - Double Side Punched) x 6500",204,1,{"$f":"IF(D411=0,\"\",COUNTIF($D$2:D411,\">0\"))","v":410},"K00102-F06"]
["I01028-F25","I01028-F25 100X50 (25Sq - Single Side Punched) x 6500",336,1,{"$f":"IF(D412=0,\"\",COUNTIF($D$2:D412,\">0\"))","v":411},"I01028-F25"]
["I01028-F26","I01028-F26 100X50 (19Rnd - Single Side Punched) x 6500",336,1,{"$f":"IF(D413=0,\"\",COUNTIF($D$2:D413,\">0\"))","v":412},"I01028-F26"]
["SH502.56500","SH502.56500 - 50X50X2.5 x 6500",161.10000000000002,1,{"$f":"IF(D414=0,\"\",COUNTIF($D$2:D414,\">0\"))","v":413},"SH502.56500"]
["RH100503.06500","RH100503.06500 - 100X50X3 x 6500",292.8,1,{"$f":"IF(D415=0,\"\",COUNTIF($D$2:D415,\">0\"))","v":414},"RH100503.06500"]
["SH251.66500","SH251.66500 - 25X25X1.6 x 6500",50.7,1,{"$f":"IF(D416=0,\"\",COUNTIF($D$2:D416,\">0\"))","v":415},"SH251.66500"]
["RT191.26500","RT191.26500 - 19X1.2 x 6500",22.8,1,{"$f":"IF(D417=0,\"\",COUNTIF($D$2:D417,\">0\"))","v":416},"RT191.26500"]
["RH76.225.42.46500","RH76.225.42.46500 - 75X25X2.5 x 6500",150,1,{"$f":"IF(D418=0,\"\",COUNTIF($D$2:D418,\">0\"))","v":417},"RH76.225.42.46500"]
["RH100252.56500","RH100252.56500 - 100X25X2.5 x 6500",203.3,1,{"$f":"IF(D419=0,\"\",COUNTIF($D$2:D419,\">0\"))","v":418},"RH100252.56500"]
["LUXE3","LUXE3 - 3 metre boom gate kit with boom ",2377,1,{"$f":"IF(D420=0,\"\",COUNTIF($D$2:D420,\">0\"))","v":419},"LUXE3"]
["LUXE4","LUXE4 - Boom gate - No boom, hub or spring",2265,1,{"$f":"IF(D421=0,\"\",COUNTIF($D$2:D421,\">0\"))","v":420},"LUXE4"]
["LUXE3&4BASE","LUXE3&4BASE - Base plate for LUXE4 and LUXE3",103,1,{"$f":"IF(D422=0,\"\",COUNTIF($D$2:D422,\">0\"))","v":421},"LUXE3&4BASE"]
["LA4MLED","LA4MLED - LED kit for 4 metre AE4BOOM.",151,1,{"$f":"IF(D423=0,\"\",COUNTIF($D$2:D423,\">0\"))","v":422},"LA4MLED"]
["PG4MSTRIP","PG4MSTRIP - Rubber edge strip for AE4BOOM.",81,1,{"$f":"IF(D424=0,\"\",COUNTIF($D$2:D424,\">0\"))","v":423},"PG4MSTRIP"]
["LUXE6","LUXE6 - Boom gate - No boom or springs",3439,1,{"$f":"IF(D425=0,\"\",COUNTIF($D$2:D425,\">0\"))","v":424},"LUXE6"]
["AE3BOOM","AE3BOOM - Elliptical aluminium boom. ",409,1,{"$f":"IF(D426=0,\"\",COUNTIF($D$2:D426,\">0\"))","v":425},"AE3BOOM"]
["AE4BOOM","AE4BOOM - Elliptical aluminium boom.",468,1,{"$f":"IF(D427=0,\"\",COUNTIF($D$2:D427,\">0\"))","v":426},"AE4BOOM"]
["TAUSYNCCOMM","TAUSYNCCOMM - Communications interface for TAU boards",131,1,{"$f":"IF(D428=0,\"\",COUNTIF($D$2:D428,\">0\"))","v":427},"TAUSYNCCOMM"]
["LA8MLED","LA8MLED - LED kit for 6 metre boom",232,1,{"$f":"IF(D429=0,\"\",COUNTIF($D$2:D429,\">0\"))","v":428},"LA8MLED"]
["AEBOOMHUB","AEBOOMHUB - Boom hub for AEBOOM",85,1,{"$f":"IF(D430=0,\"\",COUNTIF($D$2:D430,\">0\"))","v":429},"AEBOOMHUB"]
["LUXE3BOOM","LUXE3BOOM - Round section telescopic boom Ø 75 mm, 3 m",339,1,{"$f":"IF(D431=0,\"\",COUNTIF($D$2:D431,\">0\"))","v":430},"LUXE3BOOM"]
["DIVA3","DIVA3 - 3 metre carpark boom gate",5763,1,{"$f":"IF(D432=0,\"\",COUNTIF($D$2:D432,\">0\"))","v":431},"DIVA3"]
["DIVA3BOOM","DIVA3BOOM - 3 metre boom with RGB leds",739,1,{"$f":"IF(D433=0,\"\",COUNTIF($D$2:D433,\">0\"))","v":432},"DIVA3BOOM"]
["PG8MSTRIP","PG8MSTRIP - Rubber edge strip for 6 metre boom",144,1,{"$f":"IF(D434=0,\"\",COUNTIF($D$2:D434,\">0\"))","v":433},"PG8MSTRIP"]
["LLCABLED","LLCABLED - Cabinet LED Kit for LUXE",140,1,{"$f":"IF(D435=0,\"\",COUNTIF($D$2:D435,\">0\"))","v":434},"LLCABLED"]
["REDSPRING","REDSPRING - 7mm Spring",123,1,{"$f":"IF(D436=0,\"\",COUNTIF($D$2:D436,\">0\"))","v":435},"REDSPRING"]
["CITYBOOM","CITYBOOM - Aluminium four to six metre boom",588,1,{"$f":"IF(D437=0,\"\",COUNTIF($D$2:D437,\">0\"))","v":436},"CITYBOOM"]
["LUXE6ARTARM","LUXE6ARTARM - Articulated arm for LUXE6 boom gate",1063,1,{"$f":"IF(D438=0,\"\",COUNTIF($D$2:D438,\">0\"))","v":437},"LUXE6ARTARM"]
["FPLSUPPORT","FPLSUPPORT - Drop down support leg for LUXE & RBLOX",192,1,{"$f":"IF(D439=0,\"\",COUNTIF($D$2:D439,\">0\"))","v":438},"FPLSUPPORT"]
["LUXE6BASE","LUXE6BASE - Base plate for LUXE6.",96,1,{"$f":"IF(D440=0,\"\",COUNTIF($D$2:D440,\">0\"))","v":439},"LUXE6BASE"]
["LUXESS","LUXESS - Stainless Steel boom gate - No boom or springs",5592,1,{"$f":"IF(D441=0,\"\",COUNTIF($D$2:D441,\">0\"))","v":440},"LUXESS"]
["LUXEBREAKAWAY","LUXEBREAKAWAY - Boom breakaway for LUXE (Max 5M)",1063,1,{"$f":"IF(D442=0,\"\",COUNTIF($D$2:D442,\">0\"))","v":441},"LUXEBREAKAWAY"]
["LUXESKIRTGA2","LUXESKIRTGA2 - 1.6 mtr lead skirt section for Luxe boom gate.",212,1,{"$f":"IF(D443=0,\"\",COUNTIF($D$2:D443,\">0\"))","v":442},"LUXESKIRTGA2"]
["LUXESKIRTPGA2","LUXESKIRTPGA2 - 1.95 mtr follow skirt section for Luxe boom gate.",212,1,{"$f":"IF(D444=0,\"\",COUNTIF($D$2:D444,\">0\"))","v":443},"LUXESKIRTPGA2"]
["GICOUPLING","GICOUPLING - Boom coupling for AE3BOOM - turns 3 mtr into 6.",151,1,{"$f":"IF(D445=0,\"\",COUNTIF($D$2:D445,\">0\"))","v":444},"GICOUPLING"]
["RAFRAME","RAFRAME - Boom reinforcement frame for LUXE.",137,1,{"$f":"IF(D446=0,\"\",COUNTIF($D$2:D446,\">0\"))","v":445},"RAFRAME"]
["YELLOWSPRING","YELLOWSPRING - 9mm Spring",123,1,{"$f":"IF(D447=0,\"\",COUNTIF($D$2:D447,\">0\"))","v":446},"YELLOWSPRING"]
["LUXE4ARTARM","LUXE4ARTARM - Articulated arm for LUXE4 boom gate",1063,1,{"$f":"IF(D448=0,\"\",COUNTIF($D$2:D448,\">0\"))","v":447},"LUXE4ARTARM"]
["LUXE6KIT","LUXE6KIT - 6 metre boom gate kit with six metre boom.",4790,1,{"$f":"IF(D449=0,\"\",COUNTIF($D$2:D449,\">0\"))","v":448},"LUXE6KIT"]
["LUXE4KIT","LUXE4KIT - 4 metre boom gate kit with four metre boom.",2939,1,{"$f":"IF(D450=0,\"\",COUNTIF($D$2:D450,\">0\"))","v":449},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D449),E:E,0)),\"\")","v":"LUXE4KIT"}]
["EVA8","EVA8 - 8 Metre industrial boom gate.  (24 volt - 8 metre)",6334,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A451),0)","v":1},{"$f":"IF(D451=0,\"\",COUNTIF($D$2:D451,\">0\"))","v":450},"EVA8"]
["EVA8BOOM","EVA8BOOM - 8 Metre two part boom - complete kit.",1690,1,{"$f":"IF(D452=0,\"\",COUNTIF($D$2:D452,\">0\"))","v":451},"EVA8BOOM"]
["EVA8BASE","EVA8BASE - EVA8 base plate",151,1,{"$f":"IF(D453=0,\"\",COUNTIF($D$2:D453,\">0\"))","v":452},"EVA8BASE"]
["EVA8FLASHER","EVA8FLASHER - Flashing light module for EVA8",138,1,{"$f":"IF(D454=0,\"\",COUNTIF($D$2:D454,\">0\"))","v":453},"EVA8FLASHER"]
["BENINCASYNC","BENINCASYNC - Module - EVA8, BULL1524, BULL624TURBO (Need 2)",110,1,{"$f":"IF(D455=0,\"\",COUNTIF($D$2:D455,\">0\"))","v":454},"BENINCASYNC"]
["EVA8SKIRT","EVA8SKIRT - Two metre skirt for EVA8 (Maximum boom 7.0mtr)",305,1,{"$f":"IF(D456=0,\"\",COUNTIF($D$2:D456,\">0\"))","v":455},"EVA8SKIRT"]
["EVA8LIGHTS","EVA8LIGHTS - Light kit for EVA8 boom",232,1,{"$f":"IF(D457=0,\"\",COUNTIF($D$2:D457,\">0\"))","v":456},"EVA8LIGHTS"]
["BOOMSUPPORT","BOOMSUPPORT -Bolt down boom support",170,1,{"$f":"IF(D458=0,\"\",COUNTIF($D$2:D458,\">0\"))","v":457},"BOOMSUPPORT"]
["BOOMSUPPMAG","BOOMSUPPMAG - Bolt down boom support with mag lock",906,1,{"$f":"IF(D459=0,\"\",COUNTIF($D$2:D459,\">0\"))","v":458},"BOOMSUPPMAG"]
["CHAIN","CHAIN - Chaingate chain per metre",49,1,{"$f":"IF(D460=0,\"\",COUNTIF($D$2:D460,\">0\"))","v":459},"CHAIN"]
["VIGILANT800","VIGILANT800 - Automatic traffic control bollard","P.O.A.",1,{"$f":"IF(D461=0,\"\",COUNTIF($D$2:D461,\">0\"))","v":460},"VIGILANT800"]
["VIGILANT800SS","VIGILANT800SS - Automatic traffic control bollard stainless steel","P.O.A.",1,{"$f":"IF(D462=0,\"\",COUNTIF($D$2:D462,\">0\"))","v":461},"VIGILANT800SS"]
["VIGILANTKIT","VIGILANTKIT - Foundation kit for vigilant","P.O.A.",1,{"$f":"IF(D463=0,\"\",COUNTIF($D$2:D463,\">0\"))","v":462},"VIGILANTKIT"]
["FORCE825","FORCE825 - Automatic security bollard","P.O.A.",1,{"$f":"IF(D464=0,\"\",COUNTIF($D$2:D464,\">0\"))","v":463},"FORCE825"]
["FORCE825SS","FORCE825SS - Automatic security bollard stainless steel","P.O.A.",1,{"$f":"IF(D465=0,\"\",COUNTIF($D$2:D465,\">0\"))","v":464},"FORCE825SS"]
["FORCEKIT","FORCEKIT - Foundation kit for force","P.O.A.",1,{"$f":"IF(D466=0,\"\",COUNTIF($D$2:D466,\">0\"))","v":465},"FORCEKIT"]
["FORCE825K","FORCE825K - Automatic anti terror bollard","P.O.A.",1,{"$f":"IF(D467=0,\"\",COUNTIF($D$2:D467,\">0\"))","v":466},"FORCE825K"]
["FORCE825KSS","FORCE825KSS - Automatic anti terror bollard stainless steel","P.O.A.",1,{"$f":"IF(D468=0,\"\",COUNTIF($D$2:D468,\">0\"))","v":467},"FORCE825KSS"]
["FORCEKKIT","FORCEKKIT - Foundation kit for force anti terror","P.O.A.",1,{"$f":"IF(D469=0,\"\",COUNTIF($D$2:D469,\">0\"))","v":468},"FORCEKKIT"]
["LOGICCP1S","LOGICCP1S - Logic control for one bollard.","P.O.A.",1,{"$f":"IF(D470=0,\"\",COUNTIF($D$2:D470,\">0\"))","v":469},"LOGICCP1S"]
["LOGICCP2S","LOGICCP2S - Logic control for two bollards.","P.O.A.",1,{"$f":"IF(D471=0,\"\",COUNTIF($D$2:D471,\">0\"))","v":470},"LOGICCP2S"]
["LOGICCP4S","LOGICCP4S - Logic control for four bollards.","P.O.A.",1,{"$f":"IF(D472=0,\"\",COUNTIF($D$2:D472,\">0\"))","v":471},"LOGICCP4S"]
["BOLLCABLE10M","BOLLCABLE10M - 10 metre bollard cable with plug ends","P.O.A.",1,{"$f":"IF(D473=0,\"\",COUNTIF($D$2:D473,\">0\"))","v":472},"BOLLCABLE10M"]
["BOLLCABLE15M","BOLLCABLE15M - 15 metre bollard cable with plug ends","P.O.A.",1,{"$f":"IF(D474=0,\"\",COUNTIF($D$2:D474,\">0\"))","v":473},"BOLLCABLE15M"]
["BOLLCABLE20M","BOLLCABLE20M - 20 metre bollard cable with plug ends","P.O.A.",1,{"$f":"IF(D475=0,\"\",COUNTIF($D$2:D475,\">0\"))","v":474},"BOLLCABLE20M"]
["BOLLCABLE25M","BOLLCABLE25M - 25 metre bollard cable with plug ends","P.O.A.",1,{"$f":"IF(D476=0,\"\",COUNTIF($D$2:D476,\">0\"))","v":475},"BOLLCABLE25M"]
["CHAINMASTER","CHAINMASTER - Chain gate master unit",3583,1,{"$f":"IF(D477=0,\"\",COUNTIF($D$2:D477,\">0\"))","v":476},"CHAINMASTER"]
["CHAINSLAVE","CHAINSLAVE - Chain gate slave unit",2626,1,{"$f":"IF(D478=0,\"\",COUNTIF($D$2:D478,\">0\"))","v":477},"CHAINSLAVE"]
["TRAFFICLGTS100","TRAFFICLGTS100 - Red/Green with brackets & visors 12/24 DC",979,1,{"$f":"IF(D479=0,\"\",COUNTIF($D$2:D479,\">0\"))","v":478},"TRAFFICLGTS100"]
["LIMIT4KIT","LIMIT4 KIT - Complete kit for four metre manual boom gate.",2819,1,{"$f":"IF(D480=0,\"\",COUNTIF($D$2:D480,\">0\"))","v":479},"LIMIT4KIT"]
["LIMIT4","LIMIT4 - Main base module for LIMIT4 manual boom",1226,1,{"$f":"IF(D481=0,\"\",COUNTIF($D$2:D481,\">0\"))","v":480},"LIMIT4"]
["LIMIT4BOOM","LIMITBOOM - 4 metre boom for LIMIT4 manual boom",487,1,{"$f":"IF(D482=0,\"\",COUNTIF($D$2:D482,\">0\"))","v":481},"LIMIT4BOOM"]
["LIMIT4BASE","LIMIT4BASE - Foundation plate kit for LIMIT4 manual boom",124,1,{"$f":"IF(D483=0,\"\",COUNTIF($D$2:D483,\">0\"))","v":482},"LIMIT4BASE"]
["LIMIT4SUPPORT","LIMIT4SUPPORT - Boom support for LIMIT4 manual boom",256,1,{"$f":"IF(D484=0,\"\",COUNTIF($D$2:D484,\">0\"))","v":483},"LIMIT4SUPPORT"]
["LIMIT4BALANCE","LIMIT4BALANCE - Boom balance shaft for LIMIT4 manual boom",85,1,{"$f":"IF(D485=0,\"\",COUNTIF($D$2:D485,\">0\"))","v":484},"LIMIT4BALANCE"]
["LIMIT4WEIGHTS","LIMIT4WEIGHTS - Balance weights for LIMIT4 manual boom",64,1,{"$f":"IF(D486=0,\"\",COUNTIF($D$2:D486,\">0\"))","v":485},"LIMIT4WEIGHTS"]
["LIMIT4BOOMCAP","LIMIT4BOOMCAP - End cap for LIMIT4 manual boom",13,1,{"$f":"IF(D487=0,\"\",COUNTIF($D$2:D487,\">0\"))","v":486},"LIMIT4BOOMCAP"]
["PORTASTDBASE","PORTASTDBASE - Base for LUXE & EVA boom gates.",2099,1,{"$f":"IF(D488=0,\"\",COUNTIF($D$2:D488,\">0\"))","v":487},"PORTASTDBASE"]
["PORTAHVYBASE","PORTAHVYBASE - Base for LUXE & EVA boom gates.",3025,1,{"$f":"IF(D489=0,\"\",COUNTIF($D$2:D489,\">0\"))","v":488},"PORTAHVYBASE"]
["PORTAINDBASE","PORTAINDBASE - Base for LUXE & EVA boom gates.",5091,1,{"$f":"IF(D490=0,\"\",COUNTIF($D$2:D490,\">0\"))","v":489},"PORTAINDBASE"]
["PARTS","PARTS",0,1,{"$f":"IF(D491=0,\"\",COUNTIF($D$2:D491,\">0\"))","v":490},"PARTS"]
["CB6LIGHTMOD","CB6LIGHTMOD - LOGICCB6 Light module",73,1,{"$f":"IF(D492=0,\"\",COUNTIF($D$2:D492,\">0\"))","v":491},"CB6LIGHTMOD"]
["GSMANT4GW","GSMANT4GW - AES GSM Antenna",104,1,{"$f":"IF(D493=0,\"\",COUNTIF($D$2:D493,\">0\"))","v":492},"GSMANT4GW"]
["LOCINOX3006FF","LOCINOX3006FF - Locinox blocking spindle",24,1,{"$f":"IF(D494=0,\"\",COUNTIF($D$2:D494,\">0\"))","v":493},"LOCINOX3006FF"]
["LOCINOX3006BLOK","LOCINOX3006BLOK - Locinox aluminium handle block",10,1,{"$f":"IF(D495=0,\"\",COUNTIF($D$2:D495,\">0\"))","v":494},"LOCINOX3006BLOK"]
["ASAPARTS","ASAPARTS -",0,1,{"$f":"IF(D496=0,\"\",COUNTIF($D$2:D496,\">0\"))","v":495},"ASAPARTS"]
["ASARELEASEKEY","ASARELEASEKEY - Manual release key Allen key style",17,1,{"$f":"IF(D497=0,\"\",COUNTIF($D$2:D497,\">0\"))","v":496},"ASARELEASEKEY"]
["ASAPOSTBRACKET","ASAPOSTBRACKET - Post bracket for ASA swing gate motors",30,1,{"$f":"IF(D498=0,\"\",COUNTIF($D$2:D498,\">0\"))","v":497},"ASAPOSTBRACKET"]
["ASAGATEBRACKET","ASAGATEBRACKET - Gate bracket for ASA swing gate motors",19,1,{"$f":"IF(D499=0,\"\",COUNTIF($D$2:D499,\">0\"))","v":498},"ASAGATEBRACKET"]
["ASAGRUBSCREW","ASAGRUBSCREW - Securing grub screw for ASA swing gate motor",5,1,{"$f":"IF(D500=0,\"\",COUNTIF($D$2:D500,\">0\"))","v":499},"ASAGRUBSCREW"]
["ASAPIVOTPIN","ASAPIVOTPIN - Pivot pin for ASA swing gate motors",5,1,{"$f":"IF(D501=0,\"\",COUNTIF($D$2:D501,\">0\"))","v":500},"ASAPIVOTPIN"]
["ASALIMITACT","ASALIMITACT - Limit actuators for ASA sliders.",43,1,{"$f":"IF(D502=0,\"\",COUNTIF($D$2:D502,\">0\"))","v":501},"ASALIMITACT"]
["ASA6000ROCKER","ASA6000ROCKER - Spring / Motor rocker arm",233,1,{"$f":"IF(D503=0,\"\",COUNTIF($D$2:D503,\">0\"))","v":502},"ASA6000ROCKER"]
["ASA6000SHAFT","ASA6000SHAFT - Main shaft for ASA6000",247,1,{"$f":"IF(D504=0,\"\",COUNTIF($D$2:D504,\">0\"))","v":503},"ASA6000SHAFT"]
["ASA8WORMGEAR","ASA8WORMGEAR - Metal worm gear for ASA sliders",68,1,{"$f":"IF(D505=0,\"\",COUNTIF($D$2:D505,\">0\"))","v":504},"ASA8WORMGEAR"]
["PCBID410","LOGICID410 - PCB for ASA6",246,1,{"$f":"IF(D506=0,\"\",COUNTIF($D$2:D506,\">0\"))","v":505},"PCBID410"]
["ASA6UNLOCKLEV","ASA6UNLOCKLEV - release lever for ASA6 (Old)",43,1,{"$f":"IF(D507=0,\"\",COUNTIF($D$2:D507,\">0\"))","v":506},"ASA6UNLOCKLEV"]
["ASA6COVER-OLD","ASA6COVER-OLD - Cover for ASA6 (old)",68,1,{"$f":"IF(D508=0,\"\",COUNTIF($D$2:D508,\">0\"))","v":507},"ASA6COVER-OLD"]
["TOROIDALTRAN","TOROIDALTRAN - toroidal transformer 12-24",245,1,{"$f":"IF(D509=0,\"\",COUNTIF($D$2:D509,\">0\"))","v":508},"TOROIDALTRAN"]
["PCBID200","PCBID200 -ID200 PCB",297,1,{"$f":"IF(D510=0,\"\",COUNTIF($D$2:D510,\">0\"))","v":509},"PCBID200"]
["ASALIMITSPRING","ASALIMITSPRING - Limit switch spring",34,1,{"$f":"IF(D511=0,\"\",COUNTIF($D$2:D511,\">0\"))","v":510},"ASALIMITSPRING"]
["ASA6LIMITBOOT","ASA6LIMITBOOT - Rubber limit boot for ASA6 (Old)",6,1,{"$f":"IF(D512=0,\"\",COUNTIF($D$2:D512,\">0\"))","v":511},"ASA6LIMITBOOT"]
["E3300BRACKETS","E3300BRACKETS - Set of aluminium add on brackets for E3300",113,1,{"$f":"IF(D513=0,\"\",COUNTIF($D$2:D513,\">0\"))","v":512},"E3300BRACKETS"]
["GR6E","GR6E - 12 volt motor for Drop Gate and Cantilever Boom",570,1,{"$f":"IF(D514=0,\"\",COUNTIF($D$2:D514,\">0\"))","v":513},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D513),E:E,0)),\"\")","v":"GR6E"}]
["ASAOVERIDECAP","ASAOVERIDECAP - Overide cap for ASA swing motors",4,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A515),0)","v":1},{"$f":"IF(D515=0,\"\",COUNTIF($D$2:D515,\">0\"))","v":514},"ASAOVERIDECAP"]
["ASARELEASEASS","ASARELEASEASS - ASA300-600 release assembly with \"O\" rings",24,1,{"$f":"IF(D516=0,\"\",COUNTIF($D$2:D516,\">0\"))","v":515},"ASARELEASEASS"]
["ASA6KEYBARREL","ASA6KEYBARREL - key and barrel for ASA6 (Old)",37,1,{"$f":"IF(D517=0,\"\",COUNTIF($D$2:D517,\">0\"))","v":516},"ASA6KEYBARREL"]
["E3300MOTOR","E3300MOTOR - Motor for E3300",85,1,{"$f":"IF(D518=0,\"\",COUNTIF($D$2:D518,\">0\"))","v":517},"E3300MOTOR"]
["E3300GEARBOX","E3300GEARBOX - Gearbox for E3300",85,1,{"$f":"IF(D519=0,\"\",COUNTIF($D$2:D519,\">0\"))","v":518},"E3300GEARBOX"]
["E3300COUPLER","E3300COUPLER - Coupler for E3300",10,1,{"$f":"IF(D520=0,\"\",COUNTIF($D$2:D520,\">0\"))","v":519},"E3300COUPLER"]
["ASA300600MOT","ASA300600MOT - Motor for ASA30012V & ASA60012V",244,1,{"$f":"IF(D521=0,\"\",COUNTIF($D$2:D521,\">0\"))","v":520},"ASA300600MOT"]
["PCBMCS","PCBMCS - Elsema MCS PCB",329,1,{"$f":"IF(D522=0,\"\",COUNTIF($D$2:D522,\">0\"))","v":521},"PCBMCS"]
["RIBPARTS","RIBPARTS -",0,1,{"$f":"IF(D523=0,\"\",COUNTIF($D$2:D523,\">0\"))","v":522},"RIBPARTS"]
["K5COVER","K5COVER - K5 motor cover",109,1,{"$f":"IF(D524=0,\"\",COUNTIF($D$2:D524,\">0\"))","v":523},"K5COVER"]
["PCBK500","PCBK500 - PCB for K500",502,1,{"$f":"IF(D525=0,\"\",COUNTIF($D$2:D525,\">0\"))","v":524},"PCBK500"]
["K500PINION","K500PINION - Gear",106,1,{"$f":"IF(D526=0,\"\",COUNTIF($D$2:D526,\">0\"))","v":525},"K500PINION"]
["K500COVER","K500COVER - K500 motor cover",136,1,{"$f":"IF(D527=0,\"\",COUNTIF($D$2:D527,\">0\"))","v":526},"K500COVER"]
["KINGLOCKCYL","KINGLOCKCYL - KING lock cylinder and keys",114,1,{"$f":"IF(D528=0,\"\",COUNTIF($D$2:D528,\">0\"))","v":527},"KINGLOCKCYL"]
["KSERIESCOVER","KSERIESCOVER - K series slider motor cover",163,1,{"$f":"IF(D529=0,\"\",COUNTIF($D$2:D529,\">0\"))","v":528},"KSERIESCOVER"]
["K500LIMITACT","K500LIMITACT - Pair of K500 limit actuators",113,1,{"$f":"IF(D530=0,\"\",COUNTIF($D$2:D530,\">0\"))","v":529},"K500LIMITACT"]
["PRINCEMECHSTOP","PRINCEMECHSTOP - Mechanical stopper for PRINCE",61,1,{"$f":"IF(D531=0,\"\",COUNTIF($D$2:D531,\">0\"))","v":530},"PRINCEMECHSTOP"]
["RIBPIVOTFORK","RIBPIVOTFORK - Rear pivot fork for PRINCE and KING",113,1,{"$f":"IF(D532=0,\"\",COUNTIF($D$2:D532,\">0\"))","v":531},"RIBPIVOTFORK"]
["PRINCEMOTOR","PRINCEMOTOR - 24 volt Prince motor",341,1,{"$f":"IF(D533=0,\"\",COUNTIF($D$2:D533,\">0\"))","v":532},"PRINCEMOTOR"]
["PRINCECARRIAGE","PRINCECARRIAGE - worm carriage for Prince",131,1,{"$f":"IF(D534=0,\"\",COUNTIF($D$2:D534,\">0\"))","v":533},"PRINCECARRIAGE"]
["PRINCEPOSTBRAC","PRINCEPOSTBRAC - bracket for post mounting for Prince",87,1,{"$f":"IF(D535=0,\"\",COUNTIF($D$2:D535,\">0\"))","v":534},"PRINCEPOSTBRAC"]
["PRINCEGATEBRAC","PRINCEGATEBRAC - bracket for gate mounting for Prince",87,1,{"$f":"IF(D536=0,\"\",COUNTIF($D$2:D536,\">0\"))","v":535},"PRINCEGATEBRAC"]
["PRINCELOCKKEYS","PRINCELOCKKEYS - lock and key assembly for Prince",118,1,{"$f":"IF(D537=0,\"\",COUNTIF($D$2:D537,\">0\"))","v":536},"PRINCELOCKKEYS"]
["PRINCELOCKCAM","PRINCELOCKCAM - lock cam for Prince",23,1,{"$f":"IF(D538=0,\"\",COUNTIF($D$2:D538,\">0\"))","v":537},"PRINCELOCKCAM"]
["KINGMECHSTOP","KINGMECHSTOP - Mechanical stopper for KING",75,1,{"$f":"IF(D539=0,\"\",COUNTIF($D$2:D539,\">0\"))","v":538},"KINGMECHSTOP"]
["K400TRANS","K400TRANS - Transformer for K400FAST",229,1,{"$f":"IF(D540=0,\"\",COUNTIF($D$2:D540,\">0\"))","v":539},"K400TRANS"]
["CHAINBREAKAWAY","CHAINBREAKAWAY - Chaingate breakaway chain connector",86,1,{"$f":"IF(D541=0,\"\",COUNTIF($D$2:D541,\">0\"))","v":540},"CHAINBREAKAWAY"]
["CHAINEYEBOLT","CHAINEYEBOLT - Chaingate eyebolt",128,1,{"$f":"IF(D542=0,\"\",COUNTIF($D$2:D542,\">0\"))","v":541},"CHAINEYEBOLT"]
["CHAINCARRIAGE","CHAINCARRIAGE - Chaingate trailing carriage",473,1,{"$f":"IF(D543=0,\"\",COUNTIF($D$2:D543,\">0\"))","v":542},"CHAINCARRIAGE"]
["CHAINDRVCHAIN","CHAINDRVCHAIN - Chaingate drive chain and connector",368,1,{"$f":"IF(D544=0,\"\",COUNTIF($D$2:D544,\">0\"))","v":543},"CHAINDRVCHAIN"]
["PCBCHAINGATE","PCBCHAINGATE - Logic control for chain gate",666,1,{"$f":"IF(D545=0,\"\",COUNTIF($D$2:D545,\">0\"))","v":544},"PCBCHAINGATE"]
["PCBS1LOGIC","PCBS1LOGIC - S1 logic control PCB",919,1,{"$f":"IF(D546=0,\"\",COUNTIF($D$2:D546,\">0\"))","v":545},"PCBS1LOGIC"]
["CHAINGATEMOT","CHAINGATEMOT - Motor for chain gate",451,1,{"$f":"IF(D547=0,\"\",COUNTIF($D$2:D547,\">0\"))","v":546},"CHAINGATEMOT"]
["CHAINSHACKLE","CHAINSHACKLE - Chaingate shackle connector",66,1,{"$f":"IF(D548=0,\"\",COUNTIF($D$2:D548,\">0\"))","v":547},"CHAINSHACKLE"]
["CHAINMECHFUSE","CHAINMECHFUSE - Chaingate mechanical fuse assembly",95,1,{"$f":"IF(D549=0,\"\",COUNTIF($D$2:D549,\">0\"))","v":548},"CHAINMECHFUSE"]
["KSERIESPINION","KSERIESPINION - K series pinion gear",198,1,{"$f":"IF(D550=0,\"\",COUNTIF($D$2:D550,\">0\"))","v":549},"KSERIESPINION"]
["CHAINGATEBATT","CHAINGATEBATT - Battery backup module for Chaingate",273,1,{"$f":"IF(D551=0,\"\",COUNTIF($D$2:D551,\">0\"))","v":550},"CHAINGATEBATT"]
["K500LOCKKEYS","K500LOCKKEYS - Lock and keys for K500",59,1,{"$f":"IF(D552=0,\"\",COUNTIF($D$2:D552,\">0\"))","v":551},"K500LOCKKEYS"]
["KINGCARRIAGE","KINGCARRIAGE - worm carriage for KING",163,1,{"$f":"IF(D553=0,\"\",COUNTIF($D$2:D553,\">0\"))","v":552},"KINGCARRIAGE"]
["TAUPARTS","TAUPARTS  -",0,1,{"$f":"IF(D554=0,\"\",COUNTIF($D$2:D554,\">0\"))","v":553},"TAUPARTS"]
["PCBK122","PCBK122 - PCB for SPEED2",435,1,{"$f":"IF(D555=0,\"\",COUNTIF($D$2:D555,\">0\"))","v":554},"PCBK122"]
["PCBK590","PCBK590 - PCB for MASTER20",535,1,{"$f":"IF(D556=0,\"\",COUNTIF($D$2:D556,\">0\"))","v":555},"PCBK590"]
["PCBK126MA","PCBK126MA - PCB for TONE10B and MASTER18QR",444,1,{"$f":"IF(D557=0,\"\",COUNTIF($D$2:D557,\">0\"))","v":556},"PCBK126MA"]
["MASTERDOG","MASTERDOG - Nylon gear and metal insert for MASTER",102,1,{"$f":"IF(D558=0,\"\",COUNTIF($D$2:D558,\">0\"))","v":557},"MASTERDOG"]
["TAUENCODER","TAUENCODER - Encoder with plug end",51,1,{"$f":"IF(D559=0,\"\",COUNTIF($D$2:D559,\">0\"))","v":558},"TAUENCODER"]
["PCBK100","PCBK100 - PCB for TONE E series",338,1,{"$f":"IF(D560=0,\"\",COUNTIF($D$2:D560,\">0\"))","v":559},"PCBK100"]
["TONERELEASE","TONERELEASE - Release assembly inc barrel and keys",92,1,{"$f":"IF(D561=0,\"\",COUNTIF($D$2:D561,\">0\"))","v":560},"TONERELEASE"]
["PCBK123","PCBK123 - PCB for MASTER12",465,1,{"$f":"IF(D562=0,\"\",COUNTIF($D$2:D562,\">0\"))","v":561},"PCBK123"]
["MASTERCOVER","MASTERCOVER",157,1,{"$f":"IF(D563=0,\"\",COUNTIF($D$2:D563,\">0\"))","v":562},"MASTERCOVER"]
["MASTERRELEASE","MASTERRELEASE - Release assembly inc barrel and keys",111,1,{"$f":"IF(D564=0,\"\",COUNTIF($D$2:D564,\">0\"))","v":563},"MASTERRELEASE"]
["RBLOMOTBOX","RBLOMOTBOX - RBLO motor and gearbox assembly",1714,1,{"$f":"IF(D565=0,\"\",COUNTIF($D$2:D565,\">0\"))","v":564},"RBLOMOTBOX"]
["PCBK205","PCBK205 - PCB for RBLO and CITY",428,1,{"$f":"IF(D566=0,\"\",COUNTIF($D$2:D566,\">0\"))","v":565},"PCBK205"]
["RBLOXHUBNO","RBLOXHUBNO - RBLOX hub without bush",95,1,{"$f":"IF(D567=0,\"\",COUNTIF($D$2:D567,\">0\"))","v":566},"RBLOXHUBNO"]
["RBLOCITYKEY","RBLOCITYKEY - Overide key",12,1,{"$f":"IF(D568=0,\"\",COUNTIF($D$2:D568,\">0\"))","v":567},"RBLOCITYKEY"]
["TONE6BTRAN","TONE6BTRAN - transformer for TONE6B",245,1,{"$f":"IF(D569=0,\"\",COUNTIF($D$2:D569,\">0\"))","v":568},"TONE6BTRAN"]
["CITYRHARM","CITYRHARM - Right hand CITY arm with hook.",318,1,{"$f":"IF(D570=0,\"\",COUNTIF($D$2:D570,\">0\"))","v":569},"CITYRHARM"]
["CITYLHARM","CITYLHARM - Left hand CITY arm.",187,1,{"$f":"IF(D571=0,\"\",COUNTIF($D$2:D571,\">0\"))","v":570},"CITYLHARM"]
["CITYMOTBOX","CITYMOTBOX - CITY motor and gearbox assembly",1422,1,{"$f":"IF(D572=0,\"\",COUNTIF($D$2:D572,\">0\"))","v":571},"CITYMOTBOX"]
["LUXEMOTBOX","LUXEMOTBOX - Motor & Gearbox Assembly",1611,1,{"$f":"IF(D573=0,\"\",COUNTIF($D$2:D573,\">0\"))","v":572},"LUXEMOTBOX"]
["RBLOHUBBUSH","RBLOHUBBUSH - Hub with bush and connecting rod",209,1,{"$f":"IF(D574=0,\"\",COUNTIF($D$2:D574,\">0\"))","v":573},"RBLOHUBBUSH"]
["RBLOHUBNOBUSH","RBLOHUBNOBUSH - Hub without bush",42,1,{"$f":"IF(D575=0,\"\",COUNTIF($D$2:D575,\">0\"))","v":574},"RBLOHUBNOBUSH"]
["RBLOXTRANS","RBLOXTRANS - Transformer for RBLOX",228,1,{"$f":"IF(D576=0,\"\",COUNTIF($D$2:D576,\">0\"))","v":575},"RBLOXTRANS"]
["TAUENCDISC","TAUENCDISC - TAU encoder disc",23,1,{"$f":"IF(D577=0,\"\",COUNTIF($D$2:D577,\">0\"))","v":576},"TAUENCDISC"]
["TAUKEYBARREL","TAUKEYBARREL - TAU Key and barrel",38,1,{"$f":"IF(D578=0,\"\",COUNTIF($D$2:D578,\">0\"))","v":577},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D577),E:E,0)),\"\")","v":"TAUKEYBARREL"}]
["LUXELIMITSTOP","LUXELIMITSTOP - Stop for LUXE",26,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A579),0)","v":1},{"$f":"IF(D579=0,\"\",COUNTIF($D$2:D579,\">0\"))","v":578},"LUXELIMITSTOP"]
["MASTERKITFC","MASTERKITFC - Limit switch kit for K128MA and K130MA",74,1,{"$f":"IF(D580=0,\"\",COUNTIF($D$2:D580,\">0\"))","v":579},"MASTERKITFC"]
["PCBK125","PCBK125 - PCB for TONE6B",479,1,{"$f":"IF(D581=0,\"\",COUNTIF($D$2:D581,\">0\"))","v":580},"PCBK125"]
["TONE5E8COVER","TONE5E8COVER - Cover for TONE5E and TONE8",65,1,{"$f":"IF(D582=0,\"\",COUNTIF($D$2:D582,\">0\"))","v":581},"TONE5E8COVER"]
["TONE6B10BCOVER","TONE6B10BCOVER - Cover for TONE6B and TONE10B",81,1,{"$f":"IF(D583=0,\"\",COUNTIF($D$2:D583,\">0\"))","v":582},"TONE6B10BCOVER"]
["PCB206MA","PCB206MA - PCB for LUXE",451,1,{"$f":"IF(D584=0,\"\",COUNTIF($D$2:D584,\">0\"))","v":583},"PCB206MA"]
["RBLOXHUBBUSH","RBLOXHUBBUSH - RBLOX hub with bush",140,1,{"$f":"IF(D585=0,\"\",COUNTIF($D$2:D585,\">0\"))","v":584},"RBLOXHUBBUSH"]
["RBLOXSHAFT","RBLOXSHAFT - RBLOX internal gears and shaft",205,1,{"$f":"IF(D586=0,\"\",COUNTIF($D$2:D586,\">0\"))","v":585},"RBLOXSHAFT"]
["LUXEHUBBUSH","LUXEHUBBUSH - LUXE hub with bush",152,1,{"$f":"IF(D587=0,\"\",COUNTIF($D$2:D587,\">0\"))","v":586},"LUXEHUBBUSH"]
["LUXEHUBNO","LUXEHUBNO - LUXE hub without bush",104,1,{"$f":"IF(D588=0,\"\",COUNTIF($D$2:D588,\">0\"))","v":587},"LUXEHUBNO"]
["LUXEPANELSUPP","LUXEPANELSUPP - Panel support for LUXE",102,1,{"$f":"IF(D589=0,\"\",COUNTIF($D$2:D589,\">0\"))","v":588},"LUXEPANELSUPP"]
["LUXETOPCOVER","LUXETOPCOVER - Top cover for LUXE",211,1,{"$f":"IF(D590=0,\"\",COUNTIF($D$2:D590,\">0\"))","v":589},"LUXETOPCOVER"]
["MASTER20TRAN","MASTER20TRAN - Transformer for MASTER20",146,1,{"$f":"IF(D591=0,\"\",COUNTIF($D$2:D591,\">0\"))","v":590},"MASTER20TRAN"]
["PCBK101M","PCBK101M - PCB for RBLOE",352,1,{"$f":"IF(D592=0,\"\",COUNTIF($D$2:D592,\">0\"))","v":591},"PCBK101M"]
["TAUHUBCOVER","TAUHUBCOVER - Plastic boom hub cover for RBLOX and LUXE",169,1,{"$f":"IF(D593=0,\"\",COUNTIF($D$2:D593,\">0\"))","v":592},"TAUHUBCOVER"]
["AEBOOMCAP","AEBOOMCAP - Cap for AE3BOOM and AE4BOOM",24,1,{"$f":"IF(D594=0,\"\",COUNTIF($D$2:D594,\">0\"))","v":593},"AEBOOMCAP"]
["TAUWIFIPLUG","TAUWIFIPLUG - Installers plug in program module",161,1,{"$f":"IF(D595=0,\"\",COUNTIF($D$2:D595,\">0\"))","v":594},"TAUWIFIPLUG"]
["TAUPCBCOVER","TAUPCBCOVER - Cover for Diamond series control boards",71,1,{"$f":"IF(D596=0,\"\",COUNTIF($D$2:D596,\">0\"))","v":595},"TAUPCBCOVER"]
["TONELIMITSPRING","TONELIMITSPRING - Limit spring for TONE operators",26,1,{"$f":"IF(D597=0,\"\",COUNTIF($D$2:D597,\">0\"))","v":596},"TONELIMITSPRING"]
["RBLOMOTOR","RBLOMOTOR - RBLO motor only",634,1,{"$f":"IF(D598=0,\"\",COUNTIF($D$2:D598,\">0\"))","v":597},"RBLOMOTOR"]
["TAUBOOMMAG","TAUBOOMMAG - Magnetic lock for TAU Boom support",446,1,{"$f":"IF(D599=0,\"\",COUNTIF($D$2:D599,\">0\"))","v":598},"TAUBOOMMAG"]
["PCBD703","PCBD703 - PCB for BIG18",560,1,{"$f":"IF(D600=0,\"\",COUNTIF($D$2:D600,\">0\"))","v":599},"PCBD703"]
["MASTER20SPRING","MASTER20SPRING - limit switch spring for MASTER20",23,1,{"$f":"IF(D601=0,\"\",COUNTIF($D$2:D601,\">0\"))","v":600},"MASTER20SPRING"]
["MASTER18TRAN","MASTER18TRAN - transformer for MASTER18",254,1,{"$f":"IF(D602=0,\"\",COUNTIF($D$2:D602,\">0\"))","v":601},"MASTER18TRAN"]
["TONE10BTRAN","TONE10BTRAN - transformer for TONE10B",203,1,{"$f":"IF(D603=0,\"\",COUNTIF($D$2:D603,\">0\"))","v":602},"TONE10BTRAN"]
["LUXERELEASE","LUXERELEASE - Boom release lever for LUXE",107,1,{"$f":"IF(D604=0,\"\",COUNTIF($D$2:D604,\">0\"))","v":603},"LUXERELEASE"]
["LUXETRAN","LUXETRAN - transformer for LUXE",282,1,{"$f":"IF(D605=0,\"\",COUNTIF($D$2:D605,\">0\"))","v":604},"LUXETRAN"]
["RBLOXTOPCOVER","RBLOXTOPCOVER - Top cover for RBLOX",96,1,{"$f":"IF(D606=0,\"\",COUNTIF($D$2:D606,\">0\"))","v":605},"RBLOXTOPCOVER"]
["RBLOEDOOR","RBLOEDOOR - Door for RBLOE",249,1,{"$f":"IF(D607=0,\"\",COUNTIF($D$2:D607,\">0\"))","v":606},"RBLOEDOOR"]
["TAULIMITACTLH","TAULIMITACTLH - Left hand TAU slider limit actuator",53,1,{"$f":"IF(D608=0,\"\",COUNTIF($D$2:D608,\">0\"))","v":607},"TAULIMITACTLH"]
["TAULIMITACTRH","TAULIMITACTRH - Right hand TAU slider limit actuator",53,1,{"$f":"IF(D609=0,\"\",COUNTIF($D$2:D609,\">0\"))","v":608},"TAULIMITACTRH"]
["TAULEDCOVER2M","TAULEDCOVER2M - Two metre length of boom LED cover``",26,1,{"$f":"IF(D610=0,\"\",COUNTIF($D$2:D610,\">0\"))","v":609},"TAULEDCOVER2M"]
["PCBD749","PCBD749 - PCB for LOGICTAUD749MA",432,1,{"$f":"IF(D611=0,\"\",COUNTIF($D$2:D611,\">0\"))","v":610},"PCBD749"]
["TAUD749TRAN","TAUD749TRAN - D749 transformer",182,1,{"$f":"IF(D612=0,\"\",COUNTIF($D$2:D612,\">0\"))","v":611},"TAUD749TRAN"]
["ARM290RELGRP","ARM290RELGRP - ARM290 release group of gears",141,1,{"$f":"IF(D613=0,\"\",COUNTIF($D$2:D613,\">0\"))","v":612},"ARM290RELGRP"]
["ARM290MOTOR","ARM290MOTOR - ARM290 motor",563,1,{"$f":"IF(D614=0,\"\",COUNTIF($D$2:D614,\">0\"))","v":613},"ARM290MOTOR"]
["ARM290SHAFT","ARM290SHAFT - ARM290 shaft complete",679,1,{"$f":"IF(D615=0,\"\",COUNTIF($D$2:D615,\">0\"))","v":614},"ARM290SHAFT"]
["ARM290COVER","ARM290COVER - ARM290 shaft cover",170,1,{"$f":"IF(D616=0,\"\",COUNTIF($D$2:D616,\">0\"))","v":615},"ARM290COVER"]
["ARM290COVEREND","ARM290COVEREND - ARM290 shaft cover end cap",41,1,{"$f":"IF(D617=0,\"\",COUNTIF($D$2:D617,\">0\"))","v":616},"ARM290COVEREND"]
["ARM290MOTSHELL","ARM290MOTSHELL - ARM290 top and bottom motor shell",255,1,{"$f":"IF(D618=0,\"\",COUNTIF($D$2:D618,\">0\"))","v":617},"ARM290MOTSHELL"]
["ARM290RELLEVER","ARM290RELLEVER - ARM290 release lever",60,1,{"$f":"IF(D619=0,\"\",COUNTIF($D$2:D619,\">0\"))","v":618},"ARM290RELLEVER"]
["ARM290POSTBRAC","ARM290POSTBRAC - ARM weld on post bracket",26,1,{"$f":"IF(D620=0,\"\",COUNTIF($D$2:D620,\">0\"))","v":619},"ARM290POSTBRAC"]
["RBLOENCBASE","RBLOENCBASE - Base for RBLO encoder",26,1,{"$f":"IF(D621=0,\"\",COUNTIF($D$2:D621,\">0\"))","v":620},"RBLOENCBASE"]
["RBLOENCCOVER","RBLOENCCOVER - Cover for RBLO encoder",26,1,{"$f":"IF(D622=0,\"\",COUNTIF($D$2:D622,\">0\"))","v":621},"RBLOENCCOVER"]
["PCBD820M","PCBD820M - PCB for BIG40QI",1342,1,{"$f":"IF(D623=0,\"\",COUNTIF($D$2:D623,\">0\"))","v":622},"PCBD820M"]
["ARM290GATEBRAC","ARM290GATEBRAC - ARM bolt on gate bracket",26,1,{"$f":"IF(D624=0,\"\",COUNTIF($D$2:D624,\">0\"))","v":623},"ARM290GATEBRAC"]
["BIG40LIMITSWITCH","BIG40LIMITSWITCH - Limit switch for BIG40",149,1,{"$f":"IF(D625=0,\"\",COUNTIF($D$2:D625,\">0\"))","v":624},"BIG40LIMITSWITCH"]
["LUXE3BOOMHUB","LUXE3BOOMHUB - Boom hub and cover for LUXE3",138,1,{"$f":"IF(D626=0,\"\",COUNTIF($D$2:D626,\">0\"))","v":625},"LUXE3BOOMHUB"]
["CONSUMABLES","CONSUMABLES -",0,1,{"$f":"IF(D627=0,\"\",COUNTIF($D$2:D627,\">0\"))","v":626},"CONSUMABLES"]
["DCTODCM015N","DCTODCM015N",58,1,{"$f":"IF(D628=0,\"\",COUNTIF($D$2:D628,\">0\"))","v":627},"DCTODCM015N"]
["PCBMOUNT","PCBMOUNT - 8mm PCB mount",1.7000000000000002,1,{"$f":"IF(D629=0,\"\",COUNTIF($D$2:D629,\">0\"))","v":628},"PCBMOUNT"]
["CABLEGLAND20","CABLEGLAND20 - 20mm cable gland",2.9000000000000004,1,{"$f":"IF(D630=0,\"\",COUNTIF($D$2:D630,\">0\"))","v":629},"CABLEGLAND20"]
["2CORE3MM","2CORE3MM - 100 metre roll 3mm twin low voltage cable",219.60000000000002,1,{"$f":"IF(D631=0,\"\",COUNTIF($D$2:D631,\">0\"))","v":630},"2CORE3MM"]
["2CORE5MM","2CORE5MM - 100 metre roll 5mm twin low voltage cable",523.20000000000005,1,{"$f":"IF(D632=0,\"\",COUNTIF($D$2:D632,\">0\"))","v":631},"2CORE5MM"]
["5CORECABLE","5CORECABLE - 100 metre roll 3mm five core low voltage cable",533.70000000000005,1,{"$f":"IF(D633=0,\"\",COUNTIF($D$2:D633,\">0\"))","v":632},"5CORECABLE"]
["LOOPCABLE100M","LOOPCABLE100M - Single Core loop Detector Cable - 100 mtrs",160.70000000000002,1,{"$f":"IF(D634=0,\"\",COUNTIF($D$2:D634,\">0\"))","v":633},"LOOPCABLE100M"]
["LOOPCABLE500M","LOOPCABLE500M - Single Core loop Detector Cable - 500 mtrs",803.2,1,{"$f":"IF(D635=0,\"\",COUNTIF($D$2:D635,\">0\"))","v":634},"LOOPCABLE500M"]
["POWER4CORE","POWER4CORE - 100 metre roll 4 core mains voltage flex cable",566.9,1,{"$f":"IF(D636=0,\"\",COUNTIF($D$2:D636,\">0\"))","v":635},"POWER4CORE"]
["PLUGLEAD","PLUGLEAD  3 Pin moulded lead ",13.8,1,{"$f":"IF(D637=0,\"\",COUNTIF($D$2:D637,\">0\"))","v":636},"PLUGLEAD"]
["4COREALARM","4COREALARM - 4 Core Cable - 14/020 100 metre roll",132,1,{"$f":"IF(D638=0,\"\",COUNTIF($D$2:D638,\">0\"))","v":637},"4COREALARM"]
["6CORESHIELDED","6CORESHIELDED  6 Core Cable - 7/020 Shielded 100mtr roll",147.70000000000002,1,{"$f":"IF(D639=0,\"\",COUNTIF($D$2:D639,\">0\"))","v":638},"6CORESHIELDED"]
["DCPLUGPAK","DCPLUGPACK - 12 volt dc 1500mA plugpak",74.5,1,{"$f":"IF(D640=0,\"\",COUNTIF($D$2:D640,\">0\"))","v":639},"DCPLUGPAK"]
["CM90","CM90 - professional grade power surge and filter protector",513,1,{"$f":"IF(D641=0,\"\",COUNTIF($D$2:D641,\">0\"))","v":640},"CM90"]
["ACPLUGPAK","ACPLUGPAK - 16 volt 1500mA AC Plug pak",46,1,{"$f":"IF(D642=0,\"\",COUNTIF($D$2:D642,\">0\"))","v":641},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D641),E:E,0)),\"\")","v":"ACPLUGPAK"}]
["POWCONV","POWCONV - 16-28 volt AC or DC convertor to 12 volt DC",27,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A643),0)","v":1},{"$f":"IF(D643=0,\"\",COUNTIF($D$2:D643,\">0\"))","v":642},"POWCONV"]
["PS12VDC3A","PS12VDC3A - 3.0 amp 12 volt dc power supply",106,1,{"$f":"IF(D644=0,\"\",COUNTIF($D$2:D644,\">0\"))","v":643},"PS12VDC3A"]
["7DAYTIMER","7DAYTIMER - 12volt 24 hour 7 day timer relay",61,1,{"$f":"IF(D645=0,\"\",COUNTIF($D$2:D645,\">0\"))","v":644},"7DAYTIMER"]
["RELAY12","RELAY12 - 12 volt single relay module",67,1,{"$f":"IF(D646=0,\"\",COUNTIF($D$2:D646,\">0\"))","v":645},"RELAY12"]
["RELAY24","RELAY24 - 24 volt single relay module",67,1,{"$f":"IF(D647=0,\"\",COUNTIF($D$2:D647,\">0\"))","v":646},"RELAY24"]
["TIMERRELAY","TIMERRELAY",104,1,{"$f":"IF(D648=0,\"\",COUNTIF($D$2:D648,\">0\"))","v":647},"TIMERRELAY"]
["CAPACITOR8UF","CAPACITOR8UF - Capacitor 8uF",34,1,{"$f":"IF(D649=0,\"\",COUNTIF($D$2:D649,\">0\"))","v":648},"CAPACITOR8UF"]
["CAPACITOR10UF","CAPACITOR10UF - Capacitor 10uF",35,1,{"$f":"IF(D650=0,\"\",COUNTIF($D$2:D650,\">0\"))","v":649},"CAPACITOR10UF"]
["CAPACITOR12UF","CAPACITOR12UF - Capacitor 12uF",39,1,{"$f":"IF(D651=0,\"\",COUNTIF($D$2:D651,\">0\"))","v":650},"CAPACITOR12UF"]
["CAPACITOR16UF","CAPACITOR16UF - Capacitor 16uF",44,1,{"$f":"IF(D652=0,\"\",COUNTIF($D$2:D652,\">0\"))","v":651},"CAPACITOR16UF"]
["SEAPARTS","SEAPARTS",0,1,{"$f":"IF(D653=0,\"\",COUNTIF($D$2:D653,\">0\"))","v":652},"SEAPARTS"]
["MERCRELEASE","MERCRELEASE - Release lever with lock and keys for Mercury",132,1,{"$f":"IF(D654=0,\"\",COUNTIF($D$2:D654,\">0\"))","v":653},"MERCRELEASE"]
["SEATANKSWIVEL","SEATANKSWIVEL - rear swivel bracket for fulltank",90,1,{"$f":"IF(D655=0,\"\",COUNTIF($D$2:D655,\">0\"))","v":654},"SEATANKSWIVEL"]
["PCBGATE1DG240","PCBGATE1DG240 - Logic control board for SEA sliders ",595,1,{"$f":"IF(D656=0,\"\",COUNTIF($D$2:D656,\">0\"))","v":655},"PCBGATE1DG240"]
["PCBUSER124V","PCBUSER124V - Logic control board for SEA sliders and barriers",507,1,{"$f":"IF(D657=0,\"\",COUNTIF($D$2:D657,\">0\"))","v":656},"PCBUSER124V"]
["MERC800MOTOR","MERC800MOTOR - Motor for Mercury 800",533,1,{"$f":"IF(D658=0,\"\",COUNTIF($D$2:D658,\">0\"))","v":657},"MERC800MOTOR"]
["MERC400MOTOR","MERC400MOTOR - Motor for Mercury 400",284,1,{"$f":"IF(D659=0,\"\",COUNTIF($D$2:D659,\">0\"))","v":658},"MERC400MOTOR"]
["MERCLIMITASS","MERCLIMITASS - Limit assembly for MERCURY",109,1,{"$f":"IF(D660=0,\"\",COUNTIF($D$2:D660,\">0\"))","v":659},"MERCLIMITASS"]
["MERCDOGGEAR","MERCDOGGEAR - Dog gear for MERCURY",102,1,{"$f":"IF(D661=0,\"\",COUNTIF($D$2:D661,\">0\"))","v":660},"MERCDOGGEAR"]
["MERCLOCKKEY","MERCLOCKKEY - Lock and keys for MERCURY",48,1,{"$f":"IF(D662=0,\"\",COUNTIF($D$2:D662,\">0\"))","v":661},"MERCLOCKKEY"]
["MERC400TRAN","MERC400TRAN - Transformer for MERCURY400",129,1,{"$f":"IF(D663=0,\"\",COUNTIF($D$2:D663,\">0\"))","v":662},"MERC400TRAN"]
["BENINCAPARTS","BENINCAPARTS",0,1,{"$f":"IF(D664=0,\"\",COUNTIF($D$2:D664,\">0\"))","v":663},"BENINCAPARTS"]
["PCBBULL","PCBBULL - PCB for BULL 424 & 624",382,1,{"$f":"IF(D665=0,\"\",COUNTIF($D$2:D665,\">0\"))","v":664},"PCBBULL"]
["BULLCOVER","BULLCOVER - Cover for BULL 424 & 624",81,1,{"$f":"IF(D666=0,\"\",COUNTIF($D$2:D666,\">0\"))","v":665},"BULLCOVER"]
["BULLLIMITACT","BULLLIMITACT - Limit actuator set for BULL 424 & 624",100,1,{"$f":"IF(D667=0,\"\",COUNTIF($D$2:D667,\">0\"))","v":666},"BULLLIMITACT"]
["BULLRELEASE","BULLRELEASE - Manual release lever for BULL ",82,1,{"$f":"IF(D668=0,\"\",COUNTIF($D$2:D668,\">0\"))","v":667},"BULLRELEASE"]
["BULLLIMITSWITCH","BULLLIMITSWITCH - Limit assembly for BULL 424 & 624",71,1,{"$f":"IF(D669=0,\"\",COUNTIF($D$2:D669,\">0\"))","v":668},"BULLLIMITSWITCH"]
["BULLPINIONGEAR","BULLPINIONGEAR - Pinion gear for BULL 424 & 624",98,1,{"$f":"IF(D670=0,\"\",COUNTIF($D$2:D670,\">0\"))","v":669},"BULLPINIONGEAR"]
["BULL624MOTOR","BULL624MOTOR - Motor for BULL624",408,1,{"$f":"IF(D671=0,\"\",COUNTIF($D$2:D671,\">0\"))","v":670},"BULL624MOTOR"]
["BULL424MOTOR","BULL424MOTOR - Motor for BULL424",268,1,{"$f":"IF(D672=0,\"\",COUNTIF($D$2:D672,\">0\"))","v":671},"BULL424MOTOR"]
["BISON25INVERTER","BISON25INVERTER - Inverter for BISON25",1106,1,{"$f":"IF(D673=0,\"\",COUNTIF($D$2:D673,\">0\"))","v":672},"BISON25INVERTER"]
["BISON25INVFAN","BISON25INVFAN - Inverter fan for BISON25",198,1,{"$f":"IF(D674=0,\"\",COUNTIF($D$2:D674,\">0\"))","v":673},"BISON25INVFAN"]
["BISONLIMITSW","BISONLIMITSW - Limit switch for BISON",96,1,{"$f":"IF(D675=0,\"\",COUNTIF($D$2:D675,\">0\"))","v":674},"BISONLIMITSW"]
["BISONENCODER","BISONENCODER - Encoder for BISON",83,1,{"$f":"IF(D676=0,\"\",COUNTIF($D$2:D676,\">0\"))","v":675},"BISONENCODER"]
["BISONLOCK","BISONLOCK - Keylock for BISON",45,1,{"$f":"IF(D677=0,\"\",COUNTIF($D$2:D677,\">0\"))","v":676},"BISONLOCK"]
["BISON25RELEASE","BISON25RELEASE - Release assembly for BISON25",386,1,{"$f":"IF(D678=0,\"\",COUNTIF($D$2:D678,\">0\"))","v":677},"BISON25RELEASE"]
["BISONPINION","BISONPINION - Pinion gear for BISON",69,1,{"$f":"IF(D679=0,\"\",COUNTIF($D$2:D679,\">0\"))","v":678},"BISONPINION"]
["BISON25LIMITACT","BISON25LIMITACT - Limit actuator pair for BISON25",140,1,{"$f":"IF(D680=0,\"\",COUNTIF($D$2:D680,\">0\"))","v":679},"BISON25LIMITACT"]
["BISON35LIMITACT","BISON35LIMITACT - Limit actuator pair for BISON35",210,1,{"$f":"IF(D681=0,\"\",COUNTIF($D$2:D681,\">0\"))","v":680},"BISON35LIMITACT"]
["BISON35RELEASE","BISON35RELEASE - Release assembly for BISON35",481,1,{"$f":"IF(D682=0,\"\",COUNTIF($D$2:D682,\">0\"))","v":681},"BISON35RELEASE"]
["BISON35INVERTER","BISON35INVERTER - Inverter for BISON35",2225,1,{"$f":"IF(D683=0,\"\",COUNTIF($D$2:D683,\">0\"))","v":682},"BISON35INVERTER"]
["BISON35INVFAN","BISON35INVFAN - Inverter fan for BISON35",198,1,{"$f":"IF(D684=0,\"\",COUNTIF($D$2:D684,\">0\"))","v":683},"BISON35INVFAN"]
["PCBBISON","PCBBISON - PCB for BISON",1042,1,{"$f":"IF(D685=0,\"\",COUNTIF($D$2:D685,\">0\"))","v":684},"PCBBISON"]
["MBCOVER","MBCOVER - Cover for MB actuator",96,1,{"$f":"IF(D686=0,\"\",COUNTIF($D$2:D686,\">0\"))","v":685},"MBCOVER"]
["MBMOTOR","MBMOTOR - Motor for MB Actuator",305,1,{"$f":"IF(D687=0,\"\",COUNTIF($D$2:D687,\">0\"))","v":686},"MBMOTOR"]
["MBRELEASE","MBRELEASE - Release lever for MB actuator",51,1,{"$f":"IF(D688=0,\"\",COUNTIF($D$2:D688,\">0\"))","v":687},"MBRELEASE"]
["PRCOVER","PRCOVER - Cover for PR actuator",81,1,{"$f":"IF(D689=0,\"\",COUNTIF($D$2:D689,\">0\"))","v":688},"PRCOVER"]
["PRMOTOR","PRMOTOR - Motor for PR Actuator",548,1,{"$f":"IF(D690=0,\"\",COUNTIF($D$2:D690,\">0\"))","v":689},"PRMOTOR"]
["PRRELEASE","PRRELEASE - Release lever for PR actuator",61,1,{"$f":"IF(D691=0,\"\",COUNTIF($D$2:D691,\">0\"))","v":690},"PRRELEASE"]
["BULL1524COVER","BULL1524COVER - Cover for BULL1524",119,1,{"$f":"IF(D692=0,\"\",COUNTIF($D$2:D692,\">0\"))","v":691},"BULL1524COVER"]
["BULL1524PCB","BULL1524PCB - Logic control board for BULL1524",800,1,{"$f":"IF(D693=0,\"\",COUNTIF($D$2:D693,\">0\"))","v":692},"BULL1524PCB"]
["BULL1524MOTOR","BULL1524MOTOR -Motor for BULL1524",1174,1,{"$f":"IF(D694=0,\"\",COUNTIF($D$2:D694,\">0\"))","v":693},"BULL1524MOTOR"]
["BOB3024WORM","BOB3024WORM - BOB3024 worm with gear and bearing",205,1,{"$f":"IF(D695=0,\"\",COUNTIF($D$2:D695,\">0\"))","v":694},"BOB3024WORM"]
["BOB3024CARRIAGE","BOB3024CARRIAGE - BOB3024 carriage",105,1,{"$f":"IF(D696=0,\"\",COUNTIF($D$2:D696,\">0\"))","v":695},"BOB3024CARRIAGE"]
["BOB2124RELEASE","BOB2124RELEASE - Manual release key for BOB2124",49,1,{"$f":"IF(D697=0,\"\",COUNTIF($D$2:D697,\">0\"))","v":696},"BOB2124RELEASE"]
["EVA8BOOMHUB","EVA8BOOMHUB - Boom hub for EVA8",169,1,{"$f":"IF(D698=0,\"\",COUNTIF($D$2:D698,\">0\"))","v":697},"EVA8BOOMHUB"]
["EVA8HUBCOVER","EVA8HUBCOVER - Cover for EVA8 boom hub",61,1,{"$f":"IF(D699=0,\"\",COUNTIF($D$2:D699,\">0\"))","v":698},"EVA8HUBCOVER"]
["PCBEVA8","PCBEVA8 - PCB for EVA8",620,1,{"$f":"IF(D700=0,\"\",COUNTIF($D$2:D700,\">0\"))","v":699},"PCBEVA8"]
["EVA8LIGHTCOVER","EVA8LIGHTCOVER - Light cover for EVA8",51,1,{"$f":"IF(D701=0,\"\",COUNTIF($D$2:D701,\">0\"))","v":700},"EVA8LIGHTCOVER"]
["EVA8TOPCOVER","EVA8TOPCOVER - Top cover for EVA8",231,1,{"$f":"IF(D702=0,\"\",COUNTIF($D$2:D702,\">0\"))","v":701},"EVA8TOPCOVER"]
["EVA8RELEASE","EVA8RELEASE - Release assembly for EVA8",306,1,{"$f":"IF(D703=0,\"\",COUNTIF($D$2:D703,\">0\"))","v":702},"EVA8RELEASE"]
["EVA8ENCODER","EVA8ENCODER - Encoder assembly for EVA8",265,1,{"$f":"IF(D704=0,\"\",COUNTIF($D$2:D704,\">0\"))","v":703},"EVA8ENCODER"]
["EVA8TRANROD","EVA8TRANROD - Transmission rod for EVA8",178,1,{"$f":"IF(D705=0,\"\",COUNTIF($D$2:D705,\">0\"))","v":704},"EVA8TRANROD"]
["EVA8MOTBOX","EVA8MOTBOX -Motor and gearbox for EVA8",1948,1,{"$f":"IF(D706=0,\"\",COUNTIF($D$2:D706,\">0\"))","v":705},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D705),E:E,0)),\"\")","v":"EVA8MOTBOX"}]
["EVA8SPRINGLGE","EVA8SPRINGLGE -Large spring for EVA8",202,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A707),0)","v":1},{"$f":"IF(D707=0,\"\",COUNTIF($D$2:D707,\">0\"))","v":706},"EVA8SPRINGLGE"]
["EVA8SPRINGSML","EVA8SPRINGSML -Small spring for EVA8",143,1,{"$f":"IF(D708=0,\"\",COUNTIF($D$2:D708,\">0\"))","v":707},"EVA8SPRINGSML"]
["EVA8SPRINGRODS","EVA8SPRINGRODS -Six threaded rods for EVA8 springs",250,1,{"$f":"IF(D709=0,\"\",COUNTIF($D$2:D709,\">0\"))","v":708},"EVA8SPRINGRODS"]
["EVA8SPRINGHEAD","EVA8SPRINGHEAD -Articulated head for EVA8 springs",38,1,{"$f":"IF(D710=0,\"\",COUNTIF($D$2:D710,\">0\"))","v":709},"EVA8SPRINGHEAD"]
["LOGICBEAUTY","LOGICBEAUTY - BEAUTY logic control board",590,1,{"$f":"IF(D711=0,\"\",COUNTIF($D$2:D711,\">0\"))","v":710},"LOGICBEAUTY"]
["BOB2124STOP","BOB2124STOP - Mechanical stop for BOB2124",45,1,{"$f":"IF(D712=0,\"\",COUNTIF($D$2:D712,\">0\"))","v":711},"BOB2124STOP"]
["BEAUTYKEY","BEAUTYKEY - Manual release key for BEAUTY",27,1,{"$f":"IF(D713=0,\"\",COUNTIF($D$2:D713,\">0\"))","v":712},"BEAUTYKEY"]
["BEAUTYSTOP","BEAUTYSTOP - Mechanical stop for BEAUTY",33,1,{"$f":"IF(D714=0,\"\",COUNTIF($D$2:D714,\">0\"))","v":713},"BEAUTYSTOP"]
["BEAUTYCARRIAGE","BEAUTYCARRIAGE - Carriage for BEAUTY",69,1,{"$f":"IF(D715=0,\"\",COUNTIF($D$2:D715,\">0\"))","v":714},"BEAUTYCARRIAGE"]
["BOB2124CARRIAGE","BOB2124CARRIAGE - Carriage for BOB2124",71,1,{"$f":"IF(D716=0,\"\",COUNTIF($D$2:D716,\">0\"))","v":715},"BOB2124CARRIAGE"]
["BULLTRANS","BULLTRANS - Transformer for BULL 424 & 624",172,1,{"$f":"IF(D717=0,\"\",COUNTIF($D$2:D717,\">0\"))","v":716},"BULLTRANS"]
["PCBBRAINY","PCBBRAINY - PCB for BRAINY",504,1,{"$f":"IF(D718=0,\"\",COUNTIF($D$2:D718,\">0\"))","v":717},"PCBBRAINY"]
["BENINCASM120","BENINCASM120 - Switch mode power supply (SA.24)",336,1,{"$f":"IF(D719=0,\"\",COUNTIF($D$2:D719,\">0\"))","v":718},"BENINCASM120"]
["BENINCASM200","BENINCASM200 - Switch mode power supply (SAR.24)",391,1,{"$f":"IF(D720=0,\"\",COUNTIF($D$2:D720,\">0\"))","v":719},"BENINCASM200"]
["EVA8BOOMCAP","EVA8BOOMCAP - Boom cap for EVA8",16,1,{"$f":"IF(D721=0,\"\",COUNTIF($D$2:D721,\">0\"))","v":720},"EVA8BOOMCAP"]
["BEAUTYSINGLE","BEAUTYSINGLE - Single Beauty operator",357,1,{"$f":"IF(D722=0,\"\",COUNTIF($D$2:D722,\">0\"))","v":721},"BEAUTYSINGLE"]
["BAARMS","BAARMS - Single set of MB articulated arms",214,1,{"$f":"IF(D723=0,\"\",COUNTIF($D$2:D723,\">0\"))","v":722},"BAARMS"]
["DU.32ARMS","DU.32ARMS - Single set of PR articulated arms",284,1,{"$f":"IF(D724=0,\"\",COUNTIF($D$2:D724,\">0\"))","v":723},"DU.32ARMS"]
["PCBBULL624TURBO","PCBBULL624TURBO - Logic control for BULL624TURBO",903,1,{"$f":"IF(D725=0,\"\",COUNTIF($D$2:D725,\">0\"))","v":724},"PCBBULL624TURBO"]
["BULL624TURBMOT","BULL624TURBMOT - Motor for BULL624TURBO",541,1,{"$f":"IF(D726=0,\"\",COUNTIF($D$2:D726,\">0\"))","v":725},"BULL624TURBMOT"]
["BULL624TURBPIN","BULL624TURBPIN - Pinion gear for BULL624TURBO",82,1,{"$f":"IF(D727=0,\"\",COUNTIF($D$2:D727,\">0\"))","v":726},"BULL624TURBPIN"]
["BULL624TURBREL","BULL624TURBREL - Release assembly for BULL624TURBO",126,1,{"$f":"IF(D728=0,\"\",COUNTIF($D$2:D728,\">0\"))","v":727},"BULL624TURBREL"]
["BENINCAKEYBARR","BENINCAKEYBARR - Key & Barrell suit many Beninca",69,1,{"$f":"IF(D729=0,\"\",COUNTIF($D$2:D729,\">0\"))","v":728},"BENINCAKEYBARR"]
["BEAUTYUNLOCK","BEAUTYUNLOCK - Unlock mechanism for BEAUTY",143,1,{"$f":"IF(D730=0,\"\",COUNTIF($D$2:D730,\">0\"))","v":729},"BEAUTYUNLOCK"]
["HD5024GATEBRAC","HD5024GATEBRAC - Gate bracket for HD5024",156,1,{"$f":"IF(D731=0,\"\",COUNTIF($D$2:D731,\">0\"))","v":730},"HD5024GATEBRAC"]
["PRCOVERSUPP","PRCOVERSUPP - Cover support for PR24",59,1,{"$f":"IF(D732=0,\"\",COUNTIF($D$2:D732,\">0\"))","v":731},"PRCOVERSUPP"]
["EVA9HUBSHAFT","EVA8HUBSHAFT - Hub and shaft for EVA8",299,1,{"$f":"IF(D733=0,\"\",COUNTIF($D$2:D733,\">0\"))","v":732},"EVA9HUBSHAFT"]
["BOB5024CARRIAGE","BOB5024CARRIAGE - BOB5024 carriage",134,1,{"$f":"IF(D734=0,\"\",COUNTIF($D$2:D734,\">0\"))","v":733},"BOB5024CARRIAGE"]
["DUITRELEASEKEY","DUITRELEASEKEY - Release handle for DUIT",66,1,{"$f":"IF(D735=0,\"\",COUNTIF($D$2:D735,\">0\"))","v":734},"DUITRELEASEKEY"]
["QUADCOINVALID","QUADCOINVALID - Coin validator for QUAD",860,1,{"$f":"IF(D736=0,\"\",COUNTIF($D$2:D736,\">0\"))","v":735},"QUADCOINVALID"]
["DUITBOXCOVER","DUITBOXCOVER - Foundation box cover for DUIT",202,1,{"$f":"IF(D737=0,\"\",COUNTIF($D$2:D737,\">0\"))","v":736},"DUITBOXCOVER"]
["HD5024SHAFTEND","HD5024SHAFTEND - Bearing end to shaft",67,1,{"$f":"IF(D738=0,\"\",COUNTIF($D$2:D738,\">0\"))","v":737},"HD5024SHAFTEND"]
["HD5024SHAFTSPACE","HD5024SHAFTSPACE - Spacers for bearing end of shaft",93,1,{"$f":"IF(D739=0,\"\",COUNTIF($D$2:D739,\">0\"))","v":738},"HD5024SHAFTSPACE"]
["MBBRACKET","MBBRACKET - Mounting bracket for MB24",93,1,{"$f":"IF(D740=0,\"\",COUNTIF($D$2:D740,\">0\"))","v":739},"MBBRACKET"]
["PCBCPB24SW","PCBCPB24SW - logic control for BULL424SW",396,1,{"$f":"IF(D741=0,\"\",COUNTIF($D$2:D741,\">0\"))","v":740},"PCBCPB24SW"]
["MISC","MISC",0,1,{"$f":"IF(D742=0,\"\",COUNTIF($D$2:D742,\">0\"))","v":741},"MISC"]
["SPECIALTONE5E","SPECIALTONE5E - TONEKIT5E, 4 x RACKNYLON",882.40000000000009,1,{"$f":"IF(D743=0,\"\",COUNTIF($D$2:D743,\">0\"))","v":742},"SPECIALTONE5E"]
["EASYSLIDER","EASYSLIDER - ASA612 with two remotes.",640,1,{"$f":"IF(D744=0,\"\",COUNTIF($D$2:D744,\">0\"))","v":743},"EASYSLIDER"]
["EASYSWINGLH","EASYSWINGLH - ASA60012VLH, LOGIC, 2 x REMGR, ELSLOCK",1177,1,{"$f":"IF(D745=0,\"\",COUNTIF($D$2:D745,\">0\"))","v":744},"EASYSWINGLH"]
["EASYSWINGRH","EASYSWINGRH - ASA60012VRH, LOGIC, 2 x REMGR, ELSLOCK",1177,1,{"$f":"IF(D746=0,\"\",COUNTIF($D$2:D746,\">0\"))","v":745},"EASYSWINGRH"]
["EASYSWINGDBLE","EASYSWINGDBLE - ASA30012V x 2, LOGIC, 2 x REMGR",1348,1,{"$f":"IF(D747=0,\"\",COUNTIF($D$2:D747,\">0\"))","v":746},"EASYSWINGDBLE"]
["SPECIALASA612","SPECIALASA612 - ASA612, 2 x REMGR, 4 x RACK",854.40000000000009,1,{"$f":"IF(D748=0,\"\",COUNTIF($D$2:D748,\">0\"))","v":747},"SPECIALASA612"]
["SPECIALTONE6B","SPECIALTONE6B - TONEKIT6B, 4 x RACK",1125.6000000000001,1,{"$f":"IF(D749=0,\"\",COUNTIF($D$2:D749,\">0\"))","v":748},"SPECIALTONE6B"]
["SPECIALARM","SPECIALARM - ARM250, LOGICTAUM749, REMTAUSLIM x 2",1301.6000000000001,1,{"$f":"IF(D750=0,\"\",COUNTIF($D$2:D750,\">0\"))","v":749},"SPECIALARM"]
["SPECIALTONEXLE","SPECIALTONEXLE - Includes two remotes, four rack and photocells",1060.8,1,{"$f":"IF(D751=0,\"\",COUNTIF($D$2:D751,\">0\"))","v":750},"SPECIALTONEXLE"]
["SPECIALBULL424","SPECIALBULL424 - BULL424, 4 x RACK, 2 REMOTES",951.2,1,{"$f":"IF(D752=0,\"\",COUNTIF($D$2:D752,\">0\"))","v":751},"SPECIALBULL424"]
["SPECIALTONE10B","SPECIALTONE10B - TONEKIT10B, 4 x RACK",1233.6000000000001,1,{"$f":"IF(D753=0,\"\",COUNTIF($D$2:D753,\">0\"))","v":752},"SPECIALTONE10B"]
["SPECIALBOB3024","SPECIALBOB3024 - 2 x BOB3024, LOGIC, 2 x REMBENINCA",2289.6,1,{"$f":"IF(D754=0,\"\",COUNTIF($D$2:D754,\">0\"))","v":753},"SPECIALBOB3024"]
["SPECIALTONE8E","SPECIALTONE8E - Includes two remotes, four rack and photocells",1006.4000000000001,1,{"$f":"IF(D755=0,\"\",COUNTIF($D$2:D755,\">0\"))","v":754},"SPECIALTONE8E"]
["SPECIALRACKSTEEL","SPECIALRACKSTEEL - One metre lengths of heavy duty steel rack",15,1,{"$f":"IF(D756=0,\"\",COUNTIF($D$2:D756,\">0\"))","v":755},"SPECIALRACKSTEEL"]
["EXPOSTLGE","EXPOSTLGE  Express post bag to 5kg",81,1,{"$f":"IF(D757=0,\"\",COUNTIF($D$2:D757,\">0\"))","v":756},"EXPOSTLGE"]
["EXPOSTSML","EXPOSTSML  Express post bag to 3kg",54,1,{"$f":"IF(D758=0,\"\",COUNTIF($D$2:D758,\">0\"))","v":757},"EXPOSTSML"]
["AIREXP3KG","AIREXP3KG  Air Express Bag 3KG",76,1,{"$f":"IF(D759=0,\"\",COUNTIF($D$2:D759,\">0\"))","v":758},"AIREXP3KG"]
["AIREXP5KG","AIREXP5KG  Air Express Bag 5KG",124,1,{"$f":"IF(D760=0,\"\",COUNTIF($D$2:D760,\">0\"))","v":759},"AIREXP5KG"]
["MOVEBLANKET","MOVEBLANKET - 3000x1800 protective blanket",37,1,{"$f":"IF(D761=0,\"\",COUNTIF($D$2:D761,\">0\"))","v":760},"MOVEBLANKET"]
["PALLET60002000","PALLET60002000 - Pallet 6000x2000",526,1,{"$f":"IF(D762=0,\"\",COUNTIF($D$2:D762,\">0\"))","v":761},"PALLET60002000"]
["PALLET11651165","PALLET11651165 - Pallet 1165x1165",75,1,{"$f":"IF(D763=0,\"\",COUNTIF($D$2:D763,\">0\"))","v":762},"PALLET11651165"]
["ADMINFEES","ADMINFEES - Annual licence fees",0,1,{"$f":"IF(D764=0,\"\",COUNTIF($D$2:D764,\">0\"))","v":763},"ADMINFEES"]
["ADVERTISING","ADVERTISING - Quarterly Advertising & Marketing Fees",0,1,{"$f":"IF(D765=0,\"\",COUNTIF($D$2:D765,\">0\"))","v":764},"ADVERTISING"]
["AFTERHOURS","AFTERHOURS - Labour per hour (Minimum four hours)",294,1,{"$f":"IF(D766=0,\"\",COUNTIF($D$2:D766,\">0\"))","v":765},"AFTERHOURS"]
["CABLING","CABLING - As required for installation",0,1,{"$f":"IF(D767=0,\"\",COUNTIF($D$2:D767,\">0\"))","v":766},"CABLING"]
["CONCRETE","CONCRETE - As required for installation",0,1,{"$f":"IF(D768=0,\"\",COUNTIF($D$2:D768,\">0\"))","v":767},"CONCRETE"]
["CUSTOMGATE","CUSTOMGATE - Custom made gate to customer specification",0,1,{"$f":"IF(D769=0,\"\",COUNTIF($D$2:D769,\">0\"))","v":768},"CUSTOMGATE"]
["CUSTOMPANELS","CUSTOMPANELS - Custom made fence panels to specification",0,1,{"$f":"IF(D770=0,\"\",COUNTIF($D$2:D770,\">0\"))","v":769},{"$f":"IFERROR(INDEX(A:A,MATCH(ROW(D769),E:E,0)),\"\")","v":"CUSTOMPANELS"}]
["ELECTRICAL","ELECTRICAL - Electrical work as required",0,{"$f":"IFERROR(SEARCH(INDIRECT(CELL(\"address\")),A771),0)","v":1},{"$f":"IF(D771=0,\"\",COUNTIF($D$2:D771,\">0\"))","v":770},"ELECTRICAL"]
["FACTORYLABOUR","FACTORYLABOUR - Factory labour per hour",118,1,{"$f":"IF(D772=0,\"\",COUNTIF($D$2:D772,\">0\"))","v":771},"FACTORYLABOUR"]
["FREIGHTGATE","FREIGHTGATE - ",0,1,{"$f":"IF(D773=0,\"\",COUNTIF($D$2:D773,\">0\"))","v":772},"FREIGHTGATE"]
["GALV","GALV - Hot dip galvanising",0,1,{"$f":"IF(D774=0,\"\",COUNTIF($D$2:D774,\">0\"))","v":773},"GALV"]
["HANDLING","Fabrication, packing and handling.",0,1,{"$f":"IF(D775=0,\"\",COUNTIF($D$2:D775,\">0\"))","v":774},"HANDLING"]
["INSTALLLABOUR","INSTALLLABOUR - Installation and service labour per hour ",147,1,{"$f":"IF(D776=0,\"\",COUNTIF($D$2:D776,\">0\"))","v":775},"INSTALLLABOUR"]
["KEYTAGS","KEYTAGS - Each",1.1000000000000001,1,{"$f":"IF(D777=0,\"\",COUNTIF($D$2:D777,\">0\"))","v":776},"KEYTAGS"]
["PAINT","PAINT - Finishing as per specifications",0,1,{"$f":"IF(D778=0,\"\",COUNTIF($D$2:D778,\">0\"))","v":777},"PAINT"]
["PAYMENT","PAYMENT - 50% deposit balance due at practical handover",0,1,{"$f":"IF(D779=0,\"\",COUNTIF($D$2:D779,\">0\"))","v":778},"PAYMENT"]
["POSTS","POSTS - Support posts ",0,1,{"$f":"IF(D780=0,\"\",COUNTIF($D$2:D780,\">0\"))","v":779},"POSTS"]
["PRODUCTRETURN","PRODUCTRETURN - Returned product as follows",0,1,{"$f":"IF(D781=0,\"\",COUNTIF($D$2:D781,\">0\"))","v":780},"PRODUCTRETURN"]
["REINFORCETRACK","REINFORCETRACK - RHS reinforcing to sliding gate track permetre",89,1,{"$f":"IF(D782=0,\"\",COUNTIF($D$2:D782,\">0\"))","v":781},"REINFORCETRACK"]
["REPAIRS","REPAIRS - As required",0,1,{"$f":"IF(D783=0,\"\",COUNTIF($D$2:D783,\">0\"))","v":782},"REPAIRS"]
["RESINLABELS","RESINLABELS - Sheet of 28",37,1,{"$f":"IF(D784=0,\"\",COUNTIF($D$2:D784,\">0\"))","v":783},"RESINLABELS"]
["SERVICE","SERVICE - fees including half hour on site",220,1,{"$f":"IF(D785=0,\"\",COUNTIF($D$2:D785,\">0\"))","v":784},"SERVICE"]
["SERVICELABOUR","SERVICELABOUR - Labour per hour",147,1,{"$f":"IF(D786=0,\"\",COUNTIF($D$2:D786,\">0\"))","v":785},"SERVICELABOUR"]
["SPEXPENSES","SPEXPENSES - Special projects expenses per day",1262,1,{"$f":"IF(D787=0,\"\",COUNTIF($D$2:D787,\">0\"))","v":786},"SPEXPENSES"]
["SPTRAVEL","SPTRAVEL - Special projects travel fees",3221,1,{"$f":"IF(D788=0,\"\",COUNTIF($D$2:D788,\">0\"))","v":787},"SPTRAVEL"]
["TRAVELLABOUR","TRAVEL - Labour per hour out of service area",331,1,{"$f":"IF(D789=0,\"\",COUNTIF($D$2:D789,\">0\"))","v":788},"TRAVELLABOUR"]
["WARRANTY","WARRANTY - Site inspect and make warranty repairs only",0,1,{"$f":"IF(D790=0,\"\",COUNTIF($D$2:D790,\">0\"))","v":789},"WARRANTY"]

{"sheet":"Notes","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[" "]
[null,"Quote Page"]
[null,1,"Nothing to change here on a regular basis unless you wish to update terms and conditions."]
[]
[null,2,"If you add or subtract rows there are three macros all refering to different cells which you may affect and need"]
[null,null,"to change"]
[]
[null,"Setup Page"]
[null,1,"No changes necessary."]
[]
[null,"Items Page "]
[null,1,"Each pricebook update requires new data to columns A, B and C. Cut and paste from price list excel file."]
[]
[null,2,"Do not change or remove ROW 1"]
[]
[null,3,"When you update the data in columns A, B and C you need to ensure that columns D, E and F all fill down to the"]
[null,null,"same number of rows as A, B and C. This will ensure the functions continue to work."]