M   $$$$$ M MuuVuuVuVuVu Vu : Vs 8:>K@UEE(w_E _E _E _E _E% _E     _E_E% " ANS_INFOPRTttX X ANS_KEEPDATAt  ANS_MACROPRT1tq q ANS_MACROPRT2tr r ANS_MACROPRT3ts s ANS_SWAPDATAt: : ANS_UPDDATAt  BACKGRNDTAt%% BCK_COLTAt-- BCK_LOOPTAt(( CLEAN_LISTt CLEAN_LOOPt CURR_SCENtmm DATA_01Nt DATA_02Nt DATA_03Nt DATA_04Nt DATA_05Nt DATA_06Nt DATA_07Nt  DATA_08Nt  DEL_SCENARIOt DLG_INFOPRTtUU DLG_KEEPDATAt DLG_KHELPTAt DLG_MACPRINTtnn DLG_PERSONALt{{ DLG_SAMPLE1too DLG_SAMPLE2txx DLG_SWAPDATAt77 DLG_UPDDATAt DLG_UPDSCAtAA DLG_UPDUNAtJJ D_VERSIONSt FRM_UPDSCtDD INFORMATIONt INFO_ABOUTtHH INFO_CONVENTION INFO_CURR_PRTNBB INFO_LISTPRTNLQ INFO_NOTESFXN INFO_OVERVIEWN;; INFO_PRINTEWN00 INFO_STEPSEWNuu INFO_TIPSEWN INFO_TOPICEWNSS INF_ABOU_RANGEJV INF_CONVENTION INF_NOTE_RANGE$ INF_OVER_RANGE=M INF_STEP_RANGEw INF_TIPS_RANGE KEEPDATARANGE K_EXISTSRANGE K_HELPSRANGE K_LIMITRANGE K_UPDATERANGE K_VERSIONSNGE LIST_ADDRNGE LIST_RNGNGE MACROSGNGE MACROS_RANGEE MACRO_HIDEEEWW MACRO_PRINTE`` MACRO_SHOWETT NOTES FIELDSE NOTES_FIELDSE NOTES_SHOWSE[[ NO_UPDATESE55 PERSONALIZEEyy PREV_SCENEEll RES_SCENEE RES_INFOPRTEV V RES_KEEPDATAE  RES_MACROPRTEo o RES_SAMPLE1Ep p RES_SAMPLE2Ey y RES_SWAPDATAE8 8 RES_UPDDATAE  RES_UPDSCAEB B RES_UPDUNAEK K RNG_NAMEAE RNG_NUMAE RN_TABLEAE RN_TABLE_RANGE; SAMPDATARANGE__ SAMP_RESTOREEhh SCENARIO_LIST SHEET_RANGET$ SHT_PRINTET SWAPDATAET TABLE_CONTENTS TERRITORYENTS UPDATERYENTS   UPDATE_LISTTS UPDATE_LOOPTS// UPDATE_POSTTS.. UPDATE_TESTTS)) UPDUN_TESTTS UPPER_LEFTTSJJ UP_EXISTINGTS UP_UNNAMEDTS ZM_ALLMEDTS ZM_NRMLEDTS ZM_RESTORETS ZM_SCRNRETS   ZM_TABLEETS ZOOM_RTNETS ZOOM_TESTTS \0M_TESTTS XSTESTTS DF0TESTTS DS0TESTTS DSKTESTTS RN0TESTTSLQ RS0TESTTSV!   ?? @VName8LBLBq+q+q+ 6Contents6/C6Territory Sales6/C 6Macros6_/C6Information6"/C  Arial! Arial"  Arial# Arial%$Times New Roman%%Times New Roman&  Arial MT' Arial(  Arial MT)  Arial* Arial MT+  Arial, Arial-  Arial. Arial MT/ Arial0 Arial1 Arial2 Arial3  Arial4  Arial6 Arial7  Arial8  Arial9  Arial: Arial<  Arial>  Arial@  ArialA  ArialB  ArialC  ArialE  Arial MTF ArialG ArialH  ArialI  ArialK  ArialL ArialM ArialO ArialQ GillSansA# !)) .*"C6 <: <3 <3 7 <'3_  _!)_") #7 $)%+&+', (-)0*&+3_ ,1 -__./>0C1)2447_ 52 6C 7# 8) 93:8_ <7_ =7>" ?_@9 A<BCC7D"E<F"G"H"J" K@LAM%NAOAPAQA RBSATA UC_VAW$X.Y\ <] a cAeFfF gG hHjGkG lF mH nAqH rtwA+yA+|AA+AAA(_ AA@A+AIA A A__ A A+A +B +B+BKBBL!!9M!9OM9& Q_ &"2@@STYL1QUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefinedq0*@@@@@ @@ @@@ @@ @ @@@ @ @@ @ @@@@@ @@@@@@ @@@@@@ @@@@@@ @@@@ @@ @@@@ @@ @;@ @;@   @;@ @#@ ```````` ` ` ` ` ` ` ~@@' (@@@@@!@}@}@@y@@@@@@!@ @ @@@!@!@!@@"@@#@#@$@          @$@$$@$@@!@!@ @ @@@!@!@!@%@"@@#@#@$@@@%!@!@@%@2'@ @!@!@#@@(@2"@@"@!@!@%#@@(@2"@@"@ ```````` ` ` ` ` ``````````````````` !@$@(@)$@"#!$@$@@)@)@)@)@*, `!`"`#`$` ~@@'    *,*@, +@         +@@ +@@,@ +@@,  +@@   @@@``````` ` ` ` ` ``````````````````` ! "!#"$#%$&%'&(')(*)+*,+-.,/0.102+@ 32435465768798:9;:<;=<>=?> `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@?A1B@ C@DCEDFEGFHGI+@@@ J@@ KIL@ M+@ NMONPOQPRAS-TRU+@, V+@,-@,@,@WUX+@,-@,,@YXZ+@,-@,[Z\W]T^/_]@`A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_``+@@-@ a`bacbdcedfeg_hgihjikjlSmlnko\pVqor[srtsutvqwnxvypzx{u|{}|~zw``a`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x`y`z`{`|`}`~``^+@,@ `````````````````````````@@@@`````+@@ ~y+@, ,@}````````````````````````````````Yf````````````````````````````````m+@-@ ````````````````````````````````          ````````` ` ` ` ` ``````````````````` ! "#"$#%!&%'&(')(*)+*,+-,.-/.0/102132435647897:;<;=<>=?9 `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@6A?B8CAD>EDFEGFHCI@JHKBLJMGNMONPOQLRISTRUTVUWVXWYXZS[Y\[]\^]_Z@`A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_``^a+@@ b`cbdcedfegfhgihjikjlkmlnQoKpnqPrqsrtsutvpwmx yxzy{z| }{~}~``a`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x y z { | } ~   +@ w            `````````````````````_, ``````````````@@` @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@          @@@@@@@@@@@@@@@@@@ @@ @@ @@ @@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ ! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;: @@!@@"@@#@@$@@%@@&@@'@@(@@)@@*@@+@@,@@-@@.@@/@@0@@1@@2@@3@@4@@5@@6@@7@@8@@9@@:@@;@@ ~@' @@@ @@@@@ @ @ @ @ @ @ @@ @ @ @ @ @ @ @ @ @ @      @ @@ @ @     @ @@ @ @ @ @@ @ @@ ! "!#"$#%$&%'& ``@@@@@@ @ @ @ ` @@@``@@@@@@ @!@"@#@$@%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;@<@@=@>@ @@?@@@@A@BAC@@DBE@@FDGE(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@; @<@=`> ?`@`A`B`C`D`E`F`G`HFIHJGKILKMLN@@@ OPOQPRQSRTSUTVUWVXWYXZY[Z\[]\^]_^`_a`bacbdcedfegfH`I`J`K`L`M`N@O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnmonpoqprqsrts uvtw=x>y@@z@@@{@@@|z}@@@~@@@@|}~vh@i@j@k@l@m@n@o@p@q@r@s@t@u @v@w`x y`z`{`|`}`~`````````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@wxy@@@@@ @@` ``````````@@@@@@@@@@@@@ @ @ # @  @  @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@` " @ @ @@ @ ``````````@@@@@@@@@@@@@@@@@@@@@@          @ @ @@@@ @@@!"!#"$#%&%'&@ @ @ @ @ @@@@@@@@@@@ @@` ```` `!`"`#`$`%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCEDFEGF(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@A@B@C@D@E@F@G@HIGJKLM@@NMO$POQPRQSRTSUTVUWXIYXZY[Z\[]\^]_^`_a`bacbdcedfegfH @I@J`K L`M`N`O`P`Q`R`S`T`U`V`W`X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnmonpoqprqsrtsutvuwvxwyxzy{z|}|~}~h@i@j@k@l@m@n@o@p@q@r@s@t@u@v@w@x@y@z@{@|@}@~@@ ~@@'&^Territory Sales Plan SmartMaster^Table of Contents9^Click a tab or a button to use a SmartMaster sheet.'  'Sheet'Description%5CSheetnamelTerritory Sales;'Forecast or plan sales for specific accounts within a'a territory. 'Information? 'Help, tips, and details on file sharing, conventions, and& 'macros used in this SmartMaster.^Territory Sales Plan'Territory"Date 'Established Customers^This Yr. Forecast^Last Yr. Actual^% Change ^Change%.qC;%C;%C;%cC;%8C;%&C;% "C   ; % %C   ; % C   ; % C   ; % C   ; % P9C   ; % C   ; % 'C   ; % :qC   ; % sC   ; %mC;%ƎC;%C;%#C;%2C;%DC;'Subtotals*cCPP;*JCPP;%$gC;%C;'New Customers%C;%%C;%=C;%"C;%}C;%C;%C;%C;%/C;%!C;%'C;%C;'Subtotals*\9CPP;*~CPP;%*mC;%sC;'Prospective Customers^Expected Value^Close Quarter^Probability^Annual Potential;FqC  ?;;oC  ?;;jnC  ?;;p8C  ?;; C  ?;; ҎC      ?; !'Subtotals*!,C P P;!*!8"C P P;!#'All Customers#^This Yr. Forecast#^Last Yr. Actual#^% Change #^Change $'Totals:$‰C!!;$,$0gC;$%$VC$$$;$%$cC$$$;$'SCREEN-ADJUST 'CODE'DESCRIPTION'\0'{ZOOM_TEST})'; Senses screen resolution and sets0'{Let ZM_NRML;@Vlookup(ZM_SCRN;ZM_TABLE;1)}$'; view preferences accordingly/'{Let ZM_ALL;@Vlookup(ZM_SCRN;ZM_TABLE;2)}4'{Set "Window-Custom-Zoom";ZM_NRML}{Calc}{Quit}'ZOOM_TEST>'{If @Info("Screen-Width")<=640}{Let ZM_SCRN;640}{Return}> '{If @Info("Screen-Width")<=800}{Let ZM_SCRN;800}{Return}@ '{If @Info("Screen-Width")<=1024}{Let ZM_SCRN;1024}{Return} '{Let ZM_SCRN;1280}{Return} 'ZM_SCRN  "NORMAL"FULL PAGE'ZM_TABLE@@T\ 'ZOOM FACTOR 'CODE'DESCRIPTION'ZOOM_RTN-'{Set "Window-Custom-Zoom";ZM_ALL}{Quit}('; Sets view to display entire page 'ZM_NRML 'ZM_ALL@'ZM_RESTORE4'{Set "Window-Custom-Zoom";ZM_NRML}{R}{L}{Quit}'; Resets view to normal'PRINT SHEET 'CODE'DESCRIPTION'SHT_PRINTH'{Set "Print-Range";SHEET_RANGE}{Set "Print-Footer-Center-Text";""}'; Prints spreadsheet pageF'{Set "Print-Orientation";"Portrait"}{Set "Print-Fit-Page";"Yes"}$'{Set "Print-Margin-Top";".75"}E '{Set "Print-Margin-Left";".75"}{Set "Print-Margin-Right";".75"}'!'{Set "Print-Margin-Bottom";".25"}&"'{BACKGRND 0}{Print?}{BACKGRND 2} #'{Quit}%'BACKGRND%'{Define BCK_COL:V}-%'; Sets / Resets light yellow background&'{Let RNG_NUM;1}{BCK_LOOP}('BCK_LOOP>('{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+)'{If 1-@Isrange(@@(RNG_NAME))}{Return},*'{Style-Interior BCK_COL;;;;;+RNG_NAME}.+'{Let RNG_NUM;RNG_NUM+1}{Branch BCK_LOOP} -'BCK_COL-/'PRINT INFORMATION /'CODE/'DESCRIPTION0'INFO_PRINT0'{Define INFO_TOPIC:V}00'; Prints Topics from the Information sheet1'{Dialog DLG_INFOPRT}2'{If RES_INFOPRT=0}{Quit}*3'{Set "Print-Footer-Center-Text";"^"})4'{Set "Print-Centered";"Horizontal"}F5'{Set "Print-Orientation";"Portrait"}{Set "Print-Size";"Fit-All"}#6'{Set "Print-Margin-Top";".5"}C7'{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'8'{Set "Print-Margin-Bottom";".25"}&9'{Let UPPER_LEFT;@Info("Origin")}':'{If ANS_INFOPRT=0}{INFO_CURR_PRT}?;'{If ANS_INFOPRT}{Select @Vlookup(INFO_TOPIC;INFO_LIST;1)}<'{Style-Interior 0}='{Print?}>'{Style-Interior 2}?'{Edit-Goto +UPPER_LEFT} @'{Quit}B'INFO_CURR_PRTB'{Select INF_OVER_RANGE}$C'{Select-Append INF_STEP_RANGE}$D'{Select-Append INF_TIPS_RANGE}$E'{Select-Append INF_CONVENTION}$F'{Select-Append INF_NOTE_RANGE}$G'{Select-Append INF_ABOU_RANGE}H'{Return}J'UPPER_LEFTJ'$D:$A$281L'INFO_LISTLL'INF_OVER_RANGEMM'INF_STEP_RANGENN'INF_TIPS_RANGEOO'INF_CONVENTIONP P'INF_NOTE_RANGEQ Q'INF_ABOU_RANGES'INFO_TOPICSU'DLG_INFOPRT U'DIALOGU'InfoPrintVpVV~V|V0VTV'""V'""#V '"Select Information to Print"V  W'FONTW W'"Helv"XXXvXX(X@X'"button"X'"Current topic"X X YY*YpYY*Y@Y'"button"Y'"All topics"Y Y ZZZPZZZ@Z'"button" Z'"OK"Z [[,[P[[[@['"button"['"Cancel"[ \'END DIALOG^'SAMPLE DATA ^'CODE^'DESCRIPTION_'SAMPDATA=_'{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}9_'; Displays Sample data, preserving existing entries5`'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}:a'{If @Exact(CURR_SCEN;"sample")}{Branch SAMP_RESTORE}b'{Dialog DLG_SAMPLE1}c'{If RES_SAMPLE1=0}{Quit}d'{Let PREV_SCEN;CURR_SCEN}e'{UPDATE}*f'{Scenario-Show "sample"}{Calc}{Quit}h'SAMP_RESTOREh'{Dialog DLG_SAMPLE2}i'{If RES_SAMPLE2=0}{Quit}+j'{Scenario-Show PREV_SCEN}{Calc}{Quit}l'PREV_SCEN l'unnamedm'CURR_SCEN m'sampleo'DLG_SAMPLE1 o'DIALOG o'Sample1ppppfpxp`ptp'""p'""p '"Sample Data"p  q'FONTq q'"Helv"rrrr0rr@r'"static"mr'"You can use a set of sample data to see how this SmartMaster works. You can restore the data that is"r sssPsss@s'"button" s'"OK"s tt,tPttt@t'"button"t'"Cancel"t uu8uu4uu@u'"static"Wu'"currently in this SmartMaster by clicking the Sample Data button a second time."u v'END DIALOGx'DLG_SAMPLE2 x'DIALOG x'Sample2ypyydyxy`yTy'""y'""y '"Sample Data"y  z'FONTz z'"Helv"{{{{0{{@{'"static"[{'"Restore the data that was in this SmartMaster before you displayed the sample data?"{ |||P|||@|'"button" |'"OK"| }},}P}}}@}'"button"}'"Cancel"} ~'END DIALOG'KEEP DATA 'CODE'DESCRIPTION'KEEPDATAG'{If @Count(SCENARIO_LIST)=@Rows(SCENARIO_LIST)-1}{Branch K_LIMIT}&'; Stores user-data in a scenario'{Dialog DLG_KEEPDATA}'{If RES_KEEPDATA=0}{Quit}*'{If RES_KEEPDATA=3}{Branch K_UPDATE}('{If RES_KEEPDATA=4}{Branch K_HELP}'{If @Length(@S(ANS_KEEPDATA))<1}{Alert "To create a scenario, you must enter a scenario name. Press OK to return to the Keep Data dialog box."}{Branch KEEPDATA}Z'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(ANS_KEEPDATA))))}{Branch K_EXISTS}3'{Scenario-Create @Lower(@Trim(ANS_KEEPDATA))}!'{Let RNG_NUM;1}{K_VERSIONS}>'{Put SCENARIO_LIST;0;@Count(SCENARIO_LIST);ANS_KEEPDATA}1'{Scenario-Show @Lower(@Trim(ANS_KEEPDATA))}'{Calc}{Return}'K_UPDATE&'{CLEAN_LIST}{Dialog DLG_UPDDATA}'{If ANS_UPDDATA<0}{Quit}'{If RES_UPDDATA=0}{Quit}H'{Scenario-Delete @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}H'{Scenario-Create @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}"'{Let RNG_NUM;1}{UP_EXISTING}R'{Scenario-Show @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}{Calc}{Quit}'CLEAN_LIST'{Blank ANS_SWAPDATA}'CLEAN_LOOP3'{If ANS_SWAPDATA>@Count(UPDATE_LIST)}{Return}'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))))}{Let ANS_SWAPDATA;ANS_SWAPDATA+1}{Branch CLEAN_LOOP}U'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR}' '{Branch CLEAN_LOOP}'UP_EXISTING>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}Q'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}Q'{Version-Create +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}'{Scenario-Add-Version @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)));;+RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}1'{Let RNG_NUM;RNG_NUM+1}{Branch UP_EXISTING} 'K_HELP'{Dialog DLG_KHELP}'{Branch KEEPDATA} 'K_LIMIT'{Alert +"The maximum number of "&@String(@Count(SCENARIO_LIST);0)&" scenarios is in use. You must delete a scenario before creating a new one."} '{Quit}'K_EXISTSw'{Alert +""""&@Lower(@Trim(ANS_KEEPDATA))&""" already exists. Please use another scenario name."}{Branch KEEPDATA}'K_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}<'{Version-Create +RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}_'{Scenario-Add-Version @Lower(@Trim(ANS_KEEPDATA));;+RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}0'{Let RNG_NUM;RNG_NUM+1}{Branch K_VERSIONS} 'RNG_NUM'RNG_NAME 'DATA_09'DLG_KEEPDATA 'DIALOG'KeepDatap(@'""'"" '"Keep Data"  'FONT '"Helv">@ '"edit"'"" (P@'"button" '"OK" (DP@'"button"'"Cancel" ($P@'"button"'"Update..." (hP@'"button" '"Help" @$@'"static"E'"You can create a new scenario or update an existing scenario." 0@'"static"y'"This SmartMaster can keep more than one set of data in this file. Each set of data you keep is called a scenario." l@'"static"*'"Enter a name for the new scenario:" 'END DIALOG'DLG_UPDDATA 'DIALOG 'UpdateplH'""'"" '"Update"  'FONT '"Helv"H`RFB@'"listbox"'""  'UPDATE_LIST0@'"static"['"Select the scenario you want to update with the data currently in this SmartMaster." , P@'"button" '"OK" ,,P@'"button"'"Cancel" 'END DIALOG'DLG_KHELP 'DIALOG 'KHELPp*@d'""'"" '"Keep Data Help"  'FONT '"Helv"(P@'"button" '"OK" T@'"static"'For more information on using Version Manager to create scenarios and share information, search on "Version Manager" in Help. 'END DIALOG'SWAP DATA 'CODE'DESCRIPTION'SWAPDATA''{CLEAN_LIST}{Dialog DLG_SWAPDATA}3'; Switches to a scenario selected by the user'{If ANS_SWAPDATA<0}{Quit}'{If RES_SWAPDATA=0}{Quit}.'{If RES_SWAPDATA=3}{Branch DEL_SCENARIO}='{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}5'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}''{If CURR_SCEN<>"unnamed"}{UPDATE}%'{If CURR_SCEN="unnamed"}{UPDUN}I'{Scenario-Show @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}C'{If @Scenariolast(@Cellpointer("Filename"))<>"-blank-"}{Quit}<'{Scenario-Delete "unnamed"}{Scenario-Create "unnamed"}F'{Let RNG_NUM;1}{UP_UNNAMED}{Scenario-Show "unnamed"}{Calc}{Quit} 'UPDUN'{Dialog DLG_UPDUN}'{If RES_UPDUN=3}{Quit} '{If RES_UPDUN=1}{KEEPDATA}'{Let RES;1}{Return}'UP_UNNAMED>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}*'{Version-Delete +RNG_NAME;"unnamed"}*'{Version-Create +RNG_NAME;"unnamed"};'{Scenario-Add-Version "unnamed";;+RNG_NAME;"unnamed"}0'{Let RNG_NUM;RNG_NUM+1}{Branch UP_UNNAMED}'LIST_RNGؐCSheetlCollRowl: ..SheetlCollRowlRC:B255..C:B255'LIST_ADDRLDCCSheetlCollRowl:  C:B254 'RES'DEL_SCENARIO'{If ANS_SWAPDATA<1}{Alert "The scenario named ""-Blank-"" cannot be deleted. This scenario is used to clear data from the SmartMaster and create a blank, unnamed scenario."}{Branch SWAPDATA}k'{Alert +"Delete """&@Index(SCENARIO_LIST;0;ANS_SWAPDATA)&""" scenario?";2;"Stop";RES}{If 1-RES}{Quit}K'{Scenario-Delete @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}!'{Let RNG_NUM;1}{D_VERSIONS}Y'{If ANS_SWAPDATA=@Count(SCENARIO_LIST)-1}{Recalc LIST_ADDR}{Blank +LIST_ADDR}{Quit},'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}/'{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR} '{Quit}'D_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}T'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}0'{Let RNG_NUM;RNG_NUM+1}{Branch D_VERSIONS}'SCENARIO_LIST '-Blank-@d'UPDATE_LISTt' < Blank Cell. To increase limit, 1) place cell pointer on blank cell, and 2) insert as many rows as you like. 'UPDATE3 '{Let RNG_NUM;1}{Blank NO_UPDATE}{UPDATE_TEST}!'{If NO_UPDATE}{Return}-"'{If @Exact(CURR_SCEN;"sample")}{Return};#'{If @Exact(CURR_SCEN;"unnamed")}{UPDATE_POST}{Return}*$'{Recalc FRM_UPDSC}{Dialog DLG_UPDSC}%'{If RES_UPDSC=3}{Quit}#&'{If RES_UPDSC=1}{UPDATE_POST}''{Return})'UPDATE_TEST>)'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}<*'{If 1-@Isrange(@@(RNG_NAME))}{Let NO_UPDATE;1}{Return}8+'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Return}1,'{Let RNG_NUM;RNG_NUM+1}{Branch UPDATE_TEST}.'UPDATE_POST*.'{Version-Update +RNG_NAME;CURR_SCEN}/'UPDATE_LOOP/'{Let RNG_NUM;RNG_NUM+1}>0'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+1'{If 1-@Isrange(@@(RNG_NAME))}{Return}D2'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Branch UPDATE_POST}3'{Branch UPDATE_LOOP}5'NO_UPDATE57'DLG_SWAPDATA 7'DIALOG7'SwapData8p8 8j8H888'""8'""8 '"Swap Data"8 8 'RES_SWAPDATA 9'FONT9 9'"Helv"::4::t:RF:B@:'"listbox":'"": : 'SCENARIO_LIST: 'ANS_SWAPDATA;;;;$;;@;'"static"C;'"Select the scenario you want to swap into this SmartMaster."; <,< <P<<<@<'"button" <'"OK"< =,=,=P===@='"button"='"Cancel"= >,>T>P>>>@>'"button">'"Delete"> ?'END DIALOGA'DLG_UPDSC A'DIALOG A'Update1BpBBBbBhBtB'""B'""B '"Update Scenario"B  C'FONTC C'"Helv"DD DDXDD@D'"static"RD#C:The scenario named "m" has changed. Update "m?">DThe scenario named "sample" has changed. Update "sample?"D EEEPEEE@E'"button" E'"Yes"E FF$FPFFF@F'"button" F'"No"F GGNGPGGG@G'"button"G'"Cancel"G H'END DIALOGJ'DLG_UPDUN J'DIALOG J'unnamedKpKKKxKKtK'""K'""K '"Update Scenario"K  L'FONTL L'"Helv"MMMM6MM@M'"static"CM'"The current scenario is unnamed. Assign a name and keep it?"M NNNPNNN@N'"button" N'"Yes"N OO$OPOOO@O'"button" O'"No"O PPNPPPPP@P'"button"P'"Cancel"P Q'END DIALOGS'SHOW MACROS S'CODES'DESCRIPTIONT'MACRO_SHOWT'{Show-Sheets MACROS:A1}%T'; Show / Hide this Macros sheet!U'{Edit-Goto MACROS:A1}{Quit}W'MACRO_HIDE#W'{Home}{Hide-Sheets MACROS:A1}&X'{Edit-Goto INFORMATION:A1}{Quit}Z'SHOW NOTES FIELDS Z'CODEZ'DESCRIPTION['NOTES_SHOW['{Show-Sheets MACROS:A1}'['; Navigate to the Notes/FX fields\'{Edit-Goto NOTES_FIELDS}&]'{Edit-Goto "NOTES FIELDS"}{Quit}_'PRINT MACROS _'CODE_'DESCRIPTION`'MACRO_PRINT`'{DIALOG DLG_MACPRINT})`'; Print sections of the macro sheeta'{IF RES_MACROPRT=0}{Quit}]b'{IF ANS_MACROPRT1}{Set "Print-Range";MACROS_RANGE}{Set "Print-Orientation";"Landscape"}\c'{IF ANS_MACROPRT2}{Set "Print-Range";NOTES FIELDS}{Set "Print-Orientation";"Portrait"}^d'{IF ANS_MACROPRT3}{Set "Print-Range";RN_TABLE_RANGE}{Set "Print-Orientation";"Portrait"})e'{SET "Print-Centered";"Horizontal"}*f'{SET "Print-Footer-Center-Text";"^"}&g'{SET "Print-Size";"Fit-Columns"}#h'{SET "Print-Margin-Top";".5"}Ci'{SET "Print-Margin-Left";".5"}{SET "Print-Margin-Right";".5"}'j'{SET "Print-Margin-Bottom";".25"}k'{Print?} l'{QUIT}n'DLG_MACPRINT n'DIALOGn'MacPrintopo oo|o0oTo'""o'""#o '"Select Information to Print"o  p'FONTp p'"Helv"qqqvqq(q@q'"button"q'"Macros"q q rrrrr*r@r'"button"r'"Notes Fields"r r ss4sss,s@s'"button"s'"Range Name Table"s s tttPttt@t'"button" t'"OK"t uu,uPuuu@u'"button"u'"Cancel"u v'END DIALOG'END OF MACROS'NOTES FIELDS'Num_User_ScenariosR'Current_Scenario7filenameOz@<<@123>>SCENARIOLAST('Established_ForecastFC'Established_ActualPC'New_ForecastlC'New_Actual;C'Prospective_ExpectedC!'Prospective_Potential}C!'ANS_INFOPRT'C:L89..C:L89'ANS_KEEPDATA'C:L184..C:L184'ANS_MACROPRT1'C:L370..C:L370'ANS_MACROPRT2'C:L371..C:L371'ANS_MACROPRT3'C:L372..C:L372'ANS_SWAPDATA'C:L315..C:L315'ANS_UPDDATA'C:L197..C:L197'BACKGRND'C:B38..C:B38 'BCK_COL'C:B46..C:B46'BCK_LOOP'C:B41..C:B41'CLEAN_LIST'C:B151..C:B151'CLEAN_LOOP'C:B152..C:B152'CURR_SCEN'C:B110..C:B110 'DATA_01'B:C4..B:C4 'DATA_02'B:H4..B:H4 'DATA_03'B:B7..B:B17 'DATA_04'B:E7..B:F17 'DATA_05'B:B20..B:B25 'DATA_06'B:E20..B:F25 'DATA_07'B:B28..B:B33 'DATA_08'B:F28..B:H33'DEL_SCENARIO'C:B240..C:B240'DLG_INFOPRT'C:B86..C:B86'DLG_KEEPDATA'C:B181..C:B181'DLG_KHELP'C:B203..C:B203'DLG_MACPRINT'C:B367..C:B367'DLG_PERSONAL'C:B380..C:B380'DLG_SAMPLE1'C:B112..C:B112'DLG_SAMPLE2'C:B121..C:B121'DLG_SWAPDATA'C:B312..C:B312'DLG_UPDDATA'C:B194..C:B194'DLG_UPDSC'C:B322..C:B322'DLG_UPDUN'C:B331..C:B331'D_VERSIONS'C:B249..C:B249'FRM_UPDSC'C:I325..C:I325'INFORMATION'D:A1..D:A1'INFO_ABOUT'D:A329..D:A329'INFO_CONVENTION'D:A225..D:A225'INFO_CURR_PRT'C:B67..C:B67'INFO_LIST'C:B77..C:C82'INFO_NOTESFX'D:A281..D:A281 'INFO_OVERVIEW 'D:A60..D:A60 'INFO_PRINT 'C:B49..C:B49 'INFO_STEPS 'D:A118..D:A118 'INFO_TIPS 'D:A174..D:A174 'INFO_TOPIC 'C:B84..C:B84'INF_ABOU_RANGE'D:B331..D:H343'INF_CONVENTION'D:B231..D:H242'INF_NOTE_RANGE'D:B283..D:H293'INF_OVER_RANGE'D:B62..D:H78'INF_STEP_RANGE'D:B120..D:H135'INF_TIPS_RANGE'D:B176..D:H187'KEEPDATA'C:B130..C:B130'K_EXISTS'C:B170..C:B170 'K_HELP'C:B164..C:B164 'K_LIMIT'C:B167..C:B167'K_UPDATE'C:B143..C:B143'K_VERSIONS'C:B172..C:B172'LIST_ADDR'C:B237..C:B237'LIST_RNG'C:B236..C:B236 'MACROS'C:A1..C:A1'MACROS_RANGE'C:A3..C:L397'MACRO_HIDE'C:B344..C:B344'MACRO_PRINT'C:B353..C:B353 'MACRO_SHOW 'C:B341..C:B341!'NOTES FIELDS!'C:A435..C:B442"'NOTES_FIELDS"'C:A433..C:A433#'NOTES_SHOW#'C:B348..C:B348$'NO_UPDATE$'C:B310..C:B310%'PERSONALIZE%'C:B378..C:B378&'PREV_SCEN&'C:B109..C:B109 ''RES''C:B238..C:B238('RES_INFOPRT('C:L87..C:L87)'RES_KEEPDATA)'C:L182..C:L182*'RES_MACROPRT*'C:L368..C:L368+'RES_SAMPLE1+'C:L113..C:L113,'RES_SAMPLE2,'C:L122..C:L122-'RES_SWAPDATA-'C:L313..C:L313.'RES_UPDDATA.'C:L195..C:L195/'RES_UPDSC/'C:L323..C:L3230'RES_UPDUN0'C:L332..C:L3321'RNG_NAME1'C:B179..C:B179 2'RNG_NUM2'C:B178..C:B1783'RN_TABLE3'C:A480..C:A4804'RN_TABLE_RANGE4'C:A481..C:B5725'SAMPDATA5'C:B96..C:B966'SAMP_RESTORE6'C:B105..C:B1057'SCENARIO_LIST7'C:B254..C:B2878'SHEET_RANGE8'B:B2..B:H379'SHT_PRINT9'C:B30..C:B30:'SWAPDATA:'C:B211..C:B211;'TABLE_CONTENTS;'A:A1..A:A1<'TERRITORY<'B:A1..B:A1 ='UPDATE='C:B289..C:B289>'UPDATE_LIST>'C:B255..C:B287?'UPDATE_LOOP?'C:B304..C:B304@'UPDATE_POST@'C:B303..C:B303A'UPDATE_TESTA'C:B298..C:B298 B'UPDUNB'C:B224..C:B224C'UPPER_LEFTC'C:B75..C:B75D'UP_EXISTINGD'C:B157..C:B157E'UP_UNNAMEDE'C:B229..C:B229 F'ZM_ALLF'C:B25..C:B25 G'ZM_NRMLG'C:B24..C:B24H'ZM_RESTOREH'C:B27..C:B27 I'ZM_SCRNI'C:B14..C:B14J'ZM_TABLEJ'C:B16..C:D19K'ZOOM_RTNK'C:B22..C:B22L'ZOOM_TESTL'C:B9..C:B9M'\0M'C:B4..C:B4^Information ^Index(^Click a button to go to a subject. 'Subject'Description'Overview1'General information about this SmartMaster. 'Steps)'Procedures to use this SmartMaster. 'Tips/ 'Helpful hints for using this SmartMaster. 'Conventions6 'Details on conventions used in this SmartMaster.'Notes/FX Enabling3'Description of Notes/FX and available fields. 'Macros;'Individual macro commands and their descriptions used'in this SmartMaster. 'About:'Information about the developer of this SmartMaster.4>^Overview: The Territory Sales Plan SmartMasterq@'The Territory Sales Plan SmartMaster projects a bottom-up forecast or plan. Territory managers can use thismA' template to communicate local sales plans to corporate headquarters. It is designed to be used at the !B'beginning of a sales year. sD'The SmartMaster is broken down so that the user can enter forecasted sales for three categories of customers:F' Established customersH' New customersGI' A customer that has made their first purchase in the past year.K' Prospective customers@L' A customer that has not yet purchased from your company.7x^Steps: Using the Territory Sales Plan SmartMaster]z'1. Enter the forecasted and actual sales information for established and new customers.:|'2. Under prospective customers, enter the following:~'  Close QuarterE' The quarter in which you expect the account to be closed.'  Probability<' The expected probability of closing the account.'  Annual Potential'' The annual potential sales. ^Tipsm' The expected value of prospective customers is calculated by multiplying the annual potential by thel' probability of closing the account by the remaining number of quarters in the year, so choose these' values carefully.q' For example, if the annual potential sales to ABC Company are $20,000 with a 70% probability of closing p' in the second quarter, the expected value of ABC is $10,500. The associated formula is detailed below:<' @IF(20000,@ROUND(+20000*.70*((5-2)/4),0),"") = 10500^Conventions'Cell Typesi'Shaded cells are data entry areas. Outlined cells contain formulas that are automatically computed.'Printing.'All forms print in portrait orientation. 'Dates!'Enter the date as MM/DD/YY.*^Using this SmartMaster with Notes/FXn'Notes/FX lets you exchange data between applications by embedding the data as an object in a Notes form.p'In 1-2-3, the range called "Notes Fields" can be made available to Notes for exchanging data between Notes'and the spreadsheet. i!'This SmartMaster contains fields that can be used for Notes/FX applications. To see the range namedp"'"Notes Fields," click on the Notes Fields button. For more information about using Notes/FX, see the Notes#'documentation.K^About this SmartMastercM'This SmartMaster was developed by KMT Software, Inc. KMT Software is the developer of severaldN'add-on products that are marketed under the Lotus name through Lotus Selects. KMT Software hasbO'worked closely with Lotus to develop the Lotus SmartMaster Collection for 1-2-3 Release 5, aeP'collection of dozens of additional SmartMaster templates. The Lotus SmartMaster Collection for fQ'1-2-3 Release 5 includes SmartMaster templates to help you manage your business as well as your %R'personal planning and finances.kT'To order or learn more about the Lotus SmartMaster Collection for 1-2-3 Release 5, in the U.S. pleaseLU'call Lotus Selects at 1-800-635-6887. In Canada, call 1-800-GO-LOTUS.-U_ ArialSWISSSWISSSWISSSWISSSWISSSWISSSWISS      O;4!*@d|^|5 _-oZ/j(5 u|xd2<! >{Home}{Edit-Goto B:A1}8 .*5 u|xd2<+ >"{Home}{Edit-Goto INFORMATION:A1} 8  .*5 _{oZaJ?OvITxw<<'@5  V1Dx#6C# Keep Data{Branch KEEPDATA} @5  էX8px#^C# Swap Data{Branch SWAPDATA} >5 ֌:x( xwIC. Information{Edit-Goto Information:A1}s  q%5  x#IC% Sample Data{Branch SAMPDATA} N5  ȯf*xwd2CZoom{Branch ZOOM_RTN}  E%5 K'0xe/(Restore Zoom{Branch ZM_RESTORE}!  % K5  #|#xwUC Print{Branch SHT_PRINT}  >%5  {LwZaEV2?Ovdx<< +>'5 !0 Fx&UC"Print{Branch MACRO_PRINT}$,5 "XVxIC' Hide Macros{Branch MACRO_HIDE}$N5 &N 0xUC-Range Name Table{Edit-Goto RN_TABLE}?$o5 '"  xUCGNotes Fields 4{Edit-Goto NOTES_FIELDS}{Edit-Goto "NOTES FIELDS"}$P5  {LwZaEV25  |_1ZaE\?Ov ?(x<<(V#5 ',m)#xU)Return to Macros{Home} ?!d5 #9KxI)' Information{Branch MACRO_HIDE} !^5 $j#xU)"Print{Branch MACRO_PRINT} !,? Ov ?(x<<(V#5 (',m)#xU)Return to Macros{Home} ?!d5 )9KxI)' Information{Branch MACRO_HIDE} !^5 *j#xU)"Print{Branch MACRO_PRINT} !,4   =N 4  w4  4  %4  884  8JW85 _޸|wZa& A/5 u|xd2<$ >{Edit-Goto INFO_OVERVIEW}8 .*5 _8f֋ xZaE;<$5?Ov%IVxw<<;;'@5 (CXE(xwUCPrinta{INFO_PRINT 1};I ;L C*5 0~)&xwIC@Return to Territory Sales {Edit-Goto Territory Sales:A1}; ; +5 :xwd2C Information Index{Home}; ;P *5 _8f֋ wZaEuv$5?Ovm5x1<<uu );(5  |z26x1UCPrint{INFO_PRINT 2}uk uk")5 ; zx&d2C Information Index{Home}u uk"h5 _8f֋ wZaE$55 _8f֋ wZaE$5?Ov?IVxw<< '@5 (SXe%xwUCPrint{INFO_PRINT 5} !C'5 yx1d2C Information Index{Home}X !g5 $mn$xwUC.Notes Fields{Home}{Branch NOTES_SHOW}W !y&5 _8f֋ wZaEHI$5?OvIVxw<<HH'@5 (SXe%xwUCPrint{INFO_PRINT 6}H H!C'5  :xwd2C Information Index{Home}H5 H!'5 %L"x3&)BGo to Territory Sales&{Home}{Edit-Goto Territory Sales:A1}` w5 u|xd2<! >{Edit-Goto INFO_STEPS}8 .*5  u|xd2<  >{Edit-Goto INFO_TIPS} 8  .*5 u|xd2<# >{Edit-Goto INFO_NOTESFX}8 .*5 u|xd2<$ >{Home}{Branch MACRO_SHOW}8 .*5 u|xd2<! >{Edit-Goto INFO_ABOUT}8 .*5  Dx1IC@Return to Territory Sales {Edit-Goto Territory Sales:A1}u u"?Ov?5x1<<(<#5 x}7 x1UCPrint{INFO_PRINT 3}d q!*5 ux x1d2C Information Index{Home}  q!g5 f=x1IC@Return to Territory Sales {Edit-Goto Territory Sales:A1}}  !5 0*]#xwIC@Return to Territory Sales {Edit-Goto Territory Sales:A1} [!(5  )]#xwIC@Return to Territory Sales {Edit-Goto Territory Sales:A1}H H-!(5 +u|xd2<& >{Edit-Goto INFO_CONVENTION} 8  .*? Ovd9x1<<% >-5 ,+=#x1UCPrint{INFO_PRINT 4}}d=5 -q4x1d2C Information Index{Home}"<5 .z{_Sx1IC@Return to Territory Sales {Edit-Goto Territory Sales:A1}"G>? _ %UProject a bottom-up sales forecast or plan. Territory managers use this form to communicate local sales plans to corporate headquarters.Create a Territory Sales Plan Scott TuckerALIASDefaultALIAS Erin LimanLotus NotesELIMANLAN Manager Paul MoodyLotus NotesErin LimanALIAS"Scott TuckerLotus Notes!SmartMasterLotus Notes) Karen Vona McIntyreLotus Notes/l׍u@C:\SM4\BALSHEET.WK4m ar@D:\DARWIN\WORK\KMT2\BALSHEET.WK4@43F2?j/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: UUUUU@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J DOfq@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: Ε$s@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J !-Cs@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: SY܏+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4J I+@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: F+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4K ףp= +@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4< :b߱ي/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4L 5F/@A:\NEW_BAL2.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4<  \/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4< G;6v0@C:\123R4W\PROGRA/A:\BALSHEET.WK4? Qߦz0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< - {0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? 7&{0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< 8e|{0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? y@Ε0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< xV40@I:\KMT\BALSHEET./A:\BALSHEET.WK4E =e1@A:\BALSHEET.WK4/D:\DARWIN\WORK\NEW_SM.WK4T T`w1@D:\DARWIN\WORK\NEW_SM.WK4/D:\DARWIN\WORK\KMT2\NEW_SM.WK4@ A01@D:\DARWIN\WORK\KMT/I:\KMT\NEW_SM.WK4? SA@A:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 A@D:\DARWIN\WO/B:\PAUL.WK4? RA@B:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 l(B@D:\DARWIN\WO/A:\PAUL.WK4? ]B@A:\PAUL.WK4/C:\123R4W\WORK\PAUL.WK4Y """""B@D:\CSERVE\DOWNLOAD\PAUL.WK4/D:\FORMS\SSPC\SHEETS\AUTOZOOM.WK4O ŝ ND@D:\FORMS\SSPC\SHEETS\A)/D:\FORMS\SM_MAS02.WK4G 贁N D@D:\FORMS\SM_MAS02.WK4/D:\FORMS\SM_MAS03.WK4E y58O@C:\DATA\SM_MAS03.WK4/C:\DATA\SM_MAS04.WK4G yKs¦R@D:\FORMS\SM_MAS04.WK4/D:\FORMS\SM_MAS05.WK4G djR@D:\FORMS\SM_MAS05.WK4/D:\FORMS\SM_MAS06.WK4G bR@D:\FORMS\SM_MAS06.WK4/D:\FORMS\SM_MAS07.WK4G n;S@D:\FORMS\SM_MAS07.WK4/D:\FORMS\SM_MAS08.WK4S oi^S@D:\FORMS\SM_MAS08.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4_ ħS@D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS10.WK4W tľX@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC2.WK4W lUJd@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC3.WK4U Sd@C:\DATA\SM_MASTR\INVOIC3.WK4/C:\DATA\SM_MASTR\INVOIC4.WK4U ~9xf@C:\DATA\SM_MASTR\INVOIC4.WK4/C:\DATA\SM_MASTR\INVOIC5.WK4V  f@C:\DATA\SM_MASTR\INVOIC6.WK7/C:\DATA\SM_MASTR\SHELL.WK4T 7Ũof@C:\DATA\SM_MASTR\SHELL.WK4/C:\DATA\SM_MASTR\TERSALES.WK4M ;6*e@E:\GOLDSM\TSALES.WT4/E:\123R4W\MASTERS\TSALES.WT4V @E:\GOLDSM\WO_SELEC\TSALES.WT4/E:\123R4W\MASTERS\TSALES.WT4Z .}p@M:\GOLD_FIL\SMASTER\OLD\TSALES./M:\GOLD_FIL\SMASTER\TSALES.WT4DATA_08 sampleDATA_08%sampleDATA_08Sample Data3 bg@sampleDATA_08sample            M  E   c  3 a   N -blank-DATA_08%-blank-DATA_08Blank Data5g@-blank-DATA_08-blank-                       unnamedDATA_085g@unnamedDATA_08unnamed                     DATA_07 sampleDATA_07%sampleDATA_07Sample Data3 bg@sampleDATA_07sample 'Pacific Pipeline 'United Frozen Systems 'Precision Monolithics 'Osprey Partners 'Execucel Halides  'All Others -blank-DATA_07%-blank-DATA_07Blank Data5g@-blank-DATA_07-blank-         unnamedDATA_075g@unnamedDATA_07unnamed       "DATA_06unnamed sampleDATA_06%sampleDATA_06Sample Data3:mg@sampleDATA_06sample   c"  C p@@@]@]@`@ X@ -blank-DATA_06%-blank-DATA_06Blank Data5sg@-blank-DATA_06-blank-             unnamedDATA_065g@unnamedDATA_06unnamed            "DATA_05unnamed sampleDATA_05%sampleDATA_05Sample Data3:mg@sampleDATA_05sample 'Deer Valley Associates 'The Flintridge Group 'WebbChem 'The Cascade Agency 'Snelling Foods 'All Others -blank-DATA_05%-blank-DATA_05Blank Data5sg@-blank-DATA_05-blank-       unnamedDATA_055g@unnamedDATA_05unnamed       DATA_04 sampleDATA_04%sampleDATA_04Sample Data3>g@sampleDATA_04sample I 1 #:  ` }@  C]  C    6 Q?@ Z Cj N @ =@ Ĥ@ C@ @@@0ł@X@ -blank-DATA_04%-blank-DATA_04Blank Data5sg@-blank-DATA_04-blank-                                  unnamedDATA_045g@unnamedDATA_04unnamed                                 DATA_03 sampleDATA_03%sampleDATA_03Sample Data3>g@sampleDATA_03sample 'InterVista Indemnity 'Palisades Research 'Pantronics Group  'Metrola Property  'Kolgard ! 'HydroTube International  'Zabriskie Industries  'Amkor Pharmaceuticals 'Fountain Fresh 'Coastal Freightway 'All Others -blank-DATA_03%-blank-DATA_03Blank Data5sg@-blank-DATA_03-blank-                  unnamedDATA_035g@unnamedDATA_03unnamed                DATA_02 sampleDATA_02%sampleDATA_02Sample Data3>g@sampleDATA_02sample8@ -blank-DATA_02%-blank-DATA_02Blank Data5sg@-blank-DATA_02-blank-   unnamedDATA_025g@unnamedDATA_02unnamed "DATA_01unnamed sampleDATA_01%sampleDATA_01Sample Data3>g@sampleDATA_01sample South Central -blank-DATA_01%-blank-DATA_01Blank Data5gE#g@-blank-DATA_01-blank-  unnamedDATA_015g@unnamedDATA_01unnamed sample4sampleOriginal SmartMaster sample data set)g@samplesample# >g@sample# >g@sample# >g@sample# >g@sample# :mg@sample# :mg@sample# bg@sample# bg@sample9samplesampleScott TuckerLotus NotesDATA_019samplesampleScott TuckerLotus NotesDATA_029samplesampleScott TuckerLotus NotesDATA_039samplesampleScott TuckerLotus NotesDATA_049samplesampleScott TuckerLotus NotesDATA_059samplesampleScott TuckerLotus NotesDATA_069samplesampleScott TuckerLotus NotesDATA_079samplesampleScott TuckerLotus NotesDATA_08-blank-4-blank-Original SmartMaster blank data set+gE#g@-blank--blank-$ gE#g@-blank-$ sg@-blank-$ sg@-blank-$ sg@-blank-$ sg@-blank-$ g@-blank-$ g@-blank-$ g@-blank-;-blank--blank-Scott TuckerLotus NotesDATA_01;-blank--blank-Scott TuckerLotus NotesDATA_02;-blank--blank-Scott TuckerLotus NotesDATA_03;-blank--blank-Scott TuckerLotus NotesDATA_04;-blank--blank-Scott TuckerLotus NotesDATA_05;-blank--blank-Scott TuckerLotus NotesDATA_06;-blank--blank-Scott TuckerLotus NotesDATA_07;-blank--blank-Scott TuckerLotus NotesDATA_08unnamed+4g@unnamedunnamed$ g@unnamed$ g@unnamed$ g@unnamed$ g@unnamed$ g@unnamed$ g@unnamed$ g@unnamed$ ^B{ g@unnamed;unnamedunnamedScott TuckerLotus NotesDATA_01;unnamedunnamedScott TuckerLotus NotesDATA_02;unnamedunnamedScott TuckerLotus NotesDATA_03;unnamedunnamedScott TuckerLotus NotesDATA_04;unnamedunnamedScott TuckerLotus NotesDATA_05;unnamedunnamedScott TuckerLotus NotesDATA_06;unnamedunnamedScott TuckerLotus NotesDATA_07;unnamedunnamedScott TuckerLotus NotesDATA_08CR3CR3 PropertyDoc Info CommentsDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info ObjectDoc Info PropertyDoc Info TitleFM3FM3 PropertyWK3WK3 Property  OL O O5!O O   !   OO 5O O GO tO ^O:3(O $OCMHdrOL