{\rtf0\ansi{\fonttbl\f2\fswiss Helvetica;\f1\fmodern Courier;}
\paperw16380
\paperh8500
\margl120
\margr120
\pard\tx1440\tx2880\tx4320\tx5760\tx7200\tx8640\tx10080\tx11520\tx12960\tx14400\f2\b0\i0\ul0\fs24 These files demonstrate linked worksheets.\

\fs36\fi-20\li1440 \

\b\fi0\li0 Report
\b0 .
\b Mesa
\b0\fi-20\li1440 \
\
This file displays an employee performance review, complete with tables and graphs.  It allows you view customized letters for each of the 25 sales reps.\
\
It showcases:\
\
*  Using file links in Mesa to provide summaries.\
*  Mesa's ability to create custom form letters, including:\
		- current date\
		- custom data\
		- custom graphs\
*  Use of @CHOOSE and @VLOOKUP functions to further customize letters.\
*  Different graphs types\
*  Custom formatting, including different font types and font colors\
*  Mesa's ability to add graphics to embellish documents\
*  Some of Mesa's macro features\
*  Changing Linked Worksheets by changing the name of the linked sheet in one cell\
\
To change the region to examine, set cell P1 to "Sales_North", "Sales_East", "Sales_West", or "Sales_South" and then click on the "Run: MORE..." macro.\
\
Click:	[MORE]	to pull up the next Sales Rep's letter.\
		[MENU] to pull up additional choices:\
\
			VIEW - 
\fs28 return to main view
\fs36 \
			STYLE - 
\fs28 see additional formatting (control-d=down, control-e=up)
\fs36 \
			PRINT -	
\fs28 print the current form letter
\fs36 \
			FORMULAS - 
\fs28 Display some of the formulas used to create the letter
\fs36 \
\

\b\fi0\li0 Sales
\b0 .
\b Mesa
\b0\fi-20\li1440 \
\
This spreadsheet illustrates how you can easily create database summaries in Mesa.  It is a partially-interactive tutorial.\
\
It showcases:\
\
*  The format of a Mesa database.\
*  How to obtain summaries for specific people\
*  Obtaining summaries for joint criteria\
*  How to quickly build reports\
\
Click:	[MENU] to bring up menu choices:\
\
			View Data - 
\fs28 Display the database table
\fs36 \
			Summary by Salesperson - 
\fs28 How to build this summary
\fs36 \
			Product Summary - 
\fs28 How to build  a joint product/sales summary
\fs36 \
			Creating Reports - 
\fs28 Step-by-step approach to building quick report
\fs36 \
\
		[PRINT] to print the screens.\
\

\b\fi0\li0 Sales_Summary
\b0 .
\b Mesa
\b0\fi-20\li1440 \
\
This file summarizes information from four regional data files (Sales_East, Sales_West, Sales_North, Sales_South).\
\
It highlights:\
\
* Mesa's versatility with file links.\
*  Performing more-complex database summaries.\
\
Click:	[RECALC] to have Mesa choose, at random, records from 4 linked files\
		[MORE] moves through each of the 4 screens, then back to the beginning\
\
		Screens 2 & 3 request you to enter some formulas.\
\
Type:	COMMAND-p  to print\
*
}
