00_Python_template_v3.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	S	T	U	W	X	Y	AA	AB	AC	AE	AF	AG	AI	AJ	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AX	AY	AZ	BA	BB	BC	BE	BF	BG	BH	BI	BJ	BK	BL	BM
1	USER INPUTS:		COPY AND PASTE IN RAW DATA																		INPUT VALUES FOR DIRECT N2O REF. INJECTION						corrected to m/z=44 peak area of 20 Vs			scale normalized 45R and 46R		PYTHON INPUTS								SCRAMBLING OUTPUT: CHECK VALUES			MATLAB/PYTHON OUTPUT		SIZE CORRECTED DELTA VALUES			peak area 20	N2O CONCENTRATIONS
2	run_date	ref_tag	Row	Identifier 1	Is Ref _	d 15N/14N	d 18O/16O	d 17O/16O	Area 44	Area 30	BGD 44	Rt	FileHeader: Filename	Time Code	rR 45N2O/44N2O sam	rR 46N2O/44N2O sam	rR 31NO/30NO sam	rR 45N2O/44N2O std	rR 46N2O/44N2O std	rR 31NO/30NO std	31R	45R	46R	raw 45rR/45rR	raw 46rR/46rR	raw 31rR/31rR	size corrected 31rR/31rR	size corrected 45rR/45rR	size corrected 46rR/46rR	scale decompressed 45rR/45rR	scale decompressed 46rR/46rR	size corrected 31R	size corrected 45R	size corrected 46R	D17O	gamma	kappa	DATE	SAMPLE ID	d15Nbulk	d17O	d18O	d15Na	d15Nb	SP	d15Nbulk	d17O	d18O	Pre_weight_g	Post_weight_g	volume analyzed (g)	matrix	volume analyzed (L)	N2O (nmols)	+/-	N2O (nmols/L)	+/-
3	201204	ATM	2	ATM_EQ_SW	0	5.406	46.78	3.478	4.769	4.95	2.1	1547.6	201204_V-0002.dxf	44169.76476	0.766037	0.741418	0.432084	0.762031	0.7364251	0.4284072	0.0037337628257	0.007741024950	0.0021012952216	1.0052570039802	1.00677991557	1.00858248881	1.0094442359432	1.0056851047434	1.0075218404243	1.0058729965988	1.0044845844523	0.0037690253628	0.0077864879628	0.0021107186575	0.00	0.1833	0.09049	201204	ATM_EQ_SW	6.18	24.28	47.59	15.11	-2.71	17.82	6.20	24.01	47.05	265	109	156	seawater	0.152	2.31	0.33	15.22	2.15
4	201205	S2	1	S2_ref_1	0	-3.689	33.856	-2.934	6.277	6.537	1.9	1546.3	201205_V-0000.dxf	2020/12/05 14:32:14	0.7590643	0.7322447	0.4294842	0.7618802	0.7364361	0.4293024				0.9963040121006	0.99430853539	1.00042347772	1.0011999044719	0.9966897272062	0.9949770033054	0.9976786855819	0.9935729162599	0.0037382429844	0.0077230555968	0.0020877900212	0.00	0.1833	0.09049	201205	S2_ref_1	-3.50	18.00	35.17	6.87	-13.88	20.76	-3.50	17.85	34.88	265	109	156	DI	0.156	3.01	0.33	19.27	2.13
5	201205	B6	2	B6_ref_1	0	0.364	44.33	2.266	21.185	22.028	2.0	1545.8	201205_V-0001.dxf	2020/12/05 15:07:56	0.7622279	0.7396701	0.4281049	0.7619105	0.736453	0.4293365	INPUT SIZE CORRECTION SLOPES			1.0004165843626	1.00436837110	0.99713138762	0.9970643420954	1.0003832773306	1.0043106479702	1.0010441118738	1.0016931138633	0.0037228017753	0.0077491074457	0.0021048529536	0.00	0.1833	0.09049	201205	B6_ref_1	0.36	22.70	44.45	-0.54	1.28	-1.82	0.37	22.46	43.99	265	109	156	DI	0.156	9.90	0.39	63.38	2.49
6	201205	ATM	3	ATM_EQ_SW_1	0	6.169	46.974	3.574	4.992	5.193	1.6	1546.9	201205_V-0002.dxf	2020/12/05 15:39:59	0.7665563	0.7416676	0.4329987	0.7619964	0.7365295	0.4293217	31R	45R	46R	1.0059841490065	1.00697609532	1.00856467306	1.0094138031925	1.0064059818641	1.0077071575147	1.0065293924218	1.0046456446432	0.0037689117341	0.0077915691393	0.0021110570925	0.00	0.1833	0.09049	201205	ATM_EQ_SW_1	6.98	24.37	47.76	14.85	-0.86	15.71	7.00	24.10	47.22	265	109	156	seawater	0.152	2.42	0.33	15.90	2.16
7	201205	S2	4	S2_ref_2	0	-2.894	35.592	-2.071	36.725	38.041	2.0	1546.2	201205_V-0003.dxf	2020/12/05 16:11:34	0.7597944	0.7334814	0.4297725	0.7620026	0.7364437	0.4289197	5.66E-05	2.81E-05	4.87E-05	0.9971021096253	0.99597756081	1.00198825095	1.0010419755352	0.9966320167053	0.9951628609726	0.9976260930525	0.9937347060209	0.0037376533152	0.0077226484767	0.0020881299893	0.00	0.1833	0.09049	201205	S2_ref_2	-3.57	18.09	35.36	6.66	-13.80	20.46	-3.57	17.94	35.06	265	109	156	DI	0.156	17.09	0.45	109.35	2.85
8	201205	B6	5	B6_ref_2	0	-0.866	42.325	1.272	21.034	21.866	3.5	1550.8	201205_V-0004.dxf	2020/12/05 18:31:18	0.761398	0.7382732	0.4269908	0.7620078	0.7364788	0.4285536				0.9991997457244	1.00243645846	0.99635331496	0.9962948127956	0.9991706828796	1.0023860907651	0.9999393635896	1.0000195591990	0.0037199285354	0.0077405555617	0.0021013363212	0.00	0.1833	0.09049	201205	B6_ref_2	-0.94	21.73	42.55	-1.16	-0.70	-0.45	-0.93	21.52	42.12	265	109	156	DI	0.156	9.84	0.39	62.93	2.48
9	201205	ATM	6	ATM_EQ_SW_2	0	4.841	44.903	2.549	4.982	5.192	2.3	1550.5	201205_V-0005.dxf	2020/12/05 19:02:52	0.7655403	0.7401441	0.4323824	0.7619803	0.7364764	0.4285005	SCALE NORMALIZATION FACTORS			1.0046720367968	1.00498006453	1.00905926598	1.0099089618882	1.0050941507264	1.0057116138413	1.0053348710262	1.0029111057558	0.0037707605392	0.0077823223193	0.0021074123142	0.00	0.1833	0.09049	201205	ATM_EQ_SW_2	5.57	23.37	45.78	16.04	-4.87	20.90	5.59	23.12	45.29	265	109	156	seawater	0.152	2.41	0.33	15.87	2.16
10	201205		7	DI	0	-9.761	44.925	2.56	17.01	17.718	2.7	1550.8	201205_V-0006.dxf	2020/12/05 19:34:26	0.7549911	0.7400237	0.4309752	0.7619683	0.7364943	0.4285044	coefficient	45R	46R	0.9908431886208	1.00479216200	1.00576610182	1.0059352715333	0.9909272291488	1.0049378093882	0.9924258769503	1.0022383914148	0.0037559237219	0.0076823934741	0.0021059987428	0.00	0.1833	0.09049	201205	DI	-10.10	23.08	45.21	14.46	-34.82	49.27	-10.18	22.85	44.76	265	109	156	DI	0.156	7.97	0.37	51.03	2.39
11	201207	ATM	1	ATM_EQ_SW_1	0	5.499	44.616	2.407	4.653	4.86	2.2	1550.3	201207_V-0000.dxf	2020/12/07 11:54:27	0.7657072	0.7397361	0.4334584	0.7616795	0.7362646	0.4291878	𝜆	0.9104107485	0.8717441712	1.0052879196565	1.00471501686	1.00995042264	1.0108187328750	1.0057192808549	1.0054625922472	1.0059041166638	1.0026946236853	0.0037741574083	0.0077867288640	0.0021069574214	0.00	0.1833	0.09049	201207	ATM_EQ_SW_1	6.28	23.24	45.52	17.15	-4.57	21.73	6.29	22.99	45.03	265	109	156	seawater	0.152	2.26	0.33	14.87	2.15
12	201207	S2	2	S2_ref_1	0	-3.908	32.678	-3.52	7.684	8.013	2.3	1549.8	201207_V-0001.dxf	2020/12/07 12:26:40	0.7586403	0.7312424	0.4294653	0.7616368	0.7362627	0.4292549	intercept	0.0006946942199	-0.002058024042	0.9960657100602	0.99318137399	1.00049015166	1.0011869724618	0.9964118783354	0.9937813048191	0.9974254748268	0.9925319637522	0.0037381946993	0.0077210954860	0.0020856026727	0.00	0.1833	0.09049	201207	S2_ref_1	-3.78	17.39	33.98	7.01	-14.58	21.59	-3.78	17.25	33.71	265	109	156	DI	0.156	3.66	0.34	23.44	2.17
13	201207	B6	3	B6_ref_1	0	0.138	44.011	2.108	20.544	21.38	2.4	1548.9	201207_V-0002.dxf	2020/12/07 13:08:33	0.7617839	0.738967	0.4279681	0.7616354	0.7359783	0.4290465				1.0001949751810	1.00406085342	0.99748651953	0.9974557408224	1.0001796848642	1.0040343543686	1.0008586349725	1.0014528800343	0.0037242631653	0.0077476716644	0.0021043481514	0.00	0.1833	0.09049	201207	B6_ref_1	0.14	22.56	44.18	0.08	0.22	-0.14	0.15	22.33	43.72	265	109	156	DI	0.156	9.61	0.39	61.48	2.47
14	201207	ATM	13	ATM_EQ_SW_2	0	4.622	44.532	2.365	4.851	5.042	2.2	1554.3	201207_V-0012.dxf	2020/12/07 19:56:02	0.7649379	0.7397445	0.4310904	0.7615454	0.7363411	0.4277457				1.0044547573920	1.00462204269	1.00781936557	1.0086764732682	1.0048805533648	1.0053599732054	1.0051403612671	1.0026054118203	0.0037661587190	0.0077808166144	0.0021067699610	0.00	0.1833	0.09049	201207	ATM_EQ_SW_2	5.34	23.19	45.43	14.39	-3.68	18.07	5.36	22.94	44.94	265	109	156	seawater	0.152	2.35	0.33	15.47	2.16
15	201207	ATM	23	ATM_EQ_SW_3	0	5.383	45.667	2.928	4.602	4.783	1.8	1551.9	201207_V-0022.dxf	2020/12/08 01:14:46	0.7655956	0.7404807	0.4321556	0.7616306	0.736271	0.428029				1.0052059357909	1.00571759583	1.00964093554	1.0105121312871	1.0056387304565	1.0064676555079	1.0058307689745	1.0035683137342	0.0037730126307	0.0077861610777	0.0021087933022	0.00	0.1833	0.09049	201207	ATM_EQ_SW_3	6.16	23.75	46.53	16.68	-4.33	21.01	6.17	23.49	46.02	265	109	156	seawater	0.152	2.24	0.33	14.72	2.15
16	201207	S2	24	S2_ref_2	0	-4.002	33.719	-3.002	8.283	8.603	2.0	1551	201207_V-0023.dxf	2020/12/08 01:46:13	0.758632	0.7319906	0.4283885	0.7616757	0.7362807	0.4281233				0.9960039423602	0.99417328201	1.00061944772	1.0012823779997	0.9963332744226	0.9947440346560	0.9973538399306	0.9933701107466	0.0037385509210	0.0077205409585	0.0020873638670	0.00	0.1833	0.09049	201207	S2_ref_2	-3.89	17.88	34.94	7.10	-14.89	22.00	-3.90	17.74	34.66	265	109	156	DI	0.156	3.94	0.34	25.21	2.18
17	201207		25	DI	0	-7.13	44.149	2.176	13.6	14.154	2.0	1551.2	201207_V-0024.dxf	2020/12/08 02:17:40	0.7566037	0.7392814	0.4306244	0.7616956	0.7362712	0.4282544				0.9933150460630	1.00408843915	1.00553409375	1.0058961961536	0.9934949321430	1.0044001927512	0.9947668052736	1.0017709701110	0.0037557778237	0.0077005146587	0.0021050165526	0.00	0.1833	0.09049	201207	DI	-7.27	22.79	44.64	13.73	-28.34	42.06	-7.31	22.57	44.19	265	109	156	DI	0.156	6.40	0.36	40.94	2.31
18
19
20
21
22
23
24
25
26
27
28
29
30
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