{"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,"2020 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.020043,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=",19543,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":142180},{"$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":79},{"$f":"IF(ISERROR((LN($O$8)-LN(intercept))/LN(slope)),NA(),(LN($O$8)-LN(intercept))/LN(slope))","v":82.266104784293702},{"$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":86}]
[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 2020"]
[15442,{"$f":"slope","v":1.020043},null,"(Based on 2.6% 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,19543,{"$f":"SUM(C6*0.92)","v":17979.560000000001},{"$f":"SUM(C6*1.08)","v":21106.440000000002}]
[null,1,{"$f":"SUM(C6*$B$2)","v":19934.700349000002},{"$f":"SUM(C7*0.92)","v":18339.924321080001},{"$f":"SUM(C7*1.08)","v":21529.476376920004},null,51,{"$f":"SUM(C56*$B$2)","v":53769.216147415253},{"$f":"SUM(H7*0.92)","v":49467.678855622034},{"$f":"SUM(H7*1.08)","v":58070.753439208478}]
[null,2,{"$f":"SUM(C7*$B$2)","v":20334.25154809501},{"$f":"SUM(C8*0.92)","v":18707.511424247408},{"$f":"SUM(C8*1.08)","v":21960.991671942611},null,52,{"$f":"SUM(H7*$B$2)","v":54846.912546657899},50459.15954292527,59234.665550390535]
[null,3,20741.810951873478,19082.466075723602,22401.155828023358,null,53,{"$f":"SUM(H8*$B$2)","v":55946.209214830567},51470.512477644123,60421.905952017019]
[null,4,21157.53906878188,19464.935943279332,22850.142194284432,null,54,57067.539086123419,52502.13595923355,61632.942213013295]
[null,5,21581.599624337476,19855.071654390478,23308.127594284477,null,55,58211.343772026594,53554.436270264472,62868.251273788723]
[null,6,22014.159625608074,20253.02685555943,23775.292395656721,null,56,59378.073735249323,54627.82783642938,64128.319634069274]
[null,7,22455.389426984137,20658.958272825406,24251.820581142871,null,57,60568.188467124928,55722.73338975494,65413.643544494924]
[null,8,22905.462797269181,21073.025773487647,24737.899821050716,null,58,61782.156668571515,56839.584135085795,66724.729202057235]
[null,9,23364.556988114848,21495.392429065661,25233.721547164037,null,59,63020.456434679698,57978.819919905327,68062.092949454076]
[null,10,23832.852803827634,21926.224579521426,25739.481028133847,null,60,64283.575442999987,59140.889407559989,69426.261478439992]
[null,11,24310.534672574751,22365.691898768771,26255.377446380735,null,61,65572.011145604032,60326.25025395571,70817.772037252362]
[null,12,24797.790719017168,22813.967461495795,{"$f":"SUM(C18*1.08)","v":26781.613976538545},null,62,66886.270964995376,61535.369287795751,72237.172642195015]
[null,13,25294.812838398429,{"$f":"SUM(C19*0.92)","v":23271.227811326557},27318.397865470306,null,63,68226.872493946779,62768.722694431039,73685.02229346252]
[null,14,{"$f":"SUM(C19*$B$2)","v":25801.79677211845},23737.653030348974,27865.94051388793,null,64,69594.343699342964,64026.796203395526,75161.891195290402]
[null,15,{"$f":"SUM(C20*$B$2)","v":26318.942184822023},24213.426810036261,28424.457559607785,null,65,70989.22313010889,65310.085279700179,76668.360980517609]
[null,16,26846.452743032412,24698.736523589821,28994.168962475007,null,66,72412.060129305668,66619.095318961219,78205.024939650131]
[null,17,27384.536195361012,25193.773299732133,29575.299090989894,null,67,73863.415050477342,67954.341846439158,79772.488254515541]
[null,18,27933.404454324635,25698.732097978664,30168.076810670609,null,68,75343.859478334067,69316.350720067348,81371.3682366008]
[null,19,28493.273679802664,26213.811785418453,30772.735574186878,null,69,76853.976453858326,70705.658337549656,83002.294570166996]
[null,20,29064.364364166948,26739.215215033593,31389.513513300306,null,70,78394.360703923012,72122.811847609177,84665.909560236862]
[null,21,29646.901419117949,27275.149305588515,32018.653532647386,null,71,79965.618875511747,73568.369365470804,86362.868385552691]
[null,22,30241.11426426133,27821.825123120427,32660.403405402238,null,72,81568.369774633626,75042.900192662943,88093.839356604323]
[null,23,30847.236917459923,28379.457964063131,33315.015870856718,null,73,83203.24461002661,76546.985041224485,89859.504178828749]
[null,24,31465.508086996571,28948.267440036849,33982.748733956301,null,74,84870.887241745382,78081.216262405753,91660.558221085012]
[null,25,32096.171265584246,29528.477564337507,34663.864966830988,null,75,86571.954434731684,79646.198079953159,93497.710789510224]
[null,26,32739.474826260353,30120.316840159525,35358.632812361182,null,76,88307.116117467012,81242.546828069651,95371.685406864373]
[null,27,33395.672120203089,30724.018350586844,36067.325889819338,null,77,90077.055645809407,82870.891194144657,97283.220097474172]
[null,28,34065.021576508319,31339.819850387656,36790.22330262899,null,78,91882.470072118362,84531.872466348897,99233.067677887841]
[null,29,34747.786803966279,31967.963859648979,37527.609748283583,null,79,93724.070419773838,86226.14478619193,101221.99605335575]
[null,30,35444.236694878178,32608.697759287927,38279.775630468437,null,80,95602.581963197372,87954.375406141582,103250.78852025316]
[null,31,36154.645530953625,33262.273888477335,39047.017173429915,null,81,97518.744513485741,89717.24495240688,105320.2440745646]
[null,32,36879.293091330532,33928.949644024091,39829.63653863698,null,82,99473.31270976954,91515.447692987975,107431.1777265511]
[null,33,37618.464762760072,34608.987581739268,40627.941943780883,null,83,101467.05631641146,93349.691811098543,109584.42082172439]
[null,34,38372.451652000076,35302.655519840075,41442.247784160085,null,84,103500.76052616129,95220.699684068386,111780.8213682542]
[null,35,39141.550700461114,36010.226644424227,42272.874756498008,null,85,105575.22626938715,97129.208167836172,114021.24437093812]
[null,36,39926.06480115046,36731.979617058423,43120.149985242497,null,86,107691.27052950447,99075.968887144118,116306.57217186484]
[null,37,40726.302917959918,37468.198684523129,43984.407151396714,null,87,109849.72666472734,101061.74853154915,118637.70479790554]
[null,38,41542.580207344588,38219.17379075702,44865.986623932156,null,88,112051.44473626847,103087.329157367,121015.56031516996]
[null,39,42375.218142440397,38985.200691045167,45765.235593835634,null,89,114297.29184311751,105153.50849566811,123441.07519056692]
[null,40,43224.54463966933,39766.581068495783,46682.508210842876,null,90,116588.15246352911,107261.1002664468,125915.20466061145]
[null,41,44090.894187882222,40563.622652851649,47618.165722912803,null,91,118924.92880335564,109410.93449908719,128438.9231076241]
[null,42,44974.607980089946,41376.639341682749,48572.576618497143,null,92,121308.54115136129,111603.8578592524,131013.2244434702]
[null,43,45876.034047834888,42205.9513240081,49546.116771661684,null,93,123739.92824165802,113840.73398232539,133639.12250099066]
[null,44,46795.527398255646,43051.8852063952,50539.1695901161,null,94,126220.04762340558,116122.44381353314,136317.65143327805]
[null,45,47733.450153898884,43914.774141586975,51552.126166210801,null,95,128749.87603792151,118449.8859548878,139049.86612095524]
[null,46,48690.171695333484,44794.957959706808,52585.385430960167,null,96,131330.40980334958,120823.97701908162,141836.84258761755]
[null,47,49666.068806623058,45692.783302093216,53639.354311152907,null,97,133962.66520703811,123245.65199047506,{"$f":"SUM(H53*1.08)","v":144679.67842360117}]
[null,48,50661.525823714204,46608.603757817073,54714.447889611343,null,98,136647.67890578278,125715.86459332016,{"$f":"SUM(H54*1.08)","v":147579.49321824542}]
[null,49,51676.934785798912,47542.780002935004,55811.089568662828,null,99,139386.5083340914,128235.58766736409,{"$f":"SUM(H55*1.08)","v":150537.42900081872}]
[null,50,52712.695589710682,48495.679942533832,56929.711236887539,"  GS15/10",100,142180.23212063161,130805.81355098108,{"$f":"SUM(H56*1.08)","v":153554.65069028214}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,34988,34988,34988]
[null,2,71764,53703,48488]
[null,3,102288,71764,65321]
[null,4,142180,102288]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2020 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$19,543-$34,988\n(GS 1-4)","II\n$30,113-$71,764\n(GS 5-11)","III\n$66,167-$102,288\n(GS 12-13)","IV\n$92,977-$142,180\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$19,543-$34,988\n(GS 1-4)","II\n$30,133-$53,703\n(GS 5-8)","III\n$45,627-$71,764\n(GS 9-11)","IV\n$66,127-$102,288\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$19,543-$34,988\n(GS 1-4)","II\n$30,133-$48,488\n(GS 5-7)","III\n$41,310-$65,321\n(GS 8-10)","2020 Broadband\nScale\n(w/o Locality Pay)"]