> 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/260529-29may26-session-26-22.md).

# 260529 - 29May26 - session 26-22

grass maintenance, exporting data via Table View with metadata, Excel functions for editing large spreadsheets, importing data into Parish Online using the Helpdesk

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

#### Video Timeline (min:sec)

00:00 - 01:30 Introductory banter

01:30 - 85:28 (end) Manipulating grass mowing data layers, exporting data to spreadsheet including metadata, manipulating large spreadsheets, sending to Parish Online helpdesk for re-import

***

#### Presentation:

No presentation this week - the video says it all!

***

#### Meeting Summary:

May 29, 2026 01:59 PM London ID: 897 5877 7706

### Quick recap

The meeting focused on helping Scott restructure his grass maintenance data layers for Bridgewater from three teams to four quadrants. Graham, Stuart, and Andrew guided Scott through the process of exporting data from his current three-layer system, creating new fields for team identification and quarter names, and using Excel formulas to assign quadrants based on coordinate calculations. The team worked through the technical steps of creating formulas to determine north-south and east-west boundaries, filtering data, and organizing it into a combined spreadsheet format that could be easily imported by Geosphere to create four separate layers representing each quadrant of the town. Scott learned how to use table view, export data with metadata, and create the necessary formulas to categorize his grass maintenance areas into northeast, northwest, southeast, and southwest quadrants, which would allow different teams to access only their relevant areas through public map links.

### Next steps

#### Scott

* Send the combined spreadsheet (with "combined" tab) to Parish Online support, requesting creation of four new layers per quarter based on column E (quarter name), and confirm that each team will only be given access to the relevant quadrant layer.
* After new layers are created, review the data in Parish Online to ensure correct allocation of areas to each quadrant, and manually adjust any polygons/areas that need to be moved between layers (e.g., due to road boundaries or operational requirements).
* Once layers are finalized, generate and distribute public URLs for each quadrant layer to the respective operational teams, ensuring each team only receives access to their assigned quadrant.
* If further boundary adjustments are needed after initial upload, edit the layer details directly in Parish Online to reflect operational requirements.

### Summary

### Grass Maintenance Team Restructuring Plan

Scott discussed plans to restructure grass maintenance teams by splitting Bridgewater into four quarters and redistributing work across teams. Graham and Stuart provided guidance on how to export data from the current three-layer system to a spreadsheet, where Scott could reorganize and add new fields for team assignments and quarter allocations. The team agreed to use table view to efficiently add new columns for team names and quarter designations before importing the updated data back into the system.

### Record Division Strategy Discussion

The team discussed how to organize and divide 967 records into quarters for different urban areas. Graham suggested exporting the data to a spreadsheet, dividing the map into quarters using coordinates, and sending the coordinates to GeoSphere to sort the records accordingly. They determined that filtering by area was not possible without first populating the required designation field, which needed to be done through the admin bar. The conversation ended with instructions to properly export the data including metadata and sort by centroid.

### Map Quadrant Coordinate System Development

The team worked on creating a system to divide a map into four quarters based on coordinate data. They discussed adding horizontal and vertical lines to a map and using spreadsheet formulas to determine which areas fall into each quadrant. Scott and the others worked through creating formulas to categorize data points as either North (N) or South (S) based on coordinate values, though they encountered some challenges with the formula implementation. The discussion included determining the appropriate coordinate thresholds for dividing the map into quarters, with specific focus on using the M2 and N2 columns in their spreadsheet to make these determinations.

### Spreadsheet Error Correction Meeting

The team identified and corrected an error in a number (3:70 instead of 3:30) in their spreadsheet calculations. They worked through updating formulas and creating a new column in U2 to concatenate data from both north-south and east-west quadrants using the CONCAT function. Scott confirmed that the Southwest area was correctly identified based on his knowledge of the urban layer data.

### Urban Data Organization Project

The team worked on organizing data into quadrants and creating an urban team section in a spreadsheet. They discussed how to properly format and copy data, including using control and shift commands for copying and filtering. They identified some missing or blank data points that needed to be addressed, and decided to save the work as a single spreadsheet with an "urban" tab rather than creating multiple separate spreadsheets.

### Geographic Data Restructuring Project

The team worked on creating a spreadsheet to restructure geographic data for four quadrants of a town, moving from a team-based organization to a quadrant-based system. Scott, Stuart, and Graham collaborated to extract data from maps, format it in Excel, and prepare it for submission to Parish Online to create four separate layers for each quadrant. They finalized an email to send to Parish Online requesting the creation of these four new layers based on the attached spreadsheet, with specific instructions to use the "combined" tab and reference column E for quadrant identification.

***

#### Chat:

No chat used this week

***

#### Audio-transcript:

7
\
00:01:56.670 --> 00:02:00.670
\
Graham Stoddart-Stones: Scott, that's the most unusual screen I've seen.

8
\
00:02:01.530 --> 00:02:02.769
\
Graham Stoddart-Stones: There you go.

9
\
00:02:04.370 --> 00:02:05.430
\
Scott Mason: How are you?

10
\
00:02:05.430 --> 00:02:12.110
\
Graham Stoddart-Stones: Well, I think we're in for a blasting, because you only ever arrive when there's something really, really crucial to look at.

11
\
00:02:12.110 --> 00:02:13.839
\
Scott Mason: I just told the team that.

12
\
00:02:13.840 --> 00:02:17.869
\
Graham Stoddart-Stones: Well, how are you?

13
\
00:02:17.870 --> 00:02:22.600
\
Scott Mason: Yeah, good, thank you. Sorry, it's been a while, hasn't it? But that means all has been well.

14
\
00:02:22.600 --> 00:02:23.630
\
Graham Stoddart-Stones: Wow.

15
\
00:02:25.270 --> 00:02:27.469
\
Graham Stoddart-Stones: Well, is it nice and cool in your office?

16
\
00:02:27.470 --> 00:02:29.080
\
Scott Mason: No, it's not, actually, no.

17
\
00:02:29.490 --> 00:02:34.240
\
Scott Mason: We're at the top floor of the town hall, and it's, yeah, it's quite warm. I'll bet.

18
\
00:02:34.240 --> 00:02:38.220
\
Graham Stoddart-Stones: You probably remember Andrew, who's in Martok, not that far from you.

19
\
00:02:38.220 --> 00:02:39.070
\
Scott Mason: Yeah.

20
\
00:02:39.070 --> 00:02:40.880
\
Andrew Clegg: Are you at Taunton, aren't you, Scott? Is that right?

21
\
00:02:40.880 --> 00:02:41.530
\
Scott Mason: daughter.

22
\
00:02:41.530 --> 00:02:42.390
\
Andrew Clegg: Bridgewater.

23
\
00:02:42.390 --> 00:02:44.739
\
Scott Mason: Yeah, yeah, not, not far.

24
\
00:02:44.740 --> 00:02:45.170
\
Andrew Clegg: Yeah.

25
\
00:02:45.170 --> 00:02:48.499
\
Graham Stoddart-Stones: I'm being visited by my daughter, who lives there, so…

26
\
00:02:49.050 --> 00:02:52.759
\
Graham Stoddart-Stones: She's going to be very chuffed to know that you were calling from Bridgewater.

27
\
00:02:53.740 --> 00:02:55.869
\
Graham Stoddart-Stones: So, Scott, the floor is yours.

28
\
00:02:55.890 --> 00:03:04.269
\
Scott Mason: Thank you. Right, let me just start by sharing my screen. Bear with me. I'm not a big user of Zoom, so I'll probably only actually use it for this meeting, actually.

29
\
00:03:06.030 --> 00:03:13.089
\
Graham Stoddart-Stones: So if you go down the bottom of the screen with your mouse, it'll pop up with a green share button.

30
\
00:03:13.520 --> 00:03:18.139
\
Scott Mason: Fine, got it. Let me just choose the right… it always throws me when there's so many options of which screen to share, because I've got.

31
\
00:03:18.140 --> 00:03:20.370
\
Graham Stoddart-Stones: I know. You've got 3 up running.

32
\
00:03:20.370 --> 00:03:21.550
\
Scott Mason: Yeah, and I've got…

33
\
00:03:21.750 --> 00:03:22.990
\
Graham Stoddart-Stones: Wonderful, yep.

34
\
00:03:22.990 --> 00:03:25.520
\
Scott Mason: Right. Is that okay? Can you see…

35
\
00:03:25.520 --> 00:03:28.559
\
Graham Stoddart-Stones: Well, you can see, you've started, haven't… there we go, we're there.

36
\
00:03:28.560 --> 00:03:29.160
\
Scott Mason: Okay.

37
\
00:03:29.690 --> 00:03:37.530
\
Scott Mason: So, the question I've got for you is, we've got lots of layers, and…

38
\
00:03:38.150 --> 00:03:50.729
\
Scott Mason: our grass functions are split over these three layers here. Okay. And they are… basically, they dictate different frequencies and different teams that basically carry out the work.

39
\
00:03:50.730 --> 00:03:51.090
\
Graham Stoddart-Stones: you know.

40
\
00:03:51.090 --> 00:03:53.490
\
Scott Mason: A blue team, a green team, and a red team, essentially.

41
\
00:03:53.750 --> 00:04:10.550
\
Scott Mason: And what we're looking at doing… what we would like to trial going forward is splitting the town of Bridgewater into quarters, and applying their grass rounds to each team per quarter, so effectively we'd be moving to four teams, and I wondered if there was an easy way of transferring

42
\
00:04:12.050 --> 00:04:23.400
\
Scott Mason: probably all of the data initially into a layer for the first quarter, and then I can strip out everything that isn't needed. Is there a way that we can… because the current data on the screen is split over three layers, is there a way of moving all of that

43
\
00:04:23.640 --> 00:04:25.070
\
Scott Mason: to another layer.

44
\
00:04:25.620 --> 00:04:28.840
\
Scott Mason: Without having to click on each parcel and duplicating it.

45
\
00:04:29.760 --> 00:04:35.899
\
Graham Stoddart-Stones: Do you, what happens if you export them all into spreadsheets and just put them all together in one spreadsheet?

46
\
00:04:36.330 --> 00:04:38.879
\
Scott Mason: I don't know, I haven't tried that. So would I…

47
\
00:04:39.080 --> 00:04:45.890
\
Graham Stoddart-Stones: So, if you go into Table View, so click on any one of the layers, or any one of them, yep.

48
\
00:04:46.640 --> 00:04:48.189
\
Graham Stoddart-Stones: Select your layer.

49
\
00:04:52.200 --> 00:04:53.630
\
Scott Mason: Okay, yep.

50
\
00:04:53.800 --> 00:04:58.559
\
Graham Stoddart-Stones: So, there we go. Now, down the bottom right, you've got an export button.

51
\
00:04:59.470 --> 00:05:01.910
\
Graham Stoddart-Stones: So you can send it all out to a spreadsheet.

52
\
00:05:02.080 --> 00:05:07.569
\
Graham Stoddart-Stones: Okay. And then sort them out, whichever, you know, give them whichever quarter they're going to be in to each one.

53
\
00:05:07.820 --> 00:05:08.480
\
Scott Mason: Right.

54
\
00:05:08.480 --> 00:05:17.979
\
Graham Stoddart-Stones: And then, I would strongly recommend, Scott, that you send the resulting spreadsheet to the help desk and say, please, would you import this for me?

55
\
00:05:18.340 --> 00:05:19.230
\
Scott Mason: Oh, okay, once we.

56
\
00:05:19.230 --> 00:05:22.370
\
Graham Stoddart-Stones: And you can have it… you can have it all in one layer if you want to.

57
\
00:05:22.500 --> 00:05:25.849
\
Graham Stoddart-Stones: Hi, Stuart. Well, Stuart might give you a distant answer.

58
\
00:05:26.420 --> 00:05:34.170
\
Scott Mason: I'm just… I'm just wondering how I'm… from a spreadsheet, how I'm gonna pick out what the pieces of land are, and how easy that's gonna be to do.

59
\
00:05:34.780 --> 00:05:44.830
\
Graham Stoddart-Stones: That… isn't that a good question? You can… presumably the quarters that they're in at the moment are on there somewhere. How do you show which quarter people are in? Do you…

60
\
00:05:45.090 --> 00:05:45.710
\
Graham Stoddart-Stones: Go back.

61
\
00:05:45.710 --> 00:05:47.349
\
Scott Mason: And let me go back to…

62
\
00:05:47.350 --> 00:05:52.879
\
Graham Stoddart-Stones: Go back into the regular item, just go into any one, record.

63
\
00:05:52.880 --> 00:06:00.270
\
Scott Mason: So if I turn on Parks Team 1, see, it's split, this is what they cover across the whole of Bridgewater. If all of a sudden they're just gonna do this.

64
\
00:06:00.270 --> 00:06:07.520
\
Graham Stoddart-Stones: I'm sorry, what I meant was… oh, I see what you're saying, it doesn't specify which particular layer. No. Right.

65
\
00:06:08.650 --> 00:06:17.730
\
Graham Stoddart-Stones: That's a very good question. What you could do is… create… a…

66
\
00:06:18.030 --> 00:06:31.149
\
Graham Stoddart-Stones: a field which you add to the layers of the quarter, and neither the quarter that they're in at the moment, or the one that you want them to be in in the future. I suggest the latter. So, have quarter one, two, three, and four?

67
\
00:06:31.410 --> 00:06:32.880
\
Scott Mason: So how would I do that?

68
\
00:06:33.350 --> 00:06:40.819
\
Graham Stoddart-Stones: If you go in… I'm just think… let me think this through a bit further, because I'm not sure I've already got it right.

69
\
00:06:41.550 --> 00:06:44.560
\
Graham Stoddart-Stones: I think what you'd have to do…

70
\
00:06:45.560 --> 00:06:48.900
\
Graham Stoddart-Stones: Is go to each of those areas in turn.

71
\
00:06:49.210 --> 00:06:49.770
\
Scott Mason: Yeah.

72
\
00:06:49.940 --> 00:06:55.919
\
Graham Stoddart-Stones: So, and the ones in the bottom left, you allocate to Quarter 4, and the ones in the top right, you allocate to Quarter 1.

73
\
00:06:56.360 --> 00:06:57.170
\
Scott Mason: Yes.

74
\
00:06:57.170 --> 00:07:05.820
\
Graham Stoddart-Stones: then you know which one belongs in which area, and you can allocate… do they have a contractor name or ID in there?

75
\
00:07:06.020 --> 00:07:06.850
\
Scott Mason: they've got…

76
\
00:07:07.160 --> 00:07:09.070
\
Graham Stoddart-Stones: What have they got? Not much.

77
\
00:07:09.070 --> 00:07:10.300
\
Scott Mason: Not much, no.

78
\
00:07:10.300 --> 00:07:11.689
\
Graham Stoddart-Stones: Wow, in fact, nothing.

79
\
00:07:11.870 --> 00:07:15.129
\
Graham Stoddart-Stones: How do you know which one is which? Oh, because they've got Team 1 as the name.

80
\
00:07:15.130 --> 00:07:15.929
\
Scott Mason: Yeah, tease.

81
\
00:07:15.930 --> 00:07:16.689
\
Graham Stoddart-Stones: Oh, okay. I just know.

82
\
00:07:16.690 --> 00:07:17.220
\
Scott Mason: it's.

83
\
00:07:17.220 --> 00:07:31.599
\
Graham Stoddart-Stones: If I were you, if I were you, Scott, I would like to… and again, Stuart, jump in if you don't think so. I would suggest you go into each of those layers, one by one, allocate A a team number, existing team number.

84
\
00:07:31.770 --> 00:07:37.220
\
Graham Stoddart-Stones: to each layer, and B, the new quarter you want it to be in.

85
\
00:07:37.220 --> 00:07:37.820
\
Scott Mason: Okay.

86
\
00:07:37.820 --> 00:07:38.860
\
Graham Stoddart-Stones: to each layer.

87
\
00:07:39.030 --> 00:07:42.660
\
Graham Stoddart-Stones: Do you know about adding new fields to an existing layer?

88
\
00:07:42.660 --> 00:07:48.110
\
Scott Mason: Yeah, that's fine, I know how to do that. I guess the thing that daunts me a little bit is the quantity on this round, the Urban Team.

89
\
00:07:48.110 --> 00:07:48.769
\
Graham Stoddart-Stones: Look up again.

90
\
00:07:48.770 --> 00:07:49.570
\
Scott Mason: parcels.

91
\
00:07:49.570 --> 00:07:50.810
\
Graham Stoddart-Stones: Every single one.

92
\
00:07:50.810 --> 00:07:52.179
\
Scott Mason: Every single one.

93
\
00:07:52.180 --> 00:07:53.700
\
Graham Stoddart-Stones: Oh, but you know what you can do?

94
\
00:07:53.700 --> 00:07:56.430
\
Stuart Bacon: The easier way to do that is do that in table view.

95
\
00:07:56.650 --> 00:07:58.020
\
Stuart Bacon: Exactly.

96
\
00:07:58.020 --> 00:08:03.370
\
Graham Stoddart-Stones: I was about to say that. So if you go into TableView… oh, sorry, let's create the two new columns first, Scott.

97
\
00:08:03.370 --> 00:08:05.400
\
Scott Mason: Okay, so let's go up to.

98
\
00:08:05.400 --> 00:08:08.189
\
Graham Stoddart-Stones: I know you're into admin, yeah, absolutely.

99
\
00:08:08.190 --> 00:08:11.460
\
Scott Mason: to… So we start with the urban, then, because that's the big one.

100
\
00:08:11.950 --> 00:08:12.620
\
Graham Stoddart-Stones: Right.

101
\
00:08:12.620 --> 00:08:14.260
\
Scott Mason: Glass Urban Team.

102
\
00:08:14.690 --> 00:08:19.870
\
Scott Mason: And then I wanna edit… And I want to add a column, so…

103
\
00:08:19.870 --> 00:08:23.379
\
Stuart Bacon: I'd do one for team… team name.

104
\
00:08:24.180 --> 00:08:28.120
\
Graham Stoddart-Stones: It's actually one for area name, or quarter name. Yep.

105
\
00:08:28.660 --> 00:08:31.630
\
Scott Mason: And then, so this is where it's going to become, it's going to be the new quarter name, isn't it?

106
\
00:08:31.630 --> 00:08:32.829
\
Graham Stoddart-Stones: Right, yes, exactly.

107
\
00:08:32.830 --> 00:08:34.669
\
Scott Mason: Have I spot it right? Quarter…

108
\
00:08:34.679 --> 00:08:35.269
\
Graham Stoddart-Stones: Yeah.

109
\
00:08:36.710 --> 00:08:37.030
\
Scott Mason: Okay.

110
\
00:08:37.319 --> 00:08:38.129
\
Graham Stoddart-Stones: Good.

111
\
00:08:38.459 --> 00:08:39.059
\
Graham Stoddart-Stones: So…

112
\
00:08:40.130 --> 00:08:43.899
\
Stuart Bacon: And they said, yeah, they're, they're techs, that's fine.

113
\
00:08:44.560 --> 00:08:47.569
\
Graham Stoddart-Stones: And go back into the maps, go back into table view.

114
\
00:08:48.410 --> 00:08:50.079
\
Graham Stoddart-Stones: For a new layer that you're in.

115
\
00:08:52.760 --> 00:08:55.520
\
Scott Mason: It's a bit slow, I've got lots running on my other…

116
\
00:08:55.520 --> 00:08:58.819
\
Graham Stoddart-Stones: Yeah, yeah, you're just, just, are you sure how important you are.

117
\
00:08:58.820 --> 00:09:02.110
\
Scott Mason: I've got CCTV showing on another screen, I'm just gonna turn that off.

118
\
00:09:02.310 --> 00:09:03.360
\
Scott Mason: Okay.

119
\
00:09:04.440 --> 00:09:09.759
\
Graham Stoddart-Stones: Right. You have to recognize, Scott, that you're three times the speed of most other people who are on board.

120
\
00:09:09.760 --> 00:09:12.819
\
Scott Mason: No comment.

121
\
00:09:12.820 --> 00:09:15.379
\
Graham Stoddart-Stones: Well, you've probably got nice internet access.

122
\
00:09:16.650 --> 00:09:19.649
\
Graham Stoddart-Stones: So, if you choose a layer, choose your team one…

123
\
00:09:19.650 --> 00:09:20.690
\
Scott Mason: table view now.

124
\
00:09:20.690 --> 00:09:23.200
\
Graham Stoddart-Stones: Yeah, whichever the urban area you're on, wasn't it?

125
\
00:09:23.200 --> 00:09:23.870
\
Stuart Bacon: Thank you, Governor.

126
\
00:09:23.870 --> 00:09:24.500
\
Scott Mason: Yeah, what's happening?

127
\
00:09:25.170 --> 00:09:27.099
\
Graham Stoddart-Stones: So, select the urban layer.

128
\
00:09:27.860 --> 00:09:34.240
\
Graham Stoddart-Stones: The urban team was the one you were in, wasn't it? So now you know everything in here, so if you now go into table view.

129
\
00:09:36.530 --> 00:09:37.200
\
Scott Mason: Here.

130
\
00:09:37.640 --> 00:09:43.510
\
Graham Stoddart-Stones: No, well, yeah, that'll do, but actually you aren't there. Yes, go to the review, that's it, yeah.

131
\
00:09:43.700 --> 00:09:47.710
\
Graham Stoddart-Stones: So, now you've got the two new records.

132
\
00:09:47.820 --> 00:09:53.850
\
Graham Stoddart-Stones: On the left-hand side, team name, importer name, so…

133
\
00:09:54.460 --> 00:09:58.660
\
Graham Stoddart-Stones: The team name, you can just say, is whatever it is. It's one, is it, or Urban? Urban.

134
\
00:09:58.830 --> 00:09:59.620
\
Scott Mason: Urban, yeah.

