{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input for Auto Config","Labor_Installation","R5K Details","ORDER","order_hack","Revision History","2017","DropDowns"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":1,"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":"Input for Auto Config","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,8],[1,1,1,2],[3,1,3,2],[31,0,31,8],[30,0,30,8],[33,0,33,8],[4,3,4,4],[0,0,0,10],[1,3,1,4],[2,3,2,4],[3,3,3,4],[32,0,32,8]]}
["International Responder 5000 2018 Estimate Sheet v 1.31"]
[null,"Input Config Information",null,"Date:",null,"2018-01-11"]
[null,null,null,"Job Name:",null,"Angol"]
[null,"System Config/Intergrations/Software",null,"Distributor Name:",null,"Cencomex"]
[null,"SIP Telephony Integration (yes or no)","Yes","Salesperson:",null,"Cristian Yañez"]
[null,"Audio Paging to R5K stations in rooms? (yes or no)","Yes"]
[null,"Reporting Software  (yes or no)","Yes"]
[null,"TAP Output to pocket pagers/middleware (yes or no)","Yes"]
[null,"R5K Messaging App (yes or no)","Yes"]
[null,"Number of concurrent users of messaging app"]
[]
[]
[null,"Typical Patient Room Stations/Corridor Lights (Drop Down)","Part Number","Quantity",null,"Typical Patient Room Accessories (Drop Down)","Part Number","Quantity"]
[null,"CLA246 - 4Bulb/1-Point Audio R4K Corridor Light ",{"$f":"IF(B14<>\"\", VLOOKUP(B14, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"CLA246"},142,null,null,{"$f":"IF(F14<>\"\", VLOOKUP(F14,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R5KDC46 - 6-Point, 4-Point Audio Domeless Controller",{"$f":"IF(B15<>\"\", VLOOKUP(B15, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R5KDC46"},218,null,null,{"$f":"IF(F15<>\"\", VLOOKUP(F15,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R5KSDTY -  Duty Station",{"$f":"IF(B16<>\"\", VLOOKUP(B16, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R5KSDTY"},3,null,null,{"$f":"IF(F16<>\"\", VLOOKUP(F16,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R5KDC16D - 6-Point, 1 Point Audio Duty Domeless Controller",{"$f":"IF(B17<>\"\", VLOOKUP(B17, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R5KDC16D"},3,null,null,{"$f":"IF(F17<>\"\", VLOOKUP(F17,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R5KPS1EA - Enhanced Single Station",{"$f":"IF(B18<>\"\", VLOOKUP(B18, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R5KPS1EA"},282,null,null,{"$f":"IF(F18<>\"\", VLOOKUP(F18,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R4KPB23 - SLIM Dual Button w/ Code St",{"$f":"IF(B19<>\"\", VLOOKUP(B19, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R4KPB23"},282,null,null,{"$f":"IF(F19<>\"\", VLOOKUP(F19,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R4KPB23 - SLIM Dual Button w/ Code St",{"$f":"IF(B20<>\"\", VLOOKUP(B20, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R4KPB23"},89,null,null,{"$f":"IF(F20<>\"\", VLOOKUP(F20,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R4KPB12 - SLIM Single Button St",{"$f":"IF(B21<>\"\", VLOOKUP(B21, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R4KPB12"},178,null,null,{"$f":"IF(F21<>\"\", VLOOKUP(F21,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,"R4KPC11 - SLIM Pull Cord St",{"$f":"IF(B22<>\"\", VLOOKUP(B22, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":"R4KPC11"},78,null,null,{"$f":"IF(F22<>\"\", VLOOKUP(F22,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\", VLOOKUP(B23, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F23<>\"\", VLOOKUP(F23,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\", VLOOKUP(B24, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F24<>\"\", VLOOKUP(F24,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\", VLOOKUP(B25, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F25<>\"\", VLOOKUP(F25,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B26<>\"\", VLOOKUP(B26, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F26<>\"\", VLOOKUP(F26,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B27<>\"\", VLOOKUP(B27, DropDowns!A$1:B$70, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F27<>\"\", VLOOKUP(F27,DropDowns!A$69:B$86, 2, FALSE), \"\")","v":""}]
[]
["Instructions:"]
[]
["1. Make your System/Integration/Software Choices by choosing Yes or No under System Conf/Integrations/Software boxes above."]
["2. In the Typical Patient Room section, if you have a large number of rooms that have the same exact stations in them, choose each of those items from the Yellow drop-down box and then enter the number of rooms that have this station in the count box.  By choosing the station type and entering in a quantity, this will automatically update the Quote Detail tab."]
["3. For all other rooms or stations, enter/edit the Quantities of each station/device individually in the next sheet, Quote Detail."]
["4. Based on what you enter in this sheet, the next sheet will auto update."]
["5. However, use the Column labeled,  Enter Qty +/- to add or substract items based on your specific needs. For example, if the Auto Update selects 5 Power Supplies, but you only want 4 in the quote, enter \"-1\" for that item."]

{"sheet":"Labor_Installation","index":1,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Cost Summary"]
["Hours","Rate",null,null,null,null,null,"Selling Price Summary"]
[null,null,null,null,null,null,null,null,"Cost","Mark-up","Selling Price",null,"Profit"]
[null,null,"Total Cable Selling Cost -->",null,{"$f":"'R5K Details'!M175","v":0},null,null,"Equipment",{"$f":"order_hack!G205","v":147424},1.7,{"$f":"I4*J4","v":250620.79999999999},null,{"$f":"K4-I4","v":103196.79999999999}]
["Total Labor Costs",null,null,null,null,null,null,"Training",0,1.7,{"$f":"I5*J5","v":0},null,{"$f":"K5-I5","v":0}]
[0,0,"Demolition Labor",null,{"$f":"B6*A6","v":0},null,null,"Cable",{"$f":"E4","v":0},1.7,{"$f":"I6*J6","v":0},null,{"$f":"K6-I6","v":0}]
[{"$f":"order_hack!D203","v":0},0,"Est. Shop Labor ",null,0,null,null,"Labor",{"$f":"E21","v":0},1.5,{"$f":"I7*J7","v":0},null,{"$f":"K7-I7","v":0}]
[{"$f":"'R5K Details'!O175","v":536},0,"Est. Cable Labor",null,0,null,null,"Miscellaneous",{"$f":"E39","v":0},1.7,{"$f":"I8*J8","v":0},null,{"$f":"K8-I8","v":0}]
[{"$f":"order_hack!F203","v":839.8},0,"Est. Field Labor ",null,0,null,null,"Total -->",{"$f":"SUM(I4:I8)","v":147424},null,{"$f":"SUM(K4:K8)","v":250620.79999999999}]
[0,0,"Engineering (7% of Dist Net hardware and Field Labor)",null,0,null,null,null,null,null,null,"Gross Profit -->",{"$f":"SUM(M4:M8)","v":103196.79999999999}]
[0,0,"Warranty",null,0,null,null,null,null,null,null,"Distributor Allowance -->",0]
[0,0,"Coordination",null,{"$f":"A12*B12","v":0},null,null,null,null,null,null,"Net Profit -->",{"$f":"M10-M11","v":103196.79999999999}]
[0,0,"In-Service/Needs Assessment (beyond CAS)",null,0]
[0,0,"Testing / Troubleshooting / Inspection",null,0,null,null,null,null,null,null,"Profitability -->",{"$f":"IF((K9<>0),(M12/K9),0)","v":0.41176470588235292}]
[0,0,"Project Management",null,0,null,null,null,null,"Total Selling Price -->",{"$f":"K9","v":250620.79999999999}]
[0,0,"CAD Drawings",null,0]
[0,0,"Enter your own items",null,0,null,null,null,null,"Sales Tax -->",0]
[0,0,"Enter your own items",null,0]
[0,0,"Enter your own items",null,0]
[{"$f":"SUM(A6:A19)","v":1375.8},"<-- Total Labor Hours "]
[null,null,"Total Labor Cost -->",null,{"$f":"SUM(E6:E19)","v":0}]
["Total Miscellaneous Costs"]
[0,0,"Lost Time",null,{"$f":"A23*B23","v":0}]
[0,0,"Travel",null,0]
[0,0,"Freight",null,0]
[0,0,"Bond",null,0]
[0,0,"Parking",null,0]
[0,0,"PerDiem",null,0]
[0,0,"Subcontractors",null,0]
[0,0,"Infection Control Hardware",null,0]
[0,0,"Infection Control Labor",null,0]
[0,0,"Overtime",null,0]
[0,0,"After Hours",null,0]
[0,0,"Enter your own items",null,0]
[0,0,"Enter your own items",null,0]
[0,0,"Enter your own items",null,0]
[0,0,"Enter your own items",null,0]
[{"$f":"SUM(A23:A37)","v":0},"<-- Total Misc. Hours "]
[null,null,"Total Misc. Installation Cost -->",null,{"$f":"SUM(E23:E38)","v":0}]

{"sheet":"R5K Details","index":2,"n_rows":175,"n_cols":18,"rows_kept":175,"cut":false,"hidden":false,"merged":[[3,2,3,3],[0,0,0,19],[1,13,1,18],[2,13,2,18],[3,13,3,18],[1,0,1,9],[2,0,2,9],[152,0,152,11],[151,0,151,11],[122,0,122,9],[5,0,5,9],[28,0,28,9],[81,0,81,9],[106,0,106,9]]}
[]
[{"$f":"'Input for Auto Config'!A1:K1","v":"International Responder 5000 2018 Estimate Sheet v 1.31"},null,null,null,null,null,null,null,null,null,null,null,"Job Name:",{"$f":"'Input for Auto Config'!F3","v":"Angol"}]
["Responder 5000 System",null,null,null,null,null,null,null,null,null,null,null,"Distributor Name:",{"$f":"'Input for Auto Config'!F4","v":"Cencomex"}]
[null,null,"Date:",null,{"$f":"'Input for Auto Config'!F2","v":"2018-01-11"},null,null,null,null,null,null,null,"Salesperson:",{"$f":"'Input for Auto Config'!F5","v":"Cristian Yañez"}]
["MANUF.","Part #","Con- 8","Con- 6","Description (Items in Purple Automatically Add Quantities in Yellow Column after Completing the Input for Auto Config Tab)","Con- 8","Con- 6","Auto","Add or Decrease Quantity after Completing Auto Config (See Input for Auto Config Tab)","Qty","List Price","Current (Amps)","Total Current","Shop Hours","Shop Total","Field Hours","Field Total","Notes"]
["Headend"]
["RAULAND","NC2828",null,null,"Head-End Equipment Cabinet",null,null,{"$f":"IF(J11>CEILING((J9+J10)/3,1),J11,CEILING((J9+J10)/3,1))","v":12},null,{"$f":"H7+I7","v":12},{"$f":"VLOOKUP(B7,'2017'!C$4:J$257,7,FALSE)","v":1680},null,null,null,{"$f":"IF(H7*N7=0,\" \",H7*N7)","v":" "},2,{"$f":"IF(H7*P7=0,\" \",H7*P7)","v":24}]
["\"","351102",null,null,"Wall Mounting Cabinet-head-end",null,null,null,null,0,{"$f":"VLOOKUP(B8,'2017'!C$4:J$257,7,FALSE)","v":1145}]
["\"","R5KMPR15",null,null,"Power Supply 15V for Stations, CLs, DCs (w/battery backup)",null,null,{"$f":"CEILING((M150)/2.6, 1)","v":24},null,24,{"$f":"VLOOKUP(B9,'2017'!C$4:J$257,7,FALSE)","v":933},null,null,null,{"$f":"IF(H9*N9=0,\" \",H9*N9)","v":" "},1,{"$f":"IF(H9*P9=0,\" \",H9*P9)","v":24}]
["\"","R5KMPR36",null,null,"Power Supply 36V for MSC, Console (w/battery backup)",null,null,{"$f":"CEILING(SUM(M11:M14)/2.4, 1)+J13","v":12},null,{"$f":"H10+I10","v":12},{"$f":"VLOOKUP(B10,'2017'!C$4:J$257,7,FALSE)","v":900},null,null,null,{"$f":"IF(H10*N10=0,\" \",H10*N10)","v":" "},0.5,{"$f":"IF(H10*P10=0,\" \",H10*P10)","v":6}]
["\"","R5KMSC",null,null,"Main System Controller",null,null,{"$f":"DropDowns!I34","v":3},1,{"$f":"H11+I11","v":4},{"$f":"VLOOKUP(B11,'2017'!C$4:J$257,7,FALSE)","v":1803},2,{"$f":"L11*J11","v":8},null,{"$f":"IF(H11*N11=0,\" \",H11*N11)","v":" "},6,{"$f":"IF(H11*P11=0,\" \",H11*P11)","v":18}]
["\"","351010",null,null,"Responder Network Concentrator",null,null,null,1,{"$f":"H12+I12","v":1},{"$f":"VLOOKUP(B12,'2017'!C$4:J$257,7,FALSE)","v":12108}]
["\"","R5KM8PRT",null,null,"R5K 8-Port Switch",null,null,{"$f":"ROUNDUP(SUM(J11,J23)/8,0)","v":4},4,{"$f":"H13+I13","v":8},{"$f":"VLOOKUP(B13,'2017'!C$4:J$257,7,FALSE)","v":1113},2.4,null,null,null,0.5,{"$f":"IF(H13*P13=0,\" \",H13*P13)","v":2}]
["\"","351006",null,null,"Fiber Optic Adapter Module",null,null,{"$f":"IF(H11>=1,2,0)","v":2},null,{"$f":"H14+I14","v":2},{"$f":"VLOOKUP(B14,'2017'!C$4:J$257,7,FALSE)","v":510},0.75,{"$f":"L14*J14","v":1.5},null,null,2]
["\"","R5KL2KA",null,null,"Data Converter for K-Bus to L-Net",null,null,{"$f":"DropDowns!I46","v":9},null,9,{"$f":"VLOOKUP(B15,'2017'!C$4:J$257,7,FALSE)","v":543},0.13,{"$f":"L15*J15","v":1.17},null,null,8,{"$f":"IF(H15*P15=0,\" \",H15*P15)","v":72}]
["\"","R5KMRPT",null,null,"Reporting Software License (1 per system)",null,null,{"$f":"IF('Input for Auto Config'!C7=\"yes\", 1, 0)","v":1},null,1,{"$f":"VLOOKUP(B16,'2017'!C$4:J$257,7,FALSE)","v":9000},null,null,null,{"$f":"IF(H16*N16=0,\" \",H16*N16)","v":" "},16,{"$f":"IF(H16*P16=0,\" \",H16*P16)","v":16}]
["\"","R5KMSIP",null,null,"SIP Telephony Software License (1 per system)",null,null,{"$f":"IF(AND('Input for Auto Config'!C5=\"\",'Input for Auto Config'!C9=\"\"),0,IF('Input for Auto Config'!C5=\"yes\",1,IF(AND('Input for Auto Config'!C5=\"no\",'Input for Auto Config'!C9=\"yes\"),1,IF(AND('Input for Auto Config'!C5=\"\",'Input for Auto Config'!C9=\"yes\"),1, 0))))","v":1},null,{"$f":"IF(AND(H17=0,I144=1),1,H17+I17)","v":1},{"$f":"VLOOKUP(B17,'2017'!C$4:J$257,7,FALSE)","v":5175},null,null,null,null,6,{"$f":"IF(H17*P17=0,\" \",H17*P17)","v":6}]
["\"","355005",null,null,"Responder SIP Server",null,null,{"$f":"IF(H17=1, 1, 0)","v":1},null,1,{"$f":"VLOOKUP(B18,'2017'!C$4:J$257,7,FALSE)","v":4125},null,null,null,null,6,{"$f":"IF(H18*P18=0,\" \",H18*P18)","v":6}]
["\"","R4KPA25",2,null,"Paging Amplifier",{"$f":"C19*J19","v":18},null,{"$f":"IF('Input for Auto Config'!C6=\"yes\", 'R5K Details'!J15, 0)","v":9},null,{"$f":"H19+I19","v":9},{"$f":"VLOOKUP(B19,'2017'!C$4:J$257,7,FALSE)","v":858},2.5,{"$f":"L19*J19","v":22.5},null,null,4,{"$f":"IF(H19*P19=0,\" \",H19*P19)","v":36}]
["\"","R4KMQCV2",2,null,"Marquee Controller",{"$f":"C20*J20","v":0},null,null,null,{"$f":"I20","v":0},{"$f":"VLOOKUP(B20,'2017'!C$4:J$257,7,FALSE)","v":507},0.3,{"$f":"L20*J20","v":0},null,null,2,{"$f":"IF(J20*P20=0,\" \",J20*P20)","v":" "}]
["\"","R4KMST",2,null,"Marquee Speaker Station",{"$f":"C21*J21","v":0},null,null,null,{"$f":"I21","v":0},{"$f":"VLOOKUP(B21,'2017'!C$4:J$257,7,FALSE)","v":123},5.0000000000000001E-3,{"$f":"L21*J21","v":0},null,null,0.35," "]
["\"","R5KMTRM",8,null,"Termination Board",{"$f":"C22*J22","v":72},null,{"$f":"J15","v":9},null,{"$f":"H22+I22","v":9},{"$f":"VLOOKUP(B22,'2017'!C$4:J$257,7,FALSE)","v":183},null,null,null,null,1,9]
["\"","R5KCONS",null,null,"VoIP Nurse Console",null,null,null,24,{"$f":"H23+I23","v":24},{"$f":"VLOOKUP(B23,'2017'!C$4:J$257,7,FALSE)","v":1836},0.32800000000000001,{"$f":"L23*J23","v":7.8719999999999999},null,null,2,48]
["\"","R4KTMB",14,null,"Termination Board",{"$f":"C24*J24","v":0},null,0,null,{"$f":"H24+I24","v":0},{"$f":"VLOOKUP(B24,'2017'!C$4:J$257,7,FALSE)","v":155},null,null,null,null,1," "]
["\"","R4KANNV2",2,null,"Annunciate Panel (comes with a Receptacle)",0,{"$f":"D25*J25","v":0},null,null,{"$f":"I25","v":0},{"$f":"VLOOKUP(B25,'2017'!C$4:J$257,7,FALSE)","v":882},0.375,{"$f":"L25*J25","v":0},null,null,1," "]
["\"","R4KRECP",2,null,"R4K Console Receptacle",0,0,null,null,{"$f":"I26","v":0},{"$f":"VLOOKUP(B26,'2017'!C$4:J$257,7,FALSE)","v":66},null,null,null,{"$f":"IF(J26*N26=0,\" \",J26*N26)","v":" "},0.5," "]
["\"","R4KWM22",null,null,"Wall Mount Kit for Annunciate Panel",null,null,null,null,{"$f":"I27+H27","v":0},{"$f":"VLOOKUP(B27,'2017'!C$4:J$257,7,FALSE)","v":243},null,null,null,{"$f":"IF(J27*N27=0,\" \",J27*N27)","v":" "},1," "]
["\"","R4KDM22",null,null,"Desk Mount Kit",null,null,null,null,{"$f":"I28","v":0},{"$f":"VLOOKUP(B28,'2017'!C$4:J$257,7,FALSE)","v":189},null,null,null," ",1," "]
["Stations"]
["RAULAND","R5KPD2EA",4,null,"R5K Enhnaced Dual Patient Station",{"$f":"C30*J30","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B30,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B30,'2017'!C$4:J$257,7,FALSE)","v":216},1.4999999999999999E-2,{"$f":"L30*J30","v":0},null,null,0.35,{"$f":"IF(J30*P30=0,\" \",J30*P30)","v":" "}]
["\"","R5KPS1EA",2,null,"R5K Enhanced Single Station",564,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B31,'Input for Auto Config'!D$14:D$27)","v":282},null,282,{"$f":"VLOOKUP(B31,'2017'!C$4:J$257,7,FALSE)","v":165},1.0999999999999999E-2,3.1019999999999999,null,null,0.35,98.699999999999989]
["\"","R5KPD2A",4,null,"R5K Dual Patient Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B32,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B32,'2017'!C$4:J$257,7,FALSE)","v":177},0.01,0,null,null,0.35," "]
["\"","R5KPS1A",2,null,"R5K Single Audio Patient Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B33,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B33,'2017'!C$4:J$257,7,FALSE)","v":126},8.0000000000000002E-3,0,{"$f":"SUMIF('Input for Auto Config'!C14:C27,B33,'Input for Auto Config'!D14:D27)","v":0},null,0.35," "]
["\"","R5KPS1V",2,null,"R5K Single Patient Visual Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B34,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B34,'2017'!C$4:J$257,7,FALSE)","v":105},3.0000000000000001E-3,0,null,null,0.35," "]
["\"","R5KPS1LCA",4,null,"R5K Audio Single Patient Station with Lighting Control",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B35,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B35,'2017'!C$4:J$257,7,FALSE)","v":180},3.1E-2,0,null,null,0.35," "]
["\"","R5KSSTF",2,null,"R5K Staff Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B36,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B36,'2017'!C$4:J$257,7,FALSE)","v":111},1.6E-2,0,null,null,0.35," "]
["\"","R5KSDTY",4,null,"R5K Duty Station",12,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B37,'Input for Auto Config'!D$14:D$27)","v":3},null,3,{"$f":"VLOOKUP(B37,'2017'!C$4:J$257,7,FALSE)","v":132},2.7E-2,8.1000000000000003E-2,null,null,0.35,1.0499999999999998]
["\"","R5KPB4",4,null,"Responder 5K 4-button Workflow and Registration Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B38,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B38,'2017'!C$4:J$257,7,FALSE)","v":123},1.0999999999999999E-2,0,null,{"$f":"IF(J38*N38=0,\" \",J38*N38)","v":" "},0.35," "]
["\"","R5KPC11WP",2,null,"Waterproof Pullcord Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B39,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B39,'2017'!C$4:J$257,7,FALSE)","v":{"$error":"#N/A"}},1.4999999999999999E-2,null,null,{"$f":"IF(J39*N39=0,\" \",J39*N39)","v":" "},0.35," "]
["\"","R5KPC11WPS",2,null,"Waterproof Pullcord Station - Spanish",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B40,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B40,'2017'!C$4:J$257,7,FALSE)","v":{"$error":"#N/A"}},1.4999999999999999E-2,null,null,null,null," "]
["\"","R5KPC11WPF",2,null,"Waterproof Pullcord Station - French",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B41,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B41,'2017'!C$4:J$257,7,FALSE)","v":{"$error":"#N/A"}},1.4999999999999999E-2,null,null,null,null," "]
["\"","R4K15V",null,4,"SLIM 1/4\" Jack / Button St",0,{"$f":"D42*J42","v":0},{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B42,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B42,'2017'!C$4:J$257,7,FALSE)","v":123},7.0000000000000001E-3,{"$f":"L42*J42","v":0},null,{"$f":"IF(J42*N42=0,\" \",J42*N42)","v":" "},0.35," "]
["\"","R4K17V",null,2,"SLIM Enh Single Call St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B43,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B43,'2017'!C$4:J$257,7,FALSE)","v":186},2.5000000000000001E-2,0,null," ",0.35," "]
["\"","R4K11V",null,2,"Single Patient Station - Visual",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B44,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B44,'2017'!C$4:J$257,7,FALSE)","v":95},2E-3,0,null," ",0.35," "]
["\"","R4K12A",2,null,"Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B45,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B45,'2017'!C$4:J$257,7,FALSE)","v":103},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K12AHZ",2,null,"Horizontal Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B46,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B46,'2017'!C$4:J$257,7,FALSE)","v":108},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K13VA",2,null,"Enhanced Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B47,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B47,'2017'!C$4:J$257,7,FALSE)","v":203},2.5000000000000001E-2,0,null," ",0.35," "]
["\"","R4K13VAHZ",2,2,"Horizontal Enh Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B48,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B48,'2017'!C$4:J$257,7,FALSE)","v":205},2.5000000000000001E-2,0,null," ",0.35," "]
["\"","R4K14SA",2,2,"Single Patient w/ Staff Emer",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B49,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B49,'2017'!C$4:J$257,7,FALSE)","v":130},1.7999999999999999E-2,0,null," ",0.35," "]
["\"","R4K16LV",null,2,"Enhanced Single Patient Station - Visual",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B50,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B50,'2017'!C$4:J$257,7,FALSE)","v":163},1.4999999999999999E-2,0,null," ",0.35," "]
["\"","R4K21V",4,null,"Dual Patient Station - Visual",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B51,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B51,'2017'!C$4:J$257,7,FALSE)","v":125},4.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K22A",2,2,"Dual Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B52,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B52,'2017'!C$4:J$257,7,FALSE)","v":133},7.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K23VA",4,null,"Enhanced Dual Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B53,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B53,'2017'!C$4:J$257,7,FALSE)","v":253},0.03,0,null," ",0.35," "]
["\"","HSS400",2,null,"High Security Audio Bed Station",0,{"$f":"D54*J54","v":0},{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B54,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B54,'2017'!C$4:J$257,7,FALSE)","v":774},0.01,0,null," ",0.35," "]
["\"","HSS401",2,null,"High Security  Staff Station",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B55,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B55,'2017'!C$4:J$257,7,FALSE)","v":774},8.0000000000000002E-3,0,null," ",0.35," "]
["\"","HSS433",null,2,"High Security Push Button Station",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B56,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B56,'2017'!C$4:J$257,7,FALSE)","v":774},1.4999999999999999E-2,0,null," ",0.35,{"$f":"IF(J56*P56=0,\" \",J56*P56)","v":" "}]
["\"","R4KSS",2,null,"Staff Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B57,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B57,'2017'!C$4:J$257,7,FALSE)","v":103},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KDY",2,2,"Duty Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B58,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B58,'2017'!C$4:J$257,7,FALSE)","v":143},1.2E-2,0,null," ",0.35," "]
["\"","R4K2JACK",null,4,"SLIM Dual 1/4\" Jack St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B59,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B59,'2017'!C$4:J$257,7,FALSE)","v":135},7.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KCB13",null,2,"SLIM Code Button St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B60,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B60,'2017'!C$4:J$257,7,FALSE)","v":102},1.7000000000000001E-2,0,null," ",0.35," "]
["\"","R4KDTY2",2,2,"SLIM Duty St w/ Speaker",null,null,null,null,null,{"$f":"VLOOKUP(B61,'2017'!C$4:J$257,7,FALSE)","v":143},1.2E-2,0,null," ",0.35," "]
["\"","R4KPB12",null,2,"SLIM Single Button St",0,356,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B62,'Input for Auto Config'!D$14:D$27)","v":178},null,178,{"$f":"VLOOKUP(B62,'2017'!C$4:J$257,7,FALSE)","v":90},4.0000000000000001E-3,0.71199999999999997,null," ",0.35,62.3]
["\"","R4KPB23",null,2,"SLIM Dual Button w/ Code St",0,742,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B63,'Input for Auto Config'!D$14:D$27)","v":371},null,371,{"$f":"VLOOKUP(B63,'2017'!C$4:J$257,7,FALSE)","v":99},1.7000000000000001E-2,6.3070000000000004,null," ",0.5,185.5]
["\"","R4KPC11",null,2,"SLIM Pull Cord St",0,156,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B64,'Input for Auto Config'!D$14:D$27)","v":78},null,78,{"$f":"VLOOKUP(B64,'2017'!C$4:J$257,7,FALSE)","v":93},2E-3,0.156,null," ",0.35,27.299999999999997]
["\"","R4KSAR",null,2,"SLIM Dual Button St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B65,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B65,'2017'!C$4:J$257,7,FALSE)","v":102},7.0000000000000001E-3,0,null," ",0.5," "]
["\"","R4KSPK",2,null,"SLIM Speaker Module",0,0,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B66,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B66,'2017'!C$4:J$257,7,FALSE)","v":45},null,null,null," ",0.35," "]
["\"","R4KESR",null,2,"Emergency/Staff Registration Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B67,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B67,'2017'!C$4:J$257,7,FALSE)","v":108},7.0000000000000001E-3,{"$f":"L67*J67","v":0},null," ",0.35," "]
["\"","R4KCNCL",null,2,"Cancel Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B68,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B68,'2017'!C$4:J$257,7,FALSE)","v":83},null,null,null," ",0.35," "]
["\"","R4KCB12",null,2,"Code Blue Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B69,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B69,'2017'!C$4:J$257,7,FALSE)","v":98},1.7000000000000001E-2,{"$f":"L69*J69","v":0},null," ",0.35," "]
["\"","R4KPB11",null,2,"Single Push Button -Push for Help",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B70,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B70,'2017'!C$4:J$257,7,FALSE)","v":90},4.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KPC10",null,2,"Pull Cord Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B71,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B71,'2017'!C$4:J$257,7,FALSE)","v":85},2E-3,0,null," ",0.35," "]
["\"","R4KPB22",null,2,"Dual Push Button Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B72,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B72,'2017'!C$4:J$257,7,FALSE)","v":113},1.7000000000000001E-2,0,null," ",0.5," "]
["\"","R4KPB44",null,4,"Four Button Status Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B73,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B73,'2017'!C$4:J$257,7,FALSE)","v":128},1.0999999999999999E-2,0,null," ",0.5," "]
["\"","R4KSR1",null,2,"Staff Register Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B74,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B74,'2017'!C$4:J$257,7,FALSE)","v":80},2E-3,0,null," ",0.35," "]
["\"","R4KFB1",1,1,"Feature Bed Interface",{"$f":"C75*J75","v":0},{"$f":"D75*J75","v":0},{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B75,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H75+I75","v":0},{"$f":"VLOOKUP(B75,'2017'!C$4:J$257,7,FALSE)","v":132},7.4999999999999997E-2,0,null," ",0.05," "]
["\"","R4KSLC1",null,2,"Single Light Control Module",0,{"$f":"D76*J76","v":0},{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B76,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H76+I76","v":0},{"$f":"VLOOKUP(B76,'2017'!C$4:J$257,7,FALSE)","v":81},1.2999999999999999E-2,0,null," ",0.05," "]
["\"","R4KDLC2",null,3,"Dual Light Control Module",0,{"$f":"D77*J77","v":0},{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B77,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H77+I77","v":0},{"$f":"VLOOKUP(B77,'2017'!C$4:J$257,7,FALSE)","v":135},2.3E-2,0,null," ",0.05," "]
["\"","R4KTVA",null,null,"TV Adapter pigtail kit (Set of 10)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B78,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"ROUNDUP(I78+H78,0)","v":0},{"$f":"VLOOKUP(B78,'2017'!C$4:J$257,7,FALSE)","v":42},null,null,null," ",0.25," "]
["\"","R4KTVR1",2,null,"Digital TV Isolation Module",0,{"$f":"D79*J79","v":0},{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B79,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H79+I79","v":0},{"$f":"VLOOKUP(B79,'2017'!C$4:J$257,7,FALSE)","v":54},1.4999999999999999E-2,{"$f":"L79*J79","v":0},null," ",0.25," "]
["\"","R4KFAM",1,1,"Fire/Auxiliary Module",0,{"$f":"D80*J80","v":0},null,null,{"$f":"I80","v":0},{"$f":"VLOOKUP(B80,'2017'!C$4:J$257,7,FALSE)","v":117},0.03,{"$f":"L80*J80","v":0},null," ",0.25," "]
["\"","R4KCAL",1,1,"Call Assurance Light",0,{"$f":"D81*J81","v":0},{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B81,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"I81+H81","v":0},{"$f":"VLOOKUP(B81,'2017'!C$4:J$257,7,FALSE)","v":81},5.0000000000000001E-3,{"$f":"L81*J81","v":0},null," ",0.35," "]
["Corridor Devices"]
["RAULAND","R5KCL506",2,null,"5-Bulb, Visual Corridor Light",{"$f":"C83*J83","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B83,'Input for Auto Config'!D$14:D$27)","v":0},null,{"$f":"H83+I83","v":0},{"$f":"VLOOKUP(B83,'2017'!C$4:J$257,7,FALSE)","v":198},3.5999999999999997E-2,{"$f":"L83*J83","v":0},null,{"$f":"IF(J83*N83=0,\" \",J83*N83)","v":" "},0.75,{"$f":"IF(J83*P83=0,\" \",J83*P83)","v":" "}]
["\"","R5KCL516",2,null,"5-Bulb, 1-Point Audio Corridor Light",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B84,'Input for Auto Config'!D$14:D$27)","v":0},null,{"$f":"H84+I84","v":0},{"$f":"VLOOKUP(B84,'2017'!C$4:J$257,7,FALSE)","v":237},3.7999999999999999E-2,0,null," ",0.75," "]
["\"","R5KCL546",2,null,"5-Bulb, 4-Point Audio Corridor Light ",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B85,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B85,'2017'!C$4:J$257,7,FALSE)","v":270},5.8000000000000003E-2,0,null," ",0.75," "]
["\"","CLA246",2,null,"R4K 4 Bulb, 1-Point Audio Corridor Light",284,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B86,'Input for Auto Config'!D$14:D$27)","v":142},null,142,{"$f":"VLOOKUP(B86,'2017'!C$4:J$257,7,FALSE)","v":408},0.13800000000000001,19.596]
["\"","CLAR46",12,null,"R4K 4 Point Audio Relay Kit for CLA246",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B87,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B87,'2017'!C$4:J$257,7,FALSE)","v":128},0.32,0]
["\"","R5KDC06",2,null,"6-Point Visual Domeless Controller",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B88,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B88,'2017'!C$4:J$257,7,FALSE)","v":264},1.6E-2,0,null," ",1," "]
["\"","R5KDC016",2,null,"16-Point Visual Domeless Controller",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B89,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B89,'2017'!C$4:J$257,7,FALSE)","v":369},1.7000000000000001E-2,0,null," ",0.75," "]
["\"","R5KDC46",2,null,"6-Point, 4-Point Audio Domeless Controller",436,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B90,'Input for Auto Config'!D$14:D$27)","v":218},null,218,{"$f":"VLOOKUP(B90,'2017'!C$4:J$257,7,FALSE)","v":315},3.7999999999999999E-2,8.2839999999999989,null," ",0.75,163.5]
["\"","R5KDC16D",2,null,"6-Point, 1 Point Audio Duty Domeless Controller",6,null,{"$f":"IF(SUMIF('Input for Auto Config'!C$14:C$27,B91,'Input for Auto Config'!D$14:D$27)=0,J37,SUMIF('Input for Auto Config'!C$14:C$27,B91,'Input for Auto Config'!D$14:D$27))","v":3},null,3,{"$f":"VLOOKUP(B91,'2017'!C$4:J$257,7,FALSE)","v":330},5.8000000000000003E-2,0.17400000000000002,null," ",0.75,2.25]
["\"","R5KDCRC4",null,null,"Relay Output Control",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B92,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B92,'2017'!C$4:J$257,7,FALSE)","v":120},3.2000000000000001E-2,0,null," ",0.25," "]
["\"","R5KDCRCS4",null,null,"Solid State Relay Output Control",0,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B93,'Input for Auto Config'!D$14:D$27)","v":0},null,0,{"$f":"VLOOKUP(B93,'2017'!C$4:J$257,7,FALSE)","v":144},2.1000000000000001E-2,0,null," ",0.25," "]
["\"","CLV122",2,null,"Visual 2-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B94,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B94,'2017'!C$4:J$257,7,FALSE)","v":235},2.1999999999999999E-2,0,null," ",0.75," "]
["\"","CLV144",2,null,"Visual 4-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B95,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B95,'2017'!C$4:J$257,7,FALSE)","v":270},3.2000000000000001E-2,0,null," ",0.75," "]
["\"","DCV100",2,null,"Visual Domeless Controller - 6 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B96,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B96,'2017'!C$4:J$257,7,FALSE)","v":265},1.2E-2,0,null," ",0.75," "]
["\"","DCV116",2,null,"Visual Domeless Controller - 16 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B97,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B97,'2017'!C$4:J$257,7,FALSE)","v":385},1.2E-2,0,null," ",1," "]
["\"","CLA222",2,null,"Audio 2-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B98,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B98,'2017'!C$4:J$257,7,FALSE)","v":325},6.8000000000000005E-2,0,null," ",0.75," "]
["\"","CLA244",2,null,"Audio 4-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B99,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B99,'2017'!C$4:J$257,7,FALSE)","v":{"$error":"#N/A"}},7.8E-2,0,null," ",0.75," "]
["\"","CLA214D",2,null,"Audio 4-Bulb Duty Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B100,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B100,'2017'!C$4:J$257,7,FALSE)","v":455},9.8000000000000004E-2,0,null," ",0.75," "]
["\"","DCA200",2,null,"Audio Domeless Controller - 6 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B101,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B101,'2017'!C$4:J$257,7,FALSE)","v":343},3.7999999999999999E-2,0,null," ",0.75," "]
["\"","DCA214D",2,null,"Audio Duty Domeless Controller - 6 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B102,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B102,'2017'!C$4:J$257,7,FALSE)","v":383},5.8000000000000003E-2,0,null," ",0.75," "]
["\"","DCA216",2,null,"Audio Domeless Controller - 16 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B103,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B103,'2017'!C$4:J$257,7,FALSE)","v":430},3.7999999999999999E-2,0,null," ",1," "]
["\"","CLAR4",null,null,"Four Station Audio Relay Kit",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B104,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B104,'2017'!C$4:J$257,7,FALSE)","v":{"$error":"#N/A"}},3.2000000000000001E-2,0,null," ",0.25," "]
["\"","R4KOUT4R",null,2,"Visual Relay Output Control",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B105,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B105,'2017'!C$4:J$257,7,FALSE)","v":103},3.2000000000000001E-2,0,null," ",0.25," "]
["\"","R4KOUT4S",null,2,"Audio Solid State Relay Output Control",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B106,'Input for Auto Config'!D$14:D$27)","v":0},null,null,{"$f":"VLOOKUP(B106,'2017'!C$4:J$257,7,FALSE)","v":125},2.1000000000000001E-2,0,null," ",0.25," "]
["Accessories"]
["RAULAND","350018",null,null,"8pn Inlinecon Cat-5 Cat-6(100)",{"$f":"SUM(F19:F26,F30:F66,G42:G66,G25:G26,F76:F81,G76:G81,F83:F93,F115:F116,G115:G116,)","v":2646},null,{"$f":"ROUNDUP(F108/100,0)","v":27},null,{"$f":"I108+H108","v":27},{"$f":"VLOOKUP(B108,'2017'!C$4:J$257,7,FALSE)","v":338},null,null,null,{"$f":"IF(J108*N108=0,\" \",J108*N108)","v":" "},null,{"$f":"IF(J108*P108=0,\" \",J108*P108)","v":" "}]
["\"","R4KCONN6",null,null,"6-Pin connectors (Bag of 100)",null,{"$f":"SUM(G75)","v":0},{"$f":"CEILING(G109/100, 1)","v":0},null,{"$f":"I109+H109","v":0},{"$f":"VLOOKUP(B109,'2017'!C$4:J$257,7,FALSE)","v":486},null,null,null,{"$f":"IF(J109*N109=0,\" \",J109*N109)","v":" "},null,{"$f":"IF(J109*P109=0,\" \",J109*P109)","v":" "}]
["\"","R4KCONN8",null,null,"8-Pin connectors (Bag of 100)",{"$f":"SUM(F75)","v":0},null,{"$f":"CEILING(F110/100, 1)","v":0},null,{"$f":"I110+H110","v":0},{"$f":"VLOOKUP(B110,'2017'!C$4:J$257,7,FALSE)","v":490},null,null,null,{"$f":"IF(J110*N110=0,\" \",J110*N110)","v":" "},null,{"$f":"IF(J110*P110=0,\" \",J110*P110)","v":" "}]
["\"","350006",null,null,"Crimping tool Adapter",null,null,null,null,{"$f":"I111+H111","v":0},{"$f":"VLOOKUP(B111,'2017'!C$4:J$257,7,FALSE)","v":83}]
["\"","350007",null,null,"Station Removal Tool",null,null,null,null,{"$f":"I112+H112","v":0},{"$f":"VLOOKUP(B112,'2017'!C$4:J$257,7,FALSE)","v":40}]
["\"","R4KCRIMP",null,null,"Responder 4000 Crimp Tool",null,null,null,null,{"$f":"I113","v":0},{"$f":"VLOOKUP(B113,'2017'!C$4:J$257,7,FALSE)","v":60},null,null,null,{"$f":"IF(J113*N113=0,\" \",J113*N113)","v":" "},null,{"$f":"IF(J113*P113=0,\" \",J113*P113)","v":" "}]
["\"","R4KSTAC",null,null,"R4K Test Adapter Cables",null,null,null,null,{"$f":"I114","v":0},{"$f":"VLOOKUP(B114,'2017'!C$4:J$257,7,FALSE)","v":129}]
["\"","R4KKBS",3,null,"K-Bus Splitter",{"$f":"C115*J115","v":0},{"$f":"D115*J115","v":0},null,null,{"$f":"I115","v":0},{"$f":"VLOOKUP(B115,'2017'!C$4:J$257,7,FALSE)","v":42},null,null,null," ",0.25," "]
["\"","R4KKBSP",3,null,"K-Bus Splitter w/ Power",{"$f":"C116*J116","v":0},{"$f":"D116*J116","v":0},null,null,{"$f":"I116","v":0},{"$f":"VLOOKUP(B116,'2017'!C$4:J$257,7,FALSE)","v":48},null,null,null," ",0.25," "]
["\"","R5KPADP",null,null,"R5K Adapter Plates (10)",null,null,null,null,{"$f":"H117+I117","v":0},{"$f":"VLOOKUP(B117,'2017'!C$4:J$257,7,FALSE)","v":111},null,null,null," ",0.35," "]
["\"","350026",null,null,"R5 & R4K Single Gang Adapter Plates",null,null,null,null,0,{"$f":"VLOOKUP(B118,'2017'!C$4:J$257,7,FALSE)","v":53},null,null,null,null,0.1," "]
["\"","350008",null,null,"Clear Station Cover (SLIM 1 & 2 Button Stations)",null,null,null,null,{"$f":"I119+H119","v":0},{"$f":"VLOOKUP(B119,'2017'!C$4:J$257,7,FALSE)","v":63},null,null,null," ",0.1," "]
["\"","R4KSTR",null,null,"Strain Relief Kit",null,null,null,null,{"$f":"I120+H120","v":0},{"$f":"VLOOKUP(B120,'2017'!C$4:J$257,7,FALSE)","v":55},null,null,null," ",0.05," "]
["\"","R4KHVK",null,null,"R4K 250v Kit For NC2828",null,null,null,null,{"$f":"I121","v":0},{"$f":"VLOOKUP(B121,'2017'!C$4:J$257,7,FALSE)","v":290},null,null,null,{"$f":"IF(J121*N121=0,\" \",J121*N121)","v":" "},2," "]
["\"","CLS103",null,null,"3 Lamp High Security Dome Lite",null,null,null,null,{"$f":"I122","v":0},{"$f":"VLOOKUP(B122,'2017'!C$4:J$257,7,FALSE)","v":276},0.2,{"$f":"L122*J122","v":0},null,{"$f":"IF(J122*N122=0,\" \",J122*N122)","v":" "},2," "]
["Pillow Speakers/Call Cords/Other"]
["RAULAND","NCPSDSL2",null,null,"Digital Pillow Speaker, 2 Lts",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B124,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H124+I124","v":0},{"$f":"VLOOKUP(B124,'2017'!C$4:J$257,7,FALSE)","v":330},null,{"$f":"IF(J124*L124=0,\" \",J124*L124)","v":" "},null,{"$f":"IF(J124*N124=0,\" \",J124*N124)","v":" "},0.1,{"$f":"IF(J124*P124=0,\" \",J124*P124)","v":" "}]
["\"","NCPSDSTV",null,null,"Digital Pillow Speaker, TV",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B125,'Input for Auto Config'!H$14:H$27)","v":0},null,0,{"$f":"VLOOKUP(B125,'2017'!C$4:J$257,7,FALSE)","v":330},null,null,null," ",0.1]
["\"","NCPSKPL2",null,null,"Direct Access Digital PS, 2 Lt",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B126,'Input for Auto Config'!H$14:H$27)","v":0},null,0,{"$f":"VLOOKUP(B126,'2017'!C$4:J$257,7,FALSE)","v":345},null,null,null," ",0.1]
["\"","NCPSKPTV",null,null,"Direct Access Digital PS, TV",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B127,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H127+I127","v":0},{"$f":"VLOOKUP(B127,'2017'!C$4:J$257,7,FALSE)","v":345},null,null,null," ",0.1]
["\"","NCSAV",null,null,"DIN Cord Saver",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B128,'Input for Auto Config'!H$14:H$27)","v":0},null,0,{"$f":"VLOOKUP(B128,'2017'!C$4:J$257,7,FALSE)","v":43},null,{"$f":"IF(J128*L128=0,\" \",J128*L128)","v":" "},null," ",0.1,{"$f":"IF(J128*P128=0,\" \",J128*P128)","v":" "}]
["\"","CCDIN3",null,null,"Handheld Pendent - 2 Lights (8-pin DIN)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B129,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H129+I129","v":0},{"$f":"VLOOKUP(B129,'2017'!C$4:J$257,7,FALSE)","v":118},null,{"$f":"IF(J129*L129=0,\" \",J129*L129)","v":" "},null," ",0.1,{"$f":"IF(J129*P129=0,\" \",J129*P129)","v":" "}]
["\"","CCDIN",null,null,"Call Cord - Single w/ Clip (10 ft.)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B130,'Input for Auto Config'!H$14:H$27)","v":0},282,282,{"$f":"VLOOKUP(B130,'2017'!C$4:J$257,7,FALSE)","v":55},null,{"$f":"IF(J130*L130=0,\" \",J130*L130)","v":" "},null," ",0.1,{"$f":"IF(J130*P130=0,\" \",J130*P130)","v":28.200000000000003}]
["\"","CC200",null,null,"Call Cord - 1/4\" Jack Call Cord w/ Clip (10ft.)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B131,'Input for Auto Config'!H$14:H$27)","v":0},null,0,{"$f":"VLOOKUP(B131,'2017'!C$4:J$257,7,FALSE)","v":45},null,{"$f":"IF(J131*L131=0,\" \",J131*L131)","v":" "},null," ",0.1,{"$f":"IF(J131*P131=0,\" \",J131*P131)","v":" "}]
["\"","NC4JACK",null,null,"1/4\" Jack Auxiliary Input Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$14:C$27,B132,'Input for Auto Config'!D$14:D$27)","v":0},null,{"$f":"I132+H132","v":0},{"$f":"VLOOKUP(B132,'2017'!C$4:J$257,7,FALSE)","v":195},null,null,null," ",0.5]
["\"","NCBED",null,null,"37-pin Feature Bed Receptacle",null,null,null,null,{"$f":"I133","v":0},{"$f":"VLOOKUP(B133,'2017'!C$4:J$257,7,FALSE)","v":145},null,{"$f":"IF(J133*L133=0,\" \",J133*L133)","v":" "},null," ",0.5,{"$f":"IF(J133*P133=0,\" \",J133*P133)","v":" "}]
["\"","NCC37",null,null,"37-pin Feature Bed Cable",null,null,null,null,0,{"$f":"VLOOKUP(B134,'2017'!C$4:J$257,7,FALSE)","v":158},null,null,null," ",0.5]
["\"","NCC37RA",null,null,"37-pin Feature Bed Cable -Right Angle",null,null,null,null,0,{"$f":"VLOOKUP(B135,'2017'!C$4:J$257,7,FALSE)","v":158},null,null,null," ",0.5]
["\"","NCLV120",null,null,"Low Voltage Lighting Control 120V",null,null,{"$f":"SUMIF('Input for Auto Config'!G$14:G$27,'R5K Details'!B136,'Input for Auto Config'!H$14:H$27)","v":0},null,{"$f":"H136+I136","v":0},{"$f":"VLOOKUP(B136,'2017'!C$4:J$257,7,FALSE)","v":213},null,{"$f":"IF(J136*L136=0,\" \",J136*L136)","v":" "},null," ",0.5,{"$f":"IF(J136*P136=0,\" \",J136*P136)","v":" "}]
["\"","CM300",null,null,"Chassis Fault Monitor",null,null,null,null,null,{"$f":"VLOOKUP(B137,'2017'!C$4:J$257,7,FALSE)","v":363},null,null,null," ",0.5," "]
["\"","PM300",null,null,"Power Fault Monitor",null,null,null,null,null,{"$f":"VLOOKUP(B138,'2017'!C$4:J$257,7,FALSE)","v":343},null,null,null," ",0.5," "]
["\" ","350011",null,null,"Bio-seals - Cancel Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B139,'2017'!C$4:J$257,7,FALSE)","v":28},null,null,null," ",0.5," "]
["\" ","350012",null,null,"Bio-seals-Small Push Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B140,'2017'!C$4:J$257,7,FALSE)","v":28},null,null,null," ",0.5," "]
["\" ","350013",null,null,"Bio-seals Large Push Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B141,'2017'!C$4:J$257,7,FALSE)","v":38},null,null,null," ",0.5," "]
["WaveWare","STG",null,null,"WaveWare SIP to Tap Gateway",null,null,{"$f":"IF('Input for Auto Config'!C8=\"Yes\",1,0)","v":1},null,{"$f":"I142+H142","v":1},{"$f":"order_hack!F174","v":"FQ"},null,null,null," ",2,2]
["WaveWare","SPS-5V9E",null,null,"WaveWare Paging Transmitter for STG, 5W, Site Licensing ",null,null,{"$f":"IF('Input for Auto Config'!C8=\"Yes\",1,0)","v":1},null,{"$f":"I143+H143","v":1},{"$f":"order_hack!F175","v":"FQ"},null,null,null," ",2,2]
["WaveWare","0250-1250  ",null,null,"WaveWare Responder 5000 Messaging Server  ",null,null,{"$f":"IF('Input for Auto Config'!C9=\"Yes\",1,0)","v":1},null,{"$f":"I144+H144","v":1},{"$f":"order_hack!F176","v":"FQ"},null,null,null," ",null," "]
["WaveWare","0250-1003  ",null,null,"WaveWare 10 User Account Bundle (app licenses)",null,null,{"$f":"IF(AND('Input for Auto Config'!C9=\"yes\",'Input for Auto Config'!C10=\"\"),10000,IF('Input for Auto Config'!C10<=2,0,IF('Input for Auto Config'!C10>2,ROUNDUP(('Input for Auto Config'!C10-2)/10,0))))","v":10000},null,{"$f":"I145+H145","v":10000},2500,null,null,null," ",null," "]
[null,null,null,null,{"$f":"IF(B146=\"\",\"\",VLOOKUP(B146,'2017'!C$4:J$250,2,FALSE))","v":""},null,null,null,null,{"$f":"I146","v":0},{"$f":"IF(B146=\"\",0,VLOOKUP(B146,'2017'!C$4:J$257,7,FALSE))","v":0},null,null,null,{"$f":"IF(J146*N146=0,\" \",J146*N146)","v":" "},null,{"$f":"IF(J146*P146=0,\" \",J146*P146)","v":" "}]
[null,null,null,null,{"$f":"IF(B147=\"\",\"\",VLOOKUP(B147,'2017'!C$4:J$250,2,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(B147=\"\",0,VLOOKUP(B147,'2017'!C$4:J$257,7,FALSE))","v":0},null,null,null," ",null," "]
[null,null,null,null,{"$f":"IF(B148=\"\",\"\",VLOOKUP(B148,'2017'!C$4:J$250,2,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(B148=\"\",0,VLOOKUP(B148,'2017'!C$4:J$257,7,FALSE))","v":0},null,null,null," ",null," "]
[null,null,null,null,{"$f":"IF(B149=\"\",\"\",VLOOKUP(B149,'2017'!C$4:J$250,2,FALSE))","v":""},null,null,null,null,{"$f":"I149","v":0},{"$f":"IF(B149=\"\",0,VLOOKUP(B149,'2017'!C$4:J$257,7,FALSE))","v":0},null,null,null,{"$f":"IF(J149*N149=0,\" \",J149*N149)","v":" "},null,{"$f":"IF(J149*P149=0,\" \",J149*P149)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Amps -->",{"$f":"SUM(M24:M149,M19:M20)","v":60.911999999999999},"Hours -->",{"$f":"SUM(O7:O148)","v":0},"Hours -->",{"$f":"SUM(Q7:Q148)","v":839.8}]
[]
[{"$f":"A2","v":"International Responder 5000 2018 Estimate Sheet v 1.31"},null,null,null,null,null,null,null,null,null,null,null,"Job Name:",{"$f":"IF(N2=\"\",\"\",N2)","v":"Angol"}]
["Cable",null,null,null,null,null,null,null,null,null,null,null,"System:",{"$f":"IF(N3=\"\",\"\",N3)","v":"Cencomex"}]
[null,"DATE:",null,null,{"$f":"IF(E4=\"\",\"\",E4)","v":"2018-01-11"},null,null,null,null,null,null,null,"Salesperson:",{"$f":"IF(N4=\"\",\"\",N4)","v":"Cristian Yañez"}]
["MANUF.","Part #",null,null,"Description",null,null,null,null,"Qty","Distributor Cable Cost per 1000'","Distributor Extended Cable Cost",null,"Cable Labor","Cable Labor Total","Notes"]
[null,null,null,null,"4-Pair Cat5 Ethernet cable estimate (50ft/Room Device)",null,null,null,null,{"$f":"ROUNDUP(((SUM(J30:J74,J21)*50))/1000,0)","v":46},0,{"$f":"K156*J156","v":0},{"$f":"IF(J156*L156=0,\" \",J156*L156)","v":" "},8,{"$f":"IF(J156*N156=0,\" \",J156*N156)","v":368}]
[null,null,null,null,"4-Pair Cat5 Ethernet cable Estimate (250ft/Console)",null,null,null,null,{"$f":"ROUNDUP((SUM(J23:J23,J25,J20)*250)/1000,0)","v":6},0,{"$f":"K157*J157","v":0},{"$f":"IF(J157*L157=0,\" \",J157*L157)","v":" "},8,48]
[null,null,null,null,"4-Pair Cat5 Ethernet cable (400ft/MSC)",null,null,null,null,{"$f":"ROUNDUP((SUM(J11)*400)/1000,0)","v":2},0,0," ",8,16]
[null,null,null,null,"4-Pair Cat5 Ethernet cable (30ft/Corridor Light/Domeless Controller)",null,null,null,null,{"$f":"ROUNDUP((SUM(J83:J91,J94:J103)*30)/1000,0)","v":11},0,0," ",8,88]
[null,null,null,null,"Power Common - #12 AWG",null,null,null,null,null,0,0," ",8," "]
[null,null,null,null,"Power Common - #14 AWG",null,null,null,null,{"$f":"ROUNDUP((SUM(J11,J22,J24,J81,J14)*100/1000),0)","v":2},0,0," ",8,16]
[null,null,null,null,null,null,null,null,null,null,0,0," ",8," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,0,0," ",null," "]
[null,null,null,null,null,null,null,null,null,null,null,"Total Cable, Etc.",{"$f":"SUM(L156:L174)","v":0},"Hours -->",{"$f":"SUM(O156:O174)","v":536}]

{"sheet":"ORDER","index":3,"n_rows":226,"n_cols":9,"rows_kept":226,"cut":false,"hidden":false,"merged":[[198,3,198,5],[0,0,0,2],[210,3,210,5],[208,3,208,5],[209,3,209,5],[205,3,205,5],[199,3,199,5],[200,3,200,5],[201,3,201,5],[193,3,193,4],[194,3,194,5],[195,3,195,5],[196,3,196,5],[197,3,197,5],[206,3,206,5],[207,3,207,5],[210,1,210,2],[205,1,205,2],[206,1,206,2],[207,1,207,2],[208,1,208,2],[209,1,209,2],[195,1,195,2],[196,1,196,2],[223,1,223,2],[224,1,224,2],[225,1,225,2],[165,3,165,4],[166,3,166,4],[170,3,170,5],[171,3,171,5],[172,3,172,5],[175,3,175,4],[176,3,176,4],[191,3,191,5],[192,3,192,4],[182,3,182,5],[183,3,183,5],[184,3,184,5],[185,3,185,4],[186,3,186,4],[187,3,187,5],[188,3,188,5],[189,3,189,5],[190,3,190,5],[224,3,224,5],[217,3,217,4],[204,1,204,2],[221,1,221,2],[222,1,222,2],[211,1,211,2],[212,1,212,2],[213,1,213,2],[214,1,214,2],[215,1,215,2],[216,1,216,2],[217,1,217,2],[218,1,218,2],[219,1,219,2],[220,1,220,2],[197,1,197,2],[198,1,198,2],[199,1,199,2],[200,1,200,2],[201,1,201,2],[202,1,202,2],[203,1,203,2],[193,1,193,2],[194,1,194,2],[184,1,184,2],[185,1,185,2],[186,1,186,2],[187,1,187,2],[188,1,188,2],[189,1,189,2],[190,1,190,2],[191,1,191,2],[192,1,192,2],[182,1,182,2],[183,1,183,2],[172,1,172,2],[173,1,173,2],[174,1,174,2],[175,1,175,2],[176,1,176,2],[177,1,177,2],[178,1,178,2],[179,1,179,2],[180,1,180,2],[181,1,181,2],[0,4,0,5],[1,1,1,3],[1,6,1,7],[6,2,6,3],[6,4,7,4],[7,2,7,3],[2,3,2,4],[4,4,4,7],[2,6,2,7],[2,0,2,2],[3,0,12,0],[6,5,7,7],[5,2,5,3],[5,5,5,7],[12,1,12,2],[0,6,0,7],[1,4,1,5],[3,1,3,2],[3,5,3,6],[4,1,4,3],[8,1,8,7],[9,1,11,1],[9,3,9,7],[10,3,10,4],[10,5,10,6],[11,4,11,6],[12,3,12,4],[13,5,14,6],[13,1,14,1],[13,2,15,2],[13,3,15,3],[13,4,15,4],[15,0,15,1],[89,0,89,2],[89,3,89,5],[95,0,95,5],[90,0,90,5],[13,0,14,0],[119,2,119,3],[119,4,119,5],[13,7,89,7],[117,1,118,6],[99,7,116,7],[116,1,116,3],[116,4,116,6],[99,0,116,0],[108,1,108,3],[107,1,107,3],[101,1,101,3],[110,1,110,3],[109,1,109,3],[114,1,114,3],[115,1,115,5],[91,4,91,5],[111,1,111,3],[112,1,112,3],[113,1,113,3],[96,0,98,1],[91,0,94,2],[133,3,133,7],[122,1,122,6],[125,1,125,7],[131,0,131,7],[124,1,124,6],[120,4,120,5],[121,1,121,7],[126,1,127,4],[126,5,126,6],[120,2,120,3],[128,1,129,4],[128,5,128,6],[129,5,129,6],[132,1,132,7],[118,0,130,0],[123,1,123,6],[100,1,100,6],[133,1,133,2],[130,1,130,7],[102,1,102,3],[170,1,170,2],[171,1,171,2],[161,1,161,2],[162,1,162,2],[163,1,163,2],[164,1,164,2],[165,1,165,2],[134,1,134,2],[139,1,140,1],[139,2,139,7],[140,2,140,7],[137,1,137,7],[135,0,136,7],[166,1,166,2],[167,1,167,2],[168,1,168,2],[169,1,169,2],[158,1,158,2],[158,5,158,6],[159,1,159,2],[160,1,160,2],[159,3,159,5],[142,0,142,7],[141,3,141,5],[0,8,89,50],[90,8,90,13],[91,8,91,13],[90,14,209,48],[92,8,317,13],[210,14,342,48],[97,2,98,6],[99,1,99,4],[96,2,96,4],[127,5,127,6],[149,0,150,7],[148,1,148,7],[145,2,145,4],[138,2,138,7],[151,2,151,3],[178,3,178,5],[179,3,179,5],[162,3,162,5],[163,3,163,5],[168,3,168,5],[143,0,143,7],[161,3,161,5],[146,1,146,4],[147,2,147,5],[141,6,141,7],[151,4,151,5],[151,7,152,7],[152,2,152,3],[152,4,152,5],[144,1,144,7],[160,3,160,5],[134,3,134,7],[103,1,103,3],[104,1,104,3],[106,1,106,3],[105,1,105,3],[154,1,154,3],[154,4,154,7],[153,2,153,3],[155,5,155,7],[156,2,156,3],[156,4,157,4],[157,2,157,3],[156,5,157,7],[155,2,155,3],[225,3,225,5],[164,3,164,5],[167,3,167,5],[169,3,169,5],[173,3,173,5],[174,3,174,5],[177,3,177,5],[180,3,180,5],[181,3,181,5],[202,3,202,4],[203,3,203,4],[204,3,204,5],[220,3,220,4],[218,3,218,5],[219,3,219,5],[221,3,221,4],[222,3,222,5],[223,3,223,5],[212,3,212,5],[216,3,216,4],[213,3,213,5],[214,3,214,5],[215,3,215,5],[211,3,211,4]]}
["Responder 5000 Nurse Call System Purchase Order",null,null,"Project Name:",{"$f":"IF('R5K Details'!N2=\"\",\"\",'R5K Details'!N2)","v":"Angol"},null,"Enter Original date of Quote"]
[null,"Responder 5000 Nurse Call System Order Entry Fax (800) 217-0977",null,null,"Revision Date",null,{"$f":"TODAY()","v":"2018-01-11"}]
["1. Click on the \"Generate Purchase Order\" button to get a complete list of required components for your system. \n2. Fill in the required information in the light yellow cells to complete your order, then sign both pages and fax to Rauland. ",null,null,"Please fill in all Pale Yellow boxes before printing"]
[null,"PURCHASE ORDER  ",null,null,"Dist. P.O. # :"]
[null,"Distributor Information",null,null,"Facility Information"]
[null,"Distributor Name & Address",{"$f":"IF('R5K Details'!N3=\"\",\"\",'R5K Details'!N3)","v":"Cencomex"},null,"Facility Name:"]
[null,"Project Name/No.",null,null,"Facility Address:"]
[null,"Dist. Contact Person:"]
[]
[null,"Shipping Instructions:","Ship To Address:"]
[null,null,"Method of Shipment:",null,null,"Accept Partials? (yes/no):",null,"no"]
[null,null,"Requested Ship Date (mm/dd/yy):",null,"Special Instructions? (yes/no):",null,null,"no"]
[null,"Projected Time Frame for Job ",null,""]
["Qty.","Part Number","Description","List Price Ea.","Extended List Price","Distributor Prices"]
[]
["Head End",null,null,null,null,"Net","Extended Net"]
["Responder 5000"]
[12,"NC2828","Head-End Equipment Cabinet",1680,20160,672,8064]
[24,"R5KMPR15","Power Supply 15V for Stations, CLs, DCs (w/battery backup)",933,22392,311,7464]
[12,"R5KMPR36","Power Supply 36V for MSC, Console (w/battery backup)",900,10800,300,3600]
[4,"R5KMSC","Main System Controller",1803,7212,601,2404]
[1,"351010","Responder Network Concentrator",12108,12108,4843,4843]
[8,"R5KM8PRT","R5K 8-Port Switch",1113,8904,371,2968]
[2,"351006","Fiber Adapter Modules",510,1020,204,408]
[9,"R5KL2KA","Data Converter for K-Bus to L-Net",543,4887,181,1629]
[9,"R5KMTRM","Termination Board",183,1647,61,549]
[24,"R5KCONS","VoIP Nurse Console",1836,44064,612,14688]
[9,"R4KPA25","Paging Amplifier",858,7722,286,2574]
[218,"R5KDC46","6-Point, 4-Point Audio Domeless Controller",315,68670,105,22890]
[3,"R5KDC16D","6-Point, 1 Point Audio Duty Domeless Controller",330,990,110,330]
[282,"R5KPS1EA","R5K Enhanced Single Station",165,46530,55,15510]
[3,"R5KSDTY","R5K Duty Station",132,396,44,132]
[178,"R4KPB12","SLIM Single Button St",90,16020,30,5340]
[371,"R4KPB23","SLIM Dual Button w/ Code St",99,36729,33,12243]
[78,"R4KPC11","SLIM Pull Cord St",93,7254,31,2418]
[142,"CLA246","Audio 4-Bulb Corridor Light",408,57936,163,23146]
["Software"]
[1,"R5KMRPT","Reporting Software License (1 per system)",9000,9000,3000,3000]
[1,"R5KMSIP","SIP Telephony Software License (1 per system)",5175,5175,1725,1725]
[1,"355005","Responder SIP Server (1 per System)",4125,4125,1650,1650]
["ACCESSORIES"]
[27,"350018","Responder 8-pin SL Connector (Pack of 100)",338,9126,135,3645]
["Pillow Speakers/Call Cords"]
[282,"CCDIN","Call Cord - Single w/ Clip (10 ft.)",55,15510,22,6204]
["Additional Items"]
[1,"STG","WaveWare SIP to Tap Gateway","FQ","FQ","FQ","FQ"]
[1,"SPS-5V9E","WaveWare Paging Transmitter for STG, 5W, Site Licensing ","FQ","FQ","FQ","FQ"]
[1,"0250-1250  ","WaveWare Responder 5000 Messaging Server  ","FQ","FQ","FQ","FQ"]
[10000,"0250-1003  ","WaveWare 10 User Account Bundle (app licenses)","FQ","FQ","FQ","FQ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* Prices not in printed Price List are subject to change.",null,null,"Responder 5000 Suggested List Total: ",null,null,{"$f":"SUM(E17:E89)","v":418377}]
["Distributor Discount: ",null,null,null,null,null,{"$f":"G90-G92","v":270953},{"$f":"1-order_hack!F4","v":0.6},"Price per Bed (List Price)"]
["This program should be used as a guide when configuring/pricing a Responder 5000 system.  Rauland-Borg is not responsible for any discrepancies in this program.  Refer to Responder 5000 Installation and Configuration Manuals for assistance.",null,null,null,"Discounted Price:",null,{"$f":"order_hack!G205","v":147424},null,{"$f":"IF(G90=0,0,IF(SUM(order_hack!C35:C36,order_hack!C38:C40,order_hack!C44:C51,(SUM(order_hack!C37,order_hack!C52:C54)*2))=0,0,G90/SUM(order_hack!C35:C36,order_hack!C38:C40,order_hack!C44:C51,(SUM(order_hack!C37,order_hack!C52:C54)*2))))","v":1483.6063829787233}]
[null,null,null,"Total Cable Selling Cost -->",null,null,0]
[null,null,null,"Total Labor Cost -->",null,null,0]
[null,null,null,"Total Misc. Installation Cost -->",null,null,0]
["Customer Responder 5000 Total: ",null,null,null,null,null,{"$f":"SUM(G92:G95)","v":147424}]
[null,null,"Yearly Software Maintenance Agreement Distributor Price",null,null,"See Below",247.5]
[null,null,"If the Total Price of the Miscellaneous items is over 1,000,000.00 then you need to go back to the General Information page and enter in values for some servers."]
[]
[" ",{"$f":"B117","v":"TOTAL PRICE of Non-Rauland Miscellaneous Items not included in Quote above."},null,null,null,"See Below",{"$f":"E117","v":4300}]
[null,"Enter Miscellaneous Items (not listed in this quote above)"]
[null,"Enter Miscellaneous Non-Rauland Items (not listed elsewhere in this auto quote)",null,null,"Price Each","Quantity","Ext. Price"]
[null,"SIP Firewall",null,null,null,null,{"$f":"F103*E103","v":0}]
[null,"Server - Reports to include MS SQL 2014 Express",null,null,4300,{"$f":"IF('R5K Details'!J16=1,1,0)","v":1},4300]
[null,"Responder SIP Server",null,null,4300,{"$f":"IF(AND('R5K Details'!J16=1,'R5K Details'!J17=1),0,IF(AND('R5K Details'!J16=0,'R5K Details'!J17=1),1,0))","v":0},0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,"Miscellaneous  Accessories Total: ",null,null,null,null,{"$f":"SUM(G103:G115)","v":4300}]
[null,"TOTAL PRICE of Non-Rauland Miscellaneous Items not included in Quote above.",null,null,{"$f":"G116","v":4300}]
[]
[]
[null,"Page 1 of 2",null,null,null,null,{"$f":"TODAY()","v":"2018-01-11"}]
[null,null,"Authorization Signature",null,"Name",null,"Date"]
[null,"Rauland Order Entry Fax (800)217-0977"]
[null,"We will accept Partial Shipments on Peripherals/Accessories?",null,null,null,null,null,"Y"]
[]
[]
[]
[null,"I authorize Rauland to add the following items to my order should they be required to make a system functional/complete: ",null,null,null,"Power Supplies",null,"Y "]
[null,null,null,null,null,"8 port Switches",null,"Y "]
[null,null,null,null,null,"K-Bus to L-Net Adapters",null,"Y "]
[]
[]
["Responder 5000 Nurse Call System Server Requirements (minimum)"]
[]
[null,{"$f":"IF(F104=1,\"Responder Applications Server\",\"\")","v":"Responder Applications Server"},null,{"$f":"IF(F104=1,\"Please refer to Application Note R5000_APPNOTE_In_Your_IT_Environment\",\"\")","v":"Please refer to Application Note R5000_APPNOTE_In_Your_IT_Environment"}]
[null,{"$f":"IF(F105=1,\"Responder SIP Server\",\"\")","v":""},null,{"$f":"IF(F105=1,\"Please refer to Application Note R5000_APPNOTE_In_Your_IT_Environment\",\"\")","v":""}]
[]
[]
[null,"Facility Information"]
[null,"Facility Name:",{"$f":"IF($F$6=\"\",\"\",$F$6)","v":""}]
[null,null,{"$f":"IF($F$7=\"\",\"\",$F$7)","v":""}]
[null,null,{"$f":"IF($F$8=\"\",\"\",$F$8)","v":""}]
[null,"Contact Name (optional):",null,"Contact Phone Number (optional):"]
[]
["Software Maintenance Agreement"]
[null,"Software Maintenance agreements entitle the facility to software service packs, new releases and customer support for all Responder Database, Application and Integration software after the first 12 months.  Software Maintenance Agreement will be directly billed to the facility after the first 14 months after initial activation of the software has elapsed and will continue annually, unless otherwise instructed by the facility."]
[]
[null,"The Software Maintenance Agreement cost will be automatically added to any purchase order."]
[null,null,"Yearly Software Maintenance Agreement Distributor Price",null,null,null,{"$f":"order_hack!F111","v":247.5}]
[]
["This program should be used as a guide when configuring/pricing a Responder 5 system.  Rauland-Borg is not responsible for any discrepancies in this program.  Refer to Responder 5 Installation and Configuration Manuals for assistance."]
[]
[null,null,null,null,{"$f":"IF($E$132=\"\",\"\",$E$132)","v":""},null,"1900-09-03T12:00:00"]
[null,null,"Authorization Signature",null,"Name",null,"Date"]
[]
[null,"Customer Information",null,null,"Facility Information"]
[null,"Customer    ",{"$f":"C6","v":"Cencomex"},null,"Facility Name:",{"$f":"F6","v":0}]
[null,"Project Name/No.",{"$f":"C7","v":0},null,"Facility Address:",{"$f":"F7","v":0}]
[null,"Cust. Contact Person:",{"$f":"C8","v":0}]
[null,"Facility Information",null,"Answer",null,"Helpful Information"]
[null,"Type of Facility?",null,"",null,null,""]
[null,"# of licensed patient beds?",null,"",null,null,""]
[null,"# of inpatient units?",null,"",null,null,""]
[null,"Is this a stand alone facility or part of a healthcare system?",null,"",null,null,""]
[null,"If part of a system, how many facilities do you anticipate interfacing to a single data center?",null,"",null,null,""]
[null,"What brand of wireless devices does the site have?",null,"",null,null,"Cisco, Ascom i75, SpectraLink 900, etc."]
[null,null,null,"",null,null,""]
[null,"Network Information",null,null,null,null,""]
[null,"Is the datacenter in the same building as resident rooms?",null,"",null,null,""]
[null,"What is the speed to the datacenter from unit?",null,"",null,null,""]
[null,"Does the facility network operate on a WAN?",null,"",null,null,""]
[null,"Does the facility network operate on a LAN?",null,"",null,null,""]
[null,"Will the site allow remote access to servers via VPN?",null,"",null,null,""]
[null,"If so, which VPN client software?",null,"",null,null,""]
[null,"What type of switches does the site standardize on?",null,"",null,null,""]
[null,"Is a network topology diagram available for our review?",null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,"Backup and Recovery Information",null,null,null,null,""]
[null,"Type of backup environment",null,"",null,null,""]
[null,"Frequency of backup",null,"",null,null,""]
[null,"Are the backup jobs run at a certain time of the day?",null,"",null,null,""]
[null,"What is the backup software vendor and application name?",null,"",null,null,""]
[null,"Is replication desired (required)?",null,"",null,null,""]
[null,"If so, who is the vendor for replication used?",null,"",null,null,""]
[null,"Does the site operate in a SAN environment?",null,"",null,null,""]
[null,"If so, who is the vendor used?",null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,"Database Information",null,null,null,null,""]
[null,"Most common type of database server",null,"",null,null,"MS SQL, Oracle, etc."]
[null,"Is the site backing up the databases via MS SQL Server database utility, or using an external backup?",null,"",null,null,""]
[null,"Does the site archive their data in their databases?",null,"",null,null,"(remove data from database to conserve on space)"]
[null,"Does the site have the ability to tune database performance?",null,"",null,null,""]
[null,"What is the site's policy for applying updates to MS SQL Server?",null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,"Server Information",null,null,null,null,""]
[null,"Brand of servers typically used",null,"",null,null,"i.e. Dell, Compaq, IBM, etc."]
[null,"Name of Interface Engine",null,"",null,null,""]
[null,"Name of antivirus software vendor.",null,"",null,null,"McAfee, Norton, etc."]
[null,"Are the servers organized in grids?",null,"",null,null,""]
[null,"Name of operating systems supported.",null,"",null,null,""]
[null,"Are the site's servers virtualized?",null,"",null,null,""]
[null,"If so, who is the vendor and application?",null,"",null,null,""]
[null,"What is the site's policy for applying updates to the operating system, Windows Server?",null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,"Software and Integration Information",null,null,null,null,""]
[null,"Who is the site's wireless phone vendor(s)?",null,"",null,null,""]
[null,"Is it integrated with their nurse call system?",null,"",null,null,""]
[null,"Who is the site's pager vendor?",null,"",null,null,""]
[null,"Who is the site's PBX (Public Branch Exchange) vendor?",null,"",null,null,""]
[null,"Is it integrated with their resident care system?",null,"",null,null,""]
[null,"Is it integrated via a middleware?  If so, which middleware?",null,"",null,null,"staff, patients, assets, visitors"]
[null,null,null,"",null,null,""]
[null,"Client Workstation Information",null,null,null,null,""]
[null,"Brand of PC's typically used",null,"",null,null,"Dell, Gateways, etc."]
[null,"Name and version of operating system typically seen",null,"",null,null,"Windows XP Professional sp2"]
[null,"Name of antivirus software vendor for clients.",null,"",null,null,""]
[null,"Does the site use touch screen monitors?",null,"",null,null,""]
[null,null,null,"",null,null,""]
[null,"Security Information",null,null,null,null,""]
[null,"Name of directory or user services application",null,"",null,null,""]
[null,"Does the site use token identification?",null,"",null,null,"i.e. barcodes, proximity readers, swipe, etc."]
[null,null,null,"",null,null,""]
[null,"IT Personnel Information",null,null,null,null,""]
[null,"Is there a dedicated DBA on staff?",null,"",null,null,"provide names here"]
[null,"Is there a network architect on staff?",null,"",null,null,"provide names here"]
[null,"Is there a System Administrator on staff?",null,"",null,null,"provide names here"]
[null,"Is there a dedicated Project Manager on staff for this project?",null,""]

{"sheet":"order_hack","index":4,"n_rows":205,"n_cols":11,"rows_kept":205,"cut":false,"hidden":true,"merged":[[134,7,134,8],[140,7,140,8],[102,1,102,4],[0,5,0,6],[1,0,1,3],[0,0,0,3],[2,0,2,3],[99,2,99,3],[109,2,109,3],[197,1,197,4],[3,0,3,4],[4,1,4,4],[184,1,184,4],[156,0,156,1],[111,1,111,4],[182,1,182,3],[169,0,169,1]]}
["Responder 5000 Nurse Call System ",null,null,null,"Project Name:","Project Name"]
[null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-01-11"}]
[null,null,null,null,null,null,"GPO factor","BOM setting"]
["distributor/dealer discount",null,null,null,null,0.4,1.2]
["R5K"]
[]
["Model # ","Description",null,"Dist Net Price","Extended Price"," List Price","Extended List Price"]
[null,null,null,null,null,null,null,null,null,"# of R4KPR400","# of R5KMPR15"]
["NC2828","Head-End Equipment Cabinet",{"$f":"'R5K Details'!J7","v":12},{"$f":"VLOOKUP(A9,'2017'!C$4:J$257,8,FALSE)","v":672},{"$f":"D9*C9","v":8064},{"$f":"VLOOKUP(A9,'2017'!C$4:J$257,7,FALSE)","v":1680},{"$f":"F9*C9","v":20160},null,null,null,{"$f":"'R5K Details'!J9","v":24}]
["351102","Wall Mounting Cabinet-head-end",{"$f":"'R5K Details'!J8","v":0},{"$f":"VLOOKUP(A10,'2017'!C$4:J$257,8,FALSE)","v":458},{"$f":"D10*C10","v":0},{"$f":"VLOOKUP(A10,'2017'!C$4:J$257,7,FALSE)","v":1145},{"$f":"F10*C10","v":0}]
["R5KMPR15","Power Supply 15V for Stations, CLs, DCs (w/battery backup)",{"$f":"IF(J9=0,K9,K9)","v":24},{"$f":"VLOOKUP(A11,'2017'!C$4:J$257,8,FALSE)","v":311},{"$f":"D11*C11","v":7464},{"$f":"VLOOKUP(A11,'2017'!C$4:J$257,7,FALSE)","v":933},22392]
["R5KMPR36","Power Supply 36V for MSC, Console (w/battery backup)",{"$f":"'R5K Details'!J10","v":12},{"$f":"VLOOKUP(A12,'2017'!C$4:J$257,8,FALSE)","v":300},3600,{"$f":"VLOOKUP(A12,'2017'!C$4:J$257,7,FALSE)","v":900},{"$f":"F12*C12","v":10800}]
["R5KMSC","Main System Controller",{"$f":"'R5K Details'!J11","v":4},{"$f":"VLOOKUP(A13,'2017'!C$4:J$257,8,FALSE)","v":601},2404,{"$f":"VLOOKUP(A13,'2017'!C$4:J$257,7,FALSE)","v":1803},7212]
["351010","Responder Network Concentrator",{"$f":"'R5K Details'!J12","v":1},{"$f":"VLOOKUP(A14,'2017'!C$4:J$257,8,FALSE)","v":4843},{"$f":"D14*C14","v":4843},{"$f":"VLOOKUP(A14,'2017'!C$4:J$257,7,FALSE)","v":12108},{"$f":"F14*C14","v":12108}]
["R5KM8PRT","R5K 8-Port Switch",{"$f":"'R5K Details'!J13","v":8},{"$f":"VLOOKUP(A15,'2017'!C$4:J$257,8,FALSE)","v":371},2968,{"$f":"VLOOKUP(A15,'2017'!C$4:J$257,7,FALSE)","v":1113},8904]
["351006","Fiber Adapter Modules",{"$f":"'R5K Details'!J14","v":2},{"$f":"VLOOKUP(A16,'2017'!C$4:J$257,8,FALSE)","v":204},{"$f":"D16*C16","v":408},{"$f":"VLOOKUP(A16,'2017'!C$4:J$257,7,FALSE)","v":510},{"$f":"F16*C16","v":1020}]
["R5KL2KA","Data Converter for K-Bus to L-Net",{"$f":"'R5K Details'!J15","v":9},{"$f":"VLOOKUP(A17,'2017'!C$4:J$257,8,FALSE)","v":181},1629,{"$f":"VLOOKUP(A17,'2017'!C$4:J$257,7,FALSE)","v":543},4887]
["R5KMTRM","Termination Board",{"$f":"'R5K Details'!J22","v":9},{"$f":"VLOOKUP(A18,'2017'!C$4:J$257,8,FALSE)","v":61},549,{"$f":"VLOOKUP(A18,'2017'!C$4:J$257,7,FALSE)","v":183},1647]
["R5KCONS","VoIP Nurse Console",{"$f":"'R5K Details'!J23","v":24},{"$f":"VLOOKUP(A19,'2017'!C$4:J$257,8,FALSE)","v":612},14688,{"$f":"VLOOKUP(A19,'2017'!C$4:J$257,7,FALSE)","v":1836},44064]
["R4KPA25","Paging Amplifier",{"$f":"'R5K Details'!J19","v":9},{"$f":"VLOOKUP(A20,'2017'!C$4:J$257,8,FALSE)","v":286},2574,{"$f":"VLOOKUP(A20,'2017'!C$4:J$257,7,FALSE)","v":858},7722]
["R4KMQCV2","Marquee Controller",{"$f":"'R5K Details'!J20","v":0},{"$f":"VLOOKUP(A21,'2017'!C$4:J$257,8,FALSE)","v":169},0,{"$f":"VLOOKUP(A21,'2017'!C$4:J$257,7,FALSE)","v":507},0]
["R4KMST","Marquee Speaker Station",{"$f":"'R5K Details'!J21","v":0},{"$f":"VLOOKUP(A22,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A22,'2017'!C$4:J$257,7,FALSE)","v":123},0]
["R4KTMB","Termination Board",{"$f":"'R5K Details'!J24","v":0},{"$f":"VLOOKUP(A23,'2017'!C$4:J$257,8,FALSE)","v":62},0,{"$f":"VLOOKUP(A23,'2017'!C$4:J$257,7,FALSE)","v":155},0]
["R4KANNV2","Annunciate Panel (comes with a Receptacle)",{"$f":"'R5K Details'!J25","v":0},{"$f":"VLOOKUP(A24,'2017'!C$4:J$257,8,FALSE)","v":294},0,{"$f":"VLOOKUP(A24,'2017'!C$4:J$257,7,FALSE)","v":882},0]
["R4KRECP","R4K Console Receptacle",{"$f":"'R5K Details'!J26","v":0},{"$f":"VLOOKUP(A25,'2017'!C$4:J$257,8,FALSE)","v":22},0,{"$f":"VLOOKUP(A25,'2017'!C$4:J$257,7,FALSE)","v":66},0]
["R5KCL506","5-Bulb, Visual Corridor Light",{"$f":"'R5K Details'!J83","v":0},{"$f":"VLOOKUP(A26,'2017'!C$4:J$257,8,FALSE)","v":66},{"$f":"D26*C26","v":0},{"$f":"VLOOKUP(A26,'2017'!C$4:J$257,7,FALSE)","v":198},{"$f":"F26*C26","v":0}]
["R5KCL516","5-Bulb, 1-Point Audio Corridor Light",{"$f":"'R5K Details'!J84","v":0},{"$f":"VLOOKUP(A27,'2017'!C$4:J$257,8,FALSE)","v":79},0,{"$f":"VLOOKUP(A27,'2017'!C$4:J$257,7,FALSE)","v":237},0]
["R5KCL546","5-Bulb, 4-Point Audio Corridor Light ",{"$f":"'R5K Details'!J85","v":0},{"$f":"VLOOKUP(A28,'2017'!C$4:J$257,8,FALSE)","v":90},0,{"$f":"VLOOKUP(A28,'2017'!C$4:J$257,7,FALSE)","v":270},0]
["R5KDC06","6-Point Visual Domeless Controller",{"$f":"'R5K Details'!J88","v":0},{"$f":"VLOOKUP(A29,'2017'!C$4:J$257,8,FALSE)","v":88},0,{"$f":"VLOOKUP(A29,'2017'!C$4:J$257,7,FALSE)","v":264},0]
["R5KDC016","16-Point Visual Domeless Controller",{"$f":"'R5K Details'!J89","v":0},{"$f":"VLOOKUP(A30,'2017'!C$4:J$257,8,FALSE)","v":123},0,{"$f":"VLOOKUP(A30,'2017'!C$4:J$257,7,FALSE)","v":369},0]
["R5KDC46","6-Point, 4-Point Audio Domeless Controller",{"$f":"'R5K Details'!J90","v":218},{"$f":"VLOOKUP(A31,'2017'!C$4:J$257,8,FALSE)","v":105},22890,{"$f":"VLOOKUP(A31,'2017'!C$4:J$257,7,FALSE)","v":315},68670]
["R5KDC16D","6-Point, 1 Point Audio Duty Domeless Controller",{"$f":"'R5K Details'!J91","v":3},{"$f":"VLOOKUP(A32,'2017'!C$4:J$257,8,FALSE)","v":110},330,{"$f":"VLOOKUP(A32,'2017'!C$4:J$257,7,FALSE)","v":330},990]
["R5KDCRC4","Relay Output Control",{"$f":"'R5K Details'!J92","v":0},{"$f":"VLOOKUP(A33,'2017'!C$4:J$257,8,FALSE)","v":40},0,{"$f":"VLOOKUP(A33,'2017'!C$4:J$257,7,FALSE)","v":120},0]
["R5KDCRCS4","Solid State Relay Output Control",{"$f":"'R5K Details'!J93","v":0},{"$f":"VLOOKUP(A34,'2017'!C$4:J$257,8,FALSE)","v":48},0,{"$f":"VLOOKUP(A34,'2017'!C$4:J$257,7,FALSE)","v":144},0]
["R5KPD2EA","R5K Enhnaced Dual Patient Station",{"$f":"'R5K Details'!J30","v":0},{"$f":"VLOOKUP(A35,'2017'!C$4:J$257,8,FALSE)","v":72},0,{"$f":"VLOOKUP(A35,'2017'!C$4:J$257,7,FALSE)","v":216},0]
["R5KPS1EA","R5K Enhanced Single Station",{"$f":"'R5K Details'!J31","v":282},{"$f":"VLOOKUP(A36,'2017'!C$4:J$257,8,FALSE)","v":55},15510,{"$f":"VLOOKUP(A36,'2017'!C$4:J$257,7,FALSE)","v":165},46530]
["R5KPD2A","R5K Dual Patient Station",{"$f":"'R5K Details'!J32","v":0},{"$f":"VLOOKUP(A37,'2017'!C$4:J$257,8,FALSE)","v":59},0,{"$f":"VLOOKUP(A37,'2017'!C$4:J$257,7,FALSE)","v":177},0]
["R5KPS1A","R5K Single Audio Patient Station",{"$f":"'R5K Details'!J33","v":0},{"$f":"VLOOKUP(A38,'2017'!C$4:J$257,8,FALSE)","v":42},0,{"$f":"VLOOKUP(A38,'2017'!C$4:J$257,7,FALSE)","v":126},0]
["R5KPS1V","R5K Single Patient Visual Station",{"$f":"'R5K Details'!J34","v":0},{"$f":"VLOOKUP(A39,'2017'!C$4:J$257,8,FALSE)","v":35},0,{"$f":"VLOOKUP(A39,'2017'!C$4:J$257,7,FALSE)","v":105},0]
["R5KPS1LCA","R5K Audio Single Patient Station with Lighting Control",{"$f":"'R5K Details'!J35","v":0},{"$f":"VLOOKUP(A40,'2017'!C$4:J$257,8,FALSE)","v":60},0,{"$f":"VLOOKUP(A40,'2017'!C$4:J$257,7,FALSE)","v":180},0]
["R5KSSTF","R5K Staff Station",{"$f":"'R5K Details'!J36","v":0},{"$f":"VLOOKUP(A41,'2017'!C$4:J$257,8,FALSE)","v":37},0,{"$f":"VLOOKUP(A41,'2017'!C$4:J$257,7,FALSE)","v":111},0]
["R5KSDTY","R5K Duty Station",{"$f":"'R5K Details'!J37","v":3},{"$f":"VLOOKUP(A42,'2017'!C$4:J$257,8,FALSE)","v":44},132,{"$f":"VLOOKUP(A42,'2017'!C$4:J$257,7,FALSE)","v":132},396]
["R4K15V","SLIM 1/4\" Jack / Button St",{"$f":"'R5K Details'!J42","v":0},{"$f":"VLOOKUP(A43,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A43,'2017'!C$4:J$257,7,FALSE)","v":123},0]
["R4K17V","SLIM Enh Single Call St",{"$f":"'R5K Details'!J43","v":0},{"$f":"VLOOKUP(A44,'2017'!C$4:J$257,8,FALSE)","v":62},0,{"$f":"VLOOKUP(A44,'2017'!C$4:J$257,7,FALSE)","v":186},0]
["R4K11V","Single Patient Station - Visual",{"$f":"'R5K Details'!J44","v":0},{"$f":"VLOOKUP(A45,'2017'!C$4:J$257,8,FALSE)","v":38},0,{"$f":"VLOOKUP(A45,'2017'!C$4:J$257,7,FALSE)","v":95},0]
["R4K12A","Single Patient Station - Audio",{"$f":"'R5K Details'!J45","v":0},{"$f":"VLOOKUP(A46,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A46,'2017'!C$4:J$257,7,FALSE)","v":103},0]
["R4K12AHZ","Horizontal Single Patient Station - Audio",{"$f":"'R5K Details'!J46","v":0},{"$f":"VLOOKUP(A47,'2017'!C$4:J$257,8,FALSE)","v":43},0,{"$f":"VLOOKUP(A47,'2017'!C$4:J$257,7,FALSE)","v":108},0]
["R4K13VA","Enhanced Single Patient Station - Audio",{"$f":"'R5K Details'!J47","v":0},{"$f":"VLOOKUP(A48,'2017'!C$4:J$257,8,FALSE)","v":81},0,{"$f":"VLOOKUP(A48,'2017'!C$4:J$257,7,FALSE)","v":203},0]
["R4K13VAHZ","Horizontal Enh Single Patient Station - Audio",{"$f":"'R5K Details'!J48","v":0},{"$f":"VLOOKUP(A49,'2017'!C$4:J$257,8,FALSE)","v":82},0,{"$f":"VLOOKUP(A49,'2017'!C$4:J$257,7,FALSE)","v":205},0]
["R4K14SA","Single Patient w/ Staff Emer",{"$f":"'R5K Details'!J49","v":0},{"$f":"VLOOKUP(A50,'2017'!C$4:J$257,8,FALSE)","v":52},0,{"$f":"VLOOKUP(A50,'2017'!C$4:J$257,7,FALSE)","v":130},0]
["R4K16LV","Enhanced Single Patient Station - Visual",{"$f":"'R5K Details'!J50","v":0},{"$f":"VLOOKUP(A51,'2017'!C$4:J$257,8,FALSE)","v":65},0,{"$f":"VLOOKUP(A51,'2017'!C$4:J$257,7,FALSE)","v":163},0]
["R4K21V","Dual Patient Station - Visual",{"$f":"'R5K Details'!J51","v":0},{"$f":"VLOOKUP(A52,'2017'!C$4:J$257,8,FALSE)","v":50},0,{"$f":"VLOOKUP(A52,'2017'!C$4:J$257,7,FALSE)","v":125},0]
["R4K22A","Dual Patient Station - Audio",{"$f":"'R5K Details'!J52","v":0},{"$f":"VLOOKUP(A53,'2017'!C$4:J$257,8,FALSE)","v":53},0,{"$f":"VLOOKUP(A53,'2017'!C$4:J$257,7,FALSE)","v":133},0]
["R4K23VA","Enhanced Dual Patient Station - Audio",{"$f":"'R5K Details'!J53","v":0},{"$f":"VLOOKUP(A54,'2017'!C$4:J$257,8,FALSE)","v":101},0,{"$f":"VLOOKUP(A54,'2017'!C$4:J$257,7,FALSE)","v":253},0]
["HSS400","High Security Audio Bed Station",{"$f":"'R5K Details'!J54","v":0},{"$f":"VLOOKUP(A55,'2017'!C$4:J$257,8,FALSE)","v":258},0,{"$f":"VLOOKUP(A55,'2017'!C$4:J$257,7,FALSE)","v":774},0]
["HSS401","High Security  Staff Station",{"$f":"'R5K Details'!J55","v":0},{"$f":"VLOOKUP(A56,'2017'!C$4:J$257,8,FALSE)","v":258},0,{"$f":"VLOOKUP(A56,'2017'!C$4:J$257,7,FALSE)","v":774},0]
["HSS433","High Security Push Button Station",{"$f":"'R5K Details'!J56","v":0},{"$f":"VLOOKUP(A57,'2017'!C$4:J$257,8,FALSE)","v":258},0,{"$f":"VLOOKUP(A57,'2017'!C$4:J$257,7,FALSE)","v":774},0]
["R4KSS","Staff Station",{"$f":"'R5K Details'!J57","v":0},{"$f":"VLOOKUP(A58,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A58,'2017'!C$4:J$257,7,FALSE)","v":103},0]
["R4KDY","Duty Station",{"$f":"'R5K Details'!J58","v":0},{"$f":"VLOOKUP(A59,'2017'!C$4:J$257,8,FALSE)","v":57},0,{"$f":"VLOOKUP(A59,'2017'!C$4:J$257,7,FALSE)","v":143},0]
["R5KPB4","Responder 5K 4-button Workflow and Registration Station",{"$f":"'R5K Details'!J38","v":0},{"$f":"VLOOKUP(A60,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A60,'2017'!C$4:J$257,7,FALSE)","v":123},0]
["R5KPC11WP","Waterproof Pullcord Station",{"$f":"'R5K Details'!J39","v":0},null,0,"Future",{"$f":"IF(F61=\"Future\",\"Future\",F61*C61)","v":"Future"}]
["R5KPC11WPS","Waterproof Pullcord Station - Spanish",{"$f":"'R5K Details'!J40","v":0},null,0,"Future",{"$f":"IF(F62=\"Future\",\"Future\",F62*C62)","v":"Future"}]
["R5KPC11WPF","Waterproof Pullcord Station - French",{"$f":"'R5K Details'!J41","v":0},null,0,"Future","Future"]
["R4K2JACK","SLIM Dual 1/4\" Jack St",{"$f":"'R5K Details'!J59","v":0},{"$f":"VLOOKUP(A64,'2017'!C$4:J$257,8,FALSE)","v":45},0,{"$f":"VLOOKUP(A64,'2017'!C$4:J$257,7,FALSE)","v":135},0]
["R4KCB13","SLIM Code Button St",{"$f":"'R5K Details'!J60","v":0},{"$f":"VLOOKUP(A65,'2017'!C$4:J$257,8,FALSE)","v":34},0,{"$f":"VLOOKUP(A65,'2017'!C$4:J$257,7,FALSE)","v":102},0]
["R4KDTY2","SLIM Duty St w/ Speaker",{"$f":"'R5K Details'!J61","v":0},{"$f":"VLOOKUP(A66,'2017'!C$4:J$257,8,FALSE)","v":57},0,{"$f":"VLOOKUP(A66,'2017'!C$4:J$257,7,FALSE)","v":143},0]
["R4KPB12","SLIM Single Button St",{"$f":"'R5K Details'!J62","v":178},{"$f":"VLOOKUP(A67,'2017'!C$4:J$257,8,FALSE)","v":30},5340,{"$f":"VLOOKUP(A67,'2017'!C$4:J$257,7,FALSE)","v":90},16020]
["R4KPB23","SLIM Dual Button w/ Code St",{"$f":"'R5K Details'!J63","v":371},{"$f":"VLOOKUP(A68,'2017'!C$4:J$257,8,FALSE)","v":33},12243,{"$f":"VLOOKUP(A68,'2017'!C$4:J$257,7,FALSE)","v":99},36729]
["R4KPC11","SLIM Pull Cord St",{"$f":"'R5K Details'!J64","v":78},{"$f":"VLOOKUP(A69,'2017'!C$4:J$257,8,FALSE)","v":31},2418,{"$f":"VLOOKUP(A69,'2017'!C$4:J$257,7,FALSE)","v":93},7254]
["R4KSAR","SLIM Dual Button St",{"$f":"'R5K Details'!J65","v":0},{"$f":"VLOOKUP(A70,'2017'!C$4:J$257,8,FALSE)","v":34},0,{"$f":"VLOOKUP(A70,'2017'!C$4:J$257,7,FALSE)","v":102},0]
["R4KSPK","SLIM Speaker Module",{"$f":"'R5K Details'!J66","v":0},{"$f":"VLOOKUP(A71,'2017'!C$4:J$257,8,FALSE)","v":15},0,{"$f":"VLOOKUP(A71,'2017'!C$4:J$257,7,FALSE)","v":45},0]
["R4KESR","Emergency/Staff Registration Station",{"$f":"'R5K Details'!J67","v":0},{"$f":"VLOOKUP(A72,'2017'!C$4:J$257,8,FALSE)","v":43},0,{"$f":"VLOOKUP(A72,'2017'!C$4:J$257,7,FALSE)","v":108},0]
["R4KCNCL","Cancel Station",{"$f":"'R5K Details'!J68","v":0},{"$f":"VLOOKUP(A73,'2017'!C$4:J$257,8,FALSE)","v":33},0,{"$f":"VLOOKUP(A73,'2017'!C$4:J$257,7,FALSE)","v":83},0]
["R4KCB12","Code Blue Station",{"$f":"'R5K Details'!J69","v":0},{"$f":"VLOOKUP(A74,'2017'!C$4:J$257,8,FALSE)","v":39},0,{"$f":"VLOOKUP(A74,'2017'!C$4:J$257,7,FALSE)","v":98},0]
["R4KPB11","Single Push Button -Push for Help",{"$f":"'R5K Details'!J70","v":0},{"$f":"VLOOKUP(A75,'2017'!C$4:J$257,8,FALSE)","v":36},0,{"$f":"VLOOKUP(A75,'2017'!C$4:J$257,7,FALSE)","v":90},0]
["R4KPC10","Pull Cord Station",{"$f":"'R5K Details'!J71","v":0},{"$f":"VLOOKUP(A76,'2017'!C$4:J$257,8,FALSE)","v":34},0,{"$f":"VLOOKUP(A76,'2017'!C$4:J$257,7,FALSE)","v":85},0]
["R4KPB22","Dual Push Button Station",{"$f":"'R5K Details'!J72","v":0},{"$f":"VLOOKUP(A77,'2017'!C$4:J$257,8,FALSE)","v":45},0,{"$f":"VLOOKUP(A77,'2017'!C$4:J$257,7,FALSE)","v":113},0]
["R4KPB44","Four Button Status Station",{"$f":"'R5K Details'!J73","v":0},{"$f":"VLOOKUP(A78,'2017'!C$4:J$257,8,FALSE)","v":51},0,{"$f":"VLOOKUP(A78,'2017'!C$4:J$257,7,FALSE)","v":128},0]
["R4KSR1","Staff Register Station",{"$f":"'R5K Details'!J74","v":0},{"$f":"VLOOKUP(A79,'2017'!C$4:J$257,8,FALSE)","v":32},0,{"$f":"VLOOKUP(A79,'2017'!C$4:J$257,7,FALSE)","v":80},0]
["R4KFAM","Fire/Auxiliary Module",{"$f":"'R5K Details'!J80","v":0},{"$f":"VLOOKUP(A80,'2017'!C$4:J$257,8,FALSE)","v":39},0,{"$f":"VLOOKUP(A80,'2017'!C$4:J$257,7,FALSE)","v":117},0]
["R4KCAL","Call Assurance Light",{"$f":"'R5K Details'!J81","v":0},{"$f":"VLOOKUP(A81,'2017'!C$4:J$257,8,FALSE)","v":27},0,{"$f":"VLOOKUP(A81,'2017'!C$4:J$257,7,FALSE)","v":81},0]
["CLV122","Visual 2-Bulb Corridor Light",{"$f":"'R5K Details'!J94","v":0},{"$f":"VLOOKUP(A82,'2017'!C$4:J$257,8,FALSE)","v":94},{"$f":"D82*C82","v":0},{"$f":"VLOOKUP(A82,'2017'!C$4:J$257,7,FALSE)","v":235},{"$f":"F82*C82","v":0}]
["CLV144","Visual 4-Bulb Corridor Light",{"$f":"'R5K Details'!J95","v":0},{"$f":"VLOOKUP(A83,'2017'!C$4:J$257,8,FALSE)","v":108},0,{"$f":"VLOOKUP(A83,'2017'!C$4:J$257,7,FALSE)","v":270},0]
["DCV100","Visual Domeless Controller - 6 pt",{"$f":"'R5K Details'!J96","v":0},{"$f":"VLOOKUP(A84,'2017'!C$4:J$257,8,FALSE)","v":106},0,{"$f":"VLOOKUP(A84,'2017'!C$4:J$257,7,FALSE)","v":265},0]
["DCV116","Visual Domeless Controller - 16 pt",{"$f":"'R5K Details'!J97","v":0},{"$f":"VLOOKUP(A85,'2017'!C$4:J$257,8,FALSE)","v":154},0,{"$f":"VLOOKUP(A85,'2017'!C$4:J$257,7,FALSE)","v":385},0]
["CLA222","Audio 2-Bulb Corridor Light",{"$f":"'R5K Details'!J98","v":0},{"$f":"VLOOKUP(A86,'2017'!C$4:J$257,8,FALSE)","v":130},0,{"$f":"VLOOKUP(A86,'2017'!C$4:J$257,7,FALSE)","v":325},0]
["CLA246","Audio 4-Bulb Corridor Light",{"$f":"'R5K Details'!J86","v":142},{"$f":"VLOOKUP(A87,'2017'!C$4:J$257,8,FALSE)","v":163},23146,{"$f":"VLOOKUP(A87,'2017'!C$4:J$257,7,FALSE)","v":408},57936]
["CLA214D","Audio 4-Bulb Duty Corridor Light",{"$f":"'R5K Details'!J100","v":0},{"$f":"VLOOKUP(A88,'2017'!C$4:J$257,8,FALSE)","v":182},0,{"$f":"VLOOKUP(A88,'2017'!C$4:J$257,7,FALSE)","v":455},0]
["DCA200","Audio Domeless Controller - 6 pt",{"$f":"'R5K Details'!J101","v":0},{"$f":"VLOOKUP(A89,'2017'!C$4:J$257,8,FALSE)","v":137},0,{"$f":"VLOOKUP(A89,'2017'!C$4:J$257,7,FALSE)","v":343},0]
["DCA214D","Audio Duty Domeless Controller - 6 pt",{"$f":"'R5K Details'!J102","v":0},{"$f":"VLOOKUP(A90,'2017'!C$4:J$257,8,FALSE)","v":153},0,{"$f":"VLOOKUP(A90,'2017'!C$4:J$257,7,FALSE)","v":383},0]
["DCA216","Audio Domeless Controller - 16 pt",{"$f":"'R5K Details'!J103","v":0},{"$f":"VLOOKUP(A91,'2017'!C$4:J$257,8,FALSE)","v":172},0,{"$f":"VLOOKUP(A91,'2017'!C$4:J$257,7,FALSE)","v":430},0]
["CLAR46","Four Station Audio Relay Kit",{"$f":"'R5K Details'!J87","v":0},{"$f":"VLOOKUP(A92,'2017'!C$4:J$257,8,FALSE)","v":51},0,{"$f":"VLOOKUP(A92,'2017'!C$4:J$257,7,FALSE)","v":128},0]
["R4KOUT4R","Visual Relay Output Control",{"$f":"'R5K Details'!J105","v":0},{"$f":"VLOOKUP(A93,'2017'!C$4:J$257,8,FALSE)","v":41},0,{"$f":"VLOOKUP(A93,'2017'!C$4:J$257,7,FALSE)","v":103},0]
["R4KOUT4S","Audio Solid State Relay Output Control",{"$f":"'R5K Details'!J106","v":0},{"$f":"VLOOKUP(A94,'2017'!C$4:J$257,8,FALSE)","v":50},0,{"$f":"VLOOKUP(A94,'2017'!C$4:J$257,7,FALSE)","v":125},0]
[]
[]
[]
[]
[]
[null,null,"Subtotal (R5K)",null,{"$f":"SUM(E9:E99)","v":131200},null,{"$f":"SUM(G9:G99)","v":375441}]
[]
[]
["Software"]
[]
["Model # ","Description","Quantity","Dist Net","Extended Price"," List Price","Extended List Price"]
[]
["R5KMRPT","Reporting Software License (1 per system)",{"$f":"'R5K Details'!J16","v":1},{"$f":"VLOOKUP(A107,'2017'!C$4:J$257,8,FALSE)","v":3000},{"$f":"D107*C107","v":3000},{"$f":"VLOOKUP(A107,'2017'!C$4:J$257,7,FALSE)","v":9000},{"$f":"F107*C107","v":9000}]
["R5KMSIP","SIP Telephony Software License (1 per system)",{"$f":"'R5K Details'!J17","v":1},{"$f":"VLOOKUP(A108,'2017'!C$4:J$257,8,FALSE)","v":1725},1725,{"$f":"VLOOKUP(A108,'2017'!C$4:J$257,7,FALSE)","v":5175},5175]
["355005","Responder SIP Server (1 per System)",{"$f":"'R5K Details'!J18","v":1},{"$f":"VLOOKUP(A109,'2017'!C$4:J$257,8,FALSE)","v":1650},1650,{"$f":"VLOOKUP(A109,'2017'!C$4:J$257,7,FALSE)","v":4125},4125]
[null,null,"Subtotal (Software)",null,{"$f":"SUM(E107:E109)","v":6375},null,{"$f":"SUM(G107:G108)","v":14175}]
[null,null,null,null,"SMA",{"$f":"E109*0.15","v":247.5}]
["Accessories"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
["350018","Responder 8-pin SL Connector (Pack of 100)",{"$f":"'R5K Details'!J108","v":27},{"$f":"VLOOKUP(A116,'2017'!C$4:J$257,8,FALSE)","v":135},{"$f":"D116*C116","v":3645},{"$f":"VLOOKUP(A116,'2017'!C$4:J$257,7,FALSE)","v":338},{"$f":"F116*C116","v":9126},"# of R4K CL/DC"]
["350006","Crimping tool Adapter",{"$f":"'R5K Details'!J111","v":0},{"$f":"VLOOKUP(A117,'2017'!C$4:J$257,8,FALSE)","v":33},0,{"$f":"VLOOKUP(A117,'2017'!C$4:J$257,7,FALSE)","v":83},{"$f":"F117*C117","v":0},{"$f":"SUM('R5K Details'!J94:J103)","v":0}]
["R4KCONN6","6-Pin connectors (Bag of 100)",{"$f":"'R5K Details'!J109","v":0},{"$f":"VLOOKUP(A118,'2017'!C$4:J$257,8,FALSE)","v":162},0,{"$f":"VLOOKUP(A118,'2017'!C$4:J$257,7,FALSE)","v":486},0]
["R4KCONN8","8-Pin connectors (Bag of 100)",{"$f":"'R5K Details'!J110","v":0},{"$f":"VLOOKUP(A119,'2017'!C$4:J$257,8,FALSE)","v":196},0,{"$f":"VLOOKUP(A119,'2017'!C$4:J$257,7,FALSE)","v":490},0]
["R4KCRIMP","Responder 4000 Crimp Tool",{"$f":"'R5K Details'!J113","v":0},{"$f":"VLOOKUP(A120,'2017'!C$4:J$257,8,FALSE)","v":20},0,{"$f":"VLOOKUP(A120,'2017'!C$4:J$257,7,FALSE)","v":60},0]
["R4KSTAC","R4K Test Adapter Cables",{"$f":"'R5K Details'!J114","v":0},{"$f":"VLOOKUP(A121,'2017'!C$4:J$257,8,FALSE)","v":43},{"$f":"D121*C121","v":0},{"$f":"VLOOKUP(A121,'2017'!C$4:J$257,7,FALSE)","v":129},{"$f":"F121*C121","v":0}]
["350007","Station Removal Tool",{"$f":"'R5K Details'!J112","v":0},{"$f":"VLOOKUP(A122,'2017'!C$4:J$257,8,FALSE)","v":16},0,{"$f":"VLOOKUP(A122,'2017'!C$4:J$257,7,FALSE)","v":40},0]
["R4KKBS","K-Bus Splitter",{"$f":"'R5K Details'!J115","v":0},{"$f":"VLOOKUP(A123,'2017'!C$4:J$257,8,FALSE)","v":14},0,{"$f":"VLOOKUP(A123,'2017'!C$4:J$257,7,FALSE)","v":42},0]
["R4KKBSP","K-Bus Splitter w/ Power",{"$f":"'R5K Details'!J116","v":0},{"$f":"VLOOKUP(A124,'2017'!C$4:J$257,8,FALSE)","v":16},0,{"$f":"VLOOKUP(A124,'2017'!C$4:J$257,7,FALSE)","v":48},0]
["R4KFB1","Feature Bed Interface",{"$f":"'R5K Details'!J75","v":0},{"$f":"VLOOKUP(A125,'2017'!C$4:J$257,8,FALSE)","v":44},0,{"$f":"VLOOKUP(A125,'2017'!C$4:J$257,7,FALSE)","v":132},0]
["R4KSLC1","Single Light Control Module",{"$f":"'R5K Details'!J76","v":0},{"$f":"VLOOKUP(A126,'2017'!C$4:J$257,8,FALSE)","v":27},0,{"$f":"VLOOKUP(A126,'2017'!C$4:J$257,7,FALSE)","v":81},0]
["R4KDLC2","Dual Light Control Module",{"$f":"'R5K Details'!J77","v":0},{"$f":"VLOOKUP(A127,'2017'!C$4:J$257,8,FALSE)","v":45},0,{"$f":"VLOOKUP(A127,'2017'!C$4:J$257,7,FALSE)","v":135},0]
["R4KTVA","TV Adapter pigtail kit (Set of 10)",{"$f":"'R5K Details'!J78","v":0},{"$f":"VLOOKUP(A128,'2017'!C$4:J$257,8,FALSE)","v":14},0,{"$f":"VLOOKUP(A128,'2017'!C$4:J$257,7,FALSE)","v":42},0]
["R4KTVR1","Digital TV Isolation Module",{"$f":"'R5K Details'!J79","v":0},{"$f":"VLOOKUP(A129,'2017'!C$4:J$257,8,FALSE)","v":18},0,{"$f":"VLOOKUP(A129,'2017'!C$4:J$257,7,FALSE)","v":54},0]
["NC4JACK","1/4\" Jack Auxiliary Input Station",{"$f":"'R5K Details'!J132","v":0},{"$f":"VLOOKUP(A130,'2017'!C$4:J$257,8,FALSE)","v":78},0,{"$f":"VLOOKUP(A130,'2017'!C$4:J$257,7,FALSE)","v":195},0]
["NCBED","37-pin Feature Bed Receptacle",{"$f":"'R5K Details'!J133","v":0},{"$f":"VLOOKUP(A131,'2017'!C$4:J$257,8,FALSE)","v":58},0,{"$f":"VLOOKUP(A131,'2017'!C$4:J$257,7,FALSE)","v":145},0]
["NCC37","37-pin Feature Bed Cable",{"$f":"'R5K Details'!J134","v":0},{"$f":"VLOOKUP(A132,'2017'!C$4:J$257,8,FALSE)","v":63},0,{"$f":"VLOOKUP(A132,'2017'!C$4:J$257,7,FALSE)","v":158},0]
["NCC37RA","37-pin Feature Bed Cable -Right Angle",{"$f":"'R5K Details'!J135","v":0},{"$f":"VLOOKUP(A133,'2017'!C$4:J$257,8,FALSE)","v":63},0,{"$f":"VLOOKUP(A133,'2017'!C$4:J$257,7,FALSE)","v":158},0]
["NCLV120","Low Voltage Lighting Control 120V",{"$f":"'R5K Details'!J136","v":0},{"$f":"VLOOKUP(A134,'2017'!C$4:J$257,8,FALSE)","v":85},0,{"$f":"VLOOKUP(A134,'2017'!C$4:J$257,7,FALSE)","v":213},0]
["350008","Clear Station Cover (1 & 2 Button Stations)",{"$f":"'R5K Details'!J119","v":0},{"$f":"VLOOKUP(A135,'2017'!C$4:J$257,8,FALSE)","v":25},0,{"$f":"VLOOKUP(A135,'2017'!C$4:J$257,7,FALSE)","v":63},0]
[]
["R4KCSC","Clear Station Cover",null,{"$f":"VLOOKUP(A137,'2017'!C$4:J$257,8,FALSE)","v":28},{"$f":"D137*C137","v":0},{"$f":"VLOOKUP(A137,'2017'!C$4:J$257,7,FALSE)","v":70},{"$f":"F137*C137","v":0}]
["R4KSTR","Strain Relief Kit",{"$f":"'R5K Details'!J165","v":0},{"$f":"VLOOKUP(A138,'2017'!C$4:J$257,8,FALSE)","v":22},0,{"$f":"VLOOKUP(A138,'2017'!C$4:J$257,7,FALSE)","v":55},{"$f":"F138*C138","v":0}]
["R4KWM22","Wall Mount Kit for Annunciate Panel",0,{"$f":"VLOOKUP(A139,'2017'!C$4:J$257,8,FALSE)","v":81},0,{"$f":"VLOOKUP(A139,'2017'!C$4:J$257,7,FALSE)","v":243},0]
["R4KDM22","Desk Mount Kit",0,{"$f":"VLOOKUP(A140,'2017'!C$4:J$257,8,FALSE)","v":63},0,{"$f":"VLOOKUP(A140,'2017'!C$4:J$257,7,FALSE)","v":189},0]
["R4KHVK","R4K 250v Kit For NC2828",{"$f":"'R5K Details'!J121","v":0},{"$f":"VLOOKUP(A141,'2017'!C$4:J$257,8,FALSE)","v":116},{"$f":"D141*C141","v":0},{"$f":"VLOOKUP(A141,'2017'!C$4:J$257,7,FALSE)","v":290},{"$f":"F141*C141","v":0}]
["CLS103","3 Lamp High Security Dome Lite",{"$f":"'R5K Details'!J122","v":0},{"$f":"VLOOKUP(A142,'2017'!C$4:J$257,8,FALSE)","v":92},{"$f":"D142*C142","v":0},{"$f":"VLOOKUP(A142,'2017'!C$4:J$257,7,FALSE)","v":276},{"$f":"F142*C142","v":0}]
["R5KPADP","R5K Adapter Plates (10)",{"$f":"'R5K Details'!J117","v":0},{"$f":"VLOOKUP(A143,'2017'!C$4:J$257,8,FALSE)","v":37},{"$f":"D143*C143","v":0},{"$f":"VLOOKUP(A143,'2017'!C$4:J$257,7,FALSE)","v":111},{"$f":"F143*C143","v":0}]
["350026","R5 & R4K Single Gang Adapter Plates",{"$f":"'R5K Details'!J118","v":0},{"$f":"VLOOKUP(A144,'2017'!C$4:J$257,8,FALSE)","v":21},{"$f":"D144*C144","v":0},{"$f":"VLOOKUP(A144,'2017'!C$4:J$257,7,FALSE)","v":53},{"$f":"F144*C144","v":0}]
[]
[]
[]
[null,null,"Subtotal (Accessories) ",null,{"$f":"SUM(E116:E135,E137:E147)","v":3645},null,{"$f":"SUM(G116:G147)","v":9126}]
[]
[]
[]
[{"$f":"A1","v":"Responder 5000 Nurse Call System "}]
["Bill of Materials - page 2 of 2"]
[null,null,null,null,"Project Name:","Project Name"]
[null,null,null,null,"Date:",{"$f":"TODAY()","v":"2018-01-11"}]
[]
["Pillow Speakers/Call Cords"]
[]
["Model # ","Description","Quantity","Price","Total"," List Price","Extended List Price"]
[]
["NCPSDSL2","Digital Pillow Speaker, 2 Lts",{"$f":"'R5K Details'!J124","v":0},{"$f":"VLOOKUP(A161,'2017'!C$4:J$257,8,FALSE)","v":110},{"$f":"D161*C161","v":0},{"$f":"VLOOKUP(A161,'2017'!C$4:J$257,7,FALSE)","v":330},{"$f":"F161*C161","v":0}]
["NCPSDSTV","Digital Pillow Speaker, TV",{"$f":"'R5K Details'!J125","v":0},{"$f":"VLOOKUP(A162,'2017'!C$4:J$257,8,FALSE)","v":110},{"$f":"D162*C162","v":0},{"$f":"VLOOKUP(A162,'2017'!C$4:J$257,7,FALSE)","v":330},{"$f":"F162*C162","v":0}]
["NCPSKPL2","Direct Access Digital PS, 2 Lt",{"$f":"'R5K Details'!J126","v":0},{"$f":"VLOOKUP(A163,'2017'!C$4:J$257,8,FALSE)","v":115},0,{"$f":"VLOOKUP(A163,'2017'!C$4:J$257,7,FALSE)","v":345},0]
["NCPSKPTV","Direct Access Digital PS, TV",{"$f":"'R5K Details'!J127","v":0},{"$f":"VLOOKUP(A164,'2017'!C$4:J$257,8,FALSE)","v":115},0,{"$f":"VLOOKUP(A164,'2017'!C$4:J$257,7,FALSE)","v":345},0]
["NCSAV","DIN Cord Saver",{"$f":"'R5K Details'!J128","v":0},{"$f":"VLOOKUP(A165,'2017'!C$4:J$257,8,FALSE)","v":17},0,{"$f":"VLOOKUP(A165,'2017'!C$4:J$257,7,FALSE)","v":43},0]
["CCDIN3","Handheld Pendent - 2 Lights (8-pin DIN)",{"$f":"'R5K Details'!J129","v":0},{"$f":"VLOOKUP(A166,'2017'!C$4:J$257,8,FALSE)","v":47},0,{"$f":"VLOOKUP(A166,'2017'!C$4:J$257,7,FALSE)","v":118},0]
["CCDIN","Call Cord - Single w/ Clip (10 ft.)",{"$f":"'R5K Details'!J130","v":282},{"$f":"VLOOKUP(A167,'2017'!C$4:J$257,8,FALSE)","v":22},{"$f":"D167*C167","v":6204},{"$f":"VLOOKUP(A167,'2017'!C$4:J$257,7,FALSE)","v":55},15510]
["CC200","Call Cord - 1/4\" Jack Call Cord w/ Clip (10ft.)",{"$f":"'R5K Details'!J131","v":0},{"$f":"VLOOKUP(A168,'2017'!C$4:J$257,8,FALSE)","v":18},0,{"$f":"VLOOKUP(A168,'2017'!C$4:J$257,7,FALSE)","v":45},0]
[null,null,"Subtotal (PS/CC) ",null,{"$f":"SUM(E161:E168)","v":6204},null,{"$f":"SUM(G161:G168)","v":15510}]
["Other"]
[]
["Model # ","Description","Quantity","Price","Total"," List Price","Extended List Price"]
[]
[{"$f":"IF('R5K Details'!B142=\"\",\"\",'R5K Details'!B142)","v":"STG"},{"$f":"IF('R5K Details'!B142=\"\",\"\",'R5K Details'!E142)","v":"WaveWare SIP to Tap Gateway"},{"$f":"'R5K Details'!J142","v":1},{"$f":"IF(F174=\"FQ\",\"FQ\",F174*F$4)","v":"FQ"},{"$f":"IF(D174=\"FQ\",\"FQ\",D174*C174)","v":"FQ"},"FQ",{"$f":"IF(F174=\"FQ\",\"FQ\")","v":"FQ"}]
[{"$f":"IF('R5K Details'!B143=\"\",\"\",'R5K Details'!B143)","v":"SPS-5V9E"},{"$f":"IF('R5K Details'!B143=\"\",\"\",'R5K Details'!E143)","v":"WaveWare Paging Transmitter for STG, 5W, Site Licensing "},{"$f":"'R5K Details'!J143","v":1},"FQ",{"$f":"IF(D175=\"FQ\",\"FQ\",D175*C175)","v":"FQ"},"FQ",{"$f":"IF(F175=\"FQ\",\"FQ\")","v":"FQ"}]
[{"$f":"IF('R5K Details'!B144=\"\",\"\",'R5K Details'!B144)","v":"0250-1250  "},{"$f":"IF('R5K Details'!B144=\"\",\"\",IF('R5K Details'!A144<>\"Rauland\",'R5K Details'!E144,\"\"))","v":"WaveWare Responder 5000 Messaging Server  "},{"$f":"'R5K Details'!J144","v":1},"FQ","FQ","FQ","FQ"]
[{"$f":"IF('R5K Details'!B145=\"\",\"\",'R5K Details'!B145)","v":"0250-1003  "},{"$f":"IF('R5K Details'!B145=\"\",\"\",IF('R5K Details'!A145<>\"Rauland\",'R5K Details'!E145,\"\"))","v":"WaveWare 10 User Account Bundle (app licenses)"},{"$f":"'R5K Details'!J145","v":10000},"FQ","FQ","FQ","FQ"]
[{"$f":"IF('R5K Details'!B146=\"\",\"\",'R5K Details'!B146)","v":""},{"$f":"IF('R5K Details'!B148=\"\",\"\",IF('R5K Details'!A148<>\"Rauland\",'R5K Details'!E148,\"\"))","v":""},{"$f":"'R5K Details'!J146","v":0},{"$f":"IF(F178=\"FQ\",\"FQ\",F178*F$4)","v":0},{"$f":"IF(D178=\"FQ\",\"FQ\",(C178*D178))","v":0},{"$f":"VLOOKUP(A178,'2017'!C$4:J$257,7,FALSE)","v":0},{"$f":"IF(F178=\"FQ\",\"FQ\",F178*C178)","v":0}]
[{"$f":"IF('R5K Details'!B147=\"\",\"\",'R5K Details'!B147)","v":""},{"$f":"IF('R5K Details'!B149=\"\",\"\",IF('R5K Details'!A149<>\"Rauland\",'R5K Details'!E149,\"\"))","v":""},{"$f":"'R5K Details'!J147","v":0},0,0,{"$f":"VLOOKUP(A179,'2017'!C$4:J$257,7,FALSE)","v":0},{"$f":"IF(F179=\"FQ\",\"FQ\",F179*C179)","v":0}]
[{"$f":"IF('R5K Details'!B148=\"\",\"\",'R5K Details'!B148)","v":""},{"$f":"IF('R5K Details'!B150=\"\",\"\",IF('R5K Details'!A150<>\"Rauland\",'R5K Details'!E150,\"\"))","v":""},{"$f":"'R5K Details'!J148","v":0},0,0,{"$f":"VLOOKUP(A180,'2017'!C$4:J$257,7,FALSE)","v":0},0]
[{"$f":"IF('R5K Details'!B149=\"\",\"\",'R5K Details'!B149)","v":""},{"$f":"IF('R5K Details'!B151=\"\",\"\",IF('R5K Details'!A151<>\"Rauland\",'R5K Details'!E151,\"\"))","v":""},{"$f":"'R5K Details'!J149","v":0},0,0,{"$f":"VLOOKUP(A181,'2017'!C$4:J$257,7,FALSE)","v":0},0]
[null,null,null,null,null,null,0]
[null,"Subtotal (Other) ",null,null,{"$f":"SUM(E174:E182)","v":0},"list total",{"$f":"SUM(G174:G182)","v":0}]
[]
["Bio-Seals"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
["350011","Bio-seals - Cancel Button (10)",{"$f":"'R5K Details'!J139","v":0},{"$f":"VLOOKUP(A189,'2017'!C$4:J$257,8,FALSE)","v":11},{"$f":"D189*C189","v":0},{"$f":"VLOOKUP(A189,'2017'!C$4:J$257,7,FALSE)","v":28},{"$f":"F189*C189","v":0}]
["350012","Bio-seals- Small Push-Button (10) ",{"$f":"'R5K Details'!J140","v":0},{"$f":"VLOOKUP(A190,'2017'!C$4:J$257,8,FALSE)","v":11},{"$f":"D190*C190","v":0},{"$f":"VLOOKUP(A190,'2017'!C$4:J$257,7,FALSE)","v":28},{"$f":"F190*C190","v":0}]
["350013","Bio-seals- Large Push-Button (10) ",{"$f":"'R5K Details'!J141","v":0},{"$f":"VLOOKUP(A191,'2017'!C$4:J$257,8,FALSE)","v":15},0,{"$f":"VLOOKUP(A191,'2017'!C$4:J$257,7,FALSE)","v":38},0]
["350014","Bio-seals- Left side Pt Stn (10) ",null,{"$f":"VLOOKUP(A192,'2017'!C$4:J$257,8,FALSE)","v":17},0,{"$f":"VLOOKUP(A192,'2017'!C$4:J$257,7,FALSE)","v":43},0]
["350015","Bio-seals- Right side Pt.Stn (10) ",null,{"$f":"VLOOKUP(A193,'2017'!C$4:J$257,8,FALSE)","v":17},0,{"$f":"VLOOKUP(A193,'2017'!C$4:J$257,7,FALSE)","v":43},0]
["350016","Bio-seals- Staff Terminal LCD (5)",null,{"$f":"VLOOKUP(A194,'2017'!C$4:J$257,8,FALSE)","v":30},0,{"$f":"VLOOKUP(A194,'2017'!C$4:J$257,7,FALSE)","v":75},0]
[null,null,"Subtotal (Bio-Seal) ",null,{"$f":"SUM(E189:E194)","v":0},null,{"$f":"SUM(G189:G194)","v":0}]
[]
[]
["Labor/Cable"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
[null,"Cable","cable hours",{"$f":"'R5K Details'!O175","v":536},null,"Total cable price",{"$f":"Labor_Installation!K6","v":0}]
[null,"labor","R5K Shop",{"$f":"'R5K Details'!O150","v":0},"R5K field hours",{"$f":"'R5K Details'!Q150","v":839.8},{"$f":"Labor_Installation!K7","v":0}]
[null,"misc",null,null,null,null,{"$f":"Labor_Installation!K8","v":0}]
[null,"Total R5K equipment dist net",null,null,null,null,{"$f":"E100+E110+E148+E169+E183+E195","v":147424}]

{"sheet":"Revision History","index":5,"n_rows":80,"n_cols":2,"rows_kept":80,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Release Notes of AutoQuote Program"]
["Version  ","Changes Included"]
[]
["Version 1.31","1. Corrected calculation of R5KL2KA"]
[]
["Version 1.30","1. Corrected R5KSDTY input from Auto Config tab."]
[]
["Version 1.29","1. Corrected calculations for the CLA246 and CLAR46."]
[]
["Version 1.28","1. Added the CLA246 and CLAR46."]
[]
["Version 1.27","1. Corrected Pricing of Other items"]
[null,"2. Changed format of dropdown boxes on Input for Auto Config tab"]
[]
["Version 1.26","1. Added the RNC"]
[]
["Version 1.25","1. Edited device names/descriptions to fit in columns better"]
[]
["Version 1.24","1. Corrected SIP Telephony Integration calculation."]
[null,"2. Corrected number of servers needed for Reports and SIP Integration."]
[]
["Version 1.23","1. Corrected distributor discount displayed on Order tab."]
[]
["Version 1.22","1. Added the R5K Messaging App."]
[]
["Version 1.21","1. Corrected calculation of 351102"]
[null,"2. Final prices loaded."]
[]
["Version 1.20","1. Added the 351102 Head End Cabinet"]
[]
["Version 1.19","1. Corrected power calculations for L2KA."]
[]
["Version 1.18","1. Shifted CL before stations in Order list"]
[]
["Version 1.17","1. Changed all connectors to 350018 except R4KFB1."]
[null,"2. Power calculations of R5K devices corrected."]
[null,"3. Corrected 350008 showing the CSC in order."]
[]
["Version 1.16","1. Include Fiber Adapter"]
[null,"2. Correct Calculations of R5K Termination Board."]
[null,"3. Include Fiber Adapters"]
[null,"4. correct cables pricing and calculation area"]
[null,"5. Corrected cable calculation to be viewable. Corrected field labor calculations."]
[]
[]
["Version 1.15","1. Included R4KSTAC test cable."]
[]
["Version 1.14","1. Corrected data validation and calculation of PA25."]
[]
["Version 1.13","1. included R4KWM22 for Ann panel"]
[]
["Version 1.12","1. Corrected Server MSRP"]
[null,"2. Removed original R4K items"]
[null,"3. corrected MSC calculation"]
[]
["Version 1.11","1. Updated connector count for MQC, MST, R5CONS"]
[null,"2. Corrected MRPT and SDTY part numbers"]
[]
["Version 1.10","1. Added R4K single adapter plates"]
[]
[]
["Version 1.9","1. Corrected L2KA calculations."]
[null,"2. Corrected SMA fee to just RSS."]
[]
["Version 1.8","1. Corrected pricing calculations"]
[]
["Version 1.7","1. Updated pricing."]
[null,"2. Updated server specs to reference correct document."]
[]
["Version 1.6","1. Corrected calculations of SIP server, PA25, WaveWare STG"]
[]
["Version 1.5","1. Edited macros."]
[null,"1. Corrected MSC calculations with MQC and loading."]
[]
["Version 1.4","1. Corrected Additional item calculation"]
[]
["Version 1.3","1. Added Responder SIP Server"]
[null,"2. Updated Order for SIP Server and Additional Items."]
[]
["Version 1.2","1. Updated connector count."]

{"sheet":"2017","index":6,"n_rows":263,"n_cols":10,"rows_kept":263,"cut":false,"hidden":true,"merged":[]}
["THIS DOCUMENT IS FOR INTERNAL USE ONLY. DO NOT DISTRIBUTE",null,""]
["Pricelist","FY 2018 Item Class","Model #","Description","Warranty","Carton Qty","FY 2018 \nSuggested List \nPrice $US","FY 2018 \nDistributor Net \nPrice $US","FY 2018 \nSuggested List \nPrice $Intl","FY 2018 \nDistributor Net \nPrice $Intl"]
[null,5,"301103","Universal Wireless Wall Unit",60,null,{"$f":"IFERROR(ROUNDUP(H3*2.5,0),\"\")","v":358},143,{"$f":"IFERROR(ROUNDUP(J3*2.5,0),\"\")","v":340},136]
["HC",5,"301200","Wireless Bed Unit-Socket (HR)",60,null,378,151,363,145]
["HC",5,"301210","Wireless Bed Unit-Plug (Stryker)",60,null,378,151,363,145]
["HC",5,"301300","Wireless Bed Interface-Demo",12,null,1030,412,1030,412]
["HC",5,"350000","R5 Demo Kit",12,null,34420,13768,34420,13768]
["HC",5,"350002","L-net T-tap Module (25)",18,null,653,261,643,257]
["HC",5,"350003","L-net Term Resistor (10)",18,null,560,224,540,216]
["HC",5,"350004","L-net Hub",18,null,383,153,298,119]
["HC",5,"350005","M-net Divider Interface",18,null,85,34,65,26]
["HC",5,"350014","Overlay Kit Left Side Stn (10)",18,null,53,21,43,17]
["HC",5,"350015","Overlay Kit Right Side Stn(10)",18,null,53,21,43,17]
["HC",5,"350016","Overlay Kit Staff Term Lcd (5)",18,null,80,32,75,30]
["HC",5,"350017","L-net T-tap Insulator (25)",18,null,78,31,53,21]
["HC",5,"350019","Responder 5 L-net Test Adapter",18,null,85,34,70,28]
["HC",5,"350022","Clear Button Cover For 353001",18,null,48,19,43,17]
["HC",5,"350023","Clear Button Cover-4 Button S",18,null,65,26,65,26]
["HC",5,"350024","Pillow Spker Cord Grip Kit 20",18,null,83,33,83,33]
["HC",5,"350026","1-gang Adapter Plates (10)",18,null,58,23,53,21]
["HC",5,"350030","Demo Panel Large R5",12,null,2128,851,2118,847]
["HC",5,"350031","Demo Panel Small R5",12,null,1890,756,1880,752]
["HC",5,"350100","Call Cord W/tilt Release Din",24,null,80,32,80,32]
["HC",5,"350200","Enhncd Pillow Spkr-tv-digi Vol",24,null,313,125,313,125]
["HC",5,"350201","Enhncd Pillowspkr-1lgt-digivol",24,null,313,125,313,125]
["HC",5,"350202","Enhncd Pillowspkr-2lgt-digivol",24,null,313,125,313,125]
["HC",5,"350205","Enhncd Pillow Spkr-tv-anlgvol",24,null,313,125,313,125]
["HC",5,"350206","Enhanced Pillow Spkr 1 Light",24,null,313,125,313,125]
["HC",5,"350207","Enhncd Pillowspkr 2 Lgt-anlgvo",24,null,313,125,313,125]
["HC",5,"350220","Std Pillow Spkr-tv-digi Vol",24,null,313,125,313,125]
["HC",5,"350221","Std Pillow Spkr-1 Lgt-digi Vol",24,null,313,125,313,125]
["HC",5,"350222","Std Pillowspkr-2 Lgt-digi Vol",24,null,313,125,313,125]
["HC",5,"350225","Std Pillow Spkr-tv-anlg Vol",24,null,313,125,313,125]
["HC",5,"350226","Std Pillowspkr-1 Lgt-anlg Vol",24,null,313,125,313,125]
["HC",5,"350227","Std Pillowspkr-2 Lgt-anlg Vol\\",24,null,313,125,313,125]
["HC",5,"350240","Basic Pillow Speaker-tv",24,null,213,85,213,85]
["HC",5,"350241","Basic Pillow Speaker-1 Light",24,null,195,78,195,78]
["HC",5,"350242","Basic Pillow Speaker-2 Lights",24,null,213,85,213,85]
["HC",5,"350300","Remote Tilt Release Din Stn",60,null,255,102,205,82]
["HC",5,"350301","Remote Std 8-pin Din Station",60,null,335,134,220,88]
["HC",5,"350302","Feature Bed Control Module",60,null,193,77,185,74]
["HC",5,"351001","Branch Regional Controller V2",60,null,1860,744,1745,698]
["HC",5,"351002","Responder Ntwrk Adapter Module",60,null,11685,4674,11573,4629]
["HC",5,"351003","Power Supply W/batt. Backup",60,null,1318,527,1293,517]
["HC",5,"351004","8 Port Ethernet Switch W/poe",60,null,1268,507,1145,458]
["HC",5,"351006","Fiber Optic Adapter Module",60,null,643,257,510,204]
["HC",5,"351010","Responder Network Concentrator",60,null,12228,4891,12108,4843]
["HC",5,"351101","Rack Mount Kit For Switches",60,null,113,45,110,44]
["HC",5,"351102","Wall Mounting Cabinet-head-end",60,null,1190,476,1145,458]
["HC",5,"351201","Console Receptacle",60,null,128,51,93,37]
["HC",5,"351203","Console Desk Stand",60,null,180,72,158,63]
["HC",5,"351205","VoIP Nurse Console V2",60,null,2083,833,2113,845]
["HC",5,"351310","VoIP Staff Terminal V2",60,null,1613,645,1635,654]
["HC",5,"352000","Corridor Light - 4 Pos",60,null,673,269,670,268]
["HC",5,"352004","Mini-corridor Light",60,null,178,71,168,67]
["HC",5,"352010","Corridor Light - 4 Pos V2",60,null,605,242,613,245]
["HC",5,"352021","Domeless Controller v2",60,null,638,255,613,245]
["HC",5,"353000","Single Patient Station",60,null,560,224,540,216]
["HC",5,"353001","Enhanced Single Patient Stn",60,null,638,255,613,245]
["HC",5,"353010","Dual Patient Station",60,null,683,273,655,262]
["HC",5,"353100","Duty Station",60,null,553,221,533,213]
["HC",5,"353101","Staff Station",60,null,568,227,515,206]
["HC",5,"353200","Remote Audio Output Station",60,null,423,169,405,162]
["HC",5,"353201","Remote Audio Output Module",60,null,368,147,315,126]
["HC",5,"354000","Pull-cord Station With Audio",60,null,378,151,363,145]
["HC",5,"354001","Pull-cord Station",60,null,173,69,153,61]
["HC",5,"354010","Cancel Station",60,null,{"$f":"IFERROR(ROUNDUP(H67*2.5,0),\"\")","v":178},71,{"$f":"IFERROR(ROUNDUP(J67*2.5,0),\"\")","v":173},69]
["HC",5,"354011","Code Station",60,null,178,71,173,69]
["HC",5,"354012","Staff Assist Station",60,null,178,71,173,69]
["HC",5,"354015","Staff Assist / Code Station",60,null,185,74,178,71]
["HC",5,"354016","Bed Management Station",60,null,238,95,228,91]
["HC",5,"354017","Staff Registration Station",60,null,238,95,228,91]
["HC",5,"354018","2-jack Station",60,null,253,101,205,82]
["HC",5,"354100","Input Module - 2 Point",60,null,213,85,170,68]
["HC",5,"354101","Output Module-high Current",60,null,270,108,235,94]
["HC",5,"354102","Output Module-Dry Contact",60,null,228,91,185,74]
["HC",5,"354103","Output Module-Low Current",60,null,233,93,188,75]
["HC",5,"355000","R5ware Firmware Diagnostics",12,null,0,0,0,0]
["HC",5,"NC2828","Head-End Equipment Cabinet",60,null,1748,699,1680,672]
["HC",5,"NC4JACK","Auxiliary 4 Alarm Input Station",18,null,203,81,195,78]
["HC",5,"NCBED5","R5 Feature Bed Recep - 37 Pin",18,null,158,63,158,63]
["HC",10,"355002","Interface-Telephone-25 Beds",12,null,2413,965,2318,927]
["HC",10,"355005","Responder SIP Server",12,null,4125,1650,4125,1650]
["HC",10,"356000","Responder 5 Demo Laptop",0,null,8813,3525,8940,3576]
["HC",10,"366102","PC Console (R5 Apps) - 25 Beds",12,null,2413,965,2318,927]
["HC",10,"366104","Staff Assignment Client-25 Beds",12,null,2413,965,2318,927]
["HC",10,"366200","Reports Manager - 25 Beds",12,null,2413,965,2318,927]
["HC",10,"366401","Interface-Location (RTLS)-25 Beds",12,null,2413,965,2318,927]
["HC",10,"366402","Interface-HL7(ADT)-25 Beds",12,null,2413,965,2318,927]
["HC",10,"366403","Interface-Resp Sync-25 Beds",12,null,2413,965,2318,927]
["HC",10,"366404","All Touch EMR - 25 beds",12,null,2413,965,2318,927]
["HC",10,"366406","All Touch Bed Mgmt-25 Beds",12,null,2413,965,2318,927]
["HC",10,"366407","All Touch Iptv-25 Beds",12,null,1208,483,1188,475]
["HC",10,"366409","All Touch Bed Info - 25 Beds",12,null,1208,483,1188,475]
["HC",10,"366405-1","All Touch Wire.wkflw #1-25 Bed",12,null,1208,483,1188,475]
["HC",10,"366405-2","All Touch Wire.wkflw #2-25 Bed",12,null,1208,483,1188,475]
["HC",10,"366408-1","All Touch Med Devices-25 Beds",12,null,1208,483,1188,475]
["HC",10,"366408-2","All Touch Med Devices-25 Beds",12,null,1208,483,1188,475]
["HC",10,"R5KMRPT","R5K Application Module",12,null,{"$f":"IFERROR(ROUNDUP(H99*3,0),\"\")","v":9000},3000,{"$f":"IFERROR(ROUNDUP(J99*3,0),\"\")","v":9000},3000]
["HC",10,"R5KMSIP","R5K Telephony Interface",12,null,{"$f":"IFERROR(ROUNDUP(H100*3,0),\"\")","v":5175},1725,{"$f":"IFERROR(ROUNDUP(J100*3,0),\"\")","v":5175},1725]
["HC",11,"350006","Crimping Tool Adapter",12,null,{"$f":"IFERROR(ROUNDUP(H101*2.5,0),\"\")","v":88},35,{"$f":"IFERROR(ROUNDUP(J101*2.5,0),\"\")","v":83},33]
["HC",11,"350007","Station Removal Tool",12,null,50,20,40,16]
["HC",11,"350008","Clear Station Cover",18,null,68,27,63,25]
["HC",11,"350009","351003 Battery Kit",18,null,118,47,110,44]
["HC",11,"350011","Overlay Kit Cancel Button (10)",18,null,28,11,28,11]
["HC",11,"350012","Overlay Kit Sm Push Button(10)",18,null,30,12,28,11]
["HC",11,"350013","Overlay Kit Lg Push Button(10)",18,null,40,16,38,15]
["HC",11,"350018","8pn Inlinecon Cat-5 Cat-6(100)",18,null,368,147,338,135]
["HC",11,"350025","3-gang Adapter Plates (10)",18,null,78,31,85,34]
["HC",11,"CC200","Call Cord w/Clip - 10FT",24,null,45,18,45,18]
["HC",11,"CCDIN","Call Cord - Din Connector",24,null,55,22,55,22]
["HC",11,"CCDIN3","Handheld Pendant W/2 Lights",24,null,118,47,118,47]
["HC",11,"CM300","Chassis Fault Monitor",18,null,385,154,363,145]
["HC",11,"CP7385","Pushbutton for 1/4\" Jack",18,null,50,20,50,20]
["HC",11,"DP300","Dummy Plug for DIN Jacks",18,null,10,4,10,4]
["HC",11,"DP7380","Dummy Plug for 1/4",18,null,10,4,10,4]
["HC",11,"DTP4401","DIN-to-Plug Adapter",18,null,40,16,40,16]
["HC",11,"NCBED","Feature Bed Receptacle - 37 pin",18,null,145,58,145,58]
["HC",11,"NCC37","Feature Bed Cable - 8ft",18,null,158,63,158,63]
["HC",11,"NCC37RA","Feature Bed Cable - Right Angle",18,null,158,63,158,63]
["HC",11,"NCLV120","Low Volt Lt Control - 120V",18,null,213,85,213,85]
["HC",11,"NCLV240","Low Volt Lt Control - 240V",18,null,213,85,213,85]
["HC",11,"NCSAV","DIN Cord Saver",18,null,43,17,43,17]
["HC",11,"PM300","Power Fault Monitor",18,null,353,141,343,137]
["HC",11,"R4KHVK","250v Kit For Nc2828",null,null,303,121,290,116]
["HC",14,"CLA214D","R4k 4 Bulb Audio Duty Cl",60,null,480,192,455,182]
["HC",14,"CLA222","R4k 2 Bulb/6 Pt Audio Cl",60,null,345,138,325,130]
["HC",14,"CLA246","R4k 4 Bulb/6 Pt Audio Cl",60,null,430,172,408,163]
["HC",14,"CLAR46","R4k 4 Pt Audio Relay Kit",60,null,133,53,128,51]
["HC",14,"CLV122","R4k 2 Bulb/6 Pt Visual Cl",60,null,250,100,235,94]
["HC",14,"CLV144","R4k 4 Bulb/6 Pt Visual Cl",60,null,285,114,270,108]
["HC",14,"DCA200","R4k Audio 6 Pt Domeless Cntl",60,null,365,146,343,137]
["HC",14,"DCA214D","R4k Audio Domeless Duty Cntl",60,null,403,161,383,153]
["HC",14,"DCA216","R4k 16 Pt Audio Domeless Cntl",60,null,455,182,430,172]
["HC",14,"DCV100","R4k 6 Pt Visual Domeless Cntl",60,null,280,112,265,106]
["HC",14,"DCV116","R4k 16 Pt Visual Domeless Cntl",60,null,405,162,385,154]
["HC",14,"R4K11V","R4k Visual Single Call St",60,null,98,39,95,38]
["HC",14,"R4K12A","R4k Audio Single Call St",60,null,105,42,103,41]
["HC",14,"R4K12AHZ","R4k Horiz'l Single Audio St",60,null,113,45,108,43]
["HC",14,"R4K13VA","R4k Enh Audio Single Call St",60,null,215,86,203,81]
["HC",14,"R4K13VAHZ","R4k Horiz'l Enh Sgle Audio St",60,null,218,87,205,82]
["HC",14,"R4K14SA","R4k Single Call St - W/emer",60,null,140,56,130,52]
["HC",14,"R4K16LV","R4k Sgl Visual Lgt Ctl Call St",60,null,173,69,163,65]
["HC",14,"R4K21V","R4k Dual Visual Call St",60,null,130,52,125,50]
["HC",14,"R4K22A","R4k Dual Audio Call St",60,null,143,57,133,53]
["HC",14,"R4K23VA","R4k Enh Dual Audio Call St",60,null,268,107,253,101]
["HC",14,"R4K4020","R4k Lcd Console",60,null,1870,748,1770,708]
["HC",14,"R4KBK400","R4k Battery Back-up Kit",60,null,623,249,593,237]
["HC",14,"R4KCB12","R4k Code Button Station",60,null,103,41,98,39]
["HC",14,"R4KCNCL","R4k Cancel Station",60,null,88,35,83,33]
["HC",14,"R4KCONN8","R4k 8-pin Connectors - 100",18,null,518,207,490,196]
["HC",14,"R4KCSC","R4k Clear Station Cover",18,null,73,29,70,28]
["HC",14,"R4KDTY2","R4k Slim Duty St",60,null,150,60,143,57]
["HC",14,"R4KDY","R4k Duty Station",60,null,150,60,143,57]
["HC",14,"R4KESR","R4k Emer / Staff Register St",60,null,113,45,108,43]
["HC",14,"R4KNIM","R4k Network Interface Module",60,null,3088,1235,2870,1148]
["HC",14,"R4KOUT4R","R4k Visual Relay Output Cntl",60,null,110,44,103,41]
["HC",14,"R4KOUT4S","R4k Audio Ss Output Cntl",60,null,130,52,125,50]
["HC",14,"R4KPB11","R4k Push For Help Button St",60,null,98,39,90,36]
["HC",14,"R4KPB22","R4k Dual Push Button St",60,null,118,47,113,45]
["HC",14,"R4KPB44","R4k Four Button Status St",60,null,135,54,128,51]
["HC",14,"R4KPC10","R4k Pull Cord St",60,null,88,35,85,34]
["HC",14,"R4KPIP","R4k Peripheral Interface Port",60,null,3120,1248,2903,1161]
["HC",14,"R4KPLI","R4k Phone Line Interface",60,null,3973,1589,3768,1507]
["HC",14,"R4KPR400","R4k Power Supply",60,null,{"$f":"IFERROR(ROUNDUP(H165*2.5,0),\"\")","v":875},350,{"$f":"IFERROR(ROUNDUP(J165*2.5,0),\"\")","v":830},332]
["HC",14,"R4KRSPIP","R4k Reporting Sftw Interface",60,null,8500,3400,8000,3200]
["HC",14,"R4KSPA","R4k Serial Peripheral Adapter",60,null,565,226,535,214]
["HC",14,"R4KSR1","R4k Staff Register St",60,null,83,33,80,32]
["HC",14,"R4KSS","R4k Staff  Station",60,null,110,44,103,41]
["HC",14,"R4KSTR","R4k Strain Relief Kit",18,null,58,23,55,22]
["HC",14,"R4KTMB","R4k K-bus Termination Board",60,null,163,65,155,62]
["HC",14,"R4KWARE","R4k System Software Cd-rom",12,null,4200,1680,4080,1632]
["HC",14,"R4KWM11","R4k Console Wall Mount Kit",18,null,365,146,348,139]
["HC",14,"R4KXBA","R4k X-bus Adapter",60,null,10733,4293,10118,4047]
["HC",20,"CLS103","R5K High Security Dome Lite 3 Lamp",18,null,{"$f":"IFERROR(ROUNDUP(H175*3,0),\"\")","v":261},87,{"$f":"IFERROR(ROUNDUP(J175*3,0),\"\")","v":276},92]
["HC",20,"HSS400","R5K High Security Audio Bed St",18,null,774,258,774,258]
["HC",20,"HSS401","R5K High Security Staff St",18,null,774,258,774,258]
["HC",20,"HSS433","R5K High Security Push Btn St",18,null,774,258,774,258]
["HC",20,"NCPSDSL2","R5K Digital Pillow Speaker 2 Lights",24,null,330,110,330,110]
["HC",20,"NCPSDSTV","R5K Digital Pillow Speaker TV Only",24,null,330,110,330,110]
["HC",20,"NCPSKPL2","R5K Direct Access Pillow Speaker 2 Lights",24,null,345,115,345,115]
["HC",20,"NCPSKPTV","R5K Direct Access Pillow Speaker TV Only",24,null,345,115,345,115]
["HC",20,"R4K15V","R5K Patient Station w 1/4\" Jack & Button",60,null,120,40,123,41]
["HC",20,"R4K17V","R5K Enhanced Single Patient Stn w/DIN",60,null,186,62,186,62]
["HC",20,"R4K2JACK","R5K Dual 1/4\" Jack Station",60,null,135,45,135,45]
["HC",20,"R4KANNV2","R5K Annunciator Panel v2",60,null,825,275,882,294]
["HC",20,"R4KCAL","R5K Call Assurance Light",60,null,75,25,81,27]
["HC",20,"R4KCB13","R5K Code Blue Station",60,null,102,34,102,34]
["HC",20,"R4KCONN6","R5K 6-pin Connectors - 100",18,null,483,161,486,162]
["HC",20,"R4KCRIMP","R5K Crimping Tool",60,null,60,20,60,20]
["HC",20,"R4KDLC2","R5K Dual Light Cntl Mod",60,null,123,41,135,45]
["HC",20,"R4KDM22","R5K Desk Mount Kit for ANN Panel",60,null,180,60,189,63]
["HC",20,"R4KFAM","R5K Fire/auxiliary Module",60,null,105,35,117,39]
["HC",20,"R4KFB1","R5K Feature Bed Interface",60,null,120,40,132,44]
["HC",20,"R4KKBS","R5K K-bus Splitter",60,null,39,13,42,14]
["HC",20,"R4KKBSP","R5K K-bus Splitter - With Pwr",60,null,42,14,48,16]
["HC",20,"R4KMQCV2","R5K Marquee Controller v2",60,null,465,155,507,169]
["HC",20,"R4KMST","R5K Marquee Speaker St W/mute",60,null,114,38,123,41]
["HC",20,"R4KPA25","R5K Paging Amplifier -25 Watt",60,null,762,254,858,286]
["HC",20,"R4KPB12","R5K Single Button Station",60,null,90,30,90,30]
["HC",20,"R4KPB23","R5K Staff Assist Code Station",60,null,90,30,99,33]
["HC",20,"R4KPC11","R5K Pull Cord Station",60,null,87,29,93,31]
["HC",20,"R4KRECP","R5K ANN Panel Receptacle",60,null,60,20,66,22]
["HC",20,"R4KSAR","R5K Push for Help Staff Reg Station",60,null,102,34,102,34]
["HC",20,"R4KSLC1","R5K Single Light Cntl Mod",60,null,75,25,81,27]
["HC",20,"R4KSPK","R5K Speaker Station",60,null,42,14,45,15]
["HC",20,"R4KSTAC","R5K Test Adapter Cables",60,null,120,40,129,43]
["HC",20,"R4KTVA","R5K TV Adaptor Kit Qty 10",60,null,39,13,42,14]
["HC",20,"R4KTVR1","R5K Digital Tv Isolation Mod",60,null,51,17,54,18]
["HC",20,"R4KWM22","R5K ANN Panel Wall Mount Kit",60,null,225,75,243,81]
["HC",20,"R5KCL506","R5K Corridor Light Visual 6pt",60,null,183,61,198,66]
["HC",20,"R5KCL516","R5K Corridor Light 1 Audio 6pt",60,null,222,74,237,79]
[null,20,"R5KCL546","R5K Corridor Light 4 Audio 6pt",60,null,270,90,270,90]
[null,20,"R5KCONS","R5K VoIP Nurse Console",60,null,1659,553,1836,612]
[null,20,"R5KDC016","R5K Domeless 16pt Visual ",60,null,363,121,369,123]
[null,20,"R5KDC06","R5K Domeless 6pt Visual",60,null,243,81,264,88]
[null,20,"R5KDC16D","R5K Domeless Duty 1 Audio 6pt",60,null,300,100,330,110]
[null,20,"R5KDC46","R5k Domeless 4 Audio 6pt",60,null,288,96,315,105]
[null,20,"R5KDCRC4","R5k Relay Output Controller",60,null,108,36,120,40]
[null,20,"R5KDCRCS4","R5k Ss Relay Output Controller",60,null,132,44,144,48]
[null,20,"R5KDEMO","R5K Demo CNF",60,null,18000,6000,"not for Intl","-"]
[null,20,"R5KDEMOACT","R5K Demo Acute",60,null,"not for US","-",{"$f":"IFERROR(ROUNDUP(J222*3,0),\"\")","v":18000},6000]
[null,20,"R5KL2KA","R5K L2K Adapter",60,null,{"$f":"IFERROR(ROUNDUP(H223*3,0),\"\")","v":510},170,543,181]
[null,20,"R5KLAPTOP","R5K Demo Unit Laptop",60,null,12000,4000,12000,4000]
[null,20,"R5KM8PRT","R5K 8-port Ethernet Switch",60,null,1020,340,1113,371]
[null,20,"R5KMPR15","R5K 15v Pwr Sply w Bat Backup",60,null,840,280,933,311]
[null,20,"R5KMPR36","R5K 36v Pwr Sply w Bat Backup",60,null,810,270,900,300]
[null,20,"R5KMSC","R5K Main System Controller ",60,null,1650,550,1803,601]
[null,20,"R5KMTRM","R5K Termination Board",60,null,171,57,183,61]
[null,20,"R5KPADP","R5k Adapter Plates (10)",60,null,102,34,111,37]
[null,20,"R5KPB4","R5K 4 Button Workflow Station",60,null,114,38,123,41]
[null,20,"R5KPD2A","R5K Dual Patient Station Audio",60,null,177,59,177,59]
[null,20,"R5KPD2EA","R5K Dual Enhanced Patient Station Audio",60,null,213,71,216,72]
[null,20,"R5KPS1A","R5K Single Patient Station Audio",60,null,117,39,126,42]
[null,20,"R5KPS1EA","R5K Single Enhanced Patient Station Audio",60,null,153,51,165,55]
[null,20,"R5KPS1LCA","R5K Single Patient Station w Lighting and Audio",60,null,180,60,180,60]
[null,20,"R5KPS1V","R5K Single Patient Station Visual",60,null,102,34,105,35]
[null,20,"R5KSDTY","R5K Duty Station",60,null,120,40,132,44]
[null,20,"R5KSSTF","R5K Staff Station",60,null,102,34,111,37]
[null,20,"R5KWare","R5K Configuration Software",12,null,0,0,0,0]
[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,""]

{"sheet":"DropDowns","index":7,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":true,"merged":[[30,7,30,8]]}
["R5KPD2EA - Enhnaced Dual Patient Station","R5KPD2EA"]
["R5KPS1EA - Enhanced Single Station","R5KPS1EA",null,"Yes"]
["R5KPD2A -  Dual Patient Station","R5KPD2A",null,"No",{"$f":"E2+10","v":10}]
["R5KPS1A -  Single Audio Patient Station","R5KPS1A",null,null,{"$f":"E3+10","v":20}]
["R5KPS1V -  Single Patient Visual Station","R5KPS1V",null,null,{"$f":"E4+10","v":30}]
["R5KPS1LCA -  Audio Single Patient Station with Lighting Control","R5KPS1LCA",null,null,40]
["R5KSSTF -  Staff Station","R5KSSTF",null,null,50]
["R5KSDTY -  Duty Station","R5KSDTY",null,null,60]
["R4K15V - SLIM 1/4\" Jack / Button St","R4K15V"]
["R4K17V - SLIM Enh Single Call St","R4K17V"]
["HSS400 - High Security Audio Bed Station","HSS400"]
["HSS401 - High Security  Staff Station","HSS401"]
["HSS433 - High Security Push Button Station","HSS433"]
["R5KPB4 -  4-button Workflow and Registration Station","R5KPB4"]
["R4K2JACK - SLIM Dual 1/4\" Jack St","R4K2JACK"]
["R4KCB13 - SLIM Code Button St","R4KCB13"]
["R4KPB12 - SLIM Single Button St","R4KPB12"]
["R4KPB23 - SLIM Dual Button w/ Code St","R4KPB23"]
["R4KPC11 - SLIM Pull Cord St","R4KPC11"]
["R4KSAR - SLIM Dual Button St","R4KSAR",null,null,null,null,"R5KPC11WP - Waterproof Pullcord Station","R5KPC11WP"]
["R4KSPK - SLIM Speaker Module","R4KSPK",null,null,null,null,"R5KPC11WPS - Waterproof Pullcord Station - Spanish","R5KPC11WPS"]
["NC4JACK - 1/4\" Jack Auxiliary Input Station","NC4JACK",null,null,null,null,"R5KPC11WPF - Waterproof Pullcord Station - French","R5KPC11WPF"]
["R4KFB1 - Feature Bed Interface","R4KFB1"]
["R5KCL506 - 5-Bulb, Visual Corridor Light","R5KCL506"]
["R5KCL516 - 5-Bulb, 1-Point Audio Corridor Light","R5KCL516"]
["R5KCL546 - 5-Bulb, 4-Point Audio Corridor Light ","R5KCL546"]
["R5KDC06 - 6-Point Visual Domeless Controller","R5KDC06"]
["R5KDC016 - 16-Point Visual Domeless Controller","R5KDC016"]
["R5KDC46 - 6-Point, 4-Point Audio Domeless Controller","R5KDC46"]
["R5KDC16D - 6-Point, 1 Point Audio Duty Domeless Controller","R5KDC16D"]
["CLA246 - 4Bulb/1-Point Audio R4K Corridor Light ","CLA246"]
["CLAR46 - 4 Audio Point Relay Module","CLAR46"]
[null,null,null,null,null,null,null,"Number of Bed Stations",{"$f":"SUM('R5K Details'!J30:J36,'R5K Details'!J42:J55)","v":282}]
[null,null,null,null,null,null,null,"Number of MSCs Needed (95% loading)",{"$f":"IF(I42=0,0,IF(I42<=87,1,IF(I42<=174,2,IF(I42<=261,3,IF(I42<=348,4,IF(I42<=435,5,IF(I42<=522,6,IF(I42<=609,7,IF(I42<=696,8,IF(I42<=783,9,IF(I42<=870,10,IF(I42<=957,11,IF(I42<=1044,12,0)))))))))))))","v":3}]
[null,null,null,null,null,null,null,"Number of Visual and Audio CL/DC Selected",{"$f":"SUM('R5K Details'!J83:J91)","v":363}]
[null,null,null,null,null,null,null,"Number of Audio Stations",{"$f":"SUM('R5K Details'!J30:J33,'R5K Details'!J35:J36,'R5K Details'!J54:J55,'R5K Details'!J66)","v":282}]
[null,null,null,null,null,null,null,"Number of Audio CL/DC Needed",{"$f":"I36","v":282}]
[null,null,null,null,null,null,null,"Number of Audio CL/DC Selected",{"$f":"SUM('R5K Details'!J84:J85,'R5K Details'!J90)","v":218}]
[null,null,null,null,null,null,null,"Number of Visual CL/DC Needed",{"$f":"I35-I36","v":81}]
[null,null,null,null,null,null,null,"Number of Visual CL/DC Selected",{"$f":"SUM('R5K Details'!J83,'R5K Details'!J88:J89)","v":0}]
[null,null,null,null,null,null,null,"Number Duty DC Selected",{"$f":"'R5K Details'!J91","v":3}]
[null,null,null,null,null,null,null,"Total Number of CLs/DCs Selected",{"$f":"SUM(I38,I40,I43,I41)","v":221}]
[null,null,null,null,null,null,null,"Number of Marquee controllers",{"$f":"'R5K Details'!J20","v":0}]
[null,null,null,null,null,null,null,"calculations for L2 needed",{"$f":"IF(I42=0,0,IF(I42<=24,1,IF(I42<=48,2,IF(I42<=72,3,IF(I42<=96,4,IF(I42<=120,5,IF(I42<=164,6,IF(I42<=188,7,IF(I42<=212,8,IF(I42<=236,9,IF(I42<=260,10,IF(I42<=284,11,IF(I42<=308,12,IF(I42<=332,13,IF(I42<=356,14,IF(I42<=380,15,IF(I42<=404,16,IF(I42<=428,17,IF(I42<=452,18,IF(I42>=476,12,0))))))))))))))))))))","v":9}]
[null,null,null,null,null,null,null,"calculations for L2 needed",{"$f":"IF(I42<=476,0,IF(I42<=500,1,IF(I42<=524,2,IF(I42<=548,3,IF(I42<=572,4,IF(I42<=596,5,IF(I42<=620,6,IF(I42<=644,7,IF(I42<=668,8,IF(I42<=692,9,IF(I42<=716,10,IF(I42<=740,11,IF(I42<=764,12,IF(I42<=788,13,IF(I42<=812,14,IF(I42<=836,15,IF(I42<=860,16,IF(I42<=884,17,IF(I42<=908,18,IF(I42<=932,19,IF(I42<=956,20,IF(I42<=980,21,IF(I42<=1004,22,0)))))))))))))))))))))))","v":0}]
[null,null,null,null,null,null,null,"Number of L2 Needed",{"$f":"I44+I45","v":9}]
[null,null,null,null,null,null,null,"Number of Consoles"]
[null,null,null,null,null,null,null,"Number of ANN Panels"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["R5KDCRC4 - Relay Output Control","R5KDCRC4"]
["R5KDCRCS4 - Solid State Relay Output Control","R5KDCRCS4"]
["NCPSDSL2 - Digital Pillow Speaker, 2 Lts","NCPSDSL2"]
["NCPSDSTV - Digital Pillow Speaker, TV","NCPSDSTV"]
["NCPSKPL2 - Direct Access Digital PS, 2 Lt","NCPSKPL2"]
["NCPSKPTV - Direct Access Digital PS, TV","NCPSKPTV"]
["NCSAV - DIN Cord Saver","NCSAV"]
["CCDIN - Call Cord - Single w/ Clip (10 ft.)","CCDIN"]
["CC200 - Call Cord - 1/4\" Jack Call Cord w/ Clip (10ft.)","CC200"]
["350008 - Clear Station Cover (SLIM 1 & 2 Buttons Station)","350008"]
["R4KFB1 - Feature Bed Interface","R4KFB1"]
["R4KSLC1 - Single Light Control Module","R4KSLC1"]
["R4KDLC2 - Dual Light Control Module","R4KDLC2"]
["R4KTVA - TV Adapter pigtail kit (Set of 10)","R4KTVA"]
["R4KTVR1 - Digital TV Isolation Module","R4KTVR1"]
["NCLV120 - Low Voltage Lighting Control 120V","NCLV120"]
["R4KCAL - Call Assurance Light","R4KCAL"]
["R4KFAM Fire/Auxiliary Module","R4KFAM"]