Automating Data Analasys
 

I am working on a project for my department that involves looking at
student rosters, checking what classes each student is registered for
and then recording how many classes they are registered for during:
M-F during the day (D)
M-Th during the evening (E)
Friday evening (F)
Saturday (S)
Sunday (U)

And then how many credits they are taking in each of those periods.

I now have 3 spread sheets I am working with
One will contain all of my final information
One contains the student's classes they are registered for (via our
code for the class)
The third is a list of all of the info on each class (sorted by codes)

In the third sheet (the Class list) I have created a formula that has
given me what time period each class falls under (D, E, F, S, U).

What I now need is a formula for my student spread sheet. What I want
it to do is:
Look at the Cell to the left of it (this will either be blank or
contain a code)
Identify that code on the sheet that has my class list (for ease of
refference I have just made a second worksheet named CLASS, so
refferencing it is done via CLASS! I know).
Pull out the letter code (sitting in the cell to the Right) and that
would be result of the formula.

My main problems a
1) I don't know how to have a formula seach through a list for
something specific.
2) Refference something that is one column over (B-1 = A? A+1 = B?)


Once I understand these things I should be able to automate what
aparently was done by hand before :)

Thank you for your time and help.

Automating Data Analasys
 

Well, I have found out how to use VLOOKUP, and that made things much
easier :D
I figgured out a simple IF statment lets me check to see if I actualy
need to run the conversion....

Things are looking up :D

Thansal wrote:
I am working on a project for my department that involves looking at
student rosters, checking what classes each student is registered for
and then recording how many classes they are registered for during:
M-F during the day (D)
M-Th during the evening (E)
Friday evening (F)
Saturday (S)
Sunday (U)

And then how many credits they are taking in each of those periods.

I now have 3 spread sheets I am working with
One will contain all of my final information
One contains the student's classes they are registered for (via our
code for the class)
The third is a list of all of the info on each class (sorted by codes)

In the third sheet (the Class list) I have created a formula that has
given me what time period each class falls under (D, E, F, S, U).

What I now need is a formula for my student spread sheet. What I want
it to do is:
Look at the Cell to the left of it (this will either be blank or
contain a code)
Identify that code on the sheet that has my class list (for ease of
refference I have just made a second worksheet named CLASS, so
refferencing it is done via CLASS! I know).
Pull out the letter code (sitting in the cell to the Right) and that
would be result of the formula.

My main problems a
1) I don't know how to have a formula seach through a list for
something specific.
2) Refference something that is one column over (B-1 = A? A+1 = B?)


Once I understand these things I should be able to automate what
aparently was done by hand before :)

Thank you for your time and help.

Automating Data Analasys
 

Do you need any more help with this, or are you at a good place right now and
just looking forward to your next brick wall? If so, reply to this and I'll
get back to the thread as soon as I get the email.

"Thansal" wrote:

Well, I have found out how to use VLOOKUP, and that made things much
easier :D
I figgured out a simple IF statment lets me check to see if I actualy
need to run the conversion....

Things are looking up :D

Thansal wrote:
I am working on a project for my department that involves looking at
student rosters, checking what classes each student is registered for
and then recording how many classes they are registered for during:
M-F during the day (D)
M-Th during the evening (E)
Friday evening (F)
Saturday (S)
Sunday (U)

And then how many credits they are taking in each of those periods.

I now have 3 spread sheets I am working with
One will contain all of my final information
One contains the student's classes they are registered for (via our
code for the class)
The third is a list of all of the info on each class (sorted by codes)

In the third sheet (the Class list) I have created a formula that has
given me what time period each class falls under (D, E, F, S, U).

What I now need is a formula for my student spread sheet. What I want
it to do is:
Look at the Cell to the left of it (this will either be blank or
contain a code)
Identify that code on the sheet that has my class list (for ease of
refference I have just made a second worksheet named CLASS, so
refferencing it is done via CLASS! I know).
Pull out the letter code (sitting in the cell to the Right) and that
would be result of the formula.

My main problems a
1) I don't know how to have a formula seach through a list for
something specific.
2) Refference something that is one column over (B-1 = A? A+1 = B?)


Once I understand these things I should be able to automate what
aparently was done by hand before :)

Thank you for your time and help.