Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves

A log display for one vertical well. Paste SP, gamma-ray and shallow, medium and deep resistivity onto the Log Data sheet — any sampling interval, depth increasing downward — and the Well Log sheet draws them as tracks against depth: SP as bars either side of a shale baseline, GR as bars coloured by a five-band palette, a lithology column from the same palette, resistivity on a logarithmic scale with decade lines, and a computed shale-volume track from the gamma-ray index. The tracks are charts over a grid of cells that supplies the depth lines and labels, and the sheet prints on one page. No add-in is needed.

Well-Log Display Excel workbook

LogDisplay.xlsx

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves: Guide sheet

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves: Inputs sheet

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves: Log Data sheet

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves: Well Log sheet

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves: Calc sheet

Description Preview Requirements

A window sets what the 120 track rows show: a top depth (0 means the top of the data) and the feet each row covers. Each row reads the curves at its middle depth by linear interpolation, so the sampling of the log and the scale of the display are independent. A sample that is blank, text or an error, equals the null value (LAS files use −999.25) or, for resistivity, is not above zero, is a gap in that curve.

A chart's axis limits are numbers inside the chart, not cells, so a chart cannot follow a scale typed in a cell. Here every track plots a share of its width — (GR − left edge) / (right edge − left edge), and for resistivity the same in log space — computed on the Calc sheet from the scale cells, and the chart axis is fixed at 0 to 1. Change a scale, the shale baseline, a palette edge or the window and the curves, the decade lines and the scale printed under each track title all move.

Input checks flag a set of inputs that cannot draw a log — depths that run upward or repeat, text among the depths, a window that misses the data, a scale whose left edge is above its right, more than six decades of resistivity — in red with the fix spelled out.

Inputs

Named cells you can edit — the curves, grid lines and headers recalculate from them. The curves themselves are pasted on the Log Data sheet.

Name	Description	Default	Unit
`LD_WellName`	Well name shown in the title	Example well A-12	—
`LD_WinTop`	Window top (0 = top of the data)	0	ft
`LD_Step`	Depth per row; the log is 120 rows tall	1	ft
`LD_Null`	Null value: a sample equal to it is a gap	−999.25	—
`LD_SPBase`	SP shale baseline	−15	mV
`LD_SPMin`, `LD_SPMax`	SP scale, left and right edge	−100, 0	mV
`LD_GRMin`, `LD_GRMax`	GR scale, left and right edge	0, 150	API
`LD_RMin`, `LD_RMax`	Resistivity scale, left and right edge (log, at most six decades)	0.2, 2000	ohm·m
`LD_GRB1`–`LD_GRB4`	GR palette edges: clean sand, sand, shaly sand, sandy shale, shale	45, 65, 85, 105	API
`LD_GRClean`, `LD_GRShale`	GR in clean sand (Vsh = 0) and in shale (Vsh = 1)	30, 115	API

5 sheets, shown with the values the file opens with

	A
1	Well-log display — paste the curves, get printable tracks
2
3	What this is
4	A log display for one vertical well. Paste SP, gamma-ray and shallow, medium and deep resistivity onto the Log Data sheet and the Well Log sheet draws them as tracks against depth: SP, GR, a lithology column from the GR palette, resistivity on a log scale and a computed shale-volume track. No add-in is needed — every formula is plain Excel, the curves are charts, and the depth lines, labels and lithology are cells behind them — and the sheet prints on one page.
5
6	Using it
7	Log Data — depth in the first column, increasing downward, then SP, GR, RS, RM and RD. Paste over the example from A5; any sampling interval works, up to 5,000 rows. A curve you do not have can stay empty.
8	Inputs — the window (which depth to start at, and how many feet each row covers) and the scale of each track. Blue cells on a yellow background are the ones to change.
9	Well Log — the display. The scale under each track title is the one on Inputs; the legend on the right names every colour.
10	Checks — at the bottom of Inputs. Depths that run upward, a scale whose left edge is above its right, a window that misses the data and similar are flagged in red with the fix spelled out, and the Well Log says so on its third line.
11
12	The window
13	The log is always 120 rows tall. The window top (0 means the top of the data) and the depth per row set what it shows: at 1 ft a row it covers 120 ft, at 2.5 ft a row 300 ft. Each row reads the curves at its middle depth, by linear interpolation between the two samples either side, so the sampling of the log and the scale of the display are independent.
14
15	Why the scales follow the inputs
16	A chart's axis limits are numbers inside the chart, not cells, so a chart cannot follow a scale typed in a cell. Here every track plots a share of its width, from 0 at the left edge to 1 at the right, computed on the Calc sheet from the scale cells — (GR − left) / (right − left), and for resistivity the same in log space — and the chart axis is fixed at 0 to 1. Change a scale and the curves move. The decade lines of the resistivity track are series too, placed from the same two cells. A reading off the scale runs along the edge of its track.
17
18	Gaps
19	A sample that is blank, text or an error, equals the null value on Inputs (LAS files use −999.25), or — for resistivity — is not above zero is a gap: the curve stops there and starts again at the next good sample, and a row between a good sample and a gap is a gap too.
20
21	What it does not do
22	It does not read a LAS file — paste the curves — and it draws one well, with no image logs. The curves are fixed at SP, GR and three resistivities. Shale volume is the linear gamma-ray index; porosity, saturation and the nonlinear shale corrections belong to petrophysics functions this workbook does not carry. Vertical wells only: depths are measured depth.

	A	B	C	F
1	Inputs
2	Blue cells on a yellow background drive the display. Field units, vertical well. The curves themselves are pasted on the Log Data sheet; here are the window that says which part of them to show, and the scale of each track. Change a scale and the curves, their grid lines and the headers under each track title follow. The checks at the bottom flag a set of inputs that cannot draw a log.
3
4	Well and depth window
5	Well name	Example well A-12
6	Window top (0 = top of the data)	0	ft	The log is 120 rows tall. Depth per row sets how much it shows: 1 ft a row is 120 ft, 5 ft a row is 600 ft.
7	Depth per row	1.0	ft
8	Null value (a sample equal to it is a gap)	-999.25
9
10	Track scales
11	SP shale baseline	-15	mV	SP bars grow left (sand) or right (shale) from the baseline.
12	SP scale, left edge	-100	mV
13	SP scale, right edge	0	mV
14	GR scale, left edge	0	API
15	GR scale, right edge	150	API
16	Resistivity scale, left edge	0.2	ohm·m	Logarithmic, at most six decades apart; the decade lines follow the two edges.
17	Resistivity scale, right edge	2,000	ohm·m
18
19	GR palette and shale volume
20	Palette edge: clean sand \| sand	45	API	The palette colours the GR track and the lithology column.
21	Palette edge: sand \| shaly sand	65	API
22	Palette edge: shaly sand \| sandy shale	85	API
23	Palette edge: sandy shale \| shale	105	API
24	GR in clean sand (Vsh = 0)	30	API	Linear gamma-ray index: Vsh = (GR − clean) / (shale − clean), kept between 0 and 1.
25	GR in shale (Vsh = 1)	115	API
26
27	Input checks
28	Checks failing	0
29	Check	Status	What to fix
30	Depth column holds only numbers	OK
31	Depth samples form one block from the first row	OK
32	There are at least two depth samples	OK
33	Depths increase down the sheet	OK
34	Every pasted row fits the sheet	OK
35	The window overlaps the data	OK
36	Depth per row is positive	OK
37	SP scale increases and holds the shale baseline	OK
38	GR scale increases	OK
39	Resistivity scale is positive, increasing and within six decades	OK
40	GR palette edges increase	OK
41	Clean-sand GR is below shale GR	OK

	A	B	C	D	E	F	H
