{"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":16,"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,"2025 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200428399999999,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=",22360,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":162672},{"$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":72},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":75.481216246481438},{"$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":79}]
[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 2025"]
[15442,{"$f":"slope","v":1.0200428399999999},null,"(Based on 1.7% 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,22360,{"$f":"SUM(C6*0.92)","v":20571.2},{"$f":"SUM(C6*1.08)","v":24148.800000000003}]
[null,1,{"$f":"SUM(C6*$B$2)","v":22808.157902399998},{"$f":"SUM(C7*0.92)","v":20983.505270207999},{"$f":"SUM(C7*1.08)","v":24632.810534592001},null,51,{"$f":"SUM(C56*$B$2)","v":61519.216868545489},{"$f":"SUM(H7*0.92)","v":56597.67951906185},{"$f":"SUM(H7*1.08)","v":66440.754218029135}]
[null,2,{"$f":"SUM(C7*$B$2)","v":23265.298161932536},{"$f":"SUM(C8*0.92)","v":21404.074308977935},{"$f":"SUM(C8*1.08)","v":25126.522014887141},null,52,{"$f":"SUM(H7*$B$2)","v":62752.236689167039},57732.057754033682,67772.415624300411]
[null,3,23731.600810544442,21833.072745700887,25630.128875388,null,53,{"$f":"SUM(H8*$B$2)","v":64009.969728770135},58889.172150468527,69130.767307071743]
[null,4,24207.249488534053,22270.66952945133,26143.829447616779,null,54,65292.911310448711,60069.478405612819,70516.344215284611]
[null,5,24692.431516872821,22717.036995522994,{"$f":"SUM(C11*1.08)","v":26667.826038222647},null,55,66601.566684978214,61273.441350179957,71929.69201977647]
[null,6,25187.337970976456,23172.350933298341,27202.325008654574,null,56,67936.451229794562,62501.535131411001,73371.367328178138]
[null,7,25692.163755954658,23636.790655478286,27747.536856431034,null,57,69298.090651961131,63754.24339980424,74841.937904118022]
[null,8,26207.107683369053,24110.539068699531,28303.676298038579,null,58,70687.021195203881,65032.059499587573,76341.982890820203]
[null,9,26732.372549529588,24593.782745567223,28870.962353491956,null,59,72103.789851095949,66335.486663008283,77872.09303918363]
[null,10,27268.165215360197,25086.711998131381,29449.618432589014,null,60,73548.954574475079,67665.038208517071,79432.870940433088]
[null,11,27814.696687865224,25589.520952836006,30039.872422894445,null,61,75023.084503178543,69021.237742924262,81024.931263432838]
[null,12,28372.182203228633,26102.407626970344,{"$f":"SUM(C18*1.08)","v":30641.956779486925},null,62,76526.760182182217,70404.619367607636,82648.900996756798]
[null,13,28940.841311578788,{"$f":"SUM(C19*0.92)","v":26625.574006652485},31256.108616505095,null,63,78060.573792232055,71815.727888853493,84305.419695610632]
[null,14,{"$f":"SUM(C19*$B$2)","v":29520.897963452149},27159.226126375979,31882.569800528323,null,64,79625.129383057953,73255.11903241332,85995.139733702599]
[null,15,{"$f":"SUM(C20*$B$2)","v":30112.580597989945},27703.574150150751,32521.587045829143,null,65,81221.043111261868,74723.359662360919,87718.726560162817]
[null,16,30716.122232902559,28258.832454270356,33173.412011534769,null,66,82848.943482973977,76221.028004336069,89476.858961611899]
[null,17,31331.760556237063,28825.2197117381,33838.301400736033,null,67,84509.471601372265,77748.713873262488,91270.229329482056]
[null,18,31959.73801998403,29402.958978385308,34516.517061582752,null,68,86203.281419163104,79307.018905630059,93099.543932696164]
[null,19,32600.301935560485,29992.277780715649,35208.326090405324,null,69,87931.039996122359,80896.556796432575,94965.523195812159]
[null,20,33253.70457120661,30593.408205510084,35914.00093690314,null,70,{"$f":"SUM(H25*$B$2)","v":89693.42776179823},82517.953540854374,96868.9019827421]
[null,21,33920.203251334569,31206.586991227807,36633.819511441339,null,71,91491.138783479502,84171.847680801147,98810.429886157872]
[null,22,34600.060457868545,31832.055621239062,37368.065294498032,null,72,93324.881039534564,85858.8905563718,100790.87152269733]
[null,23,35293.543933615925,32470.060418926652,38117.027448305205,null,73,95195.376698228982,87579.746562370667,102811.00683408731]
[null,24,36000.926787710356,33120.852644693528,38881.00093072719,null,74,97103.362402131301,89335.093409960798,104871.63139430182]
[null,25,36722.487603168142,33784.688594914689,39660.286611421594,null,75,99049.589558219217,91125.622393561687,106973.55672287676]
[null,26,37458.510546600417,34461.829702872383,40455.191390328451,null,76,101034.82463380026,92952.038663096246,109117.6106045043]
[null,27,38209.285480124236,35152.542641714295,41266.028318534176,null,77,103059.84945836358,94815.061501694494,111304.63741503267]
[null,28,38975.108075516684,35857.099429475347,42093.116721558021,null,78,105125.46153148163,96715.424608963105,113535.49845400018]
[null,29,39756.279930656972,36575.777536204419,42936.782325109532,null,79,107232.47433688326,98653.8763899326,115811.07228383393]
[null,30,40553.108688302338,37308.859993238155,43797.357383366529,null,80,109381.71766282151,100631.1802497958,118132.25507584724]
[null,31,41365.908157244587,38056.635504665021,44675.18080982416,null,81,111574.0379288626,102648.1148945536,120499.96096317162]
[null,32,42194.99843589493,38819.398561023336,45570.598310766523,null,82,113810.29851922471,104705.47463768674,122915.1224007627]
[null,33,43040.706038345816,39597.449555278152,46483.962521413487,null,83,116091.38012279777,106804.06971297396,125378.69053262159]
[null,34,43903.364022959409,40391.094901122655,47415.633144796164,null,84,118418.18107997817,108944.72659357992,127891.63556637643]
[null,35,44783.312123533338,41200.647153650672,48365.977093416011,null,85,120791.61773645518,111128.28831753877,130454.94715537161]
[null,36,45680.896883095375,42026.425132447745,49335.368633743004,null,86,123212.6248040881,113355.61481976106,133069.63478841516]
[null,37,46596.47179037975,42868.75404714937,50324.18953361013,null,87,125682.15572901646,115627.58327069515,135736.72818733778]
[null,38,47530.39741903884,43727.965625515732,51332.829212561948,null,88,128201.18306714822,117945.08842177637,138457.2777125201]
[null,39,48483.041569645044,44604.39824407344,52361.684895216647,null,89,130770.69886717376,120309.04295779987,141232.35477654767]
[null,40,49454.779414538782,45498.397061375683,53411.161767701888,null,90,133391.71506125669,122720.37785635616,144063.05226615723]
[null,41,50445.993645579671,46410.314153933301,54481.673137226047,null,91,136065.26386355504,125180.04275447065,146950.48497263945]
[null,42,51457.074624859037,47340.508654870318,55573.640594847762,null,92,{"$f":"SUM(H47*$B$2)","v":138792.39817673003},127689.00632259164,{"$f":"SUM(H48*1.08)","v":149895.79003086843}]
[null,43,52488.420538433144,48289.346895358496,56687.494181507798,null,93,141574.1920066025,130248.25664607431,152900.12736713071]
[null,44,53540.437553137665,49257.202548886657,57823.67255738868,null,94,144411.74088512009,132858.80161431048,155964.6801559297]
[null,45,54613.539976545188,50244.456778421576,58982.623174668806,null,95,147306.16230180199,135521.66931765783,159090.65528594615]
[null,46,55708.150420128681,51251.498386518389,60164.802453738979,null,96,150258.59614383103,138237.90845232457,162279.28383533753]
[null,47,56824.699965695247,52278.723968439626,61370.675962950867,null,97,153270.20514496643,141008.58873336911,{"$f":"SUM(H53*1.08)","v":165531.82155656375}]
[null,48,57963.628335155678,53326.538068343223,62600.718601968139,null,98,156342.17534345415,143834.80131597782,{"$f":"SUM(H54*1.08)","v":168849.5493709305}]
[null,49,59125.384063696663,54395.353338600929,63855.414788792397,null,99,159475.71654911494,146717.65922518575,{"$f":"SUM(H55*1.08)","v":172233.77387304415}]
[null,50,60310.424676423878,55485.590702309972,65135.258650537791,"  GS15/10",100,162672.06281979417,149658.29779421064,{"$f":"SUM(H56*1.08)","v":175685.8278453777}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,40038,40038,40038]
[null,2,82108,61449,55486]
[null,3,117034,82108,74733]
[null,4,162672,117034]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2025 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$22,360-$40,038\n(GS 1-4)","II\n$34,454-$82,108\n(GS 5-11)","III\n$75,706-$117,034\n(GS 12-13)","IV\n$106,382-$162,672\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$22,360-$40,038\n(GS 1-4)","II\n$34,454-$61,449\n(GS 5-8)","III\n$52,205-$82,108\n(GS 9-11)","IV\n$75,706-$117,034\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$22,360-$40,038\n(GS 1-4)","II\n$34,454-$55,486\n(GS 5-7)","III\n$47,265-$74,733\n(GS 8-10)","2025 Broadband\nScale\n(w/o Locality Pay)"]