NOTE-- We
retired the MacNail estimating program in 2000, and replaced
it with Goldenseal construction estimating
software. We keep these instructions online for our die-hard MacNail
users! Goldenseal is an integrated program that also
includes accounting, scheduling and contract writing.
It prints vendor price requests, and also imports vendor
price data from downloads or text files.
Getting Prices 'in bulk'
Once or twice a year
you'll probably want to get the latest prices for all material items. The MacNail construction management
software makes it easy
to do that by giving you printed 'price request' sheets to hand out to your suppliers.
You can make a price
request sheet for all material items at once, or you can make it for just a selected group of items.
To
make a price request sheet:
1. Choose Material Price Sheets from the MacNail (McN) menu, and open
the MacNail Price Sheet (or some other Price Sheet if you are using more than one of them).
2. Choose Sort Special from the Data menu, and sort by Description. Alphabetizing the list before
you print it makes data entry easier, later on.
3. Choose Sort Special again, and sort the worksheet by category (if you plan to get prices for all items,
or for one basic category of items) or by source (if you plan to get prices from one specific supplier).
3. If you are making a price request for everything in the Price Sheet, skip to step 4. Otherwise, drag the
mouse through all those rows that you'd like to include in the price request.
4. Choose New Price Request from the File menu.
5. Click on either All Items or Selected Items only, and type in a file name if the one that's already
there is not suitable. Then click OK.
HINT: The text in the 'active cell' will be used as a suggested file name.
When selecting rows, you might want to select cells in the source column or the category column so the suggested
file name is
logical!
6. A new price request will be created automatically. It will be saved in the Printed Price Sheets folder,
using the file name you typed in. For example, if you used 'Windows' as a file name, the price
request will be saved under the name Windows Price Request.
7. Print the Price Request immediately, or print it later on by using the Print Price Requests command.
8. Take or mail the printed Price Request sheet to your local supplier(s), and have them fill in prices.
It may take a reminder or two to get them to finally do it!
|