135
\
00:09:59.620 --> 00:10:02.509
\
Graham Stoddart-Stones: So just type in, click there, and type in the word urban.

136
\
00:10:03.800 --> 00:10:05.059
\
Scott Mason: Into this one.

137
\
00:10:05.060 --> 00:10:05.760
\
Graham Stoddart-Stones: Yes.

138
\
00:10:06.310 --> 00:10:07.220
\
Scott Mason: Yeah.

139
\
00:10:07.220 --> 00:10:08.510
\
Graham Stoddart-Stones: Yeah, exactly.

140
\
00:10:08.510 --> 00:10:08.920
\
Scott Mason: Yep.

141
\
00:10:08.920 --> 00:10:13.459
\
Stuart Bacon: Looks like designation is a required field.

142
\
00:10:14.310 --> 00:10:18.699
\
Scott Mason: Oh, okay, I can't edit that in the admin bar, can't I?

143
\
00:10:18.700 --> 00:10:19.440
\
Stuart Bacon: Yes.

144
\
00:10:20.090 --> 00:10:21.390
\
Scott Mason: Do I need to do that first, then?

145
\
00:10:21.390 --> 00:10:25.340
\
Stuart Bacon: You need, yeah, you'll need to do that first, otherwise it won't let you save anything.

146
\
00:10:31.330 --> 00:10:40.250
\
Scott Mason: No, that won't… Columns… designation… is that right?

147
\
00:10:40.250 --> 00:10:42.700
\
Graham Stoddart-Stones: Yes, exactly, yeah. Hold on.

148
\
00:10:43.530 --> 00:10:45.200
\
Scott Mason: Let's see, still remember.

149
\
00:10:46.550 --> 00:10:48.479
\
Scott Mason: It's a long time since I've done some of this.

150
\
00:10:48.660 --> 00:10:53.409
\
Scott Mason: Right, okay, and then go back to urban and Table View.

151
\
00:10:53.410 --> 00:10:54.320
\
Graham Stoddart-Stones: Correct.

152
\
00:10:59.640 --> 00:11:02.400
\
Scott Mason: Oh, no, wrong one, getting too confident now.

153
\
00:11:02.540 --> 00:11:03.480
\
Graham Stoddart-Stones: That one.

154
\
00:11:04.070 --> 00:11:05.030
\
Scott Mason: Okay.

155
\
00:11:06.100 --> 00:11:08.559
\
Graham Stoddart-Stones: So, each of those you call urban.

156
\
00:11:08.720 --> 00:11:09.310
\
Scott Mason: Yep.

157
\
00:11:10.270 --> 00:11:13.029
\
Graham Stoddart-Stones: Oh, God, you gotta do it all those times?

158
\
00:11:13.150 --> 00:11:16.299
\
Graham Stoddart-Stones: How many of those are there? 967!

159
\
00:11:16.410 --> 00:11:18.110
\
Scott Mason: Yeah.

160
\
00:11:18.110 --> 00:11:22.679
\
Graham Stoddart-Stones: Oh, oh dear. You… you really do want to… oh, dear.

161
\
00:11:23.140 --> 00:11:24.950
\
Scott Mason: Is there no way I can apply it to all?

162
\
00:11:25.700 --> 00:11:44.919
\
Graham Stoddart-Stones: No, that's the… funny enough, we were talking last week to, Tristram, who's the chairman of Geosphere, and saying, this is the longest request we've had open, and no one has answered it yet, but we wanted to do a block thing. So I think, now that you've created those two,

163
\
00:11:45.260 --> 00:11:46.300
\
Graham Stoddart-Stones: Fields.

164
\
00:11:46.690 --> 00:11:49.520
\
Graham Stoddart-Stones: Scott, I think you need to,

165
\
00:11:50.790 --> 00:11:53.440
\
Graham Stoddart-Stones: Export it all to a spreadsheet.

166
\
00:11:55.110 --> 00:12:01.810
\
Graham Stoddart-Stones: The quarter name is a real pain, identifying which quarter is… oh, you only know which quarter it is by looking at the map first, don't you?

167
\
00:12:01.810 --> 00:12:02.920
\
Scott Mason: Yeah, yep.

168
\
00:12:02.920 --> 00:12:04.240
\
Graham Stoddart-Stones: It's a real pain.

169
\
00:12:04.880 --> 00:12:09.710
\
Graham Stoddart-Stones: And each quarter… oh, sorry, each one of those color ones for urban…

170
\
00:12:09.850 --> 00:12:12.230
\
Graham Stoddart-Stones: Yeah. Would be in a different place.

171
\
00:12:12.230 --> 00:12:12.910
\
Scott Mason: Correct.

172
\
00:12:12.910 --> 00:12:15.870
\
Graham Stoddart-Stones: So, have we got the entire layer here?

173
\
00:12:16.590 --> 00:12:17.310
\
Scott Mason: Yes.

174
\
00:12:17.530 --> 00:12:20.659
\
Graham Stoddart-Stones: So you can't go into any one of those individual spots.

175
\
00:12:23.080 --> 00:12:26.359
\
Graham Stoddart-Stones: So, just go into an individual… yeah, that one there.

176
\
00:12:31.440 --> 00:12:38.410
\
Graham Stoddart-Stones: So I was thinking you could put the quarter in, but you're gonna have to… how many quarters are there? I mean, sorry, I don't mean how many records? 967 records, blindly.

177
\
00:12:38.490 --> 00:12:39.420
\
Scott Mason: Yeah.

178
\
00:12:39.570 --> 00:12:40.530
\
Graham Stoddart-Stones: Instead of, like, a keyboard.

179
\
00:12:40.530 --> 00:12:42.350
\
Scott Mason: Shortcut where you can select.

180
\
00:12:42.350 --> 00:12:49.000
\
Graham Stoddart-Stones: No, no, you know what you want to do, you, oh, God.

181
\
00:12:49.000 --> 00:12:56.899
\
Scott Mason: That's all I could think of doing otherwise, but it's still a very manual task, is clicking on a parcel, and then copying it to another layer, but we're gonna have to do that 900 times.

182
\
00:12:57.290 --> 00:12:57.869
\
Graham Stoddart-Stones: No, you…

183
\
00:12:57.870 --> 00:12:59.529
\
Scott Mason: Create a layer for each zone.

184
\
00:13:00.160 --> 00:13:07.319
\
Graham Stoddart-Stones: I think this is very simply done on the original database. I think what you want to do is to…

185
\
00:13:17.290 --> 00:13:20.230
\
Graham Stoddart-Stones: Export the whole thing to a spreadsheet.

186
\
00:13:21.120 --> 00:13:28.109
\
Graham Stoddart-Stones: Alright, then look at the map and say, and you can do this with a line.

187
\
00:13:28.630 --> 00:13:31.239
\
Graham Stoddart-Stones: And divide the screen into quarters.

188
\
00:13:31.430 --> 00:13:32.010
\
Scott Mason: Yeah.

189
\
00:13:32.010 --> 00:13:37.740
\
Graham Stoddart-Stones: And then say everything from coordinate X to coordinate Y is in quarter one.

190
\
00:13:38.280 --> 00:13:46.680
\
Graham Stoddart-Stones: And this is just you're going to have to write this down for… and then send it to, Geosphere, saying, could you please, Mark.

191
\
00:13:47.000 --> 00:13:54.499
\
Graham Stoddart-Stones: All the records in the spreadsheet in these… so, give… The coordinates in this quarter.

192
\
00:13:55.670 --> 00:14:09.169
\
Graham Stoddart-Stones: the quarter one, and then quarter two, quarter three, quarter four, and you send them the coordinates, because it's very easy for them to sort the database into the coordinates in order, and then they can just easily divide between, you know, 1 and 4.

193
\
00:14:09.170 --> 00:14:10.220
\
Scott Mason: Yeah, yeah, no.

194
\
00:14:10.220 --> 00:14:13.130
\
Graham Stoddart-Stones: At the same time,

195
\
00:14:13.400 --> 00:14:25.230
\
Graham Stoddart-Stones: If you have one spreadsheet for each of the teams, so you can say all the records in this field are to be called Group 1, or Urban, rather.

196
\
00:14:25.620 --> 00:14:29.900
\
Graham Stoddart-Stones: Again, Oh, actually, no, you can do that in the spreadsheet yourself.

197
\
00:14:30.100 --> 00:14:32.669
\
Graham Stoddart-Stones: So, before you send the spreadsheet to them.

198
\
00:14:32.830 --> 00:14:35.960
\
Graham Stoddart-Stones: Put all the urban in one column.

199
\
00:14:36.900 --> 00:14:38.209
\
Graham Stoddart-Stones: In the team name.

200
\
00:14:38.510 --> 00:14:39.060
\
Scott Mason: Yep.

201
\
00:14:39.060 --> 00:14:47.679
\
Graham Stoddart-Stones: Then send it to them in saying, please, here are the coordinates that I want to divide this up to, and coordinates 1 contain this area.

202
\
00:14:49.720 --> 00:14:54.450
\
Graham Stoddart-Stones: And you can probably do that with extent, can't you? It's an interesting question.

203
\
00:14:56.190 --> 00:15:15.259
\
Graham Stoddart-Stones: I think I would just put in a quick layer with a dividing line down the middle and a dividing line horizontally along the middle, and you've got each of your quarters, and then say, you know, here are the coordinates of these quarters, please put the records that fall into that quarter, in area 1, and so forth.

204
\
00:15:15.470 --> 00:15:19.800
\
Graham Stoddart-Stones: And then ask them to re-import it for you, because you're not allowed to re-import yet.

205
\
00:15:20.090 --> 00:15:20.700
\
Scott Mason: Okay.

206
\
00:15:20.700 --> 00:15:23.530
\
Graham Stoddart-Stones: I honestly don't see any other way.

207
\
00:15:23.700 --> 00:15:27.559
\
Scott Mason: There's nothing under the filter function at all, is there, that might help here?

208
\
00:15:28.100 --> 00:15:31.190
\
Graham Stoddart-Stones: I don't think you can filter on area.

209
\
00:15:31.190 --> 00:15:31.930
\
Scott Mason: No.

210
\
00:15:32.270 --> 00:15:34.060
\
Graham Stoddart-Stones: You can… no, you've…

211
\
00:15:34.600 --> 00:15:37.439
\
Stuart Bacon: You can only filter by the fields you've defined.

212
\
00:15:37.730 --> 00:15:42.119
\
Scott Mason: Oh, okay. Which, which, like you say, deeply populated.

213
\
00:15:42.120 --> 00:15:49.540
\
Stuart Bacon: Yeah, that's not sort of helpful for you, but once you… if you go into the table view, and export it to a spreadsheet.

214
\
00:15:50.030 --> 00:15:57.329
\
Stuart Bacon: that, in itself, you can see, I mean, even there, you can see where the,

215
\
00:15:58.030 --> 00:16:00.899
\
Stuart Bacon: The data is on the… on the right-hand side.

216
\
00:16:01.440 --> 00:16:03.210
\
Stuart Bacon: Yeah, true, yeah.

217
\
00:16:03.210 --> 00:16:06.050
\
Graham Stoddart-Stones: Well, I guess you could do the centering yourself, couldn't you?

218
\
00:16:06.530 --> 00:16:16.460
\
Graham Stoddart-Stones: If you can sort the spreadsheet into, I would say, probably the centered area, So, do the export, Scott.

219
\
00:16:16.750 --> 00:16:18.369
\
Graham Stoddart-Stones: Have you done the export yet?

220
\
00:16:18.370 --> 00:16:19.230
\
Scott Mason: Yeah.

221
\
00:16:19.530 --> 00:16:22.330
\
Graham Stoddart-Stones: Okay, so why don't we open that up and play with it a bit?

222
\
00:16:26.510 --> 00:16:28.360
\
Graham Stoddart-Stones: Can you open it as a spreadsheet?

223
\
00:16:28.680 --> 00:16:29.559
\
Stuart Bacon: It's just opening.

224
\
00:16:29.560 --> 00:16:30.210
\
Scott Mason: Yeah.

225
\
00:16:30.210 --> 00:16:32.690
\
Graham Stoddart-Stones: Oh, is this operating at the speed of light again?

226
\
00:16:34.710 --> 00:16:37.130
\
Graham Stoddart-Stones: So, looks like…

227
\
00:16:37.130 --> 00:16:38.629
\
Scott Mason: Should it display like this?

228
\
00:16:39.340 --> 00:16:41.009
\
Graham Stoddart-Stones: Yeah, can you… you need to go…

229
\
00:16:41.010 --> 00:16:46.800
\
Stuart Bacon: you display a CSV file, I guess, initially to come out, but where's the rest of…

230
\
00:16:46.800 --> 00:16:49.530
\
Graham Stoddart-Stones: You need to slide red. Can you, can you go left?

231
\
00:16:50.260 --> 00:16:50.770
\
Scott Mason: But…

232
\
00:16:50.770 --> 00:16:55.869
\
Stuart Bacon: It is left, that's as far left as there is. There's only 5 columns worth of data there.

233
\
00:16:56.240 --> 00:17:00.569
\
Stuart Bacon: Okay, yeah, you've got, 900 and some odd.

234
\
00:17:01.190 --> 00:17:04.880
\
Stuart Bacon: Rows, but you've only got 5 columns worth of…

235
\
00:17:05.010 --> 00:17:06.450
\
Scott Mason: Yeah, that's what we populated it with.

236
\
00:17:06.450 --> 00:17:16.919
\
Graham Stoddart-Stones: Sorry, when you do the export, I beg your pardon, that's my fault. When you do the export, Tom, kill this spreadsheet. It's not of any use to you, so just get rid of it, yeah.

237
\
00:17:17.099 --> 00:17:23.930
\
Graham Stoddart-Stones: Now do the export again, but this time check the box marked No.

238
\
00:17:23.930 --> 00:17:25.010
\
Scott Mason: CSV still?

239
\
00:17:25.230 --> 00:17:29.320
\
Graham Stoddart-Stones: Yeah, it should be… it should ask you for metadata. Yes, include metadata, that's it.

240
\
00:17:29.490 --> 00:17:32.019
\
Graham Stoddart-Stones: That's what you need. Now, you should get everything now.

241
\
00:17:39.210 --> 00:17:40.349
\
Graham Stoddart-Stones: Yeah, me too.

242
\
00:17:40.530 --> 00:17:50.040
\
Graham Stoddart-Stones: Right, so… If you were to, select all the records, And…

243
\
00:17:50.660 --> 00:17:55.120
\
Graham Stoddart-Stones: I would think you should probably be able to sort on Centroid.

244
\
00:17:55.120 --> 00:17:56.470
\
Stuart Bacon: So, yeah.

245
\
00:17:56.470 --> 00:17:56.970
\
Graham Stoddart-Stones: Soleil.

246
\
00:17:56.970 --> 00:17:58.780
\
Stuart Bacon: Go to Data and Filter.

247
\
00:17:59.010 --> 00:17:59.680
\
Graham Stoddart-Stones: M.

248
\
00:18:00.330 --> 00:18:01.540
\
Stuart Bacon: I'd like to sort.

249
\
00:18:05.230 --> 00:18:08.960
\
Stuart Bacon: And then on your Centroid, you can… Yeah.

250
\
00:18:09.750 --> 00:18:12.649
\
Stuart Bacon: Go to I2Z, or whatever.

251
\
00:18:13.130 --> 00:18:14.390
\
Stuart Bacon: Yeah, it's Android.

252
\
00:18:18.300 --> 00:18:20.039
\
Graham Stoddart-Stones: That one? Yeah. Yup.

253
\
00:18:21.060 --> 00:18:21.939
\
Scott Mason: Is that okay?

254
\
00:18:24.230 --> 00:18:25.670
\
Graham Stoddart-Stones: Good. So…

255
\
00:18:26.310 --> 00:18:34.239
\
Graham Stoddart-Stones: If they're now all in centroid order, you can go back to your map and work out roughly where the centroids are for each quarter.

256
\
00:18:35.200 --> 00:18:38.179
\
Graham Stoddart-Stones: So, if you go back to the map.

257
\
00:18:38.830 --> 00:18:42.349
\
Graham Stoddart-Stones: Can you just add a quick layer, a new layer.

258
\
00:18:42.680 --> 00:18:46.210
\
Graham Stoddart-Stones: Which has two lines in it, a horizontal line and a vertical line.

259
\
00:18:46.590 --> 00:18:51.840
\
Graham Stoddart-Stones: Or just go to a line layer, let's put it that way. You've got a line layer already, a line existing?

260
\
00:18:52.070 --> 00:18:54.760
\
Scott Mason: I expect so. Yeah, I've got some here.

261
\
00:18:54.890 --> 00:18:56.040
\
Scott Mason: Just anyone?

262
\
00:18:56.040 --> 00:19:00.429
\
Graham Stoddart-Stones: You want one that doesn't have any records in it, so you're better off creating a new one, I think.

263
\
00:19:00.430 --> 00:19:01.159
\
Scott Mason: without any one of them.

264
\
00:19:01.160 --> 00:19:02.790
\
Graham Stoddart-Stones: Just creating your energy data.

265
\
00:19:02.920 --> 00:19:04.840
\
Graham Stoddart-Stones: So, geometry type is line.

266
\
00:19:05.300 --> 00:19:05.920
\
Scott Mason: Yeah.

267
\
00:19:07.750 --> 00:19:09.130
\
Graham Stoddart-Stones: There you go, yep.

268
\
00:19:09.500 --> 00:19:12.559
\
Scott Mason: Do we need any columns or not?

269
\
00:19:12.560 --> 00:19:14.480
\
Stuart Bacon: It will need one column in it.

270
\
00:19:14.480 --> 00:19:18.200
\
Graham Stoddart-Stones: Yeah, it won't work. Name is fine, that's right.

271
\
00:19:18.850 --> 00:19:19.610
\
Scott Mason: Just line?

272
\
00:19:19.890 --> 00:19:22.399
\
Graham Stoddart-Stones: No, discord… no, leave it as name.

273
\
00:19:22.790 --> 00:19:23.600
\
Scott Mason: Oh, okay.

274
\
00:19:23.910 --> 00:19:24.620
\
Scott Mason: Oops.

275
\
00:19:25.630 --> 00:19:27.569
\
Graham Stoddart-Stones: Employee-employment, yep.

276
\
00:19:29.780 --> 00:19:32.880
\
Graham Stoddart-Stones: So now, go back to the maps and open up the layer.

277
\
00:19:37.450 --> 00:19:41.480
\
Graham Stoddart-Stones: And… Yep.

278
\
00:19:41.830 --> 00:19:43.279
\
Graham Stoddart-Stones: And then, you record…

279
\
00:19:43.280 --> 00:19:45.090
\
Stuart Bacon: End up following the roads, do you?

280
\
00:19:45.260 --> 00:19:46.030
\
Graham Stoddart-Stones: And do…

281
\
00:19:46.030 --> 00:19:50.940
\
Scott Mason: Well, this is… I do need to pin down more accurately, once I know what I'm doing, where this divide's gonna go, but for now…

282
\
00:19:50.940 --> 00:19:56.279
\
Graham Stoddart-Stones: So you divide the line horizontally and vertically, yeah.

283
\
00:19:56.490 --> 00:19:57.070
\
Graham Stoddart-Stones: Perfect.

284
\
00:19:57.800 --> 00:19:58.210
\
Graham Stoddart-Stones: Exactly.

285
\
00:19:58.210 --> 00:20:00.140
\
Scott Mason: of this. Yeah.

286
\
00:20:00.140 --> 00:20:00.780
\
Graham Stoddart-Stones: Exactly.

287
\
00:20:00.780 --> 00:20:03.740
\
Stuart Bacon: Save, save that line before you stop… Oh, okay, yeah.

288
\
00:20:03.740 --> 00:20:05.160
\
Scott Mason: Of course. So, name…

289
\
00:20:05.180 --> 00:20:10.310
\
Graham Stoddart-Stones: Yeah, horizon. Horizontal, yes. That's good.

290
\
00:20:10.530 --> 00:20:11.980
\
Scott Mason: And so, save…

291
\
00:20:12.530 --> 00:20:14.049
\
Graham Stoddart-Stones: And do a lift to it? Yeah.

292
\
00:20:14.180 --> 00:20:15.739
\
Scott Mason: Hold on, don't see that…

293
\
00:20:21.810 --> 00:20:29.240
\
Graham Stoddart-Stones: So, if you plonk the mouse somewhere in the middle of each quarter, so just say, Yeah, that one.

294
\
00:20:29.510 --> 00:20:36.680
\
Graham Stoddart-Stones: And just, oh, you see the centroid there, so you're looking at 330756.

295
\
00:20:37.350 --> 00:20:38.810
\
Stuart Bacon: No, because that's…

296
\
00:20:39.260 --> 00:20:40.269
\
Graham Stoddart-Stones: Oh, that you…

297
\
00:20:40.270 --> 00:20:41.620
\
Stuart Bacon: centroid for the parish.

298
\
00:20:41.770 --> 00:20:43.869
\
Stuart Bacon: That's not pulling the centroid for…

299
\
00:20:43.870 --> 00:20:44.630
\
Graham Stoddart-Stones: No.

300
\
00:20:45.350 --> 00:20:53.470
\
Stuart Bacon: Because that's what… as it says, that's pulling the centroid for the parish layer. If you turn, go back to your,

301
\
00:20:55.840 --> 00:20:58.909
\
Stuart Bacon: Left-hand columns and whatever, and turn parish boundaries off.

302
\
00:21:00.370 --> 00:21:01.239
\
Graham Stoddart-Stones: Oh, yes.

303
\
00:21:01.360 --> 00:21:03.489
\
Graham Stoddart-Stones: All the way down. Long way down.

304
\
00:21:04.280 --> 00:21:05.350
\
Graham Stoddart-Stones: Boundaries.

305
\
00:21:07.020 --> 00:21:08.060
\
Stuart Bacon: You've gone past it.

