MH
Uploaded byMohammad B. Hamida
269 views

Microsoft Excel: Applications of the Software in the Architectural Engineering Domain

The document provides an overview of Microsoft Excel, its history, and its applications in architectural engineering. It covers basic calculations rules, systematic procedures for programming sheets, and includes exercises for practical application. Key features include the cell types and principles for entering equations, as well as the comprehensive features of Excel for enhancing professional performance.

Embed presentation

February 4, 2019 By Mohammad B. Hamida Slide # 1 King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬
1. Introduction  Overview of Microsoft Excel  History of the Development of Spreadsheet Applications/Software  Software interface 2. Applications of the software in the ARE domain 3. Rules of basic calculations in Excel  Cell type  Principles of entering equation 4. The systematic procedure for sheet programing 5. Exercises  Exercise 1: Calculating the relative difference  Exercise 2: Analyzing the space efficiency of the architectural design  Exercise 3: Preliminary Designing of the Lighting System  Guidelines of Conducting BOQ 6. Summary CONTENTS King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 2
 Microsoft Excel is a basic application software offering the spreadsheet service to the end user.  It enables the end user to organize, analyze, and graph numeric data, as well as conduct advanced-mathematical and statistical calculations for such kind of data.  Visual Basic is the macro programming language of Microsoft Excel, which is one of the old and common programming languages in the IT sector. 1. Introduction: Overview of Microsoft Excel CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 3
 VisiCalc was the first computer spreadsheet program, which was released for Apple II (computers), in 1978.  Microsoft originally marketed a spreadsheet program called “Multiplan” in 1982, which was menially Control Program for Microcomputers.  On September 30, 1985, Microsoft released the first version of Excel for the Macintosh.  In November 1987, Microsoft released the first Windows version.  After the first Windows version of Excel in 1987, the growth of developing and using the software have been rapidly increased, due to software's capabilities and features at enhancing the performance of different professions. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 4 1. Introduction: History of the Development of Spreadsheet Applications/Software
CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 5 1. Introduction: History of the Development of Spreadsheet Applications/Software
 The following diagram illustrates the interface of Microsoft Excel. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 6 1. Introduction: Software interface Quick Access Title Bar Menu Bar Tool Bar Formula (Equation) Bar Rows Columns Sheet tabs
 In the architectural engineering field, Microsoft Excel is one of the valuable tools that offer endless of applications for professionals of this domain, such as:  Tabulation of the architectural program of the building.  Estimation of the number of building users/occupants.  Estimation of the maximum demand load of water, electricity and cooling.  Design the MEP systems (mechanical, electrical and plumbing systems).  Design the structural system.  Estimation of the cost of the building during the design intention and development phases.  and others…. 2. Applications of the software in the ARE domain CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 7
 The followings are major rules that should be comprehended as well as kept in mind when an end user is using the software: 1. Cell type  Cell type is one of the key concerns that should be kept in mind when the end user is conducting calculation and/or numeric analysis.  Cell type is one of the followings: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and costume cells.  Therefore, user can select the type of the cell according to his data through identifying a cell/set of cells, then right click on and select “Format Cells”.  Through this tab, the user can select the appropriate type for him. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 8 3. Rules of basic calculations in Excel
CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 9 3. Rules of basic calculations in Excel
2. Principles of entering equation  Each equation shall be started with the equal sign (=).  Addition and subtraction processes are performed by entering their normal signs (+ or -).  Multiplication (product) process is performed by entering star sign (*).  Division is performed by entering slash sign (/).  Exponent is performed by entering caret sign (^), which can be written by Click SHIFT6 simultaneously in the keyboard.  The formula system in Excel is based on Algebra basics, which identify the priority of each calculation process.  These basics are known as PEMDAS, (Parenthesis | Exponents | Multiplication | Division | Addition | Subtraction).  PEMDAS can be remined by link it to the saying “Please Excuse my Dear Aunt Sally“ ☺ ☺ ☺.  Separation between numerator and denominator in any polynomial fraction shall be made by closing each part with parentheses. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 10 3. Rules of basic calculations in Excel
4. The systematic procedure for sheet programing CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 11  The following flowchart was developed by the course presenter, to show a systematic procedure that facilitate the programing process to Excel users: Specify determinant(s) that you would like to calculate Identify the equation used to calculate the determinant(s) Prepare the sheet layout and its cells to calculate the determinant in a right manner Enter the parameters of the equation in the right cells Enter the equation once in the first cell (if applies) Check the validity of the equation by compare it with a manual calculation of the same values Apply the equation to the rest cells in the same column by dragging it to the rest cells (if this applies) Continue if its valid Backifitsnotvalid
Exercise 1: Suppose that you are working in a study pertaining to the assessment of the impact of design/operation alternatives (e.g. wall, roof, openings or operation settings) on the energy performance of a building, using any energy simulation program as a tool to predict the energy consumption. Generally, the relative difference (percentage change) is the method used to indicate and compare the differences of the software outputs. Thus, the table shown in the next slide presents results of the energy simulation obtained from the software. Calculate the relative difference between the base scenario and the alternative in a monthly base as well as annual base, using the equation below. Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 12
Exercise 1: 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 13 MONTH MONTHLY ENERGY CONSUMPTION (Kwh) JANUARY 157,802 FEBRUARY 137,902 MARCH 226,202 APRIL 232,802 MAY 304,802 JUNE 313,802 JULY 285,602 AUGUST 345,602 SEPTEMBER 329,402 OCTOBER 238,082 NOVEMBER 226,922 DECEMBER 178,802 Total 2,977,724 Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100
Exercise 1: The exercise can be solved as follows: Step 1: Specify a column for calculating relative difference, with a cell type of “percentage”., (done by the presenter). Step 2: Ener the equation in the first cell of the column as shown in the figure below once. Step 3: Drag the first cell of the column which you have entered the equation in to the rest rows. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 14 Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100 =(C2-B2)/C2
Exercise 2: Suppose that you are working in designing a house for a middle-income client in Saudi Arabia, so that the client concerns with using each square meter in his house in an effective manner. On the other side, you (as a designer) concern with developing a design that meets the client needs as well as the regulatory requirements. In this regard, you need to show and justify your design solutions to the client. One of the methods that are used for this purpose are the calculation of the space ratio for each space in the building. Further, the ratio between usable space to the non-usable space (circulation) in a building is one of the indicators of the space efficiency of the building. Calculate the space ratio of each space of the floor plan attached in the next slide, and then determine the space efficiency of the building, using the equations below. Percatage = 𝑃𝑎𝑟𝑡 𝑊ℎ𝑜𝑙𝑒 × 100 space efficiency = 𝐴𝑟𝑒𝑎 𝑜𝑓 𝑢𝑠𝑎𝑏𝑙𝑒 𝑠𝑝𝑎𝑐𝑒 𝑇𝑜𝑡𝑎𝑙 𝑎𝑟𝑒𝑎 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 15
King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 16 5. Exercises
Exercise 2: Part 1: Calculate the space ratio (Percentage) of each space Step 1: Develop a table including three columns for the name, area and percentage of each space respectively (done by the presenter). Step 2: Enter name and area for each space (done by the presenter). Step 3: Adjust the cell type of the last column, to be “percentage”. Step 4: Calculate the sum of the areas of all rooms as shown in the next slide Step 5: Ener the equation in the first cell of the column as shown in the figure next slide once. Step 6: Drag the first cell of the column which you have entered the equation in to the rest rows Percatage = 𝑃𝑎𝑟𝑡 𝑊ℎ𝑜𝑙𝑒 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 17
Exercise 2: Part 1: Calculate the space ratio 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 18 =B2/B$18 =SUM(B2:B17) Using ($) before the cell number is required in this case for fixing the cell of the sum of rooms areas You can do this by highlighting all the cells of the area column, and then click “Auto sum” from the editing tab
Exercise 2: Part 2: Calculate the space efficiency of the building Step 1: Develop a table including three columns for the space category, area and percentage of each space respectively (done by the presenter). Step 2: Enter name and area for category of space (done by the presenter). Step 3: Calculate the usable space by taking the sum of the areas of all rooms, except the circulation spaces as shown in the next slide. Step 4: Calculate the non-usable space by taking the sum of the areas of all circulation spaces as shown in the next slide Step 5: Take the sum of the areas of the usable and non-usable space. Step 6: Highlight the all the cells of the area column, including the total, and then drag it to the right. Step 3: Adjust the cell type of the last column, to be “percentage”. space efficiency = 𝐴𝑟𝑒𝑎 𝑜𝑓 𝑢𝑠𝑎𝑏𝑙𝑒 𝑠𝑝𝑎𝑐𝑒 𝑇𝑜𝑡𝑎𝑙 𝑎𝑟𝑒𝑎 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 19
King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 20 5. Exercises Building boundaries Usable Space Non-usable Space
Exercise 2: Part 2: Calculate the space efficiency of the building 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 21 =SUM(B2:B12) =SUM(B13:B17) =SUM(B22:B23) Space efficiency
King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 22 5. Exercises Building boundaries Usable Space Non-usable Space Space efficiency = 81.6%
Exercise 3: Suppose that the owner of the previous example would ask you to develop a preliminary design of the lighting systems of his house, using the T8 - 36 Watt (a type of florescent tub lamps) for all rooms. Calculate the number of lighting fixtures required per each room according to the recommended lighting level (Illuminance), assuming 300 lux for all spaces. Then, calculate the electric load of the lighting in each space. N = 𝐸 ×𝐴 𝑛×ᴓ ×𝐶.𝐹×𝐿.𝐿.𝐹 Where: N: is number of lighting fixtures required in a given space E: is the recommended lighting level “Illuminance” (in lux) A: Space Area (in 𝑚2 ) 𝑛: is number of lamps per a fixture ᴓ: is the luminous (in FLUX) C.F: is the utilization factor L.L.F: is the lighting loss factor 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 23 From design code/standard From the product feature From the product properties (value between 0.4 to 0.65) value between 0.75 to 0.8
Exercise 3: The exercise can be solved as follows: Step 1: Develop a table in new sheet including 12 columns for the space name, area, Lighting Level, Luminous, Utilization Factor, Lighting Loss Factor, Number of Lamps Per Unit, Number of Unite and Unit Wattage (Electric load) (done by the presenter). Step 2: Transfer the room names and their areas values from the previous sheet, by enter equal equation (=) to the first cell of each columns and drag it to the rest cells. Step 3: Enter the values of the equation parameters (done by the presenter). Step 4: Enter the equation of the required number of lighting fixtures as shown in the next slide. Step 5: Based on the determined value, decide if you would like to increase the number or not for each. Step 6: Enter the equation of determining the eclectic load of the space in the first cell, and then drag it to other cells as shown in the next slide. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 24
Exercise 3: 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 25 ='2. Architectural information'!A2) ='2. Architectural information'!B2 =(B3*C3)/(D3*E3*F3*G3) =(I3*G3*J3)
Exercise 3: 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 26 This eclectic load is used for designing the electric circuits of lamps Total electric demand of the lighting system Total number of lighting fixtures
Guidelines of Conducting BOQ The followings are some guidelines of using Excel in the bill of quantities of a building project: 1. Obtain the building drawing in DWG format (if the project wasn’t designed with the help of Revit) 2. Make at least five sheets for your project elements within the Excel file that you will use for the BOQ, (e.g. Substructure. Structure, Block Wall, Finishes, Openings, etc.), to avoid any error during the preparation of the BOQ of the different systems and materials in the project. 3. In each sheet, it is better to establish two tables, one for the quantities and one for the pricing, as shown in the upcoming slides. 4. The calculation of the quantity as well as the price are shown in the upcoming slides. 5. The development of final sheet that summarize the total price of each type of works )items) is highly recommended. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 27
5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 28 =(G12*H12*I12)*(F12) =SUM(J12:J21)
5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 29 =(F58*H58) =SUM(J58:J67)
5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 30
 Microsoft excel has countless of applications in the architectural engineering field.  The effective use of the software is based on the understanding of the software basics, plus the continues practice as well as the self improvements at using the software.  Accordingly, this course has gave you some knowledge and skills of using the software.  For any help, don't hesitate to contact me, and you are welcome in any time. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 31 6. Summary:
