> For the complete documentation index, see [llms.txt](https://chagos.gitbook.io/parish-online/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://chagos.gitbook.io/parish-online/parish-online-banter-sessions/250912-12sep25-session-25-37.md).

# 250912 12Sep25 session 25-37

Grit Bins and spreadsheet calcs for fullness, Watercourses, nodes and points, adding photos thereto

{% embed url="<https://youtu.be/kJ1Zbg53gpQ>" %}

### Video Timeline (min:secs) - very approximate!:

00:00 - 00:50 Banter&#x20;

00:50 - 40:00 Grit Bins - and associated spreadsheet work and calcs&#x20;

40:00 - 43:00 Banter&#x20;

43:00 - 53:00 Watercourses, Nodes, and attaching photos&#x20;

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.