Update Apartment Pricing & Preserve History

This guide describes how to update a community pricing sheet after a price change request is submitted to the Help Desk. This guide assumes the sales person wants the history to be retained in the pricing sheet.

Open Community Pricing Sheet

  1. 1. Highlight Current Rate Column

    Highlight Current Rate Column
  2. 2. Insert Column Left

    Insert Column Left
  3. 3. Enter Column Information

    Name = Month or Year price was last changed

    Column Type = Text/Number

    Click OK

    Enter Column Information
  4. 4. Format Column Width As Needed

    Format Column Width As Needed
  5. 5. Copy Current Rate Data

    Highlight the column and CTRL+C to copy the data.

    Copy Current Rate Data
  6. 6. Paste Data into New Column

    Right-click + Paste Special

    OR

    CTRL+V

    Paste Data into New Column
  7. 7. Format Column As Needed

    Background Color = Automatic

    Format Column As Needed
  8. 8. Copy Formulas on Header Rows (Grey Rows)

    Click the lower right corner of the header row cell in the Current Rate column. Drag left to copy the formula to the new column.

    Copy Formulas on Header Rows (Grey Rows)

Open the Master Pricing Sheet

  1. 9. Filter on the Community

    Filter on the Community
  2. 10. Copy New Market Rate Data

    Paste data into the Current Market Rate Column

    Copy New Market Rate Data
  3. 11. Tip: Paste Values to Avoid Formatting Changes

    Right-click on top cell of the column, then click Paste Special.

    Select Values then click OK.

    Tip: Paste Values to Avoid Formatting Changes
  4. 12. Save

    Save
  5. 13. Delete Increase Request Data

    Highlight Rate Override, Requested % Increase, and New Rate Effective Date.

    Press Delete on your keyboard to remove the data.

    Delete Increase Request Data
  6. 14. Save

    Save

Open Community Pricing Report

  1. 15. Open the Associated Community Pricing Report

    Open the Associated Community Pricing Report
  2. 16. Select New Column

    Click on Columns.

    Check the box next to the new column you just created. Click OK.

    The column will be added to the end of the report.

    Select New Column
  3. 17. Format Column

    Move the column to the appropriate location in the report.

    Format column width as needed.

    Save.

    Format Column
  4. 18. Open the Pricing Sheet Dynamic View & Click Settings

    Open the Pricing Sheet Dynamic View & Click Settings
  5. 19. Click on View Display

    Click on View Display
  6. 20. Enable New Column

    Click the checkbox by the new column.

    Enable New Column
  7. 21. Move the Column As Needed

    Move the Column As Needed
  8. 22. Click Save

    Click Save
  9. 23. Click Back to view

    Click Back to view
  10. 24. Review New Column

    Review New Column