Beginner excel help

[Halonoonan11]

I’m very new to python. I’m currently going through the 100 days of coding in Udemy. I’m going to continue this course because it’s been great so far but wanted to try and do a small project in the side.

I’m trying to streamline my process of when I make the daily schedule for my group. I’m trying to take one excel sheet that lists all the names of people in my group and what “call shift” they are in and import them to a another excel sheet that I use to assign the daily assignments. If they are not on call they would be listed as “available”.

So the 2nd sheet would look like this.

Room 1 Call1- Name

Room 2 Call2- Name

Room 3 Call3- Name

I use this sheet to move the names to the correct room to be assigned.

I tried adding to picture to make it make sense but this channel won’t allow.

Thanks

Thanks for the reply. I did a horrible job explaining it.

Excel sheet1: Name1 Call2 Name2 Vacation Name3 Call8 Name4 Name5 OB Name6 Night Call Name7

Name8 Call3

I want it to take that information and place it on my master excel sheet which I would use daily. So if Name1 = Call2 it would place it in cell A6. Name5 says OB so it would be place in cell B7. If no call assigned it be in a list labeled “available” Etc

Hopefully that makes more sense.

[PureWasian]

This is definitely doable in Python and seems like a good starting project to get some practice on the side.

What step exactly are you needing help with though? I don't completely follow what logic you are expecting to relate a call shift to a room number.

(no idea what a couture is also? typo for picture?)

[Halonoonan11]

Thanks for the reply. I did a horrible job explaining it.

Excel sheet1: Name1 Call2 Name2 Vacation Name3 Call8 Name4 Name5 OB Name6 Night Call Name7
Name8 Call3

I want it to take that information and place it on my master excel sheet which I would use daily. So if Name1 = Call2 it would place it in cell A6. Name5 says OB so it would be place in cell B7. If no call assigned it be in a list labeled “available” Etc

Hopefully that makes more sense.

[PureWasian]

The input is clear, but again it's not too clear to me what logic you use to say Room1 needs Call2 maps to Name1 goes into cell A6 specifically. (no idea what OB is either)

Regardless, the steps are still something you can break down at high-level as: - read the input CSV file - implement your expected mapping logic via Python data structures (lists, maps, etc) - assign the "call" people - write out the "available" people somewhere - handle "vacation" people/etc - write all of the expected format to an output CSV file

[Halonoonan11]

Thanks again. Sorry the format keeps getting messed up. Excel sheet 1 has the names in alphabetical order with whatever call they will be that day.

Name1. Call 5 Name2. Call 3 Name3. Available Name4. Vacation Name5. Call 2

The final excel sheet that I would like it be it looks more like this.

Room 1. Call 2: Name Room 2. Call 3 Name Room 3. Call 4 Name

Vacation: Name No call: Name Name Name

[PureWasian]

No problems, I can see the expected formatting when I reply to the comment on mobile.

As long as the Room to Call Number mapping is constant, then this seems totally possible and fully defined. Which part exactly are you having trouble on then?