08_Aug_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	IF2200119795	8/11/2022	B Shift	1	4		1APARTW	78000	39000	117000	3900	1900	5800	74100	37100	95.00%	95.13%	111200	78000	39000	117000	3900	1900	5800	111200
3	IF2200130198	8/30/2022	C Shift	2	21		1RESDW	265300	132650	397950	13625	6632	20257	251675	126018	94.86%	95.00%	377693	265300	132650	397950	13625	6632	20257	377693
4	IF2200120109	8/12/2022	C Shift	1	4	D. Taylor	1APARTW	2365500	50000	2415500	2000000	50000	2050000	365500	0	15.45%	0.00%	365500	607820	303910	911730	513904	303910	817814	93916
5	IF2200114325	8/2/2022	B Shift	1	12		1RESDW	252300	126150	378450	227070	113535	340605	25230	12615	10.00%	10.00%	37845	252300	126150	378450	227070	113535	340605	37845
6	IF2200128246	8/27/2022	B Shift	1	31		1BUILDW	111000	55500	166500	15000	10000	25000	96000	45500	86.49%	81.98%	141500	111000	55500	166500	15000	10000	25000	141500
7	IF2200116514	8/6/2022	B Shift	1	31		1RESDW	56200	26300	82500	7890	3945	11835	48310	22355	85.96%	85.00%	70665	56200	28100	84300	7890	4215	12105	72195
8	IF2200127099	8/25/2022	C Shift	3	22		1RESDW	88000	44000	132000	70000	40000	110000	18000	4000	20.45%	9.09%	22000	88000	44000	132000	70000	40000	110000	22000
9	IF2200115899	8/5/2022	A Shift	2	17	A Thomas	1APARTW	300000	35000	335000	40000	20000	60000	260000	15000	86.67%	42.86%	275000	300000	150000	450000	40000	85714	125714	324286
10	IF2200124034	8/19/2022	A Shift	4	2	K McCourt	1RESDW	81800	4000	85800	3000	200	3200	78800	3800	96.33%	95.00%	82600	81800	40900	122700	3000	2045	5045	117655
11	IF2200118424	8/9/2022	C Shift	4	44		1BUILDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
12	IF2200117613	8/8/2022	A Shift	3	10		1RESDW	84600	1000	85600	45000	1000	46000	39600	0	46.81%	0.00%	39600	84600	1000	85600	45000	1000	46000	39600
13	IF2200126469	8/24/2022	B Shift	3	22		1RESDW	54100	27050	81150	40575	20287	60862	13525	6763	25.00%	25.00%	20288	54100	27050	81150	40575	20287	60862	20288
14	IF2200113597	8/1/2022	A Shift	1	5	S Olofson	1DBLRESW	60000	4000	64000	25000	1500	26500	35000	2500	58.33%	62.50%	37500	128300	64150	192450	53458	24056	77515	114935
15	IF2200119655	8/11/2022	B Shift	3	20		1DBLRESW	133400	66700	200100	20000	0	20000	113400	66700	85.01%	100.00%	180100	133400	66700	200100	20000	0	20000	180100
16	IF2200126784	8/24/2022	C Shift	5	27		1RESDW	84800	48400	133200	25000	15000	40000	59800	33400	70.52%	69.01%	93200	84800	42400	127200	25000	13140	38140	89060
17	IF2200122251	8/16/2022	A Shift	1	5	S Olofson	1RESDW	77900	3000	80900	30000	2000	32000	47900	1000	61.49%	33.33%	48900	77900	38950	116850	30000	25967	55967	60883
18	IF2200117069	8/7/2022	C Shift	3	20		1RESDW	95500	0	95500	10000	0	10000	85500	0	89.53%	0.00%	85500	95400	0	95400	9990	0	9990	85410
19	IF2200127590	8/26/2022	A Shift	5	27		1DBLRESW	50600	1000	51600	30000	1000	31000	20600	0	40.71%	0.00%	20600	50600	1000	51600	30000	1000	31000	20600
20	IF2200130329	8/30/2022	C Shift	5	27		1RESDW	40000	3000	43000	250	250	500	39750	2750	99.38%	91.67%	42500	48000	3000	51000	300	250	550	50450
21	IF2200123071	8/17/2022	B Shift	5	27		1RESDW	108400	0	108400	21580	0	21580	86820	0	80.09%	0.00%	86820	108400	0	108400	21580	0	21580	86820
22	IF2200127483	8/25/2022	A Shift	3	20	K Witt	1APARTW	0	3000	3000	0	3000	3000	0	0	0.00%	0.00%	0	633350	316675	950025	633350	316675	950025	0
23	IF2200122214	8/16/2022	A Shift	5	3	E Hofmeister	1RESDW	185800	15000	200800	25000	5000	30000	160800	10000	86.54%	66.67%	170800	155800	77900	233700	20963	25967	46930	186770
24	IF2200119966	8/12/2022	C Shift	5	3		1DBLRESW	62700	32000	94700	60000	25000	85000	2700	7000	4.31%	21.88%	9700	62700	31350	94050	60000	24492	84492	9558
25	IF2200127104	8/25/2022	C Shift	5	15		1APARTW	888500	445000	1333500	100000	25000	125000	788500	420000	88.75%	94.38%	1208500	888500	444250	1332750	100000	24958	124958	1207792
26	IF2200127133	8/25/2022	C Shift	5	29	K Witt	1RESDW	102000	30000	132000	2500	1000	3500	99500	29000	97.55%	96.67%	128500	102000	51000	153000	2500	1700	4200	148800
27	IF2200129113	8/28/2022	A Shift	5	29	E Hofmeister	1RESDW	120000	10000	130000	25000	5000	30000	95000	5000	79.17%	50.00%	100000	68100	34050	102150	14188	17025	31213	70938
28	IF2200122507	8/16/2022	A Shift	3	24		1RESDW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
29	IF2200119642	8/11/2022	B Shift	4	44	C Ashby	1APARTW	1000000	100000	1100000	250000	25000	275000	750000	75000	75.00%	75.00%	825000	208800	104400	313200	52200	26100	78300	234900
30	IF2200115331	8/4/2022	C Shift	4	44	G Randolph	1APARTW	11485900	6000	11491900	40000	5000	45000	11445900	1000	99.65%	16.67%	11446900	208800	104400	313200	727	87000	87727	225473
31	IF2200124997	8/21/2022	C Shift	4	45		1RESDW	123500	0	123500	24700	0	24700	98800	0	80.00%	0.00%	98800	123500	0	123500	24700	0	24700	98800
32	IF2200122971	8/17/2022	B Shift	4	41		1SCHOOLW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
33	IF2200122967	8/17/2022	B Shift	4	41		1BARNW			0			0	0	0	0.00%	0.00%	0		0	0	0	0	0	0
34	IF2200118226	8/9/2022	B Shift	4	42	C Ashby	1RESDW	298000	37260	335260	298000	7450	305450	0	29810	0.00%	80.01%	29810	298000	149000	447000	298000	29792	327792	119208
35	IF2200115308	8/4/2022	C Shift	7	13	K Jones	1APARTHW	35355200	5000	35360200	60000	5000	65000	35295200	0	99.83%	0.00%	35295200	35355200	17677600	53032800	60000	17677600	17737600	35295200
36
37
38
39
40
41
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