1	Log Data — paste the curves here
2	Depth in the first column, increasing downward, then SP, GR and the shallow, medium and deep resistivity — any sampling interval, up to 5,000 rows. Paste over the example (a synthetic sand–shale sequence at 0.5 ft) from A5 and the Well Log follows. A sample that is blank, text or an error, or equal to the null value on the Inputs sheet (LAS files use −999.25), leaves a gap in that curve.
3	Curves
4	Depth (ft)	SP (mV)	GR (API)	RS (ohm·m)	RM (ohm·m)	RD (ohm·m)	Notes
5	5000	-14.7	111.3	2.1	2.32	2.43	Only these six columns are read. Put anything else — a header block, a comment — to the right of column H.
6	5000.5	-14.1	115.4	2.04	2.2	2.48	A curve you do not have can stay empty: its track is blank and the others are unaffected.
7	5001	-14.8	118.1	2.08	2.22	2.25	Resistivity must be above zero; a zero or negative sample is a gap, not a reading.
8	5001.5	-14.4	116.4	1.99	2.08	2.16
9	5002	-14.6	116.4	1.83	2.05	2.44
10	5002.5	-16.2	114.9	1.93	2.2	2.52
11	5003	-16	112.1	2.06	2.24	2.45
12	5003.5	-14.8	113.3	2.01	2.33	2.56
13	5004	-14.8	114.4	2.07	2.39	2.46
14	5004.5	-14.5	114.9	2.14	2.15	2.25
15	5005	-14.1	118.4	1.97	2.05	2.28
16	5005.5	-15.1	117.9	1.89	2.17	2.31
17	5006	-15.6	113.2	1.94	2.11	2.38
18	5006.5	-15.6	113.4	1.94	2.14	2.62
19	5007	-16	114.2	2.04	2.42	2.57
20	5007.5	-15.1	111.8	2.14	2.4	2.39
21	5008	-14.2	114.2	2.06	2.2	2.46
22	5008.5	-15.4	117.6	2.06	2.23	2.41
23	5009	-16.4	115	2.08	2.22	2.32
24	5009.5	-17.3	111.9	1.98	2.27	2.72
25	5010	-20.7	108.4	2.12	2.66	3.27
26	5010.5	-24.6	101.1	2.55	3.15	3.69
27	5011	-28.8	94.5	2.89	3.91	4.83
28	5011.5	-36.3	86.5	3.44	5.44	6.96
29	5012	-46	73.9	4.47	7.2	10
30	5012.5	-55.3	63.4	5.29	9.46	15.9
31	5013	-64	53.9	6.01	13.7	24.2
32	5013.5	-70.4	41.5	7.12	17.5	32.2
33	5014	-73.7	35.2	7.92	19.5	41.2
34	5014.5	-75.9	35.1	8.6	23.2	45.9
35	5015	-76.6	32.5	9.33	24.9	43.6
36	5015.5	-75.9	32.4	9.08	22.9	44.7
37	5016	-76.9	36.1	8.74	22.5	46.3
38	5016.5	-78.2	34.8	8.92	22.9	43.8
39	5017	-77.9	31.7	8.52	22.5	46.7
40	5017.5	-78.4	31.2	8.4	24.1	52.6
41	5018	-79.2	29.5	9.35	25.5	50.6
42	5018.5	-77.9	29.8	9.59	24.8	48.2
43	5019	-77	33.2	9.09	25.1	48.3
44	5019.5	-77.5	33.3	9.22	24.1	45.2
45	5020	-77.5	33.4	8.99	21.6	44.8
46	5020.5	-78	35	8.4	22.7	48
47	5021	-79	31.2	8.65	24.8	48.7
48	5021.5	-78.5	27.9	9.03	24	50.8
49	5022	-78.2	31.1	9.18	25	52.3
50	5022.5	-78.1	32.2	9.61	26.3	46.9
51	5023	-76.9	31.5	9.34	23.8	44.6
52	5023.5	-77	34.8	8.66	22.3	47.3
53	5024	-78.6	35	8.8	23.1	46.1
54	5024.5	-78.5	31.2	8.77	23.1	46.5
55	5025	-78.2	30.4	8.47	24.2	52.4
56	5025.5	-78.9	29.9	9.21	25.9	51.9
57	5026	-78.1	29.8	9.8	24.9	47.4
58	5026.5	-76.8	33.4	9.16	24.3	47.1
59	5027	-77.3	34.4	8.95	24.2	45.7
60	5027.5	-77.8	32.8	8.97	22	44.7
61	5028	-78.1	34	8.47	22.1	48.3
62	5028.5	-78.9	32.1	8.59	25.1	49.7
63	5029	-78.5	27.8	9.14	24.9	49.7
64	5029.5	-77.6	30.4	9.2	24.2	51.2
65	5030	-77.5	34	9.4	25.3	46.7
66	5030.5	-76.4	33.5	9.23	23.4	41.9
67	5031	-75.4	35.7	8.31	20.8	43.5
68	5031.5	-75.8	38.4	8.04	20.7	42.4
69	5032	-74.3	37.5	7.97	19.7	37.3
70	5032.5	-69.8	40.6	7.1	17.7	34.4
71	5033	-64.4	48.7	6.48	15.3	27
72	5033.5	-56.3	59.1	5.83	10.9	16.6
73	5034	-45.4	74.7	4.39	7.16	10.3
74	5034.5	-36.2	89.3	3.28	5.05	6.56
75	5035	-29.2	97.1	2.76	3.54	4.42
76	5035.5	-23.8	104.1	2.35	2.78	3.64
77	5036	-20.9	108.7	2.16	2.77	3.25
78	5036.5	-18.9	107.2	2.22	2.69	2.88
79	5037	-16.9	109	2.21	2.45	2.83
80	5037.5	-16.9	113.8	2.22	2.52	2.73
81	5038	-17.8	112.2	2.29	2.57	2.57
82	5038.5	-19.1	108.7	2.24	2.55	2.99
83	5039	-23.6	105.3	2.38	3.03	3.91
84	5039.5	-29.3	95.9	2.93	4	4.88
85	5040	-33.9	85.4	3.46	5.26	6.84
86	5040.5	-39	78.9	4.08	7.15	9.77
87	5041	-43.9	72.8	5.07	8.7	11.4
88	5041.5	-46.2	70	5.46	9.24	12.8
89	5042	-48.2	69.7	5.29	10.2	14.8
90	5042.5	-50.7	65.4	5.51	10.8	15.9
91	5043	-51.7	62.1	5.68	10.7	17.3
92	5043.5	-52.3	62.6	5.7	11.9	18.9
93	5044	-52.5	59.9	6.11	13.2	18.3
94	5044.5	-51.4	58.9	6.29	12.2	17.9
95	5045	-51.1	63.9	6.12	11.7	17.8
96	5045.5	-51.7	65.2	6.11	11.8	15.9
97	5046	-51.3	62.8	5.75	10.7	15.5
98	5046.5	-51.9	63.2	5.37	10.3	16.7
99	5047	-53.3	61.8	5.64	10.5	15.2
100	5047.5	-52.4	59.1	5.69	9.53	12.6
101	5048	-51.1	60.8	5.23	8.13	10.3
102	5048.5	-51.1	62.6	5.06	6.31	6.83
103	5049	-50.4	63.8	4.65	4.2	4.09
104	5049.5	-49.7	66.8	3.82	3.03	2.78
105	5050	-50.7	65.4	3.46	2.47	2.01
106	5050.5	-51	61.6	3.41	1.99	1.61
107	5051	-50.7	62.7	3.29	1.86	1.48
108	5051.5	-50.7	62.8	3.37	1.95	1.3
109	5052	-49.6	61.1	3.46	1.76	1.15
110	5052.5	-48.9	65.1	3.29	1.58	1.14
111	5053	-49.7	68.2	3.22	1.6	1.06
112	5053.5	-49.8	65.2	3.15	1.54	1.02
113	5054	-49.6	64.1	2.95	1.5	1.15
114	5054.5	-50.8	64.1	3.09	1.65	1.21
115	5055	-50.2	62.2	3.34	1.71	1.14
116	5055.5	-47.9	64.3	3.21	1.7	1.18
117	5056	-46.7	68.7	3.16	1.73	1.18
118	5056.5	-45	71.9	3.16	1.61	1.12
119	5057	-41.5	78.1	2.8	1.57	1.23
120	5057.5	-38	84.1	2.51	1.76	1.45
121	5058	-33.5	87.1	2.48	1.86	1.66
122	5058.5	-27.7	94.7	2.36	1.95	1.97
123	5059	-23.2	103.4	2.28	2.25	2.14
124	5059.5	-19.4	106.5	2.27	2.27	2.08
125	5060	-16.4	111.4	2.11	2.04	2.19
126	5060.5	-16.1	117.1	2	2.07	2.25
127	5061	-16.2	115.5	1.99	2.12	2.18
128	5061.5	-15.4	113.1	1.89	2.08	2.41
129	5062	-16	113.6	1.92	2.24	2.66
130	5062.5	-16.2	112.4	2.13	2.36	2.47
131	5063	-14.5	113	2.11	2.28	2.38
132	5063.5	-14	116.4	2.01	2.27	2.41
133	5064	-14.7	116.6	2.06	2.15	2.24
134	5064.5	-14.6	116.8	1.97	1.99	2.24
135	5065	-15.2	117.2	1.85	2.14	2.44
136	5065.5	-16.1	112.9	1.95	2.28	2.49
137	5066	-15.5	111.2	2.05	2.21	2.56
138	5066.5	-15.1	114.8	2.07	2.35	2.57
139	5067	-14.8	114.8	2.14	2.42	2.32
140	5067.5	-13.9	114.5	2.08	2.14	2.29
141	5068	-14.5	117.9	1.98	2.1	2.45
142	5068.5	-15.9	116.2	2.06	2.29	2.44
143	5069	-15.7	111	2.14	2.4	2.69
144	5069.5	-16	109.2	2.31	2.76	3.32
145	5070	-17.1	106.2	2.96	3.47	3.74
146	5070.5	-16.7	101	3.93	4.41	4.6
147	5071	-17	96	5.42	6.68	7.43
148	5071.5	-19.9	85	9.51	12.2	13.7
149	5072	-22.6	69.6	18.7	23.9	29.3
150	5072.5	-25.1	56	34.5	52.7	69.3
151	5073	-27.9	41.5	62.1	108	134
152	5073.5	-29.1	30.2	97.8	159	205
153	5074	-29.6	28.7	121	199	259
154	5074.5	-30.9	28.2	133	222	250
155	5075	-32.1	25.4	124	184	211
156	5075.5	-34.9	27.3	96.9	132	167
157	5076	-40.5	28.4	70.9	89.7	98.6
158	5076.5	-46.2	25.3	45.6	47.4	44.8
159	5077	-52	26.4	25.1	21.4	19.2
160	5077.5	-59.2	30	15	10	7.31
161	5078	-64.1	31.9	9.8	4.87	2.92
162	5078.5	-66.8	35.8	6.38	2.82	1.65
163	5079	-70.1	38	4.9	2.07	1.17
164	5079.5	-72.5	36	4.42	1.63	0.928
165	5080	-73.3	36	3.96	1.49	0.885
166	5080.5	-74.3	35.2	3.83	1.6	0.87
167	5081	-74.3	31.8	4.06	1.55	0.812
168	5081.5	-73.4	34.4	4.05	1.43	0.795
169	5082	-73.4	38.7	3.95	1.47	0.742
170	5082.5	-73.4	37.3	3.89	1.4	0.681
171	5083	-73.2	37	3.62	1.27	0.731
172	5083.5	-74.6	38.3	3.58	1.34	0.778
173	5084	-75.3	34.6	3.81	1.44	0.751
174	5084.5	-74	32.5	3.78	1.44	0.794
175	5085	-74	34.9	3.86	1.5	0.816
176	5085.5	-74	35.8	4.14	1.46	0.721
177	5086	-72.9	37.5	3.9	1.34	0.693
178	5086.5	-73.2	39.3	3.58	1.35	0.731
179	5087	-74.6	36.6	3.69	1.34	0.729
180	5087.5	-74.6	34.9	3.71	1.32	0.764
181	5088	-74.6	35.5	3.68	1.48	0.812
182	5088.5	-74.5	32.9	3.95	1.55	0.776
183	5089	-73.4	33.7	4.03	1.4	0.756
184	5089.5	-73.2	39	3.88	1.39	0.739
185	5090	-73.7	38.7	3.83	1.4	0.681
186	5090.5	-73.5	36.2	3.64	1.28	0.713
187	5091	-74.4	37.2	3.53	1.32	0.796
188	5091.5	-75.5	35.1	3.81	1.46	0.774
189	5092	-74.3	32.3	3.9	1.47	0.769
190	5092.5	-73.4	34.8	3.83	1.47	0.805
191	5093	-73.9	36.8	4.04	1.46	0.733
192	5093.5	-73.2	37.5	3.95	1.33	0.679
193	5094	-73.1	39.2	3.56	1.32	0.727
194	5094.5	-74.5	37	3.6	1.37	0.751
195	5095	-74.8	33.9	3.77	1.34	0.767
196	5095.5	-74.2	35.3	3.73	1.45	0.814
197	5096	-74	34.9	3.9	1.57	0.784
198	5096.5	-72.7	34.6	4.02	1.43	0.745
199	5097	-71.6	40.3	3.8	1.35	0.756
200	5097.5	-71.3	43.2	3.66	1.41	0.732
201	5098	-69.4	42	3.5	1.37	0.767
202	5098.5	-66.3	46.1	3.24	1.4	0.933
203	5099	-62.2	53	3.28	1.62	1.04
204	5099.5	-54	60.3	3.21	1.75	1.13
205	5100	-43.6	74	2.8	1.82	1.39
206	5100.5	-35.1	89	2.58	1.93	1.59
207	5101	-27.8	99.1	2.41	1.89	1.67
208	5101.5	-22.1	107.1	2.06	1.92	1.96
209	5102	-19.9	110.2	1.95	2.11	2.25
210	5102.5	-18.6	108.9	2.06	2.14	2.35
211	5103	-16.7	111.2	2.05	2.21	2.5
212	5103.5	-15.8	113.6	2.07	2.43	2.46
213	5104	-14.9	112.8	2.14	2.29	2.28
214	5104.5	-14.1	116.2	2.03	2.05	2.31
215	5105	-14.9	119.3	1.95	2.12	2.29
216	5105.5	-15.4	115.4	1.94	2.14	2.25
217	5106	-15.2	113.1	1.88	2.09	2.52
218	5106.5	-16	114.2	1.97	2.28	2.65
219	5107	-15.8	112.6	2.15	2.39	2.41
220	5107.5	-14	113.4	2.07	2.27	2.39
221	5108	-14.1	117	2	2.22	2.4
222	5108.5	-14.9	117.1	2.06	2.11	2.21
223	5109	-14.6	116.8	1.93	2.01	2.26
224	5109.5	-15.3	116.2	1.84	2.18	2.5
225	5110	-16.2	112.2	1.99	2.27	2.51
226	5110.5	-15.4	112	2.07	2.22	2.53
227	5111	-14.8	115.3	2.05	2.38	2.5
228	5111.5	-14.5	114.8	2.1	2.34	2.28
229	5112	-13.9	115.6	2.03	2.04	2.27
230	5112.5	-14.7	119.1	1.91	2.05	2.35
231	5113	-15.8	116.3	1.94	2.19	2.3
232	5113.5	-15.3	112.2	1.92	2.14	2.47
233	5114	-15.5	113.4	1.95	2.26	2.69
234	5114.5	-15.8	113.7	2.14	2.4	2.45
235	5115	-14.2	113.7	2.13	2.26	2.29
236	5115.5	-13.7	117	1.97	2.17	2.37
237	5116	-15	117.6	2	2.12	2.27
238	5116.5	-15.1	116	1.97	2.02	2.26
239	5117	-15.2	115.7	1.85	2.16	2.51
240	5117.5	-16.1	112.7	1.97	2.34	2.56
241	5118	-15.5	111.2	2.11	2.25	2.5
242	5118.5	-14.5	115.3	2.07	2.29	2.48
243	5119	-14.5	116.5	2.07	2.34	2.28
244	5119.5	-14.1	115.3	2.02	2.07	2.22
245	5120	-14.6	117.9	1.9	1.99	2.38

	A	C	D	E	F	G	I	J
