{"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,"2018 Expected Contribution Range Calculator"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Contribution Range"]
["Slope=",1.0200425,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=",18785,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":136659},{"$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":94},{"$f":"(LN($O$8)-LN(intercept))/LN(slope)","v":97.482725244322637},{"$f":"FLOOR((LN($O$8)-LN(intercept*0.92))/LN(slope),1)","v":101}]
[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 2018"]
[15442,{"$f":"slope","v":1.0200425},null,"(Based on 1.4% 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":18785},{"$f":"SUM(C6*0.92)","v":17282.2},{"$f":"SUM(C6*1.08)","v":20287.800000000003}]
[null,1,{"$f":"SUM(C6*$B$2)","v":19161.498362499999},{"$f":"SUM(C7*0.92)","v":17628.578493500001},{"$f":"SUM(C7*1.08)","v":20694.4182315},null,51,{"$f":"SUM(C56*$B$2)","v":51682.416995085536},{"$f":"SUM(H7*0.92)","v":47547.823635478693},{"$f":"SUM(H7*1.08)","v":55817.010354692386}]
[null,2,{"$f":"SUM(C7*$B$2)","v":19545.542693430405},{"$f":"SUM(C8*0.92)","v":17981.899277955974},{"$f":"SUM(C8*1.08)","v":21109.18610890484},null,52,{"$f":"SUM(H7*$B$2)","v":52718.261837709535},48500.800890692772,56935.722784726298]
[null,3,19937.284232863483,18342.301494234405,21532.266971492565,null,53,{"$f":"SUM(H8*$B$2)","v":53774.867600591824},49472.878192544478,58076.857008639177]
[null,4,20336.87725210065,18709.927071932598,21963.827432268703,null,54,54852.650384476685,50464.438353718549,59240.86241523482]
[null,5,20744.479114425878,19084.92078527181,22404.037443579949,null,55,55952.03462980756,51475.871859422958,60428.19740019217]
[null,6,21160.250337076759,19467.43031011062,22853.070364042902,null,56,57073.453283875475,52507.577021165438,61639.329546585519]
[null,7,21584.35465445762,19857.606282101013,23311.103026814231,null,57,58217.347971317547,53559.960133612149,62874.735809022954]
[null,8,22016.959082619585,20255.602356010018,23778.315809229152,null,58,59384.169168032677,54633.435634590067,64134.902701475294]
[null,9,22458.233985032988,20661.575266230349,24254.892703835631,null,59,60574.376378582972,55728.426268296338,65420.326488869614]
[null,10,22908.353139678013,21075.684888503773,24741.021390852256,null,60,61788.438317150722,56845.363251778668,66731.513382522782]
[null,11,23367.493807480008,21498.094302881607,25236.89331207841,null,61,63026.833092122215,57984.686444752442,68068.979739492002]
[null,12,23835.836802116424,21928.969857947111,{"$f":"SUM(C18*1.08)","v":25742.703746285741},null,62,64290.048394371071,59146.84452282139,69433.252265920761]
[null,13,24313.56656122284,{"$f":"SUM(C19*0.92)","v":22368.481236325013},26258.651886120668,null,63,65578.581689315251,60332.295154170031,70824.868224460472]
[null,14,{"$f":"SUM(C19*$B$2)","v":24800.871219026147},22816.801521504058,26784.940916548239,null,64,66892.940412823344,61541.505179797481,72244.375645849213]
[null,15,{"$f":"SUM(C20*$B$2)","v":25297.942680433476},23274.107265998799,27321.778094868157,null,65,68233.642171047351,62774.950797363563,73692.33354473114]
[null,16,25804.976696606063,23740.57856087758,27869.37483233455,null,66,69601.214944260559,64033.11774871972,75169.312139801405]
[null,17,26322.17294204779,24216.399106683966,28427.946777411613,null,67,70996.197294780897,65316.501511198425,76675.89307836337]
[null,18,26849.735093238782,24701.75628577968,28997.713900697887,null,68,72419.138579061546,66625.607492736628,78212.669665386478]
[null,19,27387.87090884502,25196.841236137418,29578.900581552622,null,69,73870.599164032377,67960.951230909792,79780.247097154977]
[null,20,27936.792311535544,25701.848926612704,30171.735696458389,null,70,75351.150647777496,69323.058595955299,81379.242699599708]
[null,21,28496.715471439493,26216.978233724334,30776.452709154655,null,71,76861.376084635573,70712.465997864725,83010.28617140642]
[null,22,29067.860891275817,26742.432019973752,31393.289762577886,null,72,78401.870214811875,72129.720597626932,84674.019831996833]
[null,23,29650.453493189212,27278.417213734076,32022.489772644352,null,73,79973.239698592239,73575.380522704858,86371.09887447962]
[null,24,30244.722707326455,27825.144890740339,32664.300523912574,null,74,81576.103355251267,75050.015086831176,88102.191623671373]
[null,25,30850.902562188043,28382.830357212999,33318.97476716309,null,75,83211.092406748881,76554.205014208972,89867.979799288791]
[null,26,31469.231776790697,28951.693234647442,33986.770318933952,null,76,84878.850726311139,78088.542668206253,91669.158784416039]
[null,27,32099.953854677024,29531.957546302863,34667.950163051188,null,77,86580.035091993224,79653.632284633772,93506.437899352692]
[null,28,32743.317179809386,30123.851805424638,35362.782554194142,null,78,88315.315445324493,81250.090209698537,95380.540680950464]
[null,29,33399.575114385712,30727.609105234857,36071.541123536568,null,79,90085.375155137401,82878.545142726405,97292.205167548396]
[null,30,34068.986098615787,31343.467210726525,36794.504986505053,null,80,91890.911286684233,84539.638383749494,99242.184189618973]
[null,31,34751.813752497292,31971.668652297511,37531.958852697077,null,81,93732.634876147597,86234.024086055797,101231.24566623941]
[null,32,35448.326979631718,32612.460821261182,38284.193138002258,null,82,95611.271210652776,87962.369513800557,103260.17290750501]
[null,33,36158.800073120983,33266.096067271304,39051.504078970662,null,83,97527.560113892279,89725.355304780896,105329.76492300366]
[null,34,36883.512823586512,33932.83179769959,39834.193849473435,null,84,99482.256237474969,91523.675738476973,107440.83673647298]
[null,35,37622.750629353242,34612.930579004984,40632.570679701501,null,85,101476.12935811456,93358.039009465399,109594.21970676373]
[null,36,38376.804608842052,35306.66024013469,41446.948977549422,null,86,103509.96468077456,95229.167506312602,111790.76185523653]
[null,37,39145.971715214771,36014.293977997593,42277.649452431957,null,87,105584.56314788898,97137.798096057872,114031.32819972011]
[null,38,39930.554853316964,36736.110465051606,43124.999241582322,null,88,107700.74175478055,99084.682414398107,116316.801095163]
[null,39,40730.862998964571,37472.393959047404,43989.332038881737,null,89,109859.33387140074,101070.58716168869,118648.08058111281]
[null,40,41547.211320621318,38223.434414971613,44870.988226271023,null,90,112061.18957051828,103096.29440487683,121026.08473615976]
[null,41,42379.921303514871,38989.527599233683,45770.315007796067,null,91,114307.17596248539,105162.60188548655,123451.75003948422]
[null,42,43229.32087624057,39770.975206141324,46687.666546339817,null,92,116598.1775367135,107270.32333377642,125926.03173965059]
[null,43,44095.744539902618,40568.084976710408,47623.404103094828,null,93,118935.09650999308,109420.28878919364,128449.90423079253]
[null,44,44979.533499843616,41381.170819856125,48577.896179831107,null,94,121318.85318179461,111613.34492725105,131024.36143633818]
[null,45,45881.03580001423,42210.552936013089,49551.51866401537,null,95,123750.38629669072,113850.35539295546,133650.41720042599]
[null,46,46800.606460036011,43056.557943233129,50544.654976838894,null,96,126230.65341404214,116132.20114091878,136329.10568716552]
[null,47,47738.607615011279,43919.519005810376,51557.696224212181,null,97,128760.63128509308,118459.78078228564,{"$f":"SUM(H53*1.08)","v":139061.48178790053}]
[null,48,48695.408658135144,44799.775965484332,52591.041350785956,null,98,131341.31623762456,120834.01093861461,{"$f":"SUM(H54*1.08)","v":141848.62153663454}]
[null,49,49671.386386165817,45697.675475272554,53645.097297059088,null,99,133973.72456831715,123255.82660285178,{"$f":"SUM(H55*1.08)","v":144691.62253378253}]
[null,50,50666.925147810543,46613.571135985701,54720.279159635393,"  GS15/10",100,136658.89294297763,125726.18150753943,{"$f":"SUM(H56*1.08)","v":147591.60437841585}]
[]
[]
[null,null,null,null,null,null,"Yes"]
[null,"BroadBand","NH","NJ","NK",null,"No"]
[null,1,33629,33629,33629]
[null,2,68983,51623,46609]
[null,3,98317,68983,62787]
[null,4,136659,98317]

{"sheet":"Salary Ranges","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,1,6,3]]}
[]
[null,"2018 Broadband Salary Ranges"]
[null,"Business and Technical Management Professional (NH)"]
[null,"I\n$18,785-$33,629\n(GS 1-4)","II\n$28,945-$68,983\n(GS 5-11)","III\n$63,600-$98,317\n(GS 12-13)","IV\n$89370-$136,659\n(GS 14-15)"]
[null,"Technical Management Support (NJ)"]
[null,"I\n$18,785-$33,629\n(GS 1-4)","II\n$28,945-$51,623\n(GS 5-8)","III\n$43,857-$68,983\n(GS 9-11)","IV\n$63,600-$98,317\n(GS 12-13)"]
[null,"Administrative Support (NK)"]
[null,"I\n$18,785-$33,629\n(GS 1-4)","II\n$28,945-$46,609\n(GS 5-7)","III\n$39,707-$62,787\n(GS 8-10)","2018 Broadband\nScale\n(w/o Locality Pay)"]