Title: Water Resources Analysis Using Electronic Spreadsheets, Figure 1: Lotus Map of the Cypress Creek Basin
CITATION THUMBNAILS PAGE IMAGE ZOOMABLE
Full Citation
STANDARD VIEW MARC VIEW
Permanent Link: http://ufdc.ufl.edu/WL00000691/00001
 Material Information
Title: Water Resources Analysis Using Electronic Spreadsheets, Figure 1: Lotus Map of the Cypress Creek Basin
Physical Description: Photograph
Language: English
 Subjects
Spatial Coverage: North America -- United States of America -- Florida
 Notes
Abstract: Water Resources Analysis Using Electronic Spreadsheets, Figure 1: Lotus Map of the Cypress Creek Basin
General Note: Box 7, Folder 1 ( Vail Conference 1987 - 1987 ), Item 84
Funding: Digitized by the Legal Technology Institute in the Levin College of Law at the University of Florida.
 Record Information
Bibliographic ID: WL00000691
Volume ID: VID00001
Source Institution: Levin College of Law, University of Florida
Holding Location: Levin College of Law, University of Florida
Rights Management: All rights reserved by the source institution and holding location.

Full Text

















































0 2 4 8 8 10


+ Gage site


Figure 1.


12 14 18


MILBS
* Basin boundary


Lotus Map of the Cypress Creek Basin, Using
Graph Command with Vertical and Horizontal
Gridding.


4
-. 05-


*

*

*

+ T. 10

*

0 0



CY RES *
*

+ RESE* *

*

*

*

*










these crude but quite useful maps were constructed for each

parameter file. By creating a list of X and Y coordinates (Table

1) on the spreadsheet, any number of Z attributes may be

assigned. In the case of Table 1, which contains a sample of the

data used to create the raingage map, a 16 by 16 matrix was

formed by entering a series of coordinates (X= .5 through 15.5,

with corresponding Y values). Each cell of the matrix can

represent any areal unit; in this case, one square mile. Since

the area of the watershed is 117 square miles, this matrix will

easily accommodate the entire watershed. By using the Copy

command, it is unnecessary to type in all 256 values of the

coordinates. The first 16 values may be entered using the Data

Fill command, by which any consecutive set of numbers may be

entered instantly and automatically. Then, the Copy command is

used to copy the original 16 entries to the desired amount of

cells. Using this same technique for the Y values will create a

16 by 16 matrix within a few minutes. Once the first map is

constructed, the scale can be altered by multiplying all X and Y

coordinates by a scaling integer. Thus, it is possible to zoom

in or out, as on computer-aided design (CAD) systems (see Figure

2).

If numbers or labels are assigned to the cells on the map,

then a matrix of Z attributes is assigned to the X and Y

coordinates. Each value will appear in the center of the cell

(Figure 3), and will be changed automatically if the Z
coordinates are altered on the spreadsheet. In Figure 3, only


5
.06,




University of Florida Home Page
© 2004 - 2010 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated October 10, 2010 - - mvs