{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calculator","NPR SPL Table","Salary Ranges"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Calculator","index":0,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,13,4,15],[1,5,2,17],[7,8,8,9]]}
[]
[null,null,null,null,null,"2019 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200425,null,null,null,null,null,null,"Career Path","Broad-band","Max Pay","Retained Pay?",null,"Upper Rail","Standard Pay Line","Lower Rail"]
["GS-1/1 Base Salary=",19048,null,null,null,null,"Enter Base Pay/Retained Pay",100000,"NH",4,{"$f":"VLOOKUP($J$7,MaxPay,MATCH($I$7,PaySched,1)+1,FALSE)","v":138572},{"$f":"IF($H$7>$K$7,\"Yes\",\"No\")","v":"No"},"Expected Contribution Range =",{"$f":"IF(ISERROR(CEILING((LN($O$8)-LN(intercept*1.08))/LN(slope),1)),NA(),CEILING((LN($O$8)-LN(intercept*1.08))/LN(slope),1))","v":80},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":83.560954722887189},{"$f":"IF(ISERROR(FLOOR((LN($O$8)-LN(intercept*0.92))/LN(slope),1)),NA(),FLOOR((LN($O$8)-LN(intercept*0.92))/LN(slope),1))","v":87}]
[null,null,null,null,null,null,null,null,"Click on Boxes for Dropdown List to Select",null,null,null,null,"Pay Used in Calculation:",{"$f":" IF($L$7=\"Yes\",$K$7,$H$7)","v":100000}]

{"sheet":"NPR SPL Table","index":1,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[56,1,56,9],[0,0,0,10],[1,1,1,2],[1,3,1,8],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
["Normal Pay Range and Standard Pay Line for 2019"]
[15442,{"$f":"slope","v":1.0200425},null,"(Based on 0% Increase)"]
[]
[null,"OCS","SPL","*0.92 \nLower Rail","*1.08\nUpper Rail",null,"OCS","SPL","*0.92 \nLower Rail","*1.08\nUpper Rail"]
[]
["GS01/1",0,{"$f":"intercept","v":19048},{"$f":"SUM(C6*0.92)","v":17524.16},{"$f":"SUM(C6*1.08)","v":20571.84}]
[null,1,{"$f":"SUM(C6*$B$2)","v":19429.769539999998},{"$f":"SUM(C7*0.92)","v":17875.387976799997},{"$f":"SUM(C7*1.08)","v":20984.151103199998},null,51,{"$f":"SUM(C56*$B$2)","v":52405.998345615611},{"$f":"SUM(H7*0.92)","v":48213.518477966361},{"$f":"SUM(H7*1.08)","v":56598.478213264862}]
[null,2,{"$f":"SUM(C7*$B$2)","v":19819.190696005448},{"$f":"SUM(C8*0.92)","v":18233.655440325012},{"$f":"SUM(C8*1.08)","v":21404.725951685883},null,52,{"$f":"SUM(H7*$B$2)","v":53456.345567457611},49179.837922061,57732.853212854221]
[null,3,20216.416825530137,18599.103479487727,21833.730171572552,null,53,{"$f":"SUM(H8*$B$2)","v":54527.744373493377},50165.524823613909,58889.963923372852]
[null,4,20621.604359755824,18971.87601097536,22271.332708536291,null,54,55620.616690099116,51170.967354891189,60070.26602530705]
[null,5,21034.91286513623,19352.119835925332,22717.705894347131,null,55,56735.392900110426,52196.561468101594,61274.224332119265]
[null,6,21456.505106235723,19739.984697736865,23173.025514734582,null,56,57872.512012310886,53242.71105132602,62502.31297329576]
[null,7,21886.547109827454,20135.623341041257,23637.470878613651,null,57,59032.421834317625,54309.828087572219,63755.015581063039]
[null,8,22325.20823027617,20539.191571854077,24111.224888698267,null,58,60215.579148931931,55398.332817017377,65032.825480846492]
[null,9,22772.661216231478,20950.84831893296,24594.474113529999,null,59,61422.449894024394,56508.653902502447,66336.245885546348]
[null,10,23229.082278657796,21370.755696365173,25087.408860950422,null,60,62653.509346025377,57641.228598343347,67665.790093707416]
[null,11,23694.651160227793,21799.07906740957,25590.223253046017,null,61,63909.242307093089,58796.502922525644,69021.981691660534]
[null,12,24169.551206106658,22235.987109618127,{"$f":"SUM(C18*1.08)","v":26103.115302595193},null,62,65190.143296032998,59974.931832350361,70405.354759715643]
[null,13,24653.96943615505,{"$f":"SUM(C19*0.92)","v":22681.651881262645},26626.286991047455,null,63,66496.71674304374,61176.979403600242,71816.454082487238]
[null,14,{"$f":"SUM(C19*$B$2)","v":25148.096618579188},23136.248889092854,27159.944348065525,null,64,67829.477188366189,62403.119013296899,73255.835363435486]
[null,15,{"$f":"SUM(C20*$B$2)","v":25652.127345057059},23599.957157452496,27704.297532661625,null,65,69188.949484914017,63653.833526120899,74724.06544370715]
[null,16,26166.260107370363,24072.959298780734,28259.560915959995,null,66,70575.669004965399,64929.615484568167,76221.722525362638]
[null,17,26690.697375572334,24555.441585526547,28825.953165618121,null,67,71990.181850997411,66230.967302917619,77749.396399077203]
[null,18,27225.645677722241,25047.594023504462,29403.697331940024,null,68,73433.045070746026,67558.401465086354,79307.688676405713]
[null,19,27771.315681217988,25549.610426720548,29993.020935715427,null,69,74904.826876576451,68912.440726450339,80897.213026702579]
[null,20,28327.9222757588,26061.688493698097,30594.156057819506,null,70,76406.10686925023,70293.618319710222,82518.595418790253]
[null,21,28895.684657970694,26584.029885333039,31207.339430608354,null,71,77937.476266177182,71702.47816488301,84172.474367471368]
[null,22,29474.826417728073,27116.84030430983,31832.812531146319,null,72,79499.53813424203,73139.57508350267,85859.501184981404]
[null,23,30065.575626205387,27660.329576108958,32470.821676301821,null,73,81092.907627297565,74605.475017113757,87580.340237481374]
[null,24,30668.164925693607,28214.711731638119,33121.618119749095,null,74,82718.212228417673,76100.75525014427,89335.669206691091]
[null,25,31282.831621216821,28780.205091519478,33785.458150914172,null,75,84376.091997005729,77626.004637245278,91126.179356766195]
[null,26,31909.817773985058,29357.032352066253,34462.603195903866,null,76,86067.19982085572,79181.823835187271,92952.575806524183]
[null,27,32549.370296720153,29945.420672982542,35153.319920457769,null,77,87792.201673265212,80768.825539404002,94815.577807126436]
[null,28,33201.741050892168,30545.601766820797,35857.880334963542,null,78,89551.776875301628,82387.634725277501,96715.919025325769]
[null,29,33867.186945904672,31157.811990232298,36576.56190157705,null,79,91346.618363324858,84038.888894258867,98654.347832390849]
[null,30,34545.970040267966,31782.29243704653,37309.647643489407,null,80,93177.432961871789,85723.238324922044,100631.62759882153]
[null,31,35238.357644800039,32419.289033216039,38057.426256384046,null,81,95044.941662010096,87441.346329049295,102648.53699497091]
[null,32,35944.622427895942,33069.052633664265,38820.192222127618,null,82,96949.879905270936,89193.889512849259,104705.87029769261]
[null,33,36665.042522907046,33731.839121074481,39598.245924739611,null,83,98892.997873272325,90981.558043410536,106804.43770313411]
[null,34,37399.90163767241,34407.909506658616,40391.893768686205,null,84,100875.06078314738,92805.055920495593,108945.06564579917]
[null,35,38149.489166245461,35097.530032945826,41201.448299545104,null,85,102896.8491888936,94665.101253782108,111128.59712400509]
[null,36,38914.100302859937,35800.972278631147,42027.228327088735,null,86,104959.15928876199,96562.42654566103,113355.89203186295]
[null,37,39694.036158180003,36518.513265525602,42869.559050834403,null,87,107062.803238807,98497.778979702445,115627.82749791157]
[null,38,40489.603877880327,37250.435567649904,43728.772188110757,null,88,109208.60947272078,100471.92071490313,117945.29823053845]
[null,39,41301.116763602739,37997.027422514519,44605.206104690958,null,89,111397.42302807778,102485.62918583157,120309.21687032402]
[null,40,42128.894396337244,38758.582844630269,45499.205948044226,null,90,113630.10587911803,104539.69740878859,122720.51434944748]
[null,41,42973.26276227583,39535.401741293768,46411.123783257899,null,91,115907.53727620025,106634.93429410424,125180.14025829628]
[null,42,43834.55438118874,40327.790030693643,47341.318731683845,null,92,118230.61409205849,108772.16496469382,127689.06321942317]
[null,43,44713.10843737371,41136.059762383818,48290.157112363609,null,93,120600.25117499857,110952.2310809987,130248.27126899846]
[null,44,45609.270913229768,41960.529240171389,49258.012586288154,null,94,123017.38170917348,113175.99117243961,132858.77224590737]
[null,45,46523.394725508173,42801.523147467524,50245.266303548829,null,95,125482.95758207959,115444.32097551323,135521.59418864598]
[null,46,47455.839864294168,43659.37267515064,51252.307053437704,null,96,127997.94975941841,117758.11377866493,138237.78574017188]
[null,47,48406.973534774283,44534.415651992342,52279.531417556231,null,97,130563.34866747154,120118.28077407382,{"$f":"SUM(H53*1.08)","v":141008.41656086926}]
[null,48,49377.170301844992,45426.996677697396,53327.343925992594,null,98,133180.16458313933,122525.75141648819,{"$f":"SUM(H54*1.08)","v":143834.57774979048}]
[null,49,50366.812237619721,46337.467258610144,54396.157216629304,null,99,135849.42803179688,124981.47378925314,{"$f":"SUM(H55*1.08)","v":146717.38227434063}]
[null,50,51376.289071892214,47266.185946140838,55486.392197643596,"  GS15/10",100,138572.19019312417,127486.41497767424,{"$f":"SUM(H56*1.08)","v":149657.96540857412}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,34099,34099,34099]
[null,2,69951,52341,47264]
[null,3,99691,69951,63661]
[null,4,138572,99691]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2019 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$19,048-$34,099\n(GS 1-4)","II\n$29,350-$69,951\n(GS 5-11)","III\n$64,490-$99,691\n(GS 12-13)","IV\n$90,621-$138,572\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$19,048-$34,099\n(GS 1-4)","II\n$29,350-$52,341\n(GS 5-8)","III\n$44,471-$69,951\n(GS 9-11)","IV\n$64,490-$99,691\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$19,048-$34,099\n(GS 1-4)","II\n$29,350-$47,264\n(GS 5-7)","III\n$40,263-$63,661\n(GS 8-10)","2019 Broadband\nScale\n(w/o Locality Pay)"]