ShotGunWorld Shotguns

It is currently Mon Mar 01, 2021 1:48 am

All times are UTC - 6 hours [ DST ]


Image



Post new topic Reply to topic  [ 43 posts ]  Go to page Previous  1, 2, 3  Next
Author Message
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 6:57 am 
*Proud to be a*
*Proud to be a*
User avatar

Joined: Thu Mar 05, 2009 10:56 pm
Posts: 7795
Location: Central ND
I find this humorous, but I have to side with the Excel guys if you are looking for ease and speed. Once you setup the spreadsheet, which for anyone with Excel experience is fairly simple, it is much faster to plug in numbers, than to do it long hand or with a calculator.

On the other side of this, how often do you have to figure the cost of reloading a box of shells?

I think some folks like to play with their computers!! :mrgreen:



_________________
Mark

aka Mr. Tactful. Common sense no longer appears to be common.
NSCA#544066


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 9:02 am 
Limited Edition

Joined: Wed Nov 12, 2014 1:49 pm
Posts: 324
I made one up and use it occasionally. If anyone wants it PM me with your email addy and I'll send it to you. You change the item cost in the cell, hit enter and you get cost per box and per shell. Entries are, wad and primer cost per 1000, shot per bag, powder cost per pound, shot load weight and powder load weight. Simple little excel spredsheet.


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 10:20 am 
Crown Grade
User avatar

Joined: Sun Jun 24, 2018 2:51 pm
Posts: 2274
Location: S.E. Wisconsin
Or just use one like this thats already out there.

http://www.losttarget.com/costcal.htm


Steve

_________________
The More Times You Pull The Trigger The More Fun You Are Having.
I repair MEC presses. PM me.
Used to be Steve Y


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 11:07 am 
Tournament Grade

Joined: Sat Mar 09, 2019 10:14 pm
Posts: 288
Location: Near, but not in, Portland, OR
I do a lot of excel stuff at work. I have a simple sheet that I just drop the component price / quantity into to give me a cost / box number. It's quick and easy. I rarely use it though, be cause unless the price of something changes dramatically, the cost per box doesn't change enough to be bothered about.

I also have one that gives me rounds / lb of powder. for example, 8lbs of red dot, at 17 grains/shot, 1lb=412 5lb=2059 8lb=3294

Which, now that I look at it, I can't believe I shot well over 3K rounds this summer. Probably closer to 4k. Huh.

_________________
My mind is a raging torrent, flooded with rivulets of thought cascading into a waterfall of creative alternatives


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 11:40 am 
Crown Grade

Joined: Sun Mar 03, 2013 11:01 am
Posts: 6393
Location: Newton Kansas
Ulysses wrote:
I gotta side with Burnt Powder on this one. We're talking about a 5th grade math problem. How hard can that be?

Sample Problem: A case of 5000 wads costs $68. How much does ONE wad cost? Is there anyone reading this who can't figure out the anwer to that in about 10 seconds with a calculator? Why would anyone need a "spread sheet" for that? :? Or, for that matter, why would anyone need a calculator for that problem? It is a very simple division problem.

Gee folks, technology is great, but let's not forget how to do the basic things without a calculator or computer. Probably in a few years, our computers will "talk" to us and we won't even have to know how to read. Just turn it on and punch a few buttons with the proper markings on them and the computer will verbally tell us everything we want to know. :wink:

I have a co-worker, who rarely "reads", listens to Audiobooks constantly.

It would be one thing listening to said Audiobook while driving (like a trucker), working for hours at one of our blasting cabinets (abrasive paint removal), but SITTING AT HIS DESK AT BREAK TIME (which is when I pull out an old paper book for 10 minutes).

I also enforce a STRICT limit on my Extraneous And Pointless Reccordkeeping, there are a whole host of things some people feel they need to keep for others to throw away eventually, 98% of that information is useless and pointless to me.
Prior to a midsummer discussion on this very board, I haven't figured "reloading cost" in nearly 2 decades. Don't care. Don't matter.
I sure as heck don't ascribe a "cost" to my time, because that time is not being removed from someone willing to pay me for that time.
If I spent a day loading ammo, away from work, when I could have been at work making $30 an hour, then my loading time is costing me $30 an hour.
Same thing mowing my yard instead of going to work.

However, if I spend that day loading on a Saturday, or some other holiday I am not scheduled to work, or I am On Vacation and already being paid that day, that "time" I have has NO value, because no-one is offering to pay me for that time, so it has NO COST.

