Beginnings
When I first started this project, I had no idea what I was doing, and I didn’t even know it would turn into a project. I just wanted something fun to work on while trying to figure out how adults use Excel. That is, for something other than just organizing a collection or making a schedule. It turns out that’s all a lot of people use Excel for, and there’s nothing wrong with that. Still, I wanted to take advantage of all spreadsheets have to offer, and using the data I was already gathering (but not yet recording) seemed like a good place to start. I figured that doing something fun alongside my Excel education would keep me interested and motivated, and in that I was correct. In fact it ended up growing into something much more, but in this post I want to focus on how it all began.
As I mentioned in my Welcome post, things really began to take shape when I created a PowerPoint slideshow to go along with my Toastmasters speech. In my Candle Burn Times presentation, I listed a methodology that sounded pretty good at the time. It’s long and terrible, so I apologize in advance for having to read it.
- Purchase candles
- What I’ve purchased before
- Supporting small and local businesses
- The wants and needs of the average American candle buyer
- Measuring – What to measure
- Started with only total burn time
- Times for lit and snuffed, with a simple summation once candle was completely extinguished
- Added cost
- Total cost, dollars per hour, hours per dollar
- Added weight
- Grams vs Ounces – all candles save for Diptyque measured in ounces, went with ounces and converted when necessary
- Burn the candles!
- Make adjustments to methods as study continued
- They made my room (and sometimes my house) smell great
Well, that was embarrassing. You can pretend you didn’t see it. Fortunately, with the help of some friends, I’ve been able to make some refinements. Or possibly amputations is a more appropriate word. Either way, there have been changes to both the way I measure candle data as well as my approach to the project overall. However, there is one metric that has eluded me from the start, and continues to do so. And that is the potency of the candle’s scent, known as the throw. A candle has a cold throw, which is how far it projects its scent when unlit, and, more importantly, a hot throw, which is how far it projects when lit. One of my stated goals in my original presentation is to find “a weighted formula that takes into account all data points.” Cracking the code on how to involve the hot throw should help in finalizing that formula and allow for some true value proposition measurements.
As the site moves forward, beyond just sharing basic data, I would like to embed some interactive Tableau reports to allow people to discover for themselves how the different measurements work together and view what’s important for them. Eventually, I want to allow for individual candle collections, but that is still a long way off. For now, I want to populate the site with as many data points (and pictures!) as I can. My current project plan is hopefully a little less embarrassing.
Project Scope / Metrics
- Purpose: Compare and contrast the value of various candle brands and convey that information in a fun and easily relatable way
Resources
- Measuring equipment
- Candles
- Candle accessories
- Office 365
- Visual Studio Code
- freeCodeCamp
- Stack Overflow
Milestones
- Timeline: 2023 – 2024
- First candle burned and data collected
- Second candle burned and data collected
- Third candle burned and data collected
- Fourth candle burned and data collected
- Fifth candle burned and data collected
- Spreadsheet completed
- PostgrSQL DB completed for first five candles
- Launch Candlegraph v1 (stretch goal)
Key Stakeholders: Me
Deliverables
- Excel sheet
- SQL Database (stretch goal)
- Candlegraph v1 (stretch goal)
Tasks
- Burn candles
- Record data in Excel spreadsheet
- Import spreadsheet data into PostgreSQL
- Launch Candlegraph v1 (stretch goal)
Success Criteria
- Collect data from one candle a month
- Complete data collection by August 1, 2023
- Launch Candlegraph v1 by December 31, 2023
I now realize that the “complete data collection” criterion doesn’t make sense, because it will be an ongoing project. I meant to complete the data collection of five different candles, but that wasn’t achieved, so I am just going to pretend that it was never achievable. Candlegraph is live, though, so I will definitely take that as a win. I do have enough data to start posting some visualizations, though, and I will be sharing that information soon.
Until then, thanks for reading!