Challenge #417: Evaluation of Employee Working Hours

[ScottLewis]

My answer, fairly elegant this time, though it does rely on a quirk of the date format (for YYYY MM DD) type formats where MM and DD have enforced 0 in the first character date minimum and string minimum are the same so you don't have to fuss with conversions.)

Bonus question feels like a bit of data overreach as the data set doesn't have a majority of the relevant considerations for making that decision.

[Inactive User]

My Solution: 

Spoiler

Bonus: IJ345 - due to all shifts being below 4 hours and the lowest amount of shifts performed.

 

[achisman]

My Solution

[Reesetrain2]

All,

My solution:

Spoiler

 

Who should pickup more shifts:

Spoiler

 

[olga_strubbe]

Hi Akimasa, 

From what I can see, the total days are different because in the challenge solution from Nathan the total days are counted from the first day that employee worked - not all employees started work on Jan 1.  

Hope this helps :)  

[sar5760]

My solution:

Spoiler

  

[pchong]

Solution for my first challenge! 

[asultanov]

Spoiler

[Powerhouse_21]

Spoiler

[Chris-Nienart]

If the dataset were larger, I would have reimported the start file as a csv and used the First Row Contains Field Names option.

Also, does anyone else hate percentages stated on a 0-100 scale?  

Spoiler