Per Pellet Cost Comparison Spreadsheet

[Revoman]

Hello AGN'ers!

Going through many threads on pellet cost, and doing the homework myself, I thought; "Why not just create a simple Excel spreadsheet to do the comparisons?"
So, that spreadsheet is attached and ready for your use. The only areas that you should NOT enter any information are the cells in deep red.
You can change the tax rate at the top of the sheet to match your local tax rate and it will automatically calculate your tax. If there is no tax, then you will use the dark blue cells for the calculation. (equals 0).
You simply input the information: FX / Caliber / Grains / Head-Size / Tin Quantity / Tins Needed / Freebies / Per Tin Cost / Shipping (if any).
With that information it will kick out a per pellet cost at the far right.
It also has direct links to the vendors that I normally deal with, just click on them and they go directly to the site.
I have examples throughout to make it easier to understand how it works.
Any questions, just ask. I hope that it works for you.

Mike

View attachment Pellet Cost Comparison.xlsx

 

[bdzjlz]

My thought…. You have too much time on your hands, lol…

 

[Revoman]

"My thought…. You have too much time on your hands, lol…"
That's okay, it's not for everyone, I get it. It did save me a lot of money in my last pellet purchase, so it works for me.

 

[beerthief]

will not open here ?
Buy i think the idea is to pay for the best pellet that works best in your gun

 

[Gerry52]

Mike, I TOLD YOU to cut down on coffee! Twelve cups every morning might possibly make your brain go into overload! Now, please finish that study on how much every puff of air costs when we pull the trigger (BTW, I couldn't get your hard work to open up either)
Gerry

 

[WorriedMan]

Like where you're going with this, normally use website Shopping Cart, with shipping, to determine "to-my-door pricing," adding sales tax, then divide by number of pellets. WM

 

[Privateer]

It opens in Excel and also Open Office just fine for me.

 

[Revoman]

beerthief --=--
True dat.

Gerry52 --=--
I rarely drink coffee! My motor is constantly running.

WorriedMan --=--
That is exactly where this sheet takes you.

Not sure why it's not opening for some. Hopefully, you can eventually get it to open? It's coming from a Microsoft Excel Sheet, so not sure if IMac/Apple will open?

MIke

 

[bdzjlz]

"My thought…. You have too much time on your hands, lol…"
That's okay, it's not for everyone, I get it. It did save me a lot of money in my last pellet purchase, so it works for me.

I was just giving you a hard time. Thanks for your efforts on behalf of all!