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
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
