{"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,"2021 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.02004294,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=",19738,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":143598},{"$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":78},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":81.766037033368534},{"$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":85}]
[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 2021"]
[15442,{"$f":"slope","v":1.02004294},null,"(Based on 1.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,19738,{"$f":"SUM(C6*0.92)","v":18158.96},{"$f":"SUM(C6*1.08)","v":21317.040000000001}]
[null,1,{"$f":"SUM(C6*$B$2)","v":20133.60754972},{"$f":"SUM(C7*0.92)","v":18522.9189457424},{"$f":"SUM(C7*1.08)","v":21744.2961536976},null,51,{"$f":"SUM(C56*$B$2)","v":54305.56232749379},{"$f":"SUM(H7*0.92)","v":49961.117341294288},{"$f":"SUM(H7*1.08)","v":58650.007313693299}]
[null,2,{"$f":"SUM(C7*$B$2)","v":20537.144237822584},{"$f":"SUM(C8*0.92)","v":18894.172698796778},{"$f":"SUM(C8*1.08)","v":22180.115776848394},null,52,{"$f":"SUM(H7*$B$2)","v":55394.005454890008},50962.48501849881,59825.525891281213]
[null,3,20948.768987552608,19272.8674685484,22624.67050655682,null,53,{"$f":"SUM(H8*$B$2)","v":56504.264182582039},51983.923047975477,61024.605317188609]
[null,4,21368.643907443984,19659.152394848465,23078.135420039504,null,54,57636.775759337681,53025.833698590672,62247.717820084697]
[null,5,21796.934355162248,20053.179606749269,23540.689103575231,null,55,58791.986197675535,54088.627301861496,63495.345093489581]
[null,6,22233.809002626702,20455.104282416567,24012.51372283684,null,56,59970.350449516372,55172.722413555064,64767.978485477688]
[null,7,22679.439902437807,20865.084710242783,24493.795094632835,null,57,61172.332585354998,56278.545978526599,66066.119192183396]
[null,8,23134.002555635972,21283.282351185095,24984.72276008685,null,58,62398.405977023307,57406.533498861449,67390.27845518518]
[null,9,23597.675980818429,21709.861902352954,25485.490059283904,null,59,63649.053484116426,58557.129205387115,68740.977762845738]
[null,10,24070.642784641412,22144.991361870099,25996.294207412728,null,60,64924.767644155363,59730.786232622937,70118.749055687804]
[null,11,24553.089233735413,22588.84209503658,26517.336372434249,null,61,66226.050866561112,60927.966797236229,71524.134935886002]
[null,12,25045.205328061817,23041.588901816871,{"$f":"SUM(C18*1.08)","v":27048.821754306762},null,62,67553.415630516538,62149.142380075216,72957.688880957867]
[null,13,25547.18487573984,{"$f":"SUM(C19*0.92)","v":23503.410085680654},27590.95966579903,null,63,68907.384686794045,63394.793911850524,74419.975461737573]
[null,14,{"$f":"SUM(C19*$B$2)","v":26059.2255693732},23974.487523823347,28143.963614923057,null,64,70288.49126362837,64665.411962538106,75911.570564718641]
[null,15,{"$f":"SUM(C20*$B$2)","v":26581.529063906612},24455.006738794084,28708.051389019143,null,65,71697.279276715795,65961.496934578536,77433.061618853069]
[null,16,27114.301056042746,24945.156971559329,29283.445140526168,null,66,73134.303543422255,67283.559259948481,78985.047826896043]
[null,17,27657.751365250948,25445.131256030872,29870.371474471027,null,67,74600.130001284851,68632.119601182072,80568.140401387645]
[null,18,28212.094016399591,25955.126495087625,30469.061537711561,null,68,76095.335930892805,70007.709056421387,82182.962805364237]
[null,19,28777.547324044644,26475.343538121073,31079.75110996822,null,69,77620.510183235529,71410.869368576692,83830.15099789438]
[null,20,29354.333978407631,27005.987260135022,31702.680696680243,null,70,79176.253411607497,72842.153138678899,85510.353684536109]
[null,21,29942.681133076814,27547.26664243067,32338.095623722962,null,71,80763.178308161136,74302.124043508244,87224.232572814028]
[null,22,30542.820494466203,28099.394854908907,32986.246134023502,null,72,82381.909845200906,75791.357057584843,88972.462632816983]
[null,23,31154.988413067556,28662.589340022154,33647.387486112966,null,73,84033.085521313667,77310.438679608575,90755.73236301876]
[null,24,31779.425976531362,29237.071898408853,34321.780054653871,null,74,85717.35561243222,78859.967163437643,92574.744061426798]
[null,25,32416.379104613421,29823.068776244349,35009.689432982494,null,75,87435.383427930865,80440.552753696393,94430.214102165337]
[null,26,33066.098646024438,30420.810754342485,35711.386537706399,null,76,89187.845571853875,82052.817926105563,96322.873217602188]
[null,27,33728.840477220787,31030.533239043125,36427.147715398452,null,77,90975.432209379811,83697.397632629436,98253.4667861302]
[null,28,34404.865603175291,31652.476354921269,37157.254851429316,null,78,92798.847338626467,85374.939551536358,100222.75512571659]
[null,29,35094.440260167794,32286.885039354373,37901.995480981219,null,79,94658.809067903712,87086.104342471415,102231.51379333601]
[null,30,35797.836020635921,32934.00913898505,38661.6629022868,null,80,96556.049898523153,88831.565906641306,104280.53389040501]
[null,31,36515.329900127363,33594.103508117172,39436.556292137553,null,81,98491.317013276261,90612.011652214162,106370.62237433837]
[null,32,37247.204466395822,34267.428109084161,40226.98082370749,null,82,100465.37257069434,92428.142765038792,108502.6023763499]
[null,33,37993.747950683523,34954.248114628841,41033.247786738204,null,83,102478.9940052064,94280.674484789895,110677.31352562293]
[null,34,38755.254361234191,35654.834012335457,41855.674710132931,null,84,104532.9743333131,96170.336386648065,112895.61227997816]
[null,35,39532.023599081142,36369.461711154654,42694.585487007636,null,85,106628.12246589724,98097.872668625467,115158.37226316902]
[null,36,40324.361576156109,37098.412650063619,43550.310502248598,null,86,108765.26352679386,100064.04244465036,117466.48460893738]
[null,37,41132.580335765306,37841.973908904081,44423.18676262653,null,87,110945.23917774558,102069.62004352594,119820.85831196523]
[null,38,41956.998175480228,38600.438321441812,45313.558029518652,null,88,113168.90794987077,104115.39531388112,122222.42058586044]
[null,39,42797.939772491489,39374.104590692172,46221.774954290813,null,89,115437.14558177555,106202.17393523351,124672.1172283176]
[null,40,43655.73631147515,40163.277406557143,47148.195216393164,null,90,117750.84536444234,108330.77773528696,127170.91299359774]
[null,41,44530.725615021867,40968.267565820119,48093.183664223623,null,91,120110.91849303113,110502.04501358865,129719.79197247363]
[null,42,45423.252276680214,41789.392094545801,49057.112458814634,null,92,122518.29442573184,112716.8308716733,132319.75797979039]
[null,43,46333.667796666574,42626.974372933248,50040.3612203999,null,93,124973.92124980912,114976.0075498244,134971.83494979385]
[null,44,47262.330720295089,43481.344262671482,51043.317177918703,null,94,127478.76605498376,117280.46477058507,137677.06733938248]
[null,45,48209.606779182119,44352.83823684755,52066.375321516694,null,95,130033.81531429783,119631.11008915401,140436.52053944167]
[null,46,49175.869035280855,45241.79951245839,53109.938558103328,null,96,132640.07527261338,122028.86925080432,143251.28129442246]
[null,47,50161.498027802845,46148.578185578619,54174.417870027079,null,97,135298.57234289785,124474.68655546603,{"$f":"SUM(H53*1.08)","v":146122.4581303297}]
[null,48,51166.881923084213,47073.531369237477,55260.232476930956,null,98,138010.3535104522,126969.52522961603,{"$f":"SUM(H54*1.08)","v":149051.1817912884}]
[null,49,52192.416667455669,48017.023334059217,56367.810000852129,null,99,140776.48674524098,129514.3678056217,{"$f":"SUM(H55*1.08)","v":152038.60568486026}]
[null,50,53238.506143176477,48979.425651722362,57497.586634630599,"  GS15/10",100,143598.06142248664,132110.21650868771,{"$f":"SUM(H56*1.08)","v":155085.90633628558}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,35338,35338,35338]
[null,2,72487,54242,48978]
[null,3,103309,72487,65976]
[null,4,143598,103309]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2021 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$19,738-$35,338\n(GS 1-4)","II\n$30,414-$72,487\n(GS 5-11)","III\n$66,829-$103,309\n(GS 12-13)","IV\n$93,907-$143,598\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$19,738-$35,338\n(GS 1-4)","II\n$30,414-$54,242\n(GS 5-8)","III\n$46,083-$72,487\n(GS 9-11)","IV\n$66,829-$103,309\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$19,738-$35,338\n(GS 1-4)","II\n$30,414-$48,978\n(GS 5-7)","III\n$41,723-$65,976\n(GS 8-10)","2021 Broadband\nScale\n(w/o Locality Pay)"]