Decorating
Den Excel Files for Microsoft Office 97 or 2000
You may wish to print this page for ease of use while trying it. For Microsoft Windows 95/98 users who also have Microsoft Office 97 or 2000, the listed files are linked for download. The size of the file in Kb and estimated download time (with a 28.8 modem) is also shown. As you can see, it would take twice as long to download the individual files. See our weasel words below. The files are available as uncompressed Excel files (Items 3 to 7 below), or as one large compressed self-extracting file (Item 2 below). You can choose whichever method is most efficient for you. If you need to download more than two of the individual files the Item 2 file will be faster.
INSTRUCTIONS (for Items 3 to 7 below): Position cursor over the desired link. Then right click. Up will come a menu. Left click on "Save Target As", and save the file on your hard disk wherever you want, most likely in the "My Document" folder or in a "Downloads" folder that you create (using File/New/Folder in Windows Explorer). Then click Save.
INSTRUCTIONS FOR THE ENTIRE SELF-EXTRACTING ZIP FILE ONLY (for Item 2 below): Click on the link. Up will come a "File Download" box. Make sure that "Save this program to disk" is on, and click OK. Then a "Save As" box will appear which will allow you to save the file to any location on your hard disk. By clicking on the manila folders on the upper and lower windows you can select the location where the downloaded file will be saved (See the next note for creating a new folder). Once you determine where you want the file, click Save.
CREATING A NEW FOLDER: Open Start/Programs/Windows Explorer. Click on any folder to open it. (We will use the "My Documents" folder for this example. Click on File/New/Folder. A folder will appear in the right window with the "New Folder" name flashing. Type in any name you want, like "Internet Downloads", then hit Enter. If you want to change the name of a file or folder, just single click on it to highlight it, then hit the F2 key, then type the new name and hit Enter.
REVISION COMMENT: The Job Log has an automatic method for
calculating Summary Sales by Year.
Business Plan updated for current format. Ad Planner contains main budget page as required, and is now
linked to Business Plan.
|
Item |
FILE TYPE |
DESCRIPTION |
File Date |
SIZE and DOWNLOAD ESTIMATE |
|
1. |
Just click on the link to go directly to the instructions for what you do AFTER you download the Item 2 Zip file. Print out the page. |
6 Apr 99 |
4 Kb, 10 seconds |
|
|
2. |
Entire self-extracting zip file with all 5 Excel 97 files below except cover letter |
Compressed single file for faster download. Don't download this if you only need one or two of the files. (Check the file dates.) |
11 Jan 00 |
781 Kb, 8 Minutes |
|
3. |
Contains each required Ad report used at Business Plan time, easy to keep up to date and measure media hit performance. |
11 Jan 00 |
179 Kb, 2 Minutes |
|
|
4. |
Contains 38 Tabs which include one page per month for each of the 3 monthly reports (Sales, Leads, Gross Profit). Also includes Annual Sales, and instruction file. |
11 Jan 00 |
350 Kb, 4 Minutes |
|
|
5. |
Contains tabs for QuickBooks and Decorating Den comparative data, along with reports for the business plan. |
11 Jan 00 |
158 Kb, 2 Minutes |
|
|
6. |
A simple spreadsheet for keeping track of job numbers of new orders entered, along with a summary of annual sales. |
07 Jan 00 |
281 Kb, 3 Minutes |
|
|
7. |
The workhorse - This contains each weekly report, the monthly, the lead register, and the gross profit report. |
07 Jan 00 |
284 Kb, 3 Minutes |
|
|
|
|
|
|
|
Disclaimer (Weasel words) - Hopefully, some of the information found here will be useful to someone. None of the programs or files are guaranteed. You should review their operation prior to relying on the information they present. Hey, I'm not a programmer by trade, just a knowledgeable power user. And by all means, please Email errors, problems, or suggestions to tom.smith@rcn.com. Otherwise how will I know there is anything to fix?
Please see the primary links page for trademark references or go all the way back to Tom and Cheryl's Web site Home Page. Or send mail to tom.smith@rcn.com if you notice something we need to fix.
Prior Update 6 Apr 99 - added more detailed instructions, numbered the table above, "Reupholstery" was added to the tables.
Last Update 11 Jan 00 - Item 1 Description was clarified as to what it is for. In Instructions, last command was "OK", changed to "Save", the Self-extracting Zip file download instruction were changed, and individual files changed as follows:
· Ad Planner revised to current media types, primary annual budget page added, linked to Business Plan file.
· Archive revised to add Reupholstery category., and annual subtotals by category.
· Business Plan revised to current plan reporting style.
· Job Log Summary Sales revised to autocalculate the year summaries. A readme tab was added to it as well.
· Weekly file revised with Reupholstery category.