hydro-terp
Well-Known Member
So this is a byproduct of buying stuff off CPs scorcher deals where you only have 60 seconds to make a decision.
I have en excel file that I track my purchases with and in it I have a formula that will calculate the cost per stick and I then enter the cost per stick based on the everyday price if you bought a box from Da Page. I then have a cell that calculates how much % savings off MAP I got the cigars for. And Its been a wide range I must say from 10% to 75% and everything in between. Not all have been scorcher purchases but the following is specific to this situation.
Well with 60 seconds to make a decision its easy to mistake a mundane sale for a good one so I have created a sheet that does the same on one line but I added another cell and added the IF formula to it. So in additions to giving % off MAP it will have another instantaneous function, a "Buy" or "No Deal" prompt. I can set a % off MAP as my buy trigger. Say above 20% off it will say Buy, below it will say No Deal. It should make buying the scorcher deals a little easier and cut down on buying stuff that really isnt great. So enter the deal thats running down in 60 seconds, look it up at the CP list of brands and do the quick math and come back and enter that price and presto. @CBoukal Im sure you have something thats goes way deaper but humor me. Some of my best deals have come from the CP Scorcher so its utility has value for me. I bought basically two boxes (8x5r's) of EPC Encore's that were over 50% off MAP as scorcher deals.
I know MAP pricing is like pricing on new cars and the manufactures can set the price at whatever they want *cough* Gurkha *cough* so this isnt perfect. You can have big mark downs on Oliva and Rojas etc. and hardly any on Perdomo and Padron for example but this will be a useful and fun exercise for those brands that are not outlyers on the price bell curve.
So
20%
30%
What?
HT
I have en excel file that I track my purchases with and in it I have a formula that will calculate the cost per stick and I then enter the cost per stick based on the everyday price if you bought a box from Da Page. I then have a cell that calculates how much % savings off MAP I got the cigars for. And Its been a wide range I must say from 10% to 75% and everything in between. Not all have been scorcher purchases but the following is specific to this situation.
Well with 60 seconds to make a decision its easy to mistake a mundane sale for a good one so I have created a sheet that does the same on one line but I added another cell and added the IF formula to it. So in additions to giving % off MAP it will have another instantaneous function, a "Buy" or "No Deal" prompt. I can set a % off MAP as my buy trigger. Say above 20% off it will say Buy, below it will say No Deal. It should make buying the scorcher deals a little easier and cut down on buying stuff that really isnt great. So enter the deal thats running down in 60 seconds, look it up at the CP list of brands and do the quick math and come back and enter that price and presto. @CBoukal Im sure you have something thats goes way deaper but humor me. Some of my best deals have come from the CP Scorcher so its utility has value for me. I bought basically two boxes (8x5r's) of EPC Encore's that were over 50% off MAP as scorcher deals.
I know MAP pricing is like pricing on new cars and the manufactures can set the price at whatever they want *cough* Gurkha *cough* so this isnt perfect. You can have big mark downs on Oliva and Rojas etc. and hardly any on Perdomo and Padron for example but this will be a useful and fun exercise for those brands that are not outlyers on the price bell curve.
So
20%
30%
What?
HT