{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Contents","Inputs","DL linkLevel","UL linkLevel","Sources"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":1,"defined_names":60,"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":"Contents","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,4]]}
[]
[null,null,null,null,null,{"$f":"Workbook.Title","v":"Single User Throughput in 5G NR"}]
[]
["Information"]
[]
["Title ","Single User Throughput in 5G NR"]
["Objective","To compare throughput for different spectrum options"]
["Status","Approved for release"]
[]
["Contents"]
[]
["Sheet","Description"]
["Contents","This contents sheet"]
["Inputs","Input parameters used in calculation sheets"]
["DL linkLevel","Calculation sheet for Downlink throughput calculations"]
["UL linkLevel","Calculation sheet for Uplink throughput calculations"]
["Sources","Sources of equations and parameters taken from 3gpp references"]
[]
["Terms and conditions"]
["The terms and conditions on which OFCOM is making available the model are set out below.\n\nThe SUT model provided has been developed to calculate the single user throughput for different spectrum scenarios and compare against differentservice throughput requirements.\n\nAll right, title and interest in the provided model (the ‘Model’) constructed in Excel to calculate SUT are owned by OFCOM. Such title and interest is protected by United Kingdom intellectual property laws and international treaty provisions. While you may freely use the Model for the purposes for which it is provided, as set out in the accompanying model documentation, it is not to be modified in any way or used for commercial gain or otherwise without the prior written permission of OFCOM.\n\nNo representation or warranty is given as to the accuracy, completeness or correctness of the provided Model and it is provided 'as is'. It is provided without any representation or endorsement made and without warranty of any kind, whether express or implied, including but not limited to the implied warranties of satisfactory quality, fitness for a particular purpose, non-infringement, compatibility, security and accuracy.\n\nOFCOM does not accept any responsibility for any loss, disruption or damage to your data or your computer system which may occur whilst using the Model or material derived from the Model. OFCOM does not warrant that the functions contained in the Model will be uninterrupted or error free. Also, OFCOM does not warrant that defects will be corrected, or that the Model provided is free of viruses.\n\nIn no event will OFCOM be liable for any loss or damage including, without limitation, indirect or consequential loss or damage, or any loss or damages whatsoever arising from use or loss of use of, data or profits arising out of or in connection with the use or otherwise of the provided Model. By using this Model, you agree to the above."]

{"sheet":"Inputs","index":1,"n_rows":102,"n_cols":16,"rows_kept":102,"cut":false,"hidden":false,"merged":[[26,3,31,3],[33,3,38,3],[10,12,10,14],[96,7,96,11],[84,7,84,11],[4,7,4,14],[18,6,18,7],[18,8,18,9]]}
["Input Parameters"]
[null,"All parameters are described in detail in Annex 2 of the associated consultation"]
[null,"Lookup Tables"]
[null,null,"Yes","No",null," 3GPP  TS 38.101 Maximum Tx BW configuration NRB Table 5.3.2-1 "]
[null,null,null,null,null,null,null,"BW (MHz)"]
[null,null,"table offset",null,null,"Sub carrier spacing (SCS) (kHz)","MU (numerology)",5,10,20,40,50,70,80,100]
[null,{"$f":"B44","v":"DL 0.75 New"},1,null,null,15,0,25,null,106,216,270,"N/A","NA","NA"]
[null,{"$f":"B54","v":"DL 0.75 Original"},11,null,null,30,1,11,24,51,106,133,189,217,273]
[null,{"$f":"B64","v":"UL New"},1,null,null,60,2,"NA",11,24,"NA",65,93,107,135]
[null,{"$f":"B74","v":"UL Original"},11]
[null,null,null,null,null,null,"QPSK","16QAM","64QAM","256QAM",null,null,"Base station"]
[null,null,null,null,null,"Qm options",2,4,6,8,null,null,"Macro","Micro","Small Indoor"]
[null,null,null,null,null,null,null,null,null,null,null,"BS power (dBm/20 MHz)",71,24,{"$f":"24-6","v":18}]
[null,null,null,null,null,"f options",1,0.8,0.75,0.4,null,"BS NF (dB)",5,7,9,"Equation 14.6, §14.4, “LTE for UMTS: Evolution to LTE-Advanced”, Harri Holma and Antti Toskala, Wiley, Second edition, 2011."]
[null,null,null,null,null,null,null,null,null,null,null,"BS gain (dBi)",21,3,0]
[]
[]
[]
[null,"General Parameters",null,null,null,null,"Downlink",null,"Uplink"]
[null,"Base Station","Macro","BS_type",null,"Throughput Parameters"]
[null,"Carrier aggregation loss",0.06,"CA_Loss","Table 13 of ECC Report 287","Qm",8,"DL_Qm",6,"UL_Qm","as CQI = 15"]
[null,"Number Subcarriersper Res Element",12,"Subcarriers","3gpp TR 36.942 Annex A","Rmax",{"$f":"948/1024","v":0.92578125},"DL_Rmax",{"$f":"948/1024","v":0.92578125},"UL_Rmax","as CQI = 15"]
[null,"Number Symbols per Res Element",14,"Symbols","3gpp TR 36.942 Annex A","f",1,"DL_f",1,"UL_f","From 3GPP TS 38.306 V16.0.0 (2020-03)"]
[null,"thermal noise (dBm/MHz)",{"$f":"-174+60","v":-114},"thermal_noise",null,"Overhead",0.14000000000000001,"DL_OH",0.08,"UL_OH","From 3GPP TS 38.306 V16.0.0 (2020-03)"]
[null,null,null,null,null,"Pathloss parameters"]
[null,null,null,null,null,"Normalise BW (MHz)",98.28,"DL_NormBW",98.28,"UL_NormBW"]
[null,"Downlink Service","Mbps","explanation of selection provided in Annex 2 of Consultation and summarised in Table A5",null,"Normalise layers",4,"DL_NormLayers",2,"UL_NormLayers"]
[null,"Mobile broadband live video",300,null,null,"Max Device Power dBm)",{"$f":"HLOOKUP(BS_type,M12:O15,2,FALSE)+10*LOG10(DL_NormBW/20)","v":77.914351521440622},null,26,null,"From Ofcom Licence template"]
[null,"Professional mobile video 8K 2D; Cloud VR 2K@90fps",100,null,null,"EIRP per layer (dBm)",{"$f":"G28-10*LOG10(DL_NormLayers)","v":71.893751608160997},"DL_EIRP",{"$f":"I28-10*LOG10(UL_NormLayers)","v":22.989700043360187},"UL_EIRP","From Ofcom Licence template"]
[null,"Cloud computer games for connected vehicles with 4K 3D graphics; Professional mobile video 4K 3D; Cloud VR 1018p@60fps",50,null,null,"Noise Figure (dB)",9,"DL_NF",{"$f":"HLOOKUP(BS_type,M12:O15,3,FALSE)","v":5},"UL_NF"]
[null,"Professional mobile video 4K 2D",25,null,null,"Rx Antenna Gain (dBi)",0,"DL_Rxgain",{"$f":"HLOOKUP(BS_type,$M$12:$O$15,4,FALSE)","v":21},"UL_Rxgain"]
[null,"Cloud VR 720p@30fps",20,null,null,null,{"$f":"thermal_noise+10*LOG10(G26) +DL_NF","v":-85.075348521919565},"DL_NormNoise",{"$f":"thermal_noise+10*LOG10(G26) +UL_NF","v":-89.075348521919565},"UL_NormNoise"]
[null,null,null,null,null,"Shannon parameters"]
[null,"Uplink  Service","Mbps","explanation of selection provided in Annex 2 of Consultation and summarised in Table A5",null,"Alpha",0.6,"DL_alpha",0.55000000000000004,"UL_alpha","3gpp TR 36.942 Annex A"]
[null,"Mobile broadband live video; Cloud computer games for connected vehicles with 4K 3D graphics",50]
[null,"Industrial control",25]
[null,"Connectivity for drones",20]
[]
[]
[]
[]
[null,"Spectrum Scenarios"]
[]
[null,"DL 0.75 New"]
[null,"Scenario","No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","Scenario Description"]
["Scenario 1","40 MHz TDD 4x4 SU-MIMO",4,30,40,null,"Single carrier, 4 layers, scs 30 kHz, 40 MHz"]
["Scenario 2","50 MHz TDD 4x4 SU-MIMO",4,30,50,null,"Single carrier, 4 layers, scs 30 kHz, 50 MHz "]
["Scenario 3","80 MHz TDD 4x4 SU-MIMO",4,30,80,null,"Single carrier, 4 layers, scs 30 kHz, 80 MHz"]
["Scenario 4","40 + 40 MHz 4x4 SU-MIMO ",4,30,40,40,"Dual carrier, 4 layers, scs 30 kHz, 40 + 40 MHz"]
["Scenario 5","100 MHz TDD 4x4 SU-MIMO",4,30,100,null,"Single carrier, 4 layers, scs 30 kHz, 100 MHz "]
[]
[]
[]
[null,"DL 0.75 Original"]
[null,"Scenario","No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","Scenario Description"]
["Scenario 1","40 MHz TDD 4x4 SU-MIMO",4,30,40,null,"Single carrier, 4 layers, scs 30 kHz, 40 MHz"]
["Scenario 2","100 MHz TDD 2x2 SU-MIMO",2,30,100,null,"Single carrier, 2 layers, scs 30 kHz, 100 MHz "]
["Scenario 3","20 + 70 MHz TDD 4x4 SU-MIMO ",4,30,20,70,"Dual carrier, 4 layers, scs 30 kHz, 20 + 70 MHz"]
["Scenario 4","50 + 50 MHz 4x4 SU-MIMO ",4,30,50,50,"Dual carrier, 4 layers, scs 30 kHz, 50 + 50 MHz"]
["Scenario 5","100 MHz TDD 4x4 SU-MIMO",4,30,100,null,"Single carrier, 4 layers, scs 30 kHz, 100 MHz "]
[]
[]
[]
[null,"UL New"]
[null,"Scenario","No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","Scenario Description"]
["Scenario 1","40 MHz TDD 2x2 SU-MIMO",2,30,40,null,"Single carrier, 2 layers, scs 30 kHz, 40 MHz"]
["Scenario 2","50 MHz TDD 2x2 SU-MIMO",2,30,50,null,"Single carrier, 2 layers, scs 30 kHz, 50 MHz "]
["Scenario 3","80 MHz TDD 2x2 SU-MIMO",2,30,80,null,"Single carrier, 2 layers, scs 30 kHz, 80 MHz"]
["Scenario 4","100 MHz TDD 2x2 SU-MIMO",2,30,100,null,"Single carrier, 2 layers, scs 30 kHz, 100 MHz"]
["Scenario 5",null,2,30]
[]
[]
[]
[null,"UL Original"]
[null,"Scenario","No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","Scenario Description"]
["Scenario 1","40 MHz TDD 2x2 SU-MIMO",2,30,40,null,"Single carrier, 2 layers, scs 30 kHz, 40 MHz"]
["Scenario 2","80 MHz TDD 2x2 SU-MIMO",2,30,80,null,"Single carrier, 2 layers, scs 30 kHz, 80 MHz "]
["Scenario 3","20 + 70 MHz TDD 2x2 SU-MIMO ",2,30,20,70,"Dual carrier, 2 layers, scs 30 kHz, 20 + 70 MHz"]
["Scenario 4","50 + 50 MHz 2x2 SU-MIMO ",2,30,50,50,"Dual carrier, 2 layers, scs 30 kHz, 50 + 50 MHz"]
["Scenario 5","100 MHz TDD 2x2 SU-MIMO",2,30,100,null,"Single carrier, 2 layers, scs 30 kHz, 100 MHz"]
[]
[]
[null,"Plot configurations Settings for checks"]
[]
[null,"Downlink configuration Settings",null,null,null,null,null,"Plot Lines"]
[null,"Summary","TDD Ratio","BS Type","Spectrum Scenario","Plot Type","Scale Plot?",{"$f":"B28","v":"Mobile broadband live video"},{"$f":"B29","v":"Professional mobile video 8K 2D; Cloud VR 2K@90fps"},{"$f":"B30","v":"Cloud computer games for connected vehicles with 4K 3D graphics; Professional mobile video 4K 3D; Cloud VR 1018p@60fps"},{"$f":"B31","v":"Professional mobile video 4K 2D"},{"$f":"B32","v":"Cloud VR 720p@30fps"}]
["e.g.","DL 0.75 New - SINR ",0.75,"Macro","DL 0.75 New","SINR per layer (dB)","No","Yes","Yes","Yes","Yes","Yes"]
[null,"DL 0.75 Original - SINR ",0.75,"Macro","DL 0.75 Original","SINR per layer (dB)","No","Yes","Yes","Yes","Yes","Yes"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Uplink  configuration Settings",null,null,null,null,null,"Plot Lines"]
[null,"Summary","TDD Ratio","BS Type","Spectrum Scenario","Plot Type","Scale Plot?",{"$f":"B35","v":"Mobile broadband live video; Cloud computer games for connected vehicles with 4K 3D graphics"},{"$f":"B36","v":"Industrial control"},{"$f":"B37","v":"Connectivity for drones"},{"$f":"B38","v":0},{"$f":"B39","v":0}]
["e.g","UL 0.25 New  - SINR",0.25,"Macro","UL New","SINR per layer (dB)","No","Yes","No","Yes","No","No"]
[null,"UL 0.50 New  - SINR",0.5,"Macro","UL New","SINR per layer (dB)","No","No","Yes","No","No","No"]
[null,"UL 0.25 New  - Pathloss (scales)",0.25,"Macro","UL New","Pathloss (dB)","Yes","Yes","No","Yes","No","No"]
[null,"UL 0.25 Origional  - SINR",1.25,"Macro","UL New","SINR per layer (dB)","No","Yes","Yes","Yes","No","No"]

{"sheet":"DL linkLevel","index":2,"n_rows":77,"n_cols":52,"rows_kept":77,"cut":false,"hidden":false,"merged":[[16,2,16,3],[17,2,17,3],[24,6,24,8],[24,21,24,25],[2,5,2,6],[24,9,24,11],[24,12,24,14],[24,15,24,17],[24,18,24,20]]}
["Downlink Link Level Throughput Calculations"]
[null,null,null,null,null,"Plot configurations check"]
[null,"Parameter",null,null,null,"DL 0.75 New - SINR "]
[null,"BS type",{"$f":"BS_type","v":"Macro"},"change on Inputs sheet",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,3,FALSE)","v":"Macro"},{"$f":"F4=C4","v":true}]
[null,"DL/UL ratio",0.75,"DL_ratio",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,2,FALSE)","v":0.75},{"$f":"F5=C5","v":true}]
[null,"Scale Power","No","DL_scale",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,6,FALSE)","v":"No"},{"$f":"F6=C6","v":true}]
[null,"Plot","SINR per layer (dB)","DL_Plot",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,5,FALSE)","v":"SINR per layer (dB)"},{"$f":"F7=C7","v":true}]
[null,"Plot title",{"$f":"CONCATENATE(\"Downlink SUT Distribution (Downlink \",DL_ratio*100,\"%)\")","v":"Downlink SUT Distribution (Downlink 75%)"}]
[]
[null,"Services","Mbps","Plot?"]
[null,{"$f":"Inputs!B28","v":"Mobile broadband live video"},{"$f":"Inputs!C28","v":300},"Yes",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,7,FALSE)","v":"Yes"},{"$f":"F11=D11","v":true}]
[null,{"$f":"Inputs!B29","v":"Professional mobile video 8K 2D; Cloud VR 2K@90fps"},{"$f":"Inputs!C29","v":100},"Yes",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,8,FALSE)","v":"Yes"},{"$f":"F12=D12","v":true}]
[null,{"$f":"Inputs!B30","v":"Cloud computer games for connected vehicles with 4K 3D graphics; Professional mobile video 4K 3D; Cloud VR 1018p@60fps"},{"$f":"Inputs!C30","v":50},"Yes",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,9,FALSE)","v":"Yes"},true]
[null,{"$f":"Inputs!B31","v":"Professional mobile video 4K 2D"},{"$f":"Inputs!C31","v":25},"Yes",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,10,FALSE)","v":"Yes"},true]
[null,{"$f":"Inputs!B32","v":"Cloud VR 720p@30fps"},{"$f":"Inputs!C32","v":20},"Yes",null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,11,FALSE)","v":"Yes"},true]
[]
[null,"Spectrum Scenarios","DL 0.75 New",null,null,{"$f":"VLOOKUP('DL linkLevel'!$F$3,Inputs!$B$86:$L$94,4,FALSE)","v":"DL 0.75 New"},{"$f":"F17=C17","v":true}]
[null,"lookup offset",{"$f":"VLOOKUP('DL linkLevel'!C17,Inputs!B7:C8,2,FALSE)","v":1},null,"DL_scenario_offset",null,null,null,"lookuptable offset",2,2]
[null,null,"No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","CA Scaling (reduce 6% if 2 carriers)","total carrier BW","mu (factor for the throughput calc)","NRB1 (looked up from table  based on BW1, SCS hard coded)","NRB2 (looked up from table above based on BW2, SCS hard coded)","Max_tput (Mbps) calc based on 5G NR throughput rate calc","Transmission BW (MHz)","spec Efficiency/ T-BW layer @100% (bps/Hz) ","SINR scaling for Power/carriers","Scenario description"]
[1,"Scenario 1",{"$f":"HLOOKUP(C$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A20,FALSE)","v":4},{"$f":"HLOOKUP(D$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A20,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A20,FALSE)","v":40},{"$f":"HLOOKUP(F$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A20,FALSE)","v":0},{"$f":"IF(F20=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E20:F20)","v":40},{"$f":"VLOOKUP(D20,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E20>0,HLOOKUP(E20,Inputs!$H$6:$O$9,$I20+$J$18,FALSE),)","v":106},{"$f":"IF(F20>0,HLOOKUP(F20,Inputs!$H$6:$O$9,$I20+$J$18,FALSE),)","v":0},{"$f":"C20*DL_ratio*DL_Qm*DL_f*DL_Rmax*(1-DL_OH)*Symbols*Subcarriers*(2^I20)*(J20+K20)/1000","v":680.55498},{"$f":"((D20*Subcarriers*J20)+(D20*Subcarriers*K20))/1000","v":38.159999999999997},{"$f":"L20/(M20*C20*DL_ratio)","v":5.9447500000000009},{"$f":"IF(DL_scale=\"Yes\",DL_NormBW*DL_NormLayers/(M20*C20),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$45:$G$60,DL_scenario_offset+$A20,FALSE)","v":"Single carrier, 4 layers, scs 30 kHz, 40 MHz"}]
[2,"Scenario 2",{"$f":"HLOOKUP(C$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A21,FALSE)","v":4},{"$f":"HLOOKUP(D$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A21,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A21,FALSE)","v":50},{"$f":"HLOOKUP(F$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A21,FALSE)","v":0},{"$f":"IF(F21=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E21:F21)","v":50},{"$f":"VLOOKUP(D21,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E21>0,HLOOKUP(E21,Inputs!$H$6:$O$9,$I21+$J$18,FALSE),)","v":133},{"$f":"IF(F21>0,HLOOKUP(F21,Inputs!$H$6:$O$9,$I21+$J$18,FALSE),)","v":0},{"$f":"C21*DL_ratio*DL_Qm*DL_f*DL_Rmax*(1-DL_OH)*Symbols*Subcarriers*(2^I21)*(J21+K21)/1000","v":853.90389000000005},{"$f":"((D21*Subcarriers*J21)+(D21*Subcarriers*K21))/1000","v":47.88},{"$f":"L21/(M21*C21*DL_ratio)","v":5.94475},{"$f":"IF(DL_scale=\"Yes\",DL_NormBW*DL_NormLayers/(M21*C21),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$45:$G$60,DL_scenario_offset+$A21,FALSE)","v":"Single carrier, 4 layers, scs 30 kHz, 50 MHz "}]
[3,"Scenario 3",{"$f":"HLOOKUP(C$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A22,FALSE)","v":4},{"$f":"HLOOKUP(D$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A22,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A22,FALSE)","v":80},{"$f":"HLOOKUP(F$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A22,FALSE)","v":0},{"$f":"IF(F22=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E22:F22)","v":80},{"$f":"VLOOKUP(D22,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E22>0,HLOOKUP(E22,Inputs!$H$6:$O$9,$I22+$J$18,FALSE),)","v":217},{"$f":"IF(F22>0,HLOOKUP(F22,Inputs!$H$6:$O$9,$I22+$J$18,FALSE),)","v":0},{"$f":"C22*DL_ratio*DL_Qm*DL_f*DL_Rmax*(1-DL_OH)*Symbols*Subcarriers*(2^I22)*(J22+K22)/1000","v":1393.2116099999998},{"$f":"((D22*Subcarriers*J22)+(D22*Subcarriers*K22))/1000","v":78.12},{"$f":"L22/(M22*C22*DL_ratio)","v":5.9447499999999991},{"$f":"IF(DL_scale=\"Yes\",DL_NormBW*DL_NormLayers/(M22*C22),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$45:$G$60,DL_scenario_offset+$A22,FALSE)","v":"Single carrier, 4 layers, scs 30 kHz, 80 MHz"}]
[4,"Scenario 4",{"$f":"HLOOKUP(C$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A23,FALSE)","v":4},{"$f":"HLOOKUP(D$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A23,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A23,FALSE)","v":40},{"$f":"HLOOKUP(F$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A23,FALSE)","v":40},{"$f":"IF(F23=0,1,1-CA_Loss)","v":0.94},{"$f":"SUM(E23:F23)","v":80},{"$f":"VLOOKUP(D23,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E23>0,HLOOKUP(E23,Inputs!$H$6:$O$9,$I23+$J$18,FALSE),)","v":106},{"$f":"IF(F23>0,HLOOKUP(F23,Inputs!$H$6:$O$9,$I23+$J$18,FALSE),)","v":106},{"$f":"C23*DL_ratio*DL_Qm*DL_f*DL_Rmax*(1-DL_OH)*Symbols*Subcarriers*(2^I23)*(J23+K23)/1000","v":1361.10996},{"$f":"((D23*Subcarriers*J23)+(D23*Subcarriers*K23))/1000","v":76.319999999999993},{"$f":"L23/(M23*C23*DL_ratio)","v":5.9447500000000009},{"$f":"IF(DL_scale=\"Yes\",DL_NormBW*DL_NormLayers/(M23*C23),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$45:$G$60,DL_scenario_offset+$A23,FALSE)","v":"Dual carrier, 4 layers, scs 30 kHz, 40 + 40 MHz"}]
[5,"Scenario 5",{"$f":"HLOOKUP(C$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A24,FALSE)","v":4},{"$f":"HLOOKUP(D$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A24,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A24,FALSE)","v":100},{"$f":"HLOOKUP(F$19,Inputs!$B$45:$F$60,DL_scenario_offset+$A24,FALSE)","v":0},{"$f":"IF(F24=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E24:F24)","v":100},{"$f":"VLOOKUP(D24,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E24>0,HLOOKUP(E24,Inputs!$H$6:$O$9,$I24+$J$18,FALSE),)","v":273},{"$f":"IF(F24>0,HLOOKUP(F24,Inputs!$H$6:$O$9,$I24+$J$18,FALSE),)","v":0},{"$f":"C24*DL_ratio*DL_Qm*DL_f*DL_Rmax*(1-DL_OH)*Symbols*Subcarriers*(2^I24)*(J24+K24)/1000","v":1752.75009},{"$f":"((D24*Subcarriers*J24)+(D24*Subcarriers*K24))/1000","v":98.28},{"$f":"L24/(M24*C24*DL_ratio)","v":5.9447499999999991},{"$f":"IF(DL_scale=\"Yes\",DL_NormBW*DL_NormLayers/(M24*C24),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$45:$G$60,DL_scenario_offset+$A24,FALSE)","v":"Single carrier, 4 layers, scs 30 kHz, 100 MHz "}]
[null,null,null,null,null,null,{"$f":"B20","v":"Scenario 1"},null,null,{"$f":"B21","v":"Scenario 2"},null,null,{"$f":"B22","v":"Scenario 3"},null,null,{"$f":"B23","v":"Scenario 4"},null,null,{"$f":"B24","v":"Scenario 5"},null,null,"Service Lines"]
[null,null,"SINR per layer (dB)","Pathloss (dB)","X-axis (dB)","SINR (linear)","Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$45:$G$60,DL_scenario_offset+$A20,1)","v":"40 MHz TDD 4x4 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$45:$G$60,DL_scenario_offset+$A21,1)","v":"50 MHz TDD 4x4 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$45:$G$60,DL_scenario_offset+$A22,1)","v":"80 MHz TDD 4x4 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$45:$G$60,DL_scenario_offset+$A23,1)","v":"40 + 40 MHz 4x4 SU-MIMO "},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$45:$G$60,DL_scenario_offset+$A24,1)","v":"100 MHz TDD 4x4 SU-MIMO"},{"$f":"IF($D$11=\"yes\",B11,\"service 1\")","v":"Mobile broadband live video"},{"$f":"IF($D$12=\"yes\",B12,\"service 2\")","v":"Professional mobile video 8K 2D; Cloud VR 2K@90fps"},{"$f":"IF($D$13=\"yes\",B13,\"service 3\")","v":"Cloud computer games for connected vehicles with 4K 3D graphics; Professional mobile video 4K 3D; Cloud VR 1018p@60fps"},{"$f":"IF($D$14=\"yes\",B14,\"service 4\")","v":"Professional mobile video 4K 2D"},{"$f":"IF($D$15=\"yes\",B15,\"service 5\")","v":"Cloud VR 720p@30fps"}]
[null,null,-10,{"$f":"DL_EIRP-(C27+DL_NormNoise)+DL_Rxgain","v":166.96910013008056},{"$f":"IF(DL_Plot=$C$26,C27,IF($C$7=$D$26,D27,0))","v":-10},{"$f":"10^(C27/10)","v":0.1},{"$f":"DL_alpha*LOG(1 +($F27*$O$20),2)","v":8.2502114249961012E-2},{"$f":"IF(G27<=$N$20,G27,$N$20)","v":8.2502114249961012E-2},{"$f":"$H27*$G$20*$M$20*$C$20*DL_ratio","v":9.4448420393355352},{"$f":"DL_alpha*LOG(1 +($F27*$O$21),2)","v":8.2502114249961012E-2},{"$f":"IF(J27<=$N$20,J27,$N$20)","v":8.2502114249961012E-2},{"$f":"$K27*$G$21*$M$21*$C$21*DL_ratio","v":11.8506036908644},{"$f":"DL_alpha*LOG(1 +($F27*$O$22),2)","v":8.2502114249961012E-2},{"$f":"IF(M27<=$N$20,M27,$N$20)","v":8.2502114249961012E-2},{"$f":"$N27*$G$22*$M$22*$C$22*DL_ratio","v":19.335195495620862},{"$f":"DL_alpha*LOG(1 +($F27*$O$23),2)","v":8.2502114249961012E-2},{"$f":"IF(P27<=$N$20,P27,$N$20)","v":8.2502114249961012E-2},{"$f":"$Q27*$G$23*$M$23*$C$23*DL_ratio","v":17.756303033950804},{"$f":"DL_alpha*LOG(1 +($F27*$O$24),2)","v":8.2502114249961012E-2},{"$f":"IF(S27<=$N$20,S27,$N$20)","v":8.2502114249961012E-2},{"$f":"$T27*$G$24*$M$24*$C$24*DL_ratio","v":24.324923365458506},{"$f":"IF($D$11=\"yes\",$C$11,\"\")","v":300},{"$f":"IF($D$12=\"yes\",$C$12,\"\")","v":100},{"$f":"IF($D$13=\"yes\",$C$13,\"\")","v":50},{"$f":"IF($D$14=\"yes\",$C$14,\"\")","v":25},{"$f":"IF($D$15=\"yes\",$C$15,\"\")","v":20}]
[null,null,-9,165.96910013008056,-9,0.12589254117941667,0.1026414831086387,0.1026414831086387,11.750396986276957,0.1026414831086387,0.1026414831086387,14.743422633724862,0.1026414831086387,0.1026414831086387,24.055057981340568,0.1026414831086387,0.1026414831086387,22.090746334200677,0.1026414831086387,0.1026414831086387,30.262814879751037,300,100,50,25,20]
[null,null,-8,164.96910013008056,-8,0.15848931924611132,0.12734684595623708,0.12734684595623708,14.578666925070019,0.12734684595623708,0.12734684595623708,18.292100953153895,0.12734684595623708,0.12734684595623708,29.845006818303723,0.12734684595623708,0.12734684595623708,27.407893819131633,0.12734684595623708,0.12734684595623708,37.546944061736937,300,100,50,25,20]
[null,null,-7,163.96910013008056,-7,0.19952623149688795,0.15747882428452659,0.15747882428452659,18.028175804092605,0.15747882428452659,0.15747882428452659,22.6202583202294,0.15747882428452659,0.15747882428452659,36.906737259321659,0.15747882428452659,0.15747882428452659,33.892970511694095,0.15747882428452659,0.15747882428452659,46.431056552049817,300,100,50,25,20]
[null,null,-6,162.96910013008056,-6,0.25118864315095801,0.19397959361630546,0.19397959361630546,22.206783877194646,0.19397959361630546,0.19397959361630546,27.863228827046115,0.19397959361630546,0.19397959361630546,45.46105755991735,0.19397959361630546,0.19397959361630546,41.748753689125934,0.19397959361630546,0.19397959361630546,57.192943381831498,300,100,50,25,20]
[null,null,-5,161.96910013008056,-5,0.31622776601683794,0.23784549669786828,0.23784549669786828,27.228552461971958,0.23784549669786828,0.23784549669786828,34.164127145681803,0.23784549669786828,0.23784549669786828,55.741470606112415,0.23784549669786828,0.23784549669786828,51.189678628507281,0.23784549669786828,0.23784549669786828,70.126366246399485,300,100,50,25,20]
[null,null,-4,160.96910013008056,-4,0.3981071705534972,0.29008497200740813,0.29008497200740813,33.208927595408078,0.29008497200740813,0.29008497200740813,41.667805379144106,0.29008497200740813,0.29008497200740813,67.984314039656169,0.29008497200740813,0.29008497200740813,62.432783879367186,0.29008497200740813,0.29008497200740813,85.528653146664212,300,100,50,25,20]
[null,null,-3,159.96910013008056,-3,0.50118723362727224,0.35166235586720845,0.35166235586720845,40.258306499678021,0.35166235586720845,0.35166235586720845,50.512780796765824,0.35166235586720845,0.35166235586720845,82.415589721038984,0.35166235586720845,0.35166235586720845,75.685616219394674,0.35166235586720845,0.35166235586720845,103.68412900388773,300,100,50,25,20]
[null,null,-2,158.96910013008056,-2,0.63095734448019325,0.42343143046410814,0.42343143046410814,48.474430159531096,0.42343143046410814,0.42343143046410814,60.821690671864488,0.42343143046410814,0.42343143046410814,99.235390043568387,0.42343143046410814,0.42343143046410814,91.131928699918447,0.42343143046410814,0.42343143046410814,124.84452295803763,300,100,50,25,20]
[null,null,-1,157.96910013008056,-1,0.79432823472428149,0.50606629512219148,0.50606629512219148,57.934469465588478,0.50606629512219148,0.50606629512219148,72.691362631351581,0.50606629512219148,0.50606629512219148,118.6016969248368,0.50606629512219148,0.50606629512219148,108.91680259530632,0.50606629512219148,0.50606629512219148,149.20858645382694,300,100,50,25,20]
[null,null,0,156.96910013008056,0,1,0.6,0.6,68.687999999999988,0.6,0.6,86.183999999999997,0.6,0.6,140.61599999999999,0.6,0.6,129.13343999999998,0.6,0.6,176.904,300,100,50,25,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"69*100/40","v":172.5}]
[null,null,1,155.96910013008056,1,1.2589254117941673,0.70538198081543324,0.70538198081543324,80.752129163750794,0.70538198081543324,0.70538198081543324,101.32106772432883,0.70538198081543324,0.70538198081543324,165.31332102390493,0.70538198081543324,0.70538198081543324,151.81400282785148,0.70538198081543324,0.70538198081543324,207.97482322362231,300,100,50,25,20]
[null,null,2,154.96910013008056,2,1.5848931924611136,0.82206280185059166,0.82206280185059166,94.109749555855728,0.82206280185059166,0.82206280185059166,118.081100857819,0.82206280185059166,0.82206280185059166,192.65863824170467,0.82206280185059166,0.82206280185059166,176.92632916500875,0.82206280185059166,0.82206280185059166,242.37699649762845,300,100,50,25,20]
[null,null,3,153.96910013008056,3,1.9952623149688797,0.94960941294693368,0.94960941294693368,108.71128559416496,0.94960941294693368,0.94960941294693368,136.40189607569755,0.94960941294693368,0.94960941294693368,222.55046201824342,0.94960941294693368,0.94960941294693368,204.37721691703013,0.94960941294693368,0.94960941294693368,279.98283931327393,300,100,50,25,20]
[null,null,4,152.96910013008056,4,2.5118864315095806,1.0873477147803754,1.0873477147803754,124.47956638805735,1.0873477147803754,1.0873477147803754,156.18662575105313,1.0873477147803754,1.0873477147803754,254.83081043592878,1.0873477147803754,1.0873477147803754,234.02158480954785,1.0873477147803754,1.0873477147803754,320.59360022584588,300,100,50,25,20]
[null,null,5,151.96910013008056,5,3.1622776601683795,1.234423925164077,1.234423925164077,141.31685095278351,1.234423925164077,1.234423925164077,177.31265261056802,1.234423925164077,1.234423925164077,289.29959110145307,1.234423925164077,1.234423925164077,265.67567979123299,1.234423925164077,1.234423925164077,363.95755009537646,300,100,50,25,20]
[null,null,6,150.96910013008056,6,3.9810717055349727,1.3898737077757557,1.3898737077757557,159.11274206616849,1.3898737077757557,1.3898737077757557,199.64145938490952,1.3898737077757557,1.3898737077757557,325.73080215432611,1.3898737077757557,1.3898737077757557,299.13195508439674,1.3898737077757557,1.3898737077757557,409.79036400060374,300,100,50,25,20]
[null,null,7,149.96910013008056,7,5.0118723362727229,1.5526886241372189,1.5526886241372189,177.75179369122881,1.5526886241372189,1.5526886241372189,223.02819397107015,1.5526886241372189,1.5526886241372189,363.88810595279864,1.5526886241372189,1.5526886241372189,334.17337213951009,1.5526886241372189,1.5526886241372189,457.79471394061761,300,100,50,25,20]
[null,null,8,148.96910013008056,8,6.3095734448019343,1.7218723315021713,1.7218723315021713,197.11994451036855,1.7218723315021713,1.7218723315021713,247.32974169697189,1.7218723315021713,1.7218723315021713,403.53799961084894,1.7218723315021713,1.7218723315021713,370.58549567949291,1.7218723315021713,1.7218723315021713,507.67683822010019,300,100,50,25,20]
[null,null,9,147.96910013008056,9,7.9432823472428176,1.8964826543478146,1.8964826543478146,217.10933426973781,1.8964826543478146,1.8964826543478146,272.41076847052011,1.8964826543478146,1.8964826543478146,444.45967487295383,1.8964826543478146,1.8964826543478146,408.16554842710701,1.8964826543478146,1.8964826543478146,559.15894580790973,300,100,50,25,20]
[null,null,10,146.96910013008056,10,10,2.0756589711823787,2.0756589711823787,237.62143902095869,2.0756589711823787,2.0756589711823787,298.1476546206369,2.0756589711823787,2.0756589711823787,486.45143648630233,2.0756589711823787,2.0756589711823787,446.72830535940233,2.0756589711823787,2.0756589711823787,611.98729106341261,300,100,50,25,20]
[null,null,11,145.96910013008056,11,12.58925411794168,2.2586366202257175,2.2586366202257175,258.56872028344014,2.2586366202257175,2.2586366202257175,324.43056412922209,2.2586366202257175,2.2586366202257175,529.33407831609918,2.2586366202257175,2.2586366202257175,486.1091941328674,2.2586366202257175,2.2586366202257175,665.9364211073505,300,100,50,25,20]
[null,null,12,144.96910013008056,12,15.848931924611136,2.4447511409432563,2.4447511409432563,279.87511061518398,2.4447511409432563,2.4447511409432563,351.16405388508934,2.4447511409432563,2.4447511409432563,572.95187739146161,2.4447511409432563,2.4447511409432563,526.16520795654583,2.4447511409432563,2.4447511409432563,720.81042639570978,300,100,50,25,20]
[null,null,13,143.96910013008056,13,19.952623149688804,2.6334353804178274,2.6334353804178274,301.47568235023289,2.6334353804178274,2.6334353804178274,378.26665804321675,2.6334353804178274,2.6334353804178274,617.17191575472202,2.6334353804178274,2.6334353804178274,566.77428281843765,2.6334353804178274,2.6334353804178274,776.44208756239232,300,100,50,25,20]
[null,null,14,142.96910013008056,14,25.118864315095799,2.8242121576373016,2.8242121576373016,323.31580780631828,2.8242121576373016,2.8242121576373016,405.66983432302209,2.8242121576373016,2.8242121576373016,661.88236126387801,2.8242121576373016,2.8242121576373016,607.83371867587834,2.8242121576373016,2.8242121576373016,832.69071255778204,300,100,50,25,20]
[null,null,15,141.96910013008056,15,31.622776601683803,3.0166846040103117,3.0166846040103117,345.35005346710045,3.0166846040103117,3.0166846040103117,433.31657652004117,3.0166846040103117,3.0166846040103117,706.9902037958567,3.0166846040103117,3.0166846040103117,649.25810051814881,3.0166846040103117,3.0166846040103117,889.43928864640043,300,100,50,25,20]
[null,null,16,140.96910013008056,16,39.810717055349755,3.2105256925491621,3.2105256925491621,367.54098128302803,3.2105256925491621,3.2105256925491621,461.15991047776163,3.2105256925491621,3.2105256925491621,752.41880130582172,3.2105256925491621,3.2105256925491621,690.97704481209257,3.2105256925491621,3.2105256925491621,946.59139519119492,300,100,50,25,20]
[null,null,17,139.96910013008056,17,50.118723362727238,3.4054679410829305,3.4054679410829305,389.85796989517382,3.4054679410829305,3.4054679410829305,489.16141505715211,3.4054679410829305,3.4054679410829305,798.10546667219558,3.4054679410829305,3.4054679410829305,732.93298340292677,3.4054679410829305,3.4054679410829305,1004.0681677488913,300,100,50,25,20]
[null,null,18,138.96910013008056,18,63.095734448019364,3.6012938664011891,3.6012938664011891,412.27612182560813,3.6012938664011891,3.6012938664011891,517.28985096986685,3.6012938664011891,3.6012938664011891,843.99923052978284,3.6012938664011891,3.6012938664011891,775.07910903214315,3.6012938664011891,3.6012938664011891,1061.8054835697267,300,100,50,25,20]
[null,null,19,137.96910013008056,19,79.432823472428197,3.7978274756651462,3.7978274756651462,434.77528941414596,3.7978274756651462,3.7978274756651462,545.51993860454161,3.7978274756651462,3.7978274756651462,890.05884719688368,3.7978274756651462,3.7978274756651462,817.37754409859429,3.7978274756651462,3.7978274756651462,1119.7514529251116,300,100,50,25,20]
[null,null,20,136.96910013008056,20,100,3.9949268896510772,3.9949268896510772,457.33923032725528,3.9949268896510772,3.9949268896510772,573.83129842948074,3.9949268896510772,3.9949268896510772,936.25106585862648,3.9949268896510772,3.9949268896510772,859.79775301523989,3.9949268896510772,3.9949268896510772,1177.8642441447237,300,100,50,25,20]
[null,null,21,135.96910013008056,21,125.89254117941677,4.192478075373554,4.192478075373554,479.95489006876443,4.192478075373554,4.192478075373554,602.20755074665738,4.192478075373554,4.192478075373554,982.54916174454615,4.192478075373554,4.192478075373554,902.31519332927701,4.192478075373554,4.192478075373554,1236.1102357431387,300,100,50,25,20]
[null,null,22,{"$f":"DL_EIRP-(C59+DL_NormNoise)+DL_Rxgain","v":134.96910013008056},{"$f":"IF(DL_Plot=$C$26,C59,IF($C$7=$D$26,D59,0))","v":22},{"$f":"10^(C59/10)","v":158.48931924611153},{"$f":"DL_alpha*LOG(1 +($F59*$O$20),2)","v":4.390389601161929},{"$f":"IF(G59<=$N$20,G59,$N$20)","v":4.390389601161929},{"$f":"$H59*$G$20*$M$20*$C$20*DL_ratio","v":502.6118015410176},{"$f":"DL_alpha*LOG(1 +($F59*$O$21),2)","v":4.390389601161929},{"$f":"IF(J59<=$N$20,J59,$N$20)","v":4.390389601161929},{"$f":"$K59*$G$21*$M$21*$C$21*DL_ratio","v":630.63556231089945},{"$f":"DL_alpha*LOG(1 +($F59*$O$22),2)","v":4.390389601161929},{"$f":"IF(M59<=$N$20,M59,$N$20)","v":4.390389601161929},{"$f":"$N59*$G$22*$M$22*$C$22*DL_ratio","v":1028.9317069283097},{"$f":"DL_alpha*LOG(1 +($F59*$O$23),2)","v":4.390389601161929},{"$f":"IF(P59<=$N$20,P59,$N$20)","v":4.390389601161929},{"$f":"$Q59*$G$23*$M$23*$C$23*DL_ratio","v":944.91018689711291},{"$f":"DL_alpha*LOG(1 +($F59*$O$24),2)","v":4.390389601161929},{"$f":"IF(S59<=$N$20,S59,$N$20)","v":4.390389601161929},{"$f":"$T59*$G$24*$M$24*$C$24*DL_ratio","v":1294.4624700065831},{"$f":"IF($D$11=\"yes\",$C$11,\"\")","v":300},{"$f":"IF($D$12=\"yes\",$C$12,\"\")","v":100},{"$f":"IF($D$13=\"yes\",$C$13,\"\")","v":50},{"$f":"IF($D$14=\"yes\",$C$14,\"\")","v":25},{"$f":"IF($D$15=\"yes\",$C$15,\"\")","v":20}]
[null,null,23,133.96910013008056,23,199.52623149688802,4.5885882974942449,4.5885882974942449,525.30158829714105,4.5885882974942449,4.5885882974942449,659.10482305207336,4.5885882974942449,4.5885882974942449,1075.3815534007513,4.5885882974942449,4.5885882974942449,987.56698599862511,4.5885882974942449,4.5885882974942449,1352.8993736332031,300,100,50,25,20]
[null,null,24,132.96910013008056,24,251.18864315095806,4.7870156986807482,4.7870156986807482,548.01755718497202,4.7870156986807482,4.7870156986807482,687.60693495850273,4.7870156986807482,4.7870156986807482,1121.8849991428201,4.7870156986807482,4.7870156986807482,1030.2730075077473,4.7870156986807482,4.7870156986807482,1411.4037085990317,300,100,50,25,20]
[null,null,25,131.96910013008056,25,316.22776601683825,4.9856251447276829,4.9856251447276829,570.7543665684251,4.9856251447276829,4.9856251447276829,716.13519578868443,4.9856251447276829,4.9856251447276829,1168.4311089183798,4.9856251447276829,4.9856251447276829,1073.018209148639,4.9856251447276829,4.9856251447276829,1469.9617176715101,300,100,50,25,20]
[null,null,26,130.96910013008056,26,398.10717055349761,5.1843794334104363,5.1843794334104363,593.5077575368266,5.1843794334104363,5.1843794334104363,744.68426181507505,5.1843794334104363,5.1843794334104363,1215.0111640140699,5.1843794334104363,5.1843794334104363,1115.794584169234,5.1843794334104363,5.1843794334104363,1528.562432146733,300,100,50,25,20]
[null,null,27,129.96910013008056,27,501.18723362727269,5.3832489259925742,5.3832489259925742,616.27433704762984,5.3832489259925742,5.3832489259925742,773.24987572957343,5.3832489259925742,5.3832489259925742,1261.6182182956197,5.3832489259925742,5.3832489259925742,1158.5957536495441,5.3832489259925742,5.3832489259925742,1587.1971133396505,300,100,50,25,20]
[null,null,28,128.96910013008056,28,630.95734448019323,5.5822100239217312,5.5822100239217312,639.05140353855973,5.5822100239217312,5.5822100239217312,801.8286478361174,5.5822100239217312,5.5822100239217312,1308.246741206297,5.5822100239217312,5.5822100239217312,1201.4166386524921,5.5822100239217312,5.5822100239217312,1645.8588034530831,300,100,50,25,20]
[null,null,29,127.96910013008056,29,794.32823472428208,5.7812439469929808,5.7812439469929808,661.8368070517563,5.7812439469929808,5.7812439469929808,830.41788054607173,5.7812439469929808,5.7812439469929808,1354.892331417275,5.7812439469929808,5.7812439469929808,1244.253197257302,5.7812439469929808,5.7812439469929808,1704.5419653314107,300,100,50,25,20]
[null,null,30,126.96910013008056,30,1000,5.9803357553015957,5.9447500000000009,680.55498,5.9803357553015957,5.9447500000000009,853.90389000000027,5.9803357553015957,5.9447500000000009,1393.2116100000003,5.9803357553015957,5.9447500000000009,1279.4433623999998,5.9803357553015957,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,31,125.96910013008056,31,1258.925411794168,6.1794735675943553,5.9447500000000009,680.55498,6.1794735675943553,5.9447500000000009,853.90389000000027,6.1794735675943553,5.9447500000000009,1393.2116100000003,6.1794735675943553,5.9447500000000009,1279.4433623999998,6.1794735675943553,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,32,124.96910013008056,32,1584.8931924611156,6.3786479373711442,5.9447500000000009,680.55498,6.3786479373711442,5.9447500000000009,853.90389000000027,6.3786479373711442,5.9447500000000009,1393.2116100000003,6.3786479373711442,5.9447500000000009,1279.4433623999998,6.3786479373711442,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,33,123.96910013008056,33,1995.2623149688804,6.5778513553986127,5.9447500000000009,680.55498,6.5778513553986127,5.9447500000000009,853.90389000000027,6.5778513553986127,5.9447500000000009,1393.2116100000003,6.5778513553986127,5.9447500000000009,1279.4433623999998,6.5778513553986127,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,34,122.96910013008056,34,2511.8864315095811,6.7770778533373131,5.9447500000000009,680.55498,6.7770778533373131,5.9447500000000009,853.90389000000027,6.7770778533373131,5.9447500000000009,1393.2116100000003,6.7770778533373131,5.9447500000000009,1279.4433623999998,6.7770778533373131,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,35,121.96910013008056,35,3162.2776601683804,6.9763226881296267,5.9447500000000009,680.55498,6.9763226881296267,5.9447500000000009,853.90389000000027,6.9763226881296267,5.9447500000000009,1393.2116100000003,6.9763226881296267,5.9447500000000009,1279.4433623999998,6.9763226881296267,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,36,120.96910013008056,36,3981.0717055349769,7.1755820908187857,5.9447500000000009,680.55498,7.1755820908187857,5.9447500000000009,853.90389000000027,7.1755820908187857,5.9447500000000009,1393.2116100000003,7.1755820908187857,5.9447500000000009,1279.4433623999998,7.1755820908187857,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,37,119.96910013008056,37,5011.8723362727324,7.3748530667246444,5.9447500000000009,680.55498,7.3748530667246444,5.9447500000000009,853.90389000000027,7.3748530667246444,5.9447500000000009,1393.2116100000003,7.3748530667246444,5.9447500000000009,1279.4433623999998,7.3748530667246444,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,38,118.96910013008056,38,6309.5734448019384,7.5741332365256238,5.9447500000000009,680.55498,7.5741332365256238,5.9447500000000009,853.90389000000027,7.5741332365256238,5.9447500000000009,1393.2116100000003,7.5741332365256238,5.9447500000000009,1279.4433623999998,7.5741332365256238,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,39,117.96910013008056,39,7943.2823472428154,7.7734207099043582,5.9447500000000009,680.55498,7.7734207099043582,5.9447500000000009,853.90389000000027,7.7734207099043582,5.9447500000000009,1393.2116100000003,7.7734207099043582,5.9447500000000009,1279.4433623999998,7.7734207099043582,5.9447500000000009,1752.75009,300,100,50,25,20]
[null,null,40,116.96910013008056,40,10000,7.9727139851043267,5.9447500000000009,680.55498,7.9727139851043267,5.9447500000000009,853.90389000000027,7.9727139851043267,5.9447500000000009,1393.2116100000003,7.9727139851043267,5.9447500000000009,1279.4433623999998,7.9727139851043267,5.9447500000000009,1752.75009,300,100,50,25,20]

