{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Rev","4 Chan WDM","Functions","Channel Est"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Rev","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
["Pete Anslow",null,"This spreadsheet includes User Defined Functions so Macros must be Enabled for proper operation"]
["Paul Kolesar",null,"The worksheet is locked except for input cells.  Use Tools, Protection, Unprotect sheet to unlock (no password needed)"]
[null,null,"User configurable cell are in bold blue font"]
["Duane Remein",null,"Channel Est. tab can be used to derive nearest grid frequencies to a given wavenength (nm)"]
[]
["V 1.0","2007-01-17","Initial version in anslow_02_0107.xls"]
["V 2.0","2007-03-07","anslow_02_0307.xls This version agreed at Fiber Optic Ad Hoc 4 April 2007"]
["V 3.0 Draft 2","2007-11-12","Re-arranged to have 4 separate channels and predict max optical skew variation.  Equations moved to user-defined functions."]
["V4.0","2016-05-01","remein_3ca_3_0516.xlsx  Added ability to define custom channel wavelengths & estimated channel frequency tab"]

{"sheet":"4 Chan WDM","index":1,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,9,0],[10,0,12,0],[13,0,17,0],[42,0,51,0],[4,4,4,8],[42,1,46,1],[47,1,51,1],[18,0,27,0],[28,0,29,0],[30,0,33,0]]}
[null,"Parameter","Value","Units"]
["Inputs","Aggregate bit rate after PCS coding",25,"GBd"]
[null,"Link length",20,"km"]
[null,"Fibre type (G.652.A&B (B1.1) or G.652.C&D (B1.3))","G.652.A&B","-"]
[null,"Grid type","DWDM","-","Custom Grid wavelengths"]
[null,"DWDM Grid Spacing",800,"GHz",1,2,3,4,"Channel"]
[null,"DWDM Frequency tolerance (+/-% of spacing)",20,"%",1290,1310,1325,1340,"Min"]
[null,"DWDM Channel 1 centre frequency",231.9,"THz",1300,1315,1330,1345,"Max"]
[null,"ITU CWDM Channel 1 centre wavelength",1291,"nm"]
[null,"ITU CWDM Wavelength tolerance (+/- nm)",6.5,"nm"]
["Fibre limits","Maximum zero dispersion wavelength (l0 max)",1324,"nm"]
[null,"Maximum zero dispersion wavelength (l0 min)",1300,"nm"]
[null,"Maximum fibre dispersion slope",9.2999999999999999E-2,"ps/(nm^2.km)"]
["Results","Maximum loss for any channel",{"$f":"MAX(E29:H30)","v":8.7325011214147708},"dB"]
[null,"Maximum dispersion for any channel",{"$f":"MAX(E31:H32)","v":13.275459794878744},"ps/nm"]
[null,"Minimum dispersion for any channel",{"$f":"MIN(E33:H34)","v":-62.018943506308624},"ps/nm"]
[null,"Maximum optical skew",{"$f":"MAX(C37,C41)","v":4.4864184516645764},"UI"]
[null,"Maximum optical skew variation",{"$f":"MAX(C38,C42)","v":1.0543507653110282},"UI"]
[{"$f":"\"Channels for Grid Type \" & C5","v":"Channels for Grid Type DWDM"},"Channel number",null,"-",1,2,3,4]
[null,"Channel frequency upper bound",null,"THz",{"$f":"E21+$C6/1000*$C7/100","v":232.06},{"$f":"F21+$C6/1000*$C7/100","v":231.26},{"$f":"G21+$C6/1000*$C7/100","v":230.45999999999998},{"$f":"H21+$C6/1000*$C7/100","v":229.65999999999997}]
[null,"Channel centre frequency",null,"THz",{"$f":"C8","v":231.9},{"$f":"E21-$C6/1000","v":231.1},{"$f":"F21-$C6/1000","v":230.29999999999998},{"$f":"G21-$C6/1000","v":229.49999999999997}]
[null,"Channel frequency lower bound",null,"THz",{"$f":"E21-$C6/1000*$C7/100","v":231.74},{"$f":"F21-$C6/1000*$C7/100","v":230.94},{"$f":"G21-$C6/1000*$C7/100","v":230.14},{"$f":"H21-$C6/1000*$C7/100","v":229.33999999999997}]
[null,"channel width",null,"nm",{"$f":"E27-E28","v":1.7838954209332769},{"$f":"F19-F28","v":-1294.3437602698264},{"$f":"G19-G28","v":-1297.843782001215},{"$f":"H19-H28","v":-1301.3751545763305}]
[null,"channel center",null,"nm",{"$f":"E28+(E23)/2","v":1292.7667128574112},{"$f":"F28+(F23)/2","v":649.17188013491318},{"$f":"G28+(G23)/2","v":651.9218910006075},{"$f":"H28+(H23)/2","v":654.68757728816524}]
[null,"channel guard below",null,"nm","n/a",{"$f":"F28-E19","v":1295.3437602698264},{"$f":"G28-F19","v":1298.843782001215},{"$f":"H28-G19","v":1302.3751545763305}]
[null,"channel guard above",null,"nm",{"$f":"F28-E19","v":1295.3437602698264},{"$f":"G28-F19","v":1298.843782001215},{"$f":"H28-G19","v":1302.3751545763305},"n/a"]
[null,"Maximum channel wavelength",null,"nm",{"$f":"VLOOKUP($C$5,MaxLambdaTable,E19+2,FALSE)","v":1293.6586605678779},{"$f":"VLOOKUP($C$5,MaxLambdaTable,F19+2,FALSE)","v":1298.1400277128259},{"$f":"VLOOKUP($C$5,MaxLambdaTable,G19+2,FALSE)","v":1302.6525506213611},{"$f":"VLOOKUP($C$5,MaxLambdaTable,H19+2,FALSE)","v":1307.1965553326941}]
[null,"Minimum channel wavelength",null,"nm",{"$f":"VLOOKUP($C$5,MinLambdaTable,E19+2,FALSE)","v":1291.8747651469446},{"$f":"VLOOKUP($C$5,MinLambdaTable,F19+2,FALSE)","v":1296.3437602698264},{"$f":"VLOOKUP($C$5,MinLambdaTable,G19+2,FALSE)","v":1300.843782001215},{"$f":"VLOOKUP($C$5,MinLambdaTable,H19+2,FALSE)","v":1305.3751545763305}]
["Loss","Maximum fibre loss at max channel wavelength",null,"dB",{"$f":"fibre_loss($C$4,E27)*$C$3","v":8.6870316606996312},8.5794235879552616,8.4831927712252764,8.4018470983141924]
[null,"Maximum fibre loss at min channel wavelength",null,"dB",8.7325011214147708,8.6212933033425543,8.5200984669313584,8.4323687653090929]
["Dispersion","Maximum dispersion at max channel wavelength",null,"ps/nm",{"$f":"fibre_dispersion($C$12,$C$13,E27)*$C$3","v":-11.881900540266219},{"$f":"fibre_dispersion($C$12,$C$13,F27)*$C$3","v":-3.4669908093950519},{"$f":"fibre_dispersion($C$12,$C$13,G27)*$C$3","v":4.9186949593174116},13.275459794878744]
[null,"Maximum dispersion at min channel wavelength",null,"ps/nm",-15.256114622465827,-6.8294309271471239,1.5679081805896045,9.9362048908977343]
[null,"Minimum dispersion at max channel wavelength",null,"ps/nm",{"$f":"fibre_dispersion($C$11,$C$13,E27)*$C$3","v":-58.451544731541453},-49.556002594991625,-40.693002832543556,-31.862230919868189]
[null,"Minimum dispersion at min channel wavelength",null,"ps/nm",-62.018943506308624,-53.110296821843946,-44.23431773503313,-35.390692560400787]
["Skew","Relative delay at max channel wavelength and l0 max",null,"UI",{"$f":"fibre_delay($C$11,$C$13,E27)*$C$3*$C$2/4000","v":5.4772063232676373},3.964859136681298,2.6924213680285902,1.6623574317854946]
[null,"Relative delay at min channel wavelength and l0 max",null,"UI",6.148775883450071,4.5411454570403293,3.1724505810079791,2.0451386369140891]
[null,"Max optical skew for l0 max",{"$f":"MAX(E35:H36)-MIN(E35:H37)","v":4.4864184516645764},"UI",{"$f":"IF(AND(E$28<$C11,E$27>$C11),0,\"\")","v":""},{"$f":"IF(AND(F$28<$C11,F$27>$C11),0,\"\")","v":""},{"$f":"IF(AND(G$28<$C11,G$27>$C11),0,\"\")","v":""},{"$f":"IF(AND(H$28<$C11,H$27>$C11),0,\"\")","v":""}]
[null,"Max change of optical skew for l0 max",{"$f":"C37-(MAX(MIN(E35:E36),MIN(F35:F36),MIN(G35:G36),MIN(H35:H36))-MIN(MAX(E35:E36),MAX(F35:F36),MAX(G35:G36),MAX(H35:H36)))","v":1.0543507653110282},"UI"]
[null,"Relative delay at max channel wavelength and l0 min",null,"UI",{"$f":"fibre_delay($C$12,$C$13,E27)*$C$3*$C$2/4000","v":0.2348827994946987},2.0137147270361311E-2,4.0813659471496067E-2,0.29937675056771695]
[null,"Relative delay at min channel wavelength and l0 min",null,"UI",0.38615531494633615,7.7921324305862072E-2,4.1356305318913655E-3,0.16724561518367409]
[null,"Max optical skew for l0 min",{"$f":"MAX(E39:H40)-MIN(E39:H41)","v":0.38201968441444478},"UI",{"$f":"IF(AND(E$28<$C12,E$27>$C12),0,\"\")","v":""},{"$f":"IF(AND(F$28<$C12,F$27>$C12),0,\"\")","v":""},{"$f":"IF(AND(G$28<$C12,G$27>$C12),0,\"\")","v":""},{"$f":"IF(AND(H$28<$C12,H$27>$C12),0,\"\")","v":""}]
[null,"Max change of optical skew for l0 min",{"$f":"C41-(MAX(MIN(E39:E40),MIN(F39:F40),MIN(G39:G40),MIN(H39:H40))-MIN(MAX(E39:E40),MAX(F39:F40),MAX(G39:G40),MAX(H39:H40)))","v":0.18795054439124215},"UI"]
["Grids","Maximum channel wavelength","CWDM LX4","nm",1282.4000000000001,1306.9000000000001,1331.4,1355.9]
[null,null,"LR4","nm",1264.5,1284.5,1304.5,1324.5]
[null,null,"CWDM ITU","nm",1297.5,1317.5,1337.5,1357.5]
[null,null,"DWDM","nm",{"$f":"IF($C$5=\"CWDM LX4\",1282.4+24.5*(E$19-1),IF($C$5=\"CWDM ITU\",$C$9+$C$10+20*(E$19-1),IF($C$5=\"DWDM\",299792458/E$22/1000,IF($C$5=\"Custom\",E55,\"ERR!\"))))","v":1293.6586605678779},{"$f":"IF($C$5=\"CWDM LX4\",1282.4+24.5*(F$19-1),IF($C$5=\"CWDM ITU\",$C$9+$C$10+20*(F$19-1),IF($C$5=\"DWDM\",299792458/F$22/1000,IF($C$5=\"Custom\",F55,\"ERR!\"))))","v":1298.1400277128259},{"$f":"IF($C$5=\"CWDM LX4\",1282.4+24.5*(G$19-1),IF($C$5=\"CWDM ITU\",$C$9+$C$10+20*(G$19-1),IF($C$5=\"DWDM\",299792458/G$22/1000,IF($C$5=\"Custom\",G55,\"ERR!\"))))","v":1302.6525506213611},{"$f":"IF($C$5=\"CWDM LX4\",1282.4+24.5*(H$19-1),IF($C$5=\"CWDM ITU\",$C$9+$C$10+20*(H$19-1),IF($C$5=\"DWDM\",299792458/H$22/1000,IF($C$5=\"Custom\",H55,\"ERR!\"))))","v":1307.1965553326941}]
[null,null,"Custom","nm",{"$f":"E7","v":1290},{"$f":"F7","v":1310},1325,1340]
[null,"Minimum channel wavelength","CWDM LX4","nm",1269,1293.5,1318,1342.5]
[null,null,"LR4","nm",1277.5,1297.5,1317.5,1337.5]
[null,null,"CWDM ITU","nm",1284.5,1304.5,1324.5,1344.5]
[null,null,"DWDM","nm",{"$f":"IF($C$5=\"CWDM LX4\",1269+24.5*(E$19-1),IF($C$5=\"CWDM ITU\",$C$9-$C$10+20*(E$19-1),IF($C$5=\"DWDM\",299792458/E$20/1000,IF($C$5=\"Custom\",E56,\"ERR!\"))))","v":1291.8747651469446},{"$f":"IF($C$5=\"CWDM LX4\",1269+24.5*(F$19-1),IF($C$5=\"CWDM ITU\",$C$9-$C$10+20*(F$19-1),IF($C$5=\"DWDM\",299792458/F$20/1000,IF($C$5=\"Custom\",F56,\"ERR!\"))))","v":1296.3437602698264},{"$f":"IF($C$5=\"CWDM LX4\",1269+24.5*(G$19-1),IF($C$5=\"CWDM ITU\",$C$9-$C$10+20*(G$19-1),IF($C$5=\"DWDM\",299792458/G$20/1000,IF($C$5=\"Custom\",G56,\"ERR!\"))))","v":1300.843782001215},{"$f":"IF($C$5=\"CWDM LX4\",1269+24.5*(H$19-1),IF($C$5=\"CWDM ITU\",$C$9-$C$10+20*(H$19-1),IF($C$5=\"DWDM\",299792458/H$20/1000,IF($C$5=\"Custom\",H56,\"ERR!\"))))","v":1305.3751545763305}]
[null,null,"Custom","nm",{"$f":"E8","v":1300},{"$f":"F8","v":1315},1330,1345]
[]
[null,null,null,null,{"$f":"E27+(E28-E27)/2","v":1292.7667128574112},{"$f":"F27+(F28-F27)/2","v":1297.2418939913262},1301.7481663112881,1306.2858549545122]
[null,null,null,null,{"$f":"E$54-E27","v":-0.89194771046663845},{"$f":"F$54-F27","v":-0.89813372149978932},-0.90438431007305553,-0.91070037818190031]
[null,null,null,null,{"$f":"E$54-E28","v":0.89194771046663845},{"$f":"F$54-F28","v":0.89813372149978932},0.90438431007305553,0.91070037818167293]

