Chrono Data Spreadsheet?

[markwilliston]

Do any of you guys have an excel spreadsheet setup for chrono data or something similar? Now that I have my chrono up and running and collected a bunch of data from it, it just reminded me how much I hated doing statistics back in college....

[Joe4d]

I use RCBS.Load version 2.88 works well you plug in the raw data and it gives you all the stats you could want.

[XD Niner]

If you PM me with your email address, I will be happy to send you the Excel workbook that I created and use.

Edited March 14, 2007 by XD Niner

[iainmcphersn]

I put it together a couple years ago. Nothing special, I designed it so I could enter data onto my iPAQ and sync it at home later. I can email you a copy if you like.

John

Edited March 14, 2007 by iainmcphersn

[shred]

I've got one that puts an entire load onto one line and does the PF, ES & SD calcs.

something like so:

Bullet wt	mfg/type	amount	powder	OAL	avg vel	KE	PF	gun	date	temp 'F	environment	notes		ES	SD	vel 1 2 3 4 5 6 7 8 9 10

The formulas are like so:

R4:AA4 is the velocity slots
F4 is average velocity
A4 is the bullet weight

avg vel = AVERAGE(R4:AA4)			  
ke = ((F4*F4)/450240)*A4				 
pf = (A4*F4)/1000
es = (MAX(R4:AA4)-MIN(R4:AA4))
sd = STDEVP(R4:AA4)

[markwilliston]

XD Niner, that works perfect thanks. It's been a long time since I really worked with excel, and looking at a big blank page sure had me wondering where the hell to start

Thanks guys

Mark

[markwilliston]

Shred, that one is about 2 floors over my head

[XD Niner]

You're very welcome Mark. Just remember it is worth every penny you paid for it.

Edited March 15, 2007 by XD Niner

[Skywalker]

Here's what I use to keep track of my reloads.

Caliber-specific.

Infinity_40_SW.zip

[A_Med]

You're very welcome Mark. Just remember it is worth every penny you paid for it.

Hey I'm willing to pay that price. Would you share it here.

Angel

[markwilliston]

XD Niner, come up to our Nationals in August and I'll buy you a beer. (after shooting is done of course)

http://www.pcdhfc.com/2007/

Skywalker, holy COW! No temperature/altitude/pressure compensasion? SHAME! Just kidding That is some serious spreadsheet.

A_Med, hopefully the file attached to this message. If not pm myself your XD Niner

Chronographdatasheet.zip

Edited March 15, 2007 by markwilliston

[A_Med]

XD Niner, come up to our Nationals in August and I'll buy you a beer. (after shooting is done of course)

http://www.pcdhfc.com/2007/

Skywalker, holy COW! No temperature/altitude/pressure compensasion? SHAME! Just kidding That is some serious spreadsheet.

A_Med, hopefully the file attached to this message. If not pm myself your XD Niner

Got it. Thanks.

[XD Niner]

Here is the file I use.

Chrono_Log.zip