05_May_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	IF2200072365	5/20/2022	B Shift	6	54	1RESDW			0	0		0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
3	IF2200071099	5/17/2022	C Shift	4	44	1APARTEW	500000	30000	530000	25000	12500	37500	475000	17500	95.00%	58.33%	492500		0	0	0	0	0	0
4	IF2200076060	5/26/2022	C Shift	4	43	1RESDW	147900	73950	221850	7395	3697	11092	140505	70253	95.00%	95.00%	210758	170400	85200	255600	8520	4259	12779	242821
5	IF2200068700	5/13/2022	B Shift	2	32	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
6	IF2200068035	5/12/2022	A Shift	3	22	1APARTW	50000	500	50500	500	500	1000	49500	0	99.00%	0.00%	49500	309500	154750	464250	3095	154750	157845	306405
7	IF2200066084	5/9/2022	C Shift	1	30	1APARTW	900000	10000	910000	90000	8000	98000	810000	2000	90.00%	20.00%	812000	900000	10000	910000	90000	8000	98000	812000
8	IF2200067363	5/11/2022	B Shift	5	29	1RESDW	56100	30000	86100	35000	5000	40000	21100	25000	37.61%	83.33%	46100	56100	28050	84150	35000	4675	39675	44475
9	IF2200073914	5/22/2022	B Shift	5	29	1RESDW	107000	53500	160500	107000	53500	160500	0	0	0.00%	0.00%	0	107000	53500	160500	107000	53500	160500	0
10	IF2200067728	5/11/2022	C Shift	2	28	1RESDW	202000	101000	303000	10100	5050	15150	191900	95950	95.00%	95.00%	287850		0	0	0	0	0	0
11	IF2200073548	5/22/2022	A Shift	5	27	1RESDW	75000	2000	77000	1000	1000	2000	74000	1000	98.67%	50.00%	75000	99900	49950	149850	1332	24975	26307	123543
12	IF2200078304	5/31/2022	A Shift	6	35	1RESDW	146200	73100	219300	15000	5000	20000	131200	68100	89.74%	93.16%	199300	146200	73100	219300	15000	5000	20000	199300
13	IF2200065662	5/8/2022	C Shift	6	35	1BUILDW	200000	30000	230000	150000	30000	180000	50000	0	25.00%	0.00%	50000	72800	36400	109200	54600	36400	91000	18200
14	IF2200068241	5/12/2022	A Shift	6	26	1RESDW	159100	80000	239100	10000	3000	13000	149100	77000	93.71%	96.25%	226100	159100	79550	238650	10000	2983	12983	225667
15	IF2200065300	5/7/2022	B Shift	6	26	1RESDEW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
16	IF2200067209	5/10/2022	B Shift	3	25	1RESDW	250000	5000	255000	500	200	700	249500	4800	99.80%	96.00%	254300	170600	85300	255900	341	3412	3753	252147
17	IF2200075953	5/26/2022	C Shift	3	24	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
18	IF2200063895	5/4/2022	B Shift	3	22	1RESDW	114900	57450	172350	11490	5745	17235	103410	51705	90.00%	90.00%	155115	108600	54300	162900	10860	5430	16290	146610
19	IF2200068509	5/13/2022	A Shift	3	22	1RESDW	49900	20000	69900	25000	5000	30000	24900	15000	49.90%	75.00%	39900	49900	24950	74850	25000	6238	31238	43613
20	IF2200069084	5/14/2022	B Shift	3	20	1RESDW	100000	50000	150000	30000	25000	55000	70000	25000	70.00%	50.00%	95000	65100	32550	97650	19530	16275	35805	61845
21	IF2200064522	5/6/2022	C Shift	3	20	1RESDW	48700	24350	73050	4870	2434	7304	43830	21916	90.00%	90.00%	65746	45400	22700	68100	4540	2269	6809	61291
22	IF2200067435	5/11/2022	C Shift	7	19	1RESDW	30000	0	30000	10000	0	10000	20000	0	66.67%	0.00%	20000	72600	0	72600	24200	0	24200	48400
23	IF2200073058	5/21/2022	A Shift	7	19	1RESDW	49100	24550	73650	4810	2455	7265	44290	22095	90.20%	90.00%	66385	49100	24550	73650	4810	2455	7265	66385
24	IF2200070659	5/16/2022	B Shift	4	42	1RESDW	37000	18500	55500	10000	3000	13000	27000	15500	72.97%	83.78%	42500	37000	18500	55500	10000	3000	13000	42500
25	IF2200066484	5/9/2022	A Shift	1	14	1RESDW	85600	42800	128400	70620	2140	72760	14980	40660	17.50%	95.00%	55640	85600	42800	128400	70620	2140	72760	55640
26	IF2200063514	5/4/2022	A Shift	7	13	1BUILDHW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
27	IF2200073387	5/21/2022	A Shift	7	13	1BUILDHW	3407600	1703800	5111400	170380	85190	255570	3237220	1618610	95.00%	95.00%	4855830	3407600	1703800	5111400	170380	85190	255570	4855830
28	IF2200068458	5/13/2022	A Shift	5	11	1DBLRESW	125000	25000	150000	30000	20000	50000	95000	5000	76.00%	20.00%	100000	90400	45200	135600	21696	36160	57856	77744
29	IF2200067915	5/12/2022	C Shift	5	11	1DBLRESW	55600	30000	85600	20000	1500	21500	35600	28500	64.03%	95.00%	64100		0	0	0	0	0	0
30	IF2200071316	5/18/2022	C Shift	5	27	1DBLRESW	773000	20000	793000	500	500	1000	772500	19500	99.94%	97.50%	792000	77300	38650	115950	50	966	1016	114934
31	IF2200062879	5/2/2022	C Shift	3	10	1RESDW	42900	0	42900	20000	0	20000	22900	0	53.38%	0.00%	22900	42900	0	42900	20000	0	20000	22900
32	IF2200064120	5/5/2022	C Shift	2	9	1BUILDW	2166900	1029278	3196178	1000	0	1000	2165900	1029278	99.95%	100.00%	3195178	2166900	1083450	3250350	1000	0	1000	3249350
33	IF2200073399	5/21/2022	A Shift	2	9	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2200063930	5/4/2022	B Shift	2	9	1BUILDW	200000	300000	500000	200000	100000	300000	0	200000	0.00%	66.67%	200000		0	0	0	0	0	0
35	IF2200065144	5/7/2022	B Shift	3	8	1RESDW	146300	73150	219450	7315	3657	10972	138985	69493	95.00%	95.00%	208478	146300	73150	219450	7315	3657	10972	208478
36	IF2200068122	5/12/2022	A Shift	7	7	1APARTHW	15192300	500000	15692300	400000	200000	600000	14792300	300000	97.37%	60.00%	15092300	1519300	500000	2019300	40002	200000	240002	1779298
37	IF2200077299	5/29/2022	B Shift	7	7	1APARTHW	1247000	5000	1252000	20000	5000	25000	1227000	0	98.40%	0.00%	1227000	1247800	623900	1871700	20013	623900	643913	1227787
38
39
40
41
42
43
44
45
46
47
48
49
50
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