Go Back   Maryland Shooters > Topics of Interest > The Depot

Reply
 
Thread Tools Display Modes
Old August 22nd, 2009, 04:54 PM   #1
amish
Senior Member
 
amish's Avatar
 
Join Date: Aug 2008
Location: Fredneck
Posts: 1,252
Ammo Inventory Program

Currently I try to keep a inventory of all my ammo using a crude spreadsheet, however it doesn't fit my needs that well.

I'm looking for an ammo inventory program. I've found some firearm programs, but they are more geared towards gun inventory.

What I would like is to be able to create a ammunition type, record initial inventory. Then as I buy or shoot ammo, I can create entries that log that and update the total. Inputting variables such as purchase price and location would be great as well.

Also, currently with my spreadsheet, I have two ammo sources. One a long term inventory stored in ammo cans (think of your savings account). The other is ammo stored in my range bag (think cash in your wallet). I track the ammo can inventory closely, but the range bag ammo not so much. It would be cool for an app to be able to move ammo between storage locations.

Has anyone seen anything like this?


__________________
"Worrying is like a rocking chair, it'll give you something to do but won't get you anywhere."
amish is offline   Reply With Quote
Old August 22nd, 2009, 04:59 PM   #2
snavematt
say what?
 
snavematt's Avatar
 
Join Date: May 2009
Location: Stafford, VA as of 5/7/13
Posts: 4,795
I havent seen one, if I was better at pivot tables with excel Im sure I could come up with one. Anyone good with excel
snavematt is offline   Reply With Quote
Old August 22nd, 2009, 07:24 PM   #3
Jimbob2.0
Senior Member
 
Join Date: Feb 2008
Posts: 11,315
Images: 22
I havent but I would think a little excel spreadsheet would work fine with a few macros (I suck at it)_ frankly I wouldnt be able to keep up with it.

I have just started a "gun inventory", timed with my annual oil and corrosion check. It has revealed to me that I have to many guns (seriously).

P.S. you will start seeing some photos as I have been "linking" a photo to each spreadsheet line. This might be useful for surplus ammo too to get a a photo of the headstamp.
Jimbob2.0 is offline   Reply With Quote
Old August 22nd, 2009, 09:51 PM   #4
Nanook
F-notso-NG-anymore
 
Nanook's Avatar
 
Join Date: Feb 2009
Location: In one REALLY F'd up state
Posts: 1,922
Images: 2
Tin foil hat time: what are the odds that the .gov folks are riding our computers seeing who has what.....?


__________________
NRA/VFW Life Member
Former NRA LE Firearms Instructor
Not an "operator" and I'm okay with that
Slightly more than an 'Average Joe'

Have you taken a fence-sitter shooting today?
Nanook is offline   Reply With Quote
Old August 22nd, 2009, 10:02 PM   #5
DD214


Founder/Head Geek

 
DD214's Avatar
 
Join Date: Apr 2005
Location: Calvert County
Posts: 13,935
Images: 26
Quote:
Originally Posted by Nanook View Post
Tin foil hat time: what are the odds that the .gov folks are riding our computers seeing who has what.....?
Mac: 0.686%
Windows: 3.953%
Linux: 0.538%


__________________


Tolerance is the virtue of the man without convictions.
--G.K. Chesterton
DD214 is offline   Reply With Quote
Old August 22nd, 2009, 10:07 PM   #6
mudd4life88
Member
 
mudd4life88's Avatar
 
Join Date: Mar 2009
Location: Essex, MD
Posts: 931
We use a free download from cnet to help with our off the record inventory at work. It will track amounts, different suppliers, when to restock etc.. It could be adapted for ammo inventory. It's called Inflow Inventory Software.


__________________
If all of this seems like a great deal of trouble, think what's at stake. We are faced with the most evil enemy mankind has known in his long climb from the swamp to the stars. There can be no security anywhere in the free world if there is no fiscal and economic stability within the United States. Those who ask us to trade our freedom for the soup kitchen of the welfare state are architects of a policy of accommodation.

