Advanced Excel for Surveyors

1. Auflage 2003
ISBN: 978-0-7282-0413-3
Verlag: Taylor & Francis Ltd

Buch, Englisch, 128 Seiten, Format (B × H): 235 mm x 158 mm, Gewicht: 202 g

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.

Zielgruppe

Professional Practice & Development

Autoren/Hrsg.

Bowcock, Philip

Bayfield, Natalie

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation Microsoft Excel
• Technische Wissenschaften Bauingenieurwesen Vermessungswesen

Inhaltsverzeichnis

Foreword, Preface, 1 Introduction, 2 Some of the new features in Excel, 3 Managing large worksheet models and good practice, 4 Databases, 5 Sharing workbooks, 6 Maps, 7 Protecting your workbook and setting passwords, 8 Visual Basic, 9 Regression analysis, 10 Linear programming, 11 Simulation, 12 Portfolio management, Appendix A Bibliography, Appendix B Add-Ins, Appendix C A note on Excel for Macintosh

Über Autor(innen)

Philip Bowcock, Natalie Bayfield