Valuation Workbook: Setting up your Workbook

Cam Vine

Prerequisites:

Subscription tier: Professional, Enterprise
Valcre Ribbon Add-On

Overview

Your workbook will be branded and licensed for your company based on the branding and style guide you provided our Client Success team during onboarding. If you want to change your branding, please contact your Client Success Manager.

Navigation menu

This menu will help you navigate different worksheets and modules you’ve enabled for your job.

Home sheet

You will use this tab to set up your Valuation Workbooks. You can navigate to this tab anytime if you need to change your setup. This training guide will focus on the HOME sheet in your Valuation Workbook.

Turn workbook shading off.

This is only necessary when you have completed your valuation workbook and are ready to move on to the word portion of the process. Turning the workbook shading off will remove all cell shading, ensuring charts are clean and consistent.

Field Types

Yellow Fields: Fields you can type directly into.

Blue Fields: Drop-down menus with different options.

Green Color Text: Data will be pulled into the Valuation Workbook directly from the database.

Set up Workbook

This will tailor the valuation workbook based on the specifications of your job.

Step 1: Select the Valcre ribbon in Excel.

If you don’t have this in your Valcre Valuation Workbook, please review the guide on installing the Valcre Add On’s.

Step 2: Select Load Job from the Valcre ribbon at the top of your workbook.

This will provide a list of all jobs you are currently assigned. If you want to view all jobs, including ones you are not assigned, deselect the radio button: Assigned to Me.

Step 3: Highlight the job you wish to load into the Valuation Workbook and select Load.

Note: If you make any updates in the database to this job after loading the job into the workbook, you can push all updates into your workbook by selecting Load Job again. You will not lose any work already completed; only add additional database information you have added.

If you wish to change the job loaded into the workbook, select Change Job from the Valcre ribbon.

Once you load the job, you will see that the Job number has been added to Step 1 in your workbook's SET UP WORKBOOK section. Additionally, all comparable sets have been imported.

Step 4: In SET UP WORKBOOK, Select the Property Type and Subtype using the drop-down selections.

Step 5: Select the Property Occupancy Status using the drop-down selection.

Step 6: Select your Template.

The template describes the property. This will determine how the rest of your workbook is set up based on the type of property you are appraising. You must select a template, or you cannot set up your workbook.

By default, this will display the most relevant templates based on your selection above. If you want to view the entire list of templates, select SHOW ALL.

Step 7: Select your Approach using the drop-down selection next to Select Approaches to Value.

The approach is the analysis you will perform as part of that appraisal. The combination of the template and approach will determine how the workbook is set up.

If you would like to enable them manually, select SHOW ALL

Step 8: Select SET UP WORKBOOK from the bottom of the Home tab

Pro tip: If you make any changes in the SET UP WORKBOOK section after selecting SET UP WORKBOOK, please be sure to reselect SET UP WORKBOOK for the changes to be updated.

Step 9: (optional) If you have additional custom sheets, select Load Modules from the Valcre ribbon and select the appropriate add-on's to add to your work. The applicable sheets will automatically populate based on your selection.

Pro tip: You may add as many additional sheets as required. If you'd like to add more modules, please reach out to your Client Success Manager.

Not sure who your Client Success Manager is? No problem—our Support team is here to help connect you!

Additional Home Sheet Sections of Note

The home page is set up with the following sections:

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. (Live Chat, Email, Phone)

Was this article helpful?

0 out of 0 found this helpful