10_Oct_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	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	IF2200147195	10/1/2022	B Shift	2	6	D Hayden	1BUILDHW	3400000	500000	3900000	1000000	250000	1250000	2400000	250000	70.59%	50.00%	2650000	7115600	3557800	10673400	2092824	1778900	3871724	6801676
3	IF2200147327	10/2/2022	B Shift	2	28		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
4	IF2200147365	10/2/2022	B Shift	7	19		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
5	IF2200147464	10/2/2022	C Shift	4	43	D Dixon	1APARTW	91000	15000	106000	13650	2275	15925	77350	12725	85.00%	84.83%	90075	467425	233713	701138	70114	35446	105560	595577
6	IF2200147959	10/3/2022	A Shift	3	25	J. Bowman	1RESDW	196000	20000	216000	80000	10000	90000	116000	10000	59.18%	50.00%	126000	196000	98000	294000	80000	49000	129000	165000
7	IF2200148198	10/3/2022	A Shift	4	2		1APARTEW	791800	10000	801800	15000	0	15000	776800	10000	98.11%	100.00%	786800	791800	10000	801800	15000	0	15000	786800
8	IF2200149487	10/5/2022	C Shift	4	45		1APARTW	1000000	500000	1500000	500000	150000	650000	500000	350000	50.00%	70.00%	850000	1000000	500000	1500000	500000	150000	650000	850000
9	IF2200150006	10/6/2022	A Shift	5	15		1RESDW	116000	58000	174000	11600	2900	14500	104400	55100	90.00%	95.00%	159500	116000	58000	174000	11600	2900	14500	159500
10	IF2200150199	10/7/2022	B Shift	2	6		1APARTW	316950	158475	475425	47542	15847	63389	269408	142628	85.00%	90.00%	412036	316950	158475	475425	47542	15847	63389	412036
11	IF2200150308	10/7/2022	B Shift	6	35		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
12	IF2200150640	10/8/2022	B Shift	1	5	C Ashby	1RESDW	79800	10000	89800	35000	5000	40000	44800	5000	56.14%	50.00%	49800	79800	39900	119700	35000	19950	54950	64750
13	IF2200151125	10/9/2022	C Shift	5	29		1RESDW	71400	36000	107400	50000	20000	70000	21400	16000	29.97%	44.44%	37400	71400	35700	107100	50000	19833	69833	37267
14	IF2200151448	10/9/2022	A Shift	1	12		1RESDW	192900	96450	289350	42900	31200	74100	150000	65250	77.76%	67.65%	215250	192900	96450	289350	42900	31200	74100	215250
15	IF2200151747	10/10/2022	B Shift	4	2		1RESDW	84700	40000	124700	20000	6000	26000	64700	34000	76.39%	85.00%	98700	84700	42350	127050	20000	6353	26353	100698
16	IF2200152138	10/11/2022	B Shift	3	20		1DBLRESW	133400	66700	200100	100000	40000	140000	33400	26700	25.04%	40.03%	60100	133400	66700	200100	100000	40000	140000	60100
17	IF2200152417	10/11/2022	C Shift	5	29		1RESDW	76200	38000	114200	50000	25000	75000	26200	13000	34.38%	34.21%	39200	76200	38100	114300	50000	25066	75066	39234
18	IF2200152441	10/11/2022	C Shift	6	34		1RESDW	150000	0	150000	7500	0	7500	142500	0	95.00%	0.00%	142500	150000	0	150000	7500	0	7500	142500
19	IF2200152649	10/12/2022	C Shift	5	11		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
20	IF2200152672	10/12/2022	C Shift	5	11		1BUILDW	60800	0	60800	5000	0	5000	55800	0	91.78%	0.00%	55800	60800	0	60800	5000	0	5000	55800
21	IF2200153168	10/12/2022	A Shift	5	29		1RESDW	113600	65000	178600	50000	15000	65000	63600	50000	55.99%	76.92%	113600	113600	56800	170400	50000	13108	63108	107292
22	IF2200153642	10/13/2022	B Shift	5	29		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
23	IF2200153692	10/13/2022	B Shift	4	44		1RESDW	96100	48050	144150	12013	2400	14413	84087	45650	87.50%	95.01%	129737	96100	48050	144150	12013	2400	14413	129737
24	IF2200153719	10/14/2022	B Shift	3	25		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
25	IF2200154059	10/14/2022	C Shift	6	23		1APARTW	150000	0	150000	3000	0	3000	147000	0	98.00%	0.00%	147000	150000	0	150000	3000	0	3000	147000
26	IF2200154191	10/14/2022	C Shift	4	43		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
27	IF2200154678	10/15/2022	A Shift	4	2		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
28	IF2200154888	10/16/2022	B Shift	5	3		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
29	IF2200155861	10/18/2022	A Shift	3	10		1RESDEW	58500	15000	73500	25000	5000	30000	33500	10000	57.26%	66.67%	43500	58500	15000	73500	25000	5000	30000	43500
30	IF2200156333	10/19/2022	A Shift	5	29		1RESDW	50000	10000	60000	50000	10000	60000	0	0	0.00%	0.00%	0	50000	10000	60000	50000	10000	60000	0
31	IF2200156551	10/19/2022	B Shift	5	3		1RESDW	103000	0	103000	20000	0	20000	83000	0	80.58%	0.00%	83000	103000	0	103000	20000	0	20000	83000
32	IF2200156560	10/19/2022	B Shift	6	23		1APARTW	4197400	1000000	5197400	1500	1000	2500	4195900	999000	99.96%	99.90%	5194900	4197400	1000000	5197400	1500	1000	2500	5194900
33	IF2200157314	10/21/2022	C Shift	4	44		1RESDW	76800	36400	113200	50000	20000	70000	26800	16400	34.90%	45.05%	43200	76800	38400	115200	50000	21099	71099	44101
34	IF2200157583	10/21/2022	A Shift	3	20	A Thomas	1RESDW	130000	8000	138000	60000	2000	62000	70000	6000	53.85%	75.00%	76000	112400	56200	168600	51877	14050	65927	102673
35	IF2200157841	10/22/2022	A Shift	4	41	J Bowman	1APARTEW	158800	11910	170710	0	0	0	158800	11910	100.00%	100.00%	170710	218000	109000	327000	0	0	0	327000
36	IF2200157852	10/22/2022	A Shift	5	3		1RESDEW	97100	20000	117100	40000	5000	45000	57100	15000	58.81%	75.00%	72100	97100	20000	117100	40000	5000	45000	72100
37	IF2200157944	10/22/2022	A Shift	1	14		1BUILDW	20000	0	20000	15000	0	15000	5000	0	25.00%	0.00%	5000	15500	0	15500	11625	0	11625	3875
38	IF2200158502	10/23/2022	B Shift	4	45	T Waldroup	1APARTW	2456700	5000	2461700	20000	1000	21000	2436700	4000	99.19%	80.00%	2440700	307087	153544	460631	2500	30709	33209	427422
39	IF2200158862	10/23/2022	C Shift	1	33		1APARTEW	80000	400000	480000	40000	200000	240000	40000	200000	50.00%	50.00%	240000	38300	153544	191844	19150	76772	95922	95922
40	IF2200159206	10/24/2022	A Shift	4	45	P McCrary	1APARTW	2718000	7000	2725000	30000	5000	35000	2688000	2000	98.90%	28.57%	2690000	90600	45300	135900	1000	32357	33357	102543
41	IF2200159309	10/24/2022	A Shift	5	29	R Pool	1BUILDW	150000	15000	165000	1000	2000	3000	149000	13000	99.33%	86.67%	162000	47600	23800	71400	317	3173	3491	67909
42	IF2200159561	10/25/2022	A Shift	3	25		1RESDW	83900	41950	125850	12585	2000	14585	71315	39950	85.00%	95.23%	111265	83900	41950	125850	12585	2000	14585	111265
43	IF2200159572	10/25/2022	A Shift	5	11		1BUILDW	107000	5000	112000	107000	5000	112000	0	0	0.00%	0.00%	0	107000	5000	112000	107000	5000	112000	0
44	IF2200159619	10/25/2022	A Shift	5	11		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
45	IF2200160304	10/26/2022	C Shift	5	11		1RESDW	79900	40000	119900	25000	15000	40000	54900	25000	68.71%	62.50%	79900	79900	39950	119850	25000	14981	39981	79869
46	IF2200161033	10/27/2022	A Shift	7	1		1DBLRESW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
47	IF2200161701	10/29/2022	B Shift	1	4		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
48	IF2200161739	10/29/2022	B Shift	1	4		1RESDW	350000	10000	360000	10000	2000	12000	340000	8000	97.14%	80.00%	348000	201400	100700	302100	5754	20140	25894	276206
49	IF2200161868	10/29/2022	C Shift	3	10		1RESDW	46900	35000	81900	25000	23450	48450	21900	11550	46.70%	33.00%	33450	46900	23450	70350	25000	15712	40712	29639
50	IF2200162047	10/29/2022	C Shift	5	27		1RESDEW	72800	0	72800	50000	0	50000	22800	0	31.32%	0.00%	22800	72800	0	72800	50000	0	50000	22800
51	IF2200162262	10/30/2022	C Shift	5	27		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
52	IF2200162759	10/31/2022	A Shift	5	3		1RESDW	120700	60350	181050	120700	60350	181050	0	0	0.00%	0.00%	0	120700	60350	181050	120700	60350	181050	0
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