03_Mar_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	IF2300029817	3/1/2023	B Shift	5	27		1RESDW	121600	0	121600	6080	0	6080	115520	0	95.00%	0.00%	115520	121600	0	121600	6080	0	6080	115520
3	IF2300029974	3/1/2023	C Shift	6	34	Jackson	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
4	IF2300030995	3/3/2023	B Shift	5	27		1RESDW	116300	58150	174450	8722	2907	11629	107578	55243	92.50%	95.00%	162821	116300	58150	174450	8722	2907	11629	162821
5	IF2300031403	3/4/2023	B Shift	3	20	Culver	1APARTEW	2831300	141565	2972865	141565	70782	212347	2689735	70783	95.00%	50.00%	2760518	2831300	1415650	4246950	141565	707820	849385	3397565
6	IF2300031652	3/4/2023	C Shift	4	43		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
7	IF2300031900	3/5/2023	C Shift	5	27		1RESDW	127500	65000	192500	10000	6000	16000	117500	59000	92.16%	90.77%	176500	121600	60800	182400	9537	5612	15150	167250
8	IF2300032377	3/6/2023	A Shift	1	14		1RESDW	80000	2200	82200	10000	1000	11000	70000	1200	87.50%	54.55%	71200	91500	2200	93700	11438	1000	12438	81263
9	IF2300032426	3/6/2023	A Shift	5	11		1RESDW	30000	0	30000	10000	0	10000	20000	0	66.67%	0.00%	20000	44000	0	44000	14667	0	14667	29333
10	IF2300032445	3/6/2023	A Shift	5	11		1BUILDW	121000	60500	181500	121000	10000	131000	0	50500	0.00%	83.47%	50500	121000	60500	181500	121000	10000	131000	50500
11	IF2300032819	3/6/2023	B Shift	5	27		1RESDW	137300	0	137300	13730	0	13730	123570	0	90.00%	0.00%	123570	137300	0	137300	13730	0	13730	123570
12	IF2300033606	3/8/2023	A Shift	5	11	Pool	1APARTEW	99500	1000	100500	5000	1000	6000	94500	0	94.97%	0.00%	94500	99500	49750	149250	5000	49750	54750	94500
13	IF2300033944	3/8/2023	A Shift	1	4	Acoff	1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
14	IF2300034051	3/9/2023	A Shift	3	10	Grass	1RESDW	93900	12000	105900	25000	6000	31000	68900	6000	73.38%	50.00%	74900	93900	46950	140850	25000	23475	48475	92375
15	IF2300034315	3/9/2023	B Shift	1	4		1RESDW	275400	137700	413100	13770	6885	20655	261630	130815	95.00%	95.00%	392445	275400	137700	413100	13770	6885	20655	392445
16	IF2300034458	3/9/2023	B Shift	1	14	Ashby	1RESDEW	100000	50000	150000	75000	15000	90000	25000	35000	25.00%	70.00%	60000	69300	34650	103950	51975	10395	62370	41580
17	IF2300034729	3/10/2023	C Shift	3	22		1RESDW	51000	0	51000	10000	0	10000	41000	0	80.39%	0.00%	41000	51600	0	51600	10118	0	10118	41482
18	IF2300035080	3/11/2023	C Shift	5	11		1RESDW	48000	25000	73000	25000	5000	30000	23000	20000	47.92%	80.00%	43000	48800	24400	73200	25417	4880	30297	42903
19	IF2300035118	3/11/2023	C Shift	1	14		1APARTW	20000	10000	30000	10000	10000	20000	10000	0	50.00%	0.00%	10000	113800	56900	170700	56900	56900	113800	56900
20	IF2300036308	3/13/2023	C Shift	1	5		1RESDW	61800	5000	66800	5000	1000	6000	56800	4000	91.91%	80.00%	60800	61800	5000	66800	5000	1000	6000	60800
21	IF2300036436	3/13/2023	C Shift	5	29		1RESDW	68400	35000	103400	30000	15000	45000	38400	20000	56.14%	57.14%	58400	68400	34200	102600	30000	14657	44657	57943
22	IF2300037105	3/15/2023	A Shift	5	27		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
23	IF2300037545	3/16/2023	B Shift	4	41	Jenkins	1BUILDW	2399000	30000	2429000	30000	30000	60000	2369000	0	98.75%	0.00%	2369000		0	0	0	0	0	0
24	IF2300038059	3/16/2023	C Shift	4	44		1BUILDW	886300	441350	1327650	44315	22000	66315	841985	419350	95.00%	95.02%	1261335	886300	443150	1329450	44315	22090	66405	1263045
25	IF2300038148	3/17/2023	C Shift	3	10		1RESDW	20000	0	20000	15000	0	15000	5000	0	25.00%	0.00%	5000	65800	32900	98700	49350	32900	82250	16450
26	IF2300038909	3/18/2023	B Shift	1	33		1BUILDW	475700	50000	525700	100000	20000	120000	375700	30000	78.98%	60.00%	405700	475700	50000	525700	100000	20000	120000	405700
27	IF2300038996	3/18/2023	B Shift	7	1	Kesterson	1DBLRESW	111100	30000	141100	55000	30000	85000	56100	0	50.50%	0.00%	56100	111100	55550	166650	55000	55550	110550	56100
28	IF2300039310	3/19/2023	C Shift	3	20		1BUILDEW	1527100	0	1527100	20000	0	20000	1507100	0	98.69%	0.00%	1507100	1527100	0	1527100	20000	0	20000	1507100
29	IF2300039549	3/19/2023	C Shift	2	32		1RESDW	321000	160500	481500	20000	0	20000	301000	160500	93.77%	100.00%	461500	321700	160850	482550	20044	0	20044	462506
30	IF2300039609	3/20/2023	C Shift	3	24		1APARTW	50000	25000	75000	17500	6250	23750	32500	18750	65.00%	75.00%	51250	50000	25000	75000	17500	6250	23750	51250
31	IF2300039636	3/20/2023	C Shift	3	24		1APARTW	50000	25000	75000	5000	0	5000	45000	25000	90.00%	100.00%	70000	50000	25000	75000	5000	0	5000	70000
32	IF2300039863	3/20/2023	A Shift	6	23		1APARTW	500000	80000	580000	250000	20000	270000	250000	60000	50.00%	75.00%	310000	500000	80000	580000	250000	20000	270000	310000
33	IF2300039884	3/20/2023	A Shift	3	8		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2300040139	3/21/2023	A Shift	2	32		1RESDW	313200	101790	414990	78300	23490	101790	234900	78300	75.00%	76.92%	313200	313200	156600	469800	78300	36138	114438	355362
35	IF2300040308	3/21/2023	B Shift	7	13	Kesterson	1APARTW	397200	10000	407200	5000	2000	7000	392200	8000	98.74%	80.00%	400200	397200	198600	595800	5000	39720	44720	551080
36	IF2300040756	3/22/2023	C Shift	5	15		1BUILDW	300200	160000	460200	75000	25000	100000	225200	135000	75.02%	84.38%	360200	300200	150100	450300	75000	23453	98453	351847
37	IF2300041061	3/22/2023	C Shift	5	27		1RESDW	138500	70000	208500	1000	500	1500	137500	69500	99.28%	99.29%	207000	138500	69250	207750	1000	495	1495	206255
38	IF2300041643	3/23/2023	A Shift	5	15		1RESDW	79100	30000	109100	59325	15000	74325	19775	15000	25.00%	50.00%	34775	79100	39550	118650	59325	19775	79100	39550
39	IF2300041672	3/24/2023	A Shift	3	22	Grass	1RESDW	80000	16000	96000	16000	4000	20000	64000	12000	80.00%	75.00%	76000	80000	40000	120000	16000	10000	26000	94000
40	IF2300041863	3/24/2023	B Shift	7	7	Callahan	1BUILDHW	50000000	2000000	52000000	5000000	500000	5500000	45000000	1500000	90.00%	75.00%	46500000		0	0	0	0	0	0
41	IF2300042041	3/24/2023	B Shift	1	14		1RESDW	93900	46950	140850	32865	18780	51645	61035	28170	65.00%	60.00%	89205	93900	46950	140850	32865	18780	51645	89205
42	IF2300042371	3/25/2023	C Shift	7	18	Taylor	1BUILDW	228000	0	228000	30000	0	30000	198000	0	86.84%	0.00%	198000	91400	0	91400	12026	0	12026	79374
43	IF2300042458	3/25/2023	C Shift	7	18	Taylor	1BUILDW	250000	0	250000	10000	0	10000	240000	0	96.00%	0.00%	240000	91400	0	91400	3656	0	3656	87744
44	IF2300043135	3/26/2023	A Shift	5	29		1BUILDW	48700	0	48700	200	0	200	48500	0	99.59%	0.00%	48500	48700	0	48700	200	0	200	48500
45	IF2300043347	3/27/2023	A Shift	6	23		1APARTW	350000	175000	525000	100	100	200	349900	174900	99.97%	99.94%	524800	350000	175000	525000	100	100	200	524800
46	IF2300044021	3/28/2023	C Shift	1	30		1RESDW	101000	50000	151000	50000	50000	100000	51000	0	50.50%	0.00%	51000	101700	50850	152550	50347	50850	101197	51353
47	IF2300044609	3/29/2023	A Shift	5	56		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
48	IF2300044612	3/29/2023	A Shift	1	30		1RESDW	66375	26500	92875	39825	26500	66325	26550	0	40.00%	0.00%	26550	64900	32450	97350	38940	32450	71390	25960
49	IF2300045096	3/30/2023	B Shift	2	9		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
50	IF2300045605	3/31/2023	C Shift	5	29		1RESDW	100000	50000	150000	20000	5000	25000	80000	45000	80.00%	90.00%	125000	100000	50000	150000	20000	5000	25000	125000
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