_________________
I don't always venture out into the sub-freezing darkness, but when I do, it is hunting season, and I carry a Browning. Stay hungry my friends.


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 11:57 am 
Crown Grade

Joined: Wed Nov 28, 2012 3:28 pm
Posts: 5707
I reload(ed) to save money. I want to know the cost of my reloads compared to new ammo simply so I know whether to buy new ammo or reloading supplies.

I have used an Excel sheet. It's probably still lurking somewhere on my hard drive or a thumb drive. Now I just use an on-line calculator I have bookmarked.


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 2:24 pm 
Tournament Grade

Joined: Sat Mar 09, 2019 10:14 pm
Posts: 288
Location: Near, but not in, Portland, OR
OldStufferA5#1911 wrote:
Ulysses wrote:
I gotta side with Burnt Powder on this one. We're talking about a 5th grade math problem. How hard can that be?

Sample Problem: A case of 5000 wads costs $68. How much does ONE wad cost? Is there anyone reading this who can't figure out the anwer to that in about 10 seconds with a calculator? Why would anyone need a "spread sheet" for that? :? Or, for that matter, why would anyone need a calculator for that problem? It is a very simple division problem.

Gee folks, technology is great, but let's not forget how to do the basic things without a calculator or computer. Probably in a few years, our computers will "talk" to us and we won't even have to know how to read. Just turn it on and punch a few buttons with the proper markings on them and the computer will verbally tell us everything we want to know. :wink:

I have a co-worker, who rarely "reads", listens to Audiobooks constantly.

It would be one thing listening to said Audiobook while driving (like a trucker), working for hours at one of our blasting cabinets (abrasive paint removal), but SITTING AT HIS DESK AT BREAK TIME (which is when I pull out an old paper book for 10 minutes).

I also enforce a STRICT limit on my Extraneous And Pointless Reccordkeeping, there are a whole host of things some people feel they need to keep for others to throw away eventually, 98% of that information is useless and pointless to me.
Prior to a midsummer discussion on this very board, I haven't figured "reloading cost" in nearly 2 decades. Don't care. Don't matter.
I sure as heck don't ascribe a "cost" to my time, because that time is not being removed from someone willing to pay me for that time.
If I spent a day loading ammo, away from work, when I could have been at work making $30 an hour, then my loading time is costing me $30 an hour.
Same thing mowing my yard instead of going to work.

However, if I spend that day loading on a Saturday, or some other holiday I am not scheduled to work, or I am On Vacation and already being paid that day, that "time" I have has NO value, because no-one is offering to pay me for that time, so it has NO COST.


I do that too. Always listening to Audio books. Pretty hard to read a book while reloading ammo, walking the dog, or doing chores around the house. And they're free from the library, so why not?

_________________
My mind is a raging torrent, flooded with rivulets of thought cascading into a waterfall of creative alternatives


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 9:05 pm 
Moderator
Moderator
User avatar

Joined: Fri Nov 04, 2005 11:15 am
Posts: 23265
Location: Knoxville, Tn area Nyuck, Nyuck
I maintain that you can be attentive to one thing or another. Either you are listening to the book or loading ammo. If you are trying to do both, then something is not being observed as it should be.
Even worse is driving and listening to an audiobook.

_________________
if you love the ole USA https://youtu.be/f22JcsKmnYg If you were Military, enjoy

Let us endeavor so to live so that when we come to die even the undertaker will be sorry.
Mark Twain


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 9:16 pm 
Crown Grade

Joined: Mon Aug 23, 2010 9:38 pm
Posts: 2572
Location: San Jose, CA
I tried on an Excel spreadsheet, but found my MEC 9000G to be a superior tool.

_________________
Hornady Apex 91 shotshell loaders in 12 g and 20g for sale

http://www.shotgunworld.com/bbs/viewtopic.php?f=73&t=448601


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Mon Oct 28, 2019 9:41 pm 
Tournament Grade

Joined: Sat Mar 09, 2019 10:14 pm
Posts: 288
Location: Near, but not in, Portland, OR
Curly N wrote:
I maintain that you can be attentive to one thing or another. Either you are listening to the book or loading ammo. If you are trying to do both, then something is not being observed as it should be.
Even worse is driving and listening to an audiobook.


You don't talk to people or listen to the radio when you drive? I don't seem to have any problem it.

