{"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,"2017 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200426,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=",18526,null,null,null,null,"Enter Base Pay/Retained Pay",130000,"NH",4,{"$f":"VLOOKUP($J$7,MaxPay,MATCH($I$7,PaySched,1)+1,FALSE)","v":134776},{"$f":"IF($H$7>$K$7,\"Yes\",\"No\")","v":"No"},"Expected Contribution Range =",{"$f":"CEILING((LN($O$8)-LN(intercept*1.08))/LN(slope),1)","v":95},{"$f":"(LN($O$8)-LN(intercept))/LN(slope)","v":98.181863422560696},{"$f":"FLOOR((LN($O$8)-LN(intercept*0.92))/LN(slope),1)","v":102}]
[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":130000}]

{"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 2017"]
[15442,{"$f":"slope","v":1.0200426},null,"(Based on 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,{"$f":"intercept","v":18526},{"$f":"SUM(C6*0.92)","v":17043.920000000002},{"$f":"SUM(C6*1.08)","v":20008.080000000002}]
[null,1,{"$f":"SUM(C6*$B$2)","v":18897.309207599999},{"$f":"SUM(C7*0.92)","v":17385.524470992001},{"$f":"SUM(C7*1.08)","v":20409.093944208002},null,51,{"$f":"SUM(C56*$B$2)","v":50970.095523317112},{"$f":"SUM(H7*0.92)","v":46892.487881451743},{"$f":"SUM(H7*1.08)","v":55047.703165182487}]
[null,2,{"$f":"SUM(C7*$B$2)","v":19276.060417124245},{"$f":"SUM(C8*0.92)","v":17733.975583754305},{"$f":"SUM(C8*1.08)","v":20818.145250494184},null,52,{"$f":"SUM(H7*$B$2)","v":51991.66875985275},47832.33525906453,56151.002260640977]
[null,3,19662.402785640501,18089.41056278926,21235.395008491741,null,53,{"$f":"SUM(H8*$B$2)","v":53033.716980138975},48791.019621727857,57276.414338550094]
[null,4,20056.488459711978,18451.969382935022,21661.007536488938,null,54,54096.650556085107,49768.918511598298,58424.382600571917]
[null,5,20458.472635314603,18821.794824489436,22095.150446139774,null,55,55180.888084520499,50766.41703775886,59595.359131282145]
[null,6,20868.513618955159,19199.032529438748,22537.994708471575,null,56,56286.856552043311,51783.90802787985,60789.80507620678]
[null,7,21286.772890014432,19583.831058813277,22989.714721215587,null,57,57414.991503173296,52821.792182919438,62008.190823427161]
[null,8,21713.415164339836,19976.341951192651,23450.488377487025,null,58,58565.737211874795,53880.478234924813,63250.996188824785]
[null,9,22148.608459112635,20376.719782383625,23920.497135841648,null,59,59739.546856517518,54960.383107996116,64518.710605038927]
[null,10,22592.524159015247,20785.122226294028,24399.92609173647,null,60,60936.882698343958,56061.932082476444,65811.833314211472]
[null,11,23045.337083724728,21201.710117026749,24888.964050422706,null,61,62158.216263513787,57185.558962432689,67130.873564594891]
[null,12,23507.225556758989,21626.647512218271,{"$f":"SUM(C18*1.08)","v":25387.803601299711},null,62,63404.028528796887,58331.706246493137,68476.350811100638]
[null,13,23978.371475702887,{"$f":"SUM(C19*0.92)","v":22060.101757646658},25896.641193759118,null,63,64674.810110988154,59500.8253021091,69848.794919867214]
[null,14,{"$f":"SUM(C19*$B$2)","v":24458.960383841808},22502.243553134464,26415.677214549156,null,64,65971.061460118639,60693.376543309154,71248.746376928131]
[null,15,{"$f":"SUM(C20*$B$2)","v":24949.181543230996},22953.247019772516,26945.116066689476,null,65,67293.293056539216,61909.829612016081,72676.756501062351]
[null,16,25449.228009229359,23413.289768491009,27485.166249967708,null,66,68642.025611954217,63150.663562997885,74133.387660910565]
[null,17,25959.29670652714,23882.55297000497,28036.040443049314,null,67,70017.790274484374,64416.367052525624,75619.213496443132]
[null,18,26479.588506697382,24361.221426161592,28597.955587233177,null,68,71421.128837839758,65707.438530812578,77134.819144866939]
[null,19,27010.308307301715,24849.48364271758,29171.132971885854,null,69,72852.593954685042,67024.386438310248,78680.801471059851]
[null,20,27551.665112581642,25347.531903575113,29755.798321588176,null,70,74312.749354281215,68367.72940593872,80257.769302623725]
[null,21,28103.872115767073,25855.562346505707,30352.18188502844,null,71,75802.170064489328,69737.996459330185,81866.343669648486]
[null,22,28667.146783034546,26373.775040391785,30960.518525677311,null,72,77321.44263822386,71135.72722716596,83507.158049281774]
[null,23,29241.710939148194,26902.374064016338,31581.047814280049,null,73,78871.165384444728,72561.472153689159,85180.858615200312]
[null,24,29827.790854817165,27441.567586431793,32214.014123202542,null,74,80451.948603779005,74015.792715476695,86888.104492081329]
[null,25,30425.617335803923,27991.56794893961,32859.66672266824,null,75,82064.414828865105,75499.261642555895,88629.568015174314]
[null,26,31035.425813818507,28552.591748713028,33518.259878923993,null,76,83709.199069514114,77012.463143952991,90405.934995075251]
[null,27,31657.456439234546,29124.859924095785,34190.052954373314,null,77,85386.949062784755,78555.99313776198,92217.904987807546]
[null,28,32291.954175663548,29708.597841610466,34875.310509716634,null,78,87098.32552807052,80130.459485824875,94066.191570316165]
[null,29,32939.168896424701,30304.035384710725,35574.302408138676,null,79,88844.002427299434,81736.482233115486,95951.522621483397]
[null,30,33599.35548294818,30911.407044312327,36287.30392158404,null,80,90624.66723034883,83374.693851920922,97874.640608776739]
[null,31,34272.773925150716,31530.952011138659,37014.595839162772,null,81,92441.021185779828,85045.739490917447,99836.302880642223]
[null,32,34959.689423822943,32162.91426991711,37756.464577728781,null,82,94293.779596997934,86750.277229238098,101837.28196475777]
[null,33,35660.372495068856,32807.542695463351,38513.202294674367,null,83,96183.672103948731,88488.978335632841,103878.36587226464]
[null,34,36375.099076838524,33465.091150691442,39285.107002985606,null,84,98111.442970459335,90262.527532822598,105960.35840809609]
[null,35,37104.150637595965,34135.818586588292,40072.482688603646,null,85,100077.85137733906,92071.623267151939,108084.07948752619]
[null,36,37847.814287165049,34819.989144191844,40875.639430138253,null,86,102083.67172135452,93916.977983646168,110250.36545906289]
[null,37,38606.382889796987,35517.872258613228,41694.893520980746,null,87,104129.69392019694,95799.31840658118,112460.06943381269]
[null,38,39380.155179504036,36229.742765143717,42530.567593864362,null,88,106216.72372356188,97719.385825676931,114714.06162144685]
[null,39,40169.435877704767,36955.881007488388,43382.990747921154,null,89,108345.58303046375,99677.936388026646,117013.22967290085]
[null,40,40974.535813227252,37696.572948169072,44252.498678285432,null,90,110517.11021291012,101675.74139587731,119358.47902994294]
[null,41,41795.772044717443,38452.110281140049,45139.433808294845,null,91,112732.1604460634,103713.58761037832,121750.73328174847]
[null,42,42633.467985500902,39222.790546660828,46044.145424340975,null,92,114991.60604501967,105792.2775614181,124190.93452862125]
[null,43,43487.953530947103,40008.917248471334,46966.989813422872,null,93,117296.33680833758,107912.62986367058,126680.0437530046]
[null,44,44359.565188386463,40810.799973315545,47908.330403457381,null,94,119647.26036845238,110075.47953897619,129219.04119792857]
[null,45,45248.646209631217,41628.754512860723,48868.537906401718,null,95,122045.30254911313,112281.67834518407,131808.92675304218]
[null,46,46155.546726152374,42463.102988060185,49847.990464244569,null,96,124491.40772998398,114532.09511158527,134450.72034838272]
[null,47,47080.623886965957,43314.173976008686,50847.073797923236,null,97,126986.53921855296,116827.61608106873,{"$f":"SUM(H53*1.08)","v":137145.4623560372}]
[null,48,48024.241999282865,44182.30263934024,51866.181359225498,null,98,129531.67962949474,119169.14525913517,{"$f":"SUM(H54*1.08)","v":139894.21399985434}]
[null,49,48986.772671977691,45067.83085821948,52905.714485735909,null,99,132127.83127163685,121557.60476990591,{"$f":"SUM(H55*1.08)","v":142698.05777336782}]
[null,50,49968.594961933071,45971.10736497843,53966.08255888772,"  GS15/10",100,134776.01654268175,123993.93521926722,{"$f":"SUM(H56*1.08)","v":145558.0978660963}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,33164,33164,33164]
[null,2,68025,50904,45970]
[null,3,96958,68025,61922]
[null,4,134776,96958]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2017 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$18,526-$33,164\n(GS 1-4)","II\n$28,545-$68,025\n(GS 5-11)","III\n$62,722-$96,958\n(GS 12-13)","IV\n$88,136-$134,776\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$18,526-$33,164\n(GS 1-4)","II\n$28,545-$50,904\n(GS 5-8)","III\n$43,251-$68,025\n(GS 9-11)","IV\n$62,722-$96,958\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$18,526-$33,164\n(GS 1-4)","II\n$28,545-$45,970\n(GS 5-7)","III\n$39,159-$61,922\n(GS 8-10)","2017 Broadband\nScale\n(w/o Locality Pay)"]