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, ...
most info comes in dropdown lists
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.
4. A comparator tool
I can compare up to 4 blends.
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.
6. Charts.
Some pie charts about the blends that I own. Percentages of what what.
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.
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, ...
most info comes in dropdown lists
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.
4. A comparator tool
I can compare up to 4 blends.
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.
6. Charts.
Some pie charts about the blends that I own. Percentages of what what.
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.