_________________
My mind is a raging torrent, flooded with rivulets of thought cascading into a waterfall of creative alternatives


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Tue Oct 29, 2019 1:19 am 
Crown Grade

Joined: Sun Mar 03, 2013 11:01 am
Posts: 6393
Location: Newton Kansas
Curly N wrote:
I maintain that you can be attentive to one thing or another. Either you are listening to the book or loading ammo. If you are trying to do both, then something is not being observed as it should be.
Even worse is driving and listening to an audiobook.

This.

Me, I usually have music going, the radio or an MP3 player.

The music is basically just background noise that I don't really pay attention to, but it is there, filling the otherwise silence which has it's own way of being distracting.

A number of times, I have had to go back and listen to the exact same Guntalk Podcast 3 or 4 times to actually "listen" to it, because I was paying it so little attention when it played the first time (or 2, or 3).

A book I would have to concentrate on to follow the story.

_________________
I don't always venture out into the sub-freezing darkness, but when I do, it is hunting season, and I carry a Browning. Stay hungry my friends.


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Tue Oct 29, 2019 9:14 am 
Moderator
Moderator
User avatar

Joined: Fri Nov 04, 2005 11:15 am
Posts: 23265
Location: Knoxville, Tn area Nyuck, Nyuck
OldStufferA5#1911 wrote:
Curly N wrote:
I maintain that you can be attentive to one thing or another. Either you are listening to the book or loading ammo. If you are trying to do both, then something is not being observed as it should be.
Even worse is driving and listening to an audiobook.


A book I would have to concentrate on to follow the story.


Exactly my point about having to concentrate on the book while driving is certainly a recipe for unpleasant happenings.

_________________
if you love the ole USA https://youtu.be/f22JcsKmnYg If you were Military, enjoy

Let us endeavor so to live so that when we come to die even the undertaker will be sorry.
Mark Twain


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Tue Oct 29, 2019 7:15 pm 
Tournament Grade

Joined: Sat Mar 09, 2019 10:14 pm
Posts: 288
Location: Near, but not in, Portland, OR
I've never had any problems with it. I've been more distracted by other people in the car I'm having a conversation with, or even when a good tune comes on.

_________________
My mind is a raging torrent, flooded with rivulets of thought cascading into a waterfall of creative alternatives


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Wed Oct 30, 2019 2:35 pm 
Presentation Grade

Joined: Tue May 03, 2011 1:25 pm
Posts: 507
Location: New Mexico
Quote:
I was thinking having all the load data in an excel sheet would make it nice and easy to use filters to find a load to fit what components you have or want to use. There are 100's of combinations and using excel would be very nice. I noticed Copied data from the big powder Mfg wont past right in excel....


Not hundreds of published loads for 12 gauge. Try more like hundreds of thousands. And many more for the other gauges.

Your copy and paste problems are probably due to a format issue. The data in published on-line sources is most likely formatted in HTML or PDF or even a newer format, and it's not just data, but also format instructions. So a spreadsheet does not know how to paste "just the data" properly. You may have success with saving what you copy as a "text only" file ("txt" file extension), then importing (reading) that into your spreadsheet.

If this were an EASY thing to accomplish, there would already be "mash-ups" of what web sites have for published loads all rolled up into a giant database to be searched quickly. Think small and just record what components you want in about 3-6 loads that you know run well in your guns. Buy those components when one goes into "low inventory" status. Or you spot a sale on one of your 20 favorite components.

Besides, new powders and wads and even hulls come out every year. Who really wants to find all those new combinations? Hint - not even Hodgdon nor Alliant!

Keep it simple - everyone else does (either in their head or even a loading log book).

Good luck, GJ


Top
 Profile  
 
 Post subject: Re: Relaoding Excel Spreadsheet?
PostPosted: Thu Oct 31, 2019 10:35 am 
*Proud to be a*
*Proud to be a*

Joined: Sat Jan 04, 2014 4:23 pm
Posts: 772
Location: South Arkansas
Sample Problem: [i]A case of 5000 wads costs $68. :wink:[/quote]

Wow! $68 per case! That is a bargin.
Mind saying where and what wad?

bp

_________________
Retirement expert


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Thu Oct 31, 2019 11:50 am 
Utility Grade

Joined: Sun Jul 16, 2017 9:24 pm
Posts: 12
mark-60 wrote:
I've never had any problems with it. I've been more distracted by other people in the car I'm having a conversation with, or even when a good tune comes on.



