Advanced Excel for Surveyors

by Philip Bowcock, Natalie Bayfield

Overview

Advanced Excel for Surveyors is the companion to the highly successful Excel for Surveyors. This volume is intended to help both students and practitioners use Mircosoft Excel™ to solve some of the more complex problems that the surveyor may come across.

It explores how Visual Basic and macros can simplify and speed up repetitive tasks, fulfilling one of the basic aims of computing: “If it is repetitive teach the machine to do this for you”. The methodology of portfolio analysis is a relatively new discipline, which may be unfamiliar to many readers. The book provides an introduction to the principles and shows how Excel can help, readers may even find this of help when assessing their own personal investment portfolios. Further ideas for setting up databases; how to arrange for several surveyors to work on a single project; data analysis; and the use of charts in Reports are discussed together with further advice on security and protection.

Product Details

ISBN-13:	9781135322779
Publisher:	CRC Press
Publication date:	05/22/2014
Sold by:	Barnes & Noble
Format:	eBook
Pages:	128
File size:	5 MB

About the Author

Philip Bowcock, Natalie Bayfield

Table of Contents

Chapter 1 Introduction; Chapter 2 Some of the new features in Excel; Chapter 3 Managing large worksheet models and good practice; Chapter 4 Databases; Chapter 5 Sharing workbooks; Chapter 6 Maps; Chapter 7 Protecting your workbook and setting passwords; Chapter 8 Visual Basic; Chapter 9 Regression analysis; Chapter 10 Linear programming; Chapter 11 Simulation; Chapter 12 Portfolio management;