{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["START HERE","Input","Policies","PowerShell","More info","Formulas","DSCP","Tasks"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"START HERE","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,0,8,2],[0,0,0,2],[1,0,1,2],[3,0,3,2],[5,0,5,2],[7,0,7,2]]}
[{"$f":"\"Lync Server Quality of Service (QoS) Calculator \" & $A12","v":"Lync Server Quality of Service (QoS) Calculator v1.0"}]
["Use this calculator to define all Lync related QoS policies and settings. The output can be sent to the AD/GPO team and the Network team. You can use the info to configure Lync Server for optimal end user experience."]
[]
["By Pat Richard, Lync MVP (@PatRichard)"]
[]
["Enter/update data in the green cells on the INPUT worksheet. QoS Group Policy Objects (GPOs) results are displayed on the POLICIES worksheet and the server side configuration is available on the POWERSHELL worksheet."]
[]
["For more information, or to submit feedback, please visit"]
["http://www.ehloworld.com/2821 "]
[]
["Version","Date","Changelog"]
["v1.0","2014-11-03","Original version"]

{"sheet":"Input","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,7],[11,0,11,7],[18,0,18,7],[15,1,15,3],[16,1,16,3],[17,1,17,3],[13,0,13,7]]}
["Scenario","Starting port","Ending port","Port count","Range","DSCP Value"]
["Server Audio",40803,{"$f":"$B$2+($D$2-1)","v":49151},8349,{"$f":"Input!$B$2&\":\"&Input!$C$2","v":"40803:49151"},"46 (EF)"]
["Server Video",{"$f":"B2+D2","v":49152},{"$f":"$B$3+($D$3-1)","v":57500},8349,{"$f":"Input!$B$3&\":\"&Input!$C$3","v":"49152:57500"},"34 (AF41)"]
["Server Application Sharing",{"$f":"B3+D3","v":57501},{"$f":"B4+D4","v":65534},8033,{"$f":"B4&\":\"&C4","v":"57501:65534"},"26 (AF31)"]
[]
["Client Audio",{"$f":"B2","v":40803},{"$f":"$B$6+($D$6-1)","v":40842},40,{"$f":"Input!$B$6&\":\"&Input!$C$6","v":"40803:40842"},"46 (EF)"]
["Client Video",{"$f":"B3","v":49152},{"$f":"$B$7+($D$7-1)","v":49191},40,{"$f":"Input!$B$7&\":\"&Input!$C$7","v":"49152:49191"},"34 (AF41)"]
["Client Application Sharing",{"$f":"B4","v":57501},{"$f":"$B$8+($D$8-1)","v":57540},40,{"$f":"Input!$B$8&\":\"&Input!$C$8","v":"57501:57540"},"26 (AF31)"]
["Client File Transfer",20000,{"$f":"$B$9+($D$9-1)","v":20039},40,{"$f":"Input!$B$9&\":\"&Input!$C$9","v":"20000:20039"},"14 (AF13)"]
["Client Media (OCS clients)",{"$f":"B9+D9","v":20040},{"$f":"$B$10+($D$10-1)","v":20079},40,{"$f":"Input!$B$10&\":\"&Input!$C$10","v":"20040:20079"},"46 (EF)"]
["Client SIP",{"$f":"B10+D10","v":20080},{"$f":"$B$11+($D$11-1)","v":20119},40,{"$f":"Input!$B$11&\":\"&Input!$C$11","v":"20080:20119"},"24 (CS3)"]
[]
["Lync Phone Edition",null,null,null,null,"46 (EF)"]
[]
["Pool Info"]
["Front End Pool FQDN","frontendpool01.contoso.com"]
["Mediation Pool FQDN","mediationpool01.contoso.com"]
["Edge Pool FQDN","edgepool01.contoso.com"]
[]
["Include these policies"]
["Exchange Unified Messaging (UM)"]
["UCMA applications"]
["Lync Phone Edition (LPE)"]
["Lync 2010 Attendant Console"]
["Lync 2010 client"]
["Lync 2013 client"]
["OCS client"]
["VDI"]
["Edge servers"]
["Windows Store App"]
["Mac client"]
["Client SIP"]
[]
["Options"]
["Collocated Front End/Mediation"]

{"sheet":"Policies","index":2,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Policy Name","Component","Communication type","Executable name","DSCP value","TCP/UDP","Source IP","Destination IP","Source Ports"]
["Client polices"]
["OCS 2007 R2 Media - communicator.exe","OCS 2007 R2","Media","communicator.exe",{"$f":"Input!F10","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!E10","v":"20040:20079"}]
["Lync 2010 Audio QoS - communicator.exe","Lync 2010 client","Audio","communicator.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync 2010 Video QoS - communicator.exe","Lync 2010 client","Video","communicator.exe",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$7","v":"49152:49191"}]
["Lync 2010 Application Sharing QoS - communicator.exe","Lync 2010 client","Application Sharing","communicator.exe",{"$f":"Input!$F$8","v":"26 (AF31)"},"TCP","Any","Any",{"$f":"Input!$E$8","v":"57501:57540"}]
["Lync 2010 File Transfer QoS - communicator.exe","Lync 2010 client","File Transfer","communicator.exe",{"$f":"Input!$F$9","v":"14 (AF13)"},"TCP","Any","Any",{"$f":"Input!$E$9","v":"20000:20039"}]
["Lync 2013 Audio QoS - lync.exe","Lync 2013 client","Audio","lync.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync 2013 Video QoS - lync.exe","Lync 2013 client","Video","lync.exe",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$7","v":"49152:49191"}]
["Lync 2013 Application Sharing QoS - lync.exe","Lync 2013 client","Application Sharing","lync.exe",{"$f":"Input!$F$8","v":"26 (AF31)"},"TCP","Any","Any",{"$f":"Input!$E$8","v":"57501:57540"}]
["Lync 2013 File Transfer QoS - lync.exe","Lync 2013 client","File Transfer","lync.exe",{"$f":"Input!$F$9","v":"14 (AF13)"},"TCP","Any","Any",{"$f":"Input!$E$9","v":"20000:20039"}]
["Lync 2013 SIP - lync.exe","Signaling","Signaling","lync.exe",{"$f":"Input!$F$11","v":"24 (CS3)"},"TCP","Any","Any",{"$f":"Input!$E$11","v":"20080:20119"}]
["Lync 2010 Attendant Audio QoS - attendantconsole.exe","Lync 2010 Attendant","Audio","AttendantConsole.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync Phone Edition QoS","Lync Phone Edition","Audio","N/A",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync Windows Store App Audio QoS - lyncmx.exe","Lync Windows Store App","Audio","lyncmx.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync Windows Store App Video QoS - lyncmx.exe","Lync Windows Store App","Video","lyncmx.exe",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$7","v":"49152:49191"}]
["Mac client QoS","Mac client","Audio","GPO based QoS for the Mac client is not available."]
["Mac client QoS","Mac client","Video","GPO based QoS for the Mac client is not available."]
[]
["Front End Server policies"]
["Lync 2010/2013 Conferencing Audio QoS","A/V Conferencing service","Audio","avmcusvc.exe",{"$f":"Input!$F$2","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2010/2013 Conferencing Video QoS","A/V Conferencing service","Video","avmcusvc.exe",{"$f":"Input!$F$3","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$3","v":"49152:57500"}]
["Lync 2010/2013 Application Sharing QoS","Application Sharing","Application Sharing","asmcusvc.exe",{"$f":"Input!F4","v":"26 (AF31)"},"TCP","Any","Any",{"$f":"Input!E4","v":"57501:65534"}]
["Lync 2010/2013 Response Group QoS","Response Group application","Audio","OcsAppServerHost.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2010/2013 Conference Announcement Service QoS","Conference Announcement service","Audio","OcsAppServerHost.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2010/2013 Call Park QoS","Call Park","Audio","OcsAppServerHost.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2013 UCMA Applications Audio QoS","UCMA applications","Audio","OcsAppServerHost.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2013 UCMA Applications Video QoS","UCMA applications","Video","OcsAppServerHost.exe",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$3","v":"49152:57500"}]
[]
["Mediation Server policies"]
["Lync 2010/2013 Mediation Audio QoS","PSTN audio","Audio","MediationServerSvc.exe",{"$f":"Input!$F$2","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
[]
["Edge Server policies"]
["Lync 2010/2013 Client Audio QoS","A/V Edge service","Audio","All applications (MediaRelaySvc.exe)",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","edge server INTERNAL (ie 10.10.10.20/32)","any",{"$f":"Input!$E$6","v":"40803:40842"}]
["Lync 2010/2013 Client Video QoS","A/V Edge service","Video","All applications (MediaRelaySvc.exe)",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","edge server INTERNAL (ie 10.10.10.20/32)","any",{"$f":"Input!$E$7","v":"49152:49191"}]
["Lync 2010/2013 Conferencing Audio QoS","A/V Edge service","Audio","All applications (MediaRelaySvc.exe)",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","edge server INTERNAL (ie 10.10.10.20/32)","any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync 2010/2013 Conferencing Video QoS","A/V Edge service","Video","All applications (MediaRelaySvc.exe)",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","edge server INTERNAL (ie 10.10.10.20/32)","any",{"$f":"Input!$E$3","v":"49152:57500"}]
[]
["Exchange UM Policies"]
["Lync Edge to Exchange UM Audio QoS","Unified Messaging","Audio","All applications (MediaRelaySvc.exe)",{"$f":"Input!$F$7","v":"34 (AF41)"},"UDP","edge server INTERNAL (ie 10.10.10.20/32)","Exchange UM IP","1024:65535"]
["Exchange UM Audio to Lync Edge QoS","Unified Messaging","Audio","umservices.exe\nMicrosoft.Exchange.UM.CallRouter.exe\numworkerprocess.exe",{"$f":"Input!$F$2","v":"46 (EF)"},"UDP","Exchange UM IP","edge server INTERNAL (ie 10.10.10.20/32)"]
[]
["VDI policies"]
["Lync VDI Audio QoS","Audio","Audio","mstsc.exe",{"$f":"Input!$F$6","v":"46 (EF)"},"Both","Any","Any",{"$f":"Input!$E$2","v":"40803:49151"}]
["Lync VDI Video QoS","Video","Video","mstsc.exe",{"$f":"Input!$F$7","v":"34 (AF41)"},"Both","Any","Any",{"$f":"Input!$E$3","v":"49152:57500"}]
["Lync VDI Application Sharing QoS","Application Sharing","Application Sharing","mstsc.exe",{"$f":"Input!$F$8","v":"26 (AF31)"},"Both","Any","Any",{"$f":"Input!#REF!","v":{"$error":"#REF!"}}]

{"sheet":"PowerShell","index":3,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,0,10,1],[13,0,13,1]]}
["Application","Command"]
["Client",{"$f":"\"Set-CsConferencingConfiguration -Identity global -ClientAudioPort \"& Input!$B$6 &\" -ClientAudioPortRange \"& Input!$D$6 &\" -ClientVideoPort \"& Input!$B$7 &\" -ClientVideoPortRange \"& Input!$D$7 &\" -ClientAppSharingPort \"& Input!$B$8 & \" -ClientAppSharingPortRange \"& Input!$D$8 & \" -ClientFileTransferPort \"& Input!$B$9 & \" -ClientFileTransferPortRange \"& Input!$D$9 & Formulas!$C$21","v":"Set-CsConferencingConfiguration -Identity global -ClientAudioPort 40803 -ClientAudioPortRange 40 -ClientVideoPort 49152 -ClientVideoPortRange 40 -ClientAppSharingPort 57501 -ClientAppSharingPortRange 40 -ClientFileTransferPort 20000 -ClientFileTransferPortRange 40 -ClientMediaPortRangeEnabled $true -ClientMediaPort 20040 -ClientMediaPortRange 40"}]
["LPE",{"$f":"\"Set-CsUCPhoneConfiguration -Identity global -VoiceDiffServTag \" & LEFT(Input!$F$13, 2)","v":"Set-CsUCPhoneConfiguration -Identity global -VoiceDiffServTag 46"}]
["Conferencing server",{"$f":"\"Set-CsConferenceServer -Identity \" & Input!$B$16 & \" -AppSharingPortStart \" & Input!$B$4 & \" -AppSharingPortCount \" & Input!$D$4 & \" -AudioPortStart \" & Input!$B$2 & \" -AudioPortCount \" & Input!$D$2 & \" -VideoPortStart \" & Input!$B$3 & \" -VideoPortCount \" & Input!$D$3","v":"Set-CsConferenceServer -Identity frontendpool01.contoso.com -AppSharingPortStart 57501 -AppSharingPortCount 8033 -AudioPortStart 40803 -AudioPortCount 8349 -VideoPortStart 49152 -VideoPortCount 8349"}]
["Applications server",{"$f":"\"Set-CsApplicationServer -Identity \" & Input!$B$16 & \" -AppSharingPortStart \" & Input!$B$4 & \" -AppSharingPortCount \" & Input!$D$4 & \" -AudioPortStart \" & Input!$B$2 & \" -AudioPortCount \" & Input!$D$2 & \" -VideoPortStart \" & Input!$B$3 & \" -VideoPortCount \" & Input!$D$3","v":"Set-CsApplicationServer -Identity frontendpool01.contoso.com -AppSharingPortStart 57501 -AppSharingPortCount 8033 -AudioPortStart 40803 -AudioPortCount 8349 -VideoPortStart 49152 -VideoPortCount 8349"}]
["Mediation Server",{"$f":"\"Set-CsMediationServer -Identity \" & IF(Formulas!$B$24,Input!$B$16,Input!$B$17) & \" –AudioPortStart \" & Input!$B$2 & \" -AudioPortCount B5\" & Input!$D$2","v":"Set-CsMediationServer -Identity mediationpool01.contoso.com –AudioPortStart 40803 -AudioPortCount B58349"}]
["Mediation Server","Set-CsMediaConfiguration -Identity global -EnableQoS $true"]
["Edge Server",{"$f":"\"Set-CsEdgeServer -Identity \" & Input!B18 & \" -MediaCommunicationPortStart 50000 -MediaCommunicationPortCount 10000\"","v":"Set-CsEdgeServer -Identity edgepool01.contoso.com -MediaCommunicationPortStart 50000 -MediaCommunicationPortCount 10000"}]
["Web Server",{"$f":"\"Set-CsWebServer -Identity \" & Input!$B$16 & \" -AppSharingPortStart \"& Input!$B$4 & \" -AppSharingPortCount \"& Input!$D$4","v":"Set-CsWebServer -Identity frontendpool01.contoso.com -AppSharingPortStart 57501 -AppSharingPortCount 8033"}]
[]
["To apply these settings to additional pools, change the value of -Identity to match the target pool/configuration"]
[]
[]
["Note: PowerShell code to create and configure the Group Policy Objects is planned for a future version."]

{"sheet":"More info","index":4,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["DO NOT CHANGE ANYTHING ON THIS PAGE. IN THE PUBLIC VERSION, THIS TAB WILL BE HIDDEN"]
[]
[null,"Managing Quality of Service (QoS) in Lync Server 2013","http://technet.microsoft.com/en-us/library/gg405409.aspx "]
[null,"Enabling QoS for Lync Server 2013 and Various Clients – Part 1","http://www.shudnow.net/2013/02/16/enabling-qos-for-lync-server-2013-and-various-clients-part-1/"]
[null,"Enabling QoS for Lync Server 2013 and Various Clients – Part 2","http://www.shudnow.net/2013/03/03/enabling-qos-for-lync-server-2013-and-various-clients-part/"]
[null,"Lync 2013 – Adding QOS to Lync Servers, Lync Clients and Lync Phone Editions","http://northernlync.wordpress.com/2013/08/22/lync-2013-adding-qos-to-lync-servers-lync-clients-and-lync-phone-editions/"]
[null,"Configuring Lync 2013 VDI Plug-in support for QoS","http://blogs.technet.com/b/nexthop/archive/2013/10/24/configuring-lync-2013-vdi-plug-in-support-for-qos.aspx"]
[null,"Lync 2013 QoS Configuration Step by Step","http://www.xlync.com/home/Article/9/Lync-2013-QoS-Configuration-Step-by-Step "]
[null,"Configure Quality of Service (QoS) for Unified Messaging","http://technet.microsoft.com/en-us/library/ee633464.aspx"]
[null,"Some notes on Lync and Exchange UM QoS","http://www.confusedamused.com/notebook/some-notes-on-lync-and-exchange-um-qos/"]
[null,"Configure Quality of Service (QoS) for Unified Messaging","http://technet.microsoft.com/en-us/library/ee633464.aspx "]
[null,"Lync Quality of Service Behavior","http://blog.schertz.name/2011/08/lync-qos-behavior/ "]
[]
[null,"Enabling DSCP Marking (OCS 2007 R2)","http://technet.microsoft.com/en-us/library/dd441192(v=office.13).aspx"]
[]
[null,"Issue with Edge servers and .exe names"]
[]
[]
[null,"VBA macros and protected worksheets","http://www.ozgrid.com/VBA/excel-macro-protected-sheet.htm "]
[]
[]
[]
[null,"Lync 2013 QoS Settings Report","http://gallery.technet.microsoft.com/office/Lync-2013-QoS-Settings-03917cf5"]

{"sheet":"Formulas","index":5,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["DO NOT CHANGE ANYTHING ON THIS PAGE. IN THE PUBLIC VERSION, THIS TAB WILL BE HIDDEN"]
[]
[]
[]
[]
[]
[]
[]
[]
["Policy type","Visible",null,null,null,"DSCP Class","DSCP (dec)","DSCP & Class"]
["Exchange UM",true]
["UCMA applications",true,null,null,null,"none",0,0]
["Lync Phone Edition",true,null,null,null,"cs1",8,"8 (CS1)"]
["Lync 2010 Attendant Console",true,null,null,null,"af11",10,"10 (AF11)"]
[null,null,null,null,null,"af12",12,"12 (AF12)"]
["Lync 2010 client",true,null,null,null,"af13",14,"14 (AF13)"]
["Lync 2013 client",true,null,null,null,"cs2",16,"16 (CS2)"]
["VDI",true,null,null,null,"af21",18,"18 (AF21)"]
["Edge servers",true,null,null,null,"af22",20,"20 (AF22)"]
["Windows Store App",true,null,null,null,"af23",22,"22 (AF23)"]
[null,null,{"$f":"IF(Formulas!B25,\" -ClientMediaPortRangeEnabled $true -ClientMediaPort \" & Input!B10 & \" -ClientMediaPortRange \" & Input!D10, \"\")","v":" -ClientMediaPortRangeEnabled $true -ClientMediaPort 20040 -ClientMediaPortRange 40"},null,null,"cs3",24,"24 (CS3)"]
["Client SIP",false,{"$f":"IF(Formulas!B22,\" -ClientSipDynamicPortRange $true\", \"\")","v":""},null,null,"af31",26,"26 (AF31)"]
["Mac client",true,null,null,null,"af32",28,"28 (AF32)"]
["Colocated FE/Mediation",false,null,null,null,"af33",30,"30 (AF33)"]
["OCS client",true,null,null,null,"cs4",32,"32 (CS4)"]
[null,null,null,null,null,"af41",34,"34 (AF41)"]
[null,null,null,null,null,"af42",36,"36 (AF42)"]
[null,null,null,null,null,"af43",38,"38 (AF43)"]
[null,null,null,null,null,"cs5",40,"40 (CS5)"]
[null,null,null,null,null,"ef",46,"46 (EF)"]
[null,null,null,null,null,"cs6",48,"48 (CS6)"]
[null,null,null,null,null,"cs7",56,"56 (CS7)"]

{"sheet":"DSCP","index":6,"n_rows":60,"n_cols":20,"rows_kept":60,"cut":false,"hidden":true,"merged":[[6,6,6,10]]}
["Media Type","Classification","Queuing and Dropping","Notes"]
["Audio","EF (DSCP 46)","Priority Queue","Low loss, low latency, low jitter, assured bandwidth (BW)"]
["Video","AF41 (DSCP 34)","BW Queue + DSCP WRED","Pair with WAN Bandwidth Policies on constrained links"]
["SIP Signalling","CS3 (DSCP 24)","BW Queue","Class 4. Low drop priority"]
[]
[]
["Abbreviation","Description",null,null,null,null,"Assured Forwarding (AF) Behavior Group"]
["ABR","Available Bit Rate",null,null,null,null,"Column1","Class 1 (lowest)","Class 2","Class 3","Class 4 (highest)"]
["AF","Assured Forwarding",null,null,null,null,"Low Drop","AF11 (DSCP 10)","AF21 (DSCP 18)","AF31 (DSCP 26)","AF41 (DSCP 34)"]
["ATM","Asynchronous Transfer Mode",null,null,null,null,"Med Drop","AF12 (DSCP 12)","AF22 (DSCP 20)","AF32 (DSCP 28)","AF42 (DSCP 36)"]
["BA","Behavior Aggregate",null,null,null,null,"High Drop","AF13 (DSCP 14)","AF23 (DSCP 22)","AF33 (DSCP 30)","AF43 (DSCP 38)"]
["Bc","committed Burst"]
["Be","excess Burst"]
["BGP","Border Gateway Protocol"]
["CAC","Connection Admission Control"]
["CAR","Committed Access Rate",null,null,null,null,"DSCP Class","DSCP (bin)","DSCP (hex)","DSCP (dec)","ToS (dec)","ToS (hex)","ToS (bin)","ToS Prec. (bin)","ToS Prec. (dec)","ToS Delay Flag","ToS Throghput Flag","ToS Reliability Flag","TOS String Format","Column1"]
["CBWFQ","Class Based Weighted Fair Queuing"]
["CIR","Committed Information Rate",null,null,null,null,"none",0,"0×00",0,0,"0×00",0,0,0,0,0,0,"Routine"]
["CoPS","Common Open Policy Server",null,null,null,null,"cs1",1000,"0×08",8,32,"0×20",100000,1,1,0,0,0,"Priority"]
["CoS","Classification on Flows",null,null,null,null,"af11",1010,"0×0A",10,40,"0×28",101000,1,1,0,1,0,"Priority"]
["DiffServ","Differentiated Services",null,null,null,null,"af12",1100,"0×0C",12,48,"0×30",110000,1,1,1,0,0,"Priority"]
["DS","Differentiated Services",null,null,null,null,"af13",1110,"0×0E",14,56,"0×38",111000,1,1,1,1,0,"Priority"]
["DSCP","Differentiated Services Code Point",null,null,null,null,"cs2",10000,"0×10",16,64,"0×40",1000000,10,2,0,0,0,"Immediate"]
["DTR","Data Terminal Ready",null,null,null,null,"af21",10010,"0×12",18,72,"0×48",1001000,10,2,0,1,0,"Immediate"]
["EF","Expedited Forwarding",null,null,null,null,"af22",10100,"0×14",20,80,"0×50",1010000,10,2,1,0,0,"Immediate"]
["EGP","Exterior Gateway Protocol",null,null,null,null,"af23",10110,"0×16",22,88,"0×58",1011000,10,2,1,1,0,"Immediate"]
["EIGRP","Interior Gateway Routing Protocol",null,null,null,null,"cs3",11000,"0×18",24,96,"0×60",1100000,11,3,0,0,0,"Flash"]
["ERP","Enterprise Resource Planning",null,null,null,null,"af31",11010,"0×1A",26,104,"0×68",1101000,11,3,0,1,0,"Flash"]
["FRF","Frame-Relay Forum",null,null,null,null,"af32",11100,"0×1C",28,112,"0×70",1110000,11,3,1,0,0,"Flash"]
["FRTS","Frame Relay Traffic Shaping",null,null,null,null,"af33",11110,"0×1E",30,120,"0×78",1111000,11,3,1,1,0,"Flash"]
["FRTS","Frame-Relay Traffic Shaping",null,null,null,null,"cs4",100000,"0×20",32,128,"0×80",10000000,100,4,0,0,0,"FlashOverride"]
["FTP","File Transfer Protocol",null,null,null,null,"af41",100010,"0×22",34,136,"0×88",10001000,100,4,0,1,0,"FlashOverride"]
["GTS","Generic Traffic Shaping",null,null,null,null,"af42",100100,"0×34",36,144,"0×90",10010000,100,4,1,0,0,"FlashOverride"]
["IEFT","Internet Engineering Task Force",null,null,null,null,"af43",100110,"0×26",38,152,"0×98",10011000,100,4,1,1,0,"FlashOverride"]
["IGP","Interior Gateway Protocol",null,null,null,null,"cs5",101000,"0×28",40,160,"0xA0",10100000,101,5,0,0,0,"Critical"]
["IntServ","Integrated Services",null,null,null,null,"ef",101110,"0×2E",46,184,"0xB8",10111000,101,5,1,1,0,"Critical"]
["IP","Internet Protocol",null,null,null,null,"cs6",110000,"0×30",48,192,"0xC0",11000000,110,6,0,0,0,"Internetworkcontrol"]
["IS-IS","Intermediate System-to-Intermediate System",null,null,null,null,"cs7",111000,"0×38",56,224,"0xE0",11100000,111,7,0,0,0,"Networkcontrol"]
["ITU-T","International Union for Telecommunications, Telecommunications"]
["LAN","Local Area Network"]
["LLQ","Low Latency Queuing"]
["MCR","Minimum Cell Rate"]
["MIB","Management Information Base"]
["MPLS","Multi Protocol Label Switching"]
["MQC","Modular QoS CLI"]
["OSPF","Open Shortest Path First"]
["PCR","Peak Cell Rate"]
["PHB","Per-Hop Behavior"]
["QoS","Quality of Service"]
["RFCs","Request for Comments"]
["RMON","Remote Monitoring"]
["RSVP","Resource Reservation Protocol"]
["SLA","Service Level Agreement"]
["SVC","Switched Virtual Circuit"]
["TCP","Transfer Control Protocol"]
["ToS","Type of Service"]
["UDP","User Datagram Protocol"]
["VBR-rt","Variable Bit Rate, Real-Time"]
["VoIP","Voice over IP"]
["WRED","Weighted Randomly Early Detected"]

{"sheet":"Tasks","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Task","Priority","Status"]
["Additional information about why ALL APPLICATIONS should be specified for edge servers"]
["Remove LPE info from POLICIES"]
["Fix RESET buttons to handle resetting DSCP cells"]
["Add PowerShell for GPOs"]
["Validate ExUM executable names"]
["policy names should dynamically change PowerShell, etc."]
["Trusted app ports"]
["SDN API ports"]