Did John Doe manage to complete his 'masterpiece' in Se7en?

John Doe planned this meticulously for a very long time, and with the exception of that small glitch where Somerset and Mills find his apartment a bit too early, it's safe to say his plan is carried out. However, Doe's plan involves 7 victims representing each sin, but not necessarily performing them or dying for them:

• The Gluttony victim was indeed killed by Doe for his sin by being force-fed.
• The Greed victim was killed somewhat indirectly by Doe, also for embodying his sin.
• The Pride victim also embodied her sin, but was presumably faced with a choice and chose death herself. It's not made entirely clear in the film, but it's possible she could've lived. It's also possible that this one was rushed or improvised after Doe was tracked down by Somerset and Mills and had to change his plans.
• The Sloth victim was punished for his sin as well, but he's not dead yet (although braindead and basically a living corpse). His sin of Sloth was also rather forced upon him by Doe.
• The Lust victim was the prostitute, but the guy who actually embodies the sin of Lust is still alive (although traumatized and branded for life for killing her).
• The Envy victim is Mills' wife, although the sin's perpetrator is Doe himself.
• The Wrath victim is Doe, now with Mills embodying the sin and suffering the consequences.

As you can see, the master plan was never as straight forward as '7 people dying for their sins' but rather a complex admonition involving 7 victims and the 7 deadly sins, that eventually loops in on itself (with Doe and Mills playing a part in it: Doe being envious because he's unable to live a normal life in the sick world he's in, and Mills representing the law's inability to cure it). Doe wanted his master plan to be "puzzled over and studied", and now, as Somerset realizes, he's certainly going to achieve that.

I love that Mills only fires 6 rounds into Doe at the film's end; only 6 people, (the Gluttony, Greed, Sloth, Lust, Pride and Envy victims/sinners) were punished. Another take on the outcome is that technically 7 people DID die. Face it: the sloth victim probably didn't make it long after the doc said he "still has Hell to look forward to" and in addition to Mills' wife and unborn child also falling victim to Doe, that makes seven deceased. Hope this helps, or at least intrigues someone.

You are right. Mills is still alive but is as good as dead. As you can see in the whole movie that Mill's has bad temper which represents wrath. The only thing capable of calming him was his wife. You can tell how patient he was around her when the subway train came and other instances. Having her killed in his own case has left him good as dead (you know that kind of people who are left with nothing else to live with). So, eventually he is also punished but with a pain greater than any other sinners.

Yes. I believe he did. But I think everyone is downplaying the killing of Mill’s wife. Doe planned this for years. Mills volunteered to join this unit (as mentioned in the beginning). Which means Doe wasn’t expected him (which is why Doe called saying he has to make changes). Every victim killed indeed committed a deadly sin themselves. Sloth more than likely died a few days later. And as Somerset said, dismissing Doe’s actions would be downplaying him. I believe Doe lied to Mills and Doe was in fact wrath. I just don’t know how Mill’s wife would be envy. Maybe she was envious of her husband. She sacrificed her life and job she loved to relocated to a terrible new home. That’s what I think. Because with the theories mentioned above you have one deadly sinner who is still alive, and an innocent victim dead. Which in the car ride there Doe said no one he killed was innocent (and he just left from killing Mills wife). I would love to hear some thoughts from anyone who agrees.