1	Well log — Example well A-12
2	Depth 5000–5120 ft, 1 ft per row. 241 samples in Log Data, 5000–5120 ft.
3	Inputs consistent.
4
5	Depth (ft)	SP (mV)	GR (API)	Lith.	Resistivity (ohm·m, log)	Vsh (v/v)	Legend
6		-100 … 0	0 … 150		0.2 … 2000	0 … 1
7	5000							SP, toward sand (left of the baseline)
8
9								SP, toward shale (right of the baseline)
10
11								clean sand GR < 45
12
13								sand GR 45 – 65
14
15								shaly sand GR 65 – 85
16
17	5010							sandy shale GR 85 – 105
18
19								shale GR ≥ 105
20
21							– – –	Shallow resistivity (RS)
22							– – –
23							· · · ·	Medium resistivity (RM)
24							· · · ·
25							━━━━	Deep resistivity (RD)
26							━━━━
27	5020							Vsh, from the gamma-ray index
28
29
30
31
32
33
34
35
36
37	5030
38
39
40
41
42
43
44
45
46
47	5040
48
49
50
51
52
53
54
55
56
57	5050
58
59
60
61
62
63
64
65
66
67	5060
68
69
70
71
72
73
74
75
76
77	5070
78
79
80
81
82
83
84
85
86
87	5080
88
89
90
91
92
93
94
95
96
97	5090
98
99
100
101
102
103
104
105
106
107	5100
108
109
110
111
112
113
114
115
116
117	5110
118
119
120
121
122
123
124
125
126

