O___ _ _#_ _&__# _O _O_u_u_Vu_u_Vu_Vu_Vu _Vu _: _Vs _8:_>B_@L___EE(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 DATA_09Nt&& DATA_10Nt DEL_SCENARIOt DIRECTNARIOt 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_ABOUTt?? INFO_CONVENTION INFO_CURR_PRTNBB INFO_LISTPRTNLQ INFO_NOTESFXN INFO_OVERVIEWN;; INFO_PRINTEWN00 INFO_STEPSEWNmm INFO_TIPSEWN INFO_TOPICEWNSS INF_ABOU_RANGEAM INF_CONVENTION INF_NOTE_RANGE INF_OVER_RANGE=E INF_STEP_RANGEoy 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 UPDATEONTENTS   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 CBCOPYTTSKL DF0PYTTS DS0PYTTS DSKPYTTS RN0PYTTSAM RS0PYTTSM!   ?? @VName8LBLBq+q+q+ 6Contents6_C6Direct Analysis6_C 6Macros6Information6"_C  Arial! Arial"  Arial#  Arial%%Times New Roman&  Arial MT' Arial(  Arial MT)  Arial* Arial MT+  Arial,  Arial- Arial MT/ Arial1  Arial3  Arial5  Arial6  Arial7 Arial8  Arial9 Arial: Arial;  Arial< Arial=  Arial>  Arial? Arial@ ArialA ArialB ArialC  ArialD  Arial MTE  Arial MTF ArialG ArialH  ArialI  ArialJ  ArialK ArialL ArialM ArialQ GillSans%STimes New Roman? !3) ##" C? : <3 <3 5'3_  _!#"# #6$=_ %*&#'8(*))*&+3_ ,#-__.#/#0#+1#2*3#4#5D_6C 7+8>93:#+;-<#=#>#+?_@#A#BCC#+D#+E#+FIGI+H6IJ)KIL) M%N#9P)_QR>SCT)UC_V,W!X8Y9 Z;[?\ <] ^B _) a eFfF gG hHjGkG lF mH o qH rK L <!!9@M !9A@9L M C <(_ IJIC S__ >C&& Q_ &"2@@STYL1SUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2 NormalUndefined"2NormalUndefined"2NormalUndefined"2NormalUndefinedq0*@@@ @@@ @@ @@  @@ @ @ @ @@@ @@@:@:@@ @@@:@:@@ @@@:@:@@ @@@:@@ @@ @@@:@@ @@ @@:;@ @@;   @;@ @#@ ```````` ` ` ` ` ` ` ~@' ('@@   @"@@@@@@y@@@@)@ @ @@@@ @ @@) @ @" @@@ @ @" @@)@ @ @ @@@@ @ @ @@) @ @@@@@ @ @ @@) @ @ @@@@@ @ @ @@) @ @ @" @@@@ @ @ @@    )@ @@@ @@@@ @ @ @@) @ @@@@@ @@@ @@)@ @ @@@@@ @ @@@)@ @ @@@@@ @ @@@@  @@@ @ @@@@@@ @ @2@@@@ @ @@@@ @ @@@@ @ @@@@ @ @@ @ @ @@@ ```````` ` ` ` ` ``````````````````` @ @@@!"#"$@@%$&@@@@@?@?A@BACBDCEDFE< `!`"`#`$`%`&` B@ @' #@ ###@@         #@@ #@ @ #@@   #@@   @```````` ` ` ` ` ``````````````````` ! "!#"$#%$&%'&(')(*)+*,+-.,/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`cbdcedfegfhgihjikjlkmlnQoKpnqrqsrtPutvpwmx 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@BACBDCE@@F@@@ G(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@; @<@=`> ?`@`A`B`C`D`E`F@G@HGIHJIKJLKMLNMONPOQPRQSRTSUTVUWVXWYXZY[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@hgihjikjlk mnlo=p>q@@r@@@s@@@trutvswuxwyxzn{z|{}|~}~h@i@j@k@l@m @n@o`p q`r`s`t`u`v`w`x`y`z@{@|@}@~@@@@@@@@@@@@@@@opqyv@@@@@@@@@@@@@@@@@@@@@@@@ @@` ``````````@@@@@@@@@@@@@@@@@@@@@@@@@@@#@@@@@"@@@@@@@@@@@@@@@@@@@@@@` ``````````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@           "@@"@$@!@@"" @"@ " @"@ " ! "!#"$#%$&%'&@ @ @ @ @ @@ @@` `````````@@@@ @!@"@#@$@%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?@>AB@C@@D@@EDF@@@GF(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@? @@@A`B C`D`E`F`G`HGIHJIKJLKMLN@ONPOQPRQSRTSUTVUWVXWYXZY[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@hgihjikjlkmlnmonpoqprsrtsutth@i@j@k@l@m@n@o@p@q@r@s@t@u@ ~@@'+^Direct Marketing Analysis SmartMaster^Table of Contents9^Click a tab or a button to use a SmartMaster sheet.'  'Sheet'Description%CSheetnamelDirect Analysis;'Use this SmartMaster to "run the numbers" on a direct'marketing campaign. 'Information@ 'Help, tips, and details on file sharing, conventions, and & 'macros used in this SmartMaster.^Direct Marketing Analysis'Promotion""Date ^Gross Margin per Unit^Direct Mail Cost per Unit' Selling Price' Circulars' Add: Handling Charge' Letters ' Total Revenue per Unit, OC;  ' Inserts ' Lift Pieces ' Cost of Merchandise ' Envelopes ' Shipping or Delivery ' Order Forms ' Order Processing ' List Rental' Cost of Returns' Assembly' Bad Debt' Addressing ' Other' Postage' Total Cost per Unit*SC? P? P; ' Other' Gross Margin per Unit,`GC  ; ' Direct Mail Cost per Unit*f_C?P?P;%^Net Profit and Break-even Point' Units Mailed' Response Rate' Unit Sales,C;' Gross Margin,́C;' Mailing Costs,SC;' Fixed Costs' Creative Development' Allocations, Other' Total Fixed Costs*NCPP; ' Total Net Profit: r_C; "' Break-even Unit Sales?"lGC ?;"#' Break-even Unit Mailing?#*?C ?;#&""Prepared by '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)}.'{Set "Window-Custom-Zoom";ZM_NRML}{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 sheet 'ZM_NRML'; Preferred zoom setting 'ZM_ALL@'; View entire sheet'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$320L'INFO_LISTLL'INF_OVER_RANGEMM'INF_STEP_RANGENN'INF_TIPS_RANGEOO'INF_CONVENTIONP P'INF_NOTE_RANGEQ Q'INF_ABOU_RANGES'INFO_TOPICS U'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'unnamedo'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}L'{Scenario-Show @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}{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_11'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_ADDRL 2CSheetlCollRowl:  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 "unnamed" has changed. Update "unnamed?"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('Promotion 'Date'Revenue_Per_UnitOC 'COGS_Per_UnitC'DM_Cost_Per_Unitz]C'Units_Mailed'Response_Rate'BE_Unit_Sales?C"'BE_Unit_MailingC#'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:C5..B:C5 'DATA_02'B:H5..B:H5 'DATA_03'B:D8..B:D9 'DATA_04'B:D12..B:D17 'DATA_05'B:C17..B:C17 'DATA_06'B:H8..B:H18 'DATA_07'B:H23..B:H24 'DATA_08'B:H29..B:H30 'DATA_09'B:G39..B:G39 'DATA_10'B:G18..B:G18'DEL_SCENARIO'C:B240..C:B240 'DIRECT'B:A1..B:A1'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:A320..D:A320'INFO_CONVENTION'D:A213..D:A213 'INFO_CURR_PRT 'C:B67..C:B67 'INFO_LIST 'C:B77..C:C82 'INFO_NOTESFX 'D:A272..D:A272 'INFO_OVERVIEW 'D:A60..D:A60 'INFO_PRINT 'C:B49..C:B49'INFO_STEPS'D:A110..D:A110'INFO_TIPS'D:A161..D:A161'INFO_TOPIC'C:B84..C:B84'INF_ABOU_RANGE'D:B322..D:H333'INF_CONVENTION'D:B219..D:H230'INF_NOTE_RANGE'D:B274..D:H284'INF_OVER_RANGE'D:B62..D:H70'INF_STEP_RANGE'D:B112..D:H122'INF_TIPS_RANGE'D:B163..D:H174'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:B445%'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:L1220'RES_SWAPDATA0'C:L313..C:L3131'RES_UPDDATA1'C:L195..C:L1952'RES_UPDSC2'C:L323..C:L3233'RES_UPDUN3'C:L332..C:L3324'RNG_NAME4'C:B179..C:B179 5'RNG_NUM5'C:B178..C:B1786'RN_TABLE6'C:A480..C:A4807'RN_TABLE_RANGE7'C:A481..C:B5728'SAMPDATA8'C:B96..C:B969'SAMP_RESTORE9'C:B105..C:B105:'SCENARIO_LIST:'C:B254..C:B287;'SHEET_RANGE;'B:B2..B:H39<'SHT_PRINT<'C:B30..C:B30='SWAPDATA='C:B211..C:B211>'TABLE_CONTENTS>'A:A1..A:A1 ?'UPDATE?'C:B289..C:B289@'UPDATE_LIST@'C:B255..C:B287A'UPDATE_LOOPA'C:B304..C:B304B'UPDATE_POSTB'C:B303..C:B303C'UPDATE_TESTC'C:B298..C:B298 D'UPDUND'C:B224..C:B224E'UPPER_LEFTE'C:B75..C:B75F'UP_EXISTINGF'C:B157..C:B157G'UP_UNNAMEDG'C:B229..C:B229 H'ZM_ALLH'C:B25..C:B25 I'ZM_NRMLI'C:B24..C:B24J'ZM_RESTOREJ'C:B27..C:B27 K'ZM_SCRNK'C:B14..C:B14L'ZM_TABLEL'C:B16..C:D19M'ZOOM_RTNM'C:B22..C:B22N'ZOOM_TESTN'C:B9..C:B9O'\0O'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. 'About9'Information about the developer of this SmartMaster9>^Overview: The Direct Marketing Analysis SmartMasterr@'The Direct Marketing SmartMaster provides you with the necessary tools to assess your direct mail efforts. nA'This SmartMaster automatically calculates the financial scenario of a direct mail campaign. In times ofnB'"mailing more for less," this SmartMaster will help you to manage your expense line, track the resulting:C'revenue, and provide you with a break-even analysis.<p^Steps: Using the Direct Marketing Analysis SmartMastersr'1. Enter all of the information about the product and its sales (e.g., cost, handling charge, bad debt, etc.)Dt'2. Enter the costs for all of the direct marketing materials. (u' Change labels where necessary.nw'3. Enter the response rate. You can either enter it as a percentage for example 1.8% or a as a decimal, x' for instance .018. ^Tipsr' If you don't know the breakdown of each individual item, enter the total item mailing cost in the "Other"3' calculation cell and label it "Total Cost."n' Fixed costs are the basis for break-even calculations, and 1-2-3 does a break-even analysis only when*' you have entered fixed-cost data.t' Run the model several times to measure projected profitability by using a different response rate, product ' cost, and so on.^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 dates 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.B^About this SmartMastercD'This SmartMaster was developed by KMT Software, Inc. KMT Software is the developer of severaldE'add-on products that are marketed under the Lotus name through Lotus Selects. KMT Software hasbF'worked closely with Lotus to develop the Lotus SmartMaster Collection for 1-2-3 Release 5, aeG'collection of dozens of additional SmartMaster templates. The Lotus SmartMaster Collection for fH'1-2-3 Release 5 includes SmartMaster templates to help you manage your business as well as your %I'personal planning and finances.kK'To order or learn more about the Lotus SmartMaster Collection for 1-2-3 Release 5, in the U.S. pleaseLL'call Lotus Selects at 1-800-635-6887. In Canada, call 1-800-GO-LOTUS.-U_ ArialSWISSSWISSSWISSSWISSSWISSSWISSSWISS      O=E4!*@XoyAL|^|5 _-oZ/j(5 u|xd21! >{Home}{Edit-Goto B:A1}8 .*5 u|xd21+ >"{Home}{Edit-Goto INFORMATION:A1} 8  .*5 _{oZa5J?OvŚIx<<m(@5  ^|2x65# Keep Data{Branch KEEPDATA} F J5  }x^5# Swap Data{Branch SWAPDATA}F  N5 (—!xU5 Print{Branch SHT_PRINT}  B#5 OcxI5. Information{Edit-Goto Information:A1}  n#5 N^GxI5% Sample Data{Branch SAMPDATA}  25  { A xd25Zoom{Branch ZOOM_RTN}  i25 Q~^xe/(Restore Zoom{Branch ZM_RESTORE}"2% 25 -Gxw47# Tips{Edit-Goto INFO_TIPS} j 5  {LwZaEV2?Ovi[x<<}*>&5 !1txUC"Print{Branch MACRO_PRINT}#-5 "XVxIC' Hide Macros{Branch MACRO_HIDE}#N5 &N 0xUC-Range Name Table{Edit-Goto RN_TABLE}2#o5 '"  xUCGNotes Fields 4{Edit-Goto NOTES_FIELDS}{Edit-Goto "NOTES FIELDS"}#P5  {LwZaEV25  |_1ZaE\5 $gGVx'IC' Information{Branch MACRO_HIDE} !5 (g jx'UC"Print{Branch MACRO_PRINT} !=5  |wx'Za&2?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   =F 4  oz4  4  4  884  8AN85 _޸|wZa& A/5 u|xd21$ >{Edit-Goto INFO_OVERVIEW}8 .*5 _8f֋ xZaE;<$5?Ov"I6x<<; ;(@5 (`X"xUCPrint{INFO_PRINT 1}; ; C$5 *n+xIC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1}; ; $5 E:xd2C Information Index{Home}; ; $5 _8f֋ wZaEmn$5?Ov̞Ix<<mm(@5  (Xp$xUCPrint{INFO_PRINT 2}m m!C&5 :xd2C Information Index{Home}m m!&5 _8f֋ wZaE$55 _8f֋ wZaE$5?Ov̞Ix<< (@5 (>W!xUCPrint{INFO_PRINT 5}g c B#5 |kyx%d2C Information Index{Home}  q g5 $mZ"xUC.Notes Fields{Home}{Branch NOTES_SHOW} !y$5 _8f֋ wZaE?@$5?Ov˞IMx<<??'@5 $p$xUCPrint{INFO_PRINT 6}? ?B K&5  ήxd2C Information Index{Home}? ? &5 %6=x&)>!Go to Direct Marketing Analysis{Home}{Edit-Goto B:A1}5 u|xd21! >{Edit-Goto INFO_STEPS}8 .*5  u|xd21  >{Edit-Goto INFO_TIPS} 8  .*5 u|xd21# >{Edit-Goto INFO_NOTESFX}8 .*5 u|xd21$ >{Home}{Branch MACRO_SHOW}8 .*5 u|xd21! >{Edit-Goto INFO_ABOUT}8 .*5 ;^,!xIC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1}m mz!&?Ov?xw4<<(<#5 |zU268xw4UCPrint{INFO_PRINT 3}X X )5 Aaxw4d2C Information Index{Home}  d f5 K.xw4IC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1}  5  c*xIC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1}  #5 ^(!xIC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1}? ? &5 .u|xd21& >{Edit-Goto INFO_CONVENTION} 8  .*? OvVxw4<< <%5 /!e`xw4UCPrint{INFO_PRINT 4}]W `45 0ynD6V xw4d2C Information Index{Home}c55 1X` AAxw4IC@Return to Direct Analysis {Edit-Goto Direct Analysis:A1} @3? _!##! p!#U|Use this SmartMaster to "run the numbers" on a direct mail campaign, including gross margin, costs, and break-even analysis.Analyze a Direct Marketing 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.WK4R wwwwwcg@C:\DATA\SM_MASTR\SHELL.WK4/C:\DATA\SM_MASTR\DIRECT.WK4O =c@E:\GOLDSM\DRCTMKT.WT4/E:\123R4W\MASTERS\DRCTMKT.WT4Y qq@E:\GOLDSM\WO_SELEC\DRCTMKT.WT4/E:\123R4W\MASTERS\DRCTMKT.WT4` Cem@M:\GOLD_FIL\SMASTER\OLD\DRCTMKT.6'?M/M:\GOLD_FIL\SMASTER\DRCTMKT.WT4"&DATA_09unnamed sampleDATA_09%sampleDATA_09Sample Data3y5fg@sampleDATA_09sample #&^Diana Siever, Product Mgr -blank-DATA_09%-blank-DATA_09Blank Data5K~gg@-blank-DATA_09-blank- & unnamedDATA_095̴~@unnamedDATA_09unnamed &"DATA_08unnamed sampleDATA_08%sampleDATA_08Sample Data3xKsfg@sampleDATA_08sample ]  -blank-DATA_08%-blank-DATA_08Blank Data5E9"gg@-blank-DATA_08-blank-   unnamedDATA_085̴~@unnamedDATA_08unnamed  "DATA_07unnamed sampleDATA_07%sampleDATA_07Sample Data3xKsfg@sampleDATA_07sample   -blank-DATA_07%-blank-DATA_07Blank Data5E9"gg@-blank-DATA_07-blank-   unnamedDATA_075Ƈ ̴~@unnamedDATA_07unnamed  " DATA_06unnamed sampleDATA_06%sampleDATA_06Sample Data3xKsfg@sampleDATA_06sample 5 5      %    E 5     -blank-DATA_06%-blank-DATA_06Blank Data5E9"gg@-blank-DATA_06-blank-                 unnamedDATA_065Ƈ ̴~@unnamedDATA_06unnamed                "DATA_05unnamed sampleDATA_05%sampleDATA_05Sample Data3xKsfg@sampleDATA_05sample '(Guarantee Card) -blank-DATA_05%-blank-DATA_05Blank Data5E9"gg@-blank-DATA_05-blank-  unnamedDATA_055Ƈ ̴~@unnamedDATA_05unnamed " DATA_04unnamed sampleDATA_04%sampleDATA_04Sample Data33fg@sampleDATA_04sample          -blank-DATA_04%-blank-DATA_04Blank Data5>T`gg@-blank-DATA_04-blank-          unnamedDATA_045Ƈ ̴~@unnamedDATA_04unnamed         "DATA_03unnamed sampleDATA_03%sampleDATA_03Sample Data33fg@sampleDATA_03sample d  -blank-DATA_03%-blank-DATA_03Blank Data5>T`gg@-blank-DATA_03-blank-   unnamedDATA_035Ƈ ̴~@unnamedDATA_03unnamed  "DATA_02unnamed sampleDATA_02%sampleDATA_02Sample Data33fg@sampleDATA_02sample@ -blank-DATA_02%-blank-DATA_02Blank Data5>T`gg@-blank-DATA_02-blank-  unnamedDATA_025Ƈ ̴~@unnamedDATA_02unnamed "DATA_01unnamed sampleDATA_01%sampleDATA_01Sample Data3fg@sampleDATA_01sample /^"Turbo-Kleen" Sampler @ 175,000 Units -blank-DATA_01%-blank-DATA_01Blank Data5>T`gg@-blank-DATA_01-blank-  unnamedDATA_015Ƈ ̴~@unnamedDATA_01unnamed "DATA_10unnamed sampleDATA_10%sampleDATA_10Sample Data3y5fg@sampleDATA_10sample  -blank-DATA_10%-blank-DATA_10Blank Data5K~gg@-blank-DATA_10-blank-  unnamedDATA_105̴~@unnamedDATA_10unnamed  sample4sampleOriginal SmartMaster sample data set)fg@samplesample# 3fg@sample# 3fg@sample# 3fg@sample# 3fg@sample# xKsfg@sample# xKsfg@sample# xKsfg@sample# y5fg@sample# y5fg@sample# y5fg@sample# fg@sample9samplesampleScott TuckerLotus NotesDATA_019samplesampleScott TuckerLotus NotesDATA_029samplesampleScott TuckerLotus NotesDATA_039samplesampleScott TuckerLotus NotesDATA_049samplesampleScott TuckerLotus NotesDATA_059samplesampleScott TuckerLotus NotesDATA_069samplesampleScott TuckerLotus NotesDATA_079samplesampleScott TuckerLotus NotesDATA_089samplesampleScott TuckerLotus NotesDATA_099samplesampleScott TuckerLotus NotesDATA_10 -blank-4-blank-Original SmartMaster blank data set+8&gg@-blank--blank-$ >T`gg@-blank-$ >T`gg@-blank-$ >T`gg@-blank-$ >T`gg@-blank-$ E9"gg@-blank-$ E9"gg@-blank-$ E9"gg@-blank-$ K~gg@-blank-$ K~gg@-blank-$ K~gg@-blank-$ K~gg@-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_08;-blank--blank-Scott TuckerLotus NotesDATA_09;-blank--blank-Scott TuckerLotus NotesDATA_10 unnamed+Ƈ ̴~@unnamedunnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ Ƈ ̴~@unnamed$ ̴~@unnamed$ ̴~@unnamed$ ̴~@unnamed9unnamedunnamedErin LimanLotus NotesDATA_019unnamedunnamedErin LimanLotus NotesDATA_029unnamedunnamedErin LimanLotus NotesDATA_039unnamedunnamedErin LimanLotus NotesDATA_049unnamedunnamedErin LimanLotus NotesDATA_059unnamedunnamedErin LimanLotus NotesDATA_069unnamedunnamedErin LimanLotus NotesDATA_079unnamedunnamedErin LimanLotus NotesDATA_089unnamedunnamedErin LimanLotus NotesDATA_099unnamedunnamedErin LimanLotus NotesDATA_10CR3CR3 PropertyDoc Info CommentsDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info ObjectDoc Info PropertyDoc Info TitleFM3FM3 PropertyWK3WK3 Property  HL H H-#H H   #   _HOH G qH H 3H H0G GCMHdrHL