[object Object]

← back to Rentv Sheet Enrich

Add derived πŸ”₯ Warmth score column to RENTV live console + top-N export

ddffc4908f2321241c3a092638e70044f40aa4cb Β· 2026-08-13 20:16:12 -0700 Β· Steve Abrams

- warmth.py: shared scorer (appearances + status intent + Strong-Prospect + reachability)
- live_server.py: augment tab()/combined() responses; guard write_cell against the derived col
- index.html: numeric-aware sort, read-only heat-pill cell, default sort = Warmth desc
- export_top.py: ranked 'top-N to work' CSV using the same scorer

Files touched

Diff

commit ddffc4908f2321241c3a092638e70044f40aa4cb
Author: Steve Abrams <steve@designerwallcoverings.com>
Date:   Thu Aug 13 20:16:12 2026 -0700

    Add derived πŸ”₯ Warmth score column to RENTV live console + top-N export
    
    - warmth.py: shared scorer (appearances + status intent + Strong-Prospect + reachability)
    - live_server.py: augment tab()/combined() responses; guard write_cell against the derived col
    - index.html: numeric-aware sort, read-only heat-pill cell, default sort = Warmth desc
    - export_top.py: ranked 'top-N to work' CSV using the same scorer
---
 __pycache__/export_top.cpython-314.pyc  | Bin 0 -> 4478 bytes
 __pycache__/live_server.cpython-314.pyc | Bin 23129 -> 23418 bytes
 __pycache__/warmth.cpython-314.pyc      | Bin 0 -> 6857 bytes
 export_top.py                           |  74 ++++++++++++
 live_server.py                          |  13 ++-
 public_live/index.html                  |   9 +-
 rentv_top200_to_work.csv                | 201 ++++++++++++++++++++++++++++++++
 warmth.py                               | 126 ++++++++++++++++++++
 8 files changed, 417 insertions(+), 6 deletions(-)

diff --git a/__pycache__/export_top.cpython-314.pyc b/__pycache__/export_top.cpython-314.pyc
new file mode 100644
index 0000000..7007c56
Binary files /dev/null and b/__pycache__/export_top.cpython-314.pyc differ
diff --git a/__pycache__/live_server.cpython-314.pyc b/__pycache__/live_server.cpython-314.pyc
index eadb3e4..fe1d6bc 100644
Binary files a/__pycache__/live_server.cpython-314.pyc and b/__pycache__/live_server.cpython-314.pyc differ
diff --git a/__pycache__/warmth.cpython-314.pyc b/__pycache__/warmth.cpython-314.pyc
new file mode 100644
index 0000000..79d6367
Binary files /dev/null and b/__pycache__/warmth.cpython-314.pyc differ
diff --git a/export_top.py b/export_top.py
new file mode 100644
index 0000000..e63ec6b
--- /dev/null
+++ b/export_top.py
@@ -0,0 +1,74 @@
+#!/usr/bin/env python3
+"""
+Export the top-N warmest RENTV leads as a ready-to-work CSV.
+
+Reads the local snapshot (data/snapshot.json β€” the same source the live console
+serves) so it never burns a Sheets read, scores every unique contact with the
+shared warmth.py scorer, sorts hottest-first, and writes a lean outreach sheet
+with a 'Why Warm' reason column.
+
+Usage:  python3 export_top.py [N] [outfile.csv]
+        (defaults: N=200, outfile=rentv_top<N>_to_work.csv)
+"""
+import csv, json, os, sys
+import warmth
+
+HERE = os.path.dirname(os.path.abspath(__file__))
+UNIQUE_GID = 3823360  # "Unique Contacts (all tabs)" β€” the deduped master
+
+N = int(sys.argv[1]) if len(sys.argv) > 1 else 200
+OUT = sys.argv[2] if len(sys.argv) > 2 else os.path.join(HERE, f"rentv_top{N}_to_work.csv")
+
+snap = json.load(open(os.path.join(HERE, "data", "snapshot.json")))
+tab = next(t for t in snap["tabs"] if t["gid"] == UNIQUE_GID)
+H, rows = tab["headers"], tab["rows"]
+idx = {h: i for i, h in enumerate(H)}
+
+
+def cell(r, name):
+    i = idx.get(name)
+    return (str(r[i]).strip() if i is not None and i < len(r) and r[i] is not None else "")
+
+
+def best_email(r):
+    for f in ("Email", "Updated Email (found)", "Likely Email (inferred)"):
+        v = cell(r, f)
+        if v:
+            return v
+    return ""
+
+
+def best_linkedin(r):
+    return cell(r, "LinkedIn (Contact)") or cell(r, "LinkedIn (Company)")
+
+
+scored = sorted(rows, key=lambda r: warmth.score(r, idx), reverse=True)
+
+COLS = ["Rank", "Warmth", "Why Warm", "Contact Name", "Company/Venue", "Position",
+        "Best Email", "Phone 1", "Phone 2", "Status", "Marketing/VP Name",
+        "Marketing/VP Position", "LinkedIn", "Website", "Source Tabs", "# Appearances"]
+
+written = 0
+with open(OUT, "w", newline="") as f:
+    w = csv.writer(f)
+    w.writerow(COLS)
+    for r in scored:
+        sc = warmth.score(r, idx)
+        # skip section/divider rows and anything with no real identity
+        if cell(r, "Status (color)") == "Section / Category":
+            continue
+        if not (cell(r, "Contact Name") or cell(r, "Company/Venue")):
+            continue
+        written += 1
+        w.writerow([
+            written, sc, warmth.reason(r, idx),
+            cell(r, "Contact Name"), cell(r, "Company/Venue"), cell(r, "Position"),
+            best_email(r), cell(r, "Phone 1"), cell(r, "Phone 2"),
+            cell(r, "Status (color)"), cell(r, "Marketing/VP Name"),
+            cell(r, "Marketing/VP Position"), best_linkedin(r),
+            cell(r, "Website"), cell(r, "Source Tabs"), cell(r, "# Appearances"),
+        ])
+        if written >= N:
+            break
+
+print(f"Wrote {written} leads -> {OUT}")
diff --git a/live_server.py b/live_server.py
index d0766f8..033e9ca 100644
--- a/live_server.py
+++ b/live_server.py
@@ -17,6 +17,7 @@ import base64, json, os, socket, sys, threading, urllib.request
 from http.server import BaseHTTPRequestHandler, ThreadingHTTPServer
 sys.path.insert(0, os.path.dirname(os.path.abspath(__file__)))
 import lib
+import warmth  # derived πŸ”₯ Warmth column β€” response-only, never written to the sheet
 
 HERE = os.path.dirname(os.path.abspath(__file__))
 USER, PW = "admin", "DW2024!"
@@ -82,9 +83,9 @@ def meta():
 
 def tab(gid):
     t = SNAP["_by_gid"][int(gid)]
-    return {"gid": t["gid"], "title": t["title"], "headers": t["headers"],
+    return warmth.augment({"gid": t["gid"], "title": t["title"], "headers": t["headers"],
             "rows": t["rows"], "green": t["green"], "colors": t.get("colors", {}),
-            "generated": SNAP["generated"]}
+            "generated": SNAP["generated"]})
 
 def green_map(gid):
     """Enriched (green) cells for a tab β€” precomputed in the local snapshot."""
@@ -125,9 +126,9 @@ def combined(gids):
                 hx = cmap.get(f"{ri},{ci}")
                 if hx:
                     colors[f"{base+ri},{ui}"] = hx
-    return {"gid": "combined", "title": f"{len(tabs)} sheets combined",
+    return warmth.augment({"gid": "combined", "title": f"{len(tabs)} sheets combined",
             "headers": order, "rows": rows, "green": green, "colors": colors,
-            "generated": SNAP["generated"]}
+            "generated": SNAP["generated"]})
 
 def resolve_combined(gids, crow, ucol):
     """Reverse-map a combined-view (row, union-col) back to the SOURCE (gid, tab_row0, tab_col0).
@@ -159,6 +160,10 @@ def write_cell(gid, row0, col0, value, formula=False):
     # row0 is 0-based over DATA (body) rows; the real sheet grid row = hr + 1 + row0
     # (hr = the tab's header row; tabs with a title row ABOVE the header have hr>0)
     t = SNAP["_by_gid"].get(int(gid))
+    # πŸ”₯ Warmth is a derived, response-only column (index == real header count).
+    # It has no sheet cell behind it β€” reject the write instead of corrupting the grid.
+    if t and int(col0) >= len(t["headers"]):
+        return {"ok": False, "error": "derived column (πŸ”₯ Warmth) is read-only"}
     hr = t.get("hr", 0) if t else 0
     cell = {"row0": int(row0) + hr + 1, "col0": int(col0), "value": value}
     if formula:
diff --git a/public_live/index.html b/public_live/index.html
index 47f4166..80cb732 100644
--- a/public_live/index.html
+++ b/public_live/index.html
@@ -633,9 +633,9 @@ function cellTD(ri,ci,val,isN,gr){
   if(isStatusCol(ci)){                                          // color-coded status chip + date/time under it + click-to-set picker
     const lm=lmCol(), dt=(lm>=0 && DATA.rows[ri] && DATA.rows[ri][lm])||'';
     const dtHtml=dt?`<div class="chipdate" title="Last modified">πŸ•“ ${esc(String(dt))}</div>`:'';
-    if(!s) return `<td data-r="${ri}" data-c="${ci}" contenteditable="false" class="statuscell empty ${cls}" title="Click to set status">οΌ‹ set status${dtHtml}</td>`;
+    if(!s) return `<td data-r="${ri}" data-c="${ci}" contenteditable="false" role="button" tabindex="0" aria-label="Set status" class="statuscell empty ${cls}" title="Click or press Enter to set status">οΌ‹ set status${dtHtml}</td>`;
     const col=statusColor(s);
-    return `<td data-r="${ri}" data-c="${ci}" contenteditable="false" class="statuscell ${cls}" title="Click to change status"><span class="statuschip" style="background:${col};color:${txtOn(col)}">${esc(s)}</span>${dtHtml}</td>`;
+    return `<td data-r="${ri}" data-c="${ci}" contenteditable="false" role="button" tabindex="0" aria-label="Status: ${esc(s)}. Change status" class="statuscell ${cls}" title="Click or press Enter to change status"><span class="statuschip" style="background:${col};color:${txtOn(col)}">${esc(s)}</span>${dtHtml}</td>`;
   }
   const em=emailOf(s);
   if(em){ return `<td data-r="${ri}" data-c="${ci}" contenteditable="false" data-mail="${esc(em)}" title="Email ${esc(em)}" class="mailcell ${cls}${xcls}"${xsty}><span class="cicon">${ICON.mail}</span><span class="linkval">${esc(em)}</span></td>`; }
@@ -667,6 +667,11 @@ function wireGrid(){
   // (per-render) #grid element and open the link in a POPUP WINDOW. tel: links proceed as normal.
   const gridEl=$('#grid');
   if(gridEl){
+    gridEl.addEventListener('keydown',e=>{                                  // keyboard access to the status picker (a11y)
+      if(e.key!=='Enter'&&e.key!==' ')return;
+      const st=e.target.closest('td.statuscell'); if(!st)return;
+      e.preventDefault(); openStatusPicker(st);
+    });
     gridEl.addEventListener('click',e=>{
       const st=e.target.closest('td.statuscell');                          // Status -> color-coded picker (writes to sheet)
       if(st){ e.preventDefault(); openStatusPicker(st); return; }
diff --git a/rentv_top200_to_work.csv b/rentv_top200_to_work.csv
new file mode 100644
index 0000000..5e24a16
--- /dev/null
+++ b/rentv_top200_to_work.csv
@@ -0,0 +1,201 @@
+Rank,Warmth,Why Warm,Contact Name,Company/Venue,Position,Best Email,Phone 1,Phone 2,Status,Marketing/VP Name,Marketing/VP Position,LinkedIn,Website,Source Tabs,# Appearances

+1,117,7 tabs; Active / Contacted; Strong Prospect; has email/phone,CJ Osbrink,Newmark | NAIOP,CJ Osbrink,cj.osbrink@nmrk.com,602-952-3841,,Active / Contacted,,,https://www.linkedin.com/company/nmrk-cre,nmrk.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Strong Prospects, Office Panel, retail panel",7

+2,117,7 tabs; Active / Contacted; Strong Prospect; has email/phone,Daniel Withers,Matthews Retail | Matthews Real Estate Invest Svcs | Matthews Real estate | EMAIL,"Kyle Matthews; Daniel Withers, lori.valencia David Harrington",Daniel.withers@matthews.com,310-497-5590,562-328-5745,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",7

+3,117,7 tabs; Active / Contacted; Strong Prospect; has email/phone,Kyle Matthews,Matthews Retail | Matthews Real Estate Invest Svcs | Matthews Real estate | EMAIL,"Kyle Matthews; Daniel Withers, lori.valencia David Harrington",Kyle.matthews@matthews.com,310-497-5590,562-328-5745,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",7

+4,117,7 tabs; Active / Contacted; Strong Prospect; has email/phone,Lori Valencia,Matthews Retail | Matthews Real Estate Invest Svcs | Matthews Real estate | EMAIL,"Kyle Matthews; Daniel Withers, lori.valencia David Harrington",lori.valencia@matthews.com,310-497-5590,562-328-5745,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",7

+5,117,7 tabs; Active / Contacted; Strong Prospect; has email/phone,Lori.valencia David,Matthews Retail | Matthews Real Estate Invest Svcs | Matthews Real estate | EMAIL,"Kyle Matthews; Daniel Withers, lori.valencia David Harrington",david.harrington@matthews.com,310-497-5590,562-328-5745,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",7

+6,117,6 tabs; Active / Contacted; Strong Prospect; has email/phone,Peter Rooney,Sares Regis | Sares - Regis Group | Sares-Regis | EMAIL,Zoe Solsby  Peter Rooney,prooney@sares-regis.com,949-756-5959,,Active / Contacted,,,https://www.linkedin.com/company/saresregisgroup,sares-regis.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",6

+7,109,5 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Alan Clifton,Passco | EMAIL,"Alan Clifton Gary Goodman Stacy Stemen, todd siegel",aclifton@passco.com,949-263-7912,(949) 263-7965,Needs Email / Outreach Pending,Stacy Stemen,SVP Corporate Marketing & Development,https://www.linkedin.com/company/passco,passco.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",5

+8,109,5 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Gary Goodman,Passco | EMAIL,"Alan Clifton Gary Goodman Stacy Stemen, todd siegel",ggoodman@passco.com,949-263-7912,(949) 263-7965,Needs Email / Outreach Pending,Stacy Stemen,SVP Corporate Marketing & Development,https://www.linkedin.com/company/passco,passco.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",5

+9,109,5 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Stacy Stemen,Passco | EMAIL,"Alan Clifton Gary Goodman Stacy Stemen, todd siegel",sstemen@passco.com,949-263-7912,(949) 263-7965,Needs Email / Outreach Pending,Stacy Stemen,SVP Corporate Marketing & Development,https://www.linkedin.com/company/passco,passco.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",5

+10,109,5 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Todd Siegel,Passco | EMAIL,"Alan Clifton Gary Goodman Stacy Stemen, todd siegel",tsiegel@passco.com,949-263-7912,(949) 263-7965,Needs Email / Outreach Pending,Stacy Stemen,SVP Corporate Marketing & Development,https://www.linkedin.com/company/passco,passco.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily, retail panel",5

+11,107,6 tabs; Flag / Priority; has email/phone,Amer Kasm,IRA Capital,,akasm@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/in/amer-kasm-12b7272/,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+12,107,6 tabs; Flag / Priority; has email/phone,Amer Malas,IRA Capital,,amalas@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/company/ira-capital,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+13,107,6 tabs; Flag / Priority; has email/phone,Danielle DeSouza,IRA Capital,,ddesouza@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/company/ira-capital,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+14,107,6 tabs; Flag / Priority; has email/phone,Jay Gangwal,IRA Capital,,jgangwal@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/company/ira-capital,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+15,107,6 tabs; Flag / Priority; has email/phone,Mohammad Malas,IRA Capital,,mmalas@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/company/ira-capital,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+16,107,6 tabs; Flag / Priority; has email/phone,Samir Patel,IRA Capital,,spatel@iracapital.com,(949) 258-7411,,Flag / Priority,,,https://www.linkedin.com/company/ira-capital,iracapital.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+17,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Brett Heron,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",bheron@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+18,101,3 tabs; Active / Contacted; Strong Prospect; has email/phone/VP contact,Brian Mahoney,Rockefeller Group | EMAIL,James Camp  Brian Mahoney,bmahoney@rockgrp.com,212-282-2590,949-468-1811,Active / Contacted,Amy Ankeles,Vice President of Marketing,https://www.linkedin.com/company/rockefellergroup,rockgrp.com,"Sheet2, Strong Prospects, Financial PAnel",3

+19,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Colm Macken,Shea Properties | EMAIL,James Williams  Vincent Lee Jon Marchiorlatti,colm.macken@sheaproperties.com,,,Active / Contacted,,,https://www.linkedin.com/company/shea-properties,sheaproperties.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",4

+20,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Emily Park,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",epark@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+21,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,James Camp,Rockefeller Group | The Rockefeller Group | EMAIL,James Camp  Brian Mahoney,jcamp@rockgrp.com,212-282-2590,949-468-1811,Active / Contacted,,,https://www.linkedin.com/company/rockefellergroup,rockgrp.com,"Sheet2, Strong Prospects, Financial PAnel",4

+22,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Jeff Moloznik,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",jmoloznik@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+23,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Jon Marchiorlatti,Shea Properties | EMAIL,James Williams  Vincent Lee Jon Marchiorlatti,Jon.marchiorlatti@sheaproperties.com,949-389-7283,949-945-3130,Active / Contacted,,,https://www.linkedin.com/company/shea-properties,sheaproperties.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Financial PAnel",4

+24,101,5 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Laura Ortiz,Evergreen Devco | Evergreen Development | EMAIL,"Laura Ortiz, Bryan Lamond -Dir Acquis  Rogg Collins  Chris Bergren",lortiz@evgre.com,818-334-1321,310-480-0128,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/evergreen-devco-inc,evgre.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",5

+25,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Mark Enfield,TruAmerica | EMAIL,Bruce Beck / Robert Hart  Noah Hochman  Mark Enfield,menfield@truamerica.com,310-699-6640,,Active / Contacted,,,https://www.linkedin.com/company/truamerica,truamerica.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",4

+26,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Michael Ebert,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",mebert@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+27,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Mike Kallner,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",mkallner@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+28,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Noah Hochman,TruAmerica | EMAIL,Bruce Beck / Robert Hart  Noah Hochman  Mark Enfield,nhochman@truamerica.com,310-699-6640,,Active / Contacted,,,https://www.linkedin.com/company/truamerica,truamerica.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",4

+29,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Shane Stephens,RED Development | EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",sstephens@reddevelopment.com,480-947-7772,,Active / Contacted,,,https://www.linkedin.com/company/red-development,reddevelopment.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, retail panel",4

+30,101,4 tabs; Active / Contacted; Strong Prospect; has email/phone,Vincent Lee,Shea Properties | EMAIL,James Williams  Vincent Lee Jon Marchiorlatti,vince.lee@sheaproperties.com,,,Active / Contacted,,,https://www.linkedin.com/company/shea-properties,sheaproperties.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Multifamily",4

+31,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Andrew Richards,Private Mortgage Fund | EMAIL,Randy van Dueck  Gordan Van Dueck  Andrew Richards Christopher Bunce,andrew@pmfundllc.com,805-373-2431,818-702-2551 x 9,Prospect / Follow-up,,,https://www.linkedin.com/company/private-mortgage-fund-llc,pmfundllc.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+32,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,David Green,Kennedy Funding | EMAIL,Edwin Urrego   David Green at Results ad,davidgreen@resultsinc.com,800-342-8500,201-288-7888,Prospect / Follow-up,,,https://www.linkedin.com/company/results-advertising,resultsinc.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+33,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Edwin Urrego,Kennedy Funding | EMAIL,Edwin Urrego   David Green at Results ad,edwin@kennedyfunding.com,800-342-8500,201-288-7888,Prospect / Follow-up,,,https://www.linkedin.com/company/kennedy-funding,kennedyfunding.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+34,99,5 tabs; Flag / Priority; has email/phone,Eric Termansen,Western Retail Advisors,,etermansen@w-retail.com,602.778.3745,,Flag / Priority,,,https://www.linkedin.com/company/western-retail-advisors,w-retail.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., retail panel",5

+35,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Jenny Redlin,Partner Engineering and Science | Partner Engineering & Science | EMAIL,Joe Derhake  Jenny Redlin Kelly McMicken,jredlin@partneresi.com,310-615-4500,,Prospect / Follow-up,,,https://www.linkedin.com/company/1894937,partneresi.com,"Sheet2, Strong Prospects",3

+36,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Joe Derhake,Partner Engineering and Science | Partner Engineering & Science | EMAIL,Joe Derhake  Jenny Redlin Kelly McMicken,jderhake@partneresi.com,310-615-4500,,Prospect / Follow-up,,,https://www.linkedin.com/company/1894937,partneresi.com,"Sheet2, Strong Prospects",3

+37,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Joe Giordani,Northmarq Capital | EMAIL,Rob Hervey / Lisa Baccare  Joe Giordani,jgiordani@northmarq.com,856-813-3248,651-492-5861,Prospect / Follow-up,,,https://www.linkedin.com/company/northmarq,northmarq.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+38,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Jonathan Stern,Meridian Capital | EMAIL,Jonathan Stern  Seth Grossman,jstern@meridiancapital.com,212-972-3600,858-964-1151,Prospect / Follow-up,,,https://www.linkedin.com/company/meridian-capital-group,meridiancapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+39,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Lisa Baccare,Northmarq Capital | EMAIL,Rob Hervey / Lisa Baccare  Joe Giordani,lbaccare@northmarq.com,856-813-3248,651-492-5861,Prospect / Follow-up,,,https://www.linkedin.com/company/northmarq,northmarq.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+40,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Seth Grossman,Meridian Capital | EMAIL,Jonathan Stern  Seth Grossman,sgrossman@meridiancapital.com,212-972-3600,858-964-1151,Prospect / Follow-up,,,https://www.linkedin.com/company/meridian-capital-group,meridiancapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+41,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Tim White,Partners Capital Solutions | EMAIL,Managing Director & Chief Operating Officer,twhite@pcs-funds.com,818.676.3335,,Prospect / Follow-up,,,https://www.linkedin.com/company/partners-capital-solutions-inc-,pcs-funds.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+42,99,3 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,,Private Mortgage Fund | EMAIL,Randy van Dueck  Gordan Van Dueck  Andrew Richards Christopher Bunce,gordon@pmfundllc.com,805-373-2431,818-702-2551 x 9,Prospect / Follow-up,,,https://www.linkedin.com/company/private-mortgage-fund-llc,pmfundllc.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+43,95,8 tabs; Active / Contacted; has email/phone/VP contact,Brett Isbell,Kidder Mathews | Kidder -  Phx,602-513-5114,bret.isbell@kidder.com,602.300.4112,,Active / Contacted,Shayna Leonardsen,"Vice President Corporate Marketing, Shareholder",https://www.linkedin.com/company/kidder-mathews,kidder.com,"Sheet2, Sponsors and Specaker Co., Sheet1, ARIZONA BROKERAGE FIRMS, Office Panel, retail panel",8

+44,95,6 tabs; Active / Contacted; has email/phone/VP contact,Chris Marchildon,Newmark,,Chris.Marchildon@nmrk.com,602.686.1879,,Active / Contacted,Monique Rafferty,"SVP, Marketing",https://www.linkedin.com/company/nmrk-cre,nmrk.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+45,95,7 tabs; Active / Contacted; has email/phone/VP contact,Dena Zell,Capital Asset Management | Capital Asset Management CRE | Zell Commercial,602-386-5726 602-248-0600,dzell@camcre.com,480-326-6166,,Active / Contacted,Sophia Hobley,Senior Marketing Coordinator,https://www.linkedin.com/in/dena-zell-10ab3924,camcre.com,"Sheet2, Sponsors and Specaker Co., Event Sponsors, retail panel",7

+46,95,6 tabs; Active / Contacted; has email/phone/VP contact,Jimmy Cornish,JLL,ofc,Jimmy.Cornish@jll.com,,,Active / Contacted,Liz Newcomer,"Senior Director, Marketing Operations (Phoenix AZ)",https://www.linkedin.com/company/jll,jll.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+47,95,6 tabs; Active / Contacted; has email/phone/VP contact,JLL Ryan,JLL,,Ryan.Bartos@jll.com,,,Active / Contacted,Liz Newcomer,"Senior Director, Marketing Operations (Phoenix AZ)",https://www.linkedin.com/company/jll,jll.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+48,95,8 tabs; Active / Contacted; has email/phone/VP contact,Mindy Korth,Colliers | Cushman & Wakefield | Picor,EVP,mindy.korth@colliers.com,602-222-5005,,Active / Contacted,Cheryl Garver,Marketing Director,https://www.linkedin.com/company/colliers-international,colliers.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",8

+49,95,6 tabs; Active / Contacted; has email/phone/VP contact,Ryan Timpani,JLL,ofc,Ryan.Timpani@jll.com,,,Active / Contacted,Liz Newcomer,"Senior Director, Marketing Operations (Phoenix AZ)",https://www.linkedin.com/company/jll,jll.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+50,95,6 tabs; Active / Contacted; has email/phone/VP contact,Tiffany Winne,Stream Realty Partners,Ofc   Exec Mg Dir Partner,tiffany.winne@streamrealty.com,602-885-0027,,Active / Contacted,Susan Bloomfield,Chief Marketing Officer,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+51,93,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Abraham Fassberg,Fassberg General Constructors | Fassberg | EMAIL,President,afassberg@fassbergcc.com,(818) 386-1800,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/buildfassberg,fassbergcc.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",4

+52,93,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Bronson Naab,National Bank of Arizona | NAIOP,Bronson Naab Tim Colquhoun Martina Burberry Scott Stovall,bronson.naab@nbarizona.com,612-812-1397,480-726-5740,Needs Email / Outreach Pending,Cheryl Holdraker,Director of Marketing,https://www.linkedin.com/company/national-bank-of-arizona,nbarizona.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+53,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Diana O'Connor,Berkadia Commercial Mortgage | EMAIL,Diana O'Connor,Diana.O'Connor@berkadia.com,215-328-3267,800-446-2226,Active / Contacted,,,https://www.linkedin.com/company/berkadia,berkadia.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+54,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Dina Finnegan,Capital One | EMAIL,Dina Finnegan,dina.finnegan@capitalone.com,332-2558061,301-741-2997,Active / Contacted,,,https://www.linkedin.com/company/capital-one,capitalone.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+55,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,James Williams,Shea Properties | EMAIL,James Williams  Vincent Lee Jon Marchiorlatti,james.williams@sheaproperties.com,,,Active / Contacted,,,https://www.linkedin.com/company/shea-properties,sheaproperties.com,"Sheet2, Strong Prospects, Multifamily",3

+56,93,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Jeannie Nguyen,National Bank of Arizona | NAIOP,Bronson Naab Tim Colquhoun Martina Burberry Scott Stovall,Jeannie.nguyen@nbarizona.com,612-812-1397,480-726-5740,Needs Email / Outreach Pending,Cheryl Holdraker,Director of Marketing,https://www.linkedin.com/company/national-bank-of-arizona,nbarizona.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+57,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,John Loshbaugh,KeyBank | EMAIL,Lisa Lombardo John Loshbaugh   Matthew Ruark,john_loshbaugh@keybank.com,216-689-3869,913-317-4237,Active / Contacted,,,https://www.linkedin.com/company/keybank,keybank.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+58,93,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Kelly McMicken,Partner Engineering | Partner Engineering & Science | EMAIL,Marketing,kmcmicken@partneresi.com,310-615-4500,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/1894937,partneresi.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",4

+59,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Kevin Miller,Thorofare Capital | EMAIL,Felix Gutnikov Kevin Miller,kevin@thorofarecapital.com,213-873-4007,,Active / Contacted,,,https://www.linkedin.com/company/1845520,thorofarecapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+60,93,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Lance Ryan,Watson Land Company | EMAIL,Lance Ryan  Stephen Fry,lryan@watsonlandcompany.com,310-952-6424,949-391-1285,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/watson-land-company,watsonlandcompany.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Financial PAnel",4

+61,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Larry Grantham,CalmWater | EMAIL,Bill Hess  Larry Grantham Ryan Malatesta,larry@calmwatercapital.com,310-806-9724,310-373-0103,Active / Contacted,,,https://www.linkedin.com/company/calmwater-capital,calmwatercapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+62,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Lisa Lombardo,KeyBank | EMAIL,Lisa Lombardo John Loshbaugh   Matthew Ruark,lisa_k_lombardo@keybank.com,216-689-3869,913-317-4237,Active / Contacted,,,https://www.linkedin.com/company/keybank,keybank.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+63,93,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Matt Levine,National Bank of Arizona | NAIOP,Bronson Naab Tim Colquhoun Martina Burberry Scott Stovall,matt.levine@nbarizona.com,612-812-1397,480-726-5740,Needs Email / Outreach Pending,Cheryl Holdraker,Director of Marketing,https://www.linkedin.com/company/national-bank-of-arizona,nbarizona.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+64,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Matthew Ruark,KeyBank | EMAIL,Lisa Lombardo John Loshbaugh   Matthew Ruark,matthew_t_ruark@keybank.com,216-689-3869,913-317-4237,Active / Contacted,,,https://www.linkedin.com/company/keybank,keybank.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+65,93,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Michaelle Cocagne,Marcus & Millichap HQ | Marcus & Millichap - IPA | EMAIL,"Hessam Nadji, Michelle Cocagne Alan Pontius",michelle.cocagne@marcusmillichap.com,925-953-1700,(415) 963-3070,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/marcus-,marcusmillichap.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",4

+66,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,Stacey Link,Berkeley Point Capital | EMAIL,Stacey Link  Peter Kurzeka,stacey.link@berkpoint.com,617-722-5015,301-347-4844,Active / Contacted,,,https://www.linkedin.com/company/berkeley-point-capital-llc,berkpoint.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+67,93,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Stephen Fry,Watson Land Company | EMAIL,Lance Ryan  Stephen Fry,stephen@evoinc.com,310-952-6424,949-391-1285,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/evo-strategies-inc-,evoinc.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects, Financial PAnel",4

+68,93,3 tabs; Active / Contacted; Strong Prospect; has email/phone,,CalmWater | EMAIL,Bill Hess  Larry Grantham Ryan Malatesta,ryanm@calmwatercapital.com,310-806-9724,310-373-0103,Active / Contacted,,,https://www.linkedin.com/company/calmwater-capital,calmwatercapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+69,91,4 tabs; Flag / Priority; has email/phone,Bob Ruth,The Ruth Group,,bruth@trgpartners.com,310-788-0838,,Flag / Priority,,,https://www.linkedin.com/company/the-ruth-group-inc.,trgpartners.com,"Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",4

+70,91,4 tabs; Flag / Priority; has email/phone,Neil Board,Western Retail Advisors,,nboard@w-retail.com,602.778.3745,,Flag / Priority,,,https://www.linkedin.com/company/western-retail-advisors,w-retail.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co.",4

+71,91,2 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,Randy Van,Private Mortgage Fund | EMAIL,Randy van Dueck  Gordan Van Dueck  Andrew Richards Christopher Bunce,randy@pmfundllc.com,805-373-2431,818-702-2551 x 9,Prospect / Follow-up,,,https://www.linkedin.com/company/private-mortgage-fund-llc,pmfundllc.com,"Sheet2, Strong Prospects",2

+72,91,2 tabs; Prospect / Follow-up; Strong Prospect; has email/phone,,Private Mortgage Fund | EMAIL,Randy van Dueck  Gordan Van Dueck  Andrew Richards Christopher Bunce,chris@pmfundllc.com,805-373-2431,818-702-2551 x 9,Prospect / Follow-up,,,https://www.linkedin.com/company/private-mortgage-fund-llc,pmfundllc.com,"Sheet2, Strong Prospects",2

+73,90,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Danielle Mishal,Bolour Associates | EMAIL,Danielle  Mishal Patel,mishal@bolourassociates.com,323-677-0550x 125,,Needs Email / Outreach Pending,,,,bolourassociates.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",4

+74,90,4 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Danielle Ricchuiti,Bolour Associates | EMAIL,Danielle  Mishal Patel,danielle@bolourassociates.com,323-677-0550x 125,,Needs Email / Outreach Pending,,,,bolourassociates.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",4

+75,89,6 tabs; Active / Contacted; has email/VP contact,Barry Gabel,Newmark,,barry.gabel@nmrk.com,,,Active / Contacted,Monique Rafferty,"SVP, Marketing",https://www.linkedin.com/company/nmrk-cre,nmrk.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+76,89,6 tabs; Active / Contacted; has email/VP contact,Becca Arriola,CBRE | Colliers,,Becca.Arriola@cbre.com,,,Active / Contacted,Benji Baer,Global Chief Marketing Officer,https://www.linkedin.com/company/cbre,cbre.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., retail panel",6

+77,89,6 tabs; Active / Contacted; has email/VP contact,Bryan Taute,CBRE,ofc,Bryan.taute@cbre.com,,,Active / Contacted,Brittany Warnica,Marketing Director (Phoenix AZ),https://www.linkedin.com/company/cbre,cbre.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+78,89,6 tabs; Active / Contacted; has email/VP contact,Corey Hawley,CBRE,ofc,corey.hawley@cbre.com,,,Active / Contacted,Brittany Warnica,Marketing Director (Phoenix AZ),https://www.linkedin.com/company/cbre,cbre.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+79,89,8 tabs; Active / Contacted; has email/VP contact,Kathy Foster,Colliers | Cushman & Wakefield,office,kathy.foster@colliers.com,,,Active / Contacted,Crissy Nolen,Chief Marketing Officer,https://www.linkedin.com/company/colliers-international,colliers.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",8

+80,89,6 tabs; Active / Contacted; has email/VP contact,Mike Garlick,Newmark,,mike.garlick@nmrk.com,,,Active / Contacted,Monique Rafferty,"SVP, Marketing",https://www.linkedin.com/company/nmrk-cre,nmrk.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+81,89,8 tabs; Active / Contacted; has email/VP contact,Phil Breidenbach,Colliers | Cushman & Wakefield,office,phil.breidenbach@colliers.com,,,Active / Contacted,Crissy Nolen,Chief Marketing Officer,https://www.linkedin.com/company/colliers-international,colliers.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",8

+82,89,6 tabs; Active / Contacted; has email/VP contact,Spencer Nast,CBRE,ofc,spencer.nast@cbre.com,,,Active / Contacted,Brittany Warnica,Marketing Director (Phoenix AZ),https://www.linkedin.com/company/cbre,cbre.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+83,89,8 tabs; Active / Contacted; has email/VP contact,Todd Noel,Colliers | Cushman & Wakefield | Picor,865 254 1323,Todd.Noel@colliers.com,,,Active / Contacted,Cheryl Garver,Marketing Director,https://www.linkedin.com/company/colliers-international,colliers.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",8

+84,87,5 tabs; Active / Contacted; has email/phone/VP contact,Aaron Dutcher,MHG Commercial,,aaron@mhgcommercial.com,480-797-8369,,Active / Contacted,Lish Cook,Marketing Strategist / Brand,https://www.linkedin.com/company/mhg-commercial-real-estate,mhgcommercial.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",5

+85,87,6 tabs; Active / Contacted; has email/phone,Adam Baugh,Withey Morris Baugh,,adam@wmbattorneys.com,602) 230-0600,,Active / Contacted,,,https://www.linkedin.com/in/adam-baugh,wmbattorneys.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel, charities",6

+86,87,6 tabs; Needs Email / Outreach Pending; has email/phone/VP contact,Adam Edwards,Eastdil Secured,949-930-7474,aedwards@eastdilsecured.com,949-930-7474,,Needs Email / Outreach Pending,Nicholas Leitner,SVP of Marketing,https://www.linkedin.com/in/adam-edwards-1bb1a3142/,eastdilsecured.com,"Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",6

+87,87,6 tabs; Active / Contacted; has email/phone,Alex Boles,ViaWest Group,,aboles@viawestgroup.com,,,Active / Contacted,,,https://www.linkedin.com/company/viawest-properties,viawestgroup.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Financial PAnel, Office Panel, retail panel",6

+88,87,6 tabs; Active / Contacted; has email/phone,Andrea Davis,Davis CRE,"She opened her brokerage a couple of years ago to get her name out there. Hired several brokers now, and she just launched her 2nd published book. Also lives in Scottsdale.",andrea@daviscreaz.com,480-435-9777,,Active / Contacted,,,https://www.linkedin.com/in/andreadavisccim,daviscreaz.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Event Sponsors, Office Panel, retail panel",6

+89,87,6 tabs; Active / Contacted; has email/phone,Bill Douglass,Upland Group,,bill.douglass@uplandgroup.com,480) 420-2306,,Active / Contacted,,,https://www.linkedin.com/company/usgi-upland-group,uplandgroup.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+90,87,5 tabs; Active / Contacted; has email/phone/VP contact,Brett Abramson,Stream Realty,,brett.abramson@streamrealty.com,,,Active / Contacted,Susan Bloomfield,Chief Marketing Officer,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+91,87,5 tabs; Active / Contacted; has email/phone/VP contact,Bryon Sarhangian,Snell & Wilmer,,bsarhangian@swlaw.com,602-382-6531,,Active / Contacted,Michelle Richards,Senior Director of Marketing,https://www.linkedin.com/company/13234,swlaw.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+92,87,7 tabs; Active / Contacted; has email/phone,Cathy Thuringer,Trammell Crow | Trammell Crow Company,,cthuringer@trammellcrow.com,602-222-4000,,Active / Contacted,,,https://www.linkedin.com/company/trammell-crow-company,trammellcrow.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel, charities",7

+93,87,6 tabs; Active / Contacted; has email/phone,Chad Kurz,Matthews Retail | Matthews Real Estate Invest Svcs | Matthews Real estate,,chad.kurz@matthews.com,310-497-5590,562-328-5745,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Multifamily, retail panel",6

+94,87,7 tabs; Active / Contacted; has email/phone,Chris Beall,Stream Realty | Stream Realty Partners,ofc,chris.beall@streamrealty.com,,,Active / Contacted,,,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet2, Sheet1, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",7

+95,87,7 tabs; Active / Contacted; has email/phone,Chris Latvaaho,Stream Realty | Stream Realty Partners,ofc,chris.latvaaho@streamrealty.com,,,Active / Contacted,,,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet2, Sheet1, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",7

+96,87,8 tabs; Active / Contacted; has email/phone,Cullen Mahoney,Trammell Crow | Trammell Crow Company | CBRE,,CMahoney@trammellcrow.com,602-222-4000,,Active / Contacted,,,https://www.linkedin.com/company/trammell-crow-company,trammellcrow.com,"Sheet2, Sheet1, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",8

+97,87,6 tabs; Active / Contacted; has email/phone,Danyale Breckenridge,ViaWest Group,,dbreckenridge@viawestgroup.com,,,Active / Contacted,,,https://www.linkedin.com/company/viawest-properties,viawestgroup.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Financial PAnel, Office Panel, retail panel",6

+98,87,6 tabs; Active / Contacted; has email/phone,David Cameron,Matthews Real Estate Invest Svcs | Matthews Real estate | Matthews,,david.cameron@matthews.com,480-881-3100,310-497-5590,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Multifamily",6

+99,87,8 tabs; Active / Contacted; has email/phone,Duerk Brewer,Matthews RE Investment Services | Matthews Real Estate Invest Svcs | Matthews Real estate,602-380-5964,duerk.brewer@matthews.com,480-881-3100,310-497-5590,Active / Contacted,,,https://www.linkedin.com/company/4821421,matthews.com,"Sheet2, Sponsors and Specaker Co., Multifamily, retail panel",8

+100,87,6 tabs; Active / Contacted; has email/phone,Jason Morris,Withey Morris Baugh,,jason@wmbattorneys.com,602) 230-0600,,Active / Contacted,,,https://www.linkedin.com/in/adam-baugh,wmbattorneys.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel, charities",6

+101,87,8 tabs; Active / Contacted; has email/phone,Jenn Gandin,CIM Group | CIM,,jgandin@cimgroup.com,323-860-4947,602.778.8700,Active / Contacted,,,https://www.linkedin.com/company/cimgroup,cimgroup.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",8

+102,87,6 tabs; Active / Contacted; has email/phone,Jim Erwin,The Opus Group    design build | The Opus Group,,jim.erwin@opus-group.com,,,Active / Contacted,,,https://www.linkedin.com/company/10674,opus-group.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",6

+103,87,5 tabs; Active / Contacted; has email/phone/VP contact,John Bonnell,Stream Realty,,john.bonnell@streamrealty.com,,,Active / Contacted,Susan Bloomfield,Chief Marketing Officer,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+104,87,5 tabs; Active / Contacted; has email/phone/VP contact,John Carlson,Mark-Taylor,,john.carlson@mark-taylor.com,480.504.7955,,Active / Contacted,Dustin Lacey,VP of Marketing & Technology,https://www.linkedin.com/company/mark-taylor-inc,mark-taylor.com,"Sheet2, Sponsors and Specaker Co., Event Sponsors, Multifamily, charities",5

+105,87,5 tabs; Active / Contacted; has email/phone/VP contact,John Pierson,JLL,,johnpierson@jll.com,,,Active / Contacted,Liz Newcomer,"Senior Director, Marketing Operations (Phoenix AZ)",https://www.linkedin.com/company/jll,jll.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+106,87,7 tabs; Needs Email / Outreach Pending; has email/phone/VP contact,K.C. Scheipe,Eastdil Secured,949-930-7474,kscheipe@eastdilsecured.com,949-930-7474,,Needs Email / Outreach Pending,Nicholas Leitner,SVP of Marketing,https://www.linkedin.com/company/eastdil-secured,eastdilsecured.com,"Sheet2, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",7

+107,87,7 tabs; Active / Contacted; has email/phone,Katlin Ruiz,Davis CRE,"She opened her brokerage a couple of years ago to get her name out there. Hired several brokers now, and she just launched her 2nd published book. Also lives in Scottsdale.",katlin@daviscreaz.com,480-435-9777,,Active / Contacted,,,https://www.linkedin.com/in/andreadavisccim,daviscreaz.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Event Sponsors, Office Panel, retail panel",7

+108,87,6 tabs; Active / Contacted; has email/phone,Larry Pobuda,The Opus Group    design build | The Opus Group,,lawrence.pobuda@opus-group.com,,,Active / Contacted,,,https://www.linkedin.com/company/10674,opus-group.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Office Panel, retail panel",6

+109,87,6 tabs; Active / Contacted; has email/phone,Lindsay Bennett,ViaWest Group,,lbennett@viawestgroup.com,,,Active / Contacted,,,https://www.linkedin.com/company/viawest-properties,viawestgroup.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Financial PAnel, Office Panel, retail panel",6

+110,87,5 tabs; Active / Contacted; has email/phone/VP contact,Martin Pupil,Stream Realty,,martin.pupil@streamrealty.com,,,Active / Contacted,Susan Bloomfield,Chief Marketing Officer,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+111,87,6 tabs; Active / Contacted; has email/phone,Michael Withey,Withey Morris Baugh,,michael@wmbattorneys.com,602) 230-0600,,Active / Contacted,,,https://www.linkedin.com/in/adam-baugh,wmbattorneys.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel, charities",6

+112,87,5 tabs; Active / Contacted; has email/phone/VP contact,Richard Friedman,Greystar,,rfriedman@greystar.com,949-705-0010,949-705-0012,Active / Contacted,Kelly Siegal,"Managing Director, Marketing",https://www.linkedin.com/company/greystar,greystar.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel, Multifamily",5

+113,87,7 tabs; Active / Contacted; has email/phone,Shaul Kuba,CIM Group | CIM,,skuba@cimgroup.com,323-860-4947,602.778.8700,Active / Contacted,,,https://www.linkedin.com/company/cimgroup,cimgroup.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",7

+114,87,5 tabs; Active / Contacted; has email/phone/VP contact,Shawn Hansen,Greystar,,shansen@greystar.com,949-705-0010,949-705-0012,Active / Contacted,Kelly Siegal,"Managing Director, Marketing",https://www.linkedin.com/company/greystar,greystar.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel, Multifamily",5

+115,87,5 tabs; Active / Contacted; has email/phone/VP contact,Stirling Pascal,Stream Realty,,stirling.pascal@streamrealty.com,,,Active / Contacted,Susan Bloomfield,Chief Marketing Officer,https://www.linkedin.com/company/stream-realty-partners,streamrealty.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+116,87,6 tabs; Active / Contacted; has email/phone,Todd Weiss,ViaWest Group,,tweiss@viawestgroup.com,,,Active / Contacted,,,https://www.linkedin.com/company/viawest-properties,viawestgroup.com,"Sheet2, Sheet1, Financial PAnel, Office Panel, retail panel",6

+117,87,6 tabs; Active / Contacted; has email/phone,Tom Glissmeyer,ViaWest Group,,mglissmeyer@viawestgroup.com,,,Active / Contacted,,,https://www.linkedin.com/company/viawest-properties,viawestgroup.com,"Sheet2, Sheet1, Financial PAnel, Office Panel, retail panel",6

+118,87,7 tabs; Active / Contacted; has email/phone,Whitney Delgado,PMB | PMB Real Estate services | PMB Real Estate Services,Sr PM,wdelgado@pmbres.com,,,Active / Contacted,,,https://www.linkedin.com/company/pmb-real-estate-services,pmbres.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",7

+119,87,7 tabs; Active / Contacted; has email/phone,,CIM Group | CIM,,jschreiber@cimgroup.com,323-860-4947,602.778.8700,Active / Contacted,,,https://www.linkedin.com/company/cimgroup,cimgroup.com,"Sheet2, Sheet1, Sponsors and Specaker Co., Multifamily, Office Panel, retail panel",7

+120,87,6 tabs; Active / Contacted; has email/phone,,Upland Group,,billd@uplandgroup.com,480) 420-2306,,Active / Contacted,,,https://www.linkedin.com/company/usgi-upland-group,uplandgroup.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+121,87,6 tabs; Active / Contacted; has email/phone,,Withey Morris Baugh,,m@wmbattorneys.com,602) 230-0600,,Active / Contacted,,,https://www.linkedin.com/in/adam-baugh,wmbattorneys.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel, charities",6

+122,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Alexa Mizrahi,Lone Oak | EMAIL,"Alexa Mizrahi, Harriet Ducot Tyler Hereford",alexa@loneoakfund.com,310-826-2888,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/lone-oak-fund-llc,loneoakfund.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+123,85,2 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Andew McDonald,Cushman & Wakefield | EMAIL,Andew McDonald  Eric Olofson,andrew.mcdonald@cushwake.com,213-955-5100,,Needs Email / Outreach Pending,Patricia Neill,Marketing Director,https://www.linkedin.com/in/andrewmcdonald1/,cushwake.com,"Sheet2, Strong Prospects",2

+124,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Andy Walburger,Ten-X | EMAIL,Randa McMinn Steve Jacobs  Rob Drury Andy Walburger Maureen Waters Joseph Cuomo,awalburger@ten-x.com,201-465-8007,949-609-5376,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/ten-x,ten-x.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+125,85,5 tabs; Prospect / Follow-up; has email/phone,Asher Luzzatto,The Luzzatto Company,,asher@luzzattocompany.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/the-luzzatto-company-inc,luzzattocompany.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+126,85,6 tabs; Active / Contacted; has phone/VP contact,Bartos,JLL,,,,,Active / Contacted,Liz Newcomer,"Senior Director, Marketing Operations (Phoenix AZ)",https://www.linkedin.com/company/jll,jll.com,"Sheet1, Sheet2, ARIZONA BROKERAGE FIRMS, Sponsors and Specaker Co., Office Panel, retail panel",6

+127,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Bobby Khorshidi,Archway Holdings | EMAIL,"Marissa; Bobby Khorshidi, Guido Chiappa VP",bobby@archwayfund.com,(310) 980-9878,310-447-8899,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/archway-fund,archwayfund.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+128,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Carissa Schlosser,Morgan Stanley | EMAIL,Tom Lawlor Gary Duff Carissa Schlosser    Lisa Matulis at Martin Advertsiing,carissa.schlosser@morganstanley.com,310-788-2113,310-788-1727,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/morgan-stanley,morganstanley.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+129,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Chad Williams,Bellwether Enterprise | EMAIL,Greg Fink Chad Williams  Ned Huffman Pres  Debbie Rogan EVP   Adrian Corbiere  Todd Harrop EVP  Phil Melton EVP,chwilliams@bwecap.com,813-767-9903,949.247.8906,Active / Contacted,,,https://www.linkedin.com/company/bellwether-enterprise-real-estate-capital,bwecap.com,"Sheet2, Strong Prospects",2

+130,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,David McMahon,Tauro Capital Advisors | EMAIL,310-564-2641,davidmcmahon90@gmail.com,310-564-2641,213-268-4006,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/tauro-real-estate-investment-services-inc-,taurocapitaladvisors.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+131,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,David Padilla,CoStar | EMAIL,"David Padilla, James Petronella",dpadilla@costar.com,310-692-5602,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/costar-group,costar.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+132,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Debbie Rogan,Bellwether Enterprise | EMAIL,Greg Fink Chad Williams  Ned Huffman Pres  Debbie Rogan EVP   Adrian Corbiere  Todd Harrop EVP  Phil Melton EVP,drogan@bwecap.com,813-767-9903,949.247.8906,Active / Contacted,,,https://www.linkedin.com/company/bellwether-enterprise-real-estate-capital,bwecap.com,"Sheet2, Strong Prospects",2

+133,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Elliot Shirwo,BridgeCore Capital | EMAIIL,Elliot Shirwo  Roger Pondel,elliot@bridgecorecapital.com,310-748-4414,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/bridgecorecapital,bridgecorecapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+134,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Eric Hasserjian,NAI Capital | EMAIL,Eric Hasserjian JC Casillas   Michael Zugsmith Rick Gold,ehasserjian@naicapital.com,818 933 2433,310-440-8500,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/nai-capital,naicapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+135,85,2 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone/VP contact,Eric Olofson,Cushman & Wakefield | EMAIL,Andew McDonald  Eric Olofson,eric.olofson@cushwake.com,213-955-5100,,Needs Email / Outreach Pending,Patricia Neill,Marketing Director,https://www.linkedin.com/company/cushman-,cushwake.com,"Sheet2, Strong Prospects",2

+136,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Felix Gutnikov,Thorofare Capital | EMAIL,Felix Gutnikov Kevin Miller,felix@thorofarecapital.com,213-873-4007,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/1845520,thorofarecapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+137,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Gary Bechtel,Money 360 | EMAIL,Gary Bechtel,garybechtel@money360.com,714-504-8500,949-528-9311,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/money360,money360.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+138,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Gary Duff,Morgan Stanley | EMAIL,Tom Lawlor Gary Duff Carissa Schlosser    Lisa Matulis at Martin Advertsiing,gary.duff@morganstanley.com,310-788-2113,310-788-1727,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/morgan-stanley,morganstanley.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+139,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Greg Fink,Bellwether Enterprise | EMAIL,Greg Fink Chad Williams  Ned Huffman Pres  Debbie Rogan EVP   Adrian Corbiere  Todd Harrop EVP  Phil Melton EVP,gfink@bwecap.com,813-767-9903,949.247.8906,Active / Contacted,,,https://www.linkedin.com/company/bellwether-enterprise-real-estate-capital,bwecap.com,"Sheet2, Strong Prospects",2

+140,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Hingson Doug,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",doug@parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+141,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,James Petronella,CoStar | EMAIL,"David Padilla, James Petronella",jpetronella@costar.com,310-692-5602,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/costar-group,costar.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+142,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,JC Casillas,NAI Capital | EMAIL,Eric Hasserjian JC Casillas   Michael Zugsmith Rick Gold,jcasillas@naicapital.com,818 933 2433,310-440-8500,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/nai-capital,naicapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+143,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,John Hillier,Citizens Business Bank | EMAIL,Senior VP,jphillier@cbbank.com,626-437-7456,714-996-8150,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/citizens-business-bank,cbbank.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+144,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,John Jacobs,PGIM | EMAIL,John Jacobs / Virginia Casey / Nicki De Curtis,john.jacobs@prudential.com,312-565-6268,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/prudential-financial,prudential.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+145,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Josh Vidro,McShane Companies | EMAIL,"Josh Vidro  Sheri Tantari, Mary Michaelsen  JOsh Vydro",jvidro@mcshane.com,847-692-8873,847-292-4300,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/mcshane-construction-company,mcshane.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+146,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Karim Moullemaaz,Fidelity National Title | EMAIL,Karim Moullemaaz,karim@fnf.com,562-857-0900,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/fidelitynationaltitle-ncs,fnf.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+147,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Karina Bradley,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",Karina@Parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+148,85,5 tabs; Prospect / Follow-up; has email/phone,Marc Luzzatto,The Luzzatto Company,,marc@luzzattocompany.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/the-luzzatto-company-inc,luzzattocompany.com,"Sheet1, Sheet2, Sponsors and Specaker Co., Office Panel, retail panel",5

+149,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Marissa,Archway Holdings | EMAIL,"Marissa; Bobby Khorshidi, Guido Chiappa VP",marissa@archwayfund.com,(310) 980-9878,310-447-8899,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/archway-fund,archwayfund.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+150,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Mary Michaelsen,McShane Companies | EMAIL,"Josh Vidro  Sheri Tantari, Mary Michaelsen  JOsh Vydro",mmichaelsen@mcshane.com,847-692-8873,847-292-4300,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/mcshane-construction-company,mcshane.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+151,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Melissa Sutton,Yardi | EMAIL,Melissa Sutton,melissa.sutton@yardi.com,800-866-1144,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/yardi,yardi.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+152,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Michael Duran,Citizens Business Bank | EMAIL,Senior VP,mduran@cbbank.com,626-437-7456,714-996-8150,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/citizens-business-bank,cbbank.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+153,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Paul Fiorilla,Yardi | EMAIL,Melissa Sutton,paul.fiorilla@yardi.com,800-866-1144,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/yardi,yardi.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+154,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Paul Rahimian,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",paul@parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+155,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Randa McMinn,Ten-X | EMAIL,Randa McMinn Steve Jacobs  Rob Drury Andy Walburger Maureen Waters Joseph Cuomo,rmcminn@ten-x.com,201-465-8007,949-609-5376,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/ten-x,ten-x.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+156,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Ray Pressley,Brevitas | EMAIL,Ray Pressley,rpressley@brevitas.com,,,Needs Email / Outreach Pending,,,https://www.linkedin.com/in/raymondpressley,brevitas.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+157,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Rick Gold,NAI Capital | EMAIL,Eric Hasserjian JC Casillas   Michael Zugsmith Rick Gold,rgold@naicapital.com,818 933 2433,310-440-8500,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/nai-capital,naicapital.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+158,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Rob Hervey,Northmarq Capital | EMAIL,Rob Hervey / Lisa Baccare  Joe Giordani,rhervey@northmarq.com,856-813-3248,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/northmarq,northmarq.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+159,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Ross Luke,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",luke@parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+160,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Sheri Tantari,McShane Companies | EMAIL,"Josh Vidro  Sheri Tantari, Mary Michaelsen  JOsh Vydro",stantari@mcshane.com,847-692-8873,847-292-4300,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/mcshane-construction-company,mcshane.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+161,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Stephen Stein,Tauro Capital Advisors | EMAIL,310-564-2641,sstein@taurocapitaladvisors.com,310-564-2641,213-268-4006,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/tauro-real-estate-investment-services-inc-,taurocapitaladvisors.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+162,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Sterling McGregor,SVN Dealpoint Merrill | EMAIL,"David Frank, Sterling McGregor,",smcgregor@dealpointmerrill.com,949-231-7757,,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/dealpoint-merrill,dealpointmerrill.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+163,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Susan Hyde.,W.P. Carey | EMAIL,Susan Hyde. Guy Lawrence,shyde@wpcarey.com,212-492-1100,212-492-1151,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/w-p-carey-inc,wpcarey.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+164,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,Todd Harrop,Bellwether Enterprise | EMAIL,Greg Fink Chad Williams  Ned Huffman Pres  Debbie Rogan EVP   Adrian Corbiere  Todd Harrop EVP  Phil Melton EVP,tharrop@bwecap.com,813-767-9903,949.247.8906,Active / Contacted,,,https://www.linkedin.com/company/bellwether-enterprise-real-estate-capital,bwecap.com,"Sheet2, Strong Prospects",2

+165,85,3 tabs; Needs Email / Outreach Pending; Strong Prospect; has email/phone,Tom Lawlor,Morgan Stanley | EMAIL,Tom Lawlor Gary Duff Carissa Schlosser    Lisa Matulis at Martin Advertsiing,thomas.lawlor@morganstanley.com,310-788-2113,310-788-1727,Needs Email / Outreach Pending,,,https://www.linkedin.com/company/morgan-stanley,morganstanley.com,"Sheet2, Sponsors and Specaker Co., Strong Prospects",3

+166,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",larry@parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+167,85,2 tabs; Active / Contacted; Strong Prospect; has email/phone,,Parkview Financial | EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",brad@parkviewfinancial.com,310-996-8999,310-406-7566,Active / Contacted,,,https://www.linkedin.com/company/parkview-financial,parkviewfinancial.com,"Sheet2, Strong Prospects",2

+168,84,7 tabs; Active / Contacted; has email/phone,Cass Stephens,Cass Stephens Commercial Broker | S.J. Fowler RE Investments | S.J. Fowler Real Estate iNvestments,,cstephens@ccim.net,602-672-3526,,Active / Contacted,,,,ccim.net,"Sheet2, Sponsors and Specaker Co., Multifamily",7

+169,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Alison Shumaker,EMAIL,John Manganiello / Peter Drake   Alison Shumaker,Alison.shumaker@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+170,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Archway Holdings,EMAIL,"Marissa; Bobby Khorshidi, Guido Chiappa VP",archwayholdings@bankofamerica.com,(310) 980-9878,310-447-8899,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+171,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Avison Young,EMAIL,paige Aldrich,avisonyoung@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+172,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Bank Of,EMAIL,John Manganiello / Peter Drake   Alison Shumaker,bankof@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+173,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Bellwether Enterprise,EMAIL,Greg Fink Chad Williams  Ned Huffman Pres  Debbie Rogan EVP   Adrian Corbiere  Todd Harrop EVP  Phil Melton EVP,bellwetherenterprise@bankofamerica.com,813-767-9903,949.247.8906,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+174,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Berkadia Commercial,EMAIL,Diana O'Connor,berkadiacommercial@bankofamerica.com,215-328-3267,800-446-2226,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+175,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Berkeley Point,EMAIL,Stacey Link  Peter Kurzeka,berkeleypoint@bankofamerica.com,617-722-5015,301-347-4844,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+176,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Black Creek,EMAIL,JR Wetzel Gregg Boehm  Christopher Sanford,blackcreek@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+177,83,3 tabs; Flag / Priority; has email/phone,Bob O'Neill,CapRock Partners | Caprock Partners,,boneill@caprock-partners.com,949-342-8000 x 108,,Flag / Priority,,,https://www.linkedin.com/company/caprock-partners,caprock-partners.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel",3

+178,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Bolour Associates,EMAIL,Danielle  Mishal Patel,bolourassociates@bankofamerica.com,323-677-0550x 125,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+179,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Citizens Business,EMAIL,Michael Duran John Hillier,citizensbusiness@bankofamerica.com,714-996-8150,626-564-6240,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+180,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Evergreen Development,EMAIL,"Laura Ortiz, Bryan Lamond -Dir Acquis  Rogg Collins  Chris Bergren",evergreendevelopment@bankofamerica.com,818-334-1321,310-480-0128,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+181,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Fidelity National,EMAIL,Karim Moullemaaz,fidelitynational@bankofamerica.com,562-857-0900,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+182,83,3 tabs; Flag / Priority; has email/phone,Jon Pharris,CapRock Partners | Caprock Partners,,jpharris@caprock-partners.com,949-342-8000 x 108,,Flag / Priority,,,https://www.linkedin.com/company/caprock-partners,caprock-partners.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel",3

+183,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Kennedy Funding,EMAIL,Edwin Urrego   David Green at Results ad,kennedyfunding@bankofamerica.com,800-342-8500,201-288-7888,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+184,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Kidder Mathews,EMAIL,,kiddermathews@bankofamerica.com,206296-9606,562472-0077,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+185,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Lone Oak,EMAIL,"Alexa Mizrahi, Harriet Ducot Tyler Hereford",loneoak@bankofamerica.com,310-826-2888,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+186,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Matthews Retail,EMAIL,"Kyle Matthews; Daniel Withers, lori.valencia David Harrington",matthewsretail@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+187,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,McShane Companies,EMAIL,"Josh Vidro  Sheri Tantari, Mary Michaelsen  JOsh Vydro",mcshanecompanies@bankofamerica.com,847-692-8873,847-292-4300,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+188,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Morgan Stanley,EMAIL,Tom Lawlor Gary Duff Carissa Schlosser    Lisa Matulis at Martin Advertsiing,morganstanley@bankofamerica.com,310-788-2113,310-788-1727,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+189,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Parkview Financial,EMAIL,"Paul Rahimian, Karina Bradley Ross Luke Hingson Doug Esteves",parkviewfinancial@bankofamerica.com,310-996-8999,310-406-7566,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+190,83,3 tabs; Flag / Priority; has email/phone,Pat Daniels,CapRock Partners | Caprock Partners,,pdaniels@caprock-partners.com,949-342-8000 x 108,,Flag / Priority,,,https://www.linkedin.com/company/caprock-partners,caprock-partners.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel",3

+191,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Private Mortgage,EMAIL,Randy van Dueck  Gordan Van Dueck  Andrew Richards Christopher Bunce,privatemortgage@bankofamerica.com,805-373-2431,818-702-2551 x 9,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+192,83,3 tabs; Flag / Priority; has email/phone,Rachel Bliss,Western Retail Advisors,,rbliss@w-retail.com,602.778.3745,,Flag / Priority,,,https://www.linkedin.com/company/western-retail-advisors,w-retail.com,"Sheet2, Sponsors and Specaker Co., retail panel",3

+193,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,RED Development,EMAIL,"Jeff Moloznik Michael Ebert, Scott Rehorn, Brett Heron, Mike Kallner, Shane Stephens, Emily park",reddevelopment@bankofamerica.com,480-947-7772,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+194,83,3 tabs; Flag / Priority; has email/phone,Ryan Desmond,Western Retail Advisors,,rdesmond@w-retail.com,602.778.3745,,Flag / Priority,,,https://www.linkedin.com/company/western-retail-advisors,w-retail.com,"Sheet2, Sponsors and Specaker Co., retail panel",3

+195,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Shea Properties,EMAIL,James Williams  Vincent Lee Jon Marchiorlatti,sheaproperties@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+196,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Stewart Title,EMAIL,Joshua Bishop,stewarttitle@bankofamerica.com,713-625-8348,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+197,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,SVN Dealpoint,EMAIL,"David Frank, Sterling McGregor,",svndealpoint@bankofamerica.com,949-231-7757,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+198,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,Tauro Advisors,EMAIL,Stephen Stein  David McMahon   714-642-9976,tauroadvisors@bankofamerica.com,,,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

+199,83,3 tabs; Flag / Priority; has email/phone,Taylor Arnett,CapRock Partners | Caprock Partners,,tarnett@caprock-partners.com,949-342-8000 x 108,,Flag / Priority,,,https://www.linkedin.com/company/caprock-partners,caprock-partners.com,"Sheet2, Sponsors and Specaker Co., Financial PAnel",3

+200,83,1 tab; Prospect / Follow-up; Strong Prospect; has email/phone,W.P. Carey,EMAIL,Susan Hyde. Guy Lawrence,wpcarey@bankofamerica.com,212-492-1100,212-492-1151,Prospect / Follow-up,,,https://www.linkedin.com/company/bank-of-america,bankofamerica.com,Strong Prospects,1

diff --git a/warmth.py b/warmth.py
new file mode 100644
index 0000000..637d52f
--- /dev/null
+++ b/warmth.py
@@ -0,0 +1,126 @@
+"""
+Warmth scoring for RENTV leads β€” one definition of "warm", shared by the live
+console (live_server.py) and the top-N export (export_top.py) so they never drift.
+
+A lead's warmth blends the three signals that already live in the sheet:
+  1. Centrality  β€” # Appearances (how many source tabs a contact shows up on).
+  2. Intent      β€” Status (color): a flagged/left-message lead outranks a cold one.
+  3. Reachabilityβ€” do we actually have an email / phone / LinkedIn / enriched VP?
+Plus a Strong-Prospects membership bonus (Steve's own hand-tagged short list).
+
+The score is a plain int. Higher = work first. Section/header rows get a large
+negative so they sink to the bottom under a descending sort.
+
+Pure/stdlib, no deps β€” same input always yields the same score ($0, offline).
+"""
+
+WARMTH_HEADER = "πŸ”₯ Warmth"
+
+# Status (color) -> intent weight. Keys match the sheet's inferred status labels.
+_STATUS_WEIGHT = {
+    "Flag / Priority": 40,
+    "In Progress / Left Message": 32,
+    "Prospect / Follow-up": 26,
+    "Active / Contacted": 20,
+    "Needs Email / Outreach Pending": 12,
+    "On Hold / Inactive": -25,
+    "Section / Category": -100,   # header/divider rows β€” sink them
+}
+
+
+def _cell(row, idx, name):
+    i = idx.get(name)
+    if i is None or i >= len(row):
+        return ""
+    v = row[i]
+    return "" if v is None else str(v).strip()
+
+
+def _int(s):
+    try:
+        return int(float(str(s).strip() or 0))
+    except (ValueError, TypeError):
+        return 0
+
+
+def score(row, idx):
+    """row = list of cell values; idx = {header_name: col_index}. Returns int warmth."""
+    pts = 0
+
+    # 1. Centrality β€” capped so a contact spammed across every tab can't dominate.
+    appearances = _int(_cell(row, idx, "# Appearances"))
+    pts += min(appearances, 6) * 8            # 0..48
+
+    # 2. Intent
+    status = _cell(row, idx, "Status (color)")
+    pts += _STATUS_WEIGHT.get(status, 0)
+
+    # 3. Strong-Prospects membership (Steve's hand-tagged list)
+    src = _cell(row, idx, "Source Tabs").lower()
+    if "strong prospects" in src:
+        pts += 30
+
+    # 4. Reachability β€” a warm lead we can't contact is worth less.
+    email = _cell(row, idx, "Email") or _cell(row, idx, "Updated Email (found)") \
+        or _cell(row, idx, "Likely Email (inferred)")
+    if email:
+        pts += 10
+    phone = any(_cell(row, idx, p) for p in
+                ("Phone 1", "Phone 2", "Phone 3", "Company Phone (found)", "Marketing/VP Phone"))
+    if phone:
+        pts += 6
+    if _cell(row, idx, "Marketing/VP Name") or _cell(row, idx, "Marketing/VP Contact"):
+        pts += 8
+    if _cell(row, idx, "LinkedIn (Contact)") or _cell(row, idx, "LinkedIn (Company)"):
+        pts += 3
+
+    return pts
+
+
+def reason(row, idx):
+    """Short human 'why warm' string for the export β€” mirrors score()'s inputs."""
+    bits = []
+    app = _int(_cell(row, idx, "# Appearances"))
+    if app:
+        bits.append(f"{app} tab{'s' if app != 1 else ''}")
+    status = _cell(row, idx, "Status (color)")
+    if status and status != "Section / Category":
+        bits.append(status)
+    if "strong prospects" in _cell(row, idx, "Source Tabs").lower():
+        bits.append("Strong Prospect")
+    reach = []
+    if _cell(row, idx, "Email") or _cell(row, idx, "Updated Email (found)") \
+            or _cell(row, idx, "Likely Email (inferred)"):
+        reach.append("email")
+    if any(_cell(row, idx, p) for p in
+           ("Phone 1", "Phone 2", "Phone 3", "Company Phone (found)", "Marketing/VP Phone")):
+        reach.append("phone")
+    if _cell(row, idx, "Marketing/VP Name"):
+        reach.append("VP contact")
+    if reach:
+        bits.append("has " + "/".join(reach))
+    return "; ".join(bits)
+
+
+def can_score(headers):
+    """Only augment tabs that actually carry the signals β€” others get no column."""
+    hs = set(headers)
+    return ("Status (color)" in hs) or ("# Appearances" in hs)
+
+
+def augment(payload):
+    """Given a tab/combined payload {headers, rows, ...}, append the Warmth column
+    (in the RESPONSE only β€” never written back to the sheet). Returns the payload."""
+    headers = payload.get("headers", [])
+    if not can_score(headers):
+        return payload
+    idx = {h: i for i, h in enumerate(headers)}
+    new_headers = list(headers) + [WARMTH_HEADER]
+    new_rows = []
+    for r in payload.get("rows", []):
+        new_rows.append(list(r) + [score(r, idx)])
+    payload = dict(payload)
+    payload["headers"] = new_headers
+    payload["rows"] = new_rows
+    payload["warmth_col"] = len(new_headers) - 1   # so the UI can find it
+    return payload

← 72a7312 rentv :9797 legend: Cody fixes β€” sticky header (βœ• stays visi  Β·  back to Rentv Sheet Enrich  Β·  rentv :9797 legend: fold the long tail of one-off color tint 06105fe β†’