offset SP, sand side SP, shale side

GR, clean sand GR, sand GR, shaly sand GR, sandy shale GR, shale

Vsh

Lines at 2–9× a decade Decade lines Shallow resistivity (RS) Medium resistivity (RM) Deep resistivity (RD)

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	Y	Z	AA	AB
1	Calc — helpers for the Well Log sheet
2	Nothing here needs editing. The Well Log draws from this sheet; every chart series is the share of its track the scale cells give it.
3	Samples in Log Data	241
4	First depth (ft)	5,000.0
5	Last depth (ft)	5,120.0
6	Window top (ft)	5,000.0
7	Window base (ft)	5,120.0
8	Decade of the resistivity left edge	-1
9	log10 of the resistivity left edge	-0.699
10	Resistivity scale, decades	4.000
11
12	Track row				Curves on the track rows						Chart series (0–1 of the track)													Decade lines of the resistivity track
13	Row	Depth sampled (ft)	Sample at or above	Fraction to the next sample	SP (mV)	GR (API)	RS (ohm·m)	RM (ohm·m)	RD (ohm·m)	Vsh (v/v)	SP offset (hidden bar)	SP, sand side	SP, shale side	GR on the scale	GR palette band (0–4)	GR, clean sand	GR, sand	GR, shaly sand	GR, sandy shale	GR, shale	RS (ohm·m), log scale	RM (ohm·m), log scale	RD (ohm·m), log scale	Decade lines, x	Decade lines, y	Lines at 2–9×, x	Lines at 2–9×, y
14	0	5,000.5	2	0.000	-14.1	115.4	2.04	2.2	2.48	1.000	0.850	0.000	0.009	0.769	4	0.000	0.000	0.000	0.000	0.769	0.252	0.260	0.273	0.000	-1.500	0.000	-1.500
15	1	5,001.5	4	0.000	-14.4	116.4	1.99	2.08	2.16	1.000	0.850	0.000	0.006	0.776	4	0.000	0.000	0.000	0.000	0.776	0.249	0.254	0.258	0.000	120.500	0.000	120.500
16	2	5,002.5	6	0.000	-16.2	114.9	1.93	2.2	2.52	0.999	0.838	0.012	0.000	0.766	4	0.000	0.000	0.000	0.000	0.766	0.246	0.260	0.275	0.175	120.500	0.044	120.500
17	3	5,003.5	8	0.000	-14.8	113.3	2.01	2.33	2.56	0.980	0.850	0.000	0.002	0.755	4	0.000	0.000	0.000	0.000	0.755	0.251	0.267	0.277	0.175	-1.500	0.044	-1.500
18	4	5,004.5	10	0.000	-14.5	114.9	2.14	2.15	2.25	0.999	0.850	0.000	0.005	0.766	4	0.000	0.000	0.000	0.000	0.766	0.257	0.258	0.263	0.425	-1.500	0.075	-1.500
19	5	5,005.5	12	0.000	-15.1	117.9	1.89	2.17	2.31	1.000	0.849	0.001	0.000	0.786	4	0.000	0.000	0.000	0.000	0.786	0.244	0.259	0.266	0.425	120.500	0.075	120.500
20	6	5,006.5	14	0.000	-15.6	113.4	1.94	2.14	2.62	0.981	0.844	0.006	0.000	0.756	4	0.000	0.000	0.000	0.000	0.756	0.247	0.257	0.279	0.675	120.500	0.099	120.500
21	7	5,007.5	16	0.000	-15.1	111.8	2.14	2.4	2.39	0.962	0.849	0.001	0.000	0.745	4	0.000	0.000	0.000	0.000	0.745	0.257	0.270	0.269	0.675	-1.500	0.099	-1.500
22	8	5,008.5	18	0.000	-15.4	117.6	2.06	2.23	2.41	1.000	0.846	0.004	0.000	0.784	4	0.000	0.000	0.000	0.000	0.784	0.253	0.262	0.270	0.925	-1.500	0.119	-1.500
23	9	5,009.5	20	0.000	-17.3	111.9	1.98	2.27	2.72	0.964	0.827	0.023	0.000	0.746	4	0.000	0.000	0.000	0.000	0.746	0.249	0.264	0.283	0.925	120.500	0.119	120.500
24	10	5,010.5	22	0.000	-24.6	101.1	2.55	3.15	3.69	0.836	0.754	0.096	0.000	0.674	3	0.000	0.000	0.000	0.674	0.000	0.276	0.299	0.316	1.000	120.500	0.136	120.500
25	11	5,011.5	24	0.000	-36.3	86.5	3.44	5.44	6.96	0.665	0.637	0.213	0.000	0.577	3	0.000	0.000	0.000	0.577	0.000	0.309	0.359	0.385	1.000	-1.500	0.136	-1.500
26	12	5,012.5	26	0.000	-55.3	63.4	5.29	9.46	15.9	0.393	0.447	0.403	0.000	0.423	1	0.000	0.423	0.000	0.000	0.000	0.356	0.419	0.475	1.000	-1.500	0.151	-1.500
27	13	5,013.5	28	0.000	-70.4	41.5	7.12	17.5	32.2	0.135	0.296	0.554	0.000	0.277	0	0.277	0.000	0.000	0.000	0.000	0.388	0.486	0.552	1.000	120.500	0.151	120.500
28	14	5,014.5	30	0.000	-75.9	35.1	8.6	23.2	45.9	0.060	0.241	0.609	0.000	0.234	0	0.234	0.000	0.000	0.000	0.000	0.408	0.516	0.590			0.163	120.500
29	15	5,015.5	32	0.000	-75.9	32.4	9.08	22.9	44.7	0.028	0.241	0.609	0.000	0.216	0	0.216	0.000	0.000	0.000	0.000	0.414	0.515	0.587			0.163	-1.500
30	16	5,016.5	34	0.000	-78.2	34.8	8.92	22.9	43.8	0.056	0.218	0.632	0.000	0.232	0	0.232	0.000	0.000	0.000	0.000	0.412	0.515	0.585			0.250	-1.500
31	17	5,017.5	36	0.000	-78.4	31.2	8.4	24.1	52.6	0.014	0.216	0.634	0.000	0.208	0	0.208	0.000	0.000	0.000	0.000	0.406	0.520	0.605			0.250	120.500
32	18	5,018.5	38	0.000	-77.9	29.8	9.59	24.8	48.2	0.000	0.221	0.629	0.000	0.199	0	0.199	0.000	0.000	0.000	0.000	0.420	0.523	0.596			0.294	120.500
33	19	5,019.5	40	0.000	-77.5	33.3	9.22	24.1	45.2	0.039	0.225	0.625	0.000	0.222	0	0.222	0.000	0.000	0.000	0.000	0.416	0.520	0.589			0.294	-1.500
34	20	5,020.5	42	0.000	-78	35	8.4	22.7	48	0.059	0.220	0.630	0.000	0.233	0	0.233	0.000	0.000	0.000	0.000	0.406	0.514	0.595			0.325	-1.500
35	21	5,021.5	44	0.000	-78.5	27.9	9.03	24	50.8	0.000	0.215	0.635	0.000	0.186	0	0.186	0.000	0.000	0.000	0.000	0.414	0.520	0.601			0.325	120.500
36	22	5,022.5	46	0.000	-78.1	32.2	9.61	26.3	46.9	0.026	0.219	0.631	0.000	0.215	0	0.215	0.000	0.000	0.000	0.000	0.420	0.530	0.593			0.349	120.500
37	23	5,023.5	48	0.000	-77	34.8	8.66	22.3	47.3	0.056	0.230	0.620	0.000	0.232	0	0.232	0.000	0.000	0.000	0.000	0.409	0.512	0.593			0.349	-1.500
38	24	5,024.5	50	0.000	-78.5	31.2	8.77	23.1	46.5	0.014	0.215	0.635	0.000	0.208	0	0.208	0.000	0.000	0.000	0.000	0.410	0.516	0.592			0.369	-1.500
39	25	5,025.5	52	0.000	-78.9	29.9	9.21	25.9	51.9	0.000	0.211	0.639	0.000	0.199	0	0.199	0.000	0.000	0.000	0.000	0.416	0.528	0.604			0.369	120.500
40	26	5,026.5	54	0.000	-76.8	33.4	9.16	24.3	47.1	0.040	0.232	0.618	0.000	0.223	0	0.223	0.000	0.000	0.000	0.000	0.415	0.521	0.593			0.386	120.500
41	27	5,027.5	56	0.000	-77.8	32.8	8.97	22	44.7	0.033	0.222	0.628	0.000	0.219	0	0.219	0.000	0.000	0.000	0.000	0.413	0.510	0.587			0.386	-1.500
42	28	5,028.5	58	0.000	-78.9	32.1	8.59	25.1	49.7	0.025	0.211	0.639	0.000	0.214	0	0.214	0.000	0.000	0.000	0.000	0.408	0.525	0.599			0.401	-1.500
43	29	5,029.5	60	0.000	-77.6	30.4	9.2	24.2	51.2	0.005	0.224	0.626	0.000	0.203	0	0.203	0.000	0.000	0.000	0.000	0.416	0.521	0.602			0.401	120.500
44	30	5,030.5	62	0.000	-76.4	33.5	9.23	23.4	41.9	0.041	0.236	0.614	0.000	0.223	0	0.223	0.000	0.000	0.000	0.000	0.416	0.517	0.580			0.413	120.500
45	31	5,031.5	64	0.000	-75.8	38.4	8.04	20.7	42.4	0.099	0.242	0.608	0.000	0.256	0	0.256	0.000	0.000	0.000	0.000	0.401	0.504	0.582			0.413	-1.500
46	32	5,032.5	66	0.000	-69.8	40.6	7.1	17.7	34.4	0.125	0.302	0.548	0.000	0.271	0	0.271	0.000	0.000	0.000	0.000	0.388	0.487	0.559			0.500	-1.500
47	33	5,033.5	68	0.000	-56.3	59.1	5.83	10.9	16.6	0.342	0.437	0.413	0.000	0.394	1	0.000	0.394	0.000	0.000	0.000	0.366	0.434	0.480			0.500	120.500
48	34	5,034.5	70	0.000	-36.2	89.3	3.28	5.05	6.56	0.698	0.638	0.212	0.000	0.595	3	0.000	0.000	0.000	0.595	0.000	0.304	0.351	0.379			0.544	120.500
49	35	5,035.5	72	0.000	-23.8	104.1	2.35	2.78	3.64	0.872	0.762	0.088	0.000	0.694	3	0.000	0.000	0.000	0.694	0.000	0.268	0.286	0.315			0.544	-1.500
50	36	5,036.5	74	0.000	-18.9	107.2	2.22	2.69	2.88	0.908	0.811	0.039	0.000	0.715	4	0.000	0.000	0.000	0.000	0.715	0.261	0.282	0.290			0.575	-1.500
51	37	5,037.5	76	0.000	-16.9	113.8	2.22	2.52	2.73	0.986	0.831	0.019	0.000	0.759	4	0.000	0.000	0.000	0.000	0.759	0.261	0.275	0.284			0.575	120.500
52	38	5,038.5	78	0.000	-19.1	108.7	2.24	2.55	2.99	0.926	0.809	0.041	0.000	0.725	4	0.000	0.000	0.000	0.000	0.725	0.262	0.276	0.294			0.599	120.500
53	39	5,039.5	80	0.000	-29.3	95.9	2.93	4	4.88	0.775	0.707	0.143	0.000	0.639	3	0.000	0.000	0.000	0.639	0.000	0.291	0.325	0.347			0.599	-1.500
54	40	5,040.5	82	0.000	-39	78.9	4.08	7.15	9.77	0.575	0.610	0.240	0.000	0.526	2	0.000	0.000	0.526	0.000	0.000	0.327	0.388	0.422			0.619	-1.500
55	41	5,041.5	84	0.000	-46.2	70	5.46	9.24	12.8	0.471	0.538	0.312	0.000	0.467	2	0.000	0.000	0.467	0.000	0.000	0.359	0.416	0.452			0.619	120.500
56	42	5,042.5	86	0.000	-50.7	65.4	5.51	10.8	15.9	0.416	0.493	0.357	0.000	0.436	2	0.000	0.000	0.436	0.000	0.000	0.360	0.433	0.475			0.636	120.500
57	43	5,043.5	88	0.000	-52.3	62.6	5.7	11.9	18.9	0.384	0.477	0.373	0.000	0.417	1	0.000	0.417	0.000	0.000	0.000	0.364	0.444	0.494			0.636	-1.500
58	44	5,044.5	90	0.000	-51.4	58.9	6.29	12.2	17.9	0.340	0.486	0.364	0.000	0.393	1	0.000	0.393	0.000	0.000	0.000	0.374	0.446	0.488			0.651	-1.500
59	45	5,045.5	92	0.000	-51.7	65.2	6.11	11.8	15.9	0.414	0.483	0.367	0.000	0.435	2	0.000	0.000	0.435	0.000	0.000	0.371	0.443	0.475			0.651	120.500
60	46	5,046.5	94	0.000	-51.9	63.2	5.37	10.3	16.7	0.391	0.481	0.369	0.000	0.421	1	0.000	0.421	0.000	0.000	0.000	0.357	0.428	0.480			0.663	120.500
61	47	5,047.5	96	0.000	-52.4	59.1	5.69	9.53	12.6	0.342	0.476	0.374	0.000	0.394	1	0.000	0.394	0.000	0.000	0.000	0.364	0.420	0.450			0.663	-1.500
62	48	5,048.5	98	0.000	-51.1	62.6	5.06	6.31	6.83	0.384	0.489	0.361	0.000	0.417	1	0.000	0.417	0.000	0.000	0.000	0.351	0.375	0.383			0.750	-1.500
63	49	5,049.5	100	0.000	-49.7	66.8	3.82	3.03	2.78	0.433	0.503	0.347	0.000	0.445	2	0.000	0.000	0.445	0.000	0.000	0.320	0.295	0.286			0.750	120.500
64	50	5,050.5	102	0.000	-51	61.6	3.41	1.99	1.61	0.372	0.490	0.360	0.000	0.411	1	0.000	0.411	0.000	0.000	0.000	0.308	0.249	0.226			0.794	120.500
65	51	5,051.5	104	0.000	-50.7	62.8	3.37	1.95	1.3	0.386	0.493	0.357	0.000	0.419	1	0.000	0.419	0.000	0.000	0.000	0.307	0.247	0.203			0.794	-1.500
66	52	5,052.5	106	0.000	-48.9	65.1	3.29	1.58	1.14	0.413	0.511	0.339	0.000	0.434	2	0.000	0.000	0.434	0.000	0.000	0.304	0.224	0.189			0.825	-1.500
67	53	5,053.5	108	0.000	-49.8	65.2	3.15	1.54	1.02	0.414	0.502	0.348	0.000	0.435	2	0.000	0.000	0.435	0.000	0.000	0.299	0.222	0.177			0.825	120.500
68	54	5,054.5	110	0.000	-50.8	64.1	3.09	1.65	1.21	0.401	0.492	0.358	0.000	0.427	1	0.000	0.427	0.000	0.000	0.000	0.297	0.229	0.195			0.849	120.500
69	55	5,055.5	112	0.000	-47.9	64.3	3.21	1.7	1.18	0.404	0.521	0.329	0.000	0.429	1	0.000	0.429	0.000	0.000	0.000	0.301	0.232	0.193			0.849	-1.500
70	56	5,056.5	114	0.000	-45	71.9	3.16	1.61	1.12	0.493	0.550	0.300	0.000	0.479	2	0.000	0.000	0.479	0.000	0.000	0.300	0.226	0.187			0.869	-1.500
71	57	5,057.5	116	0.000	-38	84.1	2.51	1.76	1.45	0.636	0.620	0.230	0.000	0.561	2	0.000	0.000	0.561	0.000	0.000	0.275	0.236	0.215			0.869	120.500
72	58	5,058.5	118	0.000	-27.7	94.7	2.36	1.95	1.97	0.761	0.723	0.127	0.000	0.631	3	0.000	0.000	0.000	0.631	0.000	0.268	0.247	0.248			0.886	120.500
73	59	5,059.5	120	0.000	-19.4	106.5	2.27	2.27	2.08	0.900	0.806	0.044	0.000	0.710	4	0.000	0.000	0.000	0.000	0.710	0.264	0.264	0.254			0.886	-1.500
74	60	5,060.5	122	0.000	-16.1	117.1	2	2.07	2.25	1.000	0.839	0.011	0.000	0.781	4	0.000	0.000	0.000	0.000	0.781	0.250	0.254	0.263			0.901	-1.500
75	61	5,061.5	124	0.000	-15.4	113.1	1.89	2.08	2.41	0.978	0.846	0.004	0.000	0.754	4	0.000	0.000	0.000	0.000	0.754	0.244	0.254	0.270			0.901	120.500
76	62	5,062.5	126	0.000	-16.2	112.4	2.13	2.36	2.47	0.969	0.838	0.012	0.000	0.749	4	0.000	0.000	0.000	0.000	0.749	0.257	0.268	0.273			0.913	120.500
77	63	5,063.5	128	0.000	-14	116.4	2.01	2.27	2.41	1.000	0.850	0.000	0.010	0.776	4	0.000	0.000	0.000	0.000	0.776	0.251	0.264	0.270			0.913	-1.500
78	64	5,064.5	130	0.000	-14.6	116.8	1.97	1.99	2.24	1.000	0.850	0.000	0.004	0.779	4	0.000	0.000	0.000	0.000	0.779	0.248	0.249	0.262			1.000	-1.500
79	65	5,065.5	132	0.000	-16.1	112.9	1.95	2.28	2.49	0.975	0.839	0.011	0.000	0.753	4	0.000	0.000	0.000	0.000	0.753	0.247	0.264	0.274			1.000	120.500
80	66	5,066.5	134	0.000	-15.1	114.8	2.07	2.35	2.57	0.998	0.849	0.001	0.000	0.765	4	0.000	0.000	0.000	0.000	0.765	0.254	0.268	0.277			1.000	120.500
81	67	5,067.5	136	0.000	-13.9	114.5	2.08	2.14	2.29	0.994	0.850	0.000	0.011	0.763	4	0.000	0.000	0.000	0.000	0.763	0.254	0.257	0.265			1.000	-1.500
82	68	5,068.5	138	0.000	-15.9	116.2	2.06	2.29	2.44	1.000	0.841	0.009	0.000	0.775	4	0.000	0.000	0.000	0.000	0.775	0.253	0.265	0.272			1.000	-1.500
83	69	5,069.5	140	0.000	-16	109.2	2.31	2.76	3.32	0.932	0.840	0.010	0.000	0.728	4	0.000	0.000	0.000	0.000	0.728	0.266	0.285	0.305			1.000	120.500
84	70	5,070.5	142	0.000	-16.7	101	3.93	4.41	4.6	0.835	0.833	0.017	0.000	0.673	3	0.000	0.000	0.000	0.673	0.000	0.323	0.336	0.340			1.000	120.500
85	71	5,071.5	144	0.000	-19.9	85	9.51	12.2	13.7	0.647	0.801	0.049	0.000	0.567	3	0.000	0.000	0.000	0.567	0.000	0.419	0.446	0.459			1.000	-1.500
86	72	5,072.5	146	0.000	-25.1	56	34.5	52.7	69.3	0.306	0.749	0.101	0.000	0.373	1	0.000	0.373	0.000	0.000	0.000	0.559	0.605	0.635			1.000	-1.500
87	73	5,073.5	148	0.000	-29.1	30.2	97.8	159	205	0.002	0.709	0.141	0.000	0.201	0	0.201	0.000	0.000	0.000	0.000	0.672	0.725	0.753			1.000	120.500
88	74	5,074.5	150	0.000	-30.9	28.2	133	222	250	0.000	0.691	0.159	0.000	0.188	0	0.188	0.000	0.000	0.000	0.000	0.706	0.761	0.774			1.000	120.500
89	75	5,075.5	152	0.000	-34.9	27.3	96.9	132	167	0.000	0.651	0.199	0.000	0.182	0	0.182	0.000	0.000	0.000	0.000	0.671	0.705	0.730			1.000	-1.500
90	76	5,076.5	154	0.000	-46.2	25.3	45.6	47.4	44.8	0.000	0.538	0.312	0.000	0.169	0	0.169	0.000	0.000	0.000	0.000	0.589	0.594	0.588			1.000	-1.500
91	77	5,077.5	156	0.000	-59.2	30	15	10	7.31	0.000	0.408	0.442	0.000	0.200	0	0.200	0.000	0.000	0.000	0.000	0.469	0.425	0.391			1.000	120.500
92	78	5,078.5	158	0.000	-66.8	35.8	6.38	2.82	1.65	0.068	0.332	0.518	0.000	0.239	0	0.239	0.000	0.000	0.000	0.000	0.376	0.287	0.229			1.000	120.500
93	79	5,079.5	160	0.000	-72.5	36	4.42	1.63	0.928	0.071	0.275	0.575	0.000	0.240	0	0.240	0.000	0.000	0.000	0.000	0.336	0.228	0.167			1.000	-1.500
94	80	5,080.5	162	0.000	-74.3	35.2	3.83	1.6	0.87	0.061	0.257	0.593	0.000	0.235	0	0.235	0.000	0.000	0.000	0.000	0.321	0.226	0.160			1.000	-1.500
95	81	5,081.5	164	0.000	-73.4	34.4	4.05	1.43	0.795	0.052	0.266	0.584	0.000	0.229	0	0.229	0.000	0.000	0.000	0.000	0.327	0.214	0.150			1.000	120.500
96	82	5,082.5	166	0.000	-73.4	37.3	3.89	1.4	0.681	0.086	0.266	0.584	0.000	0.249	0	0.249	0.000	0.000	0.000	0.000	0.322	0.211	0.133			1.000	120.500
97	83	5,083.5	168	0.000	-74.6	38.3	3.58	1.34	0.778	0.098	0.254	0.596	0.000	0.255	0	0.255	0.000	0.000	0.000	0.000	0.313	0.207	0.147			1.000	-1.500
98	84	5,084.5	170	0.000	-74	32.5	3.78	1.44	0.794	0.029	0.260	0.590	0.000	0.217	0	0.217	0.000	0.000	0.000	0.000	0.319	0.214	0.150			1.000	-1.500
99	85	5,085.5	172	0.000	-74	35.8	4.14	1.46	0.721	0.068	0.260	0.590	0.000	0.239	0	0.239	0.000	0.000	0.000	0.000	0.329	0.216	0.139			1.000	120.500
100	86	5,086.5	174	0.000	-73.2	39.3	3.58	1.35	0.731	0.109	0.268	0.582	0.000	0.262	0	0.262	0.000	0.000	0.000	0.000	0.313	0.207	0.141			1.000	120.500
101	87	5,087.5	176	0.000	-74.6	34.9	3.71	1.32	0.764	0.058	0.254	0.596	0.000	0.233	0	0.233	0.000	0.000	0.000	0.000	0.317	0.205	0.146			1.000	-1.500
102	88	5,088.5	178	0.000	-74.5	32.9	3.95	1.55	0.776	0.034	0.255	0.595	0.000	0.219	0	0.219	0.000	0.000	0.000	0.000	0.324	0.222	0.147			1.000	-1.500
103	89	5,089.5	180	0.000	-73.2	39	3.88	1.39	0.739	0.106	0.268	0.582	0.000	0.260	0	0.260	0.000	0.000	0.000	0.000	0.322	0.210	0.142			1.000	120.500
104	90	5,090.5	182	0.000	-73.5	36.2	3.64	1.28	0.713	0.073	0.265	0.585	0.000	0.241	0	0.241	0.000	0.000	0.000	0.000	0.315	0.202	0.138			1.000	120.500
105	91	5,091.5	184	0.000	-75.5	35.1	3.81	1.46	0.774	0.060	0.245	0.605	0.000	0.234	0	0.234	0.000	0.000	0.000	0.000	0.320	0.216	0.147			1.000	-1.500
106	92	5,092.5	186	0.000	-73.4	34.8	3.83	1.47	0.805	0.056	0.266	0.584	0.000	0.232	0	0.232	0.000	0.000	0.000	0.000	0.321	0.217	0.151			1.000	-1.500
107	93	5,093.5	188	0.000	-73.2	37.5	3.95	1.33	0.679	0.088	0.268	0.582	0.000	0.250	0	0.250	0.000	0.000	0.000	0.000	0.324	0.206	0.133			1.000	120.500
108	94	5,094.5	190	0.000	-74.5	37	3.6	1.37	0.751	0.082	0.255	0.595	0.000	0.247	0	0.247	0.000	0.000	0.000	0.000	0.314	0.209	0.144			1.000	120.500
109	95	5,095.5	192	0.000	-74.2	35.3	3.73	1.45	0.814	0.062	0.258	0.592	0.000	0.235	0	0.235	0.000	0.000	0.000	0.000	0.318	0.215	0.152			1.000	-1.500
110	96	5,096.5	194	0.000	-72.7	34.6	4.02	1.43	0.745	0.054	0.273	0.577	0.000	0.231	0	0.231	0.000	0.000	0.000	0.000	0.326	0.214	0.143			1.000	-1.500
111	97	5,097.5	196	0.000	-71.3	43.2	3.66	1.41	0.732	0.155	0.287	0.563	0.000	0.288	0	0.288	0.000	0.000	0.000	0.000	0.316	0.212	0.141			1.000	120.500
112	98	5,098.5	198	0.000	-66.3	46.1	3.24	1.4	0.933	0.189	0.337	0.513	0.000	0.307	1	0.000	0.307	0.000	0.000	0.000	0.302	0.211	0.167			1.000	120.500
113	99	5,099.5	200	0.000	-54	60.3	3.21	1.75	1.13	0.356	0.460	0.390	0.000	0.402	1	0.000	0.402	0.000	0.000	0.000	0.301	0.236	0.188			1.000	-1.500
114	100	5,100.5	202	0.000	-35.1	89	2.58	1.93	1.59	0.694	0.649	0.201	0.000	0.593	3	0.000	0.000	0.000	0.593	0.000	0.278	0.246	0.225			1.000	-1.500
115	101	5,101.5	204	0.000	-22.1	107.1	2.06	1.92	1.96	0.907	0.779	0.071	0.000	0.714	4	0.000	0.000	0.000	0.000	0.714	0.253	0.246	0.248			1.000	120.500
116	102	5,102.5	206	0.000	-18.6	108.9	2.06	2.14	2.35	0.928	0.814	0.036	0.000	0.726	4	0.000	0.000	0.000	0.000	0.726	0.253	0.257	0.268			1.000	120.500
117	103	5,103.5	208	0.000	-15.8	113.6	2.07	2.43	2.46	0.984	0.842	0.008	0.000	0.757	4	0.000	0.000	0.000	0.000	0.757	0.254	0.271	0.272			1.000	-1.500
118	104	5,104.5	210	0.000	-14.1	116.2	2.03	2.05	2.31	1.000	0.850	0.000	0.009	0.775	4	0.000	0.000	0.000	0.000	0.775	0.252	0.253	0.266			1.000	-1.500
119	105	5,105.5	212	0.000	-15.4	115.4	1.94	2.14	2.25	1.000	0.846	0.004	0.000	0.769	4	0.000	0.000	0.000	0.000	0.769	0.247	0.257	0.263			1.000	120.500
120	106	5,106.5	214	0.000	-16	114.2	1.97	2.28	2.65	0.991	0.840	0.010	0.000	0.761	4	0.000	0.000	0.000	0.000	0.761	0.248	0.264	0.281			1.000	120.500
121	107	5,107.5	216	0.000	-14	113.4	2.07	2.27	2.39	0.981	0.850	0.000	0.010	0.756	4	0.000	0.000	0.000	0.000	0.756	0.254	0.264	0.269			1.000	-1.500
122	108	5,108.5	218	0.000	-14.9	117.1	2.06	2.11	2.21	1.000	0.850	0.000	0.001	0.781	4	0.000	0.000	0.000	0.000	0.781	0.253	0.256	0.261			1.000	-1.500
123	109	5,109.5	220	0.000	-15.3	116.2	1.84	2.18	2.5	1.000	0.847	0.003	0.000	0.775	4	0.000	0.000	0.000	0.000	0.775	0.241	0.259	0.274			1.000	120.500
124	110	5,110.5	222	0.000	-15.4	112	2.07	2.22	2.53	0.965	0.846	0.004	0.000	0.747	4	0.000	0.000	0.000	0.000	0.747	0.254	0.261	0.276			1.000	120.500
125	111	5,111.5	224	0.000	-14.5	114.8	2.1	2.34	2.28	0.998	0.850	0.000	0.005	0.765	4	0.000	0.000	0.000	0.000	0.765	0.255	0.267	0.264			1.000	-1.500
126	112	5,112.5	226	0.000	-14.7	119.1	1.91	2.05	2.35	1.000	0.850	0.000	0.003	0.794	4	0.000	0.000	0.000	0.000	0.794	0.245	0.253	0.268
127	113	5,113.5	228	0.000	-15.3	112.2	1.92	2.14	2.47	0.967	0.847	0.003	0.000	0.748	4	0.000	0.000	0.000	0.000	0.748	0.246	0.257	0.273
128	114	5,114.5	230	0.000	-15.8	113.7	2.14	2.4	2.45	0.985	0.842	0.008	0.000	0.758	4	0.000	0.000	0.000	0.000	0.758	0.257	0.270	0.272
129	115	5,115.5	232	0.000	-13.7	117	1.97	2.17	2.37	1.000	0.850	0.000	0.013	0.780	4	0.000	0.000	0.000	0.000	0.780	0.248	0.259	0.268
130	116	5,116.5	234	0.000	-15.1	116	1.97	2.02	2.26	1.000	0.849	0.001	0.000	0.773	4	0.000	0.000	0.000	0.000	0.773	0.248	0.251	0.263
131	117	5,117.5	236	0.000	-16.1	112.7	1.97	2.34	2.56	0.973	0.839	0.011	0.000	0.751	4	0.000	0.000	0.000	0.000	0.751	0.248	0.267	0.277
132	118	5,118.5	238	0.000	-14.5	115.3	2.07	2.29	2.48	1.000	0.850	0.000	0.005	0.769	4	0.000	0.000	0.000	0.000	0.769	0.254	0.265	0.273
133	119	5,119.5	240	0.000	-14.1	115.3	2.02	2.07	2.22	1.000	0.850	0.000	0.009	0.769	4	0.000	0.000	0.000	0.000	0.769	0.251	0.254	0.261