President Ronald Reagan
mudd4life88 is offline   Reply With Quote
Old August 22nd, 2009, 11:15 PM   #7
amish
Senior Member
 
amish's Avatar
 
Join Date: Aug 2008
Location: Fredneck
Posts: 1,252
Quote:
Originally Posted by Nanook View Post
Tin foil hat time: what are the odds that the .gov folks are riding our computers seeing who has what.....?
That's why I keep that excel file in an encrypted container. TrueCrypt. I love it.


Quote:
Originally Posted by mudd4life88 View Post
We use a free download from cnet to help with our off the record inventory at work. It will track amounts, different suppliers, when to restock etc.. It could be adapted for ammo inventory. It's called Inflow Inventory Software.
Thanks, I'll take a look at it.


__________________
"Worrying is like a rocking chair, it'll give you something to do but won't get you anywhere."
amish is offline   Reply With Quote
Old August 23rd, 2009, 12:28 AM   #8
blindnoodle
Livin' the dream!
 
Join Date: Apr 2009
Posts: 1,403
Quote:
Originally Posted by amish View Post
That's why I keep that excel file in an encrypted container. TrueCrypt. I love it.
And they love you for using it... (and telling them what it is.)
blindnoodle is offline   Reply With Quote
Old September 8th, 2009, 03:04 PM   #9
omalon
Junior Member
 
omalon's Avatar
 
Join Date: Aug 2009
Location: Anne Arundel
Posts: 26
Quote:
Originally Posted by mudd4life88 View Post
We use a free download from cnet to help with our off the record inventory at work. It will track amounts, different suppliers, when to restock etc.. It could be adapted for ammo inventory. It's called Inflow Inventory Software.
I have been using the free version of InFlow Inventory Programfor the past 2 months and it's much easier than the Excel Spreadsheet I was using. I set my guns up as customers and I can track the ammo use for each gun. The reports are very easy to use and gives me a excellent idea of the cost per gun and the ammo used by each gun.

Best thing, is the prgram is free....................
omalon is offline   Reply With Quote
Old September 8th, 2009, 04:37 PM   #10
mpickering
Member
 
Join Date: Mar 2007
Location: Shores of the Bay, MD
Posts: 857
If someone would like something custom developed, let me know. Always looking for little projects to do for cross-platform. I can write code for Windows, Mac and Linux so if there are specific desires/needs, I'd be happy to take a swing. Either standalone or web-based.

Matt
mpickering is offline   Reply With Quote
Old September 8th, 2009, 05:00 PM   #11
guthook
Grrr.
 
guthook's Avatar
 
Join Date: Apr 2008
Location: St. Mary's
Posts: 6,576
Images: 13
Still using Excel. Keeps track of model, ser#, caliber, magazines, finish, accessories and any add-ons. It works for what I need it for and easy to backup. I just have to remember and update the description everytime I change one of the AR-15s characteristics or get another mag...


__________________
_______________________________________

Nothing clever to read here. Move along.
guthook is offline   Reply With Quote
Old September 9th, 2009, 08:16 PM   #12
IndispensableDestiny
Senior Member
 
IndispensableDestiny's Avatar
 
Join Date: Apr 2009
Location: Hazzard Precinct, Harford County, MD
Posts: 2,158
You have way too much time on your hands!
IndispensableDestiny is offline   Reply With Quote
Old September 9th, 2009, 08:29 PM   #13
gdubyacobb
Member
 
gdubyacobb's Avatar
 
Join Date: Mar 2009
Location: Patagonia Arizona
Posts: 319
I use Excel and it works out fine.


__________________
"Don't ever trust a man who doesn't like John Wayne. A man's opinion of John Wayne is a good rule-of-thumb test of his character and moral values. To admire John Wayne is to admire the heroic and the morally noble. To sneer at John Wayne is to admire the opposite."
So I ask, are you a John Wayne man or a Woodie Allen guy?
gdubyacobb is offline   Reply With Quote
Old September 9th, 2009, 08:31 PM   #14
smokey0118
2A TEACHER
 
