Chesterton ergs

	A	B	C	D	E	G	H	I	J	K	M	N	O	P	Q	R	S
1				Adjustment is done on a 2/9 power law: the adjustment factor at a given weight is (w_ref/w)^2/9. To take account of deadweight, the adjustment is done with W=w+d, where d is the (constant) deadweight. This is done to both the rower and the reference weight.
2										Over 7750
3				Adjusted weight, including deadweight	"Pure" adjusted weight					Over 8000						Under 7
4	Boat weigth			85		Current ergs, 30 min	Raw score	Weight	Adjustment factor	Adjusted, using the deadweight	Current ergs, 2k	Raw time (m+s/60)			Adjusted time, using deadweight, m+s/60	Adj, m	Adj, s
5	100		60	1.062292931	1.080475787	TW	8350	81	1.009	8,422.381	Andy S 02/07	7.545	90	0.990	7.623	7	37.40
6	Cox weight		61	1.059364452	1.076514287	WMC (PB, 2011)	7938	72	1.030	8,174.609	Steven A	6.648	95	0.980	6.784	6	47.05
7	60		62	1.056479831	1.072631377	WMC	7838	73	1.027	8,052.260	James H	6.832	82	1.006	6.788	6	47.27
8	Total		63	1.053637888	1.068824267	WD	7500	92	0.986	7,393.203	WMC (last year)	7.183	72	1.030	6.975	6	58.52
9	160		64	1.05083749	1.06509031	JH	8144	83	1.004	8,178.879	Chris F	7.112	95	0.980	7.257	7	15.41
10	Each share		65	1.048077545	1.061426989	SE	7324	65	1.048	7,676.120	Andy S 02/13	7.695	90	0.990	7.775	7	46.50
11	20		66	1.045357003	1.057831912	CW	7629	80	1.011	7,712.166	Simon E, 02/28	7.647	65	1.048	7.296	7	17.75
12			67	1.042674852	1.054302802	DB 02/08	6884	78	1.015	6,990.357	Will W	7.130	79	1.013	7.037	7	2.24
13			68	1.04003012	1.05083749	WMC 02/09	7600	72	1.030	7,826.534	Simon E	7.525	64	1.051	7.161	7	9.66
14			69	1.037421868	1.04743391	Dave R 02/09	7468	68	1.040	7,766.945	Paul H	7.427	72	1.030	7.212	7	12.70
15			70	1.034849191	1.044090092	SA 02/10	8330	92	0.986	8,211.385	Luca	7.657	75	1.022	7.488	7	29.30
16			71	1.032311216	1.040804155	WMC 02/11	7792	72	1.030	8,024.257	Harish	8.663	80	1.011	8.570	8	34.19
17			72	1.029807102	1.037574301	SE 02/10	7093	65	1.048	7,434.014	Chris F 04/27	6.800	95	0.980	6.939	6	56.33
18			73	1.027336036	1.034398816	WD 02/10	7534	94	0.982	7,397.566	WMC 3/x	7.213	72	1.030	7.005	7	0.27
19			74	1.024897234	1.031276056	WW 02/11	7650	80	1.011	7,733.395	Dave R 04/27	7.350	68	1.040	7.067	7	4.03
20			75	1.022489938	1.028204453	Lorraine	6701	64	1.051	7,041.662	Rasmus	8.040	68	1.040	7.731	7	43.83
21			76	1.020113416	1.025182503	Gary D 02/11	7030	80	1.011	7,106.636	Simon Green	7.667	95	0.980	7.823	7	49.39
22			77	1.017766959	1.022208764	DR 02/11	7568	68	1.040	7,870.948	Anne R	8.152	65	1.048	7.778	7	46.66
23			78	1.015449883	1.019281857	Dave B 02/11	6909	77	1.018	7,031.752
24			79	1.013161527	1.016400458	Gary D 02/14	7250	83	1.004	7,281.050
25			80	1.010901249	1.013563296	Paul H	7531	74	1.025	7,718.501	Giulio	18.633	79	1.013	18.391	18	23.48
26			81	1.008668429	1.010769153	Steven 02/15	8260	92	0.986	8,142.381
27			82	1.006462467	1.008016855	Dave B 02/13	6991	78	1.015	7,099.010
28			83	1.004282781	1.005305279	Chris W 02/16	7711	80	1.011	7,795.060
29			84	1.002128807	1.002633341	Dave B, 02/20	7010	78	1.015	7,118.304
30			85	1	1	Simon E, 02/20	7177	65	1.048	7,522.053
31			86	0.9978958293	0.9974042548	Dave B, 02/21	7021	78	1.015	7,129.474
32			87	0.9958157818	0.9948451405	Lorraine, 02/18	6782	64	1.051	7,126.780
33			88	0.9937593593	0.9923217279	Simon E, 02/28	7402	65	1.048	7,757.870
34			89	0.9917260784	0.9898331216	Anne R	7088	70	1.035	7,335.011
35			90	0.98971547	0.9873784585	Dave B, 02/27	6793	78	1.015	6,897.951
36			91	0.9877270784	0.9849569061	Dave B, 02/29	7010	79	1.013	7,102.262
37			92	0.9857604615	0.9825676612	Dave B, 03/02	7064	78	1.015	7,173.138
38			93	0.9838151894	0.9802099486	Dave B, 03/21	7041	78	1.015	7,149.783
39			94	0.9818908447	0.9778830196	Simon E 04.x	7489	64	1.051	7,869.722
40			95	0.9799870216	0.9755861513	Steven A	8358	93	0.984	8,222.727
41			96	0.9781033256	0.9733186449	Dave B	7099	78	1.015	7,208.679
42			97	0.9762393732	0.9710798251	Anne R	7076	65.000	1.048	7,416.197
43			98	0.9743947913	0.9688690388	Chris F	8300	95.000	0.980	8,133.892
44			99	0.972569217	0.9666856541	William C 05/18	7862	72	1.030	8,096.343
45			100	0.9707622971	0.9645290598	Andy S	7606	90	0.990	7,527.776
46			101	0.968973688	0.9623986642	Chris W 06/04	7908	80	1.011	7,994.207
47			102	0.9672030551	0.9602938943
48			103	0.9654500725	0.958214195	Target distance calculator!
49			104	0.9637144229	0.9561590287	Your target distance (adjusted)	8222.727353			Note: the default value for this cell is the maximum of the 30mins, exlcuding TW's of course.
50			105	0.9619957972	0.9541278743	Your weight	83
51			106	0.9602938943	0.9521202264	Your adjustment factor then comes to...	1.004
52			107	0.9586084206	0.9501355951	The raw distance you need to do is...	8187.661392
53			108	0.95693909	0.9481735051
54			109	0.9552856236	0.9462334951
55			110	0.9536477494	0.9443151175
56
57
58
59
60
61
62
63				Stone and lb to Kg conversion
64		9	0	57.15
65			1	57.60357143
66			2	58.05714286
67			3	58.51071429
68			4	58.96428571
69			5	59.41785714
70			6	59.87142857
71			7	60.325
72			8	60.77857143
73			9	61.23214286
74			10	61.68571429
75			11	62.13928571
76			12	62.59285714
77			13	63.04642857
78		10	0	63.5
79			1	63.95357143
80			2	64.40714286
81			3	64.86071429
82			4	65.31428571
83			5	65.76785714
84			6	66.22142857
85			7	66.675
86			8	67.12857143
87			9	67.58214286
88			10	68.03571429
89			11	68.48928571
90			12	68.94285714
91			13	69.39642857
92		11	0	69.85
93
94
95
96
97
98
99
100