Inventory

[RealGun]

I got my spreadsheet set up, for lack of a relational database, and thought the summary might be of interest:

14 cartridges
36 loads
15 active powders
5 types of primers

This is all handgun, mostly revolver. I am equipped to also do 30-30, .223/5.56, and .410 but have never done it.

The actual armory was lost in a flood.

 

[clutch]

Spreadsheets make for a nice flat file. Now you can have a tab per cartridge or gun. I think a relational database would be a bit of over kill.

KISS

 

[RealGun]

Stating all the load variables in a spreadsheet is kludgy. I confine it to bullet and powder/primer. On taper crimps I include COL. The rest is in the comments. That requires more than one row per cartridge, so it's not something you would want to sort.

I am a retired application designer and have used Excel and Access extensively, but I don't have a current version of Access and would be rather rusty using it for a small scale application.

 

[Shootshellz]

What is a spreadsheet?

 

[Paddy]

Kinda like this, only different.

 

[AnselHazen]

Kinda like this, only different.

Does that run on Android?

 

[Duvel]

I believe I'm at the limits of what spreadsheet can do, and will eventually have to migrate to a DB.

1 cartridge
255 loads (71 pending)
26 powders

 

[dragon813gt]

If I can't recall off the top of my head or physically go count it then it doesn't exist I know I have enough. I don't need to complicate this aspect w/ a spreadsheet. The only spreadsheet I made is to keep track of my molds.

 

[Duvel]

Does that run on Android?

No, Knutella only runs on iOS.

 

[mstreddy]

But Gnutella runs on Android -- no proprietary source here!


Back to reloading related, I've thought of access, but I haven't messed with it in a long time, and frankly don't have the time to do so these days.

I'm using an excel sheet with some calcs for powder use, primer and bullets. One tab per cartridge, 28 cartridges so far.
I had to add the bullet inventory feature as I had to keep track of stocks for reorder, particularly 9MM.

 

[Bula]

If you need MS Access for table and dbase functionality, I think there may be a need to streamline processes. Holy cow 200 plus loads for a single caliber? Now that's conviction!!

 

[Duvel]

It's a project that grew into a monster, a 10mm monster, and a hobby I really enjoy

The other 4 calibers I load for don't quite have as many

 

[Shootshellz]

What is a spreadsheet?

 

[RealGun]

I think we have had quite enough comedians stopping by.

 

[GW Staar]

This is a downloadable spreadsheet: (one I made for a small specialty forum....you need Excel....some have reported that it works on Open Office too)

http://2amunitions.boards.net/attachment/download/37

You're welcome.

 

[vaalpens]

The spreadsheet is a good tool to use. I use it to keep track of all my loads, recorded chrono data, recorded accuracy test data, ammo inventory, selected loads, load data, bullet OAL, etc., etc.

I was also thinking of start using a database, but realized I would spend more time designing the application and tables than capturing data, so i just kept on adding to the spreadsheet.

A great spreadsheet tool I use is the Pivot Table, which I use to summarize my data.

 

[Duvel]

The spreadsheet's almost unlimited size and 'flat' format make it really appealing, but using it as a front end to interpret data becomes clumsy (at least to a casual user). I did seek advice on what I thought was going to be a fairly simple formula, and found I needed to use arrays.

I'll probably just use it as a data source.

This has nothing to do with efficiently locating the "perfect load" out of a catalog of many, and much more about the behavior of powders at temperature ranges, as pressures rise, QL predictions vs PTII, ect.

It's a project