play makAll work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All
HBAM2016AUG95
Pro 3.0
All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dullCopyright 1984-1996 Claris Corporation
and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy.
HBAM3016AUG95@
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
chart
8/7/97
AENTER1
AENTER2
AENTER3
AENTER4
AENTER5
AENTER6
Line Chart
Instructions Mac
Instructions PC
Line ChartB
ASEGMENT1
Y ASEGMENT2
_ ASEGMENT3
` ASEGMENT4
a ASEGMENT5
ASLOPE1
ASLOPE2
ASLOPE3
ASLOPE4
ASLOPE5
AXISMID
BENTER1
BENTER2
BENTER3
BENTER4
BENTER5
BENTER6
BSEGMENT1
BSEGMENT2
BSEGMENT3
BSEGMENT4
BSEGMENT5
BSLOPE1
BSLOPE2
BSLOPE3
BSLOPE4
BSLOPE5
CONSTANT
w LINEINDEX
LINEMAX
LINEMIN
LOTSACRS
\ VARIABLE1
VARIABLE2
VARIABLE3
VARIABLE4
VARIABLE5
VARIABLE6
YVARIABLE1
YVARIABLE2
YVARIABLE3
YVARIABLE4
YVARIABLE5
YVARIABLE6
A Variable1B
A Variable2B
A Variable3B
A Variable4B
A Variable5B
A Variable6B
YVariable1B
YVariable2B
YVariable3B
YVariable4B
YVariable5B
YVariable6B
YA ASegment1B
ZA LineIndexB
LotsaCRsB
_A ASegment2B
7("''''''''''''''''''''''''''''"
h)) + 1) &
227 * (
) -
)) / (
Z / 60) * (
227 * (
)) / (
227 * (
) -
)) / (
0) +
h) < 0
''''''''''''''''''''''''''''
`A ASegment3B
7("''''''''''''''''''''''''''''"
c)) + 1) &
227 * (
)) / (
Z / 60) * (
227 * (
) -
)) / (
227 * (
)) / (
0) +
c) < 0
''''''''''''''''''''''''''''
aA ASegment4B
7("''''''''''''''''''''''''''''"
j)) + 1) &
227 * (
)) / (
Z / 60) * (
227 * (
)) / (
227 * (
)) / (
0) +
j) < 0
''''''''''''''''''''''''''''
bA ASegment5B
7("''''''''''''''''''''''''''''"
k)) + 1) &
227 * (
)) / (
Z / 60) * (
227 * (
)) / (
227 * (
)) / (
0) +
k) < 0
7("''''''''''''''''''''''''''''"
i)) + 1) &
227 * (
)) / (
Z / 60) * (
227 * (
)) / (
227 * (
)) / (
0) +
i) < 0
''''''''''''''''''''''''''''
ASlope1B
) - (
)) / (
ASlope2B
) - (
)) / (
ASlope3B
) - (
)) / (
ASlope4B
) - (
)) / (
ASlope5B
) - (
)) / (
ConstantB
LineMaxB
''''''''''''''''''''''''''''
LineMinB
BSlope1B
) - (
)) / (
BSlope2B
) - (
)) / (
BSlope3B
) - (
)) / (
BSlope4B
BSlope5B
) - (
)) / (
A BSegment1B
7("''''''''''''''''''''''''''''"
)) + 1) &
227 * (
J) -
)) / (
Z / 60) * (
227 * (
K) -
)) / (
227 * (
J) -
)) / (
0) +
) < 0
''''''''''''''''''''''''''''
A BSegment2B
) - (
)) / (
A BSegment3B
7("''''''''''''''''''''''''''''"
)) + 1) &
227 * (
L) -
)) / (
Z / 60) * (
227 * (
M) -
)) / (
227 * (
L) -
)) / (
0) +
) < 0
''''''''''''''''''''''''''''
A BSegment4B
7("''''''''''''''''''''''''''''"
)) + 1) &
227 * (
M) -
)) / (
Z / 60) * (
227 * (
N) -
)) / (
227 * (
M) -
)) / (
0) +
) < 0
7("''''''''''''''''''''''''''''"
)) + 1) &
227 * (
K) -
)) / (
Z / 60) * (
227 * (
L) -
)) / (
227 * (
K) -
)) / (
0) +
) < 0
''''''''''''''''''''''''''''
A BSegment5B
7("''''''''''''''''''''''''''''"
)) + 1) &
227 * (
N) -
)) / (
Z / 60) * (
227 * (
O) -
)) / (
227 * (
N) -
)) / (
0) +
) < 0
''''''''''''''''''''''''''''
AEnter1B
AEnter2B
AEnter3B
AEnter4B
AEnter5B
AEnter6B
BEnter1B
''''''''''''''''''''''''''''
BEnter2B
BEnter3B
BEnter4B
BEnter5B
BEnter6B
AxisMidB
) / 2
Instructions MacB
ASEGMENT1
Y"/''
Y#1''
Y$2''
Y%4''
Y&5''
Y'6''
Y(8''
Y)9''
Y*:''
Y+<''
Y,=''
Y-?''
Y.@''
Y/A''
Y0C''
Y1D''
Instructions PCB
Line Chart
Line Chart
Line Chart
Line Chart
General:
Everything in this file is stored in a single record. No globals, relations, or scripts are used in any of the demo files, allowing all the calculations to remain stored and indexable (this particular file uses globals as entry fields and allows certain calculations to be unstored, to minimize user interface delays caused by the calculations). This gives you the greatest flexibility for incorporating it into your own solutions.
Fields:
ASegment1...5 These fields are text fiel
ds with 60 repetitions to plot each of the 60 pixels between two adjacent data points. The A series of fields is for the first data series. Since there are 6 variables in this series, there are 5 line segments connecting them. Each repetition consists of a bullet character followed by enough carriage returns to raise the pixel to the correct height above the bottom edge of the chart.
ASlope1...5 This calculation determines the slope of each of the 5 line segments. The slope is
used in case the line is so steep that there might otherwise be gaps in the line. This number is used to determine how many bullet characters should be stacked on top of each other to insure that the line stays at a uniform thickness no matter what the slope is.
AxisMid The value for the central axis, defined as the average of LineMax and LineMin.
BSegment1...5 The text fields for the second data series. You can add as many series as you want; just call them CSegment, DSegmen
t, and so on.
BSlope1...5 The slope calculations for the second data series.
Constant A calculation, always 1, for use as a relational key if you decide to link to this file via a relation. Set up another field of 1 in your main file, and you can set the Variable fields using this relation.
LineIndex Simply a global with 60 repetitions containing the numbers 1 through 60. This is necessary for all the calculations involving repeating fields; include this field and FileMaker can kn
ow what repetition it is currently calculating for, and get the right value for each of the 60 pixels in each line segment. Without this field, only the first repetition/pixel would be calculated.
LineMax A calculation to determine the maximum value of all data points in all data series. If you add any data series, make sure to include their values in this calc. The line chart draws so slow that features such as the option to manually scale it are omitted because they would sl
ow it down even more. The maximum value is used to compare each value to, because this chart is always automatically scaled.
LineMin A calculation to determine the minimum value for the automatic scaling.
LotsaCRs This is just a few hundred carriage returns, which the Segment calcs use a certain portion of.
Variable1...6 These are the values for each data point in the first series, which you must set with your data. You can use the Set Field command, a script, a relation, or w
hatever you want. To use more than six data points, simply add more Number fields and name them Variable7, Variable8, etc.
YVariable1...6 The values for the data points in the second series. You can add as many series as you want. For example, to add a Z series, recreate all the fields in this file that contain a Y but replace it with Z.
Layout:
Position the segment fields right up next to each other in numerical order left to right. It is helpful to make the borders temporarily
visible. Position the next series exactly on top of them, and so on with any additional series. Make these fields frontmost in the layout since they draw the slowest.
Resizing:
Adding or subtracting data points will resize the chart horizontally. To make the segments shorter horizontally, you
ll have to go through the fields and replace all the 60
s with a smaller number. To make them wider, replace the 60
s with a larger number and add enough repetitions to all repeating fields.
Fill in the extra repetitions in LineIndex with serial numbers.
To resize the chart vertically, simply replace the 227 in all the Segment fields with a new number. This number determines the height in pixels of the whole chart.
Y -''
Y!.''
Line Chart
Line Chart
Line Chart
Line Chart
General:
Everything in this file is stored in a single record. No globals, relations, or scripts are used in any of the demo files, allowing all the calculations to remain stored and indexable (this particular file uses globals as entry fields and allows certain calculations to be unstored, to minimize user interface delays caused by the calculations). This gives you the greatest flexibility for incorporating it into your own solutions.
Fields:
ASegment1...5 These fields are text fiel
ds with 60 repetitions to plot each of the 60 pixels between two adjacent data points. The A series of fields is for the first data series. Since there are 6 variables in this series, there are 5 line segments connecting them. Each repetition consists of a bullet character followed by enough carriage returns to raise the pixel to the correct height above the bottom edge of the chart.
ASlope1...5 This calculation determines the slope of each of the 5 line segments. The slope is
used in case the line is so steep that there might otherwise be gaps in the line. This number is used to determine how many bullet characters should be stacked on top of each other to insure that the line stays at a uniform thickness no matter what the slope is.
AxisMid The value for the central axis, defined as the average of LineMax and LineMin.
BSegment1...5: The text fields for the second data series. You can add as many series as you want; just call them CSegment, DSegm
ent, and so on.
BSlope1...5 The slope calculations for the second data series.
Constant A calculation, always 1, for use as a relational key if you decide to link to this file via a relation. Set up another field of 1 in your main file, and you can set the Variable fields using this relation.
LineIndex Simply a global with 60 repetitions containing the numbers 1 through 60. This is necessary for all the calculations involving repeating fields; include this field and FileMaker can
know what repetition it is currently calculating for, and get the right value for each of the 60 pixels in each line segment. Without this field, only the first repetition/pixel would be calculated.
LineMax A calculation to determine the maximum value of all data points in all data series. If you add any data series, make sure to include their values in this calc. The line chart draws so slow that features such as the option to manually scale it are omitted because they would
slow it down even more. The maximum value is used to compare each value to, because this chart is always automatically scaled.
LineMin A calculation to determine the minimum value for the automatic scaling.
LotsaCRs This is just a few hundred carriage returns, which the Segment calcs use a certain portion of.
Variable1...6 These are the values for each data point in the first series, which you must set with your data. You can use the Set Field command, a script, a relation, or w
hatever you want. To use more than six data points, simply add more Number fields and name them Variable7, Variable8, etc.
YVariable1...6 The values for the data points in the second series. You can add as many series as you want. For example, to add a Z series, recreate all the fields in this file that contain a Y but replace it with Z.
Layout:
Position the segment fields right up next to each other in numerical order left to right. It is helpful to make the borders temporari
ly visible. Position the next series exactly on top of them, and so on with any additional series. Make these fields frontmost in the layout since they draw the slowest.
Resizing:
Adding or subtracting data points will resize the chart horizontally. To make the segments shorter horizontally, you
ll have to go through the fields and replace all the 60
s with a smaller number. To make them wider, replace the 60
s with a larger number and add enough repetitions to all repeating fields.
Fill in the extra repetitions in LineIndex with serial numbers.
To resize the chart vertically, simply replace the 227 in all the Segment fields with a new number. This number determines the height in pixels of the whole chart.