- Before
- “I can’t price a schedule I don’t believe.” Prices Gulf Coast renewals on whatever survived the scrub.
- Now
- Opens a map that shows which rows to stop believing, fixes pins by dragging them and decides each finding with its source in view.
One Gulf Coast renewal, from spreadsheet to model-ready file
Harlow & Vane sends the Tidewater Crest Logistics renewal: 42 warehouses, cold stores and truck terminals from Victoria, Texas to Pensacola, Florida, TIV $989.49M, effective 1 November. Here is what happens next, screen by screen, in the working solution.
- 01Morning
Every schedule that came in, on one screen
Elena Marsh · Senior property underwriterElena opens Accounts: seven schedules, each a stripe of its locations coloured clean, fixed by an agent, needs you or agents reading. Tidewater Crest Logistics — 42 locations, $989.5M TIV, quote due Fri 23 Oct — is marked Ready for you.
- 02Earlier, at 06:10
Six agents read, place, check and value every row
The agentsThe schedule reader maps the broker’s 31 columns across three tabs to the 24 standard fields. The geocoder drops every pin on the map, then the property data checker and the valuation checker work through each location while the pins change colour.
“Valuation checker · value per sq ft against rebuild cost for construction, occupancy and area · 5 under 80% · 1 over 130%”
- 03Done
The schedule map: which rows to stop believing
Elena Marsh · Senior property underwriterGreen is clean, amber the agents fixed, red needs her. Of 42 locations, 22 are clean, 12 were fixed by an agent and 8 need Elena. Beside the map, the COPE table shows each location’s construction, occupancy, protection and exposure, with suspect values outlined, value per square foot and a bar against rebuild cost. TIV moves from $989.49M submitted to $1,001.71M checked.
On the map, without anyone looking for it: “Baytown · insured at 48% of rebuild”.
- 04Location 23
A cold store that landed on a ZIP centroid
Geocoder2215 Calcasieu Channel Rd is not in the address file, so it matched only the 70601 ZIP centroid, in flood Zone X. The geocoder searched the parcels on the channel road and found a 96,000 sq ft cold store 5.6 km west, on the ship channel, in Zone AE. It shows the old pin hollow, with a dotted line to its best match — and does not move it on its own.
“Agents’ best match · cold store, 96,000 sq ft · drag pin 23 here”
- 05One drag
She moves the pin onto the building
Elena Marsh · Senior property underwriterElena moves pin 23 onto the cold store. It re-geocodes to the roof, the hazard mapper re-runs, and the row, the flood zone and the exposure file update together. Needs you drops to 7.
“Pin 23 moved to the roof · 5.6 km west · flood Zone X → Zone AE, BFE 8 ft · exposure file updated”
- 06Next
Colour the map by value, not just data quality
Elena Marsh · Senior property underwriterOne switch recolours every pin by insured value against rebuild cost: under 60%, 60–80%, 80–130% and over 130%. The comparison uses the checked area and occupancy, so a wrong square footage or a missed freezer cannot hide an under-valued building.
- 07Location 17
Baytown: insured at 48% of rebuild
Valuation checker4410 Port Road is a 212,000 sq ft tilt-up distribution warehouse, masonry non-combustible, built 1998, ESFR sprinklered. The schedule carries $9.8M — $46 per sq ft. Rebuilding it in the Houston area costs about $96 per sq ft, $20.35M. The value has been $9.8M on every schedule since 2019 while the area cost index rose 45%.
- 08Location page
What the broker said, what the agents found, and where
Elena Marsh · Senior property underwriterThe location page shows the rebuild build-up (212,000 sq ft × $96 × 1.00 for the Baytown area), the building value on each schedule beside the cost index, every field with its source, and the agents’ run on this location. Elena decides: accept the checked value or keep the broker’s.
“With 90% coinsurance the building limit of $9.80M is 54% of what is required: a $4.0M partial loss would be paid at about $2.14M, before the deductible.”
- 09Drafted
Ten questions, one email, every one with its evidence
Broker query writerOne email to Megan Cole at Harlow & Vane, copied to Raj Patel: the Pasadena sprinklers the 2025 survey found in the office only, the Beaumont freezer addition, the Gentilly row counted twice, five building values under 80% of rebuild. The 12 small corrections the agents made are listed, not asked. Beside it: what the answers change — +$29.99M of building value on the five under-valued locations, −$17.77M for the duplicate, $34.71M into flood Zone AE.
“Untick a question to leave it out. Nothing goes until you send it.”
- 10Ready for modelling
A model-ready exposure file, unknowns kept unknown
Tomás Rivera · Catastrophe modelling analystThe exposure file shows total insured value by flood zone and by distance to the coast, submitted beside checked, how precisely each location is placed, and the fields the model reads. Floor elevation is known for 6 of 41 locations, so the other 35 go as unknown and the model uses its neutral assumption — never a favourable value.
“Unknowns stay unknown — never coded as a credit.”