{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[52,0,52,12],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,7],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[40,0,40,12],[50,0,50,12],[22,0,22,1],[9,4,10,7],[11,4,11,7],[12,4,13,4],[12,7,13,7],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[15,0,15,7],[27,0,27,1],[26,0,26,1],[38,0,38,1],[37,0,37,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
[null," "]
["This tool helps designers calculate the total PoE+ draw for daisy-chained EX endpoints"]
["When the total draw, or number of endpoints is exceeded, the required quantity of power supplies is indicated for each daisy-chain"]
["1. Enter the number of EX-UH endpoints in the daisy-chain."]
["2. For each microphone type, enter the number of microphones into the column according to how many will be wired to each EX-ML. "]
["3. Push button/LED rings are calculated separately. Enter the quantity for each into each column according to how many will be wired to each EX-ML. "]
["4. The total PoE+ draw, qauntity of each EX endpoint and microphones and total number of Dante input/output channels will be calculated."]
["5. Use the clear button to reset the values."]
[]
[null,null,null,null,"EX-UH"]
[]
[]
[null,null,null,null,"EX-4ML",null,null,"EX-8ML"]
[]
["EX-4ML, EX-8ML and EX-UH wattages",4.25,"# of Mics","Device Draw",3.53,"Total 4MLs","Total Mic Power",4.5599999999999996,"Total 8MLS","Total Mic/Light Ring Power","Toatl Mics","Total EX-ML Dante Channels"]
["Microphones"]
["AudioTechnica ES94x",null,1,{"$f":"29.25*0.00538","v":0.157365},null,null,null,null,{"$f":"ROUNDUP(H17*$C17/8,0)","v":0},{"$f":"H17*D17","v":0},{"$f":"$E17+$H17","v":0},{"$f":"$K17*$C17","v":0}]
["Clockaudio CS 1S-RF",null,1,{"$f":"0.015*12+0.27","v":0.45},null,{"$f":"ROUNDUP(E18*$C18/4,0)","v":0},{"$f":"E18*D18","v":0},null,{"$f":"ROUNDUP(H18*$C18/8,0)","v":0},0,0,0]
["Clockaudio CS 2S-RF",null,2,{"$f":"0.015*12+0.27*2","v":0.72},null,0,0,null,{"$f":"ROUNDUP(H19*$C19/8,0)","v":0},0,0,0]
["Clockaudio CS 3S-RF",null,3,{"$f":"0.015*12+0.27*3","v":0.99},null,0,0,null,0,0,0,0]
["Clockaudio C011E-RF",null,1,{"$f":"0.27","v":0.27},null,0,0,null,0,0,0,0]
["Clockaudio C012E-RF",null,1,{"$f":"0.27","v":0.27},null,0,0,null,{"$f":"ROUNDUP(H22*$C22/8,0)","v":0},0,0,0]
["Earthworks IMBL30 (+LED)",null,1,1.32,null,0,0,null,{"$f":"ROUNDUP(H23*$C23/8,0)","v":0},0,0,0]
["Sennheiser ME 34",null,1,{"$f":"0.00025*48","v":1.2E-2},null,0,{"$f":"E24*D24","v":0},null,{"$f":"ROUNDUP(H24*$C24/8,0)","v":0}]
["Sennheiser ME 35",null,1,{"$f":"0.00025*48","v":1.2E-2},null,0,0,null,{"$f":"ROUNDUP(H25*$C25/8,0)","v":0}]
["Sennheiser ME 36",null,1,{"$f":"0.00025*48","v":1.2E-2},null,0,0]
["Sennheiser MEB 102-L",null,1,{"$f":"12*0.003+48*0.003","v":0.18000000000000002},null,{"$f":"ROUNDUP(E27*$C27/4,0)","v":0},{"$f":"E27*D27","v":0}]
["Sennheiser MEB 104-L",null,1,{"$f":"12*0.003+48*0.003","v":0.18000000000000002},null,0,{"$f":"E28*D28","v":0}]
["Shure MX41xD/S",null,1,{"$f":"5.14-4.99","v":0.14999999999999947},null,0,{"$f":"E29*D29","v":0},null,{"$f":"ROUNDUP(H29*$C29/8,0)","v":0},{"$f":"H29*D29","v":0},{"$f":"$E29+$H29","v":0},{"$f":"$K29*$C29","v":0}]
["Shure MX395",null,1,{"$f":"4*D29","v":0.59999999999999787},null,0,0,null,0,{"$f":"H30*D30","v":0},{"$f":"$E30+$H30","v":0},{"$f":"$K30*$C30","v":0}]
["Shure MX396-2",null,2,{"$f":"7.73-6.73","v":1},null,0,0,null,0,{"$f":"H31*D31","v":0},{"$f":"$E31+$H31","v":0},{"$f":"$K31*$C31","v":0}]
["Shure MX396-3",null,3,{"$f":"7.89 - 6.73","v":1.1599999999999993},null,0,0,null,0,{"$f":"H32*D32","v":0},{"$f":"$E32+$H32","v":0},{"$f":"$K32*$C32","v":0}]
["Push Button/LED Rings (add these with mic)"]
["AudioTechnica AT8657/LED",null,1,{"$f":"0.00544*12","v":6.5280000000000005E-2},null,null,{"$f":"E34*D34","v":0},null,null,{"$f":"H34*D34","v":0}]
["Clockaudio TS-001",null,1,0.1,null,null,{"$f":"E35*D35","v":0},null,null,{"$f":"H35*D35","v":0}]
["Clockaudio CH-32",null,1,0.1,null,null,0,null,null,{"$f":"H36*D36","v":0}]
["Harry Joseph \"Hushbutton\"",null,1,{"$f":"0.06*12","v":0.72},null,null,{"$f":"E37*D37","v":0},null,null,{"$f":"H37*D37","v":0}]
["Sennheiser MAS 1",null,1,{"$f":"0.006*12","v":7.2000000000000008E-2},null,null,{"$f":"E38*D38","v":0}]
["Sennheiser MAT 153-S",null,1,{"$f":"0.0037*12","v":4.4400000000000002E-2},null,null,{"$f":"E39*D39","v":0}]
[]
["Totals"]
[null,"EX-UH",null,null,"EX-4ML",null,null,"EX-8ML"]
["Total PoE+ wattage ",{"$f":"(E12*B15)","v":0},null,null,{"$f":"SUM(F17:F32)*E$15+SUM(G17:G37)","v":0},null,null,{"$f":"SUM(I17:I32)*H$15+SUM(J$17:J$37)","v":0},null,null,null,null,{"$f":"SUM(B43:H43)","v":0},"Should be <24 W"]
["Total # EX Endpoints",{"$f":"E12","v":0},null,null,{"$f":"SUM(F17:F32)","v":0},null,null,{"$f":"SUM(I17:I32)","v":0},null,null,null,null,{"$f":"SUM(B44:H44)","v":0},"Each daisy chain should not exceed 6 devices"]
["Total # Mics",{"$f":"SUM(K17:K32)","v":0}]
["Total # Dante Input Channels ",{"$f":"E12*4+SUM($L17:$L32)","v":0}]
["Total # of Dante Output Channels ",{"$f":"E12*3","v":0}]
[{"$f":"IF(M$43>=24,\"Total PoE+ draw is exceeded. An external power supply is required.\", \" \")","v":" "}]
[{"$f":"IF(M$44>3,\"Number of PoE+ daisy-chainable devices has been exceeded. An external power supply is required.\", \" \")","v":" "}]
[{"$f":"IF(M$44>6,  CONCATENATE(\"Separate endpoints into \", ROUNDUP(M$44/6,0), \" daisy-chains of 6 devices or less.\"),\" \")","v":" "}]
[{"$f":"IF(M43/60>1, CONCATENATE(ROUNDUP(M43/60,0),\" Power Supplies are Required\"), CONCATENATE(ROUNDUP(M43/60,0),\" Power Supply is Required\"))","v":"0 Power Supply is Required"}]
[]
[" Select Power Supply Based Upon Region"]
[null,"800446-1110",null,null,"US"]
[null,"800446-4110",null,null,"UK"]
[null,"800446-2110",null,null,"EU"]
[null,"800446-5110",null,null,"Australia"]
[null,"800446-3110",null,null,"Japan"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rev 6/27/2018"]