King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 32

More Related Content

PDF
NCEES_Credential Evaluations
byIbrahim Shalaby, PMP, FE, LEED AP BDC
 
PDF
Testing and verification of software model through formal semantics a systema...
byeSAT Publishing House
 
PPTX
MySQL Database with phpMyAdmin
byKarwan Mustafa Kareem
 
PDF
Rit dubai bachelor mechanical engeering
byRit Dubai
 
PPTX
Mvn lf e&c engineering
byLFMVNIET
 
PDF
HomeAlone Project
byKanishk Srivastava
 
DOCX
cv (1)
byHafeez Niazi
 
PPTX
DT-G3-T1-W8-L3-Excel Extended .pptx
byshelmi1
 
NCEES_Credential Evaluations
byIbrahim Shalaby, PMP, FE, LEED AP BDC
 
Testing and verification of software model through formal semantics a systema...
byeSAT Publishing House
 
MySQL Database with phpMyAdmin
byKarwan Mustafa Kareem
 
Rit dubai bachelor mechanical engeering
byRit Dubai
 
Mvn lf e&c engineering
byLFMVNIET
 
HomeAlone Project
byKanishk Srivastava
 
cv (1)
byHafeez Niazi
 
DT-G3-T1-W8-L3-Excel Extended .pptx
byshelmi1
 