306
\
00:21:08.320 --> 00:21:11.320
\
Scott Mason: Oh, boy. I was looking for one that was slightly colored differently, but…

307
\
00:21:11.320 --> 00:21:14.060
\
Stuart Bacon: It's just got the circle and the, yeah.

308
\
00:21:14.060 --> 00:21:15.230
\
Scott Mason: Got it. Okay.

309
\
00:21:15.230 --> 00:21:15.950
\
Stuart Bacon: There you go.

310
\
00:21:18.910 --> 00:21:19.470
\
Scott Mason: Not, mops.

311
\
00:21:19.470 --> 00:21:24.380
\
Stuart Bacon: And now you should be able to click on… the area.

312
\
00:21:24.380 --> 00:21:27.330
\
Graham Stoddart-Stones: Well, probably the area… Newtown is near enough, isn't it?

313
\
00:21:28.060 --> 00:21:29.200
\
Graham Stoddart-Stones: You would, you too.

314
\
00:21:29.200 --> 00:21:31.169
\
Scott Mason: I'm clicking, but it's not doing anything.

315
\
00:21:37.910 --> 00:21:38.699
\
Graham Stoddart-Stones: I'll be in a refund.

316
\
00:21:38.700 --> 00:21:42.339
\
Scott Mason: Is it… picking up my location, is that what it's… shall I turn on?

317
\
00:21:42.340 --> 00:21:44.940
\
Graham Stoddart-Stones: Yes, yes, turn off the G.

318
\
00:21:44.940 --> 00:21:47.179
\
Stuart Bacon: Bottom left-hand corner, on the three dots.

319
\
00:21:49.130 --> 00:21:53.870
\
Scott Mason: I wondered if it was… No, it's not changing either.

320
\
00:21:54.240 --> 00:21:55.389
\
Scott Mason: Maybe that is.

321
\
00:21:55.390 --> 00:22:01.660
\
Stuart Bacon: just F5… just F5, yeah, ukraine, and…

322
\
00:22:08.990 --> 00:22:10.450
\
Graham Stoddart-Stones: It needs to be related upon…

323
\
00:22:10.450 --> 00:22:13.560
\
Stuart Bacon: Turn those two layers back on the lines.

324
\
00:22:14.280 --> 00:22:19.119
\
Scott Mason: So that one? Yeah. And turn off the boundaries.

325
\
00:22:19.490 --> 00:22:20.030
\
Stuart Bacon: Yep.

326
\
00:22:22.540 --> 00:22:28.929
\
Graham Stoddart-Stones: Well, are you operating inside the boundary? Because if you need to stay inside your boundary, you'd probably need to have it there.

327
\
00:22:28.930 --> 00:22:32.229
\
Stuart Bacon: The… the red… the red lines and whatever.

328
\
00:22:32.230 --> 00:22:36.529
\
Graham Stoddart-Stones: No, of course they are, yes, you're absolutely right, yes, you're quite right, quite right.

329
\
00:22:38.930 --> 00:22:44.469
\
Graham Stoddart-Stones: So I think the word Newtown is not far… the word N, the N of Newtown, isn't that about the center?

330
\
00:22:45.340 --> 00:22:46.450
\
Scott Mason: Yeah, roughly.

331
\
00:22:47.600 --> 00:22:48.709
\
Scott Mason: I just can't get the cord.

332
\
00:22:48.710 --> 00:22:54.099
\
Graham Stoddart-Stones: Today's exercise. So, if you just put the cursor on the N, the first, the capital N, sorry.

333
\
00:22:55.450 --> 00:22:56.990
\
Graham Stoddart-Stones: Yep.

334
\
00:22:57.520 --> 00:23:01.750
\
Graham Stoddart-Stones: Okay, make a note of that number down the bottom, 329551.

335
\
00:23:02.300 --> 00:23:04.680
\
Scott Mason: Well, that number hasn't updated, has it? I don't think.

336
\
00:23:05.070 --> 00:23:11.069
\
Graham Stoddart-Stones: Oh, really? If you move the mouse, it doesn't move. Oh, you're on the… sorry, turn off the, throttle mask.

337
\
00:23:11.250 --> 00:23:13.860
\
Graham Stoddart-Stones: That white dot thing, yeah, turn it off.

338
\
00:23:14.680 --> 00:23:16.290
\
Graham Stoddart-Stones: That's all interesting.

339
\
00:23:17.650 --> 00:23:20.979
\
Graham Stoddart-Stones: Okay, so see where it's got the dot in the center?

340
\
00:23:20.980 --> 00:23:21.430
\
Scott Mason: Yeah.

341
\
00:23:21.430 --> 00:23:22.819
\
Graham Stoddart-Stones: Yeah, turn that off.

342
\
00:23:23.190 --> 00:23:24.269
\
Graham Stoddart-Stones: There we go.

343
\
00:23:24.590 --> 00:23:26.229
\
Graham Stoddart-Stones: And today.

344
\
00:23:26.230 --> 00:23:26.730
\
Scott Mason: 18 minutes.

345
\
00:23:26.730 --> 00:23:28.589
\
Graham Stoddart-Stones: And again, I think, for the mouse.

346
\
00:23:30.050 --> 00:23:32.120
\
Graham Stoddart-Stones: One more class minutes after that.

347
\
00:23:32.310 --> 00:23:33.209
\
Graham Stoddart-Stones: There we go.

348
\
00:23:33.210 --> 00:23:34.290
\
Scott Mason: That's working, isn't it?

349
\
00:23:34.480 --> 00:23:40.009
\
Graham Stoddart-Stones: Yeah, okay. So now you keep those figures, so 3299241.

350
\
00:23:40.880 --> 00:23:43.010
\
Graham Stoddart-Stones: And 137499.

351
\
00:23:44.570 --> 00:23:45.589
\
Scott Mason: Yep, got it.

352
\
00:23:45.590 --> 00:23:47.249
\
Graham Stoddart-Stones: Now let's go back to your spreadsheet.

353
\
00:23:49.060 --> 00:23:54.749
\
Stuart Bacon: Do you want… well, before you do that, do you want to get all of them? Get all four, and then when you're in the spreadsheet, we can…

354
\
00:23:55.120 --> 00:23:59.639
\
Graham Stoddart-Stones: Yeah, makes sense. Good thinking. I thought I would prove the system first, but you're absolutely right.

355
\
00:23:59.640 --> 00:24:03.059
\
Scott Mason: So if I go, sort of, here, sort of central…

356
\
00:24:03.340 --> 00:24:04.680
\
Stuart Bacon: I've got… yeah.

357
\
00:24:07.740 --> 00:24:11.839
\
Scott Mason: Right, 331090, and 1…

358
\
00:24:11.840 --> 00:24:14.350
\
Stuart Bacon: 137569.

359
\
00:24:14.520 --> 00:24:15.120
\
Scott Mason: Okay.

360
\
00:24:15.120 --> 00:24:19.140
\
Graham Stoddart-Stones: I think… I'm not sure we're doing this the right way.

361
\
00:24:20.500 --> 00:24:24.000
\
Graham Stoddart-Stones: Well, I think you need to be able to divide everything above the line.

362
\
00:24:24.240 --> 00:24:28.339
\
Graham Stoddart-Stones: On the horizontal line, and everything to the right of the vertical line.

363
\
00:24:28.440 --> 00:24:31.039
\
Graham Stoddart-Stones: So probably you need the coordinates of the line.

364
\
00:24:31.870 --> 00:24:32.809
\
Scott Mason: Rather than central.

365
\
00:24:32.810 --> 00:24:33.320
\
Graham Stoddart-Stones: to the zone.

366
\
00:24:34.490 --> 00:24:38.430
\
Graham Stoddart-Stones: the Y coordinates for the horizontal line, and you need the X coordinate.

367
\
00:24:38.680 --> 00:24:40.940
\
Graham Stoddart-Stones: It's right, other way around.

368
\
00:24:40.940 --> 00:24:47.960
\
Stuart Bacon: Effectively, you're saying that what we need is the crossover point where the two lines intersect?

369
\
00:24:48.800 --> 00:24:52.480
\
Graham Stoddart-Stones: Well, that's the center of the whole thing, but what we only need is to know.

370
\
00:24:52.480 --> 00:24:55.670
\
Stuart Bacon: Oh, yeah, and then you can work out from whatever's above,

371
\
00:24:56.640 --> 00:24:58.650
\
Stuart Bacon: And to the right would be…

372
\
00:24:59.520 --> 00:25:06.110
\
Graham Stoddart-Stones: Yeah, but I'm thinking… I'm thinking of… he's got a spreadsheet with the center point… sorry, the,

373
\
00:25:06.720 --> 00:25:09.230
\
Graham Stoddart-Stones: Coordinates of each area.

374
\
00:25:09.610 --> 00:25:17.270
\
Graham Stoddart-Stones: In it. So, if the coordinates for the horizontal are Higher than the…

375
\
00:25:17.600 --> 00:25:22.879
\
Graham Stoddart-Stones: Horizontal line, then it's either in the first quarter or the last quarter, whichever way you're measuring it.

376
\
00:25:23.480 --> 00:25:25.570
\
Graham Stoddart-Stones: And ditto for the vertical line.

377
\
00:25:25.910 --> 00:25:26.550
\
Stuart Bacon: Yeah.

378
\
00:25:26.800 --> 00:25:31.860
\
Graham Stoddart-Stones: So, in the spreadsheet, you need those two numbers, the vertical line and the horizontal line.

379
\
00:25:31.860 --> 00:25:35.480
\
Stuart Bacon: of those… of that… of the two lines, isn't it?

380
\
00:25:37.440 --> 00:25:40.169
\
Graham Stoddart-Stones: I don't think… does it give you that there? Maybe.

381
\
00:25:40.170 --> 00:25:43.739
\
Stuart Bacon: Well, if you scroll into the intersection point of that line.

382
\
00:25:43.940 --> 00:25:44.900
\
Graham Stoddart-Stones: Yep, alright.

383
\
00:25:47.250 --> 00:25:48.090
\
Graham Stoddart-Stones: Yep.

384
\
00:25:48.920 --> 00:25:50.460
\
Graham Stoddart-Stones: Fair enough, quite right.

385
\
00:25:52.070 --> 00:25:53.469
\
Scott Mason: What am I doing?

386
\
00:25:53.770 --> 00:25:56.870
\
Graham Stoddart-Stones: Write down 330-085.

387
\
00:25:58.880 --> 00:26:00.620
\
Graham Stoddart-Stones: 27 miles, I guess.

388
\
00:26:00.730 --> 00:26:04.200
\
Graham Stoddart-Stones: And 136997.02.

389
\
00:26:05.690 --> 00:26:06.310
\
Scott Mason: Yep.

390
\
00:26:07.200 --> 00:26:09.550
\
Graham Stoddart-Stones: And now, let's go back to your spreadsheet.

391
\
00:26:10.660 --> 00:26:12.040
\
Stuart Bacon: And it's only that.

392
\
00:26:12.490 --> 00:26:16.490
\
Stuart Bacon: two numbers that we need. The ones we took earlier on, we're not going to need.

393
\
00:26:16.490 --> 00:26:17.470
\
Scott Mason: Okay, fine.

394
\
00:26:18.020 --> 00:26:20.700
\
Stuart Bacon: We want…

395
\
00:26:21.010 --> 00:26:25.550
\
Graham Stoddart-Stones: You want to sort by center… is it Mike in November, by the look of it? I can't remember.

396
\
00:26:25.550 --> 00:26:31.409
\
Stuart Bacon: Do you want to sort it, or do you want to just create an, use column

397
\
00:26:31.660 --> 00:26:37.520
\
Stuart Bacon: Create a new dataset in the… Right of, that.

398
\
00:26:37.980 --> 00:26:40.190
\
Stuart Bacon: And whatever, and we'll just…

399
\
00:26:40.190 --> 00:26:40.690
\
Graham Stoddart-Stones: give it…

400
\
00:26:40.690 --> 00:26:45.409
\
Stuart Bacon: Create a formula or whatever to show which Quadrant it's in.

401
\
00:26:46.100 --> 00:26:49.669
\
Graham Stoddart-Stones: There you go. That's much more, practical.

402
\
00:26:50.000 --> 00:26:51.040
\
Scott Mason: What do I need to do?

403
\
00:26:51.040 --> 00:26:52.410
\
Graham Stoddart-Stones: He walked Scott through it.

404
\
00:26:52.410 --> 00:26:55.050
\
Scott Mason: Yeah, you've lost me now. Okay.

405
\
00:26:55.050 --> 00:27:00.880
\
Stuart Bacon: So, yeah, we'll, we've got the.

406
\
00:27:00.880 --> 00:27:04.380
\
Graham Stoddart-Stones: Yes, it says if, if, if Mike 2…

407
\
00:27:04.970 --> 00:27:08.879
\
Graham Stoddart-Stones: Is greater than whatever your horizontal number is, then

408
\
00:27:09.700 --> 00:27:16.359
\
Graham Stoddart-Stones: quadrant so-and-so, and B for the N2, isn't it? Is Mike and November are the two columns involved.

409
\
00:27:16.360 --> 00:27:23.380
\
Stuart Bacon: Yeah, yeah, you want an ifs statement, and whatever. I think we're going to put in column…

410
\
00:27:23.860 --> 00:27:25.050
\
Stuart Bacon: Is it all?

411
\
00:27:25.050 --> 00:27:30.549
\
Scott Mason: So shall I start making a column? Because there's going to be four quarters, obviously, so shall I make quarter one, quarter two, quarter three, quarter four?

412
\
00:27:30.550 --> 00:27:31.660
\
Stuart Bacon: No, I just…

413
\
00:27:31.660 --> 00:27:32.420
\
Graham Stoddart-Stones: Yo.

414
\
00:27:32.420 --> 00:27:34.769
\
Stuart Bacon: I just do a column for quarters.

415
\
00:27:36.000 --> 00:27:39.670
\
Scott Mason: Does it matter? In the next one, sort of? Yeah, yeah, go for it.

416
\
00:27:39.670 --> 00:27:41.819
\
Stuart Bacon: Let's putting on quarters.

417
\
00:27:41.820 --> 00:27:42.690
\
Scott Mason: Okay.

418
\
00:27:42.690 --> 00:27:51.720
\
Stuart Bacon: And then we'll do the… we'll do a formula that will work it out as to which quarter it is. Okay. So, equals IFS.

419
\
00:27:52.730 --> 00:27:54.460
\
Scott Mason: IF S?

420
\
00:27:54.460 --> 00:27:55.010
\
Stuart Bacon: Yep.

421
\
00:27:55.270 --> 00:27:57.300
\
Stuart Bacon: Open brackets.

422
\
00:27:57.300 --> 00:27:57.840
\
Scott Mason: Yeah.

423
\
00:27:58.840 --> 00:28:01.689
\
Stuart Bacon: And what we're testing…

424
\
00:28:01.790 --> 00:28:04.399
\
Graham Stoddart-Stones: Is Mike, mic 2. M2?

425
\
00:28:04.400 --> 00:28:05.830
\
Stuart Bacon: Yeah, Mike 2.

426
\
00:28:07.290 --> 00:28:08.390
\
Graham Stoddart-Stones: Greater than…

427
\
00:28:08.810 --> 00:28:11.660
\
Stuart Bacon: Yeah.

428
\
00:28:11.950 --> 00:28:15.479
\
Graham Stoddart-Stones: And whatever your first 3 number was that you wrote down.

429
\
00:28:15.480 --> 00:28:18.810
\
Scott Mason: Oh, 370085? Should I put that in?

430
\
00:28:18.810 --> 00:28:20.609
\
Graham Stoddart-Stones: Yep, yep, to write that.

431
\
00:28:20.980 --> 00:28:22.290
\
Scott Mason: 79?

432
\
00:28:22.290 --> 00:28:25.330
\
Graham Stoddart-Stones: Yep, absolutely, you've got to be precise with government work.

433
\
00:28:27.200 --> 00:28:28.010
\
Scott Mason: Okay.

434
\
00:28:31.920 --> 00:28:36.910
\
Stuart Bacon: True is… North.

435
\
00:28:37.930 --> 00:28:38.870
\
Scott Mason: It's the one we're doing here.

436
\
00:28:38.870 --> 00:28:40.510
\
Stuart Bacon: So you… comma… Comma.

437
\
00:28:40.640 --> 00:28:41.450
\
Stuart Bacon: Yeah.

438
\
00:28:44.860 --> 00:28:48.870
\
Scott Mason: Yeah, value underscore F… True.

439
\
00:28:48.870 --> 00:28:49.669
\
Stuart Bacon: No, no, no.

440
\
00:28:49.670 --> 00:28:52.390
\
Graham Stoddart-Stones: No, no, no, no, that's what they want you to put in.

441
\
00:28:52.390 --> 00:28:53.130
\
Scott Mason: always seem.

442
\
00:28:53.130 --> 00:28:55.420
\
Graham Stoddart-Stones: So the value underscore if true is N.

443
\
00:28:55.710 --> 00:28:57.230
\
Graham Stoddart-Stones: Just the letter N.

444
\
00:28:57.230 --> 00:28:58.609
\
Scott Mason: Oh, so you don't need value at all.

445
\
00:28:58.610 --> 00:29:00.449
\
Graham Stoddart-Stones: be in quotes? Does it need to be in quotes?

446
\
00:29:00.890 --> 00:29:04.140
\
Stuart Bacon: Yeah, it needs to be in quotes to write… So, yeah.

447
\
00:29:04.140 --> 00:29:05.600
\
Graham Stoddart-Stones: votes in.

448
\
00:29:06.380 --> 00:29:09.040
\
Scott Mason: When you say quotes, what do you mean by that?

449
\
00:29:09.040 --> 00:29:11.370
\
Stuart Bacon: So, Shift and F2. Shift and 2.

450
\
00:29:11.810 --> 00:29:14.590
\
Scott Mason: Shift, oh, okay, yeah. And then N…

451
\
00:29:15.260 --> 00:29:16.630
\
Scott Mason: And then shift and F2 again.

452
\
00:29:16.630 --> 00:29:18.710
\
Graham Stoddart-Stones: Yep, yep, comma.

453
\
00:29:19.710 --> 00:29:20.490
\
Scott Mason: Comma.

454
\
00:29:21.800 --> 00:29:25.849
\
Graham Stoddart-Stones: And then if M… sorry, if November 2…

455
\
00:29:27.020 --> 00:29:28.699
\
Scott Mason: Let the hell.

456
\
00:29:34.410 --> 00:29:36.059
\
Scott Mason: space? How do you.

457
\
00:29:36.060 --> 00:29:37.950
\
Graham Stoddart-Stones: No brackets, open bracket.

458
\
00:29:37.950 --> 00:29:46.989
\
Stuart Bacon: No, you don't need… do you need if November 2? Is it not just if, November 2… is it not just we put in Mike 2?

459
\
00:29:46.990 --> 00:29:47.440
\
Graham Stoddart-Stones: kit.

460
\
00:29:47.440 --> 00:29:49.819
\
Stuart Bacon: Brighter than the other number.

461
\
00:29:50.200 --> 00:29:52.689
\
Graham Stoddart-Stones: Yeah, not Mike 2, November 2.

462
\
00:29:52.900 --> 00:29:54.000
\
Stuart Bacon: Yeah, sorry, yeah, November's.

463
\
00:29:54.000 --> 00:30:04.029
\
Graham Stoddart-Stones: So you don't need the F, I'm sorry, you're doing an IFS, a makeup, so just if, just, Mike, November 2, change that, you want to go back a space.

464
\
00:30:05.120 --> 00:30:07.099
\
Stuart Bacon: Delete the… delete the eye, effectively.

465
\
00:30:07.440 --> 00:30:15.190
\
Graham Stoddart-Stones: Yeah, now you want Mike… sorry, November 2… Capital N, greater than…

466
\
00:30:15.740 --> 00:30:18.100
\
Graham Stoddart-Stones: And then the number that started with 1.

467
\
00:30:19.150 --> 00:30:25.680
\
Scott Mason: 136997.02.

468
\
00:30:26.620 --> 00:30:27.250
\
Graham Stoddart-Stones: Good?

469
\
00:30:27.920 --> 00:30:31.830
\
Graham Stoddart-Stones: Then that is… East?

470
\
00:30:32.650 --> 00:30:35.820
\
Graham Stoddart-Stones: Yes, no.

471
\
00:30:35.820 --> 00:30:37.110
\
Stuart Bacon: Nutty taste, yeah.

472
\
00:30:37.310 --> 00:30:41.109
\
Graham Stoddart-Stones: Yeah, east. So, comma, quotes, E.

473
\
00:30:43.640 --> 00:30:44.260
\
Scott Mason: Okay.

474
\
00:30:45.570 --> 00:30:48.360
\
Stuart Bacon: Close brackets.

475
\
00:30:50.260 --> 00:30:51.780
\
Scott Mason: Yeah, happy with that, should I press enter?

476
\
00:30:51.780 --> 00:30:54.689
\
Stuart Bacon: And that's… we're just testing at the moment.

477
\
00:30:54.700 --> 00:30:55.590
\
Graham Stoddart-Stones: Okay.

478
\
00:30:55.870 --> 00:30:59.720
\
Stuart Bacon: You need to now…

479
\
00:31:01.860 --> 00:31:06.439
\
Stuart Bacon: Click on, move your mouse across to…

480
\
00:31:07.010 --> 00:31:10.649
\
Stuart Bacon: the left. Sorry, not your manager, you, with your…

481
\
00:31:10.810 --> 00:31:14.059
\
Stuart Bacon: With your arrow keys, move the field across to the left.

482
\
00:31:15.060 --> 00:31:16.970
\
Stuart Bacon: And again.

483
\
00:31:18.060 --> 00:31:22.039
\
Stuart Bacon: Now… Shift and down arrow.

