7 Responses to “Cigar Reviewer”

1. Darren says:

   April 21, 2010 at 7:07 am

   If you are using Internet Explorer and the file is showing up as a .zip then use this method to download. Right click on the link and then click on “Save Target As”. Then change the file type to “All Files”. Then rename the file to “Cigar-Reviewer2.xlsx” I don’t know why but it seems that it doesn’t know what file extension it is supposed to be so it uses .zip by default. Enjoy the program.
2. Len Bell says:

   January 18, 2011 at 10:16 pm

   I am interested in your rating sheet. I need more information in order for it to make sense to me.

   Could you elaborate more on your formulas and how to manipulate the form?

   Thanks,

   Len
   Bell
3. Darren says:

   January 19, 2011 at 2:05 pm

   NO problem, thanks for trying it out! Start out by entering the cigar info in the yellow cells on the left side of the program “cigar, maker, length, ring gauge, wrapper, cost”. This is the most important step because all of the formulas are calculated using the length and ring gauge sizes. Next, move to the right and enter your cigar ratings in the blue cells “Constructin, draw, burn, ash, flavor, complexity”. These ratings should be a 1 to 10 scale with 1 being terrible and 10 being outstanding as shown at the top of the program. With this information entered you should get a value calculated in the green cell. If you are not satisfied with this number simply change the “1″ that is already in the “Value Manager” box at the top of the program to a higher positive number to increase the value or a lower negative number to decrease it. I have also added a Rating manager box so that you can place more weight on a particular rating. For instance, if you place more value on the flavor of a cigar over the construction all you have to do is increase the “1″ next to “flavor” to a 2, 3, 4, or 5. You should notice a slight change in the “Average” cell’s number. You can change the weight for all the other categories just as I have showed you. Once you are happy with the “value” all you have to do is keep adding cigars to the list. Each cigar you add will use the same formulas as the first cigar to calculate the value of all the cigars you add. In this way you can compare the value of all the cigars you enter and use the program as a tool to help make cigar purchases in the future. I hope this helps. Also, if anyone has any ideas or changes they think would improve the program I would be glad to take them.
4. Darren says:

   April 6, 2011 at 11:37 pm

   One thing I forgot to mention… The cost is also a major part of my program. If you notice at the far right, the cigar volume is calculated using the length and ring gauge entries. The Cost/Square Inch is calculated by dividing the cost of the cigar by the volume. That is really where the “Value Manager” number comes into play. Even if you give every rating a 10, if the cost of the cigar is 20 bucks it will still only fall into the Average category. If you think that the cigar should be valued higher then you can increase the “Value Manager” number. I set up the program so that a moderately priced cigar (2-6 bucks) that recieves high scores will have a high value.
5. Sam De La Torre says:

   May 10, 2012 at 6:32 pm

   Darren! Matt tells me you are the Excell wizkid! I would like to make Excell recognize when I enter decimals for the cost/cigar block. Sometimes you get those amazing deals on CI.com and just don’t reach a dollar per stick. Is there a way?

   BTW, like I told Matt. I’ll be using this Excell file as often as a crackhead uses a needle.

   My buddy Alex and I thank you from the bottom of our hearts! You are an Excell God in my book!
6. Darren says:

   May 10, 2012 at 7:17 pm

   Hey Sam, thanks for the comment! Its hard to know if people even like the program when hardly anyone comments so i appreciate your post. The format for the Cost/Cigar cell is set to currency. If you type 3.4 in the cell it should show up as $3.40. It rounds to the nearest penny so even if you type 3.45 in the cell it should show up as $3.45. If it does’t work for you there are some steps you can take to correct it. Let me know if it works and we will go from there.

   Thanks again.
7. Sam De La Torre says:

   May 10, 2012 at 7:50 pm

   It worked. My dumb#@& was adding the /1 after the value. lol. I love it bro, honest. Thank you so much! Great product!