IC Timesheet Documentation
How To Use The Timesheet
1) Type in name, date, and work-study information on the summary sheet. 2) Type in your shift information on the sheet for the lab you worked at.* 3) The summary page automatically updates based on the information on the individual lab sheets.
* see the section "Usage Notes" for important details on entering data into the timesheet
Timesheet Data Entry Requirements
1) All shifts should only be recorded to the nearest 15 minute increment. 2) If a shift is a sub you must say so in the comments including the username of who it is a sub for. 3) If claimed time is from a training, you must say so in the comments and indicate which training.
Turning In Your Timesheet
1) You must also submit an electronic copy of the timesheet file to a drop box on icweb. The submitted file must be named with the following convention (without the quotes of course): "login_BeginMonth-EndMonth.xls" where "login" is your Unix login, "BeginMonth" is the first 3 letters of the first month in the pay period, and "EndMonth" is the first 3 letters of the last month in the pay period. The file name should be all lowercase except for the first letter of each month. Failure to follow the correct naming convention may lead to improper processing of your timesheet causing it to be late. 2) If you need to resubmit your timesheet with updated information the resubmitted file should be named as above except that an integer version number should be appended after EndMonth but before .xls. (e.g. first submission=login_Jan-Feb.xls, second submission=login_Jan-Feb1.xls, third submission=login_Jan-Feb2.xls) The file with the largest version number will be used as your official timesheet. 3) Don’t forget - both the electronic copy of the timesheet file and the Cruzpay timesheet must be submitted by the timesheet deadline in order for your timesheet to be considered on time.
Usage Notes
• If a cell goes red that indicates an input error of some sort. • When typing in times you MUST include a space then either "AM" or "PM" after the number (just "A" or "P" is OK too). Failure to do this will cause Excel to interpret the data improperly and the totals will be WRONG. If you accidentally enter information incorrectly, the spreadsheet will detect this by turning cell will go red. • If you work 2 shifts in a day at different labs, the second shift must be put on the second in/out column. Failure to do this will cause Excel to interpret the data improperly and the totals will be WRONG. If you accidentally do this the summary page on the spreadsheet will detect it and that day will go red indicating to you that you must correct it. • The file is in Excel 97/98 format because it uses features not present in the previous version of Excel.