Pipe Tool-ish

Log in

SmokingPipes.com Updates

Watch for Updates Twice a Week

PipesMagazine Approved Sponsor

PipesMagazine Approved Sponsor

Drucquers Banner

PipesMagazine Approved Sponsor

PipesMagazine Approved Sponsor

PipesMagazine Approved Sponsor

Status
Not open for further replies.

carver

Part of the Furniture Now
Mar 29, 2015
625
3
Belgium
Hi all,
It's Chinese New Year here so ... Happy New Year ... again. hum ...
Just wanted to know what you all look for in a tool that revolves around our hobby.
I have been working tirelessly on an excel spreadsheet that is getting a little out of hand, but it's only about tobaccos, not about pipes.

I know that "the pipe tool" is out there, but I prefer the one I made for a number of reasons, one being the challenge of doing it myself.
Nothing better than what one does for himself, right?

Lots of coding and formulas, etc, lots of hours of fun, programing, if anyone can relate.
So far, I have those tabs.
1. List of tobaccos

I am filling it up progressively, it would be the main database.

Blend, brand, blend type, cut, overall score from tobaccoreviews, comment, link to label picture I made, content, aromas, scores on room note, strength, ...
Screenshot%202016-02-07%2000.31.14.png


Screenshot%202016-02-07%2000.32.03.png

most info comes in dropdown lists

Screenshot%202016-02-07%2000.33.31.png


Screenshot%202016-02-07%2000.34.03.png

2. List of tobaccos that I own

about the same as the main list.
3. Information sheet

I select a blend and it gives me all the info, displays the label and image of the type of cut.

Screenshot%202016-02-07%2000.49.27.png

4. A comparator tool

I can compare up to 4 blends.

Screenshot%202016-02-07%2000.36.35.png

5. Two Label Makers.

One for the "pictures" and one for an "information label". The information label is automatically colored according to blend types.

I can select up to 9 blends for pictures and 10 for information labels, makes it easier for printing.

Screenshot%202016-02-07%2000.38.56.png


Screenshot%202016-02-07%2000.40.09.png


Screenshot%202016-02-07%2000.41.43.png

6. Charts.

Some pie charts about the blends that I own. Percentages of what what.

Screenshot%202016-02-07%2000.43.01.png

I am now in the process of creating a new tab relating to every smokes and my impressions of it.

It would then calculate the average of them, per blend, and update the rating in another tab.
Other crazy people out there?
Any other ideas of things to add, I am always looking up to more crazy things to code, so ... anything that could be useful.
By the way, when it's done, I am happy to share with you.

 

yaddy306

Lifer
Aug 7, 2013
1,372
504
Regina, Canada
I have something done up in Excel similar to your #2. I added a bar chart of consumption (number of bowls per month) as well as a plot of Internet order shipping costs vs. date (no free shipping to Canada!).

 

carver

Part of the Furniture Now
Mar 29, 2015
625
3
Belgium
@yaddy306
Adding prices and shipping costs is a really good idea. Didn't think of that !

As is a graph for consumption, which will come when I start populating the new tab about it.
Thanks for the idea ;-)

 

tennsmoker

Lifer
Jul 2, 2010
1,157
7
Uh, what is Excel?
Just kidding. My daughters tell me all the time, "Dad, you gotta learn Excel."
My response is to take a nap.
That is mighty impressive, Carver.

 

shutterbugg

Lifer
Nov 18, 2013
1,451
21
Here's mine, it's a little simpler:
English: Dunhill Nightcap

VA: Dunhill Flake

VA-Per: Dunhill Deluxe Navy Rolls/Escudo

Nickick: Dunhill Royal Yacht

ARO: 4th Generation 1931 Flake

 

carver

Part of the Furniture Now
Mar 29, 2015
625
3
Belgium
I get a little crazy when I start doing that kind of stuff.

I just finished a little tool within the workbook that allows me to track my smokes, and personal evaluation of taste, strength, flavouring and room note and calculates averages to show in another tab.
The next thing I have in mind is to have a "suggestions" tab, which would allow the user to select a blend and the tool proposes similar ones according to types and characteristics.

That one will be a tougher I believe.
Anyone interested ?

 

captpat

Lifer
Dec 16, 2014
2,277
12,168
North Carolina
I started with Excel and have since migrated to Tobacco Cellar and the Pipe Tool, neither is completely satisfactory. Your spreadsheet looks much more complete and impressive. What are your plans for it going forward?
Pat

 

randelli

Part of the Furniture Now
Nov 21, 2015
914
5
Wow! I too have tendancy to over analyze and over populate excel... I love it!

 

carver

Part of the Furniture Now
Mar 29, 2015
625
3
Belgium
Thanks for the comments guys!!
@Pat: for now I am a little idle, but in the near future, I want to adapt it to increase the amount of data. Because every drop down is an alphabetical list of blends, if that list becomes too big, 200+, it really slows down the thing. I will make cascading drop downs by brand then blend to lighten the processing. After that, I want to have a tab that allows suggestions, based either on 1 blend + choice of characteristics, or choice of 3-4 blends and provide suggestions.
@bpftc: I don't know about "public" but I am happy to share. For now it's still a little early though.
Anyone interested, send me a MP with an email.
Also I am looking for people on windown to test it.

 

robwoodall

Can't Leave
Apr 29, 2015
422
5
I have something similar.
It's a pile of tins and jars on my workbench, with the ones I like closer to the front, and the less-loved blends slowly pushed toward the back.
Hmmm. Actually, that's not similar at all!
Seriously, excellent work!

 

cobguy

Lifer
Oct 18, 2013
3,742
15
I have something similar.
It's a pile of tins and jars on my workbench, with the ones I like closer to the front, and the less-loved blends slowly pushed toward the back.
Hmmm. Actually, that's not similar at all!
:rofl: This is funny ... because it's true! :rofl:
That's a serious commitment to organization, my friend ... nicely done!

 
Status
Not open for further replies.