100142_OG1.7_SpotAvg_LinReg.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ
1	(0) Short identifer for analysis
2	Copy-Paste 100142, spot OG1.7.1.1, WITH SBM
3
4	(1) TotalCountsAtMass data from condensed PD/XML (starting column C and row containing spot-name; ending column "sbm zero" and row containing scan 6)
5						OG1.7.1.1, 2010-11-12 00:22:46					10 peaks, 6 scans
6		tot cts					tot cts					tot cts					tot cts					tot cts					tot cts					tot cts					tot cts					tot cts					tot cts
7	2	mass		tot cts	trim	20	mass		tot cts	trim	20	mass		tot cts	trim	15	mass		tot cts	trim	30	mass		tot cts	trim	5	mass		tot cts	trim	5	mass		tot cts	trim	2	mass		tot cts	trim	2	mass		tot cts	trim	2	mass		tot cts	trim	Dead time
8	Secs	195.766	±1sig	SBM	mass	Secs	203.952	±1sig	SBM	mass	Secs	203.992	±1sig	SBM	mass	Secs	205.958	±1sig	SBM	mass	Secs	206.962	±1sig	SBM	mass	Secs	207.965	±1sig	SBM	mass	Secs	238.031	±1sig	SBM	mass	Secs	248.033	±1sig	SBM	mass	Secs	254.064	±1sig	SBM	mass	Secs	270.097	±1sig	SBM	mass	ns	sbm zero
9	17	23503.2	153	484674	195.769	33	3.0000	1.73	4840935	203.955	57	2.0000	1.41	4827535	203.995	79	61012.0	247	3615665	205.960	105	36784.7	217	7217408	206.964	126	4965.9	70.5	1201716	207.967	139	11947.8	109	1201838	238.035	152	25735.2	160	480606	248.034	162	30396.9	191	480439	254.067	174	11996.7	110	480470	270.100	12	9588
10	193	25851.4	181	478875	195.766	209	1.0000	1.00	4788506	203.952	233	0.0000	0.00	4784084	203.992	255	60720.8	246	3586700	205.957	281	35836.6	245	7167989	206.961	302	4937.9	70.3	1193843	207.964	315	12177.9	110	1195251	238.030	328	25727.7	171	478235	248.033	338	30948.3	176	478277	254.065	349	11853.8	109	478575	270.096
11	369	26912.1	190	476660	195.767	385	2.0000	1.41	4767954	203.953	409	0.0000	0.00	4763796	203.993	431	59856.6	245	3572969	205.958	457	36350.0	191	7141998	206.962	478	4847.0	69.6	1190032	207.964	491	12719.4	113	1191199	238.031	503	26141.6	162	476916	248.031	514	30800.4	175	476879	254.063	525	12138.9	110	476841	270.096
12	545	28186.9	168	474511	195.765	561	3.0000	1.73	4747471	203.950	584	3.0000	1.73	4744885	203.990	607	59380.6	244	3556355	205.956	632	35755.8	274	7105860	206.960	653	4876.4	69.8	1183728	207.962	667	12572.8	112	1184410	238.029	679	26683.0	197	473969	248.031	690	31705.4	178	473939	254.062	701	12152.0	118	474415	270.092
13	721	28768.3	170	471786	195.763	737	2.0000	1.41	4717253	203.949	760	1.0000	1.00	4711226	203.989	782	59127.2	292	3532734	205.954	808	35463.3	196	7060312	206.959	829	4851.8	69.7	1176574	207.961	843	12800.8	113	1177416	238.030	855	26902.5	194	471230	248.028	866	31208.0	177	471233	254.061	877	12322.7	111	471604	270.093
14	897	29778.5	181	468788	195.764	912	1.0000	1.00	4688615	203.950	936	0.0000	0.00	4684272	203.990	958	59388.0	291	3512998	205.955	984	35305.8	220	7022613	206.959	1005	4898.5	70.0	1169543	207.962	1019	12894.1	114	1171367	238.029	1031	26870.8	164	469138	248.030	1042	31603.8	178	469333	254.061	1053	12385.4	111	469974	270.093
15
16	(2) Within-Spot Ratio data from SQUID-book (starting column A and row containing spot-name; ending column "206/254 err" and row containing interpolation 5)
17	OG1.7.1.1	Time	204/206	err	Time	207/206	err	Time	208/206	err	Time	238/196	err	Time	206/238	err	Time	254/238	err	Time	248/254	err	Time	206/270	err	Time	270/254	err	Time	206/254	err
18	11/12/10 0:22	495.5	0.00001251805837	0.000005110518574	180	0.299016936	0.001423914848	190.5	0.2444582219	0.00264865422	166	0.1877724625	0.001813558132	197	1.687353999	0.01263982724	238.5	6.338025024	0.04921826715	245	0.8394314941	0.005177553995	214.25	0.6788206513	0.005517991402	255.75	0.3884405995	0.003024855035	208.5	0.2657632755	0.001492421002
19	Spot# 36				356	0.2993704029	0.001430918612	366.5	0.2445580808	0.002666115823	342	0.183001356	0.001737175356	373	1.624360761	0.01202713572	414.5	6.177997468	0.0474089233	420.75	0.8404327483	0.005166828347	390	0.6737375307	0.005476783993	431.5	0.3881382213	0.003013754641	384.5	0.259766747	0.001457562765
20					531.75	0.3029093971	0.001451276578	542.25	0.2446467077	0.002675878912	518	0.1809457747	0.00168985923	549	1.568563256	0.01153997321	590.5	6.162973732	0.04696065332	596.5	0.8466895602	0.005168133025	566	0.6555468527	0.005300869888	607.5	0.3879031073	0.00299452099	560.5	0.2563507667	0.001436057576
21					707.25	0.300712046	0.001447973489	717.75	0.2464271866	0.002694990865	694	0.1754049861	0.001633278754	724.75	1.563156545	0.01149636662	766.5	6.189706589	0.04707524791	772.5	0.8518559037	0.005174489196	741.75	0.6501428681	0.005246790119	783.5	0.3885495832	0.002989180959	736.25	0.2507203723	0.001402218868
22					883	0.2984903941	0.001440145265	893.5	0.2462133201	0.002690184842	870	0.1725157409	0.001591330021	900.5	1.543726113	0.01129496003	942.5	6.092556902	0.04614775425	948.5	0.856819275	0.005202598763	917.5	0.6443538219	0.0051795852	959.5	0.3926087748	0.00301165804	912	0.2535237988	0.001419636265
23
24	(3) SPOT AVERAGE data from StandardData/SampleData sheet (single row, starting column A; ending column "206/254 %err")
25	Spot Name	Date/Time	Hours	stage X	stage Y	stage Z	Qt1y	Qt1z	Primary beam (na)	Bkrd cts /sec	total 196 cts /sec	total 204 cts /sec	total 206 cts /sec	total 207 cts /sec	total 208 cts /sec	total 238 cts /sec	total 248 cts /sec	total 254 cts /sec	total 270 cts /sec	204/206	%err	207/206	%err	208/206	%err	238/196	%err	206/238	%err	254/238	%err	248/254	%err	206/270	%err	270/254	%err	206/254	%err
26	OG1.7.1.1	2010-11-12, 00:22:46	13.30	17623	11165	22730	116	305	1.7	0.05	13583	0.10	3994	1197.2	979	2504	13172	15555	6071	1.3E-5	41	0.3001	0.3	0.245	0.6	0.180	1.6	1.5953	1.9	6.193	0.95	0.85	0.35	0.66000	1.09	0.3896	0.45	0.25745	1.1
27
28	(4) LINEAR REGRESSION TO SPOT MIDTIME data from StandardData/SampleData sheet (single row, starting column A; ending column "206/254 %err")
29	Spot Name	Date/Time	Hours	stage X	stage Y	stage Z	Qt1y	Qt1z	Primary beam (na)	Bkrd cts /sec	total 196 cts /sec	total 204 cts /sec	total 206 cts /sec	total 207 cts /sec	total 208 cts /sec	total 238 cts /sec	total 248 cts /sec	total 254 cts /sec	total 270 cts /sec	204/206	%err	207/206	%err	208/206	%err	238/196	%err	206/238	%err	254/238	%err	248/254	%err	206/270	%err	270/254	%err	206/254	%err
30	OG1.7.1.1	12 Nov, 2010 00:22	13.30	17623	11165	22730	116	305	1.7	0.05	13583	0.10	3994	1197.2	979	2504	13172	15555	6071	1.3E-5	41	0.3004	1.0	0.244	1.3	0.191	1.0	1.7078	1.7	6.397	1.00	0.83	0.83	0.68930	1.0	0.3860	1.1	0.25639	0.4
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100