05_May_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	IF2300071854	5/19/2023	A Shift	1	14		1RESDW	386000	193000	579000	193000	96500	289500	193000	96500	50.00%	50.00%	289500	386000	193000	579000	193000	96500	289500	289500
3	IF2300065416	5/7/2023	A Shift	3	10		1RESDW	51300	17955	69255	12825	5130	17955	38475	12825	75.00%	71.43%	51300	51300	25650	76950	12825	7329	20154	56796
4	IF2300072416	5/20/2023	B Shift	3	22		1RESDW	37000	18500	55500	3700	1850	5550	33300	16650	90.00%	90.00%	49950	37000	18500	55500	3700	1850	5550	49950
5	IF2300069201	5/14/2023	B Shift	5	3		1RESDW	81300	40650	121950	20000	40650	60650	61300	0	75.40%	0.00%	61300	81300	40650	121950	20000	40650	60650	61300
6	IF2300075909	5/26/2023	B Shift	5	15		1BUILDW	133000	66500	199500	120000	66500	186500	13000	0	9.77%	0.00%	13000	133000	66500	199500	120000	66500	186500	13000
7	IF2300069344	5/14/2023	B Shift	7	19		1BUILDW	681300	100000	781300	5000	2000	7000	676300	98000	99.27%	98.00%	774300	681300	340650	1021950	5000	6813	11813	1010137
8	IF2300068715	5/13/2023	A Shift	3	22		1RESDW	59700	29850	89550	53730	25372	79102	5970	4478	10.00%	15.00%	10448	59700	29850	89550	53730	25372	79102	10448
9	IF2300063403	5/4/2023	C Shift	6	23		1BUILDW	543500	271750	815250	2000	13587	15587	541500	258163	99.63%	95.00%	799663	543500	271750	815250	2000	13587	15587	799663
10	IF2300072221	5/20/2023	A Shift	2	28		1RESDEW	610200	305000	915200	305100	152500	457600	305100	152500	50.00%	50.00%	457600	610200	305100	915300	305100	152550	457650	457650
11	IF2300062463	5/2/2023	B Shift	5	3		1RESDW	190900	95450	286350	100000	20000	120000	90900	75450	47.62%	79.05%	166350	190900	95450	286350	100000	20000	120000	166350
12	IF2300064227	5/5/2023	B Shift	1	33		1RESDW	129500	64750	194250	40000	20000	60000	89500	44750	69.11%	69.11%	134250	129500	64750	194250	40000	20000	60000	134250
13	IF2300073790	5/23/2023	A Shift	4	41		1APARTW	300000	12500	312500	25000	12500	37500	275000	0	91.67%	0.00%	275000	300000	12500	312500	25000	12500	37500	275000
14	IF2300064045	5/5/2023	B Shift	4	55		1BUILDW	165300	82650	247950	150000	60000	210000	15300	22650	9.26%	27.40%	37950	165300	82650	247950	150000	60000	210000	37950
15	IF2300066991	5/10/2023	A Shift	4	42		1RESDW	210500	105250	315750	63150	31575	94725	147350	73675	70.00%	70.00%	221025	210500	105250	315750	63150	31575	94725	221025
16	IF2300078272	5/31/2023	A Shift	4	42		1RESDW	271400	135500	406900	70000	80000	150000	201400	55500	74.21%	40.96%	256900	271400	135700	407100	70000	80118	150118	256982
17	IF2300072201	5/20/2023	A Shift	4	43		1APARTW	201000	12000	213000	24000	12000	36000	177000	0	88.06%	0.00%	177000	201000	12000	213000	24000	12000	36000	177000
18	IF2300071222	5/18/2023	C Shift	4	44		1APARTW	120000	60000	180000	18000	9000	27000	102000	51000	85.00%	85.00%	153000	120000	60000	180000	18000	9000	27000	153000
19	IF2300065113	5/7/2023	C Shift	6	53		1RESDW	182100	91050	273150	9105	4552	13657	172995	86498	95.00%	95.00%	259493	182100	91050	273150	9105	4552	13657	259493
20	IF2300065127	5/7/2023	C Shift	4	55		1RESDW	380400	190200	570600	100000	57060	157060	280400	133140	73.71%	70.00%	413540	380400	190200	570600	100000	57060	157060	413540
21	IF2300073692	5/22/2023	A Shift	7	1		1RESDW	59700	0	59700	26865	0	26865	32835	0	55.00%	0.00%	32835	59700	0	59700	26865	0	26865	32835
22	IF2300072544	5/20/2023	B Shift	1	4		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
23	IF2300066832	5/10/2023	A Shift	1	5	S. Olofson	1RESDW	50000	10000	60000	50000	10000	60000	0	0	0.00%	0.00%	0	116000	58000	174000	116000	58000	174000	0
24	IF2300074680	5/24/2023	C Shift	7	7	D Taylor	1RESDW	32400	10000	42400	5000	4000	9000	27400	6000	84.57%	60.00%	33400	225400	112700	338100	34784	45080	79864	258236
25	IF2300071067	5/18/2023	B Shift	3	8		1APARTEW	3000000	0	3000000	5000	0	5000	2995000	0	99.83%	0.00%	2995000		0	0	0	0	0	0
26	IF2300061917	5/1/2023	C Shift	5	11	L Sayre	1RESDW	80000	80000	160000	10000	40000	50000	70000	40000	87.50%	50.00%	110000	119500	59750	179250	14938	29875	44813	134438
27	IF2300076012	5/27/2023	B Shift	5	11		1RESDW	20000	10000	30000	20000	10000	30000	0	0	0.00%	0.00%	0		0	0	0	0	0	0
28	IF2300076440	5/27/2023	C Shift	5	27		1DBLRESW	120400	0	120400	60200	0	60200	60200	0	50.00%	0.00%	60200	120400	0	120400	60200	0	60200	60200
29	IF2300064439	5/5/2023	B Shift	3	20		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
30	IF2300075326	5/25/2023	A Shift	2	21		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
31	IF2300070751	5/17/2023	B Shift	3	22		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
32	IF2300071342	5/18/2023	C Shift	3	22	J Marsh	1DBLRESW	250000	4000	254000	10000	2500	12500	240000	1500	96.00%	37.50%	241500	141500	70750	212250	5660	44219	49879	162371
33	IF2300064645	5/6/2023	B Shift	3	24		1BUILDW	503900	0	503900	150000	0	150000	353900	0	70.23%	0.00%	353900	503900	0	503900	150000	0	150000	353900
34	IF2300064901	5/6/2023	C Shift	3	24		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
35	IF2300077804	5/30/2023	C Shift	6	26		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
36	IF2300077189	5/29/2023	B Shift	1	31		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
37	IF2300065568	5/7/2023	A Shift	6	34		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
38	IF2300073479	5/22/2023	A Shift	6	34		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
39	IF2300073194	5/22/2023	C Shift	6	35		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
40	IF2300078280	5/31/2023	A Shift	4	44		1APARTW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
41	IF2300069049	5/14/2023	B Shift	6	53	J McNair	1RESDW	195000	50000	245000	25000	20000	45000	170000	30000	87.18%	60.00%	200000	195000	97500	292500	25000	39000	64000	228500
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