656 lines
12 KiB
Text
656 lines
12 KiB
Text
1
|
|
00:00:00,000 --> 00:00:08,120
|
|
So let's create a room finish schedule and we will populate our spaces with certain properties
|
|
|
|
2
|
|
00:00:08,120 --> 00:00:10,120
|
|
So then we can use that
|
|
|
|
3
|
|
00:00:10,240 --> 00:00:15,740
|
|
To create a room schedule. So first I'm going to select that space
|
|
|
|
4
|
|
00:00:17,360 --> 00:00:19,360
|
|
And let's start adding some
|
|
|
|
5
|
|
00:00:19,720 --> 00:00:22,800
|
|
P-sets here. Let's start with space occupancy
|
|
|
|
6
|
|
00:00:23,520 --> 00:00:25,120
|
|
requirements
|
|
|
|
7
|
|
00:00:25,120 --> 00:00:26,880
|
|
add that
|
|
|
|
8
|
|
00:00:26,880 --> 00:00:28,880
|
|
and I'm just gonna say
|
|
|
|
9
|
|
00:00:29,560 --> 00:00:34,160
|
|
For occupancy type I'm gonna say habitable and say okay
|
|
|
|
10
|
|
00:00:37,280 --> 00:00:43,120
|
|
And then let's add space covering requirements
|
|
|
|
11
|
|
00:00:45,680 --> 00:00:51,480
|
|
Add that and for our floor let's do
|
|
|
|
12
|
|
00:00:53,599 --> 00:00:55,599
|
|
Carpet one
|
|
|
|
13
|
|
00:00:55,600 --> 00:00:57,960
|
|
For our walls
|
|
|
|
14
|
|
00:00:59,840 --> 00:01:05,040
|
|
We'll do this so let me drag it out here or so
|
|
|
|
15
|
|
00:01:08,300 --> 00:01:12,280
|
|
Adding that verbiage there and for the ceiling
|
|
|
|
16
|
|
00:01:15,280 --> 00:01:20,920
|
|
Just gonna say see reflected ceiling plan there and then for the wall base
|
|
|
|
17
|
|
00:01:20,920 --> 00:01:26,080
|
|
Or the skirting board rather I'm going to use that
|
|
|
|
18
|
|
00:01:27,480 --> 00:01:32,560
|
|
So I'm gonna go through the rest of these spaces then and add those
|
|
|
|
19
|
|
00:01:33,080 --> 00:01:35,560
|
|
parameters to the rest of them
|
|
|
|
20
|
|
00:01:36,240 --> 00:01:41,440
|
|
so now that we went through all the spaces and added these property sets and
|
|
|
|
21
|
|
00:01:42,640 --> 00:01:44,560
|
|
property values here
|
|
|
|
22
|
|
00:01:44,560 --> 00:01:48,200
|
|
We can then create a simple room finish schedule
|
|
|
|
23
|
|
00:01:49,200 --> 00:01:51,200
|
|
So that is done
|
|
|
|
24
|
|
00:01:51,480 --> 00:01:57,400
|
|
At this tab here the quality and coordination tab and then the spreadsheet import export down here
|
|
|
|
25
|
|
00:01:57,840 --> 00:02:03,240
|
|
and you want to load from memory, so it's loading that IFC that's in bonsai right now and
|
|
|
|
26
|
|
00:02:04,200 --> 00:02:08,080
|
|
We're going to add a search group and yes, we want
|
|
|
|
27
|
|
00:02:08,759 --> 00:02:11,800
|
|
the filter to be class and we're filtering for
|
|
|
|
28
|
|
00:02:12,960 --> 00:02:14,960
|
|
IFC space
|
|
|
|
29
|
|
00:02:15,160 --> 00:02:16,760
|
|
pulling out
|
|
|
|
30
|
|
00:02:16,760 --> 00:02:18,760
|
|
All the information
|
|
|
|
31
|
|
00:02:20,280 --> 00:02:26,440
|
|
From those IFC spaces, so if we just open this web UI click on that
|
|
|
|
32
|
|
00:02:31,519 --> 00:02:33,519
|
|
It opens this browser-based
|
|
|
|
33
|
|
00:02:34,799 --> 00:02:42,760
|
|
Table essentially for the spreadsheet so right now our room finish schedule is not very elaborate it only has the
|
|
|
|
34
|
|
00:02:43,560 --> 00:02:46,519
|
|
Global ID of all the spaces so far
|
|
|
|
35
|
|
00:02:47,720 --> 00:02:50,079
|
|
So let's start adding to that
|
|
|
|
36
|
|
00:02:51,239 --> 00:02:53,239
|
|
we're going to add a
|
|
|
|
37
|
|
00:02:54,320 --> 00:02:58,799
|
|
CSV attribute sometimes their attributes and sometimes their properties
|
|
|
|
38
|
|
00:02:59,920 --> 00:03:02,760
|
|
In this case it's an attribute. We're gonna do
|
|
|
|
39
|
|
00:03:03,560 --> 00:03:05,359
|
|
Just name
|
|
|
|
40
|
|
00:03:05,359 --> 00:03:08,840
|
|
If you remember our name is actually the number of our spaces
|
|
|
|
41
|
|
00:03:08,840 --> 00:03:13,480
|
|
So I'm gonna type in number in the second field is
|
|
|
|
42
|
|
00:03:14,280 --> 00:03:16,280
|
|
Basically what you name the column
|
|
|
|
43
|
|
00:03:16,880 --> 00:03:20,560
|
|
of that data, so we're gonna open the web UI again and
|
|
|
|
44
|
|
00:03:21,720 --> 00:03:29,460
|
|
Here you can see your spreadsheet is starting to come together so on top of the header there. It says number
|
|
|
|
45
|
|
00:03:30,120 --> 00:03:32,480
|
|
Then we have our numbers all in a row
|
|
|
|
46
|
|
00:03:36,040 --> 00:03:38,840
|
|
We can add some more stuff how about
|
|
|
|
47
|
|
00:03:42,080 --> 00:03:44,080
|
|
Long name
|
|
|
|
48
|
|
00:03:44,560 --> 00:03:46,560
|
|
Just call it name
|
|
|
|
49
|
|
00:03:47,960 --> 00:03:49,960
|
|
Let's we can
|
|
|
|
50
|
|
00:03:51,520 --> 00:03:53,520
|
|
Add the
|
|
|
|
51
|
|
00:03:53,560 --> 00:03:55,560
|
|
level that each
|
|
|
|
52
|
|
00:03:55,880 --> 00:03:57,680
|
|
spaces in
|
|
|
|
53
|
|
00:03:57,680 --> 00:03:59,200
|
|
by
|
|
|
|
54
|
|
00:03:59,200 --> 00:04:00,400
|
|
using
|
|
|
|
55
|
|
00:04:00,400 --> 00:04:02,400
|
|
the parent and
|
|
|
|
56
|
|
00:04:02,600 --> 00:04:04,520
|
|
then dot name
|
|
|
|
57
|
|
00:04:04,520 --> 00:04:08,400
|
|
Again when you want to find out where some of these values come from
|
|
|
|
58
|
|
00:04:08,400 --> 00:04:09,920
|
|
You
|
|
|
|
59
|
|
00:04:09,920 --> 00:04:15,280
|
|
go back to this selector syntax that I've brought up a number of times and
|
|
|
|
60
|
|
00:04:16,240 --> 00:04:20,720
|
|
You can see if we use the parent key there
|
|
|
|
61
|
|
00:04:21,240 --> 00:04:24,200
|
|
that it gets the parent element in the spatial hierarchy and
|
|
|
|
62
|
|
00:04:24,840 --> 00:04:27,700
|
|
so you follow that then by a
|
|
|
|
63
|
|
00:04:28,220 --> 00:04:31,160
|
|
Dot and it gets the name of that spatial hierarchy
|
|
|
|
64
|
|
00:04:32,000 --> 00:04:33,800
|
|
So we'll just say
|
|
|
|
65
|
|
00:04:33,800 --> 00:04:35,800
|
|
level then
|
|
|
|
66
|
|
00:04:35,800 --> 00:04:37,800
|
|
I
|
|
|
|
67
|
|
00:04:37,960 --> 00:04:42,680
|
|
What else we're gonna add how about we add some properties now
|
|
|
|
68
|
|
00:04:44,560 --> 00:04:47,220
|
|
Click on that and we are going to
|
|
|
|
69
|
|
00:04:48,280 --> 00:04:52,680
|
|
Add that occupancy type property that we added to the space
|
|
|
|
70
|
|
00:04:52,800 --> 00:04:56,720
|
|
so that's the property set and then dot this is the property and
|
|
|
|
71
|
|
00:04:57,760 --> 00:05:00,400
|
|
We're just going to name that column
|
|
|
|
72
|
|
00:05:02,020 --> 00:05:04,020
|
|
Occupancy type
|
|
|
|
73
|
|
00:05:05,800 --> 00:05:12,400
|
|
Let's actually just run it to see delete this run it to see what we got so far
|
|
|
|
74
|
|
00:05:15,880 --> 00:05:17,880
|
|
So, yep looks like it's coming together
|
|
|
|
75
|
|
00:05:21,520 --> 00:05:25,300
|
|
Let's add in the area of the space
|
|
|
|
76
|
|
00:05:31,440 --> 00:05:33,440
|
|
Area
|
|
|
|
77
|
|
00:05:33,680 --> 00:05:34,920
|
|
And
|
|
|
|
78
|
|
00:05:34,920 --> 00:05:36,920
|
|
Run it again
|
|
|
|
79
|
|
00:05:37,120 --> 00:05:43,040
|
|
Here it's added. You can tell that it's not rounded to the whole number so we can change that
|
|
|
|
80
|
|
00:05:46,040 --> 00:05:51,880
|
|
Again if you go back to your selector syntax and search for rounds
|
|
|
|
81
|
|
00:05:55,040 --> 00:06:00,280
|
|
Round you can kind of see the logic which you can use
|
|
|
|
82
|
|
00:06:03,480 --> 00:06:06,520
|
|
So I'm just going to basically copy and paste
|
|
|
|
83
|
|
00:06:07,240 --> 00:06:11,400
|
|
The logic that we need and you have to turn on this
|
|
|
|
84
|
|
00:06:12,160 --> 00:06:15,760
|
|
or click this icon to turn on where to enter the
|
|
|
|
85
|
|
00:06:17,320 --> 00:06:19,920
|
|
The values there to round the number
|
|
|
|
86
|
|
00:06:24,760 --> 00:06:26,760
|
|
And that's what we're going to use there
|
|
|
|
87
|
|
00:06:28,960 --> 00:06:33,080
|
|
Let us add in the floor covering and the wall covering
|
|
|
|
88
|
|
00:06:33,600 --> 00:06:35,600
|
|
parameters
|
|
|
|
89
|
|
00:06:39,360 --> 00:06:41,360
|
|
Open this up further
|
|
|
|
90
|
|
00:06:50,920 --> 00:06:56,240
|
|
Flooring wall coverings
|
|
|
|
91
|
|
00:07:03,440 --> 00:07:05,440
|
|
Ceiling
|
|
|
|
92
|
|
00:07:13,480 --> 00:07:15,480
|
|
And then
|
|
|
|
93
|
|
00:07:17,520 --> 00:07:23,880
|
|
Baseboard I just say base I guess let's do wall this one
|
|
|
|
94
|
|
00:07:26,320 --> 00:07:28,800
|
|
And we'll run it again see what it looks like
|
|
|
|
95
|
|
00:07:28,800 --> 00:07:30,800
|
|
All
|
|
|
|
96
|
|
00:07:31,840 --> 00:07:39,280
|
|
Right starting to look like something so you can drag these open to get wider columns if you'd like
|
|
|
|
97
|
|
00:07:42,440 --> 00:07:48,400
|
|
You're also in this view you can kind of sort quickly on certain things
|
|
|
|
98
|
|
00:07:49,960 --> 00:07:51,960
|
|
Or you can filter
|
|
|
|
99
|
|
00:07:52,960 --> 00:07:58,960
|
|
It's a first floor so just filters the first floor spaces
|
|
|
|
100
|
|
00:08:02,120 --> 00:08:06,280
|
|
You can also make how this table is sorted a more permanent
|
|
|
|
101
|
|
00:08:07,680 --> 00:08:09,679
|
|
fixture
|
|
|
|
102
|
|
00:08:09,960 --> 00:08:13,200
|
|
And if you turn on the show sorting
|
|
|
|
103
|
|
00:08:14,560 --> 00:08:16,560
|
|
Element there
|
|
|
|
104
|
|
00:08:16,880 --> 00:08:18,880
|
|
You can say
|
|
|
|
105
|
|
00:08:19,600 --> 00:08:22,280
|
|
You can tell it how to sort from here
|
|
|
|
106
|
|
00:08:22,960 --> 00:08:26,280
|
|
So we can actually start with the highest number and go down
|
|
|
|
107
|
|
00:08:27,280 --> 00:08:29,280
|
|
See what it looks like
|
|
|
|
108
|
|
00:08:34,960 --> 00:08:38,640
|
|
Or we want to go the other direction ascending
|
|
|
|
109
|
|
00:08:42,760 --> 00:08:44,760
|
|
There descends
|
|
|
|
110
|
|
00:08:45,200 --> 00:08:48,240
|
|
So let's say we want to sort by
|
|
|
|
111
|
|
00:08:48,920 --> 00:08:51,439
|
|
The accuracy type and then the number
|
|
|
|
112
|
|
00:08:53,480 --> 00:08:59,060
|
|
The order of these values is that important so if we want to
|
|
|
|
113
|
|
00:09:01,640 --> 00:09:04,600
|
|
Sort by the accuracy type we have to move it up
|
|
|
|
114
|
|
00:09:04,600 --> 00:09:06,600
|
|
And
|
|
|
|
115
|
|
00:09:17,880 --> 00:09:19,880
|
|
We want to
|
|
|
|
116
|
|
00:09:20,200 --> 00:09:25,320
|
|
Sort by sending and then after that sort by the name or the number of the
|
|
|
|
117
|
|
00:09:26,880 --> 00:09:28,880
|
|
Space
|
|
|
|
118
|
|
00:09:29,240 --> 00:09:35,760
|
|
So here you can see it's organized by whether it's habitable or non habitable and then after that then it starts ordering
|
|
|
|
119
|
|
00:09:37,640 --> 00:09:39,640
|
|
By the number
|
|
|
|
120
|
|
00:09:40,560 --> 00:09:46,560
|
|
So instead of exporting it to that web-based viewer you can actually export out a
|
|
|
|
121
|
|
00:09:49,640 --> 00:09:55,120
|
|
Excel or a CSV file or a open document file
|
|
|
|
122
|
|
00:09:56,120 --> 00:10:03,200
|
|
You change that here and say we want to export an ODS file instead
|
|
|
|
123
|
|
00:10:04,920 --> 00:10:06,920
|
|
Say export
|
|
|
|
124
|
|
00:10:07,920 --> 00:10:11,480
|
|
And navigate to where we want it
|
|
|
|
125
|
|
00:10:19,640 --> 00:10:22,640
|
|
Let's add a folder and say schedules
|
|
|
|
126
|
|
00:10:25,120 --> 00:10:27,120
|
|
And
|
|
|
|
127
|
|
00:10:31,200 --> 00:10:33,200
|
|
Let's say room finish
|
|
|
|
128
|
|
00:10:35,240 --> 00:10:41,600
|
|
Schedule okay, then we're gonna navigate to that
|
|
|
|
129
|
|
00:10:43,360 --> 00:10:45,360
|
|
To open it
|
|
|
|
130
|
|
00:10:55,120 --> 00:10:57,120
|
|
So
|
|
|
|
131
|
|
00:11:09,040 --> 00:11:11,880
|
|
Here it is in LibreCalc as well
|
|
|
|
132
|
|
00:11:14,280 --> 00:11:16,280
|
|
So there's other
|
|
|
|
133
|
|
00:11:16,800 --> 00:11:18,960
|
|
Aspects you can add to this you can
|
|
|
|
134
|
|
00:11:20,800 --> 00:11:22,800
|
|
You click on that component
|
|
|
|
135
|
|
00:11:25,120 --> 00:11:27,120
|
|
You can sum the values
|
|
|
|
136
|
|
00:11:27,520 --> 00:11:29,520
|
|
Oh, I don't want to sum that
|
|
|
|
137
|
|
00:11:30,440 --> 00:11:33,440
|
|
We want to sum of the the name or the number
|
|
|
|
138
|
|
00:11:34,600 --> 00:11:36,600
|
|
See what happens
|
|
|
|
139
|
|
00:11:39,640 --> 00:11:42,680
|
|
Let's replace that again set again
|
|
|
|
140
|
|
00:11:47,800 --> 00:11:51,000
|
|
And see if we just open it recent see what changes
|
|
|
|
141
|
|
00:11:55,120 --> 00:11:57,120
|
|
You
|
|
|
|
142
|
|
00:12:02,880 --> 00:12:06,480
|
|
Yep there and added the sum of all those numbers
|
|
|
|
143
|
|
00:12:09,040 --> 00:12:13,120
|
|
The other great features you can actually change the value here
|
|
|
|
144
|
|
00:12:13,640 --> 00:12:15,640
|
|
so we can change the
|
|
|
|
145
|
|
00:12:15,680 --> 00:12:19,280
|
|
Flooring in the primary bedroom to something was to say testing
|
|
|
|
146
|
|
00:12:20,040 --> 00:12:25,920
|
|
Save it and then you can import that then back into the model if you go import type C
|
|
|
|
147
|
|
00:12:27,079 --> 00:12:29,079
|
|
navigate to the file
|
|
|
|
148
|
|
00:12:30,000 --> 00:12:34,900
|
|
Import and then if you select that space
|
|
|
|
149
|
|
00:12:37,199 --> 00:12:39,199
|
|
Go back to properties
|
|
|
|
150
|
|
00:12:39,360 --> 00:12:43,339
|
|
You can see that it's updated there with testing is the value
|
|
|
|
151
|
|
00:12:43,800 --> 00:12:47,920
|
|
So very powerful if you got a lot of data that you need to wrangle
|
|
|
|
152
|
|
00:12:49,280 --> 00:12:51,680
|
|
After spending so much time creating this schedule
|
|
|
|
153
|
|
00:12:52,400 --> 00:12:54,400
|
|
Let's make sure we save it
|
|
|
|
154
|
|
00:12:55,420 --> 00:12:57,040
|
|
externally in our
|
|
|
|
155
|
|
00:12:57,040 --> 00:13:01,220
|
|
Repo directory so we then we if we need to run this schedule again
|
|
|
|
156
|
|
00:13:01,220 --> 00:13:04,720
|
|
We can open it and so to do that you click on here
|
|
|
|
157
|
|
00:13:05,420 --> 00:13:06,640
|
|
save
|
|
|
|
158
|
|
00:13:06,640 --> 00:13:11,920
|
|
It's gonna save it as a JSON file. So navigate to where you want to be placed
|
|
|
|
159
|
|
00:13:13,000 --> 00:13:15,000
|
|
and we're gonna say
|
|
|
|
160
|
|
00:13:16,800 --> 00:13:18,800
|
|
Finish
|
|
|
|
161
|
|
00:13:19,280 --> 00:13:22,000
|
|
You will save
|
|
|
|
162
|
|
00:13:29,319 --> 00:13:32,959
|
|
So then if we want to let's actually delete all these
|
|
|
|
163
|
|
00:13:34,600 --> 00:13:39,720
|
|
Later on load that file go back to it
|
|
|
|
164
|
|
00:13:42,000 --> 00:13:46,199
|
|
And it should repopulate all the values there so you can run the schedule again
|
|
|