FILLCAL ​
Used in a JUSTDOIT to create a room use calendar for courses.
Reporting Area(s) ​
Room Use
Required Parameters ​
- Numeric return value:
0= (one line) Course Title, Time, Instructor
1= (one line) Time, Number
2= (one line) Time, Title, Room
3= (one line) Time, Title
4= (one line) Time, Number, Instructor
5= (two line) 1) Time 2) Number
6= (two line) 1) Time 2) Title
7= (two line) 1) Time 2) Number, Title
8= (two line) 1) Time 2) Number, Instructor
9= (two line) 1) Location 2) Time, Title
Options 10 + for those who have enabled Split Location option
10= (one line) Room, Number, Time
11= (one line) Room, Time, Number
12= (one line) Room, Time, Title
13= (two line) 1) Room, Time, Number 2) Instructor
14= (two line) 1) Room, Time 2) Title
15= (two line) 1) Room, Time 2) Title
16= (two line) 1) Building, Room, Time 2) Title
17= (two line) 1) Building, Room 2) Time, Title
21= (one line) Time, Title, Teacher
31= (one line) Room, Number, time
3> 2= (two line) 1) Room, Time 2) Title
--OR--Character return value: custom data string to return (i.e. "loclocat+' '+nicetime(crmtm)+' '+trim(cocrsenm)" returns location, time,title)
Optional Parameters ​
- Logical .t. returns 5 characters of room number, .f. returns 9 characters
- Logical .t. return short course number (i.e. MGT101 vs. 03SMGT101), .f. returns entire course number (default)
- Numeric return value: number of characters of course title to return (i.e. 15 returns 15 characters of title)
- Logical .t. returns an asterisk (*) on first course meeting and number sign (#) on last course meeting, .f. does not (default)
- Logical .t. doesn’t create a marker column in the cursor so justdoits can be written against the new cursor. .f. is default.
- Logical .t. allows a 6th week to be created where the month goes that long (October has the 1st on a Saturday, so only one day that week and the 30th and 31st are then pushed to a 6th week). .f. is default and the 6th week shows at the beginning of the 1st week.
Example(s) ​
JUSTDOIT('DO FILLCAL with 3') returns course time and title (i.e. 8am - 11am Intro to Management)
JUSTDOIT('=FILLCAL(1,.f.,.t.)') returns course time and shortened number (i.e. 8am - 11am MGT101)
JUSTDOIT('=FILLCAL("loclocat+[ ]+nicetime(crmtm)+CHR(13)+trim(cocrsenm)")') returns course location, time, carriage return, title