We're sunsetting PodQuest on 2025-07-28. Thank you for your support!
Export Podcast Subscriptions
cover of episode #151 Automating a coffee shop chain using self-taught coding skills with Eamonn Cottrell

#151 Automating a coffee shop chain using self-taught coding skills with Eamonn Cottrell

2024/11/22
logo of podcast freeCodeCamp Podcast

freeCodeCamp Podcast

AI Deep Dive AI Insights AI Chapters Transcript
People
E
Eamonn Cottrell
Q
Quincy Larson
Topics
Quincy Larson: 本期访谈的主题是关于Eamonn Cottrell如何利用自学编程技能自动化其咖啡店连锁店的运营,以及他如何平衡工作、家庭和个人爱好,例如超马拉松和音乐创作。访谈中,Quincy Larson 赞扬了Eamonn Cottrell 的终身学习精神和高效的工作方式,并探讨了电子表格在提高工作效率和自动化方面的巨大潜力。他还强调了在平衡工作和生活方面取得成功的必要性,并鼓励听众学习新的技能来提高自身竞争力。 Eamonn Cottrell: 他分享了自己通过freeCodeCamp学习编程的经历,以及如何利用电子表格和Google Apps Script等工具自动化咖啡店的库存管理、订单处理等流程。他详细介绍了其在咖啡店运营中使用电子表格的经验,并分享了多个成功案例,例如使用电子表格创建个人财务追踪器,以及如何利用电子表格和脚本提高工作效率。他还谈到了自己作为超马拉松运动员和音乐家的经历,以及如何平衡这些爱好与工作和家庭生活。此外,他还分享了自己克服药物和酒精成瘾的经历,以及如何将这段经历转化为帮助他人的动力。他鼓励听众积极学习新的技能,并找到平衡工作、生活和个人爱好的方法。 Eamonn Cottrell: 他详细讲述了自己如何利用电子表格和脚本自动化咖啡店运营的流程,并分享了多个具体的案例。他强调了电子表格在提高工作效率和减少错误方面的作用,并鼓励小型企业主充分利用电子表格的潜力。他还分享了自己在学习编程和使用电子表格方面的经验,以及如何将这些技能应用于实际工作中。此外,他还谈到了自己克服药物和酒精成瘾的经历,以及如何将这段经历转化为帮助他人的动力。他鼓励听众积极学习新的技能,并找到平衡工作、生活和个人爱好的方法。

Deep Dive

Key Insights

Why did Eamonn Cottrell decide to automate his coffee shop chain using spreadsheets?

Eamonn saw the inefficiencies in the manual processes, such as faxing orders on paper, and wanted to create a more efficient system using Google Sheets and scripting to reduce errors and save time.

How many freeCodeCamp tutorials has Eamonn Cottrell published?

Eamonn has published 37 freeCodeCamp tutorials focused on productivity and automation using spreadsheets.

What is Eamonn Cottrell's daily routine like as a father of four and a coffee shop chain operator?

Eamonn wakes up early, often at 4 a.m., to run and have quiet time before the day starts. He balances family commitments, running the coffee chain, and creating coding tutorials, often going to bed by 8:30 p.m.

What was Eamonn Cottrell's first coding project for his coffee shop chain?

His first project was creating an inventory management and ordering system using Google Sheets and scripting to replace the outdated faxing system.

How does Eamonn Cottrell balance his creative pursuits with his professional responsibilities?

Eamonn channels his creativity into productive tasks like coding, writing tutorials, and running his coffee chain. He believes in finding a balance between creative expression and practical responsibilities to provide for his family.

What is Eamonn Cottrell's approach to personal finance management?

Eamonn uses a custom-built finance tracker in Google Sheets that requires manual input, helping him and his wife stay conscientious about their spending and maintain financial stability.

How did Eamonn Cottrell's experience with addiction shape his life?

Eamonn's addiction led him to rehab at 19, which marked the beginning of his personal growth. He stayed sober for over 20 years and credits his recovery with helping him develop the discipline and focus needed to succeed in his career and personal life.

What is Eamonn Cottrell's opinion on the use of alcohol and recreational drugs?

Eamonn believes that removing psychoactive drugs, including alcohol, can improve cognitive performance and overall productivity. He has been alcohol-free for over eight years and encourages others to consider abstinence for better focus and health.

What are Eamonn Cottrell's future goals for his career and personal life?

Eamonn hopes to transition to full-time technical and creative work, but acknowledges the practical constraints of supporting his family. He plans to continue balancing his current responsibilities with his creative and technical pursuits.

How does Eamonn Cottrell view the role of spreadsheets in business operations?

Eamonn sees spreadsheets as incredibly powerful tools for automation and productivity in small businesses. He believes that even basic spreadsheet skills can make a significant difference in reducing errors and improving efficiency.

Chapters
Eamonn Cottrell is a software engineer, coffee shop owner, ultra-marathoner, musician, and writer. He's a father of four and has overcome addiction. He's also created 37 freeCodeCamp tutorials on spreadsheet automation.
  • Eamonn's diverse skills and accomplishments
  • His use of spreadsheets for productivity and automation
  • His work in addiction recovery

Shownotes Transcript

On this week's episode of the podcast, freeCodeCamp founder Quincy Larson interviews Eamonn Cottrell. He's a software engineer who also runs a local chain of coffee shops in Knoxville. Eamonn taught himself to code using freeCodeCamp. And he's since published 37 freeCodeCamp tutorials on using productivity and automation using spreadsheets.

Support for this podcast comes from a grant from Wix Studio. Wix Studio provides developers tools to rapidly build websites with everything out-of-the-box, then extend, replace, and break boundaries with code. Learn more at https://wixstudio.com

Support also comes from the 11,113 kind folks who support freeCodeCamp through a monthly donation. Join these kind folks and get involved in our mission by going to donate.freecodecamp.org

We talk about: - Eamonn love of coffee and how he bought VHS tapes to learn latte art - How he finds time to expand his skills in between running coffee shops and ultra-marathoning - How he used spreadsheets to automate the logistics of running coffee shops - How he balances being a musician and writer with the practical realities of providing for a family of 6

Can you guess what song I'm playing in the intro?

Also, I want to thank the 10,993 kind people who support our charity each month, and who make this podcast possible. You can join them and support our mission at: https://www.freecodecamp.org/donate

CORRECTION: Vincent van Gogh was supported by his younger brother – not his brother in-law. van Gogh never married so he never had a brother in law. I'm not sure why I thought that. Also, he seems to have sold more than one painting in his life (as many of us were taught in school), but nowhere near enough paintings to support himself as an artist.

Links we talk about during our conversation:

Eamonn's freeCodeCamp articles: https://www.freecodecamp.org/news/author/sieis/

Eamonn's YouTube channel: https://www.youtube.com/@eamonncottrell

Excel-based esports: https://www.youtube.com/watch?v=N2QC6VQXo8U

Ultra Marathons: https://www.youtube.com/@runtired

Got Sheet: https://www.gotsheet.xyz/

Progress and Perfection: https://www.progressandperfection.com/

Eamonn on LinkedIn: https://www.linkedin.com/in/eamonncottrell/

Eamonn on Twitter: https://x.com/EamonnCottrell