During a recent murder mystery weekend, four games were played.

In one game Mrs Red used the spanner, but not in the library.

In another game the rope was used in the study, but not by Major Yellow.

During one game the gun was used in the conservatory, whilst in another game Dr Purple was not to be found in the library.

Major Yellow was never in the conservatory and Miss Beige never used the rope.

The lead piping may or may not have been used in the kitchen.

Can you determine who used what and where?