Excel Walkthrough: Using the Home Sheet in the Valcre Valuation Workbook (06.30)

Cam Vine

The below video and subsequent guide will walk you through using the Home sheet in the Valcre Valuation Workbook. Please review whichever style (video or written content) best supports your learning style.

Pre-Req:

Subscription tier: Advanced, Professional, Enterprise
Set up your Valcre Valuation Workbook

The home page is set up with the following sections:

Workbook Details:

This section reviews property types supported in the Valcre Valuation Workbook, defines key cell colors, and allows you to turn off workbook shading when you can sync your Valuation Workbook to your Report.

Workbook Set up:

Five easy steps to get your workbook set up with the appropriate templates and modules based on the type of appraisal you are completing

Subject Property Photo

The subject property's primary photo will be pulled from the database.

If you want a larger picture, select Get Larger Photo.

Change the Image:

Designate a new photo in the Property Record in the Valcre Database to change your Property Subject primary image. Once in the Property Record, select Files, then select the star button on any image. Once selected, the primary image will be the main image on the report cover page and will be used in any datasheets if you use this property as a comparable later. Don’t forget to select Load Job again in the Valuation Workbook to update the photo.

Note: Anything outside of the white box behind the photo will not be added to your report. You must adjust the sizing if your photo is larger than the white box behind it.

Appraisal Information

General information about the appraisal. This is being populated from the Online App | Database.

Note: If there are missing fields, please update the database with the information and reload the job. You can manually add them to the workbook, but they will not be added to the database. We recommend adding it to the database for data consistency.

Client Information

General Information about the client. This is being populated from the Online App | Database.

Appraiser Information:

General Information about the appraiser(s) working on this job. It will default to the total number of appraisers assigned to the job; this is pulled from the data from the account page for each appraiser.

Manually select whether the individual inspected the property and the extent by using the drop-downs next to Inspected and Extent.
Select GET SIGNATURE to bring the uploaded signature from the Database into the Workbook.
Repeat this process with each Appraiser added to the workbook.
Select Assistance Provided to choose what type of assistance was provided.
Select Assistant Name - if applicable, to include the assistant information. If no one assisted, the name will default to no.

Valuation Scenarios:

You have the ability to add up to two different Valuation Scenarios.

When adding a Valuation Scenario:

Manually enter a custom name or select an option from the drop-down.

Select Property Rights Appraised using the drop-down.

Repeat the process above for up to three Valuation Scenarios.

Insurable Replacement Costs and Other Values

To enable, select Yes from the Insurable Replacement Cost Estimate drop-down.

That will activate the Insurable worksheet located at the bottom of your Workbook.

You can add up to 13 valuation scenarios using the Other Value fields. Rename the Other Value to the desired scenario name, and select Yes from the drop-down next to it.

Pro tip: Unhide the rows to add additional OTHER VALUE fields.

Dates

General information about the dates for the appraisal. This information is being pulled from the Database. By default, the As-IS Market Value - Date of Value field will populate with the Inspection Date. If this date differs, you can manually override this field and type in the correct date. (Remember, all yellow fields can be directly typed into.)

Add in the appropriate date for Prospective Upon Completion - Date of Value.

The Date of the Report will always be set for today’s date. You can manually override this by typing directly into the field if you would like.

Subject Property Location Information

General information about the Subject Property Location. Most of these fields will be populated from the Database.

If you have set a custom pin location for your property, use the USE DATABASE GEOCODE button to pull that into your Workbook.

Select GET CENSUS INFO to pull in the Census tract for your property. This will bring the Market, Submarket, and Adjacent Property information from the Database.

Qualitative Information

The qualitative analysis made and entered into the Database is added to your workbook here. You can adjust these directly in the Workbook if changes are needed.

Subject Sales History:

Use this section to enter any subject sales history, such as Current Owner, Last Sale Date, and Last Known Sales Price.

Select Yes from the Enhanced Discussion drop-down to add a detailed analysis to the Sales History.

Select a suitable option in the Ownership + Sales History drop-downs. The options available are generated based on the information you provided in the above sections of the Workbook.

Extraordinary Assumptions:

Use this section to select the Extraordinary Assumption(s) that make the most sense for the property you are appraising. You can also manually type your extraordinary assumptions into the cell.

Everything you add or select will be added to the Extraordinary Assumptions paragraph section at the bottom of this section. This is what will be added to your report once you sync your Workbook and Report.

Hypothetical Conditions

Use this section to select the Hypothetical Condition(s) that makes the most sense for the property you are appraising. You can also manually type your Hypothetical Conditions into the cell.

Everything you add or select will be added to the Hypothetical Conditions paragraph section at the bottom of this section. This is what will be added to your report once you sync your Workbook and Report.

Continue Learning about Valcre with our next suggested guide: Valcre Workbook: Using the CUSTOM - Custom Fields sheet.

For additional questions about Using the Home sheet in Valcre Office, please contact Valcre Support using the live chat feature in Valcre Online or Valcre Mobile.

Was this article helpful?

0 out of 0 found this helpful