» Advanced

Go Back   Shooters Forum > Handloading > Handloading Procedures/Practices
Register FAQ Members List Donate Calendar Search Today's Posts Mark Forums Read



Reply
 
LinkBack Thread Tools Rate Thread Display Modes
  #1  
Old 02-18-2008, 06:07 PM
Beartooth Regular
 
Join Date: Dec 2003
Location: Winchester, VA
Posts: 568
Excel file for Reloading Data


Registered Users do not see the above ad.


I have recently compiled a few data sheets that I use when I reload. They are in Excel format so if you have Excel you may find them useful. I have a link on my webpage that will allow you to download the spreadsheets if anybody is interested.

http://www.brleather.net/ReloadingData.html
__________________
Hunting is not a necessity.......it is an obsession!
Reply With Quote
  #2  
Old 02-19-2008, 09:42 AM
TMan's Avatar
Beartooth Regular
 
Join Date: Jan 2006
Location: NJ - But Not For Long :)
Posts: 2,969
Nice Job Bigbore, and right decent to share your effort.

I have maintained a logbook, using a Research Notebook, for many years, and document much the same data. It's an interesting exercise. I also have a tracking number to trace the date etc. of all of the loads I put in a box, also very handy.

By maintaining a Page/Item trail(Pg.42/Item #3, etc), I can have a complete history of accuracy, velocity, and brass life for a load. Good records is the difference between handloading, and case stuffing.
Reply With Quote
  #3  
Old 02-19-2008, 06:33 PM
Beartooth Regular
 
Join Date: Jan 2004
Location: Northern Virginia
Posts: 463
Big Bore,
I like your format. I also use excel to keep my reloading records (must be a Winchester thing). It sure beats notes in the margins of a reloading manual. I also paste pictures of the groups I shoot on the spread sheet.
Reply With Quote
  #4  
Old 02-20-2008, 02:22 PM
Beartooth Regular
 
Join Date: Dec 2003
Location: Winchester, VA
Posts: 568
Thanks for the comments guys. I hope you find it useful.
__________________
Hunting is not a necessity.......it is an obsession!
Reply With Quote
  #5  
Old 02-24-2008, 05:22 AM
Beartooth Regular
 
Join Date: May 2001
Location: Eastern NC
Posts: 107
Thanks for sharing this spreadsheet, and especially for sharing it - it is far superior to the one I developed for my use. Thanks, Odessa
Reply With Quote
  #6  
Old 02-24-2008, 07:49 AM
flashhole's Avatar
Beartooth Regular
 
Join Date: May 2004
Location: Owego, NY - USA
Posts: 2,974
Yes, thanks from me too. A lesson learned experience - I kept detailed records of all my load development on my computer. When I needed to load something I just went and reviewed my records. I seldom (if ever) printed my data sheets as I would just go to the computer for reference. The hard drive failed and I lost everything I had. Now I print an updated version every time I make an addition or change to the data sheet. Fortunately I kept a hand written note in every box of ammo I loaded so I could go back and resurect my data.
__________________
Remember - always have your democrats neutered or spayed - Ann Coulter
Reply With Quote
  #7  
Old 02-24-2008, 02:34 PM
Registered User
 
Join Date: Jul 2005
Location: DFW TEXAS
Posts: 17
VA big bore Excellent file you got there. Hope to move to it soon. Thanks for sharing.
__________________
Member of Lone Star Paralyzed Veterans
[U]http://www.lspva.com[/U]
USS LEXINGTON CVT-16 VNE V-2 CATS ABE2
Reply With Quote
  #8  
Old 03-20-2008, 03:51 AM
Beartooth Regular
 
Join Date: Apr 2001
Location: S.C.
Posts: 4,158
I am no computor guy but I got it downloaded and made a shortcut so I can find it on my desktop. I hope it allows me to learn excel and store my load data. Thanks a lot. It looks very good. I use Marshall's paper record keeping system for field and now I can come home and enter it here and see if I get some value out of the info.
Reply With Quote
  #9  
Old 03-20-2008, 02:56 PM
Beartooth Regular
 
Join Date: Dec 2003
Location: Winchester, VA
Posts: 568
I'm glad you liked the layout. Hope you find it helpful.
__________________
Hunting is not a necessity.......it is an obsession!
Reply With Quote
  #10  
Old 03-22-2008, 06:36 AM
Beartooth Regular
 
Join Date: Apr 2001
Location: S.C.
Posts: 4,158
OK VaB. I have a couple questions. Could you send a copy of one of your filled out pages so I could see the relationships of the sections and the data. I guess I am not relating a shooting session to the data sheet. Dates are not there. Weather conditions. Do the rounds fired in the bottom section correspond to the number of the bullet at the top?

What about the firearm the round is fired from? Is that a new sheet with the firearm in the Cartridge info title. What about a comments section? Do you put those in?

I am really enjoying getting this set up. I am trying to go back and install old data. I sure wish I had this during the winter. Too much to do now.

Thanks VaB
Reply With Quote
  #11  
Old 03-23-2008, 05:06 PM
Beartooth Regular
 
Join Date: Dec 2003
Location: Winchester, VA
Posts: 568
Quote:
Originally Posted by Chief RID View Post
OK VaB. I have a couple questions. Could you send a copy of one of your filled out pages so I could see the relationships of the sections and the data. I guess I am not relating a shooting session to the data sheet. Dates are not there. Weather conditions. Do the rounds fired in the bottom section correspond to the number of the bullet at the top?
You can view any of the data that I have posted by downloading one of the excel files I have listed on the page http://www.brleather.net/ReloadingData.html. Just list your data for each round to the right. First load info, then your grouping (largest of 5 shots then smallest of the same 5 shots), then list the chronoed velocities for those 5 shots. The rest will be calculated for you.

Quote:
What about the firearm the round is fired from? Is that a new sheet with the firearm in the Cartridge info title. What about a comments section? Do you put those in?
You can add whatever data you want to the page. The cells are not locked (at least I don't remember locking them). Just type in any open space the information you want to add for the loaded data.

Quote:
I am really enjoying getting this set up. I am trying to go back and install old data. I sure wish I had this during the winter. Too much to do now.
Glad you like it, hope it helps. If you are still at a loss just let me know. I will be out of town for the next week, but I will get back to you when I return.
__________________
Hunting is not a necessity.......it is an obsession!
Reply With Quote
  #12  
Old 11-30-2008, 11:28 AM
Beartooth Regular
 
Join Date: Apr 2001
Location: S.C.
Posts: 4,158
Help VA B

do you know how to copy and past data from your spreadsheet to a post on this forum? I would like to share some data I put in your spreadsheet but I don't know how to transfer it to the forum I tried attaching it as a file but I guess xls files don't attach. I tried doing a ctrl c & v but it did not work. Have you got any ideas?

The spreadsheet is working great.
Reply With Quote
  #13  
Old 11-30-2008, 11:40 AM
Jack Monteith's Avatar
Beartooth Regular
 
Join Date: Dec 2000
Location: Saskatchewan
Posts: 7,788
I wonder if the CTRL-C is copying the underlying formulas too. Try copying from Excel to Notepad, then from Notepad to Beartooth. You may have the option of saving as text too. If you can, paste that into Beartooth.

Bye
Jack
Reply With Quote
  #14  
Old 11-30-2008, 01:34 PM
unclenick's Avatar
Super Moderator
 
Join Date: Jan 2005
Location: Hilliard, Ohio
Posts: 10,914
I think Jack is right. Try this:

Use the Excel Insert menu to add a worksheet. Select and copy the cells you want to post. Go to the new worksheet and right click on the upper left-most cell you want to include. From the small flyout menu that appears, select Paste Special. In the Paste Special menu check Values. Then paste. This will create an identical looking sheet that has no underlying anything, but just the last set of results.

Use the new page to copy to the forum. Select the cells you want us to see. If CTRL+C and CTRL+V are not working for you, substitute CTRL+Insert for copy and SHIFT+Insert for paste. These almost always work when other keystroke combinations do not.

Before pasting into the forum, type the word "code" surrounded by square brackets, followed by "/code" surrounded by square brackets. Paste your copied Excel file sheet right between the two bracketed texts. Using square brackets tells the forum to execute an HTML tag. That's why I can't actually type the brackets here to show you, or it will execute the code tag. The /code tells it the tag execution is done. What using the code tag will do is stop the system from automatically removing extra spaces and will force it to show what you have organized as you inserted it. Us the Go Advanced button on your editing window to see how it will actually look before you post it and to have an opportunity to make corrections.
<table x:str="" style="border-collapse: collapse; width: 48pt;" border="0" cellpadding="0" cellspacing="0" width="64"><col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt; width: 48pt;" x:num="0.79970683292919986" align="right" width="64" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="0.8769026377803999" align="right" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="1.0016778328676001" align="right" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="1.0795497209027998" align="right" height="17">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl22" style="height: 12.75pt;" x:num="1.2036488328060002" align="right" height="17">
</td> </tr> </tbody></table>
__________________
Nick
__________________________
Orange Hat Family Member
CMP Certified GSM Master Instructor
NRA Certified Instructor
NRA Benefactor Member
"First contemplation of the problems of Interior Ballistics gives the impression that they should yield rather easily to relatively simple methods of analysis. Further study shows the subject to be of almost unbelievable complexity." Homer Powley
Reply With Quote
  #15  
Old 11-30-2008, 04:36 PM
Beartooth Regular
 
Join Date: Apr 2001
Location: S.C.
Posts: 4,158
I think that worked as good as it could. It did not come over right but I think it is codes in the original sheet that has it messed up. Good work and thanks for the help. I learned something today.
Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
10 gauge 2-7/8 inch shotshell reloading data mscoble Shotguns, Shotgunning, and Shotshell Reloading 7 07-25-2008 12:06 PM
Load Data for 110 Gr HP Smitty357 Handloading Procedures/Practices 31 02-24-2008 07:23 AM
Alliant Reloading Data slickyboyboo Shotguns, Shotgunning, and Shotshell Reloading 0 02-14-2008 12:01 PM
45-70 reload data Flashole Big-Bore Lever Guns 3 02-10-2008 12:23 PM
Concerns w/ Hodgdon 2004 25-35 data gmushial Handloading Procedures/Practices 0 05-25-2005 09:10 PM


All times are GMT -8. The time now is 06:54 AM.

< Contact Us - Shooters Forum - Archive >

 
 

All Content & Design Copyright © 1999-2002 Beartooth Bullets, All Rights Reserved
View Privacy Policy | Contact Webmaster | Legal Information
Website Design & Development By Exbabylon Internet Solutions
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2