PDA

View Full Version : ::: LEAD to BULLET CALCULATOR :::



xXFREEDOMisNOTfreeXx
10-02-2010, 07:36 PM
Hey guys, thought some of you might find this helpful (Also I'm not sure if this really belongs in this forum section...sorry). I am in to computers a lot and love to use MS Excel. Anyway i created this "LEAD TO BULLET CALCULATOR" that was pretty helpful to my Dad & I. To use it you need "Microsoft Excel."

Basically the calc will tell you how many bullets you can cast with any given amount of lead. It will also tell you how much it cost you per single bullet, 50 lot, & 100 lot. I want to add more features to the "Calc" and would love to hear feedback from anyone who uses it. Feel free to edit it and upload your own recreated version to show others and give ideas of what is possible. I am currently working on an addition to figure in brass costs and a section that will encompass the total cost of a bullet from start to finish. Hope you enjoy.

REMEMBER EXCEL FORMAT.

DOWNLOAD HERE (Excel 2007 Format): http://www.filefront.com/17344836/LEAD TO BULLET CALCULATOR v1.1.xlsx (http://www.filefront.com/17344836/LEAD TO BULLET CALCULATOR v1.1.xlsx)

DOWNLOAD HERE (Excel 97-2003 Format): http://www.filefront.com/17406804/LEAD TO BULLET CALCULATOR v1.1 (97-2003).xls (http://www.filefront.com/17406804/LEAD TO BULLET CALCULATOR v1.1 (97-2003).xls)

sleeper1428
10-09-2010, 07:00 PM
Interesting and potentially useful spreadsheet. However, I couldn't open it with MS Excel 2003 - reported to be an unreadable format - but was able to open it in Corel Quattro Pro X5. Is it possible that you did this spreadsheet in MS Excel 2007 and saved it in that versions format? If so, would you, when you have time, save it again but this time in MS Excel 2003 format and then post that file for downloading. Yes, I'm one of those 'dinosaurs' who started long ago with WordPerfect and have never seen an overwhelmingly compelling reason to switch over completely to MS Office products. Having been given a copy of MS Office 2003, I do have that on my box but only use it on rare occasions.

Again, nice spreadsheet that I may well add information to when I have time.

sleeper1428

bhn22
10-09-2010, 11:23 PM
I must be missing the point here. This happens when you get old. There are 7000 grains to 1 lb. The rest is very basic arithmetic. a spreadsheet is necessary for this?

RP
10-10-2010, 01:06 AM
bhn22 its not that your getting old its how some people like to do things, Really just a spin on it with some extras. I use the 7000 trick to count my boolits while casting. I have to say good job if you computer guys were not tinkering I dont think we be talking right now keep it up bud.

Ravenhawk57
10-10-2010, 08:07 AM
Such a chart already exists for hand guns, rifles and shotguns. Just goggle Handgun ammo costs. Home is under GUN CALC. Just thought I let you know.

imashooter2
10-10-2010, 08:18 AM
Some suggestions...

Narrow the columns and get rid of the serial number column so it fits on conventional aspect monitors.

Add tin, antimony and/or type metal blocks with cost, then total to get alloy cost and quantity.

Add a gas check cost box and include that in cost per boolit for those that use them.

bhn22
10-10-2010, 10:22 AM
bhn22 its not that your getting old its how some people like to do things, Really just a spin on it with some extras. I use the 7000 trick to count my boolits while casting. I have to say good job if you computer guys were not tinkering I dont think we be talking right now keep it up bud.


Phew! I was getting worried...

RP
10-10-2010, 12:26 PM
Bhn 22 not sure why I said anything about age sometimes my fingers dont keep up with my mind and I start to ramble on. I have a hard time with computers so do thinks the old way is easier for me and others. I have the lee shooter program and it has ballistic charts and price calculators along with some other things. Some I use others I dont. Just typing in how much I payed for primers powder and getting a price gives me a quick ideal of cost.

shootingbuff
10-17-2010, 09:23 PM
Some suggestions...

Narrow the columns and get rid of the serial number column so it fits on conventional aspect monitors.

Add tin, antimony and/or type metal blocks with cost, then total to get alloy cost and quantity.

Add a gas check cost box and include that in cost per boolit for those that use them.

Yep, or have the costs on different worksheets or to the right with the results on the left. Most worry about the results and not so much how they got there.

Good job, nice work and thanks!

sb

xXFREEDOMisNOTfreeXx
10-18-2010, 09:29 PM
Hey guys just letting you know that I did update the original post with a 97-2003 format for anyone who has that era of "MS Office." Also thanks for all the positive feedback and recommendations. Currently I am working on a new spreadsheet with the columns some of you had asked for. Hopefully it will be done in a short while.

DOWNLOAD HERE (Excel 2007 Format): http://www.filefront.com/17344836/LEAD TO BULLET CALCULATOR v1.1.xlsx (http://www.filefront.com/17344836/LEAD TO BULLET CALCULATOR v1.1.xlsx)

DOWNLOAD HERE (Excel 97-2003 Format): http://www.filefront.com/17406804/LEAD TO BULLET CALCULATOR v1.1 (97-2003).xls (http://www.filefront.com/17406804/LEAD TO BULLET CALCULATOR v1.1 (97-2003).xls)