Session Number

(1)

Session Number The Session Number only needs to be entered one time on the RapidTimeEntryTemplate tab. The CopySessionNumber macro copies the Session Number from the first cell to all cells in the Session Number column and displays an error message if it is missing. Cells in error are marked in RED, warnings are marked in YELLOW.

Empl ID The RapidTimeEntryTemplate tab uses the EmplIDLeadingZeros macro to force leading zeros when the client enters an Empl ID that is less than 6-digits and converts it to Text

format. It uses the ValidateEmplID macro to make sure there is a value in the Empl ID column and displays an error message if it is missing. Cells in error are marked RED, warnings are marked in YELLOW.

Empl Record This column is pre-defined as Number with a format of -1234.

The RapidTimeEntryTemplate tab uses the ValidateEmplRecPositionNbr macro to make sure the Empl Record is between 0 and 99 and displays a warning message if any Empl Records are not within those limits. It also makes sure that if the Empl Record is blank there is a value in the corresponding Position Number. Cells in error are marked RED, warnings are marked in YELLOW.

Date Under Report This column is pre-defined as Date with a format of MM/DD/YYYY.

The RapidTimeEntryTemplate tab uses the ValidateDateUnderReport macro to make sure the Date Under Report is a valid date and it is equal to or greater than (after) January 1, 2014, and if not the date is marked as an error. It also checks to see if the Date Under Report is 6 months before today's date or 1 month after today's date, and if so the date is marked with a warning. Cells in error are marked RED, warnings are marked in YELLOW.

Sequence Number Sequence Number Formula: IF(B3 = B2, IF(C3 = C2, IF(D3 = D2, E2 + 1,1),1),1) The Sequence Number is automatically incremented by 1 when the combination of Empl ID, Empl Record, and Date Under Report are all equal.

The RapidTimeEntryTemplate tab uses the CopySequenceNumber macro to copy the Sequence Number formula from the first cell to all cells in the Sequence Number column.

Time Reporting Code The RapidTimeEntryTemplate tab uses the ConvertTRCtoUppercase macro to convert TRC codes to be UPPERCASE.

The RapidTimeEntryTemplate tab uses the ValidateTRC macro to make sure there is a value in the Time Reporting Code, it is found on the TRC tab and displays an error message if it is missing.

Cells in error are marked RED, warnings are marked in YELLOW.

Quantity This column is pre-defined as Number with a format of -1234.10.

The RapidTimeEntryTemplate tab uses the ValidateQuantity macro to make sure the quantity for hour/unit TRCs is between 0.01 and 24, the quantity for amount TRCs is between 0.01 and 300, and

(2)

displays a warning message if any quantities are not within those limits. Cells in error are marked RED, warnings are marked in YELLOW,

Override Rate This column is pre-defined as Number with a format of -1234.10.

The RapidTimeEntryTemplate tab uses the ValidateOverrideRatey macro to make sure the optional Override Rate is between 0.01 and 130 and displays a warning message if any rates are not within those limits. Less than the minimum is an error but greater than the maximum is a warning. An Override Rate with an amount TRC is an error. Cells in error are marked RED, warnings are marked in YELLOW.

Combination Code The RapidTimeEntryTemplate tab uses the ComboCodeLeadingZeros macro to force leading zeros when the client enters a 4-digit Combination Code (or one that is less than 9-digits) and convert it to Text format.

The RapidTimeEntryTemplate tab uses the ValidateComboCode macro to make sure there is a value in the Combination Code and displays an error message if it is missing. Cells in error are marked RED, warnings are marked in YELLOW.

Position Number This column is pre-defined as Text.

The RapidTimeEntryTemplate tab uses the ValidateEmplRecPositionNbr macro to make sure an 8-digit position number has been entered and displays an error message if any position numbers are less than or greater than 8-digits in length. It also makes sure that if the Position Number is blank there is a vallue in the corresponding Empl Record column. Cells in error are marked RED, warnings are marked in YELLOW.

Validate Button The Validate button runs all of the macros to validate and sort data on the RapidTimeEntryTemplate.

The Validate should be run after all time entries have been entered and the spreadsheet saved.

However, it can be run multiple times as required. If there are more than 500 time entries a warning message will be displayed as the recommended maximum is 500 entries per Session Number.

(3)

Rapid Time Entry Template

Click Validate when finished to validate and sort the time entries (RED = Error, YELLOW = Warning).

Session Number Empl ID Empl Record Date Under Report Sequence Number Time Reporting Code Quantity

(4)

Override Rate Combination Code Position Number

Click Validate when finished to validate and sort the time entries (RED = Error, YELLOW = Warning).

(5)

