04_Apr_Save Loss Data_2023.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	AE
1	Incident Number	Date	Shift	BN	Station Area	Officer in Charge	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 Contents 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	IF2300054493	4/16/2023	A Shift	1	4		1APARTEW	2576400	1288200	3864600	128820	64410	193230	2447580	1223790	95.00%	95.00%	3671370	2576400	1288200	3864600	128820	64410	193230	3671370
3	IF2300051266	4/10/2023	A Shift	1	5	Olofson	1RESDW	75000	7000	82000	3500	1000	4500	71500	6000	95.33%	85.71%	77500	73500	36750	110250	3430	5250	8680	101570
4	IF2300060874	4/29/2023	A Shift	1	5		1RESDW	99100	45000	144100	74325	44495	118820	24775	505	25.00%	1.12%	25280	99100	49550	148650	74325	48994	123319	25331
5	IF2300059133	4/25/2023	A Shift	3	8		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
6	IF2300057623	4/22/2023	A Shift	3	10		1RESDW	50600	15300	65900	2530	1265	3795	48070	14035	95.00%	91.73%	62105	50600	25300	75900	2530	2092	4622	71278
7	IF2300054645	4/17/2023	A Shift	1	12	Coe	1APARTEW	4000000	500000	4500000	2000000	300000	2300000	2000000	200000	50.00%	40.00%	2200000	1395000	697500	2092500	697500	418500	1116000	976500
8	IF2300051681	4/11/2023	B Shift	1	14		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
9	IF2300053557	4/15/2023	B Shift	1	5		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
10	IF2300046686	4/2/2023	B Shift	5	15		1RESDW	88800	44400	133200	80000	40000	120000	8800	4400	9.91%	9.91%	13200	88800	44400	133200	80000	40000	120000	13200
11	IF2300047971	4/4/2023	A Shift	5	27		1RESDW	10000	0	10000	5000	0	5000	5000	0	50.00%	0.00%	5000	10000	0	10000	5000	0	5000	5000
12	IF2300055229	4/18/2023	C Shift	5	15		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
13	IF2300050246	4/9/2023	B Shift	6	54		1BARNW	250000	150000	400000	250000	150000	400000	0	0	0.00%	0.00%	0	250000	150000	400000	250000	150000	400000	0
14	IF2300058608	4/24/2023	C Shift	6	52		1RESDW	121300	60650	181950	103105	60650	163755	18195	0	15.00%	0.00%	18195	121300	60650	181950	103105	60650	163755	18195
15	IF2300049266	4/7/2023	A Shift	7	18	M. Tennery	1DBLRESEW	141600	10000	151600	41480	5000	46480	100120	5000	70.71%	50.00%	105120	141600	70800	212400	41480	35400	76880	135520
16	IF2300050889	4/10/2023	A Shift	7	18		1RESDW	77000	38500	115500	19250	9625	28875	57750	28875	75.00%	75.00%	86625	77000	38500	115500	19250	9625	28875	86625
17	IF2300059578	4/26/2023	B Shift	7	19		1DBLRESW	167500	80000	247500	30000	80000	110000	137500	0	82.09%	0.00%	137500	167500	83750	251250	30000	83750	113750	137500
18	IF2300052714	4/13/2023	A Shift	3	20		1RESDW	146900	75000	221900	110000	55000	165000	36900	20000	25.12%	26.67%	56900	146900	73450	220350	110000	53863	163863	56487
19	IF2300055126	4/18/2023	B Shift	5	27		1RESDW	77900	0	77900	3895	0	3895	74005	0	95.00%	0.00%	74005	77900	0	77900	3895	0	3895	74005
20	IF2300047682	4/4/2023	A Shift	6	23		1APARTW	471000	0	471000	5000	0	5000	466000	0	98.94%	0.00%	466000	472110	0	472110	5012	0	5012	467098
21	IF2300049050	4/6/2023	C Shift	3	24		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
22	IF2300050939	4/10/2023	A Shift	3	24		1APARTW	108000	60000	168000	40000	53950	93950	68000	6050	62.96%	10.08%	74050	107900	53950	161850	39963	48510	88473	73377
23	IF2300060669	4/28/2023	A Shift	6	26		1APARTW	681061	340530	1021591	5000	1000	6000	676061	339530	99.27%	99.71%	1015591	681061	340530.5	1021591.5	5000	1000	6000	1015591
24	IF2300047202	4/3/2023	C Shift	5	27	Isaacs	1RESDW	119900	10000	129900	50000	10000	60000	69900	0	58.30%	0.00%	69900	119900	59950	179850	50000	59950	109950	69900
25	IF2300053842	4/15/2023	C Shift	5	27		1RESDW	63400	31700	95100	20000	5000	25000	43400	26700	68.45%	84.23%	70100	63400	31700	95100	20000	5000	25000	70100
26	IF2300054507	4/16/2023	A Shift	5	27	Grass	1DBLRESW	150000	0	150000	5000	0	5000	145000	0	96.67%	0.00%	145000	131200	65600	196800	4373	65600	69973	126827
27	IF2300047417	4/3/2023	C Shift	5	29		1RESDW	97100	50000	147100	15000	5000	20000	82100	45000	84.55%	90.00%	127100	97100	48550	145650	15000	4855	19855	125795
28	IF2300053572	4/15/2023	B Shift	5	29		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
29	IF2300055173	4/18/2023	B Shift	5	29		1RESDW	132300	70000	202300	50000	25000	75000	82300	45000	62.21%	64.29%	127300	132300	66150	198450	50000	23625	73625	124825
30	IF2300050922	4/10/2023	A Shift	1	30	Olofson	1RESDW	85000	8000	93000	70000	5000	75000	15000	3000	17.65%	37.50%	18000	64100	32050	96150	52788	20031	72819	23331
31	IF2300061038	4/29/2023	B Shift	1	30		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
32	IF2300050204	4/9/2023	B Shift	2	32		1RESDW	179300	0	179300	53790	0	53790	125510	0	70.00%	0.00%	125510	179300		179300	53790	0	53790	125510
33	IF2300052728	4/13/2023	A Shift	6	35		1RESDW	228200	114100	342300	79870	34230	114100	148330	79870	65.00%	70.00%	228200	228200	114100	342300	79870	34230	114100	228200
34	IF2300047884	4/4/2023	A Shift	4	43		1RESDW	118200	59100	177300	23640	11820	35460	94560	47280	80.00%	80.00%	141840	118200	59100	177300	23640	11820	35460	141840
35	IF2300057850	4/23/2023	A Shift	4	44		1SCHOOLW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
36	IF2300051194	4/10/2023	A Shift	4	45		1APARTW	219715	16000	235715	32000	8000	40000	187715	8000	85.44%	50.00%	195715	219715	16000	235715	32000	8000	40000	195715
37	IF2300053844	4/15/2023	C Shift	4	55		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
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