11_Save Loss Data_2023 for IFDR.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	IF2300167194	11/3/2023	C Shift	5	27		1BUILDW	64000	32000	96000	5000	500	5500	59000	31500	92.19%	98.44%	90500	64000	32000	96000	5000	500	5500	90500
3	IF2300167278	11/3/2023	A Shift	4	2		1RESDW	848000	424000	1272000	40000	20000	60000	808000	404000	95.28%	95.28%	1212000	84400	42200	126600	3981	1991	5972	120628
4	IF2300167510	11/3/2023	A Shift	4	44		1RESDW	91200	45600	136800	15000	15000	30000	76200	30600	83.55%	67.11%	106800	91200	45600	136800	15000	15000	30000	106800
5	IF2300167969	11/4/2023	B Shift	6	35		1RESDW	188100	94050	282150	65835	47025	112860	122265	47025	65.00%	50.00%	169290	188100	94050	282150	65835	47025	112860	169290
6	IF2300168150	11/4/2023	B Shift	6	53		1RESDW	309600	139400	449000	46440	15480	61920	263160	123920	85.00%	88.90%	387080	309600	154800	464400	46440	17190	63630	400770
7	IF2300168367	11/5/2023	B Shift	3	24		1RESDW	120300		120300			0	120300	0	100.00%	0.00%	120300	120300	60150	180450	0	60150	60150	120300
8	IF2300168939	11/6/2023	C Shift	3	22		1RESDW	76000	0	76000	57000	0	57000	19000	0	25.00%	0.00%	19000	76000	0	76000	57000	0	57000	19000
9	IF2300169210	11/6/2023	A Shift	6	26		1RESDW	290500	145250	435750	230000	100000	330000	60500	45250	20.83%	31.15%	105750	290500	145250	435750	230000	100000	330000	105750
10	IF2300169304	11/6/2023	A Shift	6	23		1APARTW	815000	407500	1222500	200000	30000	230000	615000	377500	75.46%	92.64%	992500	815100	407550	1222650	200025	30004	230028	992622
11	IF2300169458	11/7/2023	A Shift	6	23		1APARTW	815000	407500	1222500	300000	50000	350000	515000	357500	63.19%	87.73%	872500	815100	407550	1222650	300037	50006	350043	872607
12	IF2300169667	11/7/2023	B Shift	3	20		1BUILDW	42500	10000	52500	20000	10000	30000	22500	0	52.94%	0.00%	22500	42500	21250	63750	20000	21250	41250	22500
13	IF2300170214	11/8/2023	C Shift	3	24		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
14	IF2300170649	11/9/2023	C Shift	1	5		1BUILDW	150000	0	150000	5000	0	5000	145000	0	96.67%	0.00%	145000		0	0	0	0	0	0
15	IF2300170977	11/9/2023	A Shift	3	8		1APARTW	88266	44128	132394	17651	8825	26476	70615	35303	80.00%	80.00%	105918	88266	44133	132399	17651	8826	26477	105922
16	IF2300171056	11/9/2023	A Shift	6	52		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
17	IF2300171273	11/10/2023	B Shift	3	8		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
18	IF2300171556	11/10/2023	B Shift	7	19		1RESDW	52900	500	53400	45000	500	45500	7900	0	14.93%	0.00%	7900	52900	500	53400	45000	500	45500	7900
19	IF2300171559	11/10/2023	B Shift	6	35		1BUILDW	679100	345000	1024100	10000	5000	15000	669100	340000	98.53%	98.55%	1009100	689100	344550	1033650	10147	4993	15141	1018509
20	IF2300171722	11/11/2023	C Shift	5	3		1RESDW	112500	57000	169500	5000	2500	7500	107500	54500	95.56%	95.61%	162000	112500	56250	168750	5000	2467	7467	161283
21	IF2300172432	11/12/2023	A Shift	4	43		1RESDW	117000	58500	175500	25000	5000	30000	92000	53500	78.63%	91.45%	145500	117500	58750	176250	25107	5021	30128	146122
22	IF2300172568	11/12/2023	A Shift	5	15		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
23	IF2300172585	11/12/2023	A Shift	3	24		1RESDW	85900	42950	128850	25770	42950	68720	60130	0	70.00%	0.00%	60130	85900	42950	128850	25770	42950	68720	60130
24	IF2300172677	11/13/2023	A Shift	1	31		1RESDW	108600	54300	162900	5430	2715	8145	103170	51585	95.00%	95.00%	154755	105600	52800	158400	5280	2640	7920	150480
25	IF2300172837	11/13/2023	B Shift	5	11		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
26	IF2300172994	11/13/2023	B Shift	4	44		1BUILDW			0			0	0	0	0.00%	0.00%	0	8727000	4363500	13090500	8727000	4363500	13090500	0
27	IF2300173307	11/14/2023	B Shift	5	29		1RESDW	104300	52150	156450	104300	52150	156450	0	0	0.00%	0.00%	0	104300	52150	156450	104300	52150	156450	0
28	IF2300173574	11/14/2023	C Shift	1	14		1APARTHW	827800	0	827800	0	0	0	827800	0	100.00%	0.00%	827800	827800	0	827800	0	0	0	827800
29	IF2300173577	11/14/2023	C Shift	4	45		1RESDEW	126900	63450	190350	101520	50760	152280	25380	12690	20.00%	20.00%	38070	1269000	634500	1903500	1015200	507600	1522800	380700
30	IF2300173786	11/14/2023	C Shift	5	29		1RESDW	74200	0	74200	30000	0	30000	44200	0	59.57%	0.00%	44200	74200	0	74200	30000	0	30000	44200
31	IF2300173988	11/15/2023	A Shift	1	31		1DBLRESW			0			0	0	0	0.00%	0.00%	0	147400	73700	221100	147400	73700	221100	0
32	IF2300174026	11/15/2023	A Shift	7	18		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
33	IF2300174027	11/15/2023	A Shift	5	11		1RESDW	71000	500	71500	10000	500	10500	61000	0	85.92%	0.00%	61000	71100	500	71600	10014	500	10514	61086
34	IF2300174148	11/15/2023	A Shift	7	1		1RESDW	60400	30200	90600	45000	4000	49000	15400	26200	25.50%	86.75%	41600	60400	30200	90600	45000	4000	49000	41600
35	IF2300174281	11/15/2023	A Shift	5	15		1APARTW	76000	38000	114000	34200	10000	44200	41800	28000	55.00%	73.68%	69800	76000	38000	114000	34200	10000	44200	69800
36	IF2300174315	11/15/2023	A Shift	5	27		1RESDW	56700	28350	85050	11340	5670	17010	45360	22680	80.00%	80.00%	68040	56700	28350	85050	11340	5670	17010	68040
37	IF2300174504	11/16/2023	B Shift	5	15		1DBLRESW	76000	38000	114000	0	0	0	76000	38000	100.00%	100.00%	114000	76000	38000	114000	0	0	0	114000
38	IF2300174759	11/16/2023	B Shift	7	18		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
39	IF2300174862	11/16/2023	B Shift	3	20		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
40	IF2300175325	11/17/2023	C Shift	6	35		1BUILDW	1057000	0	1057000	1500	0	1500	1055500	0	99.86%	0.00%	1055500	1002100	501050	1503150	1422	501050	502472	1000678
41	IF2300175449	11/17/2023	C Shift	3	10		1BUILDW			0			0	0	0	0.00%	0.00%	0	461700	230850	692550	461700	230850	692550	0
42	IF2300175504	11/18/2023	C Shift	5	29		1RESDW	210500	106000	316500	75000	25000	100000	135500	81000	64.37%	76.42%	216500	210500	105250	315750	75000	24823	99823	215927
43	IF2300175995	11/18/2023	A Shift	7	19		1RESDW	52400	28450	80850	36985	14225	51210	15415	14225	29.42%	50.00%	29640	52400	26200	78600	36985	13100	50085	28515
44	IF2300176386	11/19/2023	B Shift	3	22		1RESDW			0			0	0	0	0.00%	0.00%	0	51700	25850	77550	51700	25850	77550	0
45	IF2300176614	11/20/2023	B Shift	1	33		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
46	IF2300177086	11/21/2023	C Shift	5	11		1DBLRESW	122400	0	122400	24480	0	24480	97920	0	80.00%	0.00%	97920	122400	0	122400	24480	0	24480	97920
47	IF2300177336	11/21/2023	A Shift	3	10		1RESDW	37400	18700	56100	13090	4675	17765	24310	14025	65.00%	75.00%	38335	37400	18700	56100	13090	4675	17765	38335
48	IF2300177587	11/22/2023	A Shift	7	13		1BUILDW	1032300	516150	1548450	309690	154845	464535	722610	361305	70.00%	70.00%	1083915	1032300	516150	1548450	309690	154845	464535	1083915
49	IF2300177856	11/22/2023	B Shift	5	27		1DBLRESW	235000	117500	352500	20000	10000	30000	215000	107500	91.49%	91.49%	322500	235000	117500	352500	20000	10000	30000	322500
50	IF2300178623	11/24/2023	C Shift	5	3		1RESDW	416000	222500	638500	50000	25000	75000	366000	197500	87.98%	88.76%	563500	416100	208050	624150	50012	23376	73388	550762
51	IF2300179021	11/24/2023	A Shift	5	15		1RESDW	79800	39900	119700	10000	2000	12000	69800	37900	87.47%	94.99%	107700	79800	39900	119700	10000	2000	12000	107700
52	IF2300179686	11/26/2023	B Shift	5	29		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
53	IF2300180692	11/28/2023	A Shift	6	26		1RESDW	204000	102000	306000	25000	15000	40000	179000	87000	87.75%	85.29%	266000	204000	102000	306000	25000	15000	40000	266000
54	IF2300180728	11/28/2023	A Shift	7	1		1RESDW	113100	500	113600	50000	500	50500	63100	0	55.79%	0.00%	63100	113800	500	114300	50309	500	50809	63491
55	IF2300180845	11/28/2023	B Shift	5	15		1BUILDW	165000	5000	170000	2500	500	3000	162500	4500	98.48%	90.00%	167000	165000	5000	170000	2500	500	3000	167000
56	IF2300181258	11/29/2023	B Shift	2	32		1RESDW	218900	109450	328350	30000	10000	40000	188900	99450	86.30%	90.86%	288350	218900	109450	328350	30000	10000	40000	288350
57	IF2300182196	11/30/2023	A Shift	1	4		1APARTW			0			0	0	0	0.00%	0.00%	0	244498	122249	366747	244498	122249	366747	0
58	IF2300182300	11/30/2023	A Shift	4	42		1BUILDW	18500	100000	118500	15000	75000	90000	3500	25000	18.92%	25.00%	28500	18500	100000	118500	15000	75000	90000	28500
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