example_gres.xlsx

	A	B	C	D	E	F	G	H	I	K	L
1	Note: gmin_spreadsheet_tool was created by Lawren Sack, as a tool to be used with the Protocol "Minimum epidermal conductance (''gmin'', a.k.a. cuticular conductance)" for PrometheusWiki
2	Note: blue cells should be filled in
3
4	Leaf 1
5	hours	min	s	time	leaf_mass	RH	T	VPsat	mfVPD	gmin calculated from intervals
6				(min)	(g)	(%)	(oC)	kPa	(mol mol-1)	(mmol m-2 s-1)
7	1	33	36	0	0.1648	73	26.7	3.50	0.009339898447
8	1	59	18	25.7	0.1461	70	27	3.57	0.01056229863	59.94374088
9	2	35	7	61.51666667	0.1291	68	26.9	3.55	0.01120046779	36.87409721
10	3	1	49	88.21666667	0.1178	67	26.9	3.55	0.01155048241	31.88312344
11	3	27	26	113.8333333	0.1075	66	26.9	3.55	0.01190049702	29.39972776
12	3	53	40	140.0666667	0.097	66	26.9	3.55	0.01190049702	29.26607779
13	4	18	45	165.15	0.0885	64	27	3.57	0.01267475836	23.26418213
14	4	47	22	193.7666667	0.0813	62	27.3	3.63	0.01361639853	16.07848033
15	5	15	26	221.8333333	0.0739	64	27.5	3.67	0.01305166362	17.57797376
16	5	43	2	249.4333333	0.0678	61	27.2	3.61	0.01389306379	13.8425635
17	6	9	36	276	0.0624	59	27.5	3.67	0.01486439468	11.89880278
18	6	33	45	300.15	0.0589	59	27.5	3.67	0.01486439468	8.483937927
19	7	1	17	327.6833333	0.0555	59	27.7	3.72	0.01503918431	7.144792888
20	7	27	45	354.15	0.0531	57	27.4	3.65	0.01549852716	5.091143832
21	8	0	5	386.4833333	0.0506	60	27.6	3.69	0.01458689464	4.612331189
22	8	27	46	414.1666667	0.049	59	27.6	3.69	0.01495156701	3.363633664
23	8	47	33	433.95	0.049	58	27.6	3.69	0.01531623937	0
24	9	5	43	452.1166667	0.0472	60	27.9	3.76	0.01484464531	5.807928131
25	9	26	20	472.7333333	0.0465	61	27.9	3.76	0.01447352918	2.041262942
26
27
28
29
30	Atmospheric pressure (kPa)		101.3		mean	64.5	27.025	3.57	0.01252303773	2.041262942
31					max/min	4	0.4	0.08	0.001715901511	2.8682997	calculated from slope
32	Initial leaf area (cm2)		6.59
33	Final leaf area (cm2)		4.051		Graph shows leaf mass plotted against time; only the linear portion should be used for gmin calculation
34	Mean leaf area (cm2)		5
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