ATWJE - Lenny Leedy, the Excel Guru

Episode: 00116

Release Date: July 18, 2022

Description: Don’t ask our next guest his favorite Excel formula (there’s too many to choose); in this week’s episode Leonard (Lenny) Leedy tells us all bout how Excel can make your analysis easier and how his skills made him an invaluable addition to any team he was on.  Lenny’s badge stories include phone analysis for embezzlement cases and drug trafficking organizations as well as providing lead tasking assistance on the Boston Marathon Bombing investigation. Lenny has twenty-five years of varied Law Enforcement experience including Uniform, K-9, SWAT, Vice and Narcotics. Lenny has gone onto be an instructor and course developer for multiple groups (Federal Law Enforcement Training Center and Multijurisdictional Counterdrug Task Force Training, among others). In addition to being an instructor, Lenny is an authorized reseller for Law Enforcement Investigative software developed by ACISS Systems.

We have a new segment called The Analysts of Tomorrow where we highlight up-and-coming analysts with exceptional potential in the field of law enforcement analysis. Got someone you'd like us to highlight? Let us know in the comments, or if you’d like to be featured in a future episode, please send us a recording (no more than 30 seconds) of who you think is an "Analyst of Tomorrow" and why to leapodcasts@gmail.com. 

CHALLENGE: There are Easter eggs in one of the tables of the chapter that Jason wrote for the IACA textbook. First-person to email us at leapodcasts@gmail.com about what the Easter eggs are will receive a $20 gift card from us. Happy hunting!

Name Drops: Chief Curt Zinger/Mickey Stepinoff (00:16:33), Steve Gottlieb (00:26:51), Cindy Leedy (01:17:55)

Public Service Announcements:
Small Steps with Seth Potts (https://www.youtube.com/playlist?list=PLqQ0bCMYfEp5-ma42q5SQVlwcFOMD5byv

Related Links: https://www.rff.com/sample_criminal_analysis.php ,www.rff.com , www.aciss.com, https://www.tampabay.com/news/religion/the-rev-henry-lyons-forced-out-as-pastor-of-tampa-church-amid-accusations/2327607/ , https://en.wikipedia.org/wiki/Boston_Marathon_bombing , https://www.fox13news.com/news/president-obama-commutes-sentence-of-st-petersburg-man , http://www.clarkprosecutor.org/html/death/US/chandler1275.ht

Association(s) Mentioned: IALEIA, National Fusion Center Association, LEIU

Vendor(s) Mentioned: ACISS, RF Flow, I2

Contact: 727-397-6882 Desk, lwleedy@aciss.com

Transcript: https://mcdn.podbean.com/mf/web/xd3vkh/Lenny_Leedy_transcript.pdf 

Podcast Writer: Mindy Duong

Podcast Researcher: 

Theme Song: Written and Recorded by The Rough & Tumble. Find more of their music at www.theroughandtumble.com.

Logo: Designed by Kyle McMullen. Please visit www.moderntype.com for any printable business forms and planners. 

Podcast Email: leapodcasts@gmail.com  

Podcast Webpage: www.leapodcasts.com  

Podcast Twitter: @leapodcasts

YouTube Version: https://youtu.be/qTUxtafqI8s 

00:00:17 – Introducing Lenny
00:06:36 – Bringing Computers to Investigations
00:08:25 – Discovering Pivot Tables
00:21:46 – Link Charting with RF Flow
00:23:46 – Analyzing with Excel
00:32:30 – Break:  Small Steps with Seth Potts
00:34:29 – Calculating Age in Excel
00:50:21 – Multi-Target Analysis:  Henry Lyons Case
00:55:22 – Using ACISS in Boston Marathon Bombing Case
01:06:35 – Studying a 1,000 calls a day:  Romeo Mathis Case
01:13:14 – Personal Interests:  Banjo & Wilderness Trainer
01:21:01 – Words to the World