484
\
00:31:25.340 --> 00:31:28.960
\
Stuart Bacon: Sorry, not shift. Control and down arrow.

485
\
00:31:29.520 --> 00:31:32.129
\
Scott Mason: Okay, control down arrow…

486
\
00:31:32.320 --> 00:31:34.340
\
Stuart Bacon: Yeah, to take you to the bottom of the list.

487
\
00:31:34.340 --> 00:31:34.870
\
Scott Mason: Yep.

488
\
00:31:35.160 --> 00:31:39.340
\
Stuart Bacon: Arrow across, across twice to, R.

489
\
00:31:41.590 --> 00:31:42.730
\
Scott Mason: Twice to ask.

490
\
00:31:42.730 --> 00:31:45.129
\
Graham Stoddart-Stones: to the right, to come our, you know… Oops!

491
\
00:31:45.130 --> 00:31:48.019
\
Stuart Bacon: You've gone all the way… sorry, you've gone all the way across.

492
\
00:31:48.340 --> 00:31:51.539
\
Scott Mason: Do you want me to just give you control? That'd be easier.

493
\
00:31:53.220 --> 00:31:53.660
\
Stuart Bacon: You count.

494
\
00:31:53.990 --> 00:31:58.710
\
Stuart Bacon: I mean, yeah, no, I mean, it's… Yeah.

495
\
00:31:58.840 --> 00:32:08.090
\
Stuart Bacon: Effectively, I just want you… you just want to be in the, in the cell, in the R column at the bottom of your list.

496
\
00:32:08.940 --> 00:32:10.069
\
Scott Mason: Oh, I see.

497
\
00:32:10.590 --> 00:32:12.110
\
Scott Mason: Can I just scroll down to it, then?

498
\
00:32:12.830 --> 00:32:19.080
\
Stuart Bacon: Yeah, it works. Take, if you click on P, and…

499
\
00:32:19.280 --> 00:32:25.299
\
Stuart Bacon: or H, L, and P, and do your, Ctrl and down arrow, that will take you to the bottom anyway.

500
\
00:32:25.630 --> 00:32:27.400
\
Scott Mason: Oh, okay. And then I can go to here.

501
\
00:32:27.400 --> 00:32:33.490
\
Stuart Bacon: Harrowing across Trice, yeah. Now, ctrl, Shift, and up arrow.

502
\
00:32:35.760 --> 00:32:36.250
\
Graham Stoddart-Stones: Hold on.

503
\
00:32:36.250 --> 00:32:37.279
\
Stuart Bacon: Roland D.

504
\
00:32:38.120 --> 00:32:39.630
\
Scott Mason: Sorry, Ctrl and D.

505
\
00:32:39.630 --> 00:32:40.190
\
Stuart Bacon: Yes.

506
\
00:32:41.660 --> 00:32:43.439
\
Stuart Bacon: And that copies the…

507
\
00:32:43.930 --> 00:32:44.820
\
Scott Mason: to the rule.

508
\
00:32:44.820 --> 00:32:47.690
\
Stuart Bacon: The full… that's copied the formula down.

509
\
00:32:47.690 --> 00:32:48.330
\
Scott Mason: Okay.

510
\
00:32:48.710 --> 00:32:58.550
\
Stuart Bacon: And if you scroll up, and go… Right, okay, we've got…

511
\
00:32:58.970 --> 00:33:02.540
\
Stuart Bacon: Go to… Filter, at the top.

512
\
00:33:02.710 --> 00:33:05.020
\
Stuart Bacon: Turn it off and turn it back on again.

513
\
00:33:07.280 --> 00:33:10.610
\
Stuart Bacon: Sorry, you've got to unhighlight the…

514
\
00:33:10.610 --> 00:33:11.929
\
Scott Mason: I don't want it filtered there, do I?

515
\
00:33:11.930 --> 00:33:12.620
\
Stuart Bacon: None.

516
\
00:33:13.030 --> 00:33:14.160
\
Scott Mason: filtered here.

517
\
00:33:14.160 --> 00:33:14.700
\
Stuart Bacon: Yep.

518
\
00:33:15.980 --> 00:33:16.630
\
Scott Mason: Okay.

519
\
00:33:18.450 --> 00:33:25.810
\
Stuart Bacon: Or… yeah, that's only… that's only height… filtered, column R, it's not filtered the whole table.

520
\
00:33:25.970 --> 00:33:26.990
\
Stuart Bacon: So…

521
\
00:33:28.380 --> 00:33:29.409
\
Scott Mason: So it's Islam.

522
\
00:33:29.810 --> 00:33:34.450
\
Stuart Bacon: If you click in the little triangle just above, between A1,

523
\
00:33:35.360 --> 00:33:37.669
\
Stuart Bacon: Yeah, there you go. Now filter it.

524
\
00:33:39.820 --> 00:33:40.969
\
Stuart Bacon: That's got, you know.

525
\
00:33:42.590 --> 00:33:48.109
\
Stuart Bacon: And now, let's just see if it's pulled anything through, if you'd floated down on quarters.

526
\
00:33:48.960 --> 00:33:54.949
\
Stuart Bacon: And it's only… it's got A on some of them.

527
\
00:33:55.380 --> 00:33:56.300
\
Stuart Bacon: No, it's not.

528
\
00:33:56.540 --> 00:33:59.509
\
Stuart Bacon: So let's click out the NA in blanks.

529
\
00:34:00.070 --> 00:34:02.240
\
Stuart Bacon: Have a look at what we… how many we've got.

530
\
00:34:06.350 --> 00:34:08.189
\
Scott Mason: It's got, what, 377 records.

531
\
00:34:09.350 --> 00:34:10.190
\
Graham Stoddart-Stones: Nope.

532
\
00:34:11.389 --> 00:34:18.769
\
Graham Stoddart-Stones: But why, it should… should be… shouldn't there be both an N and an E?

533
\
00:34:22.370 --> 00:34:23.480
\
Graham Stoddart-Stones: Shoot.

534
\
00:34:23.480 --> 00:34:27.710
\
Stuart Bacon: Because we've done it as an ifs, so it's looking for meeting both.

535
\
00:34:28.070 --> 00:34:29.659
\
Stuart Bacon: Well, it's heavy, aren't we?

536
\
00:34:29.830 --> 00:34:33.940
\
Stuart Bacon: So we need to go back in. Let's undo… undo the filter.

537
\
00:34:37.760 --> 00:34:38.980
\
Stuart Bacon: Platform.

538
\
00:34:42.060 --> 00:34:46.950
\
Stuart Bacon: Right, and then if we click in R… Talk to again.

539
\
00:34:49.830 --> 00:34:50.870
\
Graham Stoddart-Stones: Well, yup.

540
\
00:34:53.000 --> 00:34:56.989
\
Graham Stoddart-Stones: So, if M2 is greater than that, It's north.

541
\
00:34:59.520 --> 00:35:00.245
\
Stuart Bacon: won't…

542
\
00:35:02.380 --> 00:35:06.099
\
Graham Stoddart-Stones: Actually, I'm not familiar with IFS. What does IFS do?

543
\
00:35:07.220 --> 00:35:13.020
\
Stuart Bacon: If she's meeting… matching the most full criteria at once, whereas it's…

544
\
00:35:13.180 --> 00:35:17.860
\
Stuart Bacon: If, on its own, he's just set one criteria, and that's… you're locked.

545
\
00:35:18.060 --> 00:35:22.430
\
Stuart Bacon: We can do it as a… perhaps we'll change the formula,

546
\
00:35:22.430 --> 00:35:25.010
\
Graham Stoddart-Stones: Let me do it as a single step, so…

547
\
00:35:25.390 --> 00:35:43.300
\
Graham Stoddart-Stones: have one column for Eastings, and one column for Northings, and then you can do your if on the end of, if it's N plus E, then that's column 1. If it's quarter one, if it's S plus E, that's quarter two. If it's S plus W, it's quarter three, and if it's S plus…

548
\
00:35:44.030 --> 00:35:44.970
\
Graham Stoddart-Stones: Yeah.

549
\
00:35:45.520 --> 00:35:46.330
\
Stuart Bacon: do that.

550
\
00:35:46.640 --> 00:35:50.309
\
Scott Mason: My worry with doing all of this is that I need to still pin down the exact boundaries.

551
\
00:35:50.660 --> 00:35:51.330
\
Scott Mason: So, where…

552
\
00:35:51.330 --> 00:35:51.890
\
Graham Stoddart-Stones: the.

553
\
00:35:51.890 --> 00:35:52.999
\
Scott Mason: In fact, north.

554
\
00:35:53.000 --> 00:35:57.410
\
Graham Stoddart-Stones: No, I don't think you do. I think you leave that to, what's-their-face to do.

555
\
00:35:57.510 --> 00:35:58.750
\
Graham Stoddart-Stones: Oh, I… mmm…

556
\
00:35:58.750 --> 00:36:01.869
\
Scott Mason: I need to work out where the teams are going to be operating in their four quarters.

557
\
00:36:01.870 --> 00:36:06.290
\
Graham Stoddart-Stones: Yeah, yeah, yeah, but when you, when you get the… when you get the,

558
\
00:36:07.270 --> 00:36:11.070
\
Graham Stoddart-Stones: Sorry, you're sending this as a spreadsheet for urban.

559
\
00:36:11.740 --> 00:36:12.420
\
Scott Mason: Yeah.

560
\
00:36:12.860 --> 00:36:17.029
\
Graham Stoddart-Stones: you just… when you get it back, or you'll ask, Giers Fitz.

561
\
00:36:17.030 --> 00:36:17.760
\
Scott Mason: Oh, I see.

562
\
00:36:17.760 --> 00:36:21.070
\
Graham Stoddart-Stones: Jess, who owns Urban will be looking after.

563
\
00:36:21.070 --> 00:36:22.550
\
Scott Mason: Yeah, okay, fine.

564
\
00:36:23.760 --> 00:36:30.250
\
Graham Stoddart-Stones: So… Stuart, do you want to continue with this, or would you like to go my simpler way?

565
\
00:36:30.250 --> 00:36:33.639
\
Stuart Bacon: Try, try, try your simple way if you want, Graham.

566
\
00:36:34.040 --> 00:36:36.659
\
Graham Stoddart-Stones: So, if we go to R2.

567
\
00:36:37.530 --> 00:36:38.220
\
Scott Mason: Yep.

568
\
00:36:38.220 --> 00:36:42.959
\
Graham Stoddart-Stones: And change the, formula to if…

569
\
00:36:43.490 --> 00:36:44.390
\
Scott Mason: So get rid of the S.

570
\
00:36:44.390 --> 00:36:51.669
\
Graham Stoddart-Stones: No, yes, change… get rid of the S, yep. M2 is… I think everything after the N…

571
\
00:36:52.150 --> 00:36:58.840
\
Graham Stoddart-Stones: Delete. So leave the brackets on the end, but, you know, get rid of that, get rid of that. Good, yup, leave it at that.

572
\
00:36:59.230 --> 00:37:01.180
\
Graham Stoddart-Stones: Okay, click on that.

573
\
00:37:02.740 --> 00:37:03.949
\
Graham Stoddart-Stones: Press enter.

574
\
00:37:05.240 --> 00:37:06.850
\
Graham Stoddart-Stones: Oh, sorry, you got a space.

575
\
00:37:06.850 --> 00:37:08.479
\
Stuart Bacon: Finish the if statement, has it?

576
\
00:37:08.480 --> 00:37:14.109
\
Graham Stoddart-Stones: Yeah, it doesn't change your… take the space out after the N codes. Yeah, that's good.

577
\
00:37:14.490 --> 00:37:20.709
\
Stuart Bacon: I mean, it's po, yeah, you've not finished your if statement, though. You only said.

578
\
00:37:20.710 --> 00:37:21.650
\
Graham Stoddart-Stones: Oh yeah, we enjoyed it.

579
\
00:37:21.650 --> 00:37:24.900
\
Stuart Bacon: We're not given the alternative if it's not.

580
\
00:37:26.070 --> 00:37:26.850
\
Graham Stoddart-Stones: Okay.

581
\
00:37:27.180 --> 00:37:29.420
\
Graham Stoddart-Stones: Els, do you want? Nice.

582
\
00:37:29.420 --> 00:37:31.039
\
Stuart Bacon: So, you, you won't.

583
\
00:37:32.140 --> 00:37:34.040
\
Graham Stoddart-Stones: Or just leave it blank.

584
\
00:37:34.040 --> 00:37:38.329
\
Stuart Bacon: It's got to be a nested if, that it… so, comma…

585
\
00:37:38.580 --> 00:37:42.010
\
Graham Stoddart-Stones: Yeah, car and enclosed the racket. There you go.

586
\
00:37:44.850 --> 00:37:47.629
\
Stuart Bacon: Well, I was gonna do eco, if…

587
\
00:37:47.630 --> 00:37:48.500
\
Scott Mason: Where is it?

588
\
00:37:53.840 --> 00:37:58.770
\
Graham Stoddart-Stones: Oh, you need another accommodation for the, for the, false, or true or false.

589
\
00:37:58.920 --> 00:38:03.859
\
Stuart Bacon: No, yeah, no, cause you… the… the… You're formatting… start… okay.

590
\
00:38:04.410 --> 00:38:11.210
\
Stuart Bacon: Scott, fear out the… the content… sorry, the…

591
\
00:38:11.340 --> 00:38:16.740
\
Stuart Bacon: or just click on the FX at the side of the, the Formula Bar.

592
\
00:38:18.010 --> 00:38:18.680
\
Scott Mason: There.

593
\
00:38:18.680 --> 00:38:19.230
\
Stuart Bacon: Yeah.

594
\
00:38:20.460 --> 00:38:22.589
\
Stuart Bacon: And click on if.

595
\
00:38:24.310 --> 00:38:25.500
\
Stuart Bacon: Click OK.

596
\
00:38:27.900 --> 00:38:35.030
\
Stuart Bacon: So, your logical test is… M2…

597
\
00:38:38.150 --> 00:38:39.350
\
Graham Stoddart-Stones: greater than…

598
\
00:38:39.520 --> 00:38:41.990
\
Stuart Bacon: Greater than, the number.

599
\
00:38:44.040 --> 00:38:45.040
\
Scott Mason: Alright, number.

600
\
00:38:45.040 --> 00:38:46.840
\
Graham Stoddart-Stones: The one that started with 3.

601
\
00:38:47.220 --> 00:38:48.020
\
Scott Mason: Oh, I see.

602
\
00:38:48.020 --> 00:38:49.870
\
Graham Stoddart-Stones: The one you wrote down, it started with 3.

603
\
00:38:49.870 --> 00:38:50.440
\
Stuart Bacon: G.

604
\
00:38:52.100 --> 00:38:52.650
\
Scott Mason: Yep.

605
\
00:38:55.000 --> 00:38:59.299
\
Stuart Bacon: And your value, if true, is,

606
\
00:39:03.710 --> 00:39:11.420
\
Stuart Bacon: Yeah, but… Switchmarks to… well, yeah, switch marks N, sorry, switch mark, yeah.

607
\
00:39:13.710 --> 00:39:15.169
\
Scott Mason: to what you want to hear, N.

608
\
00:39:15.170 --> 00:39:18.430
\
Stuart Bacon: So, yeah, but you've got to put that in,

609
\
00:39:20.590 --> 00:39:26.780
\
Stuart Bacon: inside the double quotes or whatever, so it's Shift-F2, Sorry, Shift 2… N.

610
\
00:39:26.930 --> 00:39:27.950
\
Stuart Bacon: Shift 2.

611
\
00:39:30.420 --> 00:39:32.820
\
Stuart Bacon: And then, value if false.

612
\
00:39:33.060 --> 00:39:36.049
\
Stuart Bacon: You want,

613
\
00:39:40.170 --> 00:39:42.930
\
Stuart Bacon: Just go with… Double quotes.

614
\
00:39:43.460 --> 00:39:45.460
\
Stuart Bacon: So… Yeah.

615
\
00:39:45.770 --> 00:39:49.830
\
Stuart Bacon: Okay, so that'll show blank cells.

616
\
00:39:54.720 --> 00:39:55.829
\
Stuart Bacon: I won't stop.

617
\
00:39:57.370 --> 00:39:59.920
\
Stuart Bacon: Oh, because it's nested it. Oh, okay.

618
\
00:40:00.860 --> 00:40:02.000
\
Stuart Bacon: Click yes.

619
\
00:40:04.950 --> 00:40:07.560
\
Stuart Bacon: Now, in the…

620
\
00:40:12.400 --> 00:40:14.600
\
Stuart Bacon: In… in that, sorry.

621
\
00:40:14.820 --> 00:40:20.510
\
Stuart Bacon: That formula… The second M2…

622
\
00:40:23.530 --> 00:40:25.919
\
Scott Mason: Where am I looking now? Up here?

623
\
00:40:26.140 --> 00:40:26.760
\
Stuart Bacon: Yep.

624
\
00:40:27.350 --> 00:40:28.880
\
Stuart Bacon: Change that to less than.

625
\
00:40:33.110 --> 00:40:38.999
\
Stuart Bacon: Try that. And changed… and then the second N… Change that to S.

626
\
00:40:42.860 --> 00:40:44.139
\
Scott Mason: And then hit enter.

627
\
00:40:44.140 --> 00:40:44.680
\
Stuart Bacon: Yeah.

628
\
00:40:46.350 --> 00:40:51.650
\
Stuart Bacon: Now, arrow one cell.

629
\
00:40:53.720 --> 00:40:54.649
\
Scott Mason: Up one, no.

630
\
00:40:54.650 --> 00:40:55.220
\
Stuart Bacon: Yep.

631
\
00:40:55.430 --> 00:41:03.670
\
Stuart Bacon: And now… Shift and down arrow, Shift, Ctrl, and down arrow.

632
\
00:41:05.500 --> 00:41:07.739
\
Stuart Bacon: And Ctrl and D.

633
\
00:41:12.280 --> 00:41:14.580
\
Stuart Bacon: Now, that should have split.

634
\
00:41:15.560 --> 00:41:17.150
\
Stuart Bacon: In North and South.

635
\
00:41:19.310 --> 00:41:20.230
\
Scott Mason: all south.

636
\
00:41:21.300 --> 00:41:23.409
\
Stuart Bacon: That's not… they're not all cells.

637
\
00:41:30.340 --> 00:41:38.570
\
Stuart Bacon: Is that… that says anything greater than… 370,000 is…

638
\
00:41:38.900 --> 00:41:42.109
\
Stuart Bacon: should be N, and anything less than should be S.

639
\
00:41:49.300 --> 00:41:51.209
\
Stuart Bacon: And that's where we've got the mistake.

640
\
00:41:52.360 --> 00:41:54.340
\
Stuart Bacon: I see where we've got the mistake.

641
\
00:41:54.590 --> 00:41:56.960
\
Scott Mason: Glad you can.

642
\
00:41:56.960 --> 00:42:00.350
\
Stuart Bacon: It, it… look at the… look at the numbers in column N.

643
\
00:42:01.700 --> 00:42:07.470
\
Stuart Bacon: Yeah? We've put the wrong figure… we're working on the wrong figure. The easy way…

644
\
00:42:07.900 --> 00:42:11.290
\
Stuart Bacon: is, is now. We want that information.

645
\
00:42:11.610 --> 00:42:12.560
\
Stuart Bacon: Yep. Yep.

646
\
00:42:12.800 --> 00:42:22.040
\
Stuart Bacon: Right-click on, the header of R, An insert a… a… Column to the left.

647
\
00:42:25.170 --> 00:42:32.990
\
Stuart Bacon: Right? And now… Go back into S2 now.

648
\
00:42:35.690 --> 00:42:45.440
\
Stuart Bacon: And change… change your criteria from M, Oh, okay.

649
\
00:42:46.810 --> 00:42:48.700
\
Stuart Bacon: Is that right? Am I looking at this right?

650
\
00:42:52.500 --> 00:42:54.250
\
Stuart Bacon: No, it is studies.

651
\
00:43:00.140 --> 00:43:02.559
\
Stuart Bacon: Am I just wanted to boot himself?

652
\
00:43:04.000 --> 00:43:06.290
\
Scott Mason: This is too heavy for a Friday afternoon.

653
\
00:43:12.460 --> 00:43:13.670
\
Stuart Bacon: Those limbs.

654
\
00:43:15.110 --> 00:43:18.730
\
Stuart Bacon: I think I've just moved that one myself.

655
\
00:43:22.420 --> 00:43:24.520
\
Graham Stoddart-Stones: Is it not happy with that forever?

656
\
00:43:25.340 --> 00:43:31.640
\
Stuart Bacon: No, that formula, everything… everything is showing as an S, and I… it shouldn't…

657
\
00:43:32.340 --> 00:43:33.700
\
Graham Stoddart-Stones: Not all of it, no.

658
\
00:43:34.640 --> 00:43:40.190
\
Stuart Bacon: Shouldn't be doing it for all of it. There should be a split where… Builder!

659
\
00:43:40.490 --> 00:43:45.180
\
Stuart Bacon: Okay, let's look at what we… how many we're… we're looking at.

660
\
00:43:46.100 --> 00:43:48.110
\
Stuart Bacon: Filter column M.

661
\
00:43:49.170 --> 00:43:50.090
\
Scott Mason: For Mike.

662
\
00:43:50.370 --> 00:43:51.050
\
Stuart Bacon: Yep.

663
\
00:43:57.650 --> 00:44:03.550
\
Stuart Bacon: And click on… Non-offenses.

664
\
00:44:04.420 --> 00:44:06.019
\
Graham Stoddart-Stones: You just set the level, couldn't you?

665
\
00:44:08.330 --> 00:44:09.929
\
Stuart Bacon: What kind of number for it is.

666
\
00:44:12.880 --> 00:44:14.790
\
Stuart Bacon: And then greater than…

