Even though I've gotten stupid comments from other users regarding this, I'm still making it available to those who may benefit.
If you're looking to reload on the cheap or would simply like to know exactly how much every round / box costs, then this is the spreadsheet for you. I had already made a spreadsheet like this for myself, using simple formulas, but I found it annoying that I constantly had to re-input data every time I wanted to make a calculation. I also had to have a different spreadsheet for every caliber so I started a new spreadsheet that would incorporate all this into one.
Here's what the Calculator's main page looks like:
The calc page is where you select from all the options you've input. You don't actually type any information on this page except for your powder charge in grains and your primer type and cost. Everything else is input in the #1-3 sheets.
Here's how you calculate: You select your bullet type at the top left (from a drop down menu). And then you go across from left to right selecting bullet, powder type and quantity (the spreadsheet displays your recommended load for each bullet based on your inputs) and finally primer and brass selection. All from drop down menus.
At the bottom it displays your cost per round, per 20 and per 50.
And the pages you input the data into look like this:
This is Sheet #1 of 3. This is where you input the data that is used in the calc page to figure out your reloading costs. You first start by inputting your round name at the top left. I've left some of my 30-30 data there for example, use at your own risk - I am not responsible for the accuracy of the powder charge numbers.
Under "Enter Bullet Names Here" is where you enter the bullet names, price per box and quantity per box. I also like to include the bullet type (RN, FP, Spitzer etc). The spreadsheet then copies the bullet names in the boxes below for easy referencing. To the right of the bullet name box, you enter your brass in the same fashion.
Below is where things get important. Here you input your powder options and charge for each individual bullet. This makes sure that you don't select the wrong powder load for a specific bullet. You then select your container size, enter the price and enter the suggested load as per your reloading manual or personal recipe. I like to input a Min - Max load so that when I'm calculating I can easily see what my options are.
You have to select all options for the spreadsheet to give you a result. For example, if you change your bullet type from 30-30 to 30.06, but don't re-select new bullet, powder etc. the spreadsheet will display #N/A in the results. This means that it attempted to calculate the data fields displayed, but couldn't find the data on the sheet specified. That's because it is now looking on the 30.06 page for numbers that are on the 30-30 page. Sounds confusing, it kind of is when it comes to make it all work, but it works.
Anyhow, if you're still with me and would like to give it a go, send me a pm and I'll get you the file. It is in .xls (the common excel file) but if you don't have excel, just go download Open Office org (free excel/word/powerpoint program) which is actually what I used to create this file.
If you've got any questions or suggestions as to how I could make the spreadsheet work better or more efficient, feel free to post. If there's something that doesn't work for you or would like it tailored a little more to your needs but don't have the knowledge to make the formulas work, let me know and I'll see if I can help.
If you aren't interested, or have a better spreadsheet (or think you do), either post it for yourself, or move on. Negative comments/ trash talking isn't wanted here, I didn't need to do this, I'm simply trying to be helpful.
Cheers,
Joedude
UPDATE:
After talking with a few people, I've discovered that some Excel users are having issues, it depends on which version of excel you use. But it works fine in Open office. I have this spreadsheet on my PC and Mac and works fine. I guess its just a difference in the way the program reads the formulas. I don't currently have access to a usable copy of Excel at home so I can't change the coding. Unless someone chimes in to tell me that theirs works on Excel, I guess you'll have to download Open Office. It is a free program and it is very small so it won't take much room on your computer. It is also compatible with Mac and PC.
In the meantime I'll get to work changing the formulas to make it cross compatible.
Thanks for everyone's input so far!
If you're looking to reload on the cheap or would simply like to know exactly how much every round / box costs, then this is the spreadsheet for you. I had already made a spreadsheet like this for myself, using simple formulas, but I found it annoying that I constantly had to re-input data every time I wanted to make a calculation. I also had to have a different spreadsheet for every caliber so I started a new spreadsheet that would incorporate all this into one.
Here's what the Calculator's main page looks like:
The calc page is where you select from all the options you've input. You don't actually type any information on this page except for your powder charge in grains and your primer type and cost. Everything else is input in the #1-3 sheets.
Here's how you calculate: You select your bullet type at the top left (from a drop down menu). And then you go across from left to right selecting bullet, powder type and quantity (the spreadsheet displays your recommended load for each bullet based on your inputs) and finally primer and brass selection. All from drop down menus.
At the bottom it displays your cost per round, per 20 and per 50.
And the pages you input the data into look like this:
This is Sheet #1 of 3. This is where you input the data that is used in the calc page to figure out your reloading costs. You first start by inputting your round name at the top left. I've left some of my 30-30 data there for example, use at your own risk - I am not responsible for the accuracy of the powder charge numbers.
Under "Enter Bullet Names Here" is where you enter the bullet names, price per box and quantity per box. I also like to include the bullet type (RN, FP, Spitzer etc). The spreadsheet then copies the bullet names in the boxes below for easy referencing. To the right of the bullet name box, you enter your brass in the same fashion.
Below is where things get important. Here you input your powder options and charge for each individual bullet. This makes sure that you don't select the wrong powder load for a specific bullet. You then select your container size, enter the price and enter the suggested load as per your reloading manual or personal recipe. I like to input a Min - Max load so that when I'm calculating I can easily see what my options are.
You have to select all options for the spreadsheet to give you a result. For example, if you change your bullet type from 30-30 to 30.06, but don't re-select new bullet, powder etc. the spreadsheet will display #N/A in the results. This means that it attempted to calculate the data fields displayed, but couldn't find the data on the sheet specified. That's because it is now looking on the 30.06 page for numbers that are on the 30-30 page. Sounds confusing, it kind of is when it comes to make it all work, but it works.
Anyhow, if you're still with me and would like to give it a go, send me a pm and I'll get you the file. It is in .xls (the common excel file) but if you don't have excel, just go download Open Office org (free excel/word/powerpoint program) which is actually what I used to create this file.
If you've got any questions or suggestions as to how I could make the spreadsheet work better or more efficient, feel free to post. If there's something that doesn't work for you or would like it tailored a little more to your needs but don't have the knowledge to make the formulas work, let me know and I'll see if I can help.
If you aren't interested, or have a better spreadsheet (or think you do), either post it for yourself, or move on. Negative comments/ trash talking isn't wanted here, I didn't need to do this, I'm simply trying to be helpful.
Cheers,
Joedude
UPDATE:
After talking with a few people, I've discovered that some Excel users are having issues, it depends on which version of excel you use. But it works fine in Open office. I have this spreadsheet on my PC and Mac and works fine. I guess its just a difference in the way the program reads the formulas. I don't currently have access to a usable copy of Excel at home so I can't change the coding. Unless someone chimes in to tell me that theirs works on Excel, I guess you'll have to download Open Office. It is a free program and it is very small so it won't take much room on your computer. It is also compatible with Mac and PC.
In the meantime I'll get to work changing the formulas to make it cross compatible.
Thanks for everyone's input so far!
Last edited:
