8L2C)pJJJJ IH(ȱH:=IH[H`@HcH  $ +   I/H`JLNGȄBȄF aK  haaFF  mJm# KKJ UJ )J ۈ) ;J3ȱJFȱJGJKaȄM  aaNNJFLGJL L? &PRODOS `DaElH$?EGvѶK+`L HHLy XP LM ŠϠĠӠS)*+,+`F)) (*=GJFjJJA QE'+ '== `@ STSP8QSS8 m P o R(8RLnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!) >dMԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@LMOVE2S402KA' DATABASE# COPY.ME$33FASTCOPY.SYSTEM)VNZ [*LAUNCHER.SYSTEMG,b$ b1 PRODOSW#Bb  SETTINGSy$ c SYSUTIL.SYSTEM{c% c% UTIL.0~Qc, c, UTIL.1;yc c UTIL.2 c. c. dDATABASEu#' #' '*AUTORECALC {wT-H.FORMULA.NUM &+; .H.FORMULA.TEXT""+ -STUDENT.NAMES5xT +DISK.IMPORT:{T (AN.INTRO> GARTD`T4MATHEpT5-FORMULA.DATESGB~xC+FORMULA.NUML~`C,FORMULA.TEXTQ ~pC/H.FORMULA.DATESW0+7 %DD/  ( #Entryory 1 MultiplierResult45678Entry Multiplier2.4dudes3.81dudes4dudesEnter a number in Entry^BO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===this file.ry in Formula.Dates and press OA-` to read aOMThis is the help file for the Formula.Num Data Base. Place the cursor on any LJcategory in Formula.Num and press OA-` to read appropriate info from this file. NumberDataMKThis is the orig  inal data used to demonstrate the numeric functions. It is PNsimply a list of numbers. Feel free to add as many new numbers as you please, NLespecially in those cases where the usage of a function may not be entirely clear.<The Numeric Functions are found on page 175 of the manual.<The Special Functions are found on page 177 of the manual. Absolute2@Abs will return the absolute value of a number.Usage: @Abs(Numeric)PNAbsolute value, in layman's terms, means the value of a number, regardless of MKa prefixed plus or minus sign; the positive square root of the square of a Knumber. You math nuts know this function makes negative numbers positive.9@Abs(123) will return 123. @Abs (-123) will return 123. SquareRoot,@Sqrt returns the square root of a number.Usage: @Sqrt(Numeric)/@Sqrt(4) returns 2. @Sqrt(10000) returns 100.Ж MaximumJH@Max returns the largest number in the list. The number of arguments is #limited only by data-entry space.(Usage: @Max(Number1, Number2, NumberN)@Max(1,2,3,4) will return 4.Ж MinimumKI@Min returns the smallest number in the list. The number of arguments is #limited only by data-entry space.(Usage: @Min(Number1, Number2, NumberN)@Max(1,2,3,4) will return 1.ЖSumKIReturns the additive sum of the numbers in the list. That is, all of the .numbers in the list are added to each other.(Usage: @Sum(Number1, Number2, NumberN)@Sum(1,2,3,4) will return 10.#An equivalent formula is 1+2+3+4.Ж Average 1JH@Avg returns the average of the numbers in the list. Optionally you can :choose not to average numbers in the list equal to zero.0Usage: @Avg(Number1, Number2, NumberN, Option)NLIf Option is set to 1, zeroes will not be included in the average. If it is $set to 0, zeroes will be included.F@Avg(3,6,9,0,0) will return 4.5. @Avg(3,6,9,0,1) will return 6.LThe equivalent formula is (3+6+9)/4. The equivalent formula is (3+6+9)/3.;This is an example of counting the zeroes in the average.Ж Average 2JH@Avg returns the average of the numbers in the list. Optionally you can :choose not to average numbers in the list equal to zero.0Usage: @Avg(Number1, Number2, NumberN, Option)NLIf Option is set to 1, zeroes will not be included in the average. If it is $set to 0, zeroes will be included.F@Avg(3,6,9,0,0) will return 4.5. @Avg(3,6,9,0,1) will return 6.LThe equivalent formula is (3+6+9)/4. The equivalent formula is (3+6+9)/3.EThis is an example of excluding the count of zeroes in the average.ЖRoundO@Round returns a number rounded to a user-specified number of decimal places.&Usage: @Round(Number, DecimalPlaces)PNIf the digit to the right of the number specified by DecimalPlaces is 0-4, no Dchange takes place. If this number is 5-9, it is incremented by 1.PN@Round(1.2345,2) would return 1.23. The next digit to the right was 4, so the 3 was left unchanged.MK@Round(1.2345,3) would return 1.235. The next digit to the right was 5, so the 4 was incremented by 1.Ж Integer2@Int returns the integer portion of the number. Usage: @Int(Numeric)LJThe integer portion is that portion on the left of the decimal point. The Cdecimal portion in truncated; the integer portion is not rounded.@Int(1.99999) would return 1. Decimal>@Dec return the fractional or decimal portion of the number.Usage: @Dec(Numeric)KIThe fractional portion is that portion to the right of and including the decimal point. @Dec(1.999) would return .999. Inverse*@Inv will change the sign of the number.Usage: @Inv(Numeric)CIt makes positive numbers negative and negative numbers positive.0@Inv(-5)will return 5. @Inv(5) will return -5.ЖCurrentRecNum7@CurRecNo will return the current true record number.Usage: @CurRecNo#This function takes no arguments.KIThis functions returns the true row number used by AppleWorks. If Record FDSelection Rules are being used, the row numbers returned may not be /contiguous, as not all rows may be displayed.Ж CurrentRowK@CurRow returns the number of the current row as displayed on the screen.Usage: @CurRow#This function takes no arguments.HFThis function returns the displayed row number irrespective of Record LJSelection rules. Even if Record Selection Rules are being used, the count will always be contiguous.Ж IncrementB@Inc will increment with each record by a user-specified amount.+Usage: @Inc(StartNumber, IncrementNumber)MKThe first record displayed will contain StartNumber. Each record displayed 4thereafter will be incremented by IncrementNumber. PriorRecordI@PriorRec will return the contents of any category in the prior record. Usage: @PriorRec(CategoryName)MKIf the first record is active, 0 will be returned. This function will then KIcontain the contents of the user-specified category from the last active record.OMThis can be used for running totals by adding a current category (Amount) to IGan @PriorRec category using itself (RunningTotal) as the user-specifed category:DAmount RunningTotal --> @PriorRec([RunningTotal])+[Amount]---------- ------------1.00 1.002.00 3.003.00 6.004.00 10.00ЖTotalRecordsH@TotRecs will return the total number of records in the current file. Usage: @TotRecsJHBy using the "Update empty categories only" option you can keep running PNtotals of the number of records in your file. By subtracting these totals you Acan count the number of newly-added records in any given group.ЖIfOM@If is used to to provide one set of data if a condition is true and another (set of data if the condition is false.5Usage(@If LogicalEquation, DataIfTrue, DataIfFalse)MKDataIfTrue is returned if LogicalEquation evaluates to anything other than Bzero. DataIfFalse is returned if LogicalEquation evaluates to 0.(The logical operators you can use are: = is equal to <> is not equal to < is less than <= is less than or equal to > is greater than" => is greater than or equal toLJ@If([Category1]="M","Mr.","Mrs.") will return the text "Mr." if Category1 HFcontained the letter M. It would return "Mrs." if Category1 contained #anything other than the letter M.NLYou can use text or numbers in both your logical operations and in the data #you wish this function to return.JHThe @If statement is not very intelligent in that it cannot distinguish NLwhether the categories you are comparing contain numeric data or text data. KIUnlike the AppleWorks spreadsheet, all data base data is stored as text. JHLogical comparisons assume that your categories contain text data, even NLthough you mean for it to be numeric data. As a result, your @If statements OMmay not return the results you expect unless you force the comparison to use numeric data. PNFor example, assume the category "Data" contains a "1". It's easy to think of IGData as being numeric because the formula [Data]+1 will result in a 2. OMReally, Data is text; TotalControl sees the "+" operator and knows you meant -Data to be a number. Consider this formula:(@If([Data]=1,"Equals","Is not equal").HFThis formula will return "Is not equal", because text (Data) is being 4compared with a number (1). Consider this formula:*@If([Data]="1","Equals","Is not equal").KThis formula will return Equals because text is being compared with text.OMTo compare numbers, use this little trick- add zero (0) to the category. For example:*@If([Data]+0=1,"Equals","Is not equal").MKThis formula will return Equals because you are now comparing numeric data OMwith numeric data. The "+0" forces TotalControl to consider this term on the OMleft side of the equal sign as numeric. Similarly, to compare two categories as numerics, use7@If([DataOne]+0=[DataTwo]+0,"Equals","Is not equal").MK@If will also return results that can be used as numerics. For example, if Kthe category Data contains a 1, the following formula will evaluate to 5.@If([Data]+0=1,1,0)+4ЖIfDataHFThis data is here to demonstrate an important point regarding the @IF "function. See the next category.OMTry this totally controlled, TotalControl-unrelated problem. Imagine you are PNon a game show. You are to choose one door from among three doors, being able PNto keep the item behind the chosen door. Behind one door is $100,000 in cash. PNBehind another door is a copy of TotalControl, and behind the other door is a NLcopy of DoubleData. You do not know which "prize" is behind which door. You NLchoose door #1. Your host tells you it's a good thing that you did not pick PNdoor #2, because behind it is the copy of DoubleData. Your host now gives you 7the chance to stay with door #1 or change to door #3.EShould you stay, should you switch, or does it make any difference?OMHint: You should switch. It really does make a difference. The proof is left Hup to the clever reader. (Set up an experiment and track the results.)RBO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@If([Data]+0=1,1,0)+4tains a 1, the following formula PNThis is the help file for the Formula.Text Data Base. Place the cursor on any MKcategory in Formula.Text and press OA-` to read appropriate info from this file. TextDataKIThis is the orig!#$%&'()*+,-./0123inal data used to demonstrate many of the text and logic 9functions. It is simply a list of first and last names.9The Text Functions are found on page 174 of the manual.:The Logic Functions are found on page 176 of the manual.ЖGenderGEThis is a list of codes to signify the genders of the names found in @TextData. It will be used later to build titles out the names.Ж Upper CaseNLThe @Upper function is used to convert every character of the data to upper case.Usage: @Upper(String)Ж Lower CaseNLThe @Lower function is used to convert every character of the data to lower case.Usage: @Lower(String)Ж CapitalizeOMThe @Caps function is used to convert the first character of every word in a LJcategory to upper case. All other characters are ignored and are returned unchanged. Usage: @Caps(String)>The usage @Caps("the leDeaux School of Cooking") will return The LeDeaux School Of Cooking.LJIf you want to capitalize only the first letter of each word changing all .others to lower case, use this construction:<@Caps(@Lower("eVEry gOOd BOy doeS fINE ALwaYS")) to return"Every Good Boy Does Fine Always.ЖFindJ@Find is used to find the occurence of one string within another string.FUsage: @Find(SearchString, StringToBeSearched, Start, RespectCase). PN@Find will return 0 if SearchString is not found in StringToBeSearched. If it NLis found, the position of the first character matched in StringToBeSearched is returned.NLStart is used to specify the starting character in StringToBeSearched to be matched.NLRespectCase will differentiate between upper and lower case if set to 1; it will ignore case if set to 0.QO@Find("a","DAN",0,0) will return 2, since "a" in the second character in % "Dan", and case is being ignored.NL@Find("Dan","John Smith",0,0) will return 0, since there is no occurence of "Dan" in "John Smith".ЖLengthPN@Len will return the number of characters in a string (its length as measured in characters).Usage: @Len(String)J@Len("ABCDE") will return 5, since there are 5 characters in the string.ЖLeftMK@Left will return a requested amount of characters starting with the first ?character on the left of a string working from left to right.Usage: @Left(String),@Left("JEM Software",3) will return "JEM".MKNotice how the the formula in the data base used @Left, @Find, and @Len to NLreturn the first name out of any name in TextData. The first and last names must be separated by a space.RightNL@Right will return a requested amount of characters starting with the first @character on the right of a string working from right to left.Usage: @Right(String)2@Right("JEM Software",8) will return "Software".NLNotice how the the formula in the data base used @Right, @Find, and @Len to MKreturn the last name out of any name in TextData. The first and last names must be separated by a space.IfOM@If is used to to provide one set of data if a condition is true and another (set of data if the condition is false.5Usage(@If LogicalEquation, DataIfTrue, DataIfFalse)MKDataIfTrue is returned if LogicalEquation evaluates to anything other than Bzero. DataIfFalse is returned if LogicalEquation evaluates to 0.(The logical operators you can use are: = is equal to <> is not equal to < is less than <= is less than or equal to > is greater than" => is greater than or equal toLJ@If([Category1]="M","Mr.","Mrs.") will return the text "Mr." if Category1 HFcontained the letter M. It would return "Mrs." if Category1 contained #anything other than the letter M.NLYou can use text or numbers in both your logical operations and in the data #you wish this function to return.JHThe @If statement is not very intelligent in that it cannot distinguish NLwhether the categories you are comparing contain numeric data or text data. KIUnlike the AppleWorks spreadsheet, all data base data is stored as text. JHLogical comparisons assume that your categories contain text data, even NLthough you mean for it to be numeric data. As a result, your @If statements OMmay not return the results you expect unless you force the comparison to use numeric data. PNFor example, assume the category "Data" contains a "1". It's easy to think of IGData as being numeric because the formula [Data]+1 will result in a 2. OMReally, Data is text; TotalControl sees the "+" operator and knows you meant -Data to be a number. Consider this formula:(@If([Data]=1,"Equals","Is not equal").HFThis formula will return "Is not equal", because text (Data) is being 4compared with a number (1). Consider this formula:*@If([Data]="1","Equals","Is not equal").KThis formula will return Equals because text is being compared with text.OMTo compare numbers, use this little trick- add zero (0) to the category. For example:*@If([Data]+0=1,"Equals","Is not equal").MKThis formula will return Equals because you are now comparing numeric data OMwith numeric data. The "+0" forces TotalControl to consider this term on the OMleft side of the equal sign as numeric. Similarly, to compare two categories as numerics, use7@If([DataOne]+0=[DataTwo]+0,"Equals","Is not equal").MK@If will also return results that can be used as numerics. For example, if Kthe category Data contains a 1, the following formula will evaluate to 5.@If([Data]+0=1,1,0)+4Ж Concat 18@Concat will append all the strings found in the list.)Usage: @Concat(String1,String2,StringN)9@Concat("All ","is"," well") will return "All is well".OMIn the data base this is used to combine a title based on the gender code to the last name. Concat 28@Concat will append all the strings found in the list.)Usage: @Concat(String1,String2,StringN)9@Concat("All ","is"," well") will return "All is well".KIRemember you can nest functions to obtain the same result. Using nesting $allows you to conserve categories. Account #'This is some more demonstration data.ЖMiddleO@Middle will return any number of characters out of the middle of the string.?Usage: @Middle(String, StartingCharacter, NumberOfCharacters)-@Middle("AAAbbbCCC",4,3) will return "bbb".Colors'Some test data to demonstrate @Match.Choose-@Choose will return the nth item in a list..Usage: @Choose(Test,"Item1","Item2","ItemN")LJIf Test contained the number 3, "ItemN" would be returned. Test must be a 7number. The items in the list may be numbers or text.ЖMatchNL@Match will match a test item against the list and return the number of the %order of its occurence in the list.3Usage: @Match("TestItem","Item1","Item2","ItemN")JHIf TestItem matched "Item2", the number 2 would be returned. All of the 'arguments of @Match are text strings.This example will return 3:/@Match("Green","Red","Blue","Green","Orange") LogNums1DThis is part one of a number set to demonstrate logical functions.Ж LogNums2DThis is part two of a number set to demonstrate logical functions.ЖAnd6@And will return the logical AND of any two numbers.!Usage: @And(Numeric1, Numeric2)MAny non-zero number is considered to be true. There are four possibilities: 0 And 0 = 0 0 And 1 = 0 1 And 0 = 0 1 And 1 = 1NLTotalControl's logical operators return true or false, so you can nest this type of logcal equation:C@If(@And([Cat1]+0>5,[Cat2]+0>6),"TrueStatement","FalseStatement")ЖOr4@Or will return the logical OR of any two numbers. Usage: @Or(Numeric1, Numeric2)MAny non-zero number is considered to be true. There are four possibilities: 0 Or 0 = 0 0 Or 1 = 1 1 Or 0 = 1  1 Or 1 = 1IGAgain, logical operators will work inside of an @Or statement. So, the !following is a valid statement:B@If(@Or([Cat1]+0>5,[Cat2]+0>6),"TrueStatement","FalseStatement")ЖNot6@Not will return the logical inverse of an argument.Usage: @Not(Numeric)@Not(1)=0 @Not(0)=1DD/ )  (4678Namegory 1IDGradeTeacher..Comments Citizenship Attendance..core10.core10.core10.core10.core10!Reggie WilliamsRW111MannyLaPhonso EllisLE112Moe Dikembe MutomboDM110JackDD/  (9;<*'Triggery 1 DB Import SS Import(GradeName Student NamesTriggerNumbersTriggerType in 10, 11, or 12p@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===NGEThe files in the TOTALCONTROL directory are adapted from the samples CAon the original TotalControl product from JEM Software. It added A?category rules to AppleWorks 3.0, including formulas, imports,=?@ABC GEglossaries, etc., and was the basis for these features in AppleWorks HF4, although additional enhancements were made in the that version and now in AppleWorks 5. Formulas ========DBLoad these files: H.Formula.Dates, H.Formula,Num, H.Formula.Text, IGFormula.Dates, Formula,Num, and Formula.Text. The first three are Word GProcessor files containing help info about the three Data Base files.GESwitch to any of the Data Base files and press OA-` in a category to EClearn more about the function being demonstrated in that category. ECAfter Escaping back to the Data Base, press OA-O to see the actual formula definition. AutoRecalc ==========ECAutoRecalc is a very simple file demonstrating how the auto-recalc DBcapability can automatically recalculate a record when a specific GEcategory is changed, providing Spreadsheet-like capabilities. Add it 7to the desktop and follow the on-screen instructions.Disk Importing==============B@Add the "Disk Import" file to the desktop. Follow the on-screen GEinstructions and it will demonstrate importing from both a Data Base IGand a Spreadsheet on disk. Use OA-O to see the actual rule definitions ,in the DB Import and SS Import categories.Miscellaneous=============ECLoad the Sample and States files. Sample demonstrates various data ECentry rules such as a phone mask, minimum and maximum values, case IGrules, etc. It also uses the States file for a glossary example in the IGState category. Type the first few letters of a state in that category 2and press Return to get the postal abbreviation.$More Importing and a Glossary, too$==================================GELoad these files: Student Names, Students, Art, Math and PE. Examine CAthe Spreadsheet files and notice that an ID is in column A, with HFgrades in column C. Now switch to the Student Names file and note the 7ID category, along with Teacher and Grade categories.IGSwitch to Students. Place the cursor in the ID category and press OA-G CAfor a Glossary list of students. Choose one and observe that the ECrecord suddenly becomes much more filled out. Press OA-Z to switch GElayouts and try it again. One thing different from the "Disk Import" HFsample is that the Class categories are not absolute. In other words, HFAppleWorks looks in the Class category to determine where to look for @the grade. This allows for extremely flexible Data Base files. CA1NINIP nSAARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeRW1Williams, ReggieBDM1Mutombo, DikembeC+LE1Ellis, LaPhonsoC CA1NINIP nSAARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeDM1Mutombo, DikembeALE1Ellis, LaPhonsoB+RW1Williams, ReggieCsDD/   (FHIJ) * + , - . / 0 1 2 3 4 6 Datesory 1 DateToJull JulToDatee DayFromJull MoFromJulll YrFromJulllTodayymJull`%Read anTimeeymJulut applicatTimesatamenDates TymeToNumenDatesީ0DaysBetweenDatesih DateInFutureates !IntosetutureatesChoose8|LM Joinat (6Lǀ  ˍDatesٍ DateToJul2͍ DateToJul̍ DateToJul΍ DateToJul  ՍTimes ˍ DateToJul ٍ DateToJul100001 .( DateToJulȍ DateToJul771@:IntSunMonTuesWednesThursFriSaturChooseday1991L25A001991D15A011989B28O0011:59 PM%DD/ ))))  (KMNO5 6 7 9 : ; < = > &&&&&&&& NumberDataAbsolute SquareRootMaximumMinimumSum Average 1 Average 2RounderIntegerDecimalInverseRecNum CurrentRecNum CurrentRow Increment PriorRecord| TotalRecords à L:IfDataaanother TimeOuIf_2lication disk|`ƍ NumberDataʍ NumberData10 NumberData10 NumberData NumberData103690036901 ؍ NumberData2 ȍ NumberData Ǎ NumberData ɍ NumberData  ܍25Ӎ CurrentRow%ލIfData021041234512345-1200.751 12 -1-1123.456-2.2505ABC,DD/     ))))))))  (PRSTU&%'%(%)%*%+%,%: * + , - . / 0 1 TextData 1Genderc Upper Case Lower Case Capitalize8{FinddatNol;|<| ߁LengthtNoT`%Read anLefttttek1ut applicatRightee1{` Ifddlee1 Ɉީ0Join 1 1 HihJoin 2 2  ! Account # ! ŀŀMiddle8|LM ChooseentColors|{|Matchms1ums1 à L:LogNums1ums2er TimeOuLogNums2tion disk|`And `|8 Ortީ0!׭| NotHihL/i   ύTextData ЍTextDataэ Lower Caseߍ TextData10 ҍTextDataۍTextDataFind1 #ڍTextDataLengthFind "ލGenderMMr.Mrs. If Right 0*ލGenderMMrMrs. Rightݍ Account #623-MiddleOneTwoThreeFourFive60ColorsGreenBlueRedGrayYellow֍LogNums1LogNums2׍LogNums1LogNums2 ōOr)Al AllanM 5050-01-1800Green00) Bob BrownM 4545-02-5455Blue01. Clem CalhounM 2110-03-6000Yellow10, Danni DanielsF 2550-04-2545Red11( Esther EasterF 1300-05-0505GrayAO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===only' to Yes to prevent unwanted updating of the curreMKThis is the help file for the Formula.Dates Data Base. Place the cursor on MKany category in Formula.Dates and press OA-` to read appropriate info from this file.ЖDatesLThese are simVXYZ[\]^_`abcply some dates- one famous, one onerous, and one meaningless.LJWell, perhaps not meaningless to you, since there is a 1 in 365.25 chance 0that this was your birthday several years ago.MKAdd your birthdate in record number four, and use the correct year, unless MKyou were born in the 1800's; then you have earned the option to choose any 1year you please! Add as many dates as you wish.*These are all in AppleWorks date format.9The Date Functions are found on page 173 of the manual.Ж DateToJulMKThis formula converts a date into a Julian date. Julian date number one is MMarch 1, 1920. Julian dates increase sequentially with each succeeding day.Usage: @DateToJul(Date)JHTo convert a date to Julian, the date must be either in AppleWorks date 8format or in a text format recognizable by AppleWorks.Ж JulToDate+This converts a Julian number to a date. Usage: @JulToDate(JulianDate)MKThe date can be one of several formats. The possible formats are listed on page 174 of the manual.Ж DayFromJulDThis will return the number of the day (1-31) from a Julian date. Usage: @DayFromJul(JulianDate)OMThis is useful for making your own custom date formats, such as a date stamp in the form of May 13th.Ж MoFromJulFThis will return the number of the month (1-12) from a Julian date. Usage: @MoFromJul(JulianDate)9This is useful for making your own custom date formats.Ж YrFromJulBThis will return the number of the year in a four-digit format. Usage: @YrFromJul(JulianDate)PNIt will return years in the 21st century, for example, @YrFromJul(30000) will return 2002.ЖToday<Returns the current date in the current AppleWorks format.Usage: @TodayMKIf you use this for date-stamping, set the option 'Update empty categories @only' to Yes to prevent unwanted updating of the current date.OMIf you do not have a system clock, it will use the date you entered when you started AppleWorks.ЖTime<Returns the current time in the current AppleWorks format.Usage: @TimeMKIf you use this for time-stamping, set the option 'Update empty categories @only' to Yes to prevent unwanted updating of the current time.ЖTimesKIThese are times used to demonstrate the TimeToNum function. See the next category to the right.OMSince we don't want this screen to appear sparse, let's talk about something LJtotally unrelated to TotalControl. Have you ever purchased a product, and LJhaving observed the total amount were surprised to find it contained only LJdollars and no cents (xxx.00)? You were surprised because this happens so OMrarely, yet you have an equal chance of getting .00 as you do of getting any PNother number, .49 for example. The chances for getting either number are 1 in 100.NLThe reason you rarely see .00 is because you have a 99 in 100 chance of not KIreceiving the number .00. (Editor's note: What Dan is forgetting is that OMretailers tend to price items a penny or two below an even dollar amount, so OMtax almost always bumps you past the magic .00, making the chances less than "1 in 100 in our consumer world.)Ж TimeToNumNL@TimeToNum will convert an AppleWorks time format into an integer between 0 and 1439.$Usage: @TimeToNum(AppleWorks Time)PNThe integer returned represents the number of minutes past midnight. Midnight itself is the integer 0.J12:00 AM, or 00:00 for you 24-hour buffs, is converted to the integer 0.L11:59 PM, or 23:59 for you 24-hour buffs, is converted to the number 1439.OMUsing this function, you can calculate the number of minutes between any two PNtime fixes. You can start with midnight, but you cannot end with midnight nor Dcan you cross midnight between your starting time and ending time.OMTo find out how many minutes elapsed between 3:04 pm and 4:01 pm, place 3:04 PNPM in the category StartTime and 4:01 PM in the category EndTime and use this formula:/@TimeToNum([EndTime])-@TimeToNum([StartTime])(To determine hours, just divide by 60.DaysBetweenDatesPNJulian date math allows you to find the number of days between any two dates. PNThis is useful for billing, time management, and just plain fun. If you added PNyour birthday in the Date category, you can see how old you are as counted in days.F@DateToJul(@Today) is a quick way of getting today's date in Julian.DateInFutureLJJulian date math allows you to add any number of days to a date, and then *determine what that future date will be.NLFor example, on a payment list, knowing you invoice date and payment terms, 3you can display the date on which payment is due.ЖIntOMThis is part of a formula for calculating the day of the week for any Julian Hdate. Don't forget to see the next two formula columns in this series.Usage: @Int(Numeric)PNThis formula calculates the day of the week as a counting number based on the Julian date.ChooseLJThis is the second step of calculating the day of the week for any Julian >date. See the previous formula and the next formula as well.2Usage: @Choose(Position,"List1","List2","ListN")LJIt takes the number we calculated in the previous formula and returns the Gprefix of the day of the week. For more information see Formula.Text.ЖConcatMKUsing the previous two columns of formulas and this final formula, you can Ldisplay the day of the week for any Julian date supported by TotalControl.)Usage: @Concat("Text1","Text2","Text3")HFThis formula appends the word "day" onto the prefix calculated in the previous formula.OMIf you are paid on the 15th and 31st of the month, you can now see if payday ;falls on a weekend. For more information see Formula.Text&STATESf%|~ PEjT5(STUDENTSlT6NUMBERSpv~n0&SAMPLEr|GD D/6   Namesory 1Abbrev.tuff....eghi........ AlabamaAL AlaskaAK ArizonaAZ ArkansasAR CaliforniaCA ColoradoCO ConnecticutCT DelawareDEDistrict of ColumbiaDC FloridaFL GeorgiaGA GuamGU HawaiiHI IdahoID IllinoisIL IndianaIN IowaIA KansasKS KentuckyKY LouisianaLA MaineME MarylandMD MassachusettsMA MichiganMI MinnesotaMN MississippiMS MissouriMO MontanaMT NebraskaNE NevadaNV New HampshireNH New JerseyNJ New MexicoNM New YorkNYNorth CarolinaNC North DakotaND OhioOH OklahomaOK OregonOR PennsylvaniaPA Puerto RicoPR Rhode IslandRISouth CarolinaSC South DakotaSD TennesseeTN TexasTX UtahUT VermontVT VirginiaVAVirgin IslandsVI WashingtonWA West VirginiaWV WisconsinWI WyomingWY[^rb CA1NINIP nSAARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeLE1Ellis, LaPhonsoA+DM1Mutombo, DikembeARW1Williams, ReggieADD/  ))))))))))))))      (kmno2))J)>)'''Namegory 1IDGradeTeacher..Comments Citizenship Attendance.Class01Score01Class02Score02Class03Score03Class04Score04Class05Score05Class06Score06Class07Score07Class08Score08Class09Score09Class10Score10 IDName Student NamesIDNameID Student Names!IDGrade Student NamesID#IDTeacher Student NamesID Class01IDClass02IDClass03IDPEMathArtMathArtPEArtPEMath CA1NFNFP nS $@Ten &@Eleven (@Twelve(c) 1991 BrandDD/      (P`qst#Name- no rules)Phone- mask nostore MinMax ValMust fill MinMax LenStatex Len UPPER CASE ListnumbersASE1 80)ead anCapstalizeCAP TEXTcat() -9999amesAbbrev2NamesAbbrevStatesP` Applied Beagle Bros Call APPLE"Quality Orders(800) 777-3642šHmCɄ@TIv@ bs ,FPPQHd ^B; lm6̄cu$j:dHAe  -j0@b'Ҫ!d"@1  D2$ڀh1,C F" ,CyDk*tl&dk@]N%LT#pk :S6 |J7FRPj;!F it2!`XYPB%Țjl%v rhiסLP.1h&P+8̠Z#.4m :f4B|(/pJ `%( KT A"uB70_$Sr w0x~tK*fxVIJ^qh|%Ls ,"/0!bC >l 7@%0qqcf.^F#QљףFJ=D N("|nTT;"Z!tCc@;bNs(+ n`fkEh"ⶂ |( Ջ!41@+N$q=[ql NImyXbc(m%@*j1b(Q?~0;_hEJBI3Q~h`a[(?<-Dx@\A7W rp > Hal@x(mxVؿ?򀠚-psx k@PY)l @(dHdXH\h7؂\&t-PAHZ恇cH @r؂dx؀dpJe x.kXdCaKaqaQ8P@H @?h8Qc` H2QXdR)*&-QxPԈV@FCF<h@Pc&.1D 82ޘ G=Zm ]$Uȕ"Jx4T`B0 '@(Љ5A2ҍ2@4FxpG+8.a(,`tp"; c~"U >/1> VJFah <DZJ՗]IB~K5D+F:%,eXR`@2pG`( $.bB TT\7hvxh+Ql4HP  H<+"B"(-@(ChGpy u1 }ºxb*X8E2`F+[l A"DK)@Cmko+[ַ_0t$(h׊Ū [,0G,6bAUl1jQ⋸d@ EhƁbx'Tыbmi -"0 G T И3g\ `F zB8DD5S>N 0(fHu E> M7 4}:u!>! ̮&*يWk)@2! Ex" gT;`Dn$zP Њc H C2 ^rS1 G ̓1H Pp4buH\񽀭7K D݀R衁#w*` iS0dn;2$|lL# BġӡQV >ll0p!RO)o*֞`ts١sXP^/i'<q\ň$lF4uH@,6 ( @; %  j ˄ *fL@D8@$X@D@sZ@dX@&@'`TH&`(&p`y&!`?(&#`8&$`BXCxʛ`|0< FL $%lBLF8@Ķ$ z7Ǵb xpB9G200癎6 ׈ ut+Gp @ö3_M8@ ٠ ` :@F 6H8 05d8<٬ۄ2h ď¨NZŁKK׸BĉIBp3LBJ3GFl (=C}E\QFo4L} 4g 08I4Iָ()ƪOɖAYNE+3|!AJ.76Kt*M)DЀjhPRJъBZ5 2 F b ě8Z!*@tТGkwFF5DuL < x!Y&6wf-4$q,@BjN x 4CBT vР(u^T)% BKpB0nK60(Dm`P2@a2>pA!"6b T82> '`E,H XTx!DJ#'=ɗYL  O N8]PJH2LXD5$rm#褀d%шx $ !"I (JA[4Pz?p3+|jO2^lOŪ5§8+091&B%$ @LA) 0$8 APhhms. /Bȅ;eϙtvn XK0 @^X@+ 9e@$"Mk[V Ci2 bt'tvHȺ(A {ɇ~}BqqZڅG BK2Lhzl&XhH= хdY`BdlDR{g zs]A +$ !Vػ0$V0e 2)Y @ @ ~`@ FvFQJ(J(}ǻɄ 0!klKlK f07 B"<1stLj*0l80TPFPcVf`f8 dp d"`B`h#pF@&h l=L,^B~5B)B)6(3TDV؇(`D)@LĒFVP >3xDHЀT:gL ixV0vpn4BXlǀ P'Kz h00`⃧ >8:3h/pa(#Vxt@Mh)M(McCbۇ)b Q I[`Z}lF t@H CZ5g+^ Qid xЁWP )H  U`\HPEX EHh\V`JJI-8^8JdxfHʦ-]K4V(cp̷ܓFH,eK"HW0p(X_D V͹؄Mh.2LXQxP\FE`O,i0hPh M h"HR0 eJH#S$0xF 3%;m!OS?HK `5 m߃Fڙ TBPM/k2$X3Y*cPh8k82&K48  /XN'ãHi )3~ hO?HGFhK&CUmpITɒ, yeIIl nɝD1J*1IPHQP`2?R]@ӇTFTPFȐFF8XW)V*p&Q@PG=FT *hJ?ܓTf9s,|V@H>2 j(Z)؉ g&P'@0~t0Th(XzH6z0G0(")ej~(Xh|0`@ȁRFǺm~\X@eI[XܧF}R-=H@<ьP H JC)X(Q@XpV dLѪʀ`R(i`z$M9M4Q]ϟL -eG4KhЦRE  "1=)M)TS^ͺUSׯaǖ=[Lo;f[|dG$d344`ftPճWsR; d`iH%D,ŽVAPp '#XpX/|"L`W 5Hφ3фL@`#]tCHxh頑Lv_dh`hRx4hT^hChp@ V!В i$P>&\!.@x# &>;UK## a"Lr& Z0, "D&Yg,( `|!/d`|A?SPdl!/A4"@8("0g`us^eӶ 5Rᡁpm`"HǁR$i@ H WzؙآWЍv.XX%dw: :-I@ bPp1k`" GdP Va@`顓a\C @psѠieAxZI hHĎTl^!1j܀aWNNOP\# yIFAű]!fJRgt&^f\pw|~|!|@-|A|@H|(Y|_| Ƈx|LJ||,!@vA U=h |ЋbL>"` 2EkCG&t/T8@G…? Ц  Q'@+AÆy!SF䐆Th/ք)C SF Uc@FpфЈ4*#dZ# I V@*f@A+d,< (BLDh`B#ECvk1PxHAЈYB HE5 a@( &o%0b~lYPn,L1ᣍj-fGґ<9zNT2`@"D$8zd)@2AH heyF95ؖ4"JN#&F@ `\)j jP@X(~f\ ! ̹&3XdЀ1D vNE)v\C*,0LjQԍHA#UXEAఀV KH#8Qm"@@` [mV!!X«(([f\4#V:XӘC\K։!m2ҫ-8B9`r#`P;``0HL@ 1 4A-E*>һJn-RS"#q,D8`4Lqm8!/,J\v` 7 8#(D-@70 Z#$&J=HP;d$0$+L Xk(BHXA0!HM/ vyBDh]D!lab7C }Zh!A$)/ u+4@+ȌBn>1ID}` =وzsSHaY"kw>p7{XvRRHKE ڍ*u!FaB$Ofv|o[SG+Ίi's'RP\}CpD'L >I+^[+(Gʃ_=,N4Q솇ZuyW/[CG++B=O$XwJӝNDR=Z1 >> <9xXFh)# h"Ce'xPĢFx!h,ekSReUX?V :C:kӏk 4%  (V(Ahf0%H8AhpVd HĀv0%Ђ & ,h˯fJ!k; hÐ/Ӎw-Hz4w6qVZc=4FHs 9 >0Up\k^.7ȇVȃh?h0h#`TB^#^ԁTlU 4*E^i(F`ԇ 􃴨PhЇVȢF]T"Hv$'p 8/.GVHEÚ(ĂF3H>(FX !xhWH^tH0 p//@/wj**@h@wIWI!8zd`+ hF])V`"lHdP2`'0dXP#0& TD-X%lЍ H,ܬf8 ;kсU F0Jxhh(J{ʧH)x[J^pk(W #`Hm4ևH@vIURVV&JW$p@pLV @8]S9H=,0U8E PPP&P0P9PCPLPVXڦeڻ`ڨuکeZ$pEXlLѼ$(Oho0O(O(O@w([@T[~O L:(P FݒЛD g H%9t炤WQdMV6xJժԱ\ֲgqZ1*@Xt/ ~;KQan`5 lA ZX$dEp/ڝj'@*LgFRQT#8#LXN0] V3S) w;v ZrF8f}F7,\QbqĿVHZe;FIL(h(:RtZY%gsfh >hfqVN!U 4Rh H  w|ɝ'Z"6"XhłT aU@x#"V<>R(DVࣝ>RP ML@0b,@=DF"DwlOP$tRap2 ,IH8dꁇd&d1GA`2Z957xAJI%9 =(d1 &@`$v[qd1 &Ǩ{MǨ&eigd+k)UX`VP,pEXQF,8V)%FAIq)N`X@gl`&RRƕ܀SlUhw@ &2UCD1Fh DHLFRH! ѰaFf[}UFС`Cc)$Z;n@dh\iY$Xi̡ڼ PjFV2Y9!Zhr]hzcbmAPwlEf W@PAZy1&Z9$ }vvp#'F̏ ^臐[ HNTUP@#JHFxb}E+ѧX  1t+0H sLe~b$-8~ؒ@0  Ѕ)C< aH\@4ix << eC̐e`x\ r C7a p,n_<E.SP#'CrhB耆7SC<( nH2 0KipJԢΠ!ȡ a8egpu+A@,Rgbʠ(m%9/&`mE2` cf@' yP)P9 oX00, q2,P6x C70Ԓt&9N: \',A9Fs H@p0́h0@`3cCg `zdJ1x t@@AІYqli:a.#bz1* oȠ*4.igް96ԭcp `1e),Qnl:ZM@apC ǿ\ VXi`#Ⱥ7UPqZ0n/E,:4A DmWLf'A璠 ]4q@FbMˬ+O@5B9Amu8Y)T2ppؖU: 27 5'Nl Q"UB;4*`;8t A HJOu8pk$lgA+Z!Xkbܒ#06ӻD^ж=U,fi:<@mxʋlhGI׸c$g4?{#4U&7M s0t@A/|F@}M`o 1F`Z Vh\O7#6h4 &Q*pB2\gBZCN9l<:kr 0jn{Ҭ[o2QXPց Zi0vmjt9Pp` (cCO6 jԓC@v Xjvnv%ذB]?phAP@E;@D`?HTiT3L (V WU'#.MD,V@/_,%Wpq=?9|Xow%gm@bo@jq@ms@ThPg R&xV) =)=ɠD%U`VScmex؝|pXm݁DDxD;0:97ظk& 9ZAJ"*=SHPPV0 E'FzR `BFQ)C Z8W {%1&B2<$@*,$A2$ @- E*& DN `$K Dv/`lY+VIdEHvo"CK& FWuU¬%S Ń>Q L$h>w +Q"1XU+2|gO!XU< @Р- ej5+րFwsՄSɮ> 5ATٰ d,7lA F(5a"E@(g hpg5r@fw w8^`k@%XeX"QhPFH"eZ ]kSI$ň+T !LqTWaE^UF&$ K>3d ÕK{'!, A  FZ B4iB6K MQYwXդM"Q#x RI%ASfRHIA00Q08IM=Exs )$^ЩYPiESf.`P!݃#MMxL `IL 'iXt gA@dy DO 5>HVb"FqƆtgLz DDr<X9[}Ҝ hheS$J@#شH@x$1?"!:E&M`iF(/F fhpСV.@x*(x^ (&h"y2dLL#w "](ă.%'@b0, D2 Ԡ/ <{PGcDb5OPRʄ_8 (bG*@!ȋGcD2,z$hblSH: 5HdtP*SUG`@Di@Ab4#H4x7P @0+ap@P'L x@#C vm豍HoXh"ЀEM 숹w!h9 ) T EK!aPY$WjxH2=RCh:D9WNP#tX#pM4 D#pN4b7h_ q`Ux{@:E#<sïK G$wh֣ w`-Gt#IJp{{{HHFJd{cDQF vJ>BL*Ep0),I,d(IFKBꠐa&0 U3E0E2sul2Ex2? EHGK8%QF0KDpC(XHT؀fﰔM7V"N(15uP&ʵ.Vь/Q B\gxhى,6\vFP2LPBqB1A>&J)x8 hv8ABaCm.6tKypEmEThT&؄KQNX }HȗHh28R3aBXX`(H娔`7 87&(LLMwńRF04 1`BQ8R dȕX1Yaa`f׌F Vk0|1xՒpWX&yъ4Qh`ohm`iK'xXp0X d+*xdOӄfWgaQȄV LHȲ))G5MZxI0 @n XwX[&XXpW S8C H۸U HW=@=hH|qh&LH)Х^8 ]e0b:`=K2w21SB+*|0)W=Het@` H@A" QHV)N00]&Q@ )xCF4şnE`@@`A(ɔB -Le+0Ƞ 0)&0; )wI N|RpՂS0e#5%X0@J)h`Q%܁6hW[1+q,@4+I8O% iD]Cc*&h@&`:2&tDjhC f V LB>q>WH I9zR66dXœAz76;3aq\H#݀/O0HO1GVfKACXhq4@ |Zbb"ü R,E,>$[3x`U@O0F< ` maHbZ` (D-PQ[r`e :] 4B0)3D h20*! &>ኾ 4 ( Cق{ ;: ' X$viGO$LFчDsԄf /&<$P9P xEO=B TD!rZxtHض:xlrL( 9Ah, PN9́$ {a`Ӊ-+J3#9qt&oɋ;Uu0d&рT@,)-h1⬵ 'JQ V8E I&gH 8 h!AGXPiApIX?9@Lx(ZS @3BFgn*xh`u ʼ¶_v1aڌ5$|;hĤT(+ ,TbXn`8cbBQЉaZߺ+)-@Lѯit,q=C"6:aXT@ا`($> W:o ɵJ*Ј%\{pHB $ĆyUAM0HhkxQ-؂dSh"hV׀ʹ0x@@ЁH@)FP^A$AHF@4@Ta`S@hI,H?p2i&z5p8GGXRȎF S8 @ , (hD{$`CW@Dw@^D9؀VP(xXdHx8V@D HAD&QhHSC^B "tDx&Th6d)Љ c9epSbK<&<920FxhhԎVȇh}xhSh׈VPfCHE6Lf*,R0wChQ_H XA` j_*@d Ʋk,P\xVIp*PUQVɆP &@Rȅ`ɝDf IB 5(H@i.&hR0pl($R f(Ҕ(8IHɕl!'<XXsd&(0,,HJ-Ѭl|($BKhxLL,l`CސL N0Nڢ\`| (H/(B/M0XȀ @dIX|J*+HI JKȅw0bЄxMaw0HX@CpN0OM NLj͎ڼMSPSx p;8tqSXvRtzS Vjl8lKWFDGȉ ȁkt HSItxRK0Fi! ,h.@9Aah (#x)/8////////@&7=r11P111X111H11p1Ї1p28222222(QU282(2؂2(2(9VA(O(b({0VH3333333P33h33( ?8W8d8{8@$@1@R@R9H"H/HyH~HP PPNPpPX^XiX~X'`7``]606X6686X66( |`h!h=hOhRYRhh!`"'*+(!8S"H'8'') M'p$$()" " #%[^kM))u0*()#Z*("', ')( &($( He&'%&Z*\'(8\͂'[$@#@ \)H!5۫Z-ۼ-޾-( p\[=*ʥЕ8߹( !^e\&ȂZ"[X[!H۲e۬5\}`#+X\&-8 8e͂%u%0)ܸM\\"\%3\P\'ȝ@ๅ eZ-5Zۺ5\)+M#}`%*(x ""'`ߩGL@%$T9*DB "IRʀ)L@$*_&LJH&E8p'$򲀔S@"JRDL_'TJJ *R% I4 d"R-/Lj5Bx0%W²!"Ɠb.QB,\[ɉ:B#*=('*x h*Oz!]t"Tr&"X6 ҨpM6-2j0V"H_'̴HA\1c)"cVmB)p@I8 ˫B(&s [xdfy L@l2*aK ?T޹= KҺDRE”""׼n_PI#W0!lfKۋ¡I /YYdj> \bDb+ˤ#xd xgRy P^"A;flÄo=F|#r.h%ܡD5&qT^" Sx*}5WHKHף`ďTD 7.oFˑYFD اR!0#Iq0E[(BRpT\)SĖ|0R }"Jkt^ OB1kkNF16</YY SEG.DBC >Z\0kt)PH#L .sMeWɈL,$a h09p@)RH!mC Xrʌy#CIZl RM:e ڶoy6iy-&oa@cȒ)Mˀp8aإF5v&7f@1-4~Q!8խAȮLPtI2u睃zvme$n攑c xR"n$zpL4 8+7r!@ /@ù3T3;2\lʘK2ڀ#;0̰0Pq0;@d<-- C:8J1 XEA " :"6ՎKD 2@ϵQ37*c`Fl墖 kfhhSnAim΍1@)S eg>@` ٌ[1A0 IN # 2 #7ʀ"RsV) eFge Am!"TA,madyZѦx0h%BRCtz1 Qx@p5@(" x<'_"QH4C;С08kDp6h bD1 BP$ 4Ap2ze5и] O0! ]HF5C)`(U8WM7ѐOX r  "X~ ֤6͇4"%<rԡ H9hqJ2?0!@=?xT w'?C+|56ˊ1 @0(!R"`W,0($H4B`Gz!P? ZcL@ #uzЋ%2C+ fx)^88@; VЈ|Ң&$/,Q>8]59LQ S4#+^ pG)>q @4 p B`B1Pp CB t`dǙaq EpЏ Ouř/o" 9Yf~ordo>Z۪$7ЁV>xЀS>#$<s00p(pj bMWn)xG 0hTARG'\(h+*9Yp ɀ#KB8(D`F/KW^(A l!7vpZYsHF!8-\0Wx^Cq06^HBQk7Y:BX?&""B "9Se k H$V>ˀROD9U 9`; A00NZVӀy6`(C@c4!dF gl +(0$=`al,BS&x"`LVFv*Jh 9&CB$jshS0+1 (^HBFX"[0x(QhAUAQd+d?`*(EM-xXK#1Q@H&~ FFG,,x-Z,"+BfP+xxdhH'% &Ot ujJ_ &`"H> ,J H x4`0 A4:jS tS\\s%x +%ӺUbJ6>*xFPlH42h E VTd|`3N?\ #(DHD"H#(Cܫ[$&Ђ1JLJZʒ)SBJ+/ x1x(tZfMc9xFI"H`"9{qS0h8#K8OX ` xThF#HChA`h@`RhC`RQRP!0-Ud?JR&+=VX5%mS('OE,m@X:2&P#EJp90%4WS ?0ÀN(Z(WLV`a#vFHG-F,`,z&x#pb F-zXL (́f hʆоˁlR`PX d1txVLPF#x\ ,ȅlU$nȅ Vrm[`(A A`seUfG W0 `'OA* }\aIA*#`ne`Xy(P&3"P!ҎV 5ꐣr\,$("SKd H<;,t;tqV*P+B%mF?BBhZ}µ@hπ9QeVdsJj&"h5 R8xFx{Fr֐QBj72`[R^(V i @ -ViF%SN@@h;F`[t HaB]RBV9FnX:qqVkfLZ[B qVl30$C,_4B+D F1,(B-:h*&Y"fV' ` &B,4;8&鸒o L. @p?mbc` h 0@tŖHEp8 [jQy@W4`$h4*P S":7@ XH! .D "h `2@+!|`(F aV'Wش"Q @@p'FԀFhhCAa @#J gE+4iE@!T(D8 !B(D9xGhx _ ZLmy -!4%-JyY ' r4xHj#B0e-A 88`BbPPA؈ /UW@H…H @cf2&8 A%h@1Q<`dR((P6 FP PJh7;)shhFN֊5M1hҎzPnd]i3JPI:&  hVNuhgF"  *K|0<`p ^Á!O Ьפ UuM-\ZZ۵bd*@0>(b-,! ) Ad'{')MGM^i$h@pmhUD-hpY͉ixv)$$ [:`H^7'HgDsPL-XPb["8G};ڀtW=mX;  7.k='Ήsg Gqu"xԉB_:蜗j_6s=guNZkς|rk]Q2 k@cʶ*K^#;13xX@-x=d ƣOuAoA5y@\L`C:WX\K| _U0R!5>ـ-`Mf8"{Ђ S,ȂًO*RG+`@Bh9#.`/e}/#Th#`ZT =htKQB@GS*i+*hv4JJPyʤpL yx` DPRe dAa FM6 Ȓ#q?vL ܰ"Q¤v2c{A0=h0͢ *@"Q(W8o0F !"ARG"@ !ke_ fy gY h9 i‹F, &x (h T 8d⯐ª9x&Z%/  \9^n,B`Vl&ldXhJ]˗\r*)B @F9O&#H FJ&xh Z@G&тJ4P%,HEW0Q :keki)K6gs& @FQ"wTQia-U@AAhB>r` 4r` BUb|_`t؂` Ρ[y梑q$ZY7R|"};j6m|'^d7 'juF p>8I(3 ud\0X%@pFX~+`t XH `3J 3iGrMTXU1` rkHBc1xP{Bmwp06փ 6\x:rs,;'o ^HJÇGQh`h1Կ&EԈ?Kd@xET0+ ;h_?Wl_EQ\Al(d@p( CVhE hPWEVEp1x+#>kP`KCp0P8BpP&@d`k@i($hiGX8FHCE@DIlD0=H pHpH`^dBQc+xpl (KH hChlLp tKx@V?dH0q, 0>tJdJoʇlBB$ ʢH(>@d 88`KPRJhK0KhUHKp@&P2d@rLrRqPbHhȆT`̈́h0KI hITRP(?LXJba \- (\h*\h@6a;x.+5+YA>V*j,\ <hPa\9iڂ0biO&CZBѭZ-nS=7\2m @ > @ P@2`8@hǒ978A9x92/%9X)*!x823H762(91:,% 92H R"`S"p2XT9%S3R#`S#C 6`KS;4B-S70mp)*M7-07(; UL20/S-+-V:)e6TҚS3տ0ȃ7TR&x;KS@EA%TCETEeYm'Vj] 67004`2p[2S?EeBuCS7ךT-3t R(`S(<%1/9W),kSښ14x7:9)6J}1mq~Ń28T*H:YR+YZVm0hY;:S~Rȼ]T<()6Ղ7x6[ů7-R]ش][y mY8f=Sxi}8]V:[~ T<=9FЙDL 3]MæL:hat!.om^ʜϙv?Yd0ɔ2lPN??4  jAIЁtx?",D4 TBxP(@a ?=t@q^0C%IR12,XzFb|@&QFH|*-'V) Q "he-{h nQR9qzhSd*RD "DsFqShAoz(eFE"h. "d6f&!i I A "FVzmF1\ xiQUpHps{y?"|#T*&f(-YuQt}׍cg8&.B0=@at"0(( Htgu k,083)cŘ#踠􊇱e10j"@(:A$6x{;Ҡc 4Z"xcKrc@`:m`6 Q"+"H%`( ӓP|>B!Z vdg 8H9k*1oz뚼+f 7Š[9&@"@c/p%XCE*( Ƞ@5Ά6Έd? gFt 04(DhE``h QZ "(- R)VъGr;pJ u@XB! a EobB/x n)4 F8 oo  iO]^schBSc@hC RȀ+lh T@*+ډ*hBڀTj(- QTH(2m$n (35W ʞݘ{Bc8m3**6c@@)hNc-[sU2I-41Q@(iB<Q+@< Hb`P!1x.#kH2ZnN* P T ex'6F! iG@ h8V8[0[k:DNTHQ:c7dBν2fd i:kCT9. jSD,`W蓞;a3c500W f6 &oIZp*T>qp>! :@!8T>9 ;2Ёx  iHAHʸ b :8'?qp7)AIA03pJ1jX3J5`Aq9B9 %PТ(KIȤB4/Teq\,Q0Q0Q`3xpBG@pFtF,DYBpE*5sDxBLD(khFt(2YRbhp[lTBElpD QE$((=(DdNڣ^B@kkkdYj 1A6pUi]1@DB2 ;/ jvbh0Ql]5nGAsL(AcB;}GņTE+vP℘BQ,k(ȴ2kPR첆/TQ`@XذIȆB p+Q9R2J(kPHHҲTWI=r8%H+kJ܁)(T(U@ CpSpKlH0W(W8:pD2.%9PQ)@Ѝ \\Cs@8cXł@mX JFDiF@ Q.s)d,0X)xVd@ǂd\Gd`dtDI&H6V iTHH%hH0J1%`A4 @E1t0p;VAj; zF؈ZZ"gfB(6\jo)wWх^TfTw|=T0tIxa$XHN]EYxs>697"h~rhڐG桕;VIFot`p裓!bi@iNk$֣$Τk%Υ% hGсd[Qw\>v%^xv&<j00B 8""AU.$`t-DsD1Ev҅GxDpwWpxH7I qns qwzy㥇ŚVpov&ѹbD9h(EḞ?߀VjgzH%BENH ux$^/na@vt DX:I+SAPR5"@Hǂ_kX:V,Q&(!J|A(E7y{:8Pyc!|Gh\ )>x@2؅h $8Ȇa X4  ("D heЉB-[Ex OPD VP&3dDszfY45⃄HF"`l (v>`D/Nh%4qAeHFpև^^, x;$ zBF;7#] 0tR(E-1h~sWiE4԰僇6G&A[f <CJ 1@8A!^ln@8xz(@-0- &\ @ *2*! MqS-PZxz%V|"K-bwః,cЫ@b h* V8ȐPG ߆.,Cz9@o+F'QHTIRi/SqVCe4iZ._J<C"NhDք0F@MPM5©xZ&2xU ǾG1akb-ו 0ΞVB$ hW@" H@p5f̄$!Ā|ކ.ɲX)WW) $C@Va4?W]Ȟ[Bw~r283$B1m[D F4V8ɶ]0n gkDe#8Ú>gB|5 , :%(<(`ڧUj-Ai4\Y`\LU B GQ~&4_Lsbኇ8܏B G TD0AfP](PAi0q ]z$h9(S`TZ|4N$ (!s( p BJyF@CJ}H! AXFjb4DI7કr=҈pyc#Z Z5nČi'o hHh5hМٳ`ΏJ&xs*ndVJ?jTgpcA#g /DRҡu@ ijQ1fn9ҥ&!ZH# \6~=@'40_ P4 f0hr$XI` p[sqE@" JDQ.+`Ê ;X+|ՙŁ";` {;&Bx3 sD;AAbxD*H#)J`؃Bꕂ8`2-$ \rpPt4"H(;pЎIxG;4Yw!~d*M#q&AF 4RTHG(;RDf3D`!I$0F;6<iDtXC@'%/X8:.pjHGc8iE%B8l0r8FIC:*Hh1A JJ$p!PG(d9YCph;n9v2 (qSrRp-+jɗ`0Wdabr(F8Ap(:Y"m#ބnh7:ˆP"<y֓H!*@iJъ࠱Ae,QIY5hl8armj#h'^%gXvxR@AX6 }l#'-y4ZmH*TD9nۈFmPn#HD j[Bhu QRì(%52Rû5G)A^۞=LUDo hB)!`~ < k8:Uz:Sí<}ڱb )4!L`'0O"tn H2G?8ip9ʁVLehD!ؑ!hGbe&88JTE@*9 r4L o,W}jD">cn=O&G`j`wV`n#F6ӆT rzhme&4 g l0)Pj?pHxn[; uXϺo p< +kZw=/9^p:}s0Jpq]V(>9I+ yPDQP*R -:i ! W~a_hWÍkYRȂ @wwWs ƻ&~X2d'm#Yx%8Vb0cGQx NpͲh >p&LxPA 2 rP7ԁG,:a`7!w@0#( ?3k0d2t26(9Q@t@ @ @61(l@"p?6H1 t(lAB8hV @kCF4H$PFH44W,Ǹ{ =d48xU`(G8HhypRF (H0IdȇI|GV|~ǀȂhHKpT%Н޿؍TXyd(sK{ -S!=~~RH(D22@# EDP pϸ- (t PWA$_AUp#!I_l¨R"Y\BBP$0_4e EHjD&>ObV&vnEO])HBR4&Ik5N(h2r5!&YcG^$@E$ H8ZT!A.Hs&/48! op@04n؈`Ё%c@Cp'& .Ђ^r> X:T#c )qRt wH& 1d n2 @>RԤ E-7mXN@4 $D p A(PR9!ZWPPҡ BC HʐWA*A ^p6g$`X[&eFz;d(l^#N*4 tVP35^K8)a͐lXiHj\U(NJյb 7aTA,OPO8)pݼT  *XڻVClτa CR`|T8+e-[>EB[4VU{p*HMԫWUHA`XA'L_:$D2ׅpWU@IMڄh^g> ^v i1(dE]e COm(:< DsV 0;\!1#E])" iȄ=с `[qN)osaNH|r&eL'>LaA" D48^e4ɠ/$&4 h_…eD@1G0~1L_YQ0yJ \ :n PHr(7YY&Yw0QKb(3#Q0(sUp rxXe>dxHX0BX̀)LH#05`[! QwBہ ts0@),lf k BVB(ZhCZ(Sh"8؂U`0/Px(kChRyn8oA$:)S`$&lUHW0t`Q0P"1Hh#VF3q]w,hTF"hpFl|(W#pklf\:HVІFp H0Vp)X÷ y(&`EWEā~FpCrXfpC9tD㙺k{/OxBŘs7}hC\VdX(kChT#G$I8H蜱`ӪȠI~k;7 @\lf hej+F p F`@e\8 }H #ؽTPdEH̡̍L,J IHʐ9| K0xmȁp$AhQR0,,RB /0sHQPPCWMe`〄 ,,Pp, PV%<hxQHH#N<@wM&ָFrsY:Px70WT:)SpKsPTL\; ?Kԓp==A4SHfHxxk/1X(&2-D#02(:Q ָLAX-ӈ5 "HoHR[RpR)sQP9҆1eBx$$2&e02A!4m`$(m4v%@AcDU2S4A3o8&@%p KLEP2l^@@A!l^%npӧ% C 4HP. #ރ)0R`%9UHVUERX e0Kig ЋV Wj-xn]c%QA?[fR)2Iv&h%R|h%yPVI.Qq@aa3`^#AUp&*Z0mGS&&h;R3B&٘ Pȍ2IޅT:Im40`4"N0yaHdOVq#%5$B2 p9 W0 bb͒5L4yIU pAaB1I^4 T!J!7jRev`42ۊ+ G(bh Klkf_-*#`QDU!(%]t Lk?Bp4Wيt:.21ȭ&5CP@0r#4Uu8 6""ZyMx(&h餔Ij)bb'c+?Qpr%4( ` iT(kR CYZn/baLC:D x *Obt Q FsTRGcb" 8੠Q)d \˞8 K-2 l 1 ~yBè*z ¤Uy4ruV^JZKruW^&AJV UbyI\VMUfI)vwfjQZwՖr%e\wep^p )"]Qzs RrʀxH&h0FM&TWM FX Hf5FVzQRsش ᱠӳ`y2$ hzK!@(/PDy@8$߈Hb ƯAƃ !K@è6{HF I@X xH DWY(0C4lrBsxU4H += <)vƨ% s0,a)aaKUA] np!\5 | hx`GTC6tD%hyP4H3o@hWVoLHc8Rits(phd0h (VЀZIc4Po,fcZ BHsTM@m ?PC؃(Ճ+CBbLrx5@GC&PTe!XIF=(T$ U0o+6[5$ `aIfL i,02*DJg%L5)^BOJ| x @!=S(O)38ʍQE  'B@P*MKUnYPRm6I'cL<*# Θ0$ق NL`V$q28n_Q4s2VS ]+I&Y,Hf傗p (V" 'B4DƛH%Dh^@FK}5m /! q~5iӂ41+z4b$ Ӕ Kf0ٌ0k¾!+d'ddfTh6hHEF`+88c@B@P!h! xÍ<@ 8(c@A*C 67| :p8# <0NHc5" :h26݄SN:(8`Q 1E@ HA(BXIBa$ )" iȄdRQ8@H(`bv'P<< BZ@M4BJ(&%b B@Ȅe,aD#EXe K@G< G\! (!<)bCF{< S0hD/P4 j$8!'SF'= ].\LO6 PB^ r^P,q% KHqndH#撌$& D$lx`@<]g;=+@KX ʓ S30x *D O%`XV0Q[g H@DnahV@o[& DbA$BG EZ(hEYW#[' B2>`B+6c0DN4n# RmsV% G\N|.ܱFwk۠eBeF@PتΐȐ>AX 8 @):4#LhD8!:A N EZ7xh`n>"X@ 0"^}P([d9+Ae&TVHC2[, D CA@B! (t*P;"vhw\AqHD E)zQXUL ,!@8-RFn-FҋF"UUO^@@/Apγ]Pv}~ms1@ nϙ ӠQP pZ!P>t(|ӥnu xR  q$H'YeL0Cu<1Dv`nЉpF֭{BH DpۡBg ' 1` W V,PЋm x@ Tt!Q4h "N(, xzӈ<'PP"țhD8ъl^G{7 4ڣg@` &RABPEWh!59,Z3 Q h!Ј=8D?>pQx7p(7C;K<{,hdh0xjU'P0GF%X( A“V(Hd/jd#B#< k8sN͠l$5!ThlVBhFRV ڏfP( vH3GF @Vh\hB*WPU(OpR%DWhb=C(FH(S@x0+s324B&h;789#9i+H3'LFxۄ##3*4"Olb>%Lq,VG`(PHjj,WBI&P(hu| 3Dlv/AldxLh$WFCHPHD|`hGYQlHhXF8T@FHhU0TplGp;ȈD&("d @vHIpIl^Is(k'6j(Mu@_'LEzEx PiWvH@▜yFYS`(eh6/: !h@ HUxdK#Xઈ'hDQ/N^! &ɢ0#ZˆdVgdZp9 hp%ohzxM"@ $`6$D &\ ^P?XHڻ<p@p \d^p9 'ğ> 0yqd`ĊdtE D Ld'oxVX.y{HsђVL@7&ZzM@(TrK<&nc@2 e![E>Rxԣ,!ԡ'Ff #8A KV РǨX:حK/pɦ8A\`M*w9& # hT Fqm$T nC+ e *Kh[XWHL xd$T-9!,D%Ȕ  $Ei|:v$G "LF)#7T #hei2UN$ռ?2qE(L!JYFF$LN|jM!\шWh%zSB p2H<8E][R P!` )4`>ChnZr@* NL`0# LF+$IʒjK_PC   #AAXP"%J΁sSmSBmQe#*`%XzM,jm]Q DV, -m YotHIKhJVXhڷ4t )p)S3 춷™FeЖE"Zʖ^ -4"ZfYBjP*(zЅVtqFӌBp;oVaAUqhUM:I hX]6!I_GpSȀJ$Ha)@bM wh? C_ 4 (Df[RbDNfPhē0aOw4]p{AV@DZ+E$2F0 hF4BϛhrD"O](&cMCH\ƗV(Dl؄\`Ǚ!aWps#aIW>B'$!eN >:\LPsr`Y(;ۯ'5)\wh^煇Z=Wr@mu\Z`uƸ5w T!D"Fp@#LFpP-pDA Ř$<gBW Q@ @@ (8!BYx3P, f0xP$IXEMl(! nk98,qsA!F7%!YK5@*iZJ 9z(0 Q`9tQ ]$7.  -."XDE* T @`O!+.·0E+ \pɠO uO{VEeߊ_ 47 E#/4 w<>MH?0HId xS4h :2XFPQsQH+?k380`s|@ , :k7< 4@KZT6k;@;XBBjFЃ+B> DHWxp(XȄ7D{h68ªm<>  0 0 @m8D4H T8 $0K&#))246!x2(9+@4`2:@_ۺ2H997p "1V0:xma:s3h7 2:7mLG8x96:V 1E!9F :27:a$Fq< E^E`E2H5@FedFg\^w`1H2pȃ7FwD2ЁrW눀Rf"K(Tȹax,Bhy!Z"dTP <,&B Ydb%[v<xds'_H h,H B@@hT(T(s&dp(ЍdshXb*BnEH;7PEE& Q;0!YpIe@I"1}X}{0Gh, v#š( B̡t(D a(S[!䆈hs:FsJ C>`"0@EH| Ǻ @D'F@E`(DK E&* 14Q^\B8@4 @0 "@}1fH e@#vqr X&`#G+0O"id -!&d &#!w[P1ZLd $ `8Dʣ"F&`\5c59h$ "̅0ˋ }v=hD u-D JAd4"8aaS@e'wK1 \"Ve H2Fp(B OpzmO@] G``$x8 G!TXO}2 ޷A?.?JO'#}#|3{v<Hc2g;~ꃅ;.cFx.; f+b>'bd0x; F. j[wShXSicPsAb[A,sA,c>r5s55:&0'd(X؎c3=ێ{(c;(99b3 40@%%`BЅ(#1$`0==UUDU  <8LyU8UzUU{` 䇭UUUUUU rpU/ mU T 䇀/fg Dgg 䇭fg Ɂcg UU UUUUUUUU ` <8`U RU RU Ɂ rU+ ŎUU ! Rҭ RU8!U L荭U!O8 R R0. R R#O Rǭ R8``#` UFUU ݀L ၠ G$DU $LEU DULLGi̭F $LF $U $U $U $UFLΉU ݀vFG8ΉU ݀XF) $C* $6' $)( $ $ $F`8`U U ݀` F 8i񩀍F` UUU ݀U UUU ` <8`izzjM bi ii8Li𐳥iL`UV7% / )#$%z8z !+mU-,mU .`UV 8` 8`z"z!& &BiߥiLȱ" ߈!ՠ!ȱ"ȱ#ȱ$Lґ`U U`8` ၭi ii8`UU ၠiUU 瀰UUUU` <8`+ , - . U  T T  U U U U ``!8"mUUiV` UU#cgUUUUUU ݀LcgUUUU UUU UUUO` <8` UUULLUUO# ` <8` .$  `UUU#`UU 瀐LK`U! .cg .cg## 토iLՔ ᔰ U Li 4ii  LՔ  `i  L`"`8`O` `!```U UU7 >sU)U edULUU!UUU L)U KU& mU- TL 9̭Ux eUпn K  mU` K:)@ " m 9!U eUU K !! K!  m`U K!  mU`΢U8i#i `8``URR ၢ UULLLL8U LU LmUU $RЬ ၩ ei`U8`U UU DLߘU?U@U ၭU꘍󘨭 Lߘ ၠLg L ΥULg L } K"& m) S .S S Sɀjj(iLi(mm(ΥU K$% mΥU K!  m`U` K!  mU`hhUHHHHH`hhhhhUHH` ee`  S S `8` U`  U '7J UTUCU nCT)BT%LNUL7SCTSBTCTBT ךLNUU U)L>&U%UUL$UUU#U ΥUΦUL b L4UUUUU b LN L")U KU&:"!  m` K!  mU ͚` < ͚ K  m ͚ < K! mU`΢UΤU UUUei`8`U UUUU UUUUUU `L8`UU `U  쁩UU x`r=?Cօ8  Q S K! m`H 1ȹ1)ͯhh1Ӡr `L S`U UU7 >LU_ULU"8%080UUU ݀L ၩeiUUUUU L K& mS L28;;ȱ<< K;$<% m ΥUU K!  m` K!  mU` K  mU`ei`U Ƀ 1R # +L&R L& R RR R-.R/U2RU8+`-./R2R R RL 1R R R#,UL~ RR2RU0R R R RLLHȱhRR1R L1R LRR RORL~ RL~ R8 R RU8&R/-.&`U`HH8 Ƀ 1RUcd , + LLR LR1R L RȭU UȢEU RRR L ݧL ۢL RRR RU <8xyRzhh`HHxyzR 1R R#R R$R6 R RLeUC { 餐 L| R$R8xyRzabhh`U abL蟩!mmUmm#R$RH0F_` 餐 L}L|_`!#Rб$RШL}2RL} m UF  fg! 餰9ݠ 餰- 䇭fgϩ! L|2RL}L|ݠ nLǠ#ݠ`HH 1R#R { 餐LhRRR!HRh LhRL ݧLhR LhU <8whhw`` Ƀ( 1RU +LWȱ X LVR ̦LS LSRRR+R g RRȱ gRRRL ݧLSRHh R1R LS <8`< LV |88JJ`H9YI) RmRh` @HH YL΢ RRRR8ڢhhڢ`HHRHRHRRR LR ϥLRR R" LRRRȽR ϥLR8fhRhRhhf`HHH L}888hhh`HRRLRRRh`HHR%R'R)R+R-R'RR) %R)R+RU)UUUR R!R ̦ ֠LԮ@ ˵L+@ Kҥҭ?BC8 + +Hh@ <ԥ&JJJȱ>'JJJ3ȱ>*JJJfȱ>J&*J&'J&&ȱ>J&*J&'J̻&*)')3*)f>)JJJ`80|'x&Hh & 󸩪 󸩭 󸘠Y'&Yxꪽ' 󸩪 󸽎`Hh` aI꽌ɪ򠚽ɭ&Y&&Y& 꽌ɪ\8`&&꽌ɪɵ'*&%&,E'зЮ꽌ɪФ`2JJJ'J&J>Ƚ3JJJJ&'J&&3>ȽfJJJJ&'J&&f>ȥ&)>ȥ')̻>JJJ >`*xY+&x'8*BIxix&&  x) + ') + &д_ +`FG8`0($ p,&" (0 8@ HPX !"#$`h%&px')*+,-./12345679:;<>) JxR(*iyR{R|RzRwR RS8 xRRyRR`HIHHh݌H6 BGKPUֶڶZlZlZlZlZlZ lZ lZlZlZlZl`@ `(HP  U  ȹȹ @ȹ ȹ ȹ ȹ ȹ {xyz|}~T`