Challenge #440: Unmask the Saboteur

[cdwaraga]

Cool challenge. Here is my solution

Spoiler

[krishnakumare]

I have attached my solution

[nSpire]

Spoiler

 

[tammybrown_tds]

I found the element of the time of day to be irrelevant in finding the answer.

Spoiler

[a640687]

Spoiler

[Gem]

Really enjoyed this one! More murder mystery challenges, please! 

[alisonpitt]

Fun challenge! More murder mysteries, please!

Spoiler

[arizzio]

Spoiler

[Yogesh1795]

I found the 3 possible culprits, including answer, but don't know how the macro is deciding who is the murderer.

Wish this challenge would have one more hint like after reversing " first 4 letters of saboteur name look the same when you read it backward"

[AlexvanOs]

Fun challenge, but there's an error in the macro and some unneccesary hints. 

Spoiler

I had 12 suspects, but the macro also provides the correct answer with <12 suspects. There is no way the "Do you have enough suspects? We are expecting twelve" line will be the result because of the <= part in the bold part of the formula tool (8) of the macro below.

IF [Count] > 12
THEN "Too many suspects!!!"
ELSEIF [Count] <= 12
THEN "Elle Banna shakes and screams in pain!"
ElSE "Do you have enough suspects? We are expecting twelve"
ENDIF

Also, no need to parse the time when all incidents happen at night. Just filter the incidents beforehand and the only times that will pop up are night times. So I ignored that hint. 

Since I don't like to limit my flows to only work with the current data, I decided not to filter on incident count = 7, but instead I counted the total amount of incidents and the amount of incidents per employee and matched who was present for all incidents that way.