On the PC version, when you download the Visual Pricing System it is downloaded in a ZIP file. You will need to unzip the file to get access to the setup.exe file that will install the Visual Pricing System. In many cases, there may already be an unzip program located on your system. Just double-click (to open) the ZIP file to see if that is the case. If you don’t have an unzip program you will need to download one. One of the most popular programs is WinZip. However, a free unzip routine that we’ve had great experience with is the “7 ZIP” program. You can go to a site where you can download it by selecting this link. Once you download it, you will need to install it. You can then run the 7 ZIP program and find the setup_VPS2007.ZIP file. Open the ZIP file and run the setup.exe program contained within the ZIP file.
I’m on a MAC, and when I run the Visual Pricing System, I’m getting a message that I need to “repair” the system.
We have seen the situation where folks are opening up the Visual Pricing System and they are getting the message that the Microsoft Excel file is “Corrupt” and asking if they want to “Repair and Open” the file. When they select the yes option, the file is “repaired” and opened, but the Visual Pricing System is not operational. Generally this problem occurs, after they have purchased a new MAC and have moved files over.
If you have just purchased a new MAC and you (or you had someone else) updated your new MAC with programs and data from your previous MAC using the Migration Assistant you may see this problem (or you may see a “Compile Error in Hidden Module 5″ error message). The Migration Assistant is a great tool to help you move all your programs and data from a previous MAC to your new MAC. However, there is a minor problem with moving over the Microsoft Office applications. Once you do move them over, you’ll need to provide your activation code again. Additionally, you’ll need to run the install Microsoft Office Installation. You do NOT need to delete the application files or make any other changes to your new MAC. All you need to do is to put in your Microsoft Office DVD disc (or access the download if you purchased it on-line) and run the install. Even if your version has been updated, running the Microsoft Office install will clean things up.
If your on a MAC and you just installed the Visual Pricing System and you are getting the “Compile Error in Hidden Module 5″ error message then something is wrong with your version of Microsoft Excel. Generally there are three things that can be wrong:
- You have the wrong version of Microsoft Excel. The Visual Pricing System requires that you have Microsoft Excel for the MAC version 11.0. If you have an earlier version, then you will need to update you version. You can upgrade by going to the http://www.microsoft.com/MAC and selecting the release that best meets your need.
- You have the “Microsoft Excel for the MAC version 11.0″ installed but you are still getting the “Hidden Module” error. You will need to “Update your Configuration”. to Update your Configuration, bring up the Microsoft Excel. Then select Help at the top menu and select the Check for Updates option. You will see several update that are available. Update your Microsoft Excel and you should be good to go.
- You have just purchased a new MAC. You (or you had someone else) update your new MAC with programs and data from your previous MAC using the Migration Assistant. The Migration Assistant is a great tool to help you move all your programs and data from a previous MAC to your new MAC. However, there is a minor problem with moving over the Microsoft Office applications. Once you do move them over, you’ll need to provide your activation code again. Additionally, you’ll need to run the install Microsoft Office Installation. You do NOT need to delete the application files or make any other changes to your new MAC. All you need to do is to put in your Microsoft Office DVD disc (or access the download if you purchased it on-line) and run the install. Even if your version has been updated, running the Microsoft Office install will clean things up.
I’d like to add a property to my MLS data form so I can put it on my Scattergram. How can I do that?
There are several reasons why you might want to add properties to your MLS Data form (or the Active Data Form). Some of the reasons we’ve heard include:
- There is a For Sale By Owner that sold in the Neighborhood that I’d like to include.
- I’d like to include a property that sold over two years ago (I know that I should only include properties that have sold in the last six months, but this is an exception).
- I’ve exported data, and didn’t include a key property. I’d like to include it without redoing my export file and my scattergram.
- I’d like to include the subject property on the scattergram chart.
Including properties on either the MLS data form or the Active Data form is very easy to do. Be aware, that if you add properties to MLS data form they are not automatically added to the Active Data form (and visa versa). Also, the data added are not reflected in any of the other charts (Odds of Selling, Time to Sell, Buying Pattern, Real Estate Pond, etc.)
To add a property first, go to the respective data form that you want to add the property in.
- Position your cursor in an entry in under the “MLS #” heading as shown below.
- Then right-click to get the the dropdown menu and select the “Add User Property” option.
Once you select the “Add User Property” option, you will see a dialog box as shown below:
Enter the address of the property you are adding and select the Status of the property. On the MLS Data form you will be able to select any of the following status values: Sold, For Sale, U/C (under contract), With/Exp and Subject. On the Active Data Form you will be able to select any of the following status values: For Sale, U/C, and Subject (Sold and With/Exp properties are not shown on the Active Data Form). Once you’ve provided this information, select the “OK” button. Once you select the “OK” button, the entry will be added and a random MLS number starting the letter “u” will be added. You can then edit the other values in the spreadsheet (you can even modify the address). Be sure to add in the price and the size if you intend to add the property to either the Scattergram or Priceline chart.
What does the Subject Status mean?
The Subject status category is mean to show the subject property. This will allow you to show where you believe the subject property should fit on the scattergram chart, if you wish. When you do show the Subject property on the Scattergram chart, notice that it will be shown in a large red circle. (It is also possible to show multiple Subject properties on the same graph if you wish, although it may create some confusion).
You may choose to show the MLS number in the data boxes that are creating when you create your scattergram. By default only the Address, square footages, and bedroom/bathrooms are shown. You may find it helpful to quickly look up the detailed MLS sheet when the MLS numbers are shown in the text box. [To see how to create textboxes on your scattergram, select this link.]
To show MLS numbers, open the Configuration Dialog box [need help finding the configuration dialog box, select this link]. Once you do, then select the “Pricing” tab located at the top of the Configuration Dialog box. Then select the “Show MLS number when data box is created” option.
The next scattergram you create, will show the MLS number in addition to the other default information.
The configuration Dialog box can be found by first going to the “start” tab (of just opening the Visual Pricing System). Then at the top menu, you will either see a “Focus 1st” or a “Add-Ins” menu. If you select the “Add-Ins” menu, the “Focus 1st” menu will drop down below. Once you select the “ Focus 1st” menu, then select the Configure item and the Configuration Dialog Box will appear.
Can’t find the Focus 1st menu? You must be on a MAC. On MAC computers the menu’s are embedded in the spreadsheet. Position your cursor over the “To use the Visual Pricing application you must first EXPORT…” message in the middle of your screen and then right-click over that message. Your menus will then appear. Select the “Configure” menu.
On the Time to Sell graphs the Visual Pricing System will show the Average Days Before Sold and the Average Sold Price of homes that sold. If you’d prefer to see the Median Days Before Sold and the Median Sold Price of homes, you may do that. Open the Configuration Dialog box and select the “Show ‘Median’ instead of ‘Average’ on Time to Sell Chart”.
The next export file you read in, will show Median instead of Average values.
Need help in finding the Configuration Dialog Box? Select this link to see how to find the Configuration Dialog box.