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

{"sheet":"Revision history","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Fronthaul dimensioning tool"]
["Developed by MTI"]
[]
["Revision","Date","Author","Comment"]
[0.1,"2017-01-20","Andrijana Popovska Avramova","Throughput calculations, options 8-5"]
[0.2,"2017-02-22","Aleksandra Checko","Main added, works for split 8 only"]
[0.3,"2017-03-21","Aleksandra Checko","Splits 1-8 are considered for FDD, LTE DL. TDD tentatively"]
[0.4,"2017-04-06","Aleksandra Checko","Uplink added, figure with splits updated. TDD removed"]
[0.5,"2017-04-07","Aleksandra Checko","Clarification that for split 1-6 transport overhead is included is assumption"]
[1,"2017-04-10","Aleksandra Checko","Some comments added"]
[1.1000000000000001,"2017-04-21","Aleksandra Checko","Real-time control added. Format changed from a template to non-template. Typos fixed. One more variant added"]

{"sheet":"Main","index":1,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[5,8,5,16],[8,0,26,0],[3,0,3,5],[2,0,2,5],[27,0,32,0],[6,9,7,16],[6,8,7,8],[8,9,9,16],[8,8,9,8],[12,9,13,16],[14,9,15,16],[12,8,13,8],[14,8,15,8],[10,9,11,16],[10,8,11,8]]}
["Fronthaul dimensioning tool for LTE in DL and UL"]
["Developed by  MTI"]
["Contact: Aleksandra.Checko@mtigroup.com, Andrijana.Avramova@mtigroup.com",null,null,null,null,null,null,null,"\n"]
["Edit values of input parameters to see resulting fronthaul throughput. ",null,null,null,null,null,null,null,"LTE calculations are based on document 159.05.1.01 Small Cell Virtualization Functional Splits and Use Cases, Small Cell Forum, June 2015"]
[]
["Configuration",null,null,null,null,null,null,null,"Assumptions"]
[null,null,"Variant 1","Variant 2","Variant 3","Variant 4",null,null,"PUSCH in UL","Split 7.3, UL - only data for PUSCH taken into account, control channels impact is treated as negligible here"]
[null,"Input Parameters","Value","Value","Value","Value"]
["Radio","Bandwidth per user [MHz]",20,100,20,20,null,null,"PDSCH in DL","Split 7.3, DL - only data for PDSCH taken into account, control channels impact is treated as negligible here"]
[null,"# of subcarriers per RB",12,12,null,12]
[null,"# of antennas",2,16,2,2,null,null,187.5,"Throughput requirement in Mbps for spilt option 1-6 [NGMN Small Cell Backhaul Requirements, June 2012] for 20 MHz, 64QAM, 2 MIMO layers. That includes transport overhead"]
[null,"# MIMO layers",2,16,2,2]
[null,"# of symbols per subframe (DL)",14,14,null,14,null,null,"Option 7-3 (DL)","3GPP considers it only for DL: Only the encoder resides in the CU, and the rest of PHY functions reside in the DU. "]
[null,"# of CFI symbols (DL)",1,1,null,1]
[null,"# of UEs per TTI (DL)",1,1,null,1,null,null,"Option 7-1 (DL)","iFFT and CP addition functions reside in the DU, the rest of PHY functions reside in the CU."]
[null,"avg # of RE for reference signal per RB per subframe per antenna, excluding ones within symbols booked by CFI (DL)",6,6,null,6]
[null,"# of data carrying symbols per sub-frame (UL)",12,12,null,12]
[null,"# of RB per PUCCH (UL)",2,2,null,2]
[null,"# of bits in log likelihood ratio (UL)",8,8,null,8,null,null,"Splits naming convention based on 38.801. Splits 7.1, 7.2 and 7.3 edited by MTI"]
[null,"Bit width (I+Q)",32,32,null,32]
[null,"Compression, % of original",1,0.58499999999999996,1,1]
[null,"Modulation (e.g. 64QAM = 6, 256QAM = 8)",6,8,6,6]
[null,"# Sectors",1,1,1,1]
[null,"Load factor ",1,1,1,1]
[null,"DL or UL?","DL","DL","DL","DL"]
[null,"Real-time control, % (e.g. beamforming weights and scheduling)",0,0,0,0]
[null,"Split option","3GPP Option 8","3GPP Option 7.1","3GPP Option 2","3GPP Option 6"]
["FH entering DU","Transport overhead, % (e.g. CPRI 25% or 3.125%, RoE <10%)",0,0,0,0]
[null,"MUX gain on link entering DU [sum of throughputs/aggregated throughput]",1,1,1,1]
[null,"# of RRU per FTN I",1,3,1,1]
[null,"# of FTN I per DU",1,6,1,1]
[null,"# of optical modules per RRU ",1,2,1,1]
[]
[]
[null,"Resulting throughput on fronthaul, Gbps",{"$f":"IF(C27=\"3GPP Option 8\", ((30.72*C9/20*C11*C20*C21*C23*(1+C26)*(C28+1)*C30*C31*C32)/1000), IF(C27=\"3GPP Option 7.1\", ((C9/20*100*IF(C25=\"DL\", C13, IF(C25=\"UL\", C17))*C10*C11*C20*C21*C23*C24*(1+C26)*(C28+1)*C30*C31*C32)/1000000), IF(C27=\"3GPP Option 7.3\", ((IF(C25=\"DL\",(C9/20*100*C15*(C10*(C13-C14)-(C16*C11))), IF(C25=\"UL\",(C17*C10*(C9/20*100-C18)*C19)))*C21*C22*C12*C23*C24*(1+C26)*(C28+1)/C29*C30*C31*C32)/1000000), IF(OR(C27=\"3GPP Option 1\", C27=\"3GPP Option 2\", C27=\"3GPP Option 3\", C27=\"3GPP Option 4\", C27=\"3GPP Option 5\", C27=\"3GPP Option 6\"), ($I$11*(C9/20*C12/2*C21*C22/6*C23*C24*(1+C26)*(C28+1)/C29*C30*C31*C32)/1000), 0))))","v":1.9660799999999998},{"$f":"IF(D27=\"3GPP Option 8\", ((30.72*D9/20*D11*D20*D21*D23*(1+D26)*(D28+1)*D30*D31*D32)/1000), IF(D27=\"3GPP Option 7.1\", ((D9/20*100*IF(D25=\"DL\", D13, IF(D25=\"UL\", D17))*D10*D11*D20*D21*D23*D24*(1+D26)*(D28+1)*D30*D31*D32)/1000000), IF(D27=\"3GPP Option 7.3\", ((IF(D25=\"DL\",(D9/20*100*D15*(D10*(D13-D14)-(D16*D11))), IF(D25=\"UL\",(D17*D10*(D9/20*100-D18)*D19)))*D21*D22*D12*D23*D24*(1+D26)*(D28+1)/D29*D30*D31*D32)/1000000), IF(OR(D27=\"3GPP Option 1\", D27=\"3GPP Option 2\", D27=\"3GPP Option 3\", D27=\"3GPP Option 4\", D27=\"3GPP Option 5\", D27=\"3GPP Option 6\"), ($I$11*(D9/20*D12/2*D21*D22/6*D23*D24*(1+D26)*(D28+1)/D29*D30*D31*D32)/1000), 0))))","v":905.74847999999997},0.1875,0.1875]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Source: IEEE 1914, tf1_1701_huang_two-level-architecture_2.pdf"]

{"sheet":"Technical","index":2,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Valid split options"]
["3GPP Option 1"]
["3GPP Option 2"]
["3GPP Option 3"]
["3GPP Option 4"]
["3GPP Option 5"]
["3GPP Option 6"]
["3GPP Option 7.1"]
["3GPP Option 7.3"]
["3GPP Option 8"]
[]
["Valid duplex options"]
["FDD"]
["TDD"]
[]
["Valid directions"]
["DL"]
["UL"]
[]
["Ideas FFS"]
["Editorial:"]
["After selecting a given split, parameters that have impact are highlighted"]
["Lock some fields"]
["Technical:"]
["TDD"]
["Option 7.2"]
["number of DU per CU"]
["Resiliency"]