{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Link model illustration","Revision notes","Colour code","version 1.0"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"Link model illustration","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Revision notes","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Version 2.0"]
["Align the model with motion #19 from July 2007 minutes: “For budget calculations, assume the following mapping function between ITU-T sensitivity and IEEE stressed sensitivity. Sensitivity(ITU)[OMA] + Optical_Path_Penalty(ITU) = Stressed_Sensitivity(IEEE)"]
["Implement the new dispersion penalty calculation mechanism proposed in 3av_0705_saeki_1.pdf"]
["Less clutter – more user friendly interface"]
["Parameters divided into Tx, Rx and channel groups"]
["Aligns the model with the contents of motion #19 from July 2007 minutes"]
["Calculate the Channel Insertion Loss (ChIL) as a total of: splitter loss (calculated), fibre loss (ideal), connector loss and excess loss (user provided)"]
["Required Rx sensitivity is calculated based on Tx output power (min value) and the maximum ChIL figure"]
["Both IEEE and ITU Rx sensitivity figures are calculated, IEEE Stressed Rx Sensitivity is estimated "]
["Cells B16, B17 and B24 are based on drop down lists to allow only specific parameter values – prevents introduction of unexpected values by users"]
["Added range checking for most of the user defined and calculated parameters"]
["Added dispersion penalty testing (Dispersion_penalty <= ITU_Optical_Path_Penalty)"]
["G652AB/CD fibre attenuation curves with min / max values"]
["Added min/max/average curves for PSC insertion loss "]
["Spreadsheet is locked but not password protected (Tools > Protection > Protect Sheet)"]
[]
["Version 2.1"]
["added a legend for the field color code "]
["uniformization of the Tx_Chirp_Parameter_Max with the official definition in Agrawal’s “Fiber-Optic Communication Systems” "]
["correction in the Dispersion_Penalty formula (minus sign missing) "]
["removal of the circular reference in the Fibre_Attenuation_Value formula for G652AB and G652CD options in the Fibre_Attenuation_Curve parameter "]
["parameter Tx_Spectral_Width_Max was removed - it was not used in any calculations (carry-on from the previous spreadsheet version) "]
["added TDP parameter cell (user defined) "]
["updated the Channel Link Model Illustration (see tab Link model illustration)"]
[]
["Version 2.2"]
["Added IEEE_Tx_OMA_Min and IEEE_Tx_OMA_Max parameters to faciliate the filling in tables in clause 60"]
["Corrected error in the conversion between dBm OMA and uW OMA - cells affected: B8, B10, B44, B47, B49"]
["Conversion formulas: dBm > wM: 10^(dBm/10); mW > dBm: 10log10(mW); OMA=2*Pmean*(ER-1)/(ER+1); ER=(2*Pmean+OMA)/(2*Pmean-OMA)"]
["Added extended description of the model parameter definitions in the Comments column"]
["Added a new tab with the colour code for improved readibility."]
[]
["Version 2.3"]
["Added IEEE_Rx_Sen_Ave parameter to facilitate filling up the tables in Clause 91 (PMD parameters)"]
["Added Power Budget field, which calculates the total available power budget"]

{"sheet":"Colour code","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,1,6,8],[5,1,5,8],[1,1,1,8],[0,0,0,8],[3,1,3,8],[2,1,2,8],[4,1,4,8]]}
["Colour Code Key"]
[null,"User input field (unlocked)"]
[null,"Introduced value is OK"]
[null,"Introduced / Calculated value is outside of expected range"]
[null,"Locked fields, not accessible to a user"]
[null,"Comments"]
[null,"Newly added fields"]

{"sheet":"version 1.0","index":3,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,5],[55,0,55,2],[16,0,16,5],[41,0,41,5],[54,0,54,5]]}
["Parameter name","Value","Unit","Description","Value min","Value max"]
[]
["Transmitter parameters"]
["ITU_ERnom",9,"dB","Nominal Extinction Ratio used to convert average power values to OMA values - for a test procedure, see 802.3, clause 52.9.5; for relation between OMA, ER and average power, see 802.3, clause 58.7.6",0,9,null,"min","lambda^-4","min"]
["ITU_Tx_Ave_Min",6,"dBm","Average Tx launch power (minimum) equal to the minimum OMA at the maximum ER",-99,99,null,"ave","G652AB","max"]
["ITU_Tx_Ave_Max",8,"dBm","Average Tx launch power (maximum) equal to the maximum OMA at the nominal ER",-99,99,null,"max","G652CD"]
["IEEE_Tx_OMA_Min",{"$f":"10*LOG((2*10^(B5/10)*(10^(B4/10)-1)/(10^(B4/10)+1)),10)","v":7.9109787975607118},"dBm","Minimum OMA Tx launch power"]
["IEEE_Tx_OMA_Min",{"$f":"10^(B7/10)","v":6.1815570218848501},"mW","Minimum OMA Tx launch power"]
["IEEE_Tx_OMA_Max",{"$f":"10*LOG((2*10^(B6/10)*(10^(B4/10)-1)/(10^(B4/10)+1)),10)","v":9.9109787975607126},"dBm","Maximum OMA Tx launch power"]
["IEEE_Tx_OMA_Max",{"$f":"10^(B9/10)","v":9.7971076427954937},"mW","Maximum OMA Tx launch power"]
["Tx_Wavelength_Min",1340,"nm","Transmitter wavelength (min)",1200,1600]
["Tx_Wavelength_Max",1360,"nm","Transmitter wavelength (max)",1200,1600]
["Tx_Wavelength_Uc",{"$f":"(B12+B11)/2","v":1350},"nm","Transmitter wavelength (central wavelength), calculated based on Tx_Wavelength_Min and Tx_Wavelength_Max",{"$f":"B11","v":1340},{"$f":"B12","v":1360}]
["Tx_Chirp_Parameter_Max",0,"-","The maximum (worst case) value of Chirp parameter used in the calculation of the dispersion penalty. (Normal DML's are negative)"]
["Tx_Data_Rate",25000,"MBd","The effective data rate at the PMD level after encoding, scrambling i.e. fed to the PMA interface and transmitted on the fibre channel",9500,100000]
[]
["Link parameters"]
["Fibre_Attenuation_Curve","lambda^-4","-","Defines the type of the fibre attenuation curve which will be used for calculation of the fibre attenuation for the given operating wavelength. 3 types of curves are available i.e. lambda^-4,G652AB,G652CD"]
["Fibre_Attenuation_Curve_Type","min","-","Defines the variant of the fibre attenuation curve for G.652 SMF. Maximum and minimum attenuation curves are available only for G652AB and G652CD type of fibre."]
["Fibre_Attenuation_Base_Value",0.35,"dB/km","Base wavelength for fibre attenuation estimation - only applicable to the lambda^-4 model.",0,1]
["Fibre_Attenuation_Base_Wavelength",{"$f":"IF(B18=\"lambda^-4\",(IF(Uc<1000,850,IF(Uc>1430,1550,1310))),Uc)","v":1310},"nm","Base wavelength for fibre attenuation estimation"]
["Fibre_Attenuation_Value",{"$f":"fibre_loss(B18,B19,B21,B20,Uc)","v":0.33845151782066002},"dB/km","Calculated nominal attenuation of fibre in dB/km of ideal channel (no connectors, splices etc. i.e. the medium is considered to be continous)"]
["Channel_Length_Max",20,"km","The length of the fibre channel between the OLT and the most distant ONU",0.5,20]
["Fibre_Loss",{"$f":"B22*B23","v":6.7690303564132002},"dB","Calculated total attenuation of an ideal fibre channel (no connectors, splices etc. i.e. the medium is considered to be continous)"]
["PSC_Split_count",32,"-","The maximum number of ports on the Passive Splitter Combiner (powers of 2 are acceptable)",2,64]
["PSC_Loss_Curve","max","-","Defines the type of the PSC loss curve (best case [min], average [avg] and worst case [max]) for the FBT type PSC devices, based on the collected device loss data and approximated curves."]
["PSC_Loss",{"$f":"10*LOG(B25)+IF(B26=\"ave\",0.564*LN(B25)+0.4,IF(B26=\"min\",0.288*LN(B25)+0.09,0.663*LN(B25)+1.05))","v":18.399282686755278},"dB","The total loss of the PSC device with the particular number of ports (PSC_Split_count) for the given loss curve (PSC_Loss_Curve), accounting for the ideal and excess loss"]
["SRS_Loss",1,"dB","SRS induced nonlinear penalty (as resulting from the nonlinear interaction with any other transmission system e.g. 1550nm Analog video overlay operated on the PON fiber).",null,10]
["Excess_Loss",{"$f":"B32-B24-B27-B28","v":2.8316869568315219},"dB","The additional loss resulting from the non-ideal fibre channel elements i.e. connectors, splices and as well as other sources of extra loss"]
["ITU_Optical_Path_Penalty",1,"dB","The penalty attributable to the optical path.  Given a fixed set of transmitter and receiver, the optical path penalty is equal to the link margin measured with pure attenuation less the link margin measured with the worst case optical path.",0,5]
["Channel_Loss_Min",8,"dB","Minimum channel insertion loss (user defined) to prevent the overload of the receiver on the receiving side of the link.",0,{"$f":"B32","v":29}]
["Channel_Loss_Max",29,"dB","Maximum channel insertion loss (user defined), limited by the Tx power and Rx sensitivity",{"$f":"B31","v":8},45]
["Power Budget",{"$f":"B5-B49","v":30.499999999999996},"dB","Available power budget"]
["Dispersion_Uo_Min",1300,"nm","Minimum value of the zero dispersion wavelength"]
["Dispersion_Uo_Max",{"$f":"IF(Uc>1312,1300,1324)","v":1300},"nm","Maximum value of the zero dispersion wavelength"]
["Dispersion_So",{"$f":"IF(Uo=1320,0.11,0.093)","v":9.2999999999999999E-2},"ps/nm^2·km","Value of the dispersion curvature parameter"]
["Dispersion_D_Max",{"$f":"0.25*B36*B12*(1-(B34/B12)^4)","v":5.221476233335026},"ps/(nm·km)","Maximum calculated dispersion \"D\" parameter"]
["Dispersion_D_Min",{"$f":"0.25*B36*B11*(1-(B35/B11)^4)","v":3.5567228681719452},"ps/(nm·km)","Minimum calculated dispersion \"D\" parameter"]
["Dispersion_Penalty",{"$f":"5*LOG((1+8*(B14)*(-(B11^2/(2*PI()*3*10^5)*B38))*(B15/1000000)^2*B23)^2+(8*(-(B11^2/(2*PI()*3*10^5)*B38))*(B15/1000000)^2*B23)^2,10)","v":0.23597198684335674},"dB","Dispersion penalty, calculated for the worst case transmission wavelength in the allocated window (Tx_Wavelength_Min, Tx_Wavelength_Max), based on the dispersion penalty estimation model presented in 3av_0705_saeki_1.pdf"]
["TDP",1.5,"dB","Transmitter and Dispersion Penalty (maximum) is equal to the link margin, measured with an ideal Tx and pure attenuation less the link margin measured with a worst case Tx and worst case optical path.",0,10]
[]
["Receiver parameters"]
["ITU_Rx_Sensitivity_Ave ",{"$f":"B5-B32-B30","v":-24},"dBm","Average Rx sensitivity in ITU formalism, calculated as the difference between the minimum, average Tx launch power (ITU_Tx_Ave_Min) and the total power budget (Channel_Loss_Max + ITU_Optical_Path_Penalty) @ BER 1e-3"]
["ITU_Rx_Sensitivity_Ave_OMA",{"$f":"10*LOG((2*10^(B43/10)*(10^(B4/10)-1)/(10^(B4/10)+1)),10)","v":-22.089021202439287},"dBm","Average Rx sensitivity (ITU_Rx_Sensitivity_Ave) in OMA, for the given nominal ER (ITU_Ernom) @ BER 1e-3"]
["ITU_Rx_Sensitivity_Ave_OMA",{"$f":"1000*10^(B44/10)","v":6.1815570218848483},"uW","Average Rx sensitivity (ITU_Rx_Sensitivity_Ave) in OMA, for the given nominal ER (ITU_Ernom) @ BER 1e-3"]
["IEEE_Rx_Stressed_Sensitivity_Ave",{"$f":"B43+B30","v":-23},"dBm","Stressed Rx sensitivity in average power form @ BER 1e-3"]
["IEEE_Rx_Stressed_Sensitivity_OMA ",{"$f":"10*LOG((2*10^(B46/10)*(10^(B4/10)-1)/(10^(B4/10)+1)),10)","v":-21.089021202439287},"dBm","OMA stressed Rx sensitivity in average power form @ BER 1e-3"]
["IEEE_Rx_Stressed_Sensitivity_OMA ",{"$f":"1000*10^(B47/10)","v":7.7821192193055069},"uW","OMA stressed Rx sensitivity in average power form @ BER 1e-3"]
["IEEE_Rx_Sen_Ave",{"$f":"10*LOG(((10^(B51/10))/(2*(10^(B4/10)-1)/(10^(B4/10)+1))),10)","v":-24.499999999999996},"dBm","Ideal Rx sensitivity in IEEE formalism in average power taking the TDP into account."]
["IEEE_Rx_Sen_Ave",{"$f":"1000*10^(B49/10)","v":3.5481338923357555},"uW","Ideal Rx sensitivity in IEEE formalism in average power taking the TDP into account."]
["IEEE_Rx_Sen_OMA",{"$f":"B47-B40","v":-22.589021202439287},"dBm","Ideal Rx sensitivity in IEEE formalism in OMA taking the TDP into account."]
["IEEE_Rx_Sen_OMA",{"$f":"1000*10^(B51/10)","v":5.5093184948821143},"uW","Ideal Rx sensitivity in IEEE formalism in OMA taking the TDP into account."]
["Rx_Overload",{"$f":"B6-B31","v":0},"dBm","The Rx overload value for the given link"]
[]
["Check Conditions"]
["Dispersion_Penalty <= ITU_Optical_Path_Penalty",null,null,{"$f":"IF(B39<=B30,\"PASSED\",\"FAILED\")","v":"PASSED"}]