{"product_id":"insaat-muhendisleri-icin-excel-uygulamalari_351732-html","title":"Excel Applications for Civil Engineers","description":"\u003cp\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eFOREWORD\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eToday, Spreadsheet software has become one of the most important elements of computer usage. Especially for personal computer users, it can be said that the most popular programs are Spreadsheet software. Since these software are \"General Purpose,\" they provide a wide range of uses, from \"Economic Analyses\" to \"Matrix Calculations,\" and thus, they are increasingly becoming an indispensable aid for all employees, from managers to technical staff and researchers.\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eSuch software has been developed for organizing and using numerical and\/or alphanumeric information in tabular form, allowing for all kinds of algebraic relationships between the cells of the table. The ability to easily copy and paste relevant formulas into other cells and to make desired changes in the table at any time has also been provided. Thus, a general-purpose model related to the problem at hand is developed and can be saved for application to similar problems in the future. In the 3rd generation Spreadsheet software widely used today, extensive features such as formatting, adding and deleting columns or rows, using conditional formulas (IF), communication with other tables and different types of files (Text, Word, etc.), graphical display, sorting, and querying are provided.\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eThus, personal computer users can effectively use computers without needing extensive programming knowledge and sometimes achieve results that even professional programmers would be proud of. The impact of changes made to one or more data in the prepared table on the results can be observed instantly (graphically, if desired). This provides managers and technical staff, in particular, with the widest possible opportunity to compare various options (What If).\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eSCIENTIFIC AND TECHNICAL APPLICATIONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eAs their names suggest, Spreadsheet Software can be used in all kinds of applications that can be organized in a tabular format. In all engineering fields, tabular calculation schemes (models) have been widely used in various applications, from \"Price Analysis\" to \"Moment of Inertia Calculation.\" Spreadsheets can be used in all these applications, and thus, they are increasingly becoming indispensable aids for engineers. The use of Spreadsheet software by engineers initially involved topics such as Timesheets, Payroll, Economic Analyses, etc. Later, its use began and became widespread, especially in areas such as Price Analysis, Discovery, Quantity Survey, Progress Payments, Work Programs, Resource Allocation, and Cash Flow. Thus, both technical staff and managers have been freed from dependence on software that needs to be specially developed or provided (or on professional programmers) for various issues, and they have gained the opportunity to easily obtain quick and reliable results, along with their options, on all matters.\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003eAs is known, in both engineering and scientific research, numerical results are obtained using tabular calculation schemes in many applications, from solutions involving trigonometric or exponential functions to matrix methods.\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCONTENTS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eINTRODUCTION\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSCIENTIFIC AND TECHNICAL APPLICATIONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eEXCEL 2000 SCREEN\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eMENUS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eTOOLBARS AND BUTTONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCELLS AND THEIR CONTENTS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eFUNCTIONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eMATRIX (ARRAY) FORMULAS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eFORMATTING\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eBASIC OPERATIONS: SELECTING, COPYING, PASTING\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eRELATIVE ADDRESS, ABSOLUTE ADDRESS AND NAMING\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eADDING AND DELETING ROWS AND COLUMNS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eITERATIVE APPROACH AND VARIOUS APPLICATION METHODS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCONDITIONAL FUNCTIONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCREATING AND EDITING CHARTS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eDATABASE OPERATIONS\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eEXAMPLE\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSection Forces of a Cantilever Beam\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCalculation of the Natural Period of a Multi-Story Building\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCalculation of the Natural Period of a Chimney\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSeismic Load Calculation (1)\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eMoment of Inertia Calculation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eRound Bar Area Table\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eArea Calculation using the Cross Method\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eBeam on Elastic Foundation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003ePreparation of Helical Stair Data for SAP 2000\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eVolume Calculation of a Horizontal Cylindrical Tank\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eHeight Calculation of a Horizontal Cylindrical Tank\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eDimensions of an Isolated Foundation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eReinforcement Calculation for a Rectangular Section\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eReinforcement Calculation for a Hexagonal Section\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSecond-Order Calculation for a Cantilever Beam\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eBuckling Load Calculation for a Cantilever Beam\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSolution of a First-Order Differential Equation Solution of the Equation of Motion with Linear Acceleration Method\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eTorsional Moment of Inertia Calculation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSolution of a System of Linear Equations\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eNatural Angular Frequency Calculation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eLine Fitting\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eCurve Fitting\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSeismic Load Calculation (2)\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eBid Evaluation\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSuperposition in Truss Beams\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eReinforced Concrete Rebar Quantity Survey\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eReinforcement Calculation for a Doubly Reinforced Rectangular Section\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eInteraction Diagram\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eSizing of Truss Members\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003eTruss Quantity Survey\u003c\/span\u003e\u003cbr style=\"color: rgb(69, 69, 69); font-family: \" source sans pro sans-serif\u003e\u003cspan\u003ePersonnel Database\u003c\/span\u003e\u003cbr\u003e\u003c\/p\u003e","brand":"Birsen Yayınevi","offers":[{"title":"Default Title","offer_id":39409057235139,"sku":"9789755112893","price":1260.0,"currency_code":"TRY","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0523\/3950\/7395\/products\/9789755112893.jpg?v=1616018510","url":"https:\/\/yemkitabevi.com\/en-us\/products\/insaat-muhendisleri-icin-excel-uygulamalari_351732-html","provider":"YEM Kitabevi","version":"1.0","type":"link"}