667
\
00:44:14.980 --> 00:44:15.550
\
Graham Stoddart-Stones: Yeah.

668
\
00:44:17.820 --> 00:44:20.860
\
Stuart Bacon: And put you 320.

669
\
00:44:21.010 --> 00:44:24.840
\
Stuart Bacon: Thousand or whatever is in the… Yep.

670
\
00:44:27.440 --> 00:44:27.860
\
Scott Mason: Okay.

671
\
00:44:27.860 --> 00:44:29.480
\
Stuart Bacon: Okay. Yep.

672
\
00:44:30.300 --> 00:44:30.860
\
Scott Mason: None.

673
\
00:44:32.780 --> 00:44:34.919
\
Graham Stoddart-Stones: Well, which line are you measuring?

674
\
00:44:35.500 --> 00:44:38.159
\
Andrew Clegg: I think the number… I think the number you've just put.

675
\
00:44:38.160 --> 00:44:40.900
\
Graham Stoddart-Stones: I think you're way down the bottom, you need to scroll up.

676
\
00:44:41.920 --> 00:44:42.780
\
Scott Mason: I'll skip that?

677
\
00:44:42.780 --> 00:44:44.209
\
Graham Stoddart-Stones: Is that what you're saying, Andrew?

678
\
00:44:44.630 --> 00:44:55.039
\
Andrew Clegg: I think the number you've just put in is not correct, is it? Go back and have a look at the numbers. To say I'm a bit out of my depth is a…

679
\
00:44:55.040 --> 00:44:55.430
\
Scott Mason: today.

680
\
00:44:55.430 --> 00:44:56.310
\
Andrew Clegg: Did we get it?

681
\
00:44:56.310 --> 00:44:57.440
\
Scott Mason: From here, didn't we?

682
\
00:44:57.440 --> 00:44:57.950
\
Stuart Bacon: Yeah.

683
\
00:45:00.050 --> 00:45:04.249
\
Stuart Bacon: That's it. It's 330 now86, not 370.

684
\
00:45:04.840 --> 00:45:05.650
\
Stuart Bacon: Alright.

685
\
00:45:05.650 --> 00:45:07.190
\
Andrew Clegg: I think that number was wrong.

686
\
00:45:07.190 --> 00:45:12.259
\
Stuart Bacon: That explains the, that explains the issue, sort of, yeah, in the corners.

687
\
00:45:12.260 --> 00:45:13.259
\
Scott Mason: lay my hand right in.

688
\
00:45:15.220 --> 00:45:16.600
\
Graham Stoddart-Stones: Are you a doctor?

689
\
00:45:16.600 --> 00:45:20.600
\
Scott Mason: Should be. Right, okay.

690
\
00:45:20.600 --> 00:45:23.650
\
Stuart Bacon: So, turn the filter off on that.

691
\
00:45:25.710 --> 00:45:30.139
\
Stuart Bacon: Or go back into the filter if you want.

692
\
00:45:30.140 --> 00:45:32.279
\
Scott Mason: I could change it to be 330 now, can't I?

693
\
00:45:32.280 --> 00:45:33.630
\
Stuart Bacon: Yeah, you can do.

694
\
00:45:34.230 --> 00:45:35.870
\
Scott Mason: Gonna saved you a lot of time.

695
\
00:45:36.210 --> 00:45:40.750
\
Andrew Clegg: Yeah, I think… I think in your map, you've got there everything that's west of Martok.

696
\
00:45:42.300 --> 00:45:50.060
\
Stuart Bacon: Yeah, so that gives us now 482, so we know what we're looking for. Right. Okay, so let's turn that filter off entirely.

697
\
00:45:53.000 --> 00:45:54.420
\
Scott Mason: How do I do that?

698
\
00:45:54.420 --> 00:45:56.759
\
Stuart Bacon: or two, clear filter from center X.

699
\
00:45:57.850 --> 00:45:58.580
\
Scott Mason: Okay.

700
\
00:45:58.580 --> 00:46:02.670
\
Stuart Bacon: Yep. And now go back into S2.

701
\
00:46:05.650 --> 00:46:09.820
\
Stuart Bacon: And changed 37,000 to $330,000.

702
\
00:46:10.420 --> 00:46:11.450
\
Stuart Bacon: Thousand…

703
\
00:46:11.630 --> 00:46:12.720
\
Graham Stoddart-Stones: In the formula.

704
\
00:46:13.020 --> 00:46:13.850
\
Stuart Bacon: too, listen.

705
\
00:46:14.120 --> 00:46:15.620
\
Stuart Bacon: Saint. And…

706
\
00:46:16.480 --> 00:46:16.910
\
Scott Mason: on that wall.

707
\
00:46:17.510 --> 00:46:18.869
\
Stuart Bacon: Yep, on that one as well.

708
\
00:46:19.700 --> 00:46:20.140
\
Graham Stoddart-Stones: Alright.

709
\
00:46:20.140 --> 00:46:22.849
\
Stuart Bacon: Okay, yep, so, fresh…

710
\
00:46:23.080 --> 00:46:25.829
\
Graham Stoddart-Stones: Yeah, that's right.

711
\
00:46:26.700 --> 00:46:32.829
\
Stuart Bacon: Now, Ctrl-Shift and D… Sorry, Ctrl-Shift and DOWN, even.

712
\
00:46:34.780 --> 00:46:36.570
\
Stuart Bacon: And now CTRL and D.

713
\
00:46:40.830 --> 00:46:43.140
\
Stuart Bacon: And now, you should have…

714
\
00:46:43.790 --> 00:46:45.310
\
Graham Stoddart-Stones: So, split.

715
\
00:46:45.650 --> 00:46:45.970
\
Stuart Bacon: What?

716
\
00:46:46.320 --> 00:46:48.130
\
Scott Mason: I was just testing you all.

717
\
00:46:48.780 --> 00:46:51.640
\
Andrew Clegg: So, is that…

718
\
00:46:51.640 --> 00:46:55.200
\
Graham Stoddart-Stones: the, is there nothing in R now?

719
\
00:46:56.260 --> 00:46:57.830
\
Scott Mason: Hmm…

720
\
00:46:58.300 --> 00:46:59.989
\
Stuart Bacon: R is a blank.

721
\
00:46:59.990 --> 00:47:05.819
\
Graham Stoddart-Stones: So, the one you've called Quarter, is this just really, north-south, and then you're gonna do the same again for east-west?

722
\
00:47:06.000 --> 00:47:06.570
\
Stuart Bacon: Yeah.

723
\
00:47:06.890 --> 00:47:09.009
\
Graham Stoddart-Stones: So, I would change the name of S.

724
\
00:47:09.350 --> 00:47:11.710
\
Graham Stoddart-Stones: Scott, to north and south.

725
\
00:47:13.540 --> 00:47:14.090
\
Graham Stoddart-Stones: Yeah.

726
\
00:47:14.090 --> 00:47:14.820
\
Scott Mason: Okay.

727
\
00:47:14.820 --> 00:47:18.200
\
Graham Stoddart-Stones: And now do exactly the same thing in T for East-West.

728
\
00:47:21.210 --> 00:47:26.129
\
Graham Stoddart-Stones: And you can copy the formula across from S2.

729
\
00:47:31.640 --> 00:47:33.589
\
Stuart Bacon: Click it, click into T2…

730
\
00:47:34.550 --> 00:47:35.790
\
Scott Mason: Oh, no, don't want to do that.

731
\
00:47:35.790 --> 00:47:36.520
\
Stuart Bacon: Not.

732
\
00:47:36.730 --> 00:47:37.570
\
Scott Mason: Yep.

733
\
00:47:37.570 --> 00:47:39.260
\
Stuart Bacon: Go Ctrl and R.

734
\
00:47:42.120 --> 00:47:43.109
\
Stuart Bacon: There we go.

735
\
00:47:44.310 --> 00:47:46.380
\
Graham Stoddart-Stones: And now it changed the formula, yeah.

736
\
00:47:46.630 --> 00:47:47.280
\
Stuart Bacon: Yeah.

737
\
00:47:47.380 --> 00:47:52.569
\
Graham Stoddart-Stones: So, if… If N…

738
\
00:47:53.930 --> 00:47:56.069
\
Stuart Bacon: It's N2, yep, that would be right.

739
\
00:47:56.070 --> 00:47:57.030
\
Graham Stoddart-Stones: And…

740
\
00:47:57.030 --> 00:48:01.779
\
Stuart Bacon: Changing the 330 to something that begins with a 1.

741
\
00:48:01.780 --> 00:48:03.870
\
Scott Mason: Oh, 136997, yeah.

742
\
00:48:03.870 --> 00:48:04.490
\
Stuart Bacon: Yep.

743
\
00:48:06.070 --> 00:48:08.059
\
Scott Mason: So all of this number changes, yeah?

744
\
00:48:08.060 --> 00:48:08.630
\
Graham Stoddart-Stones: risk.

745
\
00:48:14.690 --> 00:48:15.950
\
Scott Mason: And the same number in here?

746
\
00:48:16.540 --> 00:48:17.230
\
Graham Stoddart-Stones: Yes.

747
\
00:48:19.390 --> 00:48:20.860
\
Scott Mason: See if I got my numbers right this time.

748
\
00:48:20.860 --> 00:48:24.740
\
Graham Stoddart-Stones: You change the N to E, and the… S2W.

749
\
00:48:25.760 --> 00:48:27.149
\
Scott Mason: So, N to E.

750
\
00:48:28.230 --> 00:48:30.029
\
Scott Mason: S to W-E-N.

751
\
00:48:30.540 --> 00:48:31.100
\
Stuart Bacon: Nope.

752
\
00:48:31.220 --> 00:48:31.780
\
Graham Stoddart-Stones: Yeah.

753
\
00:48:31.780 --> 00:48:32.820
\
Scott Mason: And then enter.

754
\
00:48:33.260 --> 00:48:33.630
\
Graham Stoddart-Stones: Yep.

755
\
00:48:33.630 --> 00:48:34.180
\
Stuart Bacon: Yep.

756
\
00:48:35.370 --> 00:48:36.779
\
Graham Stoddart-Stones: Okay, and now just…

757
\
00:48:36.780 --> 00:48:38.690
\
Stuart Bacon: So, arrow left.

758
\
00:48:41.850 --> 00:48:44.870
\
Stuart Bacon: Control, Shift, and down.

759
\
00:48:44.870 --> 00:48:46.890
\
Graham Stoddart-Stones: Whoa, whoa, whoa, whoa, you're on the wrong column.

760
\
00:48:46.890 --> 00:48:47.830
\
Stuart Bacon: No, I'm not.

761
\
00:48:47.830 --> 00:48:48.790
\
Graham Stoddart-Stones: Okay.

762
\
00:48:48.790 --> 00:48:49.349
\
Stuart Bacon: and downs.

763
\
00:48:50.290 --> 00:48:52.790
\
Stuart Bacon: No. No.

764
\
00:48:53.560 --> 00:48:54.470
\
Stuart Bacon: Okay.

765
\
00:48:55.030 --> 00:49:02.069
\
Stuart Bacon: Go… you want… T… what is it? 968.

766
\
00:49:03.530 --> 00:49:04.720
\
Scott Mason: E968, yeah.

767
\
00:49:04.720 --> 00:49:05.300
\
Stuart Bacon: Yep.

768
\
00:49:05.580 --> 00:49:06.469
\
Scott Mason: So, what are they claim?

769
\
00:49:06.470 --> 00:49:06.880
\
Stuart Bacon: 12th.

770
\
00:49:06.880 --> 00:49:07.619
\
Scott Mason: Click on one.

771
\
00:49:08.680 --> 00:49:12.570
\
Stuart Bacon: Now, Ctrl, Shift, and, oh.

772
\
00:49:13.370 --> 00:49:14.920
\
Stuart Bacon: from that.

773
\
00:49:15.480 --> 00:49:17.369
\
Stuart Bacon: and Ctrl and D.

774
\
00:49:24.560 --> 00:49:29.680
\
Graham Stoddart-Stones: No, I… yeah. My only concern is whether… what the east and the west's in the right direction.

775
\
00:49:31.530 --> 00:49:36.080
\
Stuart Bacon: Let's look at… let's take an example.

776
\
00:49:42.880 --> 00:49:44.449
\
Stuart Bacon: Have we got…

777
\
00:49:47.270 --> 00:49:48.489
\
Graham Stoddart-Stones: Or take, you know…

778
\
00:49:49.040 --> 00:49:57.609
\
Stuart Bacon: Have we got, sort of, one of them, we can look at? Click… so, the top one, we think now, is Southwest.

779
\
00:49:57.890 --> 00:49:58.440
\
Scott Mason: Yep.

780
\
00:49:58.440 --> 00:50:00.389
\
Stuart Bacon: So if we go.

781
\
00:50:00.700 --> 00:50:03.520
\
Scott Mason: It is South West, I can tell you that much, yeah.

782
\
00:50:03.520 --> 00:50:04.390
\
Graham Stoddart-Stones: Oh, really?

783
\
00:50:04.390 --> 00:50:04.970
\
Scott Mason: Yeah.

784
\
00:50:06.050 --> 00:50:08.610
\
Scott Mason: So, if I go back into my urban layer…

785
\
00:50:08.740 --> 00:50:16.180
\
Scott Mason: Yeah. Which is where… urban… it's over here, because it's one of these that's outlined in red, because it's quoted work.

786
\
00:50:16.320 --> 00:50:17.820
\
Scott Mason: Should be one of these.

787
\
00:50:18.670 --> 00:50:23.300
\
Graham Stoddart-Stones: Alright, so now go up into a northeast area, if you know one.

788
\
00:50:23.660 --> 00:50:25.549
\
Scott Mason: Well, no, not so good with that area.

789
\
00:50:25.550 --> 00:50:26.165
\
Graham Stoddart-Stones: You…

790
\
00:50:26.780 --> 00:50:29.020
\
Scott Mason: It's because I live in the Southwest.

791
\
00:50:29.020 --> 00:50:34.560
\
Graham Stoddart-Stones: Right. Well, just, click on any one of those points, it doesn't matter which one.

792
\
00:50:34.750 --> 00:50:35.320
\
Scott Mason: Yeah.

793
\
00:50:35.530 --> 00:50:39.219
\
Graham Stoddart-Stones: Yeah, now go into, View Coordinates.

794
\
00:50:39.760 --> 00:50:40.650
\
Scott Mason: Where's fine.

795
\
00:50:40.650 --> 00:50:42.249
\
Graham Stoddart-Stones: Oh, no, sorry, just right quick.

796
\
00:50:42.250 --> 00:50:45.419
\
Stuart Bacon: put it there on the centroid, that's fine. Yeah, that's it.

797
\
00:50:46.240 --> 00:50:48.040
\
Scott Mason: What's that number on the spreadsheet?

798
\
00:50:48.040 --> 00:50:49.170
\
Graham Stoddart-Stones: 31…

799
\
00:50:50.270 --> 00:50:50.860
\
Stuart Bacon: Yep.

800
\
00:50:51.030 --> 00:50:52.270
\
Graham Stoddart-Stones: 637…

801
\
00:50:56.820 --> 00:50:57.570
\
Scott Mason: is East.

802
\
00:50:57.730 --> 00:50:58.770
\
Scott Mason: That's right, isn't it?

803
\
00:50:58.990 --> 00:51:01.149
\
Stuart Bacon: Yeah, that's northeast, yeah.

804
\
00:51:01.150 --> 00:51:02.010
\
Graham Stoddart-Stones: Right, good.

805
\
00:51:02.010 --> 00:51:08.279
\
Stuart Bacon: So what you… now what we want to do… As well…

806
\
00:51:08.920 --> 00:51:11.400
\
Stuart Bacon: Is, do you want to know.

807
\
00:51:11.400 --> 00:51:12.170
\
Graham Stoddart-Stones: Even accordingly.

808
\
00:51:12.170 --> 00:51:14.639
\
Stuart Bacon: Do you want, do you want it, sort of,

809
\
00:51:14.790 --> 00:51:27.269
\
Stuart Bacon: as a column for south and a north, and a column for east and west, or do you want a holistic column that says north, west, south, east?

810
\
00:51:27.510 --> 00:51:28.070
\
Stuart Bacon: Whatever.

811
\
00:51:29.730 --> 00:51:31.020
\
Scott Mason: Do you…

812
\
00:51:31.020 --> 00:51:32.489
\
Stuart Bacon: The way we can do that…

813
\
00:51:32.760 --> 00:51:34.540
\
Graham Stoddart-Stones: You can just do a formula.

814
\
00:51:34.540 --> 00:51:43.180
\
Stuart Bacon: The two, the two answers. So, for you, So… In U2?

815
\
00:51:44.280 --> 00:51:50.300
\
Scott Mason: thinking about the data that I want back from Geosphere is to come back with it all in four quadrants, so that would be… Yes.

816
\
00:51:50.300 --> 00:51:52.030
\
Graham Stoddart-Stones: Are you gonna say… In Northwest.

817
\
00:51:52.210 --> 00:51:53.020
\
Scott Mason: Northeast.

818
\
00:51:53.020 --> 00:51:59.060
\
Graham Stoddart-Stones: similar in… In column U, Yeah.

819
\
00:52:02.130 --> 00:52:04.570
\
Graham Stoddart-Stones: Go down to…

820
\
00:52:04.570 --> 00:52:05.670
\
Stuart Bacon: Oh, so…

821
\
00:52:05.670 --> 00:52:06.779
\
Graham Stoddart-Stones: Yeah, you too.

822
\
00:52:08.360 --> 00:52:10.000
\
Stuart Bacon: equals CONCAT.

823
\
00:52:11.000 --> 00:52:12.490
\
Scott Mason: Equals what?

824
\
00:52:12.490 --> 00:52:12.930
\
Stuart Bacon: on…

825
\
00:52:12.930 --> 00:52:15.720
\
Graham Stoddart-Stones: C-O-N-C-A-T, yeah.

826
\
00:52:15.720 --> 00:52:16.440
\
Scott Mason: Yep.

827
\
00:52:17.410 --> 00:52:18.280
\
Graham Stoddart-Stones: Open bracket.

828
\
00:52:18.280 --> 00:52:18.810
\
Stuart Bacon: Excellent.

829
\
00:52:20.420 --> 00:52:26.800
\
Graham Stoddart-Stones: S2… Comma… T2.

830
\
00:52:29.230 --> 00:52:30.399
\
Stuart Bacon: Oh, it's graphics.

831
\
00:52:30.400 --> 00:52:31.600
\
Graham Stoddart-Stones: Close the brackets.

832
\
00:52:32.500 --> 00:52:33.330
\
Scott Mason: And enter.

833
\
00:52:33.630 --> 00:52:34.180
\
Graham Stoddart-Stones: Yep.

834
\
00:52:35.510 --> 00:52:38.080
\
Graham Stoddart-Stones: And now, just do your usual trick, there's a whole lot.

835
\
00:52:38.860 --> 00:52:41.070
\
Scott Mason: No, I can't remember that.

836
\
00:52:41.070 --> 00:52:43.069
\
Graham Stoddart-Stones: It's Ctrl-Shift-Down Arrow.

837
\
00:52:43.460 --> 00:52:44.460
\
Scott Mason: Control, shift.

838
\
00:52:44.460 --> 00:52:47.680
\
Stuart Bacon: We've left… Go left or so. You want to be in T2.

839
\
00:52:48.020 --> 00:52:48.480
\
Scott Mason: Yeah.

840
\
00:52:48.480 --> 00:52:52.669
\
Stuart Bacon: And just, yeah, controlling down.

841
\
00:52:52.860 --> 00:52:54.710
\
Scott Mason: Control, down, yeah.

842
\
00:52:54.900 --> 00:52:55.700
\
Stuart Bacon: Don't write.

843
\
00:52:56.400 --> 00:52:57.190
\
Scott Mason: Yep.

844
\
00:52:57.860 --> 00:52:59.480
\
Stuart Bacon: Now, Ctrl, shift, and up.

845
\
00:53:00.780 --> 00:53:01.480
\
Scott Mason: Okay.

846
\
00:53:01.670 --> 00:53:03.120
\
Stuart Bacon: And Ctrl-D.

847
\
00:53:04.060 --> 00:53:06.929
\
Stuart Bacon: To copy down everything that you've just done.

848
\
00:53:07.420 --> 00:53:08.000
\
Graham Stoddart-Stones: Yeah.

849
\
00:53:09.670 --> 00:53:10.340
\
Stuart Bacon: -Oh.

850
\
00:53:11.000 --> 00:53:13.250
\
Graham Stoddart-Stones: So then in Veeve, in Victor.

851
\
00:53:13.580 --> 00:53:14.100
\
Scott Mason: Yep.

852
\
00:53:15.880 --> 00:53:20.069
\
Graham Stoddart-Stones: If… Equals if, sorry, equals if.

853
\
00:53:20.070 --> 00:53:22.049
\
Scott Mason: Oh, equals F.

854
\
00:53:22.250 --> 00:53:25.459
\
Graham Stoddart-Stones: Is there a clever way of doing this, Stuart?

855
\
00:53:25.460 --> 00:53:26.390
\
Stuart Bacon: What do you want to do? Sorry, I'm.

856
\
00:53:26.390 --> 00:53:33.929
\
Graham Stoddart-Stones: Well, if it's Southwest, you want it in quarter… oh, I guess, actually, SW is all you need. Do you want four quarters? 1, 2, 3, and 4, Scott?

857
\
00:53:33.930 --> 00:53:34.360
\
Scott Mason: Yeah.

858
\
00:53:34.360 --> 00:53:37.410
\
Graham Stoddart-Stones: What do you do with SW, DW, E, EW.

859
\
00:53:37.410 --> 00:53:40.510
\
Scott Mason: No, we can make do with the abbreviations, that's fine.

860
\
00:53:40.510 --> 00:53:42.979
\
Graham Stoddart-Stones: So leave… you're fine, then, in case you don't.

