{"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,"2023 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200428699999999,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=",20999,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":152771},{"$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":75},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":78.64562541321267},{"$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":82}]
[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 2023"]
[15442,{"$f":"slope","v":1.0200428699999999},null,"(Based on 4.1% 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,20999,{"$f":"SUM(C6*0.92)","v":19319.080000000002},{"$f":"SUM(C6*1.08)","v":22678.920000000002}]
[null,1,{"$f":"SUM(C6*$B$2)","v":21419.880227129997},{"$f":"SUM(C7*0.92)","v":19706.289808959598},{"$f":"SUM(C7*1.08)","v":23133.4706453004},null,51,{"$f":"SUM(C56*$B$2)","v":57774.775165728293},{"$f":"SUM(H7*0.92)","v":53152.793152470033},{"$f":"SUM(H7*1.08)","v":62396.757178986561}]
[null,2,{"$f":"SUM(C7*$B$2)","v":21849.196101937934},{"$f":"SUM(C8*0.92)","v":20101.2604137829},{"$f":"SUM(C8*1.08)","v":23597.131790092972},null,52,{"$f":"SUM(H7*$B$2)","v":58932.747473654214},54218.127675761876,63647.367271546558]
[null,3,22287.116699013583,20504.147363092496,24070.086034934669,null,53,{"$f":"SUM(H8*$B$2)","v":60113.928870011492},55304.814560410574,64923.043179612418]
[null,4,22733.814481686739,20915.109323151799,24552.519640221679,null,54,61318.784531542376,56413.281769018991,66224.287294065769]
[null,5,23189.465369947302,21334.308140351517,{"$f":"SUM(C11*1.08)","v":25044.622599543087},null,55,62547.788958466088,57543.965841788806,67551.612075143377]
[null,6,23654.248809726658,21761.908904948526,25546.588714504793,null,56,63801.426161348056,58697.312068440217,68905.540254255902]
[null,7,24128.347843567662,22198.080016082251,26058.615671053078,null,57,65080.189851714553,59873.774663577395,70286.605039851725]
[null,8,24611.949182711069,22642.993248094182,26580.905117327955,null,58,66384.583636487776,61073.816945568753,71695.350327406806]
[null,9,25105.24328062675,23096.82381817661,27113.662743076893,null,59,67715.121216318017,62297.911519012581,73132.33091362346]
[null,10,25608.424408018724,23559.750455377227,27657.098360660224,null,60,69072.326587890915,63546.540460859644,74598.112714922187]
[null,11,26121.69072933347,24031.955470986792,28211.425987680148,null,61,70456.734250289548,64820.195510266385,76093.272990312718]
[null,12,26645.244380801705,24513.624830337569,{"$f":"SUM(C18*1.08)","v":28776.863931265845},null,62,71868.889415492638,66119.378262253231,77618.40056873206]
[null,13,27179.291550044341,{"$f":"SUM(C19*0.92)","v":25004.948226040797},29353.63487404789,null,63,73309.348223091729,67444.600365244391,79174.096080939067]
[null,14,{"$f":"SUM(C19*$B$2)","v":27724.042557273977},25506.119152692059,29941.965961855898,null,64,74778.677959311884,68796.383722566941,80760.972196056842]
[null,15,{"$f":"SUM(C20*$B$2)","v":28279.711938123884},26017.334983073975,30542.088893173797,null,65,76277.457280422226,70175.260697988444,82379.653862856008]
[null,16,28846.518528137149,26538.797045886178,31154.240010388123,null,66,77806.276440624279,71581.774325374339,84030.778555874233]
[null,17,29424.68554894919,27070.710705033256,31778.660392865128,null,67,79365.737524507771,73016.478522547157,85714.9965264684]
[null,18,30014.440696197657,27613.285440501844,32415.595951893472,null,68,80956.454684165597,74479.938309432357,87432.971058898853]
[null,19,30616.016229194254,28166.734930858715,33065.297527529794,null,69,82579.054381061214,75972.73003057632,89185.378731546123]
[null,20,31229.649062393884,28731.277137402376,33728.020987385396,null,70,{"$f":"SUM(H25*$B$2)","v":84234.175632743747},77495.441582124244,90972.90968336325]
[null,21,31855.580858697063,29307.134390001298,34404.027327392832,null,71,85922.470264507996,79048.672643347367,92796.26788566864]
[null,22,32494.058124622414,29894.53347465262,35093.582774592207,null,72,87644.603166098386,80633.034912810515,94656.171419386257]
[null,23,33145.332307386663,30493.70572279573,35796.9588919776,null,73,89401.252553558079,82249.152349273441,96553.352757842731]
[null,24,33809.659893930409,31104.887102415978,36514.432685444845,null,74,91193.110236326203,83897.66141742011,98488.559055232312]
[null,25,34487.302511928669,31728.318310974377,37246.286712882968,null,75,93020.88188968855,85579.211338513473,100462.55244086364]
[null,26,35178.527032825928,32364.244870199855,37992.809195452006,null,76,94885.287332688924,87294.464346073815,102476.11031930405]
[null,27,35883.605676936342,33012.917222781434,38754.29413109125,null,77,96787.060811610645,89044.095946681802,104530.0256765395]
[null,28,36602.816120650437,33674.590830998401,39531.041410302474,null,78,98726.951289139848,90828.795186008661,106625.10739227105]
[null,29,37336.441605790533,34349.526277327292,40323.356934253781,null,79,100705.72273932441,92649.264920178466,108762.18055847037]
[null,30,38084.771051157979,35037.98936706534,41131.552735250618,null,80,102724.15444844472,94506.222092569151,110942.08680432031]
[null,31,38848.099166316097,35740.251233010807,41955.947099621386,null,81,104783.04132191482,96400.398016161635,113165.68462766802]
[null,32,39626.726567653677,36456.588442241387,42796.864693065974,null,82,106883.19419733458,98332.53866154782,115433.84973312136]
[null,33,40420.959896774701,37187.28310503273,43654.636688516679,null,83,109025.4401638165,100303.40495071118,117747.47537692182]
[null,34,41231.11194126097,37932.622985960094,44529.600896561853,null,84,111210.62288771264,102313.77305669563,120107.47271872967]
[null,35,42057.501757855105,38692.9016172267,45422.101898483517,null,85,113439.60294487009,104364.43470928048,122514.77118045971]
[null,36,42900.454798112565,39468.418414263564,46332.491181961574,null,86,115713.25815954573,106456.19750678207,124970.3188123094]
[null,37,43760.303036572011,40259.478793646253,47261.127279497778,null,87,118032.48395011394,108589.88523410482,127475.08266612305]
[null,38,44637.385101494627,41066.394293375059,48208.375909614202,null,88,120398.19368170315,110766.33818716691,130030.04917623941]
[null,39,45532.046408223818,41889.482695565915,49174.610120881727,null,89,122811.31902590035,112986.41350382833,132636.22454797238]
[null,40,46444.639295217814,42729.06815160039,50160.210438835245,null,90,125272.81032766498,115250.98550145178,135294.63515387819]
[null,41,47375.523162808757,43585.48130978406,51165.565015833461,null,91,127783.63697959701,117560.94602122925,138006.32793796479]
[null,42,48325.064614742922,44459.059445563493,52191.069783922358,null,92,{"$f":"SUM(H47*$B$2)","v":130344.78780370626},119917.20477940976,{"$f":"SUM(H48*1.08)","v":140772.37082800278}]
[null,43,49293.637602557814,45350.146594353188,53237.12861076244,null,93,132957.27144083352,122320.68972556684,143593.8531561002]
[null,44,50281.623572852986,46259.093687024746,54304.153458681227,null,94,135622.11674787683,124772.3474080467,146471.88608770698]
[null,45,51289.411617512611,47186.258688111608,55392.564546913622,null,95,138340.37320297933,127273.143346741,149407.60305921768]
[null,46,52317.398626938906,48132.006736783798,56502.790517094021,null,96,141113.11131883811,129824.06241333106,152402.16022434516]
[null,47,53365.98944635682,49096.710290648276,57635.268602065371,null,97,143941.42306429709,132426.10921915332,{"$f":"SUM(H53*1.08)","v":155456.73690944086}]
[null,48,54435.597035251521,50080.7492724314,58790.44479807165,null,98,146826.42229438981,135080.30851083863,{"$f":"SUM(H54*1.08)","v":158572.53607794101}]
[null,49,55526.64263000145,51084.511219601336,59968.774040401571,null,99,149769.24518900135,137787.70557388125,{"$f":"SUM(H55*1.08)","v":161750.78480412147}]
[null,50,56639.555909771021,52108.391436989339,61170.72038255271,"  GS15/10",100,152771.05070032261,140549.3666442968,{"$f":"SUM(H56*1.08)","v":164992.73475634842}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,37597,37597,37597]
[null,2,77112,57709,52106]
[null,3,109908,77112,70190]
[null,4,152771,109908]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2023 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$20,999-$37,597\n(GS 1-4)","II\n$32,357-$77,172\n(GS 5-11)","III\n$71,099-$109,908\n(GS 12-13)","IV\n$99,908-$152,771\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$20,999-$37,597\n(GS 1-4)","II\n$32,357-$57,709\n(GS 5-8)","III\n$49,028-$77,112\n(GS 9-11)","IV\n$71,099-$109,908\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$20,999-$37,597\n(GS 1-4)","II\n$32,357-$52,106\n(GS 5-7)","III\n$44,389-$70,190\n(GS 8-10)","2023 Broadband\nScale\n(w/o Locality Pay)"]