More from Mohammad B. Hamida

PDF
Research methods (A short lecture was given on December 5, 2024))
byMohammad B. Hamida
 
PDF
Writing a Coherent, Inviting, and Structured Introduction
byMohammad B. Hamida
 
PDF
Laying the Groundwork for a Robust Research Design
byMohammad B. Hamida
 
PDF
Literature review (2-October 2024 by Mohammad Hamida and Brian van Laar)
byMohammad B. Hamida
 
PDF
Defining and Designing a Coherent Case Study Protocol
byMohammad B. Hamida
 
PDF
Re-design of complex projects - lecture by MBH 20-02-2024 .pdf
byMohammad B. Hamida
 
PDF
Autodesk Revit 2019
byMohammad B. Hamida
 
PDF
REPORT OF ARFA'S PROJECT
byMohammad B. Hamida
 
PDF
HP0076
byMohammad B. Hamida
 
PDF
HP0017
byMohammad B. Hamida
 
Research methods (A short lecture was given on December 5, 2024))
byMohammad B. Hamida
 
Writing a Coherent, Inviting, and Structured Introduction
byMohammad B. Hamida
 
Laying the Groundwork for a Robust Research Design
byMohammad B. Hamida
 
Literature review (2-October 2024 by Mohammad Hamida and Brian van Laar)
byMohammad B. Hamida
 
Defining and Designing a Coherent Case Study Protocol
byMohammad B. Hamida
 
Re-design of complex projects - lecture by MBH 20-02-2024 .pdf
byMohammad B. Hamida
 
Autodesk Revit 2019
byMohammad B. Hamida
 
REPORT OF ARFA'S PROJECT
byMohammad B. Hamida
 
HP0076
byMohammad B. Hamida
 
HP0017
byMohammad B. Hamida
 

Recently uploaded

PPTX
TRANSPORTATION ENGINEERING Unit-5.2.pptx
byMood Naik
 
PPTX
Permit to work training ppt provide short
byvickysharma78117
 
PDF
detail detail canopy - project canopy1 Civil Engineering Spreadsheets - Premi...
byICEDAHum
 
PPTX
Green and Black Modern Pitch Deck Presentation.pptx
byu2yash24
 
PDF
k-means algorithm with numerical solution.pdf
bydeepalishinkar1
 
PDF
MODULE III Networking and the Internet.pdf
bychintumali5599
 
PPT
Apresentação de slides para sala de aulas
byjeansbs1
 
PPTX
K-nearest neighbouring machine learing algorithm .pptx
bydeepalishinkar1
 
PPTX
Automation Testing and New Ways to test Software using AI
byswapnilnarayan1
 
PPTX
WPS.....................................
bywikan14
 
PPTX
Control Structures and Looping Basics Understanding Control Flow and Loops Co...
bySiamSharifAmi
 
PPT
Pump Selection and Process Sizing _PROTEC Dept. April 2014_draft 6.ppt
byashekongbesh
 
