馃攳
Excel Animation Tutorial - Building a 3D House - (3D/2D conversion) - YouTube
Channel: unknown
[0]
hello my friends and welcome back in the
[2]
previous uh tutorial
[5]
we
[6]
took our three-dimensional cube and
[9]
wrote all the formulas i mean replace
[12]
all the
[13]
cell formulas and many cells with just
[16]
two
[17]
user defined formulas
[20]
and we wrote them in vba
[23]
i'm going to open it developer visual
[25]
basic and again they need to be written
[28]
in uh
[30]
in a module okay
[33]
so you saw how i managed to do this
[36]
fairly neatly
[38]
i divided the macro into
[41]
various sections one called scale one
[44]
offset
[45]
then i converted the angles from degree
[48]
in radians
[50]
using simple formulas
[52]
these are radians of
[55]
a number
[56]
in degree
[58]
is uh doesn't exist in vba so
[62]
we have to use the word application dot
[66]
radians in this way we can
[68]
use uh in vba functions that don't exist
[72]
in vba exist only
[74]
as cell
[76]
in the worksheet worksheet functions
[78]
rather than user defined function what i
[80]
did in the meanwhile i'm not going to
[81]
spend much time on this one i
[84]
copied this sheet 2 into sheet 2 a
[88]
and
[89]
i
[91]
copied the
[92]
code in module 1
[94]
in module 2 and created two new
[97]
functions
[99]
which are instead of u1 before they were
[101]
called u1 let me go back to module 1.
[105]
they were called e1 and v1
[109]
now i call them in module 2
[112]
u2 and v2
[114]
and the only difference really is that
[117]
if you go to the original v1 and u u1
[121]
and v1 you see this
[123]
formulas here and
[125]
i'm trying to
[127]
save some space and some effort and i
[130]
created some
[131]
user defined function so sub
[134]
functions i mean functions user defined
[137]
functions
[138]
that will be used in the
[141]
main user defunct functions
[143]
and if you look here this this is these
[146]
are the rotation formulas and always
[149]
when you rotate something around a
[151]
certain axis
[153]
you write these two formulas for the
[155]
other two axes okay so the axis around
[158]
you which you rotate it doesn't change
[161]
the coordinate that coordinate doesn't
[162]
change when you rotate again around that
[165]
axis the chain what changes is you only
[168]
the other two coordinates so
[171]
in this case i created let me go to
[174]
module two
[175]
i created one called function so user
[178]
defined function udf
[181]
one called rotation x
[184]
for
[186]
this formula right here you see this one
[189]
and one called rotation
[192]
let me see
[194]
and while called rotation y
[197]
and the both these functions
[200]
have three arguments
[203]
two are just
[204]
x and y i mean coordinates
[207]
and so linear coordinates and one is um
[213]
an angle
[214]
it's going to be included here you can
[216]
look at it
[217]
essentially
[218]
i
[219]
change i um
[221]
replace this
[223]
formulas here with
[226]
a sub
[228]
user defined function okay which is
[230]
rotation x rotation y you can see here
[232]
in the u2 and v2 right here
[237]
now
[238]
i'm not going to talk about this but
[241]
you need to be careful
[243]
if you convert you can
[245]
convert the angle in radians inside the
[248]
sub functions
[250]
but you need to be careful because
[252]
if you do this you apply them both
[257]
one after the other and the first one
[259]
will turn the angle in radians
[262]
and the other one will also turn the
[264]
same angle
[266]
again from radian into radiance you get
[268]
some kind of a not error
[270]
you don't uh get uh you don't get
[273]
flagged with an error but
[276]
your model will not work properly this
[278]
being said
[280]
then i did
[281]
3d house prelim prelim stands for
[284]
preliminary so i cr i did this before i
[288]
created a tutorial make sure everything
[291]
is okay
[292]
so this house has
[295]
body the green one a roof a window and a
[299]
door
[300]
and it uses a parametric
[303]
system so that's very important i'm i'm
[306]
trying to render this idea to you that
[310]
oftentimes you need to use parameters
[313]
so if you have to scale it to change it
[315]
into something different in a systematic
[319]
and neat way that you don't lose track
[322]
of what you're doing you don't just type
[324]
in numbers here okay in xyz
[327]
cells here you create certain
[332]
parameters like in this case
[334]
you see house length house with so let
[338]
me open this um powerpoint so this is
[342]
our house
[344]
is the house here you can see i can
[347]
rotate it
[350]
i can
[352]
translate it
[355]
i can scale it
[362]
let me go to one
[364]
to one okay um let me see
[368]
let me remove that uh z offset
[371]
actually let's leave us the offset of
[373]
minus one it puts it better
[376]
in the center of the of the of the chart
[380]
what i did here i created a body from uh
[384]
what are these eight points but some of
[386]
them are repeated okay so the body is uh
[389]
here uh
[392]
highlighted in red
[394]
so and in order to
[396]
write this i go from point a
[399]
to b to c i follow the arrow
[403]
follow the red arrows so a b you see a b
[406]
c d a
[410]
maybe there's an error here
[412]
um i mean an omission so a b c d then go
[416]
back to a then go up to e
[419]
f
[420]
g g
[422]
h and then go back to e
[424]
so you can see it here
[427]
then i have to connect uh
[429]
three more three more pairs of points
[432]
b f you see bf
[435]
c g and d h
[437]
and that's that creates the body of the
[440]
house
[441]
and if i go to the next page i explain
[444]
here
[445]
the system of coordinates is like this
[447]
the x axis is horizontal so
[451]
what i see here is the the screen and
[454]
behind the screen is a 3d scene okay
[457]
and
[459]
the the y-axis goes in and out so it's
[462]
perpendicular on the screen
[465]
the z-axis is vertical z always is
[468]
vertical in my models because i say z is
[471]
either height or depth
[473]
so it's vertical
[475]
and
[477]
i created parameters okay i parameter
[480]
parameterize the house
[483]
and also i
[484]
use the named ranges okay so let me show
[487]
you
[488]
if you go here
[490]
you see hl means house length
[494]
house length
[495]
is
[497]
you see this guy from b to c or from a
[500]
to d this house length
[502]
the house will be centered so from the
[504]
center to a
[506]
on the x-axis is
[508]
minus house length
[511]
over 2 from the
[513]
so from this y-axis here
[516]
along the x-axis the coordinate is plus
[519]
house house length of a two so a
[523]
and also
[524]
the width of the house is here between a
[527]
and b is a width
[528]
and the height of the house is between c
[531]
and g or between b and f is a vertical
[534]
part so if you look at point a
[537]
point a is
[539]
from from the point of view of x
[541]
coordinate is what minus house length
[543]
over two
[544]
okay
[545]
what is the y coordinate this house
[548]
house width over 2 with plus
[551]
then if you go to point b
[554]
the the x coordinate is the same okay
[556]
because the x coordinate is a horizontal
[558]
is minus house length over 2
[561]
but
[562]
the y coordinate is minus house width
[565]
over 2 instead of plus
[568]
and you can verify all these things how
[570]
they are
[571]
okay
[572]
and then i show you
[574]
the roof is here
[576]
and i created a roof out of two lines
[580]
two let's say
[582]
geometrical paths
[584]
so one is a b c
[587]
d
[588]
a back and then e
[590]
f
[591]
d
[592]
so this is it okay
[595]
and then um
[601]
the other path is the b e f c
[606]
and again here i i
[608]
use the notation
[610]
r l roof length
[612]
rw roof with
[615]
rh roof height and rr roof reach
[620]
and if you go back here again
[623]
hl house length
[625]
hw house width
[627]
hh house height
[630]
okay
[631]
and you can verify for yourself that uh
[634]
these are the coordinates
[637]
and uh for the width for the i'm sorry
[640]
for the uh
[641]
window and the door
[643]
i use the
[644]
door width d w
[647]
door height do
[648]
d h
[650]
window with
[652]
w w
[654]
and window height
[655]
wh
[657]
there are also three more coordinates
[659]
the
[660]
x coordinates for the window so w c x so
[663]
window coordinate x
[666]
d c x door coordinate x and also w c y
[671]
window coordinate
[673]
y okay this is a
[674]
an error here it's not y is z
[678]
z
[683]
okay because
[684]
y goes in and out from these planes
[686]
perpendicular on the plane
[688]
so
[689]
the width of the house
[691]
or the width of the roof is parallel to
[693]
the
[694]
y-axis
[696]
so in order to create this i'm going to
[698]
copy
[699]
go here and just copy this
[702]
move or copy so this is a cube the
[705]
original cube with the
[707]
user defined functions
[709]
and move it to the end let's call this
[713]
3d
[715]
house
[717]
just 3d house without a prelim okay and
[721]
you can see the
[723]
you can
[724]
[Music]
[727]
everything works okay trust me
[730]
i mean i don't want to spend more time
[732]
but
[733]
from here let's uh call this body
[738]
body okay
[739]
and i'm gonna copy go here
[741]
so so we can save some time okay just
[744]
copy this these are the parameters okay
[747]
so ctrl c this is e cell e i mean column
[751]
e
[752]
so we go
[754]
to the next
[756]
and here ctrl v
[761]
and in column
[763]
let me see in column
[766]
h
[768]
ctrl c
[770]
and come here in
[773]
is it column h let me see let me see let
[775]
me see
[777]
yeah
[778]
maybe i should use uh g i think it's
[782]
better
[783]
save some space
[785]
so go
[788]
go here
[793]
and let's uh
[796]
let me see
[800]
house length okay
[802]
you guys can do a little bit of reading
[805]
about um
[807]
named ranges
[809]
so a range this is a range okay this is
[812]
a range
[813]
a cell is a range we can go here and say
[816]
house length
[817]
h l i'm sorry no not there you go you
[821]
highlight the cell or the range and name
[824]
it so here
[825]
h l
[827]
hit return
[829]
so
[829]
oops
[831]
well um
[832]
[Music]
[835]
you know what because we already have
[837]
these names
[839]
unfortunately i'm gonna have to
[842]
delete the
[844]
worksheet
[846]
so let me see let me
[849]
copy this chart i like the colors okay
[852]
so in order to maintain to save some
[855]
time i'm going to delete this
[859]
and paste the chart here
[862]
and then i'm going to just
[865]
completely delete this
[869]
you want to continue
[871]
um
[877]
okay so we delete it
[880]
so now i think i can use house length hl
[885]
okay you see
[887]
so now i highlighted this cell i go here
[891]
and i type hl it means house length it
[894]
name the range so i can use these names
[897]
here in the cells rather than
[899]
let me delete this
[901]
okay so
[903]
so you can read a little bit what are
[905]
named ranges
[906]
house with hw okay
[910]
not there right here
[917]
so
[918]
house
[920]
weed okay
[922]
what else
[923]
so house length house length house width
[928]
house height
[929]
hh okay
[931]
now window
[933]
uh let's call this not window length
[936]
that's what i called it in the previous
[938]
model window height
[943]
height
[944]
window width is okay
[947]
window coordinate
[950]
x let me see
[955]
yeah it's okay in the corners yx window
[958]
then door width or height door
[960]
coordinate x
[963]
uh roof overhang
[966]
i use roof overhang let's call this roof
[970]
with
[973]
see i uh
[975]
we had a fire we lost our house so
[979]
i did uh
[980]
i use some software and i design my own
[983]
house
[984]
so
[985]
this is something important is roof
[987]
overhang so that's why i use it but it's
[989]
better for you to not to get entangled
[992]
with those notions
[994]
so um let me see
[997]
so roof with a roof height roof ridge
[999]
okay
[1001]
so these are named already let's name
[1003]
this uh wh
[1007]
not there i'm sorry i always forget
[1009]
so double right here
[1012]
wh
[1013]
okay
[1014]
hit return then what is this ww
[1018]
window width
[1022]
what is this
[1024]
wcx
[1029]
okay
[1033]
and
[1033]
w
[1035]
not there
[1039]
w c
[1041]
z
[1044]
okay door with
[1046]
dw not there again
[1049]
what am i doing uh dw
[1054]
so i'm naming these ranges
[1057]
this is nicer in the formulas this is
[1060]
just
[1060]
a neater way to go i usually don't do it
[1062]
when i do it for myself but
[1065]
i'm teaching you this because it's
[1066]
better it's a better practice so w d
[1069]
double d w
[1072]
d
[1073]
h
[1075]
door height
[1078]
what else dcx
[1083]
okay
[1085]
okay rw here roof width
[1090]
not there
[1095]
okay roof with
[1097]
roof height
[1099]
r
[1100]
h
[1103]
a roof rage okay
[1106]
rr
[1109]
so we have it all
[1111]
now point a
[1113]
if we look here at the house here
[1116]
point a
[1118]
now wait where is this
[1120]
here you can always compare with this
[1122]
image you know
[1125]
print screen
[1127]
stop the the video print screen and use
[1130]
this image as a reference but
[1133]
i like to go straight on the worksheet
[1136]
and not look there to get a better
[1138]
practice you know so what's the
[1141]
what are the coordinates of the
[1144]
of the point a and i can also
[1147]
i can go
[1148]
here and
[1152]
save the screen
[1154]
go here and
[1155]
paste it
[1157]
paste okay
[1160]
and
[1160]
[Music]
[1162]
i can crop it
[1165]
so cut i'm trying to save some memory so
[1167]
i cut it and then i
[1169]
a special
[1173]
picture
[1174]
it's much lighter in terms of
[1180]
size okay bytes
[1183]
so we go a a
[1185]
let's look at these points which one has
[1190]
which one have negative
[1195]
x coordinates so the x coordinate
[1198]
runs horizontally so
[1199]
a b
[1201]
e f so how much they have they have
[1204]
minus house length
[1207]
so is equal to
[1209]
minus
[1211]
house length over two
[1213]
okay
[1215]
so
[1219]
another thing i want to take from the
[1222]
yeah let's put house length uh
[1227]
four
[1228]
yeah
[1229]
four
[1231]
so a b
[1234]
ctrl c
[1236]
through b
[1239]
e f
[1240]
okay so e control b
[1243]
control b they have the same x
[1246]
coordinate
[1249]
how about c it has the same thing but
[1251]
it's positive so
[1254]
let's go put ctrl v and remove this
[1257]
minus here
[1259]
and then ctrl c
[1263]
through v
[1265]
so c d g h
[1271]
v
[1272]
okay
[1273]
let's copy this see
[1279]
because a the same let me see e
[1283]
e
[1284]
ctrl c and ctrl
[1287]
v
[1289]
now
[1291]
z
[1293]
z
[1294]
um
[1298]
a b c d have a z of zero so coordinate z
[1303]
runs vertical so
[1305]
0
[1307]
0
[1308]
0
[1309]
0 0
[1311]
and then here
[1313]
the rest are
[1315]
h house height so this is equal to hh
[1321]
hit return
[1322]
let's put house height
[1325]
two okay
[1326]
no i'm sorry uh house height yeah let's
[1328]
leave the width the two
[1330]
house height is 2 that's fine
[1333]
so ctrl c
[1337]
throw v here okay
[1340]
and
[1343]
y
[1344]
let's look at y a e h d a e h d has a y
[1349]
of
[1351]
house width
[1352]
over two with plus
[1355]
so this is equal to
[1358]
house with
[1360]
over two
[1363]
okay
[1365]
and uh
[1367]
control c
[1369]
a b c d a okay
[1372]
no a a i'm sorry
[1376]
a d
[1387]
a d
[1388]
[Music]
[1389]
h e
[1394]
a again
[1397]
and um
[1399]
b c g f have
[1404]
the same thing but with
[1406]
minus
[1408]
okay
[1409]
so don't forget you see the the system
[1411]
of coordinates
[1413]
so x is runs horizontally z vertically y
[1417]
is perpendicular on the screen or on the
[1420]
on the screen plane yes
[1422]
so
[1424]
bc
[1425]
bcgf
[1427]
so ctrl c through
[1431]
v
[1433]
um
[1436]
yeah i need to look again so let me see
[1439]
so a
[1441]
e
[1442]
hd a
[1447]
e
[1448]
plus
[1451]
h
[1454]
and d
[1455]
plus uh
[1456]
plus how about e here is yes and the
[1461]
rest um
[1463]
through c
[1466]
ctrl v
[1468]
select data let's
[1471]
remove them all add
[1473]
a series called
[1476]
body
[1480]
house body
[1484]
and pick up the x from here
[1487]
and
[1489]
the y
[1491]
from here
[1495]
so what did we get oh
[1498]
we forgot um is correct that's correct
[1502]
we just
[1505]
the house is kind of small so let's get
[1507]
closer to
[1509]
let's get further from the screen so
[1511]
then it looks bigger why because when we
[1514]
get further from the screen
[1517]
we
[1518]
can see a smaller area so we can see a
[1521]
smaller area of the image
[1523]
and in real life when you get further
[1524]
from the screen the screen becomes
[1526]
smaller but when you look at this chart
[1528]
the chart doesn't become smaller if you
[1529]
become go farther so distance from i to
[1533]
screen let's make it nine
[1535]
okay let's make it 12 okay
[1539]
uh and house length
[1548]
do we need this we can leave it there
[1550]
it's okay
[1552]
so house length
[1554]
format axes
[1558]
let's go from minus 3
[1561]
to 3
[1564]
let's go here from
[1566]
what
[1568]
minus one
[1573]
two
[1574]
three
[1577]
that's good
[1580]
so let's now
[1582]
make it green
[1584]
a nice
[1586]
fruity green
[1590]
three units thick
[1592]
actually
[1595]
yeah three minutes is probably okay
[1602]
let's add bf okay so this b
[1606]
ctrl c
[1608]
ctrl v
[1611]
how about
[1614]
f
[1616]
c
[1618]
actually let's do this ctrl c
[1620]
ctrl b
[1623]
and
[1623]
[Music]
[1625]
extend the range
[1628]
right here for the body
[1631]
okay
[1638]
let me see that's something funny here
[1641]
so b
[1643]
yeah yeah yeah
[1646]
so this is zero
[1648]
so b
[1656]
okay control c control v
[1660]
f
[1665]
okay good
[1666]
so c
[1668]
ctrl c
[1670]
let me see
[1672]
control v
[1675]
g
[1679]
okay so we have that now d
[1683]
right here ctrl c
[1686]
to be
[1687]
f no h i'm sorry
[1690]
c
[1692]
ctrl b okay
[1694]
good so now
[1697]
let's make the the roof
[1700]
so roof
[1706]
so roof
[1708]
let's name this x actually we know it's
[1711]
already x y z
[1713]
so for the roof
[1716]
i'm gonna go um
[1719]
let me see right here
[1731]
actually i'm gonna remember abcd
[1734]
okay so
[1737]
let's see
[1741]
a
[1742]
b
[1743]
c
[1745]
d
[1746]
and then a
[1747]
and then we go up the roof right here
[1751]
to point uh
[1754]
e f and then d e f d
[1758]
e
[1760]
f
[1761]
d okay
[1763]
and we have another one another path we
[1767]
need to follow we need to build it
[1770]
is called
[1772]
b e
[1773]
f c b e f c
[1776]
so you see b e f c
[1780]
d
[1782]
e
[1783]
f
[1784]
c
[1784]
so a what is a
[1787]
actually we can copy this okay right
[1789]
here
[1791]
this ctrl c
[1795]
because it's the same we describe the
[1797]
same
[1798]
rectangle
[1800]
except instead of
[1801]
h l we use
[1803]
roof rl
[1805]
so
[1806]
rl2 okay roof length
[1810]
let me see
[1811]
roof
[1813]
roof with rover
[1820]
actually we call it with okay
[1826]
let me see
[1827]
with range
[1840]
and
[1842]
roof
[1845]
lane
[1846]
length okay
[1849]
roof length so
[1851]
we we rename this range
[1854]
r
[1854]
l
[1856]
so roof length
[1859]
and let's make it uh house length is for
[1862]
let's make
[1863]
this five okay
[1867]
house with is uh
[1868]
two let's make it two plus one so three
[1874]
we can actually say we can actually say
[1876]
this is equal to
[1879]
house length
[1880]
plus
[1883]
let's make it 1.2
[1886]
times
[1887]
house length
[1889]
okay
[1890]
and this is equal to
[1896]
i don't like it let's add
[1898]
uniformly an overhang all around the
[1901]
house
[1902]
so this is equal to
[1905]
house length
[1908]
plus
[1909]
one
[1911]
then here
[1914]
this is equal to house width
[1916]
plus one
[1918]
let's make the house a little bit fatter
[1921]
how sweet is too narrow okay
[1925]
so now
[1927]
roof height let's make it two
[1932]
okay
[1934]
and roof rage um
[1936]
like make it two we can change it later
[1943]
so here
[1945]
rw so we change house length so h
[1950]
anything that is h we change it into r
[1954]
a roof length
[1957]
let me see
[1960]
yeah
[1962]
roof length
[1967]
roof length
[1970]
blue flag okay
[1973]
you can always follow this you know
[1977]
since i did it quite a few times for me
[1979]
it's easy now to just
[1980]
i have it in my in the memory
[1984]
i have an image of this
[1986]
so
[1987]
okay here what else
[1989]
house
[1990]
weed
[1992]
so is a roof with a roof with
[1997]
roof
[2000]
roof
[2002]
roof
[2005]
and roof
[2007]
and
[2011]
here
[2012]
this will be
[2014]
the roof will start at the height of the
[2016]
house so
[2017]
house height here so this is
[2020]
equal to house height
[2026]
good
[2028]
and then let's copy this
[2031]
ctrl c and
[2034]
paste it here ctrl v
[2041]
now
[2044]
here we go
[2047]
b f
[2048]
b e f c b e f c
[2051]
okay so
[2056]
actually we didn't consider the
[2060]
e
[2061]
which is going to be
[2063]
the x of the
[2065]
point e will be minus
[2068]
so this is equal to minus
[2071]
roof ridge
[2073]
you see roof reach over
[2075]
2
[2079]
over 2
[2085]
the
[2086]
y is 0 because it's centered
[2089]
and the z
[2091]
is equal to
[2093]
house height
[2095]
plus
[2097]
roof height
[2101]
okay
[2102]
now f
[2104]
is the same as here except
[2108]
the x will be instead of minus rule
[2112]
reach roof reach
[2114]
over 2 plus
[2115]
roof ridge over 2 okay and d is equal to
[2119]
d which is this one
[2121]
ctrl c
[2123]
let's pick up the whole thing control c
[2125]
control b
[2128]
and
[2131]
select data
[2134]
add
[2135]
one called roof
[2137]
okay
[2139]
roof another roof
[2141]
x series we take it from here
[2145]
y series
[2146]
you need to delete that if you just
[2148]
write on top this is a bug in microsoft
[2152]
excel
[2153]
so
[2154]
this one okay
[2157]
r so let's see do we have it no we don't
[2161]
it's kind of funny
[2162]
uh we have it
[2164]
the only problem
[2167]
is
[2174]
format x is
[2176]
maximum let's make it four okay
[2179]
and
[2181]
this is a little problem let me see here
[2184]
so here is not roof width over two is
[2188]
the roof
[2190]
length over two
[2192]
okay
[2200]
okay
[2214]
i think that's okay
[2217]
let me see
[2221]
okay there's a problem here
[2224]
this
[2228]
four four zero zero here it should be
[2231]
zero
[2232]
okay yeah
[2234]
because the the the ridge is centered
[2237]
around
[2238]
over the y coordinate is zero so let's
[2242]
make the roof
[2244]
red
[2247]
and the thickness
[2250]
three okay
[2252]
that's good
[2253]
let's now add this so b
[2259]
ctrl c ctrl v
[2262]
b e
[2268]
f
[2274]
d
[2280]
and also
[2282]
copy this
[2284]
and paste it here
[2286]
and pick up the roof
[2289]
data from
[2291]
this area you see i left an empty space
[2294]
here
[2295]
and now we have the roof
[2297]
there's a little problem let me see
[2300]
b so a b
[2306]
c
[2308]
let's see
[2312]
i'm comparing this minus two
[2317]
okay b
[2320]
e f
[2323]
e f e f they look good okay
[2326]
is that is the rich here
[2328]
but then you go you go to point a b c c
[2332]
there's some problem with point c
[2335]
yeah yeah yeah okay you see this
[2338]
uh minus two control c here
[2342]
okay so now we have the roof
[2345]
let's now build uh
[2350]
the
[2351]
the door okay
[2353]
door width let's make it um
[2357]
0.7
[2360]
door height let's make it
[2364]
the house height is 2 so 1.5
[2369]
door coordinate x
[2372]
let's make it part of i mean function of
[2375]
the
[2377]
length of the house
[2379]
so the length is like this the wheel is
[2381]
like this you can
[2384]
maybe you don't like it you can change
[2385]
the names but
[2387]
i started with this because usually the
[2389]
length is the longer one and the width
[2390]
is narrower so
[2393]
so let's make it um
[2398]
this is equal to house length divided by
[2401]
four
[2403]
let's see how it goes
[2405]
so in order to build a
[2408]
door i did not show here
[2414]
but we need to let's start at this point
[2416]
right here let's not put it on the
[2418]
ground let's put it a little bit higher
[2420]
than the ground
[2421]
all the y-coordinates are
[2425]
minus house width over two
[2429]
okay for the door so
[2433]
call this door
[2438]
a
[2439]
b
[2440]
c
[2441]
d
[2442]
a
[2444]
okay
[2447]
oh man what the
[2452]
so a b c d a
[2454]
and uh
[2456]
i just uh
[2458]
label it in my mind so a is here b c b
[2462]
and back to a a b c d we go in a circle
[2465]
like this
[2468]
so a what is a a is
[2474]
the x of a is
[2483]
doorway let me see door with
[2486]
door
[2492]
with dw
[2494]
[Music]
[2496]
the h height
[2498]
d c x
[2500]
okay so is
[2502]
this is equal to
[2504]
d
[2505]
c x the coordinate
[2508]
minus
[2510]
door width over two
[2513]
okay
[2514]
then in b
[2516]
so if you start
[2519]
if you start a here
[2521]
b has the same x coordinate okay
[2526]
so let's now
[2527]
actually
[2530]
the y what is y for all of them
[2534]
y is equal to
[2536]
minus
[2538]
house with over 2
[2542]
and then copy it down
[2544]
because y is
[2547]
y is the same for all these points it
[2549]
belongs to the front face of the house
[2553]
that's why
[2554]
z
[2555]
okay z here let's make it is equal to
[2560]
0.05 very very little
[2563]
five percent of
[2565]
times
[2567]
door height
[2568]
okay
[2570]
b is a door height so is equal to
[2573]
door height
[2576]
okay here we copy this
[2580]
so a and b
[2582]
will have the same x coordinate then c
[2587]
copy here but instead of minus
[2591]
put plus
[2592]
okay plus
[2595]
d the same
[2598]
and here
[2599]
minus again
[2601]
[Music]
[2603]
okay z this
[2607]
this
[2610]
then
[2615]
you can you can think about this i
[2617]
already did it so for me it's easy to
[2620]
fill this out so
[2621]
ctrl c
[2625]
ctrl v
[2627]
and
[2633]
source data what image let me see
[2637]
select data
[2639]
in the old excel is source data but uh
[2641]
okay so add one called door
[2645]
door should be brown okay
[2647]
you need to delete this okay
[2650]
the door from here
[2652]
the y the x values from here
[2658]
and here we have the door
[2660]
i would make the door a little bit
[2662]
higher okay so
[2663]
door height
[2666]
uh
[2666]
[Music]
[2668]
let's make the door height is equal to
[2670]
0.8
[2672]
times
[2673]
house height okay
[2675]
we're working a parametric way much
[2677]
better
[2678]
uh eight uh 0.85 i i think it should be
[2682]
higher
[2684]
i don't like low doors
[2691]
make it brown
[2693]
more colors standard colors
[2696]
i like that okay and
[2701]
this is the door
[2703]
let's make now the window
[2709]
copy this okay
[2711]
why because it's just another
[2714]
square or whatever
[2717]
rectangle ctrl v
[2719]
so
[2720]
a b
[2722]
c
[2723]
d
[2723]
a
[2725]
and instead of uh
[2728]
let me see instead of
[2732]
dcx the door
[2735]
coordinate let's call it window
[2738]
coordinate minus
[2741]
window width over two okay
[2750]
so the window the window
[2754]
oh we didn't put anything at the window
[2756]
so window height let's make it is equal
[2758]
to
[2762]
let's take the door height
[2768]
0.4
[2770]
door height
[2773]
window width let's
[2775]
let's make it is equal to
[2778]
0.2
[2781]
times
[2782]
house
[2784]
length
[2787]
window coordinate x let's make it minus
[2791]
equal to minus
[2794]
house
[2795]
length divided by
[2798]
four for now okay for now
[2801]
window coordinate z
[2802]
let's make it
[2805]
i have an idea let's put the top of the
[2807]
window at the top of the door okay so
[2809]
window coordinate is equal to
[2813]
um
[2814]
door height
[2816]
minus
[2818]
minus
[2821]
the
[2822]
window
[2824]
height divided by two
[2826]
so this is okay
[2829]
so now
[2833]
okay minus okay
[2842]
be
[2844]
so a
[2846]
b
[2848]
so window
[2854]
okay
[2856]
now here
[2858]
we change the d into we
[2861]
w
[2862]
so door into window okay
[2864]
but it's the same principle you have
[2867]
a b
[2868]
a b c d e
[2873]
same here window
[2877]
window
[2879]
and
[2880]
window
[2883]
and window
[2889]
now
[2890]
let me see here
[2893]
door let's change this to
[2903]
this is equal to
[2911]
window coordinate
[2913]
y
[2914]
okay
[2916]
minus
[2919]
window height divided by two
[2928]
window coordinate why do we have
[2930]
this doesn't
[2932]
doesn't seem to exist window coordinate
[2936]
no no we don't have it we have z
[2939]
okay so
[2940]
window coordinate z
[2948]
copy here
[2950]
plus
[2952]
okay
[2955]
then
[2958]
the other one is the same
[2961]
here is minus
[2964]
and
[2968]
the same plus
[2980]
okay so
[2984]
source
[2987]
select data add
[2990]
one call window
[2996]
x
[2997]
series from
[2999]
here
[3001]
and y series from
[3007]
here
[3010]
do we have it no
[3012]
so let me see
[3015]
a b c d
[3018]
now this problem with d so
[3021]
okay the z coordinate here
[3027]
okay so we have it
[3029]
let's um
[3036]
let's make this blue
[3038]
beautiful blue this light blue
[3040]
[Music]
[3041]
make it uh
[3045]
three
[3047]
okay
[3050]
and let's add
[3053]
a separator
[3055]
okay so let's call this abcd
[3059]
e f
[3061]
this is horizontal separator
[3064]
so horizontal separator the x is gonna
[3066]
be my uh
[3068]
the x is gonna be the x of a let's say
[3071]
this one
[3072]
ctrl c
[3075]
so a b c
[3078]
and the x for the f will be c
[3083]
v here
[3086]
so this is equal to
[3094]
window coordinate
[3097]
z
[3099]
window coordinate z
[3104]
let me see
[3108]
and
[3112]
the window belongs to the front of the
[3113]
house so the y is the same
[3119]
copy these
[3121]
paste them here
[3124]
click on the window and extend the range
[3127]
here
[3134]
okay so we have a horizontal separator
[3136]
let's make a vertical separator ef
[3139]
[Music]
[3140]
gh
[3142]
so g let me see
[3145]
the x of g will be is equal to
[3147]
[Music]
[3149]
the x of uh
[3151]
okay
[3152]
this is equal to
[3156]
window coordinate
[3158]
x
[3161]
same for the neg the h because this is a
[3164]
vertical separator they have the same x
[3172]
the y is the same as everything else on
[3175]
this face
[3178]
and
[3178]
z
[3180]
this is equal to
[3185]
z of
[3187]
let me see a b
[3191]
through c
[3204]
ctrl c
[3206]
ctrl v
[3208]
so because i did it oh let me see
[3212]
this it's kind of easy you need to you
[3214]
need to
[3216]
spend some time you know don't expect
[3219]
it's basic very basic but
[3223]
that's what it is since i did it quite a
[3225]
few times
[3227]
i want to waste more time but we have
[3229]
the house we have the window the door
[3232]
we can scale it
[3235]
okay
[3239]
we can
[3240]
rotate it
[3243]
vertically
[3245]
let's make it a little bit smaller
[3248]
we can
[3251]
translate it
[3256]
rotating
[3258]
rotate it
[3260]
around the y-axis
[3264]
okay
[3265]
rotate it
[3267]
a lot around the z axis
[3271]
okay
[3273]
and i will show you a few more tricks
[3276]
but for now let's
[3278]
close this let's finish up this being
[3281]
said i will see you in the next tutorial
[3284]
next tutorial we can play a little bit
[3286]
with these settings
[3287]
and also start making
[3290]
a ground plane like in the roller
[3292]
coaster because eventually this will be
[3294]
a roller coaster and uh we can also make
[3297]
some trees and also
[3300]
we can move around the house i mean fly
[3303]
around the house with a an imaginary
[3306]
aircraft this will be a very good
[3308]
exercise for the roller coaster so this
[3311]
being said the
[3313]
link for the file will be in the
[3314]
description and i will see you in the
[3317]
next tutorial thanks for watching
Most Recent Videos:
You can go back to the homepage right here: Homepage