Mr. Boddy was recently on a trip to London when he unfortunately met with his untimely demise... But whodunnit?? In the spirit of the game Clue (a murder mystery game originally called Cluedo, created by Anthony E Pratt from Birmingham, England in 1949), follow the clues to figure out who committed this dastardly deed, where the crime was committed, and which weapon was used!
*** Once you have all 3 answers, enter your answers into the Clue! Macro to see if your sleuthing is correct! You can also spot check any of your 3 answers in the macro as you go along... ***
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #136
Bennett Boddy
+1 555 867 5309
Willow White
+44 20 7946 0686
Scarlett Smith
+44 20 7946 0540
Paul Plum
+44 20 7946 0055
Paulina Peacock
+44 20 7946 0130
George Green
+44 20 7946 0356
Matthew Mustard
+44 20 7946 0801
Phone Directory
02/10/2018 10:37am
26116029
442079460540
15558675309
A little birdie told me you are going to be on this side of the pond this week, you rogue
02/10/2018 10:38am
125315035
442079460540
15558675309
I sincerely hope you are planning to pay me back for last time
02/10/2018 10:46am
106072568
15558675309
442079460540
Heh, why yes, I am going to be in town… :)
02/10/2018 10:48am
23474531
15558675309
442079460540
You free for a drink? I hear The Conservatory Bar has a splendid view of the city…
02/10/2018 11:08am
150391236
442079460540
15558675309
So you can stick me with the bill again and duck out the back door?? ABSOLUTELY NOT. >:(
02/10/2018 11:09am
55045190
442079460540
15558675309
But I will meet you. I'm performing at Queen Elizabeth Hall this weekend.
02/10/2018 11:33am
132410554
15558675309
442079460540
When?
02/10/2018 11:44am
730429
442079460540
15558675309
06 Oct 18 at 14:00
02/10/2018 11:45am
35628755
442079460540
15558675309
Bring me my money, or I swear, all the Queen's horses and all the Queen's men won't be able to put you back together again...
05/10/2018 11:13am
161145769
15558675309
442079460055
05/10/2018 11:15am
50918749
15558675309
442079460055
You're still at the National Poetry Library, right? I'll swing by and say hello!
05/10/2018 11:16am
77327538
15558675309
442079460055
Maybe we could check out that billiards place again, Shades Snooker club?
05/10/2018 11:37am
84204240
442079460055
15558675309
Not interested.
05/10/2018 11:59am
172627695
15558675309
442079460055
Awww, come on. You're not still upset about the World Cup Finals are you?
05/10/2018 12:15pm
120545262
442079460055
15558675309
Yes
05/10/2018 12:31pm
100780274
15558675309
442079460055
That was an accident! How was I supposed to know that it was a $10,000 bottle of liquor?
05/10/2018 12:53pm
43563438
442079460055
15558675309
Check the price list, perhaps?
05/10/2018 12:57pm
6463028
15558675309
442079460055
Well surely, they should have known I meant the cheaper one just below it. I still blame that waiter.
05/10/2018 01:01pm
27544734
442079460055
15558675309
You know what? I changed my mind.
05/10/2018 01:02pm
44959878
442079460055
15558675309
Let's meet up
05/10/2018 01:03pm
100428063
442079460055
15558675309
07 Oct 18 at 13:30
05/10/2018 01:10pm
162123026
15558675309
442079460055
Great! Where to?
05/10/2018 01:24pm
10547306
442079460055
15558675309
There's a $10,000 tab with your name on it at that bar in Lambeth.
05/10/2018 01:25pm
169962652
442079460055
15558675309
And unfortunately, the exchange rate is not currently in your favour.
05/10/2018 01:48pm
109936746
15558675309
442079460055
…
05/10/2018 02:02pm
77086856
15558675309
442079460055
Oh shoot, looks like I'm already booked for something at that time. Rain check?
05/10/2018 02:26pm
93394175
442079460055
15558675309
Riiiiiight
05/10/2018 02:27pm
29844314
442079460055
15558675309
If you're not there, I WILL track you down. You do know I have a whole realm of academic and research resources at my disposal, right?
05/10/2018 02:34pm
29422228
15558675309
442079460055
:|
05/10/2018 02:35pm
150381595
15558675309
442079460055
Lambeth it is.
07/10/2018 07:59am
135933360
15558675309
442079460801
07/10/2018 08:16am
36868850
442079460801
15558675309
You know I don't like being called that. Also, it's Colonel.
07/10/2018 08:39am
195961104
15558675309
442079460801
07/10/2018 08:57am
70682780
442079460801
15558675309
What do you want now?
07/10/2018 09:18am
115582972
15558675309
442079460801
Can't a guy just check in on a friend?
07/10/2018 09:29am
162742484
442079460801
15558675309
No.
07/10/2018 09:30am
152932046
442079460801
15558675309
And we're not friends
07/10/2018 09:39am
5680775
15558675309
442079460801
Okay ouch. I probably deserve that…
07/10/2018 09:50am
35873481
442079460801
15558675309
You do.
07/10/2018 10:02am
84295052
15558675309
442079460801
07/10/2018 10:23am
9853857
442079460801
15558675309
If you are referring to the 3000 quid you owe me for New Years Eve last year… then yes I want my money, but no, it won't help.
07/10/2018 10:34am
54314029
15558675309
442079460801
07/10/2018 10:35am
4701315
15558675309
442079460801
08 Oct 18 at 20:00
07/10/2018 10:36am
115417055
15558675309
442079460801
Work for you?
07/10/2018 11:00am
47203696
442079460801
15558675309
As long as you disappear immediately afterwards? Fine.
07/10/2018 11:09am
38731557
15558675309
442079460801
It's a date! ;)
07/10/2018 11:33am
10684511
442079460801
15558675309
No.
04/10/2018 02:25pm
9870859
442079460130
15558675309
Why hello love - was that you I just saw crossing the street in Picadilly?
04/10/2018 02:28pm
84104898
15558675309
442079460130
Uh, hey Paulina… how are you?
04/10/2018 02:31pm
187398206
442079460130
15558675309
04/10/2018 02:32pm
21455485
442079460130
15558675309
The same Bennett Boddy who swore he would remedy that little *incident* in Canterbury next time we crossed paths!
04/10/2018 02:45pm
32319988
15558675309
442079460130
Now look, Paulina… in my defense, you failed to mention there was a Mr. Peacock in the picture...
04/10/2018 03:04pm
155161076
442079460130
15558675309
That does not change the fact that you and your whiskeyed lack of inhibitions punched both my husband AND a priceless vase.
04/10/2018 03:16pm
54117895
15558675309
442079460130
Priceless?? I thought you said it was from Harrod's?!?
04/10/2018 03:38pm
183691953
442079460130
15558675309
Darling, I do NOT shop at Harrod's.
04/10/2018 03:39pm
142657839
442079460130
15558675309
I was referring to King Herod I of Judea... it was a part of his coronation collection. Ringing a bell?
04/10/2018 03:40pm
132574015
442079460130
15558675309
Regardless, the only priceless thing I want to see is the look of contrition on your face when I see you at this weekend's Peacock Society Annual Auction at The Ballroom Southbank
04/10/2018 03:41pm
196378142
442079460130
15558675309
with a check for 1 million GBP. I would recommend using it to bid on the trip to Laos.
04/10/2018 03:42pm
130238885
442079460130
15558675309
I hear it's lovely this time of year. And very far away from here.
04/10/2018 03:43pm
166331019
442079460130
15558675309
06 Oct 18 at 21:00
04/10/2018 03:44pm
173551456
442079460130
15558675309
DO NOT BE LATE...
05/10/2018 04:49pm
143153121
15558675309
442079460356
I received your email earlier this week, Reverend… as it turns out, I'm in London now!
05/10/2018 05:07pm
61462103
442079460356
15558675309
I sincerely pray, for your sake, that you are joking.
05/10/2018 05:15pm
175687390
15558675309
442079460356
Whatever for??
05/10/2018 05:28pm
99517814
442079460356
15558675309
Notwithstanding the debt you owe to myself, to God, and to several of your countrymen…
05/10/2018 05:29pm
104189524
442079460356
15558675309
But to show up on these streets again after what you did to my daughter on her wedding day?
05/10/2018 05:30pm
130190496
442079460356
15558675309
Willow is a God-fearing woman, Bennett, but I believe God himself fears what she might do to you if she were to happen upon you...
05/10/2018 05:52pm
127772094
15558675309
442079460356
Aw, now surely she's not still that mad.
05/10/2018 06:00pm
32332032
442079460356
15558675309
Ere I quote: "The depths of the Mariana Trench are not deep enough to bury him."
05/10/2018 06:24pm
30336997
15558675309
442079460356
… Oh.
05/10/2018 06:48pm
13571661
442079460356
15558675309
I'm giving a service for the kids at The Fulham Study this Sunday. You should come. Cleanse your soul & such.
05/10/2018 06:49pm
88118551
442079460356
15558675309
07 Oct 18 at 10:00
05/10/2018 06:58pm
182299193
15558675309
442079460356
05/10/2018 07:14pm
34689560
442079460356
15558675309
I will ask. God help you if she runs into you before then, however…
05/10/2018 10:07pm
130091471
442079460686
15558675309
YOU ROTTEN SCOUNDREL
05/10/2018 10:08pm
176002043
442079460686
15558675309
HOW DARE YOU SHOW UP HERE
05/10/2018 10:09pm
83049123
15558675309
442079460686
…
05/10/2018 10:10pm
183243749
442079460686
15558675309
I SWORE IF I EVER SAW YOU AGAIN
05/10/2018 10:11pm
64320735
15558675309
442079460686
Now Willow, I am SO sorry…
05/10/2018 10:12pm
165922768
442079460686
15558675309
THAT I WOULD MAKE SURE YOU NEVER SAW THE LIGHT OF DAY AGAIN
05/10/2018 10:13pm
197900682
15558675309
442079460686
It was a surefire bet!
05/10/2018 10:14pm
195857658
442079460686
15558675309
AND THAT I WOULD BURY YOU SO DEEP
05/10/2018 10:15pm
115818407
15558675309
442079460686
How was I supposed to know the horse had tripped over a fence the day before and had a busted ankle??
05/10/2018 10:16pm
38486311
442079460686
15558675309
THAT THE VULTURES WOULD NEVER FIND YOUR BODY
05/10/2018 10:17pm
124852318
15558675309
442079460686
Ascot really should do a better job of reporting these things.
05/10/2018 10:18pm
17338064
15558675309
442079460686
And I swear, I didn't realize that money was meant for the honeymoon…
05/10/2018 10:19pm
96675355
442079460686
15558675309
I HAD TO SPEND MY HONEYMOON IN ALBEQUERQUE... ALBEQUERQUE!!!
05/10/2018 10:20pm
98320603
15558675309
442079460686
…
05/10/2018 10:41pm
8397911
15558675309
442079460686
How do you feel about Laos? Honeymoon V2?
05/10/2018 11:05pm
108464852
442079460686
15558675309
…
05/10/2018 11:08pm
180875999
442079460686
15558675309
I'm listening.
05/10/2018 11:10pm
160779101
15558675309
442079460686
Alright. Meet me at Fulham Study this Sunday. Your father will be there, so, um, be nice?
05/10/2018 11:11pm
176139739
15558675309
442079460686
07 Oct 18 at 10:00
05/10/2018 11:30pm
40115890
442079460686
15558675309
I make no promises.
Text Message Data from Mr. Boddy's Phone
QUESTION #1: WHO IS THE CULPRIT?
4189401094462949
MS31372
1452016131
Pain Reliever Tablets
11.69
4189401094462949
MS31372
2301852013
Cat Food
14.99
4189401094462949
MS31372
2023581429
Laundry Detergent
5.32
4189401094462949
MS31372
8765623749
Phone Screen Protector
7.99
4189401094462949
MS31372
3949586
Lighter
2.99
4189401094462949
MS31372
968472648
Whole Chicken
9.99
4189401094462949
MS31372
9968390294
Cereal
3.49
4189401094462949
MS31372
8573039992
Bananas
0.79
4189401094462949
MS31372
2892454667
Pork Chops
17.49
4189401094462949
MS31372
7542270275
Ice Lollies
8.64
4189401094462949
MS31372
1915931973
Greeting Card
6.99
4189401094462949
HR91872
1.20355E+20
Umbrella
12.69
4189401094462949
HR91872
9.54041E+20
Clock
55.89
4189401094462949
HR91872
2.34029E+20
Crystal Candlestick
89.49
4189401094462949
HR91872
7.40304E+20
Rainboots
49.99
4189401094462949
PT72111
6.02589E+17
Hunting Knife
37.99
4189401094462949
PT72111
3.83114E+17
Copper Pipe
62.99
4189401094462949
PT72111
2.61573E+17
Insect Repellent
4.99
4189401094462949
BT48766
4.46435E+16
Socks
14.44
4189401094462949
BT06461
3.28101E+16
Nylon Rope
17.98
4189401094462949
BT06461
2.2915E+16
Light Bulbs
13.97
4189401094462949
BT06461
2.62949E+16
Formula
45.54
4189401094462949
BT06461
6.03461E+15
Batteries
13.96
4189401094462949
BT06461
2.02192E+16
Plasters
8.54
2998363896648291
MS31372
2023581429
Laundry Detergent
5.32
2998363896648291
MS31372
10299867
Tea
1.99
2998363896648291
MS31372
7757589393
Mascara
24.99
2998363896648291
MS31372
8431652781
Tissue
5.29
2998363896648291
MS31372
7542270275
Ice Lollies
8.64
2998363896648291
MS31372
7594844479
Birthday Candles
3.99
2998363896648291
HR91872
3.11791E+20
Perfume
79.99
2998363896648291
HR91872
5.92762E+20
Duvet Cover
161.27
2998363896648291
HR91872
2.34029E+20
Crystal Candlestick
89.49
2998363896648291
HR91872
5.56071E+20
Tablecloth
25.85
2998363896648291
BT48766
1.34317E+16
Sunglasses
12.79
2998363896648291
BT48766
1.89915E+16
Storage Containers
16.14
2998363896648291
BT48766
1.32566E+16
Printer Ink
49.99
2998363896648291
BT48766
1.19716E+16
Bracelets
10.17
2998363896648291
BT48766
5.366E+16
Shoelaces
5.36
2998363896648291
BT48766
7.79521E+16
Scarf
17.01
2998363896648291
BT76204
2.2915E+16
Light Bulbs
13.97
2998363896648291
BT76204
7.03521E+16
Diapers
37.04
2998363896648291
BT76204
1.77977E+16
Rubbish Bags
12.08
2998363896648291
BT76204
6.85932E+16
Toothpaste
11.94
2998363896648291
BT76204
3.08022E+16
Magazine
5
4118144299736992
MS90434
1452016131
Pain Reliever Tablets
11.69
4118144299736992
MS90434
2023581429
Laundry Detergent
5.32
4118144299736992
MS90434
1523502535
Granola Bars
3.5
4118144299736992
MS90434
8765623749
Phone Screen Protector
7.99
4118144299736992
MS90434
8487376278
Candles
6.49
4118144299736992
MS90434
3949586
Lighter
2.99
4118144299736992
MS90434
8284769450
Deli Sandwich
7.49
4118144299736992
MS90434
968472648
Whole Chicken
9.99
4118144299736992
MS90434
10299867
Tea
1.99
4118144299736992
MS90434
3939869030
Lipstick
17.49
4118144299736992
MS90434
8868488830
Gum
0.99
4118144299736992
HR91872
2.6247E+20
Pillow
126
4118144299736992
HR91872
1.20355E+20
Umbrella
12.69
4118144299736992
HR91872
9.54041E+20
Clock
55.89
4118144299736992
HR91872
1.89006E+20
Area Rug
381.19
4118144299736992
HR91872
3.11791E+20
Perfume
79.99
4118144299736992
HR91872
7.40304E+20
Rainboots
49.99
4118144299736992
HR91872
7.71806E+20
Carving Knife
89.99
4118144299736992
HR91872
8.96039E+20
Flower Pot
9.99
4118144299736992
PT57059
9.729E+17
Camping Rope
89.97
4118144299736992
PT57059
6.02589E+17
Hunting Knife
37.99
4118144299736992
PT57059
8.41198E+17
Sleeping Bag
75.19
4118144299736992
PT57059
5.51021E+17
Water Filter
17.88
4118144299736992
PT57059
2.12528E+16
Socket Wrench Set
18.99
4118144299736992
PT57059
9.94544E+17
Fishing Tackle Box
14.99
4118144299736992
PT57059
5.59042E+17
Fishing Pole
58.99
4118144299736992
BT06461
1.89915E+16
Storage Containers
16.14
4118144299736992
BT06461
9.53174E+16
Extension Cord
13.59
4118144299736992
BT48766
7.79521E+16
Scarf
17.01
4118144299736992
BT48766
4.16571E+16
Cake Knife
13.99
4118144299736992
BT48766
7.03521E+16
Diapers
37.04
4118144299736992
BT48766
1.77977E+16
Rubbish Bags
12.08
4118144299736992
BT48766
6.03461E+15
Batteries
13.96
4118144299736992
BT06461
5.39444E+16
Robe
26.95
4118144299736992
BT06461
9.46542E+16
Paper Towels
5.95
4118144299736992
BT76204
5.13977E+16
Picture Frame
14.99
4118144299736992
BT76204
2.40032E+16
Candlestick
23.99
4118144299736992
BT76204
9.4765E+16
Dog Leash
11.99
9288236467079501
MS75337
2301852013
Cat Food
14.99
9288236467079501
MS75337
1523502535
Granola Bars
3.5
9288236467079501
MS75337
3939869030
Lipstick
17.49
9288236467079501
MS75337
8573039992
Bananas
0.79
9288236467079501
MS75337
7542270275
Ice Lollies
8.64
9288236467079501
HR91872
2.6247E+20
Pillow
126
9288236467079501
HR91872
1.20355E+20
Umbrella
12.69
9288236467079501
HR91872
1.89006E+20
Area Rug
381.19
9288236467079501
HR91872
8.96039E+20
Flower Pot
9.99
9288236467079501
PT57059
3.29945E+17
Portable Air Compressor
59.99
9288236467079501
PT57059
7.99572E+17
Lead Pipe
31.95
9288236467079501
PT57059
9.94544E+17
Fishing Tackle Box
14.99
9288236467079501
PT57059
5.59042E+17
Fishing Pole
58.99
9288236467079501
BT76204
1.34317E+16
Sunglasses
12.79
9288236467079501
BT76204
8.34995E+16
Whisk
5.94
9288236467079501
BT76204
9.53174E+16
Extension Cord
13.59
9288236467079501
BT76204
6.30701E+16
Kitchen Timer
6.3
9288236467079501
BT76204
7.79521E+16
Scarf
17.01
9288236467079501
BT76204
9.5208E+16
Doll
12.88
2748931237613895
MS50165
3661043023
USB Charger
11.99
2748931237613895
MS50165
1452016131
Pain Reliever Tablets
11.69
2748931237613895
MS50165
1151499855
Headphones
14.99
2748931237613895
MS50165
1523502535
Granola Bars
3.5
2748931237613895
MS50165
8284769450
Deli Sandwich
7.49
2748931237613895
MS50165
968472648
Whole Chicken
9.99
2748931237613895
MS50165
3939869030
Lipstick
17.49
2748931237613895
MS50165
8484859939
Sunscreen
8.49
2748931237613895
MS50165
8868488830
Gum
0.99
2748931237613895
PT57059
8.41198E+17
Sleeping Bag
75.19
2748931237613895
PT57059
3.83114E+17
Copper Pipe
62.99
2748931237613895
PT57059
6.42309E+17
Tent
127.27
2748931237613895
PT57059
9.94544E+17
Fishing Tackle Box
14.99
2748931237613895
PT57059
4.3467E+17
Pipe Wrench
32.99
2748931237613895
BT76204
3.47149E+16
Watercolor Paints
14.92
2748931237613895
BT76204
1.89915E+16
Storage Containers
16.14
2748931237613895
BT76204
9.53174E+16
Extension Cord
13.59
2748931237613895
BT76204
6.30701E+16
Kitchen Timer
6.3
2748931237613895
BT06461
8.49624E+16
Ballpoint Pens
3.2
2748931237613895
BT06461
5.366E+16
Shoelaces
5.36
2748931237613895
BT06461
1.84107E+16
TV Remote
9
2748931237613895
BT06461
3.28101E+16
Nylon Rope
17.98
2748931237613895
BT76204
5.39444E+16
Robe
26.95
2748931237613895
BT76204
2.02192E+16
Plasters
8.54
2748931237613895
BT76204
9.46542E+16
Paper Towels
5.95
2748931237613895
BT76204
9.4765E+16
Dog Leash
11.99
3294351388677880
MS75337
1477189526
Apple Cider Vinegar
14.05
3294351388677880
MS75337
8765623749
Phone Screen Protector
7.99
3294351388677880
MS75337
8474736940
Candy
0.99
3294351388677880
MS75337
7757589393
Mascara
24.99
3294351388677880
MS75337
8484859939
Sunscreen
8.49
3294351388677880
MS75337
8431652781
Tissue
5.29
3294351388677880
MS75337
1915931973
Greeting Card
6.99
3294351388677880
MS75337
353834735
Carving Knife
28.99
3294351388677880
MS75337
7594844479
Birthday Candles
3.99
3294351388677880
HR91872
2.6247E+20
Pillow
126
3294351388677880
HR91872
1.20355E+20
Umbrella
12.69
3294351388677880
HR91872
9.54041E+20
Clock
55.89
3294351388677880
BT06461
6.30701E+16
Kitchen Timer
6.3
3294351388677880
BT06461
8.49624E+16
Ballpoint Pens
3.2
3294351388677880
BT06461
7.79521E+16
Scarf
17.01
3294351388677880
BT06461
3.28101E+16
Nylon Rope
17.98
3294351388677880
BT06461
7.03521E+16
Diapers
37.04
3294351388677880
BT06461
6.85932E+16
Toothpaste
11.94
3294351388677880
BT06461
9.5814E+16
Watering Can
13.9
3294351388677880
BT06461
9.4765E+16
Dog Leash
11.99
Purchase Details
QUESTION #2: WHAT WAS THE WEAPON?
The London Kitchen
Caterer
51.495531
-0.115524
The Ballroom Southbank
Event Venue
51.506283
-0.112956
Conservatory Bar
Bar
51.501971
-0.023116
Queen Elizabeth Hall
Concert Venue
51.506697
-0.116198
The Fulham Study
School
51.471132
-0.207069
The National Poetry Library
Library
51.505976
-0.116546
Shades Snooker & Billiard Club
Pool Hall
51.480507
-0.026868
CellarDoor
Bar
51.511688
-0.119360
Quarter Bar & Lounge
Bar
51.505317
-0.088256
Disappearing Dining Club
Restaurant
51.519391
-0.098316
Instagram Post Locations
Tower Bridge
51.505431
-0.075423
Point of Discovery
QUESTION #3: WHERE IS THE SCENE OF THE CRIME?
RecordID|TransID|TransDate|TransTime|TransCode|CardNumber|ExpDate|CardholderName|Address|City|Country|Zip|StoreID|CardType|Amount
0000000001|0000000001|10042018|1945|IX|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|MS50165|VISA|0000002697
0000000002|0000000002|10042018|1725|IX|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|BT06461|VISA|0000003554
0000000003|0000000003|10052018|0175|IP|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|MS50165|VISA|0000002098
0000000004|0000000004|10052018|0228|IX|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|PT72111|VISA|0000011097
0000000005|0000000005|10052018|1749|IX|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|BT76204|VISA|0000005343
0000000006|0000000006|10062018|1749|IX|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|MS50165|VISA|0000003867
0000000007|0000000007|10062018|1515|IP|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|PT72111|VISA|0000020246
0000000008|0000000008|10062018|1417|IP|2748XXXXXXXX3895|1219|Willow White|20 Brighton Terrace|Brixton|UK|SW9 8DL|BT76204|VISA|0000005095
0000000009|0000000001|10042018|1555|IP|2998XXXXXXXX8291|0719|Paul Plum|11 Manchester Grove|Isle of Dogs|UK|E14 3BG|BT76204|DISC|0000008003
0000000010|0000000002|10052018|1658|IP|2998XXXXXXXX8291|0719|Paul Plum|11 Manchester Grove|Isle of Dogs|UK|E14 3BG|BT48766|DISC|0000003254
0000000011|0000000003|10062018|1156|IP|2998XXXXXXXX8291|0719|Paul Plum|11 Manchester Grove|Isle of Dogs|UK|E14 3BG|MS31372|DISC|0000005022
0000000012|0000000004|10062018|1523|IP|2998XXXXXXXX8291|0719|Paul Plum|11 Manchester Grove|Isle of Dogs|UK|E14 3BG|HR91872|DISC|0000035660
0000000013|0000000005|10062018|0215|IX|2998XXXXXXXX8291|0719|Paul Plum|11 Manchester Grove|Isle of Dogs|UK|E14 3BG|BT48766|DISC|0000007892
0000000014|0000000001|10052018|1022|IS|3294XXXXXXXX7880|1220|Scarlett Smith|10 Lansdowne Cres|London|UK|W11 2NJ|MS75337|MSCRD|0000000399
0000000015|0000000002|10052018|0853|IX|3294XXXXXXXX7880|1220|Scarlett Smith|10 Lansdowne Cres|London|UK|W11 2NJ|BT06461|MSCRD|0000005240
0000000016|0000000003|10062018|1128|IP|3294XXXXXXXX7880|1220|Scarlett Smith|10 Lansdowne Cres|London|UK|W11 2NJ|MS75337|MSCRD|0000009778
0000000017|0000000004|10062018|0148|IX|3294XXXXXXXX7880|1220|Scarlett Smith|10 Lansdowne Cres|London|UK|W11 2NJ|HR91872|MSCRD|0000019458
0000000018|0000000005|10062018|2247|IS|3294XXXXXXXX7880|1220|Scarlett Smith|10 Lansdowne Cres|London|UK|W11 2NJ|BT06461|MSCRD|0000006696
0000000019|0000000001|10032018|1642|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|BT76204|MSCRD|0000005097
0000000020|0000000002|10042018|1040|IP|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|HR91872|MSCRD|0000022996
0000000021|0000000003|10042018|0755|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|PT57059|MSCRD|0000009297
0000000022|0000000004|10042018|2031|IP|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|BT06461|MSCRD|0000003290
0000000023|0000000005|10052018|1232|IP|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|MS90434|MSCRD|0000003046
0000000024|0000000006|10052018|1744|IP|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|HR91872|MSCRD|0000043708
0000000025|0000000007|10052018|2256|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|PT57059|MSCRD|0000001788
0000000026|0000000008|10052018|0229|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|BT48766|MSCRD|0000009408
0000000027|0000000009|10062018|1340|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|MS90434|MSCRD|0000004547
0000000028|0000000010|10062018|1137|IX|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|HR91872|MSCRD|0000013869
0000000029|0000000011|10062018|0219|IS|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|PT57059|MSCRD|0000020315
0000000030|0000000012|10062018|2030|IP|4118XXXXXXXX6992|0319|Paulina Peacock|21 Denbridge Rd|Bromley|UK|BR1 2AG|BT06461|MSCRD|0000002973
0000000031|0000000001|10042018|0168|IX|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|BT06461|VISA|0000006804
0000000032|0000000002|10052018|1634|IP|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|MS31372|VISA|0000004739
0000000033|0000000003|10052018|1055|IX|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|BT06461|VISA|0000003195
0000000034|0000000004|10062018|1458|IX|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|MS31372|VISA|0000004298
0000000035|0000000005|10062018|1532|IP|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|HR91872|VISA|0000020806
0000000036|0000000006|10062018|1237|IP|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|PT72111|VISA|0000010597
0000000037|0000000007|10062018|1027|IP|4189XXXXXXXX2949|0520|George Green|123 Camden St|Camden Town|UK|NW1 0HX|BT48766|VISA|0000001444
0000000038|0000000001|10052018|1657|IX|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|MS81706|VISA|0000000943
0000000039|0000000002|10052018|0136|IX|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|BT76204|VISA|0000002583
0000000040|0000000003|10062018|2244|IX|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|MS75337|VISA|0000003598
0000000041|0000000004|10062018|1022|IX|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|HR91872|VISA|0000052987
0000000042|0000000005|10062018|0227|IS|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|PT57059|VISA|0000016592
0000000043|0000000006|10062018|1352|IX|9288XXXXXXXX9501|1120|Matthew Mustard|5 Circus St|London|UK|SE10 8SG|BT76204|VISA|0000004268
Credit Card Statement Summary Data
"Phone Number"
True
True
True
True
True
True
False
True
False
upper
Simple
Message
Contains
Oct
Contains([Message],"Oct")
Suspect = if Contains([From Name],'Boddy') then [To Name] else [From Name] endif...
2018-10-07 15:00:00
Murder Time
Error
Time difference = DateTimeDiff([Message],[Murder Time],'minutes')
Time differenc...
Time difference - Ascending
First
1
First 1
C:\ProgramData\Alteryx\Engine\Engine_85120_6090bdbec550490d9392baffbc24f4df_\Engine_76000_3e9769e84e8243fe8863fffc8f09ec0e_.yxdb
Single
Profile
Prime Suspect = Plum
Field1
Last
Field1
Simple
CardholderName
Contains
Plum
Contains([CardholderName],"Plum")
FirstRow
Warn
CreditCardNumber = Left([CreditCardNumber],4)+'XXXXXXXX'+right([CreditCardNumber...
Item
Match
Warn
CreditCardNumber_Matched
Match:
.*Candlestick.*|.*Knife.*|....
Simple
CreditCardNumber_Matched
IsTrue
[CreditCardNumber_Matched] = 1
Kilometers
Latest:TeleAtlas_UK
Double
Double
First
1
First 1
C:\ProgramData\Alteryx\Engine\Engine_85120_6090bdbec550490d9392baffbc24f4df_\Engine_76000_63109acbdb414755bebb841bee8bc1e1_.yxdb
Weapon = Candlestick
C:\ProgramData\Alteryx\Engine\Engine_85120_6090bdbec550490d9392baffbc24f4df_\Engine_76000_e3224ef99d1542cbb1c458c4555ca7df_.yxdb
Single
Map
Location = Lounge
HINT (Only if you're stuck!)
Mr. Boddy's contacts are all very consistent: the format used in all text messages any time a datetime is referenced will be 01 Jan 18 at 17:00.
For help with datetime formats, check out the following Help link:
https://help.alteryx.com/11.8/index.htm#Reference/DateTimeFunctions.htm
ENTER YOUR SOLUTIONS HERE!
C:\ProgramData\Alteryx\Engine\Engine_85120_6090bdbec550490d9392baffbc24f4df_\Engine_76000_0289e32b36a04dcc8434548b942d3c87_.yxdb
Single
Report
Check Answer Here!
Lounge
Professor Plum
Candlestick
ClueAnswerMacro (71)
HINT (Only if you're stuck!)
Some of the digits in the credit card numbers in the Summary file are masked for privacy. You'll need to convert the non-masked numbers in the detail file to a format that is equivalently masked in order to match the credit card owners (from the Summary file) to the credit card transactions (Purchase Details file).
HINT (Only if you're stuck!)
Convert the various locations & the point of discovery to Spatial Objects first, then determine how far each Instagram post location is from the Tower Bridge location. You can accomplish this several ways, including (and certainly not limited to!):
a) Distance between locations, then filter for less than 1km
b) Trade Area of 1km, then Spatial Match
c) Find Nearest Tool
Horizontal
Cluedo Start