250912 12Sep25 session 25-37
Grit Bins and spreadsheet calcs for fullness, Watercourses, nodes and points, adding photos thereto
Video Timeline (min:secs) - very approximate!:
00:00 - 00:50 Banter
00:50 - 40:00 Grit Bins - and associated spreadsheet work and calcs
40:00 - 43:00 Banter
43:00 - 53:00 Watercourses, Nodes, and attaching photos
53:00 - 73:36(end) Banter (focus on phosphates)
Presentation:
No formal presentation this week
Chat:
01:10:23 Stuart Bacon: Excel formula for reporting details to Highways about fill level of grit bins.
=IF((($D2>=0)($D2<=19))=1,"EMPTY",IF((($D2>=20)($D2<=39))=1,"1/4",IF((($D2>=40)($D2<=59))=1,"1/2",IF((($D2>=60)($D2<=79))=1,"3/4",IF((($D2>=80)*($D2<=100))=1,"FULL","No Data")))))
Audio Transcript:
41 00:04:19.440 --> 00:04:21.989 chris edwards: And, I've got two questions.
42 00:04:21.990 --> 00:04:23.500 Graham Stoddart-Stones: Oh, splendid.
43 00:04:24.810 --> 00:04:35.440 Graham Stoddart-Stones: Well, let me just make apologies to you both from, Andrew Clegg, who said he might join us, but it all depends upon the manure, so I just left that with you today.
44 00:04:36.910 --> 00:04:38.210 Graham Stoddart-Stones: And.
45 00:04:38.210 --> 00:04:39.220 Stuart Bacon: finish my dinner!
46 00:04:39.390 --> 00:04:40.600 Graham Stoddart-Stones: Come again?
47 00:04:40.600 --> 00:04:40.929 Stuart Bacon: I will.
48 00:04:40.930 --> 00:04:44.840 Graham Stoddart-Stones: I'm glad I've just finished my dinner! Yeah, exactly, and
49 00:04:45.400 --> 00:04:55.799 Graham Stoddart-Stones: And, who's the other one? Richard is involved with the carnival again. It's carnival time, so he won't be with us today. John, I guess, is still in Brittany somewhere?
50 00:04:55.800 --> 00:04:56.370 chris edwards: Mmm.
51 00:04:56.370 --> 00:04:59.049 Graham Stoddart-Stones: And here we are.
52 00:04:59.480 --> 00:04:59.880 chris edwards: Oh my god.
53 00:04:59.880 --> 00:05:06.060 Graham Stoddart-Stones: I do expect Alistair to join in at some point, but… Anyway, so… And then…
54 00:05:06.650 --> 00:05:10.929 Graham Stoddart-Stones: No further delays, Chris. Let's roar ahead with your questions.
55 00:05:10.930 --> 00:05:13.820 chris edwards: Okay, so I'm gonna share my screen…
56 00:05:19.380 --> 00:05:21.409 chris edwards: Okay, the first one…
57 00:05:21.850 --> 00:05:29.730 chris edwards: is to do with, reporting the contents of our grip bins to Somerset Council.
58 00:05:29.920 --> 00:05:30.640 Graham Stoddart-Stones: Right?
59 00:05:30.790 --> 00:05:35.310 chris edwards: Now, over the last month,
60 00:05:35.650 --> 00:05:41.390 chris edwards: they have got a new icon showing grip booms, which I haven't seen before.
61 00:05:42.160 --> 00:05:47.400 chris edwards: And you'll see one is… has got a black surround, others are green.
62 00:05:47.490 --> 00:05:50.390 Graham Stoddart-Stones: And I think there's other colors as well.
63 00:05:50.520 --> 00:05:54.920 chris edwards: And I've learned that black means zero contents.
64 00:05:54.920 --> 00:05:55.270 Graham Stoddart-Stones: Yep.
65 00:05:55.400 --> 00:05:57.490 chris edwards: Green probably means full.
66 00:05:58.010 --> 00:05:58.610 Graham Stoddart-Stones: Yep.
67 00:05:59.050 --> 00:06:01.930 chris edwards: Right, let's get to the nub of this.
68 00:06:02.280 --> 00:06:08.490 chris edwards: I'm… I've reported the contents to Somerset Council, And…
69 00:06:08.960 --> 00:06:12.110 chris edwards: Is there a chance of me being able to
70 00:06:12.340 --> 00:06:17.899 chris edwards: Put, a reference number on each of these icons.
71 00:06:18.660 --> 00:06:21.950 chris edwards: I don't think I can do that, because we're in…
72 00:06:22.080 --> 00:06:26.010 chris edwards: Assets and maintenance, rather than a parish layer.
73 00:06:26.430 --> 00:06:36.150 Graham Stoddart-Stones: Well, you're able to change the data in an asset submission, so you may just want to reallocate one of the fields. If you click on any one of them to bring up the data.
74 00:06:39.480 --> 00:06:42.579 chris edwards: That one there… There's the data.
75 00:06:42.870 --> 00:06:45.100 Graham Stoddart-Stones: Right, so.
76 00:06:45.100 --> 00:06:46.550 Stuart Bacon: I would like to put…
77 00:06:46.550 --> 00:06:52.110 chris edwards: ANS03 on… on the map.
78 00:06:52.610 --> 00:06:55.049 Graham Stoddart-Stones: Oh, okay, so that's a label.
79 00:06:55.300 --> 00:06:57.109 chris edwards: Oh, yes, that's right.
80 00:06:57.110 --> 00:07:07.029 Graham Stoddart-Stones: Yeah, unfortunately, you can't style the asset mentioned there. It's really, really, really irritating. I've asked for it so many times. By all means, put in a ticket, Chris.
81 00:07:07.030 --> 00:07:10.700 Stuart Bacon: Yes, okay, I will, I will. Chris, if you stop sharing, Chris…
82 00:07:10.850 --> 00:07:11.630 chris edwards: Yep.
83 00:07:15.520 --> 00:07:18.949 Stuart Bacon: And can I… Where's it going?
84 00:07:21.460 --> 00:07:26.189 Graham Stoddart-Stones: Because you can always just copy the layer, Chris, into a parish layer, and then just put the labels on.
85 00:07:26.650 --> 00:07:28.460 chris edwards: Oh, right, I hadn't thought of that, thank you.
86 00:07:28.460 --> 00:07:35.729 Stuart Bacon: I had… a long discussion with Mr Muse,
87 00:07:35.860 --> 00:07:43.950 Stuart Bacon: A week or two ago, about a similar issue with, the bins within the,
88 00:07:43.950 --> 00:07:45.719 Graham Stoddart-Stones: assets and maintenance, right? Yeah.
89 00:07:45.720 --> 00:07:46.160 chris edwards: Yup.
90 00:07:46.160 --> 00:07:53.280 Stuart Bacon: And he's now put, more info on the… on the bins.
91 00:07:53.460 --> 00:07:59.960 Stuart Bacon: So they've now got labels to them, and you can sort of pull the detail through. So when you look at the legend.
92 00:07:59.960 --> 00:08:01.949 chris edwards: It gives a little bit more…
93 00:08:02.010 --> 00:08:06.310 Stuart Bacon: than just a, yeah.
94 00:08:06.470 --> 00:08:13.149 Graham Stoddart-Stones: Okay, so there's the amounts for Chris, so 100% is light green, and black is zero, so really, yes.
95 00:08:13.150 --> 00:08:13.780 chris edwards: Yep.
96 00:08:13.780 --> 00:08:23.140 Stuart Bacon: Yeah. So you might be able to get him to amend the numbering system, I don't know.
97 00:08:23.140 --> 00:08:24.560 Graham Stoddart-Stones: To be enabled.
98 00:08:24.560 --> 00:08:26.119 Stuart Bacon: To, to give you a label.
99 00:08:26.120 --> 00:08:27.160 chris edwards: Yeah, yeah, okay.
100 00:08:27.160 --> 00:08:34.020 Stuart Bacon: Or to give you a label, and keep the numbering system in the, yeah.
101 00:08:34.429 --> 00:08:39.450 Stuart Bacon: Keep the numbering system in the legend, but put a label on it that's the location.
102 00:08:40.090 --> 00:08:42.530 Stuart Bacon: As well, I'm not quite sure how that would work, but…
103 00:08:42.530 --> 00:08:49.379 chris edwards: Yes, okay, yep, right, I'll certainly get to grips with that later on. Stuart, before we say
104 00:08:49.950 --> 00:08:52.750 chris edwards: Goodbye to your… Map.
105 00:08:52.860 --> 00:08:54.800 chris edwards: Could you just go back?
106 00:08:55.170 --> 00:09:04.250 chris edwards: if you click off… click… yeah, now go into the cogwheel on bins, the bins layer,
107 00:09:07.850 --> 00:09:10.529 chris edwards: Right, I make use of table view.
108 00:09:10.920 --> 00:09:17.160 chris edwards: But where it says, yes, Yet, I've got something very similar to that.
109 00:09:17.570 --> 00:09:21.979 chris edwards: But go back one stage again, please, Stuart.
110 00:09:22.970 --> 00:09:29.050 chris edwards: cogwheel… Now, turn labels off. That's…
111 00:09:30.550 --> 00:09:32.500 chris edwards: And then turn it on again, please.
112 00:09:35.470 --> 00:09:41.530 chris edwards: Right, I don't think I've actually fiddled with that on my computer, so I'll… I'll try that one out.
113 00:09:41.790 --> 00:09:46.659 Graham Stoddart-Stones: I mean, he's only just done it, hasn't he? Because… it's only because of Chris, sorry, Stuart's…
114 00:09:46.660 --> 00:09:50.309 chris edwards: begging at the best of these labels there in the first place, so, yes.
115 00:09:50.310 --> 00:09:52.560 Stuart Bacon: He only launched that yesterday.
116 00:09:52.940 --> 00:09:54.050 chris edwards: Oh, fantastic!
117 00:09:54.050 --> 00:09:56.329 Graham Stoddart-Stones: Why are you so slow off the mark, Chris?
118 00:09:56.330 --> 00:09:58.980 chris edwards: Red hot. Haha, yes.
119 00:09:58.980 --> 00:09:59.520 Stuart Bacon: excuse me.
120 00:09:59.520 --> 00:10:00.320 chris edwards: Okay.
121 00:10:00.320 --> 00:10:05.909 Stuart Bacon: Yeah, so that one's only happened yesterday, so I just thought I'd bring that to your attention, that.
122 00:10:05.910 --> 00:10:06.490 Graham Stoddart-Stones: That's lovely.
123 00:10:06.490 --> 00:10:07.520 chris edwards: Thank you ever so much.
124 00:10:07.520 --> 00:10:09.000 Graham Stoddart-Stones: Well done. It's really cute.
125 00:10:09.000 --> 00:10:09.950 chris edwards: Yeah, yeah.
126 00:10:10.150 --> 00:10:12.170 Graham Stoddart-Stones: Doing things to the public good.
127 00:10:12.320 --> 00:10:16.059 chris edwards: Yeah, let me go back… oh, what's that?
128 00:10:18.210 --> 00:10:25.220 chris edwards: Right. Now, before we finish on… on that…
129 00:10:26.860 --> 00:10:31.170 chris edwards: Forgive me, forgive me, I'm just lost for a second.
130 00:10:31.760 --> 00:10:41.529 chris edwards: Excel… Right, this is something which I sent Somerset Camp
131 00:10:41.810 --> 00:10:47.809 chris edwards: Let's get rid of… this is what I sent to Somerset Council.
132 00:10:48.200 --> 00:10:51.059 chris edwards: This is, a list of our bins.
133 00:10:51.060 --> 00:10:51.680 Graham Stoddart-Stones: Yep.
134 00:10:52.450 --> 00:10:56.529 chris edwards: location. I mean, I did… I… I'm sorry that that's right.
135 00:10:56.530 --> 00:10:58.700 Stuart Bacon: the time when we put together the other week, isn't it?
136 00:10:58.700 --> 00:11:04.900 chris edwards: Yeah, that's it, that's it. I never even given the Eastings and Northings and so on.
137 00:11:05.170 --> 00:11:11.880 chris edwards: Now, it's a pity that Somerset Council want the contents in Imperial
138 00:11:12.080 --> 00:11:22.059 chris edwards: measurements, and Parish Online do it in metric measurements, 20%, 40%, 100%, but they don't allow…
139 00:11:22.060 --> 00:11:24.609 Stuart Bacon: You know, there's 1 tenth, 2 tenths, 3 tenths.
140 00:11:24.610 --> 00:11:34.200 chris edwards: What… what… I mean, it can't cater for 90%, which is a bit sad, but there we are.
141 00:11:34.470 --> 00:11:36.749 chris edwards: That's a bit of a beef of mine.
142 00:11:37.590 --> 00:11:40.729 Graham Stoddart-Stones: Yeah, but that's the limitation of the county system, isn't it?
143 00:11:40.730 --> 00:11:41.900 chris edwards: Yeah, yes.
144 00:11:41.900 --> 00:11:52.769 Stuart Bacon: When you say Somerset want it in Imperial, have they stated a particular style of Imperial, or just…
145 00:11:52.770 --> 00:11:56.110 chris edwards: Yeah, yes, quarter, half, three quarters full.
146 00:11:56.930 --> 00:11:57.930 chris edwards: That's it.
147 00:11:58.130 --> 00:11:59.400 chris edwards: Nothing else.
148 00:11:59.700 --> 00:12:03.480 Graham Stoddart-Stones: Right, so… I'm not quite sure I understand what your question is.
149 00:12:06.080 --> 00:12:20.199 chris edwards: Well, it's just a pity that one… I mean, you know, I'm not ticking off Parish Online, I'm not ticking off Somerset Council, but it's a pity that they've got no other options other than
150 00:12:21.470 --> 00:12:24.390 chris edwards: A quarter, half, three quarters full.
151 00:12:24.640 --> 00:12:27.230 chris edwards: It doesn't give you enough, sort of, leeway.
152 00:12:28.180 --> 00:12:32.169 Stuart Bacon: You can create a formula in your Excel spreadsheet to do that for you.
153 00:12:32.170 --> 00:12:39.660 Graham Stoddart-Stones: Exactly, that's what I was going to suggest, and I thought, Chris, since there's nobody else around, and you don't have any more questions, why don't we just go ahead and do that?
154 00:12:40.080 --> 00:12:40.600 chris edwards: Right.
155 00:12:40.600 --> 00:12:42.610 Graham Stoddart-Stones: Because it's going to be news to you, isn't it?
156 00:12:42.610 --> 00:12:43.600 chris edwards: Yeah, yeah, quite.
157 00:12:43.600 --> 00:12:46.390 Graham Stoddart-Stones: Yeah, so perhaps you're able to hand around.
158 00:12:46.390 --> 00:12:46.760 chris edwards: W.
159 00:12:46.760 --> 00:12:48.479 Graham Stoddart-Stones: over to Stuart, let him do it.
160 00:12:50.560 --> 00:12:53.560 chris edwards: Do you want to… do you want me to do it on my computer, or Stuart's.
161 00:12:53.560 --> 00:12:55.470 Stuart Bacon: We'll do it on your machine.
162 00:12:55.470 --> 00:12:57.120 Graham Stoddart-Stones: Yeah, on your Agreed.
163 00:12:58.440 --> 00:13:00.089 Stuart Bacon: I mean, I don't know whether they…
164 00:13:00.370 --> 00:13:07.240 Stuart Bacon: the details in Parish Online have changed since we downloaded it last week, but we can go with the spreadsheet you've got.
165 00:13:08.250 --> 00:13:11.010 chris edwards: So, let's… let's go to table view.
166 00:13:11.430 --> 00:13:14.960 chris edwards: If I put in our stuff…
167 00:13:23.720 --> 00:13:25.819 chris edwards: Yep. So those are bins.
168 00:13:26.860 --> 00:13:27.450 Stuart Bacon: Yep.
169 00:13:28.780 --> 00:13:34.400 chris edwards: And, I mean, you know, some of these are 95%, some are 90%,
170 00:13:36.210 --> 00:13:41.939 chris edwards: But, you know, I could only use what Parish Online give us.
171 00:13:42.580 --> 00:13:45.100 chris edwards: 20, 40, 60, 80, 100.
172 00:13:45.970 --> 00:13:46.480 Graham Stoddart-Stones: Yes.
173 00:13:47.140 --> 00:13:53.420 Stuart Bacon: So you'd have to keep… you'd have to keep the detail in Parish Online as Parish Online require it.
174 00:13:53.700 --> 00:13:58.269 Stuart Bacon: But then when you ex… when we export it, we can look at
175 00:13:58.380 --> 00:14:00.250 Stuart Bacon: What we can do to the spreadsheet.
176 00:14:00.630 --> 00:14:02.259 Graham Stoddart-Stones: An algorithm, yes.
177 00:14:04.630 --> 00:14:06.099 Graham Stoddart-Stones: So, could I suggest, Chris…
178 00:14:06.100 --> 00:14:06.949 Stuart Bacon: I tell you, yeah.
179 00:14:06.950 --> 00:14:07.470 Graham Stoddart-Stones: Yep.
180 00:14:16.710 --> 00:14:18.159 chris edwards: So, let me just…
181 00:14:18.630 --> 00:14:23.039 Stuart Bacon: If you make that full screen, and… Unused Expo… Exo.
182 00:14:23.500 --> 00:14:24.210 Stuart Bacon: Yep.
183 00:14:28.230 --> 00:14:32.350 chris edwards: Right, so I'm… I'm all yours. What do you want me to do?
184 00:14:32.350 --> 00:14:33.270 Stuart Bacon: Let's…
185 00:14:33.650 --> 00:14:37.129 Graham Stoddart-Stones: Can I just suggest you change some of those statuses just for today?
186 00:14:38.110 --> 00:14:38.600 Graham Stoddart-Stones: So…
187 00:14:38.600 --> 00:14:44.229 chris edwards: I mean, I did… I did… I did knock off, you know, lots and lots of them to get it down to…
188 00:14:44.390 --> 00:14:55.619 Graham Stoddart-Stones: No, I didn't mean that. I meant the status. So, instead of them all being 100% full, why don't you make some of them 80, or some of them 60, and some of them 0, and just give Stuart something to play with.
189 00:14:59.970 --> 00:15:00.800 Graham Stoddart-Stones: Yup.
190 00:15:00.900 --> 00:15:01.980 Graham Stoddart-Stones: That's nice.
191 00:15:02.120 --> 00:15:03.040 Graham Stoddart-Stones: Okay?
192 00:15:04.450 --> 00:15:05.660 chris edwards: Right, so there's just.
193 00:15:05.660 --> 00:15:07.510 Stuart Bacon: And can we make one of them 20?
194 00:15:08.260 --> 00:15:10.669 Graham Stoddart-Stones: Just for argument.
195 00:15:10.670 --> 00:15:12.020 chris edwards: sake, sorry.
196 00:15:12.020 --> 00:15:13.140 Graham Stoddart-Stones: Okay, go on.
197 00:15:14.140 --> 00:15:19.510 Stuart Bacon: Okay, so I'm gonna go in… cell C2,
198 00:15:24.840 --> 00:15:30.359 Stuart Bacon: equals… If… I'm gonna go with a nested if statement, I think.
199 00:15:32.330 --> 00:15:33.730 Stuart Bacon: Open bracket.
200 00:15:47.720 --> 00:15:49.009 Graham Stoddart-Stones: D2, less energy.
201 00:15:49.010 --> 00:15:55.379 Stuart Bacon: Yeah, yeah, sorry, I was just trying to think of any sensible way around doing it. If we go $D…
202 00:15:55.690 --> 00:15:56.720 Stuart Bacon: 2…
203 00:15:57.010 --> 00:15:59.130 chris edwards: What, what, D2?
204 00:15:59.370 --> 00:16:00.520 Stuart Bacon: toler sewing.
205 00:16:01.010 --> 00:16:02.880 Stuart Bacon: Which is.
206 00:16:02.880 --> 00:16:03.710 Graham Stoddart-Stones: shift 4.
207 00:16:03.710 --> 00:16:05.260 Stuart Bacon: or Shift and 4…
208 00:16:08.790 --> 00:16:10.856 Graham Stoddart-Stones: Not quite.
209 00:16:15.730 --> 00:16:17.159 Stuart Bacon: Now, Shift and 4.
210 00:16:20.620 --> 00:16:21.910 Graham Stoddart-Stones: Hey, good…
211 00:16:22.230 --> 00:16:31.660 Stuart Bacon: D2… Equals.
212 00:16:32.100 --> 00:16:33.270 chris edwards: Hang on, hang on.
213 00:16:35.310 --> 00:16:35.800 Stuart Bacon: Okay.
214 00:16:35.800 --> 00:16:37.440 chris edwards: I, I, oh, bugger.
215 00:16:40.120 --> 00:16:41.740 chris edwards: Oh, blast.
216 00:16:42.310 --> 00:16:43.960 Stuart Bacon: Minimize that when… yeah.
217 00:16:44.380 --> 00:16:46.760 Stuart Bacon: Minimise that window, Chris.
218 00:16:47.550 --> 00:16:51.760 Stuart Bacon: Get rid of it. Top right or… top right, and just minimize it. No, no, no, okay.
219 00:16:51.760 --> 00:16:52.090 chris edwards: Oh.
220 00:16:52.090 --> 00:16:53.949 Stuart Bacon: No, top right, very top right.
221 00:16:55.180 --> 00:17:00.589 Stuart Bacon: Yeah, and minimize that. Not the close, the two to the left. Next one. That one.
222 00:17:02.950 --> 00:17:03.910 Stuart Bacon: Okay.
223 00:17:05.710 --> 00:17:13.850 chris edwards: Right. I'm just… I'm just going to widen the… C, column, Why can't I do that?
224 00:17:14.390 --> 00:17:18.060 Stuart Bacon: You're now changing the formula and messing around with the formula, Chris.
225 00:17:18.060 --> 00:17:20.460 chris edwards: Okay, I trust you to give it more space, but I can't.
226 00:17:20.460 --> 00:17:20.859 Stuart Bacon: Right.
227 00:17:20.869 --> 00:17:21.499 chris edwards: count.
228 00:17:22.400 --> 00:17:25.969 Stuart Bacon: Yeah, you don't… we don't need to create any more space, it's fine.
229 00:17:26.130 --> 00:17:40.150 Stuart Bacon: Right. So you need to backspace and delete what we've got. So, open bracket, Dollar… D2… equals…
230 00:17:42.040 --> 00:17:47.870 Stuart Bacon: And then, in quotes, You want,
231 00:17:51.920 --> 00:17:52.890 Stuart Bacon: No.
232 00:17:53.830 --> 00:17:54.710 Stuart Bacon: Hang on.
233 00:17:55.690 --> 00:17:59.730 Stuart Bacon: Sorry, not in quotes, Equals,
234 00:18:01.490 --> 00:18:11.759 Stuart Bacon: less than 25%. So, what is that? That's full… shift and full… yeah, less than 25%.
235 00:18:12.140 --> 00:18:12.850 Stuart Bacon: Oh.
236 00:18:15.140 --> 00:18:19.790 Stuart Bacon: Comma.
237 00:18:24.080 --> 00:18:30.050 Stuart Bacon: And then you want… one quarter.
238 00:18:30.820 --> 00:18:35.040 Stuart Bacon: In, in brackets, you want to put that in?
239 00:18:36.040 --> 00:18:39.970 Stuart Bacon: Sorry, I'm not in brackets, sorry, in quotation marks. My fault. My…
240 00:18:39.970 --> 00:18:40.600 chris edwards: Right.
241 00:18:43.120 --> 00:18:43.990 Stuart Bacon: No.
242 00:18:44.710 --> 00:18:45.280 Graham Stoddart-Stones: Yes.
243 00:18:46.390 --> 00:18:47.960 Graham Stoddart-Stones: Just, just ignore it, you know.
244 00:18:47.960 --> 00:18:48.550 Stuart Bacon: Yeah.
245 00:18:50.940 --> 00:18:57.350 Stuart Bacon: What comes after the… So, backspace… Put a quotation mark in.
246 00:18:58.540 --> 00:19:03.719 Stuart Bacon: Now, after the 4, You put another quotation mark in.
247 00:19:04.140 --> 00:19:04.730 chris edwards: Yep.
248 00:19:05.240 --> 00:19:06.070 Stuart Bacon: Comma.
249 00:19:06.860 --> 00:19:08.850 chris edwards: Gosh!
250 00:19:09.520 --> 00:19:20.820 Stuart Bacon: Now, if… Open bracket, Dollar D2…
251 00:19:26.080 --> 00:19:28.150 chris edwards: Dollar, sorry, hang on, I haven't got the dollar.
252 00:19:28.570 --> 00:19:29.130 Stuart Bacon: Yep.
253 00:19:29.310 --> 00:19:30.540 chris edwards: Yep, yep.
254 00:19:32.070 --> 00:19:38.090 Stuart Bacon: equals… .
255 00:19:38.920 --> 00:19:40.190 Graham Stoddart-Stones: Less than 50.
256 00:19:40.190 --> 00:19:48.900 Stuart Bacon: well, it's got to be higher than 25 and less than 50, isn't it? So it's… 25…
257 00:19:49.620 --> 00:19:51.269 Stuart Bacon: Lower than 50.
258 00:19:55.290 --> 00:19:57.009 chris edwards: What's the next thing I've got to put?
259 00:19:57.010 --> 00:20:01.650 Stuart Bacon: So, 20… backspace… 25.
260 00:20:03.730 --> 00:20:12.320 Stuart Bacon: Oh, sorry, 10 sets of 26, let's make it easier on the calculation. Lower than… 50.
261 00:20:15.380 --> 00:20:17.140 Stuart Bacon: Percent?
262 00:20:20.810 --> 00:20:21.760 Stuart Bacon: comma.
263 00:20:22.960 --> 00:20:24.449 chris edwards: Oops, yep.
264 00:20:25.310 --> 00:20:28.110 Stuart Bacon: open your quotation.
265 00:20:29.910 --> 00:20:32.170 Stuart Bacon: and then half.
266 00:20:35.490 --> 00:20:36.830 Stuart Bacon: Close quotes.
267 00:20:39.130 --> 00:20:41.359 Stuart Bacon: Comma.
268 00:20:42.590 --> 00:20:43.480 chris edwards: Damn.
269 00:20:44.470 --> 00:20:50.089 Stuart Bacon: And then we go through this again, twice. So, let's…
270 00:20:51.770 --> 00:20:54.219 Stuart Bacon: Yeah, if you type that in again…
271 00:20:56.490 --> 00:20:59.729 Stuart Bacon: So the F, open brackets, D2…
272 00:21:01.060 --> 00:21:02.979 Graham Stoddart-Stones: Still on the same line. Yes.
273 00:21:03.260 --> 00:21:03.710 Graham Stoddart-Stones: Lightning.
274 00:21:03.710 --> 00:21:04.240 Stuart Bacon: Yep.
275 00:21:07.980 --> 00:21:11.109 Stuart Bacon: If D2… If the brackets, open the brackets…
276 00:21:12.450 --> 00:21:13.380 Graham Stoddart-Stones: Yeah.
277 00:21:13.460 --> 00:21:15.319 Stuart Bacon: Not a quotation, but…
278 00:21:16.120 --> 00:21:17.480 chris edwards: Oh yeah, got it, got it, got it.
279 00:21:17.480 --> 00:21:18.100 Stuart Bacon: Yep.
280 00:21:18.560 --> 00:21:20.120 Stuart Bacon: Dollar D2.
281 00:21:20.870 --> 00:21:23.010 Graham Stoddart-Stones: I think there's a space there you don't want.
282 00:21:23.850 --> 00:21:24.400 chris edwards: Okay.
283 00:21:29.260 --> 00:21:30.630 chris edwards: Yep, thank you.
284 00:21:31.200 --> 00:21:38.279 Stuart Bacon: equals… 51 lower than 75.
285 00:21:40.360 --> 00:21:42.750 chris edwards: Do the lower than before the 51.
286 00:21:42.750 --> 00:21:46.869 Stuart Bacon: 51… Lower than 75.
287 00:21:48.860 --> 00:21:49.910 Stuart Bacon: percent.
288 00:21:52.330 --> 00:21:54.580 Stuart Bacon: Hello, comma.
289 00:21:56.660 --> 00:22:00.770 Stuart Bacon: Open your quotation marks and 3 quarters.
290 00:22:03.460 --> 00:22:05.270 Stuart Bacon: Closure quotation.
291 00:22:10.030 --> 00:22:10.770 Graham Stoddart-Stones: Comma.
292 00:22:12.330 --> 00:22:13.130 Stuart Bacon: Como.
293 00:22:14.180 --> 00:22:15.680 Stuart Bacon: And then…
294 00:22:16.620 --> 00:22:17.839 Graham Stoddart-Stones: You can just say else.
295 00:22:17.840 --> 00:22:25.719 Stuart Bacon: And then, what, full. Or whatever they want for whatever the… open your quotation marks again.
296 00:22:26.740 --> 00:22:30.300 Stuart Bacon: And what do they want for… a full day.
297 00:22:31.500 --> 00:22:32.260 chris edwards: room.
298 00:22:32.690 --> 00:22:33.049 Graham Stoddart-Stones: I agree.
299 00:22:33.320 --> 00:22:34.430 chris edwards: He shouldn't go along.
300 00:22:35.090 --> 00:22:35.740 Stuart Bacon: Sorry?
301 00:22:37.760 --> 00:22:40.950 Stuart Bacon: Yep, and close quotation marks, close bracket.
302 00:22:41.650 --> 00:22:43.489 Stuart Bacon: 3 times.
303 00:22:46.220 --> 00:22:47.779 Stuart Bacon: And press enter.
304 00:22:48.030 --> 00:22:53.029 Graham Stoddart-Stones: Mmm, hang on a minute, I think you're gonna need to put percent behind all the numbers.
305 00:22:53.630 --> 00:22:56.490 Graham Stoddart-Stones: So, behind 51 and behind 26.
306 00:22:59.040 --> 00:23:00.470 Stuart Bacon: Oh, yes, sorry, yeah.
307 00:23:01.010 --> 00:23:05.950 chris edwards: When you say behind, do you mean after the one at 51? Yes, exactly, yes.
308 00:23:07.350 --> 00:23:11.509 Graham Stoddart-Stones: So, straightforward percent sign, yeah. And again, for the 26.
309 00:23:11.510 --> 00:23:13.160 Stuart Bacon: 26%, yeah.
310 00:23:15.270 --> 00:23:16.350 Graham Stoddart-Stones: And…
311 00:23:20.650 --> 00:23:21.490 Stuart Bacon: I think that's it.
312 00:23:21.490 --> 00:23:24.220 Graham Stoddart-Stones: I think you've got the wrong number of brackets. You've got…
313 00:23:24.630 --> 00:23:26.920 Graham Stoddart-Stones: No, no, 3 open, 3 full, okay.
314 00:23:27.120 --> 00:23:30.119 Graham Stoddart-Stones: Alright, Matt, that's closed. Alright, fair enough, try that.
315 00:23:30.560 --> 00:23:31.400 chris edwards: So, answer?
316 00:23:32.180 --> 00:23:32.890 Stuart Bacon: Yep.
317 00:23:34.710 --> 00:23:36.830 Stuart Bacon: Okay, question, take, take yes.
318 00:23:39.390 --> 00:23:46.910 Stuart Bacon: and then copy that formula that's in C2, Yep.
319 00:23:47.610 --> 00:23:49.020 Graham Stoddart-Stones: Well…
320 00:23:49.510 --> 00:23:55.020 Stuart Bacon: Okay, now, select all the cells from C2 down to C12.
321 00:23:57.230 --> 00:23:59.500 Stuart Bacon: No, C2, C1.
322 00:23:59.500 --> 00:24:00.520 Graham Stoddart-Stones: C3.
323 00:24:02.280 --> 00:24:03.170 Graham Stoddart-Stones: Alright.
324 00:24:05.600 --> 00:24:07.779 Stuart Bacon: And press Ctrl and D.
325 00:24:09.380 --> 00:24:10.340 Graham Stoddart-Stones: or paste.
326 00:24:12.650 --> 00:24:13.759 chris edwards: Would you…
327 00:24:16.910 --> 00:24:18.920 Stuart Bacon: Well, the way you do it, Chris, is…
328 00:24:19.240 --> 00:24:21.700 Stuart Bacon: No. No, you've just lost it, Chris.
329 00:24:22.070 --> 00:24:23.130 chris edwards: Oh, booger.
330 00:24:23.300 --> 00:24:26.899 Graham Stoddart-Stones: Would I make another suggestion? If you escape out of that.
331 00:24:28.990 --> 00:24:34.339 Graham Stoddart-Stones: Just press the escape button, yeah. Now, highlight, or click on C2.
332 00:24:35.290 --> 00:24:35.910 chris edwards: Oh.
333 00:24:37.350 --> 00:24:38.800 Graham Stoddart-Stones: C2, yep.
334 00:24:39.080 --> 00:24:41.060 Graham Stoddart-Stones: Just click.
335 00:24:41.060 --> 00:24:44.740 Stuart Bacon: Press enter, press, yeah, press enter, press enter.
336 00:24:47.820 --> 00:24:56.589 Graham Stoddart-Stones: Right, click on the full word in C2, and now pick out the little bottom square of that bracket and just pull it down. There you go.
337 00:24:58.480 --> 00:25:00.219 Graham Stoddart-Stones: Well, it's almost there.
338 00:25:00.960 --> 00:25:03.529 Graham Stoddart-Stones: That is perfect.
339 00:25:03.870 --> 00:25:04.769 Graham Stoddart-Stones: That she's notable.
340 00:25:04.770 --> 00:25:05.530 chris edwards: I… yeah.
341 00:25:05.530 --> 00:25:08.920 Stuart Bacon: This is a quarter, so C3 is not right.
342 00:25:09.590 --> 00:25:13.040 Stuart Bacon: And it's C3 and, and C7.
343 00:25:13.040 --> 00:25:13.360 chris edwards: Yeah.
344 00:25:13.360 --> 00:25:16.500 Graham Stoddart-Stones: So let's look at the formula again in each one of those.
345 00:25:16.810 --> 00:25:18.250 chris edwards: So, there's the formula.
346 00:25:18.250 --> 00:25:21.959 Graham Stoddart-Stones: Well, go into C3 for the formula.
347 00:25:23.770 --> 00:25:25.230 Stuart Bacon: Let's just see…
348 00:25:33.540 --> 00:25:34.940 Graham Stoddart-Stones: Oh, okay.
349 00:25:35.050 --> 00:25:38.640 Graham Stoddart-Stones: What you said… is that…
350 00:25:42.540 --> 00:25:45.849 Graham Stoddart-Stones: So C3 should be 3 quarters, right?
351 00:25:48.270 --> 00:25:49.500 Stuart Bacon: Yes.
352 00:25:54.260 --> 00:25:57.249 chris edwards: Well, that would be 75%, wouldn't it?
353 00:25:59.970 --> 00:26:04.110 Graham Stoddart-Stones: Well, but it is 60, so that's going to be… it's between 50 and 3…
354 00:26:04.110 --> 00:26:05.000 chris edwards: Oh, I see, I beg your pony.
355 00:26:05.000 --> 00:26:05.650 Graham Stoddart-Stones: 75.
356 00:26:05.650 --> 00:26:07.610 Stuart Bacon: Yeah, it's in that range, isn't it?
357 00:26:08.110 --> 00:26:13.999 Graham Stoddart-Stones: So I'm not sure why it says full, whether it's working perfectly for C11, for instance.
358 00:26:17.330 --> 00:26:25.789 Graham Stoddart-Stones: Oh, you said less than or equal to 25%. Okay, then you've got equals 26 to 50, and what did they come up with?
359 00:26:27.480 --> 00:26:31.420 Graham Stoddart-Stones: If you go, just escape out of where you are, Chris.
360 00:26:33.370 --> 00:26:34.250 Graham Stoddart-Stones: Oh…
361 00:26:36.170 --> 00:26:38.100 chris edwards: Press the escape button now.
362 00:26:38.100 --> 00:26:43.250 Graham Stoddart-Stones: No, well, I just… looking at, C3, saying full.
363 00:26:44.940 --> 00:26:50.219 Graham Stoddart-Stones: It's as if it's ignored the first… the second if statement, doesn't it?
364 00:26:50.430 --> 00:26:57.630 Stuart Bacon: Yeah, it's not picked up the range, it's… It's… it's going with… single figure.
365 00:27:05.790 --> 00:27:11.110 Graham Stoddart-Stones: If we… since we know that it's always going to be either
366 00:27:11.350 --> 00:27:15.730 Graham Stoddart-Stones: 20, 30, sorry, 20, 40, 60, or 80, you could just assume that.
367 00:27:16.890 --> 00:27:23.109 Graham Stoddart-Stones: Because… The numbers are determined by Persian Line?
368 00:27:24.540 --> 00:27:28.349 Graham Stoddart-Stones: And when you fill in the data for the bins, Chris.
369 00:27:29.110 --> 00:27:32.999 Graham Stoddart-Stones: They asked you to select from a drop-down list, do they?
370 00:27:33.310 --> 00:27:37.720 chris edwards: No, you simply put in quarter, half, three quarters, and so on.
371 00:27:38.050 --> 00:27:39.570 Stuart Bacon: No, on personal, not unusual.
372 00:27:39.570 --> 00:27:41.570 Graham Stoddart-Stones: No, no, no, I think that's not right.
373 00:27:42.150 --> 00:27:44.020 Graham Stoddart-Stones: Other way round, Chris, surely.
374 00:27:44.870 --> 00:27:52.660 chris edwards: So, Somerset Council deal in Imperial, Parish Online deal in percentages 20, 40, 60, 80.
375 00:27:52.660 --> 00:27:58.139 Graham Stoddart-Stones: Yes, but how do they ask you to fill in that number? Do they give you a drop-down list?
376 00:27:58.700 --> 00:28:01.420 chris edwards: Yes. Parish Online, yes.
377 00:28:01.420 --> 00:28:08.130 Graham Stoddart-Stones: Yeah, so… If the answer in D is always going to be a multiple of 20,
378 00:28:09.010 --> 00:28:11.430 Graham Stoddart-Stones: Then we can adjust the… make the…
379 00:28:11.430 --> 00:28:13.929 Stuart Bacon: Yeah, well, it would adjust the formula and go with it that way.
380 00:28:13.930 --> 00:28:15.149 Graham Stoddart-Stones: Yeah, that's what I mean.
381 00:28:19.880 --> 00:28:28.390 Stuart Bacon: Okay, so, Chris, go back up to see… 2…
382 00:28:28.560 --> 00:28:32.330 Stuart Bacon: And… click in the formula bar at the top.
383 00:28:34.540 --> 00:28:38.099 Stuart Bacon: And move across to after the first D2.
384 00:28:38.100 --> 00:28:38.780 Graham Stoddart-Stones: Yep.
385 00:28:43.370 --> 00:28:45.589 Stuart Bacon: Yep. Delete the less than.
386 00:28:47.320 --> 00:28:49.870 Graham Stoddart-Stones: Well, hmm, okay.
387 00:28:50.720 --> 00:28:59.290 Stuart Bacon: And if that, equals… Type, type in, equals zero.
388 00:29:00.780 --> 00:29:01.810 Stuart Bacon: Percent?
389 00:29:05.210 --> 00:29:08.790 Stuart Bacon: Oh, and I wasn't wanting you to delete the 25, but okay.
390 00:29:09.120 --> 00:29:11.400 Stuart Bacon: Sorry, I was just… yeah, keep…
391 00:29:13.110 --> 00:29:14.390 Graham Stoddart-Stones: Go to the left of that.
392 00:29:14.390 --> 00:29:15.679 Stuart Bacon: Go to the left of that.
393 00:29:16.410 --> 00:29:17.609 Graham Stoddart-Stones: And say zero.
394 00:29:18.870 --> 00:29:19.780 Graham Stoddart-Stones: percent.
395 00:29:21.570 --> 00:29:22.500 Graham Stoddart-Stones: Comma.
396 00:29:24.940 --> 00:29:26.450 Graham Stoddart-Stones: Quote, empty.
397 00:29:32.580 --> 00:29:35.080 Stuart Bacon: I'd put empty in capital letters, Chris.
398 00:29:41.660 --> 00:29:43.110 Graham Stoddart-Stones: Close quotes, comma.
399 00:29:45.960 --> 00:29:47.220 chris edwards: Yup.
400 00:29:49.730 --> 00:29:54.470 Graham Stoddart-Stones: If… Dollar D2?
401 00:29:57.930 --> 00:29:59.669 chris edwards: Hang on. Yep.
402 00:29:59.970 --> 00:30:02.830 Stuart Bacon: Sorry, before the dollar, you need to open the bracket.
403 00:30:02.830 --> 00:30:03.460 Graham Stoddart-Stones: Yep.
404 00:30:09.170 --> 00:30:10.699 Graham Stoddart-Stones: Equals 20%.
405 00:30:17.180 --> 00:30:18.959 Stuart Bacon: So, delete the 25 there, yep.
406 00:30:19.510 --> 00:30:20.150 chris edwards: Oh.
407 00:30:20.550 --> 00:30:23.469 Stuart Bacon: Yeah, no, no, that's fine, you've got… that's fine now.
408 00:30:25.050 --> 00:30:30.879 Stuart Bacon: That's… that's a quarter, that's great. Now move across to your next one, your next if statement.
409 00:30:32.060 --> 00:30:34.850 Graham Stoddart-Stones: 8 of 26 to 40.
410 00:30:40.120 --> 00:30:41.489 Graham Stoddart-Stones: Comma, half.
411 00:30:43.210 --> 00:30:43.760 chris edwards: Comma R.
412 00:30:43.760 --> 00:30:47.750 Graham Stoddart-Stones: Well, you would take out the less than 50%, that's all you need to do.
413 00:30:51.500 --> 00:30:52.270 Graham Stoddart-Stones: Yep.
414 00:30:52.980 --> 00:30:55.529 Graham Stoddart-Stones: That's good. So, moving along to the next one.
415 00:30:55.660 --> 00:30:58.269 Graham Stoddart-Stones: If $D2 equals 60,
416 00:31:02.560 --> 00:31:03.630 Graham Stoddart-Stones: I rose every…
417 00:31:03.630 --> 00:31:05.200 Stuart Bacon: But they're less than 75.
418 00:31:05.200 --> 00:31:05.770 Graham Stoddart-Stones: Yep.
419 00:31:08.450 --> 00:31:12.300 Stuart Bacon: And I would just suggest you can either go for half… I would do that as half as well.
420 00:31:12.300 --> 00:31:17.000 Graham Stoddart-Stones: I'd say it's half, so comma, open quotes, half, close quotes.
421 00:31:17.570 --> 00:31:18.979 Stuart Bacon: No, no, go back, Chris.
422 00:31:18.980 --> 00:31:21.669 Graham Stoddart-Stones: Don't change that, just add it extra.
423 00:31:22.160 --> 00:31:25.129 Graham Stoddart-Stones: So after the comma, open another set of quotes.
424 00:31:25.530 --> 00:31:27.949 Graham Stoddart-Stones: And change that to 3 quarters, by the way.
425 00:31:28.080 --> 00:31:29.790 Graham Stoddart-Stones: Go back to putting 3 there.
426 00:31:30.120 --> 00:31:31.809 Graham Stoddart-Stones: Alright, go to the left.
427 00:31:33.800 --> 00:31:35.539 Graham Stoddart-Stones: Open quotes.
428 00:31:36.470 --> 00:31:38.260 chris edwards: I know, anyway. I've got quotes.
429 00:31:38.260 --> 00:31:41.960 Graham Stoddart-Stones: Open quotes again, Chris, just open another quote.
430 00:31:42.700 --> 00:31:43.940 Graham Stoddart-Stones: put in half.
431 00:31:48.280 --> 00:31:50.910 Graham Stoddart-Stones: Close codes, comma.
432 00:31:53.480 --> 00:31:54.610 Graham Stoddart-Stones: And then…
433 00:31:54.610 --> 00:31:55.020 Stuart Bacon: If…
434 00:31:55.020 --> 00:31:55.880 Graham Stoddart-Stones: your F.
435 00:31:58.490 --> 00:31:59.890 Graham Stoddart-Stones: Open brackets.
436 00:32:01.310 --> 00:32:02.700 Graham Stoddart-Stones: Dollar D2.
437 00:32:07.000 --> 00:32:08.560 Graham Stoddart-Stones: Equals 80%.
438 00:32:14.280 --> 00:32:14.960 Stuart Bacon: Comma.
439 00:32:14.960 --> 00:32:16.580 Graham Stoddart-Stones: Comma, 3 quarters.
440 00:32:17.360 --> 00:32:17.910 chris edwards: Yup.
441 00:32:18.180 --> 00:32:19.289 Graham Stoddart-Stones: Leave it full.
442 00:32:19.630 --> 00:32:27.000 Stuart Bacon: And then your brackets on the end there, 1, 2… 3, 4, 5…
443 00:32:27.000 --> 00:32:27.410 Graham Stoddart-Stones: Hi.
444 00:32:27.410 --> 00:32:30.139 Stuart Bacon: Yeah, two more on. Yeah, two more close brackets.
445 00:32:30.880 --> 00:32:31.320 Graham Stoddart-Stones: Good.
446 00:32:31.560 --> 00:32:32.630 Stuart Bacon: Press Enter.
447 00:32:33.100 --> 00:32:33.760 chris edwards: Right.
448 00:32:35.570 --> 00:32:40.750 Graham Stoddart-Stones: Right, and then copy that, go to C2, and copy it down to the other ones.
449 00:32:44.660 --> 00:32:45.390 Graham Stoddart-Stones: Good.
450 00:32:47.360 --> 00:32:48.170 Graham Stoddart-Stones: That's special.
451 00:32:48.170 --> 00:32:48.790 Stuart Bacon: hydrant.
452 00:32:48.790 --> 00:32:50.140 Graham Stoddart-Stones: Yeah, well done.
453 00:32:53.250 --> 00:32:57.460 chris edwards: Now, my only query is half… Half…
454 00:32:58.320 --> 00:33:02.760 chris edwards: And yet, that's 60… half 60%, half 40%,
455 00:33:02.980 --> 00:33:06.850 chris edwards: 3 quart… yeah, I suppose it's… it's… it's nigh on the same.
456 00:33:07.390 --> 00:33:08.150 chris edwards: No.
457 00:33:08.720 --> 00:33:09.370 Stuart Bacon: Yeah.
458 00:33:09.860 --> 00:33:15.770 chris edwards: Yeah, that's terrific. I mean, I haven't… I won't be able to remember any of that, but at least
459 00:33:15.900 --> 00:33:18.780 chris edwards: I'll, I'll make use of the.
460 00:33:19.740 --> 00:33:20.390 Graham Stoddart-Stones: We'll just keep…
461 00:33:20.390 --> 00:33:20.750 chris edwards: Nice.
462 00:33:20.750 --> 00:33:25.369 Graham Stoddart-Stones: Create the spreadsheet, and then you can just… you'll always be able to copy that algorithm.
463 00:33:25.520 --> 00:33:26.870 chris edwards: Yeah, fantastic.
464 00:33:27.450 --> 00:33:30.749 chris edwards: Oh, thanks very much, chaps. That's really good.
465 00:33:31.040 --> 00:33:32.410 Graham Stoddart-Stones: I usually wait…
466 00:33:32.410 --> 00:33:38.589 Stuart Bacon: Just copy that across, and then use that in any other spreadsheet you download when… if you download different data in the future.
467 00:33:39.010 --> 00:33:39.980 chris edwards: Los Mobile's.
468 00:33:40.280 --> 00:33:41.220 chris edwards: Terrific.
469 00:33:42.370 --> 00:33:45.779 chris edwards: Now, what do I do to get out of what we're looking at on screen?
470 00:33:45.780 --> 00:33:48.320 Stuart Bacon: Anything I need to do is save what you've done, Chris.
471 00:33:48.800 --> 00:33:50.829 Stuart Bacon: Before we go any further.
472 00:33:50.850 --> 00:33:51.620 Graham Stoddart-Stones: Nice.
473 00:33:56.830 --> 00:33:58.120 chris edwards: Normally.
474 00:33:58.120 --> 00:33:59.239 Stuart Bacon: Where is it saved in?
475 00:33:59.240 --> 00:34:01.020 chris edwards: Normally, I go into info.
476 00:34:03.150 --> 00:34:04.410 Graham Stoddart-Stones: Alright.
477 00:34:04.410 --> 00:34:06.589 Stuart Bacon: I did on site, file save as, but yeah.
478 00:34:06.590 --> 00:34:07.310 chris edwards: load.
479 00:34:10.520 --> 00:34:11.800 chris edwards: OneDrive.
480 00:34:16.560 --> 00:34:17.400 Graham Stoddart-Stones: Okay.
481 00:34:18.010 --> 00:34:24.279 chris edwards: Now, what… would you… can I reword that? Because it's a huge…
482 00:34:24.280 --> 00:34:27.840 Stuart Bacon: We'll save ours and saved it that way to get it where you want it.
483 00:34:32.300 --> 00:34:34.860 Stuart Bacon: But you've got to save a copy now, yeah.
484 00:34:36.780 --> 00:34:42.850 Graham Stoddart-Stones: I would stick with the way you're used to doing it, Chris, if that's… but I have a suggestion for you.
485 00:34:42.850 --> 00:34:43.690 chris edwards: Go then.
486 00:34:43.699 --> 00:34:50.609 Graham Stoddart-Stones: So just, the one thing that is presumably a constant in your life is that you always have a contact.
487 00:34:52.159 --> 00:34:53.759 chris edwards: Yes?
488 00:34:53.760 --> 00:34:56.969 Graham Stoddart-Stones: So, if you take a copy of the formula.
489 00:34:57.120 --> 00:35:00.450 Graham Stoddart-Stones: Go back into the spreadsheet and copy C2.
490 00:35:02.750 --> 00:35:04.370 chris edwards: Should I do that right now?
491 00:35:04.370 --> 00:35:05.540 Graham Stoddart-Stones: Yeah, sure.
492 00:35:09.420 --> 00:35:14.419 Graham Stoddart-Stones: So, go ahead, copy, do a Ctrl-C, or copy, whichever you like, yeah, copy.
493 00:35:14.930 --> 00:35:17.000 Graham Stoddart-Stones: Now go into your contacts.
494 00:35:20.430 --> 00:35:25.999 Graham Stoddart-Stones: Somewhere in… down in Outlook, your Outlook column, is that right?
495 00:35:26.660 --> 00:35:27.810 Graham Stoddart-Stones: Is it what you lose?
496 00:35:27.810 --> 00:35:31.819 Stuart Bacon: Down at the bottom, you've got Outlook open, under H.
497 00:35:32.380 --> 00:35:33.580 Stuart Bacon: Column H.
498 00:35:35.600 --> 00:35:39.279 Stuart Bacon: Hollow that down, and Outlook is right on your taskbar at the bottom.
499 00:35:40.480 --> 00:35:41.970 Graham Stoddart-Stones: Go into Outlook, Chris.
500 00:35:42.960 --> 00:35:45.830 Graham Stoddart-Stones: Keep going down, go straight down, go down, go down, go down.
501 00:35:46.850 --> 00:35:49.000 Stuart Bacon: Stop scrolling down, Chris, move your mouse down.
502 00:35:49.300 --> 00:35:53.460 Graham Stoddart-Stones: Yeah, move it… move the whole mouse down to the next thing down below the spreadsheet.
503 00:35:54.210 --> 00:35:57.280 chris edwards: Well, I'm afraid…
504 00:36:00.900 --> 00:36:03.050 chris edwards: I can't go down to the taskbar.
505 00:36:03.420 --> 00:36:05.879 chris edwards: Which is not visible on my…
506 00:36:06.240 --> 00:36:08.420 Graham Stoddart-Stones: Oh, I see. Well, close your sharing, then.
507 00:36:14.920 --> 00:36:20.510 Graham Stoddart-Stones: Good, so now you can go into Outlook, And open up your contacts.
508 00:36:25.090 --> 00:36:25.960 chris edwards: This one.
509 00:36:25.960 --> 00:36:27.990 Graham Stoddart-Stones: Oh, what, yeah, whatever, I can't see your screen now.
510 00:36:27.990 --> 00:36:29.330 Stuart Bacon: Oh, yeah.
511 00:36:30.120 --> 00:36:33.290 Graham Stoddart-Stones: But if you just open your contacts and create a new contact.
512 00:36:43.600 --> 00:36:45.030 chris edwards: Hydro,
513 00:36:48.180 --> 00:36:50.730 chris edwards: Shall I press on… click on that?
514 00:36:51.110 --> 00:36:53.020 Graham Stoddart-Stones: Well, we can't see what you're looking at.
515 00:36:53.020 --> 00:36:54.010 chris edwards: Right.
516 00:36:54.010 --> 00:36:54.490 Graham Stoddart-Stones: Yes.
517 00:36:54.880 --> 00:36:57.709 Graham Stoddart-Stones: Share your screen again, now that you're in Outlook.
518 00:36:58.500 --> 00:36:59.569 chris edwards: I can't.
519 00:36:59.780 --> 00:37:01.200 chris edwards: Unfortunately.
520 00:37:01.570 --> 00:37:02.350 Graham Stoddart-Stones: Really?
521 00:37:02.540 --> 00:37:03.729 chris edwards: No, I can't.
522 00:37:04.980 --> 00:37:07.099 Graham Stoddart-Stones: So I'll have to come out of Outlook.
523 00:37:07.380 --> 00:37:09.319 Graham Stoddart-Stones: Yeah, it's going to Zoom.
524 00:37:12.540 --> 00:37:16.670 Graham Stoddart-Stones: Oh, I know why, Chris. When you go into your Zoom screen.
525 00:37:23.230 --> 00:37:24.860 Graham Stoddart-Stones: Do you know Alt-Tab?
526 00:37:25.560 --> 00:37:27.910 Graham Stoddart-Stones: If you press Alt-Tab on your keyboard.
527 00:37:34.150 --> 00:37:36.639 Graham Stoddart-Stones: And then, does it show the Zoom screen to you?
528 00:37:38.900 --> 00:37:39.640 chris edwards: No.
529 00:37:39.640 --> 00:37:40.570 Graham Stoddart-Stones: You good.
530 00:37:41.620 --> 00:37:46.179 Graham Stoddart-Stones: Well, you're still in Zoom, so it's… you've got a window called Zoom Open.
531 00:37:47.040 --> 00:37:47.840 chris edwards: Lime.
532 00:37:50.750 --> 00:37:53.160 Graham Stoddart-Stones: Are you, are you in your browser?
533 00:37:53.860 --> 00:37:54.710 chris edwards: No.
534 00:37:55.610 --> 00:37:57.360 Graham Stoddart-Stones: Well, can you move to your browser?
535 00:38:05.110 --> 00:38:07.780 Graham Stoddart-Stones: We'll have asked the question another way, what are you in?
536 00:38:08.670 --> 00:38:19.020 chris edwards: Well, I… I've… I've got my, microsoft Excel… spreadsheet.
537 00:38:19.830 --> 00:38:26.420 chris edwards: with… with, the, C column.
538 00:38:26.600 --> 00:38:31.789 chris edwards: where we've been working for the last 25 minutes. That's what I'm looking at at the moment.
539 00:38:32.590 --> 00:38:34.889 Graham Stoddart-Stones: But that's the only window I've got open.
540 00:38:35.190 --> 00:38:37.699 Graham Stoddart-Stones: Right, so if you go,
541 00:38:39.030 --> 00:38:42.150 Graham Stoddart-Stones: You must have a browser open, because you're still in Zoom.
542 00:38:46.090 --> 00:38:56.100 Stuart Bacon: Chris, click on… Your… Windows… K on the.
543 00:38:56.100 --> 00:38:57.049 chris edwards: Yeah, yeah, yeah.
544 00:38:57.050 --> 00:39:02.849 Stuart Bacon: On the screen, and go into your apps, and choose Quick Assist.
545 00:39:03.950 --> 00:39:04.620 chris edwards: Love it.
546 00:39:06.790 --> 00:39:11.050 chris edwards: Right, I'm in… I'm in the apps. Let me see…
547 00:39:11.050 --> 00:39:12.519 Stuart Bacon: Scroll down to Q.
548 00:39:19.160 --> 00:39:21.209 chris edwards: Right, I'm almost there.
549 00:39:22.590 --> 00:39:25.300 chris edwards: Yeah, click on Assist, Quick Assist.
550 00:39:26.380 --> 00:39:28.870 chris edwards: So… right.
551 00:39:30.160 --> 00:39:39.970 Stuart Bacon: Yep. Now, it asks you to put in a code, type in E… 3… 0…
552 00:39:43.200 --> 00:39:45.099 chris edwards: Capital E, or…
553 00:39:45.100 --> 00:39:49.100 Stuart Bacon: Yeah, capital letters, E, 3-0.
554 00:39:49.100 --> 00:39:49.560 chris edwards: Yep.
555 00:39:49.560 --> 00:39:51.460 Stuart Bacon: EK5.
556 00:39:53.980 --> 00:39:55.920 chris edwards: Okay. Submit.
557 00:39:56.240 --> 00:39:56.800 Stuart Bacon: Yep.
558 00:39:58.830 --> 00:40:01.230 Stuart Bacon: Sorry, Graham, that she's leaving you out of the…
559 00:40:01.230 --> 00:40:04.859 Graham Stoddart-Stones: That's right, you're talking windows, which I don't understand, so…
560 00:40:04.860 --> 00:40:11.730 chris edwards: I have a block. I leave anything to do with those out of my lifetime.
561 00:40:12.440 --> 00:40:15.420 Graham Stoddart-Stones: I'm gonna live a lot longer than you guys.
562 00:40:15.420 --> 00:40:17.699 chris edwards: Allow screen sharing.
563 00:40:18.070 --> 00:40:18.610 Stuart Bacon: Yep.
564 00:40:20.250 --> 00:40:21.270 chris edwards: I don't know.
565 00:40:24.050 --> 00:40:28.270 Graham Stoddart-Stones: Oh, right, you're gonna hand over control to… Stuart?
566 00:40:28.600 --> 00:40:29.340 chris edwards: Right.
567 00:40:29.670 --> 00:40:31.960 Stuart Bacon: So, screen sharing is on.
568 00:40:33.580 --> 00:40:34.130 Stuart Bacon: Yep.
569 00:40:34.420 --> 00:40:38.879 Stuart Bacon: So now I can see your screen.
570 00:40:38.880 --> 00:40:39.310 chris edwards: Okay.
571 00:40:39.310 --> 00:40:46.830 Stuart Bacon: So… You've got the copy of, cell C2.
572 00:40:47.140 --> 00:40:48.409 chris edwards: Yes, .
573 00:40:48.410 --> 00:40:49.389 Graham Stoddart-Stones: It's on your clipboard.
574 00:40:49.390 --> 00:40:50.650 chris edwards: On my clipboard, yep.
575 00:40:50.650 --> 00:40:55.350 Stuart Bacon: Yep. So now if you go down to Outlook, Damn?
576 00:40:55.630 --> 00:40:57.010 Stuart Bacon: Make your match, Dan.
577 00:40:57.210 --> 00:41:00.169 chris edwards: No, no, I can't, I simply cannot.
578 00:41:00.400 --> 00:41:01.720 chris edwards: go down to Outlander.
579 00:41:01.720 --> 00:41:03.490 Stuart Bacon: Move your mouse down.
580 00:41:04.060 --> 00:41:06.909 Stuart Bacon: And go left, slightly, there, click.
581 00:41:07.080 --> 00:41:07.720 chris edwards: Yeah.
582 00:41:11.250 --> 00:41:18.470 Stuart Bacon: Right, so on the left-hand side, there are a picture of two… People. Yep, click on that.
583 00:41:20.160 --> 00:41:20.760 chris edwards: Got it.
584 00:41:20.760 --> 00:41:23.409 Stuart Bacon: And then, in the top left, it says New Contact.
585 00:41:25.870 --> 00:41:27.400 Stuart Bacon: Yep, that one.
586 00:41:30.090 --> 00:41:33.550 Graham Stoddart-Stones: And I would just suggest you call it grip bin formula, something like that.
587 00:41:33.550 --> 00:41:34.190 Stuart Bacon: Yeah.
588 00:41:34.500 --> 00:41:37.090 Stuart Bacon: First name Gripman, surname Formula.
589 00:41:42.650 --> 00:41:45.079 Stuart Bacon: No, no, surname formula, Chris.
590 00:41:50.920 --> 00:41:54.629 Graham Stoddart-Stones: Is Microsoft fussy about that? Insist on one and the other?
591 00:41:54.960 --> 00:41:59.559 Stuart Bacon: Well, it makes it easier to find than if you've got, that, and…
592 00:41:59.560 --> 00:42:00.970 chris edwards: I've got a clouch.
593 00:42:00.970 --> 00:42:02.120 Stuart Bacon: Scope down…
594 00:42:02.250 --> 00:42:02.880 chris edwards: Yep.
595 00:42:03.520 --> 00:42:10.950 Stuart Bacon: You're looking for notes. So, not notes at the bottom there, yep. And then press Ctrl and V.
596 00:42:10.950 --> 00:42:12.350 Graham Stoddart-Stones: Little paste, yeah.
597 00:42:13.140 --> 00:42:14.180 chris edwards: Ctrl-C.
598 00:42:14.320 --> 00:42:15.690 Stuart Bacon: Ctrl-V.
599 00:42:15.950 --> 00:42:17.179 chris edwards: B, B for Bertie.
600 00:42:17.180 --> 00:42:18.370 Stuart Bacon: for Victor.
601 00:42:18.370 --> 00:42:19.740 chris edwards: Oh, right.
602 00:42:21.570 --> 00:42:24.070 Stuart Bacon: All I see is the word full.
603 00:42:26.480 --> 00:42:30.020 Stuart Bacon: So, I don't know what the hell she might cross out for.
604 00:42:30.170 --> 00:42:35.139 Stuart Bacon: per… Yeah, using your arrow keys, press up.
605 00:42:36.240 --> 00:42:37.140 chris edwards: Right.
606 00:42:38.340 --> 00:42:44.910 Stuart Bacon: Okay, we lost, we've lost that. So, click, leave that where it is.
607 00:42:45.190 --> 00:42:46.110 Graham Stoddart-Stones: into Excel.
608 00:42:46.110 --> 00:42:52.659 Stuart Bacon: go back into Excel, so scroll… move your mouse… no, no, don't scroll, we're not scrolling. Move your mouse down.
609 00:42:53.240 --> 00:42:55.399 Stuart Bacon: And go, right, slowly.
610 00:42:55.830 --> 00:43:02.380 Stuart Bacon: Go to the right, little bit further, little bit further, little bit further, stop. Click there.
611 00:43:02.790 --> 00:43:11.420 Stuart Bacon: Now scroll up… And click back on…
612 00:43:12.030 --> 00:43:12.940 Graham Stoddart-Stones: Sea tooth?
613 00:43:13.100 --> 00:43:17.410 Stuart Bacon: Well, click on the formula bar in the top.
614 00:43:17.660 --> 00:43:18.960 chris edwards: Yeah.
615 00:43:18.960 --> 00:43:21.699 Stuart Bacon: And let's highlight all of that.
616 00:43:23.380 --> 00:43:26.580 Stuart Bacon: And then right-click on it, and click Copy.
617 00:43:27.890 --> 00:43:28.600 chris edwards: Got it.
618 00:43:28.600 --> 00:43:30.879 Stuart Bacon: Right, now go back down to Outlook.
619 00:43:31.790 --> 00:43:33.029 Stuart Bacon: Go to the right.
620 00:43:34.260 --> 00:43:35.350 Graham Stoddart-Stones: Now…
621 00:43:35.350 --> 00:43:38.140 Stuart Bacon: Press, right-click, and paste.
622 00:43:41.090 --> 00:43:42.669 chris edwards: I just didn't like that.
623 00:43:42.950 --> 00:43:43.839 Stuart Bacon: Click on that.
624 00:43:44.500 --> 00:43:45.980 chris edwards: No, nothing's happening.
625 00:43:46.680 --> 00:43:47.420 Stuart Bacon: Press control.
626 00:43:47.420 --> 00:43:48.500 chris edwards: peel and paste.
627 00:43:49.490 --> 00:43:52.380 chris edwards: At the top, it says Paste and Match Style.
628 00:43:52.380 --> 00:43:53.690 Stuart Bacon: Yeah, go, try that one.
629 00:43:54.580 --> 00:43:56.160 chris edwards: No, nothing's happening.
630 00:43:56.160 --> 00:43:58.710 Stuart Bacon: Okay, so, click out of that space.
631 00:43:59.190 --> 00:43:59.860 chris edwards: Yep.
632 00:44:03.180 --> 00:44:05.509 Stuart Bacon: Press Ctrl and V.
633 00:44:07.920 --> 00:44:09.579 chris edwards: Yes, it's got… it's got it now.
634 00:44:09.580 --> 00:44:11.239 Stuart Bacon: Now it's got it, now click save.
635 00:44:11.470 --> 00:44:12.160 chris edwards: Okay.
636 00:44:13.660 --> 00:44:21.010 Stuart Bacon: So now… As you scroll down, to,
637 00:44:21.500 --> 00:44:24.420 Stuart Bacon: Yeah, the formula one, it… oh, what is that?
638 00:44:24.420 --> 00:44:25.520 chris edwards: group bins.
639 00:44:25.520 --> 00:44:28.180 Stuart Bacon: Grip bin formula, yeah. So under G…
640 00:44:28.990 --> 00:44:30.520 chris edwards: There we are, I've got it.
641 00:44:30.720 --> 00:44:32.339 Stuart Bacon: Yeah, it's there.
642 00:44:32.340 --> 00:44:33.629 chris edwards: Okay, that's fine.
643 00:44:38.280 --> 00:44:44.030 Stuart Bacon: So, yeah, that's, that solved that one.
644 00:44:44.660 --> 00:44:45.580 Stuart Bacon: Fool, yeah.
645 00:44:46.260 --> 00:44:47.090 chris edwards: Terrific.
646 00:44:47.500 --> 00:44:51.019 Stuart Bacon: So, I shall now leave your desktop.
647 00:44:51.400 --> 00:44:52.230 chris edwards: Okay.
648 00:44:53.480 --> 00:44:56.920 Stuart Bacon: Screen sharing has ended. I can't see your screen any longer.
649 00:44:56.920 --> 00:45:02.380 chris edwards: Okay, thank you very much indeed. No worries. So, let me get rid of that.
650 00:45:03.790 --> 00:45:06.199 Graham Stoddart-Stones: So, I have a fun story for you now.
651 00:45:08.130 --> 00:45:08.809 chris edwards: Go on, then.
652 00:45:08.810 --> 00:45:11.490 Graham Stoddart-Stones: So, in Parish Online, there is a…
653 00:45:12.010 --> 00:45:17.070 Graham Stoddart-Stones: layer for EPCs, your energy performance certificates.
654 00:45:17.680 --> 00:45:18.230 Stuart Bacon: Yep.
655 00:45:18.230 --> 00:45:24.250 Graham Stoddart-Stones: And that data is… Not necessarily up to date.
656 00:45:24.770 --> 00:45:34.670 Graham Stoddart-Stones: So I went to the government's website and said, could I please have the latest information? And they said, sure, you can have it to the end of July, which I thought was pretty good.
657 00:45:35.480 --> 00:45:40.980 Graham Stoddart-Stones: And they said, warning, you're about to download a large file.
658 00:45:41.720 --> 00:45:45.749 Graham Stoddart-Stones: Because this is the energy performance certificates for every house in the country.
659 00:45:45.750 --> 00:45:50.760 chris edwards: And, it was 5.5 gigabytes of data.
660 00:45:50.760 --> 00:45:51.320 Stuart Bacon: Dominic!
661 00:45:51.320 --> 00:45:53.510 Graham Stoddart-Stones: And now I'm going to import that into XMAP.
662 00:45:54.150 --> 00:46:00.689 chris edwards: And see whether I get loud complaints from Chris about taking up all of his disk space. Yeah.
663 00:46:00.850 --> 00:46:08.330 chris edwards: Now, I haven't got the ability to get back to, stop sharing my screen.
664 00:46:08.520 --> 00:46:10.160 Graham Stoddart-Stones: Or you aren't sharing your screen.
665 00:46:11.000 --> 00:46:11.630 chris edwards: Oh.
666 00:46:11.630 --> 00:46:15.490 Graham Stoddart-Stones: That's why you can't do it. You can't turn it off, because it isn't turned on.
667 00:46:15.650 --> 00:46:16.620 chris edwards: Okay, fair enough.
668 00:46:19.040 --> 00:46:19.710 chris edwards: Alright.
669 00:46:23.260 --> 00:46:24.490 chris edwards: Oh, there we go.
670 00:46:26.790 --> 00:46:34.260 Graham Stoddart-Stones: What I really like about having Stuart online is he can fill in all my Windows gaps for me, and all my various online gaps, too.
671 00:46:34.260 --> 00:46:35.040 chris edwards: Yes.
672 00:46:35.040 --> 00:46:38.579 Graham Stoddart-Stones: So, you're a very useful bloke, Stuart, don't let anyone tell you otherwise.
673 00:46:38.580 --> 00:46:43.070 chris edwards: Pat on the back, Nish. Stuart, thank you very much.
674 00:46:44.080 --> 00:46:51.310 chris edwards: I've lost all my energy. So I'm going to save my second question to next week.
675 00:46:51.740 --> 00:46:56.019 Graham Stoddart-Stones: I thought that was your second question. Oh, do please tell us. No, we'd love to know, Chris, come on.
676 00:46:56.020 --> 00:46:57.230 chris edwards: Alright, okay.
677 00:46:57.230 --> 00:46:59.579 Graham Stoddart-Stones: Have a quick cup of coffee or something.
678 00:46:59.900 --> 00:47:05.910 chris edwards: No, I've, I've, I've, I've lost… Why can't I…
679 00:47:07.060 --> 00:47:11.260 Stuart Bacon: You… your Edge browser is down at the bottom there.
680 00:47:12.140 --> 00:47:14.379 Stuart Bacon: Go left, yep, click there.
681 00:47:14.820 --> 00:47:22.489 chris edwards: There we go, there we go. Yeah, right. Now, my second question was to do with watercourses and nodes.
682 00:47:22.490 --> 00:47:24.149 Graham Stoddart-Stones: Oh yeah, we've had this before.
683 00:47:24.150 --> 00:47:33.079 chris edwards: Yeah, we've had this before, and John's very kindly come to my rescue previously. Now, so I've clicked on that… that node.
684 00:47:33.230 --> 00:47:46.370 chris edwards: we've got a problem with a blocked watercourse, and I've sent a stiff letter to the landowner saying it's his responsibility to clear debris from the watercourse, which is causing flooding.
685 00:47:46.660 --> 00:47:52.229 chris edwards: Now, here, here is the node, information.
686 00:47:52.770 --> 00:48:01.910 chris edwards: But it's just double Dutch to me. What can I glean from the information On the left-hand side… on…
687 00:48:02.110 --> 00:48:03.790 chris edwards: On the left-hand side.
688 00:48:04.390 --> 00:48:06.540 Graham Stoddart-Stones: Could I make a suggestion, Chris?
689 00:48:06.540 --> 00:48:07.280 chris edwards: Yes.
690 00:48:07.420 --> 00:48:12.750 Graham Stoddart-Stones: Is what he's got to keep clear, would you think that would show up on the gully data?
691 00:48:14.050 --> 00:48:17.309 chris edwards: Perhaps. So if I go to Gunnies.
692 00:48:17.310 --> 00:48:17.940 Graham Stoddart-Stones: Yep.
693 00:48:19.640 --> 00:48:21.539 Graham Stoddart-Stones: She's in South Somerset.
694 00:48:23.530 --> 00:48:25.010 Graham Stoddart-Stones: And you're gonna go down a bit.
695 00:48:25.140 --> 00:48:27.199 Graham Stoddart-Stones: There's sunset sharing.
696 00:48:28.070 --> 00:48:29.070 Graham Stoddart-Stones: Gullies.
697 00:48:31.000 --> 00:48:33.099 Graham Stoddart-Stones: No, it isn't. Okay, it's not there. Alright.
698 00:48:33.100 --> 00:48:33.450 chris edwards: So…
699 00:48:33.450 --> 00:48:34.359 Graham Stoddart-Stones: off the gully.
700 00:48:34.640 --> 00:48:40.329 Graham Stoddart-Stones: Alright, well, I would suggest, then, another action. If you know exactly where it is.
701 00:48:40.330 --> 00:48:41.430 chris edwards: Yeah, precisely.
702 00:48:41.430 --> 00:48:43.270 Graham Stoddart-Stones: Well, can put a point on it.
703 00:48:44.080 --> 00:48:47.410 Graham Stoddart-Stones: So, go into a point layer in your parish layers.
704 00:48:51.850 --> 00:48:56.410 Graham Stoddart-Stones: Parish layers, yeah. Do you have a spare point layer that you keep available?
705 00:48:56.790 --> 00:49:03.429 Graham Stoddart-Stones: I don't, actually, no. So I can go into… Well, no, go up to the top, go to Create Layer.
706 00:49:04.880 --> 00:49:08.269 Graham Stoddart-Stones: Top… top menu in the middle, the back line, create.
707 00:49:08.710 --> 00:49:10.849 Graham Stoddart-Stones: Add a layer, new layer.
708 00:49:11.700 --> 00:49:13.330 Graham Stoddart-Stones: This is… I knew…
709 00:49:13.330 --> 00:49:14.090 chris edwards: Try water cools.
710 00:49:14.090 --> 00:49:15.300 Stuart Bacon: Simple points.
711 00:49:15.570 --> 00:49:19.269 Graham Stoddart-Stones: Oh, I would just call it… just call it, Chris's Point Lair.
712 00:49:23.140 --> 00:49:24.580 Graham Stoddart-Stones: Chris's?
713 00:49:24.910 --> 00:49:27.690 Graham Stoddart-Stones: Oh, CED, okay, yeah, that's fine, yup.
714 00:49:28.910 --> 00:49:30.240 Graham Stoddart-Stones: And go for that.
715 00:49:31.580 --> 00:49:33.080 chris edwards: Point, point, point, point.
716 00:49:33.080 --> 00:49:36.149 Graham Stoddart-Stones: And just down at the bottom, save, or next, next.
717 00:49:37.410 --> 00:49:45.219 Graham Stoddart-Stones: And just… geometry type is a point, yup. And the reason for it, the description, is a handy…
718 00:49:45.580 --> 00:49:47.870 Graham Stoddart-Stones: Layer for all additional points.
719 00:49:51.570 --> 00:49:52.150 chris edwards: Yes.
720 00:49:52.150 --> 00:49:58.870 Graham Stoddart-Stones: Just call it convenient layer, or handy layer, or Aid to Chris, or whatever you want to call it, Handy Layer for Additional Points.
721 00:50:03.260 --> 00:50:06.020 Graham Stoddart-Stones: good… Yep, next.
722 00:50:06.020 --> 00:50:06.880 Stuart Bacon: Next.
723 00:50:07.760 --> 00:50:11.190 Graham Stoddart-Stones: Add one column, call it name, and just finish.
724 00:50:13.860 --> 00:50:16.890 Graham Stoddart-Stones: Right, now go into, yes, your layers.
725 00:50:17.690 --> 00:50:19.820 Graham Stoddart-Stones: And add a feature.
726 00:50:21.870 --> 00:50:24.859 Graham Stoddart-Stones: Go along to the point that you've got the farmer to clear.
727 00:50:25.550 --> 00:50:29.159 Graham Stoddart-Stones: Or the Landover. It's a bit further to the right, isn't it, Chris?
728 00:50:29.820 --> 00:50:33.330 chris edwards: Actually, it, no, it's, it's right there.
729 00:50:33.330 --> 00:50:37.660 Graham Stoddart-Stones: Okay, so save that. Oh, give it a name, sorry, give it a name, give it a name, give it a name.
730 00:50:42.310 --> 00:50:45.090 Graham Stoddart-Stones: Or blocked, whatever they call it, yeah.
731 00:50:49.170 --> 00:50:49.709 Graham Stoddart-Stones: And I think…
732 00:50:49.710 --> 00:50:51.259 Stuart Bacon: of course, blocked at Fairfield.
733 00:50:51.260 --> 00:50:52.779 Graham Stoddart-Stones: No, it can be used.
734 00:50:52.780 --> 00:50:54.399 chris edwards: I can come back, I can come back to that.
735 00:50:54.400 --> 00:50:56.249 Graham Stoddart-Stones: Close down the left-hand layer.
736 00:50:57.570 --> 00:50:59.559 Graham Stoddart-Stones: Alright, click on your red dot.
737 00:51:01.360 --> 00:51:03.719 Graham Stoddart-Stones: Sorry, I should have said,
738 00:51:04.200 --> 00:51:06.890 Graham Stoddart-Stones: Close that down, Chris, sorry, close down the column.
739 00:51:07.180 --> 00:51:09.180 Graham Stoddart-Stones: And right-click on the red dot.
740 00:51:10.910 --> 00:51:12.360 Graham Stoddart-Stones: Okay, copy.
741 00:51:12.900 --> 00:51:14.290 Graham Stoddart-Stones: And coordinates?
742 00:51:15.220 --> 00:51:16.469 Graham Stoddart-Stones: Yeah, that'll do.
743 00:51:17.260 --> 00:51:24.740 Graham Stoddart-Stones: And so now, in your clipboard, you've got the coordinates of that point, and you can send that to your man and say, please clear out these coordinates.
744 00:51:24.740 --> 00:51:25.320 chris edwards: All right, okay.
745 00:51:25.320 --> 00:51:28.780 Graham Stoddart-Stones: He can go out with his phone. When he gets there with his phone, he'll know where he is.
746 00:51:28.780 --> 00:51:30.809 chris edwards: Yeah, yeah, that's fantastic.
747 00:51:31.180 --> 00:51:32.360 chris edwards: That's brilliant.
748 00:51:32.360 --> 00:51:36.380 Graham Stoddart-Stones: So you can write your email now, and just watch it's in your clipboard.
749 00:51:36.510 --> 00:51:38.339 chris edwards: Yeah. And just send it to him.
750 00:51:38.580 --> 00:51:44.430 chris edwards: Yes. But, by the way, let me just see…
751 00:51:46.050 --> 00:51:52.610 chris edwards: I don't think I've got it in my layers, but I'll just show you, out of interest.
752 00:51:52.910 --> 00:51:54.280 chris edwards: Give me a second.
753 00:52:13.570 --> 00:52:20.630 chris edwards: I'm gonna just show you… the… the state… And… oh, blast.
754 00:52:23.330 --> 00:52:24.730 Graham Stoddart-Stones: Oh, that one there, okay.
755 00:52:24.730 --> 00:52:27.519 Stuart Bacon: Is that water outlet at Fairfield? Is that the one you're looking for?
756 00:52:27.970 --> 00:52:30.190 Graham Stoddart-Stones: Bottom line, Chris, bottom line in the middle.
757 00:52:30.560 --> 00:52:32.210 Stuart Bacon: One left, there you go, that one.
758 00:52:33.170 --> 00:52:38.110 chris edwards: No, no, no, no, no. I must have got it…
759 00:52:44.490 --> 00:52:46.150 chris edwards: Elonhoes.
760 00:52:51.370 --> 00:52:56.779 chris edwards: Oh, dear, I've kind of forgot where I put the bloomin' photographs. Anyway, anyway, that's by the way.
761 00:52:56.780 --> 00:52:57.780 Graham Stoddart-Stones: Maybe you gave it.
762 00:53:00.560 --> 00:53:02.269 Graham Stoddart-Stones: You can search on the name.
763 00:53:12.020 --> 00:53:13.560 chris edwards: I don't like that.
764 00:53:14.190 --> 00:53:15.000 chris edwards: Okay.
765 00:53:16.210 --> 00:53:19.690 Stuart Bacon: It may be, if you go up, go back to pictures.
766 00:53:20.010 --> 00:53:24.599 Stuart Bacon: Rather than in camera roll, now put the same search criteria.
767 00:53:24.600 --> 00:53:30.870 chris edwards: Actually… This doesn't show you the blockage, it just shows you.
768 00:53:30.870 --> 00:53:33.319 Graham Stoddart-Stones: the impact. It's causing a flood on a… on a…
769 00:53:33.340 --> 00:53:39.260 chris edwards: public right-of-way, and where I'm, waggling my cursor.
770 00:53:39.860 --> 00:53:46.309 chris edwards: There, it's… the watercourse is completely flooded, and it's covering a culvert.
771 00:53:46.900 --> 00:53:49.889 chris edwards: which… is extraordinary.
772 00:53:50.200 --> 00:53:51.120 Graham Stoddart-Stones: Of course.
773 00:53:51.120 --> 00:53:56.269 chris edwards: These homes are really facing a lot of damp issues.
774 00:53:58.810 --> 00:54:04.930 chris edwards: I'm sorry I can't, bring up the pictures, but never mind.
775 00:54:05.970 --> 00:54:13.719 Graham Stoddart-Stones: Well, when you send your note to the farmer, you might send the attachment, the photo as an attachment, and you can see the impact of what he's doing.
776 00:54:13.870 --> 00:54:15.010 chris edwards: Yeah, yeah.
777 00:54:15.180 --> 00:54:16.050 chris edwards: Quite.
778 00:54:16.450 --> 00:54:22.710 chris edwards: In fact, in fact, I've just ordered something, Bear with me.
779 00:54:24.960 --> 00:54:27.129 Graham Stoddart-Stones: I've got another question for you when you're done.
780 00:54:27.130 --> 00:54:29.200 chris edwards: Won't be long.
781 00:54:37.560 --> 00:54:40.199 chris edwards: It's just coming up.
782 00:54:51.720 --> 00:54:53.820 chris edwards: Now, we've just done that.
783 00:54:53.820 --> 00:54:54.580 Graham Stoddart-Stones: Yup.
784 00:54:54.580 --> 00:54:55.190 Stuart Bacon: Yep.
785 00:54:57.870 --> 00:55:01.990 chris edwards: Now, what I'm pointing at is that there's a culvert here.
786 00:55:01.990 --> 00:55:02.959 Graham Stoddart-Stones: Right, is that the word?
787 00:55:02.960 --> 00:55:08.239 chris edwards: And look at all of the water there, and I think I've got a better picture.
788 00:55:10.090 --> 00:55:11.220 chris edwards: See?
789 00:55:11.440 --> 00:55:13.790 chris edwards: The flood comes up beyond… beyond the.
790 00:55:13.790 --> 00:55:14.210 Graham Stoddart-Stones: Oh.
791 00:55:14.210 --> 00:55:16.580 chris edwards: boat. And there's… there's the footpath.
792 00:55:16.580 --> 00:55:17.300 Graham Stoddart-Stones: Yup.
793 00:55:17.740 --> 00:55:24.720 chris edwards: So, as I say, I've, and I've even… Pointed out the developers
794 00:55:26.330 --> 00:55:32.090 chris edwards: Plot of land, and that… that is the area where it is flooded, where the footpath is.
795 00:55:33.150 --> 00:55:35.300 Graham Stoddart-Stones: That seems to be very clear, Chris.
796 00:55:35.300 --> 00:55:35.750 chris edwards: Yes.
797 00:55:35.750 --> 00:55:36.530 Graham Stoddart-Stones: to come.
798 00:55:36.750 --> 00:55:37.520 chris edwards: Yep, yep.
799 00:55:38.520 --> 00:55:39.290 chris edwards: vegetables.
800 00:55:39.290 --> 00:55:40.610 Graham Stoddart-Stones: Yeah, it's right, good luck.
801 00:55:40.610 --> 00:55:42.220 chris edwards: Oh, Andrew's joined us!
802 00:55:42.460 --> 00:55:43.440 Graham Stoddart-Stones: Okay.
803 00:55:43.910 --> 00:55:47.710 chris edwards: Let me just close that down, and what were you going to say, Graham?
804 00:55:48.550 --> 00:55:52.939 Graham Stoddart-Stones: That was a very good question. I had a question for you, didn't I? Yeah.
805 00:55:55.740 --> 00:55:57.859 chris edwards: I'm going to shut down this as well.
806 00:56:01.440 --> 00:56:06.209 Graham Stoddart-Stones: But let's say good day to Andrew, and does this mean you've solved your manure problem?
807 00:56:06.910 --> 00:56:10.349 Andrew Clegg: It also means I've just woken up.
808 00:56:13.640 --> 00:56:16.909 Graham Stoddart-Stones: Well, welcome. You've missed a very exciting morning… afternoon.
809 00:56:16.910 --> 00:56:17.790 Andrew Clegg: about that.
810 00:56:17.790 --> 00:56:18.760 Graham Stoddart-Stones: That's alright.
811 00:56:20.210 --> 00:56:24.580 Graham Stoddart-Stones: I sent you an email earlier with a link to a website.
812 00:56:24.950 --> 00:56:26.869 Graham Stoddart-Stones: Andrew, I don't know if you've seen it yet.
813 00:56:28.230 --> 00:56:30.660 Andrew Clegg: Yes, yes, thank you very much, yeah.
814 00:56:30.660 --> 00:56:33.149 Graham Stoddart-Stones: I didn't know if it was at all helpful, or whether it was… you knew all.
815 00:56:33.150 --> 00:56:44.329 Andrew Clegg: Well, no, but you know, everybody's setting up these sort of links all over the place. It is helpful, because it's close by, I'll investigate it.
816 00:56:44.330 --> 00:56:47.130 Graham Stoddart-Stones: Well, I thought it said they gave you free kits.
817 00:56:47.530 --> 00:56:54.169 Andrew Clegg: Which sounds… Yeah, but what… they don't mean free, real kits, they mean free, very cheap, cheap kits.
818 00:56:54.170 --> 00:56:58.019 Graham Stoddart-Stones: Right, right. And not necessarily measuring nitrates, anyway.
819 00:56:59.440 --> 00:57:01.469 Graham Stoddart-Stones: Anyway, that was just a thought.
820 00:57:02.560 --> 00:57:08.650 Graham Stoddart-Stones: Sorry, Chris, it's gone out of my mind, I should have.
821 00:57:08.650 --> 00:57:10.210 chris edwards: Don't lie.
822 00:57:11.870 --> 00:57:18.200 Graham Stoddart-Stones: So, Andrew, you'll be surprised to know that A, we admire that haircut, and B,
823 00:57:19.040 --> 00:57:20.990 Graham Stoddart-Stones: It's your turn to ask a question.
824 00:57:21.290 --> 00:57:27.139 Andrew Clegg: I haven't got a question, I've only just been… Jonah's just woken up, Graham, can't you?
825 00:57:27.530 --> 00:57:29.380 Stuart Bacon: You've not been dreaming up a question for us!
826 00:57:29.840 --> 00:57:30.910 Stuart Bacon: Yes.
827 00:57:30.910 --> 00:57:37.649 Graham Stoddart-Stones: I mean, whenever I wake up, I've got my mind full of all the things it's been working on whilst I was asleep. You mean your brain doesn't work that way?
828 00:57:37.840 --> 00:57:56.339 Andrew Clegg: Now, one of the things I've… one problem that I've got, though, is that I've… I've been entering the results of sampling of the river parrot for a year. One sample per week, so that means 52 samples, and I've done it from the same spot, and how do you get 52
829 00:57:56.340 --> 00:58:03.400 Andrew Clegg: points on a spot that's, in reality, only about 6 feet wide.
830 00:58:05.080 --> 00:58:07.039 Stuart Bacon: With great difficulty.
831 00:58:07.040 --> 00:58:12.500 Andrew Clegg: No, it's alright, I just… they're just spread out all over the place.
832 00:58:13.230 --> 00:58:18.579 Graham Stoddart-Stones: But then, there isn't the simple answer to put them into a spreadsheet and attach the spreadsheet to one spot.
833 00:58:18.800 --> 00:58:21.000 Andrew Clegg: No, well, you say, I'm adding it each week.
834 00:58:21.740 --> 00:58:25.090 Andrew Clegg: You know, I put one in each week, I put a spot in each week.
835 00:58:25.090 --> 00:58:27.910 Graham Stoddart-Stones: But it's the same pace, or they're all not always the same.
836 00:58:27.910 --> 00:58:31.389 Andrew Clegg: Yeah, they'll all come on the same spreadsheet anyway, if people want to download.
837 00:58:31.390 --> 00:58:32.040 Graham Stoddart-Stones: Oh, I see.
838 00:58:32.040 --> 00:58:32.620 Andrew Clegg: Yeah.
839 00:58:32.800 --> 00:58:33.160 Graham Stoddart-Stones: Alright.
840 00:58:33.160 --> 00:58:39.210 chris edwards: Andrew, has the level of phosphates risen and fallen over that year?
841 00:58:39.690 --> 00:58:56.660 Andrew Clegg: Well, it's… there's a baseline that almost happens with all rivers, and that is that the phosphate concentration tends to double during the summer months, and then go down again during the winter months, and I've actually no idea why.
842 00:58:56.830 --> 00:59:04.119 Andrew Clegg: It seems to me that it ought to be the other way around, because less phosphate is being taken up by… by.
843 00:59:04.590 --> 00:59:06.350 Graham Stoddart-Stones: Isn't do a method of dilution, no.
844 00:59:06.540 --> 00:59:07.820 Graham Stoddart-Stones: parts per million.
845 00:59:08.630 --> 00:59:09.679 Andrew Clegg: Yes it is.
846 00:59:09.900 --> 00:59:13.380 Graham Stoddart-Stones: So if you double the water flow, don't you halve the phosphate count?
847 00:59:13.380 --> 00:59:18.899 Andrew Clegg: No, the concentration is independent of the water flow.
848 00:59:20.150 --> 00:59:23.850 Andrew Clegg: I mean, that's the odd thing.
849 00:59:23.850 --> 00:59:25.419 Graham Stoddart-Stones: Yeah, that's very puzzling.
850 00:59:25.420 --> 00:59:32.430 Andrew Clegg: It's very odd indeed, but it's… I can work that one out, actually, with… with… because I suspect it's not the case.
851 00:59:32.580 --> 00:59:42.749 Andrew Clegg: It's only the case in where you've got clay, or a similar soil that strongly absorbs phosphate in the sediment of the river. What we're seeing is.
852 00:59:42.760 --> 00:59:45.550 Graham Stoddart-Stones: As you put more water in the river.
853 00:59:45.550 --> 00:59:47.569 Andrew Clegg: Phosphine comes out of the sediment.
854 00:59:47.570 --> 00:59:48.240 Graham Stoddart-Stones: Yeah.
855 00:59:48.240 --> 00:59:50.969 Andrew Clegg: Very quickly, you see, in a matter of minutes.
856 00:59:50.970 --> 00:59:52.660 Graham Stoddart-Stones: Right, and fascinating.
857 00:59:52.660 --> 01:00:11.290 Andrew Clegg: And you get up to a sort of fairly stable concentration. But we've had… just had a huge storm yesterday, and this morning, the phosphate has gone up very dramatically, and I suspect it's just a question of stuff being washed out.
858 01:00:12.250 --> 01:00:14.630 Andrew Clegg: You accumulated over the summer.
859 01:00:14.970 --> 01:00:21.730 Graham Stoddart-Stones: So if the parrot floods, does it send some of the silt over the surrounding countryside, and therefore gets rid of those phosphates?
860 01:00:21.730 --> 01:00:37.669 Andrew Clegg: Well, that's a big question, and that's one of my… I've got a little program over the last year to try and find out the answer, and I think the answer is that when it floods, there is a net removal of phosphate rather than deposition.
861 01:00:40.080 --> 01:00:41.580 Andrew Clegg: Which is interesting.
862 01:00:41.580 --> 01:00:42.450 Graham Stoddart-Stones: It is.
863 01:00:42.450 --> 01:00:42.920 Andrew Clegg: Yeah.
864 01:00:42.920 --> 01:00:44.749 Graham Stoddart-Stones: Where does it remove it to?
865 01:00:45.630 --> 01:00:46.370 Andrew Clegg: demo.
866 01:00:46.900 --> 01:00:49.590 Graham Stoddart-Stones: Who? The Bristol Channel. Yes, yes, yes.
867 01:00:51.250 --> 01:01:01.029 chris edwards: And Andrew, do you take readings, on various points on the River Parrot? Sort of upstream, downstream, that sort of thing?
868 01:01:01.030 --> 01:01:06.409 Andrew Clegg: Yeah, I start… I start in Dorset, and I take the reading… readings
869 01:01:06.600 --> 01:01:18.220 Andrew Clegg: just upstream of a sewage works, and just downstream of a sewage works, and there's about 5 of those down the river. And also, I take readings from some of the main tributaries.
870 01:01:18.490 --> 01:01:19.210 chris edwards: Right.
871 01:01:19.210 --> 01:01:19.870 Andrew Clegg: Yeah.
872 01:01:19.990 --> 01:01:24.210 chris edwards: It's led so far to two prosecutions, actually. Oh, right.
873 01:01:24.210 --> 01:01:29.570 Graham Stoddart-Stones: Therefore, you are seeing a difference between above and below the sewage?
874 01:01:29.570 --> 01:01:30.310 Andrew Clegg: Yes.
875 01:01:30.540 --> 01:01:31.749 Graham Stoddart-Stones: Go to…
876 01:01:32.370 --> 01:01:47.510 Andrew Clegg: Gotcha. And, interestingly, Wessex Water have sorted out three of the three largest sewage works on the river in the last year, and now what they're putting in is zero.
877 01:01:47.510 --> 01:01:48.010 Graham Stoddart-Stones: done.
878 01:01:48.010 --> 01:01:51.170 Andrew Clegg: The differences immediately disappeared, but…
879 01:01:51.760 --> 01:01:58.240 Andrew Clegg: What hasn't happened is there hasn't been a substantial drop in the overall concentration in the river.
880 01:01:58.770 --> 01:02:02.740 chris edwards: That's because we're now washing out 150 years of…
881 01:02:03.630 --> 01:02:06.259 Graham Stoddart-Stones: You need to get a treasure in there, don't you?
882 01:02:06.700 --> 01:02:10.930 Andrew Clegg: Well, you just need to… you just need another 100 years of, good rain.
883 01:02:10.930 --> 01:02:11.960 Graham Stoddart-Stones: Clean, yes.
884 01:02:13.150 --> 01:02:13.849 Graham Stoddart-Stones: That's really true.
885 01:02:13.850 --> 01:02:16.859 chris edwards: You know, do you take readings on the River Brew?
886 01:02:17.320 --> 01:02:23.069 Andrew Clegg: I took one… I took one above Wyke Farm and one below Wyke Farm.
887 01:02:23.070 --> 01:02:24.180 chris edwards: Oh, yes.
888 01:02:24.180 --> 01:02:25.600 Andrew Clegg: And there was no difference.
889 01:02:25.860 --> 01:02:26.659 chris edwards: Oh, I see.
890 01:02:26.660 --> 01:02:34.190 Andrew Clegg: I was just… I was on a visit to Wyck Farm, so I thought, before I go, I'll just see if they're… see if they're clean or dirty.
891 01:02:35.310 --> 01:02:37.589 Graham Stoddart-Stones: Is that… is that a cow farm?
892 01:02:37.590 --> 01:02:52.979 Andrew Clegg: It's a well-known dairy, sort of high-end dairy, I think. It's quality stuff. And they also have a power station there, where all the manure and everything, plus
893 01:02:53.330 --> 01:02:59.649 Andrew Clegg: all the bread that people in North Somerset don't want goes there, and…
894 01:02:59.650 --> 01:03:00.660 Graham Stoddart-Stones: Finance Fund.
895 01:03:00.660 --> 01:03:10.499 Andrew Clegg: And they've got this biomass plant, which they use to generate electricity. All beautifully clean and ready for visitors like me, you know.
896 01:03:10.810 --> 01:03:13.509 chris edwards: Andrew and myself attended.
897 01:03:13.510 --> 01:03:15.819 Andrew Clegg: Oh, yes. Sort of an away day…
898 01:03:15.820 --> 01:03:18.900 chris edwards: Yes, yes, of course, but it was a most interesting visit.
899 01:03:18.900 --> 01:03:19.250 Andrew Clegg: Yeah.
900 01:03:19.250 --> 01:03:20.860 chris edwards: For the biomass plant.
901 01:03:20.980 --> 01:03:25.829 chris edwards: We all left with… Bags of goodies, which was rather nice.
902 01:03:25.830 --> 01:03:30.329 Andrew Clegg: Yes, yeah, yeah. It was a very impressive visit, wasn't it, that? It was.
903 01:03:30.330 --> 01:03:31.090 chris edwards: Yes.
904 01:03:31.390 --> 01:03:33.450 Graham Stoddart-Stones: So, what was the impressive about it?
905 01:03:34.240 --> 01:03:39.490 Andrew Clegg: Just that the whole operation was very slick, clean, and, you know…
906 01:03:40.400 --> 01:03:45.550 Graham Stoddart-Stones: And they are generating on a constant basis? They're getting enough supply, is what?
907 01:03:45.660 --> 01:03:49.539 Andrew Clegg: Yeah. What amazed me was the pile of bread.
908 01:03:49.750 --> 01:03:50.630 chris edwards: Yes.
909 01:03:51.510 --> 01:03:55.540 Andrew Clegg: Huge pile of bread, but big as a house.
910 01:03:56.350 --> 01:03:59.120 Graham Stoddart-Stones: So, I have a different news story for you, Chris.
911 01:03:59.120 --> 01:03:59.680 chris edwards: Okay.
912 01:03:59.680 --> 01:04:00.629 Graham Stoddart-Stones: So I was…
913 01:04:00.630 --> 01:04:05.750 Andrew Clegg: As you know, I was a Submariner years ago, and so I got very used to nuclear power.
914 01:04:05.750 --> 01:04:06.120 chris edwards: Hmm?
915 01:04:06.120 --> 01:04:16.929 Graham Stoddart-Stones: I'm very interested in climate mitigation going ahead, of how big a part nuclear is going to play, but I came across a brand new idea yesterday, which I thought was rather sweet.
916 01:04:17.030 --> 01:04:23.190 Graham Stoddart-Stones: So… If you have a place like Hinkley Point, which is a pressurized water reactor.
917 01:04:23.670 --> 01:04:31.210 Graham Stoddart-Stones: The water acts as the, transfer of heat to the turbine, so it turns into steam.
918 01:04:31.210 --> 01:04:44.970 Graham Stoddart-Stones: drives the turbine, gets pressurized back into water, and gets pumped back into the reactor, and so it goes round and round, around, around, around. And the reason that you need the pressure is so you can build up the steam temperature high enough to be really effective.
919 01:04:46.150 --> 01:04:55.300 Graham Stoddart-Stones: So that's the only point of the pressure, is to stop it flashing off to steam at boiling point. You've got to actually increase the pressure, and it doesn't flash off to steam until it's much hotter.
920 01:04:55.530 --> 01:04:56.060 chris edwards: Oh, right.
921 01:04:56.150 --> 01:05:06.319 Graham Stoddart-Stones: So, effectively, the amount of pressure in a reactor is something of the order of, let's say, 600 pounds per square inch. Maybe it's a bit more than that nowadays.
922 01:05:06.390 --> 01:05:22.900 Graham Stoddart-Stones: But you can get exactly the same effect by, putting a column of water a mile high on top of the reactor. That's the sort of pressure that you're getting, is a mile's worth of water. So this new idea is to… you drill a hole.
923 01:05:23.180 --> 01:05:27.169 Graham Stoddart-Stones: a mile deep into the Earth's surface, or into the Earth.
924 01:05:27.360 --> 01:05:30.559 Graham Stoddart-Stones: And at the bottom of the hole, you put a nuclear reactor.
925 01:05:30.840 --> 01:05:37.460 Graham Stoddart-Stones: And you say, this reactor's going to be good for, 2 or 3 years, and then it'll need refueling.
926 01:05:37.630 --> 01:05:42.120 Graham Stoddart-Stones: And you don't refuel it, you just drop in another reactor on top.
927 01:05:42.310 --> 01:06:01.299 Graham Stoddart-Stones: And then you put in a mile of water on top of that. The water circulates and comes to the surface very hot to drive the turbine, and then goes back down. But the reactor is a mile away below everybody, and when you're finished with that reactor, you just take the water out, fill it with concrete, and you're done.
928 01:06:01.640 --> 01:06:02.100 chris edwards: Mmm.
929 01:06:02.130 --> 01:06:10.010 Graham Stoddart-Stones: The reactor itself is not very big, it's about 25cm across, because that's the diameter of the tube that you're boring.
930 01:06:10.550 --> 01:06:26.959 Graham Stoddart-Stones: And it'll last for about 2 years, and then when you're done, you just drop another one in on top of it, and perhaps another one on top of that. And then, at the end of it, you're finished. And I just thought it was very neat, very much less expensive, because you haven't got to build those huge pressure vessels.
931 01:06:26.960 --> 01:06:39.570 Graham Stoddart-Stones: I mean, the one at Hinkley is several thousand tons worth of metal sitting on top of the thing, and then you put a concrete container around that, so that if the pressure vessel leaks, the radiation doesn't go anywhere.
932 01:06:39.940 --> 01:06:42.690 Graham Stoddart-Stones: But if it's down at the bottom of a mile-long pipe.
933 01:06:42.960 --> 01:06:46.490 Graham Stoddart-Stones: You've solved all of those problems, and you've saved huge amounts of money.
934 01:06:46.710 --> 01:06:47.250 chris edwards: Mmm.
935 01:06:47.250 --> 01:06:59.190 Graham Stoddart-Stones: You don't have all the people contending that, you know, we don't want our view destroyed by a nuclear reactor, we don't want the Bristol Channel heated up by the heat coming out of Hinkley Point, which is going to be a substantial issue, I think.
936 01:06:59.400 --> 01:07:00.769 Graham Stoddart-Stones: And so it goes.
937 01:07:01.090 --> 01:07:01.450 chris edwards: Yeah.
938 01:07:02.220 --> 01:07:04.409 Graham Stoddart-Stones: Doesn't that sound like a sweet answer?
939 01:07:04.410 --> 01:07:05.070 chris edwards: Yeah.
940 01:07:05.180 --> 01:07:09.070 chris edwards: I wonder how many mile… mile…
941 01:07:09.780 --> 01:07:10.640 Graham Stoddart-Stones: Down.
942 01:07:10.770 --> 01:07:12.660 chris edwards: down.
943 01:07:12.850 --> 01:07:14.900 Andrew Clegg: Things there are in the world.
944 01:07:14.900 --> 01:07:17.809 chris edwards: Are we talking about just a few, or hundreds?
945 01:07:18.740 --> 01:07:22.479 Graham Stoddart-Stones: Well, I don't think anyone's built anything yet, but there are lots of boreholes around.
946 01:07:22.660 --> 01:07:23.120 chris edwards: Yes.
947 01:07:23.120 --> 01:07:26.810 Graham Stoddart-Stones: I mean, people have dug, what, 10 kilometers down or something, if not further?
948 01:07:27.040 --> 01:07:28.219 chris edwards: Oh, I never knew that.
949 01:07:29.190 --> 01:07:34.409 Graham Stoddart-Stones: So, I just thought it sounded like an extremely sweet solution.
950 01:07:34.410 --> 01:07:35.719 chris edwards: Yeah, yeah.
951 01:07:36.970 --> 01:07:42.030 Andrew Clegg: There'll be some… there'll be something wrong with it, Graham. It's too good to be… too good to be true.
952 01:07:42.030 --> 01:07:50.699 Graham Stoddart-Stones: Of course, there's going to be pros and cons, and the question is, which is the greatest… I mean, I'm very interested in these small modular reactors, which they're deciding.
953 01:07:51.070 --> 01:07:53.990 Graham Stoddart-Stones: But I also read the other day that,
954 01:07:54.590 --> 01:07:59.330 Graham Stoddart-Stones: Local water wheels powering electricity generators are coming back into fashion.
955 01:07:59.620 --> 01:08:06.229 Graham Stoddart-Stones: They're beginning to realize that modern technology, that propellers, are so efficient that they can drive generators where
956 01:08:06.500 --> 01:08:16.289 Graham Stoddart-Stones: in the old days, they used to drive, you know, flour mills and so forth. I mean, if you can drive a flour mill, you can drive a generator and just have a little local generator humming away.
957 01:08:16.800 --> 01:08:19.220 Graham Stoddart-Stones: The problem with that, of course, is when you have a drought.
958 01:08:19.770 --> 01:08:20.520 Andrew Clegg: Hmm.
959 01:08:20.859 --> 01:08:23.599 Graham Stoddart-Stones: But we live in England, we don't have droughts.
960 01:08:24.830 --> 01:08:31.300 Graham Stoddart-Stones: Despite… I remember, a phone call to you, Andrew, not many banter sessions ago, where you were…
961 01:08:31.439 --> 01:08:34.060 Graham Stoddart-Stones: pleading for water. You hadn't seen water in months.
962 01:08:34.069 --> 01:08:36.339 Andrew Clegg: Oh, it's still not good.
963 01:08:36.569 --> 01:08:39.709 Andrew Clegg: Even though we had a few storm.
964 01:08:40.029 --> 01:08:44.649 Andrew Clegg: My, you know, foot down, my allotment is bone dry, still.
965 01:08:44.969 --> 01:08:46.009 Graham Stoddart-Stones: Is it?
966 01:08:46.819 --> 01:08:48.899 Graham Stoddart-Stones: The water just runs straight off, it doesn't soak in.
967 01:08:48.899 --> 01:08:50.859 Andrew Clegg: Oh, no, it's soaking in gradually.
968 01:08:51.279 --> 01:08:52.029 Graham Stoddart-Stones: Right.
969 01:08:52.059 --> 01:08:52.749 Andrew Clegg: Hmm.
970 01:08:53.910 --> 01:09:08.180 Graham Stoddart-Stones: I wonder why… I often wonder why the water people, I don't know if they have the incentive, but if they keep pumping stuff out of the aquifers, and then when it rains, it all just washes straight into the sea, why aren't they capturing it, sticking it back into the aquifers?
971 01:09:08.380 --> 01:09:09.480 Andrew Clegg: I don't know.
972 01:09:09.750 --> 01:09:12.489 chris edwards: It worries me that they're pumping thought.
973 01:09:12.490 --> 01:09:15.430 Andrew Clegg: Four much… too much out of the aquifers.
974 01:09:15.720 --> 01:09:16.470 Graham Stoddart-Stones: Yeah.
975 01:09:16.479 --> 01:09:19.979 Andrew Clegg: That's now happened… been happening for 40 years.
976 01:09:19.979 --> 01:09:24.119 Graham Stoddart-Stones: Yeah, you're gonna get land subsidence and houses falling down, and roads…
977 01:09:24.120 --> 01:09:27.080 Andrew Clegg: Fossil water that isn't being replaced, a lot of it.
978 01:09:27.080 --> 01:09:27.450 Graham Stoddart-Stones: Yes.
979 01:09:28.050 --> 01:09:30.490 Andrew Clegg: It's just not re… not renewable.
980 01:09:31.290 --> 01:09:37.119 Graham Stoddart-Stones: But don't worry, there's some satellite moon of… is it Jupiter?
981 01:09:37.670 --> 01:09:39.269 Andrew Clegg: Yeah, lots of it up there.
982 01:09:39.279 --> 01:09:45.029 Graham Stoddart-Stones: Masses of masses and masses of water, you just need to tow it to the earth.
983 01:09:45.029 --> 01:09:46.289 Andrew Clegg: In a long pipe.
984 01:09:46.290 --> 01:09:49.069 Graham Stoddart-Stones: Yes, exactly.
985 01:09:49.630 --> 01:09:52.599 Graham Stoddart-Stones: All right, well, I think it's weekend time, people.
986 01:09:52.609 --> 01:09:56.559 Stuart Bacon: Yeah, sorry, I'll just…
987 01:09:56.939 --> 01:10:04.749 Stuart Bacon: Going back to Chris's point, I've worked out where I was go… the alternative with the formula we were looking at, and how it… why it didn't work.
988 01:10:04.750 --> 01:10:06.490 Graham Stoddart-Stones: Oh, good, what was the reason?
989 01:10:08.650 --> 01:10:09.979 Graham Stoddart-Stones: Show us what you've come up with.
990 01:10:10.170 --> 01:10:12.720 Stuart Bacon: Yeah, I'm just about to put it in the chat.
991 01:10:12.720 --> 01:10:13.340 Graham Stoddart-Stones: Okay.
992 01:10:13.520 --> 01:10:15.589 Stuart Bacon: Yeah, so bear with me one second.
993 01:10:23.240 --> 01:10:24.970 Stuart Bacon: There you go.
994 01:10:24.970 --> 01:10:25.690 chris edwards: Oat.
995 01:10:28.410 --> 01:10:30.549 Graham Stoddart-Stones: Oh, times D2.
996 01:10:30.950 --> 01:10:32.790 Graham Stoddart-Stones: That's an equal to 19.
997 01:10:33.780 --> 01:10:36.220 Graham Stoddart-Stones: What's that asterisk doing in there?
998 01:10:36.360 --> 01:10:43.140 Stuart Bacon: So, effectively, what it says is you've got to have the asterisk there for your times in the upper and lower…
999 01:10:43.500 --> 01:10:44.720 Stuart Bacon: Upper and lower range.
1000 01:10:44.720 --> 01:10:47.950 Graham Stoddart-Stones: Oh, okay, equal to 1, I'm with you, right, okay.
1001 01:10:50.090 --> 01:10:51.070 Graham Stoddart-Stones: Alright.
1002 01:10:53.490 --> 01:10:56.930 Graham Stoddart-Stones: You can easily sort of copy that, Chris, and.
1003 01:10:56.930 --> 01:11:01.810 chris edwards: Yes, I've copied it already. Thank you very much indeed then, Stuart. Brilliant.
1004 01:11:02.260 --> 01:11:05.300 Andrew Clegg: I'm just trying to imagine what the question was.
1005 01:11:05.300 --> 01:11:08.130 chris edwards: Don't ask! No, come on, it's an easy.
1006 01:11:08.130 --> 01:11:14.680 Graham Stoddart-Stones: one. So, Chris is telling his county council what the state of his grip bins is.
1007 01:11:14.900 --> 01:11:19.620 Graham Stoddart-Stones: And if you store the data in Paris Online, they store it as a percentage.
1008 01:11:19.900 --> 01:11:26.859 Graham Stoddart-Stones: And the council doesn't understand percentages, they only understand quarter, half, or three-quarters, or full, or even…
1009 01:11:26.860 --> 01:11:30.200 Andrew Clegg: Oh, I see, so you're putting your percentages in, and then that…
1010 01:11:30.200 --> 01:11:31.450 Graham Stoddart-Stones: Conversing it to the…
1011 01:11:31.450 --> 01:11:32.770 chris edwards: Yes, yes.
1012 01:11:33.350 --> 01:11:33.980 Graham Stoddart-Stones: Yeah.
1013 01:11:34.510 --> 01:11:42.119 Graham Stoddart-Stones: And we've actually had quite a lot of fun today doing that. So, I did come up with the answer to the question I was going to mention to you, Chris.
1014 01:11:42.120 --> 01:11:42.660 chris edwards: Yep.
1015 01:11:42.660 --> 01:11:44.949 Graham Stoddart-Stones: So when you share your screen.
1016 01:11:45.830 --> 01:11:51.270 Graham Stoddart-Stones: in Zoom, does it come up with a whole bunch of windows that are open in your browser?
1017 01:11:52.530 --> 01:11:53.080 Graham Stoddart-Stones: So.
1018 01:11:53.080 --> 01:11:53.600 chris edwards: continue.
1019 01:11:53.600 --> 01:11:55.569 Graham Stoddart-Stones: Do it now, if you go into Share Screen.
1020 01:11:56.010 --> 01:11:56.910 chris edwards: Right.
1021 01:11:56.910 --> 01:12:03.660 Graham Stoddart-Stones: And when it… now, your situation in that, what do you see on your screen in front of you? No, no, no, you've already done it, you clicked it too far.
1022 01:12:04.690 --> 01:12:07.120 Graham Stoddart-Stones: When you selected that, what did you select it from?
1023 01:12:07.450 --> 01:12:08.270 Stuart Bacon: Yeah.
1024 01:12:10.490 --> 01:12:12.649 Graham Stoddart-Stones: So, was there a bunch of…
1025 01:12:12.770 --> 01:12:16.899 Graham Stoddart-Stones: windows on your screen, and you selected the one that had Paris Online in it.
1026 01:12:17.150 --> 01:12:18.210 chris edwards: No, not…
1027 01:12:18.750 --> 01:12:19.290 Graham Stoddart-Stones: Okay.
1028 01:12:19.290 --> 01:12:22.060 Stuart Bacon: If you, if you stop screen sharing now, Chris.
1029 01:12:22.230 --> 01:12:22.920 chris edwards: Yep.
1030 01:12:24.020 --> 01:12:29.500 Stuart Bacon: Yeah? And go back to… just click on the green share button.
1031 01:12:29.760 --> 01:12:30.400 chris edwards: Yep.
1032 01:12:31.840 --> 01:12:33.569 Stuart Bacon: And what does that show you?
1033 01:12:33.810 --> 01:12:39.439 chris edwards: Right, at the bottom, on a blue cell, it says the word share.
1034 01:12:40.340 --> 01:12:42.609 chris edwards: So I normally click on that.
1035 01:12:43.030 --> 01:12:45.269 Graham Stoddart-Stones: Whoa, but what's inside the shell?
1036 01:12:46.750 --> 01:12:48.220 Graham Stoddart-Stones: Shell, what's inside it?
1037 01:12:48.650 --> 01:12:52.970 chris edwards: Right, it's got… The screen… well…
1038 01:12:53.200 --> 01:12:59.750 chris edwards: application windows, which is Parish Online. I've got a load of files.
1039 01:13:03.400 --> 01:13:07.659 Graham Stoddart-Stones: Can you take… do you understand how to do a print screen or a screenshot in…
1040 01:13:08.010 --> 01:13:10.119 Graham Stoddart-Stones: Oh, Windows is that weird word.
1041 01:13:10.120 --> 01:13:12.509 chris edwards: Yeah, yeah, yes, I'll do it, I'll do it now.
1042 01:13:14.870 --> 01:13:15.360 Graham Stoddart-Stones: Excuse me.
1043 01:13:15.360 --> 01:13:17.230 chris edwards: Give me a second. Give me a second.
1044 01:13:17.230 --> 01:13:17.880 Graham Stoddart-Stones: Yeah.
1045 01:13:21.120 --> 01:13:22.960 chris edwards: I'll save that.
1046 01:13:26.360 --> 01:13:27.959 Graham Stoddart-Stones: And then you can chose it.
1047 01:13:34.540 --> 01:13:35.720 chris edwards: Save.
1048 01:13:40.040 --> 01:13:43.290 chris edwards: Right. How do I show you that?
1049 01:13:43.870 --> 01:13:45.120 Stuart Bacon: Drop it in the chat.
1050 01:13:46.030 --> 01:13:46.660 Graham Stoddart-Stones: Yep.
1051 01:13:47.020 --> 01:13:47.550 Stuart Bacon: Drugma.
1052 01:13:47.800 --> 01:13:52.049 chris edwards: Okay, just… I'm just gathering my thoughts, just one second.
1053 01:14:01.830 --> 01:14:03.600 chris edwards: I'm get… I'm getting there.
1054 01:14:36.990 --> 01:14:40.750 chris edwards: Sorry, I've… I've… I've gone and lost it now.
1055 01:14:45.030 --> 01:14:53.859 Graham Stoddart-Stones: So, at the bottom of the chat, there's a bunch of 4 icons, 5 icons, 4 icons. The right-hand icon is a screenshot.
1056 01:14:55.110 --> 01:14:58.830 Graham Stoddart-Stones: If you click on that, it should take you to your last screenshot you just saved.
1057 01:15:00.310 --> 01:15:01.490 Graham Stoddart-Stones: That'll be good.
1058 01:15:01.880 --> 01:15:02.780 Stuart Bacon: That's me.
1059 01:15:03.020 --> 01:15:03.650 Graham Stoddart-Stones: Yeah.
1060 01:15:06.460 --> 01:15:09.889 chris edwards: There's… something's not right on my screen.
1061 01:15:10.960 --> 01:15:12.420 chris edwards: Oh, dear.
1062 01:15:18.190 --> 01:15:21.160 chris edwards: No, I'm… I'm lost.
1063 01:15:24.970 --> 01:15:26.080 Graham Stoddart-Stones: Well, not to worry.
1064 01:15:26.480 --> 01:15:31.159 chris edwards: Sorry, folks, I'll have to show you that next… next week. Oh, no, here we go.
1065 01:15:32.980 --> 01:15:37.920 chris edwards: Oh, bloody hell.
1066 01:15:38.960 --> 01:15:41.189 chris edwards: I had it a second ago, and I…
1067 01:15:53.900 --> 01:15:56.270 Graham Stoddart-Stones: Can I suggest a new way of you doing it, Chris?
1068 01:15:57.010 --> 01:15:57.610 chris edwards: Yeah, go on.
1069 01:15:57.610 --> 01:15:59.789 Graham Stoddart-Stones: If you go into the Zoom chat.
1070 01:16:02.190 --> 01:16:03.270 chris edwards: Yes.
1071 01:16:03.270 --> 01:16:05.900 Graham Stoddart-Stones: At the bottom, you've got a row of icons.
1072 01:16:12.710 --> 01:16:13.840 Graham Stoddart-Stones: Yes, no?
1073 01:16:15.580 --> 01:16:23.089 Graham Stoddart-Stones: So, at the very bottom, where you type in a new message, it says, message everyone, and then below that, there are 1, 2, 3, 4 icons.
1074 01:16:23.510 --> 01:16:29.650 chris edwards: No, I… I… No, I don't… I don't see that on my screen.
1075 01:16:29.650 --> 01:16:33.160 Graham Stoddart-Stones: Okay. Is your Zoom screen maximized?
1076 01:16:36.690 --> 01:16:39.679 Andrew Clegg: I wonder whether it may be a different version of Zoom.
1077 01:16:40.430 --> 01:16:44.939 Graham Stoddart-Stones: Well, that's very possible. It's also running on Windows, so the poor guy hasn't got a chance.
1078 01:16:48.340 --> 01:16:48.940 chris edwards: No.
1079 01:16:49.840 --> 01:16:51.160 Graham Stoddart-Stones: Well, not to worry, Chris.
1080 01:16:53.440 --> 01:16:54.300 chris edwards: Oh!
1081 01:16:56.330 --> 01:17:03.450 chris edwards: I've got… If you click on the chat, do you see something which says, message everyone?
1082 01:17:03.450 --> 01:17:04.200 Andrew Clegg: Yes.
1083 01:17:04.200 --> 01:17:06.530 Graham Stoddart-Stones: And then below that, there are 4 icons.
1084 01:17:08.230 --> 01:17:11.329 Stuart Bacon: See, a smiley face.
1085 01:17:11.670 --> 01:17:12.160 chris edwards: No.
1086 01:17:12.580 --> 01:17:15.590 chris edwards: No, no, don't have anything of that sort.
1087 01:17:16.220 --> 01:17:16.760 Graham Stoddart-Stones: Bye.
1088 01:17:18.080 --> 01:17:18.830 chris edwards: Right.
1089 01:17:19.230 --> 01:17:22.140 chris edwards: I think… I think I need a whiskey and soda.
1090 01:17:24.650 --> 01:17:27.220 chris edwards: What a way to start the weekend.
1091 01:17:28.540 --> 01:17:30.889 Graham Stoddart-Stones: Any other points anyone wants to share?
1092 01:17:31.020 --> 01:17:31.770 chris edwards: No.
1093 01:17:32.160 --> 01:17:34.399 Graham Stoddart-Stones: Gentlemen, I've had a lot of fun, thank you very much.
1094 01:17:35.110 --> 01:17:37.500 Graham Stoddart-Stones: Pleasure to see you all. See you next week.
1095 01:17:37.500 --> 01:17:39.349 chris edwards: Okay, thank you ever so much, everyone.
1096 01:17:39.350 --> 01:17:41.840 Graham Stoddart-Stones: Ryan, have a good snooze, Andrew.
1097 01:17:41.840 --> 01:17:48.399 Andrew Clegg: Yeah. Next week, unfortunately, I'm with my brother. I don't think I'll be back. I'm meeting him from the station.
1098 01:17:48.400 --> 01:17:48.890 chris edwards: So…
1099 01:17:48.890 --> 01:17:50.970 Andrew Clegg: Right. I don't know what'll happen next week.
1100 01:17:51.280 --> 01:17:51.660 Graham Stoddart-Stones: Dear.
1101 01:17:52.310 --> 01:17:52.830 Andrew Clegg: Yeah.
1102 01:17:52.830 --> 01:17:53.780 Graham Stoddart-Stones: Take care.
1103 01:17:53.780 --> 01:17:54.470 Andrew Clegg: Bye-bye.
Last updated