# Scott Dunphy

> Personal home page of Scott Dunphy, a real estate portfolio manager and adjunct professor who writes about commercial real estate and generative AI. The site is deliberately styled as a 1990s personal web page; the content below is the same information in plain text.

## About

- Name: Scott Dunphy
- Occupation: Real Estate Portfolio Manager & Adjunct Professor
- Website: https://scottdunphy.com
- Email: professor.dunphy@gmail.com
- LinkedIn: https://www.linkedin.com/in/scottedunphy/
- Newsletter: Real Intelligence — https://real-intelligence.beehiiv.com
- Interests: commercial real estate, computers and technology, generative AI, music (Pink Floyd, Billy Joel), military history, Winston Churchill, travel, movies

## Publications

- [ODCE Adopts An Alternative Approach](https://www.prea.org/publications/quarterly/odce-adopts-an-alternative-approach/): co-author, Pension Real Estate Association (PREA) Quarterly, Summer 2024
- [Bits Meets Bricks: Leveraging AI in Real Estate](https://nyublueprint.substack.com/p/bits-meets-bricks-leveraging-ai-in): author, NYU Schack's Blueprint, July 2024
- [Real Intelligence newsletter](https://real-intelligence.beehiiv.com): ongoing newsletter on AI and real estate

## Projects

- Carried Interest Excel Function (.xlsm): an early project in which ChatGPT-3.5 wrote a custom Excel function that calculates carried interest across up to four waterfall tiers. Downloadable from the home page.
- Portfolio Manager Excel Model (.xlsm, work in progress): a portfolio model that forecasts cash flows and performance for a closed- or open-end real estate fund. Excel is the input and output screen; VBA macros are the engine.
- [Kryptos K4 Cryptanalysis](https://github.com/scott-dunphy/kryptos-k4): a systematic attack on K4, the unsolved section of Jim Sanborn's Kryptos sculpture, run in October 2026 with a team of Claude agents. No solution; about 180 documented experiments eliminate the classic hand-cipher families and identify one statistical pattern around the letters of KRYPTOS. Python code, experiment log (NOTES.md) and results.
- [Visitor and AI crawler stats](https://scottdunphy.com/stats.php): counts of human visitors and of AI crawlers by user agent.

## AI stack

Claude Cowork, Claude Code, Perplexity Comet browser, Wispr Flow, ChatGPT, Gemini 3.

## Optional

- [Home page](https://scottdunphy.com/): the full retro HTML version of this information
- [Guestbook](https://scottdunphy.com/guestbook.php): visitor guestbook; entries are moderated before they appear
- [Building Blocks](https://scottdunphy.com/building-blocks.html): a standalone experiment page