converting room scheduling data to grid...

  • Thread starter Thread starter Laurel Thomason
  • Start date Start date
L

Laurel Thomason

Just wondering if there is a relative easy way to take data that looks
like this:


smith Jon english 2020 MWF 0700-0750

and convert it automatically into a grid that shows who is teaching at
what time in a particular class, with the occupied hours colored in,
with time on the vertical access and days of the week on the
horizontal?

This is a lame question, I know. [slinks away]
 
Laurel, the only way this will work is if the fields with
the data from which you're importing is fixed width, or
you have a delimiter between the fields in each record
(like Smith,John,English2020,MWF,0700-0750).

Are you trying to import or just copy and paste the data
from word or something.

Email me at (e-mail address removed)

Tony
 
So if I export as CSV then it can be imported into a grid that looks like this:


Mon Tues Wed Thursday

8am E101

9am E102

10am

11am

etc.?

tonyb said:
Laurel, the only way this will work is if the fields with
the data from which you're importing is fixed width, or
you have a delimiter between the fields in each record
(like Smith,John,English2020,MWF,0700-0750).

Are you trying to import or just copy and paste the data
from word or something.

Email me at (e-mail address removed)

Tony
-----Original Message-----
Just wondering if there is a relative easy way to take data that looks
like this:


smith Jon english 2020 MWF 0700-0750

and convert it automatically into a grid that shows who is teaching at
what time in a particular class, with the occupied hours colored in,
with time on the vertical access and days of the week on the
horizontal?

This is a lame question, I know. [slinks away]
.
Click to expand...
Click to expand...
 
Back
Top