o10
March 1987
Disk(s) under separate cover
Circular 740
Sugarcane Field Record System
with Stubble Replacement Analysis
COMPUTER SERIES
Steven Smiley
Central Science
Library
JAN 30 1990
University of Florida
101
F636c eWxt mMon vi / institute of Food and AriuaItur Solsnm / Unweity of orid / Job T. Woe,. Dan
740
guide
SUGARCANE FIELD RECORD SYSTEM .
WITH STUBBLE REPLACEMENT ANALYSIS
Steven Smiley
Food and Resource Economics Department
Institute of Food and Agricultural Sciences
University of Florida, Gainesville
U,1,PrRSITY OF FLORIDA LIBRARIES
Abstract
This manual explains how to use the Sugarcane Field
Record System With Stubble Replacement Analysis (SFRS)
microcomputer program. The SFRS is designed to integrate the
field record keeping and stubble replacement decision aspects
of sugarcane farm management. The SFRS can increase the
availability of information on past field performance and
improve the accuracy of the replacement decision.
Keywords: Sugarcane, Field records, Stubble replacement,
Microcomputer
Acknowledgment
The author would like to acknowledge the work of Susan
Phillips, who spent a lot of time and effort preparing the
documentation and software for publication.
Table of Contents
Page
INTRODUCTION.*............................................. .... 5
Program Description. ........................................ 5
Hardware and Software Requirements.......................... 5
Key Words................................................... 6
Menus....................................................... 7
Making Back-Up Copies....................................... 8
Starting the Sugarcane Field Record System.................. 8
USING THE SUGARCANE FIELD RECORD SYSTEM MESSAGES............... 10
Getting Extra Help (MESSAGES/HELP) .......................... 10
The IFAS Disclaimer Statement (MESSAGES/DISCLAIMER)......... 11
USING THE SUGARCANE FIELD RECORD SYSTEM....................... 12
Entering Field Records (ENTER).............................. 12
Printing Field Records (FIELD/PRINT)........................ 17
Finding a Field Record (FIELD/FIND)......................... 18
Storing an Old Field Record (FIELD/STORE)................... 19
Deleting a Field Record (FIELD/DELETE).......... 21
Accessing Permanently Stored Records (OLD).................. 22
USING THE STUBBLE REPLACEMENT DECISION AID.................... 24
Description ................................................ 24
Setting Up the Decision Aid Worksheet (DECISION/SETUP)...... 26
Beginning the Decision Aid Calculations (DECISION/BEGIN) .... 27
Graphing the Results of the Decision Aid (DECISION/GRAPH)... 30
Using the Total Harvest Prediction Aid (DECISION/HARVEST)... 31
Changing the Yield Prediction Values (DECISION/CHANGE) ....... 37
Erasing Old Decision Aid Inputs (DECISION/ERASE) ............ 38
SAVING YOUR WORK (SAVE) ....................................... 39
QUITTING THE SUGARCANE FIELD RECORD SYSTEM (QUIT)............. 39
ERROR MESSAGES. ................................. ...... ....... 39
ORDERING INFORMATION.......................................... 40
Appendix: Flowchart.......................................... 41
List of Figures
Page
SFRS Menu Hierarchy............ .............................. .8
Title Screen and Main Menu ......................... ...................... 9
HELP Message...................... ...... ............... ............. 10
I FAS Disclaimer Statement ..... ................. ..................... 11
Sample Field Records ................................................... 12
Sample Field Records (continued) .......................................... 13
Sample Field Records (continued) ........ .......... .................. J3
Sample Field Records (continued) ................ .. ......................14
Sample Field Type Classification Scheme ..... ....... ................... .. ...15
PRINT Submenu .......................................................17
FIELD Submenu....................................................... 18
Finding a Field ................................ .......... ............19
OLD Submenu .................. .................................... ...21
DECISION Submenu................ .. ............... . .............. 25
Sample Decision Aid Input Worksheet ................................... 26
Sample Results from the BEGIN Option.....................................29
GRAPH Submenu ...................................... ................ 30
RESULTS Graph .......................................................32
COMPARE Graph....................................................... 33
ALTERNATIVE Graph.................................................. 34
ESTIMATES Graph .................................................. 35
Sample Total Harvest Prediction Aid....... .............................36
Sample Yield Prediction Worksheet......... ...... .........................37
Figure 1.
Figure 2.
Figure 3.
Figure 4.
Figure 5.
Figure 6.
-Figure 7.
Figure 8.
Figure 9.
Figure 10.
Figure 11.
Figure 12.
Figure 13.
Figure 14.
Figure 15.
Figure 16.
Figure 17.
Figure 18.
Figure 19.
Figure 20.
Figure 21.
Figure 22.
Figure 23.
Sugarcane Field Record System
With Stubble Replacement Analysis
Steven Smiley *
INTRODUCTION
Program Description
The Sugarcane Field Record System With Stubble
Replacement-Analysis (SFRS) is a microcomputer program
designed to integrate the field record keeping and stubble
replacement decision aspects of sugarcane farm management.
The stubble replacement decision aid portion of the package
analyzes the field records and helps the producer determine
if a field should be replaced, and if so the replacement
variety to plant on that field which maximizes discounted net
revenues based on data recorded and assumptions made by the
producer. The SFRS can increase the availability of
information on past field performance and improve the
accuracy of the replacement decision.
The SFRS was developed at the Institute of Food and
Agricultural Sciences at the University of Florida to conform
with production and record keeping practices in Florida.
Users may find the SFRS to be suitable to conditions in other
areas.
Hardware and Software Reauirements
The SFRS is a template to be used in conjunction with
Lotus 1-2-3 Release 1.A integrated software. (Users with
Release 1 will be able to use the SFRS with some slight
modification in operating procedures.) The SFRS will operate
on MS-DOS/Lotus 1-2-3 compatible computers with a minimum of
256K memory and dual disk drives. An Epson compatible
printer is required for the program to operate properly and
must be turned on when the program is started. Reports will
not print properly on printers other than Epson or Epson
compatibles. Experienced Lotus users may modify the print
commands on a backup copy of the SFRS program, but it is
suggested that novices do not attempt any modifications.
Steven Smiley is a former graduate research assistant.
Food and Resource Economics Department, Institute of Food and
Agricultural Sciences, University of Florida.
A color or graphics monitor is required to view the graphs.
Users with nongraphics monitors can use the Lotus PrintGraph
option (Graph for Lotus 1-2-3 Release 1) to print the graphs
on paper.
You can not use all the computer memory for field
records since the stubble replacement portion of the SFRS
needs at least 5K of memory. The following is an
approximation of the maximum number of fields the SFRS can
handle with different memory capability.
Total Memory Number of Field Records
256K 200
320K 350
384K 500
448K 650
512K 800
576K 850
640K 850
Notice that 850 fields are the maximum number of records that
the SFRS can handle, regardless of the available memory. Any
records entered beyond this limit will be ignored by the
program. The SFRS can only analyze the records stored on the
disk with the program. Additional data disks will not
increase the total number of records that can be analyzed.
Hard disk drive users may store both the program and records
on the hard drive, but the program would need to be modified
extensively. An expert user may want to modify the program
using a backuD cov, but it is suggested that a novice Lotus
user not attempt any modifications. Using a hard drive will
not increase the number of records that can be analyzed.
A basic understanding of Lotus mechanics is needed to
run the SFRS program. Working through the first four lessons
of the 1-2-3 Tutorial supplied with the Lotus 1-2-3 software
package is suggested. Also, reading the first four sections
of the 1-2-3 Users's Manual is helpful. Once you feel
comfortable moving the cursor around the screen, selecting
menu choices with the cursor, and entering numbers and labels
into cells, you should be able to use the SPFRS program.
Key- Words
Throughout this manual several key words are used to
describe the appearance of the SFRS once it is loaded into
the 1-2-3 spreadsheet. The following is a brief summary of
the meaning of those keywords.
Enter:
Screen:
Spreadsheet:
Worksheet:
Input screen:
Null return:
when appropriate letters and/or numbers
are typed into a cell highlighted by the
cursor and the
key is pressed.
the numbers and letters visible on the
monitor at any time.
the rows, columns, and related features
of 1-2-3.
specific portions of the 1-2-3 spreadsheet
set up by the SFRS to accept input from
the user and make pre-specified calculations.
portion of the spreadsheet formatted by the
SFRS to accept production records on
sugarcane fields.
pressing the key with no data
input.
The menus in the SFRS operate like the Lotus command
menus. To select a menu choice (option) move the cursor so
that the option name is highlighted and then press the
key. Figure 1 shows a schematic of the menu
hierarchy used by the SFRS program.
Although the SFRS will allow you to make a menu
selection by pressing the first letter of the option name, it
is suggested that the cursor be used instead. The reason for
this is that certain menu options give specific instructions
when the option name is highlighted. If the first letter
method of making menu choices is used, these important
instructions will be missed. This is especially important
for all FIELD submenu options.
amER m EED mm c mm= pB S3B aw
I I I I E M
I I I I
II I
IHe
I I am Rom I RMW
I
P==I Z BlN 2MN I*=N 4WEN MS W
s E3
Figure 1. SFRS Menu Hierarchy
Making Back-Up Copies
Before using the SFRS for the first time, protect the
original program disk by making a back-up copy of it.
Following the specific directions for your computer, first
format a blank disk and then copy all of the files from the
original disk to the back-up using the COPY *.* B: command,
assuming that the original is in drive A and the formatted
blank disk is in drive B. Store the original SFRS program
disk in a safe location and use the back-up disk for
day-to-day work. You may make as many back-up copies as you
want.
Starting the Sucarcane Field Record System
To start the SFRS, place your 1-2-3 System disk in drive
A and your back-up copy of the SFRS in drive B. Turn on the
computer. If the power is already on, reboot the system
( for the IBM-PC). When the Lotus Access
System Menu appears, highlight the 1-2-3 option and press the
key. Press any key when prompted to do so by
Lotus. The SFRS will automatically load, go through a series
of set-up operations, and finally display the title screen
and Main Menu as shown in Figure 2. (Users with Lotus 1-2-3
Release 1 must use the /File Retrieve AUT0123 command to load
the SFRS program and then must press the <0> keys
simultaneously to perform the initial set-up routine. Note
nZ 3M am=
CEmNX m4anS
CN aESSx 1Ena
that this is the letter 0, not the number zero.) Once the
title page is displayed you may proceed to any of the SFRS
options.
ite Birt Fi1d cid Dr:inicn Mamng Sae Qiit
Ekte cr In go ffld azid eatrias. Paews 4 kam finisdac.
AT
201
20 .... ......... ............. ....... ... ............ .
204 SEE: SgMUa MFld ad NeIB Syst *
205 with SbtJle a Bla karalnis *
207 *
208 *
210 *
211 DIelpecity: *
212 az au d jenaza Baxnics atnBrt *
213 .1 Bad ar ary2lbnt2l aslaa *
214 *
235 (C) IS-, Utimstty cdds, 196 *
216 *
218
239
220
Figure 2. Title Screen and Main Menu
USING THE SUGARCANE FIELD RECORD SYSTEM MESSAGES
Getting Extra HelD (MESSAGES/HELP)
A help screen is available from the MESSAGES submenu and
can be viewed by first selecting MESSAGES and then HELP.
This help feature describes the options available in the SFRS
that are not available from any of the menus. The complete
help message is shown in Figure 3. Use the and
keys to read the entire message. When you are finished,
press the keys to go back to the Main Menu.
HELP
aUw an I istad tte qa ttu ai rt aidlable
se mia system. a us a c ths q;a psm a Mda the41t>
)W,, than pumn the 1Intr 03coBG-,iLW to the de < zect qT>
sm M Rr D amtS Wan alszr fi d aa i in te Ws
ae yar wzd pwrzimk1ly by tgAing t3 fblod srzes:
/FS X=23 R
1il sevein ce 103 caardsz 111i ,rt P 1d6 2
Xm w3fth in ic ai n im n fthe ar ktrlus avy
eh =m yu lomd t- S, ht y ghuld
n ta< n of arera a rw fadd zec c
betze refei= ary c1 1JB On tB a s liztimsB.
af 5 BBGchtsxicman duttuiSEm An ~yaa i r l
axta ct ti smm aild yi wrt to zbn to the
ftin M)n.
4
t EN a sti to d~at a field zami ft
crumC ct ttr 2A fUim a axme fa*= y=
cd:t di c:
Fi e .41.xE
Figure 3. HELP Message
The IFAS Disclaimer Statement (MESSAGES/DISCLAIMER)
Each user of the SFRS program should select the
DISCLAIMER option from the MESSAGES submenu and read the IFAS
Disclaimer and Condition of Release or Sale statement before
using any of the other SFRS options. It is the users'
responsibility to read and understand the message. Figure 4
shows the Disclaimer and Condition of Release or Sale
statement.
I
Ma Uo1asity oc Iccidi M, Ihdtt c Pad ard Armdalnsb
Scdlaxs (M"S), ad Elaedda af.Hmtb Edmsicn Sevica (5ES) O dl
hb ma liabLty cr mpaei Ity t y pho cr my atterp pWIn
cr atity wifth pect to my liability, 1=ss, cr dxage caNNW cr
allied to be aand cditsLy cr irdiStcly by sg m1ro by I33S
ftr sala cr cqEaiw use imluzbiW ht I initd to ay ftrL-
nZln cE sav3m, 1= ca hadris, cr ay -0 cr
intial m acisi at c ay bcb Eat te t cr
dclicgia c this a tIac.
a20 w C1 E CR SIE
AU c= =bM rstan ddb9ibjd]EScrB aa a 'AS 33'
bimaiswiC i ct1 Dis b a a w
1WW
Figure 4. IFAS Disclaimer Statement
USING THE SUGARCANE FIELD RECORD SYSTEM
Entering Field Records (ENTER)
To enter or change data for the field records select
ENTER from the Main Menu. The SFRS requires that field
records be entered in a specific format. This format ensures
that the records are in the form which the SFRS expects them
to be. The SFRS is flexible enough to allow for field
numbering systems which may vary from farm to farm. Sample
field records are shown in Figures 5, 6, 7, and 8.
Figure 5. Sample Field Records
K L M N O P Q R S
1
2 --IIj | -Fattan i S
3 SWy-P 9W -1 G/A-1 ml .-1 %83Z-1 Ng/A-1 S/A-1 HAL-2 G/A-2
4 57.25 7302.08 33.74 3.50 14.30 32.62 38.52 7411.21 37.65
5 54.26 732.08 37.90 3.50 14.16 37.29 43.5L 7411.21 33.55
6 5.95 7302.08 46.40 3.50 14.60 44.25 53.59 7411.21 36.28
7 41.27 732.08 49.03 3.50 14.19 47.60 5.49 7411.21 37.29
8 56.25 7302.08 29.91 3.50 14.58 28.48 34.43 741.21 35.98
9 61.00 7302.08 32.20 3.50 14.69 30.77 37.54
10 51.30 7302.08 27.27 3.50 13.52 25.84 28.50 7411.21 32.38
11 54.30
12 55.73 7302.08 36.93 3.40 24.30 35.50 41.93 7411.21 41.06
13 60.M 73M2.08 41.85 3.40 14.20 40.42 47.33 7411.21 45.57
14 64.6. 7302.08 36.71 3.40 14.40 35.28 42.01 7411.21 41.84
15 63.10 7302.08 35.59 3.40 14.50 34.15 41.02 7411.21 40.70
16 57.25
17 54.26
18 59.95 7302.08 45.68 3.50 14.60 44.25 53.59 7411.21 36.28
19 41.27 7302.08 49.03 3.50 14.19 47.60 5.69 7411.21 37.29
20 56.25 7302.08 29.91 3.50 14.58 28.48 34.43 7411.21 35.98
Figure 6. Sample Field Records .(continued)
T U V W X Y Z MA B JC
d lbmg. II 1ia |iz l I
4h-2 Vkv-2 NIWA2 SE/A-2 MC-3 (3A-3 TSh-3 SazM-3 N/A-3 S -3
3.30 14.35 36.51 43.30 7512.28 33.54 3.60 14.17 32.06 37.44
3.30 14.34 26.93 31.91 7512.28 29.89 3.60 13.89 28.41 31.30
3.30 13.99 30.12 34.64 7512.28 29.29 3.60 13.74 27.81 31.28
3.80 13.73 31.72 35.65 7512.28 28.72 3.60 13.90 27.24 31.08
3.80 13.78 30.42 34.34 7512.28 28.72 3.60 14.12 27.24 31.68
3.80 34.52
3.90 34.20
3.90 14.15
3.90 14.08
3.90 13.98
3.30 13.99
3.80 13.73
3.80 13.78
25.55 30.74 7532.28
33.67
37.68
34.69
34.00
30.12
31.72
30.42
39.42 7512.28
43.93 7512.28
40.20 7532.28
39.06 7512.28
34.64 7512.28
43.65 7512.28
34.34 7512.28
35.10 3.60 14.74 33.62 41.28
33.68 3.70 14.28 32.20 37.96
35.60
32.19
3.70 13.89 34.12 38.89
3.70 13.70 30.71 34.42
29.29 3.60 i3.74 27.81 31.28
28.72 3.60 14.32 27.24
31.68 J
Figure 7. Sample Field Records (continued)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
38
19
20
AD AE AF A JM At
1
2 | Ruath asujn |
3 IMCb4 G-4 Msh-4 %ax=4 NA-4 S/A4
4 771.L21 31.71 3.70 3.12 29.99 34.88
5
6 7701.21 27.81 3.90 13.73 25.84 29.04
7
8
9
10
31
32 7701.21 31.78 3.50 14.12 30.06 34.96
13
14 7701.21 33.89 3.50 33.98 32.17 36.96
35 7701.21 33.25 3.40 33.89 31.53 35.95
26
17
28 7701.21 27.56 3.90 13.49 26.09 28.70
19
20 7701L21 27.56 3.30 13.73 25.84 29.04
Figure 8. Sample Field Records (continued)
To move around the field records worksheet use the
, , , and the directional arrow keys. The
SFRS is designed to hold a maximum of 850 records. A record
is a row of information applying to one field of sugarcane.
The SFRS does not expect records to be entered in row 854 or
higher and will not consider data entered in these rows in
its calculations for the stubble replacement decision aid. A
number indicating the number of records contained in the
system appears in cell Gl (see Figure 5). This number is
only updated each time the SFRS is loaded.
While entering record information it is possible to move
the cursor unrestricted anywhere in the entire spreadsheet.
However, it is strongly recommended that you do not go
anywhere to the riaht of column AI. The program commands
that operate the SFRS are located to the riaht of column AI
and should never be altered in any way by the user. In
addition, do not ever insert or delete a row from the field
record input area. this will destroy the SFRS Droaram.
Five general items of information are required for each
field regardless of the age of the cane. These items are:
field name, type, variety of cane, number of acres in the
field, and planting date. Several fields can be grouped and
treated as one record by entering the proper figure in the
"Acres" column. This will essentially allow more then 850
fields to be analyzed. (Note: the maximum record number
remains 850.)
The name of each field may be up to five characters
(letters and/or numbers) long and is entered into column A
under the heading "Field Name." If the name of a field
begins with a number, then the name must be preceded with an
apostrophe ('). For example, '21W1 is a valid entry, but
21W1 is not valid. If the apostrophe is omitted, 1-2-3
interprets the entry as a number. If the apostrophe is
omitted when a name begins with a number and also has
letters, then 1-2-3 will beep. To correct the error, press
the key and retype the field name including the
apostrophe.
The field type is entered into column B under the
heading "T." The field type is a one-digit number
representing the classification of each field according to
certain characteristics. It is used to distinguish groups of
fields with similar characteristics from other groups.
Figure 9 presents a sample classification scheme. Each
grower must create his/her own classification scheme. Use
whatever groupings of characteristics you want in
constructing your scheme. The classification numbers should
be divided equally between fields most recently fallowed and
fields most recently replanted successively. It is helpful
when entering field information to group fields by type.
That is, enter all the fields for type 1, then all the fields
for type 2, and so on. This allows for easier identification
when you are later searching for a specific field.
Txp.e Characteristics
1 Successive, light frost damage
2 Fallow, light frost damage
3 Successive, muck soil, pest damage
4 ,Fallow, muck soil, pest damage
5 Successive, fair soil, low rainfall
6 Fallow, fair soil, low rainfall
7 Successive, sandy soil, heavy fertilizer
8 Fallow, sandy soil, heavy fertilizer
Figure 9. Sample Field Type Classification Scheme
The variety name of the sugarcane grown in the field is
entered into column C under the heading "Variety." The name
of each variety may be up to eight characters (letters and/or
numbers) long. The use of the apostrophe for variety names
beginning with a number is the same as for the field name.
The last two items of required information are the
number of acres and the planting date. The number of acres
planted for each field is entered into column D under the
heading "Acres." The field's most recent planting date is
entered into column E under the heading "Plant Date." The
date is always entered. with numerics in the YYMM.DD format
where-YY are the last two digits of the year, MM is the month
number, and .DD is the day of the month preceded by a period
(decimal point). For example, September 10, 1983 would be
entered as 8309.10, and February 3, 1980, would be entered as
8002.03.
The remaining record information for each sugarcane
field is entered in columns F through AI. This information
pertains to yields for plant cane and-up to four ratoons.
Columns F through K are used for plant cane, L through Q for
the first ratoon, R through W for the second ratoon, X
through AC for the third ratoon, and AD through AI for the
fourth ratoon. For the plant cane and each appropriate
ratoon the following information is required.
HvDt-P : harvesting date in decimal form (YYMM.DD)
GT/A-P : gross tons harvested per acre
Trsh-P : percent trash
%Suc-P : percent sucrose in normal juice
NT/A-P : net tons harvested per acre
St/A-P : standard tons harvested per acre
In each case the "-P" indicates that entries are for plant
cane. The same abbreviations are used for each column
heading except that the "P" becomes a number that indicates
the ratoon rotation.
All fields in the SFRS must have entries for the plant
cane yield. If the field has been harvested twice, you must
also enter the harvesting information for the first ratoon
(columns L through Q). If a field has been harvested three
times, data should appear in the plant cane, first ratoon,
and second ratoon columns. Continue entering information for
each ratoon that has been harvested from the field. Remember
to enter production data only for the most recent crop
planted in the field. The blank spaces that appear for some
fields in the example (Figures 5, 6, 7, and 8) indicate that
those ratoon data do not apply.
Continue to enter the field name, type, variety of cane,
number of acres, planting date, and plant cane and ratoon
harvesting information for every sugarcane field. When data
entry is complete press the keys simultaneously to
return to the Main Menu. Before continuing with the SFRS
program, it is necessary to save your work. To do this
simply use the SAVE option on the Main Menu. If you want to
save your work while you are entering data, use the following
key sequence: /File Save AUT0123 Replace.
Printing Field Records (PRINTi
To print the field records on all of the fields of a
specific age, select the PRINT option from the Main Menu.
The screen will appear like Figure 10. Move the cursor to
highlight the age of the cane fields you want to print and
then press the key. The printer must be on. If the
printer is not on, an error message will appear. To recover,
press. the key and then the keys
simultaneously. After printing all the desired information,
select the RETURN option to go back to the Main Menu.
PRINT Submenu
PJatura Unsta 2RBbozn MRsabn 4RBtxzn ashan
Pit daa cn a1L plat cra fields
AT
2aL
202
204 SEE: a1Dana Field aB ld Npng at *
206 with Stxt Fla 1R:mt kftis *
206 dJesi l. *
27 *
20* *
29*
211* Deuae*cl S y:
232 -. a BFad a Ed B IWics DkctRat
213 atitue c ad ai Agcrintnl Sias *
215* (C) IS, Usityf M ki, 196 *
2M8
239
Figure 10.
Finding a Field Record (FIELD/FIND)
Once you have entered information for several fields, it
becomes difficult to locate one individual field. To locate
a field, select the FIELD option from the Main Menu. A
submenu appears on the top of the screen as shown in Figure
11. Choose the FIND option.
You are asked to type in the name of the field to find
and press the key (see Figure 12). If you correctly
typed the name of an existing field (using an apostrophe if
the name begins with a number and capital or lower case
letters exactly the way the field name was entered into the
system), the SFRS will locate and highlight the field. You
can move the cursor horizontally to view the production
information for that field.
FIrd Stor Welbs aesh
H4AiSt a st Ofaled wzcKc. rite dan tts call amitraes.
AT
202
2%0 SEMS: Sxra Field Fa*acd pirn; sba
205* with Stbbla it in ktlsis *
26* weaml.O *
207 *
z2* *zia saearmc~scnr
23* *nh CIa dMluial8Ire
208
209
220 **
211 Da*krlDS *b
232 and Pasmm Brndca.Dbwut *
223 3t*tte cf ad ard A7imctxml Sac'e *
224 **
215 (Q MIg, Utvw~ty n a 1986 *
236f* *
217
228
229
220
Figure 11. FIELD Submenu
U WA M AX AY AZ E B
131 TAPn aC field to tihd thm
12 pas
233
34 If tt fied nn begirs wift a trnb,
335 pscnbdttata wifan;-ha 1t, (').
136
337 Aftr th SESEB pan dib tta field
138 pwn <4IE> to artink.
139
140 -
341
142
143
244
145
346
347
248
349
Figure 12. Finding a Field
If the FIND option does not result in any records being
highlighted and the cursor appears at cell Al, you have not
entered the name of the field properly or the field name does
not exist in the SFRS system. Reselect the FIND option and
reenter the field name.
After viewing the field record information, press the
key to return to the FIELD submenu. Note that the
title page will not reappear, but rather the cursor returns
to cell Al. To return to the Main Menu, select the RETURN
option.
Storina an Old Field Record (FIELD/STORE)
To store old field record information permanently in a
separate worksheet requires location of the field name using
the FIND option from the FIELD submenu. Make a note of the
row number. Next, select the STORE option from the FIELD
submenu. If the STORE option is selected in error or
accidentally, use the RETURN option to go back to the FIELD
submenu, otherwise move the cursor to highlight the CONTINUE
option.
Read the instructions that appear below the menu for the
CONTINUE option before pressing the key, as no
further instructions will be given by the program for the
next two steps. When ready, press the key. Move
the cursor to highlight the field name (column A) of the
record to store. To store the record, press the
keys. The SFRS will verify your choice and allow you to
return to the FIELD submenu without storing the record
(select NO). To continue, select YES. The SFRS
automatically copies the record information for the field
into a temporary file and loads a separate file named
OLD.WKS. A new menu will now appear (see Figure 13). (Users
with Lotus 1-2-3 Release 1 should press the <0> keys
when the OLD.WKS file is loaded.) To continue the storing
routine, select the COPY option. If at this point you decide
not to continue the storing routine, select the RETURN option
to go back to the Main Menu. After SFRS completes the
storing routine you are returned to the OLD submenu. From
here you can PRINT records, FIND records, BROWSE through the
records, or use a special option SPACE to create more space
on the program disk. These options are described under the
section entitled "Accessing Permanently Stored Records." To
go back to the Main Menu, select the RETURN option.
Once you have stored the record information for a
replaced field into the OLD.WKS file and have returned to the
SFRS Main Menu, you must still delete the record information
from the system. Use the DELETE option from the FIELD
submenu that was described in the previous section.
To avoid getting a disk full error while using the SFRS
program, it is a good idea to copy large OLD.WKS files to
separate data disks. The file can be loaded from the Lotus
ready level by typing /File Retrieve OLD.WKS. Once an
OLD.WKS file is copied to a data disk the records in the
original OLD.WKS file on the program disk (the disk that has
the AUT0123 file) can be removed using the SPACE option on
the OLD submenu to create more disk space for the SFRS
program. For more explanation see the section entitled
"Accessing Permanently Store Records."
m adrt Fird aBEM qa= Rtz
dto 1 ealdcdm tie SE qtdm arazs this file.
A B C D E F G H I J
1
2
3 NUar CC
4 Etes 7
5
6 Field mlat
7 ?mS T Vndary ac9 ab&s
8 2B0 2 CPS3-MB 40.5 7011.11
9 22E3 3 C56-9 39 7011.11
10 236 2 CS3-58 39.5 7011.11
11 23W7 3 CSE3-8 41 7011.11
12 23W7 3 C3-58 41 7011.11
13 22W3 3 ~63-8 45.5 7011.11
34 23M5 2 C6-88 80 7011.11
35
16
17
38
39
20
nBa p- ary Tash-P "a-P Mr/-P
7201.09 47.75 3.30 4.23 46.22
720L9 54.82 3.20 33.80 53.07
720.09 45.17 3.30 34.91 43.72
7201.09 46.66 3.30 13.85 45.17
7201.11 46.66 3.30 33.85 45.17
72L.09 49.24 3.30 34.50 47.67
720L.09 49.5 3.30 15.21 47.96
Figure 13. OLD Submenu
Deletina a Field Record (FIELD/DELETE)
The SFRS is designed to maintain and analyze records on
the most recent planting of cane growing in the fields.
Afler the Stubble Replacement Decision Aid has been used on
the current set of records and the decision is made to remove
the stubble from a field, the information in the SFRS for the
existing variety must be removed from the SFRS. The old
record information can either be deleted entirely, or saved
to a separate worksheet for permanent storage (see the STORE
option on the FIELD submenu).
To delete the production information for a field, first
locate the field name using the FIND option from the FIELD
submenu. Make a note of the row number. Second, select the
DELETE option from the FIELD submenu. If the DELETE option
is selected, in error or accidentally, use the RETURN option
to go back to the FIELD submenu. Otherwise move the cursor
to highlight the CONTINUE option.
Read the instructions that appear below the menu for the
CONTINUE option before pressing the key, as no
further instructions will be given by the program for the
next two steps. When ready, press the key. Move
the cursor to highlight the field name (column A) of the
record to delete. To delete the record, press the
keys. The SFRS will verify your choice and allow you to
return to the FIELD submenu without deleting the record
(select NO), or continue and delete the record (select YES).
After the SFRS deletes the information, the FIELD submenu
will reappear.
Using the DELETE option does not delete the name of the
field or the number representing the type of field. This
will allow you to enter new production information for the
field or enter a new field name and type to replace the old
name and type.
Only one record can be deleted at a time. If you want
to permanently store old record information, be sure that you
print the records using the PRINT option and store the old
records using the STORE option before you use the DELETE
option. After deleting all the records that you want, return
to the Main Menu by selecting the RETURN option. To complete
the deletion process you m= use the SAVE option on the Main
Menu to update the SFRS system.
Accessing Permanently Stored Records (OLD)
To access permanently stored old record information,
select the OLD option from the Main Menu. There are six
options on the OLD submenu: COPY, FIND, PRINT, BROWSE,
SPACE, and RETURN (see Figure 13). The COPY option is only
used in conjunction with the STORE option on the FIELD
submenu. The FIND option lets you locate a specific
sugarcane field. It operates like the FIND option on the
FIELD submenu. The PRINT option lets you print field records
on all of the fields of a specific age. This print function
works the same as the PRINT option on the Main Menu. To view
the record information for the old fields, use the BROWSE
option. You can use the , , , and
directional arrow keys to move about the worksheet. However,
do not move the cursor beyond column AI since the program
commands that operate this portion of the SFRS program are
located to the right of column Al. To return to the OLD
submenu from the BROWSE option, press the keys. To
go back to the Main Menu, select the RETURN option.
When the OLD.WKS file gets too many records in it you
may receive a disk full error while trying to enter new field
records (the ENTER option), or using any of the other SFRS
options. To avoid disk full errors, copy large OLD.WKS files
to a separate data disk using either the Lotus copy utility
or the DOS level copy commands. These data disks should not
contain the AUT0123 file thus, the OLD.WKS file must be
loaded by using the /File Retrieve OLD command. (Users with
Lotus 1-2-3 Release 1 will need to execute the <0> key
sequence to activate the menu.) The RETURN option on the OLD
submenu is no longer appropriate since the AUT0123 file is
not present. In this case use the BROWSE command to break
out of the SFRS macro commands and then use Lotus commands to
exit the program.
Once you have copied the -OLD.WKS file from the SFRS
program disk to separate data disks you can use the SPACE
option on the OLD submenu to erase all the records and thus
create more space on the program disk. Make sure that you
have copied the OLD.WKS file from the program disk to a
separate data disk before you use the SPACE option, since
once the records are erased they are lost forever. The SPACE
option gives you two opportunities to escape from the option
and return to the OLD submenu without erasing the records.
You should never use the SPACE option on the OLD.WKS files
that are stored on data disks.
USING THE STUBBLE REPLACEMENT DECISION AID
The purpose of the stubble replacement decision aid is
to utilize the information on past field performance
contained in the field production records to help decide
whether to replace the existing stubble in a particular field
or allow the existing variety to ratoon one more year. The
SFRS does not calculate the optimal time to replace a field,
but given the record information and assumptions that you
have made helps you to determine the variety to use when
replanting that field.
Depending on the number of field records entered and the
number of replacement varieties being considered, the SFRS
requires approximately three minutes to perform its
calculations, during which time there is a lot of screen
activity and files are loaded and reloaded. When the
calculations are completed the results are displayed on the
monitor screen. Here is a brief outline of what the SFRS
does to obtain the stubble replacement results.
1. Search for the field to be considered for
replacement and display its production statistics
for the previous year.
2. Search for other fields in the SFRS which were of
the same type and had the same variety of cane
growing on them as the field to be considered for
replacement. The selected fields must also have
been planted within ten days of the planting date
and harvested within ten days of the most recent
harvesting date of the original field. The
averages of the production records for those fields
are displayed.
3. Search for fields of the same type, variety, and
similar planting and harvesting dates as the field
to be replaced but which were one ratoon older, and
display the averages of the production data for
those fields. '
4. One at a time, take the suggested replacement
varieties and search for fields which were of the
same type, age, and similar planting and harvesting
dates as the first field. Display the averages of
the standard ton yields for each field.
5. Calculate the present value of the infinite net
revenue stream which could be expected from each of
the suggested replacement varieties. The exact
methodology by which this is done is outlined in
"An Integrated Microcomputer Approach To The
Sugarcane Stubble Replacement Decision," a Master's
Thesis written by Steven Smiley at the University of
Florida.
6. Copy the relevant figures from the numbers just
generated to the results worksheet. Print the table
of numbers generated, graph the results, and display
the results worksheet.
The power of the stubble replacement decision aid is
that it allows you to try different strategies or adjust any
of the yield predications to recalculate the best replacement
strategy and best replacement variety in just a few minutes.
You can change the numbers as often as you like--creating
several different scenarios.
After all your field records have been entered and
saved, select the DECISION option from the Main Menu. A
submenu with seven choices will appear as shown in Figure
14. The DECISION submenu options are described in the
following sections.
Seb* Begin GQsh Hwmwt wan EMan Rab=
Rtar the < nraBmsiy tD begin t iecsil Aid.
AT
201
20M
204 E* R: gMra Field ad a*q Si stan *
205 wit SbiWte J pl a1 t Aiflys,
206 esnLO0 ,
207*
209
220
211 CaO* Nepty:
212 R* Rd ar Wa'd Bzna ks D*art t
213 IhAtik ac Rad ard Agrilt*al aiatc
215 (C) TS, U*ierity of Fetid, 196 *
238
239
220
Figure 14. DECISION Submenu
Setting Up the Decision Aid Worksheet (DECISION/SETUPI
To access the decision aid input worksheet, select the
SETUP option from the DECISION submenu. A sample input
worksheet is shown in Figure 15. Enter each piece of
information and press the down arrow to move to the next
space. When all the information has been entered, press a
null return to go back to the DECISION submenu.
AK AL M M AD AP 7Q
21 (1) Ts ttee ct tse fld tor plat: 23w
22
23 (2) If y cb rot aplat th field will nat ar's
24 =p beal, 2, 3, 4, cr 5 zat ald: (#) 3
25
26 (3) List tha wndlSim to =awar fr
27 epla:Lc tbs aba Wld: -.W*M 0EC-5 4*
28 -loI1-223 4<
29 (4) Pa (WStad. Tn) 22.00 = -
30 (5) ftau.st t ($V3M 9.00 .- A.
31 (6) Rlat ot (V=,)-, 350 An
32 (7) Dia=tnzaa (%),. 0.10 4W
33 (8) tal rat t in yr
34 anal i.13 qta 75000
35 (9) Pexhaet c:st -p- c 65
36 (10) If y im or plart, dl it be:
37 1) arsfie piatirg
38 2) ,a tr 1a r cm y
39 tam 1scr 2- 2
40
Figure 15. Sample Decision Aid Input Worksheet
Begin setting up the decision aid by entering the name
of the field you are considering for replanting. The SFRS
decision aid only considers one field at a time. Press the
down arrow and the cursor will skip to the third entry. Do
not worry about this. It is a quirk of the SFRS that could
not be avoided. Continue by entering the names of varieties
you wish to consider for replacing the existing stubble. Up
to six different varieties can be considered at one time. At
least one variety name must be entered. Varieties of cane
which are not already recorded somewhere in your field
records should not be included. After entering the variety
names and moving the cursor through all six spaces, press the
down arrow key and the cursor will move back to the second
26
entry. Enter the age that the cane would be the following
year if it were allowed to ratoon again. Press the down
arrow key to move the cursor to the fourth entry.
Next, enter values for price per standard ton, harvest
cost per gross ton, replant cost per acre, and your discount
rate entered as a decimal (for example, 10% is entered as
.10). The discount rate is the return you could get on an
investment other than sugarcane and is used by the SFRS in
the present value calculations. Since the SFRS generates
rough estimates of the number of net tons which will be
produced in the following year, enter your annual mill quota
in net tons. This value is used later for comparisons.
Enter the pre-harvest cost. Finally, if you do replant,
identify whether it will be a successive planting (enter 1)
or after one year fallow (enter 2).
The decision aid worksheet is now complete. Press a
null return to return to the DECISION submenu.
Beginning the Decision Aid Calculations (DECISION/BEGIN)
After setting up the decision aid worksheet, select the
BEGIN option from the DECISION submenu. Notice that the
printer must be onl If the printer is not on the decision
aid calculations will be terminated. To recover, press the
key and then the keys to go to the Main
Menu. However, all data entered into the decision aid
worksheet using the SETUP option will be lost.
When the BEGIN option is selected the decision aid
calculations will start. There will be a lot of screen
activity and loading and reloading of files. (Users with
Lotus 1-2-3 Release 1 must press <0>, the letter 0,
when the separate template named CALC is loaded, and again
when the AUT0123 file is reloaded.) During the calculation
routine three output tables are printed: stubble replacement
comparisons, yield predictions, and the results with the
recommendation for a best strategy (see Figure 16). When.the
calculations are complete the results worksheet will appear
on the screen and control returns to the DECISION submenu.
If the field should be replaced this year the SFRS will
calculate the replacement variety for a field and the optimum
cycle length for the next cycle for the replacement variety.
The results for each of your alternative varieties appear at
the bottom of the worksheet.
The infinite discounted net revenue streams are
calculated two different ways to determine if the field
should be replaced this year or if the stubble should be
allowed to ratoon one more year. The calculation method
which gives the highest value determines the best strategy.
The best replacement variety is defined as the variety with
the largest infinite discounted net revenue stream. The
results worksheet indicates what the best strategy is in
words in the middle of the worksheet. The best strategy
statement is preceded by two asterisks to help locate it.
The primary factor affecting which variety is determined
to be the best replacement is the standard tons yield
predictions made by the SFRS for a five year cycle for each
alternative variety. If you do not feel that the yield
predictions are accurate, such as if you anticipate allowing
a fallow year before replanting thereby increasing yields,
you can change the yield prediction values by using the
CHANGE option on the DECISION submenu. For more explanation
on the CHANGE option see the section titled "Changing the
Yield Prediction Values."
Fr this fW ths yew
fia alX dwar
f elds rm yw
Sas zr. Ne/A st?4
3.30 3M.35 36.5L 43.30
3.64 M1.07 32.27 37.34
3.62 14.03 30.44
35.i4
m. Mo idnm Minmn Stl. Dw.
8 37.68 25.55
6 34.32 27.24
YIELD PREDICTIONS
R101. cwtw
Hsv. *m: o
1 Mietr
Plat
3R
22.00 splabt: axMxsbe (M)
350 craftr Xllw (2) =c
0.10 an-ta m oet =1
9.00 ratio (g/s) *o
CMA1-223C53-588
64.61 52.61 0 0 0
42.0. 47.59 0 0 0
40.20 35.77 0 0 0
38.89 34.45 0 0 0
36.96 30.76 0 0 0
1 2 3 4 5
2
650.87
0.87
awD , 1 :=pwa paizufa m as ycvig
Ma -1 m~m be an1
RESULTS
Sbd. tMWIM -to 3&.29 fts Mpaat qd~s (=ftm) -p 3
WC ($t.L= -0 22.00 %1m cC =amstn *
bes ao. 44C5.74
Pzbv. 65 ..t np1m it th
Qzwt must Jo a3ka-ad
Fv= p' a=&: 433.34 to nib= CM =m YEWr 4438.46
A~RA
Madety:
FW. stzabe: 4405.74 3904.5B 0.00 0.00 0.00 0.00
rw .bnmp u3
at uBmna: 4438.56 3982.96 433.34 433.34 433.34 433.34
Figure 16. Sample Results from the BEGIN Option
3.67
2.90
Graphina the Results of the Decision Aid (DECISION/GRAPH)
Select the GRAPH option from the DECISION submenu to
display and save graphs. A color or graphics monitor is
required to view the graphs. Users with nongraphics monitors
must still use the GRAPH option to save the graph "picture"
to disk for later printing with the PrintGraph program (Graph
program for Lotus 1-2-3 Release 1) supplied with the Lotus
software package. Graphs should be updated every time the
decision aid is used (after using the BEGIN, HARVEST, or
CHANGE options) to be sure that the graph represents the most
current analysis. The GRAPH submenu is shown in Figure 17.
A brief description of each graph follows.
Figure 17. GRAPH Submenu
mESS 0329M AzaEWL E3Mn S Rumn
nghat cEtoa vael.plsaat zranlts.
AT
203
204 S: S=a Fad ed mpSir ta *
205 wtth S am peRaI aBo a ftalsis *
206 vicn L00 *
207 *
208 *
20 *
210 *
213 itt f Rod and Acjdiltal scsas *
224 *
25 (C) MM, U* dsity cE ladh, 36 *
228
239
220
..._______...... .. .. ........ _....... .... ........... ....-,,,..___.,_..
Graph of the final replacement results.
COMPARE Graph of the average yield of current
and similar fields.
ALTERNATIVE Graph of the standard ton yields of
alternative varieties.
ESTIMATES Graph of total harvest prediction
estimates.
Use the cursor to highlight the desired graph name and
press . After viewing the graph, press the
key to go back to the DECISION submenu. To view another
graph, reselect the GRAPH option, then choose the graph name
to view. Users with nongraphics monitors should press the
key when the WAIT message flashes in the upper right
corner of the.monitor display area. When selecting the
ALTERNATIVE graph, the monitor will beep once and the screen
will be blank. To view the graph, press the key.
To print any of the four available graphs, follow the
1-2-3 User's Manual for printing graphs. The eight character
graph file names are RESULTS.PIC, COMPARE.PIC, ALTERNAT.PIC,
and ESTIMATE.PIC. Examples of each of the graphs appear in
Figures 18, 19, 20, and 21.
Usina the Total Harvest Prediction Aid (DECISION/HARVEST1
To have the SFRS make a rough estimate of the total
expected harvest of your farm for the coming year, select the
HARVEST option from the DECISION submenu. The harvest
prediction aid shows the effect on the total yield of the
farm from replanting a particular field or fields. Depending
on what you choose to do with the stubble, the total yield is
adjusted for the expected yield of the field you are
considering for replacement. The SFRS estimates the average
yield, in net tons, of each age of cane, the total number of
acres of cane of each age, the total expected yield from each
age, and the total projected yield for the next harvest
period.
You should complete the stubble replacement decision aid
portion (SETUP and BEGIN on the DECISION submenu) of the SFRS
before selecting the HARVEST option. When the HARVEST option
is selected you are first asked if you have entered any more
records since the last time you changed the yield prediction
(see the section entitled "Changing the Yield Prediction
Values"). If you have not added any new records, or have not
RESULTS
Value Of Revenue Streams
(All st-rategies)
7\
N->
. . . ... .
. . .. . .... . .
Strategy
| Rev., stream + curr,
1-
I-<.
r ri
'- '- ,-
0 0
co Q
SI l
I3I
EA
77 Rev, stream
COMPARISON RESULT -
(Based on current fields)
% Sucr. NetT/A
Stc dr/.A
[7Z) Current
P. *
kc 0
0
8 -
I-
0
s(n
DI.
45
40
35
30
25
20
15
10
5
0
8in-lilar
M Ratocon
YIELD PREDICTIONS
(Based on expected yields)
70-
60 -
50 -
40-
a 30 -
c:
-0
2o
10-
Plant 1R 2R 3R 4R
Age
S1 -+ 2 o 3 A 4 x 5 6
AVERAGE YIELDS BY RATOON
50
45.34
45- ,
40-/
5 /30/ 34.70
| 35- --
3 31.90
30,31
ii28.71
l /// Ill !tl Iil
Mc 25-
Eo
o ///_ 20 __ !y1 III !t
5-
S20
Plant First Second Third Fourth
7 I Ave. net tons/acre e Std-dev. (net tons)
changed the yield predications from what the SFRS calculated,
then the SFRS does not re-estimate the predicted total
harvest. Enter a 1 for changes or a 2 for no changes, then
press .
The printer must be on for the HARVEST option to
operate. To recover from printer error, press the
key and then the keys to return control to the Main
Menu.
HARVEST Will first draw a graph of the total harvest
prediction estimates (ESTIMATES from the GRAPH option).
User's with nongraphic monitors should press the key
when Lotus displays the message "Enter name of graph to make
current:GRAPH3" and the WAIT signal is flashing in the upper
right corner of the display area. For users with graphic
monitors, press the key to continue after viewing
the graph. The results are now displayed on the monitor and
printed (see Figure 22).
TOTAL HARVEST PREDICTION
Mat rPmt S9erd izd Fabzth
Om Fabtn Rsbtn Rftan Fetabn Iis prafticr is braad
- -- enthe ameE ylald
(art 4 4 2 7 14 ct all flald in
AW. 5.34 31.90 34.70 30.31 28.71 the pwian ymr.
+/- Le9 1.95 2.98 2.90 2.45
As 41.25 70.13 41.00 41.43 43.64 ayaec nmtr cE
.- -.- aaes pe tfad
T1ftal 7480 8947 2845 8790 %7541
S ix IztjIec aal yird r za o uedetyy
Figure 22. Sample Total Harvest Prediction Aid
In the total harvest prediction worksheet the row
labeled "Count" indicates the number of fields of each age,
"Ave." is the average yield in net tons, "+/-" is the average
standard deviation of the yields, and "Acres*" is the average
number of acres per field. After the results are printed,
you are returned to the DECISION submenu. The total harvest
prediction worksheet will remain displayed on the monitor.
Changing the Yield Prediction Values (DECISION/CHANGE)
In the section describing the BEGIN option it was noted
that the primary factor affecting which variety is calculated
to be the best replacement is the standard tons yield
predictions made by the SFRS for a five year cycle for each
alternative variety. To change any of the numbers in the
yield predictions worksheet (see Figure 23), select the
CHANGE option from the DECISION submenu. Use the arrow keys
to move around the worksheet, changing any of the values.
When you have made all the desired changes, press a null
return. Be sure that the printer is onl The SFRS will
automatically recalculate the stubble replacement decision
aid, print out the results, and return to the DECISION
submenu. The CHANGE option should only be used after the
SETUP and BEGIN options.
AK AL M M O AP AS
61
63 YIELD PREDICTIONS
64.
66 PIa (ai ) so 22.00 ftaprt: a m.sse (1)
67 apl. oat- 30 3cr ataemf11 (2) -t, 2
68 Di. zaMab' 0.10 Iba-hamrst aCt = 65
69 HIaMv. at 9.00 io (gs) 0.87
70 SVXftO T5 1RAE
71 tay: cUl-2MPM-Ws
72 a 64. 32.. .. 0 0 0 0
73 3R 42.01 47.W 0 0 0 0
74 Ae: 2R 40.20 35.77 0 0 0 0
75 3R 38.89 34.45 0 0 0 0
76 4R 36.96 30.76 0 0 0 0
:77 1 2 3 4 5 6
78 2Man3s 3 1 1 tspamrplet Wi==yPrdid-
79 tht p;ms to wrecat3ted a9isd
80 t piter mat he cni
Figure 23. Sample Yield Prediction Worksheet
Erasing Old Decision Aid Inputs (DECISION/ERASE)
Once you have made your decision about replacing one
sugarcane field you will most likely want to do the same for
a number of other fields. Use the ERASE option from the
DECISION submenu to erase the field name, alternative
varieties, and age of cane from the decision analysis
worksheet. The price, harvest cost, replant cost, discount
rate, mill quota, pre-harvest cost, and replanting strategy
will remain since these values are less likely to change from
field to field. You may, of course, change these entries if
you wish by just typing in new values when the SETUP option
is selected. The ERASE option should always be used before
beginning an analysis on a new field.
SAVING YOUR WORK (SAVE)
Use the SAVE option on the Main Menu to save your work
to the SFRS program disk. This is essential after adding,
changing, or deleting records.
QUITTING THE SFRS PROGRAM (QUIT)
To quit the SFRS program, select the QUIT option from
the Main Menu. Be sure that you first save your work using
the SAVE option. The QUIT option returns you to the Lotus
system menu.
ERROR MESSAGES
All 1-2-3 error messages are explained in the Appendices
of the 1-2-3- User's Manual. Since the SFRS performs many
operations for you, unfortunately, knowing what an error
message means is not always helpful. Some useful
explanations of possible error messages appear below.
Disk full: There is not enough space on your data disk
to perform the operation you are attempting. Always try to
have at least two copies*of the SFRS program disk containing
your field records on hand in case this happens.
Illegal cell or range address: Something may be wrong
with the automatic functions the SFRS is supposed to
perform. This might occur if changes have been made to the
spreadsheet in areas outside of the acceptable input areas.
Press to recreate the SFRS program files and then
retry the operation.
Memory full: There is not enough memory space to hold
all of your field records. Save what you have, and then use
another copy of the SFRS program disk to continue entering
records. However, note that when using the decision aids the
SFRS program can only use the records stored on the disk that
is currently in use (ie. in drive B). Alternatively, you
could upgrade the memory in your computer.
Printer error: Usually occurs when the SFRS is trying
to print a report and your printer is not properly connected
or is not turned on. Turn on the printer, press the
key, and then the keys to recover. Data entered
using the options on the DECISION submenu will be lost.
A different kind of error may also occur while the SFRS
is calculating. This is not a system error like the ones
just described. When this type of error occurs, the word ERR
appears in a cell where a number should be. On the yield
predictions worksheet, this probably means that there are no
fields of similar variety, planting date, and most recent
harvesting date as the variety you are considering
replacing. If this is the case, you will not be able to use
the variety for which the ERR message was generated in the
decision aid, and must restart the decision aid from the
beginning using the SETUP and BEGIN options. The word ERR
may also appear in the results worksheet for the same reason.
ORDERING INFORMATION
For more information on this and other IFAS agricultural
software, contact your county extension office or write to:
IFAS Software Communication and Distribution
G022 McCarty Hall
University of Florida
Gainesville, FL 32611
Appendix: Flowchart
SUGARCANE FIELD RECORD SYSTEM
FLOW CHART
Create field
classification table.
Enter annual
production records./
Print any of the
four possible graphs
using separate program.
Find a field
and highI eight.
Print the field
records by age
of the cane.
Display and save
for later printing
any of four possible
graphs.
Recreate graphs
and special files.
Calculate similar
planting and
harvesting dates.
Calculate 5-year
yield predictions
for each challenger.
Calculate N.P.V.'s for
each alternative; best
alternative; best
cycle length.
Calculate expected
revenue for
existing stubble.
Delete records
for a field.
This publication was produced at a cost of $305.76, or $2.78 per copy, to inform sugarcane growers and field managers
on the ways to use the SFRS microcomputer program. 3-110-87
COOPERATIVE EXTENSION SERVICE, UNIVERSITY OF FLORIDA, INSTITUTE OF FOOD AND AGRICULTURAL SCIENCES, K.R. TelertllM,
direct, In coopeaton with the United Stat Department of Arculture, publishes this Ionrmaion to the the purpose of the May 8 and
June 30 1914 Aots of Congress; and is authorized to provide research, educational Idormation and other services only to ndiidual and nstitu-
tions that funedon without regard to race, color or national origin. Single copes of Extension publcans mungg 4 and Youth publie-
tions) e available tree to Florida residents from County Extension Offices. Infoation on bulk rates or opies for out-otte purchase"""
vailble from CM. Hinton, Publaon Distrlbuton Cnter IFAS Building 8664, Unerty of Florida. Gaineav, Florida 32611. Befre pubcizing Vale pubmidaon.
editors should contact this address to detennine availability.
RSS
HIDE
