Database Spreadsheets

From a simple notebook to software, tell us about what you use or ask questions before you purchase
Locked
User avatar
44-40 Willy
Founding Member
Founding Member
Posts: 32
Joined: 30 Jun 2013 09:16
My Press Choice: Turret
Location: Dyer TN
Has thanked: 5 times
Been thanked: 7 times

Database Spreadsheets

Post by 44-40 Willy »

I use a spreadsheet database in Open Office to keep my loading data in. I originally started it on my first computer in Lotus 123, then switched to Microsoft Office on the next two computers. When I got this one, I just installed the free Open Office and switched it all over to that. I use a separate spreadsheet for each caliber that I load for.

My sheets will calculate muzzle energy and Taylor Knockdown factor once you put in bullet diameter, weight and velocity. I keep back up copies on a portable hard drive in case my computer bites the dust.
User avatar
Ranch Dog
Site Admin
Site Admin
Posts: 6457
Joined: 22 Jun 2013 17:16
My Press Choice: Progressive
Location: Inez, TX
Has thanked: 1617 times
Been thanked: 2850 times

Re: Database Spreadsheets

Post by Ranch Dog »

Any chance of attaching a worksheet for others to work with?
Michael
Image
User avatar
44-40 Willy
Founding Member
Founding Member
Posts: 32
Joined: 30 Jun 2013 09:16
My Press Choice: Turret
Location: Dyer TN
Has thanked: 5 times
Been thanked: 7 times

Re: Database Spreadsheets

Post by 44-40 Willy »

Sure, no problem. Here's a partial on my 357 Mag sheet for Microsoft Office. I left some data in there to show how it's set up.

I looked at the Open Office sheet and apparently my calculations didn't translate well in the changeover from MS Office. Guess I need to redo them.
You do not have the required permissions to view the files attached to this post.
User avatar
joec
Founding Member
Founding Member
Posts: 78
Joined: 30 Jun 2013 09:25
My Press Choice: Turret
Location: Lexington Kentucky
Been thanked: 12 times

Re: Database Spreadsheets

Post by joec »

I downloaded a freeware app about 2 years ago called Reloaders Reference that was good but had some bugs and things I didn't need. So I basically wrote another screen start up added some table for my needs as well as some reports using parts of the original program RRv93x74r. When I get a chance I will make a version with none of my data in it and up loaded here if I can. It is rather large however especially with attached gun manuals and targets sheets you can print out.
Joe
User avatar
Doc with a Glock
Posts: 10
Joined: 30 Jun 2013 09:19
My Press Choice: Lee Loader
Location: Montana "Big Sky Country"
Been thanked: 6 times

Re: Database Spreadsheets

Post by Doc with a Glock »

I created an Excel spreadsheet ballistic calculator, generates hi, lo, extreme spread, and std. deviation for chronograph info entered.

Doc
You do not have the required permissions to view the files attached to this post.
User avatar
Doc with a Glock
Posts: 10
Joined: 30 Jun 2013 09:19
My Press Choice: Lee Loader
Location: Montana "Big Sky Country"
Been thanked: 6 times

Re: Database Spreadsheets

Post by Doc with a Glock »

I wrote another Excel spreadsheet to calculate Lee's Pressure and Velocity factors from the Lee loading manual, 1st. Ed. The numbers in rows 2 , etc. are placeholders and are to be replaced with your own values.

Doc
You do not have the required permissions to view the files attached to this post.
User avatar
Neted
Founding Member
Founding Member
Posts: 24
Joined: 01 Sep 2013 22:05
My Press Choice: Progressive
Location: NJ
Been thanked: 5 times

Re: Database Spreadsheets

Post by Neted »

Doc with a Glock wrote:I created an Excel spreadsheet ballistic calculator, generates hi, lo, extreme spread, and std. deviation for chronograph info entered.

Doc
Thanks Doc, I'm going to give this a try next weekend.
User avatar
akuser47
Moderator & Supporter
Moderator & Supporter
Posts: 1397
Joined: 30 Jun 2013 09:16
My Press Choice: Single Stage
Location: ohio
Has thanked: 666 times
Been thanked: 266 times

Re: Database Spreadsheets

Post by akuser47 »

Great work guys and thanks we all can gain from this.
Image
Live Free,Ride Free, Or Die Fighting, For The Right, To do So!
weaselfire
Posts: 11
Joined: 11 Oct 2013 17:26
My Press Choice: Hand Press
Location: Naples, FL
Been thanked: 1 time

Re: Database Spreadsheets

Post by weaselfire »

Okay, what the heck is a "Spreadsheet Database?" That's like driving a Ford Chevy into town for Firewood Groceries.

You're using a spreadsheet, not a database. [SMILING FACE WITH SMILING EYES]

And I've spent way too many decades in computers and software...

Jeff
Locked

Return to “Other Load Record Keeping Sytems”