Transcripts
1. Overview of LOB and 3D Gantt charts: Let's learn to prepare
amazing 3D Gantt charts. My name is Amir, and I will take you
through this course. I'm an education and
technology enthusiasts. I have been working
in project management with a total experience
of 17 years. Fortunately, I got an
opportunity to work and learn on iOS projects such as
special economic zone, IT, commercial, residential,
hospitality and infra. Since last few years, I was working on how to
effectively communicate critical project information
to different stakeholders. I've worked on numerous
format and then came across this innovate
build 3D Gantt charts. 3d Gantt chart is a great way to visualize a project
schedule which provides powerful insights
about your project for analysis and better
decision-making. Promise simple
activity to preparing a stunning comprehensive
visual reports, this course provides
necessary knowledge, tools and techniques
which can be easily applied for different
types of projects, such as commercial,
high-rise, roads and bridges. Only basic Excel
operating skills are necessary as
we will learn to prepare all these reports using Excel charts and few
formatting techniques. There are no courts Macros. This course will certainly
provide you with the important upgrade to your
knowledge and experience. It will enhance your
visualization and we'll prove vital in personal as well as
professional development. Please go through the
course description. Quite excited to see you add this amazing tool to your
diverse knowledge portfolio.
2. Anatomy of 3D Gantt Chart: Before we actually start
preparing pretty Gantt chart, it is necessary to understand charts and decode
various chart elements. It will help you not
only for this course, but in case you want to use
charts for other purpose. This area, It's
spreadsheet area. These are various commands. Commands are segregated
in different groups. Every group contains commands
of similar characteristics. This area where all the commands are available is
called as a ribbon. These are different tabs which contain different
commands under each. Let's try to understand charts. First, select the cell
range, which contains dates. Go to Insert tab. There is a group
called as charts, where different
charts are available. When you take your
cursor or any element. As in our case charts, excel gives a
description of each. Here you have different
jars available. We will use scatter chart. There is a small arrow. It means there are
few more charts available under that option. Let's click on it.
Select scatter chart. You will have one
chart inserted. There are small circles
I will label at the corners and
centers of each side, which help us resize the chart. We use a chart to represent certain information of facts
which is called as data. If we want to edit the data, select the chart
and right-click. When you right-click
on the chart or any of the chart element, we get a mini toolbar and chart Min new
Vitruvian commands, which are most commonly
used with that selection. Over here we are
discussing about the data. Hence, click on Select Data. Let's select data source
dialog box will appear. Here. You will find one of the
series captured already. To make changes in that series, you need to select the
series and click on edit. To add more data or more series. You have to click on Add. Select the series,
and click on Edit. It will display an edit
series dialog box. There are three value boxes. First value box is the
name of the series. Next to value boxes are
very important for us. As discussed, we need to
take activity dates and x-axis respect to floor
height on the y-axis. This step is very important
in the entire course, you need to select
activity dates on x-axis and fluid
levels on y-axis. Let's explore a
few more options. When you select the chart. On the right-hand side, there are more
options available. On top, you'll see a plus sign, which help you add or remove
different chart elements. When you click on the plus
sign or chart elements, it presents number of
chart elements to add. Elements would
checkboxes checked are already added to
the current chart. When you move your cursor over a different chart elements, it presents preview
of this elements on the chart to help you
visualize the effect. Let's add a few elements. Add excess title
using the checkbox. Add data labels. Had legions. When you take your cursor
over any of the elements, one arrow appears on
the right-hand side. It means there are a
few more options I will label under that
particular chart element. Let's take the GSA on the grid line and
click on the arrow. If you observe we have
two checkboxes checked. One is primary vertical and
second is Primary Horizontal. Now let us discuss how to edit
Chart and chart elements. When you take your cursor over a different chart elements, excel describes the
element instantly. So it becomes easier to
select a particular element. Move your cursor over various
areas to understand them. First, chart area,
plot area, lesions. Axis. Title. First Format Chart Area. Thank your cursor
over the chart. When the Excel displays
chart area selected by left-click board to format and change the fill
off your choice. Similarly, select the plot
area, change the field. You can change the
outline as well. In the same fashion. You can format various
chart elements that are added in the chart. Let's explore another way. Select any Chart Element
and right-click so forth. I mean, we will select horizontal
axis by left clicking. And I right-click.
Click on Format Axis. On the right-hand side, you will get a task pin. We have selected format axis. All the options
that are related to the format axis will be
available on the task pen. First one is access option. Second, Size and Properties. Effects. Fourth
is Phil and line. Click on Axis option. There are more formatting
options. I will label. Just click the arrow
and you use scrollbar. Now, let's discuss two options which we will be using
very frequently. Under bounds. You
will how to value boxes one for a minimum
and other for maximum. It will define the start and
end of our project timeline. We can directly enter
data in this value boxes. Under units you how to value
boxes, which would be fine. Holder timeline is formatted. If you reach to her
daily interval, you how to enter one in measure and if you
weren't weekly interval, you how to enter seven. Just play around with
various options. Similarly, you can
add chart elements from Design tab,
chart layout groups. Click on the arrow near
Add Chart Element. There are various options
available under each one. This tutorial, it just to
give you idea of chart and various chart elements
which we will be using often throughout
this course. We will start working on it
from the mixed tutorial. Thank you very much.
3. Create 1st line of Balance: Hello. In this tutorial, we will see how to create a 3D timeline or 3D Gantt chart, which will act as
a stepping stone for our future projects. Typical Gantt chart
audit timeline has only one value access to
shoot any numerical data. It becomes very
difficult to plot data points which contains
two numerical attributes. Scatter chart always
has to value axis to show one set of
numerical data along a horizontal axis
and another set of numerical values along vertical axis and
that is y-axis. The chart displays point at the intersection of X
and Y numerical value. Further combining these values
into a single data point. We are going to create, overthink simply
using scatter charts. Now let us see how to
use scatter chart to create our first 3D timeline. Let's refer some simple data. Here we have floor wise finish
dates of structural word. Select Finish dates
and go to Insert tab. Charts group. Under Insert
Scatter or bubble chart. Select scatter with
straight lines and markers. We will see a scatter
graph created. No absorbed the chart. Here we have dates on y-axis
and floors on x-axis. As we know, Gantt chart represents the
information against time. We need dates on x-axis
and floors on y-axis. Right-click on the chart area. We will get context menus. Click on Select Data. Select beta source
dialog box will appear. On top. We have data
range for the chart. Left-hand side, we have series. Now remember this is the area where we will put
our activities. On the right-hand side, means under horizontal axis
labels we have floors. As we heard, discussed, or lady, we want finish dates
on horizontal axis means we need to edit
the data for the series. Hence select the series. Click on edit and edit series
dialog box will appear. Here you will see three value
boxes to enter the data. First we are Lubac
says Siri's name under which the data
is already captured. This value box just defines column header on name
of the activity. Second value boxes
series x-value walks. We wanted to show floor
row-wise finish date for each activity against aim. And hence we need to select Finish dates in x-axis
while loop box. Hence select cell range
containing finished it. Let's move to cities
while loop box. It will define height or
floors in our Gantt chart. Hence select floors
from the data. Click Okay. Now you will
see a graph created. No, we will format
the chart a bit. First, we will format x-axis. Let's select x-axis. Right-click, and
select Format axis. We will get a task pane
on the right-hand side. Under access options. Good to bounce. Here we have minimum
and maximum. It defines the range of dates or boundaries
of our timeline. We weren't timeline from 13, January 18 to 18, August 18. You can change the dates also. Type these values in the
minimum and maximum. Minimum. Third been January 18. Maximum eight been August 18. Now let's change
the scale to seven. Under measure units. To save in. Here we haven't taken weekly
interval, the number. Select category as dead, and select as bait
and Mn, VB MMM. Let's change the alignment of the labels to make
them properly visible. Click on Size and Properties. Under alignment. Select, rotate all
takes to 70 degrees. Now if the labels are
still not visible properly and just select the plot
area and they resize it. Here we added one series and we started some
formatting work. We will continue in the
next tutorial. Thank you.
4. Understand Data points for LOB: Hi, welcome back. We will continue from
where we had left. In the last tutorial, we added one series and
we formatted x-axis. We will format y-axis also, that is where vertical axis. Click on y-axis and enter one. Measure unit while loop box. Now we will add data labels. So select the series. Click on Chart Elements, which is on top
right of the chart. Elements. Select Data Labels. Let's format data
labels as well. Select Data Labels. Check X value as well. Expel humans finished it. Absorbed the chart we
have completion date of specific floor or
in the detail label. Let's format the chart a bit. Select the chart. Go to Design tab. Under Chart style. Change the style of your choice. Here I will select style nine. Now we are building
our chart here. Let's add another
activity in our chart. Right-click on the chart again. We will get context menus. Click on Select Data. The Select Data Source
dialog box will appear. We already have one
series in our chart. We need to add
another series which contains finish dates
for second activity. Hence, click on Add
under a series name. Select silicon tending column header mesentery
under x-value box, select Finish date
for that activity. In series y-value box, select cell range containing
floors. Click Okay. You will find another
line added to our chart. Let's add data labels
to this series as well. Select the series. Click on Chart Elements. Elements, Select Data Labels. Let's format the data labels. Select labels. On the right-hand side, check x-value as well. Here our basic graph is ready. You will find lines passing
through each data point. As we have already seen, each data point is at
the intersection of its position on
x-axis and y-axis. Each data point is at
the intersection of its position with respect to the finish date and the
particular floor level. Hence, when you take
the mouse pointer over any of the data point, it shows its position
along both the axis. It tells you finished it. The floor under
consideration as well. Further, you will absorb
certain slope for this line. This slope represents
production rate for that particular activity. For this timeline. You absorb the second activity with respect to the
first activity. Say activity also follows first one with the
identical slope. We can say that
production rates for both the activities are
balanced in this case. That's all for this tutorial. In this tutorial we created
a symbol 3D Gantt chart or line of balance using scattered
chart for two activities. Some important
points to remember, only two value boxes there it is x-axis while loop box and y-axis value box defines the
graph or designs the graph. We wanted to show
activities against Spain. Hence, we selected
dates in x-value box, means we selected finish
dates in x-value box. We use Why? Well, Lou box to represent
floor level or height. Whenever we are using
lineup balance charts, we will select dates
in x-axis while loop box and floor label our
height in y-axis value box. This tutorial will help a lot
to build further reports. In the next tutorial, we will prepare line of balance sharp for a commercial project. Thank you very much.
5. Data Set up for Commercial Building for 3D Gantt chart or LOB: Hello. In this tutorial, we
will see how to create line of balance chart
or a low bar chart, or a 3D timeline or 3D Gantt chart for a
commercial project. Here we will go one step ahead. For a typical
project, generally, floor hate doesn't remain constant throughout
the building. That is, if you absorb the
section of the building, we have used certain sets of floors are different heights. For example, basements, parking. How different heights? Office floors may have a different height
than parking floors. Structure about terrace
has different height. Know when we try to represent the lines with respect
to each floor, it creates a problem because
of variable heights. But there is a very
easy solution. Or rather we can say there is a very simple trick which helps us a lot in
our further reports. Also, in this tutorial, we will learn very
interesting thing how to create a perfect graph for
variable height of floors. So that data point for
that particular floor exactly matches the floor
level under consideration. Once you learn the simple trick, you will be easily
able to create amazing 3D timelines or line of balance charts for any
current of the building which contain any kind
of height four floors. Now let's see how to use scatter chart to
create a 3D timeline. Let's refer the data. Here is the data for a
commercial building. A typical commercial
building contains many areas as parking floors and office floors with
different heights. In the first column, we have floor to floor height. In the second column, we have lower levels
of the building. Third column contains
designation of Florida. Next columns and ten activities and late finish dates
for respect to floors. Here I heard they can
finish their itself only few selected floors to
make the chart little easy. We can plot date for activity
and every floor also.
6. LOB commercial - Add first series : We will begin
creating the chart. Let's go step-by-step. First, we will enter the chart. Select Finish dates
with column header. Go to Insert tab charged group. Under Insert Scatter
or bubble chart. Select scatter with
straight lines and markers. We will see a scatter
graph created. Let's resize, increase
the size of the shot. First, we will format the chart. Absorb the chart. Here we have dates on y-axis and
floors on x-axis. Whereas we weren't dates on
x-axis and floors and y-axis. So that chart replicates
the building. So we'd do the same thing as
we did in the last tutorial. Right-click on the chart area. Click on Select Data. Select the series which
is already added. And I click on edit. And edit series dialog
box will appear. We don't need to change
anything in series name. Rarely box as the column
header is already captured or the name of the
activity is already captured. In series x-value box. Select Finish dates
for structure. In series YOLO box. Select levels from
second column. Click Okay. Our chart
with one series is ready. Let's format the
chart. Move the chart. If you will absorb the chart, you will find points
below x-axis. Also know these dates represent finished date
for basement floors. We will format axis, select x-axis, right-click,
and select Format Axis. Under abounds in minimum fire, June 17, in maximum
fire, December 19. Now here the timeline
is large enough, so we will take
monthly interval. There is inconsistency
in days, months. How over the year? Like few months contain 30 days, whereas few contain 31 days. Do this. We will use 30.5 units. Let's put 30 value as measure
as well as minor unit. Under labeled position. Select low. Go-to number. Under
Category. Select Date. Under type, select
month and year. Mmm, YY. We will change the alignment of label to make them
properly visible. Click on Size and
Properties under alignment, open various options for
ticks alignment and select, Rotate alt-text to 70 degree. The labels are still
not visible properly. We can select plot area by clicking on the chart
and the resizing it. Select Y-axis, right-click
and select Format Axis. I was on the floor levels. Here we held minimum as minus
8.7 and maximum as API 0.3. We will use these values
under major and minor units. What do we don't want
a y-axis on the chart. Hence, click on the chart. Under Chart Elements under axis. Unchecked, Primary Vertical X. Let's add data labels
to the series. Select the series. Click on Chart Elements. Elements, selecting data labels. Now let's format
the data labels. Select Labels. Format Data Labels. Task pane will appear
on the right-hand side. Under Label Options. Check x-value and
uncheck y-value. What it means we are
showing only finished it and we're not chewing
height or fluid. Know when you absorb the
chart we help completion date of specific floor
in the data label. We will change the
alignment of the label. Hence, click on Size and
Properties under alignment. Select text direction. Rotate to 70 degree. Let's change the font to Arial and decrease the
font size to eight. Let's remove
horizontal grid lines. As we will use buildings
section to highlight the floor. Click on Chart. Under Chart, Elements,
under grid lines. Unchecked primary measure
horizontal grid lines. In this tutorial, we saw how
to create a 3D timeline for a project and how to how data point exactly in front of
that respect to floor, taking into account floors
with different heights. Next tutorial, we
will add image of the building so as to
make the presentation fairly easy to understand
and to communicate in a better manner. Thanks a lot.
7. Position data points in space along with building: Hello, Welcome back. In this tutorial, we will see how to
add an image and match dates with respect to
floors in a building section, you endo floor height is not constant throughout
the building. Go to Insert tab under
Illustrations group. Click on Picture. Select the image from the
location and click on insert. An image will be inserted. Now select the image
and reposition it. Just the size of image. Just the size of chart area
and plot area if needed. Moody image about the chart. Just resize it. Right-click on the image and
send the image backwards. Select Chart Area. Go to Format. Under Fill. Select no fill. The outline, select no outline. Now align the chart so that basement data point matches best men floridly
well in this section, now believe the title. Add just the chart area and broad area to match
individual floor data points. It may take a minute or so. Display around. You can resize the image
also if you need. But remember to not to
change the aspect ratio. Most select x-axis. Make it bold. Increase the font. Change the font
color, the orange. Select what it picker grid lines and change
color to orange. And select squared a dot. Now let's add legions. Click on the chart. Under
Chart Elements under lesions. Click on More Options. In the task pane on
the right-hand side. Under the lesion options. Legion position, check left. Unchecked, showed the lesion without overlapping the chart. Select the series
under fill in-line, change line color
to purple accent. Click on market. Under
Fill, select solid fill. Orange color. Under border. Select solid line.
But upper color. Select Data Labels, and change their color
to purple accent. Here you will easily find
finish date of respect to flow or just by pressing
along the grid line. Let's say we want to
know the finish date for terrace level price along the grid line and check the
data point you will find 16, August 18 is the finish
date for RCC Paris level. Now, RCC completion babies
Greenpeace, September 18. Moreover, if you
take mouse pointer over the top wine for any floor, it will give you floor level and finished it absorbed the data. Suppose you want to know RCC
finish date for 14 floor, which is at 60.05
meter floor level. Now we will take mouse
pointer over the data point. When you take your mouse
pointer or the data point, it will display a box. First value gives
you a finish date, and second value gives
you floor level. Let's check the date with respect to the
floor level, 60.05, you hence 14 floor assets if finished
date is 28, June 18. Know how we can draw some inferences or conclusions
by absorbing the chart. When you look at
the data points, we have around two data points in a month on an average for typical floors means four floors between first floor
and Data Explorer. We can easily say that RCC productivity is
two floors per month, or we're casting two
slabs in each month. So roughly overflow, it takes
15 days for RCC completion. This kind of conclusions you can easily draw by
observing the chart. Because of graphical nature, LOB is very easy to read, visualize, and analyze in comparison to conventional
Gantt charts. The inferences help a lot
to plan, cross-check, and reschedule construction
processes like procurement and
inventory management, cashflow and execution. We will go in detail
in next tutorials. Next tutorial we will add few more activities and
will develop line of balance sharp for a typical floor commercial
project. Thank you.
8. How to add more data and format: Hello. In last tutorial, we
plotted one series and added an image to
improve visualization. In this tutorial, we will learn how to plot few more activities. We will make it
more interesting. We will learn how to represent activity finish date for
different flows as well. Please absorb the chart
which contain dates. Here column header
represent activity names. We will show a few
activities start from first floor and
finish at 16 floor. At initial level. Might elevator work starts from leaf machine room and
finish at lower best men. I hope but oppositely
used finish dates for different floors so that
you will understand the logic behind it
and you can easily plot it for any given situation. Let's add another
activity of sand blaster. For this activity, we
will use finish date for first floor and 16 fluid. Right-click on the chart area. We will get context menus. Click on Select Data. Select Data Source
dialog box will appear. On the left-hand
side, you will find one series already selected. Here we will add another series. Hence click on Add. Under a series name Value box, select the cell which contain
name of second activity, that is sand plaster. In series x-value box. Select dates for sand blaster. So click inside x-value box
and select Finish dates. Select Finish date
for first floor. Insert coma. Then select Finish
date for 16 floor. Here we are entering the
values in a different way. Let's move to cities,
Wyman blue box. Here we will enter floor levels, select the cell containing
first floor level. Insert coma. Then select the cell
containing 16th floor level. Here is that you
can draw a line in between any two or more floors
by selecting Finish dates and heights for those with
respect to fluids separate by comma in x-value box and
white box respect to. Click. Okay. You will find another
line is created. Let's format this. Select the series
under fill in line. Change the line color to
green. Click on marker. Under field, selecting
green color. Under border. Select solid line green color. Go to Chart Elements. Click on Data Labels. Now select data labels. Under Label Options, check
x-values and uncheck y-values, as we will add only finished it. Select Label Position left. Change their field to green. Change foreign color to black. Make the font bold. Reduce foreign size. Let's add another activity
of waterproofing world. Right-click on the chart area. Click on Select Data. Click on Add. Under a series name Value box. Select the salvage contain
name of the activity, waterproofing. In x-value box. Select Finish date
for the first floor. Insert coma, then select
Finish date for 16 floor. Similarly, in
series y-value box. Select the cell containing
first floor level. Insert coma. Then select the cell
containing 16 floor level. Click OK. Now format the series. Select the cities
under fill in-line, change line color to blue. Click on the marker. Under Fill. Select blue color. Under Barter. Select
solid line blue color. While the series is selected, go to Chart Elements. Click on Data Labels. Select Beta labels. Right-click. Click on Format
Data Label. The task pane. Under Label option, check
x-value or uncheck wire loop. Click on Size and Properties. Under alignment, x-direction, click on the
rotate alt text to 70 degree. Most Select Data Labels. Change their field to Blue. Change foreign color to white. Make the font bold, reduced the foreign size. We will continue in the
next tutorial. Thank you.
9. Make it visually Appealing: Hi, welcome back. We will continue from
where we had left. Let's add another
activity of piling work. Right-click on the chart area. Click on Select Data. Click on Add and better
Series Name Value box. Select the cell which contains name of the activity tiling. In x-value box. We will select date for tiling. Select finished it
for first floor. Insert coma, select
Finish date for 16 floor. Similarly in series y-value box, select cell containing
first floor level, insert coma, then select the silicon tanning
16th floor level. Click Okay. We have
added another line. Select the series. Under fill line, change
the line color to orange. I click on marker. Under Fill, select orange color. Under Barter. Select
solid line orange color. Select the series and
go to Chart Elements. Click on Data Labels. Now select data labels. Under Label Options. Check x-values and
uncheck y-values. Click on Size and Properties. Under alignment. Thanks direction. Click on rotate
alt-text to 70 degrees. Select Data Labels,
change their field to orange and change
font color to black. Make the font bold. Reduce the font size. Let's add another activity. False ceiling would
right-click on the chart area, click on Select Data. Click on Add. Under series name or Lubac. Select the cell containing name of the activity false ceiling. In x-value box. Select dates for
false ceiling word. Select Finish date
for first floor. Insert coma, then select
Finish date for 16 floor. Why we're Lu box. Select floridly wells. First floor. Insert coma, then cell containing 16
floor level. Click Okay. You will find another
line is created. Select the series
under fill in-line, change line color to light-blue. Click on marker. Under
Fill, select light blue. Under Barter, select solid line, light-blue. Let's format this. Select the series,
go-to chart elements. Click on Data Labels. Select data labels. Under Label option, check
x-values, and uncheck y-values. Select Label Position. Click on Size and Properties. Under alignment. X-direction, click on the
rotate alt-text to 70 degrees. Select Data Labels, change
their field to light-blue. Change foreign color to black. Make the font bold and
reduce the foreign size. In this tutorial,
we have created a 3D Gantt chart or line of balance for a few activities
for typical floors. That is from posts
blower to 16 fluid. Next tutorial, we will add few more activities to our existing line
of balance chart, but we will use different
sets of floors. Thank you.
10. Finish 3D Gantt charts and Read the data: Hello. In last tutorial, we created a 3D Gantt chart for a few activities from first
floor or to 16 floor. This tutorial, we
will create a line of balance for a few
more activities, but we will use different
sets of floors. Let's add another activity
of external facade. Here we will take finish date of facade from the risk level. So click on the chart area, click on Select
Data. Click on Add. Under series name Value box, select the cell
which contains name of activity, external facade. In X value box. Those select Finish
date for first floor, insert coma, then finish
date for terrace level. Now in series y-value box, select the silicon
turning first Flow Label, insert coma, then silicon
containing Davis fluid label. Click Okay. You will find another activity added
to our 3D Gantt chart. Starting from first floor
tilts there is fluid. Select the series
under fill in-line, change line color to dark red. Change dashed type
to square a dot. Click on marker under
Fill, select dark red. Under Barter. Select
solid line, dark red. Go to Chart Elements. Click on Data Labels. Most Select Data
Labels under Label, option, chick, x-values,
and uncheck y-values. Click on Size and Properties. Under alignment,
takes direction, click on, rotate,
alt-text to 70 degree. Select Data Label, change
their field to dark red. Change foreign color to white. Make the font bold. Reduce the foreign size. Let's add another
series of elevator. Let's observe elevated rates, elevator activities taken from leaf machine room
bill last basement. Here we need to select the cells corresponding to the label of best men and
lift machine room. Right-click on the chart area. Click on Select Data, click on Add under the
series name Value box. Select the cell which contains name of the activity elevator. In x-value box, we will
select date for elevators. Select Finish date for
basement to insert a comma. Select Finish date for
lip machine room top. Similarly in cities
y-value box select cell containing the floor level
of basement to insert coma. Then select the cell
containing level of top of lip Machine Room. Click Okay. Here we will find another line created but for
different set of floors. Now select the series
under fill in line, change line color to dark blue. Change batch type
two square dot. Click on mocker under Fill, select dark blue. Under Barter. Select solid line
and dark blue color. Let's select the series, go-to chart elements and
click on Select Data Labels. More select data labels
under the label option. Chick, x-values are
uncheck y-values. Select Label Position, right. Change the data
field to dark blue. Change foreign color to white. Make the font bold. Reduce the font size. Let's add another series for finishing dates
for each floor. Here, we will add final finishing dates for
each flow are same as RCC, but only for office floors. Right-click on the chart area. Click on Select Data. Click on Add under
series name var lib box. Select the sale which
contain name of activity finishing x x-value box. Select all finish dates starting
from first floor to 16. Fluent. In cities y-value box. Select cells containing
all fluid levels from first floor
to 16 floor level. Click Okay, you will
find another line added. Select the series
under fill and line, change line color to dark red. Click on the marker under
field, select dark red. Under Barter, select
solid line, dark red. Go to Chart Elements. Click on Data Labels. Select the data labels. Under Label Options. Chick x-values and
uncheck y-values. Select Label Position, right. Change foreign
color to dark red. Make the font bold, reduce the font size. Our 3D Gantt chart online
or balance chart is ready. Here we can easily absorb
that lines are not crossing what it means
productivity rates are maintained in
such a way that all internal
finishing activities are performing uninterruptedly. When you take mouse to
any of the desktop wine, it gives you activity
name and finish date for that activity
at that floor, which makes it easy to read. A project manager
and project team can easily analyze
the information and can easily make
strategic decisions regarding contact or
finalization procurement, managing funds, or workflow. Lob charts are invaluable
in review of any schedule. Pictorial and graphical
representation, enhanced visualization
and understanding. As everything is created
using Excel charts, you can easily change the dates and can see the
effect immediately. You can experiment a lot
with different strategies. You can easily compare them, evaluate them, and
choose the best among. It gives them more control over the future processes
of the project. Use it often and it will certainly give you
wonderful results. Thank you very much.
11. Prepare Linear or Align based schedule: Hello. We discussed earlier that line of balance
is suitable for effectively scheduling
the projects which contain the repetitive
work or activities. Project involving
repetitive activities can be grouped tasks, pointing best products and
distance best projects. In our earlier tutorial sweep created line of balance
Per Point best projects. For Distance-Based projects
or alignment in this project, activities are performed
continuously along the length of horizontal
alignment of the project. Highways, railroads, panels, and pipelines are examples
of such projects. The linear scaling method is very useful and
informative tool for scheduling alignment
and best products. Linear schedule is
developed with time on the y-axis and
distance on x axis. We will try to deliver schedule for a pipeline lane project. Biplane projects
in wall activities continuous along the
horizontal alignment, such as grabbing, stringing, bending, welding, coding, etc. Typically, the same
crew repeats each of these activities from one end of the project to the other. Often the only
distinguishing feature for this linear type activities
is the rate of progress. For pipeline
construction projects. The sequence of activities is usually not the
issue of concern. Instead, by issue is accurately
assessing and achieving the optimum production rate necessary for timely completion. Hence, we will plot linear
chart for the review. Basic schedule is prepared in Microsoft Project and
balancing is done later on. Mass production rates. And to ensure continuous work
friend using linear charts. In this type of scheduling, there is a slight
difference in the layout. In linear scheduling,
we take distance on x-axis and dates on the y-axis. Please refer the data. Here we have a schedule
prepared for a stretch between Wednesday at a 100
meters and 4900 meters. Leftmost column
contains activities. The entire pipeline work is
broken into three stages. Stage one, stage
two, stage three. Then we start and
finish dates for each activity and for each
stage in subsequent columns. I specifically put Janet about dates and column
headers about change. In this arrangement
makes creating linear scaling chart surprisingly
simple and fast. We will begin
preparing the chart. Select entire data range
including activity names, Genesis, start, finish dates. Go to Insert tab. Charts, group, insert scatter with straight lines and markers. You will find a chart if we
look a little different, but don't worry,
we will format it. Increase the size of the chart. Right-click on the chart area
and click on Select Data. Select Data Source
dialog box will appear. Now we'll just do
one simple thing. Click on switch row, column. Mousey, we have
activities and category, and distance on
horizontal axis labels. Click Okay. You will find a graph created
in this few minutes. We will just how to
format the chart. Select the chart. Under design. Select Style Six. Most select y-axis. Under Format Axis task been in access option enter minimum
value as 20 February 18. Maximum. No emulating. In units. Enter 30 phi you in measure
30.5 minor as well. Under tick marks. For measure pipe, select outside in number. Under Category. Select
Date, and select bypass. Month and year. Most select x-axis. Under Format Axis pass pin. Emax is option. Minimum value as friendly 700, and maximum 5 thousand. In units enter 100 in
measure and a 100 in myelin. Under tick marks. Outside for measured pipe and outside for
minor type as well. Selected regions. Under lesions options. Untick showed the lesion
without overlap in the chart. Mood the lesions just
about the y-axis values. Resize it if needed. Select plot area and
move it all the way up. Click on Chart Title. Select the chart.
Under Chart Elements. Check data labels. You will find start
and finish dates added near data point for
every activity. For every section. I have already inserted the
image in the worksheet. Now we will drag the
image and reposition it. He can resize the image
and resize the chart. That the stages matches
exactly with the chart. So our linear scaling
chart is ready. In this method, the
progression of each of these activities
in the relation to location and time is
plotted on the chart. Project bim can easily determine activities in progress
at particular location. Activity production rates
represented by slopes of the line and
scheduling conflicts do to work location constraints. The convenience flow of
work along the alignment becomes a driving factor in scheduling linear
products of this type. Most continuous
resource usage is critical in establishing
the project mutation. The use of graphics and
visual into Tunis provided by separate activity pipes and labeled project
managers, schedulers, owners and construction personal to better visualize the plan of action and more
easily communicate the plan to everyone
involved in the project. Thank you very much.
12. Prepare LOB for a Skyscraper: Hello, welcome back. Earlier we created a 3D timeline or line of balance for
a commercial project. In this tutorial, we will create a line of balance
for a skyscraper. Moreover, along with
creating a line or balance, we will learn few additional
tricks and techniques which will enhance our LOB
charts to a great degree. Let's see the section of
the high-rise building. I have already inserted image. We will develop a lobby using this section or this image only. Let's refer the data. In the Excel sheet. Dates are extracted from
Microsoft Project schedule. First few columns contain floor demarcations and
respect to Florida levels. Next, column headers
contain activity and finish date for floor
under consideration. Here we will learn how to show bars in line no balance charts, how to create symbol milestones, and how to add few
important procurement items in our LOB chart, which will help immensely
in the reviewing the schedule and taking
strategic decisions. Unlike previous
tutorials, we will start working directly
on the image. Let's begin creating the chart. First, we will enter the chart. Go to Insert tab charged group. Under Insert Scatter
or bubble chart, select scatter with
straight lines and markers. We will see a scatter
graph created. Let's increase the
size of the chart. Here, we will insert RCC activity in the
form of bar charts. Right-click on Chart Area. Click on Select Data. Under the legend
entries. Click on Add. We will see an edit
series dialog box. Didn't see his name value box. Just type RCC. In x-value box. Select RCC start dates. In series y-value box, select Florida labels
and click, Okay. Our chart with one
series is ready. We will format Chart
Elements one-by-one. First, select Y-axis. Right-click. Click
on Format Axis. Under Axis Options type
minus 70 in minimum. Remember we have
fluid level as minus 29.89 in maximum pipe 1050. We don't want to
display y-axis as we already how buildings
section for the reference. Hence, go-to chart
elements under excess option, unchecked
vertical axis. Let's format x-axis now. In minimum, enter three, Juliet been in maximum
Phi u January 22. Interim measure units as
penalty point for you. Minor. Third, peak wind for you. God took tick marks. Select outside for major type. Go to labels. Select Label, Position low. Go-to number. In Category. Select Date, and type
as month and year. Go to Size and Properties
under alignment. Thanks direction. Select, Rotate alt
text to 70 degrees. Make it board. Increase the size and change the color to blue. Click on the plot area. And the resize it so that x-axis labels are properly visible. Click on the chart area. From Format tab. Remove fill and outline. Let's go to Format tab. Under the shear fill. Select no fill and no outline. Under Shape outline. Select the chart. And the
remote horizontal grid lines from chart elements. So here we plotted one series. In the next tutorial, we will learn how to show
activities in the form of a bar chart. Thank you.
13. 3D Gantt chart for the Skyscraper: Hello, Welcome back. In the last tutorial, we plot in one series. In this tutorial, we will
match data points with the section and format the
series to create bar chart. First, select plot area and take it all the way to
the top of the chart area. Select the chart
area and address it. Such a way that
super data is data pipeline matches with the
dotted line of the same. You can invariable adjust the
plot area from the bottom. Also. Great. Now we will format the series as
we want to show bar charts. Select the series. Under Freeland line
option, select no line. Click on the marker
option and check none. Now the question is
how to show bars representing the duration
for each floor under RCC? What can you think of
a possible solution? I will give you a hint. Era bars will be
very handy here. Can you think?
Okay, let's start. We will insert error bars with
the series still selected. Go to Chart Elements. Under error bars. Click on More options. For error bar options. Select series are
CC-BY error bars. Here we don't want
why edit the bars? Hence under Edit about options. Select plus no cap
and fixed value as 0. Select series RCC x error
bars, direction select plus. In style, no cap. Select Custom. Click on specify value. A custom error bar
dialog box will appear. In positive error value. Select cell range containing duration of each
activity for RCC work. Under Freeland line option. Underline, select solid line. Red color. Increase the width. Three points under shadows. Select opposite
diagonal bottom right. Now let's add data labels, but in a different fashion. We will try to show name of
the floor and finish it. Now if you remember, we already selected start date, but here we are trying
to show finished it. Hence select the series
from Chart Elements. Click on Data Labels. You will find data labels added. Now we want to show activity finish dates
behind the bar chart. We need to insert. One column. Insert a column. Great. Now drag the formula. Go to our chart.
Select data labels. Under Label Options. Click on value from cells. Data Label Range,
dialogue box will appear. Select cell range from column
we have just inserted. Click Okay. Goto label
position. Click on left. You will find data labels inserted with floor
and finished it. Select Beta labels,
reduce font size. Now let's say we wanted to focus few important floors
which we can use as our milestones for starting subsequent activities
and material ordering. Hence, select Beta label
for the first floor. From home. Change
the field to pan, change foreign color
to read. Make it bold. Select tenth floor. Change the field to tan. J's the foreign color to red. Make it bold. Select 28th floor. Change the field to pan
and change the font color to red. Make it bold. Select 13th floor. Change the fill to change the font color
to red. Make it bold. Select 14th floor. Change the fill color to
change the font color to red. Make it bold to
select service floor, change the field to change the foreign color to
red, make it bold. It is done. We have
inserted one series. So in this tutorial we
enter RCC activity, where we short duration in
the form of bar charts. Remember we use simple and
formatting techniques. Moreover, we added
different formatting for some important floors, which we can use as base for focusing
subsequent processes. What do we did? We
selected the cities and enter data as usual. But then we hide the
line and marker. Then we use the error bars
to show activity duration and kept error value equal to
duration of that activity. Here error bars played
important role for showing the duration of that particular activity
at that floor level. Just practice it a few more times and you will
be very good at it. We will continue
with more fun in next tutorial. Thank you.
14. Add Dynamic milestones : Hello, Welcome back. Here we will insert
few activities, mainly from project
preliminaries, but in a different fashion. Loe charts contain balanced
lines of activities, but we can definitely add additional information
on the same chart to improve visualization for decision-making and
review purpose. We will insert few activities
in the form of milestones. We created RCC
series first as we wanted to set the entire
timeline range and Chart Area. Right-click on the chart area. Click on Select Data. Click on Add and Edit
series dialog box will appear in series name value
box just pipe preliminaries. In x-value box. Select dates from
rock and cutting period tower crane installation. Here we will have to do
a horizontal selection. By now, you must tell
we realized that whether you selected
horizontally or vertically, if you end up proper values
in X value box and white box, that you can easily
plot the graph and show any kind of the
information you want. Now we'll plot these
dates in the form of milestones about x-axis. Now how much M0 we
want to show values to be plotted will come
under y-value box. Height of the buildings
around 950 meters. So we will plot data
labels at 150 so that labels are easily
visible in y-value box. Now here is another trick. We have to manually enter
the value, insert 150. But remember, we meet
to enter it seven times as we go and
save and activities and projects, preliminaries. Hence enter 157 times
separated by comma. Click. Okay. I want a chart
with one series is ready. It's not properly visible
right now, but don't worry. From task pane, select
series preliminaries. No go-to chart elements, and check data labels. Select data labels. Right-click, click on
Format Data Labels. Here we want to show
activity and finished it. Hence, click on
value from cells. In select Data Label, range of value box, select column header from rock
anchoring to tower clean. Click Okay. Now to
show the dates. Check x-values and
uncheck y-values. Click on size and properties
are under alignment. Select tags direction, rotate
or takes to 70 degrees. Now we will our activity name
and finished it visible. Let's add some more formatting. From task pane select
series, preliminaries. Go to Chart Elements. Check error bar, checkbox. You will find error bars
added to this series. From task pane select
series preliminaries why error bars were articulated
about select minus no cap. Enter a 100% in value
of an error amount. You will find a robust added. Click on Freeland line. Select orange color,
increased to 1. Select bash type as
dash, select, etc. Bars from task been under a lot about
options. Select both. Select no cap,
enter fixed value. As we help plotted few activities
with finish dates here. Again, we will highlight few important activities
using different format. Select Beta label,
legal clearance by double-clicking. Make it bold. Increase the foreign size. Change the fill to change
the font color to red. Select Beta labeled
tower, crane. Make, make it board. Increase the foreign size. Change to the field to pan. Change the font color to red. Here we have used different
formatting options and short important dates in
the form of milestones only. Instead of checking the data
in tables and MSB schedule, we can use LOB charts to plot the same information
and review it. It gives a clear idea of what is to happen and when
it is to happen. We can plan our future
processes very efficiently. Thanks a lot. We will continue
in the next tutorial.
15. How to show dates for any specific level : Hello. In this tutorial, we will add few activities. Let's add activity, civil work. Right-click on the chart area. Click on Select Data. Click on Add. Under the
series name mailbox. Select the cell
which contains name of the activity, civil work. Select finished it for
first floor, inset coma. Select Finish date
for 47th floor. Let's move to cities via LU box. Select the cell containing first floor level, insert coma. Then select the cell containing 47 Florida level.
In the past pane. Select series, civil work. Under fill in line. Select solid line. Select line color, dark green. Click on mocker
under marker option. Select, automatic. Under Fill. Select
and dark green color. Under border, select solid line. Dark green color. Now go to Chart Elements
and check beta labels. Select the data labels under Label option,
chick, series name. Jake, x-value, uncheck y-value. Select labeled position below. Click on Size and Properties. Under alignment. X-direction, click on rotate, text to 70 degrees. Change. Feel too dark green. And change foreign
color to white. Make the font bold. Let's add another activity
for services work. Right-click on the chart area. Click on Select Data. Click on Add. Under a
series named wildly box. Select the cell which contains name of the activity services, will go to Series X value box. Select Finish date for
first floor, inset coma. Select Finish date
for 47th floor. Again, insert coma. Select Finish date
for super dangerous. Let's move to cities
via ReLu box. No, remember we entered three values in series
X will loot box. We need to enter floor levels
For three floors here. Select the cell containing first floor level, insert coma, 47th floor, insert coma, and superficialis floor level. Select the series
under fill in line, select solid line line color. But Apple under marker option, select Automatic.
Click on marker. Under field, select purple. Under Barbara, select automatic. No go-to chart elements. And check beta labels. Select the data labels. Under Label option,
chick, series name. Check x-value had
uncheck y-value. Select Label Position below. Go-to size and properties
are under alignment. Eggs, direction, click on
rotate all takes to 70 degrees. Select Data Labels. Change their field to purple, change foreign color to white, and make the font bold. Let's add another activity
for external facade work. Right-click on the chart ADR, click on Select Data. Click on Add. Citizen
named Wally box. Select the cell which
contains the name of the activity external facade. Click inside cities x value box. Select finished it
for the first floor, insert coma, and select the remaining cell range
containing finish dates. Let's move to cities via Webex. Click inside cities y-value box. Select first floor
level. Insert coma. Then select cell range
containing floor levels for which finish dates are
captured in x-value box. Here I'm using
multiple combinations in X value box. And why? Well, Lubac so that you
can easily get hold of it. Select the series
external facade. Under fill in-line,
select solid line. Select line color, orange. Under market option. Select Automatic. Click on marker under Fill. Select orange. Under Barbara. Select automatic. No go-to chart elements. And check data labels. Select data labels. Under Label option,
chick series name. Check x-value or
uncheck y-value. Select Label Position below. Click on Size and Properties. That alignment begs direction. Click on the rotate all
it takes to 70 degrees. Change, feel too orange. Change foreign color to white. Make the foreign board. In this tutorial, we have
added few activities. In next tutorial
we will try to add few dates for important
material shipment. So that in a single sheet, we will try to represent as much more information as
possible in different format. Thank you very much.
16. How to show procurement dates on the same chart: Hello, Welcome back.
In this tutorial, we will add another
series and we will try to show important
material shipment. Let's add another
activity for a handler. Right-click on the chart area. Click on Select
Data. Click on Add. Under the series name Value box. Select the cell which contains name of the activity hand lower. Click inside series X value box, and select Finish
date for first floor, insert coma, and select
Finish date for 47th floor. Let's move to cities via LU box. Select first floor level, insert coma, and select
47th floor level. Select the series handover. Under Freeland line,
select solid line. Select line color, light green. Marker option. Select
Automatic. Click on marker. Under field, select light green, border, select light green. Go to Chart Elements
and check data labels. Know Select Data Labels. Under Label option
check series name. Check x-value, and
uncheck y-value. Select Label Position Below. Click on Size and the properties under alignment, x-direction. Click on the rotate alt
text to 70 degrees. Select Data Label. Change their field
to light green. Change foreign color to white. Make the font bold. We are learning here what all possibilities this
simple technique has, which gives a greater
control to project managers over the entire
project net processes. Let's insert few
materials ship mandates. Right-click on the chart area. Click on Select Data. Under the legend
entries, click on add. In series name value box. Just type procurement. In x-value box. Select dates of procurement
items will be held. Now we will plot these dates in the form of milestones about x-axis, y value box. Let's say we want first
imported tiny ship men at tenth floor level, the net when deep floor level, then 30th floor level, elevators or lifts
around roof level. And transform was at
podium one level. We need to select respect to Florida labels
separated by comma. Select tenth floor
level. Insert coma. When Pete Florida
level, insert coma. 30 floor level, insert coma. Roof level, insert coma
and podium one-level. Click OK. So on imported items
are plotted on the graph. Now we need to format them. Click on Data Labels. Let's select procurement
series from the task pane. Under fill in-line go-to marker. Under marker option. Select Built-in go-to type. Frog, drop-down menu,
select diamond chip. Increase the size to seven. Select orange field. Go to Chart Elements. Check data labels. Most Select Data Labels. Go to Label Options. Here we want to show name of the activity and
material delivery dates. Hence, click on
value from sales. In select Beta label
range of value box, select all procurement
items and click Okay. Now too short dates. Check x-values and
uncheck y-values. Take labial position to write. Change the color to blue. Make them bold. Make them italic. Go to Format tab in
charter schools. Civic outline, color
to white background, one, darker 50 per cent. And select dashed outline. We will have activity
name and finished it. Visible. Luby charts are ready
in a single chilled. We tried to create the complete picture of
important project activities. And that took chronologically. Here we have bar charts, milestones, and line charts. Charts are
tremendously powerful. Just imagine your sheet
is like a blank canvas. Every point on the sheet is an intersection of
height and y-axis. And it's a real-time
position on the timeline, which is on x-axis. Moreover, it's all dynamic. The moment you
change the date or the height, repositions itself. Lob charts gives you a clear
picture of your project. It's a great way to visualize
the project schedule. The chart style you
went to focus and what to focus weekend easily prioritize our efforts and resources by identifying
criticality of the project. You can analyze almost
everything using simple sheet. It immensely help
a project manager to take accurate decisions. Lob charts. I like seeing a
broader picture by looking at vital aspect of
the project schedule. I am absolutely sure
it will help you go along way because it stimulates
ultimately to thinking. Once you plot it
on a Louis charts, you will start reviewing the schedule in a
more creative way. Please reward in case of
any queries or suggestions. Suggestions, feedbacks
are always welcome. Thank you very much.
17. Line of Balance - Basics of Balancing: Project consists of a number of activities happening in
a sequential manner. Every activity has different processing time
or production rates. In this production variables continuously Africa the
schedule in a way or rather. The line of balance technique is a scheduling method that allows balancing
of the operations are production rates of
different activities such that each act they would be
performs quite efficiently. In this tutorial,
we will see how to use balancing techniques so that This can be performed efficiently without
any interruption. Let's refer the data. Here are the dates off to activities waterproofing
and tiling. It takes 15 days to complete waterproofing work of one fluid. Whereas it takes plane this to complete piling
work of one floor. This speed we can
say waterproofing has productivity of
two floors per month. Dialing has productivity
of three floors. Pearlman. We'll start
creating the lines. We will insert graph. Go to Insert tab, Charts, group, insert scatter with
straight lines and markers. Blank chart will be created. Right-click on the chart. We will get contextual menus. Click on Select Data and select the tau Soyuz dialog
box will appear. Click on Add and we will
add waterproofing activity. Series name Value box, select column header
waterproofing. In x-value box, select
waterproofing, finish dates. And in Y value box, select floors. Click Okay. No first line is added. Again, click on Add. See these named Value box. Select the cell
containing tiling. In x-value box. Select tiling dates. In YAML Lu box, select respect to
floors. Click Okay. You will find two lines
added to the graph. Let's do some formatting. Select x-axis. Under minimum, fire, March 18, maximum
type fire November 18. Measure units and
pursuing under number, select Date, category,
pipe as bid and MAN. That is 14 March in
Size and Properties. Select text direction.
As it rotates, takes two to 70 degrees. Select the plot
area and resize it. Most select
waterproofing series. Board to Charlie limits
and select Data Labels. Select the data labels. Under Label Options, chick, x-value and uncheck y-value. Select tiling series. Go to Chart Elements and
CIC data label checkbox. Select labels under
Label Options, chick, x-values, and
uncheck y-value. Here you will see two
intersecting lines. As filing succeeds, waterproofing with higher
productivity rate, there are chances that
manpower may remain idle. Hip proper attention
is not paid to the high productivity
rate of piling work. When we plot the graph, we realize there is a crossover, which should always be
a widely because it is the point where succeeding
activity has two hard to let the preceding
activity finish. We will continue the same in the next tutorial. Thank you.
18. How to Balance Activities?: Hello, welcome back. We will continue from
where we had left. When we plot the graph, we realize there is a crossover which should
always be avoided. Because it is the point where succeeding activity
has two hard to lead the preceding activity
finish in schedule. Actually there won't
be any crossover as both the activities will be linked by finish-to-start
relationship. But the tiling we'll hard at every floor to accommodate for process time
of waterproofing. Here I will add another series, the dates of which are taken from Microsoft Project schedule. Here I added another
series with start, finished it so that
you can understand what happens in Microsoft
Project schedule. How to add this series that we will learn in next tutorial. Initial floors, if you
will absorb the line, you will see activity
for the next floor commencing as soon as activity for preceding flow
gets completed. Merton later on you will
absorb some gap or lag. It means styling for the next flow or current
comments at suny, styling of previous
fluid gets completed. But it will start
with some gap or lag if you are absorbed. Third floor tiling is
finishing on 21st off me. But fourth floor tiling
starts on 26th May. This is because
preceding activity or predecessor for that floor, which is the waterproofing, is not completed by that time. Same pattern will be
repeated for every floor. At every floor tiling
manpower will remain idle for some period of time
to accommodate for more processing time
of its predecessor, that is water proofing. To work on this problem, we will have to
delay the start of tiling in such a way that it performs to its full potential without delaying the
project schedule. We had to eliminate
the crossover in the schedule and in
actual condition also. Now, our aim here is to complete the tiling
work uninterruptedly. Hence, in this situation
we need to delay startup succeeding activity that
is dialing, in our case. Select dialing in Format
Data Series past pin, chick on freelance online. Change line bashed
pipe to round dot. We will add another
activity piling be. Here. We have balanced
the tiling dates. Let's add the series and
right-click on the chart. And click on Select Data. Select Data Source
dialog box will appear. Click on Add under series name. Select tiling be. In series x-value box. Select dates from first floor
and pen floor separated by comma series y-value box. Select cells from
first floor and ten floor separated by comma. Select this series. Go to Chart Elements
and check data labels. Select data labels
under Label Options, chick, x-value, and
uncheck y-value. You will see tiling actor would
be added with revised it. Now there is no crossover, which means filing can be completed without
any interruption. Here we are held in
combination of line of balance technique and
Microsoft project scheduling. This type of scheduling enhances visual capabilities of the
standard scheduling practices. It helps project managers and project team to better
understand the effect of production variables on
construction process and to manage the processes and resources quite efficiently. Next tutorial, we
will see how to balance a set of activities. Thank you very much.
Amey Vidvans, Education and Technology Enthusiast
