{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input for Auto Config","Labor_Installation","R5K Details","ORDER","order_hack","Revision History","2019","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":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,3,1,4],[2,3,2,4],[3,3,3,4],[34,0,34,8],[36,0,36,8],[1,1,1,2],[3,1,3,2],[33,0,33,8],[32,0,32,8],[35,0,35,8],[4,3,4,4]]}
["International Responder 5000 2019 Estimate Sheet v 1.50"]
[null,"Input Config Information",null,"Date:",null,"2022-12-26"]
[null,null,null,"Job Name:",null,"HOSPITAL SAN JAVIER"]
[null,"System Config/Intergrations/Software",null,"Distributor Name:",null,"CENCOMEX S.A."]
[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,"Display and Reporting Software  (yes or no)","Yes"]
[null,"ADT Integration - Display and Reporting software necessary (yes or no)","Yes"]
[null,"R5K Messaging App (yes or no)"]
[null,"Number of concurrent users of messaging app"]
[null,"Middleware Interface (Including SIP Cancel) (yes or no)","Yes"]
[null,"Resident Safety Interface (yes or no)","Yes"]
[]
[]
[null,"Typical Patient Room Stations/Corridor Lights (Drop Down)","Part Number","Quantity",null,"Typical Patient Room Accessories (Drop Down)","Part Number","Quantity"]
[null,"R5KCL546 - 5-Bulb, 4-Point Audio Corridor Light ",{"$f":"IF(B16<>\"\", VLOOKUP(B16, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R5KCL546"},12,null,"CCDIN - Call Cord - Single w/ Clip (10 ft.)",{"$f":"IF(F16<>\"\", VLOOKUP(F16,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":"CCDIN"},41]
[null,"R5KDC06 - 6-Point Visual Domeless Controller",{"$f":"IF(B17<>\"\", VLOOKUP(B17, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R5KDC06"},4,null,null,{"$f":"IF(F17<>\"\", VLOOKUP(F17,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,"R4KSAR - SLIM Dual Button St",{"$f":"IF(B18<>\"\", VLOOKUP(B18, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R4KSAR"},12,null,null,{"$f":"IF(F18<>\"\", VLOOKUP(F18,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,"R5KPS1A -  Single Audio Patient Station",{"$f":"IF(B19<>\"\", VLOOKUP(B19, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R5KPS1A"},41,null,null,{"$f":"IF(F19<>\"\", VLOOKUP(F19,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,"R5KPC11WPS - Waterproof Pullcord Station - Spanish",{"$f":"IF(B20<>\"\", VLOOKUP(B20, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R5KPC11WPS"},18,null,null,{"$f":"IF(F20<>\"\", VLOOKUP(F20,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,"R5KDC46 - 6-Point, 4-Point Audio Domeless Controller",{"$f":"IF(B21<>\"\", VLOOKUP(B21, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":"R5KDC46"},1,null,null,{"$f":"IF(F21<>\"\", VLOOKUP(F21,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B22<>\"\", VLOOKUP(B22, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F22<>\"\", VLOOKUP(F22,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B23<>\"\", VLOOKUP(B23, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F23<>\"\", VLOOKUP(F23,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B24<>\"\", VLOOKUP(B24, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F24<>\"\", VLOOKUP(F24,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B25<>\"\", VLOOKUP(B25, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F25<>\"\", VLOOKUP(F25,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B26<>\"\", VLOOKUP(B26, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F26<>\"\", VLOOKUP(F26,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B27<>\"\", VLOOKUP(B27, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F27<>\"\", VLOOKUP(F27,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B28<>\"\", VLOOKUP(B28, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F28<>\"\", VLOOKUP(F28,DropDowns!A$75:B$91, 2, FALSE), \"\")","v":""}]
[null,null,{"$f":"IF(B29<>\"\", VLOOKUP(B29, DropDowns!A$1:B$76, 2, FALSE), \"\")","v":""},null,null,null,{"$f":"IF(F29<>\"\", VLOOKUP(F29,DropDowns!A$75:B$91, 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'!M181","v":400},null,null,"Equipment",{"$f":"order_hack!G211","v":7676},1.7,{"$f":"I4*J4","v":13049.199999999999},null,{"$f":"K4-I4","v":5373.1999999999989}]
["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":400},1.7,{"$f":"I6*J6","v":680},null,{"$f":"K6-I6","v":280}]
[{"$f":"order_hack!D209","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'!O181","v":64},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!F209","v":61.2},0,"Est. Field Labor ",null,0,null,null,"Total -->",{"$f":"SUM(I4:I8)","v":8076},null,{"$f":"SUM(K4:K8)","v":13729.199999999999}]
[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":5653.1999999999989}]
[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":5653.1999999999989}]
[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":13729.199999999999}]
[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":125.2},"<-- 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":181,"n_cols":18,"rows_kept":181,"cut":false,"hidden":false,"merged":[[158,0,158,11],[157,0,157,11],[128,0,128,9],[5,0,5,9],[31,0,31,9],[87,0,87,9],[112,0,112,9],[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]]}
[]
[{"$f":"'Input for Auto Config'!A1:K1","v":"International Responder 5000 2019 Estimate Sheet v 1.50"},null,null,null,null,null,null,null,null,null,null,null,"Job Name:",{"$f":"'Input for Auto Config'!F3","v":"HOSPITAL SAN JAVIER"}]
["Responder 5000 System",null,null,null,null,null,null,null,null,null,null,null,"Distributor Name:",{"$f":"'Input for Auto Config'!F4","v":"CENCOMEX S.A."}]
[null,null,"Date:",null,{"$f":"'Input for Auto Config'!F2","v":"2022-12-26"},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,null,null,{"$f":"H7+I7","v":0},{"$f":"VLOOKUP(B7,'2019'!C$3:H$220,5,FALSE)","v":1680},null,null,null,{"$f":"IF(H7*N7=0,\" \",H7*N7)","v":" "},2,{"$f":"IF(H7*P7=0,\" \",H7*P7)","v":" "}]
["\"","351102",null,null,"Wall Mounting Cabinet-head-end",null,null,null,null,0,{"$f":"VLOOKUP(B8,'2019'!C$3:H$220,5,FALSE)","v":1145}]
["\"","R5KMPR15",null,null,"Power Supply 15V for Stations, CLs, DCs (w/battery backup)",null,null,1,null,1,{"$f":"VLOOKUP(B9,'2019'!C$3:H$220,5,FALSE)","v":933},null,null,null,{"$f":"IF(H9*N9=0,\" \",H9*N9)","v":" "},1,{"$f":"IF(H9*P9=0,\" \",H9*P9)","v":1}]
["\"","R5KMPR36",null,null,"Power Supply 36V for MSC, Console (w/battery backup)",null,null,1,null,{"$f":"H10+I10","v":1},{"$f":"VLOOKUP(B10,'2019'!C$3:H$220,5,FALSE)","v":900},null,null,null,{"$f":"IF(H10*N10=0,\" \",H10*N10)","v":" "},0.5,{"$f":"IF(H10*P10=0,\" \",H10*P10)","v":0.5}]
["\"","R5KMSC",null,null,"Main System Controller",null,null,1,null,{"$f":"H11+I11","v":1},{"$f":"VLOOKUP(B11,'2019'!C$3:H$220,5,FALSE)","v":1803},2,{"$f":"L11*J11","v":2},null,{"$f":"IF(H11*N11=0,\" \",H11*N11)","v":" "},6,{"$f":"IF(H11*P11=0,\" \",H11*P11)","v":6}]
["\"","351010",null,null,"Responder Network Concentrator",null,null,null,null,{"$f":"H12+I12","v":0},{"$f":"VLOOKUP(B12,'2019'!C$3:H$220,5,FALSE)","v":12107.5},null,null,null,null,null,{"$f":"IF(H12*P12=0,\" \",H12*P12)","v":" "}]
["\"","R5KM8PRT",null,null,"R5K 8-Port Switch",null,null,1,-1,{"$f":"H13+I13","v":0},{"$f":"VLOOKUP(B13,'2019'!C$3:H$220,5,FALSE)","v":1113},2.4,null,null,null,0.5,0.5]
["\"","351006",null,null,"Fiber Optic Adapter Module",null,null,null,null,{"$f":"H14+I14","v":0},{"$f":"VLOOKUP(B14,'2019'!C$3:H$220,5,FALSE)","v":510},0.75,{"$f":"L14*J14","v":0},null,null,2," "]
["\"","R5KL2KA",null,null,"Data Converter for K-Bus to L-Net",null,null,1,null,1,{"$f":"VLOOKUP(B15,'2019'!C$3:H$220,5,FALSE)","v":543},0.13,{"$f":"L15*J15","v":0.13},null,null,8,8]
["\"","R5KMRPT",null,null,"Reporting Software License (1 per system)",null,null,null,null,0,{"$f":"VLOOKUP(B16,'2019'!C$3:H$220,5,FALSE)","v":9000},null,null,null,{"$f":"IF(H16*N16=0,\" \",H16*N16)","v":" "},16,{"$f":"IF(H16*P16=0,\" \",H16*P16)","v":" "}]
[null,"R5KMADT",null,null,"ADT Integration Software License (1 per system)",null,null,null,null,0,{"$f":"VLOOKUP(B17,'2019'!C$3:H$220,5,FALSE)","v":3750},null,null,null,{"$f":"IF(H17*N17=0,\" \",H17*N17)","v":" "},16]
[null,"R5KMRSI",null,null,"Resident Safety Interface (1 per system)",null,null,null,null,0,{"$f":"VLOOKUP(B18,'2019'!C$3:H$220,5,FALSE)","v":3000}]
["\"","R5KMSIP",null,null,"SIP Telephony Software License (1 per system)",null,null,null,null,0,{"$f":"VLOOKUP(B19,'2019'!C$3:H$220,5,FALSE)","v":5175},null,null,null,null,6,{"$f":"IF(H19*P19=0,\" \",H19*P19)","v":" "}]
[null,"R5KMMWI",null,null,"Middleware Interface (1 per system)",null,null,null,null,0,{"$f":"VLOOKUP(B20,'2019'!C$3:H$220,5,FALSE)","v":5000}]
["\"","355005",null,null,"Responder SIP Server",null,null,null,null,0,{"$f":"VLOOKUP(B21,'2019'!C$3:H$220,5,FALSE)","v":4125},null,null,null,null,6,{"$f":"IF(H21*P21=0,\" \",H21*P21)","v":" "}]
["\"","R4KPA25",2,null,"Paging Amplifier",{"$f":"C22*J22","v":0},null,null,null,{"$f":"H22+I22","v":0},{"$f":"VLOOKUP(B22,'2019'!C$3:H$220,5,FALSE)","v":858},2.5,{"$f":"L22*J22","v":0},null,null,4,{"$f":"IF(H22*P22=0,\" \",H22*P22)","v":" "}]
["\"","R4KMQCV2",2,null,"Marquee Controller",{"$f":"C23*J23","v":0},null,null,null,{"$f":"I23","v":0},{"$f":"VLOOKUP(B23,'2019'!C$3:H$220,5,FALSE)","v":507},0.3,{"$f":"L23*J23","v":0},null,null,2,{"$f":"IF(J23*P23=0,\" \",J23*P23)","v":" "}]
["\"","R4KMST",2,null,"Marquee Speaker Station",{"$f":"C24*J24","v":0},null,null,null,{"$f":"I24","v":0},{"$f":"VLOOKUP(B24,'2019'!C$3:H$220,5,FALSE)","v":123},5.0000000000000001E-3,{"$f":"L24*J24","v":0},null,null,0.35," "]
["\"","R5KMTRM",8,null,"Termination Board",{"$f":"C25*J25","v":8},null,1,null,{"$f":"H25+I25","v":1},{"$f":"VLOOKUP(B25,'2019'!C$3:H$220,5,FALSE)","v":183},null,null,null,null,1,1]
["\"","R5KCONS",1,null,"VoIP Nurse Console",{"$f":"C26*J26","v":1},null,1,null,{"$f":"H26+I26","v":1},{"$f":"VLOOKUP(B26,'2019'!C$3:H$220,5,FALSE)","v":1836},0.32800000000000001,{"$f":"L26*J26","v":0.32800000000000001},null,null,2,2]
["\"","R4KTMB",14,null,"Termination Board",{"$f":"C27*J27","v":0},null,0,null,null,{"$f":"VLOOKUP(B27,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,1," "]
["\"","R4KANNV2",2,null,"Annunciate Panel (comes with a Receptacle)",0,{"$f":"D28*J28","v":0},null,null,{"$f":"I28","v":0},{"$f":"VLOOKUP(B28,'2019'!C$3:H$220,5,FALSE)","v":882},0.375,{"$f":"L28*J28","v":0},null,null,1," "]
["\"","R4KRECP",2,null,"R4K Console Receptacle",0,0,null,null,{"$f":"I29","v":0},{"$f":"VLOOKUP(B29,'2019'!C$3:H$220,5,FALSE)","v":66},null,null,null,{"$f":"IF(J29*N29=0,\" \",J29*N29)","v":" "},0.5," "]
["\"","R4KWM22",null,null,"Wall Mount Kit for Annunciate Panel",null,null,null,null,{"$f":"I30+H30","v":0},{"$f":"VLOOKUP(B30,'2019'!C$3:H$220,5,FALSE)","v":243},null,null,null,{"$f":"IF(J30*N30=0,\" \",J30*N30)","v":" "},1," "]
["\"","R4KDM22",null,null,"Desk Mount Kit",null,null,null,null,{"$f":"I31","v":0},{"$f":"VLOOKUP(B31,'2019'!C$3:H$220,5,FALSE)","v":189},null,null,null," ",1," "]
["Stations"]
["RAULAND","R5KPD2EA",4,null,"R5K Enhnaced Dual Patient Station",{"$f":"C33*J33","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B33,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B33,'2019'!C$3:H$220,5,FALSE)","v":216},1.4999999999999999E-2,{"$f":"L33*J33","v":0},null,null,0.35,{"$f":"IF(J33*P33=0,\" \",J33*P33)","v":" "}]
["\"","R5KPS1EA",2,null,"R5K Enhanced Single Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B34,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B34,'2019'!C$3:H$220,5,FALSE)","v":165},1.0999999999999999E-2,0,null,null,0.35," "]
["\"","R5KPD2A",4,null,"R5K Dual Patient Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B35,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B35,'2019'!C$3:H$220,5,FALSE)","v":177},0.01,0,null,null,0.35," "]
["\"","R5KPS1A",2,null,"R5K Single Audio Patient Station",82,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B36,'Input for Auto Config'!D$16:D$29)","v":41},null,41,{"$f":"VLOOKUP(B36,'2019'!C$3:H$220,5,FALSE)","v":126},8.0000000000000002E-3,0.32800000000000001,{"$f":"SUMIF('Input for Auto Config'!C16:C29,B36,'Input for Auto Config'!D16:D29)","v":41},null,0.35,14.35]
["\"","R5KPS1V",2,null,"R5K Single Patient Visual Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B37,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B37,'2019'!C$3:H$220,5,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$16:C$29,B38,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B38,'2019'!C$3:H$220,5,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$16:C$29,B39,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B39,'2019'!C$3:H$220,5,FALSE)","v":111},1.6E-2,0,null,null,0.35," "]
["\"","R5KSDTY",4,null,"R5K Duty Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B40,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B40,'2019'!C$3:H$220,5,FALSE)","v":132},2.7E-2,0,null,null,0.35," "]
["\"","R5KPB4",4,null,"Responder 5K 4-button Station",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B41,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B41,'2019'!C$3:H$220,5,FALSE)","v":123},1.0999999999999999E-2,0,null,{"$f":"IF(J41*N41=0,\" \",J41*N41)","v":" "},0.35," "]
["\"","R5KPB4CNF",4,null,"Responder 5K 4-button CNF Station",{"$f":"C42*J42","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B42,'Input for Auto Config'!D$16:D$29)","v":0},null,{"$f":"H42+I42","v":0},{"$f":"VLOOKUP(B42,'2019'!C$3:H$220,5,FALSE)","v":123},1.0999999999999999E-2,{"$f":"L42*J42","v":0},null,{"$f":"IF(J42*N42=0,\" \",J42*N42)","v":" "},0.35,{"$f":"IF(J42*P42=0,\" \",J42*P42)","v":" "}]
["\"","R5KCANCEL",4,null,"Responder 5K Cancel Station",{"$f":"C43*J43","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B43,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B43,'2019'!C$3:H$220,5,FALSE)","v":102},1.0999999999999999E-2,{"$f":"L43*J43","v":0},null,{"$f":"IF(J43*N43=0,\" \",J43*N43)","v":" "},0.35,{"$f":"IF(J43*P43=0,\" \",J43*P43)","v":" "}]
["\"","R5KPC11WP",2,null,"Waterproof Pullcord Station",{"$f":"C44*J44","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B44,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B44,'2019'!C$3:H$220,5,FALSE)","v":102},2E-3,0,null,{"$f":"IF(J44*N44=0,\" \",J44*N44)","v":" "},0.35," "]
["\"","R5KPC11WPS",2,null,"Waterproof Pullcord Station - Spanish",36,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B45,'Input for Auto Config'!D$16:D$29)","v":18},null,18,{"$f":"VLOOKUP(B45,'2019'!C$3:H$220,5,FALSE)","v":108},2E-3,3.6000000000000004E-2,null,null,null," "]
["\"","R5KPC11WPF",2,null,"Waterproof Pullcord Station - French",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B46,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B46,'2019'!C$3:H$220,5,FALSE)","v":108},2E-3,0,null,null,null," "]
["\"","R5KPC11WPP",2,null,"Waterproof Pullcord Station - Portuguese",{"$f":"C47*J47","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B47,'Input for Auto Config'!D$16:D$29)","v":0},null,{"$f":"H47+I47","v":0},{"$f":"VLOOKUP(B47,'2019'!C$3:H$220,5,FALSE)","v":108},1.4999999999999999E-2,0,null,null,null,{"$f":"IF(J47*P47=0,\" \",J47*P47)","v":" "}]
["\"","R4K15V",null,4,"SLIM 1/4\" Jack / Button St",0,{"$f":"D48*J48","v":0},{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B48,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B48,'2019'!C$3:H$220,5,FALSE)","v":123},7.0000000000000001E-3,{"$f":"L48*J48","v":0},null,{"$f":"IF(J48*N48=0,\" \",J48*N48)","v":" "},0.35," "]
["\"","R4K17V",null,2,"SLIM Enh Single Call St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B49,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B49,'2019'!C$3:H$220,5,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$16:C$29,B50,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B50,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},2E-3,0,null," ",0.35," "]
["\"","R4K12A",2,null,"Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B51,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B51,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K12AHZ",2,null,"Horizontal Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B52,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B52,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K13VA",2,null,"Enhanced Single Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B53,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B53,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},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$16:C$29,B54,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B54,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},2.5000000000000001E-2,0,null," ",0.35," "]
["\"","R4K14SA",2,2,"Single Patient w/ Staff Emer",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B55,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B55,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.7999999999999999E-2,0,null," ",0.35," "]
["\"","R4K16LV",null,2,"Enhanced Single Patient Station - Visual",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B56,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B56,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.4999999999999999E-2,0,null," ",0.35," "]
["\"","R4K21V",4,null,"Dual Patient Station - Visual",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B57,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B57,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},4.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K22A",2,2,"Dual Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B58,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B58,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},7.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4K23VA",4,null,"Enhanced Dual Patient Station - Audio",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B59,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B59,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},0.03,0,null," ",0.35," "]
["\"","HSS400",2,null,"High Security Audio Bed Station",0,{"$f":"D60*J60","v":0},{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B60,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B60,'2019'!C$3:H$220,5,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$16:C$29,B61,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B61,'2019'!C$3:H$220,5,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$16:C$29,B62,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B62,'2019'!C$3:H$220,5,FALSE)","v":774},1.4999999999999999E-2,0,null," ",0.35,{"$f":"IF(J62*P62=0,\" \",J62*P62)","v":" "}]
["\"","R4KSS",2,null,"Staff Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B63,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B63,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},5.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KDY",2,2,"Duty Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B64,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B64,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},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$16:C$29,B65,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B65,'2019'!C$3:H$220,5,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$16:C$29,B66,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B66,'2019'!C$3:H$220,5,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(B67,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.2E-2,0,null," ",0.35," "]
["\"","R4KPB12",null,2,"SLIM Single Button St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B68,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B68,'2019'!C$3:H$220,5,FALSE)","v":90},4.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KPB23",null,2,"SLIM Dual Button w/ Code St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B69,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B69,'2019'!C$3:H$220,5,FALSE)","v":99},1.7000000000000001E-2,0,null," ",0.5," "]
["\"","R4KPC11",null,2,"SLIM Pull Cord St",0,0,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B70,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B70,'2019'!C$3:H$220,5,FALSE)","v":93},2E-3,0,null," ",0.35," "]
["\"","R4KSAR",null,2,"SLIM Dual Button St",0,24,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B71,'Input for Auto Config'!D$16:D$29)","v":12},null,12,{"$f":"VLOOKUP(B71,'2019'!C$3:H$220,5,FALSE)","v":102},7.0000000000000001E-3,8.4000000000000005E-2,null," ",0.5,6]
["\"","R4KSPK",2,null,"SLIM Speaker Module",0,0,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B72,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B72,'2019'!C$3:H$220,5,FALSE)","v":45},null,null,null," ",0.35," "]
["\"","R4KESR",null,2,"Emergency/Staff Registration Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B73,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B73,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},7.0000000000000001E-3,{"$f":"L73*J73","v":0},null," ",0.35," "]
["\"","R4KCNCL",null,2,"Cancel Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B74,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B74,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},null,null,null," ",0.35," "]
["\"","R4KCB12",null,2,"Code Blue Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B75,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B75,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.7000000000000001E-2,{"$f":"L75*J75","v":0},null," ",0.35," "]
["\"","R4KPB11",null,2,"Single Push Button -Push for Help",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B76,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B76,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},4.0000000000000001E-3,0,null," ",0.35," "]
["\"","R4KPC10",null,2,"Pull Cord Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B77,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B77,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},2E-3,0,null," ",0.35," "]
["\"","R4KPB22",null,2,"Dual Push Button Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B78,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B78,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.7000000000000001E-2,0,null," ",0.5," "]
["\"","R4KPB44",null,4,"Four Button Status Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B79,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B79,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},1.0999999999999999E-2,0,null," ",0.5," "]
["\"","R4KSR1",null,2,"Staff Register Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B80,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B80,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},2E-3,0,null," ",0.35," "]
["\"","R4KFB1",1,1,"Feature Bed Interface",{"$f":"C81*J81","v":0},{"$f":"D81*J81","v":0},{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B81,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H81+I81","v":0},{"$f":"VLOOKUP(B81,'2019'!C$3:H$220,5,FALSE)","v":132},7.4999999999999997E-2,0,null," ",0.05," "]
["\"","R4KSLC1",null,2,"Single Light Control Module",0,{"$f":"D82*J82","v":0},{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B82,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H82+I82","v":0},{"$f":"VLOOKUP(B82,'2019'!C$3:H$220,5,FALSE)","v":81},1.2999999999999999E-2,0,null," ",0.05," "]
["\"","R4KDLC2",null,3,"Dual Light Control Module",0,{"$f":"D83*J83","v":0},{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B83,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H83+I83","v":0},{"$f":"VLOOKUP(B83,'2019'!C$3:H$220,5,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$16:G$29,'R5K Details'!B84,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"ROUNDUP(I84+H84,0)","v":0},{"$f":"VLOOKUP(B84,'2019'!C$3:H$220,5,FALSE)","v":42},null,null,null," ",0.25," "]
["\"","R4KTVR1",2,null,"Digital TV Isolation Module",0,{"$f":"D85*J85","v":0},{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B85,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H85+I85","v":0},{"$f":"VLOOKUP(B85,'2019'!C$3:H$220,5,FALSE)","v":54},1.4999999999999999E-2,{"$f":"L85*J85","v":0},null," ",0.25," "]
["\"","R4KFAM",1,1,"Fire/Auxiliary Module",0,{"$f":"D86*J86","v":0},null,null,{"$f":"I86","v":0},{"$f":"VLOOKUP(B86,'2019'!C$3:H$220,5,FALSE)","v":117},0.03,{"$f":"L86*J86","v":0},null," ",0.25," "]
["\"","R4KCAL",1,1,"Call Assurance Light",0,{"$f":"D87*J87","v":0},{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B87,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"I87+H87","v":0},{"$f":"VLOOKUP(B87,'2019'!C$3:H$220,5,FALSE)","v":81},5.0000000000000001E-3,{"$f":"L87*J87","v":0},null," ",0.35," "]
["Corridor Devices"]
["RAULAND","R5KCL506",2,null,"5-Bulb, Visual Corridor Light",{"$f":"C89*J89","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B89,'Input for Auto Config'!D$16:D$29)","v":0},null,{"$f":"H89+I89","v":0},{"$f":"VLOOKUP(B89,'2019'!C$3:H$220,5,FALSE)","v":198},3.5999999999999997E-2,{"$f":"L89*J89","v":0},null,{"$f":"IF(J89*N89=0,\" \",J89*N89)","v":" "},0.75,{"$f":"IF(J89*P89=0,\" \",J89*P89)","v":" "}]
["\"","R5KCL516",2,null,"5-Bulb, 1-Point Audio Corridor Light",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B90,'Input for Auto Config'!D$16:D$29)","v":0},null,{"$f":"H90+I90","v":0},{"$f":"VLOOKUP(B90,'2019'!C$3:H$220,5,FALSE)","v":237},3.7999999999999999E-2,0,null," ",0.75," "]
["\"","R5KCL546",2,null,"5-Bulb, 4-Point Audio Corridor Light ",24,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B91,'Input for Auto Config'!D$16:D$29)","v":12},null,12,{"$f":"VLOOKUP(B91,'2019'!C$3:H$220,5,FALSE)","v":270},5.8000000000000003E-2,0.69600000000000006,null," ",0.75,9]
["\"","CLA246",2,null,"R4K 4 Bulb, 1-Point Audio Corridor Light",{"$f":"C92*J92","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B92,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B92,'2019'!C$3:H$220,5,FALSE)","v":429},0.13800000000000001,0]
["\"","CLAR46",12,null,"R4K 4 Point Audio Relay Kit for CLA246",{"$f":"C93*J93","v":0},null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B93,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B93,'2019'!C$3:H$220,5,FALSE)","v":132},0.32,0]
["\"","R5KDC06",2,null,"6-Point Visual Domeless Controller",8,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B94,'Input for Auto Config'!D$16:D$29)","v":4},null,4,{"$f":"VLOOKUP(B94,'2019'!C$3:H$220,5,FALSE)","v":264},1.6E-2,6.4000000000000001E-2,null," ",1,4]
["\"","R5KDC016",2,null,"16-Point Visual Domeless Controller",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B95,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B95,'2019'!C$3:H$220,5,FALSE)","v":369},1.7000000000000001E-2,0,null," ",0.75," "]
["\"","R5KDC46",2,null,"6-Point, 4-Point Audio Domeless Controller",2,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B96,'Input for Auto Config'!D$16:D$29)","v":1},null,1,{"$f":"VLOOKUP(B96,'2019'!C$3:H$220,5,FALSE)","v":315},3.7999999999999999E-2,3.7999999999999999E-2,null," ",0.75,0.75]
["\"","R5KDC16D",2,null,"6-Point, 1 Point Audio Duty Domeless Controller",{"$f":"C97*J97","v":0},null,{"$f":"IF(SUMIF('Input for Auto Config'!C$16:C$29,B97,'Input for Auto Config'!D$16:D$29)=0,J40,SUMIF('Input for Auto Config'!C$16:C$29,B97,'Input for Auto Config'!D$16:D$29))","v":0},null,0,{"$f":"VLOOKUP(B97,'2019'!C$3:H$220,5,FALSE)","v":330},5.8000000000000003E-2,0,null," ",0.75," "]
["\"","R5KDCRC4",4,null,"Relay Output Control",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B98,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B98,'2019'!C$3:H$220,5,FALSE)","v":120},3.2000000000000001E-2,0,null," ",0.25," "]
["\"","R5KDCRCS4",4,null,"Solid State Relay Output Control",0,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B99,'Input for Auto Config'!D$16:D$29)","v":0},null,0,{"$f":"VLOOKUP(B99,'2019'!C$3:H$220,5,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$16:C$29,B100,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B100,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},2.1999999999999999E-2,0,null," ",0.75," "]
["\"","CLV144",2,null,"Visual 4-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B101,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B101,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},3.2000000000000001E-2,0,null," ",0.75," "]
["\"","DCV100",2,null,"Visual Domeless Controller - 6 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B102,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B102,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},1.2E-2,0,null," ",0.75," "]
["\"","DCV116",2,null,"Visual Domeless Controller - 16 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B103,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B103,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},1.2E-2,0,null," ",1," "]
["\"","CLA222",2,null,"Audio 2-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B104,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B104,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},6.8000000000000005E-2,0,null," ",0.75," "]
["\"","CLA244",2,null,"Audio 4-Bulb Corridor Light",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B105,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B105,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},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$16:C$29,B106,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B106,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},9.8000000000000004E-2,0,null," ",0.75," "]
["\"","DCA200",2,null,"Audio Domeless Controller - 6 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B107,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B107,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},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$16:C$29,B108,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B108,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},5.8000000000000003E-2,0,null," ",0.75," "]
["\"","DCA216",2,null,"Audio Domeless Controller - 16 pt",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B109,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B109,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},3.7999999999999999E-2,0,null," ",1," "]
["\"","CLAR4",null,null,"Four Station Audio Relay Kit",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B110,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B110,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},3.2000000000000001E-2,0,null," ",0.25," "]
["\"","R4KOUT4R",null,2,"Visual Relay Output Control",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B111,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B111,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},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$16:C$29,B112,'Input for Auto Config'!D$16:D$29)","v":0},null,null,{"$f":"VLOOKUP(B112,'2019'!#REF!,5,FALSE)","v":{"$error":"#REF!"}},2.1000000000000001E-2,0,null," ",0.25," "]
["Accessories"]
["RAULAND","350018",null,null,"8pin Inlinecon Cat-5 Cat-6(100) (Not to be used with R4K CL/DC)",{"$f":"SUM(F22:F29,F33:F72,G48:G72,G28:G29,F82:F87,G82:G87,F89:F99,F121:F122,G121:G122,)","v":185},null,{"$f":"ROUNDUP(F114/100,0)","v":2},null,{"$f":"I114+H114","v":2},{"$f":"VLOOKUP(B114,'2019'!C$3:H$220,5,FALSE)","v":337.5},null,null,null,{"$f":"IF(J114*N114=0,\" \",J114*N114)","v":" "},null,{"$f":"IF(J114*P114=0,\" \",J114*P114)","v":" "}]
["\"","R4KCONN6",null,null,"6-Pin connectors (Bag of 100)",null,{"$f":"SUM(G81)","v":0},{"$f":"CEILING(G115/100, 1)","v":0},null,{"$f":"I115+H115","v":0},{"$f":"VLOOKUP(B115,'2019'!C$3:H$220,5,FALSE)","v":486},null,null,null,{"$f":"IF(J115*N115=0,\" \",J115*N115)","v":" "},null,{"$f":"IF(J115*P115=0,\" \",J115*P115)","v":" "}]
["\"","R4KCONN8",null,null,"8-Pin connectors (Bag of 100)",{"$f":"SUM(F81)","v":0},null,{"$f":"CEILING(F116/100, 1)","v":0},null,null,{"$f":"VLOOKUP(B116,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(J116*N116=0,\" \",J116*N116)","v":" "},null,{"$f":"IF(J116*P116=0,\" \",J116*P116)","v":" "}]
["\"","350006",null,null,"Crimping tool Adapter",null,null,null,null,{"$f":"I117+H117","v":0},{"$f":"VLOOKUP(B117,'2019'!C$3:H$220,5,FALSE)","v":82.5}]
["\"","350007",null,null,"Station Removal Tool",null,null,null,null,{"$f":"I118+H118","v":0},{"$f":"VLOOKUP(B118,'2019'!C$3:H$220,5,FALSE)","v":40}]
["\"","R4KCRIMP",null,null,"Responder 4000 Crimp Tool",null,null,null,null,{"$f":"I119","v":0},{"$f":"VLOOKUP(B119,'2019'!C$3:H$220,5,FALSE)","v":60},null,null,null,{"$f":"IF(J119*N119=0,\" \",J119*N119)","v":" "},null,{"$f":"IF(J119*P119=0,\" \",J119*P119)","v":" "}]
["\"","R4KSTAC",null,null,"R4K Test Adapter Cables",null,null,null,null,{"$f":"I120","v":0},{"$f":"VLOOKUP(B120,'2019'!C$3:H$220,5,FALSE)","v":129}]
["\"","R4KKBS",3,null,"K-Bus Splitter",{"$f":"C121*J121","v":0},{"$f":"D121*J121","v":0},null,null,{"$f":"I121","v":0},{"$f":"VLOOKUP(B121,'2019'!C$3:H$220,5,FALSE)","v":42},null,null,null," ",0.25," "]
["\"","R4KKBSP",3,null,"K-Bus Splitter w/ Power",{"$f":"C122*J122","v":0},{"$f":"D122*J122","v":0},null,null,{"$f":"I122","v":0},{"$f":"VLOOKUP(B122,'2019'!C$3:H$220,5,FALSE)","v":48},null,null,null," ",0.25," "]
["\"","R5KPADP",null,null,"R5K Adapter Plates (10)",null,null,null,null,{"$f":"H123+I123","v":0},{"$f":"VLOOKUP(B123,'2019'!C$3:H$220,5,FALSE)","v":111},null,null,null," ",0.35," "]
["\"","350026",null,null,"R5 & R4K Single Gang Adapter Plates",null,null,null,null,0,{"$f":"VLOOKUP(B124,'2019'!C$3:H$220,5,FALSE)","v":52.5},null,null,null,null,0.1," "]
["\"","350008",null,null,"Clear Station Cover (SLIM 1 & 2 Button Stations)",null,null,null,null,{"$f":"I125+H125","v":0},{"$f":"VLOOKUP(B125,'2019'!C$3:H$220,5,FALSE)","v":62.5},null,null,null," ",0.1," "]
["\"","350027",null,null,"Recessed 1-Gang Adapter Plate",null,null,null,null,{"$f":"I126+H126","v":0},{"$f":"VLOOKUP(B126,'2019'!C$3:H$220,5,FALSE)","v":102.5},null,null,null," ",0.05," "]
["\"","350028",null,null,"Recessed 2-Gang Adapter Plate",null,null,null,null,{"$f":"I127+H127","v":0},{"$f":"VLOOKUP(B127,'2019'!C$3:H$220,5,FALSE)","v":115},null,null,null,{"$f":"IF(J127*N127=0,\" \",J127*N127)","v":" "},2," "]
["\"","CLS103",null,null,"3 Lamp High Security Dome Lite",null,null,null,null,{"$f":"I128","v":0},{"$f":"VLOOKUP(B128,'2019'!C$3:H$220,5,FALSE)","v":276},0.2,{"$f":"L128*J128","v":0},null,{"$f":"IF(J128*N128=0,\" \",J128*N128)","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$16:G$29,'R5K Details'!B130,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H130+I130","v":0},{"$f":"VLOOKUP(B130,'2019'!C$3:H$220,5,FALSE)","v":330},null,{"$f":"IF(J130*L130=0,\" \",J130*L130)","v":" "},null,{"$f":"IF(J130*N130=0,\" \",J130*N130)","v":" "},0.1,{"$f":"IF(J130*P130=0,\" \",J130*P130)","v":" "}]
["\"","NCPSDSTV",null,null,"Digital Pillow Speaker, TV",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B131,'Input for Auto Config'!H$16:H$29)","v":0},null,0,{"$f":"VLOOKUP(B131,'2019'!C$3:H$220,5,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$16:G$29,'R5K Details'!B132,'Input for Auto Config'!H$16:H$29)","v":0},null,0,{"$f":"VLOOKUP(B132,'2019'!C$3:H$220,5,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$16:G$29,'R5K Details'!B133,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H133+I133","v":0},{"$f":"VLOOKUP(B133,'2019'!C$3:H$220,5,FALSE)","v":345},null,null,null," ",0.1]
["\"","NCSAV",null,null,"DIN Cord Saver",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B134,'Input for Auto Config'!H$16:H$29)","v":0},null,0,{"$f":"VLOOKUP(B134,'2019'!C$3:H$220,5,FALSE)","v":42.5},null,{"$f":"IF(J134*L134=0,\" \",J134*L134)","v":" "},null," ",0.1,{"$f":"IF(J134*P134=0,\" \",J134*P134)","v":" "}]
["\"","CCDIN3",null,null,"Handheld Pendent - 2 Lights (8-pin DIN)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B135,'Input for Auto Config'!H$16:H$29)","v":0},null,{"$f":"H135+I135","v":0},{"$f":"VLOOKUP(B135,'2019'!C$3:H$220,5,FALSE)","v":117.5},null,{"$f":"IF(J135*L135=0,\" \",J135*L135)","v":" "},null," ",0.1,{"$f":"IF(J135*P135=0,\" \",J135*P135)","v":" "}]
["\"","CCDIN",null,null,"Call Cord - Single w/ Clip (10 ft.)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B136,'Input for Auto Config'!H$16:H$29)","v":41},null,41,{"$f":"VLOOKUP(B136,'2019'!C$3:H$220,5,FALSE)","v":55},null,{"$f":"IF(J136*L136=0,\" \",J136*L136)","v":" "},null," ",0.1,{"$f":"IF(J136*P136=0,\" \",J136*P136)","v":4.1000000000000005}]
["\"","CC200",null,null,"Call Cord - 1/4\" Jack Call Cord w/ Clip (10ft.)",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B137,'Input for Auto Config'!H$16:H$29)","v":0},null,0,{"$f":"VLOOKUP(B137,'2019'!C$3:H$220,5,FALSE)","v":45},null,{"$f":"IF(J137*L137=0,\" \",J137*L137)","v":" "},null," ",0.1,{"$f":"IF(J137*P137=0,\" \",J137*P137)","v":" "}]
["\"","NC4JACK",null,null,"1/4\" Jack Auxiliary Input Station",null,null,{"$f":"SUMIF('Input for Auto Config'!C$16:C$29,B138,'Input for Auto Config'!D$16:D$29)","v":0},null,{"$f":"I138+H138","v":0},{"$f":"VLOOKUP(B138,'2019'!C$3:H$220,5,FALSE)","v":195},null,null,null," ",0.5]
["\"","NCBED",null,null,"37-pin Feature Bed Receptacle",null,null,null,null,{"$f":"I139","v":0},{"$f":"VLOOKUP(B139,'2019'!C$3:H$220,5,FALSE)","v":145},null,{"$f":"IF(J139*L139=0,\" \",J139*L139)","v":" "},null," ",0.5,{"$f":"IF(J139*P139=0,\" \",J139*P139)","v":" "}]
["\"","NCC37",null,null,"37-pin Feature Bed Cable",null,null,null,null,0,{"$f":"VLOOKUP(B140,'2019'!C$3:H$220,5,FALSE)","v":157.5},null,null,null," ",0.5]
["\"","NCC37RA",null,null,"37-pin Feature Bed Cable -Right Angle",null,null,null,null,0,{"$f":"VLOOKUP(B141,'2019'!C$3:H$220,5,FALSE)","v":157.5},null,null,null," ",0.5]
["\"","NCLV120",null,null,"Low Voltage Lighting Control 120V",null,null,{"$f":"SUMIF('Input for Auto Config'!G$16:G$29,'R5K Details'!B142,'Input for Auto Config'!H$16:H$29)","v":0},null,null,{"$f":"VLOOKUP(B142,'2019'!C$3:H$220,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(J142*L142=0,\" \",J142*L142)","v":" "},null," ",0.5,{"$f":"IF(J142*P142=0,\" \",J142*P142)","v":" "}]
["\"","CM300",null,null,"Chassis Fault Monitor",null,null,null,null,0,{"$f":"VLOOKUP(B143,'2019'!C$3:H$220,5,FALSE)","v":385},null,null,null," ",0.5," "]
["\"","PM300",null,null,"Power Fault Monitor",null,null,null,null,0,{"$f":"VLOOKUP(B144,'2019'!C$3:H$220,5,FALSE)","v":342.5},null,null,null," ",0.5," "]
["\" ","350011",null,null,"Bio-seals - Cancel Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B145,'2019'!C$3:H$220,5,FALSE)","v":27.5},null,null,null," ",0.5," "]
["\" ","350012",null,null,"Bio-seals-Small Push Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B146,'2019'!C$3:H$220,5,FALSE)","v":27.5},null,null,null," ",0.5," "]
["\" ","350013",null,null,"Bio-seals Large Push Button (10) -- R4K SLIM ONLY",null,null,null,null,0,{"$f":"VLOOKUP(B147,'2019'!C$3:H$220,5,FALSE)","v":37.5},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":"I148+H148","v":1},{"$f":"order_hack!F180","v":"http://wirelessmessaging.com/"},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":"I149+H149","v":1},{"$f":"order_hack!F181","v":"http://wirelessmessaging.com/"},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":0},null,{"$f":"I150+H150","v":0},{"$f":"order_hack!F182","v":"http://wirelessmessaging.com/"},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":0},null,{"$f":"I151+H151","v":0},{"$f":"order_hack!F183","v":"http://wirelessmessaging.com/"},null,null,null," ",null," "]
["\"",null,null,null,{"$f":"IF(B152=\"\",\"\",VLOOKUP(B152,'2019'!#REF!,2,FALSE))","v":""},null,null,null,null,{"$f":"I152","v":0},{"$f":"IF(B152=\"\",0,VLOOKUP(B152,'2019'!C$3:H$220,5,FALSE))","v":0},null,null,null,{"$f":"IF(J152*N152=0,\" \",J152*N152)","v":" "},null,{"$f":"IF(J152*P152=0,\" \",J152*P152)","v":" "}]
[null,null,null,null,{"$f":"IF(B153=\"\",\"\",VLOOKUP(B153,'2019'!#REF!,2,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(B153=\"\",0,VLOOKUP(B153,'2019'!C$3:H$220,5,FALSE))","v":0},null,null,null," ",null," "]
[null,null,null,null,{"$f":"IF(B154=\"\",\"\",VLOOKUP(B154,'2019'!#REF!,2,FALSE))","v":""},null,null,null,null,0,{"$f":"IF(B154=\"\",0,VLOOKUP(B154,'2019'!C$3:H$220,5,FALSE))","v":0},null,null,null," ",null," "]
[null,null,null,null,{"$f":"IF(B155=\"\",\"\",VLOOKUP(B155,'2019'!#REF!,2,FALSE))","v":""},null,null,null,null,{"$f":"I155","v":0},{"$f":"IF(B155=\"\",0,VLOOKUP(B155,'2019'!C$3:H$220,5,FALSE))","v":0},null,null,null,{"$f":"IF(J155*N155=0,\" \",J155*N155)","v":" "},null,{"$f":"IF(J155*P155=0,\" \",J155*P155)","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Amps -->",{"$f":"SUM(M27:M155,M22:M23)","v":1.2460000000000002},"Hours -->",{"$f":"SUM(O7:O154)","v":0},"Hours -->",{"$f":"SUM(Q7:Q154)","v":61.2}]
[]
[{"$f":"A2","v":"International Responder 5000 2019 Estimate Sheet v 1.50"},null,null,null,null,null,null,null,null,null,null,null,"Job Name:",{"$f":"IF(N2=\"\",\"\",N2)","v":"HOSPITAL SAN JAVIER"}]
["Cable",null,null,null,null,null,null,null,null,null,null,null,"System:",{"$f":"IF(N3=\"\",\"\",N3)","v":"CENCOMEX S.A."}]
[null,"DATE:",null,null,{"$f":"IF(E4=\"\",\"\",E4)","v":"2022-12-26"},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(J33:J80,J24)*50))/1000,0)","v":4},100,{"$f":"J162*K162","v":400},null,8,{"$f":"IF(J162*N162=0,\" \",J162*N162)","v":32}]
[null,null,null,null,"4-Pair Cat5 Ethernet cable Estimate (250ft/Console)",null,null,null,null,{"$f":"ROUNDUP((SUM(J26:J26,J28,J23)*250)/1000,0)","v":1},0,{"$f":"J163*K163","v":0},null,8,8]
[null,null,null,null,"4-Pair Cat5 Ethernet cable (400ft/MSC)",null,null,null,null,{"$f":"ROUNDUP((SUM(J11)*400)/1000,0)","v":1},0,0,null,8,8]
[null,null,null,null,"4-Pair Cat5 Ethernet cable (30ft/Corridor Light/Domeless Controller)",null,null,null,null,{"$f":"ROUNDUP((SUM(J89:J97,J100:J109)*30)/1000,0)","v":1},0,0,null,8,8]
[null,null,null,null,"Power Common - #12 AWG",null,null,null,null,null,0,0,null,8," "]
[null,null,null,null,"Power Common - #14 AWG",null,null,null,null,{"$f":"ROUNDUP((SUM(J11,J25,J27,J87,J14)*100/1000),0)","v":1},0,0,null,8,8]
[null,null,null,null,null,null,null,null,null,null,0,0,null,8," "]
[null,null,null,null,null,null,null,null,null,null,0,0,null,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,0,0,null,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,0,0,null,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,0,0,null,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,0,0,null,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,0,0,null,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,null,"Total Cable, Etc.",{"$f":"SUM(L162:L180)","v":400},"Hours -->",{"$f":"SUM(O162:O180)","v":64}]

{"sheet":"ORDER","index":3,"n_rows":226,"n_cols":9,"rows_kept":226,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[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]]}
["Responder 5000 Nurse Call System Purchase Order",null,null,"Project Name:",{"$f":"IF('R5K Details'!N2=\"\",\"\",'R5K Details'!N2)","v":"HOSPITAL SAN JAVIER"},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":"2022-12-27"}]
["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 S.A."},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"]
[1,"R5KMPR15","Power Supply 15V for Stations, CLs, DCs (w/battery backup)",933,933,311,311]
[1,"R5KMPR36","Power Supply 36V for MSC, Console (w/battery backup)",900,900,300,300]
[1,"R5KMSC","Main System Controller",1803,1803,601,601]
[1,"R5KL2KA","Data Converter for K-Bus to L-Net",543,543,186,186]
[1,"R5KMTRM","Termination Board",183,183,61,61]
[1,"R5KCONS","VoIP Nurse Console",1836,1836,612,612]
[12,"R5KCL546","5-Bulb, 4-Point Audio Corridor Light ",270,3240,90,1080]
[4,"R5KDC06","6-Point Visual Domeless Controller",264,1056,97,388]
[1,"R5KDC46","6-Point, 4-Point Audio Domeless Controller",315,315,105,105]
[41,"R5KPS1A","R5K Single Audio Patient Station",126,5166,44,1804]
[18,"R5KPC11WPS","Waterproof Pullcord Station - Spanish",108,1944,36,648]
[12,"R4KSAR","SLIM Dual Button St",102,1224,34,408]
["Software"]
["ACCESSORIES"]
[2,"350018","8pin Inlinecon Cat-5 Cat-6(100) (Not to be used with R4K CL/DC)",337.5,675,135,270]
["Pillow Speakers/Call Cords"]
[41,"CCDIN","Call Cord - Single w/ Clip (10 ft.)",55,2255,22,902]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* Prices not in printed Price List are subject to change.",null,null,"Responder 5000 Suggested List Total: ",null,null,{"$f":"SUM(E17:E89)","v":22073}]
["Distributor Discount: ",null,null,null,null,null,{"$f":"G90-G92","v":14397},{"$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!G211","v":7676},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":538.36585365853659}]
[null,null,null,"Total Cable Selling Cost -->",null,null,680]
[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":8356}]
[null,null,"Yearly Software Maintenance Agreement Distributor Price",null,null,"See Below",0]
[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":0}]
[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":0},0]
[null,"Responder SIP Server",null,null,4300,{"$f":"IF(AND('R5K Details'!J16=1,'R5K Details'!J19=1),0,IF(AND('R5K Details'!J16=0,'R5K Details'!J19=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":0}]
[null,"TOTAL PRICE of Non-Rauland Miscellaneous Items not included in Quote above.",null,null,{"$f":"G116","v":0}]
[]
[]
[null,"Page 1 of 2",null,null,null,null,{"$f":"TODAY()","v":"2022-12-27"}]
[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":""},null,{"$f":"IF(F104=1,\"Please refer to Application Note R5000_APPNOTE_In_Your_IT_Environment\",\"\")","v":""}]
[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 entitles the facility to software service packs, new releases and customer support for all Responder Database, Application and Integration software after the first 12 months.  Rauland will bill the distributor for the Software Maintenance Agreement 14 months after the software has been invoiced.  The distributor will be billed monthly and will continue, 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!F117","v":0}]
[]
["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,"00:00:00"]
[null,null,"Authorization Signature",null,"Name",null,"Date"]
[]
[null,"Customer Information",null,null,"Facility Information"]
[null,"Customer    ",{"$f":"C6","v":"CENCOMEX S.A."},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":211,"n_cols":11,"rows_kept":211,"cut":false,"hidden":false,"merged":[[203,1,203,4],[3,0,3,4],[4,1,4,4],[190,1,190,4],[162,0,162,1],[117,1,117,4],[188,1,188,3],[175,0,175,1],[140,7,140,8],[146,7,146,8],[105,1,105,4],[0,5,0,6],[1,0,1,3],[0,0,0,3],[2,0,2,3],[102,2,102,3],[115,2,115,3]]}
["Responder 5000 Nurse Call System ",null,null,null,"Project Name:","Project Name"]
[null,null,null,null,"Date:",{"$f":"TODAY()","v":"2022-12-27"}]
[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":0},{"$f":"VLOOKUP(A9,'2019'!C$3:H$255,6,FALSE)","v":672},{"$f":"D9*C9","v":0},{"$f":"VLOOKUP(A9,'2019'!C$3:H$225,5,FALSE)","v":1680},{"$f":"F9*C9","v":0},null,null,null,{"$f":"'R5K Details'!J9","v":1}]
["351102","Wall Mounting Cabinet-head-end",{"$f":"'R5K Details'!J8","v":0},{"$f":"VLOOKUP(A10,'2019'!C$3:H$225,6,FALSE)","v":458},{"$f":"D10*C10","v":0},{"$f":"VLOOKUP(A10,'2019'!C$3:H$225,5,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":1},{"$f":"VLOOKUP(A11,'2019'!C$3:H$225,6,FALSE)","v":311},{"$f":"D11*C11","v":311},{"$f":"VLOOKUP(A11,'2019'!C$3:H$225,5,FALSE)","v":933},933]
["R5KMPR36","Power Supply 36V for MSC, Console (w/battery backup)",{"$f":"'R5K Details'!J10","v":1},{"$f":"VLOOKUP(A12,'2019'!C$3:H$225,6,FALSE)","v":300},300,{"$f":"VLOOKUP(A12,'2019'!C$3:H$225,5,FALSE)","v":900},{"$f":"F12*C12","v":900}]
["R5KMSC","Main System Controller",{"$f":"'R5K Details'!J11","v":1},{"$f":"VLOOKUP(A13,'2019'!C$3:H$225,6,FALSE)","v":601},601,{"$f":"VLOOKUP(A13,'2019'!C$3:H$225,5,FALSE)","v":1803},1803]
["351010","Responder Network Concentrator",{"$f":"'R5K Details'!J12","v":0},{"$f":"VLOOKUP(A14,'2019'!C$3:H$225,6,FALSE)","v":4843},0,{"$f":"VLOOKUP(A14,'2019'!C$3:H$225,5,FALSE)","v":12107.5},{"$f":"F14*C14","v":0}]
["R5KM8PRT","R5K 8-Port Switch",{"$f":"'R5K Details'!J13","v":0},{"$f":"VLOOKUP(A15,'2019'!C$3:H$225,6,FALSE)","v":371},0,{"$f":"VLOOKUP(A15,'2019'!C$3:H$225,5,FALSE)","v":1113},0]
["351006","Fiber Adapter Modules",{"$f":"'R5K Details'!J14","v":0},{"$f":"VLOOKUP(A16,'2019'!C$3:H$225,6,FALSE)","v":204},0,{"$f":"VLOOKUP(A16,'2019'!C$3:H$225,5,FALSE)","v":510},{"$f":"F16*C16","v":0}]
["R5KL2KA","Data Converter for K-Bus to L-Net",{"$f":"'R5K Details'!J15","v":1},{"$f":"VLOOKUP(A17,'2019'!C$3:H$225,6,FALSE)","v":186},186,{"$f":"VLOOKUP(A17,'2019'!C$3:H$225,5,FALSE)","v":543},543]
["R5KMTRM","Termination Board",{"$f":"'R5K Details'!J25","v":1},{"$f":"VLOOKUP(A18,'2019'!C$3:H$225,6,FALSE)","v":61},61,{"$f":"VLOOKUP(A18,'2019'!C$3:H$225,5,FALSE)","v":183},183]
["R5KCONS","VoIP Nurse Console",{"$f":"'R5K Details'!J26","v":1},{"$f":"VLOOKUP(A19,'2019'!C$3:H$225,6,FALSE)","v":612},612,{"$f":"VLOOKUP(A19,'2019'!C$3:H$225,5,FALSE)","v":1836},1836]
["R4KPA25","Paging Amplifier",{"$f":"'R5K Details'!J22","v":0},{"$f":"VLOOKUP(A20,'2019'!C$3:H$225,6,FALSE)","v":286},0,{"$f":"VLOOKUP(A20,'2019'!C$3:H$225,5,FALSE)","v":858},0]
["R4KMQCV2","Marquee Controller",{"$f":"'R5K Details'!J23","v":0},{"$f":"VLOOKUP(A21,'2019'!C$3:H$225,6,FALSE)","v":169},0,{"$f":"VLOOKUP(A21,'2019'!C$3:H$225,5,FALSE)","v":507},0]
["R4KMST","Marquee Speaker Station",{"$f":"'R5K Details'!J24","v":0},{"$f":"VLOOKUP(A22,'2019'!C$3:H$225,6,FALSE)","v":41},0,{"$f":"VLOOKUP(A22,'2019'!C$3:H$225,5,FALSE)","v":123},0]
["R4KTMB","Termination Board",{"$f":"'R5K Details'!J27","v":0},null,{"$f":"D23*C23","v":0},null,0]
["R4KANNV2","Annunciate Panel (comes with a Receptacle)",{"$f":"'R5K Details'!J28","v":0},{"$f":"VLOOKUP(A24,'2019'!C$3:H$225,6,FALSE)","v":294},0,{"$f":"VLOOKUP(A24,'2019'!C$3:H$225,5,FALSE)","v":882},0]
["R4KRECP","R4K Console Receptacle",{"$f":"'R5K Details'!J29","v":0},{"$f":"VLOOKUP(A25,'2019'!C$3:H$225,6,FALSE)","v":22},0,{"$f":"VLOOKUP(A25,'2019'!C$3:H$225,5,FALSE)","v":66},0]
["R5KCL506","5-Bulb, Visual Corridor Light",{"$f":"'R5K Details'!J89","v":0},{"$f":"VLOOKUP(A26,'2019'!C$3:H$225,6,FALSE)","v":66},0,{"$f":"VLOOKUP(A26,'2019'!C$3:H$225,5,FALSE)","v":198},{"$f":"F26*C26","v":0}]
["R5KCL516","5-Bulb, 1-Point Audio Corridor Light",{"$f":"'R5K Details'!J90","v":0},{"$f":"VLOOKUP(A27,'2019'!C$3:H$225,6,FALSE)","v":79},0,{"$f":"VLOOKUP(A27,'2019'!C$3:H$225,5,FALSE)","v":237},0]
["R5KCL546","5-Bulb, 4-Point Audio Corridor Light ",{"$f":"'R5K Details'!J91","v":12},{"$f":"VLOOKUP(A28,'2019'!C$3:H$225,6,FALSE)","v":90},1080,{"$f":"VLOOKUP(A28,'2019'!C$3:H$225,5,FALSE)","v":270},3240]
["R5KDC06","6-Point Visual Domeless Controller",{"$f":"'R5K Details'!J94","v":4},{"$f":"VLOOKUP(A29,'2019'!C$3:H$225,6,FALSE)","v":97},388,{"$f":"VLOOKUP(A29,'2019'!C$3:H$225,5,FALSE)","v":264},1056]
["R5KDC016","16-Point Visual Domeless Controller",{"$f":"'R5K Details'!J95","v":0},{"$f":"VLOOKUP(A30,'2019'!C$3:H$225,6,FALSE)","v":123},0,{"$f":"VLOOKUP(A30,'2019'!C$3:H$225,5,FALSE)","v":369},0]
["R5KDC46","6-Point, 4-Point Audio Domeless Controller",{"$f":"'R5K Details'!J96","v":1},{"$f":"VLOOKUP(A31,'2019'!C$3:H$225,6,FALSE)","v":105},105,{"$f":"VLOOKUP(A31,'2019'!C$3:H$225,5,FALSE)","v":315},315]
["R5KDC16D","6-Point, 1 Point Audio Duty Domeless Controller",{"$f":"'R5K Details'!J97","v":0},{"$f":"VLOOKUP(A32,'2019'!C$3:H$225,6,FALSE)","v":116},0,{"$f":"VLOOKUP(A32,'2019'!C$3:H$225,5,FALSE)","v":330},0]
["R5KDCRC4","Relay Output Control",{"$f":"'R5K Details'!J98","v":0},{"$f":"VLOOKUP(A33,'2019'!C$3:H$225,6,FALSE)","v":40},0,{"$f":"VLOOKUP(A33,'2019'!C$3:H$225,5,FALSE)","v":120},0]
["R5KDCRCS4","Solid State Relay Output Control",{"$f":"'R5K Details'!J99","v":0},{"$f":"VLOOKUP(A34,'2019'!C$3:H$225,6,FALSE)","v":48},0,{"$f":"VLOOKUP(A34,'2019'!C$3:H$225,5,FALSE)","v":144},0]
["R5KPD2EA","R5K Enhnaced Dual Patient Station",{"$f":"'R5K Details'!J33","v":0},{"$f":"VLOOKUP(A35,'2019'!C$3:H$225,6,FALSE)","v":79},0,{"$f":"VLOOKUP(A35,'2019'!C$3:H$225,5,FALSE)","v":216},0]
["R5KPS1EA","R5K Enhanced Single Station",{"$f":"'R5K Details'!J34","v":0},{"$f":"VLOOKUP(A36,'2019'!C$3:H$225,6,FALSE)","v":61},0,{"$f":"VLOOKUP(A36,'2019'!C$3:H$225,5,FALSE)","v":165},0]
["R5KPD2A","R5K Dual Patient Station",{"$f":"'R5K Details'!J35","v":0},{"$f":"VLOOKUP(A37,'2019'!C$3:H$225,6,FALSE)","v":59},0,{"$f":"VLOOKUP(A37,'2019'!C$3:H$225,5,FALSE)","v":177},0]
["R5KPS1A","R5K Single Audio Patient Station",{"$f":"'R5K Details'!J36","v":41},{"$f":"VLOOKUP(A38,'2019'!C$3:H$225,6,FALSE)","v":44},1804,{"$f":"VLOOKUP(A38,'2019'!C$3:H$225,5,FALSE)","v":126},5166]
["R5KPS1V","R5K Single Patient Visual Station",{"$f":"'R5K Details'!J37","v":0},{"$f":"VLOOKUP(A39,'2019'!C$3:H$225,6,FALSE)","v":35},0,{"$f":"VLOOKUP(A39,'2019'!C$3:H$225,5,FALSE)","v":105},0]
["R5KPS1LCA","R5K Audio Single Patient Station with Lighting Control",{"$f":"'R5K Details'!J38","v":0},{"$f":"VLOOKUP(A40,'2019'!C$3:H$225,6,FALSE)","v":60},0,{"$f":"VLOOKUP(A40,'2019'!C$3:H$225,5,FALSE)","v":180},0]
["R5KSSTF","R5K Staff Station",{"$f":"'R5K Details'!J39","v":0},{"$f":"VLOOKUP(A41,'2019'!C$3:H$225,6,FALSE)","v":37},0,{"$f":"VLOOKUP(A41,'2019'!C$3:H$225,5,FALSE)","v":111},0]
["R5KSDTY","R5K Duty Station",{"$f":"'R5K Details'!J40","v":0},{"$f":"VLOOKUP(A42,'2019'!C$3:H$225,6,FALSE)","v":44},0,{"$f":"VLOOKUP(A42,'2019'!C$3:H$225,5,FALSE)","v":132},0]
["R4K15V","SLIM 1/4\" Jack / Button St",{"$f":"'R5K Details'!J48","v":0},{"$f":"VLOOKUP(A43,'2019'!C$3:H$225,6,FALSE)","v":41},0,{"$f":"VLOOKUP(A43,'2019'!C$3:H$225,5,FALSE)","v":123},0]
["R4K17V","SLIM Enh Single Call St",{"$f":"'R5K Details'!J49","v":0},{"$f":"VLOOKUP(A44,'2019'!C$3:H$225,6,FALSE)","v":62},0,{"$f":"VLOOKUP(A44,'2019'!C$3:H$225,5,FALSE)","v":186},0]
["R4K11V","Single Patient Station - Visual",{"$f":"'R5K Details'!J50","v":0},null,0,null,0]
["R4K12A","Single Patient Station - Audio",{"$f":"'R5K Details'!J51","v":0},null,{"$f":"D46*C46","v":0},null,0]
["R4K12AHZ","Horizontal Single Patient Station - Audio",{"$f":"'R5K Details'!J52","v":0},null,0,null,0]
["R4K13VA","Enhanced Single Patient Station - Audio",{"$f":"'R5K Details'!J53","v":0},null,0,null,0]
["R4K13VAHZ","Horizontal Enh Single Patient Station - Audio",{"$f":"'R5K Details'!J54","v":0},null,0,null,0]
["R4K14SA","Single Patient w/ Staff Emer",{"$f":"'R5K Details'!J55","v":0},null,0,null,0]
["R4K16LV","Enhanced Single Patient Station - Visual",{"$f":"'R5K Details'!J56","v":0},null,0,null,0]
["R4K21V","Dual Patient Station - Visual",{"$f":"'R5K Details'!J57","v":0},null,0,null,0]
["R4K22A","Dual Patient Station - Audio",{"$f":"'R5K Details'!J58","v":0},null,0,null,0]
["R4K23VA","Enhanced Dual Patient Station - Audio",{"$f":"'R5K Details'!J59","v":0},null,0,null,0]
["HSS400","High Security Audio Bed Station",{"$f":"'R5K Details'!J60","v":0},{"$f":"VLOOKUP(A55,'2019'!C$3:H$225,6,FALSE)","v":258},0,{"$f":"VLOOKUP(A55,'2019'!C$3:H$225,5,FALSE)","v":774},0]
["HSS401","High Security  Staff Station",{"$f":"'R5K Details'!J61","v":0},{"$f":"VLOOKUP(A56,'2019'!C$3:H$225,6,FALSE)","v":258},0,{"$f":"VLOOKUP(A56,'2019'!C$3:H$225,5,FALSE)","v":774},0]
["HSS433","High Security Push Button Station",{"$f":"'R5K Details'!J62","v":0},{"$f":"VLOOKUP(A57,'2019'!C$3:H$225,6,FALSE)","v":258},0,{"$f":"VLOOKUP(A57,'2019'!C$3:H$225,5,FALSE)","v":774},0]
["R4KSS","Staff Station",{"$f":"'R5K Details'!J63","v":0},null,0,null,0]
["R4KDY","Duty Station",{"$f":"'R5K Details'!J64","v":0},null,0,null,0]
["R5KPB4","Responder 5K 4-button Station",{"$f":"'R5K Details'!J41","v":0},{"$f":"VLOOKUP(A60,'2019'!C$3:H$225,6,FALSE)","v":41},0,{"$f":"VLOOKUP(A60,'2019'!C$3:H$225,5,FALSE)","v":123},0]
["R5KPB4CNF","Responder 5K 4-button Workflow and Registration Station",{"$f":"'R5K Details'!J42","v":0},{"$f":"VLOOKUP(A61,'2019'!C$3:H$225,6,FALSE)","v":38},0,{"$f":"VLOOKUP(A61,'2019'!C$3:H$225,5,FALSE)","v":123},{"$f":"F61*C61","v":0}]
["R5KPC11WP","Waterproof Pullcord Station",{"$f":"'R5K Details'!J44","v":0},{"$f":"VLOOKUP(A62,'2019'!C$3:H$225,6,FALSE)","v":34},0,{"$f":"VLOOKUP(A62,'2019'!C$3:H$225,5,FALSE)","v":102},0]
["R5KPC11WPS","Waterproof Pullcord Station - Spanish",{"$f":"'R5K Details'!J45","v":18},{"$f":"VLOOKUP(A63,'2019'!C$3:H$225,6,FALSE)","v":36},648,{"$f":"VLOOKUP(A63,'2019'!C$3:H$225,5,FALSE)","v":108},{"$f":"F63*C63","v":1944}]
["R5KPC11WPF","Waterproof Pullcord Station - French",{"$f":"'R5K Details'!J46","v":0},{"$f":"VLOOKUP(A64,'2019'!C$3:H$225,6,FALSE)","v":36},0,{"$f":"VLOOKUP(A64,'2019'!C$3:H$225,5,FALSE)","v":108},{"$f":"F64*C64","v":0}]
["R5KPC11WPP","Waterproof Pullcord Station - Portuguese",{"$f":"'R5K Details'!J47","v":0},{"$f":"VLOOKUP(A65,'2019'!C$3:H$225,6,FALSE)","v":36},0,{"$f":"VLOOKUP(A65,'2019'!C$3:H$225,5,FALSE)","v":108},{"$f":"F65*C65","v":0}]
["R4K2JACK","SLIM Dual 1/4\" Jack St",{"$f":"'R5K Details'!J65","v":0},{"$f":"VLOOKUP(A66,'2019'!C$3:H$225,6,FALSE)","v":45},0,{"$f":"VLOOKUP(A66,'2019'!C$3:H$225,5,FALSE)","v":135},0]
["R4KCB13","SLIM Code Button St",{"$f":"'R5K Details'!J66","v":0},{"$f":"VLOOKUP(A67,'2019'!C$3:H$225,6,FALSE)","v":34},0,{"$f":"VLOOKUP(A67,'2019'!C$3:H$225,5,FALSE)","v":102},0]
["R4KDTY2","SLIM Duty St w/ Speaker",{"$f":"'R5K Details'!J67","v":0},null,0,null,0]
["R4KPB12","SLIM Single Button St",{"$f":"'R5K Details'!J68","v":0},{"$f":"VLOOKUP(A69,'2019'!C$3:H$225,6,FALSE)","v":30},0,{"$f":"VLOOKUP(A69,'2019'!C$3:H$225,5,FALSE)","v":90},0]
["R4KPB23","SLIM Dual Button w/ Code St",{"$f":"'R5K Details'!J69","v":0},{"$f":"VLOOKUP(A70,'2019'!C$3:H$225,6,FALSE)","v":35},0,{"$f":"VLOOKUP(A70,'2019'!C$3:H$225,5,FALSE)","v":99},0]
["R4KPC11","SLIM Pull Cord St",{"$f":"'R5K Details'!J70","v":0},{"$f":"VLOOKUP(A71,'2019'!C$3:H$225,6,FALSE)","v":34},0,{"$f":"VLOOKUP(A71,'2019'!C$3:H$225,5,FALSE)","v":93},0]
["R4KSAR","SLIM Dual Button St",{"$f":"'R5K Details'!J71","v":12},{"$f":"VLOOKUP(A72,'2019'!C$3:H$225,6,FALSE)","v":34},408,{"$f":"VLOOKUP(A72,'2019'!C$3:H$225,5,FALSE)","v":102},1224]
["R4KSPK","SLIM Speaker Module",{"$f":"'R5K Details'!J72","v":0},{"$f":"VLOOKUP(A73,'2019'!C$3:H$225,6,FALSE)","v":16},0,{"$f":"VLOOKUP(A73,'2019'!C$3:H$225,5,FALSE)","v":45},0]
["R4KESR","Emergency/Staff Registration Station",{"$f":"'R5K Details'!J73","v":0},null,{"$f":"D74*C74","v":0},null,0]
["R4KCNCL","Cancel Station",{"$f":"'R5K Details'!J74","v":0},null,0,null,0]
["R4KCB12","Code Blue Station",{"$f":"'R5K Details'!J75","v":0},null,0,null,0]
["R4KPB11","Single Push Button -Push for Help",{"$f":"'R5K Details'!J76","v":0},null,0,null,0]
["R4KPC10","Pull Cord Station",{"$f":"'R5K Details'!J77","v":0},null,0,null,0]
["R4KPB22","Dual Push Button Station",{"$f":"'R5K Details'!J78","v":0},null,0,null,0]
["R4KPB44","Four Button Status Station",{"$f":"'R5K Details'!J79","v":0},null,0,null,0]
["R4KSR1","Staff Register Station",{"$f":"'R5K Details'!J80","v":0},null,0,null,0]
["R5KCANCEL","Cancel Station",{"$f":"'R5K Details'!J43","v":0},{"$f":"VLOOKUP(A82,'2019'!C$3:H$225,6,FALSE)","v":34},0,{"$f":"VLOOKUP(A82,'2019'!C$3:H$225,5,FALSE)","v":102},0]
["R4KFAM","Fire/Auxiliary Module",{"$f":"'R5K Details'!J82","v":0},{"$f":"VLOOKUP(A83,'2019'!C$3:H$225,6,FALSE)","v":39},0,{"$f":"VLOOKUP(A83,'2019'!C$3:H$225,5,FALSE)","v":117},{"$f":"F83*C83","v":0}]
["R4KCAL","Call Assurance Light",{"$f":"'R5K Details'!J87","v":0},{"$f":"VLOOKUP(A84,'2019'!C$3:H$225,6,FALSE)","v":27},0,{"$f":"VLOOKUP(A84,'2019'!C$3:H$225,5,FALSE)","v":81},0]
["CLV122","Visual 2-Bulb Corridor Light",{"$f":"'R5K Details'!J100","v":0},null,null,null,{"$f":"F85*C85","v":0}]
["CLV144","Visual 4-Bulb Corridor Light",{"$f":"'R5K Details'!J101","v":0},null,null,null,0]
["DCV100","Visual Domeless Controller - 6 pt",{"$f":"'R5K Details'!J102","v":0},null,null,null,0]
["DCV116","Visual Domeless Controller - 16 pt",{"$f":"'R5K Details'!J103","v":0},null,null,null,0]
["CLA222","Audio 2-Bulb Corridor Light",{"$f":"'R5K Details'!J104","v":0},null,null,null,0]
["CLA246","Audio 4-Bulb Corridor Light",{"$f":"'R5K Details'!J92","v":0},{"$f":"VLOOKUP(A90,'2019'!C$3:H$225,6,FALSE)","v":143},{"$f":"D90*C90","v":0},{"$f":"VLOOKUP(A90,'2019'!C$3:H$225,5,FALSE)","v":429},0]
["CLA214D","Audio 4-Bulb Duty Corridor Light",{"$f":"'R5K Details'!J106","v":0},null,null,null,0]
["DCA200","Audio Domeless Controller - 6 pt",{"$f":"'R5K Details'!J107","v":0},null,null,null,0]
["DCA214D","Audio Duty Domeless Controller - 6 pt",{"$f":"'R5K Details'!J108","v":0},null,null,null,0]
["DCA216","Audio Domeless Controller - 16 pt",{"$f":"'R5K Details'!J109","v":0},null,null,null,0]
["CLAR46","Four Station Audio Relay Kit",{"$f":"'R5K Details'!J93","v":0},{"$f":"VLOOKUP(A95,'2019'!C$3:H$225,6,FALSE)","v":44},{"$f":"D95*C95","v":0},{"$f":"VLOOKUP(A95,'2019'!C$3:H$225,5,FALSE)","v":132},0]
["R4KOUT4R","Visual Relay Output Control",{"$f":"'R5K Details'!J111","v":0},null,null,null,0]
["R4KOUT4S","Audio Solid State Relay Output Control",{"$f":"'R5K Details'!J112","v":0},null,null,null,0]
[]
[]
[]
[]
[]
[null,null,"Subtotal (R5K)",null,{"$f":"SUM(E9:E102)","v":6504},null,{"$f":"SUM(G9:G102)","v":19143}]
[]
[]
["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":0},{"$f":"VLOOKUP(A110,'2019'!C$3:H$225,6,FALSE)","v":3210},{"$f":"D110*C110","v":0},{"$f":"VLOOKUP(A110,'2019'!C$3:H$225,5,FALSE)","v":9000},{"$f":"F110*C110","v":0}]
["R5KMADT","ADT Integration Software License (1 per system)",{"$f":"'R5K Details'!J17","v":0},{"$f":"VLOOKUP(A111,'2019'!C$3:H$225,6,FALSE)","v":1338},0,{"$f":"VLOOKUP(A111,'2019'!C$3:H$225,5,FALSE)","v":3750},{"$f":"F111*C111","v":0}]
["R5KMRSI","Resident Safety Interface",{"$f":"'R5K Details'!J18","v":0},{"$f":"VLOOKUP(A112,'2019'!C$3:H$225,6,FALSE)","v":1000},0,{"$f":"VLOOKUP(A112,'2019'!C$3:H$225,5,FALSE)","v":3000},0]
["355005","Responder SIP Server (1 per System)",{"$f":"'R5K Details'!J21","v":0},{"$f":"VLOOKUP(A113,'2019'!C$3:H$225,6,FALSE)","v":1650},0,{"$f":"VLOOKUP(A113,'2019'!C$3:H$225,5,FALSE)","v":4125},0]
["R5KMSIP","SIP Telephony Software License (1 per system)",{"$f":"'R5K Details'!J19","v":0},{"$f":"VLOOKUP(A114,'2019'!C$3:H$225,6,FALSE)","v":1846},0,{"$f":"VLOOKUP(A114,'2019'!C$3:H$225,5,FALSE)","v":5175},{"$f":"F114*C114","v":0}]
["R5KMMWI","Middleware Interface",{"$f":"'R5K Details'!J20","v":0},{"$f":"VLOOKUP(A115,'2019'!C$3:H$225,6,FALSE)","v":1667},0,{"$f":"VLOOKUP(A115,'2019'!C$3:H$225,5,FALSE)","v":5000},0]
[null,null,"Subtotal (Software)",null,{"$f":"SUM(E110:E113)","v":0},null,{"$f":"SUM(G110:G112)","v":0}]
[null,null,null,null,"SMA",{"$f":"E113*0.15","v":0}]
["Accessories"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
["350018","8pin Inlinecon Cat-5 Cat-6(100) (Not to be used with R4K CL/DC)",{"$f":"'R5K Details'!J114","v":2},{"$f":"VLOOKUP(A122,'2019'!C$3:H$225,6,FALSE)","v":135},{"$f":"D122*C122","v":270},{"$f":"VLOOKUP(A122,'2019'!C$3:H$225,5,FALSE)","v":337.5},{"$f":"F122*C122","v":675},"# of R4K CL/DC"]
["350006","Crimping tool Adapter",{"$f":"'R5K Details'!J117","v":0},{"$f":"VLOOKUP(A123,'2019'!C$3:H$225,6,FALSE)","v":33},0,{"$f":"VLOOKUP(A123,'2019'!C$3:H$225,5,FALSE)","v":82.5},{"$f":"F123*C123","v":0},{"$f":"SUM('R5K Details'!J100:J109)","v":0}]
["R4KCONN6","6-Pin connectors (Bag of 100)",{"$f":"'R5K Details'!J115","v":0},{"$f":"VLOOKUP(A124,'2019'!C$3:H$225,6,FALSE)","v":162},0,{"$f":"VLOOKUP(A124,'2019'!C$3:H$225,5,FALSE)","v":486},0]
["R4KCONN8","8-Pin connectors (Bag of 100)",{"$f":"'R5K Details'!J116","v":0},null,null,null,0]
["R4KCRIMP","Responder 4000 Crimp Tool",{"$f":"'R5K Details'!J119","v":0},{"$f":"VLOOKUP(A126,'2019'!C$3:H$225,6,FALSE)","v":20},{"$f":"D126*C126","v":0},{"$f":"VLOOKUP(A126,'2019'!C$3:H$225,5,FALSE)","v":60},0]
["R4KSTAC","R4K Test Adapter Cables",{"$f":"'R5K Details'!J120","v":0},{"$f":"VLOOKUP(A127,'2019'!C$3:H$225,6,FALSE)","v":43},0,{"$f":"VLOOKUP(A127,'2019'!C$3:H$225,5,FALSE)","v":129},{"$f":"F127*C127","v":0}]
["350007","Station Removal Tool",{"$f":"'R5K Details'!J118","v":0},{"$f":"VLOOKUP(A128,'2019'!C$3:H$225,6,FALSE)","v":16},0,{"$f":"VLOOKUP(A128,'2019'!C$3:H$225,5,FALSE)","v":40},0]
["R4KKBS","K-Bus Splitter",{"$f":"'R5K Details'!J121","v":0},{"$f":"VLOOKUP(A129,'2019'!C$3:H$225,6,FALSE)","v":14},0,{"$f":"VLOOKUP(A129,'2019'!C$3:H$225,5,FALSE)","v":42},0]
["R4KKBSP","K-Bus Splitter w/ Power",{"$f":"'R5K Details'!J122","v":0},{"$f":"VLOOKUP(A130,'2019'!C$3:H$225,6,FALSE)","v":18},0,{"$f":"VLOOKUP(A130,'2019'!C$3:H$225,5,FALSE)","v":48},0]
["R4KFB1","Feature Bed Interface",{"$f":"'R5K Details'!J81","v":0},{"$f":"VLOOKUP(A131,'2019'!C$3:H$225,6,FALSE)","v":44},0,{"$f":"VLOOKUP(A131,'2019'!C$3:H$225,5,FALSE)","v":132},0]
["R4KSLC1","Single Light Control Module",{"$f":"'R5K Details'!J82","v":0},{"$f":"VLOOKUP(A132,'2019'!C$3:H$225,6,FALSE)","v":27},0,{"$f":"VLOOKUP(A132,'2019'!C$3:H$225,5,FALSE)","v":81},0]
["R4KDLC2","Dual Light Control Module",{"$f":"'R5K Details'!J83","v":0},{"$f":"VLOOKUP(A133,'2019'!C$3:H$225,6,FALSE)","v":45},0,{"$f":"VLOOKUP(A133,'2019'!C$3:H$225,5,FALSE)","v":135},0]
["R4KTVA","TV Adapter pigtail kit (Set of 10)",{"$f":"'R5K Details'!J84","v":0},{"$f":"VLOOKUP(A134,'2019'!C$3:H$225,6,FALSE)","v":14},0,{"$f":"VLOOKUP(A134,'2019'!C$3:H$225,5,FALSE)","v":42},0]
["R4KTVR1","Digital TV Isolation Module",{"$f":"'R5K Details'!J85","v":0},{"$f":"VLOOKUP(A135,'2019'!C$3:H$225,6,FALSE)","v":18},0,{"$f":"VLOOKUP(A135,'2019'!C$3:H$225,5,FALSE)","v":54},0]
["NC4JACK","1/4\" Jack Auxiliary Input Station",{"$f":"'R5K Details'!J138","v":0},{"$f":"VLOOKUP(A136,'2019'!C$3:H$225,6,FALSE)","v":78},0,{"$f":"VLOOKUP(A136,'2019'!C$3:H$225,5,FALSE)","v":195},0]
["NCBED","37-pin Feature Bed Receptacle",{"$f":"'R5K Details'!J139","v":0},{"$f":"VLOOKUP(A137,'2019'!C$3:H$225,6,FALSE)","v":58},0,{"$f":"VLOOKUP(A137,'2019'!C$3:H$225,5,FALSE)","v":145},0]
["NCC37","37-pin Feature Bed Cable",{"$f":"'R5K Details'!J140","v":0},{"$f":"VLOOKUP(A138,'2019'!C$3:H$225,6,FALSE)","v":63},0,{"$f":"VLOOKUP(A138,'2019'!C$3:H$225,5,FALSE)","v":157.5},0]
["NCC37RA","37-pin Feature Bed Cable -Right Angle",{"$f":"'R5K Details'!J141","v":0},{"$f":"VLOOKUP(A139,'2019'!C$3:H$225,6,FALSE)","v":63},0,{"$f":"VLOOKUP(A139,'2019'!C$3:H$225,5,FALSE)","v":157.5},0]
["NCLV120","Low Voltage Lighting Control 120V",null,null,null,null,0]
["350008","Clear Station Cover (1 & 2 Button Stations)",{"$f":"'R5K Details'!J125","v":0},{"$f":"VLOOKUP(A141,'2019'!C$3:H$225,6,FALSE)","v":25},{"$f":"D141*C141","v":0},{"$f":"VLOOKUP(A141,'2019'!C$3:H$225,5,FALSE)","v":62.5},0]
["350026","R5 & R4K Single Gang Adapter Plates",{"$f":"'R5K Details'!J124","v":0},{"$f":"VLOOKUP(A142,'2019'!C$3:H$225,6,FALSE)","v":21},0,{"$f":"VLOOKUP(A142,'2019'!C$3:H$225,5,FALSE)","v":52.5},{"$f":"F142*C142","v":0}]
["350027","Recessed 1-Gang Adapter Plates",{"$f":"'R5K Details'!J127","v":0},{"$f":"VLOOKUP(A143,'2019'!C$3:H$225,6,FALSE)","v":41},0,{"$f":"VLOOKUP(A143,'2019'!C$3:H$225,5,FALSE)","v":102.5},0]
["350028","Recessed 2-Gang Adapter Plates",{"$f":"'R5K Details'!J127","v":0},{"$f":"VLOOKUP(A144,'2019'!C$3:H$225,6,FALSE)","v":46},0,{"$f":"VLOOKUP(A144,'2019'!C$3:H$225,5,FALSE)","v":115},0]
["R4KWM22","Wall Mount Kit for Annunciate Panel",{"$f":"'R5K Details'!J30","v":0},{"$f":"VLOOKUP(A145,'2019'!C$3:H$225,6,FALSE)","v":81},0,{"$f":"VLOOKUP(A145,'2019'!C$3:H$225,5,FALSE)","v":243},0]
["R4KDM22","Desk Mount Kit",{"$f":"'R5K Details'!J31","v":0},{"$f":"VLOOKUP(A146,'2019'!C$3:H$225,6,FALSE)","v":63},0,{"$f":"VLOOKUP(A146,'2019'!C$3:H$225,5,FALSE)","v":189},0]
["R4KHVK","R4K 250v Kit For NC2828",null,null,null,null,{"$f":"F147*C147","v":0}]
["CLS103","3 Lamp High Security Dome Lite",{"$f":"'R5K Details'!J128","v":0},{"$f":"VLOOKUP(A148,'2019'!C$3:H$225,6,FALSE)","v":92},{"$f":"D148*C148","v":0},{"$f":"VLOOKUP(A148,'2019'!C$3:H$225,5,FALSE)","v":276},{"$f":"F148*C148","v":0}]
["R5KPADP","R5K Adapter Plates (10)",{"$f":"'R5K Details'!J123","v":0},{"$f":"VLOOKUP(A149,'2019'!C$3:H$225,6,FALSE)","v":37},0,{"$f":"VLOOKUP(A149,'2019'!C$3:H$225,5,FALSE)","v":111},{"$f":"F149*C149","v":0}]
[]
[]
[]
[]
[null,null,"Subtotal (Accessories) ",null,{"$f":"SUM(E122:E141,E143:E153)","v":270},null,{"$f":"SUM(G122:G153)","v":675}]
[]
[]
[]
[{"$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":"2022-12-27"}]
[]
["Pillow Speakers/Call Cords"]
[]
["Model # ","Description","Quantity","Price","Total"," List Price","Extended List Price"]
[]
["NCPSDSL2","Digital Pillow Speaker, 2 Lts",{"$f":"'R5K Details'!J130","v":0},{"$f":"VLOOKUP(A167,'2019'!C$3:H$225,6,FALSE)","v":110},{"$f":"D167*C167","v":0},{"$f":"VLOOKUP(A167,'2019'!C$3:H$225,5,FALSE)","v":330},{"$f":"F167*C167","v":0}]
["NCPSDSTV","Digital Pillow Speaker, TV",{"$f":"'R5K Details'!J131","v":0},{"$f":"VLOOKUP(A168,'2019'!C$3:H$225,6,FALSE)","v":110},0,{"$f":"VLOOKUP(A168,'2019'!C$3:H$225,5,FALSE)","v":330},{"$f":"F168*C168","v":0}]
["NCPSKPL2","Direct Access Digital PS, 2 Lt",{"$f":"'R5K Details'!J132","v":0},{"$f":"VLOOKUP(A169,'2019'!C$3:H$225,6,FALSE)","v":115},0,{"$f":"VLOOKUP(A169,'2019'!C$3:H$225,5,FALSE)","v":345},0]
["NCPSKPTV","Direct Access Digital PS, TV",{"$f":"'R5K Details'!J133","v":0},{"$f":"VLOOKUP(A170,'2019'!C$3:H$225,6,FALSE)","v":115},0,{"$f":"VLOOKUP(A170,'2019'!C$3:H$225,5,FALSE)","v":345},0]
["NCSAV","DIN Cord Saver",{"$f":"'R5K Details'!J134","v":0},{"$f":"VLOOKUP(A171,'2019'!C$3:H$225,6,FALSE)","v":17},0,{"$f":"VLOOKUP(A171,'2019'!C$3:H$225,5,FALSE)","v":42.5},0]
["CCDIN3","Handheld Pendent - 2 Lights (8-pin DIN)",{"$f":"'R5K Details'!J135","v":0},{"$f":"VLOOKUP(A172,'2019'!C$3:H$225,6,FALSE)","v":47},0,{"$f":"VLOOKUP(A172,'2019'!C$3:H$225,5,FALSE)","v":117.5},0]
["CCDIN","Call Cord - Single w/ Clip (10 ft.)",{"$f":"'R5K Details'!J136","v":41},{"$f":"VLOOKUP(A173,'2019'!C$3:H$225,6,FALSE)","v":22},902,{"$f":"VLOOKUP(A173,'2019'!C$3:H$225,5,FALSE)","v":55},2255]
["CC200","Call Cord - 1/4\" Jack Call Cord w/ Clip (10ft.)",{"$f":"'R5K Details'!J137","v":0},{"$f":"VLOOKUP(A174,'2019'!C$3:H$225,6,FALSE)","v":18},0,{"$f":"VLOOKUP(A174,'2019'!C$3:H$225,5,FALSE)","v":45},0]
[null,null,"Subtotal (PS/CC) ",null,{"$f":"SUM(E167:E174)","v":902},null,{"$f":"SUM(G167:G174)","v":2255}]
["Other"]
[]
["Model # ","Description","Quantity","Price","Total"," List Price","Extended List Price"]
[]
[{"$f":"IF('R5K Details'!B148=\"\",\"\",'R5K Details'!B148)","v":"STG"},{"$f":"IF('R5K Details'!B148=\"\",\"\",'R5K Details'!E148)","v":"WaveWare SIP to Tap Gateway"},{"$f":"'R5K Details'!J148","v":1},"http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/"]
[{"$f":"IF('R5K Details'!B149=\"\",\"\",'R5K Details'!B149)","v":"SPS-5V9E"},{"$f":"IF('R5K Details'!B149=\"\",\"\",'R5K Details'!E149)","v":"WaveWare Paging Transmitter for STG, 5W, Site Licensing "},{"$f":"'R5K Details'!J149","v":1},"http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/"]
[{"$f":"IF('R5K Details'!B150=\"\",\"\",'R5K Details'!B150)","v":"0250-1250  "},{"$f":"IF('R5K Details'!B150=\"\",\"\",IF('R5K Details'!A150<>\"Rauland\",'R5K Details'!E150,\"\"))","v":"WaveWare Responder 5000 Messaging Server  "},{"$f":"'R5K Details'!J150","v":0},"http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/"]
[{"$f":"IF('R5K Details'!B151=\"\",\"\",'R5K Details'!B151)","v":"0250-1003  "},{"$f":"IF('R5K Details'!B151=\"\",\"\",IF('R5K Details'!A151<>\"Rauland\",'R5K Details'!E151,\"\"))","v":"WaveWare 10 User Account Bundle (app licenses)"},{"$f":"'R5K Details'!J151","v":0},"http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/","http://wirelessmessaging.com/"]
[{"$f":"IF('R5K Details'!B152=\"\",\"\",'R5K Details'!B152)","v":""},{"$f":"IF('R5K Details'!B152=\"\",\"\",'R5K Details'!E152)","v":""},{"$f":"'R5K Details'!J152","v":0},{"$f":"IF(F184=\"FQ\",\"FQ\",F184*F$4)","v":0},{"$f":"IF(D184=\"FQ\",\"FQ\",(C184*D184))","v":0},{"$f":"IF('R5K Details'!A152<>\"Rauland\",'R5K Details'!K152,VLOOKUP(A184,'2019'!#REF!,5,FALSE))","v":0},{"$f":"IF(F184=\"FQ\",\"FQ\",F184*C184)","v":0}]
[{"$f":"IF('R5K Details'!B153=\"\",\"\",'R5K Details'!B153)","v":""},{"$f":"IF('R5K Details'!B153=\"\",\"\",'R5K Details'!E153)","v":""},{"$f":"'R5K Details'!J153","v":0},0,0,{"$f":"IF('R5K Details'!A153<>\"Rauland\",'R5K Details'!K153,VLOOKUP(A185,'2019'!#REF!,5,FALSE))","v":0},{"$f":"IF(F185=\"FQ\",\"FQ\",F185*C185)","v":0}]
[{"$f":"IF('R5K Details'!B154=\"\",\"\",'R5K Details'!B154)","v":""},{"$f":"IF('R5K Details'!B154=\"\",\"\",'R5K Details'!E154)","v":""},{"$f":"'R5K Details'!J154","v":0},0,0,{"$f":"IF('R5K Details'!A154<>\"Rauland\",'R5K Details'!K154,VLOOKUP(A186,'2019'!#REF!,5,FALSE))","v":0},0]
[{"$f":"IF('R5K Details'!B155=\"\",\"\",'R5K Details'!B155)","v":""},{"$f":"IF('R5K Details'!B155=\"\",\"\",'R5K Details'!E155)","v":""},{"$f":"'R5K Details'!J155","v":0},0,0,{"$f":"IF('R5K Details'!A155<>\"Rauland\",'R5K Details'!K155,VLOOKUP(A187,'2019'!#REF!,5,FALSE))","v":0},0]
[null,null,null,null,null,null,0]
[null,"Subtotal (Other) ",null,null,{"$f":"SUM(E180:E188)","v":0},"list total",{"$f":"SUM(G180:G188)","v":0}]
[]
["Bio-Seals"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
["350011","Bio-seals - Cancel Button (10)",{"$f":"'R5K Details'!J145","v":0},{"$f":"VLOOKUP(A195,'2019'!C$3:H$225,6,FALSE)","v":11},{"$f":"D195*C195","v":0},{"$f":"VLOOKUP(A195,'2019'!C$3:H$225,5,FALSE)","v":27.5},{"$f":"F195*C195","v":0}]
["350012","Bio-seals- Small Push-Button (10) ",{"$f":"'R5K Details'!J146","v":0},{"$f":"VLOOKUP(A196,'2019'!C$3:H$225,6,FALSE)","v":11},0,{"$f":"VLOOKUP(A196,'2019'!C$3:H$225,5,FALSE)","v":27.5},{"$f":"F196*C196","v":0}]
["350013","Bio-seals- Large Push-Button (10) ",{"$f":"'R5K Details'!J147","v":0},{"$f":"VLOOKUP(A197,'2019'!C$3:H$225,6,FALSE)","v":15},0,{"$f":"VLOOKUP(A197,'2019'!C$3:H$225,5,FALSE)","v":37.5},0]
["350014","Bio-seals- Left side Pt Stn (10) ",null,{"$f":"VLOOKUP(A198,'2019'!C$3:H$225,6,FALSE)","v":17},0,{"$f":"VLOOKUP(A198,'2019'!C$3:H$225,5,FALSE)","v":42.5},0]
["350015","Bio-seals- Right side Pt.Stn (10) ",null,{"$f":"VLOOKUP(A199,'2019'!C$3:H$225,6,FALSE)","v":17},0,{"$f":"VLOOKUP(A199,'2019'!C$3:H$225,5,FALSE)","v":42.5},0]
["350400","Bio-seals- Staff Terminal LCD (5)",null,{"$f":"VLOOKUP(A200,'2019'!C$3:H$225,6,FALSE)","v":21},0,{"$f":"VLOOKUP(A200,'2019'!C$3:H$225,5,FALSE)","v":52.5},0]
[null,null,"Subtotal (Bio-Seal) ",null,{"$f":"SUM(E195:E200)","v":0},null,{"$f":"SUM(G195:G200)","v":0}]
[]
[]
["Labor/Cable"]
[]
["Model # ","Description","Quantity","Price","Extended Price"," List Price","Extended List Price"]
[]
[null,"Cable","cable hours",{"$f":"'R5K Details'!O181","v":64},null,"Total cable price",{"$f":"Labor_Installation!K6","v":680}]
[null,"labor","R5K shop",{"$f":"'R5K Details'!O156","v":0},"R5K field labor",{"$f":"'R5K Details'!Q156","v":61.2},{"$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":"E103+E116+E154+E175+E189+E201","v":7676}]

{"sheet":"Revision History","index":5,"n_rows":121,"n_cols":2,"rows_kept":121,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Release Notes of AutoQuote Program"]
["Version  ","Changes Included"]
[]
["Version 1.50","1. Allow a -1 to be entered for 355005."]
[]
["Version 1.49","1. Corrected the distributor net for the MSIP."]
[]
["Version 1.48","1. Corrected the autocalculation of the R5KL2KA."]
[]
["Version 1.47","1. Corrected the input options for the Input for Auto Config tab."]
[]
["Version 1.46","1. Corrected the auto calculation of R5KMRPT and R5KMSIP when other software modules included."]
[]
["Version 1.45","1. Corrected the Order output for software modules."]
[]
["Version 1.44","1. Added R5KMMWI Middleware Interface.  This requires R5KMSIP."]
[null,"2. Added R5KMRSI Resident Safety Interface.  This requires R5KMRPT."]
[]
["Version 1.43","1. Added R5KMADT ADT Integration Software License.  This requires R5KMRPT."]
[]
["Version 1.42","1. Description of SMA corrected"]
[null,"2. R5KCANCEL station added."]
[]
["Version 1.41","1. Updated to 2019 pricing."]
[]
["Version 1.40","1. Added R5KPB4CNF, R5KCANCEL and pull cord cut out for recessing."]
[]
["Version 1.39","1. Updated MSC autocalulations to take number of consoles into account."]
[]
["Version 1.38","1. Corrected the Order tab to show additional items."]
[null,"2. Added the R5KMADT ADT Integration Software."]
[]
["Version 1.37","1. Corrected Autocalculations when using the CLA246."]
[]
["Version 1.36","1. Widened the totals. column on the Labor_Installation tab."]
[null,"2. Corrected the totals section for the cabling."]
[]
["Version 1.35","1. Corrected some pricing."]
[]
["Version 1.34","1. Added WaterProof Pull Cord Stations."]
[null,"2. Remove Low Volt Light Controllers."]
[]
["Version 1.33","1. Please obtain a quotation from WaveWare for all WaveWare items. "]
[]
["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 of 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":"2019","index":6,"n_rows":218,"n_cols":9,"rows_kept":218,"cut":false,"hidden":false,"merged":[]}
["THIS DOCUMENT IS FOR INTERNAL USE ONLY. DO NOT DISTRIBUTE",null,"",null,null,null,null,null,"discount multiplier"]
["Pricelist",null,"",null,null,null,"List","Dist net Int"]
[null,null,"301103","Responder Wireless Wall Unit",60,null,340,136,0.4]
["HC",null,"301200","Wireless Bed Unit-socket (hr)",60,null,362.5,145,0.4]
["HC",null,"301210","Wb Unit-plug (stryker)",60,null,362.5,145,0.4]
["HC",null,"301300","Wireless Bed Demo Kit-stryker",12,null,1030,412,0.4]
["HC",null,"350000","Demonstration Unit",12,null,34420,13768,0.4]
["HC",null,"350002","L-net T-tap Module (25)",18,null,642.5,257,0.4]
["HC",null,"350003","L-net Term Resistor (10)",18,null,540,216,0.4]
["HC",null,"350004","L-net Hub",18,null,297.5,119,0.4]
["HC",null,"350005","M-net Divider Interface",18,null,65,26,0.4]
["HC",null,"350006","Crimping Tool Adapter",12,null,82.5,33,0.4]
["HC",null,"350007","Station Removal Tool",12,null,40,16,0.4]
["HC",null,"350008","Clear Station Cover",18,null,62.5,25,0.4]
["HC",null,"350009","351003 Battery Kit",18,null,110,44,0.4]
["HC",null,"350011","Overlay Kit Cancel Button (10)",18,null,27.5,11,0.4]
["HC",null,"350012","Overlay Kit Sm Push Button(10)",18,null,27.5,11,0.4]
["HC",null,"350013","Overlay Kit Lg Push Button(10)",18,null,37.5,15,0.4]
["HC",null,"350014","Overlay Kit Left Side Stn (10)",18,null,42.5,17,0.4]
["HC",null,"350015","Overlay Kit Right Side Stn(10)",18,null,42.5,17,0.4]
["HC",null,"350017","L-net T-tap Insulator (25)",18,null,52.5,21,0.4]
["HC",null,"350018","8pn Inlinecon Cat-5 Cat-6(100)",18,null,337.5,135,0.4]
["HC",null,"350019","Responder 5 L-net Test Adapter",18,null,70,28,0.4]
["HC",null,"350022","Clear Button Cover For 353001",18,null,42.5,17,0.4]
["HC",null,"350023","Clear Button Cover-4 Button S",18,null,65,26,0.4]
["HC",null,"350024","Pillow Spker Cord Grip Kit 20",18,null,82.5,33,0.4]
["HC",null,"350025","3-gang Adapter Plates (10)",18,null,77.5,31,0.4]
["HC",null,"350026","1-gang Adapter Plates (10)",18,null,52.5,21,0.4]
["HC",null,"350027","Recessed 1-gang Plate 10 Pack",60,null,102.5,41,0.4]
["HC",null,"350028","Recessed 2-gang Plate 10 Pack",60,null,115,46,0.4]
["HC",null,"350032","R5demo Upgrade Kit",60,null,9500,3800,0.4]
["HC",null,"350100","Call Cord W/tilt Release Din",24,null,80,32,0.4]
["HC",null,"350200","Enhncd Pillow Spkr-tv-digi Vol",24,null,312.5,125,0.4]
["HC",null,"350201","Enhncd Pillowspkr-1lgt-digivol",24,null,312.5,125,0.4]
["HC",null,"350202","Enhncd Pillowspkr-2lgt-digivol",24,null,312.5,125,0.4]
["HC",null,"350205","Enhncd Pillow Spkr-tv-anlgvol",24,null,312.5,125,0.4]
["HC",null,"350206","Enhanced Pillow Spkr 1 Light",24,null,312.5,125,0.4]
["HC",null,"350207","Enhncd Pillowspkr 2 Lgt-anlgvo",24,null,312.5,125,0.4]
["HC",null,"350220","Std Pillow Spkr-tv-digi Vol",24,null,312.5,125,0.4]
["HC",null,"350221","Std Pillow Spkr-1 Lgt-digi Vol",24,null,312.5,125,0.4]
["HC",null,"350222","Std Pillowspkr-2 Lgt-digi Vol",24,null,312.5,125,0.4]
["HC",null,"350225","Std Pillow Spkr-tv-anlg Vol",24,null,312.5,125,0.4]
["HC",null,"350226","Std Pillowspkr-1 Lgt-anlg Vol",24,null,312.5,125,0.4]
["HC",null,"350227","Std Pillowspkr-2 Lgt-anlg Vol\\",24,null,312.5,125,0.4]
["HC",null,"350240","Basic Pillow Speaker-tv",24,null,212.5,85,0.4]
["HC",null,"350241","Basic Pillow Speaker-1 Light",24,null,195,78,0.4]
["HC",null,"350242","Basic Pillow Speaker-2 Lights",24,null,212.5,85,0.4]
["HC",null,"350300","Remote Tilt Release Din Stn",60,null,205,82,0.4]
["HC",null,"350301","Remote Std 8-pin Din Station",60,null,220,88,0.4]
["HC",null,"350302","Feature Bed Control Module",60,null,187.5,75,0.4]
["HC",null,"350400","Staff Term Faceplate W Bioseal",60,null,52.5,21,0.4]
["HC",null,"351001","Branch Regional Controller V2",60,null,1797.5,719,0.4]
["HC",null,"351002","Responder Ntwrk Adapter Module",60,null,11572.5,4629,0.4]
["HC",null,"351003","Power Supply W/batt. Backup",60,null,1305,522,0.4]
["HC",null,"351004","8 Port Ethernet Switch W/poe",60,null,1145,458,0.4]
["HC",null,"351006","Fiber Optic Adapter Module",60,null,510,204,0.4]
["HC",null,"351010","Responder Network Concentrator",60,null,12107.5,4843,0.4]
["HC",null,"351101","Rack Mount Kit For Switches",60,null,110,44,0.4]
["HC",null,"351102","Wall Mounting Cabinet-head-end",60,null,1145,458,0.4]
["HC",null,"351201","Console Receptacle",60,null,92.5,37,0.4]
["HC",null,"351203","Console Desk Stand",60,null,157.5,63,0.4]
["HC",null,"351205","Voip Nurse Console V2",60,null,2082.5,833,0.4]
["HC",null,"351310","Voip Staff Terminal V2",60,null,1627.5,651,0.4]
["HC",null,"352004","Mini-corridor Light",60,null,167.5,67,0.4]
["HC",null,"352010","Corridor Light-4 Pos V2",60,null,617.5,247,0.4]
["HC",null,"352021","Domeless Controller V2",60,null,612.5,245,0.4]
["HC",null,"353000","Single Patient Station",60,null,555,222,0.4]
["HC",null,"353001","Enhanced Single Patient Stn",60,null,617.5,247,0.4]
["HC",null,"353010","Dual Patient Station",60,null,655,262,0.4]
["HC",null,"353100","Duty Station",60,null,547.5,219,0.4]
["HC",null,"353101","Staff Station",60,null,515,206,0.4]
["HC",null,"353200","Remote Audio Output Station",60,null,405,162,0.4]
["HC",null,"353201","Remote Audio Output Module",60,null,315,126,0.4]
["HC",null,"354000","Pull-cord Station With Audio",60,null,362.5,145,0.4]
["HC",null,"354001","Pull-cord Station",60,null,160,64,0.4]
["HC",null,"354010","Cancel Station",60,null,172.5,69,0.4]
["HC",null,"354011","Code Station",60,null,172.5,69,0.4]
["HC",null,"354012","Staff Assist Station",60,null,172.5,69,0.4]
["HC",null,"354015","Staff Assist / Code Station",60,null,177.5,71,0.4]
["HC",null,"354016","Bed Management Station",60,null,227.5,91,0.4]
["HC",null,"354017","Staff Registration Station",60,null,227.5,91,0.4]
["HC",null,"354018","2-jack Station",60,null,205,82,0.4]
["HC",null,"354100","Input Module - 2 Point",60,null,170,68,0.4]
["HC",null,"354101","Output Module-high Current",60,null,235,94,0.4]
["HC",null,"354102","Output Module-dry Contact",60,null,185,74,0.4]
["HC",null,"354103","Output Module-low Current",60,null,187.5,75,0.4]
["HC",null,"355000","R5ware Firmware Diagnostics",12,null,0,0,0.4]
["HC",null,"355002","Interface-telephone-25 Beds",12,null,2317.5,927,0.4]
["HC",null,"355005","Responder Sip Server",12,null,4125,1650,0.4]
["HC",null,"356000","Responder 5 Demo Laptop",12,null,8812.5,3525,0.4]
["HC",null,"366102","Pc Console (r5 Apps) - 25 Beds",12,null,2317.5,927,0.4]
["HC",null,"366104","Staff Assignment Client-25 Bed",12,null,2317.5,927,0.4]
["HC",null,"366200","Reports Manager - 25 Beds",12,null,2317.5,927,0.4]
["HC","|","366201","Data Warehouse",12,null,30000,10000,0.4]
["HC","|","366202","Business Intelligence",12,null,15000,5000,0.35699999999999998]
["HC",null,"366401","Interface-locate(rtls)-25 Beds",12,null,2317.5,927,0.35699999999999998]
["HC",null,"366402","Interface-hl7(adt)-25 Beds",12,null,2317.5,927,0.4]
["HC",null,"366403","Interface-resp Sync-25 Bed",12,null,2317.5,927,0.4]
["HC",null,"366404","All Touch Emr -25 Beds",12,null,2317.5,927,0.4]
["HC",null,"366406","All Touch Bed Mgmt-25 Beds",12,null,2317.5,927,0.4]
["HC",null,"366407","All Touch Iptv-25 Beds",12,null,1187.5,475,0.4]
["HC",null,"366409","All Touch Bed Info-25 Beds",12,null,1187.5,475,0.4]
["HC",null,"370000","Responder Enterprise Configurator",12,null,0,0,0.4]
["HC",null,"370001","Responder Local Configurator",12,null,0,0,0.4]
["HC",null,"350400A","Staff Term Faceplt Bioseal Wht",60,null,52.5,21,0.4]
["HC",null,"353000A","Single Pat Stat - Aus (white)",60,null,555,222,0.4]
["HC",null,"353001A","Enhance Pat Stat - Aus (white)",60,null,640,256,0.4]
["HC",null,"354001WP","Pull-cord Station Water Proof",60,null,172.5,69,0.4]
["HC",null,"354001WPA","Pull-cord Statin Wp Australian",60,null,170,68,0.4]
["HC",null,"354001WPP","Pull-cord Statin Wp Portuguese",60,null,170,68,0.4]
["HC",null,"354001WPS","Pull-cord Station Wp Spanish",60,null,172.5,69,0.4]
["HC",null,"354011A","Code Station - Aus (white)",60,null,187.5,75,0.4]
["HC",null,"354012A","Staff Assist - Aus (white)",60,null,187.5,75,0.4]
["HC",null,"354016A","Bed Manage Stat - Aus (white)",60,null,260,104,0.4]
["HC",null,"354018A","2 Jack Station - Aus (white)",60,null,215,86,0.4]
["HC",null,"366405-1","All Touch Wire.wkflw #1-25 Bed",12,null,1187.5,475,0.4]
["HC",null,"366405-2","All Touch Wire.wkflw #2-25 Bed",12,null,1187.5,475,0.4]
["HC",null,"366408-1","All Touch Med Devices-25 Beds",12,null,1187.5,475,0.4]
["HC",null,"366408-2","All Touch Med Devices-25 Beds",12,null,1187.5,475,0.4]
["HC",null,"AB4487","Wall Mtg Plate Standard",60,null,67.5,27,0.4]
["HC",null,"CC200","Call Cord W/ Clip - 10ft",24,null,45,18,0.33300000000000002]
["HC",null,"CCDIN","Call Cord - Din Connector",24,null,55,22,0.33300000000000002]
["HC",null,"CCDIN3","Handheld Pendant W/2 Lights",24,null,117.5,47,0.33300000000000002]
["HC",null,"CM300","Chassis Fault Monitor",18,null,385,{"$f":"ROUNDUP(G124*I124,0)","v":129},0.33300000000000002]
["HC","|","CLA246","R5k 4light/6pt Audio Cl",60,null,429,143,0.4]
["HC","|","CLAR46","R5k 4 Pt Audio Relay Kit",60,null,132,44,0.4]
["HC","|","CLS103","R5k High Security Cl 3 Lamp",18,null,276,92,0.4]
["HC",null,"CP7385","Nurse Pushbutton 1/4\" Jack",18,null,50,20,0.4]
["HC",null,"DP300","Dummy Plug For Din Jacks",18,null,10,4,0.4]
["HC",null,"DP7380","Dummy Plug For 1/4",18,null,10,4,0.33300000000000002]
["HC",null,"DTP4401","Din-to-plug Adapter",18,null,40,16,0.33300000000000002]
["HC","|","HSS400","R5k High Security Audio Bed St",18,null,774,258,0.33300000000000002]
["HC","|","HSS401","R5k High Security Staff St",18,null,774,258,0.4]
["HC","|","HSS433","R5k High Security Push Btn St",18,null,774,258,0.4]
["HC",null,"NC2828","Head-end Equipment Cabinet",60,null,1680,672,0.4]
["HC",null,"NC4JACK","Auxiliary 4 Alarm Input St",18,null,195,78,0.4]
["HC",null,"NCBED","Feature Bed Recep - 37 Pin",24,null,145,58,0.4]
["HC",null,"NCBED5","R5 Feature Bed Recep - 37 Pin",24,null,157.5,63,0.4]
["HC",null,"NCC37","Feat. Bed Cable -8ft",24,null,157.5,63,0.33300000000000002]
["HC",null,"NCC37RA","Feat. Bed Cable -right Angle",24,null,157.5,63,0.33300000000000002]
["HC","|","NCPSDSL2","R5k Digital Pillow Spkr 2 Lts",24,null,330,110,0.33300000000000002]
["HC","|","NCPSDSTV","R5k Digital Pillow Speaker Tv",24,null,330,110,0.33300000000000002]
["HC","|","NCPSKPL2","R5k Dir Acc Pillow Spkr 2lts",24,null,345,115,0.4]
["HC","|","NCPSKPTV","R5k Direct Acc Pillow Spkr Tv",24,null,345,115,0.4]
["HC",null,"NCSAV","Din Cord Saver",24,null,42.5,17,0.33300000000000002]
["HC",null,"PM300","Power Fault Monitor",18,null,342.5,137,0.33300000000000002]
["HC","|","R4K15V","R5k Patient Station 1/4\" & Btn",60,null,123,41,0.33300000000000002]
["HC","|","R4K17V","R5k Enhancd Sgle Pat Stn Wdin",60,null,186,62,0.33300000000000002]
["HC","|","R4K2JACK","R5k Dual 1/4\" Jack Station",60,null,135,45,0.33300000000000002]
["HC","|","R4KANNV2","R5k Annunciator Panel V2",60,null,882,294,0.33300000000000002]
["HC","|","R4KCAL","R5k Call Assurance Light",60,null,81,27,0.33300000000000002]
["HC","|","R4KCB13","R5k Code Blue Station",60,null,102,34,0.33300000000000002]
["HC","|","R4KCONN6","R5k 6-pin Connectors - 100",18,null,486,162,0.33300000000000002]
["HC","|","R4KCRIMP","R5k Crimping Tool",60,null,60,20,0.33300000000000002]
["HC","|","R4KDLC2","R5k Dual Light Cntl Mod",60,null,135,45,0.33300000000000002]
["HC","|","R4KDM22","R5k Desk Mount Kit Ann Pnl",60,null,189,63,0.33300000000000002]
["HC","|","R4KFAM","R5k Fire/auxiliary Module",60,null,117,39,0.33300000000000002]
["HC","|","R4KFB1","R5k Feature Bed Interface",60,null,132,44,0.35699999999999998]
["HC",null,"R4KHVK","R4k 250v Kit For Nc2828",60,null,290,116,0.33300000000000002]
["HC","|","R4KKBS","R5k K-bus Splitter",60,null,42,14,0.33300000000000002]
["HC","|","R4KKBSP","R5k K-bus Splitter - With Pwr",60,null,48,18,0.33300000000000002]
["HC","|","R4KMQCV2","R5k Marquee Controller V2",60,null,507,169,0.33300000000000002]
["HC","|","R4KMST","R5k Marquee Spkr St W/mute",60,null,123,41,0.35599999999999998]
["HC","|","R4KPA25","R5k Paging Amplifier -25 Watt",60,null,858,286,0.36799999999999999]
["HC","|","R4KPB12","R5k Single Button Station",60,null,90,30,0.36799999999999999]
["HC","|","R4KPB23","R5k Staff Assist Code Station",60,null,99,35,0.36799999999999999]
["HC","|","R4KPC11","R5k Pull Cord Station",60,null,93,34,0.33300000000000002]
["HC","|","R4KRECP","R5k Ann Panel Receptacle",60,null,66,22,0.33300000000000002]
["HC","|","R4KSAR","R5k Push For Help St Reg Stn",60,null,102,34,0.35699999999999998]
["HC","|","R4KSLC1","R5k Single Light Cntl Mod",60,null,81,27,0.33300000000000002]
["HC","|","R4KSPK","R5k Speaker Station",60,null,45,16,0.33300000000000002]
["HC","|","R4KSTAC","R5k Test Adapter Cables",60,null,129,43,0.33300000000000002]
["HC","|","R4KTVA","R5k Tv Adaptor Kit Qty 10",60,null,42,14,0.33300000000000002]
["HC","|","R4KTVR1","R5k Digital Tv Isolation Mod",60,null,54,18,0.33300000000000002]
["HC","|","R4KWM22","R5k Ann Panel Wall Mount Kit",60,null,243,81,0.33300000000000002]
["HC","|","R5KCL506","R5k Corridor Light Visual 6pt",60,null,198,66,0.33300000000000002]
["HC","|","R5KCL516","R5k Corridor Light 1 Audio 6pt",60,null,237,79,0.33300000000000002]
["HC","|","R5KCL546","R5k Corridor Light 4 Audio 6pt",60,null,270,90,0.33300000000000002]
["HC","|","R5KCONS","R5k Voip Nurse Console",60,null,1836,612,0.33300000000000002]
["HC","|","R5KDC016","R5k Domeless 16pt Visual",60,null,369,123,0.35]
["HC","|","R5KDC06","R5k Domeless 6pt Visual",60,null,264,97,0.33300000000000002]
["HC","|","R5KDC16D","R5k Domeless Duty 1 Audio 6pt",60,null,330,116,0.33300000000000002]
["HC","|","R5KDC46","R5k Domeless 4 Audio 6pt",60,null,315,105,0.33300000000000002]
["HC","|","R5KDCRC4","R5k Relay Output Controler",60,null,120,40,0.33300000000000002]
["HC","|","R5KDCRCS4","R5k Ss Relay Output Controller",60,null,144,48,0.34300000000000003]
["HC","|","R5KDEMOACT","R5k Demo Acute",60,null,18000,6000,0.33300000000000002]
["HC","|","R5KL2KA","R5k L2k Adapter",60,null,543,186,0.33300000000000002]
["HC","|","R5KLAPTOP","R5k Demo Unit Laptop",12,null,12000,4000,0.35699999999999998]
["HC","|","R5KM8PRT","R5k 8-port Ethernet Switch",60,null,1113,371,0.33300000000000002]
["HC","|","R5KMADT","R5k Adt Interface",12,null,3750,1338,0.33300000000000002]
["HC","|","R5KMPR15","R5k 15v Pwr Sply W Bat Backup",60,null,933,311,0.35699999999999998]
["HC","|","R5KMPR36","R5k 36v Pwr Sply W Bat Backup",60,null,900,300,0.33300000000000002]
["HC","|","R5KMRPT","R5k Application Module",12,null,9000,3210,0.35699999999999998]
["HC","|","R5KMSC","R5k Main System Controller",60,null,1803,601,0.33300000000000002]
["HC","|","R5KMSIP","R5k Telephony Interface",12,null,5175,1846,0.33300000000000002]
["HC","|","R5KMTRM","R5k Termination Board",60,null,183,61,0.33300000000000002]
["HC","|","R5KPADP","R5k Adapter Plates (10)",60,null,111,37,0.33300000000000002]
["HC","|","R5KPB4","R5k 4 Button Workflow Station",60,null,123,41,0.33300000000000002]
["HC","|","R5KPB4CNF","R5k 4 Button Status Station",60,null,123,38,0.33300000000000002]
["HC","|","R5KPC11WP","R5k Waterproof Pullcord",60,null,102,34,0.33300000000000002]
["HC","|","R5KPC11WPA","R5k Waterproof Plcd Australian",60,null,108,36,0.36599999999999999]
["HC","|","R5KPC11WPP","R5k Waterproof Plcd Portuguese",60,null,108,36,0.35]
["HC","|","R5KPC11WPS","R5k Waterproof Pulcord Spanish",60,null,108,36,0.36599999999999999]
["HC","|","R5KPC11WPf","R5k Waterproof Pulcord French",60,null,108,36,0.36599999999999999]
["HC","|","R5KPD2A","R5k Dual Patient Station Audio",60,null,177,59,0.33300000000000002]
["HC","|","R5KPD2EA","R5k Dual Enhancd Pat Stn Audio",60,null,216,79,0.33300000000000002]
["HC","|","R5KPS1A","R5k Single Pat Station Audio",60,null,126,44,0.33300000000000002]
["HC","|","R5KPS1EA","R5k Single Enhcd Pat Stn Audio",60,null,165,61,0.33300000000000002]
["HC","|","R5KPS1LCA","R5k Single Pat Stn W Lt Audio",60,null,180,60,0.33300000000000002]
["HC","|","R5KPS1V","R5k Single Patient Stn Visual",60,null,105,35,0.33300000000000002]
["HC","|","R5KSDTY","R5k Duty Station",60,null,132,44,0.33300000000000002]
["HC","|","R5KSSTF","R5k Staff Station",60,null,111,37,0.33300000000000002]
[null,"|","R5KWARE","R5kware Firmware Diagnostics",12,null,0,0]
[null,null,"R5KPC11WPS","R5K WP Pull Cord Station Spanish",null,null,102,{"$f":"ROUNDUP(G214*I214,0)","v":34},0.33300000000000002]
[null,null,"R5KPC11WPP","R5K WP Pull Cord Station Portuguese",null,null,102,34,0.33300000000000002]
[null,null,"R5KCANCEL","R5K Cancel Station",null,null,102,34,0.33300000000000002]
[null,null,"R5KMMWI","R5K Middleware Interface",null,null,5000,1667,0.33339999999999997]
[null,null,"R5KMRSI","R5K Resident Safety Interface",null,null,3000,1000,0.33329999999999999]

{"sheet":"DropDowns","index":7,"n_rows":91,"n_cols":10,"rows_kept":91,"cut":false,"hidden":false,"merged":[[31,7,31,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 Station","R5KPB4"]
["R5KPB4CNF -  4-button CNF Station","R5KPB4CNF"]
["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"]
["R5KCANCEL - Cancel Station","R5KCANCEL"]
["R5KPC11WP - Waterproof Pullcord Station","R5KPC11WP"]
["R5KPC11WPS - Waterproof Pullcord Station - Spanish","R5KPC11WPS"]
["R5KPC11WPF - Waterproof Pullcord Station - French","R5KPC11WPF"]
["R5KPC11WPP - Waterproof Pullcord Station - Portuguese","R5KPC11WPP"]
["R4KSAR - SLIM Dual Button St","R4KSAR"]
["R4KSPK - SLIM Speaker Module","R4KSPK"]
["NC4JACK - 1/4\" Jack Auxiliary Input Station","NC4JACK"]
["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",null,null,null,null,null,"Number of Bed Stations",{"$f":"SUM('R5K Details'!J33:J39,'R5K Details'!J48:J61)","v":41},"total number of MSC based on CL and consoles"]
["R5KDC46 - 6-Point, 4-Point Audio Domeless Controller","R5KDC46",null,null,null,null,null,"Number of MSCs Needed (95% loading)",{"$f":"IF(I43=0,0,IF(I43<=87,1,IF(I43<=174,2,IF(I43<=261,3,IF(I43<=348,4,IF(I43<=435,5,IF(I43<=522,6,IF(I43<=609,7,IF(I43<=696,8,IF(I43<=783,9,IF(I43<=870,10,IF(I43<=957,11,IF(I43<=1044,12,0)))))))))))))","v":1},{"$f":"IF(I35>=I49,I35,I49)","v":1}]
["R5KDC16D - 6-Point, 1 Point Audio Duty Domeless Controller","R5KDC16D",null,null,null,null,null,"Number of Visual and Audio CL/DC Selected",{"$f":"SUM('R5K Details'!J89:J97)","v":17}]
["CLA246 - 4Bulb/1-Point Audio R4K Corridor Light ","CLA246",null,null,null,null,null,"Number of Audio Stations",{"$f":"SUM('R5K Details'!J33:J36,'R5K Details'!J38:J39,'R5K Details'!J60:J61,'R5K Details'!J72)","v":41}]
["CLAR46 - 4 Audio Point Relay Module","CLAR46",null,null,null,null,null,"Number of Audio CL/DC Needed",{"$f":"I37","v":41}]
[null,null,null,null,null,null,null,"Number of Audio CL/DC Selected",{"$f":"SUM('R5K Details'!J90:J92,'R5K Details'!J96)","v":13}]
[null,null,null,null,null,null,null,"Number of Visual CL/DC Needed",{"$f":"I36-I37","v":-24}]
[null,null,null,null,null,null,null,"Number of Visual CL/DC Selected",{"$f":"SUM('R5K Details'!J89,'R5K Details'!J94:J95)","v":4}]
[null,null,null,null,null,null,null,"Number Duty DC Selected",{"$f":"'R5K Details'!J97","v":0}]
[null,null,null,null,null,null,null,"Total Number of CLs/DCs Selected",{"$f":"SUM(I39,I41,I44,I42)","v":17}]
[null,null,null,null,null,null,null,"Number of Marquee controllers",{"$f":"'R5K Details'!J23","v":0}]
[null,null,null,null,null,null,null,"calculations for L2 needed",{"$f":"IF(I43=0,0,IF(I43<=24,1,IF(I43<=48,2,IF(I43<=72,3,IF(I43<=96,4,IF(I43<=120,5,IF(I43<=164,6,IF(I43<=188,7,IF(I43<=212,8,IF(I43<=236,9,IF(I43<=260,10,IF(I43<=284,11,IF(I43<=308,12,IF(I43<=332,13,IF(I43<=356,14,IF(I43<=380,15,IF(I43<=404,16,IF(I43<=428,17,IF(I43<=452,18,IF(I43<=476,12,0))))))))))))))))))))","v":1}]
[null,null,null,null,null,null,null,"calculations for L2 needed",{"$f":"IF(I43<=476,0,IF(I43<=500,1,IF(I43<=524,2,IF(I43<=548,3,IF(I43<=572,4,IF(I43<=596,5,IF(I43<=620,6,IF(I43<=644,7,IF(I43<=668,8,IF(I43<=692,9,IF(I43<=716,10,IF(I43<=740,11,IF(I43<=764,12,IF(I43<=788,13,IF(I43<=812,14,IF(I43<=836,15,IF(I43<=860,16,IF(I43<=884,17,IF(I43<=908,18,IF(I43<=932,19,IF(I43<=956,20,IF(I43<=980,21,IF(I43<=1004,22,0)))))))))))))))))))))))","v":0}]
[null,null,null,null,null,null,null,"Number of L2 Needed",{"$f":"I45+I46","v":1}]
[null,null,null,null,null,null,null,"Number of Consoles",{"$f":"'R5K Details'!J26","v":1}]
[null,null,null,null,null,null,null,"Number of MSCs Needed Consoles ",{"$f":"IF(I48=0,0,IF(I48<=16,1,IF(I48<=32,2,IF(I48<=48,3,IF(I48<=64,4,IF(I48<=80,5,IF(I48<=96,6,IF(I48<=112,7,IF(I48<=128,8,IF(I48<=144,9,IF(I48<=160,10,IF(I48<=176,11,IF(I48<=192,12,0)))))))))))))","v":1}]
[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"]
["R4KCAL - Call Assurance Light","R4KCAL"]
["R4KFAM Fire/Auxiliary Module","R4KFAM"]