Preface |
|
xvii | |
Author |
|
xix | |
Section I: Foundations |
|
|
1 Fundamental Computing Concepts |
|
|
3 | (10) |
|
1.1 Computer Operating Systems |
|
|
3 | (1) |
|
1.2 Brief History of Operating Systems |
|
|
4 | (1) |
|
1.3 Types of Operating Systems |
|
|
5 | (1) |
|
1.4 Major Operating System Responsibilities |
|
|
6 | (2) |
|
|
7 | (1) |
|
|
7 | (1) |
|
|
7 | (1) |
|
|
7 | (1) |
|
|
8 | (1) |
|
1.5 Computer Resources and File Systems |
|
|
8 | (3) |
|
|
8 | (1) |
|
|
8 | (7) |
|
1.5.2.1 File Attributes or Properties |
|
|
9 | (1) |
|
|
9 | (1) |
|
1.5.2.3 File Types and Naming |
|
|
10 | (1) |
|
1.5.2.4 Directory Structure |
|
|
10 | (1) |
|
|
11 | (1) |
|
|
11 | (2) |
|
2 Programming Languages and Software Engineering |
|
|
13 | (14) |
|
2.1 Programming Languages |
|
|
13 | (2) |
|
2.2 Object-Oriented Programming |
|
|
15 | (2) |
|
|
16 | (1) |
|
|
16 | (1) |
|
|
17 | (3) |
|
2.4 Example of Forest Harvesting Simulator Design |
|
|
20 | (3) |
|
|
20 | (1) |
|
2.4.2 Functional Requirements |
|
|
21 | (6) |
|
2.4.2.1 Specification Document |
|
|
22 | (1) |
|
|
23 | (1) |
|
|
23 | (4) |
Section II: Data Manipulation and Analysis |
|
|
3 Elementary Data Manipulation Using Excel |
|
|
27 | (26) |
|
|
27 | (5) |
|
3.1.1 Operators in Formulas |
|
|
28 | (1) |
|
|
28 | (1) |
|
3.1.3 Referencing Cells Outside the Worksheet |
|
|
29 | (1) |
|
3.1.4 Relative versus Absolute References |
|
|
29 | (3) |
|
3.1.4.1 Relative Reference |
|
|
30 | (1) |
|
3.1.4.2 Absolute Reference |
|
|
31 | (1) |
|
|
32 | (2) |
|
|
33 | (1) |
|
|
33 | (1) |
|
3.3 Major Excel Functions |
|
|
34 | (7) |
|
3.3.1 Mathematical and Trigonometric Functions |
|
|
35 | (2) |
|
|
35 | (1) |
|
|
35 | (1) |
|
|
36 | (1) |
|
|
36 | (1) |
|
|
36 | (1) |
|
|
37 | (1) |
|
|
37 | (1) |
|
3.3.2 Statistical Functions |
|
|
37 | (2) |
|
3.3.2.1 AVERAGE, MEDIAN, and MODE |
|
|
37 | (1) |
|
|
38 | (1) |
|
|
38 | (1) |
|
|
38 | (1) |
|
|
38 | (1) |
|
|
39 | (1) |
|
|
39 | (1) |
|
|
39 | (1) |
|
|
39 | (1) |
|
3.3.3.4 REPLACE and SUBSTITUTE |
|
|
39 | (1) |
|
3.3.3.5 UPPER, LOWER, and PROPER |
|
|
40 | (1) |
|
|
40 | (1) |
|
|
40 | (2) |
|
|
40 | (1) |
|
3.4 Build Your Own Functions |
|
|
41 | (1) |
|
|
42 | (7) |
|
3.5.1 Excel Chart Example |
|
|
42 | (3) |
|
|
45 | (1) |
|
|
46 | (3) |
|
|
49 | (3) |
|
|
52 | (1) |
|
4 Statistical Analysis and Mathematical Programming Using Excel |
|
|
53 | (30) |
|
4.1 Data Analysis with Analysis ToolPak |
|
|
53 | (9) |
|
|
53 | (1) |
|
|
54 | (4) |
|
|
58 | (4) |
|
4.2 Mathematical Programming in Forest Management |
|
|
62 | (6) |
|
|
62 | (1) |
|
|
63 | (1) |
|
4.2.3 Multi-Objective Programming |
|
|
64 | (1) |
|
4.2.4 Integer Programming |
|
|
64 | (1) |
|
4.2.5 Dynamic Programming |
|
|
65 | (3) |
|
4.3 Linear Programming Formulation |
|
|
68 | (1) |
|
4.4 Solve Mathematical Models in Forest Management Using Excel Solver |
|
|
69 | (7) |
|
4.4.1 Example of Optimization Problem |
|
|
69 | (4) |
|
4.4.2 Activate Excel Solver |
|
|
73 | (1) |
|
|
73 | (3) |
|
|
76 | (5) |
|
|
81 | (2) |
|
5 Visual Basic for Applications in Microsoft Excel |
|
|
83 | (16) |
|
|
83 | (4) |
|
5.1.1 Visual Basic Editor in Excel |
|
|
83 | (1) |
|
5.1.2 Writing Code in VB Editor |
|
|
84 | (1) |
|
5.1.3 Running Events within Excel |
|
|
85 | (2) |
|
|
87 | (1) |
|
5.2.1 Variables and Data Types |
|
|
87 | (1) |
|
|
87 | (1) |
|
|
88 | (1) |
|
5.3 Harvesting Machine Rate Spreadsheet Program |
|
|
88 | (5) |
|
|
88 | (1) |
|
5.3.2 Example of Machine Rate Program with VBA |
|
|
89 | (10) |
|
|
90 | (1) |
|
|
91 | (2) |
|
5.4 VBA User Forms and Controls |
|
|
93 | (3) |
|
|
96 | (1) |
|
|
96 | (3) |
Section III: Database Management |
|
|
6 Database Concepts and the Entity-Relationship Model |
|
|
99 | (10) |
|
6.1 Fundamental Database Concepts |
|
|
99 | (2) |
|
6.1.1 Database Management System |
|
|
99 | (1) |
|
|
99 | (1) |
|
6.1.3 Table, Record, and Field |
|
|
100 | (1) |
|
|
100 | (1) |
|
6.2 Relational Databases and the Entity-Relationship Model |
|
|
101 | (4) |
|
|
102 | (1) |
|
|
102 | (1) |
|
|
102 | (1) |
|
6.2.4 Types of Relationships |
|
|
103 | (2) |
|
6.3 ER Model Examples in Forest Operations |
|
|
105 | (3) |
|
|
105 | (1) |
|
6.3.2 ER Model for Timber Cruising |
|
|
105 | (1) |
|
6.3.3 ER Model for Time Study of Timber Harvesting |
|
|
106 | (2) |
|
|
108 | (1) |
|
|
108 | (1) |
|
7 Introduction to MS Access |
|
|
109 | (16) |
|
7.1 MS Access Usability and Functionality |
|
|
109 | (2) |
|
7.1.1 MS Access Usability |
|
|
109 | (1) |
|
7.1.2 Major MS Access Functionality |
|
|
110 | (1) |
|
7.1.3 Why Use More than One Table? |
|
|
110 | (1) |
|
7.2 Access Tables and Queries |
|
|
111 | (5) |
|
|
111 | (1) |
|
7.2.2 Relationships between Tables |
|
|
112 | (1) |
|
|
113 | (3) |
|
7.3 Access Forms and Reports |
|
|
116 | (4) |
|
|
116 | (1) |
|
|
117 | (3) |
|
|
120 | (3) |
|
|
123 | (2) |
|
8 Structured Query Language and Access Query Examples |
|
|
125 | (16) |
|
8.1 Structured Query Language |
|
|
125 | (2) |
|
8.1.1 SQL Statements and Clauses |
|
|
125 | (1) |
|
|
125 | (2) |
|
|
127 | (5) |
|
8.2.1 Statements and Clauses |
|
|
127 | (3) |
|
|
130 | (2) |
|
|
132 | (4) |
|
|
136 | (1) |
|
|
137 | (4) |
Section IV: Handheld Devices |
|
|
9 Handheld Computers and Windows Mobile |
|
|
141 | (12) |
|
9.1 Handheld Terms and Features |
|
|
141 | (2) |
|
9.2 Handheld PCs and Windows Mobile |
|
|
143 | (6) |
|
9.2.1 Hewlett-Packard Jornada Series |
|
|
143 | (1) |
|
9.2.2 Zebra Workabout Handheld Field PC |
|
|
143 | (2) |
|
|
145 | (1) |
|
|
146 | (1) |
|
|
146 | (2) |
|
9.2.6 Trimble GeoExplorer 3000 Series Handhelds |
|
|
148 | (1) |
|
9.3 Mobile Operating Systems and Data Communications |
|
|
149 | (1) |
|
9.3.1 Mobile Operating Systems |
|
|
149 | (1) |
|
9.3.2 Data Communications between HPCs and PCs |
|
|
150 | (1) |
|
9.4 Data Storage and Program Execution |
|
|
150 | (2) |
|
9.4.1 Random Access Memory |
|
|
151 | (1) |
|
9.4.2 External PC, CF, and SD Cards |
|
|
151 | (1) |
|
|
151 | (1) |
|
|
152 | (1) |
|
|
152 | (1) |
|
10 Handheld PC Applications: An Integrated Computer-Based Cruising System |
|
|
153 | (12) |
|
|
153 | (2) |
|
|
155 | (2) |
|
10.3 System Implementation |
|
|
157 | (4) |
|
|
157 | (2) |
|
|
159 | (1) |
|
|
159 | (2) |
|
|
161 | (1) |
|
|
162 | (3) |
|
11 Introduction to Geospatial Technology Applications in Forest Management |
|
|
165 | (28) |
|
|
165 | (3) |
|
|
165 | (1) |
|
11.1.2 GPS in Forestry and Natural Resource Management |
|
|
166 | (2) |
|
|
166 | (1) |
|
|
167 | (1) |
|
|
168 | (9) |
|
|
168 | (2) |
|
11.2.2 GIS in Forestry and Natural Resource Management |
|
|
170 | (5) |
|
11.2.3 GIS Software and Data |
|
|
175 | (2) |
|
11.3 Remote Sensing Applications |
|
|
177 | (1) |
|
11.3.1 What Is Remote Sensing? |
|
|
177 | (1) |
|
11.3.2 RS in Forestry and Natural Resource Management |
|
|
177 | (1) |
|
11.4 GIS Mapping and Analysis Examples |
|
|
178 | (7) |
|
11.4.1 Identifying and Mapping Vegetation Phenology |
|
|
178 | (4) |
|
11.4.1.1 Data Preparation |
|
|
179 | (1) |
|
11.4.1.2 Identifying Phenology |
|
|
179 | (3) |
|
11.4.1.3 Mapping the Phenology Using ArcGIS |
|
|
182 | (1) |
|
11.4.2 Mapping and Analyzing Winter CO2 Efflux in a Conifer Forest Area of North America |
|
|
182 | (11) |
|
11.4.2.1 Data Preparation |
|
|
182 | (1) |
|
|
183 | (1) |
|
11.4.2.3 Mapping CO2 Efflux Using ArcGIS |
|
|
184 | (1) |
|
|
185 | (3) |
|
|
188 | (5) |
Section V: Visual Basic .NET Programming |
|
|
12 Introduction to Visual Basic .NET Programming |
|
|
193 | (12) |
|
12.1 What Is Visual Basic? |
|
|
193 | (2) |
|
12.1.1 Visual Basic and VB.NET Concepts |
|
|
194 | (1) |
|
12.1.1.1 Windows, Events, and Messages |
|
|
194 | (1) |
|
12.1.1.2 Procedural Programming |
|
|
194 | (1) |
|
12.1.1.3 Event-Driven Programming |
|
|
194 | (1) |
|
12.1.1.4 Object-Oriented Programming |
|
|
195 | (1) |
|
12.1.2 VB Integrated Development Environment |
|
|
195 | (1) |
|
12.2 VB.NET Programming Examples |
|
|
195 | (8) |
|
|
195 | (1) |
|
12.2.2 Example for Calculating Basal Area of Trees |
|
|
196 | (3) |
|
12.2.2.1 Creating the Interface and Setting Properties |
|
|
197 | (1) |
|
|
198 | (1) |
|
12.2.2.3 Running the Application |
|
|
198 | (1) |
|
12.2.3 Database Connection and Data Display Application |
|
|
199 | (6) |
|
12.2.3.1 Creating the Interface |
|
|
199 | (1) |
|
12.2.3.2 Setting Properties |
|
|
200 | (1) |
|
|
200 | (3) |
|
12.2.3.4 Running the Application |
|
|
203 | (1) |
|
|
203 | (1) |
|
|
203 | (2) |
|
13 VB.NET Controls, Project, and Menu Design |
|
|
205 | (20) |
|
|
205 | (1) |
|
13.2 Using Timer, Option Button, Groupbox, and Checkbox Controls |
|
|
205 | (6) |
|
13.2.1 Creating the Interface and Setting Properties |
|
|
207 | (1) |
|
|
208 | (2) |
|
13.2.3 Running the Application |
|
|
210 | (1) |
|
13.3 Using Drive, Dir, File, Combo, List, Frame Controls |
|
|
211 | (4) |
|
13.3.1 Creating the Interface and Setting Properties |
|
|
211 | (2) |
|
|
213 | (1) |
|
13.3.3 Running the Application |
|
|
214 | (1) |
|
13.4 Working with a Project |
|
|
215 | (1) |
|
|
216 | (1) |
|
13.4.2 User-Defined Class |
|
|
216 | (1) |
|
|
216 | (1) |
|
|
216 | (1) |
|
13.5 Menu Design of VB Project |
|
|
216 | (7) |
|
|
223 | (1) |
|
|
223 | (2) |
|
14 VB.NET Programming Fundamentals |
|
|
225 | (30) |
|
14.1 Variables and Constants |
|
|
225 | (1) |
|
14.1.1 Declaring Variables |
|
|
225 | (1) |
|
14.1.2 Scope of Variables |
|
|
225 | (1) |
|
14.1.3 Private versus Public |
|
|
225 | (1) |
|
|
226 | (1) |
|
|
226 | (1) |
|
|
226 | (2) |
|
|
228 | (1) |
|
|
228 | (1) |
|
14.3.2 Multidimensional Arrays |
|
|
228 | (1) |
|
14.4 Classes and Procedures |
|
|
228 | (6) |
|
|
228 | (3) |
|
|
231 | (1) |
|
14.4.2.1 Event Procedures |
|
|
231 | (1) |
|
14.4.2.2 General Procedures |
|
|
232 | (1) |
|
14.4.3 Function Procedures |
|
|
232 | (1) |
|
|
232 | (2) |
|
14.4.4.1 Passing by Value versus Passing by Reference |
|
|
234 | (1) |
|
|
234 | (2) |
|
14.5.1 Decision Structures |
|
|
235 | (1) |
|
|
235 | (1) |
|
14.6 Input and Output Files |
|
|
236 | (2) |
|
14.6.1 Direct File Access |
|
|
236 | (1) |
|
|
237 | (1) |
|
14.6.3 Opening Files for Sequential Access |
|
|
237 | (1) |
|
|
238 | (4) |
|
|
242 | (6) |
|
|
248 | (5) |
|
|
249 | (4) |
|
|
253 | (1) |
|
|
254 | (1) |
|
15 Programming Application Examples in Forest Resource Management |
|
|
255 | (52) |
|
15.1 Forest Harvesting Simulator |
|
|
255 | (8) |
|
15.1.1 Forest Stand Generation |
|
|
256 | (1) |
|
|
256 | (1) |
|
|
256 | (1) |
|
15.1.1.3 Clustered Pattern |
|
|
256 | (1) |
|
15.1.2 Felling Operations |
|
|
257 | (1) |
|
15.1.2.1 Chainsaw Felling |
|
|
257 | (1) |
|
15.1.2.2 Feller-Buncher Felling |
|
|
257 | (1) |
|
15.1.2.3 Harvester Felling |
|
|
257 | (1) |
|
15.1.3 Extraction Simulation |
|
|
258 | (3) |
|
15.1.3.1 Extraction Patterns |
|
|
258 | (1) |
|
15.1.3.2 Traffic Intensity |
|
|
259 | (2) |
|
15.1.4 Simulation Example |
|
|
261 | (2) |
|
15.2 Timber Cruising and Inventory |
|
|
263 | (9) |
|
15.2.1 Manipulate Field Cruising Data |
|
|
263 | (1) |
|
|
264 | (1) |
|
|
264 | (1) |
|
|
265 | (2) |
|
|
267 | (1) |
|
|
268 | (4) |
|
15.3 VBA for Harvesting System Production and Cost Analysis |
|
|
272 | (6) |
|
|
273 | (1) |
|
15.3.2 System Design and Implementation |
|
|
273 | (3) |
|
15.3.3 Application Example |
|
|
276 | (2) |
|
15.4 3D Log Bucking Optimization |
|
|
278 | (5) |
|
|
278 | (3) |
|
15.4.1.1 System Structure |
|
|
278 | (1) |
|
15.4.1.2 Data Manipulation and Storage |
|
|
278 | (1) |
|
15.4.1.3 3D Stem Modeling |
|
|
278 | (2) |
|
15.4.1.4 Optimal Bucking Algorithm |
|
|
280 | (1) |
|
15.4.2 Bucking System Implementation |
|
|
281 | (2) |
|
15.5 3D Lumber Edging and Trimming System |
|
|
283 | (6) |
|
15.5.1 Data Manipulation and Storage |
|
|
284 | (1) |
|
15.5.2 3D Lumber Modeling |
|
|
284 | (1) |
|
|
285 | (1) |
|
15.5.4 Optimal Edging and Trimming Algorithm |
|
|
285 | (1) |
|
15.5.5 Optimal Edging and Trimming System Implementation |
|
|
286 | (3) |
|
15.6 3D Log Processing Optimization System |
|
|
289 | (6) |
|
15.6.1 System Components and Data Management |
|
|
289 | (2) |
|
15.6.1.1 System Components |
|
|
289 | (2) |
|
15.6.1.2 System Data Management |
|
|
291 | (1) |
|
15.6.2 System Modeling and Algorithms |
|
|
291 | (1) |
|
15.6.2.1 3D Log and Internal Defect Modeling |
|
|
291 | (1) |
|
15.6.2.2 Determining Opening Face |
|
|
292 | (1) |
|
15.6.3 Primary Log Sawing Simulation |
|
|
292 | (3) |
|
15.6.3.1 Heuristic Algorithm |
|
|
292 | (1) |
|
15.6.3.2 Dynamic Programming Algorithm |
|
|
293 | (2) |
|
|
295 | (1) |
|
15.7 Forest and Biomass Harvest Scheduling and Optimization |
|
|
295 | (8) |
|
15.7.1 Forest Inventory Data |
|
|
295 | (1) |
|
15.7.2 Forest Stand Growth Simulation |
|
|
295 | (1) |
|
15.7.3 Harvest Scheduling Model Development |
|
|
296 | (2) |
|
|
298 | (5) |
|
|
303 | (1) |
|
|
303 | (4) |
|
16 Programming for Mobile Devices and Applications in lime Study of limber Harvesting Machines |
|
|
307 | (22) |
|
16.1 Programming for Mobile Devices |
|
|
307 | (3) |
|
16.1.1 iPhone/iPad App Programming |
|
|
307 | (1) |
|
16.1.1.1 Programming Languages |
|
|
307 | (1) |
|
16.1.1.2 iPhone Development Frameworks |
|
|
308 | (1) |
|
16.1.2 Android Programming |
|
|
308 | (1) |
|
16.1.2.1 Android Application Development Framework |
|
|
309 | (1) |
|
|
309 | (1) |
|
16.1.3.1 .NET Compact Framework |
|
|
309 | (1) |
|
16.2 Visual Basic .NET for Windows Mobile |
|
|
310 | (9) |
|
16.2.1 Windows Mobile SDK |
|
|
310 | (1) |
|
|
310 | (1) |
|
16.2.3 Features in VB.NET for Windows Mobile |
|
|
311 | (1) |
|
16.2.4 Programming Examples of VB.NET for Windows Mobile |
|
|
311 | (8) |
|
16.3 VB.NET for Mobile Device Application in Time Study of Timber Harvesting |
|
|
319 | (6) |
|
|
319 | (3) |
|
16.3.2 System Implementation |
|
|
322 | (2) |
|
|
322 | (1) |
|
|
322 | (2) |
|
|
324 | (1) |
|
|
325 | (1) |
|
|
325 | (4) |
Section VI: Web-Based Applications |
|
|
|
329 | (20) |
|
17.1 Terms and HTML Files |
|
|
329 | (1) |
|
|
330 | (2) |
|
17.3 Applications of HTML Tags |
|
|
332 | (15) |
|
|
333 | (1) |
|
|
333 | (1) |
|
|
333 | (1) |
|
|
333 | (1) |
|
|
333 | (1) |
|
|
334 | (2) |
|
|
336 | (1) |
|
17.3.8 Forced Line Breaks |
|
|
337 | (1) |
|
|
338 | (3) |
|
|
341 | (6) |
|
|
347 | (1) |
|
|
347 | (2) |
|
18 Introduction to ASP.NET |
|
|
349 | (10) |
|
|
349 | (4) |
|
18.2 Basic ASP.NET Techniques |
|
|
353 | (5) |
|
18.2.1 Request and Response |
|
|
353 | (3) |
|
|
356 | (2) |
|
|
358 | (1) |
|
|
358 | (1) |
|
19 ASP/ASP.NET Applications |
|
|
359 | (14) |
|
19.1 Web-Based Data Entry and Retrieval System for Forest Health Protection |
|
|
359 | (1) |
|
19.2 Online Timber Cruising System |
|
|
360 | (5) |
|
|
363 | (1) |
|
|
363 | (2) |
|
|
365 | (1) |
|
19.3 Web-Based DSS for Analyzing Biomass and Timber Harvesting Costs and Productivity |
|
|
365 | (7) |
|
|
367 | (1) |
|
|
367 | (2) |
|
19.3.2.1 General Information |
|
|
367 | (1) |
|
|
368 | (1) |
|
19.3.2.3 Machine Productivity |
|
|
368 | (1) |
|
|
368 | (1) |
|
|
369 | (1) |
|
19.3.3 Machine Rate Program Page and Summary Page |
|
|
369 | (3) |
|
|
370 | (2) |
|
|
372 | (1) |
|
|
372 | (1) |
|
|
372 | (1) |
Index |
|
373 | |