Instructions

Chart
1. Create a new tab and label it "Charts"
2. Using the data in the "Raw Data" tab, create a Line Chart in this tab that trends Expiry Date Vs In
3. Using the data in the "Raw Data" tab, create a Bar Chart in this tab that displays Total Value by C

Pivot Table
4. Create a pivot table in a new sheet from the table in the Raw Data tab
5. In the pivot table, display the Average of the Insured Value by State (as rows), and format Insure

Formulas
6. In the "Formulas" Tab, use a lookup formula to grab the corresponding value for "Business Type"
7. In the "Formulas" Tab, in Cell G2, create a SUMIF formula to sum all Insured values, that are asso

Extract
8. In the "Extract" tab, create a formula in Column B, to extract the $ amount value from the Raw D
9. In the "Extract" tab, create a formula in Column C, to extract the date value from the Raw Descri
10. In the "Extract" tab, create a formula in Column D, to extract the description part (without the d
Send your completed file to [email protected], with the subject: "Excel Test - [Your Na
ends Expiry Date Vs Insured Value over time
plays Total Value by Code. Display the chart showing the highest total value at the top, and smallest at the bottom

ws), and format Insured Value as a $ amount

ue for "Business Type" from the Raw Data table, based on the policy number and populate this in column B (replacing the q
d values, that are associated with the State "NY"

value from the Raw Description in Column A

e from the Raw Description in Column A
on part (without the date or amount) from the Raw Description in Column A
Excel Test - [Your Name]
smallest at the bottom

this in column B (replacing the question marks)

 InsuredValue ($) Char
60000000

50000000

40000000

30000000 Total Value ($)

20000000

10000000

0
21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 21 0 10000000 20000000
n- n- b- b- r- r- r- y- y- n- n- l- l- g- g- p- t- t- v- v- c- c-
J- a -Ja -Fe -Fe -Ma -Ma -Ap Ma Ma -Ju -Ju 8-Ju 5-Ju -Au -Au -Se -Oc -Oc -No -No -De -De
2 19 5 22 1 8 14 1- 8- 4 21 2 11 28 14 1 18 4 21 8 25
1 2 1 Yellow Black Orange Red
 Chart Title Chart Title

e ($) Total Value ($)

0 10000000 20000000 30000000 40000000 50000000 60000000 0 10000000 20000000 30000000 40000000 500

Yellow Black Orange Red Blue Grey White Green Orange Black White Green Grey Blue Yello
Chart Title

000000 30000000 40000000 50000000 60000000

Green Grey Blue Yellow Red

State Average of InsuredValue ($)
IL 6634326.78571429
ME 2484138.75
MI 2555560
MN 1569650
NH 766028.571428572
NJ 4391706.57894737
NY 5733209.56923077
OH 2241762.35714286
VT 5342791.86956522
WI 4051165.51086957
Total Result 4971117.93787575
Policy State Expiry InsuredValue ($) Location Region Construction BusinessType Earthquak Flood Code
100314 NY 2-Jan-21 8678500 Urban East Fire Resist Apartment Y Y Red
100359 WI 2-Jan-21 2052660 Rural Midwest Frame Farming N N Yellow
100315 NY 2-Jan-21 17580000 Urban East Frame Apartment Y Y Blue
100385 NY 3-Jan-21 1925000 Urban East Masonry Hospitality N N Grey
100388 IL 3-Jan-21 12934500 Urban Midwest Frame Apartment Y Y Green
100358 WI 4-Jan-21 928300 Urban Midwest Masonry Office Bldg N N White
100264 NY 5-Jan-21 2219900 Rural East Frame Farming N N Black
100265 NY 7-Jan-21 14100000 Urban East Frame Apartment Y Y Orange
100357 NY 7-Jan-21 4762808 Urban East Masonry Other Y Y
100399 NY 8-Jan-21 13925190 Urban East Frame Apartment Y Y
100329 NY 8-Jan-21 6350000 Urban East Frame Apartment Y Y
100429 WI 9-Jan-21 4036000 Urban Midwest Masonry Medical Y Y
100441 NJ 9-Jan-21 472800 Urban East Masonry Retail Y Y
100442 WI 10-Jan-21 11710880 Urban Midwest Masonry Apartment Y Y
100372 NY 10-Jan-21 1370300 Urban East Frame Apartment Y Y
100281 WI 12-Jan-21 1432835 Rural Midwest Frame Farming N N
100280 NY 13-Jan-21 82000 Urban East Masonry Organization Y Y
100424 NY 15-Jan-21 192000 Urban East Masonry Retail N N
100425 NY 16-Jan-21 4950000 Urban East Frame Office Bldg Y Y
100426 VT 16-Jan-21 2432875 Urban Northeast Fire Resist Apartment N N
100252 OH 16-Jan-21 1529600 Urban Central Masonry Apartment N N
100279 NY 17-Jan-21 7677000 Urban East Frame Apartment Y Y
100292 NY 18-Jan-21 13750000 Urban East Frame Apartment Y Y
100398 NY 18-Jan-21 2529400 Rural East Frame Farming N N
100382 NJ 18-Jan-21 2328650 Urban East Frame Organization N N
100461 WI 19-Jan-21 4380200 Urban Midwest Masonry Office Bldg Y Y
100263 NJ 20-Jan-21 2815000 Urban East Metal Clad Apartment Y Y
100453 NY 22-Jan-21 1177700 Urban East Frame Hospitality N N
100381 VT 22-Jan-21 7203500 Urban Northeast Frame Office Bldg Y Y
100275 WI 23-Jan-21 53410614 Urban Midwest Frame Construction Y Y
100277 NJ 25-Jan-21 3189300 Urban East Masonry Service Y Y
100312 IL 25-Jan-21 3145700 Rural Midwest Frame Education N N
100327 WI 25-Jan-21 1451100 Urban Midwest Frame Recreation N N
100326 OH 25-Jan-21 1787900 Urban Central Frame Office Bldg N N
100379 NY 26-Jan-21 18777355 Urban East Frame Apartment Y Y
100310 WI 26-Jan-21 8800000 Urban Midwest Fire Resist Office Bldg Y Y
100341 NY 28-Jan-21 1123000 Urban East Frame Office Bldg Y Y
100289 NY 28-Jan-21 2145420 Rural East Frame Farming N N
100290 NY 29-Jan-21 18933000 Urban East Frame Office Bldg Y Y
100291 NY 29-Jan-21 21400000 Urban East Fire Resist Apartment Y Y
100340 NY 29-Jan-21 3754000 Urban East Frame Office Bldg Y Y
100415 NY 30-Jan-21 9650000 Urban East Frame Office Bldg Y Y
100421 NY 31-Jan-21 9503000 Urban East Frame Office Bldg Y Y
100304 NJ 31-Jan-21 1688300 Urban East Frame Hospitality N Y
100414 WI 1-Feb-21 17856705 Urban Midwest Masonry Apartment Y Y
100420 NY 2-Feb-21 7577000 Urban East Frame Apartment Y Y
100481 WI 2-Feb-21 1990915 Urban Midwest Masonry Office Bldg N N
100352 NJ 2-Feb-21 1245000 Urban East Frame Hospitality Y Y
100496 IL 3-Feb-21 1895000 Urban Midwest Masonry Office Bldg N N
100309 WI 4-Feb-21 5000368 Urban Midwest Masonry Manufacturing N N
100413 NY 5-Feb-21 8397700 Urban East Frame Apartment Y Y
100498 NJ 5-Feb-21 36356000 Urban East Fire Resist Apartment Y Y
100499 NJ 6-Feb-21 16932600 Urban East Fire Resist Apartment Y Y
100509 OH 7-Feb-21 1849000 Urban Central Metal Clad Retail N N
100371 OH 7-Feb-21 218490 Urban Central Frame Apartment N N
100412 NJ 8-Feb-21 3052600 Urban East Frame Apartment Y N
100370 WI 8-Feb-21 8126500 Urban Midwest Masonry Organization Y Y
100377 NY 9-Feb-21 11400000 Urban East Masonry Apartment Y Y
100452 NJ 9-Feb-21 5918400 Urban East Frame Farming Y N
100459 NY 9-Feb-21 2550750 Rural East Frame Farming N N
100325 NY 9-Feb-21 140000 Urban East Masonry Retail N N
100419 NY 13-Feb-21 725000 Urban East Masonry Service N N
100512 NY 13-Feb-21 10098900 Urban East Frame Office Bldg Y Y
100513 NY 13-Feb-21 2937200 Rural East Frame Farming N N
100514 NJ 13-Feb-21 3644800 Urban East Frame Apartment Y Y
100471 NY 13-Feb-21 13882500 Urban East Frame Apartment Y Y
100396 NY 15-Feb-21 2050000 Rural East Frame Farming N N
100436 NY 16-Feb-21 3805200 Rural East Metal Clad Farming N N
100492 NY 17-Feb-21 1417800 Rural East Frame Organization N N
100494 WI 18-Feb-21 5613900 Rural Midwest Masonry Farming N N
100493 NJ 18-Feb-21 2471100 Urban East Frame Farming N N
100351 VT 19-Feb-21 2985950 Rural Northeast Frame Farming N N
100411 WI 20-Feb-21 9062700 Urban Midwest Fire Resist Hospitality N N
100469 NY 20-Feb-21 7350000 Urban East Frame Apartment Y Y
100418 NJ 21-Feb-21 1300900 Urban East Masonry Office Bldg N N
100511 NY 22-Feb-21 12750000 Urban East Frame Apartment Y Y
100536 NY 22-Feb-21 7585000 Urban East Fire Resist Office Bldg Y Y
100537 NY 22-Feb-21 9493313 Urban East Masonry Apartment Y Y
100394 NY 22-Feb-21 10302000 Urban East Fire Resist Office Bldg Y Y
100367 NH 23-Feb-21 2500000 Urban Northeast Metal Clad Manufacturing N N
100408 WI 24-Feb-21 4833900 Urban Midwest Masonry Office Bldg N N
100410 NY 24-Feb-21 2029500 Urban East Metal Clad Apartment Y Y
100369 NY 24-Feb-21 2233200 Rural East Frame Farming N N
100409 NY 25-Feb-21 2001250 Urban East Frame Office Bldg Y Y
100546 NY 25-Feb-21 1498850 Rural East Metal Clad Farming N N
100434 NJ 27-Feb-21 405556 Urban East Frame Apartment Y N
100523 NY 1-Mar-21 1311220 Urban East Frame Apartment N N
100433 NY 1-Mar-21 1769785 Urban East Frame Hospitality Y Y
100566 OH 2-Mar-21 5377000 Urban Central Frame Apartment Y Y
100522 NY 2-Mar-21 1599860 Rural East Frame Farming N N
100457 NY 5-Mar-21 10780450 Urban East Frame Apartment Y Y
100521 NJ 6-Mar-21 3839200 Urban East Masonry Apartment N N
100532 NJ 6-Mar-21 296000 Urban East Frame Apartment N N
100533 WI 7-Mar-21 2707630 Rural Midwest Frame Farming N N
100467 NJ 7-Mar-21 2249500 Urban East Frame Farming N N
100583 NY 8-Mar-21 7611000 Urban East Masonry Office Bldg Y Y
100404 WI 8-Mar-21 1152600 Rural Midwest Frame Farming N N
100554 NJ 9-Mar-21 9115500 Urban East Frame Apartment Y Y
100446 NY 9-Mar-21 1600000 Urban East Masonry Hospitality Y Y
100465 NJ 11-Mar-21 2575965 Urban East Frame Farming Y N
100490 NY 12-Mar-21 220000 Urban East Metal Clad Hospitality N N
100456 NY 12-Mar-21 1800000 Urban East Frame Apartment Y Y
100489 NJ 14-Mar-21 16998000 Urban East Frame Office Bldg Y Y
100545 NY 14-Mar-21 14450000 Urban East Frame Office Bldg Y Y
100543 NY 14-Mar-21 2835800 Urban East Metal Clad Manufacturing N N
100564 WI 15-Mar-21 2280000 Urban Midwest Frame Hospitality Y Y
100430 NJ 15-Mar-21 3960000 Urban East Frame Office Bldg Y Y
100477 VT 17-Mar-21 5272975 Urban Northeast Frame Apartment Y Y
100478 VT 17-Mar-21 6354220 Urban Northeast Frame Apartment Y Y
100444 NY 17-Mar-21 8892200 Urban East Masonry Apartment Y Y
100582 NJ 21-Mar-21 4651680 Urban East Frame Apartment Y Y
100487 NY 22-Mar-21 5990067 Urban East Frame Apartment N N
100519 NY 23-Mar-21 4102500 Rural East Frame Farming N N
100462 NY 25-Mar-21 3400000 Urban East Frame Construction Y Y
100486 NY 26-Mar-21 9973900 Urban East Frame Apartment Y Y
100463 NY 26-Mar-21 15480000 Urban East Frame Office Bldg Y Y
100595 NY 27-Mar-21 2446600 Rural East Frame Farming N N
100617 VT 27-Mar-21 8861500 Urban Northeast Frame Office Bldg N N
100580 NH 27-Mar-21 97920 Urban Northeast Frame Office Bldg Y Y
100581 NY 30-Mar-21 5150000 Urban East Frame Apartment Y Y
100475 WI 30-Mar-21 1451662 Rural Midwest Masonry Farming N N
100503 NJ 31-Mar-21 1761960 Urban East Masonry Office Bldg N N
100504 NY 31-Mar-21 1649105 Rural East Frame Farming N N
100616 NY 31-Mar-21 2329500 Urban East Frame Apartment N N
100614 NY 31-Mar-21 721500 Urban East Frame Apartment Y Y
100529 NJ 3-Apr-21 2455000 Urban East Frame Apartment Y Y
100551 NJ 5-Apr-21 3363463 Urban East Frame Farming Y N
100501 WI 6-Apr-21 1568100 Rural Midwest Frame Farming N N
100516 WI 7-Apr-21 2063960 Urban Midwest Masonry Organization N N
100542 VT 7-Apr-21 1806500 Urban Northeast Frame Apartment N Y
100625 NY 7-Apr-21 49837500 Urban East Fire Resist Apartment Y Y
100540 NY 7-Apr-21 2244800 Rural East Frame Farming N N
100663 NJ 9-Apr-21 10346950 Urban East Frame Office Bldg N Y
100539 NJ 10-Apr-21 8150000 Urban East Frame Apartment N Y
100642 NY 11-Apr-21 1697200 Urban East Frame Other N N
100549 VT 11-Apr-21 3334353 Urban Northeast Metal Clad Farming Y Y
100680 WI 15-Apr-21 6020060 Rural Midwest Masonry Farming N N
100560 NY 15-Apr-21 1381370 Urban East Frame Organization N N
100629 NY 16-Apr-21 2442400 Urban East Frame Retail N N InsuredValue
100631 NJ 16-Apr-21 4193603 Urban East Frame Farming Y N 60000000
100572 WI 16-Apr-21 3725520 Rural Midwest Masonry Farming N N
100630 NY 7394300 Urban East Frame Apartment Y Y 50000000
17-Apr-21
100637 NY 17-Apr-21 2402500 Urban East Frame Apartment Y Y 40000000
100659 NJ 17-Apr-21 1693000 Urban East Frame Farming Y N
30000000
100527 NJ 17-Apr-21 9148076 Urban East Frame Manufacturing Y Y
100638 NJ 18-Apr-21 3950000 Urban East Frame Apartment Y Y 20000000
100679 NJ 18-Apr-21 14183900 Urban East Frame Apartment Y Y
10000000
100678 WI 18-Apr-21 35245000 Urban Midwest Masonry Apartment Y Y
100570 WI 21-Apr-21 294700 Urban Midwest Masonry Office Bldg N N 0

100578 OH 4488000 Urban Central Frame Apartment N N 21 21 21 21 21 21 21 2

22-Apr-21
a n- an- eb- ar- pr- ay- un- Jul-
J J A J -
100611 NJ 25-Apr-21 1595500 Urban East Frame Office Bldg Y Y 2- 29- 25-F 4-M 20- 7-M 13- 10 6-A
2 1
100621 MI 25-Apr-21 394220 Urban Central Frame Retail N N
100622 WI 25-Apr-21 723900 Urban Midwest Fire Resist Office Bldg Y Y
100623 NY 25-Apr-21 2006700 Rural East Frame Farming N N
100604 WI 25-Apr-21 979572 Urban Midwest Frame Retail N N
100610 NY 26-Apr-21 5086300 Urban East Frame Office Bldg Y Y
100591 NY 27-Apr-21 4353100 Rural East Frame Farming N N
100557 NY 29-Apr-21 2056700 Urban East Frame Other Y Y
100636 IL 30-Apr-21 4886675 Urban Midwest Masonry Apartment N N
100628 NY 30-Apr-21 1973200 Rural East Frame Farming N N
100650 NY 1-May-21 4156000 Urban East Masonry Hospitality Y Y
100651 NJ 2-May-21 1045000 Urban East Frame Apartment Y N
100569 NY 2-May-21 800000 Urban East Frame Construction N N
100609 NJ 3-May-21 4483000 Urban East Frame Office Bldg Y Y
100649 NY 3-May-21 3074775 Rural East Frame Farming N N
100656 MN 4-May-21 1834200 Urban Midwest Frame Hospitality Y Y
100677 NY 6-May-21 13370000 Urban East Frame Apartment Y Y
100704 NJ 6-May-21 14474600 Urban East Fire Resist Apartment Y Y
100713 WI 6-May-21 2103390 Rural Midwest Masonry Farming N N
100584 WI 6-May-21 7750100 Urban Midwest Masonry Other N N
100674 NY 7-May-21 9250000 Urban East Frame Office Bldg Y Y
100589 WI 7-May-21 2867650 Rural Midwest Frame Farming N N
100590 WI 8-May-21 2798650 Rural Midwest Masonry Farming N N
100675 NY 8-May-21 2468300 Urban East Frame Apartment Y Y
100648 NY 8-May-21 270000 Urban East Masonry Retail N N
100683 NJ 9-May-21 1374100 Urban East Masonry Office Bldg Y Y
100647 WI 9-May-21 4077100 Urban Midwest Masonry Apartment Y Y
100602 NY 10-May-21 1651300 Rural East Frame Farming N N
100672 VT 11-May-21 2785000 Urban Northeast Frame Organization N N
100600 WI 11-May-21 3086048 Urban Midwest Frame Hospitality Y Y
100655 NY 12-May-21 1974300 Urban East Masonry Organization Y Y
100671 NY 12-May-21 3660780 Rural East Frame Farming N N
100646 NY 12-May-21 2550000 Urban East Frame Apartment Y Y
100618 NY 13-May-21 2730000 Urban East Metal Clad Hospitality Y Y
100681 NY 14-May-21 963100 Urban East Metal Clad Apartment Y Y
100619 NY 14-May-21 1419500 Rural East Frame Farming N N
100627 NY 15-May-21 2758482 Urban East Fire Resist Apartment Y Y
100670 OH 16-May-21 661900 Urban Central Frame Apartment N N
100689 NY 16-May-21 19451600 Urban East Frame Office Bldg Y Y
100726 NY 16-May-21 1292345 Urban East Frame Office Bldg N N
100702 VT 16-May-21 9702682 Urban Northeast Frame Apartment N N
100703 NJ 17-May-21 10198700 Urban East Fire Resist Office Bldg Y Y
100635 MI 17-May-21 714000 Urban Central Frame Apartment N N
100736 VT 18-May-21 2099525 Rural Northeast Frame Farming N N
100737 NJ 18-May-21 16200000 Urban East Frame Office Bldg Y Y
100644 NY 18-May-21 2570600 Urban East Masonry Office Bldg Y Y
100643 NY 19-May-21 1280000 Urban East Fire Resist Hospitality Y Y
100698 NY 20-May-21 205000 Urban East Fire Resist Retail N N
100652 OH 20-May-21 1760800 Urban Central Frame Apartment N N
100653 NJ 21-May-21 2812559 Urban East Frame Farming N N
100705 NY 21-May-21 3943000 Rural East Frame Farming N N
100718 NY 21-May-21 3107790 Urban East Masonry Office Bldg N Y
100744 NY 21-May-21 9448200 Urban East Frame Apartment Y Y
100709 MI 21-May-21 10617800 Rural Central Frame Manufacturing Y Y
100749 NY 22-May-21 847300 Urban East Frame Apartment Y Y
100751 NJ 22-May-21 400000 Urban East Masonry Office Bldg N Y
100752 NY 22-May-21 363200 Urban East Frame Office Bldg N Y
100696 IL 22-May-21 2922600 Urban Midwest Masonry Apartment Y Y
100742 WI 23-May-21 500500 Urban Midwest Masonry Apartment Y Y
100666 NY 23-May-21 1927450 Rural East Frame Farming N N
100667 NY 24-May-21 2660299 Rural East Frame Farming N N
100740 WI 25-May-21 3980100 Urban Midwest Masonry Apartment N N
100757 WI 25-May-21 2987000 Urban Midwest Masonry Apartment Y Y
100750 VT 25-May-21 16429900 Urban Northeast Frame Apartment Y Y
100756 NY 27-May-21 16950000 Urban East Frame Apartment Y Y
100754 NY 27-May-21 36909180 Urban East Metal Clad Manufacturing Y Y
100764 NY 29-May-21 9600000 Urban East Frame Office Bldg Y N
100724 NY 29-May-21 22050000 Urban East Frame Office Bldg Y Y
100686 NY 30-May-21 3850000 Urban East Frame Construction N Y
100761 VT 1-Jun-21 13514081 Urban Northeast Frame Recreation Y Y
100695 NY 2-Jun-21 2000000 Urban East Frame Hospitality Y Y
100727 WI 3-Jun-21 1658765 Rural Midwest Masonry Farming N N
100777 OH 3-Jun-21 8272853 Urban Central Masonry Apartment N N
100774 NY 3-Jun-21 6750000 Urban East Frame Apartment Y Y
100720 IL 4-Jun-21 7828000 Urban Midwest Masonry Office Bldg N Y
100723 NJ 5-Jun-21 373500 Urban East Frame Office Bldg N N
100759 NY 5-Jun-21 17050000 Urban East Frame Office Bldg Y Y
100722 NY 5-Jun-21 1958400 Rural East Frame Farming N N
100731 NY 6-Jun-21 17746832 Urban East Masonry Apartment Y Y
100755 WI 6-Jun-21 6040300 Urban Midwest Masonry Apartment Y N
100745 WI 6-Jun-21 2224219 Rural Midwest Frame Farming N N
100746 NY 7-Jun-21 847300 Urban East Frame Office Bldg Y Y
100747 WI 7-Jun-21 782428 Urban Midwest Masonry Apartment N N
100780 NJ 7-Jun-21 299400 Urban East Frame Office Bldg Y N
100760 WI 8-Jun-21 1397100 Urban Midwest Masonry Office Bldg Y Y
100781 NY 9-Jun-21 1714835 Urban East Frame Apartment N N
100783 MI 9-Jun-21 1991600 Urban Central Frame Organization N N
100768 WI 9-Jun-21 3701573 Urban Midwest Frame Farming N N
100769 NJ 10-Jun-21 5460000 Urban East Frame Apartment Y Y
100775 NY 10-Jun-21 3136600 Rural East Frame Farming N N
100773 NY 10-Jun-21 1780000 Urban East Frame Hospitality Y Y
100789 NY 11-Jun-21 230000 Urban East Frame Manufacturing Y Y
100790 NJ 26-Aug-21 1463800 Urban East Frame Farming Y N
100792 VT 26-Aug-21 3579800 Rural Northeast Metal Clad Farming N N
100793 NY 26-Aug-21 1275600 Urban East Frame Apartment N Y
100797 NY 27-Aug-21 5781710 Rural East Frame Farming N N
100799 NH 29-Aug-21 320000 Urban Northeast Masonry Retail N N
100800 NY 30-Aug-21 1379400 Urban East Frame Apartment N N
100801 WI 30-Aug-21 6385452 Rural Midwest Frame Farming Y N
100803 WI 31-Aug-21 4671000 Urban Midwest Masonry Apartment Y Y
100805 NY 31-Aug-21 199000 Rural East Frame Retail N N
100808 WI 1-Sep-21 2100000 Urban Midwest Frame Apartment N N
100810 NY 2-Sep-21 1875000 Urban East Masonry Hospitality Y Y
100811 WI 2-Sep-21 2201500 Rural Midwest Frame Farming N N
100813 NY 2-Sep-21 1986100 Urban East Frame Apartment N N
100814 WI 2-Sep-21 105000 Urban Midwest Masonry Other N N
100817 NJ 2-Sep-21 3700000 Urban East Masonry Office Bldg Y Y
100818 IL 3-Sep-21 29128000 Urban Midwest Fire Resist Apartment Y Y
100819 VT 3-Sep-21 10700000 Urban Northeast Frame Hospitality Y Y
100821 WI 5-Sep-21 1778600 Rural Midwest Frame Farming N N
100822 NY 5-Sep-21 3866420 Rural East Frame Farming N N
100823 NY 6-Sep-21 1037500 Urban East Frame Manufacturing N N
100824 NY 6-Sep-21 2480800 Rural East Frame Farming N N
100825 WI 7-Sep-21 578400 Urban Midwest Masonry Office Bldg N N
100826 NY 7-Sep-21 3178400 Urban East Frame Office Bldg Y Y
100828 ME 7-Sep-21 7150000 Urban Northeast Masonry Apartment Y Y
100831 NJ 9-Sep-21 1604800 Urban East Frame Hospitality Y Y
100832 NY 10-Sep-21 18275350 Urban East Frame Office Bldg Y Y
100834 NY 10-Sep-21 710400 Urban East Masonry Office Bldg N N
100836 WI 11-Sep-21 2205950 Urban Midwest Masonry Apartment N N
100837 WI 11-Sep-21 8166050 Urban Midwest Fire Resist Apartment N Y
100838 WI 11-Sep-21 3222081 Urban Midwest Masonry Farming N N
100839 NJ 11-Sep-21 371600 Urban East Frame Hospitality Y N
100844 WI 13-Sep-21 1365000 Urban Midwest Masonry Hospitality Y Y
100845 NY 15-Sep-21 24000000 Urban East Frame Apartment Y Y
100846 NY 15-Sep-21 7700000 Urban East Fire Resist Construction Y Y
100850 IL 15-Sep-21 4578800 Urban Midwest Frame Farming N N
100854 VT 16-Sep-21 2477200 Rural Northeast Frame Farming N N
100856 NJ 21-Sep-21 3432600 Urban East Frame Office Bldg Y Y
100857 IL 22-Sep-21 172100 Rural Midwest Frame Farming N N
100859 NY 23-Sep-21 11147050 Urban East Fire Resist Apartment Y Y
100861 NY 23-Sep-21 2007000 Urban East Frame Office Bldg Y Y
100863 NY 23-Sep-21 9404500 Urban East Frame Apartment Y Y
100864 NY 24-Sep-21 5056900 Urban East Fire Resist Apartment Y Y
100868 WI 24-Sep-21 4577032 Urban Midwest Frame Farming N N
100869 NY 26-Sep-21 953100 Urban East Metal Clad Office Bldg N N
100870 NY 26-Sep-21 2562500 Rural East Fire Resist Manufacturing N N
100872 NY 27-Sep-21 6908000 Urban East Frame Office Bldg Y Y
100873 VT 28-Sep-21 1588100 Urban Northeast Masonry Recreation N N
100874 NY 29-Sep-21 311200 Urban East Frame Apartment N N
100875 NY 30-Sep-21 14850000 Urban East Frame Office Bldg Y Y
100876 NY 1-Oct-21 1557500 Urban East Frame Office Bldg N Y
100878 NY 1-Oct-21 4267000 Urban East Frame Office Bldg Y Y
100882 IL 1-Oct-21 1702350 Urban Midwest Frame Apartment N N
100883 NY 3-Oct-21 280600 Urban East Frame Office Bldg N N
100885 WI 4-Oct-21 2025100 Urban Midwest Masonry Office Bldg N N
100886 NY 4-Oct-21 6748000 Urban East Frame Apartment Y Y
100887 WI 4-Oct-21 2067500 Urban Midwest Fire Resist Service Y Y
100889 NY 5-Oct-21 3235700 Urban East Frame Apartment Y Y
100894 NY 5-Oct-21 2356100 Urban East Frame Hospitality Y Y
100895 NY 7-Oct-21 7932500 Urban East Frame Apartment Y Y
100898 NY 7-Oct-21 1851125 Urban East Frame Office Bldg N N
100900 NY 10-Oct-21 8345500 Urban East Frame Apartment Y Y
100901 NY 11-Oct-21 2400000 Urban East Frame Construction Y Y
100903 WI 11-Oct-21 1675000 Urban Midwest Frame Hospitality Y Y
100904 NH 12-Oct-21 145680 Urban Northeast Frame Office Bldg N N
100908 NY 13-Oct-21 13900000 Urban East Frame Office Bldg Y Y
100909 NY 14-Oct-21 13575000 Urban East Frame Office Bldg Y Y
100910 NY 14-Oct-21 5950500 Urban East Metal Clad Office Bldg Y Y
100912 OH 14-Oct-21 1569440 Urban Central Masonry Organization N N
100215 NY 15-Oct-21 2131900 Urban East Masonry Retail N N
100914 WI 17-Oct-21 631410 Urban Midwest Frame Farming N N
100916 NY 17-Oct-21 1856637 Urban East Masonry Hospitality Y Y
100919 WI 18-Oct-21 2321900 Urban Midwest Frame Manufacturing N N
100920 NJ 20-Oct-21 4726686 Urban East Frame Farming Y N
100228 ME 20-Oct-21 1444255 Urban Northeast Frame Organization N N
100923 NY 21-Oct-21 1830900 Urban East Frame Office Bldg N N
100927 VT 21-Oct-21 1325200 Urban Northeast Frame Organization N N
100928 NY 22-Oct-21 1267625 Urban East Frame Office Bldg N N
100929 NY 22-Oct-21 3409000 Rural East Metal Clad Farming N N
100214 NY 22-Oct-21 33250000 Urban East Frame Apartment Y Y
100932 NJ 23-Oct-21 320100 Urban East Frame Apartment N N
100933 WI 23-Oct-21 275000 Urban Midwest Masonry Apartment N N
100934 WI 23-Oct-21 1519100 Urban Midwest Masonry Apartment N N
100936 IL 24-Oct-21 2182250 Rural Midwest Frame Farming N N
100250 WI 26-Oct-21 4328620 Rural Midwest Frame Farming N N
100939 NJ 27-Oct-21 1840000 Urban East Masonry Apartment N N
100940 NY 27-Oct-21 21250000 Urban East Frame Office Bldg Y Y
100941 NY 28-Oct-21 2534633 Rural East Frame Farming N N
100942 NY 28-Oct-21 2494300 Urban East Frame Apartment Y Y
100943 NY 28-Oct-21 2562500 Urban East Frame Apartment Y Y
100227 WI 28-Oct-21 685000 Urban Midwest Masonry Hospitality Y Y
100945 NY 29-Oct-21 503000 Urban East Masonry Hospitality N Y
100947 NY 29-Oct-21 10259600 Urban East Frame Apartment Y Y
100226 NY 29-Oct-21 3798400 Urban East Metal Clad Office Bldg Y Y
100948 NJ 30-Oct-21 2269865 Urban East Masonry Retail Y Y
100950 NY 30-Oct-21 2363700 Urban East Frame Farming N N
100249 WI 31-Oct-21 1960200 Urban Midwest Masonry Farming N N
100952 IL 1-Nov-21 16833800 Urban Midwest Fire Resist Apartment Y Y
100953 NY 1-Nov-21 4127900 Rural East Metal Clad Farming N N
100955 NJ 1-Nov-21 2753500 Urban East Masonry Office Bldg Y Y
100287 NY 3-Nov-21 10518041 Urban East Frame Office Bldg Y Y
100956 NJ 4-Nov-21 1554500 Urban East Frame Farming N N
100959 NJ 4-Nov-21 1115870 Urban East Frame Farming Y N
100261 NY 5-Nov-21 15625000 Urban East Frame Office Bldg Y Y
100961 IL 6-Nov-21 787500 Urban Midwest Frame Apartment N N
100962 NY 6-Nov-21 15750000 Urban East Masonry Apartment Y Y
100966 OH 7-Nov-21 320000 Urban Central Masonry Retail N N
100969 WI 7-Nov-21 2611400 Rural Midwest Frame Farming N N
100972 NY 9-Nov-21 2398000 Rural East Metal Clad Farming N N
100974 NJ 9-Nov-21 2329942 Urban East Frame Farming Y N
100975 MN 10-Nov-21 1305100 Urban Midwest Frame Apartment Y Y
100977 NY 10-Nov-21 4981500 Rural East Frame Farming N N
100978 NY 10-Nov-21 535000 Urban East Fire Resist Retail N N
100981 NY 10-Nov-21 10397500 Urban East Frame Apartment Y Y
100240 NJ 10-Nov-21 2003000 Urban East Masonry Apartment Y Y
100982 NY 11-Nov-21 10808800 Urban East Frame Office Bldg Y Y
100983 NY 11-Nov-21 1962400 Urban East Frame Apartment N N
100239 NJ 11-Nov-21 2423500 Urban East Frame Apartment Y Y
100985 NY 12-Nov-21 3067800 Rural East Frame Farming N N
100237 OH 12-Nov-21 1202090 Urban Central Frame Organization N N
100238 NJ 13-Nov-21 3062000 Urban East Frame Apartment Y Y
100986 NY 13-Nov-21 2815900 Urban East Metal Clad Manufacturing N N
100987 ME 13-Nov-21 790000 Urban Northeast Masonry Apartment N N
100988 NJ 13-Nov-21 1975000 Urban East Fire Resist Hospitality Y Y
100260 WI 13-Nov-21 2070000 Urban Midwest Masonry Apartment N N
100302 NY 14-Nov-21 847300 Urban East Frame Apartment Y Y
100274 NY 14-Nov-21 2029750 Urban East Frame Apartment N N
100209 NY 15-Nov-21 2636313 Rural East Frame Farming N N
100991 NY 16-Nov-21 2080000 Urban East Masonry Hospitality Y Y
100992 NJ 16-Nov-21 205000 Urban East Fire Resist Retail Y Y
100993 NJ 16-Nov-21 1936200 Urban East Frame Farming N N
100994 WI 16-Nov-21 1403100 Urban Midwest Frame Medical N N
100259 MI 17-Nov-21 315000 Urban Central Frame Apartment N N
100273 NY 18-Nov-21 2000000 Urban East Masonry Apartment Y Y
100996 NY 19-Nov-21 9900000 Urban East Frame Apartment Y Y
100998 MI 19-Nov-21 3255300 Urban Central Frame Hospitality N N
100999 NY 19-Nov-21 4477175 Rural East Frame Farming Y N
101000 NY 19-Nov-21 2395000 Urban East Frame Hospitality N Y
100257 NY 19-Nov-21 5550000 Urban East Fire Resist Apartment Y Y
100258 NY 20-Nov-21 1922800 Urban East Metal Clad Office Bldg Y Y
101003 NJ 21-Nov-21 3028850 Urban East Frame Farming Y N
101005 NY 21-Nov-21 10811785 Rural East Metal Clad Retail N N
100208 NY 21-Nov-21 30000 Urban East Fire Resist Service Y Y
101008 NY 22-Nov-21 15700000 Urban East Frame Office Bldg Y Y
101009 WI 22-Nov-21 5503255 Urban Midwest Masonry Office Bldg N N
100307 WI 22-Nov-21 5015000 Urban Midwest Masonry Manufacturing N N
101011 MI 23-Nov-21 601000 Urban Central Frame Other N N
101012 NJ 23-Nov-21 1563500 Urban East Frame Retail Y Y
100271 NY 24-Nov-21 10979275 Rural East Frame Farming N N
100301 NY 25-Nov-21 6198000 Urban East Frame Office Bldg Y Y
101016 WI 25-Nov-21 504000 Urban Midwest Frame Apartment N N
101019 WI 25-Nov-21 2211300 Urban Midwest Masonry Service Y Y
100336 VT 26-Nov-21 6000902 Rural Northeast Frame Farming Y Y
101023 NY 27-Nov-21 660473 Urban East Frame Apartment N N
101024 NJ 27-Nov-21 4978985 Urban East Frame Farming Y N
100206 NY 27-Nov-21 5213100 Urban East Frame Apartment Y Y
100286 NY 28-Nov-21 2336132 Rural East Metal Clad Farming N N
100324 NJ 28-Nov-21 6253000 Urban East Frame Apartment Y Y
100334 NY 28-Nov-21 1500000 Urban East Fire Resist Hospitality Y Y
100335 WI 28-Nov-21 2984500 Rural Midwest Metal Clad Farming N N
101025 WI 28-Nov-21 2502600 Urban Midwest Masonry Apartment Y Y
101029 NY 28-Nov-21 8115500 Urban East Fire Resist Apartment Y Y
101031 NY 28-Nov-21 2162291 Rural East Frame Farming N N
100205 WI 29-Nov-21 4064995 Rural Midwest Masonry Farming N N
100222 NY 30-Nov-21 3295800 Rural East Frame Farming N N
101034 NY 30-Nov-21 9710700 Urban East Frame Apartment Y Y
100221 NY 30-Nov-21 2350000 Urban East Masonry Apartment Y Y
100246 NJ 1-Dec-21 1807440 Urban East Frame Organization Y Y
100298 WI 1-Dec-21 3175400 Urban Midwest Masonry Office Bldg Y Y
101035 WI 1-Dec-21 3741300 Urban Midwest Fire Resist Apartment Y Y
100333 NY 1-Dec-21 2806200 Rural East Frame Farming N N
101036 VT 2-Dec-21 6169400 Urban Northeast Frame Apartment Y Y
101037 NY 2-Dec-21 2325718 Urban East Metal Clad Manufacturing N N
101039 NY 2-Dec-21 245000 Urban East Frame Service N N
101042 WI 3-Dec-21 4201800 Urban Midwest Frame Farming N N
101043 WI 3-Dec-21 2820265 Rural Midwest Frame Farming N N
101044 NY 4-Dec-21 12220000 Urban East Frame Office Bldg Y Y
100219 NY 4-Dec-21 1144300 Urban East Frame Apartment Y Y
100220 NY 5-Dec-21 4530000 Urban East Frame Apartment Y Y
100235 ME 5-Dec-21 552300 Urban Northeast Frame Apartment N N
100300 NY 5-Dec-21 2000300 Urban East Masonry Office Bldg N N
101046 NJ 5-Dec-21 3990000 Urban East Frame Apartment Y Y
100366 NJ 5-Dec-21 5850000 Urban East Frame Apartment Y Y
101052 NJ 7-Dec-21 6250000 Urban East Frame Apartment Y Y
101053 NH 7-Dec-21 1327600 Urban Northeast Frame Apartment N N
101054 NY 7-Dec-21 1510000 Urban East Masonry Hospitality N N
100234 NY 7-Dec-21 3871000 Urban East Frame Apartment Y Y
100269 NY 8-Dec-21 513300 Urban East Frame Apartment N N
100317 NY 9-Dec-21 2943800 Rural East Frame Farming N N
100318 WI 9-Dec-21 3952500 Urban Midwest Masonry Manufacturing Y Y
100319 NY 9-Dec-21 8923000 Urban East Frame Apartment Y Y
101058 WI 9-Dec-21 2900000 Urban Midwest Fire Resist Apartment Y Y
101061 NY 9-Dec-21 6450000 Urban East Frame Office Bldg Y Y
100365 NY 9-Dec-21 4479400 Urban East Frame Apartment N N
100374 WI 10-Dec-21 2030600 Urban Midwest Frame Farming N N
101066 NY 11-Dec-21 2013357 Rural East Frame Farming N N
101067 NY 11-Dec-21 4017155 Rural East Frame Farming N N
101068 NY 11-Dec-21 11650000 Urban East Frame Office Bldg Y Y
100244 NY 11-Dec-21 9250000 Urban East Frame Apartment Y Y
101069 VT 12-Dec-21 2198800 Rural Northeast Frame Farming N N
101070 NY 12-Dec-21 3553009 Rural East Frame Farming N N
101071 WI 12-Dec-21 1063100 Urban Midwest Masonry Apartment Y Y
101073 NY 12-Dec-21 2854500 Urban East Masonry Apartment Y Y
101074 NJ 13-Dec-21 3356200 Urban East Masonry Construction Y Y
100364 NY 13-Dec-21 1882600 Rural East Frame Farming N N
101075 NY 14-Dec-21 2393232 Rural East Frame Farming N N
101076 NY 14-Dec-21 14678200 Urban East Frame Office Bldg Y Y
100218 NY 14-Dec-21 5017360 Rural East Frame Farming N N
101083 NY 17-Dec-21 2625000 Urban East Frame Apartment Y Y
101088 NY 18-Dec-21 285700 Urban East Frame Office Bldg N N
101089 NY 19-Dec-21 275000 Urban East Fire Resist Retail Y N
101090 NY 19-Dec-21 10396250 Urban East Frame Office Bldg Y Y
101091 NY 19-Dec-21 27208210 Urban East Fire Resist Apartment Y Y
101092 WI 19-Dec-21 1740000 Urban Midwest Masonry Office Bldg N N
101093 WI 19-Dec-21 2464755 Rural Midwest Metal Clad Farming N N
100347 NY 19-Dec-21 535000 Urban East Frame Office Bldg N N
101094 NJ 20-Dec-21 2837500 Urban East Frame Manufacturing Y Y
100204 WI 20-Dec-21 1400000 Urban Midwest Masonry Organization N N
100344 WI 21-Dec-21 1711268 Urban Midwest Frame Manufacturing N N
100346 NY 21-Dec-21 1780000 Urban East Masonry Hospitality Y Y
100391 NY 21-Dec-21 10746600 Urban East Frame Apartment Y Y
101096 NY 21-Dec-21 645000 Urban East Fire Resist Retail N N
100203 NY 21-Dec-21 3724339 Rural East Frame Farming N N
100231 NY 22-Dec-21 12493000 Urban East Frame Apartment Y Y
101098 WI 22-Dec-21 539040 Urban Midwest Frame Retail N N
101100 NY 22-Dec-21 2159000 Urban East Frame Retail N N
100202 NJ 22-Dec-21 3750000 Urban East Frame Apartment Y Y
100217 NY 23-Dec-21 100000 Rural East Metal Clad Farming N N
101102 NY 23-Dec-21 1121600 Rural East Metal Clad Farming N N
100305 NY 23-Dec-21 9000000 Urban East Fire Resist Apartment Y Y
101104 NY 24-Dec-21 292200 Urban East Frame Apartment Y Y
101105 NH 24-Dec-21 345000 Urban Northeast Metal Clad Retail N N
100201 NY 24-Dec-21 11575700 Urban East Frame Apartment Y Y
100230 OH 25-Dec-21 608500 Urban Central Frame Apartment N N
100295 NJ 25-Dec-21 5114500 Urban East Frame Office Bldg Y Y
100360 WI 25-Dec-21 4822450 Urban Midwest Masonry Office Bldg Y Y
100361 NY 25-Dec-21 1125600 Urban East Masonry Apartment N N
101107 NY 25-Dec-21 9377600 Urban East Frame Apartment Y Y
101109 NY 25-Dec-21 3920500 Rural East Frame Farming N N
100229 NH 25-Dec-21 626000 Urban Northeast Masonry Office Bldg N N
100282 WI 26-Dec-21 4132600 Rural Midwest Frame Farming N N
101111 NY 26-Dec-21 6235057 Rural East Frame Farming N N
100400 VT 26-Dec-21 1960000 Rural Northeast Frame Farming N N
101113 NY 27-Dec-21 2500000 Rural East Metal Clad Farming N N
101114 IL 27-Dec-21 3883300 Urban Midwest Metal Clad Farming N N
100200 NY 27-Dec-21 1425000 Urban East Masonry Apartment N N
100330 NY 28-Dec-21 1545100 Urban East Frame Office Bldg Y Y
101115 WI 28-Dec-21 1665100 Urban Midwest Frame Apartment N N
101116 NY 28-Dec-21 8245000 Urban East Frame Apartment Y Y
100216 NJ 29-Dec-21 2432600 Urban East Frame Retail Y Y
100389 NY 30-Dec-21 1480000 Urban East Fire Resist Hospitality Y Y
101117 NY 30-Dec-21 9050000 Urban East Frame Apartment Y Y
101120 NY 30-Dec-21 1480755 Rural East Frame Farming N N
101121 VT 30-Dec-21 4101750 Urban Northeast Fire Resist Office Bldg Y Y
101122 OH 31-Dec-21 1739100 Urban Central Frame Apartment N N
101123 NY 31-Dec-21 2250000 Urban East Frame Office Bldg Y Y
101125 NY 31-Dec-21 16482200 Urban East Frame Office Bldg Y Y
101126 WI 31-Dec-21 1776800 Urban Midwest Frame Farming N N
Total Value ($) Code Total Value ($)
7203500 Green 1451100
53410614 White 1787900 Chart Title
3189300 Grey 3145700
3145700 Blue 3189300
1451100 Red 7203500
1787900 Orange 8800000
18777355 Black 18777355
8800000 Yellow 53410614 Total Value ($)

Chart Title
0 10000000 20000000 30000000 40000000 50000000 60000000

Yellow Black Orange Red Blue Grey White Green

Total Value ($)

0 10000000 20000000 30000000 40000000 50000000 60000000

Orange Black White Green Grey Blue Yellow Red

 InsuredValue ($)
60000000

50000000

40000000

30000000

20000000

10000000

0
21 21 21 21 21 21 21 21 21 21 21 21 21 21
a n- an- eb- ar- pr- ay- un- Jul- ug- ep- ep- ct- ov- ec-
J J A J - O
2- 29- 25-F 4-M 20- 7-M 13- 10 6-A 2-S 29-S 26- 2-N 19-D
2 1 2
000000 60000000

Green

00 50000000 60000000

Yellow Red
Policy BusinessType
100314 Apartment
100359 Office Bldg

100315 Apartment NY
100385 Office Bldg
100388 Apartment
100358 Office Bldg
100264 Apartment
100265 Apartment
100357 Office Bldg
100399 Apartment
100329 Apartment
100429 Office Bldg
100441 Service
100442 Hospitality
100372 Apartment
100281 Service
100280 Service
100424 Office Bldg
100425 Office Bldg
100426 Office Bldg
100252 Apartment
100279 Apartment
100292 Apartment
100398 Office Bldg
100382 Apartment
100461 Service
100263 Apartment
100453 Office Bldg
100381 Office Bldg
100275 Construction
100277 Service
100312 Apartment
100327 Apartment
100326 Hospitality
100379 Office Bldg
100310 Manufacturing
100341 Office Bldg
100289 Farming
100290 Office Bldg
100291 Apartment
100340 Office Bldg
100415 Office Bldg
100421 Office Bldg
100304 Hospitality
100414 Apartment
100420 Apartment
100481 Apartment
100352 Manufacturing
100496 Apartment
100309 Manufacturing
100413 Office Bldg
100498 Office Bldg
100499 Farming
100509 Farming
100371 Retail
100412 Apartment
100370 Organization
100377 Manufacturing
100452 Office Bldg
100459 Service
100325 Retail
100419 Farming
100512 Apartment
100513 Apartment
100514 Office Bldg
100471 Hospitality
100396 Organization
100436 Hospitality
100492 Office Bldg
100494 Office Bldg
100493 Office Bldg
100351 Apartment
100411 Office Bldg
100469 Hospitality
100418 Office Bldg
100511 Hospitality
100536 Farming
100537 Farming
100394 Office Bldg
100367 Manufacturing
100408 Farming
100410 Office Bldg
100369 Retail
100409 Office Bldg
100546 Apartment
100434 Hospitality
100523 Office Bldg
100433 Hospitality
100566 Farming
100522 Apartment
100457 Hospitality
100521 Organization
100532 Office Bldg
100533 Office Bldg
100467 Farming
100583 Office Bldg
100404 Farming
100554 Apartment
100446 Hospitality
100465 Office Bldg
100490 Office Bldg
100456 Apartment
100489 Apartment
100545 Apartment
100543 Apartment
100564 Farming
100430 Hospitality
100477 Office Bldg
100478 Apartment
100444 Hospitality
100582 Farming
100487 Farming
100519 Office Bldg
100462 Construction
100486 Farming
100463 Office Bldg
100595 Hospitality
100617 Hospitality
100580 Farming
100581 Farming
100475 Farming
100503 Farming
100504 Farming
100616 Organization
100614 Farming
100529 Apartment
100551 Apartment
100501 Farming
100516 Organization
100542 Apartment
100625 Office Bldg
100540 Office Bldg
100663 Apartment
100539 Apartment
100642 Farming
100549 Farming
100680 Apartment
100560 Farming
100629 Other
100631 Farming
100572 Apartment
100630 Apartment
100637 Apartment
100659 Farming
100527 Office Bldg
100638 Office Bldg
100679 Apartment
100678 Farming
100570 Hospitality
100578 Hospitality
100611 Farming
100621 Farming
100622 Other
100623 Hospitality
100604 Other
100610 Farming
100591 Apartment
100557 Other
100636 Office Bldg
100628 Farming
100650 Office Bldg
100651 Farming
100569 Farming
100609 Hospitality
100649 Farming
100656 Farming
100677 Farming
100704 Farming
100713 Farming
100584 Hospitality
100674 Farming
100589 Apartment
100590 Hospitality
100675 Farming
100648 Farming
100683 Apartment
100647 Apartment
100602 Hospitality
100672 Farming
100600 Hospitality
100655 Hospitality
100671 Farming
100646 Farming
100618 Hospitality
100681 Farming
100619 Farming
100627 Farming
100670 Apartment
100689 Construction
100726 Farming
100702 Farming
100703 Organization
100635 Apartment
100736 Farming
100737 Apartment
100644 Office Bldg
100643 Hospitality
100698 Farming
100652 Apartment
100653 Farming
100705 Farming
100718 Farming
100744 Apartment
100709 Farming
100749 Farming
100751 Apartment
100752 Apartment
100696 Hospitality
100742 Apartment
100666 Farming
100667 Hospitality
100740 Hospitality
100757 Farming
100750 Farming
100756 Apartment
100754 Farming
100764 Office Bldg
100724 Office Bldg
100686 Apartment
100761 Hospitality
100695 Office Bldg
100727 Farming
100777 Office Bldg
100774 Apartment
100720 Farming
100723 Farming
100759 Hospitality
100722 Hospitality
100731 Farming
100755 Apartment
100745 Farming
100746 Hospitality
100747 Farming
100780 Hospitality
100760 Hospitality
100781 Hospitality
100783 Farming
100768 Office Bldg
100769 Hospitality
100775 Farming
100773 Hospitality
100789 Hospitality
100790 Hospitality
100792 Farming
100793 Farming
100797 Farming
100799 Retail
100800 Apartment
100801 Farming
100803 Farming
100805 Apartment
100808 Apartment
100810 Hospitality
100811 Farming
100813 Organization
100814 Office Bldg
100817 Office Bldg
100818 Apartment
100819 Hospitality
100821 Farming
100822 Farming
100823 Manufacturing
100824 Farming
100825 Office Bldg
100826 Farming
100828 Apartment
100831 Apartment
100832 Office Bldg
100834 Office Bldg
100836 Office Bldg
100837 Office Bldg
100838 Farming
100839 Farming
100844 Hospitality
100845 Hospitality
100846 Farming
100850 Farming
100854 Farming
100856 Office Bldg
100857 Farming
100859 Farming
100861 Apartment
100863 Apartment
100864 Office Bldg
100868 Farming
100869 Office Bldg
100870 Manufacturing
100872 Farming
100873 Recreation
100874 Apartment
100875 Apartment
100876 Office Bldg
100878 Office Bldg
100882 Apartment
100883 Hospitality
100885 Farming
100886 Apartment
100887 Hospitality
100889 Apartment
100894 Farming
100895 Farming
100898 Office Bldg
100900 Apartment
100901 Farming
100903 Hospitality
100904 Hospitality
100908 Farming
100909 Farming
100910 Retail
100912 Organization
100215 Retail
100914 Farming
100916 Apartment
100919 Apartment
100920 Office Bldg
100228 Organization
100923 Office Bldg
100927 Hospitality
100928 Office Bldg
100929 Apartment
100214 Apartment
100932 Hospitality
100933 Farming
100934 Office Bldg
100936 Farming
100250 Apartment
100939 Apartment
100940 Office Bldg
100941 Apartment
100942 Apartment
100943 Farming
100227 Hospitality
100945 Hospitality
100947 Apartment
100226 Apartment
100948 Hospitality
100950 Hospitality
100249 Farming
100952 Farming
100953 Apartment
100955 Farming
100287 Apartment
100956 Office Bldg
100959 Apartment
100261 Farming
100961 Apartment
100962 Farming
100966 Apartment
100969 Office Bldg
100972 Farming
100974 Farming
100975 Hospitality
100977 Hospitality
100978 Farming
100981 Farming
100240 Apartment
100982 Hospitality
100983 Farming
100239 Apartment
100985 Hospitality
100237 Organization
100238 Apartment
100986 Office Bldg
100987 Hospitality
100988 Farming
100260 Service
100302 Retail
100274 Apartment
100209 Farming
100991 Farming
100992 Farming
100993 Apartment
100994 Office Bldg
100259 Service
100273 Apartment
100996 Apartment
100998 Farming
100999 Office Bldg
101000 Hospitality
100257 Apartment
100258 Office Bldg
101003 Office Bldg
101005 Office Bldg
100208 Service
101008 Farming
101009 Farming
100307 Manufacturing
101011 Farming
101012 Apartment
100271 Apartment
100301 Apartment
101016 Apartment
101019 Farming
100336 Farming
101023 Office Bldg
101024 Hospitality
100206 Apartment
100286 Farming
100324 Apartment
100334 Apartment
100335 Apartment
101025 Farming
101029 Apartment
101031 Farming
100205 Farming
100222 Apartment
101034 Apartment
100221 Farming
100246 Organization
100298 Apartment
101035 Apartment
100333 Farming
101036 Farming
101037 Farming
101039 Hospitality
101042 Hospitality
101043 Farming
101044 Apartment
100219 Farming
100220 Apartment
100235 Apartment
100300 Apartment
101046 Hospitality
100366 Apartment
101052 Farming
101053 Office Bldg
101054 Hospitality
100234 Apartment
100269 Apartment
100317 Retail
100318 Manufacturing
100319 Apartment
101058 Farming
101061 Apartment
100365 Farming
100374 Farming
101066 Farming
101067 Apartment
101068 Hospitality
100244 Apartment
101069 Farming
101070 Farming
101071 Apartment
101073 Farming
101074 Farming
100364 Retail
101075 Hospitality
101076 Farming
100218 Farming
101083 Farming
101088 Hospitality
101089 Farming
101090 Apartment
101091 Hospitality
101092 Farming
101093 Apartment
100347 Office Bldg
101094 Hospitality
100204 Organization
100344 Farming
100346 Retail
100391 Hospitality
101096 Farming
100203 Farming
100231 Apartment
101098 Farming
101100 Farming
100202 Apartment
100217 Farming
101102 Hospitality
100305 Apartment
101104 Farming
101105 Hospitality
100201 Apartment
100230 Office Bldg
100295 Farming
100360 Retail
100361 Apartment
101107 Farming
101109 Farming
100229 Retail
100282 Farming
101111 Farming
100400 Farming
101113 Hospitality
101114 Hospitality
100200 Apartment
100330 Office Bldg
101115 Hospitality
101116 Hospitality
100216 Retail
100389 Hospitality
101117 Apartment
101120 Farming
101121 Office Bldg
101122 Apartment
101123 Office Bldg
101125 Office Bldg
101126 Farming
?? Create SUMIF formula to add all insured values corresponding to the State "NY"

1490634488
Raw Description Amount Date
04/28 VZEFEWRLSS*APOEEFCC VISE 24300-5922-02434 FL $22.84 $22.84 04/28
05/07 KENJEFEF #3905 FEKJFE FL $27.63 $27.63 05/07
 Description
VZEFEWRLSS*APOEEFCC VISE 24300-5922-02434 FL
KENJEFEF #3905 FEKJFE FL