Spreadsheet: 85934d1285932387-offset-vs-match-in-array-formulas-regressiontab
Sheet: Regression

Elapsed Time | ln(Time) | Unity | SQRT (Time) | [NAME] (%) | Combined Extrapolation | Logarithmic Extrapolation | Fickian Extrapolation |  |  | 3 | 278 |  | offset (hours) | [NAME] by Combined Method | [NAME] (%) by [NAME] | [NAME] by [NAME] | [NAME] (%) by [NAME] | [NAME] by [NAME] | [NAME] (%) by Fickian method | Best Fiit Extrapoltion | [NAME] | Instantaneous Buoyancy Loss @ EOL (%)
 |  |  |  |  |  |  |  |  |  | Offset | Duration |  | 1 | 1000 | -75.86329714671702 | #[NAME]! | #[NAME]! | 0.3505635412214644 | 9.149558123845532
1 |  |  |  |  |  |  |  |  |  | 1289.434484061609 | 15373.54201906856 | y = A*ln(t) + B + C*sqrt(t) | 2 | 1000 | -89.07240335039033 | #[NAME]! | #[NAME]! | 0.3468994734454022 | 8.256723676777698
2 |  |  |  |  |  |  |  |  | 1289.434484061609 | 276 | 3095.433985756286 |  | 3 | 1000 | -98.38273860793984 | #[NAME]! | #[NAME]! | 0.3426659594783404 | 7.32736588404184
3 |  |  |  |  |  |  |  |  | 15373.54201906856 | 3095.433985756286 | 38768.72416999989 |  | 4 | 1000 | 23.69496003678474 | 0.03650437896822849 | 3.57844982788546 | 0.02152215135159152 | 20.19595650985558
3.999999999999999 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1000 | 25.50305846986741 | 0.03629373927441317 | 3.592674705066983 | 0.02125314379847349 | 20.07524661816517
4.999999999999999 |  |  |  |  |  |  |  |  | EOL (hrs) = |  |  |  | 6 | 1000 | 27.19625219135445 | 0.03606324106894272 | 3.607180696096728 | 0.02117595729095662 | 19.99441245516778
5.999999999999999 |  |  |  |  |  |  |  |  |  |  | ln(t) |  | 7 | 1000 | 28.20602197200866 | 0.03546213922316065 | 3.62763908587066 | 0.021252110775244 | 20.00623600616471
6.999999999999999 |  |  |  |  |  |  |  |  | -1.759378937233862 | 1 | constant |  | 8 | 1000 | 29.39570581386898 | 0.03503649922123007 | 3.645421665703521 | 0.02133245267627848 | 20.00677057726088
7.999999999999999 |  |  |  |  |  |  |  |  | -0.266917236787533 |  | sqrt(t) |  | 9 | 1000 | 30.1164621081095 | 0.03435089007051437 | 3.666882306457305 | 0.02133895577180163 | 20.06405968349454
9 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 1000 | 30.51656417324588 | 0.03350445942696195 | 3.690247443573162 | 0.02123774299024109 | 20.15442808999635
10 |  |  |  |  |  |  |  |  | EOL Value = |  | % |  | 11 | 1000 | 30.61594054871934 | 0.03251397860787408 | 3.715124897789098 | 0.02101943555070375 | 20.27086068694943
11 |  |  |  |  |  |  |  |  | Standard Deviation = |  |  |  | 12 | 1000 | 30.69429320851561 | 0.03160705731053165 | 3.738910706778057 | 0.02082912428954016 | 20.3822808940013
11.98333 |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 1000 | 30.69821062058024 | 0.03073319774112018 | 3.762204733646222 | 0.02063852300364346 | 20.49441312743722
12.98333 |  |  |  |  |  |  |  |  |  | 6243.957627397752 |  | y = A*ln(t) + B | 14 | 1000 | 30.85184841274988 | 0.03004283769019282 | 3.783190225216511 | 0.0205409644800882 | 20.58606369209954
13.98333 |  |  |  |  |  |  |  |  | 6243.957627397752 | 6243.957627397752 |  |  | 15 | 1000 | 30.95507504204477 | 0.02938147564580375 | 3.803790699432366 | 0.02044405956225247 | 20.67843952439303
14.98333 |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 1000 | 31.37436203676789 | 0.02895281072312957 | 3.821083182346835 | 0.02045282656567574 | 20.7382792593279
15.98333 |  |  |  |  |  |  |  |  | EOL (hrs) = |  |  |  | 17 | 1000 | 32.24045373350877 | 0.0287496397795511 | 3.834423990602297 | 0.02052758325261829 | 20.75854689926994
16.98333 |  |  |  |  |  |  |  |  |  |  | ln(t) |  | 18 | 1000 | 33.3143007133645 | 0.02862413429687055 | 3.846163158491256 | 0.02061052340396765 | 20.76578071968216
17.98333 |  |  |  |  |  |  |  |  | #[NAME]! | 1 | constant |  | 19 | 1000 | 34.27384457768247 | 0.02845833524699925 | 3.858990598312559 | 0.02068461121589003 | 20.78980212067784
18.98333 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 1000 | 35.88133788231384 | 0.02846766388513067 | 3.867040915002643 | 0.02075903365559921 | 20.76468312591467
19.98333 |  |  |  |  |  |  |  |  | EOL Value = |  | % |  | 21 | 1000 | 37.44115985002772 | 0.02845350934466983 | 3.876078474166127 | 0.02084443887953992 | 20.75510576968009
20.97933 |  |  |  |  |  |  |  |  | Standard Deviation = |  |  |  | 22 | 1000 | 39.14721986888231 | 0.0284578828665529 | 3.884622686442516 | 0.02093047736186156 | 20.74408956387865
21.97833 |  |  |  |  |  |  |  |  |  |  |  |  | 23 | 1000 | 41.17646581100117 | 0.02850627227172807 | 3.891504992318961 | 0.02100872724042318 | 20.71847856504839
22.97833 |  |  |  |  |  |  |  |  |  | 3095.433985756286 |  | y = A + B*sqrt(t) | 24 | 1000 | 43.24575149092776 | 0.02854539920796237 | 3.898983273173519 | 0.02109535077469291 | 20.70332444332044
23.97833 |  |  |  |  |  |  |  |  | 3095.433985756286 | 38768.72416999989 |  |  | 25 | 1000 | 45.24987541309949 | 0.02855683833110703 | 3.907797325456689 | 0.02118671655978027 | 20.70645542445378
24.97833 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | 1000 | 46.81712115113331 | 0.0284575749705648 | 3.920429534582722 | 0.02124366754422767 | 20.75482242514
25.97833 |  |  |  |  |  |  |  |  | EOL (hrs) = |  |  |  | 27 | 1000 | 48.03424765604391 | 0.02825406009289266 | 3.935932428782255 | 0.02123684546775545 | 20.83712206758765
26.97833 |  |  |  |  |  |  |  |  |  | 1 | constant |  | 28 | 1000 | 48.99917910811651 | 0.0279724521411387 | 3.953378868767418 | 0.02117076452172109 | 20.94250430341976
27.97822 |  |  |  |  |  |  |  |  | 0.01527125039353061 |  | sqrt(t) |  | 29 | 1000 | 50.13761938588553 | 0.02774605353344943 | 3.969781829582791 | 0.02113819095394046 | 21.03769131438688
28.97822 |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 1000 | 50.31555098220176 | 0.02720153267929609 | 3.992619983984064 | 0.02084846315623471 | 21.20482853288531
29.97822 |  |  |  |  |  |  |  |  | EOL Value = |  | % |  | 31 | 1000 | 50.29362622376082 | 0.02660995661322405 | 4.016359343244755 | 0.02051600266394753 | 21.38213115885193
30.97822 |  |  |  |  |  |  |  |  | Standard Deviation = |  |  |  | 32 | 1000 | 50.37799019926767 | 0.02609160508548502 | 4.038957130243449 | 0.02024595816482907 | 21.54704329564188
31.97822 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 1000 | 50.24931674405498 | 0.02552639742130731 | 4.062486672139039 | 0.01993436876940272 | 21.72233730294628
32.97822 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | 1000 | 50.09085330919082 | 0.02498529737114741 | 4.085706592514798 | 0.01964330044623019 | 21.89427660880314
33.97822 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 1000 | 49.22524944875334 | 0.02421747767393025 | 4.112690157334928 | 0.01915229150980701 | 22.10721446991294
34.97822 |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 1000 | 48.41190563511763 | 0.02352523758642782 | 4.138504125014709 | 0.01873367523012037 | 22.30690833548308
35.97822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Logarithmic Extrapolation Offset hours |  | Show Offset on Chart
36.97822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min Dev. =
37.97822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offset =
38.97822 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Loss in Buoyancy =
39.97822
40.97822
41.97822 |  |  |  |  |  |  |  |  | The standard deviation, |  | for the model is determined from
42.97822
43.97822
44.97822
45.97822
46.97822
47.97822
48.97822
49.97822
50.97822
51.97822
52.97822
53.97822
54.97822
55.97822
56.97822
57.97822
58.97822
59.97822
60.97822
61.97822
62.97822
63.97822
64.97822
65.97822
66.97822
67.97822
68.97822
69.97822
70.97822
71.97822
72.97822
73.97822
74.97822
75.97822
76.97822
77.97822
78.97822
79.97822
80.97822
81.97822
82.97822
83.97822
84.97822
85.97822
86.97822
87.97822
88.97822
89.97822
90.97822
91.97822
92.97822
93.97822
94.97822
95.97822
96.97822
97.97822
98.97822
99.97822
100.97822
101.97822
102.97822
103.97822
104.97822
105.97822
106.97822
107.97822
108.97822
109.97822
110.97822
111.97822
112.97822
113.97822
114.97822
115.97822
116.97822
117.97633
118.97567
119.97567
120.97567
121.97567
122.97567
123.959
124.959
125.959
126.959
127.959
128.959
129.959
130.959
131.959
132.959
133.959
134.959
135.959
136.959
137.959
138.959
139.959
140.959
141.959
142.959
143.959
144.959
145.959
146.959
147.959
148.959
149.959
150.959
151.959
152.959
153.959
154.959
155.959
156.959
157.959
158.959
159.959
160.959
161.959
162.959
163.959
164.959
165.959
166.959
167.959
168.959
169.959
170.959
171.959
172.959
173.959
174.959
175.959
176.959
177.959
178.959
179.959
180.959
181.959
182.959
183.959
184.959
185.959
186.959
187.959
188.959
189.959
190.959
191.959
192.959
193.959
194.959
195.959
196.959
197.959
198.959
199.959
200.959
201.959
202.959
203.959
204.959
205.959
206.959
207.959
208.959
209.959
210.959
211.959
212.959
213.959
214.959
215.959
216.959
217.959
218.959
219.959
220.959
221.959
222.959
223.959
224.959
225.959
226.959
227.959
228.959
229.959
230.959
231.959
232.959
233.959
234.959
235.959
236.959
237.959
238.959
239.959
240.959
241.959
242.959
243.959
244.959
245.959
246.959
247.959
248.959
249.959
250.959
251.94235
252.94122
253.93988
254.93979
255.93979
256.93979
257.93979
258.93979
259.93979
260.93979
261.93979
262.93979
263.93979
264.93979
265.93979
266.93979
267.93979
268.93979
269.93979
270.93979
271.93979
272.93979
273.93979
274.93979
275.93979
276.93979
277.93979
278.93979