PPTX
Washing-Machine-Simulation-using-PICSimLab.pptx
byhelppolytechnic24
 
PPTX
Generative AI Deep Dive: Architectures, Mechanics, and Future Applications
bygenz9514
 
PPTX
Computer engineering for collage studen. pptx
byestradageric
 
PPTX
Push pop Unit 1 CEC369 IoT P CEC369 IoT P
byKesavRaj8
 
PDF
AIS_CH_03_7e4ad9efe21bc32fe03a23587d2a6ab2.pdf
byQutaybaMehdawy
 
PPTX
Concrete Technology- Segregation and bleeding (CE205).pptx
byabanitripura08
 
PDF
IPE 105 - Engineering Materials Constitution of Alloys
byMominulIslam67
 
PDF
ELECTRONIC DEVICES AND MICROPROCESSOR(24EC307)-KONGUNADU COLLEGE OF ENGINEERI...
bySaranyaShanmugam28
 
TRANSPORTATION ENGINEERING Unit-5.2.pptx
byMood Naik
 
Permit to work training ppt provide short
byvickysharma78117
 
detail detail canopy - project canopy1 Civil Engineering Spreadsheets - Premi...
byICEDAHum
 
Green and Black Modern Pitch Deck Presentation.pptx
byu2yash24
 
k-means algorithm with numerical solution.pdf
bydeepalishinkar1
 
MODULE III Networking and the Internet.pdf
bychintumali5599
 
Apresentação de slides para sala de aulas
byjeansbs1
 
K-nearest neighbouring machine learing algorithm .pptx
bydeepalishinkar1
 
Automation Testing and New Ways to test Software using AI
byswapnilnarayan1
 
WPS.....................................
bywikan14
 
Control Structures and Looping Basics Understanding Control Flow and Loops Co...
bySiamSharifAmi
 
Pump Selection and Process Sizing _PROTEC Dept. April 2014_draft 6.ppt
byashekongbesh
 
Washing-Machine-Simulation-using-PICSimLab.pptx
byhelppolytechnic24
 
Generative AI Deep Dive: Architectures, Mechanics, and Future Applications
bygenz9514
 
Computer engineering for collage studen. pptx
byestradageric
 
Push pop Unit 1 CEC369 IoT P CEC369 IoT P
byKesavRaj8
 
AIS_CH_03_7e4ad9efe21bc32fe03a23587d2a6ab2.pdf
byQutaybaMehdawy
 
Concrete Technology- Segregation and bleeding (CE205).pptx
byabanitripura08
 
IPE 105 - Engineering Materials Constitution of Alloys
byMominulIslam67
 
ELECTRONIC DEVICES AND MICROPROCESSOR(24EC307)-KONGUNADU COLLEGE OF ENGINEERI...
bySaranyaShanmugam28
 