smokey0118's Avatar
 
Join Date: Jan 2008
Location: Annapolis
Posts: 17,633
Images: 33
one of our members posted a program on here a while back to keep inventory of your firearms and ammo....i'll try to find the thread


__________________
MSI EXECUTIVE MEMBER:

"It's hard not to be a menace to society, when half the population is happy on their knees"

Is minic a gheibhean beal oscailt diog dunta!
smokey0118 is offline   Reply With Quote
Old September 9th, 2009, 08:35 PM   #15
Inigoes
Head'n for the hills
 
Inigoes's Avatar
 
Join Date: Dec 2008
Location: SoMD / West PA
Posts: 29,580
Quote:
Originally Posted by gdubyacobb View Post
I use Excel and it works out fine.
Inigoes is offline   Reply With Quote
Old September 9th, 2009, 08:39 PM   #16
smokey0118
2A TEACHER
 
smokey0118's Avatar
 
Join Date: Jan 2008
Location: Annapolis
Posts: 17,633
Images: 33
http://www.mdshooters.com/showthread.php?t=9957

use this! it kicks butt. i use it for all my guns and it has an ammo section too


__________________
MSI EXECUTIVE MEMBER:

"It's hard not to be a menace to society, when half the population is happy on their knees"

Is minic a gheibhean beal oscailt diog dunta!
smokey0118 is offline   Reply With Quote
Old September 9th, 2009, 08:44 PM   #17
DD214


Founder/Head Geek

 
DD214's Avatar
 
Join Date: Apr 2005
Location: Calvert County
Posts: 13,935
Images: 26
Quote:
Originally Posted by mpickering View Post
If someone would like something custom developed, let me know. Always looking for little projects to do for cross-platform. I can write code for Windows, Mac and Linux so if there are specific desires/needs, I'd be happy to take a swing. Either standalone or web-based.

Matt
Do you know Objective-C?


__________________


Tolerance is the virtue of the man without convictions.
--G.K. Chesterton
DD214 is offline   Reply With Quote
Old September 9th, 2009, 09:12 PM   #18
amish
Senior Member
 
amish's Avatar
 
Join Date: Aug 2008
Location: Fredneck
Posts: 1,252
Quote:
Originally Posted by smokey0118 View Post
http://www.mdshooters.com/showthread.php?t=9957

use this! it kicks butt. i use it for all my guns and it has an ammo section too
I tried getting it to work awhile ago, but it always produced an error.


__________________
"Worrying is like a rocking chair, it'll give you something to do but won't get you anywhere."
amish is offline   Reply With Quote
Old September 9th, 2009, 09:16 PM   #19
smokey0118
2A TEACHER
 
smokey0118's Avatar
 
Join Date: Jan 2008
Location: Annapolis
Posts: 17,633
Images: 33
you have to go in and manually create a folder called "pics" or else the program can't send the pictures anywhere...it tells you how in the readmefirst doc


__________________
MSI EXECUTIVE MEMBER:

"It's hard not to be a menace to society, when half the population is happy on their knees"

Is minic a gheibhean beal oscailt diog dunta!
smokey0118 is offline   Reply With Quote
Old September 9th, 2009, 09:26 PM   #20
amish
Senior Member
 
amish's Avatar
 
Join Date: Aug 2008
Location: Fredneck
Posts: 1,252
I think I got a bigger issue than that.

During installation it goes through about a dozen .dll's that are newer on my computer, but it wants to replace. I keep my newer ones.

Adding a gun works. However when I click an ammo button, I get the following error:

"Run-time error '401':
Can't show non-modal form when modal form is displayed

Clicking 'Ok' closes the program. Haven't had time to troubleshoot anymore.


__________________
"Worrying is like a rocking chair, it'll give you something to do but won't get you anywhere."
amish is offline   Reply With Quote
Reply

  Home Page > Forum List > Topics of Interest > The Depot


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 05:22 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
2013, Maryland Shooters, LLC