TRC Effective Date Description TRC Type Unit of Measure Min Qty Max Qty Multiplication Factor Rate Factor Rate

AUTO 1/1/2015 Auto Allowance Amount 1 999 1 0 0

BAND 1/1/1901 Band Amount 1 0 1 0 0

BENI 1/1/2015 Benefit Incentive Amount 1 999 1 0 0

BIN$$ 1/1/1901 Bilingual Stip Not Cred CalSTR Amount 0 0 1 0 0

BKPA 1/1/1901 Back Pay Award Amount 1 999 1 0 0

BLGST 1/1/1901 Bilingual Stipend Amount 1 999 1 0 0

BTSNR 1/1/1901 BTSA-Without Release Amount 1 999 1 0 0

BTSWR 1/1/1901 BTSA-With Release Amount 1 999 1 0 0

CAFEP 5/1/2015 Café-Plan Cash Amount 1 999 1 0 0

CCHOT 1/1/1901 Coaching Overtime Amount 1 999 1 0 0

CERTB 6/1/2016 Certificated Bonus-DBS Amount 1 999 1 0 0

CMPE1 1/1/1901 COMP TIME EARNED 1.0 Hours 0.1 999 1 0 0

CMPE2 1/1/1901 COMP TIME EARNED 2.0 Hours 0.1 999 2 0 0

CMPT1 1/1/1901 COMP TIME TAKEN 1.0 Hours 0.1 999 1 0 0

CMPT2 1/1/1901 COMP TIME TAKEN 2.0 Hours 0.1 999 2 0 0

CNS$$ 1/1/1901 Certificated Not Creditable Amount 0 0 1 0 0

COMP 1/1/1901 Comp Time Taken Hours 0.1 99 0 0 0

COMPE 1/1/1901 Comp Time Earned Hours 0 0 1 0 0

COMPO 1/2/1901 Comp Pay Off Hours 0.1 999 1 0 0

COMPT 1/1/1901 Comp Time Taken Hours 0 0 1 0 0

CONFC 1/1/1901 Confidential Classified Amount 1 999 1 0 0

COT$$ 1/2/1901 Coaching Overtime $$ Amount 0 0 1 0 0

COTHR 1/2/1901 Coaching Overtime by Hour Hours 0 0 1 0 0

CPE15 1/1/1901 COMP TIME EARNED 1.5 Hours 0.1 999 1.5 0 0

CPT15 1/1/1901 COMP TIME TAKEN 1.5 Hours 0.1 999 1.5 0 0

CREDS 1/1/1901 Credential Stipend Amount 1 999 1 0 0

DAILY 3/1/2017 Daily Units DAY 0 50 1 0 0

DOCTS 1/1/1901 Doctorial Stipend Amount 1 999 1 0 0

DPHNR 1/1/1901 Departmnt Head Without Release Amount 1 999 1 0 0

DPHWR 1/1/1901 Dept Head With Release Amount 1 999 1 0 0

DRIVT 1/1/1901 Driver Training Amount 1 999 1 0 0

DTS$$ 1/1/1901 Difficult to staff - Cert Amount 0 0 1 0 0

EAP 1/1/1901 Educational Assistance Plan Amount 1 1500 1 0 0

EDST$ 1/1/1901 Extended Day-STRS-$Amount$ Amount 1 0 1 0 0

EDSTH 1/1/1901 Extended Day-STRS-HOURS Hours 0 0 1 0 0

EIPP 1/1/1901 Educational Incentive-PERS Amount 1 999 1 0 0

EMPA 1/1/1901 Employee Award Amount 1 2000 1 0 0

ENR$ 1/1/1901 Earns No Ret AMOUNT Amount 0 0 1 0 0

ENRH 1/1/1901 Earns No Retirement HOURS Hours -400 400 1 0 0

(6)

Overridable Hours Earnings Code

N Actual Hrs ATO

N Actual Hrs BND

N Actual Hrs BNI

N Actual Hrs

N Actual Hrs BPA

N Actual Hrs BIL

N Actual Hrs BNR

N Actual Hrs BWR

N Actual Hrs CFC

N Actual Hrs COT

N Actual Hrs CBS

Y Actual Hrs

N Actual Hrs

Y Actual Hrs

N Actual Hrs CPO

Y Actual Hrs

N Actual Hrs CNC

N Actual Hrs COT

Y Actual Hrs COT

Y Actual Hrs

N Actual Hrs CST

N Actual Hrs DLY

N Actual Hrs DST

N Actual Hrs HNR

N Actual Hrs HWR

N Actual Hrs DRT

N Actual Hrs

N Actual Hrs EAP

N Actual Hrs EDS

N Actual Hrs EIP

N Actual Hrs EAW

N Cmpstn Hrs ENR