{"sheet":"Functions","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[null,null,null,9.2999999999999999E-2]
[null,"G.652.A&B","G.652.C&D",1300,1324]
["lambda","Max Loss","Max Loss","D max","D min","Relative Delay"]
["(nm)","(dB/km)","(dB/km)","(ps/nm.km)","(ps/nm.km)","(ps/km)"]
[null,null,null,null,null,"for l0 min","for l0 max"]
[1260,{"$f":"fibre_loss(B$2,$A6)","v":0.4779123207996463},{"$f":"fibre_loss(C$2,$A6)","v":0.47812408980098553},{"$f":"fibre_dispersion(D$2,$D$1,$A6)","v":-3.9009216667266546},{"$f":"fibre_dispersion(E$2,$D$1,$A6)","v":-6.4210368427695608},{"$f":"fibre_delay(D$2,$D$1,$A6)","v":76.780650037784653},{"$f":"fibre_delay(E$2,$D$1,$A6)","v":200.26121094481641}]
[1270,{"$f":"fibre_loss(B$2,$A7)","v":0.46633867890011516},0.45970512280473486,{"$f":"fibre_dispersion(D$2,$D$1,$A7)","v":-2.8904242846674655},-5.351476693026644,{"$f":"fibre_delay(D$2,$D$1,$A7)","v":42.844420763845847},{"$f":"fibre_delay(E$2,$D$1,$A7)","v":141.42070007192524}]
[1280,0.45280876159984018,0.44575038173934445,-1.9040496253967285,-4.3078705765686056,18.891760253907705,93.145169003902993]
[1290,0.43907881869984067,0.43502623183303513,-0.94086994785923939,-3.2892203215705691,4.686116369208321,55.180107413005317]
[1300,0.42690509999977166,0.42653047869680449,0,-2.2945734708202075,0,27.280756033134821]
[1310,0.41804385529974297,0.41946543901576661,0.91940523426320531,-1.3230208576485569,4.6145715575985378,9.2116617598003359]
[1320,0.41425133439963702,0.41321254319336731,1.8181526525586442,-0.37369432765673111,18.319249311301974,0.74625625344197033]
[1330,0.41728378710001834,0.40730847073427867,2.69701302517133,0.55423540355269418,40.911338261066703,1.6664566374602146]
[1340,0.42889746319985989,0.4014228177984478,3.5567228681719469,1.461560765705888,72.195678324795153,11.762286977049371]
[1350,0.45084861249972619,0.39533729742106516,4.3979862063709794,2.3490392306489882,111.98431069959042,30.831519311934244]
[1360,0.48489348479995442,0.38892647226748522,5.2214762333350286,3.2173950983869299,160.09616133217787,58.679333096879418]
[1370,null,0.38214001983578783,6.027836875178167,4.0673211795922208,216.35674050296075,95.117991979328508]
[1380,null,0.37498652987414971,6.8176842643580562,4.8994803812863577,280.59785759294755,139.96653691241227]
[1390,null,0.36751883474062197,7.5916081292618216,5.7145072019180683,352.6573501630337,193.0504946669389]
[1400,null,0.35982087175943889,8.3501731049562675,6.513009141620989,432.3788265306066,254.20160086530086]
[1410,null,0.3519960777630331,9.0939199700986837,7.295568033026294,519.61142108042986,323.25753671645361]
[1420,0.45683921916725012,0.34415731781336945,9.8233668146550404,8.0627412976298558,614.20956159492198,400.0616786827959]
[1430,0.41437054554035058,0.33641834375157487,10.539010142749813,8.8150631323664861,716.03274793388846,484.4628603579622]
[1440,0.38057442864692348,0.32888678768358659,11.241325914673354,9.5530456307227372,824.94534143518104,576.31514587962738]
[1450,0.35407990056182825,0.32165868613810744,11.930770531797121,10.277179842423386,940.8163644470842,675.4776142430419]
[1460,0.33363948850956149,0.31481453789456282,12.607781767891892,10.987936775451972,1063.5193094389178,781.81415392005874]
[1470,0.31812921485061452,0.30841689347289503,13.272779650107996,11.685768343911882,1192.9319571706292,895.19326722476399]
[1480,0.30654859709602533,0.30250947771128267,13.926167292657887,12.371108264999112,1328.9362034331643,1015.4878839006633]
[1490,0.29802064788191274,0.29711784410756081,14.568331686038691,13.044372908139756,1471.417893901169,1142.5751834358744]
[1500,0.29179187500039916,0.29225156243774109,15.199644444444445,13.705962099143113,1620.2666666666701,1276.3364256426648]
[1510,0.28723228138142076,0.28790793861844577,15.8204625138435,14.356259882033756,1775.3758020481546,1416.6567890645092]
[1520,0.28383536509454643,0.28407726579462178,16.431128843034699,14.995635241051902,1936.6420792936333,1563.4252168005551]
[1530,0.28121811934897778,0.28074961059610359,17.031973019845726,15.62444278514967,2103.9656398180232,1716.5342693605053]
[1540,0.27912103250992004,0.27792312866949942,17.623311874497574,16.243023397160776,2277.249856636874,1875.8799841861983]
[1550,0.2774080880622023,0.27561391521885525,18.205450052029139,16.851704849681582,2456.401209677424,2041.3617414967739]
[1560,0.27606676464665725,0.27386738681525458,18.778680555555557,17.450802389571638,2641.3291666666701,2212.8821361341179]
[1570,0.27520803604193134,0.27277119555219542,19.343285262021457,18.04061929286107,2831.9460693131623,2390.3468551040569]
[1580,0.27506637116812271,0.27246967640530784,19.899535412005946,18.621447391739803,3028.1670245153,2573.6645605255617]
[1590,0.27599973408314327,0.27317982648673933,20.447692075038827,19.193567575198916,3229.9098003441322,2762.7467777168567]
[1600,0.27848958400090851,0.27520881722739432,20.988006591796875,19.757250264796877,3437.0947265625,2957.5077881624966]
[1610,0.28314087525495779,0.27897303811914753,21.520720994464547,20.312755866932516,3649.6445994560345,3157.8645271193236]
[1620,0.29068205734392905,0.28501867428713012,22.046068406464688,20.860335202921867,3867.4845907636045,3363.7364856332861]

{"sheet":"Channel Est","index":3,"n_rows":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,0,4,2],[10,0,10,2]]}
["c",2.9979245799999998,"M/sec"]
["Base",193.1,"GHz"]
["Start",{"$f":"-ROUND((B8-B2)/(B7/1000),0)-10","v":-209},"n"]
[]
["Channel 1 Est."]
[" wavelength",1287.5,"nm"]
["spacing",200,"THz"]
["Frequency",{"$f":"100000*SOL/B6","v":232.84851106796114},"GHz"]
["Next lower Grid",{"$f":"$B$2-B3*$B$7/1000","v":234.89999999999998},"GHz"]
[]
["Flex Grid channels"]
["n","GHz","Wavelength"]
[{"$f":"INT(B3)","v":-209},{"$f":"$B$2-A13*($B$7/1000)","v":234.9},{"$f":"100000*$B$1/B13","v":1276.2556747552148}]
[{"$f":"A13+1","v":-208},234.7,{"$f":"100000*SOL/B14","v":1277.3432381763953}]
[{"$f":"A14+1","v":-207},234.5,{"$f":"100000*$B$1/B15","v":1278.4326567164178}]
[-206,234.3,1279.5239351259067]
[-205,234.1,1280.6170781717215]
[-204,233.9,1281.7120906370242]
[-203,233.7,1282.8089773213521]
[-202,233.5,{"$f":"100000*$B$1/B20","v":1283.9077430406851}]
[-201,233.3,1285.0083926275181]
[-200,233.1,1286.1109309309309]
[-199,232.9,1287.2153628166593]
[-198,232.7,1288.321693167168]
[-197,232.5,1289.4299268817203]
[-196,232.3,1290.5400688764528]
[-195,232.1,1291.6521240844463]
[-194,231.9,1292.7660974557998]
[-193,231.7,1293.881993957704]
[-192,231.5,1294.9998185745139]
[-191,231.3,1296.1195763078251]
[-190,231.1,1297.241272176547]
[-189,230.9,1298.3649112169769]