Microsoft Excel: Applications of the Software in the Architectural Engineering Domain

  • 1.
    February 4, 2019 By MohammadB. Hamida Slide # 1 King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬
  • 2.
    1. Introduction  Overviewof Microsoft Excel  History of the Development of Spreadsheet Applications/Software  Software interface 2. Applications of the software in the ARE domain 3. Rules of basic calculations in Excel  Cell type  Principles of entering equation 4. The systematic procedure for sheet programing 5. Exercises  Exercise 1: Calculating the relative difference  Exercise 2: Analyzing the space efficiency of the architectural design  Exercise 3: Preliminary Designing of the Lighting System  Guidelines of Conducting BOQ 6. Summary CONTENTS King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 2
  • 3.
     Microsoft Excelis a basic application software offering the spreadsheet service to the end user.  It enables the end user to organize, analyze, and graph numeric data, as well as conduct advanced-mathematical and statistical calculations for such kind of data.  Visual Basic is the macro programming language of Microsoft Excel, which is one of the old and common programming languages in the IT sector. 1. Introduction: Overview of Microsoft Excel CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 3
  • 4.
     VisiCalc wasthe first computer spreadsheet program, which was released for Apple II (computers), in 1978.  Microsoft originally marketed a spreadsheet program called “Multiplan” in 1982, which was menially Control Program for Microcomputers.  On September 30, 1985, Microsoft released the first version of Excel for the Macintosh.  In November 1987, Microsoft released the first Windows version.  After the first Windows version of Excel in 1987, the growth of developing and using the software have been rapidly increased, due to software's capabilities and features at enhancing the performance of different professions. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 4 1. Introduction: History of the Development of Spreadsheet Applications/Software
  • 5.
    CONTENTS 1. Introduction 2. Applicationsof the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 5 1. Introduction: History of the Development of Spreadsheet Applications/Software
  • 6.
     The followingdiagram illustrates the interface of Microsoft Excel. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 6 1. Introduction: Software interface Quick Access Title Bar Menu Bar Tool Bar Formula (Equation) Bar Rows Columns Sheet tabs
  • 7.
     In thearchitectural engineering field, Microsoft Excel is one of the valuable tools that offer endless of applications for professionals of this domain, such as:  Tabulation of the architectural program of the building.  Estimation of the number of building users/occupants.  Estimation of the maximum demand load of water, electricity and cooling.  Design the MEP systems (mechanical, electrical and plumbing systems).  Design the structural system.  Estimation of the cost of the building during the design intention and development phases.  and others…. 2. Applications of the software in the ARE domain CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 7
  • 8.
     The followingsare major rules that should be comprehended as well as kept in mind when an end user is using the software: 1. Cell type  Cell type is one of the key concerns that should be kept in mind when the end user is conducting calculation and/or numeric analysis.  Cell type is one of the followings: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special and costume cells.  Therefore, user can select the type of the cell according to his data through identifying a cell/set of cells, then right click on and select “Format Cells”.  Through this tab, the user can select the appropriate type for him. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 8 3. Rules of basic calculations in Excel
  • 9.
    CONTENTS 1. Introduction 2. Applicationsof the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 9 3. Rules of basic calculations in Excel
  • 10.
    2. Principles ofentering equation  Each equation shall be started with the equal sign (=).  Addition and subtraction processes are performed by entering their normal signs (+ or -).  Multiplication (product) process is performed by entering star sign (*).  Division is performed by entering slash sign (/).  Exponent is performed by entering caret sign (^), which can be written by Click SHIFT6 simultaneously in the keyboard.  The formula system in Excel is based on Algebra basics, which identify the priority of each calculation process.  These basics are known as PEMDAS, (Parenthesis | Exponents | Multiplication | Division | Addition | Subtraction).  PEMDAS can be remined by link it to the saying “Please Excuse my Dear Aunt Sally“ ☺ ☺ ☺.  Separation between numerator and denominator in any polynomial fraction shall be made by closing each part with parentheses. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 10 3. Rules of basic calculations in Excel
  • 11.
    4. The systematicprocedure for sheet programing CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 11  The following flowchart was developed by the course presenter, to show a systematic procedure that facilitate the programing process to Excel users: Specify determinant(s) that you would like to calculate Identify the equation used to calculate the determinant(s) Prepare the sheet layout and its cells to calculate the determinant in a right manner Enter the parameters of the equation in the right cells Enter the equation once in the first cell (if applies) Check the validity of the equation by compare it with a manual calculation of the same values Apply the equation to the rest cells in the same column by dragging it to the rest cells (if this applies) Continue if its valid Backifitsnotvalid
  • 12.
    Exercise 1: Supposethat you are working in a study pertaining to the assessment of the impact of design/operation alternatives (e.g. wall, roof, openings or operation settings) on the energy performance of a building, using any energy simulation program as a tool to predict the energy consumption. Generally, the relative difference (percentage change) is the method used to indicate and compare the differences of the software outputs. Thus, the table shown in the next slide presents results of the energy simulation obtained from the software. Calculate the relative difference between the base scenario and the alternative in a monthly base as well as annual base, using the equation below. Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 12
  • 13.
    Exercise 1: 5. Exercises CONTENTS 1.Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 13 MONTH MONTHLY ENERGY CONSUMPTION (Kwh) JANUARY 157,802 FEBRUARY 137,902 MARCH 226,202 APRIL 232,802 MAY 304,802 JUNE 313,802 JULY 285,602 AUGUST 345,602 SEPTEMBER 329,402 OCTOBER 238,082 NOVEMBER 226,922 DECEMBER 178,802 Total 2,977,724 Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100
  • 14.
    Exercise 1: The exercisecan be solved as follows: Step 1: Specify a column for calculating relative difference, with a cell type of “percentage”., (done by the presenter). Step 2: Ener the equation in the first cell of the column as shown in the figure below once. Step 3: Drag the first cell of the column which you have entered the equation in to the rest rows. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 14 Relative difference = 𝑁𝑒𝑤 𝑉𝑎𝑙𝑢𝑒 −𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 𝑂𝑙𝑑 𝑉𝑙𝑢𝑒 × 100 =(C2-B2)/C2
  • 15.
    Exercise 2: Supposethat you are working in designing a house for a middle-income client in Saudi Arabia, so that the client concerns with using each square meter in his house in an effective manner. On the other side, you (as a designer) concern with developing a design that meets the client needs as well as the regulatory requirements. In this regard, you need to show and justify your design solutions to the client. One of the methods that are used for this purpose are the calculation of the space ratio for each space in the building. Further, the ratio between usable space to the non-usable space (circulation) in a building is one of the indicators of the space efficiency of the building. Calculate the space ratio of each space of the floor plan attached in the next slide, and then determine the space efficiency of the building, using the equations below. Percatage = 𝑃𝑎𝑟𝑡 𝑊ℎ𝑜𝑙𝑒 × 100 space efficiency = 𝐴𝑟𝑒𝑎 𝑜𝑓 𝑢𝑠𝑎𝑏𝑙𝑒 𝑠𝑝𝑎𝑐𝑒 𝑇𝑜𝑡𝑎𝑙 𝑎𝑟𝑒𝑎 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 15
  • 16.
    King Fahd Universityof Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 16 5. Exercises
  • 17.
    Exercise 2: Part 1:Calculate the space ratio (Percentage) of each space Step 1: Develop a table including three columns for the name, area and percentage of each space respectively (done by the presenter). Step 2: Enter name and area for each space (done by the presenter). Step 3: Adjust the cell type of the last column, to be “percentage”. Step 4: Calculate the sum of the areas of all rooms as shown in the next slide Step 5: Ener the equation in the first cell of the column as shown in the figure next slide once. Step 6: Drag the first cell of the column which you have entered the equation in to the rest rows Percatage = 𝑃𝑎𝑟𝑡 𝑊ℎ𝑜𝑙𝑒 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 17
  • 18.
    Exercise 2: Part 1:Calculate the space ratio 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 18 =B2/B$18 =SUM(B2:B17) Using ($) before the cell number is required in this case for fixing the cell of the sum of rooms areas You can do this by highlighting all the cells of the area column, and then click “Auto sum” from the editing tab
  • 19.
    Exercise 2: Part 2:Calculate the space efficiency of the building Step 1: Develop a table including three columns for the space category, area and percentage of each space respectively (done by the presenter). Step 2: Enter name and area for category of space (done by the presenter). Step 3: Calculate the usable space by taking the sum of the areas of all rooms, except the circulation spaces as shown in the next slide. Step 4: Calculate the non-usable space by taking the sum of the areas of all circulation spaces as shown in the next slide Step 5: Take the sum of the areas of the usable and non-usable space. Step 6: Highlight the all the cells of the area column, including the total, and then drag it to the right. Step 3: Adjust the cell type of the last column, to be “percentage”. space efficiency = 𝐴𝑟𝑒𝑎 𝑜𝑓 𝑢𝑠𝑎𝑏𝑙𝑒 𝑠𝑝𝑎𝑐𝑒 𝑇𝑜𝑡𝑎𝑙 𝑎𝑟𝑒𝑎 × 100 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 19
  • 20.
    King Fahd Universityof Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 20 5. Exercises Building boundaries Usable Space Non-usable Space
  • 21.
    Exercise 2: Part 2:Calculate the space efficiency of the building 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 21 =SUM(B2:B12) =SUM(B13:B17) =SUM(B22:B23) Space efficiency
  • 22.
    King Fahd Universityof Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 22 5. Exercises Building boundaries Usable Space Non-usable Space Space efficiency = 81.6%
  • 23.
    Exercise 3: Supposethat the owner of the previous example would ask you to develop a preliminary design of the lighting systems of his house, using the T8 - 36 Watt (a type of florescent tub lamps) for all rooms. Calculate the number of lighting fixtures required per each room according to the recommended lighting level (Illuminance), assuming 300 lux for all spaces. Then, calculate the electric load of the lighting in each space. N = 𝐸 ×𝐴 𝑛×ᴓ ×𝐶.𝐹×𝐿.𝐿.𝐹 Where: N: is number of lighting fixtures required in a given space E: is the recommended lighting level “Illuminance” (in lux) A: Space Area (in 𝑚2 ) 𝑛: is number of lamps per a fixture ᴓ: is the luminous (in FLUX) C.F: is the utilization factor L.L.F: is the lighting loss factor 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 23 From design code/standard From the product feature From the product properties (value between 0.4 to 0.65) value between 0.75 to 0.8
  • 24.
    Exercise 3: The exercisecan be solved as follows: Step 1: Develop a table in new sheet including 12 columns for the space name, area, Lighting Level, Luminous, Utilization Factor, Lighting Loss Factor, Number of Lamps Per Unit, Number of Unite and Unit Wattage (Electric load) (done by the presenter). Step 2: Transfer the room names and their areas values from the previous sheet, by enter equal equation (=) to the first cell of each columns and drag it to the rest cells. Step 3: Enter the values of the equation parameters (done by the presenter). Step 4: Enter the equation of the required number of lighting fixtures as shown in the next slide. Step 5: Based on the determined value, decide if you would like to increase the number or not for each. Step 6: Enter the equation of determining the eclectic load of the space in the first cell, and then drag it to other cells as shown in the next slide. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 24
  • 25.
    Exercise 3: 5. Exercises CONTENTS 1.Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 25 ='2. Architectural information'!A2) ='2. Architectural information'!B2 =(B3*C3)/(D3*E3*F3*G3) =(I3*G3*J3)
  • 26.
    Exercise 3: 5. Exercises CONTENTS 1.Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 26 This eclectic load is used for designing the electric circuits of lamps Total electric demand of the lighting system Total number of lighting fixtures
  • 27.
    Guidelines of ConductingBOQ The followings are some guidelines of using Excel in the bill of quantities of a building project: 1. Obtain the building drawing in DWG format (if the project wasn’t designed with the help of Revit) 2. Make at least five sheets for your project elements within the Excel file that you will use for the BOQ, (e.g. Substructure. Structure, Block Wall, Finishes, Openings, etc.), to avoid any error during the preparation of the BOQ of the different systems and materials in the project. 3. In each sheet, it is better to establish two tables, one for the quantities and one for the pricing, as shown in the upcoming slides. 4. The calculation of the quantity as well as the price are shown in the upcoming slides. 5. The development of final sheet that summarize the total price of each type of works )items) is highly recommended. 5. Exercises CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 27
  • 28.
    5. Exercises CONTENTS 1. Introduction 2.Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 28 =(G12*H12*I12)*(F12) =SUM(J12:J21)
  • 29.
    5. Exercises CONTENTS 1. Introduction 2.Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 29 =(F58*H58) =SUM(J58:J67)
  • 30.
    5. Exercises CONTENTS 1. Introduction 2.Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 30
  • 31.
     Microsoft excelhas countless of applications in the architectural engineering field.  The effective use of the software is based on the understanding of the software basics, plus the continues practice as well as the self improvements at using the software.  Accordingly, this course has gave you some knowledge and skills of using the software.  For any help, don't hesitate to contact me, and you are welcome in any time. CONTENTS 1. Introduction 2. Applications of the Software in the ARE domain 3. Rules of basic calculations in Excel 4. The systematic procedure for programing a sheet 5. Exercises 6. Summary King Fahd University of Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 31 6. Summary:
  • 32.
    King Fahd Universityof Petroleum & Minerals College of Environmental Design Architectural Engineering Department ‫والمعادن‬ ‫للبترول‬ ‫فهد‬ ‫الملك‬ ‫جامعة‬ ‫البيئة‬ ‫تصاميم‬ ‫كلية‬ ‫المعمارية‬ ‫الهندسة‬ ‫قسم‬ By Mohammad B. Hamida Slide # 32