{"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,"2022 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.02004304,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=",20172,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":146757},{"$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":77},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":80.669639803205172},{"$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":84}]
[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 2022"]
[15442,{"$f":"slope","v":1.02004304},null,"(Based on 2.2% 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,20172,{"$f":"SUM(C6*0.92)","v":18558.240000000002},{"$f":"SUM(C6*1.08)","v":21785.760000000002}]
[null,1,{"$f":"SUM(C6*$B$2)","v":20576.308202880002},{"$f":"SUM(C7*0.92)","v":18930.203546649602},{"$f":"SUM(C7*1.08)","v":22222.412859110402},null,51,{"$f":"SUM(C56*$B$2)","v":55499.912874256595},{"$f":"SUM(H7*0.92)","v":51059.919844316071},{"$f":"SUM(H7*1.08)","v":59939.905904197127}]
[null,2,{"$f":"SUM(C7*$B$2)","v":20988.719971242655},{"$f":"SUM(C8*0.92)","v":19309.622373543243},{"$f":"SUM(C8*1.08)","v":22667.817568942068},null,52,{"$f":"SUM(H7*$B$2)","v":56612.299847991839},52083.315860152492,61141.283835831193]
[null,3,21409.397725175069,19696.645907161066,23122.149543189076,null,53,{"$f":"SUM(H8*$B$2)","v":57746.982438337131},53127.223843270163,62366.741033404105]
[null,4,21838.507140156664,20091.426568944131,23585.587711369197,null,54,58904.407517228021,54192.054915849782,63616.760118606267]
[null,5,22276.21721230711,20494.119835322541,24058.31458929168,null,55,60085.030913272123,55278.228440210354,64891.833386333899]
[null,6,22722.70032494207,20904.884298946705,24540.516350937436,null,56,61289.317591268074,56386.172183966628,66192.462998569521]
[null,7,23178.132316462899,21323.88173114587,25032.382901779933,null,57,62517.741835322566,57516.322488496764,67519.161182148382]
[null,8,23642.692549607058,21751.277145638494,25534.107953575625,null,58,63770.787435637612,58669.124440786603,68872.450430488621]
[null,9,24116.563982086536,22187.238863519615,26045.889100653461,null,59,65048.947879041596,59845.032048718269,70252.86370936493]
[null,10,24599.933238642057,22631.938579550693,26567.927897733425,null,60,66352.726543339144,61044.508419872014,71660.944666806274]
[null,11,25092.990684541492,23085.551429778174,27100.429939304813,null,61,67682.636895556352,62268.025943911845,73097.247847200866]
[null,12,25595.930500551385,23548.256060507276,{"$f":"SUM(C18*1.08)","v":27643.604940595498},null,62,69039.202694159467,63516.066478626715,74562.338909692233]
[null,13,26108.950759411156,{"$f":"SUM(C19*0.92)","v":24020.234698658263},28197.66682016405,null,63,70422.958195326617,64789.121539700493,76056.794850952749]
[null,14,{"$f":"SUM(C19*$B$2)","v":26632.253503840064},24501.67322353286,28762.833784147271,null,64,71834.448363353877,66087.692494285569,77581.204232422198]
[null,15,{"$f":"SUM(C20*$B$2)","v":27166.044826107671},24992.761240019059,29339.328412196286,null,65,73274.229085278508,67412.290758456234,79136.167412100796]
[null,16,27710.53494919914,25493.692153263211,29927.377745135072,null,66,74742.867389803912,68763.4379986196,80722.296780988225]
[null,17,28265.938309607336,26004.66324483875,30527.213374375926,null,67,76240.941670612447,70141.666336963448,82340.217004261445]
[null,18,28832.473641784327,26525.875750441581,31139.071533127077,null,68,77769.041914154193,71547.518561021861,83990.56526728654]
[null,19,29410.364064285557,27057.534939142715,31763.193189428403,null,69,79327.769932001262,72981.548337441171,85673.991526561367]
[null,20,29999.837167640595,27599.850194229348,32399.824141051846,null,70,{"$f":"SUM(H25*$B$2)","v":80917.739597859167},74444.320430030435,87391.158765687913]
[null,21,30601.125103985101,28153.035095666295,33049.215112303915,null,71,82539.577089328639,75936.410922182346,89142.743256474932]
[null,22,31214.464678489279,28717.307504210137,33711.621852768425,null,72,84193.921134513133,77458.40744375209,90929.434825274191]
[null,23,31840.097442618826,29292.889647209322,34387.305238028333,null,73,85881.423263569028,79010.909402483507,92751.937124654549]
[null,24,32478.269789265134,29880.008206123926,35076.531372406345,null,74,87602.748065297666,80594.528220073858,94610.967910521489]
[null,25,33129.233049782168,30478.894405799594,35779.571693764745,null,75,89358.573448880357,82209.887572969936,96507.259324790793]
[null,26,33793.243592968276,31089.784105530816,36496.703080405743,null,76,91149.590910859202,83857.623637990473,98441.558183727946]
[null,27,34470.562926031882,31712.917891949332,37228.207960114436,null,77,92976.505807469191,85538.385342871654,100414.62627206673]
[null,28,35161.457797580857,32348.541173774389,37974.374421387329,null,78,94840.037632428532,87252.834621834249,102427.24064302281]
[null,29,35866.200302676079,32996.904278461996,38735.49632689017,null,79,96740.920300296799,89001.646676273056,104480.19392432056]
[null,30,36585.067989990632,33658.262550791384,39511.873429189887,null,80,98679.902435512457,90785.510240671458,106574.29463035346]
[null,31,37318.343971116738,34332.876453427401,40303.811488806081,null,81,100657.74766722354,92605.127853845654,108710.36748060143]
[null,32,38066.317032063591,35021.011669498504,41111.622394628677,null,82,102675.23493002761,94461.216135625407,110889.25372442983]
[null,33,38829.281746989924,35722.939207230731,41935.624286749124,null,83,104733.15877073955,96354.506069080395,113111.81147239872]
[null,34,39607.538594216116,36438.935506678827,42776.141681753405,null,84,106832.32966130784,98285.743288403217,115378.91603421248]
[null,35,40401.394074561533,37169.28254859661,43633.505600526456,null,85,108973.57431800262,100255.68837256241,117691.46026344283]
[null,36,41211.160832053734,37914.267965489438,44508.053698618038,null,86,111157.73602700132,102265.11714484122,120050.35490916143]
[null,37,42037.157777057022,38674.185154892461,45400.130399221584,null,87,113385.67497649994,104314.82097837995,122456.52897461994]
[null,38,42879.710211868885,39449.333394919377,46310.087028818401,null,88,115658.26859548093,106405.60710784246,124910.93008311941]
[null,39,43739.149958833783,40240.01796212708,47238.281955540486,null,89,117976.4118992709,108538.29894732923,127414.52485121258]
[null,40,44615.815491024689,41046.550251742716,48185.080730306669,null,90,120341.01784202446,110713.7364146625,129968.29926938642]
[null,41,45510.052065543918,41869.247900300405,49150.856230787431,null,91,122753.01767627288,112932.77626217106,132573.25909037472]
[null,42,46422.211859495699,42708.434910736047,50135.988808255359,null,92,{"$f":"SUM(H47*$B$2)","v":125213.36131967913},115196.2924141048,{"$f":"SUM(H48*1.08)","v":135230.43022525345}]
[null,43,47352.654108684044,43564.44177998932,51140.866437378769,null,93,127723.0177291439,117505.1763108124,137940.85914747542]
[null,44,48301.745249090563,44437.605629163321,52165.884869017813,null,94,130282.97528240984,119860.33725981705,140705.61330500263]
[null,45,49269.859061187897,45328.270336292866,53211.447786082936,null,95,132894.24216731419,122262.70279392907,143525.78154069933]
[null,46,50257.376817145647,46236.786671773996,54277.966962517305,null,96,135557.84677884335,124713.21903653588,146402.47452115081]
[null,47,51264.687430986771,47163.51243650783,55365.862425465719,null,97,138274.83812414558,127212.85107421393,{"$f":"SUM(H53*1.08)","v":149336.82517407724}]
[null,48,52292.187611753536,48108.812602813254,56475.562620693825,null,98,141046.28623566136,129762.58333680846,{"$f":"SUM(H54*1.08)","v":152329.98913451427}]
[null,49,53340.282019743419,49073.059458163945,57607.504581322894,null,99,143873.28259253417,132363.41998513145,{"$f":"SUM(H55*1.08)","v":155383.14519993693}]
[null,50,54409.383425876418,50056.632751806304,58762.134099946532,"  GS15/10",100,146756.94055046764,135016.38530643022,{"$f":"SUM(H56*1.08)","v":158497.49579450506}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,36116,36116,36116]
[null,2,74074,55430,50050]
[null,3,105579,74074,67425]
[null,4,146757,105579]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2022 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$20,172-$36,116\n(GS 1-4)","II\n$31,083-$74,074\n(GS 5-11)","III\n$68,299-$105,579\n(GS 12-13)","IV\n$95,973-$146,757\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$20,172-$36,116\n(GS 1-4)","II\n$31,083-$55,430\n(GS 5-8)","III\n$47,097-$74,074\n(GS 9-11)","IV\n$68,299-$105,579\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$20,172-$36,116\n(GS 1-4)","II\n$31,083-$50,050\n(GS 5-7)","III\n$42,641-$67,425\n(GS 8-10)","2022 Broadband\nScale\n(w/o Locality Pay)"]