12_Dec_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	IF2300185576	12/6/2023	A Shift	5	3		1RESDW	135300	67650	202950	3000	500	3500	132300	67150	97.78%	99.26%	199450	135300	67650	202950	3000	500	3500	199450
3	IF2300191967	12/18/2023	A Shift	1	4		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
4	IF2300190546	12/16/2023	A Shift	2	6		1DBLRESW	235000	117500	352500	58750	5875	64625	176250	111625	75.00%	95.00%	287875	235000	117500	352500	58750	5875	64625	287875
5	IF2300197791	12/29/2023	C Shift	2	6		1RESDW	707600	353800	1061400	200000	250000	450000	507600	103800	71.74%	29.34%	611400	707600	353800	1061400	200000	250000	450000	611400
6	IF2300192773	12/20/2023	C Shift	2	9		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
7	IF2300193712	12/22/2023	A Shift	3	10		1RESDW	63000	31500	94500	31500	15750	47250	31500	15750	50.00%	50.00%	47250	63000	31500	94500	31500	15750	47250	47250
8	IF2300196898	12/27/2023	A Shift	5	11		1DBLRESW	148100	0	148100	30000	0	30000	118100	0	79.74%	0.00%	118100	148100	0	148100	30000	0	30000	118100
9	IF2300187670	12/10/2023	B Shift	1	5		1RESDW	155900	0	155900	121500	0	121500	34400	0	22.07%	0.00%	34400	155900	0	155900	121500	0	121500	34400
10	IF2300190484	12/16/2023	A Shift	1	14		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
11	IF2300192600	12/19/2023	B Shift	1	14		1RESDW	79300	5000	84300	20000	500	20500	59300	4500	74.78%	90.00%	63800	79300	5000	84300	20000	500	20500	63800
12	IF2300191093	12/17/2023	B Shift	5	11		1RESDW	55000	5000	60000	15000	0	15000	40000	5000	72.73%	100.00%	45000	55000	5000	60000	15000	0	15000	45000
13	IF2300187318	12/10/2023	B Shift	2	17		1RESDW	282200	141100	423300	150000	80000	230000	132200	61100	46.85%	43.30%	193300	282200	141100	423300	150000	80000	230000	193300
14	IF2300194365	12/23/2023	C Shift	2	17		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
15	IF2300186540	12/8/2023	C Shift	7	18	D Taylor	1RESDW	48200	500	48700	10000	0	10000	38200	500	79.25%	100.00%	38700	48200	24100	72300	10000	0	10000	62300
16	IF2300183577	12/3/2023	C Shift	7	19	D Taylor	1RESDW	43100	10000	53100	20000	500	20500	23100	9500	53.60%	95.00%	32600	43100	21550	64650	20000	1078	21078	43573
17	IF2300183030	12/2/2023	B Shift	3	20		1RESDW	109200	54600	163800	20000	5000	25000	89200	49600	81.68%	90.84%	138800	109200	54600	163800	20000	5000	25000	138800
18	IF2300195882	12/26/2023	B Shift	3	20		1RESDW	263200	131600	394800	2000	1000	3000	261200	130600	99.24%	99.24%	391800	263200	131600	394800	2000	1000	3000	391800
19	IF2300184991	12/5/2023	C Shift	3	22	S Ross	1RESDW	200000	0	200000	1000	0	1000	199000	0	99.50%	0.00%	199000	71200	35600	106800	356	35600	35956	70844
20	IF2300195178	12/24/2023	A Shift	6	23		1APARTW	400000	50000	450000	25000	10000	35000	375000	40000	93.75%	80.00%	415000	400000	50000	450000	25000	10000	35000	415000
21	IF2300184432	12/4/2023	B Shift	3	8		1RESDW	167500	80000	247500	75000	45000	120000	92500	35000	55.22%	43.75%	127500	167500	83750	251250	75000	47109	122109	129141
22	IF2300187819	12/11/2023	C Shift	3	24		1APARTW	168500	0	168500	20000	0	20000	148500	0	88.13%	0.00%	148500	168500	0	168500	20000	0	20000	148500
23	IF2300198856	12/31/2023	B Shift	3	24		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
24	IF2300197885	12/29/2023	C Shift	3	25		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
25	IF2300186395	12/8/2023	C Shift	6	26		1RESDW	295600	147800	443400	73900	36950	110850	221700	110850	75.00%	75.00%	332550	295600	147800	443400	73900	36950	110850	332550
26	IF2300189838	12/15/2023	C Shift	6	26		1RESDW	242500	121250	363750	230375	115187	345562	12125	6063	5.00%	5.00%	18188	242500	121250	363750	230375	115187	345562	18188
27	IF2300195319	12/25/2023	A Shift	6	26		1RESDW	290400	145200	435600	150000	50000	200000	140400	95200	48.35%	65.56%	235600	290400	145200	435600	150000	50000	200000	235600
28	IF2300196644	12/27/2023	A Shift	6	26		1APARTW	150000	20000	170000	20000	3000	23000	130000	17000	86.67%	85.00%	147000	150000	20000	170000	20000	3000	23000	147000
29	IF2300188866	12/13/2023	A Shift	5	27		1DBLRESW	76000	2500	78500	60000	2500	62500	16000	0	21.05%	0.00%	16000	76000	2500	78500	60000	2500	62500	16000
30	IF2300195168	12/24/2023	A Shift	5	27		1DBLRESW	135800	0	135800	1000	0	1000	134800	0	99.26%	0.00%	134800	135800	0	135800	1000	0	1000	134800
31	IF2300183746	12/3/2023	A Shift	5	29		1RESDW	89300	20000	109300	9000	2500	11500	80300	17500	89.92%	87.50%	97800	89300	20000	109300	9000	2500	11500	97800
32	IF2300186001	12/7/2023	B Shift	5	3		1DBLRESW	137000	68500	205500	10000	10000	20000	127000	58500	92.70%	85.40%	185500	137000	68500	205500	10000	10000	20000	185500
33	IF2300186263	12/8/2023	B Shift	5	3		1DBLRESW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2300191341	12/17/2023	C Shift	1	30	K Bacon	1APARTW	4818500	2409250	7227750	200000	100000	300000	4618500	2309250	95.85%	95.85%	6927750	283441	141720.5	425161.5	11765	5882	17647	407514
35	IF2300192903	12/20/2023	C Shift	1	30		1RESDW	112000	56000	168000	22400	2800	25200	89600	53200	80.00%	95.00%	142800	112900	56450	169350	22580	2823	25403	143948
36	IF2300185768	12/7/2023	B Shift	1	33		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
37	IF2300190714	12/16/2023	B Shift	1	33	C Ashby	1RESDW	0	0	0	10000	1000	11000	-10000	-1000	0.00%	0.00%	-11000	108900	54450	163350	108900	54450	163350	0
38	IF2300185364	12/6/2023	A Shift	6	35		1BUILDW	1000000	0	1000000	1000	0	1000	999000	0	99.90%	0.00%	999000		0	0	0	0	0	0
39	IF2300191484	12/18/2023	C Shift	6	35		1RESDW	237100	118550	355650	189680	94840	284520	47420	23710	20.00%	20.00%	71130	237100	118550	355650	189680	94840	284520	71130
40	IF2300198915	12/31/2023	B Shift	2	L36	Not Imported/ BC02	1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
41	IF2300191047	12/17/2023	B Shift	4	41		1RESDW	187500	93750	281250	28125	10000	38125	159375	83750	85.00%	89.33%	243125	187500	93750	281250	28125	10000	38125	243125
42	IF2300182777	12/1/2023	B Shift	4	55	T Waldroup	1RESDW	153200	10000	163200	10000	10000	20000	143200	0	93.47%	0.00%	143200	153200	76600	229800	10000	76600	86600	143200
43	IF2300184790	12/5/2023	C Shift	4	55		1DBLRESW	201400	100700	302100	50350	45315	95665	151050	55385	75.00%	55.00%	206435	201400	100700	302100	50350	45315	95665	206435
44	IF2300194325	12/23/2023	B Shift	4	44		1BUILDW	263000	131600	394600	85540	78960	164500	177460	52640	67.48%	40.00%	230100		0	0	0	0	0	0
45	IF2300192656	12/20/2023	B Shift	4	45		1RESDW	163200	60000	223200	159120	55000	214120	4080	5000	2.50%	8.33%	9080	163200	81600	244800	159120	74800	233920	10880
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