{"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,"2024 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200427700000001,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=",21986,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":159950},{"$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":73},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":76.331471574676115},{"$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":80}]
[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 2024"]
[15442,{"$f":"slope","v":1.0200427700000001},null,"(Based on 4.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,21986,{"$f":"SUM(C6*0.92)","v":20227.120000000003},{"$f":"SUM(C6*1.08)","v":23744.880000000001}]
[null,1,{"$f":"SUM(C6*$B$2)","v":22426.660341220002},{"$f":"SUM(C7*0.92)","v":20632.527513922403},{"$f":"SUM(C7*1.08)","v":24220.793168517604},null,51,{"$f":"SUM(C56*$B$2)","v":60490.016471982897},{"$f":"SUM(H7*0.92)","v":55650.81515422427},{"$f":"SUM(H7*1.08)","v":65329.217789741531}]
[null,2,{"$f":"SUM(C7*$B$2)","v":22876.152736307198},{"$f":"SUM(C8*0.92)","v":21046.060517402624},{"$f":"SUM(C8*1.08)","v":24706.244955211776},null,52,{"$f":"SUM(H7*$B$2)","v":61702.403959427065},56766.211642672904,66638.596276181241]
[null,3,23334.654204085877,21467.881867759006,25201.426540412747,null,53,{"$f":"SUM(H8*$B$2)","v":62939.091050432959},57903.963766398323,67974.218334467601]
[null,4,23802.345311327907,21898.157686421677,25706.53293623414,null,54,64200.564776365849,59064.519594256584,69336.609958475121]
[null,5,24279.410243863433,22337.05742435436,{"$f":"SUM(C11*1.08)","v":26221.763063372509},null,55,65487.32193004866,60248.33617564477,70726.307684452564]
[null,6,24766.036879116833,22784.753928787486,26747.31982944618,null,56,66799.869261408588,61455.879720495905,72143.85880232128]
[null,7,25262.416860096491,23241.423511288773,27283.410208904214,null,57,68138.723677045084,62687.625782881478,73589.821571208697]
[null,8,25768.745670867531,23707.246017198129,27830.245324536936,null,58,69504.412443797657,63944.059448293847,75064.765439301467]
[null,9,26285.222713537227,24182.404896454249,28388.040530620208,null,59,70897.473396393834,65225.67552468233,76569.271268105353]
[null,10,26812.051386783431,24667.087275840757,28957.015497726108,null,60,72318.45514925888,66532.978737318175,78103.931561199599]
[null,11,27349.439165956916,25161.484032680364,29537.394299233471,null,61,73767.917312570804,67866.483927565147,79669.350697576476]
[null,12,27897.597684789183,25665.78987000605,{"$f":"SUM(C18*1.08)","v":30129.40549957232},null,62,75246.430712645684,69226.716255634034,81266.145169657349]
[null,13,28456.742818737948,{"$f":"SUM(C19*0.92)","v":26180.203393238913},30733.282244236987,null,63,76754.577616740178,70614.211407400973,82894.943826079398]
[null,14,{"$f":"SUM(C19*$B$2)","v":29027.094770003067},26704.927188402824,31349.262351603313,null,64,78292.951962359657,72029.515805370887,84556.388119348441]
[null,15,{"$f":"SUM(C20*$B$2)","v":29608.878154246442},27240.167901906727,31977.588406586161,null,65,79862.159591162286,73473.186823869313,86251.132358455274]
[null,16,30202.322089050031,27786.136321926031,32618.507856174034,null,66,81462.818487551252,74945.79300854716,87979.84396655536]
[null,17,30807.660284146783,28343.047461415041,33272.273106878529,null,67,83095.559022048998,76447.914300285076,89743.203743812919]
[null,18,31425.131133460076,28911.120642783269,33939.141624136886,null,68,84761.024199549356,77980.142263585411,91541.906135513316]
[null,19,32054.97780898786,29490.579584268831,34619.376033706889,null,69,86459.869912545371,79543.080319541739,93376.659505549003]
[null,20,32697.448356568511,30081.652488043033,35313.244225093993,null,70,{"$f":"SUM(H25*$B$2)","v":88192.765199432441},81137.343983477855,95248.186415387041]
[null,21,33352.795793566096,30684.572130080811,36021.019457051385,null,71,89960.392507988683,82763.561107349597,97157.223908627784]
[null,22,34021.278208513511,31299.57595183243,36742.980465194596,null,72,91763.447964136038,84422.372127005161,99104.523801266929]
[null,23,34703.15886275276,31926.90615373254,37479.41157177298,null,73,93602.641646088188,86114.430314401136,101090.85297777526]
[null,24,35398.70629411238,32566.809790583393,38230.602797641375,null,74,95478.697863993162,87840.40203487371,103116.99369311263]
[null,25,36108.194422662833,33219.538868849806,38996.84997647586,null,75,97392.355445180685,89600.96700956623,105183.74388079514]
[null,26,36831.902658591549,33885.350445904223,39778.454871278875,null,76,99344.368025126692,91396.818583116561,107291.91746713684]
[null,27,37570.116012240091,34564.506731260888,40575.725293219301,null,77,101335.50434424967,93228.6639967097,109442.34469178965]
[null,28,38323.12520634674,35257.275189839005,41388.975222854482,null,78,103366.54855065547,95097.224666603041,111635.87243470791]
[null,29,39091.226790538756,35963.928647295659,42218.52493378186,null,79,105438.30050895009,97003.236468234085,113873.3645496661]
[null,30,39874.723258119368,36684.745397469822,43064.70111876892,null,80,107551.57611524187,98947.450026022532,116155.70220446122]
[null,31,40673.923165195505,37420.009311979869,43927.837018411148,null,81,109707.20761845716,100930.63100898059,118483.78422793375]
[null,32,41489.141252193192,38170.009952017739,44808.272552368653,null,82,111906.04394809616,102953.56043224847,120858.52746394387]
[null,33,42320.698567808417,38935.042682383748,45706.354453233092,null,83,114148.95104855776,105017.03496467315,123280.86713244239]
[null,34,43168.922595442331,39715.408787806948,46622.436403077721,null,84,116436.81222016527,107121.86724255205,125751.7571977785]
[null,35,44034.147382170588,40511.415591596946,47556.879172744237,null,85,118770.52846702725,109268.88618966508,128272.17074438944]
[null,36,44916.71367029754,41323.376576673742,48510.050763921347,null,86,121151.01885187035,111458.93734372073,130843.10036001999]
[null,37,45816.969031547174,42151.611509023402,49482.326554070954,null,87,123579.22085798407,113692.88318934535,133465.5585266228]
[null,38,46735.268003943602,42996.446563628117,50474.089444259094,null,88,126056.09075841986,115971.60349774627,136140.57801909346]
[null,39,47671.972231435007,43858.214452920212,51485.73000994981,null,89,128582.60399259001,118295.99567318281,138869.21231199722]
[null,40,48627.450606316052,44737.254557810767,52517.646654821336,null,90,131159.75555041459,120666.97510638142,141652.53599444777]
[null,41,49602.079414504813,45633.913061344429,53570.245767665205,null,91,133788.56036416779,123085.47553503438,144491.64519330123]
[null,42,50596.242483731476,46548.543085032958,54643.941882429994,null,92,{"$f":"SUM(H47*$B$2)","v":136470.05370817793},125552.4494115237,{"$f":"SUM(H48*1.08)","v":147387.65800483216}]
[null,43,51610.331334697141,47481.504827921373,55739.157841472916,null,93,139205.29160653861,128068.86827801552,150341.7149350617]
[null,44,52644.745335262276,48433.165708441295,56856.324962083265,null,94,141995.35124899141,130635.7231490721,153354.97934891074]
[null,45,53699.891857725517,49403.90050910748,57995.883206343562,null,95,144841.33141514417,133254.02490193266,156428.63792835572]
[null,46,54776.186439254787,50394.091524114403,59158.281354395171,null,96,147744.3529071917,135924.80467461637,159563.90113976705]
[null,47,55874.052945533898,51404.128709891185,60343.977181176611,null,97,150705.5589913094,138649.11427200466,{"$f":"SUM(H53*1.08)","v":162762.00371061417}]
[null,48,56993.92373768906,52434.409838673935,61553.437636704191,null,98,153726.11584789367,141428.02658006217,{"$f":"SUM(H54*1.08)","v":166024.20511572517}]
[null,49,58136.23984256111,53485.340655156222,62787.139029966005,null,99,156807.21303082639,144262.63598836027,{"$f":"SUM(H55*1.08)","v":169351.7900732925}]
[null,50,59301.451126390406,54557.335036279175,64045.567216501644,"  GS15/10",100,159950.06393594426,147154.05882106873,{"$f":"SUM(H56*1.08)","v":172746.06905081982}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,39361,39361,39361]
[null,2,80737,60416,54557]
[null,3,115079,80737,73484]
[null,4,159950,115079]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2024 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$21,986-$39,361\n(GS 1-4)","II\n$33,878-$80,737\n(GS 5-11)","III\n$74,441-$115,079\n(GS 12-13)","IV\n$104,604-$159,950\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$21,986-$39,361\n(GS 1-4)","II\n$33,878-$60,416\n(GS 5-8)","III\n$51,332-$80,737\n(GS 9-11)","IV\n$74,441-$115,079\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$21,986-$39,361\n(GS 1-4)","II\n$33,878-$54,557\n(GS 5-7)","III\n$46,475-$73,484\n(GS 8-10)","2024 Broadband\nScale\n(w/o Locality Pay)"]