Agreed Mark. I listen to Audiobooks while driving and reloading and have no issues keeping track of either activity. Also, as far as the spreadsheets, yes I can do the math. I choose to do them in a spreadsheet (where I keep all my load data) so I don't have to do it again if I am trying to recall what I pay to make my ammo. It takes seconds to do and its there if I want to look at it. I constantly get assked what my costs are for various loads. I load for a lot calibers ( like many of us) so this is a simple way to keep records that works for me. To each his own i guess.


Mum-O-Killowe


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Thu Oct 31, 2019 4:14 pm 
Crown Grade

Joined: Sun Mar 03, 2013 11:01 am
Posts: 6393
Location: Newton Kansas
Mum-O-Killowe wrote:
I constantly get asked what my costs are for various loads.

And that right there is the difference between us.

The ONLY time I have EVER been asked about my costs to handload ammo, is people on message forums asking the entire forum "what does it cost you", and EVEN THAT (exception for SGW because it's an obsession around here) is less than once a year, on all the rest of the forums combined.

40 years, 20 on The Internet, and I have been personally asked about how much my ammo costs fewer times than fingers on both hands.

_________________
I don't always venture out into the sub-freezing darkness, but when I do, it is hunting season, and I carry a Browning. Stay hungry my friends.


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Thu Oct 31, 2019 5:22 pm 
*Proud to be a*
*Proud to be a*
User avatar

Joined: Sun Dec 19, 2010 1:27 am
Posts: 8186
Location: Silicon Valley
Here's mine -- pretty simple to follow, just enter costs up at the top, powder in the grid for the appropriate load/gauge, and the sheet does the rest. Click the link, it will open a view of the spreadsheet in DropBox, click the download icon and that will DL the xlsx spreadsheet file to your computer: https://www.dropbox.com/s/fwzg0c4qkty8i ... .xlsx?dl=0

_________________
Jack
NSCA #617422

When the mind is right, the body will find a way...


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Mon Nov 04, 2019 7:02 pm 
Utility Grade

Joined: Sun Jul 16, 2017 9:24 pm
Posts: 12
OldStufferA5#1911 wrote:
Mum-O-Killowe wrote:
I constantly get asked what my costs are for various loads.

And that right there is the difference between us.

The ONLY time I have EVER been asked about my costs to handload ammo, is people on message forums asking the entire forum "what does it cost you", and EVEN THAT (exception for SGW because it's an obsession around here) is less than once a year, on all the rest of the forums combined.

40 years, 20 on The Internet, and I have been personally asked about how much my ammo costs fewer times than fingers on both hands.


haha I bet there are many more differences. I'd bet on your shooting and loading experience over my limited knowledge / skillset. I do shoot a lot ( mostly IPSC and 3 Gun ) and I have met exactly 2 guys that still reload shotgun up here so I often get asked what my costs are for shotgun as guys assume I've found a $0.15 load or why would I bother. Reloading is an extension of the hobby of shooting for me that keeps me connected to it when I can't get to the range. Having a cost analysis ( that admittedly is not accurate with fluxuating costs ) is just another small part of it for me.

I see you're in Newton, Ks. I'm originally from Wichita but live in Canada now. Just got back for a couple weeks about a month ago. Was good to see the Motherland. :)

Cheers,

Mum-O_Killowe


Top
 Profile  
 
 Post subject: Re: Reloading on an Excel Spreadsheet?
PostPosted: Wed Feb 03, 2021 12:07 pm 
Utility Grade
User avatar

Joined: Mon Sep 21, 2020 8:23 am
Posts: 5
Location: Arizona Phoenix
I love using Excel to track what I've used and what I need on average for a month. There is not an easier way than that.I'm tired also of writing it on papers as I tend to lose them all time, and then I have to start everything again from scratch! So for me using a Google sheet is the most comfortable way. The only thing I never liked about them is that I had to find how to remove duplicates in google sheets which was a challenge to do one by one as it took me half a day.




Last edited by Naclean on Thu Feb 04, 2021 5:56 pm, edited 1 time in total.

Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 43 posts ]  Go to page Previous  1, 2, 3  Next

All times are UTC - 6 hours [ DST ]


Who is online

Registered users: Bing [Bot], Google [Bot], Google Adsense [Bot], Google Feedfetcher, llc, mikeydio, Patently Obvious, Rack-N-Roy, reddog reddog, SuperXOne, zxcvbnm


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group    - DMCA Notice