Dynamic Property Valuation Model with Monte Carlo Simulation

Create a Google Sheets script using Node.js that generates a probabilistic property valuation model with Monte Carlo simulation. The script should integrate historical market data, calculate potential appreciation rates, and generate confidence intervals for property value projections. Implement error handling for missing data points and visualization of potential valuation scenarios using Chart.js. Include methods to handle different property types (residential, commercial, multi-family) with configurable risk parameters.