8L2C)pJJJJ IH(ȱH:=IH[H`@HcH  $ +   I/H`JLNGȄBȄF aK  haaFF  mJm# KKJ UJ )J ۈ) ;J3ȱJFȱJGJKaȄM  aaNNJFLGJL LdDATABASEu#' #' '*AUTORECALC {wT-H.FORMULA.NUM &+; .H.FORMULA.TEXT""+ -STUDENT.NAMES5xT +DISK.IMPORT:{T (AN.INTRO>$ c SYSUTIL.SYSTEM{c% c% UTIL.0~Qc, c, UTIL.1;yc c UTIL.2 c. c. MOVE2S402KA' DATABASE# COPY.ME$33FASTCOPY.SYSTEM)VNZ [*LAUNCHER.SYSTEMG,b$ b1 PRODOSW#Bb  SETTINGSy >dMԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@LLnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)? &PRODOS `DaElH$?EGvѶK+`L HHLy XP LM ŠϠĠӠS)*+,+`F)) (*=GJFjJJA QE'+ '== `@ STSP8QSS8 m P o R(8R GARTD`T4MATHEpT5-FORMULA.DATESGB~xC+FORMULA.NUML~`C,FORMULA.TEXTQ ~pC/H.FORMULA.DATESW0+7 %DD/   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. Squarens 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 ofinal 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 Functio  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^BO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===this file.Entry Multiplier2.4dudes3.81dudes4dudesEnter a number in EntryEntryory 1 MultiplierResult45678# (Root,@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)c 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. Prior@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@Inby 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: 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 tion 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 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 poround(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 git 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@Ruivalent 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 dimberN, 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 eq;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, Nuis 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.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 @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.#RecordI@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([Runnin 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 whiIfDataHFThis 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 amongse7@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ЖKThis 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, u]="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").Mand 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([Datacomparison 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 ll 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 ions 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, al 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 operatDataIfFalse 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 equa 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. csJHBy 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 usedgTotal])+[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: @TotRech 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.)f 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 thwill 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 ohed 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) 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 StringToBeSearche 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 Jcategory 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 tge: @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 LEThis 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.Usainal 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.ЖGenderG!#$%&'()*+,-./0123+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 origRBO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@If([Data]e 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: 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.?Usagele 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@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 titwo 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.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 tder 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=alControl 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). Consiyou 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; Totke 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 bers 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. KIUnli" => 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 numo 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 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 t @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: @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 %orderNamegory 1IDGradeTeacher..Comments Citizenship Atten4678 (DD/ ) 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)=1r 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]+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 numbeof 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 ","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 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("Greendance..core10.core10.core10.core10.core10!Reggie WilliamsRW111MannyLaPhonso EllisLE112Moe Dikembe MutomboDM110Jack 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.Fo=?@ABCGEThe 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,p@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===NTriggery 1 DB Import SS Import(GradeName Student NamesTriggerNumbersTriggerType in 10, 11, or 12*'9;<(DD/  rmula.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 DBcapabilFHIJ (sDD/  AARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeDM1Mutombo, DikembeALE1Ellis, LaPhonsoB+RW1Williams, ReggieC CA1NINIP nSAARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeRW1Williams, ReggieBDM1Mutombo, DikembeC+LE1Ellis, LaPhonsoC CA1NINIP nSss 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.y 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 Clathe 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 categorhe 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 CA=============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 te 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.Miscellaneousity 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" filtaʍ NumberData10 NumberData10 NumberData NumberData103690036901 ؍ NumberData2 ȍ NumberData Ǎ NumberData ɍ NerIntegerDecimalInverseRecNum CurrentRecNum CurrentRow Increment PriorRecord| TotalRecords à L:IfDataaanother TimeOuIf_2lication disk|`ƍ NumberDa NumberDataAbsolute SquareRootMaximumMinimumSum Average 1 Average 2Round5 6 7 9 : ; < = > &&&&&&&&KMNO (%DD/ )))) 001991D15A011989B28O0011:59 PMl  ՍTimes ˍ DateToJul ٍ DateToJul100001 .( DateToJulȍ DateToJul771@:IntSunMonTuesWednesThursFriSaturChooseday1991L25AatamenDates TymeToNumenDatesީ0DaysBetweenDatesih DateInFutureates !IntosetutureatesChoose8|LM Joinat (6Lǀ  ˍDatesٍ DateToJul2͍ DateToJul̍ DateToJul΍ DateToJuDatesory 1 DateToJull JulToDatee DayFromJull MoFromJulll YrFromJulllTodayymJull`%Read anTimeeymJulut applicatTimes) * + , - . / 0 1 2 3 4 6 umberData  ܍25Ӎ CurrentRow%ލIfData021041234512345-1200.751 12 -1-1123.456-2.2505ABC,DD/     )))))))) VXYZ[\]^_`abces 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 simAO=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===@O=====<====<====<====<====<====<====<====<====<====<====<====<====<====<====<===only' to YF 1300-05-0505GrayNums2׍LogNums1LogNums2 ōOr)Al AllanM 5050-01-1800Green00) Bob BrownM 4545-02-5455Blue01. Clem CalhounM 2110-03-6000Yellow10, Danni DanielsF 2550-04-2545Red11( Esther EasterMr.Mrs. If Right 0*ލGenderMMrMrs. Rightݍ Account #623-MiddleOneTwoThreeFourFive60ColorsGreenBlueRedGrayYellow֍LogNums1Log Ortީ0!׭| NotHihL/i   ύTextData ЍTextDataэ Lower Caseߍ TextData10 ҍTextDataۍTextDataFind1 #ڍTextDataLengthFind "ލGenderMee1{` Ifddlee1 Ɉީ0Join 1 1 HihJoin 2 2  ! Account # ! ŀŀMiddle8|LM ChooseentColors|{|Matchms1ums1 à L:LogNums1ums2er TimeOuLogNums2tion disk|`And `|8 TextData 1Genderc Upper Case Lower Case Capitalize8{FinddatNol;|<| ߁LengthtNoT`%Read anLefttttek1ut applicatRight&%'%(%)%*%+%,%: * + , - . / 0 1 PRSTU (ply 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 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 not 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 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 formaher 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 OMretailersproduct, 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 PNotmesKIThese 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 ks.Ж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.ЖTi@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 AppleWore 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: 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 thd 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 formher 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 liste 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 eit 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.Жr 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 pl........ AlabamaAL AlaskaAK ArizonaAZ ArkansasAR CaliforniaCA CoeghiNamesory 1Abbrev.tuff....D D/6   &STATESf%|~ PEjT5(STUDENTSlT6NUMBERSpv~n0&SAMPLEr|Gweekend. For more information see Formula.Textby 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 s 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 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 previou 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.er 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 forain 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 numbloradoCO 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 OreClass06Score06Class07Score07Class08Score08Class09Score09Class10Score10 IDName Student NamesIDdance.Class01Score01Class02Score02Class03Score03Class04Score04Class05Score05Namegory 1IDGradeTeacher..Comments Citizenship Atten2))J)>)'''kmno     (DD/  )))))))))))))) AARoenick, Jeremy(JEMs,SpellCopy)BiologyIDStudentGradeLE1Ellis, LaPhonsoA+DM1Mutombo, DikembeARW1Williams, ReggieA CA1NINIP nSrbWY[^gonOR PennsylvaniaPA Puerto RicoPR Rhode IslandRISouth CarolinaSC South DakotaSD TennesseeTN TexasTX UtahUT VermontVT VirginiaVAVirgin IslandsVI WashingtonWA West VirginiaWV WisconsinWI WyomingNameID Student Names!IDGrade Student NamesID#IDTeacher Student NamesID Class01IDClass02IDClass03IDPEMathArtMathArtPEArtPEMath CA1NFNFP nS!x82:H762(91l 7 0jL PF"h 2`2FjF:e4y4mL7r9(n 1mpe\y0`rd0u<2ؗ:h1(9dl&&x;jlnƅ$GsDGudGwetDs} 67004P'':H7pq47umƫ6Ht3`eyt:ey2,-psx k@PY)l @(dHdXH\h7؂\&t-PAHZ恇cH @r؂dx؀dpJe x.kXdCaKaqaQ8P@H @?h8Qc` H2QXdR)*&-QxPԈV@FCF< Hal@x(mxVؿ?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 š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%Ț() -9999amesAbbrev2NamesAbbrevStatesP` Applied Beagle Bros Call APPLE"Quality Orders(800) 777-3642Name- no rules)Phone- mask nostore MinMax ValMust fill MinMax LenStatex Len UPPER CASE ListnumbersASE1 80)ead anCapstalizeCAP TEXTcat#qst (P`(c) 1991 BrandDD/      $@Ten &@Eleven (@Twelve:8ȄKq4J~l*)G8t20hh PF+G+40i8G638eԂyԂ7x6*:|r72Hi}y:ڴ0F8PjhJP)XǺ1Xf$)1Xl20h\K9x6h!hF28mlMHtLG3OfD!HHktGt2:`65v4JAeФ,2H`,\OAǑM7(ItrKPL=N 7ЀϳD'( 5!mD')H3@lP"*M&X5Pϛ4J#MS8@ "`.-fLzǍDȺͱǟL1 NG8f<;G?Oq9|;:UIF4PHP*ô;h$:(w3E9LHKNTu#MLGXUȬ2HOɖAYNE+3|!AJ.76Kt*xpB9G200癎6 ׈ ut+Gp @ö3_M8@ ٠ ` :@F 6H8 05d8<٬ۄ2h ď¨NZŁKK׸BĉIBp3LBJ3GFl (=C}E\QFo4L} 4g 08I4Iָ()ƪp`Ƒ(tt {D1:(D6@yà 0@ !H$'ȉ*8@\}EtG,􍚸 h:H0H ,9FŰ(H&􋯨 @P )?2 ؋FX 334H@h ؈>Cxʛ`|0< FL $%lBLF8@Ķ$ z7Ǵb P(@&:H! Ѝ 820!X9*B7@3 6$x;pHxBp!6P6B7BD 9@)T 78B2@ :8 x2JKp7@ 20@:5 6,2`"x( 8$1 7x BHD0Æƿp4h ȃɸȌ,sL1@xO)o*֞`ts١sXP^/i'<q\ň$lF4uH@,6 ( @; %  j ˄ *fL@D8@$X@D@sZ@dX@&@'`TH&`(&p`y&!`?(&#`8&$`BX@2! Ex" gT;`Dn$zP Њc H C2 ^rS1 G ̓1H Pp4buH\񽀭7K D݀R衁#w*` iS0dn;2$|lL# BġӡQV >ll0p!Ro+[ַ_0t$(h׊Ū [,0G,6bAUl1jQ⋸d@ EhƁbx'Tыbmi -"0 G T И3g\ `F zB8DD5S>N 0(fHu E> M7 4}:u!>! ̮&*يWk)B0 '@(Љ5A2ҍ2@4FxpG+8.a(,`tp"; c~"U >/1> VJFa]$Uȕ"Jx4T`h@Pc&.1D 82ޘ G=Zm 2`,y8INsA,%Nzz!V#,1waBqQ Rj.MA0iPEF(DGUyUZ($ XeA@ V!a)DVQvfGIEF!l6d*RD DsFq'[h!b)eF!E"F-"Hfh`ŸBiQY$@ hi%f!VmBYf`YB  7͛B}S2s8)ĝ4BIC 2.PQBNr4yC&< K!Zŏdpb<D2fCJ8=&MZ6uҼm*t*x  0P 6h " ) @CbD8@TTEbTLGE{TAFю?6 ёA\H9ҝ#;Gp;Q*Kn< 'eD)p)RSU}`}GmJ2`J-30SGj2\Pl2fdqMQ7M4m,lWy-Ӂ<- OV  :È1G ZP "dG GN;iԙpa7#ư cbʜI 3 ޘa& 2蠑# c4D,]n,LΝ=2 0r!Wm$SFUHʰs AF|R Ӧ *yx:M)DЀjhPRJъBZ5 2 F b ě8Z!*@tТGkwFF5DuL < x!Y&6wf-4$q,@BjN x 4CBT vР(u^T)% BKp&\!.@x# &>;UK## a"Lr& Z0,(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[ )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/h l2|P>؄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`JJI-8^8JdxfHʦ-]K4V(cp̷ܓFH,eK"HW0p(X_D V͹HЀ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\VvFQJ(J(}ǻɄ 0!klKlK f07 B"<1stLj*0l80TPFPcVf`f8 dp d"`B`h#pF@&h l=L,^B~5B)B)6(3TDV؇(`D)@LĒFVP >3xD@ F3EtQmF(q;; " \ vz݊Ff5|ʇ 2` tJNA=\B -nŹr`EDfViscX+f4`8` 0@Tݺ(Ф "2VU}p|+y00 `r@Pc @V [Ӆ1A WGZ0C x6~ɇ~}BqqZڅG BK2Lhzl&XhH= хdY`BdlDR{g zs]A +$ !Vػ0$V0e 2)Y @ @ ~`pA!"6b T82> '`E,H XTx!DJ#'=ɗYL  O N8]PJH2LXD5$rm#.zHX,P n{]`)ܙȢdxdF3R@g \pwWzX߃$ @` !0;v=@x( 3 X~Q ^Nx(3zEw\#.':ҥ!Q@7ׂVA+khC@"p@XE і-nwL+zq[>B0nK60(Dm`P2@RHfXi]%m^HG=k`neeUWifdw]BYMxIVFvl,n%FKZΙ APJtjDcb#i hH0'j( ` &Y &Z7(9-h aV R!CRHFh7ZʼnWܹ˛aⶵ*A @0#&R`\P$D o@Ch/ "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{MǨ&eigd+k)UX`VP,pEXQF,8V)%FAIq)N`X@gl`&RRƕ܀SlUhw@ &2UCD1Fh DHLFRH! ѰaFf[}UFС`Cc)$Z;n@dh\iY$Xi̡ڼ PjFV2Y9!ZZY%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 &L%E1> g H%9t炤WQdMV6xJժԱ\ֲgqZ1*@Xt/ ~;KQan`5 lA ZX$dEp/ڝj'@*LgFRQT#8#LXN0] V3S) w;v ZrF8f}F7,\QbqĿVHZe;FIL(h(:Rt#`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;kсU F0Jxhh(J{ʧH)x[J^pk(W *0{(/QN+8tH@J}h'KHoy#}p؇Q(bv8V ]LLK$:{&lUxV$hOO _g(,@^DѸEPw Q P5"$$PPffi58PD-3 8A\Ē$ͅm oP'N}y! ~F3H>(FX !xhWH^tH0 p//@/wj**@h@wIWI!8zd`+ hF])V`"lHdP2`'0dXP#0& TD-X%lЍ H,ܬf8 0Up\k^.7ȇVȃh?h0h#`TB^#^ԁTlU 4*E^i(F`ԇ 􃴨PhЇVȢF]T"Hv$'p 8/.GVHEÚ(Ă\}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%Ђ 10 )A2ϱNB2q*7psH:nh G$Ifl W3X@+,hF!W|=g\Q2v 6펷7@"ӆ&0>ID}` =وzsSHaY"kw>p7{XvRRHKE ڍ*u!FaB$Ofv|o[SG+Ίi's'RP$&J=HP;d$0$+L Xk(BHXA0!HM/ vyBDh]D!lab7C }Zh!A$)/ u+4@+ȌBn>1һJn-RS"#q,D8`4Lqm8!/,J\v` 7 8#(D-@70 Z# 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 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 HE5hr]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@`: @1@:E@PHx ]t"R\8$Q#*p$Y<@p_  FM M 4tژOӱm(Q`"(0@](`D h ϴ `ڡ%WxBdOnY)Y"d@+V4+Kl P n4 (E7TRR`!_EF@bj JQ2d ؔVb"FqƆtgLz DDr<X9[}Ҝ hheS$J@#شH@x$1?"!:E&M`iF(/F fhpСV.@x*(x^ (&h"y2dLL#w "](ă.%'@b3d ÕK{'!, A  FZ B4iB6K MQYwXդM"Q#x RI%ASfRHIA00Q08IM=Exs )$^ЩYPiESf.`P!݃#MMxL `IL 'iXt gA@dy DO 5>H> 5ATٰ d,7lA F(5a"E@(g hpg5r@fw w8^`k@%XeX"QhPFH"eZ ]kSI$ň+T !LqTWaEFzR `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ՄSiT3L (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'@P@O MS@aPQ  88!=zU?h xFF!UhRhD( @SDP3?D?Dh 8dh")(BH 5hj@ VXh<- R(D5(npBezp(F%E`/L@&ЇC,EW?>@E;@D`?HTggȂŷJ4&"HFT\X#06ӻD^ж=U,fi:<@mxʋlhGI׸c$g4?{#4U&73cCg `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.L.(@U@@9åĆ>0, 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#] 4B0)3D h20*! &>ኾ 4 ( Cق{ ;: ' X$viGO$LFчDsԄf /&<$P9P xEO=B TD!rZxtHض:xlrL( h: XH H#'4@ |Zbb"ü R,E,>$[3x`U@O0F< ` maHbZ` (D ڕ^q>WH Im`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]&QJ)x8 hv8ABaCm.6tKypEmEThT&؄KQNX }HȗHh28R3aBXX`(H娔`7 87&(LLMwńRF04 1`BQ8R dȕX1Yaa`f׌F Vk0|1xՒpWX&yъ4Qh`ohwJ6آ|B\K0Om>0),I,d(IFKBꠐa&0 U3E0E2sul2Ex2? EHGK8%QF0KDpC(XHT؀fﰔM7V"N(15uP&ʵ.Vь/Q B\gxhى,6\vFP2LPBqB1A>&t#IJp{{{HHFJd{cDQF vJ>BL*Ep<sïK G$wh֣ w`-G v/iz40͙@?PIcTp܋IC_5d hr/T@x^񁋀hChdxxPdb &8@@Q(8HXVHxH0 X 0NFSxRX$(E@K w ?!K HiHhABP=\,ܔ3=j†:TJ*I@} h$ы3C|.# X(mn'^8{H 0P P"Q DcH4lAMTB E%Q .TB%@ BHb`(сIW ֓hK:(#274C* 8 pW/g`@ pRRttR8!@I8Ѹ!`QVd!Z ې0O'e(K2/k`߁@-3$4 1 "@GcVmB)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.h6-2j0V"H_'̴HA\1c)"-/Lj5Bx0%W²!"Ɠb.QB,\[ɉ:B#*=('*x h*Oz!]t"Tr&"X6 ҨpM *R% I4 d"R$> W:o ɵJ*Ј%\{pHB $ĆyUAM0HhkxQ-؂dSh2͜/VZ޹$E2zi^Þ ITp"4/Mƴ ;F kZfb4` [o[SLc(a1@@j ) ,J H x4`0 A4:jS tS\\s%x +%ӺUbJ6>*xFPlH42h E VTd|`3N?\ #(DHDROD9U 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>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>ˀ2Bh5V\@w!܋9 N<A8QOvr0|PF)@? 7ьlRh6и;N޹>/o" 9Yf~ordo8]59LQ S4#+^ pG)>q @4 p B`B1Pp CB t`dǙaq EpЏ Ouř\ d4F$."֤670G-LJU&' BlFDQxt ?XRkነT pS 0R*Tm`a' o>`(U8WM7ѐOX r  "X~ ֤6͇4"%<rԡ H9hqJ2?0!@=?xT w'?CF5C)@` ٌ[1A0 IN # 2 #7ʀ"RsV) eFge Am!"TA,madyZѦx0h%BRCtz1 Qx@p5@(" x<'_"QH4C;С08kDp6h bD1 BP$ 4Ap2ze5и] O0! ]H&0HR0#"#8(A9` 348 u<D988$/?:z K:8;`9:́#1,L9DXe:U#tY+:;@P.@Mgp+#2@@Mb6LdG6O>@ϵQ37*c`Fl墖 kfhhSnAim΍1@"n$zpL4 8+7r!@ /@ù3T3;2\lʘK2ڀ#;0̰0Pq0;@d<-- C:8J1 XEA " :"6ՎKD 2Ė|0R }"Jkt^ OB1kkNF16</YY SEG.DBC >Z\0kt)P`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֐QBj72yx` DPRe dAa FM6 Ȓ#q?vL ܰ"Q¤v2c{A0=h0͢ *@"Q(W8o0F !"ARG"@ !ke_ fy gY h9 i‹*RG+`@Bh9#.`/e}/#Th#`ZT =htKQB@GS*i+*hv4JJPyʤpL >ـ-`Mf8"{Ђ S,ȂًOFi %Fj F11F_{,P% TqC؄+0: ,B xZK5TȀFh*Hqr*h{TxDHgY i8fsx3q0p{)('j**%rXPbІF`(4pT )&dPf(HЀI:h2%X)$p)dZJV!^(j,&*H9l",l0lx8^x!hpqa5NOH6ڀHɉQFT(U1i@fX`4h%b1!9.( MUlZ"`Tb=+5BHk818."Cy0'dJB+jBg!MhO-(pӐ+rDo*Dp+q 9&*(rg Gqu"xԉB_:蜗j_6s=guNZkς|rk]Q2 k@cʶ*K^#;13xX@-x=d ƣOuAoA5y@\L`C:WX\K| _U0R!5L-XPb["8G};ڀtW=mX;  7.k='Ήsa'C[yPi0AO(j\ ^!VB$Jq`2A Ph{$#G2!BꨠSUUx被 0t eEKh QA'ULVqr4+U&3jNaV 1h@՞g|5"p$`ͫS@xGO "@C LnDGO1d G`Q̸qJÝ shhFN֊5M1hҎzPnd]i3JPI:&  hVNuhgF"  *K|0<`p ^Á!O Ьפ UuM-\ZZ۵bd*@0>(b-,! ) Ad'{')MGM^i$h@pmhUD-hpY͉ixv)$$ [:`H^7'HgDsP<@!T(D8 !B(D9xGhx _ ZLmy -!4%-JyY ' r4xHj#B0e-A 88`BbPPA؈ /UW@H…H @cf2&8 A%h@1Q<`dR((P6 FP PJh7;)&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+4iE0 F5ExYF^XWqWg`[R^(V i @ -ViF%SN@@h;F`[t HaB]RBV9FnX:qqVkfLZ[B qVl30$C,_4B+D F1,(B-:h*P \t.0:|Zn`B%T1\q )l03|+D Spl24kFq)lL!=0mLOn C[h2Cd@CKSKC_LԔͼ!bh 'l|wV? 8BC5:S¾"H%#DP}l IU q `EB\e!J@AAhB>r` 4r` BUb|_`t؂` Ρ[y梑q$ZY7B!Z vdg 8H9k*1oz뚼+f 7Š[9&@"@c/p%@&QFH|*-'V) Q "he-{h nQR9qzhSd*RD "DsFqShAoz(eFE"h. "d6f&!i I A "FVzmF1\ xiQUpHps{y?"|#T*&f(-YuQt}׍cg8&.B0=@atZlTnN1˥k^9; bs B֌I?>=9FЙDL 3]MæL:hat!.om^ʜϙv?Yd0ɔ2lPN??4  jAIЁtx?",D4 TBxP(@a ?=t@q^0C%IR12,XzFb| mY8f=Sxi}8]V:[~ T< @ P@2`8@hǒ978A9x92/%9X)*!x823H762(91:,% 92H R"`S"p2XT9%S3R#`S#C 6`KS;4B-S70mp)*M7-07(; UL20/S-+-V:d 88`KPRJhK0KhUHKp@&P2d@rLrRqPbHhȆT`̈́h0KI hITRP(?LXJba \- (\h*\h@6a;x.+5+YA>V*j,\ <hPa\9iڂPWEVEp1x+#>kP`KCp0P8BpP&@d`k@i($hiGX8FHCE@DIlD0=H pHpH`^dBQc+xpl (KH hChlLp tKx@V?dH0q, 0>tJdJoʇlBB$ ʢH(>@&}@1HǓk[߫#\SkHBc1xP{Bmwp06փ 6\x:rs,;'o ^HJÇGQh`h1Կ&EԈ?Kd@xET0+ ;h_?Wl_EQ\Al(d@p( CVhE h'@0<dpM` 61^Vv):afa Qv30Xanfv3]-ې7R|^=;9NZ=[NCjaN ʀ@M[hbp8?$! !z Vtj*aJ2 pa%B`PB+ QMl@`PV?M(2HpV?D`˅{{`MdȅppC/k!ŅPщ+CC)/2dD#Qվ(HABQ {F(Ŭ NX;3!P@# wyu$6W@ آ[n-;KF,݈xhR|"};j6m|'^d7 'juF p>8I(3 ud\0X%@pFX~+`t XH `3J 3iGrMTXU1` rt 04(DhE``h QZ "(- R)VъGr;pJ u@XB! a EobB/x n)4 F8 oo  iO]^schBSc@hC RȀ+lh T@*+ڇ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ք0؅h $8Ȇa X4  ("D heЉB-[Ex OPD VP&3dDszfY45⃄HF"`l (v>`D/Nh%4qAeHFpև^^, x;$ zBF;7#] 0tR(E-1h~sWiE4԰Vpov&ѹbD9h(EḞ?߀VjgzH%BENH ux$^/na@vt DX:I+SAPR5"@Hǂ_kX:V,Q&(!J|A(E7y{:8Pyc!|Gh\ )>x@2T0tIxa$XHN]EYxs>697"h~rhڐG桕;VIFot`p裓!bi@iNk$֣$Τk%Υ% hGсd[Qw\>v%^xv&<j00B 8""AU.$`t-DsD1Ev҅GxDpwWpxH7I qns qwzy㥇Ś+D>8: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|=@ySD2d@ AJ |JB9f造& ^8oqA253O YewTRs0sʐqaH9t޴!̘iل[ pZ0y* BfӹI& :捛9:y2ʦHҦ4?W)SȠ 8̒C7 #ثAXP <0At8ZK(KbHqp>! :@!8T>9 ;2Ёx  iHAHʸ b :8'?qp7)AIA03j_Mfo 7MgS@ h8V8[0[k:DNTH 0"n $PD2 ՅG6Q#+Wǭ0HqFH/#6}*z0X-D'Pbv ` 1M p gB|5 , :%(<(`ڧUj-Ai4\Y`\LU B GQ~&4_Lsbኇ8܏B G TD0AfP](PAi0q ]z$h9(S`TZ|4N$ (!s9I+ yPDQP*R -:i ! W~a_hWÍkYRȂ @wwWs ƻ&~X2d'm#Yx%8Vb0cGQx NpͲh >p&LxPA 2 rP7ԁG,:a`7!w@0#gd?g`_;xAc)>G?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< mPn#HD j[Bhu QRì(%52Rû5G)A^۞=LUDo hB)!`~ < k8:Uz:Sí<}ڱb )4!L`'0O"tn H2I7કr=҈pycV 6Pe0ʏ hQ:hW<A0bX A It0hCFJ(6|jĄbl[nl%Fq(FXpF0Bl @* @ pV|JH0r4"`TiJ& (P&D @< H%<,|/'"úFlF Ñ+pĒ*@+#Z)@xxP@^J-"z1e4E,,(82뭸 AXFjb4D( p BJyF@CJ}H!,t@`Gd4INR!hEhFh3 HHYl/L&"h͔d&7AQ(CL4҇!hlAB8hV @kCF4H$PFH44W,Ǹ{ =d48xU`(G8HhypRF (H0IdȇI|GV|~ǀȂdxHX0BX̀)LH#05`[! QwBہ ts0@),lf k BV)VP,,-  KhF"5ҍ' k"!}7XE p,8F`  ,ЋCـ{ ?@2 $c @ > COm(:< DsV 0;\!1#E])" iȄ=с `[qN)osaNH|r&eL'>LaA" D48^e42ׅpWU@IMڄh^g> ^v i1(dE]eEB[4VU{p*HMԫWUHA`XA'L_:$D 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 ^p6g2x:kĄZAB %ÂY R  `>ϸ- (t PWA$_AUp#!I_l¨R"Y\BBP$0_4e EHjD&>ObV&vnEO])HBR4&Ik5N(h2r5!&YcG^$@E$knv;jQĈUU8dXX%;njHHFn%m;E,H &0@!U@o#!WƁi|50d a@0_Nh\xFhdTBqkTi>hHKpT%Н޿؍TXyd(sK{ -S!=~~RH(D22@# EDP pm ?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$قSȃDRȃB HQfx=h1Ե̋6(c&"RH< O0Pmhhd8F003 K@C8ji@CȃC5mK )ܔj1L2DA~LTs+Q^kKOeˉ9 p#UCȤ%%KV0B0R&҅kf`"m#9h LhiEX(97F&G8Hۻ*H8؂U`kh/PKhChT?Ԙ6 X%Hʥ|9%hkLl<ʡ\I p#xwXTF0V@fX kd<b <08 -%`FhH[01ƛѼF2.sQ0!3̮hL`[XU@d0W0W Ÿ!4ÔhÄv?NX4H DWY(0C4lrBsxU,XXn #0#3}E!0jQ\&!7BIp#BGB.Չ`!B8S4]YD􍔄A)IsuU qL~M)"mN(<MNC3(8ܫU K|yy_ ߀k.DHB) ' <¼5xNq@'cŠ)T@aEB0E)8$j$`S̾3V֝gAk$;!Hd-GL1)A!dR Z4C,8@4`Z0 @!hQZlE ƨ1hAfEJq"X0cZElj <@)01]( De A: Pe[dl6!48{ N A770K2[a¢0(L!߮7bVFJmH8`unA EY0 &E 0rT;hS^@ 3lm9)jKWg 'RjQmm1x"$s(z#I6̑!qp*t8Dp *B)*Q0f (( ЉlT@4)D"('(mtU@ Q F`x&S$FĜn)t ID h9"Ս`&d4S &`7 `$C0hIh&pHɄ2!9jYRHĥ4P PJCL /I@@`N|) GrLb8 -}3Kdt [ V4@-`I vr 4h:9@LV)LhAҡe @J- m#pX0/+ *PԢHqGp*H)0Zv$b;A)0- @Mx2:aoÀ00X8т0A6@0GC0<qt @5%6"P<$g p:hPc"81.s#C78 t 7fHA"0 HA@\REt@C4.~ @J" \4 -588a #'H[zQyH$2 ,+A "Sd $߈Hb ƯAƃ !K@è6{HF I@X x@_'LEzEx PiWvH@▜yFYp " B *hzF*Dtl&  Xcu:f%4*xl,в@*F0F0F@e-u,hPCpwAvHuX OE"PقU`Z0X%Lq,VG`(PHjj,W4h "N(, xzӈ<'PP"țhD8ъl^G{7 4ڣg@` &RABPEWh!59,Z3 Q h!Ј=8D?>pQx7p(7C;K<{,hdh0xjU'P0GF%X( A“V(Hd/UO^@@/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!Qwk۠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"U0c":SOXu  Um<90 @OLO!>S30x *D O%`XV0Q[g H@DnahV@o[& DbA$BG EZ(hEYW#[' B2>`B+6c0DN4n# RmsV% G\N|.ܱFP4 j$8!'SF'= ].\LO6 PB^ r^P,q% KHqndH#撌$& D$lx`@<]g;=+@KX ʓ 8`Q 1E@ HA(BXIBa$ )" iȄdRQ8@H(`bv'P<< BZ@M4BJ(&%b B@Ȅe,aD#EXe K@G< G\! (!<)bCF{< S0hD/<pRdi.Rfi$oYp.RAOH%*} H8T(F@ZV8x*#"P$Zi" y"vH|h $1 wvڕ#Cp*F@򶚻hnS‧dTT&(nGہZxT$ %9RJ4C e[V(e Jgn tDx,XB  ` j=Yv+J(FnFhhm2+la$@T@t 63L=tX+'.-u}7^zb-NRE!NN 0 L3Va8TȈ ,J=22x>(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:ح 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 arW눀Rf"K(Tȹax,Bhy!Z"dTP <,&B pB1L vG@py"Q$02 ^0du2`$ SN:a98Q`A!xB )D !(L`p@tB(TP@ t|Hh`…$ZT }a pFE:x,` ]R)"1"7AdhHpJQVrHm"U" E=!Ѵ'U%]le)6E3 tФqL1h@)32&ԑ p SFaM99ʙdIXL T)" 2xRXS&:"\Nd@ ό;@E3=@qC& $q̜ D9F[L`:mܼ}EEoIF;[2tTH7dxr%&40$ (L Pib@HL 2$" Y0e "Ʃ„) < "UԼjT&HS)u*χ*31E=5 Ȃ[D#|Hs98T)IdEWEYE[TFHcD( z 9;FwJI:(Ϗ1Q7X$׉MH?0HId xS4h :2XFPQsQH+?k380`s|@ , :k7< 4@KZT6k;@;XBBjFЃ+B> DHWxp(XȄ7D{h68ªm<>  0 0 @m8D4H T8 $ (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 wF4Bϛ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@ @@ 춷™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 h%zSB p2H<8E][R P!` )4`>ChnZr@* NL`0# LF+$IʒjK_PC   #AAXP"%J΁sSmSBmQe#*`%XzM,jm]Q DV, -m YotHIKhJVXhڷ4t )p)S3K/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 `!?S10< P D84SU?LY+R@#0DIaE!jQZ4cFJAfH!`ZArc!f]@0%CmQpXK (!@@& ے& S4,`*5$ch VMh  f`7oBh7`7sBڄE&2 *<)FxJIک'/Fb&'E)K{bLd@BF 1eED) 21DP((ZC2 86@! i DZᄡ8RЊ'@ըD.V@a;`BֶxĔXj\q4C kM8hVT$bDjq `0Wjk8A]xu0: '" hOA LUU!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 ! .cg .cg## 토iLՔ ᔰ U Li 4ii  LՔ  `i  L`"`8`O` `!```U UU7 >sU)U edUV` UU#cgUUUUUU ݀LcgUUUU UUU UUUO` <8` UUULLUUO# ` <8` .$  `UUU#`UU 瀐LK`UɅi8`UU ၠiUU 瀰UUUU` <8`+ , - . U  T T  U U U U ``!8"mUUiz8z !+mU-,mU .`UV 8` 8`z"z!& &BiߥiLȱ" ߈!ՠ!ȱ"ȱ#ȱ$Lґ`U U`8` ၭi iUUU ݀U UUU ` <8`izzjM bi ii8Li𐳥iL`UV7% / )#$%$U $U $U $UFLΉU ݀vFG8ΉU ݀XF) $C* $6' $)( $ $ $F`8`U U ݀` F 8i񩀍F` Rҭ RU8!U L荭U!O8 R R0. R R#O Rǭ R8``#` UFUU ݀L ၠ G$DU $LEU DULLGi̭F $LF UUDU  <8LyU8UzUU{` 䇭UUUUUU rpU/ mU T 䇀/fg Dgg 䇭fg Ɂcg UU UUUUUUUU ` <8`U RU RU Ɂ rU+ ŎUU !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==-6ФSR].uVgXzA+K0*F GTR!$*IJCXF7@`'8< 2B8qDjF:r#4"/Yq$#PP/Dxx JhzhPh'ZwV& _hAH_ +I"B24^@橅A2i}>!TXO}2 ޷A?.?[P1ZLd $ `8Dʣ"F&`\5c59h$ "̅0ˋ }v=hD u-D JAd4"8aaS@e'wK1 \"Ve H2Fp(B OpzmO@] G``$x8 G(S[!䆈hs:FsJ C>`"0@EH| Ǻ @D'F@E`(DK E&* 14Q^\B8@4 @0 "@}1fH e@#vqr X&`#G+0O"id -!&d &#!w`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  LU_ULU"8%080UUU ݀L ၩeiUUUUU L K& mS L28 K! mU`΢UΤU UUUei`8`U UUUU UUUUUU `L8`UU `U  쁩UU x`r=?Cօ8  Q S K! m`H 1ȹ1)ךLNUU U)L>&U%UUL$UUU#U ΥUΦUL b L4UUUUU b LN L")U KU&:"!  m` K!  mU ͚` < ͚ K  m ͚ < K!  m`U` K!  mU`hhUHHHHH`hhhhhUHH` ee`  S S `8` U`  U '7J UTUCU nCT)BT%LNUL7SCTSBTCTBT RR1R L1R L RR)RR RLi EU 󈈌RLRi#оRЋ8˦hh˦R`HHRRRRRRRHRhURR1R 'L1R LRRRȱRLRUU/R0RR0 #/R0R Y8L/R0R R8m/R/R0Ri0Rhh`HH1R ܧhhܧ`HH1R hh` HH m  m  ͆U ͉U͊U x) + ') + &д_ +`FG8`0($ p,&" (0 8@ HPX !"#$`h%&px')*+,-./12345679:;<> 꽌ɪ\8`&&꽌ɪɵ'*&%&,E'зЮ꽌ɪФ`2JJJ'J&J>Ƚ3JJJJ&'J&&3>ȽfJJJJ&'J&&f>ȥ&)>ȥ')̻>JJJ >`*xY+&x'8*BIxix&&  *)f>)JJJ`80|'x&Hh & 󸩪 󸩭 󸘠Y'&Yxꪽ' 󸩪 󸽎`Hh` aI꽌ɪ򠚽ɭ&Y&&Y&<L淭  ؃L޷ L޷U )=U L޷U  1R # +L跬Rȱ)Lѷ R1R  &JJJȱ>'JJJ3ȱ>*JJJfȱ>J&*J&'J&&ȱ>J&*J&'J̻&*)')3݌`8`0($ p,&">֠LԮ@ ˵L+@ Kҥҭ?BC8 + +Hh@ <ԥBGKPUֶڶ ``8 δ( :: ȱ ELyi%{ "ٴ D  `             ` δ ȱ "{ E`Z " ȀzI뵩ꍫ H H m sh` S\nv /?amg     `ķ`L̷L̷ 'ȹ'{ȱ%ȱȱȱ.$50xLJJJJ`HHjf5 bh $50x` Hh݌(` 66 ľDULݾiDU   DU! ` `DU