861
\
00:53:43.420 --> 00:53:45.020
\
Stuart Bacon: I'm not done necessarily.

862
\
00:53:45.350 --> 00:53:49.479
\
Scott Mason: So it's got all four in here, has it? SW, SE…

863
\
00:53:51.370 --> 00:53:52.550
\
Graham Stoddart-Stones: Yeah, keep going.

864
\
00:53:53.890 --> 00:53:54.730
\
Scott Mason: Just go right down.

865
\
00:53:54.730 --> 00:53:58.669
\
Stuart Bacon: Your easy way to check it is to filter you. Yep, of course.

866
\
00:53:58.670 --> 00:54:03.890
\
Scott Mason: That's fine. So by providing that now to Geosphere, they can sort that into quadrants, yeah?

867
\
00:54:03.890 --> 00:54:05.129
\
Graham Stoddart-Stones: We need to do your urban.

868
\
00:54:05.130 --> 00:54:09.840
\
Stuart Bacon: No, you just need to put a title in U as to quadrant.

869
\
00:54:11.900 --> 00:54:12.490
\
Scott Mason: Yep.

870
\
00:54:12.690 --> 00:54:13.220
\
Graham Stoddart-Stones: Dude.

871
\
00:54:14.270 --> 00:54:19.309
\
Graham Stoddart-Stones: And you need your, this is just going to be the urban team, right?

872
\
00:54:19.310 --> 00:54:20.100
\
Scott Mason: Yes.

873
\
00:54:20.100 --> 00:54:24.229
\
Graham Stoddart-Stones: So, if you come left to the, ID, I think.

874
\
00:54:24.230 --> 00:54:25.679
\
Stuart Bacon: it into D2.

875
\
00:54:26.660 --> 00:54:27.650
\
Scott Mason: Yeah.

876
\
00:54:28.460 --> 00:54:32.930
\
Graham Stoddart-Stones: And then do all the way down, you can do is just call it…

877
\
00:54:32.930 --> 00:54:35.170
\
Stuart Bacon: Do you want to type in that, urban team?

878
\
00:54:35.620 --> 00:54:37.900
\
Graham Stoddart-Stones: Do you want to call it urban? Yeah.

879
\
00:54:38.410 --> 00:54:41.249
\
Scott Mason: Why have we got… oh, we cut on behalf of, that's the one before, isn't it?

880
\
00:54:41.250 --> 00:54:42.580
\
Graham Stoddart-Stones: Yes, exactly.

881
\
00:54:42.580 --> 00:54:44.830
\
Scott Mason: It just was confusing me a bit there.

882
\
00:54:45.220 --> 00:54:46.429
\
Graham Stoddart-Stones: That equals urban.

883
\
00:54:49.330 --> 00:54:50.999
\
Stuart Bacon: Yeah, it doesn't need the equals in it.

884
\
00:54:51.000 --> 00:54:53.239
\
Scott Mason: Oh, just over and then drag it down, or…

885
\
00:54:53.240 --> 00:54:55.609
\
Stuart Bacon: Okay. Yeah, well, we should do…

886
\
00:54:55.770 --> 00:54:58.629
\
Stuart Bacon: From… from that, don't fret,

887
\
00:54:58.820 --> 00:55:02.619
\
Stuart Bacon: Then we can go right to cells.

888
\
00:55:05.340 --> 00:55:07.290
\
Scott Mason: There, yep.

889
\
00:55:07.290 --> 00:55:11.150
\
Stuart Bacon: You want, you wanna be in… yeah. Now, control and down.

890
\
00:55:12.200 --> 00:55:12.720
\
Scott Mason: Yep.

891
\
00:55:13.120 --> 00:55:21.930
\
Stuart Bacon: We're getting to the bottom. Arrow across, 2 to the left, so he puts you in D968. Yeah. Now,

892
\
00:55:22.440 --> 00:55:24.010
\
Stuart Bacon: Ctrl-Shift-Up.

893
\
00:55:26.730 --> 00:55:28.410
\
Stuart Bacon: and CTRL and D.

894
\
00:55:30.140 --> 00:55:30.720
\
Scott Mason: Okay.

895
\
00:55:30.830 --> 00:55:31.340
\
Graham Stoddart-Stones: Come on.

896
\
00:55:31.340 --> 00:55:33.670
\
Stuart Bacon: I've got it… got urban in all of your…

897
\
00:55:34.280 --> 00:55:36.740
\
Graham Stoddart-Stones: Oh, you ain't… oh, you… heh. Oh.

898
\
00:55:36.740 --> 00:55:37.400
\
Scott Mason: Wasn't quite at the top.

899
\
00:55:39.500 --> 00:55:42.589
\
Stuart Bacon: That's alright, that's… that's fine, we can sort that. If we…

900
\
00:55:42.590 --> 00:55:43.379
\
Scott Mason: Drag it out of Kai.

901
\
00:55:43.490 --> 00:55:47.050
\
Stuart Bacon: Yeah, you can drag it, or whatever now, or you just, control and…

902
\
00:55:47.090 --> 00:55:49.460
\
Scott Mason: Don't worry, I'll go this way.

903
\
00:55:49.460 --> 00:55:53.770
\
Stuart Bacon: I was thinking you've got a few hundred, sales to get up that way, that's all.

904
\
00:55:53.770 --> 00:55:55.909
\
Scott Mason: Yeah, that's right, talk of my.

905
\
00:55:55.910 --> 00:56:00.069
\
Graham Stoddart-Stones: What's that line that has a blank in it? They didn't like that one.

906
\
00:56:00.640 --> 00:56:01.450
\
Scott Mason: Which one?

907
\
00:56:01.690 --> 00:56:05.850
\
Graham Stoddart-Stones: Well, there was a blank line that had nothing across it, across the horizontal, and…

908
\
00:56:06.920 --> 00:56:10.500
\
Graham Stoddart-Stones: Jasper is a bit, sort of, sensitive about blank lines.

909
\
00:56:13.100 --> 00:56:21.930
\
Stuart Bacon: We'll filter for one in a second. Scroll… Just clicking… click on… the…

910
\
00:56:23.220 --> 00:56:23.730
\
Scott Mason: Meh?

911
\
00:56:24.100 --> 00:56:27.240
\
Stuart Bacon: Yeah, go, go CTRL and UP.

912
\
00:56:27.380 --> 00:56:28.380
\
Stuart Bacon: For the moment.

913
\
00:56:28.620 --> 00:56:29.140
\
Scott Mason: Yep.

914
\
00:56:29.710 --> 00:56:36.090
\
Stuart Bacon: and then Ctrl-Shift, down from there.

915
\
00:56:36.850 --> 00:56:39.339
\
Stuart Bacon: And then CTRL and D again.

916
\
00:56:40.400 --> 00:56:41.020
\
Scott Mason: Cool.

917
\
00:56:41.350 --> 00:56:49.390
\
Stuart Bacon: Right, that's done those. Now, if you on… Column A… Let's filter that.

918
\
00:56:51.950 --> 00:56:54.540
\
Stuart Bacon: Get rid of the years.

919
\
00:56:54.670 --> 00:56:56.180
\
Stuart Bacon: We just want the blanks.

920
\
00:56:57.560 --> 00:57:00.659
\
Stuart Bacon: So, just… just click Select All.

921
\
00:57:00.660 --> 00:57:03.060
\
Scott Mason: Oh, I see. Sorry, yeah.

922
\
00:57:03.060 --> 00:57:03.760
\
Stuart Bacon: Yep.

923
\
00:57:04.870 --> 00:57:10.550
\
Stuart Bacon: So you've got… a number of…

924
\
00:57:10.550 --> 00:57:11.889
\
Scott Mason: Yeah, I don't know why that is.

925
\
00:57:11.890 --> 00:57:12.260
\
Stuart Bacon: from…

926
\
00:57:12.260 --> 00:57:14.940
\
Graham Stoddart-Stones: Well, we don't care about life cycle anyway, do we?

927
\
00:57:15.280 --> 00:57:19.849
\
Stuart Bacon: No, no, no, but it… all I'm testing is, we know now

928
\
00:57:19.980 --> 00:57:23.760
\
Stuart Bacon: That you've… you have got an issue, we haven't got everything.

929
\
00:57:23.760 --> 00:57:24.330
\
Scott Mason: Yeah.

930
\
00:57:24.330 --> 00:57:29.530
\
Stuart Bacon: Because 969… in… is itself… Blank.

931
\
00:57:30.500 --> 00:57:32.359
\
Stuart Bacon: Okay. In, column D.

932
\
00:57:33.500 --> 00:57:38.720
\
Stuart Bacon: So, we've got… Yeah. That one just wants to say urban.

933
\
00:57:40.850 --> 00:57:41.590
\
Stuart Bacon: Yep.

934
\
00:57:41.870 --> 00:57:51.410
\
Stuart Bacon: And you want to copy across… The, the… North, south.

935
\
00:57:51.640 --> 00:57:53.180
\
Stuart Bacon: sort of quadrun.

936
\
00:57:53.570 --> 00:57:56.779
\
Stuart Bacon: Or is E969 intentionally blank?

937
\
00:57:57.360 --> 00:57:57.780
\
Graham Stoddart-Stones: Yeah.

938
\
00:57:57.780 --> 00:57:59.670
\
Scott Mason: I don't know what that relates to, to be honest, so…

939
\
00:58:00.830 --> 00:58:02.099
\
Scott Mason: Quite willing to take the risk and lose it.

940
\
00:58:02.100 --> 00:58:07.859
\
Stuart Bacon: Don't turn take the filter off, column A,

941
\
00:58:11.180 --> 00:58:13.410
\
Stuart Bacon: So, select all.

942
\
00:58:15.780 --> 00:58:23.350
\
Stuart Bacon: Yep, and now… Either in column D or A.

943
\
00:58:25.240 --> 00:58:30.550
\
Stuart Bacon: Click on… click on a cell, and then Ctrl and down.

944
\
00:58:33.110 --> 00:58:34.160
\
Stuart Bacon: And again…

945
\
00:58:36.520 --> 00:58:41.630
\
Stuart Bacon: Because you've got a couple there that are obviously missing dates, but that's not the end of it.

946
\
00:58:42.010 --> 00:58:50.849
\
Stuart Bacon: I don't know why. Keep going, keep pressing controlling down until we get to, sort of something in the 900s.

947
\
00:58:53.440 --> 00:58:58.559
\
Stuart Bacon: You might be quicker doing it in column D, because that would definitely take you down all the way.

948
\
00:59:01.520 --> 00:59:08.020
\
Stuart Bacon: Yeah, so there is nothing… all the data finishes in 968, so that 969 one can actually go.

949
\
00:59:08.430 --> 00:59:09.100
\
Scott Mason: Yeah.

950
\
00:59:09.100 --> 00:59:09.830
\
Stuart Bacon: Silly is.

951
\
00:59:09.830 --> 00:59:10.400
\
Scott Mason: Anthony?

952
\
00:59:10.860 --> 00:59:12.290
\
Scott Mason: Okay.

953
\
00:59:15.570 --> 00:59:18.209
\
Graham Stoddart-Stones: So, I would call this spreadsheet urban.

954
\
00:59:19.410 --> 00:59:21.959
\
Graham Stoddart-Stones: And then you can send it off and say…

955
\
00:59:21.960 --> 00:59:28.379
\
Stuart Bacon: Do you… do you save that as a spreadsheet as urban, or do you name the tab as urban?

956
\
00:59:28.380 --> 00:59:30.940
\
Graham Stoddart-Stones: No, I meant to say the spreadsheet is urban.

957
\
00:59:31.670 --> 00:59:32.989
\
Graham Stoddart-Stones: So that when he goes off.

958
\
00:59:32.990 --> 00:59:40.660
\
Stuart Bacon: If they've got multiple tabs in the same spreadsheet that you wanted uploading, it's easier than having multiple spreadsheets.

959
\
00:59:43.130 --> 00:59:44.300
\
Graham Stoddart-Stones: Okay.

960
\
00:59:45.600 --> 00:59:47.190
\
Stuart Bacon: So, where… where you've got…

961
\
00:59:48.180 --> 00:59:51.400
\
Graham Stoddart-Stones: Yeah, so you can… yes, okay, so you can rename the sheet.

962
\
00:59:51.400 --> 00:59:52.989
\
Stuart Bacon: Great ring on the shades, yeah.

963
\
00:59:52.990 --> 00:59:53.880
\
Scott Mason: Down here.

964
\
00:59:53.880 --> 00:59:54.480
\
Graham Stoddart-Stones: Yeah.

965
\
00:59:56.560 --> 00:59:57.660
\
Scott Mason: Just call it urban.

966
\
00:59:57.930 --> 00:59:58.530
\
Stuart Bacon: Yamaha.

967
\
00:59:58.810 --> 01:00:00.729
\
Graham Stoddart-Stones: And now go and create a new sheet.

968
\
01:00:01.400 --> 01:00:03.619
\
Graham Stoddart-Stones: for Team 1, whatever it was called.

969
\
01:00:03.900 --> 01:00:05.989
\
Scott Mason: Oh, I'm not doing alright against Team 1, am I?

970
\
01:00:06.480 --> 01:00:10.770
\
Graham Stoddart-Stones: Yes, I'm a patient. Oh my god.

971
\
01:00:10.810 --> 01:00:13.189
\
Stuart Bacon: Yes, but it's a lot… it's a lot easier now.

972
\
01:00:13.190 --> 01:00:13.750
\
Scott Mason: Sure.

973
\
01:00:13.750 --> 01:00:15.930
\
Graham Stoddart-Stones: Now, now that we've got the formula right.

974
\
01:00:16.480 --> 01:00:18.320
\
Scott Mason: And then I gotta do the same for Team 2.

975
\
01:00:18.320 --> 01:00:18.860
\
Stuart Bacon: Yeah.

976
\
01:00:19.050 --> 01:00:19.470
\
Graham Stoddart-Stones: Yes.

977
\
01:00:20.120 --> 01:00:23.300
\
Scott Mason: I was quite prepared just to copy them one by one, to be honest.

978
\
01:00:23.520 --> 01:00:24.380
\
Graham Stoddart-Stones: After that.

979
\
01:00:27.490 --> 01:00:30.789
\
Graham Stoddart-Stones: Is it just the three teams? You just have the three teams, right?

980
\
01:00:30.790 --> 01:00:34.030
\
Scott Mason: Yeah, let me just go back and just double check, that covers everything.

981
\
01:00:35.760 --> 01:00:38.940
\
Scott Mason: Grass, Box Team 1, Box Team 2, and Urban, yeah.

982
\
01:00:38.940 --> 01:00:39.730
\
Graham Stoddart-Stones: Okay.

983
\
01:00:41.490 --> 01:00:45.830
\
Stuart Bacon: Yeah, so we now need to go back to the map. Sorry.

984
\
01:00:47.240 --> 01:00:47.940
\
Scott Mason: Alright.

985
\
01:00:47.990 --> 01:00:51.370
\
Stuart Bacon: And go back into administration.

986
\
01:00:55.570 --> 01:00:57.920
\
Stuart Bacon: And edit…

987
\
01:00:58.450 --> 01:01:06.279
\
Stuart Bacon: Team 1 and Team 2, because we didn't… well, while we set up the requirements in the urban layer, we didn't add the same fields into…

988
\
01:01:06.280 --> 01:01:06.930
\
Scott Mason: I didn't.

989
\
01:01:06.930 --> 01:01:07.799
\
Graham Stoddart-Stones: Yeah, very good.

990
\
01:01:07.800 --> 01:01:08.140
\
Stuart Bacon: Yeah.

991
\
01:01:09.540 --> 01:01:10.519
\
Scott Mason: What do we have?

992
\
01:01:10.520 --> 01:01:11.030
\
Graham Stoddart-Stones: I've done there before.

993
\
01:01:11.030 --> 01:01:12.870
\
Scott Mason: Or team name, that's right.

994
\
01:01:13.160 --> 01:01:14.970
\
Graham Stoddart-Stones: nigga.

995
\
01:01:16.470 --> 01:01:17.010
\
Scott Mason: shouldn't…

996
\
01:01:18.900 --> 01:01:20.719
\
Graham Stoddart-Stones: We know he's just gonna check it.

997
\
01:01:22.860 --> 01:01:23.730
\
Stuart Bacon: Save that.

998
\
01:01:24.970 --> 01:01:26.580
\
Scott Mason: Should I do the same for Team 2 whilst I'm here?

999
\
01:01:26.580 --> 01:01:32.709
\
Stuart Bacon: While you're there, I would go back to Urban Team and just double-check we've got the names right.

1000
\
01:01:32.710 --> 01:01:35.510
\
Scott Mason: Yeah, not sure it was called Quarter Name we had.

1001
\
01:01:35.510 --> 01:01:36.380
\
Graham Stoddart-Stones: Sorry, yeah.

1002
\
01:01:36.380 --> 01:01:37.450
\
Scott Mason: quarter, and that's right.

1003
\
01:01:41.690 --> 01:01:46.390
\
Stuart Bacon: And then, yeah, if we go back up and edit that, we can change that quadrant to call to name.

1004
\
01:01:50.780 --> 01:01:51.320
\
Graham Stoddart-Stones: Good.

1005
\
01:01:51.630 --> 01:01:54.990
\
Graham Stoddart-Stones: And do it at the end for Team 3, or Team 2, what is the app.

1006
\
01:02:00.420 --> 01:02:01.760
\
Stuart Bacon: 39 quartzone.

1007
\
01:02:11.950 --> 01:02:12.960
\
Stuart Bacon: Drive power.

1008
\
01:02:15.870 --> 01:02:16.540
\
Stuart Bacon: Moved.

1009
\
01:02:20.160 --> 01:02:21.260
\
Scott Mason: Okay.

1010
\
01:02:21.260 --> 01:02:22.680
\
Graham Stoddart-Stones: Go back to the map now.

1011
\
01:02:30.440 --> 01:02:35.299
\
Graham Stoddart-Stones: And turn on the Team 1 layer, and turn off all the others.

1012
\
01:02:39.890 --> 01:02:41.509
\
Scott Mason: I turn off parish boundary again.

1013
\
01:02:41.510 --> 01:02:42.620
\
Graham Stoddart-Stones: I would, yeah.

1014
\
01:02:46.390 --> 01:02:47.120
\
Graham Stoddart-Stones: And…

1015
\
01:02:47.120 --> 01:02:48.420
\
Scott Mason: Not so much from this one.

1016
\
01:02:48.960 --> 01:02:51.880
\
Graham Stoddart-Stones: No, right. So you can go back up to your parish…

1017
\
01:02:51.880 --> 01:02:57.239
\
Stuart Bacon: We don't need the line data on this one, we just need to down… we just need to go back up to the Team 1.

1018
\
01:02:57.420 --> 01:02:58.470
\
Graham Stoddart-Stones: We need you next week.

1019
\
01:02:58.470 --> 01:02:59.270
\
Stuart Bacon: what the data.

1020
\
01:02:59.270 --> 01:03:02.100
\
Graham Stoddart-Stones: Yeah, so if you go back up to Team 1 layer…

1021
\
01:03:02.100 --> 01:03:03.910
\
Scott Mason: And then… export.

1022
\
01:03:04.120 --> 01:03:07.200
\
Graham Stoddart-Stones: Exactly. Or table view in the export, yeah.

1023
\
01:03:07.330 --> 01:03:09.529
\
Graham Stoddart-Stones: Don't forget to turn on the metadata.

1024
\
01:03:09.530 --> 01:03:10.140
\
Scott Mason: Yeah.

1025
\
01:03:12.670 --> 01:03:15.380
\
Scott Mason: 91 results, that's much more manageable.

1026
\
01:03:15.380 --> 01:03:18.350
\
Graham Stoddart-Stones: It's still a faster through it this way than the…

1027
\
01:03:21.870 --> 01:03:27.140
\
Stuart Bacon: And I've realized we booed in the spreadsheet, but it's a quick fix.

1028
\
01:03:29.670 --> 01:03:31.960
\
Scott Mason: Right, let me open that, 2 seconds.

1029
\
01:03:35.480 --> 01:03:39.140
\
Stuart Bacon: Now, clicking the triangle into the top left of A1.

1030
\
01:03:39.280 --> 01:03:39.890
\
Scott Mason: Yeah.

1031
\
01:03:40.370 --> 01:03:41.989
\
Stuart Bacon: Ctrl and C.

1032
\
01:03:42.610 --> 01:03:45.449
\
Scott Mason: Ctrl-C, yeah. Oh, we're gonna move into that spreadsheet.

1033
\
01:03:45.450 --> 01:03:47.469
\
Stuart Bacon: Move it into that other spreadsheet, yeah.

1034
\
01:03:47.770 --> 01:03:49.069
\
Scott Mason: There's this one here.

1035
\
01:03:49.070 --> 01:03:49.590
\
Stuart Bacon: Yep.

1036
\
01:03:49.980 --> 01:03:50.330
\
Scott Mason: fit there.

1037
\
01:03:50.600 --> 01:03:51.649
\
Stuart Bacon: I see that, yeah.

1038
\
01:03:51.650 --> 01:03:52.690
\
Graham Stoddart-Stones: Okay, wait, wait.

1039
\
01:03:55.080 --> 01:03:57.169
\
Graham Stoddart-Stones: You need to add your extra columns on the right.

1040
\
01:03:57.170 --> 01:03:59.499
\
Stuart Bacon: Now, come back to Urban.

1041
\
01:04:01.080 --> 01:04:10.600
\
Stuart Bacon: And go across to… Highlight S2… sorry, S1 to U2.

1042
\
01:04:12.030 --> 01:04:13.659
\
Stuart Bacon: But Dayton? Yep.

1043
\
01:04:13.860 --> 01:04:14.890
\
Stuart Bacon: Copy that.

