03_Mar_Save Loss Data_2022.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1	Incident Number	Date	Shift	BN	Station Area	Desription	Original Property Value	Original Contents value	Original Total Value	Original Property Value Loss	Original Contents Value Loss	Original Total Loss	Property Value Saved	Contents Value Saved	Percentage Property Saved	Percentage Content Saved	Original Total Dollar Save	New Property Value	New Contents Value	New Total Value	New Property Value Loss	New Content Loss	New Total Loss	New Total Save	No address found	Not 111	No values / Fire side	Large Value discrepancy	Garage Fire	Vacant

2	IF2200031162	3/1/2022	A Shift	1	33	1APARTW	1019800	509900	1529700	50900	25495	76395	968900	484405	95.01%	95.00%	1453305	1019800	509900	1529700	50900	25495	76395	1453305
3	IF2200040855	3/20/2022	B Shift	1	4	1RESDW	186600	75000	261600	28800	5000	33800	157800	70000	84.57%	93.33%	227800	186600	93300	279900	28800	6220	35020	244880
4	IF2200033808	3/7/2022	C Shift	1	12	1RESDW	1545800	77250	1623050	30000	20000	50000	1515800	57250	98.06%	74.11%	1573050	154500	77250	231750	2998	20000	22998	208752
5	IF2200043021	3/24/2022	C Shift	1	31	1RESDW	112000	56000	168000	15000	500	15500	97000	55500	86.61%	99.11%	152500	112000	56000	168000	15000	500	15500	152500
6	IF2200043046	3/24/2022	C Shift	3	8	1APARTW	1446000	723000	2169000	30000	20000	50000	1416000	703000	97.93%	97.23%	2119000	1446000	723000	2169000	30000	20000	50000	2119000
7	IF2200045219	3/29/2022	B Shift	2	17	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
8	IF2200035201	3/9/2022	C Shift	2	17	1APARTW	384280	384280	768560	115284	19214	134498	268996	365066	70.00%	95.00%	634062	384280	384280	768560	115284	19214	134498	634062
9	IF2200033497	3/6/2022	C Shift	4	2	1RESDW	67800	33900	101700	13560	6780	20340	54240	27120	80.00%	80.00%	81360	67800	33900	101700	13560	6780	20340	81360
10	IF2200041662	3/22/2022	C Shift	3	24	1RESDW	103900	20000	123900	60000	10000	70000	43900	10000	42.25%	50.00%	53900	103900	51950	155850	60000	25975	85975	69875
11	IF2200033259	3/6/2022	B Shift	3	24	1APARTW	636200	0	636200	636200	0	636200	0	0	0.00%	0.00%	0	636200	0	636200	636200	0	636200	0
12	IF2200033338	3/6/2022	B Shift	3	24	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
13	IF2200032376	3/4/2022	A Shift	1	30	1RESDW	155700	3893	159593	7785	1500	9285	147915	2393	95.00%	61.47%	150308	155700	77850	233550	7785	29996	37781	195769
14	IF2200037386	3/14/2022	B Shift	7	18	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
15	IF2200045257	3/29/2022	B Shift	3	10	1DBLRESW	63200	0	63200	3160	0	3160	60040	0	95.00%	0.00%	60040	63200	0	63200	3160	0	3160	60040
16	IF2200042884	3/24/2022	C Shift	3	10	1RESDW	28200	14100	42300	1000	500	1500	27200	13600	96.45%	96.45%	40800	32900	16450	49350	1167	583	1750	47600
17	IF2200037610	3/14/2022	B Shift	3	22	1RESDEW	53600	26800	80400	10720	5360	16080	42880	21440	80.00%	80.00%	64320	53600	26800	80400	10720	5360	16080	64320
18	IF2200038806	3/16/2022	A Shift	3	22	1RESDW	46500	5000	51500	30000	5000	35000	16500	0	35.48%	0.00%	16500	46500	23250	69750	30000	23250	53250	16500
19	IF2200036776	3/13/2022	C Shift	3	20	1RESDW	55900	17950	73850	25000	10000	35000	30900	7950	55.28%	44.29%	38850	55900	27950	83850	25000	15571	40571	43279
20	IF2200043923	3/26/2022	B Shift	5	27	1RESDW	52200	26100	78300	2610	1305	3915	49590	24795	95.00%	95.00%	74385	52200	26100	78300	2610	1305	3915	74385
21	IF2200042463	3/23/2022	B Shift	1	5	1DBLRESW	231800	10000	241800	7000	200	7200	224800	9800	96.98%	98.00%	234600	231800	115900	347700	7000	2318	9318	338382
22	IF2200034323	3/8/2022	A Shift	7	7	1APARTW	241300	0	241300	3000	0	3000	238300	0	98.76%	0.00%	238300	241300	0	241300	3000	0	3000	238300
23	IF2200042632	3/24/2022	B Shift	5	11	1RESDW	127900	0	127900	100000	63950	163950	27900	-63950	21.81%	0.00%	-36050	127900	63950	191850	100000	63950	163950	27900
24	IF2200037763	3/15/2022	B Shift	5	27	1DBLRESW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
25	IF2200041490	3/21/2022	C Shift	5	27	1RESDW	78000	0	78000	60000	0	60000	18000	0	23.08%	0.00%	18000	78000	0	78000	60000	0	60000	18000
26	IF2200043149	3/25/2022	C Shift	5	11	1RESDW	55600	0	55600	35000	0	35000	20600	0	37.05%	0.00%	20600	55600	0	55600	35000	0	35000	20600
27	IF2200045917	3/30/2022	C Shift	5	27	1RESDW	45000	0	45000	5000	0	5000	40000	0	88.89%	0.00%	40000	663000	0	663000	73667	0	73667	589333
28	IF2200045559	3/30/2022	C Shift	3	20	1APARTW	1289400	644700	1934100	128940	32235	161175	1160460	612465	90.00%	95.00%	1772925	1289400	644700	1934100	128940	32235	161175	1772925
29	IF2200038531	3/16/2022	A Shift	3	20	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
30	IF2200044302	3/27/2022	C Shift	7	7	1BUILDHW	0	0	0	5000	2500	7500	-5000	-2500	0.00%	0.00%	-7500	151400	75700	227100	151400	75700	227100	0
31	IF2200032878	3/5/2022	B Shift	7	18	1DBLRESW	35200	17600	52800	18000	9500	27500	17200	8100	48.86%	46.02%	25300	35200	17600	52800	18000	9500	27500	25300
32	IF2200037184	3/14/2022	A Shift	5	29	1BUILDW	56300	50000	106300	56300	50000	106300	0	0	0.00%	0.00%	0	56300	50000	106300	56300	50000	106300	0
33	IF2200043859	3/26/2022	B Shift	5	3	1BUILDW	348100	174050	522150	10000	8000	18000	338100	166050	97.13%	95.40%	504150	348100	174050	522150	10000	8000	18000	504150
34	IF2200034941	3/9/2022	C Shift	5	29	1BUILDW	27500	0	27500	27500	0	27500	0	0	0.00%	0.00%	0	27500	0	27500	27500	0	27500	0
35	IF2200035099	3/9/2022	C Shift	4	44	1RESDW	67700	33850	101550	16925	11847	28772	50775	22003	75.00%	65.00%	72778	67700	33850	101550	16925	11847	28772	72778
36	IF2200033031	3/5/2022	B Shift	4	44	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
37	IF2200038552	3/16/2022	A Shift	4	44	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
38	IF2200032821	3/5/2022	B Shift	4	45	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
39	IF2200046056	3/31/2022	C Shift	3	20	1APARTW	354000	177000	531000	35400	26550	61950	318600	150450	90.00%	85.00%	469050	354000	177000	531000	35400	26550	61950	469050
40	IF2200045709	3/30/2022	C Shift	6	34	1BUILDW	50000	10000	60000	3000	0	3000	47000	10000	94.00%	100.00%	57000	2002900	1001450	3004350	120174	0	120174	2884176
41	IF2200036793	3/13/2022	C Shift	5	29	1BUILDW	100000	0	100000	10000	0	10000	90000	0	90.00%	0.00%	90000	100000	0	100000	10000	0	10000	90000
42	IF2200031128	3/1/2022	A Shift	6	23	1APARTW	43200500	0	43200500	2000	0	2000	43198500	0	100.00%	0.00%	43198500	4320500	0	4320500	200	0	200	4320300
43	IF2200037459	3/14/2022	B Shift	6	23	1APARTW	43200500	0	43200500	3000	0	3000	43197500	0	99.99%	0.00%	43197500	4320500	0	4320500	300	0	300	4320200
44	IF2200034816	3/9/2022	B Shift	6	35	1BUILDW	520900	300000	820900	468810	30000	498810	52090	270000	10.00%	90.00%	322090	520900	260450	781350	468810	26045	494855	286495
45	IF2200035568	3/10/2022	A Shift	6	26	1RESDW	151000	75500	226500	37750	11325	49075	113250	64175	75.00%	85.00%	177425	151000	75500	226500	37750	11325	49075	177425
46	IF2200031492	3/2/2022	B Shift	4	55	1RESDW	180600	30000	210600	55000	10000	65000	125600	20000	69.55%	66.67%	145600	162400	81200	243600	49457	27067	76524	167076
47	IF2200033112	3/5/2022	B Shift	4	55	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
48	IF2200032954	3/5/2022	B Shift	6	53	1RESDW	122900	80000	202900	98320	61450	159770	24580	18550	20.00%	23.19%	43130	122900	61450	184350	98320	47201	145521	38829
49	IF2200046351	3/31/2022	A Shift	1	14	1DBLRESW	70600	35300	105900	56480	1765	58245	14120	33535	20.00%	95.00%	47655		0	0	0	0	0	0
50	IF2200034188	3/7/2022	A Shift	2	28	1RESDW	892500	150000	1042500	450000	100000	550000	442500	50000	49.58%	33.33%	492500	450200	225100	675300	226992	150067	377058	298242
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100