{"sheet":"UL linkLevel","index":3,"n_rows":67,"n_cols":26,"rows_kept":67,"cut":false,"hidden":false,"merged":[[24,21,24,25],[2,5,2,6],[24,12,24,14],[24,15,24,17],[24,18,24,20],[16,2,16,3],[17,2,17,3],[24,6,24,8],[24,9,24,11]]}
["Uplink Link Level Throughput Calculations"]
[null,null,null,null,null,"Plot configurations check"]
[null,"Parameter",null,null,null,"UL 0.25 New  - SINR"]
[null,"BS type",{"$f":"BS_type","v":"Macro"},"change on Inputs sheet",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,3,FALSE)","v":"Macro"},{"$f":"F4=C4","v":true}]
[null,"DL/UL ratio",0.25,"UL_ratio",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,2,FALSE)","v":0.25},{"$f":"F5=C5","v":true}]
[null,"Scale Power","No","UL_scale",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,6,FALSE)","v":"No"},{"$f":"F6=C6","v":true}]
[null,"Plot","SINR per layer (dB)","UL_Plot",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,5,FALSE)","v":"SINR per layer (dB)"},{"$f":"F7=C7","v":true}]
[null,"Plot title",{"$f":"CONCATENATE(\"Uplink SUT Distribution (Uplink \",UL_ratio*100,\"%)\")","v":"Uplink SUT Distribution (Uplink 25%)"}]
[]
[null,"Services","Mbps","Plot?"]
[null,{"$f":"Inputs!B35","v":"Mobile broadband live video; Cloud computer games for connected vehicles with 4K 3D graphics"},{"$f":"Inputs!C35","v":50},"Yes",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,7,FALSE)","v":"Yes"},{"$f":"F11=D11","v":true}]
[null,{"$f":"Inputs!B36","v":"Industrial control"},{"$f":"Inputs!C36","v":25},"No",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,8,FALSE)","v":"No"},{"$f":"F12=D12","v":true}]
[null,{"$f":"Inputs!B37","v":"Connectivity for drones"},{"$f":"Inputs!C37","v":20},"Yes",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,9,FALSE)","v":"Yes"},true]
[null,{"$f":"Inputs!B38","v":0},{"$f":"Inputs!C38","v":0},"No",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,10,FALSE)","v":"No"},true]
[null,{"$f":"Inputs!B39","v":0},{"$f":"Inputs!C39","v":0},"No",null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,11,FALSE)","v":"No"},true]
[]
[null,"Spectrum Scenarios","UL New",null,null,{"$f":"VLOOKUP('UL linkLevel'!$F$3,Inputs!$B$98:$L$106,4,FALSE)","v":"UL New"},{"$f":"F17=C17","v":true}]
[null,"lookup offset",{"$f":"VLOOKUP('UL linkLevel'!C17,Inputs!B9:'Inputs'!C10,2,FALSE)","v":1},null,"UL_scenario_offset",null,null,null,null,"lookuptable offset",2,2]
[null,null,"No. Layers","SCS (kHz)","BW1 (MHz)","BW2 (MHz)","CA Scaling (reduce 6% if 2 carriers)","total carrier BW","mu (factor for the throughput calc)","NRB1 (looked up from table above based on BW1, SCS hard coded)","NRB2 (looked up from table above based on BW2, SCS hard coded)","Max_tput (Mbps) calc based on 5G NR throughput rate calc","Transmission BW (MHz)","spec Efficiency/ T-BW layer @100% (bps/Hz) ","SINR scaling for Power/carriers","Scenario description"]
[1,"Scenario 1",{"$f":"HLOOKUP(C$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A20,FALSE)","v":2},{"$f":"HLOOKUP(D$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A20,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A20,FALSE)","v":40},{"$f":"HLOOKUP(F$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A20,FALSE)","v":0},{"$f":"IF(F20=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E20:F20)","v":40},{"$f":"VLOOKUP(D20,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E20>0,HLOOKUP(E20,Inputs!$H$6:$O$9,$I20+$K$18,FALSE),)","v":106},{"$f":"IF(F20>0,HLOOKUP(F20,Inputs!$H$6:$O$9,$I20+$K$18,FALSE),)","v":0},{"$f":"C20*UL_ratio*UL_Qm*UL_f*UL_Rmax*(1-UL_OH)*Subcarriers*Symbols*(2^I20)*(J20+K20)/1000","v":91.004445000000004},{"$f":"((D20*12*J20)+(D20*12*K20))/1000","v":38.159999999999997},{"$f":"IF(L20>0,L20/(M20*C20*UL_ratio),\"\")","v":4.7696250000000004},{"$f":"IF(UL_scale=\"Yes\",UL_NormBW*UL_NormLayers/(M20*C20),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A20,FALSE)","v":"Single carrier, 2 layers, scs 30 kHz, 40 MHz"}]
[2,"Scenario 2",{"$f":"HLOOKUP(C$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A21,FALSE)","v":2},{"$f":"HLOOKUP(D$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A21,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A21,FALSE)","v":50},{"$f":"HLOOKUP(F$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A21,FALSE)","v":0},{"$f":"IF(F21=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E21:F21)","v":50},{"$f":"VLOOKUP(D21,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E21>0,HLOOKUP(E21,Inputs!$H$6:$O$9,$I21+$K$18,FALSE),)","v":133},{"$f":"IF(F21>0,HLOOKUP(F21,Inputs!$H$6:$O$9,$I21+$K$18,FALSE),)","v":0},{"$f":"C21*UL_ratio*UL_Qm*UL_f*UL_Rmax*(1-UL_OH)*Subcarriers*Symbols*(2^I21)*(J21+K21)/1000","v":114.18482250000001},{"$f":"((D21*12*J21)+(D21*12*K21))/1000","v":47.88},{"$f":"IF(L21>0,L21/(M21*C21*UL_ratio),\"\")","v":4.7696250000000004},{"$f":"IF(UL_scale=\"Yes\",UL_NormBW*UL_NormLayers/(M21*C21),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A21,FALSE)","v":"Single carrier, 2 layers, scs 30 kHz, 50 MHz "}]
[3,"Scenario 3",{"$f":"HLOOKUP(C$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A22,FALSE)","v":2},{"$f":"HLOOKUP(D$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A22,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A22,FALSE)","v":80},{"$f":"HLOOKUP(F$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A22,FALSE)","v":0},{"$f":"IF(F22=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E22:F22)","v":80},{"$f":"VLOOKUP(D22,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E22>0,HLOOKUP(E22,Inputs!$H$6:$O$9,$I22+$K$18,FALSE),)","v":217},{"$f":"IF(F22>0,HLOOKUP(F22,Inputs!$H$6:$O$9,$I22+$K$18,FALSE),)","v":0},{"$f":"C22*UL_ratio*UL_Qm*UL_f*UL_Rmax*(1-UL_OH)*Subcarriers*Symbols*(2^I22)*(J22+K22)/1000","v":186.30155250000001},{"$f":"((D22*12*J22)+(D22*12*K22))/1000","v":78.12},{"$f":"IF(L22>0,L22/(M22*C22*UL_ratio),\"\")","v":4.7696250000000004},{"$f":"IF(UL_scale=\"Yes\",UL_NormBW*UL_NormLayers/(M22*C22),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A22,FALSE)","v":"Single carrier, 2 layers, scs 30 kHz, 80 MHz"}]
[4,"Scenario 4",{"$f":"HLOOKUP(C$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A23,FALSE)","v":2},{"$f":"HLOOKUP(D$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A23,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A23,FALSE)","v":100},{"$f":"HLOOKUP(F$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A23,FALSE)","v":0},{"$f":"IF(F23=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E23:F23)","v":100},{"$f":"VLOOKUP(D23,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E23>0,HLOOKUP(E23,Inputs!$H$6:$O$9,$I23+$K$18,FALSE),)","v":273},{"$f":"IF(F23>0,HLOOKUP(F23,Inputs!$H$6:$O$9,$I23+$K$18,FALSE),)","v":0},{"$f":"C23*UL_ratio*UL_Qm*UL_f*UL_Rmax*(1-UL_OH)*Subcarriers*Symbols*(2^I23)*(J23+K23)/1000","v":234.37937249999999},{"$f":"((D23*12*J23)+(D23*12*K23))/1000","v":98.28},{"$f":"IF(L23>0,L23/(M23*C23*UL_ratio),\"\")","v":4.7696249999999996},{"$f":"IF(UL_scale=\"Yes\",UL_NormBW*UL_NormLayers/(M23*C23),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A23,FALSE)","v":"Single carrier, 2 layers, scs 30 kHz, 100 MHz"}]
[5,"Scenario 5",{"$f":"HLOOKUP(C$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A24,FALSE)","v":2},{"$f":"HLOOKUP(D$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A24,FALSE)","v":30},{"$f":"HLOOKUP(E$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A24,FALSE)","v":0},{"$f":"HLOOKUP(F$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A24,FALSE)","v":0},{"$f":"IF(F24=0,1,1-CA_Loss)","v":1},{"$f":"SUM(E24:F24)","v":0},{"$f":"VLOOKUP(D24,Inputs!$F$7:$G$9,2,FALSE)","v":1},{"$f":"IF(E24>0,HLOOKUP(E24,Inputs!$H$6:$O$9,$I24+$K$18,FALSE),)","v":0},{"$f":"IF(F24>0,HLOOKUP(F24,Inputs!$H$6:$O$9,$I24+$K$18,FALSE),)","v":0},{"$f":"C24*UL_ratio*UL_Qm*UL_f*UL_Rmax*(1-UL_OH)*Subcarriers*Symbols*(2^I24)*(J24+K24)/1000","v":0},{"$f":"((D24*12*J24)+(D24*12*K24))/1000","v":0},{"$f":"IF(L24>0,L24/(M24*C24*UL_ratio),\"\")","v":""},{"$f":"IF(UL_scale=\"Yes\",UL_NormBW*UL_NormLayers/(M24*C24),1)","v":1},{"$f":"HLOOKUP(P$19,Inputs!$B$65:$G$80,UL_scenario_offset+$A24,FALSE)","v":0}]
[null,null,null,null,null,null,{"$f":"B20","v":"Scenario 1"},null,null,{"$f":"B21","v":"Scenario 2"},null,null,{"$f":"B22","v":"Scenario 3"},null,null,{"$f":"B23","v":"Scenario 4"},null,null,{"$f":"B24","v":"Scenario 5"},null,null,"Service Lines"]
[null,null,"SINR per layer (dB)","Pathloss (dB)","x-axis (dB)","SNR (linear)","Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$65:$G$80,UL_scenario_offset+$A20,1)","v":"40 MHz TDD 2x2 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$65:$G$80,UL_scenario_offset+$A21,1)","v":"50 MHz TDD 2x2 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$65:$G$80,UL_scenario_offset+$A22,1)","v":"80 MHz TDD 2x2 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$65:$G$80,UL_scenario_offset+$A23,1)","v":"100 MHz TDD 2x2 SU-MIMO"},"Spec Efficiency per layer","Spec Eff truncated (bit/Hz)",{"$f":"INDEX(Inputs!$B$65:$G$80,UL_scenario_offset+$A24,1)","v":0},{"$f":"IF($D$11=\"yes\",B11,\"service 1\")","v":"Mobile broadband live video; Cloud computer games for connected vehicles with 4K 3D graphics"},{"$f":"IF($D$12=\"yes\",B12,\"service 2\")","v":"service 2"},{"$f":"IF($D$13=\"yes\",B13,\"service 3\")","v":"Connectivity for drones"},{"$f":"IF($D$14=\"yes\",B14,\"service 4\")","v":"service 4"},{"$f":"IF($D$15=\"yes\",B15,\"service 5\")","v":"service 5"}]
[null,null,-10,{"$f":"UL_EIRP-(C27+UL_NormNoise)+UL_Rxgain","v":143.06504856527977},{"$f":"IF(UL_Plot=$C$26,C27,IF($C$7=$D$26,D27,0))","v":-10},{"$f":"10^(C27/10)","v":0.1},{"$f":"UL_alpha*LOG(1 +(F27*$O$20),2)","v":7.5626938062464261E-2},{"$f":"IF(G27<=$N$20,G27,$N$20)","v":7.5626938062464261E-2},{"$f":"$H27*$G$20*$M$20*$C$20*UL_ratio","v":1.4429619782318179},{"$f":"UL_alpha*LOG(1 +(F27*$O$21),2)","v":7.5626938062464261E-2},{"$f":"IF(J27<=$N$21,J27,$N$20)","v":7.5626938062464261E-2},{"$f":"$K27*$G$21*$M$21*$C$21*UL_ratio","v":1.8105088972153944},{"$f":"UL_alpha*LOG(1 +(F27*$O$22),2)","v":7.5626938062464261E-2},{"$f":"IF(M27<=$N$20,M27,$N$20)","v":7.5626938062464261E-2},{"$f":"$N27*$G$22*$M$22*$C$22*UL_ratio","v":2.9539882007198544},{"$f":"UL_alpha*LOG(1 +(F27*$O$23),2)","v":7.5626938062464261E-2},{"$f":"IF(P27<=$N$20,P27,$N$20)","v":7.5626938062464261E-2},{"$f":"$Q27*$G$23*$M$23*$C$23*UL_ratio","v":3.7163077363894939},{"$f":"UL_alpha*LOG(1 +(F27*$O$24),2)","v":7.5626938062464261E-2},{"$f":"IF(S27<=$N$20,S27,$N$20)","v":7.5626938062464261E-2},{"$f":"$T27*$G$24*$M$24*$C$24*UL_ratio","v":0},{"$f":"IF($D$11=\"yes\",$C$11,\"\")","v":50},{"$f":"IF($D$12=\"yes\",$C$12,\"\")","v":""},{"$f":"IF($D$13=\"yes\",$C$13,\"\")","v":20},{"$f":"IF($D$14=\"yes\",$C$14,\"\")","v":""},{"$f":"IF($D$15=\"yes\",$C$15,\"\")","v":""}]
[null,null,-9,142.06504856527977,-9,0.12589254117941667,9.4088026182918824E-2,9.4088026182918824E-2,1.795199539570091,9.4088026182918824E-2,9.4088026182918824E-2,2.2524673468190768,9.4088026182918824E-2,9.4088026182918824E-2,3.6750783027048093,9.4088026182918824E-2,9.4088026182918824E-2,4.6234856066286314,9.4088026182918824E-2,9.4088026182918824E-2,0,50,"",20,"",""]
[null,null,-8,141.06504856527977,-8,0.15848931924611132,0.11673460879321733,0.11673460879321733,2.2272963357745863,0.11673460879321733,0.11673460879321733,2.7946265345096228,0.11673460879321733,0.11673460879321733,4.5596538194630689,0.11673460879321733,0.11673460879321733,5.7363386760986996,0.11673460879321733,0.11673460879321733,0,50,"",20,"",""]
[null,null,-7,140.06504856527977,-7,0.19952623149688795,0.14435558892748274,0.14435558892748274,2.7543046367363702,0.14435558892748274,0.14435558892748274,3.4558727989239371,0.14435558892748274,0.14435558892748274,5.6385293035074762,0.14435558892748274,0.14435558892748274,7.0936336398965016,0.14435558892748274,0.14435558892748274,0,50,"",20,"",""]
[null,null,-6,139.06504856527977,-6,0.25118864315095801,0.17781462748161336,0.17781462748161336,3.3927030923491825,0.17781462748161336,0.17781462748161336,4.2568821819098241,0.17781462748161336,0.17781462748161336,6.9454393494318181,0.17781462748161336,0.17781462748161336,8.7378107944464816,0.17781462748161336,0.17781462748161336,0,50,"",20,"",""]
[null,null,-5,138.06504856527977,-5,0.31622776601683794,0.21802503863971262,0.21802503863971262,4.1599177372457161,0.21802503863971262,0.21802503863971262,5.2195194250347203,0.21802503863971262,0.21802503863971262,8.5160580092671747,0.21802503863971262,0.21802503863971262,10.713750398755478,0.21802503863971262,0.21802503863971262,0,50,"",20,"",""]
[null,null,-4,137.06504856527977,-4,0.3981071705534972,0.26591122434012415,0.26591122434012415,5.073586160409568,0.26591122434012415,0.26591122434012415,6.3659147107025724,0.26591122434012415,0.26591122434012415,10.386492422725251,0.26591122434012415,0.26591122434012415,13.066877564073701,0.26591122434012415,0.26591122434012415,0,50,"",20,"",""]
[null,null,-3,136.06504856527977,-3,0.50118723362727224,0.32235715954494115,0.32235715954494115,6.1505746041174767,0.32235715954494115,0.32235715954494115,7.7172303995058913,0.32235715954494115,0.32235715954494115,12.591270651825402,0.32235715954494115,0.32235715954494115,15.840630820038408,0.32235715954494115,0.32235715954494115,0,50,"",20,"",""]
[null,null,-2,135.06504856527977,-2,0.63095734448019325,0.38814547792543252,0.38814547792543252,7.4058157188172515,0.38814547792543252,0.38814547792543252,9.2922027415348545,0.38814547792543252,0.38814547792543252,15.160962367767395,0.38814547792543252,0.38814547792543252,19.073468785255756,0.38814547792543252,0.38814547792543252,0,50,"",20,"",""]
[null,null,-1,134.06504856527977,-1,0.79432823472428149,0.46389410386200891,0.46389410386200891,8.8510995016871288,0.46389410386200891,0.46389410386200891,11.105624846456493,0.46389410386200891,0.46389410386200891,18.11970369685007,0.46389410386200891,0.46389410386200891,22.795756263779118,0.46389410386200891,0.46389410386200891,0,50,"",20,"",""]
[null,null,0,133.06504856527977,0,1,0.55000000000000004,0.55000000000000004,10.494,0.55000000000000004,0.55000000000000004,13.167000000000002,0.55000000000000004,0.55000000000000004,21.483000000000004,0.55000000000000004,0.55000000000000004,27.027000000000001,0.55000000000000004,0.55000000000000004,0,50,"",20,"",""]
[null,null,1,132.06504856527977,1,1.2589254117941673,0.64660014908081387,0.64660014908081387,12.337130844461928,0.64660014908081387,0.64660014908081387,15.479607568994686,0.64660014908081387,0.64660014908081387,25.256201823096593,0.64660014908081387,0.64660014908081387,31.773931325831192,0.64660014908081387,0.64660014908081387,0,50,"",20,"",""]
[null,null,2,131.06504856527977,2,1.5848931924611136,0.75355756836304244,0.75355756836304244,14.377878404366848,0.75355756836304244,0.75355756836304244,18.040168186611236,0.75355756836304244,0.75355756836304244,29.433958620260441,0.75355756836304244,0.75355756836304244,37.029818909359904,0.75355756836304244,0.75355756836304244,0,50,"",20,"",""]
[null,null,3,130.06504856527977,3,1.9952623149688797,0.87047529520135603,0.87047529520135603,16.608668632441873,0.87047529520135603,0.87047529520135603,20.839178567120463,0.87047529520135603,0.87047529520135603,34.00076503056497,0.87047529520135603,0.87047529520135603,42.775156006194635,0.87047529520135603,0.87047529520135603,0,50,"",20,"",""]
[null,null,4,129.06504856527977,4,2.5118864315095806,0.99673540521534421,0.99673540521534421,19.017711531508766,0.99673540521534421,0.99673540521534421,23.861845600855343,0.99673540521534421,0.99673540521534421,38.93248492771135,0.99673540521534421,0.99673540521534421,48.979577812282017,0.99673540521534421,0.99673540521534421,0,50,"",20,"",""]
[null,null,5,128.06504856527977,5,3.1622776601683795,1.1315552647337375,1.1315552647337375,21.590074451119708,1.1315552647337375,1.1315552647337375,27.089433037725676,1.1315552647337375,1.1315552647337375,44.198548640499787,1.1315552647337375,1.1315552647337375,55.604625709015856,1.1315552647337375,1.1315552647337375,0,50,"",20,"",""]
[null,null,6,127.06504856527975,6,3.9810717055349727,1.274050898794443,1.274050898794443,24.308891148997969,1.274050898794443,1.274050898794443,30.500778517138968,1.274050898794443,1.274050898794443,49.764428106910948,1.274050898794443,1.274050898794443,62.606861166758932,1.274050898794443,1.274050898794443,0,50,"",20,"",""]
[null,null,7,126.06504856527975,7,5.0118723362727229,1.4232979054591173,1.4232979054591173,27.156524036159954,1.4232979054591173,1.4232979054591173,34.073751856691267,1.4232979054591173,1.4232979054591173,55.594016187233123,1.4232979054591173,1.4232979054591173,69.940859074261027,1.4232979054591173,1.4232979054591173,0,50,"",20,"",""]
[null,null,8,125.06504856527975,8,6.3095734448019343,1.5783829705436572,1.5783829705436572,30.115547077972977,1.5783829705436572,1.5783829705436572,37.786488314815152,1.5783829705436572,1.5783829705436572,61.65163882943525,1.5783829705436572,1.5783829705436572,77.561739172515317,1.5783829705436572,1.5783829705436572,0,50,"",20,"",""]
[null,null,9,124.06504856527975,9,7.9432823472428176,1.7384424331521635,1.7384424331521635,33.16948162454328,1.7384424331521635,1.7384424331521635,41.618311849662796,1.7384424331521635,1.7384424331521635,67.903561438923518,1.7384424331521635,1.7384424331521635,85.427061165097314,1.7384424331521635,1.7384424331521635,0,50,"",20,"",""]
[null,null,10,123.06504856527975,10,10,1.9026873902505139,1.9026873902505139,36.303275405979804,1.9026873902505139,1.9026873902505139,45.550336122597308,1.9026873902505139,1.9026873902505139,74.318969463185084,1.9026873902505139,1.9026873902505139,93.498058356910249,1.9026873902505139,1.9026873902505139,0,50,"",20,"",""]
[null,null,11,122.06504856527975,11,12.58925411794168,2.0704169018735747,2.0704169018735747,39.503554487747806,2.0704169018735747,2.0704169018735747,49.565780630853382,2.0704169018735747,2.0704169018735747,80.87048418718183,2.0704169018735747,2.0704169018735747,101.74028655806747,2.0704169018735747,2.0704169018735747,0,50,"",20,"",""]
[null,null,12,121.06504856527975,12,15.848931924611136,2.2410218791979855,2.2410218791979855,42.758697455097561,2.2410218791979855,2.2410218791979855,53.650063787999777,2.2410218791979855,2.2410218791979855,87.534314601473312,2.2410218791979855,2.2410218791979855,110.123815143789,2.2410218791979855,2.2410218791979855,0,50,"",20,"",""]
[null,null,13,120.06504856527975,13,19.952623149688804,2.4139824320496754,2.4139824320496754,46.058784803507805,2.4139824320496754,2.4139824320496754,57.79073942326923,2.4139824320496754,2.4139824320496754,94.290153795860334,2.4139824320496754,2.4139824320496754,118.62309671092105,2.4139824320496754,2.4139824320496754,0,50,"",20,"",""]
[null,null,14,119.06504856527975,14,25.118864315095799,2.5888611445008598,2.5888611445008598,49.3954706370764,2.5888611445008598,2.5888611445008598,61.977335799350584,2.5888611445008598,2.5888611445008598,101.12091630420359,2.5888611445008598,2.5888611445008598,127.21663664077225,2.5888611445008598,2.5888611445008598,0,50,"",20,"",""]
[null,null,15,118.06504856527975,15,31.622776601683803,2.7652942203427862,2.7652942203427862,52.761813724140353,2.7652942203427862,2.7652942203427862,66.201143635006304,2.7652942203427862,2.7652942203427862,108.01239224658923,2.7652942203427862,2.7652942203427862,135.88655798764452,2.7652942203427862,2.7652942203427862,0,50,"",20,"",""]
[null,null,16,117.06504856527975,16,39.810717055349755,2.9429818848367324,2.9429818848367324,56.152094362684849,2.9429818848367324,2.9429818848367324,70.454986322991374,2.9429818848367324,2.9429818848367324,114.95287242172277,2.9429818848367324,2.9429818848367324,144.61812982087704,2.9429818848367324,2.9429818848367324,0,50,"",20,"",""]
[null,null,17,116.06504856527975,17,50.118723362727238,3.1216789459926866,3.1216789459926866,59.561634289540457,3.1216789459926866,3.1216789459926866,74.732993967064914,3.1216789459926866,3.1216789459926866,121.93277963047434,3.1216789459926866,3.1216789459926866,153.39930340608063,3.1216789459926866,3.1216789459926866,0,50,"",20,"",""]
[null,null,18,115.06504856527975,18,63.095734448019364,3.3011860442010903,3.3011860442010903,62.986629723356799,3.3011860442010903,3.3011860442010903,79.030393898174111,3.3011860442010903,3.3011860442010903,128.94432688649459,3.3011860442010903,3.3011860442010903,162.22028221204158,3.3011860442010903,3.3011860442010903,0,50,"",20,"",""]
[null,null,19,114.06504856527975,19,79.432823472428197,3.4813418526930513,3.4813418526930513,66.424002549383417,3.4813418526930513,3.4813418526930513,83.343323953471653,3.4813418526930513,3.4813418526930513,135.98121276619059,3.4813418526930513,3.4813418526930513,171.07313864133656,3.4813418526930513,3.4813418526930513,0,50,"",20,"",""]
[null,null,20,113.06504856527975,20,100,3.6620163155134877,3.6620163155134877,69.871271299997346,3.6620163155134877,3.6620163155134877,87.668670593392903,3.6620163155134877,3.6620163155134877,143.03835728395683,3.6620163155134877,3.6620163155134877,179.9514817443328,3.6620163155134877,3.6620163155134877,0,50,"",20,"",""]
[null,null,21,112.06504856527975,21,125.89254117941677,3.8431049024257584,3.8431049024257584,73.326441538283461,3.8431049024257584,3.8431049024257584,92.003931364072656,3.8431049024257584,3.8431049024257584,150.11167748875013,3.8431049024257584,3.8431049024257584,188.85017490520178,3.8431049024257584,3.8431049024257584,0,50,"",20,"",""]
[null,null,22,111.06504856527975,22,158.48931924611153,4.0245238010651017,4.0245238010651017,76.787914124322128,4.0245238010651017,4.0245238010651017,96.347099797498544,4.0245238010651017,4.0245238010651017,157.19789966960289,4.0245238010651017,4.0245238010651017,197.76509958433911,4.0245238010651017,4.0245238010651017,0,50,"",20,"",""]
[null,null,23,110.06504856527975,23,199.52623149688802,4.2062059393697249,4.2062059393697249,80.254409323174343,4.2062059393697249,4.2062059393697249,100.69657018851122,4.2062059393697249,4.2062059393697249,164.29440399178145,4.2062059393697249,4.2062059393697249,206.69295986062829,4.2062059393697249,4.2062059393697249,0,50,"",20,"",""]
[null,null,24,109.06504856527975,24,251.18864315095806,4.3880977237906862,4.3880977237906862,83.724904569926281,4.3880977237906862,4.3880977237906862,105.05105950754903,4.3880977237906862,4.3880977237906862,171.39909709126422,4.3880977237906862,4.3880977237906862,215.63112214707431,4.3880977237906862,4.3880977237906862,0,50,"",20,"",""]
[null,null,25,108.06504856527975,25,316.22776601683825,4.5701563826670437,4.5701563826670437,87.198583781287184,4.5701563826670437,4.5701563826670437,109.40954380104903,4.5701563826670437,4.5701563826670437,178.51030830697474,4.5701563826670437,4.5701563826670437,224.57748464425853,4.5701563826670437,4.5701563826670437,0,50,"",20,"",""]
[null,null,26,107.06504856527975,26,398.10717055349761,4.7523478139595676,4.7523478139595676,90.674796290348539,4.7523478139595676,4.7523478139595676,113.77120666619206,4.7523478139595676,4.7523478139595676,185.62670561326073,4.7523478139595676,4.7523478139595676,233.53037157797314,4.7523478139595676,4.7523478139595676,0,50,"",20,"",""]
[null,null,27,106.06504856527975,27,501.18723362727269,4.9346448488265269,4.7696250000000004,91.004445000000004,4.9346448488265269,4.7696250000000004,114.18482250000001,4.9346448488265269,4.7696250000000004,186.30155250000004,4.9346448488265269,4.7696250000000004,234.37937250000002,4.9346448488265269,4.7696250000000004,0,50,"",20,"",""]
[null,null,28,105.06504856527975,28,630.95734448019323,5.1170258552615868,4.7696250000000004,91.004445000000004,5.1170258552615868,4.7696250000000004,114.18482250000001,5.1170258552615868,4.7696250000000004,186.30155250000004,5.1170258552615868,4.7696250000000004,234.37937250000002,5.1170258552615868,4.7696250000000004,0,50,"",20,"",""]
[null,null,29,104.06504856527975,29,794.32823472428208,5.2994736180768998,4.7696250000000004,91.004445000000004,5.2994736180768998,4.7696250000000004,114.18482250000001,5.2994736180768998,4.7696250000000004,186.30155250000004,5.2994736180768998,4.7696250000000004,234.37937250000002,5.2994736180768998,4.7696250000000004,0,50,"",20,"",""]
[null,null,30,103.06504856527975,30,1000,5.481974442359796,4.7696250000000004,91.004445000000004,5.481974442359796,4.7696250000000004,114.18482250000001,5.481974442359796,4.7696250000000004,186.30155250000004,5.481974442359796,4.7696250000000004,234.37937250000002,5.481974442359796,4.7696250000000004,0,50,"",20,"",""]