1044
\
01:04:17.960 --> 01:04:20.749
\
Stuart Bacon: And built that in.

1045
\
01:04:21.120 --> 01:04:23.829
\
Stuart Bacon: Stick it in S to keep it consistent, yep.

1046
\
01:04:24.460 --> 01:04:26.650
\
Scott Mason: Do the same for Team 2 as well, or not?

1047
\
01:04:26.910 --> 01:04:29.190
\
Scott Mason: Oh no, I can't do that yet, because I haven't imported the data online.

1048
\
01:04:29.190 --> 01:04:32.560
\
Stuart Bacon: You can, you can do it now, cause, yeah.

1049
\
01:04:33.750 --> 01:04:39.310
\
Graham Stoddart-Stones: Go back to the map. You have to go back to your map. Oh, yeah.

1050
\
01:04:39.310 --> 01:04:53.850
\
Stuart Bacon: What we need to do, I think, you, you now need to… Click on P,

1051
\
01:04:55.240 --> 01:04:58.709
\
Stuart Bacon: Click on… click on one of the P, one of the cells in P.

1052
\
01:05:00.330 --> 01:05:01.920
\
Stuart Bacon: Control and down.

1053
\
01:05:03.150 --> 01:05:03.660
\
Scott Mason: Yep.

1054
\
01:05:04.670 --> 01:05:07.330
\
Stuart Bacon: Right across to S,

1055
\
01:05:11.270 --> 01:05:12.290
\
Stuart Bacon: Now…

1056
\
01:05:13.320 --> 01:05:13.979
\
Graham Stoddart-Stones: In the office.

1057
\
01:05:14.500 --> 01:05:14.840
\
Graham Stoddart-Stones: Are you?

1058
\
01:05:14.840 --> 01:05:20.360
\
Stuart Bacon: And, ctrl and right twice.

1059
\
01:05:20.700 --> 01:05:21.760
\
Stuart Bacon: would shift.

1060
\
01:05:22.930 --> 01:05:24.069
\
Scott Mason: But yeah, hang on.

1061
\
01:05:26.390 --> 01:05:28.710
\
Scott Mason: It's getting too late on a Friday for this.

1062
\
01:05:28.710 --> 01:05:29.050
\
Graham Stoddart-Stones: Yeah.

1063
\
01:05:29.050 --> 01:05:31.199
\
Scott Mason: Right, S, where am I going?

1064
\
01:05:31.200 --> 01:05:34.049
\
Stuart Bacon: That one, yeah. Ctrl-Shift and Right twice.

1065
\
01:05:35.020 --> 01:05:36.119
\
Scott Mason: Oh, it's done something funny.

1066
\
01:05:36.120 --> 01:05:41.889
\
Stuart Bacon: Sorry, hang on, go back, it's not Ctrl-Shift. It's what… it's my fault. Shift and right twice.

1067
\
01:05:42.420 --> 01:05:43.000
\
Scott Mason: Yep.

1068
\
01:05:43.810 --> 01:05:46.729
\
Stuart Bacon: now, Ctrl, Shift, and up.

1069
\
01:05:47.370 --> 01:05:49.169
\
Scott Mason: Drove shift up, yeah.

1070
\
01:05:49.830 --> 01:05:51.110
\
Stuart Bacon: and Ctrl-D.

1071
\
01:05:51.590 --> 01:05:52.950
\
Scott Mason: Control D.

1072
\
01:05:53.780 --> 01:05:54.140
\
Graham Stoddart-Stones: Perfect.

1073
\
01:05:54.140 --> 01:06:04.340
\
Stuart Bacon: pops that all in there. Just scroll up slightly so I can see the column headers again. Now we need to go to D.

1074
\
01:06:05.770 --> 01:06:10.759
\
Stuart Bacon: D2, Oh, yeah. And put in Team 1.

1075
\
01:06:13.390 --> 01:06:16.950
\
Stuart Bacon: I mean, E… 2…

1076
\
01:06:18.320 --> 01:06:21.100
\
Stuart Bacon: equals… U2.

1077
\
01:06:23.860 --> 01:06:25.470
\
Stuart Bacon: Bye-bye. Yep.

1078
\
01:06:26.820 --> 01:06:29.170
\
Stuart Bacon: Now…

1079
\
01:06:34.620 --> 01:06:39.389
\
Stuart Bacon: Yeah, we need to get to the bottom of the thing, so click… go… go right one.

1080
\
01:06:41.220 --> 01:06:42.610
\
Stuart Bacon: Ctrl and D.

1081
\
01:06:43.360 --> 01:06:48.800
\
Stuart Bacon: Sorry, control… not Control and D, don't… control, controlling down.

1082
\
01:06:51.570 --> 01:06:55.750
\
Stuart Bacon: Now go… left one.

1083
\
01:06:57.320 --> 01:06:59.479
\
Stuart Bacon: Left, shift and left.

1084
\
01:07:01.850 --> 01:07:02.330
\
Stuart Bacon: Yep.

1085
\
01:07:02.330 --> 01:07:02.649
\
Graham Stoddart-Stones: You know?

1086
\
01:07:02.820 --> 01:07:04.640
\
Stuart Bacon: control, shift, and up.

1087
\
01:07:07.530 --> 01:07:09.920
\
Stuart Bacon: And then CTRL and D.

1088
\
01:07:12.280 --> 01:07:13.020
\
Graham Stoddart-Stones: Hold on.

1089
\
01:07:13.950 --> 01:07:14.550
\
Scott Mason: Okay?

1090
\
01:07:14.900 --> 01:07:17.519
\
Graham Stoddart-Stones: So you can go back and make the same changes to urban.

1091
\
01:07:18.590 --> 01:07:20.839
\
Graham Stoddart-Stones: So go into CTRL-E and make it…

1092
\
01:07:21.300 --> 01:07:23.800
\
Graham Stoddart-Stones: So, in economy, you make it a course name.

1093
\
01:07:24.840 --> 01:07:26.610
\
Stuart Bacon: So we need to go click on the urban…

1094
\
01:07:27.410 --> 01:07:28.880
\
Scott Mason: Oh, yeah, Urban, sorry.

1095
\
01:07:30.500 --> 01:07:35.600
\
Stuart Bacon: equals U2… Answer.

1096
\
01:07:35.770 --> 01:07:37.930
\
Stuart Bacon: Click, arrow left.

1097
\
01:07:39.430 --> 01:07:41.010
\
Stuart Bacon: Ctrl down.

1098
\
01:07:42.510 --> 01:07:43.660
\
Stuart Bacon: Aaron Wright.

1099
\
01:07:45.080 --> 01:07:46.560
\
Stuart Bacon: Ctrl-Shift-Up.

1100
\
01:07:48.450 --> 01:07:49.670
\
Stuart Bacon: Ctrl D.

1101
\
01:07:50.900 --> 01:07:51.680
\
Graham Stoddart-Stones: Bingo.

1102
\
01:07:52.910 --> 01:07:54.950
\
Scott Mason: Just Team 2 to go, then?

1103
\
01:07:54.950 --> 01:07:56.550
\
Graham Stoddart-Stones: Go back to the bat, man.

1104
\
01:07:56.550 --> 01:07:57.739
\
Scott Mason: So, back to the map.

1105
\
01:07:58.130 --> 01:08:00.130
\
Scott Mason: And extract the data.

1106
\
01:08:00.400 --> 01:08:00.860
\
Graham Stoddart-Stones: Yup.

1107
\
01:08:02.080 --> 01:08:05.040
\
Scott Mason: Team 2…

1108
\
01:08:05.040 --> 01:08:05.920
\
Graham Stoddart-Stones: Yep, hold on.

1109
\
01:08:06.610 --> 01:08:07.850
\
Scott Mason: table view…

1110
\
01:08:08.030 --> 01:08:09.360
\
Graham Stoddart-Stones: You're really getting the hang of this now.

1111
\
01:08:09.360 --> 01:08:10.780
\
Scott Mason: export.

1112
\
01:08:12.190 --> 01:08:15.600
\
Scott Mason: Metadata export… Found aid.

1113
\
01:08:26.640 --> 01:08:28.449
\
Scott Mason: And then copy all of this.

1114
\
01:08:28.450 --> 01:08:28.850
\
Graham Stoddart-Stones: Yep.

1115
\
01:08:28.850 --> 01:08:31.300
\
Stuart Bacon: Copy all of that. No,

1116
\
01:08:31.920 --> 01:08:36.140
\
Stuart Bacon: Yeah, copy all… copy all that, that'll be fine. Yeah. It's alright.

1117
\
01:08:38.849 --> 01:08:41.399
\
Scott Mason: And then move that into our…

1118
\
01:08:41.399 --> 01:08:42.359
\
Graham Stoddart-Stones: Tea tree.

1119
\
01:08:44.180 --> 01:08:45.699
\
Scott Mason: Which one is it now?

1120
\
01:08:45.700 --> 01:08:49.270
\
Stuart Bacon: It's the right-hand side… no, sorry, the left-hand side one. The left-hand side one.

1121
\
01:08:49.490 --> 01:08:50.090
\
Scott Mason: Oh, yeah.

1122
\
01:08:50.880 --> 01:08:52.449
\
Scott Mason: And then put that into here, yeah?

1123
\
01:08:52.590 --> 01:08:53.510
\
Stuart Bacon: Yep. Yep.

1124
\
01:08:54.140 --> 01:08:56.249
\
Stuart Bacon: Now go to Team 1 again.

1125
\
01:08:58.439 --> 01:09:02.859
\
Stuart Bacon: And we need to copy S, S1 to U2.

1126
\
01:09:05.029 --> 01:09:07.359
\
Stuart Bacon: But then… You wanna…

1127
\
01:09:07.700 --> 01:09:08.950
\
Scott Mason: That, all of that.

1128
\
01:09:08.950 --> 01:09:09.490
\
Stuart Bacon: Yep.

1129
\
01:09:10.670 --> 01:09:12.520
\
Graham Stoddart-Stones: entertain 2? Yep.

1130
\
01:09:13.470 --> 01:09:14.300
\
Graham Stoddart-Stones: Repeat?

1131
\
01:09:14.590 --> 01:09:15.120
\
Stuart Bacon: Yep.

1132
\
01:09:15.370 --> 01:09:22.349
\
Stuart Bacon: And now… go to… Click on P2.

1133
\
01:09:24.529 --> 01:09:26.929
\
Stuart Bacon: Control and D… sorry, not control.

1134
\
01:09:26.930 --> 01:09:27.520
\
Graham Stoddart-Stones: Nope.

1135
\
01:09:27.520 --> 01:09:30.470
\
Stuart Bacon: Controlling down, alright. Yeah.

1136
\
01:09:31.269 --> 01:09:39.789
\
Stuart Bacon: Arrow across to S, Shift and right twice.

1137
\
01:09:40.960 --> 01:09:41.520
\
Graham Stoddart-Stones: Yep.

1138
\
01:09:41.740 --> 01:09:44.960
\
Stuart Bacon: Ctrl, shift, and up.

1139
\
01:09:46.910 --> 01:09:48.080
\
Stuart Bacon: Ctrl D.

1140
\
01:09:50.470 --> 01:09:55.769
\
Stuart Bacon: That gets that. Now we've got to do the other bit. So, in D2.

1141
\
01:09:56.750 --> 01:09:57.320
\
Scott Mason: Yep.

1142
\
01:09:58.640 --> 01:09:59.390
\
Graham Stoddart-Stones: Interesting.

1143
\
01:10:02.140 --> 01:10:06.205
\
Stuart Bacon: And in quarter name, I'm…

1144
\
01:10:06.630 --> 01:10:07.610
\
Graham Stoddart-Stones: We'll see you too.

1145
\
01:10:07.610 --> 01:10:09.389
\
Stuart Bacon: C, it equals U2.

1146
\
01:10:12.100 --> 01:10:12.670
\
Scott Mason: Okay.

1147
\
01:10:13.290 --> 01:10:23.570
\
Stuart Bacon: Now, arrow right into F3, and… Control and, dam.

1148
\
01:10:26.010 --> 01:10:27.700
\
Stuart Bacon: Arrow left.

1149
\
01:10:29.650 --> 01:10:30.970
\
Stuart Bacon: Shift and left.

1150
\
01:10:32.630 --> 01:10:34.110
\
Stuart Bacon: Ctrl-Shift-Up.

1151
\
01:10:35.700 --> 01:10:36.920
\
Stuart Bacon: Ctrl D.

1152
\
01:10:37.650 --> 01:10:38.879
\
Graham Stoddart-Stones: Bingo, well done.

1153
\
01:10:40.590 --> 01:10:41.130
\
Scott Mason: Huge.

1154
\
01:10:41.130 --> 01:10:41.630
\
Stuart Bacon: still today.

1155
\
01:10:43.030 --> 01:10:44.560
\
Stuart Bacon: Now…

1156
\
01:10:44.740 --> 01:10:46.860
\
Graham Stoddart-Stones: Peace, peace, peace, peace, save.

1157
\
01:10:47.750 --> 01:10:50.099
\
Graham Stoddart-Stones: The spreadsheet with a decent name.

1158
\
01:10:52.550 --> 01:10:54.779
\
Stuart Bacon: Somewhere where you know you can find it.

1159
\
01:10:54.780 --> 01:10:59.470
\
Scott Mason: Well, a desktop's as good as any. But now, anyway…

1160
\
01:11:00.410 --> 01:11:02.670
\
Graham Stoddart-Stones: With a more exciting name than that one.

1161
\
01:11:06.370 --> 01:11:11.210
\
Scott Mason: Oak quarters… CSV, fine, okay.

1162
\
01:11:11.990 --> 01:11:13.849
\
Scott Mason: Sounds fantastic.

1163
\
01:11:15.420 --> 01:11:22.440
\
Stuart Bacon: You don't save it as a… as an Excel workbook rather than a CSV, is it? Oh, okay. Yeah.

1164
\
01:11:32.510 --> 01:11:35.359
\
Stuart Bacon: Yeah, if you go Excel workbook, save.

1165
\
01:11:37.200 --> 01:11:39.949
\
Stuart Bacon: I don't think it'll make a massive…

1166
\
01:11:39.950 --> 01:11:40.430
\
Scott Mason: it.

1167
\
01:11:40.430 --> 01:11:41.910
\
Stuart Bacon: Challenge for it, but…

1168
\
01:11:45.680 --> 01:11:46.670
\
Stuart Bacon: Cool, yeah.

1169
\
01:11:48.420 --> 01:11:54.239
\
Stuart Bacon: So that's now… that's now roughly ready… For you to, sort of.

1170
\
01:11:54.860 --> 01:11:59.799
\
Stuart Bacon: hang off, to support Jesus at, parish online.

1171
\
01:12:01.320 --> 01:12:01.690
\
Scott Mason: Yeah.

1172
\
01:12:02.370 --> 01:12:04.180
\
Stuart Bacon: What you potentially have.

1173
\
01:12:04.320 --> 01:12:06.870
\
Stuart Bacon: Hang on, why has it done that?

1174
\
01:12:07.530 --> 01:12:12.900
\
Stuart Bacon: Change the… Tab 3… Has changed its name.

1175
\
01:12:13.650 --> 01:12:15.910
\
Scott Mason: Oh yeah, it's Parish Online Quarters, yeah.

1176
\
01:12:15.910 --> 01:12:16.500
\
Stuart Bacon: Yeah.

1177
\
01:12:16.640 --> 01:12:19.320
\
Stuart Bacon: Change that to Team 2.

1178
\
01:12:19.790 --> 01:12:21.459
\
Scott Mason: Hang on.

1179
\
01:12:21.460 --> 01:12:22.030
\
Stuart Bacon: Right-click on.

1180
\
01:12:22.030 --> 01:12:23.296
\
Graham Stoddart-Stones: Oh, you…

1181
\
01:12:24.440 --> 01:12:24.900
\
Stuart Bacon: brilliant.

1182
\
01:12:24.950 --> 01:12:27.340
\
Graham Stoddart-Stones: In the sheet, rather than the spreadsheet.

1183
\
01:12:28.040 --> 01:12:32.079
\
Scott Mason: It's called Passion Line Quarters at the top, so I just saved that, yeah. Yeah, right.

1184
\
01:12:32.080 --> 01:12:32.660
\
Stuart Bacon: Yeah.

1185
\
01:12:33.160 --> 01:12:39.960
\
Stuart Bacon: Yeah, that will… that will… Sort of,

1186
\
01:12:40.490 --> 01:12:43.489
\
Stuart Bacon: If you, if you send that to Parish Online as is.

1187
\
01:12:43.490 --> 01:12:44.120
\
Scott Mason: Yep.

1188
\
01:12:44.440 --> 01:12:51.580
\
Stuart Bacon: That will sort of enable them to, amend what you've got.

1189
\
01:12:51.580 --> 01:12:52.580
\
Scott Mason: So… Okay.

1190
\
01:12:52.580 --> 01:12:55.640
\
Stuart Bacon: What meets up with the red lines?

1191
\
01:12:55.890 --> 01:12:56.560
\
Scott Mason: Okay.

1192
\
01:12:57.420 --> 01:13:02.929
\
Stuart Bacon: If you… if there are some of those that you change… you decide you want to change the boundaries of.

1193
\
01:13:02.930 --> 01:13:03.670
\
Scott Mason: Yeah.

1194
\
01:13:04.870 --> 01:13:05.280
\
Stuart Bacon: casino.

1195
\
01:13:05.280 --> 01:13:07.139
\
Graham Stoddart-Stones: They will cross over lines, won't they?

1196
\
01:13:07.140 --> 01:13:08.730
\
Scott Mason: They will, slightly, yeah.

1197
\
01:13:08.730 --> 01:13:11.109
\
Stuart Bacon: Yeah, I was gonna say, cause I think…

1198
\
01:13:11.460 --> 01:13:13.640
\
Stuart Bacon: I don't… I don't know, but looking at…

1199
\
01:13:13.770 --> 01:13:22.540
\
Stuart Bacon: just looking at the geography of Bridgewater and whatever, I'm assuming your southwest quadrant.

1200
\
01:13:22.740 --> 01:13:32.119
\
Stuart Bacon: is likely to be anything, west of the A38 and south of, Was it Consultant, or…

1201
\
01:13:32.120 --> 01:13:34.529
\
Scott Mason: Yeah, Quantock Road, yeah, you're right, yeah.

1202
\
01:13:36.530 --> 01:13:41.760
\
Scott Mason: Realistically, I see some of these areas falling into, you know, the southwest quadrant, really.

1203
\
01:13:42.460 --> 01:13:49.500
\
Stuart Bacon: Yeah, I mean, there's a couple of green areas there that sort of sit above the line, but it might be…

1204
\
01:13:49.980 --> 01:13:52.370
\
Stuart Bacon: It might be quicker and easier.

1205
\
01:13:52.620 --> 01:13:59.360
\
Stuart Bacon: So, wait and amend those when Parish Online have

1206
\
01:13:59.840 --> 01:14:01.990
\
Stuart Bacon: Uploading all the data for you.

1207
\
01:14:01.990 --> 01:14:08.190
\
Scott Mason: So when the layer's created, I could go in and duplicate each, because there's only a few, isn't there? I could go in, I could copy it to another layer…

1208
\
01:14:08.190 --> 01:14:13.199
\
Stuart Bacon: I think what you would do is, as you've got there now.

1209
\
01:14:13.300 --> 01:14:20.249
\
Stuart Bacon: You, you will just click on the… on the area, and edit the text, edit the detail.

1210
\
01:14:20.250 --> 01:14:21.590
\
Graham Stoddart-Stones: Yeah.

1211
\
01:14:22.270 --> 01:14:22.850
\
Scott Mason: Oh, I see.

1212
\
01:14:22.850 --> 01:14:24.260
\
Graham Stoddart-Stones: It is a quarter name.

1213
\
01:14:24.660 --> 01:14:26.230
\
Scott Mason: True, yeah, okay.

1214
\
01:14:28.220 --> 01:14:33.519
\
Stuart Bacon: Because, I mean, it'll… you'll have, sort of, 98% there, but the.

1215
\
01:14:33.520 --> 01:14:33.840
\
Scott Mason: Yeah.

1216
\
01:14:33.840 --> 01:14:43.080
\
Stuart Bacon: tweaking on one or two of them that might not fit exactly to the… if you want to do it to roads rather than the red line.

1217
\
01:14:43.080 --> 01:14:43.670
\
Scott Mason: Yeah.

1218
\
01:14:43.670 --> 01:14:46.650
\
Stuart Bacon: That would just be how it, sort of, separates it out.

1219
\
01:14:46.880 --> 01:14:48.090
\
Scott Mason: Okay.

1220
\
01:14:48.780 --> 01:14:49.380
\
Scott Mason: I won't…

1221
\
01:14:49.540 --> 01:14:59.490
\
Scott Mason: if I want Geosphere to supply this as four separate layers, so obviously a north… a northeast, north… is… is that possible, I guess, if I put that in the request? Yeah.

1222
\
01:14:59.490 --> 01:15:02.089
\
Graham Stoddart-Stones: Is it… why do you want them as 4 separate layers?

1223
\
01:15:02.830 --> 01:15:10.560
\
Scott Mason: I'm thinking if we want to make this a public link to the operatives, then I want to…

1224
\
01:15:10.560 --> 01:15:11.180
\
Graham Stoddart-Stones: We each player.

1225
\
01:15:11.180 --> 01:15:11.520
\
Scott Mason: Pretty neat.

1226
\
01:15:11.520 --> 01:15:11.980
\
Graham Stoddart-Stones: each quarter.

1227
\
01:15:11.980 --> 01:15:14.890
\
Scott Mason: quadrant, they don't need everyone else's quadrant, essentially.

1228
\
01:15:17.170 --> 01:15:17.690
\
Graham Stoddart-Stones: Yeah.