Name	Refers To	Comment
LD_Base	Calc!$B$7
LD_Dec0	Calc!$B$8
LD_Depth	'Log Data'!$A$5:$A$5004
LD_First	Calc!$B$4
LD_GR	'Log Data'!$C$5:$C$5004
LD_GRB1	Inputs!$B$20
LD_GRB2	Inputs!$B$21
LD_GRB3	Inputs!$B$22
LD_GRB4	Inputs!$B$23
LD_GRClean	Inputs!$B$24
LD_GRMax	Inputs!$B$15
LD_GRMin	Inputs!$B$14
LD_GRShale	Inputs!$B$25
LD_Last	Calc!$B$5
LD_N	Calc!$B$3
LD_Null	Inputs!$B$8
LD_Problems	Inputs!$B$28
LD_RD	'Log Data'!$F$5:$F$5004
LD_RLog0	Calc!$B$9
LD_RM	'Log Data'!$E$5:$E$5004
LD_RMax	Inputs!$B$17
LD_RMin	Inputs!$B$16
LD_RS	'Log Data'!$D$5:$D$5004
LD_RSpan	Calc!$B$10
LD_SP	'Log Data'!$B$5:$B$5004
LD_SPBase	Inputs!$B$11
LD_SPMax	Inputs!$B$13
LD_SPMin	Inputs!$B$12
LD_Step	Inputs!$B$7
LD_Top	Calc!$B$6
LD_WellName	Inputs!$B$5
LD_WinTop	Inputs!$B$6

Opens in	Works in any Excel: formulas and named LAMBDAs only, no add-in needed.
File	LogDisplay.xlsx, 87 KB
Category	Petrophysics
For agents and tools	Structure (.json) · Descriptor (.md)

Tags:

well-loglog-displaylog-trackspetrophysicsgamma-rayspontaneous-potentialresistivityshale-volumelithologychart-tracks

Well-Log Display — Chart Tracks over a Depth Grid, Paste-In Curves

Inputs

More Petrophysics Workbooks

Capillary Pressure Models — Brooks-Corey, Van Genuchten, Leverett J