{"sheet":"Sources","index":4,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,21,6,23],[24,21,24,23]]}
["Sources"]
[null,"Link level performance Model (Truncated Shannon capacity)",null,null,null,null,null,null,null,null,"5g NR Max Throughput calculations"]
[null,"Taken from Annex A to 3gpp TR 36.942 ",null,null,null,null,null,null,null,null,"Taken from  §4.1.2 in 3GPP TS 38.306"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 5.2.2.1-3: 4-bit CQI Table 2 (downlink"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CQI index","modulation","code rate x 1024","efficiency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"out of range"]
["Where:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"QPSK",78,0.15229999999999999]
["S(SINR) is the Shannon bound: S(SINR) = log2(1+SINR) (bps/Hz) and:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"QPSK",193,0.377]
["a","is the attenuation factor, representing implementation losses,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"QPSK",449,0.877]
["SINRmin  is the minimum SINR of the codeset (dB),",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"16QAM",378,1.4765999999999999]
["Thrmax  is the maximum throughput of the codeset (bps/Hz) and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"16QAM",490,1.9140999999999999]
["SINRmax SINR at which max throughput is reached S-1 (Thrmax) (dB)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"16QAM",616,2.4062999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"64QAM",466,2.7305000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"64QAM",567,3.3222999999999998]
[null,"Alpha set based on:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"64QAM",666,3.9022999999999999]
[null,"- 1:2 antenna configurations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"64QAM",772,4.5233999999999996]
[null,"- Typical Urban fast fading channel model (10kmph DL, 3kmph UL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"64QAM",873,5.1151999999999997]
[null,"- Link Adaptation (see table 1 for details of highest and lowest rate codes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"256QAM",711,5.5547000000000004]
[null,"- Channel prediction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"256QAM",797,6.2266000000000004]
[null,"- HARQ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"256QAM",885,6.9141000000000004]
[null,"3GPP TS 36.942 Table A.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"256QAM",948,7.4062999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 5.2.2.1-2: 4-bit CQI Table (uplink"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CQI index","modulation","code rate x 1024","efficiency"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"out of range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"QPSK",78,0.15229999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"QPSK",120,0.2344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"QPSK",193,0.377]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"QPSK",308,0.60160000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"QPSK",449,0.877]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"QPSK",602,1.1758]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"16QAM",378,1.4765999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"16QAM",490,1.9140999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"16QAM",616,2.4062999999999999]
[null,null,null,null,null,null,null,null,null,null,null,"Note: total Res Elem from Max Tput is NRB*12/T = NRB*12*14*1000*2^mu",null,null,null,null,null,null,null,null,10,"64QAM",466,2.7305000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"64QAM",567,3.3222999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"64QAM",666,3.9022999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"64QAM",772,4.5233999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"64QAM",873,5.1151999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"64QAM",948,5.5547000000000004]