OCW spreadsheet...I was REALLY bored tonight...

[jayd4wg]

http://dl.dropbox.com/u/42863631/OCW%20Worksheet.xls

serves purpose to mark the slots in a standard 50 round MTM R-50 case (5x10 slots)

Nothing special, just does the math for you and has enough adjustability built in to keep most folks happy. if you really want to hack up the formulas, sheet password is "snipershide"

 

[jbailey]

Re: OCW spreadsheet...I was REALLY bored tonight...

that's a nice analysis tool. thanks for sharing it!

 

[SavageLapua]

Re: OCW spreadsheet...I was REALLY bored tonight...

I like it. I have a similar excel doc. I'll share it when i get home tonight.

 

[jayd4wg]

Re: OCW spreadsheet...I was REALLY bored tonight...

i made a couple more changes last nite that I didn't upload. It now prints with a target for each load, labelled with the powder charge or each slot on a 1/2" by 1/2" grid, and a smaller "lid label" that can be taped inside the ammo box (again, sized for the MTM-50 box)

So it basically does everything but measure and interpret the results for you. now to load some shit up and hit the range

 

[tigerfan_9]

Re: OCW spreadsheet...I was REALLY bored tonight...

can you upload those changes? sounds like a great tool....

 

[jayd4wg]

Re: OCW spreadsheet...I was REALLY bored tonight...

working on the spacing for the target sheets to get them lined up right...i have my first try looking okay, but the actual measurements are off. if i get rid of the grid it looks better...and we all have calipers, right?

 

[deadnbrkn84]

Re: OCW spreadsheet...I was REALLY bored tonight...

tag

 

[jayd4wg]

Re: OCW spreadsheet...I was REALLY bored tonight...

changes uploaded...tweaking still needed

http://dl.dropbox.com/u/42863631/OCW%20Worksheet.xls

 

[DCR]

Re: OCW spreadsheet...I was REALLY bored tonight...

Ha! This beats the heck out of writing powder weight on the brass with a sharpie. I'll be using it. Thanks!

 

[Huckleberry75]

Re: OCW spreadsheet...I was REALLY bored tonight...

Now if we just add a bar below that with another group of windows and plug in the formula for cal'cing the SD and ES, it would be damn near awesome. I added these formulas and will send it to Jason.


BTW, Big Thanks to Jason for taking the time to put this together.

 

[jayd4wg]

Re: OCW spreadsheet...I was REALLY bored tonight...

Thanks Huckleberry75...took yours and added a little more.

next version will have the formulas for comparing group sizes to add some additional analytics.

I actually see this as the beginning of a database for folks to dump load and OCW data for others to see/compare.

http://dl.dropbox.com/u/42863631/OCW%20Worksheet%201.2.xls

 

[OneShotJim]

Re: OCW spreadsheet...I was REALLY bored tonight...

Thanks JasonB. That looks like a great tool to organize OCW data. Will look closer & play with it when I get home.

 

[OKbow87]

Re: OCW spreadsheet...I was REALLY bored tonight...

This is awesome! Thanks a bunch for taking the time to make this.

 

[Huckleberry75]

Re: OCW spreadsheet...I was REALLY bored tonight...

Digging the updates, Jason. Guess I will have to go try it out today.

 

[Hookman]

Re: OCW spreadsheet...I was REALLY bored tonight...

Great job Jason! Thanks..