1229
\
01:15:17.690 --> 01:15:21.479
\
Scott Mason: and I would give them a public URL to Northeast, for instance.

1230
\
01:15:23.360 --> 01:15:28.709
\
Graham Stoddart-Stones: Okay, so, yes, just ask them to give you, one for each quarter.

1231
\
01:15:29.130 --> 01:15:29.750
\
Scott Mason: Yeah.

1232
\
01:15:31.060 --> 01:15:41.519
\
Scott Mason: So with this, what exactly am I asking when I'm requesting they use this spreadsheet? So I'm asking them to refer to the columns S, T, and U, am I, to then populate four maps?

1233
\
01:15:41.520 --> 01:15:44.979
\
Graham Stoddart-Stones: Team D\&E is what you're going to be looking at.

1234
\
01:15:45.610 --> 01:15:47.220
\
Scott Mason: Oh, okay, fine.

1235
\
01:15:47.220 --> 01:15:51.640
\
Graham Stoddart-Stones: the stuff over on the… to the right of R is just your calculation.

1236
\
01:15:51.640 --> 01:15:52.420
\
Scott Mason: Oh, I see.

1237
\
01:15:52.460 --> 01:15:59.239
\
Graham Stoddart-Stones: You don't need that. So, when you… if you open up a… an email now, Scott.

1238
\
01:16:00.130 --> 01:16:02.480
\
Scott Mason: I just want to make sure I ask for the right thing after we've done all that good work.

1239
\
01:16:02.480 --> 01:16:08.790
\
Graham Stoddart-Stones: Well, that's what I'm saying, let's open up the email. We're composed to… Yeah, personal, yeah, personal.

1240
\
01:16:08.790 --> 01:16:10.579
\
Scott Mason: Geosphere, or parish?

1241
\
01:16:10.580 --> 01:16:11.560
\
Graham Stoddart-Stones: Next one down, next one down.

1242
\
01:16:11.560 --> 01:16:12.600
\
Stuart Bacon: The fourth one, yeah.

1243
\
01:16:12.740 --> 01:16:13.330
\
Graham Stoddart-Stones: Yeah.

1244
\
01:16:13.510 --> 01:16:15.069
\
Graham Stoddart-Stones: That's the one, yep.

1245
\
01:16:16.170 --> 01:16:16.910
\
Scott Mason: Okay.

1246
\
01:16:18.560 --> 01:16:19.770
\
Scott Mason: So, what are we asking for?

1247
\
01:16:19.770 --> 01:16:32.330
\
Stuart Bacon: Request layer amendment, yeah, please continue, amend the data in… Parish lair… And I can't remember.

1248
\
01:16:32.330 --> 01:16:37.610
\
Graham Stoddart-Stones: No, I think if you do it that way, they will just create new… 4 new layers for you.

1249
\
01:16:37.610 --> 01:16:41.580
\
Scott Mason: walk 4 new, don't I? Please, could you create 4 new layers?

1250
\
01:16:43.040 --> 01:16:44.770
\
Scott Mason: Based on the…

1251
\
01:16:44.770 --> 01:16:46.279
\
Graham Stoddart-Stones: On the attached spreadsheet.

1252
\
01:16:48.830 --> 01:16:51.289
\
Scott Mason: Taking note of columns D and…

1253
\
01:16:51.290 --> 01:16:52.590
\
Graham Stoddart-Stones: Exactly, yes.

1254
\
01:16:52.810 --> 01:16:54.630
\
Graham Stoddart-Stones: Well, just E, actually, isn't it?

1255
\
01:16:56.480 --> 01:16:57.040
\
Scott Mason: That's.

1256
\
01:16:57.040 --> 01:17:06.129
\
Graham Stoddart-Stones: Do you want a spreadsheet for each layer, or a spreadsheet for each… sorry, each quarter, or a spreadsheet for each team? It's really just for each team, isn't it?

1257
\
01:17:06.130 --> 01:17:06.980
\
Scott Mason: Yeah.

1258
\
01:17:06.980 --> 01:17:07.900
\
Graham Stoddart-Stones: Here's D.

1259
\
01:17:08.200 --> 01:17:09.060
\
Scott Mason: D, then not E.

1260
\
01:17:09.060 --> 01:17:12.550
\
Graham Stoddart-Stones: Yeah, so 3… you want 3 switch… 3 layers.

1261
\
01:17:12.830 --> 01:17:13.690
\
Stuart Bacon: Is it… whoops.

1262
\
01:17:13.690 --> 01:17:17.790
\
Scott Mason: No, sorry, it'd be… no, it would be per quarter, so it'd be 4, so it'd be E.

1263
\
01:17:21.080 --> 01:17:23.390
\
Graham Stoddart-Stones: Yes, right, yep.

1264
\
01:17:24.470 --> 01:17:25.689
\
Graham Stoddart-Stones: That's right, you order there.

1265
\
01:17:25.690 --> 01:17:28.659
\
Stuart Bacon: All three teams will see what's in each quarter.

1266
\
01:17:28.870 --> 01:17:29.450
\
Scott Mason: Yeah.

1267
\
01:17:30.550 --> 01:17:32.009
\
Graham Stoddart-Stones: Yeah, based on this.

1268
\
01:17:32.120 --> 01:17:33.620
\
Graham Stoddart-Stones: There you go. That's fine.

1269
\
01:17:33.620 --> 01:17:38.839
\
Stuart Bacon: How will each tip… how will each team know which bit they're doing, if it's a public map?

1270
\
01:17:39.690 --> 01:17:46.920
\
Scott Mason: So if it's 4 layers, I would only give them the public URL to the layer… to the quarter that they're concerned about.

1271
\
01:17:48.350 --> 01:17:52.400
\
Scott Mason: So if they're the northeast corner of the town, I would only give them the URL to that.

1272
\
01:17:52.600 --> 01:17:53.450
\
Scott Mason: layer.

1273
\
01:17:53.710 --> 01:17:58.920
\
Stuart Bacon: Okay, so I'm just trying to make sure that we ask the question in the right way, because effectively.

1274
\
01:17:59.160 --> 01:18:08.040
\
Stuart Bacon: what I'm trying to… backwardly, sort of, get at, I suppose, is are you after a total of 4…

1275
\
01:18:08.680 --> 01:18:13.060
\
Stuart Bacon: 3… or 12… Layers.

1276
\
01:18:13.580 --> 01:18:14.180
\
Graham Stoddart-Stones: Yep.

1277
\
01:18:17.270 --> 01:18:28.819
\
Stuart Bacon: Is it 3 layers because you want one for each team? Is it 4 layers because you want a layer for each quadrant? Or do you want a layer for each quadrant based on each team?

1278
\
01:18:28.820 --> 01:18:36.890
\
Scott Mason: So we're gonna do away with the teams as they stand now. There will no longer be a Team 1, Team 2, an Urban Team, because they'll be operating in quadrants instead.

1279
\
01:18:37.420 --> 01:18:38.380
\
Scott Mason: So…

1280
\
01:18:38.720 --> 01:18:47.650
\
Scott Mason: the team that formerly were whichever will now need access to, say, all of the data within the northeast corner of the town, and then they know that all of the grass in this area is for them to cut.

1281
\
01:18:49.680 --> 01:18:54.190
\
Graham Stoddart-Stones: Right, so we don't even need to… Perhaps we've done a spreadsheet.

1282
\
01:18:54.190 --> 01:18:55.070
\
Stuart Bacon: Rome.

1283
\
01:18:56.400 --> 01:18:56.735
\
Scott Mason: curtain.

1284
\
01:18:57.470 --> 01:19:03.120
\
Graham Stoddart-Stones: No, it's… we don't need the team names any longer, because all he wants is the data in the quadrant.

1285
\
01:19:03.120 --> 01:19:09.210
\
Scott Mason: I want the… Polygons, basically, under a layer per quarter.

1286
\
01:19:09.520 --> 01:19:18.510
\
Stuart Bacon: Yeah, yeah, yeah, no, I understand, I understand that, but I think the easy way, when we upload it for a spreadsheet for Parish Online to deal with.

1287
\
01:19:19.710 --> 01:19:24.849
\
Stuart Bacon: is we need another tab. If we go back to the spreadsheet, and I'll show you what I think I'm…

1288
\
01:19:25.690 --> 01:19:26.680
\
Stuart Bacon: Saying.

1289
\
01:19:27.990 --> 01:19:29.550
\
Stuart Bacon: Create a new tab.

1290
\
01:19:33.110 --> 01:19:36.160
\
Stuart Bacon: And call it… Amalgamation.

1291
\
01:19:41.750 --> 01:19:46.180
\
Stuart Bacon: And now we want to…

1292
\
01:19:50.360 --> 01:19:51.890
\
Stuart Bacon: Would you mind doing that?

1293
\
01:19:54.160 --> 01:20:00.190
\
Stuart Bacon: Don't know… Actually, delete… delete amalgamation.

1294
\
01:20:04.500 --> 01:20:05.910
\
Stuart Bacon: Click on Urban.

1295
\
01:20:09.110 --> 01:20:12.029
\
Stuart Bacon: And right… right-click on… on the Urban tab.

1296
\
01:20:16.240 --> 01:20:17.280
\
Stuart Bacon: Copy.

1297
\
01:20:21.350 --> 01:20:23.850
\
Stuart Bacon: Click on move to End.

1298
\
01:20:25.660 --> 01:20:28.390
\
Stuart Bacon: And create… and click Create a Copy.

1299
\
01:20:29.890 --> 01:20:30.470
\
Scott Mason: Okay.

1300
\
01:20:30.470 --> 01:20:31.200
\
Stuart Bacon: Okay.

1301
\
01:20:32.110 --> 01:20:34.409
\
Stuart Bacon: Yep, and that'll create urban tune.

1302
\
01:20:35.540 --> 01:20:38.220
\
Stuart Bacon: That's great. Now, click in Team 1.

1303
\
01:20:42.250 --> 01:20:48.730
\
Stuart Bacon: And in U, Click somewhere in, in you.

1304
\
01:20:50.660 --> 01:20:52.369
\
Stuart Bacon: Control and down.

1305
\
01:20:55.790 --> 01:20:59.319
\
Stuart Bacon: Control, Shift, and up.

1306
\
01:21:01.880 --> 01:21:03.389
\
Stuart Bacon: Shift and down.

1307
\
01:21:06.280 --> 01:21:12.329
\
Stuart Bacon: Now… Ctrl-Shift, and go all the way across to, A.

1308
\
01:21:16.860 --> 01:21:20.190
\
Stuart Bacon: ctrl and C.

1309
\
01:21:20.910 --> 01:21:21.990
\
Stuart Bacon: to copy.

1310
\
01:21:23.120 --> 01:21:25.469
\
Stuart Bacon: Now come back to Urban 2.

1311
\
01:21:27.760 --> 01:21:29.879
\
Stuart Bacon: And…

1312
\
01:21:30.370 --> 01:21:31.800
\
Graham Stoddart-Stones: You're down to the bottom?

1313
\
01:21:31.800 --> 01:21:34.719
\
Stuart Bacon: down to the… click on A somewhere.

1314
\
01:21:36.980 --> 01:21:49.080
\
Stuart Bacon: or no, or D. D is a guaranteed one. So, clicking D, controlling down, Now go to A969.

1315
\
01:21:53.140 --> 01:21:54.260
\
Graham Stoddart-Stones: Control-C.

1316
\
01:21:54.480 --> 01:21:55.869
\
Stuart Bacon: And Ctrl-C.

1317
\
01:21:57.650 --> 01:21:59.400
\
Stuart Bacon: Sorry, couldn't… that was meant to be controlled.

1318
\
01:21:59.400 --> 01:22:01.859
\
Scott Mason: Ctrl-V, we've now lost what we copied.

1319
\
01:22:01.860 --> 01:22:06.900
\
Stuart Bacon: Don't we? So, no, if we go… if you click on… if you click on, say.

1320
\
01:22:07.530 --> 01:22:09.460
\
Graham Stoddart-Stones: Anywhere other than…

1321
\
01:22:10.500 --> 01:22:12.949
\
Stuart Bacon: Was it Team 1 or Team 2 which was copied?

1322
\
01:22:13.420 --> 01:22:14.560
\
Stuart Bacon: Yeah.

1323
\
01:22:17.840 --> 01:22:18.430
\
Scott Mason: Oh.

1324
\
01:22:18.600 --> 01:22:19.590
\
Scott Mason: Copy it again.

1325
\
01:22:20.520 --> 01:22:21.090
\
Stuart Bacon: Yeah.

1326
\
01:22:21.240 --> 01:22:22.539
\
Stuart Bacon: Copy that.

1327
\
01:22:24.000 --> 01:22:25.540
\
Scott Mason: And then paste it here.

1328
\
01:22:25.870 --> 01:22:27.860
\
Stuart Bacon: Alright, and then paste it there, yep.

1329
\
01:22:29.230 --> 01:22:33.480
\
Stuart Bacon: Now, go, control and down.

1330
\
01:22:37.440 --> 01:22:39.730
\
Stuart Bacon: And… go again.

1331
\
01:22:43.980 --> 01:22:45.060
\
Stuart Bacon: Sean again.

1332
\
01:22:46.970 --> 01:22:48.040
\
Stuart Bacon: on again.

1333
\
01:22:49.650 --> 01:22:53.640
\
Stuart Bacon: And again… controlling up.

1334
\
01:22:56.550 --> 01:22:58.659
\
Stuart Bacon: And come down a cell.

1335
\
01:22:59.220 --> 01:23:03.779
\
Stuart Bacon: 1,060. Right, now we'll do the same with Team 2.

1336
\
01:23:04.110 --> 01:23:05.929
\
Stuart Bacon: And copying everything.

1337
\
01:23:08.790 --> 01:23:09.450
\
Stuart Bacon: So…

1338
\
01:23:11.100 --> 01:23:12.570
\
Scott Mason: Not a whole lot from here.

1339
\
01:23:12.570 --> 01:23:25.400
\
Stuart Bacon: So go from clicking you, selling you… Yeah. Do… Control… Sorry.

1340
\
01:23:28.090 --> 01:23:30.790
\
Stuart Bacon: Do Shift and Left.

1341
\
01:23:33.780 --> 01:23:35.469
\
Stuart Bacon: all the way to A.

1342
\
01:23:40.300 --> 01:23:43.819
\
Stuart Bacon: And now do CTRL, Shift, and Down.

1343
\
01:23:48.160 --> 01:23:50.049
\
Stuart Bacon: And copy that.

1344
\
01:23:50.940 --> 01:23:53.510
\
Graham Stoddart-Stones: Oops, yeah, Ctrl-C. Are you still here?

1345
\
01:23:53.910 --> 01:23:54.420
\
Stuart Bacon: Yeah.

1346
\
01:23:57.180 --> 01:23:58.290
\
Graham Stoddart-Stones: Excellent.

1347
\
01:23:58.290 --> 01:24:01.230
\
Stuart Bacon: Now that's got all of your teams.

1348
\
01:24:01.830 --> 01:24:04.779
\
Stuart Bacon: And all of your quadrants, all in the one…

1349
\
01:24:05.930 --> 01:24:06.750
\
Scott Mason: One tap.

1350
\
01:24:06.750 --> 01:24:07.670
\
Graham Stoddart-Stones: worksheet.

1351
\
01:24:07.670 --> 01:24:09.730
\
Scott Mason: So should I do away with these three tabs here, then?

1352
\
01:24:09.730 --> 01:24:11.029
\
Stuart Bacon: When.

1353
\
01:24:12.140 --> 01:24:14.050
\
Scott Mason: Or call it combined, or something.

1354
\
01:24:14.050 --> 01:24:15.199
\
Graham Stoddart-Stones: I would call it combined.

1355
\
01:24:15.200 --> 01:24:15.970
\
Stuart Bacon: ones, yeah.

1356
\
01:24:15.970 --> 01:24:19.000
\
Graham Stoddart-Stones: Perhaps move it to the left, so it's the first one.

1357
\
01:24:21.700 --> 01:24:22.270
\
Scott Mason: Okay.

1358
\
01:24:23.070 --> 01:24:24.189
\
Scott Mason: Save that.

1359
\
01:24:24.610 --> 01:24:26.119
\
Graham Stoddart-Stones: So you go back to your letter…

1360
\
01:24:27.400 --> 01:24:28.370
\
Stuart Bacon: Yeah.

1361
\
01:24:29.000 --> 01:24:34.199
\
Stuart Bacon: If it's all then in that, sort of, one single spreadsheet.

1362
\
01:24:34.630 --> 01:24:37.950
\
Stuart Bacon: Whatever, it's easier for Paris Online to deal with.

1363
\
01:24:38.510 --> 01:24:41.250
\
Scott Mason: Okay, so close that and just attach it to email.

1364
\
01:24:41.720 --> 01:24:43.860
\
Stuart Bacon: Save that, yeah.

1365
\
01:24:43.860 --> 01:24:45.080
\
Scott Mason: Yeah, I have, yeah.

1366
\
01:24:45.080 --> 01:24:46.670
\
Graham Stoddart-Stones: You go to the email.

1367
\
01:24:47.760 --> 01:24:48.420
\
Stuart Bacon: Yeah.

1368
\
01:24:50.310 --> 01:24:53.470
\
Stuart Bacon: I'll go carry on, sort of, drafting this email.

1369
\
01:24:55.250 --> 01:25:02.270
\
Stuart Bacon: Please use column… Sorry, tab combined.

1370
\
01:25:03.700 --> 01:25:05.420
\
Scott Mason: So rather than take a note of column E.

1371
\
01:25:05.690 --> 01:25:18.690
\
Stuart Bacon: I was still going to use that, but we'll, so, before you get to take note of column E, after Spreadsheet, using tab combined…

1372
\
01:25:24.200 --> 01:25:26.250
\
Graham Stoddart-Stones: Yeah, I want to put that in quotes.

1373
\
01:25:26.750 --> 01:25:28.730
\
Graham Stoddart-Stones: Scott makes it very clear, then.

1374
\
01:25:31.900 --> 01:25:32.600
\
Graham Stoddart-Stones: Yeah.

1375
\
01:25:36.340 --> 01:25:41.490
\
Stuart Bacon: Take note of colony, and create four layers, based on…

1376
\
01:25:44.260 --> 01:25:50.749
\
Scott Mason: Please go to create four new layers based on the attached spreadsheet, using named tab combined, taking note of column E.

1377
\
01:25:53.060 --> 01:25:56.170
\
Graham Stoddart-Stones: for… That's right.

1378
\
01:25:57.670 --> 01:25:58.680
\
Graham Stoddart-Stones: Each quadrant.

1379
\
01:25:59.090 --> 01:26:01.849
\
Graham Stoddart-Stones: Or each quarter name, isn't it? Each quarter name?

1380
\
01:26:05.390 --> 01:26:09.029
\
Graham Stoddart-Stones: Did we call it a quadrant in the spreadsheet? I can't remember what field we called it.

1381
\
01:26:09.770 --> 01:26:12.670
\
Stuart Bacon: Yeah, it was 49, I think, wasn't it?

1382
\
01:26:12.670 --> 01:26:16.600
\
Graham Stoddart-Stones: I think that's what we call it in Paris Online. I think we call it something different in the spreadsheet.

1383
\
01:26:20.930 --> 01:26:21.840
\
Scott Mason: quarter name.

1384
\
01:26:22.650 --> 01:26:23.750
\
Graham Stoddart-Stones: Okay, good.

1385
\
01:26:26.940 --> 01:26:28.190
\
Scott Mason: So is that it?

1386
\
01:26:28.720 --> 01:26:29.839
\
Graham Stoddart-Stones: Yeah, thanks, dude.

1387
\
01:26:30.560 --> 01:26:34.370
\
Stuart Bacon: Yeah, unless you leave a signature and whatever in your email, then again.

1388
\
01:26:34.370 --> 01:26:35.750
\
Scott Mason: Goes automatically.

1389
\
01:26:36.980 --> 01:26:39.570
\
Scott Mason: I can't see it. When I send it, it appears.

1390
\
01:26:40.070 --> 01:26:40.430
\
Stuart Bacon: Okay.

1391
\
01:26:41.240 --> 01:26:41.980
\
Stuart Bacon: credited.

1392
\
01:26:42.720 --> 01:26:44.460
\
Scott Mason: Excellent. Thank you.

1393
\
01:26:44.950 --> 01:26:45.540
\
Stuart Bacon: Hours.

1394
\
01:26:46.000 --> 01:26:47.529
\
Graham Stoddart-Stones: What a wonderful way to spend an afternoon.

1395
\
01:26:48.870 --> 01:26:52.690
\
Graham Stoddart-Stones: When you signed in, Scott, my heart jumped.

1396
\
01:26:53.010 --> 01:26:57.019
\
Scott Mason: I just hope that Andrew isn't still sat there waiting with a question.

1397
\
01:26:57.020 --> 01:27:02.740
\
Andrew Clegg: I've just been amazed. Absolute tour de force. It just showed me how much I don't know about Excel.

1398
\
01:27:03.890 --> 01:27:05.169
\
Scott Mason: Yeah, me too.

1399
\
01:27:07.060 --> 01:27:11.679
\
Graham Stoddart-Stones: Thank you so much all for your help. Any more questions from anybody?

1400
\
01:27:12.090 --> 01:27:12.549
\
Scott Mason: That's enough.

1401
\
01:27:12.550 --> 01:27:17.440
\
Andrew Clegg: Not this week, Graeme. I have a couple of things for some time, but not this week.

1402
\
01:27:17.440 --> 01:27:21.669
\
Graham Stoddart-Stones: Okay, well, take care, all. Thank you very much. Good to see you tomorrow.

1403
\
01:27:21.670 --> 01:27:24.030
\
Scott Mason: Thanks for your help, yeah. Bye-bye.

1404
\
01:27:24.030 --> 01:27:24.899
\
Stuart Bacon: a little bit ridiculous.