N Actual Hrs ENR

(7)

EQPAL 1/1/1901 Equipment Allowance Amount 1 999 1 0 0

EXPAL 1/1/2015 Expense Allowance Amount 1 999 1 0 0

FRIX 1/1/1901 Friday Rate Units DAY 0 0 1 0 0

HAZPR 1/1/1901 Hazard Premium Amount 1 999 1 0 0

HOL1 5/1/2019 Holiday/1.0 Hours 0 16 1 0 0

HOL15 1/2/1901 Holiday/1.5 Hours 0 0 1.5 0 0

HOL2 5/1/2019 Holiday/Double Hours 0 16 2 0 0

HOL25 1/1/1901 Holiday/2.5 Hours 0 0 2.5 0 0

HOLPR 5/1/2019 Holiday Pay-PERS Amount 0 999 1 0 0

HRLE 1/2/1901 Exception Hourly for Benefits Hours 0 200 1 0 0

HRLY 5/1/2018 Hourly Hours 0 300 1 0 0

HSALL 10/1/2017 Housing Allowance Amount 1 999 1 0 0

INSBO 1/1/2015 Insurance Buy Out Amount 1 999 1 0 0

INSWK 1/2/1901 Inservice Workshop Hours Hours 0 999 1 0 0

JRDOS 1/1/1901 Jury Duty Offset Amount 1 999 1 0 0

JURDA 1/1/1901 Jury Duty Allowance Amount 1 999 1 0 0

LEADT 1/1/1901 Lead Teacher Amount 1 999 1 0 0

LIC$$ 1/1/1901 LRT/Internet Class Amount Amount 0 0 1 0 0

LICHR 1/1/1901 LRT/Internet Class Hourly Hours -400 400 1 0 0

LONG 1/1/1901 Longevity Amount 1 999 1 0 0

LRTIC 1/1/1901 LRT/Internet Class Amount 1 999 1 0 0

LVWOP 1/1/1901 Leave Without Pay Hours 0.1 99 -1 0 0

MASTS 1/1/1901 Master Stipend Amount 1 999 1 0 0

MATHS 1/1/1901 Math Stipend Amount 1 999 1 0 0

MILE 1/1/2015 Mileage Allowance Amount 1 999 1 0 0

MILPP 1/1/1901 Military Pay-PERS Amount 1 999 1 0 0

MTE$$ 1/1/1901 Master Teacher Stipend Amount 0 0 1 0 0

O25 1/2/1901 Overtime 2.5 Hours 0 12 2.5 0 0

OCC$$ 1/1/2019 Out of Class Dollar Amount Amount 0 0 1 0 0

OLCC 1/1/1901 Overload-C.C. Amount 1 999 1 0 0

OLCHR 1/1/1901 Overload Hrs Community College Hours HRS 0 999 1 0 0

OOC 1/1/2019 Out of Class Amount 1 999 1 0 0

OSNPS 1/1/1901 Off Schedule Without PERS Amount 0 0 1 0 0

OSPPS 7/1/2017 Off Schedule Pay-PERS Amount 1 5000 1 0 0

OSPST 7/1/2017 Off Schedule Pay STRS-DBS Amount 1 5000 1 0 0

OT1 1/1/1901 Overtime-Straight Time Hours -150 150 1 0 0

OT1.5 7/1/2017 Overtime/One and Half Hours 0 150 1.5 0 0

OT2.0 1/1/1901 Overtime/Double Hours 0 12 2 0 0

OTHDS 1/1/1901 OTH Degree Stipend Amount 1 999 1 0 0

(8)

N Actual Hrs EQA

N Actual Hrs EXA

N Actual Hrs FRX

N Actual Hrs HZP

N Actual Hrs H1

N Actual Hrs H15

N Actual Hrs H2

N Actual Hrs H25

N Actual Hrs HPP

Y Actual Hrs HRE

N Actual Hrs HRL

N Actual Hrs HSA

N Actual Hrs IBO

Y Actual Hrs INS

N Actual Hrs JDO

N Actual Hrs JDA

N Actual Hrs LTR

N Actual Hrs LIC

N Actual Hrs LNG

N Actual Hrs LIC

N Actual Hrs LWP

N Actual Hrs MSS

N Actual Hrs MTS

N Actual Hrs MIL

N Actual Hrs MPP

N Actual Hrs

N Actual Hrs O25

N Cmpstn Hrs OOC

N Actual Hrs OLC

N Actual Hrs OOC

N Actual Hrs OFN

N Actual Hrs OSP

N Actual Hrs OSS

N Actual Hrs OT1

N Actual Hrs OT5

N Actual Hrs OT2

N Actual Hrs ODS

(9)

