)##' " 2:T +BBC:HSUtility:# 12 Calculate NSPS Buy In***(TF :HSUtility:***jT [Purpose: Calculate the NSPS step increase buy in cost and NSPS starting salary by employee.T  \n\nThis utility uses the active personnel file. This file should be an imported DCPDS_02 file without additional or manual entries.ZT  E\nRunning this utility does not change the personnel file in any way. T   \n\nOptionsHT  3\nUtility options are available in the next window.vT  a\nWhen calculating the days between step increases either paid days or calendar days may be used.nT  Y\nLocality pay may be included or excluded. GS, FWS, or all employees may be calculated. T   \n\nResultsT  r\nResults are displayed in the file BUYIN.TXT. It has two sections. The first section displays buy in and startingfT  Q\nsalary calculations. The total buy in cost is at the end of the first section.T   The second section lists employees not \ncalculated in the first section. If the last WGI date is missing for an employee, calculations are skipped andDT  /\nthe employee is listed in the second section.^T  I Employees at max step or step 00 are also listed in the second section.lT  W\nColumn formulas shown in the BUYIN.TXT heading are for general schedule calculations.ZT  E\nWage grade calculations are slightly different in columns 8 and 13.T  \n\nIf BUYIN.TXT is pasted into Excel, use Text to Columns on the Excel Data menu to move data into separate worksheet columns.tT  _\n\nBudget Builder for Civilian Personnel Version 8.0 or later is required to run this utility.T  \n\n %ey%OKF //Title L //FUNCTION "\!\ !"#$%&'()*+,-./01241G((pt_id%F6EE } "F Cannot open F6B (%FNSPS  BF7 800 F9jWGI3% :G% &:W& ;;G((ename G`(G` NSPS BuyIn Utility(!Buy In Date : <>Options used: <> <> <>-&File used : <>T <d] Salary Salary Salary Increase Days Salary Days Starting at at Between Between Increase Before Buy In Salary Name Grade Step Last WGI Next WGI Last WGI Next WGI Steps Steps Per Day NSPS Amount NSPS $<>col1 col2 col3 col4 col5 col6 col7 col8 col9 col10 col11 col12 col13 (7-6) (5-4) (8/9) (10x11) (6+12) $<>~vR,:F\workingF\%800@.%810 :G g.%805 :W .%F=.%F:`GW .%F>.%F> F? ;%:G 810 7>?FA8>@%?  *>>?8FFF8kB0>?FA8>@%810 :G .%805 :W .UN<><> <> <> <> <>(TCFAE:=8PUBD TFFFF8kB0(TGFAE:=FPUBD+$ <>+$ <>%:W2THG'C'KTHGC*# <>% TIF>?JTI?>+$ <>TKFHI W<> % MTLF> JlTL >*# <>TMKL,% <>TM%:WTNCM' *TNCM/(<>  <> <>}Total Buy In Amount<> <> <>  T Oe ------------------------- Employees not calculated -------------------------~.T P  800T Pno step 810 :G T Pmax step 805 :W :T Pmax step F=`T Pno grade F:`GW T P not GS/FWS F>T P no last WGI%F P * T O/HA<><> <> <> <>% OL NoneG`G`(R F QF QRBUSLSUTILID LCTITLEitZBETW pcLCMSGID;ZMSGBOX_fOPENSYSndLDBUYINt LNTOTBUYtLNPAY****LNDAYS***LNSCOPE**SPCRYPT**MISS_CHAREQ_CHAR**UNEQ_CHARPT_LEN- MPT_DECpy BBU12DTrkASKFORoyeZALERTf THISFILEELSEECOPY'ZTMPNAMEAGSTMPDIRoLSPAYCOPYOPEN1IRSPREFS ) PF_TT EnTTAYy tALLYCOPYPCT10OpenPCT11ECopPCT12PS' PCT13urn PCT14 *PCT15delePCT16recoPCT17atedPCT18get PCT19 dePCT20r emPCT21) anPCT22='00PCT23te fPCT24r(erPCT25I' PCT26es sPCT27dup PCT28te fPCT29r(erPCT30AIN'FORmissesPT_FMT duPT_ID PF_EE m.lETOCOPYGESTEPyeesEREMS empEPLANE=AENAMEEeeLNDASHESSEGRADE ELWIGDTr EWGI_DT'GWGINEXT iETABLEopeALLSTRlePTSALAR1aGETRATE eEDCPDSDT-NEXTSTEP PTSALAR2nLNSALINCmLNDAYSBETWWDYSOrderLNDAYINCWLNDAYSUNTILNBUYAMTILNBUYINSALLBNONETLLSREASONtHSERASEoTEXT3OPY4 5% AC-{)T FF k F k8"T F Nhh)T FF k  F k81T F 444hhhB  UPSTABLE PSSTEPitPDFROM pcLNSTEPD;LNWEEKS_fCASEOFndb3T FTXTSelect input fileSelect%F [T  ULSNEWFILEGETFILE2tLSXREFTXTWGINEXT VBROWSED  aqa AA ABAArUA AA#AAgq!AA2rAA!AAAA1B3A1Aa AAA2AAAAAAAAAAAAAA3AAAAAR#A3aQAc4qA#qACrArq1qqqqA$BAAqbaR11|A7b!Ba32!QA3a/X2c:\(dev)\bbu12.fxpc:\(dev)\bbu12.prg*#