01_Jan_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 Property 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	IF2200001263	1/3/2022	A Shift	6	35	1RESDW	157200	78600	235800	2000	500	2500	155200	78100	98.73%	99.36%	233300		0	0	0	0	0	0
3	IF2200001404	1/3/2022	A Shift	1	14	1APARTW	340000	3000	343000	400	50	450	339600	2950	99.88%	98.33%	342550		0	0	0	0	0	0
4	IF2200001617	1/3/2022	A Shift	7	18	1RESDW	23200	5000	28200	3480	0	3480	19720	5000	85.00%	100.00%	24720	23200	5000	28200	3480	0	3480	24720
5	IF2200001760	1/4/2022	B Shift	3	25	1RESDW	85000	2000	87000	5000	500	5500	80000	1500	94.12%	75.00%	81500	90200	45100	135300	5306	11275	16581	118719
6	IF2200003088	1/6/2022	A Shift	4	2	1APARTW	1000000	75000	1075000	45000	25000	70000	955000	50000	95.50%	66.67%	1005000	2842800	1421400	4264200	127926	473800	601726	3662474
7	IF2200003216	1/6/2022	A Shift	6	35	1RESDW	148300	74150	222450	100000	25000	125000	48300	49150	32.57%	66.28%	97450	148300	74150	222450	100000	25000	125000	97450
8	IF2200003221	1/6/2022	A Shift	5	11	1BUILDW	94700	20000	114700	15000	10000	25000	79700	10000	84.16%	50.00%	89700	94700	47350	142050	15000	23675	38675	103375
9	IF2200004062	1/8/2022	C Shift	7	18	1RESDW	30000	3000	33000	8000	2000	10000	22000	1000	73.33%	33.33%	23000		0	0	0	0	0	0
10	IF2200004247	1/8/2022	C Shift	2	6	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
11	IF2200004347	1/8/2022	C Shift	1	12	1RESDW	180000	90000	270000	120000	50000	170000	60000	40000	33.33%	44.44%	100000	202800	101400	304200	135200	56333	191533	112667
12	IF2200004628	1/9/2022	A Shift	1	33	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
13	IF2200005137	1/10/2022	A Shift	7	18	1RESDW	59000	1200	60200	59000	1200	60200	0	0	0.00%	0.00%	0	59000	29500	88500	59000	29500	88500	0
14	IF2200005469	1/10/2022	B Shift	3	20	1RESDW	60000	30000	90000	20000	5000	25000	40000	25000	66.67%	83.33%	65000	75700	37850	113550	25233	6308	31542	82008
15	IF2200005552	1/10/2022	B Shift	5	11	1RESDW	75000	20000	95000	5000	5000	10000	70000	15000	93.33%	75.00%	85000	96500	48250	144750	6433	12063	18496	126254
16	IF2200005614	1/11/2022	B Shift	5	29	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
17	IF2200007587	1/14/2022	C Shift	1	4	1RESDW	110000	1000	111000	7000	1000	8000	103000	0	93.64%	0.00%	103000	185400	92700	278100	11798	92700	104498	173602
18	IF2200007669	1/14/2022	C Shift	5	11	1RESDW	33900	17000	50900	15000	5000	20000	18900	12000	55.75%	70.59%	30900	33900	16950	50850	15000	4985	19985	30865
19	IF2200007980	1/15/2022	A Shift	7	18	1BUILDW	108900	0	108900	32670	0	32670	76230	0	70.00%	0.00%	76230	108900	0	108900	32670	0	32670	76230
20	IF2200008174	1/15/2022	A Shift	1	4	1RESDW	152700	76350	229050	45810	38175	83985	106890	38175	70.00%	50.00%	145065	152700	76350	229050	45810	38175	83985	145065
21	IF2200008515	1/16/2022	B Shift	5	27	1DBLRESW	66600	33300	99900	6600	1665	8265	60000	31635	90.09%	95.00%	91635	66600	33300	99900	6600	1665	8265	91635
22	IF2200009188	1/17/2022	C Shift	7	19	1RESDW	50000	6000	56000	7000	2000	9000	43000	4000	86.00%	66.67%	47000	75300	37650	112950	10542	12550	23092	89858
23	IF2200009370	1/18/2022	C Shift	4	43	1HOSPW	1522900	761450	2284350	304580	38000	342580	1218320	723450	80.00%	95.01%	1941770	1522900	761450	2284350	304580	38000	342580	1941770
24	IF2200009408	1/18/2022	C Shift	5	29	1DBLRESW	195000	45000	240000	91900	22000	113900	103100	23000	52.87%	51.11%	126100	91900	45950	137850	43311	22464	65775	72075
25	IF2200010096	1/19/2022	B Shift	5	15	1RESDEW	49300	24650	73950	49300	0	49300	0	24650	0.00%	100.00%	24650	49300	24650	73950	49300	0	49300	24650
26	IF2200010549	1/20/2022	C Shift	3	22	1APARTW	305700	152850	458550	20000	2000	22000	285700	150850	93.46%	98.69%	436550	305700	152850	458550	20000	2000	22000	436550
27	IF2200010944	1/20/2022	C Shift	4	44	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
28	IF2200011114	1/21/2022	A Shift	1	33	1BUILDW	400000	65000	465000	250000	65000	315000	150000	0	37.50%	0.00%	150000	175900	87950	263850	109938	87950	197888	65963
29	IF2200011189	1/21/2022	A Shift	5	15	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
30	IF2200011194	1/21/2022	A Shift	6	53	1RESDW	201200	100560	301760	15000	5000	20000	186200	95560	92.54%	95.03%	281760	201200	100600	301800	15000	5002	20002	281798
31	IF2200011624	1/22/2022	A Shift	5	27	1DBLRESW	90300	45150	135450	22575	2257	24832	67725	42893	75.00%	95.00%	110618	90300	45150	135450	22575	2257	24832	110618
32	IF2200011956	1/22/2022	B Shift	3	24	1RESDW	55500	0	55500	19425	0	19425	36075	0	65.00%	0.00%	36075	55500	0	55500	19425	0	19425	36075
33	IF2200011988	1/22/2022	B Shift	6	23	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2200012396	1/23/2022	C Shift	6	53	1RESDW	256100	1218050	1474150	12805	2000	14805	243295	1216050	95.00%	99.84%	1459345	256100	128050	384150	12805	210	13015	371135
35	IF2200012986	1/24/2022	A Shift	3	22	1APARTW	381800	3000	384800	60000	3000	63000	321800	0	84.28%	0.00%	321800	381800	190900	572700	60000	190900	250900	321800
36	IF2200013349	1/25/2022	B Shift	5	29	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
37	IF2200013396	1/25/2022	B Shift	3	22	1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
38	IF2200013481	1/25/2022	B Shift	3	24	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
39	IF2200013552	1/25/2022	B Shift	5	11	1RESDW	33900	0	33900	33900	16950	50850	0	-16950	0.00%	0.00%	-16950	33900	16950	50850	33900	16950	50850	0
40	IF2200013612	1/26/2022	B Shift	5	29	1RESDW	77400	38700	116100	60000	25000	85000	17400	13700	22.48%	35.40%	31100	77400	38700	116100	60000	25000	85000	31100
41	IF2200013657	1/26/2022	B Shift	5	29	1BUILDW	78100	0	78100	19525	0	19525	58575	0	75.00%	0.00%	58575	78100	0	78100	19525	0	19525	58575
42	IF2200014009	1/26/2022	C Shift	5	29	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
43	IF2200014022	1/26/2022	C Shift	1	33	1BUILDW	200000	30000	230000	3000	1000	4000	197000	29000	98.50%	96.67%	226000	822700	411350	1234050	12341	13712	26052	1207998
44	IF2200014163	1/27/2022	C Shift	3	8	1APARTW	52800	26400	79200	20000	8000	28000	32800	18400	62.12%	69.70%	51200	52800	26400	79200	20000	8000	28000	51200
45	IF2200014651	1/27/2022	A Shift	3	20	1RESDW	70000	100	70100	10000	100	10100	60000	0	85.71%	0.00%	60000	52100	26050	78150	7443	26050	33493	44657
46	IF2200015502	1/29/2022	C Shift	4	2	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
47	IF2200015890	1/30/2022	A Shift	3	20	1DBLRESW	89500	5000	94500	30000	2000	32000	59500	3000	66.48%	60.00%	62500	89500	44750	134250	30000	17900	47900	86350
48	IF2200016086	1/30/2022	A Shift	4	42	1TRAILW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
49	IF2200016510	1/31/2022	B Shift	4	43	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
50
51	Totals						$ 6,834,000	$ 3,051,510	$ 9,885,510	$ 1,518,970	$ 364,397	$ 1,883,367	$ 5,315,030				$ 8,002,143	$ 8,593,100	$ 4,168,700	$ 12,761,800	$ 1,440,140	$ 1,244,425	$ 2,684,565	$ 10,077,235
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