OVNST 1/1/1901 Overnight Stipend Amount 1 999 1 0 0

PARNR 10/1/2016 PAR-Without Release Amount 1 9999 1 0 0

PARWR 1/1/1901 PAR-With Release Amount 1 999 1 0 0

PPDBS 6/1/2016 Performance Pay-DBS Amount 1 999 1 0 0

PPSTR 1/1/1901 Performance Pay-STRS Amount 1 999 1 0 0

READS 1/1/1901 Reading Stipend Amount 1 999 1 0 0

REG$ 1/1/1901 Regular / Amount Amount 1 999 1 0 0

REGH 1/1/1901 Regular / Hours Hours 0.1 99 1 0 0

RET$$ 1/2/1901 RETRO AMOUNT Amount 0 0 1 0 0

RETRO 1/1/1901 Retro Pay Amount 0.1 999 1 0 0

RNCTV 1/1/1901 Retirement Incentive Amount 1 99999 1 0 0

SALRE 1/1/1901 Salary Repayment Amount 0.1 999 1 0 0

SAP$ 1/1/1901 St Match CSE Sumr Asst Amt Amount 0 0 1 0 0

SCKPS 1/1/1901 SICKLVINC PERS Amount 1 999 1 0 0

SCKST 1/1/2015 SICKLVINC STRS Amount 1 999 1 0 0

SCP$ 1/1/1901 School Closure Premium - Amt Amount 0 0 1 0 0

SCPH 1/1/1901 School Closure Premium Hours Hours -400 400 1 0 0

SDLY 1/1/1901 Substitute Daily Units DAY 0.5 5 1 0 0

SHIFT 1/1/1901 Shift Differential Lump Sum Amount 1 999 1 0 0

SICKN 1/1/1901 Negative Sick Leave Adjustment Hours 0.1 99 -0.5 0 0

SICKP 1/1/1901 Sick Leave Pay Off Hours 0.1 99 1 0 0

SITEP 1/1/1901 Site Pay Amount 1 999 1 0 0

SKDF$ 1/2/1991 Sick Differential - $Amount$ Amount -999 0 1 0 0

SPERD 1/1/1901 Period Units DAY 1 3 1 0 0

SPPC 12/17/2013 Special Programs-Certificated Amount 1 999 1 0 0

TCHSD 1/2/1901 Teacher Staff Development Amount 0 999 1 0 0

TCHSH 1/1/1901 Teacher Staff Development Hrs Hours HRS 0 0 1 0 0

TCHST 1/1/1901 Teacher TR-#STDNT Amount 1 999 1 0 0

TCHSU 1/1/1901 Teacher Staff Development Unit Units DAY 0 0 1 0 0

TCHUN 1/1/1901 Teacher TR-Uniform Amount 1 999 1 0 0

TERMP 1/2/1901 Termination Pay Amount 1 999 1 0 0

TUP$$ 1/1/1901 Temporary Upgrade Pay Amount 0 0 1 0 0

UNAP 1/1/2013 Uniform AL-PERS Amount 1 999 1 0 0

UNAS 1/1/2015 Uniform AL-STRS Amount 1 999 1 0 0

VACPO 10/1/2015 Vacation Pay Off Hours 0.1 999 1 0 0

XAC$$ 3/1/2014 Extra Curr Classified - Amount Amount 0 0 1 0 0

XACHR 3/1/2014 Extra Curr Classified - Hours Hours HRS 0 0 1 0 0

XAR$$ 1/1/2014 Extra Curr Certified - Amount Amount 0 0 1 0 0

XARHR 1/1/2014 Extra Curr Certified - Hours Hours HRS 0 0 1 0 0

(10)

N Actual Hrs ONS

N Actual Hrs PNR

N Actual Hrs PWR

N Actual Hrs PPD

N Actual Hrs PPS

N Actual Hrs RDS

N Actual Hrs REG

N Actual Hrs RRP

N Actual Hrs RNC

N Actual Hrs SRP

N Actual Hrs SAP

N Actual Hrs SLP

N Actual Hrs SLS

N Actual Hrs SCP

N Actual Hrs DLY

N Actual Hrs SDL

N Actual Hrs SLA

N Actual Hrs SPO

N Actual Hrs STP

N Actual Hrs

N Actual Hrs DLY

N Actual Hrs SPC

N Actual Hrs TSD

N Actual Hrs TTS

N Actual Hrs TSD

N Actual Hrs TTU

N Actual Hrs TMP

N Actual Hrs

N Actual Hrs UAP

N Actual Hrs UAS

N Actual Hrs VPO

N Cmpstn Hrs XAC

Y Actual Hrs XAC

N Cmpstn Hrs XAR

Y Actual Hrs XAR