
1. Re: Logical solution required
Shinichiro Murakami Sep 15, 2018 2:19 PM (in response to Rajesh L M)Hi Rajesh
According to your logic and data, nothing can be valid?
Let me know where I misunderstood.
Thanks,
Shin

wbs logic_SM_10.4.twbx 32.2 KB


2. Re: Logical solution required
Rajesh L M Sep 15, 2018 9:53 PM (in response to Shinichiro Murakami)Hi Shinichiro,
Thanks for the help.
yes you have bit misunderstood in logic:
wbs1 is valid because all activities have status completed for that wbs , similarly wbs 5
wbs 6 is valid because it has both eq02 and eq08 only once
wbs is valid only:
if all activities are completed under that wbs irrespective of multiple equ02 and equ08 / missing equ02 or equ08 (ex: wbs1 and wbs5)
if both equ02 and equ08 present once for that wbs irrespective of any status (ex: wbs6)
output(detail sheet) should look like this:
project wbs activity status code wbs Validity Reason for Invalidity project 1 wbs1 act1 completed eq.02 Valid project 1 wbs1 act2 completed eq.02 Valid project 1 wbs1 act3 completed eq.08 Valid project 1 wbs1 act4 completed eq.08 Valid project 1 wbs2 act5 completed eq.02 InValid Double eq.08 present project 1 wbs2 act6 completed eq.08 InValid Double eq.08 present project 1 wbs2 act7 completed eq.08 InValid Double eq.08 present project 1 wbs2 act18 not started eq.09 InValid Double eq.08 present project 1 wbs3 act8 not started eq.02 InValid eq.08 is missing project 1 wbs3 act9 completed eq.09 InValid eq.08 is missing project 1 wbs4 act10 not started eq.08 InValid eq.02 is missing project 1 wbs4 act11 completed eq.08 InValid eq.02 is missing project 1 wbs5 act12 completed eq.08 Valid project 1 wbs5 act13 completed eq.10 Valid project 2 wbs6 act14 completed eq.08 Valid project 2 wbs6 act15 In Progress eq.02 Valid project 2 wbs7 act16 completed eq.08 InValid eq.02 is missing project 2 wbs7 act17 not started eq.08 InValid eq.02 is missing project 2 wbs7 act19 completed eq.09 InValid eq.02 is missing project 2 wbs8 act20 not started eq.02 InValid eq.08 is missing 
3. Re: Logical solution required
Ankit Bansal Sep 16, 2018 12:28 AM (in response to Rajesh L M)Rajesh,
You can write logic something like below:
IF {fixed [Project],[Wbs] : count(if [Code]='eq.02' then [Code] end )} <= 1
and {fixed [Project],[Wbs] : count(if [Code]='eq.08' then [Code] end )}<=1
then 'Valid'
ELSEIF {fixed [Project],[Wbs] : countd(if ([Code]='eq.02' or [Code]='eq.08') then [Status] end )} = 1
and {fixed [Project],[Wbs] : Max(if ([Code]='eq.02' or [Code]='eq.08') then [Status] end )} = 'Completed'
then 'Valid'
ELSE 'Invalid'
end
In your example I am not sure why wbs2 is invalid, All the activities for eq02 and eq08 are compelted still u are saying invalid.
but you can tweak the conditions as per your requirement, hope you got some idea to write it.
Thanks,
Ankit Bansal

4. Re: Logical solution required
nazim zmirli Sep 16, 2018 1:29 AM (in response to Rajesh L M)For most difficulty levels, anything below "evil" or "extremely difficult", it doesn't pay to guess. You can deduce it all more easily than you can backtrack bad guesses. You do have to potentially find it false and backtrack  if you just write "5" in a likely square with no way to take it back, you're likely to get a failed puzzle.

5. Re: Logical solution required
Rajesh L M Sep 16, 2018 6:33 AM (in response to Ankit Bansal)Hi Ankit
wbs2 is invalid because eq.09 is not started and eq.08 exists twice.
Can you share the solution via twbx file?
Thanks

6. Re: Logical solution required
Ankit Bansal Sep 16, 2018 6:54 AM (in response to Rajesh L M)
wbs logic_v10.3.twbx 45.5 KB


7. Re: Logical solution required
Rajesh L M Sep 17, 2018 9:30 AM (in response to Rajesh L M)Hi Ankit,
Appreciate you help.
Is it possible to have Reason for Invalidity Column as well?
Thanks in adavnace